Sunday, July 20, 2014

Make a calender with (and on) a Spreadsheet

When we were still running 2Web Technologies, and showing potential customers how our product, XL2Web, could convert spreadsheets into Web Apps, I spent much of my free time creating fun and useful (and some not-so-useful) spreadsheets which worked really well as web apps. Spreadsheets for me actually became a development platform for creating web apps. I created a whole site of sample apps generated from spreadsheets (sadly, that site is no longer live) and I would use it to show off our little start-up's product to potential customers and anyone else who would listen. Over the past few years, I have intermittently taken one or more of those old spreadsheets and converted them into "our" product - Google Sheets... but I haven't had much of a catalyst to do that recently.  Today, for some reason, I decided to convert a semi-useful one I re-discovered.

The Calendar Maker Spreadsheet is super simple in what it achieves, and slightly less simple in how it does it. It's practically proof that I had a #spreadsheetaddiction when I created this, since there must be much easier ways to create calendars (...there are, right?) than to create spreadsheet formulas and format them to look semi-pretty.

If you want a copy of this thing so you can actually use it - just click the "MAKE A COPY..." item in the "FILE" menu. Then you just pick the month/year you want for either a full year or one-month calendar (two separate sheets in the spreadsheet), and you've got a calendar you can use... 

With an increased personal focus on Apps for Education, I've found - practically daily - a bunch of inspiring uses of our broader products - Docs, Sheets, Slides, Drawings and more - in the educational context... sometimes directly in teaching students, and sometimes just helping teachers do things better, faster and smarter. I've also been re-inspired by incredibly smart educators who find ways to use technology to improve their teaching, to inspire other educators and to make learning more engaging for kids and adults.  The work of one such educator indirectly inspired me to post to my blog again: @alicekeeler - who writes a prolific blog called TeacherTech, inspiring and guiding educators on ways to use technology effectively in teaching - and - she's also slightly (!) crazy about spreadsheets.



9 comments:

jatin tyagi said...

Very good write-up. I definitely appreciate this website. Continue the good work!
Devops Online Training
Adobe cq5 Training
Dell Boomi Training

Eon Mech said...

Nice article thanks for sharing , very informative and insightful stuff , keep updating more

red hat linux training in chennai | rhce certification in chennai | red hat certification training in chennai

technode said...

awesome ,thanks for sharing
linux training in chennai | red hat linux training in chennai

technode said...

Thanks for sharing , very informative and presented well , keep updating morelinux training in chennai|best linux training center in chennai|red hat training institutes in chennai|linux courses in chennai|linux classes in chennai|linux certification centers in chennai

Brave Technologies said...

Thank you for this valuable information. Get your business to the next level in simple steps. We provides lowest price of erp Software for our clientserp in Chennai | erp software providers in chennai

Laura Ellen said...

Hey, I just wanted to say thanks so much for your spreadsheets. I just downloaded a copy of your mortgage calculator spreadsheet and it is PERFECT... exactly what I was looking for. https://sites.google.com/site/spreadsheets/spreadsheet-categories/financial-sheets/mortgage-amortization-with-paydown Your other spreadsheets are great, too. Really appreciate you making these available to the rest of us. Thanks!! (I didn't know how to say thanks directly so I'm leaving this comment here : D).

Jai Technomind said...

I would to say thanks so much for your spreadsheets, i just loaded and validated, it is working. It helps if you tel the steps in document

Software Testing Training in Chennai | Selenium Training in Chennai | Load Runner Training in Chennai | JMeter Training in Chennai

mahendar cherry said...

Big Data and Data Science Course Material. Avail 15 Day Free Trial! Learn Flume, Sqoop, Pig, Hive, MapReduce, Yarn & More. Get Certified By Experts! hadoop online training

sandhosh said...


Really Good blog post.provided a helpful information.keep updating...
Digital marketing company in Chennai