{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["ترحيل","Report_Youmi","1","2","Salim","A","A (2)","A (3)","A (4)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":17,"n_cols":17,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,1,1],[0,3,1,3],[0,4,1,4]]}
["التاريخ","الاسم","رقم الفاتورة","المبلغ","أسماء صفحات الشيتات","المخزن",null,null,null,null,null,null,"مخزن1","مخزن2","مخزن3","مخزن4","مخزن5"]
["2021-01-01",null,null,null,null,"مخزن5",null,"مخزن1",null,null,null,null,1,2,1,"A",1]
[null,"ايرادات",null,0,1,null,null,"مخزن2",null,null,null,null,2,"salim","salim","A (2)",2]
[null,"ايرادات",null,0,2,null,null,"مخزن3",null,null,null,null,"salim","A","A (3)","A (3)","salim"]
[null,"ايرادات",null,0,"salim",null,null,"مخزن4",null,null,null,null,null,null,null,"A (4)","A (2)"]
[null,"ايرادات",null,0,"A (2)",null,null,"مخزن5"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"الية العمل بنختار اسم المخزن من القائمة F2 ونضغط زر استدعاء البيانات في صفحة فيحضر البيانات الى عمود الاسم وعمود المبلغ بيضع فيه اصفار وعمود"]
[null,null,null,null,null,null,null,"أسماء الصفحات وعند تغير اسم المخزن والضغط على الزر بيتغير البياات حسب مارتبناهم بالاعمدة المساعدة"]
[null,null,null,null,null,null,null,"الاعمدة المساعدة التي يستدعى منها الكود البيانات هي عمود أسماء الصفحات","من M:Q حسب عدد المخازن هنا بالمثال 5",null,null,"بس انا عندى 7 مخازن كما بالاكسس ده فقط مثال"]
[]
[null,null,null,null,null,null,null,"وفى كود الترحيل بيتم ترحيل البيانات التي بها مبلغ فقط اما التي مبلغها صفر لا ترحل"]
[null,null,null,null,null,null,null,"فبستدعى البيانات واكتب المبالغ وارحل"]

