Last visit was: 26 Mar 2025, 15:07 It is currently 26 Mar 2025, 15:07
Close
GMAT Club Daily Prep
Thank you for using the timer - this advanced tool can estimate your performance and suggest more practice questions. We have subscribed you to Daily Prep Questions via email.

Customized
for You

we will pick new questions that match your level based on your Timer History

Track
Your Progress

every week, we’ll send you an estimated GMAT score based on your performance

Practice
Pays

we will pick new questions that match your level based on your Timer History
Not interested in getting valuable practice questions and articles delivered to your email? No problem, unsubscribe here.
Close
Request Expert Reply
Confirm Cancel
User avatar
bb
User avatar
Founder
Joined: 04 Dec 2002
Last visit: 26 March 2025
Posts: 40,326
Own Kudos:
78,464
 [75]
Given Kudos: 22,312
Location: United States
GMAT 1: 750 Q49 V42
GPA: 3
Products:
Expert
Expert reply
Active GMAT Club Expert! Tag them with @ followed by their username for a faster response.
GMAT 1: 750 Q49 V42
Posts: 40,326
Kudos: 78,464
 [75]
23
Kudos
Add Kudos
52
Bookmarks
Bookmark this Post
User avatar
chuy2256
Joined: 19 Sep 2016
Last visit: 07 Jan 2017
Posts: 5
Own Kudos:
Given Kudos: 1
Location: United States (GA)
Concentration: Finance, Economics
GPA: 3.5
WE:General Management (Other)
Posts: 5
Kudos: 5
Kudos
Add Kudos
Bookmarks
Bookmark this Post
User avatar
mcelroytutoring
Joined: 10 Jul 2015
Last visit: 18 Mar 2025
Posts: 1,201
Own Kudos:
2,567
 [5]
Given Kudos: 282
Status:Expert GMAT, GRE, and LSAT Tutor / Coach
Affiliations: Harvard University, A.B. with honors in Government, 2002
Location: United States (CO)
Age: 45
GMAT 1: 770 Q47 V48
GMAT 2: 730 Q44 V47
GMAT 3: 750 Q50 V42
GMAT 4: 730 Q48 V42 (Online)
GRE 1: Q168 V169
GRE 2: Q170 V170
Expert
Expert reply
GMAT 4: 730 Q48 V42 (Online)
GRE 1: Q168 V169
GRE 2: Q170 V170
Posts: 1,201
Kudos: 2,567
 [5]
3
Kudos
Add Kudos
2
Bookmarks
Bookmark this Post
User avatar
chuy2256
Joined: 19 Sep 2016
Last visit: 07 Jan 2017
Posts: 5
Own Kudos:
Given Kudos: 1
Location: United States (GA)
Concentration: Finance, Economics
GPA: 3.5
WE:General Management (Other)
Posts: 5
Kudos: 5
Kudos
Add Kudos
Bookmarks
Bookmark this Post
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?
User avatar
bb
User avatar
Founder
Joined: 04 Dec 2002
Last visit: 26 March 2025
Posts: 40,326
Own Kudos:
Given Kudos: 22,312
Location: United States
GMAT 1: 750 Q49 V42
GPA: 3
Products:
Expert
Expert reply
Active GMAT Club Expert! Tag them with @ followed by their username for a faster response.
GMAT 1: 750 Q49 V42
Posts: 40,326
Kudos: 78,464
Kudos
Add Kudos
Bookmarks
Bookmark this Post
chuy2256
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?


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.
avatar
chaitanya87
Joined: 01 Jul 2013
Last visit: 22 Sep 2020
Posts: 64
Own Kudos:
Given Kudos: 5
GMAT 1: 620 Q49 V26
GMAT 2: 590 Q49 V21
GPA: 2.8
WE:Other (Consulting)
Products:
GMAT 2: 590 Q49 V21
Posts: 64
Kudos: 53
Kudos
Add Kudos
Bookmarks
Bookmark this Post
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
User avatar
mvictor
User avatar
Board of Directors
Joined: 17 Jul 2014
Last visit: 14 Jul 2021
Posts: 2,132
Own Kudos:
Given Kudos: 236
Location: United States (IL)
Concentration: Finance, Economics
GMAT 1: 650 Q49 V30
GPA: 3.92
WE:General Management (Transportation)
Products:
GMAT 1: 650 Q49 V30
Posts: 2,132
Kudos: 1,237
Kudos
Add Kudos
Bookmarks
Bookmark this Post
one of the best resources to prepare for GMAT!
avatar
water11275
Joined: 26 Jan 2017
Last visit: 11 Apr 2018
Posts: 3
Own Kudos:
3
 [1]
Posts: 3
Kudos: 3
 [1]
