OOTP Developments Forums - View Single Post

SandMan · 12-22-2003, 11:12 PM

I did fnd a problem if the files were loaded on a computer without the analysis pack loaded with excel that it would not work. There is a simple fix though.

In the column where the function is loaded as =randombetween($m$1, $m$2) you will need to make the following changes:

1. Define cell M1 as "start_year" and cell m2 as "end_year". (menu Insert-name-Define)

2. Modify the first cell in j1 to =INT(RAND()*(End_Year-Start_Year)+Start_Year).

3. copy this to the other cells in column "J".

I enjoyed using this because I was going to write a VB program to do this exact same thing but have not have time to do so. A program would make it available to those without access and excel but this could be automated in excel also using a script.

12-22-2003, 11:12 PM	#5 (permalink)
SandMan Hall Of Famer Join Date: Aug 2003 Location: Kenosha, Wisconsin Posts: 2,490 Thanks: 220 Thanked 142x in 110 posts	I did fnd a problem if the files were loaded on a computer without the analysis pack loaded with excel that it would not work. There is a simple fix though. In the column where the function is loaded as =randombetween($m$1, $m$2) you will need to make the following changes: 1. Define cell M1 as "start_year" and cell m2 as "end_year". (menu Insert-name-Define) 2. Modify the first cell in j1 to =INT(RAND()*(End_Year-Start_Year)+Start_Year). 3. copy this to the other cells in column "J". I enjoyed using this because I was going to write a VB program to do this exact same thing but have not have time to do so. A program would make it available to those without access and excel but this could be automated in excel also using a script.