{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["سند قبض","عام","بيان بالاشتراكات المستحقه","حساب تفصيلى لمشترك","الرئيسيه","ماكرو1","العملاء","تقرير"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":9,"rows_kept":57,"cut":false,"hidden":false,"merged":[[9,6,9,7],[10,6,10,7],[11,6,11,7],[12,0,12,1],[3,4,3,5],[6,0,6,5],[24,0,24,1],[25,0,25,2],[26,1,26,4],[27,1,27,2],[27,3,27,5],[14,1,14,4],[15,1,15,2],[15,3,15,5],[16,2,16,5],[17,1,17,5],[28,2,28,5],[13,0,13,2],[49,2,49,4],[5,1,5,5],[0,0,0,1],[2,1,2,2],[4,2,4,5],[40,2,40,5],[41,1,41,5],[29,1,29,5],[36,0,36,1],[37,0,37,2],[38,1,38,4],[39,1,39,2],[39,3,39,5],[3,1,3,3]]}
["شركةالنورلخدمات الكمبيوتروالانترنت",null,null,{"$f":"MAX(عام!V1:V99995)","v":0},"التاريخ :",{"$f":"NOW()","v":"2022-01-07T21:44:53.830"}]
["التاريخ /",null,null,"سند قبض نقدى",{"$f":"MAX(عام!L3:L100002)+1","v":12},{"$f":"MAX(عام!L2:L99995)+1","v":12}]
["اسـتلـمنا نحن /","شركةالنورلخدمات الكمبيوتروالانترنت",null,"خزينة الادارة"]
["من  السيد/","عماد محفوظ محمود محفوظ",null,null,null,null,"طباعه سند قبض"]
["   مبلغ وقدرة /  ",{"$f":"IFERROR(VLOOKUP(B4,العملاء!B4:I10000,6,0),0)","v":0},{"$f":"tafket(B5,\"جنيه\",\"قرش\")","v":"ÕÝÑ"}]
["وذلك قيمة    /"]
["بيانات العميل"]
["اسم العميل","الرقم الارضى","رقم المحمول","نوع الخدمه المقدمه","تاريخ بداية الخدمه","تاريخ انتهاء الخدمه"]
[{"$f":"B4","v":"عماد محفوظ محمود محفوظ"},{"$f":"IFERROR(VLOOKUP(A9,العملاء!B4:I10000,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A9,العملاء!B4:I10000,3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A9,العملاء!B4:I10000,4,0),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(تقرير!C3:C1000,B4)=1,VLOOKUP(B4,تقرير!C3:H10000,6,0),VLOOKUP(A9,العملاء!B4:I10000,7,0)),\"\")","v":""},{"$f":"IF(E9=\"\",\"\",E9+30)","v":""}]
[null,null,null,null,"المستلم /"]
[null,null,null,null,"التوقيع /"]
[null,null,null,null,null,"اصل"]
[{"$f":"A1","v":"شركةالنورلخدمات الكمبيوتروالانترنت"},null,null,null,"التاريخ :",{"$f":"B2","v":"00:00:00"}]
[null,null,null,{"$f":"D2","v":"سند قبض نقدى"},{"$f":"E2","v":12}]
[{"$f":"A3","v":"اسـتلـمنا نحن /"},{"$f":"B3","v":"شركةالنورلخدمات الكمبيوتروالانترنت"}]
["من  الساده  / ",{"$f":"B4","v":"عماد محفوظ محمود محفوظ"}]
[{"$f":"A5","v":"   مبلغ وقدرة /  "},{"$f":"B5","v":0},{"$f":"C5","v":"ÕÝÑ"}]
["وذلك قيمة         /",{"$f":"B6","v":0}]
[{"$f":"A7","v":"بيانات العميل"}]
["اسم العميل","الرقم الارضى","رقم المحمول","نوع الخدمه المقدمه","تاريخ بداية الخدمه","تاريخ انتهاء الخدمه"]
[{"$f":"A9","v":"عماد محفوظ محمود محفوظ"},{"$f":"B9","v":""},"","","",""]
[]
[null,null,null,null,"المستلم /"]
[null,null,null,null,"التوقيع /","أصل"]
[{"$f":"A1","v":"شركةالنورلخدمات الكمبيوتروالانترنت"},null,null,null,"التاريخ :",{"$f":"B2","v":"00:00:00"}]
[null,null,null,{"$f":"D14","v":"سند قبض نقدى"},{"$f":"E2","v":12}]
[{"$f":"A3","v":"اسـتلـمنا نحن /"},"شركةالنورلخدمات الكمبيوتروالانترنت"]
["من  السيد/","عماد محفوظ محمود محفوظ"]
["   مبلغ وقدرة /  ",0,{"$f":"C5","v":"ÕÝÑ"}]
["وذلك قيمة    /",0]
[{"$f":"A19","v":"بيانات العميل"}]
["اسم العميل","الرقم الارضى","رقم المحمول","نوع الخدمه المقدمه","تاريخ بداية الخدمه","تاريخ انتهاء الخدمه"]
[{"$f":"A9","v":"عماد محفوظ محمود محفوظ"},{"$f":"B9","v":""},"","","",""]
[]
[null,null,null,null,"المستلم /"]
[null,null,null,null,"التوقيع /","صوره1"]
[{"$f":"A1","v":"شركةالنورلخدمات الكمبيوتروالانترنت"},null,null,null,"التاريخ :",{"$f":"B2","v":"00:00:00"}]
[null,null,null,{"$f":"D26","v":"سند قبض نقدى"},{"$f":"E2","v":12}]
[{"$f":"A15","v":"اسـتلـمنا نحن /"},{"$f":"B3","v":"شركةالنورلخدمات الكمبيوتروالانترنت"}]
[{"$f":"A16","v":"من  الساده  / "},{"$f":"B4","v":"عماد محفوظ محمود محفوظ"}]
[{"$f":"A17","v":"   مبلغ وقدرة /  "},{"$f":"B5","v":0},{"$f":"C5","v":"ÕÝÑ"}]
[{"$f":"A18","v":"وذلك قيمة         /"},{"$f":"B6","v":0}]
[{"$f":"A31","v":"بيانات العميل"}]
["اسم العميل","الرقم الارضى","رقم المحمول","نوع الخدمه المقدمه","تاريخ بداية الخدمه","تاريخ انتهاء الخدمه"]
[{"$f":"A9","v":"عماد محفوظ محمود محفوظ"},{"$f":"B9","v":""},"","","",""]
[]
[null,null,null,null,"المستلم /"]
[null,null,null,null,"التوقيع /","صورة"]
[]
[" قبض نقدى رقم",{"$f":"E2","v":12},{"$f":"A1","v":"شركةالنورلخدمات الكمبيوتروالانترنت"}]
["التاريخ",{"$f":"B2","v":"00:00:00"}]
["التاريخ","رقم القيد","نوع الحساب","اسم الحساب","تاريخ بداية الخدمه","تاريخ انتهاء الخدمه","مدين","دائن"]
[{"$f":"B51","v":"00:00:00"},{"$f":"CONCATENATE($A$50,$B$50)","v":" قبض نقدى رقم12"},"الصناديق",{"$f":"D3","v":"خزينة الادارة"},null,null,{"$f":"B5","v":0},null,{"$f":"E2","v":12}]
[{"$f":"B51","v":"00:00:00"},{"$f":"CONCATENATE($A$50,$B$50)","v":" قبض نقدى رقم12"},"العملاء",{"$f":"B4","v":"عماد محفوظ محمود محفوظ"},{"$f":"E9","v":""},{"$f":"F9","v":""},null,{"$f":"B5","v":0},{"$f":"E2","v":12}]
[null,null,null,null,null,"الاجمالى",{"$f":"G53","v":0},{"$f":"H54","v":0}]
[]
[null,null,null,null,null,"المحاسب"]

{"sheet":"عام","index":1,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"التاريخ","رقم القيد","نوع الحساب","اسم الحساب","تاريخ بداية الخدمه","تاريخ انتهاء الخدمه","مدين","دائن","مسلسل"]
[null,null,null,"2014-12-17"," قبض نقدى رقم1","الصناديق","خزينة الادارة",null,null,100,null,1]
[null,null,null,"2014-12-17"," قبض نقدى رقم1","العملاء","عبد الله سيد عبد الحليم حسين رزق ","2014-12-01","2014-12-31",null,100,1]
[null,null,null,"2014-12-17"," قبض نقدى رقم2","الصناديق","خزينة الادارة",null,null,95,null,2]
[null,null,null,"2014-12-17"," قبض نقدى رقم2","العملاء","تمام سيد احمد حسن ","2014-12-02","2015-01-01",null,95,2]
[null,null,null,"2014-12-17"," قبض نقدى رقم3","الصناديق","خزينة الادارة",null,null,145,null,3]
[null,null,null,"2014-12-17"," قبض نقدى رقم3","العملاء","كريمه امين عبد الخالق عبد البر","2014-11-30","2014-12-30",null,145,3]
[null,null,null,"2014-12-18"," قبض نقدى رقم4","الصناديق","خزينة الادارة",null,null,110,null,4]
[null,null,null,"2014-12-18"," قبض نقدى رقم4","العملاء","احمد امين محمد امين","2014-12-11","2015-01-10",null,110,4]
[null,null,null,"2014-12-18"," قبض نقدى رقم5","الصناديق","خزينة الادارة",null,null,72,null,5]
[null,null,null,"2014-12-18"," قبض نقدى رقم5","العملاء","محمد الخشن","2014-12-02","2015-01-01",null,72,5]
[null,null,null,"2014-12-18"," قبض نقدى رقم6","الصناديق","خزينة الادارة",null,null,73,null,6]
[null,null,null,"2014-12-18"," قبض نقدى رقم6","العملاء","احمد محمد رشاد ابراهيم ","2014-11-30","2014-12-30",null,73,6]
[null,null,null,"2014-12-18"," قبض نقدى رقم7","الصناديق","خزينة الادارة",null,null,145,null,7]
[null,null,null,"2014-12-18"," قبض نقدى رقم7","العملاء","ياسرمحمد جاد المولي","2014-12-04","2015-01-03",null,145,7]
[null,null,null,"2014-12-18"," قبض نقدى رقم8","الصناديق","خزينة الادارة",null,null,140,null,8]
[null,null,null,"2014-12-18"," قبض نقدى رقم8","العملاء","علاء محمد ياسين معبد ","2014-12-07","2015-01-06",null,140,8]
[null,null,null,"2014-12-18"," قبض نقدى رقم9","الصناديق","خزينة الادارة",null,null,110,null,9]
[null,null,null,"2014-12-18"," قبض نقدى رقم9","العملاء","محمد سيد سيد","2014-11-07","2014-12-07",null,110,9]
[null,null,null,"2014-12-18"," قبض نقدى رقم10","الصناديق","خزينة الادارة",null,null,145,null,10]
[null,null,null,"2014-12-18"," قبض نقدى رقم10","العملاء","عبدالعزيز ابراهيم احمد سلامة ","2014-12-02","2015-01-01",null,145,10]
[null,null,null,"2014-12-19"," قبض نقدى رقم11","الصناديق","خزينة الادارة",null,null,100,null,11]
[null,null,null,"2014-12-19"," قبض نقدى رقم11","العملاء","محمد عيد محمد فيصل ","2014-12-19","2015-01-18",null,100,11]

{"sheet":"بيان بالاشتراكات المستحقه","index":2,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,5,1,8],[2,5,2,12],[0,5,0,12]]}
[]
[null,null,null,null,null,"شركة النور لخدمات النت",null,null,null,"التاريخ /",null,{"$f":"NOW()","v":"2022-01-07T21:44:53.830"}]
[null,null,null,null,null,"بيان بالاشتراكات المستحقه"]
[null,null,null,null,null,null,null,null,"حتى تاريخ","2015-01-20"]
[]
[null,null,null,null,null,"م","اسم المشترك","الرقم الارضى","رقم المحمول","نوع الخدمه",null,"تاريخ انتهاء الخدمه","قيمة الاشتراك"]
[null,"2014-04-04","قبض نقدى رقم1","الصناديق","صندوق رقم 5",1,"عبد الله سيد عبد الحليم حسين رزق ","0238627177-Syed",1002491550,"ADSL4M",null,"2014-12-31",{"$f":"IFERROR(VLOOKUP(G7,العملاء!B3:H10000,6,0),\"\")","v":""}]
[null,null,null,null,null,2,"تمام سيد احمد حسن ","0238620616-Tammam ",1278804664,"ADSL512",null,"2015-01-01",{"$f":"IFERROR(VLOOKUP(G8,العملاء!B4:H10001,6,0),\"\")","v":""}]
[null,null,null,null,null,3,"كريمه امين عبد الخالق عبد البر","0238624839-Karima",1098921911,"ADSL1M",null,"2014-12-30",{"$f":"IFERROR(VLOOKUP(G9,العملاء!B5:H10002,6,0),\"\")","v":""}]
[null,null,null,null,null,4,"احمد امين محمد امين","0238017044-Ahmed ",1001228392,"ADSL1M",null,"2015-01-10",{"$f":"IFERROR(VLOOKUP(G10,العملاء!B6:H10003,6,0),\"\")","v":""}]
[null,null,null,null,null,5,"محمد الخشن","0238620012-elnour",1140680152,"ADSL512",null,"2015-01-01",{"$f":"IFERROR(VLOOKUP(G11,العملاء!B7:H10004,6,0),\"\")","v":""}]
[null,null,null,null,null,6,"احمد محمد رشاد ابراهيم ","0238624364-Ahmed ",1228083559,"ADSL",null,"2014-12-30",{"$f":"IFERROR(VLOOKUP(G12,العملاء!B8:H10005,6,0),\"\")","v":""}]
[null,null,null,null,null,7,"ياسرمحمد جاد المولي","0238622146-Yasser",1228535990,"ADSL1M",null,"2015-01-03",{"$f":"IFERROR(VLOOKUP(G13,العملاء!B9:H10006,6,0),\"\")","v":""}]
[null,null,null,null,null,8,"علاء محمد ياسين معبد ","0238625000-Alaa ",1159159411,"ADSL1M",null,"2015-01-06",{"$f":"IFERROR(VLOOKUP(G14,العملاء!B10:H10007,6,0),\"\")","v":""}]
[null,null,null,null,null,9,"محمد سيد سيد",38620701,0,"adsl1m",null,"2014-12-07",{"$f":"IFERROR(VLOOKUP(G15,العملاء!B11:H10008,6,0),\"\")","v":""}]
[null,null,null,null,null,10,"عبدالعزيز ابراهيم احمد سلامة ","0238620736-Abd",1153853187,"ADSL1M",null,"2015-01-01",{"$f":"IFERROR(VLOOKUP(G16,العملاء!B12:H10009,6,0),\"\")","v":""}]

