{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":[" "],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":64,"n_cols":33,"rows_kept":64,"cut":false,"hidden":false,"merged":[[9,11,9,12],[10,10,10,12],[38,9,44,9],[38,16,44,16],[30,14,36,14],[38,14,44,14],[30,16,36,16],[1,7,1,9],[12,16,20,16],[22,14,28,14],[22,16,28,16],[12,14,20,14],[22,9,28,9],[7,16,10,16],[2,11,2,12],[2,14,5,14],[3,11,3,12],[4,11,4,12],[5,11,5,12],[2,16,5,16],[7,14,10,14],[7,11,7,12],[8,11,8,12]]}
[]
[null,8,"اليوم",{"$f":"NOW()","v":"2020-06-20T09:10:36.700"},8,"مقبوضات",{"$f":"SUBTOTAL(109,الجدول1[المقبوضات])","v":0},"رمز العملة",null,null,"تبديل العملة",null,null,null,null,null,null,null,"الرقم","الدولة","العملة","أجزاء العملة","فئة1","فئة2","فئة3","فئة4","فئة5","فئة6","فئة7","فئة8","فئة9","مساعد","رمز العملة"]
[null,null,null,null,null,null,null,"العملة الأولى:",{"$f":"LEFT(K3,1)*1","v":1},{"$f":"VLOOKUP($I$3,العملة[],15,0)","v":"LBP"},"1-لبنان",{"$f":"SUM($Q$13,$Q$23)","v":0},null,null,"مجموع العملتين",null,"سعر الصرف",null,1,"لبنان","ليرة لبنانية","قرش",100000,50000,20000,10000,5000,1000,500,250,null,{"$f":"IF(العملة[[#This Row],[الدولة]]<>\"\",العملة[[#This Row],[الرقم]]&\"-\"&العملة[[#This Row],[الدولة]],\"\")","v":"1-لبنان"},"LBP"]
[null,9,"التاريخ",{"$f":"NOW()","v":"2020-06-20T09:10:36.700"},null,"مصروفات",{"$f":"SUBTOTAL(109,الجدول1[المدفوعات])","v":0},"العملة الثانية:",{"$f":"LEFT(K4,1)*1","v":5},{"$f":"VLOOKUP($I$4,العملة[],15,0)","v":"USD"},"5-أمريكا",{"$f":"SUM($Q$31,$Q$39)","v":0},null,null,null,null,null,null,2,"سورية","ليرة سورية","قرش",2000,1000,500,200,100,50,25,5,1,{"$f":"IF(العملة[[#This Row],[الدولة]]<>\"\",العملة[[#This Row],[الرقم]]&\"-\"&العملة[[#This Row],[الدولة]],\"\")","v":"2-سورية"},"SP"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"مجموع العملتين / \"&VLOOKUP($I$3,العملة[],15,0)","v":"مجموع العملتين / LBP"},{"$f":"IF($Q$12=\"\",($L$4*$Q$8)+$L$3,($L$4/$Q$8)+$L$3)","v":0},null,null,null,null,null,null,3,"اليمن","ريال يمني","فلس",1000,500,250,200,100,50,null,null,null,{"$f":"IF(العملة[[#This Row],[الدولة]]<>\"\",العملة[[#This Row],[الرقم]]&\"-\"&العملة[[#This Row],[الدولة]],\"\")","v":"3-اليمن"},"YER"]
[null,null,null,null,null,"الرصيد",{"$f":"G2-G4","v":0},{"$f":"IF($C$9<>\"\",IF($Q$12=\"\",$G$6/$Q$8,$G$6*$Q$8),\"\")","v":""},null,null,{"$f":"\"مجموع العملتين / \"&VLOOKUP(I4,العملة[],15,0)","v":"مجموع العملتين / USD"},{"$f":"IF($Q$12=\"\",($L$3/$Q$8)+$L$4,($L$3*$Q$8)+$L$4)","v":0},null,null,null,null,null,null,4,"السعودية","ريال سعودي","هلله",500,100,50,10,5,2,1,null,null,{"$f":"IF(العملة[[#This Row],[الدولة]]<>\"\",العملة[[#This Row],[الرقم]]&\"-\"&العملة[[#This Row],[الدولة]],\"\")","v":"4-السعودية"},"SAR"]
[null,{"$f":"IFERROR(NoToTxt(G6,VLOOKUP($I$3,العملة[],3,0),VLOOKUP($I$3,العملة[],4,0))&\" يعادل \"&NoToTxt($H$6,VLOOKUP($I$4,العملة[],3,0),VLOOKUP($I$4,العملة[],4,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"أمريكا","دولار أمريكي","سنت",100,50,20,10,5,1,null,null,null,{"$f":"IF(العملة[[#This Row],[الدولة]]<>\"\",العملة[[#This Row],[الرقم]]&\"-\"&العملة[[#This Row],[الدولة]],\"\")","v":"5-أمريكا"},"USD"]
[null,"الرقم","التاريخ والوقت","الاسم","البيان","المدفوعات","المقبوضات","الرصيد",null,null,{"$f":"\"رصيد المقبوضات / \"&VLOOKUP(I3,العملة[],15,0)","v":"رصيد المقبوضات / LBP"},{"$f":"$G$6","v":0},null,null,"الموازنة",null,4000,null,6,"مصر","جنيه مصري","قرش",200,100,50,20,10,5,1,null,null,{"$f":"IF(العملة[[#This Row],[الدولة]]<>\"\",العملة[[#This Row],[الرقم]]&\"-\"&العملة[[#This Row],[الدولة]],\"\")","v":"6-مصر"},"LE"]
[null,{"$f":"IF(D9=\"\",\"\",SUBTOTAL(3,$D$9:D9))","v":""},{"$f":"IF($D9=\"\",\"\",IF($C9=\"\",NOW(),$C9))","v":""},null,null,null,null,{"$f":"IF($D9=\"\",\"\",SUM($G$9:G9)-SUM($F$9:F9))","v":""},null,null,{"$f":"\"رصيد الفئات / \"&VLOOKUP(I3,العملة[],15,0)","v":"رصيد الفئات / LBP"},{"$f":"IF(Q12=\"\",SUM(Q13,Q23)+SUM(Q31,Q39)*$Q$8,SUM(Q13,Q23)+SUM(Q31,Q39)/$Q$8)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(العملة[[#This Row],[الدولة]]<>\"\",العملة[[#This Row],[الرقم]]&\"-\"&العملة[[#This Row],[الدولة]],\"\")","v":""}]
[null,{"$f":"IF(D10=\"\",\"\",SUBTOTAL(3,$D$9:D10))","v":""},"",null,null,null,null,{"$f":"IF($D10=\"\",\"\",SUM($G$9:G10)-SUM($F$9:F10))","v":""},null,null,"الفرق",{"$f":"L8-(L9/$Q$8*$Q$8)","v":0}]
[null,{"$f":"IF(D11=\"\",\"\",SUBTOTAL(3,$D$9:D11))","v":""},"",null,null,null,null,{"$f":"IF($D11=\"\",\"\",SUM($G$9:G11)-SUM($F$9:F11))","v":""},null,null,{"$f":"IF($G$2<>\"\",IF($L$10>0,\"زيادة المقبوضات على الفئات\",IF($L$10<0,\"نقص المقبوضات عن الفئات\",IF($L$10=0,\"تعادل بينهما\"))),\"\")","v":"تعادل بينهما"},null,null,null,null,{"$f":"L10*-1","v":0}]
[null,{"$f":"IF(D12=\"\",\"\",SUBTOTAL(3,$D$9:D12))","v":""},"",null,null,null,null,{"$f":"IF($D12=\"\",\"\",SUM($G$9:G12)-SUM($F$9:F12))","v":""},null,null,{"$f":"IF(K11<>\"تعادل بينهما\",$K$11&\" \"&NoToTxt($P$11,VLOOKUP($I$3,العملة[],3,0),VLOOKUP($I$3,العملة[],4,0)),NoToTxt($P$11,VLOOKUP($I$3,العملة[],3,0),VLOOKUP($I$3,العملة[],4,0)))","v":"صفر"}]
[null,{"$f":"IF(D13=\"\",\"\",SUBTOTAL(3,$D$9:D13))","v":""},"",null,null,null,null,{"$f":"IF($D13=\"\",\"\",SUM($G$9:G13)-SUM($F$9:F13))","v":""},null,null,"فئات نقدية","العدد","المجموع",null,{"$f":"\"نقداً / \"&VLOOKUP($I$3,العملة[],15,0)","v":"نقداً / LBP"},null,{"$f":"SUM(' '!$M$14:$M$21)","v":0}]
[null,{"$f":"IF(D14=\"\",\"\",SUBTOTAL(3,$D$9:D14))","v":""},"",null,null,null,null,{"$f":"IF($D14=\"\",\"\",SUM($G$9:G14)-SUM($F$9:F14))","v":""},null,null,{"$f":"VLOOKUP($I$3,العملة[],5,0)","v":100000},null,{"$f":"IF($L14=\"\",\"\",$K14*$L14)","v":""}]
[null,{"$f":"IF(D15=\"\",\"\",SUBTOTAL(3,$D$9:D15))","v":""},"",null,null,null,null,{"$f":"IF($D15=\"\",\"\",SUM($G$9:G15)-SUM($F$9:F15))","v":""},null,null,{"$f":"VLOOKUP($I$3,العملة[],6,0)","v":50000},null,{"$f":"IF($L15=\"\",\"\",$K15*$L15)","v":""}]
[null,{"$f":"IF(D16=\"\",\"\",SUBTOTAL(3,$D$9:D16))","v":""},"",null,null,null,null,{"$f":"IF($D16=\"\",\"\",SUM($G$9:G16)-SUM($F$9:F16))","v":""},null,null,{"$f":"VLOOKUP($I$3,العملة[],7,0)","v":20000},null,""]
[null,{"$f":"IF(D17=\"\",\"\",SUBTOTAL(3,$D$9:D17))","v":""},"",null,null,null,null,{"$f":"IF($D17=\"\",\"\",SUM($G$9:G17)-SUM($F$9:F17))","v":""},null,null,{"$f":"VLOOKUP($I$3,العملة[],8,0)","v":10000},null,""]
[null,{"$f":"IF(D18=\"\",\"\",SUBTOTAL(3,$D$9:D18))","v":""},"",null,null,null,null,{"$f":"IF($D18=\"\",\"\",SUM($G$9:G18)-SUM($F$9:F18))","v":""},null,null,{"$f":"VLOOKUP($I$3,العملة[],9,0)","v":5000},null,""]
[null,{"$f":"IF(D19=\"\",\"\",SUBTOTAL(3,$D$9:D19))","v":""},"",null,null,null,null,{"$f":"IF($D19=\"\",\"\",SUM($G$9:G19)-SUM($F$9:F19))","v":""},null,null,{"$f":"VLOOKUP($I$3,العملة[],10,0)","v":1000},null,""]
[null,{"$f":"IF(D20=\"\",\"\",SUBTOTAL(3,$D$9:D20))","v":""},"",null,null,null,null,{"$f":"IF($D20=\"\",\"\",SUM($G$9:G20)-SUM($F$9:F20))","v":""},null,null,{"$f":"VLOOKUP($I$3,العملة[],11,0)","v":500},null,""]
[null,{"$f":"IF(D21=\"\",\"\",SUBTOTAL(3,$D$9:D21))","v":""},"",null,null,null,null,{"$f":"IF($D21=\"\",\"\",SUM($G$9:G21)-SUM($F$9:F21))","v":""},null,null,{"$f":"VLOOKUP($I$3,العملة[],12,0)","v":250},null,""]
[null,{"$f":"IF(D22=\"\",\"\",SUBTOTAL(3,$D$9:D22))","v":""},"",null,null,null,null,{"$f":"IF($D22=\"\",\"\",SUM($G$9:G22)-SUM($F$9:F22))","v":""},null,{"$f":"SUMPRODUCT(' '!$K$14:$K$21*J14:J21)","v":0},{"$f":"NoToTxt(L3,VLOOKUP($I$3,العملة[],3,0),VLOOKUP($I$3,العملة[],4,0))","v":"صفر"}]
[null,{"$f":"IF(D23=\"\",\"\",SUBTOTAL(3,$D$9:D23))","v":""},"",null,null,null,null,{"$f":"IF($D23=\"\",\"\",SUM($G$9:G23)-SUM($F$9:F23))","v":""},null,{"$f":"NoToTxt(J22,VLOOKUP($I$3,العملة[],3,0),VLOOKUP($I$3,العملة[],4,0))","v":"صفر"},"شيكات","العدد","المجموع",null,{"$f":"\"شيكات / \"&VLOOKUP($I$3,العملة[],15,0)","v":"شيكات / LBP"},null,{"$f":"SUM(Table11[المجموع])","v":0}]
[null,{"$f":"IF(D24=\"\",\"\",SUBTOTAL(3,$D$9:D24))","v":""},"",null,null,null,null,{"$f":"IF($D24=\"\",\"\",SUM($G$9:G24)-SUM($F$9:F24))","v":""}]
[null,{"$f":"IF(D25=\"\",\"\",SUBTOTAL(3,$D$9:D25))","v":""},"",null,null,null,null,{"$f":"IF($D25=\"\",\"\",SUM($G$9:G25)-SUM($F$9:F25))","v":""}]
[null,{"$f":"IF(D26=\"\",\"\",SUBTOTAL(3,$D$9:D26))","v":""},"",null,null,null,null,{"$f":"IF($D26=\"\",\"\",SUM($G$9:G26)-SUM($F$9:F26))","v":""}]
[null,{"$f":"IF(D27=\"\",\"\",SUBTOTAL(3,$D$9:D27))","v":""},"",null,null,null,null,{"$f":"IF($D27=\"\",\"\",SUM($G$9:G27)-SUM($F$9:F27))","v":""}]
[null,{"$f":"IF(D28=\"\",\"\",SUBTOTAL(3,$D$9:D28))","v":""},"",null,null,null,null,{"$f":"IF($D28=\"\",\"\",SUM($G$9:G28)-SUM($F$9:F28))","v":""}]
[null,{"$f":"IF(D29=\"\",\"\",SUBTOTAL(3,$D$9:D29))","v":""},"",null,null,null,null,{"$f":"IF($D29=\"\",\"\",SUM($G$9:G29)-SUM($F$9:F29))","v":""}]
[null,{"$f":"IF(D30=\"\",\"\",SUBTOTAL(3,$D$9:D30))","v":""},"",null,null,null,null,{"$f":"IF($D30=\"\",\"\",SUM($G$9:G30)-SUM($F$9:F30))","v":""}]
[null,{"$f":"IF(D31=\"\",\"\",SUBTOTAL(3,$D$9:D31))","v":""},"",null,null,null,null,{"$f":"IF($D31=\"\",\"\",SUM($G$9:G31)-SUM($F$9:F31))","v":""},null,null,"فئات نقدية","العدد","المجموع",null,{"$f":"\"نقداً / \"&VLOOKUP(I4,العملة[],15,0)","v":"نقداً / USD"},null,{"$f":"SUM(' '!$M$32:$M$37)","v":0}]
[null,{"$f":"IF(D32=\"\",\"\",SUBTOTAL(3,$D$9:D32))","v":""},"",null,null,null,null,{"$f":"IF($D32=\"\",\"\",SUM($G$9:G32)-SUM($F$9:F32))","v":""},null,null,{"$f":"VLOOKUP($I$4,العملة[],5,0)","v":100},null,{"$f":"IF($L32=\"\",\"\",$L32*$K32)","v":""}]
[null,{"$f":"IF(D33=\"\",\"\",SUBTOTAL(3,$D$9:D33))","v":""},"",null,null,null,null,{"$f":"IF($D33=\"\",\"\",SUM($G$9:G33)-SUM($F$9:F33))","v":""},null,null,{"$f":"VLOOKUP($I$4,العملة[],6,0)","v":50},null,{"$f":"IF($L33=\"\",\"\",$L33*$K33)","v":""}]
[null,{"$f":"IF(D34=\"\",\"\",SUBTOTAL(3,$D$9:D34))","v":""},"",null,null,null,null,{"$f":"IF($D34=\"\",\"\",SUM($G$9:G34)-SUM($F$9:F34))","v":""},null,null,{"$f":"VLOOKUP($I$4,العملة[],7,0)","v":20},null,""]
[null,{"$f":"IF(D35=\"\",\"\",SUBTOTAL(3,$D$9:D35))","v":""},"",null,null,null,null,{"$f":"IF($D35=\"\",\"\",SUM($G$9:G35)-SUM($F$9:F35))","v":""},null,null,{"$f":"VLOOKUP($I$4,العملة[],8,0)","v":10},null,""]
[null,{"$f":"IF(D36=\"\",\"\",SUBTOTAL(3,$D$9:D36))","v":""},"",null,null,null,null,{"$f":"IF($D36=\"\",\"\",SUM($G$9:G36)-SUM($F$9:F36))","v":""},null,null,{"$f":"VLOOKUP($I$4,العملة[],9,0)","v":5},null,""]
[null,{"$f":"IF(D37=\"\",\"\",SUBTOTAL(3,$D$9:D37))","v":""},"",null,null,null,null,{"$f":"IF($D37=\"\",\"\",SUM($G$9:G37)-SUM($F$9:F37))","v":""},null,null,{"$f":"VLOOKUP($I$4,العملة[],10,0)","v":1},null,""]
[null,{"$f":"IF(D38=\"\",\"\",SUBTOTAL(3,$D$9:D38))","v":""},"",null,null,null,null,{"$f":"IF($D38=\"\",\"\",SUM($G$9:G38)-SUM($F$9:F38))","v":""},null,{"$f":"SUMPRODUCT(' '!$K$32:$K$37*J32:J37)","v":0},{"$f":"NoToTxt($L$4,VLOOKUP($I$4,العملة[],3,0),VLOOKUP($I$4,العملة[],4,0))","v":"صفر"}]
[null,{"$f":"IF(D39=\"\",\"\",SUBTOTAL(3,$D$9:D39))","v":""},"",null,null,null,null,{"$f":"IF($D39=\"\",\"\",SUM($G$9:G39)-SUM($F$9:F39))","v":""},null,{"$f":"NoToTxt($J$38,VLOOKUP($I$4,العملة[],3,0),VLOOKUP($I$4,العملة[],4,0))","v":"صفر"},"شيكات","العدد","المجموع",null,{"$f":"\"شيكات / \"&VLOOKUP(I4,العملة[],15,0)","v":"شيكات / USD"},null,{"$f":"SUM(Table10[المجموع])","v":0}]
[null,{"$f":"IF(D40=\"\",\"\",SUBTOTAL(3,$D$9:D40))","v":""},"",null,null,null,null,{"$f":"IF($D40=\"\",\"\",SUM($G$9:G40)-SUM($F$9:F40))","v":""}]
[null,{"$f":"IF(D41=\"\",\"\",SUBTOTAL(3,$D$9:D41))","v":""},"",null,null,null,null,{"$f":"IF($D41=\"\",\"\",SUM($G$9:G41)-SUM($F$9:F41))","v":""}]
[null,{"$f":"IF(D42=\"\",\"\",SUBTOTAL(3,$D$9:D42))","v":""},"",null,null,null,null,{"$f":"IF($D42=\"\",\"\",SUM($G$9:G42)-SUM($F$9:F42))","v":""}]
[null,{"$f":"IF(D43=\"\",\"\",SUBTOTAL(3,$D$9:D43))","v":""},"",null,null,null,null,{"$f":"IF($D43=\"\",\"\",SUM($G$9:G43)-SUM($F$9:F43))","v":""}]
[null,{"$f":"IF(D44=\"\",\"\",SUBTOTAL(3,$D$9:D44))","v":""},"",null,null,null,null,{"$f":"IF($D44=\"\",\"\",SUM($G$9:G44)-SUM($F$9:F44))","v":""}]
[null,{"$f":"IF(D45=\"\",\"\",SUBTOTAL(3,$D$9:D45))","v":""},"",null,null,null,null,{"$f":"IF($D45=\"\",\"\",SUM($G$9:G45)-SUM($F$9:F45))","v":""}]
[null,{"$f":"IF(D46=\"\",\"\",SUBTOTAL(3,$D$9:D46))","v":""},"",null,null,null,null,{"$f":"IF($D46=\"\",\"\",SUM($G$9:G46)-SUM($F$9:F46))","v":""}]
[null,{"$f":"IF(D47=\"\",\"\",SUBTOTAL(3,$D$9:D47))","v":""},"",null,null,null,null,{"$f":"IF($D47=\"\",\"\",SUM($G$9:G47)-SUM($F$9:F47))","v":""}]
[null,{"$f":"IF(D48=\"\",\"\",SUBTOTAL(3,$D$9:D48))","v":""},"",null,null,null,null,{"$f":"IF($D48=\"\",\"\",SUM($G$9:G48)-SUM($F$9:F48))","v":""}]
[null,{"$f":"IF(D49=\"\",\"\",SUBTOTAL(3,$D$9:D49))","v":""},"",null,null,null,null,{"$f":"IF($D49=\"\",\"\",SUM($G$9:G49)-SUM($F$9:F49))","v":""}]
[null,{"$f":"IF(D50=\"\",\"\",SUBTOTAL(3,$D$9:D50))","v":""},"",null,null,null,null,{"$f":"IF($D50=\"\",\"\",SUM($G$9:G50)-SUM($F$9:F50))","v":""}]
[null,{"$f":"IF(D51=\"\",\"\",SUBTOTAL(3,$D$9:D51))","v":""},"",null,null,null,null,{"$f":"IF($D51=\"\",\"\",SUM($G$9:G51)-SUM($F$9:F51))","v":""}]
[null,{"$f":"IF(D52=\"\",\"\",SUBTOTAL(3,$D$9:D52))","v":""},"",null,null,null,null,{"$f":"IF($D52=\"\",\"\",SUM($G$9:G52)-SUM($F$9:F52))","v":""}]
[null,{"$f":"IF(D53=\"\",\"\",SUBTOTAL(3,$D$9:D53))","v":""},"",null,null,null,null,{"$f":"IF($D53=\"\",\"\",SUM($G$9:G53)-SUM($F$9:F53))","v":""}]
[null,{"$f":"IF(D54=\"\",\"\",SUBTOTAL(3,$D$9:D54))","v":""},"",null,null,null,null,{"$f":"IF($D54=\"\",\"\",SUM($G$9:G54)-SUM($F$9:F54))","v":""}]
[null,{"$f":"IF(D55=\"\",\"\",SUBTOTAL(3,$D$9:D55))","v":""},"",null,null,null,null,{"$f":"IF($D55=\"\",\"\",SUM($G$9:G55)-SUM($F$9:F55))","v":""}]
[null,{"$f":"IF(D56=\"\",\"\",SUBTOTAL(3,$D$9:D56))","v":""},"",null,null,null,null,{"$f":"IF($D56=\"\",\"\",SUM($G$9:G56)-SUM($F$9:F56))","v":""}]
[null,{"$f":"IF(D57=\"\",\"\",SUBTOTAL(3,$D$9:D57))","v":""},"",null,null,null,null,{"$f":"IF($D57=\"\",\"\",SUM($G$9:G57)-SUM($F$9:F57))","v":""}]
[null,{"$f":"IF(D58=\"\",\"\",SUBTOTAL(3,$D$9:D58))","v":""},"",null,null,null,null,{"$f":"IF($D58=\"\",\"\",SUM($G$9:G58)-SUM($F$9:F58))","v":""}]
[null,{"$f":"IF(D59=\"\",\"\",SUBTOTAL(3,$D$9:D59))","v":""},"",null,null,null,null,{"$f":"IF($D59=\"\",\"\",SUM($G$9:G59)-SUM($F$9:F59))","v":""}]
[null,{"$f":"IF(D60=\"\",\"\",SUBTOTAL(3,$D$9:D60))","v":""},"",null,null,null,null,{"$f":"IF($D60=\"\",\"\",SUM($G$9:G60)-SUM($F$9:F60))","v":""}]
[]
[]
[]
[null,null,null,null," "]