Page 1 of 8 Attachment B Data Formatting 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. Data for all of the tables should be submitted on a periodic basis as specified in the instructions in individual tables. Formatting Instructions D plan_name Text HD Preferred, Basic Video with Standard Internet The service plan name associated with the Plan ID E internet Integer 0, 1 Whether the plan includes Internet Access Service (1) or not (0) B zip Text 20427 Five-digit zip code (with leading zeros) for the service plan C plan_id Text 6478931A A unique internal system service plan identifier for each plan "Service Plan Data" Table For each month beginning June 2012 and extending through August 2015, please provide the plan level subscriber data by zip code requested in the table below. Column Variable Name Format Possible Entries/ Example Entries Description A date Text - YYYY_MM 2012_06 to 2015_08 The month and year for which the data is being collected Float 3 The advertised downstream speed of the service plan in Mbps (-1 if no Internet Access Service; -2 if unknown) H up_speed Float 1.5 The advertised upstream speed of the service plan in Mbps (-1 if no Internet Access Service, -2 if unknown) G down_speed 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 Company should enter only one of the possible entries listed for that column. No other entries should be entered. F internet_tier Text Standard Internet The internet tier name associated with this service plan (-1 if no Internet Access Service, -2 if unknown) Page 2 of 8 AD sidegrade_phone_up Integer 4 Number of subscribers in this zip code who had this service plan at the end of the previous month who subscribed to a higher Telephone Service tier at the end of the month (-1 not applicable to this service plan) AE sidegrade_video_down Integer 2 Number of subscribers in this zip code who had this service plan at the end of the previous month who subscribed to a lower MVPD Service tier at the end of the month (-1 not applicable to this service plan) AB sidegrade_video_up Integer 3 Number of subscribers in this zip code who had this service plan at the end of the previous month who subscribed to a higher MVPD Service tier at the end of the month (-1 not applicable to this service plan) AC sidegrade_internet_up Integer 6 Number of subscribers in this zip code who had this service plan at the end of the previous month who subscribed to a higher Internet Access Service tier at the end of the month (-1 not applicable to this service plan) Z upgrade_internet Integer 16 Number of subscribers in this zip code who had this service plan at the end of the previous month who had added the Company's Internet Access Service at the end of the month (-1 not applicable to this service plan) AA upgraded_phone Integer 19 Number of subscribers in this zip code who had this service plan at the end of the previous month who had added the Company's Telephone Service at the end of the month (-1 not applicable to this service plan) X downgrade_phone Integer 15 Number of subscribers in this zip code who had this service plan at the end of the previous month who no longer subscribe to the Company's Telephone Service at the end of the month (-1 not applicable to this service plan) Y upgrade_video Integer 11 Number of subscribers in this zip code who had this service plan at the end of the previous month who had added the Company's MVPD Service at the end of the month (-1 not applicable to this service plan) V downgrade_video Integer 88 Number of subscribers in this zip code who had this service plan at the end of the previous month who no longer subscribe to the Company's MVPD Service at the end of the month (-1 not applicable to this service plan) W downgrade_internet Integer 96 Number of subscribers in this zip code who had this service plan at the end of the previous month who no longer subscribe to the Company's Internet Access Service at the end of the month (-1 not applicable to this service plan) O subs_1month M plan_offered Integer 0, 1 Whether the service plan is still currently offered as of August 2015 (1) or not (0) N subs Integer 568 Total number of subscribers to the service plan in this zip code at the end of the month S subs_promo Integer I mvpd Integer 0, 1 Whether the service plan includes MVPD Service (1) or not (0) DescriptionPossible Entries/ Example Entries 277 Number of subscribers to this service plan at the end of the month in this zip code who were receiving a promotional rate FormatVariable NameColumn J video_tier Text Expanded Basic The video tier name associated with this service plan (-1 if no video service, -2 if unknown) K lineup_id Integer 26 The channel lineup identifier for this zip code (-1 if no MVPD Service) L voice Integer 0, 1 Whether the service plan includes Telephone Services (1) or not (0) Number of subscribers in this zip code who have subscribed to the service plan for 1 month or less at the end of the month P subs_12months Integer 151 Number of subscribers in this zip code who have subscribed to the service plan for 12 months or fewer at the end of the month Q subs_12_24months Integer 140 Number of subscribers in this zip code who have subscribed to the service plan for more than 12 months, and for 24 months or fewer at the end of the month Integer 18 U connects Integer 100 Number of subscribers to this service plan in the zip code at the end of the month who had not subscribed to any Company Cable Services at the end of the previous month "Service Plan Data" Table For each month beginning June 2012 and extending through August 2015, please provide the plan level subscriber data by zip code requested in the table below. R subs_24months Integer 277 Number of subscribers in this zip code who have subscribed to the service plan for more than 24 months at the end of the month T subs_nopromo Integer 277 Number of subscribers to this service plan at the end of the month in this zip code who were not receiving a promotional rate Page 3 of 8 "Service Plan Data" Table For each month beginning June 2012 and extending through August 2015, please provide this service plan level subscriber data by zip code requested in the table below. Column Variable Name Format Possible Entries/ Example Entries Description AF sidegrade_internet_down Integer 4 Number of subscribers in this zip code who had this service plan at the end of the previous month who subscribed to a lower Internet Access Service tier at the end of the month (-1 not applicable to this service plan) AG sidegrade_phone_down Integer 8 Number of subscribers in this zip code who had this service plan at the end of the previous month who subscribed to a lower Telephone Service tier at the end of the month (-1 not applicable to this service plan) AR mrr Float 90.35 Average monthly recurring revenue of subscribers to this service plan in this zip code and month Float 78.05 Average monthly recurring revenue of subscribers to this service plan in this zip code and month who have been with the Company for 1 month or less mrr_12_24months Float 95.49 Average monthly recurring revenue of subscribers to this service plan in this zip code and month who have been with the Company for more than 12 months and less than or equal to 24 months AT mrr_12months 81.82 Average monthly recurring revenue of subscribers to this service plan in this zip code and month who have been with the Company for 12 months or less Float AU 10 Number of subscribers in this zip code who had this service plan and were with the Company more than 24 months at the end of the previous month who no longer subscribe to any of the Company's Cable Services at the end of the month AV mrr_24months Float 129.25 Average monthly recurring revenue of subscribers to this service plan in this zip code and month who have been with the Company for more than 24 months AS mrr_1month AH disconnects Integer 100 Number of subscribers in this zip code who had this service plan at the end of the previous month who no longer subscribe to any of the Company's Cable Services at the end of the month AI disconnects_1month Integer 20 Number of subscribers in this zip code who had this service plan and were with the Company for one month or less at the end of the previous month who no longer subscribe to any of the Company's Cable Services at the end of the month AJ disconnects_12months Integer 30 Number of subscribers in this zip code who had this service plan and were with the Company for 12 months or fewer at the end of the previous month who no longer subscribe to any of the Company's Cable Services at the end of the month AK disconnects_12_24months Integer 40 Number of subscribers in this zip code who had this service plan and were with the Company for more than 12 months and less than or equal to 24 months at the end of the previous month who no longer subscribe to any of the Company's Cable Services at the end of the month AL disconnects_24months Integer AM disconnects_vol Integer 100 Number of subscribers in this zip code who had this service plan at the end of the previous month who no longer subscribe to any of the Company's Cable Services at the end of the month for voluntary reasons AN disconnects_vol_1month Integer 20 Number of subscribers in this zip code who had this service plan and were with the Company for one month or less at the end of the previous month who no longer subscribe to any of the Company's Cable Services at the end of the month for voluntary reasons AO disconnects_vol_12months Integer 30 Number of subscribers in this zip code who had this service plan and were with the Company for 12 months or less at the end of the previous month, who no longer subscribe to any of the Company's Cable Services at the end of the month for voluntary reasons AP disconnects_vol_12_24months Integer 40 Number of subscribers in this zip code who had this service plan and were with the Company for more than 12 months and less than or equal to 24 months at the end of the previous month, who no longer subscribe to any of the Company's Cable Services at the end of the month for voluntary reasons AQ disconnects_vol_24months Integer 10 Number of subscribers in this zip code who had this service plan and were with the Company more than 24 months at the end of the previous month, who no longer subscribe to any of the Company's Cable Services at the end of the current month for voluntary reasons Page 4 of 8 BF mrr_core_24months Float 129.25 The average monthly recurring core service plan revenues of subscribers to this service plan in this zip code and month who have been with the Company for more than 24 months The average monthly recurring core service plan revenues of subscribers to this service plan in this zip code and month who have been with the Company for 1 month or less BD mrr_core_12months Float 81.82 The average monthly recurring core service plan revenues of subscribers to this service plan in this zip code and month who have been with the Company for 12 months or fewer BE mrr_core_12_24months Float 95.49 The average monthly recurring core service plan revenues of subscribers to this service plan in this zip code and month who have been with the Company for more than 12 months and fewer than or equal to 24 months BN arpu_video Float 46.02 The average monthly recurring and non-recurring MVPD Service revenue per subscriber to this service plan in this zip code and month (-1 if no MVPD Service) BI arpu Float 90.35 The average monthly recurring and non-recurring revenue per subscriber to this service plan in this zip code and month Float 81.82 The average monthly recurring and non-recurring revenue per subscriber to this service plan in this zip code and month who have been with the Company for 12 months or less BL arpu_12_24months Float 95.49 The average monthly recurring and non-recurring revenue per subscriber to this service plan in this zip code and month who have been with the Company for more than 12 months and less than or equal to 24 months BM arpu_24months Float 129.25 The average monthly recurring and non-recurring revenue per subscriber to this service plan in this zip code and month who have been with the Company for more than 24 months AZ The average monthly recurring revenue for subscribers of this service plan receiving a promotional rate in this zip code and month Average monthly recurring Telephone Service revenues of subscribers to this service plan in this zip code and month (-1 if no Telephone Service) AW Possible Entries/ Example Entries Description BB mrr_promo mrr_core Float 78.36 The average monthly recurring core service plan revenues for subscribers to this service plan in this zip code and month. This measure should exclude recurring service revenues not generated by a MVPD, Internet Access or Telephone Service order code (e.g. equipment fees, premium channels and other service plan add-ons) BG mrr_core_promo Float 78.36 The average monthly recurring core service plan revenues for subscribers to this service plan in this zip code and month receiving a promotional rate "Service Plan Data" Table For each month beginning June 2012 and extending through August 2015, please provide this service plan level subscriber data by zip code requested in the table below. Column Variable Name Format AY mrr_phone Float 21.70 Float 78.36 BC mrr_core_1month Float 78.05 Float 78.05 The average monthly recurring and non-recurring revenue per subscriber to this service plan in this zip code and month who have been with the Company for 1 month or less BK arpu_12months mrr_data Float 22.63 Average monthly recurring Internet Access Service revenues of subscribers to this service plan in this zip code and month (-1 if no Internet Access Service) mrr_video Float 46.02 Average monthly recurring video MVPD Service revenues of subscribers to this service plan in this zip code and month. (-1 if no MVPD Service) AX BH mrr_core_nopromo Float 78.36 BA mrr_nopromo Float 78.36 The average monthly recurring revenue for subscribers of this service plan not receiving a promotional rate in this zip code and month The average monthly recurring core service plan revenues for subscribers to this service plan in this zip code and month not receiving a promotional rate BJ arpu_1month Page 5 of 8 "Service Plan Data" Table For each month beginning June 2012 and extending through August 2015, please provide this service plan level subscriber data by zip code requested in the table below. Total number of PPV and VOD revenue generating units of subscribers to this service plan in the zip code and month (-1 if no MVPD Service) CB onetime_subs Integer 25 Number of subscribers of this service plan in the zip code and month receiving a one-time payment from the Company (excluding billing corrections) BW other_mrr Float 25.93 All other monthly recurring revenues from subscribers of this service plan in the zip code and month that are not associated with core Cable Services service codes, premium channels, modem rentals and set-top box rentals (e.g. HD fees, RSN fees etc.) 15.23 Total cost of all one-time subscriber acquisition and retention payments (excluding billing corrections) made to subscribers of this service plan in the zip code and month (e.g. gift cards, retention payments, rebates and contract buyouts) BO arpu_data Float BT modem_units Float 10.10 Total termination or cancellation fees that would be imposed on subscribers subject to such fees if they were to disconnect all of the Company's Cable Services, downgrade a Cable Service or move to a lower Cable Service tier in the month BY ppv_vod_units Integer 100 CA onetime_payment_cost Float Integer 100 22.63 BS modem_revenues Float 25.93 BQ BU settopbox_revenue Float 7.99 Total recurring MVPD Service set-top box revnues generated by subscribers of this service plan in the zip code and month (-1 if no MVPD Service) premium_revenues The average monthly recurring and non-recurring Internet Service revenue per subscriber to this service plan in this zip code and month (-1 if no Internet Access Service) Total recurring Internet Access Service modem revenues generated by subscribers of this service plan in the zip code and month (-1 if no Internet Access Service) Column Variable Name Format Possible Entries/ Example Entries Description Float 25.93 Total premium channel recurring revenues generated by subscribers of this service plan in the zip code and month (-1 if no MVPD Service) CD terminationfee_potentialsubs Integer 81 Number of subscribers to this service plan in this zip code and month potentially subject to termination fees CC terminationfee_potential BP arpu_phone Float 21.70 The average total monthly recurring and non-recurring Telephone Service revenue per subscriber to this service plan in this zip code and month (-1 if no Telephone Service) BR premium_units Integer 100 Total number of revenue generating premium channel units incurring a recurring charge to subscribers of this service plan in the zip code and month (-1 if no MVPD Service) BX ppv_vod_revenues Float 25.93 Total PPV and VOD revenues generated by subscribers of this service plan in the zip code and month (-1 if no MVPD Service) CF terminationfee_subs Integer 81 Number of subscribers to this service plan in this zip code and month that paid a termination fee in the month BZ other_nrr Float 25.93 All other monthly non-recurring revenues from subscribers of this service plan in the zip code and month other than VOD and PPV (e.g. late fees, installation and maintenance fees etc.) CE terminationfee_revenues Float 10.10 Total termination or cancellation fee revenues paid by subcribers of this service plan in the zip code and month due to disconnecting all Cable Services with the Company, downgrading a Cable Service or moving to a lower Cable Service tier in the month Total number of revenue generating modem units incurring a recurring charge to subscribers of this service plan in the zip code and month (-1 if no Internet Access Service) BV settopbox_units Integer 100 Total number of revenue generating set-top box units incurring a recurring charge to subscribers of this service plan in the zip code and month (-1 if no MVPD Service) Page 6 of 8 "Service Plan Data" Table For each month beginning June 2012 and extending through August 2015, please provide this service plan level subscriber data by zip code requested in the table below. Column Variable Name Format Possible Entries/ Example Entries Description Median amount of data (in Gigabytes) used by subscribers on this service plan in this zip code in the month (-1 if no Internet Access Service) CM usage_bin5 Float 5.1 Percentage of subscribers on this service plan who used 300 or more Gigabytes of data in the month (-1 if no Internet Access Service) CG average_usage Integer 250 Average amount of data (in Gigabytes) used by subscribers on this service plan in the zip code in the month (-1 if no Internet Access Service) CH median_usage Integer 250 CI usage_bin1 Float 60.3 Percentage of subscribers on this service plan who used less than 50 Gigabytes of data in the month (-1 if no Internet Access Service) CJ usage_bin2 Float 10.7 Percentage of subscribers on this service plan who used at least 50 Gigabytes, but less than 100 Gigabytes, of data in the month (-1 if no Internet Access Service) CK usage_bin3 Float 12.1 Percentage of subscribers on this service plan who used at least 100 Gigabytes, but less than 200 Gigabytes, of data in the month (-1 if no Internet Access Service) CL usage_bin4 Float 11.8 Percentage of subscribers on this service plan who used at least 200 Gigabytes, but less than 300 Gigabytes, of data in the month (-1 if no Internet Access Service) Page 7 of 8 Attachment B: Template for "Service Plan Data" Table For each month beginning June 2012 and extending through August 2015, please provide the plan level subscriber data by zip code requested in the table below. Notes: Columns A through M define unique records in this data. date zip plan_id plan_name internet internet_tier down_spee d up_speed mvpd video_tier lineup_id voice plan_offered subs subs_1month subs_12months subs_12_24months subs_24months subs_promo subs_nopromo connects downgrade_video downgrade_internet downgrade_phone upgrade_video upgrade_intern upgraded_phone sidegrade_video_up sidegrade_internet_up sidegrade_phone_up sidegrade_video_down sidegrade_internet_down sidegrade_phone_down disconnects disconnects_1month disconnects_12months disconnects_12_24months disconnects_24months disconnects_vol disconnects_vol_1month disconnects_vol_12months disconnects_vol_12_24months disconnects_vol_24months mrr mrr_1month mrr_12months mrr_12_24months mrr_24months mrr_video mrr_data mrr_phone mrr_promo mrr_nopromo mrr_core mrr_core_1month mrr_core_12months mrr_core_12_24months mrr_core_24months mrr_core_promo mrr_core_nopromo arpu arpu_1month arpu_12months arpu_12_24months arpu_24months arpu_video arpu_data arpu_phone premium_revenues premium_units modem_revenues modem_units settopbox_revenue settopbox_units other_mrr ppv_vod_revenues ppv_vod_units other_nrr onetime_payment_cost onetime_subs terminationfee_potential terminationfee_potentialsubs 2012_06 20427 6478931A HD Preferred, Basic Video with Standard 1 Standard Internet 3 1.5 0, 1 Expanded Basic 26 1 1 568 18 151 140 277 277 277 100 88 96 15 11 16 19 3 6 4 2 4 8 100 20 30 40 10 100 20 30 40 10 90.35 78.05 81.82 95.49 129.25 46.02 22.63 21.7 78.36 78.36 78.36 78.05 81.82 95.49 129.25 78.36 78.36 90.35 78.05 81.82 95.49 129.25 46.02 22.63 21.7 25.93 100 25.93 100 7.99 100 25.93 25.93 100 25.93 15.23 25 10.1 81 ` Service Plan Data Template Page 8 of 8 Attachment B: Template for "Service Plan Data" Table terminationfee_revenues terminationfee_subs average_usage median_usage usage_bin1 usage_bin2 usage_bin3 usage_bin4 usage_bin5 10.1 81 250 250 60.3 10.7 12.1 11.8 5.1 Service Plan Data Template