{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Home","jan","feb","mar","apr","may","jun","july","aug","sep","oct","nov","dec"],"not_rendered":{"images":5,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":3,"n_cols":2,"rows_kept":3,"merged":[[1,1,1,12],[2,1,2,12]]}
[]
[null,"DEEPAK EDUWORLD PVT LTD"]
[null,"Attendance Register For Year 2010"]

{"sheet":"jan","index":1,"n_rows":24,"n_cols":50,"rows_kept":24,"merged":[[1,2,3,35],[1,37,3,49],[5,1,5,4],[5,5,5,6],[5,10,5,14],[5,16,5,21],[7,3,8,3],[7,37,8,37],[7,38,8,38],[7,39,8,39],[7,40,8,40],[7,41,8,41],[7,42,8,42],[7,43,8,43],[7,44,8,44],[7,45,8,45],[7,46,8,46],[7,47,8,47],[7,48,8,48],[7,49,8,49]]}
[]
[null,null,"Deepak EduWorld Pvt Ltd",{"$nulls":34},"Salary Calculatrion"]
[]
[]
[]
[null,"Attandance Sheet For Month",{"$nulls":3},{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,255)","v":"jan"},{"$nulls":4},{"$f":"DATEVALUE(\"1\"&F6)","v":"2019-01-01"},{"$nulls":4},"To ",{"$f":"EOMONTH(K6,0)","v":"2019-01-31"}]
[]
[null,"Emp Id","Name","Date Of \nJoining","Post",{"$f":"TEXT(F9,\"ddd\")","v":"Tue"},{"$f":"TEXT(G9,\"ddd\")","v":"Wed"},{"$f":"TEXT(H9,\"ddd\")","v":"Thu"},"Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu",null,"Presence","Absence","Leave\n Taken","Allowed \nLeave","Leave\n Charges","Total Days\nof month","Total Payable\nDays","Basic \nSalary","PF 5%","Per Day\nAmount","HRA","Total\nAmount","In Hand \nSalary"]
[{"$nulls":5},{"$f":"K6","v":"2019-01-01"},{"$f":"IF(F9<$Q$6,F9+1,\"\")","v":"2019-01-02"},"2019-01-03","2019-01-04","2019-01-05","2019-01-06","2019-01-07","2019-01-08","2019-01-09","2019-01-10","2019-01-11","2019-01-12","2019-01-13","2019-01-14","2019-01-15","2019-01-16","2019-01-17","2019-01-18","2019-01-19","2019-01-20","2019-01-21","2019-01-22","2019-01-23","2019-01-24","2019-01-25","2019-01-26","2019-01-27","2019-01-28","2019-01-29","2019-01-30","2019-01-31"]
[null,"P001","Name 1","2019-01-01","Manager","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","a","a","a","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(jan!$F10:$AJ10,\"p\")","v":24},{"$f":"COUNTIF(jan!$F10:$AJ10,\"a\")","v":3},{"$f":"COUNTIF(jan!$F10:$AJ10,\"l\")","v":0},2,{"$f":"IF(AN10>AO10,AN10-AO10,0)","v":0},{"$f":"DAY($Q$6)","v":31},{"$f":"IF(AL10=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL10)","v":28},15000,{"$f":"AS10*5%","v":750},{"$f":"AS10/AQ10","v":{"v":483.8709677419355,"d":"484"}},{"$f":"IF(AS10>20000,3000,2000)","v":2000},{"$f":"AU10*AR10","v":13548.387096774193},{"$f":"IF(AL10=0,0,AW10+AV10-AT10)","v":{"v":14798.387096774193,"d":"14798"}}]
[null,"P002","Name 2","2019-01-02","Officer","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(jan!$F11:$AJ11,\"p\")","v":27},{"$f":"COUNTIF(jan!$F11:$AJ11,\"a\")","v":0},{"$f":"COUNTIF(jan!$F11:$AJ11,\"l\")","v":0},2,{"$f":"IF(AN11>AO11,AN11-AO11,0)","v":0},31,{"$f":"IF(AL11=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL11)","v":31},16000,{"$f":"AS11*5%","v":800},{"$f":"AS11/AQ11","v":{"v":516.1290322580645,"d":"516"}},{"$f":"IF(AS11>20000,3000,2000)","v":2000},{"$f":"AU11*AR11","v":16000},{"$f":"IF(AL11=0,0,AW11+AV11-AT11)","v":17200}]
[null,"P003","Name 3","2019-01-03","Clark","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(jan!$F12:$AJ12,\"p\")","v":27},{"$f":"COUNTIF(jan!$F12:$AJ12,\"a\")","v":0},{"$f":"COUNTIF(jan!$F12:$AJ12,\"l\")","v":0},2,0,31,31,17000,850,{"v":548.3870967741935,"d":"548"},2000,17000,18150]
[null,"P004","Name 4","2019-01-04","Manager","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(jan!$F13:$AJ13,\"p\")","v":27},{"$f":"COUNTIF(jan!$F13:$AJ13,\"a\")","v":0},{"$f":"COUNTIF(jan!$F13:$AJ13,\"l\")","v":0},2,0,31,31,18000,900,{"v":580.6451612903226,"d":"581"},2000,18000,19100]
[null,"P005","Name 5","2019-01-05","Officer","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(jan!$F14:$AJ14,\"p\")","v":27},{"$f":"COUNTIF(jan!$F14:$AJ14,\"a\")","v":0},{"$f":"COUNTIF(jan!$F14:$AJ14,\"l\")","v":0},2,0,31,31,19000,950,{"v":612.9032258064516,"d":"613"},2000,19000,20050]
[null,"P006","Name 6","2019-01-06","Clark","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(jan!$F15:$AJ15,\"p\")","v":27},{"$f":"COUNTIF(jan!$F15:$AJ15,\"a\")","v":0},{"$f":"COUNTIF(jan!$F15:$AJ15,\"l\")","v":0},2,0,31,31,20000,1000,{"v":645.1612903225806,"d":"645"},2000,20000,21000]
[null,"P007","Name 7","2019-01-07","Manager","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(jan!$F16:$AJ16,\"p\")","v":27},{"$f":"COUNTIF(jan!$F16:$AJ16,\"a\")","v":0},{"$f":"COUNTIF(jan!$F16:$AJ16,\"l\")","v":0},2,0,31,31,21000,1050,{"v":677.4193548387096,"d":"677"},3000,21000,22950]
[null,"P008","Name 8","2019-01-08","Officer","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(jan!$F17:$AJ17,\"p\")","v":27},{"$f":"COUNTIF(jan!$F17:$AJ17,\"a\")","v":0},{"$f":"COUNTIF(jan!$F17:$AJ17,\"l\")","v":0},2,0,31,31,22000,1100,{"v":709.6774193548387,"d":"710"},3000,22000,23900]
[null,"P009","Name 9","2019-01-09","Clark","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(jan!$F18:$AJ18,\"p\")","v":27},{"$f":"COUNTIF(jan!$F18:$AJ18,\"a\")","v":0},{"$f":"COUNTIF(jan!$F18:$AJ18,\"l\")","v":0},2,0,31,31,23000,1150,{"v":741.9354838709677,"d":"742"},3000,23000,24850]
[null,"P010","Name 10","2019-01-10","Manager","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(jan!$F19:$AJ19,\"p\")","v":27},{"$f":"COUNTIF(jan!$F19:$AJ19,\"a\")","v":0},{"$f":"COUNTIF(jan!$F19:$AJ19,\"l\")","v":0},2,0,31,31,24000,1200,{"v":774.1935483870968,"d":"774"},3000,24000,25800]
[null,"P011","Name 11","2019-01-11","Officer","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p","p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(jan!$F20:$AJ20,\"p\")","v":27},{"$f":"COUNTIF(jan!$F20:$AJ20,\"a\")","v":0},{"$f":"COUNTIF(jan!$F20:$AJ20,\"l\")","v":0},2,0,31,31,25000,1250,{"v":806.4516129032259,"d":"806"},3000,25000,26750]
[null,"P012","Name 12","2019-01-12","Manager",{"$nulls":32},{"$f":"COUNTIF(jan!$F21:$AJ21,\"p\")","v":0},{"$f":"COUNTIF(jan!$F21:$AJ21,\"a\")","v":0},{"$f":"COUNTIF(jan!$F21:$AJ21,\"l\")","v":0},2,{"$f":"IF(AN21>AO21,AN21-AO21,0)","v":0},31,0,26000,1300,{"$f":"AS21/AQ21","v":{"v":838.7096774193549,"d":"839"}},{"$f":"IF(AS21>20000,3000,2000)","v":3000},{"$f":"AU21*AR21","v":0},{"$f":"IF(AL21=0,0,AW21+AV21-AT21)","v":0}]
[null,"P013","Name 13","2019-01-13","Officer",{"$nulls":32},{"$f":"COUNTIF(jan!$F22:$AJ22,\"p\")","v":0},{"$f":"COUNTIF(jan!$F22:$AJ22,\"a\")","v":0},{"$f":"COUNTIF(jan!$F22:$AJ22,\"l\")","v":0},2,0,31,0,27000,1350,{"v":870.9677419354839,"d":"871"},3000,0,0]
[null,"P014","Name 14","2019-01-14","Clark",{"$nulls":32},{"$f":"COUNTIF(jan!$F23:$AJ23,\"p\")","v":0},{"$f":"COUNTIF(jan!$F23:$AJ23,\"a\")","v":0},{"$f":"COUNTIF(jan!$F23:$AJ23,\"l\")","v":0},2,0,31,0,28000,1400,{"v":903.2258064516129,"d":"903"},3000,0,0]
[null,"P015","Name 15","2019-01-15","Manager",{"$nulls":32},{"$f":"COUNTIF(jan!$F24:$AJ24,\"p\")","v":0},{"$f":"COUNTIF(jan!$F24:$AJ24,\"a\")","v":0},{"$f":"COUNTIF(jan!$F24:$AJ24,\"l\")","v":0},2,0,31,0,29000,1450,{"v":935.483870967742,"d":"935"},3000,0,0]

