{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data","Formatting"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":24,"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":"Data","index":0,"n_rows":100,"n_cols":11,"rows_kept":100,"cut":false,"hidden":false,"merged":[[19,8,19,10],[19,1,19,2],[11,10,16,19],[10,2,10,3],[11,2,11,3],[13,2,13,3],[14,2,14,3],[19,5,19,7],[19,3,19,4],[15,2,15,3],[16,2,16,3]]}
["Extensometer Verification Template"]
["© 2023 Epsilon Technology Corp, All Rights Reserved"]
["v2.0.1","2023-02-22","www.epsilontech.com"]
[]
["How to use this Template"]
["1 - Enable Macros when opening if asked; this template uses macro-enabled features.",null,null,null,null,null,null,null,null,null,"Notes:"]
["2 - Enter Basic Parameters, units, and limits in Blue cells.",null,null,null,null,null,null,null,null,null,"1 - Mount extensometer and exercise 2x before verifying"]
["3 - Enter verification data in Green cells.  Minimum 2 rows. ",null,null,null,null,null,null,null,null,null,"2 - Verification Data Runs can be multiple runs, multiple ranges, or tension/compression, etc."]
["4 - Attach original verification reports in any format when sending to Epsilon.",null,null,null,null,null,null,null,null,null,"3 - Multiple ranges may be concatenated."]
[null,null,null,null,null,null,null,null,null,null,"4 - Attach original verification reports in any format when sending to Epsilon."]
["Extensometer Model",null,"e.g.  3542-050M-020-ST"]
["Extensometer S/N",null,"e.g. E123456",null,null,null,null,null,null,null,"This template is provided for reference only, for visualization and troubleshooting purposes.  It is not a substitute for a proper extensometer verification and does not attempt to address all requirements of the applicable standards.  The author makes no guarantee that this worksheet is sufficient for any application.   It is the sole responsibility of the user to follow calibration and verification procedures required by their governing standards. This template does not address gage length and resolution requirements."]
["Nominal Gauge Length",null,null,"- select units -"]
["Displayed Error Bounds",null,"- select class bounds to plot -"]
["Calibrator Make & Model",null,"e.g. Epsilon 3590VHR"]
["Verification Date:",null,"e.g. 1-Jan-2019"]
["Notes:",null,"Any notes here."]
[]
[]
[null,"Verification Data - Run 1",null,"Run 2 Data (Optional)",null,"Calculated Results - Run 1",null,null,"Calculated Results - Run 2"]
["Nominal Extension","Reference Displacement","Indicated Displacement","Reference Displacement","Indicated Displacement","Reference Disp.","Indicated Disp.","Indicated Error 1","Reference Disp.","Indicated Disp.","Indicated Error 2"]
[{"$f":"Ref.Units","v":"- select units -"},"- select units -","- select units -",{"$f":"Ref.Units.2","v":"-"},{"$f":"Ind.Units.2","v":"-"},"(mm)","(mm)","(µm)","(mm)","(mm)","(µm)"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(B23),NA(),B23*Ref.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(C23),NA(),C23*Ind.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(C23),NA(),(G23-F23)*1000)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(D23),NA(),D23*Ref.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(E23),NA(),E23*Ind.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(E23),NA(),(J23-I23)*1000)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$f":"IF(ISBLANK(B43),NA(),B43*Ref.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(C43),NA(),C43*Ind.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(C43),NA(),(G43-F43)*1000)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(D43),NA(),D43*Ref.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(E43),NA(),E43*Ind.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(E43),NA(),(J43-I43)*1000)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$f":"IF(ISBLANK(B67),NA(),B67*Ref.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(C67),NA(),C67*Ind.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(C67),NA(),(G67-F67)*1000)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(D67),NA(),D67*Ref.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(E67),NA(),E67*Ind.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(E67),NA(),(J67-I67)*1000)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,{"$f":"IF(ISBLANK(B98),NA(),B98*Ref.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(C98),NA(),C98*Ind.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(C98),NA(),(G98-F98)*1000)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(D98),NA(),D98*Ref.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(E98),NA(),E98*Ind.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(E98),NA(),(J98-I98)*1000)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"IF(ISBLANK(B99),NA(),B99*Ref.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(C99),NA(),C99*Ind.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(C99),NA(),(G99-F99)*1000)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(D99),NA(),D99*Ref.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(E99),NA(),E99*Ind.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(E99),NA(),(J99-I99)*1000)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"IF(ISBLANK(B100),NA(),B100*Ref.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(C100),NA(),C100*Ind.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(C100),NA(),(G100-F100)*1000)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(D100),NA(),D100*Ref.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(E100),NA(),E100*Ind.to.mm)","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(E100),NA(),(J100-I100)*1000)","v":{"$error":"#N/A"}}]

