Heh-heh! We seem to be in the same Excel religion, just a  different 
sect...As with any problem there is usually more than 1 solution. My point 
with the iterations is only that this is probably not the easiest, best, 
or most mathematically correct way to compute Loan/Interest payments...AND 
DEFINATELY NOT the fastest!

But I'd love to see a solution to Josephs problem USING the circular 
references that is easier and more accurate than using Excels built-in 
functions (correctly), and that require no special "control of the 
application state". IMO, just because it CAN be done doesn't mean it 
SHOULD.

cheers to you too for stimulating my Excel frontal lobe...

KC





> Actually, FWIW, I think the review of the example spreadsheet would help 
Joseph solve his problem.  You allude to this yourself when you said that 
"you limit iterations" to control it.  So, in my humble opinion, a 
developer needs to control the application state in order to determine the 
number of necessary circular reference iterations to obtain the necessary 
results.  This can be done in Excel, VB, or just about any other dev tool

I agree with you: The j-walk site is another great one!

I love these message boards because I learn SO many different ways to 
solve problems.  The various solutions are always mentally stimulating! In 
my own way, I was just attempting to add value.  I hope you all 
understand.

Best regards.





"Kevin Crider" <criderkevin@a...>
01/28/03 09:46 AM
Please respond to "professional vb"

 
        To:     "professional vb" <pro_vb@p...>
        cc: 
        Subject:        [pro_vb] Re: Circular Logic


Well I guess I SHOULD have said "Excel will not compute circular 
references unless you limit iterations" (thats what Bullen does in that 
worksheet) or use some other method to make it compute. Excel can also be 
used to play Tetris, but this doesn't help Joseph...none of this is 
answering the original question - which I believe the other fellows have 
done best...

btw, my Excel page of choice is...http://j-walk.com/ss/





> Um, Excel WILL perform circular reference calculations, because they can 

be very helpful under certain cituations.  I first learned about this from 

some outstanding (dare I say, EXCELLENT lol) work here:

http://www.bmsltd.co.uk/Excel/Default.htm

Simply put, Stephen Bullen has done some really great stuff within Excel. 
May be a bit aged, but great stuff for any developer.

Take a look at his GS_Demo.zip project for a great circular reference 
lesson.

HTH






"Kevin Crider" <criderkevin@a...>
01/27/03 02:49 PM
Please respond to "professional vb"

 
        To:     "professional vb" <pro_vb@p...>
        cc: 
        Subject:        [pro_vb] Re: Circular Logic


Joseph:

Check your formulas in Excel again, because this IS a circular reference, 
which Excel will not compute - your Excel sheet/formulas should not be 
working - unless: an amount in one of your formulas is hard coded, instead 


of using a cell reference, or there is another cell reference or amount 
that you're not telling us.

Kevin




> Have a problem I am not sure how to overcome.  I have an excel worksheet
I am in midst of converting to a VB aapplication.  The problem is that
there appears to be some circular reasoning involved.  Here's what I
have:

In excel  I have three cells:
1)  LoanFunded
2)  FinancedPrePaids
3)  PIPaymentMonthly

Converting these to VB I get the following

LoanFunded = Bunch of other stuff + FinancedPrepaids
FinancedPrepaids = PIPaymentMonthly * 3
PIPaymentMonthly = Pmt(Rate /12, 360, LoanFunded)

So Loanfunded relies on FinancedPrePaids which relies on
PIPaymentMonthly which relies on Loanfunded.

And I have absolutely no idea on how to get around this.

Any suggestions?

<FWIW - for some reason it works fine in excel>

Joseph Hagerty
Head Geek
Tentmakers Missionary Fellowship

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.445 / Virus Database: 250 - Release Date: 1/21/2003
 

---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to 



---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to