Data Types in Space: A New Data Types Experience

Published May 06 2022 09:00 AM 5,135 Views
Microsoft

Last November, we announced the availability of a new JavaScript API in Excel. This new API allows developers to create their own custom data types containing images, entities, arrays, and formatted number values – backed by their own custom data sources, in addition to allowing for the creation of custom functions which can make use of these new Excel Data Types, both as inputs and outputs. 

We were excited for the possibilities and the unique solutions that would be created using this new API.

 

Today, we’re even more excited to share with you some of the work CCP Games has been doing using the API, to bring their data right to your fingertips as Excel data types.

 

CCP Games, a Pearl Abyss company since 2019, was founded in 1997 in Reykjavik, Iceland. With the launch of EVE Online in May 2003, CCP Games established itself as one of the most innovative companies in interactive entertainment, winning numerous awards and receiving critical acclaim worldwide.

 

Eve Online is a space-based, persistent world massively multiplayer online role-playing game (MMORPG), wherein players can participate in a number of in-game professions and activities, including mining, piracy, manufacturing, trading, exploration, and combat.  The game is renowned for its scale and complexity with regards to player interactions – in its single, shared game world, players engage in unscripted economic competition, warfare, and political schemes with other players.  

 

EVE Online players frequently use Excel to work with in-game data to model and calculate everything from trading profit margins to battle strategy.  It has even been fondly nicknamed “Spreadsheets in Space.”  Now, by utilizing the new JavaScript API in Excel, CCP Games hopes to make this in-game data even easier for players to access, work with, and quickly refresh.

 

Here are some examples of the kinds of new Data Types we have been thinking about making available within the Eve Online add-in:

Data Type

Example

Ships – Ships are instrumental in the Eve Online universe.  They can be used to travel, ferry materials and of course battle your opponents.

Chris_Gross_0-1651786192480.png

Materials – Materials are the backbone of any universe and Eve Online is no different. These data types contain pricing and other information to aid in market and building decision making.

Chris_Gross_1-1651786192487.png

Blueprints – Blueprints and materials are like bread and butter. These two things in concert allow players to create items in the universe. Plan out your resource gathering requirements for your next move

Chris_Gross_2-1651786192496.png

Star Systems – Eve Online has a vast array of Star Systems to explore in the universe. These data types aid in decision making on how to manipulate these systems best to the players advantage.

Chris_Gross_3-1651786192504.png

 

 

Eve Online Item Search

Custom Functions are also being thought about. In this example, it’s possible to easily get at the data players are looking for. This function searches the vast array of in-game items to return results quickly and efficiently.

EveOnlineSearch.gif

 

This is just a glimpse of the vast set of data that makes up the Eve Online universe.

The hope is that with this add-in CCP Games can

  • Allow open and easy access for curious minds
  • Support small and mid-size player corporations with organizing activities that don’t have access to infrastructure
  • Facilitate advanced and hardcore gameplay and optimization strategies

We look forward to seeing this work evolve over the course of the project!

 

Learn More

 

You can learn more about CCP Games’ partnership with the Excel team at link coming soon, and we’re thrilled to be featured at EVE Fanfest 2022, May 6-7 in Reykjavik, Iceland. 

To learn more about the data types JavaScript API in Excel, you can check out these resources:

  

Do you have an idea to make Excel better? We'd love to hear about it. Go to the Excel forum in Microsoft Feedback to submit your idea or vote for other ideas. You can also click the Feedback button in Excel and choose "I have a suggestion".

 