{"sheet":"feb","index":2,"n_rows":24,"n_cols":50,"rows_kept":24,"merged":[[1,2,3,35],[1,37,3,49],[5,1,5,4],[5,5,5,6],[5,10,5,14],[5,16,5,21],[7,3,8,3],[7,37,8,37],[7,38,8,38],[7,39,8,39],[7,40,8,40],[7,41,8,41],[7,42,8,42],[7,43,8,43],[7,44,8,44],[7,45,8,45],[7,46,8,46],[7,47,8,47],[7,48,8,48],[7,49,8,49]]}
[]
[null,null,"Deepak EduWorld Pvt Ltd",{"$nulls":34},"Salary Calculatrion"]
[]
[]
[]
[null,"Attandance Sheet For Month",{"$nulls":3},{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,255)","v":"feb"},{"$nulls":4},{"$f":"DATEVALUE(\"1\"&F6)","v":"2019-02-01"},{"$nulls":4},"To ",{"$f":"EOMONTH(K6,0)","v":"2019-02-28"}]
[]
[null,"Emp Id","Name","Date Of \nJoining","Post",{"$f":"TEXT(F9,\"ddd\")","v":"Fri"},{"$f":"TEXT(G9,\"ddd\")","v":"Sat"},{"$f":"TEXT(H9,\"ddd\")","v":"Sun"},"Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","","","",null,"Presence","Absence","Leave\n Taken","Allowed \nLeave","Leave\n Charges","Total Days\nof month","Total Payable\nDays","Basic \nSalary","PF 5%","Per Day\nAmount","HRA","Total\nAmount","In Hand \nSalary"]
[{"$nulls":5},{"$f":"K6","v":"2019-02-01"},{"$f":"IF(F9<$Q$6,F9+1,\"\")","v":"2019-02-02"},"2019-02-03","2019-02-04","2019-02-05","2019-02-06","2019-02-07","2019-02-08","2019-02-09","2019-02-10","2019-02-11","2019-02-12","2019-02-13","2019-02-14","2019-02-15","2019-02-16","2019-02-17","2019-02-18","2019-02-19","2019-02-20","2019-02-21","2019-02-22","2019-02-23","2019-02-24","2019-02-25","2019-02-26","2019-02-27","2019-02-28","","",""]
[null,"P001","Name 1","2019-01-01","Manager","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","a","a",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(feb!$F10:$AJ10,\"p\")","v":21},{"$f":"COUNTIF(feb!$F10:$AJ10,\"a\")","v":2},{"$f":"COUNTIF(feb!$F10:$AJ10,\"l\")","v":0},2,{"$f":"IF(AN10>AO10,AN10-AO10,0)","v":0},{"$f":"DAY($Q$6)","v":28},{"$f":"IF(AL10=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL10)","v":25},15000,{"$f":"AS10*5%","v":750},{"$f":"AS10/AQ10","v":{"v":535.7142857142857,"d":"536"}},{"$f":"IF(AS10>20000,3000,2000)","v":2000},{"$f":"AU10*AR10","v":13392.857142857141},{"$f":"IF(AL10=0,0,AW10+AV10-AT10)","v":{"v":14642.857142857141,"d":"14643"}}]
[null,"P002","Name 2","2019-01-02","Officer","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(feb!$F11:$AJ11,\"p\")","v":23},{"$f":"COUNTIF(feb!$F11:$AJ11,\"a\")","v":0},{"$f":"COUNTIF(feb!$F11:$AJ11,\"l\")","v":0},2,{"$f":"IF(AN11>AO11,AN11-AO11,0)","v":0},28,{"$f":"IF(AL11=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL11)","v":27},16000,{"$f":"AS11*5%","v":800},{"$f":"AS11/AQ11","v":{"v":571.4285714285714,"d":"571"}},{"$f":"IF(AS11>20000,3000,2000)","v":2000},{"$f":"AU11*AR11","v":15428.57142857143},{"$f":"IF(AL11=0,0,AW11+AV11-AT11)","v":{"v":16628.571428571428,"d":"16629"}}]
[null,"P003","Name 3","2019-01-03","Clark","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(feb!$F12:$AJ12,\"p\")","v":23},{"$f":"COUNTIF(feb!$F12:$AJ12,\"a\")","v":0},{"$f":"COUNTIF(feb!$F12:$AJ12,\"l\")","v":0},2,0,28,27,17000,850,{"v":607.1428571428571,"d":"607"},2000,16392.85714285714,{"v":17542.85714285714,"d":"17543"}]
[null,"P004","Name 4","2019-01-04","Manager","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(feb!$F13:$AJ13,\"p\")","v":23},{"$f":"COUNTIF(feb!$F13:$AJ13,\"a\")","v":0},{"$f":"COUNTIF(feb!$F13:$AJ13,\"l\")","v":0},2,0,28,27,18000,900,{"v":642.8571428571429,"d":"643"},2000,17357.14285714286,{"v":18457.14285714286,"d":"18457"}]
[null,"P005","Name 5","2019-01-05","Officer","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(feb!$F14:$AJ14,\"p\")","v":23},{"$f":"COUNTIF(feb!$F14:$AJ14,\"a\")","v":0},{"$f":"COUNTIF(feb!$F14:$AJ14,\"l\")","v":0},2,0,28,27,19000,950,{"v":678.5714285714286,"d":"679"},2000,18321.428571428572,{"v":19371.428571428572,"d":"19371"}]
[null,"P006","Name 6","2019-01-06","Clark","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(feb!$F15:$AJ15,\"p\")","v":23},{"$f":"COUNTIF(feb!$F15:$AJ15,\"a\")","v":0},{"$f":"COUNTIF(feb!$F15:$AJ15,\"l\")","v":0},2,0,28,27,20000,1000,{"v":714.2857142857143,"d":"714"},2000,19285.714285714286,{"v":20285.714285714286,"d":"20286"}]
[null,"P007","Name 7","2019-01-07","Manager","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(feb!$F16:$AJ16,\"p\")","v":23},{"$f":"COUNTIF(feb!$F16:$AJ16,\"a\")","v":0},{"$f":"COUNTIF(feb!$F16:$AJ16,\"l\")","v":0},2,0,28,27,21000,1050,750,3000,20250,22200]
[null,"P008","Name 8","2019-01-08","Officer","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(feb!$F17:$AJ17,\"p\")","v":23},{"$f":"COUNTIF(feb!$F17:$AJ17,\"a\")","v":0},{"$f":"COUNTIF(feb!$F17:$AJ17,\"l\")","v":0},2,0,28,27,22000,1100,{"v":785.7142857142857,"d":"786"},3000,21214.285714285714,{"v":23114.285714285714,"d":"23114"}]
[null,"P009","Name 9","2019-01-09","Clark","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(feb!$F18:$AJ18,\"p\")","v":23},{"$f":"COUNTIF(feb!$F18:$AJ18,\"a\")","v":0},{"$f":"COUNTIF(feb!$F18:$AJ18,\"l\")","v":0},2,0,28,27,23000,1150,{"v":821.4285714285714,"d":"821"},3000,22178.571428571428,{"v":24028.571428571428,"d":"24029"}]
[null,"P010","Name 10","2019-01-10","Manager","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(feb!$F19:$AJ19,\"p\")","v":23},{"$f":"COUNTIF(feb!$F19:$AJ19,\"a\")","v":0},{"$f":"COUNTIF(feb!$F19:$AJ19,\"l\")","v":0},2,0,28,27,24000,1200,{"v":857.1428571428571,"d":"857"},3000,23142.85714285714,{"v":24942.85714285714,"d":"24943"}]
[null,"P011","Name 11","2019-01-11","Officer","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(feb!$F20:$AJ20,\"p\")","v":23},{"$f":"COUNTIF(feb!$F20:$AJ20,\"a\")","v":0},{"$f":"COUNTIF(feb!$F20:$AJ20,\"l\")","v":0},2,0,28,27,25000,1250,{"v":892.8571428571429,"d":"893"},3000,24107.14285714286,{"v":25857.14285714286,"d":"25857"}]
[null,"P012","Name 12","2019-01-12","Manager",{"$nulls":32},{"$f":"COUNTIF(feb!$F21:$AJ21,\"p\")","v":0},{"$f":"COUNTIF(feb!$F21:$AJ21,\"a\")","v":0},{"$f":"COUNTIF(feb!$F21:$AJ21,\"l\")","v":0},2,0,28,0,26000,1300,{"v":928.5714285714286,"d":"929"},3000,0,0]
[null,"P013","Name 13","2019-01-13","Officer",{"$nulls":32},{"$f":"COUNTIF(feb!$F22:$AJ22,\"p\")","v":0},{"$f":"COUNTIF(feb!$F22:$AJ22,\"a\")","v":0},{"$f":"COUNTIF(feb!$F22:$AJ22,\"l\")","v":0},2,0,28,0,27000,1350,{"v":964.2857142857143,"d":"964"},3000,0,0]
[null,"P014","Name 14","2019-01-14","Clark",{"$nulls":32},{"$f":"COUNTIF(feb!$F23:$AJ23,\"p\")","v":0},{"$f":"COUNTIF(feb!$F23:$AJ23,\"a\")","v":0},{"$f":"COUNTIF(feb!$F23:$AJ23,\"l\")","v":0},2,0,28,0,28000,1400,1000,3000,0,0]
[null,"P015","Name 15","2019-01-15","Manager",{"$nulls":32},{"$f":"COUNTIF(feb!$F24:$AJ24,\"p\")","v":0},{"$f":"COUNTIF(feb!$F24:$AJ24,\"a\")","v":0},{"$f":"COUNTIF(feb!$F24:$AJ24,\"l\")","v":0},2,0,28,0,29000,1450,{"v":1035.7142857142858,"d":"1036"},3000,0,0]

{"sheet":"mar","index":3,"n_rows":24,"n_cols":50,"rows_kept":24,"merged":[[1,2,3,35],[1,37,3,49],[5,1,5,4],[5,5,5,6],[5,10,5,14],[5,16,5,21],[7,3,8,3],[7,37,8,37],[7,38,8,38],[7,39,8,39],[7,40,8,40],[7,41,8,41],[7,42,8,42],[7,43,8,43],[7,44,8,44],[7,45,8,45],[7,46,8,46],[7,47,8,47],[7,48,8,48],[7,49,8,49]]}
[]
[null,null,"Deepak EduWorld Pvt Ltd",{"$nulls":34},"Salary Calculatrion"]
[]
[]
[]
[null,"Attandance Sheet For Month",{"$nulls":3},{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,255)","v":"mar"},{"$nulls":4},{"$f":"DATEVALUE(\"1\"&F6)","v":"2019-03-01"},{"$nulls":4},"To ",{"$f":"EOMONTH(K6,0)","v":"2019-03-31"}]
[]
[null,"Emp Id","Name","Date Of \nJoining","Post",{"$f":"TEXT(F9,\"ddd\")","v":"Fri"},{"$f":"TEXT(G9,\"ddd\")","v":"Sat"},{"$f":"TEXT(H9,\"ddd\")","v":"Sun"},"Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun",null,"Presence","Absence","Leave\n Taken","Allowed \nLeave","Leave\n Charges","Total Days\nof month","Total Payable\nDays","Basic \nSalary","PF 5%","Per Day\nAmount","HRA","Total\nAmount","In Hand \nSalary"]
[{"$nulls":5},{"$f":"K6","v":"2019-03-01"},{"$f":"IF(F9<$Q$6,F9+1,\"\")","v":"2019-03-02"},"2019-03-03","2019-03-04","2019-03-05","2019-03-06","2019-03-07","2019-03-08","2019-03-09","2019-03-10","2019-03-11","2019-03-12","2019-03-13","2019-03-14","2019-03-15","2019-03-16","2019-03-17","2019-03-18","2019-03-19","2019-03-20","2019-03-21","2019-03-22","2019-03-23","2019-03-24","2019-03-25","2019-03-26","2019-03-27","2019-03-28","2019-03-29","2019-03-30","2019-03-31"]
[null,"P001","Name 1","2019-01-01","Manager","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","a","a",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(mar!$F10:$AJ10,\"p\")","v":21},{"$f":"COUNTIF(mar!$F10:$AJ10,\"a\")","v":2},{"$f":"COUNTIF(mar!$F10:$AJ10,\"l\")","v":0},2,{"$f":"IF(AN10>AO10,AN10-AO10,0)","v":0},{"$f":"DAY($Q$6)","v":31},{"$f":"IF(AL10=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL10)","v":26},15000,{"$f":"AS10*5%","v":750},{"$f":"AS10/AQ10","v":{"v":483.8709677419355,"d":"484"}},{"$f":"IF(AS10>20000,3000,2000)","v":2000},{"$f":"AU10*AR10","v":12580.645161290322},{"$f":"IF(AL10=0,0,AW10+AV10-AT10)","v":{"v":13830.645161290322,"d":"13831"}}]
[null,"P002","Name 2","2019-01-02","Officer","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(mar!$F11:$AJ11,\"p\")","v":23},{"$f":"COUNTIF(mar!$F11:$AJ11,\"a\")","v":0},{"$f":"COUNTIF(mar!$F11:$AJ11,\"l\")","v":0},2,{"$f":"IF(AN11>AO11,AN11-AO11,0)","v":0},31,{"$f":"IF(AL11=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL11)","v":28},16000,{"$f":"AS11*5%","v":800},{"$f":"AS11/AQ11","v":{"v":516.1290322580645,"d":"516"}},{"$f":"IF(AS11>20000,3000,2000)","v":2000},{"$f":"AU11*AR11","v":14451.612903225807},{"$f":"IF(AL11=0,0,AW11+AV11-AT11)","v":{"v":15651.612903225807,"d":"15652"}}]
[null,"P003","Name 3","2019-01-03","Clark","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(mar!$F12:$AJ12,\"p\")","v":23},{"$f":"COUNTIF(mar!$F12:$AJ12,\"a\")","v":0},{"$f":"COUNTIF(mar!$F12:$AJ12,\"l\")","v":0},2,0,31,28,17000,850,{"v":548.3870967741935,"d":"548"},2000,15354.838709677419,{"v":16504.838709677417,"d":"16505"}]
[null,"P004","Name 4","2019-01-04","Manager","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(mar!$F13:$AJ13,\"p\")","v":23},{"$f":"COUNTIF(mar!$F13:$AJ13,\"a\")","v":0},{"$f":"COUNTIF(mar!$F13:$AJ13,\"l\")","v":0},2,0,31,28,18000,900,{"v":580.6451612903226,"d":"581"},2000,16258.064516129032,{"v":17358.06451612903,"d":"17358"}]
[null,"P005","Name 5","2019-01-05","Officer","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(mar!$F14:$AJ14,\"p\")","v":23},{"$f":"COUNTIF(mar!$F14:$AJ14,\"a\")","v":0},{"$f":"COUNTIF(mar!$F14:$AJ14,\"l\")","v":0},2,0,31,28,19000,950,{"v":612.9032258064516,"d":"613"},2000,17161.290322580644,{"v":18211.290322580644,"d":"18211"}]
[null,"P006","Name 6","2019-01-06","Clark","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(mar!$F15:$AJ15,\"p\")","v":23},{"$f":"COUNTIF(mar!$F15:$AJ15,\"a\")","v":0},{"$f":"COUNTIF(mar!$F15:$AJ15,\"l\")","v":0},2,0,31,28,20000,1000,{"v":645.1612903225806,"d":"645"},2000,18064.516129032258,{"v":19064.516129032258,"d":"19065"}]
[null,"P007","Name 7","2019-01-07","Manager","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(mar!$F16:$AJ16,\"p\")","v":23},{"$f":"COUNTIF(mar!$F16:$AJ16,\"a\")","v":0},{"$f":"COUNTIF(mar!$F16:$AJ16,\"l\")","v":0},2,0,31,28,21000,1050,{"v":677.4193548387096,"d":"677"},3000,18967.74193548387,{"v":20917.74193548387,"d":"20918"}]
[null,"P008","Name 8","2019-01-08","Officer","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(mar!$F17:$AJ17,\"p\")","v":23},{"$f":"COUNTIF(mar!$F17:$AJ17,\"a\")","v":0},{"$f":"COUNTIF(mar!$F17:$AJ17,\"l\")","v":0},2,0,31,28,22000,1100,{"v":709.6774193548387,"d":"710"},3000,19870.96774193548,{"v":21770.96774193548,"d":"21771"}]
[null,"P009","Name 9","2019-01-09","Clark","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(mar!$F18:$AJ18,\"p\")","v":23},{"$f":"COUNTIF(mar!$F18:$AJ18,\"a\")","v":0},{"$f":"COUNTIF(mar!$F18:$AJ18,\"l\")","v":0},2,0,31,28,23000,1150,{"v":741.9354838709677,"d":"742"},3000,20774.193548387095,{"v":22624.193548387095,"d":"22624"}]
[null,"P010","Name 10","2019-01-10","Manager","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(mar!$F19:$AJ19,\"p\")","v":23},{"$f":"COUNTIF(mar!$F19:$AJ19,\"a\")","v":0},{"$f":"COUNTIF(mar!$F19:$AJ19,\"l\")","v":0},2,0,31,28,24000,1200,{"v":774.1935483870968,"d":"774"},3000,21677.419354838712,{"v":23477.419354838712,"d":"23477"}]
[null,"P011","Name 11","2019-01-11","Officer","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p",null,"p","p",null,"p","p","p","p",null,{"$f":"COUNTIF(mar!$F20:$AJ20,\"p\")","v":23},{"$f":"COUNTIF(mar!$F20:$AJ20,\"a\")","v":0},{"$f":"COUNTIF(mar!$F20:$AJ20,\"l\")","v":0},2,0,31,28,25000,1250,{"v":806.4516129032259,"d":"806"},3000,22580.645161290326,{"v":24330.645161290326,"d":"24331"}]
[null,"P012","Name 12","2019-01-12","Manager",{"$nulls":32},{"$f":"COUNTIF(mar!$F21:$AJ21,\"p\")","v":0},{"$f":"COUNTIF(mar!$F21:$AJ21,\"a\")","v":0},{"$f":"COUNTIF(mar!$F21:$AJ21,\"l\")","v":0},2,0,31,0,26000,1300,{"v":838.7096774193549,"d":"839"},3000,0,0]
[null,"P013","Name 13","2019-01-13","Officer",{"$nulls":32},{"$f":"COUNTIF(mar!$F22:$AJ22,\"p\")","v":0},{"$f":"COUNTIF(mar!$F22:$AJ22,\"a\")","v":0},{"$f":"COUNTIF(mar!$F22:$AJ22,\"l\")","v":0},2,0,31,0,27000,1350,{"v":870.9677419354839,"d":"871"},3000,0,0]
[null,"P014","Name 14","2019-01-14","Clark",{"$nulls":32},{"$f":"COUNTIF(mar!$F23:$AJ23,\"p\")","v":0},{"$f":"COUNTIF(mar!$F23:$AJ23,\"a\")","v":0},{"$f":"COUNTIF(mar!$F23:$AJ23,\"l\")","v":0},2,0,31,0,28000,1400,{"v":903.2258064516129,"d":"903"},3000,0,0]
[null,"P015","Name 15","2019-01-15","Manager",{"$nulls":32},{"$f":"COUNTIF(mar!$F24:$AJ24,\"p\")","v":0},{"$f":"COUNTIF(mar!$F24:$AJ24,\"a\")","v":0},{"$f":"COUNTIF(mar!$F24:$AJ24,\"l\")","v":0},2,0,31,0,29000,1450,{"v":935.483870967742,"d":"935"},3000,0,0]

