{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Salaries"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Salaries","index":0,"n_rows":23,"n_cols":24,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,1,3,3],[3,7,8,7],[3,23,5,24],[15,2,15,3]]}
[]
[]
[]
[null,"السائقين",null,null,null,null,null,"المطلوب عد قيمة كل ورقة نقدية  من الجدول الأيمن و اضافتها الى هذا الجدول",null,null,null,null,5,10,20,50,100,200,500,1000,null,null,null,"تفقيط الأرقام لكل عملة ورقية"]
[null,6870,null,1,null,null,null,null,null,null,null,6870,{"$f":"MOD(B5,10)/5","v":0},{"$f":"(MOD(B5,10)-MOD(B5,10))/10","v":0},{"$f":"(MOD(B5,50)-MOD(B5,20))/20","v":0.5},{"$f":"(MOD(B5,100)-MOD(B5,50))/50","v":1},{"$f":"MOD(B5,100)/100","v":0.7},{"$f":"(MOD(B5,500)-MOD(B5,200))/200","v":1.5},{"$f":"(MOD(B5,1000)-MOD(B5,500))/500","v":1},{"$f":"(B5-MOD(B5,1000))/1000","v":6}]
[null,3650,null,2,null,null,null,null,null,null,null,3650,{"$f":"MOD(B6,10)/5","v":0},{"$f":"(MOD(B6,10)-MOD(B6,10))/10","v":0},{"$f":"(MOD(B6,50)-MOD(B6,20))/20","v":-0.5},{"$f":"(MOD(B6,100)-MOD(B6,50))/50","v":1},{"$f":"MOD(B6,100)/100","v":0.5},{"$f":"(MOD(B6,100)-MOD(B6,200))/200","v":0},1,{"$f":"(B6-MOD(B6,1000))/1000","v":3}]
[null,2105,null,3,null,null,null,null,null,null,null,2105,1,0,{"$f":"(MOD(B7,50)-MOD(B7,20))/20*1","v":0},0,{"$f":"MOD(B7,100)/100","v":0.05},{"$f":"(MOD(B7,1000)-MOD(B7,200))/200","v":0},0,2]
[null,5225,null,4,null,null,null,null,null,null,null,5225,1,0,1,{"$f":"(MOD(B8,100)-MOD(B8,50))/50","v":0},{"$f":"MOD(B8,100)/100","v":0.25},1,0,5]
[null,4885,null,5,null,null,null,null,null,null,null,4885,1,0,1.5,{"$f":"(MOD(B9,100)-MOD(B9,50))/50","v":1},{"$f":"MOD(B9,100)/100","v":0.85},4,1,4]
[null,4400,null,6,null,null,null,null,null,null,null,4400,0,0,0,0,{"$f":"MOD(B10,100)/100","v":0},2,0,4]
[null,4075,null,7,null,null,null,null,null,null,null,4075,1,0,{"$f":"(MOD(B11,50)-MOD(B11,20))/20*1","v":0.5},1,{"$f":"MOD(B11,100)/100","v":0.75},0,0,4]
[null,5495,null,8,null,null,null,null,null,null,null,5495,1,0,{"$f":"(MOD(B12,50)-MOD(B12,20))/20*1","v":1.5},1,{"$f":"MOD(B12,100)/100","v":0.95},{"$f":"(MOD(B12,1000)-MOD(B12,200))/200","v":2},0,5]
[null,4175,null,9,null,null,null,null,null,null,null,4175,{"$f":"MOD(B13,10)/5","v":1},0,0.5,1,{"$f":"MOD(B13,100)/100","v":0.75},0,0,4]
[null,4920,null,10,null,{"$f":"H14*J14","v":45000},"=",{"$f":"T16","v":45},"×",1000,null,4920,0,0,1,0,{"$f":"MOD(B14,100)/100","v":0.2},4,1,4]
[null,4930,null,11,null,{"$f":"H15*J15","v":2500},"=",{"$f":"S16","v":5},"×",500,null,4930,0,0,1,{"$f":"(MOD(B15,100)-MOD(B15,50))/50","v":0},{"$f":"MOD(B15,100)/100","v":0.3},4,1,4]
[null,{"$f":"SUM(B5:B15)","v":50730},"الاجمالي",null,null,2200,"=",11,"×",200,null,null,{"$f":"SUM(M5:M15)","v":6},0,7,6,5.3,18.5,{"$f":"SUM(S5:S15)","v":5},{"$f":"SUM(T5:T15)","v":45}]
[null,null,null,null,null,500,"=",5,"×",100,null,null,6,1,9,6,5,11,5,45]
[null,null,null,null,null,300,"=",6,"×",50,null,null,{"$f":"IF(M16=M17,\"OK\",\"Error\")","v":"OK"},"Error","Error","OK",{"$f":"IF(Q16=Q17,\"OK\",\"Error\")","v":"Error"},{"$f":"IF(R16=R17,\"OK\",\"Error\")","v":"Error"},"OK","OK"]
[null,null,null,null,null,180,"=",9,"×",20]
[null,null,null,null,null,20,"=",2,"×",10]
[null,null,null,null,null,{"$f":"H21*J21","v":30},"=",6,"×",5]
[]
[null,null,null,null,null,{"$f":"SUM(F14:F22)","v":50730}]