{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Info Sheet","Sheet2","Arrear Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Info Sheet","index":0,"n_rows":77,"n_cols":17,"rows_kept":77,"cut":false,"hidden":false,"merged":[[1,1,1,16],[0,1,0,10],[3,7,3,8],[3,9,4,9],[3,10,4,10],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,3,6],[2,1,2,10],[2,12,2,16],[3,12,4,12],[3,13,3,15],[3,16,4,16]]}
[]
[null,"Automatic Arrear Calculator\nfrom January 01, 2021 to Today (31.12.2026)"]
[]
[null,"SN","Employee Name","Designation","Arrear Detail",null,null,"Basic Pay",null,"PF \nType","ITax/TDS",null,"Month\n/Year","DA Rate",null,null,"HRA\nRate"]
[null,null,null,null,"Type","From","To","Due","Drawn",null,null,null,null,"Due","Drawn","Diff"]
[null,{"$f":"IF(C6=\"\",\"\",COUNTA($C$6:C6))","v":1},"Pramod Kumar Saini","Teacher","Salary","2021-01-01","2021-11-01",47900,45100,"GPF 2004",0.1,null,"2021-01-01",17,17,{"$f":"N6-O6","v":0},8]
[null,{"$f":"IF(C7=\"\",\"\",COUNTA($C$6:C7))","v":""},null,null,null,null,null,null,null,null,null,null,"2021-02-01",17,17,0,8]
[null,{"$f":"IF(C8=\"\",\"\",COUNTA($C$6:C8))","v":""},null,null,null,null,null,null,null,null,null,null,"2021-03-01",17,17,0,8]
[null,{"$f":"IF(C9=\"\",\"\",COUNTA($C$6:C9))","v":""},null,null,null,null,null,null,null,null,null,null,"2021-04-01",17,17,0,8]
[null,{"$f":"IF(C10=\"\",\"\",COUNTA($C$6:C10))","v":""},null,null,null,null,null,null,null,null,null,null,"2021-05-01",17,17,0,8]
[null,{"$f":"IF(C11=\"\",\"\",COUNTA($C$6:C11))","v":""},null,null,null,null,null,null,null,null,null,null,"2021-06-01",17,17,0,8]
[null,{"$f":"IF(C12=\"\",\"\",COUNTA($C$6:C12))","v":""},null,null,null,null,null,null,null,null,null,null,"2021-07-01",31,17,14,9]
[null,{"$f":"IF(C13=\"\",\"\",COUNTA($C$6:C13))","v":""},null,null,null,null,null,null,null,null,null,null,"2021-08-01",31,17,14,9]
[null,{"$f":"IF(C14=\"\",\"\",COUNTA($C$6:C14))","v":""},null,null,null,null,null,null,null,null,null,null,"2021-09-01",31,17,14,9]
[null,{"$f":"IF(C15=\"\",\"\",COUNTA($C$6:C15))","v":""},null,null,null,null,null,null,null,null,null,null,"2021-10-01",31,31,0,9]
[null,{"$f":"IF(C16=\"\",\"\",COUNTA($C$6:C16))","v":""},null,null,null,null,null,null,null,null,null,null,"2021-11-01",31,31,0,9]
[null,{"$f":"IF(C17=\"\",\"\",COUNTA($C$6:C17))","v":""},null,null,null,null,null,null,null,null,null,null,"2021-12-01",31,31,0,9]
[null,{"$f":"IF(C18=\"\",\"\",COUNTA($C$6:C18))","v":""},null,null,null,null,null,null,null,null,null,null,"2022-01-01",34,31,3,9]
[null,{"$f":"IF(C19=\"\",\"\",COUNTA($C$6:C19))","v":""},null,null,null,null,null,null,null,null,null,null,"2022-02-01",34,31,3,9]
[null,{"$f":"IF(C20=\"\",\"\",COUNTA($C$6:C20))","v":""},null,null,null,null,null,null,null,null,null,null,"2022-03-01",34,31,3,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2022-04-01",34,34,0,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2022-05-01",34,34,0,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2022-06-01",34,34,0,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2022-07-01",38,34,4,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2022-08-01",38,34,4,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2022-09-01",38,34,4,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-01",38,38,0,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2022-11-01",38,38,0,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-01",38,38,0,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01",42,38,4,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-01",42,38,4,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-01",42,38,4,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-01",42,42,0,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-01",42,42,0,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-01",42,42,0,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-01",46,46,0,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-01",46,46,0,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2023-09-01",46,46,{"$f":"N38-O38","v":0},9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-01",46,46,0,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-01",46,46,0,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-01",46,46,0,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2024-01-01",50,50,0,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2024-02-01",50,50,0,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2024-03-01",50,50,0,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2024-04-01",50,50,0,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2024-05-01",50,50,0,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2024-06-01",50,50,0,9]
[null,null,null,null,null,null,null,null,null,null,null,null,"2024-07-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2024-08-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2024-09-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2024-10-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2024-11-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2024-12-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2025-01-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2025-02-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2025-03-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2025-04-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2025-05-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2025-06-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2025-07-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2025-08-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2025-09-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2025-10-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2025-11-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2025-12-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2026-01-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2026-02-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2026-03-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2026-04-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2026-05-01",null,null,{"$f":"N70-O70","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"2026-06-01",null,null,{"$f":"N71-O71","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"2026-07-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2026-08-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2026-09-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2026-10-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2026-11-01",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"2026-12-01",null,null,0]

{"sheet":"Sheet2","index":1,"n_rows":77,"n_cols":33,"rows_kept":77,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,{"$f":"'Arrear Sheet'!B3","v":1},{"$f":"VLOOKUP(B4,'Info Sheet'!$B$6:$K$20,4,0)&\" Arrear from \"&TEXT(VLOOKUP(B4,'Info Sheet'!$B$6:$K$20,5,0),\"DD-MMM-YYYY\")& \" to \"&TEXT(VLOOKUP(B4,'Info Sheet'!$B$6:$K$20,6,0),\"MMM-YYYY\")","v":"Salary Arrear from 01-Jan-2021 to Nov-2021"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B4,'Info Sheet'!$B$6:$K$20,9,0),\"\")","v":"GPF 2004"},null,null,null,null,null,null,null,"RGHS"]
[null,{"$f":"IFERROR(VLOOKUP(B4,'Info Sheet'!$B$6:$K$20,2,0),\"\")","v":"Pramod Kumar Saini"},null,null,null,{"$f":"IFERROR(VLOOKUP(B4,'Info Sheet'!$B$6:$K$20,3,0),\"\")","v":"Teacher"},null,null,null,{"$f":"IFERROR(VLOOKUP($B$4,'Info Sheet'!$B$6:$K$20,10,0),\"\")","v":0.1}]
[null,{"$f":"T6","v":"1-2021"},{"$f":"IFERROR(IF(T6=\"\",0,IF($N$11=$R$6,$M$12,0)),\"\")","v":47900},{"$f":"ROUND(C6*'Info Sheet'!N6/100,0)","v":8143},{"$f":"ROUND(C6*'Info Sheet'!Q6/100,0)","v":3832},{"$f":"IFERROR(IF(T6=\"\",0,IF($N$11=$R$6,$N$12,0)),\"\")","v":45100},{"$f":"ROUND(F6*'Info Sheet'!N6/100,0)","v":7667},{"$f":"ROUND(F6*'Info Sheet'!Q6/100,0)","v":3608},null,{"$f":"ROUND((SUM(C6:E6)-SUM(F6:H6))*$J$5,0)","v":350},null,null,{"$f":"DAY(IFERROR(VLOOKUP($B$4,saini,5,0),\"Error\"))","v":1},{"$f":"VLOOKUP(N9,Q6:S77,3,0)","v":30},1,2021,{"$f":"O6&\"-\"&P6","v":"1-2021"},1,31,{"$f":"IFERROR(IF($N$10<R6,\"\",IF($N$11<=R6,Q6,\"\")),\"\")","v":"1-2021"},null,{"$f":"IF(C6>=$M$13,C6,0)","v":47900},{"$f":"IF(F6>=$N$13,F6,0)","v":45100},{"$f":"IF(V6>51500,3575,IF(V6>38500,2850,IF(V6>28500,2100,IF(V6>23000,1625,IF(V6>0,1450,0)))))","v":2850},{"$f":"IF(V6>167000,10500,IF(V6>116000,8900,IF(V6>80000,6150,IF(V6>72000,4800,IF(V6>62000,4200,X6)))))","v":2850},{"$f":"ROUND(C6*'Info Sheet'!P6/100,0)","v":0},{"$f":"Y6+Z6","v":2850},{"$f":"IF(W6>51500,3575,IF(W6>38500,2850,IF(W6>28500,2100,IF(W6>23000,1625,IF(W6>0,1450,0)))))","v":2850},{"$f":"IF(W6>167000,10500,IF(W6>116000,8900,IF(W6>80000,6150,IF(W6>72000,4800,IF(W6>62000,4200,AB6)))))","v":2850},{"$f":"ROUND(F6*'Info Sheet'!P6/100,0)","v":0},{"$f":"AC6+AD6","v":2850},{"$f":"IF(V6>54000,875,IF(V6>33500,658,IF(V6>18000,440,IF(V6>0,265,0))))","v":658},{"$f":"IF(W6>54000,875,IF(W6>33500,658,IF(W6>18000,440,IF(W6>0,265,0))))","v":658}]
[null,{"$f":"T7","v":"2-2021"},{"$f":"IFERROR(IF(T7=\"\",0,IF(C6>0,$M$13,$M$12)),\"\")","v":47900},{"$f":"ROUND(C7*'Info Sheet'!N7/100,0)","v":8143},{"$f":"ROUND(C7*'Info Sheet'!Q7/100,0)","v":3832},{"$f":"IFERROR(IF(T7=\"\",0,IF(F6>0,$N$13,$N$12)),\"\")","v":45100},{"$f":"ROUND(F7*'Info Sheet'!N7/100,0)","v":7667},{"$f":"ROUND(F7*'Info Sheet'!Q7/100,0)","v":3608},null,350,null,null,{"$f":"MONTH(IFERROR(VLOOKUP($B$4,saini,5,0),\"Error\"))","v":1},{"$f":"MONTH(IFERROR(VLOOKUP($B$4,saini,6,0),\"Error\"))","v":11},2,2021,{"$f":"O7&\"-\"&P7","v":"2-2021"},2,28,"2-2021",null,{"$f":"IF(C7>=$M$13,C7,0)","v":47900},{"$f":"IF(F7>=$N$13,F7,0)","v":45100},{"$f":"IF(V7>51500,3575,IF(V7>38500,2850,IF(V7>28500,2100,IF(V7>23000,1625,IF(V7>0,1450,0)))))","v":2850},{"$f":"IF(V7>167000,10500,IF(V7>116000,8900,IF(V7>80000,6150,IF(V7>72000,4800,IF(V7>62000,4200,X7)))))","v":2850},{"$f":"ROUND(C7*'Info Sheet'!P7/100,0)","v":0},{"$f":"Y7+Z7","v":2850},{"$f":"IF(W7>51500,3575,IF(W7>38500,2850,IF(W7>28500,2100,IF(W7>23000,1625,IF(W7>0,1450,0)))))","v":2850},{"$f":"IF(W7>167000,10500,IF(W7>116000,8900,IF(W7>80000,6150,IF(W7>72000,4800,IF(W7>62000,4200,AB7)))))","v":2850},{"$f":"ROUND(F7*'Info Sheet'!P7/100,0)","v":0},{"$f":"AC7+AD7","v":2850},{"$f":"IF(V7>54000,875,IF(V7>33500,658,IF(V7>18000,440,IF(V7>0,265,0))))","v":658},{"$f":"IF(W7>54000,875,IF(W7>33500,658,IF(W7>18000,440,IF(W7>0,265,0))))","v":658}]
[null,"3-2021",{"$f":"IFERROR(IF(T8=\"\",0,IF(C7>0,$M$13,$M$12)),\"\")","v":47900},{"$f":"ROUND(C8*'Info Sheet'!N8/100,0)","v":8143},{"$f":"ROUND(C8*'Info Sheet'!Q8/100,0)","v":3832},{"$f":"IFERROR(IF(T8=\"\",0,IF(F7>0,$N$13,$N$12)),\"\")","v":45100},{"$f":"ROUND(F8*'Info Sheet'!N8/100,0)","v":7667},{"$f":"ROUND(F8*'Info Sheet'!Q8/100,0)","v":3608},null,350,null,null,{"$f":"YEAR(IFERROR(VLOOKUP($B$4,saini,5,0),\"Error\"))","v":2021},{"$f":"YEAR(IFERROR(VLOOKUP($B$4,saini,6,0),\"Error\"))","v":2021},3,2021,"3-2021",3,31,"3-2021",null,47900,45100,2850,2850,{"$f":"ROUND(C8*'Info Sheet'!P8/100,0)","v":0},2850,2850,2850,{"$f":"ROUND(F8*'Info Sheet'!P8/100,0)","v":0},2850,658,658]
[null,"4-2021",{"$f":"IFERROR(IF(T9=\"\",0,IF(C8>0,$M$13,$M$12)),\"\")","v":47900},{"$f":"ROUND(C9*'Info Sheet'!N9/100,0)","v":8143},{"$f":"ROUND(C9*'Info Sheet'!Q9/100,0)","v":3832},{"$f":"IFERROR(IF(T9=\"\",0,IF(F8>0,$N$13,$N$12)),\"\")","v":45100},{"$f":"ROUND(F9*'Info Sheet'!N9/100,0)","v":7667},{"$f":"ROUND(F9*'Info Sheet'!Q9/100,0)","v":3608},null,350,null,null,{"$f":"M7&\"-\"&M8","v":"1-2021"},{"$f":"N7&\"-\"&N8","v":"11-2021"},4,2021,"4-2021",4,30,"4-2021",null,47900,45100,2850,2850,{"$f":"ROUND(C9*'Info Sheet'!P9/100,0)","v":0},2850,2850,2850,{"$f":"ROUND(F9*'Info Sheet'!P9/100,0)","v":0},2850,658,658]
[null,"5-2021",{"$f":"IFERROR(IF(T10=\"\",0,IF(C9>0,$M$13,$M$12)),\"\")","v":47900},{"$f":"ROUND(C10*'Info Sheet'!N10/100,0)","v":8143},{"$f":"ROUND(C10*'Info Sheet'!Q10/100,0)","v":3832},{"$f":"IFERROR(IF(T10=\"\",0,IF(F9>0,$N$13,$N$12)),\"\")","v":45100},{"$f":"ROUND(F10*'Info Sheet'!N10/100,0)","v":7667},{"$f":"ROUND(F10*'Info Sheet'!Q10/100,0)","v":3608},null,350,null,null,{"$f":"VLOOKUP(M9,Q6:S77,3,0)-M6+1","v":31},{"$f":"VLOOKUP(N9,Q6:S77,2,0)","v":11},5,2021,"5-2021",5,31,"5-2021",null,47900,45100,2850,2850,{"$f":"ROUND(C10*'Info Sheet'!P10/100,0)","v":0},2850,2850,2850,{"$f":"ROUND(F10*'Info Sheet'!P10/100,0)","v":0},2850,658,658]
[null,"6-2021",{"$f":"IFERROR(IF(T11=\"\",0,IF(C10>0,$M$13,$M$12)),\"\")","v":47900},{"$f":"ROUND(C11*'Info Sheet'!N11/100,0)","v":8143},{"$f":"ROUND(C11*'Info Sheet'!Q11/100,0)","v":3832},{"$f":"IFERROR(IF(T11=\"\",0,IF(F10>0,$N$13,$N$12)),\"\")","v":45100},{"$f":"ROUND(F11*'Info Sheet'!N11/100,0)","v":7667},{"$f":"ROUND(F11*'Info Sheet'!Q11/100,0)","v":3608},null,350,null,null,{"$f":"VLOOKUP(M9,Q6:S77,3,0)","v":31},{"$f":"VLOOKUP(M9,Q6:S77,2,0)","v":1},6,2021,"6-2021",6,30,"6-2021",null,47900,45100,2850,2850,{"$f":"ROUND(C11*'Info Sheet'!P11/100,0)","v":0},2850,2850,2850,{"$f":"ROUND(F11*'Info Sheet'!P11/100,0)","v":0},2850,658,658]
[null,"7-2021",{"$f":"IFERROR(IF(T12=\"\",0,IF($N$11<7,$M$14,IF(C11>0,$M$13,$M$12))),\"\")","v":49300},{"$f":"ROUND(C12*'Info Sheet'!N12/100,0)","v":15283},{"$f":"ROUND(C12*'Info Sheet'!Q12/100,0)","v":4437},{"$f":"IFERROR(IF(T12=\"\",0,IF($N$11<7,$N$14,IF(F11>0,$N$13,$N$12))),\"\")","v":46500},{"$f":"ROUND(F12*'Info Sheet'!N12/100,0)","v":14415},{"$f":"ROUND(F12*'Info Sheet'!Q12/100,0)","v":4185},null,392,null,null,{"$f":"ROUND((M13/M11)*M10,0)","v":47900},{"$f":"ROUND((N13/M11)*M10,0)","v":45100},7,2021,"7-2021",7,31,"7-2021",null,49300,46500,2850,2850,{"$f":"ROUND(C12*'Info Sheet'!P12/100,0)","v":6902},9752,2850,2850,{"$f":"ROUND(F12*'Info Sheet'!P12/100,0)","v":6510},9360,658,658]
[null,"8-2021",49300,{"$f":"ROUND(C13*'Info Sheet'!N13/100,0)","v":15283},{"$f":"ROUND(C13*'Info Sheet'!Q13/100,0)","v":4437},46500,{"$f":"ROUND(F13*'Info Sheet'!N13/100,0)","v":14415},{"$f":"ROUND(F13*'Info Sheet'!Q13/100,0)","v":4185},null,392,null,null,{"$f":"IFERROR(VLOOKUP($B$4,saini,7,0),\"Error\")","v":47900},{"$f":"IFERROR(VLOOKUP($B$4,saini,8,0),\"Error\")","v":45100},8,2021,"8-2021",8,31,"8-2021",null,49300,46500,2850,2850,{"$f":"ROUND(C13*'Info Sheet'!P13/100,0)","v":6902},9752,2850,2850,{"$f":"ROUND(F13*'Info Sheet'!P13/100,0)","v":6510},9360,658,658]
[null,"9-2021",49300,{"$f":"ROUND(C14*'Info Sheet'!N14/100,0)","v":15283},{"$f":"ROUND(C14*'Info Sheet'!Q14/100,0)","v":4437},46500,{"$f":"ROUND(F14*'Info Sheet'!N14/100,0)","v":14415},{"$f":"ROUND(F14*'Info Sheet'!Q14/100,0)","v":4185},null,392,null,null,{"$f":"MROUND(M13*103%,100)","v":49300},46500,9,2021,"9-2021",9,30,"9-2021",null,49300,46500,2850,2850,{"$f":"ROUND(C14*'Info Sheet'!P14/100,0)","v":6902},9752,2850,2850,{"$f":"ROUND(F14*'Info Sheet'!P14/100,0)","v":6510},9360,658,658]
[null,"10-2021",49300,{"$f":"ROUND(C15*'Info Sheet'!N15/100,0)","v":15283},{"$f":"ROUND(C15*'Info Sheet'!Q15/100,0)","v":4437},46500,{"$f":"ROUND(F15*'Info Sheet'!N15/100,0)","v":14415},{"$f":"ROUND(F15*'Info Sheet'!Q15/100,0)","v":4185},null,392,null,null,50800,47900,10,2021,"10-2021",10,31,"10-2021",null,49300,46500,2850,2850,{"$f":"ROUND(C15*'Info Sheet'!P15/100,0)","v":0},2850,2850,2850,{"$f":"ROUND(F15*'Info Sheet'!P15/100,0)","v":0},2850,658,658]
[null,"11-2021",49300,{"$f":"ROUND(C16*'Info Sheet'!N16/100,0)","v":15283},{"$f":"ROUND(C16*'Info Sheet'!Q16/100,0)","v":4437},46500,{"$f":"ROUND(F16*'Info Sheet'!N16/100,0)","v":14415},{"$f":"ROUND(F16*'Info Sheet'!Q16/100,0)","v":4185},null,392,null,null,52300,49300,11,2021,"11-2021",11,30,"11-2021",null,49300,46500,2850,2850,{"$f":"ROUND(C16*'Info Sheet'!P16/100,0)","v":0},2850,2850,2850,{"$f":"ROUND(F16*'Info Sheet'!P16/100,0)","v":0},2850,658,658]
[null,"",0,{"$f":"ROUND(C17*'Info Sheet'!N17/100,0)","v":0},{"$f":"ROUND(C17*'Info Sheet'!Q17/100,0)","v":0},0,{"$f":"ROUND(F17*'Info Sheet'!N17/100,0)","v":0},{"$f":"ROUND(F17*'Info Sheet'!Q17/100,0)","v":0},null,0,null,null,53900,50800,12,2021,"12-2021",12,31,"",null,0,0,0,0,{"$f":"ROUND(C17*'Info Sheet'!P17/100,0)","v":0},0,0,0,{"$f":"ROUND(F17*'Info Sheet'!P17/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C18*'Info Sheet'!N18/100,0)","v":0},{"$f":"ROUND(C18*'Info Sheet'!Q18/100,0)","v":0},0,{"$f":"ROUND(F18*'Info Sheet'!N18/100,0)","v":0},{"$f":"ROUND(F18*'Info Sheet'!Q18/100,0)","v":0},null,0,null,null,55500,52300,1,2022,"1-2022",13,31,"",null,0,0,0,0,{"$f":"ROUND(C18*'Info Sheet'!P18/100,0)","v":0},0,0,0,{"$f":"ROUND(F18*'Info Sheet'!P18/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C19*'Info Sheet'!N19/100,0)","v":0},{"$f":"ROUND(C19*'Info Sheet'!Q19/100,0)","v":0},0,{"$f":"ROUND(F19*'Info Sheet'!N19/100,0)","v":0},{"$f":"ROUND(F19*'Info Sheet'!Q19/100,0)","v":0},null,0,null,null,57200,53900,2,2022,"2-2022",14,28,"",null,0,0,0,0,{"$f":"ROUND(C19*'Info Sheet'!P19/100,0)","v":0},0,0,0,{"$f":"ROUND(F19*'Info Sheet'!P19/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C20*'Info Sheet'!N20/100,0)","v":0},{"$f":"ROUND(C20*'Info Sheet'!Q20/100,0)","v":0},0,{"$f":"ROUND(F20*'Info Sheet'!N20/100,0)","v":0},{"$f":"ROUND(F20*'Info Sheet'!Q20/100,0)","v":0},null,0,null,null,null,null,3,2022,"3-2022",15,31,"",null,0,0,0,0,{"$f":"ROUND(C20*'Info Sheet'!P20/100,0)","v":0},0,0,0,{"$f":"ROUND(F20*'Info Sheet'!P20/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C21*'Info Sheet'!N21/100,0)","v":0},{"$f":"ROUND(C21*'Info Sheet'!Q21/100,0)","v":0},0,{"$f":"ROUND(F21*'Info Sheet'!N21/100,0)","v":0},{"$f":"ROUND(F21*'Info Sheet'!Q21/100,0)","v":0},null,0,null,null,null,null,4,2022,"4-2022",16,30,"",null,0,0,0,0,{"$f":"ROUND(C21*'Info Sheet'!P21/100,0)","v":0},0,0,0,{"$f":"ROUND(F21*'Info Sheet'!P21/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C22*'Info Sheet'!N22/100,0)","v":0},{"$f":"ROUND(C22*'Info Sheet'!Q22/100,0)","v":0},0,{"$f":"ROUND(F22*'Info Sheet'!N22/100,0)","v":0},{"$f":"ROUND(F22*'Info Sheet'!Q22/100,0)","v":0},null,0,null,null,null,null,5,2022,"5-2022",17,31,"",null,0,0,0,0,{"$f":"ROUND(C22*'Info Sheet'!P22/100,0)","v":0},0,0,0,{"$f":"ROUND(F22*'Info Sheet'!P22/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C23*'Info Sheet'!N23/100,0)","v":0},{"$f":"ROUND(C23*'Info Sheet'!Q23/100,0)","v":0},0,{"$f":"ROUND(F23*'Info Sheet'!N23/100,0)","v":0},{"$f":"ROUND(F23*'Info Sheet'!Q23/100,0)","v":0},null,0,null,null,null,null,6,2022,"6-2022",18,30,"",null,0,0,0,0,{"$f":"ROUND(C23*'Info Sheet'!P23/100,0)","v":0},0,0,0,{"$f":"ROUND(F23*'Info Sheet'!P23/100,0)","v":0},0,0,0]
[null,"",{"$f":"IFERROR(IF(T24=\"\",0,IF($N$11<7,$M$15,IF(AND($N$11>6,$N$11<19),$M$14,IF($N$11=$R$24,$M$12)))),\"\")","v":0},{"$f":"ROUND(C24*'Info Sheet'!N24/100,0)","v":0},{"$f":"ROUND(C24*'Info Sheet'!Q24/100,0)","v":0},{"$f":"IFERROR(IF(T24=\"\",0,IF($N$11<7,$N$15,IF(AND($N$11>6,$N$11<19),$N$14,IF($N$11=$R$24,$N$12)))),\"\")","v":0},{"$f":"ROUND(F24*'Info Sheet'!N24/100,0)","v":0},{"$f":"ROUND(F24*'Info Sheet'!Q24/100,0)","v":0},null,0,null,null,null,null,7,2022,"7-2022",19,31,"",null,0,0,0,0,{"$f":"ROUND(C24*'Info Sheet'!P24/100,0)","v":0},0,0,0,{"$f":"ROUND(F24*'Info Sheet'!P24/100,0)","v":0},0,0,0]
[null,"",{"$f":"IFERROR(IF(T25=\"\",0,IF($N$11<7,$M$15,IF(AND($N$11>6,$N$11<19),$M$14,IF(C24>0,$M$13,$M$12)))),\"\")","v":0},{"$f":"ROUND(C25*'Info Sheet'!N25/100,0)","v":0},{"$f":"ROUND(C25*'Info Sheet'!Q25/100,0)","v":0},{"$f":"IFERROR(IF(T25=\"\",0,IF($N$11<7,$N$15,IF(AND($N$11>6,$N$11<19),$N$14,IF(F24>0,$N$13,$N$12)))),\"\")","v":0},{"$f":"ROUND(F25*'Info Sheet'!N25/100,0)","v":0},{"$f":"ROUND(F25*'Info Sheet'!Q25/100,0)","v":0},null,0,null,null,null,null,8,2022,"8-2022",20,31,"",null,0,0,0,0,{"$f":"ROUND(C25*'Info Sheet'!P25/100,0)","v":0},0,0,0,{"$f":"ROUND(F25*'Info Sheet'!P25/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C26*'Info Sheet'!N26/100,0)","v":0},{"$f":"ROUND(C26*'Info Sheet'!Q26/100,0)","v":0},0,{"$f":"ROUND(F26*'Info Sheet'!N26/100,0)","v":0},{"$f":"ROUND(F26*'Info Sheet'!Q26/100,0)","v":0},null,0,null,null,null,null,9,2022,"9-2022",21,30,"",null,0,0,0,0,{"$f":"ROUND(C26*'Info Sheet'!P26/100,0)","v":0},0,0,0,{"$f":"ROUND(F26*'Info Sheet'!P26/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C27*'Info Sheet'!N27/100,0)","v":0},{"$f":"ROUND(C27*'Info Sheet'!Q27/100,0)","v":0},0,{"$f":"ROUND(F27*'Info Sheet'!N27/100,0)","v":0},{"$f":"ROUND(F27*'Info Sheet'!Q27/100,0)","v":0},null,0,null,null,null,null,10,2022,"10-2022",22,31,"",null,0,0,0,0,{"$f":"ROUND(C27*'Info Sheet'!P27/100,0)","v":0},0,0,0,{"$f":"ROUND(F27*'Info Sheet'!P27/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C28*'Info Sheet'!N28/100,0)","v":0},{"$f":"ROUND(C28*'Info Sheet'!Q28/100,0)","v":0},0,{"$f":"ROUND(F28*'Info Sheet'!N28/100,0)","v":0},{"$f":"ROUND(F28*'Info Sheet'!Q28/100,0)","v":0},null,0,null,null,null,null,11,2022,"11-2022",23,30,"",null,0,0,0,0,{"$f":"ROUND(C28*'Info Sheet'!P28/100,0)","v":0},0,0,0,{"$f":"ROUND(F28*'Info Sheet'!P28/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C29*'Info Sheet'!N29/100,0)","v":0},{"$f":"ROUND(C29*'Info Sheet'!Q29/100,0)","v":0},0,{"$f":"ROUND(F29*'Info Sheet'!N29/100,0)","v":0},{"$f":"ROUND(F29*'Info Sheet'!Q29/100,0)","v":0},null,0,null,null,null,null,12,2022,"12-2022",24,31,"",null,0,0,0,0,{"$f":"ROUND(C29*'Info Sheet'!P29/100,0)","v":0},0,0,0,{"$f":"ROUND(F29*'Info Sheet'!P29/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C30*'Info Sheet'!N30/100,0)","v":0},{"$f":"ROUND(C30*'Info Sheet'!Q30/100,0)","v":0},0,{"$f":"ROUND(F30*'Info Sheet'!N30/100,0)","v":0},{"$f":"ROUND(F30*'Info Sheet'!Q30/100,0)","v":0},null,0,null,null,null,null,1,2023,"1-2023",25,31,"",null,0,0,0,0,{"$f":"ROUND(C30*'Info Sheet'!P30/100,0)","v":0},0,0,0,{"$f":"ROUND(F30*'Info Sheet'!P30/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C31*'Info Sheet'!N31/100,0)","v":0},{"$f":"ROUND(C31*'Info Sheet'!Q31/100,0)","v":0},0,{"$f":"ROUND(F31*'Info Sheet'!N31/100,0)","v":0},{"$f":"ROUND(F31*'Info Sheet'!Q31/100,0)","v":0},null,0,null,null,null,null,2,2023,"2-2023",26,28,"",null,0,0,0,0,{"$f":"ROUND(C31*'Info Sheet'!P31/100,0)","v":0},0,0,0,{"$f":"ROUND(F31*'Info Sheet'!P31/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C32*'Info Sheet'!N32/100,0)","v":0},{"$f":"ROUND(C32*'Info Sheet'!Q32/100,0)","v":0},0,{"$f":"ROUND(F32*'Info Sheet'!N32/100,0)","v":0},{"$f":"ROUND(F32*'Info Sheet'!Q32/100,0)","v":0},null,0,null,null,null,null,3,2023,"3-2023",27,31,"",null,0,0,0,0,{"$f":"ROUND(C32*'Info Sheet'!P32/100,0)","v":0},0,0,0,{"$f":"ROUND(F32*'Info Sheet'!P32/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C33*'Info Sheet'!N33/100,0)","v":0},{"$f":"ROUND(C33*'Info Sheet'!Q33/100,0)","v":0},0,{"$f":"ROUND(F33*'Info Sheet'!N33/100,0)","v":0},{"$f":"ROUND(F33*'Info Sheet'!Q33/100,0)","v":0},null,0,null,null,null,null,4,2023,"4-2023",28,30,"",null,0,0,0,0,{"$f":"ROUND(C33*'Info Sheet'!P33/100,0)","v":0},0,0,0,{"$f":"ROUND(F33*'Info Sheet'!P33/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C34*'Info Sheet'!N34/100,0)","v":0},{"$f":"ROUND(C34*'Info Sheet'!Q34/100,0)","v":0},0,{"$f":"ROUND(F34*'Info Sheet'!N34/100,0)","v":0},{"$f":"ROUND(F34*'Info Sheet'!Q34/100,0)","v":0},null,0,null,null,null,null,5,2023,"5-2023",29,31,"",null,0,0,0,0,{"$f":"ROUND(C34*'Info Sheet'!P34/100,0)","v":0},0,0,0,{"$f":"ROUND(F34*'Info Sheet'!P34/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C35*'Info Sheet'!N35/100,0)","v":0},{"$f":"ROUND(C35*'Info Sheet'!Q35/100,0)","v":0},0,{"$f":"ROUND(F35*'Info Sheet'!N35/100,0)","v":0},{"$f":"ROUND(F35*'Info Sheet'!Q35/100,0)","v":0},null,0,null,null,null,null,6,2023,"6-2023",30,30,"",null,0,0,0,0,{"$f":"ROUND(C35*'Info Sheet'!P35/100,0)","v":0},0,0,0,{"$f":"ROUND(F35*'Info Sheet'!P35/100,0)","v":0},0,0,0]
[null,"",{"$f":"IFERROR(IF(T36=\"\",0,IF($N$11<7,$M$16,IF(AND($N$11>6,$N$11<19),$M$15,IF(AND($N$11>18,$N$11<31),$M$14,IF($N$11=$R$36,$M$12))))),\"\")","v":0},{"$f":"ROUND(C36*'Info Sheet'!N36/100,0)","v":0},{"$f":"ROUND(C36*'Info Sheet'!Q36/100,0)","v":0},{"$f":"IFERROR(IF(T36=\"\",0,IF($N$11<7,$N$16,IF(AND($N$11>6,$N$11<19),$N$15,IF(AND($N$11>18,$N$11<31),$N$14,IF($N$11=$R$36,$N$12))))),\"\")","v":0},{"$f":"ROUND(F36*'Info Sheet'!N36/100,0)","v":0},{"$f":"ROUND(F36*'Info Sheet'!Q36/100,0)","v":0},null,0,null,null,null,null,7,2023,"7-2023",31,31,"",null,0,0,0,0,{"$f":"ROUND(C36*'Info Sheet'!P36/100,0)","v":0},0,0,0,{"$f":"ROUND(F36*'Info Sheet'!P36/100,0)","v":0},0,0,0]
[null,"",{"$f":"IFERROR(IF(T37=\"\",0,IF($N$11<7,$M$16,IF(AND($N$11>6,$N$11<19),$M$15,IF(AND($N$11>18,$N$11<31),$M$14,IF(C36>0,$M$13,$M$12))))),\"\")","v":0},{"$f":"ROUND(C37*'Info Sheet'!N37/100,0)","v":0},{"$f":"ROUND(C37*'Info Sheet'!Q37/100,0)","v":0},{"$f":"IFERROR(IF(T37=\"\",0,IF($N$11<7,$N$16,IF(AND($N$11>6,$N$11<19),$N$15,IF(AND($N$11>18,$N$11<31),$N$14,IF(F36>0,$N$13,$N$12))))),\"\")","v":0},{"$f":"ROUND(F37*'Info Sheet'!N37/100,0)","v":0},{"$f":"ROUND(F37*'Info Sheet'!Q37/100,0)","v":0},null,0,null,null,null,null,8,2023,"8-2023",32,31,"",null,0,0,0,0,{"$f":"ROUND(C37*'Info Sheet'!P37/100,0)","v":0},0,0,0,{"$f":"ROUND(F37*'Info Sheet'!P37/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C38*'Info Sheet'!N38/100,0)","v":0},{"$f":"ROUND(C38*'Info Sheet'!Q38/100,0)","v":0},0,{"$f":"ROUND(F38*'Info Sheet'!N38/100,0)","v":0},{"$f":"ROUND(F38*'Info Sheet'!Q38/100,0)","v":0},null,{"$f":"ROUND((SUM(C38:E38)-SUM(F38:H38))*$J$5,0)","v":0},null,null,null,null,9,2023,"9-2023",33,30,{"$f":"IFERROR(IF($N$10<R38,\"\",IF($N$11<=R38,Q38,\"\")),\"\")","v":""},null,0,0,0,0,{"$f":"ROUND(C38*'Info Sheet'!P38/100,0)","v":0},0,0,0,{"$f":"ROUND(F38*'Info Sheet'!P38/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C39*'Info Sheet'!N39/100,0)","v":0},{"$f":"ROUND(C39*'Info Sheet'!Q39/100,0)","v":0},0,{"$f":"ROUND(F39*'Info Sheet'!N39/100,0)","v":0},{"$f":"ROUND(F39*'Info Sheet'!Q39/100,0)","v":0},null,0,null,null,null,null,10,2023,"10-2023",34,31,"",null,0,0,0,0,{"$f":"ROUND(C39*'Info Sheet'!P39/100,0)","v":0},0,0,0,{"$f":"ROUND(F39*'Info Sheet'!P39/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C40*'Info Sheet'!N40/100,0)","v":0},{"$f":"ROUND(C40*'Info Sheet'!Q40/100,0)","v":0},0,{"$f":"ROUND(F40*'Info Sheet'!N40/100,0)","v":0},{"$f":"ROUND(F40*'Info Sheet'!Q40/100,0)","v":0},null,0,null,null,null,null,11,2023,"11-2023",35,30,"",null,0,0,0,0,{"$f":"ROUND(C40*'Info Sheet'!P40/100,0)","v":0},0,0,0,{"$f":"ROUND(F40*'Info Sheet'!P40/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C41*'Info Sheet'!N41/100,0)","v":0},{"$f":"ROUND(C41*'Info Sheet'!Q41/100,0)","v":0},0,{"$f":"ROUND(F41*'Info Sheet'!N41/100,0)","v":0},{"$f":"ROUND(F41*'Info Sheet'!Q41/100,0)","v":0},null,0,null,null,null,null,12,2023,"12-2023",36,31,"",null,0,0,0,0,{"$f":"ROUND(C41*'Info Sheet'!P41/100,0)","v":0},0,0,0,{"$f":"ROUND(F41*'Info Sheet'!P41/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C42*'Info Sheet'!N42/100,0)","v":0},{"$f":"ROUND(C42*'Info Sheet'!Q42/100,0)","v":0},0,{"$f":"ROUND(F42*'Info Sheet'!N42/100,0)","v":0},{"$f":"ROUND(F42*'Info Sheet'!Q42/100,0)","v":0},null,0,null,null,null,null,1,2024,"1-2024",37,31,"",null,0,0,0,0,{"$f":"ROUND(C42*'Info Sheet'!P42/100,0)","v":0},0,0,0,{"$f":"ROUND(F42*'Info Sheet'!P42/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C43*'Info Sheet'!N43/100,0)","v":0},{"$f":"ROUND(C43*'Info Sheet'!Q43/100,0)","v":0},0,{"$f":"ROUND(F43*'Info Sheet'!N43/100,0)","v":0},{"$f":"ROUND(F43*'Info Sheet'!Q43/100,0)","v":0},null,0,null,null,null,null,2,2024,"2-2024",38,29,"",null,0,0,0,0,{"$f":"ROUND(C43*'Info Sheet'!P43/100,0)","v":0},0,0,0,{"$f":"ROUND(F43*'Info Sheet'!P43/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C44*'Info Sheet'!N44/100,0)","v":0},{"$f":"ROUND(C44*'Info Sheet'!Q44/100,0)","v":0},0,{"$f":"ROUND(F44*'Info Sheet'!N44/100,0)","v":0},{"$f":"ROUND(F44*'Info Sheet'!Q44/100,0)","v":0},null,0,null,null,null,null,3,2024,"3-2024",39,31,"",null,0,0,0,0,{"$f":"ROUND(C44*'Info Sheet'!P44/100,0)","v":0},0,0,0,{"$f":"ROUND(F44*'Info Sheet'!P44/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C45*'Info Sheet'!N45/100,0)","v":0},{"$f":"ROUND(C45*'Info Sheet'!Q45/100,0)","v":0},0,{"$f":"ROUND(F45*'Info Sheet'!N45/100,0)","v":0},{"$f":"ROUND(F45*'Info Sheet'!Q45/100,0)","v":0},null,0,null,null,null,null,4,2024,"4-2024",40,30,"",null,0,0,0,0,{"$f":"ROUND(C45*'Info Sheet'!P45/100,0)","v":0},0,0,0,{"$f":"ROUND(F45*'Info Sheet'!P45/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C46*'Info Sheet'!N46/100,0)","v":0},{"$f":"ROUND(C46*'Info Sheet'!Q46/100,0)","v":0},0,{"$f":"ROUND(F46*'Info Sheet'!N46/100,0)","v":0},{"$f":"ROUND(F46*'Info Sheet'!Q46/100,0)","v":0},null,0,null,null,null,null,5,2024,"5-2024",41,31,"",null,0,0,0,0,{"$f":"ROUND(C46*'Info Sheet'!P46/100,0)","v":0},0,0,0,{"$f":"ROUND(F46*'Info Sheet'!P46/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C47*'Info Sheet'!N47/100,0)","v":0},{"$f":"ROUND(C47*'Info Sheet'!Q47/100,0)","v":0},0,{"$f":"ROUND(F47*'Info Sheet'!N47/100,0)","v":0},{"$f":"ROUND(F47*'Info Sheet'!Q47/100,0)","v":0},null,0,null,null,null,null,6,2024,"6-2024",42,30,"",null,0,0,0,0,{"$f":"ROUND(C47*'Info Sheet'!P47/100,0)","v":0},0,0,0,{"$f":"ROUND(F47*'Info Sheet'!P47/100,0)","v":0},0,0,0]
[null,"",{"$f":"IFERROR(IF(T48=\"\",0,IF($N$11<7,$M$17,IF(AND($N$11>6,$N$11<19),$M$16,IF(AND($N$11>18,$N$11<31),$M$15,IF(AND($N$11>30,$N$11<43),$M$14,IF($N$11=$R$48,$M$12)))))),\"\")","v":0},{"$f":"ROUND(C48*'Info Sheet'!N48/100,0)","v":0},{"$f":"ROUND(C48*'Info Sheet'!Q48/100,0)","v":0},{"$f":"IFERROR(IF(T48=\"\",0,IF($N$11<7,$N$17,IF(AND($N$11>6,$N$11<19),$N$16,IF(AND($N$11>18,$N$11<31),$N$15,IF(AND($N$11>30,$N$11<43),$N$14,IF($N$11=$R$48,$N$12)))))),\"\")","v":0},{"$f":"ROUND(F48*'Info Sheet'!N48/100,0)","v":0},{"$f":"ROUND(F48*'Info Sheet'!Q48/100,0)","v":0},null,0,null,null,null,null,7,2024,"7-2024",43,31,"",null,0,0,0,0,{"$f":"ROUND(C48*'Info Sheet'!P48/100,0)","v":0},0,0,0,{"$f":"ROUND(F48*'Info Sheet'!P48/100,0)","v":0},0,0,0]
[null,"",{"$f":"IFERROR(IF(T49=\"\",0,IF($N$11<7,$M$17,IF(AND($N$11>6,$N$11<19),$M$16,IF(AND($N$11>18,$N$11<31),$M$15,IF(AND($N$11>30,$N$11<43),$M$14,IF(C48>0,$M$13,$M$12)))))),\"\")","v":0},{"$f":"ROUND(C49*'Info Sheet'!N49/100,0)","v":0},{"$f":"ROUND(C49*'Info Sheet'!Q49/100,0)","v":0},{"$f":"IFERROR(IF(T49=\"\",0,IF($N$11<7,$N$17,IF(AND($N$11>6,$N$11<19),$N$16,IF(AND($N$11>18,$N$11<31),$N$15,IF(AND($N$11>30,$N$11<43),$N$14,IF(F48>0,$N$13,$N$12)))))),\"\")","v":0},{"$f":"ROUND(F49*'Info Sheet'!N49/100,0)","v":0},{"$f":"ROUND(F49*'Info Sheet'!Q49/100,0)","v":0},null,0,null,null,null,null,8,2024,"8-2024",44,31,"",null,0,0,0,0,{"$f":"ROUND(C49*'Info Sheet'!P49/100,0)","v":0},0,0,0,{"$f":"ROUND(F49*'Info Sheet'!P49/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C50*'Info Sheet'!N50/100,0)","v":0},{"$f":"ROUND(C50*'Info Sheet'!Q50/100,0)","v":0},0,{"$f":"ROUND(F50*'Info Sheet'!N50/100,0)","v":0},{"$f":"ROUND(F50*'Info Sheet'!Q50/100,0)","v":0},null,0,null,null,null,null,9,2024,"9-2024",45,30,"",null,0,0,0,0,{"$f":"ROUND(C50*'Info Sheet'!P50/100,0)","v":0},0,0,0,{"$f":"ROUND(F50*'Info Sheet'!P50/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C51*'Info Sheet'!N51/100,0)","v":0},{"$f":"ROUND(C51*'Info Sheet'!Q51/100,0)","v":0},0,{"$f":"ROUND(F51*'Info Sheet'!N51/100,0)","v":0},{"$f":"ROUND(F51*'Info Sheet'!Q51/100,0)","v":0},null,0,null,null,null,null,10,2024,"10-2024",46,31,"",null,0,0,0,0,{"$f":"ROUND(C51*'Info Sheet'!P51/100,0)","v":0},0,0,0,{"$f":"ROUND(F51*'Info Sheet'!P51/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C52*'Info Sheet'!N52/100,0)","v":0},{"$f":"ROUND(C52*'Info Sheet'!Q52/100,0)","v":0},0,{"$f":"ROUND(F52*'Info Sheet'!N52/100,0)","v":0},{"$f":"ROUND(F52*'Info Sheet'!Q52/100,0)","v":0},null,0,null,null,null,null,11,2024,"11-2024",47,30,"",null,0,0,0,0,{"$f":"ROUND(C52*'Info Sheet'!P52/100,0)","v":0},0,0,0,{"$f":"ROUND(F52*'Info Sheet'!P52/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C53*'Info Sheet'!N53/100,0)","v":0},{"$f":"ROUND(C53*'Info Sheet'!Q53/100,0)","v":0},0,{"$f":"ROUND(F53*'Info Sheet'!N53/100,0)","v":0},{"$f":"ROUND(F53*'Info Sheet'!Q53/100,0)","v":0},null,0,null,null,null,null,12,2024,"12-2024",48,31,"",null,0,0,0,0,{"$f":"ROUND(C53*'Info Sheet'!P53/100,0)","v":0},0,0,0,{"$f":"ROUND(F53*'Info Sheet'!P53/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C54*'Info Sheet'!N54/100,0)","v":0},{"$f":"ROUND(C54*'Info Sheet'!Q54/100,0)","v":0},0,{"$f":"ROUND(F54*'Info Sheet'!N54/100,0)","v":0},{"$f":"ROUND(F54*'Info Sheet'!Q54/100,0)","v":0},null,0,null,null,null,null,1,2025,"1-2025",49,31,"",null,0,0,0,0,{"$f":"ROUND(C54*'Info Sheet'!P54/100,0)","v":0},0,0,0,{"$f":"ROUND(F54*'Info Sheet'!P54/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C55*'Info Sheet'!N55/100,0)","v":0},{"$f":"ROUND(C55*'Info Sheet'!Q55/100,0)","v":0},0,{"$f":"ROUND(F55*'Info Sheet'!N55/100,0)","v":0},{"$f":"ROUND(F55*'Info Sheet'!Q55/100,0)","v":0},null,0,null,null,null,null,2,2025,"2-2025",50,28,"",null,0,0,0,0,{"$f":"ROUND(C55*'Info Sheet'!P55/100,0)","v":0},0,0,0,{"$f":"ROUND(F55*'Info Sheet'!P55/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C56*'Info Sheet'!N56/100,0)","v":0},{"$f":"ROUND(C56*'Info Sheet'!Q56/100,0)","v":0},0,{"$f":"ROUND(F56*'Info Sheet'!N56/100,0)","v":0},{"$f":"ROUND(F56*'Info Sheet'!Q56/100,0)","v":0},null,0,null,null,null,null,3,2025,"3-2025",51,31,"",null,0,0,0,0,{"$f":"ROUND(C56*'Info Sheet'!P56/100,0)","v":0},0,0,0,{"$f":"ROUND(F56*'Info Sheet'!P56/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C57*'Info Sheet'!N57/100,0)","v":0},{"$f":"ROUND(C57*'Info Sheet'!Q57/100,0)","v":0},0,{"$f":"ROUND(F57*'Info Sheet'!N57/100,0)","v":0},{"$f":"ROUND(F57*'Info Sheet'!Q57/100,0)","v":0},null,0,null,null,null,null,4,2025,"4-2025",52,30,"",null,0,0,0,0,{"$f":"ROUND(C57*'Info Sheet'!P57/100,0)","v":0},0,0,0,{"$f":"ROUND(F57*'Info Sheet'!P57/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C58*'Info Sheet'!N58/100,0)","v":0},{"$f":"ROUND(C58*'Info Sheet'!Q58/100,0)","v":0},0,{"$f":"ROUND(F58*'Info Sheet'!N58/100,0)","v":0},{"$f":"ROUND(F58*'Info Sheet'!Q58/100,0)","v":0},null,0,null,null,null,null,5,2025,"5-2025",53,31,"",null,0,0,0,0,{"$f":"ROUND(C58*'Info Sheet'!P58/100,0)","v":0},0,0,0,{"$f":"ROUND(F58*'Info Sheet'!P58/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C59*'Info Sheet'!N59/100,0)","v":0},{"$f":"ROUND(C59*'Info Sheet'!Q59/100,0)","v":0},0,{"$f":"ROUND(F59*'Info Sheet'!N59/100,0)","v":0},{"$f":"ROUND(F59*'Info Sheet'!Q59/100,0)","v":0},null,0,null,null,null,null,6,2025,"6-2025",54,30,"",null,0,0,0,0,{"$f":"ROUND(C59*'Info Sheet'!P59/100,0)","v":0},0,0,0,{"$f":"ROUND(F59*'Info Sheet'!P59/100,0)","v":0},0,0,0]
[null,"",{"$f":"IFERROR(IF(T60=\"\",0,IF($N$11<7,$M$18,IF(AND($N$11>6,$N$11<19),$M$17,IF(AND($N$11>18,$N$11<31),$M$16,IF(AND($N$11>30,$N$11<43),$M$15,IF(AND($N$11>42,$N$11<55),$M$14,IF($N$11=$R$60,$M$12))))))),\"\")","v":0},{"$f":"ROUND(C60*'Info Sheet'!N60/100,0)","v":0},{"$f":"ROUND(C60*'Info Sheet'!Q60/100,0)","v":0},{"$f":"IFERROR(IF(T60=\"\",0,IF($N$11<7,$N$18,IF(AND($N$11>6,$N$11<19),$N$17,IF(AND($N$11>18,$N$11<31),$N$16,IF(AND($N$11>30,$N$11<43),$N$15,IF(AND($N$11>42,$N$11<55),$N$14,IF($N$11=$R$60,$N$12))))))),\"\")","v":0},{"$f":"ROUND(F60*'Info Sheet'!N60/100,0)","v":0},{"$f":"ROUND(F60*'Info Sheet'!Q60/100,0)","v":0},null,0,null,null,null,null,7,2025,"7-2025",55,31,"",null,0,0,0,0,{"$f":"ROUND(C60*'Info Sheet'!P60/100,0)","v":0},0,0,0,{"$f":"ROUND(F60*'Info Sheet'!P60/100,0)","v":0},0,0,0]
[null,"",{"$f":"IFERROR(IF(T61=\"\",0,IF($N$11<7,$M$18,IF(AND($N$11>6,$N$11<19),$M$17,IF(AND($N$11>18,$N$11<31),$M$16,IF(AND($N$11>30,$N$11<43),$M$15,IF(AND($N$11>42,$N$11<55),$M$14,IF(C60>0,$M$13,$M$12))))))),\"\")","v":0},{"$f":"ROUND(C61*'Info Sheet'!N61/100,0)","v":0},{"$f":"ROUND(C61*'Info Sheet'!Q61/100,0)","v":0},{"$f":"IFERROR(IF(T61=\"\",0,IF($N$11<7,$N$18,IF(AND($N$11>6,$N$11<19),$N$17,IF(AND($N$11>18,$N$11<31),$N$16,IF(AND($N$11>30,$N$11<43),$N$15,IF(AND($N$11>42,$N$11<55),$N$14,IF(F60>0,$N$13,$N$12))))))),\"\")","v":0},{"$f":"ROUND(F61*'Info Sheet'!N61/100,0)","v":0},{"$f":"ROUND(F61*'Info Sheet'!Q61/100,0)","v":0},null,0,null,null,null,null,8,2025,"8-2025",56,31,"",null,0,0,0,0,{"$f":"ROUND(C61*'Info Sheet'!P61/100,0)","v":0},0,0,0,{"$f":"ROUND(F61*'Info Sheet'!P61/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C62*'Info Sheet'!N62/100,0)","v":0},{"$f":"ROUND(C62*'Info Sheet'!Q62/100,0)","v":0},0,{"$f":"ROUND(F62*'Info Sheet'!N62/100,0)","v":0},{"$f":"ROUND(F62*'Info Sheet'!Q62/100,0)","v":0},null,0,null,null,null,null,9,2025,"9-2025",57,30,"",null,0,0,0,0,{"$f":"ROUND(C62*'Info Sheet'!P62/100,0)","v":0},0,0,0,{"$f":"ROUND(F62*'Info Sheet'!P62/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C63*'Info Sheet'!N63/100,0)","v":0},{"$f":"ROUND(C63*'Info Sheet'!Q63/100,0)","v":0},0,{"$f":"ROUND(F63*'Info Sheet'!N63/100,0)","v":0},{"$f":"ROUND(F63*'Info Sheet'!Q63/100,0)","v":0},null,0,null,null,null,null,10,2025,"10-2025",58,31,"",null,0,0,0,0,{"$f":"ROUND(C63*'Info Sheet'!P63/100,0)","v":0},0,0,0,{"$f":"ROUND(F63*'Info Sheet'!P63/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C64*'Info Sheet'!N64/100,0)","v":0},{"$f":"ROUND(C64*'Info Sheet'!Q64/100,0)","v":0},0,{"$f":"ROUND(F64*'Info Sheet'!N64/100,0)","v":0},{"$f":"ROUND(F64*'Info Sheet'!Q64/100,0)","v":0},null,0,null,null,null,null,11,2025,"11-2025",59,30,"",null,0,0,0,0,{"$f":"ROUND(C64*'Info Sheet'!P64/100,0)","v":0},0,0,0,{"$f":"ROUND(F64*'Info Sheet'!P64/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C65*'Info Sheet'!N65/100,0)","v":0},{"$f":"ROUND(C65*'Info Sheet'!Q65/100,0)","v":0},0,{"$f":"ROUND(F65*'Info Sheet'!N65/100,0)","v":0},{"$f":"ROUND(F65*'Info Sheet'!Q65/100,0)","v":0},null,0,null,null,null,null,12,2025,"12-2025",60,31,"",null,0,0,0,0,{"$f":"ROUND(C65*'Info Sheet'!P65/100,0)","v":0},0,0,0,{"$f":"ROUND(F65*'Info Sheet'!P65/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C66*'Info Sheet'!N66/100,0)","v":0},{"$f":"ROUND(C66*'Info Sheet'!Q66/100,0)","v":0},0,{"$f":"ROUND(F66*'Info Sheet'!N66/100,0)","v":0},{"$f":"ROUND(F66*'Info Sheet'!Q66/100,0)","v":0},null,0,null,null,null,null,1,2026,"1-2026",61,31,"",null,0,0,0,0,{"$f":"ROUND(C66*'Info Sheet'!P66/100,0)","v":0},0,0,0,{"$f":"ROUND(F66*'Info Sheet'!P66/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C67*'Info Sheet'!N67/100,0)","v":0},{"$f":"ROUND(C67*'Info Sheet'!Q67/100,0)","v":0},0,{"$f":"ROUND(F67*'Info Sheet'!N67/100,0)","v":0},{"$f":"ROUND(F67*'Info Sheet'!Q67/100,0)","v":0},null,0,null,null,null,null,2,2026,"2-2026",62,28,"",null,0,0,0,0,{"$f":"ROUND(C67*'Info Sheet'!P67/100,0)","v":0},0,0,0,{"$f":"ROUND(F67*'Info Sheet'!P67/100,0)","v":0},0,0,0]
[null,"",0,{"$f":"ROUND(C68*'Info Sheet'!N68/100,0)","v":0},{"$f":"ROUND(C68*'Info Sheet'!Q68/100,0)","v":0},0,{"$f":"ROUND(F68*'Info Sheet'!N68/100,0)","v":0},{"$f":"ROUND(F68*'Info Sheet'!Q68/100,0)","v":0},null,0,null,null,null,null,3,2026,"3-2026",63,31,"",null,0,0,0,0,{"$f":"ROUND(C68*'Info Sheet'!P68/100,0)","v":0},0,0,0,{"$f":"ROUND(F68*'Info Sheet'!P68/100,0)","v":0},0,0,0]
[{"$f":"IFERROR(IF(T72=\"\",0,IF($N$11<7,$N$18,IF(AND($N$11>6,$N$11<19),$N$17,IF(AND($N$11>18,$N$11<31),$N$16,IF(AND($N$11>30,$N$11<43),$N$15,IF(AND($N$11>42,$N$11<55),$N$14,IF(F71>0,$N$13,$N$12))))))),\"\")","v":0},"",0,{"$f":"ROUND(C69*'Info Sheet'!N69/100,0)","v":0},{"$f":"ROUND(C69*'Info Sheet'!Q69/100,0)","v":0},0,{"$f":"ROUND(F69*'Info Sheet'!N69/100,0)","v":0},{"$f":"ROUND(F69*'Info Sheet'!Q69/100,0)","v":0},null,0,null,null,null,null,4,2026,"4-2026",64,30,"",null,0,0,0,0,{"$f":"ROUND(C69*'Info Sheet'!P69/100,0)","v":0},0,0,0,{"$f":"ROUND(F69*'Info Sheet'!P69/100,0)","v":0},0,0,0]
[{"$f":"IF(AND(N9>55,N9<77),N13,A69)","v":0},"",0,{"$f":"ROUND(C70*'Info Sheet'!N70/100,0)","v":0},{"$f":"ROUND(C70*'Info Sheet'!Q70/100,0)","v":0},0,{"$f":"ROUND(F70*'Info Sheet'!N70/100,0)","v":0},{"$f":"ROUND(F70*'Info Sheet'!Q70/100,0)","v":0},null,{"$f":"ROUND((SUM(C70:E70)-SUM(F70:H70))*$J$5,0)","v":0},null,null,null,null,5,2026,"5-2026",65,31,{"$f":"IFERROR(IF($N$10<R70,\"\",IF($N$11<=R70,Q70,\"\")),\"\")","v":""},null,0,0,0,0,{"$f":"ROUND(C70*'Info Sheet'!P70/100,0)","v":0},0,0,0,{"$f":"ROUND(F70*'Info Sheet'!P70/100,0)","v":0},0,0,0]
[{"$f":"IFERROR(IF(T72=\"\",0,IF($N$11<7,$M$18,IF(AND($N$11>6,$N$11<19),$M$17,IF(AND($N$11>18,$N$11<31),$M$16,IF(AND($N$11>30,$N$11<43),$M$15,IF(AND($N$11>42,$N$11<55),$M$14,IF(C71>0,$M$13,$M$12))))))),\"\")","v":0},{"$f":"T71","v":""},0,{"$f":"ROUND(C71*'Info Sheet'!N71/100,0)","v":0},{"$f":"ROUND(C71*'Info Sheet'!Q71/100,0)","v":0},0,{"$f":"ROUND(F71*'Info Sheet'!N71/100,0)","v":0},{"$f":"ROUND(F71*'Info Sheet'!Q71/100,0)","v":0},null,0,null,null,null,null,6,2026,{"$f":"O71&\"-\"&P71","v":"6-2026"},66,30,"",null,{"$f":"IF(C71>=$M$13,C71,0)","v":0},{"$f":"IF(F71>=$N$13,F71,0)","v":0},{"$f":"IF(V71>51500,3575,IF(V71>38500,2850,IF(V71>28500,2100,IF(V71>23000,1625,IF(V71>0,1450,0)))))","v":0},{"$f":"IF(V71>167000,10500,IF(V71>116000,8900,IF(V71>80000,6150,IF(V71>72000,4800,IF(V71>62000,4200,X71)))))","v":0},{"$f":"ROUND(C71*'Info Sheet'!P71/100,0)","v":0},{"$f":"Y71+Z71","v":0},{"$f":"IF(W71>51500,3575,IF(W71>38500,2850,IF(W71>28500,2100,IF(W71>23000,1625,IF(W71>0,1450,0)))))","v":0},{"$f":"IF(W71>167000,10500,IF(W71>116000,8900,IF(W71>80000,6150,IF(W71>72000,4800,IF(W71>62000,4200,AB71)))))","v":0},{"$f":"ROUND(F71*'Info Sheet'!P71/100,0)","v":0},{"$f":"AC71+AD71","v":0},{"$f":"IF(V71>54000,875,IF(V71>33500,658,IF(V71>18000,440,IF(V71>0,265,0))))","v":0},{"$f":"IF(W71>54000,875,IF(W71>33500,658,IF(W71>18000,440,IF(W71>0,265,0))))","v":0}]
[{"$f":"IF(AND(N9>55,N9<77),M13,A71)","v":0},"",{"$f":"A72","v":0},{"$f":"ROUND(C72*'Info Sheet'!N72/100,0)","v":0},{"$f":"ROUND(C72*'Info Sheet'!Q72/100,0)","v":0},{"$f":"A70","v":0},{"$f":"ROUND(F72*'Info Sheet'!N72/100,0)","v":0},{"$f":"ROUND(F72*'Info Sheet'!Q72/100,0)","v":0},null,0,null,null,null,null,7,2026,"7-2026",67,31,"",null,0,0,0,0,{"$f":"ROUND(C72*'Info Sheet'!P72/100,0)","v":0},0,0,0,{"$f":"ROUND(F72*'Info Sheet'!P72/100,0)","v":0},0,0,0]
[null,"",{"$f":"IFERROR(IF(T73=\"\",0,IF($N$11<7,$M$18,IF(AND($N$11>6,$N$11<19),$M$17,IF(AND($N$11>18,$N$11<31),$M$16,IF(AND($N$11>30,$N$11<43),$M$15,IF(AND($N$11>42,$N$11<55),$M$14,IF(C72>0,$M$13,$M$12))))))),\"\")","v":0},{"$f":"ROUND(C73*'Info Sheet'!N73/100,0)","v":0},{"$f":"ROUND(C73*'Info Sheet'!Q73/100,0)","v":0},{"$f":"IFERROR(IF(T73=\"\",0,IF($N$11<7,$N$18,IF(AND($N$11>6,$N$11<19),$N$17,IF(AND($N$11>18,$N$11<31),$N$16,IF(AND($N$11>30,$N$11<43),$N$15,IF(AND($N$11>42,$N$11<55),$N$14,IF(F72>0,$N$13,$N$12))))))),\"\")","v":0},{"$f":"ROUND(F73*'Info Sheet'!N73/100,0)","v":0},{"$f":"ROUND(F73*'Info Sheet'!Q73/100,0)","v":0},null,0,null,null,null,null,8,2026,"8-2026",68,31,"",null,0,0,0,0,{"$f":"ROUND(C73*'Info Sheet'!P73/100,0)","v":0},0,0,0,{"$f":"ROUND(F73*'Info Sheet'!P73/100,0)","v":0},0,0,0]
[null,"",{"$f":"IFERROR(IF(T74=\"\",0,IF($N$11<7,$M$18,IF(AND($N$11>6,$N$11<19),$M$17,IF(AND($N$11>18,$N$11<31),$M$16,IF(AND($N$11>30,$N$11<43),$M$15,IF(AND($N$11>42,$N$11<55),$M$14,IF(C73>0,$M$13,$M$12))))))),\"\")","v":0},{"$f":"ROUND(C74*'Info Sheet'!N74/100,0)","v":0},{"$f":"ROUND(C74*'Info Sheet'!Q74/100,0)","v":0},{"$f":"IFERROR(IF(T74=\"\",0,IF($N$11<7,$N$18,IF(AND($N$11>6,$N$11<19),$N$17,IF(AND($N$11>18,$N$11<31),$N$16,IF(AND($N$11>30,$N$11<43),$N$15,IF(AND($N$11>42,$N$11<55),$N$14,IF(F73>0,$N$13,$N$12))))))),\"\")","v":0},{"$f":"ROUND(F74*'Info Sheet'!N74/100,0)","v":0},{"$f":"ROUND(F74*'Info Sheet'!Q74/100,0)","v":0},null,0,null,null,null,null,9,2026,"9-2026",69,30,"",null,0,0,0,0,{"$f":"ROUND(C74*'Info Sheet'!P74/100,0)","v":0},0,0,0,{"$f":"ROUND(F74*'Info Sheet'!P74/100,0)","v":0},0,0,0]
[null,"",{"$f":"IFERROR(IF(T75=\"\",0,IF($N$11<7,$M$18,IF(AND($N$11>6,$N$11<19),$M$17,IF(AND($N$11>18,$N$11<31),$M$16,IF(AND($N$11>30,$N$11<43),$M$15,IF(AND($N$11>42,$N$11<55),$M$14,IF(C74>0,$M$13,$M$12))))))),\"\")","v":0},{"$f":"ROUND(C75*'Info Sheet'!N75/100,0)","v":0},{"$f":"ROUND(C75*'Info Sheet'!Q75/100,0)","v":0},{"$f":"IFERROR(IF(T75=\"\",0,IF($N$11<7,$N$18,IF(AND($N$11>6,$N$11<19),$N$17,IF(AND($N$11>18,$N$11<31),$N$16,IF(AND($N$11>30,$N$11<43),$N$15,IF(AND($N$11>42,$N$11<55),$N$14,IF(F74>0,$N$13,$N$12))))))),\"\")","v":0},{"$f":"ROUND(F75*'Info Sheet'!N75/100,0)","v":0},{"$f":"ROUND(F75*'Info Sheet'!Q75/100,0)","v":0},null,0,null,null,null,null,10,2026,"10-2026",70,31,"",null,0,0,0,0,{"$f":"ROUND(C75*'Info Sheet'!P75/100,0)","v":0},0,0,0,{"$f":"ROUND(F75*'Info Sheet'!P75/100,0)","v":0},0,0,0]
[null,"",{"$f":"IFERROR(IF(T76=\"\",0,IF($N$11<7,$M$18,IF(AND($N$11>6,$N$11<19),$M$17,IF(AND($N$11>18,$N$11<31),$M$16,IF(AND($N$11>30,$N$11<43),$M$15,IF(AND($N$11>42,$N$11<55),$M$14,IF(C75>0,$M$13,$M$12))))))),\"\")","v":0},{"$f":"ROUND(C76*'Info Sheet'!N76/100,0)","v":0},{"$f":"ROUND(C76*'Info Sheet'!Q76/100,0)","v":0},{"$f":"IFERROR(IF(T76=\"\",0,IF($N$11<7,$N$18,IF(AND($N$11>6,$N$11<19),$N$17,IF(AND($N$11>18,$N$11<31),$N$16,IF(AND($N$11>30,$N$11<43),$N$15,IF(AND($N$11>42,$N$11<55),$N$14,IF(F75>0,$N$13,$N$12))))))),\"\")","v":0},{"$f":"ROUND(F76*'Info Sheet'!N76/100,0)","v":0},{"$f":"ROUND(F76*'Info Sheet'!Q76/100,0)","v":0},null,0,null,null,null,null,11,2026,"11-2026",71,30,"",null,0,0,0,0,{"$f":"ROUND(C76*'Info Sheet'!P76/100,0)","v":0},0,0,0,{"$f":"ROUND(F76*'Info Sheet'!P76/100,0)","v":0},0,0,0]
[null,"",{"$f":"IFERROR(IF(T77=\"\",0,IF($N$11<7,$M$18,IF(AND($N$11>6,$N$11<19),$M$17,IF(AND($N$11>18,$N$11<31),$M$16,IF(AND($N$11>30,$N$11<43),$M$15,IF(AND($N$11>42,$N$11<55),$M$14,IF(C76>0,$M$13,$M$12))))))),\"\")","v":0},{"$f":"ROUND(C77*'Info Sheet'!N77/100,0)","v":0},{"$f":"ROUND(C77*'Info Sheet'!Q77/100,0)","v":0},{"$f":"IFERROR(IF(T77=\"\",0,IF($N$11<7,$N$18,IF(AND($N$11>6,$N$11<19),$N$17,IF(AND($N$11>18,$N$11<31),$N$16,IF(AND($N$11>30,$N$11<43),$N$15,IF(AND($N$11>42,$N$11<55),$N$14,IF(F76>0,$N$13,$N$12))))))),\"\")","v":0},{"$f":"ROUND(F77*'Info Sheet'!N77/100,0)","v":0},{"$f":"ROUND(F77*'Info Sheet'!Q77/100,0)","v":0},null,0,null,null,null,null,12,2026,"12-2026",72,31,"",null,0,0,0,0,{"$f":"ROUND(C77*'Info Sheet'!P77/100,0)","v":0},0,0,0,{"$f":"ROUND(F77*'Info Sheet'!P77/100,0)","v":0},0,0,0]

{"sheet":"Arrear Sheet","index":2,"n_rows":86,"n_cols":29,"rows_kept":86,"cut":false,"hidden":false,"merged":[[3,28,4,28],[0,1,0,28],[3,1,4,1],[3,2,3,5],[3,6,3,9],[3,10,3,13],[3,14,3,16],[3,20,3,22],[3,23,3,25],[3,26,4,26],[3,27,4,27],[3,17,3,19]]}
[null,"Office of the Principal, Govt Sr Sec School Malutana (Thanagazi) Alwar"]
[null,"Salary Arrear from 01-Jan-2021 to Nov-2021"]
[null,1,"Name : Pramod Kumar Saini",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Desination : Teacher"]
[null,"Month\n/\nYear","PAY DUE",null,null,null,"PAY DRAWN",null,null,null,"PAY DIFFERENCE",null,null,null,{"$f":"IFERROR(VLOOKUP(B3,'Info Sheet'!$B$6:$K$20,9,0),\"\")","v":"GPF 2004"},null,null,"SIP",null,null,"RGHS",null,null,"I TAX",null,null,"Total\nDedu","Net\nPay","TV\nNo"]
[null,null,"Basic","DA","HRA","Total","Basic","DA","HRA","Total","Basic","DA","HRA",{"$f":"IF(F5=\"\",\"\",F5)","v":"Total"},"Due","Dedu","Diff","Due","Dedu","Diff","Due","Dedu","Diff","Due","Dedu","Diff"]
[null,"2021-01-01",47900,8143,3832,{"$f":"SUM(C6:E6)","v":59875},45100,7667,3608,{"$f":"SUM(G6:I6)","v":56375},{"$f":"C6-G6","v":2800},{"$f":"D6-H6","v":476},{"$f":"E6-I6","v":224},{"$f":"SUM(K6:M6)","v":3500},2850,2850,{"$f":"O6-P6","v":0},0,0,{"$f":"R6-S6","v":0},658,658,{"$f":"U6-V6","v":0},350,0,{"$f":"X6-Y6","v":350},{"$f":"Q6+T6+W6+Z6","v":350},{"$f":"N6-AA6","v":3150}]
[null,"2021-02-01",47900,8143,3832,{"$f":"SUM(C7:E7)","v":59875},45100,7667,3608,{"$f":"SUM(G7:I7)","v":56375},{"$f":"C7-G7","v":2800},{"$f":"D7-H7","v":476},{"$f":"E7-I7","v":224},{"$f":"SUM(K7:M7)","v":3500},2850,2850,{"$f":"O7-P7","v":0},0,0,{"$f":"R7-S7","v":0},658,658,{"$f":"U7-V7","v":0},350,0,{"$f":"X7-Y7","v":350},{"$f":"Q7+T7+W7+Z7","v":350},{"$f":"N7-AA7","v":3150}]
[null,"2021-03-01",47900,8143,3832,{"$f":"SUM(C8:E8)","v":59875},45100,7667,3608,56375,2800,476,224,3500,2850,2850,0,0,0,0,658,658,0,350,0,350,350,3150]
[null,"2021-04-01",47900,8143,3832,59875,45100,7667,3608,56375,2800,476,224,3500,2850,2850,0,0,0,0,658,658,0,350,0,350,350,3150]
[null,"2021-05-01",47900,8143,3832,59875,45100,7667,3608,56375,2800,476,224,3500,2850,2850,0,0,0,0,658,658,0,350,0,350,350,3150]
[null,"2021-06-01",47900,8143,3832,59875,45100,7667,3608,56375,2800,476,224,3500,2850,2850,0,0,0,0,658,658,0,350,0,350,350,3150]
[null,"2021-07-01",49300,15283,4437,69020,46500,14415,4185,65100,2800,868,252,3920,9752,9360,392,0,0,0,658,658,0,392,0,392,784,3136]
[null,"2021-08-01",49300,15283,4437,69020,46500,14415,4185,65100,2800,868,252,3920,9752,9360,392,0,0,0,658,658,0,392,0,392,784,3136]
[null,"2021-09-01",49300,15283,4437,69020,46500,14415,4185,65100,2800,868,252,3920,9752,9360,392,0,0,0,658,658,0,392,0,392,784,3136]
[null,"2021-10-01",49300,15283,4437,69020,46500,14415,4185,65100,2800,868,252,3920,2850,2850,0,0,0,0,658,658,0,392,0,392,392,3528]
[null,"2021-11-01",49300,15283,4437,69020,46500,14415,4185,65100,2800,868,252,3920,2850,2850,0,0,0,0,658,658,0,392,0,392,392,3528]
[null,"2021-12-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2022-01-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2022-02-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2022-03-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2022-04-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2022-05-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2022-06-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2022-07-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2022-08-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2022-09-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2022-10-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2022-11-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2022-12-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2023-01-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2023-02-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2023-03-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2023-04-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2023-05-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2023-06-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2023-07-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2023-08-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2023-09-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2023-10-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2023-11-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2023-12-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2024-01-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2024-02-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2024-03-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2024-04-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2024-05-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2024-06-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2024-07-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2024-08-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2024-09-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2024-10-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2024-11-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2024-12-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2025-01-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2025-02-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2025-03-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2025-04-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2025-05-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2025-06-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2025-07-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2025-08-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2025-09-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2025-10-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2025-11-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2025-12-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2026-01-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2026-02-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2026-03-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2026-04-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2026-05-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2026-06-01",0,0,0,0,0,0,0,{"$f":"SUM(G71:I71)","v":0},{"$f":"C71-G71","v":0},{"$f":"D71-H71","v":0},{"$f":"E71-I71","v":0},{"$f":"SUM(K71:M71)","v":0},0,0,{"$f":"O71-P71","v":0},0,0,{"$f":"R71-S71","v":0},0,0,{"$f":"U71-V71","v":0},0,0,{"$f":"X71-Y71","v":0},{"$f":"Q71+T71+W71+Z71","v":0},{"$f":"N71-AA71","v":0}]
[null,"2026-07-01",0,0,0,{"$f":"SUM(C72:E72)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2026-08-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2026-09-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2026-10-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2026-11-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2026-12-01",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total",{"$f":"SUM(C6:C77)","v":533900},{"$f":"SUM(D6:D77)","v":125273},45177,704350,503100,118077,42573,663750,30800,7196,2604,40600,52056,50880,1176,0,0,0,7238,7238,0,4060,0,4060,5236,35364]
[null,null,null,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":"\"Net payable amount in words \"&SpellIndian(AB78)","v":"Net payable amount in words Rupees Thirty Five Thousand Three Hundred Sixty Four Only"}]
[null,"izek.khdj.k %"]
[null,"1- izekf.kr fd;k tkrk gS fd bl osru varj fooj.k izi= dk ;ksx QykoV tkWp fy;k x;k gS tks lgh gSA"]
[null,"2- izekf.kr fd;k tkrk gS fd bl fcy dk Hkqxrku iwoZ esa ugha mBk;k x;k gS vkSj uk gh mBk;k tkosxkA "]
[null,"3- izekf.kr fd;k tkrk gS fd lkekU; foÙkh; ,oa ys[kk fu;e vuqlkj jkf'k dk dk;kZy; fjdkWMZ esa bUnzkt dj fn;k x;k gSA"]
[null,"4- izekf.kr fd;k tkrk gS fd vk;dj vf/kfu;e 1961 ds fu;e vuqlkj vk;dj dh dVkSrh dj nh x;h gSA"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DDO's Signature with Official SEAL"]