{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["الرئيسية","تسجيل البيعة","تسجيل المخزون","تسجيل التالف","المخزون","مبيعات الشهر","الاشهر","بطاقة المواد"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"تسجيل البيعة","index":1,"n_rows":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":false,"merged":[[14,8,14,9],[15,8,15,9],[8,8,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[7,8,7,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[5,8,5,9],[6,8,6,9]]}
[null,null,{"$f":"COLUMN()","v":3}]
["تسلسل","دالة",null,"2023-01-01","وقت الفاتورة",null,"رقم الفاتورة",150,"نوعها","تالف"]
[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":2,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["باركود الصنف","الصنف","الغرام","العدد"]
[]
[]
[]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,""]

{"sheet":"تسجيل التالف","index":3,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["باركود الصنف","الصنف","الغرام","العدد"]

{"sheet":"المخزون","index":4,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
["باركود الصنف","الصنف","المخزون"]
[{"$f":"'بطاقة المواد'!B3","v":15001},{"$f":"IFERROR(VLOOKUP(A4,'بطاقة المواد'!B$3:E$19,3),\"\")","v":"خمسين"}]
[{"$f":"'بطاقة المواد'!B4","v":10},{"$f":"IFERROR(VLOOKUP(A5,'بطاقة المواد'!B$3:E$19,3),\"\")","v":"عشرة"}]
[{"$f":"'بطاقة المواد'!B5","v":20},{"$f":"IFERROR(VLOOKUP(A6,'بطاقة المواد'!B$3:E$19,3),\"\")","v":"عشرين"}]
[{"$f":"'بطاقة المواد'!B6","v":30},{"$f":"IFERROR(VLOOKUP(A7,'بطاقة المواد'!B$3:E$19,3),\"\")","v":"تلاتين"}]
[{"$f":"'بطاقة المواد'!B7","v":40},{"$f":"IFERROR(VLOOKUP(A8,'بطاقة المواد'!B$3:E$19,3),\"\")","v":"اربعين"}]
[{"$f":"'بطاقة المواد'!B8","v":50},{"$f":"IFERROR(VLOOKUP(A9,'بطاقة المواد'!B$3:E$19,3),\"\")","v":"خمسين"}]
[{"$f":"'بطاقة المواد'!B9","v":0},{"$f":"IFERROR(VLOOKUP(A10,'بطاقة المواد'!B$3:E$19,3),\"\")","v":""}]
[{"$f":"'بطاقة المواد'!B10","v":0},{"$f":"IFERROR(VLOOKUP(A11,'بطاقة المواد'!B$3:E$19,3),\"\")","v":""}]
[{"$f":"'بطاقة المواد'!B11","v":0},{"$f":"IFERROR(VLOOKUP(A12,'بطاقة المواد'!B$3:E$19,3),\"\")","v":""}]
[{"$f":"'بطاقة المواد'!B12","v":0},{"$f":"IFERROR(VLOOKUP(A13,'بطاقة المواد'!B$3:E$19,3),\"\")","v":""}]
[{"$f":"'بطاقة المواد'!B13","v":0},{"$f":"IFERROR(VLOOKUP(A14,'بطاقة المواد'!B$3:E$19,3),\"\")","v":""}]
[{"$f":"'بطاقة المواد'!B14","v":0},{"$f":"IFERROR(VLOOKUP(A15,'بطاقة المواد'!B$3:E$19,3),\"\")","v":""}]
[{"$f":"'بطاقة المواد'!B15","v":0},{"$f":"IFERROR(VLOOKUP(A16,'بطاقة المواد'!B$3:E$19,3),\"\")","v":""}]
[{"$f":"'بطاقة المواد'!B16","v":0},{"$f":"IFERROR(VLOOKUP(A17,'بطاقة المواد'!B$3:E$19,3),\"\")","v":""}]
[{"$f":"'بطاقة المواد'!B17","v":0},{"$f":"IFERROR(VLOOKUP(A18,'بطاقة المواد'!B$3:E$19,3),\"\")","v":""}]
[{"$f":"'بطاقة المواد'!B18","v":0},{"$f":"IFERROR(VLOOKUP(A19,'بطاقة المواد'!B$3:E$19,3),\"\")","v":""}]
[{"$f":"'بطاقة المواد'!B19","v":0},{"$f":"IFERROR(VLOOKUP(A20,'بطاقة المواد'!B$3:E$19,3),\"\")","v":""}]
[{"$f":"'بطاقة المواد'!B20","v":0},{"$f":"IFERROR(VLOOKUP(A21,'بطاقة المواد'!B$3:E$19,3),\"\")","v":""}]
[{"$f":"'بطاقة المواد'!B21","v":0},{"$f":"IFERROR(VLOOKUP(A22,'بطاقة المواد'!B$3:E$19,3),\"\")","v":""}]
[{"$f":"'بطاقة المواد'!B22","v":0},{"$f":"IFERROR(VLOOKUP(A23,'بطاقة المواد'!B$3:E$19,3),\"\")","v":""}]
[{"$f":"'بطاقة المواد'!B23","v":0},{"$f":"IFERROR(VLOOKUP(A24,'بطاقة المواد'!B$3:E$19,3),\"\")","v":""}]
[{"$f":"'بطاقة المواد'!B24","v":0},{"$f":"IFERROR(VLOOKUP(A25,'بطاقة المواد'!B$3:E$19,3),\"\")","v":""}]

{"sheet":"مبيعات الشهر","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"الاشهر","index":6,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,0,1,12],[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,6,0,11]]}
["كود الصنف",null,null,null,"الصنف"]
[2023]
["الايام / الاشهر","يناير","فبراير","مارس","أبريل","مايو","يونيو","يوليو","أغسطس","سبتمبر","أكتوبر","نوفمبر","ديسمبر"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
["المجموع",{"$f":"SUM(B4:B34)","v":0},{"$f":"SUM(C4:C34)","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"بطاقة المواد","index":7,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
["مسلسل","رقم الباركود","باركود الصنف","الصنف","الجرام"]
[1,15001,{"$f":"\"*\"&B3&\"*\"","v":"*15001*"},"مواد خام",40]
[2,10,{"$f":"\"*\"&B4&\"*\"","v":"*10*"},"عشرة",4]
[3,20,"*20*","عشرين",3]
[4,30,"*30*","تلاتين",5]
[5,40,"*40*","اربعين",55]
[6,50,"*50*","خمسين",22]
[7,null,"**"]
[8,null,"**"]
[9,null,"**"]
[10,null,"**"]
[11,null,"**"]
[12,null,"**"]
[13,null,"**"]
[14,null,"**"]
[15,null,"**"]
[16,null,"**"]
[17,null,"**"]