{"sheet":"Formatting","index":1,"n_rows":40,"n_cols":15,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,"Item","Selected Units","Mulitpliers (to mm)","Run2 unit label",null,"Error Messages Generation"]
[null,"Reference",{"$f":"Ref.Units","v":"- select units -"},{"$f":"VLOOKUP(Ref.Units,B11:C14,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(Ref.Units,B12:B14,1,FALSE),\"-\")","v":"-"},null,null,"Err?","Msg","Misc Dat","Msg (mult)"]
[null,"Indicated",{"$f":"Ind.Units","v":"- select units -"},{"$f":"VLOOKUP(Ind.Units,B11:C14,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(Ind.Units,B12:B14,1,FALSE),\"-\")","v":"-"},null,"Err Cellformat",{"$f":"(CELL(\"format\",Data!B23)<>CELL(\"format\",C28))","v":false},{"$f":"IF(H7,\"Data Format Error. Paste verification data by val or enter manually.\",\"\")","v":""},null,{"$f":"IF(H7,CONCATENATE(TEXT(COUNTIF($H$7:$H7,\"TRUE\"),\"0\"),\". \",I7,$C$29),\"\")","v":""}," "]
[null,"Gauge Length",{"$f":"Gauge.Length.Units","v":"- select units -"},{"$f":"VLOOKUP(Gauge.Length.Units,B11:C14,2,FALSE)","v":{"$error":"#N/A"}},null,null,"Err Units",{"$f":"ISERROR(Ref.to.mm+Ind.to.mm)","v":true},{"$f":"IF(H8,\"In cells B22:C22, select units for raw data. Gauge Length with units is required when using %ε units for verification.\",\"\")","v":"In cells B22:C22, select units for raw data. Gauge Length with units is required when using %ε units for verification."},null,{"$f":"IF(H8,CONCATENATE(TEXT(COUNTIF($H$7:$H8,\"TRUE\"),\"0\"),\". \",I8,$C$29),\"\")","v":"1. In cells B22:C22, select units for raw data. Gauge Length with units is required when using %ε units for verification.\r\r"}," "]
[null,null,null,null,null,null,"Err E83",{"$f":"AND(NOT(Gauge.Length.Entered),Class.IsE83)","v":false},{"$f":"IF(H9,\"Gauge Length is required for display of E83 limits.\",\"\")","v":""},null,{"$f":"IF(H9,CONCATENATE(TEXT(COUNTIF($H$7:$H9,\"TRUE\"),\"0\"),\". \",I9,$C$29),\"\")","v":""}," "]
[null,"Units labels","Mult. To mm",null,null,null,"Err Metadata",{"$f":"NOT(Metadata.Entered)","v":true},{"$f":"IF(H10,\"Replace default values in cells C11:C17.\",\"\")","v":"Replace default values in cells C11:C17."},null,{"$f":"IF(H10,CONCATENATE(TEXT(COUNTIF($H$7:$H10,\"TRUE\"),\"0\"),\". \",I10,$C$29),\"\")","v":"2. Replace default values in cells C11:C17.\r\r"}," "]
[null,"- select units -",{"$f":"NA()","v":{"$error":"#N/A"}},null,null,null,"Err No Model",{"$f":"NOT(ModelNo.Entered)","v":false},{"$f":"IF(H11,\"Enter Epsilon Model Number in cell C11.\",\"\")","v":""},null,{"$f":"IF(H11,CONCATENATE(TEXT(COUNTIF($H$7:$H11,\"TRUE\"),\"0\"),\". \",I11,$C$29),\"\")","v":""}," "]
[null,"(in)",25.4,null,null,null,"Err No SN",{"$f":"NOT(SerialNo.Entered)","v":false},{"$f":"IF(H12,\"Enter Epsilon Serial Number in cell C12.\",\"\")","v":""},null,{"$f":"IF(H12,CONCATENATE(TEXT(COUNTIF($H$7:$H12,\"TRUE\"),\"0\"),\". \",I12,$C$29),\"\")","v":""}," "]
[null,"(mm)",1,null,null,null,"Err Bad SN",{"$f":"AND(SerialNo.Entered,NOT(SerialNo.IsValid))","v":true},{"$f":"IF(H13,\"Not a valid Epsilon Serial Number.  Expecting 'E#####'.\",\"\")","v":"Not a valid Epsilon Serial Number.  Expecting 'E#####'."},null,{"$f":"IF(H13,CONCATENATE(TEXT(COUNTIF($H$7:$H13,\"TRUE\"),\"0\"),\". \",I13,$C$29),\"\")","v":"3. Not a valid Epsilon Serial Number.  Expecting 'E#####'.\r\r"}," "]
[null,"(%)",{"$f":"Gauge.Length.mm/100","v":{"$error":"#N/A"}},null,null,null,"Err No Class Bnds",{"$f":"ISERROR(C27)","v":true},{"$f":"IF(H14,\"Select Class Bounds to plot in cell C14.\",\"\")","v":"Select Class Bounds to plot in cell C14."},null,{"$f":"IF(H14,CONCATENATE(TEXT(COUNTIF($H$7:$H14,\"TRUE\"),\"0\"),\". \",I14,$C$29),\"\")","v":"4. Select Class Bounds to plot in cell C14.\r\r"}," "]
[null,null,null,null,null,null,null,null,null,null,null," "]
[null,"property","value",null,null,null,"Err Messages",{"$f":"OR(H7:H14)","v":true},{"$f":"IF(H16,VLOOKUP(TRUE,H7:I14,2,FALSE),\"None\")","v":"In cells B22:C22, select units for raw data. Gauge Length with units is required when using %ε units for verification."}]
[null,"GL (mm)",{"$f":"IF(ISBLANK(Gauge.Length),NA(),Gauge.Length*Gauge.Length.to.mm)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"CONCATENATE(K7,K8,K9,K10,K11,K12,K13,K14)","v":"1. In cells B22:C22, select units for raw data. Gauge Length with units is required when using %ε units for verification.\r\r2. Replace default values in cells C11:C17.\r\r3. Not a valid Epsilon Serial Number.  Expecting 'E#####'.\r\r4. Select Class Bounds to plot in cell C14.\r\r"}]
[null,"HasGL?",{"$f":"NOT(ISERROR(Gauge.Length.mm))","v":false}]
[null,"Plot Title",{"$f":"CONCATENATE(\"Bias Error Plot with \",IF(ISERROR(Class.Index),\"no Class\",Class.Bounds),\" Limits\")","v":"Bias Error Plot with no Class Limits"},null," ",null,"Revision History"]
[null,"X title","Applied Displacement (mm)",null,null,null,"v2.0.0","2023-02-08","Add 3590VHR integration;general cleanup."]
[null,"Y Title","Indicated Error (µm)"]
[null,"E83 Limits?",{"$f":"NOT(ISERROR(SEARCH(\"E83\",Class.Bounds)))","v":false}]
[null,"Metadata Entered?",{"$f":"ISERR(SEARCH(\"e.g.\",CONCATENATE(Data!C11,Data!C12,Data!C13,Data!C15,Data!C16,Data!C17)))","v":false}]
[null,"Has Model No",{"$f":"NOT(ISBLANK((Ext.Model)))","v":true}]
[null,"Has Serial No",{"$f":"NOT(ISBLANK((Ext.SN)))","v":true}]
[null,"Valid Eps SN",{"$f":"AND(LEFT(UPPER(Ext.SN),1)=\"E\",NOT(ISERROR(VALUE(MID(Ext.SN,2,10))<50000)))","v":false}]
[null,"Class Sel. Index",{"$f":"MATCH(Data!C14,B33:B40,FALSE)","v":{"$error":"#N/A"}}]
[null,"Cell Format",0]
[null,"Err LF char",{"$f":"CHAR(13) & CHAR(13)","v":"\r\r"}]
[]
[null,"Error Bounds (From E83-16 and ISO 9513-2012)",null,null,null,null,null,"Error Bounds Plot Generation",null,null,null,"Error bounds plots"]
[null,"- select class bounds to plot -","fixed (µm)","relative (%val)","breakover(mm)","fixed (m/m)",null,null,null,null,null,null,"disp (mm)","+limit (µm)","-limit (µm)"]
[null,"ASTM E83-16 Class A",{"$f":"F33*Gauge.Length.mm*1000","v":{"$error":"#N/A"}},1E-3,{"$f":"(C33/1000)/D33","v":{"$error":"#N/A"}},2.0000000000000002E-5,null,{"$f":"C32","v":"fixed (µm)"},{"$f":"D32","v":"relative (%val)"},{"$f":"E32","v":"breakover(mm)"},null,"-lim",{"$f":"H39","v":{"$error":"#N/A"}},{"$f":"MAX($H$34,$I$34*ABS(M33)*1000)","v":{"$error":"#N/A"}},{"$f":"-N33","v":{"$error":"#N/A"}}]
[null,"ASTM E83-16 Class B-1",{"$f":"F34*Gauge.Length.mm*1000","v":{"$error":"#N/A"}},5.0000000000000001E-3,{"$error":"#N/A"},1E-4,null,{"$f":"INDEX(C33:C40,Class.Index)","v":{"$error":"#N/A"}},{"$f":"INDEX(D33:D40,Class.Index)","v":{"$error":"#N/A"}},{"$f":"INDEX(E33:E40,Class.Index)","v":{"$error":"#N/A"}},null,"-break",{"$f":"MAX(-J34,H39)","v":{"$error":"#N/A"}},{"$f":"MAX($H$34,$I$34*ABS(M34)*1000)","v":{"$error":"#N/A"}},{"$f":"-N34","v":{"$error":"#N/A"}}]
[null,"ASTM E83-16 Class B-2",{"$f":"F35*Gauge.Length.mm*1000","v":{"$error":"#N/A"}},5.0000000000000001E-3,{"$error":"#N/A"},2.0000000000000001E-4,null,null,null,null,null,"+break",{"$f":"MIN(J34,I39)","v":{"$error":"#N/A"}},{"$f":"MAX($H$34,$I$34*ABS(M35)*1000)","v":{"$error":"#N/A"}},{"$f":"-N35","v":{"$error":"#N/A"}}]
[null,"ASTM E83-16 Class C",{"$f":"F36*Gauge.Length.mm*1000","v":{"$error":"#N/A"}},0.01,{"$error":"#N/A"},1E-3,null,{"$f":"MAX(IF(ISNUMBER(Data!H23:H100),Data!H23:H100),-IF(ISNUMBER(Data!H23:H100),Data!H23:H100),IF(ISNUMBER(Data!K23:K100),Data!K23:K100),-IF(ISNUMBER(Data!K23:K100),Data!K23:K100))","v":0},null,"maximum abs error (µm) in results"," ","+lim",{"$f":"I39","v":{"$error":"#N/A"}},{"$f":"MAX($H$34,$I$34*ABS(M36)*1000)","v":{"$error":"#N/A"}},{"$f":"-N36","v":{"$error":"#N/A"}}]
[null,"ISO 9513-2012 Class 0,2",0.6,2E-3,0.3,null,null,{"$f":"MAX(J34,H36*0.001/I34)*2","v":{"$error":"#N/A"}},null,"max x range for limits plot to get visually convenient display"," "]
[null,"ISO 9513-2012 Class 0,5",1.5,5.0000000000000001E-3,0.3,null,null,{"$f":"MIN(IF(ISNUMBER(Data!F23:F100),Data!F23:F100),IF(ISNUMBER(Data!I23:I100),Data!I23:I100),0)","v":0},{"$f":"MAX(IF(ISNUMBER(Data!F23:F100),Data!F23:F100),IF(ISNUMBER(Data!I23:I100),Data!I23:I100),0)","v":0},"limits of the x data range (mm)"," "]
[null,"ISO 9513-2012 Class 1",3,0.01,0.3,null,null,{"$f":"MAX(H38,-H37)","v":{"$error":"#N/A"}},{"$f":"MIN(I38,H37)","v":{"$error":"#N/A"}},"x range for limits plots"," "]
[null,"ISO 9513-2012 Class 2",6,0.02,0.3]