Best Buy Trade-in 3.0: So long! New thread started.

Status
Not open for further replies.

BudzMcGee

CAGiversary!
Feedback
3 (100%)
A new year, a new thread. You can view the previous thread here!

All Promotions are available in-store only, and they DO NOT stack!
Only the 10% Bonus from Gamers Club Unlocked will stack with these offers.
Please read FAQ below before asking questions!

Current Promos:
- 100% Bonus Trade-In Credit W/any trade in:
Get a 100% bonus when you trade-in any game (Offer valid 8/19 - 10/6 - Unconfirmed end date, 9/8 is the latest confirmed date)

General video game promotions link: http://www.bestbuy.com/site/olspage.jsp?id=pcat17093&type=page (Promotions are listed at the bottom of the page)

Previous Promotions:
Promos that have expired:
- 50% Bonus Trade-In Credit W/any trade in:
Get a 50% bonus when you trade-in any game (Offer valid 7/07 - 8/18)

- 50% Bonus Trade-In Credit W/any trade in of "hot titles":
Get a 50% bonus when you trade-in any game (Offer valid 4/22- 06/02)

- Minimum 50% Bonus Trade-In Credit W/ Select Pre-orders:
Get a 50% bonus when you pre-order Call of Duty: Black Ops II, Max Payne 3, Borderlands 3, Far Cry 3, Assassin's Creed 3, Halo 4, Medal of Honor: Warfighter, BioShock Infinite, Madden NFL 13, NCAA Football 13, Tom Clancy's Ghost Recon: Future Soldier, Diablo III . (Offer valid 05/06 - 5/12)

- 40% bonus with pre-order of .
Get a 40% trade in bonus when you pre-order any of these games: Max Payne 3, Borderlands 3, Far Cry 3, Assassin's Creed 3, Halo 4, Medal of Honor: Warfighter, BioShock Infinite, Madden NFL 13, NCAA Football 13, Tom Clancy's Ghost Recon: Future Soldier or Diablo III (Offer valid 04/08/12 -04/14/12).
- 40% bonus with purchase of Tiger Woods PGA Tour 13, Major League Baseball 2K12, FIFA Street, Mario Party 9 or Kinect Star Wars.
Get a 40% trade in bonus when you purchase select title (Offer valid 04/08/12 -04/14/12).
- Minimum 40% bonus with pre-order from select list.
Get a "minimum" 40% trade in bonus when you pre-order any title from a select list of games listed below *note, I have absolutely no idea what this means* (Offer valid 04/01/12 -04/07/12):
Max Payne 3
Borderlands 3
Far Cry 3
Assassin's Creed 3
Halo 4
Medal of Honor: Warfighter
BioShock Infinite
Resident Evil: Operation Raccoon City
Madden NFL 13
NCAA Football 13
- 50% bonus with any trade-in.
Get a 50% trade in bonus when you trade in any title (Offer valid 03/25/12 -03/31/12).

- Guaranteed $30 or more trade in credit for select games with purchase of game $39.99 or higher.
Purchase a video game priced $39.99 or more and get at least $30 credit when you trade-in one of the titles listed below (Offer valid 03/18/12 -03/24/12):

Twisted Metal - PS3
Final Fantasy XIII–2 — PS3 or Xbox 360
Uncharted 3: Drake's Deception — PS3
The Elder Scrolls V: Skyrim — PS3 or Xbox 360
Call of Duty: Modern Warfare 3 — Nintendo Wii, PS3 or Xbox 360
UFC Undisputed 3 — PS3 or Xbox 360
Soul Calibur V — PS3 or Xbox 360
Kingdoms of Amalur: Reckoning — PS3 or Xbox 360
The Darkness II — PS3 or Xbox 360
Forza Motorsport 4 — Xbox 360
The Legend of Zelda: Skyward Sword — Nintendo Wii
FIFA Soccer 12 — PS3 or Xbox 360
Battlefield 3 — PS3 or Xbox 360
Zumba Fitness: Rush — Xbox 360
Grand Slam Tennis 2 — PS3 or Xbox 360
Syndicate — PS3 or Xbox 360
FIFA Street — PS3 or Xbox 360
Mass Effect 3 — PS3 or Xbox 360
MLB 12: The Show — PS3
MLB 2K12 — PS3 or Xbox 360
Silent Hill: Downpour — PS3 or Xbox 360
SSX — PS3 or Xbox 360
Street Figher X Tekken — PS3 or Xbox 360
Binary Domain — Xbox 360
Mario Party 9 — Nintendo Wii
Asura's Wrath — PS3 or Xbox 360

