Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old August 19th, 2005, 03:07 AM
Authorized User
 
Join Date: Dec 2004
Location: , , .
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default Linear programming problem

hi there,
i have prob for my final assignment,that i should build a program that could calculate minimum optimizing for linear program problem.i thought that u guys, known this case.
what i want to ask is, should i build this program using VBA, of course!, Or we can build in VB.net or something?
btw i never use vba in my life =), but one thing i know, sometimes people tell that vba is used like an Excel problem. is it true? can someone tell wider in different perspection. thx

Reply With Quote
  #2 (permalink)  
Old August 19th, 2005, 04:00 AM
Friend of Wrox
 
Join Date: Jan 2005
Location: Bournemouth, Dorset, United Kingdom.
Posts: 180
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sounds like an interesting assignment.

In principle, the worksheet is merely a User interface of the VBA code behind the scenes, you are just passing values from the front end to the backend. What I have done of Linear programming in the past has only been fairly basic compared to your requirements, but excel can handle these both in the front end and through the use of User Defined Functions (UDF) combined with VBA programming. UDF's are by far and away more versatile, however the can be a bit cranky occasionally. For instance you could write a UDF that calculates the result of a variant of the Chi squared calculation, there is already a CHITEST calc but you may want a different statistical calculation. As far as I am aware this is not a standard function in Excel but because you are creating it, it can work.

To create a UDF is fairly easy, there's plenty of manuals available on UDFs and here on the boards we are always ready to help in any way we can, only don't ask us to do you work, make your questions quite specific.

Hope this is helpful.

Matt
Reply With Quote
  #3 (permalink)  
Old August 21st, 2005, 09:27 AM
Authorized User
 
Join Date: Dec 2004
Location: , , .
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

i'm never study about vba, is it same like vbscript? or language that we use in .net?if there's any differences, can u guys share bout these knowledge =). btw, what is UDF, is it something that we build ourself function to run through it?
i know about .net language, can it solve my problem? i mean, can i use .net for build my program. and what i need to know for sure is, can .net solve any equation problem or we should solve this equation manually? this is the most important stuff for linear problem. thx

Reply With Quote
  #4 (permalink)  
Old August 23rd, 2005, 09:08 AM
jjd jjd is offline
Authorized User
 
Join Date: May 2005
Location: , , .
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Do you have to program the LP solving process or do you just need to solve an LP? If you just need a solution, use the built-in solver. If you have to program the process (e.g. simplex,dual,interior point, etc), you might want to use something Matlab that supports more matrix operations. If you have to do it in VBA/.Net, you will have your work cut out for you, but of course it can be done.

Reply With Quote
  #5 (permalink)  
Old August 23rd, 2005, 11:40 PM
Authorized User
 
Join Date: Dec 2004
Location: , , .
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

no, i have to made a program to solve a problem with .net/vb
anybody 've built it?
i've got problem with the equation, how should we do, when we need to solve any equation in .net?
thx

Reply With Quote
  #6 (permalink)  
Old August 25th, 2005, 09:06 AM
jjd jjd is offline
Authorized User
 
Join Date: May 2005
Location: , , .
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I really think you need to look at some basic material to familiarize yourself with LP. Try a book like [u]Introduction to Linear Optimization</u>. Then you can really think about how you will implement your solution. You can't just sit down and program a linear optimization program without some understanding of HOW to solve an LP problem.

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Solve Linear Equation in XSLT waqasnet XSLT 2 November 10th, 2008 02:34 PM
non-linear y-axis scale for stock charts Alseikhan Excel VBA 0 March 28th, 2006 01:54 PM
Programming Problem nappydyno234 Java Basics 2 February 11th, 2006 12:27 PM
ACCESS Programming DELTE problem dvlnblk2000 Access 1 September 29th, 2004 07:50 AM
Problem while programming Ecard samir ASP.NET 1.0 and 1.1 Professional 1 December 14th, 2003 01:44 PM



All times are GMT -4. The time now is 02:11 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.