I'm trying to figure out the best course of action to complete this template for all of our employees. If I have all of the raw data, how can I get it to spit out an individualized version of this template for each line? I will also have each employees name and a graph as well. I'd love everyone's advice!
| Total Compensation | $1.00 | ||
| Estimated Cash Compensation | $1.00 | ||
| Base Pay | $1.00 | ||
| Bonus Potential | $0.00 | ||
| SubTotal | $1.00 | ||
| Time Off Benefits | $0.00 | ||
| PTO | $0.00 | ||
| Sick | $0.00 | ||
| SubTotal | $0.00 | ||
| Benefit Compensation | $2.00 | ||
| Zeal's Cost | Your Cost | ||
| Medical | $2.00 | $1.00 | |
| Dental | $0.00 | $0.00 | |
| Vision | $0.00 | $0.00 | |
| Life/AD&D | $0.00 | $0.00 | |
| LTD | $0.00 | $0.00 | |
| 401(k) | $0.00 | $0.00 | |
| EAP | $0.00 | $0.00 | |
| Total | $2.00 | $1.00 | |
| Total Compensation | $3.00 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
