FOOL 2036 Offseason - Page 2

Alan T · 09-11-2009, 03:56 PM

I've been playing with dat files, spreadsheets and all kinds of things for a few days.. I finally figured out how to do it... Look at Hammersmith

Alan T · 09-11-2009, 05:40 PM

It is pretty much impossible to put into words what I am feeling right now!

ekcut · 09-11-2009, 05:43 PM

I can't wait to dive into the finnished product!

Alan T · 09-11-2009, 05:46 PM

Quote:

Originally Posted by ekcut

I can't wait to dive into the finnished product!

The finished product unfortunately will probably be a few weeks. It is likely going to be a few weekends of data entry before I can even test everything.

The way I am having to do this, I pretty much only have one shot at inputting it all into the database. (Technically not just one shot, but it gets even more complex after that). So I'm going to try to get it right the first time.

I'll keep everyone up to date on the progress as I go just so you all can share in my happiness. This is something I've actually been working for some time on, and still have a long way to go!

TeachEnEspanol · 09-11-2009, 06:00 PM

I'm excited for you that you're making the progress that you want to! (does that sound like I'm being supportive without actually knowing what I'm talking about?)

TimGuru · 09-11-2009, 06:47 PM

Cripes, Teach, that was like one of those apologies I tend to be prone to where I say, "I'm sorry what I did caused you to react that way." Or else you sounded like Penny on Big Bang Theory.

Alan T · 09-11-2009, 10:34 PM

muns · 09-11-2009, 10:40 PM

ohhh wow, this is too sweet. Alan man im drooling over here!!

Young Drachma · 09-11-2009, 10:43 PM

Very cool work, Alan. Extremely awesome for keeping records across the eras!

Alan T · 09-11-2009, 10:48 PM

Alan T · 09-11-2009, 10:52 PM

That is all I have done right now. The good news is the batting stats will be all set for the other franchises when I piece them back together inside of the FOOL2 file. Hammersmith is the only franchise I have pieced back together yet though.

