Markdown Numeric List

When we read texts – whether online, in a newspaper or a printed book – we expect a certain format. Particularly important words are set in bold, a heading stands out from the rest of the test, and a structured list makes the text clearer. We consider this formatting to be obvious – and when we write a text on the PC ourselves, we can usually do so without any problems: from adjusting the font size and adding bullet points to making words bold. Any word processing program offers users a wide range of options for arranging their text.

But this is by no means a matter of course. Generally, in these situations you mark the text and the software then displays it how you wish. You don’t actually get to see the source text itself, including the markup elements (markers), with Word and similar programs. And if you did, you probably wouldn’t know what to do with it: This code can scarcely be read by people.

Languages like HTML or LaTeX can be written with any text editor, but they aren’t easy for people to decipher. The simplified markup language Markdown seeks to change exactly that. It wants the best of both worlds: to be understandable for both people and machines. Markdown uses self-explanatory elements to format the text. This means the text is relatively easy for people to read.

Markdown tutorial: The right syntax for your documents

List and comparison of Markdown editors. Side by side comparison and short reviews of Markdown editors. View and Download JRC JLR-7500 instruction manual online. JLR-7500 gps pdf manual download. Also for: Jlr-7800, Nwz-4740.

Pmhstylecollection Member List.
Turn your analyses into high quality documents, reports, presentations and dashboards with R Markdown. Use a productive notebook interface to weave together narrative text and code to produce elegantly formatted output. Use multiple languages including R, Python, and SQL. R Markdown supports a reproducible workflow for dozens of static and dynamic output formats including HTML, PDF, MS.
Note: The instructions from this guide are referring to the Classic Editor. If you are using the WordPress block editor, please see this guide. See the Markdown page for instructions on enabling Markdown for posts, pages and comments on your blog, and for more detailed information about using Markdown. Markdown Processed Emphasis.Emphasize. emphasize.

What is Markdown used for?

Just like HTML or LaTeX, Markdown is a markup language. In contrast to these examples, however, Markdown aims to be as easy as possible for people to read. Each markup element is closely related to the actual meaning, rather than being abstract. This can be shown most easily with an example: If you want to highlight a word in bold in HTML, you can either use the '<b>' or the '<strong>' tags.

If you write a document in LaTeX, use the element textbf (in continuous text mode).

Although both can be read relatively easily, they are harder to write – particularly when it comes to longer texts. Markdown simplifies this by marking bold passages with asterisks.

On the one hand, this version is easier to read as the asterisks make the bold text clear, and on the other hand, the four characters can be typed much quicker than tags. Even without converting (i.e. in plain text), a reader can easily determine what the author means – even without understanding the Markdown syntax.

This makes Markdown appealing particularly to users who don’t have a background in IT or web design skills, but still want to write texts for the internet regularly : for example, bloggers who work with a content management system (CMS). But even tech-savvy people resort to Markdown for writing simple texts. For instance, some programmers use the Markdown language to write supporting documents (e.g. readme files) that aren’t converted. Whether the user opens the text in a Markdown viewer or reads it in its raw state, there’s barely a difference in terms of readability.

For the most well-known CMSs like WordPress or Joomla, there are plugins that enable systems to understand Markdown. Many wikis, forums (such as reddit), and the website generator Jekyll can also work with the simplified markup language.

Markup languages are not considered to be programming languages. The former are only intended to define how a text is to be structured. Conversely, programming languages are characterized by loops and variables, forming the basis for writing software.

Markdown does not attempt to replace HTML – its creative possibilities are far too limited in any case. The developers of the language instead view Markdown as a complement. It’s possible to insert HTML elements into a Markdown document, thereby expanding the range of the relatively basic language. However, the Markdown language is intended primarily to simplify writing (especially online). When Markdown documents are converted by the parser, documents such as HTML documents are created to enable display in browsers.

The name “Markdown” is a play on words. Although a member of the “markup languages,” the name Markdown makes it clear that it concerns a down-scaled language.

Markdown tutorial: The right syntax for your documents