{"sheet":"apr","index":4,"n_rows":24,"n_cols":50,"rows_kept":24,"merged":[[1,2,3,35],[1,37,3,49],[5,1,5,4],[5,5,5,6],[5,10,5,14],[5,16,5,21],[7,3,8,3],[7,37,8,37],[7,38,8,38],[7,39,8,39],[7,40,8,40],[7,41,8,41],[7,42,8,42],[7,43,8,43],[7,44,8,44],[7,45,8,45],[7,46,8,46],[7,47,8,47],[7,48,8,48],[7,49,8,49]]}
[]
[null,null,"Deepak EduWorld Pvt Ltd",{"$nulls":34},"Salary Calculatrion"]
[]
[]
[]
[null,"Attandance Sheet For Month",{"$nulls":3},{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,255)","v":"apr"},{"$nulls":4},{"$f":"DATEVALUE(\"1\"&F6)","v":"2019-04-01"},{"$nulls":4},"To ",{"$f":"EOMONTH(K6,0)","v":"2019-04-30"}]
[]
[null,"Emp Id","Name","Date Of \nJoining","Post",{"$f":"TEXT(F9,\"ddd\")","v":"Mon"},{"$f":"TEXT(G9,\"ddd\")","v":"Tue"},{"$f":"TEXT(H9,\"ddd\")","v":"Wed"},"Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","",null,"Presence","Absence","Leave\n Taken","Allowed \nLeave","Leave\n Charges","Total Days\nof month","Total Payable\nDays","Basic \nSalary","PF 5%","Per Day\nAmount","HRA","Total\nAmount","In Hand \nSalary"]
[{"$nulls":5},{"$f":"K6","v":"2019-04-01"},{"$f":"IF(F9<$Q$6,F9+1,\"\")","v":"2019-04-02"},"2019-04-03","2019-04-04","2019-04-05","2019-04-06","2019-04-07","2019-04-08","2019-04-09","2019-04-10","2019-04-11","2019-04-12","2019-04-13","2019-04-14","2019-04-15","2019-04-16","2019-04-17","2019-04-18","2019-04-19","2019-04-20","2019-04-21","2019-04-22","2019-04-23","2019-04-24","2019-04-25","2019-04-26","2019-04-27","2019-04-28","2019-04-29","2019-04-30",""]
[null,"P001","Name 1","2019-01-01","Manager","p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"a","a",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p","p",null,{"$f":"COUNTIF(apr!$F10:$AJ10,\"p\")","v":17},{"$f":"COUNTIF(apr!$F10:$AJ10,\"a\")","v":2},{"$f":"COUNTIF(apr!$F10:$AJ10,\"l\")","v":0},2,{"$f":"IF(AN10>AO10,AN10-AO10,0)","v":0},{"$f":"DAY($Q$6)","v":30},{"$f":"IF(AL10=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL10)","v":21},15000,{"$f":"AS10*5%","v":750},{"$f":"AS10/AQ10","v":500},{"$f":"IF(AS10>20000,3000,2000)","v":2000},{"$f":"AU10*AR10","v":10500},{"$f":"IF(AL10=0,0,AW10+AV10-AT10)","v":11750}]
[null,"P002","Name 2","2019-01-02","Officer","p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p","p",null,{"$f":"COUNTIF(apr!$F11:$AJ11,\"p\")","v":19},{"$f":"COUNTIF(apr!$F11:$AJ11,\"a\")","v":0},{"$f":"COUNTIF(apr!$F11:$AJ11,\"l\")","v":0},2,{"$f":"IF(AN11>AO11,AN11-AO11,0)","v":0},30,{"$f":"IF(AL11=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL11)","v":23},16000,{"$f":"AS11*5%","v":800},{"$f":"AS11/AQ11","v":{"v":533.3333333333334,"d":"533"}},{"$f":"IF(AS11>20000,3000,2000)","v":2000},{"$f":"AU11*AR11","v":12266.666666666668},{"$f":"IF(AL11=0,0,AW11+AV11-AT11)","v":{"v":13466.666666666668,"d":"13467"}}]
[null,"P003","Name 3","2019-01-03","Clark","p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p","p",null,{"$f":"COUNTIF(apr!$F12:$AJ12,\"p\")","v":19},{"$f":"COUNTIF(apr!$F12:$AJ12,\"a\")","v":0},{"$f":"COUNTIF(apr!$F12:$AJ12,\"l\")","v":0},2,0,30,23,17000,850,{"v":566.6666666666666,"d":"567"},2000,13033.333333333332,{"v":14183.333333333332,"d":"14183"}]
[null,"P004","Name 4","2019-01-04","Manager","p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p","p",null,{"$f":"COUNTIF(apr!$F13:$AJ13,\"p\")","v":19},{"$f":"COUNTIF(apr!$F13:$AJ13,\"a\")","v":0},{"$f":"COUNTIF(apr!$F13:$AJ13,\"l\")","v":0},2,0,30,23,18000,900,600,2000,13800,14900]
[null,"P005","Name 5","2019-01-05","Officer","p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p","p",null,{"$f":"COUNTIF(apr!$F14:$AJ14,\"p\")","v":19},{"$f":"COUNTIF(apr!$F14:$AJ14,\"a\")","v":0},{"$f":"COUNTIF(apr!$F14:$AJ14,\"l\")","v":0},2,0,30,23,19000,950,{"v":633.3333333333334,"d":"633"},2000,14566.666666666668,{"v":15616.666666666668,"d":"15617"}]
[null,"P006","Name 6","2019-01-06","Clark","p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p","p",null,{"$f":"COUNTIF(apr!$F15:$AJ15,\"p\")","v":19},{"$f":"COUNTIF(apr!$F15:$AJ15,\"a\")","v":0},{"$f":"COUNTIF(apr!$F15:$AJ15,\"l\")","v":0},2,0,30,23,20000,1000,{"v":666.6666666666666,"d":"667"},2000,15333.333333333332,{"v":16333.333333333332,"d":"16333"}]
[null,"P007","Name 7","2019-01-07","Manager","p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p","p",null,{"$f":"COUNTIF(apr!$F16:$AJ16,\"p\")","v":19},{"$f":"COUNTIF(apr!$F16:$AJ16,\"a\")","v":0},{"$f":"COUNTIF(apr!$F16:$AJ16,\"l\")","v":0},2,0,30,23,21000,1050,700,3000,16100,18050]
[null,"P008","Name 8","2019-01-08","Officer","p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p","p",null,{"$f":"COUNTIF(apr!$F17:$AJ17,\"p\")","v":19},{"$f":"COUNTIF(apr!$F17:$AJ17,\"a\")","v":0},{"$f":"COUNTIF(apr!$F17:$AJ17,\"l\")","v":0},2,0,30,23,22000,1100,{"v":733.3333333333334,"d":"733"},3000,16866.666666666668,{"v":18766.666666666668,"d":"18767"}]
[null,"P009","Name 9","2019-01-09","Clark","p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p","p",null,{"$f":"COUNTIF(apr!$F18:$AJ18,\"p\")","v":19},{"$f":"COUNTIF(apr!$F18:$AJ18,\"a\")","v":0},{"$f":"COUNTIF(apr!$F18:$AJ18,\"l\")","v":0},2,0,30,23,23000,1150,{"v":766.6666666666666,"d":"767"},3000,17633.333333333332,{"v":19483.333333333332,"d":"19483"}]
[null,"P010","Name 10","2019-01-10","Manager","p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p","p",null,{"$f":"COUNTIF(apr!$F19:$AJ19,\"p\")","v":19},{"$f":"COUNTIF(apr!$F19:$AJ19,\"a\")","v":0},{"$f":"COUNTIF(apr!$F19:$AJ19,\"l\")","v":0},2,0,30,23,24000,1200,800,3000,18400,20200]
[null,"P011","Name 11","2019-01-11","Officer","p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p",null,"p","p",null,null,"p","p","p",null,{"$f":"COUNTIF(apr!$F20:$AJ20,\"p\")","v":19},{"$f":"COUNTIF(apr!$F20:$AJ20,\"a\")","v":0},{"$f":"COUNTIF(apr!$F20:$AJ20,\"l\")","v":0},2,0,30,23,25000,1250,{"v":833.3333333333334,"d":"833"},3000,19166.666666666668,{"v":20916.666666666668,"d":"20917"}]
[null,"P012","Name 12","2019-01-12","Manager",{"$nulls":32},{"$f":"COUNTIF(apr!$F21:$AJ21,\"p\")","v":0},{"$f":"COUNTIF(apr!$F21:$AJ21,\"a\")","v":0},{"$f":"COUNTIF(apr!$F21:$AJ21,\"l\")","v":0},2,0,30,0,26000,1300,{"v":866.6666666666666,"d":"867"},3000,0,0]
[null,"P013","Name 13","2019-01-13","Officer",{"$nulls":32},{"$f":"COUNTIF(apr!$F22:$AJ22,\"p\")","v":0},{"$f":"COUNTIF(apr!$F22:$AJ22,\"a\")","v":0},{"$f":"COUNTIF(apr!$F22:$AJ22,\"l\")","v":0},2,0,30,0,27000,1350,900,3000,0,0]
[null,"P014","Name 14","2019-01-14","Clark",{"$nulls":32},{"$f":"COUNTIF(apr!$F23:$AJ23,\"p\")","v":0},{"$f":"COUNTIF(apr!$F23:$AJ23,\"a\")","v":0},{"$f":"COUNTIF(apr!$F23:$AJ23,\"l\")","v":0},2,0,30,0,28000,1400,{"v":933.3333333333334,"d":"933"},3000,0,0]
[null,"P015","Name 15","2019-01-15","Manager",{"$nulls":32},{"$f":"COUNTIF(apr!$F24:$AJ24,\"p\")","v":0},{"$f":"COUNTIF(apr!$F24:$AJ24,\"a\")","v":0},{"$f":"COUNTIF(apr!$F24:$AJ24,\"l\")","v":0},2,0,30,0,29000,1450,{"v":966.6666666666666,"d":"967"},3000,0,0]

