{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Summary","1. Long Term Jobs","2. Payments to NYS","3. Fuel-Resource Access","4a. In-state Purchases","Subcategories","4b. Short-Term Jobs"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"comments":1,"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":"Summary","index":0,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[14,0,14,4]]}
["Facility Name:",null,"Name of Submitter: "]
["NYSERDA Agreement Number:",null,"Date Completed:"]
[]
["Bid Proposal",null,null,"Compliance (3 Year)"]
["Category","Bid Proposal Claim",null,"Category","Compliance Claim"]
["1. Long Term Jobs",null,null,"1. Long Term Jobs",{"$f":"SUM('1. Long Term Jobs'!$F:$F)","v":0}]
["2. Payments To NYS",null,null,"2. Payments To NYS",{"$f":"SUM('2. Payments to NYS'!$H:$H)","v":0}]
["3. Fuel-Resource Access",null,null,"3. Fuel-Resource Access",{"$f":"SUM('3. Fuel-Resource Access'!$H:$H)","v":0}]
["4. In-state Purchases, Goods and Short-Term Jobs",null,null,"4a. In-state Purchases",{"$f":"SUM('4a. In-state Purchases'!$I:$I)","v":0}]
["Total",{"$f":"SUM(B6:B9)","v":0},null,"4b. Short Term Jobs",{"$f":"SUM('4b. Short-Term Jobs'!$L:$L)","v":0}]
[null,null,null,"Total",{"$f":"SUM(E6:E10)","v":0}]
[]
[]
["Entry Instructions:"]
["Enter payments and expenses by category on each tab as appropriate.  Each line item must be supported by documentation to validate the specific payment or expense. Instructions have been provided above each cell for Seller entry and additional guidance.  Totals will populate above in Compliance Claim section."]
[]
["Note, NYSERDA's contractual obligation is against the total dollars claimed and is not category-specific."]

{"sheet":"1. Long Term Jobs","index":1,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,0,1,7]]}
["Category 1. Long-Term New York State Jobs"]
["Instructions to Seller:  Enter claims for Long-term employment of New York State workers (jobs lasting more than 3 years).   Examples of such jobs include, but are not limited to, those associated with operations and maintenance, plant management, or similar. List and describe the type of jobs including category, job/position title, duration, and whether the reported claim included benefits (e.g., fully loaded-wages or just wages).    \nProvide total dollars paid from the Award Notification Date through the end of the first three (3) Contract Years of operation (Expected Total Dollars)."]
["Enter a unique identifier such as name, employee ID, or job number as listed on a 3rd party payroll report,  W2 information, or an identifying number linking this line item entry to supporting documentation.","Select a job category from the provided drop-down list that best matches the entry.  If \"other\" is selected, please explain in the \"notes\" column.","Enter actual job title for each entry","Enter the date on which salary payment commenced.  Must correspond to the payment of salary indicated in supporting documentation.","Enter the date on which salary payment concluded.  Must correspond to the final date of payment of as indicated in supporting documentation.","Enter claimed dollars.","Indicate if Annual Salary & Benefits entry includes benefits or is only wages.","Please include any additional information that may be useful evaluating this economic benefit."]
["Unique Identifier","Job Category","Job Title","Start Date\n(mm/dd/yyyy )","End Date\n(mm/dd/yyyy )","Dollars Claimed","Benefits Included in Column F?","Notes"]

