Spreadsheet: 877369d1724186344-how-to-adress-one-result-despite-many-same-conditions-sometimes-classeur3
Sheet: Liste_2

 |  |  | Monthly Rate | Env |  |  |  | Monthly Rate | Valeur | Expected results |  | C0 | 63921
 |  | 1BOCLE | 13671.27272727273 | 5500 |  |  | SRS | 13671.27272727273 | 7000 | SRS1 or SRS2… SRS5 |  | C1 | 50819.99999999999
 |  | 1BOCLS | 9464.727272727272 | 5500 |  |  | SRT | 9464.727272727272 | 7000 | SRT1 or SRT2… SRT5 |  | C2 | 37719
 |  | 1BOCEE | 12619.63636363636 | 5500 |  |  | SRS | 12619.63636363636 | 7000 | SRS1 or SRS2… SRS5 |  | [NAME] | 36333
 |  | 1BOCES | 9464.727272727272 | 5500 |  |  | SRT | 9464.727272727272 | 7000 | SRT1 or SRT2… SRT5 |  | C4 | 20196
 |  | 1TTEEP | 27660 | 6000 |  |  | C | 27660 | 20196 | C4 |  | R0 | 47388.00000000001
 |  | 1TTEES | 31836 | 6000 |  |  | C | 31836 | 36333 |  |  | R1 | 41877
 |  | 1TTEEE | 38700 | 6000 |  |  | C | 38700 | 37719 |  |  | R2 | 32637
 |  | 1T-TEP | 22762 | 5500 |  |  | C | 22762 | 20196 |  |  | R3 | 26796
 |  | 1T-TES | 27402 | 5500 |  |  | C | 27402 | 20196 |  |  | R4 | 22671
 |  | 1T-T-EE | 30834 | 5500 |  |  | C | 30834 | 36333 |  |  | R5 | 18447
 |  | 1TASEJ | 17864 | 5500 |  |  | CTRS | 17864 | 17000 |  |  | CTRS0 | 57000
 |  | 1TASES | 22968 | 5500 |  |  | CTRT | 22968 | 24000 |  |  | CTRS1 | 45000
 |  | 1TASLJ | 10718.4 | 0 |  |  | Nat RS | 10718.4 | 10000 |  |  | CTRS2 | 35200
 |  | 1TASLS | 13780.8 | 0 |  |  | Nat RT | 13780.8 | 15000 |  |  | CTRS3 | 27500
 |  | 2BOCLE | 12619.63636363636 | 0 |  |  | SRS | 12619.63636363636 | 7000 |  |  | CTRS4 | 19800
 |  | 2BOCLS | 9464.727272727272 | 0 |  |  | SRT | 9464.727272727272 | 7000 |  |  | CTRS5 | 17000
 |  | 2BOCEE | 12619.63636363636 | 0 |  |  | SRS | 12619.63636363636 | 7000 |  |  | CTRT0 | 60000
 |  | 2BOCES | 9464.727272727272 | 0 |  |  | SRT | 9464.727272727272 | 7000 |  |  | CTRT1 | 46000
 |  | 2TTEEP | 10718.4 | 4000 |  |  | C | 10718.4 | 20196 |  |  | [NAME] | 36000
 |  | 2TTEES | 13054.8 | 4000 |  |  | C | 13054.8 | 20196 |  |  | CTRT3 | 28000
 |  | 2TTEEE | 16750.8 | 4000 |  |  | C | 16750.8 | 20196 |  |  | CTRT4 | 24000
 |  | 2T-TEP | 14359.2 | 4000 |  |  | C | 14359.2 | 20196 |  |  | CTRT5 | 20000
 |  | 2T-TES | 18860.73333333333 | 4000 |  |  | C | 18860.73333333333 | 20196 |  |  | Nat RS 1 | 20000
 |  | 2T-T-EE | 20708.73333333333 | 4000 |  |  | C | 20708.73333333333 | 20196 |  |  | Nat RS 2 | 15000
 |  | 2TASEJ | 18000 | 4000 |  |  | CTRS | 18000 |  |  |  | Nat RS 3 | 10000
 |  | 2TASES | 24666.66666666666 | 4000 |  |  | CTRT | 24666.66666666666 |  |  |  | Nat RS 4 | 6000
 |  | 2TASLJ | 17864 | 0 |  |  | Nat RS | 17864 |  |  |  | Nat RS 5 | 4000
 |  | 2TASLS | 22968 | 0 |  |  | Nat RT | 22968 |  |  |  | Nat RT 1
 |  | 3BOCLE | 12619.63636363636 | 5500 |  |  | SRS | 12619.63636363636 |  |  |  | Nat RT 2 | 22000
 |  | 3BOCLS | 9464.727272727272 | 5500 |  |  | SRT | 9464.727272727272 |  |  |  | Nat RT 3 | 15000
 |  | 3BOCEE | 12619.63636363636 | 5500 |  |  | SRS | 12619.63636363636 |  |  |  | Nat RT 4 | 9000
 |  | 3BOCES | 9464.727272727272 | 5500 |  |  | SRT | 9464.727272727272 |  |  |  | Nat RT 5 | 6000
 |  | 3TTEEP | 27660 | 7724.305555555556 |  |  | C | 27660 | 27500 |  |  | SRS1 | 7000
 |  | 3TTEES | 31836 | 7724.305555555556 |  |  | C | 31836 | 35200 |  |  | SRS2 | 7000
 |  | 3TTEEE | 38700 | 7724.305555555556 |  |  | C | 38700 | 35200 |  |  | SRS3 | 7000
 |  | 3T-TEP | 18739.09090909091 | 7724.305555555556 |  |  | C | 18739.09090909091 | 19800 |  |  | SRS4 | 7000
 |  | 3T-TES | 26827.09090909091 | 7724.305555555556 |  |  | C | 26827.09090909091 | 27500 |  |  | SRS5 | 7000
 |  | 3T-T-EE | 30259.09090909091 | 7724.305555555556 |  |  | C | 30259.09090909091 | 36000 |  |  | SRT1 | 7000
 |  | 3TASEJ | 9818.18181818182 | 7724.305555555556 |  |  | CTRS | 9818.18181818182 |  |  |  | SRT2 | 7000
 |  | 3TASES | 21818.18181818182 | 7724.305555555556 |  |  | CTRT | 21818.18181818182 |  |  |  | SRT3 | 7000
 |  | 3TASLJ | 9818.18181818182 | 7724.305555555556 |  |  | Nat RS | 9818.18181818182 |  |  |  | SRT4 | 7000
 |  | 3TASLS | 21818.18181818182 | 7724.305555555556 |  |  | Nat RT | 21818.18181818182 |  |  |  | SRT5 | 7000
 |  | 4BOCLE | 12619.63636363636 | 5500 |  |  | SRS | 12619.63636363636 |  |  |  | TEO | 76278.40000000001
 |  | 4BOCLS | 9464.727272727272 | 5500 |  |  | SRT | 9464.727272727272 |  |  |  | TSO | 51884.8
 |  | 4BOCEE | 12619.63636363636 | 5500 |  |  | SRS | 12619.63636363636 |  |  |  | TPO | 37558.4
 |  | 4BOCES | 9464.727272727272 | 5500 |  |  | SRT | 9464.727272727272 |  |  |  | TTO | 26716.8
 |  | 4TTEEP | 27660 | 7724.305555555556 |  |  | C | 27660 | 15000 |  |  | EO | 76278.40000000001
 |  | 4TTEES | 31836 | 7724.305555555556 |  |  | C | 31836 | 22000 |  |  | SO | 51884.8
 |  | 4TTEEE | 38700 | 7724.305555555556 |  |  | C | 38700 | 22000 |  |  | PO | 37558.4
 |  | 4T-TEP | 18739.09090909091 | 7724.305555555556 |  |  | C | 18739.09090909091 | 22000 |  |  | TO | 26716.8
 |  | 4T-TES | 26827.09090909091 | 7724.305555555556 |  |  | C | 26827.09090909091
 |  | 4T-T-EE | 30259.09090909091 | 7724.305555555556 |  |  | C | 30259.09090909091
 |  | 4TASEJ | 9818.18181818182 | 7724.305555555556 |  |  | CTRS | 9818.18181818182
 |  | 4TASES | 21818.18181818182 | 7724.305555555556 |  |  | CTRT | 21818.18181818182
 |  | 4TASLJ | 9818.18181818182 | 7724.305555555556 |  |  | Nat RS | 9818.18181818182
 |  | 4TASLS | 21818.18181818182 | 7724.305555555556 |  |  | Nat RT | 21818.18181818182
 |  | 5BOCLE | 12619.63636363636 | 5500 |  |  | SRS | 12619.63636363636
 |  | 5BOCLS | 9464.727272727272 | 5500 |  |  | SRT | 9464.727272727272
 |  | 5BOCEE | 12619.63636363636 | 5500 |  |  | SRS | 12619.63636363636
 |  | 5BOCES | 9464.727272727272 | 5500 |  |  | SRT | 9464.727272727272
 |  | 5TTEEP | 27660 | 6000 |  |  | C | 27660
 |  | 5TTEES | 31836 | 6000 |  |  | C | 31836
 |  | 5TTEEE | 38700 | 6000 |  |  | C | 38700
 |  | 5T-TEP | 22762 | 5500 |  |  | C | 22762
 |  | 5T-TES | 27402 | 5500 |  |  | C | 27402
 |  | 5T-T-EE | 30834 | 5500 |  |  | C | 30834
 |  | 5TASEJ | 17864 | 5500 |  |  | CTRS | 17864
 |  | 5TASES | 22968 | 5500 |  |  | CTRT | 22968
 |  | 5TASLJ | 10718.4 | 0 |  |  | Nat RS | 10718.4
 |  | 5TASLS | 13780.8 | 0 |  |  | Nat RT | 13780.8
 |  | 6BOCLE | 12619.63636363636 | 5500 |  |  | SRS | 12619.63636363636
 |  | 6BOCLS | 9464.727272727272 | 5500 |  |  | SRT | 9464.727272727272
 |  | 6BOCEE | 12619.63636363636 | 5500 |  |  | SRS | 12619.63636363636
 |  | 6BOCES | 9464.727272727272 | 5500 |  |  | SRT | 9464.727272727272
 |  | 6TTEEP | 27660 | 7724.305555555556 |  |  | C | 27660
 |  | 6TTEES | 31836 | 7724.305555555556 |  |  | C | 31836
 |  | 6TTEEE | 38700 | 7724.305555555556 |  |  | C | 38700
 |  | 6T-TEP | 18739.09090909091 | 7724.305555555556 |  |  | C | 18739.09090909091
 |  | 6T-TES | 26827.09090909091 | 7724.305555555556 |  |  | C | 26827.09090909091
 |  | 6T-T-EE | 30259.09090909091 | 7724.305555555556 |  |  | C | 30259.09090909091
 |  | 6TASEJ | 9818.18181818182 | 7724.305555555556 |  |  | CTRS | 9818.18181818182
 |  | 6TASES | 21818.18181818182 | 7724.305555555556 |  |  | CTRT | 21818.18181818182
 |  | 6TASLJ | 9818.18181818182 | 7724.305555555556 |  |  | Nat RS | 9818.18181818182
 |  | 6TASLS | 21818.18181818182 | 7724.305555555556 |  |  | Nat RT | 21818.18181818182