|
|
Post by option1 on Jan 6, 2022 8:11:17 GMT -6
I would like to learn to build out automatic calculation spreadsheets for various aspects of our program. I'm not looking for templates.
We are looking at weight percentages, maxes, point values, etc. TIA
|
|
|
|
Post by carookie on Jan 6, 2022 19:01:07 GMT -6
I would like to learn to build out automatic calculation spreadsheets for various aspects of our program. I'm not looking for templates. We are looking at weight percentages, maxes, point values, etc. TIA Are you asking for how to set up all the formulas? I could probably explain that. Are you proficient at setting up and formatting your columns, cells, etc? |
|
|
|
Post by cqmiller on Jan 6, 2022 19:22:35 GMT -6
HIT ME UP COACH...
I can show you what I have already setup and see if we can make it fit for what you are looking for or I can walk you through setting one up the way you want.
|
|
|
|
Post by option1 on Jan 7, 2022 8:57:04 GMT -6
I would like to learn to build out automatic calculation spreadsheets for various aspects of our program. I'm not looking for templates. We are looking at weight percentages, maxes, point values, etc. TIA Are you asking for how to set up all the formulas? I could probably explain that. Are you proficient at setting up and formatting your columns, cells, etc? Since my post yesterday I was able to figure out how to create a simple max chart. ![]() PM's sent |
|
|
|
Post by option1 on Jan 7, 2022 14:54:02 GMT -6
Right now I'm stuck trying to get a data range to convert to points.
EXAMPLE: Here the first set of data is in the first cell and the point value is in the second. Excel is not recognizing that 6.07 is less than 6.13 and therefore will not apply a point total to any range of numbers between 6.07-6.13
6.07-6.13 1
|
|
|
|
Post by carookie on Jan 7, 2022 16:17:29 GMT -6
Right now I'm stuck trying to get a data range to convert to points. EXAMPLE: Here the first set of data is in the first cell and the point value is in the second. Excel is not recognizing that 6.07 is less than 6.13 and therefore will not apply a point total to any range of numbers between 6.07-6.13 6.07-6.13 1 Hmmm, so you have written "6.07-6.13" in a given cell. What specifically do you want done with that information? I think this refers to someone's 40 time improving, and you want them to receive points based on the improvement in speed? If so there are various ways you could do that in a formula. If this is so please let me know and I will share a few. |
|
|
|
Post by option1 on Jan 7, 2022 16:25:51 GMT -6
Yes, that's it. There are a few things that info in the cell needs to do.
1. Excel needs to recognize the entire range. Example: 6.13-6.07 = 1. When we put Jimmy's name down on sheet 3 with a 40 of 6.08 the point should auto tally 1, and so on.
2. It would be nice if I could figure out how to have from 4.4 to 6.13 auot populate in increments of .05. EX: 6.12-6.07
|
|
|
|
Post by carookie on Jan 7, 2022 18:41:38 GMT -6
Yes, that's it. There are a few things that info in the cell needs to do. 1. Excel needs to recognize the entire range. Example: 6.13-6.07 = 1. When we put Jimmy's name down on sheet 3 with a 40 of 6.08 the point should auto tally 1, and so on. 2. It would be nice if I could figure out how to have from 4.4 to 6.13 auot populate in increments of .05. EX: 6.12-6.07 My best advice would be to format your spreadsheet where you put each different time (6.13, 6.07, 4.40) in a different column. With excel its always best to keep each data point separated into its own cell. For Example: Column B is all of your initial 40 yard dash times (this would be where Jimmy ran a 6.13), then Column C would be there next 40 time (where Jimmy ran a 6.07). This would allow you to run all kinds of formulas with your data, while still keeping the 40 times visible. Let me know if you choose to do this, I can break down various formulas to get the results you want. If you are married to keeping it in one cell, then when you run the formula you will only see the outcome of the formula, and not the actual data. In regards to your second request that can be done. Select the cells you want to expand the decimals for, then click on the button in the top banner that has a left pointing arrow followed by a decimal point & zeroes "<--.000". This allows you to display numbers to the tenth, hundredth, etc. |
|
|
|
Post by cqmiller on Jan 7, 2022 20:28:50 GMT -6
You going to AFCA coach? Let's meet up if you are and get some of this done.
|
|
|
|
Post by option1 on Jan 8, 2022 5:07:05 GMT -6
Thanks guys!
|
|
