{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Master Project List","References"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Master Project List","index":0,"n_rows":114,"n_cols":31,"rows_kept":114,"cut":false,"hidden":false,"merged":[[1,0,1,2],[2,0,2,2],[0,0,0,2]]}
["Master Project List",null,null,"Legend:",null,"DO NOT INPUT DATA IN THESE COLUMNS!!!"]
["Total Number of Projects:",null,null,{"$f":"COUNTA($B$6:$B$219)","v":98},null,"PMs input data in these columns"]
["Number of Projects Visible:",null,null,{"$f":"_xlfn.AGGREGATE(3,5,B6:B219)","v":98},null,"Chris inputs data in these columns"]
[]
["Fiscal Year","Project Number","Client Name","Project Name","Services","Project Type/Phase","Project Sponsor ","Project Manager","Project Coordinator","Project Level","R&D IRAP","Set Budget","Budget UTD","Last Updated","Budget Progress","Scope Progress","Projected Cost","Projected Over/Under","Final Over/Under","Final Budget Status","Project Health","Total Hours","Billing Type","Start Date","Scheduled End Date","Date of Final Invoice","Project Status","Duration","Overage Instruction","Notes"]
[{"$f":"IFERROR(IF(X6=\"\",\"\",YEAR(X6)+IF(MONTH(X6)>=11,1,0)),\"\")","v":2023},2021023,"Canada","MOP 2023","Wastewater","Construction","Jennifer","Harry","Josh","Level 3",null,801264,345960,"2023-03-27T18:46:52",{"$f":"IFERROR(M6/L6,\"\")","v":0.43176780686515304},0.15,{"$f":"IF(P6=\"\",\"-\",M6+((L6*(1-P6))))","v":1027034.4},{"$f":"IFERROR(L6-Q6,\"\")","v":-225770.40000000002},{"$f":"IFERROR(_xlfn.IFS(AA6=\"Ongoing\", \"\", W6=\"hourly\", 0,OR(L6=\"\",M6=\"\"),\"\",AA6=\"Complete\", L6-M6,AA6<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S6=\"\",'Master Project List'!$AA6<>\"Complete\"),\"\",_xlfn.IFS(AA6<>\"Complete\",\"-\",L6-M6<0,\"OVER\",AND(S6=\"\",AA6=\"Complete\"),\"N/A\", AND(L6=\"\",M6=\"\"),\"\", W6=\"\",\"\",S6=\"\",\"On Budget\",  S6=0, \"On Budget\", S6=\"\",\"\",S6<0, \"OVER\",AND(S6>0, AA6=\"complete\"), \"UNDER\",AND(S6>0, AA6<>\"complete\"),\"-\"))","v":""},null,null,"Milestone","2023-01-01","2023-12-31",null,"Ongoing",{"$f":"IFERROR(IF(AND(X6=\"\",Z6=\"\"),\"\", WEEKNUM(_xlfn.DAYS(Z6,X6))),\"\")","v":""}]
[2022,2018019,"Tajikistan","48 Avenue Paving 2022","Construction","Construction","Lisa","Lisa",null,null,null,229080,438019,"2023-03-27T18:53:10",1.9120787497817355,null,{"$f":"IF(P7=\"\",\"-\",M7+((L7*(1-P7))))","v":"-"},{"$f":"IFERROR(L7-Q7,\"\")","v":""},{"$f":"IFERROR(_xlfn.IFS(AA7=\"Ongoing\", \"\", W7=\"hourly\", 0,OR(L7=\"\",M7=\"\"),\"\",AA7=\"Complete\", L7-M7,AA7<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S7=\"\",'Master Project List'!$AA7<>\"Complete\"),\"\",_xlfn.IFS(AA7<>\"Complete\",\"-\",L7-M7<0,\"OVER\",AND(S7=\"\",AA7=\"Complete\"),\"N/A\", AND(L7=\"\",M7=\"\"),\"\", W7=\"\",\"\",S7=\"\",\"On Budget\",  S7=0, \"On Budget\", S7=\"\",\"\",S7<0, \"OVER\",AND(S7>0, AA7=\"complete\"), \"UNDER\",AND(S7>0, AA7<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L7=\"\",M7=\"\"),\"\",AND(V7<>\"\",L7<>\"\",L7<>0),\"TMU\",V7=\"\",\"Milestone\",V7<>\"\",\"Hourly\")","v":"Milestone"},"2022-06-01",null,null,{"$f":"_xlfn.IFS(X7=\"\", \"\", X7<>\"\", IF(Z7=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2022,2019013,"Liberia","Pond C EPEA","Stormwater","EPEA","Sam","Christian",null,"Level 1",null,726167,590646,"2023-03-27T18:47:16",0.81337488484053944,1,{"$f":"IF(P8=\"\",\"-\",M8+((L8*(1-P8))))","v":590646},{"$f":"IFERROR(L8-Q8,\"\")","v":135521},{"$f":"IFERROR(_xlfn.IFS(AA8=\"Ongoing\", \"\", W8=\"hourly\", 0,OR(L8=\"\",M8=\"\"),\"\",AA8=\"Complete\", L8-M8,AA8<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S8=\"\",'Master Project List'!$AA8<>\"Complete\"),\"\",_xlfn.IFS(AA8<>\"Complete\",\"-\",L8-M8<0,\"OVER\",AND(S8=\"\",AA8=\"Complete\"),\"N/A\", AND(L8=\"\",M8=\"\"),\"\", W8=\"\",\"\",S8=\"\",\"On Budget\",  S8=0, \"On Budget\", S8=\"\",\"\",S8<0, \"OVER\",AND(S8>0, AA8=\"complete\"), \"UNDER\",AND(S8>0, AA8<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L8=\"\",M8=\"\"),\"\",AND(V8<>\"\",L8<>\"\",L8<>0),\"TMU\",V8=\"\",\"Milestone\",V8<>\"\",\"Hourly\")","v":"Milestone"},"2022-04-01",null,null,{"$f":"_xlfn.IFS(X8=\"\", \"\", X8<>\"\", IF(Z8=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2022,2019013,"Liechtenstein","Pond C DD","Stormwater","DD","Sam","Sam",null,"Level 3",null,413673,722003,"2023-03-27T18:51:57",1.7453471703495274,0.25,{"$f":"IF(P9=\"\",\"-\",M9+((L9*(1-P9))))","v":1032257.75},{"$f":"IFERROR(L9-Q9,\"\")","v":-618584.75},{"$f":"IFERROR(_xlfn.IFS(AA9=\"Ongoing\", \"\", W9=\"hourly\", 0,OR(L9=\"\",M9=\"\"),\"\",AA9=\"Complete\", L9-M9,AA9<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S9=\"\",'Master Project List'!$AA9<>\"Complete\"),\"\",_xlfn.IFS(AA9<>\"Complete\",\"-\",L9-M9<0,\"OVER\",AND(S9=\"\",AA9=\"Complete\"),\"N/A\", AND(L9=\"\",M9=\"\"),\"\", W9=\"\",\"\",S9=\"\",\"On Budget\",  S9=0, \"On Budget\", S9=\"\",\"\",S9<0, \"OVER\",AND(S9>0, AA9=\"complete\"), \"UNDER\",AND(S9>0, AA9<>\"complete\"),\"-\"))","v":""},"Healthy",null,{"$f":"_xlfn.IFS(AND(L9=\"\",M9=\"\"),\"\",AND(V9<>\"\",L9<>\"\",L9<>0),\"TMU\",V9=\"\",\"Milestone\",V9<>\"\",\"Hourly\")","v":"Milestone"},"2022-06-01",null,null,{"$f":"_xlfn.IFS(X9=\"\", \"\", X9<>\"\", IF(Z9=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2020,2019024,"Lesotho","Lands","Stormwater","SMDP","Sahil","Sahil",null,"Level 2",null,792819,190843,null,0.24071446320030171,1,{"$f":"IF(P10=\"\",\"-\",M10+((L10*(1-P10))))","v":190843},{"$f":"IFERROR(L10-Q10,\"\")","v":601976},{"$f":"IFERROR(_xlfn.IFS(AA10=\"Ongoing\", \"\", W10=\"hourly\", 0,OR(L10=\"\",M10=\"\"),\"\",AA10=\"Complete\", L10-M10,AA10<>\"complete\", \"\"),\"\")","v":601976},{"$f":"IF(AND('Master Project List'!$S10=\"\",'Master Project List'!$AA10<>\"Complete\"),\"\",_xlfn.IFS(AA10<>\"Complete\",\"-\",L10-M10<0,\"OVER\",AND(S10=\"\",AA10=\"Complete\"),\"N/A\", AND(L10=\"\",M10=\"\"),\"\", W10=\"\",\"\",S10=\"\",\"On Budget\",  S10=0, \"On Budget\", S10=\"\",\"\",S10<0, \"OVER\",AND(S10>0, AA10=\"complete\"), \"UNDER\",AND(S10>0, AA10<>\"complete\"),\"-\"))","v":"UNDER"},null,null,{"$f":"_xlfn.IFS(AND(L10=\"\",M10=\"\"),\"\",AND(V10<>\"\",L10<>\"\",L10<>0),\"TMU\",V10=\"\",\"Milestone\",V10<>\"\",\"Hourly\")","v":"Milestone"},"2020-07-01",null,"2021-09-01",{"$f":"_xlfn.IFS(X10=\"\", \"\", X10<>\"\", IF(Z10=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},9]
[2023,2019024,"Laos","EPEA",null,"EPEA","Sam","Sarah",null,null,null,487431,307024,"2023-03-27T18:47:46",0.62988197303823512,0,null,null,null,null,null,null,null,"2023-02-13",null,null,null,""]
[2020,2020008,"Fiji","Planning Mapping (Hourly)","GIS/Mapping","Miscellaneous","Jessica","Jessica",null,"Level 1",null,700097,892141,null,1.2743105598224247,1,{"$f":"IF(P12=\"\",\"-\",M12+((L12*(1-P12))))","v":892141},{"$f":"IFERROR(L12-Q12,\"\")","v":-192044},{"$f":"IFERROR(_xlfn.IFS(AA12=\"Ongoing\", \"\", W12=\"hourly\", 0,OR(L12=\"\",M12=\"\"),\"\",AA12=\"Complete\", L12-M12,AA12<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S12=\"\",'Master Project List'!$AA12<>\"Complete\"),\"\",_xlfn.IFS(AA12<>\"Complete\",\"-\",L12-M12<0,\"OVER\",AND(S12=\"\",AA12=\"Complete\"),\"N/A\", AND(L12=\"\",M12=\"\"),\"\", W12=\"\",\"\",S12=\"\",\"On Budget\",  S12=0, \"On Budget\", S12=\"\",\"\",S12<0, \"OVER\",AND(S12>0, AA12=\"complete\"), \"UNDER\",AND(S12>0, AA12<>\"complete\"),\"-\"))","v":""},null,0.75,{"$f":"_xlfn.IFS(AND(L12=\"\",M12=\"\"),\"\",AND(V12<>\"\",L12<>\"\",L12<>0),\"TMU\",V12=\"\",\"Milestone\",V12<>\"\",\"Hourly\")","v":"TMU"},"2020-02-01",null,null,{"$f":"_xlfn.IFS(X12=\"\", \"\", X12<>\"\", IF(Z12=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2020,2020017,"Laos","Pond E","Stormwater","Construction","Sam","Harry",null,"Level 3",null,452257,870001,"2023-03-27T18:48:03",1.9236871955547399,0.85,937839.55,-485582.55000000005,{"$f":"IFERROR(_xlfn.IFS(AA13=\"Ongoing\", \"\", W13=\"hourly\", 0,OR(L13=\"\",M13=\"\"),\"\",AA13=\"Complete\", L13-M13,AA13<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S13=\"\",'Master Project List'!$AA13<>\"Complete\"),\"\",_xlfn.IFS(AA13<>\"Complete\",\"-\",L13-M13<0,\"OVER\",AND(S13=\"\",AA13=\"Complete\"),\"N/A\", AND(L13=\"\",M13=\"\"),\"\", W13=\"\",\"\",S13=\"\",\"On Budget\",  S13=0, \"On Budget\", S13=\"\",\"\",S13<0, \"OVER\",AND(S13>0, AA13=\"complete\"), \"UNDER\",AND(S13>0, AA13<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L13=\"\",M13=\"\"),\"\",AND(V13<>\"\",L13<>\"\",L13<>0),\"TMU\",V13=\"\",\"Milestone\",V13<>\"\",\"Hourly\")","v":"Milestone"},"2020-05-01",null,null,{"$f":"_xlfn.IFS(X13=\"\", \"\", X13<>\"\", IF(Z13=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2020,2020017,"Laos","Pond E OOS","Stormwater","MAGNA","Sahil","Sahil",null,null,null,220457,560288,null,2.5414842803812081,1,560288,-339831,{"$f":"IFERROR(_xlfn.IFS(AA14=\"Ongoing\", \"\", W14=\"hourly\", 0,OR(L14=\"\",M14=\"\"),\"\",AA14=\"Complete\", L14-M14,AA14<>\"complete\", \"\"),\"\")","v":-339831},{"$f":"IF(AND('Master Project List'!$S14=\"\",'Master Project List'!$AA14<>\"Complete\"),\"\",_xlfn.IFS(AA14<>\"Complete\",\"-\",L14-M14<0,\"OVER\",AND(S14=\"\",AA14=\"Complete\"),\"N/A\", AND(L14=\"\",M14=\"\"),\"\", W14=\"\",\"\",S14=\"\",\"On Budget\",  S14=0, \"On Budget\", S14=\"\",\"\",S14<0, \"OVER\",AND(S14>0, AA14=\"complete\"), \"UNDER\",AND(S14>0, AA14<>\"complete\"),\"-\"))","v":"OVER"},null,307.25,{"$f":"_xlfn.IFS(AND(L14=\"\",M14=\"\"),\"\",AND(V14<>\"\",L14<>\"\",L14<>0),\"TMU\",V14=\"\",\"Milestone\",V14<>\"\",\"Hourly\")","v":"TMU"},"2020-05-01",null,"2022-02-02",{"$f":"_xlfn.IFS(X14=\"\", \"\", X14<>\"\", IF(Z14=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},40]
[2022,2020019,"Dominican Republic","DD","Stormwater","DD","Sam","Sam","Alison","Level 3",null,873485,694854,"2023-03-27T18:48:36",0.79549620199545501,0.7,956899.5,-83414.5,{"$f":"IFERROR(_xlfn.IFS(AA15=\"Ongoing\", \"\", W15=\"hourly\", 0,OR(L15=\"\",M15=\"\"),\"\",AA15=\"Complete\", L15-M15,AA15<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S15=\"\",'Master Project List'!$AA15<>\"Complete\"),\"\",_xlfn.IFS(AA15<>\"Complete\",\"-\",L15-M15<0,\"OVER\",AND(S15=\"\",AA15=\"Complete\"),\"N/A\", AND(L15=\"\",M15=\"\"),\"\", W15=\"\",\"\",S15=\"\",\"On Budget\",  S15=0, \"On Budget\", S15=\"\",\"\",S15<0, \"OVER\",AND(S15>0, AA15=\"complete\"), \"UNDER\",AND(S15>0, AA15<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L15=\"\",M15=\"\"),\"\",AND(V15<>\"\",L15<>\"\",L15<>0),\"TMU\",V15=\"\",\"Milestone\",V15<>\"\",\"Hourly\")","v":{"$error":"#NAME?"}},"2022-04-01","2023-04-01",null,{"$f":"_xlfn.IFS(X15=\"\", \"\", X15<>\"\", IF(Z15=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2022,2020019,"Dominica","OOS","Stormwater","DD","Sam","Sam",null,"Level 3",null,217685,631883,null,2.9027401979925123,0.55000000000000004,729841.25,-512156.25,{"$f":"IFERROR(_xlfn.IFS(AA16=\"Ongoing\", \"\", W16=\"hourly\", 0,OR(L16=\"\",M16=\"\"),\"\",AA16=\"Complete\", L16-M16,AA16<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S16=\"\",'Master Project List'!$AA16<>\"Complete\"),\"\",_xlfn.IFS(AA16<>\"Complete\",\"-\",L16-M16<0,\"OVER\",AND(S16=\"\",AA16=\"Complete\"),\"N/A\", AND(L16=\"\",M16=\"\"),\"\", W16=\"\",\"\",S16=\"\",\"On Budget\",  S16=0, \"On Budget\", S16=\"\",\"\",S16<0, \"OVER\",AND(S16>0, AA16=\"complete\"), \"UNDER\",AND(S16>0, AA16<>\"complete\"),\"-\"))","v":""},null,0,{"$f":"_xlfn.IFS(AND(L16=\"\",M16=\"\"),\"\",AND(V16<>\"\",L16<>\"\",L16<>0),\"TMU\",V16=\"\",\"Milestone\",V16<>\"\",\"Hourly\")","v":"TMU"},"2022-05-15","2023-08-01",null,{"$f":"_xlfn.IFS(X16=\"\", \"\", X16<>\"\", IF(Z16=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2022,2020026,"Guatemala","SMDP","Stormwater","Concept Design","Sahil","Jen T",null,"Level 2",null,771724,332338,null,0.43064359797025881,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA17=\"Ongoing\", \"\", W17=\"hourly\", 0,OR(L17=\"\",M17=\"\"),\"\",AA17=\"Complete\", L17-M17,AA17<>\"complete\", \"\"),\"\")","v":439386},{"$f":"IF(AND('Master Project List'!$S17=\"\",'Master Project List'!$AA17<>\"Complete\"),\"\",_xlfn.IFS(AA17<>\"Complete\",\"-\",L17-M17<0,\"OVER\",AND(S17=\"\",AA17=\"Complete\"),\"N/A\", AND(L17=\"\",M17=\"\"),\"\", W17=\"\",\"\",S17=\"\",\"On Budget\",  S17=0, \"On Budget\", S17=\"\",\"\",S17<0, \"OVER\",AND(S17>0, AA17=\"complete\"), \"UNDER\",AND(S17>0, AA17<>\"complete\"),\"-\"))","v":"UNDER"},null,null,{"$f":"_xlfn.IFS(AND(L17=\"\",M17=\"\"),\"\",AND(V17<>\"\",L17<>\"\",L17<>0),\"TMU\",V17=\"\",\"Milestone\",V17<>\"\",\"Hourly\")","v":"Milestone"},"2022-03-01","2022-09-30","2022-08-01",{"$f":"_xlfn.IFS(X17=\"\", \"\", X17<>\"\", IF(Z17=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},22]
[2022,2020026,"Germany","DD","Stormwater","Stormwater","Aaron","Aaron","JT","Level 3",null,790090,686756,"2023-03-27T18:49:01",0.86921236821121639,0.05,null,null,null,{"$f":"IF(AND('Master Project List'!$S18=\"\",'Master Project List'!$AA18<>\"Complete\"),\"\",_xlfn.IFS(AA18<>\"Complete\",\"-\",L18-M18<0,\"OVER\",AND(S18=\"\",AA18=\"Complete\"),\"N/A\", AND(L18=\"\",M18=\"\"),\"\", W18=\"\",\"\",S18=\"\",\"On Budget\",  S18=0, \"On Budget\", S18=\"\",\"\",S18<0, \"OVER\",AND(S18>0, AA18=\"complete\"), \"UNDER\",AND(S18>0, AA18<>\"complete\"),\"-\"))","v":""},null,null,"Milestone","2022-10-04",null,null,null,""]
[2021,2020032,"Denmark","Pond 2B LA Coordination","Construction","Construction","Sahil","Danika",null,"Level 3",null,701640,96703,"2023-03-27T18:55:54",0.13782424035117724,null,{"$f":"IF(P19=\"\",\"-\",M19+((L19*(1-P19))))","v":"-"},{"$f":"IFERROR(L19-Q19,\"\")","v":""},{"$f":"IFERROR(_xlfn.IFS(AA19=\"Ongoing\", \"\", W19=\"hourly\", 0,OR(L19=\"\",M19=\"\"),\"\",AA19=\"Complete\", L19-M19,AA19<>\"complete\", \"\"),\"\")","v":604937},{"$f":"IF(AND('Master Project List'!$S19=\"\",'Master Project List'!$AA19<>\"Complete\"),\"\",_xlfn.IFS(AA19<>\"Complete\",\"-\",L19-M19<0,\"OVER\",AND(S19=\"\",AA19=\"Complete\"),\"N/A\", AND(L19=\"\",M19=\"\"),\"\", W19=\"\",\"\",S19=\"\",\"On Budget\",  S19=0, \"On Budget\", S19=\"\",\"\",S19<0, \"OVER\",AND(S19>0, AA19=\"complete\"), \"UNDER\",AND(S19>0, AA19<>\"complete\"),\"-\"))","v":"UNDER"},null,null,{"$f":"_xlfn.IFS(AND(L19=\"\",M19=\"\"),\"\",AND(V19<>\"\",L19<>\"\",L19<>0),\"TMU\",V19=\"\",\"Milestone\",V19<>\"\",\"Hourly\")","v":"Milestone"},"2021-08-01",null,"2023-01-01",{"$f":"_xlfn.IFS(X19=\"\", \"\", X19<>\"\", IF(Z19=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},22]
[2022,2020032,"Denmark","Pond 2B CM (2022)","Construction","Construction","Sahil","Hussein",null,"Level 3",null,333549,593465,null,1.7792438292424801,0.7,{"$f":"IF(P20=\"\",\"-\",M20+((L20*(1-P20))))","v":693529.7},{"$f":"IFERROR(L20-Q20,\"\")","v":-359980.69999999995},{"$f":"IFERROR(_xlfn.IFS(AA20=\"Ongoing\", \"\", W20=\"hourly\", 0,OR(L20=\"\",M20=\"\"),\"\",AA20=\"Complete\", L20-M20,AA20<>\"complete\", \"\"),\"\")","v":-259916},{"$f":"IF(AND('Master Project List'!$S20=\"\",'Master Project List'!$AA20<>\"Complete\"),\"\",_xlfn.IFS(AA20<>\"Complete\",\"-\",L20-M20<0,\"OVER\",AND(S20=\"\",AA20=\"Complete\"),\"N/A\", AND(L20=\"\",M20=\"\"),\"\", W20=\"\",\"\",S20=\"\",\"On Budget\",  S20=0, \"On Budget\", S20=\"\",\"\",S20<0, \"OVER\",AND(S20>0, AA20=\"complete\"), \"UNDER\",AND(S20>0, AA20<>\"complete\"),\"-\"))","v":"OVER"},null,null,{"$f":"_xlfn.IFS(AND(L20=\"\",M20=\"\"),\"\",AND(V20<>\"\",L20<>\"\",L20<>0),\"TMU\",V20=\"\",\"Milestone\",V20<>\"\",\"Hourly\")","v":"Milestone"},"2022-01-01","2022-12-31","2022-12-01",{"$f":"_xlfn.IFS(X20=\"\", \"\", X20<>\"\", IF(Z20=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},48]
[2023,2020032,"Dominican Republic","Pond 2B CM (2023)","Construction","Construction","Sam","Harry","Hannah","Level 3",null,494327,950788,null,1.9233988837348557,null,null,null,null,null,null,null,"Milestone","2023-01-01","2023-12-31",null,"Ongoing",""]
[2021,2020036,"Switzerland","Drought Resilient LID - Phase 2","Stormwater","Miscellaneous","Anton","Jen T",null,"Level 1",null,917051,418982,null,0.45687971552290985,null,{"$f":"IF(P22=\"\",\"-\",M22+((L22*(1-P22))))","v":"-"},{"$f":"IFERROR(L22-Q22,\"\")","v":""},{"$f":"IFERROR(_xlfn.IFS(AA22=\"Ongoing\", \"\", W22=\"hourly\", 0,OR(L22=\"\",M22=\"\"),\"\",AA22=\"Complete\", L22-M22,AA22<>\"complete\", \"\"),\"\")","v":498069},{"$f":"IF(AND('Master Project List'!$S22=\"\",'Master Project List'!$AA22<>\"Complete\"),\"\",_xlfn.IFS(AA22<>\"Complete\",\"-\",L22-M22<0,\"OVER\",AND(S22=\"\",AA22=\"Complete\"),\"N/A\", AND(L22=\"\",M22=\"\"),\"\", W22=\"\",\"\",S22=\"\",\"On Budget\",  S22=0, \"On Budget\", S22=\"\",\"\",S22<0, \"OVER\",AND(S22>0, AA22=\"complete\"), \"UNDER\",AND(S22>0, AA22<>\"complete\"),\"-\"))","v":"UNDER"},null,0,{"$f":"_xlfn.IFS(AND(L22=\"\",M22=\"\"),\"\",AND(V22<>\"\",L22<>\"\",L22<>0),\"TMU\",V22=\"\",\"Milestone\",V22<>\"\",\"Hourly\")","v":"TMU"},"2021-01-01","2021-06-04","2022-10-01","Complete",40]
[2022,2020039,"Liberia","Pond G Construction","Construction","Construction","Sam","Harry","Alison","Level 2",null,936014,73435,"2023-03-27T18:49:09",7.8455023108628716E-2,0.6,447840.60000000003,488173.39999999997,{"$f":"IFERROR(_xlfn.IFS(AA23=\"Ongoing\", \"\", W23=\"hourly\", 0,OR(L23=\"\",M23=\"\"),\"\",AA23=\"Complete\", L23-M23,AA23<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S23=\"\",'Master Project List'!$AA23<>\"Complete\"),\"\",_xlfn.IFS(AA23<>\"Complete\",\"-\",L23-M23<0,\"OVER\",AND(S23=\"\",AA23=\"Complete\"),\"N/A\", AND(L23=\"\",M23=\"\"),\"\", W23=\"\",\"\",S23=\"\",\"On Budget\",  S23=0, \"On Budget\", S23=\"\",\"\",S23<0, \"OVER\",AND(S23>0, AA23=\"complete\"), \"UNDER\",AND(S23>0, AA23<>\"complete\"),\"-\"))","v":""},"Not Awesome",null,{"$f":"_xlfn.IFS(AND(L23=\"\",M23=\"\"),\"\",AND(V23<>\"\",L23<>\"\",L23<>0),\"TMU\",V23=\"\",\"Milestone\",V23<>\"\",\"Hourly\")","v":"Milestone"},"2022-04-01",null,null,{"$f":"_xlfn.IFS(X23=\"\", \"\", X23<>\"\", IF(Z23=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2022,2021001,"Lithuania","Rangeview","Stormwater","EPEA","Sahil","Christian",null,"Level 1",null,340050,104246,null,0.30656079988237023,1,104246,235804,{"$f":"IFERROR(_xlfn.IFS(AA24=\"Ongoing\", \"\", W24=\"hourly\", 0,OR(L24=\"\",M24=\"\"),\"\",AA24=\"Complete\", L24-M24,AA24<>\"complete\", \"\"),\"\")","v":235804},{"$f":"IF(AND('Master Project List'!$S24=\"\",'Master Project List'!$AA24<>\"Complete\"),\"\",_xlfn.IFS(AA24<>\"Complete\",\"-\",L24-M24<0,\"OVER\",AND(S24=\"\",AA24=\"Complete\"),\"N/A\", AND(L24=\"\",M24=\"\"),\"\", W24=\"\",\"\",S24=\"\",\"On Budget\",  S24=0, \"On Budget\", S24=\"\",\"\",S24<0, \"OVER\",AND(S24>0, AA24=\"complete\"), \"UNDER\",AND(S24>0, AA24<>\"complete\"),\"-\"))","v":"UNDER"},null,null,{"$f":"_xlfn.IFS(AND(L24=\"\",M24=\"\"),\"\",AND(V24<>\"\",L24<>\"\",L24<>0),\"TMU\",V24=\"\",\"Milestone\",V24<>\"\",\"Hourly\")","v":"Milestone"},"2022-04-01","2023-02-17","2023-02-01",{"$f":"_xlfn.IFS(X24=\"\", \"\", X24<>\"\", IF(Z24=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},44,null,"Project is done, but not fully invoiced."]
[2023,2021006,"Central African Republic","CM Services","Wastewater","Construction","Jennifer","Harry","JT","Level 3",null,819037,258244,"2023-03-27T18:55:09",0.31530199490377114,0.25,872521.75,-53484.75,null,null,"Healthy",null,"Milestone","2022-12-19",null,null,null,""]
[2022,2021006,"Chad","Pilot Facility (2022)","Wastewater","DD","Jenn M","Jen T",null,"Level 3",null,314439,102793,null,0.32690919383409817,0.6,228568.6,85870.399999999994,{"$f":"IFERROR(_xlfn.IFS(AA26=\"Ongoing\", \"\", W26=\"hourly\", 0,OR(L26=\"\",M26=\"\"),\"\",AA26=\"Complete\", L26-M26,AA26<>\"complete\", \"\"),\"\")","v":211646},{"$f":"IF(AND('Master Project List'!$S26=\"\",'Master Project List'!$AA26<>\"Complete\"),\"\",_xlfn.IFS(AA26<>\"Complete\",\"-\",L26-M26<0,\"OVER\",AND(S26=\"\",AA26=\"Complete\"),\"N/A\", AND(L26=\"\",M26=\"\"),\"\", W26=\"\",\"\",S26=\"\",\"On Budget\",  S26=0, \"On Budget\", S26=\"\",\"\",S26<0, \"OVER\",AND(S26>0, AA26=\"complete\"), \"UNDER\",AND(S26>0, AA26<>\"complete\"),\"-\"))","v":"UNDER"},null,null,{"$f":"_xlfn.IFS(AND(L26=\"\",M26=\"\"),\"\",AND(V26<>\"\",L26<>\"\",L26<>0),\"TMU\",V26=\"\",\"Milestone\",V26<>\"\",\"Hourly\")","v":"Milestone"},"2022-01-01","2022-12-31","2023-12-22",{"$f":"_xlfn.IFS(X26=\"\", \"\", X26<>\"\", IF(Z26=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},51]
[2021,2021007,"Denmark","Pond 2B - WIS",null,"Miscellaneous","Sahil","Hussein",null,"Level 2",null,774659,72066,null,9.3029319997573121E-2,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA27=\"Ongoing\", \"\", W27=\"hourly\", 0,OR(L27=\"\",M27=\"\"),\"\",AA27=\"Complete\", L27-M27,AA27<>\"complete\", \"\"),\"\")","v":702593},{"$f":"IF(AND('Master Project List'!$S27=\"\",'Master Project List'!$AA27<>\"Complete\"),\"\",_xlfn.IFS(AA27<>\"Complete\",\"-\",L27-M27<0,\"OVER\",AND(S27=\"\",AA27=\"Complete\"),\"N/A\", AND(L27=\"\",M27=\"\"),\"\", W27=\"\",\"\",S27=\"\",\"On Budget\",  S27=0, \"On Budget\", S27=\"\",\"\",S27<0, \"OVER\",AND(S27>0, AA27=\"complete\"), \"UNDER\",AND(S27>0, AA27<>\"complete\"),\"-\"))","v":"UNDER"},null,null,{"$f":"_xlfn.IFS(AND(L27=\"\",M27=\"\"),\"\",AND(V27<>\"\",L27<>\"\",L27<>0),\"TMU\",V27=\"\",\"Milestone\",V27<>\"\",\"Hourly\")","v":"Milestone"},"2021-01-01","2021-03-12","2021-04-01",{"$f":"_xlfn.IFS(X27=\"\", \"\", X27<>\"\", IF(Z27=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},13]
[2021,2021019,"Latvia","Phase 19 SWMR","Stormwater","SWMR","Sahil","Christian",null,"Level 1",null,566258,590817,null,1.0433706896856203,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA28=\"Ongoing\", \"\", W28=\"hourly\", 0,OR(L28=\"\",M28=\"\"),\"\",AA28=\"Complete\", L28-M28,AA28<>\"complete\", \"\"),\"\")","v":-24559},{"$f":"IF(AND('Master Project List'!$S28=\"\",'Master Project List'!$AA28<>\"Complete\"),\"\",_xlfn.IFS(AA28<>\"Complete\",\"-\",L28-M28<0,\"OVER\",AND(S28=\"\",AA28=\"Complete\"),\"N/A\", AND(L28=\"\",M28=\"\"),\"\", W28=\"\",\"\",S28=\"\",\"On Budget\",  S28=0, \"On Budget\", S28=\"\",\"\",S28<0, \"OVER\",AND(S28>0, AA28=\"complete\"), \"UNDER\",AND(S28>0, AA28<>\"complete\"),\"-\"))","v":"OVER"},null,null,{"$f":"_xlfn.IFS(AND(L28=\"\",M28=\"\"),\"\",AND(V28<>\"\",L28<>\"\",L28<>0),\"TMU\",V28=\"\",\"Milestone\",V28<>\"\",\"Hourly\")","v":"Milestone"},"2021-05-01","2021-06-11","2022-06-01",{"$f":"_xlfn.IFS(X28=\"\", \"\", X28<>\"\", IF(Z28=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},5]
[2022,2021023,"Costa Rica","MOP 2022","Wastewater","Construction","Jenn M","Hussein",null,"Level 3",null,561381,590110,null,1.0511755830710336,0.85,674317.15,-112936.15000000002,{"$f":"IFERROR(_xlfn.IFS(AA29=\"Ongoing\", \"\", W29=\"hourly\", 0,OR(L29=\"\",M29=\"\"),\"\",AA29=\"Complete\", L29-M29,AA29<>\"complete\", \"\"),\"\")","v":-28729},{"$f":"IF(AND('Master Project List'!$S29=\"\",'Master Project List'!$AA29<>\"Complete\"),\"\",_xlfn.IFS(AA29<>\"Complete\",\"-\",L29-M29<0,\"OVER\",AND(S29=\"\",AA29=\"Complete\"),\"N/A\", AND(L29=\"\",M29=\"\"),\"\", W29=\"\",\"\",S29=\"\",\"On Budget\",  S29=0, \"On Budget\", S29=\"\",\"\",S29<0, \"OVER\",AND(S29>0, AA29=\"complete\"), \"UNDER\",AND(S29>0, AA29<>\"complete\"),\"-\"))","v":"OVER"},"Healthy",null,{"$f":"_xlfn.IFS(AND(L29=\"\",M29=\"\"),\"\",AND(V29<>\"\",L29<>\"\",L29<>0),\"TMU\",V29=\"\",\"Milestone\",V29<>\"\",\"Hourly\")","v":"Milestone"},"2022-07-16","2022-12-31","2022-12-22",{"$f":"_xlfn.IFS(X29=\"\", \"\", X29<>\"\", IF(Z29=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},23]
[2021,2021026,"Greece","Sollair Rezoning",null,"SMDP","Sam","Sam",null,"Level 2",null,687075,684647,null,0.99646617909252988,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA30=\"Ongoing\", \"\", W30=\"hourly\", 0,OR(L30=\"\",M30=\"\"),\"\",AA30=\"Complete\", L30-M30,AA30<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S30=\"\",'Master Project List'!$AA30<>\"Complete\"),\"\",_xlfn.IFS(AA30<>\"Complete\",\"-\",L30-M30<0,\"OVER\",AND(S30=\"\",AA30=\"Complete\"),\"N/A\", AND(L30=\"\",M30=\"\"),\"\", W30=\"\",\"\",S30=\"\",\"On Budget\",  S30=0, \"On Budget\", S30=\"\",\"\",S30<0, \"OVER\",AND(S30>0, AA30=\"complete\"), \"UNDER\",AND(S30>0, AA30<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L30=\"\",M30=\"\"),\"\",AND(V30<>\"\",L30<>\"\",L30<>0),\"TMU\",V30=\"\",\"Milestone\",V30<>\"\",\"Hourly\")","v":"Milestone"},"2021-05-01",null,null,{"$f":"_xlfn.IFS(X30=\"\", \"\", X30<>\"\", IF(Z30=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2022,2021027,"Tunisia","Water Reuse Plan",null,"Concept Design","Aaron","JT",null,"Level 1",null,315772,289342,"2023-03-27T18:50:01",0.91630036862039699,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA31=\"Ongoing\", \"\", W31=\"hourly\", 0,OR(L31=\"\",M31=\"\"),\"\",AA31=\"Complete\", L31-M31,AA31<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S31=\"\",'Master Project List'!$AA31<>\"Complete\"),\"\",_xlfn.IFS(AA31<>\"Complete\",\"-\",L31-M31<0,\"OVER\",AND(S31=\"\",AA31=\"Complete\"),\"N/A\", AND(L31=\"\",M31=\"\"),\"\", W31=\"\",\"\",S31=\"\",\"On Budget\",  S31=0, \"On Budget\", S31=\"\",\"\",S31<0, \"OVER\",AND(S31>0, AA31=\"complete\"), \"UNDER\",AND(S31>0, AA31<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L31=\"\",M31=\"\"),\"\",AND(V31<>\"\",L31<>\"\",L31<>0),\"TMU\",V31=\"\",\"Milestone\",V31<>\"\",\"Hourly\")","v":"Milestone"},"2022-05-30",null,null,{"$f":"_xlfn.IFS(X31=\"\", \"\", X31<>\"\", IF(Z31=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2021,2021029,"Lebanon","Phase 27","Stormwater","Work Plan/Proposal","Sahil","Christian",null,"Level 1",null,35035,38846,null,1.108776937348366,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA32=\"Ongoing\", \"\", W32=\"hourly\", 0,OR(L32=\"\",M32=\"\"),\"\",AA32=\"Complete\", L32-M32,AA32<>\"complete\", \"\"),\"\")","v":-3811},{"$f":"IF(AND('Master Project List'!$S32=\"\",'Master Project List'!$AA32<>\"Complete\"),\"\",_xlfn.IFS(AA32<>\"Complete\",\"-\",L32-M32<0,\"OVER\",AND(S32=\"\",AA32=\"Complete\"),\"N/A\", AND(L32=\"\",M32=\"\"),\"\", W32=\"\",\"\",S32=\"\",\"On Budget\",  S32=0, \"On Budget\", S32=\"\",\"\",S32<0, \"OVER\",AND(S32>0, AA32=\"complete\"), \"UNDER\",AND(S32>0, AA32<>\"complete\"),\"-\"))","v":"OVER"},null,null,{"$f":"_xlfn.IFS(AND(L32=\"\",M32=\"\"),\"\",AND(V32<>\"\",L32<>\"\",L32<>0),\"TMU\",V32=\"\",\"Milestone\",V32<>\"\",\"Hourly\")","v":"Milestone"},"2021-02-01",null,"2022-03-01",{"$f":"_xlfn.IFS(X32=\"\", \"\", X32<>\"\", IF(Z32=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},5]
[2022,2021051,"Kenya","SWM Update Ph 2","Stormwater","Stormwater","Aaron","Jessica","Hannah","Level 1",null,127761,709712,null,5.5549972213742844,0.7,748040.3,-620279.30000000005,{"$f":"IFERROR(_xlfn.IFS(AA33=\"Ongoing\", \"\", W33=\"hourly\", 0,OR(L33=\"\",M33=\"\"),\"\",AA33=\"Complete\", L33-M33,AA33<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S33=\"\",'Master Project List'!$AA33<>\"Complete\"),\"\",_xlfn.IFS(AA33<>\"Complete\",\"-\",L33-M33<0,\"OVER\",AND(S33=\"\",AA33=\"Complete\"),\"N/A\", AND(L33=\"\",M33=\"\"),\"\", W33=\"\",\"\",S33=\"\",\"On Budget\",  S33=0, \"On Budget\", S33=\"\",\"\",S33<0, \"OVER\",AND(S33>0, AA33=\"complete\"), \"UNDER\",AND(S33>0, AA33<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L33=\"\",M33=\"\"),\"\",AND(V33<>\"\",L33<>\"\",L33<>0),\"TMU\",V33=\"\",\"Milestone\",V33<>\"\",\"Hourly\")","v":"Milestone"},"2021-11-29",null,null,{"$f":"_xlfn.IFS(X33=\"\", \"\", X33<>\"\", IF(Z33=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2022,2021052,"Denmark","Irrigation Deployment - 2022","Stormwater","Construction","Anton","Hussein",null,"Level 1",null,956103,735455,null,0.7692215169286154,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA34=\"Ongoing\", \"\", W34=\"hourly\", 0,OR(L34=\"\",M34=\"\"),\"\",AA34=\"Complete\", L34-M34,AA34<>\"complete\", \"\"),\"\")","v":220648},{"$f":"IF(AND('Master Project List'!$S34=\"\",'Master Project List'!$AA34<>\"Complete\"),\"\",_xlfn.IFS(AA34<>\"Complete\",\"-\",L34-M34<0,\"OVER\",AND(S34=\"\",AA34=\"Complete\"),\"N/A\", AND(L34=\"\",M34=\"\"),\"\", W34=\"\",\"\",S34=\"\",\"On Budget\",  S34=0, \"On Budget\", S34=\"\",\"\",S34<0, \"OVER\",AND(S34>0, AA34=\"complete\"), \"UNDER\",AND(S34>0, AA34<>\"complete\"),\"-\"))","v":"UNDER"},null,163,{"$f":"_xlfn.IFS(AND(L34=\"\",M34=\"\"),\"\",AND(V34<>\"\",L34<>\"\",L34<>0),\"TMU\",V34=\"\",\"Milestone\",V34<>\"\",\"Hourly\")","v":"TMU"},"2022-05-01",null,"2022-10-01",{"$f":"_xlfn.IFS(X34=\"\", \"\", X34<>\"\", IF(Z34=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},22]
["",2021052,"Dominica","Irrigation Deployment - 2023","Stormwater","Construction","Aaron","Harry",null,"Level 1",null,267276,642586,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[2021,2021055,"Wurtemberg","Waterbridge","Stormwater","Concept Design","Sam","Sam",null,"Level 2",null,125461,487746,null,{"$f":"IFERROR(M36/L36,\"\")","v":3.8876304190146738},null,{"$f":"IF(P36=\"\",\"-\",M36+((L36*(1-P36))))","v":"-"},{"$f":"IFERROR(L36-Q36,\"\")","v":""},{"$f":"IFERROR(_xlfn.IFS(AA36=\"Ongoing\", \"\", W36=\"hourly\", 0,OR(L36=\"\",M36=\"\"),\"\",AA36=\"Complete\", L36-M36,AA36<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S36=\"\",'Master Project List'!$AA36<>\"Complete\"),\"\",_xlfn.IFS(AA36<>\"Complete\",\"-\",L36-M36<0,\"OVER\",AND(S36=\"\",AA36=\"Complete\"),\"N/A\", AND(L36=\"\",M36=\"\"),\"\", W36=\"\",\"\",S36=\"\",\"On Budget\",  S36=0, \"On Budget\", S36=\"\",\"\",S36<0, \"OVER\",AND(S36>0, AA36=\"complete\"), \"UNDER\",AND(S36>0, AA36<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L36=\"\",M36=\"\"),\"\",AND(V36<>\"\",L36<>\"\",L36<>0),\"TMU\",V36=\"\",\"Milestone\",V36<>\"\",\"Hourly\")","v":"Milestone"},"2021-09-01",null,null,{"$f":"_xlfn.IFS(X36=\"\", \"\", X36<>\"\", IF(Z36=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2021,2021056,"Zimbabwe","Lands","Stormwater","Concept Design","Sam","Sam","Hannah","Level 2",null,781473,6456,null,8.2613218882802101E-3,0.9,{"$f":"IF(P37=\"\",\"-\",M37+((L37*(1-P37))))","v":84603.299999999988},{"$f":"IFERROR(L37-Q37,\"\")","v":696869.7},{"$f":"IFERROR(_xlfn.IFS(AA37=\"Ongoing\", \"\", W37=\"hourly\", 0,OR(L37=\"\",M37=\"\"),\"\",AA37=\"Complete\", L37-M37,AA37<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S37=\"\",'Master Project List'!$AA37<>\"Complete\"),\"\",_xlfn.IFS(AA37<>\"Complete\",\"-\",L37-M37<0,\"OVER\",AND(S37=\"\",AA37=\"Complete\"),\"N/A\", AND(L37=\"\",M37=\"\"),\"\", W37=\"\",\"\",S37=\"\",\"On Budget\",  S37=0, \"On Budget\", S37=\"\",\"\",S37<0, \"OVER\",AND(S37>0, AA37=\"complete\"), \"UNDER\",AND(S37>0, AA37<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L37=\"\",M37=\"\"),\"\",AND(V37<>\"\",L37<>\"\",L37<>0),\"TMU\",V37=\"\",\"Milestone\",V37<>\"\",\"Hourly\")","v":"Milestone"},"2021-09-01",null,null,{"$f":"_xlfn.IFS(X37=\"\", \"\", X37<>\"\", IF(Z37=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[{"$f":"IFERROR(IF(X38=\"\",\"\",YEAR(X38)+IF(MONTH(X38)>=11,1,0)),\"\")","v":2022},2021058,"Qatar","Glacier","Stormwater","Concept Design","Aaron","Sam","Hannah","Level 2",null,703966,860692,null,1.2226329112485546,0.5,{"$f":"IF(P38=\"\",\"-\",M38+((L38*(1-P38))))","v":1212675},{"$f":"IFERROR(L38-Q38,\"\")","v":-508709},{"$f":"IFERROR(_xlfn.IFS(AA38=\"Ongoing\", \"\", W38=\"hourly\", 0,OR(L38=\"\",M38=\"\"),\"\",AA38=\"Complete\", L38-M38,AA38<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S38=\"\",'Master Project List'!$AA38<>\"Complete\"),\"\",_xlfn.IFS(AA38<>\"Complete\",\"-\",L38-M38<0,\"OVER\",AND(S38=\"\",AA38=\"Complete\"),\"N/A\", AND(L38=\"\",M38=\"\"),\"\", W38=\"\",\"\",S38=\"\",\"On Budget\",  S38=0, \"On Budget\", S38=\"\",\"\",S38<0, \"OVER\",AND(S38>0, AA38=\"complete\"), \"UNDER\",AND(S38>0, AA38<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L38=\"\",M38=\"\"),\"\",AND(V38<>\"\",L38<>\"\",L38<>0),\"TMU\",V38=\"\",\"Milestone\",V38<>\"\",\"Hourly\")","v":"Milestone"},"2022-03-01",null,null,{"$f":"_xlfn.IFS(X38=\"\", \"\", X38<>\"\", IF(Z38=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},{"$f":"IFERROR(IF(AND(X38=\"\",Z38=\"\"),\"\", WEEKNUM(_xlfn.DAYS(Z38,X38))),\"\")","v":""}]
[2022,2021062,"Tanzania","Support for Municipal Engineer","Miscellaneous","Miscellaneous","Jenn M","Jenn M",null,null,null,684197,510727,null,0.74646191082392932,null,null,null,null,{"$f":"IF(AND('Master Project List'!$S39=\"\",'Master Project List'!$AA39<>\"Complete\"),\"\",_xlfn.IFS(AA39<>\"Complete\",\"-\",L39-M39<0,\"OVER\",AND(S39=\"\",AA39=\"Complete\"),\"N/A\", AND(L39=\"\",M39=\"\"),\"\", W39=\"\",\"\",S39=\"\",\"On Budget\",  S39=0, \"On Budget\", S39=\"\",\"\",S39<0, \"OVER\",AND(S39>0, AA39=\"complete\"), \"UNDER\",AND(S39>0, AA39<>\"complete\"),\"-\"))","v":"N/A"},null,null,"TMU","2021-12-01","2022-03-31","2022-02-01",{"$f":"_xlfn.IFS(X39=\"\", \"\", X39<>\"\", IF(Z39=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},9]
[2022,2021064,"Trinidad ","3nd Party Engineering Support","Miscellaneous","Miscellaneous","Jennifer","JT",null,"Level 2",null,419476,716869,null,1.7089630872803212,null,{"$f":"IF(P40=\"\",\"-\",M40+((L40*(1-P40))))","v":"-"},{"$f":"IFERROR(L40-Q40,\"\")","v":""},{"$f":"IFERROR(_xlfn.IFS(AA40=\"Ongoing\", \"\", W40=\"hourly\", 0,OR(L40=\"\",M40=\"\"),\"\",AA40=\"Complete\", L40-M40,AA40<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S40=\"\",'Master Project List'!$AA40<>\"Complete\"),\"\",_xlfn.IFS(AA40<>\"Complete\",\"-\",L40-M40<0,\"OVER\",AND(S40=\"\",AA40=\"Complete\"),\"N/A\", AND(L40=\"\",M40=\"\"),\"\", W40=\"\",\"\",S40=\"\",\"On Budget\",  S40=0, \"On Budget\", S40=\"\",\"\",S40<0, \"OVER\",AND(S40>0, AA40=\"complete\"), \"UNDER\",AND(S40>0, AA40<>\"complete\"),\"-\"))","v":""},null,null,"Milestone","2021-12-01","2022-03-31",null,{"$f":"_xlfn.IFS(X40=\"\", \"\", X40<>\"\", IF(Z40=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2022,2021064,"Tunisia","3rd Party Engineering Support","Miscellaneous","Miscellaneous","Jennifer","JT",null,"Level 2",null,966425,746467,null,0.77240034146467651,null,{"$f":"IF(P41=\"\",\"-\",M41+((L41*(1-P41))))","v":"-"},{"$f":"IFERROR(L41-Q41,\"\")","v":""},{"$f":"IFERROR(_xlfn.IFS(AA41=\"Ongoing\", \"\", W41=\"hourly\", 0,OR(L41=\"\",M41=\"\"),\"\",AA41=\"Complete\", L41-M41,AA41<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S41=\"\",'Master Project List'!$AA41<>\"Complete\"),\"\",_xlfn.IFS(AA41<>\"Complete\",\"-\",L41-M41<0,\"OVER\",AND(S41=\"\",AA41=\"Complete\"),\"N/A\", AND(L41=\"\",M41=\"\"),\"\", W41=\"\",\"\",S41=\"\",\"On Budget\",  S41=0, \"On Budget\", S41=\"\",\"\",S41<0, \"OVER\",AND(S41>0, AA41=\"complete\"), \"UNDER\",AND(S41>0, AA41<>\"complete\"),\"-\"))","v":""},null,28,{"$f":"_xlfn.IFS(AND(L41=\"\",M41=\"\"),\"\",AND(V41<>\"\",L41<>\"\",L41<>0),\"TMU\",V41=\"\",\"Milestone\",V41<>\"\",\"Hourly\")","v":"TMU"},"2021-12-01","2023-01-01",null,{"$f":"_xlfn.IFS(X41=\"\", \"\", X41<>\"\", IF(Z41=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2021,2021068,"Denmark","Pond 2A M&M 2021/2022","Stormwater","M & M","Anton","Jen T",null,"Level 2",null,277266,282546,null,1.0190430849797667,null,{"$f":"IF(P42=\"\",\"-\",M42+((L42*(1-P42))))","v":"-"},{"$f":"IFERROR(L42-Q42,\"\")","v":""},{"$f":"IFERROR(_xlfn.IFS(AA42=\"Ongoing\", \"\", W42=\"hourly\", 0,OR(L42=\"\",M42=\"\"),\"\",AA42=\"Complete\", L42-M42,AA42<>\"complete\", \"\"),\"\")","v":-5280},{"$f":"IF(AND('Master Project List'!$S42=\"\",'Master Project List'!$AA42<>\"Complete\"),\"\",_xlfn.IFS(AA42<>\"Complete\",\"-\",L42-M42<0,\"OVER\",AND(S42=\"\",AA42=\"Complete\"),\"N/A\", AND(L42=\"\",M42=\"\"),\"\", W42=\"\",\"\",S42=\"\",\"On Budget\",  S42=0, \"On Budget\", S42=\"\",\"\",S42<0, \"OVER\",AND(S42>0, AA42=\"complete\"), \"UNDER\",AND(S42>0, AA42<>\"complete\"),\"-\"))","v":"OVER"},null,null,{"$f":"_xlfn.IFS(AND(L42=\"\",M42=\"\"),\"\",AND(V42<>\"\",L42<>\"\",L42<>0),\"TMU\",V42=\"\",\"Milestone\",V42<>\"\",\"Hourly\")","v":"Milestone"},"2021-09-01","2022-11-30","2023-11-22",{"$f":"_xlfn.IFS(X42=\"\", \"\", X42<>\"\", IF(Z42=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},12]
[2023,2021068,"Dominica","Pond 2A M&M 2023","Stormwater","M & M","Sam","Harry","Hannah","Level 2",null,278937,738684,null,null,null,null,null,null,null,null,null,"Milestone","2023-01-01","2023-12-31",null,"Ongoing",""]
[2021,2021069,"Lithuania","Phase 30 SWMR","Stormwater","SWMR","Sahil","Sahil",null,null,null,906812,507961,null,{"$f":"IFERROR(M44/L44,\"\")","v":0.56016131237786881},null,{"$f":"IF(P44=\"\",\"-\",M44+((L44*(1-P44))))","v":"-"},{"$f":"IFERROR(L44-Q44,\"\")","v":""},{"$f":"IFERROR(_xlfn.IFS(AA44=\"Ongoing\", \"\", W44=\"hourly\", 0,OR(L44=\"\",M44=\"\"),\"\",AA44=\"Complete\", L44-M44,AA44<>\"complete\", \"\"),\"\")","v":398851},{"$f":"IF(AND('Master Project List'!$S44=\"\",'Master Project List'!$AA44<>\"Complete\"),\"\",_xlfn.IFS(AA44<>\"Complete\",\"-\",L44-M44<0,\"OVER\",AND(S44=\"\",AA44=\"Complete\"),\"N/A\", AND(L44=\"\",M44=\"\"),\"\", W44=\"\",\"\",S44=\"\",\"On Budget\",  S44=0, \"On Budget\", S44=\"\",\"\",S44<0, \"OVER\",AND(S44>0, AA44=\"complete\"), \"UNDER\",AND(S44>0, AA44<>\"complete\"),\"-\"))","v":"UNDER"},null,null,{"$f":"_xlfn.IFS(AND(L44=\"\",M44=\"\"),\"\",AND(V44<>\"\",L44<>\"\",L44<>0),\"TMU\",V44=\"\",\"Milestone\",V44<>\"\",\"Hourly\")","v":"Milestone"},"2021-08-01","2021-08-31","2022-02-03",{"$f":"_xlfn.IFS(X44=\"\", \"\", X44<>\"\", IF(Z44=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},27]
[2022,2021071,"Tajikistan","Concept Design","Stormwater","Concept Design","Sahil","Sarah",null,"Level 2",null,39744,531053,null,13.36184078099839,1,531053,-491309,{"$f":"IFERROR(_xlfn.IFS(AA45=\"Ongoing\", \"\", W45=\"hourly\", 0,OR(L45=\"\",M45=\"\"),\"\",AA45=\"Complete\", L45-M45,AA45<>\"complete\", \"\"),\"\")","v":-491309},{"$f":"IF(AND('Master Project List'!$S45=\"\",'Master Project List'!$AA45<>\"Complete\"),\"\",_xlfn.IFS(AA45<>\"Complete\",\"-\",L45-M45<0,\"OVER\",AND(S45=\"\",AA45=\"Complete\"),\"N/A\", AND(L45=\"\",M45=\"\"),\"\", W45=\"\",\"\",S45=\"\",\"On Budget\",  S45=0, \"On Budget\", S45=\"\",\"\",S45<0, \"OVER\",AND(S45>0, AA45=\"complete\"), \"UNDER\",AND(S45>0, AA45<>\"complete\"),\"-\"))","v":"OVER"},"Healthy",0,{"$f":"_xlfn.IFS(AND(L45=\"\",M45=\"\"),\"\",AND(V45<>\"\",L45<>\"\",L45<>0),\"TMU\",V45=\"\",\"Milestone\",V45<>\"\",\"Hourly\")","v":"TMU"},"2022-02-28","2022-12-01","2023-08-22",{"$f":"_xlfn.IFS(X45=\"\", \"\", X45<>\"\", IF(Z45=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},26,null,"This project is hourly"]
[2022,2021071,"Tajikistan","SMDP","Stormwater","SMDP","Aaron","Sarah","Alison","Level 2",null,349762,250055,null,0.71492900886888799,0.65,372471.7,-22709.700000000012,{"$f":"IFERROR(_xlfn.IFS(AA46=\"Ongoing\", \"\", W46=\"hourly\", 0,OR(L46=\"\",M46=\"\"),\"\",AA46=\"Complete\", L46-M46,AA46<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S46=\"\",'Master Project List'!$AA46<>\"Complete\"),\"\",_xlfn.IFS(AA46<>\"Complete\",\"-\",L46-M46<0,\"OVER\",AND(S46=\"\",AA46=\"Complete\"),\"N/A\", AND(L46=\"\",M46=\"\"),\"\", W46=\"\",\"\",S46=\"\",\"On Budget\",  S46=0, \"On Budget\", S46=\"\",\"\",S46<0, \"OVER\",AND(S46>0, AA46=\"complete\"), \"UNDER\",AND(S46>0, AA46<>\"complete\"),\"-\"))","v":""},"Healthy",null,{"$f":"_xlfn.IFS(AND(L46=\"\",M46=\"\"),\"\",AND(V46<>\"\",L46<>\"\",L46<>0),\"TMU\",V46=\"\",\"Milestone\",V46<>\"\",\"Hourly\")","v":"Milestone"},"2022-02-28","2023-03-01",null,{"$f":"_xlfn.IFS(X46=\"\", \"\", X46<>\"\", IF(Z46=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2022,2021072,"Luxembourg","Phase 6","Stormwater","Miscellaneous","Sahil","Sahil",null,null,null,645088,695049,null,1.0774483481323478,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA47=\"Ongoing\", \"\", W47=\"hourly\", 0,OR(L47=\"\",M47=\"\"),\"\",AA47=\"Complete\", L47-M47,AA47<>\"complete\", \"\"),\"\")","v":-49961},{"$f":"IF(AND('Master Project List'!$S47=\"\",'Master Project List'!$AA47<>\"Complete\"),\"\",_xlfn.IFS(AA47<>\"Complete\",\"-\",L47-M47<0,\"OVER\",AND(S47=\"\",AA47=\"Complete\"),\"N/A\", AND(L47=\"\",M47=\"\"),\"\", W47=\"\",\"\",S47=\"\",\"On Budget\",  S47=0, \"On Budget\", S47=\"\",\"\",S47<0, \"OVER\",AND(S47>0, AA47=\"complete\"), \"UNDER\",AND(S47>0, AA47<>\"complete\"),\"-\"))","v":"OVER"},null,null,{"$f":"_xlfn.IFS(AND(L47=\"\",M47=\"\"),\"\",AND(V47<>\"\",L47<>\"\",L47<>0),\"TMU\",V47=\"\",\"Milestone\",V47<>\"\",\"Hourly\")","v":"Milestone"},"2022-01-22",null,"Closed",{"$f":"_xlfn.IFS(X47=\"\", \"\", X47<>\"\", IF(Z47=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},""]
[2022,2022001,"Argentina","Shoreline Treatment","Miscellaneous","RFP","Anton","Anton",null,null,null,752938,725167,null,0.96311648502267122,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA48=\"Ongoing\", \"\", W48=\"hourly\", 0,OR(L48=\"\",M48=\"\"),\"\",AA48=\"Complete\", L48-M48,AA48<>\"complete\", \"\"),\"\")","v":27771},{"$f":"IF(AND('Master Project List'!$S48=\"\",'Master Project List'!$AA48<>\"Complete\"),\"\",_xlfn.IFS(AA48<>\"Complete\",\"-\",L48-M48<0,\"OVER\",AND(S48=\"\",AA48=\"Complete\"),\"N/A\", AND(L48=\"\",M48=\"\"),\"\", W48=\"\",\"\",S48=\"\",\"On Budget\",  S48=0, \"On Budget\", S48=\"\",\"\",S48<0, \"OVER\",AND(S48>0, AA48=\"complete\"), \"UNDER\",AND(S48>0, AA48<>\"complete\"),\"-\"))","v":"UNDER"},null,null,{"$f":"_xlfn.IFS(AND(L48=\"\",M48=\"\"),\"\",AND(V48<>\"\",L48<>\"\",L48<>0),\"TMU\",V48=\"\",\"Milestone\",V48<>\"\",\"Hourly\")","v":"Milestone"},"2022-02-23",null,"2022-06-01",{"$f":"_xlfn.IFS(X48=\"\", \"\", X48<>\"\", IF(Z48=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},14,null,null,"IF A PROJECT IS HOURLY, PLEASE ADD THE CURRENT TOTAL HOURS TO CHANGE THE BILLING TYPE"]
[2022,2022004,"Lithuania","Phase 33 SWMR","Stormwater","SWMR","Sahil","Christian",null,"Level 1",null,809192,352864,null,0.4360695607470168,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA49=\"Ongoing\", \"\", W49=\"hourly\", 0,OR(L49=\"\",M49=\"\"),\"\",AA49=\"Complete\", L49-M49,AA49<>\"complete\", \"\"),\"\")","v":456328},{"$f":"IF(AND('Master Project List'!$S49=\"\",'Master Project List'!$AA49<>\"Complete\"),\"\",_xlfn.IFS(AA49<>\"Complete\",\"-\",L49-M49<0,\"OVER\",AND(S49=\"\",AA49=\"Complete\"),\"N/A\", AND(L49=\"\",M49=\"\"),\"\", W49=\"\",\"\",S49=\"\",\"On Budget\",  S49=0, \"On Budget\", S49=\"\",\"\",S49<0, \"OVER\",AND(S49>0, AA49=\"complete\"), \"UNDER\",AND(S49>0, AA49<>\"complete\"),\"-\"))","v":"UNDER"},null,null,{"$f":"_xlfn.IFS(AND(L49=\"\",M49=\"\"),\"\",AND(V49<>\"\",L49<>\"\",L49<>0),\"TMU\",V49=\"\",\"Milestone\",V49<>\"\",\"Hourly\")","v":"Milestone"},"2022-01-01",null,"2022-04-21",{"$f":"_xlfn.IFS(X49=\"\", \"\", X49<>\"\", IF(Z49=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},16]
[2022,2022005,"Democratic Republic of the Congo","Pond 2A CCC Submission","Stormwater","Miscellaneous","Jenn M","Danika",null,null,null,639218,541191,null,0.84664543238769874,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA50=\"Ongoing\", \"\", W50=\"hourly\", 0,OR(L50=\"\",M50=\"\"),\"\",AA50=\"Complete\", L50-M50,AA50<>\"complete\", \"\"),\"\")","v":98027},{"$f":"IF(AND('Master Project List'!$S50=\"\",'Master Project List'!$AA50<>\"Complete\"),\"\",_xlfn.IFS(AA50<>\"Complete\",\"-\",L50-M50<0,\"OVER\",AND(S50=\"\",AA50=\"Complete\"),\"N/A\", AND(L50=\"\",M50=\"\"),\"\", W50=\"\",\"\",S50=\"\",\"On Budget\",  S50=0, \"On Budget\", S50=\"\",\"\",S50<0, \"OVER\",AND(S50>0, AA50=\"complete\"), \"UNDER\",AND(S50>0, AA50<>\"complete\"),\"-\"))","v":"UNDER"},null,238.5,{"$f":"_xlfn.IFS(AND(L50=\"\",M50=\"\"),\"\",AND(V50<>\"\",L50<>\"\",L50<>0),\"TMU\",V50=\"\",\"Milestone\",V50<>\"\",\"Hourly\")","v":"TMU"},"2022-01-01",null,"2022-04-06",{"$f":"_xlfn.IFS(X50=\"\", \"\", X50<>\"\", IF(Z50=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},14]
[2022,2022006,"Liberia","Phase 34 SWMR","Stormwater","SWMR","Sahil","Christian",null,null,null,460789,889725,null,1.9308729158031117,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA51=\"Ongoing\", \"\", W51=\"hourly\", 0,OR(L51=\"\",M51=\"\"),\"\",AA51=\"Complete\", L51-M51,AA51<>\"complete\", \"\"),\"\")","v":-428936},{"$f":"IF(AND('Master Project List'!$S51=\"\",'Master Project List'!$AA51<>\"Complete\"),\"\",_xlfn.IFS(AA51<>\"Complete\",\"-\",L51-M51<0,\"OVER\",AND(S51=\"\",AA51=\"Complete\"),\"N/A\", AND(L51=\"\",M51=\"\"),\"\", W51=\"\",\"\",S51=\"\",\"On Budget\",  S51=0, \"On Budget\", S51=\"\",\"\",S51<0, \"OVER\",AND(S51>0, AA51=\"complete\"), \"UNDER\",AND(S51>0, AA51<>\"complete\"),\"-\"))","v":"OVER"},null,null,{"$f":"_xlfn.IFS(AND(L51=\"\",M51=\"\"),\"\",AND(V51<>\"\",L51<>\"\",L51<>0),\"TMU\",V51=\"\",\"Milestone\",V51<>\"\",\"Hourly\")","v":"Milestone"},"2022-01-01",null,"2022-05-01",{"$f":"_xlfn.IFS(X51=\"\", \"\", X51<>\"\", IF(Z51=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},18]
[2022,2022011,"Laos","Plains",null,"Concept Design","Aaron","Sam",null,"Level 2",null,615139,644152,null,1.0471649497105533,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA52=\"Ongoing\", \"\", W52=\"hourly\", 0,OR(L52=\"\",M52=\"\"),\"\",AA52=\"Complete\", L52-M52,AA52<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S52=\"\",'Master Project List'!$AA52<>\"Complete\"),\"\",_xlfn.IFS(AA52<>\"Complete\",\"-\",L52-M52<0,\"OVER\",AND(S52=\"\",AA52=\"Complete\"),\"N/A\", AND(L52=\"\",M52=\"\"),\"\", W52=\"\",\"\",S52=\"\",\"On Budget\",  S52=0, \"On Budget\", S52=\"\",\"\",S52<0, \"OVER\",AND(S52>0, AA52=\"complete\"), \"UNDER\",AND(S52>0, AA52<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L52=\"\",M52=\"\"),\"\",AND(V52<>\"\",L52<>\"\",L52<>0),\"TMU\",V52=\"\",\"Milestone\",V52<>\"\",\"Hourly\")","v":"Milestone"},"2022-02-01",null,null,{"$f":"_xlfn.IFS(X52=\"\", \"\", X52<>\"\", IF(Z52=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2022,2022012,"Wakanda","SMDP","Stormwater","SMDP","Aaron","Sarah","Alison","Level 2",null,745446,717633,null,0.96268945034247955,0.7,941266.8,-195820.80000000005,{"$f":"IFERROR(_xlfn.IFS(AA53=\"Ongoing\", \"\", W53=\"hourly\", 0,OR(L53=\"\",M53=\"\"),\"\",AA53=\"Complete\", L53-M53,AA53<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S53=\"\",'Master Project List'!$AA53<>\"Complete\"),\"\",_xlfn.IFS(AA53<>\"Complete\",\"-\",L53-M53<0,\"OVER\",AND(S53=\"\",AA53=\"Complete\"),\"N/A\", AND(L53=\"\",M53=\"\"),\"\", W53=\"\",\"\",S53=\"\",\"On Budget\",  S53=0, \"On Budget\", S53=\"\",\"\",S53<0, \"OVER\",AND(S53>0, AA53=\"complete\"), \"UNDER\",AND(S53>0, AA53<>\"complete\"),\"-\"))","v":""},"Healthy",null,{"$f":"_xlfn.IFS(AND(L53=\"\",M53=\"\"),\"\",AND(V53<>\"\",L53<>\"\",L53<>0),\"TMU\",V53=\"\",\"Milestone\",V53<>\"\",\"Hourly\")","v":"Milestone"},"2022-02-01","2023-03-01",null,{"$f":"_xlfn.IFS(X53=\"\", \"\", X53<>\"\", IF(Z53=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2022,2022013,"Canada","PH 2 SWMR",null,"SWMR","Sahil","Christian",null,null,null,56895,651506,null,11.451023815801037,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA54=\"Ongoing\", \"\", W54=\"hourly\", 0,OR(L54=\"\",M54=\"\"),\"\",AA54=\"Complete\", L54-M54,AA54<>\"complete\", \"\"),\"\")","v":-594611},{"$f":"IF(AND('Master Project List'!$S54=\"\",'Master Project List'!$AA54<>\"Complete\"),\"\",_xlfn.IFS(AA54<>\"Complete\",\"-\",L54-M54<0,\"OVER\",AND(S54=\"\",AA54=\"Complete\"),\"N/A\", AND(L54=\"\",M54=\"\"),\"\", W54=\"\",\"\",S54=\"\",\"On Budget\",  S54=0, \"On Budget\", S54=\"\",\"\",S54<0, \"OVER\",AND(S54>0, AA54=\"complete\"), \"UNDER\",AND(S54>0, AA54<>\"complete\"),\"-\"))","v":"OVER"},null,null,{"$f":"_xlfn.IFS(AND(L54=\"\",M54=\"\"),\"\",AND(V54<>\"\",L54<>\"\",L54<>0),\"TMU\",V54=\"\",\"Milestone\",V54<>\"\",\"Hourly\")","v":"Milestone"},"2022-02-01",null,"2022-03-01",{"$f":"_xlfn.IFS(X54=\"\", \"\", X54<>\"\", IF(Z54=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},4]
[2022,2022014,"Libya","PH 17","Stormwater","SWMR","Sahil","Christian",null,null,null,401728,426488,null,1.0616337422335511,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA55=\"Ongoing\", \"\", W55=\"hourly\", 0,OR(L55=\"\",M55=\"\"),\"\",AA55=\"Complete\", L55-M55,AA55<>\"complete\", \"\"),\"\")","v":-24760},{"$f":"IF(AND('Master Project List'!$S55=\"\",'Master Project List'!$AA55<>\"Complete\"),\"\",_xlfn.IFS(AA55<>\"Complete\",\"-\",L55-M55<0,\"OVER\",AND(S55=\"\",AA55=\"Complete\"),\"N/A\", AND(L55=\"\",M55=\"\"),\"\", W55=\"\",\"\",S55=\"\",\"On Budget\",  S55=0, \"On Budget\", S55=\"\",\"\",S55<0, \"OVER\",AND(S55>0, AA55=\"complete\"), \"UNDER\",AND(S55>0, AA55<>\"complete\"),\"-\"))","v":"OVER"},null,null,{"$f":"_xlfn.IFS(AND(L55=\"\",M55=\"\"),\"\",AND(V55<>\"\",L55<>\"\",L55<>0),\"TMU\",V55=\"\",\"Milestone\",V55<>\"\",\"Hourly\")","v":"Milestone"},"2022-05-01",null,"2022-09-01",{"$f":"_xlfn.IFS(X55=\"\", \"\", X55<>\"\", IF(Z55=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},18]
[2021,2022016,"Tajikistan","Development Reviews",null,"Miscellaneous","Jenn M","Sahil",null,null,null,317129,811708,null,2.5595514758978206,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA56=\"Ongoing\", \"\", W56=\"hourly\", 0,OR(L56=\"\",M56=\"\"),\"\",AA56=\"Complete\", L56-M56,AA56<>\"complete\", \"\"),\"\")","v":-494579},{"$f":"IF(AND('Master Project List'!$S56=\"\",'Master Project List'!$AA56<>\"Complete\"),\"\",_xlfn.IFS(AA56<>\"Complete\",\"-\",L56-M56<0,\"OVER\",AND(S56=\"\",AA56=\"Complete\"),\"N/A\", AND(L56=\"\",M56=\"\"),\"\", W56=\"\",\"\",S56=\"\",\"On Budget\",  S56=0, \"On Budget\", S56=\"\",\"\",S56<0, \"OVER\",AND(S56>0, AA56=\"complete\"), \"UNDER\",AND(S56>0, AA56<>\"complete\"),\"-\"))","v":"OVER"},null,8.25,{"$f":"_xlfn.IFS(AND(L56=\"\",M56=\"\"),\"\",AND(V56<>\"\",L56<>\"\",L56<>0),\"TMU\",V56=\"\",\"Milestone\",V56<>\"\",\"Hourly\")","v":"TMU"},"2021-02-01",null,"2022-10-01",{"$f":"_xlfn.IFS(X56=\"\", \"\", X56<>\"\", IF(Z56=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},35]
[2022,2022018,"Qatar","Stage 2","Stormwater","SMDP","Anton","Sahil",null,"Level 2",null,18042,281189,null,15.585245538188671,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA57=\"Ongoing\", \"\", W57=\"hourly\", 0,OR(L57=\"\",M57=\"\"),\"\",AA57=\"Complete\", L57-M57,AA57<>\"complete\", \"\"),\"\")","v":-263147},{"$f":"IF(AND('Master Project List'!$S57=\"\",'Master Project List'!$AA57<>\"Complete\"),\"\",_xlfn.IFS(AA57<>\"Complete\",\"-\",L57-M57<0,\"OVER\",AND(S57=\"\",AA57=\"Complete\"),\"N/A\", AND(L57=\"\",M57=\"\"),\"\", W57=\"\",\"\",S57=\"\",\"On Budget\",  S57=0, \"On Budget\", S57=\"\",\"\",S57<0, \"OVER\",AND(S57>0, AA57=\"complete\"), \"UNDER\",AND(S57>0, AA57<>\"complete\"),\"-\"))","v":"OVER"},null,null,{"$f":"_xlfn.IFS(AND(L57=\"\",M57=\"\"),\"\",AND(V57<>\"\",L57<>\"\",L57<>0),\"TMU\",V57=\"\",\"Milestone\",V57<>\"\",\"Hourly\")","v":"Milestone"},"2022-03-01",null,"2023-11-22",{"$f":"_xlfn.IFS(X57=\"\", \"\", X57<>\"\", IF(Z57=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},39]
[2022,2022019,"Malaysia","SWM Review","Stormwater","SWMR","Sahil","Danika",null,null,null,331422,854057,null,2.576947215332718,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA58=\"Ongoing\", \"\", W58=\"hourly\", 0,OR(L58=\"\",M58=\"\"),\"\",AA58=\"Complete\", L58-M58,AA58<>\"complete\", \"\"),\"\")","v":-522635},{"$f":"IF(AND('Master Project List'!$S58=\"\",'Master Project List'!$AA58<>\"Complete\"),\"\",_xlfn.IFS(AA58<>\"Complete\",\"-\",L58-M58<0,\"OVER\",AND(S58=\"\",AA58=\"Complete\"),\"N/A\", AND(L58=\"\",M58=\"\"),\"\", W58=\"\",\"\",S58=\"\",\"On Budget\",  S58=0, \"On Budget\", S58=\"\",\"\",S58<0, \"OVER\",AND(S58>0, AA58=\"complete\"), \"UNDER\",AND(S58>0, AA58<>\"complete\"),\"-\"))","v":"OVER"},null,null,{"$f":"_xlfn.IFS(AND(L58=\"\",M58=\"\"),\"\",AND(V58<>\"\",L58<>\"\",L58<>0),\"TMU\",V58=\"\",\"Milestone\",V58<>\"\",\"Hourly\")","v":"Milestone"},"2022-03-01",null,"2022-05-01",{"$f":"_xlfn.IFS(X58=\"\", \"\", X58<>\"\", IF(Z58=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},9]
[2022,2022020,"Chad","MOP Feasibility","Wastewater","Feasibility","Jennifer","Jessica","Hannah","Level 2",null,834893,718559,null,0.86065998876502736,0.65,1010771.55,-175878.55000000005,{"$f":"IFERROR(_xlfn.IFS(AA59=\"Ongoing\", \"\", W59=\"hourly\", 0,OR(L59=\"\",M59=\"\"),\"\",AA59=\"Complete\", L59-M59,AA59<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S59=\"\",'Master Project List'!$AA59<>\"Complete\"),\"\",_xlfn.IFS(AA59<>\"Complete\",\"-\",L59-M59<0,\"OVER\",AND(S59=\"\",AA59=\"Complete\"),\"N/A\", AND(L59=\"\",M59=\"\"),\"\", W59=\"\",\"\",S59=\"\",\"On Budget\",  S59=0, \"On Budget\", S59=\"\",\"\",S59<0, \"OVER\",AND(S59>0, AA59=\"complete\"), \"UNDER\",AND(S59>0, AA59<>\"complete\"),\"-\"))","v":""},"Healthy",null,{"$f":"_xlfn.IFS(AND(L59=\"\",M59=\"\"),\"\",AND(V59<>\"\",L59<>\"\",L59<>0),\"TMU\",V59=\"\",\"Milestone\",V59<>\"\",\"Hourly\")","v":"Milestone"},"2022-03-01","2023-02-15",null,{"$f":"_xlfn.IFS(X59=\"\", \"\", X59<>\"\", IF(Z59=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2022,2022021,"Czech Republic","Phosphorous Loading",null,"Miscellaneous","Anton","Jen T",null,"Level 1",null,51518,30390,null,0.58989091191428233,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA60=\"Ongoing\", \"\", W60=\"hourly\", 0,OR(L60=\"\",M60=\"\"),\"\",AA60=\"Complete\", L60-M60,AA60<>\"complete\", \"\"),\"\")","v":21128},{"$f":"IF(AND('Master Project List'!$S60=\"\",'Master Project List'!$AA60<>\"Complete\"),\"\",_xlfn.IFS(AA60<>\"Complete\",\"-\",L60-M60<0,\"OVER\",AND(S60=\"\",AA60=\"Complete\"),\"N/A\", AND(L60=\"\",M60=\"\"),\"\", W60=\"\",\"\",S60=\"\",\"On Budget\",  S60=0, \"On Budget\", S60=\"\",\"\",S60<0, \"OVER\",AND(S60>0, AA60=\"complete\"), \"UNDER\",AND(S60>0, AA60<>\"complete\"),\"-\"))","v":"UNDER"},null,null,{"$f":"_xlfn.IFS(AND(L60=\"\",M60=\"\"),\"\",AND(V60<>\"\",L60<>\"\",L60<>0),\"TMU\",V60=\"\",\"Milestone\",V60<>\"\",\"Hourly\")","v":"Milestone"},"2022-04-01",null,"2023-11-22",{"$f":"_xlfn.IFS(X60=\"\", \"\", X60<>\"\", IF(Z60=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},34]
[2022,2022022,"Cyprus","Outfall","Stormwater","Miscellaneous","Jenn M","Jessi",null,null,null,201939,223412,null,1.1063340909878725,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA61=\"Ongoing\", \"\", W61=\"hourly\", 0,OR(L61=\"\",M61=\"\"),\"\",AA61=\"Complete\", L61-M61,AA61<>\"complete\", \"\"),\"\")","v":-21473},{"$f":"IF(AND('Master Project List'!$S61=\"\",'Master Project List'!$AA61<>\"Complete\"),\"\",_xlfn.IFS(AA61<>\"Complete\",\"-\",L61-M61<0,\"OVER\",AND(S61=\"\",AA61=\"Complete\"),\"N/A\", AND(L61=\"\",M61=\"\"),\"\", W61=\"\",\"\",S61=\"\",\"On Budget\",  S61=0, \"On Budget\", S61=\"\",\"\",S61<0, \"OVER\",AND(S61>0, AA61=\"complete\"), \"UNDER\",AND(S61>0, AA61<>\"complete\"),\"-\"))","v":"OVER"},null,null,{"$f":"_xlfn.IFS(AND(L61=\"\",M61=\"\"),\"\",AND(V61<>\"\",L61<>\"\",L61<>0),\"TMU\",V61=\"\",\"Milestone\",V61<>\"\",\"Hourly\")","v":"Milestone"},"2022-04-25",null,"2022-08-01",{"$f":"_xlfn.IFS(X61=\"\", \"\", X61<>\"\", IF(Z61=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},14]
[2022,2022022,"Cabo Verde","Outfall","Stormwater","Miscellaneous","Jenn M","Jessi",null,null,null,208584,289203,null,1.3865061557933493,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA62=\"Ongoing\", \"\", W62=\"hourly\", 0,OR(L62=\"\",M62=\"\"),\"\",AA62=\"Complete\", L62-M62,AA62<>\"complete\", \"\"),\"\")","v":-80619},{"$f":"IF(AND('Master Project List'!$S62=\"\",'Master Project List'!$AA62<>\"Complete\"),\"\",_xlfn.IFS(AA62<>\"Complete\",\"-\",L62-M62<0,\"OVER\",AND(S62=\"\",AA62=\"Complete\"),\"N/A\", AND(L62=\"\",M62=\"\"),\"\", W62=\"\",\"\",S62=\"\",\"On Budget\",  S62=0, \"On Budget\", S62=\"\",\"\",S62<0, \"OVER\",AND(S62>0, AA62=\"complete\"), \"UNDER\",AND(S62>0, AA62<>\"complete\"),\"-\"))","v":"OVER"},null,125.25,{"$f":"_xlfn.IFS(AND(L62=\"\",M62=\"\"),\"\",AND(V62<>\"\",L62<>\"\",L62<>0),\"TMU\",V62=\"\",\"Milestone\",V62<>\"\",\"Hourly\")","v":"TMU"},"2022-04-01",null,"2022-08-01",{"$f":"_xlfn.IFS(X62=\"\", \"\", X62<>\"\", IF(Z62=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},18]
[2022,2022023,"Chile","Site Servicing",null,"Site Servicing","Jessi","Jessi",null,null,null,725604,737517,null,1.016418046207022,1,30302.5,695301.5,{"$f":"IFERROR(_xlfn.IFS(AA63=\"Ongoing\", \"\", W63=\"hourly\", 0,OR(L63=\"\",M63=\"\"),\"\",AA63=\"Complete\", L63-M63,AA63<>\"complete\", \"\"),\"\")","v":-11913},{"$f":"IF(AND('Master Project List'!$S63=\"\",'Master Project List'!$AA63<>\"Complete\"),\"\",_xlfn.IFS(AA63<>\"Complete\",\"-\",L63-M63<0,\"OVER\",AND(S63=\"\",AA63=\"Complete\"),\"N/A\", AND(L63=\"\",M63=\"\"),\"\", W63=\"\",\"\",S63=\"\",\"On Budget\",  S63=0, \"On Budget\", S63=\"\",\"\",S63<0, \"OVER\",AND(S63>0, AA63=\"complete\"), \"UNDER\",AND(S63>0, AA63<>\"complete\"),\"-\"))","v":"OVER"},"Not Awesome",null,{"$f":"_xlfn.IFS(AND(L63=\"\",M63=\"\"),\"\",AND(V63<>\"\",L63<>\"\",L63<>0),\"TMU\",V63=\"\",\"Milestone\",V63<>\"\",\"Hourly\")","v":"Milestone"},"2022-04-01",null,"2022-10-01",{"$f":"_xlfn.IFS(X63=\"\", \"\", X63<>\"\", IF(Z63=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},27,null,"In the end, the client was very happy with the report, but we went through a few too many iterations internally. "]
[2022,2022024,"Laos","PH 36 SWMR","Stormwater","SWMR","Sahil","Christian",null,null,null,902416,399226,null,0.44239685466569739,null,{"$f":"IF(P64=\"\",\"-\",M64+((L64*(1-P64))))","v":"-"},"",{"$f":"IFERROR(_xlfn.IFS(AA64=\"Ongoing\", \"\", W64=\"hourly\", 0,OR(L64=\"\",M64=\"\"),\"\",AA64=\"Complete\", L64-M64,AA64<>\"complete\", \"\"),\"\")","v":503190},{"$f":"IF(AND('Master Project List'!$S64=\"\",'Master Project List'!$AA64<>\"Complete\"),\"\",_xlfn.IFS(AA64<>\"Complete\",\"-\",L64-M64<0,\"OVER\",AND(S64=\"\",AA64=\"Complete\"),\"N/A\", AND(L64=\"\",M64=\"\"),\"\", W64=\"\",\"\",S64=\"\",\"On Budget\",  S64=0, \"On Budget\", S64=\"\",\"\",S64<0, \"OVER\",AND(S64>0, AA64=\"complete\"), \"UNDER\",AND(S64>0, AA64<>\"complete\"),\"-\"))","v":"UNDER"},null,null,{"$f":"_xlfn.IFS(AND(L64=\"\",M64=\"\"),\"\",AND(V64<>\"\",L64<>\"\",L64<>0),\"TMU\",V64=\"\",\"Milestone\",V64<>\"\",\"Hourly\")","v":"Milestone"},"2022-05-01",null,"2022-09-01",{"$f":"_xlfn.IFS(X64=\"\", \"\", X64<>\"\", IF(Z64=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},18]
[2022,2022025,"Malaysia","Stage 2",null,"Concept Design","Sam","Sam","Hannah","Level 2",null,41394,676564,null,16.344494371164902,1,676564,-635170,{"$f":"IFERROR(_xlfn.IFS(AA65=\"Ongoing\", \"\", W65=\"hourly\", 0,OR(L65=\"\",M65=\"\"),\"\",AA65=\"Complete\", L65-M65,AA65<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S65=\"\",'Master Project List'!$AA65<>\"Complete\"),\"\",_xlfn.IFS(AA65<>\"Complete\",\"-\",L65-M65<0,\"OVER\",AND(S65=\"\",AA65=\"Complete\"),\"N/A\", AND(L65=\"\",M65=\"\"),\"\", W65=\"\",\"\",S65=\"\",\"On Budget\",  S65=0, \"On Budget\", S65=\"\",\"\",S65<0, \"OVER\",AND(S65>0, AA65=\"complete\"), \"UNDER\",AND(S65>0, AA65<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L65=\"\",M65=\"\"),\"\",AND(V65<>\"\",L65<>\"\",L65<>0),\"TMU\",V65=\"\",\"Milestone\",V65<>\"\",\"Hourly\")","v":"Milestone"},"2022-04-01","2022-12-01",null,{"$f":"_xlfn.IFS(X65=\"\", \"\", X65<>\"\", IF(Z65=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2022,2022028,"Latvia","Development",null,"Feasibility","Jenn M","Jessi",null,null,null,192625,934534,null,4.8515717066839716,1,934534,-741909,{"$f":"IFERROR(_xlfn.IFS(AA66=\"Ongoing\", \"\", W66=\"hourly\", 0,OR(L66=\"\",M66=\"\"),\"\",AA66=\"Complete\", L66-M66,AA66<>\"complete\", \"\"),\"\")","v":-741909},{"$f":"IF(AND('Master Project List'!$S66=\"\",'Master Project List'!$AA66<>\"Complete\"),\"\",_xlfn.IFS(AA66<>\"Complete\",\"-\",L66-M66<0,\"OVER\",AND(S66=\"\",AA66=\"Complete\"),\"N/A\", AND(L66=\"\",M66=\"\"),\"\", W66=\"\",\"\",S66=\"\",\"On Budget\",  S66=0, \"On Budget\", S66=\"\",\"\",S66<0, \"OVER\",AND(S66>0, AA66=\"complete\"), \"UNDER\",AND(S66>0, AA66<>\"complete\"),\"-\"))","v":"OVER"},null,null,{"$f":"_xlfn.IFS(AND(L66=\"\",M66=\"\"),\"\",AND(V66<>\"\",L66<>\"\",L66<>0),\"TMU\",V66=\"\",\"Milestone\",V66<>\"\",\"Hourly\")","v":"Milestone"},"2022-04-01","2022-07-15","Closed",{"$f":"_xlfn.IFS(X66=\"\", \"\", X66<>\"\", IF(Z66=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},""]
[2022,2022029,"Singapore","Environmental Design Support","Miscellaneous","Miscellaneous","Aaron","Aaron",null,"Level 1",null,93726,537491,null,5.7347054179203205,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA67=\"Ongoing\", \"\", W67=\"hourly\", 0,OR(L67=\"\",M67=\"\"),\"\",AA67=\"Complete\", L67-M67,AA67<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S67=\"\",'Master Project List'!$AA67<>\"Complete\"),\"\",_xlfn.IFS(AA67<>\"Complete\",\"-\",L67-M67<0,\"OVER\",AND(S67=\"\",AA67=\"Complete\"),\"N/A\", AND(L67=\"\",M67=\"\"),\"\", W67=\"\",\"\",S67=\"\",\"On Budget\",  S67=0, \"On Budget\", S67=\"\",\"\",S67<0, \"OVER\",AND(S67>0, AA67=\"complete\"), \"UNDER\",AND(S67>0, AA67<>\"complete\"),\"-\"))","v":""},null,2.5,{"$f":"_xlfn.IFS(AND(L67=\"\",M67=\"\"),\"\",AND(V67<>\"\",L67<>\"\",L67<>0),\"TMU\",V67=\"\",\"Milestone\",V67<>\"\",\"Hourly\")","v":"TMU"},"2022-05-01",null,null,{"$f":"_xlfn.IFS(X67=\"\", \"\", X67<>\"\", IF(Z67=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2022,2022030,"Algeria","Solar DSSP",null,"DSSP","Sahil","Sarah",null,null,null,992891,494753,null,0.49829538186971178,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA68=\"Ongoing\", \"\", W68=\"hourly\", 0,OR(L68=\"\",M68=\"\"),\"\",AA68=\"Complete\", L68-M68,AA68<>\"complete\", \"\"),\"\")","v":498138},{"$f":"IF(AND('Master Project List'!$S68=\"\",'Master Project List'!$AA68<>\"Complete\"),\"\",_xlfn.IFS(AA68<>\"Complete\",\"-\",L68-M68<0,\"OVER\",AND(S68=\"\",AA68=\"Complete\"),\"N/A\", AND(L68=\"\",M68=\"\"),\"\", W68=\"\",\"\",S68=\"\",\"On Budget\",  S68=0, \"On Budget\", S68=\"\",\"\",S68<0, \"OVER\",AND(S68>0, AA68=\"complete\"), \"UNDER\",AND(S68>0, AA68<>\"complete\"),\"-\"))","v":"UNDER"},null,null,{"$f":"_xlfn.IFS(AND(L68=\"\",M68=\"\"),\"\",AND(V68<>\"\",L68<>\"\",L68<>0),\"TMU\",V68=\"\",\"Milestone\",V68<>\"\",\"Hourly\")","v":"Milestone"},"2022-05-15",null,"2022-07-01",{"$f":"_xlfn.IFS(X68=\"\", \"\", X68<>\"\", IF(Z68=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},7]
[2022,2022031,"Algeria","Solar DSSP",null,"DSSP","Sahil","Sarah",null,null,null,280620,315575,null,1.12456346660965,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA69=\"Ongoing\", \"\", W69=\"hourly\", 0,OR(L69=\"\",M69=\"\"),\"\",AA69=\"Complete\", L69-M69,AA69<>\"complete\", \"\"),\"\")","v":-34955},{"$f":"IF(AND('Master Project List'!$S69=\"\",'Master Project List'!$AA69<>\"Complete\"),\"\",_xlfn.IFS(AA69<>\"Complete\",\"-\",L69-M69<0,\"OVER\",AND(S69=\"\",AA69=\"Complete\"),\"N/A\", AND(L69=\"\",M69=\"\"),\"\", W69=\"\",\"\",S69=\"\",\"On Budget\",  S69=0, \"On Budget\", S69=\"\",\"\",S69<0, \"OVER\",AND(S69>0, AA69=\"complete\"), \"UNDER\",AND(S69>0, AA69<>\"complete\"),\"-\"))","v":"OVER"},null,null,{"$f":"_xlfn.IFS(AND(L69=\"\",M69=\"\"),\"\",AND(V69<>\"\",L69<>\"\",L69<>0),\"TMU\",V69=\"\",\"Milestone\",V69<>\"\",\"Hourly\")","v":"Milestone"},"2022-05-26",null,"2022-09-01",{"$f":"_xlfn.IFS(X69=\"\", \"\", X69<>\"\", IF(Z69=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},14]
[{"$f":"IFERROR(IF(X70=\"\",\"\",YEAR(X70)+IF(MONTH(X70)>=11,1,0)),\"\")","v":2022},2022032,"Laos","PH 37 SWMR","Stormwater","SWMR","Sahil","Christian",null,null,null,519008,470474,null,0.90648699056661941,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA70=\"Ongoing\", \"\", W70=\"hourly\", 0,OR(L70=\"\",M70=\"\"),\"\",AA70=\"Complete\", L70-M70,AA70<>\"complete\", \"\"),\"\")","v":48534},{"$f":"IF(AND('Master Project List'!$S70=\"\",'Master Project List'!$AA70<>\"Complete\"),\"\",_xlfn.IFS(AA70<>\"Complete\",\"-\",L70-M70<0,\"OVER\",AND(S70=\"\",AA70=\"Complete\"),\"N/A\", AND(L70=\"\",M70=\"\"),\"\", W70=\"\",\"\",S70=\"\",\"On Budget\",  S70=0, \"On Budget\", S70=\"\",\"\",S70<0, \"OVER\",AND(S70>0, AA70=\"complete\"), \"UNDER\",AND(S70>0, AA70<>\"complete\"),\"-\"))","v":"UNDER"},null,null,{"$f":"_xlfn.IFS(AND(L70=\"\",M70=\"\"),\"\",AND(V70<>\"\",L70<>\"\",L70<>0),\"TMU\",V70=\"\",\"Milestone\",V70<>\"\",\"Hourly\")","v":"Milestone"},"2022-06-08",null,"2022-09-01",{"$f":"_xlfn.IFS(X70=\"\", \"\", X70<>\"\", IF(Z70=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},{"$f":"IFERROR(IF(AND(X70=\"\",Z70=\"\"),\"\", WEEKNUM(_xlfn.DAYS(Z70,X70))),\"\")","v":13}]
[2022,2022033,"China","MOP Feasibility","Wastewater","Feasibility","Jessi","Jessi",null,"Level 2",null,682982,23351,null,3.4189773668998599E-2,0.9,91649.199999999983,591332.80000000005,{"$f":"IFERROR(_xlfn.IFS(AA71=\"Ongoing\", \"\", W71=\"hourly\", 0,OR(L71=\"\",M71=\"\"),\"\",AA71=\"Complete\", L71-M71,AA71<>\"complete\", \"\"),\"\")","v":659631},{"$f":"IF(AND('Master Project List'!$S71=\"\",'Master Project List'!$AA71<>\"Complete\"),\"\",_xlfn.IFS(AA71<>\"Complete\",\"-\",L71-M71<0,\"OVER\",AND(S71=\"\",AA71=\"Complete\"),\"N/A\", AND(L71=\"\",M71=\"\"),\"\", W71=\"\",\"\",S71=\"\",\"On Budget\",  S71=0, \"On Budget\", S71=\"\",\"\",S71<0, \"OVER\",AND(S71>0, AA71=\"complete\"), \"UNDER\",AND(S71>0, AA71<>\"complete\"),\"-\"))","v":"UNDER"},null,null,{"$f":"_xlfn.IFS(AND(L71=\"\",M71=\"\"),\"\",AND(V71<>\"\",L71<>\"\",L71<>0),\"TMU\",V71=\"\",\"Milestone\",V71<>\"\",\"Hourly\")","v":"Milestone"},"2022-06-01",null,"2022-11-01",{"$f":"_xlfn.IFS(X71=\"\", \"\", X71<>\"\", IF(Z71=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},22]
[2022,2022034,"Central African Republic","MOP Feasibility","Wastewater","Feasibility","Anton","Jessi",null,"Level 2",null,569326,964879,null,1.6947741715642708,0.9,1021811.6,-452485.6,{"$f":"IFERROR(_xlfn.IFS(AA72=\"Ongoing\", \"\", W72=\"hourly\", 0,OR(L72=\"\",M72=\"\"),\"\",AA72=\"Complete\", L72-M72,AA72<>\"complete\", \"\"),\"\")","v":-395553},{"$f":"IF(AND('Master Project List'!$S72=\"\",'Master Project List'!$AA72<>\"Complete\"),\"\",_xlfn.IFS(AA72<>\"Complete\",\"-\",L72-M72<0,\"OVER\",AND(S72=\"\",AA72=\"Complete\"),\"N/A\", AND(L72=\"\",M72=\"\"),\"\", W72=\"\",\"\",S72=\"\",\"On Budget\",  S72=0, \"On Budget\", S72=\"\",\"\",S72<0, \"OVER\",AND(S72>0, AA72=\"complete\"), \"UNDER\",AND(S72>0, AA72<>\"complete\"),\"-\"))","v":"OVER"},null,null,{"$f":"_xlfn.IFS(AND(L72=\"\",M72=\"\"),\"\",AND(V72<>\"\",L72<>\"\",L72<>0),\"TMU\",V72=\"\",\"Milestone\",V72<>\"\",\"Hourly\")","v":"Milestone"},"2022-06-08","2022-11-15","2023-01-01",{"$f":"_xlfn.IFS(X72=\"\", \"\", X72<>\"\", IF(Z72=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},30]
[2022,2022036,"Wales","SWM Opportunities","Stormwater","Concept Design","Sahil","Sahil",null,null,null,355027,772664,null,2.1763527844361135,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA73=\"Ongoing\", \"\", W73=\"hourly\", 0,OR(L73=\"\",M73=\"\"),\"\",AA73=\"Complete\", L73-M73,AA73<>\"complete\", \"\"),\"\")","v":-417637},{"$f":"IF(AND('Master Project List'!$S73=\"\",'Master Project List'!$AA73<>\"Complete\"),\"\",_xlfn.IFS(AA73<>\"Complete\",\"-\",L73-M73<0,\"OVER\",AND(S73=\"\",AA73=\"Complete\"),\"N/A\", AND(L73=\"\",M73=\"\"),\"\", W73=\"\",\"\",S73=\"\",\"On Budget\",  S73=0, \"On Budget\", S73=\"\",\"\",S73<0, \"OVER\",AND(S73>0, AA73=\"complete\"), \"UNDER\",AND(S73>0, AA73<>\"complete\"),\"-\"))","v":"OVER"},null,21.75,{"$f":"_xlfn.IFS(AND(L73=\"\",M73=\"\"),\"\",AND(V73<>\"\",L73<>\"\",L73<>0),\"TMU\",V73=\"\",\"Milestone\",V73<>\"\",\"Hourly\")","v":"TMU"},"2022-06-20","2022-07-29","2022-07-01",{"$f":"_xlfn.IFS(X73=\"\", \"\", X73<>\"\", IF(Z73=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},2]
[2022,2022037,"Honduras","Terraces",null,"Miscellaneous","Sahil","Sahil",null,null,null,541157,356133,null,0.65809552495856105,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA74=\"Ongoing\", \"\", W74=\"hourly\", 0,OR(L74=\"\",M74=\"\"),\"\",AA74=\"Complete\", L74-M74,AA74<>\"complete\", \"\"),\"\")","v":185024},{"$f":"IF(AND('Master Project List'!$S74=\"\",'Master Project List'!$AA74<>\"Complete\"),\"\",_xlfn.IFS(AA74<>\"Complete\",\"-\",L74-M74<0,\"OVER\",AND(S74=\"\",AA74=\"Complete\"),\"N/A\", AND(L74=\"\",M74=\"\"),\"\", W74=\"\",\"\",S74=\"\",\"On Budget\",  S74=0, \"On Budget\", S74=\"\",\"\",S74<0, \"OVER\",AND(S74>0, AA74=\"complete\"), \"UNDER\",AND(S74>0, AA74<>\"complete\"),\"-\"))","v":"UNDER"},null,null,{"$f":"_xlfn.IFS(AND(L74=\"\",M74=\"\"),\"\",AND(V74<>\"\",L74<>\"\",L74<>0),\"TMU\",V74=\"\",\"Milestone\",V74<>\"\",\"Hourly\")","v":"Milestone"},"2022-07-01",null,"2022-08-08",{"$f":"_xlfn.IFS(X74=\"\", \"\", X74<>\"\", IF(Z74=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},6]
[2022,2022039,"Oldenburg","SWMR","Stormwater","SWMR","Sahil","Christian",null,"Level 1",null,317180,179990,null,0.56746957563528599,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA75=\"Ongoing\", \"\", W75=\"hourly\", 0,OR(L75=\"\",M75=\"\"),\"\",AA75=\"Complete\", L75-M75,AA75<>\"complete\", \"\"),\"\")","v":137190},{"$f":"IF(AND('Master Project List'!$S75=\"\",'Master Project List'!$AA75<>\"Complete\"),\"\",_xlfn.IFS(AA75<>\"Complete\",\"-\",L75-M75<0,\"OVER\",AND(S75=\"\",AA75=\"Complete\"),\"N/A\", AND(L75=\"\",M75=\"\"),\"\", W75=\"\",\"\",S75=\"\",\"On Budget\",  S75=0, \"On Budget\", S75=\"\",\"\",S75<0, \"OVER\",AND(S75>0, AA75=\"complete\"), \"UNDER\",AND(S75>0, AA75<>\"complete\"),\"-\"))","v":"UNDER"},null,null,{"$f":"_xlfn.IFS(AND(L75=\"\",M75=\"\"),\"\",AND(V75<>\"\",L75<>\"\",L75<>0),\"TMU\",V75=\"\",\"Milestone\",V75<>\"\",\"Hourly\")","v":"Milestone"},"2022-07-11",null,"2022-07-01",{"$f":"_xlfn.IFS(X75=\"\", \"\", X75<>\"\", IF(Z75=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},""]
[2022,2022041,"Libya","PH 20 SWMR","Stormwater","Stakeholder Engagement","Sam","Christian","Josh","Level 1",null,141321,28397,null,{"$f":"IFERROR(M76/L76,\"\")","v":0.20093970464403732},0.1,155585.90000000002,-14264.900000000023,{"$f":"IFERROR(_xlfn.IFS(AA76=\"Ongoing\", \"\", W76=\"hourly\", 0,OR(L76=\"\",M76=\"\"),\"\",AA76=\"Complete\", L76-M76,AA76<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S76=\"\",'Master Project List'!$AA76<>\"Complete\"),\"\",_xlfn.IFS(AA76<>\"Complete\",\"-\",L76-M76<0,\"OVER\",AND(S76=\"\",AA76=\"Complete\"),\"N/A\", AND(L76=\"\",M76=\"\"),\"\", W76=\"\",\"\",S76=\"\",\"On Budget\",  S76=0, \"On Budget\", S76=\"\",\"\",S76<0, \"OVER\",AND(S76>0, AA76=\"complete\"), \"UNDER\",AND(S76>0, AA76<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L76=\"\",M76=\"\"),\"\",AND(V76<>\"\",L76<>\"\",L76<>0),\"TMU\",V76=\"\",\"Milestone\",V76<>\"\",\"Hourly\")","v":"Milestone"},"2022-07-25",null,null,{"$f":"_xlfn.IFS(X76=\"\", \"\", X76<>\"\", IF(Z76=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2022,2022042,"Angola","Estates 2",null,"Miscellaneous","Sahil","Christian",null,null,null,200385,403621,null,2.0142276118471942,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA77=\"Ongoing\", \"\", W77=\"hourly\", 0,OR(L77=\"\",M77=\"\"),\"\",AA77=\"Complete\", L77-M77,AA77<>\"complete\", \"\"),\"\")","v":-203236},{"$f":"IF(AND('Master Project List'!$S77=\"\",'Master Project List'!$AA77<>\"Complete\"),\"\",_xlfn.IFS(AA77<>\"Complete\",\"-\",L77-M77<0,\"OVER\",AND(S77=\"\",AA77=\"Complete\"),\"N/A\", AND(L77=\"\",M77=\"\"),\"\", W77=\"\",\"\",S77=\"\",\"On Budget\",  S77=0, \"On Budget\", S77=\"\",\"\",S77<0, \"OVER\",AND(S77>0, AA77=\"complete\"), \"UNDER\",AND(S77>0, AA77<>\"complete\"),\"-\"))","v":"OVER"},null,null,{"$f":"_xlfn.IFS(AND(L77=\"\",M77=\"\"),\"\",AND(V77<>\"\",L77<>\"\",L77<>0),\"TMU\",V77=\"\",\"Milestone\",V77<>\"\",\"Hourly\")","v":"Milestone"},"2022-07-26",null,"2022-07-01",{"$f":"_xlfn.IFS(X77=\"\", \"\", X77<>\"\", IF(Z77=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},""]
[2022,2022043,"Liechtenstein","PH 7","Stormwater","SWMR","Sahil","Christian",null,"Level 1",null,62922,79229,null,1.2591621372492927,1,79229,-16307,{"$f":"IFERROR(_xlfn.IFS(AA78=\"Ongoing\", \"\", W78=\"hourly\", 0,OR(L78=\"\",M78=\"\"),\"\",AA78=\"Complete\", L78-M78,AA78<>\"complete\", \"\"),\"\")","v":-16307},{"$f":"IF(AND('Master Project List'!$S78=\"\",'Master Project List'!$AA78<>\"Complete\"),\"\",_xlfn.IFS(AA78<>\"Complete\",\"-\",L78-M78<0,\"OVER\",AND(S78=\"\",AA78=\"Complete\"),\"N/A\", AND(L78=\"\",M78=\"\"),\"\", W78=\"\",\"\",S78=\"\",\"On Budget\",  S78=0, \"On Budget\", S78=\"\",\"\",S78<0, \"OVER\",AND(S78>0, AA78=\"complete\"), \"UNDER\",AND(S78>0, AA78<>\"complete\"),\"-\"))","v":"OVER"},null,null,{"$f":"_xlfn.IFS(AND(L78=\"\",M78=\"\"),\"\",AND(V78<>\"\",L78<>\"\",L78<>0),\"TMU\",V78=\"\",\"Milestone\",V78<>\"\",\"Hourly\")","v":"Milestone"},"2022-08-03","2022-09-15","2023-01-01",{"$f":"_xlfn.IFS(X78=\"\", \"\", X78<>\"\", IF(Z78=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},22]
[2022,2022044,"El Salvador","PH 1 SWMR","Stormwater","SWMR","Sam","Christian","Alison","Level 1",null,671005,47585,null,7.0916014038643532E-2,0.85,148235.75,522769.25,{"$f":"IFERROR(_xlfn.IFS(AA79=\"Ongoing\", \"\", W79=\"hourly\", 0,OR(L79=\"\",M79=\"\"),\"\",AA79=\"Complete\", L79-M79,AA79<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S79=\"\",'Master Project List'!$AA79<>\"Complete\"),\"\",_xlfn.IFS(AA79<>\"Complete\",\"-\",L79-M79<0,\"OVER\",AND(S79=\"\",AA79=\"Complete\"),\"N/A\", AND(L79=\"\",M79=\"\"),\"\", W79=\"\",\"\",S79=\"\",\"On Budget\",  S79=0, \"On Budget\", S79=\"\",\"\",S79<0, \"OVER\",AND(S79>0, AA79=\"complete\"), \"UNDER\",AND(S79>0, AA79<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L79=\"\",M79=\"\"),\"\",AND(V79<>\"\",L79<>\"\",L79<>0),\"TMU\",V79=\"\",\"Milestone\",V79<>\"\",\"Hourly\")","v":"Milestone"},"2022-08-08","2022-09-08",null,{"$f":"_xlfn.IFS(X79=\"\", \"\", X79<>\"\", IF(Z79=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2022,2022045,"Egypt","General","Stormwater","Miscellaneous","Sam","Christian","Alison","Level 1",null,96050,854072,null,8.8919521082769393,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA80=\"Ongoing\", \"\", W80=\"hourly\", 0,OR(L80=\"\",M80=\"\"),\"\",AA80=\"Complete\", L80-M80,AA80<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S80=\"\",'Master Project List'!$AA80<>\"Complete\"),\"\",_xlfn.IFS(AA80<>\"Complete\",\"-\",L80-M80<0,\"OVER\",AND(S80=\"\",AA80=\"Complete\"),\"N/A\", AND(L80=\"\",M80=\"\"),\"\", W80=\"\",\"\",S80=\"\",\"On Budget\",  S80=0, \"On Budget\", S80=\"\",\"\",S80<0, \"OVER\",AND(S80>0, AA80=\"complete\"), \"UNDER\",AND(S80>0, AA80<>\"complete\"),\"-\"))","v":""},null,3,{"$f":"_xlfn.IFS(AND(L80=\"\",M80=\"\"),\"\",AND(V80<>\"\",L80<>\"\",L80<>0),\"TMU\",V80=\"\",\"Milestone\",V80<>\"\",\"Hourly\")","v":"TMU"},"2022-08-08","2022-12-31",null,{"$f":"_xlfn.IFS(X80=\"\", \"\", X80<>\"\", IF(Z80=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2022,2022046,"Chad","WTE","Miscellaneous","Miscellaneous","Jennifer","Jessica","Hannah","Level 2",null,615412,928110,null,1.508111639032063,0.5,1235816,-620404,{"$f":"IFERROR(_xlfn.IFS(AA81=\"Ongoing\", \"\", W81=\"hourly\", 0,OR(L81=\"\",M81=\"\"),\"\",AA81=\"Complete\", L81-M81,AA81<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S81=\"\",'Master Project List'!$AA81<>\"Complete\"),\"\",_xlfn.IFS(AA81<>\"Complete\",\"-\",L81-M81<0,\"OVER\",AND(S81=\"\",AA81=\"Complete\"),\"N/A\", AND(L81=\"\",M81=\"\"),\"\", W81=\"\",\"\",S81=\"\",\"On Budget\",  S81=0, \"On Budget\", S81=\"\",\"\",S81<0, \"OVER\",AND(S81>0, AA81=\"complete\"), \"UNDER\",AND(S81>0, AA81<>\"complete\"),\"-\"))","v":""},"Healthy",null,{"$f":"_xlfn.IFS(AND(L81=\"\",M81=\"\"),\"\",AND(V81<>\"\",L81<>\"\",L81<>0),\"TMU\",V81=\"\",\"Milestone\",V81<>\"\",\"Hourly\")","v":"Milestone"},"2022-08-08","",null,{"$f":"_xlfn.IFS(X81=\"\", \"\", X81<>\"\", IF(Z81=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2022,2022047,"Albania","Water Treatment Residuals","Miscellaneous","MAGNA","Aaron","Jessica","Hannah","Level 2",null,656582,185966,null,0.28323347274217081,0.25,678402.5,-21820.5,{"$f":"IFERROR(_xlfn.IFS(AA82=\"Ongoing\", \"\", W82=\"hourly\", 0,OR(L82=\"\",M82=\"\"),\"\",AA82=\"Complete\", L82-M82,AA82<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S82=\"\",'Master Project List'!$AA82<>\"Complete\"),\"\",_xlfn.IFS(AA82<>\"Complete\",\"-\",L82-M82<0,\"OVER\",AND(S82=\"\",AA82=\"Complete\"),\"N/A\", AND(L82=\"\",M82=\"\"),\"\", W82=\"\",\"\",S82=\"\",\"On Budget\",  S82=0, \"On Budget\", S82=\"\",\"\",S82<0, \"OVER\",AND(S82>0, AA82=\"complete\"), \"UNDER\",AND(S82>0, AA82<>\"complete\"),\"-\"))","v":""},"Healthy",null,{"$f":"_xlfn.IFS(AND(L82=\"\",M82=\"\"),\"\",AND(V82<>\"\",L82<>\"\",L82<>0),\"TMU\",V82=\"\",\"Milestone\",V82<>\"\",\"Hourly\")","v":"Milestone"},"2022-08-22","2024-06-01",null,{"$f":"_xlfn.IFS(X82=\"\", \"\", X82<>\"\", IF(Z82=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2022,2022048,"Maldives","hourly TMU","Stormwater","Stormwater","Jenn M","Jessi",null,"Level 1",null,680328,217671,null,0.31995008290118881,1,"-","-",{"$f":"IFERROR(_xlfn.IFS(AA83=\"Ongoing\", \"\", W83=\"hourly\", 0,OR(L83=\"\",M83=\"\"),\"\",AA83=\"Complete\", L83-M83,AA83<>\"complete\", \"\"),\"\")","v":462657},{"$f":"IF(AND('Master Project List'!$S83=\"\",'Master Project List'!$AA83<>\"Complete\"),\"\",_xlfn.IFS(AA83<>\"Complete\",\"-\",L83-M83<0,\"OVER\",AND(S83=\"\",AA83=\"Complete\"),\"N/A\", AND(L83=\"\",M83=\"\"),\"\", W83=\"\",\"\",S83=\"\",\"On Budget\",  S83=0, \"On Budget\", S83=\"\",\"\",S83<0, \"OVER\",AND(S83>0, AA83=\"complete\"), \"UNDER\",AND(S83>0, AA83<>\"complete\"),\"-\"))","v":"UNDER"},null,1.5,{"$f":"_xlfn.IFS(AND(L83=\"\",M83=\"\"),\"\",AND(V83<>\"\",L83<>\"\",L83<>0),\"TMU\",V83=\"\",\"Milestone\",V83<>\"\",\"Hourly\")","v":"TMU"},"2022-08-22","2022-09-30","2022-10-01",{"$f":"_xlfn.IFS(X83=\"\", \"\", X83<>\"\", IF(Z83=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},6]
[2022,2022049,"Congo ","Net Zero Water","Stormwater","Grant Application","Jenn M","Jen T",null,"Level 1",null,546610,544239,null,0.99566235524414115,null,{"$f":"IF(P84=\"\",\"-\",M84+((L84*(1-P84))))","v":"-"},{"$f":"IFERROR(L84-Q84,\"\")","v":""},{"$f":"IFERROR(_xlfn.IFS(AA84=\"Ongoing\", \"\", W84=\"hourly\", 0,OR(L84=\"\",M84=\"\"),\"\",AA84=\"Complete\", L84-M84,AA84<>\"complete\", \"\"),\"\")","v":2371},{"$f":"IF(AND('Master Project List'!$S84=\"\",'Master Project List'!$AA84<>\"Complete\"),\"\",_xlfn.IFS(AA84<>\"Complete\",\"-\",L84-M84<0,\"OVER\",AND(S84=\"\",AA84=\"Complete\"),\"N/A\", AND(L84=\"\",M84=\"\"),\"\", W84=\"\",\"\",S84=\"\",\"On Budget\",  S84=0, \"On Budget\", S84=\"\",\"\",S84<0, \"OVER\",AND(S84>0, AA84=\"complete\"), \"UNDER\",AND(S84>0, AA84<>\"complete\"),\"-\"))","v":"UNDER"},null,null,{"$f":"_xlfn.IFS(AND(L84=\"\",M84=\"\"),\"\",AND(V84<>\"\",L84<>\"\",L84<>0),\"TMU\",V84=\"\",\"Milestone\",V84<>\"\",\"Hourly\")","v":"Milestone"},"2022-09-15","2022-10-15","2022-12-01",{"$f":"_xlfn.IFS(X84=\"\", \"\", X84<>\"\", IF(Z84=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},11]
[2022,2022050,"Iceland","WTR","Wastewater","MAGNA","Aaron","Miranda","N/A","Level 1",null,832646,976489,null,1.1727540875714288,null,"-","",{"$f":"IFERROR(_xlfn.IFS(AA85=\"Ongoing\", \"\", W85=\"hourly\", 0,OR(L85=\"\",M85=\"\"),\"\",AA85=\"Complete\", L85-M85,AA85<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S85=\"\",'Master Project List'!$AA85<>\"Complete\"),\"\",_xlfn.IFS(AA85<>\"Complete\",\"-\",L85-M85<0,\"OVER\",AND(S85=\"\",AA85=\"Complete\"),\"N/A\", AND(L85=\"\",M85=\"\"),\"\", W85=\"\",\"\",S85=\"\",\"On Budget\",  S85=0, \"On Budget\", S85=\"\",\"\",S85<0, \"OVER\",AND(S85>0, AA85=\"complete\"), \"UNDER\",AND(S85>0, AA85<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L85=\"\",M85=\"\"),\"\",AND(V85<>\"\",L85<>\"\",L85<>0),\"TMU\",V85=\"\",\"Milestone\",V85<>\"\",\"Hourly\")","v":"Milestone"},"2022-09-01","2024-09-01",null,{"$f":"_xlfn.IFS(X85=\"\", \"\", X85<>\"\", IF(Z85=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2022,2022053,"Laos","PH 60 SWMR","Stormwater","SWMR","Sam","Christian","Hannah","Level 1",null,757183,601937,null,0.79496898371991975,1,601937,155246,null,{"$f":"IF(AND('Master Project List'!$S86=\"\",'Master Project List'!$AA86<>\"Complete\"),\"\",_xlfn.IFS(AA86<>\"Complete\",\"-\",L86-M86<0,\"OVER\",AND(S86=\"\",AA86=\"Complete\"),\"N/A\", AND(L86=\"\",M86=\"\"),\"\", W86=\"\",\"\",S86=\"\",\"On Budget\",  S86=0, \"On Budget\", S86=\"\",\"\",S86<0, \"OVER\",AND(S86>0, AA86=\"complete\"), \"UNDER\",AND(S86>0, AA86<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L86=\"\",M86=\"\"),\"\",AND(V86<>\"\",L86<>\"\",L86<>0),\"TMU\",V86=\"\",\"Milestone\",V86<>\"\",\"Hourly\")","v":"Milestone"},"2022-10-12","2022-11-21",null,{"$f":"_xlfn.IFS(X86=\"\", \"\", X86<>\"\", IF(Z86=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2022,2022055,"Ecuador","PH 1 SWMR","Stormwater","SWMR","Sam","Christian","Hannah","Level 1",null,754883,879019,null,1.1644440264252871,0.8,1029995.6,-275112.59999999998,null,{"$f":"IF(AND('Master Project List'!$S87=\"\",'Master Project List'!$AA87<>\"Complete\"),\"\",_xlfn.IFS(AA87<>\"Complete\",\"-\",L87-M87<0,\"OVER\",AND(S87=\"\",AA87=\"Complete\"),\"N/A\", AND(L87=\"\",M87=\"\"),\"\", W87=\"\",\"\",S87=\"\",\"On Budget\",  S87=0, \"On Budget\", S87=\"\",\"\",S87<0, \"OVER\",AND(S87>0, AA87=\"complete\"), \"UNDER\",AND(S87>0, AA87<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L87=\"\",M87=\"\"),\"\",AND(V87<>\"\",L87<>\"\",L87<>0),\"TMU\",V87=\"\",\"Milestone\",V87<>\"\",\"Hourly\")","v":"Milestone"},"2022-10-01","2022-12-31",null,{"$f":"_xlfn.IFS(X87=\"\", \"\", X87<>\"\", IF(Z87=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2023,2022057,"El Salvador","Phase 3 SWMR","Stormwater","SWMR","Sam","Christian","Alison","Level 1",null,777555,15820,null,2.0345827626341545E-2,1,15820,761735,null,null,null,null,null,"2022-11-17",null,null,{"$f":"_xlfn.IFS(X88=\"\", \"\", X88<>\"\", IF(Z88=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2023,2022059,"Oman","fields",null,"Miscellaneous","Cody","Hanan",null,"Level 1",null,471950,948373,null,2.0094776989087828,null,"-","",null,null,null,null,"Milestone","2022-11-28",null,"2022-12-01",{"$f":"_xlfn.IFS(X89=\"\", \"\", X89<>\"\", IF(Z89=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},1]
[2023,2022061,"LewChew","PH 31 SWMR","Stormwater","SWMR","Sam","Christian","Hannah","Level 1",null,658183,587900,null,0.89321662820218695,null,"-","",null,{"$f":"IF(AND('Master Project List'!$S90=\"\",'Master Project List'!$AA90<>\"Complete\"),\"\",_xlfn.IFS(AA90<>\"Complete\",\"-\",L90-M90<0,\"OVER\",AND(S90=\"\",AA90=\"Complete\"),\"N/A\", AND(L90=\"\",M90=\"\"),\"\", W90=\"\",\"\",S90=\"\",\"On Budget\",  S90=0, \"On Budget\", S90=\"\",\"\",S90<0, \"OVER\",AND(S90>0, AA90=\"complete\"), \"UNDER\",AND(S90>0, AA90<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L90=\"\",M90=\"\"),\"\",AND(V90<>\"\",L90<>\"\",L90<>0),\"TMU\",V90=\"\",\"Milestone\",V90<>\"\",\"Hourly\")","v":"Milestone"},"2022-11-30",null,null,{"$f":"_xlfn.IFS(X90=\"\", \"\", X90<>\"\", IF(Z90=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2023,2022062,"Lithuania","PH 38 SWMR","Stormwater","SWMR","Sam","Christian","Chris","Level 1",null,206038,322990,null,1.5676234481018065,null,"-","",null,{"$f":"IF(AND('Master Project List'!$S91=\"\",'Master Project List'!$AA91<>\"Complete\"),\"\",_xlfn.IFS(AA91<>\"Complete\",\"-\",L91-M91<0,\"OVER\",AND(S91=\"\",AA91=\"Complete\"),\"N/A\", AND(L91=\"\",M91=\"\"),\"\", W91=\"\",\"\",S91=\"\",\"On Budget\",  S91=0, \"On Budget\", S91=\"\",\"\",S91<0, \"OVER\",AND(S91>0, AA91=\"complete\"), \"UNDER\",AND(S91>0, AA91<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L91=\"\",M91=\"\"),\"\",AND(V91<>\"\",L91<>\"\",L91<>0),\"TMU\",V91=\"\",\"Milestone\",V91<>\"\",\"Hourly\")","v":"Milestone"},"2022-11-30",null,null,{"$f":"_xlfn.IFS(X91=\"\", \"\", X91<>\"\", IF(Z91=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2023,2023001,"Djibouti","Pond 2B M & M","Stormwater","Construction","Sam","Harry","Josh","Level 2",null,763405,12229,null,1.6019020048336073E-2,null,null,null,null,{"$f":"IF(AND('Master Project List'!$S92=\"\",'Master Project List'!$AA92<>\"Complete\"),\"\",_xlfn.IFS(AA92<>\"Complete\",\"-\",L92-M92<0,\"OVER\",AND(S92=\"\",AA92=\"Complete\"),\"N/A\", AND(L92=\"\",M92=\"\"),\"\", W92=\"\",\"\",S92=\"\",\"On Budget\",  S92=0, \"On Budget\", S92=\"\",\"\",S92<0, \"OVER\",AND(S92>0, AA92=\"complete\"), \"UNDER\",AND(S92>0, AA92<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L92=\"\",M92=\"\"),\"\",AND(V92<>\"\",L92<>\"\",L92<>0),\"TMU\",V92=\"\",\"Milestone\",V92<>\"\",\"Hourly\")","v":"Milestone"},"2023-01-01","2023-12-31",null,{"$f":"_xlfn.IFS(X92=\"\", \"\", X92<>\"\", IF(Z92=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2023,2023002,"Denmark","Pond 2B Land Use",null,null,null,null,null,null,null,501540,377972,null,0.75362284164772497,null,null,null,null,{"$f":"IF(AND('Master Project List'!$S93=\"\",'Master Project List'!$AA93<>\"Complete\"),\"\",_xlfn.IFS(AA93<>\"Complete\",\"-\",L93-M93<0,\"OVER\",AND(S93=\"\",AA93=\"Complete\"),\"N/A\", AND(L93=\"\",M93=\"\"),\"\", W93=\"\",\"\",S93=\"\",\"On Budget\",  S93=0, \"On Budget\", S93=\"\",\"\",S93<0, \"OVER\",AND(S93>0, AA93=\"complete\"), \"UNDER\",AND(S93>0, AA93<>\"complete\"),\"-\"))","v":"N/A"},null,null,{"$f":"_xlfn.IFS(AND(L93=\"\",M93=\"\"),\"\",AND(V93<>\"\",L93<>\"\",L93<>0),\"TMU\",V93=\"\",\"Milestone\",V93<>\"\",\"Hourly\")","v":"Milestone"},"2023-01-31",null,"2023-01-31",{"$f":"_xlfn.IFS(X93=\"\", \"\", X93<>\"\", IF(Z93=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},0]
[2023,2023003,"Chad","Parking Lot","Stormwater","Stormwater","Jennifer","Sarah","Hannah","Level 1",null,660119,531145,null,0.8046200760771921,0.5,null,null,null,{"$f":"IF(AND('Master Project List'!$S94=\"\",'Master Project List'!$AA94<>\"Complete\"),\"\",_xlfn.IFS(AA94<>\"Complete\",\"-\",L94-M94<0,\"OVER\",AND(S94=\"\",AA94=\"Complete\"),\"N/A\", AND(L94=\"\",M94=\"\"),\"\", W94=\"\",\"\",S94=\"\",\"On Budget\",  S94=0, \"On Budget\", S94=\"\",\"\",S94<0, \"OVER\",AND(S94>0, AA94=\"complete\"), \"UNDER\",AND(S94>0, AA94<>\"complete\"),\"-\"))","v":""},"Healthy",null,{"$f":"_xlfn.IFS(AND(L94=\"\",M94=\"\"),\"\",AND(V94<>\"\",L94<>\"\",L94<>0),\"TMU\",V94=\"\",\"Milestone\",V94<>\"\",\"Hourly\")","v":"Milestone"},"2023-02-14",{"$f":"'Master Project List'!$X94+30","v":"2023-03-16"},null,{"$f":"_xlfn.IFS(X94=\"\", \"\", X94<>\"\", IF(Z94=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2023,2023004,"Democratic Republic of the Congo","Retrofit","Stormwater","DD","Jennifer","Harry","Hannah","Level 2",null,708507,519263,null,0.73289748725136095,null,null,null,null,{"$f":"IF(AND('Master Project List'!$S95=\"\",'Master Project List'!$AA95<>\"Complete\"),\"\",_xlfn.IFS(AA95<>\"Complete\",\"-\",L95-M95<0,\"OVER\",AND(S95=\"\",AA95=\"Complete\"),\"N/A\", AND(L95=\"\",M95=\"\"),\"\", W95=\"\",\"\",S95=\"\",\"On Budget\",  S95=0, \"On Budget\", S95=\"\",\"\",S95<0, \"OVER\",AND(S95>0, AA95=\"complete\"), \"UNDER\",AND(S95>0, AA95<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L95=\"\",M95=\"\"),\"\",AND(V95<>\"\",L95<>\"\",L95<>0),\"TMU\",V95=\"\",\"Milestone\",V95<>\"\",\"Hourly\")","v":"Milestone"},"2022-12-01",null,null,{"$f":"_xlfn.IFS(X95=\"\", \"\", X95<>\"\", IF(Z95=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2023,2023005,"Denmark","Pond 2B EPEA Compliance","Stormwater","EPEA","Jennifer","Harry","Alison","Level 1",null,10183,452868,null,44.472945104586074,1,null,null,null,{"$f":"IF(AND('Master Project List'!$S96=\"\",'Master Project List'!$AA96<>\"Complete\"),\"\",_xlfn.IFS(AA96<>\"Complete\",\"-\",L96-M96<0,\"OVER\",AND(S96=\"\",AA96=\"Complete\"),\"N/A\", AND(L96=\"\",M96=\"\"),\"\", W96=\"\",\"\",S96=\"\",\"On Budget\",  S96=0, \"On Budget\", S96=\"\",\"\",S96<0, \"OVER\",AND(S96>0, AA96=\"complete\"), \"UNDER\",AND(S96>0, AA96<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L96=\"\",M96=\"\"),\"\",AND(V96<>\"\",L96<>\"\",L96<>0),\"TMU\",V96=\"\",\"Milestone\",V96<>\"\",\"Hourly\")","v":"Milestone"},"2022-12-01",null,null,{"$f":"_xlfn.IFS(X96=\"\", \"\", X96<>\"\", IF(Z96=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2023,2023006,"Qatar","EcoPark","Stormwater","DD","Jennifer","Harry","Hannah","Level 2",null,945509,836646,null,0.88486307375180984,null,null,null,null,{"$f":"IF(AND('Master Project List'!$S97=\"\",'Master Project List'!$AA97<>\"Complete\"),\"\",_xlfn.IFS(AA97<>\"Complete\",\"-\",L97-M97<0,\"OVER\",AND(S97=\"\",AA97=\"Complete\"),\"N/A\", AND(L97=\"\",M97=\"\"),\"\", W97=\"\",\"\",S97=\"\",\"On Budget\",  S97=0, \"On Budget\", S97=\"\",\"\",S97<0, \"OVER\",AND(S97>0, AA97=\"complete\"), \"UNDER\",AND(S97>0, AA97<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L97=\"\",M97=\"\"),\"\",AND(V97<>\"\",L97<>\"\",L97<>0),\"TMU\",V97=\"\",\"Milestone\",V97<>\"\",\"Hourly\")","v":"Milestone"},"2023-01-01",null,null,{"$f":"_xlfn.IFS(X97=\"\", \"\", X97<>\"\", IF(Z97=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[{"$f":"IFERROR(IF(X98=\"\",\"\",YEAR(X98)+IF(MONTH(X98)>=11,1,0)),\"\")","v":2023},2023007,"Estonia","144th Ave. SWMR","Stormwater","SWMR","Sam","Christian","Alison","Level 1",null,577105,822510,null,1.4252345760303584,null,null,null,null,{"$f":"IF(AND('Master Project List'!$S98=\"\",'Master Project List'!$AA98<>\"Complete\"),\"\",_xlfn.IFS(AA98<>\"Complete\",\"-\",L98-M98<0,\"OVER\",AND(S98=\"\",AA98=\"Complete\"),\"N/A\", AND(L98=\"\",M98=\"\"),\"\", W98=\"\",\"\",S98=\"\",\"On Budget\",  S98=0, \"On Budget\", S98=\"\",\"\",S98<0, \"OVER\",AND(S98>0, AA98=\"complete\"), \"UNDER\",AND(S98>0, AA98<>\"complete\"),\"-\"))","v":""},null,null,{"$f":"_xlfn.IFS(AND(L98=\"\",M98=\"\"),\"\",AND(V98<>\"\",L98<>\"\",L98<>0),\"TMU\",V98=\"\",\"Milestone\",V98<>\"\",\"Hourly\")","v":"Milestone"},"2023-02-13","2023-03-13",null,{"$f":"_xlfn.IFS(X98=\"\", \"\", X98<>\"\", IF(Z98=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},""]
[2022,2023014,"Cambodia","BWSM O&M","Wastewater","Construction","Jennifer","Elizabeth","Josh","Level 3",null,152883,565325,null,3.697762341136686,0.02,{"$f":"IF(P99=\"\",\"-\",M99+((L99*(1-P99))))","v":715150.34},{"$f":"IFERROR(L99-Q99,\"\")","v":-562267.34},{"$f":"IFERROR(_xlfn.IFS(AA99=\"Ongoing\", \"\", W99=\"hourly\", 0,OR(L99=\"\",M99=\"\"),\"\",AA99=\"Complete\", L99-M99,AA99<>\"complete\", \"\"),\"\")","v":""},{"$f":"_xlfn.IFS(AA99<>\"Complete\",\"-\",L99-M99<0,\"OVER\",AND(S99=\"\",AA99=\"Complete\"),\"N/A\", AND(L99=\"\",M99=\"\"),\"\", W99=\"\",\"\",S99=\"\",\"On Budget\",  S99=0, \"On Budget\", S99=\"\",\"\",S99<0, \"OVER\",AND(S99>0, AA99=\"complete\"), \"UNDER\",AND(S99>0, AA99<>\"complete\"),\"-\")","v":"-"},null,null,{"$f":"_xlfn.IFS(AND(L99=\"\",M99=\"\"),\"\",AND(V99<>\"\",L99<>\"\",L99<>0),\"TMU\",V99=\"\",\"Milestone\",V99<>\"\",\"Hourly\")","v":"Milestone"},"2022-10-20","2022-12-31",null,{"$f":"_xlfn.IFS(X99=\"\", \"\", X99<>\"\", IF(Z99=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"}]
[2020,"2019024OOS","Luxembourg","OOS","Stormwater","SMDP","Sam","Sam","N/A","Level 2",null,324770,734913,null,2.2628721864704251,1,{"$f":"IF(P100=\"\",\"-\",M100+((L100*(1-P100))))","v":734913},{"$f":"IFERROR(L100-Q100,\"\")","v":-410143},{"$f":"IFERROR(_xlfn.IFS(AA100=\"Ongoing\", \"\", W100=\"hourly\", 0,OR(L100=\"\",M100=\"\"),\"\",AA100=\"Complete\", L100-M100,AA100<>\"complete\", \"\"),\"\")","v":""},{"$f":"IF(AND('Master Project List'!$S100=\"\",'Master Project List'!$AA100<>\"Complete\"),\"\",_xlfn.IFS(AA100<>\"Complete\",\"-\",L100-M100<0,\"OVER\",AND(S100=\"\",AA100=\"Complete\"),\"N/A\", AND(L100=\"\",M100=\"\"),\"\", W100=\"\",\"\",S100=\"\",\"On Budget\",  S100=0, \"On Budget\", S100=\"\",\"\",S100<0, \"OVER\",AND(S100>0, AA100=\"complete\"), \"UNDER\",AND(S100>0, AA100<>\"complete\"),\"-\"))","v":""},null,552.25,{"$f":"_xlfn.IFS(AND(L100=\"\",M100=\"\"),\"\",AND(V100<>\"\",L100<>\"\",L100<>0),\"TMU\",V100=\"\",\"Milestone\",V100<>\"\",\"Hourly\")","v":"TMU"},"2020-06-01",null,null,{"$f":"_xlfn.IFS(X100=\"\", \"\", X100<>\"\", IF(Z100=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},{"$f":"IFERROR(IF(AND(X100=\"\",Z100=\"\"),\"\", WEEKNUM(_xlfn.DAYS(Z100,X100))),\"\")","v":""}]
[2021,"2020033OOS","Latvia","PH 25 OOS","Stormwater","Miscellaneous","Sahil","Sahil",null,null,null,589965,795371,null,1.3481664166518352,null,{"$f":"IF(P101=\"\",\"-\",M101+((L101*(1-P101))))","v":"-"},{"$f":"IFERROR(L101-Q101,\"\")","v":""},{"$f":"IFERROR(_xlfn.IFS(AA101=\"Ongoing\", \"\", W101=\"hourly\", 0,OR(L101=\"\",M101=\"\"),\"\",AA101=\"Complete\", L101-M101,AA101<>\"complete\", \"\"),\"\")","v":-205406},{"$f":"IF(AND('Master Project List'!$S101=\"\",'Master Project List'!$AA101<>\"Complete\"),\"\",_xlfn.IFS(AA101<>\"Complete\",\"-\",L101-M101<0,\"OVER\",AND(S101=\"\",AA101=\"Complete\"),\"N/A\", AND(L101=\"\",M101=\"\"),\"\", W101=\"\",\"\",S101=\"\",\"On Budget\",  S101=0, \"On Budget\", S101=\"\",\"\",S101<0, \"OVER\",AND(S101>0, AA101=\"complete\"), \"UNDER\",AND(S101>0, AA101<>\"complete\"),\"-\"))","v":"OVER"},null,null,{"$f":"_xlfn.IFS(AND(L101=\"\",M101=\"\"),\"\",AND(V101<>\"\",L101<>\"\",L101<>0),\"TMU\",V101=\"\",\"Milestone\",V101<>\"\",\"Hourly\")","v":"Milestone"},"2020-11-01",null,"2021-05-01",{"$f":"_xlfn.IFS(X101=\"\", \"\", X101<>\"\", IF(Z101=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},{"$f":"IFERROR(IF(AND(X101=\"\",Z101=\"\"),\"\", WEEKNUM(_xlfn.DAYS(Z101,X101))),\"\")","v":26}]
[2021,"2020039OOS","Liechtenstein","Pond G OOS","Stormwater","Miscellaneous","Sahil","Sahil",null,null,null,583024,385793,null,0.66171032410329589,null,{"$f":"IF(P102=\"\",\"-\",M102+((L102*(1-P102))))","v":"-"},{"$f":"IFERROR(L102-Q102,\"\")","v":""},{"$f":"IFERROR(_xlfn.IFS(AA102=\"Ongoing\", \"\", W102=\"hourly\", 0,OR(L102=\"\",M102=\"\"),\"\",AA102=\"Complete\", L102-M102,AA102<>\"complete\", \"\"),\"\")","v":197231},{"$f":"IF(AND('Master Project List'!$S102=\"\",'Master Project List'!$AA102<>\"Complete\"),\"\",_xlfn.IFS(AA102<>\"Complete\",\"-\",L102-M102<0,\"OVER\",AND(S102=\"\",AA102=\"Complete\"),\"N/A\", AND(L102=\"\",M102=\"\"),\"\", W102=\"\",\"\",S102=\"\",\"On Budget\",  S102=0, \"On Budget\", S102=\"\",\"\",S102<0, \"OVER\",AND(S102>0, AA102=\"complete\"), \"UNDER\",AND(S102>0, AA102<>\"complete\"),\"-\"))","v":"UNDER"},null,null,{"$f":"_xlfn.IFS(AND(L102=\"\",M102=\"\"),\"\",AND(V102<>\"\",L102<>\"\",L102<>0),\"TMU\",V102=\"\",\"Milestone\",V102<>\"\",\"Hourly\")","v":"Milestone"},"2021-06-01",null,"2021-08-01",{"$f":"_xlfn.IFS(X102=\"\", \"\", X102<>\"\", IF(Z102=\"\",\"Ongoing\", \"Complete\"))","v":"Complete"},{"$f":"IFERROR(IF(AND(X102=\"\",Z102=\"\"),\"\", WEEKNUM(_xlfn.DAYS(Z102,X102))),\"\")","v":9}]
[2023,2023015,"Libya","PH 18 SWMR","Stormwater","SWMR","Sam","Christian",null,null,null,986741,5001,null,null,null,null,null,null,null,null,null,null,"2023-03-21",null,null,{"$f":"_xlfn.IFS(X103=\"\", \"\", X103<>\"\", IF(Z103=\"\",\"Ongoing\", \"Complete\"))","v":"Ongoing"},{"$f":"IFERROR(IF(AND(X103=\"\",Z103=\"\"),\"\", WEEKNUM(_xlfn.DAYS(Z103,X103))),\"\")","v":""}]
[]
[{"$f":"IF($B105<>\"\",IF(LEFT($B105,1)=\"2\",LEFT($B105,4),IF(LEFT($B105,2)=\"AM\",MID($B105,2+1,LEN($B105)-(2+IF(LEN(CELL(\"contents\",$B105))>9,\"5\",\"3\"))),IF(LEFT($B105,3)=\"AWP\",MID($B105,3+1,LEN($B105)-(3+IF(LEN(CELL(\"contents\",$B105))>11,\"5\",\"3\")))))),\"\")","v":""}]
[{"$f":"IF($B106<>\"\",IF(LEFT($B106,1)=\"2\",LEFT($B106,4),IF(LEFT($B106,2)=\"AM\",MID($B106,2+1,LEN($B106)-(2+IF(LEN(CELL(\"contents\",$B106))>9,\"5\",\"3\"))),IF(LEFT($B106,3)=\"AWP\",MID($B106,3+1,LEN($B106)-(3+IF(LEN(CELL(\"contents\",$B106))>11,\"5\",\"3\")))))),\"\")","v":""}]
[{"$f":"IF($B107<>\"\",IF(LEFT($B107,1)=\"2\",LEFT($B107,4),IF(LEFT($B107,2)=\"AM\",MID($B107,2+1,LEN($B107)-(2+IF(LEN(CELL(\"contents\",$B107))>9,\"5\",\"3\"))),IF(LEFT($B107,3)=\"AWP\",MID($B107,3+1,LEN($B107)-(3+IF(LEN(CELL(\"contents\",$B107))>11,\"5\",\"3\")))))),\"\")","v":""}]
[{"$f":"IF($B108<>\"\",IF(LEFT($B108,1)=\"2\",LEFT($B108,4),IF(LEFT($B108,2)=\"AM\",MID($B108,2+1,LEN($B108)-(2+IF(LEN(CELL(\"contents\",$B108))>9,\"5\",\"3\"))),IF(LEFT($B108,3)=\"AWP\",MID($B108,3+1,LEN($B108)-(3+IF(LEN(CELL(\"contents\",$B108))>11,\"5\",\"3\")))))),\"\")","v":""}]
[{"$f":"IF($B109<>\"\",IF(LEFT($B109,1)=\"2\",LEFT($B109,4),IF(LEFT($B109,2)=\"AM\",MID($B109,2+1,LEN($B109)-(2+IF(LEN(CELL(\"contents\",$B109))>9,\"5\",\"3\"))),IF(LEFT($B109,3)=\"AWP\",MID($B109,3+1,LEN($B109)-(3+IF(LEN(CELL(\"contents\",$B109))>11,\"5\",\"3\")))))),\"\")","v":""}]
[{"$f":"IF($B110<>\"\",IF(LEFT($B110,1)=\"2\",LEFT($B110,4),IF(LEFT($B110,2)=\"AM\",MID($B110,2+1,LEN($B110)-(2+IF(LEN(CELL(\"contents\",$B110))>9,\"5\",\"3\"))),IF(LEFT($B110,3)=\"AWP\",MID($B110,3+1,LEN($B110)-(3+IF(LEN(CELL(\"contents\",$B110))>11,\"5\",\"3\")))))),\"\")","v":""}]
[{"$f":"IF($B111<>\"\",IF(LEFT($B111,1)=\"2\",LEFT($B111,4),IF(LEFT($B111,2)=\"AM\",MID($B111,2+1,LEN($B111)-(2+IF(LEN(CELL(\"contents\",$B111))>9,\"5\",\"3\"))),IF(LEFT($B111,3)=\"AWP\",MID($B111,3+1,LEN($B111)-(3+IF(LEN(CELL(\"contents\",$B111))>11,\"5\",\"3\")))))),\"\")","v":""}]
[{"$f":"IF($B112<>\"\",IF(LEFT($B112,1)=\"2\",LEFT($B112,4),IF(LEFT($B112,2)=\"AM\",MID($B112,2+1,LEN($B112)-(2+IF(LEN(CELL(\"contents\",$B112))>9,\"5\",\"3\"))),IF(LEFT($B112,3)=\"AWP\",MID($B112,3+1,LEN($B112)-(3+IF(LEN(CELL(\"contents\",$B112))>11,\"5\",\"3\")))))),\"\")","v":""}]
[{"$f":"IF($B113<>\"\",IF(LEFT($B113,1)=\"2\",LEFT($B113,4),IF(LEFT($B113,2)=\"AM\",MID($B113,2+1,LEN($B113)-(2+IF(LEN(CELL(\"contents\",$B113))>9,\"5\",\"3\"))),IF(LEFT($B113,3)=\"AWP\",MID($B113,3+1,LEN($B113)-(3+IF(LEN(CELL(\"contents\",$B113))>11,\"5\",\"3\")))))),\"\")","v":""}]
[{"$f":"IF($B114<>\"\",IF(LEFT($B114,1)=\"2\",LEFT($B114,4),IF(LEFT($B114,2)=\"AM\",MID($B114,2+1,LEN($B114)-(2+IF(LEN(CELL(\"contents\",$B114))>9,\"5\",\"3\"))),IF(LEFT($B114,3)=\"AWP\",MID($B114,3+1,LEN($B114)-(3+IF(LEN(CELL(\"contents\",$B114))>11,\"5\",\"3\")))))),\"\")","v":""}]

{"sheet":"References","index":1,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Project Health","Project Sponsors","Project Level","Updated Project Types/Phases","Definitions","Fiscal Year","Project Status","Schedule Status","MAGNA Services","TMU","Time & Materials Upset"]
["Healthy","Aaron","Level 1","Concept Design",null,2018,"Ongoing","IN PROGRESS","Stormwater"]
["Not Awesome","Jennifer","Level 2","Construction",null,2019,"Complete","PROPOSED","Wastewater"]
["On Fire","Jessica","Level 3","DD","Detailed Design",2020,null,"ON HOLD","Stakeholder Engagement"]
["N/A","Lisa",null,"DSSP","Development Site Servicing Plan",2021,null,"FUTURE","GIS/Mapping"]
[null,"Sam",null,"EPEA","Environmental Protection and Enhancement Act",2022,null,null,"Construction"]
[null,null,null,"Feasibility",null,2023,null,null,"Miscellaneous"]
[null,null,null,"GIS Mapping",null,null,null,null,"N/A"]
[null,null,null,"Grant Application"]
[null,null,null,"M & M","Monitoring & Maintenance"]
[null,null,null,"RFP","Request for Proposal Support"]
[null,null,null,"Sanitary Servicing"]
[null,null,null,"Site Servicing"]
[null,null,null,"SMDP","Staged Master Drainage Plan"]
[null,null,null,"Stakeholder Engagement"]
[null,null,null,"Stormwater","Misc stormwater projects"]
[null,null,null,"SWMR","Stormwater Management Report"]
[null,null,null,"Wastewater","Misc wastewater projects",null,"Project Coordinator"]
["Scope Progress",null,null,"Water Reuse",null,null,"N/A"]
[0.1,null,null,"Work Plan/Proposal",null,null,"Alison"]
[0.2,null,null,"Miscellaneous",null,null,"Hannah"]
[0.3,null,null,null,null,null,"JT"]
[0.4,null,null,null,null,null,"Josh"]
[0.5]
[0.6]
[0.7]
[0.8]
[0.9]
[1]