{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["IPA Remittance Dubbing"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"IPA Remittance Dubbing","index":0,"n_rows":51,"n_cols":16,"rows_kept":51,"cut":false,"hidden":false,"merged":[[3,14,3,15],[5,14,5,15],[26,14,26,15],[3,1,3,2],[28,1,28,3],[27,14,27,15],[31,6,31,9],[32,6,32,9],[0,13,1,15],[27,1,27,3],[27,4,28,4],[10,6,23,6],[24,4,26,4],[27,11,27,12],[3,4,3,5],[4,1,4,5],[5,1,5,5],[0,10,1,12],[0,3,0,9],[26,11,26,12],[3,8,3,12],[5,10,5,12],[28,11,29,12],[27,6,27,9],[28,6,28,9],[29,6,29,9],[26,6,26,9],[33,6,33,9],[28,14,28,15],[29,14,29,15],[30,14,30,15],[31,14,31,15],[32,14,32,15],[33,14,33,15],[30,6,30,9],[33,11,33,12],[30,11,30,12],[31,11,31,12],[32,11,32,12],[35,5,35,15],[50,14,50,15],[34,14,34,15],[38,0,38,15],[40,0,40,15],[41,0,41,15],[42,0,42,15],[43,0,43,15],[44,0,44,15],[45,0,45,15],[47,0,47,15],[48,0,48,15],[39,0,39,15],[37,0,37,15],[46,0,46,15]]}
[null,null,null,"IPA REMITTANCE CALCULATIONS DUBBING",null,null,null,null,null,null,"NEW RATES AS OF 2022-JAN-01"]
[]
[]
["DATE:",null,null,"FOR PERIOD OF:",null,null,null,"PRODUCTION TITLE:",null,null,null,null,null,"EPISODE:"]
["ENGAGER:"]
["ADDRESS:",null,null,null,null,null,null,"PHONE:",null,"EMAIL:",null,null,null,"LOCATION SHOOT:"]
[]
[]
[]
["ACTRA NUMBER","PERFORMER \nNAME","MINOR DEDUCTION*\n(if Applicable)","PERFORMANCE CATEGORY","PRODUCTION \nDATE","GROSS \nFEE","USE \nFEE","WORK PERMIT**\n(if Applicable)","2.25% DUES***\n(for Full ACTRA Members Only)","3% \nFRATERNAL","MINOR DEDUCTION","GST / HST / QST \n(If Applicable)","GST / HST / QST\nNUMBER","12% I&R PRODUCER CONTRIBUTION","GST/HST/QST\n****","TOTAL AMOUNT PAYBLE TO PERFORMER"]
[null,null,null,null,null,null,"NOT APPLICABLE \nTO DUBBING CONTRACT",null,{"$f":"F11*2.25%","v":0},{"$f":"F11*3%","v":0},{"$f":"IF(C11=\"Y\",F11*0.25,0)+ROUND(,2)","v":0},null,null,{"$f":"F11*12%","v":0},{"$f":"_xlfn.IFS(L11=\"GST\",(F11+N11)*5%,L11=\"QST\",(F11+N11)*9.975%,L11=\"HST\",(F11+N11)*13%,L11=\"\",0)","v":0},{"$f":"F11-H11-I11-J11-K11+O11","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"F12*2.25%","v":0},{"$f":"F12*3%","v":0},{"$f":"IF(C12=\"Y\",F12*0.25,0)+ROUND(,2)","v":0},null,null,{"$f":"F12*12%","v":0},{"$f":"_xlfn.IFS(L12=\"Y\",(F12+N12)*5%,L12=\"N\",0,L12=\"\",0)","v":0},{"$f":"F12-H12-I12-J12-K12+O12","v":0}]
[null,null,null,null,null,null,null,null,0,0,0,null,null,0,{"$f":"_xlfn.IFS(L13=\"Y\",(F13+N13)*5%,L13=\"N\",0,L13=\"\",0)","v":0},0]
[null,null,null,null,null,null,null,null,0,0,0,null,null,0,{"$f":"_xlfn.IFS(L14=\"Y\",(F14+N14)*5%,L14=\"N\",0,L14=\"\",0)","v":0},0]
[null,null,null,null,null,null,null,null,0,0,0,null,null,0,{"$f":"_xlfn.IFS(L15=\"Y\",(F15+N15)*5%,L15=\"N\",0,L15=\"\",0)","v":0},0]
[null,null,null,null,null,null,null,null,0,0,0,null,null,0,{"$f":"_xlfn.IFS(L16=\"Y\",(F16+N16)*5%,L16=\"N\",0,L16=\"\",0)","v":0},0]
[null,null,null,null,null,null,null,null,0,0,0,null,null,0,{"$f":"_xlfn.IFS(L17=\"Y\",(F17+N17)*5%,L17=\"N\",0,L17=\"\",0)","v":0},0]
[null,null,null,null,null,null,null,null,0,0,0,null,null,0,{"$f":"_xlfn.IFS(L18=\"Y\",(F18+N18)*5%,L18=\"N\",0,L18=\"\",0)","v":0},0]
[null,null,null,null,null,null,null,null,0,0,0,null,null,0,{"$f":"_xlfn.IFS(L19=\"Y\",(F19+N19)*5%,L19=\"N\",0,L19=\"\",0)","v":0},0]
[null,null,null,null,null,null,null,null,0,0,0,null,null,0,{"$f":"_xlfn.IFS(L20=\"Y\",(F20+N20)*5%,L20=\"N\",0,L20=\"\",0)","v":0},0]
[null,null,null,null,null,null,null,null,0,0,0,null,null,0,{"$f":"_xlfn.IFS(L21=\"Y\",(F21+N21)*5%,L21=\"N\",0,L21=\"\",0)","v":0},0]
[null,null,null,null,null,null,null,null,0,0,0,null,null,0,{"$f":"_xlfn.IFS(L22=\"Y\",(F22+N22)*5%,L22=\"N\",0,L22=\"\",0)","v":0},0]
[null,null,null,null,null,null,null,null,0,0,0,null,null,0,{"$f":"_xlfn.IFS(L23=\"Y\",(F23+N23)*5%,L23=\"N\",0,L23=\"\",0)","v":0},0]
[null,null,null,null,null,null,null,null,0,0,0,null,null,0,{"$f":"_xlfn.IFS(L24=\"Y\",(F24+N24)*5%,L24=\"N\",0,L24=\"\",0)","v":0},0]
[null,null,null,null,"REQUIRED FIELD\n(SELECT DROP DOWN OPTION BELOW)",{"$f":"SUM(F11:F24)","v":0},"SUBTOTAL",{"$f":"SUM(H11:H24)","v":0},{"$f":"SUM(I11:I24)","v":0},{"$f":"SUM(J11:J24)","v":0},{"$f":"SUM(K11:K24)","v":0},null,null,{"$f":"SUM(N11:N24)","v":0}]
[]
[null,null,null,null,null,"ACTRA","DETAILS",null,null,null,"ACTRA (I&R)","DETAILS",null,"ACTRA PRS","DETAILS"]
[null,"MEMBER or NON-MEMBER",null,null,"BLANK PLEASE SELECT",{"$f":"_xlfn.IFS(E28=\"MEMBER\",F25*0.01,E28=\"NON-MEMBER\",F25*0.05,E28=\"BLANK PLEASE SELECT\",F25*0)","v":0},"5% Admin Fee Non-Member Producer | 1% Admin Fee Member Producer",null,null,null,{"$f":"J25","v":0},"Total 3% Retirement Deduction",null,{"$f":"K25","v":0},"Total 25% Minors Deduction to ACTRA PRS"]
[null,"(CMPA, ANDP or AQPM) ",null,null,null,{"$f":"F28*5%","v":0},"GST 5% applies to Admin Fee",null,null,null,{"$f":"F25*12%","v":0},"Total 12% Insurance & Retirement Producers' Contribution"]
[null,null,null,null,null,{"$f":"F28*9.975%","v":0},"QST 9.975% applies to Admin fee"]
[null,null,null,null,null,{"$f":"SUM(F28:F30)","v":0},"TOTAL Admin Fee + Taxes"]
[null,null,null,null,null,{"$f":"H25","v":0},"TOTAL Work Permit Fee"]
[null,null,null,null,null,{"$f":"I25","v":0},"TOTAL Dues"]
[]
[null,null,null,null,"TOTAL",{"$f":"F31+F32+F33","v":0},"PAYABLE TO ACTRA",null,null,null,{"$f":"K28+K29","v":0},"PAYABLE TO ACTRA I&R",null,{"$f":"SUM(N28:N34)","v":0},"PAYABLE TO PRS"]
[]
[]
[]
["IMPORTANT NOTES"]
[]
["● Input Required Information (where applicable) into all shaded fields. "]
["● Upon entering the Gross Session fee, basic calculations (Dues and I&R) should automatically be calculated - ALWAYS check for accuracy."]
["● * If Performer is a Minor and Minor Deductions should occur, select 'Y' from the drop-down menu and Minor Deductions will automatically populate in column K, be deducted from payable amount to performer, and appear in Payable to PRS section."]
["● ** Work Permit Fee Amount must be inputted for deduction. Work Permits apply to Apprentice and Non-Members of ACTRA - instead of 2.25% Dues deduction."]
["● ***2.25% Dues deduction on Performers' Gross fee for FULL Members of ACTRA only."]
["● ****GST/QST/HST (if applicable) must be selected in order to include these calculations in the Total (Performers Gross Fee + 12% (Producers Contribution I&R) x 5% GST and/or 9.975% QST or 13% HST)"]
["● TOTAL is the total payable to the headings above (ACTRA, ACTRA I&R [AFBS], PRS)."]
["● The RESET FORM button at the top can be double clicked to clear all of the populated data from this form in order to produce new data calculations"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Last Updated: 2022-Jan-21"]