{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["SOURCE_SH","TARGET_SH","ورقة3"],"not_rendered":{"charts":0,"images":3,"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":"SOURCE_SH","index":0,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,1,45,5],[10,5,10,6],[17,4,17,5],[18,4,18,5]]}
[]
[]
[]
[]
[null,null,null,null,null,"التاريخ:",{"$f":"TODAY()","v":"2020-01-20"}]
[null,null,null,null,null,"رقم الفاتورة :","INV1000-01"]
[null,null,null,null,null,"رقم الزبون:","CUS1000-A1"]
[null,null,null,null,null,"رقم امر الشراء:","ORDER1000-I1"]
[null,null,null,null,null,"تاريخ الاستحقاق:",{"$f":"G5+10","v":"2020-01-30"}]
[]
["الشركة المستلمة : ","Officena",null,null,null,"الشركة البائعة :"]
["اسم الشركة(العميل) :","ford",null,null,null,"اسم الشركة :"]
["العنوان :","hh",null,null,null,"العنوان :"]
["الهاتف :",150,null,null,null,"الهاتف : "]
[]
[]
[]
["مسؤول المبيعات","طريقة الشحن","شروط الشحن","شروط الدفع","تاريخ الاستحقاق",null,"تاريخ التسليم"]
["محمد","بحري","على الباخرة","نقدا",{"$f":"G9","v":"2020-01-30"},null,{"$f":"G5","v":"2020-01-20"}]
[]
["رقم الكود","الصنف","النوع ","المنشا","الكمية","السعر","الاجمالي"]
[152,"1200R20","G580","THI",200,10,{"$f":"IF(OR(ISBLANK(E22),E22=0),0,E22*F22)","v":2000}]
[14,"1200R21","G581","THI",200,10,{"$f":"IF(OR(ISBLANK(E23),E23=0),0,E23*F23)","v":2000}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[]
[null,null,null,null,null,"الاجمالي :",{"$f":"SUM(G16:G42)","v":47850}]
[null,null,null,null,null,"خصم",20]
["الاجمالي بالحروف :",null,null,null,null,null,{"$f":"G43-G44","v":-47850}]

{"sheet":"TARGET_SH","index":1,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[11,5,11,6],[39,1,39,5]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"التاريخ:","2020-01-20"]
[null,null,null,null,null,"رقم الفاتورة :","INV1000-01"]
[null,null,null,null,null,"رقم الزبون:","CUS1000-A1"]
[null,null,null,null,null,"رقم امر الشراء:","ORDER1000-I1"]
[null,null,null,null,null,"تاريخ الاستحقاق:","2020-01-30"]
[]
["الشركة المستلمة : ","Officena"]
["اسم الشركة(العميل) :","ford"]
["العنوان :","hh"]
["الهاتف :",150]
[]
["رقم الكود","الصنف","النوع ","المنشا","الكمية","السعر","الاجمالي"]
[152,"1200R20","G580","THI",200,10,2000]
[14,"1200R21","G581","THI",200,10,2000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"الاجمالي :",{"$f":"SUM(G18:G36)","v":4000}]
[null,null,null,null,null,"خصم",20]
[]
["الاجمالي بالحروف :",null,null,null,null,null,{"$f":"G37-G38","v":3980}]

{"sheet":"ورقة3","index":2,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[[10,0,10,1],[10,5,10,6],[45,1,45,5]]}
[]
[]
[null,null,null,null,null,"امر شراء "]
[]
[null,null,null,null,null,"التاريخ:",{"$f":"TODAY()","v":"2020-01-20"}]
[null,null,null,null,null,"رقم امر الشراء:"]
[null,null,null,null,null,"رقم الزبون:"]
[null,null,null,null,null,"تاريخ الاستحقاق:"]
[]
[]
["الشركة المستلمة : "]
["اسم الشركة(العميل) :"]
["العنوان :"]
["الهاتف :"]
[]
[]
[]
[]
["رقم الكود","الصنف","النوع ","المنشا","الكمية","السعر","الاجمالي"]
[null,"1200R20",null,null,200,1500,{"$f":"IF(OR(ISBLANK(E20),E20=\"-\"),0,E20*F20)","v":300000}]
[null,null,null,null,10,10,{"$f":"IF(OR(ISBLANK(E21),E21=0),0,E21*F21)","v":100}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[]
[null,null,null,null,null,"الاجمالي :",{"$f":"SUM(G20:G41)","v":300100}]
[null,null,null,null,null,"خصم",20]
[]
["الاجمالي بالحروف :",null,null,null,null,null,{"$f":"G43-G44","v":300080}]