1 of 3 Attachment D 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 Format 2174 Total number of transactions for transactional VOD service in this zip code in the month Text - YYYY_MM 2012_06 to 2015_08 The month and year for which the data is being provided Possible Entries/ Example Entries Column Description A date "Video-On-Demand Data" Table 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. Total revenue accruing to the Company from transactional VOD service in this zip code in the month Number of subscribers in this zip code who upgraded to Subscription VOD (SVOD) service in the month12Integersvod_upgradesN Integer A disconnect in a given month is a subscriber who was subscribed to a Company Cable Service at the end of the previous month who is no longer subscribed to any Company Cable Services at the end of the current month. C vod_transaction_once Integer Total number of hours viewed under a transactional VOD service in this zip code in the month1000Integervod_transaction_hoursE Five-digit zip code (with leading zeros). (Use code 00000 for the Company as a whole) Variable Name For each month beginning June 2012 and extending through August 2015, please provide the Video-On-Demand service data by zip code requested in the table below. A connect in a given month is a subscriber who was not subscribed to any of the Company's Cable Services at the end of the previous month who is subscribed to a Company Cable Service at the end of the current month. 1432.33 I 225 Total number of users who used a transactional VOD service at least once in this zip code during the month Total number of users who used a free VOD service at least once in this zip code in the month F H vod_free_total Integer 133015 Total number of free VOD transactions in this zip code in the month J ppv_once vod_transaction_revenue Float 1432.33 G vod_free_once Integer 11015 B zip Text 20427 Total revenue accruing to the Company from a PPV service in this zip code in the month Total number of users who used a PPV service at least once in this zip code in the month L ppv_hours Integer 1000 Total number of hours viewed on a PPV service in this zip code in the month D vod_transaction_total Integer 225 M ppv_revenue Float Total number of hours viewed on a free VOD service in this zip code in the month K ppv_total Integer 625 Total number of PPV transactions in this zip code in the month vod_free_hours Integer 240011 2 of 3 For each month beginning June 2012 and extending through August 2015, please provide the Video-On-Demand service data by zip code requested in the table below. "Video-On-Demand Data" Table O svod_subs_connects Integer Total revenue accruing to the Company from SVOD service in this zip code in the monthS svod_revenue Float 3432.33 Column R svod_subs_disconnects Integer 10 Number of subscribers in this zip code with SVOD service at the beginning of the month that disconnected service with the Company during the month 12 10 Number of subscribers in this zip code that downgraded the SVOD service at the same time that they cancelled MVPD service from the Company in the month Q svod_subs_downgrades Integer Variable Name Format Possible Entries/ Example Entries Description Number of new connects (subscribers) in this zip code that added the SVOD service at the same time that they added MVPD service from the Company in the month 3 of 3 Attachment D: Template for "Video-On-Demand Data" Table Notes: Columns A through S define unique records in this data. date zip vod_transaction_once vod_transaction_total vod_transaction_hours vod_transaction_revenue vod_free_once vod_free_total vod_free_hours ppv_once ppv_total ppv_hours ppv_revenue svod_upgrades svod_subs_connects svod_downgrades svod_subs_downgrades svod_subs_disconnects svod_revenue 2012_06 20427 225 2174 1000 1432.33 11015 133015 240011 225.00 625 1000 1432.33 12 12 10 10 10 3432.33 VOD Data Template For each month beginning June 2012 and extending through August 2015, please provide data by zip code requested in the table below.