Make A Fresnel Zone Calculator

Hi all,
The yield function in excel does not give the right value if I play around with the redemption value(% of par). I have checked this with other available online bond yield calculators such as
http://www.moneychimp.com/calculator...e=calc_bondytm

If I change the redemption value to 50 and the bond price to $50, ideally the coupon rate and the yield should be equal for any time period. While this happens in the calculator mentioned above, Excel gives me a different number. Is this actually a bug or am I missing the point?

Test this in Excel...

=YIELD("6/30/2009","6/30/2022",0.0958,50,50,2,0)

Also test different redemption and price values and compare them with the calculator above.

How this type of calculators are made? Any idea!
http://www.hughchou.org/calc/income.php

Hi. First post here, looks like a good place for Excel info.

I'm not really familiar with Excel's iteration and how to set it up properly. Here's an example of a problem that requires iteration:

1 / λ1/2 = -2 log [ 2.51 / (Re λ1/2) + (k / dh) / 3.72 ]

Only one value of lambda (λ) will allow the two equations above to be equal, I need to balance the equations and solve for Lambda. The way I do this now is using VBA (code below)... can this be done without VBA using only Excel and iteration? If so a detailed explanation (using the example above) would be much appreciated.


VBA code to solve above:
Code:

Public Function GetFrictionFactor(rgRe As Range, rgK As Range, rgDh As Range) As Double
  Dim Eqn1 As Double, Eqn2 As Double
  Dim Lambda As Double
  Dim Increment As Double, Tolerance As Double
  
  Lambda = 0.0001
  Increment = 0.000001
  Tolerance = 0.00005

  Do
    Eqn1 = -2 * Log(2.51 / (rgRe.Value * (Lambda ^ 0.5)) + (rgK.Value / rgDh.Value) / 3.72) / Log(10)
    Eqn2 = 1 / (Lambda ^ 0.5)
  
    If Eqn2 - Eqn1

OK, I know that you can use scripts to call calculators such as the following.

Code:

Sub OpCalc_Click()
'Standard Module code!

On Error GoTo Err_OpCalc_Click
ActiveSheet.Select

'Open the Calculator!
Call Shell("Calc.exe", 1)

Exit_OpCalc_Click:
Exit Sub

Err_OpCalc_Click:
MsgBox Err.Description
Resume Exit_OpCalc_Click

End Sub

However, I would like to make my own userform calculator so that I can modify the way it looks, size, font etc... and can add in other things if need be.

Does someone have a worbook that they can provide that has the scripts for a userform calculator that I can then modify the look etc.... to suite my desires.

I have searched the net but haven't found anything worth while.

Thanks

I'm trying to set up a report that calculates fees in order to validate fee
calculations on another system. Column one contains a reference to a fee
schedule; i.e. schedule A, schedule B etc. Column 2 contains the account
value. So I need to look up the appropriate schedule, use the appropriate
calculator and return the result into column 3. Part of my problem is that
the fee calculators are not in a single cell, although I could probably
re-write them if I have to. (The fee calculators discount for higher
balances- i.e. 1.00% of the first $500,00, .85% of the next $500,000, .75% of
the next $1,000,000, etc) Any ideas and/or formatting suggestions would be
appreciated!

I have an Excel 2003 spreadsheet used to calculate doses of medication. The value of several cells will depend on what optionbuttons the user selects.

I have entered the first two lines of code below w/o a problem to make certain calculations that are displayed in the specified cells. I then tried to make an additional calculation to display in cell 6,9, but it always triggers a "Application-defined or object-defined error". For troubleshooting purposes, I moved that line of code directly under the other two lines of similar code that I know work, and simplified the problem line to just arbitrarily set the value of the cell to a value of 2 (instead of the actual formula); it still triggers the error.

Code:

