New GMAT Practice Grid

Question

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 6004 times

Reworked Forms version by wlee76

Attachment:

exercises_120.xls [88.5 KiB]
Downloaded 2393 times

Original Spreadsheet:

Attachment:

TestGrid4GMAT.xls [36.5 KiB]
Downloaded 2292 times

qhoc0010 · Answer

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.

ywilfred · Answer

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 ??

qhoc0010 · Answer

Yes, you suppose to enable macro in Tools\Macro\Security, choose Medium. Then restart and click on enable macro.

gayathri · Answer

Great tool qhoc0010 :-D

qhoc0010 · Answer

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)

brravindra · Answer

Thank you qhoc0010. The tool is awsome !!

qhoc0010 · 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...


Enjoin guys!!!

thenine · Answer

One of the most useful tools on the site, thank you very much

rsanchez · Answer

great tool, going to use it tomorrow!

wlee76 · Answer

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.

miller_2555 · Answer

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.

Hermione · Answer

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!

wlee76 · Answer

Make sure that the formulas reference the other cells correctly.

chanmat · Answer

Thanks a lot qhoc0010.

Its an amazing tool.

adub35 · Answer

How does the timer work? When I click on start, it sends me to the code sheet. Am I doing something wrong?

pandrewp419 · Answer

This is an amazing tool. I wish I had it last night when I took my first diagnostic test.

AceofSpades · Answer

This is a great tool! Thanks for sharing!

MontrealLady · Answer

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,

ashimak · Answer

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!

	e-GMAT: 60% Off on GMAT Focus Get to 735+ from any starting point
	Magoosh increases your score, guaranteed - 15% off ALL Magoosh GMAT plans with code GMATCLUB15 + Free GMAT Club Tests.
	Manhattan Prep: $99 Bonus Score Higher on Your GMAT Exam. Guaranteed.
	Target Test Prep - Save up to $599 $400 Discount + $99 Bonus GMAT Club Tests
	Experts' Global - ~~$1720~~ $960 End-to-End GMAT Prep + App Support: 150+ Videos, 2000+ Questions, 15 FLTs +
	GMATWhiz - $299 ~~$499~~ Experience the course through a free trial.
	GMAT Club Tests - Free Included with every course purchase of $149+ View all deals

New GMAT Practice Grid

Prep Toolkit

Top 5 GMAT Debrief Videos

615 to 715 in 15 Days (Ria's Strategies)

More than Quant/Verbal Abilities: Speed vs. Accuracy

745 with Only Self-Prep and GMAT Club

From 555 to 765: 210-point Improvement

Perfect 805 Score Debrief by Julia

My Rewards