{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["2016 Land Storage Worksheet"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"2016 Land Storage Worksheet","index":0,"n_rows":163,"n_cols":64,"rows_kept":163,"merged":[[0,1,0,13],[1,1,1,13],[2,4,2,8],[2,10,2,13],[3,4,3,8],[3,10,3,13],[4,4,4,5],[4,7,4,8],[4,10,4,13],[5,1,5,13],[6,1,6,13],[7,4,7,5],[7,6,7,7],[7,12,7,13],[8,4,8,5],[8,6,8,7],[8,12,8,13],[9,4,9,5],[9,6,9,7],[9,12,9,13],[10,4,10,5],[10,6,10,7],[10,12,10,13],[11,4,11,5],[11,6,11,7],[11,12,11,13],[12,4,12,5],[12,6,12,7],[12,8,12,9],[12,12,12,13],[13,1,13,13],[14,1,14,13],[15,1,15,13],[17,10,17,13],[18,10,18,13],[19,10,19,13],[20,10,20,13],[21,10,21,13],[22,10,22,13],[23,10,23,13],[24,1,24,13],[26,10,26,13],[27,10,27,13],[28,1,28,13],[30,10,30,13],[31,10,31,13],[32,10,32,13],[33,10,33,13],[34,1,34,13],[36,10,36,13],[37,10,37,13],[38,10,38,13],[39,10,39,13],[40,10,40,13],[41,10,41,13],[42,1,42,13],[42,16,42,19],[42,20,42,28],[42,29,42,30],[42,31,42,45],[42,46,42,50],[43,16,44,16],[43,17,44,17],[43,18,44,18],[43,19,44,19],[43,20,44,20],[43,21,44,21],[43,22,44,22],[43,23,44,23],[43,24,44,24],[43,25,44,25],[43,26,44,26],[43,27,44,27],[43,28,44,28],[43,29,44,29],[43,30,44,30],[43,31,44,31],[43,32,44,32],[43,33,44,33],[43,34,44,34],[43,35,44,35],[43,36,44,36],[43,37,44,37],[43,38,44,38],[43,39,44,39],[43,40,44,40],[43,41,44,41],[43,42,44,42],[43,43,44,43],[43,44,44,44],[43,45,44,45],[43,46,44,46],[43,47,44,47],[43,48,44,48],[43,49,44,49],[43,50,44,50],[44,10,44,13],[45,10,45,13],[46,10,46,13],[47,10,47,13],[48,10,48,13],[49,10,49,13],[50,10,50,13],[51,10,51,13],[52,10,52,13],[53,10,53,13],[55,1,55,13],[55,16,55,22],[55,28,55,40],[55,41,55,58],[55,59,55,63],[56,15,57,15],[56,16,57,16],[56,17,57,17],[56,18,57,18],[56,19,57,19],[56,20,57,20],[56,21,57,21],[56,22,57,22],[56,23,57,23],[56,24,57,24],[56,25,57,25],[56,26,57,26],[56,27,57,27],[56,28,57,28],[56,29,57,29],[56,30,57,30],[56,31,57,31],[56,32,57,32],[56,33,57,33],[56,34,57,34],[56,35,57,35],[56,36,57,36],[56,37,57,37],[56,38,57,38],[56,39,57,39],[56,40,57,40],[56,41,57,41],[56,42,57,42],[56,43,57,43],[56,44,57,44],[56,45,57,45],[56,46,57,46],[56,47,57,47],[56,48,57,48],[56,49,57,49],[56,50,57,50],[56,51,57,51],[56,52,57,52],[56,53,57,53],[56,54,57,54],[56,55,57,55],[56,56,57,56],[56,57,57,57],[56,58,57,58],[56,59,57,59],[56,60,57,60],[56,61,57,61],[56,62,57,62],[56,63,57,63],[57,10,57,13],[58,10,58,13],[59,10,59,13],[60,10,60,13],[61,10,61,13],[62,10,62,13],[63,10,63,13],[64,10,64,13],[65,10,65,13],[66,1,66,13],[66,16,66,19],[66,20,66,23],[67,16,68,16],[67,17,68,17],[67,18,68,18],[67,19,68,19],[67,20,68,20],[67,21,68,21],[67,22,68,22],[67,23,68,23],[68,10,68,13],[69,10,69,13],[70,10,70,13],[71,10,71,13],[72,10,72,13],[73,10,73,13],[74,10,74,13],[75,10,75,13],[76,1,76,13],[76,15,77,15],[78,10,78,13],[79,10,79,13],[80,10,80,13],[81,10,81,13],[82,10,82,13],[83,10,83,13],[84,10,84,13],[85,10,85,13],[86,10,86,13],[87,10,87,13],[88,10,88,13],[89,10,89,13],[90,10,90,13],[91,1,91,13],[92,1,92,9],[92,10,92,12],[93,1,93,9],[93,10,93,12],[94,1,94,9],[94,10,94,12],[95,1,95,9],[95,10,95,12],[96,1,96,9],[96,10,96,12],[100,1,100,5],[100,7,100,10],[100,12,100,13],[101,1,101,5],[101,7,101,10],[101,12,101,13],[103,1,103,5],[103,7,103,10],[103,12,103,13],[104,1,104,5],[104,7,104,10],[104,12,104,13],[106,1,107,13],[109,1,109,13],[111,1,111,13],[112,1,112,13],[113,1,113,13],[114,1,114,13],[115,1,115,13],[116,1,116,13],[117,1,117,13],[118,1,118,13],[119,1,119,13],[120,1,120,13],[121,1,121,13],[122,1,122,13],[123,1,123,13],[124,1,124,13],[125,1,125,13],[126,1,126,13],[127,1,127,13],[128,1,128,13],[129,4,129,8],[129,10,129,13],[130,4,130,8],[130,10,130,13],[131,4,131,5],[131,7,131,8],[131,10,131,13],[132,4,132,5],[132,7,132,8],[132,10,132,13],[133,4,133,5],[133,7,133,8],[133,10,133,13],[134,1,134,13],[135,1,136,13],[137,1,137,13],[138,1,138,13],[139,1,139,13],[140,1,140,13],[141,1,141,13],[142,1,142,13],[143,1,143,13],[144,1,144,13],[145,1,145,13],[146,1,146,13],[147,1,147,13],[148,1,148,13],[149,1,149,13],[150,1,150,13],[151,1,151,13],[152,1,152,13],[153,1,153,13],[154,1,154,3],[154,4,154,6],[154,10,154,12],[159,4,159,7],[159,9,159,13],[161,4,161,7],[161,9,161,13],[162,1,162,13]]}
[]
[null,"OWNER INFORMATION"]
[null,"Name",{"$nulls":7},"Email"]
[null,"Address",{"$nulls":7},"Postal Code"]
[null,"Home Ph",{"$nulls":4},"Work Ph",null,null,"Cell Phone"]
[]
[null,"BOAT DESCRIPTION",{"$nulls":13},"Dropdown Controls",null,null,"Engine","Drive","Fuel","Generator","Cyl"]
[null,"Year",{"$nulls":4},"Length Overall ",null,null,"(Ft)","Engine Make",null,{"$f":"Q9","v":""},null,null,"Engine",9,1,"Caterpillar","Inboard","Gas","Fisher-Panda",4]
[null,"Make",{"$nulls":4},"Beam",null,null,"(Ft)","Engine Model",{"$nulls":5},{"$f":"IF($Q$8=1,S8,IF($Q$8=2,S9,IF($Q$8=3,S10,IF($Q$8=4,S11,IF($Q$8=5,S12,IF($Q$8=6,S13,IF($Q$8=7,S14,IF($Q$8=8,S15,\"\"))))))))","v":""},2,"Crusader","IPS","Diesel","Kohler",6]
[null,"Model",{"$nulls":4},"# of Batteries",{"$nulls":3},"Drive Type",null,{"$f":"Q11","v":""},null,null,"Drive",10,3,"Cummins","Jet",null,"Onan",8]
[null,"Hull Number",{"$nulls":4},"Fuel Onboard (Est)",null,null,"(Gal)","# of Cylinders",{"$nulls":5},{"$f":"IF($Q$10=1,T8,IF($Q$10=2,T9,IF($Q$10=3,T10,IF($Q$10=4,T11,IF($Q$10=5,T12,IF($Q$10=6,T13,IF($Q$10=7,T14,IF($Q$10=8,T15,\"\"))))))))","v":""},4,"Mercury","Outboard",null,"Quicksilver","Other"]
[null,"Lic Number",{"$nulls":4},"Fuel Type",null,{"$f":"Q15","v":"Gas"},null,"# of Engines",{"$nulls":4},"Gen",7,5,"Volvo","Merc Alpha",null,"Westerbeke"]
[null,"Boat Name",{"$nulls":4},"Key Location",{"$nulls":3},"Generator",null,{"$f":"Q13","v":""},{"$nulls":3},{"$f":"IF($Q$12=1,V8,IF($Q$12=2,V9,IF($Q$12=3,V10,IF($Q$12=4,V11,IF($Q$12=5,V12,IF($Q$12=6,V13,\"\"))))))","v":""},6,"Yamaha","Merc Bravo",null,"Other"]
[{"$nulls":15},"Fuel",1,7,"Yanmar","Volvo SX",null,"n/a"]
[null,"SERVICE ESTIMATES",{"$nulls":14},{"$f":"IF($Q$14=1,U8,IF($Q$14=2,U9,\"\"))","v":"Gas"},8,"Other","Volvo DP"]
[{"$nulls":15},"Cyl",3,9,null,"Other I/O"]
[null,"1. HAULOUT (Per Ft LOA)",{"$nulls":4},"QTY","RATE","PRICE",{"$nulls":3},"JOB SUB-TOTAL",{"$f":"SUM(I18:I24)","v":0},null,null,{"$f":"IF($Q$16=1,W8,IF($Q$16=2,W9,IF($Q$16=3,W10,IF($Q$16=2,W11,\"\"))))","v":8}]
[null,null,false,"Forklift ",null,"Up to 22'",{"$f":"IF(AND($I$8>0, $I$8<23,C18=TRUE),$I$8,0)","v":0},{"v":7,"d":"$7.00"},{"$f":"G18*H18","v":0}]
[null,null,false,"Hydraulic Trailer",null,"23' - 29'",{"$f":"IF(AND($I$8>22, $I$8<30,C19=TRUE),$I$8,0)","v":0},{"v":8,"d":"$8.00"},0]
[]
[null,null,false,"Marine Travelift",null,"30' - 39'",{"$f":"IF(AND($I$8>29, $I$8<40,C21=TRUE),$I$8,0)","v":0},{"v":12,"d":"$12.00"},0]
[null,null,false,"Marine Travelift",null,"40' - 49'",{"$f":"IF(AND($I$8>39, $I$8<50,C22=TRUE),$I$8,0)","v":0},{"v":16,"d":"$16.00"},0]
[null,null,false,"Marine Travelift",null,"50' - 60'",{"$f":"IF(AND($I$8>49, $I$8<61,C23=TRUE),$I$8,0)","v":0},{"v":18,"d":"$18.00"},0]
[null,null,false,"Blocking",null,"All",{"$f":"SUM(G18:G23)","v":0},{"v":2.5,"d":"$2.50"},0]
[]
[null,"2. BOTTOM WASHING (Per Ft LOA)",{"$nulls":4},"QTY","RATE","PRICE",{"$nulls":3},"JOB SUB-TOTAL",{"$f":"SUM(I27:I28)","v":0}]
[null,null,false,"Painted Bottom - Steam Only",null,null,{"$f":"IF(AND($I$8>0, $I$8<61,C27=TRUE),$I$8,0)","v":0},{"v":5.75,"d":"$5.75"},{"$f":"G27*H27","v":0}]
[null,null,false,"Gelcoat Bottom - Chemical",null,null,{"$f":"IF(AND($I$8>0, $I$8<61,C28=TRUE),$I$8,0)","v":0},{"v":10,"d":"$10.00"},{"$f":"G28*H28","v":0}]
[]
[null,"3. SHRINK WRAP (Per Sq Ft)",{"$nulls":4},"QTY","RATE","PRICE",{"$nulls":3}," JOB SUB-TOTAL",{"$f":"SUM(I31:I34)","v":0}]
[null,null,false,"Any Size Boat - LOA x Beam",null,null,{"$f":"IF(AND($I$8>0, $I$8<61,C31=TRUE),$I$8*$I$9,0)","v":0},{"v":2.15,"d":"$2.15"},{"$f":"G31*H31","v":0}]
[null,null,false,"Supply & Install Access Door",null,null,{"$f":"IF(AND($I$8>0, $I$8<61,C32=TRUE,C31=TRUE),1,0)","v":0},{"v":60,"d":"$60.00"},{"$f":"G32*H32","v":0}]
[null,null,false,"Surcharge for Flybridge",null,null,{"$f":"IF(AND($I$8>0, $I$8<61,C33=TRUE,C31=TRUE),1,0)","v":0},{"v":120,"d":"$120.00"},{"$f":"G33*H33","v":0}]
[null,null,false,"No Damp Dehumidifier (Ea.)",null,null,{"v":1,"d":"1.0"},{"v":8.95,"d":"$8.95"},{"$f":"IF(AND($I$8>0, $I$8<61,C34=TRUE),G34*H34,0)","v":0}]
[]
[null,"4. LAND STORAGE (Per Ft LOA)",{"$nulls":4},"QTY","RATE","PRICE",{"$nulls":3},"JOB SUB-TOTAL",{"$f":"SUM(I37:I42)","v":0}]
[null,null,false,"Storage to May 31",null,"Up to 25'",{"$f":"IF(AND($I$8>0, $I$8<26,C37=TRUE),$I$8,0)","v":0},{"v":27.5,"d":"$27.50"},{"$f":"G37*H37","v":0}]
[null,null,false,"Storage to May 31",null,"26' - 29'",{"$f":"IF(AND($I$8>25, $I$8<30,C38=TRUE),$I$8,0)","v":0},{"v":30.25,"d":"$30.25"},0]
[null,null,false,"Storage to May 31",null,"30' - 34'",{"$f":"IF(AND($I$8>29, $I$8<35,C39=TRUE),$I$8,0)","v":0},{"v":33,"d":"$33.00"},0]
[null,null,false,"Storage to May 31",null,"35' & Up",{"$f":"IF(AND($I$8>34,C40=TRUE),$I$8,0)","v":0},{"v":38.5,"d":"$38.50"},0]
[null,null,false,"PWC / Dinghy Storage",null,"All",{"$f":"IF(C41=TRUE,1,0)","v":0},{"v":275,"d":"$275.00"},0]
[null,null,false,"Drive Lock (Mandatory for I/O's)",null,null,{"$f":"IF(AND($I$8>0,Q10>4,C42=TRUE),$M$12,0)","v":0},{"v":60,"d":"$60.00"},0]
[{"$nulls":16},"Universal Parts",{"$nulls":3},"Fuel Filters",{"$nulls":8},"Gear Oil",null,"Engine Winterize Parts Summary",{"$nulls":14},"Generator Winterize Parts"]
[null,"5. ENGINE WINTERIZE",{"$nulls":4},"QTY","RATE","LABOUR","PARTS",null,null,"JOB SUB-TOTAL",{"$f":"SUM(I45:I54)+SUM(J45:J54)","v":0},null,null,"Antifreeze/Gal","Fuel Stab 60 Gal","Diesel Cond 60 Gal","Storage Seal Mix","Crusader Fuel Filter","Merc IB Fuel Filter","Merc OB Fuel Filter","Volvo Fuel Filter","Kohler Fuel Filter","Onan Fuel Filter","Quicksilver Fuel Filter","Westerbeke Fuel Filter","Yamaha Fuel Filter","Merc OB Gear Oil","Yamaha Gear Oil","Caterpillar Parts","Crusader Parts","Cummins Parts","Merc IB 4CYL Parts","Merc IB 6CYL Parts","Merc IB 8CYL Parts","Merc OB Parts <125","Merc OB Parts >125","Volvo Gas 4CYL Parts","Volvo Gas 6CYL Parts","Volvo Gas 8CYL Parts","Volvo Diesel Parts","Yamaha Parts <125","Yamaha Parts >125","Yanmar Parts","Fischer Panda Prts","Kohler Parts","Onan Parts","Quicksilver Parts","Westerbeke Parts"]
[null,null,false,"Gas Engine",null,{"$f":"IF(AND($Q$14=1,$Q$8=2,Q10<>4),S9,IF(AND($Q$14=1,$Q$8=4,Q10<>4),S11,IF(AND($Q$14=1,$Q$8=5,Q10<>4),S12,IF(AND($Q$14=1,$Q$8=6,Q10<>4),S13,IF(AND($Q$14=1,$Q$8=8,Q10<>4),S15,\"\")))))","v":""},{"$f":"IF(AND($Q$14=1,C45=TRUE,Q10<>4,Q10<>3),$M$12,0)","v":0},{"v":126,"d":"$126.00"},{"$f":"IF(OR($Q$8=2,$Q$8=4,$Q$8=5,$Q$8=6,$Q$8=8),(G45*H45),0)","v":0},{"$f":"IF(AND($Q$14=1,$Q$8=2,C45=TRUE,Q10<>4),(AG47*G45),IF(AND($Q$14=1,$Q$8=4,C45=TRUE,Q10<>4,Q16=1),(AI47*G45),IF(AND($Q$14=1,$Q$8=4,C45=TRUE,Q10<>4,Q16=2),(AJ47*G45),IF(AND($Q$14=1,$Q$8=4,C45=TRUE,Q10<>4,Q16=3),(AK47*G45),IF(AND($Q$14=1,$Q$8=5,C45=TRUE,Q10<>4,Q16=1),(AN47*G45),IF(AND($Q$14=1,$Q$8=5,C45=TRUE,Q10<>4,Q16=2),(AO47*G45),IF(AND($Q$14=1,$Q$8=5,C45=TRUE,Q10<>4,Q16=3),(AP47*G45),0)))))))","v":0},{"$nulls":5},"Material"]
[null,null,false,"Diesel Engine",null,{"$f":"IF(AND($Q$14=2,$Q$8=1),S8,IF(AND($Q$14=2,$Q$8=3),S10,IF(AND($Q$14=2,$Q$8=5),S12,IF(AND($Q$14=2,$Q$8=7),S14,IF(AND($Q$14=2,$Q$8=8),S15,\"\")))))","v":""},{"$f":"IF(AND($Q$14=2,C46=TRUE,Q10<>4,Q10<>3),$M$12,0)","v":0},{"v":150,"d":"$150.00"},{"$f":"IF(OR($Q$8=1,$Q$8=3,$Q$8=5,$Q$8=7,$Q$8=8),(G46*H46),0)","v":0},{"$f":"IF(AND($Q$14=2,$Q$8=1,C46=TRUE,Q10<>4),(AF47*G46),IF(AND($Q$14=2,$Q$8=3,C46=TRUE,Q10<>4),(AH47*G46),IF(AND($Q$14=2,$Q$8=5,C46=TRUE,Q10<>4),(AQ47*G46),IF(AND($Q$14=2,$Q$8=7,C46=TRUE,Q10<>4),(AT47*G46),IF(AND($Q$14=2,$Q$8=8,C46=TRUE,Q10<>4),\"Quote\",0)))))","v":0},{"$nulls":5},"P/N","74-312G55","710-92-8m0047922","74-93116c","SSM","35-802893Q01","35-802893Q01","35-8m0060041",3847644,"35-802893Q01","?","?","?","6P3-Ws24A-01"]
[null,null,false,"Generator - Gas",null,{"$f":"IF(AND($Q$14=1,$Q$12=1),V8,IF(AND($Q$14=1,$Q$12=2),V9,IF(AND($Q$14=1,$Q$12=3),V10,IF(AND($Q$14=1,$Q$12=4),V11,IF(AND($Q$14=1,$Q$12=5),V12,IF(AND($Q$14=1,$Q$12=6),V13,\"\"))))))","v":""},{"$f":"IF(AND($Q$14=1,Q12<7,C47=TRUE),1,0)","v":0},{"v":95,"d":"$95.00"},{"$f":"IF(OR($Q$12=1,$Q$12=2,$Q$12=3,$Q$12=4,$Q$12=5,$Q$12=6),(G47*H47),0)","v":0},{"$f":"IF(AND($Q$14=1,$Q$12=1,C47=TRUE),(AU47*G47),IF(AND($Q$14=1,$Q$12=2,C47=TRUE),(AV47*G47),IF(AND($Q$14=1,$Q$12=3,C47=TRUE),(AW47*G47),IF(AND($Q$14=1,$Q$12=4,C47=TRUE),(AX47*G47),IF(AND($Q$14=1,$Q$12=5,C47=TRUE),(AY47*G47),IF(AND($Q$14=1,$Q$12=6,C47=TRUE),\"Quote\",0))))))","v":0},{"$nulls":5},"Price",{"v":7.69,"d":"$7.69"},{"v":14.95,"d":"$14.95"},{"v":34.99,"d":"$34.99"},{"v":6.5,"d":"$6.50"},{"v":16.05,"d":"$16.05"},{"v":16.05,"d":"$16.05"},{"v":62.99,"d":"$62.99"},{"v":22.33,"d":"$22.33"},{"v":16.05,"d":"$16.05"},{"v":16.05,"d":"$16.05"},{"v":16.05,"d":"$16.05"},{"v":16.05,"d":"$16.05"},{"v":18.99,"d":"$18.99"},{"v":38.22,"d":"$38.22"},{"v":48.53,"d":"$48.53"},{"$f":"(Q47*8)+S47","v":{"v":96.51,"d":"$96.51"}},{"$f":"(Q47*6)+R47+T47+U47","v":{"v":83.64,"d":"$83.64"}},{"$f":"(Q47*8)+S47","v":{"v":96.51,"d":"$96.51"}},{"$f":"(Q47*4)+R47+T47+V47","v":{"v":68.26,"d":"$68.26"}},{"$f":"(Q47*5)+R47+T47+V47","v":{"v":75.95,"d":"$75.95"}},{"$f":"(Q47*6)+R47+T47+V47","v":{"v":83.64,"d":"$83.64"}},{"$f":"(Q47*2)+R47+T47+W47+AD47","v":{"v":138.04,"d":"$138.04"}},{"$f":"(Q47*2)+R47+T47+W47+(AD47*1.25)","v":{"v":147.595,"d":"$147.60"}},{"$f":"(Q47*4)+R47+T47+X47","v":{"v":74.53999999999999,"d":"$74.54"}},{"$f":"(Q47*5)+R47+T47+X47","v":{"v":82.23,"d":"$82.23"}},{"$f":"(Q47*6)+R47+T47+X47","v":{"v":89.92,"d":"$89.92"}},{"$f":"(Q47*8)+S47","v":{"v":96.51,"d":"$96.51"}},{"$f":"(Q47*2)+R47+T47+AC47+AE47","v":{"v":104.35,"d":"$104.35"}},{"$f":"(Q47*2)+R47+T47+AC47+(AE47*1.25)","v":{"v":116.48249999999999,"d":"$116.48"}},{"$f":"(Q47*8)+S47","v":{"v":96.51,"d":"$96.51"}},{"$f":"(Q47*3)+R47+T47+Y47","v":{"v":60.56999999999999,"d":"$60.57"}},{"$f":"(Q47*3)+R47+T47+Y47","v":{"v":60.56999999999999,"d":"$60.57"}},{"$f":"(Q47*3)+R47+T47+Y47","v":{"v":60.56999999999999,"d":"$60.57"}},{"$f":"(Q47*3)+R47+T47+Y47","v":{"v":60.56999999999999,"d":"$60.57"}},{"$f":"(Q47*3)+R47+T47+Y47","v":{"v":60.56999999999999,"d":"$60.57"}}]
[null,null,false,"Generator - Diesel",null,{"$f":"IF(AND($Q$14=2,$Q$12=1),V8,IF(AND($Q$14=2,$Q$12=2),V9,IF(AND($Q$14=2,$Q$12=3),V10,IF(AND($Q$14=2,$Q$12=4),V11,IF(AND($Q$14=2,$Q$12=5),V12,IF(AND($Q$14=2,$Q$12=6),V13,\"\"))))))","v":""},{"$f":"IF(AND($Q$14=2,Q12<7,C48=TRUE),1,0)","v":0},{"v":100,"d":"$100.00"},{"$f":"IF(OR($Q$12=1,$Q$12=2,$Q$12=3,$Q$12=4,$Q$12=5,$Q$12=6),(G48*H48),0)","v":0},{"$f":"IF(AND($Q$14=2,$Q$12=1,C48=TRUE),(AU47*G48),IF(AND($Q$14=2,$Q$12=2,C48=TRUE),(AV47*G48),IF(AND($Q$14=2,$Q$12=3,C48=TRUE),(AW47*G48),IF(AND($Q$14=2,$Q$12=4,C48=TRUE),(AX47*G48),IF(AND($Q$14=2,$Q$12=5,C48=TRUE),(AY47*G48),IF(AND($Q$14=2,$Q$12=6,C48=TRUE),\"Quote\",0))))))","v":0}]
[null,null,false,"4-Stroke O/B <125HP",null,{"$f":"IF(AND($Q$14=1,$Q$10=4,Q8=4,M9<126),S11,IF(AND($Q$14=1,$Q$10=4,Q8=6,M9<126),S13,IF(AND($Q$14=1,$Q$10=4,Q8=8,M9<126),S15,\"\")))","v":""},{"$f":"IF(AND($Q$14=1,Q10=4,M9<126,C49=TRUE),$M$12,0)","v":0},{"v":142.5,"d":"$142.50"},{"$f":"IF(OR($Q$8=4,$Q$8=6,$Q$8=8),(G49*H49),0)","v":0},{"$f":"IF(AND($Q$14=1,$Q$8=4,C49=TRUE,Q10=4),(AL47*G49),IF(AND($Q$14=1,$Q$8=6,C49=TRUE,Q10=4),(AR47*G49),IF(AND($Q$14=1,$Q$8=8,C49=TRUE,Q10=4),\"Quote\",0)))","v":0}]
[null,null,false,"4-Stroke O/B >125HP",null,{"$f":"IF(AND($Q$14=1,$Q$10=4,Q8=4,M9>125),S11,IF(AND($Q$14=1,$Q$10=4,Q8=6,M9>125),S13,IF(AND($Q$14=1,$Q$10=4,Q8=8,M9>125),S15,\"\")))","v":""},{"$f":"IF(AND($Q$14=1,Q10=4,M9>125,C50=TRUE),$M$12,0)","v":0},{"v":142.5,"d":"$142.50"},{"$f":"IF(OR($Q$8=4,$Q$8=6,$Q$8=8),(G50*H50),0)","v":0},{"$f":"IF(AND($Q$14=1,$Q$8=4,C50=TRUE,Q10=4),(AM47*G50),IF(AND($Q$14=1,$Q$8=6,C50=TRUE,Q10=4),(AS47*G50),IF(AND($Q$14=1,$Q$8=8,C50=TRUE,Q10=4),\"Quote\",0)))","v":0}]
[null,null,false,"2-Stroke Outboard",null,null,0,"Quote","Quote","Quote"]
[null,null,false,"PWC - 4-Stroke",null,null,{"$f":"IF(AND($Q$14=1,$Q$10=3,C52=TRUE),1,0)","v":0},{"v":142.5,"d":"$142.50"},{"$f":"G52*H52","v":0},{"$f":"IF(AND($Q$14=1,$Q$8=4,C52=TRUE,Q10=3),(AM47*G52),IF(AND($Q$14=1,$Q$8=6,C52=TRUE,Q10=3),(AS47*G52),0))","v":0}]
[null," ",false,"Battery Service",null,null,{"$f":"IF(AND($I$8>0,C53=TRUE),$I$10,0)","v":0},{"v":12,"d":"$12.00"},{"$f":"G53*H53","v":0},0]
[null,null,true,"Shop Supplies",null,null,{"$f":"SUM(G45:G52)","v":0},{"v":2,"d":"$2.00"},0,{"$f":"G54*H54","v":0}]
[]
[{"$nulls":16},"Engine Oil Filters",{"$nulls":6},"Generator Oil Filters",{"$nulls":4},"Engine Oil",{"$nulls":12},"Engine Oil Change Parts Summary",{"$nulls":17},"Generator Oil Change Parts Summary"]
[null,"6. ENGINE OIL CHANGE",{"$nulls":4},"QTY","RATE","LABOUR","PARTS",null,null,"JOB SUB-TOTAL",{"$f":"SUM(I58:I66)+SUM(J58:J66)","v":0},null,"Material","Crusader Oil Filter","Merc IB Oil Filter","Merc OB Oil Filter","Volvo Spin-on Filter","Volvo Cart Filter","Yamaha OB Filter <125","Yamaha OB Filter >125","Fischer Panda Filter","Kohler Oil Filter","Onan Oil Filter","Quicksilver Oil Filter","Westerbeke Oil Filter","Crusader Oil","Merc IB Ash Oil - 1L","Merc IB Ash Oil - 4L","Merc IB Synth - 1L","Merc IB Synth - 4L","Merc OB Syn Oil - 1L","Merc OB Syn Oil - 4L","Volvo Ash Oil - 1L","Volvo Ash Oil - 4L","Volvo Synth Oil - 1L","Volvo Synth Oil - 4L","Yamalube - 1L","SAE30 Gen Oil","Crusader Ash Parts","Crusader Synth Parts","Merc IB 4CYL Ash","Merc IB 6CYL Ash","Merc IB 8CYL Ash","Merc IB 4Cyl Synth","Merc IB 6 Cyl Synth","Merc I/B 8 Cyl Synth","Merc OB Parts <125","Merc OB Parts >125","Volvo Gas 4CYL Ash","Volvo Gas 6CYL Ash","Volvo Gas 8CYL Ash","Volvo Gas 4CYL Syn","Volvo Gas 6CYL Syn","Volvo Gas 8CYL Syn","Yamaha Parts <125","Yamaha Parts >125","Fischer Panda Prts","Kohler Parts","Onan Parts","Quicksilver Parts","Westerbeke Parts"]
[null,null,false,"Gas Engine - Standard",null,{"$f":"IF(AND($Q$14=1,$Q$8=2,C58=TRUE,Q10<>4),S9,IF(AND($Q$14=1,$Q$8=4,C58=TRUE,Q10<>4),S11,IF(AND($Q$14=1,$Q$8=5,C58=TRUE,Q10<>4),S12,IF(AND($Q$14=1,$Q$8=6,C58=TRUE,Q10<>4),S13,IF(AND($Q$14=1,$Q$8=8,C58=TRUE,Q10<>4),S15,\"\")))))","v":""},{"$f":"IF(AND($Q$14=1,$Q$8=2,C58=TRUE,Q10<>4),M12,IF(AND($Q$14=1,$Q$8=4,C58=TRUE,Q10<>4),M12,IF(AND($Q$14=1,$Q$8=5,C58=TRUE,Q10<>4),M12,IF(AND($Q$14=1,$Q$8=6,C58=TRUE,Q10<>4),M12,IF(AND($Q$14=1,$Q$8=8,C58=TRUE,Q10<>4),M12,0)))))","v":0},{"v":105,"d":"$105.00"},{"$f":"G58*H58","v":0},{"$f":"IF(AND($Q$14=1,$Q$8=2,C58=TRUE,Q10<>4),AP60,IF(AND($Q$14=1,$Q$8=4,C58=TRUE,Q10<>4,Q16=1),AR60,IF(AND($Q$14=1,$Q$8=4,C58=TRUE,Q10<>4,Q16=2),AS60,IF(AND($Q$14=1,$Q$8=4,C58=TRUE,Q10<>4,Q16=3),AT60,IF(AND($Q$14=1,$Q$8=5,C58=TRUE,Q10<>4,Q16=1),AZ60,IF(AND($Q$14=1,$Q$8=5,C58=TRUE,Q10<>4,Q16=2),BA60,IF(AND($Q$14=1,$Q$8=5,C58=TRUE,Q10<>4,Q16=3),BB60,0)))))))*G58","v":0}]
[null,null,false,"Gas Engine - Synthetic*",null,{"$f":"IF(AND($Q$14=1,$Q$8=2,C59=TRUE,Q10<>4),S9,IF(AND($Q$14=1,$Q$8=4,C59=TRUE,Q10<>4),S11,IF(AND($Q$14=1,$Q$8=5,C59=TRUE,Q10<>4),S12,IF(AND($Q$14=1,$Q$8=6,C59=TRUE,Q10<>4),S13,IF(AND($Q$14=1,$Q$8=8,C59=TRUE,Q10<>4),S15,\"\")))))","v":""},{"$f":"IF(AND($Q$14=1,$Q$8=2,C59=TRUE,Q10<>4),$M$12,IF(AND($Q$14=1,$Q$8=4,C59=TRUE,Q10<>4),$M$12,IF(AND($Q$14=1,$Q$8=5,C59=TRUE,Q10<>4),$M$12,IF(AND($Q$14=1,$Q$8=6,C59=TRUE,Q10<>4),$M$12,IF(AND($Q$14=1,$Q$8=8,C59=TRUE,Q10<>4),$M$12,0)))))","v":0},{"v":105,"d":"$105.00"},0,{"$f":"IF(AND($Q$14=1,$Q$8=2,C59=TRUE,Q10<>4),AQ60,IF(AND($Q$14=1,$Q$8=4,C59=TRUE,Q10<>4,Q16=1),AU60,IF(AND($Q$14=1,$Q$8=4,C59=TRUE,Q10<>4,Q16=2),AV60,IF(AND($Q$14=1,$Q$8=4,C59=TRUE,Q10<>4,Q16=3),AW60,IF(AND($Q$14=1,$Q$8=5,C59=TRUE,Q10<>4,Q16=1),BC60,IF(AND($Q$14=1,$Q$8=5,C59=TRUE,Q10<>4,Q16=2),BD60,IF(AND($Q$14=1,$Q$8=5,C59=TRUE,9<>4,Q16=3),BE60,0)))))))*G59","v":0},{"$nulls":5},"P/N","PH8A","35-866340Q03","35-877769K01",3850559,8692305,"OBM-01LCH-KT-04","OBM-01LCH-KT-05",null,359771,{"$nulls":3},"92-8M0078633","92-8M0078633","92-8M0078634","92-858055kc1","92-858056kc1","92-8M0053662","92-8M0078640",3847302,3847303,4681794,21681795,"YMR-4MIDW-30-LT"]
[null,null,false,"Diesel Engine 4 Cyl",null,{"$f":"IF(AND($Q$14=2,$Q$8=1,C60=TRUE,$Q$16=1),S8,IF(AND($Q$14=2,$Q$8=3,C60=TRUE,$Q$16=1),S10,IF(AND($Q$14=2,$Q$8=5,C60=TRUE,$Q$16=1),S12,IF(AND($Q$14=2,$Q$8=7,C60=TRUE,$Q$16=1),S14,IF(AND($Q$14=2,$Q$8=8,C60=TRUE,$Q$16=1),S15,\"\")))))","v":""},{"$f":"IF(AND($Q$14=2,$Q$8=1,C60=TRUE,$Q$16=1),$M$12,IF(AND($Q$14=2,$Q$8=3,C60=TRUE,$Q$16=1),$M$12,IF(AND($Q$14=2,$Q$8=5,C60=TRUE,$Q$16=1),$M$12,IF(AND($Q$14=2,$Q$8=7,C60=TRUE,$Q$16=1),$M$12,IF(AND($Q$14=2,$Q$8=8,C60=TRUE,$Q$16=1),$M$12,0)))))","v":0},{"v":110,"d":"$110.00"},0,"Quote",{"$nulls":5},"Price",{"v":8.49,"d":"$8.49"},{"v":11.99,"d":"$11.99"},{"v":10.99,"d":"$10.99"},{"v":15.37,"d":"$15.37"},{"v":17.3,"d":"$17.30"},{"v":79.5,"d":"$79.50"},{"v":96.3,"d":"$96.30"},{"v":19.95,"d":"$19.95"},{"v":12.7,"d":"$12.70"},{"v":12.7,"d":"$12.70"},{"v":12.7,"d":"$12.70"},{"v":12.7,"d":"$12.70"},{"v":9.99,"d":"$9.99"},{"v":9.99,"d":"$9.99"},{"v":36.99,"d":"$36.99"},{"v":18.95,"d":"$18.95"},{"v":60.99,"d":"$60.99"},{"v":13.99,"d":"$13.99"},{"v":57.95,"d":"$57.95"},{"v":10.23,"d":"$10.23"},{"v":36.96,"d":"$36.96"},{"v":15.85,"d":"$15.85"},{"v":57.71,"d":"$57.71"},{"v":10.05,"d":"$10.05"},{"v":9.99,"d":"$9.99"},{"$f":"Q60+(AD60*2)+AE60","v":{"v":65.46000000000001,"d":"$65.46"}},{"$f":"Q60+(2*AF60)+AG60","v":{"v":107.38,"d":"$107.38"}},{"$f":"R60+AE60","v":{"v":48.980000000000004,"d":"$48.98"}},{"$f":"R60+AD60+AE60","v":{"v":58.97,"d":"$58.97"}},{"$f":"R60+(AD60*2)+AE60","v":{"v":68.96000000000001,"d":"$68.96"}},{"$f":"R60+AG60","v":{"v":72.98,"d":"$72.98"}},{"$f":"R60+AF60+AG60","v":{"v":91.93,"d":"$91.93"}},{"$f":"R60+(2*AF60)+AG60","v":{"v":110.88,"d":"$110.88"}},{"$f":"S60+(AH60*2)+AI60","v":{"v":96.92,"d":"$96.92"}},{"$f":"S60+(AH60*3)+AI60","v":{"v":110.91,"d":"$110.91"}},{"$f":"T60+AK60","v":{"v":52.33,"d":"$52.33"}},{"$f":"U60+AJ60+AK60","v":{"v":64.49000000000001,"d":"$64.49"}},{"$f":"U60+(AJ60*2)+AK60","v":{"v":74.72,"d":"$74.72"}},{"$f":"U60+AM60","v":{"v":75.01,"d":"$75.01"}},{"$f":"U60+AL60+AM60","v":{"v":90.86,"d":"$90.86"}},{"$f":"U60+(AL60*2)+AM60","v":{"v":106.71000000000001,"d":"$106.71"}},{"$f":"V60+(AN60*7)","v":{"v":149.85000000000002,"d":"$149.85"}},{"$f":"W60+(AN60*8)","v":{"v":176.7,"d":"$176.70"}},{"$f":"X60+(AO60*3)","v":{"v":49.92,"d":"$49.92"}},{"$f":"X60+(AO60*3)","v":{"v":49.92,"d":"$49.92"}},{"$f":"X60+(AO60*3)","v":{"v":49.92,"d":"$49.92"}},{"$f":"X60+(AO60*3)","v":{"v":49.92,"d":"$49.92"}},{"$f":"X60+(AO60*3)","v":{"v":49.92,"d":"$49.92"}}]
[null,null,false,"Diesel Engine 6/8 Cyl",null,{"$f":"IF(AND($Q$14=2,$Q$8=1,C61=TRUE,$Q$16>1),S8,IF(AND($Q$14=2,$Q$8=3,C61=TRUE,$Q$16>1),S10,IF(AND($Q$14=2,$Q$8=5,C61=TRUE,$Q$16>1),S12,IF(AND($Q$14=2,$Q$8=7,C61=TRUE,$Q$16>1),S14,IF(AND($Q$14=2,$Q$8=8,C61=TRUE,$Q$16>1),S15,\"\")))))","v":""},{"$f":"IF(AND($Q$14=2,$Q$8=1,C61=TRUE,$Q$16>1),$M$12,IF(AND($Q$14=2,$Q$8=3,C61=TRUE,$Q$16>1),$M$12,IF(AND($Q$14=2,$Q$8=5,C61=TRUE,$Q$16>1),$M$12,IF(AND($Q$14=2,$Q$8=7,C61=TRUE,$Q$16>1),$M$12,IF(AND($Q$14=2,$Q$8=8,C61=TRUE,$Q$16>1),$M$12,0)))))","v":0},{"v":175,"d":"$175.00"},0,"Quote"]
[null,null,false,"Gas Generator",null,{"$f":"IF(AND($Q$14=1,$Q$12=1,C62=TRUE),V8,IF(AND($Q$14=1,$Q$12=2,C62=TRUE),V9,IF(AND($Q$14=1,$Q$12=3,C62=TRUE),V10,IF(AND($Q$14=1,$Q$12=4,C62=TRUE),V11,IF(AND($Q$14=1,$Q$12=5,C62=TRUE),V12,IF(AND($Q$14=1,$Q$12=6,C62=TRUE),V13,\"\"))))))","v":""},{"$f":"IF(AND($Q$14=1,$Q$12=1,C62=TRUE),1,IF(AND($Q$14=1,$Q$12=2,C62=TRUE),1,IF(AND($Q$14=1,$Q$12=3,C62=TRUE),1,IF(AND($Q$14=1,$Q$12=4,C62=TRUE),1,IF(AND($Q$14=1,$Q$12=5,C62=TRUE),1,IF(AND($Q$14=1,$Q$12=6,C62=TRUE),1,0))))))","v":0},{"v":95,"d":"$95.00"},0,{"$f":"IF(AND($Q$14=1,$Q$12=1,C62=TRUE),(BH60*G62),IF(AND($Q$14=1,$Q$12=2,C62=TRUE),(BI60*G62),IF(AND($Q$14=1,$Q$12=3,C62=TRUE),(BJ60*G62),IF(AND($Q$14=1,$Q$12=4,C62=TRUE),(BK60*G62),IF(AND($Q$14=1,$Q$12=5,C62=TRUE),(BL60*G62),IF(AND($Q$14=1,$Q$12=6,C62=TRUE),\"Quote\",0))))))","v":0}]
[null,null,false,"Diesel Generator",null,{"$f":"IF(AND($Q$14=2,$Q$12=1,C63=TRUE),V8,IF(AND($Q$14=2,$Q$12=2,C63=TRUE),V9,IF(AND($Q$14=2,$Q$12=3,C63=TRUE),V10,IF(AND($Q$14=2,$Q$12=4,C63=TRUE),V11,IF(AND($Q$14=2,$Q$12=5,C63=TRUE),V12,IF(AND($Q$14=2,$Q$12=6,C63=TRUE),V13,\"\"))))))","v":""},{"$f":"IF(AND($Q$14=2,$Q$12=1,C63=TRUE),1,IF(AND($Q$14=2,$Q$12=2,C63=TRUE),1,IF(AND($Q$14=2,$Q$12=3,C63=TRUE),1,IF(AND($Q$14=2,$Q$12=4,C63=TRUE),1,IF(AND($Q$14=2,$Q$12=5,C63=TRUE),1,IF(AND($Q$14=2,$Q$12=6,C63=TRUE),1,0))))))","v":0},{"v":120,"d":"$120.00"},0,"Quote"]
[null,null,false,"Outboard",null,{"$f":"IF(AND($Q$14=1,$Q$8=4,C64=TRUE,$Q$10=4),S11,IF(AND($Q$14=1,$Q$8=6,C64=TRUE,$Q$10=4),S13,IF(AND($Q$14=1,$Q$8=8,C64=TRUE,$Q$10=4),S15,\"\")))","v":""},{"$f":"IF(AND($Q$14=1,$Q$8=4,C64=TRUE,$Q$10=4),$M$12,IF(AND($Q$14=1,$Q$8=6,C64=TRUE,$Q$10=4),$M$12,IF(AND($Q$14=1,$Q$8=8,C64=TRUE,$Q$10=4),$M$12,0)))","v":0},{"v":95,"d":"$95.00"},0,{"$f":"IF(AND($Q$14=1,$Q$8=4,C64=TRUE,$Q$10=4,M9<126),AX60,IF(AND($Q$14=1,$Q$8=4,C64=TRUE,$Q$10=4,M9>125),AY60,IF(AND($Q$14=1,$Q$8=6,C64=TRUE,$Q$10=4,M9<126),AR47,IF(AND($Q$14=1,$Q$8=6,C64=TRUE,$Q$10=4,M9>125),AS47,IF(AND($Q$14=1,$Q$8=8,C64=TRUE,$Q$10=4),\"Quote\",0)))))","v":0}]
[null,null,true,"Shop Supplies",null,null,{"$f":"SUM(G58:G64)","v":0},{"v":2,"d":"$2.00"},0,{"$f":"G65*H65","v":0}]
[null,null,true,"Enviro Disposal Fee",null,null,{"$f":"SUM(G58:G64)","v":0},{"v":5,"d":"$5.00"},0,{"$f":"G66*H66","v":0}]
[{"$nulls":16},"Drive Oil Change Parts",{"$nulls":3},"Drive Service Parts"]
[null,"7. DRIVE / TRANSMISSION SERVICE",{"$nulls":4},"QTY","RATE","LABOUR","PARTS",null,null,"JOB SUB-TOTAL",{"$f":"SUM(I69:I76)+SUM(J69:J76)","v":0},null,null,"Merc Alpha Oil Change","Merc Bravo Oil Change","Volvo SX Oil Change","Volvo DP Oil Change","Merc Alpha Service","Merc Bravo Service","Volvo SX Service","Volvo DP Service"]
[null,null,false,"Sterndrive Oil Change",null,{"$f":"IF(AND(C69=TRUE,$Q$10=5,$Q$8=4),T12,IF(AND(C69=TRUE,$Q$10=6,$Q$8=4),T13,IF(AND(C69=TRUE,$Q$10=7,$Q$8=5),T14,IF(AND(C69=TRUE,$Q$10=8,$Q$8=5),T15,IF(AND(C69=TRUE,$Q$10=9),T16,\"\")))))","v":""},{"$f":"IF(AND(C69=TRUE,$Q$10=5,$Q$8=4),$M$12,IF(AND(C69=TRUE,$Q$10=6,$Q$8=4),$M$12,IF(AND(C69=TRUE,$Q$10=7,$Q$8=5),$M$12,IF(AND(C69=TRUE,$Q$10=8,$Q$8=5),$M$12,IF(AND(C69=TRUE,$Q$10=9),$M$12,0)))))","v":0},{"v":95,"d":"$95.00"},{"$f":"G69*H69","v":0},{"$f":"IF(AND(C69=TRUE,$Q$10=5,$Q$8=4),(Q71*$M$12),IF(AND(C69=TRUE,$Q$10=6,$Q$8=4),(R71*$M$12),IF(AND(C69=TRUE,$Q$10=7,$Q$8=5),(S71*$M$12),IF(AND(C69=TRUE,$Q$10=8,$Q$8=5),(T71*$M$12),IF(AND(C69=TRUE,$Q$10=9),\"Quote\",0)))))","v":0},{"$nulls":5},"Material"]
[null,null,false,"Full Sterndrive Service",null,{"$f":"IF(AND(C70=TRUE,$Q$10=5,$Q$8=4),T12,IF(AND(C70=TRUE,$Q$10=6,$Q$8=4),T13,IF(AND(C70=TRUE,$Q$10=7,$Q$8=5),T14,IF(AND(C70=TRUE,$Q$10=8,$Q$8=5),T15,IF(AND(C70=TRUE,$Q$10=9),T16,\"\")))))","v":""},{"$f":"IF(AND(C70=TRUE,$Q$10=5,$Q$8=4),$M$12,IF(AND(C70=TRUE,$Q$10=6,$Q$8=4),$M$12,IF(AND(C70=TRUE,$Q$10=7,$Q$8=5),$M$12,IF(AND(C70=TRUE,$Q$10=8,$Q$8=5),$M$12,IF(AND(C70=TRUE,$Q$10=9),$M$12,0)))))","v":0},{"v":168,"d":"$168.00"},0,{"$f":"IF(AND(C70=TRUE,$Q$10=5,$Q$8=4),(U71*$M$12),IF(AND(C70=TRUE,$Q$10=6,$Q$8=4),(V71*$M$12),IF(AND(C70=TRUE,$Q$10=7,$Q$8=5),(W71*$M$12),IF(AND(C70=TRUE,$Q$10=8,$Q$8=5),(X71*$M$12),IF(AND(C70=TRUE,$Q$10=9),\"Quote\",0)))))","v":0},{"$nulls":5},"P/N"]
[null,null,false,"Store Sterndrive Inside",null,null,{"$f":"IF(AND(Q10>4,C71=TRUE),$M$12,0)","v":0},{"v":95,"d":"$95.00"},0,0,{"$nulls":5},"Price",{"v":42.62,"d":"$42.62"},{"v":62.52,"d":"$62.52"},{"v":83.37,"d":"$83.37"},{"v":83.12,"d":"$83.12"},{"v":54.53,"d":"$54.53"},{"v":72.79,"d":"$72.79"},{"v":179.84,"d":"$179.84"},{"v":178.86,"d":"$178.86"}]
[null,null,false,"Prop Removal / Storage",null,null,{"$f":"IF(AND(Q10>3,C72=TRUE),$M$12,0)","v":0},{"v":20,"d":"$20.00"},0,0]
[null,null,false,"IPS Service",null,{"$f":"IF(AND(C73=TRUE,$Q$10=2,$Q$8=5),T9,\"\")","v":""},{"$f":"IF(AND(Q10=2,Q8=5,C73=TRUE),$M$12,0)","v":0},{"v":199,"d":"$199.00"},0,"Quote"]
[null,null,false,"Transmission Service",null,{"$f":"IF(AND(C74=TRUE,Q10=1),Q11,\"\")","v":""},{"$f":"IF(AND(Q10=1,C74=TRUE),$M$12,0)","v":0},{"v":105,"d":"$105.00"},0,"Quote"]
[null,null,true,"Shop Supplies",null,null,{"$f":"SUM(G69:G74)","v":0},{"v":2,"d":"$2.00"},0,{"$f":"G75*H75","v":0}]
[null,null,true,"Enviro Disposal Fee",null,null,{"$f":"SUM(G69:G74)","v":0},{"v":5,"d":"$5.00"},0,{"$f":"G76*H76","v":0}]
[{"$nulls":15},"Antifreeze - Qty / Gal","Price / Gal"]
[null,"8. SYSTEMS WINTERIZE",{"$nulls":4},"QTY","RATE","LABOUR","PARTS",null,null,"JOB SUB-TOTAL",{"$f":"SUM(I79:I91)+SUM(J79:J91)","v":0},null,null,{"v":7.69,"d":"$7.69"}]
[null,null,false,"Fresh Water up to 24'",null,null,{"v":1,"d":"1.0"},{"v":45,"d":"$45.00"},{"$f":"IF(AND($I$8>0,$I$8<25,C79=TRUE),G79*H79,0)","v":0},{"$f":"IF(AND(I79>0,C79=TRUE),P79*G79*$Q$78,0)","v":0},{"$nulls":5},0]
[null,null,false,"Fresh Water 25' to 30'",null,null,{"v":1,"d":"1.0"},{"v":105,"d":"$105.00"},{"$f":"IF(AND($I$8>24,$I$8<31,C80=TRUE),G80*H80,0)","v":0},0,{"$nulls":5},0]
[null,null,false,"Fresh Water 31' to 39'",null,null,{"v":1,"d":"1.0"},{"v":125,"d":"$125.00"},{"$f":"IF(AND($I$8>30,$I$8<40,C81=TRUE),G81*H81,0)","v":0},0,{"$nulls":5},0]
[null,null,false,"Fresh Water 40' and up",null,null,{"v":1,"d":"1.0"},{"v":145,"d":"$145.00"},{"$f":"IF(AND($I$8>39,C82=TRUE),G82*H82,0)","v":0},0,{"$nulls":5},0]
[null,null,false,"Icemaker",null,null,{"v":1,"d":"1.0"},{"v":30,"d":"$30.00"},{"$f":"IF(C83=TRUE,G83*H83,0)","v":0},0,{"$nulls":5},0]
[null,null,false,"Dockside Water",null,null,{"v":1,"d":"1.0"},{"v":15,"d":"$15.00"},{"$f":"IF(C84=TRUE,G84*H84,0)","v":0},0,{"$nulls":5},0]
[null,null,false,"Washdown/Livewell",null,null,{"v":1,"d":"1.0"},{"v":35,"d":"$35.00"},0,0,{"$nulls":5},1]
[null,null,false,"Head",null,null,{"v":1,"d":"1.0"},{"v":25,"d":"$25.00"},0,0,{"$nulls":5},1]
[null,null,false,"Pumpout",null,null,{"v":1,"d":"1.0"},{"v":75,"d":"$75.00"},0,0,{"$nulls":5},0]
[null,null,false,"Air Cond - 1st Unit",null,null,{"v":1,"d":"1.0"},{"v":55,"d":"$55.00"},0,0,{"$nulls":5},0]
[null,null,false,"Air Cond - Addt'l Units",null,null,{"v":1,"d":"1.0"},{"v":35,"d":"$35.00"},0,0,{"$nulls":5},0]
[null,null,false,"Dishwasher",null,null,{"v":1,"d":"1.0"},{"v":35,"d":"$35.00"},0,0,{"$nulls":5},1]
[null,null,false,"Washing Machine",null,null,{"v":1,"d":"1.0"},{"v":45,"d":"$45.00"},0,0,{"$nulls":5},1]
[]
[null,"Notes:",{"$nulls":8},"SUB-TOTAL",null,null,{"$f":"N17+N26+N30+N36+N44+N57+N68+N78","v":0}]
[{"$nulls":10},"OTHER",null,null,0]
[{"$nulls":10},"TOTAL",null,null,{"$f":"N93+N94","v":0}]
[{"$nulls":10},"13% HST - R833926280",null,null,{"$f":"N95*0.13","v":0}]
[{"$nulls":10},"TOTAL W/TAX",null,null,{"$f":"SUM(N95:N96)","v":0}]
[]
[]
[]
[{"$nulls":7},"X:"]
[null,"Name of Person Authorizing Work",{"$nulls":5},"Authorized Signature",{"$nulls":4},"Date"]
[]
[{"$nulls":7},"X:"]
[null,"Name of Authorized Marina Agent",{"$nulls":5},"Authorized Signature",{"$nulls":4},"Date"]
[]
[null,"As the Boat owner or his/her authorized agent, I hereby authorize the work set forth herein and agree to the additional terms and conditions set forth on Page (3) hereof under \"Frequently Asked Questions\" and on Page (4) hereof under \"Winter Service & Storage Agreement\". I acknowledge and agree that I must provide the Marina with a valid Credit Card Authorization form prior to commencement of any work. I agree to pay the Marina in full immediately upon completion of the work described herein. I acknowledge and agree that a service charge of 2% per month (24% per annum) will be charged on all unpaid accounts."]
[]
[]
[null,"FREQUENTLY ASKED QUESTIONS"]
[]
[null,"1. L.O.A. Means length overall of your boat including swim platform and bow pulpit."]
[null,"2. KEYS You must leave ignition and cabin door keys, as applicable, with the marina at time of delivery.  A minimum $100 surcharge will be added to your invoice if we must handle or winterize your boat without keys."]
[null,"3. FUEL We recommend that you store your boat with minimal fuel in the tanks; however we must have sufficient fuel to run the boat for approx 30 minutes.  If we must add fuel to winterize your boat properly you will be charged the cost of the fuel plus the additional labour required to tow and/or fill your boat with sufficient fuel."]
[null,"4. SHRINKWRAP Due to insurance regulations customers are not permitted to tarp or shrink wrap their boat on marina property.  Shrink wrap removal and recycling in the spring is additional and will be billed upon completion."]
[null,"5. PREPARING YOUR BOAT FOR WINTERIZING To ensure your boat is winterized properly, we ask that you take certain steps before delivering it to us for service and/or storage: a) ensure cockpit carpets are clean, dry, rolled-up and stowed in the cabin or taken home; b) remove all personal items, including safety gear, particularly those that may be obstructing engine room/bilge access; c) empty all refrigerators, freezers, icemakers, defrost and leave doors open; d) remove from your boat all perishables, cleaning products or other liquids that could freeze and cause damage to your boat; e) stow or remove from the boat any excess mooring equipment other than the minimum required to tie the boat up during service.   Ensuring your boat is neat, tidy and dry at time of winterizing saves time and avoids additional labour charges for the owner.  Any equipment left onboard your boat for the winter is your responsibility - Crate's Lake Country Boats assumes no responsibility for items stored in customer boats."]
[null,"6. ENGINE WINTERIZING Basic engine winterization includes, as applicable: a) adding fuel stabilizer/conditioner to the fuel tank(s); b) removing plugs and draining water from block / manifolds / exhaust / coolers, mufflers etc; c) reinstalling plugs, filling engine with antifreeze and fogging with storage seal mixture. Gas engine winterization includes replacement of the fuel filter.  Diesel engine fuel filter service/replacement is additional and will be quoted upon request.  4-stroke outboard winterization also includes labour and material to change lower unit oil."]
[null,"7. BATTERY SERVICE  According to battery manufacturer recommendations, batteries are topped-up with electrolyte (as applicable), charged, load tested, disconnected and left onboard for winter.  Only if a battery fails a load test will it be removed from the boat to avoid freezing - additional charges will apply."]
[null,"8. BOTTOM WASHING  If your hull bottom is coated with anti-fouling paint it should only require steam washing.  If your hull bottom is unpainted gelcoat it will probably require a chemical application in addition to steam washing.  Please only select one or the other. "]
[null,"9. OIL CHANGES  The marina follows manufacturer's recommendations for winterizing procedures, including oil changes.  Subject to availability we only use OEM parts and lubricants.  If you are unsure whether ash-based oil or synthetic oil is recommended for your engine, please speak to our service staff for guidance.  Oil change parts are estimated for specific make/model gas engines only as listed.  All others, including diesel engines, will be quote individually by specific engine make/model."]
[null,"10. FRESH WATER SYSTEMS Winterizing of fresh water systems includes water tank, pump, hot water tank, taps, showers and sumps. Components such as icemakers, washing machines, bait wells, washdown pumps, air conditioners etc. are additional as quoted herein."]
[null,"11. PARTS ESTIMATES Parts quantities and prices quoted herein are estimates only and are provided as a guideline when estimating the cost to winterize your boat.  All parts will be billed according to actual quantities used."]
[null,"12. MANDATORY STERNDRIVE LOCKS All sterndrive powered boats stored with the Marina must be equipped with a sterndrive lock(s) unless the Owner chooses indoor drive storage; in which case a lock is not required.  If your drive does not have a lock installed, we will install one for your and the cost of the lock will be added to your invoice."]
[null,"13. ADDITIONAL SERVICE WORK Our service team is happy to assist you with any additional service or repair work that may be required for your boat.  In order that we may work on your boat over the winter it will need to be stored it in a location that allows us ready access.  If you are contemplating winter service work, please advise us of this in the fall when your boat is delivered to us for winterizing.  Additional work can be requested in the Notes section of the Winterizing Worksheet or by selecting various options on our Winter Services Menu.  Booking your service work in the fall ensures you receive the most competitive off-season pricing and allows us to do the work without interfering with your boating season."]
[null,"14. STORAGE PERIOD The Land Storage pricing provided herein includes storage through May 31, 2018 only.  If your boat and/or trailer is left with us beyond this date you will be charged monthly summer storage at the Marina's 2018 rates."]
[null,"15. TRAILERS If your boat is brought to us and stored on a trailer, blocking charges will not apply, however additional handling charges will be assessed if we are required to unload/load your boat from/to the trailer to steamclean the bottom.  Handling charges will be quoted separately.  Please note winterizing services do not include trailer service or maintenance.  It is the Owner's responsibility to ensure the trailer is in serviceable condition including tires, brakes, bearings, coupler and lights, prior to pickup.  The Owner is also responsible to ensure that the Boat is securely strapped-down on the trailer with hull plug installed and all loose items, including canvas, securely stowed for transportation."]
[null,"16. TAXES  All applicable taxes are extra and will be added to your final winterizing Repair Order."]
[null,"17. DISCLAIMER The Marina assumes no responsibility whatsoever for damage to equipment not winterized by the Marina.  It is the boat owners responsibility to completely and accurately inform the Marina of all winterizing that may be required and to deliver the Boat to the Marina for service well in advance freeze-up.  The Marina assumes no responsibility for pre-existing damage."]
[null,"WINTER SERVICE & STORAGE AGREEMENT"]
[null,"Name",null,null,{"$f":"E3","v":0},{"$nulls":4},"Email",{"$f":"K3","v":0}]
[null,"Address",null,null,{"$f":"E4","v":0},{"$nulls":4},"Postal Code",{"$f":"K4","v":0}]
[null,"Home Ph",null,null,{"$f":"E5","v":0},null,"Work Ph",{"$f":"H5","v":0},null,"Cell Phone",{"$f":"K5","v":0}]
[null,"Boat Year",null,null,{"$f":"E8","v":0},null,"Make ",{"$f":"E9","v":0},null,"Model",{"$f":"E10","v":0}]
[null,"Hull #",null,null,{"$f":"E11","v":0},null,"Lic #",{"$f":"E12","v":0},null,"Boat Name",{"$f":"E13","v":0}]
[]
[null,"Where the Owner has contracted Crate's Lake Country Boats Inc. (hereinafter the \"Marina\") to provide winterization and/or storage services, as may be applicable, on his/her Boat, Motor, Trailer (hereinafter the \"Equipment\"), such services shall be detailed in the Winterizing Worksheet attached hereto as Schedule \"A\".  No Winterizing Worksheet is valid unless accompanied by this Agreement.  The Marina assumes no responsibility to prepare the Equipment for winter except as explicity authorized and directed by the Owner under this Agreement.  IF THE OWNER DOES NOT REQUIRE ANY WINTERIZATION SERVICES, HE/SHE MUST INITIAL HERE (___________).  By initialling here the Owner hereby releases the Marina from any obligation to winterize, service, clean, maintain or otherwise care for the Equipment and he/she agrees to indemnify and save harmless the Marina for any damage caused by lack of service or maintenance including, but not limited to, improper or inadequate winterization. This Agreement shall remain in full force and effect at all times while the Equipment is on the property of the Marina."]
[]
[null,"The Owner hereby agrees to service and/or store the Equipment with the Marina under the following Terms and Conditions:"]
[null,"1. PAYMENT TERMS  All accounts are payable in full immediately upon completion by the Marina of the winterizing services described herein.  The Marina shall charge, and the Owner shall pay interest at a rate of 24% per annum or 2% per month on any unpaid balance."]
[null,"2. WAIVER OF LIABILITY\n(a) The Owner acknowledges that the Marina does not assume any duty to care for the Equipment or to prevent loss or damage thereto while the same is under the control and direction of the Marina, or is on the Marina’s premises; and\n(b) Except for the gross negligence or fraud of the Marina, the Owner hereby releases the Marina from liability for any damage, expense, or loss to the Equipment however caused, by the Marina, its employees, agents or representatives, or otherwise, while the Equipment is under the control and direction of the Marina, or are on the Marina’s premises. The Owner hereby releases and discharges the Marina, its employees, agents or representatives from all actions, causes of action, claims and demands in any way related to this Agreement; and\n(c) The Owner hereby agrees to reimburse or indemnify the Marina for any damages caused to any property of the Marina, and for any sums required to be paid to anyone by the Marina, its agents, or representatives as the result of the use of or presence on the Marina premises of the Owner and/or the Equipment."]
[null,"3. INSURANCE  The Owner hereby agrees to maintain adequate insurance coverage on the Equipment while the Equipment is under the control and direction of the Marina, or on the Marina's premises."]
[null,"4. CLAIM FOR LIEN  The Owner acknowledges that the Marina shall have a lien against the Equipment for all unpaid sums due to the Marina under this Agreement.  The Marina shall be entitled to liens pursuant to the Repair and Storage Liens Act, R.S.O. 1990, c. R-25, as amended, and any successor statute. The Marina shall be entitled to retain possession of the Equipment until payment is received by the Marina of all sums owing by the Owner or until the Equipment is disposed of in accordance with the Repair and Storage Liens Act."]
[null,"5. LICENCE AGREEMENT ONLY The Owner expressly acknowledges that this Agreement shall create a licence agreement between the Marina and the Owner wherein the Owner is licenced to use the storage space and area, from time to time designated by the Marina for the storage of the Owner’s Equipment."]
[null,"6. LOCATION FOR STORAGE This Agreement shall not grant to the Owner any right, title, claim or interest in or to any specific storage space or area.  The Marina may determine, at its sole discretion, where the Equipment is to be stored.  The Marina, at its sole discretion and without notice to the Owner, may relocate the Equipment from time to time as it may deem necessary."]
[null,"7. NO DUTY TO INSPECT OR MAINTAIN\n(a) The Marina shall have no obligation to inspect or provide maintenance or repair for the Equipment except as authorized and directed by the Owner pursuant to this Agreement; and\n(b) The Marina shall have no obligation to maintain or repair the covering or shrink wrapping that has been applied to the Equipment by the Marina; and\n(c) The Marina shall have no obligation to notify the Owner of the necessity for any maintenance or repairs of the Equipment during the duration of this Agreement."]
[null,"8. SNOW REMOVAL Except where the the Owner has authorized and instructed the Marina to shrink wrap the Equipment pursuant to this Agreement, the Marina shall have no obligation to remove snow or ice from the Equipment, nor to notify the Owner of the necessity for any such snow or ice removal.  The Marina shall not be responsible for any loss, damage, cost or expense relating to the removal or non-removal of snow or ice from the Equipment."]
[null,"9. AUTHORITY OF CORPORATION TO EXECUTE AGREEMENT  If the Owner is a corporation:\n(a) The person signing this Agreement hereby acknowledges that he or she has the authority to bind the corporation; and\n(b) The Owner has all necessary corporate power, authority and capacity to enter into this Agreement and to perform its obligations under this Agreement; and\n(c) The execution and delivery of this Agreement and the consummation of the transaction contemplated under it have been duly authorized by all necessary corporate actions on the part of the Owner."]
[null,"10. ENTIRE AGREEMENT  This Agreement shall constitute the entire agreement between the parties and there is no representation, warranty, condition or collateral agreement affecting this Agreement other than as expressed herein.  This Agreement may be amended only in writing upon written consent of the Marina and Owner."]
[null,"11. SUCCESSORS  This Agreement shall be binding on each of the parties hereto, their respective heirs, executors, administrators, personal representatives, successors and assigns."]
[null,"12. SEVERABILITY  The Owner agrees that all provisions to this Agreement are severable.  If any provision is held to be invalid, it shall not affect the other provisions, which shall be given full force and effect."]
[null,"13. JURISDICTION  This Agreement shall be read with all changes of gender and number required by the context.  This Agreement and the affairs of the parties shall be governed by the laws of the Province of Ontario and the venue for any legal dispute shall be the jurisdiction in which Marina is located."]
[null,"WARNING TO BOAT OWNERS"]
[null,"YOU SHOULD NOTIFY YOUR INSURANCE COMPANY YOU HAVE SIGNED THIS AGREEMENT AS IT MAY INVALIDATE YOUR INSURANCE UNLESS YOU HAVE THE CONSENT OF THE INSURANCE COMPANY IN WRITING."]
[null,"I have read & clearly understand this Agreement & confirm that I have the authority to sign the Agreement.  I acknowledge this date having received a copy of the Agreement."]
[null,"Dated at ",{"$nulls":5},"this",null,"day  of",{"$nulls":3},", 20"]
[]
[null,"SIGNED, SEALED AND DELIVERED"]
[null,"in the presence of:"]
[]
[null,"(Witness)",{"$nulls":6},"(Owner(s))"]
[]
[null,"(Witness)",{"$nulls":6},"(Marina)"]
[null,"This Agreement is not valid unless signed and accepted by an authorized Officer of the Marina"]