{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["sheet1","الفواتير"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":4,"defined_names":6,"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":"sheet1","index":0,"n_rows":105,"n_cols":18,"rows_kept":105,"cut":false,"hidden":false,"merged":[[103,5,103,6],[102,2,102,3],[0,1,0,4],[1,2,1,4],[2,2,2,4],[3,2,3,4],[4,2,4,3],[97,1,97,8]]}
["/الاسم","الحاج/ علي",null,null,null,null,"فاتورة بيع  نقدي",{"$f":"[4]السجاد!C2","v":0},{"$f":"IF(B1<>\"\",IF(I1=\"\",NOW(),I1),\"\")","v":""},null,"نوع الفاتورة",null,"القديم",null,0,"نوع الكشف",null,"قائمة"]
[0,null,{"$f":"SUM(F8:F96)","v":9250},null,null,null,5,null,"1900-01-12",null,"فاتورة بيع  نقدي",null,null,null,0,"وذالك عن اتفاق في ستائر",null,"لم يستلم"]
[0,null,{"$f":"SUM(H10:H95)","v":1000},null,null,null,null,null,null,null,"فاتورة بيع آجل",null,null,null,0,"وذالك عن اتفاق في قعدة عربي",null,"مرتجع"]
[0,null,null,null,null,null,null,{"$f":"IF(G4=\"\",\"\",G4-1)","v":""},{"$f":"IF(G4=\"\",\"\",IF(G4-TODAY()>=1,G4-TODAY(),IF(G4-TODAY()<0,\"نفذ الفرح منذ \" & TODAY()-G4 &\" \" &\"يوم\",\"الفرح الان \")))","v":""},null,null,null,null,null,0,"وذالك عن اتفاق في سجاد",null,"استلم"]
[0,null,{"$f":"IF(AND($E$5=0,$G$5>TODAY()),\"خالص ولم يستلم\",IF(AND($E$5>0,$G$5<>TODAY()),\" الباقى كله\",IF(AND(E5=0,G5<=TODAY()),\"خالص\",IF($E$5<0,\" هذا المبلغ للعميل \"& $B$1,\"\"))))","v":" الباقى كله"},null,{"$f":"C2-C3-C4","v":8250},null,null,{"$f":"IF(G5=\"\",\"\",G5-1)","v":""},{"$f":"IF(G5=\"\",\"\",IF(G5-TODAY()>=1,G5-TODAY(),IF(G5-TODAY()<0,\"تم التسليم منذ  \" & TODAY()-G5 &\" \" &\"يوم\",\"التسليم الان \")))","v":""},{"$f":"HYPERLINK(\"https://www.facebook.com/\")","v":"https://www.facebook.com/"},null,null,null,null,0,null,null,"تليفون"]
[0,null,{"$f":"E5","v":8250},null,null,null,null,{"$f":"IF(G6=\"\",\"\",G6-1)","v":""},{"$f":"IF(G6=\"\",\"\",IF(G6-TODAY()>=1,G6-TODAY(),IF(G6-TODAY()<0,\"نفذ معاد السداد منذ \" & TODAY()-G6 &\" \" &\"يوم\",\"السدادالان \")))","v":""},null,null,null,null,null,0,null,null,"ملحوظة"]
["عدد","كود"," الصنف ","الكمية","السعر","القيمة","ملحوظة","الواصل","التاريخ",null,null,null,null,null,0,null,null,"باقي"]
[{"$f":"IF(C8=\"\",\"\",SUBTOTAL(3,$C$8:C8))","v":1},null,"سجاد 3*4",1,1000,{"$f":"D8*E8","v":1000},null,null,{"$f":"TODAY()","v":"2019-07-06"}]
[{"$f":"IF(C9=\"\",\"\",SUBTOTAL(3,$C$8:C9))","v":""},null,null,null,null,{"$f":"D9*E9","v":0},null,null,{"$f":"TODAY()","v":"2019-07-06"},null,null,43494]
[{"$f":"IF(C10=\"\",\"\",SUBTOTAL(3,$C$8:C10))","v":""},null,null,null,null,0,null,null,{"$f":"IF(H10<>\"\",IF(I10=\"\",NOW(),I10),\"\")","v":""}]
[{"$f":"IF(C11=\"\",\"\",SUBTOTAL(3,$C$8:C11))","v":2},null,"قماش",5,30,150,null,null,""]
[{"$f":"IF(C12=\"\",\"\",SUBTOTAL(3,$C$8:C12))","v":3},null,"المطلوب ترحيل البييانات بدون  فراغ",null,null,0,null,null,""]
[{"$f":"IF(C13=\"\",\"\",SUBTOTAL(3,$C$8:C13))","v":""},null,null,null,null,0,null,null,""]
[{"$f":"IF(C14=\"\",\"\",SUBTOTAL(3,$C$8:C14))","v":4},null,"مرتبة طبي 160*2",1,2100,2100,null,1000,"",{"$f":"HYPERLINK(\"d:\\OneDrive\\المطلوب\")","v":"d:\\OneDrive\\المطلوب"}]
[{"$f":"IF(C15=\"\",\"\",SUBTOTAL(3,$C$8:C15))","v":""},null,null,null,null,0,null,null,""]
[{"$f":"IF(C16=\"\",\"\",SUBTOTAL(3,$C$8:C16))","v":""},null,null,null,null,0,null,null,""]
[{"$f":"IF(C17=\"\",\"\",SUBTOTAL(3,$C$8:C17))","v":5},null,"ستائر8 قطع",8,750,6000,null,null,""]
[{"$f":"IF(C18=\"\",\"\",SUBTOTAL(3,$C$8:C18))","v":""},null,null,null,null,0,null,null,""]
[{"$f":"IF(C19=\"\",\"\",SUBTOTAL(3,$C$8:C19))","v":""},null,null,null,null,0,null,null,""]
[{"$f":"IF(C20=\"\",\"\",SUBTOTAL(3,$C$8:C20))","v":""},null,null,null,null,0,null,null,""]
[{"$f":"IF(C21=\"\",\"\",SUBTOTAL(3,$C$8:C21))","v":""},null,null,null,null,0,null,null,""]
[{"$f":"IF(C22=\"\",\"\",SUBTOTAL(3,$C$8:C22))","v":""},null,null,null,null,0,null,null,""]
[{"$f":"IF(C23=\"\",\"\",SUBTOTAL(3,$C$8:C23))","v":""},null,null,null,null,0,null,null,""]
[{"$f":"IF(C24=\"\",\"\",SUBTOTAL(3,$C$8:C24))","v":""},null,null,null,null,0,null,null,""]
[{"$f":"IF(C25=\"\",\"\",SUBTOTAL(3,$C$8:C25))","v":""},null,null,null,null,0,null,null,""]
[{"$f":"IF(C26=\"\",\"\",SUBTOTAL(3,$C$8:C26))","v":""},null,null,null,null,0,null,null,""]
[{"$f":"IF(C27=\"\",\"\",SUBTOTAL(3,$C$8:C27))","v":""},null,null,null,null,0,null,null,""]
[{"$f":"IF(C28=\"\",\"\",SUBTOTAL(3,$C$8:C28))","v":""},null,null,null,null,0,null,null,""]
[{"$f":"IF(C29=\"\",\"\",SUBTOTAL(3,$C$8:C29))","v":""},null,null,null,null,0,null,null,""]
[{"$f":"IF(C30=\"\",\"\",SUBTOTAL(3,$C$8:C30))","v":""},null,null,null,null,0,null,null,""]
[{"$f":"IF(C31=\"\",\"\",SUBTOTAL(3,$C$8:C31))","v":""},null,null,null,null,0,null,null,""]
[{"$f":"IF(C32=\"\",\"\",SUBTOTAL(3,$C$8:C32))","v":""},null,null,null,null,0,null,null,""]
[{"$f":"IF(C33=\"\",\"\",SUBTOTAL(3,$C$8:C33))","v":""},null,null,null,null,0,null,null,""]
[{"$f":"IF(C34=\"\",\"\",SUBTOTAL(3,$C$8:C34))","v":""},null,null,null,null,0,null,null,""]
[{"$f":"IF(C35=\"\",\"\",SUBTOTAL(3,$C$8:C35))","v":""},null,null,null,null,0,null,null,""]
[{"$f":"IF(C36=\"\",\"\",SUBTOTAL(3,$C$8:C36))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C37=\"\",\"\",SUBTOTAL(3,$C$8:C37))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C38=\"\",\"\",SUBTOTAL(3,$C$8:C38))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C39=\"\",\"\",SUBTOTAL(3,$C$8:C39))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C40=\"\",\"\",SUBTOTAL(3,$C$8:C40))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C41=\"\",\"\",SUBTOTAL(3,$C$8:C41))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C42=\"\",\"\",SUBTOTAL(3,$C$8:C42))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C43=\"\",\"\",SUBTOTAL(3,$C$8:C43))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C44=\"\",\"\",SUBTOTAL(3,$C$8:C44))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C45=\"\",\"\",SUBTOTAL(3,$C$8:C45))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C46=\"\",\"\",SUBTOTAL(3,$C$8:C46))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C47=\"\",\"\",SUBTOTAL(3,$C$8:C47))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C48=\"\",\"\",SUBTOTAL(3,$C$8:C48))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C49=\"\",\"\",SUBTOTAL(3,$C$8:C49))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C50=\"\",\"\",SUBTOTAL(3,$C$8:C50))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C51=\"\",\"\",SUBTOTAL(3,$C$8:C51))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C52=\"\",\"\",SUBTOTAL(3,$C$8:C52))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C53=\"\",\"\",SUBTOTAL(3,$C$8:C53))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C54=\"\",\"\",SUBTOTAL(3,$C$8:C54))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C55=\"\",\"\",SUBTOTAL(3,$C$8:C55))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C56=\"\",\"\",SUBTOTAL(3,$C$8:C56))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C57=\"\",\"\",SUBTOTAL(3,$C$8:C57))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C58=\"\",\"\",SUBTOTAL(3,$C$8:C58))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C59=\"\",\"\",SUBTOTAL(3,$C$8:C59))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C60=\"\",\"\",SUBTOTAL(3,$C$8:C60))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C61=\"\",\"\",SUBTOTAL(3,$C$8:C61))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C62=\"\",\"\",SUBTOTAL(3,$C$8:C62))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C63=\"\",\"\",SUBTOTAL(3,$C$8:C63))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C64=\"\",\"\",SUBTOTAL(3,$C$8:C64))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C65=\"\",\"\",SUBTOTAL(3,$C$8:C65))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C66=\"\",\"\",SUBTOTAL(3,$C$8:C66))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C67=\"\",\"\",SUBTOTAL(3,$C$8:C67))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C68=\"\",\"\",SUBTOTAL(3,$C$8:C68))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C69=\"\",\"\",SUBTOTAL(3,$C$8:C69))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C70=\"\",\"\",SUBTOTAL(3,$C$8:C70))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C71=\"\",\"\",SUBTOTAL(3,$C$8:C71))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C72=\"\",\"\",SUBTOTAL(3,$C$8:C72))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C73=\"\",\"\",SUBTOTAL(3,$C$8:C73))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C74=\"\",\"\",SUBTOTAL(3,$C$8:C74))","v":""},null,null,null,null,null,null,null,{"$f":"IF(H74<>\"\",IF(I74=\"\",NOW(),I74),\"\")","v":""}]
[{"$f":"IF(C75=\"\",\"\",SUBTOTAL(3,$C$8:C75))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C76=\"\",\"\",SUBTOTAL(3,$C$8:C76))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C77=\"\",\"\",SUBTOTAL(3,$C$8:C77))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C78=\"\",\"\",SUBTOTAL(3,$C$8:C78))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C79=\"\",\"\",SUBTOTAL(3,$C$8:C79))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C80=\"\",\"\",SUBTOTAL(3,$C$8:C80))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C81=\"\",\"\",SUBTOTAL(3,$C$8:C81))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C82=\"\",\"\",SUBTOTAL(3,$C$8:C82))","v":""},null,null,null,null,null,null,null,{"$f":"IF(H82<>\"\",IF(I82=\"\",NOW(),I82),\"\")","v":""}]
[{"$f":"IF(C83=\"\",\"\",SUBTOTAL(3,$C$8:C83))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C84=\"\",\"\",SUBTOTAL(3,$C$8:C84))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C85=\"\",\"\",SUBTOTAL(3,$C$8:C85))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C86=\"\",\"\",SUBTOTAL(3,$C$8:C86))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C87=\"\",\"\",SUBTOTAL(3,$C$8:C87))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C88=\"\",\"\",SUBTOTAL(3,$C$8:C88))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C89=\"\",\"\",SUBTOTAL(3,$C$8:C89))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C90=\"\",\"\",SUBTOTAL(3,$C$8:C90))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C91=\"\",\"\",SUBTOTAL(3,$C$8:C91))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C92=\"\",\"\",SUBTOTAL(3,$C$8:C92))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C93=\"\",\"\",SUBTOTAL(3,$C$8:C93))","v":""},null,null,null,null,null,null,null,{"$f":"IF(H93<>\"\",IF(I93=\"\",NOW(),I93),\"\")","v":""}]
[{"$f":"IF(C94=\"\",\"\",SUBTOTAL(3,$C$8:C94))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C95=\"\",\"\",SUBTOTAL(3,$C$8:C95))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C96=\"\",\"\",SUBTOTAL(3,$C$8:C96))","v":""}]
[{"$f":"IF(C97=\"\",\"\",SUBTOTAL(3,$C$8:C97))","v":""},null,null,null,null,null,null,null,""]
[0,{"$f":"   \"فقط : \" & ArbNum2Text(C2)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,0]
["****","****","***************************","***************","*********","**********","*********************","********************","******************************",".",null,null,null,5,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(B1>1,\" استلم \"  &$B$1&\"نسخة من الفاتورة عدد \",\"\")","v":" استلم الحاج/ علينسخة من الفاتورة عدد "},null,"عدد النسخة مع العميل",null,3,"رجاء الاحتفاظ  بالفاتورة",null,null,{"$f":"NOW()","v":"2019-07-06T12:43:55.770"},null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["******************************************************************************************************************************************************************************************************************************************************",null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"الفواتير","index":1,"n_rows":67,"n_cols":13,"rows_kept":67,"cut":false,"hidden":false,"merged":[[24,1,24,4],[2,1,2,4],[3,2,3,4],[4,2,4,4],[5,2,5,4],[6,2,6,3],[48,2,48,4],[49,2,49,4],[50,2,50,3],[25,2,25,4],[26,2,26,4],[27,2,27,4],[28,2,28,3],[46,1,46,4],[47,2,47,4]]}
[]
[]
["/الاسم","الحاج ياسر من البطرخانة",null,null,null,"م","فاتورة بيع  نقدي",{"$f":"[4]السجاد!C4","v":0},{"$f":"IF(B3<>\"\",IF(I3=\"\",NOW(),I3),\"\")","v":"2019-07-03T20:09:01.110"},null,"نوع الفاتورة",null,"القديم"]
[0,null,3860,null,null,null,5,null,"1900-01-09",null,"فاتورة بيع  نقدي"]
[0,null,{"$f":"SUM(H12:H97)","v":89494},null,null,null,null,null,null,null,"فاتورة بيع آجل"]
[0,null,null,null,null,null,null,{"$f":"IF(G6=\"\",\"\",G6-1)","v":""},{"$f":"IF(G6=\"\",\"\",IF(G6-TODAY()>=1,G6-TODAY(),IF(G6-TODAY()<0,\"نفذ الفرح منذ \" & TODAY()-G6 &\" \" &\"يوم\",\"الفرح الان \")))","v":""}]
[0,null,{"$f":"IF(AND($E$5=0,$G$5>TODAY()),\"خالص ولم يستلم\",IF(AND($E$5>0,$G$5<>TODAY()),\" الباقى كله\",IF(AND(E7=0,G7<=TODAY()),\"خالص\",IF($E$5<0,\" هذا المبلغ للعميل \"& $B$1,\"\"))))","v":""},null,{"$f":"C4-C5-C6","v":-85634},null,null,{"$f":"IF(G7=\"\",\"\",G7-1)","v":""},{"$f":"IF(G7=\"\",\"\",IF(G7-TODAY()>=1,G7-TODAY(),IF(G7-TODAY()<0,\"تم التسليم منذ  \" & TODAY()-G7 &\" \" &\"يوم\",\"التسليم الان \")))","v":""},{"$f":"HYPERLINK(\"https://www.facebook.com/\")","v":"https://www.facebook.com/"}]
[0,null,{"$f":"E7","v":-85634},null,null,null,null,{"$f":"IF(G8=\"\",\"\",G8-1)","v":""},{"$f":"IF(G8=\"\",\"\",IF(G8-TODAY()>=1,G8-TODAY(),IF(G8-TODAY()<0,\"نفذ معاد السداد منذ \" & TODAY()-G8 &\" \" &\"يوم\",\"السدادالان \")))","v":""}]
["عدد","كود"," الصنف ","الكمية","السعر","القيمة","ملحوظة","الواصل","التاريخ"]
[{"$f":"IF(C10=\"\",\"\",SUBTOTAL(3,$C$8:C10))","v":""},null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2019-07-06"}]
[{"$f":"IF(C11=\"\",\"\",SUBTOTAL(3,$C$8:C11))","v":3},null,"سجاد حفر 2*3",1,1050,1050,null,null,{"$f":"TODAY()","v":"2019-07-06"},null,null,43494]
[{"$f":"IF(C12=\"\",\"\",SUBTOTAL(3,$C$8:C12))","v":4},null,"سجاد 2*3 س",1,380,380,null,null,{"$f":"IF(H12<>\"\",IF(I12=\"\",NOW(),I12),\"\")","v":""}]
[{"$f":"IF(C13=\"\",\"\",SUBTOTAL(3,$C$8:C13))","v":5},null,"سجاد 150*225",1,275,275,null,null,""]
[{"$f":"IF(C14=\"\",\"\",SUBTOTAL(3,$C$8:C14))","v":6},null,"سجاد حفر 1*380",3.8,125,475,null,null,""]
[{"$f":"IF(C15=\"\",\"\",SUBTOTAL(3,$C$8:C15))","v":7},null,"أطفال 80*2+80*170+60*220+60*160",7.5,80,600,null,null,""]
[{"$f":"IF(C16=\"\",\"\",SUBTOTAL(3,$C$8:C16))","v":8},null,"مطبخ 1*2",1,150,150,null,1500,"2019-07-03T20:18:34.120",{"$f":"HYPERLINK(\"d:\\OneDrive\\المطلوب\")","v":"d:\\OneDrive\\المطلوب"}]
[{"$f":"IF(C17=\"\",\"\",SUBTOTAL(3,$C$8:C17))","v":9},null,"سجاد  م150*360",5.5,80,440,null,null,""]
[{"$f":"IF(C18=\"\",\"\",SUBTOTAL(3,$C$8:C18))","v":10},null,"سجاد م 120*160",2,80,160,null,null,""]
[{"$f":"IF(C19=\"\",\"\",SUBTOTAL(3,$C$8:C19))","v":11},null,"دواسة أطفال ",1,25,25,null,null,""]
[{"$f":"IF(C20=\"\",\"\",SUBTOTAL(3,$C$8:C20))","v":12},null,"دواسة كتان",3,45,135,null,null,""]
[{"$f":"IF(C21=\"\",\"\",SUBTOTAL(3,$C$8:C21))","v":13},null,"دواسة حفر",1,65,65,null,null,""]
[{"$f":"IF(C22=\"\",\"\",SUBTOTAL(3,$C$8:C22))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C23=\"\",\"\",SUBTOTAL(3,$C$8:C23))","v":""},null,null,null,null,null,null,null,""]
[]
["/الاسم","محمد",null,null,null,null,"فاتورة بيع  نقدي",{"$f":"[4]السجاد!C26","v":0},{"$f":"IF(B25<>\"\",IF(I25=\"\",NOW(),I25),\"\")","v":""},null,"نوع الفاتورة",null,"القديم"]
[0,null,3860,null,null,null,5,null,"1900-01-10",null,"فاتورة بيع  نقدي"]
[0,null,{"$f":"SUM(H34:H119)","v":87994},null,null,null,null,null,null,null,"فاتورة بيع آجل"]
[0,null,null,null,null,null,null,{"$f":"IF(G28=\"\",\"\",G28-1)","v":""},{"$f":"IF(G28=\"\",\"\",IF(G28-TODAY()>=1,G28-TODAY(),IF(G28-TODAY()<0,\"نفذ الفرح منذ \" & TODAY()-G28 &\" \" &\"يوم\",\"الفرح الان \")))","v":""}]
[0,null,{"$f":"IF(AND($E$5=0,$G$5>TODAY()),\"خالص ولم يستلم\",IF(AND($E$5>0,$G$5<>TODAY()),\" الباقى كله\",IF(AND(E29=0,G29<=TODAY()),\"خالص\",IF($E$5<0,\" هذا المبلغ للعميل \"& $B$1,\"\"))))","v":""},null,{"$f":"C26-C27-C28","v":-84134},null,null,{"$f":"IF(G29=\"\",\"\",G29-1)","v":""},{"$f":"IF(G29=\"\",\"\",IF(G29-TODAY()>=1,G29-TODAY(),IF(G29-TODAY()<0,\"تم التسليم منذ  \" & TODAY()-G29 &\" \" &\"يوم\",\"التسليم الان \")))","v":""},{"$f":"HYPERLINK(\"https://www.facebook.com/\")","v":"https://www.facebook.com/"}]
[0,null,{"$f":"E29","v":-84134},null,null,null,null,{"$f":"IF(G30=\"\",\"\",G30-1)","v":""},{"$f":"IF(G30=\"\",\"\",IF(G30-TODAY()>=1,G30-TODAY(),IF(G30-TODAY()<0,\"نفذ معاد السداد منذ \" & TODAY()-G30 &\" \" &\"يوم\",\"السدادالان \")))","v":""}]
["عدد","كود"," الصنف ","الكمية","السعر","القيمة","ملحوظة","الواصل","التاريخ"]
[{"$f":"IF(C32=\"\",\"\",SUBTOTAL(3,$C$8:C32))","v":""},null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2019-07-06"}]
[{"$f":"IF(C33=\"\",\"\",SUBTOTAL(3,$C$8:C33))","v":""},null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2019-07-06"},null,null,43494]
[{"$f":"IF(C34=\"\",\"\",SUBTOTAL(3,$C$8:C34))","v":""},null,null,null,null,null,null,null,{"$f":"IF(H34<>\"\",IF(I34=\"\",NOW(),I34),\"\")","v":""}]
[{"$f":"IF(C35=\"\",\"\",SUBTOTAL(3,$C$8:C35))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C36=\"\",\"\",SUBTOTAL(3,$C$8:C36))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C37=\"\",\"\",SUBTOTAL(3,$C$8:C37))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C38=\"\",\"\",SUBTOTAL(3,$C$8:C38))","v":""},null,null,null,null,null,null,null,"",{"$f":"HYPERLINK(\"d:\\OneDrive\\المطلوب\")","v":"d:\\OneDrive\\المطلوب"}]
[{"$f":"IF(C39=\"\",\"\",SUBTOTAL(3,$C$8:C39))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C40=\"\",\"\",SUBTOTAL(3,$C$8:C40))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C41=\"\",\"\",SUBTOTAL(3,$C$8:C41))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C42=\"\",\"\",SUBTOTAL(3,$C$8:C42))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C43=\"\",\"\",SUBTOTAL(3,$C$8:C43))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C44=\"\",\"\",SUBTOTAL(3,$C$8:C44))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C45=\"\",\"\",SUBTOTAL(3,$C$8:C45))","v":""},null,null,null,null,null,null,null,""]
[]
["/الاسم","أبو  علي",null,null,null,null,"فاتورة بيع  نقدي",{"$f":"[4]السجاد!C48","v":0},{"$f":"IF(B47<>\"\",IF(I47=\"\",NOW(),I47),\"\")","v":""},null,"نوع الفاتورة",null,"القديم"]
[0,null,3860,null,null,null,5,null,"1900-01-11",null,"فاتورة بيع  نقدي"]
[0,null,{"$f":"SUM(H56:H141)","v":500},null,null,null,null,null,null,null,"فاتورة بيع آجل"]
[0,null,null,null,null,null,"2019-10-25",{"$f":"IF(G50=\"\",\"\",G50-1)","v":"2019-10-24"},{"$f":"IF(G50=\"\",\"\",IF(G50-TODAY()>=1,G50-TODAY(),IF(G50-TODAY()<0,\"نفذ الفرح منذ \" & TODAY()-G50 &\" \" &\"يوم\",\"الفرح الان \")))","v":111}]
[0,null,{"$f":"IF(AND($E$5=0,$G$5>TODAY()),\"خالص ولم يستلم\",IF(AND($E$5>0,$G$5<>TODAY()),\" الباقى كله\",IF(AND(E51=0,G51<=TODAY()),\"خالص\",IF($E$5<0,\" هذا المبلغ للعميل \"& $B$1,\"\"))))","v":""},null,{"$f":"C48-C49-C50","v":3360},null,"2019-09-25",{"$f":"IF(G51=\"\",\"\",G51-1)","v":"2019-09-24"},{"$f":"IF(G51=\"\",\"\",IF(G51-TODAY()>=1,G51-TODAY(),IF(G51-TODAY()<0,\"تم التسليم منذ  \" & TODAY()-G51 &\" \" &\"يوم\",\"التسليم الان \")))","v":81},{"$f":"HYPERLINK(\"https://www.facebook.com/\")","v":"https://www.facebook.com/"}]
[0,null,{"$f":"E51","v":3360},null,null,null,null,{"$f":"IF(G52=\"\",\"\",G52-1)","v":""},{"$f":"IF(G52=\"\",\"\",IF(G52-TODAY()>=1,G52-TODAY(),IF(G52-TODAY()<0,\"نفذ معاد السداد منذ \" & TODAY()-G52 &\" \" &\"يوم\",\"السدادالان \")))","v":""}]
["عدد","كود"," الصنف ","الكمية","السعر","القيمة","ملحوظة","الواصل","التاريخ"]
[{"$f":"IF(C54=\"\",\"\",SUBTOTAL(3,$C$8:C54))","v":24},null,"سجاد 3*4",1,1000,null,null,null,{"$f":"TODAY()","v":"2019-07-06"}]
[{"$f":"IF(C55=\"\",\"\",SUBTOTAL(3,$C$8:C55))","v":""},null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2019-07-06"},null,null,43494]
[{"$f":"IF(C56=\"\",\"\",SUBTOTAL(3,$C$8:C56))","v":""},null,null,null,null,null,null,null,{"$f":"IF(H56<>\"\",IF(I56=\"\",NOW(),I56),\"\")","v":""}]
[{"$f":"IF(C57=\"\",\"\",SUBTOTAL(3,$C$8:C57))","v":25},null,"قماش",5,30,null,null,500,""]
[{"$f":"IF(C58=\"\",\"\",SUBTOTAL(3,$C$8:C58))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C59=\"\",\"\",SUBTOTAL(3,$C$8:C59))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C60=\"\",\"\",SUBTOTAL(3,$C$8:C60))","v":26},null,"مرتبة طبي 160*2",1,2100,null,null,null,"",{"$f":"HYPERLINK(\"d:\\OneDrive\\المطلوب\")","v":"d:\\OneDrive\\المطلوب"}]
[{"$f":"IF(C61=\"\",\"\",SUBTOTAL(3,$C$8:C61))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C62=\"\",\"\",SUBTOTAL(3,$C$8:C62))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C63=\"\",\"\",SUBTOTAL(3,$C$8:C63))","v":27},null,"ستائر8 قطع",8,750,null,null,null,""]
[{"$f":"IF(C64=\"\",\"\",SUBTOTAL(3,$C$8:C64))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C65=\"\",\"\",SUBTOTAL(3,$C$8:C65))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C66=\"\",\"\",SUBTOTAL(3,$C$8:C66))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C67=\"\",\"\",SUBTOTAL(3,$C$8:C67))","v":""},null,null,null,null,null,null,null,""]