'CVM Pharmacy Protocol
Worksheets("CRI CALCULATOR").Cells(16, 3).Value = Worksheets("CRI CALCULATOR").Cells(5, 8).Value / ((Worksheets("CRI CALCULATOR").Cells(15, 3).Value * Worksheets("CRI CALCULATOR").Cells(3, 8).Value) / Worksheets("CRI CALCULATOR").Cells(10, 3).Value)
Worksheets("CRI CALCULATOR").Cells(16, 8).Value = ((Worksheets("CRI CALCULATOR").Cells(5, 8).Value / Worksheets("CRI CALCULATOR").Cells(17, 8).Value) * Worksheets("CRI CALCULATOR").Cells(10, 3).Value) / Worksheets("CRI CALCULATOR").Cells(3, 8).Value
Worksheets("CRI CALCULATOR").Cells(6, 9).Value = 2

I really would appreciate insight as to why this simple change in a cell value is triggering an error. I've attached the file. To trigger the error, pull up the worksheet "CRI Calculator" and click on either of the optionbuttons with blue text, or double-click on a name in the list-box. The worksheet is protected but it has no password, so it should unprotect easily. Thanks!

Hi
I have a mesh of Networking equipment in my office and we have an excel sheet maintaining the interconnectivity of the routers

Near End Far End
Router-6 Router-5
Router-7 Router-5
Router-5 Router-3
Router-3 Router-4
Router-3 Router-1
Router-1 Router-2
Gateway Router-1

Now as you can see the arrangement of "Near End" and "Far End" is totally arbitrary. The actual connectivity is as follows

Gateway
/
/
/
Router-1
/ \
/ \
/ \
Router-3 Router-2
/ \
/ \
/ \
Router-4 Router-5
/ \
/ \
/ \
Router-6 Router-7
I wish to make a macro that can give me the appropriate "Far End" that connects the node to the gateway. For example given Router-3 the correct "Far End" would be Router-1. The End Result of this macro would be something like this:

Near End Far End
Router-6 Router-5
Router-7 Router-5
Router-5 Router-3
Router-3 Router-1
Router-4 Router-3
Router-2 Router-1
Router-1 Gateway

Any help is highly appreciated.

I have recently made a calculator with UserForm (in Excel 2003) and would like to convert it to an Add-in to distribute to my colleagues. I've read several references as well as a link posted in this forum but still cannot get it save properly.

Most instructions say to start with a new empty workbook but I've already put in a lot of time with this calculator and don't want to remake the userform. The references say I need to add a Toolbar.

I understand the need to unload the toolbar when exiting and some of the concepts but I'm having trouble saving as .xla file.

I've put the following into This Workbook

Private Sub Workbook_BeforeClose()
Toolbars("Calculators").Visible = False
End Sub
Private Sub Workbook_Open()
Toolbars("Calculators").Visible = True
End Sub

When I go to compile I get the following error message that I don't understand.

