sangeethajaikumar
New Member
- Joined
- Jan 31, 2019
- Messages
- 2
I have a target sum to achieve with some constrains such as - individual numbers have a constant divisor, variable must be of 2 decimals only and sum target for 2 out of 5 data.
The grand total of the row totals must be 62,185.
I tried to use solver, but got stuck.
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Divisor[/TD]
[TD]Hours[/TD]
[TD]Row Total (2 decimals only)[/TD]
[/TR]
[TR]
[TD]74.03[/TD]
[TD]variable of 2 decimals[/TD]
[TD]Product of Divisor & Hours[/TD]
[/TR]
[TR]
[TD]74.03[/TD]
[TD]variable of 2 decimals[/TD]
[TD]Product of Divisor & Hours[/TD]
[/TR]
[TR]
[TD]74.03[/TD]
[TD]variable of 2 decimals[/TD]
[TD]Product of Divisor & Hours[/TD]
[/TR]
[TR]
[TD]74.03[/TD]
[TD]variable of 2 decimals[/TD]
[TD]Product of Divisor & Hours[/TD]
[/TR]
[TR]
[TD]74.03[/TD]
[TD]variable of 2 decimals[/TD]
[TD]Product of Divisor & Hours[/TD]
[/TR]
[TR]
[TD]94.08[/TD]
[TD]variable of 2 decimals[/TD]
[TD]Product of Divisor & Hours[/TD]
[/TR]
</tbody>[/TABLE]
The grand total of the row totals must be 62,185.
I tried to use solver, but got stuck.
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Divisor[/TD]
[TD]Hours[/TD]
[TD]Row Total (2 decimals only)[/TD]
[/TR]
[TR]
[TD]74.03[/TD]
[TD]variable of 2 decimals[/TD]
[TD]Product of Divisor & Hours[/TD]
[/TR]
[TR]
[TD]74.03[/TD]
[TD]variable of 2 decimals[/TD]
[TD]Product of Divisor & Hours[/TD]
[/TR]
[TR]
[TD]74.03[/TD]
[TD]variable of 2 decimals[/TD]
[TD]Product of Divisor & Hours[/TD]
[/TR]
[TR]
[TD]74.03[/TD]
[TD]variable of 2 decimals[/TD]
[TD]Product of Divisor & Hours[/TD]
[/TR]
[TR]
[TD]74.03[/TD]
[TD]variable of 2 decimals[/TD]
[TD]Product of Divisor & Hours[/TD]
[/TR]
[TR]
[TD]94.08[/TD]
[TD]variable of 2 decimals[/TD]
[TD]Product of Divisor & Hours[/TD]
[/TR]
</tbody>[/TABLE]