{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["مدخلات","طباعة السند"],"not_rendered":{"charts":0,"images":1,"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":5,"n_cols":19,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,1,1,2],[0,3,1,3],[0,5,1,5]]}
[null,"البحث باسم المستلم",null,{"$f":" IFERROR(IF(B2<>\"\",SUMIFS(الجدول1[المبلغ],الجدول1[اسم المستلم],B2),SUM(الجدول1[المبلغ])),\"\")","v":4000},{"$f":"MIN(الجدول1[التاريخ])","v":"2021-12-20"},{"$f":" IFERROR(IF(B2<>\"\",SUMIFS(الجدول1[المبلغ],الجدول1[اسم المستلم],B2,الجدول1[التاريخ],\">=\"&E1,الجدول1[التاريخ],\"<=\"&E2),SUMIFS(الجدول1[المبلغ],الجدول1[التاريخ],\">=\"&E1,الجدول1[التاريخ],\"<=\"&E2)),\"\")","v":4000}]
[null,null,null,null,{"$f":"MAX(الجدول1[التاريخ])","v":"2021-12-20"},null,null,null,null,null,null,null,null,null,null,null,null,null,"⩗"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"شيك"]
[null,"رقم السند","التاريخ","المبلغ","اسم المستلم","رقم الهوية","وذلك مقابل","الحركة","رقم الحوالة/شيك","المستلم","اسم المحاسب"]
[null,1,"2021-12-20",4000,"محمد السيد",2454588942,"اعمال مزنمني","⩗",123,"فوزي","يزن القرش"]

