Spreadsheet: 821073d1678433096-calculation-of-best-share-percentage-for-taxes-returns-nouveau-microsoft-excel-worksheet-avk
Sheet: Sheet2

% | MAC | SAM | FD | PAT |  |  | Name | Combination | Total |  | Name | Combination | Total
1 | 4051.3 | 8787.18 | 5377.15 | -124.05 |  |  | MAC | 10 |  |  | MAC | 60
2 | 4408.09 | 9048.57 | 5617.21 | 118.41 |  |  | PAT | 20 |  |  | PAT | 17
3 | 4715.28 | 9309.98 | 5857.29 | 360.88 |  |  | SAM | 30 |  |  | SAM | 10
4 | 4951.54 | 9561.61 | 6097.35 | 603.36 |  |  | FD | 40 |  |  | FD | 13
5 | 5187.81 | 9799.66 | 6337.41 | 845.81
6 | 5424.07 | 10037.71 | 6577.48 | 1088.3
7 | 5660.34 | 10296.47 | 6817.56 | 1330.77
8 | 5896.61 | 10566.47 | 7057.62 | 1573.23
9 | 6132.87 | 10836.46 | 7297.69 | 1815.71
10 | 6369.14 | 11106.48 | 7537.77 | 2058.18
11 | 6605.4 | 11376.47 | 7777.84 | 2300.66
12 | 6841.66 | 11621.25 | 8017.9 | 2543.12
13 | 7077.93 | 11844.42 | 8256.54 | 2785.6 |  |  | yellow exemple
14 | 7314.19 | 12051.87 | 8467.27 | 3028.06 |  |  | total pourcentage of each of them equal 100%( 10+30+40+20)
15 | 7550.45 | 12243.09 | 8677.99 | 3270.53 |  |  | total sum
16 | 7786.71 | 12434.32 | 8888.71 | 3513
17 | 8022.97 | 12647.75 | 9099.45 | 3755.48 |  |  | red exemple
18 | 8259.24 | 12875.46 | 9310.17 | 3997.94 |  |  | total pourcentage of ech of the equal 100%(60+10+13+17)
19 | 8495.5 | 13086.26 | 9492.55 | 4240.42 |  |  | total sum
20 | 8731.76 | 13282.25 | 9672.3 | 4482.88
21 | 8968.03 | 13478.24 | 9853.69 | 4725.37 |  |  | as yo ucan see red exemple give better total sum. I need to find the optimal combinaison sumà
22 | 9204.29 | 13674.23 | 10035.09 | 4967.82
23 | 9440.56 | 13749.75 | 10216.5 | 5210.3
24 | 9676.82 | 13754.5 | 10397.9 | 5452.77
25 | 9913.09 | 13759.26 | 10579.3 | 5695.24
26 | 10149.35 | 13764.02 | 10760.71 | 5937.71
27 | 10385.61 | 13768.78 | 10942.11 | 6171.77
28 | 10621.88 | 13773.54 | 11123.51 | 6384.89
29 | 10858.14 | 13778.3 | 11304.92 | 6598.03
30 | 11094.4 | 13783.06 | 11486.33 | 6811.16
31 | 11330.66 | 13787.82 | 11667.72 | 7024.29
32 | 11568.44 | 13792.57 | 11849.12 | 7237.42
33 | 11808.51 | 13797.33 | 12030.53 | 7450.55
34 | 12048.58 | 13802.09 | 12211.94 | 7644.13
35 | 12288.66 | 13806.85 | 12393.32 | 7825.52
36 | 12528.72 | 13811.61 | 12574.75 | 8006.93
37 | 12768.79 | 13816.37 | 12756.14 | 8188.34
38 | 13008.87 | 13821.13 | 12937.54 | 8369.73
39 | 13248.94 | 13825.89 | 13118.95 | 8551.15
40 | 13489 | 13830.64 | 13300.35 | 8732.55
41 | 13729.08 | 13835.4 | 13481.76 | 8913.96
42 | 13969.06 | 13840.16 | 13663.15 | 9095.36
43 | 14179.79 | 13844.92 | 13862.73 | 9276.77
44 | 14390.52 | 13849.68 | 14080.88 | 9458.17
45 | 14601.25 | 13854.44 | 14304.61 | 9639.57
46 | 14811.97 | 13859.2 | 14556.93 | 9820.98
47 | 15022.7 | 13863.96 | 14905.14 | 10022.84
48 | 15237.52 | 13868.72 | 15255.87 | 10240.72
49 | 15434.36 | 13873.47 | 15606.33 | 10458.61
50 | 15631.21 | 13878.23 | 15956.81 | 10694.13
51 | 15828.06 | 13882.99 | 16307.24 | 10948.76
52 | 16024.92 | 13883.15 | 16657.7 | 11203.37
53 | 16221.75 | 13883.15 | 16984.18 | 11458
54 | 16418.61 | 13883.15 | 17302.91 | 11712.62
55 | 16615.47 | 13883.15 | 17621.63 | 11967.24
56 | 16812.3 | 13883.15 | 17940.37 | 12221.88
57 | 17009.16 | 13883.15 | 18259.11 | 12476.5
58 | 17206.01 | 13883.15 | 18628.57 | 12731.21
59 | 17402.87 | 13883.15 | 18933.22 | 12985.7
60 | 17599.7 | 13883.15 | 19232.97 | 13258.95
61 | 17796.56 | 13883.15 | 19532.72 | 13609.4
62 | 17993.41 | 13883.15 | 19832.49 | 13959.85
63 | 18190.26 | 13883.15 | 20055.47 | 14310.31
64 | 18373.93 | 13883.15 | 20256.25 | 14660.78
65 | 18552.94 | 13883.15 | 20457.03 | 15011.21
66 | 18731.94 | 13883.15 | 20657.81 | 15361.69
67 | 18910.94 | 13883.15 | 20858.58 | 15712.15
68 | 19089.95 | 13883.15 | 21059.37 | 16063.31
69 | 19268.95 | 13883.15 | 21260.15 | 16445.51
70 | 19447.96 | 13883.15 | 21460.93 | 16827.68
71 | 19626.96 | 13883.15 | 21661.7 | 17209.88
72 | 19805.97 | 13883.15 | 21838.75 | 17543.03
73 | 19984.96 | 13883.15 | 21911.75 | 17780.28
74 | 20163.98 | 13883.15 | 21944.04 | 17981.06
75 | 20342.97 | 13883.15 | 21953.59 | 18181.84
76 | 20659.64 | 13883.15 | 21963.14 | 18382.62
77 | 21002.9 | 13883.15 | 21972.69 | 18583.4
78 | 21346.17 | 13883.15 | 21982.24 | 18784.18
79 | 21689.43 | 13883.15 | 21991.78 | 18984.96
80 | 22032.71 | 13883.15 | 22001.34 | 19185.74
81 | 22378.28 | 13883.15 | 22010.89 | 19386.52
82 | 22728.74 | 13883.15 | 22020.44 | 19587.3
83 | 23093.14 | 13883.15 | 22029.99 | 19788.08
84 | 23475.35 | 13883.15 | 22039.54 | 19982.96
85 | 23857.53 | 13883.15 | 22049.09 | 20120.29
86 | 24239.71 | 13883.15 | 22058.64 | 20203.41
87 | 24621.89 | 13883.15 | 22068.19 | 20212.96
88 | 25004.08 | 13883.15 | 22077.74 | 20222.51
89 | 25371.28 | 13883.15 | 22087.29 | 20232.07
90 | 25671.04 | 13883.15 | 20096.84 | 20241.62
91 | 25894.24 | 13883.15 | 22106.39 | 20251.17
92 | 26095.02 | 13883.15 | 22109.22 | 20260.72
93 | 26295.8 | 13883.15 | 22109.22 | 20270.27
94 | 26496.58 | 13883.15 | 22109.22 | 20279.81
95 | 26697.36 | 13883.15 | 22109.22 | 20289.37
96 | 26898.15 | 13883.15 | 22109.22 | 20298.92
97 | 27098.93 | 13883.15 | 22109.22 | 20308.47
98 | 27299.69 | 13883.15 | 22109.22 | 20318.02
99 | 27468.08 | 13883.15 | 22109.22 | 20327.57
100 | 2760.05 | 13883.15 | 22109.22 | 20337.12