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

{"sheet":"2016 Runabout Worksheet","index":0,"n_rows":157,"n_cols":49,"rows_kept":157,"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,8,10,9],[10,12,10,13],[11,4,11,5],[11,12,11,13],[12,4,12,5],[12,6,12,7],[12,10,12,13],[14,1,14,13],[16,1,16,13],[17,1,17,13],[28,3,28,4],[30,1,30,13],[31,1,31,13],[33,10,33,13],[34,10,34,13],[35,1,35,13],[37,10,37,13],[38,10,38,13],[39,10,39,13],[40,10,40,13],[41,10,41,13],[42,10,42,13],[43,1,43,13],[44,16,44,21],[44,22,44,32],[44,33,44,48],[45,10,45,13],[45,16,46,16],[45,17,46,17],[45,18,46,18],[45,19,46,19],[45,20,46,20],[45,21,46,21],[45,22,46,22],[45,23,46,23],[45,24,46,24],[45,25,46,25],[45,26,46,26],[45,27,46,27],[45,28,46,28],[45,29,46,29],[45,30,46,30],[45,31,46,31],[45,32,46,32],[45,33,46,33],[45,34,46,34],[45,35,46,35],[45,36,46,36],[45,37,46,37],[45,38,46,38],[45,39,46,39],[45,40,46,40],[45,41,46,41],[45,42,46,42],[45,43,46,43],[45,44,46,44],[45,45,46,45],[45,46,46,46],[45,47,46,47],[45,48,46,48],[46,10,46,13],[47,10,47,13],[48,10,48,13],[49,10,49,13],[50,1,50,13],[52,16,52,21],[52,22,52,25],[53,10,53,13],[53,16,54,16],[53,17,54,17],[53,18,54,18],[53,19,54,19],[53,20,54,20],[53,21,54,21],[53,22,54,22],[53,23,54,23],[53,24,54,24],[53,25,54,25],[54,10,54,13],[55,10,55,13],[56,10,56,13],[57,10,57,13],[58,10,58,13],[59,10,59,13],[60,10,60,13],[61,1,61,13],[63,10,63,13],[64,10,64,13],[65,10,65,13],[66,10,66,13],[67,10,67,13],[68,10,68,13],[69,10,69,13],[71,10,71,13],[72,10,72,13],[73,10,73,13],[74,10,74,13],[75,10,75,13],[76,10,76,13],[78,1,78,3],[79,1,79,9],[80,1,80,9],[81,1,81,9],[82,1,82,9],[83,1,83,9],[84,1,84,9],[85,1,85,13],[86,1,86,9],[86,10,86,12],[87,1,87,9],[87,10,87,12],[88,1,88,9],[88,10,88,12],[89,1,89,9],[89,10,89,12],[90,1,90,9],[90,10,90,12],[93,1,93,5],[93,7,93,10],[93,12,93,13],[94,1,94,5],[94,7,94,10],[94,12,94,13],[96,1,96,5],[96,7,96,10],[96,12,96,13],[97,1,97,5],[97,7,97,10],[97,12,97,13],[99,1,100,13],[102,1,102,13],[104,1,104,13],[105,1,105,13],[106,1,106,13],[107,1,107,13],[108,1,108,13],[109,1,109,13],[110,1,110,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,4,123,8],[123,10,123,13],[124,4,124,8],[124,10,124,13],[125,4,125,5],[125,7,125,8],[125,10,125,13],[126,4,126,5],[126,7,126,8],[126,10,126,13],[127,4,127,5],[127,7,127,8],[127,10,127,13],[128,1,128,13],[129,1,130,13],[131,1,131,13],[132,1,132,13],[133,1,133,13],[134,1,134,13],[135,1,135,13],[136,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,3],[148,4,148,6],[148,10,148,12],[153,4,153,7],[153,9,153,13],[155,4,155,7],[155,9,155,13],[156,1,156,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"]
[null,"Year",{"$nulls":4},"Length Overall ",null,null,"(Ft)","Engine Make",null,{"$f":"Q10","v":0},null,null,"Dropdown Controls",null,null,"Engine","Drive","Delivery","P/U Zone","Cyl","Platinum Package",null,"$/Ft"]
[null,"Make",{"$nulls":4},"Beam",null,null,"(Ft)","Engine Model",{"$nulls":4},"Engine",5,1,"Mercury","Inboard","Marina Pick-up","Zone 1: 01-20KM",4,19,655,{"$f":"Y9/X9","v":34.473684210526315}]
[null,"Model",{"$nulls":4},"Pick-up or Drop-Off",null,{"$f":"Q18","v":"Customer Drop-off"},null,"Engine HP",{"$nulls":5},{"$f":"IF($Q$9=1,S9,IF($Q$9=2,S10,IF($Q$9=3,S11,IF($Q$9=4,S12,IF($Q$9=5,S13,IF($Q$9=6,S14,IF($Q$9=7,S15,IF($Q$9=8,S16,\"\"))))))))","v":0},2,"Volvo","Jet","Customer Drop-off","Zone 2: 21-40KM",6,20,725,{"$f":"Y10/X10","v":36.25}]
[null,"Hull Number",{"$nulls":4},"Pick-up Zone",null,{"$f":"Q15","v":""},null,"Drive Type",null,{"$f":"Q12","v":""},null,null,"Drive",9,3,"Yamaha","Outboard",null,"Zone 3: 41-60KM",8,21,740,35.23809523809524]
[null,"Lic Number",{"$nulls":4},"Fall Date Request",null,null,"(dd/mm/yyyy)","# of Cylinders",{"$nulls":5},{"$f":"IF($Q$11=1,T9,IF($Q$11=2,T10,IF($Q$11=3,T11,IF($Q$11=4,T12,IF($Q$11=5,T13,IF($Q$11=6,T14,IF($Q$11=7,T15,IF($Q$11=8,T16,\"\"))))))))","v":""},4,"Other","Merc Alpha",null,"Zone 4: 61-80KM","Other",22,760,34.54545454545455]
[null,"Key Location",{"$nulls":4},"Spring Date Request",null,null,"(dd/mm/yyyy)",{"$nulls":5},"Zone",8,5,null,"Merc Bravo",null,"Zone 5: 81-100KM",null,23,795,34.56521739130435]
[{"$nulls":17},6,null,"Volvo SX",null,"Zone 6: 101KM or More",null,24,865,{"$f":"Y14/X14","v":36.041666666666664}]
[null,"IMPORTANT: Spring delivery / pickup dates must be specified in the fall when you book your winterizing.  If you do not specify a date the Marina will assign a date for you. Spring dates are available on a first-come basis.  Boats not picked-up on the specified date will be charged a $150 handling fee and delivery will be reschuled for the next available date as determined by the Marina.",{"$nulls":14},{"$f":"IF($Q$13=1,V9,IF($Q$13=2,V10,IF($Q$13=3,V11,IF($Q$13=4,V12,IF($Q$13=5,V13,IF($Q$13=6,V14,IF($Q$13=7,V15,\"\")))))))","v":""},7,null,"Volvo DP",null,"n/a",null,25,900,{"$f":"Y15/X15","v":36}]
[{"$nulls":17},8,null,"Other I/O",{"$nulls":3},26,935,{"$f":"Y16/X16","v":35.96153846153846}]
[null,"SERVICE ESTIMATES",{"$nulls":13},"Delivery",2,9,{"$nulls":5},27,965,{"$f":"Y17/X17","v":35.74074074074074}]
[{"$nulls":16},{"$f":"IF($Q$17=1,U9,IF($Q$17=2,U10,\"\"))","v":"Customer Drop-off"}]
[null,"1. RUNABOUT STORAGE (LOA)",{"$nulls":4},"QTY","RATE","PRICE",{"$nulls":3},"JOB SUB-TOTAL",{"$f":"SUM(I20:I29)","v":0},null,"Cyl",3]
[null,null,false,"Basic Pkg through May 31",null,"Up to 19'",{"$f":"IF(AND($I$8>0,$I$8<20),1,0)","v":0},{"v":945,"d":"$945.00"},{"$f":"G20*H20","v":0},{"$nulls":7},{"$f":"IF($Q$19=1,W9,IF($Q$19=2,W10,IF($Q$19=3,W11,IF($Q$19=2,W12,\"\"))))","v":8}]
[null,null,false,"Basic Pkg through May 31",null,"20'",{"$f":"IF(AND($I$8>19,$I$8<21),1,0)","v":0},{"v":1055,"d":"$1,055.00"},0]
[null,null,false,"Basic Pkg through May 31",null,"21'",{"$f":"IF(AND($I$8>20,$I$8<22),1,0)","v":0},{"v":1125,"d":"$1,125.00"},0]
[null,null,false,"Basic Pkg through May 31",null,"22'",{"$f":"IF(AND($I$8>21,$I$8<23),1,0)","v":0},{"v":1195,"d":"$1,195.00"},0]
[null,null,false,"Basic Pkg through May 31",null,"23'",{"$f":"IF(AND($I$8>22,$I$8<24),1,0)","v":0},{"v":1325,"d":"$1,325.00"},0]
[null,null,false,"Basic Pkg through May 31",null,"24'",{"$f":"IF(AND($I$8>23,$I$8<25),1,0)","v":0},{"v":1455,"d":"$1,455.00"},0]
[null,null,false,"Basic Pkg through May 31",null,"25'",{"$f":"IF(AND($I$8>24,$I$8<26),1,0)","v":0},{"v":1535,"d":"$1,535.00"},0]
[null,null,false,"Basic Pkg through May 31",null,"26'",{"$f":"IF(AND($I$8>25,$I$8<27),1,0)","v":0},{"v":1645,"d":"$1,645.00"},0]
[null,null,false,"Basic Pkg through May 31",null,"27'",{"$f":"IF(AND($I$8>26,$I$8<28),1,0)","v":0},{"v":1735,"d":"$1,735.00"},0]
[null,null,false,"Upgrade to Platinum Pkg",null,{"$f":"IF(AND(C29=TRUE),$I$8,\"-\")","v":"-"},{"$f":"IF(AND(C29=TRUE),1,0)","v":0},"$      35 / Ft",{"$f":"IF(AND(C29=TRUE),(F29*G29*35),0)","v":0}]
[]
[null,"Platinum Package upgrade includes: compound, buff & wax hull and deck, deluxe interior detailing and steamclean carpet.  If wet sanding is required, additional charges will apply and will be quoted prior to work commencing.  Platinum Package special pricing is available only when booked at time of winterization."]
[]
[null,"2. BOTTOM WASHING (Per Ft LOA)",{"$nulls":4},"QTY","RATE","PRICE",{"$nulls":3},"JOB SUB-TOTAL",{"$f":"SUM(I34:I35)","v":0}]
[null,null,false,"Painted Bottom - Steam Only",null,null,{"$f":"IF(AND($I$8>0, $I$8<61,C34=TRUE),$I$8,0)","v":0},{"v":5.75,"d":"$5.75"},{"$f":"G34*H34","v":0}]
[null,null,false,"Gelcoat Bottom - Chemical",null,null,{"$f":"IF(AND($I$8>0, $I$8<61,C35=TRUE),$I$8,0)","v":0},{"v":10,"d":"$10.00"},{"$f":"G35*H35","v":0}]
[]
[null,"3. PICK-UP BY TRUCK (Max 24')",{"$nulls":4},"QTY","RATE","PRICE",{"$nulls":3},"JOB SUB-TOTAL",{"$f":"SUM(I38:I43)","v":0}]
[null,null,false,"Pick-Up Zone 1",null,"01-20KM",{"$f":"IF(AND($I$8<25,$Q$17=1,$Q$13=1),1,0)","v":0},"No Charge",{"$f":"IF(G38=1,\"No Charge\",0)","v":0}]
[null,null,false,"Pick-Up Zone 2",null,"21-40KM",{"$f":"IF(AND($I$8<25,$Q$17=1,$Q$13=2),1,0)","v":0},{"v":100,"d":"$100.00"},{"$f":"G39*H39","v":0}]
[null,null,false,"Pick-Up Zone 3",null,"41-60KM",{"$f":"IF(AND($I$8<25,$Q$17=1,$Q$13=3),1,0)","v":0},{"v":150,"d":"$150.00"},{"$f":"G40*H40","v":0}]
[null,null,false,"Pick-Up Zone 4",null,"61-80KM",{"$f":"IF(AND($I$8<25,$Q$17=1,$Q$13=4),1,0)","v":0},{"v":200,"d":"$200.00"},{"$f":"G41*H41","v":0}]
[null,null,false,"Pick-Up Zone 5",null,"81-100KM",{"$f":"IF(AND($I$8<25,$Q$17=1,$Q$13=5),1,0)","v":0},{"v":250,"d":"$250.00"},{"$f":"G42*H42","v":0}]
[null,null,false,"Pick-Up Zone 6",null,"101KM +",{"$f":"IF(AND($I$8<25,$Q$17=1,$Q$13=6),1,0)","v":0},"Quote",{"$f":"IF(G43=1,\"Quote\",0)","v":0}]
[]
[null,"4. ENGINE OIL CHANGE",{"$nulls":4},"QTY","RATE","LABOUR","PARTS",null,null,"JOB SUB-TOTAL",{"$f":"SUM(I46:I50)+SUM(J46:J50)","v":0},null,null,"Engine Oil Filters",{"$nulls":5},"Engine Oil",{"$nulls":10},"Engine Oil Change Parts Summary"]
[null,null,false,"Gas Engine - Standard",null,{"$f":"IF(AND(C46=TRUE,$Q$11<>3,$Q$9=1),$Q$10,IF(AND(C46=TRUE,$Q$11<>3,$Q$9=2),$Q$10,IF(AND(C46=TRUE,$Q$11<>3,$Q$9=4),$Q$10,\"\")))","v":""},{"$f":"IF(AND(C46=TRUE,$Q$11<>3,$Q$9=1),1,IF(AND(C46=TRUE,$Q$11<>3,$Q$9=2),1,IF(AND(C46=TRUE,$Q$11<>3,$Q$9=4),1,0)))","v":0},{"v":105,"d":"$105.00"},{"$f":"G46*H46","v":0},{"$f":"IF(AND(G46>0,$Q$11<>3,$Q$9=1,$Q$19=1),AH49,IF(AND(G46>0,$Q$11<>3,$Q$9=1,$Q$19=2),AI49,IF(AND(G46>0,$Q$11<>3,$Q$9=1,$Q$19=3),AJ49,IF(AND(G46>0,$Q$11<>3,$Q$9=2,$Q$19=1),AP49,IF(AND(G46>0,$Q$11<>3,$Q$9=2,$Q$19=2),AQ49,IF(AND(G46>0,$Q$11<>3,$Q$9=2,$Q$19=3),AR49,IF(AND(G46>0,$Q$11<>3,$Q$9=4),\"Quote\",0)))))))","v":0},{"$nulls":6},"Merc IB Oil Filter","Merc OB Oil Filter","Volvo Spin-on Filter","Volvo Cart Filter","Yam OB Filter <125","Yam OB Filter >125","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","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"]
[null,null,false,"Gas Engine - Synthetic*",null,{"$f":"IF(AND(C47=TRUE,$Q$11<>3,$Q$9=1),$Q$10,IF(AND(C47=TRUE,$Q$11<>3,$Q$9=2),$Q$10,IF(AND(C47=TRUE,$Q$11<>3,$Q$9=4),$Q$10,\"\")))","v":""},{"$f":"IF(AND(C47=TRUE,$Q$11<>3,$Q$9=1),1,IF(AND(C47=TRUE,$Q$11<>3,$Q$9=2),1,IF(AND(C47=TRUE,$Q$11<>3,$Q$9=4),1,0)))","v":0},{"v":105,"d":"$105.00"},{"$f":"G47*H47","v":0},{"$f":"IF(AND(G47>0,$Q$11<>3,$Q$9=1,$Q$19=1),AK49,IF(AND(G47>0,$Q$11<>3,$Q$9=1,$Q$19=2),AL49,IF(AND(G47>0,$Q$11<>3,$Q$9=1,$Q$19=3),AM49,IF(AND(G47>0,$Q$11<>3,$Q$9=2,$Q$19=1),AS49,IF(AND(G47>0,$Q$11<>3,$Q$9=2,$Q$19=2),AT49,IF(AND(G47>0,$Q$11<>3,$Q$9=2,$Q$19=3),AU49,IF(AND(G47>0,$Q$11<>3,$Q$9=4),\"Quote\",0)))))))","v":0},{"$nulls":5},"Material"]
[null,null,false,"Outboard",null,{"$f":"IF(AND(C48=TRUE,$Q$11=3,$Q$9=1),$Q$10,IF(AND(C48=TRUE,$Q$11=3,$Q$9=3),$Q$10,IF(AND(C48=TRUE,$Q$11=3,$Q$9=4),$Q$10,\"\")))","v":""},{"$f":"IF(AND(C48=TRUE,$Q$11=3,$Q$9=1),1,IF(AND(C48=TRUE,$Q$11=3,$Q$9=3),1,IF(AND(C48=TRUE,$Q$11=3,$Q$9=4),1,0)))","v":0},{"v":95,"d":"$95.00"},{"$f":"G48*H48","v":0},{"$f":"IF(AND(G48>0,$Q$11=3,$Q$9=1,M10<126),AN49,IF(AND(G48>0,$Q$11=3,$Q$9=1,M10>125),AO49,IF(AND(G48>0,$Q$11=3,$Q$9=3,M10<126),AV49,IF(AND(G48>0,$Q$11=3,$Q$9=3,M10>125),AW49,IF(AND(G48>0,$Q$11=3,$Q$9=4),\"Quote\",0)))))","v":0},{"$nulls":5},"P/N","35-866340Q03","35-877769K01",3850559,8692305,null,null,"92-8M0078633","92-8M0078634","92-858055kc1","92-858056kc1","92-8M0053662","92-8M0078640",3847302,3847303,4681794,21681795,"YMR-4MIDW-30-LT"]
[null,null,true,"Shop Supplies",null,null,{"$f":"SUM(G46:G48)","v":0},{"v":2,"d":"$2.00"},0,{"$f":"G49*H49","v":0},{"$nulls":5},"Price",{"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":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"},{"$f":"Q49+X49","v":{"v":48.980000000000004,"d":"$48.98"}},{"$f":"Q49+W49+X49","v":{"v":58.97,"d":"$58.97"}},{"$f":"Q49+(W49*2)+X49","v":{"v":68.96000000000001,"d":"$68.96"}},{"$f":"Q49+Z49","v":{"v":72.98,"d":"$72.98"}},{"$f":"Q49+Y49+Z49","v":{"v":91.93,"d":"$91.93"}},{"$f":"Q49+(2*Y49)+Z49","v":{"v":110.88,"d":"$110.88"}},{"$f":"R49+(AA49*2)+AB49","v":{"v":96.92,"d":"$96.92"}},{"$f":"R49+(AA49*3)+AB49","v":{"v":110.91,"d":"$110.91"}},{"$f":"T49+AD49","v":{"v":54.260000000000005,"d":"$54.26"}},{"$f":"T49+AC49+AD49","v":{"v":64.49000000000001,"d":"$64.49"}},{"$f":"T49+(AC49*2)+AD49","v":{"v":74.72,"d":"$74.72"}},{"$f":"T49+AF49","v":{"v":75.01,"d":"$75.01"}},{"$f":"T49+AE49+AF49","v":{"v":90.86,"d":"$90.86"}},{"$f":"T49+(AE49*2)+AF49","v":{"v":106.71000000000001,"d":"$106.71"}},{"$f":"U49+(AG49*7)","v":{"v":149.85000000000002,"d":"$149.85"}},{"$f":"V49+(AG49*8)","v":{"v":176.7,"d":"$176.70"}}]
[null,null,true,"Enviro Disposal Fee",null,null,{"$f":"SUM(G46:G48)","v":0},{"v":5,"d":"$5.00"},0,{"$f":"G50*H50","v":0}]
[]
[]
[null,"5. LOWER UNIT SERVICE",{"$nulls":4},"QTY","RATE","LABOUR","PARTS",null,null,"JOB SUB-TOTAL",{"$f":"SUM(I54:I61)+SUM(J54:J61)","v":0},null,null,"Lower Unit Oil Change Parts",{"$nulls":5},"Drive Service Parts"]
[null,null,false,"Sterndrive Gear Oil Change",null,{"$f":"IF(AND(C54=TRUE,$Q$11>3),$Q$12,\"\")","v":""},{"$f":"IF(AND(C54=TRUE,$Q$11>3),1,0)","v":0},{"v":87.5,"d":"$87.50"},{"$f":"G54*H54","v":0},{"$f":"IF(AND(G54>0,$Q$11=4),Q57,IF(AND(G54>0,$Q$11=5),R57,IF(AND(G54>0,$Q$11=6),T57,IF(AND(G54>0,$Q$11=7),U57,IF(AND(G54>0,$Q$11=8),\"Quote\",0)))))","v":0},{"$nulls":6},"Merc Alpha Oil Change","Merc Bravo Oil Change","Merc OB Oil Change","Volvo SX Oil Change","Volvo DP Oil Change","Yam OB Oil Change","Merc Alpha Service","Merc Bravo Service","Volvo SX Service","Volvo DP Service"]
[null,null,false,"Full Sterndrive Service",null,{"$f":"IF(AND(C55=TRUE,$Q$11>3),$Q$12,\"\")","v":""},{"$f":"IF(AND(C55=TRUE,$Q$11>3),1,0)","v":0},{"v":168,"d":"$168.00"},{"$f":"G55*H55","v":0},{"$f":"IF(AND(G55>0,$Q$11=4),W57,IF(AND(G55>0,$Q$11=5),X57,IF(AND(G55>0,$Q$11=6),Y57,IF(AND(G55>0,$Q$11=7),Z57,IF(AND(G55>0,$Q$11=8),\"Quote\",0)))))","v":0},{"$nulls":5},"Material"]
[null,null,false,"Outboard Gear Oil Change",null,{"$f":"IF(AND(C56=TRUE,$Q$11=3,$Q$9=1),$Q$10,IF(AND(C56=TRUE,$Q$11=3,$Q$9=3),$Q$10,IF(AND(C56=TRUE,$Q$11=3,$Q$9=4),$Q$10,\"\")))","v":""},{"$f":"IF(AND(C56=TRUE,$Q$11=3,$Q$9=1),1,IF(AND(C56=TRUE,$Q$11=3,$Q$9=3),1,IF(AND(C56=TRUE,$Q$11=3,$Q$9=4),1,0)))","v":0},{"v":87.5,"d":"$87.50"},{"$f":"G56*H56","v":0},{"$f":"IF(AND(G56>0,$Q$11=3,$Q$9=1),S57,IF(AND(G56>0,$Q$11=3,$Q$9=3),V57,IF(AND(G56>0,$Q$11=3,$Q$9=4),\"Quote\",0)))","v":0},{"$nulls":5},"P/N"]
[null,null,false,"Store Sterndrive Inside",null,null,{"$f":"IF(AND(C57=TRUE,$Q$11>3),1,0)","v":0},{"v":95,"d":"$95.00"},{"$f":"G57*H57","v":0},0,{"$nulls":5},"Price",{"v":42.62,"d":"$42.62"},{"v":62.52,"d":"$62.52"},{"v":54.53,"d":"$54.53"},{"v":83.37,"d":"$83.37"},{"v":83.12,"d":"$83.12"},{"v":54.53,"d":"$54.53"},{"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(C58=TRUE,$Q$11>3,$G$57<1),1,0)","v":0},{"v":20,"d":"$20.00"},{"$f":"G58*H58","v":0},0]
[null,null,false,"Sterndrive Lock (Mandatory)",null,null,{"$f":"IF(AND(C59=TRUE,$Q$11>3,$G$57<1),1,0)","v":0},{"v":60,"d":"$60.00"},0,{"$f":"G59*H59","v":0}]
[null,null,true,"Shop Supplies",null,null,{"$f":"SUM(G54:G56)","v":0},{"v":2,"d":"$2.00"},0,{"$f":"G60*H60","v":0}]
[null,null,true,"Enviro Disposal Fee",null,null,{"$f":"SUM(G54:G56)","v":0},{"v":5,"d":"$5.00"},0,{"$f":"G61*H61","v":0}]
[]
[null,"6. SYSTEMS WINTERIZE",{"$nulls":4},"QTY","RATE","LABOUR","PARTS",null,null,"JOB SUB-TOTAL",{"$f":"SUM(I64:I69)+SUM(J64:J69)","v":0},null,null,"Qty","Price/Gal","Amt"]
[null,null,false,"Fresh Water System ",null,null,{"$f":"IF(C64=TRUE,1,0)","v":0},{"v":45,"d":"$45.00"},{"$f":"G64*H64","v":0},{"$f":"IF(C64=TRUE,(G64*S64),0)","v":0},{"$nulls":6},0,{"v":7.69,"d":"$7.69"},{"$f":"Q64*R64","v":0}]
[null,null,false,"Ballast Tank",null,null,0,{"v":75,"d":"$75.00"},0,0,{"$nulls":6},1,{"v":7.69,"d":"$7.69"},{"v":7.69,"d":"$7.69"}]
[null,null,false,"Livewell",null,null,0,{"v":25,"d":"$25.00"},0,0,{"$nulls":6},1,{"v":7.69,"d":"$7.69"},{"v":7.69,"d":"$7.69"}]
[null,null,false,"Head",null,null,0,{"v":25,"d":"$25.00"},0,0,{"$nulls":6},1,{"v":7.69,"d":"$7.69"},{"v":7.69,"d":"$7.69"}]
[null,null,false,"Pumpout",null,null,0,{"v":75,"d":"$75.00"},0,0,{"$nulls":7},{"v":7.69,"d":"$7.69"},0]
[null,null,false,"Washdown Pump",null,null,0,{"v":35,"d":"$35.00"},0,0,{"$nulls":6},1,{"v":7.69,"d":"$7.69"},{"v":7.69,"d":"$7.69"}]
[]
[null,"7. RUNABOUT  DETAILING",{"$nulls":4},"QTY","RATE","LABOUR","PARTS",null,null,"JOB SUB-TOTAL",{"$f":"SUM(I72:I77)","v":0}]
[null,null,true,"A) Spring Clean - Basic",null,"Per Ft LOA",{"$f":"IF(C72=TRUE,$I$8,0)","v":0},"No Charge",{"$f":"IF(C72=TRUE,\"Included\",0)","v":"Included"},{"$f":"IF(C72=TRUE,\"Included\",0)","v":"Included"}]
[null,null,false,"B) Spring Clean - Standard",null,"Per Ft LOA",{"$f":"IF(C73=TRUE,$I$8,0)","v":0},{"v":5,"d":"$5.00"},{"$f":"G73*H73","v":0},{"$f":"IF(I73>0,\"Included\",0)","v":0}]
[null,null,false,"C) Spring Clean - Deluxe",null,"Per Ft LOA",{"$f":"IF(C74=TRUE,$I$8,0)","v":0},{"v":10,"d":"$10.00"},{"$f":"G74*H74","v":0},{"$f":"IF(I74>0,\"Included\",0)","v":0}]
[null,null,false,"D) Steam Clean Ext Carpet",null,"Flat Rate",{"$f":"IF(C75=TRUE,1,0)","v":0},{"v":100,"d":"$100.00"},{"$f":"G75*H75","v":0},{"$f":"IF(I75>0,\"Included\",0)","v":0}]
[null,null,false,"E) Hand Wax - Hull & Deck",null,"Per Ft LOA",{"$f":"IF(C76=TRUE,$I$8,0)","v":0},{"v":10,"d":"$10.00"},{"$f":"G76*H76","v":0},{"$f":"IF(I76>0,\"Included\",0)","v":0}]
[null,null,false,"F) Buff & Wax - Hull & Deck",null,"Per Ft LOA",{"$f":"IF(C77=TRUE,$I$8,0)","v":0},{"v":35,"d":"$35.00"},{"$f":"G77*H77","v":0},{"$f":"IF(I77>0,\"Included\",0)","v":0}]
[]
[null,"Description"]
[null,"A) Spring Clean - Basic: Pressure wash exterior only to remove winter dust"]
[null,"B) Spring Clean - Standard: Pressure wash exterior, wipe down cockpit surfaces, vacuum cockpit carpet & clean windows and/or windshield"]
[null,"C) Spring Clean - Deluxe: All items incl in Standard plus clean in all compartment, remove cockpit carpet, pressure wash cockpit floor, apply UV protectant to vinyl surfaces and pressure wash bilge and ski locker(s)"]
[null,"D) Steam Clean Exterior Carpet: Remove snap-in carpets, steam clean on shop floor, hang to dry & reinstall in boat"]
[null,"E) Hand Wax - Hull & Deck: Apply UV wax to hull and deck and hand polish"]
[null,"F) Buff & Wax - Hull & Deck: Apply compound, machine polish to remove moderate oxidation & light scratches then apply UV wax and hand polish.  Heavy oxidation and fender chafe may require wet sanding and/or multi-stage compound,; both of which available at additional cost by quote only"]
[]
[null,"Notes:",{"$nulls":8},"SUB-TOTAL",null,null,{"$f":"N19+N33+N37+N45+N53+N63+N71","v":0}]
[{"$nulls":10},"OTHER",null,null,0]
[{"$nulls":10},"TOTAL",null,null,{"$f":"N87+N88","v":0}]
[{"$nulls":10},"13% HST - R833926280",null,null,{"$f":"N89*0.13","v":0}]
[{"$nulls":10},"TOTAL W/TAX",null,null,{"$f":"SUM(N89:N90)","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 delivery of my boat to the Marina. I agree to pay the Marina in full immediately upon completion of the work described herein and I authorize the Marina to process my credit card for the charges due.  I acknowledge that the Marina will provide me with a copy of the final Repair Order marked paid in full as well as a receipt for my credit card payment.  I acknowledge and agree that a service charge of 2% per month (24% per annum) will be charged on all unpaid accounts.  No contract is formed until this Estimate is accepted by the Marina."]
[]
[]
[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. "]
[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 or taken home; b) remove all personal items, including safety gear; c) empty refrigerators and coolers 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) remove all excess mooring equipment other than the minimum fenders and lines required for us to tie up your boat 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.  If your boat is delivered to us with a wet cockpit/interior, a minumum $150 surchage will be added to your invoice if we have to dry your boat prior to storage."]
[null,"6. ENGINE WINTERIZING Basic engine winterization is included with all runabout packages and includes, as applicable: a) haul out vessel from water or remove from trailer; b) add fuel stabilizer to the fuel tank(s); c) remove plugs and drain water from block / manifolds / exhaust / coolers, mufflers etc; d) reinstall plugs and fill engine with antifreeze; e) replace fuel filter; f) fog engine with storage seal mixture; g) battery service; and, h) spring launch and start-up."]
[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 select only 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 makes/models only as listed - all others will be quoted individually as required."]
[null,"10. PARTS ESTIMATES Parts quantities and prices quoted herein are estimates and are provided as a guideline only when estimating the cost to winterize your boat.  All parts will be billed according to actual quantities used."]
[null,"11. MANDATORY STERNDRIVE LOCKS All sterndrive powered boats stored with the Marina must be equipped with a sterndrive lock(s) unless the owner chooses indoor sterndrive storage; in which case a lock is not required.  If your drive does not have a lock installed, we will install one for you and the cost of the lock will be added to your invoice."]
[null,"12. TRAILERS If your boat is delivered to us on a its own trailer there will be no additional charge for winter trailer storage.  If your trailer is left with us in the spring, trailer storage will be charged at $55.00 per month, plus tax, after May 31st.  Trailer maintenance and/or service is not included in your winterizing services."]
[null,"13. CLEANING All runabout packages include basic spring cleaning, which includes pressure washing only of your boat's exterior to remove winter dust.  Additional cleaning is available at the rates quoted herein.  To ensure that your boat is ready on time in the spring, all additional cleaning should be ordered in the fall."]
[null,"14. 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,"15. STORAGE PERIOD The Runabout Storage pricing provided herein includes storage through May 31, 2016 only.  If your boat is left with us beyond this date you will be charged monthly summer storage at the Marina's 2016 rates."]
[null,"16. TAXES  All applicable taxes are extra and will be added to your final winterizing Repair Order."]
[null,"17. SPRING PICKUP As Owner, you are are responsible to advise the Marina, at time of drop-off, of your desired spring pick-up / delivery date.  Spring pickups / deliveries are scheduled on a first-come, first-served basis and are weather dependant.  For boats that are picked-up at the Marina, it is the Owner's responsibility to ensure the boat is securely loaded and strapped-down on the trailer; all loose items, including canvas, are removed and/or stowed; the hull plug is in; the trailer is in good working condition, including tires, bearings, brakes and lights (the Marina does not service trailers as part of winterizing services); and, the trailer is properley connected to your tow vehicle."]
[null,"18. 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, & 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 & 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, & 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 & 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, & 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 & the Owner wherein the Owner is licenced to use the storage space & 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 & 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 to Equipment except as authorized & 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 & 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; &\n(b) The Owner has all necessary corporate power, authority & capacity to enter into this Agreement and to perform its obligations under this Agreement; &\n(c) The execution & delivery of this Agreement & 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 & 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 & Owner."]
[null,"11. SUCCESSORS  This Agreement shall be binding on each of the parties hereto, their respective heirs, executors, administrators, personal representatives, successors & 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 & effect."]
[null,"13. JURISDICTION  This Agreement shall be read with all changes of gender & number required by the context.  This Agreement & the affairs of the parties shall be governed by the laws of the Province of Ontario & 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"]