{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Experiment Metadata","dry x-hatch ZEK-100","dry x-hatch EFP","wet x-hatch ZEK-100","wet x-hatch EFP","B117 salt spray ZEK-100","Cyclic corrosion EFP"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":7,"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":"Experiment Metadata","index":0,"n_rows":47,"n_cols":23,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,7,8,11],[2,2,2,11],[4,2,4,11],[7,7,7,11],[27,9,27,11],[3,2,3,11],[10,7,10,11],[11,3,11,4],[11,7,11,11],[26,9,26,11],[9,3,9,4],[9,7,9,11],[18,2,18,3],[18,4,18,6],[18,9,18,10],[10,3,10,4],[42,10,42,11],[44,10,44,11],[32,3,32,4],[38,10,38,11],[39,10,39,11],[40,10,40,11],[37,6,37,9],[32,9,32,11],[41,10,41,11],[43,10,43,11],[37,14,38,14],[37,10,37,13],[6,0,6,1],[1,0,1,1],[7,3,7,4],[8,3,8,4],[15,0,15,1],[16,9,16,10],[20,9,20,10],[17,9,17,10],[16,2,16,3],[17,2,17,3],[20,2,20,3],[16,4,16,6],[17,4,17,6],[20,4,20,6],[31,3,31,4],[31,9,31,11],[19,2,19,3],[19,4,19,6],[19,9,19,10],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[25,9,25,11],[30,3,30,4],[30,9,30,11],[28,9,28,11],[29,9,29,11]]}
[]
["EXPERIMENT:"]
[null,"Title *","Pretreatment for benchmarking series 33"]
[null,"Description *","The purpose of this matrix was to further evaluate pretreatments for ZEK-100 and Eform Plus substrates and determine corrosion performance. Additionally, the interlayer adhesion between the deposited pretreatment and electrocoat was also evaluated."]
[null,"Methods *","Salt spray, cyclic corrosion testing, and cross hatch adhesion testing (dry and wet) were completed in this experiment. Corroded panels were scraped to remove the built up corrosion product and the delaminated electrocoat, then the scribe creep was measured using calipers."]
[]
["CONTRIBUTORS:"]
[null,"Last Name *","First Name *","Email Address *",null,"Institution *","Phone Number","Mailing Address"]
[null,"Allen","Kristi","Kristi.Allen@ppg.com",null,"PPG",null,"4325 Rosanna Drive, Allison Park, PA 15201"]
[]
[]
[]
[]
[null,"+Add Row"]
[]
["SOURCE MATERIAL:"]
[null,"Name *","Supplier/Provider *",null,"Description *",null,null,"Date Received *","Material *","Condition",null,"Location"]
[]
[]
[]
[]
[]
[null,"+Add Row"]
[]
["SPECIMENS:"]
[null,"Name *","Source Material","Processing *",null,"Creation Date","Thickness *","Width *","Area *","Comments"]
[null,null,"Name *",null,null,null,"mm","mm","mm^2"]
[]
[]
[]
[]
[]
[]
[]
[null,"+Add Row"]
[]
["TESTS:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEST PARAMETERS",null,null,null,null,null,null,"+Add Column"]
[null,"Name *","Specimen Name *","Type of Test *","Operator *","Test Date *","Instrument",null,null,null,"Notes",null,null,null,"Files\n(supplemental data files associated with each test)","Property Name","Property Name","Property Name","Property Name","Property Name","Property Name","Property Name"]
[null,null,null,null,null,null,"Name *","Type *","Location *","Last Calibration Date *","Test",null,"Specimen","Instrument",null,"units","units","units","units","units","units","units"]
[null,"Cyclic corrosion testing (GMW 14872)"]
[null,"dry cross hatch"]
[null,"wet cross hatch"]
[null,"Salt spray (ASTM B117)"]
[]
[]
[]
[null,"+Add Row"]

