Last visit was: 11 Jun 2026, 16:20 It is currently 11 Jun 2026, 16:20
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
saruba
User avatar
Current Student
Joined: 13 Jul 2009
Last visit: 27 May 2015
Posts: 115
Own Kudos:
494
 [1]
Given Kudos: 22
Location: Barcelona
Schools:SSE
Posts: 115
Kudos: 494
 [1]
1
Kudos
Add Kudos
Bookmarks
Bookmark this Post
User avatar
Spoilt
Joined: 29 Jul 2009
Last visit: 28 Jul 2015
Posts: 78
Own Kudos:
114
 [2]
Given Kudos: 15
Location: France
GPA: 3.95
WE:Information Technology (Computer Software)
Posts: 78
Kudos: 114
 [2]
1
Kudos
Add Kudos
1
Bookmarks
Bookmark this Post
User avatar
Spoilt
Joined: 29 Jul 2009
Last visit: 28 Jul 2015
Posts: 78
Own Kudos:
114
 [1]
Given Kudos: 15
Location: France
GPA: 3.95
WE:Information Technology (Computer Software)
Posts: 78
Kudos: 114
 [1]
1
Kudos
Add Kudos
Bookmarks
Bookmark this Post
User avatar
Spoilt
Joined: 29 Jul 2009
Last visit: 28 Jul 2015
Posts: 78
Own Kudos:
114
 [1]
Given Kudos: 15
Location: France
GPA: 3.95
WE:Information Technology (Computer Software)
Posts: 78
Kudos: 114
 [1]
1
Kudos
Add Kudos
Bookmarks
Bookmark this Post
Hello username123,

I have checked this problem on microsoft support web https://support.microsoft.com/kb/274222

The problem is because MAC OS doesn't support activex control.

I have removed the activex control : Use the attached version. Timer will start when you double click on
"Your Answer" and will stop when you double click on any other column.

Please feel free to ask for any improvement : I will try my best to implement it.

Mac Version:
Attachment:
GMATClub_Error_Log_V_Mac.xls [544 KiB]
Downloaded 242 times
User avatar
whiplash2411
Joined: 09 Jun 2010
Last visit: 02 Mar 2015
Posts: 1,761
Own Kudos:
3,605
 [1]
Given Kudos: 210
Status:Three Down.
Concentration: General Management, Nonprofit
Posts: 1,761
Kudos: 3,605
 [1]
1
Kudos
Add Kudos
Bookmarks
Bookmark this Post
score780
what is the "db" sheet in the error logs? database? for what? :)

Yes, it is the Database. If you want to add a source that's not there in order to include it in the drop-down menus or add some sort of mistake that you make which is not mentioned, etc you update the required column in the database. :)
avatar
yossarian84
Joined: 12 Aug 2010
Last visit: 27 Jul 2016
Posts: 41
Own Kudos:
111
 [1]
Given Kudos: 50
Concentration: Finance, Marketing
Schools:UNC Kenan-Flagler, IU Kelley, Emory GSB
WE 1: 5 yrs
Posts: 41
Kudos: 111
 [1]
1
Kudos
Add Kudos
Bookmarks
Bookmark this Post
whiplash2411
yossarian84
Umm..pardon my ignorance.

How to log the "questions" and the answer descriptions? Questions in verbal run along for pages. Their explanation consumes another chunk of space. Where do you guys log all this information? If I put it in the excel cell it doesn't look readable. It even doesnt work for questions with images.. Instead I've tried to write the description in a notepad and embed it into the spreadsheet. But even that gets very annoying.

I've logged OG11 and GMATPREP1 errors with just pointers to the questions I got wrong. But now I've forgotten the details about those questions. So every time I need to look back, I need to go to the open the book/software and check the questions again.

This seriously takes a lot of time and is very inefficient. I feel the best method is to keep handwritten logs but even that doesnt work for verbal. Cant write information that runs along for pages!

Can please someone shed some light on how to make efficient use of the error logs?



I think with error logs, the best way to use them is to put in the question number and book name and then write down why you got the answer wrong. If not, what you CAN do is, if you're doing these questions online, just make a list of questions that you got wrong by copying and pasting them in a Word file. You can review these later.

Thanks Whiplash.