{"sheet":"may","index":5,"n_rows":24,"n_cols":50,"rows_kept":24,"merged":[[1,2,3,35],[1,37,3,49],[5,1,5,4],[5,5,5,6],[5,10,5,14],[5,16,5,21],[7,3,8,3],[7,37,8,37],[7,38,8,38],[7,39,8,39],[7,40,8,40],[7,41,8,41],[7,42,8,42],[7,43,8,43],[7,44,8,44],[7,45,8,45],[7,46,8,46],[7,47,8,47],[7,48,8,48],[7,49,8,49]]}
[]
[null,null,"Deepak EduWorld Pvt Ltd",{"$nulls":34},"Salary Calculatrion"]
[]
[]
[]
[null,"Attandance Sheet For Month",{"$nulls":3},{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,255)","v":"may"},{"$nulls":4},{"$f":"DATEVALUE(\"1\"&F6)","v":"2019-05-01"},{"$nulls":4},"To ",{"$f":"EOMONTH(K6,0)","v":"2019-05-31"}]
[]
[null,"Emp Id","Name","Date Of \nJoining","Post",{"$f":"TEXT(F9,\"ddd\")","v":"Wed"},{"$f":"TEXT(G9,\"ddd\")","v":"Thu"},{"$f":"TEXT(H9,\"ddd\")","v":"Fri"},"Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri",null,"Presence","Absence","Leave\n Taken","Allowed \nLeave","Leave\n Charges","Total Days\nof month","Total Payable\nDays","Basic \nSalary","PF 5%","Per Day\nAmount","HRA","Total\nAmount","In Hand \nSalary"]
[{"$nulls":5},{"$f":"K6","v":"2019-05-01"},{"$f":"IF(F9<$Q$6,F9+1,\"\")","v":"2019-05-02"},"2019-05-03","2019-05-04","2019-05-05","2019-05-06","2019-05-07","2019-05-08","2019-05-09","2019-05-10","2019-05-11","2019-05-12","2019-05-13","2019-05-14","2019-05-15","2019-05-16","2019-05-17","2019-05-18","2019-05-19","2019-05-20","2019-05-21","2019-05-22","2019-05-23","2019-05-24","2019-05-25","2019-05-26","2019-05-27","2019-05-28","2019-05-29","2019-05-30","2019-05-31"]
[null,"P001","Name 1","2019-01-01","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F10:$AJ10,\"p\")","v":0},{"$f":"COUNTIF(may!$F10:$AJ10,\"a\")","v":0},{"$f":"COUNTIF(may!$F10:$AJ10,\"l\")","v":0},2,{"$f":"IF(AN10>AO10,AN10-AO10,0)","v":0},{"$f":"DAY($Q$6)","v":31},{"$f":"IF(AL10=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL10)","v":0},15000,{"$f":"AS10*5%","v":750},{"$f":"AS10/AQ10","v":{"v":483.8709677419355,"d":"484"}},{"$f":"IF(AS10>20000,3000,2000)","v":2000},{"$f":"AU10*AR10","v":0},{"$f":"IF(AL10=0,0,AW10+AV10-AT10)","v":0}]
[null,"P002","Name 2","2019-01-02","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F11:$AJ11,\"p\")","v":0},{"$f":"COUNTIF(may!$F11:$AJ11,\"a\")","v":0},{"$f":"COUNTIF(may!$F11:$AJ11,\"l\")","v":0},2,{"$f":"IF(AN11>AO11,AN11-AO11,0)","v":0},31,{"$f":"IF(AL11=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL11)","v":0},16000,{"$f":"AS11*5%","v":800},{"$f":"AS11/AQ11","v":{"v":516.1290322580645,"d":"516"}},{"$f":"IF(AS11>20000,3000,2000)","v":2000},{"$f":"AU11*AR11","v":0},{"$f":"IF(AL11=0,0,AW11+AV11-AT11)","v":0}]
[null,"P003","Name 3","2019-01-03","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F12:$AJ12,\"p\")","v":0},{"$f":"COUNTIF(may!$F12:$AJ12,\"a\")","v":0},{"$f":"COUNTIF(may!$F12:$AJ12,\"l\")","v":0},2,0,31,0,17000,850,{"v":548.3870967741935,"d":"548"},2000,0,0]
[null,"P004","Name 4","2019-01-04","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F13:$AJ13,\"p\")","v":0},{"$f":"COUNTIF(may!$F13:$AJ13,\"a\")","v":0},{"$f":"COUNTIF(may!$F13:$AJ13,\"l\")","v":0},2,0,31,0,18000,900,{"v":580.6451612903226,"d":"581"},2000,0,0]
[null,"P005","Name 5","2019-01-05","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F14:$AJ14,\"p\")","v":0},{"$f":"COUNTIF(may!$F14:$AJ14,\"a\")","v":0},{"$f":"COUNTIF(may!$F14:$AJ14,\"l\")","v":0},2,0,31,0,19000,950,{"v":612.9032258064516,"d":"613"},2000,0,0]
[null,"P006","Name 6","2019-01-06","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F15:$AJ15,\"p\")","v":0},{"$f":"COUNTIF(may!$F15:$AJ15,\"a\")","v":0},{"$f":"COUNTIF(may!$F15:$AJ15,\"l\")","v":0},2,0,31,0,20000,1000,{"v":645.1612903225806,"d":"645"},2000,0,0]
[null,"P007","Name 7","2019-01-07","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F16:$AJ16,\"p\")","v":0},{"$f":"COUNTIF(may!$F16:$AJ16,\"a\")","v":0},{"$f":"COUNTIF(may!$F16:$AJ16,\"l\")","v":0},2,0,31,0,21000,1050,{"v":677.4193548387096,"d":"677"},3000,0,0]
[null,"P008","Name 8","2019-01-08","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F17:$AJ17,\"p\")","v":0},{"$f":"COUNTIF(may!$F17:$AJ17,\"a\")","v":0},{"$f":"COUNTIF(may!$F17:$AJ17,\"l\")","v":0},2,0,31,0,22000,1100,{"v":709.6774193548387,"d":"710"},3000,0,0]
[null,"P009","Name 9","2019-01-09","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F18:$AJ18,\"p\")","v":0},{"$f":"COUNTIF(may!$F18:$AJ18,\"a\")","v":0},{"$f":"COUNTIF(may!$F18:$AJ18,\"l\")","v":0},2,0,31,0,23000,1150,{"v":741.9354838709677,"d":"742"},3000,0,0]
[null,"P010","Name 10","2019-01-10","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F19:$AJ19,\"p\")","v":0},{"$f":"COUNTIF(may!$F19:$AJ19,\"a\")","v":0},{"$f":"COUNTIF(may!$F19:$AJ19,\"l\")","v":0},2,0,31,0,24000,1200,{"v":774.1935483870968,"d":"774"},3000,0,0]
[null,"P011","Name 11","2019-01-11","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F20:$AJ20,\"p\")","v":0},{"$f":"COUNTIF(may!$F20:$AJ20,\"a\")","v":0},{"$f":"COUNTIF(may!$F20:$AJ20,\"l\")","v":0},2,0,31,0,25000,1250,{"v":806.4516129032259,"d":"806"},3000,0,0]
[null,"P012","Name 12","2019-01-12","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F21:$AJ21,\"p\")","v":0},{"$f":"COUNTIF(may!$F21:$AJ21,\"a\")","v":0},{"$f":"COUNTIF(may!$F21:$AJ21,\"l\")","v":0},2,0,31,0,26000,1300,{"v":838.7096774193549,"d":"839"},3000,0,0]
[null,"P013","Name 13","2019-01-13","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F22:$AJ22,\"p\")","v":0},{"$f":"COUNTIF(may!$F22:$AJ22,\"a\")","v":0},{"$f":"COUNTIF(may!$F22:$AJ22,\"l\")","v":0},2,0,31,0,27000,1350,{"v":870.9677419354839,"d":"871"},3000,0,0]
[null,"P014","Name 14","2019-01-14","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F23:$AJ23,\"p\")","v":0},{"$f":"COUNTIF(may!$F23:$AJ23,\"a\")","v":0},{"$f":"COUNTIF(may!$F23:$AJ23,\"l\")","v":0},2,0,31,0,28000,1400,{"v":903.2258064516129,"d":"903"},3000,0,0]
[null,"P015","Name 15","2019-01-15","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F24:$AJ24,\"p\")","v":0},{"$f":"COUNTIF(may!$F24:$AJ24,\"a\")","v":0},{"$f":"COUNTIF(may!$F24:$AJ24,\"l\")","v":0},2,0,31,0,29000,1450,{"v":935.483870967742,"d":"935"},3000,0,0]

{"sheet":"jun","index":6,"n_rows":24,"n_cols":50,"rows_kept":24,"merged":[[1,2,3,35],[1,37,3,49],[5,1,5,4],[5,5,5,6],[5,10,5,14],[5,16,5,21],[7,3,8,3],[7,37,8,37],[7,38,8,38],[7,39,8,39],[7,40,8,40],[7,41,8,41],[7,42,8,42],[7,43,8,43],[7,44,8,44],[7,45,8,45],[7,46,8,46],[7,47,8,47],[7,48,8,48],[7,49,8,49]]}
[]
[null,null,"Deepak EduWorld Pvt Ltd",{"$nulls":34},"Salary Calculatrion"]
[]
[]
[]
[null,"Attandance Sheet For Month",{"$nulls":3},{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,255)","v":"jun"},{"$nulls":4},{"$f":"DATEVALUE(\"1\"&F6)","v":"2019-06-01"},{"$nulls":4},"To ",{"$f":"EOMONTH(K6,0)","v":"2019-06-30"}]
[]
[null,"Emp Id","Name","Date Of \nJoining","Post",{"$f":"TEXT(F9,\"ddd\")","v":"Sat"},{"$f":"TEXT(G9,\"ddd\")","v":"Sun"},{"$f":"TEXT(H9,\"ddd\")","v":"Mon"},"Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","",null,"Presence","Absence","Leave\n Taken","Allowed \nLeave","Leave\n Charges","Total Days\nof month","Total Payable\nDays","Basic \nSalary","PF 5%","Per Day\nAmount","HRA","Total\nAmount","In Hand \nSalary"]
[{"$nulls":5},{"$f":"K6","v":"2019-06-01"},{"$f":"IF(F9<$Q$6,F9+1,\"\")","v":"2019-06-02"},"2019-06-03","2019-06-04","2019-06-05","2019-06-06","2019-06-07","2019-06-08","2019-06-09","2019-06-10","2019-06-11","2019-06-12","2019-06-13","2019-06-14","2019-06-15","2019-06-16","2019-06-17","2019-06-18","2019-06-19","2019-06-20","2019-06-21","2019-06-22","2019-06-23","2019-06-24","2019-06-25","2019-06-26","2019-06-27","2019-06-28","2019-06-29","2019-06-30",""]
[null,"P001","Name 1","2019-01-01","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F10:$AJ10,\"p\")","v":0},{"$f":"COUNTIF(may!$F10:$AJ10,\"a\")","v":0},{"$f":"COUNTIF(may!$F10:$AJ10,\"l\")","v":0},2,{"$f":"IF(AN10>AO10,AN10-AO10,0)","v":0},{"$f":"DAY($Q$6)","v":30},{"$f":"IF(AL10=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL10)","v":0},15000,{"$f":"AS10*5%","v":750},{"$f":"AS10/AQ10","v":500},{"$f":"IF(AS10>20000,3000,2000)","v":2000},{"$f":"AU10*AR10","v":0},{"$f":"IF(AL10=0,0,AW10+AV10-AT10)","v":0}]
[null,"P002","Name 2","2019-01-02","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F11:$AJ11,\"p\")","v":0},{"$f":"COUNTIF(may!$F11:$AJ11,\"a\")","v":0},{"$f":"COUNTIF(may!$F11:$AJ11,\"l\")","v":0},2,{"$f":"IF(AN11>AO11,AN11-AO11,0)","v":0},30,{"$f":"IF(AL11=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL11)","v":0},16000,{"$f":"AS11*5%","v":800},{"$f":"AS11/AQ11","v":{"v":533.3333333333334,"d":"533"}},{"$f":"IF(AS11>20000,3000,2000)","v":2000},{"$f":"AU11*AR11","v":0},{"$f":"IF(AL11=0,0,AW11+AV11-AT11)","v":0}]
[null,"P003","Name 3","2019-01-03","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F12:$AJ12,\"p\")","v":0},{"$f":"COUNTIF(may!$F12:$AJ12,\"a\")","v":0},{"$f":"COUNTIF(may!$F12:$AJ12,\"l\")","v":0},2,0,30,0,17000,850,{"v":566.6666666666666,"d":"567"},2000,0,0]
[null,"P004","Name 4","2019-01-04","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F13:$AJ13,\"p\")","v":0},{"$f":"COUNTIF(may!$F13:$AJ13,\"a\")","v":0},{"$f":"COUNTIF(may!$F13:$AJ13,\"l\")","v":0},2,0,30,0,18000,900,600,2000,0,0]
[null,"P005","Name 5","2019-01-05","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F14:$AJ14,\"p\")","v":0},{"$f":"COUNTIF(may!$F14:$AJ14,\"a\")","v":0},{"$f":"COUNTIF(may!$F14:$AJ14,\"l\")","v":0},2,0,30,0,19000,950,{"v":633.3333333333334,"d":"633"},2000,0,0]
[null,"P006","Name 6","2019-01-06","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F15:$AJ15,\"p\")","v":0},{"$f":"COUNTIF(may!$F15:$AJ15,\"a\")","v":0},{"$f":"COUNTIF(may!$F15:$AJ15,\"l\")","v":0},2,0,30,0,20000,1000,{"v":666.6666666666666,"d":"667"},2000,0,0]
[null,"P007","Name 7","2019-01-07","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F16:$AJ16,\"p\")","v":0},{"$f":"COUNTIF(may!$F16:$AJ16,\"a\")","v":0},{"$f":"COUNTIF(may!$F16:$AJ16,\"l\")","v":0},2,0,30,0,21000,1050,700,3000,0,0]
[null,"P008","Name 8","2019-01-08","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F17:$AJ17,\"p\")","v":0},{"$f":"COUNTIF(may!$F17:$AJ17,\"a\")","v":0},{"$f":"COUNTIF(may!$F17:$AJ17,\"l\")","v":0},2,0,30,0,22000,1100,{"v":733.3333333333334,"d":"733"},3000,0,0]
[null,"P009","Name 9","2019-01-09","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F18:$AJ18,\"p\")","v":0},{"$f":"COUNTIF(may!$F18:$AJ18,\"a\")","v":0},{"$f":"COUNTIF(may!$F18:$AJ18,\"l\")","v":0},2,0,30,0,23000,1150,{"v":766.6666666666666,"d":"767"},3000,0,0]
[null,"P010","Name 10","2019-01-10","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F19:$AJ19,\"p\")","v":0},{"$f":"COUNTIF(may!$F19:$AJ19,\"a\")","v":0},{"$f":"COUNTIF(may!$F19:$AJ19,\"l\")","v":0},2,0,30,0,24000,1200,800,3000,0,0]
[null,"P011","Name 11","2019-01-11","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F20:$AJ20,\"p\")","v":0},{"$f":"COUNTIF(may!$F20:$AJ20,\"a\")","v":0},{"$f":"COUNTIF(may!$F20:$AJ20,\"l\")","v":0},2,0,30,0,25000,1250,{"v":833.3333333333334,"d":"833"},3000,0,0]
[null,"P012","Name 12","2019-01-12","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F21:$AJ21,\"p\")","v":0},{"$f":"COUNTIF(may!$F21:$AJ21,\"a\")","v":0},{"$f":"COUNTIF(may!$F21:$AJ21,\"l\")","v":0},2,0,30,0,26000,1300,{"v":866.6666666666666,"d":"867"},3000,0,0]
[null,"P013","Name 13","2019-01-13","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F22:$AJ22,\"p\")","v":0},{"$f":"COUNTIF(may!$F22:$AJ22,\"a\")","v":0},{"$f":"COUNTIF(may!$F22:$AJ22,\"l\")","v":0},2,0,30,0,27000,1350,900,3000,0,0]
[null,"P014","Name 14","2019-01-14","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F23:$AJ23,\"p\")","v":0},{"$f":"COUNTIF(may!$F23:$AJ23,\"a\")","v":0},{"$f":"COUNTIF(may!$F23:$AJ23,\"l\")","v":0},2,0,30,0,28000,1400,{"v":933.3333333333334,"d":"933"},3000,0,0]
[null,"P015","Name 15","2019-01-15","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F24:$AJ24,\"p\")","v":0},{"$f":"COUNTIF(may!$F24:$AJ24,\"a\")","v":0},{"$f":"COUNTIF(may!$F24:$AJ24,\"l\")","v":0},2,0,30,0,29000,1450,{"v":966.6666666666666,"d":"967"},3000,0,0]

