Social Wrighty presents Forum Sheep game for 2024 - Round Ten Underway

Status
Not open for further replies.
NZWarriors.com
NZWarriors.com
Advertisement
If you would like to remove these advertisements, please do so by registering a free account
ROUND 4 OPEN AUCTION BID LOG 2:47PM
SB Williams $100k Wizards
Sonny bill williams $200,000 Defence
Sonny Bill Williams $1,950,000 Naumai
SBW $2,000,000 Wizards
Darren Lockyer $100,000 Mr B
Sonny Bill Williams $2,275,000 Naumai
Petero Civoniceva $899,000 Cces
L Tuqiri $100k Wizards
W Sailor $230k Wizards
D Buderus $420k Wizards
L Lewis $100k Wizards
B Anasta $300k Wizards
R Asotasi $700k Wizards
 
ROUND 4 OPEN AUCTION BID LOG 2:47PM
SB Williams $100k Wizards
Sonny bill williams $200,000 Defence
Sonny Bill Williams $1,950,000 Naumai
SBW $2,000,000 Wizards
Darren Lockyer $100,000 Mr B
Sonny Bill Williams $2,275,000 Naumai
Petero Civoniceva $899,000 Cces
L Tuqiri $100k Wizards
W Sailor $230k Wizards
D Buderus $420k Wizards
L Lewis $100k Wizards
B Anasta $300k Wizards
R Asotasi $700k Wizards
How this Bid LOG tyrael tyrael ? I was thinking of bolding the highest bid - but then realised the lowest on the list entry for a player will always be the highest.
 
NZWarriors.com
Advertisement
If you would like to remove these advertisements, please do so by registering a free account
ROUND 4 OPEN AUCTION BID LOG 2:47PM
SB Williams $100k Wizards
Sonny bill williams $200,000 Defence
Sonny Bill Williams $1,950,000 Naumai
SBW $2,000,000 Wizards
Darren Lockyer $100,000 Mr B
Sonny Bill Williams $2,275,000 Naumai
Petero Civoniceva $899,000 Cces
L Tuqiri $100k Wizards
W Sailor $230k Wizards
D Buderus $420k Wizards
L Lewis $100k Wizards
B Anasta $300k Wizards
R Asotasi $700k Wizards
1,700,000 Lockyer
 
NZWarriors.com
Advertisement
If you would like to remove these advertisements, please do so by registering a free account
NZWarriors.com
Advertisement
If you would like to remove these advertisements, please do so by registering a free account
SBW2.2m
JWH700k

If you put it into sheets first and then copy and paste (like you did with day 1 stuff) then it is way clearer.
I will give it some thought - one of the issues I have is how to parse the data into seperate columns since ocassionally people drop off the dollar sign before their bid. For Now I will stick with Notepad as it also cleans the fonts if people bold their bid.
 
NZWarriors.com
Advertisement
If you would like to remove these advertisements, please do so by registering a free account
Does this Spreadsheet version look better?


ROUND 4 OPEN AUCTION BID LOG 2:47PM
SB Williams $100k Wizards
Sonny bill williams $200,000 Defence
Sonny Bill Williams $1,950,000 Naumai
SBW $2,000,000 Wizards
Darren Lockyer $100,000 Mr B
Sonny Bill Williams $2,275,000 Naumai
Petero Civoniceva $899,000 Cces
L Tuqiri $100k Wizards
W Sailor $230k Wizards
D Buderus $420k Wizards
L Lewis $100k Wizards
B Anasta $300k Wizards
R Asotasi $700k Wizards
Darren Lckyer 1,700,000 Wizards
SBW $2,276,000 Wizards
Petro Civinocevia $900,000 Wizards
 
I will give it some thought - one of the issues I have is how to parse the data into seperate columns since ocassionally people drop off the dollar sign before their bid. For Now I will stick with Notepad as it also cleans the fonts if people bold their bid.
You can clear all formatting before you paste on here. The $ sign is annoying though.
 
NZWarriors.com
Advertisement
If you would like to remove these advertisements, please do so by registering a free account
ROUND 4 OPEN AUCTION BID LOG 2:47PM
SB Williams100k WizardsRound 4Dec 29 2025
Sonny bill williams200,000 DefenceRound 4Dec 29 2025
Sonny Bill Williams1,950,000 NaumaiRound 4Dec 29 2025
SBW2,000,000 WizardsRound 4Dec 29 2025
Darren Lockyer100,000 Mr BRound 4Dec 29 2025
Sonny Bill Williams2,275,000 NaumaiRound 4Dec 29 2025
Petero Civoniceva899,000 CcesRound 4Dec 29 2025
L Tuqiri100k WizardsRound 4Dec 29 2025
W Sailor230k WizardsRound 4Dec 29 2025
D Buderus420k WizardsRound 4Dec 29 2025
L Lewis100k WizardsRound 4Dec 29 2025
B Anasta300k WizardsRound 4Dec 29 2025
R Asotasi700k WizardsRound 4Dec 29 2025
Darren Lckyer1,700,000 WizardsRound 4Dec 29 2025
SBW2,276,000 WizardsRound 4Dec 29 2025
Petro Civinocevia900,000 WizardsRound 4Dec 29 2025



That would the best that can do by parsing on the dollar sign and using "text to columns" command in Excel. I won't be able to split out the contestant name e.g. 900,000 Wizards will be in one cell rather than Wizards having his own cell.
 
Last edited:
Status
Not open for further replies.
Back
Top