Since Markdown aims to be as simple a markup language as possible, the Markdown syntax is also virtually self-explanatory. Nonetheless, you first need to familiarize yourself with the markup elements before you can use it. We’ve compiled the most important functions for you.

Bold & italics

Markdown makes it especially easy to create bold and italicized text. Only asterisks are required to this end. To write in italics, add an asterisk before and after the word or words. For bold text, use two asterisks – and if you want a text to be both bold and italicized, three asterisks are necessary. Alternatively, you can use underscores.

Strikethroughs

In order to create a crossed-out text, use the tilde in Markdown twice in a row, followed by the respective text and then another two tildes.

Text can’t be underlined in Markdown. Although this is possible using the '<u>' tags in HTML, it’s usually inadvisable to do so. That’s because underlined text is used for hyperlinks online and it’s best to avoid confusing the two uses.

Headings

To create a heading in Markdown, a pound sign is typically used. It’s inserted with a space before the corresponding text. To create headings that are lower in the hierarchy and thus smaller, extra pound signs are added. This enables up to six levels of headings, just like in HTML.

Some users also insert pound signs after the headings. This can increase the readability but is not technically required. These signs are simply ignored in the conversion process.

Alternatively, equals signs and hyphens can be used to mark headings. These are inserted in the line below the actual heading. This option only allows you to create two different sizes of headings. One sign per heading is plenty, although multiple consecutive signs can often be seen. This is purely based on visual reasons since it looks as if the text is underlined once or twice.

Paragraphs

The Markdown language works with hard line breaks to separate paragraphs from each other. To create a completely new block of text (

tag), simply add an empty line. Important note: for Markdown, it’s sufficient if the line is visually empty. So if the line contains white spaces like tabs or spaces, the parser will ignore them and consider the line to be empty. If you want to create a line break like the
tag, add two spaces at the end of a line.

Quotes

In Markdown, quotes in a certain part of the text are indicated using a blockquote element. The greater-than sign is used for this purpose (>). You have the option to either mark each individual line with this sign or to insert it only at the beginning of the paragraph and to end the indented passage with an empty line. Additional formatting elements are possible in the blockquote element.

Lists

To create an unsorted list in Markdown, you can use either the plus sign, the hyphen or an asterisk. All three ways produce the same result.

Conversely, a sorted list is generated by a number directly followed by a period.

Interestingly, the actual number is irrelevant in Markdown. Even if you write “first” three times or start with “third”, the Markdown language will always begin the list with the correct number.

Markdown also gives you the option of creating checklists. These appear with a box that can be activated by clicking on it. You can also add a checkmark when creating the list. To do so, insert square brackets and an X.

It’s important that you remember to leave a space between the square brackets for empty checkboxes. Otherwise, Markdown won’t recognize your text as a list.

Code

To mark a text as code in Markdown, a backtick – also known as an accent grave – is used (not to be confused with a simple quotation mark). The text is marked with a backtick at the start and end of the relevant passage. This enables source code or software commands to be incorporated directly into the running text.

When writing the code, take care not to accidentally insert an accent grave: à. This occurs automatically when you type a vowel after the sign. You can avoid this problem by first pressing the space bar after the backtick and then writing the vowel.

If a backtick is used in your code example itself, you can also use the sign twice at the beginning of the code section. In this case, Markdown will not interpret the simple backtick as an instruction.

To mark an entire block as source code, you can either use a tab or four spaces – for each line. You can indent the selected lines further by adding more tabs or spaces.

If you’d prefer to use signs to start and end code blocks, you can also mark the corresponding passage with three backticks at the start and at the end. Here you also have the option – at least with many Markdown editors – to create color highlights automatically. To do so, enter the language of the following source code after the three introductory backticks.

Images & hyperlinks

Markdown can likewise be used to integrate images and hyperlinks in your text. Both are created with a combination of square and round brackets. You can generate a link by placing the anchor text – i.e. the words or phrases visible in the text – in square brackets and inserting the URL in round brackets directly afterwards. If you’d like to give the hyperlink an optional title that the user can see in the mouseover, this is also possible: Enter the text in the round brackets, separated from the URL with a space and put in double quotation marks.

