Spreadsheet: 859242d1707713466-creating-calculation-after-matchinf-data-look-up-and-add-value
Sheet: Model Calulations

 |  | Month |  |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12
 |  | Year |  |  | Year 1 | Year 1 | Year 1 | Year 1 | Year 1 | Year 1 | Year 1 | Year 1 | Year 1 | Year 1 | Year 1 | Year 1
Revenue
 | Line Item 1 |  |  |  | 52101.84618034514 | 305598.4761826888 | 183079.4593317844 | 126203.3268983195 | 345772.3422507891 | 917932.9918674874 | 810588.0459111731 | 260466.0731493461 | 429759.6439616295 | 153264.774637918 | 634872.7491883663 | 307609.6528310527
 | Line Item 2 |  |  |  | 139753.6228602078 | 921381.159778593 | 56755.04635453271 | 503096.0513052142 | 848773.6714050372 | 486351.347832739 | 126558.5404302111 | 342196.7268189182 | 690182.392213615 | 244779.8248400595 | 306270.970556147 | 512308.8317596742
 | Line Item 3 |  |  |  | 58014.03053872664 | 610028.0891157209 | 231136.7344677063 | 755410.9244906242 | 618898.8321704252 | 28948.1127384523 | 938873.311855545 | 740690.9859408854 | 578207.0134557766 | 788163.4962643534 | 58931.93667528141 | 743290.8600171831
 | Line Item 4 |  |  |  | 844258.0444660306 | 277891.3351377072 | 101742.7767749504 | 673923.1596451165 | 310159.9447077372 | 468918.3757534449 | 524022.9590921411 | 93985.24500044677 | 853192.3630168659 | 415585.318429764 | 186502.7669813792 | 317441.8802656629
 | Line Item 5 |  |  |  | 907639.3088224832 | 713297.6169137785 | 51908.7407186843 | 58901.19455927164 | 691828.2252130841 | 529656.982517401 | 335817.1823908507 | 438731.7621540262 | 337003.5646387744 | 525422.011031886 | 658909.5449619965 | 129162.8762678616
 | Line Item 6 |  |  |  | 477630.1491011214 | 179420.2920864565 | 939300.7237507048 | 829951.0892510386 | 79235.11080826054 | 952143.881263598 | 86506.98387075674 | 127582.4012247777 | 209847.2314273357 | 314483.8489740417 | 690846.8680663734 | 902642.0130272919
 | Line Item 7 |  |  |  | 912622.2624472578 | 133222.835117935 | 376828.1807912405 | 973239.7142824441 | 821584.1350907641 | 832691.1866435533 | 80683.83104086368 | 731578.9530163954 | 402816.2459472422 | 263873.6660256792 | 665620.0917273534 | 590020.8380576221
 | Line Item 8 |  |  |  | 110087.9666389426 | 104910.8881081102 | 308450.9203464066 | 940138.8825803526 | 839087.3193877476 | 404078.8051243844 | 677450.2350991834 | 201228.1685117915 | 507511.9521459168 | 87091.00261755416 | 445111.6613418681 | 447876.5753871022
 | Line Item 9 |  |  |  | 980079.7430976463 | 67158.54741371928 | 192156.2103368354 | 402963.4408416175 | 982599.3576131247 | 810461.6566844248 | 603491.7597508223 | 349857.1710825381 | 811630.0758252583 | 570476.6584451401 | 424267.9575140924 | 324893.1847356299
 | Line Item 10 |  |  |  | 62270.82913617102 | 226576.7880251621 | 57662.65201328372 | 318117.5982299336 | 922484.3926955042 | 371197.4880618276 | 265542.780429525 | 616720.866829715 | 406377.3841647163 | 415821.2546324056 | 341888.0150174827 | 778520.4171645602
 | Line Item 11 |  |  |  | 436550.1609383628 | 433548.1206005779 | 88666.80994681829 | 37317.93702237155 | 530171.252237611 | 240329.5364976284 | 636438.4791346827 | 429122.1991244484 | 557292.3101717732 | 688118.9955194301 | 564819.0457443284 | 288332.2769505983
 | Project 1 (Department) | Line Item 1 |  |  | 474831.8576682961 | 646423.9744350503 | 368576.5574723371 | 555835.4328841713 | 130071.5891190904 | 680963.4808886204 | 621388.3130557258 | 722320.4505822206 | 58165.18691625137 | 479531.6536162263 | 302162.9293572998 | 71386.25870644308
 | Project 2 (Department) | Line Item 3 |  |  | 812432.1560870834 | 265726.2180180862 | 207364.2190290371 | 459492.3884954247 | 511914.663452512 | 236209.0837987073 | 281670.0055027312 | 746850.81294804 | 880535.3325512706 | 632190.3686412409 | 841929.208102909 | 499351.0749912112
 | Project 3 (Department) | Line Item 9 |  |  | 289347.5443178728 | 134955.6274606462 | 273002.5308144919 | 482704.3928854844 | 147382.666457215 | 493070.8291388013 | 495896.2756325559 | 620627.8998475097 | 674940.8849755605 | 884061.5279500451 | 996381.1442928102 | 849049.2180790933
 | Project 4 (Department) | Line Item 7 |  |  | 509500.4778911361 | 650159.3119683884 | 464500.0193775154 | 268994.8621826232 | 293030.7926049564 | 321107.9931461498 | 360014.1214702287 | 668549.3199439181 | 191781.0361917304 | 165943.4077434307 | 835596.1502566925 | 493589.8944048139
 | Project 5 (Department) | Line Item 4 |  |  | 88398.83121037319 | 136739.4754071985 | 142909.5400241563 | 606788.9205234365 | 853304.3895286773 | 206271.6726824487 | 280799.2593746848 | 317381.6676183825 | 580066.6204299764 | 841178.1269685053 | 373128.4805663325 | 310160.6478996386