{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Form","SourceList","LicenceCode_Source"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":1},"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":"Form","index":0,"n_rows":50,"n_cols":34,"rows_kept":50,"cut":false,"hidden":false,"merged":[[9,19,11,19],[9,29,11,32],[9,20,11,28],[9,16,10,18],[11,16,11,18],[9,7,9,13],[9,14,10,15],[10,7,10,13],[11,7,11,10],[11,11,11,13],[11,14,11,15]]}
["Cinema"]
["Multi-Location Form"]
[]
["Client Name:"]
["Client ABN/ACN:"]
["Client Number:"]
["Opp. ID:"]
[null,null,null,null,null,null,null,"1. Music for Cinemas","1. Music for Cinemas","1. Music for Cinemas","1. Music for Cinemas","1. Music for Cinemas","1. Music for Cinemas","1. Music for Cinemas","2. Featured Music Performances","2. Featured Music Performances","3. Telephone On Hold","3. Telephone On Hold","3. Telephone On Hold","Office Use Only - Licence Codes"]
[]
[null,null,null,null,null,null,null,"1. Music for Cinemas",null,null,null,null,null,null,"2. Featured Music Performances",null,"3. Telephone On Hold",null,null,"Licence Codes (Office Use Only)","Licence Codes (Office Use Only) - Hidden Columns",null,null,null,null,null,null,null,null,"Data to Import - Hidden Columns"]
[null,null,null,null,null,null,null,"Complete the relevant option to your location from the two options below: "]
[null,null,null,null,null,null,null,"Option A: I use PPCA Sound Recordings for background Music at Location                                         ",null,null,null,"Option B: I do not use PPCA Sound Recordings for background Music at Location                                         ",null,null,"Has there been any featured performances at the Location in the last quarter?",null,"Which Telephone on Hold option and Caller Capacity are required for the Quarter"]
["Industry\n(Office Use Only)","Location Name","Address Line 1","Address Line 2","City","State","Postcode","1a. Gross Box Office Receipts","1a. Number of screens at Location ","1a. Size of Common Area (m2) ","1a. Location has single screen & fewer than 366 screening per year","1b. Gross Box Office Receipts","1b. Number of screens at Location","1b. Location has single screen & fewer than 366 screening per year","2. Common Area (m2)","2. Number of days for the quarter where Featured Music is used at Location ","3. Copyrights Used","3. Caller Capacity Lines","3. Partial Rights","All Licence Codes","Music for Cinemas - Option A (Licence Codes)","APRA/AMCOS Works (Licence Codes) - Option A","Music in Cinematograph Films (Licence Codes) - Option A","Background Music PPCA (Licence Codes) - Option A","Music for Cinemas - Option B (Licence Codes)","APRA/AMCOS Works (Licence Codes) - Option B","Music in Cinematograph Films (Licence Codes) - Option B","Featured Music (Licence Codes)","Telephone on Hold (Licence Codes)","Opportunity ID","Account Name","Industry Div","Industry Sub-Div","All Licence Codes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},{"$f":"IF($A14>0,$A14,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},{"$f":"IF($A46>0,$A46,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(IF(AND(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]=\"\",Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]=\"\",Table1[[#This Row],[Featured Music (Licence Codes)]]=\"\",Table1[[#This Row],[Telephone on Hold (Licence Codes)]]=\"\"),\"\",(Table1[[#This Row],[Music for Cinemas - Option A (Licence Codes)]]&\" \"&Table1[[#This Row],[Music for Cinemas - Option B (Licence Codes)]]&\" \"&Table1[[#This Row],[Featured Music (Licence Codes)]]&\" \"&Table1[[#This Row],[Telephone on Hold (Licence Codes)]])))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]=\"\",Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option A]]&\" \"&Table1[[#This Row],[Background Music PPCA (Licence Codes) - Option A]])","v":""},{"$f":"IF(Table1[[#This Row],[1a. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1a. Number of screens at Location ]]>0,Table1[[#This Row],[1a. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]>=2001),\"ORET-MVL-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]=\"Yes\",Table1[[#This Row],[1a. Number of screens at Location ]]<=2000,Table1[[#This Row],[1a. Number of screens at Location ]]>0),\"ORET-MVS-1-AU\",\"\"))","v":""},{"$f":"IF(AND(Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]=\"\",Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]]=\"\"),\"\",Table1[[#This Row],[APRA/AMCOS Works (Licence Codes) - Option B]]&\"; \"&Table1[[#This Row],[Music in Cinematograph Films (Licence Codes) - Option B]])","v":""},{"$f":"IF(Table1[[#This Row],[1b. Gross Box Office Receipts]]>0,\"PCIM-AA-1-AU\",\"\")","v":""},{"$f":"IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=0),\"ECIM-PP-2-AU\",IF(AND(Table1[[#This Row],[1b. Number of screens at Location]]>0,Table1[[#This Row],[1b. Location has single screen & fewer than 366 screening per year]]=\"Yes\"),\"ECIM-PP-3-AU\",\"\"))","v":""},{"$f":"IF(OR(Table1[[#This Row],[2. Common Area (m2)]]>0,Table1[[#This Row],[2. Number of days for the quarter where Featured Music is used at Location ]]>0),\"OCIM-PP-5-AU\",\"\")","v":""},{"$f":"IFERROR(INDEX(Table20[Licence Code(s)],MATCH(1,INDEX((Table1[[#This Row],[3. Copyrights Used]]=Table20[Telephone On Hold (Copyrights Used)]) * (Table1[[#This Row],[3. Partial Rights]]=Table20[Telephone On Hold - Partial Rights Discount Eligibility]),0,1),0)),\"\")","v":""},{"$f":"IF(AND($B$7>0,Table1[[#This Row],[Location Name]]>0),$B$7,\"\")","v":""},{"$f":"IF(AND($B$4>0,Table1[[#This Row],[Location Name]]>0),$B$4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Table1[[#This Row],[Industry\n(Office Use Only)]],Table16[],2,FALSE),\"\")","v":""},""]

