It has to do with a leave tracking spreadsheet. The spreadsheet updates a calendar in outlook so specific people can get a visual representation of who is on the ground and when.
There are two main reasons why I am looking for a word version of the CF-100
1. Rather then fill out the information twice, the user need only shove in their leave request times once. Using their start and end dates of the leave, I can populate the calendar with their leave times (colour coded for leave projection and leave approved). Thus, for the user, all they did was fill out a leave pass. From my side, I can update a calendar, generate a leave pass and update a worksheet. Also, this gives me other data that I can use should it be necessary (example address while on leave = location in outlook). Its easier to use everything in the "Office" group of applications as I can pass data to<->from Word/Outlook/Excel The macros running in the backend would do three things:
a. Populate the outlook calendar
b. Generate a leave pass
c. Update a leave tracking spreadsheet.
2. It saves on double-up labour and time. People can send their leave projections and I can manually mark things down. OR People can update a spreadsheet and fill out the leave pass. OR I can just automate everything
The workbook that I am working with has about 6 worksheets including a nominal roll - The less human intervention/interaction/meddling, the less chances of errors.
I can get more precise with my explanation, however I would start to be "geeky". Hopefully my outline gives you a general idea of what I'm tyring to accomplish.
... any idea where I can find a pre-formatted WORD doc of a CF-100 ? ???
essentially:
extracting data from a PDF = highly annoying (don't even know if its possible in a windows environment)
extracting data from a WORD doc = short, sweet and simple