{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["الاصناف","البيع","الفاتورة"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"الاختصار","الصنف","الكمية في المخزن","السعر","الكمية المسحوبة","رصيد المخزن"]
[null,null,"اسود","قلم لوحات أسود",30]
[null,null,"احمر","قلم لوحات اخضر",25]
[null,null,"اخضر","قلم لوحات اخضر",25]
[null,null,"حبر1","قلم حبر rotring",10]
[null,null,"حبر2","قلم حبر عادي",100]
[null,null,"جيل1","قلم جيل ألوان "]
[null,null,"رصاص1","قلم Rotrong tikky"]
[null,null,"رصاص2","قلم رصاص عادي سوبر لوكس"]
[null,null,"مثلث ص","مثلث قائم 6سم"]
[null,null,"مثلث ك","مثلث قائم 15 سم"]
[null,null,"كشكول 40","كشكول 40 ورقة لوكس"]
[null,null,"كشكول 60","كشكول 60 ورقة لوكس"]
[null,null,"كشكول 80","كشكول 80 ورقة لوكس"]

{"sheet":"البيع","index":1,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(N3,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]
[null,"اسود",{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B4,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},"حبر1",{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D4,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,"رصاص1",{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(N4,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]
[null,"احمر",{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B5,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":1},"حبر2",{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D5,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,"رصاص2",{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(N5,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":3}]
[null,"اخضر",{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B6,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":1},null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D6,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(N6,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B7,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D7,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(N7,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B8,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D8,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(N8,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B9,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D9,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(N9,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B10,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D10,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(N10,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B11,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D11,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(N11,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B12,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D12,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(N12,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B13,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D13,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(N13,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B14,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D14,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(N14,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B15,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D15,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(N15,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]
[]
[null,"مثلث ص",{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B17,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},"جيل1",{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D17,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,"كشكول 40",{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(H17,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]
[null,"مثلث ك",{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B18,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":2},null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D18,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,"كشكول 60",{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(H18,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":8}]
[null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B19,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D19,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,"كشكول 80",{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(H19,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B20,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D20,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(H20,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B21,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D21,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(H21,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B22,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D22,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(H22,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B23,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D23,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(H23,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B24,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D24,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(H24,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B25,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D25,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(H25,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B26,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D26,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(H26,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B27,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D27,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(H27,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(B28,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(D28,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(INDEX(الاصناف!$D$3:$D$1500,MATCH(H28,الاصناف!$C$3:$C$1500,0)),الفاتورة!$B$5:$E$1500,2,0),\"\")","v":""}]

{"sheet":"الفاتورة","index":2,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,2,1,3],[2,3,2,4]]}
[]
[null,"فاتورة رقم",121512]
[]
["م","الصنف","الكمية","السعر","الاجمالي"]
[null,"قلم لوحات اخضر",1,5,{"$f":"D5*C5","v":5}]
[null,"قلم رصاص عادي سوبر لوكس",3,1,{"$f":"D6*C6","v":3}]
[null,"مثلث قائم 15 سم",2,6,12]
[null,"كشكول 60 ورقة لوكس",8,6,48]