Find all School-related info fast with the new School-Specific MBA Forum

It is currently 20 Aug 2014, 15:04

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.

Events & Promotions

Events & Promotions in June
Open Detailed Calendar

Timer Tool for Google spreadsheet

  Question banks Downloads My Bookmarks Reviews Important topics  
Author Message
2 KUDOS received
Manager
Manager
User avatar
Joined: 01 Oct 2010
Posts: 71
Followers: 4

Kudos [?]: 59 [2] , given: 19

Timer Tool for Google spreadsheet [#permalink] New post 28 Oct 2010, 17:34
2
This post received
KUDOS
Greetings!

I was looking for a timer application which I can use on linux and could not find one. Recently, I learnt that Google allows scripts in their spreadsheet, and I thought of developing a tool that I can use for my practice! The advantage of such a tool is that I can use it on any browser which can run Google Spreadsheet.

Attached file is a script that you will need to install for any spreadsheet on Google docs. You need to install it once for each file, and can use it for all sheets for that file.

Installing the Script.

1) download and extract the file.
2) Go to google docs and create (or open) your spreadsheet, and save it.
3) Go to Tools->Scripts->Script Editor
4) Remove everything, and paste contents of script file that you extracted in step 1.
5) Save the script file. you can give any name you like.
6) Go to Triggers->Current Script's Triggers
7) Click on Add new Trigger, and select OnOpen, From Spreadsheet, On Open for the three combo boxes.
8) Save and close script editor and spreadsheet.

Using the Script.

1) open the spreadsheet and click somewhere on spreadsheet. You will see a new menu item called "Timer Tool". This happens automatically because of step 7 in installation.
2) If this is blank spreadsheet, you may want to add headers by going to Timer Tool->Add Headers
3) When you begin reading your question, go to Timer Tool->Reset Timer.
4) Now when you answer first question, go to Timer Tool->A/B/C/D/E
5) For second question, go to Timer Tool->A/B/C/D/E.

No need to reset timer unless you take a break. Time for question is counted from the time you answer previous question, or you click on reset timer.
If you want to come back some other time, you can close the spreadsheet. Next time when you come back, just click on Timer Tool->Reset Timer to start again.

Hope this is helpful. If you have any questions, or problems, please let me know.
Attachments

File comment: Timer Tool V1.0 [Released Oct 28 2010]
timertool_v1.0.zip [1.18 KiB]
Downloaded 188 times

To download please login or register as a user


_________________

Some other posts by me...
My GMAT Journey
Timer Tool for Google spreadsheet
Quant Flash Cards/Pages

700 (Q:49 V:35) - Thanks GMATClub - Test Center experience

Expert Post
Founder
Founder
User avatar
Affiliations: UA-1K, SPG-G, HH-D
Joined: 04 Dec 2002
Posts: 12062
Location: United States (WA)
GMAT 1: 750 Q49 V42
GPA: 3.5
WE: Information Technology (Hospitality and Tourism)
Followers: 2219

Kudos [?]: 8178 [0], given: 3641

GMAT ToolKit User Premium Member CAT Tests
Re: Timer Tool for Google spreadsheet [#permalink] New post 28 Oct 2010, 17:44
Expert's post
Thank you! Kudos

Also see these tools:
gmat-timer-56014.html
time-yourself-with-a-new-gmat-club-timer-v-96251.html
gmat-toolkit-iphone-ipod-ipad-application-82830.html
_________________

Founder of GMAT Club

Just starting out with GMAT? Start here... | Want to know your GMAT Score? Try GMAT Score Estimator
Need GMAT Book Recommendations? Best GMAT Books

Co-author of the GMAT Club tests

Have a blog? Feature it on GMAT Club!

Get the best GMAT Prep Resources with GMAT Club Premium Membership

Re: Timer Tool for Google spreadsheet   [#permalink] 28 Oct 2010, 17:44
    Similar topics Author Replies Last post
Similar
Topics:
2 Experts publish their posts in the topic Google+ walker 17 11 Jul 2011, 04:37
Consulting spreadsheet zhl226 7 14 Oct 2008, 01:10
10 GMAT 700 Threshold Spreadsheet jb32 32 07 May 2008, 13:47
First timer ex21 2 20 Sep 2007, 17:23
Interesting Timer Zem 0 08 Feb 2005, 09:23
Display posts from previous: Sort by

Timer Tool for Google spreadsheet

  Question banks Downloads My Bookmarks Reviews Important topics  

Moderators: bagdbmba, WaterFlowsUp



GMAT Club MBA Forum Home| About| Privacy Policy| Terms and Conditions| GMAT Club Rules| Contact| Sitemap

Powered by phpBB © phpBB Group and phpBB SEO

Kindly note that the GMAT® test is a registered trademark of the Graduate Management Admission Council®, and this site has neither been reviewed nor endorsed by GMAC®.