{"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":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[3,20,17,21],[45,2,45,15],[3,17,3,18],[8,17,8,18],[12,17,12,18],[13,17,13,18],[15,17,15,18],[4,9,5,9],[6,9,8,9],[9,9,11,9],[12,9,14,9],[15,9,17,9],[18,9,20,9],[21,9,23,9],[24,9,26,9],[27,9,29,9],[2,17,2,18],[2,1,2,15],[46,5,46,12],[3,8,44,8],[1,1,1,3],[4,1,7,1],[8,1,10,1],[32,1,34,1],[35,1,37,1],[38,1,40,1],[11,1,13,1],[14,1,16,1],[17,1,19,1],[20,1,22,1],[23,1,25,1],[41,1,43,1],[30,9,32,9],[33,9,35,9],[36,9,39,9],[40,9,42,9],[26,1,28,1],[29,1,31,1]]}
[]
[]
[null,{"$f":"CONCATENATE(\"D.A enhanced from \",S6*100,\"%  to \",S5*100,\"%. \",\"Enhancement : \",(S5-S6)*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 \",code!E22,\"-\",MONTH(code!T22),\"-\",YEAR(code!T22),\" will be adjusted to the \",code!S8,\" Accounts. Cash will be paid from \",code!Q6 )","v":"D.A enhanced from 16.264%  to 24.824%. Enhancement : 8.56% The D.A arrears from 1-7-2010 to 30-11-2011 will be adjusted to the ZPPF Accounts. Cash will be paid from 1-12-2010"}]
[null,"Increment Rate","Basic Pay  ",{"$f":"CONCATENATE(\"D.A To be Drawn (\",S5*100,\"%)\")","v":"D.A To be Drawn (24.824%)"},{"$f":"CONCATENATE(\"D.A already Drawn (\",S6*100,\"%)\")","v":"D.A already Drawn (16.264%)"},{"$f":"CONCATENATE(\"difference (\",(S5-S6)*100,\"%)\")","v":"difference (8.56%)"},{"$f":"CONCATENATE(code!S8,\":\",code!K8,\"/\",RIGHT(code!M8,2),\" to \",code!W24,\"    (\",code!P23,\" months)\")","v":"ZPPF:7/10 to 11/10    (5 months)"},{"$f":"CONCATENATE(\"CASH:\",\" \",code!O8,\"/\",code!Q8,\"             (1 months)\")","v":"CASH: 12/2010             (1 months)"},null,"Increment Rate",{"$f":"C4","v":"Basic Pay  "},"D.A To be Drawn (24.824%)","D.A already Drawn (16.264%)","difference (8.56%)",{"$f":"G4","v":"ZPPF:7/10 to 11/10    (5 months)"},"CASH: 12/2010             (1 months)",null,"D.A\n(For Print Use legal Pepar)",null,null,"Edit only Green color cells"]
[null,200,{"$f":"code!H2","v":6700},{"$f":"ROUND((C5*S5),0)","v":1663},{"$f":"ROUND((C5*S6),0)","v":1090},{"$f":"D5-E5","v":573},{"$f":"ROUND((F5*code!$P$23),0)","v":2865},{"$f":"ROUND((F5*1),0)","v":573},null,570,{"$f":"code!H43","v":21250},{"$f":"ROUND((K5*$S$5),0)","v":5275},{"$f":"ROUND((K5*$S$6),0)","v":3456},{"$f":"L5-M5","v":1819},{"$f":"ROUND((N5*code!$P$23),0)","v":9095},{"$f":"ROUND((N5*1),0)","v":1819},null,"To Be",0.24823999999999999]
[null,null,{"$f":"code!H3","v":6900},{"$f":"ROUND((C6*S5),0)","v":1713},{"$f":"ROUND((C6*S6),0)","v":1122},591,{"$f":"ROUND((F6*code!$P$23),0)","v":2955},{"$f":"ROUND((F6*1),0)","v":591},null,null,{"$f":"code!H44","v":21820},{"$f":"ROUND((K6*$S$5),0)","v":5417},{"$f":"ROUND((K6*$S$6),0)","v":3549},{"$f":"L6-M6","v":1868},{"$f":"ROUND((N6*code!$P$23),0)","v":9340},{"$f":"ROUND((N6*1),0)","v":1868},null,"Already",0.16264000000000001]
[null,null,{"$f":"code!H4","v":7100},{"$f":"ROUND((C7*S5),0)","v":1763},{"$f":"ROUND((C7*S6),0)","v":1155},608,{"$f":"ROUND((F7*code!$P$23),0)","v":3040},608,null,610,{"$f":"code!H45","v":22430},5568,3648,1920,{"$f":"ROUND((N7*code!$P$23),0)","v":9600},1920]
[null,null,{"$f":"code!H5","v":7300},{"$f":"ROUND((C8*S5),0)","v":1812},{"$f":"ROUND((C8*S6),0)","v":1187},625,{"$f":"ROUND((F8*code!$P$23),0)","v":3125},625,null,null,{"$f":"code!H46","v":23040},5719,3747,1972,{"$f":"ROUND((N8*code!$P$23),0)","v":9860},1972]
[null,220,{"$f":"code!H6","v":7520},{"$f":"ROUND((C9*S5),0)","v":1867},{"$f":"ROUND((C9*S6),0)","v":1223},644,{"$f":"ROUND((F9*code!$P$23),0)","v":3220},644,null,null,{"$f":"code!H47","v":23650},5871,3846,2025,{"$f":"ROUND((N9*code!$P$23),0)","v":10125},2025]
[null,null,{"$f":"code!H7","v":7740},{"$f":"ROUND((C10*S5),0)","v":1921},{"$f":"ROUND((C10*S6),0)","v":1259},662,{"$f":"ROUND((F10*code!$P$23),0)","v":3310},662,null,650,{"$f":"code!H48","v":24300},6032,3952,2080,{"$f":"ROUND((N10*code!$P$23),0)","v":10400},2080,null,"To ZPPF"]
[null,null,{"$f":"code!H8","v":7960},{"$f":"ROUND((C11*S5),0)","v":1976},{"$f":"ROUND((C11*S6),0)","v":1295},681,{"$f":"ROUND((F11*code!$P$23),0)","v":3405},681,null,null,{"$f":"code!H49","v":24950},6194,4058,2136,{"$f":"ROUND((N11*code!$P$23),0)","v":10680},2136,null,"CASH"]
[null,240,{"$f":"code!H9","v":8200},{"$f":"ROUND((C12*S5),0)","v":2036},{"$f":"ROUND((C12*S6),0)","v":1334},702,{"$f":"ROUND((F12*code!$P$23),0)","v":3510},702,null,null,{"$f":"code!H50","v":25600},6355,4164,2191,{"$f":"ROUND((N12*code!$P$23),0)","v":10955},2191]
[null,null,{"$f":"code!H10","v":8440},{"$f":"ROUND((C13*S5),0)","v":2095},{"$f":"ROUND((C13*S6),0)","v":1373},722,{"$f":"ROUND((F13*code!$P$23),0)","v":3610},722,null,700,{"$f":"code!H51","v":26300},6529,4277,2252,{"$f":"ROUND((N13*code!$P$23),0)","v":11260},2252,null,"Teacher's Union Name",null,null,null,null,null,{"$f":"UPPER(R14)","v":""}]
[null,null,{"$f":"code!H11","v":8680},{"$f":"ROUND((C14*S5),0)","v":2155},{"$f":"ROUND((C14*S6),0)","v":1412},743,{"$f":"ROUND((F14*code!$P$23),0)","v":3715},743,null,null,{"$f":"code!H52","v":27000},6702,4391,2311,{"$f":"ROUND((N14*code!$P$23),0)","v":11555},2311]
[null,260,{"$f":"code!H12","v":8940},{"$f":"ROUND((C15*S5),0)","v":2219},{"$f":"ROUND((C15*S6),0)","v":1454},765,{"$f":"ROUND((F15*code!$P$23),0)","v":3825},765,null,null,{"$f":"code!H53","v":27700},6876,4505,2371,{"$f":"ROUND((N15*code!$P$23),0)","v":11855},2371]
[null,null,{"$f":"code!H13","v":9200},{"$f":"ROUND((C16*S5),0)","v":2284},{"$f":"ROUND((C16*S6),0)","v":1496},788,{"$f":"ROUND((F16*code!$P$23),0)","v":3940},788,null,750,{"$f":"code!H54","v":28450},7062,4627,2435,{"$f":"ROUND((N16*code!$P$23),0)","v":12175},2435,null,"DA GO(P)  No"]
[null,null,{"$f":"code!H14","v":9460},{"$f":"ROUND((C17*S5),0)","v":2348},{"$f":"ROUND((C17*S6),0)","v":1539},809,{"$f":"ROUND((F17*code!$P$23),0)","v":4045},809,null,null,{"$f":"code!H55","v":29200},7249,4749,2500,{"$f":"ROUND((N17*code!$P$23),0)","v":12500},2500,null,"No","Date"]
[null,280,{"$f":"code!H15","v":9740},{"$f":"ROUND((C18*S5),0)","v":2418},{"$f":"ROUND((C18*S6),0)","v":1584},834,{"$f":"ROUND((F18*code!$P$23),0)","v":4170},834,null,null,{"$f":"code!H56","v":29950},7435,4871,2564,{"$f":"ROUND((N18*code!$P$23),0)","v":12820},2564]
[null,null,{"$f":"code!H16","v":10020},{"$f":"ROUND((C19*S5),0)","v":2487},{"$f":"ROUND((C19*S6),0)","v":1630},857,{"$f":"ROUND((F19*code!$P$23),0)","v":4285},857,null,800,{"$f":"code!H57","v":30750},7633,5001,2632,{"$f":"ROUND((N19*code!$P$23),0)","v":13160},2632]
[null,null,{"$f":"code!H17","v":10300},{"$f":"ROUND((C20*S5),0)","v":2557},{"$f":"ROUND((C20*S6),0)","v":1675},882,{"$f":"ROUND((F20*code!$P$23),0)","v":4410},882,null,null,{"$f":"code!H58","v":31550},7832,5131,2701,{"$f":"ROUND((N20*code!$P$23),0)","v":13505},2701,null,"UNIT","xyz"]
[null,300,{"$f":"code!H18","v":10600},{"$f":"ROUND((C21*S5),0)","v":2631},{"$f":"ROUND((C21*S6),0)","v":1724},907,{"$f":"ROUND((F21*code!$P$23),0)","v":4535},907,null,null,{"$f":"code!H59","v":32350},8031,5261,2770,{"$f":"ROUND((N21*code!$P$23),0)","v":13850},2770]
[null,null,{"$f":"code!H19","v":10900},{"$f":"ROUND((C22*S5),0)","v":2706},{"$f":"ROUND((C22*S6),0)","v":1773},933,{"$f":"ROUND((F22*code!$P$23),0)","v":4665},933,null,850,{"$f":"code!H60","v":33200},8242,5400,2842,{"$f":"ROUND((N22*code!$P$23),0)","v":14210},2842]
[null,null,{"$f":"code!H20","v":11200},{"$f":"ROUND((C23*S5),0)","v":2780},{"$f":"ROUND((C23*S6),0)","v":1822},958,{"$f":"ROUND((F23*code!$P$23),0)","v":4790},958,null,null,{"$f":"code!H61","v":34050},8453,5538,2915,{"$f":"ROUND((N23*code!$P$23),0)","v":14575},2915]
[null,330,{"$f":"code!H21","v":11530},{"$f":"ROUND((C24*S5),0)","v":2862},{"$f":"ROUND((C24*S6),0)","v":1875},987,{"$f":"ROUND((F24*code!$P$23),0)","v":4935},987,null,null,{"$f":"code!H62","v":34900},8664,5676,2988,{"$f":"ROUND((N24*code!$P$23),0)","v":14940},2988]
[null,null,{"$f":"code!H22","v":11860},{"$f":"ROUND((C25*S5),0)","v":2944},{"$f":"ROUND((C25*S6),0)","v":1929},1015,{"$f":"ROUND((F25*code!$P$23),0)","v":5075},1015,null,900,{"$f":"code!H63","v":35800},8887,5823,3064,{"$f":"ROUND((N25*code!$P$23),0)","v":15320},3064]
[null,null,{"$f":"code!H23","v":12190},{"$f":"ROUND((C26*S5),0)","v":3026},{"$f":"ROUND((C26*S6),0)","v":1983},1043,{"$f":"ROUND((F26*code!$P$23),0)","v":5215},1043,null,null,{"$f":"code!H64","v":36700},9110,5969,3141,{"$f":"ROUND((N26*code!$P$23),0)","v":15705},3141]
[null,360,{"$f":"code!H24","v":12550},{"$f":"ROUND((C27*S5),0)","v":3115},{"$f":"ROUND((C27*S6),0)","v":2041},1074,{"$f":"ROUND((F27*code!$P$23),0)","v":5370},1074,null,null,{"$f":"code!H65","v":37600},9334,6115,3219,{"$f":"ROUND((N27*code!$P$23),0)","v":16095},3219]
[null,null,{"$f":"code!H25","v":12910},{"$f":"ROUND((C28*S5),0)","v":3205},{"$f":"ROUND((C28*S6),0)","v":2100},1105,{"$f":"ROUND((F28*code!$P$23),0)","v":5525},1105,null,970,{"$f":"code!H66","v":38570},9575,6273,3302,{"$f":"ROUND((N28*code!$P$23),0)","v":16510},3302]
[null,null,{"$f":"code!H26","v":13270},{"$f":"ROUND((C29*S5),0)","v":3294},{"$f":"ROUND((C29*S6),0)","v":2158},1136,{"$f":"ROUND((F29*code!$P$23),0)","v":5680},1136,null,null,{"$f":"code!H67","v":39540},9815,6431,3384,{"$f":"ROUND((N29*code!$P$23),0)","v":16920},3384]
[null,390,{"$f":"code!H27","v":13660},{"$f":"ROUND((C30*S5),0)","v":3391},{"$f":"ROUND((C30*S6),0)","v":2222},1169,{"$f":"ROUND((F30*code!$P$23),0)","v":5845},1169,null,null,{"$f":"code!H68","v":40510},10056,6589,3467,{"$f":"ROUND((N30*code!$P$23),0)","v":17335},3467]
[null,null,{"$f":"code!H28","v":14050},{"$f":"ROUND((C31*S5),0)","v":3488},{"$f":"ROUND((C31*S6),0)","v":2285},1203,{"$f":"ROUND((F31*code!$P$23),0)","v":6015},1203,null,1040,{"$f":"code!H69","v":41550},10314,6758,3556,{"$f":"ROUND((N31*code!$P$23),0)","v":17780},3556]
[null,null,{"$f":"code!H29","v":14440},{"$f":"ROUND((C32*S5),0)","v":3585},{"$f":"ROUND((C32*S6),0)","v":2349},1236,{"$f":"ROUND((F32*code!$P$23),0)","v":6180},1236,null,null,{"$f":"code!H70","v":42590},10573,6927,3646,{"$f":"ROUND((N32*code!$P$23),0)","v":18230},3646]
[null,420,{"$f":"code!H30","v":14860},{"$f":"ROUND((C33*S5),0)","v":3689},{"$f":"ROUND((C33*S6),0)","v":2417},1272,{"$f":"ROUND((F33*code!$P$23),0)","v":6360},1272,null,null,{"$f":"code!H71","v":43630},10831,7096,3735,{"$f":"ROUND((N33*code!$P$23),0)","v":18675},3735]
[null,null,{"$f":"code!H31","v":15280},{"$f":"ROUND((C34*S5),0)","v":3793},{"$f":"ROUND((C34*S6),0)","v":2485},1308,{"$f":"ROUND((F34*code!$P$23),0)","v":6540},1308,null,1110,{"$f":"code!H72","v":44740},11106,7277,3829,{"$f":"ROUND((N34*code!$P$23),0)","v":19145},3829]
[null,null,{"$f":"code!H32","v":15700},{"$f":"ROUND((C35*S5),0)","v":3897},{"$f":"ROUND((C35*S6),0)","v":2553},1344,{"$f":"ROUND((F35*code!$P$23),0)","v":6720},1344,null,null,{"$f":"code!H73","v":45850},11382,7457,3925,{"$f":"ROUND((N35*code!$P$23),0)","v":19625},3925]
[null,450,{"$f":"code!H33","v":16150},{"$f":"ROUND((C36*$S$5),0)","v":4009},{"$f":"ROUND((C36*$S$6),0)","v":2627},1382,{"$f":"ROUND((F36*code!$P$23),0)","v":6910},1382,null,null,{"$f":"code!H74","v":46960},11657,7638,4019,{"$f":"ROUND((N36*code!$P$23),0)","v":20095},4019]
[null,null,{"$f":"code!H34","v":16600},{"$f":"ROUND((C37*$S$5),0)","v":4121},{"$f":"ROUND((C37*$S$6),0)","v":2700},{"$f":"D37-E37","v":1421},{"$f":"ROUND((F37*code!$P$23),0)","v":7105},{"$f":"ROUND((F37*1),0)","v":1421},null,1200,{"$f":"code!H75","v":48160},11955,7833,4122,{"$f":"ROUND((N37*code!$P$23),0)","v":20610},4122]
[null,null,{"$f":"code!H35","v":17050},4232,2773,1459,{"$f":"ROUND((F38*code!$P$23),0)","v":7295},1459,null,null,{"$f":"code!H76","v":49360},12253,8028,4225,{"$f":"ROUND((N38*code!$P$23),0)","v":21125},4225]
[null,490,{"$f":"code!H36","v":17540},4354,2853,1501,{"$f":"ROUND((F39*code!$P$23),0)","v":7505},1501,null,null,{"$f":"code!H77","v":50560},12551,8223,4328,{"$f":"ROUND((N39*code!$P$23),0)","v":21640},4328]
[null,null,{"$f":"code!H37","v":18030},4476,2932,1544,{"$f":"ROUND((F40*code!$P$23),0)","v":7720},1544,null,null,{"$f":"code!H78","v":51760},12849,8418,4431,{"$f":"ROUND((N40*code!$P$23),0)","v":22155},4431]
[null,null,{"$f":"code!H38","v":18520},4597,3012,1585,{"$f":"ROUND((F41*code!$P$23),0)","v":7925},1585,null,1300,{"$f":"code!H79","v":53060},13172,8630,4542,{"$f":"ROUND((N41*code!$P$23),0)","v":22710},4542]
[null,530,{"$f":"code!H39","v":19050},4729,3098,1631,{"$f":"ROUND((F42*code!$P$23),0)","v":8155},1631,null,null,{"$f":"code!H80","v":54360},13494,8841,4653,{"$f":"ROUND((N42*code!$P$23),0)","v":23265},4653]
[null,null,{"$f":"code!H40","v":19580},4861,3184,1677,{"$f":"ROUND((F43*code!$P$23),0)","v":8385},1677,null,null,{"$f":"code!H81","v":55660},13817,9053,4764,{"$f":"ROUND((N43*code!$P$23),0)","v":23820},4764]
[null,null,{"$f":"code!H41","v":20110},4992,3271,1721,{"$f":"ROUND((F44*code!$P$23),0)","v":8605},1721,null,{"$f":"K44","v":""},{"$f":"UPPER($R$14)","v":""},{"$f":"$K$44","v":""},{"$f":"$K$44","v":""},"","",""]
[null,570,{"$f":"code!H42","v":20680},5134,3363,1771,{"$f":"ROUND((F45*code!$P$23),0)","v":8855},1771,null,{"$f":"K44","v":""},{"$f":"$K$44","v":""},{"$f":"$K$44","v":""},"","","",""]
[null,null,{"$f":"CONCATENATE(\"Prepared by:\",UPPER(R14),\" \",\" Visit:www.gsreddy.tk,cell:9666570250\")","v":"Prepared by:  Visit:www.gsreddy.tk,cell:9666570250"}]
[null,null,null,null,null,{"$f":"IF(S20=0,\" \",\"GS/PRE,\"&UPPER(S20)&\" UNIT\")","v":"GS/PRE,XYZ UNIT"}]

