How to get random numbers random(0xff) ?
int RandomNumber = (rand() * 0xff) / RAND_MAX;
"]GHO[" <firstname.lastname@example.org> skrev i en meddelelse
> How to get random numbers random(0xff) ?
rnd() & 0xff;
On Tue, 11 Nov 2003 04:07:13 -0800, "]GHO[" <email@example.com> wrote:
>How to get random numbers random(0xff) ?
...Random Numbers not Random
When I create random numbers for an application with the following code, they
do not appear to be truely random.
Me.RandomNumber = Int(9 * Rnd + 1) ' Random Number 1-9
If I have two users setting side by side, they frequently get the same
results when they start up
Am I missing somthing?
Any help would be appreciated
Have you tried a
statement just before the RND?
That should do it.
Microsoft Access MVP
"Find a job tha...Sorting Data that feeds into other formulas....
I have a workbook (Excel 2003) and I am having trouble with a particular
sorting issue. On page 2, column GL contains specific data that feeds into
formulas used in Page 1. When I sort my data on page 2 it changes the
formula totals on page 1.
What I want to do is have the ability to 'lock' the data on page 2 so that
after I sort it doesn't change the totals in my formulas using the Page 2
For example on Page 1, one of my cells reads the following formula:
='Rep Stack Ranking'!GL$12+'Rep Stack Ranking'!GL$13+'Rep Stack
Rank...How can I edit cell contents with a macro in Excel? #2
I'm trying to creat an Excel macro that edits cell data, remembering the
edits, not just the resulting value or formula. If, for example, I want to
delete all but the last three characters of a cell value, and I record a
macro, editing the cell produces a line like: ActiveCell.FormulaR1C1 = "745".
But I don't want the specific value. I want the process.
I'm essentially asking for RIGHT(R1C1,3), but I can't use that formula in
the macro because it would be a circular reference. What am I missing?
If you use the Value property you can just replace the old v...Exchange server randomly asking random users to Authenticate randomly...
Has anyone had a problem like this where a user is in their Exchange mailbox
using Outlook 2003 and the server prompts them for their credentials? If
they hit cancel and exit out of Outlook and run it again it lets them into
Pls make sure the outlook 2003 Client does not using Cache mode
If is ,pls clearn this option
"Benjamin Chan" <bchan[pleasenospam]@controlproductsinc.com> ���g��l��s�D
> Has anyone had a problem like this where a user is in their Exchange
> using Outlo...Merging columns of data
Is it possible to merge two columns of data into a single column, such that
the resultant column will contain cells of text consisting of the
*concatenation* of the two columns?
In other words, let's say I have two columns -- A & B -- each with many rows
of cells. In column A, I have a list of First Names; in column B, I have a
list of Last Names. What I'd like to do is to merge them into a single
column of First and Last Names.
I know I can create a function (in a third column, for instance) for every
single row, where column C would use a CONCATENATE function to merge t...Formatting Imported Data
I have to compile a worksheet from data copied from a pdf file. Problem when
i copy and paste text all data falls into column A and i have to drag one
line at a time to the specific headings.
this is how the data I copy pastes into excel:
I have set up the columns as such:
Date Time Duration Number Dialled Charge
And n...Adventure Works Sample Data Install Problem
When I am tring to install the sample data using the SampleDataWizard I get
the following error when I click the Next button after entering 9 users from
************** Exception Text **************
System.Exception: Object reference not set to an instance of an object.
firstNode, TreeNode parentTreeNode)
sender, EventArgs e)
at Syst...Macro to number blank cells
In one row I have:
A B C D E
Cust# Address 1 Address 2 Address3 Address 4 Address5
I have a macro that inserts 6 rows below each name, how could I copy
information in columns B-G to the 6 cells below cust #, Thanks in advance
for your help
Can it be this simple? I'm not positive that I understand what you're
asking. But try this.
You have blank rows below each record.
Select the columns B through G, beginning with the first BLANK row and down
Hit Ed...Generating Correlated Random Values in Excel
Thanks so much for your advice. I think that I have it figured out,
but can you confirm this for me? I can't afford to screw this up.
If mean(inflation) = .031
stdev(inflation) = .047
mean(stock return) = .106
stdev(stock return) = .204
A B C D
1 Z1 Z2 Inflation Stock Return
Data Generation Formulas
Are these formulas correct to generate the random data? Particularly
cell D2. Does this give me a complete value that t...cell looses name after sorting
Can someone help me with the following problem in Excel 2000:
in a table I have attached serveral cells with unique cell names, the
values in these cells are used in other sheets.
the problem is that when I sort the table, the cell names stay in the
original rowposition; they are not sorted! while their values are. So
Cell names get different values, and other calculations on my other
sheets get messed up!
How can I make the cell names relative instead of absolute?
thankx in advance,
Message posted from http://www.ExcelForum.com/
"jimfx >" <<jimfx.109zcv@exc...Using a formula in cell with a drop-down Box
I am developing a program to track my work schedule that consists of a
couple of worksheets.
In WORKSHEET 1 I have a simple layout with one cell dedicated to each
day of the month. Each cell has a drop-down box that allows me to
select ON or OFF, relating to whether I am scheduled to work or not.
and each cell has a For each peron that I am scheduling,
In WORKSHEET 2 I have two cells dedicated to each day of the month.
Each cell has a drop-down box that allows me to select a starting time
in one and an ending time in the other.
What I am trying to do is to start in WORKS...Sort cells and "Place in this document"-hyperlinks
I am using a table with multiple columns that are used as a database.
Each column is one data entry. I am having some hyperlinks that point
from one data entry (i.e. column) to another inside the spreadsheet.
Unfortunately, when I perform a sort of the columns, these hyperlinks
remain pointing to the previous location inside the sheet, i.e. to the
wrong column after the sort.
How do I solve this, i.e. how I make Excel understand that these
hyperlinks need to be updated while sorting the table?
Thank you for any advice
Better to see so send to me if you like at dguille...Displaying Image(RGB888 data ) (buffered data ,not from file) on a Dialog box
I want to Display the Picture on a dialog box
I have the Image(RGB888) data Which is taken from the driver
I want to display it on the window
I tried with CreateBitmap(320,240,1,24,NULL);
but it is not working
How can i proceed
See if this will help
<firstname.lastname@example.org> wrote in message
> I want to Display the Picture on a dialog box
> I have the Image(RGB888) data Which is taken from the driver
> I want ...random pages
I have developed pages that randomly define a set of normal lung
function data based on gender, age and height. I have applied formulas
to this data simulate 5 classic lung function abnormalities (normal,
restrictive, obstructive, mixed and early obstructive.) Currently
the sheets that define the abnormal are named by one of the above lung
abnormalities. I would like to present data from random pages in a
work book to students and rather than have the pages named by the
abnormality be named a simulated patient name.
Can I have the name of a sheet set to equal data from to ...Merging MS WORD data into an Excel file
Any suggestions here..??....I have monthly time sheets that ar
completed in WORD. I receive them electronically and then transcrib
the data (hours worked, time off, the reason for any absence assigne
to a code) into an Excel spreadsheet for each employee. I am dealin
with close to 90 staff doing this on a monthly basis, and so th
workbook is fairly large and the transcribing seem
never-ending...:):)......the Excel file, of course, is great fo
compiling info on a monthly and a YTD basis.....but, I would like t
automate (or at least, ease) the transfer of info from the individua
WORD time sheets...What table contains the data displayed in 'My Tasks' view?
MS Project Server 2007
Does anyone know what table contains the data displayed in My Tasks?
Not sure which table it is, but when utilising the reporting db you can get
this info of the EPM task user view.
Hope this helps
Marc Soester [MVP]
> MS Project Server 2007
> Does anyone know what table contains the data displayed in My Tasks?
I am trying to pull the My Task information for one or more resources for a
specific period. I've used...How Can I find and replace symbols in excel data ( white square)
I need any input or help
> I need any input or help
...VBA Find a Replace
After standing the test for over a year, a problem with my VBA Find and
Replace AddIns was indentified by a user in Moscow Russia yesterday. If you
remember, the last problem identified and fixed was how to find text in the
shape range of any shape located in the header/footer story ranges of a
document. Through ignorance and lack of comprehensive testing, I failed to
consider grouped shapes, individual shapes in a drawing canvass, and grouped
shapes in a drawing canvass that are in a header\footer story range. By
adding a new recursive sub-routine this issue is now also fixed...Zeros if cell is blank
I would like to be able to select a portion of my spread sheet and then have
a macro that would search every cell in the selected area: if the cell is
blank I would want a ZERO to be placed in that cell but if the cell contains
a number/text that cell would be left as is.
You can record a macro when you do this:
Select the range
Edit|Goto (or hit F5 or ctrl-g)|Special|check blanks|ok
and ctrl-enter to fill all those empty (really empty) cells with 0's.
Or you could record a macro when you:
select the range
what: (leave blank)
Either o...Random Distribution
I need to randomly order numbers from a list or range of consecutive whole
numbers, such that each number is listed only once. Can this be done in
excel using functions, formulas or whatever? I want to incorporate it into
a spreadsheet with a macro to automatically generate the list and use it to
randomly designate selected entries.
"Rick via OfficeKB.com" wrote:
> I need to randomly order numbers from a list or range of consecutive whole
> numbers, such that each number is listed only once. Can this be done in
> excel using functions, formulas or whatever? I want to...Default Data Type for TXT and CSV files
When I open a .csv or .txt file in excel the default data type is General
Is there a way in Excel to change that as Text for all the columns?
Thanks in advance
See one reply to one of your other posts.
Narayanan Sankaranarayanan wrote:
> Hi All,
> When I open a .csv or .txt file in excel the default data type is General
> (radio button).
> Is there a way in Excel to change that as Text for all the columns?
> Thanks in advance
> Narayanan Sankaranarayanan
...Adding a comment to a formula-not a cell
I just went brain dead and can't remember the keystroke to
add a comment to a formula, not the cell.
Do you mean
=formula+N("This is a comment")
> I just went brain dead and can't remember the keystroke to
> add a comment to a formula, not the cell.
> Please help!
Use the N
=a2*a1+N("my wage+bonus-4 weekly loan repayments")
Gord Dibben Excel MVP
On Wed, 5 Jan 2005 11:34:34 -0800, "Floridagal"
Is there any way to make the What:="" be a variable? So if the variable =
Test then the replace code would look for Test.
Cells.Replace What:="", Replacement:="", LookAt:=xlWhole, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
x = Test
Don't use quote marks on variables.
"ordnance1" <email@example.com> wrote in message
> Is there any way to make the What:="" b...Use detailed data in one worksheet to create summary data as chart source
I need to export data from MS Access to Excel in order to create a
chart. I can get the data into an Excel worksheet. However, this data
needs to be summarized on a second worksheet. That summarized data
then would be the source for a chart.
My general thinking is to create an Excel template. The template would
have the code necessary so that when a user exports data from Access to
Excel, the following happens:
1) The 'Detail' worksheet in an instance of the template is populated
with the Access data. This would occur via coding in my Access
application. I already have this wor...