User Pass
Home Sign Up Contact Log In
tpaterniti
Lead Mod
offline
Link
 
I am trying to consolidate some posts to reduce the number of stickies.

Tactics and XP Spreadsheets: http://goallineblitz.com/game/forum_thread.pl?thread_id=305746

Originally posted by krwynn
Tired of trying to remember what tactics you used a few games back? What worked? What didn't work? Who did you play and what tactics did you use against them?

My contribution to GLB:

Tactics Log. An Excel Spreadsheet that keeps track of all 16 regular season games and 4 playoff games. Easy to use and all will print on a regular sheet of paper. Drop down menu choices. Fool proof entrys with error checking. There are no macros or background operations. Completely safe.

Enter your seasons schedule and a few other items on the setup page and you're ready to go. Easy to follow and flows perfectly through the tactics settings.

Download here:
http://www.columbuscrush.s5.com/tactics.html

Note: You have to download from the link above in this post: IT WILL NOT ALLOW A DIRECT LINK FROM ANYWHERE ELSE.

Enjoy. And you're welcome.

The sheet will not let you go over 100% on item critical entrys. It will not let you enter numbers less than 0 or more than 100 for % settings.

On Setup: Enter Home or Away in the drop downs for each game and it will place you in the correct position on the game tactic sheet. Enter points for each game and they will change color for a quick reference on a win or loss. (Green=win, red=loss, blue=tie)

Lots of bells and whistles.

Screenshots(click picture twice to expand for a clear view)

Pie Charts: http://i118.photobucket.com/albums/o111/krwynn/pie.gif
Errors: http://i118.photobucket.com/albums/o111/krwynn/error.gif
Setup: http://i118.photobucket.com/albums/o111/krwynn/setup.gif
Partial1: http://i118.photobucket.com/albums/o111/krwynn/tactics.gif
Partial2: http://i118.photobucket.com/albums/o111/krwynn/partial2.gif
Partial3: http://i118.photobucket.com/albums/o111/krwynn/partial3.gif

You may have to rename the file after you first open it and save it. Some might, some might not. Some systems will see the downloaded file as "read only". To fix that, all you need to do is save it under a different filename.

Update: Just made available Flex Log for owners and/or players. Easily keep track of where players have flex and what areas they should work on. Color coded to show what attributes are important to each position and their value when the player levels up. Can be downloaded from the same link as above(Added another link on that page). It's a standard excel sheet.

You may want to save BLANK copies of each and then save another copy season3 or whatever season it may be. That way you wont have to go back and zero everything out for future seasons.

Disclaimer: If you are a computer tard and don't know anything about excel spreadsheets, a zip file, or how to follow the extremely simple instructions, please do us both a favor and DO NOT download this file. THIS IS NOT A PROGRAM! It's a simple excel spreadsheet FILE.

06032008: Fixed the setup page so that the links are clickable. Sorry for the goof.

06122008: New version. 1.1. Download from the same link as before.
Screenshot link http://goallineblitz.com/game/forum_thread.pl?thread_id=305746&page=last#2771962


Last edited Jun 27, 2008 01:15:57
 
tpaterniti
Lead Mod
offline
Link
 
Chemistry Lookup Table: http://goallineblitz.com/game/forum_thread.pl?thread_id=328112

Originally posted by tiger5
If you want to know when your team chemistry will return to 100 without any further roster change, please take a look at this table:

http://spreadsheets.google.com/pub?key=pUxyVxgO5dqIJhCU9zNA7RQ

It might help.

- Oakland Intimidators (USA Pro West)


Last edited Jun 27, 2008 01:16:25
 
tpaterniti
Lead Mod
offline
Link
 
A Quick Stadium FAQ: Construction vs. Expansion: http://goallineblitz.com/game/forum_thread.pl?thread_id=114853

Originally posted by Mrstickball
Hello everyone. I thought I would put together a ROI (return on investment) spreadsheet, so all owners could find out what the best way of going about construction is, now that the season is under way.

