Long description
The formulae are as follows.
Row 18 of columns C, D, and E
C18: equals C17 plus D17
D18: equals D17 plus B18
E18: equals A18
Row 18 of columns I, J, and K
I18: equals I17 plusH17
J18: equals J17 plus H18
K18: equals G18
Row 5 of columns B through H
B5: equals RAND()
C5: equals VLOOKUP(B5,$C$17 colon $E$22,3,TRUE)
D5: equals D4 plus C5
E5: equals MAX(D5,H4)
F5: equals RAND()
G5: equals VLOOKUP(F5,$I$17 colon $K$19,3,TRUE)
H5: equals E5 plus G5
Get Quantitative Analysis for Management, 13/e now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