Link:
http://www.bestbuy.com/site/Games-P...er/pcmcat268500050004.c?id=pcmcat268500050004



- 40% bonus with pre-order of select titles.
Get a 40% trade in bonus when you pre-order any title from the list below (Offer valid 03/18/12 -03/24/12):
Max Payne 3
Borderlands 3
Far Cry 3
Assassin's Creed 3
Halo 4
Medal of Honor: Warfighter
BioShock Infinite
Resident Evil: Operation Raccoon City
Madden NFL 13
NCAA Football 13

Link: http://www.bestbuy.com/site/Games-P...er/pcmcat268500050008.c?id=pcmcat268500050008


- 40% bonus with order of Resident Evil: Operation Raccoon City.
Get a 40% trade in bonus when you order Resident Evil: Operation Raccoon City. Offer valid 03/11/12 -03/17/12

- 40% bonus with order of Assassin's Creed 3.
Get a 40% trade in bonus when you order Assassin's Creed 3. Offer valid 03/11/12 -03/17/12

- *RUMORED* 40% bonus with order of any pre-order.
Get a 40% trade in bonus when you pre-order any game (rumor of a non-listed promo, may or may not be true). Offer valid 03/11/12 -03/17/12

- 40% bonus with order of Street Fighter X Tekken.
Get a 40% trade in bonus when you order Street Fighter X Tekken. Offer valid 03/03/12 -03/10/12

- 40% bonus with order of Mass Effect 3.
Get a 40% trade in bonus when you order Mass Effect 3. Offer valid 03/03/12 -03/10/12

- 40% bonus with order of MLB: The Show 12.
Get a 40% trade in bonus when you order MLB: The Show 12. Offer valid 03/03/12 -03/10/12

- 40% bonus with order of MLB 2K12.
Get a 40% trade in bonus when you order MLB 2K12. Offer valid 03/03/12 -03/10/12
- 50% bonus with pre-order of Mass Effect 3.
Get a 50% trade in bonus when you pre-order Mass Effect 3. Offer valid 02/26/12 -03/03/12

- 50% bonus with pre-order of MLB: The Show 12.
Get a 50% trade in bonus when you pre-order MLB: The Show 12. Offer valid 02/26/12 -02/25/12

- 50% bonus with pre-order of MLB 2K12.
Get a 50% trade in bonus when you pre-order MLB 2K12. Offer valid 02/26/12 -02/25/12

- Trade 3, get 30% More.
Trade in 3 games or more and get 30% extra trade-in credit. Offer valid 01/01/12 -03/03/12

- 30% Bonus with any Pre-order.
Get a 30% extra trade-in credit when you pre-order any game. Offer valid 01/01/12 -03/03/12

- 40% bonus with purchase of Vita Software or Hardware.
Get a 40% trade in bonus when you purchase Playstation Vita Software or Hardware. Offer valid 02/19/12 -02/25/12

- 40% bonus with pre-order/purchase of UFC Undisputed 3.
Get a 40% trade in bonus with pre-order/purchase of UFC Undisputed 3. Offer valid 02/12/12 -02/18/12

- 40% bonus with pre-order/purchase of Twisted Metal.
Get a 40% trade in bonus with pre-order/purchase of Twisted Metal. Offer valid 02/12/12 -02/18/12

- 50% bonus with pre-order of Diablo III or UFC 3.
Get a 50% trade in bonus with pre-order either Diablo III or UFC 3. Offer valid 02/05/12 -02/12/12? ***NOTE*** This promo is NOT showing up on the BestBuyTradeIn.com page currently, but it confirmed to work by at least one CAG. It is listed as "this weeks" deal, hence the probable end date.
- 40% bonus with pre-order/purchase of Final Fantasy XIII-2.
Get a 40% trade in bonus with pre-order/purchase of Final Fantasy XIII-2. Offer valid 01/29/12 -02/04/12

- 40% bonus with pre-order/purchase of Soul Calibur V.
Get a 40% trade in bonus with pre-orde/purchase of Soul Calibur V. Offer valid 01/29/12 -02/04/12

- 50% bonus with pre-order of Final Fantasy XIII-2.
Get a 50% trade in bonus with pre-order of Final Fantasy XIII-2. Offer valid 01/15/12 -01/28/12

- 50% bonus with pre-order of Soul Calibur V.
Get a 50% trade in bonus with pre-order of Soul Calibur V. Offer valid 01/22/12 -01/28/12
- 50% Bonus when you trade in ANY game.
Get a 50% trade in bonus when you trade in ANY game. Offer valid 01/01/12 - 01/07/12

