ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Make a Fresnel Zone Calculator (https://www.excelbanter.com/excel-programming/322795-make-fresnel-zone-calculator.html)

SlimPickins

Make a Fresnel Zone Calculator
 
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.wisp-router.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

Harlan Grove

Make a Fresnel Zone Calculator
 
"SlimPickins" 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.wisp-router.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?



SlimPickins

Make a Fresnel Zone Calculator - Fresnel.xls (0/1)
 
I found this fresnel.xls. It should be attached, if I didn't screw it
up.

S

On Wed, 9 Feb 2005 18:33:28 -0800, "Harlan Grove"
wrote:

"SlimPickins" 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.wisp-router.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?



Harlan Grove

Make a Fresnel Zone Calculator - Fresnel.xls (0/1)
 
"SlimPickins" wrote...
I found this fresnel.xls. It should be attached, if I didn't screw it
up.

....

Don't attach binary files to postings to nonbinary newsgroups. Very bad
conduct. Far better to provide the url to where you found the file.



[email protected]

Make a Fresnel Zone Calculator - Fresnel.xls (0/1)
 
Sorry, was not meaning to disrespect the group.

On Wed, 9 Feb 2005 21:26:08 -0800, "Harlan Grove"
wrote:

"SlimPickins" wrote...
I found this fresnel.xls. It should be attached, if I didn't screw it
up.

...

Don't attach binary files to postings to nonbinary newsgroups. Very bad
conduct. Far better to provide the url to where you found the file.




All times are GMT +1. The time now is 11:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com