{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Form C-13CPM Instructions","Controls Chart Data","Earnings Data Input","Progress Chart"],"not_rendered":{"charts":1,"images":4,"macros":1,"external_links":0,"defined_names":3,"comments":2,"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":"Form C-13CPM Instructions","index":0,"n_rows":58,"n_cols":3,"rows_kept":58,"cut":false,"hidden":false,"merged":[[57,0,57,11],[51,2,51,11],[33,2,33,11],[34,0,34,11],[43,2,43,11],[36,0,36,11],[39,2,39,11],[41,2,41,11],[46,0,46,11],[45,2,45,11],[54,0,54,11],[50,0,50,11],[48,0,48,11],[53,0,53,11],[49,2,49,11],[18,0,18,11],[17,0,17,11],[19,0,19,11],[22,0,22,11],[44,0,44,11],[42,0,42,11],[40,0,40,11],[27,2,27,11],[23,2,23,11],[30,0,30,11],[31,2,31,11],[32,0,32,11],[29,2,29,11],[13,0,13,11],[12,0,12,11],[21,0,21,11],[28,0,28,11],[24,0,24,11],[25,2,25,11],[26,0,26,11],[0,0,0,11],[2,0,2,11],[4,0,4,11],[6,0,6,11],[1,0,1,11],[3,0,3,11],[5,0,5,11],[7,0,7,11],[56,0,56,11],[55,0,55,11],[47,2,47,11],[35,2,35,11],[9,0,9,11],[11,0,11,11],[20,0,20,11],[16,0,16,11],[8,0,8,11],[37,2,37,11],[38,0,38,11],[10,0,10,11],[15,0,15,11],[14,0,14,11],[52,0,52,11]]}
[]
["INSTRUCTIONS FOR COMPLETING THE CONTRACTOR'S PROGRESS EARNINGS SCHEDULE (FORM C-13CPM)"]
[]
["Form C-13CPM shall be used by the Contractor to submit its Progress Earnings Schedule as specified in the Progress Schedule Specifications for Category IV, V, and Design-Build projects.  Form C-13CPM should also be used for other projects when the Progress Schedule is cost-loaded at the Contractor's discretion. The Progress Earnings Schedule shall define the Contractor's anticipated and actual progress for each month relative to the Total Contract Value. The anticipated progress percent complete will be based on the anticipated cumulative earnings for work-in-place as of the Contractor's progress estimate dates as defined in Section 109.8(a) of the Specifications. The Contractor shall submit with the Progress Earnings Schedule, an Activity Cost-loading Report (ACR) showing the budgeted units and cost for each activity in the Progress Schedule that is associated with a bid item as shown in the Contract Schedule of Items. When a bid item is associated with more than one activity, the ACR shall list the bid item, activities, and the proportionate units and cost assigned to each activity.      "]
[]
["The C-13CPM form contains macros and certain advanced functions that are availble in the Analysis ToolPak. The application macro security settings must be set on \"Enable\" for the form to work properly. For Microsoft Excel 2003 users, prior to completing the form, click on Tools, then click on Macros, then click on Security, an then specify \"Medium\". Also, click on Tools, then click on Add-ins, then make sure that the Analysis ToolPak and Analysis ToolPak - VBA boxes are checked. For Microsoft Excel 2007 and above users, prior to completing the form, click on Developer tab in the Main menu, then click on the Macro Security link in the Code section, and then specify \"Enable all macros\"."]
[]
["CONTROLS CHART DATA: Complete all contract and project information fields as indicated on the Controls Chart Data form as follows. All shaded cells are locked and automatically populated:"]
[]
["CONTRACT NTP DATE: Enter the Contract Notice to Proceed (NTP) Date as defined in the Contract or as approved by the Engineer."]
[]
["CONTRACT FIXED COMPLETION DATE: Enter the Contract Fixed Completion Date as defined in the Contract or as subsequently approved by a Work Order."]
[]
["PROJECTED COMPLETION DATE: Enter the calculated project completion date as shown in the Baseline Progress Schedule or the current Progress Schedule Update, whichever is later."]
[]
["ORIGINAL TOTAL CONTRACT VALUE: Enter the original Total Contract Value as defined in the Contract."]
[]
["ADJUSTED TOTAL CONTRACT VALUE: The Adjusted Total Contract Value shall equal the Original Total Contract Value unless modified by a Work Order. Enter the current Adjusted Total Contract Value as approved by a Work Order. If there is no adjustment to the Total Contract Value, then enter the Original Total Contract Value.  "]
[]
["FIRST PROGRESS ESTIMATE DATE: Enter the  first estimate date, which shall be the Contractor's progress estimate date immediately following the NTP date according to Section 109.08 of the Specifications. This date is required to establish the Monthly Progress Estimate Dates."]
[]
["CURRENT PROGRESS ESTIMATE DATE: Enter the progress estimate date for the Contractor's current payment estimate."]
[]
[null,"Column 1","Monthly Progress Estimate Dates:  Monthly Progress Estimate Dates column shall show the date of preparation of the Contractor's monthly progress estimate as defined in Section 109.8(a) of the Specifications. Monthly estimate dates are automatically populated based on the first estimate date, which shall be the estimate date following the NTP date. The last estimate date shall be the latter of the contract fixed completion date or the projected completion date. "]
[]
[null,"Column 2","Baseline Monthly Earnings (Early):  Baseline monthly earnings (early) is the baseline schedule planned monthly earnings for work-in-place based on the early dates remaining cost data generated from the Baseline Progress Schedule. This column pulls data from the \"Earnings Data Input\" worksheet, Row 4: Remaining Cost (Early). "]
[]
[null,"Column 3","Baseline Cumulative Earnings (Early): This column shall show the baseline (planned) cumulative earnings for work-in-place each month based on the baseline monthly earnings (early). "]
[]
[null,"Column 4","Baseline Progress Percent Complete (Early):  Baseline progress percent complete (early) is the anticipated progress for work planned as of the current estimate date based on early dates. Baseline progress percent complete is based on the baseline cumulative earnings (early) for work-in-place to date relative to the Total Contract Value or Adjusted Total Contract Value, as applicable. "]
[]
[null,"Column 5","Baseline Monthly Earnings (Late):  Baseline monthly earnings (late) is the baseline schedule planned monthly earnings for work-in-place based on the late dates remaining cost data generated from the Baseline Progress Schedule. This column pulls data from the \"Earnings Data Input\" worksheet, Row 5: Remaining Cost (Late). "]
[]
[null,"Column 6","Baseline Cumulative Earnings (Late): This column shall show the baseline (planned) cumulative earnings for work-in-place each month based on the baseline monthly earnings (late). "]
[]
[null,"Column 7","Baseline Progress Percent Complete (Late):  Baseline progress percent complete (late) is the anticipated progress for work planned as of the current estimate date based on late dates. Baseline progress percent complete is based on the baseline cumulative earnings (late) for work-in-place to date relative to the Total Contract Value or Adjusted Total Contract Value, as applicable. "]
[]
[null,"Column 8","Actual Monthly Earnings:  Actual monthly earnings is the actual total value of work completed during the current estimate period. Enter the actual amount paid for work completed this period as reflected on the current progress estimate. "]
[]
[null,"Column 9","Actual Cumulative Earnings:  Actual cumulative earnings is the total value of work (total earnings to date) for all work completed as shown on the current progress estimate. "]
[]
[null,"Column 10","Actual Progress Percent Complete:  Actual progress percent complete is the current total progress for all work completed to date, which is based on the Total Earnings to date relative to the Total Contract Value or Adjusted Total Contract Value, as applicable. "]
[]
[null,"Column 11","Current Projected Monthly Earnings:  Current projected monthly earnings is the current planned monthly earnings for work-in-place for the remaining periods based on the remaining cost (early) data generated from the current Progress Schedule Update. This column pulls data from the \"Earnings Data Input\" worksheet, Row 11: Remaining Cost (Early)."]
[]
[null,"Column 12","Current Cumulative at Completion Earnings:  Current cumulative at completion earnings is the cumulative sum of the actual and projected monthly earnings for work-in-place as of each monthly payment estimate period. "]
[]
[null,"Column 13","Current Projected Progress Percent Complete:  Current projected progress percent complete shows the actual progress percent complete for work completed to date and the current projected progress percent complete for the remaining periods. The projected progress percent complete is based on the current cumulative at completion earnings relative to the current Total Contract Value (Original or Adjusted Total Contract Value, as applicable). "]
[]
[null,"Column 14","Progress Variance:  Progress variance percentage shows the difference between the \"Actual or Current Projected Progress Percent Complete\" and the \"Baseline Progress Percent Complete\" based on early earnings. When the actual or current projected progress percent complete is lower than the baseline (early), progress variance will be calculated as the difference between the actual/current projected progress percent complete and the baseline (early) progress percent complete. \n\nVariance (Early) = (Column M - Column D).\n\nThe cell will be shaded \"Orange\" if progress is  less than the baseline (early), but ahead of the baseline (late). \n\nWhen the actual or current projected progress percent complete is lower than the baseline (late), the cell will be shaded \"Red\". "]
[]
[null,"Column 15","Schedule Performance Index (SPI):\nThe SPI is a measure of total earnings todate relative to planned earnings as of the estimate date.\n(Column L)/(Column C). "]
[]
["Click the \"Set/Reset Rows\" button to hide unsused rows or to reset the rows when additional rows are needed to show additional estimate periods when the completion dates are adjusted. "]
[]
["EARNINGS DATA INPUT: Copy/paste cost data from the \"csv\" file generated from Primavera P6, using \"Past Special\" and \"Values\" commands to prevent copying/pasting cell formats that may lock the cells for future entries. When completing the Earnings Data Input form for a Baseline or Revised Baseline submission, copy/paste the monthly cost data in both Baseline and the Current Update sections making sure that the monthly cost data are pasted to the appropriate monthly estimate dates. For monthly updates, copy/paste the monthly cost data to the Current Update section only."]
[]
["PROGRESS CHART: Click the \"Update Progress Chart\" button on the Progress Chart tab to update the progress chart. "]

{"sheet":"Controls Chart Data","index":1,"n_rows":110,"n_cols":15,"rows_kept":110,"cut":false,"hidden":false,"merged":[[5,13,5,14],[3,6,9,9],[8,10,8,12],[3,2,3,5],[6,2,6,5],[9,10,9,12],[4,2,4,5],[5,2,5,5],[4,10,4,12],[5,10,5,12],[6,10,6,12],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,8,13,8],[11,9,13,9],[1,0,1,14],[3,10,3,12],[7,13,7,14],[8,13,8,14],[3,13,3,14],[4,13,4,14],[8,2,8,5],[7,10,7,12],[3,0,3,1],[6,13,6,14],[4,0,4,1],[5,0,5,1],[7,0,7,1],[8,0,8,1],[7,2,7,5],[6,0,6,1],[11,13,13,13],[109,12,109,13],[0,0,0,14],[2,0,2,14],[107,0,107,1],[107,12,107,14],[11,1,13,1],[9,13,9,14],[11,10,13,10],[102,0,102,14],[11,0,13,0],[108,12,108,14],[11,2,13,2],[11,14,13,14],[11,3,13,3],[11,7,13,7],[11,12,13,12],[109,0,109,1],[107,2,107,7],[107,10,107,11],[108,10,108,11],[109,10,109,11],[109,2,109,7],[108,0,108,1],[108,2,108,7],[107,8,109,9],[11,11,13,11]]}
["Enter Company Name Here"]
["CONTRACTOR'S PROGRESS EARNINGS SCHEDULE (FORM C-13CPM)"]
["Enter Submission Number and Data Date Here (i.e. Baseline #01, DD: 9-01-19)"]
["CONTRACT ID. NO.:",null,null,null,null,null,null,null,null,null,"CONTRACT NTP DATE:"]
["PROJECT NO.:",null,null,null,null,null,null,null,null,null,"CONTRACT COMPLETION DATE:"]
["FHWA PROJECT NO.:",null,null,null,null,null,null,null,null,null,"PROJECTED COMPLETION DATE:"]
["PROJECT NAME:",null,null,null,null,null,null,null,null,null,"ORIGINAL TOTAL CONTRACT VALUE:"]
["ROUTE:",null,null,null,null,null,null,null,null,null,"ADJUSTED TOTAL CONTRACT VALUE:"]
["CITY/COUNTY:",null,null,null,null,null,null,null,null,null,"FIRST PROGRESS ESTIMATE DATE:"]
[null,null,null,null,null,null,null,null,null,null,"CURRENT PROGRESS ESTIMATE DATE:"]
[]
["MONTHLY PROGRESS ESTIMATE DATE","BASELINE MONTHLY     EARNINGS      (EARLY)","BASELINE CUMULATIVE            EARNINGS           (EARLY)","BASELINE PERCENT COMPLETE (EARLY)","BASELINE MONTHLY         EARNINGS         (LATE)","BASELINE CUMULATIVE                   EARNINGS            (LATE)","BASELINE PERCENT COMPLETE (LATE)","ACTUAL MONTHLY                 EARNINGS","ACTUAL CUMULATIVE EARNINGS","ACTUAL PROGRESS PERCENT COMPLETE","CURRENT PROJECTED MONTHLY       EARNINGS","CURRENT CUMULATIVE AT COMPLETION     EARNINGS","CURRENT/ PROJECTED PROGRESS PERCENT COMPLETE","PROGRESS VARIANCE (CURRENT % - BASELINE %)","SCHEDULE PERFORMANCE INDEX\n(SPI)"]
[]
[]
[{"$f":"IF($N$4=\"\",\"\",$N$4)","v":""},"Notice to Proceed Date",null,{"$f":"IF($A15=\"\",\"\",0)","v":""},{"$f":"IF($A15=\"\",\"\",0)","v":""},"","","","","","","","","",""]
[{"$f":"IF($N$9=\"\",\"\",$N$9)","v":""},{"$f":"IF($A16=\"\",\"\",'Earnings Data Input'!$B16)","v":""},{"$f":"IF($A16=\"\",\"\",SUM(B16,C15))","v":""},{"$f":"IF($A16=\"\",\"\",C16/$N$8)","v":""},{"$f":"IF($A16=\"\",\"\",'Earnings Data Input'!$C16)","v":""},{"$f":"IF($A16=\"\",\"\",SUM(E16,F15))","v":""},{"$f":"IF($A16=\"\",\"\",F16/$N$8)","v":""},null,null,null,{"$f":"IF($A16=\"\",\"\",IF(H16=\"\",'Earnings Data Input'!D16,0))","v":""},{"$f":"IF(A16=\"\",\"\",IF(NOT(I16=\"\"),I16,K16+L15))","v":""},{"$f":"IF($A16=\"\",\"\",IF(J16>0,J16,L16/$N$8))","v":""},{"$f":"IF(A16=\"\",\"\",M16-D16)","v":""},{"$f":"IF($A16=\"\",\"\",L16/C16)","v":""}]
[{"$f":"IF(A16=\"\",\"\",IF(AND((A16+31)>=($N$5+31),((A16+31)>=($N$6+31))),\"\",IF(AND((A16+31)>$N$5,(A16+31)>$N$6),IF($N$6>$N$5,$N$6,$N$5),EDATE(A16,1))))","v":""},{"$f":"IF($A17=\"\",\"\",'Earnings Data Input'!$B17)","v":""},{"$f":"IF($A17=\"\",\"\",SUM(B17,C16))","v":""},{"$f":"IF($A17=\"\",\"\",C17/$N$8)","v":""},{"$f":"IF($A17=\"\",\"\",'Earnings Data Input'!$C17)","v":""},{"$f":"IF($A17=\"\",\"\",SUM(E17,F16))","v":""},{"$f":"IF($A17=\"\",\"\",F17/$N$8)","v":""},null,null,null,{"$f":"IF($A17=\"\",\"\",IF(H17=\"\",'Earnings Data Input'!D17,0))","v":""},{"$f":"IF(A17=\"\",\"\",IF(K17=\"\",\"\",IF(NOT(I17=\"\"),I17,SUM(K17,L16))))","v":""},"",{"$f":"IF(A17=\"\",\"\",M17-D17)","v":""},{"$f":"IF($A17=\"\",\"\",L17/C17)","v":""}]
["",{"$f":"IF($A18=\"\",\"\",'Earnings Data Input'!$B18)","v":""},"","",{"$f":"IF($A18=\"\",\"\",'Earnings Data Input'!$C18)","v":""},"","",null,null,null,{"$f":"IF($A18=\"\",\"\",IF(H18=\"\",'Earnings Data Input'!D18,0))","v":""},"","","",""]
["",{"$f":"IF($A19=\"\",\"\",'Earnings Data Input'!$B19)","v":""},"","",{"$f":"IF($A19=\"\",\"\",'Earnings Data Input'!$C19)","v":""},"","",null,null,null,{"$f":"IF($A19=\"\",\"\",IF(H19=\"\",'Earnings Data Input'!D19,0))","v":""},"","","",""]
["",{"$f":"IF($A20=\"\",\"\",'Earnings Data Input'!$B20)","v":""},"","",{"$f":"IF($A20=\"\",\"\",'Earnings Data Input'!$C20)","v":""},"","",null,null,null,{"$f":"IF($A20=\"\",\"\",IF(H20=\"\",'Earnings Data Input'!D20,0))","v":""},"","","",""]
["",{"$f":"IF($A21=\"\",\"\",'Earnings Data Input'!$B21)","v":""},"","",{"$f":"IF($A21=\"\",\"\",'Earnings Data Input'!$C21)","v":""},"","",null,null,null,{"$f":"IF($A21=\"\",\"\",IF(H21=\"\",'Earnings Data Input'!D21,0))","v":""},"","","",""]
["",{"$f":"IF($A22=\"\",\"\",'Earnings Data Input'!$B22)","v":""},"","",{"$f":"IF($A22=\"\",\"\",'Earnings Data Input'!$C22)","v":""},"","",null,null,null,{"$f":"IF($A22=\"\",\"\",IF(H22=\"\",'Earnings Data Input'!D22,0))","v":""},"","","",""]
["",{"$f":"IF($A23=\"\",\"\",'Earnings Data Input'!$B23)","v":""},"","",{"$f":"IF($A23=\"\",\"\",'Earnings Data Input'!$C23)","v":""},"","",null,null,null,{"$f":"IF($A23=\"\",\"\",IF(H23=\"\",'Earnings Data Input'!D23,0))","v":""},"","","",""]
["",{"$f":"IF($A24=\"\",\"\",'Earnings Data Input'!$B24)","v":""},"","",{"$f":"IF($A24=\"\",\"\",'Earnings Data Input'!$C24)","v":""},"","",null,null,null,{"$f":"IF($A24=\"\",\"\",IF(H24=\"\",'Earnings Data Input'!D24,0))","v":""},"","","",""]
["",{"$f":"IF($A25=\"\",\"\",'Earnings Data Input'!$B25)","v":""},"","",{"$f":"IF($A25=\"\",\"\",'Earnings Data Input'!$C25)","v":""},"","",null,null,null,{"$f":"IF($A25=\"\",\"\",IF(H25=\"\",'Earnings Data Input'!D25,0))","v":""},"","","",""]
["",{"$f":"IF($A26=\"\",\"\",'Earnings Data Input'!$B26)","v":""},"","",{"$f":"IF($A26=\"\",\"\",'Earnings Data Input'!$C26)","v":""},"","",null,null,null,{"$f":"IF($A26=\"\",\"\",IF(H26=\"\",'Earnings Data Input'!D26,0))","v":""},"","","",""]
["",{"$f":"IF($A27=\"\",\"\",'Earnings Data Input'!$B27)","v":""},"","",{"$f":"IF($A27=\"\",\"\",'Earnings Data Input'!$C27)","v":""},"","",null,null,null,{"$f":"IF($A27=\"\",\"\",IF(H27=\"\",'Earnings Data Input'!D27,0))","v":""},"","","",""]
["",{"$f":"IF($A28=\"\",\"\",'Earnings Data Input'!$B28)","v":""},"","",{"$f":"IF($A28=\"\",\"\",'Earnings Data Input'!$C28)","v":""},"","",null,null,null,{"$f":"IF($A28=\"\",\"\",IF(H28=\"\",'Earnings Data Input'!D28,0))","v":""},"","","",""]
["",{"$f":"IF($A29=\"\",\"\",'Earnings Data Input'!$B29)","v":""},"","",{"$f":"IF($A29=\"\",\"\",'Earnings Data Input'!$C29)","v":""},"","",null,null,null,{"$f":"IF($A29=\"\",\"\",IF(H29=\"\",'Earnings Data Input'!D29,0))","v":""},"","","",""]
["",{"$f":"IF($A30=\"\",\"\",'Earnings Data Input'!$B30)","v":""},"","",{"$f":"IF($A30=\"\",\"\",'Earnings Data Input'!$C30)","v":""},"","",null,null,null,{"$f":"IF($A30=\"\",\"\",IF(H30=\"\",'Earnings Data Input'!D30,0))","v":""},"","","",""]
["",{"$f":"IF($A31=\"\",\"\",'Earnings Data Input'!$B31)","v":""},"","",{"$f":"IF($A31=\"\",\"\",'Earnings Data Input'!$C31)","v":""},"","",null,null,null,{"$f":"IF($A31=\"\",\"\",IF(H31=\"\",'Earnings Data Input'!D31,0))","v":""},"","","",""]
["",{"$f":"IF($A32=\"\",\"\",'Earnings Data Input'!$B32)","v":""},"","",{"$f":"IF($A32=\"\",\"\",'Earnings Data Input'!$C32)","v":""},"","",null,null,null,{"$f":"IF($A32=\"\",\"\",IF(H32=\"\",'Earnings Data Input'!D32,0))","v":""},"","","",""]
["",{"$f":"IF($A33=\"\",\"\",'Earnings Data Input'!$B33)","v":""},"","",{"$f":"IF($A33=\"\",\"\",'Earnings Data Input'!$C33)","v":""},"","",null,null,null,{"$f":"IF($A33=\"\",\"\",IF(H33=\"\",'Earnings Data Input'!D33,0))","v":""},"","","",""]
["",{"$f":"IF($A34=\"\",\"\",'Earnings Data Input'!$B34)","v":""},"","",{"$f":"IF($A34=\"\",\"\",'Earnings Data Input'!$C34)","v":""},"","",null,null,null,{"$f":"IF($A34=\"\",\"\",IF(H34=\"\",'Earnings Data Input'!D34,0))","v":""},"","","",""]
["",{"$f":"IF($A35=\"\",\"\",'Earnings Data Input'!$B35)","v":""},"","",{"$f":"IF($A35=\"\",\"\",'Earnings Data Input'!$C35)","v":""},"","",null,null,null,{"$f":"IF($A35=\"\",\"\",IF(H35=\"\",'Earnings Data Input'!D35,0))","v":""},"","","",""]
["",{"$f":"IF($A36=\"\",\"\",'Earnings Data Input'!$B36)","v":""},"","",{"$f":"IF($A36=\"\",\"\",'Earnings Data Input'!$C36)","v":""},"","",null,null,null,{"$f":"IF($A36=\"\",\"\",IF(H36=\"\",'Earnings Data Input'!D36,0))","v":""},"","","",""]
["",{"$f":"IF($A37=\"\",\"\",'Earnings Data Input'!$B37)","v":""},"","",{"$f":"IF($A37=\"\",\"\",'Earnings Data Input'!$C37)","v":""},"","",null,null,null,{"$f":"IF($A37=\"\",\"\",IF(H37=\"\",'Earnings Data Input'!D37,0))","v":""},"","","",""]
["",{"$f":"IF($A38=\"\",\"\",'Earnings Data Input'!$B38)","v":""},"","",{"$f":"IF($A38=\"\",\"\",'Earnings Data Input'!$C38)","v":""},"","",null,null,null,{"$f":"IF($A38=\"\",\"\",IF(H38=\"\",'Earnings Data Input'!D38,0))","v":""},"","","",""]
["",{"$f":"IF($A39=\"\",\"\",'Earnings Data Input'!$B39)","v":""},"","",{"$f":"IF($A39=\"\",\"\",'Earnings Data Input'!$C39)","v":""},"","",null,null,null,{"$f":"IF($A39=\"\",\"\",IF(H39=\"\",'Earnings Data Input'!D39,0))","v":""},"","","",""]
["",{"$f":"IF($A40=\"\",\"\",'Earnings Data Input'!$B40)","v":""},"","",{"$f":"IF($A40=\"\",\"\",'Earnings Data Input'!$C40)","v":""},"","",null,null,null,{"$f":"IF($A40=\"\",\"\",IF(H40=\"\",'Earnings Data Input'!D40,0))","v":""},"","","",""]
["",{"$f":"IF($A41=\"\",\"\",'Earnings Data Input'!$B41)","v":""},"","",{"$f":"IF($A41=\"\",\"\",'Earnings Data Input'!$C41)","v":""},"","",null,null,null,{"$f":"IF($A41=\"\",\"\",IF(H41=\"\",'Earnings Data Input'!D41,0))","v":""},"","","",""]
["",{"$f":"IF($A42=\"\",\"\",'Earnings Data Input'!$B42)","v":""},"","",{"$f":"IF($A42=\"\",\"\",'Earnings Data Input'!$C42)","v":""},"","",null,null,null,{"$f":"IF($A42=\"\",\"\",IF(H42=\"\",'Earnings Data Input'!D42,0))","v":""},"","","",""]
["",{"$f":"IF($A43=\"\",\"\",'Earnings Data Input'!$B43)","v":""},"","",{"$f":"IF($A43=\"\",\"\",'Earnings Data Input'!$C43)","v":""},"","",null,null,null,{"$f":"IF($A43=\"\",\"\",IF(H43=\"\",'Earnings Data Input'!D43,0))","v":""},"","","",""]
["",{"$f":"IF($A44=\"\",\"\",'Earnings Data Input'!$B44)","v":""},"","",{"$f":"IF($A44=\"\",\"\",'Earnings Data Input'!$C44)","v":""},"","",null,null,null,{"$f":"IF($A44=\"\",\"\",IF(H44=\"\",'Earnings Data Input'!D44,0))","v":""},"","","",""]
["",{"$f":"IF($A45=\"\",\"\",'Earnings Data Input'!$B45)","v":""},"","",{"$f":"IF($A45=\"\",\"\",'Earnings Data Input'!$C45)","v":""},"","",null,null,null,{"$f":"IF($A45=\"\",\"\",IF(H45=\"\",'Earnings Data Input'!D45,0))","v":""},"","","",""]
["",{"$f":"IF($A46=\"\",\"\",'Earnings Data Input'!$B46)","v":""},"","",{"$f":"IF($A46=\"\",\"\",'Earnings Data Input'!$C46)","v":""},"","",null,null,null,{"$f":"IF($A46=\"\",\"\",IF(H46=\"\",'Earnings Data Input'!D46,0))","v":""},"","","",""]
["",{"$f":"IF($A47=\"\",\"\",'Earnings Data Input'!$B47)","v":""},"","",{"$f":"IF($A47=\"\",\"\",'Earnings Data Input'!$C47)","v":""},"","",null,null,null,{"$f":"IF($A47=\"\",\"\",IF(H47=\"\",'Earnings Data Input'!D47,0))","v":""},"","","",""]
["",{"$f":"IF($A48=\"\",\"\",'Earnings Data Input'!$B48)","v":""},"","",{"$f":"IF($A48=\"\",\"\",'Earnings Data Input'!$C48)","v":""},"","",null,null,null,{"$f":"IF($A48=\"\",\"\",IF(H48=\"\",'Earnings Data Input'!D48,0))","v":""},"",{"$f":"IF($A48=\"\",\"\",IF(J48>0,J48,L48/$N$8))","v":""},"",""]
[{"$f":"IF(A48=\"\",\"\",IF(AND((A48+31)>=($N$5+31),((A48+31)>=($N$6+31))),\"\",IF(AND((A48+31)>$N$5,(A48+31)>$N$6),IF($N$6>$N$5,$N$6,$N$5),EDATE(A48,1))))","v":""},{"$f":"IF($A49=\"\",\"\",'Earnings Data Input'!$B49)","v":""},"","",{"$f":"IF($A49=\"\",\"\",'Earnings Data Input'!$C49)","v":""},"","",null,null,null,{"$f":"IF($A49=\"\",\"\",IF(H49=\"\",'Earnings Data Input'!D49,0))","v":""},{"$f":"IF(A49=\"\",\"\",IF(K49=\"\",\"\",IF(NOT(I49=\"\"),I49,SUM(K49,L48))))","v":""},"","",""]
["",{"$f":"IF($A50=\"\",\"\",'Earnings Data Input'!$B50)","v":""},"","",{"$f":"IF($A50=\"\",\"\",'Earnings Data Input'!$C50)","v":""},"","",null,null,null,{"$f":"IF($A50=\"\",\"\",IF(H50=\"\",'Earnings Data Input'!D50,0))","v":""},"","","",""]
["",{"$f":"IF($A51=\"\",\"\",'Earnings Data Input'!$B51)","v":""},"","",{"$f":"IF($A51=\"\",\"\",'Earnings Data Input'!$C51)","v":""},"","",null,null,null,{"$f":"IF($A51=\"\",\"\",IF(H51=\"\",'Earnings Data Input'!D51,0))","v":""},"","","",""]
["",{"$f":"IF($A52=\"\",\"\",'Earnings Data Input'!$B52)","v":""},"","",{"$f":"IF($A52=\"\",\"\",'Earnings Data Input'!$C52)","v":""},"","",null,null,null,{"$f":"IF($A52=\"\",\"\",IF(H52=\"\",'Earnings Data Input'!D52,0))","v":""},"","","",""]
["",{"$f":"IF($A53=\"\",\"\",'Earnings Data Input'!$B53)","v":""},"","",{"$f":"IF($A53=\"\",\"\",'Earnings Data Input'!$C53)","v":""},"","",null,null,null,{"$f":"IF($A53=\"\",\"\",IF(H53=\"\",'Earnings Data Input'!D53,0))","v":""},"","","",""]
["",{"$f":"IF($A54=\"\",\"\",'Earnings Data Input'!$B54)","v":""},"","",{"$f":"IF($A54=\"\",\"\",'Earnings Data Input'!$C54)","v":""},"","",null,null,null,{"$f":"IF($A54=\"\",\"\",IF(H54=\"\",'Earnings Data Input'!D54,0))","v":""},"","","",""]
["",{"$f":"IF($A55=\"\",\"\",'Earnings Data Input'!$B55)","v":""},"","",{"$f":"IF($A55=\"\",\"\",'Earnings Data Input'!$C55)","v":""},"","",null,null,null,{"$f":"IF($A55=\"\",\"\",IF(H55=\"\",'Earnings Data Input'!D55,0))","v":""},"","","",""]
["",{"$f":"IF($A56=\"\",\"\",'Earnings Data Input'!$B56)","v":""},"","",{"$f":"IF($A56=\"\",\"\",'Earnings Data Input'!$C56)","v":""},"","",null,null,null,{"$f":"IF($A56=\"\",\"\",IF(H56=\"\",'Earnings Data Input'!D56,0))","v":""},"","","",""]
["",{"$f":"IF($A57=\"\",\"\",'Earnings Data Input'!$B57)","v":""},"","",{"$f":"IF($A57=\"\",\"\",'Earnings Data Input'!$C57)","v":""},"","",null,null,null,{"$f":"IF($A57=\"\",\"\",IF(H57=\"\",'Earnings Data Input'!D57,0))","v":""},"","","",""]
["",{"$f":"IF($A58=\"\",\"\",'Earnings Data Input'!$B58)","v":""},"","",{"$f":"IF($A58=\"\",\"\",'Earnings Data Input'!$C58)","v":""},"","",null,null,null,{"$f":"IF($A58=\"\",\"\",IF(H58=\"\",'Earnings Data Input'!D58,0))","v":""},"","","",""]
["",{"$f":"IF($A59=\"\",\"\",'Earnings Data Input'!$B59)","v":""},"","",{"$f":"IF($A59=\"\",\"\",'Earnings Data Input'!$C59)","v":""},"","",null,null,null,{"$f":"IF($A59=\"\",\"\",IF(H59=\"\",'Earnings Data Input'!D59,0))","v":""},"","","",""]
["",{"$f":"IF($A60=\"\",\"\",'Earnings Data Input'!$B60)","v":""},"","",{"$f":"IF($A60=\"\",\"\",'Earnings Data Input'!$C60)","v":""},"","",null,null,null,{"$f":"IF($A60=\"\",\"\",IF(H60=\"\",'Earnings Data Input'!D60,0))","v":""},"","","",""]
["",{"$f":"IF($A61=\"\",\"\",'Earnings Data Input'!$B61)","v":""},"","",{"$f":"IF($A61=\"\",\"\",'Earnings Data Input'!$C61)","v":""},"","",null,null,null,{"$f":"IF($A61=\"\",\"\",IF(H61=\"\",'Earnings Data Input'!D61,0))","v":""},"","","",""]
["",{"$f":"IF($A62=\"\",\"\",'Earnings Data Input'!$B62)","v":""},"","",{"$f":"IF($A62=\"\",\"\",'Earnings Data Input'!$C62)","v":""},"","",null,null,null,{"$f":"IF($A62=\"\",\"\",IF(H62=\"\",'Earnings Data Input'!D62,0))","v":""},"","","",""]
["",{"$f":"IF($A63=\"\",\"\",'Earnings Data Input'!$B63)","v":""},"","",{"$f":"IF($A63=\"\",\"\",'Earnings Data Input'!$C63)","v":""},"","",null,null,null,{"$f":"IF($A63=\"\",\"\",IF(H63=\"\",'Earnings Data Input'!D63,0))","v":""},"","","",""]
["",{"$f":"IF($A64=\"\",\"\",'Earnings Data Input'!$B64)","v":""},"","",{"$f":"IF($A64=\"\",\"\",'Earnings Data Input'!$C64)","v":""},"","",null,null,null,{"$f":"IF($A64=\"\",\"\",IF(H64=\"\",'Earnings Data Input'!D64,0))","v":""},"","","",""]
["",{"$f":"IF($A65=\"\",\"\",'Earnings Data Input'!$B65)","v":""},"","",{"$f":"IF($A65=\"\",\"\",'Earnings Data Input'!$C65)","v":""},"","",null,null,null,{"$f":"IF($A65=\"\",\"\",IF(H65=\"\",'Earnings Data Input'!D65,0))","v":""},"","","",""]
["",{"$f":"IF($A66=\"\",\"\",'Earnings Data Input'!$B66)","v":""},"","",{"$f":"IF($A66=\"\",\"\",'Earnings Data Input'!$C66)","v":""},"","",null,null,null,{"$f":"IF($A66=\"\",\"\",IF(H66=\"\",'Earnings Data Input'!D66,0))","v":""},"","","",""]
["",{"$f":"IF($A67=\"\",\"\",'Earnings Data Input'!$B67)","v":""},"","",{"$f":"IF($A67=\"\",\"\",'Earnings Data Input'!$C67)","v":""},"","",null,null,null,{"$f":"IF($A67=\"\",\"\",IF(H67=\"\",'Earnings Data Input'!D67,0))","v":""},"","","",""]
["",{"$f":"IF($A68=\"\",\"\",'Earnings Data Input'!$B68)","v":""},"","",{"$f":"IF($A68=\"\",\"\",'Earnings Data Input'!$C68)","v":""},"","",null,null,null,{"$f":"IF($A68=\"\",\"\",IF(H68=\"\",'Earnings Data Input'!D68,0))","v":""},"","","",""]
["",{"$f":"IF($A69=\"\",\"\",'Earnings Data Input'!$B69)","v":""},"","",{"$f":"IF($A69=\"\",\"\",'Earnings Data Input'!$C69)","v":""},"","",null,null,null,{"$f":"IF($A69=\"\",\"\",IF(H69=\"\",'Earnings Data Input'!D69,0))","v":""},"","","",""]
["",{"$f":"IF($A70=\"\",\"\",'Earnings Data Input'!$B70)","v":""},"","",{"$f":"IF($A70=\"\",\"\",'Earnings Data Input'!$C70)","v":""},"","",null,null,null,{"$f":"IF($A70=\"\",\"\",IF(H70=\"\",'Earnings Data Input'!D70,0))","v":""},"","","",""]
["",{"$f":"IF($A71=\"\",\"\",'Earnings Data Input'!$B71)","v":""},"","",{"$f":"IF($A71=\"\",\"\",'Earnings Data Input'!$C71)","v":""},"","",null,null,null,{"$f":"IF($A71=\"\",\"\",IF(H71=\"\",'Earnings Data Input'!D71,0))","v":""},"","","",""]
["",{"$f":"IF($A72=\"\",\"\",'Earnings Data Input'!$B72)","v":""},"","",{"$f":"IF($A72=\"\",\"\",'Earnings Data Input'!$C72)","v":""},"","",null,null,null,{"$f":"IF($A72=\"\",\"\",IF(H72=\"\",'Earnings Data Input'!D72,0))","v":""},"","","",""]
["",{"$f":"IF($A73=\"\",\"\",'Earnings Data Input'!$B73)","v":""},"","",{"$f":"IF($A73=\"\",\"\",'Earnings Data Input'!$C73)","v":""},"","",null,null,null,{"$f":"IF($A73=\"\",\"\",IF(H73=\"\",'Earnings Data Input'!D73,0))","v":""},"","","",""]
["",{"$f":"IF($A74=\"\",\"\",'Earnings Data Input'!$B74)","v":""},"","",{"$f":"IF($A74=\"\",\"\",'Earnings Data Input'!$C74)","v":""},"","",null,null,null,{"$f":"IF($A74=\"\",\"\",IF(H74=\"\",'Earnings Data Input'!D74,0))","v":""},"","","",""]
["",{"$f":"IF($A75=\"\",\"\",'Earnings Data Input'!$B75)","v":""},"","",{"$f":"IF($A75=\"\",\"\",'Earnings Data Input'!$C75)","v":""},"","",null,null,null,{"$f":"IF($A75=\"\",\"\",IF(H75=\"\",'Earnings Data Input'!D75,0))","v":""},"","","",""]
["",{"$f":"IF($A76=\"\",\"\",'Earnings Data Input'!$B76)","v":""},"","",{"$f":"IF($A76=\"\",\"\",'Earnings Data Input'!$C76)","v":""},"","",null,null,null,{"$f":"IF($A76=\"\",\"\",IF(H76=\"\",'Earnings Data Input'!D76,0))","v":""},"","","",""]
["",{"$f":"IF($A77=\"\",\"\",'Earnings Data Input'!$B77)","v":""},{"$f":"IF($A77=\"\",\"\",SUM(B77,C76))","v":""},{"$f":"IF($A77=\"\",\"\",C77/$N$8)","v":""},{"$f":"IF($A77=\"\",\"\",'Earnings Data Input'!$C77)","v":""},{"$f":"IF($A77=\"\",\"\",SUM(E77,F76))","v":""},{"$f":"IF($A77=\"\",\"\",F77/$N$8)","v":""},null,null,null,{"$f":"IF($A77=\"\",\"\",IF(H77=\"\",'Earnings Data Input'!D77,0))","v":""},"","","",""]
["",{"$f":"IF($A78=\"\",\"\",'Earnings Data Input'!$B78)","v":""},"","",{"$f":"IF($A78=\"\",\"\",'Earnings Data Input'!$C78)","v":""},"","",null,null,null,{"$f":"IF($A78=\"\",\"\",IF(H78=\"\",'Earnings Data Input'!D78,0))","v":""},"","","",""]
["",{"$f":"IF($A79=\"\",\"\",'Earnings Data Input'!$B79)","v":""},"","",{"$f":"IF($A79=\"\",\"\",'Earnings Data Input'!$C79)","v":""},"","",null,null,null,{"$f":"IF($A79=\"\",\"\",IF(H79=\"\",'Earnings Data Input'!D79,0))","v":""},"","","",""]
["",{"$f":"IF($A80=\"\",\"\",'Earnings Data Input'!$B80)","v":""},"","",{"$f":"IF($A80=\"\",\"\",'Earnings Data Input'!$C80)","v":""},"","",null,null,null,{"$f":"IF($A80=\"\",\"\",IF(H80=\"\",'Earnings Data Input'!D80,0))","v":""},"",{"$f":"IF($A80=\"\",\"\",IF(J80>0,J80,L80/$N$8))","v":""},"",""]
["",{"$f":"IF($A81=\"\",\"\",'Earnings Data Input'!$B81)","v":""},"","",{"$f":"IF($A81=\"\",\"\",'Earnings Data Input'!$C81)","v":""},"","",null,null,null,{"$f":"IF($A81=\"\",\"\",IF(H81=\"\",'Earnings Data Input'!D81,0))","v":""},{"$f":"IF(A81=\"\",\"\",IF(K81=\"\",\"\",IF(NOT(I81=\"\"),I81,SUM(K81,L80))))","v":""},"",{"$f":"IF(A81=\"\",\"\",M81-D81)","v":""},{"$f":"IF($A81=\"\",\"\",L81/C81)","v":""}]
["",{"$f":"IF($A82=\"\",\"\",'Earnings Data Input'!$B82)","v":""},"","",{"$f":"IF($A82=\"\",\"\",'Earnings Data Input'!$C82)","v":""},"","",null,null,null,{"$f":"IF($A82=\"\",\"\",IF(H82=\"\",'Earnings Data Input'!D82,0))","v":""},"","","",""]
["",{"$f":"IF($A83=\"\",\"\",'Earnings Data Input'!$B83)","v":""},"","",{"$f":"IF($A83=\"\",\"\",'Earnings Data Input'!$C83)","v":""},"","",null,null,null,{"$f":"IF($A83=\"\",\"\",IF(H83=\"\",'Earnings Data Input'!D83,0))","v":""},"","","",""]
["",{"$f":"IF($A84=\"\",\"\",'Earnings Data Input'!$B84)","v":""},"","",{"$f":"IF($A84=\"\",\"\",'Earnings Data Input'!$C84)","v":""},"","",null,null,null,{"$f":"IF($A84=\"\",\"\",IF(H84=\"\",'Earnings Data Input'!D84,0))","v":""},"","","",""]
["",{"$f":"IF($A85=\"\",\"\",'Earnings Data Input'!$B85)","v":""},"","",{"$f":"IF($A85=\"\",\"\",'Earnings Data Input'!$C85)","v":""},"","",null,null,null,{"$f":"IF($A85=\"\",\"\",IF(H85=\"\",'Earnings Data Input'!D85,0))","v":""},"","","",""]
["",{"$f":"IF($A86=\"\",\"\",'Earnings Data Input'!$B86)","v":""},"","",{"$f":"IF($A86=\"\",\"\",'Earnings Data Input'!$C86)","v":""},"","",null,null,null,{"$f":"IF($A86=\"\",\"\",IF(H86=\"\",'Earnings Data Input'!D86,0))","v":""},"","","",""]
["",{"$f":"IF($A87=\"\",\"\",'Earnings Data Input'!$B87)","v":""},"","",{"$f":"IF($A87=\"\",\"\",'Earnings Data Input'!$C87)","v":""},"","",null,null,null,{"$f":"IF($A87=\"\",\"\",IF(H87=\"\",'Earnings Data Input'!D87,0))","v":""},"","","",""]
["",{"$f":"IF($A88=\"\",\"\",'Earnings Data Input'!$B88)","v":""},"","",{"$f":"IF($A88=\"\",\"\",'Earnings Data Input'!$C88)","v":""},"","",null,null,null,{"$f":"IF($A88=\"\",\"\",IF(H88=\"\",'Earnings Data Input'!D88,0))","v":""},"","","",""]
["",{"$f":"IF($A89=\"\",\"\",'Earnings Data Input'!$B89)","v":""},"","",{"$f":"IF($A89=\"\",\"\",'Earnings Data Input'!$C89)","v":""},"","",null,null,null,{"$f":"IF($A89=\"\",\"\",IF(H89=\"\",'Earnings Data Input'!D89,0))","v":""},"","","",""]
["",{"$f":"IF($A90=\"\",\"\",'Earnings Data Input'!$B90)","v":""},"","",{"$f":"IF($A90=\"\",\"\",'Earnings Data Input'!$C90)","v":""},"","",null,null,null,{"$f":"IF($A90=\"\",\"\",IF(H90=\"\",'Earnings Data Input'!D90,0))","v":""},"","","",""]
["",{"$f":"IF($A91=\"\",\"\",'Earnings Data Input'!$B91)","v":""},"","",{"$f":"IF($A91=\"\",\"\",'Earnings Data Input'!$C91)","v":""},"","",null,null,null,{"$f":"IF($A91=\"\",\"\",IF(H91=\"\",'Earnings Data Input'!D91,0))","v":""},"","","",""]
["",{"$f":"IF($A92=\"\",\"\",'Earnings Data Input'!$B92)","v":""},"","",{"$f":"IF($A92=\"\",\"\",'Earnings Data Input'!$C92)","v":""},"","",null,null,null,{"$f":"IF($A92=\"\",\"\",IF(H92=\"\",'Earnings Data Input'!D92,0))","v":""},"","","",""]
["",{"$f":"IF($A93=\"\",\"\",'Earnings Data Input'!$B93)","v":""},"","",{"$f":"IF($A93=\"\",\"\",'Earnings Data Input'!$C93)","v":""},"","",null,null,null,{"$f":"IF($A93=\"\",\"\",IF(H93=\"\",'Earnings Data Input'!D93,0))","v":""},"","","",""]
["",{"$f":"IF($A94=\"\",\"\",'Earnings Data Input'!$B94)","v":""},"","",{"$f":"IF($A94=\"\",\"\",'Earnings Data Input'!$C94)","v":""},"","",null,null,null,{"$f":"IF($A94=\"\",\"\",IF(H94=\"\",'Earnings Data Input'!D94,0))","v":""},"","","",""]
["",{"$f":"IF($A95=\"\",\"\",'Earnings Data Input'!$B95)","v":""},"","",{"$f":"IF($A95=\"\",\"\",'Earnings Data Input'!$C95)","v":""},"","",null,null,null,{"$f":"IF($A95=\"\",\"\",IF(H95=\"\",'Earnings Data Input'!D95,0))","v":""},"","","",""]
["",{"$f":"IF($A96=\"\",\"\",'Earnings Data Input'!$B96)","v":""},"","",{"$f":"IF($A96=\"\",\"\",'Earnings Data Input'!$C96)","v":""},"","",null,null,null,{"$f":"IF($A96=\"\",\"\",IF(H96=\"\",'Earnings Data Input'!D96,0))","v":""},"","","",""]
["",{"$f":"IF($A97=\"\",\"\",'Earnings Data Input'!$B97)","v":""},"","",{"$f":"IF($A97=\"\",\"\",'Earnings Data Input'!$C97)","v":""},"","",null,null,null,{"$f":"IF($A97=\"\",\"\",IF(H97=\"\",'Earnings Data Input'!D97,0))","v":""},"","","",""]
["",{"$f":"IF($A98=\"\",\"\",'Earnings Data Input'!$B98)","v":""},"","",{"$f":"IF($A98=\"\",\"\",'Earnings Data Input'!$C98)","v":""},"","",null,null,null,{"$f":"IF($A98=\"\",\"\",IF(H98=\"\",'Earnings Data Input'!D98,0))","v":""},"","","",""]
["",{"$f":"IF($A99=\"\",\"\",'Earnings Data Input'!$B99)","v":""},"","",{"$f":"IF($A99=\"\",\"\",'Earnings Data Input'!$C99)","v":""},"","",null,null,null,{"$f":"IF($A99=\"\",\"\",IF(H99=\"\",'Earnings Data Input'!D99,0))","v":""},"","","",""]
["",{"$f":"IF($A100=\"\",\"\",'Earnings Data Input'!$B100)","v":""},{"$f":"IF($A100=\"\",\"\",SUM(B100,C99))","v":""},{"$f":"IF($A100=\"\",\"\",C100/$N$8)","v":""},{"$f":"IF($A100=\"\",\"\",'Earnings Data Input'!$C100)","v":""},{"$f":"IF($A100=\"\",\"\",SUM(E100,F99))","v":""},{"$f":"IF($A100=\"\",\"\",F100/$N$8)","v":""},null,null,null,{"$f":"IF($A100=\"\",\"\",IF(H100=\"\",'Earnings Data Input'!D100,0))","v":""},"","",{"$f":"IF(A100=\"\",\"\",M100-D100)","v":""},{"$f":"IF($A100=\"\",\"\",L100/C100)","v":""}]
[]
["Note: "]
["Form C-13CPM is required by specifications to prepare the Contractor's Progress Earnings Schedule for Category IV, V, and  Design-Build projects. "]
[]
["COMMONWEALTH OF VIRGINIA"]
["DEPARTMENT OF TRANSPORTATION"]
[]
["ACCEPTED BY:",null,null,null,null,null,null,null,null,null,"CONTRACTOR:",null,{"$f":"A$1","v":"Enter Company Name Here"}]
["TITLE:",null,null,null,null,null,null,null,null,null,"PROJECT MANAGER:"]
["DATE:",null,null,null,null,null,null,null,null,null,"SUBMITTAL DATE:"]