If you want to include a URL or an email address in the normal running text, most Markdown editors automatically create a clickable hyperlink. But to make sure this happens, you can insert a less-than and greater-than sign. To prevent this automatic editor feature, however, you should mark the URL as code and use backticks again.

As with hyperlinks, images can also be added to the Markdown document. To add images, start with an exclamation mark. Afterwards again insert square brackets which contain the alternative text for the image and round brackets with the image URL. This is then directly displayed in the text.

Of course, you can also link to HTML pages or images on your own server. If the current document is located on the same server, relative paths suffice.

Images and hyperlinks can also be combined. To create a clickable link behind an image, you can nest the two functions together. In this case, the image becomes the anchor text and thus appears in the square brackets.

Tables

Pipes (|) allow tables to be drawn in Markdown. Each cell is separated by a pipe. To create the header rows that are visually distinct from the rest of the content, you highlight the corresponding cells with hyphens.

In principle, it’s not important that the pipes are located one below the other. This only increases the readability when the Markdown document is viewed in its raw version. The same applies to pipes located to the side. These are likewise inconsequential for the compiling process.

Footnotes

Markdown gives you the option of inserting footnotes. You can write a reference number in the running text and link to the footnote at the end of the page – a corresponding line is created automatically. The reference number is also formatted as a hyperlink. Clicking on it leads directly to the relevant footnote. To use this automatic function, you should first insert the reference number after the respective word. In square brackets, you first write a circumflex and then the number.

The number you use (other terms are also possible) does not matter. Just like when creating lists, Markdown automatically performs the counting for you. However, it’s important that you correctly link to the reference again for the footnote. Add the same number to a new line with a circumflex in a bracket, insert a colon and then write the actual footnote. It can also be fully formatted and encompass multiple lines.

You can actually add the note anywhere in the text. Markdown will always display it at the end of the document. To close the note and return to the actual running text, insert an empty line.

& and <>

Since Markdown is closely related to HTML, the “and” symbol as well as the less-than and greater-than sign deserve special attention. These signs are used in HTML to open and close tags (<>) or to work with entities (&). But if you want to use the signs for their original purpose, they have to be masked in HTML: &, < and >. In general, there’s no reason in Markdown why you can’t use the signs “as they are”. However, since users have the possibility of mixing up Markdown with HTML, this is more complicated in practice. The parser understands when you want the simple characters and when you want HTML code so you don’t need to solve this problem yourself.

Backslash masking

Besides the specific characters involved in HTML, Markdown also uses certain symbols as markups. When you insert them, the parser will respond to them during conversion. This pertains to the following signs:

