Spreadsheet: 217127d1361989923-why-my-index-formula-not-working-on-the-je-tab-bns-project-0227
Sheet: PIVOT

 | DATA
Project | 495006 | 495010 | 336700 | 339000 | 122055 | 257311 | 221360
10GCS0033496 | 751.4 | 67.62599999999999 | 819.026 | 150.28 | 969.3059999999999 | 751.4 | 67.62599999999999
10GCS0035865 | 1071 | 96.39 | 1167.39 | 214.2 | 1381.59 | 1071 | 96.39
10GCS0038122 | 791.665 | 71.24985 | 862.91485 | 158.333 | 1021.24785 | 791.665 | 71.24985
10GCS555602C | 791.665 | 71.24985 | 862.91485 | 158.333 | 1021.24785 | 791.665 | 71.24985
10GCS555603C | 397.8 | 35.802 | 433.602 | 79.56 | 513.162 | 397.8 | 35.802
10GCS555605C | 3095.65 | 278.6085 | 3374.2585 | 619.13 | 3993.3885 | 3095.65 | 278.6085
10GCS555608C | 1036.945 | 93.32505 | 1130.27005 | 207.389 | 1337.65905 | 1036.945 | 93.32505
10GCS555609C | 1006.815 | 90.61335 | 1097.42835 | 201.363 | 1298.79135 | 1006.815 | 90.61335
10GCS555610C | 697.12 | 62.7408 | 759.8608 | 139.424 | 899.2848 | 697.12 | 62.7408
10GCS555611C | 397.8 | 35.802 | 433.602 | 79.56 | 513.162 | 397.8 | 35.802
10GCS555612C | 733.335 | 66.00015 | 799.33515 | 146.667 | 946.00215 | 733.335 | 66.00015
10GCS555613C | 733.375 | 66.00375 | 799.37875 | 146.675 | 946.05375 | 733.375 | 66.00375
10GCS576501C | 748.155 | 67.33394999999999 | 815.4889499999999 | 149.631 | 965.11995 | 748.155 | 67.33394999999999
10GCS576505C | 11227.505 | 1010.47545 | 12237.98045 | 2245.501 | 14483.48145 | 11227.505 | 1010.47545
10GCS576506C | 2515.95 | 226.4355 | 2742.3855 | 503.1900000000001 | 3245.5755 | 2515.95 | 226.4355
10GCS576507C | 890.865 | 80.17785 | 971.04285 | 178.173 | 1149.21585 | 890.865 | 80.17785
10GCS576508C | 1274.68 | 114.7212 | 1389.4012 | 254.936 | 1644.3372 | 1274.68 | 114.7212
10GCS576511C | 3325.36 | 299.2824 | 3624.6424 | 665.072 | 4289.714400000001 | 3325.36 | 299.2824
10GCS576514C | 217.805 | 19.60245 | 237.40745 | 43.56100000000001 | 280.96845 | 217.805 | 19.60245
10GCS576516C | 2747.105 | 247.23945 | 2994.34445 | 549.4209999999999 | 3543.76545 | 2747.105 | 247.23945
10GCS576517C | 4156.015 | 374.04135 | 4530.05635 | 831.2030000000001 | 5361.25935 | 4156.015 | 374.04135 | SIGNAGE REFRESH BILLED MONTHLY (10GCS576517C)
10GCS576519C | 895.835 | 80.62514999999999 | 976.46015 | 179.167 | 1155.62715 | 895.835 | 80.62514999999999
10GCS576523C | 600.3399999999999 | 54.03059999999999 | 654.3706 | 120.068 | 774.4386 | 600.3399999999999 | 54.03059999999999
10GCS576524C | 2011.99 | 181.0791 | 2193.0691 | 402.3980000000001 | 2595.4671 | 2011.99 | 181.0791
10GCS576525C | 300 | 27 | 327 | 60 | 387 | 300 | 27
10GCS576526C | 379.17 | 34.1253 | 413.2953 | 75.834 | 489.1293000000001 | 379.17 | 34.1253
10GCS576527C | 2596.42 | 233.6778 | 2830.0978 | 519.284 | 3349.3818 | 2596.42 | 233.6778
10GCS576528C | 809.165 | 72.82485 | 881.98985 | 161.833 | 1043.82285 | 809.165 | 72.82485
10GCS576529C | 2598.19 | 233.8371 | 2832.027099999999 | 519.638 | 3351.6651 | 2598.19 | 233.8371
10GCS576530C | 569.8599999999999 | 51.28739999999999 | 621.1474 | 113.972 | 735.1194 | 569.8599999999999 | 51.28739999999999
10GCS576532C | 291.665 | 26.24985 | 317.91485 | 58.33300000000001 | 376.24785 | 291.665 | 26.24985
10GCS576533C | 245.835 | 22.12515 | 267.96015 | 49.167 | 317.12715 | 245.835 | 22.12515
10GCS576534C | 270.835 | 24.37515 | 295.21015 | 54.167 | 349.37715 | 270.835 | 24.37515
10GCS576535C | 270.835 | 24.37515 | 295.21015 | 54.167 | 349.37715 | 270.835 | 24.37515
10GCS576536C | 270.835 | 24.37515 | 295.21015 | 54.167 | 349.37715 | 270.835 | 24.37515
Grand Total | 50718.985 | 4564.70865 | 55283.69365 | 10143.797 | 65427.49065000001 | 50718.985 | 4564.70865