{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Intro","Input Prices","Braces","Barbed Wire","Woven Wire","HT Fixed Knot","HT Electric","Poly Fence"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":14,"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":"Intro","index":0,"n_rows":43,"n_cols":18,"rows_kept":43,"cut":false,"hidden":false,"merged":[[10,1,10,13],[5,1,5,13],[4,1,4,13],[7,1,7,13],[8,1,8,13],[9,1,9,13],[15,2,34,12],[40,2,40,12],[41,2,41,12],[42,2,42,12],[12,3,12,5],[13,3,13,5],[12,9,12,12]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-10-22"]
[]
[]
[]
[null,"Fencing Budgets Calculator"]
[null,"Version 4.0a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Directory "]
[null,"David Bilderback",null,null,null,null,null,null,null,null,null,null,null,null,"Input Prices"]
[null,"Extension  Specialist",null,null,null,null,null,null,null,null,null,null,null,null,"Barbed Wire"]
[null,"Office: (865) 200-4545",null,null,null,null,null,null,null,null,null,null,null,null,"Woven Wire"]
[null,"Email: db@utk.edu",null,null,null,null,null,null,null,null,null,null,null,null,"HT Fixed Knot"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HT Electric"]
[null,null,null,"Becky Bowling",null,null,null,null,null,"Bob Moncier ",null,null,null,null,"Poly Fence"]
[null,null,null,"Extension Specialist",null,null,null,null,null," Extension Agent III - Hawkins"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Programs in agriculture and natural resources, 4-H youth development, family and consumer sciences, and resource development."]
[null,null,"University of Tennessee Institute of Agriculture, U.S. Department of Agriculture and country governments cooperating."]
[null,null,"UT Extension provide equal opportunities in programs and employment."]

{"sheet":"Input Prices","index":1,"n_rows":153,"n_cols":11,"rows_kept":153,"cut":false,"hidden":false,"merged":[[0,0,0,6],[3,10,3,12]]}
["Materials Cost "]
[]
[null,null,null,null,null,null,null,null,null,null,"Directory"]
["Materials ",null,"Price",null,null,null,null,null,null,"Password - fence","Intro"]
[null,null,null,null,null,null,null,null,null,null,"Barbed Wire"]
["8' Post 6\"-7\"","ea.",17.5,null,null,null,null,null,null,null,"Woven Wire"]
["8' Posts 5\"-6\"","ea.",14.99,null,null,null,null,null,null,null,"HT Fixed Knot"]
["8' Post 4\"-5\"","ea.",11.99,null,null,null,null,null,null,null,"HT Electric"]
["8' Brace Post 4\"-5\"","ea.",11.99,null,null,null,null,null,null,null,"Poly Fence"]
["10' Brace Post 4\"-5\"","ea.",25.99]
["Wire Conv. 1047-6-11","roll",367,330,"feet in roll",{"$f":"C11/D11","v":1.1121212121212121},"per foot"]
["Wire HT 1047-6-12.5","roll",275,330,"feet in roll",{"$f":"C12/D12","v":0.83333333333333337},"per foot"]
["Wire HT 949-6 Fixed Knot","roll",279,330,"feet in roll",0.84545454545454546,"per foot"]
["Barbed Wire - Conv. 12 1/2","roll",135,1320,"feet in roll",0.10227272727272728,"per foot"]
["Barbed Wire - HT 15 1/2","roll",59.99,1320,"feet in roll",4.5446969696969701E-2,"per foot"]
["Gate - 14'","ea.",181]
["Brace pins 1 - 10\" & 1 - 5\"","ea.",2.16]
["Brace Wire","ft.",139.99,4000,"feet in roll",{"$f":"C18/D18","v":3.4997500000000001E-2},"per foot"]
["High Tensile Wire 12.5 Gauge","ft.",139.99,4000,"feet in roll",{"$f":"C19/D19","v":3.4997500000000001E-2},"per foot"]
["Springs","ea.",10.99]
["Inline Strainers","ea.",3.49]
["Battens 40\"","ea.",3.95]
["Batten Clips","ea.",0.06]
["Insulators ","ea.",0.3]
["Long Crimp Sleeves","ea.",0.3]
["Bull Nose Insulators","ea.",1.6]
["Staples - Barbed For HT","lbs.",2.35]
["Staples - Standards","lbs.",1.99]
["T-Posts 6 FT","ea.",4.99]
["T-Post Clips","ea.",7.0000000000000007E-2]
["Step-in Fiberglass Post","ea.",2.69]
["Polywire","roll",35.99,1312,"feet in roll",{"$f":"C32/D32","v":2.743140243902439E-2},"per foot"]
["Polytape","roll",33,660,"feet in roll",{"$f":"C33/D33","v":0.05},"per foot"]
["Cut-Out Switch","ea.",15.99]
["Reel","ea.",39]
["Handle ","ea.",3.99]
["Electric Fence Charger ","ea.",229]
["Ground Rods and Clamps ","ea.",20]
["Materials Sales Tax ","%",9.4500000000000001E-2]
[]
[]
["Fencing Tools  "]
["T-Post Driver",null,44]
["Barb Wire Roller",null,7.99]
["Multi-Purpose Fence Pliers",null,16.989999999999998]
["3⁄8\" Ship Auger Drill Bit",null,28.99]
["Strainer Handle",null,5.99]
["Come along",null,23.99]
["Stretcher bar",null,139.75]
["Chain ",null,60]
["Multi-Function Fencing Tool",null,69.75]
["Spinning Jenny",null,34.99]
[]
[]
[]
["Average Annual Maintenance (%)",null,0.05]
["Interest Rate on Investment",null,0.06]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Materials ",null,"Price"]
[]
["8' Post 6\"-7\"","ea.",17.5]
["8' Posts 5\"-6\"","ea.",14.99]
["8' Post 4\"-5\"","ea.",11.99]
["8' Brace Post 4\"-5\"","ea.",11.99]
["10' Brace Post 4\"-5\"","ea.",25.99]
["Wire Conv. 1047-6-11","roll",367,330,"feet in roll",{"$f":"C107/D107","v":1.1121212121212121},"per foot"]
["Wire HT 1047-6-12.5","roll",275,330,"feet in roll",{"$f":"C108/D108","v":0.83333333333333337},"per foot"]
["Wire HT 949-6 Fixed Knot","roll",279,330,"feet in roll",0.84545454545454546,"per foot"]
["Barbed Wire - Conv. 12 1/2","roll",135,1320,"feet in roll",0.10227272727272728,"per foot"]
["Barbed Wire - HT 15 1/2","roll",59.99,1320,"feet in roll",4.5446969696969701E-2,"per foot"]
["Gate - 14'","ea.",181]
["Brace pins 1 - 10\" & 1 - 5\"","ea.",2.16]
["Brace Wire","ft.",139.99,4000,"feet in roll",{"$f":"C114/D114","v":3.4997500000000001E-2},"per foot"]
["High Tensile Wire 12.5 Gauge","ft.",139.99,4000,"feet in roll",{"$f":"C115/D115","v":3.4997500000000001E-2},"per foot"]
["Springs","ea.",10.99]
["Inline Strainers","ea.",3.49]
["Battens 40\"","ea.",3.95]
["Batten Clips","ea.",0.06]
["Insulators ","ea.",0.3]
["Long Crimp Sleeves","ea.",0.3]
["Bull Nose Insulators","ea.",1.6]
["Staples - Barbed For HT","lbs.",2.35]
["Staples - Standards","lbs.",1.99]
["T-Posts 6 FT","ea.",4.99]
["T-Post Clips","ea.",7.0000000000000007E-2]
["Step-in Fiberglass Post","ea.",2.69]
["Polywire","roll",35.99,1312,"feet in roll",{"$f":"C128/D128","v":2.743140243902439E-2},"per foot"]
["Polytape","roll",33,660,"feet in roll",{"$f":"C129/D129","v":0.05},"per foot"]
["Cut-Out Switch","ea.",15.99]
["Reel","ea.",39]
["Handle ","ea.",3.99]
["Electric Fence Charger ","ea.",229]
["Ground Rods and Clamps ","ea.",20]
["Materials Sales Tax ","%",9.4500000000000001E-2]
[]
[]
["Fencing Tools  "]
["T-Post Driver",null,44]
["Barb Wire Roller",null,7.99]
["Multi-Purpose Fence Pliers",null,16.989999999999998]
["3⁄8\" Ship Auger Drill Bit",null,28.99]
["Strainer Handle",null,5.99]
["Come along",null,23.99]
["Stretcher bar",null,139.75]
["Chain ",null,60]
["Multi-Function Fencing Tool",null,69.75]
["Spinning Jenny",null,34.99]
[]
[]
[]
["Average Annual Maintenance (%)",null,0.05]
["Interest Rate on Investment",null,0.06]

{"sheet":"Braces","index":2,"n_rows":90,"n_cols":7,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
[]
["8 ft H Brace ",null,null,null,8]
["ITEM","UNIT","PRICE","QUANTITY","TOTAL"]
["8' Post 6\"-7\"","ea",{"$f":"'Input Prices'!C6","v":17.5},2,{"$f":"C4*D4","v":35}]
["8' Brace Post 4\"-5\"","ea",{"$f":"'Input Prices'!C9","v":11.99},1,{"$f":"C5*D5","v":11.99}]
["Inline Strainers","ea",{"$f":"'Input Prices'!C21","v":3.49},1,3.49]
["Brace pins 1 - 10\" & 1 - 5\"","ea",{"$f":"'Input Prices'!C17","v":2.16},1,2.16]
["Brace Wire","ft",{"$f":"'Input Prices'!F18","v":3.4997500000000001E-2},30,1.049925]
[null,null,null,null,{"$f":"SUM(E4:E8)","v":53.689925000000002}]
[]
[]
[]
["10 ft H Brace ",null,null,null,8]
["ITEM","UNIT","PRICE","QUANTITY","TOTAL"]
["8' Post 6\"-7\"","ea",{"$f":"'Input Prices'!C6","v":17.5},2,{"$f":"C15*D15","v":35}]
["10' Brace Post 4\"-5\"","ea",{"$f":"'Input Prices'!C10","v":25.99},1,{"$f":"C16*D16","v":25.99}]
["Inline Strainers","ea",{"$f":"'Input Prices'!C21","v":3.49},1,3.49]
["Brace pins 1 - 10\" & 1 - 5\"","ea",{"$f":"'Input Prices'!C17","v":2.16},1,2.16]
["Brace Wire","ft",{"$f":"'Input Prices'!F18","v":3.4997500000000001E-2},45,1.5748875]
[null,null,null,null,{"$f":"SUM(E15:E19)","v":68.214887499999989}]
[]
[]
[]
["8 ft Double H Brace ",null,null,null,16,null,"Barbed"]
["ITEM","UNIT","PRICE","QUANTITY","TOTAL",null,1]
["8' Post 6\"-7\"","ea",{"$f":"'Input Prices'!C6","v":17.5},3,{"$f":"C26*D26","v":52.5},null,"8 ft H Brace"]
["8' Brace Post 4\"-5\"","ea",{"$f":"'Barbed Wire'!C15","v":11.99},2,{"$f":"C27*D27","v":23.98},null,"10 ft H Brace"]
["Inline Strainers","ea",{"$f":"'Input Prices'!C21","v":3.49},2,6.98,null,"8 ft Double H Brace"]
["Brace pins 1 - 10\" & 1 - 5\"","ea",{"$f":"'Input Prices'!C17","v":2.16},2,4.32]
["Brace Wire","ft",{"$f":"'Input Prices'!F18","v":3.4997500000000001E-2},60,2.09985]
[null,null,null,null,{"$f":"SUM(E26:E30)","v":89.879850000000005},null,"Woven"]
[null,null,null,null,null,null,1]
[null,null,null,null,null,null,"8 ft H Brace"]
[null,null,null,null,null,null,"10 ft H Brace"]
[null,null,null,null,null,null,"8 ft Double H Brace"]
[]
["Barbed Wire"]
[null,null,null,null,null,null,"HT Fixed Knot"]
[{"$f":"IF($G$25=1,\"8 ft H Brace\",IF($G$25=2,\"10 ft H Brace\",IF($G$25=3,\"8 ft Double H Brace\",\" \")))","v":"8 ft H Brace"},null,null,null,{"$f":"IF($G$25=1,8,IF($G$25=2,8,IF($G$25=3,16,\" \")))","v":8},null,1]
["ITEM","UNIT","PRICE","QUANTITY","TOTAL",null,"8 ft H Brace"]
["8' Post 6\"-7\"","ea",{"$f":"'Input Prices'!C6","v":17.5},{"$f":"IF($G$25=1,2,IF($G$25=2,2,IF($G$25=3,3,\" \")))","v":2},{"$f":"C41*D41","v":35},null,"10 ft H Brace"]
[{"$f":"IF($G$25=1,+'Input Prices'!A9,IF($G$25=2,+'Input Prices'!A10,IF($G$25=3,+'Input Prices'!A9,\" \")))","v":"8' Brace Post 4\"-5\""},"ea",{"$f":"IF($G$25=1,+'Input Prices'!C9,IF($G$25=2,+'Input Prices'!C10,IF($G$25=3,+'Input Prices'!C9,\" \")))","v":11.99},{"$f":"IF($G$25=1,1,IF($G$25=2,1,IF($G$25=3,2,\" \")))","v":1},{"$f":"C42*D42","v":11.99},null,"8 ft Double H Brace"]
["Inline Strainers","ea",{"$f":"'Input Prices'!C21","v":3.49},{"$f":"IF($G$25=1,1,IF($G$25=2,1,IF($G$25=3,2,\" \")))","v":1},3.49]
["Brace pins 1 - 10\" & 1 - 5\"","ea",{"$f":"'Input Prices'!C17","v":2.16},{"$f":"IF($G$25=1,1,IF($G$25=2,1,IF($G$25=3,2,\" \")))","v":1},2.16]
["Brace Wire","ft",{"$f":"'Input Prices'!F18","v":3.4997500000000001E-2},{"$f":"IF($G$25=1,30,IF($G$25=2,45,IF($G$25=3,60,\" \")))","v":30},1.049925,null,"HT Electric"]
[null,null,null,null,{"$f":"SUM(E41:E45)","v":53.689925000000002},null,1]
[null,null,null,null,null,null,"8 ft H Brace"]
["Woven Wire",null,null,null,null,null,"10 ft H Brace"]
[null,null,null,null,null,null,"8 ft Double H Brace"]
[{"$f":"IF($G$32=1,\"8 ft H Brace\",IF($G$32=2,\"10 ft H Brace\",IF($G$32=3,\"8 ft Double H Brace\",\" \")))","v":"8 ft H Brace"},null,null,null,{"$f":"IF($G$32=1,8,IF($G$32=2,8,IF($G$32=3,16,\" \")))","v":8}]
["ITEM","UNIT","PRICE","QUANTITY","TOTAL"]
["8' Post 6\"-7\"","ea",{"$f":"'Input Prices'!C6","v":17.5},{"$f":"IF($G$32=1,2,IF($G$32=2,2,IF($G$32=3,3,\" \")))","v":2},{"$f":"C52*D52","v":35},null,"Poly"]
[{"$f":"IF($G$32=1,+'Input Prices'!A9,IF($G$32=2,+'Input Prices'!A10,IF($G$32=3,+'Input Prices'!A9,\" \")))","v":"8' Brace Post 4\"-5\""},"ea",{"$f":"IF($G$32=1,+'Input Prices'!C9,IF($G$32=2,+'Input Prices'!C10,IF($G$32=3,+'Input Prices'!C9,\" \")))","v":11.99},{"$f":"IF($G$32=1,1,IF($G$32=2,1,IF($G$32=3,2,\" \")))","v":1},{"$f":"C53*D53","v":11.99},null,2]
["Inline Strainers","ea",{"$f":"'Input Prices'!C21","v":3.49},{"$f":"IF($G$32=1,1,IF($G$32=2,1,IF($G$32=3,2,\" \")))","v":1},3.49,null,"8 ft H Brace"]
["Brace pins 1 - 10\" & 1 - 5\"","ea",{"$f":"'Input Prices'!C17","v":2.16},{"$f":"IF($G$32=1,1,IF($G$32=2,1,IF($G$32=3,2,\" \")))","v":1},2.16,null,"10 ft H Brace"]
["Brace Wire","ft",{"$f":"'Input Prices'!F18","v":3.4997500000000001E-2},{"$f":"IF($G$32=1,30,IF($G$32=2,45,IF($G$32=3,60,\" \")))","v":30},1.049925,null,"8 ft Double H Brace"]
[null,null,null,null,{"$f":"SUM(E52:E56)","v":53.689925000000002}]
[]
["HT Fixed Knot"]
[]
[{"$f":"IF($G$39=1,\"8 ft H Brace\",IF($G$39=2,\"10 ft H Brace\",IF($G$39=3,\"8 ft Double H Brace\",\" \")))","v":"8 ft H Brace"},null,null,null,{"$f":"IF($G$39=1,8,IF($G$39=2,8,IF($G$39=3,16,\" \")))","v":8}]
["ITEM","UNIT","PRICE","QUANTITY","TOTAL"]
["8' Post 6\"-7\"","ea",{"$f":"'Input Prices'!C6","v":17.5},{"$f":"IF($G$39=1,2,IF($G$39=2,2,IF($G$39=3,3,\" \")))","v":2},{"$f":"C63*D63","v":35}]
[{"$f":"IF($G$39=1,+'Input Prices'!A9,IF($G$39=2,+'Input Prices'!A10,IF($G$39=3,+'Input Prices'!A9,\" \")))","v":"8' Brace Post 4\"-5\""},"ea",{"$f":"IF($G$39=1,+'Input Prices'!C9,IF($G$39=2,+'Input Prices'!C10,IF($G$39=3,+'Input Prices'!C9,\" \")))","v":11.99},{"$f":"IF($G$39=1,1,IF($G$39=2,1,IF($G$39=3,2,\" \")))","v":1},{"$f":"C64*D64","v":11.99}]
["Inline Strainers","ea",{"$f":"'Input Prices'!C21","v":3.49},{"$f":"IF($G$39=1,1,IF($G$39=2,1,IF($G$39=3,2,\" \")))","v":1},3.49]
["Brace pins 1 - 10\" & 1 - 5\"","ea",{"$f":"'Input Prices'!C17","v":2.16},{"$f":"IF($G$39=1,1,IF($G$39=2,1,IF($G$39=3,2,\" \")))","v":1},2.16]
["Brace Wire","ft",{"$f":"'Input Prices'!F18","v":3.4997500000000001E-2},{"$f":"IF($G$39=1,30,IF($G$39=2,45,IF($G$39=3,60,\" \")))","v":30},1.049925]
[null,null,null,null,{"$f":"SUM(E63:E67)","v":53.689925000000002}]
[]
["HT Electric"]
[]
[{"$f":"IF($G$46=1,\"8 ft H Brace\",IF($G$46=2,\"10 ft H Brace\",IF($G$46=3,\"8 ft Double H Brace\",\" \")))","v":"8 ft H Brace"},null,null,null,{"$f":"IF($G$46=1,8,IF($G$46=2,8,IF($G$46=3,16,\" \")))","v":8}]
["ITEM","UNIT","PRICE","QUANTITY","TOTAL"]
["8' Post 6\"-7\"","ea",{"$f":"'Input Prices'!C6","v":17.5},{"$f":"IF($G$46=1,2,IF($G$46=2,2,IF($G$46=3,3,\" \")))","v":2},{"$f":"C74*D74","v":35}]
[{"$f":"IF($G$46=1,+'Input Prices'!A9,IF($G$46=2,+'Input Prices'!A10,IF($G$46=3,+'Input Prices'!A9,\" \")))","v":"8' Brace Post 4\"-5\""},"ea",{"$f":"IF($G$46=1,+'Input Prices'!C9,IF($G$46=2,+'Input Prices'!C10,IF($G$46=3,+'Input Prices'!C9,\" \")))","v":11.99},{"$f":"IF($G$46=1,1,IF($G$46=2,1,IF($G$46=3,2,\" \")))","v":1},{"$f":"C75*D75","v":11.99}]
["Inline Strainers","ea",{"$f":"'Input Prices'!C21","v":3.49},{"$f":"IF($G$46=1,1,IF($G$46=2,1,IF($G$46=3,2,\" \")))","v":1},3.49]
["Brace pins 1 - 10\" & 1 - 5\"","ea",{"$f":"'Input Prices'!C17","v":2.16},{"$f":"IF($G$46=1,1,IF($G$46=2,1,IF($G$46=3,2,\" \")))","v":1},2.16]
["Brace Wire","ft",{"$f":"'Input Prices'!F18","v":3.4997500000000001E-2},{"$f":"IF($G$46=1,30,IF($G$46=2,45,IF($G$46=3,60,\" \")))","v":30},1.049925]
[null,null,null,null,{"$f":"SUM(E74:E78)","v":53.689925000000002}]
[]
["Poly"]
[]
[{"$f":"IF($G$53=1,\"8 ft H Brace\",IF($G$53=2,\"10 ft H Brace\",IF($G$53=3,\"8 ft Double H Brace\",\" \")))","v":"10 ft H Brace"},null,null,null,{"$f":"IF($G$53=1,8,IF($G$53=2,8,IF($G$53=3,16,\" \")))","v":8}]
["ITEM","UNIT","PRICE","QUANTITY","TOTAL"]
["8' Post 6\"-7\"","ea",{"$f":"'Input Prices'!C6","v":17.5},{"$f":"IF($G$53=1,2,IF($G$53=2,2,IF($G$53=3,3,\" \")))","v":2},{"$f":"C85*D85","v":35}]
[{"$f":"IF($G$53=1,+'Input Prices'!A9,IF($G$53=2,+'Input Prices'!A10,IF($G$53=3,+'Input Prices'!A9,\" \")))","v":"10' Brace Post 4\"-5\""},"ea",{"$f":"IF($G$53=1,+'Input Prices'!C9,IF($G$53=2,+'Input Prices'!C10,IF($G$53=3,+'Input Prices'!C9,\" \")))","v":25.99},{"$f":"IF($G$53=1,1,IF($G$53=2,1,IF($G$53=3,2,\" \")))","v":1},{"$f":"C86*D86","v":25.99}]
["Inline Strainers","ea",{"$f":"'Input Prices'!C21","v":3.49},{"$f":"IF($G$53=1,1,IF($G$53=2,1,IF($G$53=3,2,\" \")))","v":1},3.49]
["Brace pins 1 - 10\" & 1 - 5\"","ea",{"$f":"'Input Prices'!C17","v":2.16},{"$f":"IF($G$53=1,1,IF($G$53=2,1,IF($G$53=3,2,\" \")))","v":1},2.16]
["Brace Wire","ft",{"$f":"'Input Prices'!F18","v":3.4997500000000001E-2},{"$f":"IF($G$53=1,30,IF($G$53=2,45,IF($G$53=3,60,\" \")))","v":45},1.5748875]
[null,null,null,null,{"$f":"SUM(E85:E89)","v":68.214887499999989}]

{"sheet":"Barbed Wire","index":3,"n_rows":164,"n_cols":11,"rows_kept":164,"cut":false,"hidden":false,"merged":[[2,10,2,12],[9,6,9,8],[9,3,9,4],[3,10,3,12],[2,0,2,4],[7,1,7,2],[6,0,6,1],[30,0,30,3],[31,0,31,3],[89,0,89,4],[94,1,94,2],[96,3,96,4],[40,0,40,3],[33,0,33,3],[34,0,34,3],[36,0,36,3],[37,0,37,3],[39,0,39,3],[117,0,117,2],[118,0,118,2],[127,0,127,2],[120,0,120,2],[121,0,121,2],[123,0,123,2],[124,0,124,2],[126,0,126,2]]}
[]
[null,null,null,null,null,null,null,null,null,null,"Directory"]
["Barbed Wire",null,null,null,null,null,null,null,null,null,"Intro"]
[null,4,"Strand",null,null,null,null,null,null,null,"Input Prices"]
[null,1000,"Feet",null,null,null,null,null,null,null,"Woven Wire"]
[null,1,"Gates",null,null,null,null,null,null,null,"HT Fixed Knot"]
[null,null,"Brace Type",null,null,null,null,null,null,null,"HT Electric"]
[null,"Brace Adjustment",null,null,null,null,null,null,null,null,"Poly Fence"]
[null,{"$f":"$C$84","v":4},"Braces"]
[null,null,null,null,null,null,"Your Cost "]
["ITEM","UNIT","PRICE","QUANTITY","TOTAL"]
[{"$f":"'Input Prices'!A6","v":"8' Post 6\"-7\""},{"$f":"'Input Prices'!B6","v":"ea."},{"$f":"'Input Prices'!$C$6","v":17.5},{"$f":"$B$9*Braces!$D$41","v":8},{"$f":"IF(D12>0,$C12*D12,0)","v":140}]
[{"$f":"'Input Prices'!A7","v":"8' Posts 5\"-6\""},{"$f":"'Input Prices'!B7","v":"ea."},{"$f":"'Input Prices'!$C$7","v":14.99},0,0]
[{"$f":"'Input Prices'!A8","v":"8' Post 4\"-5\""},{"$f":"'Input Prices'!B8","v":"ea."},{"$f":"'Input Prices'!$C$8","v":11.99},{"$f":"IF(ROUNDUP(((B$5-((B$9*Braces!$E$39)+(B$6*14)))/72)-(IF(C$82>2,C$82-2,2)),0)<0,0,ROUNDUP(((B$5-((B$9*Braces!$E$39)+(B$6*14)))/72)-(IF(C$82>2,C$82-2,2)),0))","v":13},155.87]
[{"$f":"+Braces!$A$42","v":"8' Brace Post 4\"-5\""},{"$f":"'Input Prices'!B9","v":"ea."},{"$f":"+Braces!C42","v":11.99},{"$f":"$B$9*Braces!$D$42","v":4},47.96]
[{"$f":"'Input Prices'!A29","v":"T-Posts 6 FT"},{"$f":"'Input Prices'!B29","v":"ea."},{"$f":"'Input Prices'!$C$29","v":4.99},{"$f":"ROUNDUP(((B$5-((B$9*Braces!$E$39)+(B$6*14)))/12)-D$14,0)","v":67},334.33000000000004]
[{"$f":"'Input Prices'!A14","v":"Barbed Wire - Conv. 12 1/2"},"ft.",{"$f":"'Input Prices'!$F$14","v":0.10227272727272728},0,0]
[{"$f":"'Input Prices'!A15","v":"Barbed Wire - HT 15 1/2"},"ft.",{"$f":"'Input Prices'!$F$15","v":4.5446969696969701E-2},{"$f":"SUM($B$4*$B$5)","v":4000},181.78787878787881]
[{"$f":"'Input Prices'!A17","v":"Brace pins 1 - 10\" & 1 - 5\""},{"$f":"'Input Prices'!B17","v":"ea."},{"$f":"'Input Prices'!$C$17","v":2.16},{"$f":"$B$9*Braces!$D$44","v":4},8.64]
[{"$f":"'Input Prices'!A18","v":"Brace Wire"},{"$f":"'Input Prices'!B18","v":"ft."},{"$f":"'Input Prices'!$F$18","v":3.4997500000000001E-2},{"$f":"$B$9*Braces!$D$45","v":120},4.1997]
[{"$f":"'Input Prices'!A21","v":"Inline Strainers"},{"$f":"'Input Prices'!B21","v":"ea."},{"$f":"'Input Prices'!$C$21","v":3.49},{"$f":"$B$9*Braces!$D$43","v":4},13.96]
[{"$f":"'Input Prices'!A16","v":"Gate - 14'"},{"$f":"'Input Prices'!B16","v":"ea."},{"$f":"'Input Prices'!$C$16","v":181},{"$f":"$B$6","v":1},181]
[{"$f":"'Input Prices'!A30","v":"T-Post Clips"},{"$f":"'Input Prices'!B30","v":"ea."},{"$f":"'Input Prices'!$C$30","v":7.0000000000000007E-2},{"$f":"$D$16*$B$4","v":268},18.760000000000002]
[{"$f":"'Input Prices'!A28","v":"Staples - Standards"},{"$f":"'Input Prices'!B28","v":"lbs."},{"$f":"'Input Prices'!$C$28","v":1.99},{"$f":"SUM($D$12:$D$14)*0.15","v":3.15},6.2684999999999995]
["Other ","unit",0,0,{"$f":"IF(D25>0,$C25*D25,0)","v":0}]
["Other ","unit",0,0,{"$f":"IF(D26>0,$C26*D26,0)","v":0}]
["Other ","unit",0,0,{"$f":"IF(D27>0,$C27*D27,0)","v":0}]
["Other ","unit",0,0,{"$f":"IF(D28>0,$C28*D28,0)","v":0}]
[{"$f":"'Input Prices'!A39","v":"Materials Sales Tax "},{"$f":"'Input Prices'!B39","v":"%"},{"$f":"'Input Prices'!$C$39","v":9.4500000000000001E-2},null,{"$f":"SUM(E12:E28)*($C$29)","v":103.26733944545454}]
["Labor Cost","ft.",1.38,{"$f":"+$B$5","v":1000},{"$f":"IF(D30>0,$C30*D30,0)","v":1380}]
["Total Cost",null,null,null,{"$f":"SUM(E12:E30)","v":2576.0434182333333}]
["Total Cost Per Foot",null,null,null,{"$f":"E31/B5","v":2.5760434182333332}]
[]
["Material Cost",null,null,null,{"$f":"SUM(E12:E29)","v":1196.0434182333333}]
["Material Cost Per Foot",null,null,null,{"$f":"E34/B5","v":1.1960434182333333}]
[]
["Labor Cost",null,null,null,{"$f":"SUM(E30)","v":1380}]
["Labor Cost Per Foot",null,null,null,{"$f":"E37/B5","v":1.38}]
[]
["Annual Cost",null,null,null,{"$f":"C63","v":277.31442959689474}]
["Annual Cost Per Foot",null,null,null,{"$f":"E40/B5","v":0.27731442959689473}]
[]
["Assumptions - UT Extension PB1541 "]
["Brace every 650 feet"]
["Inline strainer used to tension brace wire "]
["Wooden post every 72 feet"]
["T-Post every 12 feet"]
["All brace posts driven 48\" in ground"]
[]
["Labor Requirements - Source (UT Extension Custom Rate Survey - AE13-06)"]
[]
[]
[null,null,{"$f":"+B4","v":4}]
[null,null,"Strand"]
[null,null," Barbed Wire"]
["Annual Cost",null,"Treated Post"]
["Estimated Useful Life",null,19]
["Average Annual Maintenance (%)",null,{"$f":"+'Input Prices'!$C$56","v":0.05}]
["Depreciation",null,{"$f":"E34/C57","v":62.949653591228071}]
["Interest Rate on Investment",null,{"$f":"+'Input Prices'!$C$57","v":0.06}]
["Interest on Investment",null,{"$f":"E31*C60","v":154.56260509399999}]
["Maintenance",null,{"$f":"E34*C58","v":59.802170911666671}]
["Total Cost",null,{"$f":"C59+C61+C62","v":277.31442959689474}]
[]
["Fencing Tools  "]
["T-Post Driver",{"$f":"+'Input Prices'!$C$43","v":44}]
["Barb Wire Roller",{"$f":"+'Input Prices'!$C$44","v":7.99}]
["Multi-Purpose Fence Pliers",{"$f":"+'Input Prices'!$C$45","v":16.989999999999998}]
["3⁄8\" Ship Auger Drill Bit",{"$f":"+'Input Prices'!$C$46","v":28.99}]
["Strainer Handle",{"$f":"+'Input Prices'!$C$47","v":5.99}]
["Come Along",{"$f":"+'Input Prices'!$C$48","v":23.99}]
["Other",0]
["Other",0]
["Other",0]
["Tax",{"$f":"SUM(B66:B74)*'Input Prices'!C39","v":12.091275}]
["Total",{"$f":"SUM(B66:B75)","v":140.04127499999998}]
["Cost per Ft",{"$f":"B76/B5","v":0.14004127499999999}]
[]
[]
[]
[null,"braces ","roundup"]
["Fence Braces",{"$f":"1+(B5/650)","v":2.5384615384615383},{"$f":"ROUNDUP(B82,0)","v":3}]
["Gate and Brace",{"$f":"B6","v":1},{"$f":"ROUNDUP(B83,0)","v":1}]
["Total",null,{"$f":"SUM(C82:C83)","v":4}]
[]
[]
[]
[]
[]
["Barbed Wire"]
[null,4,"Strand"]
[null,1000,"Feet"]
[null,1,"Gate"]
[null,null,"Brace Type"]
[null,"Brace Adjustment"]
[null,{"$f":"$C$84","v":4},"Braces"]
[]
["ITEM","UNIT","PRICE","QUANTITY","TOTAL"]
[{"$f":"'Input Prices'!A102","v":"8' Post 6\"-7\""},{"$f":"'Input Prices'!B102","v":"ea."},{"$f":"'Input Prices'!$C$6","v":17.5},{"$f":"$B$9*Braces!$D$41","v":8},{"$f":"IF(D99>0,$C99*D99,0)","v":140}]
[{"$f":"'Input Prices'!A103","v":"8' Posts 5\"-6\""},{"$f":"'Input Prices'!B103","v":"ea."},{"$f":"'Input Prices'!$C$7","v":14.99},0,0]
[{"$f":"'Input Prices'!A104","v":"8' Post 4\"-5\""},{"$f":"'Input Prices'!B104","v":"ea."},{"$f":"'Input Prices'!$C$8","v":11.99},{"$f":"IF(ROUNDUP(((B$5-((B$9*Braces!$E$39)+(B$6*14)))/72)-(IF(C$82>2,C$82-2,2)),0)<0,0,ROUNDUP(((B$5-((B$9*Braces!$E$39)+(B$6*14)))/72)-(IF(C$82>2,C$82-2,2)),0))","v":13},155.87]
[{"$f":"+Braces!$A$42","v":"8' Brace Post 4\"-5\""},{"$f":"'Input Prices'!B105","v":"ea."},{"$f":"+Braces!C42","v":11.99},{"$f":"$B$9*Braces!$D$42","v":4},47.96]
[{"$f":"'Input Prices'!A125","v":"T-Posts 6 FT"},{"$f":"'Input Prices'!B125","v":"ea."},{"$f":"'Input Prices'!$C$29","v":4.99},{"$f":"ROUNDUP(((B$5-((B$9*Braces!$E$39)+(B$6*14)))/12)-D$14,0)","v":67},334.33000000000004]
[{"$f":"'Input Prices'!A110","v":"Barbed Wire - Conv. 12 1/2"},"ft.",{"$f":"'Input Prices'!$F$14","v":0.10227272727272728},0,0]
[{"$f":"'Input Prices'!A111","v":"Barbed Wire - HT 15 1/2"},"ft.",{"$f":"'Input Prices'!$F$15","v":4.5446969696969701E-2},{"$f":"SUM($B$4*$B$5)","v":4000},181.78787878787881]
[{"$f":"'Input Prices'!A113","v":"Brace pins 1 - 10\" & 1 - 5\""},{"$f":"'Input Prices'!B113","v":"ea."},{"$f":"'Input Prices'!$C$17","v":2.16},{"$f":"$B$9*Braces!$D$44","v":4},8.64]
[{"$f":"'Input Prices'!A114","v":"Brace Wire"},{"$f":"'Input Prices'!B114","v":"ft."},{"$f":"'Input Prices'!$F$18","v":3.4997500000000001E-2},{"$f":"$B$9*Braces!$D$45","v":120},4.1997]
[{"$f":"'Input Prices'!A117","v":"Inline Strainers"},{"$f":"'Input Prices'!B117","v":"ea."},{"$f":"'Input Prices'!$C$21","v":3.49},{"$f":"$B$9*Braces!$D$43","v":4},13.96]
[{"$f":"'Input Prices'!A112","v":"Gate - 14'"},{"$f":"'Input Prices'!B112","v":"ea."},{"$f":"'Input Prices'!$C$16","v":181},{"$f":"$B$6","v":1},181]
[{"$f":"'Input Prices'!A126","v":"T-Post Clips"},{"$f":"'Input Prices'!B126","v":"ea."},{"$f":"'Input Prices'!$C$30","v":7.0000000000000007E-2},{"$f":"$D$16*$B$4","v":268},18.760000000000002]
[{"$f":"'Input Prices'!A124","v":"Staples - Standards"},{"$f":"'Input Prices'!B124","v":"lbs."},{"$f":"'Input Prices'!$C$28","v":1.99},{"$f":"SUM($D$12:$D$14)*0.15","v":3.15},6.2684999999999995]
["Other ","unit",0,0,{"$f":"IF(D112>0,$C112*D112,0)","v":0}]
["Other ","unit",0,0,{"$f":"IF(D113>0,$C113*D113,0)","v":0}]
["Other ","unit",0,0,{"$f":"IF(D114>0,$C114*D114,0)","v":0}]
["Other ","unit",0,0,{"$f":"IF(D115>0,$C115*D115,0)","v":0}]
[{"$f":"'Input Prices'!A135","v":"Materials Sales Tax "},{"$f":"'Input Prices'!B135","v":"%"},{"$f":"'Input Prices'!$C$39","v":9.4500000000000001E-2},null,{"$f":"SUM(E99:E115)*($C$29)","v":103.26733944545454}]
["Labor Cost","ft.",1.38,{"$f":"+$B$5","v":1000},{"$f":"IF(D117>0,$C117*D117,0)","v":1380}]
["Total Cost",null,null,null,{"$f":"SUM(E99:E117)","v":2576.0434182333333}]
["Total Cost Per Foot",null,null,null,{"$f":"E118/B92","v":2.5760434182333332}]
[]
["Material Cost",null,null,null,{"$f":"SUM(E99:E116)","v":1196.0434182333333}]
["Material Cost Per Foot",null,null,null,{"$f":"E121/B92","v":1.1960434182333333}]
[]
["Labor Cost",null,null,null,{"$f":"SUM(E117)","v":1380}]
["Labor Cost Per Foot",null,null,null,{"$f":"E124/B92","v":1.38}]
[]
["Annual Maintenance Cost",null,null,null,{"$f":"C150","v":277.31442959689474}]
["Annual Maintenance Cost Per Foot",null,null,null,{"$f":"E127/B92","v":0.27731442959689473}]
[]
["Assumptions - UT Extension PB1541 "]
["Brace every 650 feet, double braces"]
["Inline strainer used to tension brace wire "]
["Wooden post every 72 feet,"]
["T-Post every 12"]
["8 Ft between brace posts"]
["All brace posts driven 48\" in ground"]
[]
["Labor Requirements - Source (UT Extension Custom Rate Survey - AE13-06)"]
[]
[null,null,{"$f":"+B91","v":4}]
[null,null,"Strand"]
[null,null," Barbed Wire"]
["Annual Maintenance Cost",null,"Treated Post"]
["Estimated Useful Life",null,19]
["Average Annual Maintenance (%)",null,{"$f":"+'Input Prices'!$C$56","v":0.05}]
["Depreciation",null,{"$f":"E121/C144","v":62.949653591228071}]
["Interest Rate on Investment",null,{"$f":"+'Input Prices'!$C$57","v":0.06}]
["Interest on Investment",null,{"$f":"E118*C147","v":154.56260509399999}]
["Maintenance",null,{"$f":"E121*C145","v":59.802170911666671}]
["Total Cost",null,{"$f":"C146+C148+C149","v":277.31442959689474}]
[]
["Fencing Tools  "]
["T-Post Driver",{"$f":"+'Input Prices'!$C$43","v":44}]
["Barb Wire Roller",{"$f":"+'Input Prices'!$C$44","v":7.99}]
["Multi-Purpose Fence Pliers",{"$f":"+'Input Prices'!$C$45","v":16.989999999999998}]
["3⁄8\" Ship Auger Drill Bit",{"$f":"+'Input Prices'!$C$46","v":28.99}]
["Strainer Handle",{"$f":"+'Input Prices'!$C$47","v":5.99}]
["Come Along",{"$f":"+'Input Prices'!$C$48","v":23.99}]
["Other",0]
["Other",0]
["Other",0]
["Tax",{"$f":"SUM(B153:B161)*'Input Prices'!C126","v":8.9565000000000001}]
["Total",{"$f":"SUM(B153:B162)","v":136.90649999999999}]
["Cost per ft",{"$f":"B163/B92","v":0.13690649999999999}]

{"sheet":"Woven Wire","index":4,"n_rows":182,"n_cols":12,"rows_kept":182,"cut":false,"hidden":false,"merged":[[3,11,3,13],[4,11,4,13],[2,0,2,4],[7,1,7,2],[8,6,8,8],[58,1,58,2],[56,1,56,2],[57,1,57,2],[10,3,10,4],[33,0,33,3],[34,0,34,3],[36,0,36,3],[37,0,37,3],[39,0,39,3],[40,0,40,3],[42,0,42,3],[43,0,43,3],[101,0,101,4],[106,1,106,2],[109,3,109,4],[132,0,132,2],[133,0,133,2],[142,0,142,2],[155,1,155,2],[156,1,156,2],[157,1,157,2],[135,0,135,2],[136,0,136,2],[138,0,138,2],[139,0,139,2],[141,0,141,2]]}
[]
[]
["Woven Wire",null,null,null,null,null,null,null,null,null,null,"Directory"]
[null,1,"Strands of barb wire",null,null,null,null,null,null,null,null,"Intro"]
[null,1000,"Feet",null,null,null,null,null,null,null,null,"Input Prices"]
[null,1,"Gates",null,null,null,null,null,null,null,null,"Barbed Wire"]
[null,null,"Brace Type",null,null,null,null,null,null,null,null,"HT Fixed Knot"]
[null,"Brace Adjustment",null,null,null,null,null,null,null,null,null,"HT Electric"]
[null,{"$f":"+$C$89","v":6},"Braces",null,null,null,"Your Cost",null,null,null,null,"Poly Fence"]
[]
[]
["ITEM","UNIT","PRICE","QUANTITY","TOTAL"]
[{"$f":"'Input Prices'!A6","v":"8' Post 6\"-7\""},{"$f":"'Input Prices'!B6","v":"ea."},{"$f":"'Input Prices'!$C$6","v":17.5},{"$f":"$B$9*Braces!$D$52","v":12},{"$f":"IF(D13>0,D13*$C13,0)","v":210}]
[{"$f":"'Input Prices'!A7","v":"8' Posts 5\"-6\""},{"$f":"'Input Prices'!B7","v":"ea."},{"$f":"'Input Prices'!$C$7","v":14.99},0,0]
[{"$f":"'Input Prices'!A8","v":"8' Post 4\"-5\""},{"$f":"'Input Prices'!B8","v":"ea."},{"$f":"'Input Prices'!$C$8","v":11.99},{"$f":"IF(ROUNDUP((($B$5-(($B$9*Braces!$E$50)+($B$6*14)))/75)-(IF($C$87>2,$C$87-2,2)),0)<0,0,ROUNDUP((($B$5-(($B$9*Braces!$E$50)+($B$6*14)))/75)-(IF($C$87>2,$C$87-2,2)),0))","v":10},119.9]
[{"$f":"+Braces!$A$53","v":"8' Brace Post 4\"-5\""},{"$f":"'Input Prices'!B9","v":"ea."},{"$f":"+Braces!$C$53","v":11.99},{"$f":"$B$9*Braces!$D$53","v":6},71.94]
[{"$f":"'Input Prices'!A29","v":"T-Posts 6 FT"},{"$f":"'Input Prices'!B29","v":"ea."},{"$f":"'Input Prices'!$C$29","v":4.99},{"$f":"ROUNDUP((($B$5-(($B$9*Braces!$E$50)+($B$6*14)))/15)-$D$15,0)","v":53},264.47000000000003]
[{"$f":"'Input Prices'!A11","v":"Wire Conv. 1047-6-11"},"ft.",{"$f":"'Input Prices'!$F$11","v":1.1121212121212121},1000,1112.121212121212]
[{"$f":"'Input Prices'!A12","v":"Wire HT 1047-6-12.5"},"ft.",{"$f":"'Input Prices'!$F$12","v":0.83333333333333337},0,0]
[{"$f":"'Input Prices'!A14","v":"Barbed Wire - Conv. 12 1/2"},"ft.",{"$f":"'Input Prices'!$F$14","v":0.10227272727272728},0,0]
[{"$f":"'Input Prices'!A15","v":"Barbed Wire - HT 15 1/2"},"ft.",{"$f":"'Input Prices'!$F$15","v":4.5446969696969701E-2},{"$f":"$B$5*$B$4","v":1000},45.446969696969703]
[{"$f":"'Input Prices'!A16","v":"Gate - 14'"},{"$f":"'Input Prices'!B16","v":"ea."},{"$f":"'Input Prices'!$C$16","v":181},{"$f":"$B$6","v":1},181]
[{"$f":"'Input Prices'!A17","v":"Brace pins 1 - 10\" & 1 - 5\""},{"$f":"'Input Prices'!B17","v":"ea."},{"$f":"'Input Prices'!$C$17","v":2.16},{"$f":"$B$9*Braces!$D$55","v":6},12.96]
[{"$f":"'Input Prices'!A18","v":"Brace Wire"},{"$f":"'Input Prices'!B18","v":"ft."},{"$f":"'Input Prices'!$F$18","v":3.4997500000000001E-2},{"$f":"$B$9*Braces!$D$56","v":180},6.29955]
[{"$f":"'Input Prices'!A21","v":"Inline Strainers"},{"$f":"'Input Prices'!B21","v":"ea."},{"$f":"'Input Prices'!$C$21","v":3.49},{"$f":"$B$9*Braces!$D$54","v":6},20.94]
[{"$f":"'Input Prices'!A28","v":"Staples - Standards"},{"$f":"'Input Prices'!B28","v":"lbs."},{"$f":"'Input Prices'!$C$28","v":1.99},{"$f":"SUM($D$13:$D$15)*0.15","v":3.3},6.5669999999999993]
[{"$f":"'Input Prices'!A30","v":"T-Post Clips"},{"$f":"'Input Prices'!B30","v":"ea."},{"$f":"'Input Prices'!$C$30","v":7.0000000000000007E-2},{"$f":"$D$17*(5+$B$4)","v":318},22.26]
["Other","unit",0,0,0]
["Other","unit",0,0,0]
["Other","unit",0,0,0]
["Other","unit",0,0,0]
[{"$f":"'Input Prices'!A39","v":"Materials Sales Tax "},{"$f":"'Input Prices'!B39","v":"%"},{"$f":"'Input Prices'!$C$39","v":9.4500000000000001E-2},null,{"$f":"SUM(E13:E31)*($C$32)","v":195.98399715681819}]
["Labor Cost","ft.",3.25,{"$f":"+$B$5","v":1000},{"$f":"IF(D33>0,D33*$C33,0)","v":3250}]
["Total Cost",null,null,null,{"$f":"SUM(E13:E33)","v":5519.888728975}]
["Total Cost Per Foot",null,null,null,{"$f":"E34/B5","v":5.5198887289750003}]
[]
["Material Cost",null,null,null,{"$f":"SUM(E13:E32)","v":2269.888728975}]
["Material Cost Per Foot",null,null,null,{"$f":"E37/B5","v":2.2698887289750003}]
[]
["Labor Cost",null,null,null,{"$f":"SUM(E33:E33)","v":3250}]
["Labor Cost Per Foot",null,null,null,{"$f":"E40/B5","v":3.25}]
[]
["Annual Cost",null,null,null,{"$f":"C66","v":564.15558802803946}]
["Annual Cost Per Foot",null,null,null,{"$f":"E43/B5","v":0.56415558802803945}]
[]
["Assumptions - UT Extension PB1541 & Manufacturers Specs"]
["Brace every 330 feet"]
["Inline strainer used to tension brace wire "]
["Wooden post every 75 feet"]
["T-Post every 15 feet"]
["All brace posts driven 48\" in ground"]
[]
[]
["Labor Requirements - Source (UT Extension Custom Rate Survey - AE13-06)"]
[]
[]
[]
[]
["AnnualCost","Woven Wire"]
["Estimated Useful Life",null,19]
["Average Annual Maintenance (%)",null,{"$f":"+'Input Prices'!$C$56","v":0.05}]
["Depreciation",null,{"$f":"E37/C60","v":119.46782784078948}]
["Interest Rate on Investment",null,{"$f":"+'Input Prices'!$C$57","v":0.06}]
["Interest on Investment",null,{"$f":"E34*C63","v":331.1933237385}]
["Maintenance",null,{"$f":"E37*C61","v":113.49443644875001}]
["Total Cost",null,{"$f":"C62+C64+C65","v":564.15558802803946}]
[]
[]
["Fencing Tools  "]
["T-Post Driver",{"$f":"+'Input Prices'!$C$43","v":44}]
["Barb Wire Roller",{"$f":"+'Input Prices'!$C$44","v":7.99}]
["Multi-Purpose Fence Pliers",{"$f":"+'Input Prices'!$C$45","v":16.989999999999998}]
["Come along",{"$f":"+'Input Prices'!$C$48","v":23.99}]
["Chain ",{"$f":"+'Input Prices'!$C$50","v":60}]
["3⁄8\" Ship Auger Drill Bit",{"$f":"+'Input Prices'!$C$46","v":28.99}]
["Strainer Handle",{"$f":"+'Input Prices'!$C$47","v":5.99}]
["Stretcher bar",{"$f":"+'Input Prices'!$C$49","v":139.75}]
["Other",0]
["Other",0]
["Other",0]
["Tax",{"$f":"SUM(B70:B80)*'Input Prices'!$C$39","v":30.967650000000006}]
["Total",{"$f":"SUM(B70:B81)","v":358.66765000000004}]
["Cost per ft",{"$f":"B82/B5","v":0.35866765000000006}]
[]
[]
[null,"braces ","roundup"]
["Fence Braces",{"$f":"1+($B$5/330)","v":4.0303030303030303},{"$f":"ROUNDUP(B87,0)","v":5}]
["Gate and Brace",{"$f":"B6","v":1},{"$f":"ROUNDUP(B88,0)","v":1}]
["Total",null,{"$f":"SUM(C87:C88)","v":6}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Woven Wire"]
[null,1,"Strands of barb wire"]
[null,1000,"Feet"]
[null,1,"Gate"]
[]
[null,"Brace Adjustment"]
[null,{"$f":"+$C$89","v":6},"Braces"]
[]
[]
["ITEM","UNIT","PRICE","QUANTITY","TOTAL"]
[{"$f":"'Input Prices'!A102","v":"8' Post 6\"-7\""},{"$f":"'Input Prices'!B105","v":"ea."},{"$f":"'Input Prices'!$C$6","v":17.5},{"$f":"$B$9*Braces!$D$52","v":12},{"$f":"IF(D112>0,D112*$C112,0)","v":210}]
[{"$f":"'Input Prices'!A103","v":"8' Posts 5\"-6\""},{"$f":"'Input Prices'!B106","v":"ea."},{"$f":"'Input Prices'!$C$7","v":14.99},0,0]
[{"$f":"'Input Prices'!A104","v":"8' Post 4\"-5\""},{"$f":"'Input Prices'!B107","v":"roll"},{"$f":"'Input Prices'!$C$8","v":11.99},{"$f":"IF(ROUNDUP((($B$5-(($B$9*Braces!$E$50)+($B$6*14)))/75)-(IF($C$87>2,$C$87-2,2)),0)<0,0,ROUNDUP((($B$5-(($B$9*Braces!$E$50)+($B$6*14)))/75)-(IF($C$87>2,$C$87-2,2)),0))","v":10},119.9]
[{"$f":"+Braces!$A$53","v":"8' Brace Post 4\"-5\""},{"$f":"'Input Prices'!B108","v":"roll"},{"$f":"+Braces!$C$53","v":11.99},{"$f":"$B$9*Braces!$D$53","v":6},71.94]
[{"$f":"'Input Prices'!A107","v":"Wire Conv. 1047-6-11"},{"$f":"'Input Prices'!B128","v":"roll"},{"$f":"'Input Prices'!$C$29","v":4.99},{"$f":"ROUNDUP((($B$5-(($B$9*Braces!$E$50)+($B$6*14)))/15)-$D$15,0)","v":53},264.47000000000003]
[{"$f":"'Input Prices'!A110","v":"Barbed Wire - Conv. 12 1/2"},"ft.",{"$f":"'Input Prices'!$F$11","v":1.1121212121212121},1000,1112.121212121212]
[{"$f":"'Input Prices'!A111","v":"Barbed Wire - HT 15 1/2"},"ft.",{"$f":"'Input Prices'!$F$12","v":0.83333333333333337},0,0]
[{"$f":"'Input Prices'!A113","v":"Brace pins 1 - 10\" & 1 - 5\""},"ft.",{"$f":"'Input Prices'!$F$14","v":0.10227272727272728},0,0]
[{"$f":"'Input Prices'!A114","v":"Brace Wire"},"ft.",{"$f":"'Input Prices'!$F$15","v":4.5446969696969701E-2},{"$f":"$B$5*$B$4","v":1000},45.446969696969703]
[{"$f":"'Input Prices'!A115","v":"High Tensile Wire 12.5 Gauge"},{"$f":"'Input Prices'!B115","v":"ft."},{"$f":"'Input Prices'!$C$16","v":181},{"$f":"$B$6","v":1},181]
[{"$f":"'Input Prices'!A116","v":"Springs"},{"$f":"'Input Prices'!B116","v":"ea."},{"$f":"'Input Prices'!$C$17","v":2.16},{"$f":"$B$9*Braces!$D$55","v":6},12.96]
[{"$f":"'Input Prices'!A117","v":"Inline Strainers"},{"$f":"'Input Prices'!B117","v":"ea."},{"$f":"'Input Prices'!$F$18","v":3.4997500000000001E-2},{"$f":"$B$9*Braces!$D$56","v":180},6.29955]
[{"$f":"'Input Prices'!A120","v":"Insulators "},{"$f":"'Input Prices'!B120","v":"ea."},{"$f":"'Input Prices'!$C$21","v":3.49},{"$f":"$B$9*Braces!$D$54","v":6},20.94]
[{"$f":"'Input Prices'!A127","v":"Step-in Fiberglass Post"},{"$f":"'Input Prices'!B127","v":"ea."},{"$f":"'Input Prices'!$C$28","v":1.99},{"$f":"SUM($D$13:$D$15)*0.15","v":3.3},6.5669999999999993]
[{"$f":"'Input Prices'!A129","v":"Polytape"},{"$f":"'Input Prices'!B129","v":"roll"},{"$f":"'Input Prices'!$C$30","v":7.0000000000000007E-2},{"$f":"$D$17*(5+$B$4)","v":318},22.26]
["Other","unit",0,0,0]
["Other","unit",0,0,0]
["Other","unit",0,0,0]
["Other","unit",0,0,0]
[{"$f":"'Input Prices'!A39","v":"Materials Sales Tax "},{"$f":"'Input Prices'!B39","v":"%"},{"$f":"'Input Prices'!$C$39","v":9.4500000000000001E-2},null,{"$f":"SUM(E112:E130)*($C$32)","v":195.98399715681819}]
["Labor Cost","ft.",3.25,{"$f":"+$B$5","v":1000},{"$f":"IF(D132>0,D132*$C132,0)","v":3250}]
["Total Cost",null,null,null,{"$f":"SUM(E112:E132)","v":5519.888728975}]
["Total Cost Per Foot",null,null,null,{"$f":"E133/B104","v":5.5198887289750003}]
[]
["Material Cost",null,null,null,{"$f":"SUM(E112:E131)","v":2269.888728975}]
["Material Cost Per Foot",null,null,null,{"$f":"E136/B104","v":2.2698887289750003}]
[]
["Labor Cost",null,null,null,{"$f":"SUM(E132:E132)","v":3250}]
["Labor Cost Per Foot",null,null,null,{"$f":"E139/B104","v":3.25}]
[]
["Annual Maintenance Cost",null,null,null,{"$f":"C165","v":564.15558802803946}]
["Annual Maintenance Cost Per Foot",null,null,null,{"$f":"E142/B104","v":0.56415558802803945}]
[]
["Assumptions - UT Extension PB1541 & Manufacturers Specs"]
["Brace every 330 feet, double braces "]
["Inline strainer used to tension brace wire "]
["Wooden post every 75 feet"]
["T-Post every 15"]
["8 Ft between brace posts"]
["All brace posts driven 48\" in ground"]
[]
["Labor Requirements - Source (UT Extension Custom Rate Survey - AE13-06)"]
[]
[]
[]
[]
["Annual Maintenance Cost","Woven Wire"]
["Estimated Useful Life",null,19]
["Average Annual Maintenance (%)",null,{"$f":"+'Input Prices'!$C$56","v":0.05}]
["Depreciation",null,{"$f":"E136/C159","v":119.46782784078948}]
["Interest Rate on Investment",null,{"$f":"+'Input Prices'!$C$57","v":0.06}]
["Interest on Investment",null,{"$f":"E133*C162","v":331.1933237385}]
["Maintenance",null,{"$f":"E136*C160","v":113.49443644875001}]
["Total Cost",null,{"$f":"C161+C163+C164","v":564.15558802803946}]
[]
[]
["Fencing Tools  "]
["T-Post Driver",{"$f":"+'Input Prices'!$C$43","v":44}]
["Barb Wire Roller",{"$f":"+'Input Prices'!$C$44","v":7.99}]
["Multi-Purpose Fence Pliers",{"$f":"+'Input Prices'!$C$45","v":16.989999999999998}]
["Come along",{"$f":"+'Input Prices'!$C$48","v":23.99}]
["Chain ",{"$f":"+'Input Prices'!$C$50","v":60}]
["3⁄8\" Ship Auger Drill Bit",{"$f":"+'Input Prices'!$C$46","v":28.99}]
["Strainer Handle",{"$f":"+'Input Prices'!$C$47","v":5.99}]
["Stretcher bar",{"$f":"+'Input Prices'!$C$49","v":139.75}]
["Other",0]
["Other",0]
["Other",0]
["Tax",{"$f":"SUM(B169:B179)*'Input Prices'!$C$39","v":30.967650000000006}]
["Total",{"$f":"SUM(B169:B180)","v":358.66765000000004}]
["Cost per ft",{"$f":"B181/B104","v":0.35866765000000006}]

{"sheet":"HT Fixed Knot","index":5,"n_rows":173,"n_cols":12,"rows_kept":173,"cut":false,"hidden":false,"merged":[[150,1,150,2],[159,0,159,4],[135,0,135,2],[136,0,136,2],[147,1,147,2],[148,1,148,2],[149,1,149,2],[127,0,127,2],[129,0,129,2],[130,0,130,2],[132,0,132,2],[133,0,133,2],[96,0,96,4],[101,1,101,2],[101,3,101,4],[104,3,104,4],[126,0,126,2],[2,0,2,4],[7,1,7,2],[7,3,7,4],[10,3,10,4],[3,11,3,13],[4,11,4,13],[10,6,10,8],[65,0,65,4],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[39,0,39,3],[41,0,41,3],[42,0,42,3],[32,0,32,3],[33,0,33,3],[35,0,35,3],[36,0,36,3],[38,0,38,3]]}
[]
[]
["Fixed Knot Fence",null,null,null,null,null,null,null,null,null,null,"Directory"]
[null,1,"Strands of Barb wire",null,null,null,null,null,null,null,null,"Intro"]
[null,1000,"Feet",null,null,null,null,null,null,null,null,"Input Prices"]
[null,1,"Gates",null,null,null,null,null,null,null,null,"Barbed Wire"]
[null,null,"Brace Type",null,null,null,null,null,null,null,null,"Woven Wire"]
[null,"Brace Adjustment",null,null,null,null,null,null,null,null,null,"HT Electric"]
[null,{"$f":"$C$86","v":3},"Braces",null,null,null,null,null,null,null,null,"Poly Fence"]
[]
[null,null,null,"Top Barbed Wire",null,null,"Your Cost"]
["ITEM","UNIT","PRICE","QUANTITY","TOTAL"]
[{"$f":"'Input Prices'!A6","v":"8' Post 6\"-7\""},{"$f":"'Input Prices'!B6","v":"ea."},{"$f":"'Input Prices'!$C$6","v":17.5},{"$f":"$B$9*Braces!$D$63","v":6},{"$f":"IF(D13>0,$C13*D13,0)","v":105}]
[{"$f":"'Input Prices'!A7","v":"8' Posts 5\"-6\""},{"$f":"'Input Prices'!B7","v":"ea."},{"$f":"'Input Prices'!$C$7","v":14.99},0,0]
[{"$f":"'Input Prices'!A8","v":"8' Post 4\"-5\""},{"$f":"'Input Prices'!B8","v":"ea."},{"$f":"'Input Prices'!$C$8","v":11.99},{"$f":"IF(ROUNDUP((($B$5-(($B$9*Braces!$E$61)+($B$6*14)))/75)-(IF($C$84>2,$C$84-2,2)),0)<0,0,ROUNDUP((($B$5-(($B$9*Braces!$E$61)+($B$6*14)))/75)-(IF($C$84>2,$C$84-2,2)),0))","v":11},131.89000000000001]
[{"$f":"+Braces!$A$64","v":"8' Brace Post 4\"-5\""},{"$f":"'Input Prices'!B10","v":"ea."},{"$f":"+Braces!$C$64","v":11.99},{"$f":"$B$9*Braces!$D$64","v":3},35.97]
[{"$f":"'Input Prices'!A29","v":"T-Posts 6 FT"},{"$f":"'Input Prices'!B29","v":"ea."},{"$f":"'Input Prices'!$C$29","v":4.99},{"$f":"ROUNDUP((($B$5-(($B$9*Braces!$E$61)+($B$6*14)))/15)-$D$15,0)","v":54},269.46000000000004]
[{"$f":"'Input Prices'!A30","v":"T-Post Clips"},{"$f":"'Input Prices'!B30","v":"ea."},{"$f":"'Input Prices'!$C$30","v":7.0000000000000007E-2},{"$f":"$D$17*(5+$B$4)","v":324},22.680000000000003]
[{"$f":"'Input Prices'!A13","v":"Wire HT 949-6 Fixed Knot"},"ft.",{"$f":"'Input Prices'!$F$13","v":0.84545454545454546},{"$f":"$B$5","v":1000},845.4545454545455]
[{"$f":"'Input Prices'!A15","v":"Barbed Wire - HT 15 1/2"},"ft.",{"$f":"'Input Prices'!$F$15","v":4.5446969696969701E-2},{"$f":"$B$4*$B$5","v":1000},45.446969696969703]
[{"$f":"'Input Prices'!A16","v":"Gate - 14'"},{"$f":"'Input Prices'!B16","v":"ea."},{"$f":"'Input Prices'!$C$16","v":181},{"$f":"$B$6","v":1},181]
[{"$f":"'Input Prices'!A17","v":"Brace pins 1 - 10\" & 1 - 5\""},{"$f":"'Input Prices'!B17","v":"ea."},{"$f":"'Input Prices'!$C$17","v":2.16},{"$f":"$B$9*Braces!$D$66","v":3},6.48]
[{"$f":"'Woven Wire'!A24","v":"Brace Wire"},{"$f":"'Woven Wire'!B24","v":"ft."},{"$f":"'Input Prices'!$F$18","v":3.4997500000000001E-2},{"$f":"$B$9*Braces!$D$67","v":90},3.149775]
[{"$f":"'Input Prices'!A21","v":"Inline Strainers"},{"$f":"'Input Prices'!B21","v":"ea."},{"$f":"'Input Prices'!$C$21","v":3.49},{"$f":"$B$9*Braces!$D$65","v":3},10.47]
[{"$f":"'Input Prices'!A25","v":"Long Crimp Sleeves"},{"$f":"'Input Prices'!B25","v":"ea."},{"$f":"'Input Prices'!$C$25","v":0.3},{"$f":"IF($B$5<1320,9,ROUNDUP($B$5/1320,0)*9)","v":9},2.6999999999999997]
[{"$f":"'Input Prices'!A27","v":"Staples - Barbed For HT"},{"$f":"'Input Prices'!B27","v":"lbs."},{"$f":"'Input Prices'!$C$27","v":2.35},{"$f":"SUM($D$13:$D$15)*0.15","v":2.5499999999999998},5.9924999999999997]
["Other ","unit",0,0,0]
["Other ","unit",0,0,0]
["Other ","unit",0,0,{"$f":"IF(D29>0,$C29*D29,0)","v":0}]
["Other ","unit",0,0,0]
[{"$f":"'Input Prices'!A39","v":"Materials Sales Tax "},{"$f":"'Input Prices'!B39","v":"%"},{"$f":"'Input Prices'!$C$39","v":9.4500000000000001E-2},null,{"$f":"SUM(E13:E30)*$C$31","v":157.40806316931821}]
["Labor Cost","ft.",3.25,{"$f":"+$B$5","v":1000},{"$f":"IF(D32>0,$C32*D32,0)","v":3250}]
["Total Cost",null,null,null,{"$f":"SUM(E13:E32)","v":5073.1018533208335}]
["Total Cost Per Foot",null,null,null,{"$f":"E33/$B5","v":5.0731018533208339}]
[]
["Material Cost",null,null,null,{"$f":"SUM(E13:E31)","v":1823.1018533208337}]
["Material Cost Per Foot",null,null,null,{"$f":"E36/$B5","v":1.8231018533208336}]
[]
["Labor Cost",null,null,null,{"$f":"SUM(E32:E32)","v":3250}]
["Labor Cost Per Foot",null,null,null,{"$f":"E39/$B5","v":3.25}]
[]
["Annual Cost",null,null,null,{"$f":"C64","v":456.31126564265287}]
["Annual Cost Per Foot",null,null,null,{"$f":"E42/$B5","v":0.4563112656426529}]
[]
["Assumptions - (Manufacturers Specs)"]
["Brace every 1320 feet"]
["Inline strainer used to tension brace wire "]
["Wooden post every 75 feet"]
["T-Post every 15 feet"]
[]
[]
["Labor Requirements - Source (UT Extension Custom Rate Survey - AE13-06)"]
[]
[null,"Fixed Knot "]
[null,"Treated Post"]
[]
["Annual Cost","Top Barbed Wire"]
["Estimated Useful Life",null,30]
["Average Annual Maintenance (%)",null,{"$f":"+'Input Prices'!$C$56","v":0.05}]
["Depreciation",null,{"$f":"E36/C58","v":60.770061777361121}]
["Interest Rate on Investment",null,{"$f":"+'Input Prices'!$C$57","v":0.06}]
["Interest on Investment",null,{"$f":"E33*C61","v":304.38611119925002}]
["Maintenance",null,{"$f":"E36*C59","v":91.155092666041696}]
["Total Cost",null,{"$f":"C60+C62+C63","v":456.31126564265287}]
[]
["Fencing Tools  "]
["Item ","Quantity ","Cost","Total"]
["Stretcher Bars",2,{"$f":"+'Input Prices'!$C$49","v":139.75},{"$f":"B68*C68","v":279.5}]
["Come along",1,{"$f":"+'Input Prices'!$C$48","v":23.99},23.99]
["T-Post driver",1,{"$f":"+'Input Prices'!$C$43","v":44},44]
["Multi-Function Fencing Tool",1,{"$f":"+'Input Prices'!$C$51","v":69.75},69.75]
["Strainer Handle",1,{"$f":"+'Input Prices'!$C$47","v":5.99},5.99]
["3⁄8\" Ship Auger Drill Bit",1,{"$f":"+'Input Prices'!$C$46","v":28.99},28.99]
["Other",null,0,0]
["Other",null,0,0]
["Other",null,0,0]
["Tax ",null,null,{"$f":"SUM(D68:D76)*'Input Prices'!C39","v":42.734790000000004}]
["Total",null,null,{"$f":"SUM(D68:D77)","v":494.95479}]
["Cost Per Ft",null,null,{"$f":"D78/B5","v":0.49495478999999998}]
[]
[]
[]
[null,"braces ","roundup"]
["Fence Braces",{"$f":"1+(B5/1320)","v":1.7575757575757576},{"$f":"ROUNDUP(B84,0)","v":2}]
["Gate and Brace",{"$f":"B6","v":1},{"$f":"ROUNDUP(B85,0)","v":1}]
["Total",null,{"$f":"SUM(C84:C85)","v":3}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Fixed Knot Fence"]
[null,1,"Strands of barb wire"]
[null,1000,"Feet"]
[null,1,"Gate"]
[]
[null,"Brace Adjustment"]
[null,{"$f":"$C$86","v":3},"Braces"]
[]
[null,null,null,"Top Barbed Wire"]
["ITEM","UNIT","PRICE","QUANTITY","TOTAL"]
[{"$f":"'Input Prices'!A102","v":"8' Post 6\"-7\""},{"$f":"'Input Prices'!B102","v":"ea."},{"$f":"'Input Prices'!$C$6","v":17.5},{"$f":"$B$9*Braces!$D$63","v":6},{"$f":"IF(D107>0,$C107*D107,0)","v":105}]
[{"$f":"'Input Prices'!A103","v":"8' Posts 5\"-6\""},{"$f":"'Input Prices'!B103","v":"ea."},{"$f":"'Input Prices'!$C$7","v":14.99},0,0]
[{"$f":"'Input Prices'!A104","v":"8' Post 4\"-5\""},{"$f":"'Input Prices'!B102","v":"ea."},{"$f":"'Input Prices'!$C$8","v":11.99},{"$f":"IF(ROUNDUP((($B$5-(($B$9*Braces!$E$61)+($B$6*14)))/75)-(IF($C$84>2,$C$84-2,2)),0)<0,0,ROUNDUP((($B$5-(($B$9*Braces!$E$61)+($B$6*14)))/75)-(IF($C$84>2,$C$84-2,2)),0))","v":11},131.89000000000001]
[{"$f":"+Braces!$A$64","v":"8' Brace Post 4\"-5\""},{"$f":"'Input Prices'!B104","v":"ea."},{"$f":"+Braces!$C$64","v":11.99},{"$f":"$B$9*Braces!$D$64","v":3},35.97]
[{"$f":"'Input Prices'!A123","v":"Staples - Barbed For HT"},{"$f":"'Input Prices'!B123","v":"lbs."},{"$f":"'Input Prices'!$C$29","v":4.99},{"$f":"ROUNDUP((($B$5-(($B$9*Braces!$E$61)+($B$6*14)))/15)-$D$15,0)","v":54},269.46000000000004]
[{"$f":"'Input Prices'!A124","v":"Staples - Standards"},{"$f":"'Input Prices'!B124","v":"lbs."},{"$f":"'Input Prices'!$C$30","v":7.0000000000000007E-2},{"$f":"$D$17*(5+$B$4)","v":324},22.680000000000003]
[{"$f":"'Input Prices'!A107","v":"Wire Conv. 1047-6-11"},"ft.",{"$f":"'Input Prices'!$F$13","v":0.84545454545454546},{"$f":"$B$5","v":1000},845.4545454545455]
[{"$f":"'Input Prices'!A109","v":"Wire HT 949-6 Fixed Knot"},"ft.",{"$f":"'Input Prices'!$F$15","v":4.5446969696969701E-2},{"$f":"$B$4*$B$5","v":1000},45.446969696969703]
[{"$f":"'Input Prices'!A110","v":"Barbed Wire - Conv. 12 1/2"},{"$f":"'Input Prices'!B110","v":"roll"},{"$f":"'Input Prices'!$C$16","v":181},{"$f":"$B$6","v":1},181]
[{"$f":"'Input Prices'!A111","v":"Barbed Wire - HT 15 1/2"},{"$f":"'Input Prices'!B111","v":"roll"},{"$f":"'Input Prices'!$C$17","v":2.16},{"$f":"$B$9*Braces!$D$66","v":3},6.48]
[{"$f":"'Woven Wire'!A118","v":"Barbed Wire - HT 15 1/2"},{"$f":"'Woven Wire'!B118","v":"ft."},{"$f":"'Input Prices'!$F$18","v":3.4997500000000001E-2},{"$f":"$B$9*Braces!$D$67","v":90},3.149775]
[{"$f":"'Input Prices'!A115","v":"High Tensile Wire 12.5 Gauge"},{"$f":"'Input Prices'!B115","v":"ft."},{"$f":"'Input Prices'!$C$21","v":3.49},{"$f":"$B$9*Braces!$D$65","v":3},10.47]
[{"$f":"'Input Prices'!A119","v":"Batten Clips"},{"$f":"'Input Prices'!B119","v":"ea."},{"$f":"'Input Prices'!$C$25","v":0.3},{"$f":"IF($B$5<1320,9,ROUNDUP($B$5/1320,0)*9)","v":9},2.6999999999999997]
[{"$f":"'Input Prices'!A121","v":"Long Crimp Sleeves"},{"$f":"'Input Prices'!B121","v":"ea."},{"$f":"'Input Prices'!$C$27","v":2.35},{"$f":"SUM($D$13:$D$15)*0.15","v":2.5499999999999998},5.9924999999999997]
["Other ","unit",0,0,0]
["Other ","unit",0,0,0]
["Other ","unit",0,0,{"$f":"IF(D123>0,$C123*D123,0)","v":0}]
["Other ","unit",0,0,{"$f":"IF(D124>0,$C124*D124,0)","v":0}]
[{"$f":"'Input Prices'!A133","v":"Electric Fence Charger "},{"$f":"'Input Prices'!B133","v":"ea."},{"$f":"'Input Prices'!$C$39","v":9.4500000000000001E-2},null,{"$f":"SUM(E107:E124)*$C$31","v":157.40806316931821}]
["Labor Cost","ft.",3.25,{"$f":"+$B$5","v":1000},{"$f":"IF(D126>0,$C126*D126,0)","v":3250}]
["Total Cost",null,null,null,{"$f":"SUM(E107:E126)","v":5073.1018533208335}]
["Total Cost Per Foot",null,null,null,{"$f":"E127/$B99","v":5.0731018533208339}]
[]
["Material Cost",null,null,null,{"$f":"SUM(E107:E125)","v":1823.1018533208337}]
["Material Cost Per Foot",null,null,null,{"$f":"E130/$B99","v":1.8231018533208336}]
[]
["Labor Cost",null,null,null,{"$f":"SUM(E126:E126)","v":3250}]
["Labor Cost Per Foot",null,null,null,{"$f":"E133/$B99","v":3.25}]
[]
["Annual Maintenance Cost",null,null,null,{"$f":"C158","v":456.31126564265287}]
["Annual Maintenance Cost Per Foot",null,null,null,{"$f":"E136/$B99","v":0.4563112656426529}]
[]
["Assumptions - (Manufacturers Specs)"]
["Brace every 1320 feet, Single 10' Brace"]
["Inline strainer used to tension brace wire "]
["Wooden post every 75 feet"]
["T-Post every 15 feet"]
["10 Ft between brace posts"]
[]
["Labor Requirements - Source (UT Extension Custom Rate Survey - AE13-06)"]
[]
[null,"Fixed Knot "]
[null,"Treated Post"]
[null,"949-12-330 + 1"]
["Annual Maintenance Cost","Top Barbed Wire"]
["Estimated Useful Life",null,30]
["Average Annual Maintenance (%)",null,{"$f":"+'Input Prices'!$C$56","v":0.05}]
["Depreciation",null,{"$f":"E130/C152","v":60.770061777361121}]
["Interest Rate on Investment",null,{"$f":"+'Input Prices'!$C$57","v":0.06}]
["Interest on Investment",null,{"$f":"E127*C155","v":304.38611119925002}]
["Maintenance",null,{"$f":"E130*C153","v":91.155092666041696}]
["Total Cost",null,{"$f":"C154+C156+C157","v":456.31126564265287}]
[]
["Fencing Tools  "]
["Item ","Quantity ","Cost","Total"]
["Stretcher Bars",2,{"$f":"+'Input Prices'!$C$49","v":139.75},{"$f":"B162*C162","v":279.5}]
["Come along",1,{"$f":"+'Input Prices'!$C$48","v":23.99},23.99]
["T-Post driver",1,{"$f":"+'Input Prices'!$C$43","v":44},44]
["Multi-Function Fencing Tool",1,{"$f":"+'Input Prices'!$C$51","v":69.75},69.75]
["Strainer Handle",1,{"$f":"+'Input Prices'!$C$47","v":5.99},5.99]
["3⁄8\" Ship Auger Drill Bit",1,{"$f":"+'Input Prices'!$C$46","v":28.99},28.99]
["Other",null,0,0]
["Other",null,0,0]
["Other",null,0,0]
["Tax ",null,null,{"$f":"SUM(D162:D170)*'Input Prices'!C39","v":42.734790000000004}]
["Total",null,null,{"$f":"SUM(D162:D171)","v":494.95479}]
["Cost Per Foot",null,null,{"$f":"D172/B99","v":0.49495478999999998}]

{"sheet":"HT Electric","index":6,"n_rows":175,"n_cols":12,"rows_kept":175,"cut":false,"hidden":false,"merged":[[3,11,3,13],[4,11,4,13],[6,6,6,8],[35,0,35,3],[36,0,36,3],[0,0,0,8],[2,0,2,4],[8,1,8,2],[96,0,96,4],[45,0,45,3],[38,0,38,3],[39,0,39,3],[41,0,41,3],[42,0,42,3],[44,0,44,3],[100,6,100,8],[102,1,102,2],[129,0,129,2],[138,0,138,2],[139,0,139,2],[130,0,130,2],[132,0,132,2],[133,0,133,2],[135,0,135,2],[136,0,136,2]]}
[]
[]
["High Tensile Electric",null,null,null,null,null,null,null,null,null,null,"Directory"]
[null,4,"Strand",null,null,null,null,null,null,null,null,"Intro"]
[null,{"$f":"B4","v":4},"Hot Wires",null,null,null,null,null,null,null,null,"Input Prices"]
[null,4000,"Feet",null,null,null,null,null,null,null,null,"Barbed Wire"]
[null,2,"Gates",null,null,null,"Your Cost",null,null,null,null,"Woven Wire"]
[null,null,"Brace Type",null,null,null,null,null,null,null,null,"HT Fixed Knot"]
[null,"Brace Adjustment",null,null,null,null,null,null,null,null,null,"Poly Fence"]
[null,{"$f":"$C$87","v":7},"Braces "]
[]
["ITEM","UNIT","PRICE","QUANTITY","TOTAL"]
[{"$f":"'Input Prices'!A6","v":"8' Post 6\"-7\""},{"$f":"'Input Prices'!B6","v":"ea."},{"$f":"'Input Prices'!$C$6","v":17.5},{"$f":"$B$10*Braces!$D$74","v":14},{"$f":"IF(D13>0,$C13*D13,0)","v":245}]
[{"$f":"'Input Prices'!A7","v":"8' Posts 5\"-6\""},{"$f":"'Input Prices'!B7","v":"ea."},{"$f":"'Input Prices'!$C$7","v":14.99},0,0]
[{"$f":"'Input Prices'!A8","v":"8' Post 4\"-5\""},{"$f":"'Input Prices'!B8","v":"ea."},{"$f":"'Input Prices'!$C$8","v":11.99},{"$f":"IF(ROUNDUP((($B$6-(($B$10*Braces!$E$72)+($B$7*14)))/100)-(IF($C$85>2,$C$85-2,2)),0)<0,0,ROUNDUP((($B$6-(($B$10*Braces!$E$72)+($B$7*14)))/100)-(IF($C$85>2,$C$85-2,2)),0))","v":37},443.63]
[{"$f":"+Braces!$A$75","v":"8' Brace Post 4\"-5\""},{"$f":"'Input Prices'!B10","v":"ea."},{"$f":"+Braces!$C$75","v":11.99},{"$f":"$B$10*Braces!$D$75","v":7},83.93]
[{"$f":"'Input Prices'!A19","v":"High Tensile Wire 12.5 Gauge"},{"$f":"'Input Prices'!B19","v":"ft."},{"$f":"'Input Prices'!$F$19","v":3.4997500000000001E-2},{"$f":"SUM($B$4*$B$6)","v":16000},559.96]
[{"$f":"'Input Prices'!A16","v":"Gate - 14'"},{"$f":"'Input Prices'!B16","v":"ea."},{"$f":"'Input Prices'!$C$16","v":181},{"$f":"$B$7","v":2},362]
[{"$f":"'Input Prices'!A18","v":"Brace Wire"},{"$f":"'Input Prices'!B18","v":"ft."},{"$f":"'Input Prices'!$F$18","v":3.4997500000000001E-2},{"$f":"$B$10*Braces!$D$78","v":210},7.349475]
[{"$f":"'Input Prices'!A20","v":"Springs"},{"$f":"'Input Prices'!B20","v":"ea."},{"$f":"'Input Prices'!$C$20","v":10.99},{"$f":"$C$89*$B$4","v":16},175.84]
[{"$f":"'Input Prices'!A17","v":"Brace pins 1 - 10\" & 1 - 5\""},{"$f":"'Input Prices'!B17","v":"ea."},{"$f":"'Input Prices'!$C$17","v":2.16},{"$f":"$B$10*Braces!$D$77","v":7},15.120000000000001]
[{"$f":"'Input Prices'!A21","v":"Inline Strainers"},{"$f":"'Input Prices'!B21","v":"ea."},{"$f":"'Input Prices'!$C$21","v":3.49},{"$f":"($B$4*$C$89)+2","v":18},62.820000000000007]
[{"$f":"'Input Prices'!A22","v":"Battens 40\""},{"$f":"'Input Prices'!B22","v":"ea."},{"$f":"'Input Prices'!$C$22","v":3.95},{"$f":"IF($B$4<1.1,0,(IF($B$4>3.1,(ROUNDUP((($B$6-(($B$10*10)+($B$7*14)))/30)-(IF($C$85>2,$C$85-2,0)),0)-$C$89),(ROUNDUP((($B$6-(($B$10*10)+($B$7*14)))/50)-(IF($C$85>2,$C$85-2,0)),0)-$C$89))))","v":124},489.8]
[{"$f":"'Input Prices'!A23","v":"Batten Clips"},{"$f":"'Input Prices'!B23","v":"ea."},{"$f":"'Input Prices'!$C$23","v":0.06},{"$f":"$D$23*$B$4","v":496},29.759999999999998]
[{"$f":"'Input Prices'!A27","v":"Staples - Barbed For HT"},{"$f":"'Input Prices'!B27","v":"lbs."},{"$f":"'Input Prices'!$C$27","v":2.35},{"$f":"SUM($D$13:$D$15)*0.15","v":7.6499999999999995},17.977499999999999]
[{"$f":"'Input Prices'!A24","v":"Insulators "},{"$f":"'Input Prices'!B24","v":"ea."},{"$f":"'Input Prices'!$C$24","v":0.3},{"$f":"(SUM($D$13:$D$15)-($C$89*2))*$B$5","v":172},51.6]
[{"$f":"'Input Prices'!A26","v":"Bull Nose Insulators"},{"$f":"'Input Prices'!B26","v":"ea."},{"$f":"'Input Prices'!$C$26","v":1.6},{"$f":"IF($B$6<1320,($B$5*2),($B$5*($C$89*2)))","v":32},51.2]
["Charger ","ea.",{"$f":"+'Input Prices'!$C$37","v":229},0,0]
["Ground Rods and Clamps ","ea.",{"$f":"+'Input Prices'!$C$38","v":20},0,0]
["Other ","unit",0,0,0]
["Other ","unit",0,0,0]
["Other ","unit",0,0,0]
["Other ","unit",0,0,0]
[{"$f":"'Input Prices'!A39","v":"Materials Sales Tax "},{"$f":"'Input Prices'!B39","v":"%"},{"$f":"'Input Prices'!$C$39","v":9.4500000000000001E-2},null,{"$f":"SUM(E13:E33)*$C$34","v":245.32076913749998}]
["Labor Cost","ft.",2.0299999999999998,{"$f":"+$B$6","v":4000},{"$f":"IF(D35>0,$C35*D35,0)","v":8119.9999999999991}]
["Total Cost ",null,null,null,{"$f":"SUM(E12:E35)","v":10961.307744137499}]
["Total Cost per Foot ",null,null,null,{"$f":"E36/B6","v":2.7403269360343749}]
[]
["Material Cost",null,null,null,{"$f":"SUM(E13:E34)","v":2841.3077441374999}]
["Material Cost per Foot",null,null,null,{"$f":"E39/B6","v":0.71032693603437491}]
[]
["Labor Cost  ",null,null,null,{"$f":"SUM(E35:E35)","v":8119.9999999999991}]
["Labor Cost per Foot ",null,null,null,{"$f":"E42/B6","v":2.0299999999999998}]
[]
["Annual Cost",null,null,null,{"$f":"C68","v":894.45410999304158}]
["Annual Cost Per Foot",null,null,null,{"$f":"E45/B6","v":0.22361352749826038}]
[]
["Assumptions - UT Extension PB1541 & Manufacturers Specs"]
["Brace every 1320 feet"]
["40 - 150 Ft between line posts ",null,null,"Wire Spacing (Inches) - Ground up"]
["50 Ft between battens - 3 strand  ",null,null,"1 Wire = 30"]
["30 Ft between battens - 5 and 8 strand  ",null,null,"2 Wire = 20-16"]
["All brace posts driven 48\" in ground",null,null,"3 Wire = 13-11-12"]
["Inline strainer used to tension brace wire ",null,null,"5 Wire = 6-7-8-9-10"]
["In this budget wood post are every 100'  "]
[]
[]
["Labor Requirements - Source (UT Extension Custom Rate Survey - AE13-06)"]
[]
[null,{"$f":"+B4","v":4},"Strand"]
["Annual Cost",{"$f":"+B5","v":4},"Hot Wires"]
["Estimated Useful Life",null,30]
["Average Annual Maintenance (%)",null,{"$f":"+'Input Prices'!$C$56","v":0.05}]
["Depreciation",null,{"$f":"E39/C62","v":94.710258137916668}]
["Interest Rate on Investment",null,{"$f":"+'Input Prices'!$C$57","v":0.06}]
["Interest on Investment",null,{"$f":"E36*C65","v":657.67846464824993}]
["Maintenance",null,{"$f":"E39*C63","v":142.06538720687499}]
["Total Cost",null,{"$f":"C64+C66+C67","v":894.45410999304158}]
[]
[]
["Fencing Tools  "]
["Spinning Jenny",{"$f":"+'Input Prices'!$C$52","v":34.99}]
["Multi-Function Fencing Tool",{"$f":"+'Input Prices'!$C$51","v":69.75}]
["Strainer Handle",{"$f":"+'Input Prices'!$C$47","v":5.99}]
["3⁄8\" Ship Auger Drill Bit",{"$f":"+'Input Prices'!$C$46","v":28.99}]
["Other",0]
["Other",0]
["Other",0]
["Tax",{"$f":"SUM(B72:B78)*'Input Prices'!C39","v":13.20354}]
["Total",{"$f":"SUM(B72:B79)","v":152.92354}]
["Cost Per Ft",{"$f":"B80/B6","v":3.8230884999999999E-2}]
[]
[]
[null,"number","roundup"]
["Fence Braces",{"$f":"1+(B6/1320)","v":4.0303030303030303},{"$f":"ROUNDUP(B85,0)","v":5}]
["Gate and Brace",{"$f":"B7","v":2},{"$f":"ROUNDUP(B86,0)","v":2}]
["Total",null,{"$f":"SUM(C85:C86)","v":7}]
["Section ",{"$f":"(B6/1320)","v":3.0303030303030303},{"$f":"ROUNDUP(B88,0)","v":4}]
["Total",null,{"$f":"SUM(C88:C88)","v":4}]
[]
[]
[]
[]
[]
[]
[]
["High Tensile Electric"]
[null,4,"Strand"]
[null,{"$f":"B98","v":4},"Hot Wires"]
[null,4000,"Feet"]
[null,2,"Gate",null,null,null,"Your Cost"]
[]
[null,"Brace Adjustment"]
[null,{"$f":"$C$87","v":7},"Braces "]
[]
["ITEM","UNIT","PRICE","QUANTITY","TOTAL"]
[{"$f":"'Input Prices'!A102","v":"8' Post 6\"-7\""},{"$f":"'Input Prices'!B100","v":0},{"$f":"'Input Prices'!$C$6","v":17.5},{"$f":"$B$10*Braces!$D$74","v":14},{"$f":"IF(D107>0,$C107*D107,0)","v":245}]
[{"$f":"'Input Prices'!A103","v":"8' Posts 5\"-6\""},{"$f":"'Input Prices'!B101","v":0},{"$f":"'Input Prices'!$C$7","v":14.99},0,0]
[{"$f":"'Input Prices'!A104","v":"8' Post 4\"-5\""},{"$f":"'Input Prices'!B102","v":"ea."},{"$f":"'Input Prices'!$C$8","v":11.99},{"$f":"IF(ROUNDUP((($B$6-(($B$10*Braces!$E$72)+($B$7*14)))/100)-(IF($C$85>2,$C$85-2,2)),0)<0,0,ROUNDUP((($B$6-(($B$10*Braces!$E$72)+($B$7*14)))/100)-(IF($C$85>2,$C$85-2,2)),0))","v":37},443.63]
[{"$f":"+Braces!$A$75","v":"8' Brace Post 4\"-5\""},{"$f":"'Input Prices'!B104","v":"ea."},{"$f":"+Braces!$C$75","v":11.99},{"$f":"$B$10*Braces!$D$75","v":7},83.93]
[{"$f":"'Input Prices'!A113","v":"Brace pins 1 - 10\" & 1 - 5\""},{"$f":"'Input Prices'!B113","v":"ea."},{"$f":"'Input Prices'!$F$19","v":3.4997500000000001E-2},{"$f":"SUM($B$4*$B$6)","v":16000},559.96]
[{"$f":"'Input Prices'!A110","v":"Barbed Wire - Conv. 12 1/2"},{"$f":"'Input Prices'!B110","v":"roll"},{"$f":"'Input Prices'!$C$16","v":181},{"$f":"$B$7","v":2},362]
[{"$f":"'Input Prices'!A112","v":"Gate - 14'"},{"$f":"'Input Prices'!B112","v":"ea."},{"$f":"'Input Prices'!$F$18","v":3.4997500000000001E-2},{"$f":"$B$10*Braces!$D$78","v":210},7.349475]
[{"$f":"'Input Prices'!A114","v":"Brace Wire"},{"$f":"'Input Prices'!B114","v":"ft."},{"$f":"'Input Prices'!$C$20","v":10.99},{"$f":"$C$89*$B$4","v":16},175.84]
[{"$f":"'Input Prices'!A111","v":"Barbed Wire - HT 15 1/2"},{"$f":"'Input Prices'!B111","v":"roll"},{"$f":"'Input Prices'!$C$17","v":2.16},{"$f":"$B$10*Braces!$D$77","v":7},15.120000000000001]
[{"$f":"'Input Prices'!A115","v":"High Tensile Wire 12.5 Gauge"},{"$f":"'Input Prices'!B115","v":"ft."},{"$f":"'Input Prices'!$C$21","v":3.49},{"$f":"($B$4*$C$89)+2","v":18},62.820000000000007]
[{"$f":"'Input Prices'!A116","v":"Springs"},{"$f":"'Input Prices'!B116","v":"ea."},{"$f":"'Input Prices'!$C$22","v":3.95},{"$f":"IF($B$4<1.1,0,(IF($B$4>3.1,(ROUNDUP((($B$6-(($B$10*10)+($B$7*14)))/30)-(IF($C$85>2,$C$85-2,0)),0)-$C$89),(ROUNDUP((($B$6-(($B$10*10)+($B$7*14)))/50)-(IF($C$85>2,$C$85-2,0)),0)-$C$89))))","v":124},489.8]
[{"$f":"'Input Prices'!A117","v":"Inline Strainers"},{"$f":"'Input Prices'!B117","v":"ea."},{"$f":"'Input Prices'!$C$23","v":0.06},{"$f":"$D$23*$B$4","v":496},29.759999999999998]
[{"$f":"'Input Prices'!A121","v":"Long Crimp Sleeves"},{"$f":"'Input Prices'!B121","v":"ea."},{"$f":"'Input Prices'!$C$27","v":2.35},{"$f":"SUM($D$13:$D$15)*0.15","v":7.6499999999999995},17.977499999999999]
[{"$f":"'Input Prices'!A118","v":"Battens 40\""},{"$f":"'Input Prices'!B118","v":"ea."},{"$f":"'Input Prices'!$C$24","v":0.3},{"$f":"(SUM($D$13:$D$15)-($C$89*2))*$B$5","v":172},51.6]
[{"$f":"'Input Prices'!A120","v":"Insulators "},{"$f":"'Input Prices'!B120","v":"ea."},{"$f":"'Input Prices'!$C$26","v":1.6},{"$f":"IF($B$6<1320,($B$5*2),($B$5*($C$89*2)))","v":32},51.2]
["Charger ","ea.",{"$f":"+'Input Prices'!$C$37","v":229},0,0]
["Ground Rods and Clamps ","ea.",{"$f":"+'Input Prices'!$C$38","v":20},0,0]
["Other ","unit",0,0,0]
["Other ","unit",0,0,0]
["Other ","unit",0,0,0]
["Other ","unit",0,0,0]
[{"$f":"'Input Prices'!A133","v":"Electric Fence Charger "},{"$f":"'Input Prices'!B133","v":"ea."},{"$f":"'Input Prices'!$C$39","v":9.4500000000000001E-2},null,{"$f":"SUM(E107:E127)*$C$34","v":245.32076913749998}]
["Labor Cost","ft.",2.0299999999999998,{"$f":"+$B$6","v":4000},{"$f":"IF(D129>0,$C129*D129,0)","v":8119.9999999999991}]
["Total Cost ",null,null,null,{"$f":"SUM(E106:E129)","v":10961.307744137499}]
["Total Cost per Foot ",null,null,null,{"$f":"E130/B100","v":2.7403269360343749}]
[]
["Material Cost",null,null,null,{"$f":"SUM(E107:E128)","v":2841.3077441374999}]
["Material Cost per Foot",null,null,null,{"$f":"E133/B100","v":0.71032693603437491}]
[]
["Labor Cost  ",null,null,null,{"$f":"SUM(E129:E129)","v":8119.9999999999991}]
["Labor Cost per Foot ",null,null,null,{"$f":"E136/B100","v":2.0299999999999998}]
[]
["Annual Maintenance Cost",null,null,null,{"$f":"C162","v":894.45410999304158}]
["Annual Maintenance Cost Per Foot",null,null,null,{"$f":"E139/B100","v":0.22361352749826038}]
[]
["Assumptions - UT Extension PB1541 & Manufacturers Specs"]
["Brace every 1320 feet"]
["10 Ft between brace posts",null,null,"Wire Spacing (Inches) - Ground up"]
["40 - 150 Ft between line posts ",null,null,"1 Wire = 30"]
["50 Ft between battens - 3 strand  ",null,null,"2 Wire = 20-16"]
["30 Ft between battens - 5 and 8 strand  ",null,null,"3 Wire = 13-11-12"]
["All brace posts driven 48\" in ground",null,null,"5 Wire = 6-7-8-9-10"]
["Inline strainer used to tension brace wire "]
["In this budget wood post are every 100'  "]
[]
["Labor Requirements - Source (UT Extension Custom Rate Survey - AE13-06)"]
[]
[null,{"$f":"+B98","v":4},"Strand"]
["Annual Maintenance Cost",{"$f":"+B99","v":4},"Hot Wires"]
["Estimated Useful Life",null,30]
["Average Annual Maintenance (%)",null,{"$f":"+'Input Prices'!$C$56","v":0.05}]
["Depreciation",null,{"$f":"E133/C156","v":94.710258137916668}]
["Interest Rate on Investment",null,{"$f":"+'Input Prices'!$C$57","v":0.06}]
["Interest on Investment",null,{"$f":"E130*C159","v":657.67846464824993}]
["Maintenance",null,{"$f":"E133*C157","v":142.06538720687499}]
["Total Cost",null,{"$f":"C158+C160+C161","v":894.45410999304158}]
[]
[]
["Fencing Tools  "]
["Spinning Jenny",{"$f":"+'Input Prices'!$C$52","v":34.99}]
["Multi-Function Fencing Tool",{"$f":"+'Input Prices'!$C$51","v":69.75}]
["Strainer Handle",{"$f":"+'Input Prices'!$C$47","v":5.99}]
["3⁄8\" Ship Auger Drill Bit",{"$f":"+'Input Prices'!$C$46","v":28.99}]
["Other",0]
["Other",0]
["Other",0]
["Tax",{"$f":"SUM(B166:B172)*'Input Prices'!C39","v":13.20354}]
["Total",{"$f":"SUM(B166:B173)","v":152.92354}]
[null,{"$f":"B174/B100","v":3.8230884999999999E-2}]

{"sheet":"Poly Fence","index":7,"n_rows":103,"n_cols":13,"rows_kept":103,"cut":false,"hidden":false,"merged":[[86,0,86,2],[88,0,88,2],[89,0,89,2],[25,0,25,3],[26,0,26,3],[28,0,28,3],[29,0,29,3],[31,0,31,3],[32,0,32,3],[34,0,34,3],[35,0,35,3],[79,0,79,2],[80,0,80,2],[82,0,82,2],[83,0,83,2],[85,0,85,2],[2,0,2,4],[5,6,5,8],[6,3,6,4],[56,2,56,4],[60,3,60,4]]}
[]
[]
["Temporary Poly Fence"]
[null,null,1000,"Feet"]
[null,null,null,null,null,null,"Directory"]
[null,null,null,null,null,null,"Intro"]
[null,null,null,"Poly Fence",null,null,"Input Prices"]
[null,null,null,null,null,null,"Barbed Wire"]
["ITEM","UNIT","PRICE","QUANTITY","TOTAL",null,"Woven Wire"]
[{"$f":"'Input Prices'!A8","v":"8' Post 4\"-5\""},{"$f":"'Input Prices'!B8","v":"ea."},{"$f":"'Input Prices'!$C$8","v":11.99},0,{"$f":"IF(D10>0,$C10*D10,0)","v":0},null,"HT Fixed Knot"]
[{"$f":"'Input Prices'!A31","v":"Step-in Fiberglass Post"},{"$f":"'Input Prices'!B31","v":"ea."},{"$f":"'Input Prices'!$C$31","v":2.69},{"$f":"ROUNDUP($C$4/40,0)","v":25},67.25,null,"HT Electric",null,null,null,null,{"$f":"E11","v":67.25},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Input Prices'!A32","v":"Polywire"},"ft.",{"$f":"'Input Prices'!$F$32","v":2.743140243902439E-2},{"$f":"+$C$4","v":1000},27.431402439024389,null,null,null,null,null,null,27.431402439024389,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Input Prices'!A33","v":"Polytape"},"ft.",{"$f":"'Input Prices'!$F$33","v":0.05},0,0,null,null,null,null,null,null,0,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Input Prices'!A34","v":"Cut-Out Switch"},{"$f":"'Input Prices'!B34","v":"ea."},{"$f":"'Input Prices'!$C$34","v":15.99},1,15.99,null,null,null,null,null,null,15.99,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Input Prices'!A35","v":"Reel"},{"$f":"'Input Prices'!B35","v":"ea."},{"$f":"'Input Prices'!$C$35","v":39},1,39,null,null,null,null,null,null,39,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Input Prices'!A36","v":"Handle "},{"$f":"'Input Prices'!B36","v":"ea."},{"$f":"'Input Prices'!$C$36","v":3.99},1,3.99,null,null,null,null,null,null,3.99,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"'Input Prices'!A24","v":"Insulators "},{"$f":"'Input Prices'!B24","v":"ea."},{"$f":"'Input Prices'!$C$24","v":0.3},2,0.6,null,null,null,null,null,null,0.6,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Charger ","ea.",{"$f":"+'Input Prices'!$C$37","v":229},0,0,null,null,null,null,null,null,0,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Ground Rods and Clamps ","ea.",{"$f":"+'Input Prices'!$C$38","v":20},0,0,null,null,null,null,null,null,0,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Other ","unit",0,0,0,null,null,null,null,null,null,0,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Other ","unit",0,0,0,null,null,null,null,null,null,0,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Other ","unit",0,0,0,null,null,null,null,null,null,0,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Other ","unit",0,0,0,null,null,null,null,null,null,0,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Materials Sales Tax","%",{"$f":"+'Input Prices'!C39","v":9.4500000000000001E-2},null,{"$f":"SUM(D24)*C24","v":0},null,null,null,null,null,null,0,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Labor","ft.",0,0,{"$f":"IF(D25>0,$C25*D25,0)","v":0},null,null,null,null,null,null,0,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Total Cost ",null,null,null,{"$f":"SUM(E9:E25)","v":154.26140243902441}]
["Total Cost per Foot ",null,null,null,{"$f":"E26/C4","v":0.15426140243902442}]
[]
["Material Cost",null,null,null,{"$f":"SUM(E10:E23)","v":154.26140243902441}]
["Material Cost per Foot",null,null,null,{"$f":"E29/C4","v":0.15426140243902442}]
[]
["Labor Cost  ",null,null,null,{"$f":"SUM(E23:E23)","v":0}]
["Labor Cost per Foot ",null,null,null,{"$f":"E32/C4","v":0}]
[]
["Annual Cost",null,null,null,{"$f":"C49","v":55.534104878048787}]
["Annual Cost Per Foot",null,null,null,{"$f":"E35/C4","v":5.5534104878048787E-2}]
[]
["Assumptions "]
["Wood post on each end"]
["40 ft. between each step-in post "]
[]
["Annual Cost",null,"Total Cost"]
["Estimated Useful Life",null,4]
["Average Annual Maintenance (%)",null,{"$f":"+'Input Prices'!$C$56","v":0.05}]
["Depreciation",null,{"$f":"E29/C43","v":38.565350609756102}]
["Interest Rate on Investment",null,{"$f":"+'Input Prices'!$C$57","v":0.06}]
["Interest on Investment",null,{"$f":"E26*C46","v":9.2556841463414639}]
["Maintenance",null,{"$f":"E29*C44","v":7.7130701219512208}]
["Total Cost",null,{"$f":"C45+C47+C48","v":55.534104878048787}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Temporary Poly Fence"]
[null,null,1000,"Feet"]
[]
[]
[null,null,null,"Poly Fence"]
[]
["ITEM","UNIT","PRICE","QUANTITY","TOTAL"]
["8' Post 4\"-5\"","ea.",{"$f":"'Input Prices'!$C$8","v":11.99},0,{"$f":"IF(D64>0,$C64*D64,0)","v":0}]
["Step-in Fiberglass Post","ea.",{"$f":"'Input Prices'!$C$31","v":2.69},{"$f":"ROUNDUP($C$4/40,0)","v":25},67.25]
["Polywire","ft.",{"$f":"'Input Prices'!$F$32","v":2.743140243902439E-2},{"$f":"+$C$4","v":1000},27.431402439024389]
["Polytape","ft.",{"$f":"'Input Prices'!$F$33","v":0.05},0,0]
["Cut-Out Switch","ea.",{"$f":"'Input Prices'!$C$34","v":15.99},1,15.99]
["Reel","ea.",{"$f":"'Input Prices'!$C$35","v":39},1,39]
["Handle ","ea.",{"$f":"'Input Prices'!$C$36","v":3.99},1,3.99]
["Insulators ","ea.",{"$f":"'Input Prices'!$C$24","v":0.3},2,0.6]
["Charger ","ea.",{"$f":"+'Input Prices'!$C$37","v":229},0,0]
["Ground Rods and Clamps ","ea.",{"$f":"+'Input Prices'!$C$38","v":20},0,0]
["Other ","unit",0,0,0]
["Other ","unit",0,0,0]
["Other ","unit",0,0,0]
["Other ","unit",0,0,0]
["Materials Sales Tax","%",{"$f":"+'Input Prices'!C$39","v":9.4500000000000001E-2},null,{"$f":"SUM(E64:E77)*C78","v":14.577702530487807}]
["Labor","ft.",0,0,{"$f":"IF(D79>0,$C79*D79,0)","v":0}]
["Total Cost ",null,null,null,{"$f":"SUM(E63:E79)","v":168.83910496951222}]
["Total Cost per Foot ",null,null,null,{"$f":"E80/C58","v":0.16883910496951221}]
[]
["Material Cost",null,null,null,{"$f":"SUM(E64:E77)","v":154.26140243902441}]
["Material Cost per Foot",null,null,null,{"$f":"E83/C58","v":0.15426140243902442}]
[]
["Labor Cost  ",null,null,null,{"$f":"SUM(E77:E77)","v":0}]
["Labor Cost per Foot ",null,null,null,{"$f":"E86/C58","v":0}]
[]
["Annual Maintenance Cost",null,null,null,{"$f":"C103","v":52.072479007317085}]
["Annual Maintenance Cost Per Foot",null,null,null,{"$f":"E89/C58","v":5.2072479007317082E-2}]
[]
["Assumptions "]
["Wood post on each end"]
["40 ft. between each step-in post "]
[]
["Annual Maintenance Cost",null,"Total Cost"]
["Estimated Useful Life",null,4]
["Average Annual Maintenance (%)",null,{"$f":"+'Input Prices'!$C$56","v":0.05}]
["Depreciation",null,{"$f":"E83/C97","v":38.565350609756102}]
["Interest Rate on Investment",null,{"$f":"+'Input Prices'!$C$57","v":0.06}]
["Interest on Investment",null,{"$f":"E80*0.5*C100","v":5.0651731490853669}]
["Maintenance",null,{"$f":"E80*C98","v":8.4419552484756117}]
["Total Cost",null,{"$f":"C99+C101+C102","v":52.072479007317085}]