{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ترحيل يومية","فاتورة"],"not_rendered":{"charts":0,"images":0,"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":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[[10,8,16,11]]}
[]
[null,null,"اختر اسم العميل المراد الترحيل اليه","عميل 3"]
[]
["السعر","العدد","بيان","تاريخ الفاتورة","ملاحظات","مديونيات",null,"عميل 1"]
[5,7,"بنطة","2021-11-22","اجل",0,null,"عميل 2"]
[6,2,"مسمار","2021-11-22","كاش",0,null,"عميل 3"]
[2,3,"شنيور","2021-11-22","متبقى حساب",0]
[2,4,"بنطة 4 ملى","2021-11-22","اجل",0]
[5,4,"بنطة 6 ملى","2021-11-22","اجل",0]
[3,4,"بنطة 8 ملى","2021-11-22","اجل",0]
[5,3,"بنطة 10 ملى","2021-11-22","اجل",0,null,null,"السلام عليكم ورحمة الله وبركاته بعد البحث وجدت هذ الكود ولكن به مشكلة هو يرحل الصف الأول فقط ولا يرحل باقى البيانات الى شيت العملاء على حسب اسم العميل ممكن بعد اذنكم معالجة هذا الخطأ"]
[5,6,"بنطة 16 ملى","2021-11-22","اجل",0]
[7,2,"ترمبة كالون","2021-11-22","اجل",0]
[7,2,"هلتى","2021-11-22","اجل",0]
[6,4,"زرادية","2021-11-22","اجل",0]
[4,4,"كماشة","2021-11-22","اجل",0]
[7,2,"مسمار 10 لينية","2021-11-22","اجل",0]
[5,3,"مسمار 12 لينية","2021-11-22","اجل",0]
[2,3,"مسمار 15 لينية","2021-11-22","اجل",0]
[5,5,"مسمار 14 لينية","2021-11-22","اجل",0]
[3,2,"مسمار 16 لينية","2021-11-22","اجل",0]
[5,4,"مسمار 19 لينية","2021-11-22","اجل",0]
[6,5,"مسمار 22 لينية","2021-11-22","اجل",0]

{"sheet":"فاتورة","index":1,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,1,7],[2,5,2,6],[3,5,3,6],[4,0,4,4],[4,5,4,6],[23,0,23,4],[2,9,16,13],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[11,1,11,4],[5,5,5,6]]}
[null,null,null,null,null,null,null,null,null,{"$f":"MONTH(F5)","v":10}]
[]
[null,null,null,null,null,"الفاتورة #",null,2,null,"أستاذ حسونة نسخت كود حضرتك حاولت اعدله واطبقه على شيت الفاتورة اللى هيرحل الى شيت القيمة المضافة حسب الشهر علشان ارحل خلايا معينة ولكن لم افلح ممكن بعد اذنك عمل كود يرحلى الخلايا H3 و الخلية F5 والخلية B7 والخلية H25 والخليه H26 والخلية H27 الترحيل يكون حسب الشهر الموجود في الخلية j1  الى شيت القيمة المضافة المقسم الى 12 شهر كل شهر فى شيت وانا اسف على تعب سيادتكم"]
[]
["القيمة المضافة :",null,null,null,null,"2021-10-05",null,"Date"]
["فاتورة إلى",null,null,null,null,123,null,"po"]
["اسم المشترى","عميل 1"]
[null,null,null,null,null,"نوع الفاتورة",null,"اجل"]
["عنوانة /",null,null,null,null,"المدفوع"]
["تليفون /",null,null,null,null,"الباقى",null,{"$f":"IF(H27-H9<0,0,H27-H9)","v":74.58}]
[]
["م","البيان",null,null,null,"سعر ","الكمية","المبلغ"]
[1,22,null,null,null,44,33,33]
[2,44,null,null,null,55,33,33]
[]
[]
[]
[]
[]
[]
[]
[]
["شكراً لتعاملك معنا!",null,null,null,null,null,"الإجمالي الفرعي",{"$f":"SUM(H13:H22)","v":66}]
[null,null,null,null,null,null,null,0.14000000000000001]
[null,null,null,null,null,null,"معدل الضريبة",{"$f":"H23*H24","v":9.24}]
[null,null,null,null,null,null,"1%أ.ت.ص",{"$f":"H23*1%","v":0.66}]
[null,null,null,null,null,null,"الإجمالي",{"$f":"H23+H25-H26","v":74.58}]