{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Dashboard","Compensation Matrix","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":30,"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":"Dashboard","index":0,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,1],[14,0,14,1],[15,0,15,1]]}
["Salary Computation",null,null,null,{"$f":"IF((((C15-B3)*100)/B3)<50,\"\",\"Validate\")","v":""}]
["Particular","Details","Considering \nFactor","Remarks"]
["Current CTC",650000]
["Last appraisal<6 Months","Yes"]
["Offer in hand","Yes"]
["Offer",800000]
["Experience - sap",4]
["Education"]
["Criticality\nRare Technology"]
["Interview Rating",4]
["Grade","Junior"]
["Module","SD"]
["Certification"]
[]
["Computed Compensation",null,{"$f":"IF(AND(B4=\"Yes\",B5=\"Yes\"),(IF(C6<>\"\", B6+B6*(C6/100),(IF(B5=\"YES\",(B6+B6*0.1),(B3+B3*0.2))))),(IF(C6<>\"\", B6+B6*(C6/100),(IF(B5=\"YES\",(B6+B6*0.2),(B3+B3*0.3))))))","v":880000},{"$f":"IF(C6<>\"\", B6+B6*(C6/100),(IF(B5=\"YES\",(B6+B6*0.2),(B3+B3*0.3))))","v":960000}]
["Standard Compensation",null,{"$f":"INDEX('Compensation Matrix'!C3:AB12,MATCH(Dashboard!B7,'Compensation Matrix'!B3:B12,0),MATCH(Dashboard!B12,'Compensation Matrix'!C2:AB2,0))","v":768950}]
["Variation",null,{"$f":"C15-C16","v":111050},{"$f":"C17/C16%","v":14.441771246504974},{"$f":"IF(AND(B10>4,D17<20),\"Pass\",IF(AND(B10>3,D17<15),\"Pass\",IF(AND(B10>=3,D17<10),\"Pass\",\"Fail\")))","v":"Pass"}]
["Expected",null,600000,{"$f":"IF(C18>C15,\"Not Fulfilled\",\"Fulfilled\")","v":"Fulfilled"}]

{"sheet":"Compensation Matrix","index":1,"n_rows":12,"n_cols":28,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,0,11,0],[0,2,0,27]]}
[null,null,"Module"]
[null,"Column1","ABAP","Basis","BI","CA","CO","CS","EC","FI","HR","IM","IS","LIS","MM","CRM","PLCM","SEM","SRM","Netweaver","PM","PP","PS","QM","SCM","SD","SMB","TR"]
["Eperience",1,250000,300000,400000,400000,400000,400000,400000,400000,450000,450000,450000,350000,400000,450000,450000,450000,450000,300000,450000,400000,450000,400000,450000,350000,450000,450000]
[null,2,{"$f":"C3+(C3*30%)","v":325000},390000,520000,{"$f":"F3+(F3*30%)","v":520000},520000,{"$f":"H3+(H3*30%)","v":520000},{"$f":"I3+(I3*30%)","v":520000},{"$f":"J3+(J3*30%)","v":520000},585000,585000,{"$f":"M3+(M3*30%)","v":585000},{"$f":"N3+(N3*30%)","v":455000},{"$f":"O3+(O3*30%)","v":520000},585000,{"$f":"Q3+(Q3*30%)","v":585000},585000,585000,390000,{"$f":"U3+(U3*30%)","v":585000},520000,585000,520000,585000,{"$f":"Z3+(Z3*30%)","v":455000},585000,{"$f":"AB3+(AB3*30%)","v":585000}]
[null,3,422500,507000,676000,676000,676000,{"$f":"H4+(H4*30%)","v":676000},676000,676000,760500,760500,760500,591500,676000,760500,760500,760500,760500,507000,760500,676000,760500,676000,760500,{"$f":"Z4+(Z4*30%)","v":591500},760500,760500]
[null,4,549250,659100,878800,878800,878800,{"$f":"H5+(H5*30%)","v":878800},878800,878800,988650,988650,988650,768950,878800,988650,988650,988650,988650,659100,988650,878800,988650,878800,988650,{"$f":"Z5+(Z5*30%)","v":768950},988650,988650]
[null,5,714025,856830,1142440,1142440,1142440,{"$f":"H6+(H6*30%)","v":1142440},1142440,1142440,1285245,1285245,1285245,999635,1142440,1285245,1285245,1285245,1285245,856830,1285245,1142440,1285245,1142440,1285245,{"$f":"Z6+(Z6*30%)","v":999635},1285245,1285245]
[null,6,{"$f":"C7+(C7*20%)","v":856830},1028196,1370928,{"$f":"F7+(F7*20%)","v":1370928},1370928,{"$f":"H7+(H7*20%)","v":1370928},{"$f":"I7+(I7*20%)","v":1370928},{"$f":"J7+(J7*20%)","v":1370928},1542294,1542294,{"$f":"M7+(M7*20%)","v":1542294},{"$f":"N7+(N7*20%)","v":1199562},{"$f":"O7+(O7*20%)","v":1370928},1542294,{"$f":"Q7+(Q7*20%)","v":1542294},1542294,1542294,1028196,{"$f":"U7+(U7*20%)","v":1542294},1370928,1542294,1370928,1542294,{"$f":"Z7+(Z7*20%)","v":1199562},1542294,{"$f":"AB7+(AB7*20%)","v":1542294}]
[null,7,1028196,1233835.2,1645113.6,1645113.6,1645113.6,{"$f":"H8+(H8*20%)","v":1645113.6},1645113.6,1645113.6,1850752.8,1850752.8,1850752.8,1439474.4,1645113.6,1850752.8,1850752.8,1850752.8,1850752.8,1233835.2,1850752.8,1645113.6,1850752.8,1645113.6,1850752.8,{"$f":"Z8+(Z8*20%)","v":1439474.4},1850752.8,1850752.8]
[null,8,1233835.2,1480602.24,1974136.32,1974136.32,1974136.32,{"$f":"H9+(H9*20%)","v":1974136.32},1974136.32,1974136.32,2220903.3600000003,2220903.3600000003,2220903.3600000003,1727369.2799999998,1974136.32,2220903.3600000003,2220903.3600000003,2220903.3600000003,2220903.3600000003,1480602.24,2220903.3600000003,1974136.32,2220903.3600000003,1974136.32,2220903.3600000003,{"$f":"Z9+(Z9*20%)","v":1727369.2799999998},2220903.3600000003,2220903.3600000003]
[null,9,1480602.24,1776722.6880000001,2368963.5840000003,2368963.5840000003,2368963.5840000003,{"$f":"H10+(H10*20%)","v":2368963.5840000003},2368963.5840000003,2368963.5840000003,2665084.0320000006,2665084.0320000006,2665084.0320000006,2072843.1359999997,2368963.5840000003,2665084.0320000006,2665084.0320000006,2665084.0320000006,2665084.0320000006,1776722.6880000001,2665084.0320000006,2368963.5840000003,2665084.0320000006,2368963.5840000003,2665084.0320000006,{"$f":"Z10+(Z10*20%)","v":2072843.1359999997},2665084.0320000006,2665084.0320000006]
[null,10,1776722.6880000001,2132067.2256,2842756.3008000003,2842756.3008000003,2842756.3008000003,{"$f":"H11+(H11*20%)","v":2842756.3008000003},2842756.3008000003,2842756.3008000003,3198100.8384000007,3198100.8384000007,3198100.8384000007,2487411.7631999999,2842756.3008000003,3198100.8384000007,3198100.8384000007,3198100.8384000007,3198100.8384000007,2132067.2256,3198100.8384000007,2842756.3008000003,3198100.8384000007,2842756.3008000003,3198100.8384000007,{"$f":"Z11+(Z11*20%)","v":2487411.7631999999},3198100.8384000007,3198100.8384000007]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}