- 50% Bonus with specific Pre-order from list.
Get a 50% extra trade-in credit when you pre-order any game from the following list: Halo 4, Mass Effect 3, Bioshock Infinite, Grand Theft Auto 5, MLB 12 The Show, Soul Calibur V, Final Fantasy XIII-2, Twisted Metal, Max Payne 3, Resident Evil: Operation Raccoon City and Diablo 3. Offer valid 12/25/11 - 12/31/11

- Trade 2, get 25% More.
Trade in 2 games or more and get 25% extra trade-in credit. Offer valid 11/27/11 - 12/31/11

- 30% Bonus with any Pre-order.
Get a 30% extra trade-in credit when you pre-order any game. Offer valid 11/27/11 - 12/31/11
- 40% Bonus with purchase of any game $39.99 or above.
Get a 40% extra trade-in credit when you purchase any game $39.99 or above. Offer valid 11/27/11 - 12/10/11

- 50% Bonus with purchase of any game $39.99 or above.
Get a 50% extra trade-in credit when you purchase any game $39.99 or above. Offer valid 11/27/11 - 12/03/11

- Trade 3, get 30% More.
Trade in 3 games or more and get 25% extra trade-in credit. Offer valid 10/30/11 - 11/26/11

- 40% Bonus with any Pre-order.
Get a 40% extra trade-in credit when you pre-order any game. Offer valid 10/5/11 - 11/26/11

- 40% Bonus with Saints Row 3 Pre-order/Purchase.
Get 40% extra trade-in Credit when you pre-order/purchase Saints Row 3. Offer valid 11/13/11 - 11/19/11

- 40% Bonus with Assassin's Creed Revelations Pre-order/Purchase.
Get 40% extra trade-in Credit when you pre-order/purchase Assassin's Creed Revelations. Offer valid 11/13/11 - 11/19/11

- 50% Bonus with Modern Warfare 3 Pre-order/Purchase.
Get 50% extra trade-in Credit when you pre-order/Purchase Modern Warfare 3. Offer valid 10/10/11 - 11/12/11 (Assuming this means a bonus for purchasing the game after it is released this Tuesday)

- 50% Bonus with Saints Row 3 Pre-order.
Get 50% extra trade-in Credit when you pre-order Saints Row 3. Offer valid 11/6/11 - 11/12/11

- 50% Bonus with Assassin's Creed Revelations Pre-order.
Get 50% extra trade-in Credit when you pre-order Assassin's Creed Revelations. Offer valid 11/6/11 - 11/12/11

- 40% Bonus with The Elder Scrolls V: Pre-order/Purchase.
Get 50% extra trade-in Credit when you pre-order/purchase The Elder Scrolls V: Skyrim. Offer valid 11/6/11 - 11/12/11

- 50% Bonus with Max Payne 3 Pre-order.
Get 50% extra trade-in Credit when you pre-order Max Payne 3. Offer valid 11/6/11 - 11/12/11 - This promo seems a little odd and there is a chance it is an error on the site since the game is so far from release.

- 50% Bonus with Saints Row 3 Pre-order.
Get 50% extra trade-in Credit when you pre-order Saints Row 3. Offer valid 10/23/11 - 10/29/11

- 50% Bonus with Skyrim Pre-order.
Get 50% extra trade-in Credit when you pre-order The Elder Scrolls V: Skyrim. Offer valid 10/23/11 - 11/05/11

- 40% Bonus with Uncharted 3 Pre-order/Purchase.
Get 40% extra trade-in Credit when you pre-order/purchase Uncharted 3. Offer valid 10/30/11 - 11/05/11

- 40% Bonus with Battlefield 3 Purchase.
Get 40% extra trade-in Credit when you purchase Battlefield 3. Offer valid 10/23/11 - 10/29/11

- Trade 2, get 25% More.
Trade in 2 games or more and get 25% extra trade-in credit. Offer valid 10/2/11 - 10/29/11

- 50% Bonus with Battlefield 3 Pre-order.
Get 50% extra trade-in Credit when you pre-order Battlefield 3. Offer valid 10/9/11 - 10/22/11

- 40% Bonus with purchase of Batman: Arkham City.
Get 40% extra trade-in Credit when you pre-order Batman: Arkham City. Offer valid 10/16/11 - 10/22/11

- 50% Bonus with Batman: Arkham City Pre-order.
Get 50% extra trade-in Credit when you pre-order Batman: Arkham City. Offer valid 10/9/11 - 10/15/11