After a lot of contemplation, I am doing my logging in the following manner:

For all verbal questions that I get wrong (except RC), I put all the errors and the description in a simple ms wordfile.

For quant questions that I get wrong, I make handwritten notes for each question - write down the question, my answer, where did I falter, area tested - how to solve etc. So this also acts like a disincentive to do lesser errors ;)

Thanks guys.
User avatar
AN225
Joined: 29 Sep 2010
Last visit: 01 Mar 2017
Posts: 229
Own Kudos:
306
 [1]
Given Kudos: 48
Status:Happy to join ROSS!
Concentration: General Management, Strategy
Products:
Posts: 229
Kudos: 306
 [1]
1
Kudos
Add Kudos
Bookmarks
Bookmark this Post
BB, here is the simplified version of the 'Friendly' log without fancy buttons, but with WORKING formulas.
I also added the 'date' column. The reason for this is that I want to take reports every two weeks (Pivot table will help) on how am I performing and if there are substantial changes in the performance.
Attachments

File comment: the simplified error log with WORKING formulas
GMAT errorlog.xlsm [121.42 KiB]
Downloaded 151 times

User avatar
whiplash2411
Joined: 09 Jun 2010
Last visit: 02 Mar 2015
Posts: 1,761
Own Kudos:
3,605
 [1]
Given Kudos: 210
Status:Three Down.
Concentration: General Management, Nonprofit
Posts: 1,761
Kudos: 3,605
 [1]
1
Kudos
Add Kudos
Bookmarks
Bookmark this Post
ashokkadam123
In Saruba's friendly error log, please explain with example, the various types of "Issues" such as Careless, Guess, Not sure, Tough, Knowledge Gap, Read the Q

Thank you!!

I am sorry, but what exactly is the problem here?

I think the terms are fairly self explanatory? Careless means you messed up stupidly. Guess means you guessed and either got it right or wrong - possibly wrong, if you're putting it in an error log. Not sure means you got down to like two choices, maybe and picked one. Tough means it was hard and you took too long or something. Knowledge gap means you didn't know how to attack the problem at all and Read the Q refers to you missing a crucial detail in the question and hence getting everything wrong.

And the moderators are here. We try to answer everyone's questions but you've gotta give it a bit of time. Try thinking about stuff rather than just post things immediately. Personally, I didn't really understand what your question even was.
avatar
heel289
Joined: 17 Sep 2009
Last visit: 09 Dec 2011
Posts: 8
Own Kudos:
1
 [1]
Posts: 8
Kudos: 1
 [1]
1
Kudos
Add Kudos
Bookmarks
Bookmark this Post
Here is the macro-enabled workbook format, which includes my modifications to the Awesome Error Log V 3.0 by Saruba, Spoilt, and Trianglock. The modifications include adding in the verbal time tables and graphs plus extra sheets to show verbal and quant subarea accuracy and timing. I hope the original macros stayed in tact, as I can't be sure because I am working on a mac. The macros are just bells and whistles anyway. I would say this should count as Awesome Error Log V 4.0 but I'll leave that up to the original creators to decide.
Attachments

Brad's Awesome Error Log V3 Final.xlsm [789.62 KiB]
Downloaded 158 times

User avatar
dhlee922
Joined: 05 Mar 2013
Last visit: 22 Mar 2016
Posts: 13
Own Kudos:
9
 [1]
Given Kudos: 5
Posts: 13
Kudos: 9
 [1]
1
Kudos
Add Kudos
Bookmarks
Bookmark this Post
hi,

when doing problems and using an error log, how do you time yourself? do you do a problem say in 2 minutes, then immediately after the problem do you write down whether you knew the answer or if it was a silly mistake or if you were stuck between 2 choices. or do you do say 10 problems all timed, then when checking answers go back and try to remember your thought process.

i'm just trying to get the most efficient way to use the error log and keep track of stuff, but it seems like even using the error log is very time intensive and would take away from studying.

i'd be open to anyone's thoughts or techniques on maximum efficiency for error logs

thank you
1
Kudos
Add Kudos
Bookmarks
Bookmark this Post
dhlee922
hi,

