Outside the box — but inside the grid. This is actually inspired by a use-case I saw a Dodeca customer present on at Kscope this year. Create a workout plan. Create a list of your favorite movies — and even make a calendar.

Author:Mosar Vudorn
Language:English (Spanish)
Published (Last):20 June 2010
PDF File Size:20.29 Mb
ePub File Size:3.91 Mb
Price:Free* [*Free Regsitration Required]

Outside the box — but inside the grid. This is actually inspired by a use-case I saw a Dodeca customer present on at Kscope this year. Create a workout plan. Create a list of your favorite movies — and even make a calendar.

The user is going to be able to select a month and year from Dodeca selectors and the calendar will dynamically update. The first thing we need to do is create a dynamic calendar in a spreadsheet. In this case, I want to be able to have two input cells the year and and month and then generate a properly aligned calendar based on that.

Like this:. After a bit of searching I found an incredible step-by-step guide on setting up the formulae for a dynamic calendar in Excel that I started with. This is a great start to the calendar: we can now get a properly laid out month for any combination of year and month. For example, in the above screenshot, the title of the calendar is just a concatenation of two other cells the month and year.

If one of the parameters to the date function, however, is not a number, then the function fails and anything dependent on that cell will also be invalid. So I want to point out a small but useful technique I am using that helps me get around this issue without having to constantly change tokens back and forth. I have my selector tokens in column B cells B1 and B2. I also did this for the [T.

Year] token in cell D1. With this small technique, I can develop my report as normal and keep it tokenized, instead of having to look at something like this:. Now the template looks like this:. In Dodeca, commentary is a first class citizen with extensive configuration options. I could certainly employ that approach here. Remember the extra row and column I put into the template earlier shown here as row 4 and column J :. We need a value to generate a unique address for any given cell in our calendar.

Getting the number of the day of the month is a little trickier. Additionally, the unique Row number is 3, which in this case is 4 columns to the right. Say what?

The ACell function is very common, and it gives us a reference to the active cell being evaluated. Additionally, ColL gives us the column letter for a given column, and CCol gives us the numeric value of the current column.

In column G, the row ID values are only three columns to the right. Now, nicely enough, the values in column J the row IDs happen to also tell us how many rows up the day of the month is from a given cell.

For example, in cell F11 orange , the numeric day of the month is three rows up, in the same column. The rest of the formula is just generic string concatenation and referencing named ranges I created for the year and month. Comment Range configuration for dynamic comment calendar. Next up is this interesting SequentialRanges option. Recall that we can have multiple comment range definitions in a view. But what if I want to have one comment range definition that can handle multiple defined ranges in my worksheet?

One of the comment named ranges on the calendar. Notice that it is called Comment. Each row in the calendar table has a similar name Comment. By turning on the SequentialRanges option, I can have this single definition apply to all of the different named ranges, so long as I name them with the proper suffix.

Again, there are many, many ways that you can use Dodeca to setup a view such as this. So this is a really powerful option that saves me from having to make six almost identical comment range definitions.

The other minor options regarding the indicator should be pretty self-explanatory. Last up is the Linking category of options. You may have noticed that due to the nature of a calendar, there are several cells at the beginning and end that are likely to be blank.

Check this formula out:. Our condition string for seeing if comments should be active for a cell. Things are looking good!

Sure enough, everything looks to be in the proper place and was updated. When I flip back to December , I see that my comments have loaded in as expected. This was a very technical post that covered a lot of ground. These techniques can and are used every day by many others to facilitate business processes around the globe. Your email address will not be published. Dynamic Calendar in Excel The first thing we need to do is create a dynamic calendar in a spreadsheet.

Like this: A dynamically generated calendar in Excel. Formulae used for dynamic calendar. Formatting the dynamic calendar a bit. Cleaned up calendar template. Leave a Reply Cancel reply Comment Your email address will not be published.


Mode Dodeca

Mobile App notifications. Email Notifications. We encourage you to use comments to engage with users, share your perspective and ask questions of authors and each other. Perpetrators of spam or abuse will be deleted from the site and prohibited from future registration at Investing. Breaking News.


jason's hyperion blog

Dodecatemoria are subdivisions of the twelve signs of the Zodiac into a further twelve parts each. These can be said to form a "micro-zodiac" of dodecatemoria, each corresponding to 2. In an alternate usage, the dodecamorion refers to a point on the ecliptic reached by the addition of twelve times a given number of degrees within a sign, either to the original degree, or to the beginning of the sign. This system, used in Hellenistic astrology but less favored by later ages, apparently originated in Babylonian astrology. Within each sign, the dodecatemoria are arranged beginning with the sign itself and proceeding in the normal order.


Download a 12 sided calendar



Dodeca (0P0000X9ZH)


Related Articles