Spreadsheet: 726582d1617303544-reference-last-time-job-was-written-down-test-book
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Last Month / Year of GP Write Down
 |  |  |  |  |  |  |  |  |  |  | Contract # | Project Name | Year | Month | Amount
 |  |  |  |  |  |  |  |  |  |  | 6101099 | Project 1 |  | 12 |  |  | Looking to return the last Year/Month that GP was written down
 |  |  |  |  |  |  |  |  |  |  | 6101088 | Project 2 |  | 1 |  |  | Column J must be less than $0
 |  |  |  |  |  |  |  |  |  |  | 6101093 | Project 3 |  | 5
company | wipYear | wipMonth | Contract | ContractDescription | RevenueEstimateComplete_ToDate | CostEstimateComplete_ToDate | gpAmt | gpPerc | Month Over Month
10 | 2019 | 10 | 6101099 | Project 1 | 802382.11 | 969958.14 | -167576.03 | -0.208848
10 | 2019 | 11 | 6101099 | Project 1 | 802382.11 | 969958.14 | -167576.03 | -0.208848
10 | 2019 | 12 | 6101099 | Project 1 | 790975.59 | 969958.14 | -178982.55 | -0.22628 |  |  | Last time it was written down was 12 / 2019
10 | 2020 | 1 | 6101099 | Project 1 | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 2 | 6101099 | Project 1 | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 3 | 6101099 | Project 1 | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 4 | 6101099 | Project 1 | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 5 | 6101099 | Project 1 | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 6 | 6101099 | Project 1 | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 7 | 6101099 | Project 1 | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 8 | 6101099 | Project 1 | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 9 | 6101099 | Project 1 | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 10 | 6101099 | Project 1 | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 11 | 6101099 | Project 1 | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2020 | 12 | 6101099 | Project 1 | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2021 | 1 | 6101099 | Project 1 | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2021 | 2 | 6101099 | Project 1 | 790975.59 | 969958.14 | -178982.55 | -0.22628
10 | 2019 | 10 | 6101088 | Project 2 | 7032870 | 7530294.91 | -497424.91 | -0.070728
10 | 2019 | 11 | 6101088 | Project 2 | 7090971 | 7604961.39 | -513990.39 | -0.072485
10 | 2019 | 12 | 6101088 | Project 2 | 7190991 | 8111805.12 | -920814.12 | -0.128051
10 | 2020 | 1 | 6101088 | Project 2 | 7232598 | 8160187.07 | -927589.07 | -0.128251
10 | 2020 | 2 | 6101088 | Project 2 | 7235869 | 8160573.57 | -924704.57 | -0.127794
10 | 2020 | 3 | 6101088 | Project 2 | 7366451 | 8297794.04 | -931343.04 | -0.12643
10 | 2020 | 4 | 6101088 | Project 2 | 7403340 | 8328429.07 | -925089.07 | -0.124955
10 | 2020 | 5 | 6101088 | Project 2 | 7435861 | 8376223.56 | -940362.56 | -0.126463
10 | 2020 | 6 | 6101088 | Project 2 | 7435861 | 8402601.93 | -966740.93 | -0.13001
10 | 2020 | 7 | 6101088 | Project 2 | 7402040 | 8543628.92 | -1141588.92 | -0.154226
10 | 2020 | 8 | 6101088 | Project 2 | 7402040 | 8643629.24 | -1241589.24 | -0.167736
10 | 2020 | 9 | 6101088 | Project 2 | 7402040 | 8682142.06 | -1280102.06 | -0.172939
10 | 2020 | 10 | 6101088 | Project 2 | 7646283 | 8715839.02 | -1069556.02 | -0.139879
10 | 2020 | 11 | 6101088 | Project 2 | 7422845 | 8744458.32 | -1321613.32 | -0.178046
10 | 2020 | 12 | 6101088 | Project 2 | 7432503 | 8754116.4 | -1321613.4 | -0.177815
10 | 2021 | 1 | 6101088 | Project 2 | 7452321 | 8837783.19 | -1385462.19 | -0.18591 |  |  | Last time written down was 1 / 21
10 | 2021 | 2 | 6101088 | Project 2 | 7520271 | 8905710.08 | -1385439.08 | -0.184227
10 | 2019 | 10 | 6101093 | Project 3 | 1671366.63 | 1549414 | 121952.63 | 0.072965
10 | 2019 | 11 | 6101093 | Project 3 | 1671366.63 | 1549414 | 121952.63 | 0.072965
10 | 2019 | 12 | 6101093 | Project 3 | 1671366.63 | 1549414 | 121952.63 | 0.072965
10 | 2020 | 1 | 6101093 | Project 3 | 1671366.63 | 1549414 | 121952.63 | 0.072965
10 | 2020 | 2 | 6101093 | Project 3 | 1671366.63 | 1549414 | 121952.63 | 0.072965
10 | 2020 | 3 | 6101093 | Project 3 | 1671366.63 | 1549414 | 121952.63 | 0.072965
10 | 2020 | 4 | 6101093 | Project 3 | 1671366.63 | 1549414 | 121952.63 | 0.072965
10 | 2020 | 5 | 6101093 | Project 3 | 1671366.63 | 1564414.62 | 106952.01 | 0.06399 |  |  | Last time written down was 5 / 2020