Formatting Instructions
Synthetic Bundles
Format of Data
All data should be submitted in a .csv (comma-delimited) format.  The sheets in the workbook provide a template for 
how the tables should be designed.
The required format for the entries in each column/field is indicated in the instructions for each sheet.  
Column entries in bold red indicate that the party should enter only one of the possible entries listed for that column.  
No other entries should be entered.
Data for all of the tables should be submitted on a periodic basis as specified in the instructions in individual tables.
Partners-Instructions
Synthetic Bundles
"Partnership Agreements" Table
For every firm that the Company has partnered with to offer Synthetic Bundles, including MVPD Service provided by the partner and Internet Access Service provided by the 
Company, by month from January 2012 to June 2014, provide the data in the table below.  Note, each new date, tech and residential code should be a new row of data.
In general, this table is intended to provide data on the number of subscriber, ARPU and churn data for Sythetic Bundles, separately by acquiring partner.
Column Variable Name Format Possible Entries/Example Entries Description
A date Text - YYYY_MM 2012_01 to 2014_06 The date for which the data is being collected
B tech Integer 1, 2, 3, 4, 5, 6 Technology code for which the row of data corresponds (see Tech Table for the 6 
technology types)
C residential Integer 1, 0 Whether the row of data corresponds to (1) residential or (0) (non-residential)
D synth_subs Integer 1200 The total number of subscribers to the Synthetic Bundle at the end of the month
E synth_subs_company Integer 800 The total number of subscribers to the Synthetic Bundle at the end of the month who 
purchased the Synthetic Bundle directly from the Company
F synth_subs_partner Integer 400 The total number of subscribers to the Synthetic Bundle at the end of the month who 
purchased the Synthetic Bundle directly from the partner
G arpu_subs Integer 112 The average revenue per subscriber to the Company (net of any payments made to the 
partner) for all subscribers to the Synthetic Bundle at the end of the month
H arpu_subs_company Integer 106 The average revenue per subscriber to the Company (net of any payments made to the 
partner) for all subscribers to the Synthetic Bundle at the end of the month who 
purchased the Synthetic Bundle directly from the Company
I arpu_subs_partner Integer 115 The average revenue per subscriber to the Company (net of any payments made to the 
partner) for all subscribers to the Synthetic Bundle at the end of the month who 
purchased the Synthetic Bundle directly from the partner
J subs_new Integer 82 The number of subscribers beginning a subscription to the Synthetic Bundle during the 
month.
K subs_new_company Integer 40 The number of subscribers beginning a subscription to the Synthetic Bundle during the 
month who purchased the Synthetic Bundle directly from the Company.
L subs_new_partner Integer 42 The number of subscribers beginning a subscription to the Synthetic Bundle during the 
month who purchased the Synthetic Bundle directly from the partner.
M subs_lost Integer 15 The number of subscribers ending a subscription to the Synthetic Bundle during the 
month.
N subs_lost_company Integer 7 The number of subscribers ending a subscription to the Synthetic Bundle during the 
month who purchased the Synthetic Bundle directly from the Company.
O subs_lost_partner Integer 8 The number of subscribers ending a subscription to the Synthetic Bundle during the 
month who  purchased the Synthetic Bundle directly from the partner.
Notes by Column:
A, B, C: Any variation in Date, Tech, and Residential necessitates the creation of a new, unique record. 
Partners-Template
Synthetic Bundles
date tech residential synth_subs
synth_subs_
company
synth_subs_
partner arpu_subs
arpu_subs_
company
arpu_subs_
partner subs_new
subs_new_
company
subs_new_
partner subs_lost
subs_lost_
company
subs_lost
_partner
2014_06 1 1 1200 800 400 112 106 115 82 40 42 15 7 8
Tech Table
Synthetic Bundles
Technology of Transmission Codes for Deployment of Internet access services
Technology Code Description
1 Copper with no xDSL capability
2 xDSL
3 IPDSL
4 FTTN without capability to provide MVPD Service
5 FTTN with capability to provide MVPD Service
6 FTTP