{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ورقة1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":3,"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":"ورقة1","index":0,"n_rows":109,"n_cols":13,"rows_kept":109,"cut":false,"hidden":false,"merged":[[97,1,97,8],[99,2,99,8],[100,2,100,8],[101,2,101,8],[102,5,102,7],[103,0,103,9],[0,1,0,4],[0,8,0,9],[1,2,1,4],[2,2,2,4],[3,2,3,4],[4,3,4,5]]}
[null,null,null,null,null,null,2276,{"$f":"[1]السجاد!C2","v":0},{"$f":"IF(B1<>\"\",IF(I1=\"\",NOW(),I1),\"\")","v":""},null,"نوع العملية",null,"القديم"]
[0,null,{"$f":"SUM(F8:F92)","v":954},null,null,null,null,null,null,"ممممم","أجل"]
[0,null,{"$f":"SUM(H10:H68)","v":500},null,null,null,"التاريخ المطلوب",null,"نوع البيان المطلوب",null,"نقدي"]
[0,null,null,null,null,null,null,{"$f":"IF(G4=\"\",\"\",G4)","v":""},{"$f":"IF(G4=\"\",\"\",IF(G4-TODAY()>=1,G4-TODAY(),IF(G4-TODAY()<0,\"نفذ الفرح منذ \" & TODAY()-G4 &\" \" &\"يوم\",\"الفرح الان \")))","v":""}]
[0,null,{"$f":"IF(D5>=1,\"الباقي كله \",IF(D5<=-1,\"هذا المبلغ للعميل\",IF(D5<\"\",\"خالص مع الشكر\",\"d\")))","v":"الباقي كله "},{"$f":"C2-C3-C4","v":454},null,null,null,{"$f":"IF(G5=\"\",\"\",G5)","v":""},{"$f":"IF(G5=\"\",\"\",IF(G5-TODAY()>=1,G5-TODAY(),IF(G5-TODAY()<0,\"تم التسليم منذ  \" & TODAY()-G5 &\" \" &\"يوم\",\"التسليم الان \")))","v":""}]
[0,null,{"$f":"D5","v":454},null,null,null,"2019-02-28",{"$f":"IF(G6=\"\",\"\",G6)","v":"2019-02-28"},{"$f":"IF(G6=\"\",\"\",IF(G6-TODAY()>=1,G6-TODAY(),IF(G6-TODAY()<0,\"نفذ معاد السداد منذ \" & TODAY()-G6 &\" \" &\"يوم\",\"السدادالان \")))","v":35}]
["عدد","كود"," الصنف ","الكمية","السعر","القيمة","ملحوظة","الواصل","التاريخ"]
[{"$f":"IF(C8=\"\",\"\",SUBTOTAL(3,$C$8:C8))","v":1},null,"صنف4",1,5,{"$f":"D8*E8","v":5},null,null,{"$f":"TODAY()","v":"2019-01-24"}]
[{"$f":"IF(C9=\"\",\"\",SUBTOTAL(3,$C$8:C9))","v":2},null,"صنف 1",75,6,{"$f":"D9*E9","v":450},null,null,{"$f":"TODAY()","v":"2019-01-24"}]
[{"$f":"IF(C10=\"\",\"\",SUBTOTAL(3,$C$8:C10))","v":3},null,"صنف 2",null,7,0,"مرتجع",null,{"$f":"IF(H10<>\"\",IF(I10=\"\",NOW(),I10),\"\")","v":""}]
[{"$f":"IF(C11=\"\",\"\",SUBTOTAL(3,$C$8:C11))","v":4},null,"صنف3",4,8,32,null,null,""]
[{"$f":"IF(C12=\"\",\"\",SUBTOTAL(3,$C$8:C12))","v":5},null,"صنف5",6,9,54,"لم يستلم",null,""]
[{"$f":"IF(C13=\"\",\"\",SUBTOTAL(3,$C$8:C13))","v":6},null,"صنف6",6,10,60,null,null,""]
[{"$f":"IF(C14=\"\",\"\",SUBTOTAL(3,$C$8:C14))","v":7},null,"صنف7",null,11,0,"مرتجع",null,""]
[{"$f":"IF(C15=\"\",\"\",SUBTOTAL(3,$C$8:C15))","v":8},null,"صنف8",8,12,96,null,null,""]
[0,null,"صنف9",9,13,117,"لم يستلم",null,""]
[{"$f":"IF(C17=\"\",\"\",SUBTOTAL(3,$C$8:C17))","v":10},null,"صنف10",10,14,140,null,null,""]
[{"$f":"IF(C18=\"\",\"\",SUBTOTAL(3,$C$8:C18))","v":11},null,"صنف11",null,15,0,"مرتجع",null,""]
[{"$f":"IF(C19=\"\",\"\",SUBTOTAL(3,$C$8:C19))","v":""},null,null,null,null,null,null,null,""]
[0,null,"المطلوب عندما اكتب في العمود g8:g95 كلمة مرتجع  يقوم  بمسح الكمية في عمود d8:d95",null,null,null,null,null,""]
[0,null,null,null,null,null,null,null,""]
[{"$f":"IF(C22=\"\",\"\",SUBTOTAL(3,$C$8:C22))","v":""},null,null,null,null,null,null,500,"2019-01-24T09:42:16.400"]
[{"$f":"IF(C23=\"\",\"\",SUBTOTAL(3,$C$8:C23))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C24=\"\",\"\",SUBTOTAL(3,$C$8:C24))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C25=\"\",\"\",SUBTOTAL(3,$C$8:C25))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C26=\"\",\"\",SUBTOTAL(3,$C$8:C26))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C27=\"\",\"\",SUBTOTAL(3,$C$8:C27))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C28=\"\",\"\",SUBTOTAL(3,$C$8:C28))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C29=\"\",\"\",SUBTOTAL(3,$C$8:C29))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C30=\"\",\"\",SUBTOTAL(3,$C$8:C30))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C31=\"\",\"\",SUBTOTAL(3,$C$8:C31))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C32=\"\",\"\",SUBTOTAL(3,$C$8:C32))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C33=\"\",\"\",SUBTOTAL(3,$C$8:C33))","v":""},null,null,null,null,null,null,null,""]
[{"$f":"IF(C34=\"\",\"\",SUBTOTAL(3,$C$8:C34))","v":""},null,null,null,null,null,null,null,""]
[{"$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":"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(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(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":""}]
[0,null,null,null,null,null,null,null,""]
["00:00:00",{"$f":"   \"فقط : \" & ArbNum2Text(C2)","v":{"$error":"#NAME?"}}]
["00:00:00"]
["00:00:00",null,"محل عبا د الرحمن للمفروشات الحديثة"]
["00:00:00",null,"بيع وتصنيع احدث موديلات الستائر  - بيع جميع أنواع السجاد"]
["00:00:00",null,"العنوان الحصوة - بجوار - كبدة الإحرازي - 01006954268   - 01111602430",null,null,null,null,null,null,"الوقت"]
["00:00:00",null,null,null,null,{"$f":"IF(C103<>\"\",IF(F103=\"\",NOW(),F103),\"\")","v":""},null,null,null,{"$f":"NOW()","v":43489.412837037038}]
["******************************************************************************************************************************************************************************************************************************************************"]
[null,null,null,null,null,5]
[]
[null,null,null,null,null,5]
[]
[null,null,null,null,null,5]