%3CLINGO-SUB%20id%3D%22lingo-sub-3328453%22%20slang%3D%22en-US%22%3EData%20Types%20in%20Space%3A%20A%20New%20Data%20Types%20Experience%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3328453%22%20slang%3D%22en-US%22%3E%3CP%3ELast%20November%2C%20we%20announced%20the%20availability%20of%20a%26nbsp%3B%3CA%20href%3D%22http%3A%2F%2Faka.ms%2FExcelDataTypesAPI%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Enew%20JavaScript%20API%20in%20Excel%3C%2FA%3E.%20This%20new%20API%20allows%20developers%20to%20create%20their%20own%20custom%20data%20types%26nbsp%3Bcontaining%26nbsp%3Bimages%2C%20entities%2C%26nbsp%3Barrays%2C%20and%26nbsp%3Bformatted%20number%20values%26nbsp%3B%E2%80%93%20backed%26nbsp%3Bby%20their%20own%20custom%20data%20sources%2C%20in%20addition%20to%20allowing%20for%20the%20creation%20of%20custom%20functions%20which%20can%20make%20use%20of%20these%20new%20Excel%20Data%20Types%2C%20both%20as%20inputs%20and%20outputs.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20were%20excited%20for%20the%20possibilities%20and%20the%20unique%20solutions%20that%20would%20be%20created%20using%20this%20new%20API.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EToday%2C%20we%E2%80%99re%20even%20more%20excited%20to%20share%20with%20you%20some%20of%20the%20work%20CCP%20Games%20has%20been%20doing%20using%20the%20API%2C%20to%20bring%20their%20data%20right%20to%20your%20fingertips%20as%20Excel%20data%20types.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECCP%20Games%2C%20a%20Pearl%20Abyss%20company%20since%202019%2C%20was%20founded%20in%201997%20in%20Reykjavik%2C%20Iceland.%20With%20the%20launch%20of%20%3CA%20href%3D%22https%3A%2F%2Fwww.eveonline.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EEVE%20Online%3C%2FA%3E%20in%20May%202003%2C%20CCP%20Games%20established%20itself%20as%20one%20of%20the%20most%20innovative%20companies%20in%20interactive%20entertainment%2C%20winning%20numerous%20awards%20and%20receiving%20critical%20acclaim%20worldwide.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEve%20Online%20is%20a%20space-based%2C%20persistent%20world%20massively%20multiplayer%20online%20role-playing%20game%20(MMORPG)%2C%20wherein%20players%20can%20participate%20in%20a%20number%20of%20in-game%20professions%20and%20activities%2C%20including%20mining%2C%20piracy%2C%20manufacturing%2C%20trading%2C%20exploration%2C%20and%20combat.%26nbsp%3B%20The%20game%20is%20renowned%20for%20its%20scale%20and%20complexity%20with%20regards%20to%20player%20interactions%20%E2%80%93%20in%20its%20single%2C%20shared%20game%20world%2C%20players%20engage%20in%20unscripted%20economic%20competition%2C%20warfare%2C%20and%20political%20schemes%20with%20other%20players.%20%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.eveonline.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EEVE%20Online%3C%2FA%3E%20players%20frequently%20use%20Excel%20to%20work%20with%20in-game%20data%20to%20model%20and%20calculate%20everything%20from%20trading%20profit%20margins%20to%20battle%20strategy.%26nbsp%3B%20It%20has%20even%20been%20fondly%20nicknamed%20%E2%80%9CSpreadsheets%20in%20Space.%E2%80%9D%26nbsp%3B%20Now%2C%20by%20utilizing%20the%20new%20JavaScript%20API%20in%20Excel%2C%20CCP%20Games%20hopes%20to%20make%20this%20in-game%20data%20even%20easier%20for%20players%20to%20access%2C%20work%20with%2C%20and%20quickly%20refresh.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHere%20are%20some%20examples%20of%20the%20kinds%20of%20new%20Data%20Types%20we%20have%20been%20thinking%20about%20making%20available%20within%20the%20Eve%20Online%20add-in%3A%3C%2FP%3E%0A%3CTABLE%20style%3D%22width%3A%201000px%3B%22%3E%0A%3CTBODY%3E%0A%3CTR%3E%0A%3CTD%20width%3D%22312%22%3E%3CP%3E%3CSTRONG%3EData%20Type%3C%2FSTRONG%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20width%3D%22312%22%3E%3CP%3E%3CSTRONG%3EExample%3C%2FSTRONG%3E%3C%2FP%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20width%3D%22312%22%3E%3CP%3E%3CSTRONG%3EShips%3C%2FSTRONG%3E%20%E2%80%93%20Ships%20are%20instrumental%20in%20the%20Eve%20Online%20universe.%20%26nbsp%3BThey%20can%20be%20used%20to%20travel%2C%20ferry%20materials%20and%20of%20course%20battle%20your%20opponents.%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20style%3D%22%20text-align%3A%20center%3B%20%22%3E%3CPRE%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Chris_Gross_0-1651786192480.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369595i227BC5B0D4671C09%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Chris_Gross_0-1651786192480.png%22%20alt%3D%22Chris_Gross_0-1651786192480.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20width%3D%22312%22%3E%3CP%3E%3CSTRONG%3EMaterials%3C%2FSTRONG%3E%20%E2%80%93%20Materials%20are%20the%20backbone%20of%20any%20universe%20and%20Eve%20Online%20is%20no%20different.%20These%20data%20types%20contain%20pricing%20and%20other%20information%20to%20aid%20in%20market%20and%20building%20decision%20making.%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20style%3D%22%20text-align%3A%20center%3B%20%22%3E%3CPRE%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Chris_Gross_1-1651786192487.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369594iDC83893EC8003488%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Chris_Gross_1-1651786192487.png%22%20alt%3D%22Chris_Gross_1-1651786192487.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20width%3D%22312%22%3E%3CP%3E%3CSTRONG%3EBlueprints%3C%2FSTRONG%3E%20%E2%80%93%20Blueprints%20and%20materials%20are%20like%20bread%20and%20butter.%20These%20two%20things%20in%20concert%20allow%20players%20to%20create%20items%20in%20the%20universe.%20Plan%20out%20your%20resource%20gathering%20requirements%20for%20your%20next%20move%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20style%3D%22%20text-align%3A%20center%3B%20%22%3E%3CPRE%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Chris_Gross_2-1651786192496.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369596i70AF19BD55145532%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Chris_Gross_2-1651786192496.png%22%20alt%3D%22Chris_Gross_2-1651786192496.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%3E%0A%3CTD%20width%3D%22312%22%3E%3CP%3E%3CSTRONG%3EStar%20Systems%3C%2FSTRONG%3E%20%E2%80%93%20Eve%20Online%20has%20a%20vast%20array%20of%20Star%20Systems%20to%20explore%20in%20the%20universe.%20These%20data%20types%20aid%20in%20decision%20making%20on%20how%20to%20manipulate%20these%20systems%20best%20to%20the%20players%20advantage.%3C%2FP%3E%0A%3C%2FTD%3E%0A%3CTD%20style%3D%22%20text-align%3A%20center%3B%20%22%3E%3CPRE%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Chris_Gross_3-1651786192504.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369597i044011AF4218FEDF%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Chris_Gross_3-1651786192504.png%22%20alt%3D%22Chris_Gross_3-1651786192504.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3C%2FTBODY%3E%0A%3C%2FTABLE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EEve%20Online%20Item%20Search%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3ECustom%20Functions%20are%20also%20being%20thought%20about.%20In%20this%20example%2C%20it%E2%80%99s%20possible%20to%20easily%20get%20at%20the%20data%20players%20are%20looking%20for.%20This%20function%20searches%20the%20vast%20array%20of%20in-game%20items%20to%20return%20results%20quickly%20and%20efficiently.%3C%2FP%3E%0A%3CPRE%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22EveOnlineSearch.gif%22%20style%3D%22width%3A%20915px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369601i93BF108517E66102%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22EveOnlineSearch.gif%22%20alt%3D%22EveOnlineSearch.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20is%20just%20a%20glimpse%20of%20the%20vast%20set%20of%20data%20that%20makes%20up%20the%20Eve%20Online%20universe.%3C%2FP%3E%0A%3CP%3EThe%20hope%20is%20that%20with%20this%20add-in%20CCP%20Games%20can%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EAllow%20open%20and%20easy%20access%20for%20curious%20minds%3C%2FLI%3E%0A%3CLI%3ESupport%20small%20and%20mid-size%20player%20corporations%20with%20organizing%20activities%20that%20don%E2%80%99t%20have%20access%20to%20infrastructure%3C%2FLI%3E%0A%3CLI%3EFacilitate%20advanced%20and%20hardcore%20gameplay%20and%20optimization%20strategies%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EWe%20look%20forward%20to%20seeing%20this%20work%20evolve%20over%20the%20course%20of%20the%20project!%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ELearn%20More%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EYou%20can%20learn%20more%20about%20CCP%20Games%E2%80%99%20partnership%20with%20the%20Excel%20team%20at%26nbsp%3B%3CEM%3Elink%20coming%20soon%3C%2FEM%3E%2C%20and%20we%E2%80%99re%20thrilled%20to%20be%20featured%20at%20%3CA%20href%3D%22https%3A%2F%2Fwww.eveonline.com%2Ffanfest%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EEVE%20Fanfest%202022%3C%2FA%3E%2C%20May%206-7%20in%20Reykjavik%2C%20Iceland.%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20learn%20more%20about%20the%20data%20types%20JavaScript%20API%20in%20Excel%2C%20you%20can%20check%20out%20these%20resources%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdevblogs.microsoft.com%2Fmicrosoft365dev%2Fignite-2021-excel-add-ins-and-data-types%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EM365%20Dev%20Blog%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fmyignite.microsoft.com%2Fsessions%2F031cb167-ad63-4a1d-b6f5-88ae9900584d%3Fsource%3Dsessions%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EOffice%3A%20The%20universal%20interactive%20canvas%20for%20all%20creators%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fvideo-hub%2Fexcel-add-ins-and-data-types%2Fba-p%2F2909835%22%20target%3D%22_blank%22%3EIgnite%20skilling%20session%20for%20some%20demos%20and%20a%20deeper%20dive%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fdev%2Fadd-ins%2Fexcel%2Fexcel-data-types-overview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ETechnical%20documentation%20for%20developer%20specifics%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EDo%20you%20have%20an%20idea%20to%20make%20Excel%20better%3F%20We'd%20love%20to%20hear%20about%20it.%20Go%20to%20the%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ffeedbackportal.microsoft.com%2Ffeedback%2Fforum%2Fc23f3b77-f01b-ec11-b6e7-0022481f8472%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EExcel%20forum%20in%20Microsoft%20Feedback%3C%2FA%3E%3CSPAN%3E%26nbsp%3Bto%20submit%20your%20idea%20or%20vote%20for%20other%20ideas.%20You%20can%20also%20click%20the%20Feedback%20button%20in%20Excel%20and%20choose%20%22I%20have%20a%20suggestion%22.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-3328453%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22EveOnlineSearchBlog.gif%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369625iEECAE10008A5ECD1%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22EveOnlineSearchBlog.gif%22%20alt%3D%22EveOnlineSearchBlog.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EToday%2C%20we%E2%80%99re%20even%20more%20excited%20to%20share%20with%20you%20some%20of%20the%20work%20CCP%20Games%20has%20been%20doing%20using%20the%20Data%20Types%20API%2C%20to%20bring%20their%20data%20right%20to%20your%20fingertips%20as%20Excel%20data%20types.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3328453%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAPI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EBlog%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20Types%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EEve%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎May 16 2022 03:57 PM
Updated by: