MrExcel Publishing
Your One Stop for Excel Tips & Solutions

uses of spreadsheets

Posted by Paula Gabriel on November 15, 2001 4:27 AM

Can anyone help me??!!

I have to write a report detailing the value of spreadsheets and different situations in which they are used - but this is not to refer to anything financial.!!!!!!!!!!!!!!!!

Thank you

Posted by George on November 15, 2001 4:57 AM

You can suggest different types of lists - Contact Details, Shopping Lists, Exam dates & Results
Or perhaps calculations - Building materials (amounts of and where used), Productivity Tables (People making x amount of products on machine y)

Hope it's a start.

Posted by Todd on November 15, 2001 5:03 AM

Wow! You're gonna get plenty of responses here! I use it daily for analysis of call trends in our inbound call centre. We track call volume patterns and call handle times by half-hour and do all kinds of wonderful statistical operations on them.

Also, we use it to track our agent data - call times, QA scores, attendance, etc., which helps us decide on promotions, raises, etc.

I use Excel every day- and rarely use it for financial data - i my department, anyway!

Cheers! - Todd

Posted by Mark O'Brien on November 15, 2001 6:09 AM

My main exposure to Excel was when I was asked to use Excel to make an engineering flowsheeting package. The reason I was using Excel was because we had mathematical simulation software that could send data to Excel. It seemed easiest to use Excel to make the interface as well since VBA made it a very flexible tool. (until we got Visio which had VBA built-in as well. grrr.)

Posted by Jane Naylor on November 15, 2001 6:20 AM

What about the use of spreadsheets for reporting and graphing.
Such as displaying trends in statistics over a period of time.Excel is very handy for displaying data graphically using charts and graphs of different kinds

Posted by lenze on November 15, 2001 7:14 AM

There are some great links to sample applications at this site.

Posted by Joe Was on November 15, 2001 8:20 AM

Spreadsheet software was in the early days a "what-if" tool for mathematically inclined problems. There was once a clear distinction between problems best suited for database, word processor or spreadsheet software, today with a wide breath of application designing tools built into "Excel" the best choice software for a solution has becomed blirred. As one of the original database designers/programmer and the owner of a publishing company in the days before PC's, the evolution of the spreadsheet has been phenomenal. We use Excel where we once would have used a database program, so much so that, we have converted many of the database applications to Excel applications. Most of the forms that would have been done with a word processor are now made with Excel, with greater ease and greater versatility.

Not all spread sheet software is as good as Excel the others have poor application designing abilities, which seem to have been put in as an after thought, if at all. Other software programs, even the ones included in MS Office with Excel, do too many things for you, which makes user control difficult. Excel helps the user keep control over application design and adds to the overall development experience. Excel is far from perfect, but it is the best of the spreadsheet programs.

We still need database programs for large packages and word processors do pure text functions better, but the modern spreadsheet is the most versatile program. From the modern spreadsheet we can get, lists, tables, , inventories, signs, forms, charts, graphs, what-if-scenarios, photo albums, user interfaces, complete "turn-key" applications and other powerful and time saving tools. JSW

Posted by Gary on November 15, 2001 3:25 PM


I use excel spreadsheets in to:

keep an inventory of stock located in a warehouse (where the stock is and whether the stock is on a shared pallet, file prints off stock location sheets to stick on pallets).

To create picking lists for warehouse operatives (uses VLOOKUP to see how many different parts are needed to make up an item and then calculated the various amounts of each stock item to fulfil the order).

Create advice notes to staff that make stock into the saleable item (tells them how many parts go in and of which parts, and pulls up the instructions from a sepaerate file as to how o do the job).

Keep track of shipments and containers that are delivered.

Modifying templates to use in emails (concatenating and replacing markers).

And loads of other small bits and bobs.



Gary Hewitt-Long