{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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":"Sheet1","index":0,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Employee Name","Total Target","المنتج 1","المنتج 2","المنتج 3","المنتج 4","المنتج 5","المنتج 6","المنتج 7","Mix Total Sales** "]
["المستهدف",{"$f":"SUM(C2:I2)","v":3050000},850000,1500000,50000,200000,200000,50000,200000,350000,"هما تحت كل منتج مستهدف المبيعات"]
["المبيعات ومجموعها",{"$f":"SUM(C3:I3)","v":2510000},800000,1500000,50000,10000,0,50000,100000,{"$f":"E3+F3+G3+H3+I3","v":210000},"هما تحت كل منتج مبلغ المبيعات"]
[null,null,{"$f":"C3/C2","v":0.94117647058823528},1,1,0.05,0,1,0.5,0.6,"نسبة المحقق من المستهدف"]
["معادل العمولة",null,{"$f":"IF(AND(C4>=90%,C4<=99.99%),10,IF(AND(C4>=100%,C4<=119.99%),15,IF(AND(C4>=120%,C4<=149.99%),20,IF(C4>=150%,25,0))))","v":10},{"$f":"IF(AND(D4>=90%,D4<=99.99%),10,IF(AND(D4>=100%,D4<=119.99%),15,IF(AND(D4>=120%,D4<=149.99%),20,IF(D4>=150%,25,0))))","v":15},15,{"$f":"IF(AND(F4>=90%,F4<=99.99%),20,IF(AND(F4>=100%,F4<=119.99%),30,IF(AND(F4>=120%,F4<=149.99%),40,IF(F4>=150%,60,0))))","v":0},0,15,{"$f":"IF(AND(I4>=90%,I4<=99.99%),10,IF(AND(I4>=100%,I4<=119.99%),15,IF(AND(I4>=120%,I4<=149.99%),20,IF(I4>=150%,25,0))))","v":0},{"$f":"IF(AND(J4>=90%,J4<=99.99%),10,IF(AND(J4>=100%,J4<=119.99%),15,IF(AND(J4>=120%,J4<=149.99%),20,IF(J4>=150%,25,0))))","v":0},"هنا شريحة العمولة في حال حقق اقل نسبة 90% واعلى وعند الضغط على أي خلية ستجد معادلة"]
[null,null,{"$f":"C3/1000*C5/2","v":4000},{"$f":"D3/1000*D5/2","v":11250},375,0,0,375,0,null,"هنا ستكون العمولة في حال تحققت الشروط في مربع الحوار ادناه"]
[null,null,{"$f":"IF(AND($G$6=0,$J$6=0,E3=0),C6/2,C6)","v":4000},{"$f":"IF(AND($G$6=0,$J$6=0,F3=0),D6/2,D6)","v":11250}]
[]
[null,{"$f":"getBonus(C2)","v":"15250        =          4000             ,            11250             ,            0             ,            0             ,            0             ,            0             ,            0"}]