{"sheet":"طباعة السند","index":1,"n_rows":45,"n_cols":18,"rows_kept":45,"cut":false,"hidden":false,"merged":[[43,1,43,14],[33,1,33,2],[33,9,33,11],[33,12,33,14],[34,12,34,14],[35,1,35,3],[35,5,35,6],[36,13,36,14],[37,13,37,14],[39,10,39,14],[40,1,40,14],[37,3,37,10],[39,3,39,7],[39,8,39,9],[42,3,42,14],[32,0,32,15],[21,13,21,14],[23,10,23,14],[24,1,24,14],[27,1,27,14],[23,3,23,7],[23,8,23,9],[26,1,26,2],[28,1,28,2],[28,3,28,5],[28,10,28,11],[28,12,28,14],[21,3,21,10],[0,0,0,15],[11,1,11,14],[1,1,1,2],[1,9,1,11],[1,12,1,14],[2,12,2,14],[3,1,3,3],[3,5,3,6],[4,13,4,14],[7,8,7,9],[7,10,7,14],[8,1,8,14],[5,3,5,10],[7,3,7,7],[10,1,10,2],[5,12,5,14],[10,3,10,14],[18,12,18,14],[16,0,16,15],[17,1,17,2],[17,9,17,11],[17,12,17,14],[44,1,44,2],[44,3,44,5],[44,10,44,11],[44,12,44,14],[6,12,6,14],[22,12,22,14],[38,12,38,14],[42,1,42,2],[26,3,26,14],[12,1,12,2],[12,3,12,5],[12,10,12,11],[12,12,12,14],[19,1,19,3],[19,5,19,6],[20,13,20,14]]}
["سند صرف"]
[null,"التاريخ",null,{"$f":"IFERROR(IF(M2<>\"\",VLOOKUP(M2,الجدول1[],2,0),\"\"),\"\")","v":"2021-12-20"},null,null,null,null,null,"رقم السند",null,null,1,null,null,null,null,"Blue"]
[]
[null,"تم صرف مبلغ",null,null,null,{"$f":"IFERROR(IF(M2<>\"\",VLOOKUP(M2,الجدول1[],3,0),\"\"),\"\")","v":4000},null,null,null,null,null,null,"نقدي",{"$f":"IFERROR(IF(M2<>\"\",VLOOKUP(\"⩗\",الجدول1[الحركة],1,0),\"\"),\"\")","v":"⩗"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"شيك رقم",{"$f":"IFERROR(IF(M2<>\"\",IF(VLOOKUP(\"شيك\",مدخلات!H:H,1,0)=\"شيك\",VLOOKUP(M2,الجدول1[],8,0)),\"\"),\"\")","v":""}]
[null,"مبلغ وقدرة:",null,{"$f":"NumberToText(F4,\"ريال\",\"هللة\")","v":"أربعة ألاف ريال"},null,null,null,null,null,null,null,null,"حوالة رقم"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(M2<>\"\",IF(VLOOKUP(\"حوالة\",مدخلات!H:H,1,0)=\"حوالة\",VLOOKUP(M2,الجدول1[],8,0)),\"\"),\"\")","v":""}]
[null,"الى المكرم:",null,{"$f":"IFERROR(IF(M2<>\"\",VLOOKUP(M2,الجدول1[],4,0),\"\"),\"\")","v":"محمد السيد"},null,null,null,null,"رقم هوية:",null,{"$f":"IFERROR(IF(M2<>\"\",VLOOKUP(M2,الجدول1[],5,0),\"\"),\"\")","v":2454588942}]
[]
[]
[null,"وذلك مقابل",null,{"$f":"IFERROR(IF(M2<>\"\",VLOOKUP(M2,الجدول1[],6,0),\"\"),\"\")","v":"اعمال مزنمني"}]
[]
[null,"اسم المستلم",null,{"$f":"IFERROR(IF(M2<>\"\",VLOOKUP(M2,الجدول1[],9,0),\"\"),\"\")","v":"فوزي"},null,null,null,null,null,null,"اسم المحاسب",null,{"$f":"IFERROR(IF(M2<>\"\",VLOOKUP(M2,الجدول1[],10,0),\"\"),\"\")","v":"يزن القرش"}]
[]
[]
[]
["سند صرف"]
[null,"التاريخ",null,{"$f":"IFERROR(IF(D2<>\"\",D2,\"\"),\"\")","v":"2021-12-20"},null,null,null,null,null,"رقم السند",null,null,{"$f":"IFERROR(IF(M2<>\"\",M2,\"\"),\"\")","v":1},null,null,null,null,"Blue"]
[]
[null,"تم صرف مبلغ",null,null,null,{"$f":"IFERROR(IF(F4<>\"\",F4,\"\"),\"\")","v":4000},null,null,null,null,null,null,"نقدي",{"$f":"IFERROR(IF(N4<>\"\",N4,\"\"),\"\")","v":"⩗"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"شيك رقم",{"$f":"IFERROR(IF(N5<>\"\",N5,\"\"),\"\")","v":""}]
[null,"مبلغ وقدرة:",null,{"$f":"NumberToText(F4,\"ريال\",\"هللة\")","v":"أربعة ألاف ريال"},null,null,null,null,null,null,null,null,"حوالة رقم"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(M7<>\"\",M7,\"\"),\"\")","v":""}]
[null,"الى المكرم:",null,{"$f":"IFERROR(IF(D8<>\"\",D8,\"\"),\"\")","v":"محمد السيد"},null,null,null,null,"رقم هوية:",null,{"$f":"IFERROR(IF(K8<>\"\",K8,\"\"),\"\")","v":2454588942}]
[]
[]
[null,"وذلك مقابل",null,{"$f":"IFERROR(IF(D11<>\"\",D11,\"\"),\"\")","v":"اعمال مزنمني"}]
[]
[null,"اسم المستلم",null,{"$f":"IFERROR(IF(D13<>\"\",D13,\"\"),\"\")","v":"فوزي"},null,null,null,null,null,null,"اسم المحاسب",null,{"$f":"IFERROR(IF(M13<>\"\",M13,\"\"),\"\")","v":"يزن القرش"}]
[]
[]
[]
["سند صرف"]
[null,"التاريخ",null,{"$f":"IFERROR(IF(D18<>\"\",D18,\"\"),\"\")","v":"2021-12-20"},null,null,null,null,null,"رقم السند",null,null,{"$f":"IFERROR(IF(M18<>\"\",M18,\"\"),\"\")","v":1},null,null,null,null,"Blue"]
[]
[null,"تم صرف مبلغ",null,null,null,{"$f":"IFERROR(IF(F20<>\"\",F20,\"\"),\"\")","v":4000},null,null,null,null,null,null,"نقدي",{"$f":"IFERROR(IF(N20<>\"\",N20,\"\"),\"\")","v":"⩗"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"شيك رقم",{"$f":"IFERROR(IF(N21<>\"\",N21,\"\"),\"\")","v":""}]
[null,"مبلغ وقدرة:",null,{"$f":"NumberToText(F4,\"ريال\",\"هللة\")","v":"أربعة ألاف ريال"},null,null,null,null,null,null,null,null,"حوالة رقم"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(M23<>\"\",M23,\"\"),\"\")","v":""}]
[null,"الى المكرم:",null,{"$f":"IFERROR(IF(D24<>\"\",D24,\"\"),\"\")","v":"محمد السيد"},null,null,null,null,"رقم هوية:",null,{"$f":"IFERROR(IF(K24<>\"\",K24,\"\"),\"\")","v":2454588942}]
[]
[]
[null,"وذلك مقابل",null,{"$f":"IFERROR(IF(D27<>\"\",D27,\"\"),\"\")","v":"اعمال مزنمني"}]
[]
[null,"اسم المستلم",null,{"$f":"IFERROR(IF(D29<>\"\",D29,\"\"),\"\")","v":"فوزي"},null,null,null,null,null,null,"اسم المحاسب",null,{"$f":"IFERROR(IF(M29<>\"\",M29,\"\"),\"\")","v":"يزن القرش"}]