Building an Asset Tracking Application in Excel Services – Part 1 of 5

Airline Travel » Building an Asset Tracking Application in Excel Services ??? Part 1 of 5

Wed, 28 May 2008 10:06:00 GMT

PingBack from http://www.travel-hilarity.com/airline_travel/?p=4795

re: Building an Asset Tracking Application in Excel Services – Part 1 of 5

Kanwaljit Singh Dhunna — Wed, 28 May 2008 13:30:13 GMT

Hi Dave Gainer, Dan Parish

Though not relating to the topic under discussion, this one is too strange to be ignored. Waiting for yours response.

http://news.office-watch.com/t/n.aspx?a=609

CA Kanwaljit Singh Dhunna

(India)

re: Building an Asset Tracking Application in Excel Services – Part 1 of 5

Chris — Wed, 28 May 2008 20:16:30 GMT

Kanwaljit - you may be interested in an earlier article on this same blog (http://blogs.msdn.com/excel/archive/2008/04/10/understanding-floating-point-precision-aka-why-does-excel-give-me-seemingly-wrong-answers.aspx).

Chris

re: Building an Asset Tracking Application in Excel Services – Part 1 of 5

Joseph Chirilov — Wed, 28 May 2008 20:29:12 GMT

Chris: you beat me to it. :)

Kanwaljit: please read the link Chris posted. It should address your concerns.

re: Building an Asset Tracking Application in Excel Services – Part 1 of 5

sam — Mon, 02 Jun 2008 14:17:54 GMT

Hello Dan,

This is a great example of cracking a peanut with a sledge hammer.

Long long ago Excel had a addin called Template Wizard with Data Tracking.

Instead of upgrading this addin you decided to drop it from Excel 2002

My solution to Assest Tracking problem would be

1. Excel Template - used to update data to a Database (Excel/Access/Dbase etc) - Using ADO

Available to the User

2.Pivot Connected to the Database to generate that fancy report.

I have deployed this solutions in many places with great success....

Sam

Building an Asset Tracking Application in Excel Services – Part 2 of 5

Microsoft Excel — Tue, 03 Jun 2008 22:03:53 GMT

Today's author, Dan Parish, a Program Manager on the Excel Services team, continues on with his multi-part

Excel issues - I'm no expert

fostertlu — Thu, 05 Jun 2008 02:19:40 GMT

Help - does anyone know why the text in my excel spreadsheet keeps on indenting? The text gets cut off as well - Print preview shows a perfect layout - but when it prints, it's all wrong

Microsoft support costs $49 - time to update to new version of Office for Mac?

fostertlu — Thu, 05 Jun 2008 02:21:46 GMT

Macbook Pro, Microsoft office 2004, OS 10.4.11

Excel sucks I'm afraid.

re: Building an Asset Tracking Application in Excel Services – Part 1 of 5

MSN Raju — Tue, 10 Jun 2008 08:15:54 GMT

How to build an asset tracking application in excel

re: Building an Asset Tracking Application in Excel Services – Part 1 of 5

Dan Parish (MSFT) — Thu, 12 Jun 2008 23:35:41 GMT

sam: While I don't know enough about the particular add-on you reference to comment on it, this solution does have several advantages over the solution you propose:

1. It is web based and thus can be accessed from anywhere, no add-on, or even Excel, required

2. If you have SharePoint in your organization, you can create this entire application with no IT involvement. There are no databases, and there is no deployment of anything to the client required.

3. If you want to change anything in the template, or if you want to collect additional information, there is no re-deploy step needed. Since it is all contained on the server, you can just update the solution there.

I'm sure that there are cases where your solution meets everyone's needs. This is simply another way to build this solution, and it has its advantages as well.

Tracking Anwendung mit Excel Services

Michael Greth MVP SharePoint Blog — Wed, 13 Aug 2008 16:52:25 GMT

Hatte ich das schon mal gepostet ? Building an Asset Tracking Application in Excel Services – Part 1

Tracking Anwendung mit Excel Services

Mirrored Blogs — Wed, 13 Aug 2008 17:55:10 GMT

Hatte ich das schon mal gepostet ? Building an Asset Tracking Application in Excel Services – Part 1