{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["How To Use","Adjustment Entry Sheet","Calculation Summary Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"How To Use","index":0,"n_rows":49,"n_cols":7,"rows_kept":49,"cut":false,"hidden":false,"merged":[[44,1,44,9],[0,0,0,9],[1,0,1,8],[5,1,9,8],[10,1,11,8],[28,1,31,9],[24,1,26,9],[19,1,21,9],[13,1,16,9]]}
["Retroreflectivity Worksheet"]
["How To Use"]
[]
[]
[null,"This is the 'How to Use' instruction page."]
[null,"There are three sheets in the excel workbook, the This Sheet 'How to Use', 'Adjustment Entry Sheet' and the'Calculation Summary Sheet'.  The 'Summary Sheet' is locked and is only used to create the PDF or printed summary.  The 'Entry Sheet' was made to be easy to use, only the location were information will be entered are unlocked."]
[]
[]
[]
[]
[null,"On the Entry Sheet you will need to enter information in the light yellow cells. First you will need to enter all of the contract data in the top section of the sheet."]
[]
[]
[null,"Start at the top and fill out the Contract information. There are now three choices for stiping percentages.  Standard Waterborne Paint (4” White/4” Yellow), High Build Waterborne Paint (6” White/6” Yellow), and High Build Waterborne Paint (6” White/4” Yellow)"]
[]
[]
[]
[]
["**Change"]
[null,"Fill out the lower section with the contract line information. Some of the information is now autofilled according to the striping type you choice in the top section."]
[]
[]
[]
["**New"]
[null,"This sheet has been revamped to calculate the values based on the percent of length. You will need to add the length of each section to the line and the sheet will do the rest. The sheet will error check to see if you have the lengths or RetroReflectivity % entered.   THe Sheet will error check the totals,  The totoal of all the sections must equal the total length of the line."]
[]
[]
[]
[null,"You will need the Retro Reflectivity report.  This report is currently done by a third party inspection firm and the results are sent to Jefferson City.  From there the reports are sent out to the Inspector or Resident Engineer that requested the Retro Reflectivity Tests."]
[]
[]
[]
[]
[null,"On the Report you will find a section that looks like the following example."]
[null,null,null,"% LINE","% LINE","% LINE","% LINE"]
[null,null,null,"< 300","300-399","400-449","> 450"]
[null,null,null,"MCD","MCD","MCD","MCD"]
[]
[null,null,null,0.02,0.04,0.32,0.56000000000000005]
[null,null,null,0.05,0.08,0.46,0.2]
[]
[]
[]
[]
[null,"Save the document to your local drive. After all the entries are made you will need to go to the Calculation Summary Sheet to review the values. To Print or Save click on the 'Save from as PDF' Button. This button will bring the summary up in a PDF file format.  You will need to save this file in eProjects."]
[]
[]
[]
[null,"Please notify ReDEV email group if feel there are inconsistantcies on the spreedsheet."]

{"sheet":"Adjustment Entry Sheet","index":1,"n_rows":81,"n_cols":163,"rows_kept":81,"cut":false,"hidden":false,"merged":[[36,5,36,9],[59,5,59,9],[36,0,55,0],[59,0,78,0],[65,6,65,7],[66,6,66,7],[66,8,66,9],[42,6,42,7],[43,6,43,7],[42,8,42,9],[43,8,43,9],[65,8,65,9],[30,11,30,12],[31,7,31,8],[31,9,31,10],[31,11,31,12],[30,7,30,8],[30,9,30,10],[42,12,42,13],[43,12,43,13],[65,10,65,11],[66,10,66,11],[65,12,65,13],[66,12,66,13],[42,10,42,11],[43,10,43,11],[13,3,13,5],[15,3,15,5],[26,0,34,0],[0,0,24,0],[5,4,5,6],[0,1,0,5]]}
["Contract Info","Retroreflectivity Payment Adjustment",null,null,null,null,null,"Rev. 2.0.3","2023-07-07"]
[]
[null,"Date Adjustments were Calculated"]
[]
[]
[null,"Choose Pavement Marking Type/Width:",null,null,"Standard Waterborne Paint (4” White/4” Yellow)",null,null,"       ←Click in box and choose from list"]
[]
[null,"Will there be partial pay for Sub-Standard Items tested at less than Specification Limits?"]
[null,"Enter 1 for 'No' and 2 for 'Yes'",null,null,1,null,0,{"$f":"IF(E9>1, \"← Enter % of Deduction Here\",\" \")","v":" "}]
[null,{"$f":"IF(E9=1,\"\",\"If Partial Payment is being made on a Sub-Standard Striping Item then a letter will need to be attached to the adjustment sheet\")","v":""}]
[null,{"$f":"IF(E9=1,\"\",\"stating the reason for the acceptance of the substandard item and the autorizing person.\")","v":""}]
[null,"Contract ID"]
[]
[null,"Prime Contractor",null,null,null,null,null,"Standard Deduction Percentage"]
[null,null,null,null,null,null,null,"Surface Treatment Deduction Percentage"]
[]
[]
[null,"Job Number(s)"]
[]
[null,"Route"]
[]
[null,"County"]
[]
[null,"Federal Job Number"]
[]
[]
["Example",null,null,null,null,"Total Paid Length",null,"Plan or C.O."]
[null,"Line Number","Paint Color","Paint Type","Width (inches)","Paid Length","Unit Price","Cost"]
[null,10,"White","Standard",4,530,0.2,{"$f":"G29*F29","v":106}]
[]
[null,null,null,null,null,1.05,null,1,null,0.8,null,{"$f":"IF(AND($E$9=2,N32=0),$G$9,IF($E$6=$EU$32,EX20,IF($E$6=$EV$37,EX25,IF($E$6=$EV$43,EY30,IF($E$6=$EV$49,EY36,IF($E$6=$EV$54,EZ42,IF($E$6=$EV$59,EZ47,IF($E$6=$EV$66,EZ52,0))))))))","v":0},null,{"$f":"IF($E$9<>1,$G$9,IF($E$6=$EU$32,EY20,IF($E$6=$EV$37,EY25,IF($E$6=$EV$43,EZ30,IF($E$6=$EV$49,EZ36,IF($E$6=$EV$54,FA42,IF($E$6=$EV$59,FA47,IF($E$6=$EV$66,FA52,0))))))))","v":0}]
[null,"Location","Test Results","Length of",null,{"$f":"IF(AND($E$6=$EU$32,$D$41=\"White\"),$EV$34,IF(AND($E$6=$EU$32,$D$41=\"Yellow\"),$EV$35,IF(AND($E$6=$EV$37,$D$41=\"White\"),$EW$40,IF(AND($E$6=$EV$37,$D$41=\"Yellow\"),$EW$41,IF(AND($E$6=$EV$43,$D$41=\"White\"),$EW$45,IF(AND($E$6=$EV$43,$D$41=\"Yellow\"),$EW$46,IF(AND($E$6=$EV$49,$D$41=\"White\"),$EW$51,IF(AND($E$6=$EV$49,$D$41=\"Yellow\"),$EW$52,IF(AND($E$6=$EV$54,$D$41=\"White\"),$EW$56,IF(AND($E$6=$EV$54,$D$41=\"Yellow\"),$EW$57,IF(AND($E$6=$EV$59,$D$41=\"White\"),$EW$62,IF(AND($E$6=$EV$59,$D$41=\"Yellow\"),$EW$64,IF(AND($E$6=$EV$66,$D$41=\"White\"),$EW$68,IF(AND($E$6=$EV$66,$D$41=\"Yellow\"),$EW$69,0))))))))))))))","v":"<270"},null,{"$f":"IF(AND($E$6=$EU$32,$D$41=\"White\"),EV21,IF(AND($E$6=$EU$32,$D$41=\"Yellow\"),EV22,IF(AND($E$6=$EV$37,$D$41=\"White\"),EV26,IF(AND($E$6=$EV$37,$D$41=\"Yellow\"),EW27,IF(AND($E$6=$EV$43,$D$41=\"White\"),EW31,IF(AND($E$6=$EV$43,$D$41=\"Yellow\"),EW32,IF(AND($E$6=$EV$49,$D$41=\"White\"),EX37,IF(AND($E$6=$EV$49,$D$41=\"Yellow\"),EX39,IF(AND($E$6=$EV$54,$D$41=\"White\"),EX43,IF(AND($E$6=$EV$54,$D$41=\"Yellow\"),EX44,IF(AND($E$6=$EV$59,$D$41=\"White\"),EX48,IF(AND($E$6=$EV$59,$D$41=\"Yellow\"),EX49,IF(AND($E$6=$EV$66,$D$41=\"White\"),EX53,IF(AND($E$6=$EV$66,$D$41=\"Yellow\"),EX54,0))))))))))))))","v":0},null,{"$f":"IF(AND($E$6=$EU$32,$D$41=\"White\"),EW21,IF(AND($E$6=$EU$32,$D$41=\"Yellow\"),EW22,IF(AND($E$6=$EV$37,$D$41=\"White\"),EW26,IF(AND($E$6=$EV$37,$D$41=\"Yellow\"),EX27,IF(AND($E$6=$EV$43,$D$41=\"White\"),EX31,IF(AND($E$6=$EV$43,$D$41=\"Yellow\"),EX32,IF(AND($E$6=$EV$49,$D$41=\"White\"),EY37,IF(AND($E$6=$EV$49,$D$41=\"Yellow\"),EY39,IF(AND($E$6=$EV$54,$D$41=\"White\"),EY43,IF(AND($E$6=$EV$54,$D$41=\"Yellow\"),EY44,IF(AND($E$6=$EV$59,$D$41=\"White\"),EY48,IF(AND($E$6=$EV$59,$D$41=\"Yellow\"),EY49,IF(AND($E$6=$EV$66,$D$41=\"White\"),EY53,IF(AND($E$6=$EV$66,$D$41=\"Yellow\"),EY54,0))))))))))))))","v":0},null,{"$f":"IF(AND($E$6=$EU$32,$D$41=\"White\"),EX21,IF(AND($E$6=$EU$32,$D$41=\"Yellow\"),EX22,IF(AND($E$6=$EV$37,$D$41=\"White\"),EX26,IF(AND($E$6=$EV$37,$D$41=\"Yellow\"),EY27,IF(AND($E$6=$EV$43,$D$41=\"White\"),EY31,IF(AND($E$6=$EV$43,$D$41=\"Yellow\"),EY32,IF(AND($E$6=$EV$49,$D$41=\"White\"),EZ37,IF(AND($E$6=$EV$49,$D$41=\"Yellow\"),EZ39,IF(AND($E$6=$EV$54,$D$41=\"White\"),EZ43,IF(AND($E$6=$EV$54,$D$41=\"Yellow\"),EZ44,IF(AND($E$6=$EV$59,$D$41=\"White\"),EZ48,IF(AND($E$6=$EV$59,$D$41=\"Yellow\"),EZ49,IF(AND($E$6=$EV$66,$D$41=\"White\"),EZ53,IF(AND($E$6=$EV$66,$D$41=\"Yellow\"),EZ54,0))))))))))))))","v":0},null,{"$f":"IF(AND($E$6=$EU$32,$D$41=\"White\"),EY21,IF(AND($E$6=$EU$32,$D$41=\"Yellow\"),EY22,IF(AND($E$6=$EV$37,$D$41=\"White\"),EY26,IF(AND($E$6=$EV$37,$D$41=\"Yellow\"),EZ27,IF(AND($E$6=$EV$43,$D$41=\"White\"),EZ31,IF(AND($E$6=$EV$43,$D$41=\"Yellow\"),EZ32,IF(AND($E$6=$EV$49,$D$41=\"White\"),FA37,IF(AND($E$6=$EV$49,$D$41=\"Yellow\"),FA39,IF(AND($E$6=$EV$54,$D$41=\"White\"),FA43,IF(AND($E$6=$EV$54,$D$41=\"Yellow\"),FA44,IF(AND($E$6=$EV$59,$D$41=\"White\"),FA48,IF(AND($E$6=$EV$59,$D$41=\"Yellow\"),FA49,IF(AND($E$6=$EV$66,$D$41=\"White\"),FA53,IF(AND($E$6=$EV$66,$D$41=\"Yellow\"),FA54,0))))))))))))))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prior to July 2017 - Stiping",null,null,null,null,null,null,{"$f":"EU32","v":"Prior to July 2017 - Stiping"}]
[null,null,null,"Sections",null,"Retroreflectivity %","% total placed","Retroreflectivity %","% total placed","Retroreflectivity %","% total placed","Retroreflectivity %","% total placed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%",null,1,0.8,0.6,0.5,0,null,null,null,1,null,null,"White"]
[null,"Dashed Centerline",{"$f":"IF(SUM(F34:N34)=0,\" \",\"% in Range\")","v":{"$error":"#DIV/0!"}},265,null,0.5,{"$f":"IF(D34=0,\"\",F34*O34)","v":{"$error":"#DIV/0!"}},0.5,{"$f":"IF(D34=0,\"\",H34*O34)","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(D34=0,\"\",J34*O34)","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(D34=0,\"\",L34*O34)","v":{"$error":"#DIV/0!"}},null,{"$f":"D34/$G$41","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"White",null,"≥ 300","290-299","280-289","270-279","<270",null,{"$f":"EV43","v":"Standard Waterborne Paint (4” White/4” Yellow)"},null,null,null,null,"Yellow"]
[null,null,{"$f":"IF(SUM(F35:N35)=0,\" \",\"% in Range\")","v":{"$error":"#DIV/0!"}},265,null,0.15,{"$f":"IF(D35=0,\"\",F35*O35)","v":{"$error":"#DIV/0!"}},0.8,{"$f":"IF(D35=0,\"\",H35*O35)","v":{"$error":"#DIV/0!"}},0.05,{"$f":"IF(D35=0,\"\",J35*O35)","v":{"$error":"#DIV/0!"}},0,{"$f":"IF(D35=0,\"\",L35*O35)","v":{"$error":"#DIV/0!"}},null,{"$f":"D35/$G$41","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yellow",null,"≥ 225","215-224","205-214","195-204","<195",null,{"$f":"EV49","v":"High Build Waterborne Paint (6” White/6” Yellow)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EV54","v":"High Build Waterborne Paint (6” White/4” Yellow)"}]
["White Paint Only",null,null,null,"Description:",{"$f":"IF($E$6=\"Standard Waterborne Paint (4” White/4” Yellow)\",\"4 IN. WHITE STANDARD WATERBORNE PAVEMENT MARKING PAINT\",IF($E$6=\"High Build Waterborne Paint (6” White/4” Yellow)\",\"6 IN. WHITE HIGH BUILD WATERBORNE PAVEMENT MARKING PAINT\",IF($E$6=\"High Build Waterborne Paint (6” White/6” Yellow)\",\"6 IN. WHITE HIGH BUILD WATERBORNE PAVEMENT MARKING PAINT\",\"12 IN. WHITE HIGH BUILD WATERBORNE PAVEMENT\")))","v":"4 IN. WHITE STANDARD WATERBORNE PAVEMENT MARKING PAINT"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prior to July 2017 - Surface Treatment Deduction Percentage",null,null,null,null,null,{"$f":"EV59","v":"High Build Waterborne Paint (12 \" White)"},{"$f":"EV59","v":"High Build Waterborne Paint (12 \" White)"}]
[]
[null,null,null,null,null,null,"Total Paid Length (LF)",null,"Unadjusted",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%",null,1,0.95,0.2,0,null,null,{"$f":"EV66","v":"Temporary Pavement Marking Paint"}]
[null,"Line Number",null,"Paint Color","Paint Type","Width (inches)","Sum of all section below","Unit Price","Pay Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"White",null,"≥ 300","280-299","250-279","<250"]
[null,null,null,"White",{"$f":"IF($E$6=\"Standard Waterborne Paint (4” White/4” Yellow)\",\"Standard\",\"High Build\")","v":"Standard"},{"$f":"IF($E$6=\"Standard Waterborne Paint (4” White/4” Yellow)\",4,IF($E$6=\"High Build Waterborne Paint (6” White/6” Yellow)\",6,IF($E$6=\"High Build Waterborne Paint (6” White/4” Yellow)\",6,12)))","v":4},{"$f":"SUM(E46:E55)","v":0},null,{"$f":"H41*G41","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yellow",null,"≥ 225","205-224","175-204","<175"]
[]
[null,null,null,null,null,"% of",{"$f":"IF($E$6=$EU$32,EV33,IF($E$6=$EV$37,EW39,IF($E$6=$EV$43,EW44,IF($E$6=$EV$49,EW50,IF($E$6=$EV$54,EW55,IF($E$6=$EV$59,EW60,IF($E$6=$EV$66,EW67,0)))))))","v":0},null,{"$f":"IF($E$6=$EU$32,EW33,IF($E$6=$EV$37,EX39,IF($E$6=$EV$43,EX44,IF($E$6=$EV$49,EX50,IF($E$6=$EV$54,EX55,IF($E$6=$EV$59,EX60,IF($E$6=$EV$66,EX67,0)))))))","v":0.8},null,{"$f":"IF($E$6=$EU$32,EX33,IF($E$6=$EV$37,EY39,IF($E$6=$EV$43,EY44,IF($E$6=$EV$49,EY50,IF($E$6=$EV$54,EY55,IF($E$6=$EV$59,EY60,IF($E$6=$EV$66,EY67,0)))))))","v":1},null,{"$f":"IF(AND($E$9=2,O44=0),$G$9,IF($E$6=$EU$32,EY33,IF($E$6=$EV$37,EZ39,IF($E$6=$EV$43,EZ44,IF($E$6=$EV$49,EZ50,IF($E$6=$EV$54,EZ55,IF($E$6=$EV$59,EZ60,IF($E$6=$EV$66,EZ67,0))))))))","v":1.05},null,{"$f":"IF($E$9<>1,$G$9,IF($E$6=$EU$32,EZ33,IF($E$6=$EV$37,FA39,IF($E$6=$EV$43,FA44,IF($E$6=$EV$49,FA50,IF($E$6=$EV$54,FA55,IF($E$6=$EV$59,FA60,IF($E$6=$EV$66,FA67,0))))))))","v":0},"Total of",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard Waterborne Paint (4” White/4” Yellow)"]
[null,"Begin","End","Line","Length of","Total length",{"$f":"IF(AND($E$6=$EU$32,$D$41=\"White\"),$EV$34,IF(AND($E$6=$EU$32,$D$41=\"Yellow\"),$EV$35,IF(AND($E$6=$EV$37,$D$41=\"White\"),$EW$40,IF(AND($E$6=$EV$37,$D$41=\"Yellow\"),$EW$41,IF(AND($E$6=$EV$43,$D$41=\"White\"),$EW$45,IF(AND($E$6=$EV$43,$D$41=\"Yellow\"),$EW$46,IF(AND($E$6=$EV$49,$D$41=\"White\"),$EW$51,IF(AND($E$6=$EV$49,$D$41=\"Yellow\"),$EW$52,IF(AND($E$6=$EV$54,$D$41=\"White\"),$EW$56,IF(AND($E$6=$EV$54,$D$41=\"Yellow\"),$EW$57,IF(AND($E$6=$EV$59,$D$41=\"White\"),$EW$62,IF(AND($E$6=$EV$59,$D$41=\"Yellow\"),$EW$64,IF(AND($E$6=$EV$66,$D$41=\"White\"),$EW$68,IF(AND($E$6=$EV$66,$D$41=\"Yellow\"),$EW$69,0))))))))))))))","v":"<270"},null,{"$f":"IF(AND($E$6=$EU$32,$D$41=\"White\"),EW34,IF(AND($E$6=$EU$32,$D$41=\"Yellow\"),EW35,IF(AND($E$6=$EV$37,$D$41=\"White\"),EX40,IF(AND($E$6=$EV$37,$D$41=\"Yellow\"),EX41,IF(AND($E$6=$EV$43,$D$41=\"White\"),EX45,IF(AND($E$6=$EV$43,$D$41=\"Yellow\"),EX46,IF(AND($E$6=$EV$49,$D$41=\"White\"),EX51,IF(AND($E$6=$EV$49,$D$41=\"Yellow\"),EX52,IF(AND($E$6=$EV$54,$D$41=\"White\"),EX56,IF(AND($E$6=$EV$54,$D$41=\"Yellow\"),EX57,IF(AND($E$6=$EV$59,$D$41=\"White\"),EX62,IF(AND($E$6=$EV$59,$D$41=\"Yellow\"),EX64,IF(AND($E$6=$EV$66,$D$41=\"White\"),EX68,IF(AND($E$6=$EV$66,$D$41=\"Yellow\"),EX69,0))))))))))))))","v":"270-299"},null,{"$f":"IF(AND($E$6=$EU$32,$D$41=\"White\"),EX34,IF(AND($E$6=$EU$32,$D$41=\"Yellow\"),EX35,IF(AND($E$6=$EV$37,$D$41=\"White\"),EY40,IF(AND($E$6=$EV$37,$D$41=\"Yellow\"),EY41,IF(AND($E$6=$EV$43,$D$41=\"White\"),EY45,IF(AND($E$6=$EV$43,$D$41=\"Yellow\"),EY46,IF(AND($E$6=$EV$49,$D$41=\"White\"),EY51,IF(AND($E$6=$EV$49,$D$41=\"Yellow\"),EY52,IF(AND($E$6=$EV$54,$D$41=\"White\"),EY56,IF(AND($E$6=$EV$54,$D$41=\"Yellow\"),EY57,IF(AND($E$6=$EV$59,$D$41=\"White\"),EY62,IF(AND($E$6=$EV$59,$D$41=\"Yellow\"),EY64,IF(AND($E$6=$EV$66,$D$41=\"White\"),EY68,IF(AND($E$6=$EV$66,$D$41=\"Yellow\"),EY69,0))))))))))))))","v":"300-349"},null,{"$f":"IF(AND($E$6=$EU$32,$D$41=\"White\"),EY34,IF(AND($E$6=$EU$32,$D$41=\"Yellow\"),EY35,IF(AND($E$6=$EV$37,$D$41=\"White\"),EZ40,IF(AND($E$6=$EV$37,$D$41=\"Yellow\"),EZ41,IF(AND($E$6=$EV$43,$D$41=\"White\"),EZ45,IF(AND($E$6=$EV$43,$D$41=\"Yellow\"),EZ46,IF(AND($E$6=$EV$49,$D$41=\"White\"),EZ51,IF(AND($E$6=$EV$49,$D$41=\"Yellow\"),EZ52,IF(AND($E$6=$EV$54,$D$41=\"White\"),EZ56,IF(AND($E$6=$EV$54,$D$41=\"Yellow\"),EZ57,IF(AND($E$6=$EV$59,$D$41=\"White\"),EZ62,IF(AND($E$6=$EV$59,$D$41=\"Yellow\"),EZ64,IF(AND($E$6=$EV$66,$D$41=\"White\"),EZ68,IF(AND($E$6=$EV$66,$D$41=\"Yellow\"),EZ69,0))))))))))))))","v":"≥350"},null,{"$f":"IF(AND($E$6=$EU$32,$D$41=\"White\"),EZ34,IF(AND($E$6=$EU$32,$D$41=\"Yellow\"),EZ35,IF(AND($E$6=$EV$37,$D$41=\"White\"),FA40,IF(AND($E$6=$EV$37,$D$41=\"Yellow\"),FA41,IF(AND($E$6=$EV$43,$D$41=\"White\"),FA45,IF(AND($E$6=$EV$43,$D$41=\"Yellow\"),FA46,IF(AND($E$6=$EV$49,$D$41=\"White\"),FA51,IF(AND($E$6=$EV$49,$D$41=\"Yellow\"),FA52,IF(AND($E$6=$EV$54,$D$41=\"White\"),FA56,IF(AND($E$6=$EV$54,$D$41=\"Yellow\"),FA57,IF(AND($E$6=$EV$59,$D$41=\"White\"),FA62,IF(AND($E$6=$EV$59,$D$41=\"Yellow\"),FA64,IF(AND($E$6=$EV$66,$D$41=\"White\"),FA68,IF(AND($E$6=$EV$66,$D$41=\"Yellow\"),FA69,0))))))))))))))","v":0},"RetroRelectivity %",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%",null,0,0.8,1,1.05]
[null,"LogMile","LogMile","Description","Section in LF",null,"Retroreflectivity %","% total placed","Retroreflectivity %","% total placed","Retroreflectivity %","% total placed","Retroreflectivity %","% total placed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"White",null,"<270","270-299","300-349","≥350"]
[null,null,null,null,null,{"$f":"IF($G$41=0,0,E46/$G$41)","v":0},null,{"$f":"IF(E46=0,\"\",G46*F46)","v":""},null,{"$f":"IF(E46=0,\"\",I46*F46)","v":""},null,{"$f":"IF(E46=0,\"\",K46*F46)","v":""},null,{"$f":"IF(E46=0,\"\",M46*F46)","v":""},null,{"$f":"IF(OR(O46+M46+K46+I46+G46=1,O46+M46+K46+I46+G46=0),IF(AND(E46>0,O46+M46+K46+I46+G46<>1),\"ERROR\",O46+M46+K46+I46+G46),\"ERROR\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yellow",null,"<196","196-224","225-274","≥275"]
[null,null,null,null,null,{"$f":"IF($G$41=0,0,E47/$G$41)","v":0},null,{"$f":"IF(E47=0,\"\",G47*F47)","v":""},null,{"$f":"IF(E47=0,\"\",I47*F47)","v":""},null,"",null,"",null,{"$f":"IF(OR(O47+M47+K47+I47+G47=1,O47+M47+K47+I47+G47=0),IF(AND(E47>0,O47+M47+K47+I47+G47<>1),\"ERROR\",O47+M47+K47+I47+G47),\"ERROR\")","v":0}]
[null,null,null,null,null,0,null,{"$f":"IF(E48=0,\"\",G48*F48)","v":""},null,{"$f":"IF(E48=0,\"\",I48*F48)","v":""},null,"",null,"",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lt. Edge Line"]
[null,null,null,null,null,0,null,{"$f":"IF(E49=0,\"\",G49*F49)","v":""},null,"",null,"",null,"",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rt. Edge Line",null,null,null,null,null,null,"High Build Waterborne Paint (6” White/6” Yellow)"]
[null,null,null,null,null,0,null,{"$f":"IF(E50=0,\"\",G50*F50)","v":""},null,{"$f":"IF(E50=0,\"\",I50*F50)","v":""},null,"",null,"",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lane /Center Line",null,null,null,null,null,"%",null,0,0.8,1,1.05]
[null,null,null,null,null,0,null,"",null,"",null,"",null,"",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"White",null,"<300","300-399","400-449","≥450"]
[null,null,null,null,null,0,null,"",null,"",null,"",null,"",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yellow",null,"<225","225-299","300-349","≥350"]
[null,null,null,null,null,0,null,"",null,"",null,"",null,"",null,0]
[null,null,null,null,null,0,null,"",null,"",null,"",null,"",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Build Waterborne Paint (6” White/4” Yellow)"]
[null,null,null,null,null,0,null,"",null,"",null,"",null,"",null,{"$f":"IF(OR(O55+M55+K55+I55+G55=1,O55+M55+K55+I55+G55=0),IF(AND(E55>0,O55+M55+K55+I55+G55<>1),\"ERROR\",O55+M55+K55+I55+G55),\"ERROR\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%",null,0,0.8,1,1.05]
[null,null,null,{"$f":"IF(SUM(E43:E55)<>G41,\"ERROR (total sections must equal Paid Length)\",)","v":0},null,null,null,{"$f":"SUM(H46:H55)","v":0},null,{"$f":"SUM(J46:J55)","v":0},null,{"$f":"SUM(L46:L55)","v":0},null,{"$f":"SUM(N46:N55)","v":0},{"$f":"O46*E46+O47*E47+O48*E48+O49*E49+O50*E50+O51*E51+O52*E52+O53*E53+O54*E54+O55*E55","v":0},{"$f":"IF(OR(O56+N56+L56+J56+H56=1,O56+N56+L56+J56+H56=0),\"GOOD\",\"ERROR\")","v":"GOOD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"White",null,"<300","300-399","400-449","≥450"]
[null,null,null,"Adjusted Pay Amount",null,null,null,{"$f":"'Calculation Summary Sheet'!K16","v":0},null,{"$f":"'Calculation Summary Sheet'!K17","v":0},null,{"$f":"'Calculation Summary Sheet'!K18","v":0},null,{"$f":"'Calculation Summary Sheet'!K19","v":0},{"$f":"'Calculation Summary Sheet'!K20","v":0},{"$f":"IF(OR(SUM(E46:E55)<>G41,P56=\"ERROR\"), \"ERROR\",SUM(H57:O57)-I41)","v":0},"Line Item",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yellow",null,"<225","225-299","300-349","≥350"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjustment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Build Waterborne Paint (12 \" White)"]
["Yellow Paint only",null,null,null,"Description:",{"$f":"IF($E$6=\"Standard Waterborne Paint (4” White/4” Yellow)\",\"4 IN. YELLOW STANDARD WATERBORNE PAVEMENT MARKING PAINT\",IF($E$6=\"High Build Waterborne Paint (6” White/4” Yellow)\",\"4 IN. YELLOW HIGH BUILD WATERBORNE PAVEMENT MARKING PAINT\",IF($E$6=\"High Build Waterborne Paint (6” White/6” Yellow)\",\"6 IN. YELLOW HIGH BUILD WATERBORNE PAVEMENT MARKING PAINT\",\" \")))","v":"4 IN. YELLOW STANDARD WATERBORNE PAVEMENT MARKING PAINT"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%",null,0,0.8,1,1.05]
[]
[null,null,null,null,null,null,"Total Paid Length (LF)",null,"Unadjusted",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"White",null,"<300","300-399","400-449","≥450"]
[null,"Line Number",null,"Paint Color","Paint Type","Width (inches)","Sum of all section below","Unit Price","Pay Total"]
[null,null,null,"Yellow",{"$f":"IF($E$6=\"Standard Waterborne Paint (4” White/4” Yellow)\",\"Standard\",IF($E$6=\"High Build Waterborne Paint (6” White/4” Yellow)\",\"High Build\",\"High Build\"))","v":"Standard"},{"$f":"IF(E6=\"Standard Waterborne Paint (4” White/4” Yellow)\",4,IF(E6=\"High Build Waterborne Paint (6” White/4” Yellow)\",4,IF(E6=\"High Build Waterborne Paint (6” White/6” Yellow)\",6,0)))","v":4},{"$f":"SUM(E69:E78)","v":0},null,{"$f":"H64*G64","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yellow",null,0,0,0,0]
[]
[null,null,null,null,null,"% of",{"$f":"G43","v":0},null,{"$f":"I43","v":0.8},null,{"$f":"K43","v":1},null,{"$f":"M43","v":1.05},null,{"$f":"O43","v":0},"Total of",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temporary Pavement Marking Paint"]
[null,"Begin","End","Line","Length of","Total length",{"$f":"IF(AND($E$6=$EU$32,$D$64=\"White\"),EV34,IF(AND($E$6=$EU$32,$D$64=\"Yellow\"),EV35,IF(AND($E$6=$EV$37,$D$64=\"White\"),EW40,IF(AND($E$6=$EV$37,$D$64=\"Yellow\"),EW41,IF(AND($E$6=$EV$43,$D$64=\"White\"),EW45,IF(AND($E$6=$EV$43,$D$64=\"Yellow\"),EW46,IF(AND($E$6=$EV$49,$D$64=\"White\"),EW51,IF(AND($E$6=$EV$49,$D$64=\"Yellow\"),EW52,IF(AND($E$6=$EV$54,$D$64=\"White\"),EW56,IF(AND($E$6=$EV$54,$D$64=\"Yellow\"),EW57,IF(AND($E$6=$EV$59,$D$64=\"White\"),EW62,IF(AND($E$6=$EV$59,$D$64=\"Yellow\"),EW64,IF(AND($E$6=$EV$66,$D$64=\"White\"),EW68,IF(AND($E$6=$EV$66,$D$64=\"Yellow\"),EW69,0))))))))))))))","v":"<196"},null,{"$f":"IF(AND($E$6=$EU$32,$D$64=\"White\"),EW34,IF(AND($E$6=$EU$32,$D$64=\"Yellow\"),EW35,IF(AND($E$6=$EV$37,$D$64=\"White\"),EX40,IF(AND($E$6=$EV$37,$D$64=\"Yellow\"),EX41,IF(AND($E$6=$EV$43,$D$64=\"White\"),EX45,IF(AND($E$6=$EV$43,$D$64=\"Yellow\"),EX46,IF(AND($E$6=$EV$49,$D$64=\"White\"),EX51,IF(AND($E$6=$EV$49,$D$64=\"Yellow\"),EX52,IF(AND($E$6=$EV$54,$D$64=\"White\"),EX56,IF(AND($E$6=$EV$54,$D$64=\"Yellow\"),EX57,IF(AND($E$6=$EV$59,$D$64=\"White\"),EX62,IF(AND($E$6=$EV$59,$D$64=\"Yellow\"),EX64,IF(AND($E$6=$EV$66,$D$64=\"White\"),EX68,IF(AND($E$6=$EV$66,$D$64=\"Yellow\"),EX69,0))))))))))))))","v":"196-224"},null,{"$f":"IF(AND($E$6=$EU$32,$D$64=\"White\"),EX34,IF(AND($E$6=$EU$32,$D$64=\"Yellow\"),EX35,IF(AND($E$6=$EV$37,$D$64=\"White\"),EY40,IF(AND($E$6=$EV$37,$D$64=\"Yellow\"),EY41,IF(AND($E$6=$EV$43,$D$64=\"White\"),EY45,IF(AND($E$6=$EV$43,$D$64=\"Yellow\"),EY46,IF(AND($E$6=$EV$49,$D$64=\"White\"),EY51,IF(AND($E$6=$EV$49,$D$64=\"Yellow\"),EY52,IF(AND($E$6=$EV$54,$D$64=\"White\"),EY56,IF(AND($E$6=$EV$54,$D$64=\"Yellow\"),EY57,IF(AND($E$6=$EV$59,$D$64=\"White\"),EY62,IF(AND($E$6=$EV$59,$D$64=\"Yellow\"),EY64,IF(AND($E$6=$EV$66,$D$64=\"White\"),EY68,IF(AND($E$6=$EV$66,$D$64=\"Yellow\"),EY69,0))))))))))))))","v":"225-274"},null,{"$f":"IF(AND($E$6=$EU$32,$D$64=\"White\"),EY34,IF(AND($E$6=$EU$32,$D$64=\"Yellow\"),EY35,IF(AND($E$6=$EV$37,$D$64=\"White\"),EZ40,IF(AND($E$6=$EV$37,$D$64=\"Yellow\"),EZ41,IF(AND($E$6=$EV$43,$D$64=\"White\"),EZ45,IF(AND($E$6=$EV$43,$D$64=\"Yellow\"),EZ46,IF(AND($E$6=$EV$49,$D$64=\"White\"),EZ51,IF(AND($E$6=$EV$49,$D$64=\"Yellow\"),EZ52,IF(AND($E$6=$EV$54,$D$64=\"White\"),EZ56,IF(AND($E$6=$EV$54,$D$64=\"Yellow\"),EZ57,IF(AND($E$6=$EV$59,$D$64=\"White\"),EZ62,IF(AND($E$6=$EV$59,$D$64=\"Yellow\"),EZ64,IF(AND($E$6=$EV$66,$D$64=\"White\"),EZ68,IF(AND($E$6=$EV$66,$D$64=\"Yellow\"),EZ69,0))))))))))))))","v":"≥275"},null,{"$f":"IF(AND($E$6=$EU$32,$D$64=\"White\"),EZ34,IF(AND($E$6=$EU$32,$D$64=\"Yellow\"),EZ35,IF(AND($E$6=$EV$37,$D$64=\"White\"),FA40,IF(AND($E$6=$EV$37,$D$64=\"Yellow\"),FA41,IF(AND($E$6=$EV$43,$D$64=\"White\"),FA45,IF(AND($E$6=$EV$43,$D$64=\"Yellow\"),FA46,IF(AND($E$6=$EV$49,$D$64=\"White\"),FA51,IF(AND($E$6=$EV$49,$D$64=\"Yellow\"),FA52,IF(AND($E$6=$EV$54,$D$64=\"White\"),FA56,IF(AND($E$6=$EV$54,$D$64=\"Yellow\"),FA57,IF(AND($E$6=$EV$59,$D$64=\"White\"),FA62,IF(AND($E$6=$EV$59,$D$64=\"Yellow\"),FA64,IF(AND($E$6=$EV$66,$D$64=\"White\"),FA68,IF(AND($E$6=$EV$66,$D$64=\"Yellow\"),FA69,0))))))))))))))","v":0},"RetroRelectivity %",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%",null,1,0,0,0]
[null,"LogMile","LogMile","Description","Section in LF",null,"Retroreflectivity %","% total placed","Retroreflectivity %","% total placed","Retroreflectivity %","% total placed","Retroreflectivity %","% total placed",null,"(Total Must = 100%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"White",null,"≥275"]
[null,null,null,null,null,{"$f":"IF($G$64=0,0,E69/$G$64)","v":0},null,{"$f":"IF(E69=0,\"\",G69*F69)","v":""},null,{"$f":"IF(E69=0,\"\",I69*F69)","v":""},null,{"$f":"IF(E69=0,\"\",K69*F69)","v":""},null,{"$f":"IF(E69=0,\"\",M69*F69)","v":""},null,{"$f":"IF(OR(O69+M69+K69+I69+G69=1,O69+M69+K69+I69+G69=0),IF(AND(E69>0,O69+M69+K69+I69+G69<>1),\"ERROR\",O69+M69+K69+I69+G69),\"ERROR\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yellow",null,"≥200"]
[null,null,null,null,null,{"$f":"IF($G$64=0,0,E70/$G$64)","v":0},null,"",null,"",null,"",null,"",null,{"$f":"IF(OR(O70+M70+K70+I70+G70=1,O70+M70+K70+I70+G70=0),IF(AND(E70>0,O70+M70+K70+I70+G70<>1),\"ERROR\",O70+M70+K70+I70+G70),\"ERROR\")","v":0}]
[null,null,null,null,null,0,null,"",null,"",null,"",null,"",null,0]
[null,null,null,null,null,0,null,"",null,"",null,"",null,"",null,0]
[null,null,null,null,null,0,null,"",null,"",null,"",null,"",null,0]
[null,null,null,null,null,0,null,"",null,"",null,"",null,"",null,0]
[null,null,null,null,null,0,null,"",null,"",null,"",null,"",null,0]
[null,null,null,null,null,0,null,"",null,"",null,"",null,"",null,0]
[null,null,null,null,null,0,null,"",null,"",null,"",null,"",null,0]
[null,null,null,null,null,0,null,"",null,"",null,"",null,"",null,0]
[null,null,null,{"$f":"IF(SUM(E66:E78)<>G64,\"ERROR (total sections must equal Paid Length)\",)","v":0},null,0,null,{"$f":"SUM(H69:H78)","v":0},null,{"$f":"SUM(J69:J78)","v":0},null,{"$f":"SUM(L69:L78)","v":0},null,{"$f":"SUM(N69:N78)","v":0},{"$f":"O69*E69+O70*E70+O71*E71+O72*E72+O73*E73+O74*E74+O75*E75+O76*E76+O77*E77+O78*E78","v":0},{"$f":"IF(OR(O79+N79+L79+J79+H79=1,O79+N79+L79+J79+H79=0),\"GOOD\",\"ERROR\")","v":"GOOD"}]
[null,null,null,"Adjusted Pay Amount",null,null,null,{"$f":"'Calculation Summary Sheet'!K40","v":0},null,{"$f":"'Calculation Summary Sheet'!K41","v":0},null,{"$f":"'Calculation Summary Sheet'!K42","v":0},null,{"$f":"'Calculation Summary Sheet'!K43","v":0},{"$f":"'Calculation Summary Sheet'!K44","v":0},{"$f":"IF(OR(SUM(E69:E78)<>G64,P79=\"ERROR\"), \"ERROR\",SUM(H80:O80)-I64)","v":0},"Line Item"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjustment"]

{"sheet":"Calculation Summary Sheet","index":2,"n_rows":54,"n_cols":12,"rows_kept":54,"cut":false,"hidden":false,"merged":[[46,0,46,2],[47,0,47,2],[48,0,48,2],[49,0,49,2],[50,0,50,2],[42,0,42,2],[43,0,43,2],[44,0,44,2],[45,0,45,2],[15,1,15,2],[9,7,9,8],[13,10,14,10],[13,11,14,11],[37,10,38,10],[37,11,38,11],[17,0,17,2],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,24,2],[25,0,25,2],[26,0,26,2],[0,1,0,11],[4,5,4,6],[8,3,8,6],[8,7,8,8],[3,3,3,4],[3,5,3,6],[8,1,8,2],[4,3,4,4],[3,7,3,8],[4,7,4,8],[5,3,5,4],[95,1,95,2],[69,1,69,2],[56,1,56,2],[31,3,31,6],[63,3,63,7],[72,3,72,6],[60,3,60,6],[61,3,61,6],[59,3,59,6],[89,3,89,7],[86,3,86,6],[73,3,73,6],[87,3,87,6],[32,7,32,8],[82,1,82,2],[41,0,41,2],[9,3,10,6],[85,3,85,6],[38,3,38,7],[53,2,53,9],[74,3,74,6],[39,1,39,2],[76,3,76,7],[32,1,32,2],[33,1,33,2],[33,7,33,8],[34,7,34,8],[32,3,32,6],[33,3,34,6],[14,3,14,7],[10,7,10,8],[9,1,9,2]]}
[null,"Pavement Marking Payment Adjustments"]
[null,null,null,null,null,"For Retro-Reflectivity Testing"]
[]
[null,null,"Contract ID","Job Number",null,"Route",null,"Date"]
[null,null,{"$f":"'Adjustment Entry Sheet'!$D$12","v":0},{"$f":"'Adjustment Entry Sheet'!D18","v":0},null,{"$f":"'Adjustment Entry Sheet'!$D$20","v":0},null,{"$f":"'Adjustment Entry Sheet'!$E$3","v":"00:00:00"}]
[null,null,null,{"$f":"MID(D5,2,7)","v":""},null,{"$f":"SUBSTITUTE(B1,\" \",\"_\")","v":"Pavement_Marking_Payment_Adjustments"}]
[]
[null,null,null,null,null,null,null,null,null,null,"Line Item"]
[null,"Line #",null,"Description",null,null,null,"Paid Quantity",null,"Unit Cost","Adjustment"]
[null,{"$f":"'Adjustment Entry Sheet'!B41","v":0},null,{"$f":"'Adjustment Entry Sheet'!F37","v":"4 IN. WHITE STANDARD WATERBORNE PAVEMENT MARKING PAINT"},null,null,null,{"$f":"'Adjustment Entry Sheet'!G41","v":0},null,{"$f":"'Adjustment Entry Sheet'!H41","v":0}]
[null,null,null,null,null,null,null,{"$f":"H10*J10","v":0},null,null,{"$f":"IF('Adjustment Entry Sheet'!P57=\"ERROR\",\"ERROR\",K21-H11)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Payment Per Section","Adjustment Per Section"]
[null,null,null,"mcd/ft²/fc² @ % payment"]
[null,"Reflectivity Spec Scale →",null,{"$f":"'Adjustment Entry Sheet'!$G$44","v":"<270"},{"$f":"'Adjustment Entry Sheet'!$I$44","v":"270-299"},{"$f":"'Adjustment Entry Sheet'!$K$44","v":"300-349"},{"$f":"'Adjustment Entry Sheet'!$M$44","v":"≥350"},{"$f":"'Adjustment Entry Sheet'!O44","v":0},null,{"$f":"D17","v":"No Pay"},{"$f":"IF('Adjustment Entry Sheet'!$G$43=0,0,H11*G28*G17)","v":0},{"$f":"-D28*H11","v":0}]
[null,null,"Adjustment Percentage →",{"$f":"IF('Adjustment Entry Sheet'!G43=0,\"No Pay\", 0)","v":"No Pay"},{"$f":"'Adjustment Entry Sheet'!$I$43","v":0.8},{"$f":"'Adjustment Entry Sheet'!$K$43","v":1},{"$f":"IF('Adjustment Entry Sheet'!$M$43=0,\"No Pay\",'Adjustment Entry Sheet'!$M$43)","v":1.05},{"$f":"IF(H16=0,0,IF('Adjustment Entry Sheet'!O43=0,\"No Pay\",'Adjustment Entry Sheet'!O43))","v":0},null,{"$f":"E17","v":0.8},{"$f":"H11*E28*E17","v":0},{"$f":"-(1-E17)*E28*H11","v":0}]
[{"$f":"IF('Adjustment Entry Sheet'!B46=0,\"\",(CONCATENATE('Adjustment Entry Sheet'!B46,\" to \",'Adjustment Entry Sheet'!C46,\" \",'Adjustment Entry Sheet'!D46,\"    % in Range\")))","v":""},null,null,{"$f":"'Adjustment Entry Sheet'!$H46","v":""},{"$f":"'Adjustment Entry Sheet'!$J46","v":""},{"$f":"'Adjustment Entry Sheet'!$L46","v":""},{"$f":"'Adjustment Entry Sheet'!$N46","v":""},{"$f":"'Adjustment Entry Sheet'!$O46","v":0},{"$f":"SUM(D18:H18)","v":0},{"$f":"F17","v":1},{"$f":"H11*F28*F17","v":0},"--"]
[{"$f":"IF('Adjustment Entry Sheet'!B47=0,\"\",(CONCATENATE('Adjustment Entry Sheet'!B47,\" to \",'Adjustment Entry Sheet'!C47,\" \",'Adjustment Entry Sheet'!D47,\"    % in Range\")))","v":""},null,null,{"$f":"'Adjustment Entry Sheet'!$H47","v":""},{"$f":"'Adjustment Entry Sheet'!$J47","v":""},{"$f":"'Adjustment Entry Sheet'!$L47","v":""},{"$f":"'Adjustment Entry Sheet'!$N47","v":""},{"$f":"'Adjustment Entry Sheet'!$O47","v":0},{"$f":"SUM(D19:H19)","v":0},{"$f":"G17","v":1.05},{"$f":"H11*G28*G17","v":0},{"$f":"-(1-G17)*G28*H11","v":0}]
[{"$f":"IF('Adjustment Entry Sheet'!B48=0,\"\",(CONCATENATE('Adjustment Entry Sheet'!B48,\" to \",'Adjustment Entry Sheet'!C48,\" \",'Adjustment Entry Sheet'!D48,\"    % in Range\")))","v":""},null,null,{"$f":"'Adjustment Entry Sheet'!$H48","v":""},{"$f":"'Adjustment Entry Sheet'!$J48","v":""},{"$f":"'Adjustment Entry Sheet'!$L48","v":""},{"$f":"'Adjustment Entry Sheet'!$N48","v":""},{"$f":"'Adjustment Entry Sheet'!$O48","v":0},0,{"$f":"H17","v":0},{"$f":"IF('Adjustment Entry Sheet'!O43=0,0,H11*H28*H17)","v":0}]
[{"$f":"IF('Adjustment Entry Sheet'!B49=0,\"\",(CONCATENATE('Adjustment Entry Sheet'!B49,\" to \",'Adjustment Entry Sheet'!C49,\" \",'Adjustment Entry Sheet'!D49,\"    % in Range\")))","v":""},null,null,{"$f":"'Adjustment Entry Sheet'!$H49","v":""},{"$f":"'Adjustment Entry Sheet'!$J49","v":""},{"$f":"'Adjustment Entry Sheet'!$L49","v":""},{"$f":"'Adjustment Entry Sheet'!$N49","v":""},{"$f":"'Adjustment Entry Sheet'!$O49","v":0},0,"Totals",{"$f":"IF('Adjustment Entry Sheet'!$G$9=1,SUM(K16:K19),SUM(K16:K20))","v":0},{"$f":"SUM(L16:L20)","v":0}]
[{"$f":"IF('Adjustment Entry Sheet'!B50=0,\"\",(CONCATENATE('Adjustment Entry Sheet'!B50,\" to \",'Adjustment Entry Sheet'!C50,\" \",'Adjustment Entry Sheet'!D50,\"    % in Range\")))","v":""},null,null,{"$f":"'Adjustment Entry Sheet'!$H50","v":""},{"$f":"'Adjustment Entry Sheet'!$J50","v":""},{"$f":"'Adjustment Entry Sheet'!$L50","v":""},{"$f":"'Adjustment Entry Sheet'!$N50","v":""},{"$f":"'Adjustment Entry Sheet'!$O50","v":0},0]
[{"$f":"IF('Adjustment Entry Sheet'!B51=0,\"\",(CONCATENATE('Adjustment Entry Sheet'!B51,\" to \",'Adjustment Entry Sheet'!C51,\" \",'Adjustment Entry Sheet'!D51,\"    % in Range\")))","v":""},null,null,{"$f":"'Adjustment Entry Sheet'!$H51","v":""},{"$f":"'Adjustment Entry Sheet'!$J51","v":""},{"$f":"'Adjustment Entry Sheet'!$L51","v":""},{"$f":"'Adjustment Entry Sheet'!$N51","v":""},{"$f":"'Adjustment Entry Sheet'!$O51","v":0},0]
[{"$f":"IF('Adjustment Entry Sheet'!B52=0,\"\",(CONCATENATE('Adjustment Entry Sheet'!B52,\" to \",'Adjustment Entry Sheet'!C52,\" \",'Adjustment Entry Sheet'!D52,\"    % in Range\")))","v":""},null,null,{"$f":"'Adjustment Entry Sheet'!$H52","v":""},{"$f":"'Adjustment Entry Sheet'!$J52","v":""},{"$f":"'Adjustment Entry Sheet'!$L52","v":""},{"$f":"'Adjustment Entry Sheet'!$N52","v":""},{"$f":"'Adjustment Entry Sheet'!$O52","v":0},0]
[{"$f":"IF('Adjustment Entry Sheet'!B53=0,\"\",(CONCATENATE('Adjustment Entry Sheet'!B53,\" to \",'Adjustment Entry Sheet'!C53,\" \",'Adjustment Entry Sheet'!D53,\"    % in Range\")))","v":""},null,null,{"$f":"'Adjustment Entry Sheet'!$H53","v":""},{"$f":"'Adjustment Entry Sheet'!$J53","v":""},{"$f":"'Adjustment Entry Sheet'!$L53","v":""},{"$f":"'Adjustment Entry Sheet'!$N53","v":""},{"$f":"'Adjustment Entry Sheet'!$O53","v":0},0]
[{"$f":"IF('Adjustment Entry Sheet'!B54=0,\"\",(CONCATENATE('Adjustment Entry Sheet'!B54,\" to \",'Adjustment Entry Sheet'!C54,\" \",'Adjustment Entry Sheet'!D54,\"    % in Range\")))","v":""},null,null,{"$f":"'Adjustment Entry Sheet'!$H54","v":""},{"$f":"'Adjustment Entry Sheet'!$J54","v":""},{"$f":"'Adjustment Entry Sheet'!$L54","v":""},{"$f":"'Adjustment Entry Sheet'!$N54","v":""},{"$f":"'Adjustment Entry Sheet'!$O54","v":0},0]
[{"$f":"IF('Adjustment Entry Sheet'!B55=0,\"\",(CONCATENATE('Adjustment Entry Sheet'!B55,\" to \",'Adjustment Entry Sheet'!C55,\" \",'Adjustment Entry Sheet'!D55,\"    % in Range\")))","v":""},null,null,{"$f":"'Adjustment Entry Sheet'!$H55","v":""},{"$f":"'Adjustment Entry Sheet'!$J55","v":""},{"$f":"'Adjustment Entry Sheet'!$L55","v":""},{"$f":"'Adjustment Entry Sheet'!$N55","v":""},{"$f":"'Adjustment Entry Sheet'!$O55","v":0},0]
[null,null,"Average % of Tests",{"$f":"'Adjustment Entry Sheet'!$H56","v":0},{"$f":"'Adjustment Entry Sheet'!$J56","v":0},{"$f":"'Adjustment Entry Sheet'!$L56","v":0},{"$f":"'Adjustment Entry Sheet'!$N56","v":0},{"$f":"'Adjustment Entry Sheet'!$O56","v":0},"=",{"$f":"D28+E28+F28+G28+H28","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Line Item"]
[null,"Line #",null,"Description",null,null,null,"Paid Quantity",null,"Unit Cost","Adjustment"]
[null,{"$f":"'Adjustment Entry Sheet'!B64","v":0},null,{"$f":"'Adjustment Entry Sheet'!F60","v":"4 IN. YELLOW STANDARD WATERBORNE PAVEMENT MARKING PAINT"},null,null,null,{"$f":"'Adjustment Entry Sheet'!G64","v":0},null,{"$f":"'Adjustment Entry Sheet'!H64","v":0}]
[null,null,null,null,null,null,null,{"$f":"H34*J34","v":0},null,null,{"$f":"IF('Adjustment Entry Sheet'!P80=\"ERROR\",\"ERROR\",K45-H35)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Payment Per Section","Adjustment Per Section"]
[null,null,null,"mcd/ft²/fc² @ % payment"]
[null,"Reflectivity Spec Scale →",null,{"$f":"'Adjustment Entry Sheet'!$G67","v":"<196"},{"$f":"'Adjustment Entry Sheet'!$I67","v":"196-224"},{"$f":"'Adjustment Entry Sheet'!$K67","v":"225-274"},{"$f":"'Adjustment Entry Sheet'!$M67","v":"≥275"},{"$f":"'Adjustment Entry Sheet'!O67","v":0},null,{"$f":"D41","v":"No Pay"},{"$f":"IF('Adjustment Entry Sheet'!$G$43=0,0,H35*G52*G41)","v":0},{"$f":"-D52*H35","v":0}]
[null,null,"Adjustment Pecentage →",{"$f":"IF('Adjustment Entry Sheet'!G66=0,\"No Pay\", 0)","v":"No Pay"},{"$f":"'Adjustment Entry Sheet'!$I$66","v":0.8},{"$f":"'Adjustment Entry Sheet'!$K$66","v":1},{"$f":"IF('Adjustment Entry Sheet'!$M$66=0,\"No Pay\",'Adjustment Entry Sheet'!$M$66)","v":1.05},{"$f":"IF(H40=0,0,IF('Adjustment Entry Sheet'!O66=0,\"No Pay\",'Adjustment Entry Sheet'!O66))","v":0},null,{"$f":"E41","v":0.8},{"$f":"H35*E52*E41","v":0},{"$f":"-(1-E41)*E52*H35","v":0}]
[{"$f":"IF('Adjustment Entry Sheet'!B69=0,\"\",(CONCATENATE('Adjustment Entry Sheet'!B69,\" to \",'Adjustment Entry Sheet'!C69,\" \",'Adjustment Entry Sheet'!D69,\"    % in Range\")))","v":""},null,null,{"$f":"'Adjustment Entry Sheet'!$H69","v":""},{"$f":"'Adjustment Entry Sheet'!$J69","v":""},{"$f":"'Adjustment Entry Sheet'!$L69","v":""},{"$f":"'Adjustment Entry Sheet'!$N69","v":""},{"$f":"'Adjustment Entry Sheet'!O69","v":0},{"$f":"SUM(D42:H42)","v":0},{"$f":"F41","v":1},{"$f":"H35*F52*F41","v":0},"--"]
[{"$f":"IF('Adjustment Entry Sheet'!B70=0,\"\",(CONCATENATE('Adjustment Entry Sheet'!B70,\" to \",'Adjustment Entry Sheet'!C70,\" \",'Adjustment Entry Sheet'!D70,\"    % in Range\")))","v":""},null,null,{"$f":"'Adjustment Entry Sheet'!$H70","v":""},{"$f":"'Adjustment Entry Sheet'!$J70","v":""},{"$f":"'Adjustment Entry Sheet'!$L70","v":""},{"$f":"'Adjustment Entry Sheet'!$N70","v":""},{"$f":"'Adjustment Entry Sheet'!O70","v":0},{"$f":"SUM(D43:H43)","v":0},{"$f":"G41","v":1.05},{"$f":"H35*G52*G41","v":0},{"$f":"-(1-G41)*G52*H35","v":0}]
[{"$f":"IF('Adjustment Entry Sheet'!B71=0,\"\",(CONCATENATE('Adjustment Entry Sheet'!B71,\" to \",'Adjustment Entry Sheet'!C71,\" \",'Adjustment Entry Sheet'!D71,\"    % in Range\")))","v":""},null,null,{"$f":"'Adjustment Entry Sheet'!$H71","v":""},{"$f":"'Adjustment Entry Sheet'!$J71","v":""},{"$f":"'Adjustment Entry Sheet'!$L71","v":""},{"$f":"'Adjustment Entry Sheet'!$N71","v":""},{"$f":"'Adjustment Entry Sheet'!O71","v":0},0,{"$f":"H41","v":0},{"$f":"IF('Adjustment Entry Sheet'!O67=0,0,H35*H52*H41)","v":0}]
[{"$f":"IF('Adjustment Entry Sheet'!B72=0,\"\",(CONCATENATE('Adjustment Entry Sheet'!B72,\" to \",'Adjustment Entry Sheet'!C72,\" \",'Adjustment Entry Sheet'!D72,\"    % in Range\")))","v":""},null,null,{"$f":"'Adjustment Entry Sheet'!$H72","v":""},{"$f":"'Adjustment Entry Sheet'!$J72","v":""},{"$f":"'Adjustment Entry Sheet'!$L72","v":""},{"$f":"'Adjustment Entry Sheet'!$N72","v":""},{"$f":"'Adjustment Entry Sheet'!O72","v":0},0,"Totals",{"$f":"IF('Adjustment Entry Sheet'!$G$9=1,SUM(K40:K43),SUM(K40:K44))","v":0},{"$f":"SUM(L40:L44)","v":0}]
[{"$f":"IF('Adjustment Entry Sheet'!B73=0,\"\",(CONCATENATE('Adjustment Entry Sheet'!B73,\" to \",'Adjustment Entry Sheet'!C73,\" \",'Adjustment Entry Sheet'!D73,\"    % in Range\")))","v":""},null,null,{"$f":"'Adjustment Entry Sheet'!$H73","v":""},{"$f":"'Adjustment Entry Sheet'!$J73","v":""},{"$f":"'Adjustment Entry Sheet'!$L73","v":""},{"$f":"'Adjustment Entry Sheet'!$N73","v":""},{"$f":"'Adjustment Entry Sheet'!O73","v":0},0]
[{"$f":"IF('Adjustment Entry Sheet'!B74=0,\"\",(CONCATENATE('Adjustment Entry Sheet'!B74,\" to \",'Adjustment Entry Sheet'!C74,\" \",'Adjustment Entry Sheet'!D74,\"    % in Range\")))","v":""},null,null,{"$f":"'Adjustment Entry Sheet'!$H74","v":""},{"$f":"'Adjustment Entry Sheet'!$J74","v":""},{"$f":"'Adjustment Entry Sheet'!$L74","v":""},{"$f":"'Adjustment Entry Sheet'!$N74","v":""},{"$f":"'Adjustment Entry Sheet'!O74","v":0},0]
[{"$f":"IF('Adjustment Entry Sheet'!B75=0,\"\",(CONCATENATE('Adjustment Entry Sheet'!B75,\" to \",'Adjustment Entry Sheet'!C75,\" \",'Adjustment Entry Sheet'!D75,\"    % in Range\")))","v":""},null,null,{"$f":"'Adjustment Entry Sheet'!$H75","v":""},{"$f":"'Adjustment Entry Sheet'!$J75","v":""},{"$f":"'Adjustment Entry Sheet'!$L75","v":""},{"$f":"'Adjustment Entry Sheet'!$N75","v":""},{"$f":"'Adjustment Entry Sheet'!O75","v":0},0]
[{"$f":"IF('Adjustment Entry Sheet'!B76=0,\"\",(CONCATENATE('Adjustment Entry Sheet'!B76,\" to \",'Adjustment Entry Sheet'!C76,\" \",'Adjustment Entry Sheet'!D76,\"    % in Range\")))","v":""},null,null,{"$f":"'Adjustment Entry Sheet'!$H76","v":""},{"$f":"'Adjustment Entry Sheet'!$J76","v":""},{"$f":"'Adjustment Entry Sheet'!$L76","v":""},{"$f":"'Adjustment Entry Sheet'!$N76","v":""},{"$f":"'Adjustment Entry Sheet'!O76","v":0},0]
[{"$f":"IF('Adjustment Entry Sheet'!B77=0,\"\",(CONCATENATE('Adjustment Entry Sheet'!B77,\" to \",'Adjustment Entry Sheet'!C77,\" \",'Adjustment Entry Sheet'!D77,\"    % in Range\")))","v":""},null,null,{"$f":"'Adjustment Entry Sheet'!$H77","v":""},{"$f":"'Adjustment Entry Sheet'!$J77","v":""},{"$f":"'Adjustment Entry Sheet'!$L77","v":""},{"$f":"'Adjustment Entry Sheet'!$N77","v":""},{"$f":"'Adjustment Entry Sheet'!O77","v":0},0]
[{"$f":"IF('Adjustment Entry Sheet'!B78=0,\"\",(CONCATENATE('Adjustment Entry Sheet'!B78,\" to \",'Adjustment Entry Sheet'!C78,\" \",'Adjustment Entry Sheet'!D78,\"    % in Range\")))","v":""},null,null,{"$f":"'Adjustment Entry Sheet'!$H78","v":""},{"$f":"'Adjustment Entry Sheet'!$J78","v":""},{"$f":"'Adjustment Entry Sheet'!$L78","v":""},{"$f":"'Adjustment Entry Sheet'!$N78","v":""},{"$f":"'Adjustment Entry Sheet'!O78","v":0},0]
[null,null,"Average % of Tests",{"$f":"'Adjustment Entry Sheet'!$H79","v":0},{"$f":"'Adjustment Entry Sheet'!$J79","v":0},{"$f":"'Adjustment Entry Sheet'!$L79","v":0},{"$f":"'Adjustment Entry Sheet'!$N79","v":0},{"$f":"'Adjustment Entry Sheet'!$O79","v":0},"=",{"$f":"D52+E52+F52+G52+H52","v":0}]
[]
[null,null,{"$f":"IF('Adjustment Entry Sheet'!E9>1,\"Items on this page did not meet the minimum specification requirements for striping retro-reflectivity and received a partial pay adjustment.  A letter is required stating the justification for acceptance as part of the 'As Built' Final Plans Processing. \",\" \")","v":" "}]