{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["SM - BO Template"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":16,"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":"SM - BO Template","index":0,"n_rows":50,"n_cols":45,"rows_kept":50,"cut":false,"hidden":false,"merged":[[6,17,7,18],[26,3,26,5],[12,13,12,15],[31,3,32,13],[17,13,18,13],[17,14,18,14],[6,2,6,9],[8,2,8,9],[9,2,9,9],[8,13,8,15],[22,3,22,9],[28,1,29,15],[31,16,31,17],[13,16,13,18],[12,16,12,18],[14,16,14,18],[1,2,2,13],[5,13,5,15],[3,14,3,15],[2,14,2,15],[4,2,4,9],[3,6,3,12],[3,2,3,5],[5,2,5,9],[18,35,18,37],[17,11,18,11],[25,1,25,9],[17,18,18,18],[8,16,8,17],[10,16,10,17],[17,6,18,6],[17,1,18,1],[10,13,10,15],[11,13,11,15],[17,2,18,2],[17,16,18,16],[17,17,18,17],[15,16,15,17],[10,2,10,9],[11,2,11,9],[5,22,27,22],[18,32,18,34],[26,8,26,9],[9,13,9,15],[17,15,18,15],[17,12,18,12],[13,13,13,14],[14,13,15,15],[17,9,18,9],[5,16,5,17],[9,16,9,18],[12,2,12,9],[13,2,13,9],[17,7,18,7],[17,8,18,8],[17,4,18,4],[31,1,32,1],[14,3,14,9],[15,3,15,9],[20,3,20,9],[27,5,27,7],[17,5,18,5],[17,3,18,3],[27,2,27,4]]}
[]
[null,null,"Radio Broadcast Order",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spot"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Market",null,null,"Order#:",null,null,null,null,null,null,null,"Bonus"]
[null,null,{"$f":"VLOOKUP(O4,$Z$21:$AF$33,2,FALSE)","v":"101.5 CKMO-FM"},null,null,null,"  -   A Division of MBC",null,null,null,null,null,null,null,"Orangeville",null,null,"Date:",{"$f":"TODAY()","v":"2016-11-08"},null,null,null,"Co-op Script",null,null,"News Tag","SPOT"]
[null,null,{"$f":"VLOOKUP(O4,$Z$21:$AF$33,3,FALSE)","v":"22 Mill St., Unit 118"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"News Spnsr","PKG."]
[null,null,{"$f":"VLOOKUP(O4,Z21:AC33,4,FALSE)","v":"Orangeville, Ontario"},null,null,null,null,null,null,null,null,null,"Tel:",{"$f":"VLOOKUP(O4,Z21:AE33,6,FALSE)","v":"226-790-myfm (6936)"},null,null,"Revision",null,"NO",null,null,null,null,null,null,"Sports Tag","BONUS"]
[null,null,{"$f":"VLOOKUP(O4,$Z$21:$AF$33,5,FALSE)","v":"L9W 2M3"},null,null,null,null,null,null,null,null,null,"Fax:",{"$f":"VLOOKUP(O4,Z21:AF33,7,FALSE)","v":"226-779-7927"},null,null,null,{"$f":"IF(S6=\"YES\",\"ENTER ORIGINAL ORDER # ABOVE\",\" \")","v":" "},null,null,null,null,null,null,null,"Sprts Spnsr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wther Tag",null,null,null,null,null,null,null,null,null,null,"M","T","W","T","F","S","S","Spots","Bonus"]
[null,"Client:",null,null,null,null,null,null,null,null,null,null,"Contact:",null,null,null,"Start Date:",null,null,null,null,null,null,null,null,"Wther Spnsr",null,":10","Level 1",1," 6 SPOTS/WEEK",null,"6 SPOTS/WEEK - BONUS",null,null,11,1,1,1,1,1,null,1,6,6]
[null,"Address:",null,null,null,null,null,null,null,null,null,null,"Phone:",null,null,null,{"$f":"IF(StartDate<S4,\"INVALID - CHANGE TO FUTURE DATE\",\" \")","v":"INVALID - CHANGE TO FUTURE DATE"},null,null,null,null,null,null,null,null,"Info Tag",null,":15","Level 2",2,"12 SPOTS/WEEK",null,"7 SPOTS/WEEK - BONUS",null,null,12,1,1,1,1,1,1,1,12,7]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fax:",null,null,null,"Expiry Date:",null,null,null,null,null,null,null,null,"Info Spnsr",null,":30","Level 3",3,"18 SPOTS/WEEK",null,"8 SPOTS/WEEK - BONUS",null,null,13,1,1,1,1,1,1,2,18,8]
[null,null,null,null,null,null,null,null,null,null,null,null,"Email:",null,null,null,null,null,null,null,null,null,null,null,null,"Bonus PSA",null,":45"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Inv. Email:",null,null,null,"Acct. Exec:",null,null,null,null,null,null,null,null,"Coupon",null,":60",{"$f":"VLOOKUP($S$16,$AC$9:$AJ$11,8)","v":11}]
[null,"Line of Business:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",null,"01:30:00"]
[null,"New Client  ","NO","Detailed Billing ",null,null,null,null,null,null,null,null,"NO",{"$f":"IF(M16=\"YES\", \"PLEASE INSERT CO-OP SCRIPT ON THE RIGHT\",\" \")","v":" "},null,null,"Campaign:",null,null,null,null,null,null,null,null,null,null,"02:00:00"]
[null,"Prepayment Collected","NO","Co-Op",null,null,null,null,null,null,null,null,"NO",null,null,null,"Smart Marketing",null,"Level 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YES"]
[null,"Instructions","# Wks","M","T","W","T","F","S","S",null,"Total","Times","Length","Desc.","Occ.","Spot Rate","Pkg. Price","Total Amount",null,null,null,null,null,null,"NO",null,null,null,null,null,null,null,null,null,null,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly",null,null,"Annual"]
[null,{"$f":"VLOOKUP($S$16,$AC$9:$AK$11,3)","v":" 6 SPOTS/WEEK"},52,{"$f":"VLOOKUP($S$16,$AC$9:$AM$11,2)","v":1},{"$f":"VLOOKUP($S$16,$AC$9:$AM$11,2)","v":1},1,{"$f":"VLOOKUP($S$16,$AC$9:$AM$11,2)","v":1},{"$f":"VLOOKUP($S$16,$AC$9:$AM$11,2)","v":1},1,null,{"$f":"VLOOKUP($S$16,$AC$9:$AS$11,16)","v":6},{"$f":"SUM(D20:J20)","v":6},"6A-8P",":30","Spot",{"$f":"C20*SUM(D20:J20)","v":312},{"$f":"$S$24/$P$20","v":24.833333333333332},null,{"$f":"P20*Q20","v":7748},null,null,null,null,null,null,null,null,"Street","Town","Postal Code","Tel.","Fax","Level 1","Level 2","Level 3","Level 1","Level 2","Level 3"]
[null,null,null,{"$f":"IF(L20<>K20,\"INCORRECT # OF SPOTS\",\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alliston","Alliston","92.1 CIMA-FM","63 Tupper St. W., Suite 301","Alliston, Ontario","L9R 1E4","705-530-6936","705-530-1921",99,159,199,{"$f":"AG21*$AK$18","v":5148},{"$f":"AH21*$AK$18","v":8268},{"$f":"AI21*$AK$18","v":10348}]
[null,{"$f":"VLOOKUP($S$16,$AC$9:$AK$11,5)","v":"6 SPOTS/WEEK - BONUS"},52,{"$f":"VLOOKUP($S$16,$AC$9:$AQ$11,9)","v":1},{"$f":"VLOOKUP($S$16,$AC$9:$AQ$11,10)","v":1},{"$f":"VLOOKUP($S$16,$AC$9:$AQ$11,11)","v":1},{"$f":"VLOOKUP($S$16,$AC$9:$AQ$11,12)","v":1},{"$f":"VLOOKUP($S$16,$AC$9:$AQ$11,13)","v":1},{"$f":"VLOOKUP($S$16,$AC$9:$AQ$11,14)","v":0},{"$f":"VLOOKUP($S$16,$AC$9:$AQ$11,15)","v":1},{"$f":"VLOOKUP($S$16,$AC$9:$AS$11,17)","v":6},{"$f":"SUM(D22:J22)","v":6},"BTA",":30","Bonus",{"$f":"C22*SUM(D22:J22)","v":312},null,null,null,null,null,null,null,null,"Arnprior","Arnprior","107.7 CHMY-FM-1","160 William St. W, Suite 52","Arnprior, Ontario","K7S 3W4","613-623-7772","613-623-4508",99,169,229,5148,8788,11908]
[null,null,null,{"$f":"IF(L22<>K22,\"INCORRECT # OF SPOTS\",\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brighton","Brighton","100.9 CIYM-FM","6 Oliphant St., Unit 5, Box 1522","Brighton, Ontario","K0K 1H0","613-475-6936","613-475-9026",89,139,189,4628,7228,9828]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,"Sub-Total",{"$f":"VLOOKUP($O$4,$Z$21:$AL$33,$AC$13)","v":7748},null,null,null,null,null,"Exeter","Exeter","90.5 CKXM-FM","145 Thames Rd. W., Unit 6","Exeter, Ontario","N0M 1S3","519-235-3000","519-235-6262",99,169,229,5148,8788,11908]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P20+SUM(P22:P23)","v":624},0.13,"HST",{"$f":"S24*Q25","v":1007.24},null,null,null,null,null,"Gananoque","Gananoque","99.9 CJGM-FM","110 Kate St.","Gananoque, Ontario","K7G 2M7","613-382-myfm (6936)","613-382-8301",89,139,189,4628,7228,9828]
[null,"Details of Billing and Other Instructions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(S24:S25)","v":8755.24},null,null,null,null,null,"Kincardine","Kincardine","95.5 CIYN-FM","756 Queen St.","Kincardine, Ontario","N2Z 2Y2","519-396-7770","519-397-7771",119,169,229,6188,8788,11908]
[null,null,null,{"$f":"S24/12","v":645.66666666666663},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Napanee","Napanee","88.7 CKYM-FM","20 Market Square","Napanee, Ontario","K7R 1J3","613-354-4554","613-354-3661",99,169,229,5148,8788,11908]
[null,"Invoice Monthly:",null,null,null,{"$f":"P28*4","v":596},null,null,null,null,null,null,null,{"$f":"P28*5","v":745},null,{"$f":"S24/52","v":149},null,null,null,null,null,null,null,null,"Norfolk County","Norfolk County","98.9 CHCD-FM","55 Park Road, Box 98","Simcoe, Ontario","N3Y 4K8","519-426-7700","519-426-8574",159,199,279,8268,10348,14508]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orangeville","Orangeville","101.5 CKMO-FM","22 Mill St., Unit 118","Orangeville, Ontario","L9W 2M3","226-790-myfm (6936)","226-779-7927",149,199,249,7748,10348,12948]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pembroke","Pembroke","104.9 CIMY-FM","84 Isabella St.","Pembroke, Ontario","K8A 5S5","613-735-myfm (6936)","613-732-4054",139,189,239,7228,9828,12428]
[null,"Terms: Net 30      Note: First and last month billing will be pro-rated if order starts mid-month.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Peterborough","Peterborough","90.5 CJMB-FM","727 Lansdowne St. W.","Peterborough, Ontario","K9J 1Z2","705-874-0905","705-748-6936",99,169,229,5148,8788,11908]
[null,"Approved",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MBC - BO 011.16.",null,{"$f":"IF(S24>0.01,S24/(P20),\" \")","v":24.833333333333332},null,null,null,null,null,"Renfrew","Renfrew","96.1 CHMY-FM","321B Raglan St. S., Box 961","Renfrew, Ontario ","K7V 4H4","613-432-myfm (6936)","613-432-1086",129,169,229,6708,8788,11908]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"St. Thomas","St. Thomas","94.1 CKZM-FM","30 Talbot St., Lower Level, Unit 2","St. Thomas, Ontario","N5P 4E2","519-633-myfm (6936)","519-637-8410",119,169,229,6188,8788,11908]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strathroy","Strathroy","105.7 CJMI-FM","85 Zimmerman St. S., Unit 1","Strathroy, Ontario","N7G 0A3","519-246-myfm (6936)","519-245-6670",109,169,229,5668,8788,11908]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bonus Spots"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O20=$Z$3,P20,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O22=$Z$3,#REF!,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=$Z$3,#REF!,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=$Z$3,#REF!,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=$Z$3,#REF!,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=$Z$3,#REF!,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=$Z$3,#REF!,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=$Z$3,#REF!,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=$Z$3,#REF!,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O23=$Z$3,P23,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z40:Z49)","v":{"$error":"#REF!"}},"Total"]