- 30% Bonus with Rage or NBA 2K12 Pre-order/Purchase.
Get a 30% extra trade-in Credit when you pre-order/purchase Rage or NBA 2K12. Offer valid 10/2/11 - 10/08/11

- Trade 4 get an extra $20 Trade-in Credit.
Get $20 trade-in Credit when you trade 4 or more games (Current gen games only (no PS2) and $5 minimum for each game). Offer valid 10/2/11 - 10/08/11**** This promo was cancelled early due to technical issues. There have been issues with this promo not working on some stores' systems or simply not even being available, the issue seems to be related to disc-only games (or any game that is typed rather than scanned) so plan accordingly. The $20 extra is once per trade-in, meaning 4 games or 123 games it will only be $20 extra per transaction. So if you want to trade in 8 games, do it in two separate transactions. ****

- 50% Bonus with Rage or NBA 2K12 Pre-order.
Offer was valid from 9/25 to 10/01/2011.

- 40% Bonus with Gears of War 3 Purchase.
Get a 40% extra trade-in credit when you pre-order/purchase Gears of War 3. Offer expired 10/01/2011

- Trade 3, Get 30% More.
Trade in 3 games or more and get 30% extra trade-in credit. Offer expired 10/01/2011

- 40% Bonus with any Pre-order.
Get a 40% extra trade-in credit when you pre-order any game. Offer expired 10/01/2011


------------------------------------------------------------------------------------------------------------------------------

BEST BUY'S VIDEO GAMES TRADE-IN PAGE & VALUE ESTIMATOR

Check which BB stores do trade-ins here.
In-store trades are now done at the Trade-In Counter at the Gaming Dept.

------------------------------------------------------------------------------------------------------------------------------

F.A.Q. Best Buy has a short FAQ here.

How does the get **% with pre-order bonus work?
The percentage is based on the final total of your entire trade in, so if the trade in is $100 and there is a 50% bonus your final gift card value will be $150. After trading in your games, the employee SHOULD then sell you the pre-order for $5.

How much is a pre-order at Best Buy?
Pre-ordering at Best Buy cost $5, in fact, you aren't supposed to pay any more than that (and most employees won't let you if you ask). Yes, you can use the gift card you just received from your trade-in to purchase the pre-order.

Can I cancel a pre-order and keep the bonus?
Yes, the trade-in and the pre-order are completely separate transactions. Nothing will prevent you from returning to the Best Buy canceling the pre-order and receiving a refund. Some users have claimed that they were flagged for doing this multiple times though and were denied, so be aware of how many pre-orders you are cancelling. Also keep in mind the obvious facts that this is not how the program is intended to work and over abuse will negatively affect the program long-term. Lastly, returns are tracked on a personal level by a third party. (Read: try not to cancel a bunch of pre-orders)

Do I have to cancel the pre-order at the same store where it was made?
No, this can be handled by any BBY. Don't be surprised if you get a customer service employee who says otherwise though.

Can I pre-order once and get the pre-order bonus on my next trade-in as well?
YMMV. Officially, the answer is no, but there is nothing that actually requires the employee to sell the pre-order in order to apply the bonus so if your blue shirt is in a friendly mood they may be willing. Doesn't hurt to get to know the employees at your store. That said, expect that you will have to pre-order another game and be surprised if you don't.

Can I combine a 3 games for **% and a pre-order for **% bonus?
No. Bonuses do not stack, and you must pick one or the other. The only bonus that stacks with other promotions is the 10% you receive if you are a Gamers Club Unlocked member.

How do I become a Gamers Club Unlocked member and get the 10% bonus?
Any video game section employee should be able to set you up with the GCU membership. It cost $15 and comes with a year subscription of @Gamer magazine. It will also get you a 10% bonus on trade ins and 10% off of used games (Make sure to point it out to the blue shirt doing your trade-in though as it is easy for them to skip, and they are still new to it). It can take 48 hours (or more) for GCU to show up on your Reward Zone membership.

Can I use my Best Buy gift card to purchase Amazon Kindle Gift Cards or Visa Gift Cards?
Yes, although some employees may not be aware of this and incorrectly refuse to do so. Visa Gift Cards have a $200 limit and a $6 activation fee. Amazon Gift Cards are available in $25, $50 and $100 depending on your store selection. IL does not sell Amazon Gift Cards. Yes, Kindle Gift Cards are good for anything on Amazon.