{"sheet":"Report_Youmi","index":1,"n_rows":10,"n_cols":351,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sheets",null,"M1","M2","TOTAL","M4","M5",null,"Start_Date","End_date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ALL"]
[null,null,null,null,null,null,null,null,"2020-03-22","2020-05-30",null,null,null,"جمع الكل","Positive"]
[1,null,-1,2,6,null,-2,null,null,null,null,null,null,null,"Negativ"]
[2,null,-1,2,6,null,-2,null,null,null,null,null,null,"الأرقام الموجبة","ALL"]
["Salim",null,-1,2,6,null,-2]
["A",null,-1,2,6,null,-2]
["A (2)",null,-1,2,6,null,-2]
["A (3)",null,-1,2,6,null,-2]
["A (4)",null,-1,2,6,null,-2]
["TOTAL",null,-7,14,42,0,-14]

{"sheet":"1","index":2,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["التاريخ",null,null,null,"مخزن1","مخزن2","مخزن3","مخزن4","مخزن5"]
[]
["1900-01-01",0]
["2020-03-22","ت",555,{"$f":"RANDBETWEEN(-5,5)","v":4},3,0,-5,3,-3]
["2020-03-30","الاجمالى",null,null,{"$f":"SUM(E$4:E4)","v":3},{"$f":"SUM(F$4:F4)","v":0},{"$f":"SUM(G$4:G4)","v":-5},{"$f":"SUM(H$4:H4)","v":3},{"$f":"SUM(I$4:I4)","v":-3}]
["2020-04-01","ت1",null,null,2,4,2,4,-4]
["2020-04-20","ت2",null,null,3,-3,2,4,-1]
["2020-04-25","ت3",null,null,1,5,0,-1,-4]
["2020-04-28","ت4",null,null,3,1,0,-5,3]
["2020-04-30","الاجمالى",null,null,{"$f":"SUM(E6:E9)","v":9},{"$f":"SUM(F6:F9)","v":7},4,2,-6]
["2020-05-10","ت5",null,null,-1,-4,2,5,-3]
["2020-05-11","ت6",null,null,-1,-1,2,-4,5]
["2020-05-12","ت7",null,null,-3,5,-3,5,2]
["2020-05-20","ت8",null,null,-4,-5,-2,-5,1]
["2020-05-21","ت9",null,null,-1,0,3,-3,-1]
["2020-05-30","الاجمالى",null,null,{"$f":"SUM(E11:E15)","v":-10},{"$f":"SUM(F11:F15)","v":-5},{"$f":"SUM(G11:G15)","v":2},{"$f":"SUM(H11:H15)","v":-2},{"$f":"SUM(I11:I15)","v":4}]

{"sheet":"2","index":3,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["التاريخ",null,null,null,"مخزن1","مخزن2","مخزن3","مخزن4","مخزن5"]
[]
["1900-01-01",0]
["2020-03-22","ت",555,{"$f":"RANDBETWEEN(-5,5)","v":5},3,0,-5,3,-3]
["2020-03-30","الاجمالى",null,null,{"$f":"SUM(E$4:E4)","v":3},{"$f":"SUM(F$4:F4)","v":0},{"$f":"SUM(G$4:G4)","v":-5},{"$f":"SUM(H$4:H4)","v":3},{"$f":"SUM(I$4:I4)","v":-3}]
["2020-04-01","ت1",null,null,2,4,2,4,-4]
["2020-04-20","ت2",null,null,3,-3,2,4,-1]
["2020-04-25","ت3",null,null,1,5,0,-1,-4]
["2020-04-28","ت4",null,null,3,1,0,-5,3]
["2020-04-30","الاجمالى",null,null,{"$f":"SUM(E6:E9)","v":9},{"$f":"SUM(F6:F9)","v":7},4,2,-6]
["2020-05-10","ت5",null,null,-1,-4,2,5,-3]
["2020-05-11","ت6",null,null,-1,-1,2,-4,5]
["2020-05-12","ت7",null,null,-3,5,-3,5,2]
["2020-05-20","ت8",null,null,-4,-5,-2,-5,1]
["2020-05-21","ت9",null,null,-1,0,3,-3,-1]
["2020-05-30","الاجمالى",null,null,{"$f":"SUM(E11:E15)","v":-10},{"$f":"SUM(F11:F15)","v":-5},{"$f":"SUM(G11:G15)","v":2},{"$f":"SUM(H11:H15)","v":-2},{"$f":"SUM(I11:I15)","v":4}]

{"sheet":"Salim","index":4,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["التاريخ",null,null,null,"مخزن1","مخزن2","مخزن3","مخزن4","مخزن5"]
[]
["1900-01-01",0]
["2020-03-22","ت",555,{"$f":"RANDBETWEEN(-5,5)","v":3},3,0,-5,3,-3]
["2020-03-30","الاجمالى",null,null,{"$f":"SUM(E$4:E4)","v":3},{"$f":"SUM(F$4:F4)","v":0},{"$f":"SUM(G$4:G4)","v":-5},{"$f":"SUM(H$4:H4)","v":3},{"$f":"SUM(I$4:I4)","v":-3}]
["2020-04-01","ت1",null,null,2,4,2,4,-4]
["2020-04-20","ت2",null,null,3,-3,2,4,-1]
["2020-04-25","ت3",null,null,1,5,0,-1,-4]
["2020-04-28","ت4",null,null,3,1,0,-5,3]
["2020-04-30","الاجمالى",null,null,{"$f":"SUM(E6:E9)","v":9},{"$f":"SUM(F6:F9)","v":7},4,2,-6]
["2020-05-10","ت5",null,null,-1,-4,2,5,-3]
["2020-05-11","ت6",null,null,-1,-1,2,-4,5]
["2020-05-12","ت7",null,null,-3,5,-3,5,2]
["2020-05-20","ت8",null,null,-4,-5,-2,-5,1]
["2020-05-21","ت9",null,null,-1,0,3,-3,-1]
["2020-05-30","الاجمالى",null,null,{"$f":"SUM(E11:E15)","v":-10},{"$f":"SUM(F11:F15)","v":-5},{"$f":"SUM(G11:G15)","v":2},{"$f":"SUM(H11:H15)","v":-2},{"$f":"SUM(I11:I15)","v":4}]

{"sheet":"A","index":5,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["التاريخ",null,null,null,"مخزن1","مخزن2","مخزن3","مخزن4","مخزن5"]
[]
["1900-01-01",0]
["2020-03-22","ت",555,{"$f":"RANDBETWEEN(-5,5)","v":-3},3,0,-5,3,-3]
["2020-03-30","الاجمالى",null,null,{"$f":"SUM(E$4:E4)","v":3},{"$f":"SUM(F$4:F4)","v":0},{"$f":"SUM(G$4:G4)","v":-5},{"$f":"SUM(H$4:H4)","v":3},{"$f":"SUM(I$4:I4)","v":-3}]
["2020-04-01","ت1",null,null,2,4,2,4,-4]
["2020-04-20","ت2",null,null,3,-3,2,4,-1]
["2020-04-25","ت3",null,null,1,5,0,-1,-4]
["2020-04-28","ت4",null,null,3,1,0,-5,3]
["2020-04-30","الاجمالى",null,null,{"$f":"SUM(E6:E9)","v":9},{"$f":"SUM(F6:F9)","v":7},4,2,-6]
["2020-05-10","ت5",null,null,-1,-4,2,5,-3]
["2020-05-11","ت6",null,null,-1,-1,2,-4,5]
["2020-05-12","ت7",null,null,-3,5,-3,5,2]
["2020-05-20","ت8",null,null,-4,-5,-2,-5,1]
["2020-05-21","ت9",null,null,-1,0,3,-3,-1]
["2020-05-30","الاجمالى",null,null,{"$f":"SUM(E11:E15)","v":-10},{"$f":"SUM(F11:F15)","v":-5},{"$f":"SUM(G11:G15)","v":2},{"$f":"SUM(H11:H15)","v":-2},{"$f":"SUM(I11:I15)","v":4}]

{"sheet":"A (2)","index":6,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["التاريخ",null,null,null,"مخزن1","مخزن2","مخزن3","مخزن4","مخزن5"]
[]
["1900-01-01",0]
["2020-03-22","ت",555,{"$f":"RANDBETWEEN(-5,5)","v":4},3,0,-5,3,-3]
["2020-03-30","الاجمالى",null,null,{"$f":"SUM(E$4:E4)","v":3},{"$f":"SUM(F$4:F4)","v":0},{"$f":"SUM(G$4:G4)","v":-5},{"$f":"SUM(H$4:H4)","v":3},{"$f":"SUM(I$4:I4)","v":-3}]
["2020-04-01","ت1",null,null,2,4,2,4,-4]
["2020-04-20","ت2",null,null,3,-3,2,4,-1]
["2020-04-25","ت3",null,null,1,5,0,-1,-4]
["2020-04-28","ت4",null,null,3,1,0,-5,3]
["2020-04-30","الاجمالى",null,null,{"$f":"SUM(E6:E9)","v":9},{"$f":"SUM(F6:F9)","v":7},4,2,-6]
["2020-05-10","ت5",null,null,-1,-4,2,5,-3]
["2020-05-11","ت6",null,null,-1,-1,2,-4,5]
["2020-05-12","ت7",null,null,-3,5,-3,5,2]
["2020-05-20","ت8",null,null,-4,-5,-2,-5,1]
["2020-05-21","ت9",null,null,-1,0,3,-3,-1]
["2020-05-30","الاجمالى",null,null,{"$f":"SUM(E11:E15)","v":-10},{"$f":"SUM(F11:F15)","v":-5},{"$f":"SUM(G11:G15)","v":2},{"$f":"SUM(H11:H15)","v":-2},{"$f":"SUM(I11:I15)","v":4}]

{"sheet":"A (3)","index":7,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["التاريخ",null,null,null,"مخزن1","مخزن2","مخزن3","مخزن4","مخزن5"]
[]
["1900-01-01",0]
["2020-03-22","ت",555,{"$f":"RANDBETWEEN(-5,5)","v":-4},3,0,-5,3,-3]
["2020-03-30","الاجمالى",null,null,{"$f":"SUM(E$4:E4)","v":3},{"$f":"SUM(F$4:F4)","v":0},{"$f":"SUM(G$4:G4)","v":-5},{"$f":"SUM(H$4:H4)","v":3},{"$f":"SUM(I$4:I4)","v":-3}]
["2020-04-01","ت1",null,null,2,4,2,4,-4]
["2020-04-20","ت2",null,null,3,-3,2,4,-1]
["2020-04-25","ت3",null,null,1,5,0,-1,-4]
["2020-04-28","ت4",null,null,3,1,0,-5,3]
["2020-04-30","الاجمالى",null,null,{"$f":"SUM(E6:E9)","v":9},{"$f":"SUM(F6:F9)","v":7},4,2,-6]
["2020-05-10","ت5",null,null,-1,-4,2,5,-3]
["2020-05-11","ت6",null,null,-1,-1,2,-4,5]
["2020-05-12","ت7",null,null,-3,5,-3,5,2]
["2020-05-20","ت8",null,null,-4,-5,-2,-5,1]
["2020-05-21","ت9",null,null,-1,0,3,-3,-1]
["2020-05-30","الاجمالى",null,null,{"$f":"SUM(E11:E15)","v":-10},{"$f":"SUM(F11:F15)","v":-5},{"$f":"SUM(G11:G15)","v":2},{"$f":"SUM(H11:H15)","v":-2},{"$f":"SUM(I11:I15)","v":4}]

{"sheet":"A (4)","index":8,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["التاريخ",null,null,null,"مخزن1","مخزن2","مخزن3","مخزن4","مخزن5"]
[]
["1900-01-01",0]
["2020-03-22","ت",555,{"$f":"RANDBETWEEN(-5,5)","v":3},3,0,-5,3,-3]
["2020-03-30","الاجمالى",null,null,{"$f":"SUM(E$4:E4)","v":3},{"$f":"SUM(F$4:F4)","v":0},{"$f":"SUM(G$4:G4)","v":-5},{"$f":"SUM(H$4:H4)","v":3},{"$f":"SUM(I$4:I4)","v":-3}]
["2020-04-01","ت1",null,null,2,4,2,4,-4]
["2020-04-20","ت2",null,null,3,-3,2,4,-1]
["2020-04-25","ت3",null,null,1,5,0,-1,-4]
["2020-04-28","ت4",null,null,3,1,0,-5,3]
["2020-04-30","الاجمالى",null,null,{"$f":"SUM(E6:E9)","v":9},{"$f":"SUM(F6:F9)","v":7},4,2,-6]
["2020-05-10","ت5",null,null,-1,-4,2,5,-3]
["2020-05-11","ت6",null,null,-1,-1,2,-4,5]
["2020-05-12","ت7",null,null,-3,5,-3,5,2]
["2020-05-20","ت8",null,null,-4,-5,-2,-5,1]
["2020-05-21","ت9",null,null,-1,0,3,-3,-1]
["2020-05-30","الاجمالى",null,null,{"$f":"SUM(E11:E15)","v":-10},{"$f":"SUM(F11:F15)","v":-5},{"$f":"SUM(G11:G15)","v":2},{"$f":"SUM(H11:H15)","v":-2},{"$f":"SUM(I11:I15)","v":4}]