{"sheet":"july","index":7,"n_rows":24,"n_cols":50,"rows_kept":24,"merged":[[1,2,3,35],[1,37,3,49],[5,1,5,4],[5,5,5,6],[5,10,5,14],[5,16,5,21],[7,3,8,3],[7,37,8,37],[7,38,8,38],[7,39,8,39],[7,40,8,40],[7,41,8,41],[7,42,8,42],[7,43,8,43],[7,44,8,44],[7,45,8,45],[7,46,8,46],[7,47,8,47],[7,48,8,48],[7,49,8,49]]}
[]
[null,null,"Deepak EduWorld Pvt Ltd",{"$nulls":34},"Salary Calculatrion"]
[]
[]
[]
[null,"Attandance Sheet For Month",{"$nulls":3},{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,255)","v":"july"},{"$nulls":4},{"$f":"DATEVALUE(\"1\"&F6)","v":"2019-07-01"},{"$nulls":4},"To ",{"$f":"EOMONTH(K6,0)","v":"2019-07-31"}]
[]
[null,"Emp Id","Name","Date Of \nJoining","Post",{"$f":"TEXT(F9,\"ddd\")","v":"Mon"},{"$f":"TEXT(G9,\"ddd\")","v":"Tue"},{"$f":"TEXT(H9,\"ddd\")","v":"Wed"},"Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed",null,"Presence","Absence","Leave\n Taken","Allowed \nLeave","Leave\n Charges","Total Days\nof month","Total Payable\nDays","Basic \nSalary","PF 5%","Per Day\nAmount","HRA","Total\nAmount","In Hand \nSalary"]
[{"$nulls":5},{"$f":"K6","v":"2019-07-01"},{"$f":"IF(F9<$Q$6,F9+1,\"\")","v":"2019-07-02"},"2019-07-03","2019-07-04","2019-07-05","2019-07-06","2019-07-07","2019-07-08","2019-07-09","2019-07-10","2019-07-11","2019-07-12","2019-07-13","2019-07-14","2019-07-15","2019-07-16","2019-07-17","2019-07-18","2019-07-19","2019-07-20","2019-07-21","2019-07-22","2019-07-23","2019-07-24","2019-07-25","2019-07-26","2019-07-27","2019-07-28","2019-07-29","2019-07-30","2019-07-31"]
[null,"P001","Name 1","2019-01-01","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F10:$AJ10,\"p\")","v":0},{"$f":"COUNTIF(may!$F10:$AJ10,\"a\")","v":0},{"$f":"COUNTIF(may!$F10:$AJ10,\"l\")","v":0},2,{"$f":"IF(AN10>AO10,AN10-AO10,0)","v":0},{"$f":"DAY($Q$6)","v":31},{"$f":"IF(AL10=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL10)","v":0},15000,{"$f":"AS10*5%","v":750},{"$f":"AS10/AQ10","v":{"v":483.8709677419355,"d":"484"}},{"$f":"IF(AS10>20000,3000,2000)","v":2000},{"$f":"AU10*AR10","v":0},{"$f":"IF(AL10=0,0,AW10+AV10-AT10)","v":0}]
[null,"P002","Name 2","2019-01-02","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F11:$AJ11,\"p\")","v":0},{"$f":"COUNTIF(may!$F11:$AJ11,\"a\")","v":0},{"$f":"COUNTIF(may!$F11:$AJ11,\"l\")","v":0},2,{"$f":"IF(AN11>AO11,AN11-AO11,0)","v":0},31,{"$f":"IF(AL11=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL11)","v":0},16000,{"$f":"AS11*5%","v":800},{"$f":"AS11/AQ11","v":{"v":516.1290322580645,"d":"516"}},{"$f":"IF(AS11>20000,3000,2000)","v":2000},{"$f":"AU11*AR11","v":0},{"$f":"IF(AL11=0,0,AW11+AV11-AT11)","v":0}]
[null,"P003","Name 3","2019-01-03","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F12:$AJ12,\"p\")","v":0},{"$f":"COUNTIF(may!$F12:$AJ12,\"a\")","v":0},{"$f":"COUNTIF(may!$F12:$AJ12,\"l\")","v":0},2,0,31,0,17000,850,{"v":548.3870967741935,"d":"548"},2000,0,0]
[null,"P004","Name 4","2019-01-04","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F13:$AJ13,\"p\")","v":0},{"$f":"COUNTIF(may!$F13:$AJ13,\"a\")","v":0},{"$f":"COUNTIF(may!$F13:$AJ13,\"l\")","v":0},2,0,31,0,18000,900,{"v":580.6451612903226,"d":"581"},2000,0,0]
[null,"P005","Name 5","2019-01-05","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F14:$AJ14,\"p\")","v":0},{"$f":"COUNTIF(may!$F14:$AJ14,\"a\")","v":0},{"$f":"COUNTIF(may!$F14:$AJ14,\"l\")","v":0},2,0,31,0,19000,950,{"v":612.9032258064516,"d":"613"},2000,0,0]
[null,"P006","Name 6","2019-01-06","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F15:$AJ15,\"p\")","v":0},{"$f":"COUNTIF(may!$F15:$AJ15,\"a\")","v":0},{"$f":"COUNTIF(may!$F15:$AJ15,\"l\")","v":0},2,0,31,0,20000,1000,{"v":645.1612903225806,"d":"645"},2000,0,0]
[null,"P007","Name 7","2019-01-07","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F16:$AJ16,\"p\")","v":0},{"$f":"COUNTIF(may!$F16:$AJ16,\"a\")","v":0},{"$f":"COUNTIF(may!$F16:$AJ16,\"l\")","v":0},2,0,31,0,21000,1050,{"v":677.4193548387096,"d":"677"},3000,0,0]
[null,"P008","Name 8","2019-01-08","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F17:$AJ17,\"p\")","v":0},{"$f":"COUNTIF(may!$F17:$AJ17,\"a\")","v":0},{"$f":"COUNTIF(may!$F17:$AJ17,\"l\")","v":0},2,0,31,0,22000,1100,{"v":709.6774193548387,"d":"710"},3000,0,0]
[null,"P009","Name 9","2019-01-09","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F18:$AJ18,\"p\")","v":0},{"$f":"COUNTIF(may!$F18:$AJ18,\"a\")","v":0},{"$f":"COUNTIF(may!$F18:$AJ18,\"l\")","v":0},2,0,31,0,23000,1150,{"v":741.9354838709677,"d":"742"},3000,0,0]
[null,"P010","Name 10","2019-01-10","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F19:$AJ19,\"p\")","v":0},{"$f":"COUNTIF(may!$F19:$AJ19,\"a\")","v":0},{"$f":"COUNTIF(may!$F19:$AJ19,\"l\")","v":0},2,0,31,0,24000,1200,{"v":774.1935483870968,"d":"774"},3000,0,0]
[null,"P011","Name 11","2019-01-11","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F20:$AJ20,\"p\")","v":0},{"$f":"COUNTIF(may!$F20:$AJ20,\"a\")","v":0},{"$f":"COUNTIF(may!$F20:$AJ20,\"l\")","v":0},2,0,31,0,25000,1250,{"v":806.4516129032259,"d":"806"},3000,0,0]
[null,"P012","Name 12","2019-01-12","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F21:$AJ21,\"p\")","v":0},{"$f":"COUNTIF(may!$F21:$AJ21,\"a\")","v":0},{"$f":"COUNTIF(may!$F21:$AJ21,\"l\")","v":0},2,0,31,0,26000,1300,{"v":838.7096774193549,"d":"839"},3000,0,0]
[null,"P013","Name 13","2019-01-13","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F22:$AJ22,\"p\")","v":0},{"$f":"COUNTIF(may!$F22:$AJ22,\"a\")","v":0},{"$f":"COUNTIF(may!$F22:$AJ22,\"l\")","v":0},2,0,31,0,27000,1350,{"v":870.9677419354839,"d":"871"},3000,0,0]
[null,"P014","Name 14","2019-01-14","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F23:$AJ23,\"p\")","v":0},{"$f":"COUNTIF(may!$F23:$AJ23,\"a\")","v":0},{"$f":"COUNTIF(may!$F23:$AJ23,\"l\")","v":0},2,0,31,0,28000,1400,{"v":903.2258064516129,"d":"903"},3000,0,0]
[null,"P015","Name 15","2019-01-15","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F24:$AJ24,\"p\")","v":0},{"$f":"COUNTIF(may!$F24:$AJ24,\"a\")","v":0},{"$f":"COUNTIF(may!$F24:$AJ24,\"l\")","v":0},2,0,31,0,29000,1450,{"v":935.483870967742,"d":"935"},3000,0,0]

