{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Budget vs Actual by Category","Actual Project Expenses List"],"not_rendered":{"images":2,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Budget vs Actual by Category","index":0,"n_rows":27,"n_cols":3,"rows_kept":27,"merged":[[0,0,1,2],[24,0,24,2],[26,1,1048575,2]]}
["Budget vs Actual by Category"]
[]
[]
["Project #:"]
[]
["Expense Item\n(as per signed contract)","Budget\n(as per signed contract)","Actual"]
{"$rows_empty":16}
["Totals:",{"$f":"SUBTOTAL(109,Table13[Budget\n(as per signed contract)])","v":0},{"$f":"SUBTOTAL(109,Table13[Actual])","v":0}]
[]
["The Actual Total above must equal the Reported Actual Eligible Spend on the second tab."]
[null,"Difference (if any):",{"$f":"Table13[[#Totals],[Actual]]-'Actual Project Expenses List'!E29","v":0}]
[null,"Published May 12, 2021 - Ver. 1.6"]

{"sheet":"Actual Project Expenses List","index":1,"n_rows":30,"n_cols":8,"rows_kept":30,"merged":[[0,0,1,7],[3,1,3,3],[4,1,4,3],[29,5,29,7]]}
["Actual Project Expenses List"]
[]
["Project #:"]
["Project Name:"]
["Proponent:"]
[]
["Date","Invoice #","Vendor","Description","Pre-Tax","GST","PST","Total\nInvoice"]
[{"$nulls":7},{"$f":"SUM(Table1[[#This Row],[Pre-Tax]:[PST]])","v":0}]
[{"$nulls":7},{"$f":"SUM(Table1[[#This Row],[Pre-Tax]:[PST]])","v":0}]
[{"$nulls":7},{"$f":"SUM(Table1[[#This Row],[Pre-Tax]:[PST]])","v":0}]
[{"$nulls":7},{"$f":"SUM(Table1[[#This Row],[Pre-Tax]:[PST]])","v":0}]
[{"$nulls":7},{"$f":"SUM(Table1[[#This Row],[Pre-Tax]:[PST]])","v":0}]
[{"$nulls":7},{"$f":"SUM(Table1[[#This Row],[Pre-Tax]:[PST]])","v":0}]
[{"$nulls":7},{"$f":"SUM(Table1[[#This Row],[Pre-Tax]:[PST]])","v":0}]
[{"$nulls":7},{"$f":"SUM(Table1[[#This Row],[Pre-Tax]:[PST]])","v":0}]
[{"$nulls":7},{"$f":"SUM(Table1[[#This Row],[Pre-Tax]:[PST]])","v":0}]
[{"$nulls":7},{"$f":"SUM(Table1[[#This Row],[Pre-Tax]:[PST]])","v":0}]
[{"$nulls":7},{"$f":"SUM(Table1[[#This Row],[Pre-Tax]:[PST]])","v":0}]
[{"$nulls":7},{"$f":"SUM(Table1[[#This Row],[Pre-Tax]:[PST]])","v":0}]
[{"$nulls":7},{"$f":"SUM(Table1[[#This Row],[Pre-Tax]:[PST]])","v":0}]
[{"$nulls":7},{"$f":"SUM(Table1[[#This Row],[Pre-Tax]:[PST]])","v":0}]
[{"$nulls":7},{"$f":"SUM(Table1[[#This Row],[Pre-Tax]:[PST]])","v":0}]
[{"$nulls":7},{"$f":"SUM(Table1[[#This Row],[Pre-Tax]:[PST]])","v":0}]
[{"$nulls":7},{"$f":"SUM(Table1[[#This Row],[Pre-Tax]:[PST]])","v":0}]
[{"$nulls":7},{"$f":"SUM(Table1[[#This Row],[Pre-Tax]:[PST]])","v":0}]
[{"$nulls":7},{"$f":"SUM(Table1[[#This Row],[Pre-Tax]:[PST]])","v":0}]
[{"$nulls":3},"Totals:",{"$f":"SUBTOTAL(109,Table1[Pre-Tax])","v":0},{"$f":"SUBTOTAL(109,Table1[GST])","v":0},{"$f":"SUBTOTAL(109,Table1[PST])","v":0},{"$f":"SUBTOTAL(109,Table1[Total\nInvoice])","v":0}]
[]
[{"$nulls":3},"Reported Actual Eligible Spend (Pre-tax + PST):",{"$f":"Table1[[#Totals],[Pre-Tax]]+Table1[[#Totals],[PST]]","v":0}]
[{"$nulls":5},"Published May 12, 2021 - Ver. 1.6"]