{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["CAL WORKSHEET","REVIEW CHECKLIST","CAL CERTIFICATE","REFERENCE SOLUTIONS","EXTRA"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":1,"comments":3,"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":"CAL WORKSHEET","index":0,"n_rows":70,"n_cols":11,"rows_kept":70,"cut":false,"hidden":false,"merged":[[53,4,53,10],[49,0,49,1],[68,0,68,3],[70,0,71,10],[66,0,67,10],[61,0,61,3],[63,0,63,3],[65,0,65,10],[59,0,59,3],[52,0,54,3],[52,4,52,10],[54,4,54,10],[56,0,57,3],[56,4,56,11],[57,4,57,11],[27,7,27,9],[28,7,28,9],[23,7,26,11],[27,10,27,11],[17,2,17,9],[19,9,19,10],[20,7,20,9],[0,1,0,11],[13,1,13,9],[7,1,7,9],[19,5,19,8],[1,1,1,11],[3,8,3,9],[3,0,3,3],[19,0,19,2],[19,3,19,4],[9,1,9,9],[11,1,11,9],[15,1,15,10]]}
[null,"                    TEXAS DEPARTMENT OF PUBLIC SAFETY\n                     OFFICE OF THE SCIENTIFIC DIRECTOR\n\n                          CALIBRATION ANALYST WORKSHEET\n                                      OSD-CAL-04 Rev. 12 (10/2023) p.1 Issued by: Scientific Director"]
[null,"                    TEXAS DEPARTMENT OF PUBLIC SAFETY\n                      OFFICE OF THE SCIENTIFIC DIRECTOR\n\n         AMENDED CALIBRATION ANALYST WORKSHEET\n                                     OSD-CAL-08  Rev. 12 (10/2023) p.1 Issued by: Scientific Director"]
[]
["This amends and replaces the Calibration Certificate issued on:"]
[]
["Instrument Calibrated:",null,null,"Serial Number:",null,null,null,"Date Received in Calibration Lab:"]
[]
["Laboratory Name:"]
[]
["Laboratory Address:"]
[]
["Customer Name:"]
[]
["Customer Address:"]
[]
["Calibration Procedure Used:","OSD-CAL-01 (current version)"]
[]
["Instrument Condition:","NO","   The instrument is in proper working condition and is suitable for calibration."]
[]
["Serial number of NIST-traceable thermometer:",null,null,null,null,"Thermometer calibration expiration date:"]
[]
["NOMINAL VALUE",0,0.04,0.08,0.15,0.4]
["SIMULATOR SN"]
["SIM OPERATING PROPERLY","NO","NO","NO","NO","NO"]
["REFERENCE SOLUTION LOT","NONE","NONE","NONE","NONE","NONE"]
["VAPOR CONCENTRATION",0,0,0,0,0]
["COMB STD UNCERTAINTY (SDComb)",0,0,0,0,0]
[1,null,null,null,null,null,null,"Calibration Analyst:",null,null,""]
[2,null,null,null,null,null,null,"Date Analysis Completed:"]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
["MEAN (MeanIntox)","-",{"$f":"ROUND(AVERAGE(C28:C42),4)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE(D28:D42),4)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE(E28:E42),4)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE(F28:F42),4)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF(COUNTIF(B28:B42,\"<>0.000\")>0,\"ERROR\",\"\")","v":"ERROR"},{"$f":"IF(ABS(C43-C26)>0.003,\"ERROR\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(ABS(D43-D26)>0.003,\"ERROR\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF((ABS(E43-E26)<=E26*0.03),\"\",\"ERROR\")","v":{"$error":"#DIV/0!"}},{"$f":"IF((ABS(F43-F26)<=F26*0.03),\"\",\"ERROR\")","v":{"$error":"#DIV/0!"}}]
["STANDARD DEVIATION (SDIntox)","-",{"$f":"ROUND(_xlfn.STDEV.S(C28:C42),5)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(_xlfn.STDEV.S(D28:D42),5)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(_xlfn.STDEV.S(E28:E42),5)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(_xlfn.STDEV.S(F28:F42),5)","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"IF(C45<0.001,\"\",\"ERROR\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(D45<0.001,\"\",\"ERROR\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(E45<0.001,\"\",\"ERROR\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(F45<0.002,\"\",\"ERROR\")","v":{"$error":"#DIV/0!"}}]
[]
["ROUNDED MEAN","-",{"$f":"ROUND(C43, 3)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(D43, 3)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(E43, 3)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(F43, 3)","v":{"$error":"#DIV/0!"}}]
["*EXPANDED UNCERTAINTY (UIntox)","-",{"$f":"ROUND((SQRT((POWER((_xlfn.STDEV.S(C28:C42)),2))+(POWER(C27,2)))*2.977),3)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND((SQRT((POWER((_xlfn.STDEV.S(D28:D42)),2))+(POWER(D27,2)))*2.977),3)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND((SQRT((POWER((_xlfn.STDEV.S(E28:E42)),2))+(POWER(E27,2)))*2.977),3)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND((SQRT((POWER((_xlfn.STDEV.S(F28:F42)),2))+(POWER(F27,2)))*2.977),3)","v":{"$error":"#DIV/0!"}}]
["All results are reported in g/210 L"]
["*Rounded Mean ± Expanded Uncertainty at the 99% level (k=2.977)"]
[]
["                                                 Reason for instrument calibration:    ",null,null,null,"The instrument is to be placed into evidential service for the first time"]
[null,null,null,null,"The calibration of the instrument has been adjusted"]
[null,null,null,null,"As determined by the technical supervisor"]
[]
["                                                           Repairs/Adjustments:      ",null,null,null,"No repairs or calibration adjustments were made during the calibration; therefore, the results in the table are both the \"As Found\" and \"As Left\" results"]
[null,null,null,null,"Repairs or calibration adjustments were made to the instrument during the calibration; therefore, the calibration procedure was stopped"]
[]
["Changes were made to the worksheet during the tech/admin review:"]
[null,null,null,null," "]
["Laboratory environmental conditions suitable for calibration:",null,null,null,"NO"]
[]
["Calibration procedure was properly completed:",null,null,null,"NO"]
[]
["Reason(s) the calibration procedure was not properly completed:"]
[]
[]
[]
["Describe the change(s) made to the worksheet during the tech/admin review and the date they were made:"]

{"sheet":"REVIEW CHECKLIST","index":1,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":true,"merged":[[0,1,0,8],[4,0,4,1],[4,2,4,3],[7,1,7,4],[9,1,9,4],[1,1,1,9],[32,0,32,2],[20,1,20,8],[23,1,23,8],[25,1,25,8],[11,1,11,6],[13,1,13,10],[15,1,15,8],[16,1,16,2],[18,1,18,8],[17,1,17,10],[19,1,19,10],[22,1,22,10],[24,1,24,10],[27,0,30,6],[31,0,31,2],[31,3,31,6]]}
[null,"               TEXAS DEPARTMENT OF PUBLIC SAFETY\n              OFFICE OF THE SCIENTIFIC DIRECTOR\n\n             TECHNICAL AND ADMINISTRATIVE REVIEW CHECKLIST\n                OSD-CAL-05 Rev. 12 (10/2023) p.1 Issued by: Scientific Director"]
[null,"TEXAS DEPARTMENT OF PUBLIC SAFETY\n OFFICE OF THE SCIENTIFIC DIRECTOR\n\n AMENDED TECHNICAL AND ADMINISTRATIVE REVIEW CHECKLIST\nOSD-CAL-09 Rev. 12 (10/2023) p.1 Issued by: Scientific Director"]
[]
[]
["Instrument Serial #:"]
[]
[]
["NO","Correct form and version used"]
[]
["NO","All required information entered"]
[]
["NO","Data entered corresponds to ACA printouts"]
[]
["NO","All ACA printouts signed and/or initialed by the calibration analyst"]
[]
["NO","Calibration Notes labels (OSD-CAL-03) and solution labels affixed to ACA printouts"]
[]
["NO","   Information entered on the Calibration Analyst Worksheet matches information on the"]
[null,"   labels affixed to the ACA printouts"]
[]
[]
[]
["NO","   NIST-traceable thermometer serial number and expiration date verified against the"]
[null,"   thermometer calibration certificate"]
["NO","   COBRA review completed"]
[]
[]
[]
[]
[]
[]
["Reviewing Analyst:"]
["Date review completed:"]

{"sheet":"CAL CERTIFICATE","index":2,"n_rows":59,"n_cols":8,"rows_kept":59,"cut":false,"hidden":true,"merged":[[59,2,59,7],[39,7,42,11],[35,10,35,11],[53,4,53,11],[57,0,57,10],[55,0,55,1],[58,0,58,10],[56,0,56,10],[3,0,3,3],[53,1,53,3],[13,1,13,9],[17,2,17,9],[19,5,19,8],[51,4,51,11],[31,7,34,11],[51,1,51,3],[0,1,0,11],[9,1,9,9],[49,0,49,1],[7,1,7,9],[44,7,44,9],[15,1,15,10],[36,7,36,9],[35,7,35,9],[19,3,19,4],[1,1,1,11],[3,8,3,9],[19,9,19,10],[11,1,11,9],[19,0,19,2],[43,10,43,11],[43,7,43,9]]}
[null,"                                   TEXAS DEPARTMENT OF PUBLIC SAFETY\n                                     OFFICE OF THE SCIENTIFIC DIRECTOR\n\n                                          EVIDENTIAL BREATH ALCOHOL TESTING \n                           INSTRUMENT CALIBRATION CERTIFICATE\n                                                           OSD-CAL-06 Rev. 12 (10/2023) p.1 Issued by: Scientific Director"]
[null,"                                   TEXAS DEPARTMENT OF PUBLIC SAFETY\n                                     OFFICE OF THE SCIENTIFIC DIRECTOR\n\n                        AMENDED EVIDENTIAL BREATH ALCOHOL TESTING \n                       INSTRUMENT CALIBRATION CERTIFICATE\n                                                             OSD-CAL-10 Rev. 12 (10/2023) p.1 Issued by: Scientific Director"]
[]
["This amends and replaces the Calibration Certificate issued on:"]
[]
["Instrument Calibrated:",null,null,"Serial Number:",null,null,"Date Received in Calibration Lab:"]
[]
["Laboratory Name:"]
[]
["Laboratory Address:"]
[]
["Customer Name:"]
[]
["Customer Address:"]
[]
["Calibration Procedure Used:","OSD-CAL-01 (current version)"]
[]
["Instrument Condition:","NO","   The instrument is in proper working condition and is suitable for calibration."]
[]
["Serial number of NIST-traceable thermometer:",null,null,null,null,"Thermometer calibration expiration date:"]
[]
["NOMINAL VALUE",0,0.04,0.08,0.15,0.4]
["SIMULATOR SN"]
["SIM OPERATING PROPERLY","NO","NO","NO","NO","NO"]
["REFERENCE SOLUTION LOT","NONE","NONE","NONE","NONE","NONE"]
["VAPOR CONCENTRATION",0,0,0,0,0]
["COMB STD UNCERTAINTY (SDComb)",0,0,0,0,0]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9,null,null,null,null,null,null,"Reviewing Analyst:"]
[10,null,null,null,null,null,null,"Date review completed:"]
[11]
[12]
[13]
[14]
[15]
["MEAN (MeanIntox)","-",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"ERROR",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Calibration Analyst: "]
["STANDARD DEVIATION (SDIntox)","-",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Date certificate issued: "]
[null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["ROUNDED MEAN","-",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["*EXPANDED UNCERTAINTY (UIntox)","-",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["All results are reported in g/210 L"]
["*Rounded Mean ± Expanded Uncertainty at the 99% level (k=2.977)"]
[null,"Reason for instrument calibration:"]
[]
[null,"Repairs/Adjustments:  "]
[]
["TRACEABILITY INFORMATION"]
["This calibration is traceable to NIST through an unbroken chain of comparisons. This instrument was calibrated using solutions prepared by the DPS CRM Laboratory, an ISO 17034-accredited reference material producer, and the solutions' measurements are traceable through their certificate of analyses to NIST ethanol standards."]
["Simulator temperatures are measured at 34.00 ± 0.20ºC by using a NIST-traceable thermometer. The thermometer is made traceable to NIST by being calibrated in an ISO/IEC 17025-accredited calibration laboratory that provides a certificate showing that the measurements are traceable to NIST."]
["The Instrument Calibration Certificate is a three-page document contained in the Calibration Certificate Workbook (OSD-WBK-01) as defined in OSD-CAL-01. This Instrument Calibration Certificate applies only to the item being calibrated and shall not be reproduced, except in full, without the written approval of the Office of the Scientific Director. "]

{"sheet":"REFERENCE SOLUTIONS","index":3,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Reference Solutions"]
["Lot #","Nominal","Vapor Conc","SDcomb","Expires","Added By","Added Date","Signature"]
["PW-0718A",0,0,0,"2020-07-31","Carly Bishop","2018-09-21"]
["040-0718A",0.04,4.1000000000000002E-2,1.9000000000000001E-4,"2020-07-31","Carly Bishop","2018-09-21"]
["080-0718A",0.08,8.2000000000000003E-2,3.6000000000000002E-4,"2020-07-31","Carly Bishop","2018-09-21"]
["150-0718A",0.15,0.15079999999999999,6.8000000000000005E-4,"2020-07-31","Carly Bishop","2018-09-21"]
["400-0818A",0.4,0.40720000000000001,2.0500000000000002E-3,"2020-08-31","Carly Bishop","2018-09-21"]
["080-0718B",0.08,8.1299999999999997E-2,3.8999999999999999E-4,"2020-07-31","Carly Bishop","2018-09-21"]
["PW-1019A",0,0,0,"2021-10-31","Carly Bishop","2019-11-07"]
["040-1019A",0.04,4.0399999999999998E-2,3.4000000000000002E-4,"2021-10-31","Carly Bishop","2019-11-07"]
["080-1019A",0.08,8.1299999999999997E-2,9.3999999999999997E-4,"2021-10-31","Carly Bishop","2019-11-07"]
["150-1019A",0.15,0.14860000000000001,5.9000000000000003E-4,"2021-10-31","Carly Bishop","2019-11-07"]
["400-1019B",0.4,0.40160000000000001,1.2999999999999999E-3,"2021-10-31","Carly Bishop","2019-11-07"]
["080-0820A",0.08,8.0399999999999999E-2,3.8999999999999999E-4,"2022-08-31","Carly Bishop","2020-09-10"]
["PW-1120A",0,0,0,"2022-11-30","Jennifer Howard","2021-02-02"]
["040-1120A",0.04,4.1099999999999998E-2,1.9000000000000001E-4,"2022-11-30","Jennifer Howard","2021-02-02"]
["080-1120A",0.08,8.0799999999999997E-2,2.7E-4,"2022-11-30","Jennifer Howard","2021-02-02"]
["150-1120A",0.15,0.1532,3.4000000000000002E-4,"2022-11-30","Jennifer Howard","2021-02-02"]
["400-1120A",0.4,0.40589999999999998,1.8500000000000001E-3,"2022-11-30","Jennifer Howard","2021-02-02"]
["080-0821B",0.08,8.1199999999999994E-2,5.2999999999999998E-4,"2023-08-31","Jennifer Howard","2021-09-07"]
["PW-0422A",0,0,0,"2024-04-30","Jennifer Howard","2022-04-26"]
["040-0422A",0.04,4.1200000000000001E-2,1.6000000000000001E-4,"2024-04-30","Jennifer Howard","2022-04-26"]
["080-0422A",0.08,8.1600000000000006E-2,4.6000000000000001E-4,"2024-04-30","Jennifer Howard","2022-04-26"]
["150-0422A",0.15,0.15049999999999999,8.8000000000000003E-4,"2024-04-30","Jennifer Howard","2022-04-26"]
["400-0422A",0.4,0.40060000000000001,1.2700000000000001E-3,"2023-04-14","Jennifer Howard","2022-04-26",null,"Expiration date changed from 4/30/2024 to 4/14/2023 due to solution recall"]
["080-1122A",0.08,8.1699999999999995E-2,4.2000000000000002E-4,"2024-11-30","Jennifer Howard","2022-11-21"]
["400-0423B",0.4,0.40379999999999999,1.0300000000000001E-3,"2025-04-30","Jennifer Howard","2023-04-27"]
["PW-0623A",0,0,0,"2025-06-30","Jennifer Howard","2023-07-30"]
["040-0623A",0.04,4.0399999999999998E-2,2.2000000000000001E-4,"2025-06-30","Jennifer Howard","2023-07-30"]
["080-0623A",0.08,8.14E-2,2.4000000000000001E-4,"2025-06-30","Jennifer Howard","2023-07-30"]
["150-0623A",0.15,0.15190000000000001,6.9999999999999999E-4,"2025-06-30","Jennifer Howard","2023-07-30"]
["400-0623A",0.4,0.40310000000000001,1.75E-3,"2025-06-30","Jennifer Howard","2023-07-30"]

{"sheet":"EXTRA","index":4,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["BALQA"]