NEW HERE? LEARN MORE
closeclose
Last visit was: 24 Apr 2024, 16:09 It is currently 24 Apr 2024, 16:09
Decision Tracker
My Rewards
New posts
New comers' posts

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.
Go to My Error Log Learn more
Close
Request Expert Reply
Confirm Cancel

New GMAT Practice Grid

SORT BY:
Date
Kudos
 1   2   
User avatar
qhoc0010
Senior Manager
Senior Manager
Joined: 29 Oct 2004
Posts: 456
Own Kudos [?]: 1497 [40]
Given Kudos: 0
Send PM
New GMAT Practice Grid [#permalink] New post   Updated on: 20 Jun 2009, 22:43
25
Kudos
15
Bookmarks
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 5843 times


Reworked Forms version by wlee76
Attachment:
exercises_120.xls [88.5 KiB]
Downloaded 2305 times



Original Spreadsheet:
Attachment:
TestGrid4GMAT.xls [36.5 KiB]
Downloaded 2246 times

Originally posted by qhoc0010 on 09 Nov 2004, 11:39.
Last edited by bb on 20 Jun 2009, 22:43, edited 3 times in total.
Files Updated
User avatar
qhoc0010
Senior Manager
Senior Manager
Joined: 29 Oct 2004
Posts: 456
Own Kudos [?]: 1497 [0]
Given Kudos: 0
Send PM
[#permalink] New post   21 Nov 2004, 16:56
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.
Attachments

TestGrid4GMAT.zip [17.28 KiB]
Downloaded 1732 times

User avatar
ywilfred
SVP
SVP
Joined: 07 Jul 2004
Posts: 2004
Own Kudos [?]: 1899 [0]
Given Kudos: 0
Location: Singapore
Send PM
[#permalink] New post   22 Nov 2004, 05:47
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 ??
User avatar
qhoc0010
Senior Manager
Senior Manager
Joined: 29 Oct 2004
Posts: 456
Own Kudos [?]: 1497 [0]
Given Kudos: 0
Send PM
[#permalink] New post   22 Nov 2004, 05:52
Yes, you suppose to enable macro in Tools\Macro\Security, choose Medium. Then restart and click on enable macro.
User avatar
gayathri
Senior Manager
Senior Manager
Joined: 07 Nov 2004
Posts: 367
Own Kudos [?]: 468 [1]
Given Kudos: 0
Send PM
[#permalink] New post   22 Nov 2004, 07:07
1
Kudos
Great tool qhoc0010 :-D
User avatar
qhoc0010
Senior Manager
Senior Manager
Joined: 29 Oct 2004
Posts: 456
Own Kudos [?]: 1497 [0]
Given Kudos: 0
Send PM
[#permalink] New post   03 Dec 2004, 10:42
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)
Attachments

TestGrid4GMAT.xls [63 KiB]
Downloaded 1086 times

avatar
brravindra
Intern
Intern
Joined: 04 Oct 2004
Posts: 8
Own Kudos [?]: 1 [0]
Given Kudos: 0
Send PM
[#permalink] New post   03 Dec 2004, 14:21
Thank you qhoc0010. The tool is awsome !!
User avatar
qhoc0010
Senior Manager
Senior Manager
Joined: 29 Oct 2004
Posts: 456
Own Kudos [?]: 1497 [6]
Given Kudos: 0
Send PM
[#permalink] New post   14 Dec 2004, 12:15
5
Kudos
1
Bookmarks
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!!!
Attachments

TestGrid4GMAT.xls [78.5 KiB]
Downloaded 2914 times

User avatar
thenine
Intern
Intern
Joined: 06 Dec 2004
Posts: 45
Own Kudos [?]: [0]
Given Kudos: 0
Location: san diego
Send PM
[#permalink] New post   07 Jan 2005, 00:52
One of the most useful tools on the site, thank you very much
avatar
rsanchez
Intern
Intern
Joined: 17 Oct 2005
Posts: 15
Own Kudos [?]: 24 [0]
Given Kudos: 0
Send PM
:-) [#permalink] New post   17 Oct 2005, 20:07
great tool, going to use it tomorrow!
avatar
wlee76
Intern
Intern
Joined: 05 Nov 2005
Posts: 29
Own Kudos [?]: 1 [1]
Given Kudos: 0
Location: London
Send PM
[#permalink] New post   27 Nov 2005, 14:46
1
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.
Attachments

Exercises.xls [88.5 KiB]
Downloaded 1134 times

avatar
miller_2555
Intern
Intern
Joined: 05 Dec 2005
Posts: 1
Own Kudos [?]: [0]
Given Kudos: 0
Send PM
How to download qhoc0010's GMAT practice grid [#permalink] New post   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.
User avatar
Hermione
Manager
Manager
Joined: 23 May 2005
Posts: 139
Own Kudos [?]: 214 [0]
Given Kudos: 0
Location: Sing/ HK
Send PM
[#permalink] New post   15 Apr 2006, 00:54
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!
avatar
wlee76
Intern
Intern
Joined: 05 Nov 2005
Posts: 29
Own Kudos [?]: 1 [0]
Given Kudos: 0
Location: London
Send PM
[#permalink] New post   18 Apr 2006, 01:06
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.
User avatar
chanmat
Intern
Intern
Joined: 15 Aug 2006
Posts: 37
Own Kudos [?]: 3 [0]
Given Kudos: 0
Send PM
[#permalink] New post   20 Sep 2006, 12:39
Thanks a lot qhoc0010.

Its an amazing tool.
User avatar
adub35
Manager
Manager
Joined: 29 Nov 2006
Posts: 55
Own Kudos [?]: 257 [0]
Given Kudos: 0
Send PM
[#permalink] New post   02 Dec 2006, 21:26
How does the timer work? When I click on start, it sends me to the code sheet. Am I doing something wrong?
avatar
pandrewp419
Intern
Intern
Joined: 28 Jun 2009
Posts: 1
Own Kudos [?]: [0]
Given Kudos: 0
Send PM
Re: New GMAT Practice Grid [#permalink] New post   28 Jun 2009, 08:15
This is an amazing tool. I wish I had it last night when I took my first diagnostic test.
avatar
AceofSpades
Manager
Manager
Joined: 14 May 2009
Posts: 111
Own Kudos [?]: 76 [0]
Given Kudos: 29
Schools: AGSM '16
Send PM
Re: New GMAT Practice Grid [#permalink] New post   28 Jun 2009, 08:23
This is a great tool! Thanks for sharing!
avatar
MontrealLady
Manager
Manager
Joined: 29 Jul 2009
Posts: 134
Own Kudos [?]: 282 [0]
Given Kudos: 2
Send PM
Re: [#permalink] New post   05 Aug 2009, 16:11
qhoc0010 wrote:
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!!!


Hi,
not sure how calculating the time in TestGrid4GMAT document in qhoc0010's post work.
I know how to calculate the time it takes to complete the whole exam (by clicking start). but what about calculating the time it takes to answer each questions?

Thanks,
avatar
ashimak
Intern
Intern
Joined: 20 Oct 2009
Posts: 1
Own Kudos [?]: [0]
Given Kudos: 1
Send PM
Re: New GMAT Practice Grid [#permalink] New post   20 Oct 2009, 09:39
Hi,

Does anybody know how to change the time assigned per question? Say for SC questions, I would like the excel sheet to only assign 1.3 minutes per question and accordingly calculate the total time i.e. Time Left. Can a programmer figure this out for me please...

Excellent tool nonetheless!
GMAT Club Bot
gmatclubot
Re: New GMAT Practice Grid [#permalink]
20 Oct 2009, 09:39
 1   2   

Powered by phpBB © phpBB Group | Emoji artwork provided by EmojiOne
Main navigation
GMAT Resources
Partners
MBA Resources
www.gmac.com|www.mba.com | | GMAT Club Rules | Terms and Conditions