How much business value can we put in one add-in?

Whoa, what is this? An Excel app for reporting critical business data? That can easily be modified to support a plethora of different businesses? Why indeed!

Our Excel (And Word) Add-in is targeted to the bar manager who wants to get immediate insights. Gone are the days of getting reports a week or a month ahead in time, in the future, only current-situ and future-situ will be important.

Now there’s an add-in for that.

Our bar manager Björn will use this add-in to;

  • View breaking news. In a superhero universe, doing good business or doing great business depends on being aware of what’s happening. Slow day? Probably a lot of superheroes are going to be coming in for a beer, maybe some criminals too? Busy day of fighting crime and destroying public property? Yup, that hero will come to the bar, bring his friends and we better stock up. We’re providing super-fresh news from the Marvel universe to provide the business owner with yet another KPI to make decisions on.
  • View realtime data, Björn the bar manager can – across devices – view realtime status of how the bar is doing. Yes, the data is live and it’s updating every time we receive a new order.
  • Literally open and close the bar. No more phoning employees.
  • Start happy hour to gain marginal profit.
  • Stop the serving immediately
  • Activate auto-management mode (the system will then open and close the bar and adjust happy-hour at it’s own will.
  • Add the live data to the spreadsheet at a click of a button.

BeerApp1

BeerApp2

This naturally brings extreme business value and can  be used on a plethora of different scenarios.

Aiming for:

The add-in is still in alpha, so some of the buttons don’t actually do anything yet.. that said, they’re there and they’re obviously providing business value once they get implemented one by one.

Also, notice how the login-button actually takes you to the Azure AD (in the webapp) and brings out the username of the user. That’s the new experimental Adal.js implemented by best-practice. Unfortunately, we can’t find a way to properly set the scope, so even though we can make requests, we don’t have permissions for them. Yes, we can set it in the URL, but that’s not a very stable / sustainable solution, since the adalService.login() seems to set some cookies and do some other magic as well.. That said, we are completely at your mercy. Believe me when i say; We tried. We display the username however, which is nice (And resolved through the authentication).

Consumer / Commercial 200 bonus points … maaaaybe?? 🙂

 

Power user

Point One Arms is a modern pub with a powerful back office solution.

It has lists for breweries, beers, patrons, purchases, stock, orders, employees and timesheets.

These lists have been created manually, as have the lookup-fields between the lists. (for example, “purchases” has a lookup-field column to “beer”, which in turn has a lookup-field column to “breweries”)

We have also configured really beautiful Power BI graphs.

dash it out

For this we claim the Power User Love badge.

Badge-PowerUserLove

For the awesome graphs we claim the Dash it badge.Badge-Dash

Xamarin: TODO for the bar staff

To make it easy for the staff to keep track of their tasks todo in beer, it could get hectic, the hulk ipa is really good and the superheroes are thirsty, we have this azure mobile service html to run at the back office computer for everyone to see. It authenticates with Google.

azure

We have created a multi-platform solution where staff can track todo-tasks, enter new ones, mark tasks as completed, and, in a richer platform, the staff can also examine the details of a task. So we are also providing a responsive UI!

Our app reads a list, and also a single item. We have met all the criteria for the badges.

Xam1

Android

Xam2

Native Windows app

For the Azure service we claim the WAMS badge

<insert non-existing-wams-image>

For the Xamarin apps (Android and Win) we claim the “Proper native apps” badge.

<insert non-existing-proper-native-app-image>

 

 

Stock management

When your bar sells beer you are happy, and you need a way to manage your local beer stock.

PointOne Arms has several workflows to manage and calculate the status of the stock. There is also a alert system that notifies responsible bar manager in Yammer in a way that he is notified on his overpriced watch. This is an open group so other bar members can see de alerts if they are interested.

Workflow checking every 10 minutes if a beer is under stock threshold.

stockunderrun

Yammer group for stock alerts

yammer

Instant yammer notification on wrist when a beer is under threshold.

watch

 

flow yam

 

New badge: FFS, it’s 2016!

We live in a modern world, with the best of IDEs and modern conveniences.

But every now and again you have to do the equivalent of a HIMEM.SYS – not because you want to be retro, but because you have to, because there is no other way of doing it that works – despite this being 2016.

You do not get this badge for correctly, or incorrectly, disposing spweb objects (…because that is too easy).

You do get this badge for doing something which should have been fixed before MS bought SharePoint.

This is a suggestion for a new badge. (I’m being told I’m not very clear. Come around and ask)

PointOne – Happy Campers

PointOne, Agents of Shield, provide support services for weary superheroes, preferably of the Marvel genome.

We dress in professional attire, with even more professional badges.

badges

We have a relaxing atmosphere, with beer on tap. Not just any beer, mind you, but Hulk IPA, from PointOne’s own micro brewery. (kind of hidden because of Norwegian laws…)

Hulk IPA

For this we’d like to be considered for the Happy Camper badgers. And possibly the worst pun of the competition award. (if you are allowed to create badges on the fly, so are we.)

HappyCamperBadgers

Badge-HappyCamper

An exciting overview

In our inventory list, to make it more engaging for the employees of our bar and let them have a better understanding of the beers we have to offer we use canvas to draw a circle to display the color of the beer. Also,  in honor of the American guest this year, all American beers will now be represented with the Star Spangled Banner drawn as a canvas instead of a boring text output. Also we like the Scottish flag, so they got a canvas flag as well.

Also, because this list uses the rest api and the country is a taxonomy field, we use a Caml query to get the label of the field. We also use the Caml query to select the columns we would like to display.

canvas

beercolor

JsCaml

drawFlag

We are going for High Five and Query Master

Badge-CAML Badge-HighFive

 

 

Data mining with a rusty pickaxe

We have data about our stock and our stock of merchandise (Beer), but we want to have updated images and a score from the world. Beer bottle / can labels change every now and then and to keep up, we’ve connected with one of the world’s largest databases of beer.

The only issue is that they don’t really want to share their data.. they closed their handy JSON API about a year ago.

No worries, WebClient to the rescue! We’re simply scraping the data away in the worst way we could think of.

https://gist.github.com/Helgesmeby/97342f48ab46d5adfce1

Yes, it’s ugly – that’s why it’s nasty, and yes – it works as a charm!

 

PointOne – Agents of Shield

Point One, Agents of Shield, providing support services for weary superheroes, preferably of the Marvel genome.

We dress in professional attire, with even more professional badges.

badges

We have a relaxing atmosphere, with beer on tap. Not just any beer, mind you, but Hulk IPA, from Point One micro brewery.

Hulk IPA

For this we’d like to be considered for the Happy Camper badgers. And possibly the worst pun of the competition award. (if you are allowed to create badges on the fly, so are we.)

HappyCamperBadgers

Badge-HappyCamper