points

Hello all. My work is instituting an incentive plan to encourage overtime when needed. They decided on a point system where you earn points for each hour you work of overtime. Each hour of each day may be worth a different point. As an example: Working 6:00 PM - 7:00 PM on Tuesday would be 1...

I have a line graph with a trend line and I was wondering is there a somewhat easy way to determine the beginning and end points on the trend line?

I have followed MS explanatory to no avail. I have created a Scatter diagram showing smoothed lines thru the data points with the highlighted data points in my spread sheet.. However, lines do not appear. Thank you id advance for your suggestion(s).

Hell o, As the Conditional format shows icons for arrows, but the Red points down and the Green points up, is there a code that can change the arrows, so that the Red points up and the Green points down? i have searched and am not able to find anything suitable Many thanks Pugg

Hey Folks, Newbie to the community here, trying to update weekly football scores that i copy and paste from a website. (covers.com) The football scores come in this format W/L (win or loss) and the score with a hyphen in the middle. "L 31-33" would be a loss as the team scored 31 points and...

Hi all, Apologies in advance for the excessive post, but hope it makes sense. I am in the process of analysing a tennis match. I would like to look at how many times a player wins just 1 point at a time, 2 points in a row, 3 in a row 4 in a row and 5+ points in a row. From my raw data is have...

Good afternoon, Here is a sample spreadsheet for which my questions will be related: A B C D E F G H I J K <tbody> Hand No. John Susan Nick Jane Nancy Sarah Mary Robert Math Check...

Hi all I am trying to build something to use for my local darts and dominoes league and are unsure which one is best for what I need and am looking for help. I have downloaded some football spreadsheets from internet where you enter the score and it updates the league but our league is based...

Hi I am looking for some help, been fiddling with excel most of last night but not any closer to solving this little problem. Lets say I have some test results, based on the % achieved you get some points (which will be used later in combination with other test results). Any score under 60%...

All rows have a height of 15 points There are 72 points per inch Row 303 will have a position in points of (303*15) 4545 Row 303 will have a position in inches of (4545/72) of 63.125 One of my machines produces this result. On another machine the position in inches is 62.62 (using top in crop...

Hi Excel newbie here and would appreciate any help someone could give. I am trying to take points away (max 100) for exceeding a target value Lets take the example a service loading The team have a target of 350 (milliseconds) anything under that time gets you 100 points automatically...

Hello there, I am hoping this place can help me with what I am trying to do. I have the top 3 finishes since 2004 for our fantasy football league. I want to create a basic function where 1st place gets 3 points, 2nd place gets 2 points and 3rd place gets 1 point. I want to see the total...

I'm using an IF statement to assign a value to performance, ultimately to gather a Rank in points. I'm using multiple criteria (about 6) and each has a point assigned based on their performance in that metric. Issue: Some values in catagories are coming up blank. This is causing my formula...

I am creating a scatter plot in excel with over 180 points. With that many points I am not able to use data labels to show which point is for what item. Is there a way that I can change the y variable within the data point to point to the item of the y axis? Thank you

Hi I want to make a point-based level system I'll have the data in a table displayed like this: 10 points 30 points 60 points and so on... but in the scoreboard will be displayed like this: level 1: 10/10 points level 2: 20/20 points (10 points from level 1 + 20 points of level 2) level 3...

i inserted 2 arrows into my worksheet, i want to reference the name... i cant seem to find the name, i figure in the properties dialog box it would exist but that would make too much sense. i used this code i found but the msgbox is empty <code> CallingShapeName =...

Good Day, I have a data list which show the results from column A to column AD all the way down. Column B is the customer ID numbers. Column C is the customer Name. Column D is the customer Surname. Column G is the customer Nationality. Column I is the customer points which from negative to...

I am a beginner in Excel who was plunged reluctantly into a doctoral degree post retirement age. I work in occupational health & safety. I have the need to convert data recorded by dataloggers in three instruments, from one sample per minute to one sample per one second or one sample per 2...

Hi. I have a line graph which is reasonably linear. However, at some points on the graph, there are significant changes. I would like a user to be able to hover over those points and see an explanatory note. Let's say the graph was sales and point A was where the business had to close because of...

Hi guys, I am trying to create a spreadsheet which calculates my students' daily grades and spit out an average at the end of the week. I have certain tasks they do during the day and they're graded for those task for a total of out of 20 points per day. the formula i have right now is just an...