{"sheet":"dry x-hatch ZEK-100","index":1,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
["Test *","cross hatch adhesion testing (dry) on ZEK-100"]
[]
["SUMMARY"]
[null,"Field Name: * ","cleaner 1","PT 2","PT2.4","PT2.5","PT2.6","PT2.7","PT2.8","PT2.9","+Add Column"]
[null,"Units: * ","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"Dry hatch rating:",9.75,8.75,9.25,10,9.75,9.5,7.5,9]
[]
[null,null,"Enter data here"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"+Add Row"]
[]
["TEST DATA"]
[null,null,"RAW",null,null,null,null,"+Add Column","CALCULATED",null,null,null,null,"+Add Column"]
[null,"Field Name: *","Property Name","Property Name","Property Name","Property Name","Property Name",null,"Property Name","Property Name","Property Name","Property Name","Property Name"]
[null,"Units: *","units","units","units","units","units",null,"units","units","units","units","units"]
[null,"Description: *","description","description","description","description","description",null,"description","description","description","description","description"]
[null,"Valid Min:"]
[null,"Valid Max:"]
[null,"Missing Value:"]
[null,null,"Enter data here"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"+Add Row"]

{"sheet":"dry x-hatch EFP","index":2,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
["Test *","cross hatch adhesion testing (dry) on EFP"]
[]
["SUMMARY"]
[null,"Field Name: * ","cleaner 1","PT 2","PT2.4","PT2.5","PT2.6","PT2.7","PT2.8","PT2.9","+Add Column"]
[null,"Units: * ","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"Dry hatch rating:",9.75,9.75,10,9.25,10,10,9,8.5]
[]
[null,null,"Enter data here"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"+Add Row"]
[]
["TEST DATA"]
[null,null,"RAW",null,null,null,null,"+Add Column","CALCULATED",null,null,null,null,"+Add Column"]
[null,"Field Name: *","Property Name","Property Name","Property Name","Property Name","Property Name",null,"Property Name","Property Name","Property Name","Property Name","Property Name"]
[null,"Units: *","units","units","units","units","units",null,"units","units","units","units","units"]
[null,"Description: *","description","description","description","description","description",null,"description","description","description","description","description"]
[null,"Valid Min:"]
[null,"Valid Max:"]
[null,"Missing Value:"]
[null,null,"Enter data here"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"+Add Row"]

{"sheet":"wet x-hatch ZEK-100","index":3,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
["Test *","cross hatch adhesion testing (wet) on ZEK-100"]
[]
["SUMMARY"]
[null,"Field Name: * ","cleaner 1","PT 2","PT2.4","PT2.5","PT2.6","PT2.7","PT2.8","PT2.9","+Add Column"]
[null,"Units: * ","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"wet hatch rating:",5.25,3.5,4,6,7.75,7.5,8,8.5]
[]
[null,null,"Enter data here"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"+Add Row"]
[]
["TEST DATA"]
[null,null,"RAW",null,null,null,null,"+Add Column","CALCULATED",null,null,null,null,"+Add Column"]
[null,"Field Name: *","Property Name","Property Name","Property Name","Property Name","Property Name",null,"Property Name","Property Name","Property Name","Property Name","Property Name"]
[null,"Units: *","units","units","units","units","units",null,"units","units","units","units","units"]
[null,"Description: *","description","description","description","description","description",null,"description","description","description","description","description"]
[null,"Valid Min:"]
[null,"Valid Max:"]
[null,"Missing Value:"]
[null,null,"Enter data here"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"+Add Row"]

{"sheet":"wet x-hatch EFP","index":4,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
["Test *","cross hatch adhesion testing (wet) on EFP"]
[]
["SUMMARY"]
[null,"Field Name: * ","cleaner 1","PT 2","PT2.4","PT2.5","PT2.6","PT2.7","PT2.8","PT2.9","+Add Column"]
[null,"Units: * ","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"wet hatch rating:",7.5,6.25,0,0,9,6.5,8.25,7.5]
[]
[null,null,"Enter data here"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"+Add Row"]
[]
["TEST DATA"]
[null,null,"RAW",null,null,null,null,"+Add Column","CALCULATED",null,null,null,null,"+Add Column"]
[null,"Field Name: *","Property Name","Property Name","Property Name","Property Name","Property Name",null,"Property Name","Property Name","Property Name","Property Name","Property Name"]
[null,"Units: *","units","units","units","units","units",null,"units","units","units","units","units"]
[null,"Description: *","description","description","description","description","description",null,"description","description","description","description","description"]
[null,"Valid Min:"]
[null,"Valid Max:"]
[null,"Missing Value:"]
[null,null,"Enter data here"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"+Add Row"]

{"sheet":"B117 salt spray ZEK-100","index":5,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
["Test *","Salt spray (ASTM B117) on ZEK-100"]
[]
["SUMMARY"]
[null,"Field Name: * ","cleaner 1","PT 2","PT2.4","PT2.5","PT2.6","PT2.7","PT2.8","PT2.9","+Add Column"]
[null,"Units: * ","mm/days","mm/days","mm/days","mm/days","mm/days","mm/days","mm/days","mm/days"]
[null,"Avg Scribe Creep/ Days Exposed: *",1.3187000000000002,0.45425000000000004,0.43205555555555564,0.49636956521739128,0.42025000000000001,1.3283,1.0643999999999998,0.68449999999999989]
[null,"scribe creep measurement: *","6.59 mm","7.27 mm","3.89 mm","11.42 mm","7.56 mm","6.64 mm","5.32 mm","3.42 mm"]
[null,"Days Exposed: *","5 days","16 days","9 days","23 days","18 days","5 days","5 days","5 days"]
[null,null,"Enter data here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"+Add Row"]
["TEST DATA"]
[null,null,"RAW",null,null,null,null,null,null,null,"+Add Column"]
[null,"Field Name: * ","cleaner 1","PT 2","PT2.4","PT2.5","PT2.6","PT2.7","PT2.8","PT2.9"]
[null,"Units: * ","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"scribe creep measurement: *","6.59 mm","7.27 mm","3.89 mm","11.42 mm","7.56 mm","6.64 mm","5.32 mm","3.42 mm"]
[null,"Days Exposed: *","5 days","16 days","9 days","23 days","18 days","5 days","5 days","5 days"]
[null,null,"Enter data here"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"+Add Row"]

{"sheet":"Cyclic corrosion EFP","index":6,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
["Test *","Cyclic corrosion testing (GMW 14872) on EFP"]
[]
["SUMMARY"]
[null,"Field Name: * ","cleaner 1","PT 2","PT2.4","PT2.5","PT2.6","PT2.7","PT2.8","PT2.9","+Add Column"]
[null,"Units: * ","mm","mm","mm","mm","mm","mm","mm","mm"]
[null,"scribe creep measurement: *",11.565000000000001,5.8083333333333336,13.582500000000001,16.161666666666665,1.8083333333333331,6.7233333333333327,4.1775000000000002,4.8958333333333339]
[]
[null,null,"Enter data here"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"+Add Row"]
[]
["TEST DATA"]
[null,null,"RAW",null,null,null,null,"+Add Column","CALCULATED",null,null,null,null,"+Add Column"]
[null,"Field Name: *","Property Name","Property Name","Property Name","Property Name","Property Name",null,"Property Name","Property Name","Property Name","Property Name","Property Name"]
[null,"Units: *","units","units","units","units","units",null,"units","units","units","units","units"]
[null,"Description: *","description","description","description","description","description",null,"description","description","description","description","description"]
[null,"Valid Min:"]
[null,"Valid Max:"]
[null,"Missing Value:"]
[null,null,"Enter data here"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"+Add Row"]