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

{"sheet":"Budget","index":0,"n_rows":72,"n_cols":51,"rows_kept":72,"merged":[[1,4,1,6],[1,8,1,10],[1,12,1,14],[1,16,1,18],[1,20,1,22],[1,24,1,26],[1,28,1,30],[1,32,1,34],[1,36,1,38],[1,40,1,42],[1,44,1,46],[1,48,1,50],[52,0,52,2],[62,0,62,2],[70,0,70,1],[71,0,71,1],[72,0,72,1]]}
[{"$nulls":4},"Show 1 Name: ",{"$nulls":3},"Show 2 Name: ",{"$nulls":3},"Show 3 Name: ",{"$nulls":3},"Show 4 Name: ",{"$nulls":3},"Show 5 Name: ",{"$nulls":3},"Show 6 Name: ",{"$nulls":3},"Show 7 Name: ",{"$nulls":3},"Show 8 Name: ",{"$nulls":3},"Show 9 Name: ",{"$nulls":3},"Show 10 Name: ",{"$nulls":3},"Show 10 Name: "]
["Show name",{"$nulls":3},"AAAA",{"$nulls":3},"BBBB",{"$nulls":3},"CCCC",{"$nulls":3},"DDDD",{"$nulls":3},"EEEE",{"$nulls":3},"FFFF",{"$nulls":3},"GGGG",{"$nulls":3},"HHHH",{"$nulls":3},"IIII",{"$nulls":3},"JJJJ",{"$nulls":3},"KKKK",{"$nulls":3},"All Show Totals"]
["Show date",{"$nulls":3},"Put first show date here"]
["Show city",{"$nulls":3},"Put first show city here"]
["Booth number(s)",{"$nulls":3},"Put first booth number here"]
["Booth size(s)",{"$nulls":3},"Put first booth size here",{"$nulls":43},"Recalculate equations if you add shows"]
["Website"]
["Trade Show Costs","Notes","Acct#",null,"Plan","Actual","Variance",null,"Plan","Actual","Variance",null,"Plan","Actual","Variance",null,"Plan","Actual","Variance",null,"Plan","Actual","Variance",null,"Plan","Actual","Variance",null,"Plan","Actual","Variance",null,"Plan","Actual","Variance",null,"Plan","Actual","Variance",null,"Plan","Actual","Variance",null,"Plan","Actual","Variance",null,"Plan","Actual","Variance"]
["Booth space","About 1/3 entire budget usually.",null,null,0,0,{"$f":"E9-F9","v":0},null,0,0,{"$f":"I9-J9","v":0},null,0,0,{"$f":"M9-N9","v":0},null,0,0,{"$f":"Q9-R9","v":0},null,0,0,{"$f":"U9-V9","v":0},null,0,0,{"$f":"Y9-Z9","v":0},null,0,0,{"$f":"AC9-AD9","v":0},null,0,0,{"$f":"AG9-AH9","v":0},null,0,0,{"$f":"AK9-AL9","v":0},null,0,0,{"$f":"AO9-AP9","v":0},null,0,0,{"$f":"AS9-AT9","v":0},null,{"$f":"SUM(E9+I9+M9+Q9+U9+AC9+AG9+Y9+AK9+AO9+AS9)","v":0},{"$f":"SUM(F9+J9+N9+R9+V9+AD9+AH9+Z9+AL9+AP9+AT9)","v":0},{"$f":"AW9-AX9","v":0}]
[]
["Exhibit-related costs"]
["Exhibit use at show","Pro-rated for each show use, or expense at major show.  Add show-specific graphics.",null,null,0,0,{"$f":"E12-F12","v":0},null,0,0,{"$f":"I12-J12","v":0},null,0,0,{"$f":"M12-N12","v":0},null,0,0,{"$f":"Q12-R12","v":0},null,0,0,{"$f":"U12-V12","v":0},null,0,0,{"$f":"Y12-Z12","v":0},null,0,0,{"$f":"AC12-AD12","v":0},null,0,0,{"$f":"AG12-AH12","v":0},null,0,0,{"$f":"AK12-AL12","v":0},null,0,0,{"$f":"AO12-AP12","v":0},null,0,0,{"$f":"AS12-AT12","v":0},null,{"$f":"SUM(E12+I12+M12+Q12+U12+AC12+AG12+Y12+AK12+AO12+AS12)","v":0},{"$f":"SUM(F12+J12+N12+R12+V12+AD12+AH12+Z12+AL12+AP12+AT12)","v":0},{"$f":"AW12-AX12","v":0}]
["Exhibit storage (per show)",{"$nulls":3},0,0,{"$f":"E13-F13","v":0},null,0,0,{"$f":"I13-J13","v":0},null,0,0,{"$f":"M13-N13","v":0},null,0,0,{"$f":"Q13-R13","v":0},null,0,0,{"$f":"U13-V13","v":0},null,0,0,{"$f":"Y13-Z13","v":0},null,0,0,{"$f":"AC13-AD13","v":0},null,0,0,{"$f":"AG13-AH13","v":0},null,0,0,{"$f":"AK13-AL13","v":0},null,0,0,{"$f":"AO13-AP13","v":0},null,0,0,{"$f":"AS13-AT13","v":0},null,{"$f":"SUM(E13+I13+M13+Q13+U13+AC13+AG13+Y13+AK13+AO13+AS13)","v":0},{"$f":"SUM(F13+J13+N13+R13+V13+AD13+AH13+Z13+AL13+AP13+AT13)","v":0},{"$f":"AW13-AX13","v":0}]
["   Subtotal:",{"$nulls":3},{"$f":"SUM(E12:E13)","v":0},{"$f":"SUM(F12:F13)","v":0},{"$f":"E14-F14","v":0},null,{"$f":"SUM(I12:I13)","v":0},{"$f":"SUM(J12:J13)","v":0},{"$f":"I14-J14","v":0},null,{"$f":"SUM(M12:M13)","v":0},{"$f":"SUM(N12:N13)","v":0},{"$f":"M14-N14","v":0},null,{"$f":"SUM(Q12:Q13)","v":0},{"$f":"SUM(R12:R13)","v":0},{"$f":"Q14-R14","v":0},null,{"$f":"SUM(U12:U13)","v":0},{"$f":"SUM(V12:V13)","v":0},{"$f":"U14-V14","v":0},null,{"$f":"SUM(Y12:Y13)","v":0},{"$f":"SUM(Z12:Z13)","v":0},{"$f":"Y14-Z14","v":0},null,{"$f":"SUM(AC12:AC13)","v":0},{"$f":"SUM(AD12:AD13)","v":0},{"$f":"AC14-AD14","v":0},null,{"$f":"SUM(AG12:AG13)","v":0},{"$f":"SUM(AH12:AH13)","v":0},{"$f":"AG14-AH14","v":0},null,{"$f":"SUM(AK12:AK13)","v":0},{"$f":"SUM(AL12:AL13)","v":0},{"$f":"AK14-AL14","v":0},null,{"$f":"SUM(AO12:AO13)","v":0},{"$f":"SUM(AP12:AP13)","v":0},{"$f":"AO14-AP14","v":0},null,{"$f":"SUM(AS12:AS13)","v":0},{"$f":"SUM(AT12:AT13)","v":0},{"$f":"AS14-AT14","v":0},null,{"$f":"SUM(AW12:AW13)","v":0},{"$f":"SUM(AX12:AX13)","v":0},{"$f":"AW14-AX14","v":0}]
[]
["Promotions"]
["Pre-Show Promo","Printing, postage, mail house, list rental",null,null,0,0,{"$f":"E17-F17","v":0},null,0,0,{"$f":"I17-J17","v":0},null,0,0,{"$f":"M17-N17","v":0},null,0,0,{"$f":"Q17-R17","v":0},null,0,0,{"$f":"U17-V17","v":0},null,0,0,{"$f":"Y17-Z17","v":0},null,0,0,{"$f":"AC17-AD17","v":0},null,0,0,{"$f":"AG17-AH17","v":0},null,0,0,{"$f":"AK17-AL17","v":0},null,0,0,{"$f":"AO17-AP17","v":0},null,0,0,{"$f":"AS17-AT17","v":0},null,{"$f":"SUM(E17+I17+M17+Q17+U17+AC17+AG17+Y17+AK17+AO17+AS17)","v":0},0,{"$f":"AW17-AX17","v":0}]
["At-Show Promo","Ads, press kits, sponsorships, giveaways, at-show events, or professional talent at show",null,null,0,0,{"$f":"E18-F18","v":0},null,0,0,{"$f":"I18-J18","v":0},null,0,0,{"$f":"M18-N18","v":0},null,0,0,{"$f":"Q18-R18","v":0},null,0,0,{"$f":"U18-V18","v":0},null,0,0,{"$f":"Y18-Z18","v":0},null,0,0,{"$f":"AC18-AD18","v":0},null,0,0,{"$f":"AG18-AH18","v":0},null,0,0,{"$f":"AK18-AL18","v":0},null,0,0,{"$f":"AO18-AP18","v":0},null,0,0,{"$f":"AS18-AT18","v":0},null,0,0,{"$f":"AW18-AX18","v":0}]
["Post-Show Promo","Follow-up and lead fulfillment",null,null,0,0,{"$f":"E19-F19","v":0},null,0,0,{"$f":"I19-J19","v":0},null,0,0,{"$f":"M19-N19","v":0},null,0,0,{"$f":"Q19-R19","v":0},null,0,0,{"$f":"U19-V19","v":0},null,0,0,{"$f":"Y19-Z19","v":0},null,0,0,{"$f":"AC19-AD19","v":0},null,0,0,{"$f":"AG19-AH19","v":0},null,0,0,{"$f":"AK19-AL19","v":0},null,0,0,{"$f":"AO19-AP19","v":0},null,0,0,{"$f":"AS19-AT19","v":0},null,0,0,{"$f":"AW19-AX19","v":0}]
["Measurement of ROI & ROO","Reinvest 1 to 3% of show budget to prove and improve",null,null,0,0,{"$f":"E20-F20","v":0},null,0,0,{"$f":"I20-J20","v":0},null,0,0,{"$f":"M20-N20","v":0},null,0,0,{"$f":"Q20-R20","v":0},null,0,0,{"$f":"U20-V20","v":0},null,0,0,{"$f":"Y20-Z20","v":0},null,0,0,{"$f":"AC20-AD20","v":0},null,0,0,{"$f":"AG20-AH20","v":0},null,0,0,{"$f":"AK20-AL20","v":0},null,0,0,{"$f":"AO20-AP20","v":0},null,0,0,{"$f":"AS20-AT20","v":0},null,0,0]
["   Subtotal:",{"$nulls":3},{"$f":"SUM(E17:E20)","v":0},{"$f":"SUM(F17:F20)","v":0},{"$f":"E21-F21","v":0},null,{"$f":"SUM(I17:I20)","v":0},{"$f":"SUM(J17:J20)","v":0},{"$f":"I21-J21","v":0},null,{"$f":"SUM(M17:M20)","v":0},{"$f":"SUM(N17:N20)","v":0},{"$f":"M21-N21","v":0},null,{"$f":"SUM(Q17:Q20)","v":0},{"$f":"SUM(R17:R20)","v":0},{"$f":"Q21-R21","v":0},null,{"$f":"SUM(U17:U20)","v":0},{"$f":"SUM(V17:V20)","v":0},{"$f":"U21-V21","v":0},null,{"$f":"SUM(Y17:Y20)","v":0},{"$f":"SUM(Z17:Z20)","v":0},{"$f":"Y21-Z21","v":0},null,{"$f":"SUM(AC17:AC20)","v":0},{"$f":"SUM(AD17:AD20)","v":0},{"$f":"AC21-AD21","v":0},null,{"$f":"SUM(AG17:AG20)","v":0},{"$f":"SUM(AH17:AH20)","v":0},{"$f":"AG21-AH21","v":0},null,{"$f":"SUM(AK17:AK20)","v":0},{"$f":"SUM(AL17:AL20)","v":0},{"$f":"AK21-AL21","v":0},null,{"$f":"SUM(AO17:AO20)","v":0},{"$f":"SUM(AP17:AP20)","v":0},{"$f":"AO21-AP21","v":0},null,{"$f":"SUM(AS17:AS20)","v":0},{"$f":"SUM(AT17:AT20)","v":0},{"$f":"AS21-AT21","v":0},null,{"$f":"SUM(AW17:AW20)","v":0},{"$f":"SUM(AX17:AX20)","v":0},{"$f":"AW21-AX21","v":0}]
[]
["At-Show Services"]
["Freight","Exhibit, product, literature, giveaways",null,null,0,0,{"$f":"E24-F24","v":0},null,0,0,{"$f":"I24-J24","v":0},null,0,0,{"$f":"M24-N24","v":0},null,0,0,{"$f":"Q24-R24","v":0},null,0,0,{"$f":"U24-V24","v":0},null,0,0,{"$f":"Y24-Z24","v":0},null,0,0,{"$f":"AC24-AD24","v":0},null,0,0,{"$f":"AG24-AH24","v":0},null,0,0,{"$f":"AK24-AL24","v":0},null,0,0,{"$f":"AO24-AP24","v":0},null,0,0,{"$f":"AS24-AT24","v":0},null,{"$f":"SUM(E24+I24+M24+Q24+U24+AC24+AG24+Y24+AK24+AO24+AS24)","v":0},{"$f":"SUM(F24+J24+N24+R24+V24+AD24+AH24+Z24+AL24+AP24+AT24)","v":0},{"$f":"AW24-AX24","v":0}]
["Drayage","Cost to bring the exhibit and crates from storage into the hall and back.",null,null,0,0,{"$f":"E25-F25","v":0},null,0,0,{"$f":"I25-J25","v":0},null,0,0,{"$f":"M25-N25","v":0},null,0,0,{"$f":"Q25-R25","v":0},null,0,0,{"$f":"U25-V25","v":0},null,0,0,{"$f":"Y25-Z25","v":0},null,0,0,{"$f":"AC25-AD25","v":0},null,0,0,{"$f":"AG25-AH25","v":0},null,0,0,{"$f":"AK25-AL25","v":0},null,0,0,{"$f":"AO25-AP25","v":0},null,0,0,{"$f":"AS25-AT25","v":0},null,{"$f":"SUM(E25+I25+M25+Q25+U25+AC25+AG25+Y25+AK25+AO25+AS25)","v":0},0,{"$f":"AW25-AX25","v":0}]
["Electric","Lights, computers, refrigerators, installation.",null,null,0,0,{"$f":"E26-F26","v":0},null,0,0,{"$f":"I26-J26","v":0},null,0,0,{"$f":"M26-N26","v":0},null,0,0,{"$f":"Q26-R26","v":0},null,0,0,{"$f":"U26-V26","v":0},null,0,0,{"$f":"Y26-Z26","v":0},null,0,0,{"$f":"AC26-AD26","v":0},null,0,0,{"$f":"AG26-AH26","v":0},null,0,0,{"$f":"AK26-AL26","v":0},null,0,0,{"$f":"AO26-AP26","v":0},null,0,0,{"$f":"AS26-AT26","v":0},null,0,0,{"$f":"AW26-AX26","v":0}]
["AV & Technology at show","Internet connection, computers, monitors, flatscreen rental?",null,null,0,0,{"$f":"E27-F27","v":0},null,0,0,{"$f":"I27-J27","v":0},null,0,0,{"$f":"M27-N27","v":0},null,0,0,{"$f":"Q27-R27","v":0},null,0,0,{"$f":"U27-V27","v":0},null,0,0,{"$f":"Y27-Z27","v":0},null,0,0,{"$f":"AC27-AD27","v":0},null,0,0,{"$f":"AG27-AH27","v":0},null,0,0,{"$f":"AK27-AL27","v":0},null,0,0,{"$f":"AO27-AP27","v":0},null,0,0,{"$f":"AS27-AT27","v":0},null,0,0,{"$f":"AW27-AX27","v":0}]
["Show I&D","Supervision, labor, rigging, forklifts",null,null,0,0,{"$f":"E28-F28","v":0},null,0,0,{"$f":"I28-J28","v":0},null,0,0,{"$f":"M28-N28","v":0},null,0,0,{"$f":"Q28-R28","v":0},null,0,0,{"$f":"U28-V28","v":0},null,0,0,{"$f":"Y28-Z28","v":0},null,0,0,{"$f":"AC28-AD28","v":0},null,0,0,{"$f":"AG28-AH28","v":0},null,0,0,{"$f":"AK28-AL28","v":0},null,0,0,{"$f":"AO28-AP28","v":0},null,0,0,{"$f":"AS28-AT28","v":0},null,0,0,{"$f":"AW28-AX28","v":0}]
["Carpet or flooring","Rental or purchase cost prorated per show",null,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0]
["Booth cleaning","Cleaning exhibit, carpet, trash removal.",null,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0]
["Card readers","Machine rental, forms",null,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0]
["Floral","Mum's the word",null,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0]
["Furniture rental",{"$nulls":3},0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0]
["Security",{"$nulls":3},0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0]
["   Subtotal:",{"$nulls":3},{"$f":"SUM(E24:E34)","v":0},{"$f":"SUM(F24:F34)","v":0},0,null,{"$f":"SUM(I24:I34)","v":0},{"$f":"SUM(J24:J34)","v":0},0,null,{"$f":"SUM(M24:M34)","v":0},{"$f":"SUM(N24:N34)","v":0},0,null,{"$f":"SUM(Q24:Q34)","v":0},{"$f":"SUM(R24:R34)","v":0},0,null,{"$f":"SUM(U24:U34)","v":0},{"$f":"SUM(V24:V34)","v":0},0,null,{"$f":"SUM(Y24:Y34)","v":0},{"$f":"SUM(Z24:Z34)","v":0},0,null,{"$f":"SUM(AC24:AC34)","v":0},{"$f":"SUM(AD24:AD34)","v":0},0,null,{"$f":"SUM(AG24:AG34)","v":0},{"$f":"SUM(AH24:AH34)","v":0},0,null,{"$f":"SUM(AK24:AK34)","v":0},{"$f":"SUM(AL24:AL34)","v":0},0,null,{"$f":"SUM(AO24:AO34)","v":0},{"$f":"SUM(AP24:AP34)","v":0},0,null,{"$f":"SUM(AS24:AS34)","v":0},{"$f":"SUM(AT24:AT34)","v":0},0,null,{"$f":"SUM(AW24:AW34)","v":0},{"$f":"SUM(AX24:AX34)","v":0},0]
[]
["Staffer Costs"]
["Travel",{"$nulls":3},0,0,{"$f":"E38-F38","v":0},null,0,0,{"$f":"I38-J38","v":0},null,0,0,{"$f":"M38-N38","v":0},null,0,0,{"$f":"Q38-R38","v":0},null,0,0,{"$f":"U38-V38","v":0},null,0,0,{"$f":"Y38-Z38","v":0},null,0,0,{"$f":"AC38-AD38","v":0},null,0,0,{"$f":"AG38-AH38","v":0},null,0,0,{"$f":"AK38-AL38","v":0},null,0,0,{"$f":"AO38-AP38","v":0},null,0,0,{"$f":"AS38-AT38","v":0},null,{"$f":"SUM(E38+I38+M38+Q38+U38+AC38+AG38+Y38+AK38+AO38+AS38)","v":0},{"$f":"SUM(F38+J38+N38+R38+V38+AD38+AH38+Z38+AL38+AP38+AT38)","v":0},{"$f":"AW38-AX38","v":0}]
["Hotel",{"$nulls":3},0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0]
["Meals",{"$nulls":3},0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0]
["Booth Staffer Attire","Have an extra set or wash every day.",null,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,null,0,null,0,null,0,null,0,0,0]
["Taxi, ground transport, parking","Sometimes limos cost less for a group",null,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0]
["Staffer show registration","Some shows require registration for staffers",null,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0]
["Training","Trained booth staffers pull in more leads",null,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0,null,0,0,0]
["   Subtotal:",{"$nulls":3},{"$f":"SUM(E38:E44)","v":0},{"$f":"SUM(F38:F44)","v":0},0,null,{"$f":"SUM(I38:I44)","v":0},{"$f":"SUM(J38:J44)","v":0},0,null,{"$f":"SUM(M38:M44)","v":0},{"$f":"SUM(N38:N44)","v":0},0,null,{"$f":"SUM(Q38:Q44)","v":0},{"$f":"SUM(R38:R44)","v":0},0,null,{"$f":"SUM(U38:U44)","v":0},{"$f":"SUM(V38:V44)","v":0},0,null,{"$f":"SUM(Y38:Y44)","v":0},{"$f":"SUM(Z38:Z44)","v":0},0,null,{"$f":"SUM(AC38:AC44)","v":0},{"$f":"SUM(AD38:AD44)","v":0},0,null,{"$f":"SUM(AG38:AG44)","v":0},{"$f":"SUM(AH38:AH44)","v":0},0,null,{"$f":"SUM(AK38:AK44)","v":0},{"$f":"SUM(AL38:AL44)","v":0},0,null,{"$f":"SUM(AO38:AO44)","v":0},{"$f":"SUM(AP38:AP44)","v":0},0,null,{"$f":"SUM(AS38:AS44)","v":0},{"$f":"SUM(AT38:AT44)","v":0},0,null,{"$f":"SUM(AW38:AW44)","v":0},{"$f":"SUM(AX38:AX44)","v":0},0]
[]
["Miscellaneous"]
["Total",{"$nulls":3},{"$f":"SUM(E9+E14+E21+E45+E47+E35)","v":0},{"$f":"SUM(F9+F14+F21+F45+F47)","v":0},{"$f":"E48-F48","v":0},null,{"$f":"SUM(I9+I14+I21+I45+I47+I35)","v":0},{"$f":"SUM(J9+J14+J21+J45+J47)","v":0},{"$f":"I48-J48","v":0},null,{"$f":"SUM(M9+M14+M21+M45+M47+M35)","v":0},{"$f":"SUM(N9+N14+N21+N45+N47)","v":0},{"$f":"M48-N48","v":0},null,{"$f":"SUM(Q9+Q14+Q21+Q45+Q47+Q35)","v":0},{"$f":"SUM(R9+R14+R21+R45+R47)","v":0},{"$f":"Q48-R48","v":0},null,{"$f":"SUM(U9+U14+U21+U45+U47+U35)","v":0},{"$f":"SUM(V9+V14+V21+V45+V47)","v":0},{"$f":"U48-V48","v":0},null,{"$f":"SUM(Y9+Y14+Y21+Y45+Y47+Y35)","v":0},{"$f":"SUM(Z9+Z14+Z21+Z45+Z47)","v":0},{"$f":"Y48-Z48","v":0},null,{"$f":"SUM(AC9+AC14+AC21+AC45+AC47+AC35)","v":0},{"$f":"SUM(AD9+AD14+AD21+AD45+AD47)","v":0},{"$f":"AC48-AD48","v":0},null,{"$f":"SUM(AG9+AG14+AG21+AG45+AG47+AG35)","v":0},{"$f":"SUM(AH9+AH14+AH21+AH45+AH47)","v":0},{"$f":"AG48-AH48","v":0},null,{"$f":"SUM(AK9+AK14+AK21+AK45+AK47+AK35)","v":0},{"$f":"SUM(AL9+AL14+AL21+AL45+AL47)","v":0},{"$f":"AK48-AL48","v":0},null,{"$f":"SUM(AO9+AO14+AO21+AO45+AO47+AO35)","v":0},{"$f":"SUM(AP9+AP14+AP21+AP45+AP47)","v":0},{"$f":"AO48-AP48","v":0},null,{"$f":"SUM(AS9+AS14+AS21+AS45+AS47+AS35)","v":0},{"$f":"SUM(AT9+AT14+AT21+AT45+AT47)","v":0},{"$f":"AS48-AT48","v":0},null,{"$f":"SUM(E48+I48+M48+Q48+U48+AC48+AG48+Y48+AK48+AO48+AS48)","v":0},{"$f":"SUM(AX9+AX14+AX21+AX45+AX47)","v":0},{"$f":"AW48-AX48","v":0}]
[]
["Calculate Your ROI Per Show","Enter in data in blue cells only",{"$nulls":46},"Recalculate equations if you add shows"]
[null,"Calculated cells in green"]
[]
["Enter Data in the following 8 lines if you know your closure rate, but not show sales"]
["Leads","enter data",{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},{"$f":"SUM(F54+J54+N54+R54+V54+AD54+AH54+Z54+AL54+AP54+AT54)","v":0}]
["Cost per lead","calculated",{"$nulls":3},{"$f":"IF(F54<1,\"-\",F48/F54)","v":"-"},{"$nulls":3},{"$f":"IF(J54<1,\"-\",J48/J54)","v":"-"},{"$nulls":3},{"$f":"IF(N54<1,\"-\",N48/N54)","v":"-"},{"$nulls":3},{"$f":"IF(R54<1,\"-\",R48/R54)","v":"-"},{"$nulls":3},{"$f":"IF(V54<1,\"-\",V48/V54)","v":"-"},{"$nulls":3},{"$f":"IF(Z54<1,\"-\",Z48/Z54)","v":"-"},{"$nulls":3},{"$f":"IF(AD54<1,\"-\",AD48/AD54)","v":"-"},{"$nulls":3},{"$f":"IF(AH54<1,\"-\",AH48/AH54)","v":"-"},{"$nulls":3},{"$f":"IF(AL54<1,\"-\",AL48/AL54)","v":"-"},{"$nulls":3},{"$f":"IF(AP54<1,\"-\",AP48/AP54)","v":"-"},{"$nulls":3},{"$f":"IF(AT54<1,\"-\",AT48/AT54)","v":"-"},{"$nulls":3},{"$f":"IF(AX54<0.000001,\"-\",AX48/AX54)","v":"-"}]
["Closure rate","enter data",{"$nulls":3},{"v":0,"d":"0%"},{"$nulls":3},{"v":0,"d":"0%"},{"$nulls":3},{"v":0,"d":"0%"},{"$nulls":3},{"v":0,"d":"0%"},{"$nulls":3},{"v":0,"d":"0%"},{"$nulls":3},{"v":0,"d":"0%"},{"$nulls":3},{"v":0,"d":"0%"},{"$nulls":3},{"v":0,"d":"0%"},{"$nulls":3},{"v":0,"d":"0%"},{"$nulls":3},{"v":0,"d":"0%"},{"$nulls":3},{"v":0,"d":"0%"},{"$nulls":3},{"$f":"IF(AX54<0.000001,\"-\",SUM(AX57/AX54))","v":"-"}]
["Number of Sales","calculated",{"$nulls":3},{"$f":"F54*F56","v":0},{"$nulls":3},{"$f":"J54*J56","v":0},{"$nulls":3},{"$f":"N54*N56","v":0},{"$nulls":3},{"$f":"R54*R56","v":0},{"$nulls":3},{"$f":"V54*V56","v":0},{"$nulls":3},{"$f":"Z54*Z56","v":0},{"$nulls":3},{"$f":"AD54*AD56","v":0},{"$nulls":3},{"$f":"AH54*AH56","v":0},{"$nulls":3},{"$f":"AL54*AL56","v":0},{"$nulls":3},{"$f":"AP54*AP56","v":0},{"$nulls":3},{"$f":"AT54*AT56","v":0},{"$nulls":3},{"$f":"SUM(F57+J57+N57+R57+V57+AD57+AH57+Z57+AL57+AP57+AT57)","v":0}]
["Average Sale","enter data",{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},{"$f":"IF(AX57<0.000001,\"-\",AX60/AX57)","v":"-"}]
["ROI","calculated",{"$nulls":3},{"$f":"IF(F48<0.00000001,\"-\",F60/(F48))","v":"-"},"to 1",null,null,{"$f":"IF(J48<0.00000001,\"-\",J60/(J48))","v":"-"},"to 1",null,null,{"$f":"IF(N48<0.00000001,\"-\",N60/(N48))","v":"-"},"to 1",null,null,{"$f":"IF(R48<0.00000001,\"-\",R60/(R48))","v":"-"},"to 1",null,null,{"$f":"IF(V48<0.00000001,\"-\",V60/(V48))","v":"-"},"to 1",null,null,{"$f":"IF(Z48<0.00000001,\"-\",Z60/(Z48))","v":"-"},"to 1",null,null,{"$f":"IF(AD48<0.00000001,\"-\",AD60/(AD48))","v":"-"},"to 1",null,null,{"$f":"IF(AH48<0.00000001,\"-\",AH60/(AH48))","v":"-"},"to 1",null,null,{"$f":"IF(AL48<0.00000001,\"-\",AL60/(AL48))","v":"-"},"to 1",null,null,{"$f":"IF(AP48<0.00000001,\"-\",AP60/(AP48))","v":"-"},"to 1",null,null,{"$f":"IF(AT48<0.00000001,\"-\",AT60/(AT48))","v":"-"},"to 1",null,null,{"$f":"IF(AX48<0.00000001,\"-\",AX60/(AX48))","v":"-"},"to 1"]
["Estimated Sales","calculated",{"$nulls":3},{"$f":"F57*F58","v":0},{"$nulls":3},{"$f":"J57*J58","v":0},{"$nulls":3},{"$f":"N57*N58","v":0},{"$nulls":3},{"$f":"R57*R58","v":0},{"$nulls":3},{"$f":"V57*V58","v":0},{"$nulls":3},{"$f":"Z57*Z58","v":0},{"$nulls":3},{"$f":"AD57*AD58","v":0},{"$nulls":3},{"$f":"AH57*AH58","v":0},{"$nulls":3},{"$f":"AL57*AL58","v":0},{"$nulls":3},{"$f":"AP57*AP58","v":0},{"$nulls":3},{"$f":"AT57*AT58","v":0},{"$nulls":3},{"$f":"SUM(F60+J60+N60+R60+V60+AD60+AH60+Z60+AL60+AP60+AT60)","v":{"v":0,"d":"$0"}}]
["% of all Trade Show Generated Sales","calculated",{"$nulls":3},{"$f":"IF($AX$60<0.0001,\"-\",F60/$AX$60)","v":"-"},{"$nulls":3},{"$f":"IF($AX$60<0.0001,\"-\",J60/$AX$60)","v":"-"},{"$nulls":3},{"$f":"IF($AX$60<0.0001,\"-\",N60/$AX$60)","v":"-"},{"$nulls":3},{"$f":"IF($AX$60<0.0001,\"-\",R60/$AX$60)","v":"-"},{"$nulls":3},{"$f":"IF($AX$60<0.0001,\"-\",V60/$AX$60)","v":"-"},{"$nulls":3},{"$f":"IF($AX$60<0.0001,\"-\",Z60/$AX$60)","v":"-"},{"$nulls":3},{"$f":"IF($AX$60<0.0001,\"-\",AD60/$AX$60)","v":"-"},{"$nulls":3},{"$f":"IF($AX$60<0.0001,\"-\",AH60/$AX$60)","v":"-"},{"$nulls":3},{"$f":"IF($AX$60<0.0001,\"-\",AL60/$AX$60)","v":"-"},{"$nulls":3},{"$f":"IF($AX$60<0.0001,\"-\",AP60/$AX$60)","v":"-"},{"$nulls":3},{"$f":"IF($AX$60<0.0001,\"-\",AT60/$AX$60)","v":"-"},{"$nulls":3},{"$f":"IF(AX60<0.0000000001,\"-\",AX60/$AX$60)","v":"-"}]
[]
["Enter Data in the following 5 lines if you know each show's sales, but not closure rate"]
["Leads","enter data",{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},{"$f":"SUM(F64+J64+N64+R64+V64+AD64+AH64+Z64+AL64+AP64+AT64)","v":0}]
["Cost per lead","calculated",{"$nulls":3},{"$f":"IF(F64<0.00001,\"-\",F48/F64)","v":"-"},{"$nulls":3},{"$f":"IF(J64<0.00001,\"-\",J48/J64)","v":"-"},{"$nulls":3},{"$f":"IF(N64<0.00001,\"-\",N48/N64)","v":"-"},{"$nulls":3},{"$f":"IF(R64<0.00001,\"-\",R48/R64)","v":"-"},{"$nulls":3},{"$f":"IF(V64<0.00001,\"-\",V48/V64)","v":"-"},{"$nulls":3},{"$f":"IF(Z64<0.00001,\"-\",Z48/Z64)","v":"-"},{"$nulls":3},{"$f":"IF(AD64<0.00001,\"-\",AD48/AD64)","v":"-"},{"$nulls":3},{"$f":"IF(AH64<0.00001,\"-\",AH48/AH64)","v":"-"},{"$nulls":3},{"$f":"IF(AL64<0.00001,\"-\",AL48/AL64)","v":"-"},{"$nulls":3},{"$f":"IF(AP64<0.00001,\"-\",AP48/AP64)","v":"-"},{"$nulls":3},{"$f":"IF(AT64<0.00001,\"-\",AT48/AT64)","v":"-"},{"$nulls":3},{"$f":"IF(AX64<0.0000001,\"-\",AX48/AX64)","v":"-"}]
["Known Show Sales","enter data",{"$nulls":3},{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"},{"$nulls":3},{"v":0,"d":"$0"},{"$nulls":3},{"$f":"SUM(F66+J66+N66+R66+V66+AD66+AH66+Z66+AL66+AP66+AT66)","v":{"v":0,"d":"$0"}}]
["ROI","calculated",{"$nulls":3},{"$f":"IF(F48<0.0000001,\"-\",F66/(F48))","v":"-"},"to 1",null,null,{"$f":"IF(J48<0.0000001,\"-\",J66/(J48))","v":"-"},"to 1",null,null,{"$f":"IF(N48<0.0000001,\"-\",N66/(N48))","v":"-"},"to 1",null,null,{"$f":"IF(R48<0.0000001,\"-\",R66/(R48))","v":"-"},"to 1",null,null,{"$f":"IF(V48<0.0000001,\"-\",V66/(V48))","v":"-"},"to 1",null,null,{"$f":"IF(Z48<0.0000001,\"-\",Z66/(Z48))","v":"-"},"to 1",null,null,{"$f":"IF(AD48<0.0000001,\"-\",AD66/(AD48))","v":"-"},"to 1",null,null,{"$f":"IF(AH48<0.0000001,\"-\",AH66/(AH48))","v":"-"},"to 1",null,null,{"$f":"IF(AL48<0.0000001,\"-\",AL66/(AL48))","v":"-"},"to 1",null,null,{"$f":"IF(AP48<0.0000001,\"-\",AP66/(AP48))","v":"-"},"to 1",null,null,{"$f":"IF(AT48<0.0000001,\"-\",AT66/(AT48))","v":"-"},"to 1",null,null,{"$f":"IF(AX48<0.000000001,\"-\",AX66/(AX48))","v":"-"},"to 1"]
["% of all Trade Show Generated Sales","calculated",{"$nulls":3},{"$f":"IF($AX$66<0.0000001,\"-\",F66/$AX$66)","v":"-"},{"$nulls":3},{"$f":"IF($AX$66<0.0000001,\"-\",J66/$AX$66)","v":"-"},{"$nulls":3},{"$f":"IF($AX$66<0.0000001,\"-\",N66/$AX$66)","v":"-"},{"$nulls":3},{"$f":"IF($AX$66<0.0000001,\"-\",R66/$AX$66)","v":"-"},{"$nulls":3},{"$f":"IF($AX$66<0.0000001,\"-\",V66/$AX$66)","v":"-"},{"$nulls":3},{"$f":"IF($AX$66<0.0000001,\"-\",Z66/$AX$66)","v":"-"},{"$nulls":3},{"$f":"IF($AX$66<0.0000001,\"-\",AD66/$AX$66)","v":"-"},{"$nulls":3},{"$f":"IF($AX$66<0.0000001,\"-\",AH66/$AX$66)","v":"-"},{"$nulls":3},{"$f":"IF($AX$66<0.0000001,\"-\",AL66/$AX$66)","v":"-"},{"$nulls":3},{"$f":"IF($AX$66<0.0000001,\"-\",AP66/$AX$66)","v":"-"},{"$nulls":3},{"$f":"IF($AX$66<0.0000001,\"-\",AT66/$AX$66)","v":"-"},{"$nulls":3},{"$f":"IF($AX$66<0.000000001,\"-\",AX66/$AX$66)","v":"-"}]
[]
[]
["Trade Show Budget Spreadsheet "]
["provided by Skyline Exhibits."]