Hello all!
I really need your advice/ suggestions/ comments regarding a particular
program of mine that I am currently developing.
What the program does is that
1. the user imports data
2. the application calculates the estimated rates using a base rate as a
basis
against a data that holds item details to be charged.
3. The results from these calculations will then be compared to an invoice
data to check
whether a specific company charges the correct cost or not.
4. Saves to database and generates the report.
Now, I am having some problems as to how am I going to implement a form that
would allow the user to enter their own calculations based on the types of
base rates they are going to use. I've found out that the column from the
base rates vary, so does the formulas needed for consolidation.
If you guys have any suggestions on how I could implement this, or any
changes, I would really appreciate it!
Thank you so much and more power to all!
--A 4 1078
Ann,
Hmm, you might want to think about hosting a scripting language (like VB
script) in your application. This way, you can set up the variables (with
values assigned to them), and then you could have them write the code (or in
this case, the formulas) which are then evaluated.
Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com
"Ann Marinas" <an*********@xtra.co.nz> wrote in message
news:ul**************@tk2msftngp13.phx.gbl... Hello all!
I really need your advice/ suggestions/ comments regarding a particular program of mine that I am currently developing.
What the program does is that 1. the user imports data 2. the application calculates the estimated rates using a base rate as a basis against a data that holds item details to be charged. 3. The results from these calculations will then be compared to an invoice data to check whether a specific company charges the correct cost or not. 4. Saves to database and generates the report.
Now, I am having some problems as to how am I going to implement a form
that would allow the user to enter their own calculations based on the types of base rates they are going to use. I've found out that the column from the base rates vary, so does the formulas needed for consolidation.
If you guys have any suggestions on how I could implement this, or any changes, I would really appreciate it!
Thank you so much and more power to all!
--A
Thank you for your help! I really do appreciate it!
But I still have some questions, if you may permit me to ask...
1. I'm not too familiar with scripting. Do you have any suggestions on some
materials that I could research on with regards to scripting?
2. Are there any alternatives besides scripting?
--Ann
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote in
message news:Ov***************@TK2MSFTNGP12.phx.gbl... Ann,
Hmm, you might want to think about hosting a scripting language (like
VB script) in your application. This way, you can set up the variables (with values assigned to them), and then you could have them write the code (or
in this case, the formulas) which are then evaluated.
Hope this helps.
-- - Nicholas Paldino [.NET/C# MVP] - mv*@spam.guard.caspershouse.com
"Ann Marinas" <an*********@xtra.co.nz> wrote in message news:ul**************@tk2msftngp13.phx.gbl... Hello all!
I really need your advice/ suggestions/ comments regarding a particular program of mine that I am currently developing.
What the program does is that 1. the user imports data 2. the application calculates the estimated rates using a base rate as a basis against a data that holds item details to be charged. 3. The results from these calculations will then be compared to an
invoice data to check whether a specific company charges the correct cost or not. 4. Saves to database and generates the report.
Now, I am having some problems as to how am I going to implement a form that would allow the user to enter their own calculations based on the types
of base rates they are going to use. I've found out that the column from
the base rates vary, so does the formulas needed for consolidation.
If you guys have any suggestions on how I could implement this, or any changes, I would really appreciate it!
Thank you so much and more power to all!
--A
Ann,
Besides scripting, you could always try and interpret the functions that
you wrote yourself. This might be a pain though. Also, just coming to
mind, you might be able to use MATLAB. I believe they have function
libraries that will interpret mathematical equations and return results. Of
course, you would have to use COM interop or the P/Invoke layer for this (I
don't believe there is a managed wrapper for this yet).
As for hosting scripting, check out the artile in MSDN magazine titled
"Add Scripting to Your Apps with Microsoft ScriptControl", located at (watch
for line wrap): http://msdn.microsoft.com/msdnmag/is...g/default.aspx
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com
"Ann Marinas" <aC*************@hotmail.com> wrote in message
news:Oo*************@tk2msftngp13.phx.gbl... Thank you for your help! I really do appreciate it!
But I still have some questions, if you may permit me to ask...
1. I'm not too familiar with scripting. Do you have any suggestions on
some materials that I could research on with regards to scripting? 2. Are there any alternatives besides scripting?
--Ann
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote
in message news:Ov***************@TK2MSFTNGP12.phx.gbl... Ann,
Hmm, you might want to think about hosting a scripting language
(like VB script) in your application. This way, you can set up the variables
(with values assigned to them), and then you could have them write the code
(or in this case, the formulas) which are then evaluated.
Hope this helps.
-- - Nicholas Paldino [.NET/C# MVP] - mv*@spam.guard.caspershouse.com
"Ann Marinas" <an*********@xtra.co.nz> wrote in message news:ul**************@tk2msftngp13.phx.gbl... Hello all!
I really need your advice/ suggestions/ comments regarding a
particular program of mine that I am currently developing.
What the program does is that 1. the user imports data 2. the application calculates the estimated rates using a base rate as
a basis against a data that holds item details to be charged. 3. The results from these calculations will then be compared to an invoice data to check whether a specific company charges the correct cost or not. 4. Saves to database and generates the report.
Now, I am having some problems as to how am I going to implement a
form that would allow the user to enter their own calculations based on the
types of base rates they are going to use. I've found out that the column from the base rates vary, so does the formulas needed for consolidation.
If you guys have any suggestions on how I could implement this, or any changes, I would really appreciate it!
Thank you so much and more power to all!
--A
Once again, thank you so much for the help! :)
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote in
message news:en**************@TK2MSFTNGP12.phx.gbl... Ann,
Besides scripting, you could always try and interpret the functions
that you wrote yourself. This might be a pain though. Also, just coming to mind, you might be able to use MATLAB. I believe they have function libraries that will interpret mathematical equations and return results.
Of course, you would have to use COM interop or the P/Invoke layer for this
(I don't believe there is a managed wrapper for this yet).
As for hosting scripting, check out the artile in MSDN magazine titled "Add Scripting to Your Apps with Microsoft ScriptControl", located at
(watch for line wrap):
http://msdn.microsoft.com/msdnmag/is...g/default.aspx
-- - Nicholas Paldino [.NET/C# MVP] - mv*@spam.guard.caspershouse.com
"Ann Marinas" <aC*************@hotmail.com> wrote in message news:Oo*************@tk2msftngp13.phx.gbl... Thank you for your help! I really do appreciate it!
But I still have some questions, if you may permit me to ask...
1. I'm not too familiar with scripting. Do you have any suggestions on some materials that I could research on with regards to scripting? 2. Are there any alternatives besides scripting?
--Ann
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote in message news:Ov***************@TK2MSFTNGP12.phx.gbl... Ann,
Hmm, you might want to think about hosting a scripting language (like VB script) in your application. This way, you can set up the variables (with values assigned to them), and then you could have them write the code (or in this case, the formulas) which are then evaluated.
Hope this helps.
-- - Nicholas Paldino [.NET/C# MVP] - mv*@spam.guard.caspershouse.com
"Ann Marinas" <an*********@xtra.co.nz> wrote in message news:ul**************@tk2msftngp13.phx.gbl... > Hello all! > > I really need your advice/ suggestions/ comments regarding a particular > program of mine that I am currently developing. > > What the program does is that > 1. the user imports data > 2. the application calculates the estimated rates using a base rate
as a > basis > against a data that holds item details to be charged. > 3. The results from these calculations will then be compared to an invoice > data to check > whether a specific company charges the correct cost or not. > 4. Saves to database and generates the report. > > Now, I am having some problems as to how am I going to implement a form that > would allow the user to enter their own calculations based on the
types of > base rates they are going to use. I've found out that the column
from the > base rates vary, so does the formulas needed for consolidation. > > If you guys have any suggestions on how I could implement this, or
any > changes, I would really appreciate it! > > Thank you so much and more power to all! > > --A > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: FLEB |
last post by:
I like PHP for its excellent inline integration into standard HTML files,
but I like Perl for its quick-moving syntax and simpler data-processing. To
resolve this deep-seated inner turmoil (oh, the...
|
by: Frank Millman |
last post by:
Hi all
I would like some advice, and I hope that the good people on c.l.p
will give me the benefit of their experience.
I am busy developing an accounting package, using Python and wxPython,...
|
by: Naran Hirani |
last post by:
Hi fellow Netters,
I need to re-write a very old C/C++ application written in the days when
MS/PC-DOS was king.
The reason for the re-write is that the application needs some new
functionality,...
|
by: Alan Silver |
last post by:
Hello,
I shamefully admit to be an old web designer, from before the days of
CSS. In those heady days, tables were king and were used for every
possible kind of alignment. When CSS came along,...
|
by: user451 |
last post by:
As the most Access-savvy person in my office, I have been handed the
task of proposing a nationwide expansion of a project that I have
developed in Access. A brief overview:
Right now, about 25...
|
by: frizzle |
last post by:
Hi there,
I'm going to build a simple forum in mySQL.
I've thought about it for a while now, but still can't figure it
out completely:
If i have say 5 main categories,
One has 5...
|
by: Robert Vasquez |
last post by:
I have three classes. One (Class ObjectC) and two other classes (Class1 and
Class2) that will hold instances of the ObjectC class. I would like to
transfer an instance of OjectC from Class1 into...
|
by: johannblake |
last post by:
First off, I am NOT a beginner. I have lots of experience developing
professional web sites and am a professional software developer.
Unfortunately I've been out of web site development for the...
|
by: simoncole |
last post by:
Hi there
Am just about to deploy a new application - one of those 'generic' database
types with very little Oracle specific functionality built in.
There is no referential integrity, and one...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| |