Creating a HTML page with calculations and saves?

All topics about coding, designing, etc. goes in here.
Post Reply
StarBound
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?

Post by StarBound »

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?
My Steam Screenshots

I lived the dream ...then my PC died.
Anakha56
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?

Post by Anakha56 »

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.
StarBound
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?

Post by StarBound »

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 Steam Screenshots

I lived the dream ...then my PC died.
User avatar
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?

Post by hamin_aus »

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
Image
StarBound
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?

Post by StarBound »

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.
My Steam Screenshots

I lived the dream ...then my PC died.
GDI_Lord
Forum Administrator
Posts: 2663
Joined: 05 Sep 2005, 02:00

Re: Creating a HTML page with calculations and saves?

Post by GDI_Lord »

StarBound wrote:Will look into the sharepoint thing.
Image

No, seriously. It's a huge enterprise-wide implementation project. Perhaps try an access-controlled Google Docs/Office365 document?
Important Thread: Yours in Christ's service,
User avatar
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?

Post by hamin_aus »

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... :roll:

Start your search with SharePoint Foundation. It's not as complicated as some would make it seem.
Image
GDI_Lord
Forum Administrator
Posts: 2663
Joined: 05 Sep 2005, 02:00

Re: Creating a HTML page with calculations and saves?

Post by GDI_Lord »

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++;
Important Thread: Yours in Christ's service,
User avatar
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?

Post by hamin_aus »

Best 3.5 minutes of my day that!
Image
User avatar
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?

Post by rustypup »

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)
Most people would sooner die than think; in fact, they do so - Bertrand Russel
Post Reply