{"sheet":"2. Payments to NYS","index":2,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,0,1,10],[2,2,2,5]]}
["Category 2. Payments/Benefits to New York State and/or its Municipalities"]
["Instructions to Seller:  Enter claims associated  with local property tax revenues to school districts, cities, towns or other taxing jurisdictions in New York, or alternatively, Payments in Lieu of Taxes (PILOT) or other alternative taxing mechanisms and forms of compensation.  List and describe separately all tax payment, PILOT arrangements and/or “host” community payment agreements with all affected New York jurisdictions. All other taxes, including New York State sales taxes and local sales taxes, paid by Seller should be claimed under Category 4.  \nProvide total dollars paid from the Award Notification Date through the end of the first three (3) Contract Years of operation (Expected Total Dollars)."]
["Enter a unique identifier linking each transaction with supporting documentation provided to Auditor.  Examples of a UI include check number, invoice number, identifying number on a 1099 or similar tax form.","Enter payee name.","Indicate the name of the NYS entity or municipality paid.",null,null,null,"Select an entry from the drop down menu that most appropriately characterizes this transaction.  If \"Other\" is selected, please provide an explanation in the notes column.","Enter claimed dollars.","Enter either the date on which the payment was made, or the start date for a range of time over which the payment covered.  E.g. If supporting documentation is an invoice for payments made over the first quarter of any given year, the start date would reflect the start of that quarter.","Enter the end date for a range of time over which a payment  was made.  E.g. If supporting documentation is an invoice for payments made over the first quarter of any given year, the end date would reflect the last day of that quarter.","Please include any additional information that may be useful evaluating this economic benefit."]
["Check Number/Invoice Number/Other UI","NYS Entity or Municipality","Address","City","State","Zip Code","Payment Type","Dollars Claimed","Start Date\n(mm/dd/yyyy )","End Date\n(mm/dd/yyyy )","Notes"]

{"sheet":"3. Fuel-Resource Access","index":3,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,0,1,10],[2,2,2,5]]}
["Category 3. Payments for Renewable fuels and resource access"]
["Instructions to Seller:  Enter claims associated with renewable fuels and resource access.  Examples include payments for leases of land in New York, payments associated with the production of electricity, fuel purchases of biomass sourced or harvested in New York, and purchases for landfill gas produced in New York. Payments for non-renewable fuels such as natural gas are not eligible for consideration in this category or any Economic Benefits category. Provide total dollars paid from the Award Notification Date through the end of the first three (3) Contract Years of operation (Expected Total Dollars)."]
["Enter a unique identifier linking each transaction with supporting documentation provided to Auditor.  Examples of a UI include check number, invoice number, identifying number on a 1099 or similar tax form.","Enter the name or unique identifier of the landowner or fuel vendor to whom the payment was made.","Enter the payee's address.",null,null,null,"Select a payment pategory that best matches the entry from the drop-down list provided.  If \"other\" is selected, please explain in the \"notes\" column.","Enter claimed dollars."," Enter either the date on which the payment for fuel/resource access was made, or the start date for a range of time over which fuel/resource access was purchased.  e.g. If supporting documentation is a 1099 for payments made over the course of a year, the start date would reflect the start of that year.   ","Enter the end date for a range of time over which fuel/resource access was purchased.  e.g. If supporting documentation is a 1099 for payments made over the course of a year, the end date would reflect the end of that year.","Please include any additional information that may be useful evaluating this economic benefit."]
["Check #/1099/UI","Vendor/Landowner","Address","City","State","Zip Code","Payment Category","Dollars Claimed","Start Date\n(mm/dd/yyyy )","End Date\n(mm/dd/yyyy )","Notes"]