Asterisk: *
Hyphen: -
Underscore: _
Round brackets: ()
Square brackets: []
Curly brackets: {}
Period: .
Exclamation mark: !
Pound: #
Accent grave: `
Backslash:

To use these signs for their original purpose, simply add a backslash in front of them. Important: The backslash must be entered before each individual sign, i.e. before an opening bracket and before a closing bracket.

Would you like to try Markdown yourself? Find out which program is right for your system in our article on Markdown editors.

Related articles

Содержание

1 Excel To Do List Templates (Free Download)
4 To Do List Templates (Excel)

You start your day. Plan some tasks. Write it down somewhere and start working on it.

When it’s way past your work time, you think about that to-do list (stare at it if you have it written) and curse the world for not having enough time in the day.

Sounds familiar?

If you are nodding your heading in agreement, you – my friend, are suffering from an acute condition of expanding-to-do-list.

Well, I am neither a brain doctor nor a self-help guru. I can not help you in overcoming procrastination and getting your work done.

BUT…

I can give you an Excel To Do List template that can handle your ever-expanding list (you will still have to make one and do all the work).

Jokes aside, I do believe it is helpful when you maintain a to-do list. I create one every morning, and on some lucky days, I also get the pleasure of checking off most (if not all) the items.

Excel To Do List Templates (Free Download)

Here are the four Excel To Do List templates you can download: Workplace by facebook download for mac.

A Simple printable Excel To-do List.
To-do List with drop downs to mark a task as complete.
To-do List where you can check a box to mark a task as complete.
To-do List where you can simply double to mark the task as complete.

Excel To Do List Template #1 – Printable To Do List

This one is for people like me.

I like to print my to-do list and stick it right in front of my eyes and then work on the items on the list.

Here is a simple Excel template where you can fill the tasks and take a print-out. If you prefer writing the tasks yourselves, simply print it first and then fill in the tasks.

There is a separate column to mention date and comments (if any). If you don’t need it, delete these columns before printing.

Download simple printable to-do list template

Excel To Do List Template #2 – With Drop Down List

If you prefer making and maintaining the To Do list in Excel itself, you are in for a treat.

Here is an Excel To Do List template where you can:

Additional Notes:

The weights are given as follows (in the pic below). If you want to change the weights, you can easily do it by changing these values. In the download file, columns G to J are hidden. Unhide it to change the weights.
To calculate progress using the progress bar, we calculate:
- Total Score: Add all the weights for all the activities. For example, if there are 2 high priority tasks and 1 medium priority task, and 1 low priority task, the total score would be 14 (5+5+3+1).
- Completed Score: Here we add all the weights for all the activities that are completed. For example, if out of 4 activities, 1 high priority activity has been completed, then the Completed Score would be 5.
- % Completed: The value when we divide Completed Score with Total Score. For example, in the above case, it would be 35.7% (5/14).

Download to-do list with drop-downs

Excel To Do List Template #3 – With Check Boxes

This template is exactly like the one with drop downs, with a minor difference – it has checkboxes instead of the drop-down.

You can mark the task as complete by checking the checkbox. If not checked, it is considered incomplete.

Here is how you can use this Excel To Do List Template:

NOTE: Be careful while adding deleting rows. Deleting a row does not delete the checkbox.

Download to-do list template with checkboxes

Excel To Do List Template #4 – Double-click Enabled

I find this version of the template the best of all.

It uses a small VBA code to enable the double click event where you can mark a task as completed by simply double-clicking on it.

NOTE: Since this contains a VBA code, it should be saved in .XLS or .XLSM format.

Here is how you can use this Excel To-do List Template:

Download Excel Template To Do List #4 – Double Click Enabled

NOTE: Since this template contains a VBA code, when you open it, Excel will show a prompt to enable content. You need to enable it for this to work.

So here are 4 Excel To-do list templates that I find useful and often use while planning my work.

Common Use Cases of Using these To-do list templates

While I have shown you the example of common daily tasks, you can use these to-do list templates in many different ways.

Here are some use cases that come to my mind:

Project Management Checklist: Since a project can have many moving parts to it, creating a daily or even weekly/monthly to-do lists can help you keep a tab on all the important stuff.
Client onboarding checklist: You can create a quick client onboarding checklist and hand it over to your sales/customer executives. This will make sure a client gets seamless and complete onboarding experience.
Grocery checklist: While it may sound weird to create one in Excel, I have seen people do this. This has become more useful now that we can order stuff groceries online in a few minutes.
Event Management Checklist: Event management can get crazy and out of control if not planned well. A handy to-do list can save you (and others) a lot of time and money.
Travel Itinerary and Packing checklist: I love to keep my traveling hassle-free by having a to-do list of stuff that needs to be done (bookings, visa, tickets, etc). You can also create a packing list to make sure you don’t leave important stuff behind.
Blog Publishing Checklist: I have created a to-do list to make sure I don’t miss out on the important parts when publishing a blog post on this site. These tasks include doing grammar and spell-check, making sure titles are correct, images are present, tahs and categories are assigned, etc.

What goes into making the Excel TO DO List template?

There is no rocket science at play here. Simple Excel techniques come together to make it happen.

Here are the components that make these templates:

Conditional formatting (to highlight a row in green when a task is marked as completed).
Strikethrough Format (appears when a task is marked as completed).
Excel Drop-down Lists (to show the status in the drop-down).
Check Boxes (to mark a task as complete by checking it).
VBA (to enable double click event).
Excel Charting (to create the progress bar).

I hope these templates will help you become more productive and save some time.

I am sure you also have tons of To-do list success/failure stories and I would love to hear it. I am waiting in the comment section 🙂

Other Excel Templates You Might Like:

To Do List template Integrated with Calendar in Excel.
Task Prioritization Matrix Template in Excel.
Shared Expense Calculator in Excel.
Employee Timesheet Calculator.
Vacation Itinerary and Packing List Template.

A to-do list is very important in ensuring that you conduct all of your important daily activities. One of the character traits of humans is being forgetful, so sometimes you can come to the end of the day only to realize that you forgot a certain task. A to-do list does away with all the possibilities of forgetting something that you wanted to do. Examples of to-do lists that you can have include shopping, work, assignments and targets to meet. Luckily, you can create your own to do list using Excel from your computer. This article shows you how you can create a to-do list with checkboxes using excel.

Steps to Creating a To Do List in Excel

To create your To Do list effectively, follow the steps below:

Depending on the to do list that you want to create, open Excel application and add relevant column headers. These may include tasks, priority, status, due date and done/completed.
After creating the column headers, fill them with relevant information. This includes all the tasks that you want to accomplish in order of their relevance.
At the Home tab, highlight the column headers then click on the center icon to center the highlighted text.

Adding check boxes in your to-do list

Your to-do list is more fun and easier to accomplish if you add check boxes. These will remind you of the tasks that you have not accomplished easily. Here is how to add check boxes to your to-do list:

Click on File> options then select the customize ribbon located in the pop-up box.
Looking at the right side where the Main Tabs are located, you will see a box next to Developer. Click on it, and you should see a new developer tab added to your excel file.

On the Developer tab, click insert and select the checkbox option.

4. Click on the area where you want your checkbox to appear, and it will automatically do so.

To enable editing, right click on the text. You can use the provided text or delete them and add yours. You can also resize the boxes at this stage.
After putting your checkbox in a cell, click on it and drag down to the other columns so that you can auto-populate the checkboxes.
Create a formula that will help you determine whether the information put on the check boxes is true or false.

To Do List Templates (Excel)

Download

Task To Do List Template

Download

To Do List with Due Date (Excel)

Download

Priority To Do List Template (Excel)

Download

Conclusion

To do lists are very important in helping to work on all of your day’s tasks. Fortunately, you can create one using excel as shown above depending on what you want to achieve.

One of the best ways to learn new techniques in Excel is to see them in action. This post demonstrates how to add some fun and useful features to simple to do lists including drop-down lists, check boxes, progress bars, and more. The images show Excel 2016, but instructions are similar for Excel 2010 and Excel 2013.

1. Simple Drop-Down Lists via Data Validation

Many task lists include a Priority or Status column, such as the Homework To Do List shown below. It’s very handy to use an Excel drop down list for columns like these.

To create a simple drop-down list, follow these steps:

Select the cells you want to edit
Go to Data > Data Validation
Choose «List» in the Allow field
In the Source field enter a comma-delimited list such as High,Medium,Low

2. Conditional Formats for the Priority Column

In the example above you will see that the values in the Priority column have been highlighted differently. This can be done automatically and is a great way to easily identify your high-priority tasks. Follow these steps to create the type of formats shown in the example above.

Select the cells in the Priority column
Go to Home > Conditional Formatting > Text That Contains
Enter the word high and choose the «Light Red Fill with Dark Red Text» option

The image below shows how to get to the correct option from the Home tab.

3. Conditional Formats for Numeric Priority

If you want to use a numeric priority like 0-4, then you can use Icon Sets to display images instead of (or in addition to) the numeric value. You can see this demonstrated in the Simple Task Tracker below.

Select the cells in the Priority column
Create a drop-down list with the options 4,3,2,1
Go to Home > Conditional Formatting > Icon Sets > More Rules
The image below shows you how to modify the settings for this rule.

4. Checkboxes using Form Fields

I don’t like this method. If you like to sort and delete and insert rows, form fields get all messed up. They may be nice for a spreadsheet layout that is not meant to be modified, but so far I haven’t found a to do list that I haven’t wanted to modify frequently.

The form field checkbox is found in the Developer tab shown in the image below. If you don’t see the Developer tab, go to File > Excel Options > Customize Ribbon and find and check the Developer tab.

5. Checkboxes via Data Validation

I wish Microsoft would add an in-cell checkbox feature (Apple’s Numbers software does it), but until they do that we have to come up with clever alternatives.

One method I like is using a data validation drop-down list because it works pretty well in Excel on touch-enabled devices, and it is also compatible with most versions of Excel and OpenOffice and Google Sheets.

The simplest checkbox to make using a drop-down list is probably just a list with a single character (x), or you could use a special character like the square root sign (√) that looks like a check mark in some fonts. In the example below, I’ve used this technique plus a small square ascii character (□,√).

Another approach that I really like is to use custom Icon Sets via Conditional Formatting. This isn’t as compatible with other spreadsheet programs (like Google Sheets) but it looks good. The simple Task Tracker Template shows an example of this:

Select the cells you want to use for the check boxes
Create a drop-down list with the options 1,0,-1
Go to Home > Conditional Formatting > Icon Sets and select any set you like
With those cells still selected, go to Home > Conditional Formatting > Manage Rules and find the rule you just created and edit it to create a custom icon set with the setting shown in the following image.

One password iphone. Another example that uses this technique is my Financial Plan Summary template.

6. Progress Bar for % Completed

In some of the examples above, you’ve already seen progress bars in the «% Complete» column. Now you’ll learn how to do it. Conditional formatting comes in handy yet again:

Select the cells in the % Complete column
Go to Home > Conditional Formatting > Data Bars > More Rules
Modify the bar based on the settings shown in the image below

What a Progress Bar in Google Sheets? No problem. In cell A1 enter the % Complete and then in the cell to the right of it you can use the formula =REPT(«█»,ROUND(A1*10,0)). You can change the color of the bar by just changing the font color. That’s a pretty old trick for Excel users, but it’s something that will work in Google Sheets, too.

7. Gray-Out Tasks When They are Complete

If you like the effect of seeing your completed tasks crossed out or grayed out or both, you can do that fairly easily using conditional formatting.

In the example below, the first rule is applied when column A is equal to the special square root character. The placement of the dollar sign in the $A4 reference is very important in this formula because we want all the columns in the table to reference column A.

Also note that the first rule has the «Stop if True» box checked. That is why you don’t see the priority cell highlighted red or the % Complete showing a green bar in the example. When the task is marked as complete, I don’t want to be distracted by formatting that no longer matters to me. So I’m using the rule order to prevent the following rules from being applied if the task has been marked as done.

8. Highlighting Overdue Dates

When you have a Due Date, you may want to highlight the date when it is overdue. You can do that with a simple conditional formatting rule shown in the example below. Evernote journals with smart stickers.

You can see an example of this in the Homework To Do List shown at the very top of this article.

9. Autofilter and Sorting

The little arrows that show up in the header of an Excel table or list are a result of turning on the Filter Button feature. If you don’t see the little arrows in the header row already, select a cell in your table (or the entire table) and go to the Data tab and click on the Filter button.

10. Create a Gantt Chart

Although a Gantt chart is a great visualization and management tool for projects, creating one from scratch is not nearly as simple as the other ideas shared in this article. The two most common ways to create a Gantt chart in Excel are (1) using a stacked bar graph chart object and (2) using conditional formatting. Visit my Task List Templates page to find an example that uses a chart object and try the free Gantt Chart Template to see the conditional formatting technique in action.

11. Drop-Down with Current Date

Update 10/9/2018 — I recently created a new wedding checklist where a user requested the ability to enter either a checkmark or the current date. To do this with data validation, create a list somewhere in the worksheet with the first cell containing a check mark unicode character ✔ and the next cell containing the formula =TODAY().

Then, use data validation to create a drop-down list referencing those two cells. This will allow you to select either a checkmark or the current date as shown in the image below.

To avoid having Excel show warnings when cells contain older dates, make sure to turn off the warnings and errors when setting up the data validation.

Небольшое Excel-приложение, эмулирующее простой To-Do-лист сделанную в духе матрицы Эйзенхауэра.

Позволяет наглядно отслеживать задачи — что нужно сделать, что делается и что сделано.)

Задачи, в зависимости от статуса реализации, записывается в ячейку нужной цветовой зоны. Задачи можно переносить из одной зоны в другую — для этого просто нужно навести курсор на границу ячейки и перетащить, зажав левую кнопку мыши.

Чтобы вообще удалить задачу, нужно просто выделить ячейку с ней и нажать на клавиатуре Delete. При добавлении/удалении, а также изменении статуса задач окрашивание ячеек происходит автоматически. Собственно, тут и понадобились макросы. 🙂

Тип данных во всех ячейках на листе — многострочный текст. Используйте комбинацию Alt + Enter, чтобы создавать заметки из двух-трёх строк.

Рабочая область разделена на 4 зоны:

Зелёная — важно и несрочно — планируемые важные задачи. Самый главный квадрант. Спокойное планомерное выполнение задач из этой области ведёт к достижению целей.
Жёлтая — важно и срочно — текущие задачи, которые необходимо выполнить прямо сейчас. Необходимо всячески стремиться, чтобы этот квадрант был пустым, т.е. откладывать все второстепенные дела и выполнять важносрочные задачи.
Серая — неважно, срочно — Небольшие задачи, возникающие в течении дня и способствующие решению важных задач из жёлтой или зелёной области.
Чёрная — неважно, несрочно — несущественные несложные дела, которыми мы занимаемся лишь бы не выполнять задачи из других квадрантов.

В основной области автоматически выделяется красная подобласть. Её размер зависит от жёлтой зоны.

Следует обратить внимание на эту область. Она логически определяет центр и влияет на раксраску квадрантов. Значение ячееек этой области нельзя менять (по тексту всех 4-х ячеек макрос идентифицирует логический центр, если текст изменить, то идентификация станет невозможной).

Однако при этом разрешается перенести центр. Для этого необходимо выделить одновременно все 4 ячейки, навести курсор на границу ячеек и перетащить эту группу ячеек в другое место. В соответствии с новым расположением изменится расцветка квадрантов, которые изменятся в размерах.

Ссылки

Скачать excel-приложение «To-Do» с Гугл-Диска

Musadya

November 5, 2011

Other

Markdown Ordered Sub List

There are several to do list templates that you can find as part of my excel templates. For example in my daily planner template and gantt chart template. But, if you need a more simple and standalone to do list template, you can use this one. I called it simple because there is no time or date references inside this template. There are only task name and completion status that you have to fill. It is will be more suitable for kind of jobs or tasks that have to be finished without any strict completion time or date or to be finished within one day or short period of time.

There are two kind of templates available. The first one is a single to-do list where it is more suitable to be used for single person. Inside it, there are 26 rows that you can use to fill your tasks. There are no excel formula inside the table. Just type the number, type your tasks name, and type a completion status once you finished your tasks. You can put word “done” or type “v” or any other characters. Remember to leave the status column blank when the tasks are not finished yet. The reason why you have to leave it blank, because the completion bar on top of the table will calculate the percentage of finished job by counting the number of columns that is not blank. You can modify this excel formula to suit your needs.

The second one is the team to do list. Basically, it is an aggregation of single to-do list templates with additional summary where you can see accomplishment of any members in this team. For example, it can be used to monitor the performance for any voluntaries project that is held in one day. Or, it can be used to measure performance of its member for doing the same job within the same period of time. To use this template is the same with the first template, except you can switch between to-do list from summary worksheet by selecting it from the column name. You can download both templates below which is only can be opened if you are using Microsoft Excel 2007 or 2010.