{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["CME Claim Form","Read Me","Sheet1"],"not_rendered":{"images":1,"external_links":1,"defined_names":13},"read":"whole","date_system":"1900"}

{"sheet":"CME Claim Form","index":0,"n_rows":59,"n_cols":62,"rows_kept":59,"merged":[[0,1,0,63],[5,1,5,6],[5,8,5,15],[5,18,5,23],[5,25,5,31],[7,1,7,6],[7,8,7,20],[7,27,7,32],[7,34,7,62],[10,1,10,64],[12,2,12,8],[12,9,12,62],[15,14,15,16],[15,17,15,19],[15,20,15,22],[15,36,15,38],[15,40,15,43],[15,45,15,48],[15,50,15,53],[16,2,16,9],[16,14,16,16],[16,17,16,19],[16,20,16,22],[16,36,16,38],[16,40,16,43],[16,45,16,48],[16,50,16,53],[17,7,17,8],[17,14,17,16],[17,17,17,19],[17,20,17,22],[17,36,17,38],[17,40,17,43],[17,45,17,48],[17,50,17,53],[18,2,18,9],[18,14,18,16],[18,17,18,19],[18,20,18,22],[18,36,18,38],[18,40,18,43],[18,45,18,48],[18,50,18,53],[19,2,19,9],[19,14,19,16],[19,17,19,19],[19,20,19,22],[19,36,19,38],[19,40,19,43],[19,45,19,48],[19,50,19,53],[20,2,20,10],[20,14,20,16],[20,17,20,19],[20,20,20,22],[20,36,20,38],[20,40,20,43],[20,45,20,48],[20,50,20,53],[21,2,21,10],[21,14,21,16],[21,17,21,19],[21,20,21,22],[21,36,21,38],[21,40,21,43],[21,45,21,48],[21,50,21,53],[22,2,22,10],[22,14,22,16],[22,17,22,19],[22,20,22,22],[22,36,22,38],[22,40,22,43],[22,45,22,48],[22,50,22,53],[23,2,23,9],[23,14,23,16],[23,17,23,19],[23,20,23,22],[23,40,23,43],[23,45,23,48],[23,50,23,53],[25,1,25,64],[27,14,27,16],[27,17,27,19],[27,20,27,22],[27,36,27,38],[27,40,27,43],[27,45,27,48],[27,50,27,53],[28,2,28,9],[28,14,28,16],[28,17,28,19],[28,20,28,22],[28,23,28,25],[28,36,28,38],[28,40,28,43],[28,45,28,48],[28,50,28,53],[29,2,29,9],[29,14,29,16],[29,17,29,19],[29,20,29,22],[29,23,29,25],[29,36,29,38],[29,40,29,43],[29,45,29,48],[29,50,29,53],[30,2,30,10],[30,14,30,16],[30,17,30,19],[30,20,30,22],[30,23,30,25],[30,36,30,38],[30,40,30,43],[30,45,30,48],[30,50,30,53],[31,2,31,10],[31,14,31,16],[31,17,31,19],[31,20,31,22],[31,23,31,25],[31,36,31,38],[31,40,31,43],[31,45,31,48],[31,50,31,53],[32,2,32,10],[32,14,32,16],[32,17,32,19],[32,20,32,22],[32,23,32,25],[32,36,32,38],[32,40,32,43],[32,45,32,48],[32,50,32,53],[33,2,33,9],[33,14,33,16],[33,17,33,19],[33,20,33,22],[33,40,33,43],[33,45,33,48],[33,50,33,53],[35,1,35,64],[37,14,37,16],[37,17,37,19],[37,20,37,22],[37,23,37,25],[37,26,37,28],[37,30,37,32],[37,33,37,35],[37,36,37,38],[37,40,37,43],[37,44,37,47],[37,48,37,51],[37,52,37,55],[37,57,37,59],[37,61,37,63],[38,2,38,10],[38,14,38,16],[38,17,38,19],[38,20,38,22],[38,23,38,25],[38,26,38,28],[38,30,38,32],[38,33,38,35],[38,36,38,38],[38,40,38,43],[38,44,38,47],[38,48,38,51],[38,52,38,55],[38,57,38,59],[38,61,38,63],[39,2,39,10],[39,14,39,16],[39,17,39,19],[39,20,39,22],[39,23,39,25],[39,26,39,28],[39,30,39,32],[39,33,39,35],[39,36,39,38],[39,40,39,43],[39,44,39,47],[39,48,39,51],[39,52,39,55],[39,57,39,59],[39,61,39,63],[40,2,40,10],[40,14,40,16],[40,17,40,19],[40,20,40,22],[40,23,40,25],[40,26,40,28],[40,30,40,32],[40,33,40,35],[40,36,40,38],[40,40,40,43],[40,44,40,47],[40,48,40,51],[40,52,40,55],[40,57,40,59],[40,61,40,63],[41,2,41,10],[41,14,41,16],[41,17,41,19],[41,20,41,22],[41,23,41,25],[41,26,41,28],[41,30,41,32],[41,33,41,35],[41,36,41,38],[41,40,41,43],[41,44,41,47],[41,48,41,51],[41,52,41,55],[41,57,41,59],[41,61,41,63],[42,2,42,10],[42,14,42,16],[42,17,42,19],[42,20,42,22],[42,23,42,25],[42,26,42,28],[42,30,42,32],[42,33,42,35],[42,36,42,38],[42,40,42,43],[42,44,42,47],[42,48,42,51],[42,52,42,55],[42,57,42,59],[42,61,42,63],[43,2,43,10],[43,14,43,16],[43,17,43,19],[43,20,43,22],[43,23,43,25],[43,26,43,28],[43,30,43,32],[43,33,43,35],[43,36,43,38],[43,40,43,43],[43,44,43,47],[43,48,43,51],[43,52,43,55],[43,57,43,59],[43,61,43,63],[44,2,44,9],[44,14,44,16],[44,17,44,19],[44,20,44,22],[44,23,44,25],[44,26,44,28],[44,30,44,32],[44,40,44,43],[44,44,44,47],[44,48,44,51],[44,52,44,55],[44,57,44,59],[44,61,44,63],[46,1,46,64],[49,3,49,7],[49,12,49,22],[49,27,49,45],[49,49,49,60],[51,3,51,7],[51,12,51,22],[51,27,51,45],[51,49,51,60],[54,1,54,63]]}
[null,"SToNZ RMO CME Expense Claim Form"]
[]
[]
[]
[]
[null,"EMPLOYEE NUMBER \n(compulsory to fill)",{"$nulls":16},"MEDICAL COUNCIL NUMBER\n(compulsory to fill)",{"$nulls":16},"BANK ACCOUNT NO."]
[]
[null,"EMPLOYEE NAME",{"$nulls":25},"SPECIALTY"]
[]
[]
[null,"CONFERENCE DETAILS  Please complete this section for conference expenses as part of your CME claim                               Please note cells highlighted in orange are locked and automatically populate"]
[]
[null,null,"Detail of Conference:\n(Name, Date etc)"]
[]
[]
[null,"Cost of Conference:",{"$nulls":11},"NZD or Foreign Currency","$ NZ net",null,null,"GST (NZ expenses only)",null,null,"$NZ Total (including GST)",{"$nulls":15},"CME Balance ",{"$nulls":3},"Recalculated GST",{"$nulls":4},"CME Deduction",{"$nulls":4},"Amount Reimbursed to RMO"]
[null,"1 -","Conference Registration Fees:",{"$nulls":11},{"$f":"U17-R17","v":0},null,null,{"$f":"IF(N17<>\"NZD\",0,U17*3/23)","v":0},{"$nulls":22},{"$f":"IF(AND(N17=\"NZD\",O17>AK17),AK17*15%,R17)","v":0},{"$nulls":4},{"$f":"IF(AK17<O17,AK17,O17)","v":0},{"$nulls":4},{"$f":"IF(AK17<O17,AT17+AO17,U17)","v":0}]
[null,"2 -","Accommodation:",{"$nulls":3},"..",null,null,"nights",{"$nulls":4},{"$f":"U18-R18","v":0},null,null,{"$f":"IF(N18<>\"NZD\",0,U18*3/23)","v":0},{"$nulls":22},{"$f":"IF(AND(N18=\"NZD\",O18>AK18),AK18*15%,R18)","v":0},{"$nulls":4},{"$f":"IF(AK18<O18,AK18,O18)","v":0},{"$nulls":4},{"$f":"IF(AK18<O18,AT18+AO18,U18)","v":0}]
[null,"3 -","Return Airfares (including tax):",{"$nulls":11},0,null,null,0,{"$nulls":22},0,{"$nulls":4},0,{"$nulls":4},0]
[null,"4 -","Taxis to and from conferences",{"$nulls":11},0,null,null,0,{"$nulls":22},0,{"$nulls":4},0,{"$nulls":4},0]
[null,"5 -",{"$nulls":12},0,null,null,0,{"$nulls":22},0,{"$nulls":4},0,{"$nulls":4},0]
[null,"7 -",{"$nulls":12},0,null,null,0,{"$nulls":22},0,{"$nulls":4},0,{"$nulls":4},0]
[null,"8 -",{"$nulls":12},0,null,null,0,{"$nulls":22},0,{"$nulls":4},0,{"$nulls":4},0]
[null,null,"Total",{"$nulls":11},{"$f":"SUM(O17:Q23)","v":0},null,null,{"$f":"SUM(R17:T23)","v":0},null,null,{"$f":"SUM(U17:W23)","v":0},{"$nulls":19},{"$f":"SUM(AO17:AR23)","v":0},{"$nulls":4},{"$f":"SUM(AT17:AW23)","v":0},{"$nulls":4},{"$f":"SUM(AY17:BB23)","v":0}]
[]
[null,"EXPENSES  Please complete this section for expenses as part of your CME claim other than Conferences and IT related equipment                                                             Please note that cells highlighted in orange are locked and automatically populate"]
[]
[null,"Cost of Expenses:",{"$nulls":11},"NZD or Foreign Currency","$ NZ net",null,null,"GST (NZ expenses only)",null,null,"$NZ Total (including GST)",{"$nulls":15},"CME Balance ",{"$nulls":3},"Recalculated GST",{"$nulls":4},"CME Deduction",{"$nulls":4},"Amount Reimbursed to RMO"]
[null,"9 -","Subscriptions",{"$nulls":11},{"$f":"U29-R29","v":0},null,null,{"$f":"IF(N29<>\"NZD\",0,U29*3/23)","v":0},{"$nulls":22},{"$f":"IF(AND(N29=\"NZD\",O29>AK29),AK29*15%,R29)","v":0},{"$nulls":4},{"$f":"IF(AK29<O29,AK29,O29)","v":0},{"$nulls":4},{"$f":"IF(AK29<O29,AT29+AO29,U29)","v":0}]
[null,"10 -","Books",{"$nulls":11},{"$f":"U30-R30","v":0},null,null,{"$f":"IF(N30<>\"NZD\",0,U30*3/23)","v":0},{"$nulls":22},{"$f":"IF(AND(N30=\"NZD\",O30>AK30),AK30*15%,R30)","v":0},{"$nulls":4},{"$f":"IF(AK30<O30,AK30,O30)","v":0},{"$nulls":4},{"$f":"IF(AK30<O30,AT30+AO30,U30)","v":0}]
[null,"11 -","Personal Surgical / medical equipment",{"$nulls":11},{"$f":"U31-R31","v":0},null,null,{"$f":"IF(N31<>\"NZD\",0,U31*3/23)","v":0},{"$nulls":22},0,{"$nulls":4},{"$f":"IF(AK31<O31,AK31,O31)","v":0},{"$nulls":4},{"$f":"IF(AK31<O31,AT31+AO31,U31)","v":0}]
[null,"12 -",{"$nulls":12},0,null,null,0,{"$nulls":22},0,{"$nulls":4},0,{"$nulls":4},0]
[null,"13 -",{"$nulls":12},0,null,null,0,{"$nulls":22},0,{"$nulls":4},0,{"$nulls":4},0]
[null,null,"Total",{"$nulls":11},{"$f":"SUM(O29:Q33)","v":0},null,null,{"$f":"SUM(R29:T33)","v":0},null,null,{"$f":"SUM(U29:W33)","v":0},{"$nulls":19},{"$f":"SUM(AT27:AW27)","v":0},{"$nulls":4},{"$f":"SUM(BF27:BK33)","v":0},{"$nulls":4},{"$f":"SUM(AY29:BB33)","v":0}]
[]
[null,"PURCHASED IT ASSETS  Please complete this section for IT assets expenses as part of your CME claim                                         Please note that cells highlighted in orange are locked and automatically populate"]
[]
[null,"Cost of Equipment:",{"$nulls":10},"Payroll Code (NRA use only)","NZD or Foreign Currency","$ NZ net             ",null,null,"GST (NZ expenses only)",null,null,"$NZ Total (including GST)",null,null,"PAYE",null,null,"Grossed up",null,null,"Kiwisaver EMPLOYER Contribution Rate","Kiwisaver EMPLOYER contribution Amount",null,null,"Kiwisaver EMPLOYEE Contribution Rate",null,null,"CME Balance ",{"$nulls":3},"Recalculated GST",{"$nulls":3},"Recalculated PAYE ",{"$nulls":3},"Recalculated Kiwisaver EMPLOYER Contribution",{"$nulls":3},"CME Deduction",{"$nulls":4},"EMPLOYEE Kiwisaver deduction from Reimbursement",{"$nulls":3},"Amount Reimbursed to RMO"]
[null,"14 -","Smart Phones / Mobile Phones",{"$nulls":9},"CMEB / EDS",null,{"$f":"U39-R39","v":0},null,null,{"$f":"IF(N39<>\"NZD\",0,U39*3/23)","v":0},{"$nulls":5},{"$f":"(U39/0.67)-U39","v":0},null,null,{"$f":"U39/0.67","v":0},{"$nulls":3},{"$f":"IF(AD39<>\"No Kiwisaver\",AA39*AD39,0)","v":0},{"$nulls":9},{"$f":"IF(N39=\"NZD\",(BA39-AW39-AS39)*3/23,0)","v":0},{"$nulls":3},{"$f":"(BA39-AW39)*33/100","v":0},{"$nulls":3},{"$f":"IF(AD39<>\"No Kiwisaver\",BA39*(AD39*100)/(AD39*100+100),0)","v":0},{"$nulls":3},{"$f":"IF(U39+X39+AE39>AK39,AK39,U39+X39+AE39)","v":0},{"$nulls":4},{"$f":"IF(AD39<>\"No Kiwisaver\",(BA39-AW39)*AH39,0)","v":0},{"$nulls":3},{"$f":"BA39-AS39-AW39-BF39","v":0}]
[null,"15 -","Laptops / Tablets",{"$nulls":9},"CMEB / EDS",null,{"$f":"U40-R40","v":0},null,null,{"$f":"IF(N40<>\"NZD\",0,U40*3/23)","v":0},{"$nulls":5},{"$f":"(U40/0.67)-U40","v":0},null,null,{"$f":"U40/0.67","v":0},{"$nulls":3},{"$f":"IF(AD40<>\"No Kiwisaver\",AA40*AD40,0)","v":0},{"$nulls":9},{"$f":"IF(N40=\"NZD\",(BA40-AW40-AS40)*3/23,0)","v":0},{"$nulls":3},{"$f":"(BA40-AW40)*33/100","v":0},{"$nulls":3},{"$f":"IF(AD40<>\"No Kiwisaver\",BA40*(AD40*100)/(AD40*100+100),0)","v":0},{"$nulls":3},{"$f":"IF(U40+X40+AE40>AK40,AK40,U40+X40+AE40)","v":0},{"$nulls":4},{"$f":"IF(AD40<>\"No Kiwisaver\",(BA40-AW40)*AH40,0)","v":0},{"$nulls":3},{"$f":"BA40-AS40-AW40-BF40","v":0}]
[null,"16 -","Desktops",{"$nulls":9},"CMEB / EDS",null,{"$f":"U41-R41","v":0},null,null,{"$f":"IF(N41<>\"NZD\",0,U41*3/23)","v":0},{"$nulls":5},{"$f":"(U41/0.67)-U41","v":0},null,null,{"$f":"U41/0.67","v":0},{"$nulls":3},{"$f":"IF(AD41<>\"No Kiwisaver\",AA41*AD41,0)","v":0},{"$nulls":9},{"$f":"IF(N41=\"NZD\",(BA41-AW41-AS41)*3/23,0)","v":0},{"$nulls":3},{"$f":"(BA41-AW41)*33/100","v":0},{"$nulls":3},{"$f":"IF(AD41<>\"No Kiwisaver\",BA41*(AD41*100)/(AD41*100+100),0)","v":0},{"$nulls":3},{"$f":"IF(U41+X41+AE41>AK41,AK41,U41+X41+AE41)","v":0},{"$nulls":4},{"$f":"IF(AD41<>\"No Kiwisaver\",(BA41-AW41)*AH41,0)","v":0},{"$nulls":3},0]
[null,"17 -","Software (work related applications only)",{"$nulls":9},"CMEB / EDS",null,0,null,null,{"$f":"IF(N42<>\"NZD\",0,U42*3/23)","v":0},{"$nulls":5},{"$f":"(U42/0.67)-U42","v":0},null,null,0,{"$nulls":3},0,{"$nulls":9},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":4},0,{"$nulls":3},0]
[null,"18 -","Accessories - keyboard, mouse, laptop bag",{"$nulls":9},"CMEB / EDS",null,0,null,null,{"$f":"IF(N43<>\"NZD\",0,U43*3/23)","v":0},{"$nulls":5},0,null,null,0,{"$nulls":3},0,{"$nulls":9},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":4},0,{"$nulls":3},0]
[null,"19 -",{"$nulls":10},"CMEB / EDS",null,0,null,null,0,{"$nulls":5},0,null,null,0,{"$nulls":3},0,{"$nulls":9},{"$f":"IF(N44=\"NZD\",(BA44-AW44-AS44)*3/23,0)","v":0},{"$nulls":3},{"$f":"(BA44-AW44)*33/100","v":0},{"$nulls":3},{"$f":"IF(AD44<>\"No Kiwisaver\",BA44*(AD44*100)/(AD44*100+100),0)","v":0},{"$nulls":3},0,{"$nulls":4},0,{"$nulls":3},0]
[null,null,"Total",{"$nulls":11},{"$f":"SUM(O39:Q44)","v":0},null,null,{"$f":"SUM(R39:T44)","v":0},null,null,{"$f":"SUM(U39:W44)","v":0},null,null,{"$f":"SUM(X39:Z44)","v":0},null,null,{"$f":"SUM(AA39:AC44)","v":0},{"$nulls":3},{"$f":"SUM(AE39:AG44)","v":0},{"$nulls":9},{"$f":"SUM(AO39:AR44)","v":0},{"$nulls":3},{"$f":"SUM(AS39:AS44)","v":0},{"$nulls":3},{"$f":"SUM(AW39:AW44)","v":0},{"$nulls":3},{"$f":"SUM(BA39:BD44)","v":0},{"$nulls":4},{"$f":"SUM(BF39:BH44)","v":0},{"$nulls":3},{"$f":"SUM(BJ39:BN44)","v":0}]
[]
[null,"APPROVAL SECTION Please ensure you receive the necessary signoff before committing to costs relating to this application."]
[]
[null,null,"I certify all expenses claimed above were  necessarily incurred in the course of my work and I have attached the appropriate receipts required as below."]
[{"$nulls":3},"Applicant:",{"$nulls":4},"Signature:",{"$nulls":16},"Name:",{"$nulls":21},"Date:"]
[null,null,"The application is complete and sufficient balance of CME entitlement has been confirmed. "]
[{"$nulls":3},"NRA Approver",{"$nulls":4},"Signature:",{"$nulls":16},"Name:",{"$nulls":21},"Date:"]
[]
[]
[null,"Requirement:\n1. All original supporting receipts/invoices or copies of certificates must be attached. Please note that a GST invoice is required for all claims in excess of $50 (NZ expenditure only).\n2. In addition for overseas expenditure, include a copy of your credit card statement showing the relevant transaction.  \n3. For overseas cash expenditure, complete the form in NZ$, using the currency conversion rate found on your credit card statement for the same period of time. If this is not possible, use the currency conversion rate for the day of the expense and attach a print out of the website the rate is taken from to this form. "]
[null,"NRA Office Use: "]
[null,"Item on approved list?",{"$nulls":6},"YES",{"$nulls":4},"NO",{"$nulls":3},"If NO date escalated where applicable:"]
[]
[null,"CME Balance:",{"$nulls":15},"Reimbursement Capped?",{"$nulls":7},"YES",null,null,"NO",{"$nulls":4},"GST Split Required?",{"$nulls":5},"NO",null,null,"YES",null,"(If yes you will need to split costs into separate entries on claim form)"]

{"sheet":"Read Me","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"Sheet1","index":2,"n_rows":7,"n_cols":3,"rows_kept":7}
["NZ or Overseas Expense",null,"Kiwisaver Contribution Rate"]
["NZD",null,{"v":0.03,"d":"3%"}]
["Overseas",null,{"v":0.04,"d":"4%"}]
["NZD GST Exempt",null,{"v":0.06,"d":"6%"}]
[null,null,{"v":0.08,"d":"8%"}]
[null,null,{"v":0.1,"d":"10%"}]
[null,null,"No Kiwisaver"]