Project Timers, Planners,-and-Calendars
Created with Spreadsheet Software
by David Alderoty © 2012
This website provides six devices created with Microsoft Excel
for scheduling and planning projects or daily activities.
This website also provides information on time
management
in relation to planning projects and goals.
To contact the author (David Alderoty) use this
e‑mail address: David@TechForText.com, or left click
on the link below for a website communication form.
Link for a Website Communication Form
This website also provides LINKS to a number of other websites created by the author that provide free downloads of various types of timing devices, and information on time management, which are presented below:
The above is a webpage that lists a number of websites
www.TechForText.com/Time-Management
www.TechForText.com/Timing-Devices-Created-with-Spreadsheet-Software
www.TechForText.com/Project-Timers-and-Calendars
www.TechForText.com/Elapsed-Timers
www.TechForText.com/Experimental-Elapsed-Timers
The Software-Based Devices On This
Website Are Available For Free Download
Below there are six devices in the Microsoft Excel format, that will help you plan projects, and daily activities. Some of these devices are also in the JavaScript format, which is primarily for demonstration purposes. (The Excel devices require Microsoft Windows, and they are available for Microsoft Excel 2007-2010 and Excel 2003, as indicated on the filenames.)
Remove the software from the zipped folder before you use it. This applies to both the Excel and JavaScript versions. To use any of the following devices, delete the dates in the white input boxes, and entered the dates that relate to your project or daily, weekly, monthly or yearly plans. With these dates the Excel and JavaScript devices perform a set of calculations, as indicated on each device.
(For Devices 3, 4, 5, and 6) The Planner-Calendars provide sections under each date, to enter your sub‑goals or related plans for the day. You can also use these sections for any other information that will help you obtain your objectives. Sometimes it is useful to record problems and/or successful outcomes in these sections as they occur day by day. To download any of the following devices left click on the blue words below.
Important Note about Timing Devices
Created With Spreadsheet Software
It is important to understand that timing devices that were created with Microsoft Excel, or similar spreadsheet software, must be updated to obtain the correct time and date. For example, if a timing device created with spreadsheet software is opened on your computer on August 23, 2012, at 4:26 PM, it will indicate the above time and date. This date and time will not change, even if you leave the software opened on your computer for a week, unless you update it. You can update the spreadsheet versions either by entering or deleting numbers, and clicking with the mouse, or by opening and closing the software. When a JavaScript timing device is created with spreadsheet software, the exact same concept applies. That is the software will not register any changes in date or time unless it is updated as indicated above. However, with the JavaScript versions, I often provide an update button, which the user can press to update the date and time.
All of the above usually does not result in any practical problems, because most people frequently open and close software, and/or enter or delete data, which automatically updates the time and date. When this is a problem, alternative timing software should be used.
It is also important to understand that the spreadsheet and JavaScript devices access the date and time on your computer's clock. Thus, if your computer’s timing mechanism is incorrect the time and/or date on the spreadsheet and JavaScript devices will also be incorrect.
Some Useful Ideas to Help You With
Project Planning, Goal Attainment and Scheduling
Of Daily, Weekly, Monthly, and Yearly Activities
Based on the way the terminology is used on this website, project planners, are software-based devices that have a built-in timing mechanism or calendar, which is designed to help with planning and/or scheduling various aspects of a project. In the simplest form, a project planner is a software-based calendar to describe various sub-goals or tasks that relate to the completion of the project.
Projects, schedules and project planners, involve a specific start date, an end date. The start date is the day when the project or plans officially starts. I am defining the end date, as the last day of the project. For example, if September 23, 2012 is the end date, it means that before the end of September 23 all the work will be completed before the end of the day. The date of total completion, where 100% of the project is completed, would be September 24, 2012, with this example.
The project can be a set of unrelated goals or activities that you want to complete in a day, a week a month, or year. On the other hand the project can be specific goal divided into a series of sub-goals, which may involve one or more individuals. The most obvious example is a construction project.
Organizing tasks and goals into a project that is to be completed within a specific period of time can be a very useful time management strategy. This type of planning is more likely to be fruitful if the relevant tasks or sub-goals are listed on paper or on the computer screen, and evaluated by asking yourself a series of relevant questions, such as the following examples:
How much time is required to complete this sub-goal?
How much money is required to complete this sub-goal?
What are the risks involved with this sub-goal.
Can I complete this sub-goal by myself, or do I need the assistance of others, such as technicians and/or experts.
What are the tools, equipment and personnel needed to complete this project?
What is the time, cost, and risks associated with the entire project?
Are there any ways of reducing the time, cost, and risks associated with this project?
Is the cost benefit ratio favorable with this project?
Are there any strategies that can be implemented to improve the cost benefit ratio of this project?
What are all the potential problems with this project, and how can they be circumvented?
Are there any other questions you can add to this list? (Usually the best questions, and related answers, are created by the individual or people that are planning the project.)
When answering questions of this nature, it is helpful to keep in mind that people often underestimate the time, cost, and risks associated with projects and long-term goals. This is probably because it is difficult to visualize and evaluate the large number of steps, and potential problems with most long-term objectives. Trying to visualize and evaluate more of the sequences, and potential problems, can result in better planning of long-term projects. To compensate for the tendency to underestimate, create plans that have safety margins in terms of extra funding, and additional time. Increasing estimates of time and money to complete a project by a specific percentage may be the most realistic strategy in many situations. This can range from 5 to 70% depending on the circumstances.
In many situations, especially with personal goals, the best plans are very flexible in nature, and contain a number of alternate pathways to the primary objective. This essentially involves alternative sets of sub‑goals that will help you obtain your primary objective, or an alternative objective that is almost as desirable.
It's important to understand that goals can be divided into two general categories, which are projects that have an almost definite outcome, and objectives that you or your business hopes to achieve. For example, opening up a new business outlet, for a large corporation, is a construction project with an almost definite outcome. However, making the new business outlet profitable is a goal that is NOT at all definite. It is a desire that may or may NOT be obtainable. Many of our personal goals, hopes and dreams fall into this indefinite category, which are usually best achieved with very flexible planning.
The JavaScript Devices
Presented for demonstration
Below there is an embedded JavaScript 14 Day Planner-Calendar, and links to five JavaScript devices, which can also be obtained by downloading the zip folder presented several paragraphs above. For an actual project you should use the Excel devices. The JavaScript devices function best for demonstration purposes. Left click on the links presented below to open the device directly in your web browser.
1) Countdown Timer for the Number of Days Remaining to Complete a Project
2) Countdown Timer in Percentages & Days Remaining to Complete a Project
3) A Planner-Calendar for a 14 Day Project
4) A Planner-Calendar for a 14 Day Project, with Percentage Calculations
5) A Planner-Calendar for a 28-Day Project, with Percentage Calculations