FAQ
Home
Podcast
Forums
Coming Soon
About Us
Contact Us
Privacy Policy
AndroidAppStats

Next Gen Fantasy

The Grid: Auction FAQ


Support FAQs
(technical issues and troubleshooting)

Optimization FAQs (increase Speed, show more on screen, using Excel features)

Fantasy League FAQs (information on different league scenarios about positions, keepers, scoring, etc.)

 

Support FAQ

Support FAQ

How do I contact support if I’m having an issue not found in the FAQ?

First and foremost, make sure you have a lot of practice using the product before you use it in a live auction.  You can do this just by playing around and trying different things, or by doing some mock auctions using the tool (see the Mock Drafting FAQ further down the page).

Next, be sure you have consulted the FAQ thoroughly before contacting support.  If the issue persists, please send an email to support@nextgenfantasy.com with the following contents:

·         A screenshot, if possible, of the error or issue you are experiencing.  If this is not possible or you’re unsure how to do it, provide a full, detailed description of the error or issue, as well as what you were doing when you encountered it.

·         An attached copy of the Excel file of The Grid: Auction that is having the problem.

How do I enable macros for The Grid: Auction to function properly?

The Grid: Auction uses macros that are 100% guaranteed to be safe.  Different Excel versions require different steps to make the macros functional.  See below on how to enable the macros for your version of Excel.

Excel 97

·         When the file is opened you will be prompted with a popup to which you must answer Enable Macros

Excel 2000

·         Check the Security level in the menu: Tools > Macro > Security

·         Set to low for The Grid: Auction to work without prompting you when opening (this may leave you open to dangerous macros from other sources)

·         Set to medium (recommended) to be prompted whether to enable the macros when opening The Grid: Auction (Select "Enable Macros")

·         If set to High, The Grid: Auction will not work

Excel 2003

·         Check the macro security level in the menu: Tools > Options > Security > Macro Security

·         Set to low for The Grid: Auction to work without prompting you when opening (this may leave you open to dangerous macros from other sources)

·         Set to medium (recommended) to be prompted whether to enable the macros when opening The Grid: Auction (Select "Enable Macros")

·         If set to High, The Grid: Auction will not work

·         If set to Very High, The Grid: Auction will not work

Excel 2007

·         Check Macro Settings in menu: Office button (upper left) > Excel Options (lower right) > Trust Center (left side) > Trust Center Settings (button right middle) > Macro Settings (left side)

·         Set to "Enable all macros" for The Grid: Auction to work without prompting you when opening (this may leave you open to dangerous macros from other sources)

·         If set to "Disable all macros except digitally signed macros", The Grid: Auction will not work

·         Set to "Disable all macros with notification" (recommended) to be prompted to allow macros in The Grid: Auction

o   Once you open the file, you'll see a notification at the top saying "Security Warning    Macros have been disabled.    [button: Options...]"

o   Click the Options button, select "Enable this content", and then click OK

·         If set to "Disable all macros without Notification", The Grid: Auction will not work

What do I do when it says “Run time error” with “End” and “Debug” buttons?

Record exactly what you clicked that produced this error, as well as exactly what it says in the error popup, and email it to support@nextgenfantasy.com.  Also please include a copy of the file as an attachment.

In the meantime, click the End button and close the file (you may save if you choose).  Open the file again, click the Refresh button and ensure that your auction is still in good condition.  You may be able to proceed just fine – the error may have been an anomaly.  If the error recurs every time you perform a certain action, all the more reason to send the error to us – we’ll take a look as soon as we can.

What if I don’t see the The Grid: Auction’s custom toolbar?

First note that in Excel 2007 things work a little different with the ribbon.  The toolbar options will be in the Add-Ins tab on the ribbon.

If that is not it, or you don’t see the toolbar in previous Excel versions, you may not have macros enabled.  See the FAQ above about allowing macros to try to solve the problem.

If it is still not solved, contact Next Gen support as indicated at the top of the FAQ.

What if I double-click a cell in The Grid, or enter a player name search at the top, and nothing happens?

This is a clear sign that macros are not enabled.  See the FAQ above about enabling macros.

What do I do if The Grid: Auction is doing something weird for a certain player?

The first thing to check is that you don’t have two players in the AvgDraft tab with an identical name.  Go to that tab and do an Excel Find operation for the player in question.  If you find two instances, you have a problem.  You must do something to distinguish the player names in AvgDraft, such as “Chris Young-P” and “Chris Young-OF”.

In other rare cases where there was an unexpected error, a player’s status may get out of sync.  Know that these are the basic roles of three tabs in the product so that you can get the player back in sync:

·         The Grid: This tab has no responsibility for recording a player’s status.  It simply is a constantly updating visual into the status of players as stored in the two tabs below

·         AvgDraft: This tab is responsible for recording the master list of players, the cheat sheet.  If a player has been purchased, their name will be in a strikethrough font (a line going through it).  If this is the case, then the player must also appear in the ActDraft tab – if not then they’re out of sync

·         ActDraft: This tab is responsible for recording completed player auctions.  If a player appears here, then they should also show in the AvgDraft tab with a strikethrough font – if not then they’re out of sync.

If you find that AvgDraft and ActDraft are out of sync for a player, then take the following steps:

·         If player is supposed to have been purchased: Go to the AvgDraft and find the player (you can do an Excel Find operation from the menu).  Make sure his name appears in a strikethrough font.  If not, then format the cell to have it (you can find this in the font tab for Format Cells).  Now find the player in the ActDraft.  If you find him, make sure his name, purchasing team, and purchase amount are there.  If his name is there but not the other pieces, simply add those other pieces.  If you don’t find the player here at all, you’re best off un-auctioning him and redoing it.  To do that, go back to AvgDraft and take strikethrough font off.  Then return to The Grid, find that player and start an auction for him.  Quickly go through the process, picking the winning team and entering the winning amount.  This will get him squared away on both tabs.

·         If a player is not supposed to have been purchased: Go to the AvgDraft and find the player (you can do an Excel Find operation from the menu).  Make sure his name does not appear in a strikethrough font.  If not, then format the cell to remove it (you can find this in the font tab for Format Cells).  Now try to find the player in the ActDraft.  If you find him, delete his name, team and amount so that the row is empty except for the number on the left.

Optimization FAQ

Optimization FAQ

How can I maximize the refresh speed after a completed auction?

The speed of refresh after entering an amount to complete an auction will generally be about 3-4 seconds on most computers.  If your computer is running slower or you’d like to shave a little time off of this, here are some options in order of speed improvement:

·         Don’t list more players in the AvgDraft than you need.  If you think you only need 250 or so to get through the auction, don’t list 400.  This may not be feasible if you really need 400, but here’s a trick: when The Grid is refreshing, it will scan through AvgDraft until it finds a blank name.  So early in the auction, you can take the last half of AvgDraft and cut and paste it down one row, so that there is a blank row in between the first and second half of the list.  Once you get deeper into the auction and you need more names in the grid, cut and paste some or all of the rows below the blank back up.

·         Use the toolbar “Show” option of “Position”.  This is the entry that will skip any value icons you may be using in the Styles tab column B, which add a little time to the refresh.

How can I maximize the amount of players that appear on screen at once?

The more names you can see on screen, the easier it will be to view the landscape of the auction and make decisions on who to bid on and who to wait for.  You have a lot of options, listed below:

·         Increase the resolution of your screen

·         Hide or move the Windows Start bar

·         Hide the status bar in Excel

·         Lower the zoom level in Excel

·         Increase the width of all columns in The Grid, which will force fewer cells to wrap and create extra vertical space

·         Use “$ Format” in the toolbar of “Compress” or “Comment”.  To maximize the effect of this, also go into the styles tab and set the format of all your value and position cells to “Shrink to Fit” (in the Alignment tab of the Format Cells screen).  This will guarantee that each cell of the grid does not wrap at all.  To further maximize, change the row height of row 18 in the Styles tab.

·         Decrease the font size in your value and position cells in the Styles tab, particularly any icons in column B

·         Collapse some or all of the budget statistics rows at the top by clicking using the + and – buttons in the upper left.  You can also lower the font size of the Remaining budget row to save space.

·         In Excel 2007, minimize the ribbon – tabs are still available to click so you can still get to the functions you need

·         In previous versions of Excel, hide all toolbars except for The Grid: Auction custom toolbar.

·         The formula bar and row and column headings are already suppressed by default to save space – ensure that they are hidden.

How can I use native features of Excel to enhance The Grid: Auction?

Excel is such a powerful tool that it would be impossible to think of all the things you can do – part of our decision to use Excel as our “Operating System”.  This will also depend on your level of experience with Excel.  But here are a few starter ideas:

·         Add charts or even change default pie chart based on the budget statistics.  You could do a line or bar graph with all teams in the league on it.  You could do some charts showing dollar spent by position, remaining by position, etc.

·         You could create another sheet that is a mirror of the AvgDraft tab, but alphabetized by player name so that you can do VLOOKUPS (an Excel function you can read up on if you don’t know it).  This can open up a world of possibilities were you can set up formulas to track how much you’re spending by position, against preset positional budget guidelines.  You can include many statistics on this new tab and do formulas to keep track of how you look in given statistical categories, what you should draft for, and what you already have.

·         Use the “random” function of Excel to create your own mock-draft functionality, having Excel dictate a top-bid amount of some random amount near, but not exactly matching, the nominated player’s suggested value.  Then you can conduct a mock auction by constantly deciding whether you want to beat the max bid.

Fantasy League FAQs

Fantasy League FAQs

How can I auction for more than one team?

This basically works right out of the box.  A feature of the product is that you can see the situation of all teams, not just your own.  So there’s no reason you can’t monitor needs of both teams and act on their behalves.  We’ve all been in leagues where someone doesn’t show and you could be forced to do this (though in an auction it’s particularly tricky and more of a conflict of interest).

How can I reflect multi-position eligibility?

Unfortunately the grid does not handle multi-position eligibility well yet.  You'll need to do one of two things:

·         Create actual positions for each possible combination, like "1B/3B" in baseball or "PF/C" in basketball.  It may be impractical to cover all possible combinations with their own combo-position, thus their own color, especially in baseball where some utility-men cover 4 or 5 positions.  But basketball or hockey may be more manageable, or even in baseball, you can cover a few common ones like 1B/3B or SP/RP, and handle the rest as in the next bullet

·         Your only other option is to blow away all multi-positions and simply make a choice for each player what position you'll treat them as.  In this case we suggest you choose the most-scarce position so as to give the best indication of value when drafting.  Another way to augment this method is to populate additional position eligibility right in the Name, like “Adam Dunn-1B,OF”.

How can I handle positions that are more specific than in my league, like if Tight Ends are treated as Wide Receivers in football, or Point Guards and Shooting Guards are all just Guards in basketball?

You have two options here:

·         Change their position in AvgDraft to be the less specific position, like “WR” or “TE”.  One drawback here is that they’ll be indistinguishable, and you might prefer knowing the difference.

·         Include cells for the more-specific positions (like “TE”, “PG”, “SG”) in the Styles sheet and simply format them the same as WR and G, respectively.  Or better yet, format them the same color but just a couple shades off, so you can tell the difference but you can also tell they’re from the same general position color.

Can I use unusual positions, like IDP in football?

Without a doubt, yes.  However, the pre-filled data in AvgDraft will not include them, and you’ll need to work them in yourself.  Once you've done that though, it works just like any other position.  Simply make sure you have styles set up for each position in the Styles sheet columns D:H, and that they exactly match the positions for corresponding players in AvgDraft column C.

Can I reflect each team’s keepers for specific amounts before the auction?

You can absolutely do this.  You basically conduct auctions in the product just like you would normally, except as soon as you nominate the player, you know instantly know the team and the amount.  Simply set some time aside before the auction to go through and finish all the keepers.  All the kept players and remaining budgets will then be ready to go for live auctioning.

Can I use the product for AL or NL-only leagues?

Yes, you simply need to customize the AvgDraft rankings to include only the eligible players.  We’ve even heard of certain hybrid leagues, for instance one where each team is allowed one NL player and the rest AL.  These would be fully supported too.  Again, you simply need to adjust the AvgDraft to have only eligible players and be ranked in a way that considers your league setup.

How were the prefill rankings determined?

All prefills are created by aggregating several different respected sources into one set of rankings.  They are generally based on the most standard league types in a given sport.  Here are the assumptions in the data for the current baseball product:

·         Starters: C, 1B, 2B, 3B, SS, MI, CI, OFx5, UTILx2, Px9, 3 bench for 26-player roster

·         Category-based scoring, either rotisserie or head-to-head, using 5x5 categories (R, HR, RBI, SB, AVG and W, K, SV, ERA, WHIP)

·         Total team budget of $260

·         Mixed-league (not AL or NL-only)

·         Redraft (non-keeper) league

If your league differs from this, you can completely replace the AvgDraft rankings, move them around a bit, or leave them and try to adjust on the fly during the auction.

How should I customize the AvgDraft and Value assessments?

