Microsoft Excel - Using excel to make discs,need help with zero results, leaves numbers in zero result space
Asked By dan heyvaert on 27-Apr-13 09:45 PM
I am making ASB discs with excel. E.g. a batter hits a home run 10% of the time. 10% of the circle is 36 degrees. This game has been around since the 1940's. The problem I am having is with the number"5" which represents triples. I am making a 2 ring template. One ring is the record against right hand pitchers and the other is for the record against left hand pitching. When I get a result of zero for the 5 it still displays a five on an empty space instead of ignoring it. I can email the template if either you can tell me how to do this at egghead or I can email it directly. All of this is kind of hard to explain and I like to at least show you a picture but I could not get it to paste here. Any assistance greatly appriciated.
Harry Boughen replied to dan heyvaert on 27-Apr-13 10:45 PM
You are right about it being hard to explain.
To post a file on the site you have to compress it using a program such as 7-Zip. Then, when you are in the edit area (making a post) at the top left there is an icon with a letterA and a paperclip. If you click on that it will take you to a dialog box where you click on the Upload button that allows you to browse your computer for the zip file and then you can upload it to the server. Once it is uploaded you select it and insert it into the post.
After that, maybe someone can help.
dan heyvaert replied to Harry Boughen on 28-Apr-13 08:18 PM
Thank you for your reply. I thought I followed your instructions, however, what zip 7 made did not in anyway resemble the excel file. Is this correct?
Harry Boughen replied to dan heyvaert on 28-Apr-13 08:45 PM
It is a compressed file that will look like rubbish if you open it with anything other than a de-compressing program such as 7-Zip or WinZip. It should have a name like xxxxx.zip.
dan heyvaert replied to Harry Boughen on 29-Apr-13 09:11 PM
Harry Boughen replied to dan heyvaert on 29-Apr-13 09:35 PM
Your file is there alright but the files are xml. I thought you were working in Excel?
dan heyvaert replied to Harry Boughen on 30-Apr-13 09:27 PM
It was in excel until I did the zip 7 thing to it.
Harry Boughen replied to dan heyvaert on 30-Apr-13 10:15 PM
Not sure what happened then but what you posted contained a number of directories and files labeled .xml. Some of them contained stuff that looked as if it might have been Excel-like. I assume you are using a bog standard Excel application.
Let's try again.
Open Explorer and find your file (Yourfilename.xls(x/m)). Right click on it and one of the options that comes up will be 7-Zip. Click on that and select Add to "Yourfilename.zip".
Find the .zip file and double click on it and 7-Zip should open it with a name that looks like the original. If you then double click on that it should open in Excel.
If it passes this test, then re-post it as you did before.
dan heyvaert replied to Harry Boughen on 30-Apr-13 11:26 PM
Will do tomorrow Harry. Thanks for your patience. This is a learning experience in more ways than one.
dan heyvaert replied to Harry Boughen on 01-May-13 10:02 PM
Harry Boughen replied to dan heyvaert on 01-May-13 11:52 PM
Seems like it is password protected.
dan heyvaert replied to Harry Boughen on 02-May-13 07:59 PM
Harry, I hope it works. When it asked for a password I used "harry". If this doesn't could I just email it ?
Harry Boughen replied to dan heyvaert on 04-May-13 03:10 AM
The problem is down to the fact that Excel uses the same categories for both series (in this case from ColumnA) and the category with the number 5 on the card4 sheet is the only one that is different. So it is nothing to do with the number 5 specifically, it could have been any number that met those criteria.
There is a manual way to fix it and I have done it for the card4 sheet.
2 right left splits George Brett, Mickey Mantle, et..xlsm.zip
What you have to do is select the labels in the outer ring and click one of them a second time to select just the one label. You can then go to the formula bar and enter a reference to the appropriate cell in ColumnK. Where there are consecutive zero values and no label showing you can temporarily fake in a value to expose the location while you access it to put in the reference. Then you can restore your formula. If the faked in values are too small the labels will be too close to select separately so a value of 0.1 (10%) would be a good one to use.
Hope you can manage but if you get really desperate, let me know and I can do the lot for you.
dan heyvaert replied to Harry Boughen on 04-May-13 08:36 PM
Many thanks for your assistance. I will print out your instructions, study it out, try to implement it, then let you know how I did.
dan heyvaert replied to Harry Boughen on 05-May-13 11:49 AM
I am sorry to say I did not have much luck trying to change the formula. I think you corrected the error on "sheet4". I actually print them from the "print discs" sheet. Could you give me a few pointers on this? Would calling work for you? I really want to be able to do these cause I like to learn and I have modified a three ring disc maker which shows batting right, left, and both ways and it has the same problem. Thanks! How did you get your excel proficiency?
Harry Boughen replied to dan heyvaert on 05-May-13 06:15 PM
Here are some more detailed instructions. Hope they help you to follow through. Let me know if you still have problems.
As to how I learned (am still learning) Excel, just by doing projects like you, and tapping other peoples knowledge.
dan heyvaert replied to Harry Boughen on 12-May-13 10:03 PM
Many, many, thanks for your proficient assisstance. I did not get it to work exactly like your instructions stated, but I improvised and am making ASB discs. Thank you so much!