GRRRRR, stoopid commas!!!

FrogMan · 01-08-2004, 10:31 PM

they added commas to the player values and now my Hattrick spreadsheets won't parse the player listing right!!! GRRRRR!!!

if it ain't broke, don't fix it, they say... The match reports are nice now, the commas were not necessary, at least I was never raised to use them here in Quebec... oh well...

FM

finkenst · 01-08-2004, 10:34 PM

i just don't see his myself:
Jeffrey Wheatley
171 000 US$, 26 years, passable form
Has weak experience and passable leadership abilities [Quick]

....

uynless it's the commas in the $, 26 yo, passable...

FrogMan · 01-08-2004, 10:38 PM

Tim, I read your comment in the USA conference, replying to Brandon. Brandon is in Canada too, I guess this is only in Canada... Look at Nick's value below...

Your 25 players

Nick de Hooge
1,174,000 C$, 23 years, passable form
Has inadequate experience and weak leadership abilities

Stamina: excellent Keeper: excellent
Playmaking: disastrous Passing: wretched
Winger: disastrous Defending: disastrous
Scoring: disastrous Set Pieces: wretched

My parser was looking for the first comma as the delimiter for the value, now I'm gonna make it look for the "C$" and then have to substitute all the "," for "" in order to be able to make a value out of it, a tiny pain, but unneeded...

FM

finkenst · 01-08-2004, 10:42 PM

hehehehehehehe...

i just posted the same thing to brandon.

Poli · 01-08-2004, 10:51 PM

Sucks to be Canada.

Qwikshot · 01-08-2004, 11:06 PM

I had commas and I'm in the U.S.

terpkristin · 01-08-2004, 11:26 PM

I don't know much about Excel...but my values and stuff worked fine in your killer spreadsheet. Is this possibly related to some of the issues that US people had when you first posted your spreadsheet? I seem to remember there was some problem with the spreadsheet not working for us US players...but I definitely don't remember what the problem was...

~tk

Mr. Wednesday · 01-09-2004, 12:25 AM

The original problem with FM's spreadsheet (at least, the one I encountered) was with the VALUE function in older versions of Excel.

vex · 01-09-2004, 12:28 AM

I have comas too.

Alf · 01-09-2004, 04:11 AM

I don't have commas and using "English" language in my French League.

FrogMan · 01-09-2004, 07:10 AM

Commas have disappeared from my players page this morning, weird...

tk, as Mr. Wednesday said, the problem was with some version of Excel not being able to compute the "value" function with spaces in the middle of a number shown as text...

oh well, for now everything works as before, we'll see if the disappearing commas resurface again...

FM

Alf · 01-09-2004, 07:46 AM

GRRRRR, stoopid commas!!! - There are commas now in the players page and on the economical page too.... transfert history as well....

finkenst · 01-09-2004, 09:14 AM

ARgh!

stoopid commas!!!!

they must be spreading from canada.

wait a minute, wtf?!!?

now there are no commas...

Fonzie · 01-09-2004, 09:23 AM

Quote:

Originally posted by vexroid
I have comas too.

You might want to see a doctor about that.

FrogMan · 01-09-2004, 09:40 AM

Quote:

Originally posted by finkenst
ARgh!

stoopid commas!!!!

they must be spreading from canada.

wait a minute, wtf?!!?

now there are no commas...

yeah, we sent you our commas. Being that they are stoopid, they thought that being closer to Celine Dion was a good thing, MUAHAHAHAHAHAH!!!!!

FM

Alf · 01-09-2004, 09:53 AM

Bienvenue

Desnudo · 01-09-2004, 10:06 AM

aaaaawww.

Poli · 01-09-2004, 10:12 AM

All things evil come from Canada.

MacroGuru · 01-09-2004, 11:11 AM

Wait, I thought that was North Dakota?

Desnudo · 01-09-2004, 11:55 AM

Isn't that a Canadian province?

Hobbes- · 01-09-2004, 01:59 PM

Quote:

Originally posted by indoorsoccersim
Wait, I thought that was North Dakota?

nope.. canada gave us mad cow.. and tried to hide it for 2 years..

Hobbes- · 01-09-2004, 02:01 PM

They prolly gave us the Evil SouthPark Cows too.. fckin worthless cows..

PUT EM ALL DOWN! KILL KILL!!

finkenst · 01-09-2004, 05:00 PM

back on topic of this thread...

I am starting to suspect it might depend on which server you get... e.g. .158 and no commas. now on .154 and i have commas again.

FrogMan · 01-09-2004, 05:05 PM

ouch, this is gonna be a major pain then...

FM

finkenst · 01-09-2004, 05:07 PM

yeah

195.149.159.155:
Vicent Ribelles
97 000 US$, 30 years, passable form
Has poor experience and weak leadership abilities

195.149.159.154:
Vicent Ribelles
97,000 US$, 30 years, passable form
Has poor experience and weak leadership abilities