{"sheet":"aug","index":8,"n_rows":24,"n_cols":50,"rows_kept":24,"merged":[[1,2,3,35],[1,37,3,49],[5,1,5,4],[5,5,5,6],[5,10,5,14],[5,16,5,21],[7,3,8,3],[7,37,8,37],[7,38,8,38],[7,39,8,39],[7,40,8,40],[7,41,8,41],[7,42,8,42],[7,43,8,43],[7,44,8,44],[7,45,8,45],[7,46,8,46],[7,47,8,47],[7,48,8,48],[7,49,8,49]]}
[]
[null,null,"Deepak EduWorld Pvt Ltd",{"$nulls":34},"Salary Calculatrion"]
[]
[]
[]
[null,"Attandance Sheet For Month",{"$nulls":3},{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,255)","v":"aug"},{"$nulls":4},{"$f":"DATEVALUE(\"1\"&F6)","v":"2019-08-01"},{"$nulls":4},"To ",{"$f":"EOMONTH(K6,0)","v":"2019-08-31"}]
[]
[null,"Emp Id","Name","Date Of \nJoining","Post",{"$f":"TEXT(F9,\"ddd\")","v":"Thu"},{"$f":"TEXT(G9,\"ddd\")","v":"Fri"},{"$f":"TEXT(H9,\"ddd\")","v":"Sat"},"Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat",null,"Presence","Absence","Leave\n Taken","Allowed \nLeave","Leave\n Charges","Total Days\nof month","Total Payable\nDays","Basic \nSalary","PF 5%","Per Day\nAmount","HRA","Total\nAmount","In Hand \nSalary"]
[{"$nulls":5},{"$f":"K6","v":"2019-08-01"},{"$f":"IF(F9<$Q$6,F9+1,\"\")","v":"2019-08-02"},"2019-08-03","2019-08-04","2019-08-05","2019-08-06","2019-08-07","2019-08-08","2019-08-09","2019-08-10","2019-08-11","2019-08-12","2019-08-13","2019-08-14","2019-08-15","2019-08-16","2019-08-17","2019-08-18","2019-08-19","2019-08-20","2019-08-21","2019-08-22","2019-08-23","2019-08-24","2019-08-25","2019-08-26","2019-08-27","2019-08-28","2019-08-29","2019-08-30","2019-08-31"]
[null,"P001","Name 1","2019-01-01","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F10:$AJ10,\"p\")","v":0},{"$f":"COUNTIF(may!$F10:$AJ10,\"a\")","v":0},{"$f":"COUNTIF(may!$F10:$AJ10,\"l\")","v":0},2,{"$f":"IF(AN10>AO10,AN10-AO10,0)","v":0},{"$f":"DAY($Q$6)","v":31},{"$f":"IF(AL10=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL10)","v":0},15000,{"$f":"AS10*5%","v":750},{"$f":"AS10/AQ10","v":{"v":483.8709677419355,"d":"484"}},{"$f":"IF(AS10>20000,3000,2000)","v":2000},{"$f":"AU10*AR10","v":0},{"$f":"IF(AL10=0,0,AW10+AV10-AT10)","v":0}]
[null,"P002","Name 2","2019-01-02","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F11:$AJ11,\"p\")","v":0},{"$f":"COUNTIF(may!$F11:$AJ11,\"a\")","v":0},{"$f":"COUNTIF(may!$F11:$AJ11,\"l\")","v":0},2,{"$f":"IF(AN11>AO11,AN11-AO11,0)","v":0},31,{"$f":"IF(AL11=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL11)","v":0},16000,{"$f":"AS11*5%","v":800},{"$f":"AS11/AQ11","v":{"v":516.1290322580645,"d":"516"}},{"$f":"IF(AS11>20000,3000,2000)","v":2000},{"$f":"AU11*AR11","v":0},{"$f":"IF(AL11=0,0,AW11+AV11-AT11)","v":0}]
[null,"P003","Name 3","2019-01-03","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F12:$AJ12,\"p\")","v":0},{"$f":"COUNTIF(may!$F12:$AJ12,\"a\")","v":0},{"$f":"COUNTIF(may!$F12:$AJ12,\"l\")","v":0},2,0,31,0,17000,850,{"v":548.3870967741935,"d":"548"},2000,0,0]
[null,"P004","Name 4","2019-01-04","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F13:$AJ13,\"p\")","v":0},{"$f":"COUNTIF(may!$F13:$AJ13,\"a\")","v":0},{"$f":"COUNTIF(may!$F13:$AJ13,\"l\")","v":0},2,0,31,0,18000,900,{"v":580.6451612903226,"d":"581"},2000,0,0]
[null,"P005","Name 5","2019-01-05","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F14:$AJ14,\"p\")","v":0},{"$f":"COUNTIF(may!$F14:$AJ14,\"a\")","v":0},{"$f":"COUNTIF(may!$F14:$AJ14,\"l\")","v":0},2,0,31,0,19000,950,{"v":612.9032258064516,"d":"613"},2000,0,0]
[null,"P006","Name 6","2019-01-06","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F15:$AJ15,\"p\")","v":0},{"$f":"COUNTIF(may!$F15:$AJ15,\"a\")","v":0},{"$f":"COUNTIF(may!$F15:$AJ15,\"l\")","v":0},2,0,31,0,20000,1000,{"v":645.1612903225806,"d":"645"},2000,0,0]
[null,"P007","Name 7","2019-01-07","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F16:$AJ16,\"p\")","v":0},{"$f":"COUNTIF(may!$F16:$AJ16,\"a\")","v":0},{"$f":"COUNTIF(may!$F16:$AJ16,\"l\")","v":0},2,0,31,0,21000,1050,{"v":677.4193548387096,"d":"677"},3000,0,0]
[null,"P008","Name 8","2019-01-08","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F17:$AJ17,\"p\")","v":0},{"$f":"COUNTIF(may!$F17:$AJ17,\"a\")","v":0},{"$f":"COUNTIF(may!$F17:$AJ17,\"l\")","v":0},2,0,31,0,22000,1100,{"v":709.6774193548387,"d":"710"},3000,0,0]
[null,"P009","Name 9","2019-01-09","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F18:$AJ18,\"p\")","v":0},{"$f":"COUNTIF(may!$F18:$AJ18,\"a\")","v":0},{"$f":"COUNTIF(may!$F18:$AJ18,\"l\")","v":0},2,0,31,0,23000,1150,{"v":741.9354838709677,"d":"742"},3000,0,0]
[null,"P010","Name 10","2019-01-10","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F19:$AJ19,\"p\")","v":0},{"$f":"COUNTIF(may!$F19:$AJ19,\"a\")","v":0},{"$f":"COUNTIF(may!$F19:$AJ19,\"l\")","v":0},2,0,31,0,24000,1200,{"v":774.1935483870968,"d":"774"},3000,0,0]
[null,"P011","Name 11","2019-01-11","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F20:$AJ20,\"p\")","v":0},{"$f":"COUNTIF(may!$F20:$AJ20,\"a\")","v":0},{"$f":"COUNTIF(may!$F20:$AJ20,\"l\")","v":0},2,0,31,0,25000,1250,{"v":806.4516129032259,"d":"806"},3000,0,0]
[null,"P012","Name 12","2019-01-12","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F21:$AJ21,\"p\")","v":0},{"$f":"COUNTIF(may!$F21:$AJ21,\"a\")","v":0},{"$f":"COUNTIF(may!$F21:$AJ21,\"l\")","v":0},2,0,31,0,26000,1300,{"v":838.7096774193549,"d":"839"},3000,0,0]
[null,"P013","Name 13","2019-01-13","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F22:$AJ22,\"p\")","v":0},{"$f":"COUNTIF(may!$F22:$AJ22,\"a\")","v":0},{"$f":"COUNTIF(may!$F22:$AJ22,\"l\")","v":0},2,0,31,0,27000,1350,{"v":870.9677419354839,"d":"871"},3000,0,0]
[null,"P014","Name 14","2019-01-14","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F23:$AJ23,\"p\")","v":0},{"$f":"COUNTIF(may!$F23:$AJ23,\"a\")","v":0},{"$f":"COUNTIF(may!$F23:$AJ23,\"l\")","v":0},2,0,31,0,28000,1400,{"v":903.2258064516129,"d":"903"},3000,0,0]
[null,"P015","Name 15","2019-01-15","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F24:$AJ24,\"p\")","v":0},{"$f":"COUNTIF(may!$F24:$AJ24,\"a\")","v":0},{"$f":"COUNTIF(may!$F24:$AJ24,\"l\")","v":0},2,0,31,0,29000,1450,{"v":935.483870967742,"d":"935"},3000,0,0]

{"sheet":"sep","index":9,"n_rows":24,"n_cols":50,"rows_kept":24,"merged":[[1,2,3,35],[1,37,3,49],[5,1,5,4],[5,5,5,6],[5,10,5,14],[5,16,5,21],[7,3,8,3],[7,37,8,37],[7,38,8,38],[7,39,8,39],[7,40,8,40],[7,41,8,41],[7,42,8,42],[7,43,8,43],[7,44,8,44],[7,45,8,45],[7,46,8,46],[7,47,8,47],[7,48,8,48],[7,49,8,49]]}
[]
[null,null,"Deepak EduWorld Pvt Ltd",{"$nulls":34},"Salary Calculatrion"]
[]
[]
[]
[null,"Attandance Sheet For Month",{"$nulls":3},{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,255)","v":"sep"},{"$nulls":4},{"$f":"DATEVALUE(\"1\"&F6)","v":"2019-09-01"},{"$nulls":4},"To ",{"$f":"EOMONTH(K6,0)","v":"2019-09-30"}]
[]
[null,"Emp Id","Name","Date Of \nJoining","Post",{"$f":"TEXT(F9,\"ddd\")","v":"Sun"},{"$f":"TEXT(G9,\"ddd\")","v":"Mon"},{"$f":"TEXT(H9,\"ddd\")","v":"Tue"},"Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","",null,"Presence","Absence","Leave\n Taken","Allowed \nLeave","Leave\n Charges","Total Days\nof month","Total Payable\nDays","Basic \nSalary","PF 5%","Per Day\nAmount","HRA","Total\nAmount","In Hand \nSalary"]
[{"$nulls":5},{"$f":"K6","v":"2019-09-01"},{"$f":"IF(F9<$Q$6,F9+1,\"\")","v":"2019-09-02"},"2019-09-03","2019-09-04","2019-09-05","2019-09-06","2019-09-07","2019-09-08","2019-09-09","2019-09-10","2019-09-11","2019-09-12","2019-09-13","2019-09-14","2019-09-15","2019-09-16","2019-09-17","2019-09-18","2019-09-19","2019-09-20","2019-09-21","2019-09-22","2019-09-23","2019-09-24","2019-09-25","2019-09-26","2019-09-27","2019-09-28","2019-09-29","2019-09-30",""]
[null,"P001","Name 1","2019-01-01","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F10:$AJ10,\"p\")","v":0},{"$f":"COUNTIF(may!$F10:$AJ10,\"a\")","v":0},{"$f":"COUNTIF(may!$F10:$AJ10,\"l\")","v":0},2,{"$f":"IF(AN10>AO10,AN10-AO10,0)","v":0},{"$f":"DAY($Q$6)","v":30},{"$f":"IF(AL10=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL10)","v":0},15000,{"$f":"AS10*5%","v":750},{"$f":"AS10/AQ10","v":500},{"$f":"IF(AS10>20000,3000,2000)","v":2000},{"$f":"AU10*AR10","v":0},{"$f":"IF(AL10=0,0,AW10+AV10-AT10)","v":0}]
[null,"P002","Name 2","2019-01-02","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F11:$AJ11,\"p\")","v":0},{"$f":"COUNTIF(may!$F11:$AJ11,\"a\")","v":0},{"$f":"COUNTIF(may!$F11:$AJ11,\"l\")","v":0},2,{"$f":"IF(AN11>AO11,AN11-AO11,0)","v":0},30,{"$f":"IF(AL11=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL11)","v":0},16000,{"$f":"AS11*5%","v":800},{"$f":"AS11/AQ11","v":{"v":533.3333333333334,"d":"533"}},{"$f":"IF(AS11>20000,3000,2000)","v":2000},{"$f":"AU11*AR11","v":0},{"$f":"IF(AL11=0,0,AW11+AV11-AT11)","v":0}]
[null,"P003","Name 3","2019-01-03","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F12:$AJ12,\"p\")","v":0},{"$f":"COUNTIF(may!$F12:$AJ12,\"a\")","v":0},{"$f":"COUNTIF(may!$F12:$AJ12,\"l\")","v":0},2,0,30,0,17000,850,{"v":566.6666666666666,"d":"567"},2000,0,0]
[null,"P004","Name 4","2019-01-04","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F13:$AJ13,\"p\")","v":0},{"$f":"COUNTIF(may!$F13:$AJ13,\"a\")","v":0},{"$f":"COUNTIF(may!$F13:$AJ13,\"l\")","v":0},2,0,30,0,18000,900,600,2000,0,0]
[null,"P005","Name 5","2019-01-05","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F14:$AJ14,\"p\")","v":0},{"$f":"COUNTIF(may!$F14:$AJ14,\"a\")","v":0},{"$f":"COUNTIF(may!$F14:$AJ14,\"l\")","v":0},2,0,30,0,19000,950,{"v":633.3333333333334,"d":"633"},2000,0,0]
[null,"P006","Name 6","2019-01-06","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F15:$AJ15,\"p\")","v":0},{"$f":"COUNTIF(may!$F15:$AJ15,\"a\")","v":0},{"$f":"COUNTIF(may!$F15:$AJ15,\"l\")","v":0},2,0,30,0,20000,1000,{"v":666.6666666666666,"d":"667"},2000,0,0]
[null,"P007","Name 7","2019-01-07","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F16:$AJ16,\"p\")","v":0},{"$f":"COUNTIF(may!$F16:$AJ16,\"a\")","v":0},{"$f":"COUNTIF(may!$F16:$AJ16,\"l\")","v":0},2,0,30,0,21000,1050,700,3000,0,0]
[null,"P008","Name 8","2019-01-08","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F17:$AJ17,\"p\")","v":0},{"$f":"COUNTIF(may!$F17:$AJ17,\"a\")","v":0},{"$f":"COUNTIF(may!$F17:$AJ17,\"l\")","v":0},2,0,30,0,22000,1100,{"v":733.3333333333334,"d":"733"},3000,0,0]
[null,"P009","Name 9","2019-01-09","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F18:$AJ18,\"p\")","v":0},{"$f":"COUNTIF(may!$F18:$AJ18,\"a\")","v":0},{"$f":"COUNTIF(may!$F18:$AJ18,\"l\")","v":0},2,0,30,0,23000,1150,{"v":766.6666666666666,"d":"767"},3000,0,0]
[null,"P010","Name 10","2019-01-10","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F19:$AJ19,\"p\")","v":0},{"$f":"COUNTIF(may!$F19:$AJ19,\"a\")","v":0},{"$f":"COUNTIF(may!$F19:$AJ19,\"l\")","v":0},2,0,30,0,24000,1200,800,3000,0,0]
[null,"P011","Name 11","2019-01-11","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F20:$AJ20,\"p\")","v":0},{"$f":"COUNTIF(may!$F20:$AJ20,\"a\")","v":0},{"$f":"COUNTIF(may!$F20:$AJ20,\"l\")","v":0},2,0,30,0,25000,1250,{"v":833.3333333333334,"d":"833"},3000,0,0]
[null,"P012","Name 12","2019-01-12","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F21:$AJ21,\"p\")","v":0},{"$f":"COUNTIF(may!$F21:$AJ21,\"a\")","v":0},{"$f":"COUNTIF(may!$F21:$AJ21,\"l\")","v":0},2,0,30,0,26000,1300,{"v":866.6666666666666,"d":"867"},3000,0,0]
[null,"P013","Name 13","2019-01-13","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F22:$AJ22,\"p\")","v":0},{"$f":"COUNTIF(may!$F22:$AJ22,\"a\")","v":0},{"$f":"COUNTIF(may!$F22:$AJ22,\"l\")","v":0},2,0,30,0,27000,1350,900,3000,0,0]
[null,"P014","Name 14","2019-01-14","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F23:$AJ23,\"p\")","v":0},{"$f":"COUNTIF(may!$F23:$AJ23,\"a\")","v":0},{"$f":"COUNTIF(may!$F23:$AJ23,\"l\")","v":0},2,0,30,0,28000,1400,{"v":933.3333333333334,"d":"933"},3000,0,0]
[null,"P015","Name 15","2019-01-15","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F24:$AJ24,\"p\")","v":0},{"$f":"COUNTIF(may!$F24:$AJ24,\"a\")","v":0},{"$f":"COUNTIF(may!$F24:$AJ24,\"l\")","v":0},2,0,30,0,29000,1450,{"v":966.6666666666666,"d":"967"},3000,0,0]

