Creating a HTML page with calculations and saves?
-
- Registered Pervert
- Posts: 6879
- Joined: 30 Jul 2004, 02:00
- Processor: Intel i7 4790k
- Motherboard: MSI Z97 Gaming 7
- Graphics card: MSI GTX780Ti Gaming
- Memory: G.Skill Sniper 1866mhz 16GB
- Location: The Greater Unknown
- Contact:
Creating a HTML page with calculations and saves?
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?
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?
-
- Forum Administrator
- Posts: 22136
- Joined: 14 Jun 2004, 02:00
- Processor: Ryzen 1700K
- Motherboard: Asus X370
- Graphics card: Asus 1060 Strix
- Memory: 16GB RAM
- Location: Where Google says
Re: Creating a HTML page with calculations and saves?
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...
JUSTICE, n A commodity which is a more or less adulterated condition the State sells to the citizen as a reward for his allegiance, taxes and personal service.
-
- Registered Pervert
- Posts: 6879
- Joined: 30 Jul 2004, 02:00
- Processor: Intel i7 4790k
- Motherboard: MSI Z97 Gaming 7
- Graphics card: MSI GTX780Ti Gaming
- Memory: G.Skill Sniper 1866mhz 16GB
- Location: The Greater Unknown
- Contact:
Re: Creating a HTML page with calculations and saves?
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.
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.
- hamin_aus
- Forum Moderator
- Posts: 18363
- Joined: 28 Aug 2003, 02:00
- Processor: Intel i7 3770K
- Motherboard: GA-Z77X-UP4 TH
- Graphics card: Galax GTX1080
- Memory: 32GB G.Skill Ripjaws
- Location: Where beer does flow and men chunder
- Contact:
Re: Creating a HTML page with calculations and saves?
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
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
-
- Registered Pervert
- Posts: 6879
- Joined: 30 Jul 2004, 02:00
- Processor: Intel i7 4790k
- Motherboard: MSI Z97 Gaming 7
- Graphics card: MSI GTX780Ti Gaming
- Memory: G.Skill Sniper 1866mhz 16GB
- Location: The Greater Unknown
- Contact:
Re: Creating a HTML page with calculations and saves?
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.
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.
Re: Creating a HTML page with calculations and saves?
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?
Important Thread:
- Hey everybody, I have returned (2013) and I am not Dead.
- Explaining RAM - SDRAM, DDRx and GDDR
- hamin_aus
- Forum Moderator
- Posts: 18363
- Joined: 28 Aug 2003, 02:00
- Processor: Intel i7 3770K
- Motherboard: GA-Z77X-UP4 TH
- Graphics card: Galax GTX1080
- Memory: 32GB G.Skill Ripjaws
- Location: Where beer does flow and men chunder
- Contact:
Re: Creating a HTML page with calculations and saves?
Right, like SQL Server is a huge enterprise-wide DBMS... except for SQL Express - the version that you can install on your desktop...GDI_Lord wrote:It's a huge enterprise-wide implementation project.
Start your search with SharePoint Foundation. It's not as complicated as some would make it seem.
Re: Creating a HTML page with calculations and saves?
Thanks hamin, I didn't know about that. All of my experiences with Sharepoint have been really big enterprise deployments. Have some Reputation++;hamin_aus wrote:Start your search with SharePoint Foundation.
Important Thread:
- Hey everybody, I have returned (2013) and I am not Dead.
- Explaining RAM - SDRAM, DDRx and GDDR
- hamin_aus
- Forum Moderator
- Posts: 18363
- Joined: 28 Aug 2003, 02:00
- Processor: Intel i7 3770K
- Motherboard: GA-Z77X-UP4 TH
- Graphics card: Galax GTX1080
- Memory: 32GB G.Skill Ripjaws
- Location: Where beer does flow and men chunder
- Contact:
Re: Creating a HTML page with calculations and saves?
Best 3.5 minutes of my day that!
- rustypup
- Registered User
- Posts: 8872
- Joined: 13 Dec 2004, 02:00
- Location: nullus pixius demonica
- Contact:
Re: Creating a HTML page with calculations and saves?
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)
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)
Most people would sooner die than think; in fact, they do so - Bertrand Russel