{"text_format":"1","workbook":"xlsx","n_sheets":5,"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":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,"اسم العميل","محمود عبد الفتاح"]
[null,"رقم الجوال","01090854263"]
[null,"التاريخ",{"$f":"TODAY()","v":"2023-02-25"}]
[]
[]
[]
[]
["م","كود الصنف","الصنف","عدد القطع المباعه","عدد المرتجع","سعر القطعه","سعر البيع","الخصم","قيمة الخصم","الاجمالي بعد الخصم",null,"التاريخ"]
[{"$f":"IF(B10>0,ROW()-9,\"\")","v":1},1002,"بنطلون كلاسيك تركي",5,null,120,600,0.1,60,540,null,{"$f":"IF(B10>0,$C$4,\"\")","v":"2023-02-25"}]
[{"$f":"IF(B11>0,ROW()-9,\"\")","v":2},1001,"بنطلون جينز تركي",6,null,150,900,0.05,45,855,null,{"$f":"IF(B11>0,$C$4,\"\")","v":"2023-02-25"}]
[{"$f":"IF(B12>0,ROW()-9,\"\")","v":3},1002,"بنطلون كلاسيك تركي",10,null,120,600,0.1,60,540,null,{"$f":"IF(B12>0,$C$4,\"\")","v":"2023-02-25"}]
["",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,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,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,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,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,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,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,""]

{"sheet":"المرتجع","index":1,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,"اسم العميل","محمود عبد الفتاح"]
[null,"رقم الجوال","01090854263"]
[null,"التاريخ",{"$f":"TODAY()","v":"2023-02-25"}]
[]
[]
[]
[]
["م","كود الصنف","الصنف","عدد القطع المباعه","عدد المرتجع","سعر القطعه","سعر البيع","الخصم","قيمة الخصم","الاجمالي بعد الخصم","التاريخ"]
[{"$f":"IF(B10>0,ROW()-9,\"\")","v":1},1002,"بنطلون كلاسيك تركي",null,2,120,240,0.1,24,216,{"$f":"IF(A10>0,$C$4,\"\")","v":"2023-02-25"}]
[2,1001,"بنطلون جينز تركي",null,3,150,450,0.05,22.5,427.5,{"$f":"IF(A11>0,$C$4,\"\")","v":"2023-02-25"}]
[]
[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,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,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,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,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,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,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"مديونيات العميل","index":2,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,"اسم العميل","محمودعبد الفتاح"]
[null,"رقم الجوال","01090854263"]
[null,"التاريخ",{"$f":"TODAY()","v":"2023-02-25"}]
[]
[]
[]
[]
["م","كود الصنف","الصنف","القطع المباعه","عدد المرتجع","سعر القطعه","سعر البيع","الخصم","قيمة الخصم","الاجمالي بعد الخصم","سداد","التاريخ"]
[{"$f":"IF(B10>0,ROW()-9,\"\")","v":1},1002,"بنطلون كلاسيك تركي","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ",500,"2023-02-22"]
[2,null,null,"ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ",null,{"$f":"IF(B11>0,$C$4,\"\")","v":""}]
[3,null,null,"ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ",null,""]
[4,null,null,"ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ",null,""]
[5,null,null,"ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ",null,""]
[6,null,null,"ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ",null,""]
[7,null,null,"ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ",null,""]
[8,null,null,"ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ",null,""]
[9,null,null,"ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ",null,""]
[10,null,null,"ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ",null,""]
[11,null,null,"ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ",null,""]
[12,null,null,"ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ",null,""]
[13,null,null,"ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ",null,""]
[14,null,null,"ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ",null,""]
[15,null,null,"ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ",null,""]

{"sheet":"بيانات المخزن","index":3,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
["م","كود الصنف","الصنف","عددالقطع المباعه","عدد المرتجع","عدد المتبقي"]
[1,1002,"بنطلون كلاسيك تركي",15,2,{"$f":"D10-E10","v":13},null,null,{"$f":"D10-E10","v":13}]
[2,1001,"بنطلون جينز تركي",6,3,{"$f":"D11-E11","v":3},null,null,{"$f":"D11-E11","v":3}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]

{"sheet":"محمود عبد الفتاح","index":4,"n_rows":484,"n_cols":19,"rows_kept":484,"cut":false,"hidden":false,"merged":[[5,0,6,1],[5,2,6,3],[5,4,5,5],[5,6,5,8],[5,9,5,10],[6,4,6,5],[6,6,6,8],[6,9,6,10]]}
[]
[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,null,null,null,null,null,null,null,"رقم الجوال","01090854263"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"التاريخ",{"$f":"TODAY()","v":"2023-02-25"}]
[]
["العميل/",null,{"$f":"S2","v":"محمودعبد الفتاح"},null,"المبلغ المستحق",null,"مبلغ تم استرجاعه",null,null,"سداد مديونيات",null,"مبلغ مستحق"]
[null,null,null,null,{"$f":"SUM(O10:O997)","v":1935},null,{"$f":"SUM(P10:P997)","v":643.5},null,null,{"$f":"SUM(K10:K484)","v":500},null,{"$f":"E7-G7-J7","v":791.5}]
[]
["م","كود الصنف","الصنف","عدد القطع المباعه","عدد المرتجع","سعر القطعه","سعر البيع","الخصم","قيمة الخصم","الاجمالي بعد الخصم","سداد","التاريخ",null,null,"مبلغ مستحق","مبلغ مرتجع للعميل"]
[{"$f":"IF(B10>0,ROW()-9,\"\")","v":1},1002,"بنطلون كلاسيك تركي",5,null,120,600,0.1,60,540,null,"2023-02-23",null,null,{"$f":"IF(D10>0,J10,\"\")","v":540},{"$f":"IF(E10>0,J10,\"\")","v":""}]
[2,1001,"بنطلون جينز تركي",6,null,150,900,0.05,45,855,null,"2023-02-23",null,null,855,""]
[3,1002,"بنطلون كلاسيك تركي",10,null,120,600,0.1,60,540,null,"2023-02-23",null,null,540,""]
[4,1002,"بنطلون كلاسيك تركي",null,2,120,240,0.1,24,216,null,"2023-02-23",null,null,"",216]
[5,1001,"بنطلون جينز تركي",null,3,150,450,0.05,22.5,427.5,null,"2023-02-23",null,null,"",427.5]
[6,1002,"بنطلون كلاسيك تركي","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ","ــــــــــــ",500,"2023-02-22",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,null,"",""]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["",null,null,null,null,null,null,null,null,null,{"$f":"IF(D19>0,J19,\"\")","v":""},{"$f":"IF(B19>0,$S$4,\"\")","v":""},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,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,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,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,null,null,"","",null,null,"",""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B73>0,ROW()-9,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B137>0,ROW()-9,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B201>0,ROW()-9,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B265>0,ROW()-9,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B329>0,ROW()-9,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B393>0,ROW()-9,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B457>0,ROW()-9,\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]