{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheets1","Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":18,"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":"Sheets1","index":0,"n_rows":78,"n_cols":11,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[]
["Date","Semaine","NOM","TCC","T001","T002","R1","R2","R3"]
["2022-04-15",15,"Ali",55,582.59,300.99,2345,0.35,2.74]
["2022-04-15",15,"Ali",55,584.35,305.05,0.09,0.26,3.04,null,"في الشيت الثاني يتم كتابة الإسم في الخانة C3 وتتم عملية تصفية الأعمدة R1 وR2وR3 تلقائيا على حسب الإسم "]
["2022-04-15",15,"Ali",55,null,null,0.1,0.19,2.73]
["2022-04-15",15,"Ali",55,635.30999999999995,332.81,100,200,300]
["2022-04-15",15,"BADR",55,616.19000000000005,343.99,800,0.35,4.1399999999999997]
["2022-04-15",15,"BADR",55,null,null,140,5,22]
["2022-04-15",15,"BADR",55,662.15,341.06,77,88,100]
["2022-04-15",15,"ALI",55,647.08000000000004,338.65,477,88,23,null,"قد تم عمل الملف  بواسطة الهاتف بنسخة اوفيس 365 حيث تفاجأت لاحقا انه لا يمكنني استخدمها على الجهاز عندي لأن نسخة الاوفيس عندي 2016  "]
["2022-04-15",15,"ALI",55,null,null,69,55,10,null,"المطلوب انشاء معادلة تقوم بنفس الدور لاكن تشتغل على النسخة التي عندي لأنه صعب اغيرها حاليا"]
["2022-04-15",15,"BADR",55,null,null,44,25,12]
["2022-04-15",15,"khalid",55,612.84,323.14,1407,75,11]
["2022-04-15",15,"hicham1470",55,612.20000000000005,321.2,745,47,1123]
["2022-04-15",15,"officena",55,853.27,460.97,25,14,14]
["2022-04-15",15,"tawfik",55,868.43,459.83,800,45,44]
["2022-04-15",15,"khalid",55]
["2022-04-15",15,"ALI",55,883.03,472.73,55,56,96]
["2022-04-15",15,"ALI",55,880.02,463.12,11,22,69]
["2022-04-15",15,"ALI",55,null,null,2,55,25]
["2022-04-15",15,"ALI",55,842.18,473.18,65,88,47]
["2022-04-15",15,"Ali",55,852.16,469.58,0.1,0.19,2.73]
["2022-04-15",15,"Ali",55,null,null,100,200,300]
["2022-04-15",15,"Ali",55,853.07,474.67,0.13,0.35,4.1399999999999997]
["2022-04-15",15,"Ali",55,854.1,473.3,140,5,22]
["2022-04-15",15,"BADR",55,null,null,77,88,100]
["2022-04-14",15,"BADR",55,561.24,294.94,477,88,23]
["2022-04-14",15,"BADR",55,568.05999999999995,297.16000000000003,69,55,10]
["2022-04-14",15,"ALI",55,null,null,44,25,12]
["2022-04-14",15,"ALI",55,null,null,1407,75,11]
["2022-04-14",15,"ALI",55,556.83000000000004,298.8,745,47,1123]
["2022-04-14",15,"BADR",55,605.62,300.19,25,14,14]
["2022-04-14",15,"khalid",55,null,null,45,45,44]
["2022-04-14",15,"khalid",55,542.16,295.11,0.1,0.19,2.73]
["2022-04-14",15,"khalid",55,558.09,289.04000000000002,100,200,300]
["2022-04-14",15,"khalid",55,null,null,0.13,0.35,4.1399999999999997]
["2022-04-14",15,"ALI",55,null,null,140,5,22]
["2022-04-14",15,"ALI",55,null,null,77,88,100]
["2022-04-14",15,"BADR",55,556.83000000000004,308.55,477,88,23]
["2022-04-14",15,"khalid",55,605.62,300.19,69,55,10]
["2022-04-14",15,"hicham1470",55,null,null,44,25,12]
["2022-04-14",15,"officena",55,null,null,1407,75,11]
["2022-04-14",15,"tawfik",55,542.16,295.11,745,47,1123]
["2022-04-14",15,"Ali",55,558.09,311.05,25,14,14]
["2022-04-14",15,"BADR",55,null,null,45,45,44]
["2022-04-14",15,"BADR",55]
["2022-04-14",15,"BADR",55,859.14,450.04,55,56,96]
["2022-04-14",15,"ALI",55,850.87,448.77,0.1,0.19,2.73]
["2022-04-14",15,"ALI",55,null,null,100,200,300]
["2022-04-14",15,"ALI",55,868.01,447.21,0.13,0.35,4.1399999999999997]
["2022-04-14",15,"BADR",55,866.08,450.98,140,5,22]
["2022-04-14",15,"ALI",null,null,null,77,88,100]
["2022-04-14",15,"BADR",null,null,null,477,88,23]
["2022-04-14",15,"khalid",null,null,null,69,55,10]
["2022-04-14",15,"hicham1470",null,null,null,44,25,12]
["2022-04-14",15,"officena",null,null,null,1407,75,11]
["2022-04-14",15,"tawfik",null,null,null,745,47,1123]
["2022-04-14",15,"ALI",null,null,null,25,14,14]
["2022-04-13",15,"ALI",null,null,null,45,45,44]
["2022-04-13",15,"Ali"]
["2022-04-13",15,"Ali",null,null,null,55,56,96]
["2022-04-14",15,"Ali",null,null,null,11,22,69]
["2022-04-15",15,"Ali",null,null,null,0.1,0.19,2.73]
["2022-04-16",15,"BADR",null,null,null,100,200,300]
["2022-04-17",15,"BADR",null,null,null,0.13,0.35,4.1399999999999997]
["2022-04-18",15,"BADR",null,null,null,140,5,22]
["2022-04-19",15,"ALI",null,null,null,77,88,100]
["2022-04-20",15,"ALI",null,null,null,477,88,23]
["2022-04-21",15,"ALI",null,null,null,69,55,10]
["2022-04-22",15,"BADR",null,null,null,44,25,12]
["2022-04-23",15,"khalid",null,null,null,1407,75,11]
["2022-04-24",15,"khalid",null,null,null,745,47,1123]
["2022-04-25",15,"khalid",null,null,null,25,14,14]
["2022-04-26",15,"khalid",null,null,null,45,45,44]
["2022-04-27",15,"ALI"]
["2022-04-28",15,"ALI",null,null,null,55,56,96]
["2022-04-29",15,null,null,null,null,55,56,96]
["2022-04-30",15,null,null,null,null,55,56,96]

{"sheet":"Feuil1","index":1,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Ali"]
[null,"R1","R2","R3"]
[null,{"$f":"_xlfn._xlws.FILTER(Sheets1!G3:G78,Sheets1!C3:C78=C2)","v":2345},{"$f":"_xlfn._xlws.FILTER(Sheets1!H3:H78,Sheets1!C3:C78=C2)","v":0.35},{"$f":"_xlfn._xlws.FILTER(Sheets1!I3:I78,Sheets1!C3:C78=C2)","v":2.74},null,"تصفية الأعمدة التي باللون الأصفر في الشيت 1  بشرط الخلية  C3"]
[null,0.09,0.26,3.04]
[null,0.1,0.19,2.73]
[null,100,200,300]
[null,477,88,23]
[null,69,55,10]
[null,55,56,96]
[null,11,22,69]
[null,2,55,25]
[null,65,88,47]
[null,0.1,0.19,2.73]
[null,100,200,300]
[null,0.13,0.35,4.1399999999999997]
[null,140,5,22]
[null,44,25,12]
[null,1407,75,11]
[null,745,47,1123]
[null,140,5,22]
[null,77,88,100]
[null,25,14,14]
[null,0.1,0.19,2.73]
[null,100,200,300]
[null,0.13,0.35,4.1399999999999997]
[null,77,88,100]
[null,25,14,14]
[null,45,45,44]
[null,0,0,0]
[null,55,56,96]
[null,11,22,69]
[null,0.1,0.19,2.73]
[null,77,88,100]
[null,477,88,23]
[null,69,55,10]
[null,0,0,0]
[null,55,56,96]