{"sheet":"Earnings Data Input","index":2,"n_rows":100,"n_cols":87,"rows_kept":100,"cut":false,"hidden":false,"merged":[[11,0,11,1],[0,0,0,4],[7,0,7,4],[12,0,12,1],[13,0,13,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[6,0,6,1],[4,0,4,1],[5,0,5,1],[8,0,8,1],[9,0,9,1],[10,0,10,1]]}
["BASELINE MONTHLY COST (EARNINGS) DATA "]
["Payment Estimate Dates",null,{"$f":"IF($A16=\"\",\"\",$A16)","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A17<=MAX($A$16:$A$100),$A17,IF(AND(C$2=MAX($A$16:$A$100),$A18=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A18<=MAX($A$16:$A$100),$A18,IF(AND(D$2=MAX($A$16:$A$100),$A19=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A19<=MAX($A$16:$A$100),$A19,IF(AND(E$2=MAX($A$16:$A$100),$A20=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A20<=MAX($A$16:$A$100),$A20,IF(AND(F$2=MAX($A$16:$A$100),$A21=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A21<=MAX($A$16:$A$100),$A21,IF(AND(G$2=MAX($A$16:$A$100),$A22=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A22<=MAX($A$16:$A$100),$A22,IF(AND(H$2=MAX($A$16:$A$100),$A23=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A23<=MAX($A$16:$A$100),$A23,IF(AND(I$2=MAX($A$16:$A$100),$A24=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A24<=MAX($A$16:$A$100),$A24,IF(AND(J$2=MAX($A$16:$A$100),$A25=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A25<=MAX($A$16:$A$100),$A25,IF(AND(K$2=MAX($A$16:$A$100),$A26=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A26<=MAX($A$16:$A$100),$A26,IF(AND(L$2=MAX($A$16:$A$100),$A27=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A27<=MAX($A$16:$A$100),$A27,IF(AND(M$2=MAX($A$16:$A$100),$A28=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A28<=MAX($A$16:$A$100),$A28,IF(AND(N$2=MAX($A$16:$A$100),$A29=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A29<=MAX($A$16:$A$100),$A29,IF(AND(O$2=MAX($A$16:$A$100),$A30=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A30<=MAX($A$16:$A$100),$A30,IF(AND(P$2=MAX($A$16:$A$100),$A31=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A31<=MAX($A$16:$A$100),$A31,IF(AND(Q$2=MAX($A$16:$A$100),$A32=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A32<=MAX($A$16:$A$100),$A32,IF(AND(R$2=MAX($A$16:$A$100),$A33=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A33<=MAX($A$16:$A$100),$A33,IF(AND(S$2=MAX($A$16:$A$100),$A34=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A34<=MAX($A$16:$A$100),$A34,IF(AND(T$2=MAX($A$16:$A$100),$A35=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A35<=MAX($A$16:$A$100),$A35,IF(AND(U$2=MAX($A$16:$A$100),$A36=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A36<=MAX($A$16:$A$100),$A36,IF(AND(V$2=MAX($A$16:$A$100),$A37=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A37<=MAX($A$16:$A$100),$A37,IF(AND(W$2=MAX($A$16:$A$100),$A38=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A38<=MAX($A$16:$A$100),$A38,IF(AND(X$2=MAX($A$16:$A$100),$A39=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A39<=MAX($A$16:$A$100),$A39,IF(AND(Y$2=MAX($A$16:$A$100),$A40=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A40<=MAX($A$16:$A$100),$A40,IF(AND(Z$2=MAX($A$16:$A$100),$A41=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A41<=MAX($A$16:$A$100),$A41,IF(AND(AA$2=MAX($A$16:$A$100),$A42=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A42<=MAX($A$16:$A$100),$A42,IF(AND(AB$2=MAX($A$16:$A$100),$A43=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A43<=MAX($A$16:$A$100),$A43,IF(AND(AC$2=MAX($A$16:$A$100),$A44=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A44<=MAX($A$16:$A$100),$A44,IF(AND(AD$2=MAX($A$16:$A$100),$A45=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A45<=MAX($A$16:$A$100),$A45,IF(AND(AE$2=MAX($A$16:$A$100),$A46=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A46<=MAX($A$16:$A$100),$A46,IF(AND(AF$2=MAX($A$16:$A$100),$A47=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A47<=MAX($A$16:$A$100),$A47,IF(AND(AG$2=MAX($A$16:$A$100),$A48=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A48<=MAX($A$16:$A$100),$A48,IF(AND(AH$2=MAX($A$16:$A$100),$A49=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A49<=MAX($A$16:$A$100),$A49,IF(AND(AI$2=MAX($A$16:$A$100),$A50=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A50<=MAX($A$16:$A$100),$A50,IF(AND(AJ$2=MAX($A$16:$A$100),$A51=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A51<=MAX($A$16:$A$100),$A51,IF(AND(AK$2=MAX($A$16:$A$100),$A52=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A52<=MAX($A$16:$A$100),$A52,IF(AND(AL$2=MAX($A$16:$A$100),$A53=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A53<=MAX($A$16:$A$100),$A53,IF(AND(AM$2=MAX($A$16:$A$100),$A54=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A54<=MAX($A$16:$A$100),$A54,IF(AND(AN$2=MAX($A$16:$A$100),$A55=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A55<=MAX($A$16:$A$100),$A55,IF(AND(AO$2=MAX($A$16:$A$100),$A56=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A56<=MAX($A$16:$A$100),$A56,IF(AND(AP$2=MAX($A$16:$A$100),$A57=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A57<=MAX($A$16:$A$100),$A57,IF(AND(AQ$2=MAX($A$16:$A$100),$A58=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A58<=MAX($A$16:$A$100),$A58,IF(AND(AR$2=MAX($A$16:$A$100),$A59=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A59<=MAX($A$16:$A$100),$A59,IF(AND(AS$2=MAX($A$16:$A$100),$A60=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A60<=MAX($A$16:$A$100),$A60,IF(AND(AT$2=MAX($A$16:$A$100),$A61=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A61<=MAX($A$16:$A$100),$A61,IF(AND(AU$2=MAX($A$16:$A$100),$A62=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A62<=MAX($A$16:$A$100),$A62,IF(AND(AV$2=MAX($A$16:$A$100),$A63=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A63<=MAX($A$16:$A$100),$A63,IF(AND(AW$2=MAX($A$16:$A$100),$A64=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A64<=MAX($A$16:$A$100),$A64,IF(AND(AX$2=MAX($A$16:$A$100),$A65=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A65<=MAX($A$16:$A$100),$A65,IF(AND(AY$2=MAX($A$16:$A$100),$A66=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A66<=MAX($A$16:$A$100),$A66,IF(AND(AZ$2=MAX($A$16:$A$100),$A67=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A67<=MAX($A$16:$A$100),$A67,IF(AND(BA$2=MAX($A$16:$A$100),$A68=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A68<=MAX($A$16:$A$100),$A68,IF(AND(BB$2=MAX($A$16:$A$100),$A69=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A69<=MAX($A$16:$A$100),$A69,IF(AND(BC$2=MAX($A$16:$A$100),$A70=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A70<=MAX($A$16:$A$100),$A70,IF(AND(BD$2=MAX($A$16:$A$100),$A71=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A71<=MAX($A$16:$A$100),$A71,IF(AND(BE$2=MAX($A$16:$A$100),$A72=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A72<=MAX($A$16:$A$100),$A72,IF(AND(BF$2=MAX($A$16:$A$100),$A73=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A73<=MAX($A$16:$A$100),$A73,IF(AND(BG$2=MAX($A$16:$A$100),$A74=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A74<=MAX($A$16:$A$100),$A74,IF(AND(BH$2=MAX($A$16:$A$100),$A75=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A75<=MAX($A$16:$A$100),$A75,IF(AND(BI$2=MAX($A$16:$A$100),$A76=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A76<=MAX($A$16:$A$100),$A76,IF(AND(BJ$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A77<=MAX($A$16:$A$100),$A77,IF(AND(BK$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A78<=MAX($A$16:$A$100),$A78,IF(AND(BL$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A79<=MAX($A$16:$A$100),$A79,IF(AND(BM$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A80<=MAX($A$16:$A$100),$A80,IF(AND(BN$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A81<=MAX($A$16:$A$100),$A81,IF(AND(BO$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A82<=MAX($A$16:$A$100),$A82,IF(AND(BP$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A83<=MAX($A$16:$A$100),$A83,IF(AND(BQ$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A84<=MAX($A$16:$A$100),$A84,IF(AND(BR$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A85<=MAX($A$16:$A$100),$A85,IF(AND(BS$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A86<=MAX($A$16:$A$100),$A86,IF(AND(BT$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A87<=MAX($A$16:$A$100),$A87,IF(AND(BU$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A88<=MAX($A$16:$A$100),$A88,IF(AND(BV$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A89<=MAX($A$16:$A$100),$A89,IF(AND(BW$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A90<=MAX($A$16:$A$100),$A90,IF(AND(BX$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A91<=MAX($A$16:$A$100),$A91,IF(AND(BY$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A92<=MAX($A$16:$A$100),$A92,IF(AND(BZ$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A93<=MAX($A$16:$A$100),$A93,IF(AND(CA$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A94<=MAX($A$16:$A$100),$A94,IF(AND(CB$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A95<=MAX($A$16:$A$100),$A95,IF(AND(CC$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A96<=MAX($A$16:$A$100),$A96,IF(AND(CD$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A97<=MAX($A$16:$A$100),$A97,IF(AND(CE$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A98<=MAX($A$16:$A$100),$A98,IF(AND(CF$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A99<=MAX($A$16:$A$100),$A99,IF(AND(CG$2=MAX($A$16:$A$100),$A100=\"\"),\"Total\",\"\")))","v":""},{"$f":"IF($A$16=\"\",\"\",IF($A100<=MAX($A$16:$A$100),$A100,IF(AND(BK$2=MAX($A$16:$A$100),$A101=\"\"),\"Total\",\"\")))","v":""}]
["Actual Cost"]
["Remaining Cost (Early)"]
["Remaining Cost (Late)"]
["At Completion Cost"]
["Cum At Completion Cost"]
["CURRENT UPDATE MONTHLY COST (EARNINGS) DATA "]
["Payment Estimate Dates",null,{"$f":"IF(C2=\"\",\"\",C2)","v":""},{"$f":"IF(D2=\"\",\"\",D2)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Actual Cost"]
["Remaining Cost (Early)"]
["Remaining Cost (Late)"]
["At Completion Cost"]
["Cum At Completion Cost"]
["MONTHLY ESTIMATE DATES","BASELINE MONTHLY EARNINGS (EARLY)","BASELINE MONTHLY EARNINGS (LATE)","CURRENT PROJECTED MONTHLY EARNINGS","CURRENT UPDATE CUM AT COMPLETION COST","CURRENT ACTUAL/    PROJECTED CUM AT COMPLETION EARNINGS","CUM AT COMPLETION EARNINGS VARIANCE (COLUMN E - F)"]
[{"$f":"IF('Controls Chart Data'!A16=\"\",\"\",'Controls Chart Data'!A16)","v":""},{"$f":"IF($A16=\"\",\"\",IF(OR($C$2=\"\",$C$2=\"Period Total\",$C$2=\"Total\"),\"\",IF($C$4=\"\",$C$3,$C$4)))","v":""},{"$f":"IF($A16=\"\",\"\",IF(OR($C$2=\"\",$C$2=\"Period Total\",$C$2=\"Total\"),\"\",IF($C$5=\"\",$C$3,$C$5)))","v":""},{"$f":"IF($A16=\"\",\"\",IF(OR($C$9=\"\",$C$9=\"Period Total\",$C$9=\"Total\"),\"\",$C$11))","v":""},{"$f":"IF($A16=\"\",\"\",IF(OR($C$9=\"\",$C$9=\"Period Total\",$C$9=\"Total\"),\"\",$C$14))","v":""},{"$f":"IF(A16=\"\",\"\",'Controls Chart Data'!L16)","v":""},{"$f":"IF(A16=\"\",\"\",E16-F16)","v":""}]
[{"$f":"IF('Controls Chart Data'!A17=\"\",\"\",'Controls Chart Data'!A17)","v":""},{"$f":"IF($A17=\"\",\"\",IF(OR($D$2=\"\",$D$2=\"Period Total\",$D$2=\"Total\"),\"\",IF($D$4=\"\",$D$3,$D$4)))","v":""},{"$f":"IF($A17=\"\",\"\",IF(OR($D$2=\"\",$D$2=\"Period Total\",$D$2=\"Total\"),\"\",IF($D$5=\"\",$D$3,$D$5)))","v":""},{"$f":"IF($A17=\"\",\"\",IF(OR($D$9=\"\",$D$9=\"Period Total\",$D$9=\"Total\"),\"\",$D$11))","v":""},{"$f":"IF($A17=\"\",\"\",IF(OR($D$9=\"\",$D$9=\"Period Total\",$D$9=\"Total\"),\"\",$D$14))","v":""},{"$f":"IF(A17=\"\",\"\",'Controls Chart Data'!L17)","v":""},{"$f":"IF(A17=\"\",\"\",E17-F17)","v":""}]
[{"$f":"IF('Controls Chart Data'!A18=\"\",\"\",'Controls Chart Data'!A18)","v":""},{"$f":"IF($A18=\"\",\"\",IF(OR($E$2=\"\",$E$2=\"Period Total\",$E$2=\"Total\"),\"\",IF($E$4=\"\",$E$3,$E$4)))","v":""},{"$f":"IF($A18=\"\",\"\",IF(OR($E$2=\"\",$E$2=\"Period Total\",$E$2=\"Total\"),\"\",IF($E$5=\"\",$E$3,$E$5)))","v":""},{"$f":"IF($A18=\"\",\"\",IF(OR($E$9=\"\",$E$9=\"Period Total\",$E$9=\"Total\"),\"\",$E$11))","v":""},{"$f":"IF($A18=\"\",\"\",IF(OR($E$9=\"\",$E$9=\"Period Total\",$E$9=\"Total\"),\"\",$E$14))","v":""},{"$f":"IF(A18=\"\",\"\",'Controls Chart Data'!L18)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A19=\"\",\"\",'Controls Chart Data'!A19)","v":""},{"$f":"IF($A19=\"\",\"\",IF(OR($F$2=\"\",$F$2=\"Period Total\",$F$2=\"Total\"),\"\",IF($F$4=\"\",$F$3,$F$4)))","v":""},{"$f":"IF($A19=\"\",\"\",IF(OR($F$2=\"\",$F$2=\"Period Total\",$F$2=\"Total\"),\"\",IF($F$5=\"\",$F$3,$F$5)))","v":""},{"$f":"IF($A19=\"\",\"\",IF(OR($F$9=\"\",$F$9=\"Period Total\",$F$9=\"Total\"),\"\",$F$11))","v":""},{"$f":"IF($A19=\"\",\"\",IF(OR($F$9=\"\",$F$9=\"Period Total\",$F$9=\"Total\"),\"\",$F$14))","v":""},{"$f":"IF(A19=\"\",\"\",'Controls Chart Data'!L19)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A20=\"\",\"\",'Controls Chart Data'!A20)","v":""},{"$f":"IF($A20=\"\",\"\",IF(OR($G$2=\"\",$G$2=\"Period Total\",$G$2=\"Total\"),\"\",IF($G$4=\"\",$G$3,$G$4)))","v":""},{"$f":"IF($A20=\"\",\"\",IF(OR($G$2=\"\",$G$2=\"Period Total\",$G$2=\"Total\"),\"\",IF($G$5=\"\",$G$3,$G$5)))","v":""},{"$f":"IF($A20=\"\",\"\",IF(OR($G$9=\"\",$G$9=\"Period Total\",$G$9=\"Total\"),\"\",$G$11))","v":""},{"$f":"IF($A20=\"\",\"\",IF(OR($G$9=\"\",$G$9=\"Period Total\",$G$9=\"Total\"),\"\",$G$14))","v":""},{"$f":"IF(A20=\"\",\"\",'Controls Chart Data'!L20)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A21=\"\",\"\",'Controls Chart Data'!A21)","v":""},{"$f":"IF($A21=\"\",\"\",IF(OR($H$2=\"\",$H$2=\"Period Total\",$H$2=\"Total\"),\"\",IF($H$4=\"\",$H$3,$H$4)))","v":""},{"$f":"IF($A21=\"\",\"\",IF(OR($H$2=\"\",$H$2=\"Period Total\",$H$2=\"Total\"),\"\",IF($H$5=\"\",$H$3,$H$5)))","v":""},{"$f":"IF($A21=\"\",\"\",IF(OR($H$9=\"\",$H$9=\"Period Total\",$H$9=\"Total\"),\"\",$H$11))","v":""},{"$f":"IF($A21=\"\",\"\",IF(OR($H$9=\"\",$H$9=\"Period Total\",$H$9=\"Total\"),\"\",$H$14))","v":""},{"$f":"IF(A21=\"\",\"\",'Controls Chart Data'!L21)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A22=\"\",\"\",'Controls Chart Data'!A22)","v":""},{"$f":"IF($A22=\"\",\"\",IF(OR($I$2=\"\",$I$2=\"Period Total\",$I$2=\"Total\"),\"\",IF($I$4=\"\",$I$3,$I$4)))","v":""},{"$f":"IF($A22=\"\",\"\",IF(OR($I$2=\"\",$I$2=\"Period Total\",$I$2=\"Total\"),\"\",IF($I$5=\"\",$I$3,$I$5)))","v":""},{"$f":"IF($A22=\"\",\"\",IF(OR($I$9=\"\",$I$9=\"Period Total\",$I$9=\"Total\"),\"\",$I$11))","v":""},{"$f":"IF($A22=\"\",\"\",IF(OR($I$9=\"\",$I$9=\"Period Total\",$I$9=\"Total\"),\"\",$I$14))","v":""},{"$f":"IF(A22=\"\",\"\",'Controls Chart Data'!L22)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A23=\"\",\"\",'Controls Chart Data'!A23)","v":""},{"$f":"IF($A23=\"\",\"\",IF(OR($J$2=\"\",$J$2=\"Period Total\",$J$2=\"Total\"),\"\",IF($J$4=\"\",$J$3,$J$4)))","v":""},{"$f":"IF($A23=\"\",\"\",IF(OR($J$2=\"\",$J$2=\"Period Total\",$J$2=\"Total\"),\"\",IF($J$5=\"\",$J$3,$J$5)))","v":""},{"$f":"IF($A23=\"\",\"\",IF(OR($J$9=\"\",$J$9=\"Period Total\",$J$9=\"Total\"),\"\",$J$11))","v":""},{"$f":"IF($A23=\"\",\"\",IF(OR($J$9=\"\",$J$9=\"Period Total\",$J$9=\"Total\"),\"\",$J$14))","v":""},{"$f":"IF(A23=\"\",\"\",'Controls Chart Data'!L23)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A24=\"\",\"\",'Controls Chart Data'!A24)","v":""},{"$f":"IF($A24=\"\",\"\",IF(OR($K$2=\"\",$K$2=\"Period Total\",$K$2=\"Total\"),\"\",IF($K$4=\"\",$K$3,$K$4)))","v":""},{"$f":"IF($A24=\"\",\"\",IF(OR($K$2=\"\",$K$2=\"Period Total\",$K$2=\"Total\"),\"\",IF($K$5=\"\",$K$3,$K$5)))","v":""},{"$f":"IF($A24=\"\",\"\",IF(OR($K$9=\"\",$K$9=\"Period Total\",$K$9=\"Total\"),\"\",$K$11))","v":""},{"$f":"IF($A24=\"\",\"\",IF(OR($K$9=\"\",$K$9=\"Period Total\",$K$9=\"Total\"),\"\",$K$14))","v":""},{"$f":"IF(A24=\"\",\"\",'Controls Chart Data'!L24)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A25=\"\",\"\",'Controls Chart Data'!A25)","v":""},{"$f":"IF($A25=\"\",\"\",IF(OR($L$2=\"\",$L$2=\"Period Total\",$L$2=\"Total\"),\"\",IF($L$4=\"\",$L$3,$L$4)))","v":""},{"$f":"IF($A25=\"\",\"\",IF(OR($L$2=\"\",$L$2=\"Period Total\",$L$2=\"Total\"),\"\",IF($L$5=\"\",$L$3,$L$5)))","v":""},{"$f":"IF($A25=\"\",\"\",IF(OR($L$9=\"\",$L$9=\"Period Total\",$L$9=\"Total\"),\"\",$L$11))","v":""},{"$f":"IF($A25=\"\",\"\",IF(OR($L$9=\"\",$L$9=\"Period Total\",$L$9=\"Total\"),\"\",$L$14))","v":""},{"$f":"IF(A25=\"\",\"\",'Controls Chart Data'!L25)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A26=\"\",\"\",'Controls Chart Data'!A26)","v":""},{"$f":"IF($A26=\"\",\"\",IF(OR($M$2=\"\",$M$2=\"Period Total\",$M$2=\"Total\"),\"\",IF($M$4=\"\",$M$3,$M$4)))","v":""},{"$f":"IF($A26=\"\",\"\",IF(OR($M$2=\"\",$M$2=\"Period Total\",$M$2=\"Total\"),\"\",IF($M$5=\"\",$M$3,$M$5)))","v":""},{"$f":"IF($A26=\"\",\"\",IF(OR($M$9=\"\",$M$9=\"Period Total\",$M$9=\"Total\"),\"\",$M$11))","v":""},{"$f":"IF($A26=\"\",\"\",IF(OR($M$9=\"\",$M$9=\"Period Total\",$M$9=\"Total\"),\"\",$M$14))","v":""},{"$f":"IF(A26=\"\",\"\",'Controls Chart Data'!L26)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A27=\"\",\"\",'Controls Chart Data'!A27)","v":""},{"$f":"IF($A27=\"\",\"\",IF(OR($N$2=\"\",$N$2=\"Period Total\",$N$2=\"Total\"),\"\",IF($N$4=\"\",$N$3,$N$4)))","v":""},{"$f":"IF($A27=\"\",\"\",IF(OR($N$2=\"\",$N$2=\"Period Total\",$N$2=\"Total\"),\"\",IF($N$5=\"\",$N$3,$N$5)))","v":""},{"$f":"IF($A27=\"\",\"\",IF(OR($N$9=\"\",$N$9=\"Period Total\",$N$9=\"Total\"),\"\",$N$11))","v":""},{"$f":"IF($A27=\"\",\"\",IF(OR($N$9=\"\",$N$9=\"Period Total\",$N$9=\"Total\"),\"\",$N$14))","v":""},{"$f":"IF(A27=\"\",\"\",'Controls Chart Data'!L27)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A28=\"\",\"\",'Controls Chart Data'!A28)","v":""},{"$f":"IF($A28=\"\",\"\",IF(OR($O$2=\"\",$O$2=\"Period Total\",$O$2=\"Total\"),\"\",IF($O$4=\"\",$O$3,$O$4)))","v":""},{"$f":"IF($A28=\"\",\"\",IF(OR($O$2=\"\",$O$2=\"Period Total\",$O$2=\"Total\"),\"\",IF($O$5=\"\",$O$3,$O$5)))","v":""},{"$f":"IF($A28=\"\",\"\",IF(OR($O$9=\"\",$O$9=\"Period Total\",$O$9=\"Total\"),\"\",$O$11))","v":""},{"$f":"IF($A28=\"\",\"\",IF(OR($O$9=\"\",$O$9=\"Period Total\",$O$9=\"Total\"),\"\",$O$14))","v":""},{"$f":"IF(A28=\"\",\"\",'Controls Chart Data'!L28)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A29=\"\",\"\",'Controls Chart Data'!A29)","v":""},{"$f":"IF($A29=\"\",\"\",IF(OR($P$2=\"\",$P$2=\"Period Total\",$P$2=\"Total\"),\"\",IF($P$4=\"\",$P$3,$P$4)))","v":""},{"$f":"IF($A29=\"\",\"\",IF(OR($P$2=\"\",$P$2=\"Period Total\",$P$2=\"Total\"),\"\",IF($P$5=\"\",$P$3,$P$5)))","v":""},{"$f":"IF($A29=\"\",\"\",IF(OR($P$9=\"\",$P$9=\"Period Total\",$P$9=\"Total\"),\"\",$P$11))","v":""},{"$f":"IF($A29=\"\",\"\",IF(OR($P$9=\"\",$P$9=\"Period Total\",$P$9=\"Total\"),\"\",$P$14))","v":""},{"$f":"IF(A29=\"\",\"\",'Controls Chart Data'!L29)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A30=\"\",\"\",'Controls Chart Data'!A30)","v":""},{"$f":"IF($A30=\"\",\"\",IF(OR($Q$2=\"\",$Q$2=\"Period Total\",$Q$2=\"Total\"),\"\",IF($Q$4=\"\",$Q$3,$Q$4)))","v":""},{"$f":"IF($A30=\"\",\"\",IF(OR($Q$2=\"\",$Q$2=\"Period Total\",$Q$2=\"Total\"),\"\",IF($Q$5=\"\",$Q$3,$Q$5)))","v":""},{"$f":"IF($A30=\"\",\"\",IF(OR($Q$9=\"\",$Q$9=\"Period Total\",$Q$9=\"Total\"),\"\",$Q$11))","v":""},{"$f":"IF($A30=\"\",\"\",IF(OR($Q$9=\"\",$Q$9=\"Period Total\",$Q$9=\"Total\"),\"\",$Q$14))","v":""},{"$f":"IF(A30=\"\",\"\",'Controls Chart Data'!L30)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A31=\"\",\"\",'Controls Chart Data'!A31)","v":""},{"$f":"IF($A31=\"\",\"\",IF(OR($R$2=\"\",$R$2=\"Period Total\",$R$2=\"Total\"),\"\",IF($R$4=\"\",$R$3,$R$4)))","v":""},{"$f":"IF($A31=\"\",\"\",IF(OR($R$2=\"\",$R$2=\"Period Total\",$R$2=\"Total\"),\"\",IF($R$5=\"\",$R$3,$R$5)))","v":""},{"$f":"IF($A31=\"\",\"\",IF(OR($R$9=\"\",$R$9=\"Period Total\",$R$9=\"Total\"),\"\",$R$11))","v":""},{"$f":"IF($A31=\"\",\"\",IF(OR($R$9=\"\",$R$9=\"Period Total\",$R$9=\"Total\"),\"\",$R$14))","v":""},{"$f":"IF(A31=\"\",\"\",'Controls Chart Data'!L31)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A32=\"\",\"\",'Controls Chart Data'!A32)","v":""},{"$f":"IF($A32=\"\",\"\",IF(OR($S$2=\"\",$S$2=\"Period Total\",$S$2=\"Total\"),\"\",IF($S$4=\"\",$S$3,$S$4)))","v":""},{"$f":"IF($A32=\"\",\"\",IF(OR($S$2=\"\",$S$2=\"Period Total\",$S$2=\"Total\"),\"\",IF($S$5=\"\",$S$3,$S$5)))","v":""},{"$f":"IF($A32=\"\",\"\",IF(OR($S$9=\"\",$S$9=\"Period Total\",$S$9=\"Total\"),\"\",$S$11))","v":""},{"$f":"IF($A32=\"\",\"\",IF(OR($S$9=\"\",$S$9=\"Period Total\",$S$9=\"Total\"),\"\",$S$14))","v":""},{"$f":"IF(A32=\"\",\"\",'Controls Chart Data'!L32)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A33=\"\",\"\",'Controls Chart Data'!A33)","v":""},{"$f":"IF($A33=\"\",\"\",IF(OR($T$2=\"\",$T$2=\"Period Total\",$T$2=\"Total\"),\"\",IF($T$4=\"\",$T$3,$T$4)))","v":""},{"$f":"IF($A33=\"\",\"\",IF(OR($T$2=\"\",$T$2=\"Period Total\",$T$2=\"Total\"),\"\",IF($T$5=\"\",$T$3,$T$5)))","v":""},{"$f":"IF($A33=\"\",\"\",IF(OR($T$9=\"\",$T$9=\"Period Total\",$T$9=\"Total\"),\"\",$T$11))","v":""},{"$f":"IF($A33=\"\",\"\",IF(OR($T$9=\"\",$T$9=\"Period Total\",$T$9=\"Total\"),\"\",$T$14))","v":""},{"$f":"IF(A33=\"\",\"\",'Controls Chart Data'!L33)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A34=\"\",\"\",'Controls Chart Data'!A34)","v":""},{"$f":"IF($A34=\"\",\"\",IF(OR($U$2=\"\",$U$2=\"Period Total\",$U$2=\"Total\"),\"\",IF($U$4=\"\",$U$3,$U$4)))","v":""},{"$f":"IF($A34=\"\",\"\",IF(OR($U$2=\"\",$U$2=\"Period Total\",$U$2=\"Total\"),\"\",IF($U$5=\"\",$U$3,$U$5)))","v":""},{"$f":"IF($A34=\"\",\"\",IF(OR($U$9=\"\",$U$9=\"Period Total\",$U$9=\"Total\"),\"\",$U$11))","v":""},{"$f":"IF($A34=\"\",\"\",IF(OR($U$9=\"\",$U$9=\"Period Total\",$U$9=\"Total\"),\"\",$U$14))","v":""},{"$f":"IF(A34=\"\",\"\",'Controls Chart Data'!L34)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A35=\"\",\"\",'Controls Chart Data'!A35)","v":""},{"$f":"IF($A35=\"\",\"\",IF(OR($V$2=\"\",$V$2=\"Period Total\",$V$2=\"Total\"),\"\",IF($V$4=\"\",$V$3,$V$4)))","v":""},{"$f":"IF($A35=\"\",\"\",IF(OR($V$2=\"\",$V$2=\"Period Total\",$V$2=\"Total\"),\"\",IF($V$5=\"\",$V$3,$V$5)))","v":""},{"$f":"IF($A35=\"\",\"\",IF(OR($V$9=\"\",$V$2=\"Period Total\",$V$9=\"Total\"),\"\",$V$11))","v":""},{"$f":"IF($A35=\"\",\"\",IF(OR($V$9=\"\",$V$2=\"Period Total\",$V$9=\"Total\"),\"\",$V$14))","v":""},{"$f":"IF(A35=\"\",\"\",'Controls Chart Data'!L35)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A36=\"\",\"\",'Controls Chart Data'!A36)","v":""},{"$f":"IF($A36=\"\",\"\",IF(OR($W$2=\"\",$W$2=\"Period Total\",$W$2=\"Total\"),\"\",IF($W$4=\"\",$W$3,$W$4)))","v":""},{"$f":"IF($A36=\"\",\"\",IF(OR($W$2=\"\",$W$2=\"Period Total\",$W$2=\"Total\"),\"\",IF($W$5=\"\",$W$3,$W$5)))","v":""},{"$f":"IF($A36=\"\",\"\",IF(OR($W$9=\"\",$W$9=\"Period Total\",$W$9=\"Total\"),\"\",$W$11))","v":""},{"$f":"IF($A36=\"\",\"\",IF(OR($W$9=\"\",$W$9=\"Period Total\",$W$9=\"Total\"),\"\",$W$14))","v":""},{"$f":"IF(A36=\"\",\"\",'Controls Chart Data'!L36)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A37=\"\",\"\",'Controls Chart Data'!A37)","v":""},{"$f":"IF($A37=\"\",\"\",IF(OR($X$2=\"\",$X$2=\"Period Total\",$X$2=\"Total\"),\"\",IF($X$4=\"\",$X$3,$X$4)))","v":""},{"$f":"IF($A37=\"\",\"\",IF(OR($X$2=\"\",$X$2=\"Period Total\",$X$2=\"Total\"),\"\",IF($X$5=\"\",$X$3,$X$5)))","v":""},{"$f":"IF($A37=\"\",\"\",IF(OR($X$9=\"\",$X$9=\"Period Total\",$X$9=\"Total\"),\"\",$X$11))","v":""},{"$f":"IF($A37=\"\",\"\",IF(OR($X$9=\"\",$X$9=\"Period Total\",$X$9=\"Total\"),\"\",$X$14))","v":""},{"$f":"IF(A37=\"\",\"\",'Controls Chart Data'!L37)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A38=\"\",\"\",'Controls Chart Data'!A38)","v":""},{"$f":"IF($A38=\"\",\"\",IF(OR($Y$2=\"\",$Y$2=\"Period Total\",$Y$2=\"Total\"),\"\",IF($Y$4=\"\",$Y$3,$Y$4)))","v":""},{"$f":"IF($A38=\"\",\"\",IF(OR($Y$2=\"\",$Y$2=\"Period Total\",$Y$2=\"Total\"),\"\",IF($Y$5=\"\",$Y$3,$Y$5)))","v":""},{"$f":"IF($A38=\"\",\"\",IF(OR($Y$9=\"\",$Y$9=\"Period Total\",$Y$9=\"Total\"),\"\",$Y$11))","v":""},{"$f":"IF($A38=\"\",\"\",IF(OR($Y$9=\"\",$Y$9=\"Period Total\",$Y$9=\"Total\"),\"\",$Y$14))","v":""},{"$f":"IF(A38=\"\",\"\",'Controls Chart Data'!L38)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A39=\"\",\"\",'Controls Chart Data'!A39)","v":""},{"$f":"IF($A39=\"\",\"\",IF(OR($Z$2=\"\",$Z$2=\"Period Total\",$Z$2=\"Total\"),\"\",IF($Z$4=\"\",$Z$3,$Z$4)))","v":""},{"$f":"IF($A39=\"\",\"\",IF(OR($Z$2=\"\",$Z$2=\"Period Total\",$Z$2=\"Total\"),\"\",IF($Z$5=\"\",$Z$3,$Z$5)))","v":""},{"$f":"IF($A39=\"\",\"\",IF(OR($Z$9=\"\",$Z$9=\"Period Total\",$Z$9=\"Total\"),\"\",$Z$11))","v":""},{"$f":"IF($A39=\"\",\"\",IF(OR($Z$9=\"\",$Z$9=\"Period Total\",$Z$9=\"Total\"),\"\",$Z$14))","v":""},{"$f":"IF(A39=\"\",\"\",'Controls Chart Data'!L39)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A40=\"\",\"\",'Controls Chart Data'!A40)","v":""},{"$f":"IF($A40=\"\",\"\",IF(OR($AA$2=\"\",$AA$2=\"Period Total\",$AA$2=\"Total\"),\"\",IF($AA$4=\"\",$AA$3,$AA$4)))","v":""},{"$f":"IF($A40=\"\",\"\",IF(OR($AA$2=\"\",$AA$2=\"Period Total\",$AA$2=\"Total\"),\"\",IF($AA$5=\"\",$AA$3,$AA$5)))","v":""},{"$f":"IF($A40=\"\",\"\",IF(OR($AA$9=\"\",$AA$9=\"Period Total\",$AA$9=\"Total\"),\"\",$AA$11))","v":""},{"$f":"IF($A40=\"\",\"\",IF(OR($AA$9=\"\",$AA$9=\"Period Total\",$AA$9=\"Total\"),\"\",$AA$14))","v":""},{"$f":"IF(A40=\"\",\"\",'Controls Chart Data'!L40)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A41=\"\",\"\",'Controls Chart Data'!A41)","v":""},{"$f":"IF($A41=\"\",\"\",IF(OR($AB$2=\"\",$AB$2=\"Period Total\",$AB$2=\"Total\"),\"\",IF($AB$4=\"\",$AB$3,$AB$4)))","v":""},{"$f":"IF($A41=\"\",\"\",IF(OR($AB$2=\"\",$AB$2=\"Period Total\",$AB$2=\"Total\"),\"\",IF($AB$5=\"\",$AB$3,$AB$5)))","v":""},{"$f":"IF($A41=\"\",\"\",IF(OR($AB$9=\"\",$AB$9=\"Period Total\",$AB$9=\"Total\"),\"\",$AB$11))","v":""},{"$f":"IF($A41=\"\",\"\",IF(OR($AB$9=\"\",$AB$9=\"Period Total\",$AB$9=\"Total\"),\"\",$AB$14))","v":""},{"$f":"IF(A41=\"\",\"\",'Controls Chart Data'!L41)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A42=\"\",\"\",'Controls Chart Data'!A42)","v":""},{"$f":"IF($A42=\"\",\"\",IF(OR($AC$2=\"\",$AC$2=\"Period Total\",$AC$2=\"Total\"),\"\",IF($AC$4=\"\",$AC$3,$AC$4)))","v":""},{"$f":"IF($A42=\"\",\"\",IF(OR($AC$2=\"\",$AC$2=\"Period Total\",$AC$2=\"Total\"),\"\",IF($AC$5=\"\",$AC$3,$AC$5)))","v":""},{"$f":"IF($A42=\"\",\"\",IF(OR($AC$9=\"\",$AC$9=\"Period Total\",$AC$9=\"Total\"),\"\",$AC$11))","v":""},{"$f":"IF($A42=\"\",\"\",IF(OR($AC$9=\"\",$AC$9=\"Period Total\",$AC$9=\"Total\"),\"\",$AC$14))","v":""},{"$f":"IF(A42=\"\",\"\",'Controls Chart Data'!L42)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A43=\"\",\"\",'Controls Chart Data'!A43)","v":""},{"$f":"IF($A43=\"\",\"\",IF(OR($AD$2=\"\",$AD$2=\"Period Total\",$AD$2=\"Total\"),\"\",IF($AD$4=\"\",$AD$3,$AD$4)))","v":""},{"$f":"IF($A43=\"\",\"\",IF(OR($AD$2=\"\",$AD$2=\"Period Total\",$AD$2=\"Total\"),\"\",IF($AD$5=\"\",$AD$3,$AD$5)))","v":""},{"$f":"IF($A43=\"\",\"\",IF(OR($AD$9=\"\",$AD$9=\"Period Total\",$AD$9=\"Total\"),\"\",$AD$11))","v":""},{"$f":"IF($A43=\"\",\"\",IF(OR($AD$9=\"\",$AD$9=\"Period Total\",$AD$9=\"Total\"),\"\",$AD$14))","v":""},{"$f":"IF(A43=\"\",\"\",'Controls Chart Data'!L43)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A44=\"\",\"\",'Controls Chart Data'!A44)","v":""},{"$f":"IF($A44=\"\",\"\",IF(OR($AE$2=\"\",$AE$2=\"Period Total\",$AE$2=\"Total\"),\"\",IF($AE$4=\"\",$AE$3,$AE$4)))","v":""},{"$f":"IF($A44=\"\",\"\",IF(OR($AE$2=\"\",$AE$2=\"Period Total\",$AE$2=\"Total\"),\"\",IF($AE$5=\"\",$AE$3,$AE$5)))","v":""},{"$f":"IF($A44=\"\",\"\",IF(OR($AE$9=\"\",$AE$9=\"Period Total\",$AE$9=\"Total\"),\"\",$AE$11))","v":""},{"$f":"IF($A44=\"\",\"\",IF(OR($AE$9=\"\",$AE$9=\"Period Total\",$AE$9=\"Total\"),\"\",$AE$14))","v":""},{"$f":"IF(A44=\"\",\"\",'Controls Chart Data'!L44)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A45=\"\",\"\",'Controls Chart Data'!A45)","v":""},{"$f":"IF($A45=\"\",\"\",IF(OR($AF$2=\"\",$AF$2=\"Period Total\",$AF$2=\"Total\"),\"\",IF($AF$4=\"\",$AF$3,$AF$4)))","v":""},{"$f":"IF($A45=\"\",\"\",IF(OR($AF$2=\"\",$AF$2=\"Period Total\",$AF$2=\"Total\"),\"\",IF($AF$5=\"\",$AF$3,$AF$5)))","v":""},{"$f":"IF($A45=\"\",\"\",IF(OR($AF$9=\"\",$AF$9=\"Period Total\",$AF$9=\"Total\"),\"\",$AF$11))","v":""},{"$f":"IF($A45=\"\",\"\",IF(OR($AF$9=\"\",$AF$9=\"Period Total\",$AF$9=\"Total\"),\"\",$AF$14))","v":""},{"$f":"IF(A45=\"\",\"\",'Controls Chart Data'!L45)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A46=\"\",\"\",'Controls Chart Data'!A46)","v":""},{"$f":"IF($A46=\"\",\"\",IF(OR($AG$2=\"\",$AG$2=\"Period Total\",$AG$2=\"Total\"),\"\",IF($AG$4=\"\",$AG$3,$AG$4)))","v":""},{"$f":"IF($A46=\"\",\"\",IF(OR($AG$2=\"\",$AG$2=\"Period Total\",$AG$2=\"Total\"),\"\",IF($AG$5=\"\",$AG$3,$AG$5)))","v":""},{"$f":"IF($A46=\"\",\"\",IF(OR($AG$9=\"\",$AG$9=\"Period Total\",$AG$9=\"Total\"),\"\",$AG$11))","v":""},{"$f":"IF($A46=\"\",\"\",IF(OR($AG$9=\"\",$AG$9=\"Period Total\",$AG$9=\"Total\"),\"\",$AG$14))","v":""},{"$f":"IF(A46=\"\",\"\",'Controls Chart Data'!L46)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A47=\"\",\"\",'Controls Chart Data'!A47)","v":""},{"$f":"IF($A47=\"\",\"\",IF(OR($AH$2=\"\",$AH$2=\"Period Total\",$AH$2=\"Total\"),\"\",IF($AH$4=\"\",$AH$3,$AH$4)))","v":""},{"$f":"IF($A47=\"\",\"\",IF(OR($AH$2=\"\",$AH$2=\"Period Total\",$AH$2=\"Total\"),\"\",IF($AH$5=\"\",$AH$3,$AH$5)))","v":""},{"$f":"IF($A47=\"\",\"\",IF(OR($AH$9=\"\",$AH$9=\"Period Total\",$AH$9=\"Total\"),\"\",$AH$11))","v":""},{"$f":"IF($A47=\"\",\"\",IF(OR($AH$9=\"\",$AH$9=\"Period Total\",$AH$9=\"Total\"),\"\",$AH$14))","v":""},{"$f":"IF(A47=\"\",\"\",'Controls Chart Data'!L47)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A48=\"\",\"\",'Controls Chart Data'!A48)","v":""},{"$f":"IF($A48=\"\",\"\",IF(OR($AI$2=\"\",$AI$2=\"Period Total\",$AI$2=\"Total\"),\"\",IF($AI$4=\"\",$AI$3,$AI$4)))","v":""},{"$f":"IF($A48=\"\",\"\",IF(OR($AI$2=\"\",$AI$2=\"Period Total\",$AI$2=\"Total\"),\"\",IF($AI$5=\"\",$AI$3,$AI$5)))","v":""},{"$f":"IF($A48=\"\",\"\",IF(OR($AI$9=\"\",$AI$9=\"Period Total\",$AI$9=\"Total\"),\"\",$AI$11))","v":""},{"$f":"IF($A48=\"\",\"\",IF(OR($AI$9=\"\",$AI$9=\"Period Total\",$AI$9=\"Total\"),\"\",$AI$14))","v":""},{"$f":"IF(A48=\"\",\"\",'Controls Chart Data'!L48)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A49=\"\",\"\",'Controls Chart Data'!A49)","v":""},{"$f":"IF($A49=\"\",\"\",IF(OR($AJ$2=\"\",$AJ$2=\"Period Total\",$AJ$2=\"Total\"),\"\",IF($AJ$4=\"\",$AJ$3,$AJ$4)))","v":""},{"$f":"IF($A49=\"\",\"\",IF(OR($AJ$2=\"\",$AJ$2=\"Period Total\",$AJ$2=\"Total\"),\"\",IF($AJ$5=\"\",$AJ$3,$AJ$5)))","v":""},{"$f":"IF($A49=\"\",\"\",IF(OR($AJ$9=\"\",$AJ$9=\"Period Total\",$AJ$9=\"Total\"),\"\",$AJ$11))","v":""},{"$f":"IF($A49=\"\",\"\",IF(OR($AJ$9=\"\",$AJ$9=\"Period Total\",$AJ$9=\"Total\"),\"\",$AJ$14))","v":""},{"$f":"IF(A49=\"\",\"\",'Controls Chart Data'!L49)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A50=\"\",\"\",'Controls Chart Data'!A50)","v":""},{"$f":"IF($A50=\"\",\"\",IF(OR($AK$2=\"\",$AK$2=\"Period Total\",$AK$2=\"Total\"),\"\",IF($AK$4=\"\",$AK$3,$AK$4)))","v":""},{"$f":"IF($A50=\"\",\"\",IF(OR($AK$2=\"\",$AK$2=\"Period Total\",$AK$2=\"Total\"),\"\",IF($AK$5=\"\",$AK$3,$AK$5)))","v":""},{"$f":"IF($A50=\"\",\"\",IF(OR($AK$9=\"\",$AK$9=\"Period Total\",$AK$9=\"Total\"),\"\",$AK$11))","v":""},{"$f":"IF($A50=\"\",\"\",IF(OR($AK$9=\"\",$AK$9=\"Period Total\",$AK$9=\"Total\"),\"\",$AK$14))","v":""},{"$f":"IF(A50=\"\",\"\",'Controls Chart Data'!L50)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A51=\"\",\"\",'Controls Chart Data'!A51)","v":""},{"$f":"IF($A51=\"\",\"\",IF(OR($AL$2=\"\",$AL$2=\"Period Total\",$AL$2=\"Total\"),\"\",IF($AL$4=\"\",$AL$3,$AL$4)))","v":""},{"$f":"IF($A51=\"\",\"\",IF(OR($AL$2=\"\",$AL$2=\"Period Total\",$AL$2=\"Total\"),\"\",IF($AL$5=\"\",$AL$3,$AL$5)))","v":""},{"$f":"IF($A51=\"\",\"\",IF(OR($AL$9=\"\",$AL$9=\"Period Total\",$AL$9=\"Total\"),\"\",$AL$11))","v":""},{"$f":"IF($A51=\"\",\"\",IF(OR($AL$9=\"\",$AL$9=\"Period Total\",$AL$9=\"Total\"),\"\",$AL$14))","v":""},{"$f":"IF(A51=\"\",\"\",'Controls Chart Data'!L51)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A52=\"\",\"\",'Controls Chart Data'!A52)","v":""},{"$f":"IF($A52=\"\",\"\",IF(OR($AM$2=\"\",$AM$2=\"Period Total\",$AM$2=\"Total\"),\"\",IF($AM$4=\"\",$AM$3,$AM$4)))","v":""},{"$f":"IF($A52=\"\",\"\",IF(OR($AM$2=\"\",$AM$2=\"Period Total\",$AM$2=\"Total\"),\"\",IF($AM$5=\"\",$AM$3,$AM$5)))","v":""},{"$f":"IF($A52=\"\",\"\",IF(OR($AM$9=\"\",$AM$9=\"Period Total\",$AM$9=\"Total\"),\"\",$AM$11))","v":""},{"$f":"IF($A52=\"\",\"\",IF(OR($AM$9=\"\",$AM$9=\"Period Total\",$AM$9=\"Total\"),\"\",$AM$14))","v":""},{"$f":"IF(A52=\"\",\"\",'Controls Chart Data'!L52)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A53=\"\",\"\",'Controls Chart Data'!A53)","v":""},{"$f":"IF($A53=\"\",\"\",IF(OR($AN$2=\"\",$AN$2=\"Period Total\",$AN$2=\"Total\"),\"\",IF($AN$4=\"\",$AN$3,$AN$4)))","v":""},{"$f":"IF($A53=\"\",\"\",IF(OR($AN$2=\"\",$AN$2=\"Period Total\",$AN$2=\"Total\"),\"\",IF($AN$5=\"\",$AN$3,$AN$5)))","v":""},{"$f":"IF($A53=\"\",\"\",IF(OR($AN$9=\"\",$AN$9=\"Period Total\",$AN$9=\"Total\"),\"\",$AN$11))","v":""},{"$f":"IF($A53=\"\",\"\",IF(OR($AN$9=\"\",$AN$9=\"Period Total\",$AN$9=\"Total\"),\"\",$AN$14))","v":""},{"$f":"IF(A53=\"\",\"\",'Controls Chart Data'!L53)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A54=\"\",\"\",'Controls Chart Data'!A54)","v":""},{"$f":"IF($A54=\"\",\"\",IF(OR($AO$2=\"\",$AO$2=\"Period Total\",$AO$2=\"Total\"),\"\",IF($AO$4=\"\",$AO$3,$AO$4)))","v":""},{"$f":"IF($A54=\"\",\"\",IF(OR($AO$2=\"\",$AO$2=\"Period Total\",$AO$2=\"Total\"),\"\",IF($AO$5=\"\",$AO$3,$AO$5)))","v":""},{"$f":"IF($A54=\"\",\"\",IF(OR($AO$9=\"\",$AO$9=\"Period Total\",$AO$9=\"Total\"),\"\",$AO$11))","v":""},{"$f":"IF($A54=\"\",\"\",IF(OR($AO$9=\"\",$AO$9=\"Period Total\",$AO$9=\"Total\"),\"\",$AO$14))","v":""},{"$f":"IF(A54=\"\",\"\",'Controls Chart Data'!L54)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A55=\"\",\"\",'Controls Chart Data'!A55)","v":""},{"$f":"IF($A55=\"\",\"\",IF(OR($AP$2=\"\",$AP$2=\"Period Total\",$AP$2=\"Total\"),\"\",IF($AP$4=\"\",$AP$3,$AP$4)))","v":""},{"$f":"IF($A55=\"\",\"\",IF(OR($AP$2=\"\",$AP$2=\"Period Total\",$AP$2=\"Total\"),\"\",IF($AP$5=\"\",$AP$3,$AP$5)))","v":""},{"$f":"IF($A55=\"\",\"\",IF(OR($AP$9=\"\",$AP$9=\"Period Total\",$AP$9=\"Total\"),\"\",$AP$11))","v":""},{"$f":"IF($A55=\"\",\"\",IF(OR($AP$9=\"\",$AP$9=\"Period Total\",$AP$9=\"Total\"),\"\",$AP$14))","v":""},{"$f":"IF(A55=\"\",\"\",'Controls Chart Data'!L55)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A56=\"\",\"\",'Controls Chart Data'!A56)","v":""},{"$f":"IF($A56=\"\",\"\",IF(OR($AQ$2=\"\",$AQ$2=\"Period Total\",$AQ$2=\"Total\"),\"\",IF($AQ$4=\"\",$AQ$3,$AQ$4)))","v":""},{"$f":"IF($A56=\"\",\"\",IF(OR($AQ$2=\"\",$AQ$2=\"Period Total\",$AQ$2=\"Total\"),\"\",IF($AQ$5=\"\",$AQ$3,$AQ$5)))","v":""},{"$f":"IF($A56=\"\",\"\",IF(OR($AQ$9=\"\",$AQ$9=\"Period Total\",$AQ$9=\"Total\"),\"\",$AQ$11))","v":""},{"$f":"IF($A56=\"\",\"\",IF(OR($AQ$9=\"\",$AQ$9=\"Period Total\",$AQ$9=\"Total\"),\"\",$AQ$14))","v":""},{"$f":"IF(A56=\"\",\"\",'Controls Chart Data'!L56)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A57=\"\",\"\",'Controls Chart Data'!A57)","v":""},{"$f":"IF($A57=\"\",\"\",IF(OR($AR$2=\"\",$AR$2=\"Period Total\",$AR$2=\"Total\"),\"\",IF($AR$4=\"\",$AR$3,$AR$4)))","v":""},{"$f":"IF($A57=\"\",\"\",IF(OR($AR$2=\"\",$AR$2=\"Period Total\",$AR$2=\"Total\"),\"\",IF($AR$5=\"\",$AR$3,$AR$5)))","v":""},{"$f":"IF($A57=\"\",\"\",IF(OR($AR$9=\"\",$AR$9=\"Period Total\",$AR$9=\"Total\"),\"\",$AR$11))","v":""},{"$f":"IF($A57=\"\",\"\",IF(OR($AR$9=\"\",$AR$9=\"Period Total\",$AR$9=\"Total\"),\"\",$AR$14))","v":""},{"$f":"IF(A57=\"\",\"\",'Controls Chart Data'!L57)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A58=\"\",\"\",'Controls Chart Data'!A58)","v":""},{"$f":"IF($A58=\"\",\"\",IF(OR($AS$2=\"\",$AS$2=\"Period Total\",$AS$2=\"Total\"),\"\",IF($AS$4=\"\",$AS$3,$AS$4)))","v":""},{"$f":"IF($A58=\"\",\"\",IF(OR($AS$2=\"\",$AS$2=\"Period Total\",$AS$2=\"Total\"),\"\",IF($AS$5=\"\",$AS$3,$AS$5)))","v":""},{"$f":"IF($A58=\"\",\"\",IF(OR($AS$9=\"\",$AS$9=\"Period Total\",$AS$9=\"Total\"),\"\",$AS$11))","v":""},{"$f":"IF($A58=\"\",\"\",IF(OR($AS$9=\"\",$AS$9=\"Period Total\",$AS$9=\"Total\"),\"\",$AS$14))","v":""},{"$f":"IF(A58=\"\",\"\",'Controls Chart Data'!L58)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A59=\"\",\"\",'Controls Chart Data'!A59)","v":""},{"$f":"IF($A59=\"\",\"\",IF(OR($AT$2=\"\",$AT$2=\"Period Total\",$AT$2=\"Total\"),\"\",IF($AT$4=\"\",$AT$3,$AT$4)))","v":""},{"$f":"IF($A59=\"\",\"\",IF(OR($AT$2=\"\",$AT$2=\"Period Total\",$AT$2=\"Total\"),\"\",IF($AT$5=\"\",$AT$3,$AT$5)))","v":""},{"$f":"IF($A59=\"\",\"\",IF(OR($AT$9=\"\",$AT$9=\"Period Total\",$AT$9=\"Total\"),\"\",$AT$11))","v":""},{"$f":"IF($A59=\"\",\"\",IF(OR($AT$9=\"\",$AT$9=\"Period Total\",$AT$9=\"Total\"),\"\",$AT$14))","v":""},{"$f":"IF(A59=\"\",\"\",'Controls Chart Data'!L59)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A60=\"\",\"\",'Controls Chart Data'!A60)","v":""},{"$f":"IF($A60=\"\",\"\",IF(OR($AU$2=\"\",$AU$2=\"Period Total\",$AU$2=\"Total\"),\"\",IF($AU$4=\"\",$AU$3,$AU$4)))","v":""},{"$f":"IF($A60=\"\",\"\",IF(OR($AU$2=\"\",$AU$2=\"Period Total\",$AU$2=\"Total\"),\"\",IF($AU$5=\"\",$AU$3,$AU$5)))","v":""},{"$f":"IF($A60=\"\",\"\",IF(OR($AU$9=\"\",$AU$9=\"Period Total\",$AU$9=\"Total\"),\"\",$AU$11))","v":""},{"$f":"IF($A60=\"\",\"\",IF(OR($AU$9=\"\",$AU$9=\"Period Total\",$AU$9=\"Total\"),\"\",$AU$14))","v":""},{"$f":"IF(A60=\"\",\"\",'Controls Chart Data'!L60)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A61=\"\",\"\",'Controls Chart Data'!A61)","v":""},{"$f":"IF($A61=\"\",\"\",IF(OR($AV$2=\"\",$AV$2=\"Period Total\",$AV$2=\"Total\"),\"\",IF($AV$4=\"\",$AV$3,$AV$4)))","v":""},{"$f":"IF($A61=\"\",\"\",IF(OR($AV$2=\"\",$AV$2=\"Period Total\",$AV$2=\"Total\"),\"\",IF($AV$5=\"\",$AV$3,$AV$5)))","v":""},{"$f":"IF($A61=\"\",\"\",IF(OR($AV$9=\"\",$AV$9=\"Period Total\",$AV$9=\"Total\"),\"\",$AV$11))","v":""},{"$f":"IF($A61=\"\",\"\",IF(OR($AV$9=\"\",$AV$9=\"Period Total\",$AV$9=\"Total\"),\"\",$AV$14))","v":""},{"$f":"IF(A61=\"\",\"\",'Controls Chart Data'!L61)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A62=\"\",\"\",'Controls Chart Data'!A62)","v":""},{"$f":"IF($A62=\"\",\"\",IF(OR($AW$2=\"\",$AW$2=\"Period Total\",$AW$2=\"Total\"),\"\",IF($AW$4=\"\",$AW$3,$AW$4)))","v":""},{"$f":"IF($A62=\"\",\"\",IF(OR($AW$2=\"\",$AW$2=\"Period Total\",$AW$2=\"Total\"),\"\",IF($AW$5=\"\",$AW$3,$AW$5)))","v":""},{"$f":"IF($A62=\"\",\"\",IF(OR($AW$9=\"\",$AW$9=\"Period Total\",$AW$9=\"Total\"),\"\",$AW$11))","v":""},{"$f":"IF($A62=\"\",\"\",IF(OR($AW$9=\"\",$AW$9=\"Period Total\",$AW$9=\"Total\"),\"\",$AW$14))","v":""},{"$f":"IF(A62=\"\",\"\",'Controls Chart Data'!L62)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A63=\"\",\"\",'Controls Chart Data'!A63)","v":""},{"$f":"IF($A63=\"\",\"\",IF(OR($AX$2=\"\",$AX$2=\"Period Total\",$AX$2=\"Total\"),\"\",IF($AX$4=\"\",$AX$3,$AX$4)))","v":""},{"$f":"IF($A63=\"\",\"\",IF(OR($AX$2=\"\",$AX$2=\"Period Total\",$AX$2=\"Total\"),\"\",IF($AX$5=\"\",$AX$3,$AX$5)))","v":""},{"$f":"IF($A63=\"\",\"\",IF(OR($AX$9=\"\",$AX$9=\"Period Total\",$AX$9=\"Total\"),\"\",$AX$11))","v":""},{"$f":"IF($A63=\"\",\"\",IF(OR($AX$9=\"\",$AX$9=\"Period Total\",$AX$9=\"Total\"),\"\",$AX$14))","v":""},{"$f":"IF(A63=\"\",\"\",'Controls Chart Data'!L63)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A64=\"\",\"\",'Controls Chart Data'!A64)","v":""},{"$f":"IF($A64=\"\",\"\",IF(OR($AY$2=\"\",$AY$2=\"Period Total\",$AY$2=\"Total\"),\"\",IF($AY$4=\"\",$AY$3,$AY$4)))","v":""},{"$f":"IF($A64=\"\",\"\",IF(OR($AY$2=\"\",$AY$2=\"Period Total\",$AY$2=\"Total\"),\"\",IF($AY$5=\"\",$AY$3,$AY$5)))","v":""},{"$f":"IF($A64=\"\",\"\",IF(OR($AY$9=\"\",$AY$9=\"Period Total\",$AY$9=\"Total\"),\"\",$AY$11))","v":""},{"$f":"IF($A64=\"\",\"\",IF(OR($AY$9=\"\",$AY$9=\"Period Total\",$AY$9=\"Total\"),\"\",$AY$14))","v":""},{"$f":"IF(A64=\"\",\"\",'Controls Chart Data'!L64)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A65=\"\",\"\",'Controls Chart Data'!A65)","v":""},{"$f":"IF($A65=\"\",\"\",IF(OR($AZ$2=\"\",$AZ$2=\"Period Total\",$AZ$2=\"Total\"),\"\",IF($AZ$4=\"\",$AZ$3,$AZ$4)))","v":""},{"$f":"IF($A65=\"\",\"\",IF(OR($AZ$2=\"\",$AZ$2=\"Period Total\",$AZ$2=\"Total\"),\"\",IF($AZ$5=\"\",$AZ$3,$AZ$5)))","v":""},{"$f":"IF($A65=\"\",\"\",IF(OR($AZ$9=\"\",$AZ$9=\"Period Total\",$AZ$9=\"Total\"),\"\",$AZ$11))","v":""},{"$f":"IF($A65=\"\",\"\",IF(OR($AZ$9=\"\",$AZ$9=\"Period Total\",$AZ$9=\"Total\"),\"\",$AZ$14))","v":""},{"$f":"IF(A65=\"\",\"\",'Controls Chart Data'!L65)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A66=\"\",\"\",'Controls Chart Data'!A66)","v":""},{"$f":"IF($A66=\"\",\"\",IF(OR($BA$2=\"\",$BA$2=\"Period Total\",$BA$2=\"Total\"),\"\",IF($BA$4=\"\",$BA$3,$BA$4)))","v":""},{"$f":"IF($A66=\"\",\"\",IF(OR($BA$2=\"\",$BA$2=\"Period Total\",$BA$2=\"Total\"),\"\",IF($BA$5=\"\",$BA$3,$BA$5)))","v":""},{"$f":"IF($A66=\"\",\"\",IF(OR($BA$9=\"\",$BA$9=\"Period Total\",$BA$9=\"Total\"),\"\",$BA$11))","v":""},{"$f":"IF($A66=\"\",\"\",IF(OR($BA$9=\"\",$BA$9=\"Period Total\",$BA$9=\"Total\"),\"\",$BA$14))","v":""},{"$f":"IF(A66=\"\",\"\",'Controls Chart Data'!L66)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A67=\"\",\"\",'Controls Chart Data'!A67)","v":""},{"$f":"IF($A67=\"\",\"\",IF(OR($BB$2=\"\",$BB$2=\"Period Total\",$BB$2=\"Total\"),\"\",IF($BB$4=\"\",$BB$3,$BB$4)))","v":""},{"$f":"IF($A67=\"\",\"\",IF(OR($BB$2=\"\",$BB$2=\"Period Total\",$BB$2=\"Total\"),\"\",IF($BB$5=\"\",$BB$3,$BB$5)))","v":""},{"$f":"IF($A67=\"\",\"\",IF(OR($BB$9=\"\",$BB$9=\"Period Total\",$BB$9=\"Total\"),\"\",$BB$11))","v":""},{"$f":"IF($A67=\"\",\"\",IF(OR($BB$9=\"\",$BB$9=\"Period Total\",$BB$9=\"Total\"),\"\",$BB$14))","v":""},{"$f":"IF(A67=\"\",\"\",'Controls Chart Data'!L67)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A68=\"\",\"\",'Controls Chart Data'!A68)","v":""},{"$f":"IF($A68=\"\",\"\",IF(OR($BC$2=\"\",$BC$2=\"Period Total\",$BC$2=\"Total\"),\"\",IF($BC$4=\"\",$BC$3,$BC$4)))","v":""},{"$f":"IF($A68=\"\",\"\",IF(OR($BC$2=\"\",$BC$2=\"Period Total\",$BC$2=\"Total\"),\"\",IF($BC$5=\"\",$BC$3,$BC$5)))","v":""},{"$f":"IF($A68=\"\",\"\",IF(OR($BC$9=\"\",$BC$9=\"Period Total\",$BC$9=\"Total\"),\"\",$BC$11))","v":""},{"$f":"IF($A68=\"\",\"\",IF(OR($BC$9=\"\",$BC$9=\"Period Total\",$BC$9=\"Total\"),\"\",$BC$14))","v":""},{"$f":"IF(A68=\"\",\"\",'Controls Chart Data'!L68)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A69=\"\",\"\",'Controls Chart Data'!A69)","v":""},{"$f":"IF($A69=\"\",\"\",IF(OR($BD$2=\"\",$BD$2=\"Period Total\",$BD$2=\"Total\"),\"\",IF($BD$4=\"\",$BD$3,$BD$4)))","v":""},{"$f":"IF($A69=\"\",\"\",IF(OR($BD$2=\"\",$BD$2=\"Period Total\",$BD$2=\"Total\"),\"\",IF($BD$5=\"\",$BD$3,$BD$5)))","v":""},{"$f":"IF($A69=\"\",\"\",IF(OR($BD$9=\"\",$BD$9=\"Period Total\",$BD$9=\"Total\"),\"\",$BD$11))","v":""},{"$f":"IF($A69=\"\",\"\",IF(OR($BD$9=\"\",$BD$9=\"Period Total\",$BD$9=\"Total\"),\"\",$BD$14))","v":""},{"$f":"IF(A69=\"\",\"\",'Controls Chart Data'!L69)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A70=\"\",\"\",'Controls Chart Data'!A70)","v":""},{"$f":"IF($A70=\"\",\"\",IF(OR($BE$2=\"\",$BE$2=\"Period Total\",$BE$2=\"Total\"),\"\",IF($BE$4=\"\",$BE$3,$BE$4)))","v":""},{"$f":"IF($A70=\"\",\"\",IF(OR($BE$2=\"\",$BE$2=\"Period Total\",$BE$2=\"Total\"),\"\",IF($BE$5=\"\",$BE$3,$BE$5)))","v":""},{"$f":"IF($A70=\"\",\"\",IF(OR($BE$9=\"\",$BE$9=\"Period Total\",$BE$9=\"Total\"),\"\",$BE$11))","v":""},{"$f":"IF($A70=\"\",\"\",IF(OR($BE$9=\"\",$BE$9=\"Period Total\",$BE$9=\"Total\"),\"\",$BE$14))","v":""},{"$f":"IF(A70=\"\",\"\",'Controls Chart Data'!L70)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A71=\"\",\"\",'Controls Chart Data'!A71)","v":""},{"$f":"IF($A71=\"\",\"\",IF(OR($BF$2=\"\",$BF$2=\"Period Total\",$BF$2=\"Total\"),\"\",IF($BF$4=\"\",$BF$3,$BF$4)))","v":""},{"$f":"IF($A71=\"\",\"\",IF(OR($BF$2=\"\",$BF$2=\"Period Total\",$BF$2=\"Total\"),\"\",IF($BF$5=\"\",$BF$3,$BF$5)))","v":""},{"$f":"IF($A71=\"\",\"\",IF(OR($BF$9=\"\",$BF$9=\"Period Total\",$BF$9=\"Total\"),\"\",$BF$11))","v":""},{"$f":"IF($A71=\"\",\"\",IF(OR($BF$9=\"\",$BF$9=\"Period Total\",$BF$9=\"Total\"),\"\",$BF$14))","v":""},{"$f":"IF(A71=\"\",\"\",'Controls Chart Data'!L71)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A72=\"\",\"\",'Controls Chart Data'!A72)","v":""},{"$f":"IF($A72=\"\",\"\",IF(OR($BG$2=\"\",$BG$2=\"Period Total\",$BG$2=\"Total\"),\"\",IF($BG$4=\"\",$BG$3,$BG$4)))","v":""},{"$f":"IF($A72=\"\",\"\",IF(OR($BG$2=\"\",$BG$2=\"Period Total\",$BG$2=\"Total\"),\"\",IF($BG$5=\"\",$BG$3,$BG$5)))","v":""},{"$f":"IF($A72=\"\",\"\",IF(OR($BG$9=\"\",$BG$9=\"Period Total\",$BG$9=\"Total\"),\"\",$BG$11))","v":""},{"$f":"IF($A72=\"\",\"\",IF(OR($BG$9=\"\",$BG$9=\"Period Total\",$BG$9=\"Total\"),\"\",$BG$14))","v":""},{"$f":"IF(A72=\"\",\"\",'Controls Chart Data'!L72)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A73=\"\",\"\",'Controls Chart Data'!A73)","v":""},{"$f":"IF($A73=\"\",\"\",IF(OR($BH$2=\"\",$BH$2=\"Period Total\",$BH$2=\"Total\"),\"\",IF($BH$4=\"\",$BH$3,$BH$4)))","v":""},{"$f":"IF($A73=\"\",\"\",IF(OR($BH$2=\"\",$BH$2=\"Period Total\",$BH$2=\"Total\"),\"\",IF($BH$5=\"\",$BH$3,$BH$5)))","v":""},{"$f":"IF($A73=\"\",\"\",IF(OR($BH$9=\"\",$BH$9=\"Period Total\",$BH$9=\"Total\"),\"\",$BH$11))","v":""},{"$f":"IF($A73=\"\",\"\",IF(OR($BH$9=\"\",$BH$9=\"Period Total\",$BH$9=\"Total\"),\"\",$BH$14))","v":""},{"$f":"IF(A73=\"\",\"\",'Controls Chart Data'!L73)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A74=\"\",\"\",'Controls Chart Data'!A74)","v":""},{"$f":"IF($A74=\"\",\"\",IF(OR($BI$2=\"\",$BI$2=\"Period Total\",$BI$2=\"Total\"),\"\",IF($BI$4=\"\",$BI$3,$BI$4)))","v":""},{"$f":"IF($A74=\"\",\"\",IF(OR($BI$2=\"\",$BI$2=\"Period Total\",$BI$2=\"Total\"),\"\",IF($BI$5=\"\",$BI$3,$BI$5)))","v":""},{"$f":"IF($A74=\"\",\"\",IF(OR($BI$9=\"\",$BI$9=\"Period Total\",$BI$9=\"Total\"),\"\",$BI$11))","v":""},{"$f":"IF($A74=\"\",\"\",IF(OR($BI$9=\"\",$BI$9=\"Period Total\",$BI$9=\"Total\"),\"\",$BI$14))","v":""},{"$f":"IF(A74=\"\",\"\",'Controls Chart Data'!L74)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A75=\"\",\"\",'Controls Chart Data'!A75)","v":""},{"$f":"IF($A75=\"\",\"\",IF(OR($BJ$2=\"\",$BJ$2=\"Period Total\",$BJ$2=\"Total\"),\"\",IF($BJ$4=\"\",$BJ$3,$BJ$4)))","v":""},{"$f":"IF($A75=\"\",\"\",IF(OR($BJ$2=\"\",$BJ$2=\"Period Total\",$BJ$2=\"Total\"),\"\",IF($BJ$5=\"\",$BJ$3,$BJ$5)))","v":""},{"$f":"IF($A75=\"\",\"\",IF(OR($BJ$9=\"\",$BJ$9=\"Period Total\",$BJ$9=\"Total\"),\"\",$BJ$11))","v":""},{"$f":"IF($A75=\"\",\"\",IF(OR($BJ$9=\"\",$BJ$9=\"Period Total\",$BJ$9=\"Total\"),\"\",$BJ$14))","v":""},{"$f":"IF(A75=\"\",\"\",'Controls Chart Data'!L75)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A76=\"\",\"\",'Controls Chart Data'!A76)","v":""},{"$f":"IF($A76=\"\",\"\",IF(OR($BK$2=\"\",$BK$2=\"Period Total\",$BK$2=\"Total\"),\"\",IF($BK$4=\"\",$BK$3,$BK$4)))","v":""},{"$f":"IF($A76=\"\",\"\",IF(OR($BK$2=\"\",$BK$2=\"Period Total\",$BK$2=\"Total\"),\"\",IF($BK$5=\"\",$BK$3,$BK$5)))","v":""},{"$f":"IF($A76=\"\",\"\",IF(OR($BK$9=\"\",$BK$9=\"Period Total\",$BK$9=\"Total\"),\"\",$BK$11))","v":""},{"$f":"IF($A76=\"\",\"\",IF(OR($BK$9=\"\",$BK$9=\"Period Total\",$BK$9=\"Total\"),\"\",$BK$14))","v":""},{"$f":"IF(A76=\"\",\"\",'Controls Chart Data'!L76)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A77=\"\",\"\",'Controls Chart Data'!A77)","v":""},{"$f":"IF($A77=\"\",\"\",IF(OR($BL$2=\"\",$BL$2=\"Period Total\",$BL$2=\"Total\"),\"\",IF($BL$4=\"\",$BL$3,$BL$4)))","v":""},{"$f":"IF($A77=\"\",\"\",IF(OR($BL$2=\"\",$BL$2=\"Period Total\",$BL$2=\"Total\"),\"\",IF($BL$5=\"\",$BL$3,$BL$5)))","v":""},{"$f":"IF($A77=\"\",\"\",IF(OR($BL$9=\"\",$BL$9=\"Period Total\",$BL$9=\"Total\"),\"\",$BL$11))","v":""},{"$f":"IF($A77=\"\",\"\",IF(OR($BL$9=\"\",$BL$9=\"Period Total\",$BL$9=\"Total\"),\"\",$BL$14))","v":""},{"$f":"IF(A77=\"\",\"\",'Controls Chart Data'!L77)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A78=\"\",\"\",'Controls Chart Data'!A78)","v":""},{"$f":"IF($A78=\"\",\"\",IF(OR($BM$2=\"\",$BM$2=\"Period Total\",$BM$2=\"Total\"),\"\",IF($BM$4=\"\",$BM$3,$BM$4)))","v":""},{"$f":"IF($A78=\"\",\"\",IF(OR($BM$2=\"\",$BM$2=\"Period Total\",$BM$2=\"Total\"),\"\",IF($BM$5=\"\",$BM$3,$BM$5)))","v":""},{"$f":"IF($A78=\"\",\"\",IF(OR($BM$9=\"\",$BM$9=\"Period Total\",$BM$9=\"Total\"),\"\",$BM$11))","v":""},{"$f":"IF($A78=\"\",\"\",IF(OR($BM$9=\"\",$BM$9=\"Period Total\",$BM$9=\"Total\"),\"\",$BM$14))","v":""},{"$f":"IF(A78=\"\",\"\",'Controls Chart Data'!L78)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A79=\"\",\"\",'Controls Chart Data'!A79)","v":""},{"$f":"IF($A79=\"\",\"\",IF(OR($BN$2=\"\",$BN$2=\"Period Total\",$BN$2=\"Total\"),\"\",IF($BN$4=\"\",$BN$3,$BN$4)))","v":""},{"$f":"IF($A79=\"\",\"\",IF(OR($BN$2=\"\",$BN$2=\"Period Total\",$BN$2=\"Total\"),\"\",IF($BN$5=\"\",$BN$3,$BN$5)))","v":""},{"$f":"IF($A79=\"\",\"\",IF(OR($BN$9=\"\",$BN$9=\"Period Total\",$BN$9=\"Total\"),\"\",$BN$11))","v":""},{"$f":"IF($A79=\"\",\"\",IF(OR($BN$9=\"\",$BN$9=\"Period Total\",$BN$9=\"Total\"),\"\",$BN$14))","v":""},{"$f":"IF(A79=\"\",\"\",'Controls Chart Data'!L79)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A80=\"\",\"\",'Controls Chart Data'!A80)","v":""},{"$f":"IF($A80=\"\",\"\",IF(OR($BO$2=\"\",$BO$2=\"Period Total\",$BO$2=\"Total\"),\"\",IF($BO$4=\"\",$BO$3,$BO$4)))","v":""},{"$f":"IF($A80=\"\",\"\",IF(OR($BO$2=\"\",$BO$2=\"Period Total\",$BO$2=\"Total\"),\"\",IF($BO$5=\"\",$BO$3,$BO$5)))","v":""},{"$f":"IF($A80=\"\",\"\",IF(OR($BO$9=\"\",$BO$9=\"Period Total\",$BO$9=\"Total\"),\"\",$BO$11))","v":""},{"$f":"IF($A80=\"\",\"\",IF(OR($BO$9=\"\",$BO$9=\"Period Total\",$BO$9=\"Total\"),\"\",$BO$14))","v":""},{"$f":"IF(A80=\"\",\"\",'Controls Chart Data'!L80)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A81=\"\",\"\",'Controls Chart Data'!A81)","v":""},{"$f":"IF($A81=\"\",\"\",IF(OR($BP$2=\"\",$BP$2=\"Period Total\",$BP$2=\"Total\"),\"\",IF($BP$4=\"\",$BP$3,$BP$4)))","v":""},{"$f":"IF($A81=\"\",\"\",IF(OR($BP$2=\"\",$BP$2=\"Period Total\",$BP$2=\"Total\"),\"\",IF($BP$5=\"\",$BP$3,$BP$5)))","v":""},{"$f":"IF($A81=\"\",\"\",IF(OR($BP$9=\"\",$BP$9=\"Period Total\",$BP$9=\"Total\"),\"\",$BP$11))","v":""},{"$f":"IF($A81=\"\",\"\",IF(OR($BP$9=\"\",$BP$9=\"Period Total\",$BP$9=\"Total\"),\"\",$BP$14))","v":""},{"$f":"IF(A81=\"\",\"\",'Controls Chart Data'!L81)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A82=\"\",\"\",'Controls Chart Data'!A82)","v":""},{"$f":"IF($A82=\"\",\"\",IF(OR($BQ$2=\"\",$BQ$2=\"Period Total\",$BQ$2=\"Total\"),\"\",IF($BQ$4=\"\",$BQ$3,$BQ$4)))","v":""},{"$f":"IF($A82=\"\",\"\",IF(OR($BQ$2=\"\",$BQ$2=\"Period Total\",$BQ$2=\"Total\"),\"\",IF($BQ$5=\"\",$BQ$3,$BQ$5)))","v":""},{"$f":"IF($A82=\"\",\"\",IF(OR($BQ$9=\"\",$BQ$9=\"Period Total\",$BQ$9=\"Total\"),\"\",$BQ$11))","v":""},{"$f":"IF($A82=\"\",\"\",IF(OR($BQ$9=\"\",$BQ$9=\"Period Total\",$BQ$9=\"Total\"),\"\",$BQ$14))","v":""},{"$f":"IF(A82=\"\",\"\",'Controls Chart Data'!L82)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A83=\"\",\"\",'Controls Chart Data'!A83)","v":""},{"$f":"IF($A83=\"\",\"\",IF(OR($BR$2=\"\",$BR$2=\"Period Total\",$BR$2=\"Total\"),\"\",IF($BR$4=\"\",$BR$3,$BR$4)))","v":""},{"$f":"IF($A83=\"\",\"\",IF(OR($BR$2=\"\",$BR$2=\"Period Total\",$BR$2=\"Total\"),\"\",IF($BR$5=\"\",$BR$3,$BR$5)))","v":""},{"$f":"IF($A83=\"\",\"\",IF(OR($BR$9=\"\",$BR$9=\"Period Total\",$BR$9=\"Total\"),\"\",$BR$11))","v":""},{"$f":"IF($A83=\"\",\"\",IF(OR($BR$9=\"\",$BR$9=\"Period Total\",$BR$9=\"Total\"),\"\",$BR$14))","v":""},{"$f":"IF(A83=\"\",\"\",'Controls Chart Data'!L83)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A84=\"\",\"\",'Controls Chart Data'!A84)","v":""},{"$f":"IF($A84=\"\",\"\",IF(OR($BS$2=\"\",$BS$2=\"Period Total\",$BS$2=\"Total\"),\"\",IF($BS$4=\"\",$BS$3,$BS$4)))","v":""},{"$f":"IF($A84=\"\",\"\",IF(OR($BS$2=\"\",$BS$2=\"Period Total\",$BS$2=\"Total\"),\"\",IF($BS$5=\"\",$BS$3,$BS$5)))","v":""},{"$f":"IF($A84=\"\",\"\",IF(OR($BS$9=\"\",$BS$9=\"Period Total\",$BS$9=\"Total\"),\"\",$BS$11))","v":""},{"$f":"IF($A84=\"\",\"\",IF(OR($BS$9=\"\",$BS$9=\"Period Total\",$BS$9=\"Total\"),\"\",$BS$14))","v":""},{"$f":"IF(A84=\"\",\"\",'Controls Chart Data'!L84)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A85=\"\",\"\",'Controls Chart Data'!A85)","v":""},{"$f":"IF($A85=\"\",\"\",IF(OR($BT$2=\"\",$BT$2=\"Period Total\",$BT$2=\"Total\"),\"\",IF($BT$4=\"\",$BT$3,$BT$4)))","v":""},{"$f":"IF($A85=\"\",\"\",IF(OR($BT$2=\"\",$BT$2=\"Period Total\",$BT$2=\"Total\"),\"\",IF($BT$5=\"\",$BT$3,$BT$5)))","v":""},{"$f":"IF($A85=\"\",\"\",IF(OR($BT$9=\"\",$BT$9=\"Period Total\",$BT$9=\"Total\"),\"\",$BT$11))","v":""},{"$f":"IF($A85=\"\",\"\",IF(OR($BT$9=\"\",$BT$9=\"Period Total\",$BT$9=\"Total\"),\"\",$BT$14))","v":""},{"$f":"IF(A85=\"\",\"\",'Controls Chart Data'!L85)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A86=\"\",\"\",'Controls Chart Data'!A86)","v":""},{"$f":"IF($A86=\"\",\"\",IF(OR($BU$2=\"\",$BU$2=\"Period Total\",$BU$2=\"Total\"),\"\",IF($BU$4=\"\",$BU$3,$BU$4)))","v":""},{"$f":"IF($A86=\"\",\"\",IF(OR($BU$2=\"\",$BU$2=\"Period Total\",$BU$2=\"Total\"),\"\",IF($BU$5=\"\",$BU$3,$BU$5)))","v":""},{"$f":"IF($A86=\"\",\"\",IF(OR($BU$9=\"\",$BU$9=\"Period Total\",$BU$9=\"Total\"),\"\",$BU$11))","v":""},{"$f":"IF($A86=\"\",\"\",IF(OR($BU$9=\"\",$BU$9=\"Period Total\",$BU$9=\"Total\"),\"\",$BU$14))","v":""},{"$f":"IF(A86=\"\",\"\",'Controls Chart Data'!L86)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A87=\"\",\"\",'Controls Chart Data'!A87)","v":""},{"$f":"IF($A87=\"\",\"\",IF(OR($BV$2=\"\",$BV$2=\"Period Total\",$BV$2=\"Total\"),\"\",IF($BV$4=\"\",$BV$3,$BV$4)))","v":""},{"$f":"IF($A87=\"\",\"\",IF(OR($BV$2=\"\",$BV$2=\"Period Total\",$BV$2=\"Total\"),\"\",IF($BV$5=\"\",$BV$3,$BV$5)))","v":""},{"$f":"IF($A87=\"\",\"\",IF(OR($BV$9=\"\",$BV$9=\"Period Total\",$BV$9=\"Total\"),\"\",$BV$11))","v":""},{"$f":"IF($A87=\"\",\"\",IF(OR($BV$9=\"\",$BV$9=\"Period Total\",$BV$9=\"Total\"),\"\",$BV$14))","v":""},{"$f":"IF(A87=\"\",\"\",'Controls Chart Data'!L87)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A88=\"\",\"\",'Controls Chart Data'!A88)","v":""},{"$f":"IF($A88=\"\",\"\",IF(OR($BW$2=\"\",$BW$2=\"Period Total\",$BW$2=\"Total\"),\"\",IF($BW$4=\"\",$BW$3,$BW$4)))","v":""},{"$f":"IF($A88=\"\",\"\",IF(OR($BW$2=\"\",$BW$2=\"Period Total\",$BW$2=\"Total\"),\"\",IF($BW$5=\"\",$BW$3,$BW$5)))","v":""},{"$f":"IF($A88=\"\",\"\",IF(OR($BW$9=\"\",$BW$9=\"Period Total\",$BW$9=\"Total\"),\"\",$BW$11))","v":""},{"$f":"IF($A88=\"\",\"\",IF(OR($BW$9=\"\",$BW$9=\"Period Total\",$BW$9=\"Total\"),\"\",$BW$14))","v":""},{"$f":"IF(A88=\"\",\"\",'Controls Chart Data'!L88)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A89=\"\",\"\",'Controls Chart Data'!A89)","v":""},{"$f":"IF($A89=\"\",\"\",IF(OR($BX$2=\"\",$BX$2=\"Period Total\",$BX$2=\"Total\"),\"\",IF($BX$4=\"\",$BX$3,$BX$4)))","v":""},{"$f":"IF($A89=\"\",\"\",IF(OR($BX$2=\"\",$BX$2=\"Period Total\",$BX$2=\"Total\"),\"\",IF($BX$5=\"\",$BX$3,$BX$5)))","v":""},{"$f":"IF($A89=\"\",\"\",IF(OR($BX$9=\"\",$BX$9=\"Period Total\",$BX$9=\"Total\"),\"\",$BX$11))","v":""},{"$f":"IF($A89=\"\",\"\",IF(OR($BX$9=\"\",$BX$9=\"Period Total\",$BX$9=\"Total\"),\"\",$BX$14))","v":""},{"$f":"IF(A89=\"\",\"\",'Controls Chart Data'!L89)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A90=\"\",\"\",'Controls Chart Data'!A90)","v":""},{"$f":"IF($A90=\"\",\"\",IF(OR($BY$2=\"\",$BY$2=\"Period Total\",$BY$2=\"Total\"),\"\",IF($BY$4=\"\",$BY$3,$BY$4)))","v":""},{"$f":"IF($A90=\"\",\"\",IF(OR($BY$2=\"\",$BY$2=\"Period Total\",$BY$2=\"Total\"),\"\",IF($BY$5=\"\",$BY$3,$BY$5)))","v":""},{"$f":"IF($A90=\"\",\"\",IF(OR($BY$9=\"\",$BY$9=\"Period Total\",$BY$9=\"Total\"),\"\",$BY$11))","v":""},{"$f":"IF($A90=\"\",\"\",IF(OR($BY$9=\"\",$BY$9=\"Period Total\",$BY$9=\"Total\"),\"\",$BY$14))","v":""},{"$f":"IF(A90=\"\",\"\",'Controls Chart Data'!L90)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A91=\"\",\"\",'Controls Chart Data'!A91)","v":""},{"$f":"IF($A91=\"\",\"\",IF(OR($BZ$2=\"\",$BZ$2=\"Period Total\",$BZ$2=\"Total\"),\"\",IF($BZ$4=\"\",$BZ$3,$BZ$4)))","v":""},{"$f":"IF($A91=\"\",\"\",IF(OR($BZ$2=\"\",$BZ$2=\"Period Total\",$BZ$2=\"Total\"),\"\",IF($BZ$5=\"\",$BZ$3,$BZ$5)))","v":""},{"$f":"IF($A91=\"\",\"\",IF(OR($BZ$9=\"\",$BZ$9=\"Period Total\",$BZ$9=\"Total\"),\"\",$BZ$11))","v":""},{"$f":"IF($A91=\"\",\"\",IF(OR($BZ$9=\"\",$BZ$9=\"Period Total\",$BZ$9=\"Total\"),\"\",$BZ$14))","v":""},{"$f":"IF(A91=\"\",\"\",'Controls Chart Data'!L91)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A92=\"\",\"\",'Controls Chart Data'!A92)","v":""},{"$f":"IF($A92=\"\",\"\",IF(OR($CA$2=\"\",$CA$2=\"Period Total\",$CA$2=\"Total\"),\"\",IF($CA$4=\"\",$CA$3,$CA$4)))","v":""},{"$f":"IF($A92=\"\",\"\",IF(OR($CA$2=\"\",$CA$2=\"Period Total\",$CA$2=\"Total\"),\"\",IF($CA$5=\"\",$CA$3,$CA$5)))","v":""},{"$f":"IF($A92=\"\",\"\",IF(OR($CA$9=\"\",$CA$9=\"Period Total\",$CA$9=\"Total\"),\"\",$CA$11))","v":""},{"$f":"IF($A92=\"\",\"\",IF(OR($CA$9=\"\",$CA$9=\"Period Total\",$CA$9=\"Total\"),\"\",$CA$14))","v":""},{"$f":"IF(A92=\"\",\"\",'Controls Chart Data'!L92)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A93=\"\",\"\",'Controls Chart Data'!A93)","v":""},{"$f":"IF($A93=\"\",\"\",IF(OR($CB$2=\"\",$CB$2=\"Period Total\",$CB$2=\"Total\"),\"\",IF($CB$4=\"\",$CB$3,$CB$4)))","v":""},{"$f":"IF($A93=\"\",\"\",IF(OR($CB$2=\"\",$CB$2=\"Period Total\",$CB$2=\"Total\"),\"\",IF($CB$5=\"\",$CB$3,$CB$5)))","v":""},{"$f":"IF($A93=\"\",\"\",IF(OR($CB$9=\"\",$CB$9=\"Period Total\",$CB$9=\"Total\"),\"\",$CB$11))","v":""},{"$f":"IF($A93=\"\",\"\",IF(OR($CB$9=\"\",$CB$9=\"Period Total\",$CB$9=\"Total\"),\"\",$CB$14))","v":""},{"$f":"IF(A93=\"\",\"\",'Controls Chart Data'!L93)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A94=\"\",\"\",'Controls Chart Data'!A94)","v":""},{"$f":"IF($A94=\"\",\"\",IF(OR($CC$2=\"\",$CC$2=\"Period Total\",$CC$2=\"Total\"),\"\",IF($CC$4=\"\",$CC$3,$CC$4)))","v":""},{"$f":"IF($A94=\"\",\"\",IF(OR($CC$2=\"\",$CC$2=\"Period Total\",$CC$2=\"Total\"),\"\",IF($CC$5=\"\",$CC$3,$CC$5)))","v":""},{"$f":"IF($A94=\"\",\"\",IF(OR($CC$9=\"\",$CC$9=\"Period Total\",$CC$9=\"Total\"),\"\",$CC$11))","v":""},{"$f":"IF($A94=\"\",\"\",IF(OR($CC$9=\"\",$CC$9=\"Period Total\",$CC$9=\"Total\"),\"\",$CC$14))","v":""},{"$f":"IF(A94=\"\",\"\",'Controls Chart Data'!L94)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A95=\"\",\"\",'Controls Chart Data'!A95)","v":""},{"$f":"IF($A95=\"\",\"\",IF(OR($CD$2=\"\",$CD$2=\"Period Total\",$CD$2=\"Total\"),\"\",IF($CD$4=\"\",$CD$3,$CD$4)))","v":""},{"$f":"IF($A95=\"\",\"\",IF(OR($CD$2=\"\",$CD$2=\"Period Total\",$CD$2=\"Total\"),\"\",IF($CD$5=\"\",$CD$3,$CD$5)))","v":""},{"$f":"IF($A95=\"\",\"\",IF(OR($CD$9=\"\",$CD$9=\"Period Total\",$CD$9=\"Total\"),\"\",$CD$11))","v":""},{"$f":"IF($A95=\"\",\"\",IF(OR($CD$9=\"\",$CD$9=\"Period Total\",$CD$9=\"Total\"),\"\",$CD$14))","v":""},{"$f":"IF(A95=\"\",\"\",'Controls Chart Data'!L95)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A96=\"\",\"\",'Controls Chart Data'!A96)","v":""},{"$f":"IF($A96=\"\",\"\",IF(OR($CE$2=\"\",$CE$2=\"Period Total\",$CE$2=\"Total\"),\"\",IF($CE$4=\"\",$CE$3,$CE$4)))","v":""},{"$f":"IF($A96=\"\",\"\",IF(OR($CE$2=\"\",$CE$2=\"Period Total\",$CE$2=\"Total\"),\"\",IF($CE$5=\"\",$CE$3,$CE$5)))","v":""},{"$f":"IF($A96=\"\",\"\",IF(OR($CE$9=\"\",$CE$9=\"Period Total\",$CE$9=\"Total\"),\"\",$CE$11))","v":""},{"$f":"IF($A96=\"\",\"\",IF(OR($CE$9=\"\",$CE$9=\"Period Total\",$CE$9=\"Total\"),\"\",$CE$14))","v":""},{"$f":"IF(A96=\"\",\"\",'Controls Chart Data'!L96)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A97=\"\",\"\",'Controls Chart Data'!A97)","v":""},{"$f":"IF($A97=\"\",\"\",IF(OR($CF$2=\"\",$CF$2=\"Period Total\",$CF$2=\"Total\"),\"\",IF($CF$4=\"\",$CF$3,$CF$4)))","v":""},{"$f":"IF($A97=\"\",\"\",IF(OR($CF$2=\"\",$CF$2=\"Period Total\",$CF$2=\"Total\"),\"\",IF($CF$5=\"\",$CF$3,$CF$5)))","v":""},{"$f":"IF($A97=\"\",\"\",IF(OR($CF$9=\"\",$CF$9=\"Period Total\",$CF$9=\"Total\"),\"\",$CF$11))","v":""},{"$f":"IF($A97=\"\",\"\",IF(OR($CF$9=\"\",$CF$9=\"Period Total\",$CF$9=\"Total\"),\"\",$CF$14))","v":""},{"$f":"IF(A97=\"\",\"\",'Controls Chart Data'!L97)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A98=\"\",\"\",'Controls Chart Data'!A98)","v":""},{"$f":"IF($A98=\"\",\"\",IF(OR($CG$2=\"\",$CG$2=\"Period Total\",$CG$2=\"Total\"),\"\",IF($CG$4=\"\",$CG$3,$CG$4)))","v":""},{"$f":"IF($A98=\"\",\"\",IF(OR($CG$2=\"\",$CG$2=\"Period Total\",$CG$2=\"Total\"),\"\",IF($CG$5=\"\",$CG$3,$CG$5)))","v":""},{"$f":"IF($A98=\"\",\"\",IF(OR($CG$9=\"\",$CG$9=\"Period Total\",$CG$9=\"Total\"),\"\",$CG$11))","v":""},{"$f":"IF($A98=\"\",\"\",IF(OR($CG$9=\"\",$CG$9=\"Period Total\",$CG$9=\"Total\"),\"\",$CG$14))","v":""},{"$f":"IF(A98=\"\",\"\",'Controls Chart Data'!L98)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A99=\"\",\"\",'Controls Chart Data'!A99)","v":""},{"$f":"IF($A99=\"\",\"\",IF(OR($CH$2=\"\",$CH$2=\"Period Total\",$CH$2=\"Total\"),\"\",IF($CH$4=\"\",$CH$3,$CH$4)))","v":""},{"$f":"IF($A99=\"\",\"\",IF(OR($CH$2=\"\",$CH$2=\"Period Total\",$CH$2=\"Total\"),\"\",IF($CH$5=\"\",$CH$3,$CH$5)))","v":""},{"$f":"IF($A99=\"\",\"\",IF(OR($CH$9=\"\",$CH$9=\"Period Total\",$CH$9=\"Total\"),\"\",$CH$11))","v":""},{"$f":"IF($A99=\"\",\"\",IF(OR($CH$9=\"\",$CH$9=\"Period Total\",$CH$9=\"Total\"),\"\",$CH$14))","v":""},{"$f":"IF(A99=\"\",\"\",'Controls Chart Data'!L99)","v":""},""]
[{"$f":"IF('Controls Chart Data'!A100=\"\",\"\",'Controls Chart Data'!A100)","v":""},{"$f":"IF($A100=\"\",\"\",IF(OR($CI$2=\"\",$CI$2=\"Period Total\",$CI$2=\"Total\"),\"\",IF($CI$4=\"\",$CI$3,$CI$4)))","v":""},{"$f":"IF($A100=\"\",\"\",IF(OR($CI$2=\"\",$CI$2=\"Period Total\",$CI$2=\"Total\"),\"\",IF($CI$5=\"\",$CI$3,$CI$5)))","v":""},{"$f":"IF($A100=\"\",\"\",IF(OR($CI$9=\"\",$CI$9=\"Period Total\",$CI$9=\"Total\"),\"\",$CI$11))","v":""},{"$f":"IF($A100=\"\",\"\",IF(OR($CI$9=\"\",$CI$9=\"Period Total\",$CI$9=\"Total\"),\"\",$CI$14))","v":""},{"$f":"IF(A100=\"\",\"\",'Controls Chart Data'!L100)","v":""},""]

{"sheet":"Progress Chart","index":3,"n_rows":9,"n_cols":15,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,0,1,15],[3,0,3,1],[3,2,3,4],[3,11,3,13],[3,14,3,15],[2,0,2,15],[5,14,5,15],[3,5,8,10],[4,0,4,1],[4,2,4,4],[4,11,4,13],[4,14,4,15],[0,0,0,15],[8,0,8,1],[8,2,8,4],[8,11,8,13],[8,14,8,15],[7,0,7,1],[7,2,7,4],[7,11,7,13],[7,14,7,15],[6,0,6,1],[6,2,6,4],[6,11,6,13],[6,14,6,15],[5,0,5,1],[5,2,5,4],[5,11,5,13]]}
[{"$f":"IF('Controls Chart Data'!A1:O1=\"\",\"\",'Controls Chart Data'!A1:O1)","v":"Enter Company Name Here"}]
["CONTRACTOR'S PROGRESS EARNINGS S-CURVE"]
[{"$f":"IF('Controls Chart Data'!A3:O3=\"\",\"\",'Controls Chart Data'!A3:O3)","v":"Enter Submission Number and Data Date Here (i.e. Baseline #01, DD: 9-01-19)"}]
["CONTRACT ID. NO.:",null,{"$f":"IF('Controls Chart Data'!C4:I4=\"\",\"\",'Controls Chart Data'!C4:H4)","v":""},null,null,null,null,null,null,null,null,{"$f":"'Controls Chart Data'!K4","v":"CONTRACT NTP DATE:"},null,null,{"$f":"IF('Controls Chart Data'!N4=\"\",\"\",'Controls Chart Data'!N4)","v":""}]
["PROJECT NO.:",null,{"$f":"IF('Controls Chart Data'!C5:I5=\"\",\"\",'Controls Chart Data'!C5:H5)","v":""},null,null,null,null,null,null,null,null,{"$f":"'Controls Chart Data'!K5","v":"CONTRACT COMPLETION DATE:"},null,null,{"$f":"IF('Controls Chart Data'!N5=\"\",\"\",'Controls Chart Data'!N5)","v":""}]
["FHWA PROJECT NO.:",null,{"$f":"IF('Controls Chart Data'!C6:I6=\"\",\"\",'Controls Chart Data'!C6:H6)","v":""},null,null,null,null,null,null,null,null,{"$f":"'Controls Chart Data'!K6","v":"PROJECTED COMPLETION DATE:"},null,null,{"$f":"IF('Controls Chart Data'!N6=\"\",\"\",'Controls Chart Data'!N6)","v":""}]
["PROJECT NAME:",null,{"$f":"IF('Controls Chart Data'!C7:I7=\"\",\"\",'Controls Chart Data'!C7:H7)","v":""},null,null,null,null,null,null,null,null,{"$f":"'Controls Chart Data'!K7","v":"ORIGINAL TOTAL CONTRACT VALUE:"},null,null,{"$f":"IF('Controls Chart Data'!N7=\"\",\"\",'Controls Chart Data'!N7)","v":""}]
["ROUTE:",null,{"$f":"IF('Controls Chart Data'!C8:I8=\"\",\"\",'Controls Chart Data'!C8:H8)","v":""},null,null,null,null,null,null,null,null,{"$f":"'Controls Chart Data'!K8","v":"ADJUSTED TOTAL CONTRACT VALUE:"},null,null,{"$f":"IF('Controls Chart Data'!N8=\"\",\"\",'Controls Chart Data'!N8)","v":""}]
["CITY/COUNTY:",null,{"$f":"IF('Controls Chart Data'!C9:I9=\"\",\"\",'Controls Chart Data'!C9:H9)","v":""},null,null,null,null,null,null,null,null,{"$f":"'Controls Chart Data'!K10","v":"CURRENT PROGRESS ESTIMATE DATE:"},null,null,{"$f":"IF('Controls Chart Data'!N10=\"\",\"\",'Controls Chart Data'!N10)","v":""}]