{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["المبيعات","الاصناف"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["رقم الفاتورة","التاريخ","كوود","اسم الصنف","العدد","السعر","الاجمالى","البائع","رقم","العميل","سعر الشراء","ربح الحبه","اجمالى ربح"]
[1,"2019-04-06",1,"زيت",1,12,12,null,122,525,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":2}]
[2,"2019-04-06",1,"زيت",22,12,264,null,11,22,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":44}]
[2,"2019-04-06",1,"زيت",1,12,12,null,11,22,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":2}]
[2,"2019-04-06",1,"زيت",2,12,24,null,11,22,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":4}]
[2,"2019-04-06",1,"زيت",1,12,12,null,11,22,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":2}]
[2,"2019-04-06",1,"زيت",12,12,144,null,11,22,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":24}]
[2,"2019-04-06",1,"زيت",1,12,12,null,11,22,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":2}]
[2,"2019-04-06",1,"زيت",1,12,12,null,11,22,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":2}]
[3,"2019-04-06",1,"زيت",1,12,12,null,1,"محمد",{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":2}]
[3,"2019-04-06",1,"زيت",1,12,12,null,1,"محمد",{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":2}]
[3,"2019-04-06",1,"زيت",1,12,12,null,1,"محمد",{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":2}]
[4,"2019-04-06",1,"زيت",1,12,12,null,1,1111,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":2}]
[4,"2019-04-06",1,"زيت",1,12,12,null,1,1111,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":2}]
[4,"2019-04-06",1,"زيت",2,12,24,null,1,1111,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":4}]
[4,"2019-04-06",1,"زيت",3,12,36,null,1,1111,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":6}]
[4,"2019-04-06",1,"زيت",11,12,132,null,1,1111,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":22}]
[5,"2019-04-06",1,"زيت",2,12,24,null,1,11,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":4}]
[5,"2019-04-06",1,"زيت",2,12,24,null,1,11,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":4}]
[5,"2019-04-06",1,"زيت",1,1,1,null,1,11,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":-9},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":-9}]
[5,"2019-04-06",1,"زيت",1,12,12,null,1,11,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":2}]
[5,"2019-04-06",1,"زيت",1,1,1,null,1,11,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":-9},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":-9}]
[5,"2019-04-06",1,"زيت",11,12,132,null,1,11,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":22}]
[6,"2019-04-06",2,"ارو",2,7,14,null,1,1,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":5},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":4}]
[6,"2019-04-06",1,"زيت",10,12,120,null,1,1,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":20}]
[6,"2019-04-06",2,"ارو",2,7,14,null,1,1,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":5},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":4}]
[6,"2019-04-06",1,"زيت",1,12,12,null,1,1,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":2}]
[6,"2019-04-06",1,"زيت",2,12,24,null,1,1,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":4}]
[7,"2019-05-30",1,"زيت",5,12,60,null,"م",222,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":10}]
[8,"2019-05-31",1,"زيت",11,12,132,null,11,225,{"$f":"VLOOKUP(الجدول4[[#This Row],[كوود]],الجدول3[],4,0)","v":10},{"$f":"الجدول4[[#This Row],[السعر]]-الجدول4[[#This Row],[سعر الشراء]]","v":2},{"$f":"الجدول4[[#This Row],[العدد]]*الجدول4[[#This Row],[ربح الحبه]]","v":22}]

{"sheet":"الاصناف","index":1,"n_rows":4,"n_cols":19,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["كوود","التاريخ","العدد","سعر الشراء","اسم الصنف","السائق","سعر البيع","البائع","المباع","المبلغ","العدد الباقى","صافى ربح",null,null,null,null,null,"العملاء"]
[1,"2019-04-06",360,10,"زيت","احمد",12,"محمد",null,null,null,null,null,null,null,null,null,"رقم ","اسم"]
[2,"2019-04-06",300,5,"ارو","احمد",7,null,null,null,null,null,null,null,null,null,null,100,"محمد"]
[3,"2019-10-10",500,5,"صابون","احمد",6,null,null,null,null,null,null,null,null,null,null,101,"احمد"]