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 shou 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 sh Data for all of the tables should be submitted on a periodic basis as specified in the instructions in individual tables. "Purchases of Transit Service" Table For each month from 01/01/2013 through 06/30/2014, provide data on purchases of Transit Service requested in the "Purchases of Transit Service" table. Data should be provided for all transit providers of the Company. In general, this table is intended to provide data on Transit Service that the Company purchases from other providers, separately by provider. Column Variable Name Format Possible Entries/ Example Entries Description A Date Text - YYYY_MM 2013_01 to 2014_06 The month for which the data is being collected. B Provider_Name Text ABC Technologies, Inc., Name of provider selling Transit Service to the Company C Provider_DBA_Name Text ABC, Other Name that provider uses when doing business with the Company D Capacity Float 500 mbps Total traffic volume capacity in megabits per second (mbps) that the Company can send/receive over provider's network. E Utilization_In Float 280 mbps The 95th percentile utilization in mbps for inbound traffic delivered via provider measured using the average bandwidth utilized during five minute sampling intervals. See note below. F Utilization_Out Float 120 mbps The 95th percentile utilization in mbps for outbound traffic delivered via provider measured using the average bandwidth utilized during five minute sampling intervals. See note below. G Total_Revenue Float $100,000 Total amount of money paid by the Company to provider during the month for Transit Service. H Non_Recurring_Revenue Float $20,000 Amount of money paid by the Company to provider for port installation and other charges which are not expected to be incurred on a regular basis in other months. I Recurring_Revenue Float $80,000 Amount of money other than non-recurring revenue that the Company paid provider during the month. If recurring revenue is contractually determined on an annual basis, divide annual recurring revenue by twelve. J Contract_Start Text - YYYY_MM 2010_04 Date when Transit Service arrangement commenced. K Contract_End Text - YYYY_MM 2018_07 Date when Transit Service arrangement is set to end; 9999 if not applicable. Notes by Column: A, B, C: Any variation in Date and Provider Name or DBA Name necessitates the creation of a new, unique record. G, H: Provide a complete explanation of the methodology used to calculate utilization. Date Provider_Name Provider_DBA_Name Capacity Utilization_ In Utilization_ Out Total_Revenue Non_Recurring_ Revenue Recurring_ Revenue Contract_ Start Contract_ End 2013_01 ABC Technologies, Inc. ABC 500 mbps 280 mbps 120 mbps $100,000 $20,000 $80,000 2010_04 2018_07 … … … … … … … … … … … "Sales of Paid Peering" Table For each month from 01/01/2013 through 06/30/2014, provide data on sales of Paid Peering requested in the "Sales of Paid Peering" table. Data should be provided for all Paid Peering customers of the Company. In general this table is intended to provide data on Paid Peering sold by the Company to various customers, separately for each customer. Column Variable Name Format Possible Entries/ Example Entries Description A Date Text - YYYY_MM 2013_01 to 2014_06 The month for which the data is being collected. B Customer_Name Text ABC Technologies, Inc., Other Name of customer obtaining Paid Peering offered by the Company C Customer_DBA_Name Text ABC, Other Name that customer uses when doing business with the Company D Capacity Float 400,000 mbps Total traffic volume capacity in megabits per second (mbps) that customer can send/receive over the Company's network. E Utilization_In Float 5,000 mbps The 95th percentile utilization in mbps for inbound traffic to the Company network measured using the average bandwidth utilized during five minute sampling intervals. See note below. F Utilization_Out Float 2,500 mbps The 95th percentile utilization in mbps for outbound traffic from the Company network measured using the average bandwidth utilized during five minute sampling intervals. See note below. G Total_Revenue Float $100,000 Amount of money paid by customer to the Company during the month for Paid Peering service. H Non_Recurring_Revenue Float $20,000 Amount of money paid by customer to the Company for port installation and other charges which are not expected to be incurred on a regular basis in other months. I Recurring_Revenue Float $80,000 Amount of money other than non-recurring revenue that customer paid the Company during the month. If recurring revenue is contractually determined on an annual basis, divide annual recurring revenue by twelve. J Contract_Start Text - YYYY_MM 2010_04 Date when Paid Peering arrangement commenced. K Contract_End Text - YYYY_MM 2018_07 Date when Paid Peering arrangement is set to end; 9999 if not applicable. Notes by Column: A, B, C: Any variation in Date and Customer Name or DBA Name necessitates the creation of a new, unique record. G, H: Provide a complete explanation of the methodology used to calculate utilization. Date Customer_Name Customer_DBA_Name Capacity Utilization_ In Utilization_ Out Total_Revenue Non_Recurring_ Revenue Recurring_ Revenue Contract_ Start Contract_ End 2013_01 ABC Technologies, Inc. ABC 400,000 mbps 5,000 mbps 2,500 mbps $100,000 $20,000 $80,000 2010_04 2018_07 … … … … … … … … … … … "Settlement-Free Peering Traffic" Table For each month from 01/01/2013 through 06/30/2014, provide traffic and utilization data requested in the "Settlement-Free Peering Traffic" table. Data should be provided for every Settlement-Free Peer of the Company. In general, this table is intended to provide data on traffic and utilization by Settlement-Free Peers. Column Variable Name Format Possible Entries/ Example Entries Description A Date Text - YYYY_MM 2009_01 to 2014_06 The month for which the data is being collected. B Peer_Name Text ABC Technologies, Inc., Other Name of Settlement-Free Peer C Peer_DBA_Name Text ABC, Other Name that peer uses when doing business with the Company D Peer_Capacity Float 400,000 mbps Total traffic volume capacity in megabits per second (mbps) that the Company can send/receive over peer's network without incurring penalty fees. E Company_Capacity Float 400,000 mbps Total traffic volume capacity in megabits per second (mbps) that peer can send/receive over the Company network without incurring penalty fees. F Utilization_In Float 5,000 mbps The 95th percentile utilization in mbps for inbound traffic to the Company network measured using the average bandwidth utilized during five minute sampling intervals. See note below. G Utilization_Out Float 2,500 mbps The 95the percentile utilization in mbps for outbound traffic from the Company network measured using the average bandwidth utilized during five minute sampling intervals. See note below. H Peer_Penalty_Fees_Paid Float $2,000 Amount of money paid by peer to the Company for penalties or fees incurred during the month. I Company_Penalty_Fees_Paid Float $2,000 Amount of money paid by the Company to peer for penalties or fees incurred during the month. J Contract_Start Text - YYYY_MM 2010_04 Date when Settlement-Free Peering arrangement commenced. 9999 if non-contract. K Contract_End Text - YYYY_MM 2018_07 Date when Settlement-Free Peering is set to end; 9999 if not applicable. Notes by Column: A, B: Any variation in Date and Peer Name necessitates the creation of a new, unique record. H, I: Provide a complete explanation of the methodology used to calculate utilization. Date Peer_Name Peer_DBA_Name Peer_Capacity Company_Capacity Utilization_ In Utilization_ Out Peer_Penalty_ Fees_Paid Company_Penalty_ Fees_Paid Contract_ Start Contract_ End 2013_01 ABC Technologies, Inc. ABC 400,000 mbps 400,000 mbps 5,000 mbps 2,500 mbps $2,000 $2,000 2010_04 2018_07 … … … … … … … … … … …