{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Data","Proceedings","Bill Preparation","Bill","aptc 49"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":1,"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":"Data","index":0,"n_rows":182,"n_cols":22,"rows_kept":182,"cut":false,"hidden":false,"merged":[[13,7,13,8],[14,1,14,3],[15,1,15,3],[0,0,0,3],[1,1,1,2],[12,0,12,3],[2,1,2,2],[17,1,17,3],[13,1,13,3]]}
["Data of the Promoted Employee",null,null,null,null,null,null,null,"> < Inc",{"$f":"IF(D8<D5,1,2)","v":2},null,null,null,null,null,null,null,null,null,{"$f":"R2","v":20000}]
["Name","Smt Shaik ASHITUN (CFMS ID15087189)",null,"Female",null,{"$f":"IF(D2=\"Female\",\"her\",\"his\")","v":"her"},{"$f":"IF(Data!O7<Data!P7,1,2)","v":1},null,null,null,null,null,null,null,null,null,null,20000,600,20600,600,21200]
["Design.","PHYSICAL EDUCATION TEACHER",null,"CPS",null,null,null,null,null,null,null,null,null,null,null,null,null,20600,600,21200,600,21800]
["Promoted as","Teacher","Specify the Design."," SCHOOL ASST(Phy Ed)",null,{"$f":"DAY(B5)&\"-\"&MONTH(B5)&\"-\"&YEAR(B5)","v":"11-7-2023"},null,null,null,null,null,null,null,null,null,null,null,21200,600,21800,660,22460]
["Date of Joining","2023-07-11","Date of Increment","2023-06-01",{"$f":"DAY(B5)&\"-\"&MONTH(B5)&\"-\"&YEAR(B5)","v":"11-7-2023"},{"$f":"DAY(D5)&\"-\"&MONTH(D5)&\"-\"&YEAR(D5)","v":"1-6-2023"},{"$f":"DATE(YEAR(B5)+1,MONTH(B5),1)","v":"2024-07-01"},null,null,null,null,null,null,null,null,null,null,21800,660,22460,660,23120]
["Option Date","Promotion Date","Initial fixation done","No",{"$f":"IF(B6=\"Increment Date\",F5,E5)","v":"11-7-2023"},null,null,null,null,null,null,null,null,null,null,"Min Pay",null,22460,660,23120,660,23780]
["Present Scale of Pay","32670-101970","Promotion Scale","44570-127480",null,"FR 22(a)(i)","Pay with normal Inc",{"$f":"B8","v":34580},{"$f":"LOOKUP(H7,$R$2:$R$83,$S$2:$S$83)","v":990},null,null,null,null,{"$f":"SUM(I7:M7)","v":990},{"$f":"LOOKUP(H7,$R$2:$R$83,$T$2:$T$83)","v":35570},{"$f":"I135","v":44570},null,23120,660,23780,720,24500]
[{"$f":"\"Pay as on \"&E5","v":"Pay as on 11-7-2023"},34580,"Bill claimed upto","2023-09-30",{"$f":"D8+1","v":"2023-10-01"},"FR 22(B)","Notional Inc",{"$f":"O7","v":35570},{"$f":"LOOKUP(H8,$R$2:$R$83,$S$2:$S$83)","v":990},null,null,null,null,990,{"$f":"LOOKUP(H8,$R$2:$R$83,$T$2:$T$83)","v":36560},null,null,23780,720,24500,720,25220]
["whether 24 years scale drawn in previous cader","No","Place of posting"," ZPHSCHOOL EDLAPADU",null,null,"Next stage in pro. Scale",{"$f":"O8","v":36560},1080,null,null,null,null,1080,37640,null,null,24500,720,25220,720,25940]
["PPs",0,"FP",0,null,null,null,{"$f":"O9","v":37640},1080,null,null,null,null,1080,38720,null,null,25220,720,25940,780,26720]
["HMA",0,"CA/RA","Not Applicalbe",{"$f":"D5","v":"2023-06-01"},{"$f":"DATE(YEAR(E11)+1,MONTH(E11),1)","v":"2024-06-01"},{"$f":"DAY(F11)&\"-\"&MONTH(F11)&\"-\"&YEAR(F11)","v":"1-6-2024"},{"$f":"O10","v":38720},1080,null,null,null,null,1080,39800,null,null,25940,780,26720,780,27500]
["HRA",10,"CCA","Not Applicable",null,null,null,{"$f":"O11","v":39800},1170,null,null,null,null,1170,40970,null,null,26720,780,27500,780,28280]
["Proceedings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27500,780,28280,850,29130]
["Name of the officer"," G VIJAYA BHARATHI B.Sc, MA, B.Ed",null,null,null,null,null,"Pay fixation ",null,null,"Bill Claim from",null,{"$f":"IF(D6=\"Yes\",D5,B5)","v":"2023-07-11"},null,null,null,null,28280,850,29130,850,29980]
["Designation","HEAD MASTER",null,null,null,null,"FR22(a)(i)",{"$f":"B5","v":"2023-07-11"},{"$f":"IF(O7<P7,P7,O7)","v":44570},null,null,null,null,null,null,null,null,29130,850,29980,850,30830]
["Office"," ZPHIGH SCHOOL  EDLAPADU ",null,null,null,null,"Pay with normal Inc",{"$f":"IF(B6=\"Promotion Date\",B5,D5)","v":"2023-07-11"},{"$f":"IF(O7<P7,P7,O7)","v":44570},null,null,null,null,null,null,null,null,29980,850,30830,920,31750]
["RC NO","5/ PROMOTION FR 22B /2023","Proceedings Date","2023-09-19",null,{"$f":"DAY(D17)&\"-\"&MONTH(D17)&\"-\"&YEAR(D17)","v":"19-9-2023"},"Notional Inc",{"$f":"IF(B9=\"Yes\",D5,H16)","v":"2023-07-11"},{"$f":"IF(O7<P7,P7,IF(B9=\"Yes\",O8,IF(B6=\"Increment Date\",O8,O7)))","v":44570},null,null,null,null,null,null,null,null,30830,920,31750,920,32670]
["Promotion order","RC No.2179/B2/2023 -9  dt 08-07-2023 of the DEO,  GUNTUR ",null,null,null,null,"Next stage in pro. Scale",{"$f":"H17","v":"2023-07-11"},{"$f":"IF(B9=\"Yes\",I17,IF(O7<P7,P7,IF(B6=\"Increment Date\",O9,O8)))","v":44570},{"$f":"LOOKUP(I18,$R$2:$R$81,$S$2:$S$81)","v":1260},null,null,null,null,{"$f":"SUM(J18:N18)","v":1260},{"$f":"I18+O18","v":45830},null,31750,920,32670,920,33590]
[null,null,null,null,null,null,"Next Inc.Date",{"$f":"F11","v":"2024-06-01"},{"$f":"P18","v":45830},null,null,null,null,null,null,null,null,32670,920,33590,990,34580]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33590,990,34580,990,35570]
[null,null,null,null,null,null,"Next Inc Date",{"$f":"IF(B6=\"Increment Date\",IF(H18>D8,MIN(H18:H19),H19))","v":false},null,null,null,null,null,null,null,null,null,34580,990,35570,990,36560]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35570,990,36560,1080,37640]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36560,1080,37640,1080,38720]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37640,1080,38720,1080,39800]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38720,1080,39800,1170,40970]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39800,1170,40970,1170,42140]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40970,1170,42140,1170,43310]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42140,1170,43310,1260,44570]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43310,1260,44570,1260,45830]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44570,1260,45830,1260,47090]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45830,1260,47090,1350,48440]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47090,1350,48440,1350,49790]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48440,1350,49790,1350,51140]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49790,1350,51140,1460,52600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51140,1460,52600,1460,54060]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52600,1460,54060,1460,55520]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54060,1460,55520,1580,57100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55520,1580,57100,1580,58680]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57100,1580,58680,1580,60260]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58680,1580,60260,1700,61960]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60260,1700,61960,1700,63660]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61960,1700,63660,1700,65360]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63660,1700,65360,1830,67190]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65360,1830,67190,1830,69020]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67190,1830,69020,1830,70850]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69020,1830,70850,1960,72810]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70850,1960,72810,1960,74770]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72810,1960,74770,1960,76730]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74770,1960,76730,2090,78820]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76730,2090,78820,2090,80910]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78820,2090,80910,2090,83000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80910,2090,83000,2240,85240]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83000,2240,85240,2240,87480]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85240,2240,87480,2240,89720]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87480,2240,89720,2390,92110]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89720,2390,92110,2390,94500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92110,2390,94500,2390,96890]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94500,2390,96890,2540,99430]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96890,2540,99430,2540,101970]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99430,2540,101970,2540,104510]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,101970,2540,104510,2700,107210]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104510,2700,107210,2700,109910]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,107210,2700,109910,2700,112610]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109910,2700,112610,2890,115500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,112610,2890,115500,2890,118390]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,115500,2890,118390,2890,121280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,118390,2890,121280,3100,124380]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,121280,3100,124380,3100,127480]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,124380,3100,127480,3100,130580]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127480,3100,130580,3320,133900]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130580,3320,133900,3320,137220]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,133900,3320,137220,3320,140540]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,137220,3320,140540,3610,144150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,140540,3610,144150,3610,147760]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,144150,3610,147760,3610,151370]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,147760,3610,151370,3610,154980]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,151370,3610,154980,3900,158880]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,154980,3900,158880,3900,162780]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,158880,3900,162780,3900,166680]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,162780,3900,166680,3900,170580]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,166680,3900,170580,4210,174790]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,170580,4210,174790,4210,179000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,174790,4210,179000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Pay","Inc","Pay",null,"S NO","Pay Grade","Pay Scale",null,"Min Pay"]
[20000,600,20600,null,1,"I","20000-600-21800-660-23780-720-25940-780-28280-850-30830-920-33590-990-36560-1080-39800-1170-43310-1260-47090-1350-51140-1460-55520-1580-60260-1700-61960","20000-61960",20000]
[20600,600,21200,null,2,"II","20600-600-21800-660-23780-720-25940-780-28280-850-30830-920-33590-990-36560-1080-39800-1170-43310-1260-47090-1350-51140-1460-55520-1580-60260-1700-63660","20600-63660",20600]
[21200,600,21800,null,3,"III","21200-600-21800-660-23780-720-25940-780-28280-850-30830-920-33590-990-36560-1080-39800-1170-43310-1260-47090-1350-51140-1460-55520-1580-60260-1700-65360","21200-65360",21200]
[21800,660,22460,null,4,"IV","22460-660-23780-720-25940-780-28280-850-30830-920-33590-990-36560-1080-39800-1170-43310-1260-47090-1350-51140-1460-55520-1580-60260-1700-65360-1830-70850-1960-72810","22460-72810",22460]
[22460,660,23120,null,5,"V","23120-660-23780-720-25940-780-28280-850-30830-920-33590-990-36560-1080-39800-1170-43310-1260-47090-1350-51140-1460-55520-1580-60260-1700-65360-1830-70850-1960-74770","23120-74770",23120]
[23120,660,23780,null,6,"VI","23780-720-25940-780-28280-850-30830-920-33590-990-36560-1080-39800-l170-43310-1260-47090-I350-5I140- l460-55520- 1580-60260-1700-65360-1830-70850-1960-76730","23780-76730",23780]
[23780,720,24500,null,7,"VII","25220-720-25940-780-28280-850-30830-920-33590-990-36560-1080-39800-1170-43310-1260-47090-1350-51140-1460-55520-1580-60260-1700-65360-1830-70850-1960-76730-2090-80910","25220-80910",25220]
[24500,720,25220,null,8,"VIII","27500-780-28280-850-30830-920-33590-990-36560-1080-39800-1170-43310-1260-47090-1350-51140-1460-55520-1580-60260-1700-65360-1830-70850-1960-76730-2090-83000-2240-87480","27500-87480",27500]
[25220,720,25940,null,9,"IX","28280-850-30830-920-33590-990-36560-1080-39800-1170-43310-1260-47090-1350-51140-1460-55520-1580-60260-1700-65360-1830-70850-1960-76730-2090-83000-2240-89720","28280-89720",28280]
[25940,780,26720,null,10,"X","29980-850-30830-920-33590-990-36560-1080-39800-1170-43310-1260-47090-1350-51140-1460-55520-1580-60260-1700-65360-1830-70850-1960-76730-2090-83000-2240-89720-2390-94500","29980-94500",29980]
[26720,780,27500,null,11,"XI","32670-920-33590-990-36560-1080-39800-1170-43310-1260-47090-1350-51140-1460-55520-1580-60260-1700-65360-1830-70850-1960-76730-2090-83000-2240-89720-2390-96890-2540-101970","32670-101970",32670]
[27500,780,28280,null,12,"XII","34580-990-36560-1080-39800-1170-43310-1260-47090-1350-51140-1460-5S520-1580-60260-1700-65360-1830-70850-1960-76730-2090-83000-2240-89720-2390-96890-2540-104510-2700-107210","34580-107210",34580]
[28280,850,29130,null,13,"XIII","35570-990-36560-1080-39800-1170-43310-1260-47090-1350-51140-1460-55520-1580-60260-1700-65360-1830-70850-1960-76730-2090-83000-2240-89720-2390-96890-2540-104510-2700-109910","35570-109910",35570]
[29130,850,29980,null,14,"XIV","37640-1080-39800-1170-43310-1260-47090-1350-51140-1460-55520-1580-60260-1700-65360-1830-70850-1960-76730-2090-83000-2240-89720-2390-96890-2540-104510-2700-112610-2890-115500","37640-115500",37640]
[29980,850,30830,null,15,"XV","38720-1080-39800-1170-43310-1260-47090-1350-51140-1460-55520-1580-60260-1700-65360-1830-70850-1960-76730-2090-83000-2240-89720-2390-96890-2540-104510-2700-112610-2890-118390","38720-118390",38720]
[30830,920,31750,null,16,"XVI","40970-1170-43310-1260-47090-1350-51140-1460-55520-1580-60260-1700-65360-1830-70850-1960-76730-2090-83000-2240-89720-2390-96890-2540-104510-2700-112610-2890-121280-3100-124380","40970-124380",40970]
[31750,920,32670,null,17,"XVII","44570-1260-47090-1350-51140-1460-55520-1580-60260-1700-65360-1830-70850-1960-76730-2090-83000-2240-89720-2390-96890-2540-104510-2700-112610-2890-121280-3100-127480","44570-127480",44570]
[32670,920,33590,null,18,"XVIII","45830-1260-47090-1350-51140-1460-55520-1580-60260-1700-65360-1830-70850-1960-76730-2090-83000-2240-89720-2390-96890-2540-104510-2700-112610-2890-121280-3100-130580","45830-130580",45830]
[33590,990,34580,null,19,"XVIV","48440-1350-51140-1460-55520-1580-60260-1700-65360-1830-70850-1960-76730-2090-83000-2240-89720-2390-96890-2540-104510-2700-112610-2890-121280-3100-130580-3320-137220","48440-137220",48440]
[34580,990,35570,null,20,"XX","54060-1460-55520-1580-60260-1700-65360-1830-70850-1960-76730-2090-83000-2240-89720-2390-96890-2540-104510-2700-112610-2890-121280-3100-130580-3320-140540","54060-140540",54060]
[35570,990,36560,null,21,"XXI","57100-1580-60260-1700-65360-1830-70850-1960-76730-2090-83000-2240-89720-2390-96890-2540-104510-2700-112610-2890-121280-3100-130580-3320-140540-3610-147760","57100-147760",57100]
[36560,1080,37640,null,22,"XXII","61960-1700-65360-1830-70850-1960-76730-2090-83000-2240-89720-2390-96890-2540-104510-2700-112610-2890-121280-3100-130580-3320-140540-3610-151370","61960-151370",61960]
[37640,1080,38720,null,23,"XXIII","65360-1830-70850-1960-76730-2090-83000-2240-89720-2390-96890-2540-104510-2700-112610-2890-121280-3100-130580-3320-140540-3610-154980","65360-154980",65360]
[38720,1080,39800,null,24,"XXIV","70850-1960-76730-2090-83000-2240-89720-2390-96890-2540-104510-2700-112610-2890-121280-3100-130580-3320-140540-3610-154980-3900-158880","70850-158880",70850]
[39800,1170,40970,null,25,"XXV","76730-2090-83000-2240-89720-2390-96890-2540-104510-2700-112610-2890-121280-3100-130580-3320-140540-3610-154980-3900-162780","76730-162780",76730]
[40970,1170,42140,null,26,"XXVI","80910-2090-83000-2240-89720-2390-96890-2540-104510-2700-112610-2890-121280-3100-130580-3320-140540-3610-154980-3900-166680","80910-166680",80910]
[42140,1170,43310,null,27,"XXVII","87480-2240-89720-2390-96890-2540-104510-2700-112610-2890-121280-3100-130580-3320-140540-3610-154980-3900-170580","87480-170580",87480]
[43310,1260,44570,null,28,"XXVIII","94500-2390-96890-2540-104510-2700-112610-2890-121280-3100-130580-3320-140540-3610-154980-3900-170580","94500-170580",94500]
[44570,1260,45830,null,29,"XXIX","101970-2540-104510-2700-112610-2890-121280-3100-130580-3320-140540-3610-154980-3900-170580-4210-174790","101970-174790",101970]
[45830,1260,47090,null,30,"XXX","112610-2890-121280-3100-130580-3320-140540-3610-154980-3900-170580-4210-174790","112610-174790",112610]
[47090,1350,48440,null,31,"XXXI","124380-3100-130580-3320-140540-3610-154980-3900-170580-4210-179000","124380-179000",124380]
[48440,1350,49790,null,32,"XXXII","133900-3320-140540-3610-154980-3900-170580-4210-179000","133900-179900",133900]
[49790,1350,51140]
[51140,1460,52600,null,{"$f":"RANK(I134,I101:I132,1)","v":11},"old",{"$f":"LOOKUP(E134,E101:E132,G101:G132)","v":"32670-920-33590-990-36560-1080-39800-1170-43310-1260-47090-1350-51140-1460-55520-1580-60260-1700-65360-1830-70850-1960-76730-2090-83000-2240-89720-2390-96890-2540-101970"},{"$f":"B7","v":"32670-101970"},{"$f":"IF(LEN(H134)=10,LEFT(H134,4)+1-1,LEFT(H134,5+1-1))*1","v":32670}]
[52600,1460,54060,null,{"$f":"RANK(I135,I101:I132,1)","v":17},"New",{"$f":"LOOKUP(E135,E101:E132,G101:G132)","v":"44570-1260-47090-1350-51140-1460-55520-1580-60260-1700-65360-1830-70850-1960-76730-2090-83000-2240-89720-2390-96890-2540-104510-2700-112610-2890-121280-3100-127480"},{"$f":"D7","v":"44570-127480"},{"$f":"IF(LEN(H135)=10,LEFT(H135,4)+1-1,LEFT(H135,5+1-1))*1","v":44570}]
[54060,1460,55520]
[55520,1580,57100]
[57100,1580,58680]
[58680,1580,60260]
[60260,1700,61960]
[61960,1700,63660]
[63660,1700,65360]
[65360,1830,67190]
[67190,1830,69020]
[69020,1830,70850]
[70850,1960,72810]
[72810,1960,74770]
[74770,1960,76730]
[76730,2090,78820]
[78820,2090,80910]
[80910,2090,83000]
[83000,2240,85240]
[85240,2240,87480]
[87480,2240,89720]
[89720,2390,92110]
[92110,2390,94500]
[94500,2390,96890]
[96890,2540,99430]
[99430,2540,101970]
[101970,2540,104510]
[104510,2700,107210]
[107210,2700,109910]
[109910,2700,112610]
[112610,2890,115500]
[115500,2890,118390]
[118390,2890,121280]
[121280,3100,124380]
[124380,3100,127480]
[127480,3100,130580]
[130580,3320,133900]
[133900,3320,137220]
[137220,3320,140540]
[140540,3610,144150]
[144150,3610,147760]
[147760,3610,151370]
[151370,3610,154980]
[154980,3900,158880]
[158880,3900,162780]
[162780,3900,166680]
[166680,3900,170580]
[170580,4210,174790]
[174790,4210,179000]

