I've been asked to convert a pay increase spreadsheet to an intranet
page. So far I've developed a page that uses a combination of ASP and
Javascript to retrieve all of the required information from the HR
database. The problem is that I need to be able to calculate the new
salary based on an increase_amount field, as well as maintain a
running total of the increase amounts. Once the amounts have been
determined, I then need to submit them, matched up with an employee ID
that is already on the page, to a stored procedure.
I've never attempted something like this before and am a little lost
on how to complete the desired functionality. Is it even possible?
Can this be done without embedding an Excel spreadsheet?
- Mark 6 6354
Mark wrote: I've been asked to convert a pay increase spreadsheet to an intranet page. So far I've developed a page that uses a combination of ASP and Javascript to retrieve all of the required information from the HR database. The problem is that I need to be able to calculate the new salary based on an increase_amount field, as well as maintain a running total of the increase amounts. Once the amounts have been determined, I then need to submit them, matched up with an employee ID that is already on the page, to a stored procedure.
I've never attempted something like this before and am a little lost on how to complete the desired functionality. Is it even possible? Can this be done without embedding an Excel spreadsheet?
- Mark
This is actually very simple for JavaScript. As long as you know how
all of your formulas convert into the JavaScript math operators and
methods, setting up a spreadsheet-like page is trivial. Instead of
cells, just use text boxes for columns and rows of user input (one text
box for each cell).
In fact, with a little attention to layout, you can create a much more
"user friendly" spreadsheet than Excel.
Look up how to create forms and how to access the values of the input
fields. The HTML spec can be found at w3.org. If you want to learn how
to use JavaScript, you should read a good programming book about
JavaScript. The book I recommend is "javascript : The Definitive Guide"
by David Flanagan (3rd Ed).
(Go ahead and email me if you need any implementation-specific help. I
have example code of a project I did that calculated signal loss and FCC
rules adherence for microwave radios given many input values. It
started out as an Excel spreadsheet [provided by my boss] and ended up a
web page that fed off of a database on the backend.)
HTH,
Zac
probably your best bet is to use Javascript Event Handlers to capture
fields being entered/exited, then call a recalculation funciton to sort
out the data. For DB Communication I'd suggest a hidden IFrame that can
then be submitted to a server side script - ASP, PHP, Perl etc - to be
processed and then have that reply come back with Javascript in it to
update the form on the main page.
Mail me if you need more
Mark wrote: I've been asked to convert a pay increase spreadsheet to an intranet page. So far I've developed a page that uses a combination of ASP and Javascript to retrieve all of the required information from the HR database. The problem is that I need to be able to calculate the new salary based on an increase_amount field, as well as maintain a running total of the increase amounts. Once the amounts have been determined, I then need to submit them, matched up with an employee ID that is already on the page, to a stored procedure.
I've never attempted something like this before and am a little lost on how to complete the desired functionality. Is it even possible? Can this be done without embedding an Excel spreadsheet?
- Mark
probably your best bet is to use Javascript Event Handlers to capture
fields being entered/exited, then call a recalculation funciton to sort
out the data. For DB Communication I'd suggest a hidden IFrame that can
then be submitted to a server side script - ASP, PHP, Perl etc - to be
processed and then have that reply come back with Javascript in it to
update the form on the main page.
Mail me if you need more
Mark wrote: I've been asked to convert a pay increase spreadsheet to an intranet page. So far I've developed a page that uses a combination of ASP and Javascript to retrieve all of the required information from the HR database. The problem is that I need to be able to calculate the new salary based on an increase_amount field, as well as maintain a running total of the increase amounts. Once the amounts have been determined, I then need to submit them, matched up with an employee ID that is already on the page, to a stored procedure.
I've never attempted something like this before and am a little lost on how to complete the desired functionality. Is it even possible? Can this be done without embedding an Excel spreadsheet?
- Mark
Thanks Zac & Greg. I appreciate the replys. If you have an example
that you could show me I think it would help me understand. If not, I
at least have some direction.
Thanks again!
- Mark
Greg Griffiths <gr***@surfaid.org> wrote in message news:<3F***************@surfaid.org>... probably your best bet is to use Javascript Event Handlers to capture fields being entered/exited, then call a recalculation funciton to sort out the data. For DB Communication I'd suggest a hidden IFrame that can then be submitted to a server side script - ASP, PHP, Perl etc - to be processed and then have that reply come back with Javascript in it to update the form on the main page.
Mail me if you need more
Mark wrote: Thanks Zac & Greg. I appreciate the replys. If you have an example that you could show me I think it would help me understand. If not, I at least have some direction.
Thanks again!
- Mark
Hey Mark,
Here's an implementation of my system here: http://planetzac.net/test/apdb/wiapdb.php
I just set it up for educational purposes, so there's no sensitive
information there. Normally, I would password protect something like
this, but there's no need in this case. Go ahead and play around with
it and see how it works. Feel free to create new access points and
alter their values.
To see how the JavaScript works, just view the page source (it's all
there). If you're interested in the server-side script, I wrote
everything in PHP and I'd be happy to email you a copy of the code if
you're interested in that as well.
HTH,
Zac
Black Hills, huh? That would be in my "neighborhood"...
Thanks for sharing your page. I'm not sure that its going to help me,
however. Your page has a set number of fields all uniquely named and
referenced. I'm trying to figure out how to take something more like
a 2 column table that can have a varying number of rows. (The number
of rows needs to be flexible as each manager can oversee a different
number of people.) The first column would be the record key, and the
second column would be the salary adjustment from which other fields
would be calculated (ie a total adjustment amount field).
If I can create this, I'm thinking that I can then combine the key
with the adjustment and send it as one field, parse it out at the
server and then populate my table.
Does this make sense?
Zac Hester <ne**@planetzac.net> wrote in message news:<3f********@news.enetis.net>... Hey Mark,
Here's an implementation of my system here:
http://planetzac.net/test/apdb/wiapdb.php
I just set it up for educational purposes, so there's no sensitive information there. Normally, I would password protect something like this, but there's no need in this case. Go ahead and play around with it and see how it works. Feel free to create new access points and alter their values.
To see how the JavaScript works, just view the page source (it's all there). If you're interested in the server-side script, I wrote everything in PHP and I'd be happy to email you a copy of the code if you're interested in that as well. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Krishna Tulasi via .NET 247 |
last post by:
Hi,
I am having trouble with creation of XML programmatically using .NET. Specifically Im trying to create an element which looks like below and insert into an existing xml doc:
<Worksheet ss:Name="TKCSheet1">
</Worksheet>
The existing xml doc is:
<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
|
by: OM |
last post by:
I have 3 tables tblFI, tblFIDet, tblMac, in Access 2000
tblFI
fldFIAuto, autonumber,
fldDate, date
…and a few more fields that don’t matter.
tblFIDet
fldFIDetAutoID, autonumber
fldFIAutoID, linked to tblFI.fldFIAutoID
|
by: nikkii |
last post by:
I currently have a spreadsheet with more than 1000 records. Within
this spreadsheet are many duplicates. In the past I've been using he
filter feature to find the duplictes. However, as the spreadsheet
getts longer that is becoming more difficult. Is there any other way
to delete the duplicates and keep the unique the values?
Please...
|
by: Dixie |
last post by:
I have a spreadsheet that uses VBA code in Access to save itself as a text
file. The line is as follows.
xl.ActiveSheet.SaveAs CurrentProject.Path & "\Reports\" &
DLookup("", "tblButtons", "ControlID=141") & ".txt", 20 ' 20 =
xlTextWindows
The code is using a DLookup to get the filename because it is different on
|
by: Mitch |
last post by:
I am using Access to create an Excel spreadsheets with graphs related
to rows on the sheet1 to the graph on sheet2. I am using the same data
but different subsets of the data to make different spreadsheets for
different groups. The spreadsheet formats are the same for each of the
different groups. So I am using a loop to requery the data...
| |
by: shapper |
last post by:
Hello,
I am for days trying to apply a XSL transformation to a XML file and
display the result in a the browser. I am using Asp.Net 2.0.
Please, could someone post just a simple code example, either C# or
VB.NET, that I can try.
Thank You Very Much,
|
by: melcoats |
last post by:
Hi Everyone,
Looking for some help here. How do I reference a spreadsheet I inserted in a user form? I'm trying to create an app for a graphics program that calcluates area. The calc language I already found and it works well. I want to now include a spreadsheet that will accept the results and allow me quickly add the columns as opposed to...
|
by: Louis |
last post by:
I am trying to use php to update a spreadsheet (MS Excel or OpenOffice
Calc) with data from MySQL.
I looked into PEAR::Spreadsheet_Excel_Writer if it will do the job. If I
understand it correctly, it basically creates spreadsheets, but not
opening an existing spreadsheet and then updating and saving it, which
is what I want to do.
Do you...
|
by: vijaymohan |
last post by:
Hi ..I am very new to perl..can some one help me with this script pls..
I am Querying database and writing data to excel..
Here is my script:
#!/usr/bin/perl -w
use strict;
use DBI;
|
by: Ed from AZ |
last post by:
I'm using Word 2003. I use a proprietary Java program that takes all
the information in the various forms and generates an XML file.
There
are times I need to move information between files. I tried to
explore this in the Excel and Access NG, because the data format
would
lend itself very well to a spreadsheet or table. But I reached a...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |