qhoc0010 Posted November 9, 2004 Share Posted November 9, 2004 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!!!TestGrid4GMAT.zip Link to comment Share on other sites More sharing options...
scarletletter Posted November 9, 2004 Share Posted November 9, 2004 Cool! :tup: How do you use it???? Link to comment Share on other sites More sharing options...
thegreatmughal Posted November 10, 2004 Share Posted November 10, 2004 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... Link to comment Share on other sites More sharing options...
Psyzygy Posted December 5, 2004 Share Posted December 5, 2004 thank you qhoc! your test grid is a life saver! Link to comment Share on other sites More sharing options...
gagan_ait Posted December 10, 2004 Share Posted December 10, 2004 Awesome qhoc ! this is realy good use of the xls. Link to comment Share on other sites More sharing options...
mba05 Posted December 16, 2004 Share Posted December 16, 2004 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 [clap] Link to comment Share on other sites More sharing options...
qhoc0010 Posted December 16, 2004 Author Share Posted December 16, 2004 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 [clap] 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... Link to comment Share on other sites More sharing options...
Sargataur Posted December 22, 2004 Share Posted December 22, 2004 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 Link to comment Share on other sites More sharing options...
qhoc0010 Posted December 22, 2004 Author Share Posted December 22, 2004 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. Link to comment Share on other sites More sharing options...
a_bit Posted November 17, 2007 Share Posted November 17, 2007 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 :( Link to comment Share on other sites More sharing options...
Recommended Posts