{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Computation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Computation","index":0,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,1,8]]}
["Salary Computation  *"]
[]
[]
[]
[]
[null,"Name",null,"XXXXXXXX",null,"Designation",null,"XXXXXXX"]
[]
[null,"Basic Salary",null,2500,"AED/Month"]
[]
[null,"Allowance",null,30,"AED / Day"]
[]
[null,null,null,null,null,null,"Hourly Rate",null,"Amount in AED"]
[null,"Basic Hours",null,"26 Days X 8 Hrs",{"$f":"26*8","v":208},"hrs",{"$f":"FLOOR(D8/E13,0.01)","v":12.01},null,{"$f":"D8","v":2500}]
[null,"ND OT Hours (125%)",null,"26 Days X 4 Hrs",{"$f":"26*4","v":104},"hrs",{"$f":"G13*1.25","v":15.012499999999999},null,{"$f":"G14*E14","v":1561.3}]
[null,"Friday Hours (150%)",null,"4 Days X 12 Hrs",{"$f":"4*12","v":48},"hrs",{"$f":"G13*1.5","v":18.015000000000001},null,{"$f":"G15*E15","v":864.72}]
[]
[null,"Monthly Hours (30 days / month)",null,null,{"$f":"SUM(E13:E15)","v":360},"hrs",null,null,{"$f":"SUM(I13:I15)","v":4926.0200000000004}]
[]
[null,"Food Allowance",null,null,30,"days",null,null,{"$f":"E19*D10","v":900}]
[]
[null,"TOTAL in AED",null,null,null,null,null,null,{"$f":"I19+I17","v":5826.02}]
[]
[null,"Amount In words",null,{"$f":"spellnumber((I21))","v":"Five Thousand Eight Hundred Twenty Six Rupees  Only "}]
[]
[]
["*On the  30 Days basis",null,"My Query"]
[null,null,null,"Actually I need the highlighted is automatically updated"]
[null,null,null,"when I change the Basic Salary "]
[null,null,null,"is there any way to do this in excel"]