{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Enter Your Data","Copy Me","Lists"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"Enter Your Data","index":0,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Scan Your Barcode Below","Label ID","Text ID","Intstrument","Raw Instrument Value","Offset (cm)","Adapter","Direction","Strength (KG/CM2)","Comment"]
[null,{"$f":"IF(A2<>\"\",MID(A2,SEARCH(CHAR(34),A2,1)+1,SEARCH(CHAR(34),A2,15)-SEARCH(CHAR(34),A2,1)-1),\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,{"$f":"IF(E2=\"\",\"\", IF(AND(D2=\"Penetrometer\",G2=\"YES\"),E2/16,IF(G2=\"NO\",E2,G2*E2)))","v":""}]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]
[null,"",{"$f":"IF(Table3[[#This Row],[Scan Your Barcode Below]]<>\"\",LEFT(Table3[[#This Row],[Scan Your Barcode Below]], SEARCH(\",\",Table3[[#This Row],[Scan Your Barcode Below]],1)-1),\"\")","v":""},null,null,null,null,null,""]

{"sheet":"Copy Me","index":1,"n_rows":25,"n_cols":23,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Text ID","Analysis","Replicate","Instrument","Display Flag","Component Name (shear or compression strength)","Component Value","Component Unit","Component Name (direction)","Component Value","Component Unit","Component Name (Offset)","Component Value","Component Unit","Component Name (Adapter)","Component Value","Component Unit","Component Name (Strength Calc)","Component Value","Component Unit","Component Name (comments)","Component Value","Component Unit"]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},{"$f":"IF(A2<>\"\",\"T\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},{"$f":"IF(A3<>\"\",\"T\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},"",{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},"",{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},"",{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},"",{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},"",{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},"",{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},"",{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},"",{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},"",{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},"",{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},"",{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},"",{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},"",{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},"",{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},"",{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},"",{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},"",{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},"",{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},"",{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},"",{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},"",{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]
[{"$f":"Table3[[#This Row],[Text ID]]","v":""},{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETRATE\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TOR_SHEAR\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"PENETROMR\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"TORVANE\",\"\"))","v":""},"",{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"raw_instrument_reading\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"raw_instrument_reading\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Strength (KG/CM2)]]<>\"\",Table3[[#This Row],[Raw Instrument Value]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Direction]]<>\"\",\"penetration_direction\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Direction]]=\"X-AXIS\",\"X-POS\",IF(Table3[[#This Row],[Direction]]=\"Z-AXIS\",\"Z-POS\",\"\"))","v":""},null,{"$f":"IF(Table3[[#This Row],[Offset (cm)]]<>\"\",\"offset\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Offset (cm)]],Table3[[#This Row],[Offset (cm)]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"adapter_foot\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"adapter_id\",\"\"))","v":""},{"$f":"IF(Table3[[#This Row],[Adapter]]<>\"\",Table3[[#This Row],[Adapter]],\"\")","v":""},null,{"$f":"IF(Table3[[#This Row],[Intstrument]]=\"Penetrometer\",\"compression_strength\",IF(Table3[[#This Row],[Intstrument]]=\"Torvane\",\"shear_strength\",\"\"))","v":""},{"$f":"Table3[[#This Row],[Strength (KG/CM2)]]","v":""},null,{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",\"comment\",\"\")","v":""},{"$f":"IF(Table3[[#This Row],[Comment]]<>\"\",Table3[[#This Row],[Comment]],\"\")","v":""}]

{"sheet":"Lists","index":2,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Analysis","Instrument","Penetration Direction","Adapter Foot (Y/N)","Adapter IDs"]
["PENETRATE","Penetrometer","X-AXIS","YES",0.2]
["TOR_SHEAR","Torvane","Z-AXIS","NO",1]
[null,null,null,null,2.5]