GMAT Club Guide to the GMAT Official Guide 2017ed

Question

The GMAT Club Guide to The - Official Guide - for GMAT Review 2017th Edition The Official Guide is a great resource - it has real GMAT questions, all questions are arranged in order of difficulty, good explanations, etc but it has one major flaw - no way to sample specific questions or ability to target a specific area - for example all CR questions with idioms or all DS questions that deal with geometry. This Guide attempts to correct that flaw (and a little bit more), making Official Guide even better. 2018 edition is out and available here: https://gmatclub.com/forum/guide-to-the ... l#p1882764 Use this guide to: Find details about every question available in the - Official Guide for GMAT Review Help find specific practice questions and build your custom practice tests that focus on your weak areas Understand difficulty of each question (it is not very linear as you will notice). We have split difficulty into 4 groups (easy, medium, hard, and very hard). This split is based on the percentile of the question difficulty as determined by GMAT Club Timer sessions Explanations are linked to each question for easy reference Questions are numbered using the same format as in the OG (new update in this version) The split of hard/medium/easy questions has remained the same by en large. However, the location of harder questions has been moving around quite a bit. In General the 2017 OG appears to have: Easy Questions: 320 Medium Questions: 203 Hard Questions: 79 Very Hard Questions: 66 You can find previous OG 12, 13, 14, and 15 versions here 2016 edition is available here MGMAT Navigator Basic is another/similar tool available from MGMAT https://gmatclub.com/blog/wp-content/uploads/2023/08/guide.png

chuy2256 · Answer

Oh My god....you are a LIFESAVER!!...There is a god haha. Is there a reason it will not refresh after I input my data?

mcelroytutoring · Answer

Great work as always, bb!

I have created a Google Docs version for those of you who prefer working in that medium:  GMAT Club Guide to the OG 2017 - Google Docs Version

I removed the Analysis and Error Log Tabs (too buggy on Google, and took forever to load!), changed the "Percentile" column to "% Incorrect" and added a few small modifications to the rest of the tabs:

OA = Official Answer (this column was there already, but it's worth clarifying what it means for those unfamiliar with the term)
MA = My Answer
1 = 1st re-try answer
2 = 2nd re-try answer

I also added a "Lessons Learned?" column at the end of each row (works in place of the error log) and shortened the links / narrowed the columns for cosmetic and space-saving purposes.

chuy2256 · Answer

AHA! I found the problem, The pivot table in this spreadsheet is referencing a tab belonging to an older GMAT Guide Spreadsheet, I believe it is referencing the "Error Log" for 13th edition that must be in "bb's" computer. However, I ended up just changing the reference in the Table Range for the pivot table to:

'Error Log'!$B$2:$G$670

Also the "Count of Result" Columns has a bad reference as well, this one seemed to do the trick, however it just elongated the table even more:

'Error Log'!$A$2:$G$670

...from within this spreadsheet. Correct me if i'm wrong?

bb · Answer

Thank you. I have updated the file and removed the faulty reference to the previous version of the file. I hope it works better for you. 
New version has been uploaded.

chaitanya87 · Answer

I used to do a similar method to analyse my GMAT prep tests. I have a column with the % of difficulty calculated by the gmatclub for the questions that appear in the EP 1 and 2. Great job @bb.

Sent from my SM-G935T using Tapatalk

mvictor · Answer

one of the best resources to prepare for GMAT!

water11275 · Answer

Hey- I am still getting the 2013 versions of the questions in the error log section.

bb · Answer

Thanks - I have restructured the Error Log section to start with Quant (there is no RC in the error log)
I have also added links to the questions in the error log and squished one typo in Version 3.

Thank you!

water11275 · Answer

Thank you for updating it- looks like the pivot table isn't updating though. It says the original source can't be found when I try to refresh the page.

ZenYogi · Answer

Unable to update the graphs, it says it cannot open a source file?

bb · Answer

Thank you. Updated to version 4 with the pesky file name removed. Pivot should update properly now.

water11275 · Answer

Hate to be the bearer of bad news- the pivot table still isn't updating- still getting those errors.

ZenYogi · Answer

I am not sure if it's just an issue with the edition that I have, but some questions like #43 on PS are not the same as the 2017 ed OG.

ENEM · Answer

Thank you! Is there gmatclub guide for 4th edition of quant review, ie. Quant review 2016. I looked for it everywhere but couldn't find it.

EliMan · Answer

Is there a similar tool for the 2017 Quant Review and 2017 Verbal Review?

ZenYogi · Answer

Would really appreciate it if there were an updated version with a fixed pivot table issue

bb · Answer

The Pivot Table issue is annoying frankly. I have updated the File yet again. What I think I will do is give you guys instructions how to handle it as I think there are multipiple issues going on potentially - saving it on my computer and also saving it on your computer with a diff name seems to trigger the absolute path in the Data Source.

Here is what you want to do:
1. Click on the Pivot Chat and select it
2. Go to the Analyze Tab
3. Click on Change Data Source
4. Paste or make sure this is what is selected: 'Error Log'!$A$2:$G$670

That's it. Here is a screenshot for the non-tech savvy types :-)

Attachments

Pivot Instructions.jpg [ 359.46 KiB | Viewed 20490 times ]

jleer · Answer

As a non-tech savvy type, thanks!

Great resource and it works perfectly now.

vtlinhbui · Answer

can i know where to get a pdf of OG 2017 full? i've been looking here and there in the forum but cant find

	Manhattan Prep: $99 Bonus Score Higher on Your GMAT Exam. Guaranteed.
	Target Test Prep - Save up to $599 $400 Discount + $99 Bonus GMAT Club Tests
	e-GMAT: 60% Off on GMAT Focus Get to 735+ from any starting point
	Magoosh increases your score, guaranteed - 15% off ALL Magoosh GMAT plans with code GMATCLUB15 + Free GMAT Club Tests.
	Experts' Global - ~~$1720~~ $960 End-to-End GMAT Prep + App Support: 150+ Videos, 2000+ Questions, 15 FLTs +
	GMATWhiz - $299 ~~$499~~ Experience the course through a free trial.
	GMAT Club Tests - Free Included with every course purchase of $149+ View all deals

GMAT Club Guide to the GMAT Official Guide 2017ed

Prep Toolkit

Top 5 GMAT Debrief Videos

615 to 715 in 15 Days (Ria's Strategies)

More than Quant/Verbal Abilities: Speed vs. Accuracy

745 with Only Self-Prep and GMAT Club

From 555 to 765: 210-point Improvement

Perfect 805 Score Debrief by Julia

My Rewards