Make A Fresnel Zone Calculator 


Make A Fresnel Zone Calculator  Excel 
View Answers 
"SlimPickins" <mayoroy@bellsouth.net> wrote...
>I wantt to make a calculator with excel. I know some excel basics, but
>I need help with the formula in the link below.
>
>http://www.softwright.com/faq/engine...Clearance.html
Presumably you'd be entering N, lambda, D_1 and D_2, and want F_N. If so,
calculate F_N as
=SQRT(N*lambda*HARMEAN(D_1,D_2))
>I would also like downtilt and azimuth calculators from the link
>below.
>
>http://www.wisprouter.com/calculators/fresnel.php
I'd need to edit this site's source to find the formulas in the php code.
You wouldn't happen to have a more explicit reference, would you?
>I wantt to make a calculator with excel. I know some excel basics, but
>I need help with the formula in the link below.
>
>http://www.softwright.com/faq/engine...Clearance.html
Presumably you'd be entering N, lambda, D_1 and D_2, and want F_N. If so,
calculate F_N as
=SQRT(N*lambda*HARMEAN(D_1,D_2))
>I would also like downtilt and azimuth calculators from the link
>below.
>
>http://www.wisprouter.com/calculators/fresnel.php
I'd need to edit this site's source to find the formulas in the php code.
You wouldn't happen to have a more explicit reference, would you?
Similar Excel Video Tutorials
Buy, Do Up and Sell Calculator
 ExcelExperts.com brings you training video on: Buy, Do Up and Sell Calculator ...
VLOOKUP for Mortgage Calculator
 See how to use VLOOKUP to create a Mortgage Calculator that can handle 4 different types of loans: Begin Annuity, End Annuity, Interest Only and Other ...
How Much Can I Spend On A House ? Calculator
 ExcelExperts.com brings you a training video on: How Much Can I Spend On A House ? Calculator ...
Helpful Excel Macros
Display The Actual Link / Email Address From Links in Excel  UDF
 Display the actual link or email address from links within Excel with this UDF. This user defined function pulls the ac
 Display the actual link or email address from links within Excel with this UDF. This user defined function pulls the ac
Excel Macro to Save a Specific Worksheet as a New File
 This Excel Macro allows you to save a specific worksheet within the Excel Workbook to its own new file. You will be a
 This Excel Macro allows you to save a specific worksheet within the Excel Workbook to its own new file. You will be a
Hide Formulas in a Worksheet and Prevent Deletion
 This macro will hide all formulas within a workbook and not allow them to be deleted. The page will not be protected li
 This macro will hide all formulas within a workbook and not allow them to be deleted. The page will not be protected li
Basic Web Query in Excel  Import Data from the Web into Excel
 Import data from the web into Excel with this macro. This is a basic web query macro that will import data from any web
 Import data from the web into Excel with this macro. This is a basic web query macro that will import data from any web
Macro to add a New Line to Message Box Popup Windows in Excel
 This is a very simple Message Box, popup window, macro for Excel that illustrates how to put new lines, the same thi
 This is a very simple Message Box, popup window, macro for Excel that illustrates how to put new lines, the same thi