when doing problems and using an error log, how do you time yourself? do you do a problem say in 2 minutes, then immediately after the problem do you write down whether you knew the answer or if it was a silly mistake or if you were stuck between 2 choices. or do you do say 10 problems all timed, then when checking answers go back and try to remember your thought process.

i'm just trying to get the most efficient way to use the error log and keep track of stuff, but it seems like even using the error log is very time intensive and would take away from studying.

i'd be open to anyone's thoughts or techniques on maximum efficiency for error logs

thank you


Just use a stopwatch and write down your time and comments after every answer. It's not hard, but you're right it is tedious. The comments are invaluable however. Especially for answers you got right but were lucky and need to review the concept.
avatar
Eduardowbeck
Joined: 30 Jan 2013
Last visit: 21 Nov 2020
Posts: 21
Own Kudos:
12
 [1]
Given Kudos: 19
Location: Brazil
Concentration: Human Resources, General Management
GMAT 1: 710 Q48 V39
GPA: 3.69
WE:Education (Education)
GMAT 1: 710 Q48 V39
Posts: 21
Kudos: 12
 [1]
1
Kudos
Add Kudos
Bookmarks
Bookmark this Post
Quote:
how to add things to the database in the awesome error log?
I tried adding topics in quant in the DB but it is not reflecting in the drop down in the quant error log worksheet.

Kindly help.


I had the same question but I just found out:

1. Go to the db sheet (database) and in the Quant Areas column add the new topics that you want to include in the drop-down list (below the ones that are already there)

2. Go to the Quant Log sheet and select the cell that you want to add more topics to the drop-down list (you will want to select all the cells in the quant Area column)

3. With those cells selected: On the Data tab, in the Data Tools group, click Data Validation.

4.In the Data Validation dialog box, click the Settings tab.

5.In the Allow box, click List.

6.Specify the location of the list of valid entries, doing the following: click in the Source box and then select the cells that contain the quant topics in the db sheet.

7. Click OK and you're ready to go!


Let me know if it worked for you or if you have any questions.


Consider giving me Kudos if this post was helpful. :-D
User avatar
bb
User avatar
Founder
Joined: 04 Dec 2002
Last visit: 11 Jun 2026
Posts: 43,417
Own Kudos:
84,153
 [1]
Given Kudos: 24,764
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: 43,417
Kudos: 84,153
 [1]
1
Kudos
Add Kudos
Bookmarks
Bookmark this Post
aakafh
My error log isn`t displaying the graph of questions by sub topic in quant stats section(Error log by Saruba 2007). I don`t know anything about excel and was hoping if someone could help me with it.

It is a bit of an issue. The formulas got slightly messed due to copy/pasting/cutting. I am not super sure what Saruba intended to use that chart for. Once I fixed it, it is showing values that are 100% (similarly to how it looks in his original file). Any idea what that is supposed to be/show?

P.S.
You should learn Excel when you can - it is a very valuable tool in Bschool. :wink:
User avatar
GMATist1
Joined: 23 Jul 2021
Last visit: 03 Dec 2023
Posts: 34
Own Kudos:
36
 [2]
Given Kudos: 138
Location: India
Concentration: Entrepreneurship, Strategy
Schools: Rotman '25
WE:Other (Computer Software)
Schools: Rotman '25
Posts: 34
Kudos: 36
 [2]
1
Kudos
Add Kudos
1
Bookmarks
Bookmark this Post
Entering data for each question you do is tiresome and takes up a lot of time...

Thanks to GMATClub for allowing us to download our error log in excel format...
But
There's no way to delve into accuracy of sub topics ...

Here's a decent Error log (inspired by Spoilt 's GMATClub_Error_Log V3.0) that uses GMATClub Error Log's data format
It would be really helpful if someone can add charts/graphs or beautify the attached.


Thank you!

Steps to use:
1. Download your error log from GMATClub
2. Copy the data
3. Paste it in the first sheet of the attached error log
4. Change defined Range(s) by heading to Formulas > Define Name

Range Name | Range
CorrectR =GMAT_Error_Log!$F$2:$F$[Last Row Number without brackets]
DiffR =GMAT_Error_Log!$I$2:$I$[Last Row Number without brackets]
SubTypeR =GMAT_Error_Log!$K$2:$K$[Last Row Number without brackets]
TypeR =GMAT_Error_Log!$B$2:$B$[Last Row Number without brackets]
Attachments

