{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Form","Database","Sheet2","DCB","MONTH WISE TAX DETAILS","MONTH WISE NON TAX DETAILS (2)","mONTH wISE dCB"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":14,"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":"Form","index":0,"n_rows":28,"n_cols":22,"rows_kept":28,"cut":false,"hidden":false,"merged":[[5,7,7,10],[2,1,2,10],[3,1,3,2],[4,1,4,10],[23,2,23,4],[21,2,21,4],[11,2,12,3],[13,2,14,3],[15,2,16,3],[17,2,18,3],[19,2,20,3],[22,2,22,4],[5,1,5,3],[18,8,18,10],[19,8,19,10],[20,8,20,10],[24,2,24,4],[9,2,10,3],[26,16,26,18],[5,16,5,18],[3,16,3,18],[3,7,3,11],[21,17,24,18],[9,8,9,10],[10,8,10,10],[11,8,11,10],[12,8,12,10],[13,8,13,10],[14,8,14,10],[15,8,15,10],[16,8,16,10],[17,8,17,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TAX",null,null,"Name: Designation: Working Place:  Dist:                 Cell No.                 GMAIL.","Gummula Mallesham                                       Panchayath Secretary                                  GP.Datnur MPP Gollaplli                                 JAGTIAL                                                  9491561942                                        mallikvlg@gmail.com"]
[null,"DCB FORM Entry",null,null,null,null,null,null,null,null,null,null,null,"NONTAX",null,null,null,null,null,null,"April",5]
[null,"Gramapanchayat",null,"Datnur","mpp","Gollapalli",null,"Dist",null,null,null,null,null,"MONTHS",3,null,"Jagtial",null,null,null,"May",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"APRIL",null,null,null,null,null,null,"June"]
[null,"MONTH & ",null,null,"YEAR",null,{"$f":"ISBLANK(F6)","v":true},"show entred months  \"0 \" means NO DATA",null,null,null,null,null,"MAY",null,null,"2020-21",null,null,null,"July"]
[null,null,null,null,"MONTH ",null,{"$f":"ISBLANK(#REF!)","v":false},null,null,null,null,null,null,"JULY",null,null,"particulars","Arrears demand","Current Demand",null,"August"]
[null,null,null,null,"Particulars",null,null,null,null,null,null,null,null,"SEPTEMBER",null,null,"House Tax",0,11849,null,"September"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"OCTOBER",null,null,null,0,null,null,"October"]
[null,null,"HOUSE TAX",null,"ARREARS",null,{"$f":"ISBLANK(F10)","v":true},null,{"$f":"Database!B2","v":"April"},null,null,null,null,"NOVEMBER",null,null,"Library cess",0,948,null,"November"]
[null,null,null,null,"CURRENT",null,true,null,{"$f":"Database!B3","v":"May"},null,null,null,null,"DECEMBER",null,null,null,null,null,null,"December"]
[null,null,"Libaray cess    ",null,"ARREARS",null,true,null,{"$f":"Database!B4","v":"June"},null,null,null,null,"JANUARY",null,null,"Water Tax",0,1185,null,"January"]
[null,null,null,null,"CURRENT",null,true,null,{"$f":"Database!B5","v":"July"},null,null,null,null,"FEBRUARY",null,null,null,null,null,null,"February"]
[null,null,"WATER TAX ",null,"ARREARS",null,true,null,{"$f":"Database!B6","v":"August"},null,null,null,null,"MARCH",null,null," Light Tax",0,1185,null,"March"]
[null,null,null,null,"CURRENT",null,true,null,{"$f":"Database!B7","v":0},null,null,null,null,"YEAR",4,null,null,null,null,null,2020,1]
[null,null,"LIGHT TAX  ",null,"ARREARS",null,true,null,{"$f":"Database!B8","v":0},null,null,null,null,2020,null,null,"Drainage Tax",0,1185,null,2021]
[null,null,null,null,"CURRENT",null,true,null,{"$f":"Database!B9","v":0},null,null,null,null,2021,null,null,null,null,null,null,2022]
[null,null,"DRAINAGE TAX",null,"ARREARS",null,true,null,{"$f":"Database!B10","v":0},null,null,null,null,2022,null,null,"Tap Fee",0,22320,null,2023]
[null,null,null,null,"CURRENT",null,true,null,{"$f":"Database!B11","v":0},null,null,null,null,2023,null,null,null,null,null,null,2024]
[null,null,"TAP FEE            ",null,"ARREARS",null,true,null,{"$f":"Database!B12","v":0},null,null,null,null,2024,null,null,null,null,null,null,2025]
[null,null,null,null,"CURRENT",null,true,null,{"$f":"Database!B13","v":0},null,null,null,null,2025,null,null,null,null,null,null,2026]
[null,null,"ACTIONS",null,null,null,true,null,null,null,null,null,null,2026,null,null,null,"SELECT MONTH & CLICK                           DCB FOR MONTH",null,null,2027]
[null,null,"TAP Donation",null,null,null,true,null,null,null,null,null,null,2027,null,null,null,null,null,null,2028]
[null,null,"    PENALITIES",null,null,null,true,null,null,null,null,null,null,2028,null,null,null,null,null,null,2029]
[0,null,"Other",null,null,null,true,null,null,null,null,null,null,null,null,null,null,null,null,null,2030]
[null,null,null,null,null,null,true,null,null,null,null,null,null,2029]
[null,null,null,null,null,null,true,null,null,null,null,null,null,2030,null,null,"IF YOUR SATISFIED TELL OTHERS               IF YOUR NOT SATISFIED TELL US"]
[null,"http://www.mallikvlg.yolasite.com/",null,null,null,1,false]

{"sheet":"Database","index":1,"n_rows":6,"n_cols":21,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["S.no","MONTH","YEAR","HOUSE TAX ARREARS","HOUSE TAX CURRENT","LIBRARYCESS ARREARS","LIBRARYCESS CURRENT","LIGHTING  TAX ARREARS","LIGHTING TAX CURRENT","WATER  TAX ARREARS","WATER TAX CURRENT","DRAINAGE  TAX ARREARS","DRAINAGE TAX CURRENT","TAP FEE ARREARS","TAP FEE current","Actions ","Tap Donation","Others/penalties","Others","SUBMITED BY","SUBMITED ON"]
[1,"April",2020,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2020-03-09T16:40:29"]
[2,"May",2020,0,3502,0,280,0,350,0,350,0,350,0,1300,0,0,1000,0,"2020-03-09T16:16:10"]
[3,"June",2020,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"2020-03-09T16:12:00"]
[4,"July",2020,0,1086,0,87,0,109,0,109,0,109,0,0,0,0,0,0,"2020-03-09T16:21:57"]
[5,"August",2020,0,2460,0,197,0,246,0,246,0,246,0,2500,0,0,0,0,"2020-03-09T16:28:16"]

{"sheet":"Sheet2","index":2,"n_rows":15,"n_cols":44,"rows_kept":15,"cut":false,"hidden":true,"merged":[[0,40,0,43],[1,40,2,41],[1,42,2,43],[15,0,15,44],[0,35,14,35],[0,44,14,44],[0,3,0,18],[0,19,0,34],[1,36,2,37],[1,38,2,39],[0,36,0,39]]}
[null,null,null,"PRIVIOUS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CURRENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TAX",null,null,null,"NON TAX"]
["S. No.","MONTH","YEAR","HOUSE TAX ARREARS","HOUSE TAX CURRENT","LIBRARYCESS ARREARS","LIBRARYCESS CURRENT","LIGHTING  TAX ARREARS","LIGHTING TAX CURRENT","WATER  TAX ARREARS","WATER TAX CURRENT","DRAINAGE  TAX ARREARS","DRAINAGE TAX CURRENT","TAP FEE ARREARS","TAP FEE current","Actions ","Tap Donation","Others/penalties","Others","HOUSE TAX ARREARS","HOUSE TAX CURRENT","LIBRARYCESS ARREARS","LIBRARYCESS CURRENT","LIGHTING  TAX ARREARS","LIGHTING TAX CURRENT","WATER  TAX ARREARS","WATER TAX CURRENT","DRAINAGE  TAX ARREARS","DRAINAGE TAX CURRENT","TAP FEE ARREARS","TAP FEE current","Actions ","Tap Donation","Others/penalties","Others",null,"CURRENT MONTH",null,"PREVIOUS MONTH",null,"CURRENT MONTH",null,"PREVIOUS MONTH"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34]
[1,{"$f":"Database!B2","v":"April"},{"$f":"Database!C2","v":2020},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Database!D2","v":0},{"$f":"Database!E2","v":0},{"$f":"Database!F2","v":0},{"$f":"Database!G2","v":0},{"$f":"Database!H2","v":0},{"$f":"Database!I2","v":0},{"$f":"Database!J2","v":0},{"$f":"Database!K2","v":0},{"$f":"Database!L2","v":0},{"$f":"Database!M2","v":0},{"$f":"Database!N2","v":0},{"$f":"Database!O2","v":0},{"$f":"Database!P2","v":0},{"$f":"Database!Q2","v":0},{"$f":"Database!R2","v":0},{"$f":"Database!S2","v":0},null,{"$f":"T4+V4+X4+Z4+AB4","v":0},{"$f":"U4+W4+Y4+AA4+AC4","v":0},{"$f":"D4+F4+H4+J4+L4","v":0},{"$f":"E4+G4+I4+K4+M4","v":0},{"$f":"AD4","v":0},{"$f":"AE4+AF4+AG4+AH4+AI4","v":0},{"$f":"N4","v":0},{"$f":"O4+P4+Q4+R4+S4","v":0}]
[2,{"$f":"Database!B3","v":"May"},{"$f":"Database!C3","v":2020},{"$f":"T4+D4","v":0},{"$f":"U4+E4","v":0},{"$f":"V4+F4","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Database!D3","v":0},{"$f":"Database!E3","v":3502},{"$f":"Database!F3","v":0},{"$f":"Database!G3","v":280},{"$f":"Database!H3","v":0},{"$f":"Database!I3","v":350},{"$f":"Database!J3","v":0},{"$f":"Database!K3","v":350},{"$f":"Database!L3","v":0},{"$f":"Database!M3","v":350},{"$f":"Database!N3","v":0},{"$f":"Database!O3","v":1300},{"$f":"Database!P3","v":0},{"$f":"Database!Q3","v":0},{"$f":"Database!R3","v":1000},{"$f":"Database!S3","v":0},null,{"$f":"T5+V5+X5+Z5+AB5","v":0},{"$f":"U5+W5+Y5+AA5+AC5","v":4832},{"$f":"D5+F5+H5+J5+L5","v":0},{"$f":"E5+G5+I5+K5+M5","v":0},{"$f":"AD5","v":0},{"$f":"AE5+AF5+AG5+AH5+AI5","v":2300},{"$f":"N5","v":0},{"$f":"O5+P5+Q5+R5+S5","v":0}]
[3,{"$f":"Database!B4","v":"June"},{"$f":"Database!C4","v":2020},{"$f":"T5+D5","v":0},{"$f":"U5+E5","v":3502},{"$f":"V5+F5","v":0},280,0,350,0,350,0,350,0,1300,0,0,1000,0,{"$f":"Database!D4","v":0},{"$f":"Database!E4","v":0},{"$f":"Database!F4","v":0},{"$f":"Database!G4","v":0},{"$f":"Database!H4","v":0},{"$f":"Database!I4","v":0},{"$f":"Database!J4","v":0},{"$f":"Database!K4","v":0},{"$f":"Database!L4","v":0},{"$f":"Database!M4","v":0},{"$f":"Database!N4","v":0},{"$f":"Database!O4","v":0},{"$f":"Database!P4","v":0},{"$f":"Database!Q4","v":0},{"$f":"Database!R4","v":0},{"$f":"Database!S4","v":0},null,0,0,0,4832,0,0,0,2300]
[4,{"$f":"Database!B5","v":"July"},{"$f":"Database!C5","v":2020},{"$f":"T6+D6","v":0},{"$f":"U6+E6","v":3502},0,280,0,350,0,350,0,350,0,1300,0,0,1000,0,{"$f":"Database!D5","v":0},{"$f":"Database!E5","v":1086},{"$f":"Database!F5","v":0},{"$f":"Database!G5","v":87},{"$f":"Database!H5","v":0},{"$f":"Database!I5","v":109},{"$f":"Database!J5","v":0},{"$f":"Database!K5","v":109},{"$f":"Database!L5","v":0},{"$f":"Database!M5","v":109},{"$f":"Database!N5","v":0},{"$f":"Database!O5","v":0},{"$f":"Database!P5","v":0},{"$f":"Database!Q5","v":0},{"$f":"Database!R5","v":0},{"$f":"Database!S5","v":0},null,0,1500,0,4832,0,0,0,2300]
[5,{"$f":"Database!B6","v":"August"},{"$f":"Database!C6","v":2020},0,4588,{"$f":"V7+F7","v":0},{"$f":"W7+G7","v":367},{"$f":"X7+H7","v":0},{"$f":"Y7+I7","v":459},{"$f":"Z7+J7","v":0},{"$f":"AA7+K7","v":459},{"$f":"AB7+L7","v":0},{"$f":"AC7+M7","v":459},{"$f":"AD7+N7","v":0},{"$f":"AE7+O7","v":1300},{"$f":"AF7+P7","v":0},{"$f":"AG7+Q7","v":0},{"$f":"AH7+R7","v":1000},{"$f":"AI7+S7","v":0},{"$f":"Database!D6","v":0},{"$f":"Database!E6","v":2460},{"$f":"Database!F6","v":0},{"$f":"Database!G6","v":197},{"$f":"Database!H6","v":0},{"$f":"Database!I6","v":246},{"$f":"Database!J6","v":0},{"$f":"Database!K6","v":246},{"$f":"Database!L6","v":0},{"$f":"Database!M6","v":246},{"$f":"Database!N6","v":0},{"$f":"Database!O6","v":2500},{"$f":"Database!P6","v":0},{"$f":"Database!Q6","v":0},{"$f":"Database!R6","v":0},{"$f":"Database!S6","v":0},null,0,3395,0,6332,0,2500,0,2300]
[6,{"$f":"Database!B7","v":0},{"$f":"Database!C7","v":0},0,7048,0,564,0,705,0,705,0,705,0,3800,0,0,1000,0,{"$f":"Database!D7","v":0},{"$f":"Database!E7","v":0},{"$f":"Database!F7","v":0},{"$f":"Database!G7","v":0},{"$f":"Database!H7","v":0},{"$f":"Database!I7","v":0},{"$f":"Database!J7","v":0},{"$f":"Database!K7","v":0},{"$f":"Database!L7","v":0},{"$f":"Database!M7","v":0},{"$f":"Database!N7","v":0},{"$f":"Database!O7","v":0},{"$f":"Database!P7","v":0},{"$f":"Database!Q7","v":0},{"$f":"Database!R7","v":0},{"$f":"Database!S7","v":0},null,0,0,0,9727,0,0,0,4800]
[7,{"$f":"Database!B8","v":0},{"$f":"Database!C8","v":0},0,7048,0,564,0,705,0,705,0,705,0,3800,0,0,1000,0,{"$f":"Database!D8","v":0},{"$f":"Database!E8","v":0},{"$f":"Database!F8","v":0},{"$f":"Database!G8","v":0},{"$f":"Database!H8","v":0},{"$f":"Database!I8","v":0},{"$f":"Database!J8","v":0},{"$f":"Database!K8","v":0},{"$f":"Database!L8","v":0},{"$f":"Database!M8","v":0},{"$f":"Database!N8","v":0},{"$f":"Database!O8","v":0},{"$f":"Database!P8","v":0},{"$f":"Database!Q8","v":0},{"$f":"Database!R8","v":0},{"$f":"Database!S8","v":0},null,0,0,0,9727,0,0,0,4800]
[8,{"$f":"Database!B9","v":0},{"$f":"Database!C9","v":0},0,7048,0,{"$f":"W10+G10","v":564},0,705,0,705,0,705,0,3800,0,0,1000,0,{"$f":"Database!D9","v":0},{"$f":"Database!E9","v":0},{"$f":"Database!F9","v":0},{"$f":"Database!G9","v":0},{"$f":"Database!H9","v":0},{"$f":"Database!I9","v":0},{"$f":"Database!J9","v":0},{"$f":"Database!K9","v":0},{"$f":"Database!L9","v":0},{"$f":"Database!M9","v":0},{"$f":"Database!N9","v":0},{"$f":"Database!O9","v":0},{"$f":"Database!P9","v":0},{"$f":"Database!Q9","v":0},{"$f":"Database!R9","v":0},{"$f":"Database!S9","v":0},null,0,0,0,9727,0,0,0,4800]
[9,{"$f":"Database!B10","v":0},{"$f":"Database!C10","v":0},0,7048,0,564,0,705,0,705,0,705,0,3800,0,0,1000,0,{"$f":"Database!D10","v":0},{"$f":"Database!E10","v":0},{"$f":"Database!F10","v":0},{"$f":"Database!G10","v":0},{"$f":"Database!H10","v":0},{"$f":"Database!I10","v":0},{"$f":"Database!J10","v":0},{"$f":"Database!K10","v":0},{"$f":"Database!L10","v":0},{"$f":"Database!M10","v":0},{"$f":"Database!N10","v":0},{"$f":"Database!O10","v":0},{"$f":"Database!P10","v":0},{"$f":"Database!Q10","v":0},{"$f":"Database!R10","v":0},{"$f":"Database!S10","v":0},null,0,0,0,9727,0,0,0,4800]
[10,{"$f":"Database!B11","v":0},{"$f":"Database!C11","v":0},0,7048,0,564,0,705,0,705,0,705,0,3800,0,0,1000,0,{"$f":"Database!D11","v":0},{"$f":"Database!E11","v":0},{"$f":"Database!F11","v":0},{"$f":"Database!G11","v":0},{"$f":"Database!H11","v":0},{"$f":"Database!I11","v":0},{"$f":"Database!J11","v":0},{"$f":"Database!K11","v":0},{"$f":"Database!L11","v":0},{"$f":"Database!M11","v":0},{"$f":"Database!N11","v":0},{"$f":"Database!O11","v":0},{"$f":"Database!P11","v":0},{"$f":"Database!Q11","v":0},{"$f":"Database!R11","v":0},{"$f":"Database!S11","v":0},null,0,0,0,9727,0,0,0,4800]
[11,{"$f":"Database!B12","v":0},{"$f":"Database!C12","v":0},0,7048,0,564,0,705,0,705,0,705,0,3800,0,0,1000,0,{"$f":"Database!D12","v":0},{"$f":"Database!E12","v":0},{"$f":"Database!F12","v":0},{"$f":"Database!G12","v":0},{"$f":"Database!H12","v":0},{"$f":"Database!I12","v":0},{"$f":"Database!J12","v":0},{"$f":"Database!K12","v":0},{"$f":"Database!L12","v":0},{"$f":"Database!M12","v":0},{"$f":"Database!N12","v":0},{"$f":"Database!O12","v":0},{"$f":"Database!P12","v":0},{"$f":"Database!Q12","v":0},{"$f":"Database!R12","v":0},{"$f":"Database!S12","v":0},null,0,0,0,9727,0,0,0,4800]
[12,{"$f":"Database!B13","v":0},{"$f":"Database!C13","v":0},{"$f":"T14+D14","v":0},7048,0,564,0,705,0,705,0,705,0,3800,0,0,1000,0,{"$f":"Database!D13","v":0},{"$f":"Database!E13","v":0},{"$f":"Database!F13","v":0},{"$f":"Database!G13","v":0},{"$f":"Database!H13","v":0},{"$f":"Database!I13","v":0},{"$f":"Database!J13","v":0},{"$f":"Database!K13","v":0},{"$f":"Database!L13","v":0},{"$f":"Database!M13","v":0},{"$f":"Database!N13","v":0},{"$f":"Database!O13","v":0},{"$f":"Database!P13","v":0},{"$f":"Database!Q13","v":0},{"$f":"Database!R13","v":0},{"$f":"Database!S13","v":0},null,0,0,0,9727,0,0,0,4800]

{"sheet":"DCB","index":3,"n_rows":21,"n_cols":19,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,14,2,16],[2,17,3,17],[1,4,1,6],[1,0,1,3],[1,8,1,10],[1,12,1,14],[20,0,20,1],[0,0,0,5],[11,0,11,1],[12,0,12,18],[13,0,13,18],[19,0,19,1],[0,18,0,19],[1,15,1,18],[0,8,0,17],[0,6,0,7],[2,0,3,0],[2,1,3,1],[2,2,2,4],[2,5,2,7],[2,8,2,10],[2,11,2,13]]}
[null,null,null,null,null,null,{"$f":"INDEX(Form!U3:U14,Form!V3)","v":"August"},null," MONTH DEMAND COLLECTION BALANCE (DCB)"]
["GRAMAPANCHAYAT:  ",null,null,null,{"$f":"Form!D4","v":"Datnur"},null,null,"Mandal:         ",{"$f":"Form!G4","v":0},null,null,"Dist: ",{"$f":"Form!J4","v":0}]
["S.No.","Taxes ","DEMAND",null,null,"PREVIOUS MONTH COLLECTION",null,null,"COLLECTION OF DURING THE MONTH",null,null,"TOTAL COLLECTION",null,null,"BALANCE ",null,null,"PERCENTAGE %","Remarks"]
[null,null,"ARREARS","CURRENT","TOTAL","ARREARS","CURRENT","TOTAL","ARREARS","CURRENT","TOTAL","ARREARS","CURRENT","TOTAL","ARREARS","CURRENT","TOTAL"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[1,"House tax",{"$f":"Form!R8","v":0},{"$f":"Form!S8","v":11849},{"$f":"C6+D6","v":11849},{"$f":"VLOOKUP(G1,Sheet2!B4:AI15,3,0)","v":0},{"$f":"VLOOKUP(G1,Sheet2!B4:AI15,4,0)","v":4588},{"$f":"F6+G6","v":4588},{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,19,FALSE)","v":0},{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,20,FALSE)","v":2460},{"$f":"I6+J6","v":2460},{"$f":"F6+I6","v":0},{"$f":"G6+J6","v":7048},{"$f":"L6+M6","v":7048},{"$f":"C6-L6","v":0},{"$f":"D6-M6","v":4801},{"$f":"O6+P6","v":4801},{"$f":"IFERROR(N6*100/E6,0)","v":59.481812811207696}]
[2,"Library tax",{"$f":"Form!R10","v":0},{"$f":"Form!S10","v":948},{"$f":"C7+D7","v":948},{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,5,FALSE)","v":0},{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,6,FALSE)","v":367},{"$f":"F7+G7","v":367},{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,21,FALSE)","v":0},{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,22,FALSE)","v":197},{"$f":"I7+J7","v":197},{"$f":"F7+I7","v":0},564,{"$f":"L7+M7","v":564},{"$f":"C7-L7","v":0},384,{"$f":"O7+P7","v":384},59.493670886075947]
[3,"Water Tax",{"$f":"Form!R12","v":0},{"$f":"Form!S12","v":1185},{"$f":"C8+D8","v":1185},{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,7,FALSE)","v":0},{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,8,FALSE)","v":459},{"$f":"F8+G8","v":459},{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,23,FALSE)","v":0},{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,24,FALSE)","v":246},{"$f":"I8+J8","v":246},0,705,{"$f":"L8+M8","v":705},0,480,{"$f":"O8+P8","v":480},59.493670886075947]
[4,"Light tax",{"$f":"Form!R12","v":0},{"$f":"Form!S12","v":1185},{"$f":"C9+D9","v":1185},{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,9,FALSE)","v":0},{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,10,FALSE)","v":459},{"$f":"F9+G9","v":459},{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,25,FALSE)","v":0},{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,26,FALSE)","v":246},{"$f":"I9+J9","v":246},0,705,{"$f":"L9+M9","v":705},0,480,{"$f":"O9+P9","v":480},59.493670886075947]
[5,"Drain tax",{"$f":"Form!R16","v":0},{"$f":"Form!S16","v":1185},{"$f":"C10+D10","v":1185},{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,11,FALSE)","v":0},{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,12,FALSE)","v":459},{"$f":"F10+G10","v":459},{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,27,FALSE)","v":0},{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,28,FALSE)","v":246},{"$f":"I10+J10","v":246},0,705,{"$f":"L10+M10","v":705},0,480,{"$f":"O10+P10","v":480},59.493670886075947]
[]
["TOTAL",null,{"$f":"C6+C7+C8+C9+C10+C11","v":0},{"$f":"D6+D7+D8+D9+D10+D11","v":16352},16352,0,{"$f":"G6+G7+G8+G9+G10+G11","v":6332},6332,0,3395,3395,0,9727,9727,0,6625,6625,59.485078277886494]
[]
["NON TAXES"]
[1,"Tap Fee (monthly)",{"$f":"Form!R18","v":0},{"$f":"Form!S18","v":22320},{"$f":"C15+D15","v":22320},{"$f":"VLOOKUP(G1,Sheet2!B4:AI15,13,0)","v":0},{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,14,FALSE)","v":1300},{"$f":"F15+G15","v":1300},{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,29,FALSE)","v":0},{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,30,FALSE)","v":2500},{"$f":"I15+J15","v":2500},{"$f":"F15+I15","v":0},{"$f":"G15+J15","v":3800},{"$f":"L15+M15","v":3800},{"$f":"C15-L15","v":0},{"$f":"D15-M15","v":18520},{"$f":"O15+P15","v":18520},{"$f":"IFERROR(N15*100/E15,0)","v":17.025089605734767}]
[2,"Action fee (wekly markets, shopping  complex , ponds, any other)",0,{"$f":"N16","v":0},{"$f":"C16+D16","v":0},0,{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,16,FALSE)","v":0},{"$f":"F16+G16","v":0},null,{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,31,FALSE)","v":0},{"$f":"I16+J16","v":0},{"$f":"F16+I16","v":0},0,{"$f":"L16+M16","v":0},{"$f":"C16-L16","v":0},0,{"$f":"O16+P16","v":0},0]
[3,"Tap Donation",0,{"$f":"N17","v":1000},{"$f":"C17+D17","v":1000},0,{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,17,FALSE)","v":1000},{"$f":"F17+G17","v":1000},null,{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,32,FALSE)","v":0},{"$f":"I17+J17","v":0},0,1000,{"$f":"L17+M17","v":1000},0,0,{"$f":"O17+P17","v":0},100]
[4,"Penalties / OTHERS",0,{"$f":"N18","v":0},{"$f":"C18+D18","v":0},0,{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,18,FALSE)","v":0},{"$f":"F18+G18","v":0},null,{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,33,FALSE)","v":0},{"$f":"I18+J18","v":0},0,0,{"$f":"L18+M18","v":0},0,0,{"$f":"O18+P18","v":0},0]
[5,"Other",0,{"$f":"(N19)","v":0},{"$f":"C19+D19","v":0},0,{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,19,FALSE)","v":0},{"$f":"F19+G19","v":0},null,{"$f":"VLOOKUP(G1,Sheet2!B2:AI14,34,0)","v":0},{"$f":"I19+J19","v":0},0,0,{"$f":"L19+M19","v":0},0,0,{"$f":"O19+P19","v":0},0]
["NON TAXES Total",null,{"$f":"SUM(C15:C19)","v":0},{"$f":"SUM(D15:D19)","v":23320},{"$f":"SUM(E15:E19)","v":23320},{"$f":"SUM(F15:F19)","v":0},{"$f":"SUM(G15:G19)","v":2300},2300,0,2500,2500,0,4800,4800,0,18520,18520,20.583190394511149]
["TOTAL        (Tax+Non Tax)",null,{"$f":"C12+C20","v":0},39672,39672,0,8632,8632,0,5895,5895,0,14527,14527,0,25145,25145,36.617765678564226]

{"sheet":"MONTH WISE TAX DETAILS","index":4,"n_rows":17,"n_cols":20,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,15,2,17],[2,18,3,18],[0,0,0,19],[2,2,3,2],[2,0,3,0],[2,1,3,1],[2,3,2,5],[2,6,2,8],[2,9,2,11],[2,12,2,14],[1,0,1,4],[1,5,1,7],[1,9,1,11],[1,13,1,15],[1,16,1,19]]}
["TAX  MONTH WISE  DEMAND COLLECTION BALANCE (DCB)"]
["GRAMAPANCHAYAT:  ",null,null,null,null,{"$f":"Form!D4","v":"Datnur"},null,null,"Mandal:         ",{"$f":"Form!F4","v":"Gollapalli"},null,null,"Dist: ",{"$f":"Form!Q4","v":"Jagtial"}]
["S.No.","MONTHS","YEAR","DEMAND",null,null,"PREVIOUS MONTH COLLECTION",null,null,"COLLECTION OF DURING THE MONTH",null,null,"TOTAL COLLECTION",null,null,"BALANCE ",null,null,"PERCENTAGE %","Remarks"]
[null,null,null,"ARREARS","CURRENT","TOTAL","ARREARS","CURRENT","TOTAL","ARREARS","CURRENT","TOTAL","ARREARS","CURRENT","TOTAL","ARREARS","CURRENT","TOTAL"]
[1,2,null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[1,"APRIL",2020,{"$f":"Form!R8+Form!R10++Form!R12+Form!R14+Form!R16","v":0},{"$f":"Form!S8+Form!S10+Form!S12+Form!S14+Form!S16","v":16352},{"$f":"D6+E6","v":16352},{"$f":"Sheet2!AM4","v":0},{"$f":"Sheet2!AN4","v":0},{"$f":"H6+G6","v":0},{"$f":"Sheet2!AK4","v":0},{"$f":"Sheet2!AL4","v":0},{"$f":"J6+K6","v":0},{"$f":"J6+G6","v":0},{"$f":"K6+H6","v":0},{"$f":"N6+M6","v":0},{"$f":"D6-M6","v":0},{"$f":"E6-N6","v":16352},{"$f":"F6-O6","v":16352},{"$f":"O6*100/F6","v":0}]
[2,"MAY",2020,{"$f":"D6","v":0},{"$f":"E6","v":16352},{"$f":"F6","v":16352},{"$f":"M6","v":0},{"$f":"N6","v":0},{"$f":"O6","v":0},{"$f":"Sheet2!AK5","v":0},{"$f":"Sheet2!AL5","v":4832},{"$f":"J7+K7","v":4832},{"$f":"J7+G7","v":0},{"$f":"K7+H7","v":4832},{"$f":"N7+M7","v":4832},{"$f":"D7-M7","v":0},{"$f":"E7-N7","v":11520},{"$f":"F7-O7","v":11520},{"$f":"O7*100/F7","v":29.549902152641877}]
[3,"JUNE",2020,{"$f":"D7","v":0},{"$f":"E7","v":16352},{"$f":"F7","v":16352},{"$f":"M7","v":0},{"$f":"N7","v":4832},{"$f":"O7","v":4832},{"$f":"Sheet2!AK6","v":0},{"$f":"Sheet2!AL6","v":0},0,0,4832,4832,0,11520,11520,29.549902152641877]
[4,"JULY",2020,0,16352,16352,0,4832,4832,{"$f":"Sheet2!AK7","v":0},{"$f":"Sheet2!AL7","v":1500},1500,0,6332,6332,0,10020,10020,38.723091976516635]
[5,"AUGUST",2020,0,16352,16352,0,6332,6332,{"$f":"Sheet2!AK8","v":0},{"$f":"Sheet2!AL8","v":3395},3395,0,9727,9727,0,6625,6625,59.485078277886494]
[6,"SEPTEMBER",2020,0,16352,16352,0,9727,9727,{"$f":"Sheet2!AK9","v":0},{"$f":"Sheet2!AL9","v":0},0,0,9727,9727,0,6625,6625,59.485078277886494]
[7,"OCTOBER",2020,0,16352,16352,0,9727,9727,{"$f":"Sheet2!AK10","v":0},{"$f":"Sheet2!AL10","v":0},0,0,9727,9727,0,{"$f":"E12-N12","v":6625},6625,59.485078277886494]
[8,"NOVEMBER",2020,0,16352,16352,0,9727,9727,{"$f":"Sheet2!AK11","v":0},{"$f":"Sheet2!AL11","v":0},0,0,9727,9727,0,6625,6625,59.485078277886494]
[9,"DECEMBER",2020,0,16352,16352,0,9727,9727,{"$f":"Sheet2!AK12","v":0},{"$f":"Sheet2!AL12","v":0},0,0,9727,9727,0,6625,6625,59.485078277886494]
[10,"JANUARY",2020,0,16352,16352,0,9727,9727,{"$f":"Sheet2!AK13","v":0},{"$f":"Sheet2!AL13","v":0},0,0,9727,9727,0,6625,6625,59.485078277886494]
[11,"FEBRUARY",2020,0,16352,16352,0,9727,9727,{"$f":"Sheet2!AK14","v":0},{"$f":"Sheet2!AL14","v":0},0,0,9727,9727,0,6625,6625,59.485078277886494]
[12,"MARCH",2020,0,16352,16352,0,9727,9727,{"$f":"Sheet2!AK15","v":0},{"$f":"Sheet2!AL15","v":0},0,0,9727,9727,0,6625,6625,59.485078277886494]

{"sheet":"MONTH WISE NON TAX DETAILS (2)","index":5,"n_rows":17,"n_cols":20,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,19],[1,0,1,4],[1,5,1,7],[1,9,1,11],[1,13,1,15],[1,16,1,19],[2,12,2,14],[2,15,2,17],[2,18,3,18],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,2,5],[2,6,2,8],[2,9,2,11]]}
["NON TAX   MONTH WISE  DEMAND COLLECTION BALANCE (DCB)"]
["GRAMAPANCHAYAT:  ",null,null,null,null,{"$f":"Form!D4","v":"Datnur"},null,null,"Mandal:         ",{"$f":"Form!F4","v":"Gollapalli"},null,null,"Dist: ",{"$f":"Form!Q4","v":"Jagtial"}]
["S.No.","MONTHS","YEAR","DEMAND",null,null,"PREVIOUS MONTH COLLECTION",null,null,"COLLECTION OF DURING THE MONTH",null,null,"TOTAL COLLECTION",null,null,"BALANCE ",null,null,"PERCENTAGE %","Remarks"]
[null,null,null,"ARREARS","CURRENT","TOTAL","ARREARS","CURRENT","TOTAL","ARREARS","CURRENT","TOTAL","ARREARS","CURRENT","TOTAL","ARREARS","CURRENT","TOTAL"]
[1,2,null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[1,"APRIL",2020,{"$f":"Form!R18","v":0},{"$f":"Form!S18","v":22320},{"$f":"E6+D6","v":22320},{"$f":"Sheet2!AQ4","v":0},{"$f":"Sheet2!AR4","v":0},{"$f":"H6+G6","v":0},{"$f":"Sheet2!AO4","v":0},{"$f":"Sheet2!AP4","v":0},{"$f":"J6+K6","v":0},{"$f":"J6+G6","v":0},{"$f":"K6+H6","v":0},{"$f":"N6+M6","v":0},{"$f":"D6-M6","v":0},{"$f":"E6-N6","v":22320},{"$f":"F6-O6","v":22320},{"$f":"O6*100/F6","v":0}]
[2,"MAY",2020,{"$f":"D6","v":0},{"$f":"E6","v":22320},{"$f":"F6","v":22320},{"$f":"M6","v":0},{"$f":"N6","v":0},{"$f":"O6","v":0},{"$f":"Sheet2!AO5","v":0},{"$f":"Sheet2!AP5","v":2300},{"$f":"J7+K7","v":2300},{"$f":"J7+G7","v":0},{"$f":"K7+H7","v":2300},{"$f":"N7+M7","v":2300},{"$f":"D7-M7","v":0},{"$f":"E7-N7","v":20020},{"$f":"F7-O7","v":20020},{"$f":"O7*100/F7","v":10.304659498207885}]
[3,"JUNE",2020,{"$f":"D7","v":0},{"$f":"E7","v":22320},{"$f":"F7","v":22320},{"$f":"M7","v":0},{"$f":"N7","v":2300},{"$f":"O7","v":2300},{"$f":"Sheet2!AO6","v":0},{"$f":"Sheet2!AP6","v":0},0,0,2300,2300,0,20020,20020,10.304659498207885]
[4,"JULY",2020,0,22320,22320,0,2300,2300,{"$f":"Sheet2!AO7","v":0},{"$f":"Sheet2!AP7","v":0},0,0,2300,2300,0,20020,20020,10.304659498207885]
[5,"AUGUST",2020,0,22320,22320,0,2300,2300,{"$f":"Sheet2!AO8","v":0},{"$f":"Sheet2!AP8","v":2500},2500,0,4800,4800,0,17520,17520,21.50537634408602]
[6,"SEPTEMBER",2020,0,22320,22320,0,4800,4800,{"$f":"Sheet2!AO9","v":0},{"$f":"Sheet2!AP9","v":0},0,0,4800,4800,0,17520,17520,21.50537634408602]
[7,"OCTOBER",2020,0,22320,22320,0,4800,4800,{"$f":"Sheet2!AO10","v":0},{"$f":"Sheet2!AP10","v":0},0,0,4800,4800,0,17520,17520,21.50537634408602]
[8,"NOVEMBER",2020,0,22320,22320,0,4800,4800,{"$f":"Sheet2!AO11","v":0},{"$f":"Sheet2!AP11","v":0},0,0,4800,4800,0,17520,17520,21.50537634408602]
[9,"DECEMBER",2020,0,22320,22320,0,4800,4800,{"$f":"Sheet2!AO12","v":0},{"$f":"Sheet2!AP12","v":0},0,0,4800,4800,0,17520,17520,21.50537634408602]
[10,"JANUARY",2020,0,22320,22320,0,4800,4800,{"$f":"Sheet2!AO13","v":0},{"$f":"Sheet2!AP13","v":0},0,0,4800,4800,0,17520,17520,21.50537634408602]
[11,"FEBRUARY",2020,0,22320,22320,0,4800,4800,{"$f":"Sheet2!AO14","v":0},{"$f":"Sheet2!AP14","v":0},0,0,4800,4800,0,17520,17520,21.50537634408602]
[12,"MARCH",2020,0,22320,22320,0,4800,4800,{"$f":"Sheet2!AO15","v":0},{"$f":"Sheet2!AP15","v":0},0,0,4800,4800,0,17520,17520,21.50537634408602]

{"sheet":"mONTH wISE dCB","index":6,"n_rows":21,"n_cols":22,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,6,0,7],[1,0,1,3],[1,4,1,6],[20,0,20,1],[19,0,19,1],[2,14,2,16],[2,17,3,17],[11,0,11,1],[12,0,12,18],[13,0,13,18],[2,0,3,0],[2,1,3,1],[2,2,2,4],[2,5,2,7],[2,8,2,10],[2,11,2,13]]}
[null,null,null,null,null,null,{"$f":"DCB!G1","v":"August"},null," MONTH DEMAND COLLECTION BALANCE (DCB)"]
["GRAMAPANCHAYAT:  ",null,null,null,{"$f":"DCB!E2","v":"Datnur"},null,null,"Mandal:         ",{"$f":"Form!F4","v":"Gollapalli"},null,null,"Dist: ",{"$f":"Form!Q4","v":"Jagtial"}]
["S.No.","Taxes ","DEMAND",null,null,"PREVIOUS MONTH COLLECTION",null,null,"COLLECTION OF DURING THE MONTH",null,null,"TOTAL COLLECTION",null,null,"BALANCE ",null,null,"PERCENTAGE %","Remarks",null,"APRIL",1]
[null,null,"ARREARS","CURRENT","TOTAL","ARREARS","CURRENT","TOTAL","ARREARS","CURRENT","TOTAL","ARREARS","CURRENT","TOTAL","ARREARS","CURRENT","TOTAL",null,null,null,"MAY"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,null,null,"JUNE"]
[1,"House tax",{"$f":"DCB!C6","v":0},{"$f":"DCB!D6","v":11849},{"$f":"DCB!E6","v":11849},{"$f":"DCB!F6","v":0},{"$f":"DCB!G6","v":4588},{"$f":"DCB!H6","v":4588},{"$f":"DCB!I6","v":0},{"$f":"DCB!J6","v":2460},{"$f":"DCB!K6","v":2460},{"$f":"DCB!L6","v":0},{"$f":"DCB!M6","v":7048},{"$f":"DCB!N6","v":7048},{"$f":"DCB!O6","v":0},{"$f":"DCB!P6","v":4801},{"$f":"DCB!Q6","v":4801},{"$f":"DCB!R6","v":59.481812811207696},null,null,"JULY"]
[2,"Library tax",{"$f":"DCB!C7","v":0},{"$f":"DCB!D7","v":948},{"$f":"DCB!E7","v":948},{"$f":"DCB!F7","v":0},{"$f":"DCB!G7","v":367},{"$f":"DCB!H7","v":367},{"$f":"DCB!I7","v":0},{"$f":"DCB!J7","v":197},{"$f":"DCB!K7","v":197},{"$f":"DCB!L7","v":0},{"$f":"DCB!M7","v":564},{"$f":"DCB!N7","v":564},{"$f":"DCB!O7","v":0},{"$f":"DCB!P7","v":384},{"$f":"DCB!Q7","v":384},{"$f":"DCB!R7","v":59.493670886075947},null,null,"AUGUST"]
[3,"Water Tax",{"$f":"DCB!C8","v":0},{"$f":"DCB!D8","v":1185},{"$f":"DCB!E8","v":1185},{"$f":"DCB!F8","v":0},{"$f":"DCB!G8","v":459},{"$f":"DCB!H8","v":459},{"$f":"DCB!I8","v":0},{"$f":"DCB!J8","v":246},{"$f":"DCB!K8","v":246},{"$f":"DCB!L8","v":0},{"$f":"DCB!M8","v":705},{"$f":"DCB!N8","v":705},{"$f":"DCB!O8","v":0},{"$f":"DCB!P8","v":480},{"$f":"DCB!Q8","v":480},{"$f":"DCB!R8","v":59.493670886075947},null,null,"SEPTEMBER"]
[4,"Light tax",{"$f":"DCB!C9","v":0},{"$f":"DCB!D9","v":1185},{"$f":"DCB!E9","v":1185},{"$f":"DCB!F9","v":0},{"$f":"DCB!G9","v":459},{"$f":"DCB!H9","v":459},{"$f":"DCB!I9","v":0},{"$f":"DCB!J9","v":246},{"$f":"DCB!K9","v":246},{"$f":"DCB!L9","v":0},{"$f":"DCB!M9","v":705},{"$f":"DCB!N9","v":705},{"$f":"DCB!O9","v":0},{"$f":"DCB!P9","v":480},{"$f":"DCB!Q9","v":480},{"$f":"DCB!R9","v":59.493670886075947},null,null,"OCTOBER"]
[5,"Drain tax",{"$f":"DCB!C10","v":0},{"$f":"DCB!D10","v":1185},{"$f":"DCB!E10","v":1185},{"$f":"DCB!F10","v":0},{"$f":"DCB!G10","v":459},{"$f":"DCB!H10","v":459},{"$f":"DCB!I10","v":0},{"$f":"DCB!J10","v":246},{"$f":"DCB!K10","v":246},{"$f":"DCB!L10","v":0},{"$f":"DCB!M10","v":705},{"$f":"DCB!N10","v":705},{"$f":"DCB!O10","v":0},{"$f":"DCB!P10","v":480},{"$f":"DCB!Q10","v":480},{"$f":"DCB!R10","v":59.493670886075947},null,null,"NOVEMBER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DECEMBER"]
["TOTAL",null,{"$f":"C6+C7+C8+C9+C10+C11","v":0},{"$f":"D6+D7+D8+D9+D10+D11","v":16352},16352,0,{"$f":"G6+G7+G8+G9+G10+G11","v":6332},6332,0,3395,3395,0,9727,9727,0,6625,6625,{"$f":"IFERROR(N12*100/E12,0)","v":59.485078277886494}]
[]
["NON TAXES"]
[1,"Tap Fee (monthly)",{"$f":"DCB!C15","v":0},{"$f":"DCB!D15","v":22320},{"$f":"DCB!E15","v":22320},{"$f":"DCB!F15","v":0},{"$f":"DCB!G15","v":1300},{"$f":"DCB!H15","v":1300},{"$f":"DCB!I15","v":0},{"$f":"DCB!J15","v":2500},{"$f":"DCB!K15","v":2500},{"$f":"DCB!L15","v":0},{"$f":"DCB!M15","v":3800},{"$f":"DCB!N15","v":3800},{"$f":"DCB!O15","v":0},{"$f":"DCB!P15","v":18520},{"$f":"DCB!Q15","v":18520},{"$f":"DCB!R15","v":17.025089605734767}]
[2,"Action fee (wekly markets, shopping  complex , ponds, any other)",null,{"$f":"DCB!D16","v":0},{"$f":"DCB!E16","v":0},null,{"$f":"DCB!G16","v":0},{"$f":"DCB!H16","v":0},null,{"$f":"DCB!J16","v":0},{"$f":"DCB!K16","v":0},null,{"$f":"DCB!M16","v":0},{"$f":"DCB!N16","v":0},null,{"$f":"DCB!P16","v":0},{"$f":"DCB!Q16","v":0},{"$f":"DCB!R16","v":0}]
[3,"Tap Donation",null,{"$f":"DCB!D17","v":1000},{"$f":"DCB!E17","v":1000},null,{"$f":"DCB!G17","v":1000},{"$f":"DCB!H17","v":1000},null,{"$f":"DCB!J17","v":0},{"$f":"DCB!K17","v":0},null,{"$f":"DCB!M17","v":1000},{"$f":"DCB!N17","v":1000},null,{"$f":"DCB!P17","v":0},{"$f":"DCB!Q17","v":0},{"$f":"DCB!R17","v":100}]
[4,"Penalties / OTHERS",null,{"$f":"DCB!D18","v":0},{"$f":"DCB!E18","v":0},null,{"$f":"DCB!G18","v":0},{"$f":"DCB!H18","v":0},null,{"$f":"DCB!J18","v":0},{"$f":"DCB!K18","v":0},null,{"$f":"DCB!M18","v":0},{"$f":"DCB!N18","v":0},null,{"$f":"DCB!P18","v":0},{"$f":"DCB!Q18","v":0},{"$f":"DCB!R18","v":0}]
[5,"Other",null,{"$f":"DCB!D19","v":0},{"$f":"DCB!E19","v":0},null,{"$f":"DCB!G19","v":0},{"$f":"DCB!H19","v":0},null,{"$f":"DCB!J19","v":0},{"$f":"DCB!K19","v":0},null,{"$f":"DCB!M19","v":0},{"$f":"DCB!N19","v":0},null,{"$f":"DCB!P19","v":0},{"$f":"DCB!Q19","v":0},{"$f":"DCB!R19","v":0}]
["NON TAXES Total",null,{"$f":"SUM(C15:C19)","v":0},{"$f":"SUM(D15:D19)","v":23320},{"$f":"SUM(E15:E19)","v":23320},{"$f":"SUM(F15:F19)","v":0},2300,2300,0,{"$f":"SUM(J15:J19)","v":2500},2500,0,4800,4800,0,18520,18520,{"$f":"IFERROR(N20*100/E20,0)","v":20.583190394511149}]
["TOTAL        (Tax+Non Tax)",null,{"$f":"C12+C20","v":0},39672,39672,0,8632,8632,0,5895,5895,0,14527,14527,0,25145,25145,{"$f":"IFERROR(N21*100/E21,0)","v":36.617765678564226}]