I took a few minutes out of my night to created the numbers in a Google Spreadsheet for anyone/everyone interested in seeing the various return rates on Construction items, and Expansion Items.

http://spreadsheets.google.com/pub?key=pTLj2bA3Ha6tRZr5ZNaLtAw

Is the link. It contains info on:

Seating Types
Seating Names
Seating Capacity (Initial and Maximum)
Cost Per 10 Seats to Buy (Construction Cost per 10, and Expansion Cost per 10)
My Ticket Prices used for calculation
Return on Investment (ROI) for Expansion & Constructed Seating
Return on Investment (ROI) for Expansion & Constructed Seating W/ Concession Stand Sales for 8 Games.

This list isn't comprehensive, or exhaustive (as no one has got the 200-Corner and Sideline seats yet). However, it should give you a good idea on what kind of return you'll get.


So a quick few Q&As:

Q. Should I construct seating, or expand what I currently have?
A. Most every case, constructing your seating gives you a much better return on your investment (usually double). However, construction only can happen in the offseason, limiting when you can do it.

Q. Should I buy expansion seating at all, during the normal year? Upto what home game can it be worthwhile?
A. It's up to you to deem it worthwhile. Check my charts, divide by 8, then multiply by your number of home games to find your ROI for your situation. What is it worth to you? Personally, after Home Game #3 (of 8), returns seem to be kinda...Not worth it.

Q. How fast does Expansion or Construction Seating take to build?
A. Constructed Seating, the massive $1m+ projects that add a part to your stadium, are only completed during the offseason (ie, after the playoffs). Expansion seating is built instantaneously when you buy it.
When in Offseason, it takes 1 day to complete the construction. However, to my knowledge, it's the last night of offseason...So if you've built construction, it should get done by Day 0, of the next season. So because of this, you cannot add a second layer incase you've bought everything.

Expansions are built the second you confirm the purchase...So buy expansion seating wisely, as you cannot sell it back!

Q. What are maximum seating capacities for <insert area>?
A. Check the chart. It has min/max numbers.

Q. When can I start selling tickets for my games? What about Playoffs?
A. Every night during regular season, at the same time your players get XP. For playoffs, it's 2 days before each playoff game.

Q. How much do I make per person on concessions at default pricing (so I know what you calculated with)?
A. I used my own stadium's income of roughly $10.50 per person, per game - this was my default pricing, and was rather stable. However, since then, I have jacked my prices up to 1.2x the normal cost (roughly $110 for a jersey). This has increased my income from concessions to roughly $15.00-$16.00 per person per game.

http://spreadsheets.google.com/pub?key=pTLj2bA3Ha6tRZr5ZNaLtAw
/\ Spreadsheet

Take care!


Last edited Jun 27, 2008 01:16:41
 
tpaterniti
Lead Mod
offline
Link
 
GLB Radio Information: http://goallineblitz.com/game/forum_thread.pl?thread_id=245693

Originally posted by Esen
Hi,

As some of you know we have started up a radio program for GLB.

Due to a lot of PMs here I have also set up a Message boards for the radio show.
You can post all of your radio show questions there as well as you apps to help on the show.
This way we do not bog down the inboxes and forums here.


Radio Show link:

http://www.blogtalkradio.com/GoalLine-Blitz-Radio

There are three shows now. One on Monday's at 8pm EST, one on Thursdays at 11pm EST and one on Sundays at 1pm EST

Here is the web board link for it:

http://glbradio.ipbfree.com/index.php?act=idx

Thanks for listening I hope you like it.

Announcement:
BLOG TALK RADIO IS now making us a featured show!!!!!!
Thanks
-Erik





Last edited Sep 10, 2008 09:22:57
 
tpaterniti
Lead Mod
offline
Link
 
GLB Chat Room (Web Base AIM Chat Room): http://goallineblitz.com/game/forum_thread.pl?thread_id=315665

Originally posted by Just Osmo
http://chat.aim.com/chats/games/goallineblitz
Last edited Jun 27, 2008 01:17:36
 


You are not logged in. Please log in if you want to post a reply.