devtrackers.gg
over 1 year
ago -
EVE Online
-
Direct link
Transcript (by Youtube)
| 9s | hello everyone and welcome to CCP TV for |
|---|---|
| 12s | tonight's stream uh we're going to be |
| 14s | talking to you about the new Microsoft |
| 16s | Excel add-in that was just officially |
| 18s | released today after months of |
| 20s | development and hard work and with the |
| 22s | assistance of uh some of the internal |
| 23s | external beta testers that we had to get |
| 25s | involved with it as well got some really |
| 27s | cool guests for you here tonight but I |
| 28s | just want to talk about it for a minute |
| 30s | because |
| 31s | um they say don't let your memes be |
| 32s | dreams and the spreadsheets and space |
| 36s | thing has been a big meme for Eve online |
| 37s | for a long time but this add-in is no |
| 41s | joke it's actually a really powerful |
| 43s | tool that's going to be that's now in |
| 45s | the hands of players which they can use |
| 46s | with Microsoft Excel for a wide array of |
| 49s | tasks uh in Eve so joining me tonight to |
| 52s | talk about this is senior game designer |
| 54s | who worked heavily on this project CCP |
| 56s | Nomad we've got uh Oz who should be |
| 60s | known to all of you he's you know one of |
| 62s | the well most well-known the most |
| 63s | well-known Eve online Market Trader who |
| 66s | also has an excellent YouTube channel |
| 67s | and Discord which you should hang button |
| 69s | if you want to get some really cool tips |
| 71s | about how to make some uh big bucks |
| 73s | trading in Eve online and my very |
| 75s | special guest is Jacob Nielsen who is a |
| 79s | product designer for Microsoft Office |
| 81s | and who also collaborated really really |
| 84s | closely with us on this plugin tonight |
| 86s | welcome to the stream everybody and I |
| 89s | just and I was as this camera after I'm |
| 92s | just Frozen you're just Frozen again man |
| 94s | I almost made it to the finish line here |
| 96s | we go look I've got I've got this was |
| 98s | happening during setup so I prepared |
| 100s | accordingly so |
| 102s | um now you can look at this version of |
| 103s | the Oz and see if it gets on stock |
| 105s | market you'll see at some point it looks |
| 106s | almost the same yeah pretty much I'm |
| 108s | just glad I got the right oz of if who |
| 110s | once the camera started freezing could |
| 112s | it could have gone anyway |
| 113s | um anyway uh Jacob thank you so much for |
| 115s | coming when was the first time you heard |
| 117s | about this thing called Eve online |
| 119s | I I actually started learning about Eve |
| 123s | online when I joined the project about a |
| 125s | year and a half ago |
| 127s | um so I haven't played the Eve online |
| 130s | before that to be honest I don't want to |
| 133s | call myself a gamer at all the last game |
| 137s | I really played was Halo on the original |
| 140s | Xbox so that sort of says how many years |
| 143s | ago it is since I played a game |
| 147s | well I you know what I never played hell |
| 149s | on the original Xbox but I did play it a |
| 151s | bunch on PC so it has been a whoop you |
| 153s | so |
| 155s | um uh so did did Eve online come had you |
| 158s | heard about Eve online at all prior to |
| 159s | this or was the first thing you heard |
| 161s | about when someone at the office said |
| 162s | hey these people in Iceland uh have come |
| 165s | to us with this idea about making a |
| 167s | plug-in for their video game do you |
| 169s | recall when you first had that |
| 170s | conversation yeah well it was exactly |
| 172s | that you know a year and a half ago I |
| 175s | was like yeah interesting I've never |
| 178s | made a you know Excel add-in on an Excel |
| 181s | integration for a game before so this is |
| 184s | really a first and I don't think Excel |
| 185s | has had it at like an integration with |
| 187s | any video game is is that correct so |
| 190s | this not to my knowledge all right and |
| 194s | um this is something that they always |
| 195s | can probably speak to as well but Eve |
| 196s | online has obviously uh really really |
| 199s | complex industrial manufacturing chains |
| 201s | uh and a really sophisticated in-game |
| 204s | Market that you know you know Rivals the |
| 207s | scale of like some small nations in |
| 209s | terms of like the volume and the the |
| 211s | number of Commodities traded and all |
| 212s | those things on a daily basis which is |
| 214s | really really nuts |
| 216s | um once the scope of is it did you at |
| 221s | all once you began to to learn more |
| 223s | about Eve online did the the scope of it |
| 225s | actually seem really appealing and |
| 226s | exciting to you uh oh absolutely |
| 230s | absolutely like you know it's it's all |
| 232s | about data Excel it's all about data but |
| 235s | especially Eve online is all about data |
| 237s | and |
| 239s | um |
| 239s | I really I was really fortunate that I |
| 242s | had someone |
| 243s | that reached out to me that works at |
| 245s | Microsoft that is actually an Eve online |
| 248s | player and a really Advanced player and |
| 252s | through conversations with him he really |
| 255s | taught me about uh lots of things in the |
| 258s | eve universe and how you play the game |
| 260s | as an industrialist and |
| 263s | that led to many conversations about |
| 266s | what the add-in should do and I try to |
| 269s | build prototype that he was using and |
| 272s | you know saying giving me critique on |
| 275s | and and so on and I think finally we |
| 277s | came up with something that even he |
| 279s | would use in his gameplay |
| 282s | that's awesome and CSP Nomad speaking |
| 285s | for yourself uh how did you get roped |
| 288s | into this |
| 289s | cool that's that's actually a funny |
| 291s | story it was the the meeting the |
| 294s | preparation meeting for the if keynote |
| 296s | last Fan Fest so that was around |
| 298s | beginning of April I think and we were |
| 300s | talking about the elements of the |
| 302s | keynote or who's talks about what and |
| 305s | then at some pointy mentioned yeah and |
| 308s | you will be talking about the axle |
| 310s | adding to someone |
| 311s | and I was like hey what now |
| 314s | and I literally go got goosebumps on my |
| 318s | skin yeah uh just hearing about it and I |
| 321s | was so excited that even when I went |
| 323s | home that evening and I told my wife |
| 325s | about that same story and I got the |
| 327s | Goosebumps again so yeah get that and |
| 330s | like I wanted to be on this project from |
| 333s | from day one really and that's that's |
| 336s | how I got involved I remember when when |
| 338s | I first someone came in and mentioned |
| 340s | we're doing Excel plugin those into the |
| 342s | community team area we were like yeah |
| 344s | but why are you really here and they're |
| 346s | like no we're legitimately doing the |
| 347s | Excel plugin once we kind of yeah got |
| 349s | over that sort of that you know the knee |
| 351s | Jack oh you know the the spreadsheets in |
| 353s | space me we were like and started to |
| 355s | think about it and talk about it and |
| 357s | we're like holy this could actually |
| 358s | be really really significant and I'll |
| 361s | I'll just go to you you've played with |
| 363s | this a lot already During the debater |
| 364s | period is that fair to say |
| 367s | yeah absolutely I mean I'm I'm someone |
| 369s | who uh who's who spends everyone that |
| 372s | watches my stream knows that I spend |
| 373s | more time in spreadsheets than than in |
| 375s | in the client you know that's and that's |
| 377s | not that's nothing against the game it's |
| 379s | just that's that is my that is my game |
| 381s | that's how you play that and I you know |
| 385s | when when this was announced at Fan Fest |
| 386s | I was there right Rick I mean I was uh I |
| 389s | had a presentation just before and I was |
| 391s | probably screaming uh the loudest and um |
| 395s | for me you know the past month have been |
| 397s | really interesting |
| 399s | um in in in one way I am I'm really not |
| 403s | the the target group for this right |
| 406s | because I've I've taught myself to to |
| 409s | program and to build all these |
| 410s | spreadsheets I I built the spreadsheets |
| 412s | for the community for templates for them |
| 414s | to use and everything uh on the other |
| 416s | end I was a good person to test it |
| 417s | because like I was trying to replicate |
| 419s | things that uh that I was doing uh very |
| 422s | complicated before through this add-in |
| 425s | and uh that's I think that's something |
| 427s | that came to life here very very |
| 429s | beautifully and you know you've been |
| 431s | talking a lot about the democratization |
| 432s | of data and that's I think what uh what |
| 437s | this this will do this is certainly |
| 438s | something where you can very very easily |
| 441s | get a lot of data without having to |
| 445s | learn how to program or learn macros or |
| 447s | you know calling Jason uh scripts in in |
| 453s | Google Sheets or in Excel you know so |
| 455s | this is a very exciting times and happy |
| 458s | to be here not not only democratizing in |
| 460s | terms of accessibility to the data but |
| 462s | also like I've got this right haven't I |
| 464s | like the the web version of excel is |
| 466s | basically free to use with this with |
| 468s | this plugin |
| 469s | so you can just set up an account |
| 472s | download this plugin and start doing |
| 474s | everything we're going to show you here |
| 475s | tonight |
| 476s | absolutely that's awesome |
| 479s | all right well uh well without further |
| 481s | Ado let's like jump in and start taking |
| 483s | a look at some of this stuff so um CCB |
| 485s | Nomad are you ready to to start going |
| 487s | through what you've got there in front |
| 489s | of you |
| 490s | sure all right now let me see if I can |
| 492s | get this done with a minimum of |
| 494s | jankiness for the people who are |
| 495s | watching the stream here |
| 527s | wait |
| 530s | okay hello stream sorry about that |
| 532s | um there was no sound on that scene but |
| 534s | there should be now can you confirm that |
| 535s | you can hear us okay good thank you |
| 537s | apologize you didn't miss much uh oh I |
| 539s | just was just making sure was that uh |
| 541s | c2p Nomad has adequately scaled up the |
| 543s | um the cell cert we could read what he's |
| 544s | typing but if it's still still too small |
| 546s | for people on the stream please just let |
| 547s | me know in twitch chat we'll see if we |
| 548s | can boost that up a little bit more but |
| 550s | go ahead CCP nomad |
| 552s | yeah so how to get that in uh if if you |
| 556s | just start your your ex desktop Excel |
| 558s | you go to insert |
| 561s | my addings here then to the store |
| 566s | and then here search for search for even |
| 569s | line and that's that's it really then |
| 572s | you add the add-in from here |
| 574s | it will ask you a couple of questions |
| 577s | and you end up having it in your home |
| 580s | bar like so on the right |
| 583s | from where you can access that add-in |
| 585s | itself where you can add the characters |
| 587s | so when you click on it you get the tab |
| 591s | with the add-in |
| 593s | I'll just say that also you can get it |
| 597s | from the web Excel so if you just open |
| 600s | your browser and write Excel dot new |
| 604s | then it will open a new Excel workbook |
| 608s | for you where you you can follow the |
| 610s | same steps and add the add-in from there |
| 613s | so after you have the add-in you can add |
| 615s | your characters So currently I have two |
| 618s | characters here maybe I'll just remove |
| 619s | one of them to show you how to add one |
| 622s | and you get |
| 624s | the normal Excel normal if SSO login |
| 629s | that you could be familiar with that's |
| 631s | not showing on your screen because |
| 632s | you're sharing because we're all right |
| 633s | and I did ask you to share the app so |
| 635s | that's on me but I'm sure everyone |
| 636s | twitch chat knows what the the eve SSI |
| 638s | login window looks like it's where you |
| 640s | put in username and password and it |
| 641s | shows you the characters on that account |
| 642s | and you choose which ones you want you |
| 644s | agree to the Scopes and then you're good |
| 647s | exactly that yes and from there you can |
| 650s | select the the characters you want to |
| 652s | authorize so it's all the same process |
| 654s | that most of the players will be |
| 656s | familiar with |
| 658s | so yeah that's that's how you get that |
| 659s | in and here |
| 662s | it has all the functions categorized in |
| 665s | in three categories whereas public those |
| 668s | are functions that are not related to |
| 670s | your corporation or character per se |
| 673s | this is public information really then |
| 676s | character which require you uh which |
| 679s | require to provide a character for the |
| 680s | functions so for example if you want to |
| 682s | check the skills of a character then you |
| 684s | you will find the function here |
| 686s | like so for example |
| 689s | each function has a try it out button |
| 691s | which is very useful |
| 694s | when you click on it the function will |
| 696s | be copied to the cell you have selected |
| 698s | so in this case I'm using the character |
| 701s | skills |
| 702s | and there's no attribute supplied here |
| 705s | that means it's skills for both of my |
| 707s | characters at the same time so if I want |
| 709s | only one character |
| 712s | I can hear |
| 714s | get all my characters for example and |
| 717s | provide this function with just one of |
| 719s | them |
| 721s | and now I have the skills from one of my |
| 725s | characters and I will show how that |
| 726s | works in other sheets that have been |
| 730s | prepared so you can download the example |
| 734s | as workbook from the |
| 737s | help center article about the if online |
| 740s | excel add-in at the very bottom there is |
| 743s | a link here |
| 744s | to the example workbook it's also linked |
| 747s | in the news item that we released today |
| 750s | and that workbook contains a lot of |
| 753s | useful information how to you can what |
| 756s | you can do with that in do you want me |
| 757s | to show some of that off or should I do |
| 760s | that later I don't remember what the |
| 762s | schedule there isn't really a schedule |
| 764s | it's just like let's just moved through |
| 765s | as long as you get to talk about all the |
| 767s | things and show all the things you want |
| 768s | to show I'm cool with that so whatever |
| 769s | order you think is going to be most |
| 771s | naturally I will just say really quick |
| 772s | I've seen one or two people on Twitch |
| 773s | that saying like uh will this work on |
| 775s | Office 365 I believe the answer that is |
| 777s | yes |
| 778s | um uh somebody else had said that they |
| 781s | they're not able to see the the add-in |
| 783s | unfortunately we can't really Provide |
| 785s | support for you right now on the stream |
| 787s | uh there is a sub Forum on the Eve |
| 789s | online forums there's also uh we can |
| 791s | also ask on the Eve online Discord |
| 792s | someone who's gone before you may be |
| 794s | able to guide you into what you need to |
| 795s | be doing so if anyone is watching this |
| 797s | live and currently trying to like get |
| 799s | the plugin set up I'm afraid um afraid I |
| 802s | can't uh we can't give you any help |
| 804s | right now on Twitch chat yeah getting |
| 806s | help from from the community is great |
| 809s | but you can also just send a support |
| 810s | ticket and then our customer support |
| 813s | will handle it as well sure |
| 815s | all right sorry carry on |
| 817s | yes so so those are like examples how |
| 820s | you can use the functions from here |
| 823s | um |
| 824s | for example what what other stuff I can |
| 827s | say or I can show like inventory search |
| 831s | so this function will provide for |
| 832s | example |
| 834s | uh here it is supplied with the word |
| 837s | rifter and it returns all the types that |
| 841s | have rifter in its name right so that's |
| 843s | one way of searching for particular |
| 845s | types |
| 847s | but also is important about this add-in |
| 850s | that it is built utilizing the entity |
| 852s | data cards so every entry here |
| 856s | is actually multi-dimensional data in |
| 859s | one cell that you can access by clicking |
| 862s | on its icon |
| 864s | where it shows a little model window |
| 867s | with all the information |
| 868s | contained within that cell and that you |
| 872s | can then extract into other cells next |
| 875s | to it |
| 876s | so for example we have this rifter |
| 880s | absent hero skin whatever that is or |
| 883s | maybe blueprint will be better to show |
| 885s | and I can |
| 887s | have access to all the attributes of |
| 890s | that particular cell which in this case |
| 892s | is specific item type |
| 896s | so I can have its volume for example |
| 898s | which is 0 1 cubic meters for a |
| 902s | blueprint obviously |
| 904s | so that way you can build |
| 907s | uh the stretches you the way you want |
| 909s | you have access to all the information |
| 911s | and that's the information is nested |
| 914s | within cells so for example |
| 917s | this one |
| 918s | if we extract the type from it okay so |
| 921s | this is type already |
| 923s | maybe I'll later show another example |
| 925s | what does it mean if for example I get |
| 928s | for a blueprint |
| 935s | function that shows a blueprint so |
| 938s | character blueprints that's okay |
| 943s | so my characters have just one blueprint |
| 946s | I those are just testing characters and |
| 948s | that blueprint have for example |
| 951s | all the information that you would |
| 953s | expect a blueprint to have |
| 957s | so I have the material efficiency time |
| 959s | efficiency type and so on |
| 961s | I see it's also got like a new like hit |
| 963s | the location and things like that so |
| 966s | um yeah you can also make a spreadsheet |
| 967s | to track your own assets |
| 969s | absolutely so I've made a few examples I |
| 971s | will just show them |
| 973s | um so this this shows all your |
| 976s | characters so basically this call is |
| 978s | active character without any character |
| 981s | provided it will show you all the |
| 982s | characters that you have authenticated |
| 985s | and for all each of those characters it |
| 987s | shows a few different values |
| 991s | like total assets isk file is wallet how |
| 995s | many skill points how many skills and so |
| 997s | on here if you want to |
| 1000s | go deeper into the skills of specific |
| 1002s | character you can choose one of the |
| 1004s | authorized characters |
| 1006s | and it will populate with all the skills |
| 1009s | of that character will group them and it |
| 1012s | will even show you a chart |
| 1014s | um |
| 1014s | showing where those skill points are |
| 1018s | nice yeah someone asked in twitch that |
| 1021s | can you also use this to see how much |
| 1023s | time you got left to go on like Amiga |
| 1024s | for certain characters and stuff or no I |
| 1027s | was going to say or is literally the |
| 1028s | first question I pull out of twitch that |
| 1030s | the one that the answer is like no |
| 1031s | that's the one thing we didn't do all |
| 1034s | right no well there's your answer anyway |
| 1036s | yeah so you were asking about assets |
| 1038s | yeah so for example this call here even |
| 1042s | line character assets uh will return |
| 1046s | all the assets for example in this case |
| 1048s | it is from all the characters that have |
| 1050s | been authenticated because I haven't |
| 1052s | provided any particular character in the |
| 1056s | function call |
| 1057s | so you can tell those are Noob |
| 1059s | characters because they don't have that |
| 1061s | much so you could throw in a character |
| 1063s | id into that and it will just narrow it |
| 1066s | down by that character and you could |
| 1067s | have a separate tab for every one of |
| 1069s | your characters and just like click on |
| 1070s | it and yes definitely and it's not only |
| 1073s | that the character id that you can |
| 1075s | provide you can provide the character |
| 1077s | entity right which is this very thing |
| 1081s | so you can refer to this cell |
| 1086s | when when making that call |
| 1088s | so you don't need to know the IDS |
| 1090s | necessarily you don't need to operate |
| 1091s | with IDs you can always use the entities |
| 1094s | themselves in most of the functions |
| 1098s | that's cool |
| 1101s | so yeah so the last one I'm sorry go |
| 1104s | ahead yeah I'll show just the last one |
| 1107s | about Manufacturing |
| 1111s | um |
| 1113s | okay if I make it bigger it doesn't fit |
| 1115s | but we'll manage |
| 1117s | so in this one this is a calculator of |
| 1121s | profits for manufacturing that takes |
| 1124s | into consideration all the parameters |
| 1127s | that that really matter |
| 1129s | so so here let's say we we choose a |
| 1132s | blueprint Let It Be caracal and then it |
| 1136s | calculates automatically all the profits |
| 1139s | that I can I can get from it based on |
| 1142s | all the inputs that I can provide I can |
| 1145s | see here it's got It's got the material |
| 1147s | efficiency and time efficiency the |
| 1149s | blueprints take into account what kind |
| 1150s | of structure it's built in manufacturing |
| 1153s | system cost what tech level the rigs so |
| 1155s | it the the quality of the blueprints the |
| 1157s | quality infrastructure that you're using |
| 1159s | and I assume incorporates your your |
| 1160s | skills as well yes absolutely and this |
| 1164s | will show you our result |
| 1166s | where the red line shows the sales price |
| 1169s | for this item and the bars show the |
| 1172s | actual cost which is the material cost |
| 1174s | the job installation cost and the market |
| 1177s | related cost altogether and this shows |
| 1181s | three different scenarios where the |
| 1183s | first bar is your scenario that you are |
| 1186s | experimenting with the middle one is the |
| 1188s | worst possible scenario as in |
| 1189s | unresearched Blueprint and you are doing |
| 1191s | that in in station with with no bonuses |
| 1194s | and this is the best possible scenario |
| 1196s | so you can see that there is space to to |
| 1200s | improve right your own efficiency you |
| 1203s | can make money producing this very item |
| 1205s | if if you want it it's just a matter of |
| 1208s | comparing which attributes I want to |
| 1210s | improve like in this case the best |
| 1212s | scenario has the fully researched BP so |
| 1216s | maybe I can get that too and maybe I |
| 1218s | should do that in sotio instead of write |
| 1220s | a rule that gives me better bonuses and |
| 1222s | so on so forth |
| 1225s | and when you do all the calculations and |
| 1228s | you finally come a positive for the what |
| 1233s | you need for example this one the |
| 1235s | building is in cheetah which has 23 |
| 1238s | percent |
| 1239s | uh industry cost index |
| 1242s | don't build stuff in GTA have such I |
| 1245s | every time I do an Abyssal run I come |
| 1247s | back and I'm like oh I got a red Mac |
| 1248s | blueprint copy I just right click buy |
| 1251s | all from G to throw it in the oven pull |
| 1253s | it out again I'd even think about it I'm |
| 1254s | such an idiot yeah so for example if we |
| 1256s | change it to the Dixie just for example |
| 1258s | it drops to six percent |
| 1260s | so that's already tells you that you |
| 1263s | just saved like 18 16 of |
| 1268s | of the value of the item in in profit |
| 1270s | potentially |
| 1273s | and here you get a bit of material bill |
| 1275s | of materials that you can just select |
| 1277s | and copy and paste it to the multibuy in |
| 1280s | the game by the stuff that you need to |
| 1283s | to manufacture the item you could draw |
| 1286s | that even further I imagine and sort of |
| 1288s | rather than doing minerals here from the |
| 1290s | build materials you could take that into |
| 1291s | or |
| 1292s | bring in your mining skills for your if |
| 1295s | you've got mining Ops and things like |
| 1296s | that and you can figure out exactly what |
| 1297s | your actual profit margin is going to be |
| 1300s | if you if you mind your own or because |
| 1302s | everyone knows that mining or is free so |
| 1304s | you can take that into account |
| 1306s | um uh Jacob like when it came to all of |
| 1309s | this stuff like what was the actual |
| 1311s | nature of the collaboration between |
| 1313s | CCP and Microsoft on this like what did |
| 1318s | it was a typical email exchange look |
| 1320s | like or you know uh how did it actually |
| 1322s | work how much how much teaching CCP |
| 1325s | about Excel was involved and how much |
| 1327s | teaching uh Microsoft about evils |
| 1330s | involved |
| 1331s | you know I think the the main thing that |
| 1333s | we did for this was to make something so |
| 1337s | um we started out |
| 1339s | doing a few basic demos that were then |
| 1342s | shown at The Fan Fest last year and that |
| 1345s | was just you know a small script that |
| 1347s | demonstrated |
| 1349s | the capabilities of excel that we we |
| 1351s | thought could be useful for for this |
| 1353s | island mostly the data types that that |
| 1357s | Daniel was is showing us right now and |
| 1360s | it's sort of a central piece of of the |
| 1363s | whole experience and then after The Fan |
| 1365s | Fest |
| 1366s | we really we worked on a on a proof of |
| 1370s | concept prototype that |
| 1372s | interfaced with the the eve |
| 1376s | API and brought the real data into into |
| 1379s | the whole experience and at some point |
| 1382s | the CCP team completely took over that |
| 1387s | that code base and evolved it into what |
| 1389s | you're seeing right now and from that |
| 1392s | Daniel has has really created something |
| 1396s | incredible Excel spreadsheets we showed |
| 1400s | some examples of what could be done but |
| 1402s | it's you know this is completely uh |
| 1404s | taking it so much further in in what is |
| 1408s | possible with the building blocks of of |
| 1410s | the add-in yeah I've just taking it |
| 1414s | further is right I know someone in in |
| 1415s | chat when Daniel was showing the um the |
| 1418s | sheet uh with the the build graphs on it |
| 1420s | they're like watch witchcraft is this |
| 1422s | but one thing I glossed over at the |
| 1424s | start yeah it was just like |
| 1426s | um you're the product designer at at |
| 1428s | Microsoft for Microsoft Office what what |
| 1430s | is that job actually entail what's your |
| 1432s | like what's your day-to-day look like |
| 1434s | well my day-to-day is uh trying to learn |
| 1437s | a lot about the needs of excel users or |
| 1441s | more generally spreadsheet users or |
| 1443s | users that work with data so I spend a |
| 1446s | lot of time connecting with customers |
| 1448s | and in this particular case it was not |
| 1450s | only you know players of Eve but it's |
| 1454s | also a CCP and the team there to really |
| 1459s | understand what what is this from or |
| 1461s | should this be from a user experience |
| 1463s | perspective but also from a from this |
| 1466s | business perspective and then it's |
| 1468s | really like working with feature Crews |
| 1470s | within the Excel team to come up with |
| 1472s | solutions that cater to those needs and |
| 1476s | figure out a way that we can build that |
| 1478s | and and and bring it out to to Market |
| 1481s | you know in parallel with this project |
| 1484s | we also worked on the programming |
| 1488s | interfaces in Excel that allows the |
| 1491s | add-in to actually deliver or return the |
| 1495s | data types onto the Excel grid that was |
| 1497s | not something that was completed or done |
| 1499s | there was a there was a feature crew of |
| 1501s | Engineers uh working hard to to realize |
| 1505s | that within within Excel that's cool is |
| 1508s | that something you'll be able now to |
| 1510s | deploy it otherwise apart from just what |
| 1512s | you've done here with the eve adding oh |
| 1515s | yeah it's been out there for a while and |
| 1518s | and available to to developers to use to |
| 1521s | create these data types that are really |
| 1524s | uh quite quite unique and some some |
| 1527s | quite an innovation in the category of |
| 1530s | spreadsheets because uh you know |
| 1534s | traditionally and from the beginning |
| 1536s | spreadsheets has been been about putting |
| 1538s | numbers and text on a grid and then |
| 1540s | connecting that with formulas but what |
| 1542s | data types brings to the spreadsheeting |
| 1545s | experience is really these sort of Rich |
| 1547s | values complex objects that can be put |
| 1549s | into a cell and and treat it as as |
| 1552s | values that you can expect as you saw |
| 1555s | Daniel do extract uh specific values |
| 1559s | from it and and so on and also in in |
| 1561s | some cases |
| 1563s | complex nested values within within |
| 1567s | those data types or list of things like |
| 1569s | for example the materials on a on a |
| 1571s | blueprint and things like that |
| 1575s | um and I assume over the years we |
| 1578s | mentioned before that this is the first |
| 1580s | um video game that you've sort of |
| 1582s | Microsoft Excel has like collaborated |
| 1584s | with but there's no doubt a whole bunch |
| 1586s | of other uh let's say drier |
| 1588s | um applications and and other data sets |
| 1590s | that you've probably collaborated with |
| 1592s | before did you just how would you |
| 1595s | characterize working with a game company |
| 1596s | uh versus you know a more I won't say |
| 1599s | the word professional because we're all |
| 1600s | professionals here but let's say like a |
| 1602s | more mainstream utilitarian |
| 1605s | um uh third party |
| 1608s | well I think it's been fascinating to be |
| 1610s | introduced to a world that was |
| 1613s | unfamiliar to me |
| 1614s | um I've I've not worked with a game |
| 1616s | company before I don't want to say that |
| 1619s | it's particularly |
| 1621s | different in the in the approach in how |
| 1624s | the people that I've worked with at CCP |
| 1627s | has thought about this this whole |
| 1630s | project in terms of formulating the |
| 1632s | goals and how they've thought about what |
| 1635s | should go into the add-in and and so on |
| 1637s | I think you would see that uh other |
| 1639s | places as well there's just one thing |
| 1642s | that really comes to my mind for this |
| 1644s | project is that I think that in terms of |
| 1648s | a mission of what the add-in should do |
| 1651s | and and also our mission at Microsoft |
| 1654s | which is really this the reason why we |
| 1657s | go to work is to empower every person on |
| 1659s | the planet to really achieve more and |
| 1662s | that's that's been one of the guiding |
| 1664s | principles of developing this add-in and |
| 1666s | really something that the team at CCP |
| 1669s | has been putting a front and center and |
| 1672s | this is really let's make sure that more |
| 1675s | players of Eve can get access to the |
| 1678s | data and do more with that data and also |
| 1681s | make the game |
| 1683s | more approachable |
| 1685s | for for those players and especially new |
| 1688s | players that may not have the developer |
| 1691s | skills to build uh |
| 1694s | one of the very elaborate solutions that |
| 1698s | are out there outside of the of the game |
| 1700s | today yeah that's that's something that |
| 1702s | Oz mentioned actually when he was uh |
| 1704s | speaking earlier is that how you know |
| 1706s | this this |
| 1708s | add-in isn't really going to be super |
| 1710s | useful to him because he's he's got the |
| 1712s | ability to create all his bespoke tools |
| 1714s | himself but it just lowers the barrier |
| 1716s | of entry for for everybody else and it |
| 1718s | means that all the people who who didn't |
| 1720s | know I mean so us for example the adam4 |
| 1723s | eve website that you often show during |
| 1725s | your during your live streams every time |
| 1727s | uh sure your your regular viewers are |
| 1730s | very very much used to seeing it but |
| 1732s | every every so often Oz will come and do |
| 1734s | just a guest stream on the CCP Channel |
| 1736s | and he'll he'll do his normal show but |
| 1737s | just on this platform and just just |
| 1739s | because it's got It's the CCP Channel a |
| 1741s | lot more people sort of come in |
| 1743s | um because you're a little skin goblins |
| 1745s | than you want to go netskins probably |
| 1747s | but they're always captivated when they |
| 1749s | actually start watching your stream |
| 1751s | particularly when you show off that |
| 1752s | adam4 Eve utility just like how powerful |
| 1754s | it is and the number of people who just |
| 1756s | don't know that it exists right |
| 1758s | automatically gives a massive advantage |
| 1761s | to to people who know how to exploit the |
| 1762s | tools that are already in the ecosystem |
| 1764s | the really really good array of |
| 1766s | third-party tools that are that by |
| 1768s | developers have been making for years |
| 1769s | and even have done a fantastic job but |
| 1772s | this is this is a a just a spreadsheet |
| 1776s | you click on add a plugin and then a CCP |
| 1778s | Nomad we're showing you before you just |
| 1780s | have a bunch of stuff on the side and |
| 1781s | you can just begin to play with it and |
| 1782s | just kind of unfolds in front of you |
| 1784s | just what you can do with it |
| 1785s | I just said that last week on my stream |
| 1787s | I think |
| 1788s | using tools like Adam adam4 Eve or even |
| 1792s | even achieve assets uh |
| 1796s | you're probably above 80 of the player |
| 1798s | base already it's almost cheating isn't |
| 1800s | it just by first of all knowing it |
| 1802s | exists it's so it's so powerful that |
| 1805s | that you can you can make very good |
| 1807s | money and Eve online just using those |
| 1809s | tools and now it's it's going to be very |
| 1811s | interesting to see what this |
| 1813s | democratization is going to do |
| 1815s | um to to profits in in trading in in Eve |
| 1819s | because the question is are you know how |
| 1823s | how little effort is too much because I |
| 1825s | think now nobody has an excuse there's |
| 1826s | really no excuse left to not build a |
| 1829s | spreadsheet and uh and and and really |
| 1832s | maybe we can drop that that 80 number |
| 1834s | down to 50 of people that are now using |
| 1836s | the data yeah I did fish this one |
| 1839s | question out of chat before I don't know |
| 1841s | if anyone in the chat is in the Stream |
| 1842s | excuse me is in a position to answer it |
| 1844s | but it was uh from Chris matica who just |
| 1846s | said is there will there also be an API |
| 1849s | for LibreOffice or is it exclusively for |
| 1851s | Microsoft Excel I'm not familiar with |
| 1853s | LibreOffice Microsoft Excel I assume |
| 1855s | it's uh like a competitor or something |
| 1858s | like that |
| 1859s | um I I don't believe we haven't we |
| 1861s | haven't been working with anyone from |
| 1862s | that end to develop that uh some people |
| 1864s | have also asked about Google Sheets |
| 1866s | plug-in I believe there's actually one |
| 1867s | something similar to this floating |
| 1868s | around which is community made but I |
| 1870s | don't know any details on that |
| 1872s | but I'm going to keep this one to excel |
| 1874s | anyway |
| 1875s | um CCP Nomad did you manage to get |
| 1877s | through everything that you wanted to |
| 1879s | I thought you can be frozen there for a |
| 1881s | second uh then you moved your eyes uh by |
| 1884s | the way uh kaldari Prime Capone Club |
| 1886s | wants you to start recording audio books |
| 1888s | so you can you can listen to your dolls |
| 1891s | at tones on the way to work probably |
| 1893s | um that's nice of you yeah did you get |
| 1896s | it there was there was one more question |
| 1897s | in chat that I thought was very |
| 1899s | interesting oh yeah if you guys spot |
| 1900s | anything just like call them out yeah |
| 1902s | they fly by but one of them uh I I read |
| 1904s | and I was curious about it that's |
| 1906s | um |
| 1907s | we know a lot of things this add-on is |
| 1910s | going to make easier |
| 1911s | um that before you had to use the the |
| 1914s | API for |
| 1915s | um or or various other ways is there |
| 1917s | anything that this add-in can do that |
| 1921s | wasn't possible before and this question |
| 1923s | you know I can't answer it but maybe |
| 1925s | Jacob or Nomad maybe you guys can think |
| 1929s | of something that is now possible that |
| 1931s | that wasn't even possible before |
| 1933s | well one of the things that wasn't |
| 1936s | available in the easy API was actually |
| 1939s | the information about blueprints like |
| 1941s | the only way to get blueprints from that |
| 1943s | API was through the static file download |
| 1948s | and as part of this we I believe the |
| 1952s | team enabled an API for blueprints which |
| 1956s | is used by by the ad and I don't think |
| 1958s | the add-in is is using the static file |
| 1960s | download anymore |
| 1964s | yeah that's a good point |
| 1966s | yeah that's that that is correct so some |
| 1969s | of the data isn't available in ESI and |
| 1971s | we made it into the add-in I also want |
| 1975s | to say that there's some very you know |
| 1978s | we started out making some really simple |
| 1981s | functions like for example the product |
| 1984s | search that Daniel showed earlier and |
| 1987s | things like that and then talk about the |
| 1990s | end of the the project we got into |
| 1992s | making something that was more and more |
| 1994s | complex and also is very very complex |
| 1997s | when you play the game so for example |
| 2000s | this is not only about getting data but |
| 2003s | there's also some functions that there's |
| 2004s | some some computation for example the |
| 2006s | blueprint explosion function that can |
| 2009s | take a a set of types and actually |
| 2013s | qualities and then compute you know what |
| 2016s | is the complete material need for for |
| 2018s | this and like |
| 2021s | um what is the excess materials that you |
| 2023s | you will have at the end end of this so |
| 2026s | give that a try it's it's it's a very |
| 2029s | fairly complex |
| 2030s | and I think in in many regards like the |
| 2034s | functions that I in the ad add in Now is |
| 2036s | really just a |
| 2038s | sort of version one oh like it's it's uh |
| 2043s | it's just the beginning of what can be |
| 2045s | done uh with with this and and hopefully |
| 2048s | you know we'll continue to add new and |
| 2050s | interesting things to it |
| 2054s | cool uh let me see I just wrote another |
| 2057s | question here |
| 2058s | um oh yeah just first to address |
| 2060s | something I mentioned this at the top of |
| 2062s | the stream earlier in the Stream but |
| 2063s | maybe it was missed but there is there |
| 2065s | is you can actually use this in Office |
| 2067s | 365 for free uh this plugin you just |
| 2070s | need to go there and make an account I |
| 2071s | Believe In the case |
| 2073s | um |
| 2073s | oh damn |
| 2075s | somebody asked if they can use this to |
| 2077s | pull solar system data and things like |
| 2078s | that I I don't believe so right because |
| 2080s | this is all bound to endpoints that you |
| 2082s | can access through the character |
| 2085s | so solar system data depends on what |
| 2088s | data we are talking about you could you |
| 2091s | could do things like um like the mining |
| 2093s | index strategic mining index yes yeah |
| 2095s | those kinds of things right I think this |
| 2096s | person was talking about like oh can I |
| 2098s | make a uh a spreadsheet to to identify |
| 2100s | kills and things like that but I |
| 2103s | I doubt that is taking into account here |
| 2105s | no no they wouldn't be so you can't you |
| 2107s | can't make an XL version of um Ezekiel |
| 2112s | um |
| 2113s | let me see there is a question though on |
| 2115s | on push capabilities from nickpaw and |
| 2118s | um you know one one of the very cool uh |
| 2121s | things is the the order stream so you |
| 2124s | can actually there there are some |
| 2126s | functions in here at least one that I |
| 2128s | know of that updates every few minutes |
| 2130s | um Based on in-game data so that's |
| 2133s | highly relevant for for Traders like me |
| 2135s | when you're monitoring |
| 2137s | um orders and prices across you so you |
| 2140s | don't have to the way I do it now is I |
| 2143s | have a in in my spreadsheets I have |
| 2146s | buttons that I click and then a hundred |
| 2148s | functions run right in the background |
| 2150s | for here this is actually one thing that |
| 2153s | um that is less less tedious now in this |
| 2157s | atom |
| 2160s | uh Ludwig Van wrecked oven says this is |
| 2162s | great for someone like me thank you |
| 2164s | thank you I'm glad I'm glad that's |
| 2165s | exactly what we want to hear |
| 2167s | um uh let me see uh seems to be Nomad |
| 2170s | Did you sort of get through everything |
| 2172s | that you wanted to show on on your |
| 2174s | sheets there or did you have some other |
| 2176s | things up your sleeve you just want to |
| 2177s | know whether or not I we should move on |
| 2178s | to what Oz was cooking or if you still |
| 2180s | want to talk about |
| 2181s | uh we we can move to us I I think it's |
| 2184s | best if people explore that example |
| 2187s | sheet themselves yep |
| 2189s | um and build their own |
| 2190s | Contraptions yeah and then share them |
| 2193s | please please do share your stuff when |
| 2195s | when you build it uh this is an |
| 2197s | inspiration for us because this whole |
| 2199s | thing started as being inspired by third |
| 2203s | party tools that that we all use and |
| 2205s | love when we when we play if |
| 2207s | so the more new stuff we see made by you |
| 2212s | guys in in the X11 will inspire us more |
| 2215s | to to add more functionalities |
| 2217s | so yeah we can move towards all right |
| 2219s | cool so what do you what are you going |
| 2221s | to be uh doing for Usos |
| 2224s | yeah so I'm going to start with a a |
| 2226s | completely blank sheet and I'm going to |
| 2228s | build some of the the backbones that I |
| 2231s | would use to start a trading spreadsheet |
| 2233s | like I have before in using using other |
| 2236s | tools and using API calls |
| 2238s | um so uh you know feel free to um uh |
| 2242s | conflict if you can keep an eye on chat |
| 2244s | and and pass the questions because I'm |
| 2246s | going to be uh basically live coding |
| 2247s | here oh sure your and your little feed |
| 2250s | here is a little bit janky let's see |
| 2252s | let's see if it clears up while using it |
| 2254s | sorry about this folks no worries is |
| 2256s | that is that better now uh no no it's um |
| 2259s | at least on mine as human stream two |
| 2261s | it's a little bit uh |
| 2262s | small a bit like no no it's not so much |
| 2265s | the matter of the zoom it looks like |
| 2268s | what am I trying to say this looks |
| 2269s | artifacting a little bit like it's uh |
| 2270s | it's being heavily compressed doesn't |
| 2272s | matter carry on we'll we'll uh |
| 2275s | so |
| 2276s | um uh first of all you know uh I'm gonna |
| 2280s | throw some shade on Nomad here but this |
| 2282s | is how you spot the professional Excel |
| 2283s | streamer I made everything black Nomad |
| 2286s | because I know people scream at me all |
| 2289s | day before having a light spreadsheets |
| 2292s | so this is for um for our basement |
| 2294s | dwelling friends |
| 2296s | um the the dark the dark spreadsheet so |
| 2300s | um everything that that I would do |
| 2303s | um starts with wallet transactions right |
| 2306s | so we we would want to |
| 2308s | um pull in the water transactions and |
| 2309s | with this add-on it's it's so super easy |
| 2312s | because all I can put in here is um I |
| 2316s | put in Eve and I see basically all of |
| 2318s | the functions that uh that I have |
| 2322s | and I can uh over here pull go to my go |
| 2327s | to my character and go to wallet |
| 2328s | transactions and if I uh put this this |
| 2332s | custom function in there uh and I |
| 2334s | actually leave everything blank then |
| 2336s | what this is going to do this is going |
| 2338s | to pull in all uh transactions uh that |
| 2342s | are relevant for the characters that |
| 2344s | I've loaded in here now this is these |
| 2346s | are um you know some of my uh this is my |
| 2348s | streaming character and two hours as you |
| 2350s | can see here |
| 2351s | um and this automatically now pulled in |
| 2353s | all of the wallet transactions for uh |
| 2356s | the last month I believe is this is is |
| 2358s | what it does without without any um |
| 2361s | without any uh additional variables in |
| 2366s | there so |
| 2367s | um this is this is great but you know as |
| 2369s | if if you're building stretch |
| 2371s | spreadsheets a lot you already can see |
| 2372s | okay what is you know what is this this |
| 2374s | only has like the item name so the |
| 2377s | reason for this is because you can use |
| 2379s | this card right here this actually has |
| 2381s | contains all of the information |
| 2385s | um yeah let me see we might have to redo |
| 2388s | the screen share just due to the fact |
| 2389s | that um because of the way I think I |
| 2391s | told you to I asked you to do this yeah |
| 2393s | people aren't getting the cards showing |
| 2395s | up in the Stream let me just confirm |
| 2396s | okay they're not seeing the drop downs |
| 2397s | and things like that uh I can share I |
| 2400s | can share one entire screen if you want |
| 2402s | me to yeah let's let's try and do that |
| 2403s | let me bring it let me bring it back in |
| 2405s | here and we'll monkey around a little |
| 2406s | bit |
| 2408s | all right we're back here you want me to |
| 2409s | stop and uh and share the entire screen |
| 2410s | yeah actually you know what chat let us |
| 2413s | just do this under the cloak of of um |
| 2416s | uh of an offset screen because it's just |
| 2418s | gonna get really ugly for a minute so |
| 2420s | don't go anywhere we'll be right back |
| 2423s | [Music] |
| 2428s | [Music] |
| 2439s | [Music] |
| 2444s | oh |
| 2446s | [Music] |
| 2458s | [Music] |
| 2477s | foreign |
| 2479s | the card comes up and then we're back in |
| 2482s | yep I think stream can see that now we |
| 2485s | should be good all right thank you for |
| 2487s | bearing with us uh twitch chat while we |
| 2489s | got that sorted out you should be able |
| 2490s | to see all the drop downs and pop-ups |
| 2492s | and stuff now please Oz carry on |
| 2495s | yeah perfect so |
| 2497s | um this uh is all the wallet |
| 2499s | transactions that I pulled in with one |
| 2501s | formula so it just took me 10 seconds |
| 2502s | right the great thing that I can do in |
| 2504s | in here now is I can pull in all the |
| 2507s | information for the transactions that I |
| 2509s | want to see right and it's it's even |
| 2511s | easier than uh um than than building the |
| 2515s | spreadsheet myself because I can now say |
| 2516s | okay give me the type which Returns the |
| 2519s | actual item right I can say give me the |
| 2523s | uh the the |
| 2526s | unit price right |
| 2529s | um |
| 2530s | if I give that the right um |
| 2533s | the right type of uh of of a formula |
| 2537s | right there or a format I can pull in |
| 2540s | the owner right so it'll return the |
| 2543s | character immediately of this |
| 2545s | transaction it I can also do something |
| 2548s | like quantity right and immediately I |
| 2551s | would have a sheet |
| 2553s | um that is you know very very useful and |
| 2557s | very customized for how I want to look |
| 2559s | at my transactions and the great thing |
| 2561s | is I can actually now pull all of this |
| 2563s | down and it will |
| 2566s | replicate down right so |
| 2569s | um this takes me literally two seconds |
| 2572s | to pull together a transaction sheet |
| 2575s | that I used to pull out of Chief assets |
| 2578s | just like this and here it's even easier |
| 2580s | to uh to customize it right so these are |
| 2583s | transactions now |
| 2585s | here's the thing that blew my mind uh |
| 2587s | the first time I used this because not |
| 2590s | only did I pull in the transactions here |
| 2592s | I uh I connected the type right so in |
| 2596s | this case the uh this looks like it's |
| 2598s | just the item but it's much more than |
| 2600s | just the item because since I can |
| 2603s | connect the type to the transaction I |
| 2605s | can now also pull in all of the |
| 2607s | information of the actual item that was |
| 2609s | in that transaction so this is a rabbit |
| 2612s | hole that that uh that is now |
| 2614s | associating different tables with each |
| 2617s | other so having done that I can pull in |
| 2619s | the average price right I can pull in |
| 2621s | stuff like the the icon I can pull in |
| 2624s | the volume of the uh the item so |
| 2628s | um this becomes just very interactive |
| 2630s | very very easy to use and again I can |
| 2633s | just you know pull this down and |
| 2635s | immediately |
| 2636s | have a sheet that is a very powerful |
| 2639s | transaction sheet now transactions is |
| 2642s | one thing that I use a lot right for for |
| 2646s | trading obviously for this what you |
| 2648s | could you know there's a myriad of |
| 2649s | things that you can do with this now |
| 2651s | this would you know this was this would |
| 2653s | totally be uh way more than we can cover |
| 2656s | today but I could now based on this I |
| 2659s | could calculate the average price I used |
| 2661s | to buy to buy the uh the item at Etc |
| 2664s | everything that I used to do but this |
| 2666s | gives me all of the raw data that I that |
| 2668s | I need to do any any type of shenanigans |
| 2670s | that I want to then do with the data the |
| 2673s | other thing Nomad alluded to earlier |
| 2676s | let me make this also a little bit |
| 2678s | bigger here |
| 2678s | [Music] |
| 2681s | you guys can actually see this so the |
| 2682s | the other thing is I can't see the |
| 2684s | sailboat is is that |
| 2686s | oh no that's that's just because I oh |
| 2688s | good I'm just making sure as if this is |
| 2692s | because you know this is something for |
| 2693s | Jacob because yeah I I I have to do it |
| 2696s | like this because Excel uh doesn't have |
| 2698s | a a dark mode you know I'm hoping every |
| 2701s | it has the dark mode for up here but it |
| 2703s | doesn't doesn't have the dark mode for |
| 2704s | down here so uh this is how I have to do |
| 2708s | the work around for it don't waste the |
| 2709s | opportunity to get your wish list in |
| 2710s | right yeah exactly I don't get to sit |
| 2713s | with Microsoft every day |
| 2715s | um taking notes here okay thank you |
| 2717s | thank you this is this is coming from an |
| 2719s | Excel streamer |
| 2721s | when you're done I have a trick that I |
| 2724s | wanna uh when when we're done uh yeah |
| 2727s | but I I'm all ears I'm all ears so uh |
| 2730s | Nomad alluded to this earlier but you |
| 2732s | know pulling in assets is also |
| 2734s | fantastically Easy Eve character assets |
| 2737s | you know I can |
| 2740s | do this and it's going to pull in every |
| 2742s | single asset that I have and yes this is |
| 2745s | the US this is a lot of assets |
| 2747s | so um again this is pulling in uh this |
| 2751s | this card so I can have a look at this |
| 2753s | card and I can look at all of the items |
| 2755s | that I can pull in here and again I can |
| 2757s | link this again to the type which will |
| 2760s | then open up a whole nother |
| 2762s | um a whole another set of |
| 2765s | um of of additional columns that I can |
| 2768s | pull into the spreadsheet but for assets |
| 2770s | um you know again let's uh let's pull in |
| 2772s | something like the the owner is very |
| 2775s | relevant because I have you know three |
| 2776s | characters here and I didn't specify the |
| 2779s | actual uh character in the formula so it |
| 2781s | pulled in the uh the assets for all of |
| 2784s | my characters I can pull in the uh the |
| 2788s | location that's important you know all |
| 2790s | my stuff is a cheetah but if I wanted to |
| 2792s | find out how much is in the Triple T |
| 2793s | that I need to evacuate or it's probably |
| 2795s | too late now then this would be an easy |
| 2797s | way to do that and again I can take this |
| 2800s | I can pull this down and there you have |
| 2804s | it again this item again is the location |
| 2807s | from the location card I can then pull |
| 2810s | in things like the region ID for Jita |
| 2813s | right and so bam I've got the region ID |
| 2816s | all this all the stuff that in the in |
| 2818s | the old times you had to pull out of the |
| 2822s | sde I I used to I have like 20 |
| 2825s | spreadsheets that just have static data |
| 2827s | that I refer to all the time right and |
| 2829s | those that's something that I can that I |
| 2832s | can now do with this super easily |
| 2834s | because I can uh very easily go in here |
| 2838s | and and pull the uh this this data right |
| 2841s | here the only reason this throws an |
| 2843s | error is because this is an enormous |
| 2844s | Freight container that obviously doesn't |
| 2846s | have |
| 2847s | a region code |
| 2849s | um yellow Hollow asks can you also do |
| 2852s | the same thing with like Corporation |
| 2853s | assets |
| 2854s | yes so um it's it's the same thing right |
| 2857s | here |
| 2859s | um instead of a character I can put in |
| 2862s | Eve I I would have to I would have to |
| 2864s | delete this other stuff so I don't |
| 2866s | confuse it but if we um if we have if we |
| 2869s | go down here we have exactly all the |
| 2871s | same formulas |
| 2873s | um for corporations so orders assets |
| 2876s | transactions wallet Journal all for |
| 2879s | corporations you can you can you can |
| 2881s | pull in so if I uh this is a holding |
| 2884s | Corp so who knows if we have Corporation |
| 2886s | assets but I'm willing to try |
| 2889s | um |
| 2889s | and I we probably I probably have to |
| 2892s | specify yeah I have to specify either a |
| 2894s | search string or or an uh or or a |
| 2897s | corporation ID but in there in theory |
| 2899s | yes |
| 2900s | it works absolutely can you do contracts |
| 2902s | as well I suppose if their contract so |
| 2903s | character was made |
| 2905s | uh I haven't tried contracts because I |
| 2907s | don't know |
| 2909s | I'm I'm the yeah no matter feel free to |
| 2911s | answer we've added contracts yesterday |
| 2914s | I believe I believe we've added I did |
| 2917s | say contrary in that version I'm not |
| 2920s | sure about the public |
| 2922s | but I think yes |
| 2924s | one one thing that I that I do want to |
| 2926s | show is somebody asked earlier in chat |
| 2928s | about |
| 2929s | um uh trading history you know Market |
| 2932s | history that's that that's the big the |
| 2934s | end point that was you know that was |
| 2936s | missing for a long time that uh that you |
| 2938s | know we were all crying about |
| 2940s | um and we can we can pull we can pull a |
| 2942s | lot of uh uh history in into here uh now |
| 2945s | this is this is just very complex you |
| 2948s | know people when when people ask and |
| 2949s | chat you know can you pull in market |
| 2951s | prices and everything |
| 2952s | a market price in Eve right is not a |
| 2957s | singular thing it's a very variable |
| 2959s | thing there are regions there are points |
| 2961s | in time there are stations there's no |
| 2963s | such thing as a price for an item |
| 2965s | because there's a reason why all Traders |
| 2968s | only look at the the percent price as we |
| 2970s | nickname it right the percent price is |
| 2973s | the top five percent of sell orders uh |
| 2976s | aggregated because the cheapest item on |
| 2978s | the market doesn't mean anything to me |
| 2980s | when I want to buy 100 billion of it |
| 2983s | right I I need to have things at scale |
| 2986s | so the way that the the add-in and you |
| 2989s | know Nomad and yeah I hope you guys have |
| 2991s | to jump in because I'm I'm talking about |
| 2993s | your your product here but |
| 2995s | um the the market history is something |
| 2997s | that um that it's done differently but I |
| 3000s | want to show it because I know a lot of |
| 3002s | people are curious about it so if we |
| 3004s | pull the market history in here then |
| 3007s | um I can I have to specify here a a |
| 3011s | region and an and a type ID otherwise |
| 3013s | this would be way too big right |
| 3016s | um and of course this being me I I know |
| 3019s | this by heart but I don't blame you if |
| 3020s | you don't know the the forge region |
| 3022s | close my heart right and uh and let's go |
| 3025s | with titanium 34 as everyone knows |
| 3028s | um and we can uh |
| 3031s | that was uh this is this is the the |
| 3034s | German way to write the formula there |
| 3036s | you go and |
| 3038s | um so immediately |
| 3040s | um I have pulled in with these two |
| 3042s | variables that I know by heart but which |
| 3044s | was this you you can very easily pull it |
| 3046s | in with with other information uh as |
| 3049s | well I have pulled in the market history |
| 3051s | for tritanium in the Forge right so |
| 3056s | um |
| 3057s | what I can do here now is I can look at |
| 3059s | the history and I think this this helps |
| 3061s | a lot if I look at the card information |
| 3063s | now for the market history then we see |
| 3067s | here that the in this case the history |
| 3069s | is not linear but the history shows the |
| 3072s | average pricing over time with high low |
| 3075s | so everything that you can get from the |
| 3079s | um the the market history endpoint as |
| 3081s | well you can you can get here it's just |
| 3084s | um a little bit more difficult to to |
| 3086s | display it so if we were to pull in the |
| 3089s | entire Market history right now you see |
| 3090s | what happens here this now pulls in a |
| 3093s | card for the market history for uh for |
| 3096s | every single day of the last I I don't |
| 3099s | know month or so no it's much longer |
| 3101s | than that right |
| 3102s | so um |
| 3104s | from here I can then again drill down |
| 3107s | and get the highest price uh get the the |
| 3110s | the lowest price for example uh and what |
| 3113s | this now does is this shows me a nice |
| 3116s | little table of the high and low price |
| 3118s | of titanium in the Forge over the last |
| 3123s | um you know X time period And so this is |
| 3127s | um |
| 3128s | the data is all there it's easy to pull |
| 3131s | in what you do from it is going to be |
| 3134s | amazing to see over the next few weeks |
| 3136s | right people like like like me uh and |
| 3140s | and a thousand others that do this even |
| 3142s | better than me are going to jump on this |
| 3144s | uh create great templates and I think |
| 3146s | the real power in this is going to be |
| 3148s | when we all exchange our templates |
| 3151s | um you know or or sit on them like |
| 3153s | goblins and use them for profit |
| 3158s | amazing stuff |
| 3160s | because does that conclude what you |
| 3162s | wanted to show on the screen there yeah |
| 3164s | sure the um maybe one one absolute last |
| 3167s | thing would be yeah I don't think |
| 3169s | anyone's gonna have any problem watching |
| 3170s | more of this okay so you know I mean you |
| 3173s | you cut me off it's it's as as usual you |
| 3175s | kind of like you just cut me off yeah |
| 3178s | uh so um Market orders is another big |
| 3181s | thing for Traders right if you want to |
| 3183s | see your orders so you can pull in |
| 3186s | character |
| 3187s | um orders right here also the history so |
| 3190s | expired orders or um |
| 3192s | um or canceled orders but the |
| 3194s | interesting thing is just orders and now |
| 3197s | I can put in a character id here of the |
| 3199s | RS but I can also just leave it blank |
| 3202s | and it pulls in just like it did before |
| 3204s | it pulls in all the orders for all the |
| 3206s | characters now you can see that this |
| 3208s | account isn't extremely active right now |
| 3211s | um but these are the orders that this |
| 3213s | account right here has has going uh at |
| 3216s | the at the moment again this is a card |
| 3219s | so one order means one card what I can |
| 3223s | do here is I can look at the card again |
| 3225s | and see all the informations about that |
| 3227s | order but the magic of excel comes to |
| 3230s | life when I actually say well I need to |
| 3233s | know again what type is this so what's |
| 3235s | what's the actual item I would like to |
| 3237s | know uh what the the price is that I |
| 3242s | actually have on this order I also need |
| 3245s | to know the volume remaining that's very |
| 3248s | interesting right the total volume isn't |
| 3250s | as interesting as the volume remaining |
| 3251s | and I would like to know this little |
| 3254s | field which I appreciate this was |
| 3256s | probably |
| 3258s | a challenge on how to display this but |
| 3261s | there is buy order is an elegant way of |
| 3264s | saying is this a buy order or a sell |
| 3266s | order |
| 3267s | um and so this way we draw this down and |
| 3271s | you can see here it says false false |
| 3272s | false that just means |
| 3274s | um these are all sell orders so that's |
| 3277s | that's all that means |
| 3278s | and if you you know if you use this as a |
| 3281s | raw data and you you build stuff on top |
| 3283s | of this probably you just rename it for |
| 3285s | your own uh for your own spreadsheets |
| 3286s | and so you can see here that I have you |
| 3289s | know these items for this price at this |
| 3292s | remaining quantity |
| 3293s | um and they're all sell orders and then |
| 3295s | I can start uh uh I can you know by |
| 3299s | freehand uh improvise uh formulas right |
| 3303s | so I can go in here and I say okay price |
| 3306s | times quantity is the total value of |
| 3308s | this order right we we we put this down |
| 3311s | uh you know put a nice little uh sum on |
| 3315s | top of this and boom I've got uh 31 |
| 3318s | billion sell orders outstanding right |
| 3320s | now right I also need to know where they |
| 3323s | are now you guys know me these are going |
| 3325s | to be all in Gita but for everyone else |
| 3327s | this is not going to be the case oh look |
| 3329s | oh a couple oh oh you better get on |
| 3332s | to it |
| 3334s | yeah um so uh |
| 3337s | this is uh this is asset safety |
| 3341s | so I feel compelled to be the professor |
| 3345s | here and just teach you a little trick |
| 3347s | or your demo is fantastic and you're |
| 3349s | really showing the capabilities of the |
| 3351s | whole thing but there's one thing I want |
| 3353s | to show you because you're doing this |
| 3354s | copy down which is very common for Excel |
| 3357s | users yeah that you want to do that but |
| 3359s | how about you just uh Delete all of the |
| 3362s | things that you copied down except for |
| 3364s | the first line where you have the |
| 3366s | formulas yes there good and then you go |
| 3368s | to each of the formulas |
| 3371s | uh so uh what you have there and it says |
| 3374s | what does it say a A6 dot something and |
| 3379s | then just after A6 you put in a part |
| 3381s | sign pound sign |
| 3384s | yeah okay hash right hash yeah yeah |
| 3389s | um and you just hit enter on that |
| 3393s | uh you can do that on the other phones |
| 3395s | as well the the the the the the neat |
| 3398s | thing about this is that if the list in |
| 3401s | column A changes in the length like |
| 3404s | there's more orders are coming in or |
| 3407s | fewer and so on that will actually |
| 3409s | dynamically update and this is a feature |
| 3412s | of dynamic arrays in uh |
| 3414s | I hope that I know that there's Excel |
| 3417s | Engineers on this uh listening to this |
| 3419s | twitch and if they haven't left and |
| 3422s | started coding up why Excel is not |
| 3424s | inserting that uh or you know |
| 3427s | automatically but let's see maybe we'll |
| 3430s | do that someday coming today was already |
| 3434s | worth it now this is already this is |
| 3436s | already the best day of the week by the |
| 3437s | way you can you can do the same in |
| 3439s | column F where you have multiplication |
| 3441s | oh yeah yeah I just I just have to do uh |
| 3445s | right there yeah just delete yeah delete |
| 3449s | that part and just do the first row the |
| 3452s | first cell with pound signs in both |
| 3456s | like that |
| 3458s | no D6 hash right multiplied by whatever |
| 3464s | that is C6 hash yes |
| 3467s | perfect and put the hash here yep yes |
| 3471s | look at that I I get to learn something |
| 3474s | yeah so um you I I think you guys can |
| 3477s | see that this this is |
| 3479s | when you get started in this it's a it's |
| 3481s | a it's a rabbit hole because you can you |
| 3484s | can build this out to whatever you want |
| 3486s | it to be and this is really just um uh |
| 3490s | just me playing around in 10 15 minutes |
| 3492s | and uh you know as I said earlier this |
| 3494s | this is uh I can't wait to see what you |
| 3496s | guys you guys do with it |
| 3499s | back to you coming all right |
| 3502s | um we're sort of getting to where we'll |
| 3504s | probably wrap this Upstream there's been |
| 3505s | so many questions in twitch chat while |
| 3507s | you're talking like can I do this |
| 3509s | specific thing can you look up this |
| 3510s | specific thing what about this what |
| 3511s | about that uh afraid we can't answer and |
| 3514s | go through all those things in my new |
| 3516s | detail tonight friends but you can just |
| 3518s | grab it yourself like uh uh office |
| 3520s | online with the plugin is free you can |
| 3523s | start playing around with it and you can |
| 3524s | you can try your hand at all these kinds |
| 3526s | of things here and uh pinned to the top |
| 3529s | of twitch chat the link to today's news |
| 3530s | item which I believe contains like uh |
| 3533s | links to a template for people to start |
| 3535s | the one that you were moving around |
| 3536s | before CCP Nomad is that correct |
| 3540s | I'm sorry I didn't get that that's okay |
| 3542s | uh the the template the the demo sheet |
| 3545s | that you were playing with uh before |
| 3547s | that's included in the news item yes it |
| 3549s | is in the news item and also in The Help |
| 3551s | Center article all right so it's it's a |
| 3554s | Brave New World for uh spreadsheet |
| 3557s | enthusiasts and Eve online uh someone |
| 3559s | made the the comment before that there |
| 3561s | was a |
| 3562s | uh you know like is this the most people |
| 3564s | who've ever watched an Excel stream I'm |
| 3565s | gonna say no because there is like an |
| 3567s | Excel esport isn't there yeah |
| 3575s | Esports but I want to say that I think |
| 3578s | that the the people at Microsoft working |
| 3581s | on this project has really been |
| 3582s | surprised about how much interest there |
| 3585s | has been in this add-in from when we |
| 3587s | first launched it at Fan Fest till now |
| 3590s | so that's that's super super exciting |
| 3593s | no it's it's excellent and like like |
| 3595s | we've said multiple times on the stream |
| 3597s | already we really can't wait to see uh |
| 3599s | what you do with these now that you've |
| 3600s | got it into your own hands because it |
| 3601s | won't necessarily be people Nest all |
| 3603s | that for themselves trying to get a leg |
| 3605s | up either you'll have these wonderful uh |
| 3607s | philanthropists like Oz here who are |
| 3609s | sort of I'm sure you keep some of the |
| 3611s | really good stuff for himself but it's |
| 3612s | usually very very forthcoming with lucky |
| 3614s | sources and his methods and uh likes to |
| 3617s | really educate other people about how to |
| 3618s | take advantage of um of uh Commodities |
| 3620s | markets in new Eden so I'm expecting a |
| 3622s | lot of people to be creating |
| 3624s | um uh templates for this with the |
| 3626s | express purpose of sharing it with other |
| 3628s | people too so even even if with the |
| 3630s | access to the plugin you're still not |
| 3632s | the most confident with the designing |
| 3633s | spreadsheets |
| 3635s | um uh you'll still be able to get your |
| 3636s | hands on some really good stuff for the |
| 3637s | result of this because as we mentioned |
| 3639s | before as we've seen with third-party |
| 3641s | developers uh e-online players are |
| 3643s | incredibly generous with their time and |
| 3644s | their work so these things will make it |
| 3646s | into your hands |
| 3647s | um but I know ironically |
| 3649s | um since Microsoft Excel is pretty much |
| 3651s | its own esport and because we haven't |
| 3653s | Alliance tournament wouldn't it be neat |
| 3655s | if we had some sort of uh XL PVP |
| 3658s | tournament uh in Eve online maybe that's |
| 3660s | something we'll start workshopping |
| 3661s | tomorrow in the community team and see |
| 3663s | if there's any possibility we can figure |
| 3665s | out what we can do with that before Fan |
| 3667s | Fest because of where's a lot of work |
| 3668s | leading up to that in September |
| 3670s | but we'll see |
| 3672s | um but that that's enough for us for |
| 3674s | tonight the longer we talk the less time |
| 3676s | you can get uh the longer it'll be |
| 3677s | before you can um sit down and start |
| 3679s | playing with yourself in Earnest so uh |
| 3681s | check out the news item that's linked at |
| 3683s | the top of twitch chat or just go to the |
| 3684s | Eve online website and look at the news |
| 3685s | and you can you can down you can read |
| 3687s | the news item from today which has all |
| 3689s | the information that you need to get |
| 3690s | your hands on this and get up and |
| 3691s | running |
| 3692s | um CCP Nomads sorry I want CCP apart |
| 3695s | from industry Nomad Oz and Jacob thank |
| 3698s | you so much for giving us some of your |
| 3700s | time to talk about this tonight it's a |
| 3702s | lot later than our usual streams outside |
| 3704s | business hours but |
| 3706s | um uh so that just makes it extra cool |
| 3708s | that you made the effort to come out |
| 3709s | here |
| 3710s | um before we sort of step out is there |
| 3712s | anything that anyone wanted just to say |
| 3714s | with regards to Excel or anything else |
| 3721s | all right Oz are you doing stream this |
| 3723s | weekend |
| 3726s | I am do I take a minute to plug yourself |
| 3729s | uh sure I I you know most most of you |
| 3732s | have seen me probably on on here my my |
| 3734s | Show's always uh Saturdays at um at |
| 3737s | around 8 PM UTC |
| 3739s | um 10 p.m uh Central European Time uh |
| 3743s | this this I I mean uh convict you have |
| 3746s | to tell me if I have a CCP guest this |
| 3747s | week this weekend but uh oh yeah you |
| 3750s | know yeah we're we're hoping to we're |
| 3752s | hoping to have a CCP guess this weekend |
| 3754s | again |
| 3755s | um and uh probably we'll see I've been |
| 3757s | kind of sandbagging you there because |
| 3759s | I've just been trying to get this out of |
| 3760s | the way first but we'll see |
| 3762s | um but it's looking it's it's it's it's |
| 3764s | it's looking quite good but either way I |
| 3766s | do a a a a show where we do market |
| 3768s | trading and a lot of spreadsheeting uh |
| 3771s | and so if you want to learn about this |
| 3772s | this sort of stuff |
| 3774s | um the spreadsheets and making a lot of |
| 3775s | a ton of isk in in Eve online then tune |
| 3778s | in uh it's a twitch dot TV slash |
| 3781s | underscore Eve right on uh but on BET on |
| 3785s | your nine sorry I wasn't able to do any |
| 3787s | uh oh sorry button uni Inc I wasn't able |
| 3790s | to do any skin Raffles today because I |
| 3792s | was too busy mashing buttons there was a |
| 3793s | lot of moving parts of the stream on the |
| 3794s | back end which you might have been able |
| 3796s | to tell you it's like higher than normal |
| 3798s | jankiness than my higher than usual |
| 3799s | flusteredness well I've been speaking |
| 3801s | tonight uh but it's all sort of worked |
| 3803s | out but don't worry you got your channel |
| 3804s | points you'll be able to claim when |
| 3805s | there's going out skin soon and you'll |
| 3806s | be able to come tune in on Friday when |
| 3808s | we do lift to feed uh we'll definitely |
| 3810s | do some Raffles for that one but we'll |
| 3812s | we'll finish it up there thank you so |
| 3814s | much for coming and watching everyone |
| 3815s | we'll send you off on a little raid |
| 3816s | thanks again to all of our guests and |
| 3818s | we'll see you again on Friday for Lift |
| 3819s | to feed at uh 1500 UTC yeah |
| 3823s | bye |