We currently use 3 separate Excel spreadsheets to log various data. Job log, serial numbers,delivery notes and use a 4th as a quote calculator.
The 3 data spreadsheets have approx 3500 lines and up to 12 columns.
We are adding up to 200 new lines each month.
At the moment none of the spreadsheets are linked to each other and searching for records is clunky to say the least.
We are looking for a web based data entry/interrogation system to perform these tasks.
The data is currently in Excel 2007 format but the final solution does not necessarily have to use Excel.
However the quote calculator uses a number of complex formulas with over 40 cells of information required.
If not too cost prohibitive. We would also like to include data from our MRP system which uses a Foxpro database.
I will be making a decision on where the works goes in the next week