473,805 Members | 2,008 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Advice / Ideas / Comments

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
Nov 15 '05 #1
4 1096
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.co m

"Ann Marinas" <an*********@xt ra.co.nz> wrote in message
news:ul******** ******@tk2msftn gp13.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

Nov 15 '05 #2
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.c om> wrote in
message news:Ov******** *******@TK2MSFT NGP12.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.co m

"Ann Marinas" <an*********@xt ra.co.nz> wrote in message
news:ul******** ******@tk2msftn gp13.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


Nov 15 '05 #3
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.co m
"Ann Marinas" <aC************ *@hotmail.com> wrote in message
news:Oo******** *****@tk2msftng p13.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.c om> wrote in message news:Ov******** *******@TK2MSFT NGP12.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.co m

"Ann Marinas" <an*********@xt ra.co.nz> wrote in message
news:ul******** ******@tk2msftn gp13.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



Nov 15 '05 #4
Once again, thank you so much for the help! :)

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote in
message news:en******** ******@TK2MSFTN GP12.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.co m
"Ann Marinas" <aC************ *@hotmail.com> wrote in message
news:Oo******** *****@tk2msftng p13.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.c om> wrote

in
message news:Ov******** *******@TK2MSFT NGP12.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.co m

"Ann Marinas" <an*********@xt ra.co.nz> wrote in message
news:ul******** ******@tk2msftn gp13.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
>
>



Nov 15 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
3159
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 drama) I've been trying to think of good ways to get Perl code to run inline in a PHP script. Here are a few of my ideas. If anyone has any further ideas, resources, or knows of someone else who's solved this already, please do tell... 1.) The...
10
2758
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, together with PostgreSQL on a Unix platform or SQL Server on a Windows platform. I am a qualified accountant and have been developing accounting software, mostly customised, for over 20 years. I have now got myself into a position financially...
4
2748
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, but more crucially, some existing functionality does not seem to work on the current MS OSs. The application works with a bespoke electrical gadget which emits a
32
2596
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, it was useful for specifying colours and fonts for a site in one central location, but useless for any real kind of design work due to the poor browser support. I got well in to using CSS for colours and fonts, but carried on using tables for...
6
1559
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 people process about 5 transactions per day. (Total, not each) The back-end database resides on a server not located in my office, but nearby. The transactions are the results of certain law enforcement activities. Pretty low volume for new...
6
1436
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 sub-categories. Each sub category consists of individual threads. Wich each has the possibility to be commented.
2
1684
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 Class2, while making sure that no resource leak occurs. Is the following the best way to hanlde this? Is there a more efficient way? public class ObjectC { public ObjectC() {
12
1695
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 past 2 years but would like to get back into it. What I need is some advice to get me up-to-date on what is the best (or one of the best) ways of developing web sites and web applications. The following are my requirements: * Static web pages...
1
1794
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 sequence generator. All referential integrity is maintained by the (java / JDBC) application. I'm looking at using partitioning as the expected data volume is large (3TB). A few good partitioning candidates have come to light, and we can range
0
9718
marktang
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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9596
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10613
Oralloy
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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10107
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9186
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7649
isladogs
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6876
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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4327
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
3
3008
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.