{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","FC List","Master CSJ List","Invoice","Signature Authority","WA Financial Status Summary","Deliverable Summary"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":30,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":118,"n_cols":3,"rows_kept":118,"cut":false,"hidden":false,"merged":[[57,1,62,1],[7,0,7,1],[16,0,16,1],[33,0,33,1],[9,0,9,1],[48,1,54,1],[5,0,5,1],[106,0,106,1],[112,0,112,1],[86,1,91,1],[100,1,105,1],[37,0,37,1],[92,0,92,1],[84,0,84,1],[98,0,98,1],[47,0,47,1],[75,0,75,1],[83,0,83,1],[82,0,82,1],[55,0,55,1],[63,0,63,1],[69,0,69,1],[0,0,0,1],[3,0,3,1],[4,0,4,1],[1,0,1,1],[2,0,2,1]]}
["Invoice Template for Lump Sum Payment Method\n\nSetup and Submittal Instructions:\n\nMaster File Setup:  Enter data into cells highlighted in blue in the Master Template Setup and the Invoice tabs.  Save the Master File with the following Prime Provider Firm Name-Legacy Contract Number-WA Number-Master File (ex:  3rd Rock Engeineering-18-2IDP5001-WA1-Master File)\n\nMonthly Invoice Completion:  Open the Master File, then  \"save as\" with the following:  Prime Provider Firm Name-Legacy Contract Number-WA Number-Invoice Date (ex:  3rd Rock Engeineering-18-2IDP5001-WA1- 12-10-2020).  Enter data into all cells that are highlighted in yellow for each tab, starting with the Deliverable Summary tab.  The white cells will be automatically populated from data that is entered into the linked tabs in the invoice template. Go back and complete the remaining yellow cells in the Invoice, Signature Authority and WA Financial Status Summary tabs. Once the yellow cells have been populated in each tab, follow the instructions for completing the invoice by rolling up unused rows, checking that all totals have carried forward correctly, and checking the print setup to ensure that the margins are adjusted and the blank pages are deleted.  \n\n(Note:  Check totals.  If there is a rounding error, line through the total, make correction and initial next to the change prior to submitting the invoice package to TxDOT.  After TxDOT receives the invoice package, the procedures allow limited internal adjustments to round the total amount payable down, but not up, not even for a one cent rounding error.  In that case, the invoice package will be returned to the provider for correction and resubmission)\n\nFinal Invoice Preparation:  Hide the Instructions, FC List and Master File Template Setup tabs. Go to File, Print and make final adjustment to delete any blank pages, and adjust margins as needed.  Save the completed invoice template as a pdf and add supporting documentation. If this is a TxDOT District contract, email to peps_invoice_center_district@inboundna11.springcm.com. If this is a TxDOT Division contract, email to peps_invoice_center_division@inboundna11.springcm.com.\n\nDO NOT MAKE ANY MODIFICATIONS TO THE PROGRAMMING OR FORMAT OF THE INVOICE TEMPLATE (OTHER THAN LINING THROUGH AND CORRECTING A ROUNDING ERROR, IF APPLICABLE).  MODIFICATIONS MAY RESULT IN A REJECTION OF THE INVOICE PACKAGE. \n\n"]
["FUNCTION CODE (FC) LIST - FOR INORMATIONAL PURPOSES ONLY"]
["For reference only:  This list has been included for reference.  The Legacy FCs that are highlighted in yellow (column C) will be used when invoicing, and then will automatically be converted to the PeopleSoft FCs and shown on the Chart of Accounts (COA) Invoice Conversion sheet that will be used by TxDOT to enter the invoice into TxDOT's electronic billing system for voucher processing.\n\n\n"]
["CHART OF ACCOUNTS (COA) INVOICE CONVERSION SHEET - FOR TxDOT USE ONLY"]
["TxDOT Use Only - This page is setup to automatically convert Legacy TxDOT COA codes for voucher processing. If applicable, verify against the Invoice Conversion page provided with the executed Work Authorization.   The COA conversion page is setup to \"roll up\" the Legacy FCs into the New FCs so the amount of line items that you see on the conversion tab will not match the same amount of line items shown on the Invoice tab.  Click on the drop down menu in Cell B9 to roll up unused rows prior to saving the invoice template as a pdf.\n\nThe COA includes a summary line that does not include a total in the \"Amount\" column.  Disregard that summary line as it is part of the conversion program.\n\n"]
["MASTER LIST OF CSJs",null,"Link to Master CSJ List"]
["Project (CSJ or Detail No.)","mvbr19\n"]
["INVOICE TAB",null,"Link to Invoice Tab"]
["Cell Heading\n\n"]
["INVOICE HEADER SECTION (TOP RIGHT)"]
["Provider Invoice Date\n\n","Automatically populated by cell B30 of the Signature Authority tab, and is a write protected cell.  Verify cell has been populated correctly. "]
["Provider Invoice No.\n\n","Enter a unique number (assigned by the provider).  The number can be up to  eight (8)  (alpha and numeric with dashes only).  Do not duplicate invoice numbers.  It is preferred that the invoice number begins with one (1) and that it is in sequence for each Work Authorization (WA) to ensure proper tracking."]
["Combined Invoice Template\nLog No.","Default is 1 (primary invoice). Used to identify the primary and supplementary invoice tabs.  If multiple combined invoice tabs are used, click on Cell G2, and a drop down menu will appear.  If no supplementary tabs are added, select N/A.  \n\nA combined invoice template package includes more than one invoice template (for example when using more than one payment method). See guidance and instructions for the Signature Authority tab and reference the Template Description Categories on the Signature Authority tab for more information)."]
["PeopleSoft (PS) Contract No.","Enter the PS Contract number for the executed contract.  "]
["PS Work Authorization (WA) \nPO No.","Enter the PS WA PO number for the executed WA.  "]
["TxDOT Invoice No.","Enter the number provided by the TxDOT Professional Engineering Procurement Services (PEPS) Division Service Center.  If you do not have the number, then this cell can be left blank and will be added by the PEPS SC."]
["INVOICE"]
["Provider Name\n\n","Enter provider name.  This must exactly match the name shown on the contract, and must be a complete legal name as shown on the Comptroller’s website.\n"]
["Provider ID No.","Enter complete VID number (14 digits).  This number must correspond to correct remittance address.  The last 3 digits correspond to a particular mail code to show where the payment is being mailed or if it is direct deposit.   \n"]
["Remittance Address\n\n","Enter the address where correspondence and documentation for this particular WA should be sent. This may be a different address than the one shown on the contract."]
["Deliverables Submittal Date\n\n","Enter the date that the deliverable(s) were submitted to the TxDOT PM for review and approval.\n\n\n\n\n"]
["Deliverables Accepted Date\n\n","Enter the date that the deliverable(s) were accepted and approved by the TxDOT PM. \n\n\n"]
["WA Project Manager (Provider)\n\n","Enter the name of the prime provider PM . \n\n"]
["DBE/HUB Goal Assignment and Percentage (for contract)","Select the goal assignment for the contract by clicking on the drop down menu to select one of the following:  DBE (for federal funded contracts) or HUB (for state funded contracts.  Enter the assigned goal percentage for the contract.  (The assigned goal percentage is found  in the top section of Exhibit H-1 of the contract.)"]
["Legacy Contract No.","Enter the contract number exactly as shown on the executed contract document.    Contact the TxDOT PM for this Work Authorization (WA) if you do not know the number."]
["Contract Amount","Enter the current contract amount.  (The amount entered in this cell is for the contract (not the WA).  This  is the authorized contract amount at the time the invoice is being submitted even if an SA is being processed for additional funds.)\n"]
["Contract Expiration Date\n\n","Enter the current contract expiration date.  Use MM/DD/YY formatting.  Enter the date of the current contract expiration at the time the invoice is being submitted, even if a SA is being processed for a time extension.  The contract expiration date is found on the fully executed contract.\n\n"]
["Legacy WA No.\n\n","Enter the legacy WA number shown on the fully executed WA document (top right hand corner).  A separate invoice package must be submitted for each WA.  \n"]
["WA Amount\n\n","Enter the exact amount shown in Part II of  the WA, including any additional amounts that have been added by a fully executed SWA.  The WA amount will be the total WA amount at the time the invoice is being submitted even if a SWA is being processed (but has not been executed) for a different amount."]
["WA Execution Date","Enter the date that the WA was fully executed.  This will be the date that the WA was signed by the TxDOT signature authority as shown in the fully executed WA under the title \"The State of Texas\"."]
["WA Expiration Date\n\n","Enter the current expiration date for the executed WA.   This will be the expiration date shown in Part IV of the fully executed WA.  This date will be the WA expiration date at the time the invoice is being submitted even if a SWA is being processed (but has not been fully executed) for a time extension.\n"]
["WA Payment Type(s)\n\n","Enter payment type (or types) as shown on Part IV of the executed WA.  The method of payment to the primary provider will be entered in this field, although various methods of payment may have been used for calculation purposes."]
["WA Project Manager (TxDOT)\n\n","Enter the name of the TxDOT PM for this specific WA. \n"]
["INVOICE SUMMARY SECTION"]
["AY (Appropriation/Fiscal Year)\n\n","Use four (4)  digit appropriation year. The TxDOT’s AY is 9/1/YY to 8/31/YY.   The invoice must not cross AYs.  A separate invoice must be submitted for invoices that are split across appropriation years. \n"]
["DEPT\n(Budget Acct Source Unit)","Enter six (6) numeric digits that will be provided by the TxDOT PM. This will be the number for the DIST/DIV budget account that has been setup in PeopleSoft to fund the project. \n\nNote the question to the right of this section: \"Is this a Consultant Engineering Contract (CEC)?\". If \"Yes\" is selected, additional instructions will appear to allow the inclusion of multiple DEPT values to be entered. Otherwise (for all other contract types), only one DEPT value will be permitted."]
["Project Description\n\n","Enter a short description of the project.  The description will closely match that shown on the 1st page of the WA.  Both alpha and numeric characters can be used, and the cell can be expanded to fit a general description.\n\n\n"]
["INVOICE DETAIL SECTION"]
["Line No.\n\n","No entry required.  The line indicator directly corresponds to the total amount invoiced by CSJ and FC shown in the Summary of Total Amount Invoiced tab and for each subtotal line number entered into the corresponding tabs.  \n   \nThe line indicator also directly corresponds to the Highway Maintenance Detail line No. in the next section. Detailed information will be provided by the TxDOT PM when there is no CSJ/Detail number associated with the project.  "]
["DD (DIST/DIV Budget No.)","Enter the district or division number that is provided by the TxDOT PM."]
["PCBU \n","Enter the Segment ID (ONLY) which will be provided by the TxDOT PM.  Note: The leading 601 will automatically be added when the line item rolls over to the COA Inv Conv tab. "]
["Project\n(CSJ or Detail No.)\n\n\n","Automatically populated from Project (CSJ/Detail No.) that was selected using the Labor Summary (Office) for the particular billing, and is a write protected cell.  Verify that this cell has been populated correctly.  Once each line number has been populated, click on the drop down menu button (Cell D20) by clicking on \"blanks\" from the drop down list to remove the checkmark, and the tab will roll up to remove unused rows."]
["Amount\n\n","Automatically populated and is a write protected cell.  Verify that the amount has been populated correctly by line number.  "]
["Source \n(Legacy Function Code)\n\n","Automatically populated and is a write protected cell.  Verify that this cell has been populated correctly. \n\nThe provider will submit their monthly invoice by the CSJ/Detail number and Legacy FC detail as provided by the TxDOT PM.  The Legacy FC will automatically be converted to the PeopleSoft FC in the COA Invoice Conversion tab. The Function Code is based on the scope of work in the WA or the Contract.   Reference and use the FC List  Legacy Function Code (FC) from the list of FCs, along with a descriptions of work as indicted in the FC List tab tab.  The TxDOT PM will assist to ensure that the correct FCs are used. )"]
["ACCT \n(Object of Expenditure)\n\n","Enter the ACCT (Object of Expenditure) number provided by the TxDOT PM for this WA."]
["(TxDOT Use Only)  \nSpecial Funding Indicator/SFI Code  TxDOT Use Only","Do not enter any data in this cell.  This code will be entered by the PEPS SC (if applicable)."]
["Amount Total\n","Automatically calculated (sums Invoice column A cells A21 to cell A70).  Note: This amount must reconcile to the tabs WA Financial Status Summary (cell E13) and Deliverable Summary.  \n\nBackup documentation is not required for Lump Sum payment type.  The amount billed is based upon receipt and acceptance of the deliverables as indicated in the Table of Deliverables (TOD).  Reference the TOD in the particular WA  for additional information.  "]
["HIGHWAY MAINTENANCE DETAIL SECTION\n(This section is only applicable for special projects (e.g. specific lab or surveying projects) that do not have an assigned CSJ/Detail number.)"]
["Line No.\n\n","Detailed information will be provided by the TxDOT PM (if applicable). Data for this Line No. will directly correspond with the Line No. under the Invoice Detail subheading in this tab.  The TxDOT PM will provide additional information on utilizing the Line No. cell when there is no CSJ/Detail number associated with the project, and the Highway Maintenance Detail information will be necessary to correctly identify the project.\n"]
["Task/Work Order\n\n"]
["County\n\n"]
["System\n\n"]
["Highway No.\n\n"]
["Suffix\n\n"]
["Class\n\n"]
["SIGNATURE AUTHORITY TAB",null,"Link to Signature Authority Tab"]
["Cell Heading"]
["Provider Invoice No.\n\n","The following group of cells will automatically be populated from the data entered into the Invoice and Signature Authority tabs.  Reference instructions for these cells under the sections for Invoice and Signature Authority."]
["Combined Invoice Template Log No."]
["Legacy Contract No."]
["Legacy WA No."]
["Provider Name\n\n"]
["Provider ID No."]
["COMBINED INVOICE SUMMARY"]
["Combined Invoice Templates","These cells are write protected and are used to describe supplemental invoice tabs included in addition to the primary invoice tab, where necessary, to calculate the combined total amount of this invoice. \n\n"]
["Invoice Template Log No.","These cells are write protected and are used to describe supplemental invoice tabs included in addition to the primary invoice tab, where necessary, to calculate the combined total amount of this invoice. \n\n"]
["Reason for Combined Invoice Template Package","Combined Invoices are used to combine more than one invoice template since the terms of the contract allow only one invoice to be submitted monthly. If using a supplementary invoice template that will be attached to the primary invoice template, use the drop-down menu starting with Cell D15 to select a reason from the drop down menu for using the additional invoice template (for a supplemental invoice) . Descriptions for reasons to combine invoice templates are listed in Cells I14 - I19)of this tab.\n\nWhen using a Combined Invoice (additional/supplemental invoice template), the entire supplementary invoice template package must be included with the primary invoice package (including a signed Signature Authority tab). The Signature Authority tab  of the primary invoice will show the Invoice Template Amount including the supplemental invoice amount, if applicable.  \n\nExample:  A separate \"supplemental Invoice\" should be used and attached to the provider invoice for \"straggler” invoices from previous billing periods that may include subproviders invoices or Other Direct Expenses (ODEs) that fall under a previous billing period.  The supplemental invoice amount will be entered on the Signature Authority Tab in the Combined Invoice Summary Section (Cell E15, 16, etc.), and the amount entered will carry forward to the WA Financial Status Summary tab (Cell E14 and E15), but will not be included in the overall total for the prime provider invoice for the month.  A separate template will be used and labeled on the Invoice tab  as Log No.2 in the top right corner (Cell G2).  All supporting documentation should be attached to the supplemental invoice.  \n\nIf submitting a supplemental invoice for a previous billing period, then use the \"Supplementary Invoice for Previous Billing Period\" option from the drop down menu on the Signature Authority tab (Cell D15, D16, etc.).  The provider should use the same invoice number associated with the \"straggler billing period\", and use a \"placeholder indicator such as SUP\" to identify that the invoice is a supplement to a previous invoice for costs incurred during a previous billing period.  (ex:  The supplemental invoice for additional costs to be billed under previous invoice No.16, may be labeled 16-SUP to indicate that this billing is a supplement to a previous billing period)."]
["Invoice Template Amount\n","Enter the total amount for each supplementary invoice tab where applicable.  This amount should match the Total found on the Invoice tab page for each supplementary invoice and should also correspond with the Combined Invoice tab Log No. listed for that supplementary invoice. Once each line number has been populated, click on the drop down menu button (Cell E13) by clicking on \"blanks\" from the drop down list to remove the checkmark, and the tab will roll up to remove unused rows."]
["Total Combined Invoice Amount","This cell is automatically calculated. (Sum of the Combined Invoice tabs Log No. 1-5, for the primary invoice tab and any supplementary invoice tab totals entered.)"]
["PROVIDER USE ONLY\nInvoice Certification "]
["Prompt Payment (PP) Certification"]
["Provider Invoice No. for PP Verification\n\n","The provider invoice number for PP verification will be the particular invoice that has been submitted and payment has been received from TxDOT by the provider (normally within last 60 days).  Read the certification statement regarding prompt payment to subproviders for the invoice indicated in this section. Follow the instructions as stated."]
["Date Provider Received Payment \n(for PP Verification)","Enter the date that the payment for the specific invoice indicated was received from TxDOT."]
["Begin Service Date \n(for PP Verification)","Enter the date that the deliverable(s) were submitted to the TxDOT PM for review and approval.\n\n\n\n\n"]
["End Service Date \n(for PP Verification)","Enter the date that the deliverable(s) were accepted and approved by the TxDOT PM for voucher processing."]
["PROVIDER SIGNATURE BLOCK"]
["Provider Authorized Signature\n\n","It is the provider’s discretion as to who signs the certification for  this invoice package. Signature and Printed Name must be the same person.  A certified electronic signature (such as DocuSign) is acceptable.\n\nThe providers representative that signs the invoice will be used as a starting point if there are questions regarding the invoice package, and will be considered as  the person accountable for the allowable invoice amount being billed  for the specific work authorization (WA) and  for the Prompt Payment  certification statement according to the terms of the contract.  Additionally,  the provider’s PM should be contacted if there are issues regarding the invoice package. \n\n"]
["Name\n\n","Enter name of person signing the invoice.  Signature and Printed Name must be the same person. \n"]
["Title","Enter the title of the individual who signed the invoice."]
["Phone No.\n\n\n","Enter the phone number for the individual who signed the form.  "]
["Email Address\n\n","Enter the email address for the person that is signing the invoice and responsible for the certification of the invoice package, and will be the person that can answer any questions regarding the invoice or prompt payment."]
["Provider Invoice Date\n\n","Enter the date that the invoice is being submitted to TxDOT. Note:  Make sure that the date entered is the same date that the invoice package is emailed to the PEPS Invoice Center for processing."]
["TxDOT USE ONLY"]
["This section will be completed by TxDOT.  \n\n\n"]
["WORK AUTHORIZATION FINANCIAL STATUS SUMMARY",null,"Link to WA Financial Status Tab"]
["Cell Heading\n"]
["Provider Invoice No.\n\n","The following group of cells will automatically be populated from the data entered into the Invoice and Signature Authority tabs.  Reference instructions for these cells under the sections for Invoice and Signature Authority."]
["Combined Invoice Template Log No."]
["Provider Name\n\n"]
["Provider ID"]
["Legacy Contract No."]
["Legacy WA No."]
["WORK AUTHORIZATION FINANCIAL SUMMARY"]
["WA Authorized Amount  ","Automatically populated from the Invoice tab WA Amount cell (Cell E11).  "]
["Previous Invoiced Amount\n(Required cell)","Enter the accumulative total amount invoiced to date for this WA.  Include the total amount for all invoices that have been submitted to TxDOT for processing, including any supplementary invoices."]
["Total Combined Invoice Amount \n(Including any supplemental invoices, if applicable.)","Automatically populated cell.  This amount is populated from the Signature Authority tab.  "]
["Total Invoiced to Date\n(Including this Invoice and any supplements.)","Automatically calculated.  Note:  This amount will be a total of Previous Invoiced Amount and Total Combined Invoice Amount. "]
["Balance Remaining","Automatically calculated  This amount will be the Authorized Amount minus Total Invoiced to Date (including this invoice and any supplements).  \n"]
["DELIVERABLE SUMMARY TAB",null,"Link to Deliverable Summary"]
["Cell Heading\n"]
["Provider Invoice No.\n\n","The following group of cells will automatically be populated from the data entered into the Invoice and Signature Authority tabs.  Reference instructions for these cells under the sections for Invoice and Signature Authority."]
["Combined Invoice Template Log No."]
["Provider Name\n\n"]
["Provider ID"]
["Legacy Contract No."]
["Legacy WA No."]
["DELIVERABLE BREAKDOWN BY CSJ/DETAIL NUMBER/FUNCTION CODE"]
["PROJECT\nCSJ/Detail Number","Click on Cell A43 and a drop down menu will appear.  Scroll up or down the menu bar to select the Project (CSJ/Detail No.) that is applicable to the services being provided for the particular billing period. The drop down menu is setup using the Master Project (CSJ/Detail No.) List tab.  Any additional Project (CSJ/Detail No.) must be added to that list in order to be selected for use in billing.  Only select the Project (CSJ/Detail No's.) that are applicable to the particular billing period.  The selected Project (CSJ/Detail No.) in the Labor Summary (Office) will auto populate the corresponding \"Subtotal Line No.\" in  all corresponding tabs within this Invoice Template workbook. (Ex:  The Project  (CSJ/Detail No )selected from the drop down menu in Cell A43, will automatically populate Cells A13:A42 with the same Project (CSJ/Detail No.).  \n\nIf there are multiple Project (CSJ/Detail No's.) associated with the project, then each number will be listed as a separate line item.  Note:  The line items by Project (CSJ/Detail No's.) will automatically populate corresponding subtotal  line numbers in other tabs in this workbook.  Repeat this action for each CSJ/Detail number associated with this particular billing cycle.  If there are multiple CSJ/Detail numbers associated with the project, then each CSJ/Detail  number will be listed as a separate line item into Cells A43, A74, etc.\n\nNote:  The line items by CSJ/Detail will automatically populate corresponding line numbers in other tabs in this package.  If the information is not correct here, it will not be correct throughout the invoice package, so it is very important that the information entered into these cells are correct.  "]
["SOURCE \n(Legacy Function Code)\n\n\n\n","Select the appropriate 3 digit number from the drop down menu for each subtotal line (Ex:  Cell B43, B734.).  The provider will submit their monthly invoice by the CSJ/Detail number and Legacy FC detail applicable to the billing period.  (The Legacy FC used will automatically be converted to the New \"PeopleSoft\" FC in the Chart of Accounts (COA) Invoice Conversion tab. The Function Code is based on the scope of work in the WA or the Contract.   \n\nReference and use the Legacy Function Code (FC) from the FC List tab that is applicable to the work provided, as indicted in the FC List tab tab.  The TxDOT PM will assist to ensure that the correct FCs are used.  "]
["Deliverable Description \n","Enter a complete description of the deliverable as shown in the Table of Deliverables in the WA.  The line items entered will only be for those deliverables that have been completed, submitted and accepted by the TxDOT PM for the particular billing cycle.  The deliverable description will need to clearly identify the deliverable submitted to the TxDOT for payment.  Once each line number has been populated, click on the drop down menu button (Cell D20) by clicking on \"blanks\" from the drop down list to remove the checkmark, and the tab will roll up to remove unused rows."]
["Deliverable Amount\n","Enter the allowable amount to be billed for the deliverable that has been completed, submitted and accepted by the TxDOT PM.  The amount billed must match line item for deliverable as shown in the Table of Deliverables (TOD) for the particular WA or Specific Deliverable (SD) contract without WAs.  Payments are based upon each line item shown in the TOD.  Partial payment shown by line item in the TOD are not allowed.  "]
["Total\n(Subtotal Lines 1-50)","Automatically populated cell by formula.  This will be the sum of the cells for all Subtotal Line #’s (1-50) for this CSJ/FC in column I.\n"]
["DELIVERABLE DETAIL"]
["Deliverable Date\n","Enter the date that the deliverables were accepted  and approved by the TxDOT PM. (Note:  This date should match the End Service Date shown on the Invoice tab (Cell C13)."]
["Deliverable Description \n","Enter a complete description of the deliverable as shown in the Table of Deliverables (TOD) in the WA.  The deliverable description will need to clearly identify the deliverable submitted to the TxDOT PM for payment.  The deliverables by line item should be in alignment with the Table of Deliverables that is part of the particular WA.\n\nNote:  The deliverable description shown here should match the description shown under the same heading under Deliverable Breakdown by CSJ/Detail Number/FC above, starting with Cell C13.  "]
["% of Total","Automatically populated cell by formula.  "]
["Total Deliverable Amount\n","Automatically populated cell by formula. "]
["Total Amount of Invoice \n","Automatically populated cell by formula."]

{"sheet":"FC List","index":1,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,3,2,4],[2,0,3,0],[1,0,1,4],[0,0,0,4],[6,0,8,0],[9,0,15,0],[19,0,20,0],[21,0,29,0],[32,0,39,0],[6,2,8,2],[6,1,8,1],[32,2,39,2],[32,1,39,1],[21,2,29,2],[21,1,29,1],[19,1,20,1],[19,2,20,2],[9,2,15,2],[9,1,15,1]]}
["Professional Engineering Procurement Services (PEPS) Division"]
["Eleven FCs have been consolidated from the legacy Thirty Three (33) FCs, as shown below.  "]
["PC Bus Unit","New Function Codes (ERP Function Codes)",null,"Legacy Function Codes"]
[null,"FC ","Description ","FC ","Description "]
[72,"000","General","000","General"]
[72,100,"General PE",100,"General PE"]
[76,100,"Pre-DES Funding Agreement Work ",180,"District Design Review and Processing"]
[null,null,null,181,"Austin Office Processing (State prepared PS& E)"]
[null,null,null,182,"Austin Office Processing (Consultant Prepared PS& E)"]
[76,102,"Feasibility Studies",102,"Feasibility Studies"]
[null,null,null,110,"Route and Design Studies"]
[null,null,null,126,"Donated Items or Services"]
[null,null,null,146,"Rework by TxDOT of complete consultant plans on advance PE projects. Advance PE are activities in function codes 102 through 150."]
[null,null,null,169,"Donated Items or Services"]
[null,null,null,191,"Toll Feasibility Studies"]
[null,null,null,195,"Rail Division - PE"]
[76,120,"Social/Econ/Environ Studies",120,"Social, Economic and Environmental Studies and Public Involvement"]
[76,130,"Right-of-Way Survey",130,"Right of Way Survey (State or Contract Provided)"]
[76,135,"Right-of-Way Utility Activities",135,"Right of Way Data Utility Engineering Investigation along with Utility Coordination and Accommodation"]
[76,145,"Managing Contracted/Donated PE",145,"Managing Contracted or Donated Advance PE Services. "]
[null,null,null,164,"Managing Contracted or Donated PS&E PE Services.  "]
[76,160,"Roadway Design",150,"Field Surveying and Photogrammetry"]
[null,null,null,160,"Roadway Design Controls (Computations and Drafting)"]
[null,null,null,161,"Drainage"]
[null,null,null,162,"Signing, Pavement Markings, Signalization (Permanent)"]
[null,null,null,163,"Miscellaneous (Roadway)"]
[null,null,null,165,"Traffic Management Systems (Permanent)"]
[null,null,null,166,"Rework By TxDOT Of Completed Consultant Plans on PE & E projects. \nPS&E PE are activities in Function Codes 160 through 190. \nRework Segment 76 FCs 160-190 for metric conversion. \nRework existing PS&E to metric units on projects already into plan preparation."]
[null,null,null,170,"Bridge Design"]
[null,null,null,190,"Other pre-letting date charges, not otherwise classified. "]
[76,192,"District and Division CDA",192,"Comprehensive Development Agreement Procurement"]
[76,193,"Toll Collection Planning",193,"Toll Collection "]
[76,300,"General Function",310,"Project Supervision"]
[null,null,null,320,"Inspection of Work in Progress and Project Records"]
[null,null,null,330,"Job Control"]
[null,null,null,340,"Post Letting Date Construction Surveys for Construction Contracts. "]
[null,null,null,350,"Design Verification, Changes and Alterations (State prepared plans only)"]
[null,null,null,351,"Design Verification, Changes and Alterations (Consultant prepared plans only)\nReview of plans to verify applicability to actual conditions and for errors; checking Shop Drawings, Field Change Requests, Extra Work Orders, Memorandum Agreements and Supplement Agreements. \nIncludes such activities at both residency and district headquarters. \nIncludes all costs to acquire and manage consultant contracts and services applicable to Construction Engineering (CE)."]
[null,null,null,352,"Final Plan Preparation"]
[null,null,null,390,"Construction Engineering not Otherwise Classified"]