01-08-2004, 10:38 PM	#3
FrogMan Hattrick Moderator Join Date: Jan 2003 Location: Pintendre, Qc, Canada	Tim, I read your comment in the USA conference, replying to Brandon. Brandon is in Canada too, I guess this is only in Canada... Look at Nick's value below... Your 25 players Nick de Hooge 1,174,000 C$, 23 years, passable form Has inadequate experience and weak leadership abilities Stamina: excellent Keeper: excellent Playmaking: disastrous Passing: wretched Winger: disastrous Defending: disastrous Scoring: disastrous Set Pieces: wretched My parser was looking for the first comma as the delimiter for the value, now I'm gonna make it look for the "C$" and then have to substitute all the "," for "" in order to be able to make a value out of it, a tiny pain, but unneeded... FM __________________ A Black Belt is a White Belt who refused to give up... follow my story: The real life story of a running frog...

01-08-2004, 10:51 PM	#5
Poli FOFC Survivor Join Date: Apr 2002 Location: Wentzville, MO	Sucks to be Canada. __________________ Cheer for a walk on quarterback! Ardent leads the Vols in the dynasty forum.

01-08-2004, 11:06 PM	#6
Qwikshot Pro Starter Join Date: Feb 2002 Location: ...down the gravity well	I had commas and I'm in the U.S. __________________ "General Woundwort's body was never found. It could be that he still lives his fierce life somewhere else, but from that day on, mother rabbits would tell their kittens that if they did not do as they were told, the General would get them. Such was Woundwort's monument, and perhaps it would not have displeased him." Watership Down, Richard Adams

01-08-2004, 11:26 PM	#7
terpkristin Grizzled Veteran Join Date: May 2003 Location: Ashburn, VA	I don't know much about Excel...but my values and stuff worked fine in your killer spreadsheet. Is this possibly related to some of the issues that US people had when you first posted your spreadsheet? I seem to remember there was some problem with the spreadsheet not working for us US players...but I definitely don't remember what the problem was... ~tk __________________ GO TERPS! https://www.flickr.com/photos/terpkristin https://twitter.com/terpkristin

01-09-2004, 12:25 AM	#8
Mr. Wednesday Pro Starter Join Date: Jul 2003 Location: South Bend, IN	The original problem with FM's spreadsheet (at least, the one I encountered) was with the VALUE function in older versions of Excel. __________________ Hattrick - Brays Bayou FC (70854) / USA III.4 Hockey Arena - Houston Aeros / USA II.1 Thanks to my FOFC Hattrick supporters - Blackout, Brillig, kingfc22, RPI-fan, Rich1033, antbacker, One_to7, ur_land, KevinNU7, and TonyR (PM me if you support me and I've missed you)

01-09-2004, 12:28 AM	#9
vex Grizzled Veteran Join Date: Jul 2001 Location: Tulsa	I have comas too.

01-09-2004, 04:11 AM	#10
Alf Pro Starter Join Date: Jan 2001 Location: Rennes, France	I don't have commas and using "English" language in my French League. __________________ FOFL - GML - IHOF - FranceStats

01-09-2004, 07:10 AM	#11
FrogMan Hattrick Moderator Join Date: Jan 2003 Location: Pintendre, Qc, Canada	Commas have disappeared from my players page this morning, weird... tk, as Mr. Wednesday said, the problem was with some version of Excel not being able to compute the "value" function with spaces in the middle of a number shown as text... oh well, for now everything works as before, we'll see if the disappearing commas resurface again... FM __________________ A Black Belt is a White Belt who refused to give up... follow my story: The real life story of a running frog...

01-09-2004, 07:46 AM	#12
Alf Pro Starter Join Date: Jan 2001 Location: Rennes, France	GRRRRR, stoopid commas!!! - There are commas now in the players page and on the economical page too.... transfert history as well.... __________________ FOFL - GML - IHOF - FranceStats

01-09-2004, 09:53 AM	#16
Alf Pro Starter Join Date: Jan 2001 Location: Rennes, France	Bienvenue __________________ FOFL - GML - IHOF - FranceStats

01-09-2004, 10:06 AM	#17
Desnudo Coordinator Join Date: Jul 2003 Location: Here and There	aaaaawww.

01-09-2004, 10:12 AM	#18
Poli FOFC Survivor Join Date: Apr 2002 Location: Wentzville, MO	All things evil come from Canada. __________________ Cheer for a walk on quarterback! Ardent leads the Vols in the dynasty forum.

01-09-2004, 11:11 AM	#19
MacroGuru Coordinator Join Date: May 2003 Location: Utah	Wait, I thought that was North Dakota? __________________ "forgetting what is in the past, I strive for the future"

01-09-2004, 11:55 AM	#20
Desnudo Coordinator Join Date: Jul 2003 Location: Here and There	Isn't that a Canadian province?

01-09-2004, 02:01 PM	#22
Hobbes- High School Varsity Join Date: Aug 2003 Location: Philly	They prolly gave us the Evil SouthPark Cows too.. fckin worthless cows.. PUT EM ALL DOWN! KILL KILL!! __________________ Owner of Fockers (71987) Death to 8 Ball!

01-09-2004, 05:05 PM	#24
FrogMan Hattrick Moderator Join Date: Jan 2003 Location: Pintendre, Qc, Canada	ouch, this is gonna be a major pain then... FM __________________ A Black Belt is a White Belt who refused to give up... follow my story: The real life story of a running frog...

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)