{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Information","Subscription Value Calculation","Adjustments","Cancel Adjustment","Premium Calculation","Average Price Calculation"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":15,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Information","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[24,7,25,8],[18,4,19,6],[18,7,19,9],[4,1,4,9],[13,2,13,9],[14,2,14,9],[22,7,23,8]]}
[{"$f":"HYPERLINK(SUBSTITUTE(INDEX(GetSheetNAme,MATCH(get,GetSheetNAme,0)+1)&\"'!A1\",\"]\",\"]'\"),\"Next Sheet….\")","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,"* * * ATTENTION * * *"]
[null,"This form must be signed and returned to AAM with filing materials"]
[]
[null,null,null,null,"***Required for publications reporting average price in paragragh 2 of publisher's statement***"]
[null,null,null,null,"**** Average price is calculated using only paid subscriptions.  Verified circulation is excluded from this calculation.****"]
[null,null,null,null,"AVERAGE PRICE "]
[null,null,null,null,"CALCULATION WORKSHEET"]
[null,null,null,null,"CONSUMER MAGAZINE"]
[]
[]
[null,"Publication Name:  "]
[null,"Member # :  "]
[]
[]
[]
[null,null,null,null,"6 Months Ended                        December 31, 2003"]
[]
[]
[]
[null,"Please enter the two 6-month periods which will be used in calculation."]
[null,null,null,null,null,null,"6 Mos(1)"]
[]
[null,null,null,null,null,null,"6 Mos(2)"]
[]
[140,null,null,null,null,null,null,{"$f":"HYPERLINK(SUBSTITUTE(INDEX(GetSheetNAme,MATCH(get,GetSheetNAme,0)+1)&\"'!A1\",\"]\",\"]'\"),\"Next Sheet….\")","v":{"$error":"#REF!"}}]
[788]

{"sheet":"Subscription Value Calculation","index":1,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[[22,5,23,5],[26,1,26,2]]}
[]
[]
[{"$f":"HYPERLINK(SUBSTITUTE(INDEX(GetSheetNAme,MATCH(get,GetSheetNAme,0)+1)&\"'!A1\",\"]\",\"]'\"),\"Next Sheet….\")","v":{"$error":"#REF!"}}]
[null,null,"Part 1 - SUBSCRIPTION VALUE CALCULATION"]
[]
[]
[]
["Step 1 - ...",null,"Total Subscription Value Summary"]
[null,null,"(Gross Sales Dollars)"]
[]
[]
["Identify production (subscription sales) for each publisher statement period."]
[]
[]
[]
["Identify the total dollar value of these sales (sum of amounts to be paid by individual purchases of the publication - not "]
["amount to be remitted by agents.)"]
[]
[]
[]
[]
[]
[null,null,null,"6 months ended","6 months ended","TOTAL (12 month period)"]
[null,null,null,{"$f":"_6mos1","v":"00:00:00"},{"$f":"_6mos2","v":"00:00:00"}]
[]
[]
["Line 1","Paid Subscription Sales (excluding verified, comps, analyzed non paid and non-qualified paid)",null,null,null,{"$f":"SUM(D27:E27)","v":0}]
["Line 2","Copies",null,null,null,{"$f":"SUM(D28:E28)","v":0}]
["Line 3","Dollar Value ($)",null,null,null,{"$f":"SUM(D29:E29)","v":0}]
[null,null,null,null,null,null,null," "]
[null,null,null,null,{"$f":"HYPERLINK(SUBSTITUTE(INDEX(GetSheetNAme,MATCH(get,GetSheetNAme,0)+1)&\"'!A1\",\"]\",\"]'\"),\"Next Sheet….\")","v":{"$error":"#REF!"}}]

{"sheet":"Adjustments","index":2,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[[49,1,49,3],[58,1,58,3]]}
[{"$f":"HYPERLINK(SUBSTITUTE(INDEX(GetSheetNAme,MATCH(get,GetSheetNAme,0)+1)&\"'!A1\",\"]\",\"]'\"),\"Next Sheet….\")","v":{"$error":"#REF!"}}]
[]
[]
[{"$f":"PubName","v":0},null,null,null,null,{"$f":"MemberNum","v":0}]
["Step 2 - ...",null,"Adjusting to individually Sold Subscriptions"]
[null,null," "]
[]
[]
[null,null,null,null,"The calculation of average price should not include impact from sponsored sales, subscriptions"]
[null,null,null,null," transferred from another title, from foreign subscriptions, and non-deductible clubs.  If sales (production) statistics "]
[null,null,null,null,"from the base period include sales from any of these sources, they must be adjusted before completing the calculation."]
[null,null,null,null,"The following three steps will allow us to deduct these subscriptions and their value from the calculation."]
[]
[]
["Step 2a - ...",null,"Total Sponsored Sales"]
[" ",null,"Identify and adjust for the dollar values associated with sponsored sales."]
[]
[null,null,null,null,"6 months ended","6 months ended","TOTAL \n(12 month period)"]
[null,null,null,null,{"$f":"_6mos1","v":"00:00:00"},{"$f":"_6mos2","v":"00:00:00"}]
[]
["Line 1","Sponsored Subscriptions",null,null,null,null,{"$f":"SUM(E21:F21)","v":0}]
["Line 2","Sponsored Copies",null,null,null,null,{"$f":"SUM(E22:F22)","v":0}]
["Line 3","Dollar Value ($)",null,null,null,null,{"$f":"SUM(E23:F23)","v":0}]
[null,null,null,null,null,null,null," "]
["Step 2b - ...",null,"Total Transferred Subscriptions"]
[" ",null,"Identify and adjust for the dollar values associated with transferred subscriptions sales."]
[]
[null,null,null,null,"6 months ended","6 months ended","TOTAL \n(12 month period)"]
[null,null,null,null,{"$f":"_6mos1","v":"00:00:00"},{"$f":"_6mos2","v":"00:00:00"}]
[]
["Line 1","Transferred Subscriptions",null,null,null,null,{"$f":"SUM(E31:F31)","v":0}]
["Line 2","Transferred Copies",null,null,null,null,{"$f":"SUM(E32:F32)","v":0}]
["Line 3","Dollar Value ($)",null,null,null,null,{"$f":"SUM(E33:F33)","v":0}]
[]
["Step 2c - ...",null,"Total International Sales"]
[" ",null,"Identify and adjust for the dollar values associated with international subscription sales."]
[]
[null,null,null,null,"6 months ended ","6 months ended","TOTAL \n(12 month period)"]
[null,null,null,null,{"$f":"_6mos1","v":"00:00:00"},{"$f":"_6mos2","v":"00:00:00"}]
[]
["Line 1","International Subscriptions",null,null,null,null,{"$f":"SUM(E41:F41)","v":0}]
["Line 2","International Copies",null,null,null,null,{"$f":"SUM(E42:F42)","v":0}]
["Line 3","Dollar Value ($)",null,null,null,null,{"$f":"SUM(E43:F43)","v":0}]
[]
["Step 2d - ...",null,"Club/Membership- Non-Deductible and Partnership - Non-Deductible"]
[" ",null,"Identify and adjust for the dollar values associated with club/membership - non-deductible  and partnership - non-deductible sales."]
[null,null,null,null,"6 months ended","6 months ended","TOTAL \n(12 month period)"]
[null,null,null,null,{"$f":"_6mos1","v":"00:00:00"},{"$f":"_6mos2","v":"00:00:00"}]
[]
["Line 1","Club/Membership Non-Deductible  and Partnership- Non-Deductible Subscriptions",null,null,null,null,{"$f":"SUM(E50:F50)","v":0}]
["Line 2","Copies",null,null,null,null,{"$f":"SUM(E51:F51)","v":0}]
["Line 3","Dollar Value ($)",null,null,null,null,{"$f":"SUM(E52:F52)","v":0}]
[]
["Step 2e - ...",null,"Muli-Title Digital Programs"]
[" ",null,"Identify and adjust for the dollar values associated with multi-title digital programs. "]
[null,null,null,null,"6 months ended","6 months ended","TOTAL \n(12 month period)"]
[null,null,null,null,{"$f":"_6mos1","v":"00:00:00"},{"$f":"_6mos2","v":"00:00:00"}]
[]
["Line 1","Muli-Title Digital Program Subscriptions",null,null,null,null,{"$f":"SUM(E59:F59)","v":0}]
["Line 2","Copies",null,null,null,null,{"$f":"SUM(E60:F60)","v":0}]
["Line 3","Dollar Value ($)",null,null,null,null,{"$f":"SUM(E61:F61)","v":0}]
[null,null,null,null,null,{"$f":"HYPERLINK(SUBSTITUTE(INDEX(GetSheetNAme,MATCH(get,GetSheetNAme,0)+1)&\"'!A1\",\"]\",\"]'\"),\"Next Sheet….\")","v":{"$error":"#REF!"}}]

{"sheet":"Cancel Adjustment","index":3,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[[18,1,18,3],[26,0,35,7]]}
[{"$f":"HYPERLINK(SUBSTITUTE(INDEX(GetSheetNAme,MATCH(get,GetSheetNAme,0)+1)&\"'!A1\",\"]\",\"]'\"),\"Next Sheet….\")","v":{"$error":"#REF!"}}]
[]
[]
[{"$f":"PubName","v":0},null,null,null,null,{"$f":"MemberNum","v":0}]
["Step 3 - ...",null,"Total Adjustments for Credit Cancellations"]
[]
["Adjust for dollar values and copy values associated with orders canceled for nonpayment (credit"]
["cancels).  Calculate actual total dollar value and copy values (based on full term of subscription order) for"]
[{"$f":"\"all credit cancellations accrued in the 12-month period, \"&TEXT(_AuditEnd,\"MM/DD/YY\")& \", regardless of when the\"","v":"all credit cancellations accrued in the 12-month period, 01/00/00, regardless of when the"}]
["subscriptions may have been sold and served."]
[]
[null,null,null,null,"6 months ended","6 months ended","TOTAL             (12 month period)"]
[null,null,null,null,{"$f":"_6mos2","v":"00:00:00"},{"$f":"_AuditEnd","v":"00:00:00"}]
[]
["Line 1","Canceled Subscriptions",null,null,null,null,{"$f":"SUM(E15:F15)","v":0}]
["Line 2","Copies",null,null,null,null,{"$f":"SUM(E16:F16)","v":0}]
["Line 3","Dollar Value ($)",null,null,null,null,{"$f":"SUM(E17:F17)","v":0}]
[]
["Line 4","Subscription Cancellation Percentage",null,null,"Total Canceled Subscriptions"]
[null,null,null,null,"(Line 1 above)"]
[null,null,null,null,"Divided by","=  ",{"$f":"+G15/'Subscription Value Calculation'!F27","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Total Subscriptions for period"]
[null,null,null,null,"(Line 1, step 1)"]
[]
[]
[null,null,null,"Special Note"]
["Please take care to ensure that you account for the full term of each subscription, not just the copies/dollars that have been served.\n\nThe period to be used to accumulate credit cancel information differs from the base period used to accumulate sales data.  This recognizes the normal delay between that of service and cancellation of the order for non-payment.  Use of data for current cancels for this period will, therefore, better match dollar values to sales dollar values.\n\nNote:  in dealing with credit cancellations, please understand that some fulfillment systems will generate reports which identify only the copies served on credit, and the associated dollars for those copies.  In such cases, it will be necessary to refer to other records, potentially financial records, to acquire the needed data."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"HYPERLINK(SUBSTITUTE(INDEX(GetSheetNAme,MATCH(get,GetSheetNAme,0)+1)&\"'!A1\",\"]\",\"]'\"),\"Next Sheet….\")","v":{"$error":"#REF!"}}]

{"sheet":"Premium Calculation","index":4,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[31,1,31,3],[32,1,32,3],[33,1,33,2]]}
[{"$f":"HYPERLINK(SUBSTITUTE(INDEX(GetSheetNAme,MATCH(get,GetSheetNAme,0)+1)&\"'!A1\",\"]\",\"]'\"),\"Next Sheet….\")","v":{"$error":"#REF!"}}]
[]
[]
[{"$f":"PubName","v":0},null,null,null,null,{"$f":"MemberNum","v":0}]
["Step 4 - ...",null,"Total Premium Values"]
[null,"Adjust for the dollar values of premiums that were used in the subscription sales"]
[null,"generated in the base period."]
[]
[]
[null,"Match premiums to the subscription sold in the base period."]
[]
[]
[]
[null,"Premium","Source Code","# of Subs. Sold","x","Premium Value","=  ","Total Premium $'s Received"]
[null,null,null,null,"x",null,"=  ",{"$f":"+D15*F15","v":0}]
[null,null,null,null,"x",null,"=  ",0]
[null,null,null,null,"x",null,"=  ",0]
[null,null,null,null,"x",null,"=  ",0]
[null,null,null,null,"x",null,"=  ",0]
[null,null,null,null,"x",null,"=  ",0]
[null,null,null,null,"x",null,"=  ",0]
[null,null,null,null,"x",null,"=  ",0]
[null,null,null,null,"x",null,"=  ",0]
[null,null,null,null,"x",null,"=  ",0]
[null,null,null,null,"x",null,"=  ",0]
[null,null,null,null,"x",null,"=  ",0]
[null,null,null,null,"x",null,"=  ",0]
[null,null,null,null,"x",null,"=  ",0]
[null,null,null,null,"x",null,"=  ",0]
[]
[null,"Total",null,null,null,"Total","a)",{"$f":"SUM(H15:H29)","v":0}]
[null,"SUBSCRIPTION CANCELLATION PERCENTAGE (Step 3, line 4)",null,null,null,null,"b)",{"$f":"+'Cancel Adjustment'!G21","v":{"$error":"#DIV/0!"}}]
[null,"CANCELED PREMIUM VALUE TO BE DEDUCTED (these were already deducted in the credit cancel deduction)",null,null,null,"(axb)=","c)",{"$f":"+H31*H32","v":{"$error":"#DIV/0!"}}]
[null,"TOTAL STEP 4:  PREMIUM VALUE DEDUCTED",null,null,null,"(a-c)=",null,{"$f":"+H31-H33","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,{"$f":"HYPERLINK(SUBSTITUTE(INDEX(GetSheetNAme,MATCH(get,GetSheetNAme,0)+1)&\"'!A1\",\"]\",\"]'\"),\"Next Sheet….\")","v":{"$error":"#REF!"}}]

{"sheet":"Average Price Calculation","index":5,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[[42,0,42,8],[46,0,46,8],[45,0,45,8],[43,0,43,8]]}
[{"$f":"HYPERLINK(SUBSTITUTE(INDEX(GetSheetNAme,1)&\"'!A1\",\"]\",\"]'\"),\"First Sheet….\")","v":"First Sheet…."}]
[]
[]
[{"$f":"PubName","v":0},null,null,null,null,{"$f":"MemberNum","v":0}]
["Step 5 - ...",null,null,null,"Calculate Net Subscription Value and Copies"]
[]
[]
[null,null,null,null,null,null,"Total Dollar ($) Value",null,"Total Copies"]
["Total Step 1 (Total Paid Subscriptions)",null,null,null,null,null,{"$f":"+'Subscription Value Calculation'!F29","v":0},null,{"$f":"+'Subscription Value Calculation'!F28","v":0}]
[]
["Less Total Step 2a",null,null,null,null,null,{"$f":"+Adjustments!G23","v":0},null,{"$f":"+Adjustments!G22","v":0}]
["(Sponsored Sales)"]
[]
["Less Total Step 2B",null,null,null,null,null,{"$f":"+Adjustments!G33","v":0},null,{"$f":"+Adjustments!G32","v":0}]
["(Transferred Subscriptions)"]
[]
["Less Total Step 2c",null,null,null,null,null,{"$f":"+Adjustments!G43","v":0},null,{"$f":"+Adjustments!G42","v":0}]
["(International Sales)"]
[]
["Less Total Step 2d",null,null,null,null,null,{"$f":"+Adjustments!G52","v":0},null,{"$f":"+Adjustments!G51","v":0}]
["(Club/Membership and Partnership - Non-Deductible)"]
[]
["Less Total Step 2e",null,null,null,null,null,{"$f":"+Adjustments!G61","v":0},null,{"$f":"+Adjustments!G60","v":0}]
["(Multi-Title Digital Programs)"]
[]
["Subtotal",null,null,null,null,null,{"$f":"+G9-G11-G14-G17-G20-G23","v":0},null,{"$f":"+I9-I11-I14-I17-I20-I23","v":0}]
["(Gross Individually Sold)"]
[]
["Less Total Step 3 ",null,null,null,null,null,{"$f":"+'Cancel Adjustment'!G17","v":0},null,{"$f":"+'Cancel Adjustment'!G16","v":0}]
["(Credit Cancellations)"]
[]
["Less Total Step 4",null,null,null,null,null,{"$f":"+'Premium Calculation'!H34","v":{"$error":"#DIV/0!"}}]
["(Premium Values)"]
[]
["Total Step 5",null,null,null,null,null,{"$f":"+G26-G29-G32","v":{"$error":"#DIV/0!"}},null,{"$f":"I26-I29","v":0}]
[null,null,null,null,null,null,"Net Subscription $ Value",null,"Net Copies"]
[]
[]
[]
[{"$f":"+G35","v":{"$error":"#DIV/0!"}},"/",{"$f":"+I35","v":0},"=",{"$f":"+A40/C40","v":{"$error":"#DIV/0!"}},"x",null,"=",{"$f":"+E40*G40","v":{"$error":"#DIV/0!"}}]
["Net Subscription $ Value",null,"Net Copies",null,"AVERAGE PRICE PER COPY",null,"Issues Per Year* (see note below)",null,"Net Average Annualized Price"]
[]
["*For publications where there may be one or more double issues served in the period covered by the average price calculation, please provide an explanation of how the \"Issues Per Year\" was determined."]
[]
["Additional Comments, Notes:"]
[]
[]
[]
[]
[]
[]
[]
["END OF WORKSHEET. PRINT & SUBMIT.",null,null,null,null,null,null,null,{"$f":"HYPERLINK(SUBSTITUTE(INDEX(GetSheetNAme,1)&\"'!A1\",\"]\",\"]'\"),\"First Sheet….\")","v":"First Sheet…."}]