Search
Member List
Calendar
Help
|
Changing an excel spreadsheet into a db driven page
|
|
21-09-2006, 10:28 AM
Post: #1
|
|||
|
|||
|
Changing an excel spreadsheet into a db driven page
I have been given a task at work to change an excel spreadsheet that our fleet department use into a db driven website.
The idea is that it will cut down on our need for Excel at each branch and allow us to create some reports based on the spreadsheet. Now my problem is that I cant think how to structure the db best. I have uploaded a copy of the sheet here so you can take a look (http://www.techmonkeys.co.uk/KiD/files/checksheet.xls) and see what you think. The way it is used is that each branch will fill in their vehicle reg's and dates that they entered the state (staff usage/accident damage/in service, etc) and once they have completed it, they will then email a copy to the fleet department. We want them to go to a webpage fill in the details and click done, then the fleet dept will be able to view the sheets online, print them off or run some reports on the data. Can anyone help me with the db structure? I will be doing it in php and mysql. - Techmonkey ================ Enterprise Business IT Support | SME IT Support | Home Support Available |
|||
|
|
21-09-2006, 10:58 AM
Post: #2
|
|||
|
|||
|
I'm sure you could hire my company to do it for you
 But more seriously, you have a software analyst on staff, neh? Use him to help  Btw, if you're doing a "proper" job of this, i.e. secure and reliable, estimate a 6 week timescale, or get professional help. No offence meant, but I know how little time your higher ups give you, and I don't think it's something you should knock together in an afternoon... Give me liberty, or give me death - Patrick Henry 1775. Think for yourselves and let others enjoy the privilege to do so too - Evelyn Beatrice Hall 1906 I spread my wings, only to find that they are paper in the rain - Neko 2006 |
|||
|
|
|
22-09-2006, 12:32 PM
Post: #3
|
|||
|
|||
|
give me a call over the weekend, probably take 10 mins with you to help you figure this out
Bomberman aka Colin Smith http://www.smithcolin.co.uk |
|||
|
|
|
22-09-2006, 01:41 PM
Post: #4
|
|||
|
|||
|
The weekend????? but that is not work time.
Will see if I can, but am off to York tonight for the evening then taking Shel to the airport tomorrow and wont be back till late. p.s. shultz have to cancel Saturday dude, forgot about taking shel to Newcastle Airport at 8pm 
- Techmonkey ================ Enterprise Business IT Support | SME IT Support | Home Support Available |
|||
|
|
|
22-09-2006, 02:34 PM
Post: #5
|
|||
|
|||
|
wheres the dedication
 Well nevermind then KiD, not really something I can do while I am at work as I have so many amny other things to do.
Bomberman aka Colin Smith http://www.smithcolin.co.uk |
|||
|
|
|
22-09-2006, 02:44 PM
Post: #6
|
|||
|
|||
|
lol sorry I do appreciate the offer, just this weekend is prolly not a good time.
Any night next week is good though....ah one week of pure bliss! - Techmonkey ================ Enterprise Business IT Support | SME IT Support | Home Support Available |
|||
|
|
|
22-09-2006, 02:59 PM
Post: #7
|
|||
|
|||
|
lol, so all on your lonesome for a whole week? I bet by the second day you have pitched a tent in the living room and are hugging your knees, rocking back and forth
Bomberman aka Colin Smith http://www.smithcolin.co.uk |
|||
|
|
|
22-09-2006, 03:03 PM
Post: #8
|
|||
|
|||
|
I bet by the second day I am unable to move away from my puter desk tbh
- Techmonkey ================ Enterprise Business IT Support | SME IT Support | Home Support Available |
|||
|
|
|
« Next Oldest | Next Newest »
|