Re: spreadsheet manipulation of netcdf files

• To: Hamish Carpenter <hamish@xxxxxxxxxxxxxxx>
• Subject: Re: spreadsheet manipulation of netcdf files
• From: Bill Hibbard <hibbard@xxxxxxxxxxxxxxxxx>
• Date: Thu, 23 May 2002 05:38:35 -0500

Hi Hamish,

There are no data operators built into the SpreadSheet
formulas for computing the number of values meeting certain
conditions. You could write such operators in Java and then
invoke them from SpreadSheet formulas using the "link"
operator (for the details see section 2.3.2.4 of
http://www.ssec.wisc.edu/~curtis/README.ss).

However, what you really need is to write VisAD Python
programs. Python is great for hacking little analysis
programs, and then you can create SpreadSheet cells for
visualization right from Python. See Tom's excellent
VisAD Python tutorial at:

  http://www.ssec.wisc.edu/~tomw/visadtutor/index.html

Cheers,
Bill

Hamish Carpenter wrote:
> 
> hi all,
> 
> I'm new to visad and indeed data visualisation in general.  I have found the
> visad.ss.SpreadSheet application extremely useful in RAD.
> 
> Q-A) Is it possible to use the SpreadSheet application to manipulate
> different variables in the same NetCDF file?
> For example if I have a netCDF file with three dimensions:
> 1) Time
> 2) X coordinate
> 3) Y coordinate
> And two main variables:
> 1) No of Males
> 2) No of Females
> This is loaded into the spreadsheet cell A1.  I want A2 to equal the
> percentage of males
>  (A1(No of Males) / (A1(No of Females)+A1(No of Males)))
> this can then be animated over time to show population trends.
> 
> This is an example of course but I'm wondering if it can be done using the
> SpreadSheet as it is currently implemented.
> 
> Q-B) What file formats (apart from netcdf) support animation using the
> spreadsheet?
> I am currently using netCDF as it is the only one I'm managed to successfully
> do animation with.
> 
> Thanks in advance
> 
> Hamish Carpenter
> 

-- 
----------------------------------------------------------
Bill Hibbard, SSEC, 1225 W. Dayton St., Madison, WI  53706
hibbard@xxxxxxxxxxxxxxxxx  608-263-4427  fax: 608-263-6738
http://www.ssec.wisc.edu/~billh/vis.html

• References:
  • spreadsheet manipulation of netcdf files
    • From: Hamish Carpenter