RedStrong Red (default) BlueCalm Blue GreenFresh Green

Chose your color scheme.

Archive for "Projects"

ZINCON Schedule Excel Worksheet

Posted on February 23, 2018 by under Projects, Zumba.    

The Zumba Instructor Convention web site launched last week and so I did what I normally do every year that I go to convention — I created a worksheet to help me build my ideal schedule. ZINCON registration doesn’t actually open until February 28 but the schedules are posted so we can all start building our perfect schedules. Then, when the appointed time comes, everyone descends upon the site to make sure they get their top choices.

The scene when registration opens is a lot like this one in Big Bang Theory.

So many people are hitting the site all at once, it’s actually been known to crash a time or two. I often am stuck in some sort of meeting when registration first opens so Brian usually has to register for me. Thus, the need for worksheet that tells him what classes to sign me up for. I usually give him several options in case a session is no longer available, which happens more often than not. Specially with some of the more famous presenters and new training programs.

In 2016, when STRONG by Zumba launched, the training session was full within minutes of registration opening, so I couldn’t get in it. Brian ended up signing me up for Sentao, which is the only other format that I wasn’t already licensed for at the time. I waited another full year to complete my SBZ training.

Since registration will be open in just a few days, I decided to build my worksheet before bed one night while watching the Olympics. The worksheets I’ve used in the past just allows sorting and filtering, to make it easy for me to compare sessions and review all of my options. I usually still have to build my schedule manually. This year, Brian challenged me to make the worksheet so that it would build my schedule automatically. I’ve never made that part automatic in the past because there’s multiple ways to build a schedule. You could opt to take training sessions on both Friday and Saturday, or you could just do training on Friday and regular workshops on Saturday, or the opposite — regular sessions on Friday and training on Saturday, or you could go with just all workshops and no instructor training. I usually have to decide this for myself so it’s really tricky to make a worksheet automatically build the schedule. I figured it out, though!

Worksheet 2

The solution isn’t the most elegant, but it works. Basically, I created tabs for the four scenarios: SESSIONS ONLY, FRIDAY TRAINING, SATURDAY TRAINING, and FRI-SAT TRAINING. The first tab has all of the options listed. You put an X in the SEL column to specify which sessions or training you want to take. The worksheet populates all of the other tabs. Obviously some sections will be blank in the other tabs, depending on your choices.

For example, if you opt to take a training session (which takes up pretty much the entire day) then you won’t have time to take any other sessions on that same day. If you go to the SESSIONS ONLY tab then it will have some empty slots. Depending on how you laid out your schedule or what choices you’ve made, you just have to click on the appropriate tab to view your personalized ZINCON schedule.

It’s not perfect, but it works. I probably could create an Access solution but most people don’t have access to Access (see what I did there – LOL) but almost everyone has access to Excel. The gears are working in my mind now, though. I could create a web site that does this more elegantly. An app would be better, but I don’t know how to make phone apps. Sigh.

Worksheet 1

Here’s a preview of the first page of the full schedule, should one decide to print it. I don’t know why you would, unless you just want to kill trees. There really is no need to print the whole thing. Oh, and you’ll notice there is an X next to the Kickoff session. I made it so you can’t remove that X. I’m a nerd and I think everyone should go to it. Obviously, people could still skip attending Kickoff if they want but it will print on their schedule regardless because that’s how I built the worksheet.

Worksheet 5

I’ve enabled auto-filters so the person using the worksheet can slice and dice the schedule however they wish. This is an example of how you can filter by Time. Say, for example, if you don’t want to get up before a certain time so you only want to see morning sessions that start at 8:30 AM or later.

Worksheet 3

This next one is an example of filtering the schedule by Presenter. It makes it easier to see all the various sessions that someone is presenting. Makes stalking your Zumba idols a lot easier. LOL.

Jokes aside, it really is mostly for doing comparisons. Being able to look at all the times side-by-side makes it easier to plan around sessions that you absolutely, positively do not want to miss.

Worksheet 4

Here’s an example of filtering the schedule by Session Title. So if you just want to look at all the ZIN Jam Sessions, you can do that.

I don’t show an example of it but you can also put an X in the SEL column of the sessions that you want to compare side-by-side. Maybe they are totally different sessions at different times and by different presenters but you want to look at them side-by-side so you can decide. When you put an X on all these sessions and then filter the schedule by SEL then you can eliminate all of the other sessions and look at just the ones you want to compare. It helps to remove all the clutter.