The value on the site doesn't match the store, why?
Sometimes the page may not update immediately. This is fairly rare though. The store's trade-in values are definitive though, so what they say is what you get. 99.99% of the time they will match up.

The value on the iPhone/Android app is way off, why?
The app sucks for updating values (and some games simply don't show up), don't rely on it.

The game I want to trade isn't on the site, what gives?
While rare, there have been some games recently not showing up in the online estimator. You can always check in-store to see if the price is in their system and simply not online, but that is unlikely to be the case. When Best Buy doesn't have a game on file they can offer $1 as a generic SKU, but that's it. New releases appear to be added on Tuesday evenings. Many new releases are taking upwards of a week or more to be added to the site.

How come the GOTY/complete version doesn't show up in the estimator?
Best Buy doesn't differentiate between the vanilla and GOTY/complete versions of a game. This is largely a cover-all policy due to the fact that many GOTY editions include the game's DLC and bonus content as one-time use codes; meaning that the game has no extra value on the 2nd hand market. So no extra TIV for your GOTY games. The plus side is that GOTY and vanilla versions sell at the same price, so if the DLC is located on disc and you find a GOTY version in-store it will be the same price as the vanilla one.

When do trade-in values update?
No one knows for sure, but updates can and do happen at any time. Sometimes an update will happen randomly, such as when GameStop has an advertised sale for a game well below Best Buy's trade in price.

What will be the TIV of Game X tomorrow/next week / next month/ etc
Nobody knows.

If I locked in a trade online, and the value drops, will I still get the locked in value when I mail it in?
Yes. You will get the locked in TIV as long as the item is received within 14 days of you locking it in (and the item is in the condition you described it as).

Can you lock in the price online then trade it in-store?
No.

Is there a limit to how many games I can trade in?
Officially, Best Buy only accepts 3 copies of a game, per system (i.e. you could trade in 3 copies of a game for Xbox, 3 copies for PS3 and 3 for Wii). This is for sure the online policy, but it varies in stores. Some people have reported being banned for trading in more than 3 copies of games, others have done so frequently without issue. Obviously it is YMMV, but do so at your own risk.

Lately some people have been told the policy is 1 game per system (i.e. you could trade in 1 copy of a game for Xbox, 1 for PS3 and 1 for Wii), and have been actively turned down when trading in more than one copy. Whether this is actually something they are banning for or if it is just what employees are being told to follow to limit multiples is unknown. Trade multiples at your own risk.

Can I trade game disc only, or do I need the case and manuals, too?
Best Buy accepts disc only games (for the same value as complete games). The trade in will take longer though as the employee will have to look up the games individually. Yes, this also applies to DS, 3DS, PSP, etc. If you have the manual and artwork you should trade it in though anyway to improve the quality of the selection for people who may want to buy the game in the future (you can't know if the game will be complete when you buy online for example).

Can I trade in games that say "Not for Resale" on the back?
Yes, since the only thing that matters is the disc. Some employees will fight this though, and in that case, just trade the game in as disc-only. Employees have gotten much better about knowing this policy though.

Does Best Buy accept game hardware?
Currently Best Buy only accepts various versions of the Nintendo DS in store, and some stores apparently accept consoles as well. Call ahead before bringing it in. That said, the TIV for most hardware is lower than competitors.

Does the **% bonuses apply to game hardware?
No, games only.

When I do a in-store trade, I am asked: to be fingerprinted, to have my photo taken, how much I weigh, etc. What's the deal?
Pawn shop laws regulating trade-ins and resale of used goods varies from state to state or even city to city. It is not Best Buy's rule, and varies from store to store depending on where you live. At a minimum you'll need a (United States) state issued ID or passport.

I went to a store to do a trade-in and they asked for a Best Buy receipt. WTF?
Some stores are required to have receipts to accept trade-ins, again this is due to local Pawn shop laws and could vary from city to city. You can always check if the store(s) near you require a receipt on Best Buy's trade-in site.

Can I trade sealed games?
Yes. You must present your receipt for the sealed games you are trading in. It is ok if the purchase was made from another store. You do run the risk of drawing extra attention to yourself as trading in sealed products is often a sign of theft. Do not be surprised if this is questioned by an employee, or you are asked to leave, open the items and return. You might even be flat out denied by the employee or manager despite the official rule.

Remember, all trades are technically at the discretion of Best Buy and they can refuse to accept a game for whatever reason they want (outside of you being black, woman, Jewish, etc.).
 
Last edited by a moderator:
[quote name='elessar123']How often these questions are popping up greatly alarms me.[/QUOTE]



Here kids paste this in Excel in cell B1


=A1*0.5+A1+A1*0.1


Put the base value in A1


Cell B1 will display what you will get with 10% GCU and 50% bonus


You're welcome bitches.
 
I can't say I didn't see the store closings coming. Going into best buys here in the metro at times are like ghost towns, tons of blue shirts just hanging out and chatting it up like you'd see at the water cooler.

Besides that, they've been popping up stores like cockroaches in the last few years, and over saturation tends to bite you in the ass... Unless of course you're Walmart or GameStop.
 
[quote name='slowdive21']Here kids paste this in Excel in cell B1


=A1*0.5+A1+A1*0.1


Put the base value in A1


Cell B1 will display what you will get with 10% GCU and 50% bonus


You're welcome bitches.[/QUOTE]

If they can't figure out what their trade in would be with bonuses what makes you think they know what Excel formulas are? Not trying to start anything just saying.
 
[quote name='Dwarfman']If they can't figure out what their trade in would be with bonuses what makes you think they know what Excel formulas are? Not trying to start anything just saying.[/QUOTE]

They don't need to know "Why" or "How" it works. If they follow my instructions and "paste it" they should hopefully be able to let the program work for them. ;)
 
[quote name='elessar123']http://www.google.com/search?q=20*1.6=

Don't even need excel. You're welcome, bitches.[/QUOTE]

What are you going to do when they ask for the TIV for a $19 game? :booty:


(BTW: I know it is 1.6x, but I wrote my formula like that in case they actually wanted to learn how to do it. It is also not technically in the right order mathematically either.)
 
Here's an example on how to calculate the bonuses for all the mathematically challenged CAGS out there. :D

Base Value X 50% & 10% GCU Bonuses
.19 x 60 = 11.4

Base Value + Bonuses
19 + 11.4 = $30.4 Total
 
[quote name='Gamer4life88']Here's an example on how to calculate the bonuses for all the mathematically challenged CAGS out there. :D

Base Value X 50% & 10% GCU Bonuses
.19 x 60 = 11.4

Base Value + Bonuses
19 + 11.4 = $30.4 Total[/QUOTE]

Might want to check the formula again. It works, but it is not right.
 
[quote name='slowdive21']It is also not technically in the right order mathematically either.)[/QUOTE]

??? Ok, now you've lost me.

a+b*c = c*b+a. What order?
 
[quote name='elessar123']??? Ok, now you've lost me.

a+b*c = c*b+a. What order?[/QUOTE]

Decimal's in the wrong place and I think it was just luck that it worked out because the numbers are wrong also.

A. total TIV (order doesn't matter) = base value * 1.5 * 1.1

or

B. total TIV = (base value * 0.5) + (base value * 0.1) + (base value)

The poster who posted referencing Excel is using a variant of B for his calculation.

Oh quick edit. If you don't have the GCU for the extra 10% bonus, just remove 1.1 from the A formula or (base value * 0.1) from the B formula.
 
[quote name='bob330i']Decimal's in the wrong place and I think it was just luck that it worked out because the numbers are wrong also.

A. total TIV (order doesn't matter) = base value * 1.5 * 1.1

or

B. total TIV = (base value * 0.5) + (base value * 0.1) + (base value)

The poster who posted referencing Excel is using a variant of B for his calculation.[/QUOTE]

Because A is wrong =P
 
is it really that hard to just figure out what half the value is, plus move the decimal over one place for the extra 10.
19+9.5+1.9= 30.40
 
[quote name='edson13']is it really that hard to just figure out what half the value is, plus move the decimal over one place for the extra 10.
19+9.5+1.9= 30.40[/QUOTE]

apparently since it's been going on the entire page...lol

Because A is wrong =P

try it out, both formulas should calculate the same result. Anyhow, this is my last post on the calculations. If you want to continue to disagree, feel free to PM me.
 
[quote name='bob330i']try it out, both formulas should calculate the same result. Anyhow, this is my last post on the calculations. If you want to continue to disagree, feel free to PM me.[/QUOTE]

I'm not arguing. It's wrong.
 
the correct answer is

TIV + (TIV*.1) + (TIV*.X) where x is the bonus. Or simply tiv * (1.(x+1))

it is NOT TIV * (1.X)* 1.1
 
Last edited by a moderator:
Are....you guys seriously spending time creating equations to figure out basic percentage bonuses? lol

/idontwanttoliveonthisplanetanymore

Confoosious is correct, btw.

Oh, and to keep things on-topic:
:360:Mass Effect 3 is still trading in @ $40 after bonuses.
$25 base + $12.50(50% bonus) + 2.50(10% Unlocked)
 
I had a terrible trip to Best Buy today..I traded in my Wii system and 3 games...made out with 120.00.. ask the kid to price match the 3ds for 145.00...hes like dont know if we can.comes back and ask what color I want, I chose red..he rings me up and then hes like oh wait I have to call Target to see if they have red in stock..Are you kidding me..so he calls over there and they onlly have blue and black....so I have to take black..I told the cashier that I would just return the black and get a red one next week..all that for a 25.00 savings..if I didnt have credit I would of never bought it there...
 
[quote name='elessar123']lol, he fucking edited his previous equation that was "wrong".[/QUOTE]

yep. typed it wrong on my phone and went back and fixed it. god forbid.
 
[quote name='slowdive21']Here kids paste this in Excel in cell B1


=A1*0.5+A1+A1*0.1


Put the base value in A1


Cell B1 will display what you will get with 10% GCU and 50% bonus


You're welcome bitches.[/QUOTE]

Hey Bro,

This ain't excel 101. BTW, you formula sux. shorter and more efficient (=A1*1.6).

Until you can build macros with vb.net, please stop pumping your excel knowledge in CAG.
 
[quote name='confoosious']excel pissing contest on CAG. It's time to shut it down, folks. Last one out, turn out the lights.[/QUOTE]

WTH is this thread turning into. didn't know the last 2 pages were all about excel. These formula are no help to the illiterate and inexperience. (@slowdive21. still no reason to blast someone when all you know is basic excel)

lets stop this non-sense.
 
[quote name='Daring']Hey Bro,

This ain't excel 101. BTW, you formula sux. shorter and more efficient (=A1*1.6).

Until you can build macros with vb.net, please stop pumping your excel knowledge in CAG.[/QUOTE]


I was just trying to help and created a formula that was easy to understand for people who were struggling with the math...I didn't realize Pythagoras was a CAG. I even stated that it isn't as concise as it could be.


You can have your spreadsheets. I'll let a nerd like you spend your time writing code. I would prefer spending my time playing games or boning chicks like your mom, sister, or girlfriend (assuming they are not fat and ugly). But if you'd like I could have them calculate c=πd of my penis while it is in their mouth, so they learn something.

:lol:
 
Slow drive generally seems pretty cool, but that last paragraph seemed holy unnecessary. You're telling people you're going to shove your cock somewhere to solve an argument over a math problem? Really!?
 
[quote name='slowdive21']I was just trying to help and created a formula that was easy to understand for people who were struggling with the math...I didn't realize Pythagoras was a CAG. I even stated that it isn't as concise as it could be.


You can have your spreadsheets. I'll let a nerd like you spend your time writing code. I would prefer spending my time playing games or boning chicks like your mom, sister, or girlfriend (assuming they are not fat and ugly). But if you'd like I could have them calculate c=πd of my penis while it is in their mouth, so they learn something.

:lol:[/QUOTE]


we've got ourselves a badass here folks.
 
[quote name='KtMack23']Slow drive generally seems pretty cool, but that last paragraph seemed holy unnecessary. You're telling people you're going to shove your cock somewhere to solve an argument over a math problem? Really!?[/QUOTE]

"slowdive" and it was a joke. That's why there is a smiley face.


(And it should be noted he came out and attacked me. All I was trying to do was make it easier for people who needed help. Read the posts above it as I was trying to help people with a really easy and reusable way to check values.)
 
[quote name='akir']we've got ourselves a badass here folks.[/QUOTE]

Literally laughed out loud.
BRTky.jpg
 
[quote name='slowdive21']"slowdive" and it was a joke. That's why there is a smiley face.


(And it should be noted he came out and attacked me. All I was trying to do was make it easier for people who needed help. Read the posts above it as I was trying to help people with a really easy and reusable way to check values.)[/QUOTE]

dude, someone bashing your excel skillz, while stupid, hardly requires a comeback talking about shoving your cock in their mom and sister's mouths.

talk about blowing things out of proportion.
 
[quote name='slowdive21']I was just trying to help and created a formula that was easy to understand for people who were struggling with the math...I didn't realize Pythagoras was a CAG. I even stated that it isn't as concise as it could be.


You can have your spreadsheets. I'll let a nerd like you spend your time writing code. I would prefer spending my time playing games or boning chicks like your mom, sister, or girlfriend (assuming they are not fat and ugly). But if you'd like I could have them calculate c=πd of my penis while it is in their mouth, so they learn something.

:lol:[/QUOTE]

Dude, you know nothing about me. WTF, nerd?.... hahaha. More like OG with intelligence. FYI, the top Pack of the herd doesn't go down for stupid shit. Dude, if this was the 90s, you'll be very scared...

But being a family man,

its cool, you aint seen shit, keep jerking off to jenna jamerson.
 
[quote name='confoosious']dude, someone bashing your excel skillz, while stupid, hardly requires a comeback talking about shoving your cock in their mom and sister's mouths.

talk about blowing things out of proportion.[/QUOTE]

Mom or sister ;) Plus they would be the aggressors. I would just drop my pants and they would drop to their knees because I am such a badass. :whee:
 
[quote name='canvasch']so this 50% bonus.... can i get cash..... or do i have to pre-order a game... or do i have to buy something?[/QUOTE]

You will get a giftcard and no preorder is necessary. If you are an unlocked member you will get an extra 10% of the base value on your Giftcard in addition to the 50% bonus.
 
[quote name='slowdive21']I was just trying to help and created a formula that was easy to understand for people who were struggling with the math...I didn't realize Pythagoras was a CAG. I even stated that it isn't as concise as it could be.


You can have your spreadsheets. I'll let a nerd like you spend your time writing code. I would prefer spending my time playing games or boning chicks like your mom, sister, or girlfriend (assuming they are not fat and ugly). But if you'd like I could have them calculate c=πd of my penis while it is in their mouth, so they learn something.

:lol:[/QUOTE]

fuck in drunk and pissed. a 35yr old base dweller (saw previous post) to post shit like this this is effin embarrass. To say you bang my wife and mother must be a fuck in joke bro. coming from a effin nerd. hahah. wish you and i knew each other 15 yrs ago. may had cap your ass. its all good now. but watch yourself there keyboard warrior, you might trek on the wrong turf eventually.
 
I'll have to jump on this tomorrow or Saturday.

I've got some games I'm looking to unload, especially my copy of Skyrim vanilla since I got the Collector's Edition. :lol:
 
[quote name='elessar123']lol, he fucking edited his previous equation that was "wrong".[/QUOTE]

And I replied AFTER he corrected it, durrrr :roll:

*edit* Serious business here, folks.
 
[quote name='Daring']fuck in drunk and pissed. a 35yr old base dweller (saw previous post) to post shit like this this is effin embarrass. To say you bang my wife and mother must be a fuck in joke bro. coming from a effin nerd. hahah. wish you and i knew each other 15 yrs ago. may had cap your ass. its all good now. but watch yourself there keyboard warrior, you might trek on the wrong turf eventually.[/QUOTE]

For the record, I do not live in a basement and I am not 35. I feel my assistance is not appreciated, so I will refrain from correcting your English. Remember, you attacked me as I was merely trying to help people. I wasn't giving a lesson. I was doing the work for the people asking questions, so the thread would not be cluttered with the same questions over and over again. You decided to make it a personal attack.
 
[quote name='canvasch']so this 50% bonus.... can i get cash..... or do i have to pre-order a game... or do i have to buy something?[/QUOTE]

Get the fuck out of here with that question. This thread is about spreadsheets, excel formulas and insults.

No, you don't have to buy anything. They give you store credit.
 
[quote name='emeraldgsl']Get the fuck out of here with that question. This thread is about spreadsheets, excel formulas and insults.
[/QUOTE]

Wow, Sir. You are now quoted in my signature :applause:
 
[quote name='emeraldgsl']Get the fuck out of here with that question. This thread is about spreadsheets, excel formulas and insults.

No, you don't have to buy anything. They give you store credit.[/QUOTE]

Amen...
 
i purchased a used game from best buy a few weeks ago.... but lost the receipt... they now have that same used game for $10 less.... i used a CC when i bought it...
any chance i can get them to price match me the new price and give me the 10$ difference?
 
[quote name='canvasch']i purchased a used game from best buy a few weeks ago.... but lost the receipt... they now have that same used game for $10 less.... i used a CC when i bought it...
any chance i can get them to price match me the new price and give me the 10$ difference?[/QUOTE]

You can look up your receipt at CS.
 
it's great to know that basic (elementary) algebra eludes so many. makes me feel a bit better that I am not yet ready for graduate level math :).

OT:
I'm surprised ME3 is $25 whereas SFxT is $20 especially since ME3 has been cheaper and has an online pass.
 
Status
Not open for further replies.
bread's done
Back
Top