{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["حساب","شهر3"],"not_rendered":{"charts":0,"images":0,"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":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[9,1,10,7],[0,0,0,1],[7,6,7,7],[1,2,1,3],[2,2,2,3],[4,3,4,5],[1,4,1,5],[2,4,2,5]]}
[]
["رقم المستند","الاسم","تاريخ صرف الاستحقاق",null,"رقم موبايل السائق",null,"الاستحقاق",{"$f":"SUBTOTAL(9,B7:B7,G7:G7)","v":0}]
[1088684,null,{"$f":"NOW()","v":"2021-06-27T17:04:48.300"},null,null,null,"طرح مبلغ النقص",{"$f":"SUM(C7)*750","v":0}]
[{"$f":"VLOOKUP(A3,شهر3!$A$1:$G$13,3,FALSE)","v":0},"رقم الوصل",null,null,null,null,"طرح المندوبية والمكتبية",{"$f":"SUBTOTAL(9,D7:D9,E7:E9)","v":0}]
[{"$f":"VLOOKUP(A3,شهر3!$A$1:$G$13,2,FALSE)","v":"عام"},null,null,"وصل صرف استحقاق سائق",null,null,"صافي الاستحقاق",{"$f":"H2-H3-H4","v":0}]
["التاريخ","الاستحقاق","النقص","المندوبية","المكتبية","المحطة","استحقاق المحطة","رقم السيارة"]
[{"$f":"VLOOKUP($A$3,شهر3!$A$1:$G$13,6,FALSE)","v":"2021-06-13"},null,null,null,null,null,null,{"$f":"VLOOKUP($A$3,شهر3!$A$1:$G$13,7,FALSE)","v":7901358}]
[null,null,null,null,null,null,{"$f":"IF(H5=\"\",\"\",numtotxt(H5,\"دينار\",\"فلس\"))","v":"صفر"}]
[]
[null,"تعديل على كود طبع الوصل  في حالة تكرار الطبع  مرتين يعلمني بانه سبق وتم طبع الوصل وفي هذه الحالة يتم الاختيار أما بتكرار الطبع أو الغاء الطبع"]

{"sheet":"شهر3","index":1,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["رقم المستند","عام/خاص","الداخلي","المحور","المنتوج","التاريخ","رقم السيارة"]
[1088684,"عام",null,null,null,"2021-06-13",7901358]
[1097328,"عام",null,null,null,"2021-06-13",55469]
[1097329,"عام",null,null,null,"2021-06-13",51020]
[1097330,"عام",null,null,null,"2021-06-13",66230]
[1097342,"خاص",null,null,null,"2021-06-13",55120]
[1097341,"خاص",null,null,null,"2021-06-13",562012]
[1088776,"عام",null,null,null,"2021-06-13",51303]
[1088699,"عام",null,null,null,"2021-06-13",6090]
[1088607,"عام",null,null,null,"2021-06-08",30601]
[870865,"عام",null,null,null,"2021-06-08",15211]
[1088608,"عام",null,null,null,"2021-06-08",62603]
[1088610,"عام",null,null,null,"2021-06-08",1101]