An XLS compilation tool: an engine to extract and aggregate data from Timesheet (XLS format) to fill a second XLS file in a calendar-like way.
$30-5000 USD
着払い
This project is about realizing a piece of desktop software that combines data available on an XLS sheet and produce, as an output, a number of filled XLS files (starting from an available template) and delivers said XLS created files via email.
Three essential steps can be seen:
1. Read a source_XSL worksheet to get the universe of data. The universe represent a collection of time-report (timesheet) of a number of consultants.
2. Use the data to recalculate aggregated Working hours, Vacations, Homesick etc etc. Fill the destination_XLS (built from a given XLS template) for each consultant.
3. Send via email the file created in (2), to the consultant mailbox
Application should be configured to produce detailed logs.
## Deliverables
See attached word file.
プロジェクトID: #3686401