Similar Topics
"SlimPickins" <mayoroy@bellsouth.net> wrote...
>I wantt to make a calculator with excel. I know some excel basics, but
>I need help with the formula in the link below.
>
>http://www.softwright.com/faq/engine...Clearance.html
Presumably you'd be entering N, lambda, D_1 and D_2, and want F_N. If so,
calculate F_N as
=SQRT(N*lambda*HARMEAN(D_1,D_2))
>I would also like downtilt and azimuth calculators from the link
>below.
>
>http://www.wisprouter.com/calculators/fresnel.php
I'd need to edit this site's source to find the formulas in the php code.
You wouldn't happen to have a more explicit reference, would you?
>I wantt to make a calculator with excel. I know some excel basics, but
>I need help with the formula in the link below.
>
>http://www.softwright.com/faq/engine...Clearance.html
Presumably you'd be entering N, lambda, D_1 and D_2, and want F_N. If so,
calculate F_N as
=SQRT(N*lambda*HARMEAN(D_1,D_2))
>I would also like downtilt and azimuth calculators from the link
>below.
>
>http://www.wisprouter.com/calculators/fresnel.php
I'd need to edit this site's source to find the formulas in the php code.
You wouldn't happen to have a more explicit reference, would you?
I wantt to make a calculator with excel. I know some excel basics, but
I need help with the formula in the link below.
http://www.softwright.com/faq/engine...Clearance.html
I would also like downtilt and azimuth calculators from the link
below.
http://www.wisprouter.com/calculators/fresnel.php
Again I need help with the formulas. I could use these but I need them
offline also. This is where excel comes in.
I know how to ste the name fields and have an area for the value to be
entered, the formula is killing me.
Thanks
Slim
I need help with the formula in the link below.
http://www.softwright.com/faq/engine...Clearance.html
I would also like downtilt and azimuth calculators from the link
below.
http://www.wisprouter.com/calculators/fresnel.php
Again I need help with the formulas. I could use these but I need them
offline also. This is where excel comes in.
I know how to ste the name fields and have an area for the value to be
entered, the formula is killing me.
Thanks
Slim
I wantt to make a calculator with excel. I know some excel basics, but
I need help with the formula in the link below.
http://www.softwright.com/faq/engine...Clearance.html
I would also like downtilt and azimuth calculators from the link
below.
http://www.wisprouter.com/calculators/fresnel.php
Again I need help with the formulas. I could use these but I need them
offline also. This is where excel comes in.
I know how to ste the name fields and have an area for the value to be
entered, the formula is killing me.
Thanks
Slim
I need help with the formula in the link below.
http://www.softwright.com/faq/engine...Clearance.html
I would also like downtilt and azimuth calculators from the link
below.
http://www.wisprouter.com/calculators/fresnel.php
Again I need help with the formulas. I could use these but I need them
offline also. This is where excel comes in.
I know how to ste the name fields and have an area for the value to be
entered, the formula is killing me.
Thanks
Slim
All,
If anyone can help with this, they are a legend. It will save me so much time.
My boss wants me to use the Westbay call centre calculator (http://www.erlang.com/calculator/call/) as they believe this is the most accurate when working out how many agents we need. However, plugging figures in to this calculator is tedious and not time effective (you can tell I work in a call centre), especially when using massive amounts of data.
I have downloaded Erlang C for Excel and I have used the example document which comes in the .zip file. To make this explanation easier I have made a few tweaks to make look it look similar the Westbay calculator in format.
Now to my problem. When figures are plugged in to both calculators the number of agents does not match.
Westbay Calculator
Excel Calculator
Any idea why this is and what I can do to make them match?
Ideally I would like the Excel document to return the exact same figures as the Westbay tool.
Many thanks,
Lee.
If anyone can help with this, they are a legend. It will save me so much time.
My boss wants me to use the Westbay call centre calculator (http://www.erlang.com/calculator/call/) as they believe this is the most accurate when working out how many agents we need. However, plugging figures in to this calculator is tedious and not time effective (you can tell I work in a call centre), especially when using massive amounts of data.
I have downloaded Erlang C for Excel and I have used the example document which comes in the .zip file. To make this explanation easier I have made a few tweaks to make look it look similar the Westbay calculator in format.
Now to my problem. When figures are plugged in to both calculators the number of agents does not match.
Westbay Calculator
Excel Calculator
Any idea why this is and what I can do to make them match?
Ideally I would like the Excel document to return the exact same figures as the Westbay tool.
Many thanks,
Lee.
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.
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
http://www.hughchou.org/calc/income.php
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.
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.
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:
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:
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
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
rewrite 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!
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
rewrite 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!
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
Router6 Router5
Router7 Router5
Router5 Router3
Router3 Router4
Router3 Router1
Router1 Router2
Gateway Router1
Now as you can see the arrangement of "Near End" and "Far End" is totally arbitrary. The actual connectivity is as follows
Gateway
/
/
/
Router1
/ \
/ \
/ \
Router3 Router2
/ \
/ \
/ \
Router4 Router5
/ \
/ \
/ \
Router6 Router7
I wish to make a macro that can give me the appropriate "Far End" that connects the node to the gateway. For example given Router3 the correct "Far End" would be Router1. The End Result of this macro would be something like this:
Near End Far End
Router6 Router5
Router7 Router5
Router5 Router3
Router3 Router1
Router4 Router3
Router2 Router1
Router1 Gateway
Any help is highly appreciated.
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
Router6 Router5
Router7 Router5
Router5 Router3
Router3 Router4
Router3 Router1
Router1 Router2
Gateway Router1
Now as you can see the arrangement of "Near End" and "Far End" is totally arbitrary. The actual connectivity is as follows
Gateway
/
/
/
Router1
/ \
/ \
/ \
Router3 Router2
/ \
/ \
/ \
Router4 Router5
/ \
/ \
/ \
Router6 Router7
I wish to make a macro that can give me the appropriate "Far End" that connects the node to the gateway. For example given Router3 the correct "Far End" would be Router1. The End Result of this macro would be something like this:
Near End Far End
Router6 Router5
Router7 Router5
Router5 Router3
Router3 Router1
Router4 Router3
Router2 Router1
Router1 Gateway
Any help is highly 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 "Applicationdefined or objectdefined 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:
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 doubleclick on a name in the listbox. The worksheet is protected but it has no password, so it should unprotect easily. Thanks!
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 "Applicationdefined or objectdefined 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 doubleclick on a name in the listbox. The worksheet is protected but it has no password, so it should unprotect easily. Thanks!
I have recently made a calculator with UserForm (in Excel 2003) and would like to convert it to an Addin 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
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
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
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
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, WinXPPro
>
>
> "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.

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, WinXPPro
>
>
> "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.
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 ?.
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 ?.
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 Webbased Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/comm...el.programming
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 Webbased 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 Copay(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" NonBrand Name ? yes or no
> > >
> > > "H" is the copay,
> > >
> > > if it's generic copay =$5 plus 20% of balance
> > >
> > > if it's Brand Name =$10 plus 30% of balance
> > >
> > > if it's NonBrand 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 copay 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>
> > > > =(C1SUMPRODUCT( (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})*((C2H2)*{0.2,0.3,0.5})),"")
> > > > >>
> > > > >> Regards
> > > > >>
> > > > >> Sandy
> > > > >> 
> > > > >> to email 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
> > > > >> >
> > > > >> >
> > > > >>
> > > > >>
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
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 Copay(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" NonBrand Name ? yes or no
> > >
> > > "H" is the copay,
> > >
> > > if it's generic copay =$5 plus 20% of balance
> > >
> > > if it's Brand Name =$10 plus 30% of balance
> > >
> > > if it's NonBrand 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 copay 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>
> > > > =(C1SUMPRODUCT( (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})*((C2H2)*{0.2,0.3,0.5})),"")
> > > > >>
> > > > >> Regards
> > > > >>
> > > > >> Sandy
> > > > >> 
> > > > >> to email 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
> > > > >> >
> > > > >> >
> > > > >>
> > > > >>
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
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.
=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 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
Hi all,
Been a closet viewer for a while now so finally decided to become a member and try and help out.
I have a vast experience using excel and im a modest VBA programmer.
I generally build shop floor production gantt charts in excel enginerring calculators and wage/overtime calculators etc.
I also build html and php websites but mainly utilise the open source code to create them these days.
Have a good day and ill see you round.
Dan.
Hi everyone!
I need a little help here please, I need a Search Engine that displays the query results in an alphabetical/alphanumerical order. I have provided a Sample Workbook, and a Link to the Original Thread, these are listed below.
So the search engine part is fine, but the issue at hand is getting Excel to display the results alphabetically. I understand the reason that they are not is due to the way Excel is ranking the results as relevent to the query. I am fairly new to using basic formulas to make Excel do what I want, and also new to actually understanding how the formulae work, so any information on this, tips&tricks, or if someone wants to edit the formulae within the Sample Workbook to force the Search Engine to display the query results in an alphabetical/alphanumerical order, would prove extremely useful. Thank you!!!
FYI: The Search Engine pulls from the Column labeled "Site_PCode" in every tab, so if you type "b" within the "PostCode Fragment" Query cell on the "Search" tab, and then note the way the results are displayed, you will understand what I mean.
Original Thread: http://www.excelforum.com/excelgene...readsheet.html
Sample Workbook: http://www.excelforum.com/attachment...atrixnew.xlsx
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.
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
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
Hello
I have built a quite extensive loan calculator, for both Annuitet and even repayments, and the calculator is working fine.
The formulas for it are a bit complex (perhaps I wrote them a bit too complicated )
Anyway, I want to be able to pay into the principal amount at any given time in the model, but I have no idea how to adjust the formulas to replicate that?
Can anyone assist?
I have attached the document for further verification.
MAny Thanks!
Loan Calculator.xlsxLoan Calculator.xlsx