{"sheet":"4a. In-state Purchases","index":4,"n_rows":4,"n_cols":12,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,2,2,5],[1,0,1,11]]}
["Category 4. In-State Purchases and Consumption of Goods. Please enter the In-State Purchases and Consumption of Goods incurred directly by the Seller or General Contractor."]
["Instructions to Seller: Enter claims associated with a) the purchase and consumption of local goods and services by non-NY-resident workers, such as, but not limited to, food, lodging, vehicles, equipment, fuel; \nb) the purchase of materials sourced from within New York such as, but not limited to, gravel, steel, concrete and similar materials and/or the purchase and use of equipment and products manufactured or assembled within New York and/or the use of rental equipment or similar supplies sourced from within New York. Wind turbine components not manufactured within New York State will not be considered and should not be included; \nc) ongoing operations and maintenance expenses which were incurred through the first three (3) years of Commercial Operation.   \nProvide total dollars paid from the Award Notification Date through the end of the first three (3) Contract Years of operation (Expected Total Dollars)."]
["Enter a unique identifier linking each transaction with supporting documentation provided to Auditor.  Examples of a UI include check number, invoice number, identifying number on a 1099 or similar tax form.","Enter the name of the vendor or service provider to whom the payment was made.\n","Enter the payee's address.",null,null,null,"Select NAICS Industry Code that best matches the industry for the vendor from the drop-down list provided.  If \"other\" is selected, please explain in the \"notes\" column.","Provide a description of the good(s) or service(s) provided.","Enter claimed dollars.","Note if a General Contractor was used and incurred this expense, or if the expense was incurred by the Seller","Indicate the date of the purchase for the good or service provided.","Please include any additional information that may be useful evaluating this economic benefit."]
["Check Number/Invoice Number/Other Unique Identifier","Vendor","Address","City","State","Zip Code","NAICS Code","Description/Item","Dollars Claimed","Incurred By","Date\n(mm/dd/yyyy)","Notes"]

{"sheet":"Subcategories","index":5,"n_rows":28,"n_cols":1,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["11 - Ag, Forestry, Fish and Hunting"]
["21 - Mining"]
["22 - Utilities"]
["23 - Construction (New, existing, structural, non-structural contractors)"]
["321 - Wood Product mfg (wood pellets)"]
["31-33 (excl. 321) - All Other Manufacturing"]
["42 - Wholesale Trade"]
["44-45 - Retail Trade"]
["482 - Truck Transportation"]
["48 (excl. 482) - All Other Transportation Services"]
["49 - Warehousing"]
["51 - Information"]
["52 - Finance and Insurance"]
["531 - Real Estate Services"]
["532 - Leasing and Rental Services"]
["5411 - Legal Services"]
["5413 - Architectural and Engineering Services"]
["54 (excl. 5411 and 5413) - All Other Professional Services"]
["55 - Management of Companies"]
["561 - Administrative Services"]
["562 - Waste Services"]
["61 - Educational Services"]
["62 - Health and Social Services"]
["71 - Arts - entertainment and recreation"]
["72 - Accomodation and Food Services"]
["811 - Repair and Maintenance Services"]
["81 - All Other Services"]
["92 - Government and Non-NAICs"]

{"sheet":"4b. Short-Term Jobs","index":6,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,0,1,10],[2,1,2,3]]}
["Category 4. Short-term Employment.  Please enter Short-term Jobs hired directly by the Seller or General Contractor."]
["Instructions for Seller: Enter claims for employment of New York workers on a short-term basis (less than 3 years).  Examples include direct employment of NYS construction, rail and port workers, contractors and laborers, engineering or environmental service providers, consultants, financial service advisors, and legal service providers associated with the development and construction/modification of the Bid Facility.\n Provide total dollars paid from the Award Notification Date through the end of the first three (3) Contract Years of operation (Expected Total Dollars)."]
["Enter a unique identifier such as name, employee ID, or job number as listed on a 3rd party payroll report,  W2 information, or an identifying number linking this line item entry to supporting documentation.","Enter the employee's city, state, and zip of residence",null,null,"Select a job category from the provided drop-down list that best matches the entry.  If \"other\" is selected, please explain in the \"notes\" column.","Add in actual job title for each job, or \"consultant\" for service related transactions","Enter the date on which salary payment commenced.  Must correspond to the payment of salary indicated in supporting documentation.","Enter the date on which salary payment concluded.  Must correspond to the final date of payment of as indicated in supporting documentation.","Enter claimed dollars.","Note if a General Contractor was used and incurred this expense, or if the expense was incurred by the Seller","Please include any additional information that may be useful evaluating this economic benefit."]
["Unique Identifier","City","State","Zip Code","Job Category","Job Title","Start Date\n (mm/dd/yyyy )","End Date \n(mm/dd/yyyy )","Dollars Claimed","Incurred By","Notes"]