When you are finished making your choices, remove all the Xs that you don’t need and leave only the ones that you want (making sure that there is only one session selected under each time slot). Then click on the appropriate tab based on the choices you made. The tabs represent the four possible schedule scenarios:

  • SESSION ONLY – this tab is if you didn’t select any instructor training at all
  • FRIDAY TRAINING – this tab is if you opted to take a training on Friday and picked regular sessions for all the other time slots
  • SATURDAY TRAINING – this tab is if you opted to take a training on Saturday and picked regular sessions for all the other time slots
  • FRI-SAT TRAINING – this tab is if you opted to take training sessions on both days

Worksheet 7

If you selected training sessions on Friday and Saturday, then click on the SESSION ONLY tab, you’ll see a bunch of blanks. Your correct schedule will be under the FRI-SAT TRAINING tab. It does take a bit to understand how to use the tool but, once you understand how it works, then it makes building your schedule super easy — since the tabs are automatically populated.

Here’s an example output of selecting all regular sessions.

Worksheet 6

Having your schedule automatically populate on the schedule tabs is actually a real time saver. So you can create multiple schedule scenarios. You can have a Plan A, Plan B, Plan C, and so on. Trust me. Unless you are one of the lucky ones who can actually get on right when registration opens (they never tell us the time either so some people actually take the day off work so they can sit in front of their computer and wait and then pounce when the time comes), you don’t always get all of your first choices. Sometimes you can get lucky, though.

Brian is usually able to register for me in case I’m stuck in a meeting and can’t take the time to register myself. I just give him my login credentials. Thus, I’ve had to come up with this solution so he knows exactly what sessions to sign me up for. I give him multiple choices. Anyway, it’s really helped me out a lot so I usually share it with others. I’ve shared my worksheet the last couple of years.

I shared this 2018 version earlier this week on the official ZINCON group in Facebook. If you’re not in the group but would like the worksheet, please leave a comment below with your email and I will gladly email it to you.

I hope it helps. See you at ZINCON!


New Beanies for Grandma

Posted on January 21, 2018 by under Projects.    

Someone (whose first name starts with the letter B) didn’t tell me that grandma wanted new crochet beanies for Christmas. I found out on Christmas day when grandma mentioned it. I asked Brian about it that night before bed.

ME: Why didn’t you tell me?

BRIAN: I only found out on Friday. I didn’t think you would have time to make one.

Anyway, I felt really bad so I decided to get right on it during my short break from work over the holidays. Amazingly enough, I was able to complete one hat in about four hours. Not bad for a novice.

I was so impressed with myself that I decided to make another one the next day.


Here are pics of the two beanies I made.


Brian delivered the beanies to grandma while I was teaching my New Year’s Eve Zumba class and he took photos for me. He said she really liked them which makes me super happy.

I may not have gotten them done in time for Christmas but at least I got them done in time for the cold weather. It has been super cold here the last two weeks. This is the first weekend we’ve had decent weather.

Anyway, I love how the hats (which, if you notice, are two different styles — since I just make these on the fly without a pattern, no two are ever identical) turned out. This has encouraged me to pick up crocheting again. Hopefully, I’ll finally learn how to read crochet patterns and learn to make some new things this year.

No Comments

Making My Home Smarter Than Me

Posted on December 31, 2017 by under Home Ownership, Projects.    

I have been wanting to add smart devices to our home for some time. I wanted a Nest since they first came out but my wife wouldn’t let me because the local power company had their own program and she felt since she worked for them, she should honor that program and be a part of it as well. This did get us a really nice Honeywell programmable thermostat, but it wasn’t a Nest!

Several years have now passed and we’ve gotten off the WattSaver program, but we got to keep the programmable thermostat and it’s worked very well for us. But, again, it’s not a Nest. So after visiting a friend’s house and seeing all of his home automation toys, I decided it was time to work on Ching and see if I could finally swing a Nest. It just so happened that Amazon was having a huge sale and I was able to get it much cheaper than normal and Ching finally caved (because she’s a sucker for sales) and I got my Nest.


This is a picture of me unboxing the Nest. It’s pretty simple when you get down to it and look at how they have everything set up for you. They even include pictures and labels. They offer a professional set up but, unless you are just really not handy (I’m close), I think you would be able to manage.


Here it’s all installed and working. I love that I can control it from my phone, laptop or even my watch.

