Earlier I was planning when my breeding pairs would be nesting using Google Calendar when I realized I needed a better way to track my nesting plans.
I remember seeing an image of somebody using a gantt chart style calendar, so I found a calendar template and modified it specifically for nest planning purposes.
[url=https://docs.google.com/spreadsheets/d/16GUlJvRrZz16GONMHIqaqdFJ7XlEWb90jqO-ZseBlus/edit?usp=sharing][size=6][u]And here's the result~[/u][/size][/url]
[img]http://i.imgur.com/y5LauLi.png[/img]
Modified from: [url=https://drive.google.com/previewtemplate?id=0AhHqLwIA4drSdEhMbXN5NGJxRjF2dzVRSnVmdVhIeVE&mode=public]90 Day Planner By Nick Rosenberg[/url]
Please feel free to make a copy and use it if you like it! ^^
---
[u][b][size=4]Updates (in FRT)[/size][/b][/u]
- 22 Nov, 6am : Added conditional formatting to highlight the current date, and to color the hatch dates differently.
(=^_^=)
Earlier I was planning when my breeding pairs would be nesting using Google Calendar when I realized I needed a better way to track my nesting plans.
I remember seeing an image of somebody using a gantt chart style calendar, so I found a calendar template and modified it specifically for nest planning purposes.
And here's the result~
Modified from:
90 Day Planner By Nick Rosenberg
Please feel free to make a copy and use it if you like it! ^^
---
Updates (in FRT)
- 22 Nov, 6am : Added conditional formatting to highlight the current date, and to color the hatch dates differently.
(=^_^=)
|
|
-
|
Free-to-Use
Arcane House
Cup Cacti!
Click -->
|
|
@
shizuyue
This is quite interesting. I'm trying it out now. Thank you!
@
shizuyue
This is quite interesting. I'm trying it out now. Thank you!
|
|
|

[/center]
|
@
Amut
Thank you for trying it out! Please don't hesitate to give any feedback you have. ^^
@
Amut
Thank you for trying it out! Please don't hesitate to give any feedback you have. ^^
|
|
-
|
Free-to-Use
Arcane House
Cup Cacti!
Click -->
|
|
@
shizuyue
This is a great idea. I'm about to start a hatchery, so this will be helpful. I did tweak it a bit for myself; I'm American so the dates were confusing me for a minute, I eliminated the need for the "backend" sheet, and I fussed around with the conditional formatting a bit so that it highlights the current date and the hatch day in the calendar. Thanks for this!
@
shizuyue
This is a great idea. I'm about to start a hatchery, so this will be helpful. I did tweak it a bit for myself; I'm American so the dates were confusing me for a minute, I eliminated the need for the "backend" sheet, and I fussed around with the conditional formatting a bit so that it highlights the current date and the hatch day in the calendar. Thanks for this!
@
meiloslyther I'm glad you find it useful! :O You managed to highlight the current date and the hatch day? That's great! I'm trying to do that too but my brain cell has been abandoning me. :( Would you mind sharing how you do it to me?
@
meiloslyther I'm glad you find it useful! :O You managed to highlight the current date and the hatch day? That's great! I'm trying to do that too but my brain cell has been abandoning me. :( Would you mind sharing how you do it to me?
|
|
-
|
Free-to-Use
Arcane House
Cup Cacti!
Click -->
|
|
@
shizuyue
Sure thing! It's really nothing fancy, especially the current date. The hatchday highlighting is slightly trickier but still pretty standard stuff. Just gotta watch your $'s. I've done way more complicated and frustrating coding in my lair companion, tbh. (The things I do to make my dragon experience more streamlined...)
https://docs.google.com/spreadsheets/d/1HnBrNU_UXoqMFrtqqAIAOI22SsUSPNouoq4Pebs-xho/edit?usp=sharing
@
meiloslyther I love your edits the the planner! And that rainbow color is so nice. Would you mind if I modify and add the highlighting of current date and hatchday into the template?
I get what you mean about streamlining your dragon experience. Thank goodness there's already so many good spreadsheets for lair management or I'll be so doomed.
@
meiloslyther I love your edits the the planner! And that rainbow color is so nice. Would you mind if I modify and add the highlighting of current date and hatchday into the template?
I get what you mean about streamlining your dragon experience. Thank goodness there's already so many good spreadsheets for lair management or I'll be so doomed.
|
|
-
|
Free-to-Use
Arcane House
Cup Cacti!
Click -->
|
|
@
shizuyue
Not at all. Hopefully others find it helpful too.
@
shizuyue
Not at all. Hopefully others find it helpful too.
@
Amut Sorry for the ping but there is a little update where I added conditional formatting to the template to highlight current date and color the hatch date differently. Do let me know if you don't wish to be pinged in the future. ^^;;
@
Amut Sorry for the ping but there is a little update where I added conditional formatting to the template to highlight current date and color the hatch date differently. Do let me know if you don't wish to be pinged in the future. ^^;;
|
|
-
|
Free-to-Use
Arcane House
Cup Cacti!
Click -->
|
|
@
shizuyue This is awesome! I'd love to be on the pinglist if there are any updates! Works wonders!
@
shizuyue This is awesome! I'd love to be on the pinglist if there are any updates! Works wonders!