{"sheet":"Proceedings","index":1,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[[38,0,38,2],[38,3,38,4],[26,0,27,2],[28,0,29,2],[30,0,31,2],[33,0,33,4],[34,0,34,4],[37,3,37,4],[24,0,25,2],[0,0,0,4],[1,0,1,4],[5,1,5,4],[13,0,13,4],[14,0,14,4],[15,0,15,4],[17,0,17,4],[18,0,19,2],[20,0,21,2],[23,0,23,4],[9,1,9,4]]}
[{"$f":"\"PROCEEDINGS OF THE \"&Data!B15&\", \"&Data!B16","v":"PROCEEDINGS OF THE HEAD MASTER,  ZPHIGH SCHOOL  EDLAPADU "}]
[{"$f":"\"Present : \"&Data!B14","v":"Present :  G VIJAYA BHARATHI B.Sc, MA, B.Ed"}]
[]
["RC NO :",{"$f":"Data!B17","v":"5/ PROMOTION FR 22B /2023"},null,"Date :",{"$f":"Data!D17","v":"2023-09-19"}]
[]
["Sub:",{"$f":"\"Establishment - \"&Data!B16&\" - \"&PROPER(Data!B2)&\" - Promoted as \"&Data!D4&\" from \"&Data!B3&\"  - Opted to fix \"&Data!F2&\" pay under \"&IF(Data!B9=\"Yes\",\"FR 22(a)(i)\",\"FR 22(B)\")&\" with effect from \"&Data!E6&\" i.e.\"&Data!B6& \" - Pay fixation orders issued - Regarding.\"","v":"Establishment -  ZPHIGH SCHOOL  EDLAPADU  - Smt Shaik Ashitun (Cfms Id15087189) - Promoted as  SCHOOL ASST(Phy Ed) from PHYSICAL EDUCATION TEACHER  - Opted to fix her pay under FR 22(B) with effect from 11-7-2023 i.e.Promotion Date - Pay fixation orders issued - Regarding."}]
[null,"      "]
["Ref: ","1. G.O.Ms.No.1 Finance(PC-TA) Dept. Dt. 17-01-2022"]
[null,"2. G.O.Ms.No.100 Finance(PC-TA)Dept. Dt.11-05-2022"]
[null,{"$f":"\"3. \"&Data!B18","v":"3. RC No.2179/B2/2023 -9  dt 08-07-2023 of the DEO,  GUNTUR "}]
[null,"4. Option given by the individual"]
[]
[]
[{"$f":"\"                  \" &Data!B2&\" has been promoted as \"&\" \"&Data!D4&\" from \"&Data!B3&\"  and joined on the FN of  \"&Data!E5&\" in the promotion post vide the proceedings cited in the reference 3rd above.\"","v":"                  Smt Shaik ASHITUN (CFMS ID15087189) has been promoted as   SCHOOL ASST(Phy Ed) from PHYSICAL EDUCATION TEACHER  and joined on the FN of  11-7-2023 in the promotion post vide the proceedings cited in the reference 3rd above."}]
[{"$f":"\"                 And as per the reference 2nd and 4th cited the individual has opted to fix \"&Data!F2&\" pay in the promotion post scale under \"&IF(Data!B9=\"Yes\",\"FR 22(a)(i)\",\"FR 22(B)\")&\" from the \"&Data!B6& \" (\"&Data!E6&\")  due to promoted as \"&Data!D4","v":"                 And as per the reference 2nd and 4th cited the individual has opted to fix her pay in the promotion post scale under FR 22(B) from the Promotion Date (11-7-2023)  due to promoted as  SCHOOL ASST(Phy Ed)"}]
[{"$f":"\"                  As the individual is promoted  to next higher post, \"&IF(Data!D6=\"Yes\",PROPER(Data!F2)&\" Pay already initially fixed in the promotion post scale from \"&Data!E5&\" under FR 22(a)(1). Now \",\" \")&Data!F2&\" pay in the time scale of higher post shall be fixed in terms of \"&IF(Data!B9=\"Yes\",\"FR 22(a)(i) read with FR 31(2) as the individual has been drawn SPP II scale in the previous cader.\",\"FR 22(B) as per the option given by the individual.\")","v":"                  As the individual is promoted  to next higher post,  her pay in the time scale of higher post shall be fixed in terms of FR 22(B) as per the option given by the individual."}]
["                 ORDER:"]
[{"$f":"\"              Consequent on promotion as \"&Data!D4&\", the pay of the individual  is hereby initially fixed in the Promotion Post Scale \"&Data!G135&\" under FR 22(a)(i) w.e.f.  \"&Data!E5&\" as follows.\"","v":"              Consequent on promotion as  SCHOOL ASST(Phy Ed), the pay of the individual  is hereby initially fixed in the Promotion Post Scale 44570-1260-47090-1350-51140-1460-55520-1580-60260-1700-65360-1830-70850-1960-76730-2090-83000-2240-89720-2390-96890-2540-104510-2700-112610-2890-121280-3100-127480 under FR 22(a)(i) w.e.f.  11-7-2023 as follows."}]
[{"$f":"\"Pay as on \"&Data!E5&\" in the lower cadre :\"","v":"Pay as on 11-7-2023 in the lower cadre :"},null,null,{"$f":"\"Rs.\"&Data!B8&\"/-\"","v":"Rs.34580/-"}]
[null,null,null,{"$f":"Data!B7","v":"32670-101970"}]
[{"$f":"IF(Data!O7<Data!P7,\"Pay fixed at the minimum of the promotion post scale w.e.f. \"&Data!E5&\" under FR 22(B) :\",\"Pay  fixed w.e.f. \"&Data!E5&\" under FR 22(a)(i) in the promotion post scale :\")","v":"Pay fixed at the minimum of the promotion post scale w.e.f. 11-7-2023 under FR 22(B) :"},null,null,{"$f":"\"Rs.\"&IF(Data!O7<Data!P7,Data!P7,Data!O7)&\"/-\"","v":"Rs.44570/-"}]
[null,null,null,{"$f":"Data!D7","v":"44570-127480"}]
[]
[{"$f":"\"             As per the option under \"&IF(Data!B9=\"Yes\",\"FR 22(a)(i)\",\"FR 22(B)\")&\"  the pay of the individual is hereby \"&IF(Data!B6=\"Promotion Date\",\"fixed\",\"refixed\")&\" in the Promotion Post Scale \"&Data!G135&\" from the \"&Data!B6&\" w.e.f. \"&Data!E6&\" \"&\" as follows  \"","v":"             As per the option under FR 22(B)  the pay of the individual is hereby fixed in the Promotion Post Scale 44570-1260-47090-1350-51140-1460-55520-1580-60260-1700-65360-1830-70850-1960-76730-2090-83000-2240-89720-2390-96890-2540-104510-2700-112610-2890-121280-3100-127480 from the Promotion Date w.e.f. 11-7-2023  as follows  "}]
[{"$f":"\"Pay as on  \"&Data!E5 &\" in the lower cadre :\"","v":"Pay as on  11-7-2023 in the lower cadre :"},null,null,{"$f":"D19","v":"Rs.34580/-"}]
[null,null,null,{"$f":"Data!B7","v":"32670-101970"}]
[{"$f":"\"Pay with the Normal Increment @\"&Data!N7&\"/-\"&\" \"&\"in the lower cadre w.e.f .\"&Data!F5&\" :\"","v":"Pay with the Normal Increment @990/- in the lower cadre w.e.f .1-6-2023 :"},null,null,{"$f":"\"Rs.\"&Data!I16&\"/-\"","v":"Rs.44570/-"}]
[null,null,null,{"$f":"D26","v":"32670-101970"}]
[{"$f":"IF(Data!B9=\"Yes\",\"Pay fixed in the promotion post scale under FR 22(a)(i) read with FR 31(2)\",\"Pay with the Notional Increment@\"&IF(Data!B6=\"Increment Date\",Data!N8,Data!N7)&\"/- \"&\"in the lower cadre under FR 22(B) \")&\" \"&\"w.e.f  \"&Data!E6&\"  :\"","v":"Pay with the Notional Increment@990/- in the lower cadre under FR 22(B)  w.e.f  11-7-2023  :"},null,null,{"$f":"\"Rs.\"&Data!I17&\"/-\"","v":"Rs.44570/-"}]
[null,null,null,{"$f":"D28","v":"32670-101970"}]
[{"$f":"\"Pay fixed at the next stage in the promotion post scale w.e.f \"&Data!E6&\" :\"","v":"Pay fixed at the next stage in the promotion post scale w.e.f 11-7-2023 :"},null,null,{"$f":"\"Rs.\"&Data!I18&\"/-\"","v":"Rs.44570/-"}]
[null,null,null,{"$f":"Data!D7","v":"44570-127480"}]
[null,"Date of Next Increment is",{"$f":"IF(Data!B9=\"Yes\",Data!D5,IF(AND(Data!D8>Data!D5,Data!B6=\"Increment Date\"),Data!F11,IF(AND(Data!D8<Data!D5,Data!B6=\"Increment Date\"),Data!D5,Data!G5)))","v":"2024-07-01"}]
["                         The individual is hereby informed that in case of any excess payment made due to erroneous pay fixation pointed out by audit or treasury authority at a later date the same will be refixed and recovered in future bills with out any intimation."]
["Certified that necessary entries have been recorded in the service register of the individual."]
[]
["To"]
["The individual",null,null,{"$f":"Data!B15","v":"HEAD MASTER"}]
[{"$f":"\"Copy to \"&Data!B15&\", \"&Data!B16","v":"Copy to HEAD MASTER,  ZPHIGH SCHOOL  EDLAPADU "},null,null,{"$f":"UPPER(Data!B16)","v":" ZPHIGH SCHOOL  EDLAPADU "}]
["Copy to Bill"]
["Copy to Sub Treasury Officer, ……………………"]

