{"text_format":"3","workbook":"xls","n_sheets":6,"sheets":["Test Pile","Test Pile Page 2","Test Pile Page 3","Pile Record","Pile Record (page 2)","Module1"],"not_rendered":{"macros":1,"external_links":1,"defined_names":13,"comments":5},"unopened":[{"sheet":"Module1","index":5,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Test Pile","index":0,"n_rows":46,"n_cols":18,"rows_kept":46,"flags":["formulas_cached_only"]}
[]
["KENTUCKY TRANSPORTATION CABINET"]
["DEPARTMENT OF HIGHWAYS"]
["DIVISION OF CONSTRUCTION"]
["RECORD OF TEST PILE"]
["Test Pile No"]
["Location of Structure",{"$nulls":12}," Page 1 ",0]
[]
[{"$nulls":4},"Penetration (Feet)","No. of Blows per foot",null,"Average Height of Fall**","Theoretical Bearing (Tons)",null,"Penetration (Feet)","No. of Blows per foot",null,"Average Height of Fall**","Theoretical Bearing Tons"]
[null,"Project Number  ",{"$nulls":15},6]
[null,"Project Code Number  ",{"$nulls":15},"Gravity"]
[null,"County  ",null,null,35,{"$nulls":3}," ",{"$nulls":8},"Single-Acting Air"]
[null,"Road Name  ",null,null,34,{"$nulls":3}," ",null,65,{"$nulls":3}," ",null,null,"Single-Acting Diesel"]
[null,"Bridge Over  ",null,null,33,{"$nulls":3}," ",null,64,{"$nulls":3}," ",null,null,"Double-Acting Air"]
[null,"Station  ",null,null,32,{"$nulls":3}," ",null,63,{"$nulls":3}," ",null,null,"Double-Acting Diesel"]
[null,"Hammer (Size, Make)  ",null,null,31,{"$nulls":3}," ",null,62,{"$nulls":3}," "]
[null,"Formula  "," ",null,30,{"$nulls":3}," ",null,61,{"$nulls":3}," ",null,null,4]
[null,"Actual Stroke Length  ",null,null,29,{"$nulls":3}," ",null,60,{"$nulls":3}," ",null,null,"Vertical"]
[null,"Weight of Ram (lbs.)  ",null,null,28,{"$nulls":3}," ",null,59,{"$nulls":3}," ",null,null,"Batter 3 to 1"]
[null,"Fall (ft)   ",null,null,27,{"$nulls":3}," ",null,58,{"$nulls":3}," ",null,null,"Batter 4 to 1"]
[null,"Type of Pile  ",null,null,26,{"$nulls":3}," ",null,57,{"$nulls":3}," "]
[null,"Orientation  "," ",null,25,{"$nulls":3}," ",null,56,{"$nulls":3}," "]
[null,"Gauge Pressure (psi)   ",null,null,24,{"$nulls":3}," ",null,55,{"$nulls":3}," "]
[null,"Energy/Blow (ft./lbs.) ",null,null,23,{"$nulls":3}," ",null,54,{"$nulls":3}," "]
[null,"Blows Per Minute  ",null,null,22,{"$nulls":3}," ",null,53,{"$nulls":3}," "]
[null,"Plan Bearing (tons) ",null,null,21,{"$nulls":3}," ",null,52,{"$nulls":3}," "]
[null,"Concrete Mix Used  ",null,null,20,{"$nulls":3}," ",null,51,{"$nulls":3}," "]
[null,"Orig. Length of Pile (ft.) ",null,null,19,{"$nulls":3}," ",null,50,{"$nulls":3}," "]
[null,"Build Up (ft.) ",null,null,18,{"$nulls":3}," ",null,49,{"$nulls":3}," "]
[null,"Cut-Off Elevation  ",null,null,17,{"$nulls":3}," ",null,48,{"$nulls":3}," "]
[null,"Cut-Off Length  ",null,null,16,{"$nulls":3}," ",null,47,{"$nulls":3}," "]
[null,"Final Elev. Tip of Pile  "," ",null,15,{"$nulls":3}," ",null,46,{"$nulls":3}," "]
[null,"Pay Length (ft.)  ",{"v":0,"d":"0.00"},null,14,{"$nulls":3}," ",null,45,{"$nulls":3}," "]
[null,"Plan Qty. Length (ft.)  ",null,null,13,{"$nulls":3}," ",null,44,{"$nulls":3}," "]
[null,"Drawing Number  ",null,null,12,{"$nulls":3}," ",null,43,{"$nulls":3}," "]
[null,"Date Driven  ",null,null,11,{"$nulls":3}," ",null,42,{"$nulls":3}," "]
[{"$nulls":4},10,{"$nulls":3}," ",null,41,{"$nulls":3}," "]
[{"$nulls":4},9,{"$nulls":3}," ",null,40,{"$nulls":3}," "]
[{"$nulls":4},8,{"$nulls":3}," ",null,39,{"$nulls":3}," "]
[{"$nulls":4},7,{"$nulls":3}," ",null,38,{"$nulls":3}," "]
[{"$nulls":4},6,{"$nulls":3}," ",null,37,{"$nulls":3}," "]
["Date Submitted",null,"Project Engineer",null,5,{"$nulls":3}," ",null,36,{"$nulls":3}," "]
[{"$nulls":5},"TIP",{"$nulls":8},"  "]
[]
[]
[null,null,"Total Penetration - Last 10 blows ",null,"in.@",null,null,"ft.  Theo. Bearing",{"$nulls":3}," ",null,null,"Tons"]

{"sheet":"Test Pile Page 2","index":1,"n_rows":48,"n_cols":20,"rows_kept":48,"hidden":true,"flags":["formulas_cached_only"]}
[]
[]
["KENTUCKY TRANSPORTATION CABINET"]
["DEPARTMENT OF HIGHWAYS"]
["DIVISION OF CONSTRUCTION"]
["RECORD OF TEST PILE (Cont.)"]
["Test Pile No",{"$nulls":4},0]
["Location in Structure",{"$nulls":4},0,{"$nulls":10},"Page 2 of 2"]
[]
["Penetration (Feet)","No. of Blows per foot",null,"Average Height of Fall**","Theoretical Bearing (Tons)",null,"Penetration (Feet)","No. of Blows per foot",null,"Average Height of Fall**","Theoretical Bearing (Tons)",null,"Penetration (Feet)","No. of Blows per foot",null,"Average Height of Fall**","Theoretical Bearing Tons"]
[{"$nulls":19},6]
[{"$nulls":19},"Gravity"]
[101,{"$nulls":3}," ",null,136,{"$nulls":3}," ",null,171,{"$nulls":3}," ",null,null,"Single-Acting Air"]
[100,{"$nulls":3}," ",null,135,{"$nulls":3}," ",null,170,{"$nulls":3}," ",null,null,"Single-Acting Diesel"]
[99,{"$nulls":3}," ",null,134,{"$nulls":3}," ",null,169,{"$nulls":3}," ",null,null,"Double-Acting Air"]
[98,{"$nulls":3}," ",null,133,{"$nulls":3}," ",null,168,{"$nulls":3}," ",null,null,"Double-Acting Diesel"]
[97,{"$nulls":3}," ",null,132,{"$nulls":3}," ",null,167,{"$nulls":3}," "]
[96,{"$nulls":3}," ",null,131,{"$nulls":3}," ",null,166,{"$nulls":3}," ",null,null,4]
[95,{"$nulls":3}," ",null,130,{"$nulls":3}," ",null,165,{"$nulls":3}," ",null,null,"Vertical"]
[94,{"$nulls":3}," ",null,129,{"$nulls":3}," ",null,164,{"$nulls":3}," ",null,null,"Batter 3 to 1"]
[93,{"$nulls":3}," ",null,128,{"$nulls":3}," ",null,163,{"$nulls":3}," ",null,null,"Batter 4 to 1"]
[92,{"$nulls":3}," ",null,127,{"$nulls":3}," ",null,162,{"$nulls":3}," "]
[91,{"$nulls":3}," ",null,126,{"$nulls":3}," ",null,161,{"$nulls":3}," "]
[90,{"$nulls":3}," ",null,125,{"$nulls":3}," ",null,160,{"$nulls":3}," "]
[89,{"$nulls":3}," ",null,124,{"$nulls":3}," ",null,159,{"$nulls":3}," "]
[88,{"$nulls":3}," ",null,123,{"$nulls":3}," ",null,158,{"$nulls":3}," "]
[87,{"$nulls":3}," ",null,122,{"$nulls":3}," ",null,157,{"$nulls":3}," "]
[86,{"$nulls":3}," ",null,121,{"$nulls":3}," ",null,156,{"$nulls":3}," "]
[85,{"$nulls":3}," ",null,120,{"$nulls":3}," ",null,155,{"$nulls":3}," "]
[84,{"$nulls":3}," ",null,119,{"$nulls":3}," ",null,154,{"$nulls":3}," "]
[83,{"$nulls":3}," ",null,118,{"$nulls":3}," ",null,153,{"$nulls":3}," "]
[82,{"$nulls":3}," ",null,117,{"$nulls":3}," ",null,152,{"$nulls":3}," "]
[81,{"$nulls":3}," ",null,116,{"$nulls":3}," ",null,151,{"$nulls":3}," "]
[80,{"$nulls":3}," ",null,115,{"$nulls":3}," ",null,150,{"$nulls":3}," "]
[79,{"$nulls":3}," ",null,114,{"$nulls":3}," ",null,149,{"$nulls":3}," "]
[78,{"$nulls":3}," ",null,113,{"$nulls":3}," ",null,148,{"$nulls":3}," "]
[77,{"$nulls":3}," ",null,112,{"$nulls":3}," ",null,147,{"$nulls":3}," "]
[76,{"$nulls":3}," ",null,111,{"$nulls":3}," ",null,146,{"$nulls":3}," "]
[75,{"$nulls":3}," ",null,110,{"$nulls":3}," ",null,145,{"$nulls":3}," "]
[74,{"$nulls":3}," ",null,109,{"$nulls":3}," ",null,144,{"$nulls":3}," "]
[73,{"$nulls":3}," ",null,108,{"$nulls":3}," ",null,143,{"$nulls":3}," "]
[72,{"$nulls":3}," ",null,107,{"$nulls":3}," ",null,142,{"$nulls":3}," "]
[71,{"$nulls":3}," ",null,106,{"$nulls":3}," ",null,141,{"$nulls":3}," "]
[70,{"$nulls":3}," ",null,105,{"$nulls":3}," ",null,140,{"$nulls":3}," "]
[69,{"$nulls":3}," ",null,104,{"$nulls":3}," ",null,139,{"$nulls":3}," "]
[68,{"$nulls":3}," ",null,103,{"$nulls":3}," ",null,138,{"$nulls":3}," "]
[67,{"$nulls":3}," ",null,102,{"$nulls":3}," ",null,137,{"$nulls":3}," "]
[{"$nulls":16},"  "]

{"sheet":"Test Pile Page 3","index":2,"n_rows":48,"n_cols":20,"rows_kept":48,"hidden":true,"flags":["formulas_cached_only"]}
[]
[]
["KENTUCKY TRANSPORTATION CABINET"]
["DEPARTMENT OF HIGHWAYS"]
["DIVISION OF CONSTRUCTION"]
["RECORD OF TEST PILE (Cont.)"]
["Test Pile No",{"$nulls":4},0]
["Location in Structure",{"$nulls":4},0,{"$nulls":10},"Page 3 of 3"]
[]
["Penetration (Feet)","No. of Blows per foot",null,"Average Height of Fall**","Theoretical Bearing (Tons)",null,"Penetration (Feet)","No. of Blows per foot",null,"Average Height of Fall**","Theoretical Bearing (Tons)",null,"Penetration (Feet)","No. of Blows per foot",null,"Average Height of Fall**","Theoretical Bearing Tons"]
[{"$nulls":19},6]
[{"$nulls":19},"Gravity"]
[101,{"$nulls":3}," ",null,136,{"$nulls":3}," ",null,171,{"$nulls":3}," ",null,null,"Single-Acting Air"]
[100,{"$nulls":3}," ",null,135,{"$nulls":3}," ",null,170,{"$nulls":3}," ",null,null,"Single-Acting Diesel"]
[99,{"$nulls":3}," ",null,134,{"$nulls":3}," ",null,169,{"$nulls":3}," ",null,null,"Double-Acting Air"]
[98,{"$nulls":3}," ",null,133,{"$nulls":3}," ",null,168,{"$nulls":3}," ",null,null,"Double-Acting Diesel"]
[97,{"$nulls":3}," ",null,132,{"$nulls":3}," ",null,167,{"$nulls":3}," "]
[96,{"$nulls":3}," ",null,131,{"$nulls":3}," ",null,166,{"$nulls":3}," ",null,null,4]
[95,{"$nulls":3}," ",null,130,{"$nulls":3}," ",null,165,{"$nulls":3}," ",null,null,"Vertical"]
[94,{"$nulls":3}," ",null,129,{"$nulls":3}," ",null,164,{"$nulls":3}," ",null,null,"Batter 3 to 1"]
[93,{"$nulls":3}," ",null,128,{"$nulls":3}," ",null,163,{"$nulls":3}," ",null,null,"Batter 4 to 1"]
[92,{"$nulls":3}," ",null,127,{"$nulls":3}," ",null,162,{"$nulls":3}," "]
[91,{"$nulls":3}," ",null,126,{"$nulls":3}," ",null,161,{"$nulls":3}," "]
[90,{"$nulls":3}," ",null,125,{"$nulls":3}," ",null,160,{"$nulls":3}," "]
[89,{"$nulls":3}," ",null,124,{"$nulls":3}," ",null,159,{"$nulls":3}," "]
[88,{"$nulls":3}," ",null,123,{"$nulls":3}," ",null,158,{"$nulls":3}," "]
[87,{"$nulls":3}," ",null,122,{"$nulls":3}," ",null,157,{"$nulls":3}," "]
[86,{"$nulls":3}," ",null,121,{"$nulls":3}," ",null,156,{"$nulls":3}," "]
[85,{"$nulls":3}," ",null,120,{"$nulls":3}," ",null,155,{"$nulls":3}," "]
[84,{"$nulls":3}," ",null,119,{"$nulls":3}," ",null,154,{"$nulls":3}," "]
[83,{"$nulls":3}," ",null,118,{"$nulls":3}," ",null,153,{"$nulls":3}," "]
[82,{"$nulls":3}," ",null,117,{"$nulls":3}," ",null,152,{"$nulls":3}," "]
[81,{"$nulls":3}," ",null,116,{"$nulls":3}," ",null,151,{"$nulls":3}," "]
[80,{"$nulls":3}," ",null,115,{"$nulls":3}," ",null,150,{"$nulls":3}," "]
[79,{"$nulls":3}," ",null,114,{"$nulls":3}," ",null,149,{"$nulls":3}," "]
[78,{"$nulls":3}," ",null,113,{"$nulls":3}," ",null,148,{"$nulls":3}," "]
[77,{"$nulls":3}," ",null,112,{"$nulls":3}," ",null,147,{"$nulls":3}," "]
[76,{"$nulls":3}," ",null,111,{"$nulls":3}," ",null,146,{"$nulls":3}," "]
[75,{"$nulls":3}," ",null,110,{"$nulls":3}," ",null,145,{"$nulls":3}," "]
[74,{"$nulls":3}," ",null,109,{"$nulls":3}," ",null,144,{"$nulls":3}," "]
[73,{"$nulls":3}," ",null,108,{"$nulls":3}," ",null,143,{"$nulls":3}," "]
[72,{"$nulls":3}," ",null,107,{"$nulls":3}," ",null,142,{"$nulls":3}," "]
[71,{"$nulls":3}," ",null,106,{"$nulls":3}," ",null,141,{"$nulls":3}," "]
[70,{"$nulls":3}," ",null,105,{"$nulls":3}," ",null,140,{"$nulls":3}," "]
[69,{"$nulls":3}," ",null,104,{"$nulls":3}," ",null,139,{"$nulls":3}," "]
[68,{"$nulls":3}," ",null,103,{"$nulls":3}," ",null,138,{"$nulls":3}," "]
[67,{"$nulls":3}," ",null,102,{"$nulls":3}," ",null,137,{"$nulls":3}," "]
[{"$nulls":16},"  "]

{"sheet":"Pile Record","index":3,"n_rows":43,"n_cols":20,"rows_kept":43,"flags":["formulas_cached_only"]}
[]
["KENTUCKY TRANSPORTATION CABINET"]
["DEPARTMENT OF HIGHWAYS"]
["DIVISION OF CONSTRUCTION"]
["RECORD OF PILES FURNISHED AND DRIVEN"]
[null,null,"Drawing No.",0,0,{"$nulls":8},"Page 1  ",0,null,"Batter","3 to 1",1.05409,"(4\" to 12\")"]
[null,null,"Project Number",0,null,null,"PCN  ",{"v":0,"d":"00~0000"},"County  ",0,{"$nulls":3},"Location of Structure ",0,null,3,"4 to 1",1.03078,"(3\" to 12\")"]
[null,null,"Road Name",0,{"$nulls":4},"Bridge Over",0,null,null,"Station",0]
[null,null,"Hammer(Size,Make)",0,null,null,"Actual Stroke Lgth.",null,0,null,null,"Weight of Ram  ",0,"lbs.  Fall  ",{"v":0,"d":"0.00"}]
[null,null,"Type of Pile",0,null,null,"Batter  "," ",null,null,"Gauge Pressure  ",{"v":0,"d":"0.00"},null,"Energy/Blow  ",0]
[]
[{"$nulls":4},"Original",{"$nulls":7},"Pene.","Avg. Fall"]
[null,"Pile",null,"Date","Length","Build","Cut-Off","Cut-Off","Final Elev.","Pay Length",null,null,"Last 10 ","Last 10","Bearing"]
[null,"No.","Orien.","Driven","of Pile","Up","Elev.","Length","Tip of Pile","Test","Production","Heat","Blows","Blows","Capacity"]
[{"$nulls":4},"(Feet)","(Feet)","(Feet)","(Feet)","(Feet)","(Feet)","(Feet)","(Steel Pile)","(Inches)","(Feet)","(Tons)"]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":3},"Total This Page  ","","","----","","----","","","----","----","---","---"]
[{"$nulls":3},"Total Continuation Page(s)  ","0.00","0.00","----","0.00","","0.00","0.00","----","----","----","---"]
[{"$nulls":3},"Grand Total  ",{"v":0,"d":"0.00)"},{"v":0,"d":"0.00"},"----",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"----","----","----","---"]
[]
["cc:  ","District TEBM for Construction",{"$nulls":5},"Submitted By:"]
[null,"Division of Construction",{"$nulls":6},"Project Engineer",{"$nulls":4},"Date"]
[{"$nulls":7},"Checked By:"]
[{"$nulls":8},"District TEBM for Construction",{"$nulls":4},"Date"]

{"sheet":"Pile Record (page 2)","index":4,"n_rows":45,"n_cols":20,"rows_kept":45,"hidden":true,"merged":[[6,13,6,14]],"flags":["formulas_cached_only"]}
[]
[]
["KENTUCKY TRANSPORTATION CABINET"]
["DEPARTMENT OF HIGHWAYS"]
["DIVISION OF CONSTRUCTION"]
["RECORD OF PILES FURNISHED AND DRIVEN (Cont.)"]
[null,null,"Drawing No.",0,{"$nulls":12},"Batter","3 to 1",1.05409,"(4\" to 12\")"]
[null,null,"Project Number",0,null,null,"PCN  ",{"v":0,"d":"00~0000"},"County  ",0,{"$nulls":3},"Location of Structure",0,null,3,"4 to 1",1.03078,"(3\" to 12\")"]
[null,null,"Road Name",0,{"$nulls":4},"Bridge Over",0,null,null,"Station",0]
[null,null,"Hammer(Size,Make)",0,null,null,"Actual Stroke Lgth.",null,0,null,null,"Weight of Ram  ",0,"lbs.       Fall  ",{"v":0,"d":"0.00"}]
[null,null,"Type of Pile",0,null,null,"Batter  "," ",{"$nulls":3},"Gauge Pressure  ",{"v":0,"d":"0.00"},"Energy/Blow",0]
[]
[{"$nulls":4},"Original",{"$nulls":7},"Pene.","Avg. Fall"]
[null,"Pile",null,"Date","Length","Build","Cut-Off","Cut-Off","Final Elev.","Pay Length",null,null,"Last 10 ","Last 10","Bearing"]
[null,"No.","Orien.","Driven","of Pile","Up","Elev.","Length","Tip of Pile","Test","Production","Heat","Blows","Blows","Capacity"]
[{"$nulls":4},"(Feet)","(Feet)","(Feet)","(Feet)","(Feet)","(Feet)","(Feet)","(Steel Pile)","(Inches)","(Feet)","(Tons)"]
[{"$nulls":8},"","","",{"$nulls":3}," "," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":8},"","","",{"$nulls":3}," "]
[{"$nulls":3},"Total This Page  ",{"v":0,"d":"0.00)"},{"v":0,"d":"0.00"},"----",{"v":0,"d":"0.00"},"",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"----","----","----","----"]