New GMAT Practice Grid

[qhoc0010]

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.

Update #1:

Here is the update. I added in the timer and question guide. You can also just double click on the cell to mark correct answer.

Update #2:

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)

Update #3:

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

[scarletletter]

Cool! How do you use it????

[thegreatmughal]

nice work dude !!!
one has to click the "enable macro" button in the dialogue box, which pops-up when you open the excel sheet. this way you can use this sheet & its functions properly...

[Psyzygy]

thank you qhoc! your test grid is a life saver!

[gagan_ait]

Awesome qhoc ! this is realy good use of the xls.

[mba05]

thank you qhoc0010,
This is sure to help a lot of magicians...
i have a suggestion ...

Each excel represents a practice test.
Worksheet 1 is the summary - test number , date, verbal score and quant score, average time for each question etc
and total score out of 800 (I dont know this is calculated though )
The sectional details are derived from sheet 2 - quant and sheet 3 - verbal
Sheets 2 and 3 have the details for each section (the sheet as it exists today).

Let me know what you think.

Thanks again for your contribution

[qhoc0010]

Originally Posted by mba05

thank you qhoc0010,
This is sure to help a lot of magicians...
i have a suggestion ...

Each excel represents a practice test.
Worksheet 1 is the summary - test number , date, verbal score and quant score, average time for each question etc
and total score out of 800 (I dont know this is calculated though )
The sectional details are derived from sheet 2 - quant and sheet 3 - verbal
Sheets 2 and 3 have the details for each section (the sheet as it exists today).

Let me know what you think.

Thanks again for your contribution

Most of the above has already on the last update. However, I try not to make the sheet too big. This sheet can be flexible as you can do any number of question you want (not 41 or 37). Again, the idea is to make it as light as possible however, still a useful tool to learn, review...

[Sargataur]

i find the time tracker tools very useful ....question is how does one use these while trying to concentrate on doing a test and clicking choices within the test interface at the same time...how do i make optimum use of this sheet...suggestion woud be welcome thanx

[qhoc0010]

Nice, but how can I change the answer?

Sargataur, yes, this sheet has limited by taking away your concentration. But again, if you do on paper, you still have to look away to write down the answer anyway!!

Next version, I probably want to put some shortcut key instead of using mouse and double click on the right cell.

[a_bit]

Does this work on Mac-OSX? I am not able to extract the zip file (using BOMArchiver). I do have MS-Office for Mac.

I am not able to unzip this file on MacOSX even on commandline