How to make a simple calendar?

October 18, 2020 at 19:48:05
Specs: several
I have Windows 10 and Open Office. I expect that one or
the other has what I want. Maybe both.

I suddenly have several things that I need to do every day.
So I want to print out a daily calendar on which I can write
down the time of day I got each of them done, or maybe how
far I walked, or the like. Prolly about 8 items every day.

Which program should I use? Should I use a template or make
the thing from scratch? If I should use a template, where
do I find it and how do I use it? I don't recall ever using
a template before. At least not this millenium.

-- Jeff, in Minneapolis


See More: How to make a simple calendar?


#1
October 19, 2020 at 01:10:18

Reply ↓  Report •

#2
October 19, 2020 at 02:37:46
Here's another site for templates:

https://templates.openoffice.org/en

"Channeling the spirit of jboy..."


Reply ↓  Report •

#3
October 19, 2020 at 11:50:09
I think it really depends on what you want your "simple calendar" to look like.

It could be anything from a bunch of boxes, one for each day, like most "wall calendars".

It could be a single page for each day, with lines for each hour.

It could be a day-planner, with no dates or times, until you fill them in, like this:

https://www.openofficetemplates.com...

Are you really planning to write the tasks on a printed page or would it be better to type them into a form that you can save on your computer and possibly evaluate/organize later? e.g. "percentage of days my walking goal was met". Things like that, which a computer could do for you.

Do you have a vision of what you want to end up with? Maybe with some more details, we could offer something other than random "calendar template" links - which I am guilty of providing also.

message edited by DerbyDad03


Reply ↓  Report •

Related Solutions

#4
October 19, 2020 at 11:52:12
T-R-A wrote:

> Here's another site ...

Actually it's the same site that is linked from the page trvlr
linked to. I wasn't finding a suitable template there, so I was
heartened to see another link... I'll have to keep looking through
them. Funny how so many of those templates were made for a
specific year.

-- Jeff, in Minneapolis


Reply ↓  Report •

#5
October 19, 2020 at 12:05:48
re: "Funny how so many of those templates were made for a specific year."

Again, not knowing exactly what you are looking for, I don't know if this helps, but there are formula based calendar templates that are not made for a "specific year".

For example, this template updates the monthly calendars based on the year you enter in cell A1:

https://binaries.templates.cdn.offi...

Granted, there isn't room to write stuff on this calendar as designed, but some simple formatting changes (e.g. make the rows and columns larger) might make it work.

message edited by DerbyDad03


Reply ↓  Report •

#6
October 19, 2020 at 12:36:46
DD03,

There are about 5-8 things I'm supposed to do every day. The same
5-8 things every day. I would have them printed on the calendar with
a space where I can write in the time that I do each of them.

-- Jeff, in Minneapolis



Reply ↓  Report •

#7
October 19, 2020 at 13:33:56
re: "There are about 5-8 things I'm supposed to do every day. The same 5-8 things every day. "

Those are not requirements that someone could could write a program or template for.

"About 5-8". Does that mean 4 - 8? 5 - 9? 4 - 9? What does "about" mean in a situation where a range was already stated?

Do you mean that there are 8 specific tasks but you only need to do 5 tasks on some days, 7 on others,
8 on others?

Look at the template I linked to. Couldn't that be adapted for your purpose? You enter the text related to your tasks in the appropriate cells, print it out and grab a pencil.


message edited by DerbyDad03


Reply ↓  Report •

#8
October 19, 2020 at 16:33:15
Go to your local Dollar Tree, buy a horse, cat, or puppy calendar for a buck, or maybe a planner, then write your notes in it.
https://www.dollartree.com/office-s...

Reply ↓  Report •

#9
October 19, 2020 at 17:50:38
DerbyDad03 wrote:

> re: "There are about 5-8 things I'm supposed to do every day. The same 5-8 things every day. "
> Those are not requirements that someone could could write a program or template for.

Yes they are. This is trivial.

> "About 5-8". Does that mean 4 - 8? 5 - 9? 4 - 9? What does "about" mean in a situation where
> a range was already stated?

There are exactly 5 things that I currently know I have to do
every day. I expect that there will be a few more. I don't know
how many more, but I'm guessing it won't total more than 8..

But the exact number doesn't matter. It should be trivial -- and
I'm certain that it IS trivial -- to adjust the number of lines in the
calendar to the number needed. I say "about 5-8" so you have
an idea of about how many lines are needed. It is more than
two and less than a hundred. That should be precise enough.

> Do you mean that there are 8 specific tasks but you only need
> to do 5 tasks on some days, 7 on others, 8 on others?

No. But in the real world, not every task is going to get done
every day, and there will always be more tasks that need to be
done that I don't currently plan to pre-include on the calendar,
and some of them might not be every day. So obviously the
calendar needs to be able to handle that sort of thing. I will
make a new printout if I need to add items. Trivial.

-- Jeff, in Minneapolis


Reply ↓  Report •

#10
October 19, 2020 at 19:02:55
You didn't answer the question that I asked:

"Look at the template I linked to. Couldn't that be adapted for your purpose? "

It seems to fit all your criteria:

1 - It is not specific to any one year
2 - You can type in your current 5 items now, and then add more as they come along
3 - You can make the day boxes big enough for both your pre-included tasks and others that might want to write in