GMATClub_Error_Log_2021_12_25 copy.xlsx [43.8 KiB]
Downloaded 91 times

User avatar
Spoilt
Joined: 29 Jul 2009
Last visit: 28 Jul 2015
Posts: 78
Own Kudos:
Given Kudos: 15
Location: France
GPA: 3.95
WE:Information Technology (Computer Software)
Posts: 78
Kudos: 114
Kudos
Add Kudos
Bookmarks
Bookmark this Post
TRIANGLOCK
Hey guys...made a couple changes / edits. First - had to change the dark red coloring and other formatting (was going for Harvard colors but I dont think it looks too good in excel). Second - needed to fix a formula. Third - created button to link to each source's performance report (before I dont think it was obvious that it was there). Fourth - created more tabs (reduced the default amount of questions from 2000 to 1000 to save space). Lastly, I made an xlsx version.

Enjoy.

[rating1]black/653347[/rating1]

Good work TRIANGLOCK.

I made a small change to this entry :
Attachment:
Trianglock_GMAT Error Log-2.1.xls [1.62 MiB]
Downloaded 227 times
User avatar
shalva
User avatar
Tuck School Moderator
Joined: 20 Aug 2009
Last visit: 17 Aug 2011
Posts: 202
Own Kudos:
Given Kudos: 69
Location: Tbilisi, Georgia
Schools:Stanford (in), Tuck (WL), Wharton (ding), Cornell (in)
Posts: 202
Kudos: 347
Kudos
Add Kudos
Bookmarks
Bookmark this Post
Thank you guys!

I liked both Saruba's and TRIANGLOCK's work, though preferred Saruba's one. They both deserve access to GMAT Club Challenges at least

Saruba
You're having D-Day today, aren't you?! :?:

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

PS I've just seen Spoilt's version too. It's very very good. All of these 3 users have made great contributions to site.
User avatar
Spoilt
Joined: 29 Jul 2009
Last visit: 28 Jul 2015
Posts: 78
Own Kudos:
Given Kudos: 15
Location: France
GPA: 3.95
WE:Information Technology (Computer Software)
Posts: 78
Kudos: 114
Kudos
Add Kudos
Bookmarks
Bookmark this Post
shalva
Thank you guys!

I liked both Saruba's and TRIANGLOCK's work, though preferred Saruba's one. They both deserve access to GMAT Club Challenges at least

Saruba
You're having D-Day today, aren't you?! :?:

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

PS I've just seen Spoilt's version too. It's very very good. All of these 3 users have made great contributions to site.

True , TRIANGLOCK did good job for me.

I would like to quote Saruba's work is incomplete - It's just a template and don't have any fuctional value at the end of competition.

After competition is over - anyone not only me , TRIANGLOCK but any GMATcluber can update and produce better version but that will not be a fair competition - Log must be functional at the end of competition.

But I really appreciate Saruba's work - Though useless for the fair competition. (But Saruba deserves access to GMAT Club Challenges at least)
User avatar
saruba
User avatar
Current Student
Joined: 13 Jul 2009
Last visit: 27 May 2015
Posts: 115
Own Kudos:
Given Kudos: 22
Location: Barcelona
Schools:SSE
Posts: 115
Kudos: 494
Kudos
Add Kudos
Bookmarks
Bookmark this Post
Spoilt

True , TRIANGLOCK did good job for me.

I would like to quote Saruba's work is incomplete - It's just a template and don't have any fuctional value at the end of competition.

But I really appreciate Saruba's work - Though useless for the fair competition. (But Saruba deserves access to GMAT Club Challenges at least)
"Error log is one of the most essential and important tools in GMAT prep. Do you use one? Have a good template? Have good ideas to create one? You may be in for some money"

Yes I use one. Yes I have one. Yes I do have some ideas. I can't see where he says that in order to participate in the contest the error log must have a functional value. By the way, what do you mean with functional value? A 'Clear log' button? How on earth will I want to erase all the entries that took me hours to introduce? A "Planner"? There are thousands of applications far better than that. Auto-increment? This is what I call useless.
A 'Hit Rate' bar graph just aside the table that shows the same information? The mess of having Quant and Verbal questions mixed together? Is this your concept of funcionality? Sorry, I don't agree with you.

