{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["About EI2","FAQ","START","ProjectData","SummaryResults","User Add-in Location","DefaultData","Calculations","Deflators","Multipliers","Lists"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":65,"comments":3,"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":"About EI2","index":0,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[[7,1,11,1]]}
[null,"EI2 - ThermalComfortR"]
[]
[null,"Economic Impacts of Electrification Initiatives (EI2) Model "]
[]
[]
[null,"Release Number: tcr-2021-10-22"]
[]
[null,"   The Economic Impacts of Electrification Initiatives (EI2) Model use a similar structure as the Jobs and Economic Development Impact (JEDI) Model that was initially developed in 2002 to demonstrate the economic benefits associated with developing land-based wind power plants in the United States.  \n\nThe primary goal in developing the Canadian provincial / territorial level model is to provide a tool for government officials, decision makers and other potential users, to easily identify the local economic impacts associated with energy efficiency measures such as installing thermal comfort technologies. The second goal was to facilitate broad access and usage of the model. "]
[]
[]
[]
[]
[null,"   \nConsistent with these goals, a strong emphasis was placed on designing the model in a user-friendly format that could be easily modified - reflecting different levels of project specific information and user skill. This insures the greatest flexibility for inexperienced spreadsheet users, those unfamiliar with economic impact analysis, and more experienced and knowledgeable users who have a need for this specific type of analysis. "]
[]
[]
[null,"The EI2 models were adapted by Éloïse Edom, research associate at the Institut de l'énergie Trottier, as part of the NRCAN-supported Energy Modelling Initiative."]
[null,"Institut de l'énergie Trottier"]
[null,"Energy Modelling Initiative"]
[]
[null,"For more information about the EI2 models go to https://emi-ime.ca/ei2/."]
[null,"Or contact:"]
[null,"info@emi-ime.ca"]
[null,"eloise.edom@polymtl.ca "]

{"sheet":"FAQ","index":1,"n_rows":60,"n_cols":2,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[]
[null,"EI2 - ThermalComfortR"]
[]
[null,"Economic Impacts of Electrification Initiatives (EI2) Model "]
[]
[null,"Frequently Asked Questions (FAQ)"]
[]
[]
[null,"How do I know if I have the most current version of the EI2 model?"]
[null,"The most current version of the EI2 model is available on the Energy Modelling initiative web site at https://emi-ime.ca/.  "]
[]
[null,"How can I determine which version of the EI2 model I have?"]
[null,"The version (release number) of the model you are currently using is listed in the \"About EI2\" worksheet contained in this model.  "]
[]
[null,"When I open up the model I receive a security alert message stating \"the macros in the file have been disabled,\" how do I change the security setting so I "]
[null,"can run the model with the macros enabled?  "]
[null,"Click on the \"Enable Content\" button that appears at the left of the security alert."]
[]
[null,"What does the \"local share\" refer to?"]
[null,"The \"local share\" refers to the percentage of each expenditure that is actually spent locally (i.e., in the province, territory,  region being analyzed).  For example, if $1 million"]
[null,"is going to be spent on equipments and half ($500,000) of this total will be purchased from local suppliers, we say the \"local share\" is 50 percent."]
[]
[null,"What does the term \"full-time equivalent for a period of one year\" refer to in the jobs results?"]
[null,"The term refers to a job that is held (and wages paid) for a period of one year.  This is based on 2,080 hours (52 weeks times 40 hours per week).  For example, if the "]
[null,"analysis indicates there are 100 construction jobs, there will be the equivalent of 100 workers, working full-time, for the entire year.  If the construction period is two   "]
[null,"years, the job impacts (100 jobs) are spread over the two year construction period.  In this example, there will be an average of 50 full-time jobs (100 jobs divided by 2    "]
[null,"years) during each of the years.  Similarly, if the construction period is less than one year, for example, 9 months (75 percent of a full year), then the number of persons   "]
[null,"actually employed and working full-time during that period will be greater since they will not be employed and working for an entire year.  In this example, there will be   "]
[null,"an average of 133 full-time workers (100 jobs divided by .75 percent of the year) during the 9 month construction period."]
[]
[null,"I want to make my analysis as accurate as possible, where can I get information to adjust the default \"local share\" values (in the ProjectData worksheet) "]
[null,"for my province or territory?"]
[null,"Since the \"local share\" is directly related to the availability of local businesses and services and their ability to meet the installation and annual operating demands"]
[null,"of the project, it is important to have an accurate picture of these local resources.  This can be obtained in a number of ways: contacting experienced and knowlegeable "]
[null,"persons in the area, contacting local business and contractor organizations and/or the local chamber of commerce, among others."]
[]
[null,"I want to make changes to the default Labour installation and/or maintenance costs, wage rates or employer payroll overhead but when I do I receive a pop up "]
[null,"instructing me to only make changes if I change other wage and/or salary related cells.  Why is this?"]
[null,"The model uses the total Labour costs and the average wages per hour to calculate the number of installation workers and maintenance workers.  Therefore, if a User chooses"]
[null,"to modify the default values, they override the default ratios programed into the model.  Thus, if the User increases (or decreases) the total Labour costs without changing "]
[null,"the wage per hour, the results will show more workers.  Similarly, if the average wage per hour is increased (or decreased), without a subsequent increase in the"]
[null,"total Labour costs, the results will show fewer workers."]
[]
[null,"I am interested in viewing and possibly editting internal formulas within the model, how do I access them?  "]
[null,"The EI2 model contains several intermediate worksheets that are an integral part of the model analysis. These worksheets are not designed to be changed by users."]
[null,"Several of these worksheets, including default data, calculations, and deflators may be viewed by merely clicking on the respective worksheet and scrolling to the right."]
[null,"Although these sheets may be viewed by users they are protected and can not be edited.  "]
[]
[null,"What is the source of the default system costs?"]
[null,"Default values are derived from various sources. Sources include:"]
[null,"Costs and cost allocations"]
[null,"- A survey (conducted with companies working in energy services in the residential sector)"]
[null,"- A database developped by Canmet ENERGY"]
[]
[null,"Where can I get more information on input-output modeling and using the EI2 model?  "]
[null,"More information on how to use the EI2 model can be found at https://emi-ime.ca/ei2/."]
[null,"EI2 use the same structure as the JEDI models developped by NREL. To view and/or download JEDI related publications go to the Department of Energy's web site "]
[null,"at www.windpoweringamerica.gov.  Click on \"Economic Development\" on the left side of the page (under Program Areas).  Additional information on these topics and access to "]
[null,"publications is available by then clicking on \"Jobs and Economic Impact (JEDI) Model.  Once there, scroll down to \"Publications\" and click on any of the links.  "]
[null,"(See also, Is additional technical support available, in FAQ.)"]

{"sheet":"START","index":2,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"EI2 - ThermalComfortR"]
[null,"Economic Impacts of Electrification Initiatives (EI2) Model "]

{"sheet":"ProjectData","index":3,"n_rows":51,"n_cols":36,"rows_kept":51,"cut":false,"hidden":false,"merged":[[43,0,43,5],[2,0,2,5],[23,0,23,2],[24,0,24,5],[34,0,34,5],[25,0,25,5]]}
["EI2 - Thermal Comfort Residential (EI2-TCR)"]
[]
["INSTRUCTIONS:      \n   1. Begin by entering Project Location (from pull-down list) and other Descriptive Data.  \t\t\t\t\t\n   2. After inserting required data press enter (or cursor to the next cell) to continue.\t\t\t\t\t\n   3. Once Descriptive Data is complete, choose \"Y\" or \"N\" on Line 20 to continue.\t\t\t\t\t\n   4. Choose \"Y\" to accept Project Cost and Local Share defaults or \"N\" to review/modify values.\n   5. Once all values are entered, click the \"Go to Summary Impacts\" button.\n\t\t\t\t\t\nTo utilize new values in analysis you must choose an \"N\" in \"Utilize Model Default Values (below)?\" - Line 21\t\t\nAdditional information is available by pointing to the red triangles located in cell corners and in the FAQ tab.\t\t\t\t\t\nOnly those cells with a white background can be changed (accept new values).  \t"]
[]
[]
["Project Descriptive Data"]
["Project Description"]
["Project Name ","Project 1",{"$f":"IF(B9=\"MYREGION\",IF('User Add-in Location'!E22=0,\"   Error - No Regional multiplier data in User Add-in Location\",\"\"),\"\")","v":""}]
["Project Location","Alberta",{"$f":"IF(B9=\"MYREGION\",IF('User Add-in Location'!E22=0,\"\",\"          Enter Region Population\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B9=\"MYREGION\",IF(B10=\"\",2,1),0)","v":0}]
[null,null,{"$f":"IF($C9=\"\",\"\",IF($B10<1,\"      **Error - Population Data Missing**\",\"\"))","v":""}]
["Thermal Comfort Technology / Service","Cold climate air-source heat pump"]
["Number of installations",12000]
[]
[]
["Installation information"]
["Year of Construction ",2022]
["Money Value (Dollar Year) ",2020]
["Costs information"]
["Installed Cost ($/technology)",{"$f":"DefaultData!F7","v":18276.16}]
["Maintenance Cost ($/technology)",{"$f":"DefaultData!G7","v":230}]
["Utilize Project Cost Data default values in analysis? Choose \"Y\" to accept default values below or \"N\" to over-ride default ","Y",null,{"$f":"IF($B$21=\"y\",\"Press 'Go To Summary Impacts' Button\",IF($B$21=\"N\",\"Modify Project Cost Data (below)\",\"Error - Re-enter 'Y' or 'N'\"))","v":"Press 'Go To Summary Impacts' Button"}]
["values and utilize new user defined values as entered below.  See FAQ for related topics."]
[]
["If desired, default values (in cells below - based on Project Descriptive Data entered above) may be restored by pressing the 'Restore Default Values' button.  Note: it is not necessary to restore defaults to incorporate default Project Cost Data in system analysis - simply choose \"Y\" in cell B24 above.  "]
["Project cost Data"]
["Installation Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Default Values"]
[null,"Cost","Cost Per installation","Percent of Total Cost","Local Share",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost","Local Share"]
["Equipment & Installation Costs"]
[{"$f":"DefaultData!C17","v":"Cold climate air-source heat pump"},{"$f":"AH29","v":120622656.00000001},{"$f":"B29/(B$12)","v":10051.888000000001},{"$f":"B29/B$33","v":0.55000000000000004},{"$f":"AI29","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DefaultData!D17","v":120622656.00000001},{"$f":"DefaultData!F17","v":1}]
["Labour",{"$f":"AH30","v":98691264},{"$f":"B30/(B$12)","v":8224.2720000000008},{"$f":"B30/B$33","v":0.45},{"$f":"AI30","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DefaultData!D18","v":98691264},{"$f":"DefaultData!F18","v":1}]
["Subtotal (all cost without taxes)",219313920,{"$f":"B31/(B$12)","v":18276.16},{"$f":"B31/B33","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH29+AH30","v":219313920}]
["Sales tax",0,{"$f":"B32/(B$12)","v":0},{"$f":"B32/B33","v":0},{"$f":"AI32","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DefaultData!D20","v":0},1]
["Total installations costs",{"$f":"B31+B32","v":219313920},null,{"$f":"D31+D32","v":1}]
[]
["Annual  Maintenance Costs"]
["","Cost","Cost Per installation","Percent of Total Cost","Local Share ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost","Local Share or % of Time Onsite (for itinerate workers)"]
["Labour"]
["Maintenance labour",{"$f":"AH38","v":2760000},{"$f":"B38/(B$12)","v":230},{"$f":"IF(B38<>0,B38/B$41,0)","v":1},{"$f":"AI38","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DefaultData!D27","v":2760000},{"$f":"DefaultData!F27","v":1}]
["Subtotal (all cost without taxes)",{"$f":"B38","v":2760000},{"$f":"B39/(B$12)","v":230},{"$f":"IF(B39<>0,B39/B$41,0)","v":1}]
["Sales tax",{"$f":"AH40","v":0},0,0,{"$f":"AI40","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DefaultData!D28","v":0},{"$f":"DefaultData!F28","v":1}]
["Total Maintenance Cost",{"$f":"B39+B40","v":2760000},null,{"$f":"D39+D40","v":1}]
[]
[]
["Other Parameters"]
["Tax Parameters"]
["Local Sales Tax Rate",{"$f":"AH46","v":0},null,null,{"$f":"AI46","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DefaultData!D33","v":0},{"$f":"DefaultData!E33","v":1}]
["Payroll Parameters"]
[null,"Wage per hour",null,"Employer Payroll Overhead",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wage per hour",null,"Employer Payroll Overhead"]
["Installation worker",{"$f":"AH49","v":27.727469804893161},null,{"$f":"AJ49","v":0.33830000000000005},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DefaultData!F37","v":27.727469804893161},null,{"$f":"DefaultData!K32","v":0.33830000000000005}]
[null,"Wage per hour",null,"Employer Payroll Overhead",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wage per hour",null,"Employer Payroll Overhead"]
["Maintenance worker",{"$f":"AH51","v":27.727469804893161},null,{"$f":"AJ51","v":0.33830000000000005},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DefaultData!F38","v":27.727469804893161},null,{"$f":"DefaultData!K32","v":0.33830000000000005}]

{"sheet":"SummaryResults","index":4,"n_rows":38,"n_cols":37,"rows_kept":38,"cut":false,"hidden":false,"merged":[[36,0,36,4]]}
["EI2 - TCR"]
[{"$f":"CONCATENATE(\"Thermal comfort measures - Project Data Summary based on \",$AE$5, \" values\")","v":"Thermal comfort measures - Project Data Summary based on Model Default Data values"}]
["Project Location",null,{"$f":"IF(ProjectData!B9=\"MyCounty\",'User Add-in Location'!#REF!,ProjectData!B9)","v":"Alberta"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D7+D8","v":18506.16},{"$f":"ProjectData!B21","v":"Y"}]
["Year of Construction ",null,{"$f":"ProjectData!B16","v":2022},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DefaultData!F7+DefaultData!G7","v":18506.16}]
["Number of installations",null,{"$f":"ProjectData!B12","v":12000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ROUND(AE3,2)=ROUND(AE4,2),AF3=\"Y\"),\"Model Default Data\",\"User Data\")","v":"Model Default Data"}]
[]
["Installed Cost ($/technology)",null,{"$f":"Calculations!D11/SummaryResults!C5","v":18276.16},{"$f":"ProjectData!B19","v":18276.16},"without taxes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(\"EI2-TCR_\",ProjectData!B8)","v":"EI2-TCR_Project 1"}]
["Maintenance Cost ($/technology)",null,{"$f":"Calculations!D18/SummaryResults!C5","v":230},{"$f":"ProjectData!B20","v":230},"without taxes"]
["Money Value (Dollar Year)",null,{"$f":"ProjectData!B17","v":2020}]
["Total Installed Project Cost",null,{"$f":"Calculations!D11","v":219313920}]
["Local Spending",null,{"$f":"Calculations!D36","v":219313920}]
["Total Annual Maintenance Expenses"]
["Direct Maintenance Costs"]
["Local Spending",null,{"$f":"Calculations!D18","v":2760000}]
[]
[]
[]
[]
[]
[]
["Local Economic Impacts - Summary Results"]
[null,"Jobs","Earnings","Output","Value Added"]
["Installation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local Economic Impacts - Construction phase - # of jobs created"]
["Direct impacts",{"$f":"Calculations!AH18","v":1605.1634957560404},{"$f":"Calculations!AI18","v":98.69126399999999},{"$f":"Calculations!AJ18","v":98.69126399999999},{"$f":"Calculations!AK18","v":55.332200467187555},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"During Installation period","JOBS",null,null,"Earnings","Output","Value Added"]
["Indirect impacts (supply chain impacts)",{"$f":"Calculations!AH19","v":734.6889450249239},{"$f":"Calculations!AI19","v":61.628760778370072},{"$f":"Calculations!AJ19","v":216.71100143867483},{"$f":"Calculations!AK19","v":85.762582537175305},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Induced Impacts",{"$f":"B26","v":257.79837846344691},null,"Induced Impacts",{"$f":"C26","v":13.552003442589077},53.352928263107302,33.133231715593446]
["Induced Impacts",{"$f":"Calculations!AH20","v":257.79837846344691},{"$f":"Calculations!AI20","v":13.552003442589077},{"$f":"Calculations!AJ20","v":53.352928263107302},{"$f":"Calculations!AK20","v":33.133231715593446},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indirect impacts (supply chain impacts)",{"$f":"B25","v":734.6889450249239},null,"Indirect impacts (supply chain impacts)",{"$f":"C25","v":61.628760778370072},216.71100143867483,85.762582537175305]
["Total Impacts",{"$f":"SUM(B24:B26)","v":2597.6508192444117},{"$f":"SUM(C24:C26)","v":173.87202822095912},368.7551937017821,174.22801471995629,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Direct impacts",{"$f":"B24","v":1605.1634957560404},null,"Direct impacts",{"$f":"C24","v":98.69126399999999},{"$f":"D24","v":98.69126399999999},{"$f":"E24","v":55.332200467187555}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Impacts",{"$f":"B27","v":2597.6508192444117},null,"Total Impacts",{"$f":"C27","v":173.87202822095912},{"$f":"D27","v":368.7551937017821},{"$f":"E27","v":174.22801471995629}]
["During operating years (annual)"]
["Onsite Labor Impacts",{"$f":"Calculations!AH25","v":35.758725227757054},{"$f":"Calculations!AI25","v":2.0148000000000001},{"$f":"Calculations!AJ25","v":2.0148000000000001},{"$f":"Calculations!AK25","v":2.0148000000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local Economic Impacts - O&M phase - # of jobs created"]
["Local Revenue and Supply Chain Impacts",{"$f":"Calculations!AH26","v":3.3911657385211731},{"$f":"Calculations!AI26","v":0.22897019564274851},{"$f":"Calculations!AJ26","v":0.85577085178713108},{"$f":"Calculations!AK26","v":0.4385825902944897},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual maintenance","JOBS",null,null,"Earnings","Output","Value Added"]
["Induced Impacts",{"$f":"Calculations!AH27","v":2.3144594202880744},{"$f":"Calculations!AI27","v":0.12201339509486173},{"$f":"Calculations!AJ27","v":0.47857890284854032},{"$f":"Calculations!AK27","v":0.2973158705024308},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Induced Impacts",{"$f":"B32","v":2.3144594202880744},null,"Induced Impacts",{"$f":"C32","v":0.12201339509486173},0.47857890284854032,0.2973158705024308]
["Total Impacts",{"$f":"SUM(B30:B32)","v":41.464350386566302},{"$f":"SUM(C30:C32)","v":2.3657835907376104},3.3491497546356719,2.7506984607969205,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local Revenue and Supply Chain Impacts",{"$f":"B31","v":3.3911657385211731},null,"Local Revenue and Supply Chain Impacts",{"$f":"C31","v":0.22897019564274851},{"$f":"D31","v":0.85577085178713108},{"$f":"E31","v":0.4385825902944897}]
[{"$f":"CONCATENATE(\"Notes:  Earnings and Output values are millions of dollars in year \", ProjectData!B17,\" dollars.\")","v":"Notes:  Earnings and Output values are millions of dollars in year 2020 dollars."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Onsite Labor Impacts",{"$f":"B30","v":35.758725227757054},null,"Onsite Labor Impacts",{"$f":"C30","v":2.0148000000000001},2.0148000000000001,2.0148000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Impacts",41.464350386566302,null,"Total Impacts",{"$f":"C33","v":2.3657835907376104},{"$f":"D33","v":3.3491497546356719},{"$f":"E33","v":2.7506984607969205}]
[]
["Installation and maintenance jobs are full-time equivalent for a period of one year (1 FTE = 2,080 hours). Economic impacts \"During operating years\" represent impacts that occur from system maintenance expenditures. The analysis does not include impacts associated with spending of homeowners utility savings. Totals may not add up due to independent rounding.  "]
[{"$f":"CONCATENATE(\"Results are based on \",AE5,\" values.\")","v":"Results are based on Model Default Data values."}]

{"sheet":"User Add-in Location","index":5,"n_rows":208,"n_cols":6,"rows_kept":208,"cut":false,"hidden":true,"merged":[]}
["Multipliers For Economic Input-Output Analysis"]
[]
["MYREGION (Name)",null,"Year of Data",null,""]
["Province or Territory (Name)"]
[]
["Jobs Direct Multipliers",null,null,null,"Personal Consumption Expenditures (PCE)"]
["Jobs Per Million Dollars Change in Final Demand","MyRegion",null,null,"MYREGION"]
["Agriculture",0,null,null,0]
["Mining",0,null,null,0]
["Construction",0,null,null,0]
["Manufacturing",0,null,null,0]
["Fabricated Metals",0,null,null,0]
["Machinery",0,null,null,0]
["Electrical Equipment",0,null,null,0]
["TCPU",0,null,null,0]
["Wholesale Trade",0,null,null,0]
["Retail Trade",0,null,null,0]
["FIRE",0,null,null,0]
["Misc. Services",0,null,null,0]
["Professional Services",0,null,null,0]
["Government",0,null,null,0]
[null,null,null,null,{"$f":"SUM(E8:E21)","v":0},"Total"]
["Jobs Indirect Multipliers"]
["Jobs Per Million Dollars Change in Final Demand","MyRegion"]
["Agriculture",0]
["Mining",0]
["Construction",0]
["Manufacturing",0]
["Fabricated Metals",0]
["Machinery",0]
["Electrical Equipment",0]
["TCPU",0]
["Wholesale Trade",0]
["Retail Trade",0]
["FIRE",0]
["Misc. Services",0]
["Professional Services",0]
["Government",0]
[]
["Jobs Induced Multipliers"]
["Jobs Per Million Dollars Change in Final Demand","MyRegion"]
["Agriculture",0]
["Mining",0]
["Construction",0]
["Manufacturing",0]
["Fabricated Metals",0]
["Machinery",0]
["Electrical Equipment",0]
["TCPU",0]
["Wholesale Trade",0]
["Retail Trade",0]
["FIRE",0]
["Misc. Services",0]
["Professional Services",0]
["Government",0]
[]
["Earnings Direct Multipliers"]
["Earnings Per Million Dollars Change in Final Demand","MyRegion"]
["Agriculture",0]
["Mining",0]
["Construction",0]
["Manufacturing",0]
["Fabricated Metals",0]
["Machinery",0]
["Electrical Equipment",0]
["TCPU",0]
["Wholesale Trade",0]
["Retail Trade",0]
["FIRE",0]
["Misc. Services",0]
["Professional Services",0]
["Government",0]
[]
["Earnings Per Million Dollars Change in Final Demand"]
["  Earnings Indirect Multipliers","MyRegion"]
["Agriculture",0]
["Mining",0]
["Construction",0]
["Manufacturing",0]
["Fabricated Metals",0]
["Machinery",0]
["Electrical Equipment",0]
["TCPU",0]
["Wholesale Trade",0]
["Retail Trade",0]
["FIRE",0]
["Misc. Services",0]
["Professional Services",0]
["Government",0]
[]
["Earnings Induced Multipliers"]
["Earnings Per Million Dollars Change in Final Demand","MyRegion"]
["Agriculture",0]
["Mining",0]
["Construction",0]
["Manufacturing",0]
["Fabricated Metals",0]
["Machinery",0]
["Electrical Equipment",0]
["TCPU",0]
["Wholesale Trade",0]
["Retail Trade",0]
["FIRE",0]
["Misc. Services",0]
["Professional Services",0]
["Government",0]
[]
["Output Direct Multipliers"]
["Output Per Million Dollars Change in Final Demand","MyRegion"]
["Agriculture",0]
["Mining",0]
["Construction",0]
["Manufacturing",0]
["Fabricated Metals",0]
["Machinery",0]
["Electrical Equipment",0]
["TCPU",0]
["Wholesale Trade",0]
["Retail Trade",0]
["FIRE",0]
["Misc. Services",0]
["Professional Services",0]
["Government",0]
[]
["Output Indirect Multipliers"]
["Output Per Million Dollars Change in Final Demand","MyRegion"]
["Agriculture",0]
["Mining",0]
["Construction",0]
["Manufacturing",0]
["Fabricated Metals",0]
["Machinery",0]
["Electrical Equipment",0]
["TCPU",0]
["Wholesale Trade",0]
["Retail Trade",0]
["FIRE",0]
["Misc. Services",0]
["Professional Services",0]
["Government",0]
[]
["Output Induced Multipliers"]
["Output Per Million Dollars Change in Final Demand","MyRegion"]
["Agriculture",0]
["Mining",0]
["Construction",0]
["Manufacturing",0]
["Fabricated Metals",0]
["Machinery",0]
["Electrical Equipment",0]
["TCPU",0]
["Wholesale Trade",0]
["Retail Trade",0]
["FIRE",0]
["Misc. Services",0]
["Professional Services",0]
["Government",0]
[]
["Value Added Direct Multipliers"]
["Value Added Per Million Dollars Change in Final Demand","MyRegion"]
["Agriculture",0]
["Mining",0]
["Construction",0]
["Manufacturing",0]
["Fabricated Metals",0]
["Machinery",0]
["Electrical Equipment",0]
["TCPU",0]
["Wholesale Trade",0]
["Retail Trade",0]
["FIRE",0]
["Misc. Services",0]
["Professional Services",0]
["Government",0]
[]
["Value Added Indirect Multipliers"]
["Value Added Per Million Dollars Change in Final Demand","MyRegion"]
["Agriculture",0]
["Mining",0]
["Construction",0]
["Manufacturing",0]
["Fabricated Metals",0]
["Machinery",0]
["Electrical Equipment",0]
["TCPU",0]
["Wholesale Trade",0]
["Retail Trade",0]
["FIRE",0]
["Misc. Services",0]
["Professional Services",0]
["Government",0]
[]
["Value Added Induced Multipliers"]
["Value Added Per Million Dollars Change in Final Demand","MyRegion"]
["Agriculture",0]
["Mining",0]
["Construction",0]
["Manufacturing",0]
["Fabricated Metals",0]
["Machinery",0]
["Electrical Equipment",0]
["TCPU",0]
["Wholesale Trade",0]
["Retail Trade",0]
["FIRE",0]
["Misc. Services",0]
["Professional Services",0]
["Government",0]

{"sheet":"DefaultData","index":6,"n_rows":66,"n_cols":58,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,0,16,1]]}
[2020,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual average change",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HVAC",null,"Labour cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5.0000000000000001E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cold climate air-source heat pump",1,0.45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electric furnace",2,0.45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,null,null,null,null,null,null,null,null,null,null,null,null,"Building envelop improvement",null,"Labour cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,null,null,null,null,null,null,null,null,null,null,null,null,"Attic insulation (acheive a minimum RSI 8.81 or R-50)",3,0.7]
[null,null,null,"Number of installations",null,"Default Installation Cost per technology","Default Maintenance cost per techno / year",null,null,null,null,null,null,null,null,"Cold climate air-source heat pump",{"$f":"VLOOKUP(ProjectData!B$9,DefaultData!AW$12:BE$26,2,FALSE)","v":18368},{"$f":"Q6*(1+$V$2)","v":18276.16},{"$f":"R6*(1+$V$2)","v":18184.779200000001},18093.855304000001,18003.386027479999,17913.369097342598,17823.802251855886,17734.683240596605,17646.009824393623,17557.779775271654,17469.990876395295,17382.640922013317,17295.72771740325,17209.249078816232,17123.20283342215,17037.586819255041,16952.398885158764,16867.636890732971,16783.298706279307,16699.382212747911,null,null,null,null,null,null,null,null,null,null,null,null,"Flat roof and/or Cathedral ceiling insulation (acheive a minimum RSI 4.93 or R-28)",4,0.7]
[null,null,null,{"$f":"ProjectData!B12","v":12000},null,{"$f":"Q16","v":18276.16},{"$f":"Q17","v":230},null,null,null,null,null,null,null,null,"Electric furnace",{"$f":"VLOOKUP(ProjectData!B$9,DefaultData!AW$12:BE$26,3,FALSE)","v":5145},{"$f":"Q7*(1+$V$2)","v":5119.2749999999996},5093.6786249999996,5068.2102318749994,5042.8691807156247,5017.6548348120468,4992.5665606379862,4967.6037278347958,4942.7657091956216,4918.0518806496439,4893.4616212463952,4868.9943131401633,4844.6493415744626,4820.4260948665906,4796.3239643922579,4772.3423445702965,4748.4806328474451,4724.7382296832075,4701.1145385347918,4677.6089658421179,null,null,null,null,null,null,null,null,null,null,null,null,"Basement / Foundation insulation (insulate a minimum of 60% the area) ",5,0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attic insulation (acheive a minimum RSI 8.81 or R-50)",{"$f":"VLOOKUP(ProjectData!B$9,DefaultData!AW$12:BE$26,4,FALSE)","v":1971.6096367999205},1961.7515886159208,1951.9428306728412,1942.1831165194769,1932.4722009368795,1922.809839932195,1913.1957907325341,1903.6298117788715,1894.1116627199772,1884.6411044063773,1875.2178988843455,1865.8418093899238,1856.5126003429741,1847.2300373412593,1837.993887154553,1828.8039177187802,1819.6598981301863,1810.5615986395353,1801.5087906463377,1792.5012466931059,null,null,null,null,null,null,null,null,null,null,null,null,"Exterior wall insulation (100% of the area to 2012 NBC levels)",6,0.4]
[null,null,null,"Construction",null," User",null,null,null,null,null,null,null,null,null,"Flat roof and/or Cathedral ceiling insulation (acheive a minimum RSI 4.93 or R-28)",{"$f":"VLOOKUP(ProjectData!B$9,DefaultData!AW$12:BE$26,5,FALSE)","v":2207.0838363585449},2196.0484171767521,2185.0681750908684,2174.142834215414,2163.272120044337,2152.4557594441153,2141.6934806468948,2130.9850132436604,2120.3300881774421,2109.728437736555,2099.1797955478723,2088.6838965701331,2078.2404770872827,2067.8492747018463,2057.5100283283373,2047.2224781866955,2036.9863657957621,2026.8014339667834,2016.6674267969495,2006.5840896629647,null,null,null,null,null,null,null,null,null,null,null,null,"Air-sealing",7,0.7]
[null,null,null,"Installation cost per techno","Installations Cost","Maintenance cost per techno / year","Maintenance costs per year",null,null,null,null,null,null,null,null,"Basement / Foundation insulation (insulate a minimum of 60% the area) ",{"$f":"VLOOKUP(ProjectData!B$9,DefaultData!AW$12:BE$26,6,FALSE)","v":3814.7328484363657},{"$f":"Q10*(1+$V$2)","v":3795.659184194184},3776.680888273213,3757.7974838318469,3739.0084964126877,3720.3134539306243,3701.7118866609712,3683.2033272276663,3664.7873105915278,3646.4633740385702,3628.2310571683774,3610.0899018825357,3592.0394523731229,3574.0792551112572,3556.208858835701,3538.4278145415224,3520.7356754688149,3503.1319970914706,3485.6163371060134,3468.1882554204831,null,null,null,null,null,null,null,null,null,null,null,null,"Windows and doors replacement (U-Factor 1.08 W/m2-K, and Energy star qualified)",8,0.4]
[null,null,null,{"$f":"ProjectData!B19","v":18276.16},{"$f":"D11*D7","v":219313920},{"$f":"ProjectData!B20","v":230},{"$f":"F11*D7","v":2760000},null,null,null,null,null,null,null,null,"Exterior wall insulation (100% of the area to 2012 NBC levels)",{"$f":"VLOOKUP(ProjectData!B$9,DefaultData!AW$12:BE$26,7,FALSE)","v":72449.442096957791},{"$f":"Q11*(1+$V$2)","v":72087.194886473008},71726.758912040648,71368.125117480449,71011.28449189305,70656.228069433579,70302.946929086407,69951.432194440975,69601.675033468768,69253.66665830143,68907.398325009926,68562.861333384877,68220.047026717948,67878.946791584356,67539.552057626439,67201.854297338301,66865.84502585161,66531.515800722351,66198.858221718736,65867.86393061014]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air-sealing",{"$f":"VLOOKUP(ProjectData!B$9,DefaultData!AW$12:BE$26,8,FALSE)","v":2073.1097756457575},2062.7442267675287,2052.4305056336912,2042.1683531055228,2031.9575113399951,2021.7977237832952,2011.6887351643786,2001.6302914885566,1991.6221400311138,1981.6640293309581,1971.7557091843032,1961.8969306383817,1952.0874459851898,1942.3270087552639,1932.6153737114876,1922.9522968429301,1913.3375353587155,1903.7708476819219,1894.2519934435122,1884.7807334762947,null,null,null,null,null,null,null,null,null,null,null,null,"Installation costs",1,2,3,4,5,6,7,8,1]
[null,null,"Project Data",null,null,null,null,null,null,null,null,null,null,null,null,"Windows and doors replacement (U-Factor 1.08 W/m2-K, and Energy star qualified)",{"$f":"VLOOKUP(ProjectData!B$9,DefaultData!AW$12:BE$26,9,FALSE)","v":20417.099999999999},{"$f":"Q13*(1+$V$2)","v":20315.014499999997},20213.439427499998,20112.372230362496,20011.810369210685,19911.751317364633,19812.19256077781,19713.131597973923,19614.565939984052,19516.493110284133,19418.91064473271,19321.816091509048,19225.207011051501,19129.080975996243,19033.435571116261,18938.268393260678,18843.577051294375,18749.359166037902,18655.612370207713,18562.334308356676,null,null,null,null,null,null,null,null,null,null,null,null,"Alberta",18368,5145,1971.6096367999205,2207.0838363585449,3814.7328484363657,72449.442096957791,2073.1097756457575,20417.099999999999,2]
[null,null,{"$f":"ProjectData!B11","v":"Cold climate air-source heat pump"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"British Columbia",18368,5456.25,2154.4902736357285,2367.692344651789,4241.776312761498,71871.686613891085,2019.2102981210853,26873.1,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Installation year index",{"$f":"HLOOKUP(Year_of_Construction,DefaultData!Q4:AJ5,2,FALSE)","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manitoba",18368,4940,1729.751447776526,1513.8303751619997,3464.8192766364932,61724.57797989191,1760.9336571428573,12759.566666666666,4]
[null,null,"Equipment & Installation costs",null,null,"Local share",null,null,null,null,null,null,null,null,null,"Installation cost per technology",{"$f":"VLOOKUP(ProjectData!B11,DefaultData!P6:AJ13,DefaultData!Q15+1,FALSE)","v":18276.16},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Brunswick",18368,4865,1926.7617776903626,1859.2869100026664,3738.4120906105281,62810.238294714123,1847.7601500000003,19628.033333333333,5]
[null,null,{"$f":"ProjectData!B11","v":"Cold climate air-source heat pump"},{"$f":"E11*(1-Q18)","v":120622656.00000001},null,1,null,null,null,null,null,null,null,null,null,"Maintenance cost per technology / year",{"$f":"HLOOKUP(AV30,AW29:BE43,AV29+1,FALSE)","v":230},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Newfoundland and Labrador",18368,4775,1790.0624260208417,2167.8928743966667,3535.1330230588255,62892.387109453593,1800.4237200000002,15933.766666666666,6]
[null,null,"Labour",{"$f":"E11*Q18","v":98691264},null,1,null,null,null,null,null,null,null,null,null,"Labour portion",{"$f":"VLOOKUP(ProjectData!B11,DefaultData!AW2:AY10,3,FALSE)","v":0.45},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Northwest Territories",18368,4977.5,1796.1076607576661,1792.7610924883329,3742.8707635199999,61279.594435428553,1722.66264,16283.466666666665,7]
[null,null,"Subtotal All Costs (without sales tax)",{"$f":"SUM(D17:D18)","v":219313920},null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nova Scotia",18368,4747.5,1771.1641570433669,1547.2625921726399,3287.1816872999993,61763.540484142744,1809.0477649484537,16982.866666666665,8]
[null,null,"Sales Tax",{"$f":"D19*D33","v":0},null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nunavut",18368,4930,1796.1076607576661,1792.7610924883329,3742.8707635199999,61279.594435428553,1722.66264,16283.466666666665,9]
[null,null,"TOTAL PROJECT COST",{"$f":"D19+D20","v":219313920},null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ontario",18368,5390,1721.8593573642409,1512.4317139960003,3407.0254617888668,68300.546943049238,2113.425608369103,18543.066666666666,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prince Edward Island",18368,4835,1790.0624260208417,2167.8928743966667,3535.1330230588255,62892.387109453593,1800.4237200000002,15933.766666666666,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quebec",18368,4940,1754.7107995713827,1651.1860212491476,3383.4480615722573,60822.65882095995,1811.1834534322813,19816.333333333332,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saskatchewan",18368,3895,1995.4458161063117,1647.4901039069998,3738.3464424104786,66297.630501979525,1939.1529504424768,15117.8,13]
[null,null,"Annual Maintenance Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yukon",18368,5015,1828.5844878777777,2205.7844574919995,3529.7601317999997,66376.55445783383,2002.7762068965515,20336.399999999998,14]
[null,null,"Service",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Canada",18368,{"$f":"AVERAGE(AY13:AY25)","v":4916.25},1820,1782,3513,59047,1987,19494]
[null,null,"Maintenance Labour",{"$f":"G11","v":2760000},null,1]
[null,null,"Sales Tax ",{"$f":"D27*D33","v":0},null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maintenance cost per installation"]
[null,null,"TOTAL",{"$f":"D27+D28","v":2760000},null,1,null,null,null,"Payroll expense",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(ProjectData!B9,DefaultData!AW30:BF43,10,FALSE)","v":1},null,1,2,3,4,5,6,7,8]
[null,null,null,null,null,null,null,null,null,"Govt",{"$f":"VLOOKUP(ProjectData!B9,Multipliers!S8:U22,3,FALSE)","v":0.27},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(ProjectData!B11,DefaultData!AW1:AX10,2,FALSE)","v":1},"Alberta",230,195,0,0,0,0,0,0,1]
[null,null,null,null,null,null,null,null,null,"Health/Ins/Misc",{"$f":"IF(OR(ProjectData!B9=Multipliers!Z8,'User Add-in Location'!B4=Multipliers!Z8),Multipliers!Y8,Multipliers!Y7)","v":6.83E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"British Columbia",245,220,0,0,0,0,0,0,2]
[null,null,null,null,null,null,null,null,null,"Total",{"$f":"K30+K31","v":0.33830000000000005},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manitoba",210,190,0,0,0,0,0,0,3]
[null,null,"Local sales tax rate",{"$f":"C66","v":0},1,{"$f":"VLOOKUP(ProjectData!B9,Multipliers!S8:T22,2,FALSE)","v":1.1148962527098174},"Adj. Factor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Brunswick",212.5,152.5,0,0,0,0,0,0,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"User Revised Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Newfoundland and Labrador",205,155,0,0,0,0,0,0,5]
[null,null,null,"Payroll Cost","Av. wage/h","Loc. adj. Wage/hour","Payroll expense","Payroll expense %","Default","User Revised",null,"Default",null,"Payroll Cost","Wage/h","Payroll expense","Payroll expense",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Northwest Territories",205,150,0,0,0,0,0,0,6]
[null,null,"Payroll Parameters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nova Scotia",210,150,0,0,0,0,0,0,7]
[null,null,"Installation Labour",{"$f":"F37+G37","v":37.107672839888522},24.87,{"$f":"E37*F$33","v":27.727469804893161},{"$f":"F37*H37","v":9.3802030349953576},{"$f":"K$32","v":0.33830000000000005},{"$f":"(D18*F18)/(D37*52*40)","v":1278.6499245492869},{"$f":"(ProjectData!B30*ProjectData!E30)/(DefaultData!N37*52*40)","v":1278.6499245492869},null,{"$f":"D37*52*40","v":77183.959506968124},null,{"$f":"O37+P37","v":37.107672839888522},{"$f":"ProjectData!B49","v":27.727469804893161},{"$f":"O37*Q37","v":9.3802030349953576},{"$f":"ProjectData!D49","v":0.33830000000000005},{"$f":"N37*52*40","v":77183.959506968124},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nunavut",210,165,0,0,0,0,0,0,8]
[null,null,"Maintenance Labour",{"$f":"F38+G38","v":37.107672839888522},24.87,{"$f":"E38*F$33","v":27.727469804893161},{"$f":"F38*H38","v":9.3802030349953576},{"$f":"K$32","v":0.33830000000000005},{"$f":"(D27*F27)/(D38*52*40)","v":35.758725227757054},{"$f":"(ProjectData!B38*ProjectData!E38)/(DefaultData!N38*52*40)","v":35.758725227757054},null,{"$f":"D38*52*40","v":77183.959506968124},null,{"$f":"O38+P38","v":37.107672839888522},{"$f":"ProjectData!B51","v":27.727469804893161},{"$f":"O38*Q38","v":9.3802030349953576},{"$f":"ProjectData!D51","v":0.33830000000000005},{"$f":"N38*52*40","v":77183.959506968124},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ontario",250,225,0,0,0,0,0,0,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prince Edward Island",212.5,160,0,0,0,0,0,0,10]
[null,null,null,null,null,null,null,"Installation Labour",{"$f":"IF(ProjectData!$B$21=\"y\",DefaultData!I37,DefaultData!J37)","v":1278.6499245492869},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quebec",215,185,0,0,0,0,0,0,11]
[null,null,null,null,null,null,null,"Maintenance Labour",{"$f":"IF(ProjectData!$B$21=\"y\",DefaultData!I38,DefaultData!J38)","v":35.758725227757054},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saskatchewan",225,205,0,0,0,0,0,0,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yukon",210,140,0,0,0,0,0,0,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Canada",{"$f":"AVERAGE(AX30:AX42)","v":218.46153846153845},{"$f":"AVERAGE(AY30:AY42)","v":176.34615384615384},0,0,0,0,0,0,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10]
[]
[null,null,"Margins"]
[null,null,null,"Agriculture","Mining","Construction","Manufacturing","Machinery & Equipment","TCPU","Wholesale Trade","Retail Trade","FIRE","Misc. Services","Repair & Maintenance","Professional Services","Government","Total"]
[null,null,"Agriculture",0.96223913488966895,0,0,0,0,1.5312164404600849E-2,2.2448700705730174E-2,0,0,0,0,0,0,{"$f":"SUM(D48:P48)","v":0.99999999999999989}]
[null,null,"Mining",0,0.92690404568968099,0,0,0,6.2888915468109916E-2,1.0207038842209132E-2,0,0,0,0,0,0,1]
[null,null,"Construction",0,0,1,0,0,0,0,0,0,0,0,0,0,1]
[null,null,"Manufacturing",0,0,0,0.87695747075314934,0,3.2664288636960907E-2,9.0378240609889804E-2,0,0,0,0,0,0,1]
[null,null,"Machinery & Equipment",0,0,0,0,0.84417534741252431,8.1514870361477591E-3,0.1476731655513279,0,0,0,0,0,0,1]
[null,null,"TCPU",0,0,0,0,0,0.99998284935316217,7.8346524902031456E-6,0,0,0,0,0,0,0.99999068400565239]
[null,null,"Wholesale Trade",0,0,0,0,0,0,1,0,0,0,0,0,0,1]
[null,null,"Retail Trade",0,0,0,0,0,0,0,1,0,0,0,0,0,1]
[null,null,"FIRE",0,0,0,0,0,0,0,0,1,0,0,0,0,1]
[null,null,"Misc. Services",0,0,0,0,0,3.2954041707493862E-4,9.1750333822067064E-3,0,0,0.9904954262007184,0,0,0,1]
[null,null,"Repair & Maintenance",0,0,0,0,0,0,0,0,0,0,1,0,0,1]
[null,null,"Professional Services",0,0,0,0,0,7.596323454341429E-5,2.920144425367152E-3,0,0,0,0,0.99700389234008946,0,1]
[null,null,"Government",0,0,0,0,0,3.2252779744282687E-5,5.8527324581989133E-4,0,0,0,0,0,0.9993824739744358,1]
[]
[]
[]
[null,null,null,"Canada","Alberta","British Columbia","Manitoba","New Brunswick","Newfoundland and Labrador","Northwest Territories","Nova Scotia","Nunavut","Ontario","Prince Edward Island","Quebec","Saskatchewan","Yukon"]
[null,null,"Sales Tax",0.05,0,7.0000000000000007E-2,7.0000000000000007E-2,0.1,0.1,0,0.1,0,0.08,0.1,9.9750000000000005E-2,0.06,0]
[null,null,{"$f":"HLOOKUP(ProjectData!B9,DefaultData!D64:R65,2,FALSE)","v":0}]

{"sheet":"Calculations","index":7,"n_rows":138,"n_cols":37,"rows_kept":138,"cut":false,"hidden":false,"merged":[[39,12,39,23],[31,12,31,23],[0,0,16,1]]}
["*** WARNING ***\n\nThis Worksheet contains Data and Formulas that are an integral part of the EI2 model.  \nAlthough the data and formulas are available for review they must not be changed.\nAny changes to the data or formulas will impact the analysis and may invalidate the model results.\n\nTo view the data and formulas simply scroll over to the adjacent columns to the right.",null,"Economic Impact Analysis for ",{"$f":"CONCATENATE(ProjectData!B12,\" \",ProjectData!B11,\" installations\")","v":"12000 Cold climate air-source heat pump installations"},null,"in",{"$f":"ProjectData!B9","v":"Alberta"}]
[]
[]
[null,null,null,"Cost","Purchased Local",null,"Local $ Spending",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Installation Costs ","Cost","Local Share"]
[]
[null,null,"Equipment & Installation costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equipment & Installation costs"]
[null,null,{"$f":"DefaultData!C17","v":"Cold climate air-source heat pump"},{"$f":"IF(ProjectData!$B$21=\"y\",DefaultData!D17,ProjectData!B29)","v":120622656.00000001},{"$f":"IF(ProjectData!$B$21=\"y\",DefaultData!F17,ProjectData!E29)","v":1},null,{"$f":"D7*E7","v":120622656.00000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C7","v":"Cold climate air-source heat pump"},{"$f":"D7","v":120622656.00000001},1]
[null,null,"Labour",{"$f":"IF(ProjectData!$B$21=\"y\",DefaultData!D18,ProjectData!B30)","v":98691264},{"$f":"IF(ProjectData!$B$21=\"y\",DefaultData!F18,ProjectData!E30)","v":1},null,{"$f":"D8*E8","v":98691264},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Labour",98691264,1]
[null,null,"Subtotal All Costs (without sales tax)",{"$f":"D7+D8","v":219313920},{"$f":"IF(ProjectData!$B$21=\"y\",DefaultData!F19,ProjectData!E31)","v":1},null,{"$f":"D9*E9","v":219313920},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal All Costs (without sales tax)",219313920,1]
[null,null,"Sales Tax",{"$f":"IF(ProjectData!$B$21=\"Y\",DefaultData!D20,ProjectData!B32)","v":0},{"$f":"IF(ProjectData!$B$21=\"y\",DefaultData!F20,ProjectData!E32)","v":1},null,{"$f":"D10*E10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sales Tax",0,1]
[null,null,"TOTAL PROJECT COST",{"$f":"D9+D10","v":219313920},null,null,{"$f":"SUM(G7:G10)","v":438627840},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL PROJECT COST",{"$f":"D11","v":219313920}]
[]
[]
[]
[null,null,"Annual Maintenance Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local Economic Impacts - Summary Results"]
[null,null,"Maintenance Labour",{"$f":"IF(ProjectData!$B$21=\"y\",DefaultData!D27,ProjectData!B38)","v":2760000},{"$f":"IF(ProjectData!$B$21=\"y\",DefaultData!F27,ProjectData!E27)","v":1},null,{"$f":"D16*E16","v":2760000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Maintenance Costs",null,null,null,null,null,"Jobs","Earnings","Output","Value Added"]
[null,null,"Sales Tax ",{"$f":"IF(ProjectData!$B$21=\"y\",DefaultData!D28,ProjectData!B39)","v":0},{"$f":"IF(ProjectData!$B$21=\"y\",DefaultData!F28,ProjectData!E28)","v":1},null,{"$f":"SUM(G16:G16)","v":2760000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  During construction period"]
[null,null,"TOTAL",{"$f":"D16+D17","v":2760000},null,null,{"$f":"G11+G17","v":441387840},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variable Costs",null,null,null,null,"Direct Impacts",{"$f":"I45","v":1605.1634957560404},{"$f":"M45*G60","v":98.69126399999999},{"$f":"Q45*$G60","v":98.69126399999999},{"$f":"U45*$G60","v":55.332200467187555}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Personnel",null,null,null,null,"     Indirect Impacts",{"$f":"I34+I37+J57","v":734.6889450249239},{"$f":"M34+M37+N60","v":61.628760778370072},{"$f":"+Q34+Q37+R60","v":216.71100143867483},{"$f":"+U34+U37+V60","v":85.762582537175305}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maintenance labour",{"$f":"D16","v":2760000},{"$f":"E16","v":1},null,null,"     Induced Impacts",{"$f":"K57","v":257.79837846344691},{"$f":"O60","v":13.552003442589077},{"$f":"S60","v":53.352928263107302},{"$f":"W60","v":33.133231715593446}]
[null,null,null,"Demand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Personnel Subtotal",{"$f":"AC20","v":2760000},{"$f":"E17","v":1},null,null,"     Total Impacts (Direct, Indirect, Induced)",{"$f":"AH20+AH19+AH18","v":2597.6508192444112},{"$f":"AI20+AI19+AI18","v":173.87202822095912},{"$f":"AJ20+AJ19+AJ18","v":368.7551937017821},{"$f":"AK20+AK19+AK18","v":174.22801471995632}]
[null,null,null,"Installation","Maintenance"]
[null,null,"Agriculture",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"D18","v":2760000},null,null,null,"  During operating years (annual)"]
[null,null,"Mining",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Payroll Parameters","Base Wage per Hour","Annual Wage","Employer Payroll Costs"]
[null,null,"Construction",{"$f":"IF(DefaultData!AV30<=2,G8+0.3*G7,G8+G7)","v":134878060.80000001},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Installation Labour",{"$f":"IF(ProjectData!$B$21=\"y\",DefaultData!F37,ProjectData!B49)","v":27.727469804893161},{"$f":"AC25*40*52","v":57673.137194177776},{"$f":"IF(ProjectData!$B$21=\"y\",DefaultData!H37,ProjectData!D49)","v":0.33830000000000005},null,"Direct impact",{"$f":"L115","v":35.758725227757054},{"$f":"P117","v":2.0148000000000001},{"$f":"T117","v":2.0148000000000001},{"$f":"X117","v":2.0148000000000001}]
[null,null,"Manufacturing",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maintenance labour",{"$f":"IF(ProjectData!$B$21=\"y\",DefaultData!F38,ProjectData!B51)","v":27.727469804893161},{"$f":"AC26*40*52","v":57673.137194177776},{"$f":"IF(ProjectData!$B$21=\"y\",DefaultData!H38,ProjectData!D51)","v":0.33830000000000005},null,"     Indirect Impacts",{"$f":"(L137-AH25)+M137","v":3.3911657385211731},{"$f":"P138-AI25+Q138","v":0.22897019564274851},{"$f":"T138-AJ25+U138","v":0.85577085178713108},{"$f":"X138-AK25+Y138","v":0.4385825902944897}]
[null,null,"Machinery & Equipment",{"$f":"IF(DefaultData!AV30<=2,G7*0.7,0)","v":84435859.200000003},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,null,null,null,"     Induced Impacts",{"$f":"N137","v":2.3144594202880744},{"$f":"R138","v":0.12201339509486173},{"$f":"V138","v":0.47857890284854032},{"$f":"Z138","v":0.2973158705024308}]
[null,null,"TCPU",0,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,null,null,null,"     Total Impacts (Direct, Indirect, Induced)",{"$f":"SUM(AH25:AH27)","v":41.464350386566302},{"$f":"SUM(AI25:AI27)","v":2.3657835907376104},{"$f":"SUM(AJ25:AJ27)","v":3.3491497546356719},{"$f":"SUM(AK25:AK27)","v":2.7506984607969205}]
[null,null,"Wholesale Trade",0,0]
[null,null,"Retail Trade",0,0]
[null,null,"FIRE",0,0]
[null,null,"Misc. Services",0,0,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"In \",Deflators!E5,\" dollars\")","v":"In 2020 dollars"}]
[null,null,"Repair & Maintenance",0,0,null,null,"Eng. & Prof. Svcs.",{"$f":"I54*C60","v":0},{"$f":"I45-DefaultData!I40","v":326.51357120675357},null,"Eng. & Prof. Svcs.",{"$f":"M54*G60","v":0},{"$f":"M45-H45","v":0},null,"Eng. & Prof. Svcs.",{"$f":"Q54*G60","v":0},{"$f":"(Q57-Q45-Q33)*G60","v":84.435859199999996},null,"Eng. & Prof. Svcs.",{"$f":"U54*G60","v":0},{"$f":"(U57-U33-U45)*K60","v":0}]
[null,null,"Professional Services",0,0,null,null,"Other Sectors (not Construction)",{"$f":"((I57-I45)*G60)-I37-I33","v":12.023219968410984},null,null,"Other Sectors (not Construction)",{"$f":"((M57-M45)*G60)-M37-M33","v":0},null,null,"Other Sectors (not Construction)",{"$f":"(Q57-Q45)*G60-Q33-Q37","v":0},null,null,"Other Sectors (not Construction)",{"$f":"(U57-U45)*G60-U33-U37","v":0}]
[null,null,"Government",{"$f":"D10","v":0},0]
[null,null,"Total",{"$f":"SUM(D23:D35)","v":219313920},{"$f":"SUM(E23:E35)","v":0}]
[null,null,null,null,null,null,null,"Manufacturing Jobs",{"$f":"I46+I47","v":223.28837084191642},{"$f":"J46+J47","v":113.57787981461057},null,"Mfg W&S Earnings",{"$f":"(M46+M47)*$G60","v":20.160115775536738},null,null,"Mfg Output",{"$f":"(Q46+Q47)*$G60","v":84.43585920000001},{"$f":"(R46+R47)*$G60","v":29.003260121775043},null,"Mfg Output",{"$f":"(U46+U47)*$G60","v":34.104686433648837},{"$f":"(V46+V47)*$G60","v":15.093271126696733}]
[null,null,null,null,null,null,null,null,{"$f":"I39/ProjectData!$B12","v":1.8607364236826369E-2},{"$f":"J39/ProjectData!$B12","v":9.4648233178842144E-3},{"$f":"K39/ProjectData!$B12","v":7.0171568985617242E-3},{"$f":"L39/ProjectData!$B12","v":3.5089344453272303E-2},null,null,null,{"$f":"P39*G60","v":33.685499382659991},null,null,null,{"$f":"T39*G60","v":130.8761334620813},null,null,null,{"$f":"X39*G60","v":60.013622237535806}]
[null,null,"Year",{"$f":"ProjectData!B$17","v":2020},null,{"$f":"CONCATENATE(\"Convert to \",Deflators!E$4, \" dollars\")","v":"Convert to 2017 dollars"},{"$f":"Deflators!J$4","v":0.94890510948905105},null,{"$f":"SUM(I46:I49)","v":223.28837084191642},{"$f":"SUM(J46:J47)","v":113.57787981461057},{"$f":"SUM(K46:K47)","v":84.205882782740687},{"$f":"SUM(L46:L47)","v":421.07213343926765},19.130036867297633,8.6235162810432158,4.2107893315554907,31.964342479896338,80.121618218978114,27.521341721392375,16.54607181196943,124.18903175233991,32.362111214411307,14.322082091026097,10.26303947470606,56.947232780143466]
[null,null,"Construction Costs Local Demand ",null,null,{"$f":"SUM(F3:F39)","v":0},null,null,{"$f":"(M45*10^6)/I45","v":58342.122107270967},null,null,null,{"$f":"CONCATENATE(\"In $\",Deflators!E4)","v":"In $2017"}]
[null,null,null,"Demand",null,"Total","Adj Demand",null,"Jobs","Jobs","Jobs","Jobs","Earnings",null,null,null,"Output",null,null,null,"Value Added"]
[null,null,null,null,null,null,{"$f":"CONCATENATE(\"Millions of \",Deflators!E4, \" dollars\")","v":"Millions of 2017 dollars"},null,"Direct","Indirect","Induced","Total","Direct","Indirect","Induced","Total","Direct","Indirect","Induced","Total","Direct","Indirect","Induced","Total"]
[null,null,"Agriculture",{"$f":"D23","v":0},null,{"$f":"D43","v":0},{"$f":"F43*G$39/10^6","v":0},null,{"$f":"$G43*Multipliers!D8","v":0},{"$f":"$G43*Multipliers!E8","v":0},{"$f":"$G43*Multipliers!F8","v":0},{"$f":"I43+J43+K43","v":0},{"$f":"$G43*Multipliers!G8","v":0},{"$f":"$G43*Multipliers!H8","v":0},{"$f":"$G43*Multipliers!I8","v":0},{"$f":"M43+N43+O43","v":0},{"$f":"+$G43*Multipliers!J8","v":0},{"$f":"$G43*Multipliers!K8","v":0},{"$f":"$G43*Multipliers!L8","v":0},{"$f":"Q43+R43+S43","v":0},{"$f":"$G43*Multipliers!M8","v":0},{"$f":"$G43*Multipliers!N8","v":0},{"$f":"$G43*Multipliers!O8","v":0},{"$f":"U43+V43+W43","v":0}]
[null,null,"Mining",{"$f":"D24","v":0},null,{"$f":"D44","v":0},{"$f":"F44*G$39/10^6","v":0},null,{"$f":"$G44*Multipliers!D9","v":0},{"$f":"$G44*Multipliers!E9","v":0},{"$f":"$G44*Multipliers!F9","v":0},{"$f":"I44+J44+K44","v":0},{"$f":"$G44*Multipliers!G9","v":0},{"$f":"$G44*Multipliers!H9","v":0},{"$f":"$G44*Multipliers!I9","v":0},{"$f":"M44+N44+O44","v":0},{"$f":"+$G44*Multipliers!J9","v":0},{"$f":"$G44*Multipliers!K9","v":0},{"$f":"$G44*Multipliers!L9","v":0},{"$f":"Q44+R44+S44","v":0},{"$f":"$G44*Multipliers!M9","v":0},{"$f":"$G44*Multipliers!N9","v":0},{"$f":"$G44*Multipliers!O9","v":0},{"$f":"U44+V44+W44","v":0}]
[null,null,"Construction",134878060.80000001,null,134878060.80000001,127.98648105109488,{"$f":"G8*G39/10^6","v":93.648644671532836},{"$f":"$H45*Multipliers!D10+DefaultData!I40","v":1605.1634957560404},{"$f":"($G45*Multipliers!E10)+(H46*Multipliers!D10)","v":385.79947439998585},{"$f":"$G45*Multipliers!F10","v":173.59249568070624},2164.5554658367328,{"$f":"H45","v":93.648644671532836},{"$f":"(G45*Multipliers!H10)+(H46*Multipliers!G10)","v":30.726292845732942},{"$f":"$G45*Multipliers!I10","v":8.6487759789304945},133.02371349619628,{"$f":"(H45*Multipliers!J10)","v":93.648644671532836},{"$f":"G45*Multipliers!K10+H46*Multipliers!J10","v":97.995216607277158},{"$f":"$G45*Multipliers!L10","v":34.080794423095888},225.72465570190587,{"$f":"$G45*Multipliers!M10","v":52.505007742586727},{"$f":"$G45*Multipliers!N10","v":34.69635946706471},{"$f":"$G45*Multipliers!O10","v":21.177253394105239},108.37862060375667]
[null,null,"Manufacturing",0,null,0,0,{"$f":"G45-H45","v":34.337836379562049},{"$f":"$G46*Multipliers!D11","v":0},{"$f":"$G46*Multipliers!E11","v":0},{"$f":"$G46*Multipliers!F11","v":0},0,{"$f":"$G46*Multipliers!G11","v":0},{"$f":"$G46*Multipliers!H11","v":0},{"$f":"$G46*Multipliers!I11","v":0},0,{"$f":"+$G46*Multipliers!J11","v":0},{"$f":"$G46*Multipliers!K11","v":0},{"$f":"$G46*Multipliers!L11","v":0},0,{"$f":"$G46*Multipliers!M11","v":0},{"$f":"$G46*Multipliers!N11","v":0},{"$f":"$G46*Multipliers!O11","v":0},0]
[null,null,"Machinery & Equipment",84435859.200000003,null,84435859.200000003,80.121618218978114,null,{"$f":"$G47*Multipliers!D12","v":223.28837084191642},{"$f":"$G47*Multipliers!E12","v":113.57787981461057},{"$f":"$G47*Multipliers!F12","v":84.205882782740687},421.07213343926765,{"$f":"$G47*Multipliers!G12","v":19.130036867297633},{"$f":"$G47*Multipliers!H12","v":8.6235162810432158},{"$f":"$G47*Multipliers!I12","v":4.2107893315554907},31.964342479896338,{"$f":"+$G47*Multipliers!J12","v":80.121618218978114},{"$f":"$G47*Multipliers!K12","v":27.521341721392375},{"$f":"$G47*Multipliers!L12","v":16.54607181196943},124.18903175233991,{"$f":"$G47*Multipliers!M12","v":32.362111214411307},{"$f":"$G47*Multipliers!N12","v":14.322082091026097},{"$f":"$G47*Multipliers!O12","v":10.26303947470606},56.947232780143466]
[null,null,"TCPU",0,null,0,0,null,{"$f":"$G48*Multipliers!D13","v":0},{"$f":"$G48*Multipliers!E13","v":0},{"$f":"$G48*Multipliers!F13","v":0},0,{"$f":"$G48*Multipliers!G13","v":0},{"$f":"$G48*Multipliers!H13","v":0},{"$f":"$G48*Multipliers!I13","v":0},0,{"$f":"+$G48*Multipliers!J13","v":0},{"$f":"$G48*Multipliers!K13","v":0},{"$f":"$G48*Multipliers!L13","v":0},0,{"$f":"$G48*Multipliers!M13","v":0},{"$f":"$G48*Multipliers!N13","v":0},{"$f":"$G48*Multipliers!O13","v":0},0]
[null,null,"Wholesale Trade",0,null,0,0,null,{"$f":"$G49*Multipliers!D14","v":0},{"$f":"$G49*Multipliers!E14","v":0},{"$f":"$G49*Multipliers!F14","v":0},0,{"$f":"$G49*Multipliers!G14","v":0},{"$f":"$G49*Multipliers!H14","v":0},{"$f":"$G49*Multipliers!I14","v":0},0,{"$f":"+$G49*Multipliers!J14","v":0},{"$f":"$G49*Multipliers!K14","v":0},{"$f":"$G49*Multipliers!L14","v":0},0,{"$f":"$G49*Multipliers!M14","v":0},{"$f":"$G49*Multipliers!N14","v":0},{"$f":"$G49*Multipliers!O14","v":0},0]
[null,null,"Retail Trade",0,null,0,0,null,{"$f":"$G50*Multipliers!D15","v":0},{"$f":"$G50*Multipliers!E15","v":0},{"$f":"$G50*Multipliers!F15","v":0},0,{"$f":"$G50*Multipliers!G15","v":0},{"$f":"$G50*Multipliers!H15","v":0},{"$f":"$G50*Multipliers!I15","v":0},0,{"$f":"+$G50*Multipliers!J15","v":0},{"$f":"$G50*Multipliers!K15","v":0},{"$f":"$G50*Multipliers!L15","v":0},0,{"$f":"$G50*Multipliers!M15","v":0},{"$f":"$G50*Multipliers!N15","v":0},{"$f":"$G50*Multipliers!O15","v":0},0]
[null,null,"FIRE",0,null,0,0,null,{"$f":"$G51*Multipliers!D16","v":0},{"$f":"$G51*Multipliers!E16","v":0},{"$f":"$G51*Multipliers!F16","v":0},0,{"$f":"$G51*Multipliers!G16","v":0},{"$f":"$G51*Multipliers!H16","v":0},{"$f":"$G51*Multipliers!I16","v":0},0,{"$f":"+$G51*Multipliers!J16","v":0},{"$f":"$G51*Multipliers!K16","v":0},{"$f":"$G51*Multipliers!L16","v":0},0,{"$f":"$G51*Multipliers!M16","v":0},{"$f":"$G51*Multipliers!N16","v":0},{"$f":"$G51*Multipliers!O16","v":0},0]
[null,null,"Misc. Services",0,null,0,0,null,{"$f":"$G52*Multipliers!D17","v":0},{"$f":"$G52*Multipliers!E17","v":0},{"$f":"$G52*Multipliers!F17","v":0},0,{"$f":"$G52*Multipliers!G17","v":0},{"$f":"$G52*Multipliers!H17","v":0},{"$f":"$G52*Multipliers!I17","v":0},0,{"$f":"+$G52*Multipliers!J17","v":0},{"$f":"$G52*Multipliers!K17","v":0},{"$f":"$G52*Multipliers!L17","v":0},0,{"$f":"$G52*Multipliers!M17","v":0},{"$f":"$G52*Multipliers!N17","v":0},{"$f":"$G52*Multipliers!O17","v":0},0]
[null,null,"Repair & Maintenance",0,null,0,0,null,{"$f":"$G53*Multipliers!D18","v":0},{"$f":"$G53*Multipliers!E18","v":0},{"$f":"$G53*Multipliers!F18","v":0},0,{"$f":"$G53*Multipliers!G18","v":0},{"$f":"$G53*Multipliers!H18","v":0},{"$f":"$G53*Multipliers!I18","v":0},0,{"$f":"+$G53*Multipliers!J18","v":0},{"$f":"$G53*Multipliers!K18","v":0},{"$f":"$G53*Multipliers!L18","v":0},0,{"$f":"$G53*Multipliers!M18","v":0},{"$f":"$G53*Multipliers!N18","v":0},{"$f":"$G53*Multipliers!O18","v":0},0]
[null,null,"Professional Services",0,null,0,0,null,{"$f":"$G54*Multipliers!D19","v":0},{"$f":"$G54*Multipliers!E19","v":0},{"$f":"$G54*Multipliers!F19","v":0},0,{"$f":"$G54*Multipliers!G19","v":0},{"$f":"$G54*Multipliers!H19","v":0},{"$f":"$G54*Multipliers!I19","v":0},0,{"$f":"+$G54*Multipliers!J19","v":0},{"$f":"$G54*Multipliers!K19","v":0},{"$f":"$G54*Multipliers!L19","v":0},0,{"$f":"$G54*Multipliers!M19","v":0},{"$f":"$G54*Multipliers!N19","v":0},{"$f":"$G54*Multipliers!O19","v":0},0]
[null,null,"Government",0,null,0,0,null,{"$f":"$G55*Multipliers!D20","v":0},{"$f":"$G55*Multipliers!E20","v":0},{"$f":"$G55*Multipliers!F20","v":0},0,{"$f":"$G55*Multipliers!G20","v":0},{"$f":"$G55*Multipliers!H20","v":0},{"$f":"$G55*Multipliers!I20","v":0},0,{"$f":"+$G55*Multipliers!J20","v":0},{"$f":"$G55*Multipliers!K20","v":0},{"$f":"$G55*Multipliers!L20","v":0},0,{"$f":"$G55*Multipliers!M20","v":0},{"$f":"$G55*Multipliers!N20","v":0},{"$f":"$G55*Multipliers!O20","v":0},0]
[]
[null,null,"Total",{"$f":"SUM(D43:D56)","v":219313920},null,{"$f":"SUM(F43:F56)","v":219313920},{"$f":"SUM(G43:G56)","v":208.10809927007301},"Total",{"$f":"SUM(I43:I56)","v":1828.451866597957},499.37735421459644,257.79837846344691,2585.6275992760002,112.77868153883047,39.349809126776158,12.859565310485985,164.98805597609262,173.77026289051093,125.51655832866953,50.626866235065322,349.9136874542458,84.867118956998041,49.018441558090807,31.440292868811298,165.32585338390015]
[]
[null,null,null,null,null,"Inflator to",{"$f":"D39","v":2020},"Dollars",null,null,null,null,{"$f":"CONCATENATE(\"↓ Conversion of totals into \", G59,\" dollars ↓\")","v":"↓ Conversion of totals into 2020 dollars ↓"}]
[null,null,null,null,null,null,{"$f":"Deflators!J5","v":1.0538461538461539},null,null,null,null,null,{"$f":"M57*$G60","v":118.85137977553673},{"$f":"N57*$G60","v":41.468645002833334},13.552003442589077,173.87202822095915,183.1271232,132.27514223867482,53.352928263107302,368.7551937017821,89.436886900836399,51.657896103526468,33.133231715593446,174.22801471995632]
[]
[null,null,"Maintenance costs",null,null,null,null,"Gross incl benefits"]
[null,null,null,"Cost","Local Share","Empl Earnings","Local $ Spending","Empl Earnings","Govt Share","Health Ben, etc."]
[null,null,"Variable Costs"]
[null,null,"Personnel"]
[null,null,"Maintenance labour",{"$f":"IF(ProjectData!$B$21=\"y\",DefaultData!D27,ProjectData!B38)","v":2760000},{"$f":"IF(ProjectData!$B$21=\"y\",DefaultData!F27,ProjectData!E38)","v":1},{"$f":"D66*(1-DefaultData!K$32)","v":1826291.9999999998},{"$f":"E66*F66","v":1826291.9999999998},{"$f":"D66*(1-DefaultData!K$30)","v":2014800},{"$f":"D66*E66*DefaultData!K$30","v":745200},{"$f":"E66*D66*DefaultData!K$31","v":188508}]
[]
[]
[null,null,"  Subtotal",{"$f":"SUM(D66:D68)","v":2760000},null,{"$f":"SUM(F66:F68)","v":1826291.9999999998},{"$f":"SUM(G66:G68)","v":1826291.9999999998},{"$f":"SUM(H66:H68)","v":2014800},{"$f":"SUM(I66:I68)","v":745200},{"$f":"SUM(J66:J68)","v":188508},{"$f":"G69+I69+J69","v":2760000}]
[null,null,"Warranty/Maintenance Services"]
[null,null,"Total",{"$f":"D69+D70","v":2760000}]
[null,null,null,null,null,null,null,null,null,null,null,"Without Employees"]
[null,null,"Annual Operations and Maintenance Costs Local Demand - margined",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Deflators!E4","v":2017},"Dollars"]
[null,null,null,"Demand",null,null,"Total","Adj Demand - Million",null,null,null,"Jobs",null,null,null,"Earnings",null,null,null,"Output",null,null,null,"Value Added"]
[null,null,null,null,null,null,"w/o Plant Empl",{"$f":"Deflators!E4","v":2017},"Dollars",null,null,"Direct","Indirect","Induced","Total","Direct","Indirect","Induced","Total","Direct","Indirect","Induced","Total","Direct","Indirect","Induced","Total"]
[null,null,"Agriculture",{"$f":"MMULT(TRANSPOSE(DemandOM),MarginsAGR)","v":0},null,null,{"$f":"D76+E76+F76","v":0},{"$f":"G76*G$39/10^6","v":0},null,null,null,{"$f":"$H76*Multipliers!D8","v":0},{"$f":"$H76*Multipliers!E8","v":0},{"$f":"$H76*Multipliers!F8","v":0},{"$f":"L76+M76+N76","v":0},{"$f":"$H76*Multipliers!G8","v":0},{"$f":"$H76*Multipliers!H8","v":0},{"$f":"$H76*Multipliers!I8","v":0},{"$f":"P76+Q76+R76","v":0},{"$f":"$H76*Multipliers!J8","v":0},{"$f":"$H76*Multipliers!K8","v":0},{"$f":"$H76*Multipliers!L8","v":0},{"$f":"T76+U76+V76","v":0},{"$f":"$H76*Multipliers!M8","v":0},{"$f":"$H76*Multipliers!N8","v":0},{"$f":"$H76*Multipliers!O8","v":0},{"$f":"X76+Y76+Z76","v":0}]
[null,null,"Mining",{"$f":"MMULT(TRANSPOSE(DemandOM),MarginsMIN)","v":0},null,null,{"$f":"D77+E77+F77","v":0},{"$f":"G77*G$39/10^6","v":0},null,null,null,{"$f":"$H77*Multipliers!D9","v":0},{"$f":"$H77*Multipliers!E9","v":0},{"$f":"$H77*Multipliers!F9","v":0},{"$f":"L77+M77+N77","v":0},{"$f":"$H77*Multipliers!G9","v":0},{"$f":"$H77*Multipliers!H9","v":0},{"$f":"$H77*Multipliers!I9","v":0},{"$f":"P77+Q77+R77","v":0},{"$f":"$H77*Multipliers!J9","v":0},{"$f":"$H77*Multipliers!K9","v":0},{"$f":"$H77*Multipliers!L9","v":0},{"$f":"T77+U77+V77","v":0},{"$f":"$H77*Multipliers!M9","v":0},{"$f":"$H77*Multipliers!N9","v":0},{"$f":"$H77*Multipliers!O9","v":0},{"$f":"X77+Y77+Z77","v":0}]
[null,null,"Construction",{"$f":"MMULT(TRANSPOSE(DemandOM),MarginsCON)","v":0},null,null,0,0,null,null,null,{"$f":"$H78*Multipliers!D10","v":0},{"$f":"$H78*Multipliers!E10","v":0},{"$f":"$H78*Multipliers!F10","v":0},0,{"$f":"$H78*Multipliers!G10","v":0},{"$f":"$H78*Multipliers!H10","v":0},{"$f":"$H78*Multipliers!I10","v":0},0,{"$f":"$H78*Multipliers!J10","v":0},{"$f":"$H78*Multipliers!K10","v":0},{"$f":"$H78*Multipliers!L10","v":0},0,{"$f":"$H78*Multipliers!M10","v":0},{"$f":"$H78*Multipliers!N10","v":0},{"$f":"$H78*Multipliers!O10","v":0},0]
[null,null,"Manufacturing",{"$f":"MMULT(TRANSPOSE(DemandOM),MarginsMFG)","v":0},null,null,0,0,null,null,null,{"$f":"$H79*Multipliers!D11","v":0},{"$f":"$H79*Multipliers!E11","v":0},{"$f":"$H79*Multipliers!F11","v":0},0,{"$f":"$H79*Multipliers!G11","v":0},{"$f":"$H79*Multipliers!H11","v":0},{"$f":"$H79*Multipliers!I11","v":0},0,{"$f":"$H79*Multipliers!J11","v":0},{"$f":"$H79*Multipliers!K11","v":0},{"$f":"$H79*Multipliers!L11","v":0},0,{"$f":"$H79*Multipliers!M11","v":0},{"$f":"$H79*Multipliers!N11","v":0},{"$f":"$H79*Multipliers!O11","v":0},0]
[null,null,"Machinery & Equipment",{"$f":"MMULT(TRANSPOSE(DemandOM),MarginsMAC)","v":0},null,null,0,0,null,null,null,{"$f":"$H80*Multipliers!D12","v":0},{"$f":"$H80*Multipliers!E12","v":0},{"$f":"$H80*Multipliers!F12","v":0},0,{"$f":"$H80*Multipliers!G12","v":0},{"$f":"$H80*Multipliers!H12","v":0},{"$f":"$H80*Multipliers!I12","v":0},0,{"$f":"$H80*Multipliers!J12","v":0},{"$f":"$H80*Multipliers!K12","v":0},{"$f":"$H80*Multipliers!L12","v":0},0,{"$f":"$H80*Multipliers!M12","v":0},{"$f":"$H80*Multipliers!N12","v":0},{"$f":"$H80*Multipliers!O12","v":0},0]
[null,null,"TCPU",{"$f":"MMULT(TRANSPOSE(DemandOM),MarginsTCPU)","v":0},null,null,0,0,null,null,null,{"$f":"$H81*Multipliers!D13","v":0},{"$f":"$H81*Multipliers!E13","v":0},{"$f":"$H81*Multipliers!F13","v":0},0,{"$f":"$H81*Multipliers!G13","v":0},{"$f":"$H81*Multipliers!H13","v":0},{"$f":"$H81*Multipliers!I13","v":0},0,{"$f":"$H81*Multipliers!J13","v":0},{"$f":"$H81*Multipliers!K13","v":0},{"$f":"$H81*Multipliers!L13","v":0},0,{"$f":"$H81*Multipliers!M13","v":0},{"$f":"$H81*Multipliers!N13","v":0},{"$f":"$H81*Multipliers!O13","v":0},0]
[null,null,"Wholesale Trade",{"$f":"MMULT(TRANSPOSE(DemandOM),MarginsWHO)","v":0},null,null,0,0,null,null,null,{"$f":"$H82*Multipliers!D14","v":0},{"$f":"$H82*Multipliers!E14","v":0},{"$f":"$H82*Multipliers!F14","v":0},0,{"$f":"$H82*Multipliers!G14","v":0},{"$f":"$H82*Multipliers!H14","v":0},{"$f":"$H82*Multipliers!I14","v":0},0,{"$f":"$H82*Multipliers!J14","v":0},{"$f":"$H82*Multipliers!K14","v":0},{"$f":"$H82*Multipliers!L14","v":0},0,{"$f":"$H82*Multipliers!M14","v":0},{"$f":"$H82*Multipliers!N14","v":0},{"$f":"$H82*Multipliers!O14","v":0},0]
[null,null,"Retail Trade",{"$f":"MMULT(TRANSPOSE(DemandOM),MarginsRET)","v":0},null,null,0,0,null,null,null,{"$f":"$H83*Multipliers!D15","v":0},{"$f":"$H83*Multipliers!E15","v":0},{"$f":"$H83*Multipliers!F15","v":0},0,{"$f":"$H83*Multipliers!G15","v":0},{"$f":"$H83*Multipliers!H15","v":0},{"$f":"$H83*Multipliers!I15","v":0},0,{"$f":"$H83*Multipliers!J15","v":0},{"$f":"$H83*Multipliers!K15","v":0},{"$f":"$H83*Multipliers!L15","v":0},0,{"$f":"$H83*Multipliers!M15","v":0},{"$f":"$H83*Multipliers!N15","v":0},{"$f":"$H83*Multipliers!O15","v":0},0]
[null,null,"FIRE",{"$f":"MMULT(TRANSPOSE(DemandOM),MarginsFIRE)","v":0},null,null,0,0,null,null,null,{"$f":"$H84*Multipliers!D16","v":0},{"$f":"$H84*Multipliers!E16","v":0},{"$f":"$H84*Multipliers!F16","v":0},0,{"$f":"$H84*Multipliers!G16","v":0},{"$f":"$H84*Multipliers!H16","v":0},{"$f":"$H84*Multipliers!I16","v":0},0,{"$f":"$H84*Multipliers!J16","v":0},{"$f":"$H84*Multipliers!K16","v":0},{"$f":"$H84*Multipliers!L16","v":0},0,{"$f":"$H84*Multipliers!M16","v":0},{"$f":"$H84*Multipliers!N16","v":0},{"$f":"$H84*Multipliers!O16","v":0},0]
[null,null,"Misc. Services",{"$f":"MMULT(TRANSPOSE(DemandOM),MarginsOTH)","v":0},null,null,0,0,null,null,null,{"$f":"$H85*Multipliers!D17","v":0},{"$f":"$H85*Multipliers!E17","v":0},{"$f":"$H85*Multipliers!F17","v":0},0,{"$f":"$H85*Multipliers!G17","v":0},{"$f":"$H85*Multipliers!H17","v":0},{"$f":"$H85*Multipliers!I17","v":0},0,{"$f":"$H85*Multipliers!J17","v":0},{"$f":"$H85*Multipliers!K17","v":0},{"$f":"$H85*Multipliers!L17","v":0},0,{"$f":"$H85*Multipliers!M17","v":0},{"$f":"$H85*Multipliers!N17","v":0},{"$f":"$H85*Multipliers!O17","v":0},0]
[null,null,"Repair & Maintenance",{"$f":"MMULT(TRANSPOSE(DemandOM),MarginsREP)","v":0},null,null,0,0,null,null,null,{"$f":"$H86*Multipliers!D18","v":0},{"$f":"$H86*Multipliers!E18","v":0},{"$f":"$H86*Multipliers!F18","v":0},0,{"$f":"$H86*Multipliers!G18","v":0},{"$f":"$H86*Multipliers!H18","v":0},{"$f":"$H86*Multipliers!I18","v":0},0,{"$f":"$H86*Multipliers!J18","v":0},{"$f":"$H86*Multipliers!K18","v":0},{"$f":"$H86*Multipliers!L18","v":0},0,{"$f":"$H86*Multipliers!M18","v":0},{"$f":"$H86*Multipliers!N18","v":0},{"$f":"$H86*Multipliers!O18","v":0},0]
[null,null,"Professional Services",{"$f":"MMULT(TRANSPOSE(DemandOM),MarginsPRO)","v":0},null,null,0,0,null,null,null,{"$f":"$H87*Multipliers!D19","v":0},{"$f":"$H87*Multipliers!E19","v":0},{"$f":"$H87*Multipliers!F19","v":0},0,{"$f":"$H87*Multipliers!G19","v":0},{"$f":"$H87*Multipliers!H19","v":0},{"$f":"$H87*Multipliers!I19","v":0},0,{"$f":"$H87*Multipliers!J19","v":0},{"$f":"$H87*Multipliers!K19","v":0},{"$f":"$H87*Multipliers!L19","v":0},0,{"$f":"$H87*Multipliers!M19","v":0},{"$f":"$H87*Multipliers!N19","v":0},{"$f":"$H87*Multipliers!O19","v":0},0]
[null,null,"Government",{"$f":"MMULT(TRANSPOSE(DemandOM),MarginsGOV)","v":0},null,null,0,0,null,null,null,{"$f":"$H88*Multipliers!D20","v":0},{"$f":"$H88*Multipliers!E20","v":0},{"$f":"$H88*Multipliers!F20","v":0},0,{"$f":"$H88*Multipliers!G20","v":0},{"$f":"$H88*Multipliers!H20","v":0},{"$f":"$H88*Multipliers!I20","v":0},0,{"$f":"$H88*Multipliers!J20","v":0},{"$f":"$H88*Multipliers!K20","v":0},{"$f":"$H88*Multipliers!L20","v":0},0,{"$f":"$H88*Multipliers!M20","v":0},{"$f":"$H88*Multipliers!N20","v":0},{"$f":"$H88*Multipliers!O20","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"$H89*Multipliers!D21","v":0},{"$f":"$H89*Multipliers!E21","v":0},{"$f":"$H89*Multipliers!F21","v":0},0,{"$f":"$H89*Multipliers!G21","v":0},{"$f":"$H89*Multipliers!H21","v":0},{"$f":"$H89*Multipliers!I21","v":0},0,{"$f":"$H89*Multipliers!J21","v":0},{"$f":"$H89*Multipliers!K21","v":0},{"$f":"$H89*Multipliers!L21","v":0},0,{"$f":"$H89*Multipliers!M21","v":0},{"$f":"$H89*Multipliers!N21","v":0},{"$f":"$H89*Multipliers!O21","v":0},0]
[null,null,"Total",{"$f":"SUM(D76:D89)","v":0},null,null,{"$f":"SUM(G76:G89)","v":0},{"$f":"SUM(H76:H89)","v":0},null,null,"Total",{"$f":"SUM(L76:L89)","v":0},{"$f":"SUM(M76:M89)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"Earnings - Gross ",null,{"$f":"K69","v":2760000}]
[null,null,null,null,"Employee - (SSI, Medicare, etc.)",{"$f":"DefaultData!K30","v":0.27},{"$f":"F93*G$92","v":745200},0,null,null,null,null,null,null,null,"Inflate to",{"$f":"D39","v":2020},"Dollars"]
[null,null,null,null,"Other benefits",{"$f":"DefaultData!K31","v":6.83E-2},{"$f":"F94*G$92","v":188508},{"$f":"IF(ProjectData!B9=\"MyRegion\",0,1)","v":1},null,"Without  Employees",null,{"$f":"L90","v":0},{"$f":"M90","v":0},{"$f":"N90","v":0},{"$f":"O90","v":0},{"$f":"P90*$G60","v":0},{"$f":"Q90*$G60","v":0},{"$f":"R90*$G60","v":0},{"$f":"P94+Q94+R94","v":0},{"$f":"T90*$G60","v":0},0,0,0,0,0,0,0]
[null,null,null,null,"Earnings (minus taxes, benefits, etc)",null,{"$f":"G92-G93-G94","v":1826292},null,null,"With  Employees",null,{"$f":"L94+L115","v":35.758725227757054},{"$f":"M94+M115","v":3.3911657385211731},{"$f":"N94+N115","v":2.3144594202880744},{"$f":"O94+O115","v":41.464350386566302},{"$f":"(P90+P115)*$G60","v":2.0148000000000001},0.22897019564274851,0.12201339509486173,2.3657835907376104,2.0148000000000001,0.85577085178713108,0.47857890284854032,3.3491497546356714,2.0148000000000001,0.4385825902944897,0.2973158705024308,2.7506984607969205]
[]
[null,null,"Employees - Maintenance",{"$f":"DefaultData!I41","v":35.758725227757054}]
[null,null,null,null,null,null,null,null,null,null,null,"Employees Only"]
[null,null,"Employee Spending",null,null,"PCE ",null,"Adj Demand - Million",null,null,null,"Jobs",null,null,null,"Earnings",null,null,null,"Output",null,null,null,"Value Added"]
[null,null,null,null,null,"Emp",null,{"$f":"H75","v":2017},"Dollars",null,null,"Direct","Indirect","Induced","Total","Direct","Indirect","Induced","Total","Direct","Indirect","Induced","Total","Direct","Indirect","Induced","Total"]
[null,null,"Agriculture",null,null,{"$f":"G$95*Multipliers!D25","v":23425.393474215925},null,{"$f":"F101*G$39/10^6","v":2.2228475559474967E-2},null,null,null,null,{"$f":"$H101*Multipliers!E8","v":4.390218606659526E-2},{"$f":"$H101*Multipliers!F8","v":1.1468540540182252E-2},{"$f":"M101+N101","v":5.5370726606777512E-2},null,{"$f":"$H101*Multipliers!H8","v":2.6398532238457767E-3},{"$f":"$H101*Multipliers!I8","v":5.8180029384694173E-4},{"$f":"Q101+R101","v":3.2216535176927182E-3},{"$f":"$H101*Multipliers!J8","v":2.2228475559474967E-2},{"$f":"$H101*Multipliers!K8","v":1.3059663178443686E-2},{"$f":"$H101*Multipliers!L8","v":2.2683313612546362E-3},{"$f":"T101+U101+V101","v":3.7556470099173289E-2},null,{"$f":"$H101*Multipliers!N8","v":5.771725796405178E-3},{"$f":"$H101*Multipliers!O8","v":1.4030730722452277E-3},{"$f":"Y101+Z101","v":7.1747988686504055E-3}]
[null,null,"Mining",null,null,{"$f":"G$95*Multipliers!D26","v":5835.9368325701098},null,{"$f":"F102*G$39/10^6","v":5.5377502790811255E-3},null,null,null,null,{"$f":"$H102*Multipliers!E9","v":9.1981184005500566E-3},{"$f":"$H102*Multipliers!F9","v":4.4592080303403562E-3},{"$f":"M102+N102","v":1.3657326430890413E-2},null,{"$f":"$H102*Multipliers!H9","v":7.5988953897844047E-4},{"$f":"$H102*Multipliers!I9","v":2.228301028680935E-4},{"$f":"Q102+R102","v":9.8271964184653399E-4},{"$f":"$H102*Multipliers!J9","v":5.5377502790811255E-3},{"$f":"$H102*Multipliers!K9","v":2.3122232230660201E-3},{"$f":"$H102*Multipliers!L9","v":8.7844558899831957E-4},{"$f":"T102+U102+V102","v":8.7284190911454656E-3},null,{"$f":"$H102*Multipliers!N9","v":1.2937919370053584E-3},{"$f":"$H102*Multipliers!O9","v":5.4345792460186134E-4},{"$f":"Y102+Z102","v":1.8372498616072196E-3}]
[null,null,"Construction",null,null,{"$f":"G$95*Multipliers!D27","v":998.43355650805847},null,9.4741870325582185E-4,null,null,null,null,{"$f":"$H103*Multipliers!E10","v":1.9696386066107986E-3},{"$f":"$H103*Multipliers!F10","v":1.2850167908522994E-3},3.254655397463098E-3,null,{"$f":"$H103*Multipliers!H10","v":1.525756451231854E-4},{"$f":"$H103*Multipliers!I10","v":6.402248155754207E-5},2.1659812668072746E-4,{"$f":"$H103*Multipliers!J10","v":9.4741870325582185E-4},{"$f":"$H103*Multipliers!K10","v":4.7122314898186433E-4},{"$f":"$H103*Multipliers!L10","v":2.5228275512448377E-4},1.67092460736217E-3,null,{"$f":"$H103*Multipliers!N10","v":2.5683946948163317E-4},{"$f":"$H103*Multipliers!O10","v":1.567644159319708E-4},4.13603885413604E-4]
[null,null,"Manufacturing",null,null,{"$f":"G$95*Multipliers!D28","v":348052.0111590327},null,0.33026833175674636,null,null,null,null,{"$f":"$H104*Multipliers!E11","v":0.72004303918426649},{"$f":"$H104*Multipliers!F11","v":0.24986717107792655},0.96991021026219304,null,{"$f":"$H104*Multipliers!H11","v":4.8150995684238258E-2},{"$f":"$H104*Multipliers!I11","v":1.2443083260781701E-2},6.0594078945019961E-2,{"$f":"$H104*Multipliers!J11","v":0.33026833175674636},{"$f":"$H104*Multipliers!K11","v":0.26400459002488669},{"$f":"$H104*Multipliers!L11","v":4.9170473200994588E-2},0.64344339498262759,null,{"$f":"$H104*Multipliers!N11","v":0.11555861785522506},{"$f":"$H104*Multipliers!O11","v":3.0541304610933451E-2},0.14609992246615852]
[null,null,"Machinery & Equipment",null,null,{"$f":"G$95*Multipliers!D29","v":12843.015557224693},null,1.2186803083497883E-2,null,null,null,null,{"$f":"$H105*Multipliers!E12","v":1.7275627810697278E-2},{"$f":"$H105*Multipliers!F12","v":1.2808035268842001E-2},3.0083663079539281E-2,null,{"$f":"$H105*Multipliers!H12","v":1.3116696484734584E-3},{"$f":"$H105*Multipliers!I12","v":6.4047708409370842E-4},1.9521467325671667E-3,{"$f":"$H105*Multipliers!J12","v":1.2186803083497883E-2},{"$f":"$H105*Multipliers!K12","v":4.1861008253178192E-3},{"$f":"$H105*Multipliers!L12","v":2.516720498914285E-3},1.8889624407729989E-2,null,{"$f":"$H105*Multipliers!N12","v":2.178443197589885E-3},{"$f":"$H105*Multipliers!O12","v":1.5610473664495032E-3},3.7394905640393879E-3]
[null,null,"TCPU",null,null,{"$f":"G$95*Multipliers!D30","v":85104.958451227489},null,8.0756529917223166E-2,null,null,null,null,{"$f":"$H106*Multipliers!E13","v":0.13220215669891516},{"$f":"$H106*Multipliers!F13","v":9.2138940844281647E-2},0.22434109754319681,null,{"$f":"$H106*Multipliers!H13","v":9.6387081513610931E-3},{"$f":"$H106*Multipliers!I13","v":4.5985935534056969E-3},1.4237301704766791E-2,{"$f":"$H106*Multipliers!J13","v":8.0756529917223166E-2},{"$f":"$H106*Multipliers!K13","v":3.6718846356185789E-2},{"$f":"$H106*Multipliers!L13","v":1.8091277605731922E-2},0.13556665387914088,null,{"$f":"$H106*Multipliers!N13","v":1.7838866763759492E-2},{"$f":"$H106*Multipliers!O13","v":1.1219808958880587E-2},2.9058675722640079E-2]
[null,null,"Wholesale Trade",null,null,{"$f":"G$95*Multipliers!D31","v":72152.111670747065},null,6.8465507424796485E-2,null,null,null,null,{"$f":"$H107*Multipliers!E14","v":0.10494575867720675},{"$f":"$H107*Multipliers!F14","v":0.10273177354057675},0.20767753221778351,null,{"$f":"$H107*Multipliers!H14","v":7.1562386605854263E-3},{"$f":"$H107*Multipliers!I14","v":5.1348748221096471E-3},1.2291113482695074E-2,{"$f":"$H107*Multipliers!J14","v":6.8465507424796485E-2},{"$f":"$H107*Multipliers!K14","v":2.4043568318768801E-2},{"$f":"$H107*Multipliers!L14","v":2.0151097304308852E-2},0.11266017304787414,null,{"$f":"$H107*Multipliers!N14","v":1.3235391734737442E-2},{"$f":"$H107*Multipliers!O14","v":1.2518820862870693E-2},2.5754212597608135E-2]
[null,null,"Retail Trade",null,null,{"$f":"G$95*Multipliers!D32","v":230132.90952243592},null,0.21837429370742092,null,null,null,null,{"$f":"$H108*Multipliers!E15","v":0.3881315139476586},{"$f":"$H108*Multipliers!F15","v":0.35325138945029622},0.74138290339795487,null,{"$f":"$H108*Multipliers!H15","v":2.541603691236053E-2},{"$f":"$H108*Multipliers!I15","v":1.7646897516196344E-2},4.3062934428556875E-2,{"$f":"$H108*Multipliers!J15","v":0.21837429370742092},{"$f":"$H108*Multipliers!K15","v":8.9472528682956742E-2},{"$f":"$H108*Multipliers!L15","v":6.9282107900806425E-2},0.37712893029118405,null,{"$f":"$H108*Multipliers!N15","v":5.0829248238189115E-2},{"$f":"$H108*Multipliers!O15","v":4.3054791542576319E-2},9.3884039780765427E-2]
[null,null,"FIRE",null,null,{"$f":"G$95*Multipliers!D33","v":259995.21858983565},null,0.24671079136261778,null,null,null,null,{"$f":"$H109*Multipliers!E16","v":0.55772714675946011},{"$f":"$H109*Multipliers!F16","v":0.2653796024995268},0.82310674925898697,null,{"$f":"$H109*Multipliers!H16","v":3.7456003529397812E-2},{"$f":"$H109*Multipliers!I16","v":1.3293581741942463E-2},5.0749585271340276E-2,{"$f":"$H109*Multipliers!J16","v":0.24671079136261778},{"$f":"$H109*Multipliers!K16","v":0.11304047234193872},{"$f":"$H109*Multipliers!L16","v":5.2059464591605542E-2},0.41181072829616205,null,{"$f":"$H109*Multipliers!N16","v":6.1704475542394152E-2},{"$f":"$H109*Multipliers!O16","v":3.2378979529661844E-2},9.4083455072055996E-2]
[null,null,"Misc. Services",null,null,{"$f":"G$95*Multipliers!D34","v":722378.66122786782},null,0.68546880262498411,null,null,null,null,{"$f":"$H110*Multipliers!E17","v":0.99363723826646311},{"$f":"$H110*Multipliers!F17","v":0.85307887030535023},1.8467161085718133,null,{"$f":"$H110*Multipliers!H17","v":5.8074431763070387E-2},{"$f":"$H110*Multipliers!I17","v":4.2732488871709641E-2},0.10080692063478003,{"$f":"$H110*Multipliers!J17","v":0.68546880262498411},{"$f":"$H110*Multipliers!K17","v":0.1769296965887249},{"$f":"$H110*Multipliers!L17","v":0.1673304879235438},1.0297289871372528,null,{"$f":"$H110*Multipliers!N17","v":9.7669930150070888E-2},{"$f":"$H110*Multipliers!O17","v":0.10393327230437206},0.20160320245444296]
[null,null,"Repair & Maintenance",null,null,{"$f":"G$95*Multipliers!D35+(G94*H94)","v":196785.63912079687},null,0.18673089843579266,null,null,null,null,{"$f":"$H111*Multipliers!E18","v":0.29316751054419449},{"$f":"$H111*Multipliers!F18","v":0.28681865999737755},0.57998617054157209,null,{"$f":"$H111*Multipliers!H18","v":1.8299628046707681E-2},{"$f":"$H111*Multipliers!I18","v":1.4378279179556034E-2},3.2677907226263715E-2,{"$f":"$H111*Multipliers!J18","v":0.18673089843579266},{"$f":"$H111*Multipliers!K18","v":6.4048698163476886E-2},{"$f":"$H111*Multipliers!L18","v":5.6206000429173592E-2},0.30698559702844308,null,{"$f":"$H111*Multipliers!N18","v":3.5478870702800612E-2},{"$f":"$H111*Multipliers!O18","v":3.4918678007493223E-2},7.0397548710293828E-2]
[null,null,"Professional Services",null,null,{"$f":"G$95*Multipliers!D36","v":25901.285634620865},null,2.4577862281027096E-2,null,null,null,null,{"$f":"$H112*Multipliers!E19","v":4.4680409130551511E-2},{"$f":"$H112*Multipliers!F19","v":3.7466268417628713E-2},8.2146677548180225E-2,null,{"$f":"$H112*Multipliers!H19","v":2.7537881930774846E-3},{"$f":"$H112*Multipliers!I19","v":1.8696085293418449E-3},4.6233967224193293E-3,{"$f":"$H112*Multipliers!J19","v":2.4577862281027096E-2},{"$f":"$H112*Multipliers!K19","v":8.6973744616986905E-3},{"$f":"$H112*Multipliers!L19","v":7.3476777659911693E-3},4.0622914508716954E-2,null,{"$f":"$H112*Multipliers!N19","v":4.9493821378756393E-3},{"$f":"$H112*Multipliers!O19","v":4.571578802869407E-3},9.5209609407450463E-3]
[null,null,"Government",null,null,{"$f":"G$95*Multipliers!D37","v":31194.425202916769},null,2.960054946262175E-2,null,null,null,null,{"$f":"$H113*Multipliers!E20","v":8.428539442800359E-2},{"$f":"$H113*Multipliers!F20","v":4.3705943524892966E-2},0.12799133795289655,null,{"$f":"$H113*Multipliers!H20","v":5.4611695688921739E-3},{"$f":"$H113*Multipliers!I20","v":2.1725965942109675E-3},7.6337661631031414E-3,{"$f":"$H113*Multipliers!J20","v":2.960054946262175E-2},{"$f":"$H113*Multipliers!K20","v":1.5060348498159452E-2},{"$f":"$H113*Multipliers!L20","v":8.5715992801964746E-3},5.3232497240977679E-2,null,{"$f":"$H113*Multipliers!N20","v":9.4076773378499144E-3},{"$f":"$H113*Multipliers!O20","v":5.3229712530555575E-3},1.4730648590905473E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$H114*Multipliers!E21","v":0},{"$f":"$H114*Multipliers!F21","v":0},0,null,{"$f":"$H114*Multipliers!H21","v":0},{"$f":"$H114*Multipliers!I21","v":0},0,{"$f":"$H114*Multipliers!J21","v":0},{"$f":"$H114*Multipliers!K21","v":0},{"$f":"$H114*Multipliers!L21","v":0},0,null,{"$f":"$H114*Multipliers!N21","v":0},{"$f":"$H114*Multipliers!O21","v":0},0]
[null,null,"Total",null,null,{"$f":"SUM(F101:F114)","v":2014800},null,{"$f":"SUM(H101:H114)","v":1.9118540145985401},null,null,null,{"$f":"IF(L117=0,0,D97)","v":35.758725227757054},{"$f":"SUM(M101:M114)","v":3.3911657385211731},{"$f":"SUM(N101:N114)","v":2.3144594202880744},{"$f":"L115+M115+N115","v":41.464350386566302},{"$f":"H115","v":1.9118540145985401},{"$f":"SUM(Q101:Q114)","v":0.21727098856611171},{"$f":"SUM(R101:R114)","v":0.11577913403162061},{"$f":"R115+Q115+P115","v":2.2449041371962726},{"$f":"SUM(T101:T114)","v":1.9118540145985401},{"$f":"SUM(U101:U114)","v":0.81204533381260613},{"$f":"SUM(V101:V114)","v":0.45412596620664408},{"$f":"T115+U115+V115","v":3.1780253146177904},{"$f":"P115","v":1.9118540145985401},{"$f":"SUM(Y101:Y114)","v":0.41617326086338435},{"$f":"SUM(Z101:Z114)","v":0.28212454865194164},{"$f":"X115+Y115+Z115","v":2.6101518241138661}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inflate to",{"$f":"Q93","v":2020},"Dollars"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M122:M135)","v":3.3911657385211731},null,null,null,{"$f":"P115*$G60","v":2.0148000000000001},0.22897019564274851,0.12201339509486173,2.3657835907376104,2.0148000000000001,0.85577085178713108,0.47857890284854032,3.3491497546356714,2.0148000000000001,0.4385825902944897,0.2973158705024308,2.7506984607969205]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total Maintenance"]
[null,null,null,null,null,null,null,null,null,null,null,"Jobs",null,null,null,"Earnings",null,null,null,"Output",null,null,null,"Value Added"]
[null,null,null,null,null,null,null,null,null,null,null,"Direct","Indirect","Induced","Total","Direct","Indirect","Induced","Total","Direct","Indirect","Induced","Total","Direct","Indirect","Induced","Total"]
[null,null,null,null,null,null,null,null,null,"Agriculture",null,{"$f":"L76+L101","v":0},4.390218606659526E-2,1.1468540540182252E-2,{"$f":"L122+M122+N122","v":5.5370726606777512E-2},{"$f":"P76+P101","v":0},2.6398532238457767E-3,5.8180029384694173E-4,{"$f":"P122+Q122+R122","v":3.2216535176927182E-3},{"$f":"T76+T101","v":2.2228475559474967E-2},1.3059663178443686E-2,2.2683313612546362E-3,{"$f":"T122+U122+V122","v":3.7556470099173289E-2},{"$f":"X76+X101","v":0},5.771725796405178E-3,1.4030730722452277E-3,{"$f":"X122+Y122+Z122","v":7.1747988686504055E-3}]
[null,null,null,null,null,null,null,null,null,"Mining",null,0,9.1981184005500566E-3,4.4592080303403562E-3,{"$f":"L123+M123+N123","v":1.3657326430890413E-2},0,7.5988953897844047E-4,2.228301028680935E-4,{"$f":"P123+Q123+R123","v":9.8271964184653399E-4},5.5377502790811255E-3,2.3122232230660201E-3,8.7844558899831957E-4,{"$f":"T123+U123+V123","v":8.7284190911454656E-3},0,1.2937919370053584E-3,5.4345792460186134E-4,{"$f":"X123+Y123+Z123","v":1.8372498616072196E-3}]
[null,null,null,null,null,null,null,null,null,"Construction",null,0,1.9696386066107986E-3,1.2850167908522994E-3,3.254655397463098E-3,0,1.525756451231854E-4,6.402248155754207E-5,2.1659812668072746E-4,9.4741870325582185E-4,4.7122314898186433E-4,2.5228275512448377E-4,1.67092460736217E-3,0,2.5683946948163317E-4,1.567644159319708E-4,4.13603885413604E-4]
[null,null,null,null,null,null,null,null,null,"Manufacturing",null,0,0.72004303918426649,0.24986717107792655,0.96991021026219304,0,4.8150995684238258E-2,1.2443083260781701E-2,6.0594078945019961E-2,0.33026833175674636,0.26400459002488669,4.9170473200994588E-2,0.64344339498262759,0,0.11555861785522506,3.0541304610933451E-2,0.14609992246615852]
[null,null,null,null,null,null,null,null,null,"Fabricated Metals",null,0,1.7275627810697278E-2,1.2808035268842001E-2,3.0083663079539281E-2,0,1.3116696484734584E-3,6.4047708409370842E-4,1.9521467325671667E-3,1.2186803083497883E-2,4.1861008253178192E-3,2.516720498914285E-3,1.8889624407729989E-2,0,2.178443197589885E-3,1.5610473664495032E-3,3.7394905640393879E-3]
[null,null,null,null,null,null,null,null,null,"Machinery & Equipment",null,0,0.13220215669891516,9.2138940844281647E-2,0.22434109754319681,0,9.6387081513610931E-3,4.5985935534056969E-3,1.4237301704766791E-2,8.0756529917223166E-2,3.6718846356185789E-2,1.8091277605731922E-2,0.13556665387914088,0,1.7838866763759492E-2,1.1219808958880587E-2,2.9058675722640079E-2]
[null,null,null,null,null,null,null,null,null,"Electrical Equipment",null,0,0.10494575867720675,0.10273177354057675,0.20767753221778351,0,7.1562386605854263E-3,5.1348748221096471E-3,1.2291113482695074E-2,6.8465507424796485E-2,2.4043568318768801E-2,2.0151097304308852E-2,0.11266017304787414,0,1.3235391734737442E-2,1.2518820862870693E-2,2.5754212597608135E-2]
[null,null,null,null,null,null,null,null,null,"TCPU",null,0,0.3881315139476586,0.35325138945029622,0.74138290339795487,0,2.541603691236053E-2,1.7646897516196344E-2,4.3062934428556875E-2,0.21837429370742092,8.9472528682956742E-2,6.9282107900806425E-2,0.37712893029118405,0,5.0829248238189115E-2,4.3054791542576319E-2,9.3884039780765427E-2]
[null,null,null,null,null,null,null,null,null,"Wholesale Trade",null,0,0.55772714675946011,0.2653796024995268,0.82310674925898697,0,3.7456003529397812E-2,1.3293581741942463E-2,5.0749585271340276E-2,0.24671079136261778,0.11304047234193872,5.2059464591605542E-2,0.41181072829616205,0,6.1704475542394152E-2,3.2378979529661844E-2,9.4083455072055996E-2]
[null,null,null,null,null,null,null,null,null,"Retail Trade",null,0,0.99363723826646311,0.85307887030535023,1.8467161085718133,0,5.8074431763070387E-2,4.2732488871709641E-2,0.10080692063478003,0.68546880262498411,0.1769296965887249,0.1673304879235438,1.0297289871372528,0,9.7669930150070888E-2,0.10393327230437206,0.20160320245444296]
[null,null,null,null,null,null,null,null,null,"FIRE",null,0,0.29316751054419449,0.28681865999737755,0.57998617054157209,0,1.8299628046707681E-2,1.4378279179556034E-2,3.2677907226263715E-2,0.18673089843579266,6.4048698163476886E-2,5.6206000429173592E-2,0.30698559702844308,0,3.5478870702800612E-2,3.4918678007493223E-2,7.0397548710293828E-2]
[null,null,null,null,null,null,null,null,null,"Misc. Services",null,0,4.4680409130551511E-2,3.7466268417628713E-2,8.2146677548180225E-2,0,2.7537881930774846E-3,1.8696085293418449E-3,4.6233967224193293E-3,2.4577862281027096E-2,8.6973744616986905E-3,7.3476777659911693E-3,4.0622914508716954E-2,0,4.9493821378756393E-3,4.571578802869407E-3,9.5209609407450463E-3]
[null,null,null,null,null,null,null,null,null,"Professional Services",null,0,8.428539442800359E-2,4.3705943524892966E-2,0.12799133795289655,0,5.4611695688921739E-3,2.1725965942109675E-3,7.6337661631031414E-3,2.960054946262175E-2,1.5060348498159452E-2,8.5715992801964746E-3,5.3232497240977679E-2,0,9.4076773378499144E-3,5.3229712530555575E-3,1.4730648590905473E-2]
[null,null,null,null,null,null,null,null,null,"Government",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"Plant Employees",null,{"$f":"L115","v":35.758725227757054},null,null,35.758725227757054,{"$f":"P115","v":1.9118540145985401},null,null,1.9118540145985401,null,null,null,0,{"$f":"X115","v":1.9118540145985401},null,null,1.9118540145985401]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(L122:L136)","v":35.758725227757054},{"$f":"SUM(M122:M135)","v":3.3911657385211731},{"$f":"SUM(N122:N135)","v":2.3144594202880744},{"$f":"SUM(O122:O136)","v":41.464350386566302},1.9118540145985401,0.21727098856611171,0.11577913403162061,2.2449041371962726,1.9118540145985401,0.81204533381260613,0.45412596620664408,3.1780253146177904,1.9118540145985401,0.41617326086338435,0.28212454865194164,2.6101518241138661]
[null,null,null,null,null,null,null,null,null,"Inflate to ",{"$f":"Q116","v":2020},"Dollars",null,null,null,{"$f":"P137*$G60","v":2.0148000000000001},0.22897019564274851,0.12201339509486173,2.3657835907376104,2.0148000000000001,0.85577085178713108,0.47857890284854032,3.3491497546356714,2.0148000000000001,0.4385825902944897,0.2973158705024308,2.7506984607969205]

{"sheet":"Deflators","index":8,"n_rows":60,"n_cols":49,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,0,16,1]]}
["*** WARNING ***\n\nThis Worksheet contains Data and Formulas that are an integral part of the EI2 model.  \nAlthough the data and formulas are available for review they must not be changed.\nAny changes to the data or formulas will impact the analysis and may invalidate the model results.\n\nTo view the data and formulas simply scroll over to the adjacent columns to the right.",null,"Deflators / Inflators"]
[null,null,"To assure consistency with multiplier data and project data"]
[]
[null,null,"Year of Multiplier Data",null,2017,null,null,null,"Deflator",{"$f":"HLOOKUP($E$5,D9:AW51,$D$60)","v":0.94890510948905105}]
[null,null,"Dollar Year $",null,{"$f":"ProjectData!B17","v":2020},null,null,null,"Inflator",{"$f":"HLOOKUP($E$5,D9:AW51,$D$59)","v":1.0538461538461539}]
[]
[]
[]
[null,null,null,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050]
[null,null,2005,1,1.0186915887850467,1.0467289719626169,1.0654205607476634,1.0654205607476634,1.0934579439252334,1.1214953271028036,1.1401869158878504,1.1495327102803738,1.1682242990654206,1.1869158878504673,1.1962616822429906,1.2149532710280373,1.2429906542056075,1.2710280373831775,1.280373831775701,1.2990654205607475,1.3271028037383177,1.3457943925233644,1.3738317757009344,1.3925233644859811,1.4205607476635513,1.4485981308411215,1.485981308411215,1.514018691588785,1.5514018691588782,1.5794392523364484,1.6168224299065419,1.6542056074766354,1.6822429906542056,1.719626168224299,1.7570093457943923,1.7943925233644857,1.8224299065420559,1.8598130841121494,1.8971962616822426,1.9345794392523361,1.9813084112149533,2.018691588785047,2.0560747663551404,2.1028037383177569,2.1495327102803734,2.1869158878504669,2.2336448598130842,2.2803738317757007,2.3364485981308412]
[null,null,null,1,0.98165137614678899,0.95535714285714279,0.93859649122807032,0.93859649122807032,0.91452991452991461,0.89166666666666672,0.87704918032786894,0.86991869918699194,0.85600000000000009,0.84251968503937014,0.8359375,0.82307692307692315,0.80451127819548873,0.78676470588235292,0.78102189781021891,0.7697841726618706,0.75352112676056349,0.74305555555555558,0.72789115646258506,0.71812080536912759,0.70394736842105265,0.69032258064516128,0.67295597484276726,0.66049382716049387,0.64457831325301207,0.63313609467455623,0.61849710982658967,0.60451977401129942,0.59444444444444444,0.58152173913043481,0.56914893617021278,0.55729166666666674,0.54871794871794877,0.53768844221105527,0.52709359605911343,0.51690821256038655,0.50471698113207553,0.49537037037037035,0.48636363636363633,0.47555555555555556,0.46521739130434792,0.45726495726495731,0.44769874476987448,0.43852459016393447,0.42800000000000005]
[null,null,2006,0.98165137614678899,1,1.0275229357798166,1.0458715596330272,1.0458715596330272,1.0733944954128438,1.1009174311926604,1.1192660550458715,1.128440366972477,1.1467889908256881,1.165137614678899,1.1743119266055044,1.1926605504587156,1.2201834862385321,1.2477064220183487,1.2568807339449541,1.275229357798165,1.3027522935779814,1.3211009174311925,1.3486238532110091,1.36697247706422,1.3944954128440366,1.4220183486238531,1.4587155963302751,1.4862385321100917,1.5229357798165135,1.5504587155963301,1.5871559633027521,1.6238532110091741,1.6513761467889907,1.6880733944954127,1.7247706422018347,1.7614678899082568,1.7889908256880733,1.8256880733944953,1.8623853211009171,1.8990825688073392,1.9449541284403669,1.9816513761467889,2.0183486238532109,2.0642201834862384,2.1100917431192658,2.1467889908256876,2.1926605504587156,2.238532110091743,2.2935779816513762]
[null,null,null,1.0186915887850467,1,0.9732142857142857,0.95614035087719318,0.95614035087719318,0.93162393162393176,0.90833333333333344,0.89344262295081978,0.88617886178861793,0.87200000000000011,0.8582677165354331,0.8515625,0.83846153846153848,0.81954887218045114,0.80147058823529416,0.79562043795620441,0.78417266187050372,0.76760563380281699,0.75694444444444453,0.74149659863945583,0.73154362416107388,0.7171052631578948,0.70322580645161292,0.68553459119496862,0.6728395061728395,0.65662650602409645,0.64497041420118351,0.63005780346820817,0.61581920903954801,0.60555555555555562,0.59239130434782605,0.57978723404255328,0.56770833333333337,0.55897435897435899,0.54773869346733672,0.53694581280788189,0.52657004830917886,0.51415094339622647,0.50462962962962965,0.49545454545454543,0.48444444444444446,0.47391304347826096,0.46581196581196588,0.45606694560669458,0.44672131147540989,0.43600000000000005]
[null,null,2007,0.95535714285714279,0.9732142857142857,1,1.0178571428571426,1.0178571428571426,1.044642857142857,1.0714285714285714,1.0892857142857142,1.0982142857142856,1.1160714285714284,1.1339285714285714,1.1428571428571428,1.1607142857142856,1.1875,1.2142857142857142,1.2232142857142856,1.2410714285714284,1.2678571428571426,1.2857142857142856,1.3124999999999998,1.3303571428571428,1.357142857142857,1.3839285714285714,1.419642857142857,1.4464285714285714,1.482142857142857,1.5089285714285712,1.544642857142857,1.5803571428571428,1.607142857142857,1.6428571428571428,1.6785714285714284,1.714285714285714,1.7410714285714284,1.7767857142857142,1.8124999999999996,1.8482142857142854,1.8928571428571428,1.9285714285714286,1.9642857142857142,2.0089285714285712,2.0535714285714284,2.089285714285714,2.1339285714285712,2.1785714285714284,2.2321428571428568]
[null,null,null,1.0467289719626169,1.0275229357798166,1,0.98245614035087736,0.98245614035087736,0.95726495726495742,0.93333333333333346,0.91803278688524603,0.91056910569105698,0.89600000000000013,0.88188976377952766,0.87500000000000011,0.86153846153846159,0.8421052631578948,0.82352941176470595,0.81751824817518248,0.80575539568345333,0.78873239436619724,0.7777777777777779,0.76190476190476197,0.75167785234899331,0.73684210526315796,0.72258064516129039,0.70440251572327051,0.6913580246913581,0.67469879518072295,0.66272189349112431,0.64739884393063596,0.63276836158192096,0.62222222222222223,0.60869565217391308,0.59574468085106391,0.58333333333333337,0.57435897435897443,0.5628140703517589,0.55172413793103459,0.54106280193236722,0.52830188679245282,0.51851851851851849,0.50909090909090915,0.49777777777777782,0.48695652173913051,0.47863247863247871,0.46861924686192469,0.45901639344262302,0.44800000000000006]
[null,null,2008,0.93859649122807032,0.95614035087719318,0.98245614035087736,1,1,1.0263157894736843,1.0526315789473684,1.0701754385964912,1.0789473684210527,1.0964912280701755,1.1140350877192984,1.1228070175438598,1.1403508771929827,1.1666666666666667,1.192982456140351,1.2017543859649125,1.2192982456140351,1.2456140350877194,1.2631578947368423,1.2894736842105263,1.3070175438596492,1.3333333333333335,1.3596491228070178,1.3947368421052633,1.4210526315789476,1.4561403508771931,1.4824561403508774,1.5175438596491229,1.5526315789473686,1.5789473684210529,1.6140350877192984,1.6491228070175439,1.6842105263157896,1.7105263157894739,1.7456140350877194,1.7807017543859649,1.8157894736842106,1.8596491228070178,1.8947368421052635,1.929824561403509,1.9736842105263159,2.0175438596491229,2.0526315789473686,2.0964912280701755,2.1403508771929824,2.192982456140351]
[null,null,null,1.0654205607476634,1.0458715596330272,1.0178571428571426,1,1,0.97435897435897434,0.95,0.93442622950819665,0.92682926829268286,0.91199999999999992,0.89763779527559051,0.89062499999999989,0.87692307692307681,0.85714285714285698,0.83823529411764697,0.83211678832116776,0.82014388489208634,0.80281690140845063,0.79166666666666663,0.77551020408163263,0.76510067114093949,0.74999999999999989,0.73548387096774182,0.71698113207547165,0.70370370370370361,0.68674698795180722,0.67455621301775148,0.65895953757225434,0.64406779661016944,0.6333333333333333,0.61956521739130421,0.60638297872340419,0.59375,0.58461538461538454,0.57286432160804013,0.56157635467980294,0.55072463768115942,0.53773584905660365,0.52777777777777768,0.51818181818181808,0.5066666666666666,0.49565217391304345,0.48717948717948717,0.47698744769874468,0.46721311475409832,0.45599999999999996]
[null,null,2009,0.93859649122807032,0.95614035087719318,0.98245614035087736,1,1,1.0263157894736843,1.0526315789473684,1.0701754385964912,1.0789473684210527,1.0964912280701755,1.1140350877192984,1.1228070175438598,1.1403508771929827,1.1666666666666667,1.192982456140351,1.2017543859649125,1.2192982456140351,1.2456140350877194,1.2631578947368423,1.2894736842105263,1.3070175438596492,1.3333333333333335,1.3596491228070178,1.3947368421052633,1.4210526315789476,1.4561403508771931,1.4824561403508774,1.5175438596491229,1.5526315789473686,1.5789473684210529,1.6140350877192984,1.6491228070175439,1.6842105263157896,1.7105263157894739,1.7456140350877194,1.7807017543859649,1.8157894736842106,1.8596491228070178,1.8947368421052635,1.929824561403509,1.9736842105263159,2.0175438596491229,2.0526315789473686,2.0964912280701755,2.1403508771929824,2.192982456140351]
[null,null,null,1.0654205607476634,1.0458715596330272,1.0178571428571426,1,1,0.97435897435897434,0.95,0.93442622950819665,0.92682926829268286,0.91199999999999992,0.89763779527559051,0.89062499999999989,0.87692307692307681,0.85714285714285698,0.83823529411764697,0.83211678832116776,0.82014388489208634,0.80281690140845063,0.79166666666666663,0.77551020408163263,0.76510067114093949,0.74999999999999989,0.73548387096774182,0.71698113207547165,0.70370370370370361,0.68674698795180722,0.67455621301775148,0.65895953757225434,0.64406779661016944,0.6333333333333333,0.61956521739130421,0.60638297872340419,0.59375,0.58461538461538454,0.57286432160804013,0.56157635467980294,0.55072463768115942,0.53773584905660365,0.52777777777777768,0.51818181818181808,0.5066666666666666,0.49565217391304345,0.48717948717948717,0.47698744769874468,0.46721311475409832,0.45599999999999996]
[null,null,2010,0.91452991452991461,0.93162393162393176,0.95726495726495742,0.97435897435897434,0.97435897435897434,1,1.0256410256410258,1.0427350427350428,1.0512820512820513,1.0683760683760684,1.0854700854700856,1.0940170940170941,1.1111111111111112,1.1367521367521369,1.1623931623931625,1.170940170940171,1.188034188034188,1.2136752136752136,1.2307692307692308,1.2564102564102564,1.2735042735042736,1.2991452991452992,1.324786324786325,1.358974358974359,1.3846153846153848,1.4188034188034189,1.4444444444444444,1.4786324786324787,1.512820512820513,1.5384615384615385,1.5726495726495728,1.6068376068376069,1.641025641025641,1.6666666666666667,1.700854700854701,1.7350427350427349,1.7692307692307692,1.8119658119658122,1.8461538461538465,1.8803418803418805,1.9230769230769231,1.9658119658119657,2,2.042735042735043,2.0854700854700856,2.1367521367521367]
[null,null,null,1.0934579439252334,1.0733944954128438,1.044642857142857,1.0263157894736843,1.0263157894736843,1,0.97499999999999998,0.95901639344262291,0.95121951219512191,0.93599999999999994,0.92125984251968496,0.91406249999999989,0.89999999999999991,0.87969924812030065,0.86029411764705876,0.85401459854014583,0.84172661870503596,0.823943661971831,0.8125,0.79591836734693877,0.78523489932885904,0.76973684210526305,0.75483870967741928,0.73584905660377353,0.7222222222222221,0.70481927710843373,0.69230769230769229,0.67630057803468202,0.66101694915254228,0.64999999999999991,0.63586956521739124,0.62234042553191493,0.609375,0.6,0.5879396984924623,0.57635467980295574,0.56521739130434778,0.55188679245283012,0.54166666666666663,0.53181818181818175,0.52,0.5086956521739131,0.5,0.48953974895397484,0.47950819672131145,0.46799999999999997]
[null,null,2011,0.89166666666666672,0.90833333333333344,0.93333333333333346,0.95,0.95,0.97499999999999998,1,1.0166666666666666,1.0250000000000001,1.0416666666666667,1.0583333333333333,1.0666666666666667,1.0833333333333335,1.1083333333333334,1.1333333333333335,1.1416666666666668,1.1583333333333332,1.1833333333333333,1.2,1.2250000000000001,1.2416666666666667,1.2666666666666668,1.2916666666666667,1.3250000000000002,1.35,1.3833333333333333,1.4083333333333334,1.4416666666666667,1.4750000000000001,1.5,1.5333333333333334,1.5666666666666667,1.6,1.625,1.6583333333333334,1.6916666666666667,1.7249999999999999,1.7666666666666668,1.8000000000000003,1.8333333333333335,1.875,1.9166666666666665,1.95,1.9916666666666669,2.0333333333333332,2.0833333333333335]
[null,null,null,1.1214953271028036,1.1009174311926604,1.0714285714285714,1.0526315789473684,1.0526315789473684,1.0256410256410258,1,0.98360655737704916,0.97560975609756095,0.96,0.94488188976377951,0.9375,0.92307692307692302,0.90225563909774431,0.88235294117647045,0.87591240875912402,0.86330935251798568,0.84507042253521125,0.83333333333333337,0.81632653061224492,0.80536912751677847,0.78947368421052633,0.77419354838709675,0.75471698113207542,0.7407407407407407,0.72289156626506024,0.7100591715976331,0.69364161849710981,0.67796610169491522,0.66666666666666663,0.65217391304347816,0.63829787234042556,0.625,0.61538461538461542,0.60301507537688437,0.59113300492610843,0.57971014492753625,0.56603773584905659,0.55555555555555547,0.54545454545454541,0.53333333333333333,0.52173913043478259,0.51282051282051289,0.502092050209205,0.49180327868852458,0.48]
[null,null,2012,0.87704918032786894,0.89344262295081978,0.91803278688524603,0.93442622950819665,0.93442622950819665,0.95901639344262291,0.98360655737704916,1,1.0081967213114753,1.0245901639344261,1.040983606557377,1.0491803278688525,1.0655737704918034,1.0901639344262295,1.1147540983606559,1.1229508196721312,1.139344262295082,1.1639344262295082,1.180327868852459,1.2049180327868851,1.221311475409836,1.2459016393442623,1.2704918032786885,1.3032786885245902,1.3278688524590165,1.360655737704918,1.3852459016393444,1.4180327868852458,1.4508196721311475,1.4754098360655739,1.5081967213114755,1.540983606557377,1.5737704918032787,1.598360655737705,1.6311475409836065,1.6639344262295082,1.6967213114754098,1.737704918032787,1.7704918032786887,1.8032786885245904,1.8442622950819672,1.8852459016393441,1.9180327868852458,1.959016393442623,2,2.0491803278688523]
[null,null,null,1.1401869158878504,1.1192660550458715,1.0892857142857142,1.0701754385964912,1.0701754385964912,1.0427350427350428,1.0166666666666666,1,0.99186991869918695,0.97599999999999998,0.96062992125984248,0.953125,0.93846153846153846,0.91729323308270672,0.89705882352941169,0.8905109489051094,0.8776978417266188,0.85915492957746487,0.84722222222222221,0.82993197278911568,0.81879194630872487,0.80263157894736836,0.7870967741935484,0.76729559748427667,0.75308641975308632,0.73493975903614461,0.72189349112426038,0.7052023121387283,0.68926553672316382,0.6777777777777777,0.66304347826086951,0.64893617021276595,0.63541666666666663,0.62564102564102564,0.61306532663316582,0.60098522167487689,0.58937198067632857,0.57547169811320753,0.56481481481481477,0.55454545454545445,0.54222222222222216,0.5304347826086957,0.5213675213675214,0.5104602510460251,0.5,0.48799999999999999]
[null,null,2013,0.86991869918699194,0.88617886178861793,0.91056910569105698,0.92682926829268286,0.92682926829268286,0.95121951219512191,0.97560975609756095,0.99186991869918695,1,1.0162601626016261,1.032520325203252,1.0406504065040652,1.056910569105691,1.0813008130081301,1.1056910569105691,1.1138211382113823,1.1300813008130082,1.1544715447154472,1.1707317073170731,1.1951219512195121,1.2113821138211383,1.2357723577235773,1.2601626016260163,1.2926829268292683,1.3170731707317074,1.3495934959349594,1.3739837398373984,1.4065040650406504,1.4390243902439024,1.4634146341463414,1.4959349593495936,1.5284552845528454,1.5609756097560976,1.5853658536585367,1.6178861788617886,1.6504065040650404,1.6829268292682926,1.7235772357723578,1.75609756097561,1.788617886178862,1.8292682926829269,1.8699186991869918,1.9024390243902438,1.943089430894309,1.9837398373983739,2.0325203252032522]
[null,null,null,1.1495327102803738,1.128440366972477,1.0982142857142856,1.0789473684210527,1.0789473684210527,1.0512820512820513,1.0250000000000001,1.0081967213114753,1,0.98399999999999999,0.96850393700787396,0.9609375,0.94615384615384612,0.92481203007518786,0.90441176470588225,0.89781021897810209,0.8848920863309353,0.86619718309859162,0.85416666666666674,0.83673469387755106,0.82550335570469802,0.80921052631578949,0.79354838709677411,0.7735849056603773,0.75925925925925919,0.74096385542168675,0.72781065088757402,0.71098265895953761,0.69491525423728817,0.68333333333333335,0.66847826086956519,0.6542553191489362,0.640625,0.63076923076923075,0.61809045226130654,0.60591133004926112,0.59420289855072472,0.58018867924528295,0.56944444444444442,0.55909090909090908,0.54666666666666663,0.5347826086956522,0.52564102564102566,0.5146443514644351,0.50409836065573765,0.49199999999999999]
[null,null,2014,0.85600000000000009,0.87200000000000011,0.89600000000000013,0.91199999999999992,0.91199999999999992,0.93599999999999994,0.96,0.97599999999999998,0.98399999999999999,1,1.016,1.024,1.04,1.0640000000000001,1.0880000000000001,1.0960000000000001,1.1119999999999999,1.1359999999999999,1.1519999999999999,1.1759999999999999,1.1919999999999999,1.216,1.24,1.272,1.296,1.3279999999999998,1.3519999999999999,1.3839999999999999,1.4159999999999999,1.44,1.472,1.504,1.536,1.56,1.5920000000000001,1.6239999999999999,1.6559999999999999,1.6960000000000002,1.7280000000000002,1.7600000000000002,1.8,1.8399999999999999,1.8719999999999999,1.9120000000000001,1.952,2]
[null,null,null,1.1682242990654206,1.1467889908256881,1.1160714285714284,1.0964912280701755,1.0964912280701755,1.0683760683760684,1.0416666666666667,1.0245901639344261,1.0162601626016261,1,0.98425196850393704,0.9765625,0.96153846153846145,0.93984962406015038,0.91911764705882348,0.91240875912408748,0.89928057553956842,0.88028169014084512,0.86805555555555558,0.85034013605442182,0.83892617449664431,0.82236842105263153,0.80645161290322576,0.78616352201257855,0.77160493827160492,0.75301204819277112,0.73964497041420119,0.7225433526011561,0.70621468926553677,0.69444444444444442,0.67934782608695654,0.66489361702127658,0.65104166666666674,0.64102564102564108,0.62814070351758799,0.61576354679802958,0.60386473429951693,0.58962264150943389,0.57870370370370372,0.56818181818181812,0.55555555555555558,0.5434782608695653,0.53418803418803418,0.52301255230125521,0.51229508196721307,0.5]
[null,null,2015,0.84251968503937014,0.8582677165354331,0.88188976377952766,0.89763779527559051,0.89763779527559051,0.92125984251968496,0.94488188976377951,0.96062992125984248,0.96850393700787396,0.98425196850393704,1,1.0078740157480315,1.0236220472440944,1.0472440944881891,1.0708661417322836,1.078740157480315,1.0944881889763778,1.1181102362204725,1.1338582677165354,1.1574803149606299,1.1732283464566928,1.1968503937007875,1.2204724409448819,1.2519685039370079,1.2755905511811025,1.3070866141732282,1.3307086614173227,1.3622047244094488,1.3937007874015748,1.4173228346456692,1.4488188976377954,1.4803149606299211,1.5118110236220472,1.5354330708661417,1.5669291338582676,1.5984251968503935,1.6299212598425195,1.6692913385826773,1.7007874015748032,1.7322834645669292,1.7716535433070866,1.811023622047244,1.8425196850393699,1.8818897637795275,1.921259842519685,1.9685039370078741]
[null,null,null,1.1869158878504673,1.165137614678899,1.1339285714285714,1.1140350877192984,1.1140350877192984,1.0854700854700856,1.0583333333333333,1.040983606557377,1.032520325203252,1.016,1,0.9921875,0.97692307692307689,0.95488721804511278,0.93382352941176461,0.92700729927007297,0.91366906474820153,0.89436619718309862,0.88194444444444453,0.86394557823129259,0.8523489932885906,0.83552631578947367,0.8193548387096774,0.79874213836477981,0.78395061728395055,0.7650602409638555,0.75147928994082847,0.73410404624277459,0.71751412429378536,0.7055555555555556,0.69021739130434778,0.67553191489361708,0.66145833333333337,0.6512820512820513,0.63819095477386933,0.62561576354679815,0.61352657004830924,0.59905660377358494,0.58796296296296291,0.57727272727272727,0.56444444444444442,0.55217391304347829,0.54273504273504281,0.53138075313807531,0.52049180327868849,0.50800000000000001]
[null,null,2016,0.8359375,0.8515625,0.87500000000000011,0.89062499999999989,0.89062499999999989,0.91406249999999989,0.9375,0.953125,0.9609375,0.9765625,0.9921875,1,1.015625,1.0390625,1.0625,1.0703125,1.0859375,1.109375,1.125,1.1484375,1.1640625,1.1875,1.2109375,1.2421875,1.265625,1.296875,1.3203125,1.3515625,1.3828125,1.40625,1.4375,1.4687499999999998,1.5,1.5234375,1.5546875,1.5859374999999998,1.6171874999999998,1.65625,1.6875,1.71875,1.7578125,1.7968749999999998,1.8281249999999998,1.8671875,1.90625,1.953125]
[null,null,null,1.1962616822429906,1.1743119266055044,1.1428571428571428,1.1228070175438598,1.1228070175438598,1.0940170940170941,1.0666666666666667,1.0491803278688525,1.0406504065040652,1.024,1.0078740157480315,1,0.98461538461538456,0.96240601503759393,0.94117647058823528,0.93430656934306566,0.92086330935251803,0.90140845070422537,0.88888888888888895,0.87074829931972797,0.85906040268456374,0.84210526315789469,0.82580645161290323,0.80503144654088044,0.79012345679012341,0.77108433734939763,0.75739644970414211,0.73988439306358389,0.7231638418079096,0.71111111111111114,0.69565217391304346,0.68085106382978733,0.66666666666666674,0.65641025641025641,0.64321608040201006,0.63054187192118238,0.6183574879227054,0.60377358490566035,0.59259259259259256,0.58181818181818179,0.56888888888888889,0.55652173913043479,0.54700854700854706,0.53556485355648531,0.52459016393442626,0.51200000000000001]
[null,null,2017,0.82307692307692315,0.83846153846153848,0.86153846153846159,0.87692307692307681,0.87692307692307681,0.89999999999999991,0.92307692307692302,0.93846153846153846,0.94615384615384612,0.96153846153846145,0.97692307692307689,0.98461538461538456,1,1.023076923076923,1.0461538461538462,1.0538461538461539,1.0692307692307692,1.0923076923076922,1.1076923076923075,1.1307692307692307,1.1461538461538461,1.1692307692307693,1.1923076923076923,1.2230769230769232,1.2461538461538462,1.2769230769230768,1.2999999999999998,1.3307692307692307,1.3615384615384616,1.3846153846153846,1.4153846153846155,1.4461538461538461,1.4769230769230768,1.5,1.5307692307692307,1.5615384615384613,1.5923076923076922,1.6307692307692307,1.6615384615384616,1.6923076923076923,1.7307692307692306,1.7692307692307689,1.7999999999999998,1.8384615384615386,1.8769230769230769,1.9230769230769229]
[null,null,null,1.2149532710280373,1.1926605504587156,1.1607142857142856,1.1403508771929827,1.1403508771929827,1.1111111111111112,1.0833333333333335,1.0655737704918034,1.056910569105691,1.04,1.0236220472440944,1.015625,1,0.97744360902255634,0.95588235294117641,0.94890510948905105,0.93525179856115115,0.91549295774647899,0.90277777777777779,0.88435374149659873,0.87248322147651014,0.85526315789473684,0.83870967741935487,0.8176100628930818,0.80246913580246915,0.78313253012048201,0.76923076923076927,0.75144508670520238,0.7344632768361582,0.72222222222222221,0.70652173913043481,0.69148936170212771,0.67708333333333337,0.66666666666666674,0.65326633165829151,0.64039408866995085,0.62801932367149771,0.6132075471698113,0.60185185185185186,0.59090909090909083,0.57777777777777783,0.56521739130434789,0.55555555555555558,0.54393305439330542,0.53278688524590168,0.52]
[null,null,2018,0.80451127819548873,0.81954887218045114,0.8421052631578948,0.85714285714285698,0.85714285714285698,0.87969924812030065,0.90225563909774431,0.91729323308270672,0.92481203007518786,0.93984962406015038,0.95488721804511278,0.96240601503759393,0.97744360902255634,1,1.0225563909774436,1.0300751879699248,1.0451127819548871,1.0676691729323307,1.0827067669172932,1.1052631578947367,1.1203007518796992,1.1428571428571428,1.1654135338345863,1.1954887218045114,1.2180451127819549,1.2481203007518795,1.2706766917293233,1.3007518796992481,1.3308270676691729,1.3533834586466165,1.3834586466165413,1.4135338345864661,1.4436090225563909,1.4661654135338344,1.4962406015037593,1.5263157894736841,1.5563909774436089,1.5939849624060149,1.6240601503759398,1.6541353383458648,1.6917293233082706,1.7293233082706765,1.7593984962406013,1.7969924812030076,1.8345864661654134,1.8796992481203008]
[null,null,null,1.2429906542056075,1.2201834862385321,1.1875,1.1666666666666667,1.1666666666666667,1.1367521367521369,1.1083333333333334,1.0901639344262295,1.0813008130081301,1.0640000000000001,1.0472440944881891,1.0390625,1.023076923076923,1,0.9779411764705882,0.97080291970802912,0.95683453237410088,0.93661971830985924,0.92361111111111116,0.90476190476190488,0.89261744966442957,0.875,0.85806451612903223,0.83647798742138368,0.82098765432098764,0.80120481927710852,0.78698224852071008,0.76878612716763006,0.75141242937853114,0.73888888888888893,0.72282608695652173,0.70744680851063835,0.69270833333333337,0.68205128205128207,0.66834170854271358,0.65517241379310354,0.64251207729468607,0.62735849056603776,0.6157407407407407,0.6045454545454545,0.59111111111111114,0.57826086956521749,0.56837606837606847,0.55648535564853552,0.54508196721311475,0.53200000000000003]
[null,null,2019,0.78676470588235292,0.80147058823529416,0.82352941176470595,0.83823529411764697,0.83823529411764697,0.86029411764705876,0.88235294117647045,0.89705882352941169,0.90441176470588225,0.91911764705882348,0.93382352941176461,0.94117647058823528,0.95588235294117641,0.9779411764705882,1,1.0073529411764706,1.0220588235294117,1.0441176470588234,1.0588235294117645,1.0808823529411764,1.0955882352941175,1.1176470588235294,1.1397058823529411,1.1691176470588236,1.1911764705882353,1.2205882352941175,1.2426470588235292,1.2720588235294117,1.3014705882352939,1.3235294117647058,1.3529411764705881,1.3823529411764703,1.4117647058823528,1.4338235294117645,1.463235294117647,1.4926470588235292,1.5220588235294115,1.5588235294117647,1.588235294117647,1.6176470588235294,1.6544117647058822,1.6911764705882351,1.7205882352941175,1.7573529411764706,1.7941176470588234,1.838235294117647]
[null,null,null,1.2710280373831775,1.2477064220183487,1.2142857142857142,1.192982456140351,1.192982456140351,1.1623931623931625,1.1333333333333335,1.1147540983606559,1.1056910569105691,1.0880000000000001,1.0708661417322836,1.0625,1.0461538461538462,1.0225563909774436,1,0.99270072992700731,0.97841726618705049,0.9577464788732396,0.94444444444444453,0.92517006802721091,0.91275167785234912,0.89473684210526316,0.8774193548387097,0.85534591194968557,0.83950617283950613,0.81927710843373502,0.804733727810651,0.78612716763005785,0.76836158192090398,0.75555555555555554,0.73913043478260876,0.72340425531914898,0.70833333333333337,0.69743589743589751,0.68341708542713575,0.66995073891625623,0.65700483091787454,0.64150943396226412,0.62962962962962965,0.61818181818181817,0.60444444444444445,0.5913043478260871,0.58119658119658124,0.56903765690376573,0.55737704918032793,0.54400000000000004]
[null,null,2020,0.78102189781021891,0.79562043795620441,0.81751824817518248,0.83211678832116776,0.83211678832116776,0.85401459854014583,0.87591240875912402,0.8905109489051094,0.89781021897810209,0.91240875912408748,0.92700729927007297,0.93430656934306566,0.94890510948905105,0.97080291970802912,0.99270072992700731,1,1.0145985401459852,1.0364963503649633,1.0510948905109487,1.0729927007299269,1.0875912408759123,1.1094890510948905,1.1313868613138685,1.1605839416058394,1.1824817518248174,1.2116788321167882,1.2335766423357664,1.2627737226277371,1.2919708029197079,1.3138686131386861,1.3430656934306568,1.3722627737226276,1.4014598540145984,1.4233576642335766,1.4525547445255473,1.4817518248175179,1.5109489051094889,1.5474452554744524,1.5766423357664234,1.6058394160583942,1.6423357664233575,1.6788321167883209,1.7080291970802917,1.7445255474452555,1.7810218978102188,1.824817518248175]
[null,null,null,1.280373831775701,1.2568807339449541,1.2232142857142856,1.2017543859649125,1.2017543859649125,1.170940170940171,1.1416666666666668,1.1229508196721312,1.1138211382113823,1.0960000000000001,1.078740157480315,1.0703125,1.0538461538461539,1.0300751879699248,1.0073529411764706,1,0.98561151079136711,0.96478873239436636,0.95138888888888895,0.93197278911564629,0.91946308724832226,0.90131578947368429,0.88387096774193552,0.86163522012578619,0.84567901234567899,0.82530120481927727,0.81065088757396464,0.79190751445086716,0.77401129943502833,0.76111111111111118,0.74456521739130432,0.72872340425531923,0.71354166666666674,0.70256410256410262,0.68844221105527648,0.67487684729064046,0.66183574879227058,0.64622641509433965,0.6342592592592593,0.62272727272727268,0.60888888888888892,0.59565217391304359,0.5854700854700855,0.57322175732217573,0.56147540983606559,0.54800000000000004]
[null,null,2021,0.7697841726618706,0.78417266187050372,0.80575539568345333,0.82014388489208634,0.82014388489208634,0.84172661870503596,0.86330935251798568,0.8776978417266188,0.8848920863309353,0.89928057553956842,0.91366906474820153,0.92086330935251803,0.93525179856115115,0.95683453237410088,0.97841726618705049,0.98561151079136711,1,1.0215827338129497,1.0359712230215827,1.0575539568345325,1.0719424460431655,1.0935251798561152,1.1151079136690649,1.1438848920863312,1.1654676258992807,1.1942446043165469,1.2158273381294964,1.2446043165467626,1.2733812949640289,1.2949640287769786,1.3237410071942448,1.3525179856115108,1.3812949640287771,1.4028776978417268,1.431654676258993,1.460431654676259,1.4892086330935252,1.5251798561151082,1.5539568345323742,1.5827338129496404,1.6187050359712232,1.6546762589928057,1.6834532374100719,1.7194244604316549,1.7553956834532376,1.7985611510791368]
[null,null,null,1.2990654205607475,1.275229357798165,1.2410714285714284,1.2192982456140351,1.2192982456140351,1.188034188034188,1.1583333333333332,1.139344262295082,1.1300813008130082,1.1119999999999999,1.0944881889763778,1.0859375,1.0692307692307692,1.0451127819548871,1.0220588235294117,1.0145985401459852,1,0.97887323943661975,0.96527777777777779,0.94557823129251695,0.93288590604026844,0.91447368421052622,0.89677419354838706,0.87421383647798734,0.85802469135802462,0.83734939759036142,0.8224852071005917,0.80346820809248554,0.78531073446327682,0.77222222222222214,0.75543478260869557,0.73936170212765961,0.72395833333333326,0.71282051282051284,0.6984924623115577,0.68472906403940892,0.67149758454106279,0.65566037735849048,0.64351851851851838,0.63181818181818172,0.61777777777777776,0.60434782608695647,0.59401709401709402,0.58158995815899572,0.56967213114754101,0.55599999999999994]
[null,null,2022,0.75352112676056349,0.76760563380281699,0.78873239436619724,0.80281690140845063,0.80281690140845063,0.823943661971831,0.84507042253521125,0.85915492957746487,0.86619718309859162,0.88028169014084512,0.89436619718309862,0.90140845070422537,0.91549295774647899,0.93661971830985924,0.9577464788732396,0.96478873239436636,0.97887323943661975,1,1.0140845070422535,1.0352112676056338,1.0492957746478875,1.0704225352112677,1.091549295774648,1.119718309859155,1.1408450704225352,1.1690140845070423,1.1901408450704225,1.2183098591549297,1.2464788732394367,1.267605633802817,1.295774647887324,1.323943661971831,1.352112676056338,1.3732394366197183,1.4014084507042255,1.4295774647887323,1.4577464788732395,1.4929577464788735,1.5211267605633805,1.5492957746478875,1.5845070422535212,1.619718309859155,1.647887323943662,1.683098591549296,1.7183098591549297,1.7605633802816902]
[null,null,null,1.3271028037383177,1.3027522935779814,1.2678571428571426,1.2456140350877194,1.2456140350877194,1.2136752136752136,1.1833333333333333,1.1639344262295082,1.1544715447154472,1.1359999999999999,1.1181102362204725,1.109375,1.0923076923076922,1.0676691729323307,1.0441176470588234,1.0364963503649633,1.0215827338129497,1,0.98611111111111105,0.96598639455782309,0.95302013422818788,0.93421052631578938,0.91612903225806441,0.89308176100628922,0.87654320987654311,0.85542168674698793,0.84023668639053251,0.82080924855491322,0.80225988700564965,0.78888888888888886,0.77173913043478248,0.75531914893617025,0.73958333333333337,0.72820512820512817,0.71356783919597988,0.69950738916256161,0.68599033816425126,0.66981132075471694,0.65740740740740733,0.64545454545454539,0.63111111111111107,0.61739130434782608,0.60683760683760679,0.59414225941422583,0.58196721311475408,0.56799999999999995]
[null,null,2023,0.74305555555555558,0.75694444444444453,0.7777777777777779,0.79166666666666663,0.79166666666666663,0.8125,0.83333333333333337,0.84722222222222221,0.85416666666666674,0.86805555555555558,0.88194444444444453,0.88888888888888895,0.90277777777777779,0.92361111111111116,0.94444444444444453,0.95138888888888895,0.96527777777777779,0.98611111111111105,1,1.0208333333333333,1.0347222222222223,1.0555555555555556,1.0763888888888891,1.1041666666666667,1.1250000000000002,1.1527777777777777,1.1736111111111112,1.2013888888888888,1.2291666666666667,1.25,1.2777777777777779,1.3055555555555556,1.3333333333333333,1.3541666666666667,1.3819444444444444,1.4097222222222221,1.4375,1.4722222222222223,1.5000000000000002,1.5277777777777779,1.5625,1.5972222222222221,1.625,1.6597222222222223,1.6944444444444444,1.7361111111111112]
[null,null,null,1.3457943925233644,1.3211009174311925,1.2857142857142856,1.2631578947368423,1.2631578947368423,1.2307692307692308,1.2,1.180327868852459,1.1707317073170731,1.1519999999999999,1.1338582677165354,1.125,1.1076923076923075,1.0827067669172932,1.0588235294117645,1.0510948905109487,1.0359712230215827,1.0140845070422535,1,0.97959183673469385,0.96644295302013417,0.94736842105263153,0.92903225806451606,0.90566037735849048,0.88888888888888884,0.86746987951807231,0.85207100591715978,0.83236994219653182,0.81355932203389825,0.79999999999999993,0.78260869565217384,0.76595744680851063,0.75,0.7384615384615385,0.72361809045226133,0.70935960591133007,0.69565217391304346,0.67924528301886788,0.66666666666666663,0.65454545454545443,0.64,0.62608695652173918,0.61538461538461542,0.60251046025104593,0.5901639344262295,0.57599999999999996]
[null,null,2024,0.72789115646258506,0.74149659863945583,0.76190476190476197,0.77551020408163263,0.77551020408163263,0.79591836734693877,0.81632653061224492,0.82993197278911568,0.83673469387755106,0.85034013605442182,0.86394557823129259,0.87074829931972797,0.88435374149659873,0.90476190476190488,0.92517006802721091,0.93197278911564629,0.94557823129251695,0.96598639455782309,0.97959183673469385,1,1.0136054421768708,1.0340136054421769,1.0544217687074831,1.0816326530612246,1.1020408163265307,1.129251700680272,1.1496598639455782,1.1768707482993197,1.2040816326530612,1.2244897959183674,1.2517006802721089,1.2789115646258502,1.3061224489795917,1.3265306122448979,1.3537414965986394,1.3809523809523809,1.4081632653061225,1.4421768707482994,1.4693877551020409,1.4965986394557824,1.5306122448979591,1.564625850340136,1.5918367346938775,1.6258503401360545,1.6598639455782314,1.7006802721088436]
[null,null,null,1.3738317757009344,1.3486238532110091,1.3124999999999998,1.2894736842105263,1.2894736842105263,1.2564102564102564,1.2250000000000001,1.2049180327868851,1.1951219512195121,1.1759999999999999,1.1574803149606299,1.1484375,1.1307692307692307,1.1052631578947367,1.0808823529411764,1.0729927007299269,1.0575539568345325,1.0352112676056338,1.0208333333333333,1,0.98657718120805371,0.96710526315789469,0.94838709677419353,0.92452830188679236,0.90740740740740733,0.88554216867469882,0.86982248520710059,0.8497109826589595,0.83050847457627119,0.81666666666666665,0.79891304347826086,0.78191489361702127,0.765625,0.75384615384615383,0.7386934673366834,0.72413793103448276,0.71014492753623193,0.69339622641509424,0.68055555555555547,0.6681818181818181,0.65333333333333332,0.63913043478260878,0.62820512820512819,0.61506276150627615,0.60245901639344257,0.58799999999999997]
[null,null,2025,0.71812080536912759,0.73154362416107388,0.75167785234899331,0.76510067114093949,0.76510067114093949,0.78523489932885904,0.80536912751677847,0.81879194630872487,0.82550335570469802,0.83892617449664431,0.8523489932885906,0.85906040268456374,0.87248322147651014,0.89261744966442957,0.91275167785234912,0.91946308724832226,0.93288590604026844,0.95302013422818788,0.96644295302013417,0.98657718120805371,1,1.0201342281879195,1.0402684563758389,1.0671140939597317,1.087248322147651,1.1140939597315436,1.1342281879194631,1.1610738255033557,1.1879194630872483,1.2080536912751678,1.2348993288590604,1.261744966442953,1.2885906040268456,1.3087248322147651,1.3355704697986577,1.3624161073825503,1.3892617449664428,1.4228187919463089,1.4496644295302015,1.476510067114094,1.5100671140939597,1.5436241610738255,1.5704697986577181,1.6040268456375839,1.6375838926174497,1.6778523489932886]
[null,null,null,1.3925233644859811,1.36697247706422,1.3303571428571428,1.3070175438596492,1.3070175438596492,1.2735042735042736,1.2416666666666667,1.221311475409836,1.2113821138211383,1.1919999999999999,1.1732283464566928,1.1640625,1.1461538461538461,1.1203007518796992,1.0955882352941175,1.0875912408759123,1.0719424460431655,1.0492957746478875,1.0347222222222223,1.0136054421768708,1,0.98026315789473684,0.96129032258064517,0.93710691823899361,0.91975308641975306,0.89759036144578319,0.88165680473372787,0.86127167630057799,0.84180790960451979,0.82777777777777772,0.80978260869565211,0.79255319148936176,0.77604166666666674,0.76410256410256416,0.74874371859296485,0.73399014778325133,0.71980676328502424,0.70283018867924529,0.68981481481481477,0.67727272727272725,0.66222222222222227,0.64782608695652177,0.63675213675213682,0.62343096234309625,0.61065573770491799,0.59599999999999997]
[]
[]
[null,null,"Source : Macro Indicators from Canada's Energy Future 2020: Energy Supply and Demand Projections to 2050"]
[null,null,"https://apps.cer-rec.gc.ca/ftrppndc/dflt.aspx?GoCTemplateCulture=en-CA"]
[null,null,"(CPI)"]
[]
[null,null,null,null,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,null,"Inf. line",{"$f":"HLOOKUP($E$4,E58:Y60,2)","v":26},2,4,6,8,10,12,14,16,18,20,22,24,26,28,30,32,34,36,38,40,42]
[null,null,"Def. line",{"$f":"HLOOKUP($E$4,E58:Y60,3)","v":27},3,5,7,9,11,13,15,17,19,21,23,25,27,29,31,33,35,37,39,41,43]

{"sheet":"Multipliers","index":9,"n_rows":329,"n_cols":26,"rows_kept":329,"cut":false,"hidden":false,"merged":[[0,0,16,1]]}
["*** WARNING ***\n\nThis Worksheet contains Data and Formulas that are an integral part of the EI2 model.  \nAlthough the data and formulas are available for review they must not be changed.\nAny changes to the data or formulas will impact the analysis and may invalidate the model results.\n\nTo view the data and formulas simply scroll over to the adjacent columns to the right.",null,{"$f":"ProjectData!B9","v":"Alberta"}]
[]
[]
[]
[null,null,"Multipliers"]
[null,null,null,"Jobs",null,null,"Earnings",null,null,"Output",null,null,"Value Added"]
[null,null,null,"Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced",null,null,null,null,"wage factor","Income tax",null,null,"CPP + EI",6.83E-2]
[null,null,"Agriculture",{"$f":"IF(C1=D44,M_CA,IF(C1=E44,M_AB,IF(C1=F44,M_BC,IF(C1=G44,M_MB,IF(C1=H44,M_NB,IF(C1=I44,M_NL,IF(C1=J44,M_NT,IF(C1=K44,M_NS,IF(C1=L44,M_NU,IF(C1=M44,M_ON,IF(C1=N44,M_PE,IF(C1=O44,M_QC,IF(C1=P44,M_SK,IF(C1=Q44,M_YK,IF(C1=R44,M_MR,M_0)))))))))))))))","v":2.2940527386729013},1.9750425956620221,0.51593913894350463,7.3079135790848945E-2,0.11875997599486887,2.6173647953961796E-2,1,0.58751951493484034,0.10204619543906382,0.46211098090700664,0.2596545939896881,6.3120526123851203E-2,null,null,null,"Canada",1,0.16,null,null,"QPP + EI",7.4800000000000005E-2,"Quebec"]
[null,null,"Mining",0.71394416125850468,1.6609846845741649,0.80523819342035574,0.13324700193082645,0.13721989990211844,4.0238380504414424E-2,1,0.4175383696517434,0.15862860272277921,0.54165475734401591,0.23363132532224554,9.8136950424575098E-2,null,null,null,"Alberta",1.1148962527098174,0.27]
[null,null,"Construction",3.4865808507104501,2.0789526318639258,1.3563346242124157,0.29457007747499669,0.16104352236118666,6.757569946374041E-2,1,0.49737581426511562,0.26628433052620709,0.41023870108301225,0.27109394040776225,0.16546476799882354,null,null,null,"British Columbia",0.99101889129761533,0.22]
[null,null,"Manufacturing",1.4650613801138181,2.1801758447570512,0.7565580682496742,0.12029141337486855,0.14579355952208906,3.767567781807929E-2,1,0.79936392514718879,0.14888037535857443,0.32259593198841696,0.34989312248180621,9.2474214674109725E-2,null,null,null,"Manitoba",0.92908021059151447,0.28000000000000003]
[null,null,"Machinery & Equipment & Equipment",2.786867961548821,1.417568470773944,1.050975812203393,0.23876248748513634,0.10763033089864123,5.255497111961846E-2,1,0.34349458152698037,0.20651195245143242,0.40391235142010418,0.17875427892485674,0.12809326250321654,null,null,null,"New Brunswick",0.80520284917931251,0.26]
[null,null,"TCPU",3.0657843968145464,1.6370460300167013,1.1409472514324928,0.2729871582229042,0.11935515507217725,5.694392215860853E-2,1,0.45468578694284212,0.22402247377736256,0.60334805017214665,0.22089689566954693,0.13893376758982939,null,null,null,"Newfoundland and Labrador",0.80520284917931251,0.28000000000000003]
[null,null,"Wholesale Trade",4.6931492704207649,1.532826712669598,1.5004894786388436,0.38994482636068573,0.1045232691577718,7.4999441547261861E-2,1,0.35117782987555607,0.2943248076623563,0.6308450161061484,0.1933147395318057,0.18284858074880331,null,null,null,"Northwest Territories",1.0714285714285714,0.22]
[null,null,"Retail Trade",11.217182313067834,1.7773681478630416,1.6176418178761662,0.41214628062505793,0.11638749452082064,8.0810324404940057E-2,1,0.40972097568788257,0.317263111534689,0.61139866223825112,0.23276204985139148,0.19716053026031244,null,null,null,"Nova Scotia",0.80520284917931251,0.28000000000000003]
[null,null,"FIRE",2.7387721173078781,2.2606516061946706,1.0756708331800104,0.21855001360805504,0.15182150453380305,5.3883260105973371E-2,1,0.4581902223149647,0.21101413644727063,0.57179014242977089,0.25010853883444584,0.13124265602987314,null,null,null,"Nunavut",1.1904761904761905,0.2]
[null,null,"Misc. Services",6.8283404649692878,1.4495732474787422,1.2445188855255089,0.34525710753117084,8.4722209881289909E-2,6.2340530609222095E-2,1,0.25811487833024266,0.24411101903216637,0.71524475847088531,0.14248632436085573,0.15162363612517801,null,null,null,"Ontario",0.99101889129761533,0.23]
[null,null,"Repair & Maintenance",5.9779999999999998,1.57,1.536,0.41899999999999998,9.8000000000000004E-2,7.6999999999999999E-2,1,0.34300000000000003,0.30099999999999999,0.629,0.19000000000000003,0.18699999999999997,null,null,null,"Prince Edward Island",0.80520284917931251,0.27]
[null,null,"Professional Services",5.1580432389494808,1.8179127468316314,1.5243908517849754,0.39778829042217367,0.11204343817986456,7.6068801589188287E-2,1,0.35387025780564474,0.29895511993584634,0.61524202754155621,0.20137561522982084,0.18600392298554139,null,null,null,"Quebec",1.0839269123567667,0.33]
[null,null,"Government",3.6137525070543379,2.8474266849145966,1.4765247374912036,0.34042480485035886,0.18449554714476821,7.3397171121922095E-2,1,0.50878611281108099,0.2895756813913305,0.51614210650105352,0.31782103740099515,0.17982677178939424,null,null,null,"Saskatchewan",1.0839269123567667,0.28000000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yukon",1.1785714285714286,0.22]
[]
[]
[null,null,"PCE House"]
[null,null,"Agriculture",{"$f":"IF(C1=D44,HFCE_CA,IF(C1=E44,HFCE_AB,IF(C1=F44,HFCE_BC,IF(C1=G44,HFCE_MB,IF(C1=H44,HFCE_NB,IF(C1=I44,HFCE_NL,IF(C1=J44,HFCE_NT,IF(C1=K44,HFCE_NS,IF(C1=L44,HFCE_NU,IF(C1=M44,HFCE_ON,IF(C1=N44,HFCE_PE,IF(C1=O44,HFCE_QC,IF(C1=P44,HFCE_SK,IF(C1=Q44,HFCE_YK,IF(C1=R44,HFCE_MR,HFCE_0)))))))))))))))","v":1.2826751403508269E-2}]
[null,null,"Mining",3.1955113599414059E-3]
[null,null,"Construction",5.4669984674305012E-4]
[null,null,"Manufacturing",0.1905785116284979]
[null,null,"Machinery & Equipment & Equipment",7.032290322262099E-3]
[null,null,"TCPU",4.6599863795727892E-2]
[null,null,"Wholesale Trade",3.9507434556328921E-2]
[null,null,"Retail Trade",0.12601101550159335]
[null,null,"FIRE",0.14236234873165718]
[null,null,"Misc. Services",0.3955439005525227]
[null,null,"Repair & Maintenance",4.5324839186706573E-3]
[null,null,"Professional Services",1.4182444885385724E-2]
[null,null,"Government",1.7080743497160787E-2]
[]
[]
[]
[null,null,"Households Final Consumption Expenditure "]
[null,null,"National, Provincial and Territorial"]
[null,null,2017]
[null,null,null,"Canada","Alberta","British Columbia","Manitoba","New Brunswick","Newfoundland and Labrador","Northwest Territories","Nova Scotia","Nunavut","Ontario","Prince Edward Island","Quebec","Saskatchewan","Yukon"]
[null,null,"Agriculture",1.4435171003612498E-2,1.2826751403508269E-2,1.3136411161202767E-2,1.3282991105438803E-2,1.5510984489813714E-2,1.1923691486361222E-2,1.5210973344225248E-2,1.4534871234955938E-2,1.2636460450795783E-2,1.5350892535221617E-2,1.5123459039957626E-2,1.4983089549126421E-2,1.181153279740047E-2,1.0643399431492199E-2,null,0]
[null,null,"Mining",2.4554301482389595E-3,3.1955113599414059E-3,1.1307895102215433E-3,2.2020241746908984E-3,1.0599794881849373E-3,4.0808375140429133E-4,5.2805050650570626E-4,1.3509001366113259E-3,5.5208909018906842E-4,3.7950961323085972E-3,6.1476659502582829E-4,6.5003630059421813E-4,4.0450929164711274E-3,3.0827670434107203E-4,null,0]
[null,null,"Construction",4.602745267532699E-4,5.4669984674305012E-4,4.654106183970099E-4,5.543841629985952E-4,5.2738121293519308E-4,5.7322076890079605E-4,5.6085363255114107E-4,1.7320433757091599E-3,4.1967897919494717E-4,4.2619312169961328E-4,4.4251789299593693E-4,4.0039815017557152E-4,4.9668390077629561E-4,4.7634659300263826E-4,null,0]
[null,null,"Manufacturing",0.19782858921172849,0.1905785116284979,0.17106574665703839,0.19729893944006688,0.23056648662511012,0.22191153992490922,0.20543964235689691,0.19072518182393688,0.18210316767516438,0.1973903401881977,0.22295451649428286,0.21918457274376515,0.19291479640630985,0.14857840862795418,null,0]
[null,null,"Machinery & Equipment",6.7243393353697495E-3,7.032290322262099E-3,6.2739196695593153E-3,6.7036347291059744E-3,6.9898425651075992E-3,5.9036421069549186E-3,5.6766973436749562E-3,6.6441885602941085E-3,6.5674875530408877E-3,6.8083648955048863E-3,5.6759337091892206E-3,6.9537929760986198E-3,7.2827107855919018E-3,5.7802418738807379E-3,null,0]
[null,null,"TCPU",4.8955808051950975E-2,4.6599863795727892E-2,4.5582011884255924E-2,5.060887243818734E-2,5.8138145143807878E-2,6.5207672372036007E-2,5.3445494162428109E-2,7.7296917977031393E-2,6.0788723514663148E-2,4.9438233094220442E-2,4.8856224782883505E-2,4.9644840445646557E-2,4.6371113550571302E-2,6.7996653397244172E-2,null,0]
[null,null,"Wholesale Trade",4.130474105198649E-2,3.9507434556328921E-2,3.7170437967590737E-2,4.2264849933566835E-2,4.9905419959425899E-2,4.8335801251417551E-2,4.5902763627136696E-2,4.2632891954783994E-2,3.9181525689148518E-2,4.0067857194702787E-2,4.8061658841432542E-2,4.5718229139283049E-2,4.2335307577117454E-2,3.5258513783666415E-2,null,0]
[null,null,"Retail Trade",0.12520653113824426,0.12601101550159335,0.1211230627712334,0.12778573909849802,0.13083382525736564,0.13835695645742999,0.12566480690051871,0.12074173226799906,0.15337205445599764,0.11952095967008146,0.12641418442138883,0.13618323325408266,0.13045000533026999,0.13541700076995403,null,0]
[null,null,"FIRE",0.14939614919810176,0.14236234873165718,0.15843133853936883,0.13523774054999096,0.12029504682957114,0.11135303585676508,0.12520277808233229,0.19202170595192722,0.1975682642181911,0.15170941116278744,0.12327689985214846,0.1559089445789722,0.13379050031945947,0.13330119019741501,null,0]
[null,null,"Misc. Services",0.38238213444967484,0.3955439005525227,0.41608393344633821,0.39126558383811544,0.3566501513794168,0.37207448970059348,0.39315527903837599,0.31718618714931313,0.25988374298599282,0.38246037775345609,0.38169624259362728,0.3470259519925018,0.39349206500672435,0.4308823615017745,null,0]
[null,null,"Repair & Maintenance",3.0320569364479088E-3,4.5324839186706573E-3,2.8379789127357591E-3,2.758028005557446E-3,3.0830428288505653E-3,4.4040550217131665E-3,2.2003101823204166E-3,2.1929589087621806E-3,1.0762316244256399E-3,2.5505825331341271E-3,1.7551667196388685E-3,3.1406446856485724E-3,3.2107973545238496E-3,2.2945052779821647E-3,null,0]
[null,null,"Professional Services",1.254995589460919E-2,1.4182444885385724E-2,1.2439194577284061E-2,1.0467388839275433E-2,1.0627552798963826E-2,7.344458873330551E-3,1.2084749441866112E-2,8.4275083374745052E-3,5.6030239460572572E-3,1.3646823337999483E-2,8.4687717882182077E-3,1.0971457016086192E-2,9.3854416920846825E-3,9.3453602575227362E-3,null,0]
[null,null,"Government",1.5268819053281611E-2,1.7080743497160787E-2,1.425976428477382E-2,1.9569823684507527E-2,1.5812141421446588E-2,1.2203352428183859E-2,1.4927601381167778E-2,2.4512912321201043E-2,8.0247549817139122E-2,1.683486838068576E-2,1.6659657269210804E-2,9.2348091680189582E-3,2.4413952362698995E-2,1.9717741583770369E-2,null,0]
[]
[]
[]
[null,null,"Multipliers"]
[null,null,"National, Provincial and Territorial"]
[null,null,2017]
[null,null,null,null,"Jobs",null,null,"Labour income",null,null,"Output",null,null,"GDP"]
[null,null,null,null,"Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced"]
[null,null,"Canada","Agriculture",3.4081857727180882,2.7316639366402549,1.1604597262698344,0.16152071043585398,0.16103680182687446,5.6739595419727229E-2,1,0.69193266752277005,0.21031548092623742,0.48722875180688707,0.33494927627359211,0.12191525530598135]
[null,null,null,"Mining",0.82917153574039315,2.3745845299942663,1.3734335036841678,0.13282652745114898,0.1673484529592475,6.6936901767330789E-2,1,0.51622310205849742,0.24927286445004224,0.57587653763654467,0.28375181718580605,0.14449052132511903]
[null,null,null,"Construction",3.937854252235562,3.319654044415199,2.2494414988500564,0.29164922493714757,0.21922963015961544,0.10946653479254601,1,0.69000825691835455,0.40795107879649423,0.42961235623753125,0.34853997593592145,0.2365151380504166]
[null,null,null,"Manufacturing",1.9620373906832762,2.7394214101431706,1.3856699495629607,0.15152855257157644,0.17380645020631821,6.735836029842876E-2,1,0.74639884439651505,0.25130085610956349,0.26818980974340806,0.3350336487579561,0.14580090787098132]
[null,null,null,"Machinery & Equipment",3.5332878485216699,2.3728863028435643,1.9717633650840229,0.27830764083598952,0.16038205899298219,9.6090511144436314E-2,1,0.54098784997654725,0.35769326266288676,0.40366306656489592,0.26116320700183832,0.20755094692552478]
[null,null,null,"TCPU",3.7259525839161025,2.882326609203433,1.9939622146070606,0.27714231649198373,0.17689751672859821,9.6990296042849783E-2,1,0.64101914021829409,0.36176577245341396,0.57383592486363211,0.31066123361277126,0.20962607179414575]
[null,null,null,"Wholesale Trade",4.7356952628168631,2.8879240704477933,2.4032165565273931,0.34903798450029122,0.16875842287731041,0.11688267096834234,1,0.53023421136154147,0.43614605628407199,0.61176132740698752,0.2817770797445468,0.25284972627340074]
[null,null,null,"Retail Trade",12.342755180523792,2.9716324203026914,2.8180330317396707,0.4335869437878978,0.17262034989134867,0.13705638634218084,1,0.56704670400124224,0.51128234693712638,0.60422396735805961,0.31237811528578224,0.296412119633996]
[null,null,null,"FIRE",2.9331913434677479,3.5762316997067574,1.9313549857235253,0.21860292384992824,0.21920499693686482,9.3968172693596266E-2,1,0.62980370009970044,0.35049251932314307,0.54611091245124421,0.34945083555865541,0.20316826450106279]
[null,null,null,"Misc. Services",7.5807828426778192,2.1858524831388761,2.1318517724389876,0.40730541126925235,0.12479854794662376,0.10365914863918366,1,0.37620804778462091,0.38685138163286387,0.70338409777470967,0.20372053798886067,0.22435164661841062]
[null,null,null,"Repair & Maintenance",8.7360000000000007,2.6019999999999999,2.6989999999999998,0.46100000000000002,0.14699999999999999,0.13100000000000001,1,0.497,0.49,0.59599999999999997,0.26500000000000001,0.28399999999999997]
[null,null,null,"Professional Services",6.3496640887725864,2.9261266337387832,2.7697998747145336,0.44208901837526138,0.16781799245283907,0.13486309831243551,1,0.48854158081759941,0.50240482924789232,0.62709886544964388,0.2735971385111981,0.29125891206294985]
[null,null,null,"Government",4.474281446022685,3.4298716373152232,2.5480955897974309,0.38679830744924781,0.20875079101816493,0.12418389157009373,1,0.58166779028965698,0.46263482997442623,0.53899345011530519,0.34715147307266209,0.26797969855593484]
[]
[]
[]
[null,null,null,null,"Jobs",null,null,"Labour income",null,null,"Output",null,null,"GDP"]
[null,null,null,null,"Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced"]
[null,null,"Alberta","Agriculture",2.2940527386729013,1.9750425956620221,0.51593913894350463,7.3079135790848945E-2,0.11875997599486887,2.6173647953961796E-2,1,0.58751951493484034,0.10204619543906382,0.46211098090700664,0.2596545939896881,6.3120526123851203E-2]
[null,null,null,"Mining",0.71394416125850468,1.6609846845741649,0.80523819342035574,0.13324700193082645,0.13721989990211844,4.0238380504414424E-2,1,0.4175383696517434,0.15862860272277921,0.54165475734401591,0.23363132532224554,9.8136950424575098E-2]
[null,null,null,"Construction",3.4865808507104501,2.0789526318639258,1.3563346242124157,0.29457007747499669,0.16104352236118666,6.757569946374041E-2,1,0.49737581426511562,0.26628433052620709,0.41023870108301225,0.27109394040776225,0.16546476799882354]
[null,null,null,"Manufacturing",1.4650613801138181,2.1801758447570512,0.7565580682496742,0.12029141337486855,0.14579355952208906,3.767567781807929E-2,1,0.79936392514718879,0.14888037535857443,0.32259593198841696,0.34989312248180621,9.2474214674109725E-2]
[null,null,null,"Machinery & Equipment",2.786867961548821,1.417568470773944,1.050975812203393,0.23876248748513634,0.10763033089864123,5.255497111961846E-2,1,0.34349458152698037,0.20651195245143242,0.40391235142010418,0.17875427892485674,0.12809326250321654]
[null,null,null,"TCPU",3.0657843968145464,1.6370460300167013,1.1409472514324928,0.2729871582229042,0.11935515507217725,5.694392215860853E-2,1,0.45468578694284212,0.22402247377736256,0.60334805017214665,0.22089689566954693,0.13893376758982939]
[null,null,null,"Wholesale Trade",4.6931492704207649,1.532826712669598,1.5004894786388436,0.38994482636068573,0.1045232691577718,7.4999441547261861E-2,1,0.35117782987555607,0.2943248076623563,0.6308450161061484,0.1933147395318057,0.18284858074880331]
[null,null,null,"Retail Trade",11.217182313067834,1.7773681478630416,1.6176418178761662,0.41214628062505793,0.11638749452082064,8.0810324404940057E-2,1,0.40972097568788257,0.317263111534689,0.61139866223825112,0.23276204985139148,0.19716053026031244]
[null,null,null,"FIRE",2.7387721173078781,2.2606516061946706,1.0756708331800104,0.21855001360805504,0.15182150453380305,5.3883260105973371E-2,1,0.4581902223149647,0.21101413644727063,0.57179014242977089,0.25010853883444584,0.13124265602987314]
[null,null,null,"Misc. Services",6.8283404649692878,1.4495732474787422,1.2445188855255089,0.34525710753117084,8.4722209881289909E-2,6.2340530609222095E-2,1,0.25811487833024266,0.24411101903216637,0.71524475847088531,0.14248632436085573,0.15162363612517801]
[null,null,null,"Repair & Maintenance",5.9779999999999998,1.57,1.536,0.41899999999999998,9.8000000000000004E-2,7.6999999999999999E-2,1,0.34300000000000003,0.30099999999999999,0.629,0.19000000000000003,0.18699999999999997]
[null,null,null,"Professional Services",5.1580432389494808,1.8179127468316314,1.5243908517849754,0.39778829042217367,0.11204343817986456,7.6068801589188287E-2,1,0.35387025780564474,0.29895511993584634,0.61524202754155621,0.20137561522982084,0.18600392298554139]
[null,null,null,"Government",3.6137525070543379,2.8474266849145966,1.4765247374912036,0.34042480485035886,0.18449554714476821,7.3397171121922095E-2,1,0.50878611281108099,0.2895756813913305,0.51614210650105352,0.31782103740099515,0.17982677178939424]
[]
[]
[]
[null,null,null,null,"Jobs",null,null,"Labour income",null,null,"Output",null,null,"GDP"]
[null,null,null,null,"Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced"]
[null,null,"British Columbia","Agriculture",3.1198520407918702,1.9274148333555765,0.84161106975094457,0.12877606501729591,0.11511402437255613,3.9904984876166186E-2,1,0.44146559608333391,0.15381019146511463,0.5480874408256694,0.24583584117139332,9.8739849928573514E-2]
[null,null,null,"Mining",0.97129657954132254,1.4244565834073748,0.8162560133833533,0.13203182923468515,9.6717756365142779E-2,3.9002550580411605E-2,1,0.29167207753896163,0.14928263659653654,0.59679696613626343,0.16439746007699313,9.5751073964942868E-2]
[null,null,null,"Construction",3.781447151985303,2.2251990399826314,1.4122956492539329,0.26249266938563492,0.15013443420527531,6.7407624886753184E-2,1,0.43819443505898314,0.25821564883177883,0.40129729660659974,0.2301740583864908,0.16591705200022944]
[null,null,null,"Manufacturing",2.5915780240254751,2.4327298155031261,1.226564557019117,0.20424251883230524,0.16148730851751167,5.8380289974883245E-2,1,0.59725310837738765,0.22427552513840857,0.31872606692485456,0.27900625480072772,0.14405599641787917]
[null,null,null,"Machinery & Equipment",3.7140220030475475,1.4624296007462763,1.4568000785698008,0.31774482643415969,9.3473656571605598E-2,6.9550165955672857E-2,1,0.27221877207732087,0.26644180612588803,0.40633425464879475,0.14674720720733192,0.17123815037841897]
[null,null,null,"TCPU",3.2765791326500344,2.1469075308411796,1.3684962354869217,0.25479696536944718,0.13482150400467183,6.5112875759789551E-2,1,0.42124062346666558,0.25041558199887876,0.54789234741433468,0.21867788014402942,0.16091180845851411]
[null,null,null,"Wholesale Trade",6.4991218200458336,1.9052477007334605,2.1094652144362005,0.45604622298093622,0.11235422820822044,0.10034682853843889,1,0.33813395790115758,0.38591191920496748,0.64256150289672309,0.18867007347051393,0.24796518717537103]
[null,null,null,"Retail Trade",11.140866755695733,2.1184499555677339,2.0689850480355938,0.44040237770165974,0.12069390226839607,9.8552260241132963E-2,1,0.39595158719121132,0.37848911307395139,0.61422635822446592,0.2277970728103775,0.24331078748908072]
[null,null,null,"FIRE",2.4961820119682714,2.839888457854487,1.1978322781587731,0.18633995766201888,0.16564304294287829,5.6865136824020619E-2,1,0.48030789320306705,0.21887492218183041,0.56337660449037597,0.26444237269841708,0.14081507290874637]
[null,null,null,"Misc. Services",7.0631091299599493,1.7360600820111636,1.46490819908218,0.32334874685904302,9.4782344760555429E-2,6.9606907599142703E-2,1,0.26038323165205363,0.26813945247711451,0.69768934447886577,0.14977218645185583,0.17234956541853563]
[null,null,null,"Repair & Maintenance",8.2850000000000001,2.0019999999999998,2.0089999999999999,0.47599999999999998,0.111,9.5999999999999988E-2,1,0.34399999999999997,0.36699999999999999,0.55500000000000005,0.19500000000000001,0.23599999999999999]
[null,null,null,"Professional Services",6.1692720377266159,1.9424201362712918,1.963475110794991,0.45322052736894863,0.10905595084818982,9.3458554212885625E-2,1,0.30501937354534991,0.35912947623115687,0.65318996944404539,0.17673523367781876,0.23078611942351768]
[null,null,null,"Government",4.5695889826297913,3.0928772847551755,1.8970074170434303,0.37742820062183124,0.19587837117021975,9.0453144403339653E-2,1,0.51020644677026439,0.34699790577282164,0.51096128708312316,0.31177274609175915,0.22306002786631049]
[]
[]
[]
[null,null,null,null,"Jobs",null,null,"Labour income",null,null,"Output",null,null,"GDP"]
[null,null,null,null,"Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced"]
[null,null,"Manitoba","Agriculture",2.5658109247951462,1.6106017330414333,0.45602409632543317,7.8730063497839203E-2,8.3319697215317165E-2,1.9993174430658293E-2,1,0.36088124555856776,7.4903332694513158E-2,0.45871405790510072,0.1849830617944479,4.918883185852467E-2]
[null,null,null,"Mining",0.71562643599586973,0.81838760820310408,0.43344354183459138,7.8693096661465511E-2,5.5450854624740427E-2,1.8804212620859202E-2,1,0.1481610043722526,7.140540878404486E-2,0.75426140447043488,8.9024858029859613E-2,4.7261450280417158E-2]
[null,null,null,"Construction",3.73432810345949,2.0486466061435391,1.1856156915538472,0.26322122860410563,0.12139264625989624,5.1640566659631043E-2,1,0.34335940988005281,0.19501332422592058,0.36431316437351013,0.18594783291017719,0.12823295752172648]
[null,null,null,"Manufacturing",2.9189452820834356,1.6607367548253773,0.87075158435192224,0.20011564246984934,9.076082891886196E-2,3.7869872638694305E-2,0.99996355007425897,0.39860766934443392,0.1433818455496744,0.33492941040048319,0.1936899470235677,9.428776128808497E-2]
[null,null,null,"Machinery & Equipment",3.2850177081687675,1.4168006154607615,0.96566709966321129,0.23097581523477856,8.5400591798412168E-2,4.2122708306176211E-2,1,0.29537148139762304,0.15892670969619097,0.40998277040768616,0.15051688049565287,0.10447805753700803]
[null,null,null,"TCPU",3.6458296076960077,1.5723439087532949,1.0932032083458585,0.2784172919577404,8.6848124615785824E-2,4.7530860781415399E-2,1,0.26368176148623995,0.17981153939302605,0.63041953387136918,0.13602444307466807,0.11838551903584717]
[null,null,null,"Wholesale Trade",5.2080499395121853,1.5563876096769311,1.3752070308727411,0.33826306966572955,8.4108425608422063E-2,5.989967560148652E-2,1,0.26003015601984508,0.22621269955180617,0.63959560103822966,0.14833088014484158,0.14912648845729959]
[null,null,null,"Retail Trade",11.854519785753837,1.7873779646594414,1.595255679282515,0.39889146667955827,9.2860246094019411E-2,6.9526855966585865E-2,1,0.30400933744639635,0.26211876813441237,0.64687514167631976,0.17651547748269722,0.17277962549607453]
[null,null,null,"FIRE",2.6019726411278379,2.5794402428279546,1.055898183456536,0.19429957622404184,0.15240122151524191,4.5926227481409045E-2,1,0.41891592737819533,0.173719795784845,0.5259484113152233,0.24172930868425957,0.11439510334832587]
[null,null,null,"Misc. Services",8.6244598653706159,1.3805739024781878,1.4464964237158702,0.39390531587701705,7.2113610655922644E-2,6.3005349387523182E-2,1,0.19305992891358389,0.23796672169442143,0.72235203619354771,0.11599802323180594,0.15663012442874338]
[null,null,null,"Repair & Maintenance",12.59,1.633,1.6539999999999999,0.51900000000000002,8.1000000000000003E-2,7.1999999999999995E-2,1,0.26300000000000001,0.27200000000000002,0.60099999999999998,0.157,0.17899999999999999]
[null,null,null,"Professional Services",7.2888856875662134,1.832100862153085,1.5952049917861508,0.42536444902879705,8.8897253216710131E-2,6.9748237948068642E-2,1,0.26217311705442387,0.26245542272503897,0.6352191695499666,0.15261219912912069,0.1728200357483769]
[null,null,null,"Government",5.6143010250736838,2.8182713595616198,1.6235237253062627,0.39071943546991639,0.14959607833569952,7.0838402024584662E-2,1,0.40892341828754103,0.26722148288679726,0.53230852321694166,0.25411657175192409,0.17574169628924519]
[]
[]
[]
[null,null,null,null,"Jobs",null,null,"Labour income",null,null,"Output",null,null,"GDP"]
[null,null,null,null,"Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced"]
[null,null,"New Brunswick","Agriculture",4.3001074133225359,1.4692248525909963,0.76697847399784902,0.18870851483019455,7.1449546464000591E-2,3.0303812079445568E-2,1,0.30800605180248963,0.12193852160581192,0.561281192004214,0.13096085664316032,7.4926572325480084E-2]
[null,null,null,"Mining",4.0865130761481279,0.77984990262326237,0.9686339872310693,0.28581065665882532,4.4908120928329492E-2,3.797432825740351E-2,1,0.16001526950910117,0.15372479832221994,0.64668735979517367,7.5763045834052536E-2,9.4288117580246356E-2]
[null,null,null,"Construction",5.3681979811514831,1.9409070780191215,1.2033257705172562,0.30433339668001674,0.10173404153072713,4.7179575805059798E-2,1,0.31650793049616205,0.19084709965064298,0.45470910207376714,0.15650428438901443,0.11744880764115163]
[null,null,null,"Manufacturing",1.3506396155528919,1.0334053119801934,0.40502413090363643,8.1149728656895528E-2,5.4757228455930777E-2,1.5743712472783132E-2,0.99999114055192229,0.23593001352350954,6.459757215614427E-2,0.1497751868097762,0.1045159073820868,3.9557216003706451E-2]
[null,null,null,"Machinery & Equipment",5.5343887100681153,0.93647887207518854,1.0972849578445945,0.2881231236273758,4.7634338460564446E-2,4.3101689841227572E-2,0.99994621449818022,0.15051606382717916,0.17381428411888808,0.41126895889511345,7.7638794497152067E-2,0.10710121543780725]
[null,null,null,"TCPU",3.007700822863971,1.9956085891703625,0.89172341393699028,0.20411923746720217,0.10204106013350361,3.5072328149323435E-2,1,0.4279643995599835,0.14129504816371005,0.47561912253839572,0.17959696036093423,8.7215843998895995E-2]
[null,null,null,"Wholesale Trade",6.2538587922842446,1.6851212293918634,1.4552789050960917,0.3758578933696512,8.8888369439560341E-2,5.7250434535743945E-2,1,0.28192557973651161,0.230790211908971,0.6157906531923103,0.15197018473835103,0.14226041955528279]
[null,null,null,"Retail Trade",13.421379689662515,1.8776174033994726,1.6429728340799867,0.42724726333011293,9.3196222362202777E-2,6.4516200858040801E-2,1,0.31822672879452196,0.26042891471468882,0.61529793714631908,0.1758587513221721,0.16052338076984368]
[null,null,null,"FIRE",2.7023505933780876,2.4736197629134216,0.88504607217415066,0.17271382345712888,0.12838271292809361,3.4698406738073902E-2,1,0.3900080781883743,0.14023737901701236,0.55705740650364388,0.21716614894430955,8.6651745494880458E-2]
[null,null,null,"Misc. Services",7.9030774459804327,1.4924627958344288,1.2186629748575881,0.33839800488290611,6.9457698019761774E-2,4.7761188787432442E-2,1,0.20888315811307906,0.19305215088054067,0.69518143775820329,0.11563206294199128,0.1187956713016355]
[null,null,null,"Repair & Maintenance",13.374000000000001,1.8639999999999999,1.7739999999999998,0.51300000000000001,9.0999999999999998E-2,7.0000000000000007E-2,1,0.316,0.28100000000000003,0.52700000000000002,0.16600000000000001,0.17300000000000001]
[null,null,null,"Professional Services",8.5114869008221792,1.8186339019505169,1.6560562331224864,0.46624229385030586,8.2650160743921133E-2,6.5127684036743225E-2,1,0.24153131469958983,0.26248308002494053,0.6510902804763824,0.13727200911028609,0.16168306331371321]
[null,null,null,"Government",5.682697353891915,2.1148504445426899,1.582047048373685,0.45296092710309593,0.10902502130412123,6.222712410892161E-2,1,0.31304557845703518,0.25090467261248806,0.59018968693331908,0.18196165410810566,0.15469491871573846]
[]
[]
[]
[null,null,null,null,"Jobs",null,null,"Labour income",null,null,"Output",null,null,"GDP"]
[null,null,null,null,"Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced"]
[null,null,"Newfoundland and Labrador","Agriculture",1.9232693217036834,1.3835228180352528,0.36921658918685735,0.10794592248737554,8.585645827017345E-2,1.7810026271517922E-2,1,0.30146690440563373,6.5765477339553194E-2,0.48318029580207356,0.1501237194352727,4.1904718691131604E-2]
[null,null,null,"Mining",0.42777300012614883,0.6009787554413879,0.29794789292655682,7.0351113355324429E-2,5.205540952720928E-2,1.4280390383506602E-2,1,0.16717026285425357,5.2713855083001596E-2,0.73378151542888048,7.7332562717466968E-2,3.3758672533428423E-2]
[null,null,null,"Construction",2.8495773686709587,1.5149840090118756,0.90227918488267789,0.24426074590829874,0.1205649167926509,4.33929449956547E-2,1,0.33034929538425661,0.16030068149272367,0.40550975551122614,0.17399690872514148,0.10250134517681712]
[null,null,null,"Manufacturing",1.3272574076970824,1.2770720998059331,0.43650739289078577,0.12334233659664744,8.4213999038755052E-2,2.081253617273186E-2,0.99997845590738388,0.46199483359282772,7.7270858323482267E-2,0.2316751146029899,0.24672978062283854,4.9600776880637243E-2]
[null,null,null,"Machinery & Equipment",5.2125813384819599,0.99000427972099125,1.2507815644304192,0.45821928877364221,7.0165088896339753E-2,5.9945374358869499E-2,1,0.19223776098126893,0.22188887437983076,0.51495851571733575,0.10785933409618519,0.14232975090521399]
[null,null,null,"TCPU",3.4801882622369278,1.1572813915768936,0.89812284269441789,0.30242118132716245,8.0239463967009303E-2,4.3294990991023588E-2,1,0.31529350693471864,0.15928702050222251,0.52853966192734736,0.14087496230855154,0.10233107587254606]
[null,null,null,"Wholesale Trade",6.1987555013615978,0.99126736506993407,1.2745274225030667,0.44943649067805963,6.8863802369507454E-2,6.1513527325593717E-2,1,0.19983315580544939,0.22637583138042114,0.71141158484389233,0.1145879711198384,0.14493764629598588]
[null,null,null,"Retail Trade",10.86378768344338,1.6007233970659178,1.281917676361787,0.4175173702338088,9.9433099183280582E-2,6.1666828432714343E-2,1,0.28898661783654311,0.22762788440136769,0.63893191657176063,0.16913444190508162,0.14580546225844296]
[null,null,null,"FIRE",2.8306548258190296,1.8506174280924341,0.81933628035058059,0.21856503760941226,0.12560550077635244,3.9172590133629129E-2,1,0.35685898500533281,0.14538344662375091,0.57616845462250121,0.19469493825985662,9.2898337954176333E-2]
[null,null,null,"Misc. Services",7.0953848943932627,1.1346254264858266,1.0682920125205235,0.39550664228423366,6.6611065340075978E-2,5.1305004359404847E-2,1,0.17791509978575154,0.18960743268288868,0.72106546556892981,0.10029862416504727,0.12174645917915404]
[null,null,null,"Repair & Maintenance",5.1189999999999998,1.804,1.331,0.41599999999999998,0.121,6.4000000000000001E-2,1,0.32600000000000001,0.23599999999999996,0.48799999999999999,0.19300000000000003,0.151]
[null,null,null,"Professional Services",5.4899860821897031,1.3220074569617055,1.2198979522883395,0.41378326282658262,8.223020374332568E-2,5.8606085414890249E-2,1,0.22740619523772104,0.2163630057623635,0.74184930829944595,0.13355265458442298,0.1387220745056989]
[null,null,null,"Government",4.8147783305576031,2.5232961434054757,1.2764604599210609,0.39088590516386046,0.1607135618943267,6.1055241241053021E-2,1,0.41512502399480355,0.2266515749163856,0.53764253689003871,0.24985382422162711,0.14498026579023027]
[]
[]
[]
[null,null,null,null,"Jobs",null,null,"Labour income",null,null,"Output",null,null,"GDP"]
[null,null,null,null,"Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced"]
[null,null,"Northwest Territories","Agriculture",11.182203302416463,0.36952365928886161,0.28621462148632465,0.26615285839183139,3.1657076886350013E-2,1.8330242715783807E-2,1,8.9004152201325556E-2,7.7738014081320167E-2,0.55912611337157958,5.3875239827820116E-2,5.0942611889986528E-2]
[null,null,null,"Mining",0.9873710290296368,0.50565524109126492,0.3515523249124084,0.188069181749384,5.0704528366921846E-2,2.243935992274141E-2,1,0.14047393110606321,9.5476767096950632E-2,0.49367402818896489,7.7148808517261663E-2,6.2840645916770091E-2]
[null,null,null,"Construction",1.2792720535033353,0.71982438991760678,0.33148644090634738,0.15850191289956347,7.507071387378958E-2,2.1130657406540215E-2,1,0.1831178528557392,8.9924017636370104E-2,0.27791868037405826,0.10466847776697191,5.9069061694151291E-2]
[null,null,null,"Manufacturing",2.0121508375643153,1.3249927495137741,0.36291941926847332,0.18785428436561949,8.2880184688683078E-2,2.318892507994998E-2,1,0.74418185601876097,9.8694705594141813E-2,0.32332750929338588,0.19485928777949427,6.4343210697827974E-2]
[null,null,null,"Machinery & Equipment",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"TCPU",1.9434990802189862,0.71540934546890811,0.41506733470919888,0.2202729643453066,5.9956378765763915E-2,2.6354343891534404E-2,1,0.20022232961903572,0.11290122650037845,0.41606147123596254,0.10262711075900717,7.381404237007369E-2]
[null,null,null,"Wholesale Trade",2.8336722087866812,0.43412791908476156,0.52363817417916525,0.31171101057010608,3.9023286009005773E-2,3.3336553840840673E-2,1,0.12106919477959062,0.14262589120715727,0.80071373224145848,6.6630087233989041E-2,9.3246280349050303E-2]
[null,null,null,"Retail Trade",9.206228478210587,0.92013684159952003,0.82871056928659925,0.46680030701920644,7.5202235690734351E-2,5.2645225622833781E-2,1,0.25861072509908944,0.22564968467378427,0.64637767924597056,0.1413402245172887,0.14755694762417151]
[null,null,null,"FIRE",1.1338861741705808,0.8678524222621754,0.26909905585914173,0.10465746289547098,7.7648784511639035E-2,1.7495602445791909E-2,1,0.24719372510745297,7.322883810288211E-2,0.6375774390742398,0.14302434270891415,4.7626937789630737E-2]
[null,null,null,"Misc. Services",5.5764447619726614,0.53946334805199891,0.61828726559711067,0.40865470107828028,4.2523867771822342E-2,3.9378203459970611E-2,1,0.12795974912426231,0.16830940141109355,0.71223007723307885,7.3565638225186678E-2,0.11002531989199492]
[null,null,null,"Repair & Maintenance",7.407,0.51100000000000001,0.61699999999999999,0.433,4.3999999999999997E-2,3.9E-2,1,0.156,0.16800000000000001,0.63200000000000001,0.09,0.10999999999999999]
[null,null,null,"Professional Services",6.1025545242185597,0.76170352792529972,0.72639146374921826,0.46158403236704404,5.8696487235501513E-2,4.6207940416079424E-2,1,0.18848261967449245,0.19751738881065256,0.60475373990670922,0.10516802919200645,0.12915766818420726]
[null,null,null,"Government",3.7436359626246341,1.2323233709048589,0.64234870875139438,0.38067136129537477,0.10619580700078826,4.1092423084967619E-2,1,0.32096198349277832,0.17509733616709569,0.49206512092363963,0.17607116671098977,0.11438368985323032]
[]
[]
[]
[null,null,null,null,"Jobs",null,null,"Labour income",null,null,"Output",null,null,"GDP"]
[null,null,null,null,"Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced"]
[null,null,"Nova Scotia","Agriculture",4.5185634605651908,1.6498121618127379,0.8765130037565616,0.20506854008144462,7.6919161597730198E-2,3.5531728981020229E-2,1,0.25593704274980406,0.1364296371460367,0.55956276358779122,0.1306038492694381,8.7049105470226276E-2]
[null,null,null,"Mining",1.0974857847667083,2.8837723111376214,1.3050979908113405,0.17212470847504882,0.2600886574682344,5.3145010327485608E-2,1,0.69741600477967358,0.2036398143304283,0.32344825469806665,0.32904408894169263,0.12947145744160934]
[null,null,null,"Construction",5.2414254729379239,2.3218449272287822,1.3579264475607908,0.3071133894855399,0.12392187148359535,5.4863293698671739E-2,1,0.33950088266988887,0.21147113671178738,0.39808768878100714,0.1817127403529179,0.13497735550041137]
[null,null,null,"Manufacturing",3.2998256559106465,2.0467526433150902,0.99728060675714914,0.21572699785342478,0.1022012440235146,4.0420063040988809E-2,0.99998258293752018,0.36898202039380884,0.15559962408805991,0.30026031019601068,0.18285710174067721,9.9150571337340315E-2]
[null,null,null,"Machinery & Equipment",4.9305894680917044,1.1102222244917543,1.3706447735377454,0.33336193912607626,6.1680271507838419E-2,5.5648564053304109E-2,1,0.17236358837887417,0.21387638600447464,0.48526979837883805,9.5623058947542972E-2,0.13654109631118516]
[null,null,null,"TCPU",3.8630255251151699,1.8449660052708396,1.168129664373871,0.26589176579755214,9.6960148203264887E-2,4.7467920495579775E-2,1,0.30857904296460437,0.18200687443294941,0.50248126823165618,0.15916416365478506,0.11620034085696411]
[null,null,null,"Wholesale Trade",7.5617301818798648,1.7558025100362304,2.0064287233527955,0.49206117722292309,9.0442889740847993E-2,8.1200383916377586E-2,1,0.27920475335694411,0.31289245123474235,0.61823242407837598,0.15196453117128245,0.19961707189421837]
[null,null,null,"Retail Trade",14.032052021328276,1.9628001342374952,1.9476117589878061,0.46208926150763291,9.9358507124828951E-2,7.8677980334205005E-2,1,0.33644348986616512,0.30368294798661039,0.61906521187419428,0.18537186174366038,0.19374403754034306]
[null,null,null,"FIRE",3.0832876665115312,2.7170437098753419,1.0488618140397559,0.18670741058291826,0.13632375166432306,4.2507986932466879E-2,1,0.39524944646767046,0.16356309111411488,0.53966705465986442,0.21777025699748376,0.10426911837242814]
[null,null,null,"Misc. Services",8.4324890605282707,1.4795798889104461,1.4563514326451963,0.36906271498433202,7.0109359298598087E-2,5.8765138998597213E-2,1,0.19825773272622949,0.22699333997344448,0.72899214192329487,0.10950766899363823,0.1451338427589712]
[null,null,null,"Repair & Maintenance",10.663,1.575,1.7149999999999999,0.45000000000000007,8.4000000000000005E-2,6.9000000000000006E-2,1,0.28999999999999998,0.26700000000000002,0.56499999999999995,0.159,0.17100000000000001]
[null,null,null,"Professional Services",8.350448523420722,1.8766861045157159,1.865428604059898,0.46721822028192378,8.9077679201426258E-2,7.5433652228608039E-2,1,0.24676362513413044,0.29105950790397622,0.65993911846775044,0.14170935620183711,0.18586286580338449]
[null,null,null,"Government",4.3692686897507942,2.8829454702434698,1.6597640385352053,0.36561832360989571,0.1569957451229054,6.7209321864281815E-2,1,0.42842025404270623,0.25918541713368248,0.4881240751754603,0.24898401949870344,0.16530686447812867]
[]
[]
[]
[null,null,null,null,"Jobs",null,null,"Labour income",null,null,"Output",null,null,"GDP"]
[null,null,null,null,"Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced"]
[null,null,"Nunavut","Agriculture",1.0720000000000001,0.42799999999999994,0.106,6.0999999999999999E-2,2.3E-2,5.9999999999999993E-3,1,7.4999999999999997E-2,2.5999999999999999E-2,0.627,4.2999999999999997E-2,1.7000000000000001E-2]
[null,null,null,"Mining",1.5072967822316159,0.28213806622379051,0.3406351093389402,0.2059225944478171,2.3935785309876459E-2,1.9615928887154861E-2,1,7.5446155364831999E-2,8.1918290668393526E-2,0.56694343905190148,4.1151254589281115E-2,5.4520795550570225E-2]
[null,null,null,"Construction",1.3758980716276707,0.66218774179270123,0.29343227650941761,0.14145797436513025,6.6759297018024424E-2,1.6476511099268655E-2,1,0.16955957213705083,7.0569597148800858E-2,0.30874104150305709,9.3447120307786638E-2,4.7107512442928094E-2]
[null,null,null,"Manufacturing",2.3896545583558084,1.7761099391435253,0.36338116941010384,0.19281966850248375,0.10579272112508256,2.0451389904054942E-2,0.9989354917418124,0.34698608426847027,8.742666788299655E-2,0.42162071620364389,0.1906327448466264,5.8349256299718523E-2]
[null,null,null,"Machinery & Equipment",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"TCPU",3.6723564349406828,0.73774062724370326,0.5939366536926769,0.35265158345440611,6.0421894281260935E-2,3.3873374798601363E-2,1,0.1742854078938425,0.14252796098343737,0.4498419660251764,9.4729190634703656E-2,9.5870716183580104E-2]
[null,null,null,"Wholesale Trade",2.5504608683496262,0.37191062220558968,0.4268730371572243,0.25701531131980199,3.1109650520976681E-2,2.432130744173085E-2,1,8.7464547882023902E-2,0.10266548972808044,0.76492556450308646,4.6678651622271854E-2,6.8939927414340477E-2]
[null,null,null,"Retail Trade",9.4366958296238685,0.82110085327239968,0.55970148623128024,0.33233533231916029,6.2337795645725572E-2,3.1601935380675204E-2,1,0.19204452847033351,0.13445386445114468,0.65069376248366317,0.10737587795299865,9.0335981868531368E-2]
[null,null,null,"FIRE",1.3869863066524253,0.93212033756970114,0.2127942265803392,8.9132669850729068E-2,7.1457020433636761E-2,1.2205778977110518E-2,1,0.21077847647417805,5.1601230118914432E-2,0.72063920097617651,0.11747817179833214,3.4171458286601467E-2]
[null,null,null,"Misc. Services",4.5383083724815894,0.67926334183405312,0.51731191321365744,0.31073078872015852,5.7767829241219933E-2,2.9254298161284737E-2,0.99959319493434251,0.19033295342052828,0.12427507976787998,0.6781838505660589,0.10014439002577992,8.3383654530577944E-2]
[null,null,null,"Repair & Maintenance",3.7550000000000003,0.54800000000000004,0.31900000000000001,0.78500000000000003,6.2E-2,1.7999999999999999E-2,1,0.18099999999999999,7.6999999999999999E-2,0.43999999999999995,9.8000000000000004E-2,5.0999999999999997E-2]
[null,null,null,"Professional Services",4.559252174590088,0.85606246406365338,0.52285795074050767,0.31264391215765613,6.2697101915774489E-2,2.9568659744441166E-2,1,0.19964814730232072,0.12592550547154463,0.54417108243712942,0.12054824257075004,8.4163396418091285E-2]
[null,null,null,"Government",3.967747575035435,1.130156857621466,0.66141910568150042,0.40072858944789602,8.5041865237513975E-2,3.7080352544288465E-2,1,0.25145009019987824,0.15915079538654714,0.48818707743498208,0.13513588671844959,0.10673938906682763]
[]
[]
[]
[null,null,null,null,"Jobs",null,null,"Labour income",null,null,"Output",null,null,"GDP"]
[null,null,null,null,"Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced"]
[null,null,"Ontario","Agriculture",5.592289967761392,2.5278535398833273,1.1676441865348695,0.1702889004512857,0.14217090533153673,5.763525418800311E-2,1,0.53608102133942448,0.21218743641594401,0.45240221061225061,0.26937394643216134,0.12403489331428524]
[null,null,null,"Mining",2.3352522076431912,1.543239120933964,1.4018864288281339,1.0830583043959668E-3,0.10776677546935555,6.9479978694643896E-2,1,0.32327515505099103,0.25445476587198884,0.61986678309851828,0.17603634060763351,0.14916560268912063]
[null,null,null,"Construction",4.0821038441454203,2.5373961394133886,1.7001650112340612,0,0.163310003145896,8.4210575282923111E-2,1,0.50493648597208229,0.30851569300497689,0.46160214426882606,0.25215551344566456,0.18094317028775286]
[null,null,null,"Manufacturing",1.6845188487226472,1.7998157085419084,0.94106768272541264,6.9074482337100604E-2,0.11816828149564998,4.6650218335480116E-2,1,0.47674012153068696,0.1710183736523932,0.23533467536847136,0.2088371805830318,0.10021518083749684]
[null,null,null,"Machinery & Equipment",3.4094923253641181,1.7105323866662296,1.4851206986269299,0,0.11730203549705506,7.3437553827409074E-2,1,0.38866247111834007,0.26939323676203175,0.38758296030898415,0.18869278367400769,0.1579357845547977]
[null,null,null,"TCPU",4.1380019199338811,2.6378875667695709,1.694218679267967,0.21589538509345038,0.15746886338600011,8.3795316925040594E-2,1,0.53810658941973011,0.3075272497299042,0.53500852608127214,0.26385593841203192,0.18035182100510641]
[null,null,null,"Wholesale Trade",3.9288117844454549,2.59741040074953,1.8157554673127434,0,0.1504299719444164,8.9745240843650542E-2,1,0.46436151983243223,0.32901522341648004,0.58499521030475876,0.2462742783351603,0.1930750200439906]
[null,null,null,"Retail Trade",12.561516585558914,2.7045244184977979,2.360050062546196,0,0.15890014042140321,0.11657075658403646,1,0.51686043115646552,0.42760996588147027,0.5800115962685628,0.28671281085317224,0.25104260501260922]
[null,null,null,"FIRE",3.0757206578291822,2.9763703937462131,1.6257829423457091,0.24096826595399548,0.18926749038784718,8.0502640692924288E-2,1,0.52721242556523507,0.2949241849083607,0.54304491368228169,0.29754917787930257,0.17289875691898918]
[null,null,null,"Misc. Services",7.1166523925220195,1.8923420736685952,1.7517463918759515,0.33953202342219529,0.10513116680090864,8.6530627035014032E-2,1,0.30407005890124622,0.31734813975785464,0.69731908151020883,0.17025438623290268,0.18657389179219949]
[null,null,null,"Repair & Maintenance",9.843,2.37,2.2690000000000001,0.48599999999999999,0.13400000000000001,0.112,1,0.438,0.41099999999999998,0.57299999999999995,0.23300000000000001,0.24099999999999999]
[null,null,null,"Professional Services",6.3362251779051881,2.4181514720700559,2.2692293814173174,0,0.13890477459895101,0.11222259037934806,1,0.39920497709295838,0.41126402971247517,0.62628396476783343,0.22375975135637158,0.24140272790091985]
[null,null,null,"Government",4.2881613786611767,2.9854168538618833,2.1188829782055021,5.4916542708556325E-3,0.18702277478854459,0.10452691918321512,1,0.50259302230658121,0.38403479433389154,0.54639814666497311,0.30346627253829028,0.22546241663978017]
[]
[]
[]
[null,null,null,null,"Jobs",null,null,"Labour income",null,null,"Output",null,null,"GDP"]
[null,null,null,null,"Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced"]
[null,null,"Prince Edward Island","Agriculture",5.3796566353975086,1.9791035945425299,0.7674284354661135,0.19312157037834399,8.5629936530984219E-2,2.8765642170761808E-2,1,0.31541093874064452,0.11582260177882286,0.49443434775053502,0.16656263621095557,7.5764331770831736E-2]
[null,null,null,"Mining",5.6362240349331296,0.38012400566024307,0.83171566541355102,0,1.8913415645857374E-2,3.0956707822928684E-2,1,7.0509355326525108E-2,0.12579796984033387,0.73275467766326252,3.8754677663262557E-2,8.1870123468786055E-2]
[null,null,null,"Construction",6.3248314654494147,1.5840870896229138,1.0464861802965721,0,7.2766339873419281E-2,3.897516451048022E-2,1,0.23337067033401365,0.1579231184354534,0.46158856965317918,0.1211052429835601,0.10313925535190653]
[null,null,null,"Manufacturing",2.0211957378189593,2.7266822545376379,0.61487609776671648,0,0.10878741613109649,2.3026134071078869E-2,0.99996550192661016,0.49138582973036288,9.2651302405882735E-2,0.31938025862883951,0.24445352044305257,6.0476705309607651E-2]
[null,null,null,"Machinery & Equipment",5.4060098562993373,0.90880965694925864,1.0625957125111869,0,4.4799084062750835E-2,3.9266724473324015E-2,1,0.15055634920932406,0.16033580302964168,0.45491438399926515,7.8978151275430841E-2,0.10479215582877245]
[null,null,null,"TCPU",3.7527056566634549,1.6003559853588263,0.8179504251549945,0,7.1025683518423172E-2,3.0697367850886996E-2,1,0.24302220089100715,0.12335341638777048,0.47484306774542484,0.12910678434158041,8.0507955104087744E-2]
[null,null,null,"Wholesale Trade",9.3563135836325309,1.3686583117280915,1.7263320713479018,0,6.4381891163347665E-2,6.4264109145407311E-2,1,0.19866077644387589,0.26012846937245743,0.60921472382351238,0.1166764058739027,0.17026350038678101]
[null,null,null,"Retail Trade",13.126195087068309,1.668193774108913,1.4333377709540205,0,7.3695640705183266E-2,5.3540896371256412E-2,1,0.24311686974290925,0.21592540914816846,0.62608429367380525,0.13900645457115504,0.14140948486250729]
[null,null,null,"FIRE",3.2876505795278375,2.1470535978688865,0.78368924234758652,0,9.9760411694666401E-2,2.9201327727811418E-2,1,0.31621813393467035,0.11808560380420276,0.5438737125244627,0.1791117112531862,7.7416652880646378E-2]
[null,null,null,"Misc. Services",8.7449495882984252,1.3948089451311807,1.2597924070477129,0,6.0842960995307546E-2,4.6992190222826191E-2,1,0.18373510430057066,0.18990780965632925,0.71668058954470215,0.10816350311600435,0.12405138741648497]
[null,null,null,"Repair & Maintenance",11.25,1.5340000000000003,1.343,0,7.0999999999999994E-2,0.05,1,0.248,0.20200000000000001,0.58099999999999996,0.14499999999999999,0.13200000000000001]
[null,null,null,"Professional Services",9.539770025200113,1.3993465402532983,1.4488776368218637,0,5.870195938027966E-2,5.3875378918269504E-2,1,0.17969531269267583,0.21828719733017279,0.6647750753459607,0.10694573812671002,0.14269665367079365]
[null,null,null,"Government",6.9114021920504722,2.130156460728998,1.6508693932730392,4.7535960343786298E-3,9.3807038537303697E-2,6.1322267220206853E-2,1,0.25444827605826409,0.24890774632360627,0.65100959009322057,0.1400575933976449,0.16285140115052765]
[]
[]
[]
[null,null,null,null,"Jobs",null,null,"Labour income",null,null,"Output",null,null,"GDP"]
[null,null,null,null,"Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced"]
[null,null,"Quebec","Agriculture",3.4186953323688036,2.1090658495084114,0.78057062428942425,9.9231639315488868E-2,0.11565232837567734,3.2709794765452813E-2,1,0.47708855754233492,0.11695040640436398,0.54084462121214028,0.27846847353118415,7.0043820392984513E-2]
[null,null,null,"Mining",1.8962761028249804,1.2870204015121953,1.1299001050601125,7.3923621672159173E-4,7.9411309190899629E-2,4.7851661109398869E-2,1,0.25783515310471583,0.16934683643807966,0.66324877051055986,0.13779465113017017,0.10121020324387382]
[null,null,null,"Construction",4.5382424886992245,3.1183605807181678,1.8317217579104317,0.32266387395760515,0.17406122274043431,7.6963988804985506E-2,1,0.54319381725782123,0.27455982856579375,0.44869070880892614,0.26455396617915833,0.16379930358705733]
[null,null,null,"Manufacturing",2.5962220695636447,2.1794998034636328,1.0725713911650285,0.17689064376785965,0.1178892915820966,4.5284189813902004E-2,1,0.4838111328146284,0.16103329512288284,0.31291932636243858,0.21486291210152536,9.6015153462844074E-2]
[null,null,null,"Machinery & Equipment",4.1391948192060699,1.719841857468553,1.4908732324469169,0,9.8003971956079614E-2,6.2789462802401372E-2,1,0.31923530963025559,0.22335237283706683,0.45507874807779708,0.15842202069554887,0.13334524646775078]
[null,null,null,"TCPU",4.4326619668590084,2.0401177693036776,1.4578581165266704,0.22499542945811721,0.1070049340662117,6.1424909435501628E-2,1,0.36124714339421726,0.21864541502197038,0.67295174165869842,0.17552381502311715,0.13033141198754655]
[null,null,null,"Wholesale Trade",5.6975492257242806,2.325032319677717,1.9247622135108851,0,0.12106218038586324,8.1051120985934158E-2,1,0.36190340656180503,0.2886045466690616,0.63485983552349745,0.19496584564782651,0.17251475265316607]
[null,null,null,"Retail Trade",13.568562336815404,2.5838268595143803,2.2537139216630058,0,0.13300524240017811,9.4945400212704659E-2,1,0.42681670108021208,0.33776808683966947,0.61548917656349134,0.23631905600921754,0.20157358610200651]
[null,null,null,"FIRE",3.1586933155265622,3.4018401597582573,1.4403529935701589,0.20670527040064968,0.18727306146603892,6.0630130359797342E-2,1,0.52412682866097315,0.21591225691601729,0.53222692426147744,0.29332519396160373,0.1289500019495356]
[null,null,null,"Misc. Services",9.1028773777991212,1.9669925527900287,1.8454463723919274,0.37558669440764558,9.5953905821374766E-2,7.7778367540114593E-2,1,0.2883716311456449,0.27645535566504564,0.70284365206784405,0.16044903063109509,0.16522296846081716]
[null,null,null,"Repair & Maintenance",11.472,1.9340000000000004,2.1970000000000001,0.48400000000000004,9.9000000000000005E-2,9.2999999999999999E-2,1,0.33200000000000002,0.32900000000000001,0.627,0.17899999999999999,0.19700000000000001]
[null,null,null,"Professional Services",7.2083315392119305,2.6304791842223851,2.2347148054465178,0,0.13508080468272596,9.4287528688226818E-2,1,0.3824562498458689,0.33492873337048734,0.61359272810294219,0.2155629925263633,0.20009579668920133]
[null,null,null,"Government",4.4543194728926103,2.9400785227047512,1.9017571676465632,6.8893073726466868E-3,0.16562459963932846,8.0248794581243482E-2,1,0.46124509494815097,0.2851584552294078,0.54852053248665833,0.29143229567604728,0.170317135077481]
[]
[]
[]
[null,null,null,null,"Jobs",null,null,"Labour income",null,null,"Output",null,null,"GDP"]
[null,null,null,null,"Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced"]
[null,null,"Saskatchewan","Agriculture",1.882779151329522,1.2836156378401582,0.28315714353057742,5.5863471402292079E-2,6.8950857368230728E-2,1.2386182846382753E-2,1,0.18230872228524458,5.0594276120831123E-2,0.45771787244029993,0.18230872228524458,3.2089654803524638E-2]
[null,null,null,"Mining",0.70135880990505084,0.86813145997398355,0.45124661802987304,9.8795763237348053E-2,6.3091649994122131E-2,1.9432634751993614E-2,1,0.14148481139581431,8.0109079479000145E-2,0.63262230865917513,0.14148481139581431,5.1681092176475193E-2]
[null,null,null,"Construction",3.1562711283086493,1.5492446772691399,0.89699576643834378,0.21808353930171703,0.1065144207561415,3.8599276304100254E-2,1,0.17841628384379138,0.15925012976961972,0.38174564575039555,0.17841628384379138,0.10307769224984417]
[null,null,null,"Manufacturing",1.3693864218165492,1.787334661879604,0.48216076046754025,9.3481363816044605E-2,9.0284210170024456E-2,2.0931425139927243E-2,0.99996023974880432,0.32898493421671277,8.5781530375590637E-2,0.2297465524437888,0.32898493421671277,5.553463318911056E-2]
[null,null,null,"Machinery & Equipment",3.5776593796460374,1.301925939302881,0.93545864494007724,0.26930417105677323,8.146075849893808E-2,4.0669595269878678E-2,0.99499320004632863,0.13613631494268041,0.16590142062735008,0.39697124547840795,0.13613631494268041,0.10775803860319379]
[null,null,null,"TCPU",2.5727879563110361,1.4790828315619515,0.74199055799116365,0.18946560855721062,9.1843394469443923E-2,3.2011143046943663E-2,1,0.17094392376597026,0.13163877852635342,0.59449880029295787,0.17094392376597026,8.5408856161551999E-2]
[null,null,null,"Wholesale Trade",4.0988375936054595,1.2352575982026219,1.0264405669477554,0.28461291793038834,7.742575241549042E-2,4.418580065805576E-2,1,0.14984145836698801,0.18190461800913857,0.62102524365115308,0.14984145836698801,0.11818673152033313]
[null,null,null,"Retail Trade",11.211664051149011,1.5895293325078497,1.3528993805153984,0.39618015490469677,8.489135800494306E-2,5.8366812552759148E-2,1,0.17039144787304322,0.23958278348102222,0.65038238794453507,0.17039144787304322,0.1556533649230297]
[null,null,null,"FIRE",2.9116304085018943,2.5152035577644933,0.85970411082111209,0.19106986692226394,0.13405810826384998,3.7351031386976784E-2,1,0.24042784415064783,0.15228318043119263,0.531333913144447,0.24042784415064783,9.9037301522876445E-2]
[null,null,null,"Misc. Services",7.7850952151984103,1.1932252138214945,1.1988037159053333,0.38218181804115881,6.2102830450871255E-2,5.1619412237747922E-2,1,0.11410682677285673,0.21250719991583522,0.7346764346071174,0.11250599190226165,0.13785101840024572]
[null,null,null,"Repair & Maintenance",8.5289999999999999,1.6419999999999999,1.4609999999999999,0.45200000000000001,8.4000000000000005E-2,6.3E-2,1,0.17199999999999999,0.25900000000000001,0.56299999999999994,0.17199999999999999,0.16800000000000001]
[null,null,null,"Professional Services",6.8172640011602086,1.7604290069064825,1.2644644291427427,0.37628630547125347,8.8365685045851766E-2,5.4664517314955995E-2,1,0.15983836315371142,0.22395934920725655,0.64072183046102282,0.15983836315371142,0.14548811033761955]
[null,null,null,"Government",5.2659519197289999,2.5560270943130909,1.3772283720931509,0.38106698568971969,0.14060865704664327,5.9616483641950088E-2,1,0.28041075422884271,0.24383316996133136,0.52447582707211615,0.26118074312317285,0.15854347433898586]
[]
[]
[]
[null,null,null,null,"Jobs",null,null,"Labour income",null,null,"Output",null,null,"GDP"]
[null,null,null,null,"Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced","Direct","Indirect","Induced"]
[null,null,"Yukon","Agriculture",13.866336663185601,2.0103960590496923,0.45720729121338766,0.31963709221994152,9.3651305085370382E-2,2.4281803922693308E-2,1,0.26981955070719582,0.10522002729021736,0.46905323790733411,0.16015151886664189,7.3460011576773648E-2]
[null,null,null,"Mining",1.1192892886625876,1.1231497665468468,0.5031683834256736,0.17025053076274602,0.11492603176949594,2.656774056539063E-2,1,0.28585489121171581,0.11629743029739575,0.56464156757970041,0.1692634968489127,8.0614883901661646E-2]
[null,null,null,"Construction",2.8868098931210002,1.1184872636540206,0.56933483687096997,0.23974378211797817,8.1331203926905266E-2,3.0250274377048959E-2,1,0.21238637975088367,0.13126465291142164,0.43508809529188724,0.12220960534312325,9.1197434904468633E-2]
[null,null,null,"Manufacturing",5.3498969585911098,1.2790957899594224,0.59293395061495457,0.35714587710507639,5.1617045876559742E-2,3.1520092531281227E-2,1,0.14853473421082614,0.13651381217389316,0.52691231927734083,9.3583078075069548E-2,9.5035791182352197E-2]
[null,null,null,"Machinery & Equipment",6.0730000000000004,0.69699999999999995,0.95300000000000007,0.47099999999999997,4.1000000000000002E-2,5.0999999999999997E-2,1,0.11,0.219,0.67800000000000005,6.2E-2,0.153]
[null,null,null,"TCPU",3.9925561699178842,1.1580949828141471,0.78361874106084939,0.33695363647804483,7.7326755582854387E-2,4.1748394724514172E-2,1,0.24051798552535938,0.18013916973204883,0.51185651475715876,0.13620230660458024,0.12567720767758966]
[null,null,null,"Wholesale Trade",4.6542888396786646,0.67327530619970755,0.95963479311633038,0.46129247392175049,4.7081385495151694E-2,5.1066911970723529E-2,1,0.13675578536030331,0.22108451374459134,0.7141002373379417,8.1883847864037157E-2,0.15362600292972739]
[null,null,null,"Retail Trade",9.0641266310976487,1.1886084037021247,0.90293883108933115,0.40001927539710808,8.1518020801189667E-2,4.8094051577429769E-2,1,0.26435966892110135,0.20778855239021865,0.6289190589672421,0.15504818518843422,0.14459329558639583]
[null,null,null,"FIRE",1.0646511415041962,1.566521061044857,0.36899282863406341,9.3492812613261367E-2,0.10761144672807539,1.9692959845275183E-2,1,0.34345651681256645,8.504511850935742E-2,0.57188552489459954,0.19039169889916757,5.936362150057601E-2]
[null,null,null,"Misc. Services",5.2659945369333592,0.83493274260998762,0.61593400400718112,0.28679391179249553,5.5923938542905526E-2,3.2651523341182556E-2,1,0.161274494291193,0.14168790538067633,0.73995068151465226,9.5377466927068555E-2,9.8916655216034322E-2]
[null,null,null,"Repair & Maintenance",10.518000000000001,1.2310000000000001,0.82299999999999995,0.47599999999999998,7.8E-2,4.3999999999999997E-2,1,0.22399999999999998,0.189,0.56799999999999995,0.13,0.13200000000000001]
[null,null,null,"Professional Services",6.9253842928344707,1.4555299270122588,0.86306202245503794,0.46046798288920082,9.855172004150059E-2,4.6060884439969418E-2,1,0.25514026137752754,0.1987181168725444,0.60039646068899299,0.15612931877125721,0.1384702555523023]
[null,null,null,"Government",7.6971285940455205,1.3791448882803052,0.96829855173139756,0.45994125852308188,0.10058563341244804,5.1575663932021759E-2,1,0.2564191915804156,0.22327190211600009,0.58696648280367947,0.15615577884266313,0.15500554692046722]
[]
[]
[]
[]
[null,null,null,"Agriculture",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Mining",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Construction",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Manufacturing",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Machinery & Equipment",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"TCPU",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Wholesale Trade",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Retail Trade",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"FIRE",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Misc. Services",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Repair & Maintenance",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Professional Services",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Government",0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Lists","index":10,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,16,1]]}
["*** WARNING ***\n\nThis Worksheet contains Data and Formulas that are an integral part of the EI2 model.  \nAlthough the data and formulas are available for review they must not be changed.\nAny changes to the data or formulas will impact the analysis and may invalidate the model results.\n\nTo view the data and formulas simply scroll over to the adjacent columns to the right."]
[null,null,"Years",null,"States",null,"Yes / No",null,"Technology/Service"]
[null,null,2010,null,"Canada",null,"Y",null,"Cold climate air-source heat pump"]
[null,null,2011,null,"Alberta",null,"N",null,"Electric furnace"]
[null,null,2012,null,"British Columbia",null,null,null,"Attic insulation (acheive a minimum RSI 8.81 or R-50)"]
[null,null,2013,null,"Manitoba",null,null,null,"Flat roof and/or Cathedral ceiling insulation (acheive a minimum RSI 4.93 or R-28)"]
[null,null,2014,null,"New Brunswick",null,null,null,"Basement / Foundation insulation (insulate a minimum of 60% the area) "]
[null,null,2015,null,"Newfoundland and Labrador",null,null,null,"Exterior wall insulation (100% of the area to 2012 NBC levels)"]
[null,null,2016,null,"Northwest Territories",null,null,null,"Air-sealing"]
[null,null,2017,null,"Nova Scotia",null,null,null,"Windows and doors replacement (U-Factor 1.08 W/m2-K, and Energy star qualified)"]
[null,null,2018,null,"Nunavut"]
[null,null,2019,null,"Ontario"]
[null,null,2020,null,"Prince Edward Island"]
[null,null,2021,null,"Quebec"]
[null,null,2022,null,"Saskatchewan"]
[null,null,2023,null,"Yukon"]
[null,null,2024]
[null,null,2025]
[null,null,2026]
[null,null,2027]
[null,null,2028]
[null,null,2029]
[null,null,2030]
[null,null,2031]
[null,null,2032]
[null,null,2033]
[null,null,2034]
[null,null,2035]
[null,null,2036]
[null,null,2037]
[null,null,2038]
[null,null,2039]
[null,null,2040]