help with an online, flash version of an excel spreadsheet!?

[mrbest]

Hi there guys.

Before I start on a project I thought I'd see if you guys could give me some pointers that might make the project easier!

Basically I am going to be creating a web-based application which will allow the user to input data for certain fields, which will save to a table and will also update graphs from the data. - Basically it will be an online, flash version of an excel spreadsheet!

Have any of you done anything like this before? Perhaps there is a really easy way of doing it?

From what I gather it will need to edit an XML file and then load this into a graph. I have found a few useful tools for creating flash based graphs. It's the creating the XML data and displaying it in a table bit that i could use some pointers on!

I hope you can help me, or point me towards some useful sites or whatever...


cheers,

mrbest

 

[mrbest]

Hey Pho,

Thanks for the reply.

No I guess it doesn't have to be flash, I only said flash as I've got a better knowledge of flash than other languages! I thought PHP would be an option though.

How do you go about creating an SQL database? I seem to remember trying to use SQL database once before for a comment board but ended up going down a different route. Could you direct me to any examples/tutorials of this?

Cheers,

mrbest

 

[mrbest]

That would be amazing. Thanks again for your help mate - really appreciate it.

Well the data will be as followed:

[per week number] Number of products delivered; number of products at status 'A'; number of products at status 'B'; number of products complete; number of products incomplete - there may be additional fields but I should be able to get a picture of what the coding structure should be from this.

Also - some of the figures entered would need to provide a percentage (perhaps using formulae from previous entries) which would intern create data for the graph - but I'm guessing this would have to happen before the information is sent.

I'm sorry if this sounds vague - I'm trying to see the bigger picture before I get into the details!

I'll get XAMPP installed and get working on some tutorials!

Thanks again

mrbest

 

[mrbest]

Pho! Mate this is so very helpful - I can't thank you enough! This should get me started, I'll report back to you when I get the ball rolling! I hope you don't mind I may ask you more questions when I have more of an idea of the structure. I should be able to give you more of an idea of what I need too.

Thanks again for taking the time to help me - you're great!

Ash