Don't get me wrong, but what i think is really unfair is that you decide who is out of the competition.
My error log is usable as is, all I said is that for folks who like it and will be using it, I would improve it, AS A FAVOR, following their suggestions.

The value of my error log is its simple, clear, well-structured and user-friendly interface. If you don't value these aspects it's fine for me, but is the jury who will decide about these matters, not you.

As a bottomline, I had access to GMAT Club Tests thanks to other contributions I made to this community so I didn't participate for that and neither for the money (I have a job). I made this because I'd have never achieved a score of 700 without GMAT Club Tests and its support forums, so I feel in debt with this community.

Thanks for those who asked about my D-day, as I wrote above I got a 700. Will write a detailed debrief soon.

@HopefulOldie I protected it for the contest, I will soon publish it free but for now you can unlock it with the password '8887'.
User avatar
Spoilt
Joined: 29 Jul 2009
Last visit: 28 Jul 2015
Posts: 78
Own Kudos:
Given Kudos: 15
Location: France
GPA: 3.95
WE:Information Technology (Computer Software)
Posts: 78
Kudos: 114
Kudos
Add Kudos
Bookmarks
Bookmark this Post
Dear all,

I made changes to Error to include GMATClub Logo. Changed Name to GMATCLub Error Log V1. Everyone can change it to contribute !!!

Clear log button can be removed later - It is just to clear the already present sample values.

BB Please don't consider it my entry for Competition.
Attachment:
GMATClub_Error_Log_V_1.xls [845 KiB]
Downloaded 316 times

Office 2007:
Attachment:
GMATClub_Error_Log_V_1.xlsm [486.51 KiB]
Downloaded 269 times
User avatar
Spoilt
Joined: 29 Jul 2009
Last visit: 28 Jul 2015
Posts: 78
Own Kudos:
Given Kudos: 15
Location: France
GPA: 3.95
WE:Information Technology (Computer Software)
Posts: 78
Kudos: 114
Kudos
Add Kudos
Bookmarks
Bookmark this Post
TRIANGLOCK
BB - Any good news for us yet? Understand the work thing though.

In the spirit of collaboration now that the competition deadline has passed, I put together something which in my opinion takes some of the best features from each competitors log and aggregates it all into 1.

I have completed roughly half of it (only the quant side) and wanted to see what people thought before proceeding to code the verbal side as well.

Summary of New Error Log


1. I usually pride myself on being the best at making documents look pretty (former IBanker mentality) but Saruba by far had the best interface in my opinion. Great design and usability for the average person. So I grabbed a little bit of that.
2. Organizing the logs into quant/verbal made some sense to me. Mostly I liked how you had 2 logs and 2 corresponding reports. Another Saruba contribution that I borrowed.
3. Even though Spoilts Planner got bashed in a previous reply - I actually liked that feature. I know sometimes I like to set goals for myself as it pertains to the GMAT (i.e. how many questions per day, how long studying, when I take practice tests) and it helps to have it all rolled up into your error log.
4. The db I borrowed a bit from everyone.
5. I liked my highlighting tool. Helps me to quickly see the questions I need to review and spend more time on based on different criteria.

There are probably others to see but I'll leave a bit of mystery so you download it.

PS - 1 Hint. There is a lot of coding that can slow it down so i suggest turning your calcs to manual so it doesnt hinder your data entry and just press f9 whenever you need to calculate.

Good . I have some suggestions : Sorry I dont have enough time to update.

1. Performace is too slow, it is because we are using some calculations that can be done in a better and efficient way.
2. For validation(drop down list) we are using db sheet reference - that is very inefficient method: Suggestion (make the range in the db with name - check Spoilt Error log "Lists" sheet ) add list validation '=<RangeName>' e.g. '=OA'.
3. use alternate colour for combination of cells.
Attachment:
Awesome Error Log.xls [1.24 MiB]
Downloaded 268 times

Attachments

Range.PNG
Range.PNG [ 59.6 KiB | Viewed 98873 times ]

   1   2   3   4   5   
Moderators:
226 posts
General GMAT Forum Moderator
474 posts