{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["DA S0FTWARE","code","Compatibility Report"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":1,"comments":2,"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":"DA S0FTWARE","index":0,"n_rows":57,"n_cols":24,"rows_kept":57,"cut":false,"hidden":false,"merged":[[43,9,46,9],[5,17,5,18],[16,17,17,18],[7,9,8,9],[9,9,11,9],[12,9,14,9],[15,9,17,9],[30,9,32,9],[4,1,4,4],[4,5,4,11],[4,12,4,15],[6,20,20,21],[6,17,6,18],[11,17,11,18],[15,17,15,18],[18,17,18,18],[26,1,28,1],[29,1,31,1],[32,1,34,1],[1,1,1,3],[7,1,10,1],[11,1,13,1],[14,1,16,1],[17,1,19,1],[2,1,2,4],[5,1,5,15],[2,12,2,15],[2,5,2,11],[18,9,20,9],[3,1,3,4],[3,5,3,11],[3,12,3,15],[48,1,48,15],[49,1,49,15],[33,9,35,9],[36,9,38,9],[39,9,42,9],[47,9,47,15],[44,1,46,1],[35,1,37,1],[38,1,40,1],[6,8,47,8],[41,1,43,1],[21,9,23,9],[24,9,26,9],[27,9,29,9],[20,1,22,1],[23,1,25,1]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(DAY(DATE(code!M8,code!K8,1)),\"-\",MONTH(DATE(code!M8,code!K8,1)),\"-\",YEAR(DATE(code!M8,code!K8,1)))","v":"1-1-2015"},{"$f":"code!M8","v":"1905-07-07"}]
[null,"President",null,null,null,"Greneral Secretary",null,null,null,null,null,null,"Finance Secratary"]
[null,{"$f":"S29","v":0},null,null,null,{"$f":"S30","v":0},null,null,null,null,null,null,{"$f":"S31","v":0}]
[null,{"$f":"T29","v":0},null,null,null,{"$f":"T30","v":0},null,null,null,null,null,null,{"$f":"T31","v":0}]
[null,{"$f":"CONCATENATE(\"D.A enhanced from \",S9*100,\"%  to \",S8*100,\"%. \",\"Enhancement : \",(S8-S9)*100,\"% \",\"The D.A arrears from \",DAY(DATE(code!M8,code!K8,1)),\"-\",MONTH(DATE(code!M8,code!K8,1)),\"-\",YEAR(DATE(code!M8,code!K8,1)),\" to \",IF(code!R8=3,code!Q6,CONCATENATE(code!E22,\"-\",MONTH(code!T22),\"-\",YEAR(code!T22))),\" will be adjusted to the \",code!S8,\" Accounts. Cash will be paid from \",IF(code!R8=3,CONCATENATE(DAY(code!T3),\"-\",MONTH(code!T3),\"-\",YEAR(code!T3)),CONCATENATE(DAY(code!O6),\"-\",MONTH(code!O6),\"-\",YEAR(code!O6))))","v":"D.A enhanced from 8.908%  to 12.052%. Enhancement : 3.144% The D.A arrears from 1-1-2015 to 31-12-2015 will be adjusted to the ZPPF Accounts. Cash will be paid from 1-1-2016"}]
[null,"Increment Rate","Basic Pay  ",{"$f":"CONCATENATE(\"D.A To be Drawn (\",S8*100,\"%)\")","v":"D.A To be Drawn (12.052%)"},{"$f":"CONCATENATE(\"D.A already Drawn (\",S9*100,\"%)\")","v":"D.A already Drawn (8.908%)"},{"$f":"CONCATENATE(\"difference (\",(S8-S9)*100,\"%)\")","v":"difference (3.144%)"},{"$f":"CONCATENATE(code!S8,\":\",code!K8,\"/\",RIGHT(code!M8,2),\" to \",code!W24,\"    (\",code!P23,\" months)\")","v":"ZPPF:1/15 to 12/15    (12 months)"},{"$f":"CONCATENATE(\"CASH:\",\" \",code!O8,\"/\",code!Q8,\"             (\",code!U8,\" months)\")","v":"CASH: 1/2016             (1 months)"},null,"Increment Rate",{"$f":"C7","v":"Basic Pay  "},"D.A To be Drawn (12.052%)","D.A already Drawn (8.908%)","difference (3.144%)",{"$f":"G7","v":"ZPPF:1/15 to 12/15    (12 months)"},"CASH: 1/2016             (1 months)",null,"D.A\n(For Print Use legal Pepar)",null,null,"Edit only Green color cells"]
[null,{"$f":"C9-C8","v":390},{"$f":"code!H2","v":13000},{"$f":"ROUND((C8*S8),0)","v":1567},{"$f":"ROUND((C8*S9),0)","v":1158},{"$f":"D8-E8","v":409},{"$f":"ROUND((F8*code!$P$23),0)","v":4908},{"$f":"ROUND((F8*code!$U$8),0)","v":409},null,{"$f":"K9-K8","v":1110},{"$f":"code!H43","v":41380},{"$f":"ROUND((K8*$S$8),0)","v":4987},{"$f":"ROUND((K8*$S$9),0)","v":3686},{"$f":"L8-M8","v":1301},{"$f":"ROUND((N8*code!$P$23),0)","v":15612},{"$f":"ROUND((N8*code!$U$8),0)","v":1301},null,"To Be",0.12052]
[null,null,{"$f":"code!H3","v":13390},{"$f":"ROUND((C9*S8),0)","v":1614},{"$f":"ROUND((C9*S9),0)","v":1193},421,{"$f":"ROUND((F9*code!$P$23),0)","v":5052},{"$f":"ROUND((F9*code!$U$8),0)","v":421},null,null,{"$f":"code!H44","v":42490},{"$f":"ROUND((K9*$S$8),0)","v":5121},{"$f":"ROUND((K9*$S$9),0)","v":3785},{"$f":"L9-M9","v":1336},{"$f":"ROUND((N9*code!$P$23),0)","v":16032},{"$f":"ROUND((N9*code!$U$8),0)","v":1336},null,"Already",8.9080000000000006E-2]
[null,null,{"$f":"code!H4","v":13780},{"$f":"ROUND((C10*S8),0)","v":1661},{"$f":"ROUND((C10*S9),0)","v":1228},433,{"$f":"ROUND((F10*code!$P$23),0)","v":5196},{"$f":"ROUND((F10*code!$U$8),0)","v":433},null,{"$f":"K11-K10","v":1190},{"$f":"code!H45","v":43680},5264,3891,1373,{"$f":"ROUND((N10*code!$P$23),0)","v":16476},{"$f":"ROUND((N10*code!$U$8),0)","v":1373}]
[null,null,{"$f":"code!H5","v":14170},{"$f":"ROUND((C11*S8),0)","v":1708},{"$f":"ROUND((C11*S9),0)","v":1262},446,{"$f":"ROUND((F11*code!$P$23),0)","v":5352},{"$f":"ROUND((F11*code!$U$8),0)","v":446},null,null,{"$f":"code!H46","v":44870},5408,3997,1411,{"$f":"ROUND((N11*code!$P$23),0)","v":16932},{"$f":"ROUND((N11*code!$U$8),0)","v":1411}]
[null,{"$f":"C13-C12","v":430},{"$f":"code!H6","v":14600},{"$f":"ROUND((C12*S8),0)","v":1760},{"$f":"ROUND((C12*S9),0)","v":1301},459,{"$f":"ROUND((F12*code!$P$23),0)","v":5508},{"$f":"ROUND((F12*code!$U$8),0)","v":459},null,null,{"$f":"code!H47","v":46060},5551,4103,1448,{"$f":"ROUND((N12*code!$P$23),0)","v":17376},{"$f":"ROUND((N12*code!$U$8),0)","v":1448}]
[null,null,{"$f":"code!H7","v":15030},{"$f":"ROUND((C13*S8),0)","v":1811},{"$f":"ROUND((C13*S9),0)","v":1339},472,{"$f":"ROUND((F13*code!$P$23),0)","v":5664},{"$f":"ROUND((F13*code!$U$8),0)","v":472},null,{"$f":"K14-K13","v":1270},{"$f":"code!H48","v":47330},5704,4216,1488,{"$f":"ROUND((N13*code!$P$23),0)","v":17856},{"$f":"ROUND((N13*code!$U$8),0)","v":1488},null,"To ZPPF"]
[null,null,{"$f":"code!H8","v":15460},{"$f":"ROUND((C14*S8),0)","v":1863},{"$f":"ROUND((C14*S9),0)","v":1377},486,{"$f":"ROUND((F14*code!$P$23),0)","v":5832},{"$f":"ROUND((F14*code!$U$8),0)","v":486},null,null,{"$f":"code!H49","v":48600},5857,4329,1528,{"$f":"ROUND((N14*code!$P$23),0)","v":18336},{"$f":"ROUND((N14*code!$U$8),0)","v":1528},null,"CASH","TO"]
[null,{"$f":"C16-C15","v":470},{"$f":"code!H9","v":15930},{"$f":"ROUND((C15*S8),0)","v":1920},{"$f":"ROUND((C15*S9),0)","v":1419},501,{"$f":"ROUND((F15*code!$P$23),0)","v":6012},{"$f":"ROUND((F15*code!$U$8),0)","v":501},null,null,{"$f":"code!H50","v":49870},6010,4442,1568,{"$f":"ROUND((N15*code!$P$23),0)","v":18816},{"$f":"ROUND((N15*code!$U$8),0)","v":1568}]
[null,null,{"$f":"code!H10","v":16400},{"$f":"ROUND((C16*S8),0)","v":1977},{"$f":"ROUND((C16*S9),0)","v":1461},516,{"$f":"ROUND((F16*code!$P$23),0)","v":6192},{"$f":"ROUND((F16*code!$U$8),0)","v":516},null,{"$f":"K17-K16","v":1360},{"$f":"code!H51","v":51230},6174,4564,1610,{"$f":"ROUND((N16*code!$P$23),0)","v":19320},{"$f":"ROUND((N16*code!$U$8),0)","v":1610},null,"Teacher's Union Name",null,null,null,null,null,{"$f":"UPPER(R17)","v":"STU"}]
[null,null,{"$f":"code!H11","v":16870},{"$f":"ROUND((C17*S8),0)","v":2033},{"$f":"ROUND((C17*S9),0)","v":1503},530,{"$f":"ROUND((F17*code!$P$23),0)","v":6360},{"$f":"ROUND((F17*code!$U$8),0)","v":530},null,null,{"$f":"code!H52","v":52590},6338,4685,1653,{"$f":"ROUND((N17*code!$P$23),0)","v":19836},{"$f":"ROUND((N17*code!$U$8),0)","v":1653},null,"stu"]
[null,{"$f":"C19-C18","v":510},{"$f":"code!H12","v":17380},{"$f":"ROUND((C18*S8),0)","v":2095},{"$f":"ROUND((C18*S9),0)","v":1548},547,{"$f":"ROUND((F18*code!$P$23),0)","v":6564},{"$f":"ROUND((F18*code!$U$8),0)","v":547},null,null,{"$f":"code!H53","v":53950},6502,4806,1696,{"$f":"ROUND((N18*code!$P$23),0)","v":20352},{"$f":"ROUND((N18*code!$U$8),0)","v":1696}]
[null,null,{"$f":"code!H13","v":17890},{"$f":"ROUND((C19*S8),0)","v":2156},{"$f":"ROUND((C19*S9),0)","v":1594},562,{"$f":"ROUND((F19*code!$P$23),0)","v":6744},{"$f":"ROUND((F19*code!$U$8),0)","v":562},null,{"$f":"K20-K19","v":1460},{"$f":"code!H54","v":55410},6678,4936,1742,{"$f":"ROUND((N19*code!$P$23),0)","v":20904},{"$f":"ROUND((N19*code!$U$8),0)","v":1742},null,"DA GO(P)  No"]
[null,null,{"$f":"code!H14","v":18400},{"$f":"ROUND((C20*S8),0)","v":2218},{"$f":"ROUND((C20*S9),0)","v":1639},579,{"$f":"ROUND((F20*code!$P$23),0)","v":6948},{"$f":"ROUND((F20*code!$U$8),0)","v":579},null,null,{"$f":"code!H55","v":56870},6854,5066,1788,{"$f":"ROUND((N20*code!$P$23),0)","v":21456},{"$f":"ROUND((N20*code!$U$8),0)","v":1788},null,"No","Date"]
[null,{"$f":"C22-C21","v":550},{"$f":"code!H15","v":18950},{"$f":"ROUND((C21*S8),0)","v":2284},{"$f":"ROUND((C21*S9),0)","v":1688},596,{"$f":"ROUND((F21*code!$P$23),0)","v":7152},{"$f":"ROUND((F21*code!$U$8),0)","v":596},null,null,{"$f":"code!H56","v":58330},7030,5196,1834,{"$f":"ROUND((N21*code!$P$23),0)","v":22008},{"$f":"ROUND((N21*code!$U$8),0)","v":1834},null,18]
[null,null,{"$f":"code!H16","v":19500},{"$f":"ROUND((C22*S8),0)","v":2350},{"$f":"ROUND((C22*S9),0)","v":1737},613,{"$f":"ROUND((F22*code!$P$23),0)","v":7356},{"$f":"ROUND((F22*code!$U$8),0)","v":613},null,{"$f":"K23-K22","v":1560},{"$f":"code!H57","v":59890},7218,5335,1883,{"$f":"ROUND((N22*code!$P$23),0)","v":22596},{"$f":"ROUND((N22*code!$U$8),0)","v":1883}]
[null,null,{"$f":"code!H17","v":20050},{"$f":"ROUND((C23*S8),0)","v":2416},{"$f":"ROUND((C23*S9),0)","v":1786},630,{"$f":"ROUND((F23*code!$P$23),0)","v":7560},{"$f":"ROUND((F23*code!$U$8),0)","v":630},null,null,{"$f":"code!H58","v":61450},7406,5474,1932,{"$f":"ROUND((N23*code!$P$23),0)","v":23184},{"$f":"ROUND((N23*code!$U$8),0)","v":1932}]
[null,{"$f":"C25-C24","v":590},{"$f":"code!H18","v":20640},{"$f":"ROUND((C24*S8),0)","v":2488},{"$f":"ROUND((C24*S9),0)","v":1839},649,{"$f":"ROUND((F24*code!$P$23),0)","v":7788},{"$f":"ROUND((F24*code!$U$8),0)","v":649},null,null,{"$f":"code!H59","v":63010},7594,5613,1981,{"$f":"ROUND((N24*code!$P$23),0)","v":23772},{"$f":"ROUND((N24*code!$U$8),0)","v":1981},null,"Mandal"]
[null,null,{"$f":"code!H19","v":21230},{"$f":"ROUND((C25*S8),0)","v":2559},{"$f":"ROUND((C25*S9),0)","v":1891},668,{"$f":"ROUND((F25*code!$P$23),0)","v":8016},{"$f":"ROUND((F25*code!$U$8),0)","v":668},null,{"$f":"K26-K25","v":1660},{"$f":"code!H60","v":64670},7794,5761,2033,{"$f":"ROUND((N25*code!$P$23),0)","v":24396},{"$f":"ROUND((N25*code!$U$8),0)","v":2033},null,"President"]
[null,null,{"$f":"code!H20","v":21820},{"$f":"ROUND((C26*S8),0)","v":2630},{"$f":"ROUND((C26*S9),0)","v":1944},686,{"$f":"ROUND((F26*code!$P$23),0)","v":8232},{"$f":"ROUND((F26*code!$U$8),0)","v":686},null,null,{"$f":"code!H61","v":66330},7994,5909,2085,{"$f":"ROUND((N26*code!$P$23),0)","v":25020},{"$f":"ROUND((N26*code!$U$8),0)","v":2085},null,"Gen Sec"]
[null,{"$f":"C28-C27","v":640},{"$f":"code!H21","v":22460},{"$f":"ROUND((C27*S8),0)","v":2707},{"$f":"ROUND((C27*S9),0)","v":2001},706,{"$f":"ROUND((F27*code!$P$23),0)","v":8472},{"$f":"ROUND((F27*code!$U$8),0)","v":706},null,null,{"$f":"code!H62","v":67990},8194,6057,2137,{"$f":"ROUND((N27*code!$P$23),0)","v":25644},{"$f":"ROUND((N27*code!$U$8),0)","v":2137}]
[null,null,{"$f":"code!H22","v":23100},{"$f":"ROUND((C28*S8),0)","v":2784},{"$f":"ROUND((C28*S9),0)","v":2058},726,{"$f":"ROUND((F28*code!$P$23),0)","v":8712},{"$f":"ROUND((F28*code!$U$8),0)","v":726},null,{"$f":"K29-K28","v":1760},{"$f":"code!H63","v":69750},8406,6213,2193,{"$f":"ROUND((N28*code!$P$23),0)","v":26316},{"$f":"ROUND((N28*code!$U$8),0)","v":2193},null,"District","YSR KADAPA","Cell"]
[null,null,{"$f":"code!H23","v":23740},{"$f":"ROUND((C29*S8),0)","v":2861},{"$f":"ROUND((C29*S9),0)","v":2115},746,{"$f":"ROUND((F29*code!$P$23),0)","v":8952},{"$f":"ROUND((F29*code!$U$8),0)","v":746},null,null,{"$f":"code!H64","v":71510},8618,6370,2248,{"$f":"ROUND((N29*code!$P$23),0)","v":26976},{"$f":"ROUND((N29*code!$U$8),0)","v":2248},null,"President"]
[null,{"$f":"C31-C30","v":700},{"$f":"code!H24","v":24440},{"$f":"ROUND((C30*S8),0)","v":2946},{"$f":"ROUND((C30*S9),0)","v":2177},769,{"$f":"ROUND((F30*code!$P$23),0)","v":9228},{"$f":"ROUND((F30*code!$U$8),0)","v":769},null,null,{"$f":"code!H65","v":73270},8831,6527,2304,{"$f":"ROUND((N30*code!$P$23),0)","v":27648},{"$f":"ROUND((N30*code!$U$8),0)","v":2304},null,"Gen Sec"]
[null,null,{"$f":"code!H25","v":25140},{"$f":"ROUND((C31*S8),0)","v":3030},{"$f":"ROUND((C31*S9),0)","v":2239},791,{"$f":"ROUND((F31*code!$P$23),0)","v":9492},{"$f":"ROUND((F31*code!$U$8),0)","v":791},null,{"$f":"K32-K31","v":1880},{"$f":"code!H66","v":75150},9057,6694,2363,{"$f":"ROUND((N31*code!$P$23),0)","v":28356},{"$f":"ROUND((N31*code!$U$8),0)","v":2363},null,"Finance Sec"]
[null,null,{"$f":"code!H26","v":25840},{"$f":"ROUND((C32*S8),0)","v":3114},{"$f":"ROUND((C32*S9),0)","v":2302},812,{"$f":"ROUND((F32*code!$P$23),0)","v":9744},{"$f":"ROUND((F32*code!$U$8),0)","v":812},null,null,{"$f":"code!H67","v":77030},9284,6862,2422,{"$f":"ROUND((N32*code!$P$23),0)","v":29064},{"$f":"ROUND((N32*code!$U$8),0)","v":2422}]
[null,{"$f":"C34-C33","v":760},{"$f":"code!H27","v":26600},{"$f":"ROUND((C33*S8),0)","v":3206},{"$f":"ROUND((C33*S9),0)","v":2370},836,{"$f":"ROUND((F33*code!$P$23),0)","v":10032},{"$f":"ROUND((F33*code!$U$8),0)","v":836},null,null,{"$f":"code!H68","v":78910},9510,7029,2481,{"$f":"ROUND((N33*code!$P$23),0)","v":29772},{"$f":"ROUND((N33*code!$U$8),0)","v":2481}]
[null,null,{"$f":"code!H28","v":27360},{"$f":"ROUND((C34*S8),0)","v":3297},{"$f":"ROUND((C34*S9),0)","v":2437},860,{"$f":"ROUND((F34*code!$P$23),0)","v":10320},{"$f":"ROUND((F34*code!$U$8),0)","v":860},null,{"$f":"K35-K34","v":2020},{"$f":"code!H69","v":80930},9754,7209,2545,{"$f":"ROUND((N34*code!$P$23),0)","v":30540},{"$f":"ROUND((N34*code!$U$8),0)","v":2545}]
[null,null,{"$f":"code!H29","v":28120},{"$f":"ROUND((C35*S8),0)","v":3389},{"$f":"ROUND((C35*S9),0)","v":2505},884,{"$f":"ROUND((F35*code!$P$23),0)","v":10608},{"$f":"ROUND((F35*code!$U$8),0)","v":884},null,null,{"$f":"code!H70","v":82950},9997,7389,2608,{"$f":"ROUND((N35*code!$P$23),0)","v":31296},{"$f":"ROUND((N35*code!$U$8),0)","v":2608}]
[null,{"$f":"C37-C36","v":820},{"$f":"code!H30","v":28940},{"$f":"ROUND((C36*S8),0)","v":3488},{"$f":"ROUND((C36*S9),0)","v":2578},910,{"$f":"ROUND((F36*code!$P$23),0)","v":10920},{"$f":"ROUND((F36*code!$U$8),0)","v":910},null,null,{"$f":"code!H71","v":84970},10241,7569,2672,{"$f":"ROUND((N36*code!$P$23),0)","v":32064},{"$f":"ROUND((N36*code!$U$8),0)","v":2672}]
[null,null,{"$f":"code!H31","v":29760},{"$f":"ROUND((C37*S8),0)","v":3587},{"$f":"ROUND((C37*S9),0)","v":2651},936,{"$f":"ROUND((F37*code!$P$23),0)","v":11232},{"$f":"ROUND((F37*code!$U$8),0)","v":936},null,{"$f":"K38-K37","v":2160},{"$f":"code!H72","v":87130},10501,7762,2739,{"$f":"ROUND((N37*code!$P$23),0)","v":32868},{"$f":"ROUND((N37*code!$U$8),0)","v":2739}]
[null,null,{"$f":"code!H32","v":30580},{"$f":"ROUND((C38*S8),0)","v":3686},{"$f":"ROUND((C38*S9),0)","v":2724},962,{"$f":"ROUND((F38*code!$P$23),0)","v":11544},{"$f":"ROUND((F38*code!$U$8),0)","v":962},null,null,{"$f":"code!H73","v":89290},10761,7954,2807,{"$f":"ROUND((N38*code!$P$23),0)","v":33684},{"$f":"ROUND((N38*code!$U$8),0)","v":2807}]
[null,{"$f":"C40-C39","v":880},{"$f":"code!H33","v":31460},{"$f":"ROUND((C39*$S$8),0)","v":3792},{"$f":"ROUND((C39*$S$9),0)","v":2802},990,{"$f":"ROUND((F39*code!$P$23),0)","v":11880},{"$f":"ROUND((F39*code!$U$8),0)","v":990},null,null,{"$f":"code!H74","v":91450},11022,8146,2876,{"$f":"ROUND((N39*code!$P$23),0)","v":34512},{"$f":"ROUND((N39*code!$U$8),0)","v":2876}]
[null,null,{"$f":"code!H34","v":32340},{"$f":"ROUND((C40*$S$8),0)","v":3898},{"$f":"ROUND((C40*$S$9),0)","v":2881},{"$f":"D40-E40","v":1017},{"$f":"ROUND((F40*code!$P$23),0)","v":12204},{"$f":"ROUND((F40*code!$U$8),0)","v":1017},null,{"$f":"K41-K40","v":2330},{"$f":"code!H75","v":93780},11302,8354,2948,{"$f":"ROUND((N40*code!$P$23),0)","v":35376},{"$f":"ROUND((N40*code!$U$8),0)","v":2948}]
[null,null,{"$f":"code!H35","v":33220},4004,2959,1045,{"$f":"ROUND((F41*code!$P$23),0)","v":12540},{"$f":"ROUND((F41*code!$U$8),0)","v":1045},null,null,{"$f":"code!H76","v":96110},11583,8561,3022,{"$f":"ROUND((N41*code!$P$23),0)","v":36264},{"$f":"ROUND((N41*code!$U$8),0)","v":3022}]
[null,{"$f":"C43-C42","v":950},{"$f":"code!H36","v":34170},4118,3044,1074,{"$f":"ROUND((F42*code!$P$23),0)","v":12888},{"$f":"ROUND((F42*code!$U$8),0)","v":1074},null,null,{"$f":"code!H77","v":98440},11864,8769,3095,{"$f":"ROUND((N42*code!$P$23),0)","v":37140},{"$f":"ROUND((N42*code!$U$8),0)","v":3095}]
[null,null,{"$f":"code!H37","v":35120},4233,3128,1105,{"$f":"ROUND((F43*code!$P$23),0)","v":13260},{"$f":"ROUND((F43*code!$U$8),0)","v":1105},null,null,{"$f":"code!H78","v":100770},12145,8977,3168,{"$f":"ROUND((N43*code!$P$23),0)","v":38016},{"$f":"ROUND((N43*code!$U$8),0)","v":3168}]
[null,null,{"$f":"code!H38","v":36070},4347,3213,1134,{"$f":"ROUND((F44*code!$P$23),0)","v":13608},{"$f":"ROUND((F44*code!$U$8),0)","v":1134},null,{"$f":"K45-K44","v":2520},{"$f":"code!H79","v":103290},12449,9201,3248,{"$f":"ROUND((N44*code!$P$23),0)","v":38976},{"$f":"ROUND((N44*code!$U$8),0)","v":3248}]
[null,{"$f":"C46-C45","v":1030},{"$f":"code!H39","v":37100},4471,3305,1166,{"$f":"ROUND((F45*code!$P$23),0)","v":13992},{"$f":"ROUND((F45*code!$U$8),0)","v":1166},null,null,{"$f":"code!H80","v":105810},12752,9426,3326,{"$f":"ROUND((N45*code!$P$23),0)","v":39912},{"$f":"ROUND((N45*code!$U$8),0)","v":3326}]
[null,null,{"$f":"code!H40","v":38130},4595,3397,1198,{"$f":"ROUND((F46*code!$P$23),0)","v":14376},{"$f":"ROUND((F46*code!$U$8),0)","v":1198},null,null,{"$f":"code!H81","v":108330},13056,9650,3406,{"$f":"ROUND((N46*code!$P$23),0)","v":40872},{"$f":"ROUND((N46*code!$U$8),0)","v":3406}]
[null,null,{"$f":"code!H41","v":39160},4720,3488,1232,{"$f":"ROUND((F47*code!$P$23),0)","v":14784},{"$f":"ROUND((F47*code!$U$8),0)","v":1232},null,null,{"$f":"code!H82","v":110850},{"$f":"ROUND((K47*$S$8),0)","v":13360},{"$f":"ROUND((K47*$S$9),0)","v":9875},{"$f":"L47-M47","v":3485},{"$f":"ROUND((N47*code!$P$23),0)","v":41820},{"$f":"ROUND((N47*code!$U$8),0)","v":3485}]
[null,{"$f":"K8-C48","v":1110},{"$f":"code!H42","v":40270},4853,3587,1266,{"$f":"ROUND((F48*code!$P$23),0)","v":15192},{"$f":"ROUND((F48*code!$U$8),0)","v":1266},null,{"$f":"UPPER(R17)&\"-\"&UPPER(R17)&\"-\"&UPPER(R17)&\"-\"&UPPER(R17)&\"-\"&UPPER(R17)&\"-\"&UPPER(R17)","v":"STU-STU-STU-STU-STU-STU"}]
[null,{"$f":"CONCATENATE(\"Prepared by:\",UPPER(R17),\" \",\" cell:9494796587,9666570250\")","v":"Prepared by:STU  cell:9494796587,9666570250"}]
[null,{"$f":"IF(S24=0,\" \",\"GS/PRE,\"&UPPER(S24)&\" UNIT\")","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"UPPER(S28)","v":"YSR KADAPA"}]

{"sheet":"code","index":1,"n_rows":82,"n_cols":23,"rows_kept":82,"cut":false,"hidden":true,"merged":[[6,10,6,11],[6,14,6,15],[69,9,69,11],[13,2,13,3],[75,9,75,18]]}
[]
[null,null,null,null,null,null,1,13000,null,{"$f":"CONCATENATE(DAY(DATE(code!M8,code!K8,1)),\"-\",MONTH(DATE(code!M8,code!K8,1)),\"-\",YEAR(DATE(code!M8,code!K8,1)))","v":"1-1-2015"}]
[null,null,null,null,null,null,2,13390,null,null,null,null,null,null,null,null,{"$f":"DATE(code!M8,code!K8,1)","v":"2015-01-01"},null,null,{"$f":"1&\"-\"&MONTH(Q6+1)&\"-\"&YEAR(Q6)","v":"1-1-2016"}]
[null,null,null,null,null,null,3,13780]
[null,null,null,null,"D.A READY RECKONER",null,4,14170]
[null,null,null,null,null,null,5,14600,null,{"$f":"DATE(M8,K8,1)","v":"2015-01-01"},{"$f":"DAY(J6)&\"-\"&MONTH(J6)&\"-\"&YEAR(J6)","v":"1-1-2015"},null,null,null,{"$f":"DATE(Q8,O8,1)","v":"2016-01-01"},{"$f":"DAY(O6)&\"-\"&R6&\"-\"&YEAR(O6)","v":"1-12-2016"},{"$f":"E22&\"-\"&MONTH(P6)&\"-\"&YEAR(O6)","v":"31-12-2016"},{"$f":"IF(O8=1,12,O8-1)","v":12}]
[null,null,null,null,null,null,6,15030,null,null,"ZPPF",null,null,null,"CASH"]
[null,null,null,null,null,null,7,15460,null,{"$f":"LOOKUP(K8,J9:K20,K9:K20)","v":"Jan"},1,1,{"$f":"LOOKUP(L8,J9:L11,L9:L11)","v":2015},{"$f":"LOOKUP(O8,N9:O20,O9:O20)","v":"Jan"},1,2,{"$f":"LOOKUP(P8,N9:P11,P9:P11)","v":2016},1,{"$f":"LOOKUP(R8,Q9:R11,R9:R11)","v":"ZPPF"},1,{"$f":"ABS(O8-T8)+1","v":1}]
[null,null,null,null,5,null,8,15930,null,1,"Jan",2015,null,1,"Jan",2015,1,"ZPPF"]
[null,null,null,null,1,null,9,16400,null,2,"Feb",2016,null,2,"Feb",2016,2,"GPF"]
[null,null,null,null,null,null,10,16870,null,3,"Mar",2017,null,3,"Mar",2017,3,"CPS"]
[null,null,null,null,null,null,11,17380,null,4,"Apr",null,null,4,"Apr",null,null,null,null,null,{"$f":"UPPER(LEFT('DA S0FTWARE'!$R$17,1)&\"  \"&MID('DA S0FTWARE'!$R$17,2,1)&\"  \"&MID('DA S0FTWARE'!$R$17,3,1)&\"  \"&MID('DA S0FTWARE'!$R$17,4,1)&\"  \"&MID('DA S0FTWARE'!$R$17,5,1)&\"  \"&MID('DA S0FTWARE'!$R$17,6,1)&\"  \"&MID('DA S0FTWARE'!$R$17,7,1)&\"  \"&MID('DA S0FTWARE'!$R$17,8,1)&\"  \"&MID('DA S0FTWARE'!$R$17,9,1))","v":"S  T  U            "}]
[null,null,null,null,null,null,12,17890,null,5,"May",null,null,5,"May",null,null,null,null,null,{"$f":"UPPER('DA S0FTWARE'!$R$17)","v":"STU"}]
[null,null,"Feb",null,null,null,13,18400,null,6,"Jun",null,null,6,"Jun"]
[null,null,2012,28,null,null,14,18950,null,7,"Jul",null,null,7,"Jul"]
[null,null,2013,28,null,null,15,19500,null,8,"Aug",null,null,8,"Aug"]
[null,null,2014,29,null,null,16,20050,null,9,"Sep",null,null,9,"Sep"]
[null,null,2015,28,null,null,17,20640,null,10,"Oct",null,null,10,"Oct",null,null,null,null,null,{"$f":"YEAR(T24)","v":2015}]
[null,null,2016,28,null,null,18,21230,null,11,"Nov",null,null,11,"Nov"]
[null,null,2017,28,null,null,19,21820,null,12,"Dec",null,null,12,"Dec"]
[null,null,2018,29,null,null,20,22460]
[null,null,1,31,{"$f":"LOOKUP(V24,C22:D33,D22:D33)","v":31},null,21,23100,null,null,"ZPPF",null,null,"ZPPF",null,"Diff",null,null,null,{"$f":"DATE(U26,V24,1)","v":"2015-12-01"}]
[null,null,2,{"$f":"IF(OR(YEAR(T22)=2012,YEAR(T22)=2016),29,28)","v":28},null,null,22,23740,null,{"$f":"CONCATENATE(J8,\" \",RIGHT(M8,2))","v":"Jan 15"},{"$f":"MATCH(J23,K24:K59,0)","v":1},null,{"$f":"CONCATENATE(N8,\" \",RIGHT(Q8,2))","v":"Jan 16"},{"$f":"MATCH(M23,N24:N59,0)","v":13},null,{"$f":"N23-K23","v":12},null,null,null,{"$f":"T24","v":"Dec 15"}]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J24)","v":1},3,31,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K24)","v":"Jan 15"},null,23,24440,null,1,{"$f":"CONCATENATE(K9,\" \",RIGHT($L$9,2))","v":"Jan 15"},null,{"$f":"J24","v":1},{"$f":"K24","v":"Jan 15"},null,null,1,{"$f":"K24","v":"Jan 15"},null,{"$f":"LOOKUP(N23,Q24:R61,S24:S60)","v":"Dec 15"},{"$f":"LEFT(T24,3)","v":"Dec"},{"$f":"MATCH(U24,O9:O20,0)","v":12},{"$f":"CONCATENATE(V24,\"/\",RIGHT(T24,2))","v":"12/15"}]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J25)","v":2},4,30,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K25)","v":"Feb 15"},null,24,25140,null,2,{"$f":"CONCATENATE(K10,\" \",RIGHT($L$9,2))","v":"Feb 15"},null,2,"Feb 15",null,null,2,{"$f":"K25","v":"Feb 15"},{"$f":"R24","v":"Jan 15"}]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J26)","v":3},5,31,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K26)","v":"Mar 15"},null,25,25840,null,3,"Mar 15",null,3,"Mar 15",null,null,3,"Mar 15",{"$f":"R25","v":"Feb 15"},null,{"$f":"\"20\"&RIGHT(T24,2)","v":"2015"}]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J27)","v":4},6,30,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K27)","v":"Apr 15"},null,26,26600,null,4,"Apr 15",null,4,"Apr 15",null,null,4,"Apr 15","Mar 15"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J28)","v":5},7,31,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K28)","v":"May 15"},null,27,27360,null,5,"May 15",null,5,"May 15",null,null,5,"May 15","Apr 15"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J29)","v":6},8,31,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K29)","v":"Jun 15"},null,28,28120,null,6,"Jun 15",null,6,"Jun 15",null,null,6,"Jun 15","May 15"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J30)","v":7},9,30,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K30)","v":"Jul 15"},null,29,28940,null,7,"Jul 15",null,7,"Jul 15",null,null,7,"Jul 15","Jun 15"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J31)","v":8},10,31,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K31)","v":"Aug 15"},null,30,29760,null,8,"Aug 15",null,8,"Aug 15",null,null,8,"Aug 15","Jul 15"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J32)","v":9},11,30,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K32)","v":"Sep 15"},null,31,30580,null,9,"Sep 15",null,9,"Sep 15",null,null,9,"Sep 15","Aug 15"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J33)","v":10},12,31,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K33)","v":"Oct 15"},null,32,31460,null,10,{"$f":"CONCATENATE(K18,\" \",RIGHT($L$9,2))","v":"Oct 15"},null,10,"Oct 15",null,null,10,"Oct 15","Sep 15"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J34)","v":11},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K34)","v":"Nov 15"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K34)","v":"Nov 15"},null,33,32340,null,11,"Nov 15",null,11,"Nov 15",null,null,11,"Nov 15","Oct 15"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J35)","v":12},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K35)","v":"Dec 15"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K35)","v":"Dec 15"},null,34,33220,null,12,"Dec 15",null,12,"Dec 15",null,null,12,"Dec 15","Nov 15"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J36)","v":13},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K36)","v":"Jan 16"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K36)","v":"Jan 16"},null,35,34170,null,13,{"$f":"CONCATENATE(K9,\" \",RIGHT($L$10,2))","v":"Jan 16"},null,13,"Jan 16",null,null,13,"Jan 16","Dec 15"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J37)","v":14},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K37)","v":"Feb 16"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K37)","v":"Feb 16"},null,36,35120,null,14,{"$f":"CONCATENATE(K10,\" \",RIGHT($L$10,2))","v":"Feb 16"},null,14,"Feb 16",null,null,14,"Feb 16","Jan 16"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J38)","v":15},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K38)","v":"Mar 16"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K38)","v":"Mar 16"},null,37,36070,null,15,"Mar 16",null,15,"Mar 16",null,null,15,"Mar 16","Feb 16"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J39)","v":16},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K39)","v":"Apr 16"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K39)","v":"Apr 16"},null,38,37100,null,16,"Apr 16",null,16,"Apr 16",null,null,16,"Apr 16","Mar 16"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J40)","v":17},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K40)","v":"May 16"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K40)","v":"May 16"},null,39,38130,null,17,"May 16",null,17,"May 16",null,null,17,"May 16","Apr 16"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J41)","v":18},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K41)","v":"Jun 16"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K41)","v":"Jun 16"},null,40,39160,null,18,"Jun 16",null,18,"Jun 16",null,null,18,"Jun 16","May 16"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J42)","v":19},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K42)","v":"Jul 16"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K42)","v":"Jul 16"},null,41,40270,null,19,"Jul 16",null,19,"Jul 16",null,null,19,"Jul 16","Jun 16"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J43)","v":20},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K43)","v":"Aug 16"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K43)","v":"Aug 16"},null,42,41380,null,20,"Aug 16",null,20,"Aug 16",null,null,20,"Aug 16","Jul 16"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J44)","v":21},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K44)","v":"Sep 16"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K44)","v":"Sep 16"},null,43,42490,null,21,"Sep 16",null,21,"Sep 16",null,null,21,"Sep 16","Aug 16"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J45)","v":22},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K45)","v":"Oct 16"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K45)","v":"Oct 16"},null,44,43680,null,22,"Oct 16",null,22,"Oct 16",null,null,22,"Oct 16","Sep 16"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J46)","v":23},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K46)","v":"Nov 16"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K46)","v":"Nov 16"},null,45,44870,null,23,"Nov 16",null,23,"Nov 16",null,null,23,"Nov 16","Oct 16"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J47)","v":24},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K47)","v":"Dec 16"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K47)","v":"Dec 16"},null,46,46060,null,24,"Dec 16",null,24,"Dec 16",null,null,24,"Dec 16","Nov 16"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J48)","v":25},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K48)","v":"Jan 17"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K48)","v":"Jan 17"},null,47,47330,null,25,{"$f":"CONCATENATE(K9,\" \",RIGHT($L$11,2))","v":"Jan 17"},null,25,"Jan 17",null,null,25,"Jan 17","Dec 16"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J49)","v":26},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K49)","v":"Feb 17"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K49)","v":"Feb 17"},null,48,48600,null,26,{"$f":"CONCATENATE(K10,\" \",RIGHT($L$11,2))","v":"Feb 17"},null,26,"Feb 17",null,null,26,"Feb 17","Jan 17"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J50)","v":27},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K50)","v":"Mar 17"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K50)","v":"Mar 17"},null,49,49870,null,27,"Mar 17",null,27,"Mar 17",null,null,27,"Mar 17","Feb 17"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J51)","v":28},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K51)","v":"Apr 17"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K51)","v":"Apr 17"},null,50,51230,null,28,"Apr 17",null,28,"Apr 17",null,null,28,"Apr 17","Mar 17"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J52)","v":29},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K52)","v":"May 17"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K52)","v":"May 17"},null,51,52590,null,29,"May 17",null,29,"May 17",null,null,29,"May 17","Apr 17"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J53)","v":30},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K53)","v":"Jun 17"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K53)","v":"Jun 17"},null,52,53950,null,30,"Jun 17",null,30,"Jun 17",null,null,30,"Jun 17","May 17"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J54)","v":31},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K54)","v":"Jul 17"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K54)","v":"Jul 17"},null,53,55410,null,31,"Jul 17",null,31,"Jul 17",null,null,31,"Jul 17","Jun 17"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J55)","v":32},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K55)","v":"Aug 17"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K55)","v":"Aug 17"},null,54,56870,null,32,"Aug 17",null,32,"Aug 17",null,null,32,"Aug 17","Jul 17"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J56)","v":33},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K56)","v":"Sep 17"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K56)","v":"Sep 17"},null,55,58330,null,33,"Sep 17",null,33,"Sep 17",null,null,33,"Sep 17","Aug 17"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J57)","v":34},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K57)","v":"Oct 17"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K57)","v":"Oct 17"},null,56,59890,null,34,"Oct 17",null,34,"Oct 17",null,null,34,"Oct 17","Sep 17"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J58)","v":35},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K58)","v":"Nov 17"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K58)","v":"Nov 17"},null,57,61450,null,35,"Nov 17",null,35,"Nov 17",null,null,35,"Nov 17","Oct 17"]
[null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!J59)","v":36},{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K59)","v":"Dec 17"},null,{"$f":"IF('DA S0FTWARE'!$R$21=0,\" \",code!K59)","v":"Dec 17"},null,58,63010,null,36,"Dec 17",null,36,"Dec 17",null,null,36,"Dec 17","Nov 17"]
[null,null,null,null,null,null,59,64670,null,null,null,null,0,0,null,null,37,null,"Dec 17"]
[null,null,null,null,null,null,60,66330]
[null,null,null,null,null,null,61,67990,null,10,14,{"$f":"LOOKUP(K62,J24:K59,K24:K59)","v":"Feb 16"},{"$f":"IF('DA S0FTWARE'!R21>0,code!J62,0)","v":10}]
[null,null,null,null,null,null,62,69750,null,{"$f":"CONCATENATE(J62,\" \",L62)","v":"10 Feb 16"},{"$f":"MONTH(J63)","v":2},{"$f":"RIGHT(L62,2)","v":"16"}]
[null,null,null,null,null,null,63,71510,null,{"$f":"IF(M62>0,M62&\"-\"&K63&\"-\"&L63,0)","v":"10-2-16"}]
[null,null,null,null,null,null,64,73270]
[null,null,null,null,null,null,65,75150]
[null,null,null,null,null,null,66,77030,null,null,null,null,null,"_______"]
[null,null,null,null,null,null,67,78910,null,{"$f":"CONCATENATE(\"Enhanced D.A w.e.f \",DAY(DATE(code!M8,code!K8,1)),\"-\",MONTH(DATE(code!M8,code!K8,1)),\"-\",YEAR(DATE(code!M8,code!K8,1)),\" G.O(P).No:\",N70,\",Dt:\",O70)","v":"Enhanced D.A w.e.f 1-1-2015 G.O(P).No:18,Dt:10-2-16"}]
[null,null,null,null,null,null,68,80930]
[null,null,null,null,null,null,69,82950,null,{"$f":"IF('DA S0FTWARE'!R21=\" \",_________,'DA S0FTWARE'!R21)","v":18},null,null,null,{"$f":"IF('DA S0FTWARE'!R21=0,N67,'DA S0FTWARE'!R21)","v":18},{"$f":"IF('DA S0FTWARE'!R21=J64,N67,J64)","v":"10-2-16"}]
[null,null,null,null,null,null,70,84970]
[null,null,null,null,null,null,71,87130]
[null,null,null,null,null,null,72,89290]
[null,null,null,null,null,null,73,91450]
[null,null,null,null,null,null,74,93780]
[null,null,null,null,null,null,75,96110,null,{"$f":"CONCATENATE(\"Enhanced D.A w.e.f \",DAY(DATE(code!M8,code!K8,1)),\"-\",MONTH(DATE(code!M8,code!K8,1)),\"-\",YEAR(DATE(code!M8,code!K8,1)),\"                  G.O(P).No:\",N70,\",Dt:\",O70)","v":"Enhanced D.A w.e.f 1-1-2015                  G.O(P).No:18,Dt:10-2-16"}]
[null,null,null,null,null,null,76,98440]
[null,null,null,null,null,null,77,100770]
[null,null,null,null,null,null,78,103290]
[null,null,null,null,null,null,79,105810]
[null,null,null,null,null,null,80,108330]
[null,null,null,null,null,null,null,110850]

{"sheet":"Compatibility Report","index":2,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[null,"Compatibility Report for DA software PRC 2010.xlsx"]
[null,"Run on 08/11/2010 17:41"]
[]
[null,"The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when you save this workbook in an earlier file format."]
[]
[null,"Minor loss of fidelity",null,null,"# of occurrences"]
[]
[null,"Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available.",null,null,38]