{"sheet":"Master CSJ List","index":2,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Master Project (CSJ or Detail No.)\n\nThe approved Project (CSJ or Detail No's.) will be provided by the TxDOT Project Manager (PM) for the particular Work Authorization (WA).  \n\nThe Project (CSJ or Detail No's) shown below will auto populate the drop down menu of the Deliverable Summary tab of this Invoice Template.  Click on the drop down menu starting with Cell A43, A74, etc. to select the applicable CSJ.\n\nAll corresponding tabs in the Invoice Template will be auto populated with corresponding Subtotal Line No's that have been selected using the drop down menu in the Deliverable Summary tab for the particular billing period.  \n\nNote:  Not all Project (CSJ or Detail No.'s) n this list will be used for every billing period.  "]
["Subtotal Line No.","Project (CSJ or Detail No.)",null,null,null,null,"Instructions","Click here for instructions for this tab"]
[1,null,null,null,"000"]
[2,null,null,null,"100"]
[3,null,null,null,"102"]
[4,null,null,null,"110"]
[5,null,null,null,"120"]
[6,null,null,null,"130"]
[7,null,null,null,"135"]
[8,null,null,null,"145"]
[9,null,null,null,"146"]
[10,null,null,null,"150"]
[11,null,null,null,"160"]
[12,null,null,null,"161"]
[13,null,null,null,"162"]
[14,null,null,null,"163"]
[15,null,null,null,"164"]
[16,null,null,null,"165"]
[17,null,null,null,"166"]
[18,null,null,null,"169"]
[19,null,null,null,"170"]
[20,null,null,null,"180"]
[21,null,null,null,"181"]
[22,null,null,null,"182"]
[23,null,null,null,"190"]
[24,null,null,null,"191"]
[25,null,null,null,"192"]
[26,null,null,null,"193"]
[27,null,null,null,"195"]
[28,null,null,null,"310"]
[29,null,null,null,"320"]
[30,null,null,null,"330"]
[31,null,null,null,"340"]
[32,null,null,null,"350"]
[33,null,null,null,"351"]
[34,null,null,null,"352"]
[35,null,null,null,"390"]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]

