2 dummy datasets -- each column is gradually smaller than the prior... having a problem when I subtract the before from the after data

[daytona12345]

What I am trying to accomplish is to create fake data, so far I've done this by doing:
1. =RANDBETWEEN() and this works fine.
2. I need each consecutive column to be smaller than the previous one, which I can accomplish by doing a =RANDBETWEEN()/100 * previous cell so that I get only a percentage as a whole number from the prior cell.
3. I then need to make a second data set. The very first column that I used for =RANDBETWEEN is the exact same, so I just reference this....then each additional column here just needs to be slightly higher than the first dataset.


I'm having an issue when I go to get the difference between the before and after dataset....I'll have a column of Total Sales, and then Sales within 24 hours -- and the sales within 24 hours is a higher number than the sales -- which is not possible.



TL;DR
I need fake data for each of these columns in 'Before'...it's an advertising workflow, so each column is smaller and smaller. Then I need an 'After' set of data where we may perform something that should increase the success rate. When I go to get the difference -- I can't have more 'Sales within 24 hours' than 'Sales'

 

[StephenCrump]

I'm having an issue when I go to get the difference between the before and after dataset....I'll have a column of Total Sales, and then Sales within 24 hours -- and the sales within 24 hours is a higher number than the sales -- which is not possible.

Your problem is not in the After - Before comparison. It's in the After fake data.

If you want every data point to be better than before (i.e. highly fake data!) then you'll need to "fix" L6 and L8 - which at the moment you have lower than F6 and F8, and also make sure that each of M6 and N6 is greater than G6 and H6, and similar for row 8.

 

[daytona12345]

Thanks Stephen -- I have a couple thousand rows of data -- any thoughts on the best way to do this more efficiently

What I had originally done was do =RANDBETWEEN() to get the ad views column -- which is going to be the same regardless of the before and after.
From there I had done =RANDBETWEEN(55,75)/100 * C3

I've also done this so that the rows with iOS and Android have different percentages because to be more accurate to real life, android would have higher numbers.


When I got to the After columns I had tried a few different things, I had tried increasing the result of before by another randbetween percentage, I also tried to do numbers greater than the before column by doin something like a D3+1 but keep running into this issue.

 

[StephenCrump]

There are any number of ways you could contrive to do this. Here's one:

	A	B	C	D	E	F	G	H	I	J	K	L	M
1		MyMin	50
2		MyMax	75
3
4			Before						After
5		Views	1p	2p	2p & sale	Sale<24h	Sale>24h		1p	2p	2p & sale	Sale<24h	Sale>24h
6
7		160,899	107,802	72,227	44,781	22,838	21,943		152,127	97,060	51,823	23,272	28,551
8		150,198	105,139	78,854	48,889	30,800	18,089		144,179	84,862	75,665	49,186	26,479
9		152,655	77,854	56,833	28,985	15,652	13,333		90,242	62,342	45,386	29,412	15,974
10		137,791	88,186	51,148	33,758	21,268	12,490		133,379	72,513	43,146	21,975	21,171
11
Sheet1

Cell Formulas
Range	Formula
B7:B10	B7	=RANDBETWEEN(120000,200000)
C7:F10	C7	=ROUND(B7*RANDBETWEEN(MyMin,MyMax)/100,0)
G7:G10,M7:M10	G7	=E7-F7
I7:I10	I7	=RANDBETWEEN(C7+4,B7)
J7:J10	J7	=RANDBETWEEN(D7+3,C7)
K7:K10	K7	=RANDBETWEEN(E7+2,D7)
L7:L10	L7	=RANDBETWEEN(F7+1,K7-G7-1)

Named Ranges
Name	Refers To	Cells
MyMax	=Sheet1!$C$2	C7:F10
MyMin	=Sheet1!$C$1	C7:F10