I opened (and modified) it in Excel. I assume (dangerous, I know) that it will also work in Open Office. I

I'm sure it will work for 2 or about 5-8. 100 might be a tad cumbersome.


message edited by DerbyDad03


Reply ↓  Report •

#11
October 19, 2020 at 20:40:24
riider wrote:

> Go to your local Dollar Tree, buy a horse, cat, or puppy calendar
> for a buck, or maybe a planner, then write your notes in it.

For the last 30 days I have been writing the date and time on a
sheet which lists the tasks. I figured that I can have the dates
pre-printed, too.

-- Jeff, in Minneapolis


Reply ↓  Report •

#12
October 19, 2020 at 21:35:52
DerbyDad03 wrote:

> Look at the template I linked to. Couldn't that be adapted for
> your purpose? You enter the text related to your tasks in the
> appropriate cells, print it out and grab a pencil.

I don't know. It appears to be just an ordinary calendar layout
with no provision for a list of tasks and comments such as the
time of day that I complete each task. When I type anything
into a cell, it just replaces the date. I don't see how to enlarge
the cells to have multiple lines and/or multiple fields.

Since paper is two-dimensional, I would expect one dimension
might be the date and the other dimension might be the task.
So maybe 365 lines by eight columns. Instead it is pretty much
the usual little square boxes calendar layout. The only thing
slightly unusual about it is that the months go down then across
instead of across and then down, like the days in each month
are arranged.

I used MS Excel for a largish but simple project in 1998, but
otherwise have no experience with spreadsheets. That project
worked fine, but I don't remember any details of how I did it.
I have no idea what to do with this one.

-- Jeff, in Minneapolis


Reply ↓  Report •

#13
October 20, 2020 at 07:15:43
I see. In your OP you said "I have Open Office". I assumed (my bad) that to mean that you were familiar enough with the various apps contained within, specifically Calc, to manipulate a template to fit your needs.

> It appears to be just an ordinary calendar layout
> with no provision for a list of tasks and comments such as the
> time of day that I complete each task. When I type anything
> into a cell, it just replaces the date.

You sort of answered your own question there.

The "provision" that you say is lacking is exactly what you did: You type in the cell. More precisely, you would probably be better off typing in the formula bar. However, unless you know how the spreadsheet works and how to alter the formulas in the cells, you will assuredly have trouble using that template. I was able to make the cells look like the following, but it was far from a straightforward process and I do not think that the method I used is something that I would suggest at this point.

         18
Walk             Time:
Shower           Time:
Eat              Time:
Work             Time:
Sleep            Time:


> I don't see how to enlarge the cells to have multiple
> lines and/or multiple fields.

Again, it's there. There are lots of resources on the web about how to resize cells in Calc, wrap text into multiple lines, etc. However, I no longer think that this template is right for you. Making it work would a be a great learning experience, but probably not the right way to jump back into the spreadsheet world after 2 decades.

> Since paper is two-dimensional, I would expect one dimension
> might be the date and the other dimension might be the task.
> So maybe 365 lines by eight columns.

OK, so there you go, you just solved your problem. Use Calc, put your Dates in Column A, put Column headings in Row 1, and fill in your data as needed.

You will still need to figure out how to resize cells, format them for multiple lines (if needed), center text, etc, so some of the learning experience is still there. You could learn how to AutoFill the dates so you just enter 1/1/2020 in a cell and drag it down to populate Column A for the entire year. After that, insert Rows where required to separate each month, if so desired. Customize the layout to fit your needs and make it look like you want it to.

You could have your basic template set up in a matter of minutes. Come back here if you have questions on how to accomplish specific tasks.

This could open up a whole new world for you! Once the data is in the spreadsheet, you can start to do calculations to track your tasks, set alerts for upcoming tasks, etc.

The world is your oyster!


message edited by DerbyDad03


Reply ↓  Report •

#14
October 20, 2020 at 13:10:44
Thanks.

Thinking about it for a few milliseconds, 30/31 lines makes way
more sense. A month will fit on a sheet of paper. A year won't.
The sheet I've been using is getting real crowded, and it is
exactly one month today.

-- Jeff, in Minneapolis


Reply ↓  Report •

#15
October 20, 2020 at 13:38:28
You can set up 1 sheet for each month in Calc.

Create one sheet for January as your template and then copy it 11 times.

On Sheet1...

1 - Enter a date in your first date cell, e.g. enter 1/1/2020 in A2. (The date can be formatted any way that you like, just make sure that Calc sees it as a date)

2 - In A3, enter =A2+1 and drag it down. 1 is equivalent to a full day when adding to a date, so you should see 1/2/2020, 1/3/2020, etc. as you drag the formula down.

3 - Enter your tasks in Row 1, starting B1 as shown below

4 - Copy this sheet 11 times and alter the date (month) in A2 of each sheet. All the other dates should update automatically since they are based on the formula. Delete the extra dates at the bottom of the list as required.

(The extra dates could be eliminated by formula, but I'm keeping it simple and suggesting you do it manually at this point.)

Your sheet might look like this:

       A             B          C         D         E         F    
1                   Walk      Shower     Eat       Work     Sleep
2   1/1/2020
3   1/2/2020
4   1/3/2020

There is a whole bunch more that you could do, but in terms of a "How to make a simple calendar?" it doesn't get much similar than that.


message edited by DerbyDad03


Reply ↓  Report •

Ask Question