{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Master","GA 55","Extra deduc","COMPUTATION"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":2,"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":"Master","index":0,"n_rows":29,"n_cols":27,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,5,28,7],[13,9,13,13],[27,2,27,10],[6,3,6,8],[0,2,0,10],[7,10,7,13],[10,10,10,12],[11,10,11,12],[12,10,12,12],[16,7,16,8],[17,7,17,8],[14,1,14,2],[14,3,14,4],[14,5,14,6],[14,7,14,8],[12,1,12,2],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[19,0,20,0],[16,3,16,4],[17,3,17,4],[16,1,16,2],[17,5,17,6],[17,1,17,2],[11,1,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8],[12,3,12,4],[12,5,12,6],[12,7,12,8],[8,7,8,8],[9,3,9,4],[9,5,9,6],[9,7,9,8],[10,1,10,2],[10,3,10,4],[10,5,10,6],[10,7,10,8],[4,1,4,3],[22,4,22,7],[3,2,3,3],[3,5,3,7],[1,1,1,3],[1,5,1,7],[2,1,2,3],[2,5,2,7],[4,5,4,7],[5,1,5,3],[5,5,5,7],[7,1,7,2],[7,3,7,8],[8,1,8,2],[8,3,8,4],[8,5,8,6]]}
[null,null,"EMPLOYEE  PERSONAL  DETAIL"]
[null,"              D;k vkius lefiZr osru fy;k gS \\",null,null,"YES",";fn gk¡ rks ekg dks lysDV djsaA",null,null,"OCT",null,null,null,null,null,null,null,null,null,"YES","JAN",8,"GPF","Jaipur (U.A.)",null,"Regular Pay",null,"2019-03-01"]
[null,"         vki fdl vk;q oxZ dh Js.kh esa vkrs gS \\",null,null,"Under 60","           D;k vkidks cksul feyk gS \\  %&",null,null,"YES",6774,null,{"$f":"UPPER(IF(Master!H9=\"\",\"\",Master!H9))","v":"SR TEACHER"},null,null,null,null,null,null,"NO",{"$f":"UPPER(IF(Master!D10=\"\",\"\",Master!D10))","v":"G.S.S.S. INDERWARA"},9,"NPS","Ajmer",null,"Fix Pay",null,"2019-04-01"]
[null,null,"foadykax HkÙkk %&",null,600,"  vkidks osru fey jgk gS %&",null,null,"Regular Pay",null,{"$f":"IF(AND(Master!I5=Master!V3),\"\",Master!D13)","v":112233},null,null,null,null,null,{"$f":"IF(AND(Master!I5=Master!V2),\"\",Master!D14)","v":""},null,null,"MAR",10,null,"Bikaner",null,{"$f":"IF(AND(Master!D15=\"\"),\"\",Master!D15)","v":51046657419},null,"2019-05-01"]
[null,"    7th PAY  HRA izfr'kr esa %&",null,null,8,"%                      GPF / NPS :- ",null,null,"GPF",null,null,null,null,null,null,null,null,null,null,"APR",12,null,"Jodhpur",null,null,null,"2019-06-01"]
[null,"CCA yxrk gSa rks sellect Yes / No   %&",null,null,"YES"," CCA ykxw gks rks CITY lysDV djsa %&",null,null,"Jodhpur",null,null,null,null,null,null,null,null,null,null,"MAY",16,null,"Kota",null,null,null,"2019-07-01"]
[null,null,null,"First Unlock Cell Entry Fill Up Then Click On Generate Button",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JUN",20,null,null,null,null,null,"2019-08-01"]
[null,"Office Name :-",null,"Government Sr. Secondary School INDERWARA , Rani (Pali)",null,null,null,null,null,null,"ije~ iwT; xw:nso Jh Jh 1008 oklwnso th egkjkt",null,null,null,null,null,null,null,null,"JUL",null,null,null,1000,null,null,"2019-09-01"]
[null,"Employee Name :-",null,"Heeralal jat",null,"Designation :-",null,"Sr Teacher",null,null,null,null,null,null,null,null,null,null,null,"AUG",null,null,null,620,null,null,"2019-10-01"]
[null,null,"Posting Place :-","G.S.S.S. Inderwara",null,"DDO Name :-",null,"Mishrilal",null,null,null,null,null,null,null,null,null,null,null,"SEP",null,null,null,null,null,null,"2019-11-01"]
[null,"Personal Employee ID :-",null,"RJPAxxxxxxxx74",null,"UID AADHAR No. :-",null,null,null,null,"Micro Software Present By ",null,null,null,null,null,null,null,null,"OCT",null,null,null,null,null,null,"2019-12-01"]
[null,"PAN No. :-",null,"ADTxxxxxx2",null,"TAN NO. :-",null,"ADIxxx1L",null,null,"HEERA LAL JAAT",null,null,null,null,null,null,null,null,"NOV",null,null,null,null,null,null,"2020-01-01"]
[null,"GPF No. :-",null,112233,null,"SI No. :-",null,123456,null,null,"Sr. Teacher",null,null,null,null,null,null,null,null,"DEC",null,null,null,null,null,null,"2020-02-01"]
[null,"PRAN No. :-",null,3216544444,null,"CPF & NPS No. :-",null,null,null,"V./P. - Chandawal Nagar, Sojat (Pali)"]
[null,"Bank A/C No. :-",null,51046657419,null,"Salary Head :-"]
[]
[null,"BASIC On 01 March 2019  F",null,45100]
[null,"Tax Calculate From Month  :-\n",null,"2019-03-01",null,"To Month  :-\n",null,"2020-02-01"]
[]
[null,"Wash All.","Handi. All.","CCA","other","SI","GPF","L.I.C.","S.I. LOAN","GPF LOAN","Other","Other"]
[null,null,null,null,null,4000,3575,2178]
[]
[null,null,null,null,"Income Tax Deduction By Salary"]
[null,"March","April","May","June","July","August","September","October","November","December","January","February"]
[null,200,500,1000,500,500,1000,2000,2000,4000,1400,1400,100]
[]
[]
[null,null,"First Unlock Cell Entry Fill Up Then Click On Generate Button"]
[null,null,null,null,null,"Use Tab Button For Unlock Cell"]

{"sheet":"GA 55","index":1,"n_rows":30,"n_cols":47,"rows_kept":30,"cut":false,"hidden":true,"merged":[[3,24,3,26],[2,0,2,2],[28,3,28,7],[28,18,28,24],[4,0,4,11],[4,12,4,23],[4,25,5,25],[2,3,2,7],[4,24,5,24],[4,26,5,26],[26,0,26,1],[2,25,2,26],[2,8,2,10],[2,11,2,14],[2,15,2,18],[2,19,2,24],[3,16,3,20],[3,21,3,23],[3,0,3,1],[3,2,3,4],[3,6,3,8],[3,10,3,12],[3,13,3,15]]}
[]
[]
["Employee Name :-",null,null,{"$f":"UPPER(IF(Master!D9=\"\",\"\",Master!D9))","v":"HEERALAL JAT"},null,null,null,null,"Designation :-",null,null,{"$f":"UPPER(IF(Master!H9=\"\",\"\",Master!H9))","v":"SR TEACHER"},null,null,null,"Posting Place :-",null,null,null,{"$f":"UPPER(IF(Master!D10=\"\",\"\",Master!D10))","v":"G.S.S.S. INDERWARA"},null,null,null,null,null,"osru Mªk ekufp="]
["PAN No. :-",null,{"$f":"UPPER(IF(Master!D12=\"\",\"\",Master!D12))","v":"ADTXXXXXX2"},null,null,"SI No.",{"$f":"IF(AND(Master!H13=\"\"),\"\",Master!H13)","v":123456},null,null,"GPF",{"$f":"IF(AND(Master!I5=Master!V3),\"\",Master!D13)","v":112233},null,null,"PRAN No. :-",null,null,{"$f":"IF(AND(Master!I5=Master!V2),\"\",Master!D14)","v":""},null,null,null,null,"Bank A/C.",null,null,{"$f":"IF(AND(Master!D15=\"\"),\"\",Master!D15)","v":51046657419}]
["Total Allowances",null,null,null,null,null,null,null,null,null,null,null,"Deductions",null,null,null,null,null,null,null,null,null,null,null,"NET PAY","TV.NO.","Enc.  DATE"]
["S.R.","Month","Basic With Grade Pay","DA","HRA",{"$f":"Master!B20","v":"Wash All."},{"$f":"Master!C20","v":"Handi. All."},"Bonus",{"$f":"Master!D20","v":"CCA"},"N.P.S. By Govt.",{"$f":"Master!E20","v":"other"},"Total","SI","GPF","RPMF","N.P.S. By SELF",{"$f":"Master!H20","v":"L.I.C."},{"$f":"Master!I20","v":"S.I. LOAN"},{"$f":"Master!J20","v":"GPF LOAN"},{"$f":"Master!K20","v":"Other"},"Income Tax","G.I. + S. Tax",{"$f":"Master!K20","v":"Other"},"Total Ded."]
[1,{"$f":"IF(AND(AT7=\"\"),\"\",AP7)","v":"2019-03-01"},{"$f":"IF(AND(B7=\"\"),\"\",AT7)","v":45100},{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C7=\"\"),\"\",ROUND(12%*C7,0)))","v":5412},{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C7=\"\"),\"\",ROUND(Master!$E$5%*C7,0)))","v":3608},{"$f":"IF(AND(C7=\"\"),\"\",IF(AND(Master!$B$21=\"\"),\"\",Master!$B$21))","v":""},{"$f":"IF(AND(C7=\"\"),\"\",IF(AND(Master!$C$21=\"\"),\"\",Master!$C$21))","v":""},null,{"$f":"IF(AND(C7=\"\"),\"\",IF(AND(Master!$D$21=\"\"),\"\",Master!$D$21))","v":""},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C7)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C7+D7)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C7=\"\"),\"\",IF(AND(Master!$E$21=\"\"),\"\",Master!$E$21))","v":""},{"$f":"IF(AND(B7=\"\"),\"\",SUM(C7,D7,E7,F7,G7,I7,K7))","v":54120},{"$f":"IF(AND(C7=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$F$21))","v":4000},{"$f":"IF(AND(C7=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",Master!$G$21)))","v":3575},{"$f":"IF(AND(B7=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",IF(C7<18001,228,IF(C7<33501,379,IF(C7<54001,568,755))))))","v":568},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C7)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C7+D7)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C7=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C7=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C7=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$I$21))","v":0},{"$f":"IF(AND(C7=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$K$21))","v":0},{"$f":"IF(AND(C7=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!B25))","v":200},null,{"$f":"IF(AND(C7=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$L$21))","v":0},{"$f":"IF(AND(B7=\"\"),\"\",SUM(M7:W7))","v":12699},{"$f":"IF(AND(B7=\"\"),\"\",IF(AND(L7=\"\",X7=\"\"),\"\",SUM(L7-X7)))","v":41421},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAR","2019-03-01",3,null,{"$f":"$AR$10","v":45100},{"$f":"IF(AND(AP7<$AR$11),\"\",IF(AND(AP7>$AR$12),\"\",AS7))","v":45100},{"$f":"ROUND(12%*AS7,0)","v":5412}]
[2,{"$f":"IF(AND(AT8=\"\"),\"\",AP8)","v":"2019-04-01"},{"$f":"IF(AND(B8=\"\"),\"\",AT8)","v":45100},{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C8=\"\"),\"\",ROUND(12%*C8,0)))","v":5412},{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C8=\"\"),\"\",ROUND(Master!$E$5%*C8,0)))","v":3608},{"$f":"IF(AND(C8=\"\"),\"\",IF(AND(Master!$B$21=\"\"),\"\",Master!$B$21))","v":""},{"$f":"IF(AND(C8=\"\"),\"\",IF(AND(Master!$C$21=\"\"),\"\",Master!$C$21))","v":""},null,{"$f":"IF(AND(C8=\"\"),\"\",IF(AND(Master!$D$21=\"\"),\"\",Master!$D$21))","v":""},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C8)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C8+D8)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C8=\"\"),\"\",IF(AND(Master!$E$21=\"\"),\"\",Master!$E$21))","v":""},{"$f":"IF(AND(B8=\"\"),\"\",SUM(C8,D8,E8,F8,G8,I8,K8))","v":54120},{"$f":"IF(AND(C8=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$F$21))","v":4000},{"$f":"IF(AND(C8=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",Master!$G$21)))","v":3575},{"$f":"IF(AND(B8=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",IF(C8<18001,242,IF(C8<33501,402,IF(C8<54001,602,800))))))","v":602},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C8)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C8+D8)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C8=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C8=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C8=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$I$21))","v":0},{"$f":"IF(AND(C8=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$K$21))","v":0},{"$f":"IF(AND(C8=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!C25))","v":500},220,{"$f":"IF(AND(C8=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$L$21))","v":0},{"$f":"IF(AND(B8=\"\"),\"\",SUM(M8:W8))","v":13253},{"$f":"IF(AND(B8=\"\"),\"\",IF(AND(L8=\"\",X8=\"\"),\"\",SUM(L8-X8)))","v":40867},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APR","2019-04-01",4,null,{"$f":"$AR$10","v":45100},{"$f":"IF(AND(AP8<$AR$11),\"\",IF(AND(AP8>$AR$12),\"\",AS8))","v":45100},{"$f":"ROUND(12%*AS8,0)","v":5412}]
[3,"2019-05-01",45100,{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C9=\"\"),\"\",ROUND(12%*C9,0)))","v":5412},{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C9=\"\"),\"\",ROUND(Master!$E$5%*C9,0)))","v":3608},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND(Master!$B$21=\"\"),\"\",Master!$B$21))","v":""},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND(Master!$C$21=\"\"),\"\",Master!$C$21))","v":""},null,{"$f":"IF(AND(C9=\"\"),\"\",IF(AND(Master!$D$21=\"\"),\"\",Master!$D$21))","v":""},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C9)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C9+D9)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND(Master!$E$21=\"\"),\"\",Master!$E$21))","v":""},54120,{"$f":"IF(AND(C9=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$F$21))","v":4000},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",Master!$G$21)))","v":3575},{"$f":"IF(AND(B9=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",IF(C9<18001,242,IF(C9<33501,402,IF(C9<54001,602,800))))))","v":602},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C9)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C9+D9)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$I$21))","v":0},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$K$21))","v":0},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!D25))","v":1000},null,{"$f":"IF(AND(C9=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$L$21))","v":0},13533,40587,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAY","2019-05-01",5,null,45100,45100,5412]
[4,"2019-06-01",45100,{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C10=\"\"),\"\",ROUND(12%*C10,0)))","v":5412},{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C10=\"\"),\"\",ROUND(Master!$E$5%*C10,0)))","v":3608},{"$f":"IF(AND(C10=\"\"),\"\",IF(AND(Master!$B$21=\"\"),\"\",Master!$B$21))","v":""},{"$f":"IF(AND(C10=\"\"),\"\",IF(AND(Master!$C$21=\"\"),\"\",Master!$C$21))","v":""},null,{"$f":"IF(AND(C10=\"\"),\"\",IF(AND(Master!$D$21=\"\"),\"\",Master!$D$21))","v":""},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C10)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C10+D10)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C10=\"\"),\"\",IF(AND(Master!$E$21=\"\"),\"\",Master!$E$21))","v":""},54120,{"$f":"IF(AND(C10=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$F$21))","v":4000},{"$f":"IF(AND(C10=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",Master!$G$21)))","v":3575},{"$f":"IF(AND(B10=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",IF(C10<18001,242,IF(C10<33501,402,IF(C10<54001,602,800))))))","v":602},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C10)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C10+D10)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C10=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C10=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C10=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$I$21))","v":0},{"$f":"IF(AND(C10=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$K$21))","v":0},{"$f":"IF(AND(C10=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!E25))","v":500},null,{"$f":"IF(AND(C10=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$L$21))","v":0},13033,41087,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JUN","2019-06-01",6,{"$f":"IF(AND(Master!D17=\"\"),\"\",Master!D17)","v":45100},45100,45100,5412]
[5,"2019-07-01",46500,{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C11=\"\"),\"\",ROUND(12%*C11,0)))","v":5580},{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C11=\"\"),\"\",ROUND(Master!$E$5%*C11,0)))","v":3720},{"$f":"IF(AND(C11=\"\"),\"\",IF(AND(Master!$B$21=\"\"),\"\",Master!$B$21))","v":""},{"$f":"IF(AND(C11=\"\"),\"\",IF(AND(Master!$C$21=\"\"),\"\",Master!$C$21))","v":""},null,{"$f":"IF(AND(C11=\"\"),\"\",IF(AND(Master!$D$21=\"\"),\"\",Master!$D$21))","v":""},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C11)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C11+D11)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C11=\"\"),\"\",IF(AND(Master!$E$21=\"\"),\"\",Master!$E$21))","v":""},55800,{"$f":"IF(AND(C11=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$F$21))","v":4000},{"$f":"IF(AND(C11=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",Master!$G$21)))","v":3575},{"$f":"IF(AND(B11=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",IF(C11<18001,242,IF(C11<33501,402,IF(C11<54001,602,800))))))","v":602},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C11)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C11+D11)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C11=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C11=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C11=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$I$21))","v":0},{"$f":"IF(AND(C11=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$K$21))","v":0},{"$f":"IF(AND(C11=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!F25))","v":500},null,{"$f":"IF(AND(C11=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$L$21))","v":0},13033,42767,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JUL","2019-07-01",7,{"$f":"IF(AND(Master!D18=\"\"),\"\",Master!D18)","v":"2019-03-01"},{"$f":"IF(AND(AR10=\"\"),0,MROUND(AR10*1.03,100))","v":46500},46500,{"$f":"ROUND(12%*AS11,0)","v":5580}]
[6,"2019-08-01",46500,{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C12=\"\"),\"\",ROUND(12%*C12,0)))","v":5580},{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C12=\"\"),\"\",ROUND(Master!$E$5%*C12,0)))","v":3720},{"$f":"IF(AND(C12=\"\"),\"\",IF(AND(Master!$B$21=\"\"),\"\",Master!$B$21))","v":""},{"$f":"IF(AND(C12=\"\"),\"\",IF(AND(Master!$C$21=\"\"),\"\",Master!$C$21))","v":""},null,{"$f":"IF(AND(C12=\"\"),\"\",IF(AND(Master!$D$21=\"\"),\"\",Master!$D$21))","v":""},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C12)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C12+D12)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C12=\"\"),\"\",IF(AND(Master!$E$21=\"\"),\"\",Master!$E$21))","v":""},55800,{"$f":"IF(AND(C12=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$F$21))","v":4000},{"$f":"IF(AND(C12=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",Master!$G$21)))","v":3575},{"$f":"IF(AND(B12=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",IF(C12<18001,242,IF(C12<33501,402,IF(C12<54001,602,800))))))","v":602},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C12)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C12+D12)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C12=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C12=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C12=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$I$21))","v":0},{"$f":"IF(AND(C12=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$K$21))","v":0},{"$f":"IF(AND(C12=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!G25))","v":1000},null,{"$f":"IF(AND(C12=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$L$21))","v":0},13533,42267,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUG","2019-08-01",8,{"$f":"IF(AND(Master!H18=\"\"),\"\",Master!H18)","v":"2020-02-01"},{"$f":"$AR$13","v":46500},46500,5580]
[7,"2019-09-01",46500,{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C13=\"\"),\"\",ROUND(12%*C13,0)))","v":5580},{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C13=\"\"),\"\",ROUND(Master!$E$5%*C13,0)))","v":3720},{"$f":"IF(AND(C13=\"\"),\"\",IF(AND(Master!$B$21=\"\"),\"\",Master!$B$21))","v":""},{"$f":"IF(AND(C13=\"\"),\"\",IF(AND(Master!$C$21=\"\"),\"\",Master!$C$21))","v":""},null,{"$f":"IF(AND(C13=\"\"),\"\",IF(AND(Master!$D$21=\"\"),\"\",Master!$D$21))","v":""},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C13)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C13+D13)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C13=\"\"),\"\",IF(AND(Master!$E$21=\"\"),\"\",Master!$E$21))","v":""},55800,{"$f":"IF(AND(C13=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$F$21))","v":4000},{"$f":"IF(AND(C13=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",Master!$G$21)))","v":3575},{"$f":"IF(AND(B13=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",IF(C13<18001,242,IF(C13<33501,402,IF(C13<54001,602,800))))))","v":602},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C13)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C13+D13)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C13=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C13=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C13=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$I$21))","v":0},{"$f":"IF(AND(C13=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$K$21))","v":0},{"$f":"IF(AND(C13=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!H25))","v":2000},null,{"$f":"IF(AND(C13=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$L$21))","v":0},14533,41267,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEP","2019-09-01",9,{"$f":"IF(AND(AR10=\"\"),\"\",MROUND(AR10*1.03,100))","v":46500},{"$f":"$AR$13","v":46500},46500,5580]
[8,"2019-10-01",46500,{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C14=\"\"),\"\",ROUND(12%*C14,0)))","v":5580},{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C14=\"\"),\"\",ROUND(Master!$E$5%*C14,0)))","v":3720},{"$f":"IF(AND(C14=\"\"),\"\",IF(AND(Master!$B$21=\"\"),\"\",Master!$B$21))","v":""},{"$f":"IF(AND(C14=\"\"),\"\",IF(AND(Master!$C$21=\"\"),\"\",Master!$C$21))","v":""},null,{"$f":"IF(AND(C14=\"\"),\"\",IF(AND(Master!$D$21=\"\"),\"\",Master!$D$21))","v":""},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C14)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C14+D14)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C14=\"\"),\"\",IF(AND(Master!$E$21=\"\"),\"\",Master!$E$21))","v":""},55800,{"$f":"IF(AND(C14=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$F$21))","v":4000},{"$f":"IF(AND(C14=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",Master!$G$21)))","v":3575},{"$f":"IF(AND(B14=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",IF(C14<18001,242,IF(C14<33501,402,IF(C14<54001,602,800))))))","v":602},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C14)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C14+D14)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C14=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C14=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C14=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$I$21))","v":0},{"$f":"IF(AND(C14=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$K$21))","v":0},{"$f":"IF(AND(C14=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!I25))","v":2000},null,{"$f":"IF(AND(C14=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$L$21))","v":0},14533,41267,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OCT","2019-10-01",10,null,46500,46500,5580]
[9,"2019-11-01",46500,{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C15=\"\"),\"\",ROUND(12%*C15,0)))","v":5580},{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C15=\"\"),\"\",ROUND(Master!$E$5%*C15,0)))","v":3720},{"$f":"IF(AND(C15=\"\"),\"\",IF(AND(Master!$B$21=\"\"),\"\",Master!$B$21))","v":""},{"$f":"IF(AND(C15=\"\"),\"\",IF(AND(Master!$C$21=\"\"),\"\",Master!$C$21))","v":""},null,{"$f":"IF(AND(C15=\"\"),\"\",IF(AND(Master!$D$21=\"\"),\"\",Master!$D$21))","v":""},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C15)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C15+D15)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C15=\"\"),\"\",IF(AND(Master!$E$21=\"\"),\"\",Master!$E$21))","v":""},55800,{"$f":"IF(AND(C15=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$F$21))","v":4000},{"$f":"IF(AND(C15=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",Master!$G$21)))","v":3575},{"$f":"IF(AND(B15=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",IF(C15<18001,242,IF(C15<33501,402,IF(C15<54001,602,800))))))","v":602},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C15)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C15+D15)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C15=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C15=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C15=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$I$21))","v":0},{"$f":"IF(AND(C15=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$K$21))","v":0},{"$f":"IF(AND(C15=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!J25))","v":4000},null,{"$f":"IF(AND(C15=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$L$21))","v":0},16533,39267,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOV","2019-11-01",11,null,46500,46500,5580]
[10,"2019-12-01",46500,{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C16=\"\"),\"\",ROUND(12%*C16,0)))","v":5580},{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C16=\"\"),\"\",ROUND(Master!$E$5%*C16,0)))","v":3720},{"$f":"IF(AND(C16=\"\"),\"\",IF(AND(Master!$B$21=\"\"),\"\",Master!$B$21))","v":""},{"$f":"IF(AND(C16=\"\"),\"\",IF(AND(Master!$C$21=\"\"),\"\",Master!$C$21))","v":""},null,{"$f":"IF(AND(C16=\"\"),\"\",IF(AND(Master!$D$21=\"\"),\"\",Master!$D$21))","v":""},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C16)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C16+D16)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C16=\"\"),\"\",IF(AND(Master!$E$21=\"\"),\"\",Master!$E$21))","v":""},55800,{"$f":"IF(AND(C16=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$F$21))","v":4000},{"$f":"IF(AND(C16=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",Master!$G$21)))","v":3575},{"$f":"IF(AND(B16=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",IF(C16<18001,242,IF(C16<33501,402,IF(C16<54001,602,800))))))","v":602},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C16)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C16+D16)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C16=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C16=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C16=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$I$21))","v":0},{"$f":"IF(AND(C16=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$K$21))","v":0},{"$f":"IF(AND(C16=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!K25))","v":1400},null,{"$f":"IF(AND(C16=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$L$21))","v":0},13933,41867,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEC","2019-12-01",12,null,46500,46500,5580]
[11,"2020-01-01",46500,{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C17=\"\"),\"\",ROUND(12%*C17,0)))","v":5580},{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C17=\"\"),\"\",ROUND(Master!$E$5%*C17,0)))","v":3720},{"$f":"IF(AND(C17=\"\"),\"\",IF(AND(Master!$B$21=\"\"),\"\",Master!$B$21))","v":""},{"$f":"IF(AND(C17=\"\"),\"\",IF(AND(Master!$C$21=\"\"),\"\",Master!$C$21))","v":""},null,{"$f":"IF(AND(C17=\"\"),\"\",IF(AND(Master!$D$21=\"\"),\"\",Master!$D$21))","v":""},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C17)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C17+D17)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C17=\"\"),\"\",IF(AND(Master!$E$21=\"\"),\"\",Master!$E$21))","v":""},55800,{"$f":"IF(AND(C17=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$F$21))","v":4000},{"$f":"IF(AND(C17=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",Master!$G$21)))","v":3575},{"$f":"IF(AND(B17=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",IF(C17<18001,242,IF(C17<33501,402,IF(C17<54001,602,800))))))","v":602},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C17)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C17+D17)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C17=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C17=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C17=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$I$21))","v":0},{"$f":"IF(AND(C17=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$K$21))","v":0},{"$f":"IF(AND(C17=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!L25))","v":1400},null,{"$f":"IF(AND(C17=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$L$21))","v":0},13933,41867,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JAN","2020-01-01",1,null,46500,46500,5580]
[12,"2020-02-01",46500,{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C18=\"\"),\"\",ROUND(12%*C18,0)))","v":5580},{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(C18=\"\"),\"\",ROUND(Master!$E$5%*C18,0)))","v":3720},{"$f":"IF(AND(C18=\"\"),\"\",IF(AND(Master!$B$21=\"\"),\"\",Master!$B$21))","v":""},{"$f":"IF(AND(C18=\"\"),\"\",IF(AND(Master!$C$21=\"\"),\"\",Master!$C$21))","v":""},null,{"$f":"IF(AND(C18=\"\"),\"\",IF(AND(Master!$D$21=\"\"),\"\",Master!$D$21))","v":""},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C18)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C18+D18)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C18=\"\"),\"\",IF(AND(Master!$E$21=\"\"),\"\",Master!$E$21))","v":""},55800,{"$f":"IF(AND(C18=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$F$21))","v":4000},{"$f":"IF(AND(C18=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",Master!$G$21)))","v":3575},{"$f":"IF(AND(B18=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",IF(C18<18001,242,IF(C18<33501,402,IF(C18<54001,602,800))))))","v":602},{"$f":"IF(AND(Master!I$5=Master!V$2),\"\",IF(AND(Master!I$4=Master!Y$3),ROUND((C18)*0.1,0),IF(AND(Master!I$5=Master!V$3),ROUND((C18+D18)*0.1,0),\"\")))","v":""},{"$f":"IF(AND(C18=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C18=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$H$21))","v":2178},{"$f":"IF(AND(C18=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$I$21))","v":0},{"$f":"IF(AND(C18=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$K$21))","v":0},{"$f":"IF(AND(C18=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!M25))","v":100},null,{"$f":"IF(AND(C18=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",Master!$L$21))","v":0},{"$f":"IF(AND(B18=\"\"),\"\",SUM(M18:W18))","v":12633},{"$f":"IF(AND(B18=\"\"),\"\",IF(AND(L18=\"\",X18=\"\"),\"\",SUM(L18-X18)))","v":43167},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FEB","2020-02-01",2,null,46500,46500,5580]
[13,"Bonus",null,null,null,null,null,{"$f":"IF(AND(Master!I3=\"\"),\"\",IF(AND(Master!I3=Master!S2),Master!J3,IF(AND(Master!I3=Master!S3),\"0\",\"\")))","v":6774},null,null,null,{"$f":"IF(AND(B19=\"\"),\"\",SUM(C19,D19,E19,F19,G19,I19,K19,H19))","v":6774},null,null,null,null,null,null,null,null,null,null,null,0,6774]
[14,"PL Surrender",{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(Master!E2=Master!S3,0,VLOOKUP(Master!I2,AO7:AU19,5,0))/2)","v":23250},{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(Master!E2=Master!S3,0,VLOOKUP(Master!I2,AO7:AU19,7,0))/2)","v":2790},null,null,null,null,null,null,null,{"$f":"IF(AND(B20=\"\"),\"\",SUM(C20,D20,E20,F20,G20,I20,K20,H20))","v":26040},null,null,null,null,null,null,null,null,null,null,null,0,26040]
[15,"DA Arrear",null,{"$f":"IF(AND(Master!$I$4=Master!$Y$3),\"\",(ROUND(12%*AS7,0)-ROUND(9%*AS7,0))*2)","v":2706},null,null,null,null,null,{"$f":"IF(AND(B21=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),ROUND((C21+D21)*0.1,0),\"\")))","v":""},null,2706,null,{"$f":"IF(AND(D21=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",D21)))","v":2706},null,{"$f":"IF(AND(B21=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),ROUND((C21+D21)*0.1,0),\"\")))","v":""},null,null,null,null,null,null,null,2706,0]
[16,"DA Arrear",null,null,null,null,null,null,null,{"$f":"IF(AND(B22=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),ROUND((C22+D22)*0.1,0),\"\")))","v":""},null,0,null,{"$f":"IF(AND(D22=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),\"\",D22)))","v":""},null,{"$f":"IF(AND(B22=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),ROUND((C22+D22)*0.1,0),\"\")))","v":""},null,null,null,null,null,null,null,0,0]
[17,null,null,null,null,null,null,null,null,{"$f":"IF(AND(B23=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),ROUND((C23+D23)*0.1,0),\"\")))","v":""},null,"",null,null,null,{"$f":"IF(AND(B23=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),ROUND((C23+D23)*0.1,0),\"\")))","v":""},null,null,null,null,null,null,null,"",""]
[18,null,null,null,null,null,null,null,null,{"$f":"IF(AND(B24=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),ROUND((C24+D24)*0.1,0),\"\")))","v":""},null,"",null,null,null,{"$f":"IF(AND(B24=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),ROUND((C24+D24)*0.1,0),\"\")))","v":""},null,null,null,null,null,null,null,"",""]
[19,null,null,null,null,null,null,null,null,{"$f":"IF(AND(B25=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),ROUND((C25+D25)*0.1,0),\"\")))","v":""},null,"",null,null,null,{"$f":"IF(AND(B25=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),ROUND((C25+D25)*0.1,0),\"\")))","v":""},null,null,null,null,null,null,null,"",""]
[20,null,null,null,null,null,null,null,null,{"$f":"IF(AND(B26=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),ROUND((C26+D26)*0.1,0),\"\")))","v":""},null,"",null,null,null,{"$f":"IF(AND(B26=\"\"),\"\",IF(AND(Master!$I$4=Master!$Y$3),\"\",IF(AND(Master!$I$5=Master!$V$3),ROUND((C26+D26)*0.1,0),\"\")))","v":""},null,null,null,null,null,null,null,"",""]
["G.Total",null,{"$f":"SUM(C7:C26)","v":575650},{"$f":"SUM(D7:D26)","v":71784},44192,0,0,6774,0,0,0,698400,48000,45606,7190,0,26136,26136,0,0,14600,220,0,167888,530512]
[]
[null,null,null,"Signature",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signature and Seal DDO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F30=\"\"),\"\",IF(AND($K$8=\"\"),\"\",$K$8))","v":""}]

