{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Sheet1","Data","Calculation a","Calculation","PAYE VS Portfolio","Agency Report",".","Umbrella rates","PAYE rates"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"defined_names":126,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[52,1,52,2],[52,5,52,6],[27,1,28,7],[30,2,30,5],[4,1,5,7],[10,1,11,7],[18,1,19,7],[29,6,31,7],[49,1,50,7],[33,1,34,7],[35,6,37,7],[36,2,36,5]]}
[]
[null,"2019/20 - Key Portfolio Rate Calculator"]
[null,"Complete Section 1 and then calculate the Key Portfolio rate in Section 2:"]
[]
[null,"1 - Enter assignment details (optional)"]
[]
[]
[null,"Enter the client booking charge",0,null,null,null,null,null,null,{"$f":"IF(C8=0,IF(G8=0,0,G8),C8)","v":0}]
[]
[]
[null,"Section 1 - Complete all fields"]
[]
[]
[null,"Select the candidate's age range",null,null,null,"Enter the PAYE rate",0,null,null,{"$f":"IF(G14=0,0,G14)","v":0}]
[]
[null,"Is the PAYE rate daily or hourly?",null,null,null,"Enter the weekly no. of  hours/days",0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G16=0,G16)","v":0}]
[]
[null,"Section 2 - Calculate the Key Portfolio rate"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"Data!C19","v":0}]
[null,null,null,null,null,null,null,null,null,0.95]
[]
[]
[]
[null,"Calculated Key Portfolio rate (do not manually enter values)"]
[]
[null,null,null,null,null,null,"Key Portfolio rate is too low! Please increase to meet\nNMW requirements."]
[null,null,{"$f":"SPR","v":0},null,null,null,null,null,null,{"$f":"VLOOKUP(AgeRange,'.'!I24:J29,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(RateType=\"Daily\",IF(UR<(6.5*J31),\"True\",\"False\"),IF(RateType=\"Hourly\",IF(UR<J31,\"True\",\"False\")))","v":false}]
[]
[null,"Estimated additional agency margin"]
[]
[]
[null,null,{"$f":"G40-G42","v":0}]
[]
[]
[null,"Approximate PAYE take-home",{"$f":"Calculation!F28","v":0},null,null,"Total cost to CER on PAYE",{"$f":"Calculation!F38+Calculation!F7","v":0},null,null,{"$f":"ROUND(C40*J24,2)","v":0}]
[]
[null,"Approximate Key take-home",{"$f":"Calculation!J28","v":0},null,null,"Total cost to CER on Key",{"$f":"Calculation!J7","v":0}]
[]
[null,null,null,null,null,"Estimated additional CER Margin",{"$f":"G40-G42","v":0}]
[]
[]
[null,null,null,null,null,null,"Do not use after 5th April 2020"]
[]
[]
[null,"Useful links:"]
[]
[]
[null,"How to promote Key Portfolio to your candidates",null,null,null,"Register your candidate"]

