{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["EXAMPLE","Budget Worksheet","Lists"],"not_rendered":{"images":3,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"EXAMPLE","index":0,"n_rows":20,"n_cols":6,"rows_kept":20,"merged":[[14,0,14,1]]}
["Expense Category","Expense Description\nEnter a brief description of what the expense includes","Amount ($)","Requested Funds from PSE\n*Ineligible expenses will not be included in the total below","Contributing Funds","Expense Eligibility\nPSE use only"]
["Electric Vehicle Supply Equipment (EVSE)","(2) Level 2 Chargers for public use",{"v":8000,"d":"$8,000"},{"v":8000,"d":"$8,000"},{"v":0,"d":"$0"},{"$f":"IFERROR(VLOOKUP(A2,Lists!A:B,2,FALSE),\"\")","v":"Eligible"}]
["Electric Vehicles (EVs)","(1) Ford F-150 Lightning for fleet operations",{"v":55000,"d":"$55,000"},{"v":50000,"d":"$50,000"},{"v":5000,"d":"$5,000"},{"$f":"IFERROR(VLOOKUP(A3,Lists!A:B,2,FALSE),\"\")","v":"Eligible"}]
["Maintenance and operations plans","Annual maintenance contract for EV charging stations",{"v":3000,"d":"$3,000"},{"v":3000,"d":"$3,000"},{"v":0,"d":"$0"},{"$f":"IFERROR(VLOOKUP(A4,Lists!A:B,2,FALSE),\"\")","v":"Eligible"}]
["Project management costs ","Personnel directly responsible for project development and/or implementation",{"v":10000,"d":"$10,000"},{"v":10000,"d":"$10,000"},{"v":0,"d":"$0"},{"$f":"IFERROR(VLOOKUP(A5,Lists!A:B,2,FALSE),\"\")","v":"Eligible"}]
["Efforts to raise awareness ","Public outreach campaign to promote EV adoption and new chargers",{"v":7500,"d":"$7,500"},{"v":7500,"d":"$7,500"},{"v":0,"d":"$0"},{"$f":"IFERROR(VLOOKUP(A6,Lists!A:B,2,FALSE),\"\")","v":"Eligible"}]
["Indirect costs - business or operational costs incurred for a common organizational purpose and not directly connected with implementation of a specific project   ","Regular employee salaries",{"v":30000,"d":"$30,000"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"IFERROR(VLOOKUP(A7,Lists!A:B,2,FALSE),\"\")","v":"Ineligible"}]
["Donated, in-kind, volunteer materials and labor","Volunteer labor for installation of EV charging stations",{"v":5000,"d":"$5,000"},{"v":0,"d":"$0"},{"v":2500,"d":"$2,500"},{"$f":"IFERROR(VLOOKUP(A8,Lists!A:B,2,FALSE),\"\")","v":"Ineligible"}]
["New or upgraded electrical service  ","Installation of upgraded electrical service for new EV chargers",{"v":15000,"d":"$15,000"},{"v":15000,"d":"$15,000"},{"v":0,"d":"$0"},{"$f":"IFERROR(VLOOKUP(A9,Lists!A:B,2,FALSE),\"\")","v":"Eligible"}]
["Contingency fees  ","10% contingency for unforeseen project costs",{"v":8000,"d":"$8,000"},{"v":8000,"d":"$8,000"},{"v":0,"d":"$0"},{"$f":"IFERROR(VLOOKUP(A10,Lists!A:B,2,FALSE),\"\")","v":"Eligible"}]
["Insurance costs","Insurance for electric tractor farm share program ",{"v":14000,"d":"$14,000"},{"v":14000,"d":"$14,000"},{"v":0,"d":"$0"},{"$f":"IFERROR(VLOOKUP(A11,Lists!A:B,2,FALSE),\"\")","v":"Ineligible"}]
["COST TOTALS",null,{"$f":"SUM(C2:C11)","v":{"v":155500,"d":"$155,500"}},{"$f":"SUMIF(F2:F11, \"Eligible\", D2:D11)","v":{"v":101500,"d":"$101,500"}},{"$f":"SUM(E2:E11)","v":{"v":7500,"d":"$7,500"}}]
[]
[]
["Funding Summary"]
["Contributing Fund Sources"," Contributing Amount"]
["Contributing Funds  ",{"$f":"E12","v":{"v":7500,"d":"$7,500"}}]
["Contributing Funds Total",{"$f":"SUM(B17:B17)","v":{"v":7500,"d":"$7,500"}}]
["Requested Funds from PSE",{"$f":"D12","v":{"v":101500,"d":"$101,500"}}]
["TOTAL FUNDING",{"$f":"SUM(B18:B19)","v":{"v":109000,"d":"$109,000"}}]

{"sheet":"Budget Worksheet","index":1,"n_rows":29,"n_cols":6,"rows_kept":29,"merged":[[23,0,23,1]]}
["Expense Category","Expense Description\nEnter a brief description of what the expense includes","Amount ($)","Requested Funds from PSE\n*Ineligible expenses will not be included in the total below","Contributing Funds","Expense Eligibility\nPSE use only"]
[]
[{"$nulls":5},{"$f":"IFERROR(VLOOKUP(A3,Lists!A:B,2,FALSE),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(VLOOKUP(A4,Lists!A:B,2,FALSE),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(VLOOKUP(A5,Lists!A:B,2,FALSE),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(VLOOKUP(A6,Lists!A:B,2,FALSE),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(VLOOKUP(A7,Lists!A:B,2,FALSE),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(VLOOKUP(A8,Lists!A:B,2,FALSE),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(VLOOKUP(A9,Lists!A:B,2,FALSE),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(VLOOKUP(A10,Lists!A:B,2,FALSE),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(VLOOKUP(A11,Lists!A:B,2,FALSE),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(VLOOKUP(A12,Lists!A:B,2,FALSE),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(VLOOKUP(A13,Lists!A:B,2,FALSE),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(VLOOKUP(A14,Lists!A:B,2,FALSE),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(VLOOKUP(A15,Lists!A:B,2,FALSE),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(VLOOKUP(A16,Lists!A:B,2,FALSE),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(VLOOKUP(A17,Lists!A:B,2,FALSE),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(VLOOKUP(A18,Lists!A:B,2,FALSE),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(VLOOKUP(A19,Lists!A:B,2,FALSE),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(VLOOKUP(A20,Lists!A:B,2,FALSE),\"\")","v":""}]
["COST TOTALS",null,{"$f":"SUM(C2:C20)","v":{"v":0,"d":"$0"}},{"$f":"SUMIF(F2:F20, \"Eligible\", D2:D20)","v":{"v":0,"d":"$0"}},{"$f":"SUM(E2:E20)","v":{"v":0,"d":"$0"}}]
[]
[]
["Funding Summary"]
["Contributing Fund Sources"," Contributing Amount"]
["Contributing Funds  ",{"$f":"E21","v":{"v":0,"d":"$0"}}]
["Contributing Funds Total",{"$f":"SUM(B26:B26)","v":{"v":0,"d":"$0"}}]
["Requested Funds from PSE",{"$f":"D21","v":{"v":0,"d":"$0"}}]
["TOTAL FUNDING",{"$f":"SUM(B27:B28)","v":{"v":0,"d":"$0"}}]

{"sheet":"Lists","index":2,"n_rows":20,"n_cols":2,"rows_kept":20,"hidden":true}
["Auxiliary equipment that support a transportation electrification project directly","Eligible"]
["Contingency fees  ","Eligible"]
["Efforts to raise awareness ","Eligible"]
["Electric Vehicle Supply Equipment (EVSE)","Eligible"]
["Electric Vehicles (EVs)","Eligible"]
["Engineering, design, permitting, construction, and installation costs ","Eligible"]
["Extended warranties for EVSE","Eligible"]
["Grant writing services to directly support application preparation","Eligible"]
["Maintenance and operations plans","Eligible"]
["Micromobility-related projects and equipment","Eligible"]
["Network subscriptions and software licensing costs  for EVSE","Eligible"]
["New or upgraded electrical service  ","Eligible"]
["Project management costs ","Eligible"]
["Project studying, planning, and evaluation","Eligible"]
["Auxiliary equipment that do not directly support a transportation electrification project ","Ineligible"]
["Donated, in-kind, volunteer materials and labor","Ineligible"]
["Indirect costs - business or operational costs incurred for a common organizational purpose and not directly connected with implementation of a specific project   ","Ineligible"]
["Insurance costs","Ineligible"]
["Ongoing energy costs  ","Ineligible"]
["Other","Eligible or Ineligible"]