First, think about how you may want to change them based on your league rules, based on the FAQ above.  However, the theory of how The Grid: Auction is truly supposed to help you requires understanding.

What you want to put in AvgDraft is the best approximation of what all your opponents are looking at.  You want to know as well as you can how they’re going to value players, so you can use that to work your own strategy of letting overvalued players go and grabbing undervalued ones.  Our prefill approach is designed to optimize this goal, by aggregating many different sources (including expert rankings, expert mock drafts, ADP rankings).

However, for whatever reason you may want to change them.  For one thing, they’ll never be as up to date as what you can go grab off the internet right here and now.  Another reason could be that your league rules may differ enough from the prefill assumptions (the above FAQ), that the prefill won’t work.  A quick note though: If your opponents are not likely to use rankings tuned to your league rules, then you don’t want your AvgDraft to either.  Again, you want them to reflect what everyone else thinks.

So if you want to change AvgDraft, here are our suggestions in order of preference:

·         If you’re in an online draft room for your fantasy site, you absolutely want to get your hands on the rankings that your fantasy site is going to show to everyone in the auction room.  There’s no doubt they’ll all be heavily influenced by the rankings right in front of them.  If you can, put those exact rankings in AvgDraft.

·         Find the most-recent ADP listing (Average Draft Position).  This will show you what people are doing in actual live auctions.

·         Find a single source you trust that seems to be a good approximation of what your opponents might have.

Now, here’s where you contrast what your opponents are using with your own opinions.  This is what the value assessments (in the Styles and AvgDraft tabs) are designed for.  If you think a player is undervalued at their AvgDraft amount, mark them with a value that will tell you that, and you’ll know you can enter the bidding and possibly win for less than “list price”.  If you think a player is overvalued, you can enter the bidding, but know that you probably won’t want to get up to the “list price” and exit the bidding if it indeed goes that high.

Your own opinions can come from anywhere: sleepers, busts, breakouts, risks, studs, duds, etc. from fantasy experts.  Or maybe you’re an expert yourself and you just know.  Or if you love stats, you can do some analysis, based on some source of projected stats, that determines an auction value.  Do some work to contrast that with the AvgDraft amounts, and your value assessments will be clear.

This is the true power of the product, to maximize your spending by knowing exactly how you value players in contrast to what the rest of the crowd is doing.

What sports can I use the product for?

Any sport you can think of that could have a fantasy auction works in The Grid: Auction.  The goal of the product is to take a set of rankings and display them in a way that gives you an edge in live decision-making.  Therefore sport, league setup, and player list are largely independent.  You only need to buy this product once, then all you need to do for other sports is change the settings and rankings.

For that matter, we’ve even heard of some crazy things like fantasy movie leagues, or some of the fun stuff you’ll hear on a Bill Simmons podcast on ESPN (fantasy Us magazine, fantasy Real World).  You could even use it to follow along with actual pro sports drafts.

The point here is, regardless of the prefill and marketing you see when you first buy the product, you can use it for anything.  We will also be creating prefills in the future so you can still get different rankings from us for different sports without re-buying the core product.

How can I use the product for mock drafting?

We are working on a mock-auction add-in product, but you still have options.  Up in the Optimization FAQ section we gave one idea of how you can build in your own mock auction functionality.

But perhaps your best bet is to go online and find free online mock auction services (ESPN has an excellent one).  Do the mock auction in that window while keeping your copy of The Grid: Auction in another window (two windows, sure, but you’ll be better off for it).  Try quite a few of these.  You get great experience in the following ways:

·         How it feels during the heat of a live auction – the more practice you get, the more it all just “slows down” for you

·         How people are valuing players – what it may take to get someone in your auction

·         How different strategies feel – what kinds of traps or advantages you encounter – when, for instance, paying big for several studs and filling out with $1 players vs. picking up more mid-level players.

·         You get very experienced at using the product and can tune your settings and approach for the real thing.  A live auction is no place to use the tool for the very first time.

Can I use the product as a draft board for my league’s live, in-person draft?

Of course!  Because it shows all team’s purchases and budget stats on the same screen, it is an ideal tool for this purpose.  We guarantee no other tool for the price will make a commissioner’s life easier for a live, in-person draft.  And not only can you do this in person with a projector / monitor / HDTV, you can use online with something like Net/Live Meeting or WebEx.

Copyright © Next Gen Fantasy Sports Royal Oak, MI
info@nextgenfantasy.com
Search Site