Excel Hash Seating Chart Planner - 2021
Вставка
- Опубліковано 23 лип 2024
- Sign up for our Excel webinar, times added weekly: www.excelcampus.com/blueprint...
This seating chart planner is packed with features to plan events or classrooms. It optimizes for small groups or families to use the least number of rows or tables. It also has user views to help attendees find their seat, and back end setup for sorting, row/table size, floor plan layout and more.
This solution is my submission for episode 3 of Excel Hash. Excel Hash is a friendly competition with my fellow Excel MVPs and UA-camrs where we must create any solution in Excel by using a list of ingredients.
#️⃣Excel Hash Playlist: • Excel Hash 2021
Watch the other submissions at the link above, and support their channels by liking and subscribing.
We had to use 4 of the following Excel features (ingredients) in the solution.
1. LET Function
2. Cutout People (required)
3. EVEN Function (required)
4. LAMBDA Function
5. Dynamic Arrays Formulas
6. Power Query Custom Data Types
Chapters:
00:00 Intro
00:55 Excel Hash Explained
01:34 Ingredient #1 Custom Data Types
02:30 Ingredient #2 Dynamic Array Formulas
03:03 Ingredient #3 Even Function
03:34 Ingredient #4 Cutout People
04:19 Group Optimization Feature
05:22 Conclusion
⬇️ Download the file and read the post:
www.excelcampus.com/functions...
#Excel #ExcelCampus #ExcelHash
You are brilliant Jon! Thank you so much for sharing your knowledge! I so greatly appreciate it!
Hi Jon. Very impressive! Looking forward to understanding how you designed all the features and components. Thanks for sharing. Thumbs up!!
Jon !! SUPER I like those seating arrangements you made it using the bubble chart.. COOL !!
Incredible. I love this. And you busted out the Solver. OMG!
Very cool use of the spilled range to put the tables. 🤯
Thanks Oz! I appreciate it. And appreciate you putting this together.
Yeah it's been awhile since I used Solver. Fun to use it in combo with Dynamic Arrays.
Beyond impressive!
I recently retired from the restaurant industry, and this is a very ingenious seating chart. Very impressive!
Thanks Ken! I appreciate it. And congrats on the retirement! 🎉🙌
Super Cool Really Love The Design Of The Seating Arrangements...Thank You Jon :)
Thanks Darryl! I appreciate it. 👍
Great Seating Chart HASH video, Jon!!
Thanks Mike!
Oh wow this is fantastic. I have watched 4 already. Thanks Oz and Jon. This might be the best yet or at least the best I have seen so far. I have 12 others to get through
Thanks Patrick! 🙌 We really appreciate your support in watching all the videos. I hope you learn a lot and find some inspiration.
This is a superb job, bud!
Thanks Terrell! 🙂
Impressive. I love the idea
Thanks Fred!
Great video! Would love to know how you get the color highlight in spill range cells based on the selected name? Any chance you could do a video on that one! THANKS!!!
Hi Jon, love this planner. When will you be able to post your video where you deep dive into what you've done here? There are many things you did in here that I am anxious to learn! Thanks, Steve
I would love to see this too please :D
very useful, just a question though. What version of excel did you use? Getting a lot of errors on excel 2016
Very Cool
Thanks Wyn!
Wow...
HI, This is great. But I cant find the more detailed explained Video of this. Can you please share?
Hello sir thanks for video.sir can u please make video for running total with purchase and sales in table format.i saw your running total video,but in that video it contains only addition, I want purchase and sales with running total in table format.please sir make a video.it,s my humble request sir.
Need to show how you created the seating chart and linked data.
Hi... How can v make a seating plan in excel with few conditions?
Where Can I find the additional video??