{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["البحث","المبيعات","المشتريات","الموردين","العمليات"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"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":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,6,5,6],[6,6,10,6],[11,6,15,6]]}
[]
[{"$f":"INDEX(sheetformula,sheetnamber)","v":"الموردين"},"حلمى",{"$f":"HYPERLINK(\"#'\"&A2&\"'!\"&ADDRESS(MATCH($B$2,INDIRECT(\"'\"&$A$2&\"'!\"&\"b1:b11\"),0),2),\"انتقل إلى \" & B2)","v":"انتقل إلى حلمى"},null,"هنا ارتباط تشعبى",null,"المبيعات","احمد"]
[null,null,null,null,"ينقلك الى الاسم الذى",null,null,"محمد"]
["م","الاسم","العنوان","الاجمالى","تبحث عنه",null,null,"محمود"]
[{"$f":"INDEX(INDIRECT(\"'\"&$A$2&\"'!\"&\"a3:d11\"),MATCH($B$2,INDIRECT(\"'\"&$A$2&\"'!\"&\"b3:b11\"),0),MATCH(A$4,INDIRECT(\"'\"&$A$2&\"'!\"&\"a2:d2\"),0))","v":1},{"$f":"INDEX(INDIRECT(\"'\"&$A$2&\"'!\"&\"a3:d11\"),MATCH($B$2,INDIRECT(\"'\"&$A$2&\"'!\"&\"b3:b11\"),0),MATCH(B$4,INDIRECT(\"'\"&$A$2&\"'!\"&\"a2:d2\"),0))","v":"حلمى"},"ميت السباع",30,null,null,null,"وجدى"]
[null,null,null,null,null,null,null,"حماد"]
[null,null,null,null,null,null,"المشتريات","حامد"]
[null,null,null,null,null,null,null,"إيهاب"]
[null,null,null,null,null,null,null,"حسام"]
[null,null,null,null,null,null,null,"حازم"]
[null,null,null,null,null,null,null,"مامون"]
[null,null,null,null,null,null,"الموردين","حلمى"]
[null,"اختر الاسم من القائمة المنسدلة في خلية  B2",null,null,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":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
[{"$f":"\"كشف حساب  \" & \" : \"   &  MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1),1)+1,100)","v":"كشف حساب   : المبيعات"},null,null,"المجموع",{"$f":"SUM(D3:D7)","v":75}]
["م","الاسم","العنوان","الاجمالى"]
[1,"احمد","مرصفا",5]
[2,"محمد","الشموت",10]
[3,"محمود","ميت كنانه",15]
[4,"وجدى","عرب الروشده",20]
[5,"حماد","الشيخ سالمه",25]

{"sheet":"المشتريات","index":2,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
[{"$f":"\"كشف حساب  \" & \" : \"   &  MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1),1)+1,100)","v":"كشف حساب   : المشتريات"},null,null,"المجموع",{"$f":"SUM(D3:D7)","v":150}]
["م","الاسم","العنوان","الاجمالى"]
[1,"حامد","بنها",20]
[2,"إيهاب","طوخ",25]
[3,"حسام","أبو حبيشى",30]
[4,"حازم","كفر العرب",35]
[5,"مامون","كفر الشموت",40]

{"sheet":"الموردين","index":3,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
[{"$f":"\"كشف حساب  \" & \" : \"   &  MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1),1)+1,100)","v":"كشف حساب   : الموردين"},null,null,"المجموع",{"$f":"SUM(D3:D7)","v":200}]
["م","الاسم","العنوان","الاجمالى"]
[1,"حلمى","ميت السباع",30]
[2,"رافت","نقباس",35]
[3,"مجدى","شبلنجه",40]
[4,"سلامه","ميت الحوفين",45]
[5,"كريم","منيا القمح",50]

{"sheet":"العمليات","index":4,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["أسماء الصفحات",null,null,null,null,"المبيعات","احمد"]
[{"$f":"IFERROR(INDEX(sheetswork,ROW()),\"\")","v":"المبيعات"},null,"REPLACE(get.workbook(1+0*NOW());1;FIND(\"]\";get.workbook(1+0*NOW()));\"\")",null,null,null,"محمد"]
["المشتريات",null,"$A$2:INDEX($A$2:$A$10;COUNTIF($A$2:$A$10;\"?*\"))",null,null,null,"محمود"]
["الموردين",null,"SUMPRODUCT(COUNTIFS(INDIRECT(\"'\"&sheetformula&\"'!\"&\"b3:b11\");البحث!$B$2)*ROW(INDIRECT(\"1:\"&COUNTA(sheetformula))))",null,null,null,"وجدى"]
["العمليات",null,null,null,null,null,"حماد"]
["",null,null,null,null,"المشتريات","حامد"]
["",null,null,null,null,null,"إيهاب"]
["",null,null,null,null,null,"حسام"]
["",null,null,null,null,null,"حازم"]
["",null,null,null,null,null,"مامون"]
[null,null,null,null,null,"الموردين","حلمى"]
[null,null,null,null,null,null,"رافت"]
[null,null,null,null,null,null,"مجدى"]
[null,null,null,null,null,null,"سلامه"]
[null,null,null,null,null,null,"كريم"]