{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["المخزن ","تقرير ","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":3,"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":"المخزن ","index":0,"n_rows":381,"n_cols":12,"rows_kept":381,"cut":false,"hidden":false,"merged":[]}
["م","كود\n الصنف ","اسم \nالصنف ","الكمية \nالموجودة ","الكمية \nالمتبقية ","سعر\n الوحدة ","سعر\n البيع ","صافى \nالربح","الكمية\n المباعة ","ضريبة \n(14%)","صافى\n الربح","الربح \nبالضريبة "]
[{"$f":"IF(C2=\"\",\"\",ROW()-1)","v":1},{"$f":"IF(C2=\"\",\"\",ROW()+999)","v":1001},"قلم روتو",100,{"$f":"D2-I2","v":99},1.5,2.5,{"$f":"G2-F2","v":1},1,{"$f":"I2:I1818*14%","v":0.14000000000000001},{"$f":"H2*I2","v":1},{"$f":"K2+J2","v":1.1400000000000001}]
[{"$f":"IF(C3=\"\",\"\",ROW()-1)","v":2},{"$f":"IF(C3=\"\",\"\",ROW()+999)","v":1002},"قلم ماركر",30,4,4,5,{"$f":"G3-F3","v":1},26,3.6400000000000006,{"$f":"H3*I3","v":26},{"$f":"K3+J3","v":29.64}]
[3,1003,"قلم كوركتور",50,30,3.5,5,1.5,20,2.8000000000000003,30,32.799999999999997]
[4,1004,"قلم سبورة ",40,39,5,7,2,1,0.14000000000000001,2,2.14]
[5,1005,"سلوتب ",100,50,1,2,1,50,7.0000000000000009,50,57]
[6,1006,"حافظة",500,499,0.4,1,0.6,1,0.14000000000000001,0.6,0.74]
[7,1007,"كشكول سلك ",20,6,7,10,3,14,1.9600000000000002,42,43.96]
[8,1008,"كشكول عادى ",30,5,2,3,1,25,3.5000000000000004,25,28.5]
[9,1009,"كراسة عادية",100,100,2,4,2]
["",""]
["",""]
[{"$f":"IF(C13=\"\",\"\",ROW()-1)","v":""},{"$f":"IF(C13=\"\",\"\",ROW()+999)","v":""}]
["",""]
["",""]
["",""]
["",""]
["",""]
[null,{"$f":"IF(D19=\"\",\"\",ROW()+999)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(D67=\"\",\"\",ROW()+999)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(D131=\"\",\"\",ROW()+999)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(D195=\"\",\"\",ROW()+999)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(D259=\"\",\"\",ROW()+999)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(D323=\"\",\"\",ROW()+999)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"تقرير ","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,1,4],[2,3,2,4],[3,3,3,4],[6,0,6,2],[2,0,2,2],[3,0,3,2],[11,0,11,2],[13,0,13,2],[12,0,12,2],[7,0,7,2],[8,0,8,2],[9,0,9,2],[10,0,10,2]]}
[]
["تقرير عن صنف "]
["كود الصنــف",null,null,1002]
["اســم الصنـــف",null,null,{"$f":"VLOOKUP($D$3,'المخزن '!B:L,2,TRUE)","v":"قلم ماركر"}]
[]
[]
["إجمالى الكميــة ",null,null,{"$f":"IFERROR(VLOOKUP($D$3,'المخزن '!B:L,3,TRUE),\"--\")","v":30}]
["الكميــة الموجودة ",null,null,{"$f":"VLOOKUP($D$3,'المخزن '!B:L,4,TRUE)","v":4}]
["الكميــة المباعة ",null,null,{"$f":"VLOOKUP($D$3,'المخزن '!B:L,8,TRUE)","v":26}]
["سعر الوحدة ",null,null,{"$f":"VLOOKUP($D$3,'المخزن '!B:L,5,TRUE)","v":4}]
["سعر البيــع ",null,null,{"$f":"VLOOKUP($D$3,'المخزن '!B:L,6,TRUE)","v":5}]
["الربـــح",null,null,{"$f":"VLOOKUP($D$3,'المخزن '!B:L,7,TRUE)","v":1}]
["ضريبــة",null,null,{"$f":"VLOOKUP($D$3,'المخزن '!B:L,9,TRUE)","v":3.6400000000000006}]
["إجمالى الربـح ",null,null,{"$f":"VLOOKUP($D$3,'المخزن '!B:L,10,TRUE)","v":26}]

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