{"sheet":"Invoice","index":3,"n_rows":135,"n_cols":34,"rows_kept":135,"cut":false,"hidden":false,"merged":[[28,32,29,33],[16,32,17,32],[19,2,19,7],[20,2,20,7],[21,2,21,7],[22,2,22,7],[93,4,93,5],[85,4,85,5],[86,4,86,5],[23,2,23,7],[24,2,24,7],[25,2,25,7],[29,8,30,8],[29,2,30,2],[29,3,30,3],[29,4,30,4],[29,5,30,5],[29,6,30,6],[29,7,30,7],[123,4,123,5],[113,4,113,5],[117,4,117,5],[114,4,114,5],[115,4,115,5],[122,4,122,5],[118,4,118,5],[119,4,119,5],[120,4,120,5],[121,4,121,5],[134,4,134,5],[129,4,129,5],[130,4,130,5],[131,4,131,5],[132,4,132,5],[126,4,126,5],[127,4,127,5],[128,4,128,5],[133,4,133,5],[125,4,125,5],[14,0,14,1],[15,0,15,7],[13,0,13,1],[14,5,14,7],[124,4,124,5],[116,4,116,5],[90,4,90,5],[99,4,99,5],[104,4,104,5],[105,4,105,5],[106,4,106,5],[107,4,107,5],[101,4,101,5],[102,4,102,5],[103,4,103,5],[110,4,110,5],[18,2,18,7],[28,0,28,7],[87,4,87,5],[84,4,84,5],[81,5,81,7],[83,0,83,7],[81,0,81,2],[16,0,17,0],[16,1,17,1],[16,2,17,7],[26,2,26,7],[27,2,27,7],[109,4,109,5],[108,4,108,5],[111,4,111,5],[112,4,112,5],[100,4,100,5],[98,4,98,5],[89,4,89,5],[88,4,88,5],[94,4,94,5],[95,4,95,5],[91,4,91,5],[92,4,92,5],[96,4,96,5],[97,4,97,5],[29,0,30,0],[29,1,30,1],[7,0,7,1],[8,0,8,1],[8,2,8,3],[7,2,7,3],[12,0,12,1],[12,2,12,3],[9,0,9,3],[10,0,10,3],[11,0,11,1],[11,2,11,3],[0,6,0,7],[1,6,1,7],[2,6,2,7],[5,0,5,7],[6,0,6,1],[6,5,6,7],[6,2,6,3],[3,6,3,7],[3,3,4,3],[3,2,4,2],[0,1,0,3],[9,5,9,7],[13,2,13,3],[13,5,13,6],[4,6,4,7],[12,5,12,7],[11,5,11,7],[10,5,10,7],[7,5,7,7],[8,5,8,7]]}
[null,"Template Updated: Sept 2023 -Ver 11",null,null,"Provider Invoice No.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,"Combined Invoice Template Log No.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,"Master Template Cell"]
[null,null,null,null,"PeopleSoft (PS) Contract No.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,"Monthly Submittal Cell"]
[null,null,"Provider Invoice Date",{"$f":"'Signature Authority'!B31","v":"00:00:00"},"PS Work Authorization (WA) PO No.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,"Instructions","Click here for instructions for this tab"]
[null,null,null,null,"TxDOT Invoice No.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["INVOICE"]
["Provider Name:  ",null,null,null,"Legacy Contract No.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost Plus Fixed Fee"]
["Provider ID No.",null,null,null,"Contract Amount:  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lump Sum"]
["Remittance Address:",null,null,null,"Contract Expiration Date: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Specified Rate"]
[null,null,null,null,"Legacy WA No.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Specified Rate/Unit Cost"]
[null,null,null,null,"WA  Authorized Amount:  ",null,null,null,null,{"$f":"IF(F11=\"\",\"For SD Contracts without WAs, enter contract amount for WA Authorized Amount.\",\"\")","v":"For SD Contracts without WAs, enter contract amount for WA Authorized Amount."}]
["Deliverables Submittal Date:  ",null,null,null,"WA Execution Date:",null,null,null,null,{"$f":"IF(F12=\"\",\"For SD Contracts without WAs, enter Contract Execution Date in WA Execution Date.\",\"\")","v":"For SD Contracts without WAs, enter Contract Execution Date in WA Execution Date."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DBE"]
["Deliverables Accepted Date:  ",null,null,null,"WA Expiration Date: ",null,null,null,null,{"$f":"IF(F13=\"\",\"For SD Contracts without WAs, enter Contract Expiration Date in WA Expiration Date.\",\"\")","v":"For SD Contracts without WAs, enter Contract Expiration Date in WA Expiration Date."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUB"]
["WA Project Manager (Provider):",null,null,null,"WA Payment Type(s) for this WA:  ",null,null,null,null,{"$f":"IF(F14=\"\",\"For SD Contracts WA Payment Type(s) is the same as the Contract Payment type(s)\",\"\")","v":"For SD Contracts WA Payment Type(s) is the same as the Contract Payment type(s)"}]
["DBE/HUB Goal Assignment for Contract and %:",null,null,null,"WA Project Manager (TxDOT):  "]
["INVOICE SUMMARY"]
["AY\n(App/Fiscal Yr)\n4 digit","DEPT\n(Budget Acct\nSource Unit)","Project Description",null,null,null,null,null,null,null,null,"FC,DDO,CSJ,Account,PCBU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Is this a Consultant Engineering Contract (CEC)?"]
[null,null,null,null,null,null,null,null,null,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(AH17=\"Yes\",\"push: \nctrl a\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["INVOICE DETAIL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FC to ACCT (Object of Expenditure) Conversion"]
["Line No.","DD\n(DIST/DIV \nBudget No.)","PCBU\n(Enter 2 Digit Seg ID  No. Only)","PROJECT\n(CSJ or Detail No.)","AMOUNT","SOURCE\n(Legacy Function Code)","ACCT\n(Object of Expenditure)","(TxDOT Use Only) SFI Code","DEPT \n(Budget Acct Source Unit)"]
[null,null,null,null,null,null,null,null,null,null,"Helper","Concat","Amount","Source Type","Account","Approp","PC Business ","Unique Concats","Sum","Account","Approp","Fund","PC Bus","Project","Activity",null,null,null,null,null,null,null,"FC (Legacy FC)","ACCT"]
[1,null,null,{"$f":"IF('Deliverable Summary'!A43=0,\"\",'Deliverable Summary'!A43)","v":""},{"$f":"'Deliverable Summary'!J43","v":0},{"$f":"'Deliverable Summary'!B43","v":0},null,{"$f":"IF(C32>0,Y32,\"\")","v":""},null,null,1,{"$f":"IF(N32>0,CONCATENATE(N32,X32,O32,C32),\"\")","v":""},{"$f":"IF(E32> 0,E32,\"\")","v":""},{"$f":"IF(OR(F32=\"180\",F32=\"181\",F32=\"182\"),100,IF(OR(F32=\"102\",F32=\"110\",F32=\"126\",F32=\"146\",F32=\"169\",F32=\"191\",F32=\"195\"),102,IF(F32=\"120\",\"120\",IF(F32=\"130\",\"130\",IF(OR(F32=\"145\",F32=\"164\"),145,IF(OR(F32=\"150\"),150,IF(OR(F32=\"160\",F32=\"161\",F32=\"162\",F32=\"163\",F32=\"165\",F32=\"166\",F32=\"170\",F32=\"190\"),160,IF(F32=\"192\",192,IF(F32=\"193\",193,IF(OR(F32=\"310\",F32=\"320\",F32=\"330\",F32=\"340\",F32=\"350\",F32=\"351\",F32=\"352\",F32=\"390\"),300,\"\"))))))))))","v":""},{"$f":"IF(G32=\"\",\"\",IF(OR(G32=421,G32=7253),7253,IF(G32=437,7223,7256)))","v":""},{"$f":"IF(N32=\"\",\"\",IF(N32=\"130\",13020,13035))","v":""},{"$f":"IF(C32>0,CONCATENATE(\"601\", C32),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-20,$K$32:$Q$81,2,FALSE),\"\")","v":""},{"$f":"SUMIF($L$32:L81,R32,$M$32:$M$81)","v":0},{"$f":"VLOOKUP(R32,$L$32:$Q$81,4,FALSE)","v":""},{"$f":"VLOOKUP(R32,$L$32:$Q$81,5,FALSE)","v":""},{"$f":" IF(R32<>\"\",\"0006\",\"\")","v":""},{"$f":"VLOOKUP(R32,$L$32:$Q$81,6,FALSE)","v":""},{"$f":"CONCATENATE(B32,SUBSTITUTE(D32,\"-\",\"\"))","v":""},{"$f":"IF(N32=\"\",\"PE\",IF(N32<=192,\"PE\",IF(N32=300,\"CE\",\"PE\")))","v":"PE"},null,null,null,null,null,null,null,"100 (180)",7256]
[2,null,null,{"$f":"IF('Deliverable Summary'!A74=0,\"\",'Deliverable Summary'!A74)","v":""},{"$f":"'Deliverable Summary'!J74","v":0},{"$f":"'Deliverable Summary'!B74","v":0},null,{"$f":"IF(C33>0,Y33,\"\")","v":""},null,null,{"$f":"IF(COUNTIF($L$32:L33,L33)=1,K32+1,K32)","v":1},{"$f":"IF(N33>0,CONCATENATE(N33,X33,O33,C33),\"\")","v":""},{"$f":"IF(E33> 0,E33,\"\")","v":""},"",{"$f":"IF(G33=\"\",\"\",IF(OR(G33=421,G33=7253),7253,IF(G33=437,7223,7256)))","v":""},{"$f":"IF(N33=\"\",\"\",IF(N33=\"130\",13020,13035))","v":""},{"$f":"IF(C33>0,CONCATENATE(\"601\", C33),\"\")","v":""},"",{"$f":"SUMIF($L$32:L82,R33,$M$32:$M$81)","v":0},{"$f":"VLOOKUP(R33,$L$32:$Q$81,4,FALSE)","v":""},{"$f":"VLOOKUP(R33,$L$32:$Q$81,5,FALSE)","v":""},{"$f":" IF(R33<>\"\",\"0006\",\"\")","v":""},{"$f":"VLOOKUP(R33,$L$32:$Q$81,6,FALSE)","v":""},{"$f":"CONCATENATE(B33,SUBSTITUTE(D33,\"-\",\"\"))","v":""},{"$f":"IF(N33=\"\",\"PE\",IF(N33<=192,\"PE\",IF(N33=300,\"CE\",\"PE\")))","v":"PE"},null,null,null,null,null,null,null,"100 (181)",7256]
[3,null,null,{"$f":"IF('Deliverable Summary'!A105=0,\"\",'Deliverable Summary'!A105)","v":""},{"$f":"'Deliverable Summary'!J105","v":0},{"$f":"'Deliverable Summary'!B105","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L34,L34)=1,K33+1,K33)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L83,R34,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"100 (182)",7256]
[4,null,null,{"$f":"IF('Deliverable Summary'!A136=0,\"\",'Deliverable Summary'!A136)","v":""},{"$f":"'Deliverable Summary'!J136","v":0},{"$f":"'Deliverable Summary'!B136","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L35,L35)=1,K34+1,K34)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L84,R35,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"102 (102)",7256]
[5,null,null,{"$f":"IF('Deliverable Summary'!A167=0,\"\",'Deliverable Summary'!A167)","v":""},{"$f":"'Deliverable Summary'!J167","v":0},{"$f":"'Deliverable Summary'!B167","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L36,L36)=1,K35+1,K35)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L85,R36,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"102 (110)",7256]
[6,null,null,{"$f":"IF('Deliverable Summary'!A198=0,\"\",'Deliverable Summary'!A198)","v":""},{"$f":"'Deliverable Summary'!J198","v":0},{"$f":"'Deliverable Summary'!B198","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L37,L37)=1,K36+1,K36)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L86,R37,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"102 (126)",7256]
[7,null,null,{"$f":"IF('Deliverable Summary'!A229=0,\"\",'Deliverable Summary'!A229)","v":""},{"$f":"'Deliverable Summary'!J229","v":0},{"$f":"'Deliverable Summary'!B229","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L38,L38)=1,K37+1,K37)","v":1},"","",{"$f":"IF(OR(F38=180,F38=181,F38=182),100,IF(OR(F38=102,F38=110,F38=126,F38=146,F38=169,F38=191,F38=195),102,IF(F38=120,120,IF(F38=130,130,IF(OR(F38=145,F38=164),145,IF(OR(F38=150),150,IF(OR(F38=160,F38=161,F38=162,F38=163,F38=165,F38=166,F38=170,F38=190),160,IF(F38=192,192,IF(F38=193,193,IF(OR(F38=310,F38=320,F38=330,F38=340,F38=350,F38=351,F38=352,F38=390),300,\"\"))))))))))","v":""},"","","","",{"$f":"SUMIF($L$32:L87,R38,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"102 (146)",7256]
[8,null,null,{"$f":"IF('Deliverable Summary'!A260=0,\"\",'Deliverable Summary'!A260)","v":""},{"$f":"'Deliverable Summary'!J260","v":0},{"$f":"'Deliverable Summary'!B260","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L39,L39)=1,K38+1,K38)","v":1},"","",{"$f":"IF(OR(F39=180,F39=181,F39=182),100,IF(OR(F39=102,F39=110,F39=126,F39=146,F39=169,F39=191,F39=195),102,IF(F39=120,120,IF(F39=130,130,IF(OR(F39=145,F39=164),145,IF(OR(F39=150),150,IF(OR(F39=160,F39=161,F39=162,F39=163,F39=165,F39=166,F39=170,F39=190),160,IF(F39=192,192,IF(F39=193,193,IF(OR(F39=310,F39=320,F39=330,F39=340,F39=350,F39=351,F39=352,F39=390),300,\"\"))))))))))","v":""},"","","","",{"$f":"SUMIF($L$32:L88,R39,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"102 (169)",7256]
[9,null,null,{"$f":"IF('Deliverable Summary'!A291=0,\"\",'Deliverable Summary'!A291)","v":""},{"$f":"'Deliverable Summary'!J291","v":0},{"$f":"'Deliverable Summary'!B291","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L40,L40)=1,K39+1,K39)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L89,R40,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"102 (191)",7256]
[10,null,null,{"$f":"IF('Deliverable Summary'!A322=0,\"\",'Deliverable Summary'!A322)","v":""},{"$f":"'Deliverable Summary'!J322","v":0},{"$f":"'Deliverable Summary'!B322","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L41,L41)=1,K40+1,K40)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L90,R41,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"102 (195)",7256]
[11,null,null,{"$f":"IF('Deliverable Summary'!A353=0,\"\",'Deliverable Summary'!A353)","v":""},{"$f":"'Deliverable Summary'!J353","v":0},{"$f":"'Deliverable Summary'!B353","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L42,L42)=1,K41+1,K41)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L91,R42,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"120 (120)",7256]
[12,null,null,{"$f":"IF('Deliverable Summary'!A384=0,\"\",'Deliverable Summary'!A384)","v":""},{"$f":"'Deliverable Summary'!J384","v":0},{"$f":"'Deliverable Summary'!B384","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L43,L43)=1,K42+1,K42)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L92,R43,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"130 (130)",7253]
[13,null,null,{"$f":"IF('Deliverable Summary'!A415=0,\"\",'Deliverable Summary'!A415)","v":""},{"$f":"'Deliverable Summary'!J415","v":0},{"$f":"'Deliverable Summary'!B415","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L44,L44)=1,K43+1,K43)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L93,R44,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"135 (135)",7256]
[14,null,null,{"$f":"IF('Deliverable Summary'!A446=0,\"\",'Deliverable Summary'!A446)","v":""},{"$f":"'Deliverable Summary'!J446","v":0},{"$f":"'Deliverable Summary'!B446","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L45,L45)=1,K44+1,K44)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L94,R45,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"145 (145)",7256]
[15,null,null,{"$f":"IF('Deliverable Summary'!A477=0,\"\",'Deliverable Summary'!A477)","v":""},{"$f":"'Deliverable Summary'!J477","v":0},{"$f":"'Deliverable Summary'!B477","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L46,L46)=1,K45+1,K45)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L95,R46,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"145 (164)",7256]
[16,null,null,{"$f":"IF('Deliverable Summary'!A508=0,\"\",'Deliverable Summary'!A508)","v":""},{"$f":"'Deliverable Summary'!J508","v":0},{"$f":"'Deliverable Summary'!B508","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L47,L47)=1,K46+1,K46)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L96,R47,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"160 (150)",7253]
[17,null,null,{"$f":"IF('Deliverable Summary'!A539=0,\"\",'Deliverable Summary'!A539)","v":""},{"$f":"'Deliverable Summary'!J539","v":0},{"$f":"'Deliverable Summary'!B539","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L48,L48)=1,K47+1,K47)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L97,R48,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"160 (160)",7256]
[18,null,null,{"$f":"IF('Deliverable Summary'!A570=0,\"\",'Deliverable Summary'!A570)","v":""},{"$f":"'Deliverable Summary'!J570","v":0},{"$f":"'Deliverable Summary'!B570","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L49,L49)=1,K48+1,K48)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L98,R49,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"160 (161)",7256]
[19,null,null,{"$f":"IF('Deliverable Summary'!A601=0,\"\",'Deliverable Summary'!A601)","v":""},{"$f":"'Deliverable Summary'!J601","v":0},{"$f":"'Deliverable Summary'!B601","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L50,L50)=1,K49+1,K49)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L99,R50,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"160 (162)",7256]
[20,null,null,{"$f":"IF('Deliverable Summary'!A632=0,\"\",'Deliverable Summary'!A632)","v":""},{"$f":"'Deliverable Summary'!J632","v":0},{"$f":"'Deliverable Summary'!B632","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L51,L51)=1,K50+1,K50)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L100,R51,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"160 (163)",7256]
[21,null,null,{"$f":"IF('Deliverable Summary'!A663=0,\"\",'Deliverable Summary'!A663)","v":""},{"$f":"'Deliverable Summary'!J663","v":0},{"$f":"'Deliverable Summary'!B663","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L52,L52)=1,K51+1,K51)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L101,R52,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"160 (165)",7256]
[22,null,null,{"$f":"IF('Deliverable Summary'!A694=0,\"\",'Deliverable Summary'!A694)","v":""},{"$f":"'Deliverable Summary'!J694","v":0},{"$f":"'Deliverable Summary'!B694","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L53,L53)=1,K52+1,K52)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L102,R53,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"160 (166)",7256]
[23,null,null,{"$f":"IF('Deliverable Summary'!A725=0,\"\",'Deliverable Summary'!A725)","v":""},{"$f":"'Deliverable Summary'!J725","v":0},{"$f":"'Deliverable Summary'!B725","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L54,L54)=1,K53+1,K53)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L103,R54,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"160 (170)",7256]
[24,null,null,{"$f":"IF('Deliverable Summary'!A756=0,\"\",'Deliverable Summary'!A756)","v":""},{"$f":"'Deliverable Summary'!J756","v":0},{"$f":"'Deliverable Summary'!B756","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L55,L55)=1,K54+1,K54)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L104,R55,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"160 (190)",7256]
[25,null,null,{"$f":"IF('Deliverable Summary'!A787=0,\"\",'Deliverable Summary'!A787)","v":""},{"$f":"'Deliverable Summary'!J787","v":0},{"$f":"'Deliverable Summary'!B787","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L56,L56)=1,K55+1,K55)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L105,R56,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"192 (192)",7256]
[26,null,null,{"$f":"IF('Deliverable Summary'!A818=0,\"\",'Deliverable Summary'!A818)","v":""},{"$f":"'Deliverable Summary'!J818","v":0},{"$f":"'Deliverable Summary'!B818","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L57,L57)=1,K56+1,K56)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L106,R57,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"193 (193)",7256]
[27,null,null,{"$f":"IF('Deliverable Summary'!A849=0,\"\",'Deliverable Summary'!A849)","v":""},{"$f":"'Deliverable Summary'!J849","v":0},{"$f":"'Deliverable Summary'!B849","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L58,L58)=1,K57+1,K57)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L107,R58,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"300 (310)",7256]
[28,null,null,{"$f":"IF('Deliverable Summary'!A880=0,\"\",'Deliverable Summary'!A880)","v":""},{"$f":"'Deliverable Summary'!J880","v":0},{"$f":"'Deliverable Summary'!B880","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L59,L59)=1,K58+1,K58)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L108,R59,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"300 (320)",7256]
[29,null,null,{"$f":"IF('Deliverable Summary'!A911=0,\"\",'Deliverable Summary'!A911)","v":""},{"$f":"'Deliverable Summary'!J911","v":0},{"$f":"'Deliverable Summary'!B911","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L60,L60)=1,K59+1,K59)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L109,R60,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"300 (330)",7256]
[30,null,null,{"$f":"IF('Deliverable Summary'!A942=0,\"\",'Deliverable Summary'!A942)","v":""},{"$f":"'Deliverable Summary'!J942","v":0},{"$f":"'Deliverable Summary'!B942","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L61,L61)=1,K60+1,K60)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L110,R61,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"300 (340)",7256]
[31,null,null,{"$f":"IF('Deliverable Summary'!A973=0,\"\",'Deliverable Summary'!A973)","v":""},{"$f":"'Deliverable Summary'!J973","v":0},{"$f":"'Deliverable Summary'!B973","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L62,L62)=1,K61+1,K61)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L111,R62,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"300 (350)",7256]
[32,null,null,{"$f":"IF('Deliverable Summary'!A1004=0,\"\",'Deliverable Summary'!A1004)","v":""},{"$f":"'Deliverable Summary'!J1004","v":0},{"$f":"'Deliverable Summary'!B1004","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L63,L63)=1,K62+1,K62)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L112,R63,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"300 (351)",7256]
[33,null,null,{"$f":"IF('Deliverable Summary'!A1035=0,\"\",'Deliverable Summary'!A1035)","v":""},{"$f":"'Deliverable Summary'!J1035","v":0},{"$f":"'Deliverable Summary'!B1035","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L64,L64)=1,K63+1,K63)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L113,R64,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"300 (352)",7256]
[34,null,null,{"$f":"IF('Deliverable Summary'!A1066=0,\"\",'Deliverable Summary'!A1066)","v":""},{"$f":"'Deliverable Summary'!J1066","v":0},{"$f":"'Deliverable Summary'!B1066","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L65,L65)=1,K64+1,K64)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L114,R65,$M$32:$M$81)","v":0},"","","","","","PE",null,null,null,null,null,null,null,"300 (390)",7256]
[35,null,null,{"$f":"IF('Deliverable Summary'!A1097=0,\"\",'Deliverable Summary'!A1097)","v":""},{"$f":"'Deliverable Summary'!J1097","v":0},{"$f":"'Deliverable Summary'!B1097","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L66,L66)=1,K65+1,K65)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L115,R66,$M$32:$M$81)","v":0},"","","","","","PE"]
[36,null,null,{"$f":"IF('Deliverable Summary'!A1128=0,\"\",'Deliverable Summary'!A1128)","v":""},{"$f":"'Deliverable Summary'!J1128","v":0},{"$f":"'Deliverable Summary'!B1128","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L67,L67)=1,K66+1,K66)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L116,R67,$M$32:$M$81)","v":0},"","","","","","PE"]
[37,null,null,{"$f":"IF('Deliverable Summary'!A1159=0,\"\",'Deliverable Summary'!A1159)","v":""},{"$f":"'Deliverable Summary'!J1159","v":0},{"$f":"'Deliverable Summary'!B1159","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L68,L68)=1,K67+1,K67)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L117,R68,$M$32:$M$81)","v":0},"","","","","","PE"]
[38,null,null,{"$f":"IF('Deliverable Summary'!A1190=0,\"\",'Deliverable Summary'!A1190)","v":""},{"$f":"'Deliverable Summary'!J1190","v":0},{"$f":"'Deliverable Summary'!B1190","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L69,L69)=1,K68+1,K68)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L118,R69,$M$32:$M$81)","v":0},"","","","","","PE"]
[39,null,null,{"$f":"IF('Deliverable Summary'!A1221=0,\"\",'Deliverable Summary'!A1221)","v":""},{"$f":"'Deliverable Summary'!J1221","v":0},{"$f":"'Deliverable Summary'!B1221","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L70,L70)=1,K69+1,K69)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L119,R70,$M$32:$M$81)","v":0},"","","","","","PE"]
[40,null,null,{"$f":"IF('Deliverable Summary'!A1252=0,\"\",'Deliverable Summary'!A1252)","v":""},{"$f":"'Deliverable Summary'!J1252","v":0},{"$f":"'Deliverable Summary'!B1252","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L71,L71)=1,K70+1,K70)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L120,R71,$M$32:$M$81)","v":0},"","","","","","PE"]
[41,null,null,{"$f":"IF('Deliverable Summary'!A1283=0,\"\",'Deliverable Summary'!A1283)","v":""},{"$f":"'Deliverable Summary'!J1283","v":0},{"$f":"'Deliverable Summary'!B1283","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L72,L72)=1,K71+1,K71)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L121,R72,$M$32:$M$81)","v":0},"","","","","","PE"]
[42,null,null,{"$f":"IF('Deliverable Summary'!A1314=0,\"\",'Deliverable Summary'!A1314)","v":""},{"$f":"'Deliverable Summary'!J1314","v":0},{"$f":"'Deliverable Summary'!B1314","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L73,L73)=1,K72+1,K72)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L122,R73,$M$32:$M$81)","v":0},"","","","","","PE"]
[43,null,null,{"$f":"IF('Deliverable Summary'!A1345=0,\"\",'Deliverable Summary'!A1345)","v":""},{"$f":"'Deliverable Summary'!J1345","v":0},{"$f":"'Deliverable Summary'!B1345","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L74,L74)=1,K73+1,K73)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L123,R74,$M$32:$M$81)","v":0},"","","","","","PE"]
[44,null,null,{"$f":"IF('Deliverable Summary'!A1376=0,\"\",'Deliverable Summary'!A1376)","v":""},{"$f":"'Deliverable Summary'!J1376","v":0},{"$f":"'Deliverable Summary'!B1376","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L75,L75)=1,K74+1,K74)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L124,R75,$M$32:$M$81)","v":0},"","","","","","PE"]
[45,null,null,{"$f":"IF('Deliverable Summary'!A1407=0,\"\",'Deliverable Summary'!A1407)","v":""},{"$f":"'Deliverable Summary'!J1407","v":0},{"$f":"'Deliverable Summary'!B1407","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L76,L76)=1,K75+1,K75)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L125,R76,$M$32:$M$81)","v":0},"","","","","","PE"]
[46,null,null,{"$f":"IF('Deliverable Summary'!A1438=0,\"\",'Deliverable Summary'!A1438)","v":""},{"$f":"'Deliverable Summary'!J1438","v":0},{"$f":"'Deliverable Summary'!B1438","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L77,L77)=1,K76+1,K76)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L126,R77,$M$32:$M$81)","v":0},"","","","","","PE"]
[47,null,null,{"$f":"IF('Deliverable Summary'!A1469=0,\"\",'Deliverable Summary'!A1469)","v":""},{"$f":"'Deliverable Summary'!J1469","v":0},{"$f":"'Deliverable Summary'!B1469","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L78,L78)=1,K77+1,K77)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L127,R78,$M$32:$M$81)","v":0},"","","","","","PE"]
[48,null,null,{"$f":"IF('Deliverable Summary'!A1500=0,\"\",'Deliverable Summary'!A1500)","v":""},{"$f":"'Deliverable Summary'!J1500","v":0},{"$f":"'Deliverable Summary'!B1500","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L79,L79)=1,K78+1,K78)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L128,R79,$M$32:$M$81)","v":0},"","","","","","PE"]
[49,null,null,{"$f":"IF('Deliverable Summary'!A1531=0,\"\",'Deliverable Summary'!A1531)","v":""},{"$f":"'Deliverable Summary'!J1531","v":0},{"$f":"'Deliverable Summary'!B1531","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L80,L80)=1,K79+1,K79)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L129,R80,$M$32:$M$81)","v":0},"","","","","","PE"]
[50,null,null,{"$f":"IF('Deliverable Summary'!A1562=0,\"\",'Deliverable Summary'!A1562)","v":""},{"$f":"'Deliverable Summary'!J1562","v":0},{"$f":"'Deliverable Summary'!B1562","v":0},null,"",null,null,{"$f":"IF(COUNTIF($L$32:L81,L81)=1,K80+1,K80)","v":1},"","","","","","","",{"$f":"SUMIF($L$32:L130,R81,$M$32:$M$81)","v":0},"","","","","","PE"]
["Total:",null,null,"blank",{"$f":"SUM(E32:E81)","v":0}]
[]
["Highway Maintenance Detail"]
["Line No.","Task/Work Order","County","System","Highway No.",null,"Suffix","Class"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]

{"sheet":"Signature Authority","index":4,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,1,38,6],[34,1,34,6],[35,1,35,6],[36,0,36,6],[37,1,37,6],[1,4,1,5],[5,0,5,6],[6,0,6,1],[2,4,2,5],[2,6,2,7],[6,2,6,6],[18,0,18,3],[18,4,18,6],[31,0,31,6],[27,1,27,6],[29,1,29,6],[21,0,21,6],[33,1,33,6],[32,0,32,6],[7,0,7,1],[7,2,7,6],[8,0,8,1],[8,2,8,6],[9,2,9,6],[9,0,9,1],[28,1,28,6],[30,1,30,6],[23,0,23,2],[23,5,23,6],[24,0,24,2],[24,5,24,6],[25,1,25,6],[26,1,26,6],[11,0,11,6],[22,0,22,6],[12,0,12,1],[12,4,12,6],[13,0,13,1],[13,4,13,6],[14,0,14,1],[14,4,14,6],[19,0,19,6],[20,0,20,6],[15,0,15,1],[15,4,15,6],[16,0,16,1],[16,4,16,6],[17,0,17,1],[17,4,17,6]]}
[null,null,null,null,null,"Provider Invoice No.  ",{"$f":"Invoice!G1","v":0},null,null,"Master Template Cell"]
[null,null,null,null,"Combined Invoice Template Log No.  ",null,{"$f":"Invoice!G2","v":0},null,null,"Monthly Submittal Cell"]
[null,null,null,null,null,null,null,null,"Instructions","Click here for instructions for this tab"]
[]
[]
["SIGNATURE AUTHORITY PAGE"]
["Legacy Contract No.",null,{"$f":"Invoice!F7","v":0}]
["Legacy WA No.",null,{"$f":"Invoice!F10","v":0}]
["Provider Name:  ",null,{"$f":"Invoice!C7","v":0}]
["Provider ID No. ",null,{"$f":"Invoice!C8","v":0}]
[]
["COMBINED INVOICE SUMMARY \n(Populate Supplementary Template information 2-5 below if using multiple invoice templates for this invoice)"]
["Combined Invoice Templates",null,"Invoice Template Log No.","Reason for Combined Invoice Template Package","Invoice Template Amount"]
["Primary Invoice Template ",null,1,"Primary Invoice Template",{"$f":"'Deliverable Summary'!I1618","v":0},null,null,null,"Supplementary Invoice to Previous Billing"]
["Supplementary Invoice Template ",null,2,null,null,null,null,null,"Add 'l Pmt Method-Lump Sum"]
["Supplementary Invoice Template ",null,3,null,null,null,null,null,"Add 'l Pmt Method-Specified Rate"]
["Supplementary Invoice Template ",null,4,null,null,null,null,null,"Add 'l Pmt Method-Unit Cost"]
["Supplementary Invoice Template ",null,5,null,null,null,null,null,"Add 'l Pmt Method-Cost Plus Fixed Fee"]
["TOTAL COMBINED INVOICE AMOUNT",null,null,null,{"$f":"SUM(E14:G18)","v":0},null,null,null,"Add 'l Template - Adjustment"]
["PROVIDER USE ONLY",null,null,null,null,null,null,null,"Add 'l Template - Add 'l Line Items Necessary"]
["I am duly authorized to certify this invoice on behalf of the above named provider.  I further certify that the claim is correct and is not duplicated on any paid or pending invoice."]
["PROMPT PAYMENT VERIFICATION"]
["I certify that all subproviders, except for any listed on the attached Prompt Payment (PP) Certification form (if applicable) have been paid according to PP law according to the Articles of the contract (within 10 days of receipt of payment) for the billing period indicated below.   I understand that the state will  perform a periodic verification of PP by requesting supporting documentation such as cancelled checks or electronic bank transfers to support PP. (If any subproviders were not paid in accordance with PP, then a completed PP form shall be attached.)"]
["Provider Invoice No. for PP Verification",null,null,"Date Provider Received Payment MM/DD/YY\n(for PP Verification)","Begin Service Date\nMM/DD/YY\n(for PP Verification)","End Service Date\nMM/DD/YY\n(for PP Verification)",null,null,"  "]
[]
["Provider Authorized Signature"]
["Name"]
["Title"]
["Phone # "]
["Email"]
["Provider Invoice Date",null,null,null,null,null,null,null,"This date must be the same date that the invoice is submitted to the PEPS Invoice Center for processing. Verify correct date is auto populated on the Invoice tab - Cell D4."]
["TXDOT USE ONLY"]
["Reviewed By:"]
["Reviewer Signature\nTitle\nDate"]
["Reviewer Signature\nTitle\nDate"]
["Reviewer Signature\nTitle\nDate"]
["Approved By:"]
["Approver Signature\nTitle\nDate"]
["Approver Signature\nTitle\nDate"]

{"sheet":"WA Financial Status Summary","index":5,"n_rows":288,"n_cols":8,"rows_kept":288,"cut":false,"hidden":false,"merged":[[21,0,21,1],[30,0,30,1],[31,0,31,1],[12,0,12,3],[2,0,2,4],[3,0,3,4],[4,0,4,4],[9,0,9,4],[6,1,6,2],[7,1,7,2],[5,0,5,4],[32,0,32,1],[39,0,39,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[41,0,41,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[42,0,42,1],[43,0,43,1],[10,0,10,3],[11,0,11,3],[13,0,13,3],[14,0,14,3],[15,0,15,4],[22,0,22,1],[23,0,23,1],[29,0,29,1],[24,0,24,1],[25,0,25,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[40,0,40,1]]}
[null,null,null,"Provider Invoice No.  ",{"$f":"Invoice!G1","v":0},null,null,"Master Template Cell"]
[null,null,null,"Combined Invoice Template Log No.  ",{"$f":"Invoice!G2","v":0},null,null,"Monthly Submittal Cell"]
[null,null,null,null,null,null,"Instruction","Click here for instructions for this tab"]
["WORK AUTHORIZATION "]
["FINANCIAL STATUS SUMMARY"]
["Lump Sum Payment Method"]
["Provider Name:  ",{"$f":"Invoice!C7","v":0},null,"Legacy Contract No.  ",{"$f":"Invoice!F7","v":0}]
["Provider ID No.  ",{"$f":"Invoice!C8","v":0},null,"Legacy WA No.",{"$f":"Invoice!F10","v":0}]
[]
["Work Authorization Financial Summary"]
["WA Authorized Amount",null,null,null,{"$f":"Invoice!F11","v":0}]
["Previous Invoiced Amount"]
["Total Combined Invoice Amount (including any supplemental invoices, if applicable)",null,null,null,{"$f":"'Signature Authority'!E19:G19","v":0}]
["Total Invoiced to Date (including this invoice and any supplemental, if applicable)  ",null,null,null,{"$f":"E12+E13","v":0}]
["Balance Remaining",null,null,null,{"$f":"E11-E14","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[0]

{"sheet":"Deliverable Summary","index":6,"n_rows":1750,"n_cols":14,"rows_kept":1750,"cut":false,"hidden":false,"merged":[[1562,6,1562,7],[1617,6,1617,7],[5,0,5,9],[1599,0,1599,1],[1600,0,1600,1],[1601,0,1601,1],[1591,0,1591,1],[1605,8,1605,9],[1608,8,1608,9],[1609,8,1609,9],[1610,8,1610,9],[1611,8,1611,9],[1567,8,1567,9],[1568,8,1568,9],[1573,8,1573,9],[1604,8,1604,9],[1569,8,1569,9],[1570,8,1570,9],[1571,8,1571,9],[1596,8,1596,9],[1595,8,1595,9],[1602,8,1602,9],[1603,8,1603,9],[1607,2,1607,6],[1608,2,1608,6],[1605,2,1605,6],[1600,8,1600,9],[1601,8,1601,9],[1598,8,1598,9],[1599,8,1599,9],[1574,2,1574,6],[1575,2,1575,6],[1598,2,1598,6],[1599,2,1599,6],[1593,2,1593,6],[1524,8,1524,9],[1527,2,1527,7],[1527,8,1527,9],[1535,8,1535,9],[1536,2,1536,7],[1536,8,1536,9],[1537,2,1537,7],[1537,8,1537,9],[1535,2,1535,7],[1613,8,1613,9],[1612,8,1612,9],[1576,8,1576,9],[1589,8,1589,9],[1590,8,1590,9],[1591,8,1591,9],[1592,8,1592,9],[1565,0,1565,9],[1544,8,1544,9],[1545,2,1545,7],[1545,8,1545,9],[1547,2,1547,7],[1547,8,1547,9],[1548,2,1548,7],[1548,8,1548,9],[1549,2,1549,7],[1549,8,1549,9],[1566,8,1566,9],[1597,8,1597,9],[1583,0,1583,1],[1584,0,1584,1],[1572,0,1572,1],[1578,0,1578,1],[1493,8,1493,9],[1494,2,1494,7],[1494,8,1494,9],[1491,2,1491,7],[1491,8,1491,9],[1492,2,1492,7],[1492,8,1492,9],[1497,2,1497,7],[1497,8,1497,9],[1513,8,1513,9],[1514,2,1514,7],[1514,8,1514,9],[1531,2,1531,7],[1531,8,1531,9],[1513,2,1513,7],[1530,6,1530,7],[1515,2,1515,7],[1515,8,1515,9],[1516,2,1516,7],[1510,8,1510,9],[1511,2,1511,7],[1511,8,1511,9],[1512,2,1512,7],[1512,8,1512,9],[1510,2,1510,7],[1507,8,1507,9],[1508,2,1508,7],[1508,8,1508,9],[1509,2,1509,7],[1524,2,1524,7],[1463,2,1463,7],[1463,8,1463,9],[1464,2,1464,7],[1464,8,1464,9],[1474,2,1474,7],[1474,8,1474,9],[1475,2,1475,7],[1475,8,1475,9],[1473,2,1473,7],[1504,8,1504,9],[1505,2,1505,7],[1505,8,1505,9],[1506,2,1506,7],[1506,8,1506,9],[1504,2,1504,7],[1501,8,1501,9],[1502,2,1502,7],[1502,8,1502,9],[1503,2,1503,7],[1503,8,1503,9],[1501,2,1501,7],[1482,8,1482,9],[1483,2,1483,7],[1483,8,1483,9],[1500,2,1500,7],[1500,8,1500,9],[1482,2,1482,7],[1499,6,1499,7],[1485,2,1485,7],[1485,8,1485,9],[1486,2,1486,7],[1493,2,1493,7],[1425,2,1425,7],[1425,8,1425,9],[1426,2,1426,7],[1426,8,1426,9],[1451,8,1451,9],[1452,2,1452,7],[1452,8,1452,9],[1469,2,1469,7],[1469,8,1469,9],[1451,2,1451,7],[1468,6,1468,7],[1453,2,1453,7],[1453,8,1453,9],[1454,2,1454,7],[1448,8,1448,9],[1449,2,1449,7],[1449,8,1449,9],[1450,2,1450,7],[1450,8,1450,9],[1448,2,1448,7],[1445,8,1445,9],[1446,2,1446,7],[1446,8,1446,9],[1447,2,1447,7],[1447,8,1447,9],[1445,2,1445,7],[1462,2,1462,7],[1462,8,1462,9],[1465,2,1465,7],[1465,8,1465,9],[1466,2,1466,7],[1466,8,1466,9],[1409,8,1409,9],[1410,2,1410,7],[1410,8,1410,9],[1408,2,1408,7],[1439,2,1439,7],[1420,8,1420,9],[1421,2,1421,7],[1421,8,1421,9],[1438,2,1438,7],[1438,8,1438,9],[1420,2,1420,7],[1437,6,1437,7],[1423,2,1423,7],[1423,8,1423,9],[1424,2,1424,7],[1431,2,1431,7],[1431,8,1431,9],[1432,2,1432,7],[1432,8,1432,9],[1429,2,1429,7],[1429,8,1429,9],[1430,2,1430,7],[1430,8,1430,9],[1435,2,1435,7],[1435,8,1435,9],[1422,2,1422,7],[1422,8,1422,9],[1427,2,1427,7],[1427,8,1427,9],[1428,2,1428,7],[1428,8,1428,9],[1424,8,1424,9],[1400,2,1400,7],[1400,8,1400,9],[1403,2,1403,7],[1403,8,1403,9],[1404,2,1404,7],[1404,8,1404,9],[1401,2,1401,7],[1401,8,1401,9],[1402,2,1402,7],[1402,8,1402,9],[1417,8,1417,9],[1418,2,1418,7],[1418,8,1418,9],[1419,2,1419,7],[1419,8,1419,9],[1417,2,1417,7],[1414,8,1414,9],[1415,2,1415,7],[1415,8,1415,9],[1416,2,1416,7],[1416,8,1416,9],[1414,2,1414,7],[1411,8,1411,9],[1412,2,1412,7],[1412,8,1412,9],[1413,2,1413,7],[1413,8,1413,9],[1411,2,1411,7],[1405,2,1405,7],[1405,8,1405,9],[1408,8,1408,9],[1409,2,1409,7],[1369,2,1369,7],[1369,8,1369,9],[1370,2,1370,7],[1370,8,1370,9],[1367,2,1367,7],[1367,8,1367,9],[1368,2,1368,7],[1368,8,1368,9],[1373,2,1373,7],[1373,8,1373,9],[1389,8,1389,9],[1390,2,1390,7],[1390,8,1390,9],[1407,2,1407,7],[1407,8,1407,9],[1389,2,1389,7],[1406,6,1406,7],[1391,2,1391,7],[1391,8,1391,9],[1392,2,1392,7],[1386,8,1386,9],[1387,2,1387,7],[1387,8,1387,9],[1388,2,1388,7],[1388,8,1388,9],[1386,2,1386,7],[1383,8,1383,9],[1384,2,1384,7],[1384,8,1384,9],[1374,8,1374,9],[1371,2,1371,7],[1342,8,1342,9],[1339,2,1339,7],[1339,8,1339,9],[1340,2,1340,7],[1340,8,1340,9],[1350,2,1350,7],[1350,8,1350,9],[1351,2,1351,7],[1351,8,1351,9],[1349,2,1349,7],[1380,8,1380,9],[1381,2,1381,7],[1381,8,1381,9],[1382,2,1382,7],[1382,8,1382,9],[1380,2,1380,7],[1377,8,1377,9],[1378,2,1378,7],[1378,8,1378,9],[1379,2,1379,7],[1379,8,1379,9],[1377,2,1377,7],[1358,8,1358,9],[1359,2,1359,7],[1359,8,1359,9],[1376,2,1376,7],[1376,8,1376,9],[1358,2,1358,7],[1361,2,1361,7],[1361,8,1361,9],[1341,8,1341,9],[1343,8,1343,9],[1304,8,1304,9],[1300,8,1300,9],[1301,2,1301,7],[1301,8,1301,9],[1302,2,1302,7],[1302,8,1302,9],[1327,8,1327,9],[1328,2,1328,7],[1328,8,1328,9],[1345,2,1345,7],[1345,8,1345,9],[1327,2,1327,7],[1344,6,1344,7],[1329,2,1329,7],[1329,8,1329,9],[1330,2,1330,7],[1324,8,1324,9],[1325,2,1325,7],[1325,8,1325,9],[1326,2,1326,7],[1326,8,1326,9],[1324,2,1324,7],[1321,8,1321,9],[1322,2,1322,7],[1322,8,1322,9],[1323,2,1323,7],[1323,8,1323,9],[1321,2,1321,7],[1338,2,1338,7],[1342,2,1342,7],[1338,8,1338,9],[1341,2,1341,7],[1284,8,1284,9],[1285,2,1285,7],[1285,8,1285,9],[1286,2,1286,7],[1286,8,1286,9],[1284,2,1284,7],[1315,2,1315,7],[1296,8,1296,9],[1297,2,1297,7],[1297,8,1297,9],[1314,2,1314,7],[1314,8,1314,9],[1296,2,1296,7],[1313,6,1313,7],[1299,2,1299,7],[1299,8,1299,9],[1300,2,1300,7],[1307,2,1307,7],[1307,8,1307,9],[1308,2,1308,7],[1308,8,1308,9],[1305,2,1305,7],[1305,8,1305,9],[1306,2,1306,7],[1306,8,1306,9],[1311,2,1311,7],[1311,8,1311,9],[1298,2,1298,7],[1298,8,1298,9],[1303,2,1303,7],[1303,8,1303,9],[1304,2,1304,7],[1293,8,1293,9],[1294,2,1294,7],[1294,8,1294,9],[1295,2,1295,7],[1295,8,1295,9],[1293,2,1293,7],[1290,8,1290,9],[1291,2,1291,7],[1291,8,1291,9],[1292,2,1292,7],[1292,8,1292,9],[1290,2,1290,7],[1287,8,1287,9],[1288,2,1288,7],[1288,8,1288,9],[1289,2,1289,7],[1289,8,1289,9],[1287,2,1287,7],[1283,2,1283,7],[1283,8,1283,9],[1265,2,1265,7],[1282,6,1282,7],[1267,2,1267,7],[1267,8,1267,9],[1268,2,1268,7],[1262,8,1262,9],[1263,2,1263,7],[1263,8,1263,9],[1264,2,1264,7],[1264,8,1264,9],[1262,2,1262,7],[1259,8,1259,9],[1260,2,1260,7],[1260,8,1260,9],[1276,2,1276,7],[1276,8,1276,9],[1279,2,1279,7],[1279,8,1279,9],[1280,2,1280,7],[1280,8,1280,9],[1277,2,1277,7],[1277,8,1277,9],[1278,2,1278,7],[1278,8,1278,9],[1281,2,1281,7],[1281,8,1281,9],[1227,8,1227,9],[1225,2,1225,7],[1256,8,1256,9],[1257,2,1257,7],[1257,8,1257,9],[1256,2,1256,7],[1253,8,1253,9],[1254,2,1254,7],[1254,8,1254,9],[1255,2,1255,7],[1255,8,1255,9],[1253,2,1253,7],[1234,8,1234,9],[1235,2,1235,7],[1235,8,1235,9],[1252,2,1252,7],[1252,8,1252,9],[1234,2,1234,7],[1251,6,1251,7],[1237,2,1237,7],[1237,8,1237,9],[1238,2,1238,7],[1245,2,1245,7],[1245,8,1245,9],[1246,2,1246,7],[1246,8,1246,9],[1243,2,1243,7],[1243,8,1243,9],[1244,2,1244,7],[1244,8,1244,9],[1249,2,1249,7],[1249,8,1249,9],[1181,8,1181,9],[1182,2,1182,7],[1182,8,1182,9],[1187,2,1187,7],[1187,8,1187,9],[1203,8,1203,9],[1204,2,1204,7],[1204,8,1204,9],[1221,2,1221,7],[1221,8,1221,9],[1203,2,1203,7],[1220,6,1220,7],[1205,2,1205,7],[1205,8,1205,9],[1206,2,1206,7],[1200,8,1200,9],[1201,2,1201,7],[1201,8,1201,9],[1202,2,1202,7],[1202,8,1202,9],[1200,2,1200,7],[1197,8,1197,9],[1198,2,1198,7],[1198,8,1198,9],[1199,2,1199,7],[1199,8,1199,9],[1197,2,1197,7],[1214,2,1214,7],[1214,8,1214,9],[1217,2,1217,7],[1217,8,1217,9],[1218,2,1218,7],[1141,8,1141,9],[1142,2,1142,7],[1142,8,1142,9],[1159,2,1159,7],[1159,8,1159,9],[1158,6,1158,7],[1143,2,1143,7],[1143,8,1143,9],[1144,2,1144,7],[1144,8,1144,9],[1147,2,1147,7],[1147,8,1147,9],[1148,2,1148,7],[1148,8,1148,9],[1145,2,1145,7],[1145,8,1145,9],[1146,2,1146,7],[1146,8,1146,9],[1151,2,1151,7],[1151,8,1151,9],[1152,2,1152,7],[1152,8,1152,9],[1149,2,1149,7],[1149,8,1149,9],[1150,2,1150,7],[1150,8,1150,9],[1155,2,1155,7],[1155,8,1155,9],[1156,2,1156,7],[1156,8,1156,9],[1153,2,1153,7],[1153,8,1153,9],[1137,2,1137,7],[1137,8,1137,9],[1138,8,1138,9],[1139,2,1139,7],[1139,8,1139,9],[1140,2,1140,7],[1140,8,1140,9],[1133,2,1133,7],[1133,8,1133,9],[1134,2,1134,7],[1134,8,1134,9],[1135,8,1135,9],[1136,2,1136,7],[1136,8,1136,9],[1129,8,1129,9],[1130,2,1130,7],[1130,8,1130,9],[1131,2,1131,7],[1131,8,1131,9],[1132,8,1132,9],[1078,2,1078,7],[1078,8,1078,9],[1076,2,1076,7],[1128,2,1128,7],[1128,8,1128,9],[1110,2,1110,7],[1127,6,1127,7],[1113,2,1113,7],[1113,8,1113,9],[1114,2,1114,7],[1107,8,1107,9],[1108,2,1108,7],[1108,8,1108,9],[1109,2,1109,7],[1109,8,1109,9],[1107,2,1107,7],[1104,8,1104,9],[1105,2,1105,7],[1105,8,1105,9],[1106,2,1106,7],[1106,8,1106,9],[1104,2,1104,7],[1112,2,1112,7],[1112,8,1112,9],[1125,2,1125,7],[1125,8,1125,9],[1126,2,1126,7],[1126,8,1126,9],[1123,2,1123,7],[1123,8,1123,9],[1124,2,1124,7],[1124,8,1124,9],[1079,8,1079,9],[1080,2,1080,7],[1080,8,1080,9],[1093,2,1093,7],[1093,8,1093,9],[1094,2,1094,7],[1094,8,1094,9],[1091,2,1091,7],[1091,8,1091,9],[1092,2,1092,7],[1092,8,1092,9],[1095,2,1095,7],[1095,8,1095,9],[1082,8,1082,9],[1083,2,1083,7],[1083,8,1083,9],[1084,2,1084,7],[1084,8,1084,9],[1088,8,1088,9],[1089,2,1089,7],[1089,8,1089,9],[1090,2,1090,7],[1090,8,1090,9],[1085,8,1085,9],[1086,2,1086,7],[1086,8,1086,9],[1087,2,1087,7],[1087,8,1087,9],[1074,2,1074,7],[1074,8,1074,9],[1075,2,1075,7],[1075,8,1075,9],[1064,8,1064,9],[1067,8,1067,9],[1076,8,1076,9],[1077,2,1077,7],[1077,8,1077,9],[1071,2,1071,7],[1071,8,1071,9],[1072,2,1072,7],[1072,8,1072,9],[1070,2,1070,7],[1073,8,1073,9],[1068,2,1068,7],[1068,8,1068,9],[1069,2,1069,7],[1069,8,1069,9],[1064,2,1064,7],[1067,2,1067,7],[1070,8,1070,9],[1048,8,1048,9],[1049,2,1049,7],[1049,8,1049,9],[1066,2,1066,7],[1066,8,1066,9],[1048,2,1048,7],[1065,6,1065,7],[1051,2,1051,7],[1051,8,1051,9],[1052,2,1052,7],[1045,8,1045,9],[1046,2,1046,7],[1046,8,1046,9],[1047,2,1047,7],[1047,8,1047,9],[1045,2,1045,7],[1057,2,1057,7],[1056,2,1056,7],[1056,8,1056,9],[1061,2,1061,7],[1061,8,1061,9],[1062,2,1062,7],[1062,8,1062,9],[1059,2,1059,7],[1059,8,1059,9],[1060,2,1060,7],[1060,8,1060,9],[1063,2,1063,7],[1063,8,1063,9],[1042,8,1042,9],[1043,2,1043,7],[1043,8,1043,9],[1042,2,1042,7],[1039,8,1039,9],[1040,2,1040,7],[1040,8,1040,9],[1041,2,1041,7],[1041,8,1041,9],[1039,2,1039,7],[1017,8,1017,9],[1018,2,1018,7],[1018,8,1018,9],[1035,2,1035,7],[1035,8,1035,9],[1017,2,1017,7],[1034,6,1034,7],[1019,2,1019,7],[1019,8,1019,9],[1020,2,1020,7],[1026,2,1026,7],[1026,8,1026,9],[1029,2,1029,7],[1029,8,1029,9],[1030,2,1030,7],[1030,8,1030,9],[1027,2,1027,7],[1027,8,1027,9],[1028,2,1028,7],[1028,8,1028,9],[1020,8,1020,9],[1021,2,1021,7],[995,2,995,7],[995,8,995,9],[996,2,996,7],[996,8,996,9],[993,2,993,7],[993,8,993,9],[994,2,994,7],[994,8,994,9],[1000,2,1000,7],[1000,8,1000,9],[997,2,997,7],[997,8,997,9],[998,2,998,7],[1012,8,1012,9],[1013,2,1013,7],[1013,8,1013,9],[1006,2,1006,7],[1006,8,1006,9],[1007,2,1007,7],[1007,8,1007,9],[1008,8,1008,9],[1009,2,1009,7],[1009,8,1009,9],[998,8,998,9],[999,2,999,7],[999,8,999,9],[967,2,967,7],[967,8,967,9],[958,8,958,9],[959,2,959,7],[959,8,959,9],[960,2,960,7],[960,8,960,9],[990,2,990,7],[990,8,990,9],[983,8,983,9],[984,2,984,7],[984,8,984,9],[985,2,985,7],[985,8,985,9],[983,2,983,7],[980,8,980,9],[981,2,981,7],[981,8,981,9],[982,2,982,7],[982,8,982,9],[980,2,980,7],[975,8,975,9],[976,2,976,7],[976,8,976,9],[974,2,974,7],[969,2,969,7],[969,8,969,9],[968,2,968,7],[968,8,968,9],[965,2,965,7],[965,8,965,9],[966,2,966,7],[937,2,937,7],[937,8,937,9],[938,2,938,7],[938,8,938,9],[935,2,935,7],[935,8,935,9],[936,2,936,7],[936,8,936,9],[939,2,939,7],[939,8,939,9],[940,2,940,7],[940,8,940,9],[964,8,964,9],[961,2,961,7],[961,8,961,9],[962,2,962,7],[962,8,962,9],[951,2,951,7],[951,8,951,9],[949,2,949,7],[944,2,944,7],[944,8,944,9],[945,2,945,7],[945,8,945,9],[891,2,891,7],[891,8,891,9],[889,2,889,7],[892,2,892,7],[892,8,892,9],[893,2,893,7],[893,8,893,9],[887,2,887,7],[887,8,887,9],[888,2,888,7],[888,8,888,9],[889,8,889,9],[890,2,890,7],[924,8,924,9],[925,2,925,7],[925,8,925,9],[942,2,942,7],[942,8,942,9],[941,6,941,7],[927,2,927,7],[927,8,927,9],[928,2,928,7],[928,8,928,9],[929,8,929,9],[930,8,930,9],[926,8,926,9],[933,8,933,9],[934,8,934,9],[931,2,931,7],[931,8,931,9],[932,2,932,7],[932,8,932,9],[894,2,894,7],[894,8,894,9],[911,2,911,7],[911,8,911,9],[910,6,910,7],[896,2,896,7],[896,8,896,9],[897,2,897,7],[897,8,897,9],[898,2,898,7],[898,8,898,9],[895,2,895,7],[895,8,895,9],[901,2,901,7],[901,8,901,9],[902,2,902,7],[902,8,902,9],[899,2,899,7],[886,2,886,7],[883,8,883,9],[886,8,886,9],[865,8,865,9],[866,2,866,7],[866,8,866,9],[878,2,878,7],[878,8,878,9],[875,2,875,7],[875,8,875,9],[876,2,876,7],[869,2,869,7],[869,8,869,9],[870,2,870,7],[870,8,870,9],[867,2,867,7],[877,2,877,7],[877,8,877,9],[867,8,867,9],[868,2,868,7],[890,8,890,9],[847,8,847,9],[845,2,845,7],[845,8,845,9],[846,2,846,7],[846,8,846,9],[849,8,849,9],[849,2,849,7],[850,2,850,7],[854,2,854,7],[854,8,854,9],[855,2,855,7],[855,8,855,9],[856,8,856,9],[857,2,857,7],[857,8,857,9],[851,2,851,7],[851,8,851,9],[852,2,852,7],[861,8,861,9],[864,8,864,9],[865,2,865,7],[882,8,882,9],[884,2,884,7],[884,8,884,9],[885,2,885,7],[885,8,885,9],[876,8,876,9],[881,2,881,7],[881,8,881,9],[882,2,882,7],[883,2,883,7],[837,8,837,9],[838,2,838,7],[838,8,838,9],[880,2,880,7],[880,8,880,9],[862,2,862,7],[879,6,879,7],[864,2,864,7],[858,2,858,7],[858,8,858,9],[856,2,856,7],[859,8,859,9],[859,2,859,7],[860,2,860,7],[860,8,860,9],[873,2,873,7],[873,8,873,9],[874,2,874,7],[874,8,874,9],[871,2,871,7],[871,8,871,9],[872,2,872,7],[872,8,872,9],[862,8,862,9],[863,2,863,7],[863,8,863,9],[850,8,850,9],[868,8,868,9],[852,8,852,9],[853,2,853,7],[853,8,853,9],[861,2,861,7],[824,2,824,7],[824,8,824,9],[825,2,825,7],[825,8,825,9],[826,2,826,7],[826,8,826,9],[815,2,815,7],[815,8,815,9],[812,2,812,7],[812,8,812,9],[813,2,813,7],[813,8,813,9],[816,2,816,7],[816,8,816,9],[821,2,821,7],[821,8,821,9],[822,2,822,7],[822,8,822,9],[818,8,818,9],[819,2,819,7],[819,8,819,9],[820,2,820,7],[820,8,820,9],[784,2,784,7],[784,8,784,9],[785,2,785,7],[785,8,785,9],[799,2,799,7],[799,8,799,9],[800,2,800,7],[800,8,800,9],[801,2,801,7],[801,8,801,9],[795,2,795,7],[795,8,795,9],[796,8,796,9],[797,2,797,7],[797,8,797,9],[798,2,798,7],[798,8,798,9],[796,2,796,7],[786,6,786,7],[787,8,787,9],[788,8,788,9],[789,2,789,7],[789,8,789,9],[790,8,790,9],[791,2,791,7],[791,8,791,9],[787,2,787,7],[788,2,788,7],[752,2,752,7],[752,8,752,9],[753,2,753,7],[753,8,753,9],[750,2,750,7],[750,8,750,9],[773,2,773,7],[773,8,773,9],[778,2,778,7],[778,8,778,9],[779,2,779,7],[779,8,779,9],[776,2,776,7],[776,8,776,9],[777,2,777,7],[777,8,777,9],[782,2,782,7],[782,8,782,9],[754,2,754,7],[754,8,754,9],[771,2,771,7],[771,8,771,9],[755,6,755,7],[756,8,756,9],[757,8,757,9],[758,2,758,7],[758,8,758,9],[759,8,759,9],[757,2,757,7],[762,8,762,9],[763,2,763,7],[763,8,763,9],[689,2,689,7],[689,8,689,9],[692,2,692,7],[692,8,692,9],[731,8,731,9],[732,2,732,7],[732,8,732,9],[730,2,730,7],[726,8,726,9],[727,8,727,9],[725,2,725,7],[727,2,727,7],[728,2,728,7],[728,8,728,9],[709,2,709,7],[709,8,709,9],[693,6,693,7],[694,8,694,9],[695,2,695,7],[695,8,695,9],[696,2,696,7],[696,8,696,9],[694,2,694,7],[697,8,697,9],[698,2,698,7],[698,8,698,9],[699,8,699,9],[697,2,697,7],[699,2,699,7],[706,8,706,9],[707,2,707,7],[707,8,707,9],[673,8,673,9],[674,2,674,7],[674,8,674,9],[673,2,673,7],[682,2,682,7],[682,8,682,9],[683,2,683,7],[683,8,683,9],[680,2,680,7],[680,8,680,9],[681,2,681,7],[681,8,681,9]],"merged_total":3222,"flags":["merged_cut"]}
[null,null,null,null,null,null,null,null,"Provider Invoice #",{"$f":"Invoice!G1","v":0}]
[null,null,null,null,null,null,null,null,"Combined Invoice Template Log #",{"$f":"Invoice!G2","v":0},null,null,null,"Monthly Submittal Cell"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Instruction","Click here for instructions for this tab"]
[]
["DELIVERABLE SUMMARY"]
["Lump Sum Payment Method"]
["Provider Name:  ",null,{"$f":"Invoice!C7","v":0},null,null,"Legacy Contract No.",null,{"$f":"Invoice!F7","v":0}]
["Provider ID No.",null,{"$f":"Invoice!C8","v":0},null,null,"Legacy WA No.",null,{"$f":"Invoice!F10","v":0}]
[]
["Deliverable Breakdown By Project (CSJ/Detail) and Source (Function Code)"]
[]
["PROJECT\n(CSJ or Detail No.)\n(Select from Drop Down Menu - Cell 43, 74, etc.)","SOURCE\n(LEGACY FC)\n(Select from Drop Down Menu - Cell 43, 74, etc)","DELIVERABLE DESCRIPTION",null,null,null,null,null,"DELIVERABLE AMOUNT\n(Must be billed by completed line item shown in the Table of Deliverables)"]
[{"$f":"A$43","v":0},{"$f":"B$43","v":0}]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$43","v":0},{"$f":"B$43","v":0}]
[0,0]
[{"$f":"A$43","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A43=0,\"\",A43)","v":""},null,null,null,"Subtotal Line 1",null,null,{"$f":"ROUND(SUM(I13:I42),2)","v":0}]
[{"$f":"A$74","v":0},{"$f":"B$74","v":0}]
[{"$f":"A$74","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$74","v":0},{"$f":"B$74","v":0}]
[0,0]
[{"$f":"A$74","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A74=0,\"\",A74)","v":""},null,null,null,"Subtotal Line 2",null,null,{"$f":"ROUND(SUM(I44:I73),2)","v":0}]
[{"$f":"A$105","v":0},{"$f":"B$105","v":0}]
[{"$f":"A$105","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$105","v":0},{"$f":"B$105","v":0}]
[0,0]
[{"$f":"A$105","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A105=0,\"\",A105)","v":""},null,null,null,"Subtotal Line 3",null,null,{"$f":"ROUND(SUM(I75:I104),2)","v":0}]
[{"$f":"A$136","v":0},{"$f":"B$136","v":0}]
[{"$f":"A$136","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$136","v":0},{"$f":"B$136","v":0}]
[0,0]
[{"$f":"A$136","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A136=0,\"\",A136)","v":""},null,null,null,"Subtotal Line 4",null,null,{"$f":"ROUND(SUM(I106:I135),2)","v":0}]
[{"$f":"A$167","v":0},{"$f":"B$167","v":0}]
[{"$f":"A$167","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$167","v":0},{"$f":"B$167","v":0}]
[0,0]
[{"$f":"A$167","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A167=0,\"\",A167)","v":""},null,null,null,"Subtotal Line 5",null,null,{"$f":"ROUND(SUM(I137:I166),2)","v":0}]
[{"$f":"A$198","v":0},{"$f":"B$198","v":0}]
[{"$f":"A$198","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$198","v":0},{"$f":"B$198","v":0}]
[0,0]
[{"$f":"A$198","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A198=0,\"\",A198)","v":""},null,null,null,"Subtotal Line 6",null,null,{"$f":"ROUND(SUM(I168:I197),2)","v":0}]
[{"$f":"A$229","v":0},{"$f":"B$229","v":0}]
[{"$f":"A$229","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$229","v":0},{"$f":"B$229","v":0}]
[0,0]
[{"$f":"A$229","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A229=0,\"\",A229)","v":""},null,null,null,"Subtotal Line 7",null,null,{"$f":"ROUND(SUM(I199:I228),2)","v":0}]
[{"$f":"A$260","v":0},{"$f":"B$260","v":0}]
[{"$f":"A$260","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$260","v":0},{"$f":"B$260","v":0}]
[0,0]
[{"$f":"A$260","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A260=0,\"\",A260)","v":""},null,null,null,"Subtotal Line 8",null,null,{"$f":"ROUND(SUM(I230:I259),2)","v":0}]
[{"$f":"A$291","v":0},{"$f":"B$291","v":0}]
[{"$f":"A$291","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$291","v":0},{"$f":"B$291","v":0}]
[0,0]
[{"$f":"A$291","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A291=0,\"\",A291)","v":""},null,null,null,"Subtotal Line 9",null,null,{"$f":"ROUND(SUM(I261:I290),2)","v":0}]
[{"$f":"A$322","v":0},{"$f":"B$322","v":0}]
[{"$f":"A$322","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$322","v":0},{"$f":"B$322","v":0}]
[0,0]
[{"$f":"A$322","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A322=0,\"\",A322)","v":""},null,null,null,"Subtotal Line 10",null,null,{"$f":"ROUND(SUM(I292:I321),2)","v":0}]
[{"$f":"A$353","v":0},{"$f":"B$353","v":0}]
[{"$f":"A$353","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$353","v":0},{"$f":"B$353","v":0}]
[0,0]
[{"$f":"A$353","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A353=0,\"\",A353)","v":""},null,null,null,"Subtotal Line 11",null,null,{"$f":"ROUND(SUM(I323:I352),2)","v":0}]
[{"$f":"A$384","v":0},{"$f":"B$384","v":0}]
[{"$f":"A$384","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$384","v":0},{"$f":"B$384","v":0}]
[0,0]
[{"$f":"A$384","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A384=0,\"\",A384)","v":""},null,null,null,"Subtotal Line 12",null,null,{"$f":"ROUND(SUM(I354:I383),2)","v":0}]
[{"$f":"A$415","v":0},{"$f":"B$415","v":0}]
[{"$f":"A$415","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$415","v":0},{"$f":"B$415","v":0}]
[0,0]
[{"$f":"A$415","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A415=0,\"\",A415)","v":""},null,null,null,"Subtotal Line 13",null,null,{"$f":"ROUND(SUM(I385:I414),2)","v":0}]
[{"$f":"A$446","v":0},{"$f":"B$446","v":0}]
[{"$f":"A$446","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$446","v":0},{"$f":"B$446","v":0}]
[0,0]
[{"$f":"A$446","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A446=0,\"\",A446)","v":""},null,null,null,"Subtotal Line 14",null,null,{"$f":"ROUND(SUM(I416:I445),2)","v":0}]
[{"$f":"A$477","v":0},{"$f":"B$477","v":0}]
[{"$f":"A$477","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$477","v":0},{"$f":"B$477","v":0}]
[0,0]
[{"$f":"A$477","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A477=0,\"\",A477)","v":""},null,null,null,"Subtotal Line 15",null,null,{"$f":"ROUND(SUM(I447:I476),2)","v":0}]
[{"$f":"A$508","v":0},{"$f":"B$508","v":0}]
[{"$f":"A$508","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$508","v":0},{"$f":"B$508","v":0}]
[0,0]
[{"$f":"A$508","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A508=0,\"\",A508)","v":""},null,null,null,"Subtotal Line 16",null,null,{"$f":"ROUND(SUM(I478:I507),2)","v":0}]
[{"$f":"A$539","v":0},{"$f":"B$539","v":0}]
[{"$f":"A$539","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$539","v":0},{"$f":"B$539","v":0}]
[0,0]
[{"$f":"A$539","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A539=0,\"\",A539)","v":""},null,null,null,"Subtotal Line 17",null,null,{"$f":"ROUND(SUM(I509:I538),2)","v":0}]
[{"$f":"A$570","v":0},{"$f":"B$570","v":0}]
[{"$f":"A$570","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$570","v":0},{"$f":"B$570","v":0}]
[0,0]
[{"$f":"A$570","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A570=0,\"\",A570)","v":""},null,null,null,"Subtotal Line 18",null,null,{"$f":"ROUND(SUM(I540:I569),2)","v":0}]
[{"$f":"A$601","v":0},{"$f":"B$601","v":0}]
[{"$f":"A$601","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$601","v":0},{"$f":"B$601","v":0}]
[0,0]
[{"$f":"A$601","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A601=0,\"\",A601)","v":""},null,null,null,"Subtotal Line 19",null,null,{"$f":"ROUND(SUM(I571:I600),2)","v":0}]
[{"$f":"A$632","v":0},{"$f":"B$632","v":0}]
[{"$f":"A$632","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$632","v":0},{"$f":"B$632","v":0}]
[0,0]
[{"$f":"A$632","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A632=0,\"\",A632)","v":""},null,null,null,"Subtotal Line 20",null,null,{"$f":"ROUND(SUM(I602:I631),2)","v":0}]
[{"$f":"A$663","v":0},{"$f":"B$663","v":0}]
[{"$f":"A$663","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$663","v":0},{"$f":"B$663","v":0}]
[0,0]
[{"$f":"A$663","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A663=0,\"\",A663)","v":""},null,null,null,"Subtotal Line 21",null,null,{"$f":"ROUND(SUM(I633:I662),2)","v":0}]
[{"$f":"A$694","v":0},{"$f":"B$694","v":0}]
[{"$f":"A$694","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$694","v":0},{"$f":"B$694","v":0}]
[0,0]
[{"$f":"A$694","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A694=0,\"\",A694)","v":""},null,null,null,"Subtotal Line 22",null,null,{"$f":"ROUND(SUM(I664:I693),2)","v":0}]
[{"$f":"A$725","v":0},{"$f":"B$725","v":0}]
[{"$f":"A$725","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$725","v":0},{"$f":"B$725","v":0}]
[0,0]
[{"$f":"A$725","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A725=0,\"\",A725)","v":""},null,null,null,"Subtotal Line 23",null,null,{"$f":"ROUND(SUM(I695:I724),2)","v":0}]
[{"$f":"A$756","v":0},{"$f":"B$756","v":0}]
[{"$f":"A$756","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$756","v":0},{"$f":"B$756","v":0}]
[0,0]
[{"$f":"A$756","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A756=0,\"\",A756)","v":""},null,null,null,"Subtotal Line 24",null,null,{"$f":"ROUND(SUM(I726:I755),2)","v":0}]
[{"$f":"A$787","v":0},{"$f":"B$787","v":0}]
[{"$f":"A$787","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$787","v":0},{"$f":"B$787","v":0}]
[0,0]
[{"$f":"A$787","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A787=0,\"\",A787)","v":""},null,null,null,"Subtotal Line 25",null,null,{"$f":"ROUND(SUM(I757:I786),2)","v":0}]
[{"$f":"A$818","v":0},{"$f":"B$818","v":0}]
[{"$f":"A$818","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$818","v":0},{"$f":"B$818","v":0}]
[0,0]
[{"$f":"A$818","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A818=0,\"\",A818)","v":""},null,null,null,"Subtotal Line 26",null,null,{"$f":"ROUND(SUM(I788:I817),2)","v":0}]
[{"$f":"A$849","v":0},{"$f":"B$849","v":0}]
[{"$f":"A$849","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$849","v":0},{"$f":"B$849","v":0}]
[0,0]
[{"$f":"A$849","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A849=0,\"\",A849)","v":""},null,null,null,"Subtotal Line 27",null,null,{"$f":"ROUND(SUM(I819:I848),2)","v":0}]
[{"$f":"A$880","v":0},{"$f":"B$880","v":0}]
[{"$f":"A$880","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$880","v":0},{"$f":"B$880","v":0}]
[0,0]
[{"$f":"A$880","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A880=0,\"\",A880)","v":""},null,null,null,"Subtotal Line 28",null,null,{"$f":"ROUND(SUM(I850:I879),2)","v":0}]
[{"$f":"A$911","v":0},{"$f":"B$911","v":0}]
[{"$f":"A$911","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$911","v":0},{"$f":"B$911","v":0}]
[0,0]
[{"$f":"A$911","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A911=0,\"\",A911)","v":""},null,null,null,"Subtotal Line 29",null,null,{"$f":"ROUND(SUM(I881:I910),2)","v":0}]
[{"$f":"A$942","v":0},{"$f":"B$942","v":0}]
[{"$f":"A$942","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$942","v":0},{"$f":"B$942","v":0}]
[0,0]
[{"$f":"A$942","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A942=0,\"\",A942)","v":""},null,null,null,"Subtotal Line 30",null,null,{"$f":"ROUND(SUM(I912:I941),2)","v":0}]
[{"$f":"A$973","v":0},{"$f":"B$973","v":0}]
[{"$f":"A$973","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$973","v":0},{"$f":"B$973","v":0}]
[0,0]
[{"$f":"A$973","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A973=0,\"\",A973)","v":""},null,null,null,"Subtotal Line 31",null,null,{"$f":"ROUND(SUM(I943:I972),2)","v":0}]
[{"$f":"A$1004","v":0},{"$f":"B$1004","v":0}]
[{"$f":"A$1004","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$1004","v":0},{"$f":"B$1004","v":0}]
[0,0]
[{"$f":"A$1004","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A1004=0,\"\",A1004)","v":""},null,null,null,"Subtotal Line 32",null,null,{"$f":"ROUND(SUM(I974:I1003),2)","v":0}]
[{"$f":"A$1035","v":0},{"$f":"B$1035","v":0}]
[{"$f":"A$1035","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$1035","v":0},{"$f":"B$1035","v":0}]
[0,0]
[{"$f":"A$1035","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A1035=0,\"\",A1035)","v":""},null,null,null,"Subtotal Line 33",null,null,{"$f":"ROUND(SUM(I1005:I1034),2)","v":0}]
[{"$f":"A$1066","v":0},{"$f":"B$1066","v":0}]
[{"$f":"A$1066","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$1066","v":0},{"$f":"B$1066","v":0}]
[0,0]
[{"$f":"A$1066","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A1066=0,\"\",A1066)","v":""},null,null,null,"Subtotal Line 34",null,null,{"$f":"ROUND(SUM(I1036:I1065),2)","v":0}]
[{"$f":"A$1097","v":0},{"$f":"B$1097","v":0}]
[{"$f":"A$1097","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$1097","v":0},{"$f":"B$1097","v":0}]
[0,0]
[{"$f":"A$1097","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A1097=0,\"\",A1097)","v":""},null,null,null,"Subtotal Line 35",null,null,{"$f":"ROUND(SUM(I1067:I1096),2)","v":0}]
[{"$f":"A$1128","v":0},{"$f":"B$1128","v":0}]
[{"$f":"A$1128","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$1128","v":0},{"$f":"B$1128","v":0}]
[0,0]
[{"$f":"A$1128","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A1128=0,\"\",A1128)","v":""},null,null,null,"Subtotal Line 36",null,null,{"$f":"ROUND(SUM(I1098:I1127),2)","v":0}]
[{"$f":"A$1159","v":0},{"$f":"B$1159","v":0}]
[{"$f":"A$1159","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$1159","v":0},{"$f":"B$1159","v":0}]
[0,0]
[{"$f":"A$1159","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A1159=0,\"\",A1159)","v":""},null,null,null,"Subtotal Line 37",null,null,{"$f":"ROUND(SUM(I1129:I1158),2)","v":0}]
[{"$f":"A$1190","v":0},{"$f":"B$1190","v":0}]
[{"$f":"A$1190","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$1190","v":0},{"$f":"B$1190","v":0}]
[0,0]
[{"$f":"A$1190","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A1190=0,\"\",A1190)","v":""},null,null,null,"Subtotal Line 38",null,null,{"$f":"ROUND(SUM(I1160:I1189),2)","v":0}]
[{"$f":"A$1221","v":0},{"$f":"B$1221","v":0}]
[{"$f":"A$1221","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$1221","v":0},{"$f":"B$1221","v":0}]
[0,0]
[{"$f":"A$1221","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A1221=0,\"\",A1221)","v":""},null,null,null,"Subtotal Line 39",null,null,{"$f":"ROUND(SUM(I1191:I1220),2)","v":0}]
[{"$f":"A$1252","v":0},{"$f":"B$1252","v":0}]
[{"$f":"A$1252","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$1252","v":0},{"$f":"B$1252","v":0}]
[0,0]
[{"$f":"A$1252","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A1252=0,\"\",A1252)","v":""},null,null,null,"Subtotal Line 40",null,null,{"$f":"ROUND(SUM(I1222:I1251),2)","v":0}]
[{"$f":"A$1283","v":0},{"$f":"B$1283","v":0}]
[{"$f":"A$1283","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$1283","v":0},{"$f":"B$1283","v":0}]
[0,0]
[{"$f":"A$1283","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A1283=0,\"\",A1283)","v":""},null,null,null,"Subtotal Line 41",null,null,{"$f":"ROUND(SUM(I1253:I1282),2)","v":0}]
[{"$f":"A$1314","v":0},{"$f":"B$1314","v":0}]
[{"$f":"A$1314","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$1314","v":0},{"$f":"B$1314","v":0}]
[0,0]
[{"$f":"A$1314","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A1314=0,\"\",A1314)","v":""},null,null,null,"Subtotal Line 42",null,null,{"$f":"ROUND(SUM(I1284:I1313),2)","v":0}]
[{"$f":"A$1345","v":0},{"$f":"B$1345","v":0}]
[{"$f":"A$1345","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$1345","v":0},{"$f":"B$1345","v":0}]
[0,0]
[{"$f":"A$1345","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A1345=0,\"\",A1345)","v":""},null,null,null,"Subtotal Line 43",null,null,{"$f":"ROUND(SUM(I1315:I1344),2)","v":0}]
[{"$f":"A$1376","v":0},{"$f":"B$1376","v":0}]
[{"$f":"A$1376","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$1376","v":0},{"$f":"B$1376","v":0}]
[0,0]
[{"$f":"A$1376","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A1376=0,\"\",A1376)","v":""},null,null,null,"Subtotal Line 44",null,null,{"$f":"ROUND(SUM(I1346:I1375),2)","v":0}]
[{"$f":"A$1407","v":0},{"$f":"B$1407","v":0}]
[{"$f":"A$1407","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$1407","v":0},{"$f":"B$1407","v":0}]
[0,0]
[{"$f":"A$1407","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A1407=0,\"\",A1407)","v":""},null,null,null,"Subtotal Line 45",null,null,{"$f":"ROUND(SUM(I1377:I1406),2)","v":0}]
[{"$f":"A$1438","v":0},{"$f":"B$1438","v":0}]
[{"$f":"A$1438","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$1438","v":0},{"$f":"B$1438","v":0}]
[0,0]
[{"$f":"A$1438","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A1438=0,\"\",A1438)","v":""},null,null,null,"Subtotal Line 46",null,null,{"$f":"ROUND(SUM(I1408:I1437),2)","v":0}]
[{"$f":"A$1469","v":0},{"$f":"B$1469","v":0}]
[{"$f":"A$1469","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$1469","v":0},{"$f":"B$1469","v":0}]
[0,0]
[{"$f":"A$1469","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A1469=0,\"\",A1469)","v":""},null,null,null,"Subtotal Line 47",null,null,{"$f":"ROUND(SUM(I1439:I1468),2)","v":0}]
[{"$f":"A$1500","v":0},{"$f":"B$1500","v":0}]
[{"$f":"A$1500","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$1500","v":0},{"$f":"B$1500","v":0}]
[0,0]
[{"$f":"A$1500","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A1500=0,\"\",A1500)","v":""},null,null,null,"Subtotal Line 48",null,null,{"$f":"ROUND(SUM(I1470:I1499),2)","v":0}]
[{"$f":"A$1531","v":0},{"$f":"B$1531","v":0}]
[{"$f":"A$1531","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$1531","v":0},{"$f":"B$1531","v":0}]
[0,0]
[{"$f":"A$1531","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A1531=0,\"\",A1531)","v":""},null,null,null,"Subtotal Line 49",null,null,{"$f":"ROUND(SUM(I1501:I1530),2)","v":0}]
[{"$f":"A$1562","v":0},{"$f":"B$1562","v":0}]
[{"$f":"A$1562","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[{"$f":"A$1562","v":0},{"$f":"B$1562","v":0}]
[0,0]
[{"$f":"A$1562","v":0},0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[0,0]
[null,null,{"$f":"IF(A1562=0,\"\",A1562)","v":""},null,null,null,"Subtotal Line 50",null,null,{"$f":"ROUND(SUM(I1532:I1561),2)","v":0}]
[null,null,"Total",null,null,null,"TOTAL:",null,{"$f":"J43+J74+J105+J136+J167+J198+J229+J260+J291+J322+J353+J384+J415+J446+J477+J508+J539+J570+J601+J632+J663+J694+J725+J756+J787+J818+J849+J880+J911+J942+J973+J1004+J1035+J1066+J1097+J1128+J1159+J1190+J1221+J1252+J1283+J1314+J1345+J1376+J1407+J1438+J1469+J1500+J1531+J1562","v":0}]
[]
[null,null,"TxDOT"]
["Deliverable Detail"]
["DELIVERABLE DATE",null,"DELIVERABLE DESCRIPTION",null,null,null,null,"% OF TOTAL SCOPE","DELIVERABLE AMOUNT"]
[null,null,null,null,null,null,null,{"$f":"I1568/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J43","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1569/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J74","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1570/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J105","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1571/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J136","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1572/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J167","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1573/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J198","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1574/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J229","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1575/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J260","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1576/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J291","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1577/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J322","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1578/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J353","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1579/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J384","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1580/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J415","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1581/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J446","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1582/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J477","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1583/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J508","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1584/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J539","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1585/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J570","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1586/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J601","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1587/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J632","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1588/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J663","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1589/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J694","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1590/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J725","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1591/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J756","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1592/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J787","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1593/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J818","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1594/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J849","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1595/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J880","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1596/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J911","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1597/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J942","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1598/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J973","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1599/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J1004","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1600/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J1035","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1601/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J1066","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1602/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J1097","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1603/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J1128","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1604/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J1159","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1605/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J1190","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1606/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J1221","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1607/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J1252","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1608/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J1283","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1609/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J1314","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1610/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J1345","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1611/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J1376","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1612/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J1407","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1613/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J1438","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1614/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J1469","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1615/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J1500","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1616/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J1531","v":0}]
[null,null,null,null,null,null,null,{"$f":"I1617/Invoice!$F$11","v":{"$error":"#DIV/0!"}},{"$f":"J1562","v":0}]
[null,null,"Total",null,null,null,"TOTAL:",null,{"$f":"SUM(I1568:J1617)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"'WA Financial Status Summary'!#REF!","v":{"$error":"#REF!"}}]