GMAT Question of the Day: Daily via email | Daily via Instagram New to GMAT Club? Watch this Video

It is currently 23 Feb 2020, 00:33

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

GMAT Error Log

  new topic post reply Question banks Downloads My Bookmarks Reviews Important topics  
Author Message
Founder
Founder
User avatar
V
Joined: 04 Dec 2002
Posts: 19028
Location: United States (WA)
GMAT 1: 750 Q49 V42
GPA: 3.5
GMAT ToolKit User CAT Tests
GMAT Error Log  [#permalink]

Show Tags

New post Updated on: 31 Aug 2011, 21:10
101
210
The Competition is finished. Here's a list of Error Logs of all times :).

How to use & Purpose

The purpose of an error log is to keep track of your mistakes. You can use one of these fancy spreadsheets, you can use your own doc, GMAT ToolKit, or you can just mark the questions you got wrong in your book. The goal is the same - to build a list of questions that are problematic for you. Usually, you would exclude anything that you have missed by pure careless error (for example, confused answer choices) but you do want to have here all other questions you missed. Why? Because these questions are what you want to review at the end of the week and perhaps every month. You also want to save them for the last week (especially the ones that you missed twice).

If one of these spreadsheets is too fancy for you, just get your own error log/timer/etc - the key is to keep track of your weaknesses and mistakes and then to attack them. No spreadsheet can do the studying for you though.

Error Logs


  1. Error Logs by Saruba
  2. Error Logs by Saruba+Spoilt+Trianglock
  3. Error Logs by Spoilt
  4. Error Logs by Trianglock




There is also a built-in Error log in the GMAT Club Forum
No downloading, No manual work - it tracks your progress automatically when you solve questions on this forum and gives you the results. Learn more about the Forum Timer






Existing Error logs and resources you may want to use to create/revise your error log:
new-gmat-practice-grid-11448.html
all-about-the-error-log-11754.html
gmat-club-guide-to-the-gmat-official-guide-12th-ed-85956.html
error-log-template-online-68055.html
standardizing-error-taxonomy-template-added-84791.html
error-log-tool-8717.html
gmat-timer-56014.html




Spoiler: :: Old files
Attachment:
Awesome Error Log_V2.xls [1.28 MiB]
Downloaded 3639 times
To download please login or register as a user

Attachment:
Awesome Error Log_V2.xlsm [379.93 KiB]
Downloaded 2093 times
To download please login or register as a user

Attachment:
Awesome_Error_Log_V2.1.xlsm [378.89 KiB]
Downloaded 32756 times
To download please login or register as a user

Attachment:
Awesome_Error_Log_V2.1.xls [1.25 MiB]
Downloaded 3959 times
To download please login or register as a user

Attachment:
GMATClub_Error_Log_V3.0.xlsm [303 KiB]
Downloaded 15526 times
To download please login or register as a user

Attachment:
GMATClub_Error_Log_V3.0.xls [569.5 KiB]
Downloaded 3141 times
To download please login or register as a user

Attachment:
friendly_error_log_v2_by_saruba.xlsm [152.41 KiB]
Downloaded 59802 times
To download please login or register as a user

Attachment:
friendly_error_log_v2_by_saruba.xls [366.5 KiB]
Downloaded 9897 times
To download please login or register as a user

Attachment:
Awesome Error Log_V2.xlsm [379.93 KiB]
Downloaded 2093 times
To download please login or register as a user

Attachment:
Awesome Error Log_V2.xls [1.28 MiB]
Downloaded 3639 times
To download please login or register as a user

Attachment:
Trianglock_GMAT Error Log-2.xlsx [814.57 KiB]
Downloaded 14733 times
To download please login or register as a user

Attachment:
Trianglock_GMAT Error Log-2.1.xls [1.62 MiB]
Downloaded 2963 times
To download please login or register as a user


_________________

Originally posted by bb on 02 Nov 2009, 17:26.
Last edited by bb on 31 Aug 2011, 21:10, edited 12 times in total.
minor bug in Awesome Error Log fixed (V2.1)
Current Student
avatar
Joined: 13 Jul 2009
Posts: 133
Location: Barcelona
Schools: SSE
Re: Competition for the Best GMAT Error Log Template  [#permalink]

Show Tags

New post 17 Nov 2009, 09:10
22
2
Here is my contribution to this cool contest.

I focused on building a user-friendly and simple to use application , rather than cracking hundreds of functions. Honestly, an error log won't make you any better by itself, it only will tell you in which areas you must work harder and in which areas you are rocking the house. And that's what my proposal does, no more no less.

I used similar colors to those of GMAT Club in order to help people feel comfortable using it while they spend the hours cracking questions through the forums.

Finally, my gmat exam is TOMORROW(!) so I hadn't plenty of time to do this. It's not an excuse for the contest, rather a promise that I will make it better afterwards. Some areas that can get improved are:
1) More thorough database
2) CAT-Specific sections
3) Decent help section
4) You decide it!

