Excel SolutionPalooza! Get inspired by the latest greatest Excel extensibility - BRK3377
Hello, all right good afternoon everyone, welcome. To, the excel solution, Palooza, I'm. Care and. This is one and we. Love, excel. Our. Goal today is to get. You guys inspired, to. Try out deploy. And, build. Different, excel solutions, what, we're going to do is provide you a set of different demos, and consider. These building blocks. Will. Have these building blocks and, then. We're going to ask two, of our great partners to come on stage front, line systems in Han Hana to, demonstrate, how they're taking these building blocks and built. Plugging, them together to build, solutions. That unlock, business, value for their users. Oh yeah. Okay. So. Told. You I we, love Excel, who, needs PowerPoint. We're. Gonna talk, about office, add-ins, office. Add-ins. Enable. You to make, your solution, a native part of Excel and if, you're a business, decision maker you may, want. To ask yourself hey do I have users, that are, using. Excel, not only traditionally. As they've done on Windows desktop but. Now, are they accessing, Excel through the browser like in this instance or, through Mac or through different devices, likewise. You may have a different solution and, people. May need to contact, switch from, your application. Into Excel a lot, of times we see developers, provide the infamous. Export, to excel, button or the, export, to CSV button and then, people load that in into. The context of Excel but, the problem there is it's static, and so. This is where by, you bringing, your solution, into. Excel you, can actually make, it way. More compelling. And things. Like that all, right the, next part is if, you're an IT Pro who's. Ever had to deploy a calm add in but, or into. Their organization. Alright. A few of you guys who, like doing that. Alright. Nobody that's, that's, why I thought. With. Office add-ins you can easily, manage, and deploy. Your. A divs and control. Them so you, as a admin. Are in control of that, add-ins that people use in your organization. And. Then developers. So. Office. Add-ins, leverage, web technologies. That. Allow you to call. Out to any service. Powerful. Services, having your logic stored, in Azure or, even. Calling, out to office. 365, services, through the Microsoft graph so. There's a lot of, goodness. Here, I. Did. Want to ask. Folks. Who. Here identifies, themselves, as a business, decision maker I'm gonna try to get a count. All. Right so one two three or four five six, all. Right. Let's. Just fudge the numbers a little bit but alright, who's an IT bro it's about. Six all, right so let's say. I'll. Give it around 70 and how many developers do we have in the audience. All. Right I'm gonna go a, hundred. Of you. Okay. So, the, first. Demo that we wanted to provide you. Was. A. Data. Visualization. So. Here, I've gone into the insert tab in Excel online and I've clicked office but Adams button and. Pretty. Quickly we can see within, this dialog, a few. Different add-ins that I have here, in this case my. IT. Admin, has already. Deployed, to. Adams one. Is the people graph another, a script lab which we'll talk about in a second now, the way the IT admin deployed this, was. Through, the. Office, Microsoft, 365, admin Center and within, the admin Center there's a service and, services. An add-in and here. You can see all the different services your, users have access to, likewise. Here. You, can see the, admin, has already, chosen, to deploy the people graph into, their organization. And it can't and you have control so you you, can deploy, to specific, users or specific.
Groups Or everyone, or even. Yourself as an admin, to test things out before you open. It up to the world. Now. In in this instance, I'm. Downloading, a. Or. Inserting. A. Content. Visualization. Adding it to my document, so, I'm going to click, Add. Load, come on. Come, on Wi-Fi, there we go so. Here we have a visualization. That. Shows us, numbers. Within the app so let's change this a little bit and. We. Want to know. Not. Only. We. We are all Excel, lovers here. So. I can select, yep. And, then. Also, I can go and customize this, to my heart's content so. With the theme, yeah. I like the root theme the. Shape let's go with some hearts and there, you go. And one. Of the things about this as I mentioned is it's, not static so, if we were to say hey a, bunch, of BDMS. Walked into a room. And. The. Data. Would react, through a data changed event and update. Itself so, here, we have an example of an, add-in, that showcases two building, blocks these. Building blocks are a web view which, shows dynamic. HTML, content as well, as the it. Talks through our api's. To. Interact, with the. Data inside, the users document. So. I wanted to also talk, about a few other building, blocks that we have. One. Of them is hey. As. I mentioned I had, the IT admin had deployed to you add-ins to me one. Of these add-ins is called, script lab and so, I didn't have to go and acquire this I just opened up Excel and, here. In my ribbon there's a script, lab tab now. Likewise. We. Have front-line systems who. Also. Created, their own ribbon. Tab or. Hana. Actually. Has just a simple button that, they use to show their task pane. Alright. So. The next part is we, have web views so I showed a Content, add-in now let's see at a screen so. Back, into script web I. Can. Open up. The. Code test pane. And. This. Will open up and I. Have, pre-loaded some. Custom, functions here. Which. Are our next building block so. Custom functions are in Developer Preview I'll talk about those and then, I'll hand it off to one who will talk about our Excel APs. So. As. This loads, alright. So. Here we have a set of custom functions here there's, a contains function, there's a translate, function let's. Try. Them out. We. Already having some issues. So, well. When. We look at custom functions, custom. Functions are really just a part of an atom, they, should they look, and feel like native, built-in functions so it does, really feel like some and I've, actually taken that quote from one of our partners who said hey you should make it really feel like some. The. When. You look at functions, they're actually just formulas, that it actually that travel, with the document, the code itself does not travel with the document the code is hosted on, a on, your. Web server you're, actually just. Having. The function be a pointer to, your logic. And. When. I think of functions there's, three. Or four main scenarios, I think about first one is. Complementing. The rich library of Excel functions with your own if you want to have reusable, logic you can go and create your own so. It's. Ignite and it's. A long week and it's hard to attract what day of the week it is so. I'm going to just you. Try, a custom, function. With. Another add-in that I've already pre deployed, which. Is hey I mean. That day and so. This will actually make a call and. Return, the, day of the week which, thankfully, it is Wednesday so I know I'm in the right place hope, you are too. Likewise. One. Of the new capabilities with, custom functions is the built-in, ability to stream in real time data so, here we have the canal, a, set of stock quotes. We're, in Orlando so I chose Disney I hope that's the right stock ticker and. Here. We're gonna say hey let's stream in some. Of their stock wolf, functionality. And this. Is going to go get that data. And I'm just gonna go fill down and I'm, just using, Excel I'm. Just using familiar, Excel, operations, that I know and love and now. I've, gotten that data. This. Is hard to see but there's going to be a working. Thing. So this, tells me hey it's going out and continually. Pulling to see if there's a change, in the stock quote data. Today didn't seem that volatile. But. If there is oh there we go Microsoft, or Disney just lost a penny. Maybe. We should all go and help their. Stock. Price go up all. Right, the, next scenario is around, what, I think is, applies.
To A lot of us where. We have a particular, service and how do you make that available, to. Users in Excel and, in. This, scenario we're going, to call a. A, sure function, which, is calling. Microsoft's, translator, services, so this is a scenario of bringing, intelligence capabilities. Right into Excel. So. I can just call a translate. And. I. Want to translate hello world and es. Yes is a locale for Spanish. I'll. Do that and here, we go hola mundo. And. You. Could say if, you want to know how to say we love Excel, you. Can do that or, my. Favorite. Donde. Esta el Bano very, good. For. The last. Demo. There's. You can also import. Data into Excel. Using. Custom functions with, a new feature that was announced at ignite, dynamic. Erase, so. I'm going to switch over to excel, desktop, to highlight, that. All. Right, so. I'm going to open up script lab and. Load. Up the code. So. Here's, an instance of that same atom that was running on Excel. Online working, on Excel desktop. And. Within. Script lab I can it. The. Alpha script up know. We. Have a different. Environments. For script lab I switch, over to beta so. We are. Adding custom function support into. A, script lab that will be rolling out in the next couple of weeks but. For now we're in beta mode and the. Next thing I'm going to do is, go. To github and get. A gist, this. Is the same gist that I had. Which. Had like, the translate function as, well as the import, HTML function. So, let me take a quick. Minute and just give, you a. Brief. Look at the code so, here, was the Translate code all. We're doing is we're returning a promise and making. A simple, web request to. This URL and. This. This. Could be any service here, all, I did was follow. The cognitive, service with quick wrap. That that into an Asscher function deployed. It and with, a few lines of code I can bring that that richness, into Excel. Right. So. Let. Me open up this. To, import. And. I'll import this snippet here. And. Then, i'm gonna click the functions button. To. Run that. Alright. So now that these, functions, have registered, and i. Want to know hey, for my next trip down to Florida. Where. Should I visit base, off over the weather it's been really hot I like Florida. Is. There, a place that's, cooler. And so. What, I've done here is I've. Gone. And fetched. Out weather, information from this website it was a table brought. That in, real time into Excel and before. A user. Would have to know oh this function is returning five results so it I have to select five cells control, shift enter, that. And guess, what not many people knew, about that and so with dynamic, arrays and custom functions working together we've, unlocked a new scenario to import.
Data All. Right with, that I'm gonna pass it on to one who's going to talk about our awesome excel, APs, thank, you very much guy your yeah. This is awesome to see I mean III. Your. Custom functions was what, used to be UDF's. So and, the good news is that you. Can actually combine custom. Functions with your audience in order to because we have the necessary API, steuby subscribing, to you. Know range. Change events, as well as. So. Basically you can create add-ins and integrates with custom functions and use, both technologies, to create you know amazing solutions, like the ones we're going to see later today so. I'm. Gonna go back to the I do, love Excel, but I have a few few, slides for you just for and then I will do a bunch of demos okay, so. By. Now everybody that has do salinger quick show, hands who has you who has created an excel adding here. Many. People in the room okay, so this, is a technology that actually shipped back, in office 2013 and, by. Now it should be very. Clear and, I've seen it with customers, and partners I've working with that's. You, know the value that we give us a platform is enormous. The fact that you can actually create an add-in and run. It in multiple platforms, it's just by itself you know an amazing capability, that our customers, actually love. The. Other thing that it's actually, super. Interesting. For our partners, and customers is the way that we deploy audience as Kelly was saying you. Know the fact that just. By deploying, doing an X copy deployment, or our web apps you know the. All. Our customers, get to get get the updates so that's actually. That's amazing, if you think about what previously previous. Technologies, do with with office. But. We still saw some, you, know. Resistance. To to actually you. Know attract Excel developers, to create add-ins and one, of the things that's. Inside. Our our companies. We. Need more api's you, know clearly, Excel. Developers, today don't have the number of API. It. Didn't actually. To. Create solutions you, know how can we create great items it will obviate. So. What I want to tell you today I'm super happy to tell you that we took this feedback, very seriously. We. Focus, on creating a PS for Excel and as you can see this chart sorry. About the small, fonts, but, it is showing every release that we have shipped and how, many api's were in that release and as. You can see the last three which is basically the last year we've been working, extremely. Focused, we. Literally. Added, many. Hundreds, of api's for you so, now the API said it's reaching a point where were it's, really about, just. Enabling what you have and in fact if. We. It's. Also interesting how we choose to prioritize. With ap as which, ap as we look first first, we. Of course you know based, on telemetry that there. Are the. Most used, but. We want to be very careful about it we, actually what we have in mind is to actually, enable in, a set of categories, we. Think about end to end we know, that the most common ways of the more common common solutions. That are built on Excel we. Try to do a categorization of, them and we, find really interesting, information about, you know what, patterns. Of api's are used in each of those categories so we, were able I mentioned two men just to mention a few of them and I, will keep this in context, for all our conversation you. Know we know what API is you are using for example we want to do reporting, if you want to do, reporting. You have to do not only support. You know charts, and tables and people tables, but you also need to have all. The necessary API, Stu pink. Still many people put reports, you wanna see in my demo order, now, we need all those capabilities we need a bunch of charts enabled, vein analysis, audience we need a bunch of API.
To Make sure that we. Can insert fast they excel, have. The necessary events, to create awesome visualizations, and so on and so forth I wanted, to think keep in mind that this is the approach that we that we chose and you. Will see that you, will have API see I think, we have if you're adding is in these categories, and others I think, you should be able to actually. Create a new Allen today and. With. That I will close. This. Is what I want to share with you is the the history of hopefully, you can see the. Problem that I have with this is light now is that we have so many API so I'm having a hard time finding, space for it for all of the objects we have today in. Build back in May we actually released our 1.7, API and we ship a lot of good stuff like protection, for workbooks tiles. Freeze. Panes we ship a bunch of events as well charts. We with a bunch of investments. Today. Add add. Ignite conference we. Are announcing, the GA of the, 1.8, api's. So. Starting today you can actually start, using. This API s we. Actually, turn on the bit back, in June so, today 95%. Of office 365 users actually, can use this API so you can use them today and. They. Say this release includes, data. Validation, which was supposed to be really actually a recent 1.7, but, we it wasn't stable, enough so we actually wait. For it now, it's rock-solid it's in 1.8, you can use it today we. Also included people tables, we, have originally, shipped something on 1.3, you. Know that you, were only able to refresh people's but now you can actually create them and do more interesting, things. We. All have more. Charts we have more events for charts we. Have created workbook which is an API, that many customers are asking for creating, new documents out of templates. And. We. Also have. Feed. Headings, removed and removeduplicates charts. And so on and so forth, we. Also announcing, today. Another. Like 400 api's that. You can actually try today on our better, endpoints and. These. One includes shapes all the, charts in Excel so basically we are declaring charts, complete, all, the charts mostly, mostly most of a chart you can use we, have out to filter for ranges. Arguelles, for the first time in the API history, we are able to support, these.
I, Can do many things I can register to the collection events so we added a bunch of events for collections, when you add a new chart when you have a new sheet maybe you have new stuff to the workbook those, events are going to get triggered. We. Also it register for events on. For. Worksheet events and I restore. For the Bing Map events and. So I'm just going to a bunch of events on this demo so. Let me go back to the map you, will. See that every, time I select something on. You, know on the on. The table it's gonna get refreshed and, one thing that is really interesting on, this demo that. I actually caught, the. The. Console here but I and hopefully, you will you'll be able to see that. All. The information that we are getting out of those events. See. The event still on, its. Subscribe to the events again sorry about that. Subscribe. To the Bing, Map events there, you go so the events are registered, and when, I do a selection. You're, clearly gonna be able to see in, what works it was event what cells were the ones that were selected and, so, on and so forth if I insert a chart here and I, try to do, and I switch from the table to the chart, sample. In the one. Chart like this you're. Gonna see that now I select the chart I'm gonna get the event what chart was selected, and so on all the context right this, was a number one request and we were able to serve. It. Okay. So. That's events. Let's. Go back to that my workbook, I want, to show you another, demo I. Want. To play the Excel right now so let me go ahead and install script lab. And. I want to show you another. Demo about charts, the new investments we have done in charge this is useful for solutions. That are you. Know you're doing business instead against you want to do charts of summarizing, data and stuff so, let me go ahead and pull up the demo here. There. You go by. The way there's a blog I need to do some pre work here. Okay. Let's. See what this this demo is it's all about well. I want to highlight on this demo is it's a lot of the chart API as we're doing. So. As you can see well let's add some sample data here, this is just data from from a store you know they have lemons. Oranges, and stuff like that and. I. Have, the sales data and other information, associated, with the sales for example the temperature, of the date when the sale was done and so on and so forth so. I can create a line chart but that's nothing new we, do two series. Of datasets. If, you want you can split them so I will have lemons. In one chard and oranges in one charge but as you can see you. Know the. Let. Me zoom. A little bit here you, know. The. Data. Is not the the, format is not in sync, right there, are different units and on both of them so we added api's to actually change the data, as. You can see when I click this button you can you can have a fair, comparison between lemons and oranges, I can. Also format the axis. Something. Like an atom before, I can, add secondary, axes, if I need to and I can format them, very. Powerful and. Then I cannot other types of charts I can do formatting, like this, I. Can. Also create scatter, charts. Okay. So there are a bunch of new chart types and you'll I will see I will Google see more in a few seconds but, then one of the things that that developers. In Excel also want to do is they. Want to print, a copy of these reports, they want to be able to create you.
Know Pages, of documents. In very, specific formats. So. In the EPI we also added, access. To the page layout object, and the page layout object, enables you to create margins, and then, able to set up break pages, and stuff like that and. In this case you, can also add headers and footers and, you can do everything, that you can do on the page layout you can do with with. The API and, the API as you can see it's just, the. Only way to visualize what's going on here after I click is if I do the print preview right, so. The Print 300. Seconds. Yeah. I. Really. Want to show you this demo because there's, something I have to disconnect, my printer, from from campus because. It was getting slow but. Okay. Scrap. Its. Set up a. Print. Area before doing this. Okay. Then. You got some sample data, they. Make sure that it's working prepare report and then. I can go and go. To print preview. For. Whatever reason is God. Demo gods are not helping, me today but it. Is working so this. Is basically showing you a report that has many pages and headers and you can do all those changes. Okay. So. I'm. Going to show you some other, demos, in the iPad, so. I'm gonna go ahead and switch. To this monitor, here. Great. What. I want to show you now it's the new charts, that are in better today. But. I want to show you them in the in an iPad I. Have. This device here I can actually run my ad, in. And. Again this is the we, will redo all this charts as a result of a request form and from the ideas team and. Now you're going to be able to again add some sample, data into the workbook, so. You can see that my my. Some, data here and you cannot now the the, new map charts. So. As you can see here. There. You go there's the map there are some but so this this data has geographic. Information about, the US so. It automatically, identifies, what geographic, data you are due you are you are using and it adjust. The chart as needed if this was series. In the world it will it will map to a work world. Chart and. Then one's going to have the Charter you cannot labels you can split the the data into different states with certain criteria, you. Can also add whispered. Charts you, know if you want to do stock stocks, charts, and stuff like that. You. Can customize if you want you can remove the axes. And stuff. Another type of chart is a waterfall chart, you. Can see here you can also have access to that songbirds charts, there. You go you can do a Pareto so you can't represent your 8020, s as well. You have three maps. And. You get the idea so on and so forth so, if, your solution is about charting, you. Definitely. Have. A solution, in. Our platform and it will be awesome to see your solutions. In our store and, finally. I want to give you them about shapes. What. We're doing in time between, perfect, so. One. Of the big API is that we are doing in the team today. Is that. It's. A shapes API and, in. Case you don't know about it. Shape. In. Excel. Everything, that floats in the workbook it's considered, you, know a shape, and that. Is true for this. Picture that, I took recently on a trip to China where, all the Excel API team is located and this, amazing work we. Went to see the pandas there so here's a picture of this this is a shape a textbook is a shape this triangle is a shape all the lines are shapes even, Agabus are shapes and. You. Will see a well how. Do people use this you know to create solutions well they use it in many many different ways well they use it for example to create reports like this they are charts, and this is nothing but you. Know, just. Shapes. And squares with numbers and different formats, they. Also do it. To. Create dashboards like this one you will see probably the demo later today this is this is a very, awesome. Trick, this is just an saved. It's. Grouped but. If you remove the group and you go to the details here you will see that you. Know the temperature, is really a rectangle. And depending, on the values this is just in size increase and stuff like that so, that's done with shapes. You. Also do it for usability so you can actually include like funnels like this close, to your data and then make the developer click on those shapes and do some action and.
Those. Two parameters of the distribution by, the number of tickets I sell divided. By the number seats on the flight, okay. Now why do I do that well, if, you think about it if you do change your policy and you oversell the flight by ten, percent what. Do you think will happen to no shows, now. They should go up and they should go up proportionally, right, so, that's why we do this. All. Right so now the. Rest of this model it's a very simple, Excel, model and part, of the message, here is that. In. Like data, fitting or or machine, learning to historical, data is not enough if you, want to take prescriptive. Actions if you want to do prescriptive, analytics where. You are going to do something in a new that has not been done before your, historical data and you, know just prediction is not enough, by itself so we're gonna simulate what, we could do if we order solve a flight now, at the moment we're just. We. Have, 300 seats and we're gonna sell 300 tickets and that's it nobody no over selling what. We're gonna do now is run a Monte Carlo simulation which, means that we're gonna we're going to simulate this flight taking off a thousand, times and. Each. Time we will randomly, sample, from the distribution, so we'll get some number of no-shows then, we collect statistics, and make, charts and all that so. To do that all we. Need does the model is pretty simple and what the model calculates. With a little Excel formulas, is, like this is that. Our net revenue, after. Accounting, for no-shows. Where we give money back and in effect to, the to the people who didn't show up and, overbooking. Compensation, if we do oversell the flight and we have to no pay people. That we bumped in some, fashion that's also taken to account with just a few formulas. All. Those well we'll just run, this again but going back to the to, the backend REST. API server, and. Sure. Enough it comes back for us and, this time it's showing, us a, distribution. Of the outcomes, we could, expect that we've simulated over. A thousand, case, of this flight taking off as you, can see our net revenue, it, its average is 58 thousand four hundred but. It can get as low as you know all fifty six thousand maybe five hundred and you can very, occasionally, touch sixty. What what do what it mean if it's if it hit sixty thousand if. You think about it you probably couldn't see this because it's in the back of the screen now but my ticket price is $200, I've got 300 seats sixty, thousand is the best I can do and now, if you think for just a minute you realize if you are the airline and you only sell 300 tickets you, can't win I, mean. Like occasionally. You'll fill your whole airplane but most, of the time there will be no shows and your revenue will be less within sixty thousand effective sort of always will you less that's. Not so hot, here's, actually our sensitivity. Of revenue. To the number of no-shows which is a negative, number of course and this, also shows our revenue declining, with. The with. The number of no-shows we get. So. One thing we can do is just play what if right so let's let's. Sell. One hundred three hundred and ten tickets, those, were the the, adding. Functions. Updating. For. A moment there don't, be too surprised if we say see getting data and it stays there for a little bit but. I'll run the simulation, again. And. Comes back pretty fast and notice that our mean, revenue has gone up to sixty thousand two hundred fifty nine the. Whole distribution is shifted a little bit and, so that kind, of looks pretty good and so. Let's get. Aggressive. It's. A. Cell, for our tickets you know maybe we'll have a hundred no-shows and. Is that is that a good idea is basically, the question here. So. It, comes back again and, well. Would be Hallward our revenue went down fifty. Eight thousand, two hundred and, forty. Four is the mean, and. There is a little clue about what's happening and one thing is that this is now shifted over to blue instead of red that is but, over here is really the information. We just we are over selling by so much that that, as. We, get more Morneau, shows our revenue goes up but, we never we, never hit our over selling. Point. So, we actually are, worse, off, okay. So we've played around with that now. What we'd really kind of like though, is to. So. A little bug probably in our software is this flashing, part over here please just sort of bear. With us on that but, we'd really like the you know the software to find out the optimal, number of tickets.
To Sell that would you know best balance. The. You know the the. Effect of no-shows versus the cost of over, booking right well. We have a model, that already, computes. What. Happens, over. A thousand, trials this. Sell down here, is the. If you can see it says side I mean it's its commits, returning, into the spreadsheet the mean value, of revenue. Over all those trials, and, over. And here. We actually have the, our decision that we're making the number of tickets to sell so. Remember, we we built solver you know so we should help to do this so. I'm, sitting on this cell and I want to say that is the decision, variable I, want. The solver to figure out what that number should be and. Then this cell down here, is what. I want as my objective, and I, want to maximize, it and. Then, there's one little thing I need to do which is to tell it over here that I want. To do the simulation, optimization, so. What we're actually asking it to do is go. Off to the server, run. An optimization, where it's adjusting, the number of tickets through so you know try tried lots of different value switches to sell each time run, a simulation, of a thousand trials, and compute. The results, and and help. Us find the optimal. Result, if. All goes well. No. Wait that's not what I wanted or expected. I'm. Not sure it sees. The. Optimization. Elements. And. That's. It. Might be us we might be waiting for, Excel online to save. Try. Running it again. Okay. It's, it actually has come back and told. Us that three hundred twenty three tickets is the optimal, number of tickets to sell and for, once we have getting data in the in, the cells but but. Hopefully this shows you what I wanted, to show you. Okay. So I think that's it and I think we want to switch, off here to, to. The other live demo thank you very much. Can. We move to the presentation. Hello. Can you hear me hi, everyone i'm matteo from hannah uk-based, start-up, so. Let let, me give you a little bit of background hannah, is an IOT company. Which. Aim to provide, solutions. Communication. Data, in, across. The globe for, IOT companies. And. We. Are here to present Simba. And he's a Dean for Microsoft. Excel. So. Let's. Start by saying I'm, impersonating. A. Supply. Chain manager, from an SME, and, I. Came, to to Microsoft, ignite and, I've, discovered some visa so. I went off on my own this. Hannah. Consolation. Visa website, and I purchased. Few. Of these with. An investments, of 300. Bucks and, actually if you if you go they're. Really, on sales, and you can actually use an ignite 18, promo code to get an 8 a 10 percent discount on, those boards I.
Got. These devices, and and I'm going to show you what I did after well, the unboxing, procedure, was very simple, because I simply took the device and I, went on the portal, I registered. Myself on. The Hannah's flash simply, support tool and I blinked, these devices, to my account, then. What I did is that I act entered, in the, Excel. And I, downloaded. Sbisa. Add-in which. Appears. Now on the right. Corner. So. When I open the sim visa at Dien now I have visibility, across all, my devices and, they. Appear with, a serial, number and an alias and I can actually customize, the alias. So. What. Happens next well. Let's. Go. And check what. The symbols are adding offers, what. We offer is that we developed, a bunch of custom functions, and we're going to start by. Maybe querying from. The physical. Device. The. Actual battery, level so. I'm going to go I'm going to get the battery, and I'm going to pass the serial number of the unit. And. If. Seems. Like it's. Not. Yeah. Out, closing, and open again thank. You. That's. The beauty of live demos. Here. We go back. Oh. Here. We go so suddenly. A cell, in Excel became. Actually a window to, the real world this, is a live. Data. Feeding, from a physical device within, your Excel spreadsheet. It's. Quite powerful but this is a static, data I just query what was the last. Battery. Available. The battery value available. To. Be sincere I want to be able to constantly, monitor I want to be able to have a live. Stream of what is going on and that's why we also developed, a bunch of custom. Streaming functions, those. Streaming functions, for example to check what, was the last time the, device updated. Some, data, and. I'll do the same i'll query the function and pass. So. Here we are both but it by the way it is a GMT, time so. There's. Some hours of delay between. Here and and where, it the, server's is hosted, so. Just. To give you an appreciation, this. Is the number of currently, available custom. Functions, in the Excel syn. Visa atom they, range from. Environmental. Data so, temperature, humidity pressure. Life. Feeding from the device, kinematic. Data so, we we have something. Like the teal detection, we see we can see, the orientation of the device we, can see if. Device dropped, and, and. We also have some historical streaming, functions, that allow you to have actually. Multiple, data set across the time so the the latest X number, of payloads, if you want to see trends if you want to see. Analyze. Trends and visualize those, so. Ok, now now a. Can I have understood, a little bit what these custom functions do when yes. I I, can see I can feed. Live data inside, an, Excel spreadsheet but. Let, me take a step back and tell. You about something, what. Can I really want to do with these products, is to, solve a problem, is well, known. Circular. Dependency, problem, so every company outside there, has. Three. Person. A person. With a problem a person. With, the money and the person that actually has the technical skills to solve the problem and the, person and the. Person with with, the problem needs, to convince the person with the money and the person, with the technical skills to be able to provide a solution with. The amount of money available and. That's. Spittin, seer this always, ends, up being a very. Very long process and, sometimes. He. Actually, doesn't. Let companies innovate, and, bring solutions. To their business. When. We think about I when we think about Excel. We, think about +. 1 billion installations, and let's face it every, single business man outside, knows. How to make his way into a spreadsheet and, on. The other side you know we, have a product, there that is, affordable. A product, that is as, simple as you, can buy it you actually get free credits. Inside the device and the, only payment that you have to incur is the, single, transaction, of the single data transfer. From the device into, your Excel, spreadsheet. So. Now. We've. Seen a little bit where we are and, we. Don't introduce what is the, first, let's. Say sim bisa dashboard. The. IOT, version. Of Excel. We. Can see there are a bunch of different columns. Ranging. With different type of data from, temperature, humidity, location. But. What's really interesting here, is that thanks, to Microsoft. Office, 365, excel. Shapes, we. Were able to build custom. Shapes custom. Shapes a give a look and feel to this dashboard that looks like almost a, web-based, dashboard, but. It's everything here in Excel so now I'm gonna take. This device it. Was under, the, light so you. Could see that the light level expressed, in lakhs is quite AI 300. And the orientation of the device was, sitting. Flat and, I'm holding in my hand we. Have to give it some little, bit of time unfortunately, with the 30 thousand people in. This building. GSM. Sometimes Oh take. His time and. Yeah. I, was. Gonna update the game is now updated, the vertical one I was gonna pay yeah here we go and the. Light came. Back to 45, lots. But.
When We think about this kind of solution we, also wonder, well, we're, where are the workflows, how, can I actually make. The. Best usage, of it well, when we say that this add-in. Connects, Excel, to the real world we. Really mean it in fact. What, we can also do is that. We can send a message from. The cell in. Excel down, to the device and. You will appear on the screen so. Now I'm gonna try to fire the. Camera. Should be on to, correct. How. They move it on one. There. We go. And. I'm gonna send. Something. Like, excel. Rocks. It's, taking some time. Here. We go. Up. The. Camera, is not a passive. Device. Just. Updated here but the camera is not showing the updates, if. Someone. Wants to walk here and see the device I don't know why the the. Camera looks, like he's actually frozen. Which. One. If. Okay. Okay. Well, I'll, see if you like the device around you can actually see the message. So. I, think. If we have last. Couple of minutes to close, these we. Wanted to prove. Another, solution. And under sort of. Use. Case for these so, I come, back to the fedot I was this supply. Chain manager, and I, purchased a bunch of devices so. What I did, is. That. Number. Six I. Purchased. A bunch of devices and I actually deployed, them across, the world and. Should. Have been open both at the same time yes. Was not. A wise idea. We. Go and now what I have is another, kind of dashboard where thanks. To. Conditional. Formatting and. The. Ability of adding a big, map inside. -. Brr itself I can, actually see, and monitor my, assets, across the globe I have one device sitting in London one device sitting in Brazil. One, in Phoenix and one here in Orlando, the one on stage and. The. Power of these fusion. Between. What. Microsoft, Office. 365 offers. With, Excel and custom, function and streaming functions, and the ardennes combined. With the solution, Hanna wants to bring is what. The real innovation is, I hope. You enjoyed the demo and. I hope you enjoyed this presentation. Please, come, and visit our website. Www.rinaldin.com. Thank. You very much myself, that's. Great great demos guys number. Five. Sorry. We're I think we're kind, of at, the end of the presentation, I want, to thank you very much Daniel and Hunca, for for the demos it was awesome. Last. Message for all of you guys please, connect with us your, opinion, and your feedback absolutely. Matters on the team if. You have any question, you have any problems, with the API feel, free to go to stack overflow we. Have an office - just tag there and the team is extremely serious about responding there in less. Than 24 hours we also have a github repository where, you can actually go and, actually. Raise. Issues this is not for specific questions but issues you find with the API so with custom functions and in, user voice if you feel that there is a feature that is missing, or if, something. That we should do better or any recommendations. You have you can actually up both requests, or create new ones. Also. Here are some useful resources if. You want to know more, about custom, functions let's go just go to this website a kms. Custom functions there's. Also an open, spec so we are one of the few teams at Microsoft, that actually has the specs online so. You can actually go ahead to this website, and actually see the api's, that are coming the, API is that our own preview the ones that you can actually try using our beta endpoints, and of, course please. Try the platform, and happy. Coding guys thank you very much for your for. Your presence, here and we're going to be here round for questions if. You want to do, thank. You very much.