{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Single Range Balance & Scale","Multiple Range Balance & Scale","Revision History","Lists"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":57,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Single Range Balance & Scale","index":0,"n_rows":90,"n_cols":12,"rows_kept":90,"cut":false,"hidden":false,"merged":[[67,7,71,7],[31,1,31,2],[31,3,31,4],[31,5,31,6],[32,1,32,2],[32,3,32,4],[32,5,32,6],[71,2,71,3],[66,4,66,5],[67,4,71,5],[67,6,71,6],[66,2,66,3],[67,2,67,3],[68,2,68,3],[69,2,69,3],[70,2,70,3],[48,3,48,4],[49,3,49,4],[50,3,50,4],[46,5,46,6],[47,5,47,6],[48,5,48,6],[49,5,49,6],[50,5,50,6],[41,2,41,3],[42,2,42,3],[43,2,43,3],[46,3,46,4],[47,3,47,4],[61,2,61,3],[57,4,57,6],[59,2,59,3],[60,2,60,3],[57,2,57,3],[58,2,58,3],[51,5,51,6],[56,2,56,3],[28,3,28,4],[29,3,29,4],[30,3,30,4],[33,3,33,4],[34,3,34,4],[28,5,28,6],[29,5,29,6],[30,5,30,6],[33,5,33,6],[34,5,34,6],[51,3,51,4],[37,2,37,3],[38,2,38,3],[40,2,40,3],[7,0,7,2],[5,0,5,2],[3,0,3,2],[2,0,2,9],[0,0,0,9],[1,0,1,9],[3,3,3,9],[5,3,5,9],[7,3,7,9],[21,3,21,9],[13,3,13,9],[11,3,11,9],[17,3,17,9],[13,0,13,2],[11,0,11,2],[9,0,9,2],[23,3,23,9],[77,3,77,9],[34,1,34,2],[33,1,33,2],[30,1,30,2],[29,1,29,2],[28,1,28,2],[23,0,23,2],[21,0,21,2],[19,0,19,2],[17,0,17,2],[9,3,9,9],[19,3,19,9],[15,3,15,9],[15,0,15,2],[81,0,81,2],[81,3,81,9],[79,3,79,9],[75,0,75,9],[79,0,79,2],[77,0,77,2],[89,3,89,9],[89,0,89,2],[87,0,87,2],[85,0,85,2],[83,0,83,2],[85,3,85,9],[87,3,87,9],[83,3,83,9]]}
["Texas Department of Transportation"]
["Single Range Balance/Scale Standardization Record"]
[{"$f":"IF(OR(ISBLANK(Serial_Number),ISBLANK(Model_Number),ISBLANK(Description),ISBLANK(Manufacturer_Name),ISBLANK(Lab_Unit),ISBLANK(Calibration_Method),ISBLANK(Completed_Date),ISBLANK(Action_Recommended),ISBLANK(Overall_Status),ISBLANK(Remarks),ISBLANK(Authority),ISBLANK(Performed_By),ISBLANK(Reviewed_By),ISBLANK(Reviewed_Date),AND(ISBLANK(NonTxDOT_Other),Authority=\"Non-TxDOT/Other\"),AND(ISBLANK(District_Lab_Area_Office),Authority=\"District Lab/Area Office\"),AND(ISBLANK(MTD_Section),Authority=\"Materials and Tests Division\")),\"***ALL BLANK FIELDS MUST BE ADDRESSED.***\",\"\")","v":"***ALL BLANK FIELDS MUST BE ADDRESSED.***"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A3=\"\",\"\",\"Instructions\")","v":"Instructions"}]
["Serial Number:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Serial_Number),\"Enter Serial Number exactly as it appears in APCM. SN must correspond to the physical piece of equipment.\",\"\")","v":"Enter Serial Number exactly as it appears in APCM. SN must correspond to the physical piece of equipment."}]
[]
["Model Number:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Model_Number),\"Enter Model Number exactly as it appears in APCM.\",\"\")","v":"Enter Model Number exactly as it appears in APCM."}]
[]
["Description:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Description),\"Enter Description exactly as it appears in APCM.\",\"\")","v":"Enter Description exactly as it appears in APCM."}]
[]
["Manufacturer Name:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Manufacturer_Name),\"Enter Manufacturer exactly as it appears in APCM. If no manufacturer exists, enter 'Not Available'.\",\"\")","v":"Enter Manufacturer exactly as it appears in APCM. If no manufacturer exists, enter 'Not Available'."}]
[]
["Lab Unit:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Lab_Unit),\"Enter the Lab Unit exactly as it appears in APCM.\",\"\")","v":"Enter the Lab Unit exactly as it appears in APCM."}]
[]
["Calibration Method:",null,null,"Tex-901-K",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Calibration_Method),\"Select the calibration/verification/standardization procedure used.\",\"\")","v":""}]
[]
["Completed Date:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Completed_Date),\"Enter the actual date the calibration/verification/standardization was performed.\",\"\")","v":"Enter the actual date the calibration/verification/standardization was performed."}]
[]
["Calibration Interval (months):",null,null,12]
[]
["Next Due Date:",null,null,{"$f":"IF(Overall_Status=\"FAIL\",\"N/A\",IF(D16=\"\",\"\",(DATE(YEAR(D16),MONTH(D16)+D18,DAY(D16)))))","v":""},null,null,null,null,null,null,null,{"$f":"IF(Next_Due_Date=\"\",\"This field will automatically populate when 'Completed Date' has been entered.\",\"\")","v":"This field will automatically populate when 'Completed Date' has been entered."}]
[]
["Overall Status:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Overall_Status),\"Select the appropriate status from the drop-down list. If equipment fails, the equipment record must be made inactive in APCM.\",\"\")","v":"Select the appropriate status from the drop-down list. If equipment fails, the equipment record must be made inactive in APCM."}]
[]
["Action Recommended:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Action_Recommended),\"Ensure that 'Overall Status' has been selected, then select the appropriate action from the drop-down list.\",\"\")","v":"Ensure that 'Overall Status' has been selected, then select the appropriate action from the drop-down list."}]
[]
["Detailed Results:"]
[]
[null,"Standard Masses:"]
[null,"Model # or Weight Range",null,"Serial Number",null,"Equipment Expiration"]
[]
[]
[]
[]
[]
[]
[]
[null,"Balance Class:"]
[null,"Class","Accuracy (g) (+0.1% Sensitivity)",null,"Readability","Capacity","Units"]
[null,null,{"$f":"IF(class=\"\",\"\",IF(class=\"Field (ASTM C138)\",\"45g(0.1lb) or 0.3%\",IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G1\",\"0.02 or 0.1 %\",IF(class=\"G2\",\"0.1 or 0.1 %\",IF(class=\"G5\",\"1.0 or 0.1 %\",IF(class=\"G20\",\"5.0 or 0.1 %\",IF(class=\"G100\",\"20.0 or 0.1 %\")))))))))","v":""},null,{"$f":"IF(class=\"\",\"\",IF(class=\"A\",0.0001,IF(class=\"B\",0.001,IF(class=\"G100\",20,IF(class=\"G5\",1,IF(class=\"G20\",5,IF(class=\"G1\",0.01,IF(class=\"G2\",0.1,IF(class=\"Field (ASTM C138)\",45)))))))))","v":""}]
[]
[null,"Step","Check",null,"Complete"]
[null,"6.1.5","Clean"]
[null,"6.1.6","Level"]
[null,"6.1.7","Exercise"]
[]
[null,"Accuracy Measurement: ",null,"Record the selected mass in nominal column."]
[null,"Mass","Nominal  Weight","As Found Indication",null,"Adjusted Indication ",null,"Deviation","Accuracy","Pass/Fail"]
[null,0,null,null,null,null,null,{"$f":"IF(AND(F48=\"\",D48=\"\"),\"\",IF(F48=\"\",ABS(D48-C48),ABS(F48-C48)))","v":""},{"$f":"IF(C48=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C48),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C48),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C48),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C48),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C48),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C48))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C48),IF(class=\"G5\",MAX(1,0.001*C48),IF(class=\"G20\",MAX(5,0.001*C48),IF(class=\"G1\",MAX(0.02,0.001*C48),IF(class=\"G2\",MAX(0.1,0.001*C48),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C48)))))))))))","v":""},{"$f":"IF(H48=\"\",\"\",IF(H48<=I48,\"Pass\",\"Fail\"))","v":""}]
[null,{"$f":"CONCATENATE(\"Approx \", 0.25*capacity, \" \",$G$39)","v":"Approx 0 "},null,null,null,null,null,{"$f":"IF(AND(F49=\"\",D49=\"\"),\"\",IF(F49=\"\",ABS(D49-C49),ABS(F49-C49)))","v":""},{"$f":"IF(C49=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C49),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C49),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C49),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C49),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C49),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C49))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C49),IF(class=\"G5\",MAX(1,0.001*C49),IF(class=\"G20\",MAX(5,0.001*C49),IF(class=\"G1\",MAX(0.02,0.001*C49),IF(class=\"G2\",MAX(0.1,0.001*C49),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C49)))))))))))","v":""},{"$f":"IF(H49=\"\",\"\",IF(H49<=I49,\"Pass\",\"Fail\"))","v":""}]
[null,{"$f":"CONCATENATE(\"Approx \", 0.5*capacity, \" \",$G$39)","v":"Approx 0 "},null,null,null,null,null,{"$f":"IF(AND(F50=\"\",D50=\"\"),\"\",IF(F50=\"\",ABS(D50-C50),ABS(F50-C50)))","v":""},{"$f":"IF(C50=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C50),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C50),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C50),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C50),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C50),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C50))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C50),IF(class=\"G5\",MAX(1,0.001*C50),IF(class=\"G20\",MAX(5,0.001*C50),IF(class=\"G1\",MAX(0.02,0.001*C50),IF(class=\"G2\",MAX(0.1,0.001*C50),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C50)))))))))))","v":""},{"$f":"IF(H50=\"\",\"\",IF(H50<=I50,\"Pass\",\"Fail\"))","v":""}]
[null,{"$f":"CONCATENATE(\"Approx \", 0.75*capacity, \" \",$G$39)","v":"Approx 0 "},null,null,null,null,null,{"$f":"IF(AND(F51=\"\",D51=\"\"),\"\",IF(F51=\"\",ABS(D51-C51),ABS(F51-C51)))","v":""},{"$f":"IF(C51=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C51),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C51),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C51),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C51),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C51),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C51))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C51),IF(class=\"G5\",MAX(1,0.001*C51),IF(class=\"G20\",MAX(5,0.001*C51),IF(class=\"G1\",MAX(0.02,0.001*C51),IF(class=\"G2\",MAX(0.1,0.001*C51),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C51)))))))))))","v":""},{"$f":"IF(H51=\"\",\"\",IF(H51<=I51,\"Pass\",\"Fail\"))","v":""}]
[null,{"$f":"CONCATENATE(\"Approx \", capacity, \" \",$G$39)","v":"Approx  "},null,null,null,null,null,{"$f":"IF(AND(F52=\"\",D52=\"\"),\"\",IF(F52=\"\",ABS(D52-C52),ABS(F52-C52)))","v":""},{"$f":"IF(C52=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C52),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C52),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C52),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C52),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C52),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C52))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C52),IF(class=\"G5\",MAX(1,0.001*C52),IF(class=\"G20\",MAX(5,0.001*C52),IF(class=\"G1\",MAX(0.02,0.001*C52),IF(class=\"G2\",MAX(0.1,0.001*C52),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C52)))))))))))","v":""},{"$f":"IF(H52=\"\",\"\",IF(H52<=I52,\"Pass\",\"Fail\"))","v":""}]
[]
[null,"Note: Set the balance to zero prior to proceeding further. "]
[]
[null,"Eccentric Measurement:",null,{"$f":"CONCATENATE(\"Select mass between \",0.3*capacity,\" to \",0.5*capacity,$G$39,\" using minimum number of weights.\")","v":"Select mass between 0 to 0 using minimum number of weights."}]
[null,"Position ","Indicated weight",null,"Deviation","Accuracy","Pass/Fail"]
[null,"1  CENTER",null,null,"Reference"]
[null,"2  FRONT LEFT",null,null,{"$f":"IF(C59=\"\",\"\",ABS(C59-$C$58))","v":""},{"$f":"IF(C59=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C58),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C58),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C58),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C58),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C58),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C58))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C58),IF(class=\"G5\",MAX(1,0.001*C58),IF(class=\"G20\",MAX(5,0.001*C58),IF(class=\"G1\",MAX(0.02,0.001*C58),IF(class=\"G2\",MAX(0.1,0.001*C58),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C58)))))))))))","v":""},{"$f":"IF(E59=\"\",\"\",IF(E59<=F59,\"Pass\",\"Fail\"))","v":""}]
[null,"3  BACK LEFT",null,null,{"$f":"IF(C60=\"\",\"\",ABS(C60-$C$58))","v":""},{"$f":"IF(C60=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C59),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C59),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C59),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C59),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C59),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C59))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C59),IF(class=\"G5\",MAX(1,0.001*C59),IF(class=\"G20\",MAX(5,0.001*C59),IF(class=\"G1\",MAX(0.02,0.001*C59),IF(class=\"G2\",MAX(0.1,0.001*C59),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C59)))))))))))","v":""},{"$f":"IF(E60=\"\",\"\",IF(E60<=F60,\"Pass\",\"Fail\"))","v":""}]
[null,"4  BACK RIGHT",null,null,{"$f":"IF(C61=\"\",\"\",ABS(C61-$C$58))","v":""},{"$f":"IF(C61=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C60),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C60),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C60),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C60),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C60),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C60))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C60),IF(class=\"G5\",MAX(1,0.001*C60),IF(class=\"G20\",MAX(5,0.001*C60),IF(class=\"G1\",MAX(0.02,0.001*C60),IF(class=\"G2\",MAX(0.1,0.001*C60),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C60)))))))))))","v":""},{"$f":"IF(E61=\"\",\"\",IF(E61<=F61,\"Pass\",\"Fail\"))","v":""}]
[null,"5  FRONT RIGHT",null,null,{"$f":"IF(C62=\"\",\"\",ABS(C62-$C$58))","v":""},{"$f":"IF(C62=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C61),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C61),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C61),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C61),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C61),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C61))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C61),IF(class=\"G5\",MAX(1,0.001*C61),IF(class=\"G20\",MAX(5,0.001*C61),IF(class=\"G1\",MAX(0.02,0.001*C61),IF(class=\"G2\",MAX(0.1,0.001*C61),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C61)))))))))))","v":""},{"$f":"IF(E62=\"\",\"\",IF(E62<=F62,\"Pass\",\"Fail\"))","v":""}]
[]
[null,"Note: Set the balance to zero prior to proceeding further. "]
[]
[null,"Repeatability Measurement:",null,{"$f":"CONCATENATE(\"Select mass between \",0.5*capacity,\" to \",capacity,$G$39,\" using minimum number of weights.\")","v":"Select mass between 0 to  using minimum number of weights."}]
[null,"Reading","Indicated weight",null,"Maximum difference between indications:",null,"Accuracy ","Pass/Fail"]
[null,1,null,null,{"$f":"IF(C68=\"\",\"\",MAX(C68:C72)-MIN(C68:C72))","v":""},null,{"$f":"IF(C68=\"\",\"\",IF($G$39=\"lb.\",E39*0.005*2,E39*2))","v":""},{"$f":"IF(C68=\"\",\"\",IF(E68<=G68,\"Pass\",\"Fail\"))","v":""}]
[null,2]
[null,3]
[null,4]
[null,5]
[]
[]
["Remarks:"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Remarks),\"Enter any comments regarding the equipment calibration/verification/standardization. \nComments must be entered for Action Recommended of 'Other' and/or Overall Status of 'Fail'. \nIf no comments are needed, enter 'None'.\",\"\")","v":"Enter any comments regarding the equipment calibration/verification/standardization. \nComments must be entered for Action Recommended of 'Other' and/or Overall Status of 'Fail'. \nIf no comments are needed, enter 'None'."}]
[]
["Authority:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Authority),\"Select the appropriate calibrating authority from the drop-down list.\",\"\")","v":"Select the appropriate calibrating authority from the drop-down list."}]
[]
["MTD Section:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(MTD_Section),\"Enter the MTD Section that performed the calibration/verification/standardization.\",\"\")","v":"Enter the MTD Section that performed the calibration/verification/standardization."}]
[]
["District Lab/Area Office:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(District_Lab_Area_Office),\"Enter the name of the district lab or area office that performed the calibration/verification/standardization.\",\"\")","v":"Enter the name of the district lab or area office that performed the calibration/verification/standardization."}]
[]
["Non-TxDOT/Other Firm:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(D84),\"Enter the name of the third-party entity that performed the calibration/verification/standardization.\",\"\")","v":"Enter the name of the third-party entity that performed the calibration/verification/standardization."}]
[]
["Performed By:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Performed_By),\"Enter the name of the individual who performed the calibration/verification/standardization.\",\"\")","v":"Enter the name of the individual who performed the calibration/verification/standardization."}]
[]
["Reviewed By:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Reviewed_By),\"Enter the name of the individual who reviewed the record for completeness and accuracy.\",\"\")","v":"Enter the name of the individual who reviewed the record for completeness and accuracy."}]
[]
["Reviewed Date:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Reviewed_Date),\"Enter the actual date the record was reviewed.\",IF(Reviewed_Date<Completed_Date,\"Reviewed Date must be after Completed Date.\",\"\"))","v":"Enter the actual date the record was reviewed."}]