Along the way I've tried to write up some excel spreadsheet formulas to help speed the process up some by ripping information from webpages and other databases to spit into a csv file that I am using. I'm hoping that will make this a bit faster for the other franchises. (ie: took about 6 hours worth of work just to piece together Hammersmith's history.)

I still have to put together files for pitching and fielding stats and I have to combine it with present day FOOL stats too before I can spit it back into the game.

I also have to put together postseason info (who made playoffs/won the league/etc), as well as award and hall of fame info too.

None of it tonight or probably tomorrow either though. (I need to do some modern FOOL stuff tomorrow, write an article for the Village Idiot, get some new uniforms in to the game, a stadium change, etc too.) So probably will get to do a bit more on Sunday during the day.

Alan T · 09-11-2009, 10:53 PM

Oh, and none of you will be able to see this in the FOOL file until the entire thing is complete, so don't dig in expecting it to be there tomorrow morning. All of these screenshots is with a test db I'm working with so as to not screw up the main file.

Alan T · 09-12-2009, 06:03 AM

Sim time! Getting exports now.

Alan T · 09-12-2009, 06:09 AM

Friday, March 7th, 2036

Napa Valley Winemakers: Signed SP J. Hinkle to a 3-year contract extension worth a total of $20,685,000.

Ann Arbor Winged Lingerines: Signed SP B. Morán to a 3-year contract extension worth a total of $2,617,500.

Ann Arbor Winged Lingerines: Signed 1B K. Sharpe to a 3-year contract extension worth a total of $17,445,000.

Ann Arbor Winged Lingerines: Signed RF C. Gonzáles to a 3-year contract extension worth a total of $16,507,500.

Thursday, March 6th, 2036

Napa Valley Winemakers: Signed MR A. Durán to a 3-year contract extension worth a total of $3,502,500.

Baltimore Charm: Signed 1B C. Davis to a minor league contract extension.

Tuesday, March 4th, 2036

Baltimore Charm: Signed 3B R. Campos to a minor league contract extension.

Hartford Harpooners: Signed CL R. Polanco to a 2-year contract extension worth a total of $8,830,000.

Monday, March 3rd, 2036

Baltimore Charm: Signed free agent MR S. Galardo to a minor league contract.

Baltimore Charm: Signed free agent MR M. Mejía to a minor league contract.

Baltimore Charm: Signed free agent MR A. López to a minor league contract.

Baltimore Charm: Signed free agent MR A. Herrera to a minor league contract.

Baltimore Charm: Signed free agent SP I. Ohayashi to a 3-year contract worth a total of $1,050,000.

Baltimore Charm: Signed free agent 2B J. Soto to a 1-year contract worth a total of $5,000,000.

Tokyo Cyclones: Signed free agent CL M. Cardona to a 2-year contract worth a total of $5,955,000.

Baltimore Charm: Signed free agent MR K. Renfro to a 1-year contract worth a total of $100,000.

Baltimore Charm: Signed free agent SP J. López to a 3-year contract worth a total of $690,000.

Baltimore Charm: Signed free agent SP J. Skiffington to a minor league contract.

Chico Rebels: Signed free agent SP G. Montoya to a 2-year contract worth a total of $10,700,000.

Tokyo Cyclones: Signed free agent MR J. Brooks to a 1-year contract worth a total of $1,547,500.

New York Heroes: Signed free agent C A. Torres to a minor league contract.

Ann Arbor Winged Lingerines: Signed free agent SP N. Ewbank to a 2-year contract worth a total of $8,440,000.

Baltimore Charm: Signed free agent SS R. Shannon to a minor league contract.

Baltimore Charm: Signed free agent 2B F. Reyes to a minor league contract.

Tokyo Cyclones: Signed free agent 2B J. Bulger to a 1-year contract worth a total of $845,000.

Napa Valley Winemakers: Signed SP J. Rangel to a 3-year contract extension worth a total of $18,360,000.

Baltimore Charm: Signed free agent RF M. Kerfoot to a minor league contract.

Baltimore Charm: Signed free agent 1B D. Smith to a minor league contract.

Baltimore Charm: Signed free agent MR R. Baker to a minor league contract.

Baltimore Charm: Signed free agent C Q. Dunderdale to a minor league contract.

Baltimore Charm: Signed free agent RF I. Ruíz to a 1-year contract worth a total of $3,500,000.

Chico Rebels: Signed free agent C A. Coutreras to a 1-year contract worth a total of $950,000.

Hartford Harpooners: Signed free agent C S. Kelley to a 2-year contract worth a total of $6,095,000.

Alan T · 09-12-2009, 06:10 AM

I hadn't noticed Soto was even in free agency.

I am guessing he hit the end of his contract and did the typical middle infielder "hold the team ransom" type of demand for a contract.

Alan T · 09-12-2009, 06:12 AM

Spring Training:

CL:

Boston 17-7
Baltimore 16-8
Napa Valley 12-12
Edmonton 11-13
Apex 9-15
Tokyo 7-17

RL:

Chico 16-8
Colorado 15-9
New York 13-11
Hammersmith 10-14
Ann Arbor 10-14
Hartford 8-16

Alan T · 09-12-2009, 06:25 AM

The new file is up!

I hope everyone has a good weekend.

The 2036 season runs Monday night!

buckinbranco · 09-12-2009, 08:38 AM

Quote:

Originally Posted by Alan T

I hadn't noticed Soto was even in free agency.

I am guessing he hit the end of his contract and did the typical middle infielder "hold the team ransom" type of demand for a contract.

Yea he was asking for like a 3-4 year deal which I didn't want to give him, and I got a replacement for him in the deal I did with muns. I would have liked to keep him for his glove, but o well.

buckinbranco · 09-12-2009, 09:17 AM

Here is the final version of the new Chico jersey, just a couple of minor changes. And here's the cap. Thanks for taking the time to put these in the game Alan!

TeachEnEspanol · 09-12-2009, 09:43 AM

Quote:

Originally Posted by buckinbranco

Here is the final version of the new Chico jersey, just a couple of minor changes. And here's the cap. Thanks for taking the time to put these in the game Alan!

Ooh, I like that. Nice job as always, Buck.

ekcut · 09-12-2009, 11:07 AM

Quote:

Originally Posted by buckinbranco

Here is the final version of the new Chico jersey, just a couple of minor changes. And here's the cap. Thanks for taking the time to put these in the game Alan!

Wicked job! Looks great!

Montreal_GM · 09-12-2009, 07:43 PM

Quote:

Originally Posted by buckinbranco

Here is the final version of the new Chico jersey, just a couple of minor changes. And here's the cap. Thanks for taking the time to put these in the game Alan!

Looks good buck. I messed with some two-tone designs for my new Tokyo jersey but I couldn't seem to make it work right. You did well.

buckinbranco · 09-12-2009, 07:49 PM

Quote:

Originally Posted by Montreal_GM

Looks good buck. I messed with some two-tone designs for my new Tokyo jersey but I couldn't seem to make it work right. You did well.

Thanks, I'm glad everyone seems to like the new jersey. I was going for a little more modern look since we are so far in the future now. Hopefully the design will age well!

buckinbranco · 09-12-2009, 07:53 PM

Here is the new logo for the franchise page and all that. Thanks again for taking the time to make my team look good, no rush on getting the logo into the game

Alan T · 09-12-2009, 09:45 PM

Just a quick reminder on the schedule for this week. I'll make sure to bring it up daily so no one forgets.

We are simming all evening sims this week, and have an extra sim.

Monday night - 2036 Regular Season
Tuesday night - 2036 Playoffs
Wednesday night - Arbitration
Thursday night - Expansion protection lists due / Live expansion draft at 9pm ET
Friday night - Free Agency Day 1 / Amateur Draft
Saturday night - Free Agency Day 2 / Spring Training

Let me know if there are any questions. I'll go over the expansion lists in detail once again later in the week.

Alan T · 09-13-2009, 02:23 PM

I've made pretty decent progress this weekend. I wrote an excel script to rip a ton of the data that I needed from historical report pages and auto-format it in the way I need to insert it back into the database.

Still quite a way to go:

On the bad side, I think I've crashed my test db about 20 times because of the incestuous natures of the old Chico/Ann Arbor franchises. Both franchises had at least one version of an Ann Arbor team and both had a version of a Compton team as well. In the database each franchise and team ID has to be unique. (a team ID can't match a franchise ID either)...

