To see less ads Register or Login ----- Daily Fantasy Sports games 18+

Spreadsheet Help - Please

A forum to discuss or share knowledge of spreadsheets.
Post Reply
wackojackouk
Kevin and Perry
Posts: 31
Joined: 13 Oct 2005, 18:33

Spreadsheet Help - Please

Post by wackojackouk »

Hi chaps

I run a Fantasy League for some friends at work and friends of friends etc.

There are 57 teams in my league this year and I am having a problem with one of the macro's in the spreadsheet I use (it was written by an old friend of a friend a few years back).

Basically there is a Top Scorers tab where I normally just copy and paste the list of players and scores etc into. I then click on a button called Sort Top Scorers which basically sorts the Top 20 for me.

Now I've added in a few new players since the last update it is missing off or not calculating the last few (ID's 993-999 which appear after Row 397 in the worksheet) correctly.

I've had a quick look at Macro and cannot see any reference to a number of rows or anything so am stumped and need an experts help...

Here's the Macro btw... (It could be something simple) or alternatively if someone wants to take a look I can email the spreadsheet over.

Here's the Macro...

'----------------------------------------------------------------------------------
' SortScorers Macro
' Sort Top Scorers Table
' Macro recorded 23aug96 at 08:43 by Mark Fulgoni
'----------------------------------------------------------------------------------
Sub SortScorers()
' select top scorers sheet
Sheets("Top Scorers").Select
' clear top 10 filter and select the whole table
Selection.AutoFilter Field:=1
Application.Goto Reference:="scorers"
' clear background and font settings
Call ClearAttributes(False)
' sort top scorers table by points, value, times selected
Selection.Sort _
Key1:=Range("H2"), Order1:=xlDescending, _
Key2:=Range("F2"), Order2:=xlAscending, _
Key3:=Range("G2"), Order3:=xlAscending, _
Header:=xlGuess, _
OrderCustom:=1, _
MatchCase:=False
' set headings black background, white text
Range("B1:H1").Select
Call MakeHeading
' set gray background for every second row
Call GrayBackground(2, 399, 2, "B", "H")
' re-apply top xx filter
Application.Goto Reference:="scorers"
Selection.AutoFilter _
Field:=1, _
Criteria1:="20", _
Operator:=xlTop10Items
' de-select table range
Call ReturnToTop
End Sub

Sub FormatPlayers()
Sheets("Players").Select
Call GrayBackground(2, 399, 2, "A", "I")
Call ReturnToTop
End Sub


Thanks in advance

WJUK

User avatar
Surprised
FISO Jedi Knight
Posts: 26528
Joined: 13 Oct 2005, 18:32
Location: Home
FS Record: TFFOSM MotW in 2008 and MotM in 2003. 78th overall in TFFO for 2002/3 and 2003/4

Re: Spreadsheet Help - Please

Post by Surprised »

Application.Goto Reference:="scorers"

This looks like there is a Named range in the sheet called "scorers" so you may need to extend that first.
Just a guess though.

User avatar
Mystery
FISO Knight
Posts: 13816
Joined: 13 Oct 2005, 18:33
Location: Just about here
FS Record: 116th in TFF 05/06
Contact:

Re: Spreadsheet Help - Please

Post by Mystery »

I don't think the Application lines are necessary at all. Unless you've got gaps in your list AutoFilter should guess the range perfectly fine without you pointing at it, as long as you select a cell in the range.

clarisha
Newbie
Posts: 1
Joined: 02 Oct 2012, 10:09

Re: Spreadsheet Help - Please

Post by clarisha »

What spreadsheet formula do I use to multiply two numbers and add another? I have created a spreadsheet and I can't figure out what formula to use. I need to multiply the cost of a cd by the number of cds and then I have to add the shipping charge. So it will be C3 * D3 + E3. What formula do I use? Thanks!

User avatar
Vid
Head Moderator
Posts: 21728
Joined: 13 Oct 2005, 18:33
FS Record: winning is a distant memory

Re: Spreadsheet Help - Please

Post by Vid »

clarisha wrote:What spreadsheet formula do I use to multiply two numbers and add another? I have created a spreadsheet and I can't figure out what formula to use. I need to multiply the cost of a cd by the number of cds and then I have to add the shipping charge. So it will be C3 * D3 + E3. What formula do I use? Thanks!
=(C3 * D3) + E3

User avatar
Knulpuk
Dumbledore
Posts: 8986
Joined: 05 Dec 2005, 13:22
Location: MTA (Mid Table Anonymity)
FS Record: Ultra ultra consistent (see above)

Re: Spreadsheet Help - Please

Post by Knulpuk »

Vid wrote:
clarisha wrote:What spreadsheet formula do I use to multiply two numbers and add another? I have created a spreadsheet and I can't figure out what formula to use. I need to multiply the cost of a cd by the number of cds and then I have to add the shipping charge. So it will be C3 * D3 + E3. What formula do I use? Thanks!
=(C3 * D3) + E3
:D

User avatar
murf
FISO Viscount
Posts: 109450
Joined: 13 Oct 2005, 18:28
Location: here
FS Record: Once led TFF. Very briefly.
Contact:

Re: Spreadsheet Help - Please

Post by murf »

=(C3*D3)+E3

No spaces :wink: :twisted:

User avatar
Vid
Head Moderator
Posts: 21728
Joined: 13 Oct 2005, 18:33
FS Record: winning is a distant memory

Re: Spreadsheet Help - Please

Post by Vid »

murf wrote:=(C3*D3)+E3

No spaces :wink: :twisted:
true, I just copied and pasted from the Q and added the = ( ) :)

User avatar
Knulpuk
Dumbledore
Posts: 8986
Joined: 05 Dec 2005, 13:22
Location: MTA (Mid Table Anonymity)
FS Record: Ultra ultra consistent (see above)

Re: Spreadsheet Help - Please

Post by Knulpuk »

C3 * D3 + E3

you don't even need the brackets, wait a minute is this one of these internet wind up things I have heard about :)

View Latest: 1 Day View Your posts
Post Reply

Return to “Spreadsheets”