WHAT SOFTWARE HAVE YOU MADE USING EXCEL IN YOUR OFFICE ?

[mrchonginhk]

Just wondering if I can use Excel to do these:-

Conference Room booking system
Intranet
Auto Travel & Entertainment submission form
Self-serviced Employee Profile update (ie staff can retrieve his own info and update it on his PC).

Have anyone built any one these or similar "goodies" using Excel and is well received by the user ?

Is there any link to help us regarding these "software" ??

 

[whiteghost]

Hi mrchonginhk

When we met a few weeks ago, I showed you some of the stuff I've made (mostly with the help of this board), but others I didn't show were a searchable telephone list (search by name or number or department) logging system for invoice,credit and debit numbers, supplier preformance report, shipping advice system, shipment "breakdown" system. This one means all the garments have a number code, country of origin code, price and quantity, based on a pivot table when the table refreshes the codes are converted to words and seperates all by country and garment type then gives a sub total for each category of garment by country + total pieces and value (by country and as a Grand total) it also printed the export licences for each country( however that part is no longer used as the export licence is done electronically now).most of these have other benefits as well (e.g. the shipping advice system automatically logs when the advice was received and if it was revised from an earlier version. the invoice log shows which operater processed which invoice and gives a monthly report of operator output, production centre, and which customers were invoiced)

 

[kanchof]

Hi mrchonginhk
i highly recommand you to use a software called Xcelsius it pretty cool and easy to use you can create all things u ask for check out their website www.xcelsius.com

 

[Tazguy37]

I made a database for circuit boards that we use as test (or "gold") boards to verify production functionality. (We make circuit boards; my area tests them after they are built before they ship, to make sure they work.)

Every month, we cycle in new gold boards out of current production, and cycle out the old. It was a really screwed up process before I got my hands on it. To tell you the truth, they didn't really have a process in place, just a vague idea of how it should be done. Now, the database tells them how many boards of each type they need, how many they have total and if any types are short, and by how many. It also gives the average age of each type, and an age breakdown of each type (less than 20 days, 20-30, 30+).

Now anybody can bring up a userform that lets them scan in new boards, and scan out the old ones.

 

[XL-Dennis]

Hi Folks,

If someone asked me how I would solve these needs I would suggest the following:

Webb-based interface (developed in ASP / ASP.NET).
A database that store all the data (MDB / MySQL are the most common in use).

Unless the needs involves advanced calculations I find it hard to see why to use Excel at all.

Yes, per se I'm a Excel-developer but have decided to change strategy for many tasks and objectives for several reasons.

Many solutions have extremly short LC (Life Cycle) and therefore the LCC (Life Cycle Cost) must reflect the time-span as well as the developing costs.

The Web-interface does not require to have access to a specific computer as long as the available computers have access to the intranet/Internet.

Easier to upgrade / revise and maintain and no issues with different kind of versions!

Yes, I'm aware that I'm a renegade