|
Author |
Message |
|
Intern
Joined: 16 Mar 2009
Posts: 28
Followers: 0
Kudos [?]:
1
[0], given: 0
|
Re: Competition for the Best GMAT Error Log Template [#permalink]
09 Dec 2009, 00:38
thanks for the reply looking fwd to get my hands on the completed xls file
I was looking forward for a way to include the "question" That i tried in the excel file ... as no way to do in excel i tried using the google doc in the following way ...
I found a bug ... may be Excel bug or google doc ... I try to maintain a online google doc of all the WRONG ques .. in the excel file when i insert a hyperlink like "http://docs.google.com/Doc?docid=0ZGQ3MzNoem5f4Y3NyN2hqZng&hl=en#Ques_3" then ideally on clicking this link i should see the ques but i see the index in browser ... BUT the URL in the browser doesnt include the #Ques_3 is sth like "http://docs.google.com/Doc?docid=0ZGQ3MzNoem5f4Y3NyN2hqZng&hl=en"
It seems like a bug in MS excel ... not sure ... may be others can try similar thing and confirm
let me knwo if i need to explain more
|
|
|
|
|
|
|
Manager
Joined: 08 Jul 2009
Posts: 177
Followers: 0
Kudos [?]:
11
[0], given: 26
|
Re: Competition for the Best GMAT Error Log Template [#permalink]
09 Dec 2009, 14:41
Thanks for the making the logs, I am going to use the Awesome Error Log!
|
|
|
|
|
|
Manager
Joined: 29 Jul 2009
Posts: 120
Followers: 4
Kudos [?]:
63
[1] , given: 14
|
Re: Competition for the Best GMAT Error Log Template [#permalink]
09 Dec 2009, 22:28
1
This post received KUDOS
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 100 times
Office 2007: Attachment:
Awesome Error Log_V2.xlsm [379.93 KiB]
Downloaded 63 times
BB can you please put those at the first page.
_________________
GMAT Club Error Log V3.0 - with Timer GMAT Club Error Log Spoilt Error Log V0.0.9 - with Timer Awesome Error Log - By Spoilt and Trianglock
|
|
|
|
|
|
Manager
Joined: 29 Jul 2009
Posts: 120
Followers: 4
Kudos [?]:
63
[0], given: 14
|
Re: Competition for the Best GMAT Error Log Template [#permalink]
09 Dec 2009, 23:26
lav wrote: thanks for the reply looking fwd to get my hands on the completed xls file
I was looking forward for a way to include the "question" That i tried in the excel file ... as no way to do in excel i tried using the google doc in the following way ...
I found a bug ... may be Excel bug or google doc ... I try to maintain a online google doc of all the WRONG ques .. in the excel file when i insert a hyperlink like "http://docs.google.com/Doc?docid=0ZGQ3MzNoem5f4Y3NyN2hqZng&hl=en#Ques_3" then ideally on clicking this link i should see the ques but i see the index in browser ... BUT the URL in the browser doesnt include the #Ques_3 is sth like "http://docs.google.com/Doc?docid=0ZGQ3MzNoem5f4Y3NyN2hqZng&hl=en"
It seems like a bug in MS excel ... not sure ... may be others can try similar thing and confirm
let me knwo if i need to explain more Oh , now I got your point: I tested the link you sent me. I tried the one below (#p660667): I copied it in excel and it's working fine. So it's not the problem of excel. competition-for-the-best-gmat-error-log-template-86232-60.html#p660667I think it's problem with your link,
_________________
GMAT Club Error Log V3.0 - with Timer GMAT Club Error Log Spoilt Error Log V0.0.9 - with Timer Awesome Error Log - By Spoilt and Trianglock
|
|
|
|
|
|
Manager
Joined: 24 Jul 2009
Posts: 197
Location: Anchorage, AK
Schools: Mellon, USC, MIT, UCLA, NSCU
Followers: 4
Kudos [?]:
17
[0], given: 10
|
Re: Competition for the Best GMAT Error Log Template [#permalink]
19 Dec 2009, 23:21
shalva wrote: Wow, sarubas work is really impressive, but I'm definitely going to check others out too I agree. Highly impressed. Just might use it for the rest of prep.
_________________
Reward wisdom with kudos.
|
|
|
|
|
|
Manager
Joined: 02 Oct 2009
Posts: 198
Followers: 1
Kudos [?]:
13
[0], given: 4
|
Re: Competition for the Best GMAT Error Log Template [#permalink]
20 Dec 2009, 22:55
Kudos folks,
Hard to accept that this site is actually free... what quality and dedication...! Awesome creativity with Excel!
DC
|
|
|
|
|
|
Manager
Joined: 29 Jul 2009
Posts: 120
Followers: 4
Kudos [?]:
63
[1] , given: 14
|
Re: Competition for the Best GMAT Error Log Template [#permalink]
21 Dec 2009, 02:06
1
This post received KUDOS
DestinyChild wrote: Kudos folks,
Hard to accept that this site is actually free... what quality and dedication...! Awesome creativity with Excel!
DC Thanks for your comments, I hope I will continue to help GMATclub members in future, lack of time doesn't allow to do many things at the same time. Thanks again.
_________________
GMAT Club Error Log V3.0 - with Timer GMAT Club Error Log Spoilt Error Log V0.0.9 - with Timer Awesome Error Log - By Spoilt and Trianglock
|
|
|
|
|
|
Manager
Joined: 24 Jul 2009
Posts: 197
Location: Anchorage, AK
Schools: Mellon, USC, MIT, UCLA, NSCU
Followers: 4
Kudos [?]:
17
[0], given: 10
|
Re: Competition for the Best GMAT Error Log Template [#permalink]
21 Dec 2009, 20:33
Seriously, the error log forum is great. People often think that practice makes perfect. However, as an athlete, I was taught that perfect practice makes perfect and I definitely see the relevance/applicability to my GMAT prep. The error log is a tool for helping you achieve perfect practice.
_________________
Reward wisdom with kudos.
|
|
|
|
|
|
Manager
Joined: 29 Jul 2009
Posts: 120
Followers: 4
Kudos [?]:
63
[0], given: 14
|
Re: Competition for the Best GMAT Error Log Template [#permalink]
23 Dec 2009, 00:00
Christmas gift to all GMATClub members. Improved and completed version of Friendly Error log. Attachment: Version 2007: Attachment: bb can you please put those at the first page of this post. 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' comments. Edit: Removed attached files to correct formula Edit: Attached updated excel files
_________________
GMAT Club Error Log V3.0 - with Timer GMAT Club Error Log Spoilt Error Log V0.0.9 - with Timer Awesome Error Log - By Spoilt and Trianglock
Last edited by Spoilt on 23 Dec 2009, 03:27, edited 2 times in total.
|
|
|
|
|
|
Founder
Status: On Vacation :-)
Affiliations: UA-1K, SPG-G, HH-D
Joined: 04 Dec 2002
Posts: 10403
Location: United States (WA)
GMAT 1: 750 Q49 V42
GPA: 3.5
WE: Information Technology (Hospitality and Tourism)
Followers: 1367
Kudos [?]:
4191
[0], given: 3122
|
Re: Competition for the Best GMAT Error Log Template [#permalink]
23 Dec 2009, 00:18
Thanks. Will do. Do you mind sharing what the changes/improvements were?
_________________
Founder of GMAT Club
Just starting out with GMAT? Start here... | Want to know your GMAT Score? Try GMAT Score Estimator Need GMAT Book Recommendations? Best GMAT Books
Co-author of the GMAT Club tests
Find out what's new at GMAT Club - latest features and updates
|
|
|
|
|
|
Manager
Joined: 29 Jul 2009
Posts: 120
Followers: 4
Kudos [?]:
63
[0], given: 14
|
Re: Competition for the Best GMAT Error Log Template [#permalink]
23 Dec 2009, 01:34
bb wrote: Thanks. Will do. Do you mind sharing what the changes/improvements were? Give me some time I will write the consolidated changes in the post. e.g. there was mistake in table of report page, there were the % of questions solved of particular type not the accuracy : so if you solved 10 questions of type "Assumption" and you missed all, so the accuracy should be 0% not the 100%. I am editing the excel formulas again, give me some time.
_________________
GMAT Club Error Log V3.0 - with Timer GMAT Club Error Log Spoilt Error Log V0.0.9 - with Timer Awesome Error Log - By Spoilt and Trianglock
|
|
|
|
|
|
Manager
Joined: 29 Jul 2009
Posts: 120
Followers: 4
Kudos [?]:
63
[1] , given: 14
|
Re: Competition for the Best GMAT Error Log Template [#permalink]
23 Dec 2009, 03:25
1
This post received KUDOS
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
_________________
GMAT Club Error Log V3.0 - with Timer GMAT Club Error Log Spoilt Error Log V0.0.9 - with Timer Awesome Error Log - By Spoilt and Trianglock
|
|
|
|
|
|
Manager
Joined: 08 Jul 2009
Posts: 177
Followers: 0
Kudos [?]:
11
[0], given: 26
|
Re: Competition for the Best GMAT Error Log Template [#permalink]
23 Dec 2009, 11:24
great. Thanks for working so hard and contributing.
|
|
|
|
|
|
Intern
Joined: 29 Nov 2009
Posts: 22
Location: Toronto
Followers: 0
Kudos [?]:
1
[0], given: 5
|
Re: Competition for the Best GMAT Error Log Template [#permalink]
23 Dec 2009, 20:40
Kudos to Saruba and Spolit, the friendly error log is fantastic! Awesome work!
|
|
|
|
|
|
Manager
Joined: 30 Jun 2004
Posts: 180
Location: Singapore
Followers: 1
Kudos [?]:
9
[0], given: 5
|
Re: Competition for the Best GMAT Error Log Template [#permalink]
29 Dec 2009, 05:37
Thanks for these great error logs. I wish I had them before I made my first GMAT attempt.
|
|
|
|
|
|
Manager
Joined: 09 May 2009
Posts: 213
Followers: 1
Kudos [?]:
45
[0], given: 13
|
Re: Competition for the Best GMAT Error Log Template [#permalink]
29 Dec 2009, 22:54
Hi, i haven't used any of the error log till now , and was searching for a useful error log. thanks to GMAT CLUB as it has some handy error logs however i was unable to find anything related to tracing the questions in error log. by tracing i mean , if in future for revesion purpose i want to find some particular q ,which i have dne wrong during my practice and has made an entry in my error log , then how i should locate the problem through my error log. i hope i am clear in expressing my issue will appreciate any help!!!!! thanks in advance
_________________
GMAT is not a game for losers , and the moment u decide to appear for it u are no more a loser........ITS A BRAIN GAME
|
|
|
|
|
|
Manager
Joined: 29 Jul 2009
Posts: 120
Followers: 4
Kudos [?]:
63
[0], given: 14
|
Re: Competition for the Best GMAT Error Log Template [#permalink]
30 Dec 2009, 02:32
Hi, it was clear. I understood what you want. i am using spoilt error log v0.0.7 in my signature. I use the notes field for this purpose. I write the question number in notes field. Add a auto filter in excel using DATA-FILTER-AUTO FILTER. so we have source field . type field . Correct field. And number of question in notes field. Using filter i can easily filter it. Try it it's easy. please don't hesitate if you need more help. Sorry using my mobile otherwise i would have attached snapshot. Posted from my mobile device
_________________
GMAT Club Error Log V3.0 - with Timer GMAT Club Error Log Spoilt Error Log V0.0.9 - with Timer Awesome Error Log - By Spoilt and Trianglock
|
|
|
|
|
|
Manager
Joined: 09 May 2009
Posts: 213
Followers: 1
Kudos [?]:
45
[0], given: 13
|
Re: Competition for the Best GMAT Error Log Template [#permalink]
30 Dec 2009, 03:10
Spoilt wrote: Hi, it was clear. I understood what you want. i am using spoilt error log v0.0.7 in my signature. I use the notes field for this purpose. I write the question number in notes field. Add a auto filter in excel using DATA-FILTER-AUTO FILTER. so we have source field . type field . Correct field. And number of question in notes field. Using filter i can easily filter it. Try it it's easy. please don't hesitate if you need more help. Sorry using my mobile otherwise i would have attached snapshot. Posted from my mobile device  thanks spoilt i got it
_________________
GMAT is not a game for losers , and the moment u decide to appear for it u are no more a loser........ITS A BRAIN GAME
|
|
|
|
|
|
Intern
Joined: 29 Sep 2009
Posts: 23
Schools: McMaster
Followers: 0
Kudos [?]:
0
[0], given: 2
|
Re: Competition for the Best GMAT Error Log Template [#permalink]
04 Jan 2010, 01:05
Hey Spoilt, this is awesome error-log! I'm using your v0.07 for your GMAT study. I was wondering if you can integrate in an auto stopwatch function inside your sheet, so in that way users can have a better understanding on what types of questions he/she needs to really practice from a timing strategy perspective. I attached an old error-log I downloaded long time ago from GMAT Club. It has the auto stopwatch function. Spoilt wrote: Hi, it was clear. I understood what you want. i am using spoilt error log v0.0.7 in my signature. I use the notes field for this purpose. I write the question number in notes field. Add a auto filter in excel using DATA-FILTER-AUTO FILTER. so we have source field . type field . Correct field. And number of question in notes field. Using filter i can easily filter it. Try it it's easy. please don't hesitate if you need more help. Sorry using my mobile otherwise i would have attached snapshot. Posted from my mobile device 
|
|
|
|
|
|
Manager
Joined: 29 Jul 2009
Posts: 120
Followers: 4
Kudos [?]:
63
[0], given: 14
|
Re: Competition for the Best GMAT Error Log Template [#permalink]
04 Jan 2010, 04:47
Jasonlu1981 wrote: Hey Spoilt, this is awesome error-log! I'm using your v0.07 for your GMAT study. I was wondering if you can integrate in an auto stopwatch function inside your sheet, so in that way users can have a better understanding on what types of questions he/she needs to really practice from a timing strategy perspective. I attached an old error-log I downloaded long time ago from GMAT Club. It has the auto stopwatch function. Spoilt wrote: Hi, it was clear. I understood what you want. i am using spoilt error log v0.0.7 in my signature. I use the notes field for this purpose. I write the question number in notes field. Add a auto filter in excel using DATA-FILTER-AUTO FILTER. so we have source field . type field . Correct field. And number of question in notes field. Using filter i can easily filter it. Try it it's easy. please don't hesitate if you need more help. Sorry using my mobile otherwise i would have attached snapshot. Posted from my mobile device  Yes sure why not. For the moment you can use GMATtimer by sir Walker - It's a very useful tool. I will check the source code in the attached excel and update log ASAP. I am really glad to know that my error logs are useful to many GMAT club members for their preparation. Please feel free to provide your valuable feedbacks and suggestions.
_________________
GMAT Club Error Log V3.0 - with Timer GMAT Club Error Log Spoilt Error Log V0.0.9 - with Timer Awesome Error Log - By Spoilt and Trianglock
|
|
|
|
|
|
|
Re: Competition for the Best GMAT Error Log Template
[#permalink]
04 Jan 2010, 04:47
|
|
|
|
|
|
|
|
|
|
|