Mike (the Prepper Nerd) started focusing on self-sufficiency in late 2019. Thanks to many of the great preparedness YouTube channels, he was more prepared than most when people were storming the aisles for toilet paper in Q1 of 2020. After a few months of stocking up on food and supplies, Mike quickly realized he needed to get organized! With experience in software development, as well as Smartsheet specifically, Mike created an inventory system for his own use in mid-2020. And so, the Ultimate Prep System was born! Mike's professional experience includes project management, business analysis and process improvement, and data analysis. All of these combined in a unique way to allow him to create a prep system loved by so many.

GREAT application icon design!

I might have missed it, but is there a way to sort food inventory by BBDate so I can concentrate on those items outdating/outdated first? I couldn’t get it to sort that way.

I am assuming you will have more lessons such as copying and pasting, inserting rows, etc.

What happens if I want to add or change food categories? I’m hoping I’ll be able to make those changes as I wish without having to have you set them up. I’m still working with categories from “My Pantry” that are different than the categories that were set up for the online system.

I also would like to see some discussion (a video perhaps) about the benefits, if any, of maintaining both the online and the offline systems.

Thanks for all your tutorials. They definitely help. We (I) need more of them.

Prepper Nerd says:

September 27, 2022 at 6:02 pm

Thanks for the comment Rebecca! And my apologies for the delayed response.

Because of the way Smartsheet works, and to keep costs down for customers, I need to be the one to sort or make changes to categories, which I’m more than happy to do.

I appreciate your feedback and suggestions!

Can anyone help me get started? The program will not load due to “Macros not being enabled” even though I have enabled 4 times and rebooted my system. I don’t know what to do. Thanks

Prepper Nerd says:

February 8, 2023 at 1:09 pm

Hi Carol, apologies for the delayed response, but we’ve already discussed the issue via our support mailbox at support@prepper-nerd.com, so I assume you’re still in good shape. Let me know if you need any further assistance!

For others who may run into this issue, try opening Excel before you open the Ultimate Prep System and let me know if that also works for you. My understanding from customer feedback is that this is quite rare.