{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["anbardari","Resid","Resid (2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"anbardari","index":0,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["شماره رسید","نام کالا","شخص","ورود","خروج","محل استفاده","تاریخ","مانده در لحظه"]
[29616,"خودکار","مریم",5,null,null,null,{"$f":"SUMIF(B$2:B2,B2,D$2:D2)-SUMIF(B$2:B2,B2,E$2:E2)","v":5},null,null,"نام کالا","مانده","مانده بحرانی",null,"اشخاص","محلهای استفاده"]
[15562,"خط کش","بیژن",6,null,null,null,{"$f":"SUMIF(B$2:B3,B3,D$2:D3)-SUMIF(B$2:B3,B3,E$2:E3)","v":6},null,null,"دفتر",{"$f":"SUMIF(B:B,K3,D:D)-SUMIF(B:B,K3,E:E)","v":0},null,null,"پیمان"]
[13950,"ماژیک","بیژن",10,null,null,null,{"$f":"SUMIF(B$2:B4,B4,D$2:D4)-SUMIF(B$2:B4,B4,E$2:E4)","v":10},null,null,"مداد",{"$f":"SUMIF(B:B,K4,D:D)-SUMIF(B:B,K4,E:E)","v":24},null,null,"مریم"]
[91646,"خط کش","سهیلا",5,null,null,null,{"$f":"SUMIF(B$2:B5,B5,D$2:D5)-SUMIF(B$2:B5,B5,E$2:E5)","v":11},null,null,"خط کش",2,null,null,"جواد"]
[33085,"ماژیک","پیمان",2,null,null,null,{"$f":"SUMIF(B$2:B6,B6,D$2:D6)-SUMIF(B$2:B6,B6,E$2:E6)","v":12},null,null,"خودکار",1,null,null,"بیژن"]
[47476,"کاغذ","سهیلا",3,null,null,null,{"$f":"SUMIF(B$2:B7,B7,D$2:D7)-SUMIF(B$2:B7,B7,E$2:E7)","v":3},null,null,"کاغذ",1,null,null,"سهیلا"]
[59972,"مداد","مریم",10,null,null,null,{"$f":"SUMIF(B$2:B8,B8,D$2:D8)-SUMIF(B$2:B8,B8,E$2:E8)","v":10},null,null,"ماژیک",9]
[45417,"خط کش","جواد",null,6,null,null,{"$f":"SUMIF(B$2:B9,B9,D$2:D9)-SUMIF(B$2:B9,B9,E$2:E9)","v":5}]
[14508,"خودکار","سهیلا",null,4,null,null,{"$f":"SUMIF(B$2:B10,B10,D$2:D10)-SUMIF(B$2:B10,B10,E$2:E10)","v":1}]
[15188,"کاغذ","پیمان",null,2,null,null,{"$f":"SUMIF(B$2:B11,B11,D$2:D11)-SUMIF(B$2:B11,B11,E$2:E11)","v":1}]
[80825,"مداد","مریم",null,1,null,null,{"$f":"SUMIF(B$2:B12,B12,D$2:D12)-SUMIF(B$2:B12,B12,E$2:E12)","v":9}]
[43695,"دفتر","بیژن",5,null,null,null,{"$f":"SUMIF(B$2:B13,B13,D$2:D13)-SUMIF(B$2:B13,B13,E$2:E13)","v":5}]
[84603,"خط کش","سهیلا",null,3,null,null,{"$f":"SUMIF(B$2:B14,B14,D$2:D14)-SUMIF(B$2:B14,B14,E$2:E14)","v":2}]
[59972,"مداد","بیژن",10]
[99999999,"دفتر",null,null,10]
[11111,"مداد",null,null,5]
[11111]
[11111,"مداد","جواد",5]
[8888,"دفتر","بیژن",5]
[3333,"ماژیک","مریم",null,3]
[5522,"مداد","پیمان",2]
[789,"مداد","سهیلا",3]

{"sheet":"Resid","index":1,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[{"$f":"VLOOKUP(G6,anbardari!A:H,2,0)","v":"مداد"}]
[null,null,null,null,null,"رسید تحویل کالا"]
[]
[null,null,null,null,null,null,59972,"شماره رسید:"]
[]
[null,null,null,null,null,null,"محل استفاده",{"$f":"VLOOKUP($G$6,anbardari!A:H,ROW(anbardari!A2),0)","v":"مداد"},"نام کالا"]
[null,null,null,null,null,null,"تاریخ",{"$f":"VLOOKUP($G$6,anbardari!A:H,ROW(anbardari!A3),0)","v":"مریم"},"شخص"]
[null,null,null,null,null,null,"مانده در لحظه",{"$f":"VLOOKUP($G$6,anbardari!A:H,ROW(anbardari!A4),0)","v":10},"ورود"]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP($G$6,anbardari!A:H,ROW(anbardari!A5),0)","v":0},"خروج"]

{"sheet":"Resid (2)","index":2,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"ثبت ورود و خروج کالا با ماکرو"]
[]
[null,null,null,null,null,null,null,"شماره رسید:"]
[]
[null,null,null,null,null,null,"تاریخ",null,"نام کالا"]
[null,null,null,null,null,null,"مانده در لحظه",null,"شخص"]
[null,null,null,null,null,null,null,null,"ورود"]
[null,null,null,null,null,null,null,null,"خروج"]