{"sheet":"حساب تفصيلى لمشترك","index":3,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,5,0,11],[2,5,2,11],[1,5,1,8],[8,5,8,11],[5,5,6,5]]}
[]
[null,null,null,null,null,"شركةالنورلخدمات الكمبيوتروالانترنت",null,null,null,"التاريخ /",null,{"$f":"NOW()","v":"2022-01-07T21:44:53.830"}]
[null,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":"IFERROR(VLOOKUP(J4,العملاء!B4:I10000,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J4,العملاء!B4:I10000,3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J4,العملاء!B4:I10000,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J4,العملاء!B4:I10000,5,0),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(J4,العملاء!B4:I10000,6,0),\"\")","v":""}]
[]
[null,null,null,null,null,"ثانيا: - بيان الدفعات"]
[null,null,null,null,null,"م","التاريخ","رقم سند القبض","تاريخ بداية الخدمه","تاريخ انتهاء الخدمه",null,"المبلغ"]
[null,"2014-04-04","قبض نقدى رقم1","الصناديق","صندوق رقم 5",1,"2014-12-19"," قبض نقدى رقم11","2014-12-19","2015-01-18",null,100]

{"sheet":"الرئيسيه","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[0,0,8,7]]}

{"sheet":"ماكرو1","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"العملاء","index":6,"n_rows":573,"n_cols":16,"rows_kept":573,"cut":false,"hidden":false,"merged":[[0,1,0,8]]}
["pktd","شاشة اضافه مشترك جديد"]
[null,"اسم العميل","اسم المدرسه التابع لها","نوع الخدمه","رقم العميل","تاريخ التعاقد","قيمة الاشتراك","تاريخ بدء الخدمه","ملاحظات",null,null,null,null,null,null,"العملاء"]
[null,"ا","ا","ا","ا","ا","ا","ا","ا"]
[]
[]
[]
[]
[]
[null,10,10,"01",10,"2022-01-01",50,"22/12/2022"]
[]
[]
[]
["محمد"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,0,"ن","ن","ن","ن",30,"ن"]

{"sheet":"تقرير","index":7,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":true,"merged":[[0,2,0,7]]}
[null,null,"تقرير عن فترة خدمه كل مشترك"]
[null,null,"اسم المشترك","الرقم الارضى","رقم المحمول","نوع الخدمه المقدمه","تاريخ بداية الخدمه","تاريخ انتهاء الخدمه"]
[null,null,"عبد الله سيد عبد الحليم حسين رزق ","0238627177-Syed","01002491550","ADSL4M","2014-12-01","2014-12-31"]
[null,null,"تمام سيد احمد حسن ","0238620616-Tammam ","01278804664","ADSL512","2014-12-02","2015-01-01"]
[null,null,"كريمه امين عبد الخالق عبد البر","0238624839-Karima","01098921911","ADSL1M","2014-11-30","2014-12-30"]
[null,null,"احمد امين محمد امين","0238017044-Ahmed ","01001228392","ADSL1M","2014-12-11","2015-01-10"]
[null,null,"محمد الخشن","0238620012-elnour","01140680152","ADSL512","2014-12-02","2015-01-01",1]
[null,null,"احمد محمد رشاد ابراهيم ","0238624364-Ahmed ","01228083559","ADSL","2014-11-30","2014-12-30",1]
[null,null,"ياسرمحمد جاد المولي","0238622146-Yasser","01228535990","ADSL1M","2014-12-04","2015-01-03",1]
[null,null,"علاء محمد ياسين معبد ","0238625000-Alaa ","01159159411","ADSL1M","2014-12-07","2015-01-06",1]
[null,null,"محمد سيد سيد","38620701",0,"adsl1m","2014-11-07","2014-12-07",1]
[null,null,"عبدالعزيز ابراهيم احمد سلامة ","0238620736-Abd","01153853187","ADSL1M","2014-12-02","2015-01-01",1]
[null,null,"محمد عيد محمد فيصل ","0238627511-Mohamed","01145295264","adsl512","2014-12-19","2015-01-18",1]
[null,null,null,null,null,null,null,null,1]