[CoLoCo] Open office acting very weird

[Richard Guenther]

Hi Jim,

I think I have it working correctly now.  This page was pretty helpful:

http://homepage.mac.com/samchops/B733177502/C1517039664/E20061119075622/index.html

Anyway, the spreadsheet is attached.  The thing to look out for (also in
Excel, they say) is that the "class" of your data (in this case the integers
2,3,4....12) should only be highlighted or chosen to be one cell less than
you would think.  In my version of your spreadsheet, the classes in the
formula are D257 to D26*6* even though you'd think they would be D257 to D26
*7*.

See if that works now.

Richard



On Sun, Mar 30, 2008 at 5:22 PM, Jim Hutchinson <jim at ubuntu-rocks.org>
wrote:

> Attached is the spreadsheet with the data from my daughter's dice rolling
> with actual dice. We need to sum up the pairs and then count the frequencies
> of each sum 2-12. Odd thing is, when I use the frequency function I get the
> wrong answers. It tells me for example that in the first 252 sums (column d)
> there are 30 2s. There are not. There are also not 2 11s or 13 12s. Even
> more odd is that when I save, close and open the frequencies are different.
> They are changing on their own. This is really odd and I can't figure out
> why. I've tried changing the cell formatting but it didn't help. I noticed
> because the data was different from when we originally did this. The only
> change is that we were using gutsy then and hardy now.
>
> Feel free to explore this and let me know if you see the same odd
> behavior.
>
> Thanks,
> -jim
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://lists.ubuntu.com/archives/ubuntu-us-co/attachments/20080330/d96b362b/attachment-0001.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Dice_DataRG.ods
Type: application/vnd.oasis.opendocument.spreadsheet
Size: 22562 bytes
Desc: not available
Url : https://lists.ubuntu.com/archives/ubuntu-us-co/attachments/20080330/d96b362b/attachment-0001.ods