{"sheet":"Bill Preparation","index":2,"n_rows":41,"n_cols":45,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,18],[0,44,1,56],[1,19,1,24],[29,19,29,24]]}
["HRA,CCA should be checked and noted correct HRA,CCA in this form compulsorly.\nThis is the Pay bill Prepared by this software. Once again you check all the columns and Proceed to  \"BILL\" sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ROUND('Bill Preparation'!F3*10%,0)<900,ROUND('Bill Preparation'!F3*10%,0),900)","v":900},null,null,null,null,null,null,null,null,"2011-05-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CCA Rates"]
[null,"FROM",null,"TO","No of Days","Ele Pay","old Pay","DA","HRA","New IR"," New CCA","Old CCA","Total of PPs","F Pay","S Pay","Ele CA/ RA","Old CA/ RA","DA arrear credit to ZPPF","2014-01-01","DA Table",null,null,null,null,null,null,null,null,"From","To","Hyderabad","Vij","Others","Not Applicable","CCA"]
["from",{"$f":"Data!M14","v":"2023-07-11"},"to",{"$f":"DATE(YEAR(B3),MONTH(B3)+1,1)-1","v":"2023-07-31"},{"$f":"(D3-B3)+1","v":21},{"$f":"IF(B3>Data!$D$8,0,IF(B3>=Data!$H$19,Data!$I$19,IF(B3>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":44570},{"$f":"IF(B3>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":34580},22.75,{"$f":"Data!B12","v":10},0,{"$f":"IF(B3>Data!$D$8,0,LOOKUP(F3,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B3>Data!$D$8,0,LOOKUP(G3,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B3>Data!$D$8,0,Data!B10)","v":0},{"$f":"IF(B3>Data!$D$8,0,Data!D10)","v":0},{"$f":"IF(B3>Data!$D$8,0,Data!B11)","v":0},{"$f":"IF(B3>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F3*10%,0)<900,ROUND('Bill Preparation'!F3*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B3>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G3*10%,0)<900,ROUND('Bill Preparation'!G3*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B3,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},{"$f":"S2","v":"2014-01-01"},"Date of effect","DA","ZPPF","diff","Date ","DA to ZPPF %",null,null,null,1,25220,400,250,200,0,{"$f":"IF(Data!$D$12='Bill Preparation'!$AH$2,'Bill Preparation'!AH3,IF(Data!$D$12='Bill Preparation'!$AE$2,'Bill Preparation'!AE3,IF(Data!$D$12='Bill Preparation'!$AG$2,'Bill Preparation'!AG3,'Bill Preparation'!AF3)))","v":0},{"$f":"DAY(B3)","v":11},{"$f":"MONTH(B3)","v":7},{"$f":"YEAR(B3)","v":2023},{"$f":"IF(AK3=2, 28,IF(AK3=4, 30,IF(AK3=6, 30,IF(AK3=9, 30,IF(AK3=11, 30, 31 )))))","v":31},{"$f":"IF(AM3=28,IF(AL3=2016,29,28),AM3)","v":31}]
["from",{"$f":"D3+1","v":"2023-08-01"},"to",{"$f":"DATE(YEAR(B4),MONTH(B4)+1,1)-1","v":"2023-08-31"},{"$f":"(D4-B4)+1","v":31},{"$f":"IF(B4>Data!$D$8,0,IF(B4>=Data!$H$19,Data!$I$19,IF(B4>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":44570},{"$f":"IF(B4>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":34580},22.75,{"$f":"IF(B4>Data!$D$8,0,I3)","v":10},0,{"$f":"IF(B4>Data!$D$8,0,LOOKUP(F4,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B4>Data!$D$8,0,LOOKUP(G4,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B4>Data!$D$8,0,M3)","v":0},{"$f":"IF(B4>Data!$D$8,0,N3)","v":0},{"$f":"IF(B4>Data!$D$8,0,O3)","v":0},{"$f":"IF(B4>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F4*10%,0)<900,ROUND('Bill Preparation'!F4*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B4>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G4*10%,0)<900,ROUND('Bill Preparation'!G4*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B4,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,"2018-07-01",0,null,0,{"$f":"T4","v":"2018-07-01"},0,null,null,null,25221,44570,600,350,300,0,{"$f":"IF(Data!$D$12='Bill Preparation'!$AH$2,'Bill Preparation'!AH4,IF(Data!$D$12='Bill Preparation'!$AE$2,'Bill Preparation'!AE4,IF(Data!$D$12='Bill Preparation'!$AG$2,'Bill Preparation'!AG4,'Bill Preparation'!AF4)))","v":0},{"$f":"DAY(B4)","v":1},{"$f":"MONTH(B4)","v":8},{"$f":"YEAR(B4)","v":2023},31,31,null,null,null,{"$f":"C37","v":"to"}]
["from",{"$f":"D4+1","v":"2023-09-01"},"to",{"$f":"DATE(YEAR(B5),MONTH(B5)+1,1)-1","v":"2023-09-30"},{"$f":"(D5-B5)+1","v":30},{"$f":"IF(B5>Data!$D$8,0,IF(B5>=Data!$H$19,Data!$I$19,IF(B5>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":44570},{"$f":"IF(B5>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":34580},22.75,{"$f":"IF(B5>Data!$D$8,0,I4)","v":10},0,{"$f":"IF(B5>Data!$D$8,0,LOOKUP(F5,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B5>Data!$D$8,0,LOOKUP(G5,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B5>Data!$D$8,0,M4)","v":0},{"$f":"IF(B5>Data!$D$8,0,N4)","v":0},{"$f":"IF(B5>Data!$D$8,0,O4)","v":0},{"$f":"IF(B5>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F5*10%,0)<900,ROUND('Bill Preparation'!F5*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B5>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G5*10%,0)<900,ROUND('Bill Preparation'!G5*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B5,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,"2019-01-01",2.73,null,{"$f":"U5-U4","v":2.73},{"$f":"T5","v":"2019-01-01"},0,null,null,null,44571,57100,700,450,350,0,{"$f":"IF(Data!$D$12='Bill Preparation'!$AH$2,'Bill Preparation'!AH5,IF(Data!$D$12='Bill Preparation'!$AE$2,'Bill Preparation'!AE5,IF(Data!$D$12='Bill Preparation'!$AG$2,'Bill Preparation'!AG5,'Bill Preparation'!AF5)))","v":0},1,9,2023,30,30,null,null,null,{"$f":"C38","v":"to"}]
["from","2023-10-01","to","2023-10-31",{"$f":"(D6-B6)+1","v":31},{"$f":"IF(B6>Data!$D$8,0,IF(B6>=Data!$H$19,Data!$I$19,IF(B6>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B6>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B6>Data!$D$8,0,LOOKUP(B6,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B6>Data!$D$8,0,I5)","v":0},0,{"$f":"IF(B6>Data!$D$8,0,LOOKUP(F6,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B6>Data!$D$8,0,LOOKUP(G6,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B6>Data!$D$8,0,M5)","v":0},{"$f":"IF(B6>Data!$D$8,0,N5)","v":0},{"$f":"IF(B6>Data!$D$8,0,O5)","v":0},{"$f":"IF(B6>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F6*10%,0)<900,ROUND('Bill Preparation'!F6*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B6>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G6*10%,0)<900,ROUND('Bill Preparation'!G6*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B6,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,"2019-07-01",7.28,null,{"$f":"U6-U5","v":4.5500000000000007},"2019-07-01",0,null,null,null,57101,null,1000,700,500,0,{"$f":"IF(Data!$D$12='Bill Preparation'!$AH$2,'Bill Preparation'!AH6,IF(Data!$D$12='Bill Preparation'!$AE$2,'Bill Preparation'!AE6,IF(Data!$D$12='Bill Preparation'!$AG$2,'Bill Preparation'!AG6,'Bill Preparation'!AF6)))","v":0},1,10,2023,31,31,null,null,null,{"$f":"C39","v":"to"}]
["from","2023-11-01","to","2023-11-30",{"$f":"(D7-B7)+1","v":30},{"$f":"IF(B7>Data!$D$8,0,IF(B7>=Data!$H$19,Data!$I$19,IF(B7>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B7>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B7>Data!$D$8,0,LOOKUP(B7,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B7>Data!$D$8,0,I6)","v":0},0,{"$f":"IF(B7>Data!$D$8,0,LOOKUP(F7,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B7>Data!$D$8,0,LOOKUP(G7,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B7>Data!$D$8,0,M6)","v":0},{"$f":"IF(B7>Data!$D$8,0,N6)","v":0},{"$f":"IF(B7>Data!$D$8,0,O6)","v":0},{"$f":"IF(B7>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F7*10%,0)<900,ROUND('Bill Preparation'!F7*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B7>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G7*10%,0)<900,ROUND('Bill Preparation'!G7*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B7,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,"2020-01-01",10.92,"2020-04-01",3.6399999999999997,"2020-01-01",3.6399999999999997,null,null,null,null,null,null,null,null,null,null,1,11,2023,30,30,null,null,null,{"$f":"C40","v":"to"}]
["from","2023-12-01","to","2023-12-31",{"$f":"(D8-B8)+1","v":31},{"$f":"IF(B8>Data!$D$8,0,IF(B8>=Data!$H$19,Data!$I$19,IF(B8>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B8>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B8>Data!$D$8,0,LOOKUP(B8,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B8>Data!$D$8,0,I7)","v":0},0,{"$f":"IF(B8>Data!$D$8,0,LOOKUP(F8,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B8>Data!$D$8,0,LOOKUP(G8,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B8>Data!$D$8,0,M7)","v":0},{"$f":"IF(B8>Data!$D$8,0,N7)","v":0},{"$f":"IF(B8>Data!$D$8,0,O7)","v":0},{"$f":"IF(B8>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F8*10%,0)<900,ROUND('Bill Preparation'!F8*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B8>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G8*10%,0)<900,ROUND('Bill Preparation'!G8*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B8,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,"2020-07-01",13.65,"2020-04-01",2.7300000000000004,"2020-07-01",3.1440000000000001,null,null,null,null,null,"CA","RA","CA/RA",null,null,1,12,2023,31,31]
["from","2024-01-01","to","2024-01-31",31,{"$f":"IF(B9>Data!$D$8,0,IF(B9>=Data!$H$19,Data!$I$19,IF(B9>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B9>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B9>Data!$D$8,0,LOOKUP(B9,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B9>Data!$D$8,0,I8)","v":0},0,{"$f":"IF(B9>Data!$D$8,0,LOOKUP(F9,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B9>Data!$D$8,0,LOOKUP(G9,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B9>Data!$D$8,0,M8)","v":0},{"$f":"IF(B9>Data!$D$8,0,N8)","v":0},{"$f":"IF(B9>Data!$D$8,0,O8)","v":0},{"$f":"IF(B9>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F9*10%,0)<900,ROUND('Bill Preparation'!F9*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B9>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G9*10%,0)<900,ROUND('Bill Preparation'!G9*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B9,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,"2021-01-01",17.29,"2020-04-01",3.6399999999999988,"2021-01-01",3.1440000000000001,null,null,null,null,"Lecturer",0.1,600,{"$f":"IF(Data!$D$11=\"CA\",AE9,IF(Data!$D$11=\"RA\",AF9,0))","v":0},null,null,1,1,2024,31,31,null,null,34]
["from","2024-02-01","to","2024-02-29",29,{"$f":"IF(B10>Data!$D$8,0,IF(B10>=Data!$H$19,Data!$I$19,IF(B10>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B10>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B10>Data!$D$8,0,LOOKUP(B10,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B10>Data!$D$8,0,I9)","v":0},0,{"$f":"IF(B10>Data!$D$8,0,LOOKUP(F10,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B10>Data!$D$8,0,LOOKUP(G10,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B10>Data!$D$8,0,M9)","v":0},{"$f":"IF(B10>Data!$D$8,0,N9)","v":0},{"$f":"IF(B10>Data!$D$8,0,O9)","v":0},{"$f":"IF(B10>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F10*10%,0)<900,ROUND('Bill Preparation'!F10*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B10>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G10*10%,0)<900,ROUND('Bill Preparation'!G10*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B10,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,"2021-07-01",20.02,"2022-01-01",2.7300000000000004,"2021-07-01",0,null,null,null,null,"Others",0.1,0,{"$f":"IF(Data!$D$11=\"CA\",AE10,IF(Data!$D$11=\"RA\",AF10,0))","v":0},null,null,1,2,2024,28,28,null,null,35]
["from","2024-03-01","to","2024-03-31",31,{"$f":"IF(B11>Data!$D$8,0,IF(B11>=Data!$H$19,Data!$I$19,IF(B11>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B11>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B11>Data!$D$8,0,LOOKUP(B11,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B11>Data!$D$8,0,I10)","v":0},0,{"$f":"IF(B11>Data!$D$8,0,LOOKUP(F11,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B11>Data!$D$8,0,LOOKUP(G11,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B11>Data!$D$8,0,M10)","v":0},{"$f":"IF(B11>Data!$D$8,0,N10)","v":0},{"$f":"IF(B11>Data!$D$8,0,O10)","v":0},{"$f":"IF(B11>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F11*10%,0)<900,ROUND('Bill Preparation'!F11*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B11>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G11*10%,0)<900,ROUND('Bill Preparation'!G11*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B11,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,"Teacher",0.1,500,{"$f":"IF(Data!$D$11=\"CA\",AE11,IF(Data!$D$11=\"RA\",AF11,0))","v":0},null,null,1,3,2024,31,31,null,null,36]
["from","2024-04-01","to","2024-04-30",30,{"$f":"IF(B12>Data!$D$8,0,IF(B12>=Data!$H$19,Data!$I$19,IF(B12>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B12>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B12>Data!$D$8,0,LOOKUP(B12,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B12>Data!$D$8,0,I11)","v":0},0,{"$f":"IF(B12>Data!$D$8,0,LOOKUP(F12,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B12>Data!$D$8,0,LOOKUP(G12,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B12>Data!$D$8,0,M11)","v":0},{"$f":"IF(B12>Data!$D$8,0,N11)","v":0},{"$f":"IF(B12>Data!$D$8,0,O11)","v":0},{"$f":"IF(B12>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F12*10%,0)<900,ROUND('Bill Preparation'!F12*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B12>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G12*10%,0)<900,ROUND('Bill Preparation'!G12*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B12,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,4,2024,30,30]
["from","2024-05-01","to","2024-05-31",31,{"$f":"IF(B13>Data!$D$8,0,IF(B13>=Data!$H$19,Data!$I$19,IF(B13>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B13>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B13>Data!$D$8,0,LOOKUP(B13,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B13>Data!$D$8,0,I12)","v":0},0,{"$f":"IF(B13>Data!$D$8,0,LOOKUP(F13,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B13>Data!$D$8,0,LOOKUP(G13,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B13>Data!$D$8,0,M12)","v":0},{"$f":"IF(B13>Data!$D$8,0,N12)","v":0},{"$f":"IF(B13>Data!$D$8,0,O12)","v":0},{"$f":"IF(B13>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F13*10%,0)<900,ROUND('Bill Preparation'!F13*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B13>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G13*10%,0)<900,ROUND('Bill Preparation'!G13*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B13,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,5,2024,31,31]
["from","2024-06-01","to","2024-06-30",30,{"$f":"IF(B14>Data!$D$8,0,IF(B14>=Data!$H$19,Data!$I$19,IF(B14>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B14>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B14>Data!$D$8,0,LOOKUP(B14,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B14>Data!$D$8,0,I13)","v":0},0,{"$f":"IF(B14>Data!$D$8,0,LOOKUP(F14,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B14>Data!$D$8,0,LOOKUP(G14,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B14>Data!$D$8,0,M13)","v":0},{"$f":"IF(B14>Data!$D$8,0,N13)","v":0},{"$f":"IF(B14>Data!$D$8,0,O13)","v":0},{"$f":"IF(B14>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F14*10%,0)<900,ROUND('Bill Preparation'!F14*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B14>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G14*10%,0)<900,ROUND('Bill Preparation'!G14*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B14,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,6,2024,30,30]
["from","2024-07-01","to","2024-07-31",31,{"$f":"IF(B15>Data!$D$8,0,IF(B15>=Data!$H$19,Data!$I$19,IF(B15>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B15>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B15>Data!$D$8,0,LOOKUP(B15,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B15>Data!$D$8,0,I14)","v":0},0,{"$f":"IF(B15>Data!$D$8,0,LOOKUP(F15,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B15>Data!$D$8,0,LOOKUP(G15,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B15>Data!$D$8,0,M14)","v":0},{"$f":"IF(B15>Data!$D$8,0,N14)","v":0},{"$f":"IF(B15>Data!$D$8,0,O14)","v":0},{"$f":"IF(B15>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F15*10%,0)<900,ROUND('Bill Preparation'!F15*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B15>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G15*10%,0)<900,ROUND('Bill Preparation'!G15*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B15,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,7,2024,31,31]
["from","2024-08-01","to","2024-08-31",31,{"$f":"IF(B16>Data!$D$8,0,IF(B16>=Data!$H$19,Data!$I$19,IF(B16>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B16>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B16>Data!$D$8,0,LOOKUP(B16,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B16>Data!$D$8,0,I15)","v":0},0,{"$f":"IF(B16>Data!$D$8,0,LOOKUP(F16,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B16>Data!$D$8,0,LOOKUP(G16,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B16>Data!$D$8,0,M15)","v":0},{"$f":"IF(B16>Data!$D$8,0,N15)","v":0},{"$f":"IF(B16>Data!$D$8,0,O15)","v":0},{"$f":"IF(B16>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F16*10%,0)<900,ROUND('Bill Preparation'!F16*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B16>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G16*10%,0)<900,ROUND('Bill Preparation'!G16*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B16,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,8,2024,31,31]
["from","2024-09-01","to","2024-09-30",30,{"$f":"IF(B17>Data!$D$8,0,IF(B17>=Data!$H$19,Data!$I$19,IF(B17>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B17>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B17>Data!$D$8,0,LOOKUP(B17,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B17>Data!$D$8,0,I16)","v":0},0,{"$f":"IF(B17>Data!$D$8,0,LOOKUP(F17,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B17>Data!$D$8,0,LOOKUP(G17,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B17>Data!$D$8,0,M16)","v":0},{"$f":"IF(B17>Data!$D$8,0,N16)","v":0},{"$f":"IF(B17>Data!$D$8,0,O16)","v":0},{"$f":"IF(B17>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F17*10%,0)<900,ROUND('Bill Preparation'!F17*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B17>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G17*10%,0)<900,ROUND('Bill Preparation'!G17*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B17,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,9,2024,30,30]
["from","2024-10-01","to","2024-10-31",31,{"$f":"IF(B18>Data!$D$8,0,IF(B18>=Data!$H$19,Data!$I$19,IF(B18>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B18>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B18>Data!$D$8,0,LOOKUP(B18,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B18>Data!$D$8,0,I17)","v":0},0,{"$f":"IF(B18>Data!$D$8,0,LOOKUP(F18,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B18>Data!$D$8,0,LOOKUP(G18,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B18>Data!$D$8,0,M17)","v":0},{"$f":"IF(B18>Data!$D$8,0,N17)","v":0},{"$f":"IF(B18>Data!$D$8,0,O17)","v":0},{"$f":"IF(B18>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F18*10%,0)<900,ROUND('Bill Preparation'!F18*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B18>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G18*10%,0)<900,ROUND('Bill Preparation'!G18*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B18,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,10,2024,31,31]
["from","2024-11-01","to","2024-11-30",30,{"$f":"IF(B19>Data!$D$8,0,IF(B19>=Data!$H$19,Data!$I$19,IF(B19>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B19>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B19>Data!$D$8,0,LOOKUP(B19,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B19>Data!$D$8,0,I18)","v":0},0,{"$f":"IF(B19>Data!$D$8,0,LOOKUP(F19,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B19>Data!$D$8,0,LOOKUP(G19,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B19>Data!$D$8,0,M18)","v":0},{"$f":"IF(B19>Data!$D$8,0,N18)","v":0},{"$f":"IF(B19>Data!$D$8,0,O18)","v":0},{"$f":"IF(B19>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F19*10%,0)<900,ROUND('Bill Preparation'!F19*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B19>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G19*10%,0)<900,ROUND('Bill Preparation'!G19*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B19,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,11,2024,30,30]
["from","2024-12-01","to","2024-12-31",31,{"$f":"IF(B20>Data!$D$8,0,IF(B20>=Data!$H$19,Data!$I$19,IF(B20>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B20>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B20>Data!$D$8,0,LOOKUP(B20,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B20>Data!$D$8,0,I19)","v":0},0,{"$f":"IF(B20>Data!$D$8,0,LOOKUP(F20,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B20>Data!$D$8,0,LOOKUP(G20,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B20>Data!$D$8,0,M19)","v":0},{"$f":"IF(B20>Data!$D$8,0,N19)","v":0},{"$f":"IF(B20>Data!$D$8,0,O19)","v":0},{"$f":"IF(B20>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F20*10%,0)<900,ROUND('Bill Preparation'!F20*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B20>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G20*10%,0)<900,ROUND('Bill Preparation'!G20*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B20,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,12,2024,31,31]
["from","2025-01-01","to","2025-01-31",31,{"$f":"IF(B21>Data!$D$8,0,IF(B21>=Data!$H$19,Data!$I$19,IF(B21>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B21>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B21>Data!$D$8,0,LOOKUP(B21,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B21>Data!$D$8,0,I20)","v":0},0,{"$f":"IF(B21>Data!$D$8,0,LOOKUP(F21,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B21>Data!$D$8,0,LOOKUP(G21,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B21>Data!$D$8,0,M20)","v":0},{"$f":"IF(B21>Data!$D$8,0,N20)","v":0},{"$f":"IF(B21>Data!$D$8,0,O20)","v":0},{"$f":"IF(B21>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F21*10%,0)<900,ROUND('Bill Preparation'!F21*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B21>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G21*10%,0)<900,ROUND('Bill Preparation'!G21*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B21,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,2025,31,31]
["from","2025-02-01","to","2025-02-28",28,{"$f":"IF(B22>Data!$D$8,0,IF(B22>=Data!$H$19,Data!$I$19,IF(B22>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B22>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B22>Data!$D$8,0,LOOKUP(B22,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B22>Data!$D$8,0,I21)","v":0},0,{"$f":"IF(B22>Data!$D$8,0,LOOKUP(F22,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B22>Data!$D$8,0,LOOKUP(G22,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B22>Data!$D$8,0,M21)","v":0},{"$f":"IF(B22>Data!$D$8,0,N21)","v":0},{"$f":"IF(B22>Data!$D$8,0,O21)","v":0},{"$f":"IF(B22>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F22*10%,0)<900,ROUND('Bill Preparation'!F22*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B22>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G22*10%,0)<900,ROUND('Bill Preparation'!G22*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B22,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,2025,28,28]
["from","2025-03-01","to","2025-03-31",31,{"$f":"IF(B23>Data!$D$8,0,IF(B23>=Data!$H$19,Data!$I$19,IF(B23>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B23>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B23>Data!$D$8,0,LOOKUP(B23,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B23>Data!$D$8,0,I22)","v":0},0,{"$f":"IF(B23>Data!$D$8,0,LOOKUP(F23,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B23>Data!$D$8,0,LOOKUP(G23,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B23>Data!$D$8,0,M22)","v":0},{"$f":"IF(B23>Data!$D$8,0,N22)","v":0},{"$f":"IF(B23>Data!$D$8,0,O22)","v":0},{"$f":"IF(B23>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F23*10%,0)<900,ROUND('Bill Preparation'!F23*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B23>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G23*10%,0)<900,ROUND('Bill Preparation'!G23*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B23,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,3,2025,31,31]
["from","2025-04-01","to","2025-04-30",30,{"$f":"IF(B24>Data!$D$8,0,IF(B24>=Data!$H$19,Data!$I$19,IF(B24>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B24>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B24>Data!$D$8,0,LOOKUP(B24,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B24>Data!$D$8,0,I23)","v":0},0,{"$f":"IF(B24>Data!$D$8,0,LOOKUP(F24,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B24>Data!$D$8,0,LOOKUP(G24,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B24>Data!$D$8,0,M23)","v":0},{"$f":"IF(B24>Data!$D$8,0,N23)","v":0},{"$f":"IF(B24>Data!$D$8,0,O23)","v":0},{"$f":"IF(B24>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F24*10%,0)<900,ROUND('Bill Preparation'!F24*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B24>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G24*10%,0)<900,ROUND('Bill Preparation'!G24*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B24,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,4,2025,30,30]
["from","2025-05-01","to","2025-05-31",31,{"$f":"IF(B25>Data!$D$8,0,IF(B25>=Data!$H$19,Data!$I$19,IF(B25>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B25>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B25>Data!$D$8,0,LOOKUP(B25,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B25>Data!$D$8,0,I24)","v":0},0,{"$f":"IF(B25>Data!$D$8,0,LOOKUP(F25,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B25>Data!$D$8,0,LOOKUP(G25,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B25>Data!$D$8,0,M24)","v":0},{"$f":"IF(B25>Data!$D$8,0,N24)","v":0},{"$f":"IF(B25>Data!$D$8,0,O24)","v":0},{"$f":"IF(B25>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F25*10%,0)<900,ROUND('Bill Preparation'!F25*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B25>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G25*10%,0)<900,ROUND('Bill Preparation'!G25*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B25,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,5,2025,31,{"$f":"IF(AM25=28,IF(AL25=2016,29,28),AM25)","v":31}]
["from","2025-06-01","to","2025-06-30",30,{"$f":"IF(B26>Data!$D$8,0,IF(B26>=Data!$H$19,Data!$I$19,IF(B26>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B26>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B26>Data!$D$8,0,LOOKUP(B26,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B26>Data!$D$8,0,I25)","v":0},0,{"$f":"IF(B26>Data!$D$8,0,LOOKUP(F26,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B26>Data!$D$8,0,LOOKUP(G26,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B26>Data!$D$8,0,M25)","v":0},{"$f":"IF(B26>Data!$D$8,0,N25)","v":0},{"$f":"IF(B26>Data!$D$8,0,O25)","v":0},{"$f":"IF(B26>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F26*10%,0)<900,ROUND('Bill Preparation'!F26*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B26>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G26*10%,0)<900,ROUND('Bill Preparation'!G26*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B26,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,6,2025,30,{"$f":"IF(AM26=28,IF(AL26=2016,29,28),AM26)","v":30}]
["from","2025-07-01","to","2025-07-31",31,{"$f":"IF(B27>Data!$D$8,0,IF(B27>=Data!$H$19,Data!$I$19,IF(B27>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B27>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B27>Data!$D$8,0,LOOKUP(B27,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B27>Data!$D$8,0,I26)","v":0},0,{"$f":"IF(B27>Data!$D$8,0,LOOKUP(F27,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B27>Data!$D$8,0,LOOKUP(G27,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B27>Data!$D$8,0,M26)","v":0},{"$f":"IF(B27>Data!$D$8,0,N26)","v":0},{"$f":"IF(B27>Data!$D$8,0,O26)","v":0},{"$f":"IF(B27>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F27*10%,0)<900,ROUND('Bill Preparation'!F27*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B27>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G27*10%,0)<900,ROUND('Bill Preparation'!G27*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B27,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,7,2025,31,31]
["from","2025-08-01","to","2025-08-31",31,{"$f":"IF(B28>Data!$D$8,0,IF(B28>=Data!$H$19,Data!$I$19,IF(B28>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B28>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B28>Data!$D$8,0,LOOKUP(B28,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B28>Data!$D$8,0,I27)","v":0},0,{"$f":"IF(B28>Data!$D$8,0,LOOKUP(F28,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B28>Data!$D$8,0,LOOKUP(G28,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B28>Data!$D$8,0,M27)","v":0},{"$f":"IF(B28>Data!$D$8,0,N27)","v":0},{"$f":"IF(B28>Data!$D$8,0,O27)","v":0},{"$f":"IF(B28>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F28*10%,0)<900,ROUND('Bill Preparation'!F28*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B28>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G28*10%,0)<900,ROUND('Bill Preparation'!G28*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B28,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,8,2025,31,31]
["from","2025-09-01","to","2025-09-30",30,{"$f":"IF(B29>Data!$D$8,0,IF(B29>=Data!$H$19,Data!$I$19,IF(B29>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B29>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B29>Data!$D$8,0,LOOKUP(B29,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B29>Data!$D$8,0,I28)","v":0},0,{"$f":"IF(B29>Data!$D$8,0,LOOKUP(F29,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B29>Data!$D$8,0,LOOKUP(G29,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B29>Data!$D$8,0,M28)","v":0},{"$f":"IF(B29>Data!$D$8,0,N28)","v":0},{"$f":"IF(B29>Data!$D$8,0,O28)","v":0},{"$f":"IF(B29>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F29*10%,0)<900,ROUND('Bill Preparation'!F29*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B29>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G29*10%,0)<900,ROUND('Bill Preparation'!G29*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B29,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,9,2025,30,30]
["from","2025-10-01","to","2025-10-31",31,{"$f":"IF(B30>Data!$D$8,0,IF(B30>=Data!$H$19,Data!$I$19,IF(B30>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B30>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B30>Data!$D$8,0,LOOKUP(B30,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B30>Data!$D$8,0,I29)","v":0},0,{"$f":"IF(B30>Data!$D$8,0,LOOKUP(F30,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B30>Data!$D$8,0,LOOKUP(G30,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B30>Data!$D$8,0,M29)","v":0},{"$f":"IF(B30>Data!$D$8,0,N29)","v":0},{"$f":"IF(B30>Data!$D$8,0,O29)","v":0},{"$f":"IF(B30>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F30*10%,0)<900,ROUND('Bill Preparation'!F30*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B30>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G30*10%,0)<900,ROUND('Bill Preparation'!G30*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B30,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,"Dates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,10,2025,31,31]
["from","2025-11-01","to","2025-11-30",30,{"$f":"IF(B31>Data!$D$8,0,IF(B31>=Data!$H$19,Data!$I$19,IF(B31>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B31>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B31>Data!$D$8,0,LOOKUP(B31,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B31>Data!$D$8,0,I30)","v":0},0,{"$f":"IF(B31>Data!$D$8,0,LOOKUP(F31,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B31>Data!$D$8,0,LOOKUP(G31,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B31>Data!$D$8,0,M30)","v":0},{"$f":"IF(B31>Data!$D$8,0,N30)","v":0},{"$f":"IF(B31>Data!$D$8,0,O30)","v":0},{"$f":"IF(B31>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F31*10%,0)<900,ROUND('Bill Preparation'!F31*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B31>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G31*10%,0)<900,ROUND('Bill Preparation'!G31*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B31,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,"Original","Text",null,null,null,null,null,null,null,null,null,null,null,null,null,1,11,2025,30,30]
["from","2025-12-01","to","2025-12-31",31,{"$f":"IF(B32>Data!$D$8,0,IF(B32>=Data!$H$19,Data!$I$19,IF(B32>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B32>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B32>Data!$D$8,0,LOOKUP(B32,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B32>Data!$D$8,0,I31)","v":0},0,{"$f":"IF(B32>Data!$D$8,0,LOOKUP(F32,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B32>Data!$D$8,0,LOOKUP(G32,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B32>Data!$D$8,0,M31)","v":0},{"$f":"IF(B32>Data!$D$8,0,N31)","v":0},{"$f":"IF(B32>Data!$D$8,0,O31)","v":0},{"$f":"IF(B32>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F32*10%,0)<900,ROUND('Bill Preparation'!F32*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B32>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G32*10%,0)<900,ROUND('Bill Preparation'!G32*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B32,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,"Pay","HRA","HMA","CA/RA",null,null,null,null,null,null,null,null,{"$f":"DAY(B32)","v":1},{"$f":"MONTH(B32)","v":12},{"$f":"YEAR(B32)","v":2025},{"$f":"IF(AK32=2, 28,IF(AK32=4, 30,IF(AK32=6, 30,IF(AK32=9, 30,IF(AK32=11, 30, 31 )))))","v":31},31,{"$f":"IF(AM32=28,IF(AL32=2012,29,28),AM32)","v":31}]
["from","2026-01-01","to","2026-01-31",31,{"$f":"IF(B33>Data!$D$8,0,IF(B33>=Data!$H$19,Data!$I$19,IF(B33>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B33>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B33>Data!$D$8,0,LOOKUP(B33,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B33>Data!$D$8,0,I32)","v":0},0,{"$f":"IF(B33>Data!$D$8,0,LOOKUP(F33,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B33>Data!$D$8,0,LOOKUP(G33,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B33>Data!$D$8,0,M32)","v":0},{"$f":"IF(B33>Data!$D$8,0,N32)","v":0},{"$f":"IF(B33>Data!$D$8,0,O32)","v":0},{"$f":"IF(B33>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F33*10%,0)<900,ROUND('Bill Preparation'!F33*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B33>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G33*10%,0)<900,ROUND('Bill Preparation'!G33*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B33,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,"Promotion Date",{"$f":"Data!B5","v":"2023-07-11"},{"$f":"U33","v":"2023-07-11"},{"$f":"SMALL(U33:U35,1)","v":"2023-06-01"},{"$f":"IF(W33<Data!M14,0,Data!I15)","v":0},null,null,null,null,null,null,null,null,null,null,null,1,1,2026,{"$f":"IF(AK33=2, 28,IF(AK33=4, 30,IF(AK33=6, 30,IF(AK33=9, 30,IF(AK33=11, 30, 31 )))))","v":31},31,{"$f":"IF(AM33=28,IF(AL33=2012,29,28),AM33)","v":31}]
["from","2026-02-01","to","2026-02-28",28,{"$f":"IF(B34>Data!$D$8,0,IF(B34>=Data!$H$19,Data!$I$19,IF(B34>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B34>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B34>Data!$D$8,0,LOOKUP(B34,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B34>Data!$D$8,0,I33)","v":0},0,{"$f":"IF(B34>Data!$D$8,0,LOOKUP(F34,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B34>Data!$D$8,0,LOOKUP(G34,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B34>Data!$D$8,0,M33)","v":0},{"$f":"IF(B34>Data!$D$8,0,N33)","v":0},{"$f":"IF(B34>Data!$D$8,0,O33)","v":0},{"$f":"IF(B34>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F34*10%,0)<900,ROUND('Bill Preparation'!F34*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B34>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G34*10%,0)<900,ROUND('Bill Preparation'!G34*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B34,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,"Increment Date",{"$f":"Data!D5","v":"2023-06-01"},{"$f":"IF(U34=V33,Data!E8,U34)","v":"2023-06-01"},{"$f":"SMALL(U33:U35,2)","v":"2023-07-11"},null,null,null,null,null,null,null,null,null,null,null,null,1,2,2026,{"$f":"IF(AK34=2, 28,IF(AK34=4, 30,IF(AK34=6, 30,IF(AK34=9, 30,IF(AK34=11, 30, 31 )))))","v":28},28,{"$f":"IF(AM34=28,IF(AL34=2012,29,28),AM34)","v":28}]
["from","2026-03-01","to","2026-03-31",31,{"$f":"IF(B35>Data!$D$8,0,IF(B35>=Data!$H$19,Data!$I$19,IF(B35>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B35>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B35>Data!$D$8,0,LOOKUP(B35,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B35>Data!$D$8,0,I34)","v":0},0,{"$f":"IF(B35>Data!$D$8,0,LOOKUP(F35,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B35>Data!$D$8,0,LOOKUP(G35,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B35>Data!$D$8,0,M34)","v":0},{"$f":"IF(B35>Data!$D$8,0,N34)","v":0},{"$f":"IF(B35>Data!$D$8,0,O34)","v":0},{"$f":"IF(B35>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F35*10%,0)<900,ROUND('Bill Preparation'!F35*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B35>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G35*10%,0)<900,ROUND('Bill Preparation'!G35*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B35,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,"Bill claimed upto",{"$f":"TODAY()-DAY(TODAY())","v":"2023-08-31"},{"$f":"IF(U35=V34,Data!E8,U35)","v":"2023-08-31"},{"$f":"SMALL(U33:U35,3)","v":"2023-08-31"},null,null,null,null,null,null,null,null,null,null,null,null,1,3,2026,{"$f":"IF(AK35=2, 28,IF(AK35=4, 30,IF(AK35=6, 30,IF(AK35=9, 30,IF(AK35=11, 30, 31 )))))","v":31},31,{"$f":"IF(AM35=28,IF(AL35=2012,29,28),AM35)","v":31}]
["from","2026-04-01","to","2026-04-30",30,{"$f":"IF(B36>Data!$D$8,0,IF(B36>=Data!$H$19,Data!$I$19,IF(B36>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B36>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B36>Data!$D$8,0,LOOKUP(B36,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B36>Data!$D$8,0,I35)","v":0},0,{"$f":"IF(B36>Data!$D$8,0,LOOKUP(F36,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B36>Data!$D$8,0,LOOKUP(G36,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B36>Data!$D$8,0,M35)","v":0},{"$f":"IF(B36>Data!$D$8,0,N35)","v":0},{"$f":"IF(B36>Data!$D$8,0,O35)","v":0},{"$f":"IF(B36>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F36*10%,0)<900,ROUND('Bill Preparation'!F36*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B36>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G36*10%,0)<900,ROUND('Bill Preparation'!G36*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B36,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,4,2026,{"$f":"IF(AK36=2, 28,IF(AK36=4, 30,IF(AK36=6, 30,IF(AK36=9, 30,IF(AK36=11, 30, 31 )))))","v":30},30,{"$f":"IF(AM36=28,IF(AL36=2012,29,28),AM36)","v":30}]
["from","2026-05-01","to","2026-05-31",31,{"$f":"IF(B37>Data!$D$8,0,IF(B37>=Data!$H$19,Data!$I$19,IF(B37>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B37>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B37>Data!$D$8,0,LOOKUP(B37,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B37>Data!$D$8,0,I36)","v":0},0,{"$f":"IF(B37>Data!$D$8,0,LOOKUP(F37,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B37>Data!$D$8,0,LOOKUP(G37,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B37>Data!$D$8,0,M36)","v":0},{"$f":"IF(B37>Data!$D$8,0,N36)","v":0},{"$f":"IF(B37>Data!$D$8,0,O36)","v":0},{"$f":"IF(B37>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F37*10%,0)<900,ROUND('Bill Preparation'!F37*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B37>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G37*10%,0)<900,ROUND('Bill Preparation'!G37*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B37,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,5,2026,31,31]
["from","2026-06-01","to","2026-06-30",{"$f":"(D38-B38)+1","v":30},{"$f":"IF(B38>Data!$D$8,0,IF(B38>=Data!$H$19,Data!$I$19,IF(B38>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B38>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B38>Data!$D$8,0,LOOKUP(B38,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B38>Data!$D$8,0,I37)","v":0},0,{"$f":"IF(B38>Data!$D$8,0,LOOKUP(F38,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B38>Data!$D$8,0,LOOKUP(G38,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B38>Data!$D$8,0,M37)","v":0},{"$f":"IF(B38>Data!$D$8,0,N37)","v":0},{"$f":"IF(B38>Data!$D$8,0,O37)","v":0},{"$f":"IF(B38>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F38*10%,0)<900,ROUND('Bill Preparation'!F38*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B38>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G38*10%,0)<900,ROUND('Bill Preparation'!G38*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B38,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,6,2026,{"$f":"IF(AK38=2,\"28\",IF(AK38=4,\"30\",IF(AK38=6,\"30\",IF(AK38=9,\"30\",IF(AK38=11,\"30\",\"31\")))))","v":"30"},"30"]
["from","2026-07-01","to","2026-07-31",{"$f":"(D39-B39)+1","v":31},{"$f":"IF(B39>Data!$D$8,0,IF(B39>=Data!$H$19,Data!$I$19,IF(B39>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B39>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B39>Data!$D$8,0,LOOKUP(B39,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B39>Data!$D$8,0,I38)","v":0},0,{"$f":"IF(B39>Data!$D$8,0,LOOKUP(F39,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B39>Data!$D$8,0,LOOKUP(G39,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B39>Data!$D$8,0,M38)","v":0},{"$f":"IF(B39>Data!$D$8,0,N38)","v":0},{"$f":"IF(B39>Data!$D$8,0,O38)","v":0},{"$f":"IF(B39>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F39*10%,0)<900,ROUND('Bill Preparation'!F39*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B39>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G39*10%,0)<900,ROUND('Bill Preparation'!G39*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B39,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,7,2026,{"$f":"IF(AK39=2,\"28\",IF(AK39=4,\"30\",IF(AK39=6,\"30\",IF(AK39=9,\"30\",IF(AK39=11,\"30\",\"31\")))))","v":"31"},{"$f":"IF(AM39=28,IF(AL39=2016,29,28),AM39)","v":"31"}]
["from","2026-08-01","to","2026-08-31",{"$f":"(D40-B40)+1","v":31},{"$f":"IF(B40>Data!$D$8,0,IF(B40>=Data!$H$19,Data!$I$19,IF(B40>=Data!$H$18,Data!$I$18,Data!$I$15)))","v":0},{"$f":"IF(B40>Data!$D$8,0,IF(Data!$D$6=\"Yes\",Data!$O$7,Data!$B$8))","v":0},{"$f":"IF(B40>Data!$D$8,0,LOOKUP(B40,$T$4:$T$16,$U$4:$U$16))","v":0},{"$f":"IF(B40>Data!$D$8,0,I39)","v":0},0,{"$f":"IF(B40>Data!$D$8,0,LOOKUP(F40,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B40>Data!$D$8,0,LOOKUP(G40,$AC$3:$AC$6,$AI$3:$AI$6))","v":0},{"$f":"IF(B40>Data!$D$8,0,M39)","v":0},{"$f":"IF(B40>Data!$D$8,0,N39)","v":0},{"$f":"IF(B40>Data!$D$8,0,O39)","v":0},{"$f":"IF(B40>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!F40*10%,0)<900,ROUND('Bill Preparation'!F40*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(B40>Data!$D$8,0,IF(Data!$D$11=\"CA\",IF(ROUND('Bill Preparation'!G40*10%,0)<900,ROUND('Bill Preparation'!G40*10%,0),900),LOOKUP(Data!$B$4,'Bill Preparation'!$AD$9:$AD$11,'Bill Preparation'!$AG$9:$AG$11)))","v":0},{"$f":"IF(Data!$D$3=\"CPS\",0,LOOKUP('Bill Preparation'!B40,'Bill Preparation'!$X$4:$X$22,'Bill Preparation'!$Y$4:$Y$22))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U33","v":"2023-07-11"}]

{"sheet":"Bill","index":3,"n_rows":42,"n_cols":47,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,0,41,24],[0,0,0,40],[1,0,1,40],[2,0,2,40],[3,0,3,39],[4,0,4,1],[4,3,4,13],[4,14,4,24],[4,25,4,39],[4,40,5,40],[4,2,5,2]]}
["Note : In this \"Bill Sheet\" if any variation found , Change the corresponding entries in the \"Bill Preparation\" Sheet.\n          Hide unnecessary rows and columns in this sheet and then print out this sheet."]
[{"$f":"\"Claim for Promotion Pay fixation arrears of  \"&Data!B2&\", \"&Data!D4","v":"Claim for Promotion Pay fixation arrears of  Smt Shaik ASHITUN (CFMS ID15087189),  SCHOOL ASST(Phy Ed)"}]
[]
[{"$f":"\"Vide the Proceedings RC No : \"&Data!B17& \" dt.\"&Data!F17&\" of the \"&PROPER(Data!B15)&\", \"&Data!B16","v":"Vide the Proceedings RC No : 5/ PROMOTION FR 22B /2023 dt.19-9-2023 of the Head Master,  ZPHIGH SCHOOL  EDLAPADU "}]
["Period",null,"No of Days","To be drawn",null,null,null,null,null,null,null,null,null,null,"Already drawn ",null,null,null,null,null,null,null,null,null,null,"Difference",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REMARKS"]
["From","To",null,"PAY","pp","FP","S Pay","D A","H R A ","IR","PHA","CCA","GROSS","PT","PAY","pp","FP","S Pay","D A","H R A ","IR","PHA","CCA","GROSS","PT","PAY","pp","FP","S Pay","D A","H R A ","IR","PHA","CCA","GROSS","ZPPF","PT","CPS"," GOVT. RECOVERIES","Net Payable"]
[{"$f":"'Bill Preparation'!B3","v":"2023-07-11"},{"$f":"'Bill Preparation'!D3","v":"2023-07-31"},{"$f":"(B7-A7)+1","v":21},{"$f":"ROUND('Bill Preparation'!F3*C7/'Bill Preparation'!AN3,0)","v":30193},{"$f":"ROUND('Bill Preparation'!M3*C7/'Bill Preparation'!AN3,0)","v":0},{"$f":"ROUND('Bill Preparation'!N3*C7/'Bill Preparation'!AN3,0)","v":0},{"$f":"ROUND('Bill Preparation'!O3*C7/'Bill Preparation'!AN3,0)","v":0},{"$f":"ROUND(D7*'Bill Preparation'!H3/100,0)","v":6869},{"$f":"IF(ROUND(D7*'Bill Preparation'!I3/100,0)>('Bill Preparation'!I3+1)*1000,('Bill Preparation'!I3+1)*1000,ROUND(D7*'Bill Preparation'!I3/100,0))","v":3019},{"$f":"ROUND(D7*'Bill Preparation'!J3/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P3*C7/'Bill Preparation'!AN3,0)","v":0},{"$f":"ROUND('Bill Preparation'!K3*C7/'Bill Preparation'!AN3,0)","v":0},{"$f":"SUM(D7:L7)","v":40081},{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C7>AQ7/2,AS7,0))","v":200},{"$f":"ROUND('Bill Preparation'!G3*C7/'Bill Preparation'!AN3,0)","v":23425},{"$f":"ROUND('Bill Preparation'!M3*C7/'Bill Preparation'!AN3,0)","v":0},{"$f":"ROUND('Bill Preparation'!N3*C7/'Bill Preparation'!AN3,0)","v":0},{"$f":"ROUND('Bill Preparation'!O3*C7/'Bill Preparation'!AN3,0)","v":0},{"$f":"ROUND(O7*'Bill Preparation'!H3/100,0)","v":5329},{"$f":"IF(ROUND(O7*'Bill Preparation'!I3/100,0)>('Bill Preparation'!I3+1)*1000,('Bill Preparation'!I3+1)*1000,ROUND(O7*'Bill Preparation'!I3/100,0))","v":2343},{"$f":"ROUND(O7*'Bill Preparation'!J3/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q3*C7/'Bill Preparation'!AN3,0)","v":0},{"$f":"ROUND('Bill Preparation'!L3*C7/'Bill Preparation'!AN3,0)","v":0},{"$f":"SUM(O7:W7)","v":31097},{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C7>AQ7/2,AU7,0))","v":200},{"$f":"D7-O7","v":6768},0,0,0,1540,676,0,0,0,{"$f":"SUM(Z7:AH7)","v":8984},{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z7*'Bill Preparation'!R3%,0))","v":0},{"$f":"N7-Y7","v":0},{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z7+AD7)*10%,0),0)","v":831},{"$f":"SUM(AJ7:AL7)","v":831},{"$f":"AI7-AM7","v":8153},null,{"$f":"MONTH(A7)*1","v":7},{"$f":"IF(AP7=2,IF(YEAR(A7)=2012,\"29\",\"28\"),IF(AP7=4,\"30\",IF(AP7=6,\"30\",IF(AP7=9,\"30\",IF(AP7=11,\"30\",\"31\")))))","v":"31"},{"$f":"'Bill Preparation'!F3+'Bill Preparation'!M3+ROUND('Bill Preparation'!F3*'Bill Preparation'!H3/100,0)+ROUND('Bill Preparation'!F3*'Bill Preparation'!I3/100,0)+'Bill Preparation'!K3+'Bill Preparation'!N3+'Bill Preparation'!O3","v":59167},{"$f":"IF(AR7>20000,200,IF(AR7>15000,150,IF(AR7>10000,100,IF(AR7>5000,80,0))))","v":200},{"$f":"'Bill Preparation'!G3+'Bill Preparation'!M3+ROUND('Bill Preparation'!G3*'Bill Preparation'!H3/100,0)+ROUND('Bill Preparation'!G3*'Bill Preparation'!I3/100,0)+'Bill Preparation'!L3+'Bill Preparation'!N3+'Bill Preparation'!O3","v":45905},{"$f":"IF(AT7>20000,200,IF(AT7>15000,150,IF(AT7>10000,100,IF(AT7>5000,80,0))))","v":200}]
[{"$f":"'Bill Preparation'!B4","v":"2023-08-01"},{"$f":"'Bill Preparation'!D4","v":"2023-08-31"},31,{"$f":"ROUND('Bill Preparation'!F4*C8/'Bill Preparation'!AN4,0)","v":44570},{"$f":"ROUND('Bill Preparation'!M4*C8/'Bill Preparation'!AN4,0)","v":0},{"$f":"ROUND('Bill Preparation'!N4*C8/'Bill Preparation'!AN4,0)","v":0},{"$f":"ROUND('Bill Preparation'!O4*C8/'Bill Preparation'!AN4,0)","v":0},{"$f":"ROUND(D8*'Bill Preparation'!H4/100,0)","v":10140},{"$f":"IF(ROUND(D8*'Bill Preparation'!I4/100,0)>('Bill Preparation'!I4+1)*1000,('Bill Preparation'!I4+1)*1000,ROUND(D8*'Bill Preparation'!I4/100,0))","v":4457},{"$f":"ROUND(D8*'Bill Preparation'!J4/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P4*C8/'Bill Preparation'!AN4,0)","v":0},{"$f":"ROUND('Bill Preparation'!K4*C8/'Bill Preparation'!AN4,0)","v":0},59167,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C8>AQ8/2,AS8,0))","v":200},{"$f":"ROUND('Bill Preparation'!G4*C8/'Bill Preparation'!AN4,0)","v":34580},{"$f":"ROUND('Bill Preparation'!M4*C8/'Bill Preparation'!AN4,0)","v":0},{"$f":"ROUND('Bill Preparation'!N4*C8/'Bill Preparation'!AN4,0)","v":0},{"$f":"ROUND('Bill Preparation'!O4*C8/'Bill Preparation'!AN4,0)","v":0},{"$f":"ROUND(O8*'Bill Preparation'!H4/100,0)","v":7867},{"$f":"IF(ROUND(O8*'Bill Preparation'!I4/100,0)>('Bill Preparation'!I4+1)*1000,('Bill Preparation'!I4+1)*1000,ROUND(O8*'Bill Preparation'!I4/100,0))","v":3458},{"$f":"ROUND(O8*'Bill Preparation'!J4/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q4*C8/'Bill Preparation'!AN4,0)","v":0},{"$f":"ROUND('Bill Preparation'!L4*C8/'Bill Preparation'!AN4,0)","v":0},45905,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C8>AQ8/2,AU8,0))","v":200},9990,0,0,0,2273,999,0,0,0,13262,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z8*'Bill Preparation'!R4%,0))","v":0},{"$f":"IF(C8>AQ8/2,(N8-Y8),0)","v":0},{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z8+AD8)*10%,0),0)","v":1226},{"$f":"SUM(AJ8:AL8)","v":1226},12036,null,8,"31",{"$f":"'Bill Preparation'!F4+'Bill Preparation'!M4+ROUND('Bill Preparation'!F4*'Bill Preparation'!H4/100,0)+ROUND('Bill Preparation'!F4*'Bill Preparation'!I4/100,0)+'Bill Preparation'!K4+'Bill Preparation'!N4+'Bill Preparation'!O4","v":59167},200,{"$f":"'Bill Preparation'!G4+'Bill Preparation'!M4+ROUND('Bill Preparation'!G4*'Bill Preparation'!H4/100,0)+ROUND('Bill Preparation'!G4*'Bill Preparation'!I4/100,0)+'Bill Preparation'!L4+'Bill Preparation'!N4+'Bill Preparation'!O4","v":45905},200]
[{"$f":"'Bill Preparation'!B5","v":"2023-09-01"},{"$f":"'Bill Preparation'!D5","v":"2023-09-30"},30,{"$f":"ROUND('Bill Preparation'!F5*C9/'Bill Preparation'!AN5,0)","v":44570},{"$f":"ROUND('Bill Preparation'!M5*C9/'Bill Preparation'!AN5,0)","v":0},{"$f":"ROUND('Bill Preparation'!N5*C9/'Bill Preparation'!AN5,0)","v":0},{"$f":"ROUND('Bill Preparation'!O5*C9/'Bill Preparation'!AN5,0)","v":0},{"$f":"ROUND(D9*'Bill Preparation'!H5/100,0)","v":10140},{"$f":"IF(ROUND(D9*'Bill Preparation'!I5/100,0)>('Bill Preparation'!I5+1)*1000,('Bill Preparation'!I5+1)*1000,ROUND(D9*'Bill Preparation'!I5/100,0))","v":4457},{"$f":"ROUND(D9*'Bill Preparation'!J5/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P5*C9/'Bill Preparation'!AN5,0)","v":0},{"$f":"ROUND('Bill Preparation'!K5*C9/'Bill Preparation'!AN5,0)","v":0},59167,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C9>AQ9/2,AS9,0))","v":200},{"$f":"ROUND('Bill Preparation'!G5*C9/'Bill Preparation'!AN5,0)","v":34580},{"$f":"ROUND('Bill Preparation'!M5*C9/'Bill Preparation'!AN5,0)","v":0},{"$f":"ROUND('Bill Preparation'!N5*C9/'Bill Preparation'!AN5,0)","v":0},{"$f":"ROUND('Bill Preparation'!O5*C9/'Bill Preparation'!AN5,0)","v":0},{"$f":"ROUND(O9*'Bill Preparation'!H5/100,0)","v":7867},{"$f":"IF(ROUND(O9*'Bill Preparation'!I5/100,0)>('Bill Preparation'!I5+1)*1000,('Bill Preparation'!I5+1)*1000,ROUND(O9*'Bill Preparation'!I5/100,0))","v":3458},{"$f":"ROUND(O9*'Bill Preparation'!J5/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q5*C9/'Bill Preparation'!AN5,0)","v":0},{"$f":"ROUND('Bill Preparation'!L5*C9/'Bill Preparation'!AN5,0)","v":0},45905,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C9>AQ9/2,AU9,0))","v":200},9990,0,0,0,2273,999,0,0,0,13262,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z9*'Bill Preparation'!R5%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z9+AD9)*10%,0),0)","v":1226},1226,12036,null,9,"30",{"$f":"'Bill Preparation'!F5+'Bill Preparation'!M5+ROUND('Bill Preparation'!F5*'Bill Preparation'!H5/100,0)+ROUND('Bill Preparation'!F5*'Bill Preparation'!I5/100,0)+'Bill Preparation'!K5+'Bill Preparation'!N5+'Bill Preparation'!O5","v":59167},200,{"$f":"'Bill Preparation'!G5+'Bill Preparation'!M5+ROUND('Bill Preparation'!G5*'Bill Preparation'!H5/100,0)+ROUND('Bill Preparation'!G5*'Bill Preparation'!I5/100,0)+'Bill Preparation'!L5+'Bill Preparation'!N5+'Bill Preparation'!O5","v":45905},200]
[{"$f":"'Bill Preparation'!B6","v":"2023-10-01"},{"$f":"'Bill Preparation'!D6","v":"2023-10-31"},31,{"$f":"ROUND('Bill Preparation'!F6*C10/'Bill Preparation'!AN6,0)","v":0},{"$f":"ROUND('Bill Preparation'!M6*C10/'Bill Preparation'!AN6,0)","v":0},{"$f":"ROUND('Bill Preparation'!N6*C10/'Bill Preparation'!AN6,0)","v":0},{"$f":"ROUND('Bill Preparation'!O6*C10/'Bill Preparation'!AN6,0)","v":0},{"$f":"ROUND(D10*'Bill Preparation'!H6/100,0)","v":0},{"$f":"IF(ROUND(D10*'Bill Preparation'!I6/100,0)>('Bill Preparation'!I6+1)*1000,('Bill Preparation'!I6+1)*1000,ROUND(D10*'Bill Preparation'!I6/100,0))","v":0},{"$f":"ROUND(D10*'Bill Preparation'!J6/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P6*C10/'Bill Preparation'!AN6,0)","v":0},{"$f":"ROUND('Bill Preparation'!K6*C10/'Bill Preparation'!AN6,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C10>AQ10/2,AS10,0))","v":0},{"$f":"ROUND('Bill Preparation'!G6*C10/'Bill Preparation'!AN6,0)","v":0},{"$f":"ROUND('Bill Preparation'!M6*C10/'Bill Preparation'!AN6,0)","v":0},{"$f":"ROUND('Bill Preparation'!N6*C10/'Bill Preparation'!AN6,0)","v":0},{"$f":"ROUND('Bill Preparation'!O6*C10/'Bill Preparation'!AN6,0)","v":0},{"$f":"ROUND(O10*'Bill Preparation'!H6/100,0)","v":0},{"$f":"IF(ROUND(O10*'Bill Preparation'!I6/100,0)>('Bill Preparation'!I6+1)*1000,('Bill Preparation'!I6+1)*1000,ROUND(O10*'Bill Preparation'!I6/100,0))","v":0},{"$f":"ROUND(O10*'Bill Preparation'!J6/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q6*C10/'Bill Preparation'!AN6,0)","v":0},{"$f":"ROUND('Bill Preparation'!L6*C10/'Bill Preparation'!AN6,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C10>AQ10/2,AU10,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z10*'Bill Preparation'!R6%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z10+AD10)*10%,0),0)","v":0},0,0,null,10,"31",{"$f":"'Bill Preparation'!F6+'Bill Preparation'!M6+ROUND('Bill Preparation'!F6*'Bill Preparation'!H6/100,0)+ROUND('Bill Preparation'!F6*'Bill Preparation'!I6/100,0)+'Bill Preparation'!K6+'Bill Preparation'!N6+'Bill Preparation'!O6","v":0},0,{"$f":"'Bill Preparation'!G6+'Bill Preparation'!M6+ROUND('Bill Preparation'!G6*'Bill Preparation'!H6/100,0)+ROUND('Bill Preparation'!G6*'Bill Preparation'!I6/100,0)+'Bill Preparation'!L6+'Bill Preparation'!N6+'Bill Preparation'!O6","v":0},0]
[{"$f":"'Bill Preparation'!B7","v":"2023-11-01"},{"$f":"'Bill Preparation'!D7","v":"2023-11-30"},30,{"$f":"ROUND('Bill Preparation'!F7*C11/'Bill Preparation'!AN7,0)","v":0},{"$f":"ROUND('Bill Preparation'!M7*C11/'Bill Preparation'!AN7,0)","v":0},{"$f":"ROUND('Bill Preparation'!N7*C11/'Bill Preparation'!AN7,0)","v":0},{"$f":"ROUND('Bill Preparation'!O7*C11/'Bill Preparation'!AN7,0)","v":0},{"$f":"ROUND(D11*'Bill Preparation'!H7/100,0)","v":0},{"$f":"IF(ROUND(D11*'Bill Preparation'!I7/100,0)>('Bill Preparation'!I7+1)*1000,('Bill Preparation'!I7+1)*1000,ROUND(D11*'Bill Preparation'!I7/100,0))","v":0},{"$f":"ROUND(D11*'Bill Preparation'!J7/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P7*C11/'Bill Preparation'!AN7,0)","v":0},{"$f":"ROUND('Bill Preparation'!K7*C11/'Bill Preparation'!AN7,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C11>AQ11/2,AS11,0))","v":0},{"$f":"ROUND('Bill Preparation'!G7*C11/'Bill Preparation'!AN7,0)","v":0},{"$f":"ROUND('Bill Preparation'!M7*C11/'Bill Preparation'!AN7,0)","v":0},{"$f":"ROUND('Bill Preparation'!N7*C11/'Bill Preparation'!AN7,0)","v":0},{"$f":"ROUND('Bill Preparation'!O7*C11/'Bill Preparation'!AN7,0)","v":0},{"$f":"ROUND(O11*'Bill Preparation'!H7/100,0)","v":0},{"$f":"IF(ROUND(O11*'Bill Preparation'!I7/100,0)>('Bill Preparation'!I7+1)*1000,('Bill Preparation'!I7+1)*1000,ROUND(O11*'Bill Preparation'!I7/100,0))","v":0},{"$f":"ROUND(O11*'Bill Preparation'!J7/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q7*C11/'Bill Preparation'!AN7,0)","v":0},{"$f":"ROUND('Bill Preparation'!L7*C11/'Bill Preparation'!AN7,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C11>AQ11/2,AU11,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z11*'Bill Preparation'!R7%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z11+AD11)*10%,0),0)","v":0},0,0,null,11,"30",{"$f":"'Bill Preparation'!F7+'Bill Preparation'!M7+ROUND('Bill Preparation'!F7*'Bill Preparation'!H7/100,0)+ROUND('Bill Preparation'!F7*'Bill Preparation'!I7/100,0)+'Bill Preparation'!K7+'Bill Preparation'!N7+'Bill Preparation'!O7","v":0},0,{"$f":"'Bill Preparation'!G7+'Bill Preparation'!M7+ROUND('Bill Preparation'!G7*'Bill Preparation'!H7/100,0)+ROUND('Bill Preparation'!G7*'Bill Preparation'!I7/100,0)+'Bill Preparation'!L7+'Bill Preparation'!N7+'Bill Preparation'!O7","v":0},0]
[{"$f":"'Bill Preparation'!B8","v":"2023-12-01"},{"$f":"'Bill Preparation'!D8","v":"2023-12-31"},31,{"$f":"ROUND('Bill Preparation'!F8*C12/'Bill Preparation'!AN8,0)","v":0},{"$f":"ROUND('Bill Preparation'!M8*C12/'Bill Preparation'!AN8,0)","v":0},{"$f":"ROUND('Bill Preparation'!N8*C12/'Bill Preparation'!AN8,0)","v":0},{"$f":"ROUND('Bill Preparation'!O8*C12/'Bill Preparation'!AN8,0)","v":0},{"$f":"ROUND(D12*'Bill Preparation'!H8/100,0)","v":0},{"$f":"IF(ROUND(D12*'Bill Preparation'!I8/100,0)>('Bill Preparation'!I8+1)*1000,('Bill Preparation'!I8+1)*1000,ROUND(D12*'Bill Preparation'!I8/100,0))","v":0},{"$f":"ROUND(D12*'Bill Preparation'!J8/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P8*C12/'Bill Preparation'!AN8,0)","v":0},{"$f":"ROUND('Bill Preparation'!K8*C12/'Bill Preparation'!AN8,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C12>AQ12/2,AS12,0))","v":0},{"$f":"ROUND('Bill Preparation'!G8*C12/'Bill Preparation'!AN8,0)","v":0},{"$f":"ROUND('Bill Preparation'!M8*C12/'Bill Preparation'!AN8,0)","v":0},{"$f":"ROUND('Bill Preparation'!N8*C12/'Bill Preparation'!AN8,0)","v":0},{"$f":"ROUND('Bill Preparation'!O8*C12/'Bill Preparation'!AN8,0)","v":0},{"$f":"ROUND(O12*'Bill Preparation'!H8/100,0)","v":0},{"$f":"IF(ROUND(O12*'Bill Preparation'!I8/100,0)>('Bill Preparation'!I8+1)*1000,('Bill Preparation'!I8+1)*1000,ROUND(O12*'Bill Preparation'!I8/100,0))","v":0},{"$f":"ROUND(O12*'Bill Preparation'!J8/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q8*C12/'Bill Preparation'!AN8,0)","v":0},{"$f":"ROUND('Bill Preparation'!L8*C12/'Bill Preparation'!AN8,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C12>AQ12/2,AU12,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z12*'Bill Preparation'!R8%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z12+AD12)*10%,0),0)","v":0},0,0,null,12,"31",{"$f":"'Bill Preparation'!F8+'Bill Preparation'!M8+ROUND('Bill Preparation'!F8*'Bill Preparation'!H8/100,0)+ROUND('Bill Preparation'!F8*'Bill Preparation'!I8/100,0)+'Bill Preparation'!K8+'Bill Preparation'!N8+'Bill Preparation'!O8","v":0},0,{"$f":"'Bill Preparation'!G8+'Bill Preparation'!M8+ROUND('Bill Preparation'!G8*'Bill Preparation'!H8/100,0)+ROUND('Bill Preparation'!G8*'Bill Preparation'!I8/100,0)+'Bill Preparation'!L8+'Bill Preparation'!N8+'Bill Preparation'!O8","v":0},0]
[{"$f":"'Bill Preparation'!B9","v":"2024-01-01"},{"$f":"'Bill Preparation'!D9","v":"2024-01-31"},{"$f":"(B13-A13)+1","v":31},{"$f":"ROUND('Bill Preparation'!F9*C13/'Bill Preparation'!AN9,0)","v":0},{"$f":"ROUND('Bill Preparation'!M9*C13/'Bill Preparation'!AN9,0)","v":0},{"$f":"ROUND('Bill Preparation'!N9*C13/'Bill Preparation'!AN9,0)","v":0},{"$f":"ROUND('Bill Preparation'!O9*C13/'Bill Preparation'!AN9,0)","v":0},{"$f":"ROUND(D13*'Bill Preparation'!H9/100,0)","v":0},{"$f":"IF(ROUND(D13*'Bill Preparation'!I9/100,0)>('Bill Preparation'!I9+1)*1000,('Bill Preparation'!I9+1)*1000,ROUND(D13*'Bill Preparation'!I9/100,0))","v":0},{"$f":"ROUND(D13*'Bill Preparation'!J9/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P9*C13/'Bill Preparation'!AN9,0)","v":0},{"$f":"ROUND('Bill Preparation'!K9*C13/'Bill Preparation'!AN9,0)","v":0},{"$f":"SUM(D13:L13)","v":0},{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C13>AQ13/2,AS13,0))","v":0},{"$f":"ROUND('Bill Preparation'!G9*C13/'Bill Preparation'!AN9,0)","v":0},{"$f":"ROUND('Bill Preparation'!M9*C13/'Bill Preparation'!AN9,0)","v":0},{"$f":"ROUND('Bill Preparation'!N9*C13/'Bill Preparation'!AN9,0)","v":0},{"$f":"ROUND('Bill Preparation'!O9*C13/'Bill Preparation'!AN9,0)","v":0},{"$f":"ROUND(O13*'Bill Preparation'!H9/100,0)","v":0},{"$f":"IF(ROUND(O13*'Bill Preparation'!I9/100,0)>('Bill Preparation'!I9+1)*1000,('Bill Preparation'!I9+1)*1000,ROUND(O13*'Bill Preparation'!I9/100,0))","v":0},{"$f":"ROUND(O13*'Bill Preparation'!J9/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q9*C13/'Bill Preparation'!AN9,0)","v":0},{"$f":"ROUND('Bill Preparation'!L9*C13/'Bill Preparation'!AN9,0)","v":0},{"$f":"SUM(O13:W13)","v":0},{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C13>AQ13/2,AU13,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z13*'Bill Preparation'!R9%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z13+AD13)*10%,0),0)","v":0},0,0,null,1,"31",{"$f":"'Bill Preparation'!F9+'Bill Preparation'!M9+ROUND('Bill Preparation'!F9*'Bill Preparation'!H9/100,0)+ROUND('Bill Preparation'!F9*'Bill Preparation'!I9/100,0)+'Bill Preparation'!K9+'Bill Preparation'!N9+'Bill Preparation'!O9","v":0},0,{"$f":"'Bill Preparation'!G9+'Bill Preparation'!M9+ROUND('Bill Preparation'!G9*'Bill Preparation'!H9/100,0)+ROUND('Bill Preparation'!G9*'Bill Preparation'!I9/100,0)+'Bill Preparation'!L9+'Bill Preparation'!N9+'Bill Preparation'!O9","v":0},0]
[{"$f":"'Bill Preparation'!B10","v":"2024-02-01"},{"$f":"'Bill Preparation'!D10","v":"2024-02-29"},{"$f":"(B14-A14)+1","v":29},{"$f":"ROUND('Bill Preparation'!F10*C14/'Bill Preparation'!AN10,0)","v":0},{"$f":"ROUND('Bill Preparation'!M10*C14/'Bill Preparation'!AN10,0)","v":0},{"$f":"ROUND('Bill Preparation'!N10*C14/'Bill Preparation'!AN10,0)","v":0},{"$f":"ROUND('Bill Preparation'!O10*C14/'Bill Preparation'!AN10,0)","v":0},{"$f":"ROUND(D14*'Bill Preparation'!H10/100,0)","v":0},{"$f":"IF(ROUND(D14*'Bill Preparation'!I10/100,0)>('Bill Preparation'!I10+1)*1000,('Bill Preparation'!I10+1)*1000,ROUND(D14*'Bill Preparation'!I10/100,0))","v":0},{"$f":"ROUND(D14*'Bill Preparation'!J10/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P10*C14/'Bill Preparation'!AN10,0)","v":0},{"$f":"ROUND('Bill Preparation'!K10*C14/'Bill Preparation'!AN10,0)","v":0},{"$f":"SUM(D14:L14)","v":0},{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C14>AQ14/2,AS14,0))","v":0},{"$f":"ROUND('Bill Preparation'!G10*C14/'Bill Preparation'!AN10,0)","v":0},{"$f":"ROUND('Bill Preparation'!M10*C14/'Bill Preparation'!AN10,0)","v":0},{"$f":"ROUND('Bill Preparation'!N10*C14/'Bill Preparation'!AN10,0)","v":0},{"$f":"ROUND('Bill Preparation'!O10*C14/'Bill Preparation'!AN10,0)","v":0},{"$f":"ROUND(O14*'Bill Preparation'!H10/100,0)","v":0},{"$f":"IF(ROUND(O14*'Bill Preparation'!I10/100,0)>('Bill Preparation'!I10+1)*1000,('Bill Preparation'!I10+1)*1000,ROUND(O14*'Bill Preparation'!I10/100,0))","v":0},{"$f":"ROUND(O14*'Bill Preparation'!J10/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q10*C14/'Bill Preparation'!AN10,0)","v":0},{"$f":"ROUND('Bill Preparation'!L10*C14/'Bill Preparation'!AN10,0)","v":0},{"$f":"SUM(O14:W14)","v":0},{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C14>AQ14/2,AU14,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z14*'Bill Preparation'!R10%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z14+AD14)*10%,0),0)","v":0},0,0,null,2,"28",{"$f":"'Bill Preparation'!F10+'Bill Preparation'!M10+ROUND('Bill Preparation'!F10*'Bill Preparation'!H10/100,0)+ROUND('Bill Preparation'!F10*'Bill Preparation'!I10/100,0)+'Bill Preparation'!K10+'Bill Preparation'!N10+'Bill Preparation'!O10","v":0},0,{"$f":"'Bill Preparation'!G10+'Bill Preparation'!M10+ROUND('Bill Preparation'!G10*'Bill Preparation'!H10/100,0)+ROUND('Bill Preparation'!G10*'Bill Preparation'!I10/100,0)+'Bill Preparation'!L10+'Bill Preparation'!N10+'Bill Preparation'!O10","v":0},0]
[{"$f":"'Bill Preparation'!B11","v":"2024-03-01"},{"$f":"'Bill Preparation'!D11","v":"2024-03-31"},31,{"$f":"ROUND('Bill Preparation'!F11*C15/'Bill Preparation'!AN11,0)","v":0},{"$f":"ROUND('Bill Preparation'!M11*C15/'Bill Preparation'!AN11,0)","v":0},{"$f":"ROUND('Bill Preparation'!N11*C15/'Bill Preparation'!AN11,0)","v":0},{"$f":"ROUND('Bill Preparation'!O11*C15/'Bill Preparation'!AN11,0)","v":0},{"$f":"ROUND(D15*'Bill Preparation'!H11/100,0)","v":0},{"$f":"IF(ROUND(D15*'Bill Preparation'!I11/100,0)>('Bill Preparation'!I11+1)*1000,('Bill Preparation'!I11+1)*1000,ROUND(D15*'Bill Preparation'!I11/100,0))","v":0},{"$f":"ROUND(D15*'Bill Preparation'!J11/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P11*C15/'Bill Preparation'!AN11,0)","v":0},{"$f":"ROUND('Bill Preparation'!K11*C15/'Bill Preparation'!AN11,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C15>AQ15/2,AS15,0))","v":0},{"$f":"ROUND('Bill Preparation'!G11*C15/'Bill Preparation'!AN11,0)","v":0},{"$f":"ROUND('Bill Preparation'!M11*C15/'Bill Preparation'!AN11,0)","v":0},{"$f":"ROUND('Bill Preparation'!N11*C15/'Bill Preparation'!AN11,0)","v":0},{"$f":"ROUND('Bill Preparation'!O11*C15/'Bill Preparation'!AN11,0)","v":0},{"$f":"ROUND(O15*'Bill Preparation'!H11/100,0)","v":0},{"$f":"IF(ROUND(O15*'Bill Preparation'!I11/100,0)>('Bill Preparation'!I11+1)*1000,('Bill Preparation'!I11+1)*1000,ROUND(O15*'Bill Preparation'!I11/100,0))","v":0},{"$f":"ROUND(O15*'Bill Preparation'!J11/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q11*C15/'Bill Preparation'!AN11,0)","v":0},{"$f":"ROUND('Bill Preparation'!L11*C15/'Bill Preparation'!AN11,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C15>AQ15/2,AU15,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z15*'Bill Preparation'!R11%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z15+AD15)*10%,0),0)","v":0},0,0,null,3,"31",{"$f":"'Bill Preparation'!F11+'Bill Preparation'!M11+ROUND('Bill Preparation'!F11*'Bill Preparation'!H11/100,0)+ROUND('Bill Preparation'!F11*'Bill Preparation'!I11/100,0)+'Bill Preparation'!K11+'Bill Preparation'!N11+'Bill Preparation'!O11","v":0},0,{"$f":"'Bill Preparation'!G11+'Bill Preparation'!M11+ROUND('Bill Preparation'!G11*'Bill Preparation'!H11/100,0)+ROUND('Bill Preparation'!G11*'Bill Preparation'!I11/100,0)+'Bill Preparation'!L11+'Bill Preparation'!N11+'Bill Preparation'!O11","v":0},0]
[{"$f":"'Bill Preparation'!B12","v":"2024-04-01"},{"$f":"'Bill Preparation'!D12","v":"2024-04-30"},30,{"$f":"ROUND('Bill Preparation'!F12*C16/'Bill Preparation'!AN12,0)","v":0},{"$f":"ROUND('Bill Preparation'!M12*C16/'Bill Preparation'!AN12,0)","v":0},{"$f":"ROUND('Bill Preparation'!N12*C16/'Bill Preparation'!AN12,0)","v":0},{"$f":"ROUND('Bill Preparation'!O12*C16/'Bill Preparation'!AN12,0)","v":0},{"$f":"ROUND(D16*'Bill Preparation'!H12/100,0)","v":0},{"$f":"IF(ROUND(D16*'Bill Preparation'!I12/100,0)>('Bill Preparation'!I12+1)*1000,('Bill Preparation'!I12+1)*1000,ROUND(D16*'Bill Preparation'!I12/100,0))","v":0},{"$f":"ROUND(D16*'Bill Preparation'!J12/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P12*C16/'Bill Preparation'!AN12,0)","v":0},{"$f":"ROUND('Bill Preparation'!K12*C16/'Bill Preparation'!AN12,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C16>AQ16/2,AS16,0))","v":0},{"$f":"ROUND('Bill Preparation'!G12*C16/'Bill Preparation'!AN12,0)","v":0},{"$f":"ROUND('Bill Preparation'!M12*C16/'Bill Preparation'!AN12,0)","v":0},{"$f":"ROUND('Bill Preparation'!N12*C16/'Bill Preparation'!AN12,0)","v":0},{"$f":"ROUND('Bill Preparation'!O12*C16/'Bill Preparation'!AN12,0)","v":0},{"$f":"ROUND(O16*'Bill Preparation'!H12/100,0)","v":0},{"$f":"IF(ROUND(O16*'Bill Preparation'!I12/100,0)>('Bill Preparation'!I12+1)*1000,('Bill Preparation'!I12+1)*1000,ROUND(O16*'Bill Preparation'!I12/100,0))","v":0},{"$f":"ROUND(O16*'Bill Preparation'!J12/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q12*C16/'Bill Preparation'!AN12,0)","v":0},{"$f":"ROUND('Bill Preparation'!L12*C16/'Bill Preparation'!AN12,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C16>AQ16/2,AU16,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z16*'Bill Preparation'!R12%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z16+AD16)*10%,0),0)","v":0},0,0,null,4,"30",{"$f":"'Bill Preparation'!F12+'Bill Preparation'!M12+ROUND('Bill Preparation'!F12*'Bill Preparation'!H12/100,0)+ROUND('Bill Preparation'!F12*'Bill Preparation'!I12/100,0)+'Bill Preparation'!K12+'Bill Preparation'!N12+'Bill Preparation'!O12","v":0},0,{"$f":"'Bill Preparation'!G12+'Bill Preparation'!M12+ROUND('Bill Preparation'!G12*'Bill Preparation'!H12/100,0)+ROUND('Bill Preparation'!G12*'Bill Preparation'!I12/100,0)+'Bill Preparation'!L12+'Bill Preparation'!N12+'Bill Preparation'!O12","v":0},0]
[{"$f":"'Bill Preparation'!B13","v":"2024-05-01"},{"$f":"'Bill Preparation'!D13","v":"2024-05-31"},31,{"$f":"ROUND('Bill Preparation'!F13*C17/'Bill Preparation'!AN13,0)","v":0},{"$f":"ROUND('Bill Preparation'!M13*C17/'Bill Preparation'!AN13,0)","v":0},{"$f":"ROUND('Bill Preparation'!N13*C17/'Bill Preparation'!AN13,0)","v":0},{"$f":"ROUND('Bill Preparation'!O13*C17/'Bill Preparation'!AN13,0)","v":0},{"$f":"ROUND(D17*'Bill Preparation'!H13/100,0)","v":0},{"$f":"IF(ROUND(D17*'Bill Preparation'!I13/100,0)>('Bill Preparation'!I13+1)*1000,('Bill Preparation'!I13+1)*1000,ROUND(D17*'Bill Preparation'!I13/100,0))","v":0},{"$f":"ROUND(D17*'Bill Preparation'!J13/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P13*C17/'Bill Preparation'!AN13,0)","v":0},{"$f":"ROUND('Bill Preparation'!K13*C17/'Bill Preparation'!AN13,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C17>AQ17/2,AS17,0))","v":0},{"$f":"ROUND('Bill Preparation'!G13*C17/'Bill Preparation'!AN13,0)","v":0},{"$f":"ROUND('Bill Preparation'!M13*C17/'Bill Preparation'!AN13,0)","v":0},{"$f":"ROUND('Bill Preparation'!N13*C17/'Bill Preparation'!AN13,0)","v":0},{"$f":"ROUND('Bill Preparation'!O13*C17/'Bill Preparation'!AN13,0)","v":0},{"$f":"ROUND(O17*'Bill Preparation'!H13/100,0)","v":0},{"$f":"IF(ROUND(O17*'Bill Preparation'!I13/100,0)>('Bill Preparation'!I13+1)*1000,('Bill Preparation'!I13+1)*1000,ROUND(O17*'Bill Preparation'!I13/100,0))","v":0},{"$f":"ROUND(O17*'Bill Preparation'!J13/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q13*C17/'Bill Preparation'!AN13,0)","v":0},{"$f":"ROUND('Bill Preparation'!L13*C17/'Bill Preparation'!AN13,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C17>AQ17/2,AU17,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z17*'Bill Preparation'!R13%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z17+AD17)*10%,0),0)","v":0},0,0,null,5,"31",{"$f":"'Bill Preparation'!F13+'Bill Preparation'!M13+ROUND('Bill Preparation'!F13*'Bill Preparation'!H13/100,0)+ROUND('Bill Preparation'!F13*'Bill Preparation'!I13/100,0)+'Bill Preparation'!K13+'Bill Preparation'!N13+'Bill Preparation'!O13","v":0},0,{"$f":"'Bill Preparation'!G13+'Bill Preparation'!M13+ROUND('Bill Preparation'!G13*'Bill Preparation'!H13/100,0)+ROUND('Bill Preparation'!G13*'Bill Preparation'!I13/100,0)+'Bill Preparation'!L13+'Bill Preparation'!N13+'Bill Preparation'!O13","v":0},0]
[{"$f":"'Bill Preparation'!B14","v":"2024-06-01"},{"$f":"'Bill Preparation'!D14","v":"2024-06-30"},30,{"$f":"ROUND('Bill Preparation'!F14*C18/'Bill Preparation'!AN14,0)","v":0},{"$f":"ROUND('Bill Preparation'!M14*C18/'Bill Preparation'!AN14,0)","v":0},{"$f":"ROUND('Bill Preparation'!N14*C18/'Bill Preparation'!AN14,0)","v":0},{"$f":"ROUND('Bill Preparation'!O14*C18/'Bill Preparation'!AN14,0)","v":0},{"$f":"ROUND(D18*'Bill Preparation'!H14/100,0)","v":0},{"$f":"IF(ROUND(D18*'Bill Preparation'!I14/100,0)>('Bill Preparation'!I14+1)*1000,('Bill Preparation'!I14+1)*1000,ROUND(D18*'Bill Preparation'!I14/100,0))","v":0},{"$f":"ROUND(D18*'Bill Preparation'!J14/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P14*C18/'Bill Preparation'!AN14,0)","v":0},{"$f":"ROUND('Bill Preparation'!K14*C18/'Bill Preparation'!AN14,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C18>AQ18/2,AS18,0))","v":0},{"$f":"ROUND('Bill Preparation'!G14*C18/'Bill Preparation'!AN14,0)","v":0},{"$f":"ROUND('Bill Preparation'!M14*C18/'Bill Preparation'!AN14,0)","v":0},{"$f":"ROUND('Bill Preparation'!N14*C18/'Bill Preparation'!AN14,0)","v":0},{"$f":"ROUND('Bill Preparation'!O14*C18/'Bill Preparation'!AN14,0)","v":0},{"$f":"ROUND(O18*'Bill Preparation'!H14/100,0)","v":0},{"$f":"IF(ROUND(O18*'Bill Preparation'!I14/100,0)>('Bill Preparation'!I14+1)*1000,('Bill Preparation'!I14+1)*1000,ROUND(O18*'Bill Preparation'!I14/100,0))","v":0},{"$f":"ROUND(O18*'Bill Preparation'!J14/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q14*C18/'Bill Preparation'!AN14,0)","v":0},{"$f":"ROUND('Bill Preparation'!L14*C18/'Bill Preparation'!AN14,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C18>AQ18/2,AU18,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z18*'Bill Preparation'!R14%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z18+AD18)*10%,0),0)","v":0},0,0,null,6,"30",{"$f":"'Bill Preparation'!F14+'Bill Preparation'!M14+ROUND('Bill Preparation'!F14*'Bill Preparation'!H14/100,0)+ROUND('Bill Preparation'!F14*'Bill Preparation'!I14/100,0)+'Bill Preparation'!K14+'Bill Preparation'!N14+'Bill Preparation'!O14","v":0},0,{"$f":"'Bill Preparation'!G14+'Bill Preparation'!M14+ROUND('Bill Preparation'!G14*'Bill Preparation'!H14/100,0)+ROUND('Bill Preparation'!G14*'Bill Preparation'!I14/100,0)+'Bill Preparation'!L14+'Bill Preparation'!N14+'Bill Preparation'!O14","v":0},0]
[{"$f":"'Bill Preparation'!B15","v":"2024-07-01"},{"$f":"'Bill Preparation'!D15","v":"2024-07-31"},31,{"$f":"ROUND('Bill Preparation'!F15*C19/'Bill Preparation'!AN15,0)","v":0},{"$f":"ROUND('Bill Preparation'!M15*C19/'Bill Preparation'!AN15,0)","v":0},{"$f":"ROUND('Bill Preparation'!N15*C19/'Bill Preparation'!AN15,0)","v":0},{"$f":"ROUND('Bill Preparation'!O15*C19/'Bill Preparation'!AN15,0)","v":0},{"$f":"ROUND(D19*'Bill Preparation'!H15/100,0)","v":0},{"$f":"IF(ROUND(D19*'Bill Preparation'!I15/100,0)>('Bill Preparation'!I15+1)*1000,('Bill Preparation'!I15+1)*1000,ROUND(D19*'Bill Preparation'!I15/100,0))","v":0},{"$f":"ROUND(D19*'Bill Preparation'!J15/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P15*C19/'Bill Preparation'!AN15,0)","v":0},{"$f":"ROUND('Bill Preparation'!K15*C19/'Bill Preparation'!AN15,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C19>AQ19/2,AS19,0))","v":0},{"$f":"ROUND('Bill Preparation'!G15*C19/'Bill Preparation'!AN15,0)","v":0},{"$f":"ROUND('Bill Preparation'!M15*C19/'Bill Preparation'!AN15,0)","v":0},{"$f":"ROUND('Bill Preparation'!N15*C19/'Bill Preparation'!AN15,0)","v":0},{"$f":"ROUND('Bill Preparation'!O15*C19/'Bill Preparation'!AN15,0)","v":0},{"$f":"ROUND(O19*'Bill Preparation'!H15/100,0)","v":0},{"$f":"IF(ROUND(O19*'Bill Preparation'!I15/100,0)>('Bill Preparation'!I15+1)*1000,('Bill Preparation'!I15+1)*1000,ROUND(O19*'Bill Preparation'!I15/100,0))","v":0},{"$f":"ROUND(O19*'Bill Preparation'!J15/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q15*C19/'Bill Preparation'!AN15,0)","v":0},{"$f":"ROUND('Bill Preparation'!L15*C19/'Bill Preparation'!AN15,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C19>AQ19/2,AU19,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z19*'Bill Preparation'!R15%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z19+AD19)*10%,0),0)","v":0},0,0,null,7,"31",{"$f":"'Bill Preparation'!F15+'Bill Preparation'!M15+ROUND('Bill Preparation'!F15*'Bill Preparation'!H15/100,0)+ROUND('Bill Preparation'!F15*'Bill Preparation'!I15/100,0)+'Bill Preparation'!K15+'Bill Preparation'!N15+'Bill Preparation'!O15","v":0},0,{"$f":"'Bill Preparation'!G15+'Bill Preparation'!M15+ROUND('Bill Preparation'!G15*'Bill Preparation'!H15/100,0)+ROUND('Bill Preparation'!G15*'Bill Preparation'!I15/100,0)+'Bill Preparation'!L15+'Bill Preparation'!N15+'Bill Preparation'!O15","v":0},0]
[{"$f":"'Bill Preparation'!B16","v":"2024-08-01"},{"$f":"'Bill Preparation'!D16","v":"2024-08-31"},31,{"$f":"ROUND('Bill Preparation'!F16*C20/'Bill Preparation'!AN16,0)","v":0},{"$f":"ROUND('Bill Preparation'!M16*C20/'Bill Preparation'!AN16,0)","v":0},{"$f":"ROUND('Bill Preparation'!N16*C20/'Bill Preparation'!AN16,0)","v":0},{"$f":"ROUND('Bill Preparation'!O16*C20/'Bill Preparation'!AN16,0)","v":0},{"$f":"ROUND(D20*'Bill Preparation'!H16/100,0)","v":0},{"$f":"IF(ROUND(D20*'Bill Preparation'!I16/100,0)>('Bill Preparation'!I16+1)*1000,('Bill Preparation'!I16+1)*1000,ROUND(D20*'Bill Preparation'!I16/100,0))","v":0},{"$f":"ROUND(D20*'Bill Preparation'!J16/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P16*C20/'Bill Preparation'!AN16,0)","v":0},{"$f":"ROUND('Bill Preparation'!K16*C20/'Bill Preparation'!AN16,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C20>AQ20/2,AS20,0))","v":0},{"$f":"ROUND('Bill Preparation'!G16*C20/'Bill Preparation'!AN16,0)","v":0},{"$f":"ROUND('Bill Preparation'!M16*C20/'Bill Preparation'!AN16,0)","v":0},{"$f":"ROUND('Bill Preparation'!N16*C20/'Bill Preparation'!AN16,0)","v":0},{"$f":"ROUND('Bill Preparation'!O16*C20/'Bill Preparation'!AN16,0)","v":0},{"$f":"ROUND(O20*'Bill Preparation'!H16/100,0)","v":0},{"$f":"IF(ROUND(O20*'Bill Preparation'!I16/100,0)>('Bill Preparation'!I16+1)*1000,('Bill Preparation'!I16+1)*1000,ROUND(O20*'Bill Preparation'!I16/100,0))","v":0},{"$f":"ROUND(O20*'Bill Preparation'!J16/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q16*C20/'Bill Preparation'!AN16,0)","v":0},{"$f":"ROUND('Bill Preparation'!L16*C20/'Bill Preparation'!AN16,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C20>AQ20/2,AU20,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z20*'Bill Preparation'!R16%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z20+AD20)*10%,0),0)","v":0},0,0,null,8,"31",{"$f":"'Bill Preparation'!F16+'Bill Preparation'!M16+ROUND('Bill Preparation'!F16*'Bill Preparation'!H16/100,0)+ROUND('Bill Preparation'!F16*'Bill Preparation'!I16/100,0)+'Bill Preparation'!K16+'Bill Preparation'!N16+'Bill Preparation'!O16","v":0},0,{"$f":"'Bill Preparation'!G16+'Bill Preparation'!M16+ROUND('Bill Preparation'!G16*'Bill Preparation'!H16/100,0)+ROUND('Bill Preparation'!G16*'Bill Preparation'!I16/100,0)+'Bill Preparation'!L16+'Bill Preparation'!N16+'Bill Preparation'!O16","v":0},0]
[{"$f":"'Bill Preparation'!B17","v":"2024-09-01"},{"$f":"'Bill Preparation'!D17","v":"2024-09-30"},30,{"$f":"ROUND('Bill Preparation'!F17*C21/'Bill Preparation'!AN17,0)","v":0},{"$f":"ROUND('Bill Preparation'!M17*C21/'Bill Preparation'!AN17,0)","v":0},{"$f":"ROUND('Bill Preparation'!N17*C21/'Bill Preparation'!AN17,0)","v":0},{"$f":"ROUND('Bill Preparation'!O17*C21/'Bill Preparation'!AN17,0)","v":0},{"$f":"ROUND(D21*'Bill Preparation'!H17/100,0)","v":0},{"$f":"IF(ROUND(D21*'Bill Preparation'!I17/100,0)>('Bill Preparation'!I17+1)*1000,('Bill Preparation'!I17+1)*1000,ROUND(D21*'Bill Preparation'!I17/100,0))","v":0},{"$f":"ROUND(D21*'Bill Preparation'!J17/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P17*C21/'Bill Preparation'!AN17,0)","v":0},{"$f":"ROUND('Bill Preparation'!K17*C21/'Bill Preparation'!AN17,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C21>AQ21/2,AS21,0))","v":0},{"$f":"ROUND('Bill Preparation'!G17*C21/'Bill Preparation'!AN17,0)","v":0},{"$f":"ROUND('Bill Preparation'!M17*C21/'Bill Preparation'!AN17,0)","v":0},{"$f":"ROUND('Bill Preparation'!N17*C21/'Bill Preparation'!AN17,0)","v":0},{"$f":"ROUND('Bill Preparation'!O17*C21/'Bill Preparation'!AN17,0)","v":0},{"$f":"ROUND(O21*'Bill Preparation'!H17/100,0)","v":0},{"$f":"IF(ROUND(O21*'Bill Preparation'!I17/100,0)>('Bill Preparation'!I17+1)*1000,('Bill Preparation'!I17+1)*1000,ROUND(O21*'Bill Preparation'!I17/100,0))","v":0},{"$f":"ROUND(O21*'Bill Preparation'!J17/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q17*C21/'Bill Preparation'!AN17,0)","v":0},{"$f":"ROUND('Bill Preparation'!L17*C21/'Bill Preparation'!AN17,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C21>AQ21/2,AU21,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z21*'Bill Preparation'!R17%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z21+AD21)*10%,0),0)","v":0},0,0,null,9,"30",{"$f":"'Bill Preparation'!F17+'Bill Preparation'!M17+ROUND('Bill Preparation'!F17*'Bill Preparation'!H17/100,0)+ROUND('Bill Preparation'!F17*'Bill Preparation'!I17/100,0)+'Bill Preparation'!K17+'Bill Preparation'!N17+'Bill Preparation'!O17","v":0},0,{"$f":"'Bill Preparation'!G17+'Bill Preparation'!M17+ROUND('Bill Preparation'!G17*'Bill Preparation'!H17/100,0)+ROUND('Bill Preparation'!G17*'Bill Preparation'!I17/100,0)+'Bill Preparation'!L17+'Bill Preparation'!N17+'Bill Preparation'!O17","v":0},0]
[{"$f":"'Bill Preparation'!B18","v":"2024-10-01"},{"$f":"'Bill Preparation'!D18","v":"2024-10-31"},31,{"$f":"ROUND('Bill Preparation'!F18*C22/'Bill Preparation'!AN18,0)","v":0},{"$f":"ROUND('Bill Preparation'!M18*C22/'Bill Preparation'!AN18,0)","v":0},{"$f":"ROUND('Bill Preparation'!N18*C22/'Bill Preparation'!AN18,0)","v":0},{"$f":"ROUND('Bill Preparation'!O18*C22/'Bill Preparation'!AN18,0)","v":0},{"$f":"ROUND(D22*'Bill Preparation'!H18/100,0)","v":0},{"$f":"IF(ROUND(D22*'Bill Preparation'!I18/100,0)>('Bill Preparation'!I18+1)*1000,('Bill Preparation'!I18+1)*1000,ROUND(D22*'Bill Preparation'!I18/100,0))","v":0},{"$f":"ROUND(D22*'Bill Preparation'!J18/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P18*C22/'Bill Preparation'!AN18,0)","v":0},{"$f":"ROUND('Bill Preparation'!K18*C22/'Bill Preparation'!AN18,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C22>AQ22/2,AS22,0))","v":0},{"$f":"ROUND('Bill Preparation'!G18*C22/'Bill Preparation'!AN18,0)","v":0},{"$f":"ROUND('Bill Preparation'!M18*C22/'Bill Preparation'!AN18,0)","v":0},{"$f":"ROUND('Bill Preparation'!N18*C22/'Bill Preparation'!AN18,0)","v":0},{"$f":"ROUND('Bill Preparation'!O18*C22/'Bill Preparation'!AN18,0)","v":0},{"$f":"ROUND(O22*'Bill Preparation'!H18/100,0)","v":0},{"$f":"IF(ROUND(O22*'Bill Preparation'!I18/100,0)>('Bill Preparation'!I18+1)*1000,('Bill Preparation'!I18+1)*1000,ROUND(O22*'Bill Preparation'!I18/100,0))","v":0},{"$f":"ROUND(O22*'Bill Preparation'!J18/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q18*C22/'Bill Preparation'!AN18,0)","v":0},{"$f":"ROUND('Bill Preparation'!L18*C22/'Bill Preparation'!AN18,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C22>AQ22/2,AU22,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z22*'Bill Preparation'!R18%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z22+AD22)*10%,0),0)","v":0},0,0,null,10,"31",{"$f":"'Bill Preparation'!F18+'Bill Preparation'!M18+ROUND('Bill Preparation'!F18*'Bill Preparation'!H18/100,0)+ROUND('Bill Preparation'!F18*'Bill Preparation'!I18/100,0)+'Bill Preparation'!K18+'Bill Preparation'!N18+'Bill Preparation'!O18","v":0},0,{"$f":"'Bill Preparation'!G18+'Bill Preparation'!M18+ROUND('Bill Preparation'!G18*'Bill Preparation'!H18/100,0)+ROUND('Bill Preparation'!G18*'Bill Preparation'!I18/100,0)+'Bill Preparation'!L18+'Bill Preparation'!N18+'Bill Preparation'!O18","v":0},0]
[{"$f":"'Bill Preparation'!B19","v":"2024-11-01"},{"$f":"'Bill Preparation'!D19","v":"2024-11-30"},30,{"$f":"ROUND('Bill Preparation'!F19*C23/'Bill Preparation'!AN19,0)","v":0},{"$f":"ROUND('Bill Preparation'!M19*C23/'Bill Preparation'!AN19,0)","v":0},{"$f":"ROUND('Bill Preparation'!N19*C23/'Bill Preparation'!AN19,0)","v":0},{"$f":"ROUND('Bill Preparation'!O19*C23/'Bill Preparation'!AN19,0)","v":0},{"$f":"ROUND(D23*'Bill Preparation'!H19/100,0)","v":0},{"$f":"IF(ROUND(D23*'Bill Preparation'!I19/100,0)>('Bill Preparation'!I19+1)*1000,('Bill Preparation'!I19+1)*1000,ROUND(D23*'Bill Preparation'!I19/100,0))","v":0},{"$f":"ROUND(D23*'Bill Preparation'!J19/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P19*C23/'Bill Preparation'!AN19,0)","v":0},{"$f":"ROUND('Bill Preparation'!K19*C23/'Bill Preparation'!AN19,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C23>AQ23/2,AS23,0))","v":0},{"$f":"ROUND('Bill Preparation'!G19*C23/'Bill Preparation'!AN19,0)","v":0},{"$f":"ROUND('Bill Preparation'!M19*C23/'Bill Preparation'!AN19,0)","v":0},{"$f":"ROUND('Bill Preparation'!N19*C23/'Bill Preparation'!AN19,0)","v":0},{"$f":"ROUND('Bill Preparation'!O19*C23/'Bill Preparation'!AN19,0)","v":0},{"$f":"ROUND(O23*'Bill Preparation'!H19/100,0)","v":0},{"$f":"IF(ROUND(O23*'Bill Preparation'!I19/100,0)>('Bill Preparation'!I19+1)*1000,('Bill Preparation'!I19+1)*1000,ROUND(O23*'Bill Preparation'!I19/100,0))","v":0},{"$f":"ROUND(O23*'Bill Preparation'!J19/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q19*C23/'Bill Preparation'!AN19,0)","v":0},{"$f":"ROUND('Bill Preparation'!L19*C23/'Bill Preparation'!AN19,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C23>AQ23/2,AU23,0))","v":0},{"$f":"D23-O23","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z23*'Bill Preparation'!R19%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z23+AD23)*10%,0),0)","v":0},0,0,null,11,"30",{"$f":"'Bill Preparation'!F19+'Bill Preparation'!M19+ROUND('Bill Preparation'!F19*'Bill Preparation'!H19/100,0)+ROUND('Bill Preparation'!F19*'Bill Preparation'!I19/100,0)+'Bill Preparation'!K19+'Bill Preparation'!N19+'Bill Preparation'!O19","v":0},0,{"$f":"'Bill Preparation'!G19+'Bill Preparation'!M19+ROUND('Bill Preparation'!G19*'Bill Preparation'!H19/100,0)+ROUND('Bill Preparation'!G19*'Bill Preparation'!I19/100,0)+'Bill Preparation'!L19+'Bill Preparation'!N19+'Bill Preparation'!O19","v":0},0]
[{"$f":"'Bill Preparation'!B20","v":"2024-12-01"},{"$f":"'Bill Preparation'!D20","v":"2024-12-31"},31,{"$f":"ROUND('Bill Preparation'!F20*C24/'Bill Preparation'!AN20,0)","v":0},{"$f":"ROUND('Bill Preparation'!M20*C24/'Bill Preparation'!AN20,0)","v":0},{"$f":"ROUND('Bill Preparation'!N20*C24/'Bill Preparation'!AN20,0)","v":0},{"$f":"ROUND('Bill Preparation'!O20*C24/'Bill Preparation'!AN20,0)","v":0},{"$f":"ROUND(D24*'Bill Preparation'!H20/100,0)","v":0},{"$f":"IF(ROUND(D24*'Bill Preparation'!I20/100,0)>('Bill Preparation'!I20+1)*1000,('Bill Preparation'!I20+1)*1000,ROUND(D24*'Bill Preparation'!I20/100,0))","v":0},{"$f":"ROUND(D24*'Bill Preparation'!J20/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P20*C24/'Bill Preparation'!AN20,0)","v":0},{"$f":"ROUND('Bill Preparation'!K20*C24/'Bill Preparation'!AN20,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C24>AQ24/2,AS24,0))","v":0},{"$f":"ROUND('Bill Preparation'!G20*C24/'Bill Preparation'!AN20,0)","v":0},{"$f":"ROUND('Bill Preparation'!M20*C24/'Bill Preparation'!AN20,0)","v":0},{"$f":"ROUND('Bill Preparation'!N20*C24/'Bill Preparation'!AN20,0)","v":0},{"$f":"ROUND('Bill Preparation'!O20*C24/'Bill Preparation'!AN20,0)","v":0},{"$f":"ROUND(O24*'Bill Preparation'!H20/100,0)","v":0},{"$f":"IF(ROUND(O24*'Bill Preparation'!I20/100,0)>('Bill Preparation'!I20+1)*1000,('Bill Preparation'!I20+1)*1000,ROUND(O24*'Bill Preparation'!I20/100,0))","v":0},{"$f":"ROUND(O24*'Bill Preparation'!J20/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q20*C24/'Bill Preparation'!AN20,0)","v":0},{"$f":"ROUND('Bill Preparation'!L20*C24/'Bill Preparation'!AN20,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C24>AQ24/2,AU24,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z24*'Bill Preparation'!R20%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z24+AD24)*10%,0),0)","v":0},0,0,null,12,"31",{"$f":"'Bill Preparation'!F20+'Bill Preparation'!M20+ROUND('Bill Preparation'!F20*'Bill Preparation'!H20/100,0)+ROUND('Bill Preparation'!F20*'Bill Preparation'!I20/100,0)+'Bill Preparation'!K20+'Bill Preparation'!N20+'Bill Preparation'!O20","v":0},0,{"$f":"'Bill Preparation'!G20+'Bill Preparation'!M20+ROUND('Bill Preparation'!G20*'Bill Preparation'!H20/100,0)+ROUND('Bill Preparation'!G20*'Bill Preparation'!I20/100,0)+'Bill Preparation'!L20+'Bill Preparation'!N20+'Bill Preparation'!O20","v":0},0]
[{"$f":"'Bill Preparation'!B21","v":"2025-01-01"},{"$f":"'Bill Preparation'!D21","v":"2025-01-31"},31,{"$f":"ROUND('Bill Preparation'!F21*C25/'Bill Preparation'!AN21,0)","v":0},{"$f":"ROUND('Bill Preparation'!M21*C25/'Bill Preparation'!AN21,0)","v":0},{"$f":"ROUND('Bill Preparation'!N21*C25/'Bill Preparation'!AN21,0)","v":0},{"$f":"ROUND('Bill Preparation'!O21*C25/'Bill Preparation'!AN21,0)","v":0},{"$f":"ROUND(D25*'Bill Preparation'!H21/100,0)","v":0},{"$f":"IF(ROUND(D25*'Bill Preparation'!I21/100,0)>('Bill Preparation'!I21+1)*1000,('Bill Preparation'!I21+1)*1000,ROUND(D25*'Bill Preparation'!I21/100,0))","v":0},{"$f":"ROUND(D25*'Bill Preparation'!J21/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P21*C25/'Bill Preparation'!AN21,0)","v":0},{"$f":"ROUND('Bill Preparation'!K21*C25/'Bill Preparation'!AN21,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C25>AQ25/2,AS25,0))","v":0},{"$f":"ROUND('Bill Preparation'!G21*C25/'Bill Preparation'!AN21,0)","v":0},{"$f":"ROUND('Bill Preparation'!M21*C25/'Bill Preparation'!AN21,0)","v":0},{"$f":"ROUND('Bill Preparation'!N21*C25/'Bill Preparation'!AN21,0)","v":0},{"$f":"ROUND('Bill Preparation'!O21*C25/'Bill Preparation'!AN21,0)","v":0},{"$f":"ROUND(O25*'Bill Preparation'!H21/100,0)","v":0},{"$f":"IF(ROUND(O25*'Bill Preparation'!I21/100,0)>('Bill Preparation'!I21+1)*1000,('Bill Preparation'!I21+1)*1000,ROUND(O25*'Bill Preparation'!I21/100,0))","v":0},{"$f":"ROUND(O25*'Bill Preparation'!J21/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q21*C25/'Bill Preparation'!AN21,0)","v":0},{"$f":"ROUND('Bill Preparation'!L21*C25/'Bill Preparation'!AN21,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C25>AQ25/2,AU25,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z25*'Bill Preparation'!R21%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z25+AD25)*10%,0),0)","v":0},0,0,null,1,"31",{"$f":"'Bill Preparation'!F21+'Bill Preparation'!M21+ROUND('Bill Preparation'!F21*'Bill Preparation'!H21/100,0)+ROUND('Bill Preparation'!F21*'Bill Preparation'!I21/100,0)+'Bill Preparation'!K21+'Bill Preparation'!N21+'Bill Preparation'!O21","v":0},0,{"$f":"'Bill Preparation'!G21+'Bill Preparation'!M21+ROUND('Bill Preparation'!G21*'Bill Preparation'!H21/100,0)+ROUND('Bill Preparation'!G21*'Bill Preparation'!I21/100,0)+'Bill Preparation'!L21+'Bill Preparation'!N21+'Bill Preparation'!O21","v":0},0]
[{"$f":"'Bill Preparation'!B22","v":"2025-02-01"},{"$f":"'Bill Preparation'!D22","v":"2025-02-28"},28,{"$f":"ROUND('Bill Preparation'!F22*C26/'Bill Preparation'!AN22,0)","v":0},{"$f":"ROUND('Bill Preparation'!M22*C26/'Bill Preparation'!AN22,0)","v":0},{"$f":"ROUND('Bill Preparation'!N22*C26/'Bill Preparation'!AN22,0)","v":0},{"$f":"ROUND('Bill Preparation'!O22*C26/'Bill Preparation'!AN22,0)","v":0},{"$f":"ROUND(D26*'Bill Preparation'!H22/100,0)","v":0},{"$f":"IF(ROUND(D26*'Bill Preparation'!I22/100,0)>('Bill Preparation'!I22+1)*1000,('Bill Preparation'!I22+1)*1000,ROUND(D26*'Bill Preparation'!I22/100,0))","v":0},{"$f":"ROUND(D26*'Bill Preparation'!J22/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P22*C26/'Bill Preparation'!AN22,0)","v":0},{"$f":"ROUND('Bill Preparation'!K22*C26/'Bill Preparation'!AN22,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C26>AQ26/2,AS26,0))","v":0},{"$f":"ROUND('Bill Preparation'!G22*C26/'Bill Preparation'!AN22,0)","v":0},{"$f":"ROUND('Bill Preparation'!M22*C26/'Bill Preparation'!AN22,0)","v":0},{"$f":"ROUND('Bill Preparation'!N22*C26/'Bill Preparation'!AN22,0)","v":0},{"$f":"ROUND('Bill Preparation'!O22*C26/'Bill Preparation'!AN22,0)","v":0},{"$f":"ROUND(O26*'Bill Preparation'!H22/100,0)","v":0},{"$f":"IF(ROUND(O26*'Bill Preparation'!I22/100,0)>('Bill Preparation'!I22+1)*1000,('Bill Preparation'!I22+1)*1000,ROUND(O26*'Bill Preparation'!I22/100,0))","v":0},{"$f":"ROUND(O26*'Bill Preparation'!J22/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q22*C26/'Bill Preparation'!AN22,0)","v":0},{"$f":"ROUND('Bill Preparation'!L22*C26/'Bill Preparation'!AN22,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C26>AQ26/2,AU26,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z26*'Bill Preparation'!R22%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z26+AD26)*10%,0),0)","v":0},0,0,null,2,"28",{"$f":"'Bill Preparation'!F22+'Bill Preparation'!M22+ROUND('Bill Preparation'!F22*'Bill Preparation'!H22/100,0)+ROUND('Bill Preparation'!F22*'Bill Preparation'!I22/100,0)+'Bill Preparation'!K22+'Bill Preparation'!N22+'Bill Preparation'!O22","v":0},0,{"$f":"'Bill Preparation'!G22+'Bill Preparation'!M22+ROUND('Bill Preparation'!G22*'Bill Preparation'!H22/100,0)+ROUND('Bill Preparation'!G22*'Bill Preparation'!I22/100,0)+'Bill Preparation'!L22+'Bill Preparation'!N22+'Bill Preparation'!O22","v":0},0]
[{"$f":"'Bill Preparation'!B23","v":"2025-03-01"},{"$f":"'Bill Preparation'!D23","v":"2025-03-31"},31,{"$f":"ROUND('Bill Preparation'!F23*C27/'Bill Preparation'!AN23,0)","v":0},{"$f":"ROUND('Bill Preparation'!M23*C27/'Bill Preparation'!AN23,0)","v":0},{"$f":"ROUND('Bill Preparation'!N23*C27/'Bill Preparation'!AN23,0)","v":0},{"$f":"ROUND('Bill Preparation'!O23*C27/'Bill Preparation'!AN23,0)","v":0},{"$f":"ROUND(D27*'Bill Preparation'!H23/100,0)","v":0},{"$f":"IF(ROUND(D27*'Bill Preparation'!I23/100,0)>('Bill Preparation'!I23+1)*1000,('Bill Preparation'!I23+1)*1000,ROUND(D27*'Bill Preparation'!I23/100,0))","v":0},{"$f":"ROUND(D27*'Bill Preparation'!J23/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P23*C27/'Bill Preparation'!AN23,0)","v":0},{"$f":"ROUND('Bill Preparation'!K23*C27/'Bill Preparation'!AN23,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C27>AQ27/2,AS27,0))","v":0},{"$f":"ROUND('Bill Preparation'!G23*C27/'Bill Preparation'!AN23,0)","v":0},{"$f":"ROUND('Bill Preparation'!M23*C27/'Bill Preparation'!AN23,0)","v":0},{"$f":"ROUND('Bill Preparation'!N23*C27/'Bill Preparation'!AN23,0)","v":0},{"$f":"ROUND('Bill Preparation'!O23*C27/'Bill Preparation'!AN23,0)","v":0},{"$f":"ROUND(O27*'Bill Preparation'!H23/100,0)","v":0},{"$f":"IF(ROUND(O27*'Bill Preparation'!I23/100,0)>('Bill Preparation'!I23+1)*1000,('Bill Preparation'!I23+1)*1000,ROUND(O27*'Bill Preparation'!I23/100,0))","v":0},{"$f":"ROUND(O27*'Bill Preparation'!J23/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q23*C27/'Bill Preparation'!AN23,0)","v":0},{"$f":"ROUND('Bill Preparation'!L23*C27/'Bill Preparation'!AN23,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C27>AQ27/2,AU27,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z27*'Bill Preparation'!R23%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z27+AD27)*10%,0),0)","v":0},0,0,null,3,"31",{"$f":"'Bill Preparation'!F23+'Bill Preparation'!M23+ROUND('Bill Preparation'!F23*'Bill Preparation'!H23/100,0)+ROUND('Bill Preparation'!F23*'Bill Preparation'!I23/100,0)+'Bill Preparation'!K23+'Bill Preparation'!N23+'Bill Preparation'!O23","v":0},0,{"$f":"'Bill Preparation'!G23+'Bill Preparation'!M23+ROUND('Bill Preparation'!G23*'Bill Preparation'!H23/100,0)+ROUND('Bill Preparation'!G23*'Bill Preparation'!I23/100,0)+'Bill Preparation'!L23+'Bill Preparation'!N23+'Bill Preparation'!O23","v":0},0]
[{"$f":"'Bill Preparation'!B24","v":"2025-04-01"},{"$f":"'Bill Preparation'!D24","v":"2025-04-30"},30,{"$f":"ROUND('Bill Preparation'!F24*C28/'Bill Preparation'!AN24,0)","v":0},{"$f":"ROUND('Bill Preparation'!M24*C28/'Bill Preparation'!AN24,0)","v":0},{"$f":"ROUND('Bill Preparation'!N24*C28/'Bill Preparation'!AN24,0)","v":0},{"$f":"ROUND('Bill Preparation'!O24*C28/'Bill Preparation'!AN24,0)","v":0},{"$f":"ROUND(D28*'Bill Preparation'!H24/100,0)","v":0},{"$f":"IF(ROUND(D28*'Bill Preparation'!I24/100,0)>('Bill Preparation'!I24+1)*1000,('Bill Preparation'!I24+1)*1000,ROUND(D28*'Bill Preparation'!I24/100,0))","v":0},{"$f":"ROUND(D28*'Bill Preparation'!J24/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P24*C28/'Bill Preparation'!AN24,0)","v":0},{"$f":"ROUND('Bill Preparation'!K24*C28/'Bill Preparation'!AN24,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C28>AQ28/2,AS28,0))","v":0},{"$f":"ROUND('Bill Preparation'!G24*C28/'Bill Preparation'!AN24,0)","v":0},{"$f":"ROUND('Bill Preparation'!M24*C28/'Bill Preparation'!AN24,0)","v":0},{"$f":"ROUND('Bill Preparation'!N24*C28/'Bill Preparation'!AN24,0)","v":0},{"$f":"ROUND('Bill Preparation'!O24*C28/'Bill Preparation'!AN24,0)","v":0},{"$f":"ROUND(O28*'Bill Preparation'!H24/100,0)","v":0},{"$f":"IF(ROUND(O28*'Bill Preparation'!I24/100,0)>('Bill Preparation'!I24+1)*1000,('Bill Preparation'!I24+1)*1000,ROUND(O28*'Bill Preparation'!I24/100,0))","v":0},{"$f":"ROUND(O28*'Bill Preparation'!J24/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q24*C28/'Bill Preparation'!AN24,0)","v":0},{"$f":"ROUND('Bill Preparation'!L24*C28/'Bill Preparation'!AN24,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C28>AQ28/2,AU28,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z28*'Bill Preparation'!R24%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z28+AD28)*10%,0),0)","v":0},0,0,null,4,"30",{"$f":"'Bill Preparation'!F24+'Bill Preparation'!M24+ROUND('Bill Preparation'!F24*'Bill Preparation'!H24/100,0)+ROUND('Bill Preparation'!F24*'Bill Preparation'!I24/100,0)+'Bill Preparation'!K24+'Bill Preparation'!N24+'Bill Preparation'!O24","v":0},0,{"$f":"'Bill Preparation'!G24+'Bill Preparation'!M24+ROUND('Bill Preparation'!G24*'Bill Preparation'!H24/100,0)+ROUND('Bill Preparation'!G24*'Bill Preparation'!I24/100,0)+'Bill Preparation'!L24+'Bill Preparation'!N24+'Bill Preparation'!O24","v":0},0]
[{"$f":"'Bill Preparation'!B25","v":"2025-05-01"},{"$f":"'Bill Preparation'!D25","v":"2025-05-31"},31,{"$f":"ROUND('Bill Preparation'!F25*C29/'Bill Preparation'!AN25,0)","v":0},{"$f":"ROUND('Bill Preparation'!M25*C29/'Bill Preparation'!AN25,0)","v":0},{"$f":"ROUND('Bill Preparation'!N25*C29/'Bill Preparation'!AN25,0)","v":0},{"$f":"ROUND('Bill Preparation'!O25*C29/'Bill Preparation'!AN25,0)","v":0},{"$f":"ROUND(D29*'Bill Preparation'!H25/100,0)","v":0},{"$f":"IF(ROUND(D29*'Bill Preparation'!I25/100,0)>('Bill Preparation'!I25+1)*1000,('Bill Preparation'!I25+1)*1000,ROUND(D29*'Bill Preparation'!I25/100,0))","v":0},{"$f":"ROUND(D29*'Bill Preparation'!J25/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P25*C29/'Bill Preparation'!AN25,0)","v":0},{"$f":"ROUND('Bill Preparation'!K25*C29/'Bill Preparation'!AN25,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C29>AQ29/2,AS29,0))","v":0},{"$f":"ROUND('Bill Preparation'!G25*C29/'Bill Preparation'!AN25,0)","v":0},{"$f":"ROUND('Bill Preparation'!M25*C29/'Bill Preparation'!AN25,0)","v":0},{"$f":"ROUND('Bill Preparation'!N25*C29/'Bill Preparation'!AN25,0)","v":0},{"$f":"ROUND('Bill Preparation'!O25*C29/'Bill Preparation'!AN25,0)","v":0},{"$f":"ROUND(O29*'Bill Preparation'!H25/100,0)","v":0},{"$f":"IF(ROUND(O29*'Bill Preparation'!I25/100,0)>('Bill Preparation'!I25+1)*1000,('Bill Preparation'!I25+1)*1000,ROUND(O29*'Bill Preparation'!I25/100,0))","v":0},{"$f":"ROUND(O29*'Bill Preparation'!J25/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q25*C29/'Bill Preparation'!AN25,0)","v":0},{"$f":"ROUND('Bill Preparation'!L25*C29/'Bill Preparation'!AN25,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C29>AQ29/2,AU29,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z29*'Bill Preparation'!R25%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z29+AD29)*10%,0),0)","v":0},0,0,null,5,"31",{"$f":"'Bill Preparation'!F25+'Bill Preparation'!M25+ROUND('Bill Preparation'!F25*'Bill Preparation'!H25/100,0)+ROUND('Bill Preparation'!F25*'Bill Preparation'!I25/100,0)+'Bill Preparation'!K25+'Bill Preparation'!N25+'Bill Preparation'!O25","v":0},0,{"$f":"'Bill Preparation'!G25+'Bill Preparation'!M25+ROUND('Bill Preparation'!G25*'Bill Preparation'!H25/100,0)+ROUND('Bill Preparation'!G25*'Bill Preparation'!I25/100,0)+'Bill Preparation'!L25+'Bill Preparation'!N25+'Bill Preparation'!O25","v":0},0]
[{"$f":"'Bill Preparation'!B26","v":"2025-06-01"},{"$f":"'Bill Preparation'!D26","v":"2025-06-30"},30,{"$f":"ROUND('Bill Preparation'!F26*C30/'Bill Preparation'!AN26,0)","v":0},{"$f":"ROUND('Bill Preparation'!M26*C30/'Bill Preparation'!AN26,0)","v":0},{"$f":"ROUND('Bill Preparation'!N26*C30/'Bill Preparation'!AN26,0)","v":0},{"$f":"ROUND('Bill Preparation'!O26*C30/'Bill Preparation'!AN26,0)","v":0},{"$f":"ROUND(D30*'Bill Preparation'!H26/100,0)","v":0},{"$f":"IF(ROUND(D30*'Bill Preparation'!I26/100,0)>('Bill Preparation'!I26+1)*1000,('Bill Preparation'!I26+1)*1000,ROUND(D30*'Bill Preparation'!I26/100,0))","v":0},{"$f":"ROUND(D30*'Bill Preparation'!J26/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P26*C30/'Bill Preparation'!AN26,0)","v":0},{"$f":"ROUND('Bill Preparation'!K26*C30/'Bill Preparation'!AN26,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C30>AQ30/2,AS30,0))","v":0},{"$f":"ROUND('Bill Preparation'!G26*C30/'Bill Preparation'!AN26,0)","v":0},{"$f":"ROUND('Bill Preparation'!M26*C30/'Bill Preparation'!AN26,0)","v":0},{"$f":"ROUND('Bill Preparation'!N26*C30/'Bill Preparation'!AN26,0)","v":0},{"$f":"ROUND('Bill Preparation'!O26*C30/'Bill Preparation'!AN26,0)","v":0},{"$f":"ROUND(O30*'Bill Preparation'!H26/100,0)","v":0},{"$f":"IF(ROUND(O30*'Bill Preparation'!I26/100,0)>('Bill Preparation'!I26+1)*1000,('Bill Preparation'!I26+1)*1000,ROUND(O30*'Bill Preparation'!I26/100,0))","v":0},{"$f":"ROUND(O30*'Bill Preparation'!J26/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q26*C30/'Bill Preparation'!AN26,0)","v":0},{"$f":"ROUND('Bill Preparation'!L26*C30/'Bill Preparation'!AN26,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C30>AQ30/2,AU30,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z30*'Bill Preparation'!R26%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z30+AD30)*10%,0),0)","v":0},0,0,null,6,"30",{"$f":"'Bill Preparation'!F26+'Bill Preparation'!M26+ROUND('Bill Preparation'!F26*'Bill Preparation'!H26/100,0)+ROUND('Bill Preparation'!F26*'Bill Preparation'!I26/100,0)+'Bill Preparation'!K26+'Bill Preparation'!N26+'Bill Preparation'!O26","v":0},0,{"$f":"'Bill Preparation'!G26+'Bill Preparation'!M26+ROUND('Bill Preparation'!G26*'Bill Preparation'!H26/100,0)+ROUND('Bill Preparation'!G26*'Bill Preparation'!I26/100,0)+'Bill Preparation'!L26+'Bill Preparation'!N26+'Bill Preparation'!O26","v":0},0]
[{"$f":"'Bill Preparation'!B27","v":"2025-07-01"},{"$f":"'Bill Preparation'!D27","v":"2025-07-31"},31,{"$f":"ROUND('Bill Preparation'!F27*C31/'Bill Preparation'!AN27,0)","v":0},{"$f":"ROUND('Bill Preparation'!M27*C31/'Bill Preparation'!AN27,0)","v":0},{"$f":"ROUND('Bill Preparation'!N27*C31/'Bill Preparation'!AN27,0)","v":0},{"$f":"ROUND('Bill Preparation'!O27*C31/'Bill Preparation'!AN27,0)","v":0},{"$f":"ROUND(D31*'Bill Preparation'!H27/100,0)","v":0},{"$f":"IF(ROUND(D31*'Bill Preparation'!I27/100,0)>('Bill Preparation'!I27+1)*1000,('Bill Preparation'!I27+1)*1000,ROUND(D31*'Bill Preparation'!I27/100,0))","v":0},{"$f":"ROUND(D31*'Bill Preparation'!J27/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P27*C31/'Bill Preparation'!AN27,0)","v":0},{"$f":"ROUND('Bill Preparation'!K27*C31/'Bill Preparation'!AN27,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C31>AQ31/2,AS31,0))","v":0},{"$f":"ROUND('Bill Preparation'!G27*C31/'Bill Preparation'!AN27,0)","v":0},{"$f":"ROUND('Bill Preparation'!M27*C31/'Bill Preparation'!AN27,0)","v":0},{"$f":"ROUND('Bill Preparation'!N27*C31/'Bill Preparation'!AN27,0)","v":0},{"$f":"ROUND('Bill Preparation'!O27*C31/'Bill Preparation'!AN27,0)","v":0},{"$f":"ROUND(O31*'Bill Preparation'!H27/100,0)","v":0},{"$f":"IF(ROUND(O31*'Bill Preparation'!I27/100,0)>('Bill Preparation'!I27+1)*1000,('Bill Preparation'!I27+1)*1000,ROUND(O31*'Bill Preparation'!I27/100,0))","v":0},{"$f":"ROUND(O31*'Bill Preparation'!J27/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q27*C31/'Bill Preparation'!AN27,0)","v":0},{"$f":"ROUND('Bill Preparation'!L27*C31/'Bill Preparation'!AN27,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C31>AQ31/2,AU31,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z31*'Bill Preparation'!R27%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z31+AD31)*10%,0),0)","v":0},0,0,null,7,"31",{"$f":"'Bill Preparation'!F27+'Bill Preparation'!M27+ROUND('Bill Preparation'!F27*'Bill Preparation'!H27/100,0)+ROUND('Bill Preparation'!F27*'Bill Preparation'!I27/100,0)+'Bill Preparation'!K27+'Bill Preparation'!N27+'Bill Preparation'!O27","v":0},0,{"$f":"'Bill Preparation'!G27+'Bill Preparation'!M27+ROUND('Bill Preparation'!G27*'Bill Preparation'!H27/100,0)+ROUND('Bill Preparation'!G27*'Bill Preparation'!I27/100,0)+'Bill Preparation'!L27+'Bill Preparation'!N27+'Bill Preparation'!O27","v":0},0]
[{"$f":"'Bill Preparation'!B28","v":"2025-08-01"},{"$f":"'Bill Preparation'!D28","v":"2025-08-31"},31,{"$f":"ROUND('Bill Preparation'!F28*C32/'Bill Preparation'!AN28,0)","v":0},{"$f":"ROUND('Bill Preparation'!M28*C32/'Bill Preparation'!AN28,0)","v":0},{"$f":"ROUND('Bill Preparation'!N28*C32/'Bill Preparation'!AN28,0)","v":0},{"$f":"ROUND('Bill Preparation'!O28*C32/'Bill Preparation'!AN28,0)","v":0},{"$f":"ROUND(D32*'Bill Preparation'!H28/100,0)","v":0},{"$f":"IF(ROUND(D32*'Bill Preparation'!I28/100,0)>('Bill Preparation'!I28+1)*1000,('Bill Preparation'!I28+1)*1000,ROUND(D32*'Bill Preparation'!I28/100,0))","v":0},{"$f":"ROUND(D32*'Bill Preparation'!J28/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P28*C32/'Bill Preparation'!AN28,0)","v":0},{"$f":"ROUND('Bill Preparation'!K28*C32/'Bill Preparation'!AN28,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C32>AQ32/2,AS32,0))","v":0},{"$f":"ROUND('Bill Preparation'!G28*C32/'Bill Preparation'!AN28,0)","v":0},{"$f":"ROUND('Bill Preparation'!M28*C32/'Bill Preparation'!AN28,0)","v":0},{"$f":"ROUND('Bill Preparation'!N28*C32/'Bill Preparation'!AN28,0)","v":0},{"$f":"ROUND('Bill Preparation'!O28*C32/'Bill Preparation'!AN28,0)","v":0},{"$f":"ROUND(O32*'Bill Preparation'!H28/100,0)","v":0},{"$f":"IF(ROUND(O32*'Bill Preparation'!I28/100,0)>('Bill Preparation'!I28+1)*1000,('Bill Preparation'!I28+1)*1000,ROUND(O32*'Bill Preparation'!I28/100,0))","v":0},{"$f":"ROUND(O32*'Bill Preparation'!J28/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q28*C32/'Bill Preparation'!AN28,0)","v":0},{"$f":"ROUND('Bill Preparation'!L28*C32/'Bill Preparation'!AN28,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C32>AQ32/2,AU32,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z32*'Bill Preparation'!R28%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z32+AD32)*10%,0),0)","v":0},0,0,null,8,"31",{"$f":"'Bill Preparation'!F28+'Bill Preparation'!M28+ROUND('Bill Preparation'!F28*'Bill Preparation'!H28/100,0)+ROUND('Bill Preparation'!F28*'Bill Preparation'!I28/100,0)+'Bill Preparation'!K28+'Bill Preparation'!N28+'Bill Preparation'!O28","v":0},0,{"$f":"'Bill Preparation'!G28+'Bill Preparation'!M28+ROUND('Bill Preparation'!G28*'Bill Preparation'!H28/100,0)+ROUND('Bill Preparation'!G28*'Bill Preparation'!I28/100,0)+'Bill Preparation'!L28+'Bill Preparation'!N28+'Bill Preparation'!O28","v":0},0]
[{"$f":"'Bill Preparation'!B29","v":"2025-09-01"},{"$f":"'Bill Preparation'!D29","v":"2025-09-30"},30,{"$f":"ROUND('Bill Preparation'!F29*C33/'Bill Preparation'!AN29,0)","v":0},{"$f":"ROUND('Bill Preparation'!M29*C33/'Bill Preparation'!AN29,0)","v":0},{"$f":"ROUND('Bill Preparation'!N29*C33/'Bill Preparation'!AN29,0)","v":0},{"$f":"ROUND('Bill Preparation'!O29*C33/'Bill Preparation'!AN29,0)","v":0},{"$f":"ROUND(D33*'Bill Preparation'!H29/100,0)","v":0},{"$f":"IF(ROUND(D33*'Bill Preparation'!I29/100,0)>('Bill Preparation'!I29+1)*1000,('Bill Preparation'!I29+1)*1000,ROUND(D33*'Bill Preparation'!I29/100,0))","v":0},{"$f":"ROUND(D33*'Bill Preparation'!J29/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P29*C33/'Bill Preparation'!AN29,0)","v":0},{"$f":"ROUND('Bill Preparation'!K29*C33/'Bill Preparation'!AN29,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C33>AQ33/2,AS33,0))","v":0},{"$f":"ROUND('Bill Preparation'!G29*C33/'Bill Preparation'!AN29,0)","v":0},{"$f":"ROUND('Bill Preparation'!M29*C33/'Bill Preparation'!AN29,0)","v":0},{"$f":"ROUND('Bill Preparation'!N29*C33/'Bill Preparation'!AN29,0)","v":0},{"$f":"ROUND('Bill Preparation'!O29*C33/'Bill Preparation'!AN29,0)","v":0},{"$f":"ROUND(O33*'Bill Preparation'!H29/100,0)","v":0},{"$f":"IF(ROUND(O33*'Bill Preparation'!I29/100,0)>('Bill Preparation'!I29+1)*1000,('Bill Preparation'!I29+1)*1000,ROUND(O33*'Bill Preparation'!I29/100,0))","v":0},{"$f":"ROUND(O33*'Bill Preparation'!J29/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q29*C33/'Bill Preparation'!AN29,0)","v":0},{"$f":"ROUND('Bill Preparation'!L29*C33/'Bill Preparation'!AN29,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C33>AQ33/2,AU33,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z33*'Bill Preparation'!R29%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z33+AD33)*10%,0),0)","v":0},0,0,null,9,"30",{"$f":"'Bill Preparation'!F29+'Bill Preparation'!M29+ROUND('Bill Preparation'!F29*'Bill Preparation'!H29/100,0)+ROUND('Bill Preparation'!F29*'Bill Preparation'!I29/100,0)+'Bill Preparation'!K29+'Bill Preparation'!N29+'Bill Preparation'!O29","v":0},0,{"$f":"'Bill Preparation'!G29+'Bill Preparation'!M29+ROUND('Bill Preparation'!G29*'Bill Preparation'!H29/100,0)+ROUND('Bill Preparation'!G29*'Bill Preparation'!I29/100,0)+'Bill Preparation'!L29+'Bill Preparation'!N29+'Bill Preparation'!O29","v":0},0]
[{"$f":"'Bill Preparation'!B30","v":"2025-10-01"},{"$f":"'Bill Preparation'!D30","v":"2025-10-31"},31,{"$f":"ROUND('Bill Preparation'!F30*C34/'Bill Preparation'!AN30,0)","v":0},{"$f":"ROUND('Bill Preparation'!M30*C34/'Bill Preparation'!AN30,0)","v":0},{"$f":"ROUND('Bill Preparation'!N30*C34/'Bill Preparation'!AN30,0)","v":0},{"$f":"ROUND('Bill Preparation'!O30*C34/'Bill Preparation'!AN30,0)","v":0},{"$f":"ROUND(D34*'Bill Preparation'!H30/100,0)","v":0},{"$f":"IF(ROUND(D34*'Bill Preparation'!I30/100,0)>('Bill Preparation'!I30+1)*1000,('Bill Preparation'!I30+1)*1000,ROUND(D34*'Bill Preparation'!I30/100,0))","v":0},{"$f":"ROUND(D34*'Bill Preparation'!J30/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P30*C34/'Bill Preparation'!AN30,0)","v":0},{"$f":"ROUND('Bill Preparation'!K30*C34/'Bill Preparation'!AN30,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C34>AQ34/2,AS34,0))","v":0},{"$f":"ROUND('Bill Preparation'!G30*C34/'Bill Preparation'!AN30,0)","v":0},{"$f":"ROUND('Bill Preparation'!M30*C34/'Bill Preparation'!AN30,0)","v":0},{"$f":"ROUND('Bill Preparation'!N30*C34/'Bill Preparation'!AN30,0)","v":0},{"$f":"ROUND('Bill Preparation'!O30*C34/'Bill Preparation'!AN30,0)","v":0},{"$f":"ROUND(O34*'Bill Preparation'!H30/100,0)","v":0},{"$f":"IF(ROUND(O34*'Bill Preparation'!I30/100,0)>('Bill Preparation'!I30+1)*1000,('Bill Preparation'!I30+1)*1000,ROUND(O34*'Bill Preparation'!I30/100,0))","v":0},{"$f":"ROUND(O34*'Bill Preparation'!J30/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q30*C34/'Bill Preparation'!AN30,0)","v":0},{"$f":"ROUND('Bill Preparation'!L30*C34/'Bill Preparation'!AN30,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C34>AQ34/2,AU34,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z34*'Bill Preparation'!R30%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z34+AD34)*10%,0),0)","v":0},0,0,null,10,"31",{"$f":"'Bill Preparation'!F30+'Bill Preparation'!M30+ROUND('Bill Preparation'!F30*'Bill Preparation'!H30/100,0)+ROUND('Bill Preparation'!F30*'Bill Preparation'!I30/100,0)+'Bill Preparation'!K30+'Bill Preparation'!N30+'Bill Preparation'!O30","v":0},0,{"$f":"'Bill Preparation'!G30+'Bill Preparation'!M30+ROUND('Bill Preparation'!G30*'Bill Preparation'!H30/100,0)+ROUND('Bill Preparation'!G30*'Bill Preparation'!I30/100,0)+'Bill Preparation'!L30+'Bill Preparation'!N30+'Bill Preparation'!O30","v":0},0]
[{"$f":"'Bill Preparation'!B31","v":"2025-11-01"},{"$f":"'Bill Preparation'!D31","v":"2025-11-30"},30,{"$f":"ROUND('Bill Preparation'!F31*C35/'Bill Preparation'!AN31,0)","v":0},{"$f":"ROUND('Bill Preparation'!M31*C35/'Bill Preparation'!AN31,0)","v":0},{"$f":"ROUND('Bill Preparation'!N31*C35/'Bill Preparation'!AN31,0)","v":0},{"$f":"ROUND('Bill Preparation'!O31*C35/'Bill Preparation'!AN31,0)","v":0},{"$f":"ROUND(D35*'Bill Preparation'!H31/100,0)","v":0},{"$f":"IF(ROUND(D35*'Bill Preparation'!I31/100,0)>('Bill Preparation'!I31+1)*1000,('Bill Preparation'!I31+1)*1000,ROUND(D35*'Bill Preparation'!I31/100,0))","v":0},{"$f":"ROUND(D35*'Bill Preparation'!J31/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P31*C35/'Bill Preparation'!AN31,0)","v":0},{"$f":"ROUND('Bill Preparation'!K31*C35/'Bill Preparation'!AN31,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C35>AQ35/2,AS35,0))","v":0},{"$f":"ROUND('Bill Preparation'!G31*C35/'Bill Preparation'!AN31,0)","v":0},{"$f":"ROUND('Bill Preparation'!M31*C35/'Bill Preparation'!AN31,0)","v":0},{"$f":"ROUND('Bill Preparation'!N31*C35/'Bill Preparation'!AN31,0)","v":0},{"$f":"ROUND('Bill Preparation'!O31*C35/'Bill Preparation'!AN31,0)","v":0},{"$f":"ROUND(O35*'Bill Preparation'!H31/100,0)","v":0},{"$f":"IF(ROUND(O35*'Bill Preparation'!I31/100,0)>('Bill Preparation'!I31+1)*1000,('Bill Preparation'!I31+1)*1000,ROUND(O35*'Bill Preparation'!I31/100,0))","v":0},{"$f":"ROUND(O35*'Bill Preparation'!J31/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q31*C35/'Bill Preparation'!AN31,0)","v":0},{"$f":"ROUND('Bill Preparation'!L31*C35/'Bill Preparation'!AN31,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C35>AQ35/2,AU35,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z35*'Bill Preparation'!R31%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z35+AD35)*10%,0),0)","v":0},0,0,null,11,"30",{"$f":"'Bill Preparation'!F31+'Bill Preparation'!M31+ROUND('Bill Preparation'!F31*'Bill Preparation'!H31/100,0)+ROUND('Bill Preparation'!F31*'Bill Preparation'!I31/100,0)+'Bill Preparation'!K31+'Bill Preparation'!N31+'Bill Preparation'!O31","v":0},0,{"$f":"'Bill Preparation'!G31+'Bill Preparation'!M31+ROUND('Bill Preparation'!G31*'Bill Preparation'!H31/100,0)+ROUND('Bill Preparation'!G31*'Bill Preparation'!I31/100,0)+'Bill Preparation'!L31+'Bill Preparation'!N31+'Bill Preparation'!O31","v":0},0]
[{"$f":"'Bill Preparation'!B32","v":"2025-12-01"},{"$f":"'Bill Preparation'!D32","v":"2025-12-31"},31,{"$f":"ROUND('Bill Preparation'!F32*C36/'Bill Preparation'!AO32,0)","v":0},{"$f":"ROUND('Bill Preparation'!M32*C36/'Bill Preparation'!AO32,0)","v":0},{"$f":"ROUND('Bill Preparation'!N32*C36/'Bill Preparation'!AO32,0)","v":0},{"$f":"ROUND('Bill Preparation'!O32*C36/'Bill Preparation'!AO32,0)","v":0},{"$f":"ROUND(D36*'Bill Preparation'!H32/100,0)","v":0},{"$f":"IF(ROUND(D36*'Bill Preparation'!I32/100,0)>('Bill Preparation'!I32+1)*1000,('Bill Preparation'!I32+1)*1000,ROUND(D36*'Bill Preparation'!I32/100,0))","v":0},{"$f":"ROUND(D36*'Bill Preparation'!J32/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P32*C36/'Bill Preparation'!AN32,0)","v":0},{"$f":"ROUND('Bill Preparation'!K32*C36/'Bill Preparation'!AO32,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C36>AQ36/2,AS36,0))","v":0},{"$f":"ROUND('Bill Preparation'!G32*C36/'Bill Preparation'!AO32,0)","v":0},{"$f":"ROUND('Bill Preparation'!M32*C36/'Bill Preparation'!AO32,0)","v":0},{"$f":"ROUND('Bill Preparation'!N32*C36/'Bill Preparation'!AO32,0)","v":0},{"$f":"ROUND('Bill Preparation'!O32*C36/'Bill Preparation'!AO32,0)","v":0},{"$f":"ROUND(O36*'Bill Preparation'!H32/100,0)","v":0},{"$f":"IF(ROUND(O36*'Bill Preparation'!I32/100,0)>('Bill Preparation'!I32+1)*1000,('Bill Preparation'!I32+1)*1000,ROUND(O36*'Bill Preparation'!I32/100,0))","v":0},{"$f":"ROUND(O36*'Bill Preparation'!J32/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q32*C36/'Bill Preparation'!AN32,0)","v":0},{"$f":"ROUND('Bill Preparation'!L32*C36/'Bill Preparation'!AO32,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C36>AQ36/2,AU36,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z36*'Bill Preparation'!R32%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z36+AD36)*10%,0),0)","v":0},0,0,null,12,"31",{"$f":"'Bill Preparation'!F32+'Bill Preparation'!M32+ROUND('Bill Preparation'!F32*'Bill Preparation'!H32/100,0)+ROUND('Bill Preparation'!F32*'Bill Preparation'!I32/100,0)+'Bill Preparation'!K32+'Bill Preparation'!N32+'Bill Preparation'!O32","v":0},0,{"$f":"'Bill Preparation'!G32+'Bill Preparation'!M32+ROUND('Bill Preparation'!G32*'Bill Preparation'!H32/100,0)+ROUND('Bill Preparation'!G32*'Bill Preparation'!I32/100,0)+'Bill Preparation'!L32+'Bill Preparation'!N32+'Bill Preparation'!O32","v":0},0]
[{"$f":"'Bill Preparation'!B33","v":"2026-01-01"},{"$f":"'Bill Preparation'!D33","v":"2026-01-31"},31,{"$f":"ROUND('Bill Preparation'!F33*C37/'Bill Preparation'!AO33,0)","v":0},{"$f":"ROUND('Bill Preparation'!M33*C37/'Bill Preparation'!AO33,0)","v":0},{"$f":"ROUND('Bill Preparation'!N33*C37/'Bill Preparation'!AO33,0)","v":0},{"$f":"ROUND('Bill Preparation'!O33*C37/'Bill Preparation'!AO33,0)","v":0},{"$f":"ROUND(D37*'Bill Preparation'!H33/100,0)","v":0},{"$f":"IF(ROUND(D37*'Bill Preparation'!I33/100,0)>('Bill Preparation'!I33+1)*1000,('Bill Preparation'!I33+1)*1000,ROUND(D37*'Bill Preparation'!I33/100,0))","v":0},{"$f":"ROUND(D37*'Bill Preparation'!J33/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P33*C37/'Bill Preparation'!AN33,0)","v":0},{"$f":"ROUND('Bill Preparation'!K33*C37/'Bill Preparation'!AO33,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C37>AQ37/2,AS37,0))","v":0},{"$f":"ROUND('Bill Preparation'!G33*C37/'Bill Preparation'!AO33,0)","v":0},{"$f":"ROUND('Bill Preparation'!M33*C37/'Bill Preparation'!AO33,0)","v":0},{"$f":"ROUND('Bill Preparation'!N33*C37/'Bill Preparation'!AO33,0)","v":0},{"$f":"ROUND('Bill Preparation'!O33*C37/'Bill Preparation'!AO33,0)","v":0},{"$f":"ROUND(O37*'Bill Preparation'!H33/100,0)","v":0},{"$f":"IF(ROUND(O37*'Bill Preparation'!I33/100,0)>('Bill Preparation'!I33+1)*1000,('Bill Preparation'!I33+1)*1000,ROUND(O37*'Bill Preparation'!I33/100,0))","v":0},{"$f":"ROUND(O37*'Bill Preparation'!J33/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q33*C37/'Bill Preparation'!AN33,0)","v":0},{"$f":"ROUND('Bill Preparation'!L33*C37/'Bill Preparation'!AO33,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C37>AQ37/2,AU37,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z37*'Bill Preparation'!R33%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z37+AD37)*10%,0),0)","v":0},0,0,null,1,"31",{"$f":"'Bill Preparation'!F33+'Bill Preparation'!M33+ROUND('Bill Preparation'!F33*'Bill Preparation'!H33/100,0)+ROUND('Bill Preparation'!F33*'Bill Preparation'!I33/100,0)+'Bill Preparation'!K33+'Bill Preparation'!N33+'Bill Preparation'!O33","v":0},0,{"$f":"'Bill Preparation'!G33+'Bill Preparation'!M33+ROUND('Bill Preparation'!G33*'Bill Preparation'!H33/100,0)+ROUND('Bill Preparation'!G33*'Bill Preparation'!I33/100,0)+'Bill Preparation'!L33+'Bill Preparation'!N33+'Bill Preparation'!O33","v":0},0]
[{"$f":"'Bill Preparation'!B34","v":"2026-02-01"},{"$f":"'Bill Preparation'!D34","v":"2026-02-28"},28,{"$f":"ROUND('Bill Preparation'!F34*C38/'Bill Preparation'!AO34,0)","v":0},{"$f":"ROUND('Bill Preparation'!M34*C38/'Bill Preparation'!AO34,0)","v":0},{"$f":"ROUND('Bill Preparation'!N34*C38/'Bill Preparation'!AO34,0)","v":0},{"$f":"ROUND('Bill Preparation'!O34*C38/'Bill Preparation'!AO34,0)","v":0},{"$f":"ROUND(D38*'Bill Preparation'!H34/100,0)","v":0},{"$f":"IF(ROUND(D38*'Bill Preparation'!I34/100,0)>('Bill Preparation'!I34+1)*1000,('Bill Preparation'!I34+1)*1000,ROUND(D38*'Bill Preparation'!I34/100,0))","v":0},{"$f":"ROUND(D38*'Bill Preparation'!J34/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!P34*C38/'Bill Preparation'!AN34,0)","v":0},{"$f":"ROUND('Bill Preparation'!K34*C38/'Bill Preparation'!AO34,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C38>AQ38/2,AS38,0))","v":0},{"$f":"ROUND('Bill Preparation'!G34*C38/'Bill Preparation'!AO34,0)","v":0},{"$f":"ROUND('Bill Preparation'!M34*C38/'Bill Preparation'!AO34,0)","v":0},{"$f":"ROUND('Bill Preparation'!N34*C38/'Bill Preparation'!AO34,0)","v":0},{"$f":"ROUND('Bill Preparation'!O34*C38/'Bill Preparation'!AO34,0)","v":0},{"$f":"ROUND(O38*'Bill Preparation'!H34/100,0)","v":0},{"$f":"IF(ROUND(O38*'Bill Preparation'!I34/100,0)>('Bill Preparation'!I34+1)*1000,('Bill Preparation'!I34+1)*1000,ROUND(O38*'Bill Preparation'!I34/100,0))","v":0},{"$f":"ROUND(O38*'Bill Preparation'!J34/100,0)","v":0},{"$f":"ROUND('Bill Preparation'!Q34*C38/'Bill Preparation'!AN34,0)","v":0},{"$f":"ROUND('Bill Preparation'!L34*C38/'Bill Preparation'!AO34,0)","v":0},0,{"$f":"IF([1]Data!$B$32=\"Yes\",0,IF(C38>AQ38/2,AU38,0))","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Data!$D$3=\"CPS\",0,ROUND(Z38*'Bill Preparation'!R34%,0))","v":0},0,{"$f":"IF(Data!$D$3=\"CPS\",ROUND((Z38+AD38)*10%,0),0)","v":0},0,0,null,2,"28",{"$f":"'Bill Preparation'!F34+'Bill Preparation'!M34+ROUND('Bill Preparation'!F34*'Bill Preparation'!H34/100,0)+ROUND('Bill Preparation'!F34*'Bill Preparation'!I34/100,0)+'Bill Preparation'!K34+'Bill Preparation'!N34+'Bill Preparation'!O34","v":0},0,{"$f":"'Bill Preparation'!G34+'Bill Preparation'!M34+ROUND('Bill Preparation'!G34*'Bill Preparation'!H34/100,0)+ROUND('Bill Preparation'!G34*'Bill Preparation'!I34/100,0)+'Bill Preparation'!L34+'Bill Preparation'!N34+'Bill Preparation'!O34","v":0},0]
[]
[]
[]
["Total Cash and Adjustment",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":"SUM(Z7:Z41)","v":26748},0,0,0,6086,2674,0,0,0,35508,0,0,3283,3283,32225]

{"sheet":"aptc 49","index":4,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[10,1,10,13],[12,9,12,12],[9,1,9,13],[7,1,8,1],[7,2,8,2],[7,3,8,3],[4,13,5,13],[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,4,6],[4,7,4,8],[4,9,5,9],[4,10,5,10],[4,11,5,11],[4,12,5,12]]}
["A.P.T.C.FORM – 49"]
["PERIODICAL INCREMENT CERTIFICATE"]
["ANNEXURE"]
["        (1) Certified that every Government Servant(s) named below has have earned the prescribed periodical increment from date/dates noted in column 10 and either 1 (a) has / have been the incumbent or the appointment indicated against his name / their names for a period not less than ………..year since the date in column 5 or (if he has /they have been suspended for misconduct) column 7 after deducting the periods between the dates shown in column (8) and has (9) and has been subjected in any order of stop page of increment as penalty during the periods, and during the periods of leave on average pay taken at a time and from ………………………..which has / have been conducted for increment / in the case of officiating Government Servant / Servants named below the / they would have officiated in the post/ posts but for his / their going on leave or ……………………."]
["Sl.No.","Name","Appointment","Whether Substantive \nor Officiating","Date from which \npresent pay as drawn","Suspension for\n Misconduct",null,"Leave without pay and in the case of these holding the post  temporarily or in an officiating capacity all kinds of leave other than leave on average pay ",null,"Date from which increment may be given","Scale","Present Pay","Amount of increment","Future Pay"]
[null,null,null,null,null,"From","to","From","to"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14]
[1,{"$f":"Data!B2","v":"Smt Shaik ASHITUN (CFMS ID15087189)"},{"$f":"Data!D4","v":" SCHOOL ASST(Phy Ed)"},"Substantive"]
[]
["Note:","1.  When and increment claimed operates to carry Government Servant over an efficiency have the claim should be supported by a declaration from the     competent authority that it has  satisfied it self that the character and efficiency of the government Servant concerned are such that he is fit to pass the above columns 5 and 10 to 14 should be filled up in red ink"]
["2.      The terms leave on average pay up to a maximum 4 months wherever occurring from includes earned leave upto a maximum of 100 days or 50 days or 30 days the case may be far as","2.  The terms leave on average pay upto a maximum 4 months wherever occuring from includes earned leave upto a maximum of 100 days or 50 days or 30 days the case may be far as government Servants governed by the Andhra Pradesh Leave rules 1988 are concerned."]
[]
[null,null,null,null,null,null,null,null,null,"Signature and Designation of Drawing Officer"]