{"sheet":"oct","index":10,"n_rows":24,"n_cols":50,"rows_kept":24,"merged":[[1,2,3,35],[1,37,3,49],[5,1,5,4],[5,5,5,6],[5,10,5,14],[5,16,5,21],[7,3,8,3],[7,37,8,37],[7,38,8,38],[7,39,8,39],[7,40,8,40],[7,41,8,41],[7,42,8,42],[7,43,8,43],[7,44,8,44],[7,45,8,45],[7,46,8,46],[7,47,8,47],[7,48,8,48],[7,49,8,49]]}
[]
[null,null,"Deepak EduWorld Pvt Ltd",{"$nulls":34},"Salary Calculatrion"]
[]
[]
[]
[null,"Attandance Sheet For Month",{"$nulls":3},{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,255)","v":"oct"},{"$nulls":4},{"$f":"DATEVALUE(\"1\"&F6)","v":"2019-10-01"},{"$nulls":4},"To ",{"$f":"EOMONTH(K6,0)","v":"2019-10-31"}]
[]
[null,"Emp Id","Name","Date Of \nJoining","Post",{"$f":"TEXT(F9,\"ddd\")","v":"Tue"},{"$f":"TEXT(G9,\"ddd\")","v":"Wed"},{"$f":"TEXT(H9,\"ddd\")","v":"Thu"},"Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu",null,"Presence","Absence","Leave\n Taken","Allowed \nLeave","Leave\n Charges","Total Days\nof month","Total Payable\nDays","Basic \nSalary","PF 5%","Per Day\nAmount","HRA","Total\nAmount","In Hand \nSalary"]
[{"$nulls":5},{"$f":"K6","v":"2019-10-01"},{"$f":"IF(F9<$Q$6,F9+1,\"\")","v":"2019-10-02"},"2019-10-03","2019-10-04","2019-10-05","2019-10-06","2019-10-07","2019-10-08","2019-10-09","2019-10-10","2019-10-11","2019-10-12","2019-10-13","2019-10-14","2019-10-15","2019-10-16","2019-10-17","2019-10-18","2019-10-19","2019-10-20","2019-10-21","2019-10-22","2019-10-23","2019-10-24","2019-10-25","2019-10-26","2019-10-27","2019-10-28","2019-10-29","2019-10-30","2019-10-31"]
[null,"P001","Name 1","2019-01-01","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F10:$AJ10,\"p\")","v":0},{"$f":"COUNTIF(may!$F10:$AJ10,\"a\")","v":0},{"$f":"COUNTIF(may!$F10:$AJ10,\"l\")","v":0},2,{"$f":"IF(AN10>AO10,AN10-AO10,0)","v":0},{"$f":"DAY($Q$6)","v":31},{"$f":"IF(AL10=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL10)","v":0},15000,{"$f":"AS10*5%","v":750},{"$f":"AS10/AQ10","v":{"v":483.8709677419355,"d":"484"}},{"$f":"IF(AS10>20000,3000,2000)","v":2000},{"$f":"AU10*AR10","v":0},{"$f":"IF(AL10=0,0,AW10+AV10-AT10)","v":0}]
[null,"P002","Name 2","2019-01-02","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F11:$AJ11,\"p\")","v":0},{"$f":"COUNTIF(may!$F11:$AJ11,\"a\")","v":0},{"$f":"COUNTIF(may!$F11:$AJ11,\"l\")","v":0},2,{"$f":"IF(AN11>AO11,AN11-AO11,0)","v":0},31,{"$f":"IF(AL11=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL11)","v":0},16000,{"$f":"AS11*5%","v":800},{"$f":"AS11/AQ11","v":{"v":516.1290322580645,"d":"516"}},{"$f":"IF(AS11>20000,3000,2000)","v":2000},{"$f":"AU11*AR11","v":0},{"$f":"IF(AL11=0,0,AW11+AV11-AT11)","v":0}]
[null,"P003","Name 3","2019-01-03","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F12:$AJ12,\"p\")","v":0},{"$f":"COUNTIF(may!$F12:$AJ12,\"a\")","v":0},{"$f":"COUNTIF(may!$F12:$AJ12,\"l\")","v":0},2,0,31,0,17000,850,{"v":548.3870967741935,"d":"548"},2000,0,0]
[null,"P004","Name 4","2019-01-04","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F13:$AJ13,\"p\")","v":0},{"$f":"COUNTIF(may!$F13:$AJ13,\"a\")","v":0},{"$f":"COUNTIF(may!$F13:$AJ13,\"l\")","v":0},2,0,31,0,18000,900,{"v":580.6451612903226,"d":"581"},2000,0,0]
[null,"P005","Name 5","2019-01-05","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F14:$AJ14,\"p\")","v":0},{"$f":"COUNTIF(may!$F14:$AJ14,\"a\")","v":0},{"$f":"COUNTIF(may!$F14:$AJ14,\"l\")","v":0},2,0,31,0,19000,950,{"v":612.9032258064516,"d":"613"},2000,0,0]
[null,"P006","Name 6","2019-01-06","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F15:$AJ15,\"p\")","v":0},{"$f":"COUNTIF(may!$F15:$AJ15,\"a\")","v":0},{"$f":"COUNTIF(may!$F15:$AJ15,\"l\")","v":0},2,0,31,0,20000,1000,{"v":645.1612903225806,"d":"645"},2000,0,0]
[null,"P007","Name 7","2019-01-07","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F16:$AJ16,\"p\")","v":0},{"$f":"COUNTIF(may!$F16:$AJ16,\"a\")","v":0},{"$f":"COUNTIF(may!$F16:$AJ16,\"l\")","v":0},2,0,31,0,21000,1050,{"v":677.4193548387096,"d":"677"},3000,0,0]
[null,"P008","Name 8","2019-01-08","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F17:$AJ17,\"p\")","v":0},{"$f":"COUNTIF(may!$F17:$AJ17,\"a\")","v":0},{"$f":"COUNTIF(may!$F17:$AJ17,\"l\")","v":0},2,0,31,0,22000,1100,{"v":709.6774193548387,"d":"710"},3000,0,0]
[null,"P009","Name 9","2019-01-09","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F18:$AJ18,\"p\")","v":0},{"$f":"COUNTIF(may!$F18:$AJ18,\"a\")","v":0},{"$f":"COUNTIF(may!$F18:$AJ18,\"l\")","v":0},2,0,31,0,23000,1150,{"v":741.9354838709677,"d":"742"},3000,0,0]
[null,"P010","Name 10","2019-01-10","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F19:$AJ19,\"p\")","v":0},{"$f":"COUNTIF(may!$F19:$AJ19,\"a\")","v":0},{"$f":"COUNTIF(may!$F19:$AJ19,\"l\")","v":0},2,0,31,0,24000,1200,{"v":774.1935483870968,"d":"774"},3000,0,0]
[null,"P011","Name 11","2019-01-11","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F20:$AJ20,\"p\")","v":0},{"$f":"COUNTIF(may!$F20:$AJ20,\"a\")","v":0},{"$f":"COUNTIF(may!$F20:$AJ20,\"l\")","v":0},2,0,31,0,25000,1250,{"v":806.4516129032259,"d":"806"},3000,0,0]
[null,"P012","Name 12","2019-01-12","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F21:$AJ21,\"p\")","v":0},{"$f":"COUNTIF(may!$F21:$AJ21,\"a\")","v":0},{"$f":"COUNTIF(may!$F21:$AJ21,\"l\")","v":0},2,0,31,0,26000,1300,{"v":838.7096774193549,"d":"839"},3000,0,0]
[null,"P013","Name 13","2019-01-13","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F22:$AJ22,\"p\")","v":0},{"$f":"COUNTIF(may!$F22:$AJ22,\"a\")","v":0},{"$f":"COUNTIF(may!$F22:$AJ22,\"l\")","v":0},2,0,31,0,27000,1350,{"v":870.9677419354839,"d":"871"},3000,0,0]
[null,"P014","Name 14","2019-01-14","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F23:$AJ23,\"p\")","v":0},{"$f":"COUNTIF(may!$F23:$AJ23,\"a\")","v":0},{"$f":"COUNTIF(may!$F23:$AJ23,\"l\")","v":0},2,0,31,0,28000,1400,{"v":903.2258064516129,"d":"903"},3000,0,0]
[null,"P015","Name 15","2019-01-15","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F24:$AJ24,\"p\")","v":0},{"$f":"COUNTIF(may!$F24:$AJ24,\"a\")","v":0},{"$f":"COUNTIF(may!$F24:$AJ24,\"l\")","v":0},2,0,31,0,29000,1450,{"v":935.483870967742,"d":"935"},3000,0,0]