So I am having to be a bit careful on how I insert all of this or it crashes when I import it in

Montreal_GM · 09-13-2009, 04:59 PM

Sorry to hear about the issues you're having. Thanks again for doing all of this, I think it will be very impressive once you're finished.

Alan T · 09-14-2009, 05:57 PM

Making progress!

Montreal_GM · 09-14-2009, 06:17 PM

Hadn't realized my organization changed locations/monikers so many times.

09-11-2009, 05:40 PM	#52
Alan T Hall Of Famer Join Date: Dec 2002 Location: Mass.	It is pretty much impossible to put into words what I am feeling right now! __________________ Couch to ??k - From the couch to a Marathon in roughly 18 months.

09-11-2009, 05:43 PM	#53
ekcut College Benchwarmer Join Date: Jun 2008 Location: Edmonton, Alberta	I can't wait to dive into the finnished product! __________________ FOOLX- Alberta Renegades FOOL- Leduc Bullets

09-11-2009, 06:47 PM	#56
TimGuru High School Varsity Join Date: Sep 2008 Location: Cape Cod, MA	Cripes, Teach, that was like one of those apologies I tend to be prone to where I say, "I'm sorry what I did caused you to react that way." Or else you sounded like Penny on Big Bang Theory. __________________ FOOL: NY Panthers1974-88 ; Hyannis Patriots 2037-2055 hiatus FOOL-H: NY YANKEES 1903- FOOL-X: Cumberland Defenders 1985-

09-11-2009, 10:34 PM	#57
Alan T Hall Of Famer Join Date: Dec 2002 Location: Mass.	__________________ Couch to ??k - From the couch to a Marathon in roughly 18 months.

09-11-2009, 10:43 PM	#59
Young Drachma Dark Cloud Join Date: Apr 2001	Very cool work, Alan. Extremely awesome for keeping records across the eras! __________________ Current Dynasty:The Zenith of Professional Basketball Careers (FBPB/FBCB) FBCB / FPB3 Mods

09-11-2009, 06:00 PM	#55
TeachEnEspanol College Starter Join Date: Aug 2008	I'm excited for you that you're making the progress that you want to! (does that sound like I'm being supportive without actually knowing what I'm talking about?)

09-11-2009, 10:40 PM	#58
muns Pro Starter Join Date: Apr 2002 Location: Baltimore MD	ohhh wow, this is too sweet. Alan man im drooling over here!!

09-11-2009, 10:48 PM	#60
Alan T Hall Of Famer Join Date: Dec 2002 Location: Mass.	__________________ Couch to ??k - From the couch to a Marathon in roughly 18 months.