1
Kudos
Add Kudos
Bookmarks
Bookmark this Post
Hey- I am still getting the 2013 versions of the questions in the error log section.
User avatar
bb
User avatar
Founder
Joined: 04 Dec 2002
Last visit: 26 March 2025
Posts: 40,326
Own Kudos:
Given Kudos: 22,312
Location: United States
GMAT 1: 750 Q49 V42
GPA: 3
Products:
Expert
Expert reply
Active GMAT Club Expert! Tag them with @ followed by their username for a faster response.
GMAT 1: 750 Q49 V42
Posts: 40,326
Kudos: 78,464
Kudos
Add Kudos
Bookmarks
Bookmark this Post
water11275
Hey- I am still getting the 2013 versions of the questions in the error log section.


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!
avatar
water11275
Joined: 26 Jan 2017
Last visit: 11 Apr 2018
Posts: 3
Own Kudos:
3
 [1]
Posts: 3
Kudos: 3
 [1]
1
Kudos
Add Kudos
Bookmarks
Bookmark this Post
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.
User avatar
ZenYogi
Joined: 03 Jan 2016
Last visit: 02 May 2022
Posts: 101
Own Kudos:
24
 [1]
Given Kudos: 59
Location: India
GMAT 1: 640 Q49 V29
GMAT 2: 760 Q51 V41
GPA: 3.2
1
Kudos
Add Kudos
Bookmarks
Bookmark this Post
Unable to update the graphs, it says it cannot open a source file?
User avatar
bb
User avatar
Founder
Joined: 04 Dec 2002
Last visit: 26 March 2025
Posts: 40,326
Own Kudos:
Given Kudos: 22,312
Location: United States
GMAT 1: 750 Q49 V42
GPA: 3
Products:
Expert
Expert reply
Active GMAT Club Expert! Tag them with @ followed by their username for a faster response.
GMAT 1: 750 Q49 V42
Posts: 40,326
Kudos: 78,464
Kudos
Add Kudos
Bookmarks
Bookmark this Post
Thank you. Updated to version 4 with the pesky file name removed. Pivot should update properly now.
avatar
water11275
Joined: 26 Jan 2017
Last visit: 11 Apr 2018
Posts: 3
Own Kudos:
3
 [1]
Posts: 3
Kudos: 3
 [1]
1
Kudos
Add Kudos
Bookmarks
Bookmark this Post
Hate to be the bearer of bad news- the pivot table still isn't updating- still getting those errors. :(
User avatar
ZenYogi
Joined: 03 Jan 2016
Last visit: 02 May 2022
Posts: 101
Own Kudos:
Given Kudos: 59
Location: India
GMAT 1: 640 Q49 V29
GMAT 2: 760 Q51 V41
GPA: 3.2
Kudos
Add Kudos
Bookmarks
Bookmark this Post
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.
avatar
ENEM
Joined: 16 Nov 2016
Last visit: 13 Jan 2020
Posts: 241
Own Kudos:
192
 [1]
Given Kudos: 379
WE:Advertising (Advertising and PR)
Products:
Posts: 241
Kudos: 192
 [1]
Kudos
Add Kudos
1
Bookmarks
Bookmark this Post
bb

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.

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




Attachment:
GMAT Club Guide to OG 2017 v4.xlsx


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.
User avatar
EliMan
Joined: 01 Jan 2017
Last visit: 29 May 2017
Posts: 26
Own Kudos:
6
 [1]
Given Kudos: 2
Posts: 26
Kudos: 6
 [1]
1
Kudos
Add Kudos
Bookmarks
Bookmark this Post
Is there a similar tool for the 2017 Quant Review and 2017 Verbal Review?
User avatar
ZenYogi
Joined: 03 Jan 2016
Last visit: 02 May 2022
Posts: 101
Own Kudos:
Given Kudos: 59
Location: India
GMAT 1: 640 Q49 V29
GMAT 2: 760 Q51 V41
GPA: 3.2
Kudos
Add Kudos
Bookmarks
Bookmark this Post
Would really appreciate it if there were an updated version with a fixed pivot table issue
User avatar
bb
User avatar
Founder
Joined: 04 Dec 2002
Last visit: 26 March 2025
Posts: 40,326
Own Kudos:
78,464
 [5]
Given Kudos: 22,312
Location: United States
GMAT 1: 750 Q49 V42
GPA: 3
Products:
Expert
Expert reply
Active GMAT Club Expert! Tag them with @ followed by their username for a faster response.
GMAT 1: 750 Q49 V42
Posts: 40,326
Kudos: 78,464
 [5]
2
Kudos
Add Kudos
3
Bookmarks
Bookmark this Post
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
Pivot Instructions.jpg [ 359.46 KiB | Viewed 19640 times ]

avatar
jleer
Joined: 13 Mar 2017
Last visit: 25 May 2017
Posts: 1
Given Kudos: 1
Posts: 1
Kudos: 0
Kudos
Add Kudos
Bookmarks
Bookmark this Post
As a non-tech savvy type, thanks!

Great resource and it works perfectly now.
avatar
vtlinhbui
Joined: 19 Jun 2017
Last visit: 27 Nov 2017
Posts: 5
Own Kudos:
Given Kudos: 32
Posts: 5
Kudos: 3
Kudos
Add Kudos
Bookmarks
Bookmark this Post
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
 1   2   
Moderator:
General GMAT Forum Moderator
288 posts