{"sheet":"nov","index":11,"n_rows":24,"n_cols":50,"rows_kept":24,"merged":[[1,2,3,35],[1,37,3,49],[5,1,5,4],[5,5,5,6],[5,10,5,14],[5,16,5,21],[7,3,8,3],[7,37,8,37],[7,38,8,38],[7,39,8,39],[7,40,8,40],[7,41,8,41],[7,42,8,42],[7,43,8,43],[7,44,8,44],[7,45,8,45],[7,46,8,46],[7,47,8,47],[7,48,8,48],[7,49,8,49]]}
[]
[null,null,"Deepak EduWorld Pvt Ltd",{"$nulls":34},"Salary Calculatrion"]
[]
[]
[]
[null,"Attandance Sheet For Month",{"$nulls":3},{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,255)","v":"nov"},{"$nulls":4},{"$f":"DATEVALUE(\"1\"&F6)","v":"2019-11-01"},{"$nulls":4},"To ",{"$f":"EOMONTH(K6,0)","v":"2019-11-30"}]
[]
[null,"Emp Id","Name","Date Of \nJoining","Post",{"$f":"TEXT(F9,\"ddd\")","v":"Fri"},{"$f":"TEXT(G9,\"ddd\")","v":"Sat"},{"$f":"TEXT(H9,\"ddd\")","v":"Sun"},"Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","",null,"Presence","Absence","Leave\n Taken","Allowed \nLeave","Leave\n Charges","Total Days\nof month","Total Payable\nDays","Basic \nSalary","PF 5%","Per Day\nAmount","HRA","Total\nAmount","In Hand \nSalary"]
[{"$nulls":5},{"$f":"K6","v":"2019-11-01"},{"$f":"IF(F9<$Q$6,F9+1,\"\")","v":"2019-11-02"},"2019-11-03","2019-11-04","2019-11-05","2019-11-06","2019-11-07","2019-11-08","2019-11-09","2019-11-10","2019-11-11","2019-11-12","2019-11-13","2019-11-14","2019-11-15","2019-11-16","2019-11-17","2019-11-18","2019-11-19","2019-11-20","2019-11-21","2019-11-22","2019-11-23","2019-11-24","2019-11-25","2019-11-26","2019-11-27","2019-11-28","2019-11-29","2019-11-30",""]
[null,"P001","Name 1","2019-01-01","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F10:$AJ10,\"p\")","v":0},{"$f":"COUNTIF(may!$F10:$AJ10,\"a\")","v":0},{"$f":"COUNTIF(may!$F10:$AJ10,\"l\")","v":0},2,{"$f":"IF(AN10>AO10,AN10-AO10,0)","v":0},{"$f":"DAY($Q$6)","v":30},{"$f":"IF(AL10=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL10)","v":0},15000,{"$f":"AS10*5%","v":750},{"$f":"AS10/AQ10","v":500},{"$f":"IF(AS10>20000,3000,2000)","v":2000},{"$f":"AU10*AR10","v":0},{"$f":"IF(AL10=0,0,AW10+AV10-AT10)","v":0}]
[null,"P002","Name 2","2019-01-02","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F11:$AJ11,\"p\")","v":0},{"$f":"COUNTIF(may!$F11:$AJ11,\"a\")","v":0},{"$f":"COUNTIF(may!$F11:$AJ11,\"l\")","v":0},2,{"$f":"IF(AN11>AO11,AN11-AO11,0)","v":0},30,{"$f":"IF(AL11=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL11)","v":0},16000,{"$f":"AS11*5%","v":800},{"$f":"AS11/AQ11","v":{"v":533.3333333333334,"d":"533"}},{"$f":"IF(AS11>20000,3000,2000)","v":2000},{"$f":"AU11*AR11","v":0},{"$f":"IF(AL11=0,0,AW11+AV11-AT11)","v":0}]
[null,"P003","Name 3","2019-01-03","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F12:$AJ12,\"p\")","v":0},{"$f":"COUNTIF(may!$F12:$AJ12,\"a\")","v":0},{"$f":"COUNTIF(may!$F12:$AJ12,\"l\")","v":0},2,0,30,0,17000,850,{"v":566.6666666666666,"d":"567"},2000,0,0]
[null,"P004","Name 4","2019-01-04","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F13:$AJ13,\"p\")","v":0},{"$f":"COUNTIF(may!$F13:$AJ13,\"a\")","v":0},{"$f":"COUNTIF(may!$F13:$AJ13,\"l\")","v":0},2,0,30,0,18000,900,600,2000,0,0]
[null,"P005","Name 5","2019-01-05","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F14:$AJ14,\"p\")","v":0},{"$f":"COUNTIF(may!$F14:$AJ14,\"a\")","v":0},{"$f":"COUNTIF(may!$F14:$AJ14,\"l\")","v":0},2,0,30,0,19000,950,{"v":633.3333333333334,"d":"633"},2000,0,0]
[null,"P006","Name 6","2019-01-06","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F15:$AJ15,\"p\")","v":0},{"$f":"COUNTIF(may!$F15:$AJ15,\"a\")","v":0},{"$f":"COUNTIF(may!$F15:$AJ15,\"l\")","v":0},2,0,30,0,20000,1000,{"v":666.6666666666666,"d":"667"},2000,0,0]
[null,"P007","Name 7","2019-01-07","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F16:$AJ16,\"p\")","v":0},{"$f":"COUNTIF(may!$F16:$AJ16,\"a\")","v":0},{"$f":"COUNTIF(may!$F16:$AJ16,\"l\")","v":0},2,0,30,0,21000,1050,700,3000,0,0]
[null,"P008","Name 8","2019-01-08","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F17:$AJ17,\"p\")","v":0},{"$f":"COUNTIF(may!$F17:$AJ17,\"a\")","v":0},{"$f":"COUNTIF(may!$F17:$AJ17,\"l\")","v":0},2,0,30,0,22000,1100,{"v":733.3333333333334,"d":"733"},3000,0,0]
[null,"P009","Name 9","2019-01-09","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F18:$AJ18,\"p\")","v":0},{"$f":"COUNTIF(may!$F18:$AJ18,\"a\")","v":0},{"$f":"COUNTIF(may!$F18:$AJ18,\"l\")","v":0},2,0,30,0,23000,1150,{"v":766.6666666666666,"d":"767"},3000,0,0]
[null,"P010","Name 10","2019-01-10","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F19:$AJ19,\"p\")","v":0},{"$f":"COUNTIF(may!$F19:$AJ19,\"a\")","v":0},{"$f":"COUNTIF(may!$F19:$AJ19,\"l\")","v":0},2,0,30,0,24000,1200,800,3000,0,0]
[null,"P011","Name 11","2019-01-11","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F20:$AJ20,\"p\")","v":0},{"$f":"COUNTIF(may!$F20:$AJ20,\"a\")","v":0},{"$f":"COUNTIF(may!$F20:$AJ20,\"l\")","v":0},2,0,30,0,25000,1250,{"v":833.3333333333334,"d":"833"},3000,0,0]
[null,"P012","Name 12","2019-01-12","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F21:$AJ21,\"p\")","v":0},{"$f":"COUNTIF(may!$F21:$AJ21,\"a\")","v":0},{"$f":"COUNTIF(may!$F21:$AJ21,\"l\")","v":0},2,0,30,0,26000,1300,{"v":866.6666666666666,"d":"867"},3000,0,0]
[null,"P013","Name 13","2019-01-13","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F22:$AJ22,\"p\")","v":0},{"$f":"COUNTIF(may!$F22:$AJ22,\"a\")","v":0},{"$f":"COUNTIF(may!$F22:$AJ22,\"l\")","v":0},2,0,30,0,27000,1350,900,3000,0,0]
[null,"P014","Name 14","2019-01-14","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F23:$AJ23,\"p\")","v":0},{"$f":"COUNTIF(may!$F23:$AJ23,\"a\")","v":0},{"$f":"COUNTIF(may!$F23:$AJ23,\"l\")","v":0},2,0,30,0,28000,1400,{"v":933.3333333333334,"d":"933"},3000,0,0]
[null,"P015","Name 15","2019-01-15","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F24:$AJ24,\"p\")","v":0},{"$f":"COUNTIF(may!$F24:$AJ24,\"a\")","v":0},{"$f":"COUNTIF(may!$F24:$AJ24,\"l\")","v":0},2,0,30,0,29000,1450,{"v":966.6666666666666,"d":"967"},3000,0,0]

{"sheet":"dec","index":12,"n_rows":24,"n_cols":50,"rows_kept":24,"merged":[[1,2,3,35],[1,37,3,49],[5,1,5,4],[5,5,5,6],[5,10,5,14],[5,16,5,21],[7,3,8,3],[7,37,8,37],[7,38,8,38],[7,39,8,39],[7,40,8,40],[7,41,8,41],[7,42,8,42],[7,43,8,43],[7,44,8,44],[7,45,8,45],[7,46,8,46],[7,47,8,47],[7,48,8,48],[7,49,8,49]]}
[]
[null,null,"Deepak EduWorld Pvt Ltd",{"$nulls":34},"Salary Calculatrion"]
[]
[]
[]
[null,"Attandance Sheet For Month",{"$nulls":3},{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,255)","v":"dec"},{"$nulls":4},{"$f":"DATEVALUE(\"1\"&F6)","v":"2019-12-01"},{"$nulls":4},"To ",{"$f":"EOMONTH(K6,0)","v":"2019-12-31"}]
[]
[null,"Emp Id","Name","Date Of \nJoining","Post",{"$f":"TEXT(F9,\"ddd\")","v":"Sun"},{"$f":"TEXT(G9,\"ddd\")","v":"Mon"},{"$f":"TEXT(H9,\"ddd\")","v":"Tue"},"Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue","Wed","Thu","Fri","Sat","Sun","Mon","Tue",null,"Presence","Absence","Leave\n Taken","Allowed \nLeave","Leave\n Charges","Total Days\nof month","Total Payable\nDays","Basic \nSalary","PF 5%","Per Day\nAmount","HRA","Total\nAmount","In Hand \nSalary"]
[{"$nulls":5},{"$f":"K6","v":"2019-12-01"},{"$f":"IF(F9<$Q$6,F9+1,\"\")","v":"2019-12-02"},"2019-12-03","2019-12-04","2019-12-05","2019-12-06","2019-12-07","2019-12-08","2019-12-09","2019-12-10","2019-12-11","2019-12-12","2019-12-13","2019-12-14","2019-12-15","2019-12-16","2019-12-17","2019-12-18","2019-12-19","2019-12-20","2019-12-21","2019-12-22","2019-12-23","2019-12-24","2019-12-25","2019-12-26","2019-12-27","2019-12-28","2019-12-29","2019-12-30","2019-12-31"]
[null,"P001","Name 1","2019-01-01","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F10:$AJ10,\"p\")","v":0},{"$f":"COUNTIF(may!$F10:$AJ10,\"a\")","v":0},{"$f":"COUNTIF(may!$F10:$AJ10,\"l\")","v":0},2,{"$f":"IF(AN10>AO10,AN10-AO10,0)","v":0},{"$f":"DAY($Q$6)","v":31},{"$f":"IF(AL10=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL10)","v":0},15000,{"$f":"AS10*5%","v":750},{"$f":"AS10/AQ10","v":{"v":483.8709677419355,"d":"484"}},{"$f":"IF(AS10>20000,3000,2000)","v":2000},{"$f":"AU10*AR10","v":0},{"$f":"IF(AL10=0,0,AW10+AV10-AT10)","v":0}]
[null,"P002","Name 2","2019-01-02","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F11:$AJ11,\"p\")","v":0},{"$f":"COUNTIF(may!$F11:$AJ11,\"a\")","v":0},{"$f":"COUNTIF(may!$F11:$AJ11,\"l\")","v":0},2,{"$f":"IF(AN11>AO11,AN11-AO11,0)","v":0},31,{"$f":"IF(AL11=0,0,COUNTIF($F$8:$AJ$8,\"sun\")+AL11)","v":0},16000,{"$f":"AS11*5%","v":800},{"$f":"AS11/AQ11","v":{"v":516.1290322580645,"d":"516"}},{"$f":"IF(AS11>20000,3000,2000)","v":2000},{"$f":"AU11*AR11","v":0},{"$f":"IF(AL11=0,0,AW11+AV11-AT11)","v":0}]
[null,"P003","Name 3","2019-01-03","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F12:$AJ12,\"p\")","v":0},{"$f":"COUNTIF(may!$F12:$AJ12,\"a\")","v":0},{"$f":"COUNTIF(may!$F12:$AJ12,\"l\")","v":0},2,0,31,0,17000,850,{"v":548.3870967741935,"d":"548"},2000,0,0]
[null,"P004","Name 4","2019-01-04","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F13:$AJ13,\"p\")","v":0},{"$f":"COUNTIF(may!$F13:$AJ13,\"a\")","v":0},{"$f":"COUNTIF(may!$F13:$AJ13,\"l\")","v":0},2,0,31,0,18000,900,{"v":580.6451612903226,"d":"581"},2000,0,0]
[null,"P005","Name 5","2019-01-05","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F14:$AJ14,\"p\")","v":0},{"$f":"COUNTIF(may!$F14:$AJ14,\"a\")","v":0},{"$f":"COUNTIF(may!$F14:$AJ14,\"l\")","v":0},2,0,31,0,19000,950,{"v":612.9032258064516,"d":"613"},2000,0,0]
[null,"P006","Name 6","2019-01-06","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F15:$AJ15,\"p\")","v":0},{"$f":"COUNTIF(may!$F15:$AJ15,\"a\")","v":0},{"$f":"COUNTIF(may!$F15:$AJ15,\"l\")","v":0},2,0,31,0,20000,1000,{"v":645.1612903225806,"d":"645"},2000,0,0]
[null,"P007","Name 7","2019-01-07","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F16:$AJ16,\"p\")","v":0},{"$f":"COUNTIF(may!$F16:$AJ16,\"a\")","v":0},{"$f":"COUNTIF(may!$F16:$AJ16,\"l\")","v":0},2,0,31,0,21000,1050,{"v":677.4193548387096,"d":"677"},3000,0,0]
[null,"P008","Name 8","2019-01-08","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F17:$AJ17,\"p\")","v":0},{"$f":"COUNTIF(may!$F17:$AJ17,\"a\")","v":0},{"$f":"COUNTIF(may!$F17:$AJ17,\"l\")","v":0},2,0,31,0,22000,1100,{"v":709.6774193548387,"d":"710"},3000,0,0]
[null,"P009","Name 9","2019-01-09","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F18:$AJ18,\"p\")","v":0},{"$f":"COUNTIF(may!$F18:$AJ18,\"a\")","v":0},{"$f":"COUNTIF(may!$F18:$AJ18,\"l\")","v":0},2,0,31,0,23000,1150,{"v":741.9354838709677,"d":"742"},3000,0,0]
[null,"P010","Name 10","2019-01-10","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F19:$AJ19,\"p\")","v":0},{"$f":"COUNTIF(may!$F19:$AJ19,\"a\")","v":0},{"$f":"COUNTIF(may!$F19:$AJ19,\"l\")","v":0},2,0,31,0,24000,1200,{"v":774.1935483870968,"d":"774"},3000,0,0]
[null,"P011","Name 11","2019-01-11","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F20:$AJ20,\"p\")","v":0},{"$f":"COUNTIF(may!$F20:$AJ20,\"a\")","v":0},{"$f":"COUNTIF(may!$F20:$AJ20,\"l\")","v":0},2,0,31,0,25000,1250,{"v":806.4516129032259,"d":"806"},3000,0,0]
[null,"P012","Name 12","2019-01-12","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F21:$AJ21,\"p\")","v":0},{"$f":"COUNTIF(may!$F21:$AJ21,\"a\")","v":0},{"$f":"COUNTIF(may!$F21:$AJ21,\"l\")","v":0},2,0,31,0,26000,1300,{"v":838.7096774193549,"d":"839"},3000,0,0]
[null,"P013","Name 13","2019-01-13","Officer",{"$nulls":32},{"$f":"COUNTIF(may!$F22:$AJ22,\"p\")","v":0},{"$f":"COUNTIF(may!$F22:$AJ22,\"a\")","v":0},{"$f":"COUNTIF(may!$F22:$AJ22,\"l\")","v":0},2,0,31,0,27000,1350,{"v":870.9677419354839,"d":"871"},3000,0,0]
[null,"P014","Name 14","2019-01-14","Clark",{"$nulls":32},{"$f":"COUNTIF(may!$F23:$AJ23,\"p\")","v":0},{"$f":"COUNTIF(may!$F23:$AJ23,\"a\")","v":0},{"$f":"COUNTIF(may!$F23:$AJ23,\"l\")","v":0},2,0,31,0,28000,1400,{"v":903.2258064516129,"d":"903"},3000,0,0]
[null,"P015","Name 15","2019-01-15","Manager",{"$nulls":32},{"$f":"COUNTIF(may!$F24:$AJ24,\"p\")","v":0},{"$f":"COUNTIF(may!$F24:$AJ24,\"a\")","v":0},{"$f":"COUNTIF(may!$F24:$AJ24,\"l\")","v":0},2,0,31,0,29000,1450,{"v":935.483870967742,"d":"935"},3000,0,0]