{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["الاكواد","اليوميه"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"الاكواد","index":0,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,0,1,3]]}
["كود الصنف","اسم الصنف","الوارد","المنصرف"]
["المطلوب تنفيذ داله sumif  فى محرر الاكواد كما هى موجوده فى المعادله"]
["BMW-014","F30 BMW 320i / 2012",{"$f":"SUMIF(اليوميه!$A$1:$A$1048575,A3,اليوميه!$C$1:$C$1048575)","v":10},{"$f":"SUMIF(اليوميه!$A$1:$A$1048575,A3,اليوميه!$D$1:$D$1048575)","v":5}]
["BMW-013","B.M.W 523 / 97  ( E39 )    ",{"$f":"SUMIF(اليوميه!$A$1:$A$1048575,A4,اليوميه!$C$1:$C$1048575)","v":5},{"$f":"SUMIF(اليوميه!$A$1:$A$1048575,A4,اليوميه!$D$1:$D$1048575)","v":3}]
["BMW-011","B.M.W 525 / 89 - 95  ( E34 )  ",{"$f":"SUMIF(اليوميه!$A$1:$A$1048575,A5,اليوميه!$C$1:$C$1048575)","v":3},{"$f":"SUMIF(اليوميه!$A$1:$A$1048575,A5,اليوميه!$D$1:$D$1048575)","v":0}]
["BMW-012","B.M.W 523-525 / 2010-2015 ( F10 )",{"$f":"SUMIF(اليوميه!$A$1:$A$1048575,A6,اليوميه!$C$1:$C$1048575)","v":2},{"$f":"SUMIF(اليوميه!$A$1:$A$1048575,A6,اليوميه!$D$1:$D$1048575)","v":0}]
["BMW-002","B.M.W 318 - 320 / 98 - 2000 (E46)",{"$f":"SUMIF(اليوميه!$A$1:$A$1048575,A7,اليوميه!$C$1:$C$1048575)","v":3},{"$f":"SUMIF(اليوميه!$A$1:$A$1048575,A7,اليوميه!$D$1:$D$1048575)","v":0}]
["BMW-017","B.M.W  525-550 / 2004 (E60)",{"$f":"SUMIF(اليوميه!$A$1:$A$1048575,A8,اليوميه!$C$1:$C$1048575)","v":5},{"$f":"SUMIF(اليوميه!$A$1:$A$1048575,A8,اليوميه!$D$1:$D$1048575)","v":0}]

{"sheet":"اليوميه","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["كود","اسم الصنف","الكميه الوارده","الكميه المنصرفه"]
["BMW-014","F30 BMW 320i / 2012",10]
["BMW-013","B.M.W 523 / 97  ( E39 )    ",5]
["BMW-011","B.M.W 525 / 89 - 95  ( E34 )  ",3]
["BMW-012","B.M.W 523-525 / 2010-2015 ( F10 )",2]
["BMW-002","B.M.W 318 - 320 / 98 - 2000 (E46)",3]
["BMW-017","B.M.W  525-550 / 2004 (E60)",5]
["BMW-014","F30 BMW 320i / 2012",null,5]
["BMW-013","B.M.W 523 / 97  ( E39 )    ",null,3]