When the contest ended I'll open a new ""official"" threat for those who will be using it and want to implement some improvements.

So that's it:

Friendly Error Log v1 by Saruba
Attachment:
friendly_error_log_v1_by_saruba.xlsx [134.76 KiB]
Downloaded 1173 times
To download please login or register as a user


Attachment:
friendly_error_log_v1_by_saruba.xls [305.5 KiB]
Downloaded 728 times
To download please login or register as a user


*Several warnings prompted up when saving the 2003 version, I'm not sure if it'll work fine!

_________________
Manager
Manager
avatar
Joined: 29 Jul 2009
Posts: 84
Location: France
GPA: 3.95
WE: Information Technology (Computer Software)
Re: Competition for the Best GMAT Error Log Template  [#permalink]

Show Tags

New post 17 Nov 2009, 01:12
10
Updated version: 0.0.6

Improved performance. It's much faster now. More to come :) (I hope).

Rate: Rate:

Attachment:
Spoilt_Error_Log_V_0.0.6.xls [733 KiB]
Downloaded 577 times
To download please login or register as a user


Office 2007:
Attachment:
Spoilt_Error_Log_V_0.0.6.xlsm [240.01 KiB]
Downloaded 457 times
To download please login or register as a user


_________________
Intern
Intern
avatar
Joined: 02 Sep 2009
Posts: 5
Re: Competition for the Best GMAT Error Log Template  [#permalink]

Show Tags

New post 16 Nov 2009, 20:04
9
2
Here is my entry.


I created this Error Log to help in my own GMAT studying and the tools in it were features which were very helpful to me. I tried to keep it as simple as possible and to minimize the amount of inputs for the user but also provide maximum utility. I knowingly did not add functionality to analyze specific types of problems (algebra, arithmetic, percents, strengthen argument, etc) as I found the data entry needed to analyze the results was too time consuming. I felt that time could be better utilized elsewhere - like doing more problems. I also did not add any fancy macros as it has been my experience that sometimes those things can crash your program depending on your computer.

Instead I focused on creating something where you could quickly find the problems you should revisit based on a few criteria: 1) Accuracy; 2) Speed; and 3) Comfort Level with each answer. These were critical things to me as I obviously wanted to review problems I got wrong but I also wanted to review problems that took me too long to solve or questions where I might have just gotten lucky by guessing.

I hope many/someone out there find(s) it useful. If there are enough requests and it is easy enough I will try to provide a copy for Apple users (I own an Apple but I use the Windows side of it for all MS Office stuff - dont like the Apple versions of Excel or Word). The file is open for all to see the coding.
Attachments

Trianglock_GMAT Error Log.xls [1.87 MiB]
Downloaded 1066 times

To download please login or register as a user

