I have created a spreadsheet that automatically reads in the contents of five text files.
The largest text file contains transaction information: employee, date, amount, etc.
I lookup information from the other four text files and add it to the transaction table, as adjacent columns.
From advice in this forum, I have made this table a 'dynamic named range', as it changes constantly.
The combined table is the source data for various pivot tables to summarize and present data.
The two biggest questions answered by this spreadsheet are:
- what are employees spending money on?
- what vendors are we buying from?
Currently, the spreadsheet is used by the 'big boss' who sees data for all employees.
If there are items of note during her analysis, she wants to e-mail the appropriate supervisor, who will then sign on to the company intranet and request/view/analyse transaction data for their employees only.
This aspect of it: presenting the data on the intranet is what I wish help with.
Firstly, a developer told me to consider querying the data from the original mainframe data tables, either through UI or API, and just present that data using HTML, in other words, ignore using the current Excel spreadsheet at all.
However, the 'big boss' wonders if we can put some version of the spreadsheet onto the intranet, with only a subset of the data.
If any one has any ideas, I appreciate any and all replies.
Thanks.
This message was edited by stevesian on 2002-04-16 22:34
This message was edited by stevesian on 2002-04-16 22:34
This message was edited by stevesian on 2002-04-16 22:38
The largest text file contains transaction information: employee, date, amount, etc.
I lookup information from the other four text files and add it to the transaction table, as adjacent columns.
From advice in this forum, I have made this table a 'dynamic named range', as it changes constantly.
The combined table is the source data for various pivot tables to summarize and present data.
The two biggest questions answered by this spreadsheet are:
- what are employees spending money on?
- what vendors are we buying from?
Currently, the spreadsheet is used by the 'big boss' who sees data for all employees.
If there are items of note during her analysis, she wants to e-mail the appropriate supervisor, who will then sign on to the company intranet and request/view/analyse transaction data for their employees only.
This aspect of it: presenting the data on the intranet is what I wish help with.
Firstly, a developer told me to consider querying the data from the original mainframe data tables, either through UI or API, and just present that data using HTML, in other words, ignore using the current Excel spreadsheet at all.
However, the 'big boss' wonders if we can put some version of the spreadsheet onto the intranet, with only a subset of the data.
If any one has any ideas, I appreciate any and all replies.
Thanks.
This message was edited by stevesian on 2002-04-16 22:34
This message was edited by stevesian on 2002-04-16 22:34
This message was edited by stevesian on 2002-04-16 22:38