{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Instructions","Summary for SDTC","Project Funding ","DEPFC - CA","Cash Flow Forecast","Detailed Budget Summary - CA","Labour","Equip","Materials-Supplies","Consult-SubC","Travel","Overhead","Milestone Summary","SUMMARY"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":27,"comments":7,"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":"Instructions","index":0,"n_rows":56,"n_cols":3,"rows_kept":56,"cut":false,"hidden":false,"merged":[[18,0,22,0],[8,0,17,0],[3,0,7,0],[2,0,2,1]]}
[]
[]
["Funding requested from ERA",null,2000000]
["Project Information","ERA submission reference number",555555]
[null,"Project Title","Elsa's Winter Castle"]
[null,"Project Start Date","2022-01-05"]
[null,"Project End Date","2025-01-05"]
[null,"Number of Milestones \nNote: Maximum of 15 ",15]
["Project Partner Information (non-government)","Project Lead Name","Winterfell"]
[null,"Project Partner 1 Name","SpringBank Oil"]
[null,"Project Partner 2 Name","Gemstone drilling"]
[null,"Project Partner 3 Name","castle construction"]
[null,"Project Partner 4 Name"]
[null,"Project Partner 5 Name"]
[null,"Project Partner 6 Name"]
[null,"Project Partner 7 Name"]
[null,"Project Partner 8 Name"]
[null,"Project Partner 9 Name"]
["Government Funding Information","Government Funder 1 Name","NRCAN"]
[null,"Government Funder 2 Name"]
[null,"Government Funder 3 Name"]
[null,"Governement Funder 4 Name"]
[null,"Governement Funder 5 Name"]
[null,null,"Equity Raise"]
[null,null,"Debt Financing"]
[null,null,"Other"]
[]
[]
[null,null,"In Alberta"]
[null,null,"in Canada, but Outside Alberta"]
[null,null,"Outside of Canada"]
[null,null,"Private"]
[null,null,"Government"]
[null,null,"Other"]
[null,null,"CAD"]
[null,null,"Other"]
[null,null,"E"]
[null,null,"I"]
[null,null,"CO"]
[null,null,"SC"]
[null,null,"All"]
[null,null,"M1"]
[null,null,"M2"]
[null,null,"M3"]
[null,null,"M4"]
[null,null,"M5"]
[null,null,"M6"]
[null,null,"M7"]
[null,null,"M8"]
[null,null,"M9"]
[null,null,"M10"]
[null,null,"M11"]
[null,null,"M12"]
[null,null,"M13"]
[null,null,"M14"]
[null,null,"M15"]