{"sheet":"Extra deduc","index":2,"n_rows":41,"n_cols":41,"rows_kept":41,"cut":false,"hidden":true,"merged":[[34,4,34,5],[35,4,35,5],[36,4,36,5],[36,7,37,7],[24,0,24,7],[27,4,27,6],[29,7,30,7],[30,4,30,5],[31,4,31,5],[31,7,32,7],[20,7,20,8],[10,4,10,5],[10,7,10,8],[11,4,11,5],[11,7,11,8],[12,7,12,8],[13,7,13,8],[14,7,14,8],[15,7,15,8],[17,7,17,8],[18,7,18,8],[19,7,19,8],[7,4,7,5],[7,7,7,8],[8,4,8,5],[8,7,8,8],[9,4,9,5],[9,7,9,8],[6,4,6,5],[6,7,6,8],[1,4,1,9],[2,4,3,9],[4,7,4,8],[5,4,5,5],[5,7,5,8]]}
[]
[null,null,null,null,"Deduction Detail"]
[null,null,null,null,"osru dVkSrh ds vfrfjDr dVkSfr;k ftlds rgr vki vk;dj esa NwV pkgrs gSa] rFkk vfrfjDr ¼vU;½ vk; dks ;gkW ij bUnzkt djsA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO"]
[null,null,null,null,"1- edku fdjk;k HkRrk ¼ vxj jlhn ds ek/;e ls                                                  NwV ysuh gS rks YES ugh rks No lysDV djsA½","NO",{"$f":"IF(AND(F5=\"\"),\"0\",IF(AND(F5=AO4),\"0\",G32))","v":"0"},"18- vU; vk; /kkjk "]
[null,null,null,null,"2- euksjatu Hkrk /kkjk 16 (ii) ds vUrxZr ",null,null,"19- /kkjk 80CCC - isa'ku Iyku gsrq va'knku"]
[null,null,null,null,"3- O;o;k; dj /kkjk 16 ¼iii½ ds vUrxrZ ",null,null,"20- vU; tek jkf'k ¼/kkjk 80 lh ds vUrxZr½"]
[null,null,null,null,"4- x`g lEifr ls izkIr fdjk;k & vk;",null,null,"21- /kkjk 80CCD(1B) -uohu isa'ku ;kstuk esa vfrfjDr va'knku ¼vf/kdre :- 50]000½"]
[null,null,null,null,"5- x`gdj ",null,null,"22- /kkjk 80D - fpfdRlk chek izhfe;e "]
[null,null,null,null,"6- x`g _.k dh ewy fdLr ;gkW fy[kuh gSaA tks NwV ysuh gSaA",null,null,"23- /kkjk 80DD - fodykax vkfJrksa ds fpfdRlk mipkj "]
[null,null,null,null,"7- x`g _.k fdLr ij C;kt tks NwV ysuk gS] ;gkW fy[ksA",null,null,"24- /kkjk 80DDB - fof'k\"V jksxksa ds mipkj gsrq dVkSrh ¼vf/kdre 40000 :½"]
[null,null,null,null,"8- thou chek izhfe;e ¼tks osru ls ugh dkVk x;k½ LIC",null,null,"25- /kkjk 80E - mPp f'k{kk gsrq fy, _.k dk C;kt ¼/kkjk 80E½"]
[null,null,null,null,"9- ih-,y-vkbZ- (PLI)",null,null,"26- /kkjk 80G - /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼d Js.kh 100% ,oa [k Js.kh 50%½"]
[null,null,null,null,"10- V;w'ku Qhl (Tution Fees)",null,null,"27- /kkjk 80U - LFkkbZ :i ls 'kkjhfjd vleFkZrrk "]
[null,null,null,null,"11- ;w- ,y- vkbZ- ih-@okf\"kZd Iyku",null,null,"28- /kkjk 80TTA - cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)"]
[null,null,null,null,"12- jk\"Vªh; cpr i= (NSC)",null,null,"29- /kkjk 80 GGA - vuqeksfnr oSKkfud]lkekftd]xzkeh.k fodkl vkfn gsrq fn;k x;k nku"]
[null,null,null,null,"13- jk\"Vªh; cpr i= ij vnr C;kt",null,null,"30- jkgr /kkjk 89 ds rgr   ¼ vxj NwV ysuh gS rks YES ugh rks No lysDV djsA½","NO",0]
[null,null,null,null,"14- yksd Hkfo\"; fuf/k (PPF)",null,null,"31- bfDoVh fyad lsfoax Ldhe"]
[null,null,null,null,"15- jk\"Vªh; cpr Ldhe (NSS)",null,null,"32- LFkfxr okf\"kZdh"]
[null,null,null,null,"16- lqdU;k le`f) ;kstuk (SSY)",null,null,"33- osru ds vykok tek djk;k x;k aavk;dj (TDS)"]
[null,null,null,null,"17- vU; dksbZ izdkj dh dVkSrh (OTHER)",null,null,"34- vU; dksbZ Hkh izdkj NqV feyrh gSa tks /kkjk 10¼13&,½ o 10¼13½ds vUrxZr vkrh gks rks ;gk fy[ksA          ,oa vU; dj eqDr HkRrk ;gkW fy[ksaA"]
[]
[null,null,null,null,null,null,"For HRA"]
[]
["    edku fdjk;k NwV ds fy, jlhn dh vko';drk gks rks funsZ'kksa dh ikyuk djrs gq, jlhn dh jkf'k izkIr dj ldrs gSaA"]
["MONTHS","\"Y\"","Basic Pay.","HRA","E   Please select months by typing \"Y\" "]
["MARCH 19","Y",{"$f":"'GA 55'!C7","v":45100},{"$f":"'GA 55'!E7","v":3608}]
["APRIL 19","Y",{"$f":"'GA 55'!C8","v":45100},{"$f":"'GA 55'!E8","v":3608},"After selecting months, give rent paid amount. "]
["MAY 19","Y",{"$f":"'GA 55'!C9","v":45100},{"$f":"'GA 55'!E9","v":3608},null,null,null,"funsZ'k"]
["JUNE 19","Y",{"$f":"'GA 55'!C10","v":45100},{"$f":"'GA 55'!E10","v":3608},null,null,null,"E vxj vkidks izfrekg jlhn dh jkf'k ls de jkf'k dh NwV ysuh gSa rks lkeusa lQsn dyj dh lSy F31 esa izfrekg ds vuqlkj jlhn jkf'k fy[k ldrs gSaA"]
["JULY 19","Y",{"$f":"'GA 55'!C11","v":46500},{"$f":"'GA 55'!E11","v":3720},"RENT PAID AMOUNT MONTHLY   F",null,{"$f":"G37","v":8480}]
["AUGUST 19","Y",{"$f":"'GA 55'!C12","v":46500},{"$f":"'GA 55'!E12","v":3720},"HRA EXEMPTION AMOUNT     F",null,{"$f":"IF((G31*12)>C39*10%, MIN(ROUND(G31*12-(C39)*10%,0),G35),0)","v":44192},"P fu;ekuqlkj NwV ysuh gSa rks dqN Hkh ugh fy[kuk gSa A lkeus okyh jkf'k ftl ij LVkj yxk gqvk gSa ] og vij izFke dkWye esa lSy ua- F5  esa Lor% vk tk;sxhA"]
["SEPTEMBER 19","Y",{"$f":"'GA 55'!C13","v":46500},{"$f":"'GA 55'!E13","v":3720}]
["OCTOBER 19","Y",{"$f":"'GA 55'!C14","v":46500},{"$f":"'GA 55'!E14","v":3720}]
["NOVEMBER 19","Y",{"$f":"'GA 55'!C15","v":46500},{"$f":"'GA 55'!E15","v":3720},"Max. HRA exemption amount    F",null,{"$f":"D39","v":44192},"E ;g jkf'k tks vkius bl o\"kZ ¼12 ekg½ esa HRA (edku fdjk;k HkÙkk½ ds :Ik esa mBkyh gSA"]
["DECEMBER 19","Y",{"$f":"'GA 55'!C16","v":46500},{"$f":"'GA 55'!E16","v":3720},"Rent receipt required for max. exemption     F",null,{"$f":"ROUND(((10%*C39)+D39),0)","v":101757},"E ;g iwjs o\"kZ ¼12 ekg½ dh HRA dh jlhn jkf'k cuh gSA"]
["JANUARY 20","Y",{"$f":"'GA 55'!C17","v":46500},{"$f":"'GA 55'!E17","v":3720},"House Rent Per Month        F",null,{"$f":"ROUND(G36/B39, 0)","v":8480},"Eizfrekg jlhn dh jkf'k ¼vxj fdlh ;wtj us lQsn dyj esa vk jgh vkVks jkf'k dks gVk fn;k gSa ;k fMfyV dj fn;k gks rks ;g jkf'k lSy F31 esa fy[k nsossA ½"]
["FEBRUARY 18","Y",{"$f":"'GA 55'!C18","v":46500},{"$f":"'GA 55'!E18","v":3720}]
["TOTAL ",{"$f":"COUNTIF(B27:B38, \"Y\")","v":12},{"$f":"ROUND((SUM(C27:C38)),0)+C40","v":575650},{"$f":"ROUND((SUM(D27:D38)),0)+D40","v":44192},"E viuh vko';drkuqlkj ekg ?kVk c<+k ldrsa gSA"]
[null,null,{"$f":"SUM('GA 55'!C20:C26)+SUM('GA 55'!E20:E26)","v":23250},{"$f":"SUM([1]Bills!F23:F27)","v":0}]
[null,null,null,null,"If required",null,{"$f":"IF((G31*12)>('[1]GA55 Summry'!C26+'[1]GA55 Summry'!D26)*10%, MIN(ROUND(G31*12-('[1]GA55 Summry'!C26+'[1]GA55 Summry'!D26)*10%,0),G35),0)","v":33080}]