{"sheet":"code","index":1,"n_rows":81,"n_cols":23,"rows_kept":81,"cut":false,"hidden":true,"merged":[[6,10,6,11],[6,14,6,15],[69,9,69,11],[13,2,13,3]]}
[]
[null,null,null,null,null,null,1,6700]
[null,null,null,null,null,null,2,6900]
[null,null,null,null,null,null,3,7100]
[null,null,null,null,"D.A READY RECKONER",null,4,7300]
[null,null,null,null,null,null,5,7520,null,{"$f":"DATE(M8,K8,1)","v":"2010-07-01"},{"$f":"DAY(J6)&\"-\"&MONTH(J6)&\"-\"&YEAR(J6)","v":"1-7-2010"},null,null,null,{"$f":"DATE(Q8,O8,1)","v":"2010-12-01"},{"$f":"DAY(O6)&\"-\"&R6&\"-\"&YEAR(O6)","v":"1-11-2010"},{"$f":"DAY(O6)&\"-\"&MONTH(O6)&\"-\"&YEAR(O6)","v":"1-12-2010"},{"$f":"IF(O8=1,12,O8-1)","v":11}]
[null,null,null,null,null,null,6,7740,null,null,"ZPPF",null,null,null,"CASH"]
[null,null,null,null,null,null,7,7960,null,{"$f":"LOOKUP(K8,J9:K20,K9:K20)","v":"Jul"},7,1,{"$f":"LOOKUP(L8,J9:L11,L9:L11)","v":2010},{"$f":"LOOKUP(O8,N9:O20,O9:O20)","v":"Dec"},12,1,{"$f":"LOOKUP(P8,N9:P11,P9:P11)","v":2010},1,{"$f":"LOOKUP(R8,Q9:R11,R9:R11)","v":"ZPPF"}]
[null,null,null,null,5,null,8,8200,null,1,"Jan",2010,null,1,"Jan",2010,1,"ZPPF"]
[null,null,null,null,1,null,9,8440,null,2,"Feb",2011,null,2,"Feb",2011,2,"GPF"]
[null,null,null,null,null,null,10,8680,null,3,"Mar",2012,null,3,"Mar",2012,3,"CSS"]
[null,null,null,null,null,null,11,8940,null,4,"Apr",null,null,4,"Apr",null,null,null,null,null,{"$f":"UPPER(LEFT('DA S0FTWARE'!$R$14,1)&\"  \"&MID('DA S0FTWARE'!$R$14,2,1)&\"  \"&MID('DA S0FTWARE'!$R$14,3,1)&\"  \"&MID('DA S0FTWARE'!$R$14,4,1)&\"  \"&MID('DA S0FTWARE'!$R$14,5,1)&\"  \"&MID('DA S0FTWARE'!$R$14,6,1)&\"  \"&MID('DA S0FTWARE'!$R$14,7,1)&\"  \"&MID('DA S0FTWARE'!$R$14,8,1)&\"  \"&MID('DA S0FTWARE'!$R$14,9,1))","v":"                "}]
[null,null,null,null,null,null,12,9200,null,5,"May",null,null,5,"May",null,null,null,null,null,{"$f":"UPPER('DA S0FTWARE'!$R$14)","v":""}]
[null,null,"Feb",null,null,null,13,9460,null,6,"Jun",null,null,6,"Jun"]
[null,null,2010,28,null,null,14,9740,null,7,"Jul",null,null,7,"Jul"]
[null,null,2011,28,null,null,15,10020,null,8,"Aug",null,null,8,"Aug"]
[null,null,2012,29,null,null,16,10300,null,9,"Sep",null,null,9,"Sep"]
[null,null,2013,28,null,null,17,10600,null,10,"Oct",null,null,10,"Oct"]
[null,null,2014,28,null,null,18,10900,null,11,"Nov",null,null,11,"Nov"]
[null,null,2015,28,null,null,19,11200,null,12,"Dec",null,null,12,"Dec"]
[null,null,2016,29,null,null,20,11530]
[null,null,1,31,{"$f":"LOOKUP(V24,C22:D33,D22:D33)","v":30},null,21,11860,null,null,"ZPPF",null,null,"ZPPF",null,"Diff",null,null,null,{"$f":"DATE(YEAR(T23),MONTH(T23),1)","v":"2011-11-01"}]
[null,null,2,{"$f":"IF(OR(YEAR(T22)=2012,YEAR(T22)=2016),29,28)","v":28},null,null,22,12190,null,{"$f":"CONCATENATE(J8,\" \",RIGHT(M8,2))","v":"Jul 10"},{"$f":"MATCH(J23,K24:K59,0)","v":7},null,{"$f":"CONCATENATE(N8,\" \",RIGHT(Q8,2))","v":"Dec 10"},{"$f":"MATCH(M23,N24:N59,0)","v":12},null,{"$f":"N23-K23","v":5},null,null,null,{"$f":"T24","v":"Nov 10"}]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J24)","v":" "},3,31,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K24)","v":" "},null,23,12550,null,1,{"$f":"CONCATENATE(K9,\" \",RIGHT($L$9,2))","v":"Jan 10"},null,{"$f":"J24","v":1},{"$f":"K24","v":"Jan 10"},null,null,1,"Jan 10",null,{"$f":"LOOKUP(N23,Q24:R61,S24:S60)","v":"Nov 10"},{"$f":"LEFT(T24,3)","v":"Nov"},{"$f":"MATCH(U24,O9:O20,0)","v":11},{"$f":"CONCATENATE(V24,\"/\",RIGHT(T24,2))","v":"11/10"}]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J25)","v":" "},4,30,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K25)","v":" "},null,24,12910,null,2,{"$f":"CONCATENATE(K10,\" \",RIGHT($L$9,2))","v":"Feb 10"},null,2,"Feb 10",null,null,2,"Feb 10","Jan 10"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J26)","v":" "},5,31,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K26)","v":" "},null,25,13270,null,3,"Mar 10",null,3,"Mar 10",null,null,3,"Mar 10","Feb 10"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J27)","v":" "},6,30,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K27)","v":" "},null,26,13660,null,4,"Apr 10",null,4,"Apr 10",null,null,4,"Apr 10","Mar 10"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J28)","v":" "},7,31,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K28)","v":" "},null,27,14050,null,5,"May 10",null,5,"May 10",null,null,5,"May 10","Apr 10"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J29)","v":" "},8,31,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K29)","v":" "},null,28,14440,null,6,"Jun 10",null,6,"Jun 10",null,null,6,"Jun 10","May 10"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J30)","v":" "},9,30,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K30)","v":" "},null,29,14860,null,7,"Jul 10",null,7,"Jul 10",null,null,7,"Jul 10","Jun 10"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J31)","v":" "},10,31,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K31)","v":" "},null,30,15280,null,8,"Aug 10",null,8,"Aug 10",null,null,8,"Aug 10","Jul 10"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J32)","v":" "},11,30,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K32)","v":" "},null,31,15700,null,9,"Sep 10",null,9,"Sep 10",null,null,9,"Sep 10","Aug 10"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J33)","v":" "},12,31,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K33)","v":" "},null,32,16150,null,10,{"$f":"CONCATENATE(K18,\" \",RIGHT($L$9,2))","v":"Oct 10"},null,10,"Oct 10",null,null,10,"Oct 10","Sep 10"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J34)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K34)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K34)","v":" "},null,33,16600,null,11,"Nov 10",null,11,"Nov 10",null,null,11,"Nov 10","Oct 10"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J35)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K35)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K35)","v":" "},null,34,17050,null,12,"Dec 10",null,12,"Dec 10",null,null,12,"Dec 10","Nov 10"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J36)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K36)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K36)","v":" "},null,35,17540,null,13,{"$f":"CONCATENATE(K9,\" \",RIGHT($L$10,2))","v":"Jan 11"},null,13,"Jan 11",null,null,13,"Jan 11","Dec 10"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J37)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K37)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K37)","v":" "},null,36,18030,null,14,{"$f":"CONCATENATE(K10,\" \",RIGHT($L$10,2))","v":"Feb 11"},null,14,"Feb 11",null,null,14,"Feb 11","Jan 11"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J38)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K38)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K38)","v":" "},null,37,18520,null,15,"Mar 11",null,15,"Mar 11",null,null,15,"Mar 11","Feb 11"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J39)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K39)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K39)","v":" "},null,38,19050,null,16,"Apr 11",null,16,"Apr 11",null,null,16,"Apr 11","Mar 11"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J40)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K40)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K40)","v":" "},null,39,19580,null,17,"May 11",null,17,"May 11",null,null,17,"May 11","Apr 11"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J41)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K41)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K41)","v":" "},null,40,20110,null,18,"Jun 11",null,18,"Jun 11",null,null,18,"Jun 11","May 11"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J42)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K42)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K42)","v":" "},null,41,20680,null,19,"Jul 11",null,19,"Jul 11",null,null,19,"Jul 11","Jun 11"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J43)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K43)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K43)","v":" "},null,42,21250,null,20,"Aug 11",null,20,"Aug 11",null,null,20,"Aug 11","Jul 11"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J44)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K44)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K44)","v":" "},null,43,21820,null,21,"Sep 11",null,21,"Sep 11",null,null,21,"Sep 11","Aug 11"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J45)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K45)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K45)","v":" "},null,44,22430,null,22,"Oct 11",null,22,"Oct 11",null,null,22,"Oct 11","Sep 11"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J46)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K46)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K46)","v":" "},null,45,23040,null,23,"Nov 11",null,23,"Nov 11",null,null,23,"Nov 11","Oct 11"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J47)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K47)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K47)","v":" "},null,46,23650,null,24,"Dec 11",null,24,"Dec 11",null,null,24,"Dec 11","Nov 11"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J48)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K48)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K48)","v":" "},null,47,24300,null,25,{"$f":"CONCATENATE(K9,\" \",RIGHT($L$11,2))","v":"Jan 12"},null,25,"Jan 12",null,null,25,"Jan 12","Dec 11"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J49)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K49)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K49)","v":" "},null,48,24950,null,26,{"$f":"CONCATENATE(K10,\" \",RIGHT($L$11,2))","v":"Feb 12"},null,26,"Feb 12",null,null,26,"Feb 12","Jan 12"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J50)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K50)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K50)","v":" "},null,49,25600,null,27,"Mar 12",null,27,"Mar 12",null,null,27,"Mar 12","Feb 12"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J51)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K51)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K51)","v":" "},null,50,26300,null,28,"Apr 12",null,28,"Apr 12",null,null,28,"Apr 12","Mar 12"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J52)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K52)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K52)","v":" "},null,51,27000,null,29,"May 12",null,29,"May 12",null,null,29,"May 12","Apr 12"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J53)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K53)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K53)","v":" "},null,52,27700,null,30,"Jun 12",null,30,"Jun 12",null,null,30,"Jun 12","May 12"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J54)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K54)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K54)","v":" "},null,53,28450,null,31,"Jul 12",null,31,"Jul 12",null,null,31,"Jul 12","Jun 12"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J55)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K55)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K55)","v":" "},null,54,29200,null,32,"Aug 12",null,32,"Aug 12",null,null,32,"Aug 12","Jul 12"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J56)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K56)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K56)","v":" "},null,55,29950,null,33,"Sep 12",null,33,"Sep 12",null,null,33,"Sep 12","Aug 12"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J57)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K57)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K57)","v":" "},null,56,30750,null,34,"Oct 12",null,34,"Oct 12",null,null,34,"Oct 12","Sep 12"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J58)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K58)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K58)","v":" "},null,57,31550,null,35,"Nov 12",null,35,"Nov 12",null,null,35,"Nov 12","Oct 12"]
[null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!J59)","v":" "},{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K59)","v":" "},null,{"$f":"IF('DA S0FTWARE'!$R$18=0,\" \",code!K59)","v":" "},null,58,32350,null,36,"Dec 12",null,36,"Dec 12",null,null,36,"Dec 12","Nov 12"]
[null,null,null,null,null,null,59,33200,null,null,null,null,0,0,null,null,37,null,"Dec 12"]
[null,null,null,null,null,null,60,34050]
[null,null,null,null,null,null,61,34900,null,24,7,{"$f":"LOOKUP(K62,J24:K59,K24:K59)","v":"Jul 10"},{"$f":"IF('DA S0FTWARE'!R18>0,code!J62,0)","v":0}]
[null,null,null,null,null,null,62,35800,null,{"$f":"CONCATENATE(J62,\" \",L62)","v":"24 Jul 10"},{"$f":"MONTH(J63)","v":7},{"$f":"RIGHT(L62,2)","v":"10"}]
[null,null,null,null,null,null,63,36700,null,{"$f":"IF(M62>0,M62&\"-\"&K63&\"-\"&L63,0)","v":0}]
[null,null,null,null,null,null,64,37600]
[null,null,null,null,null,null,65,38570]
[null,null,null,null,null,null,66,39540,null,null,null,null,null,"_______"]
[null,null,null,null,null,null,67,40510,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-7-2010                  G.O(P).No:_______,Dt:_______"}]
[null,null,null,null,null,null,68,41550]
[null,null,null,null,null,null,69,42590,null,{"$f":"IF('DA S0FTWARE'!R18=\" \",_________,'DA S0FTWARE'!R18)","v":0},null,null,null,{"$f":"IF('DA S0FTWARE'!R18=0,N67,'DA S0FTWARE'!R18)","v":"_______"},{"$f":"IF('DA S0FTWARE'!R18=J64,N67,J64)","v":"_______"}]
[null,null,null,null,null,null,70,43630]
[null,null,null,null,null,null,71,44740]
[null,null,null,null,null,null,72,45850]
[null,null,null,null,null,null,73,46960]
[null,null,null,null,null,null,74,48160]
[null,null,null,null,null,null,75,49360]
[null,null,null,null,null,null,76,50560]
[null,null,null,null,null,null,77,51760]
[null,null,null,null,null,null,78,53060]
[null,null,null,null,null,null,79,54360]
[null,null,null,null,null,null,80,55660]

{"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]