LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Old December 1st 08, 09:36 PM posted to sci.physics.electromag,rec.radio.amateur.antenna
external usenet poster
 
First recorded activity by RadioBanter: Mar 2008
Posts: 329
Default Numerical integration and MS Excel "data table" function problem

On 1 dic, 13:16, Bob Bob wrote:
Hi Wim

I'll admit I am having difficulty visualizing what you are doing with
data tables and was about to suggest using a macro to generate the plot
values until I saw your "no VB" comment.

When you say "data table", is that a pivot table? I have sheets with
calcs based on pivot table outputs that are then used in further pivot
tables. Looks horribly messy but it works. (Noting that the accuracy
problems arent a problem for me due to what I am calculating for)

Cheers Bob W5/VK2YQA

Wimpie wrote:
Does somebody know a solution for this (I do not prefer a VB one)?


Hello to Bob and the other contributors

I used the table function that enters row or column data into a
formula and plot the result under the row or right to the column. I
use the 2 variable version that results in a square with 400 cells. I
add them with the sum function.

The reason for mentioning "VB not preferred" is because of when I have
to divert to programming, I prefer to abandon Excel (for this
application) and use another environment.

Following this thread and advise from other people, I will abandon
Excel for this Fresnel calculation.

Regarding stability issues, some people also advised me to use the
Unix/Linux program instead of the windows port. So I still have to
do some investigation, as I do not have a machine with Linux on it.

Best regards and thanks for the info,

Wim
PA3DJS
www.tetech.nl
Remove abc and the mail address is OK.
 
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
Tecsun to release commemorative table radio "1994", OEM of VAL R-301s [email protected] Shortwave 0 August 20th 07 07:55 AM
"meltdown in progress"..."is amy fireproof"...The Actions Of A "Man" With Three College Degrees? K4YZ Policy 6 August 28th 06 11:11 PM
FREE! "THE CB EPROM DATA BOOK" OF FREQ. MODS Lou Franklin CB 2 January 11th 06 04:13 PM
FREE! "THE CB EPROM DATA BOOK" OF FREQ. MODS Lou Franklin CB 0 December 7th 05 02:58 AM
FREE! "THE CB EPROM DATA BOOK" OF FREQ. MODS Lou Franklin CB 0 November 21st 05 11:45 PM


All times are GMT +1. The time now is 12:48 PM.

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

About Us

"It's about Radio"

 

Copyright © 2017