After that, it was time to update a coupe of light switches that we have really wanted to have on a program anyway but could never figure out how to do it. Again, my friend showed me some of the things that he had and they fit my needs perfectly. Thanks to Amazon again, they were having a sale and Ching could not resist, so we got three plugs and two light switches.

The plugs are very versatile, they just plug into the wall and there are some instructions on the app and then bam, they are available to be automated and controlled through my phone.

The light switches were a little different. These involved a little help from my father-in-law and a friend of his. I needed expert advise and installation. LOL.


Here is a picture of all of us looking at the wiring and trying to plan the best way to install them without burning my house down.


Here we have initiated the plan and we are conversing to make sure that we all agree to the final installation.


Here is the final product installed.


And here we have it all covered up with a nice smooth face plate. I like these face plates because you don’t see any screws like traditional faceplates. I think going forward, I may use these on all of my replacement switches.

All in all, I like the way everything functions. I like how it is automated and how I can, in the near future, tie them all to an Alexa and just use my voice to control everything.

No Comments

New Keeper of the Plains Statue

Posted on May 1, 2017 by under Projects, Things to Do.    

A new Keeper of the Plains replica statue was unveiled in our office building a couple of weeks ago. It is one of several 10-foot tall fiberglass replicas of our famous Keeper of the Plains statue that’s part of the “Keepers on Parade” project launched by Together Wichita in 2014.



Brian and I have been anxiously awaiting the unveiling because we collaborated on the design concept last year. When work announced that we would be commissioning our very own Keeper of the Plains replica for the atrium of our Wichita office, they held a design contest.

I wanted to enter the contest but I wanted Brian to help me. Anyway, as the deadline approached, I ended up getting busy with work. On the last day, I found out from Ebony that we only had a few entries. I told Brian what I wanted drawn and he whipped it up real quick. Then he scanned them and emailed them to me for me to send to Ebony. Below is the design that we submitted.


It’s not even colored because we ran out of time. We submitted our design literally moments before the cutoff. Who would have thought that the judges would appreciate the simplicity of our design concept.

That was last year. We’d been waiting for the completed statue since. Here’s a closer look at all the sides of the completed Keeper of the Plains replica statue.


The artist made several changes that improved the overall outcome. They kept the general concept of our design but added and changed some of the elements. I thought all of the design changes worked. The statue turned out even better than I could have ever imagined.

If you are interested in seeing this one in person, it’s located in the atrium of the Ruffin Building on the corner of Douglas and Broadway (100 N. Broadway). There are three others at the pop up park. Those were the first three I had ever seen actually. I have seen several since. They’re scattered all over town.

One of these days I will go and check out all of them. There’s a Keeper Finder map on the Together Wichita web site which makes it a lot easier to locate all of the “Keepers on Parade” statues. If you’re looking for something to do, this would be a fun weekend activity or cheap date idea. It reminds of the time that Brian and I went on a sculpture scavenger hunt on the Wichita State University campus a few years ago. That was a lot of fun.

Perhaps we will see you around at one of these installations. Happy hunting!

No Comments

Team Building and Community Service

Posted on November 20, 2016 by under Events, Projects, Things to Do.    

Here are some pictures from the team building volunteer service activity that I organized a couple of weeks ago. I’m so grateful for my amazing coworkers who gave up part of their holiday weekend to help out.


The project? We helped set up the North Pole Winter Carnival at Child Start‘s Polar Express Literacy Event.


The trickiest part was building the train display with no instructions.


Mike was super proud of the fake wood wall that he and Mel built.


He’s showing it off in this photo with Faith’s husband (left).


They didn’t need our help with the main event area. Our group’s focus was setting up and decorating the game room, which I actually thought was the fun part.


I really wish we could have attended the event and seen the kids enjoy the carnival games. Brian and I had another party to attend that evening, otherwise I would have totally dragged him with me. Had I planned the weekend better, I could have taken Nickira to the event. I think she would have enjoyed it.

I hope Child Start holds the event again next year. Nickira is getting to close to that age where she might think it’s a little bit childish but I really think she would enjoy it. I hope I can take her next year because it will be the final one before she’s officially a teenager. I saw some pictures of the event on the Child Start Facebook page and it looked like a blast. I’m really bummed that I missed it.

At least we got to help set up. I just love volunteering for stuff like this. It warms my heart. The best part is the $1000 donation from the Westar Energy Foundation to match our team building volunteer service hours.

No Comments

« Older Entries «