Spreadsheet: 690727d1597254374-retrieving-value-from-set-of-calculated-dependent-cells-sample-spreadsheet
Sheet: Companies

Name | 2019 Revenue | 2020 Dues | 2020 Applied to Health 2020 | 2020 Applied to Health 2021 | 2021 Full dues
Total
Difference from 2020
Company 1 | 74908000 | 86204 | 86204 | 0 | 88359
Company 2 | 42294000000 | 781637 | 742555 | 0
Company 3 | 1094274000 | 340860 | 340860 | 0
Company 4 | 3047597000 | 368793 | 368793 | 0
Company 5 | 178000000 | 209901 | 209901 | 0
Company 6 | 5754346135 | 399568 | 399568 | 0
Company 7 | 47000000000 | 901990 | 901990 | 0
Company 8 | 26145000000 | 1131385 | 1131385 | 0
Company 9 | 24555700000 | 633530 | 633530 | 0
Company 10 | 22449000000 | 626729 | 626729 | 0
Company 11 | 3215600000 | 473053 | 473053 | 0
Company 12 | 44359002778 | 423255 | 423255 | 0
Company 13 | 40028927855 | 853458 | 853458 | 0
Company 14 | 32753000000 | 1209489 | 1209489 | 0
Company 15 | 81581000000 | 993211 | 993211 | 0
Company 16 | 15000000000 | 552535 | 524908 | 0
Company 17 | 6710800000 | 421176 | 421176 | 0
Company 18 | 1881883000 | 352123 | 352123 | 0
Company 19 | 1661043000 | 346536 | 346536 | 0
Company 20 | 1300000000 | 342480 | 342480 | 0
Company 21 | 179804000 | 126787 | 126787 | 0
Company 22 | 108000000 | 92750 | 92750 | 0
Company 23 | 61245000 | 80971 | 80971 | 0
Company 24 | 53640000000 | 870271 | 870271 | 0
Company 25 | 16704485200 | 450000 | 450000 | 0
Company 26 | 13452900000 | 504083 | 504083 | 0
Company 27 | 5038748087 | 397266 | 397266 | 0
Company 28 | 2488138452 | 360792 | 360792 | 0
Company 29 | 853826000 | 304312 | 304312 | 0
Company 30 | 151862000 | 118824 | 118824 | 0
Company 31 | 23747000000 | 602906 | 602906 | 0
Company 32 | 753000000 | 204146 | 204146 | 0
Company 33 | 222600000 | 132036 | 132036 | 0
Company 34 | 114600000 | 150000 | 150000 | 0
Company 35 | 34788000 | 77984 | 77984 | 0
Company 36 | 57772589800 | 888454 | 888454 | 0
Company 37 | 1800000000 | 352252 | 352252 | 0
Company 38 | 628000000 | 256323 | 256323 | 0
Company 39 | 427000000 | 111608 | 111608 | 0
Company 40 | 418926000 | 150000 | 150000 | 0
Company 41 | 380800000 | 161338 | 161338 | 0
Company 42 | 346639000 | 174335 | 174335 | 0
Company 43 | 339000000 | 171873 | 171873 | 0
Company 44 | 330000000 | 141093 | 141093 | 0
Company 45 | 291000000 | 152830 | 152830 | 0
Company 46 | 254922000 | 148196 | 148196 | 0
Company 47 | 238261998 | 143448 | 143448 | 0
Company 48 | 193118000 | 97937 | 97937 | 0
Company 49 | 140000000 | 115443 | 115443 | 0
Company 50 | 85300000 | 66000 | 66000 | 0
Company 51 | 75863925 | 86545 | 86545 | 0
Company 52 | 63388617 | 81675 | 81675 | 0
Company 53 | 29868000 | 58756 | 58756 | 0
Company 54 | 19115000 | 86465 | 86465 | 0
Company 55 | 111119000 | 54000 | 54000 | 0 | 109893
Company 56 | 102000000 | 11340 | 11340 | 0 | 107229
Company 57 | 73000000 | 51660 | 51660 | 0 | 87610
Company 58 | 31000000 | 31320 | 31320 | 0 | 61178
Company 59 | 59851000 | 54000 | 54000 | 0 | 82448
Company 60 | 111500000 | 54000 | 54000 | 0 | 110004
Company 61 | 31000000 | 15300 | 15300 | 0 | 61178
Company 62 | 34644000 | 41400 | 41400 | 0 | 64244
Company 63 | 30540000 | 35000 | 35000 | 0 | 60791
Company 64 | 120000000 | 110000 | 94285.72 | 0 | 112487
Company 65 | 39813605442 | 768628 | 640523 | 128105 | 778043
Company 66 | 6035000000 | 411514 | 342928.3 | 68585.70000000001 | 421800
Company 67 | 1277000000 | 100000 | 83333.3 | 16666.7 | 352059
Company 68 | 12260000000 | 492672 | 369504 | 123168 | 504947
Company 69 | 16130000000 | 910351 | 628763 | 227588 | 543028
Company 70 | 910331929 | 317930 | 238447.53 | 79482.47 | 325878
Company 71 | 100000 | 369971 | 277478.28 | 92492.71999999997
Company 72 |  | 249118 | 186838.5 | 62279.5
Company 73 |  | 122353 | 81568.64 | 40784.36 | 128554
Company 74 |  | 219198 | 0 | 0 | 457931