Share Utility Records?
Home > IT Answers > DataManagement > Share Utility Records?
OBI Girl
85 pts.
0
Q:
Share Utility Records?
Data management and storage, Microsoft Excel, Excel worksheets
I maintain utility records for several different buildings. I would like to share individual records with their supervisor. Presently, the records are stored on one excel page. I can't seem to divide up that one page into an email for each account. What would be the best program to use to store individual building stats and then email them to each supervisor?
ASKED: Apr 24 2009  6:47 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
ITKE
10345 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Personally I always prefer using databases rather than Excel so you might consider to import your data into SQL tables and then from there by querying the data you can use many techniques to send these data to the given targets. Example you may use VBScript to extract the data and sends them via email or you may use a SQL Agent Job with DB mail and so on.
Last Answered: Apr 27 2009  3:51 PM GMT by ITKE   10345 pts.
Latest Contributors: JAucoin   50 pts., Alessandro.panzetta   9615 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

SbElectric   1625 pts.  |   Apr 28 2009  2:29AM GMT

ITKE has correctly mentioned that a database provides many more options than an excel spreadsheet. But if you are in a hurry & not familiar with database - then you may consider a few “quick and dirty” options.
1) Can you add a column to designate various buildings (Category)? All Records for Building ABC will be 1; all records for building DEF will be 2, etc. Now you can sort the spreadsheet based on this category column. You can then add page breaks (or filter) to suit your needs. May produce a .pdf copy on filtered data – which may be e-mailed.
2) If the number of buildings are reasonable – (less than say 20) then you may be able to create individual worksheets for each building. You can still create a summary total of all buildings – by summing (or averaging) individual worksheets.

Again database (Oracle, SQL, Access) will provide many options — long-term stability, growth, better security, better reporting, etc.
Good luck.

 
0