walktall777
New Member
- Joined
- Sep 17, 2018
- Messages
- 1
Dear Forum,
I need some help as I have no idea how to tackle this challenge.
I have data in the following format (about 7000 records):
<tbody>
</tbody>
and need to do some calculations on it, and present it in this format:
User
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Any assistance would be greatly appreciated.
Kind regards,
walktall.
I need some help as I have no idea how to tackle this challenge.
I have data in the following format (about 7000 records):
User | Project Code | Transaction Date | Hours | Allocation | Category |
<tbody>
</tbody>
and need to do some calculations on it, and present it in this format:
User
Days in Month | 21 | |
Billable (have info) | 21 | |
Training (have info) | 0 | |
Presales (have info) | 0 | |
Leave (have info) | 0 | |
Bench (have info) | 0 | |
Rate (have) | 425 | |
Monthly Cost (have) | 5,446 | |
Earnings (calculation) | 8,919 | |
Profit (calculation) | 3,473 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Any assistance would be greatly appreciated.
Kind regards,
walktall.