Sorting problem with baseball averages

Question

Level 1

65 points

Sorting problem with baseball averages

Please help. I am new to iworks and am learning as I go. Overall I really just love it. Here is the proect that I am working on: I am doing a spreadsheet with the statistics for my son's baseball team. The spreadsheet looks really great. What I have is the following: individual averages for each player, and at the bottow of the row of averages, the overall team average.

The problem is that when I try to sort the row decending averages, the row does show the highest to the lowest average, but instead of leaving the team average at the very bottom, it is placing it within the individual team averages. So if the team average is .263, then the team average may end up between an average for a child of .300 and another with .250. How do I correct this so that the team average remains at the very bottom?

Also, the Averages display as 0.333. How do I get rid of the 0 in front of the .3?

thanks!!

Posted on Apr 17, 2011 5:42 PM

Reply

Answer 1

Apr 17, 2011 11:04 PM in response to Docal97

Docal,

The solution is to use a Footer Row for the Team Average. Headers and Footers don't participate in the Sort, so your Footer information will be safe there.

Assuming you are using Numbers 09, you can use Custom Format to add the leading zero to your decimal fraction.

Jerry

Reply

Answer 2

Barry

Level 9

59,861 points

Apr 17, 2011 11:10 PM in response to Docal97

Hi Docal,

Place the AVERAGE formula into a Footer Row. Header and Footer Rows are not included in sorts.

The leading zero on the averages, although not in line with baseball practices, is mathematically correct notation.

You can eliminate it by setting a custom format for cells in that column.

Drag the Decimals element to the format box, select it, and press the up arrow key to add a third decimal place.

Then, click the Integers Element placed in the box by default and press delete to delete it.

These steps have been completed in the illustration.

Regards,

Barry

Reply

Answer 3

Docal97 Author

Level 1

65 points

Apr 18, 2011 9:55 AM in response to Barry

thanks so much. I will try it this way.

Another question: When posting on iwork.com or printing my data, is there a way to remove the boxes (cells) from the final appearance so that it looks more professional?

Reply

Answer 4

Docal97 Author

Level 1

65 points

Apr 18, 2011 10:29 AM in response to Jerrold Green1

How does one make a row a Footer?

Reply

Answer 5

Apr 18, 2011 10:37 AM in response to Docal97

Docal,

From the Menus, with the table selected:

Table > Footer Rows > 1

You can also use the Format Bar and the Table Inspector.

Jerry

Reply

Answer 6

Docal97 Author

Level 1

65 points

Apr 18, 2011 10:43 AM in response to Docal97

Ok, so I seem to have eliminated the above zero in front of the average by using the custom formula above. So an average of 0.333 appears correctly as .333.

What I notice now is that if someone's average is .400 it will appear as .4. Any formula to fix this if it were to occur?

Reply

Answer 7

Barry

Level 9

59,861 points

Apr 18, 2011 7:46 PM in response to Docal97

Sorry, missed that part. Go back to the Custom format setting and Click the triangle at the right end of the Decimals element to open a menu. Choose "Show trailing zeroes."

Regarding printing:

Numbers prints what you see.

Select the cells that you want to have no visible borders.

Use the buttons in the Format bar or in the Table Inspector to do one of the following:

• Set the Border Style to "None"

• Leave the border style as is, but change the Border Colour to match the background colour.

The two methods have sightly different effects on the appearance of your document.

I'm not aware of how these settings will affect posts to iWork.com.

Regards,

Barry

Reply