We had a problem. A huge problem. We needed to know where in our floor plan the different components are placed.
By training our own custom vision model based on training data of bathroom floor plans, we managed to obtain an AI model able to detect components such as:
Toilet
Shower
Bath tub
Sink
Main pipes
The model was published and the API made available for our backend application in C# to consume.
To make our amazing service Tubi work, a lot of cloud is needed. We aim to make the plumber’s job easier by recommending the best layout for where the pipes should go, and for that, we need AI. We have trained a model in Custom Vision to recognize all components in a bathroom that need water. So, when the plumber uploads a floor plan to our Static Web App, the image is sent to our Azure Function App backend in C# Asp.net through our own API. But both the image and the equipment list must be stored somewhere. Therefore, we have also connected to Azure Blob Storage. Then last but not at all least. The people working in the back office have instant interactive reports available to help them with filing and billing through Power BI and alerting the using an automated flow (Badges: Feature Bombing)
Sometimes it works, and that’s plenty
Databases are good, but sometimes it’s easier to just dump everything in one place until you need it again. Yes, it might not be very scalable or very normalized. SQL became too heavy, and we already needed a Blob storage to store the images, so we also dump the order data in the same blob storage as JSON files. It’s old fashioned way of serverstorage, and a bit dirty, but it works! (Badges: Nasty hacker, Retro badge)
Power the backoffice
As the final list of components are decided, they still have to be approved from the accounting team in the office. To make sure they have all the information they require, we have developed a Power BI dashboard to crawl through our registered data and make sure the orders are handled properly (Badges: Crawler, Dash it Out, Dataminer). And to make sure the orders are handled easy and fast, the dashboard is embedded into teams and an alert is automated by using a logic app to make sure the workers can receive and cooperate in realtime (Badges: Embedding Numbnuts, Go with the flow, Pug N’ Play, Power user love, Right Now, Stairway to heaven).
We have created a dashboard in dynamics, and in that context we feel obliged to ask for the retro badge at the same time. Dynamics is fun to deal with when it comes to a lot, but dashboard and charts feels like it has been collecting dust since 2008 (poor thing). Its reliance on outdated aesthetics compromises functionality and accessibility.
Our “PlumbBoard” shows the key values in our enviroment – Certifications Renewal – PlumbScore: The number of individuals trying to obtain certification through our ‘Plumber PowerUp’ games – Invoices: With an overview of when the invoices are due – Contacts: It’s also important to have some indications of our different memberships. In our case, we have plumbers and members.
Attending the ACDC Hackathon is not just about swearing and sweating – it is also an opportunity to eat some snacks and have fun. You are currently witnessing new and older Cepheo employees getting along playing RC car (Super Mario edition of course) and making big jumps!
The boys look more beautiful than ever with their Princess Peach-inspired tiaras and cute smiles! And even better; our Super Mario below brought beer and other delicious beverages in his portable cooler.
Yesterday we did an amazing job, but still the judges did not agree with us, and we ended up with very few points in the fight for the title. Third to last, but that never stopped us.
Our motivation:
NEVER GIVE UP!
– waken Koopa troopas
Today, we put blood, sweat, and tears into our work.
With remarkable team spirit, we have risen… in rank.. singular. Forth to last.
Embodying the true spirit of the ACDC Hackathon, our team ventured beyond the pursuit of mere badges. By assisting another team in refining their analog clock component and sharing our repository for the high-score game component, we championed the essence of community and collaboration within the tech realm. Our efforts served not only to enhance another team’s project but also to disseminate valuable code, setting a standard for openness and collective support among competitors. This ethos of sharing knowledge and resources amplifies the potential for greater innovation and collective success.
The hackathon transcends the notion of mere competition; it represents a consortium of developers challenging the status quo, learning from one another, and crafting solutions that aim not solely at winning but at making a meaningful impact. Through our commitment to earning badges and our acts of sharing, we illuminate the core values of the hackathon—innovation, collaboration, and growth. Our experience demonstrates that when developers unite in their efforts, extraordinary outcomes are within reach, underscoring the power of teamwork in driving forward the boundaries of technology and community engagement.
As one can see, the Pzl Plumbers has also shaired their code, an open source HighScore PCF component, ready to be used in any game you would want to develop 🙂
Behold, as the final flourish to this grand adventure, the customer’s inbox lights up like a beacon of achievement! With a twinkle in its digital eye, the Microsoft Outlook connector springs into action, delivering a virtual diploma straight to the customer’s awaiting hands. It’s not just an email; it’s a messenger of triumph, carrying the seal of excellence from the Awesome Plumber Firm. With every diploma received, another customer joins the ranks of plumbing champions, their victory celebrated far and wide in the kingdom of email!
Imagine the triumphant moment: the work order completed, the last wrench tightened, and voila! Like magic, a path unfurls in the digital realm, leading straight to the treasure trove of work order documents! It’s like discovering a hidden treasure map in the depths of SharePoint! Every document, every detail neatly arranged along the path, beckoning with the promise of knowledge and accomplishment. With each completed task, another chapter is added to the epic saga of plumbing prowess, all waiting to be explored in the enchanted halls of SharePoint!
Behold the power of PowerPages! Picture this: a distressed customer, facing a flood of plumbing woes, summons help with a mere click of their mouse or tap of their finger. With the agility of a ninja and the simplicity of a child’s game, they dispatch a plumber to their aid! It’s like summoning a superhero, but instead of capes, they wield wrenches and plungers! With PowerPages, plumbing problems are no match for our valiant customers
Donkey Kong, the mighty supervisor, perched atop his virtual throne in the Field Service app’s Schedule Board. With a stroke of his mighty ape paw, he oversees his troop of employees as they navigate the jungle of bookings. It’s a wild ride, but with Donkey Kong at the helm, chaos turns into coordinated mayhem
Our trusty plumbers, armed with wrenches and know-how, embarking on their daily quests to conquer leaks and vanquish clogs! But fear not, for with the power of the Bing connector, they’re armed with more than just tools—they’ve got the magic of automatic latitude and longitude retrieval! As they navigate the labyrinth of streets, our fearless plumbers rely on the Canvas app like seasoned adventurers, ensuring they always reach the pot of gold at the end of the address rainbow!