{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["تفاصيل المبيعات","الطباعة"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":14,"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":57,"n_cols":16,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["تقرير حركة الفواتير والعملاء      "]
[null,null,{"$f":"COLUMN()","v":3},{"$f":"COLUMN()","v":4},{"$f":"COLUMN()","v":5},{"$f":"COLUMN()","v":6},{"$f":"COLUMN()","v":7},{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10},{"$f":"COLUMN()","v":11},{"$f":"COLUMN()","v":12},{"$f":"COLUMN()","v":13},{"$f":"COLUMN()","v":14},{"$f":"COLUMN()","v":15},{"$f":"COLUMN()","v":16}]
["ت","رقم القائمة","اسم الزبون","كود","اسم مادة","عدد تعبئة","عدد الكارتون","عدد القطعة","السعر الكارتون","السعر قطعة","المبلغ","نوع دفع"," نوع بيع","اسم المندوب","ادخال العنوان","التاريخ"]
[1,15,"عبدالرحمن جمال الدين عبدالهادي السيد",12345,"شامبو بيرول  8لتر",13,5,8,15,0.86666666666666703,81.933333333333294,"نقدا","جملة","احمد","كركوك","16/10/2020"]
[2,15,"عبدالرحمن جمال الدين عبدالهادي السيد",12345,"شامبو بيرول  8لتر",13,5,5,15,0.86666666666666703,79.3333333333333,"نقدا","جملة","احمد","كركوك","16/10/2020"]
[3,15,"عبدالرحمن جمال الدين عبدالهادي السيد",12345,"شامبو بيرول  8لتر",13,5,7,15,0.86666666666666703,81.066666666666706,"نقدا","جملة","احمد","كركوك","16/10/2020"]
[4,15,"عبدالرحمن جمال الدين عبدالهادي السيد",12345,"شامبو بيرول  8لتر",13,0,0,0,0,0,"نقدا","جملة","احمد","كركوك","16/10/2020"]
[5,15,"عبدالرحمن جمال الدين عبدالهادي السيد",12345,"شامبو بيرول  8لتر",13,5,5,15,0.86666666666666703,79.3333333333333,"نقدا","جملة","احمد","كركوك","16/10/2020"]
[6,15,"عبدالرحمن جمال الدين عبدالهادي السيد",12345,"شامبو بيرول  8لتر",13,5,5,15,5,75,"نقدا","جملة","احمد","كركوك","16/10/2020"]
[7,15,"عبدالرحمن جمال الدين عبدالهادي السيد",12345,"شامبو بيرول  8لتر",13,5,5,15,0.86666666666666703,79.3333333333333,"نقدا","جملة","احمد","كركوك","16/10/2020"]
[8,15,"عبدالرحمن جمال الدين عبدالهادي السيد",12345,"شامبو بيرول  8لتر",13,5,6,15,5,75,"نقدا","جملة","احمد","كركوك","16/10/2020"]
[9,15,"عبدالرحمن جمال الدين عبدالهادي السيد",12345,"شامبو بيرول  8لتر",13,5,5,15,5,75,"نقدا","جملة","احمد","كركوك","16/10/2020"]
[10,15,"عبدالرحمن جمال الدين عبدالهادي السيد",12345,"شامبو بيرول  8لتر",13,5,5,15,0.86666666666666703,79.3333333333333,"نقدا","جملة","احمد","كركوك","16/10/2020"]
[11,15,"عبدالرحمن جمال الدين عبدالهادي السيد",12345,"شامبو بيرول  8لتر",13,5,5,15,5,75,"نقدا","جملة","احمد","كركوك","16/10/2020"]
[12,15,"عبدالرحمن جمال الدين عبدالهادي السيد",12345,"شامبو بيرول  8لتر",13,5,5,15,5,75,"نقدا","جملة","احمد","كركوك","16/10/2020"]
[13,15,"عبدالرحمن جمال الدين عبدالهادي السيد",12345,"شامبو بيرول  8لتر",13,5,5,15,5,75,"نقدا","جملة","مصطفى","كركوك","16/10/2020"]
[14,15,"عبدالرحمن جمال الدين عبدالهادي السيد",12345,"شامبو بيرول  8لتر",13,5,5,15,5,75,"نقدا","جملة","مصطفى","كركوك","16/10/2020"]
[15,15,"عبدالرحمن جمال الدين عبدالهادي السيد",12345,"شامبو بيرول  8لتر",13,5,5,15,5,75,"نقدا","جملة","مصطفى","كركوك","16/10/2020"]
[16,15,"عبدالرحمن جمال الدين عبدالهادي السيد",12345,"شامبو بيرول  8لتر",13,5,5,15,5,75,"نقدا","جملة","مصطفى","كركوك","16/10/2020"]
[1,20,"طارق حسن محمود المجدلي",45045,"ملمع بريل للصحون 2",12,4,5,34,6,136,"نقدا","جملة","حسن","طريق الموصل / قرب شارع 60 ","16/10/2020"]
[2,20,"طارق حسن محمود المجدلي",45045,"ملمع بريل للصحون 2",12,4,5,34,6,136,"نقدا","جملة","حسن","طريق الموصل / قرب شارع 60 ","16/10/2020"]
[3,20,"طارق حسن محمود المجدلي",45045,"ملمع بريل للصحون 2",12,4,5,34,6,136,"نقدا","جملة","حسن","طريق الموصل / قرب شارع 60 ","16/10/2020"]
[4,20,"طارق حسن محمود المجدلي",45045,"ملمع بريل للصحون 2",12,4,5,34,6,136,"نقدا","جملة","حسن","طريق الموصل / قرب شارع 60 ","16/10/2020"]
[5,20,"طارق حسن محمود المجدلي",45045,"ملمع بريل للصحون 2",12,4,5,34,6,136,"نقدا","جملة","حسن","طريق الموصل / قرب شارع 60 ","16/10/2020"]
[6,20,"طارق حسن محمود المجدلي",45045,"ملمع بريل للصحون 2",12,4,5,34,6,136,"نقدا","جملة","حسن","طريق الموصل / قرب شارع 60 ","16/10/2020"]
[7,20,"طارق حسن محمود المجدلي",45045,"ملمع بريل للصحون 2",12,4,5,34,6,136,"نقدا","جملة","حسن","طريق الموصل / قرب شارع 60 ","16/10/2020"]
[8,20,"طارق حسن محمود المجدلي",12345,"شامبو بيرول 5لتر",14,4,5,15,6,60,"نقدا","جملة","حسن","طريق الموصل / قرب شارع 60 ","16/10/2020"]
[9,20,"طارق حسن محمود المجدلي",45045,"ملمع بريل للصحون 2",12,4,5,34,6,136,"نقدا","جملة","حسن","طريق الموصل / قرب شارع 60 ","16/10/2020"]
[10,20,"طارق حسن محمود المجدلي",45045,"ملمع بريل للصحون 2",12,4,5,34,6,136,"نقدا","جملة","حسن","طريق الموصل / قرب شارع 60 ","16/10/2020"]
[11,20,"طارق حسن محمود المجدلي",12345,"شامبو بيرول 5لتر",14,4,5,15,6,60,"نقدا","جملة","حسن","طريق الموصل / قرب شارع 60 ","16/10/2020"]
[12,20,"طارق حسن محمود المجدلي",12345,"شامبو بيرول 5لتر",14,4,5,15,6,60,"نقدا","جملة","حسن","طريق الموصل / قرب شارع 60 ","16/10/2020"]
[13,20,"طارق حسن محمود المجدلي",12345,"شامبو بيرول 5لتر",14,4,5,15,6,60,"نقدا","جملة","حسن","طريق الموصل / قرب شارع 60 ","16/10/2020"]
[14,20,"طارق حسن محمود المجدلي",4132,"شامبو بيرول 6 لتر",12,0,0,123,9.7560975609756101E-2,0,"نقدا","جملة","حسن","طريق الموصل / قرب شارع 60 ","16/10/2020"]
[15,20,"طارق حسن محمود المجدلي",4132,"شامبو بيرول 6 لتر",12,0,5,123,9.7560975609756101E-2,42.5,"نقدا","جملة","حسن","طريق الموصل / قرب شارع 60 ","16/10/2020"]
[16,20,"طارق حسن محمود المجدلي",4132,"شامبو بيرول 6 لتر",12,0,5,123,9.7560975609756101E-2,42.5,"نقدا","جملة","حسن","طريق الموصل / قرب شارع 60 ","16/10/2020"]
[17,20,"طارق حسن محمود المجدلي",54,"شامبو بيرول 3 لتر",34,4,5,54,6,216,"نقدا","جملة","حسن","طريق الموصل / قرب شارع 60 ","16/10/2020"]
[18,20,"طارق حسن محمود المجدلي",54,"شامبو بيرول 3 لتر",34,4,5,54,6,216,"نقدا","جملة","حسن","طريق الموصل / قرب شارع 60 ","16/10/2020"]
[19,20,"طارق حسن محمود المجدلي",54,"شامبو بيرول 3 لتر",34,4,5,54,6,216,"نقدا","جملة","حسن","طريق الموصل / قرب شارع 60 ","16/10/2020"]
[20,20,"طارق حسن محمود المجدلي",54,"شامبو بيرول 3 لتر",34,4,5,54,6,216,"نقدا","جملة","حسن","طريق الموصل / قرب شارع 60 ","16/10/2020"]
[1,24,"راندا صديق نادي قنديل","c34","اقراص فانس 19 عدد",34,45,3,4,8.5,205.5,"نقدا","جملة","ذياب","كركوك","16/10/2020"]
[1,33,"طارق حسن محمود المجدلي","g347","اقراص فانس 12 عدد",5,4,6,4,1.25,23.5,"نقدا","جملة","ذياب","كركوك","16/10/2020"]
[1,34,"عبدالرحمن جمال الدين عبدالهادي ","g347","اقراص فانس 12 عدد",5,4,6,4,1.25,23.5,"نقدا","جملة","ذياب","كركوك","16/10/2020"]
[1,35,"محمد حسن ابراهيم محمد","c34","اقراص فانس 19 عدد",34,6,0,6,5.6666666666666696,36,"نقدا","جملة","ذياب","كركوك","16/10/2020"]
[1,36,"محمد عبدالحميد محمد بريقع","g347","اقراص فانس 12 عدد",5,6,0,6,0.83333333333333304,36,"نقدا","جملة","ذياب","كركوك","16/10/2020"]
[1,37,"محمود رمضان محمد احمد",5,"تايت 1 كم",8,3,0,4,2,12,"نقدا","جملة","ذياب","كركوك","16/10/2020"]
[1,39,"احمد ربيع احمد عطية","g347","شامبو بيرول 3 لتر",12,6,0,4,3,24,"نقدا","جملة","ذياب","كركوك","16/10/2020"]
[1,40,"احمد سمير فتوح عمر","g347","شامبو بيرول 5لتر",1,8,45,3,0.33333333333333298,39,"نقدا","جملة","ذياب","كركوك","16/10/2020"]
[2,40,"احمد سمير فتوح عمر","g347","شامبو بيرول 5لتر",1,5,45,3,0.33,30,"نقدا","جملة","ذياب","كركوك","16/10/2020"]
[1,55,"طارق حسن محمود المجدلي",54,"شامبو بيرول 3 لتر",34,3,1,45,0.75,135.75,"اجل","الجملة","احمد"," الموصل ","20/10/2020"]
[2,55,"طارق حسن محمود المجدلي",12345,"شامبو بيرول 5لتر",14,4,0,17,0.82,68,"اجل","الجملة","احمد"," الموصل ","20/10/2020"]
[3,55,"طارق حسن محمود المجدلي",98,"صابون ",23,1,0,5,4.5999999999999996,5,"اجل","المفرد","احمد"," الموصل ","20/10/2020"]
[4,55,"طارق حسن محمود المجدلي",5646,"أقراص فانش بيرول * 330 لتر * 2 عدد",34,2,3,34,1,71,"اجل","المفرد","احمد"," الموصل ","20/10/2020"]
[5,55,"طارق حسن محمود المجدلي",6352,"تايت 1 كم",12,2,3,5,1,10,"اجل","المفرد","احمد"," الموصل ","20/10/2020"]
[6,55,"طارق حسن محمود المجدلي",8654,"ملمع غسالات الصحون * 2 لتر",12,2,3,5,2.4,17.2,"اجل","المفرد","احمد"," الموصل ","20/10/2020"]
[7,55,"طارق حسن محمود المجدلي",7547,"تايت غسالات الصحون * 1 لتر",12,2,0,6,2,12,"اجل","الجملة","احمد"," الموصل ","20/10/2020"]
[8,55,"طارق حسن محمود المجدلي",4535,"حفاظات اطفال 45 عدد ",12,5,0,7,1.71,35,"اجل","الجملة","احمد"," الموصل ","20/10/2020"]
[1,55,"محمد حسن ابراهيم محمد",2,"أقراص فانش بيرول * 330 لتر * 2 عدد",34,5,5,34,1,170,"اجل","الجملة","احمد"," الموصل ","20/10/2020"]

{"sheet":"الطباعة","index":1,"n_rows":52,"n_cols":26,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,11,2,12],[7,1,7,2],[9,1,9,2],[11,1,11,2],[2,8,3,9],[0,8,1,9],[3,11,5,12],[5,6,5,9],[47,6,48,6],[45,8,46,9],[51,1,51,2],[40,1,41,9],[42,1,43,9],[47,5,48,5],[51,7,51,9],[47,8,48,9],[45,5,46,5],[45,6,46,6]]}
[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,15]
[null,null,null,null,null,null,null,null,null,null,null,20]
[]
[null,null,null,null,null,null,"الموصل / مجموعة الثقافية / الشارع العام"]
[]
[null,"اسم الزبون",null,"عبدالرحمن جمال الدين عبدالهادي السيد",null,null,null,"نوع العملة","دولار"]
[]
[null,"العنوان الزبون",null,"كركوك",null,null,null,"المندوب","مصطفى"]
[]
[null,"التاريخ",null,"16/10/2020",null,null,null,"نوع الدفع","نقدا"]
[null,null,null,null,null,{"$f":"COLUMN()","v":6},{"$f":"COLUMN()","v":7},{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10}]
[null,"ت","كود المادة","المادة","عدد تعئبة","عدد الكارتون","عدد القطعة","السعر الكارتون","السعر القطعة","المبلغ"]
[null,1,12345,"شامبو بيرول  8لتر",13,null,8,15,0.86666666666666703,81.933333333333294,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"x","v":{"$error":"#NAME?"}}]
[null,2,12345,"شامبو بيرول  8لتر",13,null,5,15,0.86666666666666703,79.3333333333333]
[null,3,12345,"شامبو بيرول  8لتر",13,null,7,15,0.86666666666666703,81.066666666666706]
[null,4,12345,"شامبو بيرول  8لتر",13,null,0,0,0,0]
[null,5,12345,"شامبو بيرول  8لتر",13,null,5,15,0.86666666666666703,79.3333333333333,{"$f":"IFERROR(VLOOKUP(L8&ROW(A5),'تفاصيل المبيعات'!B8:K61,3,0),\"\")","v":""}]
[null,6,12345,"شامبو بيرول  8لتر",13,null,5,15,5,75]
[null,7,12345,"شامبو بيرول  8لتر",13,null,5,15,0.86666666666666703,79.3333333333333]
[null,8,12345,"شامبو بيرول  8لتر",13,null,6,15,5,75]
[null,9,12345,"شامبو بيرول  8لتر",13,null,5,15,5,75]
[null,10,12345,"شامبو بيرول  8لتر",13,null,5,15,0.86666666666666703,79.3333333333333]
[null,11,12345,"شامبو بيرول  8لتر",13,null,5,15,5,75]
[null,12,12345,"شامبو بيرول  8لتر",13,null,5,15,5,75]
[null,13,12345,"شامبو بيرول  8لتر",13,null,5,15,5,75]
[null,14,12345,"شامبو بيرول  8لتر",13,null,5,15,5,75]
[null,15,12345,"شامبو بيرول  8لتر",13,null,5,15,5,75]
[null,16,12345,"شامبو بيرول  8لتر",13,null,5,15,5,75]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"        لقد تم استلام البطاعة بتاريخه أعلاه بحالة جيدة وضمن مدة صلاحتيها ان عدم مراجعة الشركة خلال مهلة يومين من تاريخ استلام للبضاعة . تعتبر هذه الأخيرة ممستوفية "]
[]
[null,"        للشروط والمواصفات  المطلوبة كافة لاتعتبر هذه القائمة مسددة الا بموجب وصل قبض رسمي صادر عن الشركة . والاحتفاظ بالوصل لاجل المطابقة"]
[]
[]
[null,null,null,null,null,"عدد الكارتون","عدد القطعة",null,"المجموع المبلغ القائمة"]
[]
[null,null,null,null,null,{"$f":"SUM(F15:F39)","v":0},{"$f":"SUM(G15:G39)","v":81},null,{"$f":"SUM(J15:J39)","v":1155.3333333333333}]
[]
[]
[]
[null,"اسم و توقيع السائق",null,"اسم وتوقيع وتاريخ المستلم البطاعة",null,null,null,"يسدد القائمة خلال 15 يوم"]