{"sheet":"Summary for SDTC","index":1,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Payment Schedule"]
[]
["Milestone","Total Eligible Costs","SDTC \nContribution","SDTC Payment","Payment \nAmount","Scheduled \nPayment Date","Milestone \nEnd Date","Reports Due"]
["Milestone 1",{"$f":"'Detailed Budget Summary - CA'!D20+'Detailed Budget Summary - CA'!E20","v":{"$error":"#REF!"}},{"$f":"'Detailed Budget Summary - CA'!I16","v":{"$error":"#REF!"}},"Initial payment",{"$f":"C4*0.9","v":{"$error":"#REF!"}},{"$f":"IF(project_start=\"\",\"\",project_start)","v":{"$error":"#REF!"}},{"$f":"IF(MS_1=\"\",\"\",MS_1)","v":{"$error":"#REF!"}},{"$f":"IF(G4<>\"\",IF(G5<>\"\",G4+30,G4+90),\"\")","v":{"$error":"#REF!"}}]
["Milestone 2",{"$f":"'Detailed Budget Summary - CA'!D27+'Detailed Budget Summary - CA'!E27","v":{"$error":"#REF!"}},{"$f":"'Detailed Budget Summary - CA'!I23","v":{"$error":"#REF!"}},"Payment #2",{"$f":"C5*0.9","v":{"$error":"#REF!"}},{"$f":"IF(G4<>\"\",IF(G5<>\"\",H4+45,\"\"),\"\")","v":{"$error":"#REF!"}},{"$f":"IF(MS_2=\"\",\"\",MS_2)","v":"Government Funder 1 Name"},{"$f":"IF(G5<>\"\",IF(G6<>\"\",G5+30,G5+90),\"\")","v":{"$error":"#VALUE!"}}]
["Milestone 3",{"$f":"'Detailed Budget Summary - CA'!D34+'Detailed Budget Summary - CA'!E34","v":{"$error":"#REF!"}},{"$f":"'Detailed Budget Summary - CA'!I30","v":{"$error":"#REF!"}},"Payment #3",{"$error":"#REF!"},{"$f":"IF(G5<>\"\",IF(G6<>\"\",H5+45,\"\"),\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(MS_3=\"\",\"\",MS_3)","v":"Government Funder 2 Name"},{"$error":"#VALUE!"}]
["Milestone 4",{"$f":"'Detailed Budget Summary - CA'!D41+'Detailed Budget Summary - CA'!E41","v":{"$error":"#REF!"}},{"$f":"'Detailed Budget Summary - CA'!I37","v":{"$error":"#REF!"}},"Payment #4",{"$error":"#REF!"},{"$f":"IF(G6<>\"\",IF(G7<>\"\",H6+45,\"\"),\"\")","v":""},{"$f":"IF(MS_4=\"\",\"\",MS_4)","v":""},""]
["Milestone 5",{"$f":"'Detailed Budget Summary - CA'!D48+'Detailed Budget Summary - CA'!E48","v":{"$error":"#REF!"}},{"$f":"'Detailed Budget Summary - CA'!I44","v":{"$error":"#REF!"}},"Payment #5",{"$error":"#REF!"},{"$f":"IF(G7<>\"\",IF(G8<>\"\",H7+45,\"\"),\"\")","v":""},{"$f":"IF(MS_5=\"\",\"\",MS_5)","v":""},""]
["Milestone 6",{"$f":"'Detailed Budget Summary - CA'!D55+'Detailed Budget Summary - CA'!E55","v":{"$error":"#REF!"}},{"$f":"'Detailed Budget Summary - CA'!I51","v":{"$error":"#REF!"}},"Payment #6",{"$error":"#REF!"},"",{"$f":"IF(MS_6=\"\",\"\",MS_6)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Milestone 7",{"$f":"'Detailed Budget Summary - CA'!D62+'Detailed Budget Summary - CA'!E62","v":{"$error":"#REF!"}},{"$f":"'Detailed Budget Summary - CA'!I58","v":{"$error":"#REF!"}},"Payment #7",{"$error":"#REF!"},{"$f":"IF(G9<>\"\",IF(G10<>\"\",H9+45,\"\"),\"\")","v":{"$error":"#REF!"}},{"$f":"IF(project_end=\"\",\"\",project_end)","v":""},{"$f":"IF(G10<>\"\",G10+90,\"\")","v":""}]
["Final Payment",null,null,"Holdback",{"$f":"SUM(C4:C10)*0.1","v":{"$error":"#REF!"}},{"$f":"IF(H4=\"\",\"\",IF(H5=\"\",H4+90,IF(H6=\"\",H5+90,IF(H7=\"\",H6+90,IF(H8=\"\",H7+90,IF(H9=\"\",H8+90,IF(H10=\"\",H9+90,H10+90)))))))","v":{"$error":"#REF!"}}]

{"sheet":"Project Funding ","index":2,"n_rows":35,"n_cols":29,"rows_kept":35,"cut":false,"hidden":false,"merged":[[5,17,7,25]]}
["Proposed Project Funding Details"]
["ERA PROJECT NUMBER",{"$f":"SOI","v":555555}]
["PROJECT LEAD",{"$f":"Instructions!C9","v":"Winterfell"}]
["PROJECT TITLE",{"$f":"Company_name","v":"Elsa's Winter Castle"}]
[]
["Project Funders/Partners","Location of Funding Organization","Funding Type","Funding Currency\n(e.g. CAD or Other - specify)","Specify Funding Currency\n(if not CAD)","Exchange Rate\n(if not CAD)","Confirmed Funding (Funding Currency)","Unconfirmed Funding (Funding Currency)",null,"Confirmed Funding* (CAD)","Unconfirmed Funding (CAD)","Total Funding (CAD)",null,"Inside\nAlberta","In Canada, but outside Alberta","Outside of Canada","Total",null,null,null,null,null,null,null,null,null,null,null,"In Alberta"]
["ERA","In Alberta","ERA","CAD",null,null,{"$f":"Instructions!C3","v":2000000},null,null,{"$f":"IF(D7=\"CAD\",G7,G7*F7)","v":2000000},{"$f":"IF(D7=\"CAD\",H7,H7*F7)","v":0},{"$f":"SUM(J7:K7)","v":2000000},null,{"$f":"IF(B7=\"In Alberta\",L7,0)","v":2000000},{"$f":"IF(B7=\"In Canada, but outside Alberta\",L7,0)","v":0},{"$f":"IF(B7=\"Outside of Canada\",L7,0)","v":0},{"$f":"SUM(N7:P7)","v":2000000},null,null,null,null,null,null,null,null,null,null,null,"In Canada, but outside Alberta"]
["Winterfell","In Alberta","Private","CAD",null,null,2000000,null,null,2000000,0,{"$f":"SUM(J8:K8)","v":2000000},null,2000000,0,0,{"$f":"SUM(N8:P8)","v":2000000},null,null,null,null,null,null,null,null,null,null,null,"Outside of Canada"]
["SpringBank Oil","In Alberta","Private","CAD",null,null,3000000,null,null,3000000,0,{"$f":"SUM(J9:K9)","v":3000000},null,3000000,0,0,{"$f":"SUM(N9:P9)","v":3000000}]
["Gemstone drilling","In Canada, but outside Alberta","Private","CAD",null,null,2000000,null,null,2000000,0,2000000,null,0,2000000,0,2000000,null,null,null,null,null,null,null,null,null,null,null,"Y"]
["castle construction","In Canada, but outside Alberta","Private","CAD",null,null,2000000,null,null,2000000,0,2000000,null,0,2000000,0,2000000,null,null,null,null,null,null,null,null,null,null,null,"N"]
["NRCAN","In Canada, but outside Alberta","Government","CAD",null,null,2475000,null,null,2475000,0,2475000,null,0,2475000,0,2475000]
[null,null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,{"$f":"SUM(J16:K16)","v":0},null,{"$f":"IF(B16=\"In Alberta\",#REF!,0)","v":0},{"$f":"IF(B16=\"In Canada, but outside Alberta\",#REF!,0)","v":0},{"$f":"IF(B16=\"Outside of Canada\",#REF!,0)","v":0},{"$f":"SUM(N16:P16)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,{"$f":"SUM(J17:K17)","v":0},null,{"$f":"IF(B17=\"In Alberta\",#REF!,0)","v":0},{"$f":"IF(B17=\"In Canada, but outside Alberta\",#REF!,0)","v":0},{"$f":"IF(B17=\"Outside of Canada\",#REF!,0)","v":0},0]
[null,null,null,null,null,null,null,null,null,0,0,{"$f":"SUM(J18:K18)","v":0},null,{"$f":"IF(B18=\"In Alberta\",#REF!,0)","v":0},{"$f":"IF(B18=\"In Canada, but outside Alberta\",#REF!,0)","v":0},{"$f":"IF(B18=\"Outside of Canada\",#REF!,0)","v":0},0]
[null,null,null,null,null,null,null,null,null,0,0,0,null,{"$f":"IF(B19=\"In Alberta\",#REF!,0)","v":0},{"$f":"IF(B19=\"In Canada, but outside Alberta\",#REF!,0)","v":0},{"$f":"IF(B19=\"Outside of Canada\",#REF!,0)","v":0},0]
[null,null,null,null,null,null,null,null,null,0,0,0,null,{"$f":"IF(B20=\"In Alberta\",#REF!,0)","v":0},{"$f":"IF(B20=\"In Canada, but outside Alberta\",#REF!,0)","v":0},{"$f":"IF(B20=\"Outside of Canada\",#REF!,0)","v":0},0]
[null,null,null,null,null,null,null,null,null,0,0,{"$f":"SUM(J21:K21)","v":0},null,{"$f":"IF(B21=\"In Alberta\",#REF!,0)","v":0},{"$f":"IF(B21=\"In Canada, but outside Alberta\",#REF!,0)","v":0},{"$f":"IF(B21=\"Outside of Canada\",#REF!,0)","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J7:J21)","v":13475000},0,{"$f":"SUM(L7:L21)","v":13475000},null,{"$f":"SUM(N7:N21)","v":7000000},6475000,0,{"$f":"SUM(Q7:Q21)","v":13475000}]
[]
[]
[null,null,null,null,null,null,null,"Total Project Funding (CAD)",null,null,null,{"$f":"L22","v":13475000}]
[]
[null,null,null,null,null,null,null,"Total Government Funding (incl ERA)",null,null,null,{"$f":"SUMIF(C7:C21,\"Government\",L7:L21)+G7","v":4475000}]
[]
[null,null,null,null,null,null,null,"Total Private Funding",null,null,null,{"$f":"SUMIF(C7:C21,\"Private\",L7:L21)","v":9000000}]
[]
[null,null,null,null,null,null,null,"ERA % of Total Project Funding",null,null,null,{"$f":"$G$7/L25","v":0.14842300556586271}]
[]
[null,null,null,null,null,null,null,"ERA % of Total Private Funding",null,null,null,{"$f":"$G$7/(SUMIF(C7:C21,\"Private\",L7:L21))","v":0.22222222222222221}]
[]
[null,null,null,null,null,null,null,"% Government Funding/Total Budget",null,null,null,{"$f":"L27/L25","v":0.33209647495361783}]

{"sheet":"DEPFC - CA","index":3,"n_rows":90,"n_cols":11,"rows_kept":90,"cut":false,"hidden":true,"merged":[[67,0,67,1],[80,0,80,1]]}
[]
["Detailed Eligible Project Funding Contribution"]
[]
["Funding Commitments","Confirmed Cash ($) ","Unconfirmed Cash ($)","Source Type \n(Cash)","Confirmed\nIn-Kind($)","Unconfirmed\nIn-Kind($)","Source Type \n(In-Kind)","Confirmed Totals ($)","Unconfirmed Totals ($)"," Totals ($)","Time Period to Obtain Funding"]
["ELIGIBLE PROJECT FUNDING"]
["Consortium Members:"]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"B7+E7","v":{"$error":"#REF!"}},{"$f":"C7+F7","v":{"$error":"#REF!"}},{"$f":"SUM(H7:I7)","v":{"$error":"#REF!"}}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"B8+E8","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUM(H8:I8)","v":{"$error":"#REF!"}}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"B17+E17","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"B18+E18","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"B19+E19","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"B20+E20","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["Government Funding \n(specify program)",null,null,"Federal (GF), Provincial (GP) or Municipal (GM)",null,null,"Federal (GF), Provincial (GP) or Municipal (GM)"]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"B26+E26","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUM(H26:I26)","v":{"$error":"#REF!"}}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["SDTC ",{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},0,null,null,null,null,{"$error":"#REF!"},0,{"$error":"#REF!"}]
[]
["SDTC % of Total Project Funding",null,null,null,null,null,null,null,null,{"$f":"IF(J65<>0,MAX(B31,C31)/J65,\" - \")","v":{"$error":"#REF!"}}]
["SDTC % of Eligible Project Funding",null,null,null,null,null,null,null,null,{"$f":"IF(J36<>0,MAX(B31:C31)/J36,\" - \")","v":{"$error":"#REF!"}}]
[]
["TOTAL ELIGIBLE PROJECT FUNDING",{"$f":"SUM(B7:B32)","v":{"$error":"#REF!"}},{"$f":"SUM(C7:C32)","v":{"$error":"#REF!"}},null,{"$f":"SUM(E7:E32)","v":{"$error":"#REF!"}},{"$f":"SUM(F7:F32)","v":{"$error":"#REF!"}},null,{"$f":"SUM(H7:H32)","v":{"$error":"#REF!"}},{"$f":"SUM(I7:I32)","v":{"$error":"#REF!"}},{"$f":"SUM(J7:J32)","v":{"$error":"#REF!"}}]
[]
["INELIGIBLE PROJECT FUNDING"]
["Consortium Members:"]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"B40+E40","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUM(H40:I40)","v":{"$error":"#REF!"}}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["Government Funding \n(specify program)",null,null,"Federal (GF), Provincial (GP) or Municipal (GM)",null,null,"Federal (GF), Provincial (GP) or Municipal (GM)"]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"B58+E58","v":{"$error":"#REF!"}},{"$f":"C58+F58","v":{"$error":"#REF!"}},{"$f":"SUM(H58:I58)","v":{"$error":"#REF!"}}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$f":"'Project Funding '!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
["TOTAL INELIGIBLE PROJECT FUNDING",{"$f":"SUM(B40:B63)","v":{"$error":"#REF!"}},{"$f":"SUM(C40:C63)","v":{"$error":"#REF!"}},null,{"$f":"SUM(E40:E63)","v":{"$error":"#REF!"}},{"$f":"SUM(F40:F63)","v":{"$error":"#REF!"}},null,{"$f":"SUM(H40:H63)","v":{"$error":"#REF!"}},{"$f":"SUM(I40:I63)","v":{"$error":"#REF!"}},{"$f":"SUM(J40:J63)","v":{"$error":"#REF!"}}]
["TOTAL PROJECT FUNDING",{"$f":"B64+B36","v":{"$error":"#REF!"}},{"$f":"C64+C36","v":{"$error":"#REF!"}},null,{"$f":"E64+E36","v":{"$error":"#REF!"}},{"$f":"F64+F36","v":{"$error":"#REF!"}},null,{"$f":"H64+H36","v":{"$error":"#REF!"}},{"$f":"I64+I36","v":{"$error":"#REF!"}},{"$f":"J64+J36","v":{"$error":"#REF!"}}]
[]
[]
["Funding Source Summary"]
[" "]
["Description","Amount","% of Eligible \nProject Costs"]
["Total Eligible Project Costs",{"$f":"'Detailed Budget Summary - CA'!D65","v":{"$error":"#REF!"}}]
["Total Ineligible Project Costs",{"$f":"'Detailed Budget Summary - CA'!F64","v":{"$error":"#REF!"}},null,{"$f":"IF(J64<B72,\" Ineligible funds do not meet ineligble costs\",\"\")","v":{"$error":"#REF!"}}]
["Total Project Costs",{"$f":"'Detailed Budget Summary - CA'!D66","v":{"$error":"#REF!"}}]
["Eligible Consortium Members Funds",{"$f":"SUM(J7:J23)","v":{"$error":"#REF!"}},{"$f":"IF(B$71<>0,B74/B$71, )","v":{"$error":"#REF!"}},{"$f":"IF(AND(C74<25%, C74>0), \" Consortium portion of eligible costs < 25%\", \" \" )","v":{"$error":"#REF!"}}]
["SDTC Funds",{"$f":"J31","v":{"$error":"#REF!"}},{"$f":"IF(B$71<>0,B75/B$71, )","v":{"$error":"#REF!"}},{"$f":"IF(C75>50%, \" SDTC portion of eligible costs > 50%\", \" \" )","v":{"$error":"#REF!"}}]
["Eligible Other Government Funds",{"$f":"SUM(J26:J30)","v":{"$error":"#REF!"}},{"$f":"IF(B$71<>0,B76/B$71,)","v":{"$error":"#REF!"}},{"$f":"IF(C75+C76>75%, \" SDTC+Gov portion of eligible costs >75%\", \" \" )","v":{"$error":"#REF!"}}]
["Total Eligible Funds",{"$f":"J36","v":{"$error":"#REF!"}},{"$f":"SUM(C74:C76)","v":{"$error":"#REF!"}},{"$f":"IF(AND(B71<>0,C77<100%), \" Funds do not cover costs\", \" \" )","v":{"$error":"#REF!"}}]
["Total Project Funds",{"$f":"J65","v":{"$error":"#REF!"}},{"$f":"IF(B73<>0,B78/B73,)","v":{"$error":"#REF!"}},{"$f":"IF(AND(B73<>0,C78<100%), \" Funds do not cover costs\", \" \" )","v":{"$error":"#REF!"}}]
[]
[]
["Funding Status"]
[]
["Description","Amount","% of Required Funding"]
["Confirmed Cash",{"$f":"B65","v":{"$error":"#REF!"}},{"$f":"IF($B$90=0,0,IF(B84/$B$90>0,B84/$B$90,\"-\"))","v":{"$error":"#REF!"}}]
["Confirmed In-Kind",{"$f":"E65","v":{"$error":"#REF!"}},{"$f":"IF($B$90=0,0,IF(B85/$B$90>0,B85/$B$90,\"-\"))","v":{"$error":"#REF!"}}]
["Total Confirmed Funds",{"$f":"SUM(B84:B85)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Unconfirmed Cash",{"$f":"C65","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Unconfirmed In-Kind",{"$f":"F65","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Total Unconfirmed Funds",{"$f":"SUM(B87:B88)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Total Project Funds",{"$f":"B89+B86","v":{"$error":"#REF!"}},{"$error":"#REF!"}]

{"sheet":"Cash Flow Forecast","index":4,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":true,"merged":[[3,0,3,7],[8,0,8,7],[21,0,21,7]]}
[{"$f":"\"Cash Flow Forecast for \"&Instructions!#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Milestone 1","Milestone 2","Milestone 3","Milestone 4","Milestone 5","Milestone 6","Milestone 7","Comments"]
["Company Expenditures"]
["SDTC Project - Eligible Cash Costs",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["SDTC Project - Non Eligible Cash Costs",{"$f":"Labour!#REF!+Travel!#REF!+Equip!#REF!+'Consult-SubC'!#REF!+'Materials-Supplies'!#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}}]
["Other Company Expenditures"]
["Total Expenditures",{"$f":"B5+B6+B7","v":{"$error":"#REF!"}},{"$f":"C5+C6+C7","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Confirmed Sources of Funding"]
["Cash On Hand at Milestone Start",null,{"$f":"B21","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Project Related Revenues"]
["Other Revenues"]
["Cash Contributions from Consortium Members"]
["Investors"]
["Loans"]
["SR&ED (Project Related)"]
["SR&ED (Other)"]
["Other Grants"]
["SDTC",{"$f":"'Summary for SDTC'!E4","v":{"$error":"#REF!"}},{"$f":"'Summary for SDTC'!E5","v":{"$error":"#REF!"}},{"$f":"'Summary for SDTC'!E6","v":{"$error":"#REF!"}},{"$f":"'Summary for SDTC'!E7","v":{"$error":"#REF!"}},{"$f":"'Summary for SDTC'!E8","v":{"$error":"#REF!"}},{"$f":"'Summary for SDTC'!E9","v":{"$error":"#REF!"}},{"$f":"'Summary for SDTC'!E10","v":{"$error":"#REF!"}}]
["Total Confirmed Funding",{"$f":"SUM(B10:B19)","v":{"$error":"#REF!"}},{"$f":"SUM(C10:C19)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Balance",{"$f":"B20-B8","v":{"$error":"#REF!"}},{"$f":"C20-C8","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Unconfirmed Sources of Funding"]
["Cash On Hand at Milestone Start",{"$f":"B10","v":0},{"$f":"B34","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Project Related Revenues"]
["Other Revenues"]
["Cash Contributions from Consortium Members"]
["Investors"]
["Loans"]
["SR&ED (Project Related)"]
["SR&ED (Other)"]
["Other Grants"]
["Total Unconfirmed Funding",{"$f":"SUM(B23:B31)","v":0},{"$f":"SUM(C23:C31)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Total Funding",{"$f":"SUM(B11:B19)+SUM(B23:B31)","v":{"$error":"#REF!"}},{"$f":"SUM(C11:C19)+SUM(C23:C31)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Balance",{"$f":"B33-B8","v":{"$error":"#REF!"}},{"$f":"C33-C8","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"Detailed Budget Summary - CA","index":5,"n_rows":66,"n_cols":10,"rows_kept":66,"cut":false,"hidden":true,"merged":[[12,0,13,0],[12,1,13,1],[12,2,13,2],[12,3,12,5],[12,6,12,9],[13,7,13,9],[22,7,23,7],[22,8,23,8],[22,9,23,9],[15,7,16,7],[15,8,16,8],[15,9,16,9],[17,7,18,7],[17,8,18,8],[17,9,18,9],[19,2,20,2],[19,5,20,5],[19,6,20,6],[19,7,20,9],[20,3,20,4],[24,7,25,7],[24,8,25,8],[24,9,25,9],[26,2,27,2],[26,5,27,5],[26,6,27,6],[26,7,27,9],[27,3,27,4],[36,7,37,7],[36,8,37,8],[36,9,37,9],[29,7,30,7],[29,8,30,8],[29,9,30,9],[31,7,32,7],[31,8,32,8],[31,9,32,9],[33,2,34,2],[33,5,34,5],[33,6,34,6],[33,7,34,9],[34,3,34,4],[38,7,39,7],[38,8,39,8],[38,9,39,9],[40,2,41,2],[40,5,41,5],[40,6,41,6],[40,7,41,9],[41,3,41,4],[50,7,51,7],[50,8,51,8],[50,9,51,9],[43,7,44,7],[43,8,44,8],[43,9,44,9],[45,7,46,7],[45,8,46,8],[45,9,46,9],[47,2,48,2],[47,5,48,5],[47,6,48,6],[47,7,48,9],[48,3,48,4],[52,7,53,7],[52,8,53,8],[52,9,53,9],[54,2,55,2],[54,5,55,5],[54,6,55,6],[54,7,55,9],[55,3,55,4],[63,6,65,6],[63,7,65,9],[64,3,64,4],[65,3,65,5],[57,7,58,7],[57,8,58,8],[57,9,58,9],[59,7,60,7],[59,8,60,8],[59,9,60,9],[61,2,62,2],[61,5,62,5],[61,6,62,6],[61,7,62,9],[62,3,62,4]]}
["Project Financial Certification Report (PFCR)"]
["Contract Number:",null,{"$f":"SOI","v":555555}]
["Consortium Name:",null,{"$f":"Company_name","v":"Elsa's Winter Castle"}]
["Date of Report:"]
["NOTE: A detailed report of all project expenditures must be included with this report (a copy of the project expenditure ledger will suffice) "]
["and copies of invoices over $1000.00 must be made available for review and submitted with the Final Project Report."]
["NOTE: SDTC's contribution can never exceed the percentage contribution approved by the Board at any given time. "]
[]
[]
["The information provided on this report is hereby certified to be true and accurate: _________________________________________________"]
["                                                                                                                                                                       Name                            Title"]
[]
["Date","Milestone","Activity/Description of Expenses","Budget",null,null,"Contributors"]
[null,null,null,"Eligible Cash ","Eligible In-kind ","Ineligible","In-kind Contributions","Cash Contributions"]
[{"$f":"MS_1","v":{"$error":"#REF!"}},"Milestone 1","Labour",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}},"Contributor","Amount","%"]
[null,null,"Travel",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}},"SDTC",{"$f":"D21*J16","v":{"$error":"#REF!"}},{"$f":"'DEPFC - CA'!$C$75","v":{"$error":"#REF!"}}]
[null,null,"Equipment ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}}]
[null,null,"Sub-contractors & Consultants",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}},"Other",{"$f":"D20-I16","v":{"$error":"#REF!"}},{"$f":"IF(D21<>0,I18/D21,)","v":{"$error":"#REF!"}}]
[null,null,"Other Costs",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}}]
[null,null,"Totals for Milestone 1:",{"$f":"SUM(D15:D19)","v":{"$error":"#REF!"}},{"$f":"SUM(E15:E19)","v":{"$error":"#REF!"}},{"$f":"SUM(F15:F19)","v":{"$error":"#REF!"}},{"$f":"IF(D21<>0,E20/D21,)","v":{"$error":"#REF!"}},{"$f":"IF(D21<>0,D20/D21,)","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"D20+E20","v":{"$error":"#REF!"}}]
[{"$f":"MS_2","v":"Government Funder 1 Name"},"Milestone 2","Labour",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}},"Contributor","Amount","%"]
[null,null,"Travel",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}},"SDTC",{"$f":"D28*J23","v":{"$error":"#REF!"}},{"$f":"'DEPFC - CA'!$C$75","v":{"$error":"#REF!"}}]
[null,null,"Equipment ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}}]
[null,null,"Sub-contractors & Consultants",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}},"Other",{"$f":"D27-I23","v":{"$error":"#REF!"}},{"$f":"IF(D28<>0,I25/D28,)","v":{"$error":"#REF!"}}]
[null,null,"Other Costs",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}}]
[null,null,"Totals for Milestone 2:",{"$f":"SUM(D22:D26)","v":{"$error":"#REF!"}},{"$f":"SUM(E22:E26)","v":{"$error":"#REF!"}},{"$f":"SUM(F22:F26)","v":{"$error":"#REF!"}},{"$f":"IF(D28<>0,E27/D28,)","v":{"$error":"#REF!"}},{"$f":"IF(D28<>0,D27/D28,)","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"D27+E27","v":{"$error":"#REF!"}}]
[{"$f":"MS_3","v":"Government Funder 2 Name"},"Milestone 3","Labour",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}},"Contributor","Amount","%"]
[null,null,"Travel",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}},"SDTC",{"$f":"D35*J30","v":{"$error":"#REF!"}},{"$f":"'DEPFC - CA'!$C$75","v":{"$error":"#REF!"}}]
[null,null,"Equipment ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}}]
[null,null,"Sub-contractors & Consultants",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}},"Other",{"$f":"D34-I30","v":{"$error":"#REF!"}},{"$f":"IF(D35<>0,I32/D35,)","v":{"$error":"#REF!"}}]
[null,null,"Other Costs",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}}]
[null,null,"Totals for Milestone 3:",{"$f":"SUM(D29:D33)","v":{"$error":"#REF!"}},{"$f":"SUM(E29:E33)","v":{"$error":"#REF!"}},{"$f":"SUM(F29:F33)","v":{"$error":"#REF!"}},{"$f":"IF(D35<>0,E34/D35,)","v":{"$error":"#REF!"}},{"$f":"IF(D35<>0,D34/D35,)","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"D34+E34","v":{"$error":"#REF!"}}]
[{"$f":"MS_4","v":"00:00:00"},"Milestone 4","Labour",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}},"Contributor","Amount","%"]
[null,null,"Travel",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}},"SDTC",{"$f":"D42*J37","v":{"$error":"#REF!"}},{"$f":"'DEPFC - CA'!$C$75","v":{"$error":"#REF!"}}]
[null,null,"Equipment ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}}]
[null,null,"Sub-contractors & Consultants",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}},"Other",{"$f":"D41-I37","v":{"$error":"#REF!"}},{"$f":"IF(D42<>0,I39/D42,)","v":{"$error":"#REF!"}}]
[null,null,"Other Costs",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}}]
[null,null,"Totals for Milestone 4:",{"$f":"SUM(D36:D40)","v":{"$error":"#REF!"}},{"$f":"SUM(E36:E40)","v":{"$error":"#REF!"}},{"$f":"SUM(F36:F40)","v":{"$error":"#REF!"}},{"$f":"IF(D42<>0,E41/D42,)","v":{"$error":"#REF!"}},{"$f":"IF(D42<>0,D41/D42,)","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"D41+E41","v":{"$error":"#REF!"}}]
[{"$f":"MS_5","v":"00:00:00"},"Milestone 5","Labour",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}},"Contributor","Amount","%"]
[null,null,"Travel",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}},"SDTC",{"$f":"D49*J44","v":{"$error":"#REF!"}},{"$f":"'DEPFC - CA'!$C$75","v":{"$error":"#REF!"}}]
[null,null,"Equipment ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}}]
[null,null,"Sub-contractors & Consultants",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}},"Other",{"$f":"D48-I44","v":{"$error":"#REF!"}},{"$f":"IF(D49<>0,I46/D49,)","v":{"$error":"#REF!"}}]
[null,null,"Other Costs",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}}]
[null,null,"Totals for Milestone 5:",{"$f":"SUM(D43:D47)","v":{"$error":"#REF!"}},{"$f":"SUM(E43:E47)","v":{"$error":"#REF!"}},{"$f":"SUM(F43:F47)","v":{"$error":"#REF!"}},{"$f":"IF(D49<>0,E48/D49,)","v":{"$error":"#REF!"}},{"$f":"IF(D49<>0,D48/D49,)","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"D48+E48","v":{"$error":"#REF!"}}]
[{"$f":"Instructions!#REF!","v":{"$error":"#REF!"}},"Milestone 6","Labour",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}},"Contributor","Amount","%"]
[null,null,"Travel",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}},"SDTC",{"$f":"D56*J51","v":{"$error":"#REF!"}},{"$f":"'DEPFC - CA'!$C$75","v":{"$error":"#REF!"}}]
[null,null,"Equipment ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}}]
[null,null,"Sub-contractors & Consultants",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}},"Other",{"$f":"D55-I51","v":{"$error":"#REF!"}},{"$f":"IF(D56<>0,I53/D56,)","v":{"$error":"#REF!"}}]
[null,null,"Other Costs",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}}]
[null,null,"Totals for Milestone 6:",{"$f":"SUM(D50:D54)","v":{"$error":"#REF!"}},{"$f":"SUM(E50:E54)","v":{"$error":"#REF!"}},{"$f":"SUM(F50:F54)","v":{"$error":"#REF!"}},{"$f":"IF(D56<>0,E55/D56,)","v":{"$error":"#REF!"}},{"$f":"IF(D56<>0,D55/D56,)","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"D55+E55","v":{"$error":"#REF!"}}]
[{"$f":"project_end","v":"00:00:00"},"Milestone 7","Labour",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}},"Contributor","Amount","%"]
[null,null,"Travel",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}},"SDTC",{"$f":"D63*J58","v":{"$error":"#REF!"}},{"$f":"'DEPFC - CA'!$C$75","v":{"$error":"#REF!"}}]
[null,null,"Equipment ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}}]
[null,null,"Sub-contractors & Consultants",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}},"Other",{"$f":"D62-I58","v":{"$error":"#REF!"}},{"$f":"IF(D63<>0,I60/D63,)","v":{"$error":"#REF!"}}]
[null,null,"Other Costs",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" \", \"\"), IF(#REF!<>0, \"- \"&#REF!&\" -\", \"- \"))","v":{"$error":"#REF!"}}]
[null,null,"Totals for Milestone 7:",{"$f":"SUM(D57:D61)","v":{"$error":"#REF!"}},{"$f":"SUM(E57:E61)","v":{"$error":"#REF!"}},{"$f":"SUM(F57:F61)","v":{"$error":"#REF!"}},{"$f":"IF(D63<>0,E62/D63,)","v":{"$error":"#REF!"}},{"$f":"IF(D63<>0,D62/D63,)","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"D62+E62","v":{"$error":"#REF!"}}]
[null,null,"Totals for all Milestones:",{"$f":"D20+D27+D34+D41+D48+D55+D62","v":{"$error":"#REF!"}},{"$f":"E20+E27+E34+E41+E48+E55+E62","v":{"$error":"#REF!"}},{"$f":"F20+F27+F34+F41+F48+F55+F62","v":{"$error":"#REF!"}},{"$f":"IF(D65<>0,E64/D65,)","v":{"$error":"#REF!"}},{"$f":"IF(D65<>0,D64/D65,)","v":{"$error":"#REF!"}}]
[null,null,"Totals Eligible Project Costs:",{"$f":"D64+E64","v":{"$error":"#REF!"}}]
[null,null,"Total Project Costs:",{"$f":"D65+F64","v":{"$error":"#REF!"}}]

{"sheet":"Labour","index":6,"n_rows":43,"n_cols":29,"rows_kept":43,"cut":false,"hidden":false,"merged":[[10,24,10,27],[32,0,32,11],[38,0,38,11]]}
["Project Labour Expense Forecast"]
["ERA PROJECT NUMBER",{"$f":"SOI","v":555555}]
["PROJECT LEAD",{"$f":"Instructions!C9","v":"Winterfell"}]
["PROJECT TITLE",{"$f":"Company_name","v":"Elsa's Winter Castle"}]
[]
["Location","Jobs Created (FTE) due to the project being funded","Location(s), if outside Alberta"]
["In Alberta"]
["In Canada, but outside Alberta"]
["Outside Canada"]
["TOTAL Jobs",{"$f":"SUM(B7:C9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summary of Geographical Spending"]
["Employer (Applicant or Partner)\n","Title/Function of employee","Location of Employee","Project Expense: Eligible (E) or Ineligible (I)","Total Project Salary Expense ($)","Total Fringe Benefits expense for employee [Maximum is 20% of salary expense]","Indicate which Milestone this expense occurs in","% of Fringe benefits ","Total Eligible Fringe Benefits","Total Ineligible fringe benefits","Total Eligible Labour Expense","Total Ineligible Labour Expense","Total Labour expense ",null,"Eligible Labour expense in Alberta","Eligible Labour expense in Canada, but outside Alberta","Eligible Labour Expense Outside of Canada"]
["Winterfell","PM","In Alberta","E",200000,100000,"M5",{"$f":"IFERROR(F13/E13,0)","v":0.5},{"$f":"IF(D13=\"E\",IF(H13>20%,IF(D13=\"E\",E13*0.2,E13*H13),E13*H13),0)","v":40000},{"$f":"IF(D13=\"E\",IF(H13>0.2,(H13-0.2)*E13,0),E13*H13)","v":60000},{"$f":"IF(D13=\"E\",E13,0)+I13","v":240000},{"$f":"IF(D13=\"I\",E13,0)+J13","v":60000},{"$f":"SUM(K13:L13)","v":300000},null,{"$f":"IF((AND(C13=\"In Alberta\",D13=\"E\")),(E13+F13),0)","v":300000},{"$f":"IF((AND(C13=\"In Canada, but outside Alberta\",D13=\"E\")),(E13+F13),0)","v":0},{"$f":"IF((AND(C13=\"Outside Canada\",D13=\"E\")),(E13+F13),0)","v":0}]
["Winterfell","PM","In Alberta","E",200000,0,"M5",{"$f":"IFERROR(F14/E14,0)","v":0},0,{"$f":"IF(D14=\"E\",IF(H14>0.2,(H14-0.2)*E14,0),E14*H14)","v":0},{"$f":"IF(D14=\"E\",E14,0)+I14","v":200000},{"$f":"IF(D14=\"I\",E14,0)+J14","v":0},{"$f":"SUM(K14:L14)","v":200000},null,200000,0,{"$f":"IF((AND(C14=\"Outside Canada\",D14=\"E\")),(E14+F14),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Y"]
["Gemstone drilling","Eng","In Alberta","I",200000,0,"M3",0,0,0,0,200000,200000,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,"N"]
["castle construction","Eng","In Alberta","I",200000,0,"M3",0,0,0,0,200000,200000,null,0,0,0]
["SpringBank Oil","eng","In Alberta","E",200000,0,"M3",0,0,0,200000,0,200000,null,200000,0,0]
["SpringBank Oil","Eng","In Alberta","E",200000,0,"M12",0,0,0,200000,0,200000,null,200000,0,0]
["Gemstone drilling","yy","In Canada, but outside Alberta","I",200000,0,"M4",0,0,0,0,200000,200000,null,0,0,0]
["SpringBank Oil","yy","In Canada, but outside Alberta","E",200000,0,"All",0,0,0,200000,0,200000,null,0,200000,0]
["castle construction",null,"In Canada, but outside Alberta","I",200000,0,"All",0,0,0,0,200000,200000,null,0,0,0]
["castle construction",null,"In Canada, but outside Alberta","E",200000,0,"M5",0,0,0,200000,0,200000,null,0,200000,0]
["castle construction",null,"In Canada, but outside Alberta","E",200000,0,"All",0,0,0,200000,0,200000,null,0,200000,0]
["Winterfell",null,"In Canada, but outside Alberta","E",200000,0,"M11",0,0,0,200000,0,200000,null,0,200000,0]
["Gemstone drilling",null,"In Alberta","I",200000,0,"M11",0,0,0,0,200000,200000,null,0,0,0]
["Gemstone drilling",null,"Outside Canada","E",200000,0,"M13",0,0,0,{"$f":"IF(D26=\"E\",E26,0)+I26","v":200000},{"$f":"IF(D26=\"I\",E26,0)+J26","v":0},{"$f":"SUM(K26:L26)","v":200000},null,{"$f":"IF((AND(C26=\"In Alberta\",D26=\"E\")),(E26+F26),0)","v":0},{"$f":"IF((AND(C26=\"In Canada, but outside Alberta\",D26=\"E\")),(E26+F26),0)","v":0},{"$f":"IF((AND(C26=\"Outside Canada\",D26=\"E\")),(E26+F26),0)","v":200000}]
["Gemstone drilling",null,"In Canada, but outside Alberta","E",200000,0,"M12",0,0,0,200000,0,200000,null,0,200000,0]
["Gemstone drilling",null,"In Canada, but outside Alberta","I",200000,0,"M5",0,0,0,0,200000,200000,null,0,0,0]
[null,null,null,"I",200000,0,"M13",0,0,0,0,200000,200000,null,0,0,0]
[null,null,null,"E",200000,0,"All",0,0,0,200000,0,200000,null,0,0,0]
[null,null,null,null,{"$f":"SUM(E13:E30)","v":3600000},{"$f":"SUM(F13:F30)","v":100000},null,null,null,null,{"$f":"SUM(K13:K30)","v":2240000},{"$f":"SUM(L13:L30)","v":1460000},{"$f":"SUM(M13:M30)","v":3700000},null,{"$f":"SUM(O13:O30)","v":900000},{"$f":"SUM(P13:P30)","v":1000000},{"$f":"SUM(Q13:Q30)","v":200000}]
[]
["Milestone summary - Eligible Labor Expense by Milestone"]
["Milestone 1","Milestone 2","Milestone 3","Milestone 4","Milestone 5","Milestone 6","Milestone 7","Milestone 8","Milestone 9","Milestone 10","Milestone 11","Milestone 12","Milestone 13","Milestone 14","Milestone 15","Total"]
[{"$f":"A36/$P$36","v":1.7857142857142856E-2},1.7857142857142856E-2,0.10714285714285714,1.7857142857142856E-2,0.30357142857142855,1.7857142857142856E-2,1.7857142857142856E-2,1.7857142857142856E-2,1.7857142857142856E-2,1.7857142857142856E-2,0.10714285714285714,0.19642857142857142,0.10714285714285714,1.7857142857142856E-2,1.7857142857142856E-2,{"$f":"SUM(A35:O35)","v":1}]
[{"$f":"(SUMIF(G13:G30,\"M1\",K13:K30))+(A37/Instructions!$C$8)","v":40000},{"$f":"SUMIF(G13:G30,\"M2\",K13:K30)+A37/Instructions!C8","v":40000},{"$f":"SUMIF(G13:G30,\"M3\",K13:K30)+A37/Instructions!C8","v":240000},{"$f":"SUMIF(G13:G30,\"M4\",K13:K30)+A37/Instructions!C8","v":40000},{"$f":"SUMIF(G13:G30,\"M5\",K13:K30)+A37/Instructions!C8","v":680000},{"$f":"SUMIF(G13:G30,\"M6\",K13:K30)+A37/Instructions!C8","v":40000},{"$f":"SUMIF(G13:G30,\"M7\",K13:K30)+A37/Instructions!C8","v":40000},{"$f":"SUMIF(G13:G30,\"M8\",K13:K30)+A37/Instructions!C8","v":40000},{"$f":"SUMIF(G13:G30,\"M9\",K13:K30)+A37/Instructions!C8","v":40000},{"$f":"SUMIF(G13:G30,\"M10\",K13:K30)+A37/Instructions!C8","v":40000},{"$f":"SUMIF(G13:G30,\"M11\",K13:K30)+$A$37/Instructions!$C$8","v":240000},{"$f":"SUMIF(G13:G30,\"M12\",K13:K30)+$A$37/Instructions!$C$8","v":440000},{"$f":"SUMIF(G13:G30,\"M13\",K13:K30)+$A$37/Instructions!$C$8","v":240000},{"$f":"SUMIF(G13:G30,\"M14\",K13:K30)+$A$37/Instructions!$C$8","v":40000},{"$f":"SUMIF(G13:G30,\"M15\",K13:K30)+$A$37/Instructions!$C$8","v":40000},{"$f":"SUM(A36:O36)","v":2240000},"Please delete data from this row for un-used milestones"]
[{"$f":"SUMIF(G13:G30,\"All\",K13:K30)","v":600000}]
[]
["Milestone summary - inEligible Labor Expense by Milestone"]
["Milestone 1","Milestone 2","Milestone 3","Milestone 4","Milestone 5","Milestone 6","Milestone 7","Milestone 8","Milestone 9","Milestone 10","Milestone 11","Milestone 12","Milestone 13","Milestone 14","Milestone 15","Total"]
[{"$f":"A42/$P$42","v":9.1324200913242021E-3},9.1324200913242021E-3,0.28310502283105021,0.14611872146118723,0.18721461187214611,9.1324200913242021E-3,9.1324200913242021E-3,9.1324200913242021E-3,9.1324200913242021E-3,9.1324200913242021E-3,0.14611872146118723,9.1324200913242021E-3,0.14611872146118723,9.1324200913242021E-3,9.1324200913242021E-3,{"$f":"SUM(A41:O41)","v":1}]
[{"$f":"(SUMIF(G13:G30,\"M1\",L13:L30))+(A43/Instructions!$C$8)","v":13333.333333333334},{"$f":"SUMIF(G13:G30,\"M2\",L13:L30)+(A43/Instructions!$C$8)","v":13333.333333333334},{"$f":"SUMIF(G13:G30,\"M3\",L13:L30)+(A43/Instructions!$C$8)","v":413333.33333333331},{"$f":"SUMIF(G13:G30,\"M4\",L13:L30)+(A43/Instructions!$C$8)","v":213333.33333333334},{"$f":"SUMIF(G13:G30,\"M5\",L13:L30)+(A43/Instructions!$C$8)","v":273333.33333333331},{"$f":"SUMIF(G13:G30,\"M6\",L13:L30)+(A43/Instructions!$C$8)","v":13333.333333333334},{"$f":"SUMIF(G13:G30,\"M7\",L13:L30)+(A43/Instructions!$C$8)","v":13333.333333333334},{"$f":"SUMIF(G13:G30,\"M8\",L13:L30)+(A43/Instructions!$C$8)","v":13333.333333333334},{"$f":"SUMIF(G13:G30,\"M9\",L13:L30)+(A43/Instructions!$C$8)","v":13333.333333333334},{"$f":"SUMIF(G13:G30,\"M10\",L13:L30)+(A43/Instructions!$C$8)","v":13333.333333333334},{"$f":"SUMIF(G13:G30,\"M11\",L13:L30)+(A43/Instructions!$C$8)","v":213333.33333333334},{"$f":"SUMIF(G13:G30,\"M12\",L13:L30)+(A43/Instructions!$C$8)","v":13333.333333333334},{"$f":"SUMIF(G13:G30,\"M13\",L13:L30)+(A43/Instructions!$C$8)","v":213333.33333333334},{"$f":"SUMIF(G13:G30,\"M14\",L13:L30)+(A43/Instructions!$C$8)","v":13333.333333333334},{"$f":"SUMIF(G13:G30,\"M15\",L13:L30)+(A43/Instructions!$C$8)","v":13333.333333333334},{"$f":"SUM(A42:O42)","v":1460000},"Please delete data from this row for un-used milestones"]
[{"$f":"SUMIF(G13:G30,\"All\",L13:L30)","v":200000}]

{"sheet":"Equip","index":7,"n_rows":35,"n_cols":29,"rows_kept":35,"cut":false,"hidden":false,"merged":[[5,13,5,15],[24,0,24,9],[30,0,30,9]]}
["Project Equipment Expense Forecast"]
["ERA PROJECT NUMBER",{"$f":"SOI","v":555555}]
["PROJECT LEAD",{"$f":"Instructions!C9","v":"Winterfell"}]
["PROJECT TITLE",{"$f":"Company_name","v":"Elsa's Winter Castle"}]
[]
[]
["Project Partner (e.g. entity funding equipment)\n(if applicable)","Vendor\n(if applicable)","Item Description","Indicate which Milestone this expense occurs in","Location of Vendor/Service Provider","Project Expense: Eligible (E) or Ineligible (I)","Total Item Cost (CAD)","Eligible Equipment Expense","Ineligible Equipment Expense","Total Equipment Expense",null,"Eligible Economic spend Inside Alberta","Eligible Economic spend In Canada, but outside Alberta","Eligible Economic spend Outside of Canada"]
["Winterfell",null,null,"M7","In Alberta","E",5000,{"$f":"IF(F8=\"E\",G8,0)","v":5000},{"$f":"IF(F8=\"I\",G8,0)","v":0},{"$f":"G8","v":5000},null,{"$f":"IF(E8=\"In Alberta\",H8,0)","v":5000},{"$f":"IF(E8=\"In Canada, but outside Alberta\",H8,0)","v":0},{"$f":"IF(E8=\"Outside of Canada\",H8,0)","v":0}]
["Gemstone drilling",null,null,"M8","In Alberta","I",5000,{"$f":"IF(F9=\"E\",G9,0)","v":0},{"$f":"IF(F9=\"I\",G9,0)","v":5000},{"$f":"G9","v":5000},null,{"$f":"IF(E9=\"In Alberta\",H9,0)","v":0},{"$f":"IF(E9=\"In Canada, but outside Alberta\",H9,0)","v":0},{"$f":"IF(E9=\"Outside of Canada\",H9,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
["NRCAN",null,null,"M9",null,"I",5000,0,5000,5000,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,"M10",null,"E",5000,5000,0,5000,null,0,0,0]
[null,null,null,"M11",null,"I",5000,0,5000,5000,null,0,0,0]
[null,null,null,"M12",null,"E",5000,5000,0,5000,null,0,0,0]
[null,null,null,"M13",null,"E",5000,5000,0,5000,null,0,0,0]
[null,null,null,"M14",null,"I",5000,0,5000,5000,null,0,0,0]
[null,null,null,"M15",null,"I",5000,0,5000,5000,null,0,0,0]
[null,null,null,"M2",null,"E",5000,5000,0,5000,null,0,0,0]
[null,null,null,"M3",null,"E",5000,5000,0,5000,null,0,0,0]
[null,null,null,"M4",null,"E",5000,5000,0,5000,null,0,0,0]
[null,null,null,"M13",null,"E",5000,5000,0,5000,null,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G8:G20)","v":65000},{"$f":"SUM(H8:H20)","v":40000},{"$f":"SUM(I8:I20)","v":25000},{"$f":"SUM(J8:J20)","v":65000},null,{"$f":"SUM(L8:L20)","v":5000},{"$f":"SUM(M8:M20)","v":0},{"$f":"SUM(N8:N20)","v":0}]
[]
[]
[]
["Milestone summary - Eligible  Expense by Milestone"]
["Milestone 1","Milestone 2","Milestone 3","Milestone 4","Milestone 5","Milestone 6","Milestone 7","Milestone 8","Milestone 9","Milestone 10","Milestone 11","Milestone 12","Milestone 13","Milestone 14","Milestone 15","Total"]
[{"$f":"A28/$P$28","v":0},0.125,0.125,0.125,0,0,0.125,0,0,0.125,0,0.125,{"$f":"M28/$P$28","v":0.25},0,0,{"$f":"SUM(A27:O27)","v":1}]
[{"$f":"(SUMIF($D$8:$D$20,\"M1\",$H$8:$H$20))+($A$29/Instructions!$C$8)","v":0},{"$f":"(SUMIF($D$8:$D$20,\"M2\",$H$8:$H$20))+($A$29/Instructions!$C$8)","v":5000},{"$f":"(SUMIF($D$8:$D$20,\"M3\",$H$8:$H$20))+($A$29/Instructions!$C$8)","v":5000},{"$f":"(SUMIF($D$8:$D$20,\"M4\",$H$8:$H$20))+($A$29/Instructions!$C$8)","v":5000},{"$f":"(SUMIF($D$8:$D$20,\"M5\",$H$8:$H$20))+($A$29/Instructions!$C$8)","v":0},{"$f":"(SUMIF($D$8:$D$20,\"M6\",$H$8:$H$20))+($A$29/Instructions!$C$8)","v":0},{"$f":"(SUMIF($D$8:$D$20,\"M7\",$H$8:$H$20))+($A$29/Instructions!$C$8)","v":5000},{"$f":"(SUMIF($D$8:$D$20,\"M8\",$H$8:$H$20))+($A$29/Instructions!$C$8)","v":0},{"$f":"(SUMIF($D$8:$D$20,\"M9\",$H$8:$H$20))+($A$29/Instructions!$C$8)","v":0},{"$f":"(SUMIF($D$8:$D$20,\"M10\",$H$8:$H$20))+($A$29/Instructions!$C$8)","v":5000},{"$f":"(SUMIF($D$8:$D$20,\"M11\",$H$8:$H$20))+($A$29/Instructions!$C$8)","v":0},{"$f":"(SUMIF($D$8:$D$20,\"M12\",$H$8:$H$20))+($A$29/Instructions!$C$8)","v":5000},{"$f":"(SUMIF($D$8:$D$20,\"M13\",$H$8:$H$20))+($A$29/Instructions!$C$8)","v":10000},{"$f":"(SUMIF($D$8:$D$20,\"M14\",$H$8:$H$20))+($A$29/Instructions!$C$8)","v":0},{"$f":"(SUMIF($D$8:$D$20,\"M15\",$H$8:$H$20))+($A$29/Instructions!$C$8)","v":0},{"$f":"SUM(A28:O28)","v":40000},"Please delete data from this row for un-used milestones"]
[{"$f":"SUMIF(D8:D20,\"All\",H8:H20)","v":0}]
[]
["Milestone summary - InEligible  Expense by Milestone"]
["Milestone 1","Milestone 2","Milestone 3","Milestone 4","Milestone 5","Milestone 6","Milestone 7","Milestone 8","Milestone 9","Milestone 10","Milestone 11","Milestone 12","Milestone 13","Milestone 14","Milestone 15","Total"]
[{"$f":"A34/$P$34","v":0},0,0,0,0,0,0,0.2,0.2,0,{"$f":"K34/$P$34","v":0.2},0,0,0.2,0.2,{"$f":"SUM(A33:O33)","v":1}]
[{"$f":"(SUMIF($D$8:$D$20,\"M1\",$I$8:$I$20))+($A$35/Instructions!$C$8)","v":0},{"$f":"(SUMIF($D$8:$D$20,\"M2\",$I$8:$I$20))+($A$35/Instructions!$C$8)","v":0},{"$f":"(SUMIF($D$8:$D$20,\"M3\",$I$8:$I$20))+($A$35/Instructions!$C$8)","v":0},{"$f":"(SUMIF($D$8:$D$20,\"M4\",$I$8:$I$20))+($A$35/Instructions!$C$8)","v":0},{"$f":"(SUMIF($D$8:$D$20,\"M5\",$I$8:$I$20))+($A$35/Instructions!$C$8)","v":0},{"$f":"(SUMIF($D$8:$D$20,\"M6\",$I$8:$I$20))+($A$35/Instructions!$C$8)","v":0},{"$f":"(SUMIF($D$8:$D$20,\"M7\",$I$8:$I$20))+($A$35/Instructions!$C$8)","v":0},{"$f":"(SUMIF($D$8:$D$20,\"M8\",$I$8:$I$20))+($A$35/Instructions!$C$8)","v":5000},{"$f":"(SUMIF($D$8:$D$20,\"M9\",$I$8:$I$20))+($A$35/Instructions!$C$8)","v":5000},{"$f":"(SUMIF($D$8:$D$20,\"M10\",$I$8:$I$20))+($A$35/Instructions!$C$8)","v":0},{"$f":"(SUMIF($D$8:$D$20,\"M11\",$I$8:$I$20))+($A$35/Instructions!$C$8)","v":5000},{"$f":"(SUMIF($D$8:$D$20,\"M12\",$I$8:$I$20))+($A$35/Instructions!$C$8)","v":0},{"$f":"(SUMIF($D$8:$D$20,\"M13\",$I$8:$I$20))+($A$35/Instructions!$C$8)","v":0},{"$f":"(SUMIF($D$8:$D$20,\"M14\",$I$8:$I$20))+($A$35/Instructions!$C$8)","v":5000},{"$f":"(SUMIF($D$8:$D$20,\"M15\",$I$8:$I$20))+($A$35/Instructions!$C$8)","v":5000},{"$f":"SUM(A34:O34)","v":25000},"Please delete data from this row for un-used milestones"]
[{"$f":"SUMIF(D8:D20,\"All\",I8:I20)","v":0}]

{"sheet":"Materials-Supplies","index":8,"n_rows":35,"n_cols":27,"rows_kept":35,"cut":false,"hidden":false,"merged":[[24,0,24,9],[30,0,30,9]]}
["Project Materials and Supplies Expense Forecast"]
["ERA PROJECT NUMBER",{"$f":"SOI","v":555555}]
["PROJECT LEAD",{"$f":"Instructions!C9","v":"Winterfell"}]
["PROJECT TITLE",{"$f":"Company_name","v":"Elsa's Winter Castle"}]
[]
["Project Partner (e.g. who is funding it)\n(if applicable)","Vendor\n(if applicable)","Description of  Item","Location of Vendor/Service Provider/Contractor","Project Expense: Eligible (E) or Ineligible (I)","Indicate which Milestone this expense occurs in","Cost\n($)","Eligible M&S Amount ","Ineligible M&S Amount ","Total Expenses",null,"Eligible Economic spend Inside Alberta","Eligible Economic spend In Canada, but outside Alberta","Eligible Economic spend Outside of Canada"]
["SpringBank Oil",null,null,null,"E","M2",60000,{"$f":"IF(E7=\"E\",G7,0)","v":60000},{"$f":"IF(E7=\"I\",G7,0)","v":0},{"$f":"G7","v":60000},null,{"$f":"IF(D7=\"In Alberta\",H7,0)","v":0},{"$f":"IF(D7=\"In Canada, but outside Alberta\",H7,0)","v":0},{"$f":"IF(D7=\"Outside of Canada\",H7,0)","v":0}]
["castle construction",null,null,null,"I","M3",60000,{"$f":"IF(E8=\"E\",G8,0)","v":0},{"$f":"IF(E8=\"I\",G8,0)","v":60000},60000,null,{"$f":"IF(D8=\"In Alberta\",H8,0)","v":0},{"$f":"IF(D8=\"In Canada, but outside Alberta\",H8,0)","v":0},{"$f":"IF(D8=\"Outside of Canada\",H8,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
["Gemstone drilling",null,null,null,"E","M4",60000,60000,0,60000,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
["NRCAN",null,null,null,"I","M5",60000,0,60000,60000,null,0,0,0]
["Gemstone drilling",null,null,null,"I","M6",60000,0,60000,60000,null,0,0,0]
[null,null,null,null,"I","M7",60000,0,60000,60000,null,0,0,0]
[null,null,null,null,"E","M8",60000,60000,0,60000,null,0,0,0]
[null,null,null,null,"E","M9",60000,60000,0,60000,null,0,0,0]
[null,null,null,null,"I","All",60000,0,60000,60000,null,0,0,0]
[null,null,null,null,"E","M11",60000,60000,0,60000,null,0,0,0]
[null,null,null,null,"E","M12",60000,60000,0,60000,null,0,0,0]
[null,null,null,null,"E","M13",60000,60000,0,60000,null,0,0,0]
[null,null,null,null,"E","M14",60000,60000,0,60000,null,0,0,0]
[null,null,null,null,"E","M15",60000,60000,0,60000,null,0,0,0]
[null,null,null,null,"E","M1",60000,60000,0,60000,null,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G7:G21)","v":900000},{"$f":"SUM(H7:H21)","v":600000},{"$f":"SUM(I7:I21)","v":300000},{"$f":"SUM(J7:J21)","v":900000},null,{"$f":"SUM(L7:L21)","v":0},{"$f":"SUM(M7:M21)","v":0},{"$f":"SUM(N7:N21)","v":0}]
[]
[]
["Milestone summary - Eligible  Expense by Milestone"]
["Milestone 1","Milestone 2","Milestone 3","Milestone 4","Milestone 5","Milestone 6","Milestone 7","Milestone 8","Milestone 9","Milestone 10","Milestone 11","Milestone 12","Milestone 13","Milestone 14","Milestone 15","Total"]
[{"$f":"A28/$P$28","v":0.1},{"$f":"B28/$P$28","v":0.1},{"$f":"C28/$P$28","v":0},0.1,0,0,0,0.1,0.1,0,0.1,{"$f":"L28/$P$28","v":0.1},0.1,0.1,0.1,{"$f":"SUM(A27:O27)","v":0.99999999999999989}]
[{"$f":"(SUMIF(F7:F21,\"M1\",H7:H21))+($A$29/Instructions!$C$8)","v":60000},{"$f":"(SUMIF(F7:F21,\"M2\",H7:H21))+($A$29/Instructions!$C$8)","v":60000},{"$f":"(SUMIF(F7:F21,\"M3\",H7:H21))+($A$29/Instructions!$C$8)","v":0},{"$f":"(SUMIF(F7:F21,\"M4\",H7:H21))+($A$29/Instructions!$C$8)","v":60000},{"$f":"(SUMIF(F7:F21,\"M5\",H7:H21))+($A$29/Instructions!$C$8)","v":0},{"$f":"(SUMIF(F7:F21,\"M6\",H7:H21))+($A$29/Instructions!$C$8)","v":0},{"$f":"(SUMIF(F7:F21,\"M7\",H7:H21))+($A$29/Instructions!$C$8)","v":0},{"$f":"(SUMIF(F7:F21,\"M8\",H7:H21))+($A$29/Instructions!$C$8)","v":60000},{"$f":"(SUMIF(F7:F21,\"M9\",H7:H21))+($A$29/Instructions!$C$8)","v":60000},{"$f":"(SUMIF(F7:F21,\"M10\",H7:H21))+($A$29/Instructions!$C$8)","v":0},{"$f":"(SUMIF(F7:F21,\"M11\",H7:H21))+($A$29/Instructions!$C$8)","v":60000},{"$f":"(SUMIF(F7:F21,\"M12\",H7:H21))+($A$29/Instructions!$C$8)","v":60000},{"$f":"(SUMIF(F7:F21,\"M13\",H7:H21))+($A$29/Instructions!$C$8)","v":60000},{"$f":"(SUMIF(F7:F21,\"M14\",H7:H21))+($A$29/Instructions!$C$8)","v":60000},{"$f":"(SUMIF(F7:F21,\"M15\",H7:H21))+($A$29/Instructions!$C$8)","v":60000},{"$f":"SUM(A28:O28)","v":600000},"Please delete data from this row for un-used milestones"]
[{"$f":"SUMIF(F7:F21,\"All\",H7:H21)","v":0}]
[]
["Milestone summary - inEligible  Expense by Milestone"]
["Milestone 1","Milestone 2","Milestone 3","Milestone 4","Milestone 5","Milestone 6","Milestone 7","Milestone 8","Milestone 9","Milestone 10","Milestone 11","Milestone 12","Milestone 13","Milestone 14","Milestone 15","Total"]
[{"$f":"A34/$P$34","v":1.3333333333333334E-2},1.3333333333333334E-2,0.21333333333333335,1.3333333333333334E-2,0.21333333333333335,0.21333333333333335,0.21333333333333335,1.3333333333333334E-2,1.3333333333333334E-2,1.3333333333333334E-2,{"$f":"K34/$P$34","v":1.3333333333333334E-2},1.3333333333333334E-2,1.3333333333333334E-2,1.3333333333333334E-2,1.3333333333333334E-2,{"$f":"SUM(A33:O33)","v":0.99999999999999989}]
[{"$f":"(SUMIF(F7:F21,\"M1\",I7:I21))+($A$35/Instructions!$C$8)","v":4000},{"$f":"(SUMIF(F7:F21,\"M2\",I7:I21))+($A$35/Instructions!$C$8)","v":4000},{"$f":"(SUMIF(F7:F21,\"M3\",I7:I21))+($A$35/Instructions!$C$8)","v":64000},{"$f":"(SUMIF(F7:F21,\"M4\",I7:I21))+($A$35/Instructions!$C$8)","v":4000},{"$f":"(SUMIF(F7:F21,\"M5\",I7:I21))+($A$35/Instructions!$C$8)","v":64000},{"$f":"(SUMIF(F7:F21,\"M6\",I7:I21))+($A$35/Instructions!$C$8)","v":64000},{"$f":"(SUMIF(F7:F21,\"M7\",I7:I21))+($A$35/Instructions!$C$8)","v":64000},{"$f":"(SUMIF(F7:F21,\"M8\",I7:I21))+($A$35/Instructions!$C$8)","v":4000},{"$f":"(SUMIF(F7:F21,\"M9\",I7:I21))+($A$35/Instructions!$C$8)","v":4000},{"$f":"(SUMIF(F7:F21,\"M10\",I7:I21))+($A$35/Instructions!$C$8)","v":4000},{"$f":"(SUMIF(F7:F21,\"M11\",I7:I21))+($A$35/Instructions!$C$8)","v":4000},{"$f":"(SUMIF(F7:F21,\"M12\",I7:I21))+($A$35/Instructions!$C$8)","v":4000},{"$f":"(SUMIF(F7:F21,\"M13\",I7:I21))+($A$35/Instructions!$C$8)","v":4000},{"$f":"(SUMIF(F7:F21,\"M14\",I7:I21))+($A$35/Instructions!$C$8)","v":4000},{"$f":"(SUMIF(F7:F21,\"M15\",I7:I21))+($A$35/Instructions!$C$8)","v":4000},{"$f":"SUM(A34:O34)","v":300000},"Please delete data from this row for un-used milestones"]
[{"$f":"SUMIF(F7:F21,\"All\",I7:I21)","v":60000}]

{"sheet":"Consult-SubC","index":9,"n_rows":36,"n_cols":28,"rows_kept":36,"cut":false,"hidden":false,"merged":[[25,0,25,9],[31,0,31,9]]}
["Project Consulting Expense Forecast"]
["ERA PROJECT NUMBER",{"$f":"SOI","v":555555}]
["PROJECT LEAD",{"$f":"Instructions!C9","v":"Winterfell"}]
["PROJECT TITLE",{"$f":"Company_name","v":"Elsa's Winter Castle"}]
[]
["Project Partner (e.g. entity funding the consulting work)\n(if applicable)","Vendor\n(if applicable)","Expense Type\nConsulting (CO) or\nSubcontract (SC)","Description of  Work","Location of Sub-Contractor/Consultant","Indicate which Milestone this expense occurs in","Project Expense: Eligible (E) or Ineligible (I)","Total Cost (CAD)","Eligible Sub-Contracting or Consulting Amount ","Ineligible Sub-Contracting or Consulting Amount ","Total Expenses",null,"Eligible Economic spend Inside Alberta","Eligible Economic spend In Canada, but outside Alberta","Eligible Economic spend Outside of Canada"]
["Winterfell",null,null,null,null,"All","I",10000,{"$f":"IF(G7=\"E\",H7,0)","v":0},{"$f":"IF(G7=\"I\",H7,0)","v":10000},{"$f":"SUM(I7:J7)","v":10000},null,{"$f":"IF(E7=\"In Alberta\",I7,0)","v":0},{"$f":"IF(E7=\"In Canada, but outside Alberta\",I7,0)","v":0},{"$f":"IF(E7=\"Outside of Canada\",I7,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,"M1","I",10000,{"$f":"IF(G8=\"E\",H8,0)","v":0},{"$f":"IF(G8=\"I\",H8,0)","v":10000},{"$f":"SUM(I8:J8)","v":10000},null,{"$f":"IF(E8=\"In Alberta\",I8,0)","v":0},{"$f":"IF(E8=\"In Canada, but outside Alberta\",I8,0)","v":0},{"$f":"IF(E8=\"Outside of Canada\",I8,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,"M2","E",10000,10000,0,{"$f":"SUM(I9:J9)","v":10000},null,0,0,0]
[null,null,null,null,null,"M3","I",10000,0,10000,10000,null,0,0,0]
[null,null,null,null,null,"M4","I",10000,0,10000,10000,null,0,0,0]
[null,null,null,null,null,"M5","I",10000,0,10000,10000,null,0,0,0]
[null,null,null,null,null,"M6","I",10000,0,10000,10000,null,0,0,0]
[null,null,null,null,null,"M7","I",10000,0,10000,10000,null,0,0,0]
[null,null,null,null,null,"All","I",10000,0,10000,10000,null,0,0,0]
[null,null,null,null,null,"M12","E",10000,10000,0,10000,null,0,0,0]
[null,null,null,null,null,"M15","E",10000,10000,0,10000,null,0,0,0]
[null,null,null,null,null,"All","E",10000,10000,0,10000,null,0,0,0]
[null,null,null,null,null,"All","E",10000,10000,0,10000,null,0,0,0]
[null,null,null,null,null,"All","E",10000,10000,0,10000,null,0,0,0]
[null,null,null,null,null,"All","E",10000,10000,0,10000,null,0,0,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H7:H21)","v":150000},{"$f":"SUM(I7:I21)","v":70000},{"$f":"SUM(J7:J21)","v":80000},{"$f":"SUM(K7:K21)","v":150000},null,{"$f":"SUM(M7:M21)","v":0},{"$f":"SUM(N7:N21)","v":0},{"$f":"SUM(O7:O21)","v":0}]
[]
[]
[]
["Milestone summary - Eligible  Expense by Milestone"]
["Milestone 1","Milestone 2","Milestone 3","Milestone 4","Milestone 5","Milestone 6","Milestone 7","Milestone 8","Milestone 9","Milestone 10","Milestone 11","Milestone 12","Milestone 13","Milestone 14","Milestone 15","Total"]
[{"$f":"A29/$P$29","v":3.8095238095238092E-2},0.18095238095238095,3.8095238095238092E-2,3.8095238095238092E-2,3.8095238095238092E-2,3.8095238095238092E-2,3.8095238095238092E-2,3.8095238095238092E-2,3.8095238095238092E-2,3.8095238095238092E-2,{"$f":"K29/$P$29","v":3.8095238095238092E-2},0.18095238095238095,3.8095238095238092E-2,3.8095238095238092E-2,0.18095238095238095,{"$f":"SUM(A28:O28)","v":0.99999999999999978}]
[{"$f":"(SUMIF(F7:F21,\"M1\",I7:I21))+($A$30/Instructions!$C$8)","v":2666.6666666666665},{"$f":"(SUMIF(F7:F21,\"M2\",I7:I21))+($A$30/Instructions!$C$8)","v":12666.666666666666},{"$f":"(SUMIF(F7:F21,\"M3\",I7:I21))+($A$30/Instructions!$C$8)","v":2666.6666666666665},{"$f":"(SUMIF(F7:F21,\"M4\",I7:I21))+($A$30/Instructions!$C$8)","v":2666.6666666666665},{"$f":"(SUMIF(F7:F21,\"M5\",I7:I21))+($A$30/Instructions!$C$8)","v":2666.6666666666665},{"$f":"(SUMIF(F7:F21,\"M6\",I7:I21))+($A$30/Instructions!$C$8)","v":2666.6666666666665},{"$f":"(SUMIF(F7:F21,\"M7\",I7:I21))+($A$30/Instructions!$C$8)","v":2666.6666666666665},{"$f":"(SUMIF(F7:F21,\"M8\",I7:I21))+($A$30/Instructions!$C$8)","v":2666.6666666666665},{"$f":"(SUMIF(F7:F21,\"M9\",I7:I21))+($A$30/Instructions!$C$8)","v":2666.6666666666665},{"$f":"(SUMIF(F7:F21,\"M10\",I7:I21))+($A$30/Instructions!$C$8)","v":2666.6666666666665},{"$f":"(SUMIF(F7:F21,\"M11\",I7:I21))+($A$30/Instructions!$C$8)","v":2666.6666666666665},{"$f":"(SUMIF(F7:F21,\"M12\",I7:I21))+($A$30/Instructions!$C$8)","v":12666.666666666666},{"$f":"(SUMIF(F7:F21,\"M13\",I7:I21))+($A$30/Instructions!$C$8)","v":2666.6666666666665},{"$f":"(SUMIF(F7:F21,\"M14\",I7:I21))+($A$30/Instructions!$C$8)","v":2666.6666666666665},{"$f":"(SUMIF(F7:F21,\"M15\",I7:I21))+($A$30/Instructions!$C$8)","v":12666.666666666666},{"$f":"SUM(A29:O29)","v":70000},"Please delete data from this row for un-used milestones"]
[{"$f":"SUMIF(F7:F21,\"All\",I7:I21)","v":40000}]
[]
["Milestone summary - InEligible  Expense by Milestone"]
["Milestone 1","Milestone 2","Milestone 3","Milestone 4","Milestone 5","Milestone 6","Milestone 7","Milestone 8","Milestone 9","Milestone 10","Milestone 11","Milestone 12","Milestone 13","Milestone 14","Milestone 15","Total"]
[{"$f":"A35/$P$35","v":0.14166666666666672},1.6666666666666673E-2,0.14166666666666672,0.14166666666666672,0.14166666666666672,0.14166666666666672,0.14166666666666672,1.6666666666666673E-2,1.6666666666666673E-2,1.6666666666666673E-2,{"$f":"K35/$P$35","v":1.6666666666666673E-2},1.6666666666666673E-2,1.6666666666666673E-2,1.6666666666666673E-2,1.6666666666666673E-2,{"$f":"SUM(A34:O34)","v":1.0000000000000007}]
[{"$f":"(SUMIF(F7:F21,\"M1\",J7:J21))+($A$36/Instructions!$C$8)","v":11333.333333333334},{"$f":"(SUMIF(F7:F21,\"M2\",J7:J21))+($A$36/Instructions!$C$8)","v":1333.3333333333333},{"$f":"(SUMIF(F7:F21,\"M3\",J7:J21))+($A$36/Instructions!$C$8)","v":11333.333333333334},{"$f":"(SUMIF(F7:F21,\"M4\",J7:J21))+($A$36/Instructions!$C$8)","v":11333.333333333334},{"$f":"(SUMIF(F7:F21,\"M5\",J7:J21))+($A$36/Instructions!$C$8)","v":11333.333333333334},{"$f":"(SUMIF(F7:F21,\"M6\",J7:J21))+($A$36/Instructions!$C$8)","v":11333.333333333334},{"$f":"(SUMIF(F7:F21,\"M7\",J7:J21))+($A$36/Instructions!$C$8)","v":11333.333333333334},{"$f":"(SUMIF(F7:F21,\"M8\",J7:J21))+($A$36/Instructions!$C$8)","v":1333.3333333333333},{"$f":"(SUMIF(F7:F21,\"M9\",J7:J21))+($A$36/Instructions!$C$8)","v":1333.3333333333333},{"$f":"(SUMIF(F7:F21,\"M10\",J7:J21))+($A$36/Instructions!$C$8)","v":1333.3333333333333},{"$f":"(SUMIF(F7:F21,\"M11\",J7:J21))+($A$36/Instructions!$C$8)","v":1333.3333333333333},{"$f":"(SUMIF(F7:F21,\"M12\",J7:J21))+($A$36/Instructions!$C$8)","v":1333.3333333333333},{"$f":"(SUMIF(F7:F21,\"M13\",J7:J21))+($A$36/Instructions!$C$8)","v":1333.3333333333333},{"$f":"(SUMIF(F7:F21,\"M14\",J7:J21))+($A$36/Instructions!$C$8)","v":1333.3333333333333},{"$f":"(SUMIF(F7:F21,\"M15\",J7:J21))+($A$36/Instructions!$C$8)","v":1333.3333333333333},{"$f":"SUM(A35:O35)","v":79999.999999999971},"Please delete data from this row for un-used milestones"]
[{"$f":"SUMIF(F7:F21,\"All\",J7:J21)","v":20000}]

{"sheet":"Travel","index":10,"n_rows":35,"n_cols":23,"rows_kept":35,"cut":false,"hidden":false,"merged":[[24,0,24,9],[30,0,30,9]]}
["Project Travel Expense Forecast"]
["ERA PROJECT NUMBER",{"$f":"SOI","v":555555}]
["PROJECT LEAD",{"$f":"Instructions!C9","v":"Winterfell"}]
["PROJECT TITLE",{"$f":"Company_name","v":"Elsa's Winter Castle"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[]
["Applicant or Partner  (e.g. entity  funding the travel)\n(if applicable)","Employee Name","Description of Trip Expense","Location of Vendor/Service Provider","Project Expense: Eligible (E) or Ineligible (I)","Indicate which Milestone this expense occurs in","Cost in CAD","Eligible Travel Expenses","Ineligible Travel Expenses","Total Travel Expenses",null,null,"Eligible Economic spend Inside Alberta","Eligible Economic spend In Canada, but outside Alberta","Eligible Economic spend Outside of Canada"]
[null,null,null,null,"I","M2",90000,{"$f":"IF(E7=\"E\",G7,0)","v":0},{"$f":"IF(E7=\"I\",G7,0)","v":90000},{"$f":"G7","v":90000},null,null,{"$f":"IF(D7=\"In Alberta\",H7,0)","v":0},{"$f":"IF(D7=\"In Canada, but outside Alberta\",H7,0)","v":0},{"$f":"IF(D7=\"Outside of Canada\",H7,0)","v":0}]
[null,null,null,null,"E","M3",90000,{"$f":"IF(E8=\"E\",G8,0)","v":90000},{"$f":"IF(E8=\"I\",G8,0)","v":0},{"$f":"G8","v":90000},null,null,{"$f":"IF(D8=\"In Alberta\",H8,0)","v":0},{"$f":"IF(D8=\"In Canada, but outside Alberta\",H8,0)","v":0},{"$f":"IF(D8=\"Outside of Canada\",H8,0)","v":0}]
[null,null,null,null,"I","All",90000,0,90000,90000,null,null,0,0,0]
[null,null,null,null,"E","M5",90000,90000,0,90000,null,null,0,0,0]
[null,null,null,null,"E","M6",90000,90000,0,90000,null,null,0,0,0]
[null,null,null,null,"I","M7",90000,0,90000,90000,null,null,0,0,0]
[null,null,null,null,"E","M8",90000,90000,0,90000,null,null,0,0,0]
[null,null,null,null,"E","M9",90000,90000,0,90000,null,null,0,0,0]
[null,null,null,null,"E","M10",90000,90000,0,90000,null,null,0,0,0]
[null,null,null,null,"E","M11",90000,90000,0,90000,null,null,0,0,0]
[null,null,null,null,"I","M12",90000,0,90000,90000,null,null,0,0,0]
[null,null,null,null,"E","M13",90000,90000,0,90000,null,null,0,0,0]
[null,null,null,null,"E","M14",90000,90000,0,90000,null,null,0,0,0]
[null,null,null,null,"E","M15",90000,90000,0,90000,null,null,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G7:G20)","v":1260000},{"$f":"SUM(H7:H20)","v":900000},{"$f":"SUM(I7:I20)","v":360000},{"$f":"SUM(J7:J20)","v":1260000},null,null,{"$f":"SUM(M7:M20)","v":0},{"$f":"SUM(N7:N20)","v":0},{"$f":"SUM(O7:O20)","v":0}]
[]
[]
[]
["Milestone summary - Eligible Expense by Milestone"]
["Milestone 1","Milestone 2","Milestone 3","Milestone 4","Milestone 5","Milestone 6","Milestone 7","Milestone 8","Milestone 9","Milestone 10","Milestone 11","Milestone 12","Milestone 13","Milestone 14","Milestone 15","Total"]
[{"$f":"A28/$P$28","v":0},0,0.1,0,0.1,0.1,0,0.1,0.1,0.1,{"$f":"K28/$P$28","v":0.1},0,0.1,0.1,0.1,{"$f":"SUM(A27:O27)","v":0.99999999999999989}]
[{"$f":"(SUMIF(F7:F20,\"M1\",H7:H20))+(A29/Instructions!$C$8)","v":0},{"$f":"(SUMIF($F$7:$F$20,\"M2\",$H$7:$H$20))+($A$29/Instructions!$C$8)","v":0},{"$f":"(SUMIF($F$7:$F$20,\"M3\",$H$7:$H$20))+($A$29/Instructions!$C$8)","v":90000},{"$f":"(SUMIF($F$7:$F$20,\"M4\",$H$7:$H$20))+($A$29/Instructions!$C$8)","v":0},{"$f":"(SUMIF($F$7:$F$20,\"M5\",$H$7:$H$20))+($A$29/Instructions!$C$8)","v":90000},{"$f":"(SUMIF($F$7:$F$20,\"M6\",$H$7:$H$20))+($A$29/Instructions!$C$8)","v":90000},{"$f":"(SUMIF($F$7:$F$20,\"M7\",$H$7:$H$20))+($A$29/Instructions!$C$8)","v":0},{"$f":"(SUMIF($F$7:$F$20,\"M8\",$H$7:$H$20))+($A$29/Instructions!$C$8)","v":90000},{"$f":"(SUMIF($F$7:$F$20,\"M9\",$H$7:$H$20))+($A$29/Instructions!$C$8)","v":90000},{"$f":"(SUMIF($F$7:$F$20,\"M10\",$H$7:$H$20))+($A$29/Instructions!$C$8)","v":90000},{"$f":"(SUMIF($F$7:$F$20,\"M11\",$H$7:$H$20))+($A$29/Instructions!$C$8)","v":90000},{"$f":"(SUMIF($F$7:$F$20,\"M12\",$H$7:$H$20))+($A$29/Instructions!$C$8)","v":0},{"$f":"(SUMIF($F$7:$F$20,\"M13\",$H$7:$H$20))+($A$29/Instructions!$C$8)","v":90000},{"$f":"(SUMIF($F$7:$F$20,\"M14\",$H$7:$H$20))+($A$29/Instructions!$C$8)","v":90000},{"$f":"(SUMIF($F$7:$F$20,\"M15\",$H$7:$H$20))+($A$29/Instructions!$C$8)","v":90000},{"$f":"SUM(A28:O28)","v":900000},"Please delete data from this row for un-used milestones"]
[{"$f":"SUMIF($F$7:$F$20,\"All\",$H$7:$H$20)","v":0}]
[]
["Milestone summary - InEligible Expense by Milestone"]
["Milestone 1","Milestone 2","Milestone 3","Milestone 4","Milestone 5","Milestone 6","Milestone 7","Milestone 8","Milestone 9","Milestone 10","Milestone 11","Milestone 12","Milestone 13","Milestone 14","Milestone 15","Total"]
[{"$f":"A34/$P$34","v":1.6666666666666666E-2},0.26666666666666666,1.6666666666666666E-2,1.6666666666666666E-2,1.6666666666666666E-2,1.6666666666666666E-2,0.26666666666666666,1.6666666666666666E-2,1.6666666666666666E-2,1.6666666666666666E-2,{"$f":"K34/$P$34","v":1.6666666666666666E-2},0.26666666666666666,1.6666666666666666E-2,1.6666666666666666E-2,1.6666666666666666E-2,{"$f":"SUM(A33:O33)","v":1.0000000000000002}]
[{"$f":"(SUMIF(F7:F20,\"M1\",I7:I20))+($A$35/Instructions!$C$8)","v":6000},{"$f":"(SUMIF(F7:F20,\"M2\",I7:I20))+($A$35/Instructions!$C$8)","v":96000},{"$f":"(SUMIF(F7:F20,\"M3\",I7:I20))+($A$35/Instructions!$C$8)","v":6000},{"$f":"(SUMIF(F7:F20,\"M4\",I7:I20))+($A$35/Instructions!$C$8)","v":6000},{"$f":"(SUMIF(F7:F20,\"M5\",I7:I20))+($A$35/Instructions!$C$8)","v":6000},{"$f":"(SUMIF(F7:F20,\"M6\",I7:I20))+($A$35/Instructions!$C$8)","v":6000},{"$f":"(SUMIF(F7:F20,\"M7\",I7:I20))+($A$35/Instructions!$C$8)","v":96000},{"$f":"(SUMIF(F7:F20,\"M8\",I7:I20))+($A$35/Instructions!$C$8)","v":6000},{"$f":"(SUMIF(F7:F20,\"M9\",I7:I20))+($A$35/Instructions!$C$8)","v":6000},{"$f":"(SUMIF(F7:F20,\"M10\",I7:I20))+($A$35/Instructions!$C$8)","v":6000},{"$f":"(SUMIF(F7:F20,\"M11\",I7:I20))+($A$35/Instructions!$C$8)","v":6000},{"$f":"(SUMIF(F7:F20,\"M12\",I7:I20))+($A$35/Instructions!$C$8)","v":96000},{"$f":"(SUMIF(F7:F20,\"M13\",I7:I20))+($A$35/Instructions!$C$8)","v":6000},{"$f":"(SUMIF(F7:F20,\"M14\",I7:I20))+($A$35/Instructions!$C$8)","v":6000},{"$f":"(SUMIF(F7:F20,\"M15\",I7:I20))+($A$35/Instructions!$C$8)","v":6000},{"$f":"SUM(A34:O34)","v":360000},"Please delete data from this row for un-used milestones"]
[{"$f":"SUMIF($F$7:$F$20,\"All\",$I$7:$I$20)","v":90000}]

{"sheet":"Overhead","index":11,"n_rows":35,"n_cols":26,"rows_kept":35,"cut":false,"hidden":false,"merged":[[24,0,24,9],[30,0,30,9]]}
["Project Overhead Expense Forecast"]
["ERA PROJECT NUMBER",{"$f":"SOI","v":555555}]
["PROJECT LEAD",{"$f":"Instructions!C9","v":"Winterfell"}]
["PROJECT TITLE",{"$f":"Company_name","v":"Elsa's Winter Castle"}]
[]
["Project Partner (e.g. the entity funding overhead)\n(if applicable)","Description of Overhead Cost","Project Expense: Eligible (E) or Ineligible (I)","Location of Expense","Indicate which Milestone this expense occurs in","Cost\n($)","Eligible Overhead Amount ","Ineligible Overhead Amount ","Total Expenses",null,"Eligible Economic spend Inside Alberta","Eligible Economic spend In Canada, but outside Alberta","Eligible Economic spend Outside of Canada"]
[null,null,"I",null,"All",500000,{"$f":"IF(C7=\"E\",F7,0)","v":0},{"$f":"IF(C7=\"I\",F7,0)","v":500000},{"$f":"F7","v":500000},null,{"$f":"IF(D7=\"In Alberta\",G7,0)","v":0},{"$f":"IF(D7=\"In Canada, but outside Alberta\",G7,0)","v":0},{"$f":"IF(D7=\"Outside of Canada\",G7,0)","v":0}]
[null,null,"E",null,"All",500000,{"$f":"IF(C8=\"E\",F8,0)","v":500000},{"$f":"IF(C8=\"I\",F8,0)","v":0},{"$f":"F8","v":500000},null,{"$f":"IF(D8=\"In Alberta\",G8,0)","v":0},{"$f":"IF(D8=\"In Canada, but outside Alberta\",G8,0)","v":0},{"$f":"IF(D8=\"Outside of Canada\",G8,0)","v":0}]
[null,null,"E",null,"M4",500000,500000,0,500000,null,0,0,0]
[null,null,"I",null,"All",500000,0,500000,500000,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,"E",null,"All",500000,500000,0,500000,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,"E",null,"M7",500000,500000,0,500000,null,0,0,0]
[null,null,"E",null,"All",500000,500000,0,500000,null,0,0,0]
[null,null,"E",null,"All",500000,500000,0,500000,null,0,0,0]
[null,null,"E",null,"All",500000,500000,0,500000,null,0,0,0]
[null,null,"E",null,"All",500000,500000,0,500000,null,0,0,0]
[null,null,"E",null,"All",500000,500000,0,500000,null,0,0,0]
[null,null,"E",null,"All",500000,500000,0,500000,null,0,0,0]
[null,null,"E",null,"All",500000,500000,0,500000,null,0,0,0]
[null,null,"E",null,"All",500000,500000,0,500000,null,0,0,0]
[null,null,"E",null,"All",500000,500000,0,500000,null,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F7:F21)","v":7500000},{"$f":"SUM(G7:G21)","v":6500000},{"$f":"SUM(H7:H21)","v":1000000},{"$f":"SUM(I7:I21)","v":7500000},null,{"$f":"SUM(K7:K21)","v":0},{"$f":"SUM(L7:L21)","v":0},{"$f":"SUM(M7:M21)","v":0}]
[]
[]
["Milestone summary - Eligible  Expense by Milestone"]
["Milestone 1","Milestone 2","Milestone 3","Milestone 4","Milestone 5","Milestone 6","Milestone 7","Milestone 8","Milestone 9","Milestone 10","Milestone 11","Milestone 12","Milestone 13","Milestone 14","Milestone 15","Total"]
[{"$f":"A28/$P$28","v":5.6410256410256397E-2},5.6410256410256397E-2,5.6410256410256397E-2,0.1333333333333333,5.6410256410256397E-2,5.6410256410256397E-2,0.1333333333333333,5.6410256410256397E-2,5.6410256410256397E-2,5.6410256410256397E-2,{"$f":"K28/$P$28","v":5.6410256410256397E-2},5.6410256410256397E-2,5.6410256410256397E-2,5.6410256410256397E-2,5.6410256410256397E-2,{"$f":"SUM(A27:O27)","v":1}]
[{"$f":"(SUMIF(E7:E21,\"M1\",G7:G21))+($A$29/Instructions!$C$8)","v":366666.66666666669},{"$f":"(SUMIF(E7:E21,\"M2\",G7:G21))+($A$29/Instructions!$C$8)","v":366666.66666666669},{"$f":"(SUMIF(E7:E21,\"M3\",G7:G21))+($A$29/Instructions!$C$8)","v":366666.66666666669},{"$f":"(SUMIF(E7:E21,\"M4\",G7:G21))+($A$29/Instructions!$C$8)","v":866666.66666666674},{"$f":"(SUMIF(E7:E21,\"M5\",G7:G21))+($A$29/Instructions!$C$8)","v":366666.66666666669},{"$f":"(SUMIF(E7:E21,\"M6\",G7:G21))+($A$29/Instructions!$C$8)","v":366666.66666666669},{"$f":"(SUMIF(E7:E21,\"M7\",G7:G21))+($A$29/Instructions!$C$8)","v":866666.66666666674},{"$f":"(SUMIF(E7:E21,\"M8\",G7:G21))+($A$29/Instructions!$C$8)","v":366666.66666666669},{"$f":"(SUMIF(E7:E21,\"M9\",G7:G21))+($A$29/Instructions!$C$8)","v":366666.66666666669},{"$f":"(SUMIF(E7:E21,\"M10\",G7:G21))+($A$29/Instructions!$C$8)","v":366666.66666666669},{"$f":"(SUMIF(E7:E21,\"M11\",G7:G21))+($A$29/Instructions!$C$8)","v":366666.66666666669},{"$f":"(SUMIF(E7:E21,\"M12\",G7:G21))+($A$29/Instructions!$C$8)","v":366666.66666666669},{"$f":"(SUMIF(E7:E21,\"M13\",G7:G21))+($A$29/Instructions!$C$8)","v":366666.66666666669},{"$f":"(SUMIF(E7:E21,\"M14\",G7:G21))+($A$29/Instructions!$C$8)","v":366666.66666666669},{"$f":"(SUMIF(E7:E21,\"M15\",G7:G21))+($A$29/Instructions!$C$8)","v":366666.66666666669},{"$f":"SUM(A28:O28)","v":6500000.0000000019},"Please delete data from this row for un-used milestones"]
[{"$f":"SUMIF($E$7:$E$21,\"All\",$G$7:$G$21)","v":5500000}]
[]
["Milestone summary - InEligible Expense by Milestone"]
["Milestone 1","Milestone 2","Milestone 3","Milestone 4","Milestone 5","Milestone 6","Milestone 7","Milestone 8","Milestone 9","Milestone 10","Milestone 11","Milestone 12","Milestone 13","Milestone 14","Milestone 15","Total"]
[{"$f":"A34/$P$34","v":6.6666666666666693E-2},6.6666666666666693E-2,6.6666666666666693E-2,6.6666666666666693E-2,6.6666666666666693E-2,6.6666666666666693E-2,6.6666666666666693E-2,6.6666666666666693E-2,6.6666666666666693E-2,6.6666666666666693E-2,{"$f":"K34/$P$34","v":6.6666666666666693E-2},6.6666666666666693E-2,6.6666666666666693E-2,6.6666666666666693E-2,6.6666666666666693E-2,{"$f":"SUM(A33:O33)","v":1.0000000000000002}]
[{"$f":"(SUMIF(E7:E21,\"M1\",H7:H21))+($A$35/Instructions!$C$8)","v":66666.666666666672},{"$f":"(SUMIF(E7:E21,\"M2\",H7:H21))+($A$35/Instructions!$C$8)","v":66666.666666666672},{"$f":"(SUMIF(E7:E21,\"M3\",H7:H21))+($A$35/Instructions!$C$8)","v":66666.666666666672},{"$f":"(SUMIF(E7:E21,\"M4\",H7:H21))+($A$35/Instructions!$C$8)","v":66666.666666666672},{"$f":"(SUMIF(E7:E21,\"M5\",H7:H21))+($A$35/Instructions!$C$8)","v":66666.666666666672},{"$f":"(SUMIF(E7:E21,\"M6\",H7:H21))+($A$35/Instructions!$C$8)","v":66666.666666666672},{"$f":"(SUMIF(E7:E21,\"M7\",H7:H21))+($A$35/Instructions!$C$8)","v":66666.666666666672},{"$f":"(SUMIF(E7:E21,\"M8\",H7:H21))+($A$35/Instructions!$C$8)","v":66666.666666666672},{"$f":"(SUMIF(E7:E21,\"M9\",H7:H21))+($A$35/Instructions!$C$8)","v":66666.666666666672},{"$f":"(SUMIF(E7:E21,\"M10\",H7:H21))+($A$35/Instructions!$C$8)","v":66666.666666666672},{"$f":"(SUMIF(E7:E21,\"M11\",H7:H21))+($A$35/Instructions!$C$8)","v":66666.666666666672},{"$f":"(SUMIF(E7:E21,\"M12\",H7:H21))+($A$35/Instructions!$C$8)","v":66666.666666666672},{"$f":"(SUMIF(E7:E21,\"M13\",H7:H21))+($A$35/Instructions!$C$8)","v":66666.666666666672},{"$f":"(SUMIF(E7:E21,\"M14\",H7:H21))+($A$35/Instructions!$C$8)","v":66666.666666666672},{"$f":"(SUMIF(E7:E21,\"M15\",H7:H21))+($A$35/Instructions!$C$8)","v":66666.666666666672},{"$f":"SUM(A34:O34)","v":999999.99999999977},"Please delete data from this row for un-used milestones"]
[{"$f":"SUMIF($E$7:$E$21,\"All\",$H$7:$H$21)","v":1000000}]

{"sheet":"Milestone Summary","index":12,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[6,1,8,1],[7,2,7,3],[8,8,9,10],[6,7,8,7],[7,6,8,6],[7,5,8,5],[7,4,8,4]]}
[null,"Project Funding by Milestone"]
[null,"ERA PROJECT NUMBER",{"$f":"SOI","v":555555}]
[null,"PROJECT LEAD",{"$f":"Instructions!C9","v":"Winterfell"}]
[null,"PROJECT TITLE",{"$f":"Company_name","v":"Elsa's Winter Castle"}]
[]
[null,"Copy this into schedule A"]
[null,"Milestone ","A ","B ","C ","A+C ","A+B+C ","% ERA contribution to eligible"]
[null,null,"Proponent Contribution ($) ",null,"ERA Contribution ($) ","Total Eligible Project Costs ($) ","Total Project Cost ($) "]
[null,null,"Eligible","Ineligible",null,null,null,null,"Note: ERA's contribution for each milestone's total eligible costs should be evenly distributed and no more than 50%. "]
[null,"M1 ",379333,{"$f":"SUMMARY!L36","v":101333.33333333334},{"$f":"F10-C10","v":90000.333333333372},{"$f":"SUMMARY!L26","v":469333.33333333337},{"$f":"SUMMARY!L26+SUMMARY!L36","v":570666.66666666674},{"$f":"E10/F10","v":0.19176207386363642}]
[null,"M2 ",390338,{"$f":"SUMMARY!M36","v":181333.33333333334},93995.333333333372,{"$f":"SUMMARY!M26","v":484333.33333333337},{"$f":"SUMMARY!M26+SUMMARY!M36","v":665666.66666666674},{"$f":"E11/F11","v":0.19407157604955272}]
[null,"M3 ",570333,{"$f":"SUMMARY!N36","v":561333.33333333326},134000.33333333326,{"$f":"SUMMARY!N26","v":704333.33333333326},{"$f":"SUMMARY!N26+SUMMARY!N36","v":1265666.6666666665},0.19025130146710828]
[null,"M4 ",785333,{"$f":"SUMMARY!O36","v":301333.33333333337},189000.33333333337,{"$f":"SUMMARY!O26","v":974333.33333333337},{"$f":"SUMMARY!O26+SUMMARY!O36","v":1275666.6666666667},0.19397913102976397]
[null,"M5",918333,{"$f":"SUMMARY!P36","v":421333.33333333331},221000.33333333326,{"$f":"SUMMARY!P26","v":1139333.3333333333},{"$f":"SUMMARY!P26+SUMMARY!P36","v":1560666.6666666665},0.19397337624341715]
[null,"M6",403333,{"$f":"SUMMARY!Q36","v":161333.33333333331},96000.333333333372,{"$f":"SUMMARY!Q26","v":499333.33333333337},{"$f":"SUMMARY!Q26+SUMMARY!Q36","v":660666.66666666674},0.19225700934579446]
[null,"M7",737333,{"$f":"SUMMARY!R36","v":251333.33333333331},177000.33333333337,{"$f":"SUMMARY!R26","v":914333.33333333337},{"$f":"SUMMARY!R26+SUMMARY!R36","v":1165666.6666666667},0.19358403208166244]
[null,"M8",451333,{"$f":"SUMMARY!S36","v":96333.333333333343},108000.33333333337,{"$f":"SUMMARY!S26","v":559333.33333333337},{"$f":"SUMMARY!S26+SUMMARY!S36","v":655666.66666666674},0.19308760429082247]
[null,"M9",451333,{"$f":"SUMMARY!T36","v":96333.333333333343},108000.33333333337,{"$f":"SUMMARY!T26","v":559333.33333333337},{"$f":"SUMMARY!T26+SUMMARY!T36","v":655666.66666666674},0.19308760429082247]
[null,"M10",407333,{"$f":"SUMMARY!U36","v":91333.333333333343},97000.333333333372,{"$f":"SUMMARY!U26","v":504333.33333333337},{"$f":"SUMMARY!U26+SUMMARY!U36","v":595666.66666666674},0.19233377395902188]
[null,"M11",612333,{"$f":"SUMMARY!V36","v":296333.33333333337},147000.33333333337,{"$f":"SUMMARY!V26","v":759333.33333333337},{"$f":"SUMMARY!V26+SUMMARY!V36","v":1055666.6666666667},0.1935913081650571]
[null,"M12",712333,{"$f":"SUMMARY!W36","v":181333.33333333334},172000.33333333337,{"$f":"SUMMARY!W26","v":884333.33333333337},{"$f":"SUMMARY!W26+SUMMARY!W36","v":1065666.6666666667},0.19449717301168493]
[null,"M13",620333,{"$f":"SUMMARY!X36","v":291333.33333333337},149000.33333333337,{"$f":"SUMMARY!X26","v":769333.33333333337},{"$f":"SUMMARY!X26+SUMMARY!X36","v":1060666.6666666667},0.1936746100519931]
[null,"M14",451333,{"$f":"SUMMARY!Y36","v":96333.333333333343},108000.33333333337,{"$f":"SUMMARY!Y26","v":559333.33333333337},{"$f":"SUMMARY!Y26+SUMMARY!Y36","v":655666.66666666674},0.19308760429082247]
[null,"M15",459333,{"$f":"SUMMARY!Z36","v":96333.333333333343},110000.33333333337,{"$f":"SUMMARY!Z26","v":569333.33333333337},{"$f":"SUMMARY!Z26+SUMMARY!Z36","v":665666.66666666674},0.19320901639344268]
[null,"TOTAL",{"$f":"SUM(C10:C24)","v":8350000},{"$f":"SUM(D10:D24)","v":3225000.0000000009},{"$f":"SUM(E10:E24)","v":2000000.0000000009},{"$f":"SUM(F10:F24)","v":10350000},{"$f":"SUM(G10:G24)","v":13574999.999999998},0.19323671497584549,{"$f":"C25+E25-F25","v":0},"check  - must be zero"]
[null,null,null,"ERA max funding",{"$f":"'Project Funding '!G7","v":2000000}]
[null,null,null,"check - must be zero",{"$f":"E25-E26","v":0}]
[]
[]
[null,"Copy this into schedule A"]

{"sheet":"SUMMARY","index":13,"n_rows":85,"n_cols":27,"rows_kept":85,"cut":false,"hidden":false,"merged":[[27,10,27,16],[27,17,27,18],[27,1,27,7],[0,5,0,11],[17,17,17,18],[9,1,9,6],[17,1,17,6],[17,10,17,16],[9,10,9,14],[0,13,0,14],[3,3,3,5],[1,1,1,2]]}
[null,"Project Summary",null,null,null,"NOTE TO PREPARER: Do not modify this tab as these amounts are calculated automatically. ",null,null,null,null,null,null,null,"Version 1.0 March 2021"]
[null,"ERA PROJECT NUMBER",null,{"$f":"SOI","v":555555}]
[null,"Project Lead",null,{"$f":"Instructions!C9","v":"Winterfell"}]
[null,"Project Title",null,{"$f":"Company_name","v":"Elsa's Winter Castle"}]
[]
[null,"Total Project Budget (Ineligible + Eligible)",{"$f":"E26","v":13575000},null,"Total Eligible Project Expenses",{"$f":"C26","v":10350000}]
[null,"Total Project Funding",{"$f":"F15","v":13475000},null,"Total InEligible Project Expenses",{"$f":"D26","v":3225000}]
[null,"Difference",{"$f":"C7-C6","v":-100000},null,"Total Project Budget",{"$f":"F7+F6","v":13575000}]
[]
[null,"Summary of Funding Sources",null,null,null,null,null,null,null,null,"Summary of Job Creation"]
[null,null,"Inside Alberta","In Canada, but outside Alberta","Outside of Canada","Total","% of Total Project Funding","% of Total Eligible Expenses",null,null,null,"Jobs Created (FTE)","Location(s), if outside Alberta"]
[null,"Private Funding",{"$f":"SUMIF('Project Funding '!C7:C21,\"Private\",'Project Funding '!N7:N21)","v":5000000},{"$f":"SUMIF('Project Funding '!C7:C21,\"Private\",'Project Funding '!O7:O21)","v":4000000},{"$f":"SUMIF('Project Funding '!C7:C21,\"Private\",'Project Funding '!P7:P21)","v":0},{"$f":"SUM(C12:E12)","v":9000000},{"$f":"F12/$C$7","v":0.66790352504638217},{"$f":"F12/$F$6","v":0.86956521739130432},null,null,"In Alberta",{"$f":"Labour!B7","v":0}]
[null,"Other Government",{"$f":"SUMIF('Project Funding '!C8:C21,\"Government\",'Project Funding '!N8:N21)","v":0},{"$f":"SUMIF('Project Funding '!C8:C21,\"Government\",'Project Funding '!O8:O21)","v":2475000},{"$f":"SUMIF('Project Funding '!C8:C21,\"Government\",'Project Funding '!P8:P21)","v":0},{"$f":"SUM(C13:E13)","v":2475000},{"$f":"F13/$C$7","v":0.18367346938775511},{"$f":"F13/$F$6","v":0.2391304347826087},null,null,"In Canada, but outside Alberta",{"$f":"Labour!B8","v":0},{"$f":"Labour!C8","v":0}]
[null,"ERA",{"$f":"Instructions!C3","v":2000000},null,null,{"$f":"SUM(C14:E14)","v":2000000},0.14842300556586271,0.19323671497584541,null,null,"Outside Canada",{"$f":"Labour!B9","v":0},{"$f":"Labour!C9","v":0}]
[null,"Totals",{"$f":"SUM(C12:C14)","v":7000000},{"$f":"SUM(D12:D14)","v":6475000},{"$f":"SUM(E12:E14)","v":0},{"$f":"SUM(F12:F14)","v":13475000},null,null,null,null,"Totals",{"$f":"SUM(L12:L14)","v":0}]
[null,"% of Total Project Funding",{"$f":"C15/$F$15","v":0.51948051948051943},{"$f":"D15/$F$15","v":0.48051948051948051},{"$f":"E15/$F$15","v":0}]
[]
[null,"Sumary of Expenses Eligibility by Category",null,null,null,null,null,null,null,null,"Summary of Eligble Expenses by Milestone"]
[null,"Expense category","Eligible","Ineligible ","Totals","Category Eligible Expense as a % of total Eligible Expenses","Expense Category as a % of Total Project Budget",null,null,null,"Expense category","M1","M2","M3","M4","M5","M6","M7","M8","M9","M10","M11","M12","M13","M14","M15","TOTAL"]
[null,"Labour",{"$f":"Labour!K31","v":2240000},{"$f":"Labour!L31","v":1460000},{"$f":"D20+C20","v":3700000},{"$f":"C20/$F$6","v":0.21642512077294687},{"$f":"E20/$C$6","v":0.27255985267034993},null,null,null,"Labour",{"$f":"Labour!A36","v":40000},{"$f":"Labour!B36","v":40000},{"$f":"Labour!C36","v":240000},{"$f":"Labour!D36","v":40000},{"$f":"Labour!E36","v":680000},{"$f":"Labour!F36","v":40000},{"$f":"Labour!G36","v":40000},{"$f":"Labour!H36","v":40000},{"$f":"Labour!I36","v":40000},{"$f":"Labour!J36","v":40000},{"$f":"Labour!K36","v":240000},{"$f":"Labour!L36","v":440000},{"$f":"Labour!M36","v":240000},{"$f":"Labour!N36","v":40000},{"$f":"Labour!O36","v":40000},{"$f":"SUM(L20:Z20)","v":2240000}]
[null,"Equipment",{"$f":"Equip!H21","v":40000},{"$f":"Equip!I21","v":25000},65000,3.8647342995169081E-3,4.7882136279926331E-3,null,null,null,"Equipment",{"$f":"Equip!A28","v":0},{"$f":"Equip!B28","v":5000},{"$f":"Equip!C28","v":5000},{"$f":"Equip!D28","v":5000},{"$f":"Equip!E28","v":0},{"$f":"Equip!F28","v":0},{"$f":"Equip!G28","v":5000},{"$f":"Equip!H28","v":0},{"$f":"Equip!I28","v":0},{"$f":"Equip!J28","v":5000},{"$f":"Equip!K28","v":0},{"$f":"Equip!L28","v":5000},{"$f":"Equip!M28","v":10000},{"$f":"Equip!N28","v":0},{"$f":"Equip!O28","v":0},40000]
[null,"Materials & Supplies",{"$f":"'Materials-Supplies'!H22","v":600000},{"$f":"'Materials-Supplies'!I22","v":300000},{"$f":"D22+C22","v":900000},5.7971014492753624E-2,6.6298342541436461E-2,null,null,null,"Materials & Supplies",{"$f":"'Materials-Supplies'!A28","v":60000},{"$f":"'Materials-Supplies'!B28","v":60000},{"$f":"'Materials-Supplies'!C28","v":0},{"$f":"'Materials-Supplies'!D28","v":60000},{"$f":"'Materials-Supplies'!E28","v":0},{"$f":"'Materials-Supplies'!F28","v":0},{"$f":"'Materials-Supplies'!G28","v":0},{"$f":"'Materials-Supplies'!H28","v":60000},{"$f":"'Materials-Supplies'!I28","v":60000},{"$f":"'Materials-Supplies'!J28","v":0},{"$f":"'Materials-Supplies'!K28","v":60000},{"$f":"'Materials-Supplies'!L28","v":60000},{"$f":"'Materials-Supplies'!M28","v":60000},{"$f":"'Materials-Supplies'!N28","v":60000},{"$f":"'Materials-Supplies'!O28","v":60000},600000]
[null,"Consulting/subcontracting",{"$f":"'Consult-SubC'!I22","v":70000},{"$f":"'Consult-SubC'!J22","v":80000},150000,6.7632850241545897E-3,1.1049723756906077E-2,null," ",null,"Consulting/subcontracting",{"$f":"'Consult-SubC'!A29","v":2666.6666666666665},{"$f":"'Consult-SubC'!B29","v":12666.666666666666},{"$f":"'Consult-SubC'!C29","v":2666.6666666666665},{"$f":"'Consult-SubC'!D29","v":2666.6666666666665},{"$f":"'Consult-SubC'!E29","v":2666.6666666666665},{"$f":"'Consult-SubC'!F29","v":2666.6666666666665},{"$f":"'Consult-SubC'!G29","v":2666.6666666666665},{"$f":"'Consult-SubC'!H29","v":2666.6666666666665},{"$f":"'Consult-SubC'!I29","v":2666.6666666666665},{"$f":"'Consult-SubC'!J29","v":2666.6666666666665},{"$f":"'Consult-SubC'!K29","v":2666.6666666666665},{"$f":"'Consult-SubC'!L29","v":12666.666666666666},{"$f":"'Consult-SubC'!M29","v":2666.6666666666665},{"$f":"'Consult-SubC'!N29","v":2666.6666666666665},{"$f":"'Consult-SubC'!O29","v":12666.666666666666},{"$f":"SUM(L23:Z23)","v":70000}]
[null,"Travel",{"$f":"Travel!H21","v":900000},{"$f":"Travel!I21","v":360000},1260000,8.6956521739130432E-2,9.2817679558011054E-2,null,null,null,"Travel",{"$f":"Travel!A28","v":0},{"$f":"Travel!B28","v":0},{"$f":"Travel!C28","v":90000},{"$f":"Travel!D28","v":0},{"$f":"Travel!E28","v":90000},{"$f":"Travel!F28","v":90000},{"$f":"Travel!G28","v":0},{"$f":"Travel!H28","v":90000},{"$f":"Travel!I28","v":90000},{"$f":"Travel!J28","v":90000},{"$f":"Travel!K28","v":90000},{"$f":"Travel!L28","v":0},{"$f":"Travel!M28","v":90000},{"$f":"Travel!N28","v":90000},{"$f":"Travel!O28","v":90000},900000]
[null,"Overhead",{"$f":"Overhead!G22","v":6500000},{"$f":"Overhead!H22","v":1000000},7500000,0.6280193236714976,0.5524861878453039,null,null,null,"Overhead",{"$f":"Overhead!A28","v":366666.66666666669},{"$f":"Overhead!B28","v":366666.66666666669},{"$f":"Overhead!C28","v":366666.66666666669},{"$f":"Overhead!D28","v":866666.66666666674},{"$f":"Overhead!E28","v":366666.66666666669},{"$f":"Overhead!F28","v":366666.66666666669},{"$f":"Overhead!G28","v":866666.66666666674},{"$f":"Overhead!H28","v":366666.66666666669},{"$f":"Overhead!I28","v":366666.66666666669},{"$f":"Overhead!J28","v":366666.66666666669},{"$f":"Overhead!K28","v":366666.66666666669},{"$f":"Overhead!L28","v":366666.66666666669},{"$f":"Overhead!M28","v":366666.66666666669},{"$f":"Overhead!N28","v":366666.66666666669},{"$f":"Overhead!O28","v":366666.66666666669},6500000.0000000019]
[null,"Totals",{"$f":"SUM(C20:C25)","v":10350000},{"$f":"SUM(D20:D25)","v":3225000},{"$f":"SUM(E20:E25)","v":13575000},null,null,null,null,null,"Totals",{"$f":"SUM(L20:L25)","v":469333.33333333337},484333.33333333337,704333.33333333326,974333.33333333337,1139333.3333333333,499333.33333333337,914333.33333333337,559333.33333333337,559333.33333333337,504333.33333333337,759333.33333333337,884333.33333333337,769333.33333333337,559333.33333333337,569333.33333333337,10350000]
[]
[null,"Summary of Eligible Expenses by Geographical Area and Expense Category",null,null,null,null,null,null,null,null,"Summary of InEligble Expenses by Milestone"]
[null,"Expense Category","In Alberta","In Canada, but outside Alberta","Outside of Canada","Total Eligible Expenses By Category",null,null,null,null,"Expense category","M1","M2","M3","M4","M5","M6","M7","M8","M9","M10","M11","M12","M13","M14","M15","TOTAL"]
[null,"Labour",{"$f":"Labour!O31","v":900000},{"$f":"Labour!P31","v":1000000},{"$f":"Labour!Q31","v":200000},{"$f":"SUM(C30:E30)","v":2100000},null,null,null,null,"Labour",{"$f":"Labour!A42","v":13333.333333333334},{"$f":"Labour!B42","v":13333.333333333334},{"$f":"Labour!C42","v":413333.33333333331},{"$f":"Labour!D42","v":213333.33333333334},{"$f":"Labour!E42","v":273333.33333333331},{"$f":"Labour!F42","v":13333.333333333334},{"$f":"Labour!G42","v":13333.333333333334},{"$f":"Labour!H42","v":13333.333333333334},{"$f":"Labour!I42","v":13333.333333333334},{"$f":"Labour!J42","v":13333.333333333334},{"$f":"Labour!K42","v":213333.33333333334},{"$f":"Labour!L42","v":13333.333333333334},{"$f":"Labour!M42","v":213333.33333333334},{"$f":"Labour!N42","v":13333.333333333334},{"$f":"Labour!O42","v":13333.333333333334},{"$f":"SUM(L30:Z30)","v":1460000}]
[null,"Equipment",{"$f":"Equip!L21","v":5000},{"$f":"Equip!M21","v":0},{"$f":"Equip!N21","v":0},{"$f":"SUM(C31:E31)","v":5000},null,null,null,null,"Equipment",{"$f":"Equip!A34","v":0},{"$f":"Equip!B34","v":0},{"$f":"Equip!C34","v":0},{"$f":"Equip!D34","v":0},{"$f":"Equip!E34","v":0},{"$f":"Equip!F34","v":0},{"$f":"Equip!G34","v":0},{"$f":"Equip!H34","v":5000},{"$f":"Equip!I34","v":5000},{"$f":"Equip!J34","v":0},{"$f":"Equip!K34","v":5000},{"$f":"Equip!L34","v":0},{"$f":"Equip!M34","v":0},{"$f":"Equip!N34","v":5000},{"$f":"Equip!O34","v":5000},25000]
[null,"Materials & Supplies",{"$f":"'Materials-Supplies'!L22","v":0},{"$f":"'Materials-Supplies'!M22","v":0},{"$f":"'Materials-Supplies'!N22","v":0},{"$f":"SUM(C32:E32)","v":0},null,null,null,null,"Materials & Supplies",{"$f":"'Materials-Supplies'!A34","v":4000},{"$f":"'Materials-Supplies'!B34","v":4000},{"$f":"'Materials-Supplies'!C34","v":64000},{"$f":"'Materials-Supplies'!D34","v":4000},{"$f":"'Materials-Supplies'!E34","v":64000},{"$f":"'Materials-Supplies'!F34","v":64000},{"$f":"'Materials-Supplies'!G34","v":64000},{"$f":"'Materials-Supplies'!H34","v":4000},{"$f":"'Materials-Supplies'!I34","v":4000},{"$f":"'Materials-Supplies'!J34","v":4000},{"$f":"'Materials-Supplies'!K34","v":4000},{"$f":"'Materials-Supplies'!L34","v":4000},{"$f":"'Materials-Supplies'!M34","v":4000},{"$f":"'Materials-Supplies'!N34","v":4000},{"$f":"'Materials-Supplies'!O34","v":4000},300000]
[null,"Consulting/subcontracting",{"$f":"'Consult-SubC'!M22","v":0},{"$f":"'Consult-SubC'!N22","v":0},{"$f":"'Consult-SubC'!O22","v":0},{"$f":"SUM(C33:E33)","v":0},null,null,null,null,"Consulting/subcontracting",{"$f":"'Consult-SubC'!A35","v":11333.333333333334},{"$f":"'Consult-SubC'!B35","v":1333.3333333333333},{"$f":"'Consult-SubC'!C35","v":11333.333333333334},{"$f":"'Consult-SubC'!D35","v":11333.333333333334},{"$f":"'Consult-SubC'!E35","v":11333.333333333334},{"$f":"'Consult-SubC'!F35","v":11333.333333333334},{"$f":"'Consult-SubC'!G35","v":11333.333333333334},{"$f":"'Consult-SubC'!H35","v":1333.3333333333333},{"$f":"'Consult-SubC'!I35","v":1333.3333333333333},{"$f":"'Consult-SubC'!J35","v":1333.3333333333333},{"$f":"'Consult-SubC'!K35","v":1333.3333333333333},{"$f":"'Consult-SubC'!L35","v":1333.3333333333333},{"$f":"'Consult-SubC'!M35","v":1333.3333333333333},{"$f":"'Consult-SubC'!N35","v":1333.3333333333333},{"$f":"'Consult-SubC'!O35","v":1333.3333333333333},79999.999999999971]
[null,"Travel",{"$f":"Travel!M21","v":0},{"$f":"Travel!N21","v":0},{"$f":"Travel!O21","v":0},{"$f":"SUM(C34:E34)","v":0},null,null,null,null,"Travel",{"$f":"Travel!A34","v":6000},{"$f":"Travel!B34","v":96000},{"$f":"Travel!C34","v":6000},{"$f":"Travel!D34","v":6000},{"$f":"Travel!E34","v":6000},{"$f":"Travel!F34","v":6000},{"$f":"Travel!G34","v":96000},{"$f":"Travel!H34","v":6000},{"$f":"Travel!I34","v":6000},{"$f":"Travel!J34","v":6000},{"$f":"Travel!K34","v":6000},{"$f":"Travel!L34","v":96000},{"$f":"Travel!M34","v":6000},{"$f":"Travel!N34","v":6000},{"$f":"Travel!O34","v":6000},360000]
[null,"Overhead",{"$f":"Overhead!K22","v":0},{"$f":"Overhead!L22","v":0},{"$f":"Overhead!M22","v":0},{"$f":"SUM(C35:E35)","v":0},null,null,null,null,"Overhead",{"$f":"Overhead!A34","v":66666.666666666672},{"$f":"Overhead!B34","v":66666.666666666672},{"$f":"Overhead!C34","v":66666.666666666672},{"$f":"Overhead!D34","v":66666.666666666672},{"$f":"Overhead!E34","v":66666.666666666672},{"$f":"Overhead!F34","v":66666.666666666672},{"$f":"Overhead!G34","v":66666.666666666672},{"$f":"Overhead!H34","v":66666.666666666672},{"$f":"Overhead!I34","v":66666.666666666672},{"$f":"Overhead!J34","v":66666.666666666672},{"$f":"Overhead!K34","v":66666.666666666672},{"$f":"Overhead!L34","v":66666.666666666672},{"$f":"Overhead!M34","v":66666.666666666672},{"$f":"Overhead!N34","v":66666.666666666672},{"$f":"Overhead!O34","v":66666.666666666672},999999.99999999977]
[null,"Total Eligible Expenses by Geographic Area",{"$f":"SUM(C30:C35)","v":905000},{"$f":"SUM(D30:D35)","v":1000000},{"$f":"SUM(E30:E35)","v":200000},{"$f":"SUM(F30:F35)","v":2105000},null,null,null,null,"Totals",{"$f":"SUM(L30:L35)","v":101333.33333333334},{"$f":"SUM(M30:M35)","v":181333.33333333334},{"$f":"SUM(N30:N35)","v":561333.33333333326},301333.33333333337,421333.33333333331,161333.33333333331,251333.33333333331,96333.333333333343,96333.333333333343,91333.333333333343,296333.33333333337,181333.33333333334,291333.33333333337,96333.333333333343,96333.333333333343,3225000.0000000009]
[]
[null,"ERIMS INPUT (Eligible + Ineligible expenses)",null,"FOR ERA ADMIN PURPOSES ONLY - PLEASE DO NOT EDIT"]
[null,{"$f":"D2","v":555555}]
[null,{"$f":"D3","v":"Winterfell"}]
[null,null,null,"Labour","Equipment","Materials","Sub-Con","Travel","Admin","TOTAL","CHECK"]
[null,"M1","Proponent",{"$f":"($L20*(1-'Milestone Summary'!H10))+L30","v":45662.85037878788},{"$f":"(L21*(1-'Milestone Summary'!H10))+L31","v":0},{"$f":"(L22*(1-'Milestone Summary'!H10))+SUMMARY!L32","v":52494.275568181816},{"$f":"(L23*(1-'Milestone Summary'!H10)+SUMMARY!L33)","v":13488.63446969697},{"$f":"(L24*(1-'Milestone Summary'!H10)+SUMMARY!L34)","v":6000},{"$f":"L25*(1-'Milestone Summary'!H10)+SUMMARY!L35","v":363020.57291666669},{"$f":"SUM(D42:I42)","v":480666.33333333337},{"$f":"(J42+J43)-(L36+L26)","v":0}]
[null,null,"ERA",{"$f":"L20*'Milestone Summary'!H10","v":7670.4829545454568},{"$f":"L21*'Milestone Summary'!H10","v":0},{"$f":"L22*'Milestone Summary'!H10","v":11505.724431818186},{"$f":"L23*'Milestone Summary'!H10","v":511.36553030303043},{"$f":"L24*'Milestone Summary'!H10","v":0},{"$f":"L25*'Milestone Summary'!H10","v":70312.760416666686},{"$f":"SUM(D43:I43)","v":90000.333333333358}]
[]
[null,"M2","Proponent",{"$f":"(M20*(1-'Milestone Summary'!H11)+SUMMARY!M30)","v":45570.470291351223},{"$f":"(M21*(1-'Milestone Summary'!H11)+SUMMARY!M31)","v":4029.6421197522363},{"$f":"(M22*(1-'Milestone Summary'!H11)+SUMMARY!M32)","v":52355.705437026838},{"$f":"(M23*(1-'Milestone Summary'!H11)+SUMMARY!M33)","v":11541.760036705666},{"$f":"(M24*(1-'Milestone Summary'!H11)+SUMMARY!M34)","v":96000},{"$f":"(M25*(1-'Milestone Summary'!H11)+SUMMARY!M35)","v":362173.75544849737},{"$f":"SUM(D45:I45)","v":571671.33333333337},{"$f":"(J45+J46)-(M26+M36)","v":0}]
[null,null,"ERA",{"$f":"M20*'Milestone Summary'!H11","v":7762.8630419821084},{"$f":"M21*'Milestone Summary'!H11","v":970.35788024776355},{"$f":"M22*'Milestone Summary'!H11","v":11644.294562973164},{"$f":"M23*'Milestone Summary'!H11","v":2458.2399632943343},{"$f":"M24*'Milestone Summary'!H11","v":0},{"$f":"M25*'Milestone Summary'!H11","v":71159.577884836006},{"$f":"SUM(D46:I46)","v":93995.333333333372}]
[]
[null,"M3","Proponent",{"$f":"(N20*(1-'Milestone Summary'!H12)+SUMMARY!N30)","v":607673.02098122728},{"$f":"(N21*(1-'Milestone Summary'!H12)+SUMMARY!N31)","v":4048.7434926644582},{"$f":"(N22*(1-'Milestone Summary'!H12)+SUMMARY!N32)","v":64000},{"$f":"(N23*(1-'Milestone Summary'!H12)+SUMMARY!N33)","v":13492.663196087711},{"$f":"(N24*(1-'Milestone Summary'!H12)+SUMMARY!N34)","v":78877.382867960245},{"$f":"(N25*(1-'Milestone Summary'!H12)+SUMMARY!N35)","v":363574.52279539366},{"$f":"SUM(D48:I48)","v":1131666.3333333333},{"$f":"(J48+J49)-(N26+N36)","v":0}]
[null,null,"ERA",{"$f":"N20*'Milestone Summary'!H12","v":45660.31235210599},{"$f":"N21*'Milestone Summary'!H12","v":951.25650733554141},{"$f":"N22*'Milestone Summary'!H12","v":0},{"$f":"N23*'Milestone Summary'!H12","v":507.3368039122887},{"$f":"N24*'Milestone Summary'!H12","v":17122.617132039744},{"$f":"N25*'Milestone Summary'!H12","v":69758.810537939702},{"$f":"SUM(D49:I49)","v":134000.33333333326}]
[]
[null,"M4","Proponent",{"$f":"(O20*(1-'Milestone Summary'!H13)+SUMMARY!O30)","v":245574.16809214279},{"$f":"(O21*(1-'Milestone Summary'!H13)+SUMMARY!O31)","v":4030.1043448511805},{"$f":"(O22*(1-'Milestone Summary'!H13)+SUMMARY!O32)","v":52361.252138214164},{"$f":"(O23*(1-'Milestone Summary'!H13)+SUMMARY!O33)","v":13482.722317253963},{"$f":"(O24*(1-'Milestone Summary'!H13)+SUMMARY!O34)","v":6000},{"$f":"(O25*(1-'Milestone Summary'!H13)+SUMMARY!O35)","v":765218.08644087124},{"$f":"SUM(D51:I51)","v":1086666.3333333333},{"$f":"(J51+J52)-(O26+O36)","v":0}]
[null,null,"ERA",{"$f":"O20*'Milestone Summary'!H13","v":7759.1652411905588},{"$f":"O21*'Milestone Summary'!H13","v":969.89565514881986},{"$f":"O22*'Milestone Summary'!H13","v":11638.747861785838},{"$f":"O23*'Milestone Summary'!H13","v":517.27768274603727},{"$f":"O24*'Milestone Summary'!H13","v":0},{"$f":"O25*'Milestone Summary'!H13","v":168115.24689246214},{"$f":"SUM(D52:I52)","v":189000.3333333334}]
[]
[null,"M5","Proponent",{"$f":"(P20*(1-'Milestone Summary'!H14)+SUMMARY!P30)","v":821431.43748780969},{"$f":"(P21*(1-'Milestone Summary'!H14)+SUMMARY!P31)","v":0},{"$f":"(P22*(1-'Milestone Summary'!H14)+(SUMMARY!P32))","v":64000},{"$f":"(P23*(1-'Milestone Summary'!H14)+SUMMARY!P33)","v":13482.737663350888},{"$f":"(P24*(1-'Milestone Summary'!H14)+SUMMARY!P34)","v":78542.396138092459},{"$f":"(P25*(1-'Milestone Summary'!H14)+SUMMARY!P35)","v":362209.76204408042},{"$f":"SUM(D54:I54)","v":1339666.3333333335},{"$f":"(J54+J55)-(P26+P36)","v":0}]
[null,null,"ERA",{"$f":"P20*'Milestone Summary'!H14","v":131901.89584552366},{"$f":"P21*'Milestone Summary'!H14","v":0},{"$f":"P22*'Milestone Summary'!H14","v":0},{"$f":"P23*'Milestone Summary'!H14","v":517.2623366491124},{"$f":"P24*'Milestone Summary'!H14","v":17457.603861907544},{"$f":"P25*'Milestone Summary'!H14","v":71123.571289252955},{"$f":"SUM(D55:I55)","v":221000.33333333328}]
[]
[null,"M6","Proponent",{"$f":"(Q20*(1-'Milestone Summary'!H15)+SUMMARY!Q30)","v":45643.052959501554},{"$f":"(Q21*(1-'Milestone Summary'!H15)+SUMMARY!Q31)","v":0},{"$f":"(Q22*(1-'Milestone Summary'!H15)+SUMMARY!Q32)","v":64000},{"$f":"(Q23*(1-'Milestone Summary'!H15)+SUMMARY!Q33)","v":13487.31464174455},{"$f":"(Q24*(1-'Milestone Summary'!H15)+SUMMARY!Q34)","v":78696.8691588785},{"$f":"(Q25*(1-'Milestone Summary'!H15)+SUMMARY!Q35)","v":362839.09657320875},{"$f":"SUM(D57:I57)","v":564666.33333333337},{"$f":"(J57+J58)-(Q26+Q36)","v":0}]
[null,null,"ERA",{"$f":"Q20*'Milestone Summary'!H15","v":7690.280373831778},{"$f":"Q21*'Milestone Summary'!H15","v":0},{"$f":"Q22*'Milestone Summary'!H15","v":0},{"$f":"Q23*'Milestone Summary'!H15","v":512.68535825545189},{"$f":"Q24*'Milestone Summary'!H15","v":17303.1308411215},{"$f":"Q25*'Milestone Summary'!H15","v":70494.236760124637},{"$f":"SUM(D58:I58)","v":96000.333333333372}]
[]
[null,"M7","Proponent",{"$f":"(R20*(1-'Milestone Summary'!H16)+SUMMARY!R30)","v":45589.972050066841},{"$f":"(R21*(1-'Milestone Summary'!H16)+SUMMARY!R31)","v":4032.0798395916881},{"$f":"(R22*(1-'Milestone Summary'!H16)+SUMMARY!R32)","v":64000},{"$f":"(R23*(1-'Milestone Summary'!H16)+SUMMARY!R33)","v":13483.775914448901},{"$f":"(R24*(1-'Milestone Summary'!H16)+SUMMARY!R34)","v":96000},{"$f":"(R25*(1-'Milestone Summary'!H16)+SUMMARY!R35)","v":765560.50552922592},{"$f":"SUM(D60:I60)","v":988666.33333333337},{"$f":"(J60+J61)-(R26+R36)","v":0}]
[null,null,"ERA",{"$f":"R20*'Milestone Summary'!H16","v":7743.3612832664976},{"$f":"R21*'Milestone Summary'!H16","v":967.9201604083122},{"$f":"R22*'Milestone Summary'!H16","v":0},{"$f":"R23*'Milestone Summary'!H16","v":516.22408555109985},{"$f":"R24*'Milestone Summary'!H16","v":0},{"$f":"R25*'Milestone Summary'!H16","v":167772.82780410745},{"$f":"SUM(D61:I61)","v":177000.33333333337}]
[]
[null,"M8","Proponent",{"$f":"(S20*(1-'Milestone Summary'!H17)+SUMMARY!S30)","v":45609.829161700436},{"$f":"(S21*(1-'Milestone Summary'!H17)+SUMMARY!S31)","v":5000},{"$f":"(S22*(1-'Milestone Summary'!H17)+SUMMARY!S32)","v":52414.74374255065},{"$f":"(S23*(1-'Milestone Summary'!H17)+SUMMARY!S33)","v":3485.0997218911398},{"$f":"(S24*(1-'Milestone Summary'!H17)+SUMMARY!S34)","v":78622.115613825968},{"$f":"(S25*(1-'Milestone Summary'!H17)+SUMMARY!S35)","v":362534.54509336513},{"$f":"SUM(D63:I63)","v":547666.33333333326},{"$f":"(J63+J64)-(S26+S36)","v":0}]
[null,null,"ERA",{"$f":"S20*'Milestone Summary'!H17","v":7723.5041716328988},{"$f":"S21*'Milestone Summary'!H17","v":0},{"$f":"S22*'Milestone Summary'!H17","v":11585.256257449348},{"$f":"S23*'Milestone Summary'!H17","v":514.90027810885988},{"$f":"S24*'Milestone Summary'!H17","v":17377.884386174024},{"$f":"S25*'Milestone Summary'!H17","v":70798.788239968242},{"$f":"SUM(D64:I64)","v":108000.33333333337}]
[]
[null,"M9","Proponent",{"$f":"(T20*(1-'Milestone Summary'!H18)+SUMMARY!T30)","v":45609.829161700436},{"$f":"(T21*(1-'Milestone Summary'!H18)+SUMMARY!T31)","v":5000},{"$f":"(T22*(1-'Milestone Summary'!H18)+SUMMARY!T32)","v":52414.74374255065},{"$f":"(T23*(1-'Milestone Summary'!H18)+SUMMARY!T33)","v":3485.0997218911398},{"$f":"(T24*(1-'Milestone Summary'!H18)+SUMMARY!T34)","v":78622.115613825968},{"$f":"(T25*(1-'Milestone Summary'!H18)+SUMMARY!T35)","v":362534.54509336513},{"$f":"SUM(D66:I66)","v":547666.33333333326},{"$f":"(J66+J67)-(T26+T36)","v":0}]
[null,null,"ERA",{"$f":"T20*'Milestone Summary'!H18","v":7723.5041716328988},{"$f":"T21*'Milestone Summary'!H18","v":0},{"$f":"T22*'Milestone Summary'!H18","v":11585.256257449348},{"$f":"T23*'Milestone Summary'!H18","v":514.90027810885988},{"$f":"T24*'Milestone Summary'!H18","v":17377.884386174024},{"$f":"T25*'Milestone Summary'!H18","v":70798.788239968242},{"$f":"SUM(D67:I67)","v":108000.33333333337}]
[]
[null,"M10","Proponent",{"$f":"(U20*(1-'Milestone Summary'!H19)+SUMMARY!U30)","v":45639.98237497246},{"$f":"(U21*(1-'Milestone Summary'!H19)+SUMMARY!U31)","v":4038.3311302048905},{"$f":"(U22*(1-'Milestone Summary'!H19)+SUMMARY!U32)","v":4000},{"$f":"(U23*(1-'Milestone Summary'!H19)+SUMMARY!U33)","v":3487.1099361092747},{"$f":"(U24*(1-'Milestone Summary'!H19)+SUMMARY!U34)","v":78689.960343688028},{"$f":"(U25*(1-'Milestone Summary'!H19)+SUMMARY!U35)","v":362810.94954835868},{"$f":"SUM(D69:I69)","v":498666.33333333331},{"$f":"(J69+J70)-(U26+U36)","v":0}]
[null,null,"ERA",{"$f":"U20*'Milestone Summary'!H19","v":7693.3509583608748},{"$f":"U21*'Milestone Summary'!H19","v":961.66886979510934},{"$f":"U22*'Milestone Summary'!H19","v":0},{"$f":"U23*'Milestone Summary'!H19","v":512.89006389072495},{"$f":"(U24*'Milestone Summary'!H19)","v":17310.039656311968},{"$f":"U25*'Milestone Summary'!H19","v":70522.383784974692},{"$f":"SUM(D70:I70)","v":97000.333333333372}]
[]
[null,"M11","Proponent",{"$f":"(V20*(1-'Milestone Summary'!H20)+SUMMARY!V30)","v":406871.4193737196},{"$f":"(V21*(1-'Milestone Summary'!H20)+SUMMARY!V31)","v":5000},{"$f":"(V22*(1-'Milestone Summary'!H20)+SUMMARY!V32)","v":52384.521510096572},{"$f":"(V23*(1-'Milestone Summary'!H20)+SUMMARY!V33)","v":3483.7565115598472},{"$f":"(V24*(1-'Milestone Summary'!H20)+SUMMARY!V34)","v":78576.782265144866},{"$f":"(V25*(1-'Milestone Summary'!H20)+SUMMARY!V35)","v":362349.85367281246},{"$f":"SUM(D72:I72)","v":908666.33333333326},{"$f":"(J72+J73)-(V26+V36)","v":0}]
[null,null,"ERA",{"$f":"V20*'Milestone Summary'!H20","v":46461.913959613703},{"$f":"V21*'Milestone Summary'!H20","v":0},{"$f":"V22*'Milestone Summary'!H20","v":11615.478489903426},{"$f":"V23*'Milestone Summary'!H20","v":516.24348844015219},{"$f":"V24*'Milestone Summary'!H20","v":17423.217734855138},{"$f":"V25*'Milestone Summary'!H20","v":70983.479660520941},{"$f":"SUM(D73:I73)","v":147000.33333333337}]
[]
[null,"M12","Proponent",{"$f":"(W20*(1-'Milestone Summary'!H21)+SUMMARY!W30)","v":367754.57720819197},{"$f":"(W21*(1-'Milestone Summary'!H21)+SUMMARY!W31)","v":4027.5141349415753},{"$f":"(W22*(1-'Milestone Summary'!H21)+SUMMARY!W32)","v":52330.169619298904},{"$f":"(W23*(1-'Milestone Summary'!H21)+SUMMARY!W33)","v":11536.369141851992},{"$f":"(W24*(1-'Milestone Summary'!H21)+SUMMARY!W34)","v":96000},{"$f":"(W25*(1-'Milestone Summary'!H21)+SUMMARY!W35)","v":362017.70322904893},{"$f":"SUM(D75:I75)","v":893666.33333333349},{"$f":"(J75+J76)-(W26+W36)","v":0}]
[null,null,"ERA",{"$f":"W20*'Milestone Summary'!H21","v":85578.756125141372},{"$f":"W21*'Milestone Summary'!H21","v":972.48586505842468},{"$f":"W22*'Milestone Summary'!H21","v":11669.830380701096},{"$f":"W23*'Milestone Summary'!H21","v":2463.6308581480089},{"$f":"W24*'Milestone Summary'!H21","v":0},{"$f":"W25*'Milestone Summary'!H21","v":71315.630104284472},{"$f":"SUM(D76:I76)","v":172000.33333333337}]
[]
[null,"M13","Proponent",{"$f":"(X20*(1-'Milestone Summary'!H22)+SUMMARY!X30)","v":406851.42692085501},{"$f":"(X21*(1-'Milestone Summary'!H22)+SUMMARY!X31)","v":8063.2538994800698},{"$f":"(X22*(1-'Milestone Summary'!H22)+SUMMARY!X32)","v":52379.523396880417},{"$f":"(X23*(1-'Milestone Summary'!H22)+SUMMARY!X33)","v":3483.534373194685},{"$f":"(X24*(1-'Milestone Summary'!H22)+SUMMARY!X34)","v":78569.285095320622},{"$f":"(X25*(1-'Milestone Summary'!H22)+SUMMARY!X35)","v":362319.30964760261},{"$f":"SUM(D78:I78)","v":911666.33333333337},{"$f":"(J78+J79)-(X26+X36)","v":0}]
[null,null,"ERA",{"$f":"X20*'Milestone Summary'!H22","v":46481.906412478347},{"$f":"X21*'Milestone Summary'!H22","v":1936.7461005199309},{"$f":"X22*'Milestone Summary'!H22","v":11620.476603119587},{"$f":"X23*'Milestone Summary'!H22","v":516.46562680531486},{"$f":"X24*'Milestone Summary'!H22","v":17430.714904679378},{"$f":"X25*'Milestone Summary'!H22","v":71014.023685730805},{"$f":"SUM(D79:I79)","v":149000.33333333337}]
[]
[null,"M14","Proponent",{"$f":"(Y20*(1-'Milestone Summary'!H23)+SUMMARY!Y30)","v":45609.829161700436},{"$f":"(Y21*(1-'Milestone Summary'!H23)+SUMMARY!Y31)","v":5000},{"$f":"(Y22*(1-'Milestone Summary'!H23)+SUMMARY!Y32)","v":52414.74374255065},{"$f":"(Y23*(1-'Milestone Summary'!H23)+SUMMARY!Y33)","v":3485.0997218911398},{"$f":"(Y24*(1-'Milestone Summary'!H23)+SUMMARY!Y34)","v":78622.115613825968},{"$f":"(Y25*(1-'Milestone Summary'!H23)+SUMMARY!Y35)","v":362534.54509336513},{"$f":"SUM(D81:I81)","v":547666.33333333326},{"$f":"(J81+J82)-(Y26+Y36)","v":0}]
[null,null,"ERA",{"$f":"Y20*'Milestone Summary'!H23","v":7723.5041716328988},{"$f":"Y21*'Milestone Summary'!H23","v":0},{"$f":"Y22*'Milestone Summary'!H23","v":11585.256257449348},{"$f":"Y23*'Milestone Summary'!H23","v":514.90027810885988},{"$f":"Y24*'Milestone Summary'!H23","v":17377.884386174024},{"$f":"Y25*'Milestone Summary'!H23","v":70798.788239968242},{"$f":"SUM(D82:I82)","v":108000.33333333337}]
[]
[null,"M15","Proponent",{"$f":"(Z20*(1-'Milestone Summary'!H24)+SUMMARY!Z30)","v":45604.97267759563},{"$f":"(Z21*(1-'Milestone Summary'!H24)+SUMMARY!Z31)","v":5000},{"$f":"(Z22*(1-'Milestone Summary'!H24)+SUMMARY!Z32)","v":52407.459016393441},{"$f":"(Z23*(1-'Milestone Summary'!H24)+SUMMARY!Z33)","v":11552.685792349726},{"$f":"(Z24*(1-'Milestone Summary'!H24)+SUMMARY!Z34)","v":78611.188524590165},{"$f":"(Z25*(1-'Milestone Summary'!H24)+SUMMARY!Z35)","v":362490.02732240438},{"$f":"SUM(D84:I84)","v":555666.33333333337},{"$f":"(J84+J85)-(Z26+Z36)","v":0}]
[null,null,"ERA",{"$f":"Z20*'Milestone Summary'!H24","v":7728.360655737707},{"$f":"Z21*'Milestone Summary'!H24","v":0},{"$f":"Z22*'Milestone Summary'!H24","v":11592.540983606561},{"$f":"Z23*'Milestone Summary'!H24","v":2447.3142076502736},{"$f":"Z24*'Milestone Summary'!H24","v":17388.811475409842},{"$f":"Z25*'Milestone Summary'!H24","v":70843.30601092898},{"$f":"SUM(D85:I85)","v":110000.33333333337}]