"Compile error:
Procedure declaration does not match description of event or procedure having the same name"
It then highlights the first Private Sub Workbook_BeforeClose() line. (The info after the help button wasn't helpful to me.)

I took this straight from a book and followed the multiple steps.

Thanks,
Philro

Thanks very much Ron - That'll work just fine.
--
Regards,

Shaun C.


"Ron Coderre" wrote:

> Since the time zone is a Windows setting, you'll need something like Chip
> Pearson's time zone functions:
>
> http://www.cpearson.com/excel/timezone.htm
> (that site includes a link to a workbook you can download that contains the
> functions you'll need)
>
> Does that help?
>
> ***********
> Regards,
> Ron
>
> XL2002, WinXP-Pro
>
>
> "Shaun_C" wrote:
>
> > Does anyone know how to determine the current time zone in Excel? - OR - How
> > to convert the time provided by the NOW() function to UTC?
> >
> > I have a s.sheet that displays the current date and time for project
> > participants based all over the world. To do this i use the "=NOW()"
> > function and calculate the other project members time by adding or
> > subtracting an ofset. The problem is that if one of the other project
> > members opens the s.sheet (say in France) the calculations are wrong as NOW()
> > always returns their local time.
> >
> >
> > --
> > Regards,
> >
> > Shaun C.

I am trying to create my own dutching calculator but I have become stuck.

Here is an online dutching calculator:
http://www.ukhorseracing.co.uk/tools...Calculator.asp

I also have this one (attached file) but it is locked, so I cannot edit it. I can't even understand how it works as the formula refers to empty cells.

Thanks in advance.

Dan

Instead of having to pull up the calculator off the start menu then transfer
that data to excel, it would be great if we could have a way to calculate
within the cell we want the data.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming

sorry typo
http://www.eaglepi.com/formula/example.xls



"No" <no@isp.com> wrote in message news:...
> I created a workbook and tried to explain the best I could how everything
> should be. you can download the workbook at,
> http://www.eaglepi.com/formlua/example.xls
>
> I really appreciate everyones help on this.....
>
>
> "CLR" <croberts@tampabay.rr.com> wrote in message
> news:%235IxtFEHFHA.2936@TK2MSFTNGP15.phx.gbl...
> > Maybe in cell J2 you could put the formula =H2+I2, which would give you
> the
> > sum of the Co-pay(H2), and the percentage of the balance
> > (I2).................or, this could be incorporated into the I2 formula
by
> > adding +H2 to the end of it...........
> >
> > If that don't get it, then please tell us exactly "how" the formulas are
> not
> > working for you.........you've told us how you want the cells to be, and
> we
> > believe we've given you formulas to do that, but you say they are not
> giving
> > the correct results, so in order for us to help, you will have to
describe
> > exactly what is going wrong.......maybe put up another web page with the
> > formulas we've given you in place and a description of what's not
> > working..........or, you can send me your file direct to my home addy
and
> I
> > will take a look for you
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> >
> >
> > "No" <no@isp.com> wrote in message
> > news:1121c1pdoq9u32d@corp.supernews.com...
> > > OK thanks for your help, here is what I want to happen.
> > >
> > > in " D " start with a price of $107.75 "E " should be "NO" " F "
should
> be
> > > "yes" " G " should be "no" " H " should be $10.00
> > >
> > > example: if in "D" the amount is $107.75 and in "e" is "no" "f' is
"yes"
> > > 'g' is "no" " h " would have $10.00, " i " would be total of $107.75
> > minus
> > > (H)$10=$97.75 X 30% = $29.33 Now I'll explain what this is, "D"
is
> > the
> > > cost of a prescription drug
> > >
> > > "E" Generic ? yes or no
> > >
> > > "F" Brand Name ? yes or no
> > >
> > > "G" Non-Brand Name ? yes or no
> > >
> > > "H" is the co-pay,
> > >
> > > if it's generic co-pay =$5 plus 20% of balance
> > >
> > > if it's Brand Name =$10 plus 30% of balance
> > >
> > > if it's Non-Brand Name =$20 plus 50% of balance
> > >
> > > "I" would be the total after taking the Cost $107.75, because it's a
> brand
> > > name drug the co-pay would be $10 now you would take $107.75
> > minus$10=$97.75
> > > X 30%= $29.33 So the total in I for this example should be $29.33
> > >
> > >
> > >
> > > Hope that makes it easier to understand
> > >
> > >
> > >
> > > "Dana DeLouis" <delouis@bellsouth.net> wrote in message
> > > news:u2IvBICHFHA.1500@TK2MSFTNGP09.phx.gbl...
> > >
> > >
> > >
> > >
> > > > I think there are better ways, but here is one quick and dirty
option.
> > > >
> > > > H1 ->
> > > > =SUMPRODUCT(--(E1:G1="yes"),{5,10,20})
> > > >
> > > > I1->
> > > > =(C1-SUMPRODUCT( --(E1:G1="yes"),{5,10,20})) *
> > > > SUMPRODUCT( --(E1:G1="yes"),{0.2,0.3,0.5})
> > > >
> > > >
> > > > Perhaps use Data Validation to make sure you have at most one "yes"
in
> > > > E1:G1.
> > > > HTH
> > > > --
> > > > Dana DeLouis
> > > > Win XP & Office 2003
> > > >
> > > >
> > > > "No" <no@isp.com> wrote in message
> > > > news:112189bp31f8hd3@corp.supernews.com...
> > > > > So far nobody has given me a formula for " I " that works, some
work
> > but
> > > > > the
> > > > > calculations are wrong..
> > > > >
> > > > > I'm still trying to figure it out and welcome any help.
> > > > >
> > > > > "Sandy Mann" <sandymann@mailinator.com> wrote in message
> > > > > news:%230KWrYBHFHA.3332@TK2MSFTNGP15.phx.gbl...
> > > > >> There is nothing wrong with the answers that you have been given,
> so
> > > just
> > > > >> for the exercise:
> > > > >>
> > > > >>
> > > > >>
> > >
> =IF(COUNTIF(E2:G2,"Yes")>0,SUM((H2={5,10,20})*((C2-H2)*{0.2,0.3,0.5})),"")
> > > > >>
> > > > >> Regards
> > > > >>
> > > > >> Sandy
> > > > >> --
> > > > >> to e-mail direct replace @mailinator.com with @tiscali.co.uk
> > > > >>
> > > > >>
> > > > >> "No" <no@isp.com> wrote in message
> > > > >> news:111vfgeiq9r8l6f@corp.supernews.com...
> > > > >> > Because it isn't right to have attachments with posts I have
> > created
> > > a
> > > > >> > webpage to show what formulas I need help with.
> > > > >> > The link is
> > > > >> > http://www.eaglepi.com/formula/index.html
> > > > >> >
> > > > >> > Everything should be clear as to what I need, I have given
> examples
> > > to
> > > > >> help
> > > > >> > you understand what I am trying to do.
> > > > >> >
> > > > >> > Thank you in advance
> > > > >> >
> > > > >> >
> > > > >>
> > > > >>
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Hi, I'm trying to set up a direct link to the internal excel calculator, using a button in VBA.

I have the shortcut on my own toolbar, but I have many users that use the workbook, and to get them all to set up is almost impossible, so I am trying to make it simple for them.

I've tried doing it through a hyperlink direct to the calc.exe file, but get a lot of messages popping up (that'll scare a few of them).

So thought I would try and find the excel name for it and use VBA, but I cannot find it anywhere.

Can anyone help ?.

Basicaly the only formula I can use is the if formula but everytime I use it it ends up looking like a mess and the fomulas cause me a headache when I convert it to earlier excel programs

=IF('Cookie Calculator'!$B$3=Sheet1!$B$3,Sheet1!$M4,IF('Cookie Calculator'!$B$3=Sheet1!$C$3,Sheet1!$N4,IF('Cookie Calculator'!$B$3=Sheet1!$D$3,Sheet1!$O4,IF('Cookie Calculator'!$B$3=Sheet1!$E$3,Sheet1!$P4,IF('Cookie Calculator'!$B$3=Sheet1!$F$3,Sheet1!$Q4,IF('Cookie Calculator'!$B$3=Sheet1!$G$3,Sheet1!$R4,IF('Cookie Calculator'!$B$3=Sheet1!$H$3,Sheet1!$S4)))))))+3

Ive even broken some of these formulas up for when there are 2 reference,

=IF($B$1=Sheet1!$A$4,Sheet1!X4-$C5,IF($B$1=Sheet1!$A$5,Sheet1!X8-$C5,IF($B$1=Sheet1!$A$6,Sheet1!X12-$C5,IF($B$1=Sheet1!$A$7,Sheet1!X16-$C5,IF($B$1=Sheet1!$A$8,Sheet1!X20-$C5,IF($B$1=Sheet1!$A$9,Sheet1!X24-$C5,IF($B$1=Sheet1!$A$10,Sheet1!X28-$C5,IF($B$1=Sheet1!$A$11,Sheet1!X32-$C5,IF($B$1=Sheet1!$A$12,Sheet1!X36-$C5,IF($B$1=Sheet1!$A$13,Sheet1!X40-$C5,IF($B$1=Sheet1!$A$14,Sheet1!X44-$C5,IF($B$1=Sheet1!$A$15,Sheet1!X48-$C5,IF($B$1=Sheet1!$A$16,Sheet1!X52-$C5,IF($B$1=Sheet1!$A$17,Sheet1!X56-$C5,IF($B$1=Sheet1!$A$18,Sheet1!X60-$C5,IF($B$1=Sheet1!$A$19,Sheet1!X64-$C5))))))))))))))))

As you can see this is starting to become a bit of a mess, could someone tell me where I can go to learn about formulas in english so I know which one to use and when.

I have attached a worksheet so you can see how I make a simple thing turn into a big episode due to not understanding what formula to use where.

Hello,
I am trying to set up a Calculator which results in the Number of Roof Tiles I need for a House construction.
Most of the Calculators I have found are imperial but I need metric.

Does anyone have any ideas please
Thanks
Barry

I have attached an example

I have a spreadsheet where my calculation ( results ) should be the same as if you were to calculate the same input as on a calculator.

Example :

Cell A = .351
Cell B = 9.444
Cell C = 34.444

When I use the following formula : A / B*C = 1.28011 is my answer

When I calculate the same thing on a calculator my result is 1.28055

This gives me a variance of -0.044% which I cannot "use" because this can cause an incremental increase which I cannot allow for my calculations.

Is there any advice or guidance that anyone can give to help me with this? I basically need my numbers to "match" what will calc out on a calculator for those who do not have access to Excel. Thanks in advance.

I have found a on line calculator. What formula I have to use in excel to get the same result?

Current age:30
Monthly pension required from age 60 (Rs.) 5000
Growth rate per anum 10

The answers comes as :
Annual premium payable till age 60 (Rs.) 7,267
Retirement fund available at age 60 (Rs.) 817,381

Link for the calculator is:
http://www.costofpostponement.com/Aviva_PWPP_PPC_IN.htm

Hi all,

Ajay if you are able to assist me with this I would be most greatful, since you have the history with this spreadsheet. I will attach it again, but this time I need the program to function off of the "AFTERNOON *** CALCULATOR". I tried copying the program from the "MORNING *** CALCULATOR" into this worksheet, and changed "MORNING" to "AFTERNOON" in the code, but it does not work. I need it to look at the date (which is tomorrows date in the afternoon calculator. cell O24) and add the corresponding value in column F of the "*** LOG SHEET"

this is the thread with all of the history from the first time around
http://www.excelforum.com/excel-prog...dependant.html

I need to find a way to have Excel find a link and click on the link in Internet Explorer.

The link name is unique in the page, and the href looks something like this.

HTML Code:

<A HREF="http://www.somelink.com" target="_report" *******="click=1;">Some Link</A>

Thanks!

I tried searching through the forum to find a solution to this, but I found none that fit exactly. Granted I didn't check each of the 400+ thread. SO I apologize in advance if this has been covered.

Okay attached is an example of the timesheet that I am working with. I have tried a bunch of formulas that worked for the most part, but then one thing wouldn't one. So I decided to ask for help.

On the worksheet, you will see that there is 2 workbooks, Time Calculator and Employee 1. Here the thing. I need 'Employee 1"!C8 to = 'Time Calculator'!O5 if it is under 40 hrs. If the sum of 'Time Calculator'!M5 and 'Time Calculator'!O5 > 40 hours, 'Employee 1'!C8 needs to show the amount of hours used to equal 40 hours and then put the rest in 'Employee 1'!C9 (o/t).

ex.
Time Calculator M5= 21 hrs
Time Calculator O5= 21 hrs
Time Calculator Q5= 15 hrs

Employee 1 B8 should = 21 hrs
Employee 1 C8 should = 19 hrs and Employee 1 C9 = 2 hrs
Employee 1 D8 should = 0 hrs and Employee 1 D9=15 hrs

If you need further explaining, just ask. Thanks for your expert help in advance.