Spreadsheet: 720769d1614280236-formula-to-identify-consecutive-month-of-gp-write-down-testbook
Sheet: GP History

company | wipYear | wipMonth | Contract | ContractDescription | Rev | Cost | GP | % | Date | [NAME]
10 | 2019 | 10 | 1015123. |  | 2519389.75 | 2065927.35 | 453462.4 | 0.179988
10 | 2019 | 11 | 1015123. |  | 2519389.75 | 2065927.35 | 453462.4 | 0.179988
10 | 2019 | 12 | 1015123. |  | 2519389.75 | 2065927.35 | 453462.4 | 0.179988
10 | 2020 | 1 | 1015123. |  | 2519389.75 | 2065927.35 | 453462.4 | 0.179988
10 | 2020 | 2 | 1015123. |  | 2519389.75 | 2065927.35 | 453462.4 | 0.179988
10 | 2020 | 3 | 1015123. |  | 2519389.75 | 2065927.35 | 453462.4 | 0.179988
10 | 2020 | 4 | 1015123. |  | 2519389.75 | 2065927.35 | 453462.4 | 0.179988
10 | 2020 | 5 | 1015123. |  | 2519389.75 | 2065927.35 | 453462.4 | 0.179988
10 | 2020 | 6 | 1015123. |  | 2519389.75 | 2065927.35 | 453462.4 | 0.179988
10 | 2020 | 7 | 1015123. |  | 2519389.75 | 2065927.35 | 453462.4 | 0.179988
10 | 2020 | 8 | 1015123. |  | 2519389.75 | 2065927.35 | 453462.4 | 0.179988
10 | 2020 | 9 | 1015123. |  | 2519389.75 | 2065927.35 | 453462.4 | 0.179988
10 | 2020 | 10 | 1015123. |  | 2519389.75 | 2065927.35 | 453462.4 | 0.179988
10 | 2020 | 11 | 1015123. |  | 2519389.75 | 2065927.35 | 453462.4 | 0.179988
10 | 2020 | 12 | 1015123. |  | 2519389.75 | 2065927.35 | 453462.4 | 0.179988
10 | 2021 | 1 | 1015123. |  | 2519389.75 | 2065927.35 | 453462.4 | 0.179988
10 | 2019 | 10 | 1016030. |  | 6204628.93 | 6701701.81 | -497072.88 | -0.080113
10 | 2020 | 11 | 1016030. |  | 6204628.93 | 6703969.34 | -499340.41 | -0.080478
10 | 2020 | 12 | 1016030. |  | 6204628.93 | 6705624 | -500995.07 | -0.080745
10 | 2020 | 1 | 1016030. |  | 6204628.93 | 6705624 | -500995.07 | -0.080745
10 | 2019 | 10 | 1016137. |  | 536540 | 608551.34 | -72011.34 | -0.134214
10 | 2019 | 10 | 1017012. |  | 802382.11 | 969958.14 | -167576.03 | -0.208848
10 | 2019 | 11 | 1017012. |  | 802382.11 | 969958.14 | -167576.03 | -0.208848
10 | 2019 | 12 | 1017012. |  | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 1 | 1017012. |  | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 2 | 1017012. |  | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 3 | 1017012. |  | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 4 | 1017012. |  | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 5 | 1017012. |  | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 6 | 1017012. |  | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 7 | 1017012. |  | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 8 | 1017012. |  | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 9 | 1017012. |  | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 10 | 1017012. |  | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 11 | 1017012. |  | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 12 | 1017012. |  | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2021 | 1 | 1017012. |  | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2019 | 10 | 1017013. |  | 7032870 | 7530294.91 | -497424.91 | -0.070728
10 | 2020 | 11 | 1017013. | Project B | 7090971 | 7604961.39 | -513990.39 | -0.072485
10 | 2020 | 12 | 1017013. | Project B | 7190991 | 8111805.12 | -920814.12 | -0.128051
10 | 2021 | 1 | 1017013. | Project B | 7232598 | 8160187.07 | -927589.07 | -0.128251
11 | 2020 | 9 | 1109254. |  | 143608 | 120630.72 | 22977.28 | 0.16 |  | 0
11 | 2020 | 10 | 1109254. |  | 143608 | 120630.72 | 22977.28 | 0.16 |  | 0
11 | 2020 | 11 | 1109254. |  | 143608 | 120630.72 | 22977.28 | 0.16 |  | 0
11 | 2020 | 12 | 1109254. |  | 143608 | 120630.72 | 22977.28 | 0.16 |  | 0
11 | 2020 | 9 | 1109261. |  | 34400 | 28205 | 6195 | 0.180087 |  | 0
11 | 2020 | 10 | 1109261. |  | 34400 | 28205 | 6195 | 0.180087 |  | 0
11 | 2020 | 11 | 1109261. |  | 34400 | 28205 | 6195 | 0.180087 |  | 0
11 | 2020 | 12 | 1109261. |  | 34400 | 28205 | 6195 | 0.180087 |  | 0
11 | 2020 | 9 | 1109265. |  | 30400 | 24303.04 | 6096.96 | 0.200557 |  | 0
11 | 2020 | 10 | 1109265. |  | 30400 | 24303.04 | 6096.96 | 0.200557 |  | 0
11 | 2020 | 11 | 1109265. |  | 30400 | 24303.04 | 6096.96 | 0.200557 |  | 0
11 | 2020 | 12 | 1109265. |  | 30400 | 24303.04 | 6096.96 | 0.200557 |  | 0
11 | 2020 | 9 | 1109282. |  | 94900 | 74022 | 20878 | 0.22 |  | 0
11 | 2020 | 10 | 1109282. |  | 94900 | 74022 | 20878 | 0.22 |  | 0
11 | 2020 | 11 | 1109282. |  | 94900 | 74022 | 20878 | 0.22 |  | 0
11 | 2020 | 12 | 1109282. |  | 94900 | 74022 | 20878 | 0.22 |  | 0
11 | 2020 | 9 | 1109283. |  | 19800 | 15444.71 | 4355.29 | 0.219964 |  | 0
11 | 2020 | 9 | 1109286. |  | 24900 | 10175.03 | 14724.97 | 0.591364 |  | 0
11 | 2020 | 10 | 1109286. |  | 24900 | 10175.03 | 14724.97 | 0.591364 |  | 0
11 | 2020 | 11 | 1109286. |  | 24900 | 12075.03 | 12824.97 | 0.515059 |  | -1900
11 | 2020 | 12 | 1109286. |  | 24900 | 12075.03 | 12824.97 | 0.515059 |  | 0
11 | 2020 | 9 | 1109288. |  | 280000 | 218402 | 61598 | 0.219992 |  | 0
11 | 2020 | 10 | 1109288. |  | 280000 | 218402 | 61598 | 0.219992 |  | 0
11 | 2020 | 11 | 1109288. |  | 280000 | 218402 | 61598 | 0.219992 |  | 0
11 | 2020 | 12 | 1109288. |  | 280000 | 218402 | 61598 | 0.219992 |  | 0
11 | 2020 | 9 | 1109289. |  | 88900 | 69340 | 19560 | 0.220022 |  | 0
11 | 2020 | 10 | 1109289. |  | 88900 | 69340 | 19560 | 0.220022 |  | 0
11 | 2020 | 11 | 1109289. |  | 88900 | 69340 | 19560 | 0.220022 |  | 0
11 | 2020 | 12 | 1109289. |  | 88900 | 69340 | 19560 | 0.220022 |  | 0
11 | 2020 | 9 | 1115794. |  | 12144247.53 | 10051847.61 | 2092399.92 | 0.172295
11 | 2020 | 10 | 1115794. |  | 12144247.53 | 10051847.61 | 2092399.92 | 0.172295 |  | 0
11 | 2020 | 11 | 1115794. |  | 12146578.47 | 10051847.61 | 2094730.86 | 0.172454
11 | 2020 | 9 | 1115835. |  | 0 | 0 | 0 |  |  | 0
11 | 2020 | 10 | 1115835. |  | 0 | 0 | 0 |  |  | 0
11 | 2020 | 11 | 1115835. |  | 0 | 0 | 0 |  |  | 0
11 | 2020 | 12 | 1115835. |  | 0 | 0 | 0 |  |  | 0
11 | 2020 | 9 | 1117317. |  | 8905129 | 7847662.32 | 1057466.68 | 0.118748 |  | 0
11 | 2020 | 10 | 1117317. |  | 8905129 | 7847662.32 | 1057466.68 | 0.118748 |  | 0
11 | 2020 | 11 | 1117317. |  | 8904021 | 7847662.32 | 1056358.68 | 0.118638 |  | -1108
11 | 2020 | 12 | 1117317. |  | 8904021 | 7847662.32 | 1056358.68 | 0.118638 |  | 0
11 | 2020 | 9 | 1117325. |  | 36600001.77 | 33250391.64 | 3349610.13 | 0.091519 |  | 0
11 | 2020 | 10 | 1117325. |  | 36606269.77 | 33257000 | 3349269.77 | 0.091494 |  | -340.3599999998696
11 | 2020 | 11 | 1117325. |  | 36606269.77 | 33157000 | 3449269.77 | 0.094226
11 | 2020 | 12 | 1117325. |  | 36606269.77 | 33157000 | 3449269.77 | 0.094226 |  | 0
11 | 2020 | 9 | 1117329. |  | 1366.31 | 1366.31 | 0 | 0 |  | 0
17 | 2020 | 9 | 1718067. |  | 63462 | 72076.28 | -8614.28 | -0.135739 |  | 0
17 | 2020 | 10 | 1718067. |  | 63462 | 72076.28 | -8614.28 | -0.135739 |  | 0
17 | 2020 | 11 | 1718067. |  | 63462 | 72076.28 | -8614.28 | -0.135739 |  | 0
17 | 2020 | 12 | 1718067. |  | 63462 | 72076.28 | -8614.28 | -0.135739 |  | 0
17 | 2020 | 9 | 1718088. | Project A | 49250222.69 | 45986173.39 | 3264049.3 | 0.066274 |  | -23476.47999999998 |  | Consecutive months of GP write down.
17 | 2020 | 10 | 1718088. | Project A | 49686156.2 | 46704325.4 | 2981830.8 | 0.060013 |  | -282218.5
17 | 2020 | 11 | 1718088. |  | 50644347.04 | 47662516.24 | 2981830.8 | 0.058877 |  | 0
17 | 2020 | 12 | 1718088. |  | 50830661.44 | 47848830.64 | 2981830.8 | 0.058662 |  | 0
17 | 2020 | 9 | 1718130. |  | 132000 | 228894.41 | -96894.41 | -0.734048 |  | 0
17 | 2020 | 10 | 1718130. |  | 132000 | 228894.41 | -96894.41 | -0.734048 |  | 0
17 | 2020 | 11 | 1718130. | Project D | 132000 | 230113.41 | -98113.41 | -0.743283 |  | -1219
17 | 2020 | 12 | 1718130. | Project D | 132000 | 234188.91 | -102188.91 | -0.774158 |  | -4075.5
17 | 2020 | 9 | 1718145. |  | 22679 | 11768.16 | 10910.84 | 0.481098 |  | 0
17 | 2020 | 10 | 1718145. |  | 22679 | 11768.16 | 10910.84 | 0.481098 |  | 0
17 | 2020 | 11 | 1718145. |  | 22679 | 11768.16 | 10910.84 | 0.481098 |  | 0
17 | 2020 | 9 | 1718185. |  | 586044.01 | 482529.57 | 103514.44 | 0.176632 |  | 0
17 | 2020 | 10 | 1718185. |  | 588444.01 | 484929.57 | 103514.44 | 0.175912 |  | 0
17 | 2020 | 11 | 1718185. |  | 588444.01 | 484929.57 | 103514.44 | 0.175912 |  | 0
17 | 2020 | 12 | 1718185. |  | 588444.01 | 484929.57 | 103514.44 | 0.175912 |  | 0
17 | 2020 | 9 | 1718209. |  | 1499668.42 | 1104799.01 | 394869.41 | 0.263304
17 | 2020 | 10 | 1718209. |  | 1499668.42 | 1103602.08 | 396066.34 | 0.264102
17 | 2020 | 11 | 1718209. |  | 1499668.42 | 1103602.08 | 396066.34 | 0.264102 |  | 0
17 | 2020 | 12 | 1718209. |  | 1499668.42 | 1103602.08 | 396066.34 | 0.264102 |  | 0
17 | 2020 | 9 | 1718253. |  | 11348 | 9001 | 2347 | 0.20682 |  | 0
17 | 2020 | 10 | 1718253. |  | 11348 | 9001 | 2347 | 0.20682 |  | 0
17 | 2020 | 9 | 1718267. |  | 6761336 | 6307335.91 | 454000.09 | 0.067146 |  | 0
17 | 2020 | 10 | 1718267. |  | 6761336 | 6307335.91 | 454000.09 | 0.067146 |  | 0
17 | 2020 | 11 | 1718267. |  | 6761336 | 6307335.91 | 454000.09 | 0.067146 |  | 0
17 | 2020 | 12 | 1718267. |  | 6663813 | 6663813 | 0 | 0 |  | -454000.09
17 | 2020 | 5 | 1720085. |  | 16500 | 11159.59 | 5340.41 | 0.323661
17 | 2020 | 6 | 1720085. |  | 16500 | 11159.59 | 5340.41 | 0.323661
17 | 2020 | 7 | 1720085. |  | 16500 | 11159.59 | 5340.41 | 0.323661
17 | 2020 | 8 | 1720085. |  | 16500 | 11159.59 | 5340.41 | 0.323661
17 | 2020 | 9 | 1720085. |  | 16500 | 12923.2 | 3576.8 | 0.216775
17 | 2020 | 10 | 1720085. |  | 16500 | 13340.17 | 3159.83 | 0.191504
17 | 2020 | 11 | 1720085. |  | 16500 | 15095.93 | 1404.07 | 0.085095
17 | 2020 | 12 | 1720085. |  | 16500 | 16113.01 | 386.99 | 0.023453