stats

Good morning, I'm making a spreadsheet to keep track of our leagues win/losses and stats. However, I think I'm formatting it incorrectly? The problem I'm having is if I try to filter it by home team, it won't show me the the same team when they're the visiting team. ex. I want to see all of...

Hi! I need help designing a tracker for team members to track any work outside of their normal daily tasks. I have completed formulas to work out how many hours they have spent on each task and how much of their day they have utilised on each task, but I can’t think of the best way to present...

Been working on a stats spreadsheet and cant figure out how to calculate total rush yards and yards per carry for the running game. Hopefully someone can help me out. My sheet is below: ABCDEFGHIJKLMNOPQR1Team Stats:19002Player NamePlayer NumberTouchesQ1Q2Q3Q4CarriesTotal Rush YardsYards per...

Hi, I am an offensive assistant coach and I'm looking for some help on tracking statistics for the offense. I need to capture things like the number of touches our offensive guys get, the number of yards gained per play, completions, passing yards, 3rd down conversions, 4th down conversions...

So this is really more of a stats question but I'm a bit stuck on it and this board has some sharp minds so here goes. I have a set of monthly data of say 100+ data points. the time conversion to annualize the standard deviation is square root of time or sqrt(12) in this case. However, if I...

Hi, I have a table of sport team, which shows, how many goals (with assissts) 2 players scored together (so if player 5 scored a goal and player 16 assisted on this goal they will have one common goal). There is an example of the table, players numbers are in the first column and row, common...

I want to be able to copy data from a different sheet to a specific feel in a another sheet. I have a sheet named GSO Inventory Stats and a sheet named Retag metrics. I need to put a formula in Column I, that if Column H in sheet GSO Inventory Stats matches the sheet named Retag Metrics Column...

I have a Sheet Named NEA Status and a sheet Named Inventory Stats I want that if Column D in Sheet named NEA Status Matches Column D in the sheet named Inventory Stats move the data from Column H in the sheet Named Inventory Stats to Column H in the sheet named NEA Status.

Hi Everybody, Can anyone provide some pros and cons of each of these stats packages for a general professional level but not for full on data science work. thanks, Farmerscott

Hi - is there a simple way of knowing where the Table range is looking at if the file path is long and the file path is not in the same file - when I click in I cant see and then the file path stats changing Thanks

Hi I have the code below where I am trying to copy a range A1 to G15 into another workbook but its not working please can you help. I am trying to copy from Daily stats into Daily Stats WC Template, hope you can advise? Private Sub CommandButton1_Click() Dim x As Workbook Dim y As Workbook Dim...

Please consider this code ... With wb_classcsv .Sheets.Add(After:=.Sheets(.Sheets.Count)).Name = "Stats" Set ws_stats = .Worksheets("Stats") With ws_stats .Range("A3") = "Date: " .Range("B3") = Format(usr_date...

I fear there is not going to be an answer on this, but I have a formula where it counts values between certain dates, however, as this is for a weekly stat sheet, I want the calculation NOT to update after a certain date.. ie if the stats are for week commencing 1A April, after the 8 April, I do...

Hi, could someone help me with this please, I am ok with excel but new to vba and my problem is this: I have a userform with just a few textboxes and it is the first one I am having trouble with, I would have done it ages ago in excel but anyway, the userform is on a sheet called "start" and...

Hello. I am a football Stats man, and I have been trying to run a PowerQuery using my very limited knowledge with even more limited success! For example on this page : https://www.premierleague.com/stats/...s/goals?se=210 I am looking for this information here: It is struggling to find any...

----------------------------------------------------------------------------------------------------------------------------------------------------------- Example String: "calculating cumulative stats for quarters"...

HI I have a series of 5 totals for each year, the slope function over the 5 totals returns 57.6 How do I apply the slope to a subset of the totals The total are 2106, 2008, 2147,2288. slope = 57.6 My subset is 131,158,138,132,547. I want to predict the next number ignoring the first 3...

ActiveCell.FormulaR1C1 = _ "=INDEX('Department Adherence'!R[-16]:R[1048559],MATCH(""Department Total"",'Department Adherence'!C[-1],0),3)" Is there a way to amend this formula so that it actions the formula in column "C" only if column "B" equals "Department Stats" If column "B" equals...

In the "stats" tabs, I am trying to add info to each row for each employee. In the "Document" Tab I want the info from "Stats" Tab to populate but when I copy the formula down I will skip about 33 lines in the actual sheet. For Example: "Stats" A2= "document" C2 "Stats" A3= "document" C15...

I need a bit of help writing some code. I have a spreadsheet to track stats of a teams performance however the system that is used to generate the stats does not produce a team total so everyday i have to go in and manually add the formula. I was going to just do a basic =sum formula to total...