|
Author |
Message |
|
Director
Joined: 29 Oct 2004
Posts: 894
Followers: 2
Kudos [?]:
20
[14] , given: 0
|
New GMAT Practice Grid [#permalink]
09 Nov 2004, 11:39
14
This post received KUDOS
Hi, I just picked up a GMAT Practice Grid from someone online. I have modified the Excel file by doing some programming. Now, the sheet can time you automatically everytime you put in an answer. OK, guys! I decide to do some more update on this sheet so ignore my last statement. New features includes: + Change number of question: sheet automatically update + Change to Verbal/Math: Time update + Put in number of first question: Auto number + Average time per question + Fixed bugs... Attachment:
TestGrid4GMAT_latest_version.xls [78.5 KiB]
Downloaded 2489 times
Reworked Forms version by wlee76Attachment:
exercises_120.xls [88.5 KiB]
Downloaded 1135 times
Original Spreadsheet: Attachment:
TestGrid4GMAT.xls [36.5 KiB]
Downloaded 1652 times
Last edited by bb on 20 Jun 2009, 22:43, edited 3 times in total.
Files Updated
|
|
|
|
|
|
|
|
|
Director
Joined: 29 Oct 2004
Posts: 894
Followers: 2
Kudos [?]:
20
[0], given: 0
|
Here is the update.
I put the timer and the question guide in. Also, you can just double click in the cells to select answer.
|
|
|
|
|
|
GMAT Club Legend
Joined: 07 Jul 2004
Posts: 5134
Location: Singapore
Followers: 9
Kudos [?]:
87
[0], given: 0
|
Hi, nice tool. Just a question, I don't seem to be able to get the timer to run the 'clear all' tab doesn't seem to be working. Am i suppose to enable something in ms excel ??
|
|
|
|
|
|
Director
Joined: 29 Oct 2004
Posts: 894
Followers: 2
Kudos [?]:
20
[0], given: 0
|
Yes, you suppose to enable macro in Tools\Macro\Security, choose Medium. Then restart and click on enable macro.
|
|
|
|
|
|
Director
Joined: 07 Nov 2004
Posts: 728
Followers: 3
Kudos [?]:
9
[1] , given: 0
|
1
This post received KUDOS
Great tool qhoc0010
|
|
|
|
|
|
Director
Joined: 29 Oct 2004
Posts: 894
Followers: 2
Kudos [?]:
20
[0], given: 0
|
OK, this is the last update I do on this sheet. These are the new features:
+ Double click on any cell to mark "X" or answer
+ Button above "#" to do automatic numbering (You need to put the first number to start)
+ Pause button works (fixed some bugs)
|
|
|
|
|
|
Director
Joined: 25 Jan 2004
Posts: 772
Location: Milwaukee
Followers: 2
Kudos [?]:
6
[0], given: 0
|
You rock. Great job
_________________
Praveen
|
|
|
|
|
|
Intern
Joined: 04 Oct 2004
Posts: 11
Followers: 0
Kudos [?]:
0
[0], given: 0
|
Thank you qhoc0010. The tool is awsome !!
|
|
|
|
|
|
Intern
Joined: 30 Oct 2004
Posts: 9
Followers: 0
Kudos [?]:
0
[0], given: 0
|
wonderful tool buddy. gr8 work.
|
|
|
|
|
|
CEO
Joined: 15 Aug 2003
Posts: 3550
Followers: 55
Kudos [?]:
626
[0], given: 781
|
thank you for your help.
Praetorian
|
|
|
|
|
|
Senior Manager
Joined: 03 Nov 2004
Posts: 495
Followers: 1
Kudos [?]:
7
[0], given: 0
|
geniussss!!!! superb tool!!
|
|
|
|
|
|
Director
Joined: 29 Oct 2004
Posts: 894
Followers: 2
Kudos [?]:
20
[4] , given: 0
|
4
This post received KUDOS
OK, guys! I decide to do some more update on this sheet so ignore my last statement. New features includes:
+ Change number of question: sheet automatically update
+ Change to Verbal/Math: Time update
+ Put in number of first question: Auto number
+ Average time per question
+ Fixed bugs...
Enjoin guys!!!
|
|
|
|
|
|
Manager
Joined: 06 Dec 2004
Posts: 73
Location: san diego
Followers: 1
Kudos [?]:
0
[0], given: 0
|
One of the most useful tools on the site, thank you very much
|
|
|
|
|
|
Intern
Joined: 17 Oct 2005
Posts: 16
Followers: 0
Kudos [?]:
0
[0], given: 0
|
great tool, going to use it tomorrow!
|
|
|
|
|
|
Intern
Joined: 05 Nov 2005
Posts: 33
Location: London
Followers: 0
Kudos [?]:
1
[1] , given: 0
|
1
This post received KUDOS
qhoc0010,
I 've created a form-based version that I have been using for my preparation.
It hasn't got the good stats as your one does, but it may help ppl become familiar with clicking "Confirm Answer" and "Next"
It also has marking form included
To start, go to Tools->Macro, or Customise a toolbar in Excel, and add the macros to a icon
Wes.
|
|
|
|
|
|
Intern
Joined: 05 Dec 2005
Posts: 1
Followers: 0
Kudos [?]:
0
[0], given: 0
|
How to download qhoc0010's GMAT practice grid [#permalink]
06 Dec 2005, 12:44
FYI - Once you allow javascript in your browser, or modify the security settings, you should see links to download the versions of the practice grid tool in this thread.
|
|
|
|
|
|
Senior Manager
Joined: 23 May 2005
Posts: 266
Location: Sing/ HK
Followers: 1
Kudos [?]:
3
[0], given: 0
|
Recently did a 200+ test but the time per question doesn't come out correctly for questions beyond 41. Hw do i fix this?
Thanks so much!
|
|
|
|
|
|
Intern
Joined: 05 Nov 2005
Posts: 33
Location: London
Followers: 0
Kudos [?]:
1
[0], given: 0
|
Hermione wrote: Recently did a 200+ test but the time per question doesn't come out correctly for questions beyond 41. Hw do i fix this?
Thanks so much!
Make sure that the formulas reference the other cells correctly.
|
|
|
|
|
|
Manager
Joined: 15 Aug 2006
Posts: 56
Followers: 1
Kudos [?]:
0
[0], given: 0
|
Thanks a lot qhoc0010.
Its an amazing tool.
|
|
|
|
|
|
Manager
Joined: 29 Nov 2006
Posts: 85
Followers: 1
Kudos [?]:
2
[0], given: 0
|
How does the timer work? When I click on start, it sends me to the code sheet. Am I doing something wrong?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|