{"sheet":"Data","index":1,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
["Input"]
[null,"Total no of billers",1,null,null,null,null,null,null,null,"please select","Agency"]
[]
[1,"Sector","Education","Select From List",null,null,null,null,null,10,"Expenses:"]
[]
[2,"Tax Code","1250L","Tax Regime",null,"UK",null,null,null,null,"Total Expenses",null,0]
[]
[3,"Pay Cycle","Weekly","Select From List"]
[]
[4,"Fee","Portfolio",null,null,null,null,null,null,11,"Options"]
[null,null,"Percentage",null,null,null,null,{"$f":"IF(D13=0,C13,D13)","v":0.04}]
[null,"a) Percent ",{"$f":"IF($C$9='.'!$I$14,'.'!L3,IF(Data!$C$9='.'!$I$15,'.'!L6,'.'!L9))","v":0.04},null,null,null,null,null,null,null,"Student Loan","NO","Select From List"]
[null,"b) MAX",{"$f":"IF($C$9='.'!$I$14,'.'!L4,IF(Data!$C$9='.'!$I$15,'.'!L7,'.'!L10))","v":16},null,null,null,null,null,null,null,"Post Graduate Loan","NO","Select From List"]
[null,"c) Min",{"$f":"IF($C$9='.'!$I$14,'.'!L5,IF(Data!$C$9='.'!$I$15,'.'!L8,'.'!L11))","v":0},null,null,null,null,null,null,null,"NI Exempt","NO","Select From List"]
[null,null,null,null,null,null,null,null,null,null,"HP Accrued","NO","Select From List"]
[5,"HP %",0.1207,null,null,null,null,null,null,null,"Pension","YES","Select From List"]
[]
[6,"Rate",{"$f":"IF(Sheet1!G14>0,Sheet1!G14,0)","v":0}]
[null,null,null,"Select From List",null,null,null,null,null,null,"PAYROLL ONLY"]
[7,"Number of Days ",{"$f":"IF(Sheet1!C16=\"Hourly\",0,Sheet1!G16)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"No of periods",1]
[8,"Number of Hours",{"$f":"IF(Sheet1!C16=\"Daily\",0,Sheet1!G16)","v":0}]
[]
[9,"Total Income",{"$f":"IF(C23>0,C23*C19,C21*C19)","v":0}]
[]
[]
[10,"HP Accrual",0]
[]
[10]
[null,"Show Agency Savings","YES"]

{"sheet":"Calculation a","index":2,"n_rows":47,"n_cols":16378,"rows_kept":47,"cut":false,"hidden":true,"merged":[[4,15,4,16],[4,6,4,9],[3,15,3,16],[1,0,1,3],[3,4,3,5],[3,13,3,14],[3,6,3,9]]}
[]
[]
[]
[null,null,null,null,"PAYE",null,"Portfolio",null,null,null,null,null,null,"PAYE",null,"Portfolio"]
[{"$f":"IF(Data!C9=\"Weekly\",\"Weekly Gross Income\",IF(Data!C9=\"Fortnightly\",\"Fortnightly Gross Income\",IF(Data!C9=\"Monthly\",\"Monthly Gross Income\",\"4 Weekly Gross Income\")))","v":"Weekly Gross Income"}]
[null,"UNIT",null,"RATE"]
["Funds Received",{"$f":"IF(Data!$C$23>0,Data!$C$23,Data!$C$21)","v":0},"@",{"$f":"Data!C19","v":0},null,{"$f":"IF(Data!C5<>\"\",Data!$C$25,\"\")","v":0},{"$f":"'Agency Report'!G5","v":0},"@",{"$f":"'Agency Report'!G6","v":0},{"$f":"'Agency Report'!G5*'Agency Report'!G6","v":0},null,null,"Employee Income",null,null,null,{"$f":"J30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Holiday Pay",null,null,null,{"$f":"IF(Data!L16=\"NO\",'Calculation a'!I28,0)","v":0}]
["Minimum Wage",null,null,null,null,null,null,null,{"$f":"'.'!D13","v":0},null,null,null,"Taxable Income",null,{"$f":"F7","v":0},null,{"$f":"Q7+Q8","v":0}]
["HP on Minimum Wage",null,null,null,null,null,null,null,{"$f":"ROUND(I9*Data!C17,2)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"ROUND((IF(Data!$C$9=\"Weekly\",'.'!$A$3,0)),2)","v":166}]
["Auto-enrolment - Employer",null,null,null,null,null,null,null,{"$f":"ROUND(IF(Data!L17=\"yes\",IF(IF(Data!C9=\"Weekly\",IF(SUM(I9:I10)>'.'!E22,'.'!E22-'.'!E21,SUM(I9:I10)-'.'!E21),IF(Data!C9=\"Fortnightly\",IF(SUM(I9:I10)>'.'!F22,'.'!F22-'.'!F21,SUM(I9:I10)-'.'!F21),IF(Data!C9=\"4 Weekly\",IF(SUM(I9:I10)>'.'!H22,'.'!H22-'.'!H21,SUM(I9:I10)-'.'!H21),IF(Data!C9=\"Monthly\",IF(SUM(I9:I10)>'.'!G22,'.'!G22-'.'!G21,SUM(I9:I10)-'.'!G21),0))))<0,0,IF(Data!C9=\"Weekly\",IF(SUM(I9:I10)>'.'!E22,'.'!E22-'.'!E21,SUM(I9:I10)-'.'!E21),IF(Data!C9=\"Fortnightly\",IF(SUM(I9:I10)>'.'!F22,'.'!F22-'.'!F21,SUM(I9:I10)-'.'!F21),IF(Data!C9=\"4 Weekly\",IF(SUM(I9:I10)>'.'!H22,'.'!H22-'.'!H21,SUM(I9:I10)-'.'!H21),IF(Data!C9=\"Monthly\",IF(SUM(I9:I10)>'.'!G22,'.'!G22-'.'!G21,SUM(I9:I10)-'.'!G21),0)))))*'.'!B22,0),2)","v":0},null,null,null,"ERP - Reportable",null,null,null,{"$f":"IF(Data!L17=\"yes\",IF(IF(Data!C9=\"Weekly\",IF(Q9>'.'!E22,'.'!E22-'.'!E21,Q9-'.'!E21),IF(Data!C9=\"Fortnightly\",IF(Q9>'.'!F22,'.'!F22-'.'!F21,Q9-'.'!F21),IF(Data!C9=\"4 Weekly\",IF(Q9>'.'!H22,'.'!H22-'.'!H21,Q9-'.'!H21),IF(Data!C9=\"Monthly\",IF(Q9>'.'!G22,'.'!G22-'.'!G21,Q9-'.'!G21),0))))<0,0,IF(Data!C9=\"Weekly\",IF(Q9>'.'!E22,'.'!E22-'.'!E21,Q9-'.'!E21),IF(Data!C9=\"Fortnightly\",IF(Q9>'.'!F22,'.'!F22-'.'!F21,Q9-'.'!F21),IF(Data!C9=\"4 Weekly\",IF(Q9>'.'!H22,'.'!H22-'.'!H21,Q9-'.'!H21),IF(Data!C9=\"Monthly\",IF(Q9>'.'!G22,'.'!G22-'.'!G21,Q9-'.'!G21),0)))))*'.'!B22,0)","v":0}]
["Apprenticeship Levy",null,null,null,null,null,null,null,{"$f":"ROUND(SUM(I9:I10)*'.'!B5,2)","v":0}]
["ERNIC on Minimum Wage",null,null,null,null,null,null,null,{"$f":"ROUND(IF(IF(Data!C5<>\"\",IF('Calculation a'!I9+I10>'.'!A3,(IF(Data!C9=\"Monthly\",+('Calculation a'!I9+I10-'.'!C3)*0.138,(IF(Data!C9=\"Fortnightly\",+('Calculation a'!I9+I10-'.'!B3)*0.138,(IF(Data!C9=\"4 weekly\",+('Calculation a'!I9+I10-'.'!D3)*0.138,('Calculation a'!I9+I10-'.'!A3)*0.138)))))),0),\"\")<0,0,IF(Data!C5<>\"\",IF('Calculation a'!I9+I10>'.'!A3,(IF(Data!C9=\"Monthly\",+('Calculation a'!I9+I10-'.'!C3)*0.138,(IF(Data!C9=\"Fortnightly\",+('Calculation a'!I9+I10-'.'!B3)*0.138,(IF(Data!C9=\"4 weekly\",+('Calculation a'!I9+I10-'.'!D3)*0.138,('Calculation a'!I9+I10-'.'!A3)*0.138)))))),0),\"\")),2)","v":0},null,null,null,"Income Tax",{"$f":"IF(Data!F7=\"S\",'PAYE rates'!B39,'PAYE rates'!B19)","v":0},null,{"$f":"IF(Data!F7=\"S\",'Umbrella rates'!B39,'Umbrella rates'!B19)","v":0},null,null,{"$f":"ROUND((IF(Data!$C$9=\"Fortnightly\",'.'!$B$3)),2)","v":0}]
["Amount for Deduction",null,null,null,null,null,null,null,{"$f":"J7-SUM(I9:I13)","v":0},null,null,null,"Employee's National Insurance",{"$f":"IF(Data!L15=\"YES\",0,'PAYE rates'!B56)","v":0},null,{"$f":"IF(Data!L15=\"YES\",0,'Umbrella rates'!B56)","v":0},null,null,{"$f":"ROUND((IF(Data!$C$9=\"Monthly\",'.'!$C$3)),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Student Loan",{"$f":"ROUNDDOWN(IF(Data!L13=\"Plan 1\",'.'!F25,IF(Data!L13=\"Plan 2\",'.'!F26,0)),0)","v":0},null,{"$f":"ROUNDDOWN(IF(Data!L13=\"Plan 1\",'.'!G25,IF(Data!L13=\"Plan 2\",'.'!G26,0)),0)","v":0},null,null,{"$f":"ROUND((IF(Data!$C$9=\"4 weekly\",'.'!$D$3,0)),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Post Graduate Loan",{"$f":"ROUNDDOWN(IF(Data!L14=\"YES\",'.'!F27,0),0)","v":0},{"$f":"IF(Data!C5<>\"\",SUM(N13:N16),\"\")","v":0},{"$f":"ROUNDDOWN(IF(Data!L14=\"YES\",'.'!G27,0),0)","v":0},{"$f":"IF(Data!C5<>\"\",SUM(P13:P16),\"\")","v":0},null,{"$f":"SUM(S10:S15)*Data!L22","v":166}]
["Expenditure"]
["Margin",null,null,null,null,null,null,null,{"$f":"IF(K21<0,0,K21)","v":0},null,null,null,"Net Salary",null,{"$f":"IF(Data!C5<>\"\",O9-O16,\"\")","v":0},null,{"$f":"IF(Data!C5<>\"\",Q9-Q16,\"\")","v":0}]
["Expenses",null,null,null,null,null,null,null,{"$f":"IF(I14<0,0,IF(Data!M7>'.'!D14,'.'!D14,Data!M7))","v":0},{"$f":"IF(Data!C5<>\"\",I19+I18,\"\")","v":0},null,null,"Expenses",null,null,null,{"$f":"I19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Auto-enrolment - Employee",null,{"$f":"IF(Data!L17=\"yes\",(IF(IF(Data!C9=\"Weekly\",IF(O9>'.'!E22,'.'!E22-'.'!E21,O9-'.'!E21),IF(Data!C9=\"Fortnightly\",IF(O9>'.'!F22,'.'!F22-'.'!F21,O9-'.'!F21),IF(Data!C9=\"4 Weekly\",IF(O9>'.'!H22,'.'!H22-'.'!H21,O9-'.'!H21),IF(Data!C9=\"Monthly\",IF(O9>'.'!G22,'.'!G22-'.'!G21,O9-'.'!G21),0))))<0,0,IF(Data!C9=\"Weekly\",IF(O9>'.'!E22,'.'!E22-'.'!E21,O9-'.'!E21),IF(Data!C9=\"Fortnightly\",IF(O9>'.'!F22,'.'!F22-'.'!F21,O9-'.'!F21),IF(Data!C9=\"4 Weekly\",IF(O9>'.'!H22,'.'!H22-'.'!H21,O9-'.'!H21),IF(Data!C9=\"Monthly\",IF(O9>'.'!G22,'.'!G22-'.'!G21,O9-'.'!G21),0)))))*'.'!B21)*'.'!C20,0)","v":0},null,{"$f":"IF(Data!L17=\"yes\",(IF(IF(Data!C9=\"Weekly\",IF(Q9>'.'!E22,'.'!E22-'.'!E21,Q9-'.'!E21),IF(Data!C9=\"Fortnightly\",IF(Q9>'.'!F22,'.'!F22-'.'!F21,Q9-'.'!F21),IF(Data!C9=\"4 Weekly\",IF(Q9>'.'!H22,'.'!H22-'.'!H21,Q9-'.'!H21),IF(Data!C9=\"Monthly\",IF(Q9>'.'!G22,'.'!G22-'.'!G21,Q9-'.'!G21),0))))<0,0,IF(Data!C9=\"Weekly\",IF(Q9>'.'!E22,'.'!E22-'.'!E21,Q9-'.'!E21),IF(Data!C9=\"Fortnightly\",IF(Q9>'.'!F22,'.'!F22-'.'!F21,Q9-'.'!F21),IF(Data!C9=\"4 Weekly\",IF(Q9>'.'!H22,'.'!H22-'.'!H21,Q9-'.'!H21),IF(Data!C9=\"Monthly\",IF(Q9>'.'!G22,'.'!G22-'.'!G21,Q9-'.'!G21),0)))))*'.'!B21)*'.'!C20,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(IF(J7=0,0,IF(J7*Data!C13<Data!C15,Data!C15,IF(J7*Data!C13>Data!C14,Data!C14,J7*Data!C13)))>I14,I14,IF(J7=0,0,IF(J7*Data!C13<Data!C15,Data!C15,IF(J7*Data!C13>Data!C14,Data!C14,J7*Data!C13))))","v":0},null,"Payment to Bank Account",null,{"$f":"IF(Data!C5<>\"\",SUM(O18:O19)-O20,\"\")","v":0},null,{"$f":"IF(Data!C5<>\"\",SUM(Q18:Q19)-Q20,\"\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Transfer to Holiday Pay Reserve",null,null,null,{"$f":"IF(Data!L16=\"NO\",0,'Calculation a'!I28)","v":0}]
[]
["Income",null,null,null,null,null,null,null,null,{"$f":"J7-J19","v":0},null,null,"ERP- Reportable Reserve",null,null,null,{"$f":"I25-Q11","v":0}]
["Auto-enrolment - Employer",null,null,null,null,null,null,null,{"$f":"ROUND(IF(Data!L17=\"yes\",IF(IF(Data!C9=\"Weekly\",IF(J24-I27-I26>'.'!E22,'.'!E22-'.'!E21,J24-I27-I26-'.'!E21),IF(Data!C9=\"Fortnightly\",IF(J24-I27-I26>'.'!F22,'.'!F22-'.'!F21,J24-I27-I26-'.'!F21),IF(Data!C9=\"4 Weekly\",IF(J24-I27-I26>'.'!H22,'.'!H22-'.'!H21,J24-I27-I26-'.'!H21),IF(Data!C9=\"Monthly\",IF(J24-I27-I26>'.'!G22,'.'!G22-'.'!G21,J24-I27-I26-'.'!G21),0))))<0,0,IF(Data!C9=\"Weekly\",IF(J24-I27-I26-I25>'.'!E22,('.'!E22-'.'!E21)*'.'!B22,(J24-I27-I26-'.'!E21)*'.'!B22/(1+'.'!B22)),IF(Data!C9=\"Fortnightly\",IF(J24-I27-I26-I25>'.'!F22,('.'!F22-'.'!F21)*'.'!B22,(J24-I27-I26-'.'!F21)*'.'!B22/(1+'.'!B22)),IF(Data!C9=\"4 Weekly\",IF(J24-I27-I26-I25>'.'!H22,('.'!H22-'.'!H21)*'.'!B22,(J24-I27-I26-I25-'.'!H21)*'.'!B22/(1+'.'!B22)),IF(Data!C9=\"Monthly\",IF(J24-I27-I26>'.'!G22,('.'!G22-'.'!G21)*'.'!B22,(J24-I27-I26-'.'!G21)*'.'!B22/(1+'.'!B22)),0))))),0),2)","v":0},null,null,null,"Percentage Take-home",null,{"$f":"IF(Data!C5<>\"\",IF(F7=0,0,+O21/F7),\"\")","v":0},null,{"$f":"IF(Data!C5<>\"\",IF(J7=0,0,+Q21/J7),\"\")","v":0}]
["Apprenticeship Levy",null,null,null,null,null,null,null,{"$f":"ROUND((J24-I27-I25)*'.'!B5/(1+'.'!B5),2)","v":0}]
["Employer's National Insurance",null,null,null,null,null,null,null,{"$f":"ROUND(IF(J24-I25-I26-S16<0,0,(J24-I25-I26-S16)*'.'!A1/(1+'.'!A1)),2)","v":0},null,null,null,{"$f":"IF(Data!$C$31=\"yes\",\"Employer's National Insurance under PAYE\",\"\")","v":"Employer's National Insurance under PAYE"},null,{"$f":"IF(IJ44<0,0,IJ44)","v":0},null,{"$f":"O27","v":0}]
["Holiday Pay",null,null,null,null,null,null,null,{"$f":"ROUND(IF(J24<0,0,(J24-I27-I25-I26)*Data!C17/(1+Data!C17)),2)","v":0},{"$f":"SUM(I25:I28)","v":0},null,null,{"$f":"IF(Data!$C$31=\"yes\",\"Employer's National Paid by AGENCY\",\"\")","v":"Employer's National Paid by AGENCY"},null,{"$f":"IF(Data!C31=\"YES\",O27,0)","v":0},null,{"$f":"IF(Data!L3=\"Agency\",IF(Data!C5<>\"\",0,\"\"),\"\")","v":0}]
[]
["Employee Income",null,null,null,null,{"$f":"+F7","v":0},null,null,null,{"$f":"IF(Data!C5<>\"\",+J24-J28,\"\")","v":0},null,null,{"$f":"IF(Data!$C$31=\"yes\",\"Saving in Employer's National Insurance\",\"\")","v":"Saving in Employer's National Insurance"},null,{"$f":"IF(Data!L3=\"Agency\",IF(Data!C5<>\"\",O27-O28,\"\"),\"\")","v":0},null,{"$f":"IF(Data!L3=\"Agency\",IF(Data!C5<>\"\",Q27-Q28,0),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$C$31=\"Yes\",\"Percentage Agency  Saving\",\"\")","v":"Percentage Agency  Saving"},null,{"$f":"IF(Data!L3=\"Agency\",IF(Data!C5<>\"\",IF(F7=0,0,O30/O27),\"\"),\"\")","v":0},null,{"$f":"IF(Data!L3=\"Agency\",IF(Data!C5<>\"\",IF(J7=0,0,Q30/Q27),\"\"),\"\")","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!L3=\"Agency\",IF(Data!C31=\"yes\",IF(Data!C9=\"monthly\",('Calculation a'!F7-'.'!C3)*'.'!A1,(IF(Data!C9=\"4 Weekly\",('Calculation a'!F7-'.'!D3)*'.'!A1,IF(Data!C9=\"Fortnightly\",('Calculation a'!F7-'.'!B3)*'.'!A1,('Calculation a'!F7-'.'!A3)*'.'!A1))))),\"\")","v":-22.908000000000001}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!L3=\"Agency\",1,0)","v":1}]

{"sheet":"Calculation","index":3,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":true,"merged":[[4,6,4,9],[1,0,1,3],[3,4,3,5],[3,6,3,9]]}
[]
[]
[]
[null,null,null,null,"PAYE",null,"Portfolio"]
[{"$f":"IF(Data!C9=\"Weekly\",\"Weekly Gross Income\",IF(Data!C9=\"Fortnightly\",\"Fortnightly Gross Income\",IF(Data!C9=\"Monthly\",\"Monthly Gross Income\",\"4 Weekly Gross Income\")))","v":"Weekly Gross Income"}]
[null,"UNIT",null,"RATE"]
["Funds Received",{"$f":"'Calculation a'!B7","v":0},"@",{"$f":"'Calculation a'!D7","v":0},null,{"$f":"'Calculation a'!F7","v":0},{"$f":"'Calculation a'!G7","v":0},"@",{"$f":"'Calculation a'!I7","v":0},{"$f":"'Calculation a'!J7","v":0}]
[]
["Expenditure",null,null,null,null,null,null,null,null,null,null,"Employers Outgoings"]
["Margin",null,null,null,null,null,null,null,{"$f":"'Calculation a'!I18","v":0},null,null,"Employer’s National Insurance",{"$f":"'Calculation a'!I27","v":0}]
["Employers Outgoings",null,null,null,null,null,null,null,{"$f":"SUM(M10:M12)","v":0},null,null,"Apprenticeship Levy",{"$f":"'Calculation a'!I26","v":0}]
["Holiday Pay",null,null,null,null,null,null,null,{"$f":"'Calculation a'!I28","v":0},null,null,"Employer’s Pension Contribution",{"$f":"'Calculation a'!I25","v":0}]
["Expenses",null,null,null,null,null,null,null,{"$f":"'Calculation a'!I19","v":0},{"$f":"SUM(I10:I13)","v":0},null,null,{"$f":"SUM(M10:M12)","v":0}]
[]
["Gross Salary",null,null,null,null,null,null,null,null,{"$f":"'Calculation a'!Q7","v":0}]
["Holiday Pay",null,null,null,null,null,null,null,null,{"$f":"'Calculation a'!Q8","v":0}]
["Taxable Income",null,null,null,null,{"$f":"F7","v":0},null,null,null,{"$f":"'Calculation a'!Q9","v":0}]
[]
["Income Tax",null,null,null,{"$f":"'Calculation a'!N13","v":0},null,null,null,{"$f":"'Calculation a'!P13","v":0}]
["Employee's National Insurance",null,null,null,{"$f":"'Calculation a'!N14","v":0},null,null,null,{"$f":"'Calculation a'!P14","v":0}]
["Student Loan",null,null,null,{"$f":"'Calculation a'!N15","v":0},null,null,null,{"$f":"'Calculation a'!P15","v":0}]
["Post Graduate Loan",null,null,null,{"$f":"'Calculation a'!N16","v":0},{"$f":"'Calculation a'!O16","v":0},null,null,{"$f":"'Calculation a'!P16","v":0},{"$f":"'Calculation a'!Q16","v":0}]
[]
["Net Salary",null,null,null,null,{"$f":"'Calculation a'!O18","v":0},null,null,null,{"$f":"'Calculation a'!Q18","v":0}]
["Expenses",null,null,null,null,null,null,null,null,{"$f":"'Calculation a'!Q19","v":0}]
[]
["Employee’s Pension Contribution",null,null,null,null,{"$f":"'Calculation a'!O20","v":0},null,null,null,{"$f":"'Calculation a'!Q20","v":0}]
["Payment to Bank Account",null,null,null,null,{"$f":"'Calculation a'!O21","v":0},null,null,null,{"$f":"ROUND('Calculation a'!Q21,2)","v":0}]
[]
["Transfer to Holiday Pay Reserve",null,null,null,null,null,null,null,null,{"$f":"'Calculation a'!Q22","v":0}]
["ERP- Reportable Reserve",null,null,null,null,null,null,null,null,{"$f":"'Calculation a'!Q24","v":0}]
[]
["Percentage Take-home",null,null,null,null,{"$f":"IF(Data!C5<>\"\",IF(F7=0,0,+F28/F7),\"\")","v":0},null,null,null,{"$f":"IF(Data!C5<>\"\",IF(J7=0,0,+J28/J7),\"\")","v":0}]
["Agency’s PAYE Liabilities"]
[{"$f":"IF(Data!$C$31=\"yes\",\"Employer's National Insurance\",\"\")","v":"Employer's National Insurance"},null,null,null,null,{"$f":"'Calculation a'!O27","v":0},null,null,null,0]
["Apprenticeship Levy",null,null,null,null,{"$f":"F17*0.5%","v":0},null,null,null,0]
["Employer’s Pension Contribution",null,null,null,null,{"$f":"IF(Data!L17=\"yes\",IF(IF(Data!C9=\"Weekly\",IF(F7>'.'!E22,'.'!E22-'.'!E21,F7-'.'!E21),IF(Data!C9=\"Fortnightly\",IF(F7>'.'!F22,'.'!F22-'.'!F21,F7-'.'!F21),IF(Data!C9=\"4 Weekly\",IF(F7>'.'!H22,'.'!H22-'.'!H21,F7-'.'!H21),IF(Data!C9=\"Monthly\",IF(F7>'.'!G22,'.'!G22-'.'!G21,F7-'.'!G21),0))))<0,0,IF(Data!C9=\"Weekly\",IF(F7>'.'!E22,'.'!E22-'.'!E21,F7-'.'!E21),IF(Data!C9=\"Fortnightly\",IF(F7>'.'!F22,'.'!F22-'.'!F21,F7-'.'!F21),IF(Data!C9=\"4 Weekly\",IF(F7>'.'!H22,'.'!H22-'.'!H21,F7-'.'!H21),IF(Data!C9=\"Monthly\",IF(F7>'.'!G22,'.'!G22-'.'!G21,F7-'.'!G21),0)))))*'.'!B22,0)","v":0},null,null,null,0]
["Total",null,null,null,null,{"$f":"SUM(F35:F37)","v":0},null,null,null,0]
["Total Agency Saving",null,null,null,null,{"$f":"IF(Data!L3=\"Agency\",IF(Data!C5<>\"\",0,\"\"),\"\")","v":0},null,null,null,{"$f":"IF(Data!L3=\"Agency\",IF(Data!C5<>\"\",F38-J38,0),0)","v":0}]
[{"$f":"IF(Data!$C$31=\"Yes\",\"Percentage Agency  Saving\",\"\")","v":"Percentage Agency  Saving"},null,null,null,null,{"$f":"IF(Data!L3=\"Agency\",IF(Data!C5<>\"\",IF(F7=0,0,F39/F35),\"\"),\"\")","v":0},null,null,null,{"$f":"IF(Data!L3=\"Agency\",IF(Data!C5<>\"\",IF(J7=0,0,J39/F38),\"\"),\"\")","v":0}]

{"sheet":"PAYE VS Portfolio","index":4,"n_rows":41,"n_cols":16376,"rows_kept":41,"cut":false,"hidden":true,"merged":[[4,6,4,9],[4,13,4,14],[1,0,1,3],[3,4,3,5],[3,11,3,12],[3,13,3,14],[3,6,3,9]]}
[]
[]
[]
[null,null,null,null,"PAYE",null,"Portfolio",null,null,null,null,"PAYE",null,"Portfolio"]
[{"$f":"IF(Data!C9=\"Weekly\",\"Weekly Gross Income\",IF(Data!C9=\"Fortnightly\",\"Fortnightly Gross Income\",IF(Data!C9=\"Monthly\",\"Monthly Gross Income\",\"4 Weekly Gross Income\")))","v":"Weekly Gross Income"}]
[null,"UNIT",null,"RATE"]
["Funds Received",{"$f":"'Calculation a'!B7","v":0},"@",{"$f":"'Calculation a'!D7","v":0},null,{"$f":"'Calculation a'!F7","v":0},{"$f":"'Calculation a'!G7","v":0},"@",{"$f":"'Calculation a'!I7","v":0},{"$f":"'Calculation a'!J7","v":0},"Taxable Income",null,null,null,{"$f":"'Calculation a'!Q7","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Holiday Pay (advance payment from Holiday Pay Reserve)",null,null,null,{"$f":"'Calculation a'!Q8","v":0}]
["Minimum Wage",null,null,null,null,null,null,null,{"$f":"'Calculation a'!I9","v":0},null,"Gross Salary",null,{"$f":"'Calculation a'!O9","v":0},null,{"$f":"'Calculation a'!Q9","v":0}]
["HP on Minimum Wage",null,null,null,null,null,null,null,{"$f":"'Calculation a'!I10","v":0}]
["ERNIC on Minimum Wage",null,null,null,null,null,null,null,{"$f":"'Calculation a'!I13","v":0},null,"Income Tax",{"$f":"'Calculation a'!N13","v":0},null,{"$f":"'Calculation a'!P13","v":0}]
["Amount for Deduction",null,null,null,null,null,null,null,{"$f":"'Calculation a'!I14","v":0},null,"Employee's National Insurance",{"$f":"'Calculation a'!N16","v":0},{"$f":"'Calculation a'!O16","v":0},{"$f":"'Calculation a'!P16","v":0},{"$f":"'Calculation a'!Q16","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Net Salary",null,{"$f":"'Calculation a'!O18","v":0},null,{"$f":"'Calculation a'!Q18","v":0}]
["Expenditure",null,null,null,null,null,null,null,null,null,"Expenses",null,null,null,{"$f":"'Calculation a'!Q19","v":0}]
["Margin",null,null,null,null,null,null,null,{"$f":"'Calculation a'!I18","v":0}]
["Expenses",null,null,null,null,null,null,null,{"$f":"'Calculation a'!I19","v":0},{"$f":"'Calculation a'!J19","v":0},"Payment to Bank Account",null,{"$f":"'Calculation a'!O21","v":0},null,{"$f":"'Calculation a'!Q21","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Transfer to Holiday Pay Reserve",null,null,null,{"$f":"'Calculation a'!Q22","v":0}]
[]
["Income",null,null,null,null,null,null,null,null,{"$f":"'Calculation a'!J24","v":0},"Percentage Take-home",null,{"$f":"'Calculation a'!O25","v":0},null,{"$f":"'Calculation a'!Q25","v":0}]
["Employer's National Insurance",null,null,null,null,null,null,null,{"$f":"'Calculation a'!I27","v":0}]
["Transfer to Holiday Pay Reserve",null,null,null,null,null,null,null,{"$f":"'Calculation a'!I28","v":0},{"$f":"'Calculation a'!J28","v":0},{"$f":"IF(Data!$C$31=\"yes\",\"Employer's National Insurance under PAYE\",\"\")","v":"Employer's National Insurance under PAYE"},null,{"$f":"'Calculation a'!O27","v":0},null,{"$f":"'Calculation a'!Q27","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$C$31=\"yes\",\"Employer's National Paid by AGENCY\",\"\")","v":"Employer's National Paid by AGENCY"},null,{"$f":"'Calculation a'!O28","v":0},null,{"$f":"'Calculation a'!Q28","v":0}]
["Taxable Income",null,null,null,null,{"$f":"'Calculation a'!F30","v":0},null,null,null,{"$f":"'Calculation a'!J30","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$C$31=\"yes\",\"Saving in Employer's National Insurance\",\"\")","v":"Saving in Employer's National Insurance"},null,{"$f":"'Calculation a'!O30","v":0},null,{"$f":"'Calculation a'!Q30","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$C$31=\"Yes\",\"Percentage Agency  Saving\",\"\")","v":"Percentage Agency  Saving"},null,{"$f":"'Calculation a'!O32","v":0},null,{"$f":"'Calculation a'!Q32","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!L3=\"Agency\",IF(Data!C31=\"yes\",IF(Data!C9=\"monthly\",('PAYE VS Portfolio'!F7-'.'!C3)*'.'!A1,(IF(Data!C9=\"4 Weekly\",('PAYE VS Portfolio'!F7-'.'!D3)*'.'!A1,IF(Data!C9=\"Fortnightly\",('PAYE VS Portfolio'!F7-'.'!B3)*'.'!A1,('PAYE VS Portfolio'!F7-'.'!A3)*'.'!A1))))),\"\")","v":-22.908000000000001}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!L3=\"Agency\",1,0)","v":1}]

{"sheet":"Agency Report","index":5,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":true,"merged":[[1,2,2,4],[1,5,2,7]]}
[]
[null,null,"PAYE",null,null,"Portfolio     "]
[]
[]
[null,null,"UNITS",{"$f":"IF(Data!$C$23>0,Data!$C$23,Data!$C$21)","v":0},null,"UNITS",{"$f":"IF(Data!$C$23>0,Data!$C$23,Data!$C$21)","v":0}]
["RATES",null,"RATE",{"$f":"IF(Data!L3=\"Agency\",Data!C19,\"\")","v":0},null,"RATE",{"$f":"ROUND(Sheet1!C31,2)","v":0}]
[]
["Total Gross For"]
["All Candidates",null,null,{"$f":"IF(Data!L3=\"Agency\",D15*Data!C3,\"\")","v":0},null,null,{"$f":"IF(Data!L3=\"Agency\",Data!C3*'Agency Report'!G15,\"\")","v":0}]
[]
["Total ERNI for"]
["All Candidates",null,null,{"$f":"IF(Data!L3=\"Agency\",D21*Data!C3,\"\")","v":0},null,null,0]
[]
["Gross pay"]
["per Candidate",null,null,{"$f":"IF(Data!L3=\"Agency\",'Calculation a'!F7,\"\")","v":0},null,null,{"$f":"IF(Data!L3=\"Agency\",G5*G6,0)-ROUND(IF(Data!L16=\"NO\",0,(G5*G6)*Data!C17),2)","v":0}]
[]
["Net Pay"]
["per Candidate",null,null,{"$f":"IF(Data!L3=\"Agency\",'Calculation a'!O21,\"\")","v":0},null,null,{"$f":"IF(Data!L3=\"Agency\",'Calculation a'!Q21,\"\")","v":0}]
[]
["ERNI payable"]
["per Candidate",null,null,{"$f":"'Calculation a'!O28","v":0},null,null,0]
[]
["Agency ERNI Saving"]
["per Candidate",null,null,{"$f":"IF(Data!L3=\"Agency\",'Calculation a'!F42-'Calculation a'!F43,\"\")","v":0},null,null,{"$f":"'Calculation a'!Q30-('Calculation a'!J7-'Calculation a'!F7)","v":0}]
[]
["Overall Saving"]
["All Candidates",null,null,{"$f":"IF(Data!L3=\"Agency\",D24*Data!$C$3,\"\")","v":0},null,null,{"$f":"IF(Data!L3=\"Agency\",G24*Data!$C$3,\"\")","v":0}]

{"sheet":".","index":6,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[0.13800000000000001,"Employers NI Allowance",null,null,null,null,null,null,null,"Fees"]
["Weekly","Fortnightly","Monthly","4 Weekly",null,null,null,null,null,"Education","Non-Educatiion"]
[166,{"$f":"A3*2","v":332},719,{"$f":"A3*4","v":664},null,null,"Weekly",null,"Precent",0.04,0.04,{"$f":"IF(Data!$C$5='.'!$H$16,'.'!K3,'.'!J3)","v":0.04}]
[null,null,null,null,null,null,null,null,"Max",16,16,{"$f":"IF(Data!$C$5='.'!$H$16,'.'!K4,'.'!J4)","v":16}]
["Apprenticeship Levy",5.0000000000000001E-3,null,"Min WAGE",8.2100000000000009,null,null,null,"Min",0,0,{"$f":"IF(Data!$C$5='.'!$H$16,'.'!K5,'.'!J5)","v":0}]
[null,null,null,null,null,null,"Fortnightly",null,"Precent",0.04,0.04,{"$f":"IF(Data!$C$5='.'!$H$16,'.'!K6,'.'!J6)","v":0.04}]
[null,"Weekly Salary","Fortnightly Salary","4 weekly","monthly Salary","Yearly Salary",null,null,"Max",32,32,{"$f":"IF(Data!$C$5='.'!$H$16,'.'!K7,'.'!J7)","v":32}]
["Edu",{"$f":"Data!C21*'.'!$A$18*E5","v":0},{"$f":"Data!C21*'.'!$A$18*E5","v":0},{"$f":"Data!C21*'.'!$A$18*E5","v":0},{"$f":"Data!C21*'.'!$A$18*E5","v":0},null,null,null,"Min",0,0,{"$f":"IF(Data!$C$5='.'!$H$16,'.'!K8,'.'!J8)","v":0}]
["Rest",{"$f":"Data!C21*'.'!$C$18*E5","v":0},{"$f":"Data!C21*'.'!C18*E5","v":0},{"$f":"Data!C21*'.'!C18*E5","v":0},{"$f":"Data!C21*'.'!C18*E5","v":0},null,"4 weekly/Monthly",null,"Precent",0.04,0.04,{"$f":"IF(Data!$C$5='.'!$H$16,'.'!K9,'.'!J9)","v":0.04}]
["Port",{"$f":"Data!C21*'.'!$D$18*E5","v":0},{"$f":"Data!C21*'.'!$D$18*E5","v":0},{"$f":"Data!C21*'.'!$D$18*E5","v":0},{"$f":"Data!C21*'.'!$D$18*E5","v":0},null,null,null,"Max",60,60,{"$f":"IF(Data!$C$5='.'!$H$16,'.'!K10,'.'!J10)","v":60}]
[null,{"$f":"Data!C21*'.'!$B$18*E5","v":0},{"$f":"Data!C21*'.'!B18*E5","v":0},{"$f":"Data!C21*'.'!B18*E5","v":0},{"$f":"Data!C21*'.'!B18*E5","v":0},null,null,null,"Min",0,0,{"$f":"IF(Data!$C$5='.'!$H$16,'.'!K11,'.'!J11)","v":0}]
[null,null,null,null,null,{"$f":"IF(Data!C5<>\"\",IF('Calculation a'!J24>A3,(IF(Data!C9=\"Monthly\",+('Calculation a'!J24-C3)*0.138/1.138,(IF(Data!C9=\"Fortnightly\",+('Calculation a'!J24-B3)*0.138/1.138,(IF(Data!C9=\"4 weekly\",+('Calculation a'!J24-D3)*0.138/1.138,('Calculation a'!J24-A3)*0.138/1.138)))))),0),\"\")","v":0},null,"Drop downs"]
[null,"Threshold","Min wage",{"$f":"IF(Data!C23>0,Data!C23*'.'!E5,IF(Data!C5=\"Education\",A18*Data!C21*E5+F13,IF(Data!C5='.'!H15,'.'!D18*Data!C21*'.'!E5+F13,IF(Data!C5='.'!H16,'.'!D18*Data!C21*'.'!E5+F13,D18*Data!C21*E5+F13))))","v":0},null,0,null,null,"Frequency"]
[null,null,"Expenses",{"$f":"'Calculation a'!I14-'Calculation a'!I18","v":0},null,null,"1250L","Education","Weekly","YES"]
[null,null,null,null,null,null,"0T","Medical And Social Care","Fortnightly","NO"]
["Sector Days",null,null,null,null,null,"BR","Other Industries","Monthly","Please Select"]
["Education",7.5,"REST","Portfolio",null,null,"D0",null,"4 Weekly"]
[6,7.5,8,7,null,null,"D1"]
[null,null,null,null,null,null,"D2"]
["Auto-enrolment",null,0.8,null,"Weekly","Fortnightly","Monthly","4 Weekly"]
["Employee",0.05,null,"Low",118,{"$f":"E21*2","v":236},512,{"$f":"E21*4","v":472}]
["Employer",0.03,null,"Higher",962,1924,4167,3847]
[]
[null,"Week","Month","%","Threshold","PAYE","Umbrella",null,"Employee Age ","Minimum Hourly Umbrella Rate ","Minimum Daily Umbrella Rate"]
["Plan 1",364,1577,0.09,{"$f":"IF(Data!C9=\"WEEKLY\",'.'!B25,IF(Data!C9=\"Fortnightly\",'.'!B25*2,IF(Data!C9=\"Monthly\",'.'!C25,'.'!B25*4)))*Data!L22","v":364},{"$f":"IF('Calculation a'!O9>'.'!E25,('Calculation a'!O9-'.'!E25)*'.'!D25,0)","v":0},{"$f":"IF('Calculation a'!Q9>'.'!E25,('Calculation a'!Q9-'.'!E25)*'.'!D25,0)","v":0},null,null,null,"(6.5 Hour Day)"]
["Plan 2",494,2143,0.09,{"$f":"IF(Data!C9=\"WEEKLY\",'.'!B26,IF(Data!C9=\"Fortnightly\",'.'!B26*2,IF(Data!C9=\"Monthly\",'.'!C26,'.'!B26*4)))*Data!L22","v":494},{"$f":"IF('Calculation a'!O9>'.'!E26,('Calculation a'!O9-'.'!E26)*'.'!D26,0)","v":0},{"$f":"IF('Calculation a'!Q9>'.'!E26,('Calculation a'!Q9-'.'!E26)*'.'!D26,0)","v":0},null,"25 or over",10.3,66.95]
["PG",404,1750,0.06,{"$f":"IF(Data!C9=\"WEEKLY\",'.'!B27,IF(Data!C9=\"Fortnightly\",'.'!B27*2,IF(Data!C9=\"Monthly\",'.'!C27,'.'!B27*4)))*Data!L22","v":404},{"$f":"IF('Calculation a'!O9>'.'!E27,('Calculation a'!O9-'.'!E27)*'.'!D27,0)","v":0},{"$f":"IF('Calculation a'!Q9>'.'!E27,('Calculation a'!Q9-'.'!E27)*'.'!D27,0)","v":0},null,"21-24",9.6,62.4]
[null,null,null,null,null,null,null,null,"18-20",7.55,49.08]
[null,null,null,null,null,null,null,null,"Under 18",5.75,37.380000000000003]

{"sheet":"Umbrella rates","index":7,"n_rows":77,"n_cols":26,"rows_kept":77,"cut":false,"hidden":true,"merged":[[65,15,65,16],[27,3,27,4],[27,7,27,8],[27,11,27,12],[47,15,47,16],[60,6,62,10],[64,1,64,2],[65,3,65,4],[65,7,65,8],[65,11,65,12],[1,1,1,6],[1,8,1,13],[7,1,7,2],[8,3,8,4],[8,7,8,8],[8,11,8,12],[8,15,8,16],[43,4,44,8],[46,1,46,2],[47,3,47,4],[47,7,47,8],[47,11,47,12],[22,6,24,10],[26,1,26,2],[27,15,27,16]]}
[]
[null,"Scroll down for Scottish Tax Bands and Pension Calculations",null,null,null,null,null,null,"Input the Annual Allowance and Total Taxable Income and the calculations will be made for you!"]
[]
[null,"Annual Allowance",{"$f":"F4","v":12500},null,{"$f":"Data!C7","v":"1250L"},{"$f":"IF(RIGHT(E4,1)=\"L\",E5,IF(RIGHT(E4,1)=\"M\",E5,IF(RIGHT(E4,1)=\"n\",E5,IF(RIGHT(E4,1)=\"T\",E5,0))))","v":12500}]
[null,"Total taxable income",{"$f":"Calculation!$J$17","v":0},null,{"$f":"(LEFT(E4,LEN(E4)-1))*10","v":12500}]
[]
[]
[null,"Income Tax Calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"weekly","Fortnightly","4-weekly","monthly"]
[null,null,null,"Weekly ",null,null,null,"F/nightly",null,null,null,"4-weekly",null,null,null,"Monthly",null,null,null,null,null,"BR",721,1442,2885,3125]
[null,null,null,"Allowance",{"$f":"C4/52*Data!L22","v":240.38461538461539},null,null,"Allowance",{"$f":"C4/26*Data!L22","v":480.76923076923077},null,null,"Allowance",{"$f":"C4/13*Data!L22","v":961.53846153846155},null,null,"Allowance",{"$f":"C4/12*Data!L22","v":1041.6666666666667},null,null,null,null,"HR",2163,4327,8654,9375]
[null,null,null,"Income",{"$f":"C5","v":0},null,null,"Income ",{"$f":"C5","v":0},null,null,"Income",{"$f":"C5","v":0},null,null,"Income ",{"$f":"C5","v":0},null,null,null,null,"AR",2885,5770,11538,12500]
[null,null,null,"Minus PA",{"$f":"E11-E10","v":-240.38461538461539},null,null,"Minus PA",{"$f":"I11-I10","v":-480.76923076923077},null,null,"Minus PA",{"$f":"M11-M10","v":-961.53846153846155},null,null,"Minus PA",{"$f":"Q11-Q10","v":-1041.6666666666667}]
[]
[null,null,null,null,"Tax",null,null,null,"Tax",null,null,null,"Tax",null,null,null,"Tax"]
[null,null,0.2,{"$f":"IF(E12>BR_W,BR_W,E12)","v":-240.38461538461539},{"$f":"IF($E$4=\"BR\",ROUNDDOWN($C$5,0)*C15,IF($E$4=\"d0\",0,IF($E$4=\"D1\",0,ROUNDDOWN(D15,0)*C15)))","v":-48},null,0.2,{"$f":"IF(I12>BR_F,BR_F,I12)","v":-480.76923076923077},{"$f":"IF($E$4=\"BR\",ROUNDDOWN($C$5,0)*G15,IF($E$4=\"d0\",0,IF($E$4=\"D1\",0,ROUNDDOWN(H15,0)*G15)))","v":-96},null,0.2,{"$f":"IF(M12>BR_4W,BR_4W,M12)","v":-961.53846153846155},{"$f":"IF($E$4=\"BR\",ROUNDDOWN($C$5,0)*K15,IF($E$4=\"d0\",0,IF($E$4=\"D1\",0,ROUNDDOWN(L15,0)*K15)))","v":-192.20000000000002},null,0.2,{"$f":"IF(Q12>BR_M,BR_M,Q12)","v":-1041.6666666666667},{"$f":"IF($E$4=\"BR\",ROUNDDOWN($C$5,0)*O15,IF($E$4=\"d0\",0,IF($E$4=\"D1\",0,ROUNDDOWN(P15,0)*O15)))","v":-208.20000000000002},null,null,37500]
[null,null,0.4,{"$f":"IF(E12-D15>HR_W,HR_W,E12-D15)","v":0},{"$f":"IF($E$4=\"D0\",ROUNDDOWN($C$5,0)*C16,IF($E$4=\"BR\",0,IF($E$4=\"D1\",0,ROUNDDOWN(D16,0)*C16)))","v":0},null,0.4,{"$f":"IF(I12-H15>HR_F,HR_F,I12-H15)","v":0},{"$f":"IF($E$4=\"D0\",ROUNDDOWN($C$5,0)*G16,IF($E$4=\"BR\",0,IF($E$4=\"D1\",0,ROUNDDOWN(H16,0)*G16)))","v":0},null,0.4,{"$f":"IF(M12-L15>HR_4W,HR_4W,M12-L15)","v":0},{"$f":"IF($E$4=\"D0\",ROUNDDOWN($C$5,0)*K16,IF($E$4=\"BR\",0,IF($E$4=\"D1\",0,ROUNDDOWN(L16,0)*K16)))","v":0},null,0.4,{"$f":"IF(Q12-P15>HR_M,HR_M,Q12-P15)","v":0},{"$f":"IF($E$4=\"D0\",ROUNDDOWN($C$5,0)*O16,IF($E$4=\"BR\",0,IF($E$4=\"D1\",0,ROUNDDOWN(P16,0)*O16)))","v":0},null,null,112499]
[null,null,0.45,{"$f":"E12-D15-D16","v":0},{"$f":"IF($E$4=\"D1\",ROUNDDOWN($C$5,0)*C17,IF($E$4=\"d0\",0,IF($E$4=\"BR\",0,ROUNDDOWN(D17,0)*C17)))","v":0},null,0.45,{"$f":"I12-H15-H16","v":0},{"$f":"IF($E$4=\"D1\",ROUNDDOWN($C$5,0)*G17,IF($E$4=\"d0\",0,IF($E$4=\"BR\",0,ROUNDDOWN(H17,0)*G17)))","v":0},null,0.45,{"$f":"M12-L15-L16","v":0},{"$f":"IF($E$4=\"D1\",ROUNDDOWN($C$5,0)*K17,IF($E$4=\"d0\",0,IF($E$4=\"BR\",0,ROUNDDOWN(L17,0)*K17)))","v":0},null,0.45,{"$f":"Q12-P15-P16","v":0},{"$f":"IF($E$4=\"D1\",ROUNDDOWN($C$5,0)*O17,IF($E$4=\"d0\",0,IF($E$4=\"BR\",0,ROUNDDOWN(P17,0)*O17)))","v":0}]
[null,{"$f":"IF(IF(Data!C9=\"WEEKLY\",'Umbrella rates'!E19,IF(Data!C9=\"Fortnightly\",'Umbrella rates'!I19,IF(Data!C9=\"monthly\",'Umbrella rates'!Q19,'Umbrella rates'!M19)))<0,0,IF(Data!C9=\"WEEKLY\",'Umbrella rates'!E19,IF(Data!C9=\"Fortnightly\",'Umbrella rates'!I19,IF(Data!C9=\"monthly\",'Umbrella rates'!Q19,'Umbrella rates'!M19))))","v":0}]
[null,{"$f":"IF(Data!C7=\"D2\",\" Invalid Tax Code\",IF(B18<0,0,B18))","v":0},null,"Tax",{"$f":"SUM(E15:E18)","v":-48},null,null,"Tax",{"$f":"SUM(I15:I18)","v":-96},null,null,"Tax",{"$f":"SUM(M15:M18)","v":-192.20000000000002},null,null,"Tax",{"$f":"SUM(Q15:Q18)","v":-208.20000000000002}]
[]
[]
[]
[null,"Annual Allowance",{"$f":"F4","v":12500},null,null,null,"Anyone on a tax code that begins with S, will have these %s and bands applied for Income Tax. "]
[null,"Taxable income",{"$f":"'Calculation a'!Q9","v":0}]
[]
[]
[null,"Scottish Income Tax"]
[null,null,null,"Weekly ",null,null,null,"F/nightly",null,null,null,"4-weekly",null,null,null,"Monthly"]
[null,null,null,"Income",{"$f":"C24","v":0},null,null,"Income ",{"$f":"C24","v":0},null,null,"Income",{"$f":"C24","v":0},null,null,"Income ",{"$f":"C24","v":0}]
[null,null,null,"Minus PA",{"$f":"E29-E10","v":-240.38461538461539},null,null,"Minus PA",{"$f":"I29-I10","v":-480.76923076923077},null,null,"Minus PA",{"$f":"M29-M10","v":-961.53846153846155},null,null,"Minus PA",{"$f":"Q29-Q10","v":-1041.6666666666667}]
[]
[null,null,null,null,"Tax",null,null,null,"Tax",null,null,null,"Tax",null,null,null,"Tax",null,null,null,null,null,"weekly","Fortnightly","4-weekly","monthly"]
[null,null,0.19,{"$f":"IF(E30>W33,W33,E30)","v":-240.38461538461539},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*C33,IF($E$4=\"D0\",ROUNDDOWN(0,0)*C33,IF($E$4=\"D1\",ROUNDDOWN(0,0)*C33,IF($E$4=\"D2\",ROUNDDOWN(0,0)*C33,ROUNDDOWN(D33,0)*C33))))","v":-45.6},null,0.19,{"$f":"IF(I30>X33,X33,I30)","v":-480.76923076923077},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*G33,IF($E$4=\"D0\",ROUNDDOWN(0,0)*G33,IF($E$4=\"D1\",ROUNDDOWN(0,0)*G33,IF($E$4=\"D2\",ROUNDDOWN(0,0)*G33,ROUNDDOWN(H33,0)*G33))))","v":-91.2},null,0.19,{"$f":"IF(M30>Y33,Y33,M30)","v":-961.53846153846155},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*K33,IF($E$4=\"D0\",ROUNDDOWN(0,0)*K33,IF($E$4=\"D1\",ROUNDDOWN(0,0)*K33,IF($E$4=\"D2\",ROUNDDOWN(0,0)*K33,ROUNDDOWN(L33,0)*K33))))","v":-182.59},null,0.19,{"$f":"IF(Q30>Z33,Z33,Q30)","v":-1041.6666666666667},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*O33,IF($E$4=\"D0\",ROUNDDOWN(0,0)*O33,IF($E$4=\"D1\",ROUNDDOWN(0,0)*O33,IF($E$4=\"D2\",ROUNDDOWN(0,0)*O33,ROUNDDOWN(P33,0)*O33))))","v":-197.79},null,null,null,null,"SR",39.4,78.8,157.6,170.73]
[null,null,0.2,{"$f":"IF(E30-D33>W34,W34,E30-D33)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN($C$24,0)*C34,IF($E$4=\"D0\",ROUNDDOWN(0,0)*C34,IF($E$4=\"D1\",ROUNDDOWN(0,0)*C34,IF($E$4=\"D2\",ROUNDDOWN(0,0)*C34,ROUNDDOWN(D34,0)*C34))))","v":0},null,0.2,{"$f":"IF(I30-H33>X34,X34,I30-H33)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN($C$24,0)*G34,IF($E$4=\"D0\",ROUNDDOWN(0,0)*G34,IF($E$4=\"D1\",ROUNDDOWN(0,0)*G34,IF($E$4=\"D2\",ROUNDDOWN(0,0)*G34,ROUNDDOWN(H34,0)*G34))))","v":0},null,0.2,{"$f":"IF(M30-L33>Y34,Y34,M30-L33)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN($C$24,0)*K34,IF($E$4=\"D0\",ROUNDDOWN(0,0)*K34,IF($E$4=\"D1\",ROUNDDOWN(0,0)*K34,IF($E$4=\"D2\",ROUNDDOWN(0,0)*K34,ROUNDDOWN(L34,0)*K34))))","v":0},null,0.2,{"$f":"IF(Q30-P33>Z34,Z34,Q30-P33)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN($C$24,0)*O34,IF($E$4=\"D0\",ROUNDDOWN(0,0)*O34,IF($E$4=\"D1\",ROUNDDOWN(0,0)*O34,IF($E$4=\"D2\",ROUNDDOWN(0,0)*O34,ROUNDDOWN(P34,0)*O34))))","v":0},null,null,null,null,"BR",199.9,399.8,799.6,866.23]
[null,"D0",0.21,{"$f":"IF(E30-D33-D34>W35,W35,E30-D33-D34)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*C35,IF($E$4=\"D0\",ROUNDDOWN($C$24,0)*C35,IF($E$4=\"D1\",ROUNDDOWN(0,0)*C35,IF($E$4=\"D2\",ROUNDDOWN(0,0)*C35,ROUNDDOWN(D35,0)*C35))))","v":0},null,0.21,{"$f":"IF(I30-H33-H34>X35,X35,I30-H33-H34)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*G35,IF($E$4=\"D0\",ROUNDDOWN($C$24,0)*G35,IF($E$4=\"D1\",ROUNDDOWN(0,0)*G35,IF($E$4=\"D2\",ROUNDDOWN(0,0)*G35,ROUNDDOWN(H35,0)*G35))))","v":0},null,0.21,{"$f":"IF(M30-L33-L34>Y35,Y35,M30-L33-L34)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*K35,IF($E$4=\"D0\",ROUNDDOWN($C$24,0)*K35,IF($E$4=\"D1\",ROUNDDOWN(0,0)*K35,IF($E$4=\"D2\",ROUNDDOWN(0,0)*K35,ROUNDDOWN(L35,0)*K35))))","v":0},null,0.21,{"$f":"IF(Q30-P33-P34>Z35,Z35,Q30-P33-P34)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*O35,IF($E$4=\"D0\",ROUNDDOWN($C$24,0)*O35,IF($E$4=\"D1\",ROUNDDOWN(0,0)*O35,IF($E$4=\"D2\",ROUNDDOWN(0,0)*O35,ROUNDDOWN(P35,0)*O35))))","v":0},null,null,null,null,"IR",355.5,711,1422,1540.5]
[null,"D1",0.41,{"$f":"IF(E30-D33-D34-D35>W36,W36,E30-D33-D34-D35)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*C36,IF($E$4=\"D0\",ROUNDDOWN(0,0)*C36,IF($E$4=\"D1\",ROUNDDOWN($C$24,0)*C36,IF($E$4=\"D2\",ROUNDDOWN(0,0)*C36,ROUNDDOWN(D36,0)*C36))))","v":0},null,0.41,{"$f":"IF(I30-H33-H34-H35>X36,X36,I30-H33-H34-H35)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*G36,IF($E$4=\"D0\",ROUNDDOWN(0,0)*G36,IF($E$4=\"D1\",ROUNDDOWN($C$24,0)*G36,IF($E$4=\"D2\",ROUNDDOWN(0,0)*G36,ROUNDDOWN(H36,0)*G36))))","v":0},null,0.41,{"$f":"IF(M30-L33-L34-L35>Y36,Y36,M30-L33-L34-L35)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*K36,IF($E$4=\"D0\",ROUNDDOWN(0,0)*K36,IF($E$4=\"D1\",ROUNDDOWN($C$24,0)*K36,IF($E$4=\"D2\",ROUNDDOWN(0,0)*K36,ROUNDDOWN(L36,0)*K36))))","v":0},null,0.41,{"$f":"IF(Q30-P33-P34-P35>Z36,Z36,Q30-P33-P34-P35)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*O36,IF($E$4=\"D0\",ROUNDDOWN(0,0)*O36,IF($E$4=\"D1\",ROUNDDOWN($C$24,0)*O36,IF($E$4=\"D2\",ROUNDDOWN(0,0)*O36,ROUNDDOWN(P36,0)*O36))))","v":0},null,null,null,null,"HR",2289.81,4579.62,9159.24,9922.51]
[null,"D2",0.46,{"$f":"(E30-D33-D34-D35-D36)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*C37,IF($E$4=\"D0\",ROUNDDOWN(0,0)*C37,IF($E$4=\"D1\",ROUNDDOWN(0,0)*C37,IF($E$4=\"D2\",ROUNDDOWN($C$24,0)*C37,ROUNDDOWN(D37,0)*C37))))","v":0},null,0.46,{"$f":"IF(H36=0,0,(I30-H33-H34-H35-H36))","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*G37,IF($E$4=\"D0\",ROUNDDOWN(0,0)*G37,IF($E$4=\"D1\",ROUNDDOWN(0,0)*G37,IF($E$4=\"D2\",ROUNDDOWN($C$24,0)*G37,ROUNDDOWN(H37,0)*G37))))","v":0},null,0.46,{"$f":"IF(L36=0,0,(M30-L33-L34-L35-L36))","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*K37,IF($E$4=\"D0\",ROUNDDOWN(0,0)*K37,IF($E$4=\"D1\",ROUNDDOWN(0,0)*K37,IF($E$4=\"D2\",ROUNDDOWN($C$24,0)*K37,ROUNDDOWN(L37,0)*K37))))","v":0},null,0.46,{"$f":"IF(P36=0,0,(Q30-P33-P34-P35-P36))","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*O37,IF($E$4=\"D0\",ROUNDDOWN(0,0)*O37,IF($E$4=\"D1\",ROUNDDOWN(0,0)*O37,IF($E$4=\"D2\",ROUNDDOWN($C$24,0)*O37,ROUNDDOWN(P37,0)*O37))))","v":0},null,null,null,null,"AR",2884,5768,11536,12497.33]
[null,{"$f":"IF(IF(Data!C9=\"WEEKLY\",'Umbrella rates'!E39,IF(Data!C9=\"Fortnightly\",'Umbrella rates'!I39,IF(Data!C9=\"monthly\",'Umbrella rates'!Q39,'Umbrella rates'!M39)))<0,0,IF(Data!C9=\"WEEKLY\",'Umbrella rates'!E39,IF(Data!C9=\"Fortnightly\",'Umbrella rates'!I39,IF(Data!C9=\"monthly\",'Umbrella rates'!Q39,'Umbrella rates'!M39))))","v":0}]
[null,{"$f":"IF(B38<0,0,B38)","v":0},null,"Tax",{"$f":"SUM(E33:E38)","v":-45.6},null,null,"Tax",{"$f":"SUM(I33:I38)","v":-91.2},null,null,"Tax",{"$f":"SUM(M33:M38)","v":-182.59},null,null,"Tax",{"$f":"SUM(Q33:Q38)","v":-197.79}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"weekly","Fortnightly","4-weekly","monthly"]
[null,"Threshold rollover",{"$f":"Data!L22","v":1},null,"Input the number of pay periods rolled over.                      ALWAYS input 1 if on non-cumulative code. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PT",166,332,664,719]
[null,"Taxable income",{"$f":"'Calculation a'!Q9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UEL",962,1924,3848,4167]
[]
[null,"National Insurance "]
[null,null,null,"Weekly ",null,null,null,"F/nightly",null,null,null,"4-weekly",null,null,null,"Monthly"]
[null,null,null,"Income",{"$f":"C45","v":0},null,null,"Income ",{"$f":"C45","v":0},null,null,"Income",{"$f":"C45","v":0},null,null,"Income ",{"$f":"C45","v":0}]
[null,null,null,"Minus TH",{"$f":"E49-PT_Weekly*C44","v":-166},null,null,"Minus TH",{"$f":"I49-PT_Fortnightly*C44","v":-332},null,null,"Minus TH",{"$f":"M49-PT_4_Weekly*C44","v":-664},null,null,"Minus TH",{"$f":"Q49-PT_Monthly*C44","v":-719}]
[]
[null,null,null,null,"NI",null,null,null,"NI",null,null,null,"NI",null,null,null,"NI"]
[null,null,0.12,{"$f":"IF(E50>UEL_weekly-PT_Weekly,UEL_weekly-PT_Weekly,E50)","v":-166},{"$f":"D53*0.12","v":-19.919999999999998},null,0.12,{"$f":"IF(I50>UEL_Fortnightly-PT_Fortnightly,UEL_Fortnightly-PT_Fortnightly,I50)","v":-332},{"$f":"H53*0.12","v":-39.839999999999996},null,0.12,{"$f":"IF(M50>UEL_4weekly-PT_4_Weekly,(UEL_4weekly-PT_4_Weekly),M50)","v":-664},{"$f":"L53*0.12","v":-79.679999999999993},null,0.12,{"$f":"IF(Q50>UEL_monthly-PT_Monthly,UEL_monthly-PT_Monthly,Q50)","v":-719},{"$f":"P53*0.12","v":-86.28}]
[null,null,0.02,{"$f":"IF(D53=UEL_weekly-PT_Weekly,E50-(UEL_weekly-PT_Weekly),0)","v":0},{"$f":"D54*0.02","v":0},null,0.02,{"$f":"IF(H53=UEL_Fortnightly-PT_Fortnightly,I50-(UEL_Fortnightly-PT_Fortnightly),0)","v":0},{"$f":"H54*0.02","v":0},null,0.02,{"$f":"IF(L53=UEL_4weekly-PT_4_Weekly,M50-(UEL_4weekly-PT_4_Weekly),0)","v":0},{"$f":"L54*0.02","v":0},null,0.02,{"$f":"IF(P53=UEL_monthly-PT_Monthly,Q50-(UEL_monthly-PT_Monthly),0)","v":0},{"$f":"P54*0.02","v":0}]
[]
[null,{"$f":"IF(Data!C9=\"WEEKLY\",'Umbrella rates'!E56,IF(Data!C9=\"Fortnightly\",'Umbrella rates'!I56,IF(Data!C9=\"monthly\",'Umbrella rates'!Q56,'Umbrella rates'!M56)))","v":0},null,"NI",{"$f":"IF(SUM(E53:E55)<0,0,SUM(E53:E55))","v":0},null,null,"NI",{"$f":"IF(SUM(I53:I55)<0,0,SUM(I53:I55))","v":0},null,null,"NI",{"$f":"IF(SUM(M53:M55)<0,0,SUM(M53:M55))","v":0},null,null,"NI",{"$f":"IF(SUM(Q53:Q55)<0,0,SUM(Q53:Q55))","v":0}]
[]
[]
[]
[]
[null,"Annual Allowance",13505,null,null,null,"Anyone on a tax code that begins with C, will have these %s and bands applied for Income Tax. "]
[null,"Taxable income",170000]
[]
[]
[null,"Welsh Income Tax"]
[null,null,null,"Weekly ",null,null,null,"F/nightly",null,null,null,"4-weekly",null,null,null,"Monthly"]
[null,null,null,"Income",{"$f":"C62","v":170000},null,null,"Income ",{"$f":"C62","v":170000},null,null,"Income",{"$f":"C62","v":170000},null,null,"Income ",{"$f":"C62","v":170000}]
[null,null,null,"Minus PA",{"$f":"E67-C61/52","v":169740.28846153847},null,null,"Minus PA",{"$f":"I67-C61/26","v":169480.57692307694},null,null,"Minus PA",{"$f":"M67-C61/13","v":168961.15384615384},null,null,"Minus PA",{"$f":"Q67-C61/12","v":168874.58333333334}]
[]
[null,null,null,null,"Tax",null,null,null,"Tax",null,null,null,"Tax",null,null,null,"Tax"]
[null,null,0.19,{"$f":"IF(E68>38,38,E68)","v":38},{"$f":"D71*0.19","v":7.22},null,0.19,{"$f":"IF(I68>77,77,I68)","v":77},{"$f":"H71*0.19","v":14.63},null,0.19,{"$f":"IF(M68>154,154,M68)","v":154},{"$f":"L71*0.19","v":29.26},null,0.19,{"$f":"IF(Q68>167,167,Q68)","v":167},{"$f":"P71*0.19","v":31.73}]
[null,null,0.2,{"$f":"IF(E68-D71>195,195,E68-D71)","v":195},{"$f":"D72*0.2","v":39},null,0.2,{"$f":"IF(I68-H71>390,390,I68-H71)","v":390},{"$f":"H72*0.2","v":78},null,0.2,{"$f":"IF(M68-L71>781,781,M68-L71)","v":781},{"$f":"L72*0.2","v":156.20000000000002},null,0.2,{"$f":"IF(Q68-P71>846,846,Q68-P71)","v":846},{"$f":"P72*0.2","v":169.20000000000002}]
[null,null,0.21,{"$f":"IF(E68-D71-D72>374,374,E68-D71-D72)","v":374},{"$f":"D73*0.21","v":78.539999999999992},null,0.21,{"$f":"IF(I68-H71-H72>747,747,I68-H71-H72)","v":747},{"$f":"H73*0.21","v":156.87},null,0.21,{"$f":"IF(M68-L71-L72>1495,1495,M68-L71-L72)","v":1495},{"$f":"L73*0.21","v":313.95},null,0.21,{"$f":"IF(Q68-P71-P72>1619,1619,Q68-P71-P72)","v":1619},{"$f":"P73*0.21","v":339.99}]
[null,null,0.41,{"$f":"IF(E68-D71-D72-D73>2277,2277,E68-D71-D72-D73)","v":2277},{"$f":"D74*0.41","v":933.56999999999994},null,0.41,{"$f":"IF(I68-H71-H72-H73>4555,4555,I68-H71-H72-H73)","v":4555},{"$f":"H74*0.41","v":1867.55},null,0.41,{"$f":"IF(M68-L71-L72-L73>9109,9109,M68-L71-L72-L73)","v":9109},{"$f":"L74*0.41","v":3734.6899999999996},null,0.41,{"$f":"IF(Q68-P71-P72-P73>9868,9868,Q68-P71-P72-P73)","v":9868},{"$f":"P74*0.41","v":4045.8799999999997}]
[null,null,0.46,{"$f":"(E68-D71-D72-D73-D74)","v":166856.28846153847},{"$f":"D75*0.46","v":76753.892692307694},null,0.46,{"$f":"(I68-H71-H72-H73-H74)","v":163711.57692307694},{"$f":"H75*0.46","v":75307.325384615397},null,0.46,{"$f":"(M68-L71-L72-L73-L74)","v":157422.15384615384},{"$f":"L75*0.46","v":72414.190769230772},null,0.46,{"$f":"(Q68-P71-P72-P73-P74)","v":156374.58333333334},{"$f":"P75*0.46","v":71932.308333333334}]
[]
[null,null,null,"Tax",{"$f":"SUM(E71:E76)","v":77812.222692307696},null,null,"Tax",{"$f":"SUM(I71:I76)","v":77424.3753846154},null,null,"Tax",{"$f":"SUM(M71:M76)","v":76648.290769230778},null,null,"Tax",{"$f":"SUM(Q71:Q76)","v":76519.108333333337}]

{"sheet":"PAYE rates","index":8,"n_rows":77,"n_cols":26,"rows_kept":77,"cut":false,"hidden":true,"merged":[[1,1,1,6],[1,8,1,13],[7,1,7,2],[8,3,8,4],[8,7,8,8],[8,11,8,12],[8,15,8,16],[43,4,44,8],[46,1,46,2],[47,3,47,4],[47,7,47,8],[47,11,47,12],[47,15,47,16],[22,6,24,10],[26,1,26,2],[27,3,27,4],[27,7,27,8],[27,11,27,12],[65,15,65,16],[27,15,27,16],[60,6,62,10],[64,1,64,2],[65,3,65,4],[65,7,65,8],[65,11,65,12]]}
[]
[null,"Scroll down for Scottish Tax Bands and Pension Calculations",null,null,null,null,null,null,"Input the Annual Allowance and Total Taxable Income and the calculations will be made for you!"]
[]
[null,"Annual Allowance",{"$f":"F4","v":12500},null,{"$f":"Data!C7","v":"1250L"},{"$f":"IF(RIGHT(E4,1)=\"L\",E5,IF(RIGHT(E4,1)=\"M\",E5,IF(RIGHT(E4,1)=\"n\",E5,IF(RIGHT(E4,1)=\"T\",E5,0))))","v":12500}]
[null,"Total taxable income",{"$f":"Calculation!F17","v":0},null,{"$f":"(LEFT(E4,LEN(E4)-1))*10","v":12500}]
[]
[]
[null,"Income Tax Calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"weekly","Fortnightly","4-weekly","monthly"]
[null,null,null,"Weekly ",null,null,null,"F/nightly",null,null,null,"4-weekly",null,null,null,"Monthly",null,null,null,null,null,"BR",721,1442,2885,3125]
[null,null,null,"Allowance",{"$f":"C4/52*Data!L22","v":240.38461538461539},null,null,"Allowance",{"$f":"C4/26","v":480.76923076923077},null,null,"Allowance",{"$f":"C4/13","v":961.53846153846155},null,null,"Allowance",{"$f":"C4/12","v":1041.6666666666667},null,null,null,null,"HR",2163,4327,8654,9375]
[null,null,null,"Income",{"$f":"C5","v":0},null,null,"Income ",{"$f":"C5","v":0},null,null,"Income",{"$f":"C5","v":0},null,null,"Income ",{"$f":"C5","v":0},null,null,null,null,"AR",2885,5770,11538,12500]
[null,null,null,"Minus PA",{"$f":"E11-E10","v":-240.38461538461539},null,null,"Minus PA",{"$f":"I11-I10","v":-480.76923076923077},null,null,"Minus PA",{"$f":"M11-M10","v":-961.53846153846155},null,null,"Minus PA",{"$f":"Q11-Q10","v":-1041.6666666666667}]
[]
[null,null,null,null,"Tax",null,null,null,"Tax",null,null,null,"Tax",null,null,null,"Tax"]
[null,null,0.2,{"$f":"IF(E12>BR_W,BR_W,E12)","v":-240.38461538461539},{"$f":"IF($E$4=\"BR\",ROUNDDOWN($C$5,0)*C15,IF($E$4=\"d0\",0,IF($E$4=\"D1\",0,ROUNDDOWN(D15,0)*C15)))","v":-48},null,0.2,{"$f":"IF(I12>BR_F,BR_F,I12)","v":-480.76923076923077},{"$f":"IF($E$4=\"BR\",ROUNDDOWN($C$5,0)*G15,IF($E$4=\"d0\",0,IF($E$4=\"D1\",0,ROUNDDOWN(H15,0)*G15)))","v":-96},null,0.2,{"$f":"IF(M12>BR_4W,BR_4W,M12)","v":-961.53846153846155},{"$f":"IF($E$4=\"BR\",ROUNDDOWN($C$5,0)*K15,IF($E$4=\"d0\",0,IF($E$4=\"D1\",0,ROUNDDOWN(L15,0)*K15)))","v":-192.20000000000002},null,0.2,{"$f":"IF(Q12>BR_M,BR_M,Q12)","v":-1041.6666666666667},{"$f":"IF($E$4=\"BR\",ROUNDDOWN($C$5,0)*O15,IF($E$4=\"d0\",0,IF($E$4=\"D1\",0,ROUNDDOWN(P15,0)*O15)))","v":-208.20000000000002},null,null,37500]
[null,null,0.4,{"$f":"IF(E12-D15>HR_W,HR_W,E12-D15)","v":0},{"$f":"IF($E$4=\"D0\",ROUNDDOWN($C$5,0)*C16,IF($E$4=\"BR\",0,IF($E$4=\"D1\",0,ROUNDDOWN(D16,0)*C16)))","v":0},null,0.4,{"$f":"IF(I12-H15>HR_F,HR_F,I12-H15)","v":0},{"$f":"IF($E$4=\"D0\",ROUNDDOWN($C$5,0)*G16,IF($E$4=\"BR\",0,IF($E$4=\"D1\",0,ROUNDDOWN(H16,0)*G16)))","v":0},null,0.4,{"$f":"IF(M12-L15>HR_4W,HR_4W,M12-L15)","v":0},{"$f":"IF($E$4=\"D0\",ROUNDDOWN($C$5,0)*K16,IF($E$4=\"BR\",0,IF($E$4=\"D1\",0,ROUNDDOWN(L16,0)*K16)))","v":0},null,0.4,{"$f":"IF(Q12-P15>HR_M,HR_M,Q12-P15)","v":0},{"$f":"IF($E$4=\"D0\",ROUNDDOWN($C$5,0)*O16,IF($E$4=\"BR\",0,IF($E$4=\"D1\",0,ROUNDDOWN(P16,0)*O16)))","v":0},null,null,112499]
[null,null,0.45,{"$f":"E12-D15-D16","v":0},{"$f":"IF($E$4=\"D1\",ROUNDDOWN($C$5,0)*C17,IF($E$4=\"d0\",0,IF($E$4=\"BR\",0,ROUNDDOWN(D17,0)*C17)))","v":0},null,0.45,{"$f":"I12-H15-H16","v":0},{"$f":"IF($E$4=\"D1\",ROUNDDOWN($C$5,0)*G17,IF($E$4=\"d0\",0,IF($E$4=\"BR\",0,ROUNDDOWN(H17,0)*G17)))","v":0},null,0.45,{"$f":"M12-L15-L16","v":0},{"$f":"IF($E$4=\"D1\",ROUNDDOWN($C$5,0)*K17,IF($E$4=\"d0\",0,IF($E$4=\"BR\",0,ROUNDDOWN(L17,0)*K17)))","v":0},null,0.45,{"$f":"Q12-P15-P16","v":0},{"$f":"IF($E$4=\"D1\",ROUNDDOWN($C$5,0)*O17,IF($E$4=\"d0\",0,IF($E$4=\"BR\",0,ROUNDDOWN(P17,0)*O17)))","v":0}]
[null,{"$f":"IF(Data!C9=\"WEEKLY\",'PAYE rates'!E19,IF(Data!C9=\"Fortnightly\",'PAYE rates'!I19,IF(Data!C9=\"monthly\",'PAYE rates'!Q19,'PAYE rates'!M19)))","v":-48}]
[null,{"$f":"IF(Data!C7=\"D2\",\" Invalid Tax Code\",IF(B18<0,0,B18))","v":0},null,"Tax",{"$f":"SUM(E15:E18)","v":-48},null,null,"Tax",{"$f":"SUM(I15:I18)","v":-96},null,null,"Tax",{"$f":"SUM(M15:M18)","v":-192.20000000000002},null,null,"Tax",{"$f":"SUM(Q15:Q18)","v":-208.20000000000002}]
[]
[]
[]
[null,"Annual Allowance",{"$f":"F4","v":12500},null,null,null,"Anyone on a tax code that begins with S, will have these %s and bands applied for Income Tax. "]
[null,"Taxable income",{"$f":"C5","v":0}]
[]
[]
[null,"Scottish Income Tax"]
[null,null,null,"Weekly ",null,null,null,"F/nightly",null,null,null,"4-weekly",null,null,null,"Monthly"]
[null,null,null,"Income",{"$f":"C24","v":0},null,null,"Income ",{"$f":"C24","v":0},null,null,"Income",{"$f":"C24","v":0},null,null,"Income ",{"$f":"C24","v":0}]
[null,null,null,"Minus PA",{"$f":"E29-E10","v":-240.38461538461539},null,null,"Minus PA",{"$f":"I29-I10","v":-480.76923076923077},null,null,"Minus PA",{"$f":"M29-M10","v":-961.53846153846155},null,null,"Minus PA",{"$f":"Q29-Q10","v":-1041.6666666666667}]
[]
[null,null,null,null,"Tax",null,null,null,"Tax",null,null,null,"Tax",null,null,null,"Tax",null,null,null,null,null,"weekly","Fortnightly","4-weekly","monthly"]
[null,null,0.19,{"$f":"IF(E30>W33,W33,E30)","v":-240.38461538461539},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*C33,IF($E$4=\"D0\",ROUNDDOWN(0,0)*C33,IF($E$4=\"D1\",ROUNDDOWN(0,0)*C33,IF($E$4=\"D2\",ROUNDDOWN(0,0)*C33,ROUNDDOWN(D33,0)*C33))))","v":-45.6},null,0.19,{"$f":"IF(I30>X33,X33,I30)","v":-480.76923076923077},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*G33,IF($E$4=\"D0\",ROUNDDOWN(0,0)*G33,IF($E$4=\"D1\",ROUNDDOWN(0,0)*G33,IF($E$4=\"D2\",ROUNDDOWN(0,0)*G33,ROUNDDOWN(H33,0)*G33))))","v":-91.2},null,0.19,{"$f":"IF(M30>Y33,Y33,M30)","v":-961.53846153846155},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*K33,IF($E$4=\"D0\",ROUNDDOWN(0,0)*K33,IF($E$4=\"D1\",ROUNDDOWN(0,0)*K33,IF($E$4=\"D2\",ROUNDDOWN(0,0)*K33,ROUNDDOWN(L33,0)*K33))))","v":-182.59},null,0.19,{"$f":"IF(Q30>Z33,Z33,Q30)","v":-1041.6666666666667},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*O33,IF($E$4=\"D0\",ROUNDDOWN(0,0)*O33,IF($E$4=\"D1\",ROUNDDOWN(0,0)*O33,IF($E$4=\"D2\",ROUNDDOWN(0,0)*O33,ROUNDDOWN(P33,0)*O33))))","v":-197.79},null,null,null,null,"SR",39.4,78.8,157.6,170.73]
[null,null,0.2,{"$f":"IF(E30-D33>W34,W34,E30-D33)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN($C$24,0)*C34,IF($E$4=\"D0\",ROUNDDOWN(0,0)*C34,IF($E$4=\"D1\",ROUNDDOWN(0,0)*C34,IF($E$4=\"D2\",ROUNDDOWN(0,0)*C34,ROUNDDOWN(D34,0)*C34))))","v":0},null,0.2,{"$f":"IF(I30-H33>X34,X34,I30-H33)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN($C$24,0)*G34,IF($E$4=\"D0\",ROUNDDOWN(0,0)*G34,IF($E$4=\"D1\",ROUNDDOWN(0,0)*G34,IF($E$4=\"D2\",ROUNDDOWN(0,0)*G34,ROUNDDOWN(H34,0)*G34))))","v":0},null,0.2,{"$f":"IF(M30-L33>Y34,Y34,M30-L33)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN($C$24,0)*K34,IF($E$4=\"D0\",ROUNDDOWN(0,0)*K34,IF($E$4=\"D1\",ROUNDDOWN(0,0)*K34,IF($E$4=\"D2\",ROUNDDOWN(0,0)*K34,ROUNDDOWN(L34,0)*K34))))","v":0},null,0.2,{"$f":"IF(Q30-P33>Z34,Z34,Q30-P33)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN($C$24,0)*O34,IF($E$4=\"D0\",ROUNDDOWN(0,0)*O34,IF($E$4=\"D1\",ROUNDDOWN(0,0)*O34,IF($E$4=\"D2\",ROUNDDOWN(0,0)*O34,ROUNDDOWN(P34,0)*O34))))","v":0},null,null,null,null,"BR",199.9,399.8,799.6,866.23]
[null,null,0.21,{"$f":"IF(E30-D33-D34>W35,W35,E30-D33-D34)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*C35,IF($E$4=\"D0\",ROUNDDOWN($C$24,0)*C35,IF($E$4=\"D1\",ROUNDDOWN(0,0)*C35,IF($E$4=\"D2\",ROUNDDOWN(0,0)*C35,ROUNDDOWN(D35,0)*C35))))","v":0},null,0.21,{"$f":"IF(I30-H33-H34>X35,X35,I30-H33-H34)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*G35,IF($E$4=\"D0\",ROUNDDOWN($C$24,0)*G35,IF($E$4=\"D1\",ROUNDDOWN(0,0)*G35,IF($E$4=\"D2\",ROUNDDOWN(0,0)*G35,ROUNDDOWN(H35,0)*G35))))","v":0},null,0.21,{"$f":"IF(M30-L33-L34>Y35,Y35,M30-L33-L34)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*K35,IF($E$4=\"D0\",ROUNDDOWN($C$24,0)*K35,IF($E$4=\"D1\",ROUNDDOWN(0,0)*K35,IF($E$4=\"D2\",ROUNDDOWN(0,0)*K35,ROUNDDOWN(L35,0)*K35))))","v":0},null,0.21,{"$f":"IF(Q30-P33-P34>Z35,Z35,Q30-P33-P34)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*O35,IF($E$4=\"D0\",ROUNDDOWN($C$24,0)*O35,IF($E$4=\"D1\",ROUNDDOWN(0,0)*O35,IF($E$4=\"D2\",ROUNDDOWN(0,0)*O35,ROUNDDOWN(P35,0)*O35))))","v":0},null,null,null,null,"IR",355.5,711,1422,1540.5]
[null,null,0.41,{"$f":"IF(E30-D33-D34-D35>W36,W36,E30-D33-D34-D35)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*C36,IF($E$4=\"D0\",ROUNDDOWN(0,0)*C36,IF($E$4=\"D1\",ROUNDDOWN($C$24,0)*C36,IF($E$4=\"D2\",ROUNDDOWN(0,0)*C36,ROUNDDOWN(D36,0)*C36))))","v":0},null,0.41,{"$f":"IF(I30-H33-H34-H35>X36,X36,I30-H33-H34-H35)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*G36,IF($E$4=\"D0\",ROUNDDOWN(0,0)*G36,IF($E$4=\"D1\",ROUNDDOWN($C$24,0)*G36,IF($E$4=\"D2\",ROUNDDOWN(0,0)*G36,ROUNDDOWN(H36,0)*G36))))","v":0},null,0.41,{"$f":"IF(M30-L33-L34-L35>Y36,Y36,M30-L33-L34-L35)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*K36,IF($E$4=\"D0\",ROUNDDOWN(0,0)*K36,IF($E$4=\"D1\",ROUNDDOWN($C$24,0)*K36,IF($E$4=\"D2\",ROUNDDOWN(0,0)*K36,ROUNDDOWN(L36,0)*K36))))","v":0},null,0.41,{"$f":"IF(Q30-P33-P34-P35>Z36,Z36,Q30-P33-P34-P35)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*O36,IF($E$4=\"D0\",ROUNDDOWN(0,0)*O36,IF($E$4=\"D1\",ROUNDDOWN($C$24,0)*O36,IF($E$4=\"D2\",ROUNDDOWN(0,0)*O36,ROUNDDOWN(P36,0)*O36))))","v":0},null,null,null,null,"HR",2289.81,4579.62,9159.24,9922.51]
[null,null,0.46,{"$f":"(E30-D33-D34-D35-D36)","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*C37,IF($E$4=\"D0\",ROUNDDOWN(0,0)*C37,IF($E$4=\"D1\",ROUNDDOWN(0,0)*C37,IF($E$4=\"D2\",ROUNDDOWN($C$24,0)*C37,ROUNDDOWN(D37,0)*C37))))","v":0},null,0.46,{"$f":"IF(H36=0,0,(I30-H33-H34-H35-H36))","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*G37,IF($E$4=\"D0\",ROUNDDOWN(0,0)*G37,IF($E$4=\"D1\",ROUNDDOWN(0,0)*G37,IF($E$4=\"D2\",ROUNDDOWN($C$24,0)*G37,ROUNDDOWN(H37,0)*G37))))","v":0},null,0.46,{"$f":"IF(L36=0,0,(M30-L33-L34-L35-L36))","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*K37,IF($E$4=\"D0\",ROUNDDOWN(0,0)*K37,IF($E$4=\"D1\",ROUNDDOWN(0,0)*K37,IF($E$4=\"D2\",ROUNDDOWN($C$24,0)*K37,ROUNDDOWN(L37,0)*K37))))","v":0},null,0.46,{"$f":"IF(P36=0,0,(Q30-P33-P34-P35-P36))","v":0},{"$f":"IF($E$4=\"BR\",ROUNDDOWN(0,0)*O37,IF($E$4=\"D0\",ROUNDDOWN(0,0)*O37,IF($E$4=\"D1\",ROUNDDOWN(0,0)*O37,IF($E$4=\"D2\",ROUNDDOWN($C$24,0)*O37,ROUNDDOWN(P37,0)*O37))))","v":0},null,null,null,null,"AR",2884,5768,11536,12497.33]
[null,{"$f":"IF(Data!C9=\"WEEKLY\",'PAYE rates'!E39,IF(Data!C9=\"Fortnightly\",'PAYE rates'!I39,IF(Data!C9=\"monthly\",'PAYE rates'!Q39,'PAYE rates'!M39)))","v":-45.6}]
[null,{"$f":"IF(B38<0,0,B38)","v":0},null,"Tax",{"$f":"SUM(E33:E38)","v":-45.6},null,null,"Tax",{"$f":"SUM(I33:I38)","v":-91.2},null,null,"Tax",{"$f":"SUM(M33:M38)","v":-182.59},null,null,"Tax",{"$f":"SUM(Q33:Q38)","v":-197.79}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"weekly","Fortnightly","4-weekly","monthly"]
[null,"Threshold rollover",{"$f":"Data!L22","v":1},null,"Input the number of pay periods rolled over.                      ALWAYS input 1 if on non-cumulative code. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PT",166,332,664,719]
[null,"Taxable income",{"$f":"C5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UEL",962,1924,3848,4167]
[]
[null,"National Insurance "]
[null,null,null,"Weekly ",null,null,null,"F/nightly",null,null,null,"4-weekly",null,null,null,"Monthly"]
[null,null,null,"Income",{"$f":"C45","v":0},null,null,"Income ",{"$f":"C45","v":0},null,null,"Income",{"$f":"C45","v":0},null,null,"Income ",{"$f":"C45","v":0}]
[null,null,null,"Minus TH",{"$f":"E49-PT_Weekly*C44","v":-166},null,null,"Minus TH",{"$f":"I49-PT_Fortnightly*C44","v":-332},null,null,"Minus TH",{"$f":"M49-PT_4_Weekly*C44","v":-664},null,null,"Minus TH",{"$f":"Q49-PT_Monthly*C44","v":-719}]
[]
[null,null,null,null,"NI",null,null,null,"NI",null,null,null,"NI",null,null,null,"NI"]
[null,null,0.12,{"$f":"IF(E50>UEL_weekly-PT_Weekly,UEL_weekly-PT_Weekly,E50)","v":-166},{"$f":"D53*0.12","v":-19.919999999999998},null,0.12,{"$f":"IF(I50>UEL_Fortnightly-PT_Fortnightly,UEL_Fortnightly-PT_Fortnightly,I50)","v":-332},{"$f":"H53*0.12","v":-39.839999999999996},null,0.12,{"$f":"IF(M50>UEL_4weekly-PT_4_Weekly,(UEL_4weekly-PT_4_Weekly),M50)","v":-664},{"$f":"L53*0.12","v":-79.679999999999993},null,0.12,{"$f":"IF(Q50>UEL_monthly-PT_Monthly,UEL_monthly-PT_Monthly,Q50)","v":-719},{"$f":"P53*0.12","v":-86.28}]
[null,null,0.02,{"$f":"IF(D53=UEL_weekly-PT_Weekly,E50-(UEL_weekly-PT_Weekly),0)","v":0},{"$f":"D54*0.02","v":0},null,0.02,{"$f":"IF(H53=UEL_Fortnightly-PT_Fortnightly,I50-(UEL_Fortnightly-PT_Fortnightly),0)","v":0},{"$f":"H54*0.02","v":0},null,0.02,{"$f":"IF(L53=UEL_4weekly-PT_4_Weekly,M50-(UEL_4weekly-PT_4_Weekly),0)","v":0},{"$f":"L54*0.02","v":0},null,0.02,{"$f":"IF(P53=UEL_monthly-PT_Monthly,Q50-(UEL_monthly-PT_Monthly),0)","v":0},{"$f":"P54*0.02","v":0}]
[]
[null,{"$f":"IF(Data!C9=\"WEEKLY\",'PAYE rates'!E56,IF(Data!C9=\"Fortnightly\",'PAYE rates'!I56,IF(Data!C9=\"monthly\",'PAYE rates'!Q56,'PAYE rates'!M56)))","v":0},null,"NI",{"$f":"IF(SUM(E53:E55)<0,0,SUM(E53:E55))","v":0},null,null,"NI",{"$f":"IF(SUM(I53:I55)<0,0,SUM(I53:I55))","v":0},null,null,"NI",{"$f":"IF(SUM(M53:M55)<0,0,SUM(M53:M55))","v":0},null,null,"NI",{"$f":"IF(SUM(Q53:Q55)<0,0,SUM(Q53:Q55))","v":0}]
[null,{"$f":"IF(Data!C9=\"WEEKLY\",'PAYE rates'!E57,IF(Data!C9=\"Fortnightly\",'PAYE rates'!I57,IF(Data!C9=\"monthly\",'PAYE rates'!Q57,'PAYE rates'!M57)))","v":-22.908000000000001},0.13800000000000001,"ERNI",{"$f":"E50*C57","v":-22.908000000000001},null,0.13800000000000001,"ERNI",{"$f":"I50*G57","v":-45.816000000000003},null,0.13800000000000001,"ERNI",{"$f":"M50*K57","v":-91.632000000000005},null,0.13800000000000001,"ERNI",{"$f":"Q50*O57","v":-99.222000000000008}]
[]
[]
[]
[null,"Annual Allowance",13505,null,null,null,"Anyone on a tax code that begins with C, will have these %s and bands applied for Income Tax. "]
[null,"Taxable income",170000]
[]
[]
[null,"Welsh Income Tax"]
[null,null,null,"Weekly ",null,null,null,"F/nightly",null,null,null,"4-weekly",null,null,null,"Monthly"]
[null,null,null,"Income",{"$f":"C62","v":170000},null,null,"Income ",{"$f":"C62","v":170000},null,null,"Income",{"$f":"C62","v":170000},null,null,"Income ",{"$f":"C62","v":170000}]
[null,null,null,"Minus PA",{"$f":"E67-C61/52","v":169740.28846153847},null,null,"Minus PA",{"$f":"I67-C61/26","v":169480.57692307694},null,null,"Minus PA",{"$f":"M67-C61/13","v":168961.15384615384},null,null,"Minus PA",{"$f":"Q67-C61/12","v":168874.58333333334}]
[]
[null,null,null,null,"Tax",null,null,null,"Tax",null,null,null,"Tax",null,null,null,"Tax"]
[null,null,0.19,{"$f":"IF(E68>38,38,E68)","v":38},{"$f":"D71*0.19","v":7.22},null,0.19,{"$f":"IF(I68>77,77,I68)","v":77},{"$f":"H71*0.19","v":14.63},null,0.19,{"$f":"IF(M68>154,154,M68)","v":154},{"$f":"L71*0.19","v":29.26},null,0.19,{"$f":"IF(Q68>167,167,Q68)","v":167},{"$f":"P71*0.19","v":31.73}]
[null,null,0.2,{"$f":"IF(E68-D71>195,195,E68-D71)","v":195},{"$f":"D72*0.2","v":39},null,0.2,{"$f":"IF(I68-H71>390,390,I68-H71)","v":390},{"$f":"H72*0.2","v":78},null,0.2,{"$f":"IF(M68-L71>781,781,M68-L71)","v":781},{"$f":"L72*0.2","v":156.20000000000002},null,0.2,{"$f":"IF(Q68-P71>846,846,Q68-P71)","v":846},{"$f":"P72*0.2","v":169.20000000000002}]
[null,null,0.21,{"$f":"IF(E68-D71-D72>374,374,E68-D71-D72)","v":374},{"$f":"D73*0.21","v":78.539999999999992},null,0.21,{"$f":"IF(I68-H71-H72>747,747,I68-H71-H72)","v":747},{"$f":"H73*0.21","v":156.87},null,0.21,{"$f":"IF(M68-L71-L72>1495,1495,M68-L71-L72)","v":1495},{"$f":"L73*0.21","v":313.95},null,0.21,{"$f":"IF(Q68-P71-P72>1619,1619,Q68-P71-P72)","v":1619},{"$f":"P73*0.21","v":339.99}]
[null,null,0.41,{"$f":"IF(E68-D71-D72-D73>2277,2277,E68-D71-D72-D73)","v":2277},{"$f":"D74*0.41","v":933.56999999999994},null,0.41,{"$f":"IF(I68-H71-H72-H73>4555,4555,I68-H71-H72-H73)","v":4555},{"$f":"H74*0.41","v":1867.55},null,0.41,{"$f":"IF(M68-L71-L72-L73>9109,9109,M68-L71-L72-L73)","v":9109},{"$f":"L74*0.41","v":3734.6899999999996},null,0.41,{"$f":"IF(Q68-P71-P72-P73>9868,9868,Q68-P71-P72-P73)","v":9868},{"$f":"P74*0.41","v":4045.8799999999997}]
[null,null,0.46,{"$f":"(E68-D71-D72-D73-D74)","v":166856.28846153847},{"$f":"D75*0.46","v":76753.892692307694},null,0.46,{"$f":"(I68-H71-H72-H73-H74)","v":163711.57692307694},{"$f":"H75*0.46","v":75307.325384615397},null,0.46,{"$f":"(M68-L71-L72-L73-L74)","v":157422.15384615384},{"$f":"L75*0.46","v":72414.190769230772},null,0.46,{"$f":"(Q68-P71-P72-P73-P74)","v":156374.58333333334},{"$f":"P75*0.46","v":71932.308333333334}]
[]
[null,null,null,"Tax",{"$f":"SUM(E71:E76)","v":77812.222692307696},null,null,"Tax",{"$f":"SUM(I71:I76)","v":77424.3753846154},null,null,"Tax",{"$f":"SUM(M71:M76)","v":76648.290769230778},null,null,"Tax",{"$f":"SUM(Q71:Q76)","v":76519.108333333337}]