Averages in the data area in pivot table?

User Help for GS-Base

Averages in the data area in pivot table?

Postby tonto » Fri Nov 18, 2011 8:52 pm

I'm wanting to use GS-Base to make a yield map from combine yield monitor data. Yield monitors calculate yield at a given point in a field and record it with the latitude and longitude at that point. I used to spend hours combining the data so that I could use Excel 2003 to form a pivot table with the data. Now I'm trying to use GS-Base to do the same thing. What I want to do is generate a pivot table where the latitude is in rows and the longitude is in fields with the yield amounts in the data field. The yield monitor registers the data in both pounds and average yield. For a given longitude and latitude to the fourth decimal place there may be several average yields to combine. What I need for each data cell is an average of the average yield, not a sum, minimum, or maximum, although useful. I could sum the pounds but I'd need to divide each of the data cells in the table somehow? Any ideas?
tonto
 
Posts: 4
Joined: Mon Sep 05, 2011 7:06 pm

Re: Averages in the data area in pivot table?

Postby citadel5 » Sat Nov 19, 2011 7:17 pm

You can obtain both the "sum" and "count" values, but there is no simple solution to obtain the "sum/count" value (I assume you mean the arithmetic mean?). You would need to save a given table as text and use e.g. GS-Calc (but then this all could be done in GS-Calc as well).
I think new data functions should appear in the next update. Hopefully before the end of the year.
User avatar
citadel5
 
Posts: 114
Joined: Tue Apr 20, 2010 11:58 pm

Re: Averages in the data area in pivot table?

Postby tonto » Sun Nov 20, 2011 1:45 am

Yes, I meant mean. Actually,median might be better as yield monitors will sometimes throw out too high yields. Generally they're filtered out by most yield mapping software. I can work around this but I just thought there might be a solution I wasn't aware of yet. Using GS-Base has been the fastest I've ever created a basic yield map in a pivot table. Thanks for your informational response.
tonto
 
Posts: 4
Joined: Mon Sep 05, 2011 7:06 pm


Return to GS-Base Support

Who is online

Users browsing this forum: No registered users and 1 guest

cron