Excel Math Program With Remainders
Budget: $30 – $250 USD
Need an excel program with following criteria:
1. You input 1 to 4 Divisors
2. The program will look at all Dividends given in another sheet
3. Outputs lowest to highest remainder from given selection of dividends
4. If more than 1 divisor, it will calculate which dividend outputs lowest remainder with how the divisors were divided into dividend.
Example 1
Dividend = 42, 50, 61, 61, 45.5 (user uploaded to sheet)
Divisor = 10 (from user)
Remainder = 2, 0, 1, 1, 1.5 (output shows highest to lowest in color change conditional formatting)
Example 2
Dividend = 42, 50, 61, 61, 45.5 (user uploaded to sheet)
Divisor = 11, 13.5, 10(from user up to 4 variables)
Remainder =
(output remainder shows highest to lowest in color change conditional formatting)
(Output shows all combinations from best combination with lowest remainder to combinationwith highest)
42:
1, 1, 1, rem 7.5
Etc.
50:
1, 1, 2, rem 5.5
1, 2, 1, rem 2
2, 1, 1, rem 4.5
61:
1, 1, 2, rem 6.5
1, 2, 1, rem 3
2, 1, 2, rem 5.5
2, 2, 1, rem 2
3, 1, 1, rem 4.5
1, 3, 0, rem 9.5
2, 3, 0, rem 8.5
3, 2, 0, rem 1
45.5:
1, 1, 2 rem 1
1, 2, 0, rem 7.5
2, 1, 1, rem 0
Etc.
1. You input 1 to 4 Divisors
2. The program will look at all Dividends given in another sheet
3. Outputs lowest to highest remainder from given selection of dividends
4. If more than 1 divisor, it will calculate which dividend outputs lowest remainder with how the divisors were divided into dividend.
Example 1
Dividend = 42, 50, 61, 61, 45.5 (user uploaded to sheet)
Divisor = 10 (from user)
Remainder = 2, 0, 1, 1, 1.5 (output shows highest to lowest in color change conditional formatting)
Example 2
Dividend = 42, 50, 61, 61, 45.5 (user uploaded to sheet)
Divisor = 11, 13.5, 10(from user up to 4 variables)
Remainder =
(output remainder shows highest to lowest in color change conditional formatting)
(Output shows all combinations from best combination with lowest remainder to combinationwith highest)
42:
1, 1, 1, rem 7.5
Etc.
50:
1, 1, 2, rem 5.5
1, 2, 1, rem 2
2, 1, 1, rem 4.5
61:
1, 1, 2, rem 6.5
1, 2, 1, rem 3
2, 1, 2, rem 5.5
2, 2, 1, rem 2
3, 1, 1, rem 4.5
1, 3, 0, rem 9.5
2, 3, 0, rem 8.5
3, 2, 0, rem 1
45.5:
1, 1, 2 rem 1
1, 2, 0, rem 7.5
2, 1, 1, rem 0
Etc.