Manager
Manager
avatar
Joined: 29 Jul 2009
Posts: 84
Location: France
GPA: 3.95
WE: Information Technology (Computer Software)
Re: Competition for the Best GMAT Error Log Template  [#permalink]

Show Tags

New post 05 Nov 2009, 23:30
8
bb wrote:
Thanks.

By the way, I did a save as and was able to save it as 300kb file instead of 1MB - Office 2007 version though.



Thanks bb,

New Version of Error Log attached : I have protected source code of this excel till 17th Nov '09. I will provide final version with source code by 17th Nov '09.

I am unable to attach Office 2007 format file.
Attachments

Spoilt_Error_Log_V_0.0.3.xls [1.32 MiB]
Downloaded 1985 times

To download please login or register as a user


_________________
Manager
Manager
avatar
B
Joined: 31 Oct 2011
Posts: 50
Location: India
GMAT 1: 660 Q48 V32
GPA: 3.56
WE: Programming (Computer Software)
Reviews Badge
GMAT Error Log  [#permalink]

Show Tags

New post 26 Sep 2015, 02:09
7
2
Attaching an error log that I made on Google Spreadsheet. With me using different machines at different places (work, home etc.), I thought a Google Doc will help me keep track of all of it in one single place. So, here it is : http://bit.ly/ErrorLog

It's a Google Spreadsheet with View only permission. Please login with your Google accounts and select the option make a copy to have your own copy in Google Drive. The one that I am sharing is not editable.

Quick notes:

1. Use the "Quant Error Log" and "Verbal Error Log" sheets to enter quant and verbal error data. Since these are questions that you got wrong, your answer / OA doesn't make a lot of sense. However, if you think you should have it, feel free to add them.

2. Fields Topic, Difficulty, Reason for failure and Remarks are indexed. ie., if you want to add a new value to it other than what shows up in the combo box, add it in the appropriate column in the sheet "Master Table". I have indexed remarks because often we label questions with standard tags, such as stumped, too long, attempt retry etc. Having an indexed field for the same will make it handy for analytics / filters. For other remarks you can always use remarks 2.

3. Use the Quant insights and verbal insights sheets for quant and verbal dashboard. They show the following:
  • Top reasons for failure
  • Weak topics : Top topics on which you commit mistakes. Will help you understand where you must focus
  • Errors over days : Plots errors made day wise. This may not be an accurate metric if you don't practice uniform number of problems over time, but might help.
  • Errors by difficulty : Share of errors graded by question difficulty. May not be useful if you're adding questions from sources other than gmatclub here.
  • Errors by problem type : Whether you must focus on SC/CR/RC/PS/DS.

4. There is an optional accuracy sheet that you could use. This will require the aggregate of number of problems that you solved each day in quant and verbal. Given this input, and the error data that we already have, the sheet will graph you your daily accuracy rate in Quant and Verbal. Ideally, this should be a positive slope line :-)

You could go one level further and get question details by topic for correct answers as well. But then, I realized that once the task of entering data into error log becomes cumbersome, you stop using it. So, wanted to keep the data entry part as minimal as possible. Even the accuracy part is completely up to individual's preference. But personally, I feel happy realizing that I've solved this many problems today, at the end of the day so thought I might as well keep track of it.

Please try this and let me know your feedback, especially issues.

and yea, press kudos if you liked it! Thanks :-D
Founder
Founder
User avatar
V
Joined: 04 Dec 2002
Posts: 19028
Location: United States (WA)
GMAT 1: 750 Q49 V42
GPA: 3.5
GMAT ToolKit User CAT Tests
Re: Competition for the Best GMAT Error Log Template  [#permalink]

Show Tags

New post 04 Nov 2009, 12:47
6
Thanks.

By the way, I did a save as and was able to save it as 300kb file instead of 1MB - Office 2007 version though.
_________________
Manager
Manager
avatar
Joined: 29 Jul 2009
Posts: 84
Location: France
GPA: 3.95
WE: Information Technology (Computer Software)
Re: Competition for the Best GMAT Error Log Template  [#permalink]

Show Tags

New post 15 Nov 2009, 21:52
5
1
Updated version: 0.0.5

Added much needed button to clear log.
Rate:

Attachment:
Spoilt_Error_Log_V_0.0.5.xls [1.34 MiB]
Downloaded 423 times
To download please login or register as a user


Office 2007 file:
Attachment:
Spoilt_Error_Log_V_0.0.5.xlsm [420.78 KiB]
Downloaded 356 times
To download please login or register as a user


_________________
Retired Moderator
avatar
B
Status: Accepting donations for the mohater MBA debt repayment fund
Joined: 05 Feb 2008
Posts: 1833
Location: United States (CA)
Concentration: Operations, Finance
Schools: Ross '14 (M)
GMAT 2: 710 Q48 V38
GPA: 3.54
WE: Accounting (Manufacturing)
GMAT ToolKit User Reviews Badge
Re: Competition for the Best GMAT Error Log Template  [#permalink]

Show Tags

New post 17 Nov 2009, 06:51
5
1
The error log I used for my prep.

Final version, it has gone through all the necessary QA.

Attachment:
File comment: error log
error log.pdf [24.49 KiB]
Downloaded 1142 times
To download please login or register as a user




_________________
Strategy Discussion Thread | Strategy Master | GMAT Debrief| Please discuss strategies in discussion thread. Master thread will be updated accordingly. | GC Member Write Ups

GMAT Club Premium Membership - big benefits and savings
Manager
Manager
avatar
Joined: 29 Jul 2009
Posts: 84
Location: France
GPA: 3.95
WE: Information Technology (Computer Software)
Re: Competition for the Best GMAT Error Log Template  [#permalink]

Show Tags

New post Updated on: 03 Mar 2010, 00:44
5
Dear All,

Updated version of Awesome Error Log (V3.0):

Changes
Added Timer Functionality

To use Timer : Double click on cell "START TIMER" and log your answers.

bb: Can you please update those on first page? Thanks in advance.

Attachment:
Awesome Error Log_V3(Timer) .xls [1.3 MiB]
Downloaded 422 times
To download please login or register as a user



Office 2007:
Attachment:
Awesome Error Log_V3(Timer) .xlsm [391.94 KiB]
Downloaded 296 times
To download please login or register as a user




Edit: Removed attachements to correct bug

Edit: Attached corrected files

_________________

Originally posted by Spoilt on 02 Mar 2010, 22:35.
Last edited by Spoilt on 03 Mar 2010, 00:44, edited 3 times in total.
Intern
Intern
avatar
Joined: 02 Sep 2009
Posts: 5
Re: Competition for the Best GMAT Error Log Template  [#permalink]

Show Tags

New post 17 Nov 2009, 12:18
4
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.


Attachments

Trianglock_GMAT Error Log-2.xls [1.59 MiB]
Downloaded 201 times

To download please login or register as a user

Trianglock_GMAT Error Log-2.xlsx [814.57 KiB]
Downloaded 116 times

To download please login or register as a user

Founder
Founder
User avatar
V
Joined: 04 Dec 2002
Posts: 19028
Location: United States (WA)
GMAT 1: 750 Q49 V42
GPA: 3.5
GMAT ToolKit User CAT Tests
Re: Competition for the Best GMAT Error Log Template  [#permalink]

Show Tags

New post 06 Nov 2009, 06:16
3
My bad - I added xlsm extension to the allowable list.
_________________
Manager
Manager
avatar
Joined: 29 Jul 2009
Posts: 84
Location: France
GPA: 3.95
WE: Information Technology (Computer Software)
Re: Competition for the Best GMAT Error Log Template  [#permalink]

Show Tags

New post 13 Nov 2009, 01:18
3
Sorry guys a bit busy :(

Attached new version 0.0.4

I would really like to receive suggestions from you. Please do not hesitate to send me PM, if you have some suggestion.

Rate:

Attachment:
Spoilt_Error_Log_V_0.0.4.xls [1.34 MiB]
Downloaded 1406 times
To download please login or register as a user


Office 2007 file:
Attachment:
Spoilt_Error_Log_V_0.0.4.xlsm [412.83 KiB]
Downloaded 515 times
To download please login or register as a user


_________________
Manager
Manager
avatar
Joined: 29 Jul 2009
Posts: 84
Location: France
GPA: 3.95
WE: Information Technology (Computer Software)
Re: Competition for the Best GMAT Error Log Template  [#permalink]

Show Tags

New post 17 Nov 2009, 19:09
2
Version with source code:

Attachment:
Spoilt_Error_Log_V_0.0.7.xls [664.5 KiB]
Downloaded 93 times
To download please login or register as a user


Office 2007:
Attachment:
Spoilt_Error_Log_V_0.0.7.xlsm [314.25 KiB]
Downloaded 90 times
To download please login or register as a user


_________________
Intern
Intern
avatar
Joined: 02 Sep 2009
Posts: 5
Re: Competition for the Best GMAT Error Log Template  [#permalink]

Show Tags

New post 19 Nov 2009, 11:58
2
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.
Attachments

Awesome Error Log.xls [1.24 MiB]
Downloaded 142 times

To download please login or register as a user

Awesome Error Log.xlsm [373.76 KiB]
Downloaded 89 times

To download please login or register as a user

Manager
Manager
avatar
Joined: 29 Jul 2009
Posts: 84
Location: France
GPA: 3.95
WE: Information Technology (Computer Software)
Re: Competition for the Best GMAT Error Log Template  [#permalink]

Show Tags

New post 02 Feb 2010, 03:29
2
Hello GMATClub members and Jasonlu1981,

I have updated the Error Log V0.0.8.

Changes:
1. Timer functionality changed.

To Start the timer, Press START button and go on selecting 'Your Answer', Time will be automatically logged. Try it!!!

I will update the GMATClub_Error_Log_V2.0.xls tomorrow.

Please don't hesitate if you need more help.

Attachment:
Spoilt_Error_Log_V_0.0.9.xls [786.5 KiB]
Downloaded 268 times
To download please login or register as a user



2007:
Attachment:
Spoilt_Error_Log_V_0.0.9.xlsm [426.49 KiB]
Downloaded 160 times
To download please login or register as a user


_________________
Manager
Manager
avatar
Joined: 29 Jul 2009
Posts: 84
Location: France
GPA: 3.95
WE: Information Technology (Computer Software)
Re: Competition for the Best GMAT Error Log Template  [#permalink]

Show Tags

New post 09 Dec 2009, 21:28
1
Hello lav,

As I promised - attached is the updated version of the Awesome Log.
Could you please explain in breif regarding google doc query?

Attachment:
Awesome Error Log_V2.xls [1.28 MiB]
Downloaded 147 times
To download please login or register as a user



Office 2007:
Attachment:
Awesome Error Log_V2.xlsm [379.93 KiB]
Downloaded 98 times
To download please login or register as a user



BB can you please put those at the first page.
_________________
Manager
Manager
avatar
Joined: 29 Jul 2009
Posts: 84
Location: France
GPA: 3.95
WE: Information Technology (Computer Software)
Re: Competition for the Best GMAT Error Log Template  [#permalink]

Show Tags

New post 23 Dec 2009, 02:25
1
bb wrote:
Thanks. Will do. Do you mind sharing what the changes/improvements were?


Hello bb,

Changes:

1. Serial number is auto-increment.
2. Corrected all the missing dropdown in Verbal and Quant Log sheet.
3. Corrected all the formula to calculate the %correct by area - e.g. in previous version if you solve 5 question of arithmetic and even if miss all question the report was showing arithmetic : 100%.
4. Added dropdown for Sub-area to Quant Log
5. Added Sub-area to DB, Added some blank column range for user to fill new values in dropdown.
6. Added Report and graph for Sub-Area to Quant Stats.
7. Included 'updated by Spoilt' comment :)
_________________
Manager
Manager
avatar
Joined: 29 Jul 2009
Posts: 84
Location: France
GPA: 3.95
WE: Information Technology (Computer Software)
Re: Competition for the Best GMAT Error Log Template  [#permalink]

Show Tags

New post 05 Jan 2010, 03:12
1
Hello Jasonlu1981 and GMATClub members,

I have updated the Spoilt Error Log V0.0.7 with timer functionality.
"TestGrid4GMAT_latest_version.xls" code was very complex and inefficient. I have used better, simple and efficient code.

To start timer you have to double click the 'Your Answer' Cell, select value and double click on 'OA' cell timer to stop. I can only attach 2 files in one post, so I have included snapshot in help page of the attached sheet. Try it !!!

Please don't hesitate if you need more help.

Changes:
1. Timer functionality included.
2. Updated Clear Log button. (button will be automatically deleted)

Attachment:
Spoilt_Error_Log_V_0.0.8.xls [780.5 KiB]
Downloaded 370 times
To download please login or register as a user



Office 2007:
Attachment:
Spoilt_Error_Log_V_0.0.8.xlsm [418.18 KiB]
Downloaded 176 times
To download please login or register as a user


_________________
Manager
Manager
avatar
Joined: 10 Aug 2009
Posts: 98
Re: Competition for the Best GMAT Error Log Template  [#permalink]

Show Tags

New post 27 Jan 2010, 05:11
1
Hi,

Great work guys! I'm just starting to study for my GMAT and decided to use the first error log (friendly error log by Saruba). I have a couple of (stupid) questions:
- What is OA? Is that the correct answer?
- How do I actually use it? Each question that I get wrong I enter into the log and then review the appropriate areas in the last 2 weeks? There is no field for page number or w/e, so how do I record that?

Thanks!
GMAT Club Bot
Re: Competition for the Best GMAT Error Log Template   [#permalink] 27 Jan 2010, 05:11

Go to page    1   2   3   4   5    Next  [ 87 posts ] 

Display posts from previous: Sort by

GMAT Error Log

  new topic post reply Question banks Downloads My Bookmarks Reviews Important topics  

Moderator: DisciplinedPrep






Powered by phpBB © phpBB Group | Emoji artwork provided by EmojiOne