09-11-2009, 10:52 PM	#61
Alan T Hall Of Famer Join Date: Dec 2002 Location: Mass.	That is all I have done right now. The good news is the batting stats will be all set for the other franchises when I piece them back together inside of the FOOL2 file. Hammersmith is the only franchise I have pieced back together yet though. Along the way I've tried to write up some excel spreadsheet formulas to help speed the process up some by ripping information from webpages and other databases to spit into a csv file that I am using. I'm hoping that will make this a bit faster for the other franchises. (ie: took about 6 hours worth of work just to piece together Hammersmith's history.) I still have to put together files for pitching and fielding stats and I have to combine it with present day FOOL stats too before I can spit it back into the game. I also have to put together postseason info (who made playoffs/won the league/etc), as well as award and hall of fame info too. None of it tonight or probably tomorrow either though. (I need to do some modern FOOL stuff tomorrow, write an article for the Village Idiot, get some new uniforms in to the game, a stadium change, etc too.) So probably will get to do a bit more on Sunday during the day. __________________ Couch to ??k - From the couch to a Marathon in roughly 18 months.

09-11-2009, 10:53 PM	#62
Alan T Hall Of Famer Join Date: Dec 2002 Location: Mass.	Oh, and none of you will be able to see this in the FOOL file until the entire thing is complete, so don't dig in expecting it to be there tomorrow morning. All of these screenshots is with a test db I'm working with so as to not screw up the main file. __________________ Couch to ??k - From the couch to a Marathon in roughly 18 months.

09-12-2009, 06:03 AM	#63
Alan T Hall Of Famer Join Date: Dec 2002 Location: Mass.	Sim time! Getting exports now. __________________ Couch to ??k - From the couch to a Marathon in roughly 18 months.

09-12-2009, 06:10 AM	#65
Alan T Hall Of Famer Join Date: Dec 2002 Location: Mass.	I hadn't noticed Soto was even in free agency. I am guessing he hit the end of his contract and did the typical middle infielder "hold the team ransom" type of demand for a contract. __________________ Couch to ??k - From the couch to a Marathon in roughly 18 months. Last edited by Alan T : 09-12-2009 at 06:11 AM.

09-12-2009, 06:12 AM	#66
Alan T Hall Of Famer Join Date: Dec 2002 Location: Mass.	Spring Training: CL: Boston 17-7 Baltimore 16-8 Napa Valley 12-12 Edmonton 11-13 Apex 9-15 Tokyo 7-17 RL: Chico 16-8 Colorado 15-9 New York 13-11 Hammersmith 10-14 Ann Arbor 10-14 Hartford 8-16 __________________ Couch to ??k - From the couch to a Marathon in roughly 18 months.

09-12-2009, 06:25 AM	#67
Alan T Hall Of Famer Join Date: Dec 2002 Location: Mass.	The new file is up! I hope everyone has a good weekend. The 2036 season runs Monday night! __________________ Couch to ??k - From the couch to a Marathon in roughly 18 months.

09-12-2009, 09:17 AM	#69
buckinbranco High School Varsity Join Date: Jan 2009 Location: Chico, CA	Here is the final version of the new Chico jersey, just a couple of minor changes. And here's the cap. Thanks for taking the time to put these in the game Alan! __________________ FOOL Graphics They Might Be Giants Blog

09-12-2009, 07:53 PM	#74
buckinbranco High School Varsity Join Date: Jan 2009 Location: Chico, CA	Here is the new logo for the franchise page and all that. Thanks again for taking the time to make my team look good, no rush on getting the logo into the game __________________ FOOL Graphics They Might Be Giants Blog

09-12-2009, 09:45 PM	#75
Alan T Hall Of Famer Join Date: Dec 2002 Location: Mass.	Just a quick reminder on the schedule for this week. I'll make sure to bring it up daily so no one forgets. We are simming all evening sims this week, and have an extra sim. Monday night - 2036 Regular Season Tuesday night - 2036 Playoffs Wednesday night - Arbitration Thursday night - Expansion protection lists due / Live expansion draft at 9pm ET Friday night - Free Agency Day 1 / Amateur Draft Saturday night - Free Agency Day 2 / Spring Training Let me know if there are any questions. I'll go over the expansion lists in detail once again later in the week. __________________ Couch to ??k - From the couch to a Marathon in roughly 18 months.

09-13-2009, 02:23 PM	#76
Alan T Hall Of Famer Join Date: Dec 2002 Location: Mass.	I've made pretty decent progress this weekend. I wrote an excel script to rip a ton of the data that I needed from historical report pages and auto-format it in the way I need to insert it back into the database. Still quite a way to go: On the bad side, I think I've crashed my test db about 20 times because of the incestuous natures of the old Chico/Ann Arbor franchises. Both franchises had at least one version of an Ann Arbor team and both had a version of a Compton team as well. In the database each franchise and team ID has to be unique. (a team ID can't match a franchise ID either)... So I am having to be a bit careful on how I insert all of this or it crashes when I import it in __________________ Couch to ??k - From the couch to a Marathon in roughly 18 months.

09-13-2009, 04:59 PM	#77
Montreal_GM College Benchwarmer Join Date: Jan 2009	Sorry to hear about the issues you're having. Thanks again for doing all of this, I think it will be very impressive once you're finished. __________________ Kevin

09-14-2009, 05:57 PM	#78
Alan T Hall Of Famer Join Date: Dec 2002 Location: Mass.	Making progress! __________________ Couch to ??k - From the couch to a Marathon in roughly 18 months.

09-14-2009, 06:17 PM	#79
Montreal_GM College Benchwarmer Join Date: Jan 2009	Hadn't realized my organization changed locations/monikers so many times. __________________ Kevin

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