I have to examine a random number of cases every week. I used to have a little app that had a spot to ask me how many random numbers I need. So lets say this week I need to examine 15 cases, I'd enter in 15. Then it would ask me a range for the random numbers. So, lets say there are 250 cases, so I'd type in 250. Then it would spit 15 unique random numbers in sequential order. So, then I could look at me list of 250 case and review those 15 that the random number generator spit out.
Well, we just upgraded our computers to Win 7 and that little app does not work anymore. I've been playing around in Excel, and I've gotten pretty close to getting something thrown together, but I can't get it to work just right...
I am working on a Random Cycle Count Generator that provides random SKU#s based on 3 separate columns of SKU listings. The user clicks a button to generate the SKU#s to cycle count for that day. What I would like to see is a date stamp in the columns next(B,D,F) to the referenced SKU listing(A,C,E) based on which SKU#s are generated. This will let me see the last date that the SKU was generated. I would also like it to automatically save after generating.
I need to generate 8 (random) numbers which should range between 0 to 80 and the sum of those generated 8 numbers should be 80.? How can I achieve this.
I have a list numbered 0 to 300. What I am looking for is a formula to randomly select 150 unique sets of two numbers and list them in separate columns for a competition draw and should appear as per the example below
I am looking for a way to create a random order of numbers in a given range. For example, A1:a100 to be populated with a random number between 1 and 100, but not to duplicate, using every possible number within that range. I use the RANDBETWEEN function to generate the numbers, but I cannot prvent them from duplicating.
I am also using the following formula to return the date in Cell BE1: =TODAY()
I am using the following formula to give me the ISO week number in Excel in Cell BE2: =1+INT((BE1-DATE(YEAR(BE1+4-WEEKDAY(BE1,2)),1,5)+WEEKDAY(DATE(YEAR(BE1+4-WEEKDAY(BE1,2)),1,4),2))/7)
and the year in Cell BG2: =YEAR(BE1)
I then use the following to give me the wk and year in this format "wk-yr", i.e "6-09" in Cell BF4. =CONCATENATE(BE2,"-",RIGHT(BG2,2))
My question (finally) is that I am using this in a sheet that tracks issues that have deadlines. I manually enter in the dealine in the format "wk-yr". I have conditional formating that then colours a cell amber if it equals the current week and year, which is given in Cell BF4.
I want to use a traffic light system that will flag all issues in the weeks before the current week red, and the weeks after the current week in green, i.e. red = late!! I can't get my head round how I use a formual in teh conditional formating to correctly identify the relevent weeks? Any one any ideas? I could have the following situation for example (assuming that the current week is wk6 2009) and the formating should apply the colours as per my brackets:
How can one determine a week number reliably with date as an input? I can imagine that the function needs some kind of input as well, what is the first day of the year...
This would generate a random number into RPlayerNum variable, based on the list in sheet RPlay, missing off row 1 as the header.
However we have noticed a massive flaw in this code.... It works as long as the excel file is open, each time run it gives a different random number. However if you close the excel file and open it, then run it, it ALWAYS gives the same number first run, every time.
I am creating an excel spread sheet for a project I am doing, I need to create a daily chart for 6 months of water usage that results in averaging set targets.
I have made a chart with the average uses per day but would like to have daily numbers that average out to what i have but in a random sequence e.g. i have that a shower uses 320 litres per day for 2 people is there a way i can make a chart that says: 300 (a1) 340(a2) 260(a3) 360(a4) etc i need to do this for 180 days with random numbers generated to average the same overall. I dont know even how to generate random numbers.
Any way to make say cells A1 thru A10 produce random numbers from 0 to 9.
I would like to do it without a macro if possible. I also need a button to generate those random numbers. I know this button may make it impossible to not use a macro. If it has to be done with a macro then so be it.
I have a process that generates the value X in cell A1 randomly. So I can change the value of X in A1 by clicking on F9. I want to sum a sequence of X values. I can do this by manually copying each X to a row of cells and then summing the row values. But that is tedious. Can the summation be done automatically without being regarded as being circuler?
I am trying to generate random numbers between 0 - 9 in ten cells that do not repeat an always include every value 0 - 9 (0, 1, 2, 3, 4,...9). The object is to have the numbers randomize each time. So cells A1:A10 could look like this:
I have two rows in a sheet with random numbers (1 till 90).
Those numbers in those two rows I change them every 5 minutes with new one still from 1 to 90 I need a "way", in one side of my sheet (lets say in column B) to count how many times a number was repeated after finish my work (example after 2 hour's)
I'm trying to generate random numbers that will add up to a certain number and am having trouble brainstorming how to do so. For example, I'm trying to get a+b+c=6 with a, b, and c randomly generated to add up to 6.
Any way to make say cells A1 thru A10 produce random numbers from 0 to 9.
I would like to do it without a macro if possible. I also need a button to generate those random numbers. I know this button may make it impossible to not use a macro, but If it has to be done with a macro then so be it.
I want to include some random numbers in a large multi-tabbed spreadsheet, but I do not want the number to recalculate every time I make another entry on the tab or elsewhere in the workbook. I would like each tab to have one or two random number options, but each should calcualte independently based on their own inputs.
The "randbetween()" function recalcs with every/any change in the workbook.
Specifically, I want to begin with a random percent between 0 and 50% and then add three fixed values (percents) and one different random percent between 0and 30%. then I want to total all of them.
Random % (0-50) + X% + Y% + Z% + random % (0-30) = total %
Im an using excel to run a simulation of demand over a period of 200 days. i have an average daily demand of 7.75 and a stdev of 2.6. Is there any way to generate random numbers (for daily demand) based on this data?
I wonder if you think it can be possible to constraint the RAND function so that it gives off its result commensurate with the result of another RAND function with certain probability N? For example,
Say there are two random functions and the first generates 0,5667 the correlation is at 0,5 so there is a 50% probability that the second random function will generate the result very close to it, say, 0,6012….Do you think the second random function can be tweaked so that it performs in this manner….when there is a 100% correlation – the results of both random functions will agree…when it is 80% it will be very close…..do you think this can be done with NORMINV?
I have 3 columns of random numbers... it the first 2 columns the numbers range from 01 to 19... and in the 3rd column they range from 01 to 15 The total number of numbers in each column is 30... and i want to know is there a way to pridict the 31st set of numbers?
I wanted to work backwards from a weeknumber (as defined in Excel). In other words, given a week number (i.e. 5) what is the first date and last date of that weeknumber. These are the formulas that I came up with and they work fine.
