Hello guys,
i need someone to create an xls or access document that will extract some pdf files for my company.
Here in Greece, construction workers need to sign a declaration every month, in which they state the project they worked for, the amount of days and the amount of money they got paid. Since this is taking too much time, I want to create an excel document that will help me do it automatically.
I am attaching the government document in pdf and I am going to explain:
1) Text in green color is always the same, since it is the government format that needs to be filled. This will always be the same, the user must not be able to change it.
2) Text with yellow are values that will be different in every document and I must be able to "call them". It will actually be filled from tables that each employees' details are filled for every month. This means a table like this.
Worker's name - surname - date of birth - Place of birth - ...... - days he worked - position - wage - amount he got paid
3) Text with red are values that need to be able to be "called" and will be the same in every document but need to be editable. They refer to the project title - project number - location - month that the document is being created for - and year.
4) Document in blue text is the declaration itself. It needs to be editable but with some kind of protection since it will not be needed to change often. These are not values to be called. Is a common text.
I want to explain what I mean with values to be called. Every project owner wants a different kind of declaration. Some will onle ask something like "I worked in project XXXX and I was paid XXXX amount". Others need something more complicated, like "I worked in projext XXXX in adress XXXX, in the field "XXXX" for "X" days and I was paid "XXXX" amount". So the values in "" need to be possible to call them.
After I fill all values for the month I am interested for, I need to press a button and then pdf files are created for every worker and I can save or print them. |