{"sheet":"Multiple Range Balance & Scale","index":1,"n_rows":107,"n_cols":12,"rows_kept":107,"cut":false,"hidden":false,"merged":[[52,5,52,6],[63,3,63,4],[63,5,63,6],[64,3,64,4],[64,5,64,6],[65,3,65,4],[65,5,65,6],[106,0,106,2],[106,3,106,9],[100,0,100,2],[100,3,100,9],[102,0,102,2],[102,3,102,9],[104,0,104,2],[104,3,104,9],[92,0,92,9],[94,0,94,2],[94,3,94,9],[96,0,96,2],[96,3,96,9],[98,0,98,2],[98,3,98,9],[84,6,88,6],[84,7,88,7],[85,2,85,3],[86,2,86,3],[87,2,87,3],[88,2,88,3],[76,2,76,3],[77,2,77,3],[78,2,78,3],[83,2,83,3],[83,4,83,5],[84,2,84,3],[84,4,88,5],[60,3,60,4],[60,5,60,6],[73,2,73,3],[74,2,74,3],[74,4,74,6],[75,2,75,3],[66,3,66,4],[66,5,66,6],[67,3,67,4],[67,5,67,6],[68,3,68,4],[68,5,68,6],[57,3,57,4],[57,5,57,6],[58,3,58,4],[58,5,58,6],[59,3,59,4],[59,5,59,6],[41,2,41,3],[42,2,42,3],[43,2,43,3],[47,5,47,6],[47,3,47,4],[50,5,50,6],[50,3,50,4],[49,5,49,6],[49,3,49,4],[48,5,48,6],[48,3,48,4],[52,3,52,4],[51,5,51,6],[51,3,51,4],[56,5,56,6],[56,3,56,4],[55,5,55,6],[55,3,55,4],[34,1,34,2],[34,3,34,4],[34,5,34,6],[37,2,37,3],[38,2,38,3],[40,2,40,3],[32,1,32,2],[32,3,32,4],[32,5,32,6],[33,1,33,2],[33,3,33,4],[33,5,33,6],[30,1,30,2],[30,3,30,4],[30,5,30,6],[31,1,31,2],[31,3,31,4],[31,5,31,6],[28,1,28,2],[28,3,28,4],[28,5,28,6],[29,1,29,2],[29,3,29,4],[29,5,29,6],[19,0,19,2],[19,3,19,9],[21,0,21,2],[21,3,21,9],[23,0,23,2],[23,3,23,9],[13,0,13,2],[13,3,13,9],[15,0,15,2],[15,3,15,9],[17,0,17,2],[17,3,17,9],[7,0,7,2],[7,3,7,9],[9,0,9,2],[9,3,9,9],[11,0,11,2],[11,3,11,9],[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,2],[3,3,3,9],[5,0,5,2],[5,3,5,9]]}
["Texas Department of Transportation"]
["Multiple Range Balance/Scale Standardization Record"]
[{"$f":"IF(OR(ISBLANK(Serial_Number),ISBLANK(Model_Number),ISBLANK(Description),ISBLANK(Manufacturer_Name),ISBLANK(Lab_Unit),ISBLANK(Calibration_Method),ISBLANK(Completed_Date),ISBLANK(Action_Recommended),ISBLANK(Overall_Status),ISBLANK(Remarks),ISBLANK(Authority),ISBLANK(Performed_By),ISBLANK(Reviewed_By),ISBLANK(Reviewed_Date),AND(ISBLANK(NonTxDOT_Other),Authority=\"Non-TxDOT/Other\"),AND(ISBLANK(District_Lab_Area_Office),Authority=\"District Lab/Area Office\"),AND(ISBLANK(MTD_Section),Authority=\"Materials and Tests Division\")),\"***ALL BLANK FIELDS MUST BE ADDRESSED.***\",\"\")","v":"***ALL BLANK FIELDS MUST BE ADDRESSED.***"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A3=\"\",\"\",\"Instructions\")","v":"Instructions"}]
["Serial Number:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Serial_Number),\"Enter Serial Number exactly as it appears in APCM. SN must correspond to the physical piece of equipment.\",\"\")","v":"Enter Serial Number exactly as it appears in APCM. SN must correspond to the physical piece of equipment."}]
[]
["Model Number:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Model_Number),\"Enter Model Number exactly as it appears in APCM.\",\"\")","v":"Enter Model Number exactly as it appears in APCM."}]
[]
["Description:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Description),\"Enter Description exactly as it appears in APCM.\",\"\")","v":"Enter Description exactly as it appears in APCM."}]
[]
["Manufacturer Name:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Manufacturer_Name),\"Enter Manufacturer exactly as it appears in APCM. If no manufacturer exists, enter 'Not Available'.\",\"\")","v":"Enter Manufacturer exactly as it appears in APCM. If no manufacturer exists, enter 'Not Available'."}]
[]
["Lab Unit:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Lab_Unit),\"Enter the Lab Unit exactly as it appears in APCM.\",\"\")","v":"Enter the Lab Unit exactly as it appears in APCM."}]
[]
["Calibration Method:",null,null,"Tex-901-K",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Calibration_Method),\"Select the calibration/verification/standardization procedure used.\",\"\")","v":""}]
[]
["Completed Date:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Completed_Date),\"Enter the actual date the calibration/verification/standardization was performed.\",\"\")","v":"Enter the actual date the calibration/verification/standardization was performed."}]
[]
["Calibration Interval (months):",null,null,12]
[]
["Next Due Date:",null,null,{"$f":"IF(Overall_Status=\"FAIL\",\"N/A\",IF(D16=\"\",\"\",(DATE(YEAR(D16),MONTH(D16)+D18,DAY(D16)))))","v":""},null,null,null,null,null,null,null,{"$f":"IF(Next_Due_Date=\"\",\"This field will automatically populate when 'Completed Date' has been entered.\",\"\")","v":"This field will automatically populate when 'Completed Date' has been entered."}]
[]
["Overall Status:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Overall_Status),\"Select the appropriate status from the drop-down list. If equipment fails, the equipment record must be made inactive in APCM.\",\"\")","v":"Select the appropriate status from the drop-down list. If equipment fails, the equipment record must be made inactive in APCM."}]
[]
["Action Recommended:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Action_Recommended),\"Ensure that 'Overall Status' has been selected, then select the appropriate action from the drop-down list.\",\"\")","v":"Ensure that 'Overall Status' has been selected, then select the appropriate action from the drop-down list."}]
[]
["Detailed Results:"]
[]
[null,"Standard Masses:"]
[null,"Model # or Weight Range",null,"Serial Number",null,"Equipment Expiration"]
[]
[]
[]
[]
[]
[]
[]
[null,"Balance Class:"]
[null,"Class","Accuracy (g) (+0.1% Sensitivity)",null,"Readability","Capacity","Units"]
[null,"Field (ASTM C138)",{"$f":"IF(class=\"\",\"\",IF(class=\"Field (ASTM C138)\",\"45g(0.1lb) or 0.3%\",IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G1\",\"0.02 or 0.1 %\",IF(class=\"G2\",\"0.1 or 0.1 %\",IF(class=\"G5\",\"1.0 or 0.1 %\",IF(class=\"G20\",\"5.0 or 0.1 %\",IF(class=\"G100\",\"20.0 or 0.1 %\")))))))))","v":"45g(0.1lb) or 0.3%"},null,{"$f":"IF(class=\"\",\"\",IF(class=\"A\",0.0001,IF(class=\"B\",0.001,IF(class=\"G100\",20,IF(class=\"G5\",1,IF(class=\"G20\",5,IF(class=\"G1\",0.01,IF(class=\"G2\",0.1,IF(class=\"Field (ASTM C138)\",45)))))))))","v":45}]
[]
[null,"Step","Check",null,"Complete"]
[null,"6.1.5","Clean"]
[null,"6.1.6","Level"]
[null,"6.1.7","Exercise"]
[]
[null,"Accuracy Measurement for Multiple Ranges: ",null,null,"Record the selected mass in nominal column."]
[null,{"$f":"CONCATENATE(\"Range capacity\",IF(ISBLANK(G39),\"\",CONCATENATE(\" (\",G39,\")\")),\":\")","v":"Range capacity:"}]
[null,"Mass","Nominal  Weight","As Found Indication",null,"Adjusted Indication ",null,"Deviation","Accuracy","Pass/Fail"]
[null,0,null,null,null,null,null,{"$f":"IF(AND(F49=\"\",D49=\"\"),\"\",IF(F49=\"\",ABS(D49-C49),ABS(F49-C49)))","v":""},{"$f":"IF(C49=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C49),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C49),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C49),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C49),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C49),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C49))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C49),IF(class=\"G5\",MAX(1,0.001*C49),IF(class=\"G20\",MAX(5,0.001*C49),IF(class=\"G1\",MAX(0.02,0.001*C49),IF(class=\"G2\",MAX(0.1,0.001*C49),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C49)))))))))))","v":""},{"$f":"IF(H49=\"\",\"\",IF(H49<=I49,\"Pass\",\"Fail\"))","v":""}]
[null,{"$f":"CONCATENATE(\"Approx \", 0.25*capacity, \" \",$G$39)","v":"Approx 0 "},null,null,null,null,null,{"$f":"IF(AND(F50=\"\",D50=\"\"),\"\",IF(F50=\"\",ABS(D50-C50),ABS(F50-C50)))","v":""},{"$f":"IF(C50=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C50),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C50),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C50),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C50),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C50),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C50))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C50),IF(class=\"G5\",MAX(1,0.001*C50),IF(class=\"G20\",MAX(5,0.001*C50),IF(class=\"G1\",MAX(0.02,0.001*C50),IF(class=\"G2\",MAX(0.1,0.001*C50),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C50)))))))))))","v":""},{"$f":"IF(H50=\"\",\"\",IF(H50<=I50,\"Pass\",\"Fail\"))","v":""}]
[null,{"$f":"CONCATENATE(\"Approx \", 0.5*capacity, \" \",$G$39)","v":"Approx 0 "},null,null,null,null,null,{"$f":"IF(AND(F51=\"\",D51=\"\"),\"\",IF(F51=\"\",ABS(D51-C51),ABS(F51-C51)))","v":""},{"$f":"IF(C51=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C51),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C51),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C51),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C51),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C51),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C51))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C51),IF(class=\"G5\",MAX(1,0.001*C51),IF(class=\"G20\",MAX(5,0.001*C51),IF(class=\"G1\",MAX(0.02,0.001*C51),IF(class=\"G2\",MAX(0.1,0.001*C51),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C51)))))))))))","v":""},{"$f":"IF(H51=\"\",\"\",IF(H51<=I51,\"Pass\",\"Fail\"))","v":""}]
[null,{"$f":"CONCATENATE(\"Approx \", 0.75*capacity, \" \",$G$39)","v":"Approx 0 "},null,null,null,null,null,{"$f":"IF(AND(F52=\"\",D52=\"\"),\"\",IF(F52=\"\",ABS(D52-C52),ABS(F52-C52)))","v":""},{"$f":"IF(C52=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C52),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C52),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C52),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C52),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C52),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C52))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C52),IF(class=\"G5\",MAX(1,0.001*C52),IF(class=\"G20\",MAX(5,0.001*C52),IF(class=\"G1\",MAX(0.02,0.001*C52),IF(class=\"G2\",MAX(0.1,0.001*C52),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C52)))))))))))","v":""},{"$f":"IF(H52=\"\",\"\",IF(H52<=I52,\"Pass\",\"Fail\"))","v":""}]
[null,{"$f":"CONCATENATE(\"Approx \", capacity, \" \",$G$39)","v":"Approx  "},null,null,null,null,null,{"$f":"IF(AND(F53=\"\",D53=\"\"),\"\",IF(F53=\"\",ABS(D53-C53),ABS(F53-C53)))","v":""},{"$f":"IF(C53=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C53),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C53),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C53),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C53),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C53),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C53))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C53),IF(class=\"G5\",MAX(1,0.001*C53),IF(class=\"G20\",MAX(5,0.001*C53),IF(class=\"G1\",MAX(0.02,0.001*C53),IF(class=\"G2\",MAX(0.1,0.001*C53),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C53)))))))))))","v":""},{"$f":"IF(H53=\"\",\"\",IF(H53<=I53,\"Pass\",\"Fail\"))","v":""}]
[]
[null,{"$f":"CONCATENATE(\"Range capacity\",IF(ISBLANK(G47),\"\",CONCATENATE(\" (\",G47,\")\")),\":\")","v":"Range capacity:"}]
[null,"Mass","Nominal  Weight","As Found Indication",null,"Adjusted Indication ",null,"Deviation","Accuracy","Pass/Fail"]
[null,0,null,null,null,null,null,{"$f":"IF(AND(F57=\"\",D57=\"\"),\"\",IF(F57=\"\",ABS(D57-C57),ABS(F57-C57)))","v":""},{"$f":"IF(C57=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C57),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C57),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C57),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C57),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C57),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C57))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C57),IF(class=\"G5\",MAX(1,0.001*C57),IF(class=\"G20\",MAX(5,0.001*C57),IF(class=\"G1\",MAX(0.02,0.001*C57),IF(class=\"G2\",MAX(0.1,0.001*C57),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C57)))))))))))","v":""},{"$f":"IF(H57=\"\",\"\",IF(H57<=I57,\"Pass\",\"Fail\"))","v":""}]
[null,{"$f":"CONCATENATE(\"Approx \", 0.25*capacity, \" \",$G$39)","v":"Approx 0 "},null,null,null,null,null,{"$f":"IF(AND(F58=\"\",D58=\"\"),\"\",IF(F58=\"\",ABS(D58-C58),ABS(F58-C58)))","v":""},{"$f":"IF(C58=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C58),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C58),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C58),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C58),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C58),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C58))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C58),IF(class=\"G5\",MAX(1,0.001*C58),IF(class=\"G20\",MAX(5,0.001*C58),IF(class=\"G1\",MAX(0.02,0.001*C58),IF(class=\"G2\",MAX(0.1,0.001*C58),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C58)))))))))))","v":""},{"$f":"IF(H58=\"\",\"\",IF(H58<=I58,\"Pass\",\"Fail\"))","v":""}]
[null,{"$f":"CONCATENATE(\"Approx \", 0.5*capacity, \" \",$G$39)","v":"Approx 0 "},null,null,null,null,null,{"$f":"IF(AND(F59=\"\",D59=\"\"),\"\",IF(F59=\"\",ABS(D59-C59),ABS(F59-C59)))","v":""},{"$f":"IF(C59=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C59),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C59),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C59),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C59),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C59),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C59))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C59),IF(class=\"G5\",MAX(1,0.001*C59),IF(class=\"G20\",MAX(5,0.001*C59),IF(class=\"G1\",MAX(0.02,0.001*C59),IF(class=\"G2\",MAX(0.1,0.001*C59),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C59)))))))))))","v":""},{"$f":"IF(H59=\"\",\"\",IF(H59<=I59,\"Pass\",\"Fail\"))","v":""}]
[null,{"$f":"CONCATENATE(\"Approx \", 0.75*capacity, \" \",$G$39)","v":"Approx 0 "},null,null,null,null,null,{"$f":"IF(AND(F60=\"\",D60=\"\"),\"\",IF(F60=\"\",ABS(D60-C60),ABS(F60-C60)))","v":""},{"$f":"IF(C60=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C60),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C60),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C60),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C60),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C60),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C60))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C60),IF(class=\"G5\",MAX(1,0.001*C60),IF(class=\"G20\",MAX(5,0.001*C60),IF(class=\"G1\",MAX(0.02,0.001*C60),IF(class=\"G2\",MAX(0.1,0.001*C60),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C60)))))))))))","v":""},{"$f":"IF(H60=\"\",\"\",IF(H60<=I60,\"Pass\",\"Fail\"))","v":""}]
[null,{"$f":"CONCATENATE(\"Approx \", capacity, \" \",$G$39)","v":"Approx  "},null,null,null,null,null,{"$f":"IF(AND(F61=\"\",D61=\"\"),\"\",IF(F61=\"\",ABS(D61-C61),ABS(F61-C61)))","v":""},{"$f":"IF(C61=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C61),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C61),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C61),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C61),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C61),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C61))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C61),IF(class=\"G5\",MAX(1,0.001*C61),IF(class=\"G20\",MAX(5,0.001*C61),IF(class=\"G1\",MAX(0.02,0.001*C61),IF(class=\"G2\",MAX(0.1,0.001*C61),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C61)))))))))))","v":""},{"$f":"IF(H61=\"\",\"\",IF(H61<=I61,\"Pass\",\"Fail\"))","v":""}]
[]
[null,{"$f":"CONCATENATE(\"Range capacity\",IF(ISBLANK(G55),\"\",CONCATENATE(\" (\",G55,\")\")),\":\")","v":"Range capacity:"}]
[null,"Mass","Nominal  Weight","As Found Indication",null,"Adjusted Indication ",null,"Deviation","Accuracy","Pass/Fail"]
[null,0,null,null,null,null,null,{"$f":"IF(AND(F65=\"\",D65=\"\"),\"\",IF(F65=\"\",ABS(D65-C65),ABS(F65-C65)))","v":""},{"$f":"IF(C65=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C65),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C65),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C65),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C65),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C65),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C65))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C65),IF(class=\"G5\",MAX(1,0.001*C65),IF(class=\"G20\",MAX(5,0.001*C65),IF(class=\"G1\",MAX(0.02,0.001*C65),IF(class=\"G2\",MAX(0.1,0.001*C65),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C65)))))))))))","v":""},{"$f":"IF(H65=\"\",\"\",IF(H65<=I65,\"Pass\",\"Fail\"))","v":""}]
[null,{"$f":"CONCATENATE(\"Approx \", 0.25*capacity, \" \",$G$39)","v":"Approx 0 "},null,null,null,null,null,{"$f":"IF(AND(F66=\"\",D66=\"\"),\"\",IF(F66=\"\",ABS(D66-C66),ABS(F66-C66)))","v":""},{"$f":"IF(C66=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C66),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C66),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C66),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C66),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C66),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C66))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C66),IF(class=\"G5\",MAX(1,0.001*C66),IF(class=\"G20\",MAX(5,0.001*C66),IF(class=\"G1\",MAX(0.02,0.001*C66),IF(class=\"G2\",MAX(0.1,0.001*C66),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C66)))))))))))","v":""},{"$f":"IF(H66=\"\",\"\",IF(H66<=I66,\"Pass\",\"Fail\"))","v":""}]
[null,{"$f":"CONCATENATE(\"Approx \", 0.5*capacity, \" \",$G$39)","v":"Approx 0 "},null,null,null,null,null,{"$f":"IF(AND(F67=\"\",D67=\"\"),\"\",IF(F67=\"\",ABS(D67-C67),ABS(F67-C67)))","v":""},{"$f":"IF(C67=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C67),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C67),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C67),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C67),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C67),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C67))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C67),IF(class=\"G5\",MAX(1,0.001*C67),IF(class=\"G20\",MAX(5,0.001*C67),IF(class=\"G1\",MAX(0.02,0.001*C67),IF(class=\"G2\",MAX(0.1,0.001*C67),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C67)))))))))))","v":""},{"$f":"IF(H67=\"\",\"\",IF(H67<=I67,\"Pass\",\"Fail\"))","v":""}]
[null,{"$f":"CONCATENATE(\"Approx \", 0.75*capacity, \" \",$G$39)","v":"Approx 0 "},null,null,null,null,null,{"$f":"IF(AND(F68=\"\",D68=\"\"),\"\",IF(F68=\"\",ABS(D68-C68),ABS(F68-C68)))","v":""},{"$f":"IF(C68=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C68),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C68),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C68),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C68),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C68),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C68))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C68),IF(class=\"G5\",MAX(1,0.001*C68),IF(class=\"G20\",MAX(5,0.001*C68),IF(class=\"G1\",MAX(0.02,0.001*C68),IF(class=\"G2\",MAX(0.1,0.001*C68),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C68)))))))))))","v":""},{"$f":"IF(H68=\"\",\"\",IF(H68<=I68,\"Pass\",\"Fail\"))","v":""}]
[null,{"$f":"CONCATENATE(\"Approx \", capacity, \" \",$G$39)","v":"Approx  "},null,null,null,null,null,{"$f":"IF(AND(F69=\"\",D69=\"\"),\"\",IF(F69=\"\",ABS(D69-C69),ABS(F69-C69)))","v":""},{"$f":"IF(C69=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C69),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C69),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C69),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C69),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C69),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C69))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C69),IF(class=\"G5\",MAX(1,0.001*C69),IF(class=\"G20\",MAX(5,0.001*C69),IF(class=\"G1\",MAX(0.02,0.001*C69),IF(class=\"G2\",MAX(0.1,0.001*C69),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C69)))))))))))","v":""},{"$f":"IF(H69=\"\",\"\",IF(H69<=I69,\"Pass\",\"Fail\"))","v":""}]
[]
[null,"Note: Set the balance to zero prior to proceeding further. "]
[]
[null,"Eccentric Measurement:",null,{"$f":"CONCATENATE(\"Select mass between \",0.3*capacity,\" to \",0.5*capacity,$G$39,\" using minimum number of weights.\")","v":"Select mass between 0 to 0 using minimum number of weights."}]
[null,"Position ","Indicated weight",null,"Deviation","Accuracy","Pass/Fail"]
[null,"1  CENTER",null,null,"Reference"]
[null,"2  FRONT LEFT",null,null,{"$f":"IF(C76=\"\",\"\",ABS(C76-$C$75))","v":""},{"$f":"IF(C76=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C75),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C75),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C75),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C75),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C75),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C75))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C75),IF(class=\"G5\",MAX(1,0.001*C75),IF(class=\"G20\",MAX(5,0.001*C75),IF(class=\"G1\",MAX(0.02,0.001*C75),IF(class=\"G2\",MAX(0.1,0.001*C75),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C75)))))))))))","v":""},{"$f":"IF(E76=\"\",\"\",IF(E76<=F76,\"Pass\",\"Fail\"))","v":""}]
[null,"3  BACK LEFT",null,null,{"$f":"IF(C77=\"\",\"\",ABS(C77-$C$75))","v":""},{"$f":"IF(C77=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C76),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C76),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C76),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C76),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C76),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C76))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C76),IF(class=\"G5\",MAX(1,0.001*C76),IF(class=\"G20\",MAX(5,0.001*C76),IF(class=\"G1\",MAX(0.02,0.001*C76),IF(class=\"G2\",MAX(0.1,0.001*C76),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C76)))))))))))","v":""},{"$f":"IF(E77=\"\",\"\",IF(E77<=F77,\"Pass\",\"Fail\"))","v":""}]
[null,"4  BACK RIGHT",null,null,{"$f":"IF(C78=\"\",\"\",ABS(C78-$C$75))","v":""},{"$f":"IF(C78=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C77),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C77),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C77),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C77),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C77),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C77))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C77),IF(class=\"G5\",MAX(1,0.001*C77),IF(class=\"G20\",MAX(5,0.001*C77),IF(class=\"G1\",MAX(0.02,0.001*C77),IF(class=\"G2\",MAX(0.1,0.001*C77),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C77)))))))))))","v":""},{"$f":"IF(E78=\"\",\"\",IF(E78<=F78,\"Pass\",\"Fail\"))","v":""}]
[null,"5  FRONT RIGHT",null,null,{"$f":"IF(C79=\"\",\"\",ABS(C79-$C$75))","v":""},{"$f":"IF(C79=\"\",\"\",IF($G$39=\"lb.\",IF(class=\"A\",0.0002*0.00220462262185,IF(class=\"B\",0.002*0.00220462262185,IF(class=\"G100\",MAX(20*0.00220462262185,0.001*C78),IF(class=\"G5\",MAX(1*0.00220462262185,0.001*C78),IF(class=\"G20\",MAX(5*0.00220462262185,0.001*C78),IF(class=\"G1\",MAX(0.02*0.00220462262185,0.001*C78),IF(class=\"G2\",MAX(0.1*0.00220462262185,0.001*C78),IF(class=\"Field (ASTM C138)\",MAX(45*0.00220462262185,0.003*C78))))))))),IF(class=\"A\",0.0002,IF(class=\"B\",0.002,IF(class=\"G100\",MAX(20,0.001*C78),IF(class=\"G5\",MAX(1,0.001*C78),IF(class=\"G20\",MAX(5,0.001*C78),IF(class=\"G1\",MAX(0.02,0.001*C78),IF(class=\"G2\",MAX(0.1,0.001*C78),IF(class=\"Field (ASTM C138)\",MAX(45,0.003*C78)))))))))))","v":""},{"$f":"IF(E79=\"\",\"\",IF(E79<=F79,\"Pass\",\"Fail\"))","v":""}]
[]
[null,"Note: Set the balance to zero prior to proceeding further. "]
[]
[null,"Repeatability Measurement:",null,{"$f":"CONCATENATE(\"Select mass between \",0.5*capacity,\" to \",capacity,$G$39,\" using minimum number of weights.\")","v":"Select mass between 0 to  using minimum number of weights."}]
[null,"Reading","Indicated weight",null,"Maximum difference between indications:",null,"Accuracy ","Pass/Fail"]
[null,1,null,null,{"$f":"IF(C85=\"\",\"\",MAX(C85:D89)-MIN(C85:D89))","v":""},null,{"$f":"IF(C85=\"\",\"\",IF($G$39=\"lb.\",E39*0.005*2,E39*2))","v":""},{"$f":"IF(C85=\"\",\"\",IF(E85<=G85,\"Pass\",\"Fail\"))","v":""}]
[null,2]
[null,3]
[null,4]
[null,5]
[]
[]
["Remarks:"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Remarks),\"Enter any comments regarding the equipment calibration/verification/standardization. \nComments must be entered for Action Recommended of 'Other' and/or Overall Status of 'Fail'. \nIf no comments are needed, enter 'None'.\",\"\")","v":"Enter any comments regarding the equipment calibration/verification/standardization. \nComments must be entered for Action Recommended of 'Other' and/or Overall Status of 'Fail'. \nIf no comments are needed, enter 'None'."}]
[]
["Authority:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Authority),\"Select the appropriate calibrating authority from the drop-down list.\",\"\")","v":"Select the appropriate calibrating authority from the drop-down list."}]
[]
["MTD Section:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(MTD_Section),\"Enter the MTD Section that performed the calibration/verification/standardization.\",\"\")","v":"Enter the MTD Section that performed the calibration/verification/standardization."}]
[]
["District Lab/Area Office:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(District_Lab_Area_Office),\"Enter the name of the district lab or area office that performed the calibration/verification/standardization.\",\"\")","v":"Enter the name of the district lab or area office that performed the calibration/verification/standardization."}]
[]
["Non-TxDOT/Other Firm:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(D101),\"Enter the name of the third-party entity that performed the calibration/verification/standardization.\",\"\")","v":"Enter the name of the third-party entity that performed the calibration/verification/standardization."}]
[]
["Performed By:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Performed_By),\"Enter the name of the individual who performed the calibration/verification/standardization.\",\"\")","v":"Enter the name of the individual who performed the calibration/verification/standardization."}]
[]
["Reviewed By:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Reviewed_By),\"Enter the name of the individual who reviewed the record for completeness and accuracy.\",\"\")","v":"Enter the name of the individual who reviewed the record for completeness and accuracy."}]
[]
["Reviewed Date:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Reviewed_Date),\"Enter the actual date the record was reviewed.\",IF(Reviewed_Date<Completed_Date,\"Reviewed Date must be after Completed Date.\",\"\"))","v":"Enter the actual date the record was reviewed."}]