{"sheet":"SourceList","index":1,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
["Options",null,"Source - Industry Sub-Division (Current)","Industry Division",null,"Options","(All)"]
["1. Music for Cinemas",null,"Cinema","Recreation"]
["2. Featured Music Performances"]
["3. Telephone On Hold"]
["Office Use Only - Licence Codes"]
[]
["Source List - Addtl. Use Confirm (Background Music for Retail)"]
["Yes"]
[]
["Source List - State Options"]
["NSW"]
["QLD"]
["VIC"]
["SA"]
["WA"]
["NT"]
["TAS"]
["ACT"]
["National"]
[]
["Source List - Telephone on Hold (Partial Rights Discount)"]
["PPCA Sound Recordings licensing not required"]
["APRA/AMCOS Works licensing not required"]
[]
["Source List - Copyrights Used (Telephone on Hold)"]
["Communication Only"]
["Communication & Reproduction"]
[]
["Source List - Single/Multi Location (Telephone on Hold)"]
["Single Location"]
["Multiple Locations"]
[]
["Source List - Caller Capacity Lines (Telephone on Hold)"]
["1 - 2"]
["3 - 5"]
["6 - 10"]
["11 - 25"]
["26 - 50"]
["51 - 100"]
["100 - 200"]
["201 - 300"]
["301 - 400"]
["401 plus"]
[]
["Source List - PRD Eligibility (New Test - ALL Uses)"]
["APRA/AMCOS Works licensing required only"]
["PPCA Sound Recordings licensing required only"]
["PPCA Sound Recordings & APRA/AMCOS Works licensing required"]

{"sheet":"LicenceCode_Source","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":true,"merged":[[1,3,3,3],[4,3,6,3]]}
["Telephone On Hold (Copyrights Used)","Telephone On Hold - Partial Rights Discount Eligibility","Licence Code(s)"]
["Communication Only",null,"OCIM-TCO-4-AU","Communication Only"]
["Communication Only","PPCA Sound Recordings licensing not required","PCIM-TCO-4-AU"]
["Communication Only","APRA/AMCOS Works licensing not required","PCIM-TCO-4-AU"]
["Communication & Reproduction",null,"SCIM-TCC-2-AU","Communication & Reproduction"]
["Communication & Reproduction","PPCA Sound Recordings licensing not required","ACIM-TCC-2-AU"]
["Communication & Reproduction","APRA/AMCOS Works licensing not required","ACIM-TCC-2-AU"]