Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.templates,microsoft.public.excel.setup,microsoft.public.excel.programming,microsoft.public.excel.miscmicrosoft.public.excel
external usenet poster
 
Posts: 2
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.excel
external usenet poster
 
Posts: 733
Default 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?


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.excel
external usenet poster
 
Posts: 2
Default 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?


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.excel
external usenet poster
 
Posts: 733
Default 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.


  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.excel
external usenet poster
 
Posts: 1
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert time from one zone to other zone in excel ram Excel Worksheet Functions 1 April 25th 07 01:24 PM
make excel appl. fit for euro zone Nick Hodge Excel Discussion (Misc queries) 0 July 23rd 05 08:08 PM
Make a Fresnel Zone Calculator Harlan Grove Excel Discussion (Misc queries) 4 February 10th 05 02:07 PM
Make a Fresnel Zone Calculator Harlan Grove Excel Worksheet Functions 4 February 10th 05 02:07 PM
Make a Fresnel Zone Calculator Setting up and Configuration of Excel 0 February 10th 05 01:09 PM


All times are GMT +1. The time now is 09:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"