{"sheet":"COMPUTATION","index":3,"n_rows":79,"n_cols":25,"rows_kept":79,"cut":false,"hidden":true,"merged":[[61,12,61,13],[62,0,62,12],[64,11,64,13],[56,2,56,12],[57,1,57,12],[58,1,58,12],[59,1,59,12],[60,0,61,0],[60,1,61,3],[60,4,60,6],[60,7,60,8],[60,10,60,11],[60,12,60,13],[49,5,49,7],[49,9,49,11],[50,1,50,3],[50,5,50,7],[50,9,50,11],[51,1,51,3],[51,5,51,7],[51,9,51,11],[61,4,61,6],[61,7,61,8],[61,10,61,11],[45,1,45,12],[46,1,46,12],[47,0,57,0],[47,1,47,14],[48,1,48,4],[48,5,48,8],[48,9,48,12],[49,1,49,3],[34,0,43,0],[34,1,34,14],[35,1,35,12],[36,1,36,12],[37,1,37,12],[38,1,38,12],[39,1,39,12],[40,1,40,12],[41,1,41,12],[42,1,42,12],[52,1,52,3],[52,5,52,7],[52,9,52,11],[53,1,53,12],[54,1,54,12],[55,1,55,12],[25,2,25,4],[25,8,25,10],[26,2,26,4],[26,8,26,10],[27,2,27,4],[27,8,27,10],[30,17,37,21],[43,1,43,12],[44,1,44,12],[21,8,21,10],[22,2,22,4],[22,8,22,10],[23,2,23,4],[23,8,23,10],[24,2,24,4],[24,8,24,10],[16,1,16,12],[17,0,33,0],[17,1,17,14],[18,1,18,14],[19,2,19,4],[19,8,19,10],[19,13,29,14],[20,2,20,4],[20,8,20,10],[21,2,21,4],[28,2,28,4],[28,8,28,10],[29,1,29,10],[30,1,30,12],[31,1,31,12],[32,1,32,12],[33,1,33,12],[14,1,14,3],[14,4,14,6],[14,9,14,12],[15,1,15,3],[15,4,15,6],[15,10,15,12],[10,13,12,14],[11,1,12,2],[11,3,11,4],[11,5,11,7],[11,8,11,9],[11,10,11,12],[12,3,12,4],[12,5,12,7],[12,8,12,9],[12,10,12,12],[3,17,6,21],[4,1,4,12],[5,1,5,12],[6,0,8,0],[6,1,6,9],[6,10,6,12],[6,13,7,14],[7,1,7,9],[7,10,7,12],[74,2,74,10],[75,2,75,10],[73,2,73,10],[76,2,76,10],[77,2,77,10],[78,2,79,10],[0,0,0,14],[1,2,1,5],[1,6,1,7],[1,8,1,10],[1,11,1,12],[2,1,2,2],[2,3,2,7],[2,9,2,11],[2,13,2,14],[8,1,8,9],[8,10,8,12],[9,1,9,12],[10,0,12,0],[10,1,10,7],[10,8,10,9],[10,10,10,12],[3,1,3,12],[13,1,13,12]]}
[{"$f":"IF(AND(Master!D8=\"\"),\"\",CONCATENATE(\"Office Name :- \",PROPER(Master!D8)))","v":"Office Name :- Government Sr. Secondary School Inderwara , Rani (Pali)"}]
[null,null,"vk;dj x.kuk izi= o\"kZ",null,null,null,"2019-20",null,"¼dj fu/kkZj.k o\"kZ",null,null,"2020-21",null,"½"]
[1,"uke deZpkjh %",null,{"$f":"UPPER(IF(Master!D9=\"\",\"\",Master!D9))","v":"HEERALAL JAT"},null,null,null,null," in %",{"$f":"UPPER(IF(Master!H9=\"\",\"\",Master!H9))","v":"SR TEACHER"},null,null,"PAN :",{"$f":"UPPER(IF(Master!D12=\"\",\"\",Master!D12))","v":"ADTXXXXXX2"}]
[2,"vk; %  o\"kZ&2019&20 esa izkIr dqy osru ¼ dj ;ksX; lqfo/kkvksa ds eqY; lfgr ½",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"'GA 55'!L27+'GA 55'!J27","v":698400},null,"E","ljdkj }kjk tks jkf'k NPS esa tek djkbZ xbZ gSa] og jkf'k ;gkW dqy vk; esa n'kkZ;h xbZ gSaA"]
[3,"x`g fdjk;k] /kkjk 10¼13-A½ ds vUrxrZ ,oa /kkjk 10¼14½ds vUrxrZ vU; Hkrs tks dj eqDÙk gSA ",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"'Extra deduc'!G5+'GA 55'!G27","v":0}]
[4,"                                                              'ks\"k ¼2&3½",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"O4-O5","v":698400}]
[5," ¼i½euksjatu Hkrk /kkjk 16 ¼ii½ ds vUrxrZ ",null,null,null,null,null,null,null,null,{"$f":"'Extra deduc'!G6","v":0}]
[null," ¼ii½ O;o;k; dj /kkjk 16 ¼iii½ ds vUrxrZ ",null,null,null,null,null,null,null,null,{"$f":"'Extra deduc'!G7","v":0}]
[null," ¼iii½ LVs.MMZ fMMsD'ku (Standard Deduction)  50]000 ¼vf/kdre½",null,null,null,null,null,null,null,null,50000,null,null,"#-",{"$f":"SUM(K7:M9)","v":50000}]
[6,"                                                           'ks\"k ¼4&5½",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"O6-O9","v":648400}]
[7,"¼v½x`g lEifr ls vk;%¼1½ Loa; ds mi;ksx esa &'kwU;",null,null,null,null,null,null,"¼2½ izkIr fdjk;k #-",null,{"$f":"'Extra deduc'!G8","v":0}]
[null,"¼c½ ?kVk;sa ",null," fdjk;s dk 30%",null," x`g _.k ij C;kt",null,null," x`gdj ",null,"  ;ksx 7¼c½"]
[null,null,null,{"$f":"ROUND(K11*0.3,0)","v":0},null,{"$f":"'Extra deduc'!G11","v":0},null,null,{"$f":"'Extra deduc'!G9","v":0},null,{"$f":"D13+F13+I13","v":0}]
[null," 'ks\"k &@$¼7¼v½ ,oa ;ksx 7¼c½ dk½  ",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"K11-K13","v":0}]
[8,"cpr [kkrs ij C;kt %",null,null,{"$f":"'Extra deduc'!J15","v":0},null,null,null,null,"dqy 'ks\"k &@$¼6,oa 7½",null,null,null,"#-",{"$f":"O10+O14","v":648400}]
[9,"vU; vk;  %",null,null,{"$f":"'Extra deduc'!J5","v":0},null,null,null,null,null," ;ksx ¼8$9½",null,null,"#-",{"$f":"E15+E16","v":0}]
[10,"ldy vk;                                                                                     ",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"O15+O16","v":648400}]
[11,"?kVkb;s dVkSSfr;k¡ %& /kkjk US 80C, 80CCC,80CCD (1)"]
[null,"(A) vf/kdre lhek 1]50]000@& ¼/kkjk 80CCE ½ ] ¼/kkjk 80CCD (2), ds vykok"]
[null,"(i)","jkT; chek ¼SI)",null,null,"#-",{"$f":"'GA 55'!M27","v":48000},"(xi)","isa'ku ;kstuk esa va'knku ECPF /kkjk 80ccd(1½\n",null,null,"#-",{"$f":"'GA 55'!P27","v":0}]
[null,"(ii)","thou chek izhfe;e ¼LIC)",null,null,"#-",{"$f":"'GA 55'!Q27","v":26136},"(xii)","isa'ku Iyku gsrq va'knku ¼/kkjk 80ccc½",null,null,"#-",{"$f":"'Extra deduc'!J6","v":0}]
[null,"(iii)","jk\"Vªh; cpr i= ¼NSC)",null,null,"#-",{"$f":"'Extra deduc'!G16","v":0},"(xiii)","jk\"Vªh; cpr i= ij vnr C;kt",null,null,"#-",{"$f":"'Extra deduc'!G17","v":0}]
[null,"(iv)","yksd Hkfo\"; fuf/k ¼PPF)",null,null,"#-",{"$f":"'Extra deduc'!G18","v":0},"(xiv)","V;w'ku Qhl ",null,null,"#-",{"$f":"'Extra deduc'!G14","v":0}]
[null,"(v)","jk\"Vªh; cpr Ldhe ¼NSS)",null,null,"#-",{"$f":"'Extra deduc'!G19","v":0},"(xv)","bfDoVh fyad lsfoax Ldhe",null,null,"#-",{"$f":"'Extra deduc'!J18","v":0}]
[null,"(vi)","lkekU; izko/kk;h fuf/k ¼GPF)",null,null,"#-",{"$f":"'GA 55'!N27","v":45606},"(xvi)","LFkfxr okf\"kZdh ¼Defferred Annuty)",null,null,"#-",{"$f":"'Extra deduc'!J19","v":0}]
[null,"(vii)","lkewfgd chek izhfe;e ¼G.Ins.)",null,null,"#-",{"$f":"'GA 55'!V27","v":220},"(xvii)","ih-,y-vkbZ- ¼PLI)",null,null,"#-",{"$f":"'Extra deduc'!G13","v":0}]
[null,"(viii)",";w- ,y- vkbZ- ih-@okf\"kZd Iyku",null,null,"#-",{"$f":"'Extra deduc'!G15","v":0},"(xviii)","vU; tekjkf'k ¼/kkjk 80 lh ds vUrxZr½",null,null,"#-",{"$f":"'Extra deduc'!J7","v":0}]
[null,"(ix)","x`g _.k fdLr ¼HBA Premium)",null,null,"#-",{"$f":"'Extra deduc'!G10","v":0},"(xix)","lqdU;k le`f) ;kstuk esa tek jkf'k",null,null,"#-",{"$f":"'Extra deduc'!G20","v":0}]
[null,"(x)","osru ls vfrfjDr thou chek (Extra LIC)",null,null,"#-",{"$f":"'Extra deduc'!G12","v":0},"(xx)","vU;",null,null,"#-",{"$f":"'Extra deduc'!G21","v":0}]
[null,";ksx ( i ls xviii )",null,null,null,null,null,null,null,null,null,"#-",{"$f":"SUM(G20:G29)+SUM(M20:M29)","v":119962}]
[null,"                        vf/kdre dVkSrh dh jkf'k 1-50 yk[k #i, rd",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"IF(M30<150001,ROUND(M30,0),150000)","v":119962},null,null,"ljdkj }kjk tks jkf'k NPS esa tek djkbZ xbZ gSa] og jkf'k 1]50yk[k ls vfrfjDr vk;dj es NwV ds nk;jsa esa vkrh gSa A blfy, ;g jkf'k dkWye la[;k 11(B) esa /kkjk 80CCD(2) ds rgr i`FkDd NwV esa n'kkZ;h xbZ gSaA"]
[null,"(B) ?kVkb;s& /kkjk 80CCD(2) fu;ksDrk }kjk isa'ku va'knku dh jkf'k ¼vf/kdre osru dk 10%) i`Fkd ls NwV",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M20","v":0},null,"E"]
[null,"(C) ?kVkb;s & /kkjk 80CCD (1B) uohu isa'ku ;kstuk esa vfrfjDr va'knku ¼vf/kdre :- 50]000)",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"'Extra deduc'!J8","v":0}]
[null,";ksx 11(A+B+C)      ",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"SUM(O31:O33)","v":119962}]
[12," vU; dVkSfr;k¡"]
[null,"1-/kkjk 80 D fpfdRlk chek izhfe;e ¼Lo;a]ifr@iRuh o cPpksa ds fy, : 25000] ekrk&firk ds fy, : 25000]lhfu;j flVhtu : 50000½",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"'Extra deduc'!J9","v":0}]
[null,"2- /kkjk 80DD fodykax vkfJrksa ds fpfdRlk mipkj ¼vf/kdre 75]000 rFkk 80% ;k vf/kd fodykaxrk 125]000½",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"'Extra deduc'!J10","v":0}]
[null,"3- /kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"'Extra deduc'!J11","v":0}]
[null,"4- /kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"'Extra deduc'!J12","v":0}]
[null,"5- /kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"'Extra deduc'!J13","v":0}]
[null,"6- /kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"'Extra deduc'!J14","v":0}]
[null,"7- /kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)  , ( ofj\"B ukxfjdks C;kt ij NwV 50000rd ½",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"IF('Extra deduc'!J15<10001, 'Extra deduc'!J15, 10000)","v":0}]
[null,"8- /kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"'Extra deduc'!J16","v":0}]
[null,"dqy ;ksx 12 ¼ 1 ls 8 rd ½",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"SUM(O36:O43)","v":0}]
[13,"dqy dVkSrh ( 11 + 12)",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"O34+O44","v":119962}]
[14,"dj ;ksX; vk; ( 10 - 13 )",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"(O17-O45)","v":528438}]
[15,"dqy vk; dh jkf'k dks lEiw.kZ djuk ¼ nl ds xq.kd esa ½ /kkjk 288A",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"ROUND(O46,-1)","v":528440}]
[16," vk;dj dh x.kuk  mijksDr dkWye 15 ds vk/kkj ij"]
[null,",d O;fDr dj nkrk",null,null,null,"ofj\"B ukxfjd ¼60 ls 80 o\"kZ rd½",null,null,null,"80 o\"kZ ;k vf/kd vk;q"]
[null,"2,50,000 rd",null,null,"Nil","3,00,000 rd",null,null,"Nil",null,null,null,null,"#-",0,null,null,null,null,null,null,null,{"$f":"ROUND(IF(O47<=250000,0,IF(O47>=500000,12500,IF(O47<=500000,0+(O47-250000)*0.05))),0)","v":12500},{"$f":"ROUND(IF(O47<=300000,0,IF(O47>=500000,10000,IF(O47<=500000,(O47-300000)*0.05))),0)","v":10000},0]
[null,"2,50,001-5,00,000",null,null,0.05,"3,00,001-5,00,000",null,null,0.05,"5,00,000 rd",null,null,"Nil","#-",{"$f":"W50","v":12500},null,null,null,null,null,null,null,{"$f":"ROUND(IF(O47<=500000,0,IF(O47>=1000000,100000,IF(O47<=1000000,(O47-500000)*0.2,\"0\"))),0)","v":5688},{"$f":"ROUND(IF(O47<=500000,0,IF(O47>=1000000,100000,IF(O47<=1000000,(O47-500000)*0.2,\"0\"))),0)","v":5688},{"$f":"ROUND(IF(O47<=500000,0,IF(O47>=1000000,100000,IF(O47<=1000000,(O47-500000)*0.2,\"0\"))),0)","v":5688}]
[null,"5,00,001-10,00,000",null,null,0.2,"5,00,001-10,00,000",null,null,0.2,"5,00,001-10,00,000",null,null,0.2,"#-",{"$f":"W51","v":5688},null,null,null,null,null,null,null,{"$f":"ROUND(IF(O47>1000000,(O47-1000000)*0.3,\"0\"),0)","v":0},{"$f":"ROUND(IF(O47>1000000,(O47-1000000)*0.3,\"0\"),0)","v":0},{"$f":"ROUND(IF(O47>1000000,(O47-1000000)*0.3,\"0\"),0)","v":0}]
[null,"10,00,001 ,oa vf/kd",null,null,0.3,"10,00,000 ls vf/kd",null,null,0.3,"10,00,000 ls vf/kd",null,null,0.3,"#-",{"$f":"W52","v":0},null,null,null,null,null,null,null,{"$f":"ROUND(IF(O47<=250000,0,IF(O47<=500000,(O47-250000)*0.05,IF(O47<=1000000,12500+(O47-500000)*0.2,IF(O47>1000000,112500+(O47-1000000)*0.3,\"0\")))),0)","v":18188},{"$f":"ROUND(IF(O47<=300000,0,IF(O47<=500000,(O47-300000)*0.05,IF(O47<=1000000,10000+(O47-500000)*0.2,IF(O47>1000000,110000+(O47-1000000)*0.3,\"0\")))),0)","v":15688},{"$f":"ROUND(IF(O47<=250000,0,IF(O47<=500000,(O47-250000)*0.05,IF(O47<=1000000,0+(O47-500000)*0.2,IF(O47>1000000,100000+(O47-1000000)*0.3,\"0\")))),0)","v":5688}]
[null,"¼1½ ;ksx vk;dj",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"SUM(O50:O53)","v":18188}]
[null,"¼2½ NwV ?kkjk 87¼A½ ¼ 5yk[k rd dh dj ;ksX; vk; ij vk;dj dh NwV vf/kdre :- 12500@& rd½",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"IF(O47>500000,0,IF(O54<12500,O54,12500))","v":0}]
[null,"¼3½ 'ks\"k vk;dj ¼1&2½",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"O54-O55","v":18188},null,null,null,null,null,null,null,null,{"$f":"IF(T59>350000,0,IF(T59<2501,T59,2500))","v":0}]
[null,"¼4½ ","f'k{kk ,oa fpfdRlk midj  4%  ¼vk;dj ij ½",null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"ROUND((O56*0.04),0)","v":728}]
[null,"                                                             dqy vk;dj ¼3$4½",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"SUM(O56:O57)","v":18916}]
[17,"?kVkb;s  %& jkgr /kkjk 89 ds rgr ",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"'Extra deduc'!J17","v":0}]
[18,"dqy 'ks\"k vk;dj",null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"O58-O59","v":18916},null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(O47<250001,0,IF(O47>500000,12500,((O47-250000)*0.05))),IF(O47<300001,0,IF(O47>500000,10000,((O47-300000)*0.05))))","v":12500}]
[19," vk;dj dVkSrh\n dk fooj.k",null,null,"flrEcj 2019\nrd  :i;s",null,null,"vDVq- 2019 ls fnl- 2019\nrd  :i;s",null,"tuojh 2020\nesa dqy :i;s","Qjojh 2020\nessa dqy :i;s",null,",fj;j ls Vh-Mh-,l-\no vU; -",null,"dqy;ksx dkWye 19 "]
[null,null,null,null,{"$f":"SUM('GA 55'!U7:U13)","v":5700},null,null,{"$f":"SUM('GA 55'!U14:U16)","v":7400},null,{"$f":"'GA 55'!U17","v":1400},{"$f":"'GA 55'!U18","v":100},null,{"$f":"SUM('GA 55'!U21:U26)+'Extra deduc'!J20","v":0},null,{"$f":"'Extra deduc'!J20+'GA 55'!U27","v":14600}]
[{"$f":"IF(O60>O62,\"Income Tax Payable\",IF(O60<O62,\"Income Tax Refundable\",\"Income Tax Payble/Refundable\"))","v":"Income Tax Payable"},null,null,null,null,null,null,null,null,null,null,null,null,"#-",{"$f":"IF(O60>O62,O60-O62,O62-O60)","v":4316}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"gLrk{kj dkfeZd"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"This Micro software Developed by:  HEERALAL JAT "]
[null,null,"Senior Teacher"]
[null,null,"Government Senior Secondary School INDERWARA , PALI"]
[null,null,"Dist- Pali"]
[null,null,"heeralaljatchandawal@gmail.com"]
[null,null,"V./P. - Chandawal Nagar, Teh.- sojat city, Dist.- Pali (Raj) 306306"]