PCFormat Forum Archive

I'm currently using a excel spread sheet for daily capturing. The problem is either excel or the staff are tampering with my formula cells. I don't want to lock each cell for editing and there is a lot.

What I want to do is the following:
- Set up a webpage that allows the person responsible for the daily capturing to log in.
- Create a page where only the captured information is prompted or required
- process and calculate the figures the same way the excel spread sheet would have done.
- return with an error if the figures does not balance.
- Give the person comment block incase figures cannot be balanced so they can report their actions and possible reasons that the system cannot balance (there are some days it doesn't due to other system capture issues)
- Give a printable version in the same style that the excel spreadsheet would have given.
- Saves the information on the file server to be retrieved for later editing or data retrieving. (all local)

Does anyone have any ideas and suggestions?

I'm not that clued up on this sort of thing, but you are going to be using a database for this sort of thing. I would assume you could use Visual Studio to do everything...

Not to sound stingy but I would have to use money to create the system then? It's not something that I can cook up with a simple text file or excel running in the background?

My programming skills are non existent at this point. Will I need to train in VS to be able to do what I want to do? Don't suppose MS access is still around.

Do you have SharePoint with Excel services?

http://office.microsoft.com/en-au/excel ... 42809.aspx

Formulas are supported, but not macros.
You can also make cells and formulas editable or not

Not sure what sharepoint is.

At current the setup is a work network with file sharing on one of the PCs as a central file host/server. Basic network stuff, no real access control. The problem I am sitting with is the cells being changed meaning someone can put in something into a cell with a formula and after a week I will be told the particular day could not be balanced only for me to find out one of the cell formulas contains a value instead of the formula.

No there aren't any macros. Everything is formula based.

Will look into the sharepoint thing.

StarBound wrote:Will look into the sharepoint thing.

No, seriously. It's a huge enterprise-wide implementation project. Perhaps try an access-controlled Google Docs/Office365 document?

GDI_Lord wrote:It's a huge enterprise-wide implementation project.

Right, like SQL Server is a huge enterprise-wide DBMS... except for SQL Express - the version that you can install on your desktop...

Start your search with SharePoint Foundation. It's not as complicated as some would make it seem.

hamin_aus wrote:Start your search with SharePoint Foundation.

Thanks hamin, I didn't know about that. All of my experiences with Sharepoint have been really big enterprise deployments. Have some Reputation++;

Best 3.5 minutes of my day that!

still sounds like an over-engineered solution to a simple problem...

lock the cells in question...

unless locking the problem cells is more onerous than deploying, configuring and developing a sharepoint solution... (for the record, i have doubts)