{"sheet":"Revision History","index":2,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Revision Date","Revision Description","Revised By"]
["2023-02-04","Updated to new template format.","A. Melton"]

{"sheet":"Lists","index":3,"n_rows":64,"n_cols":14,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
["Status","Pass","Fail","Authority","MTD Sections","Calibration_Method",null,"Date Range",null,"Class",null,"Units",null,"Complete"]
["Pass","None","Repair","Materials and Tests Division","Rigid Pavements","Tex-198-E",null,"2000-01-01",null,"A",null,"g"]
["Fail","Other (See Remarks)","Replace","District Lab/Area Office","Flexible Pavements","Tex-237-F",null,"2100-01-01",null,"B",null,"lb."]
[null,null,"Other (See Remarks)","Non-TxDOT/Other","Soils & Aggregates","Tex-498-A",null,null,null,"G1"]
[null,null,null,null,"Coatings, Calibration, & Traffic Materials","Tex-900-K",null,null,null,"G2"]
[null,null,null,null,null,"Tex-901-K",null,null,null,"G5"]
[null,null,null,null,null,"Tex-902-K",null,null,null,"G20"]
[null,null,null,null,null,"Tex-903-K",null,null,null,"G100"]
[null,null,null,null,null,"Tex-905-K",null,null,null,"Field (ASTM C138)"]
[null,null,null,null,null,"Tex-907-K"]
[null,null,null,null,null,"Tex-909-K"]
[null,null,null,null,null,"Tex-911-K"]
[null,null,null,null,null,"Tex-913-K"]
[null,null,null,null,null,"Tex-914-K"]
[null,null,null,null,null,"Tex-916-K"]
[null,null,null,null,null,"Tex-920-K"]
[null,null,null,null,null,"Tex-921-K"]
[null,null,null,null,null,"Tex-922-K"]
[null,null,null,null,null,"Tex-923-K"]
[null,null,null,null,null,"Tex-924-K"]
[null,null,null,null,null,"Tex-925-K"]
[null,null,null,null,null,"Tex-926-K"]
[null,null,null,null,null,"Tex-927-K"]
[null,null,null,null,null,"Tex-930-K"]
[null,null,null,null,null,"AASHTO R28"]
[null,null,null,null,null,"AASHTO T202"]
[null,null,null,null,null,"AASHTO T228"]
[null,null,null,null,null,"AASHTO T240"]
[null,null,null,null,null,"AASHTO T313"]
[null,null,null,null,null,"AASHTO T315"]
[null,null,null,null,null,"AASHTO T316"]
[null,null,null,null,null,"AASHTO T48"]
[null,null,null,null,null,"AASHTO T49"]
[null,null,null,null,null,"AASHTO T50"]
[null,null,null,null,null,"AASHTO T51"]
[null,null,null,null,null,"AASHTO T53"]
[null,null,null,null,null,"AASHTO T59"]
[null,null,null,null,null,"ASME B40"]
[null,null,null,null,null,"ASME B89"]
[null,null,null,null,null,"ASTM C109"]
[null,null,null,null,null,"ASTM C1231"]
[null,null,null,null,null,"ASTM C143"]
[null,null,null,null,null,"ASTM C151"]
[null,null,null,null,null,"ASTM C1702"]
[null,null,null,null,null,"ASTM C173"]
[null,null,null,null,null,"ASTM C174"]
[null,null,null,null,null,"ASTM C192"]
[null,null,null,null,null,"ASTM C204"]
[null,null,null,null,null,"ASTM C231"]
[null,null,null,null,null,"ASTM C430"]
[null,null,null,null,null,"ASTM C511"]
[null,null,null,null,null,"ASTM C604"]
[null,null,null,null,null,"ASTM C617"]
[null,null,null,null,null,"ASTM C78"]
[null,null,null,null,null,"ASTM D4237"]
[null,null,null,null,null,"ASTM C6084"]
[null,null,null,null,null,"ASTM E10"]
[null,null,null,null,null,"ASTM E18"]
[null,null,null,null,null,"ASTM E2309"]
[null,null,null,null,null,"ASTM E4"]
[null,null,null,null,null,"ASTM E83"]
[null,null,null,null,null,"EXT - External Calibration"]
[null,null,null,null,null,"NA - Not Applicable"]
[null,null,null,null,null,"SS - Supplier's Standard"]