{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["SCORECARD","LISTS"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"SCORECARD","index":0,"n_rows":85,"n_cols":9,"rows_kept":85,"merged":[[8,2,8,5],[9,2,9,5],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,2,13,5],[14,2,14,5],[15,2,15,5],[19,1,19,8],[32,1,32,8],[41,1,41,8],[49,1,49,8],[57,1,57,8],[65,1,65,8],[74,1,74,8]]}
[]
[null,"[Company Name]"]
[null,"Channel Partner Scorecard"]
[null,"[Date]"]
[null,"[Time period]"]
[]
[null,"Gray cells will be calculated for you. You do not need to enter anything into them."]
[]
[null,"Channel Partner Profile"]
[null,"Partner name:"," "]
[null,"Corporate headquarter address:"," "]
[null,"Type of partner:"]
[null,"Number of years done business with:"," "]
[null,"Industry focus:"," "]
[null,"Is there a channel partner contract?"," "]
[null,"Key contract terms: "]
[]
[null,"Contact's Name","Title","Location","Phone Number","E-Mail","   ","    ","     "]
[null," "," "," "," "]
[null," "]
[]
[null,"Sales Forecast"]
[null,"Product Name","Product ID Number","Annual Forecast (units)","Annual Gross Revenue Forecast","Actual Unit Sales (to date)","Actual Gross Revenue (to date)","Unit Variance (to date)","Gross Revenue Variance (to date)"]
[{"$nulls":7},{"$f":"tblForecasts[Actual Unit Sales (to date)]-tblForecasts[Annual Forecast (units)]","v":{"v":0,"d":"0.00"}},{"$f":"tblForecasts[Actual Gross Revenue (to date)]-tblForecasts[Annual Gross Revenue Forecast]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":7},{"$f":"tblForecasts[Actual Unit Sales (to date)]-tblForecasts[Annual Forecast (units)]","v":{"v":0,"d":"0.00"}},{"$f":"tblForecasts[Actual Gross Revenue (to date)]-tblForecasts[Annual Gross Revenue Forecast]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":7},{"$f":"tblForecasts[Actual Unit Sales (to date)]-tblForecasts[Annual Forecast (units)]","v":{"v":0,"d":"0.00"}},{"$f":"tblForecasts[Actual Gross Revenue (to date)]-tblForecasts[Annual Gross Revenue Forecast]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":7},{"$f":"tblForecasts[Actual Unit Sales (to date)]-tblForecasts[Annual Forecast (units)]","v":{"v":0,"d":"0.00"}},{"$f":"tblForecasts[Actual Gross Revenue (to date)]-tblForecasts[Annual Gross Revenue Forecast]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":7},{"$f":"tblForecasts[Actual Unit Sales (to date)]-tblForecasts[Annual Forecast (units)]","v":{"v":0,"d":"0.00"}},{"$f":"tblForecasts[Actual Gross Revenue (to date)]-tblForecasts[Annual Gross Revenue Forecast]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":7},{"$f":"tblForecasts[Actual Unit Sales (to date)]-tblForecasts[Annual Forecast (units)]","v":{"v":0,"d":"0.00"}},{"$f":"tblForecasts[Actual Gross Revenue (to date)]-tblForecasts[Annual Gross Revenue Forecast]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":7},{"$f":"tblForecasts[Actual Unit Sales (to date)]-tblForecasts[Annual Forecast (units)]","v":{"v":0,"d":"0.00"}},{"$f":"tblForecasts[Actual Gross Revenue (to date)]-tblForecasts[Annual Gross Revenue Forecast]","v":{"v":0,"d":"$0.00"}}]
[null," "," ",{"$nulls":4},{"$f":"tblForecasts[Actual Unit Sales (to date)]-tblForecasts[Annual Forecast (units)]","v":{"v":0,"d":"0.00"}},{"$f":"tblForecasts[Actual Gross Revenue (to date)]-tblForecasts[Annual Gross Revenue Forecast]","v":{"v":0,"d":"$0.00"}}]
[null,"Total",null,{"$f":"SUBTOTAL(109,tblForecasts[Annual Forecast (units)])","v":0},{"$f":"SUBTOTAL(109,tblForecasts[Annual Gross Revenue Forecast])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblForecasts[Actual Unit Sales (to date)])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,tblForecasts[Actual Gross Revenue (to date)])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblForecasts[Unit Variance (to date)])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,tblForecasts[Gross Revenue Variance (to date)])","v":{"v":0,"d":"$0.00"}}]
[null," "]
[]
[null,"Marketing Campaigns"]
[null,"Campaign Name","Description","Objectives","Cost","Start Date","End Date","Achievement"," "]
[]
[]
[]
[null," "," "," "," "]
[null,"Total",null,null,{"$f":"SUBTOTAL(109,tblCampaigns[Cost])","v":{"v":0,"d":"$0.00"}}]
[]
[]
[null,"Market Development Funds","Notes","Amount"," ","  ","   ","    ","     "]
[null,"Beginning balance"]
[null,"+ or - adjustments"]
[null,"Subtotal",null,{"$f":"D45+D46","v":{"v":0,"d":"$0.00"}}]
[null,"Less funds used",null,{"$f":"tblCampaigns[[#Totals],[Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Current balance",null,{"$f":"D47-D48","v":{"v":0,"d":"$0.00"}}]
[]
[]
[null,"Marketing Materials","Notes","Amount"," ","  ","   ","    ","     "]
[]
[]
[]
[null," "]
[null,"Total",null,{"$f":"SUBTOTAL(109,tblMaterials[Amount])","v":{"v":0,"d":"$0.00"}}]
[null," "]
[]
[null,"Training","Notes","Amount"," ","  ","   ","    ","     "]
[]
[]
[]
[null," "]
[null,"Total",null,{"$f":"SUBTOTAL(109,tblTraining[Amount])","v":{"v":0,"d":"$0.00"}}]
[]
[]
[null,"Channel Service Issues—Description","Date of Issue","Status","Resolution Date","Costs (if any)"," ","  ","   "]
[]
[]
[]
[]
[]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,tblService[Costs (if any)])","v":{"v":0,"d":"$0.00"}}]
[]
[]
[null,"Return On Investment (ROI)","Notes","Amount"]
[null,"Actual Revenue",null,{"$f":"tblForecasts[[#Totals],[Actual Gross Revenue (to date)]]","v":{"v":0,"d":"$0.00"}}]
[null,"Less:"]
[null,"   Market development funds",null,{"$f":"D47","v":{"v":0,"d":"$0.00"}}]
[null,"   Marketing materials",null,{"$f":"tblMaterials[[#Totals],[Amount]]","v":{"v":0,"d":"$0.00"}}]
[null,"   Training",null,{"$f":"tblTraining[[#Totals],[Amount]]","v":{"v":0,"d":"$0.00"}}]
[null,"   Service costs",null,{"$f":"tblService[[#Totals],[Costs (if any)]]","v":{"v":0,"d":"$0.00"}}]
[null,"Total Costs",null,{"$f":"SUM(D80:D83)","v":{"v":0,"d":"$0.00"}}]
[null,"ROI",null,{"$f":"IFERROR((D78-D84)/D84,0)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"LISTS","index":1,"n_rows":8,"n_cols":4,"rows_kept":8}
[]
[null,"LISTS"]
[]
[null,"Partners",null,"Service Status"]
[null,"Reseller",null,"Not Started"]
[null,"Distributor",null,"In Process"]
[null,"System Integrator",null,"Resolved"]
[null,"Retailer",null,"Not Resolved"]