{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Overview","Main","Grid","Chart","ChangeHistory"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":1,"defined_names":12,"comments":2,"pivot_tables":0},"unopened":[{"sheet":"Chart","index":3,"reason":"not_a_worksheet"}],"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":"Overview","index":0,"n_rows":74,"n_cols":4,"rows_kept":74,"cut":false,"hidden":false,"merged":[[73,1,84,12],[35,1,35,12],[9,1,11,12],[40,1,42,12],[43,1,68,12],[70,1,72,12],[12,1,33,12],[1,3,1,8],[2,3,2,8],[3,3,3,8],[4,3,4,8],[5,3,5,8]]}
[]
[null,null,null,"Kiefner and Associates, Inc."]
[null,null,null,{"$f":"Main!D3","v":"6185 Huntley Road, Suite J"}]
[null,null,null,{"$f":"Main!D4","v":"Columbus, Ohio 43229"}]
[null,null,null,{"$f":"Main!D5","v":"Phone: +1 (614) 888-8220"}]
[null,"Version Released:",{"$f":"Main!C6","v":"2024-01-31"},"www.kiefner.com"]
[]
[]
[]
[null,"Disclaimer"]
[]
[]
[null,"The KAPATM spreadsheet is provided by Kiefner and Associates, Inc. (Kiefner). Kiefner hereby warrants that it is the owner of KAPATM. Kiefner believes that the equations embedded in KAPATM were correct at the time it was posted to its website, www.kiefner.com, based on and in accordance with Kiefner's knowledge, information, and belief with commonly accepted procedures and consistent with standard practices of the software industry.\n\nKiefner has taken no security measures or action relative to inadequate controls or mitigation of risk to any of its clients' IT systems.\n\nKiefner has taken no action with regard to Data Security to protect the destruction, loss, disclosure, or alteration of client confidential information.\n\nKiefner expressly excludes all warranties, express or implied, oral or written, including without limitation:\n• Any warranty that the software is error-free, will operate without interruption, or is compatible with all equipment and software configurations;\n• Any and all implied warranties of merchantability; and\n• Any and all warranties of fitness for a particular purpose.\n\nThe user of KAPATM hereby agrees to hold Kiefner harmless for any and all loss, liability, or damages, including consequential damages, arising out of, or incurred in connection with, the user's use or reproduction of KAPATM, including any decisions the user makes based on the output of information user received from KAPATM."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Do you agree to the terms of the Disclaimer? If no, the spreadsheet will be closed."]
[]
[]
[]
[]
[null,"References"]
[]
[]
[null,"The attached spreadsheet provides two methods for calculating the failure pressure levels of longitudinally oriented part-through flaws of varying depths in pressurized pipe. One method is applicable to blunt defects such as corrosion-caused metal loss. The other method is applicable to crack-like defects. The equations were developed and validated thanks to various research efforts sponsored by individual pipeline operators and industry consortia. The equations have been in the public domain for over 35 years. They have their origin in concepts advanced by early fracture mechanics experts prior to any involvement in the pipeline industry. For more information on the background of these equations, please consult the following references:\n\n1. Kiefner, J. F. (2008, October 6). Defect assessment-1: Modified equation aids integrity management. \"Oil and Gas Journal.\"\n\n2. Kiefner, J. F. (2008, October 13). Defect assessment-conclusion: Modified Ln-secant equation improves failure prediction. \"Oil and Gas Journal.\"\n\n3. Kiefner, J. F., & Duffy, A. R. (1971, July 20). \"Summary of research to determine the strength of corroded areas in line pipe.\" Presented at a public hearing of the U.S. Department of Transportation.\n\n4. Kiefner, J. F., & Vieth, P. H. (1990, August 6). Evaluating pipe: New method corrects criterion for evaluating corroded pipe. \"Oil and Gas Journal.\"\n\n5. Kiefner, J. F., & Vieth, P. H. (1990, August 20). Evaluating pipe: PC program speeds new criterion for evaluating corroded pipe. \"Oil and Gas Journal.\"\n\n6. Kiefner, J. F., Maxey, W. A., Eiber, R. J., & Duffy, A. R. (1973). \"Failure stress levels of flaws in pressurized cylinders. Progress in Flaw Growth and Toughness Testing, ASTM STP 536,\" 461–481. American Society for Testing and Materials."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Description of Spreadsheet Contents"]
[]
[]
[null,"There are three tabs in this spreadsheet: Main, Grid, and Chart. \n\nThe Main tab is where the pipe data is entered, such as pipe diameter, wall thickness, SMYS, MOP, design factor, percent operating stress, and maximum allowable pressure. A Charpy V-notch is needed only for the crack-like defect analysis, not for the corrosion or blunt defect analysis. This Main tab also contains the buttons that run the calculations, where the results are displayed once the calculations are run.\n\nThe Grid tab is where the defect profile data is entered. There are options to enter the profile in terms of defect depth or in terms of remaining wall thickness. There is also an option to enter the data in MILS. Profile spacing information needs to be entered in the leftmost column, and up to ten grids of profile data for the defect can be entered. The tab automatically tracks the maximum envelope defect profile.\n\nOn the Chart tab, a visual representation of the defect profile is displayed. The chart is automatically formatted when the calculations are run, but once they have run, it can be customized in any way that Excel allows.\n"]

{"sheet":"Main","index":1,"n_rows":33,"n_cols":20,"rows_kept":33,"cut":false,"hidden":true,"merged":[[1,3,1,8],[2,3,2,8],[3,3,3,8],[4,3,4,8],[5,3,5,8],[25,1,31,1],[7,11,7,14],[8,9,8,10],[8,11,8,12],[9,9,9,10],[9,11,9,12],[7,9,7,10],[14,1,14,2],[14,3,14,4],[15,3,15,4],[15,1,15,2],[19,1,20,1],[21,1,22,1],[23,1,24,1]]}
[]
[null,null,null,"Kiefner and Associates, Inc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,null,null,"6185 Huntley Road, Suite J"]
[null,null,null,"Columbus, Ohio 43229"]
[null,null,null,"Phone: +1 (614) 888-8220"]
[null,"Version Released:","2024-01-31","www.kiefner.com"]
[]
[null,null,null,null,null,null,null,null,null,"Line Number",null,"N/A"]
[null,"Diameter",8.625,"inches",null,null,null,null,null,"Station Number",null,"N/A"]
[null,"Wt",0.25,"inches",null,null,null,null,null,"Mile Post",null,"N/A"]
[null,"SMYS",70000,"psi"]
[null,"MOP",1704,"psi"]
[null,"CVN",25.000000000000004,"ft-lb"]
[null,"Design Factor",0.72]
[null,"Percent Operating Stress",null,{"$f":"C12*C9/(2*C11*C10)","v":0.41991428571428574}]
[null,"Maximum Allowable Pressure",null,{"$f":"IF($T$2,+C14*2*C11*C10/C9,+C14*2*C11*C10/C9)","v":2921.7391304347825},null,"psi"]
[]
[]
[null,null,null,"Envelope Defect Profile",{"$f":"IF(Grid!E17=\"\",\"\",+Grid!E17)","v":"Row 1"},{"$f":"IF(Grid!F17=\"\",\"\",+Grid!F17)","v":"Row 2"},"Row 3",{"$f":"IF(Grid!H17=\"\",\"\",+Grid!H17)","v":"Row 4"},{"$f":"IF(Grid!I17=\"\",\"\",+Grid!I17)","v":"Row 5"},{"$f":"IF(Grid!J17=\"\",\"\",+Grid!J17)","v":"Row 6"},{"$f":"IF(Grid!K17=\"\",\"\",+Grid!K17)","v":"Row 7"},{"$f":"IF(Grid!L17=\"\",\"\",+Grid!L17)","v":"Row 8"},{"$f":"IF(Grid!M17=\"\",\"\",+Grid!M17)","v":"Row 9"},{"$f":"IF(Grid!N17=\"\",\"\",+Grid!N17)","v":"Row 10"},{"$f":"IF(Grid!O17=\"\",\"\",+Grid!O17)","v":""},{"$f":"IF(Grid!P17=\"\",\"\",+Grid!P17)","v":""},{"$f":"IF(Grid!Q17=\"\",\"\",+Grid!Q17)","v":""}]
[null,"Effective Area Method","Predicted Failure Pressure (Pf, psi)",3883.3723843476901,3883.3723843476901]
[null,null,"Factor of Safety (Pf/MOP)",2.2789744039599098,2.2789744039599098]
[null,"Modified B31G","Predicted Failure Pressure (Pf, psi)",3318.2372199445699,3318.2372199445699]
[null,null,"Factor of Safety (Pf/MOP)",1.9473223121740399,1.9473223121740399]
[null,"B31G","Predicted Failure Pressure (Pf, psi)",2722.8985507246398,2722.8985507246398]
[null,null,"Factor of Safety (Pf/MOP)",1.5979451588759599,1.5979451588759599]
[null,"Calculated Parameters","Total Length (in.)",10.85,10.85]
[null,null,"Eff. Length (in.)",10.85,10.85]
[null,null,"Start Length (in.)",0,0]
[null,null,"Stop Length (in.)",10.85,10.85]
[null,null,"Max Pit Depth (in.)",9.7500000000000003E-2,9.7500000000000003E-2]
[null,null,"Max (Depth/ Thickness)",0.39,0.39]
[null,null,"Eff. Area in.^2)",0.52893749999999995,0.52893749999999995]
[null,{"$f":"_xlfn.CONCAT(\"Released: \",TEXT(C6,\"MM/DD/YY\"))","v":"Released: 01/31/24"},null,null,"Please refer to the Disclaimer in the Overview Tab."]

{"sheet":"Grid","index":2,"n_rows":1018,"n_cols":22,"rows_kept":1018,"cut":false,"hidden":true,"merged":[[6,0,6,14],[1,5,1,9],[2,5,2,9],[3,5,3,9],[4,5,4,9],[5,5,5,9],[9,4,9,5],[11,1,11,4],[12,4,12,14],[17,0,32,0],[7,11,11,13],[7,6,7,10],[8,6,11,10],[8,1,8,3],[8,4,8,5],[9,1,9,3],[7,1,7,3],[7,4,7,5]]}
[]
[null,null,null,null,null,"Kiefner and Associates, Inc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WT",{"$f":"Main!C10","v":0.25}]
[null,null,null,null,null,{"$f":"Main!D3","v":"6185 Huntley Road, Suite J"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V8=FALSE,MIN(E18:M1018), IF(V9=TRUE,MIN(E18:M1018)/1000,MIN(E18:M1018)))","v":0}]
[null,null,null,null,null,{"$f":"Main!D4","v":"Columbus, Ohio 43229"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V8=FALSE,MAX(E18:M1018),IF(V9=TRUE,MAX(E18:M1018)/1000,MAX(E18:M1018)))","v":9.7500000000000003E-2}]
[null,null,null,null,null,{"$f":"Main!D5","v":"Phone: +1 (614) 888-8220"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"min loss",{"$f":"IF(V7,V3,V2-V4)","v":0}]
[null,"Version Released:",{"$f":"Main!C6","v":"2024-01-31"},null,null,"www.kiefner.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"max loss",{"$f":"IF(V7,V4,V2-V3)","v":9.7500000000000003E-2}]
["Grid To Evaluate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pit Depth",true]
[null,"Line Number",null,null,{"$f":"+Main!L8","v":"N/A"},null,"Description",null,null,null,null,null,null,null,null,null,null,null,null,null,"US Units",{"$f":"Main!T2","v":true}]
[null,"Station Number",null,null,{"$f":"+Main!L9","v":"N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mils",false]
[null,"Mile Post",null,null,{"$f":"+Main!L10","v":"N/A"}]
[]
[null,{"$f":"IF(Main!$T$2,\"Dimensions in Inches\",\" Dimensions in mm\")","v":"Dimensions in Inches"}]
[null,null,null,null,{"$f":"IF(V5<0,\"Error Invalid Input\",IF(V6>=V2,\"Error - Corrosion Exceeds Wall Thickness\",IF(V6>=0.8*V2,\"Error - Evaluation Invalid, Corrosion Exceeds 80% of WT\",\"\")))","v":""}]
[]
[null,{"$f":"COUNT(B18:B1018)","v":3},{"$f":"MAX(E15:V15)","v":3},null,{"$f":"COUNT(E18:E1018)","v":3},{"$f":"COUNT(F18:F1018)","v":0},{"$f":"COUNT(G18:G1018)","v":0},{"$f":"COUNT(H18:H1018)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Profile Spacing","Max. Envelope Defect Profile",null,"Row 1","Row 2","Row 3","Row 4","Row 5","Row 6","Row 7","Row 8","Row 9","Row 10"]
["Pipe Longitudinal Direction",0,{"$f":"IF($V$7=TRUE,MAX(E18:N18),MIN(E18:N18))","v":0},null,0]
[null,5.4249999999999998,{"$f":"IF($V$7=TRUE,MAX(E19:N19),MIN(E19:N19))","v":9.7500000000000003E-2},null,{"$f":"0.39*0.25","v":9.7500000000000003E-2}]
[null,10.85,0,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"IF($V$7=TRUE,MAX(E83:N83),MIN(E83:N83))","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"IF($V$7=TRUE,MAX(E147:N147),MIN(E147:N147))","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"IF($V$7=TRUE,MAX(E211:N211),MIN(E211:N211))","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"IF($V$7=TRUE,MAX(E275:N275),MIN(E275:N275))","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"IF($V$7=TRUE,MAX(E339:N339),MIN(E339:N339))","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"IF($V$7=TRUE,MAX(E403:N403),MIN(E403:N403))","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"IF($V$7=TRUE,MAX(E467:N467),MIN(E467:N467))","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"IF($V$7=TRUE,MAX(E531:N531),MIN(E531:N531))","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"IF($V$7=TRUE,MAX(E595:N595),MIN(E595:N595))","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"IF($V$7=TRUE,MAX(E659:N659),MIN(E659:N659))","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"IF($V$7=TRUE,MAX(E723:N723),MIN(E723:N723))","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"IF($V$7=TRUE,MAX(E787:N787),MIN(E787:N787))","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"IF($V$7=TRUE,MAX(E851:N851),MIN(E851:N851))","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"IF($V$7=TRUE,MAX(E915:N915),MIN(E915:N915))","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,{"$f":"IF($V$7=TRUE,MAX(E979:N979),MIN(E979:N979))","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]

{"sheet":"ChangeHistory","index":4,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["KAPA Change History:"]
[]
["Date","Maintainer","Comments"]
["2018-05-03","Mark Ryan","Updated work around for Microsoft update issues with ActiveX controls."]
["2018-03-15","Mark Ryan","Updated branding"]
["2018-03-13","Mark Ryan","Changed Overview disclaimer according to Kiefner Lawyer.\nLocked access to tabs until other than the Overview disclaimer until the user agrees to the terms of the disclaimer.\nAdded coding that locks access to all tabs but the Overview disclaimer as soon as the spreadsheet is opened."]
["2018-03-09","Mark Ryan","Fixed bug in finding last row of grid when using remaining wall thickness feature.\nAdded ErrorHandler coding to pin point where errors are in the code for users.\nLocked and protected all cells in worksheets that should not be changed by users."]
["2018-03-08","Mark Ryan","Added Chart to Print to PDF Button.\nAdded coding to remove selected grouping after printing to pdf.\nAdded coding to work around the movement of option buttons and checkbox on Grid tab when clicking Print to PDF."]
["2018-03-07","Mark Ryan","Fixed bug in the Print to PDF Button.\nAdded coding to stop the screen from updating any time a calculation was done.\nAdded coding so that the option buttons, checkboxes, and click buttons all remain in the same location at the same sizes."]
["2015-12-07","Ron Ostafichuk","Added 6 new Case Tests to the Unit Test code successfully."]
["2015-12-03","Ron Ostafichuk","Updated to use leading and trailing zeros if available, updated unit tests for first release."]
["2015-07-22","Ron Ostafichuk","Fixed Error if user runs calc with no data entered"]
["2015-07-22","Ron Ostafichuk","Fixed Error if running a Row that is all zeros."]
["2015-06-12","Ron Ostafichuk","Added a changelog to the list of tabs to contain this information.\nAdded Unit Test Framework with same tests so we can automatically test the system after any changes instead of doing manual testing.\nImproved performance for finding last row so Automatic tests can run faster."]
["2015-06-11","Ron Ostafichuk","Changed Overview disclaimer according to Kiefner Lawyer"]
["2015-01-06","Ron Ostafichuk","Fix to Length Calcs, DO NOT include the leading or trailing zero for length calcs(Depth Mode).  \nie. assume the start of the defect is the first non-zero entry when using depth.  \nIf using remaining Wt then the first entry < Wt is the start and the last < Wt is the end.   (INCORRECT, fixed in 3-dec-2015)"]
["2015-04-07","Ron Ostafichuk","Fixed bug in the Effective Length calc by removing multiple (almost) identical blocks of code and replacing them with a function to do the calc the same way all the time."]
["2014-01-30","Ron Ostafichuk"," Added FULL units conversion of existing data so that if you change the selected units the program will automatically convert all entered values into the unit system you just selected."]