Microsoft data streamer for excel что это
Stream and analyze live data from your Arduino microcontroller into Excel with the Data Streamer add-in!
- 137,947 views
- 21 comments
- 77 respects
Components and supplies
Apps and online services
About this project
Microsoft Excel is a helpful tool to visualize and analyze data. The Data Streamer add-in allows you to import, view, and analyze live data from external devices like your Arduino microcontroller. This makes gathering data from sensors accessible, affordable, and user-friendly for a wide variety of applications.
Data Streamer, free w/ O365, reads values printed to your computer's serial port, which is the same method data is printed to the Arduino IDE Serial Monitor.
For this tutorial, you'll need to have Microsoft Excel O365 with Data Streamer enabled. For instructions on how to do this, visit the Data Streamer website .
Let's get started!
1. Connect your sensor to the Arduino microcontroller.
Use your own sensor or follow one of our tutorials. Here are some examples: Electroconductivity Sensor , Pressure Sensor , Electromagnetic Sensor .
2. Write and flash a sketch that reads in the sensor and prints the value to the Serial Monitor with a new line at the end.
Write your own or use the sample code in the attachments section.
Note: if you use the sample code, be sure to connect your sensor to Arduino Analog Pin A0.
3. Open Excel and navigate to the Data Streamer tab. Click Connect a Device to connect Excel to the microcontroller.
This will create 3 new sheets:
- Data In: Live data is printed on this sheet.
- Data Out: Send data and/or commands to the Arduino board using this sheet.
- Settings: Change basic settings for Data Streamer, including the amount of live data and number of data columns.
4. Click Start Data to begin streaming data into Excel.
By default we only get 15 rows of data, but you can gather up to 500 rows of live data (limit is due to Excel bandwidth -- there's a lot happening in the background!).
5. To save data into a text (.CSV) file, click the Record Data button.
When you click Stop Record, you will be prompted to select a file name and location.
6. Add a Plot of your data! Do some data analysis!
Scatter plots show you how the sensor readings change over time. Add a Scatter Plot by going to Insert -> Charts -> Scatter.
When the plot pops up, right click on the empty chart and choose "Select Data," then Add a Series.
Add a title to your data series. Next, you'll want to display your data on the y-axis, with "time"* on the x-axis. To do this, click the arrow under the "Series Y-Values."
Go to the Data In sheet, and select all of the incoming sensor data.
Now you have a plot of your live data! This makes it much easier to visualize and understand changes in the sensor readings.
Youcan also do calculations and comparisons in Excel! To write a formula, click on an empty cell and type an equals sign (" ,");
Serial.print(sensorReading2);
Serial.print(",");
Serial.println();
That's it! Go forth and measure all the things!
Use this as a foundation to start exploring sensors, Arduino coding, and data analysis to tackle your questions, curiosities, and fav mysteries in this big, beautiful world.
Visit the Data Streamer website for instructions for simple sensor projects, or check out the Microsoft Hacking STEM website for more project ideas and full curriculum!
And of course, please leave a comment if you have any questions or need any assistance!
Arduino Analog Sensor Sample CodeArduino
Use this code to read an analog sensor from Arduino analog pin 0 and print to the serial port (Data Streamer). This sample code can be modified for more and different types of sensors as well as to get data from Excel and send commands to the Arduino microcontroller.
Модернизируйте аудитории с помощью данных в режиме реального времени, чтобы преобразовать способ моделирования учащимися современных научных или технических занятий.
Хотите измерить скорость ветра с помощью анемометра? Смоделировать воздействия при столкновении мозга с черепом? Определить электропроводность раствора? Надстройка Data Streamer для Excel поддерживает сбор, визуализацию и анализ данных датчиков в режиме реального времени в Excel.
Data Streamer предоставляет учащимся простой способ перемещения данных между физическим миром и эффективным цифровым решением Excel. С помощью датчика, микроконтроллера и приложения Excel надстройка Data Streamer знакомит учащихся с миром обработки и анализа данных, а также Интернетом вещей.
Примечание: Data Streamer предоставляется бесплатно всем подписчикам Microsoft 365. Если вы являетесь подписчиком Microsoft 365, убедитесь, что у вас установлена последняя версия Office
Принцип действия
Data Streamer — это средство двусторонней передачи данных для Excel, выполняющее потоковую передачу данных в режиме реального времени из микроконтроллера в Excel, а также отправляющее данные из Excel обратно в микроконтроллер.
Чтобы получать данные с датчика в книге Excel, соедините датчик с микроконтроллером, подключенным к компьютеру с Windows 10. Также нужно включить надстройку Data Streamer для Excel и открыть книгу.
Выполните указанные ниже действия, чтобы запустить потоковую передачу данных в Excel в режиме реального времени.
Параметры Data Streamer
Книги надстройки Data Streamer можно настраивать в соответствии со своими требованиями. Чтобы изменить способ отображения данных и другие параметры пользовательского интерфейса, используйте указанные ниже ссылки.
Дополнительные сведения
Вы всегда можете задать вопрос специалисту Excel Tech Community, попросить помощи в сообществе Answers community, а также предложить новую функцию или улучшение на веб-сайте Excel User Voice.
Stream and analyze live data from your Arduino microcontroller into Excel with the Data Streamer add-in!
- 137,947 views
- 21 comments
- 77 respects
Components and supplies
Apps and online services
About this project
Microsoft Excel is a helpful tool to visualize and analyze data. The Data Streamer add-in allows you to import, view, and analyze live data from external devices like your Arduino microcontroller. This makes gathering data from sensors accessible, affordable, and user-friendly for a wide variety of applications.
Data Streamer, free w/ O365, reads values printed to your computer's serial port, which is the same method data is printed to the Arduino IDE Serial Monitor.
For this tutorial, you'll need to have Microsoft Excel O365 with Data Streamer enabled. For instructions on how to do this, visit the Data Streamer website .
Let's get started!
1. Connect your sensor to the Arduino microcontroller.
Use your own sensor or follow one of our tutorials. Here are some examples: Electroconductivity Sensor , Pressure Sensor , Electromagnetic Sensor .
2. Write and flash a sketch that reads in the sensor and prints the value to the Serial Monitor with a new line at the end.
Write your own or use the sample code in the attachments section.
Note: if you use the sample code, be sure to connect your sensor to Arduino Analog Pin A0.
3. Open Excel and navigate to the Data Streamer tab. Click Connect a Device to connect Excel to the microcontroller.
This will create 3 new sheets:
- Data In: Live data is printed on this sheet.
- Data Out: Send data and/or commands to the Arduino board using this sheet.
- Settings: Change basic settings for Data Streamer, including the amount of live data and number of data columns.
4. Click Start Data to begin streaming data into Excel.
By default we only get 15 rows of data, but you can gather up to 500 rows of live data (limit is due to Excel bandwidth -- there's a lot happening in the background!).
5. To save data into a text (.CSV) file, click the Record Data button.
When you click Stop Record, you will be prompted to select a file name and location.
6. Add a Plot of your data! Do some data analysis!
Scatter plots show you how the sensor readings change over time. Add a Scatter Plot by going to Insert -> Charts -> Scatter.
When the plot pops up, right click on the empty chart and choose "Select Data," then Add a Series.
Add a title to your data series. Next, you'll want to display your data on the y-axis, with "time"* on the x-axis. To do this, click the arrow under the "Series Y-Values."
Go to the Data In sheet, and select all of the incoming sensor data.
Now you have a plot of your live data! This makes it much easier to visualize and understand changes in the sensor readings.
Youcan also do calculations and comparisons in Excel! To write a formula, click on an empty cell and type an equals sign (" ,");
Serial.print(sensorReading2);
Serial.print(",");
Serial.println();
That's it! Go forth and measure all the things!
Use this as a foundation to start exploring sensors, Arduino coding, and data analysis to tackle your questions, curiosities, and fav mysteries in this big, beautiful world.
Visit the Data Streamer website for instructions for simple sensor projects, or check out the Microsoft Hacking STEM website for more project ideas and full curriculum!
And of course, please leave a comment if you have any questions or need any assistance!
Arduino Analog Sensor Sample CodeArduino
Use this code to read an analog sensor from Arduino analog pin 0 and print to the serial port (Data Streamer). This sample code can be modified for more and different types of sensors as well as to get data from Excel and send commands to the Arduino microcontroller.
Microsoft Data Streamer (available in Excel) app samples
This repo contains the samples that demonstrate the API communication patterns for the Microsoft Data Streamer (available in Excel) in the Windows Software Development Kit (SDK) for Windows 10. These code samples were created with the Universal Windows Platform templates available in Visual Studio, and are designed to run on desktop, mobile, and future devices that support the Universal Windows Platform.
Note: If you are unfamiliar with Git and GitHub, you can download the entire collection as a ZIP file, but be sure to unzip everything to access shared dependencies. For more info on working with the ZIP file, the samples collection, and GitHub, see Get the UWP samples from GitHub. For more samples, see the Samples portal.
Data Streamer communication app development
These samples require Visual Studio 2017 Update 4 or higher and the Windows Software Development Kit (SDK) version 17134 for Windows 10.
Additionally, to stay on top of the latest updates to Windows and the development tools, become a Windows Insider by joining the Windows Insider Program.
Using the samples
The easiest way to use these samples without using Git is to download the zip file containing the current version (using the following link or by clicking the "Download ZIP" button on the repo page). You can then unzip the entire archive and use the samples in Visual Studio 2017.
Notes:
- Before you unzip the archive, right-click it, select Properties, and then select Unblock.
- Be sure to unzip the entire archive, and not just individual samples. The samples all depend on the SharedContent folder in the archive.
- In Visual Studio 2017, the platform target defaults to ARM, so be sure to change that to x64 or x86 if you want to test on a non-ARM device.
The samples use Linked files in Visual Studio to reduce duplication of common files, including sample template files and image assets. These common files are stored in the SharedContent folder at the root of the repository, and are referred to in the project files using links.
Reminder: If you unzip individual samples, they will not build due to references to other portions of the ZIP file that were not unzipped. You must unzip the entire archive if you intend to build the samples.
For more info about the programming models, platforms, languages, and APIs demonstrated in these samples, please refer to the guidance, tutorials, and reference topics provided in the Windows 10 documentation available in the Windows Developer Center. These samples are provided as-is in order to indicate or demonstrate the functionality of the programming models and feature APIs for Windows.
These samples are direct from the feature teams and we welcome your input on issues and suggestions for new samples. At this time we are not accepting new samples from the public, but check back here as we evolve our contribution model.
For additional UWP samples, see the Samples portal. For additional Windows samples, see Windows on GitHub.
About
One should use this example to learn on how to communicate (as UWP compliant app) to Microsoft Data Streamer
Note: This repo is now archived. It is still available READ ONLY for forking or historical interest.
Data Streamer Connect is an Open Source Project and Sample that demonstrates the following:
- Wrapping Microsoft MakeCode in a Windows UWP application
- Adding Blocks and JavaScript for the Arudino UNO using the Windows Provider Model and RemoteArduino built on the Firmata Protocol
- Adding a Windows AppService to a MakeCode UWP App to communicate with the Microsoft Hacking STEM Data Streamer Excel Plugin
- Adding example Blocks and JavaScript to communicate with Windows 10 platform API
- Upgrade Arudino Uno firmware programmatically with a pre-defined hex program
Setting up the development environment
To setup your development machine you will need to install:
- Visual Studio Community 2017 or better
- Install the Universal Windows Platform development workload
- Ensure that the following optional components are selected
- C++ Universal Windows Platform tools
- Windows 10 SDK (10.0.15063.0)
Updating the embedded Microsoft MakeCode instance
Data Streamer Connect is built using Microsoft MakeCode. To update the instance you will need to:
- Clone this repository
- You should create your own branch to contain any changes
- Open DataStreamerConnect.sln and build the project (either x86 or x64)
- Install Node.js
- Ensure that Node.js is added to the path
- Install Visual Studio Code
- Download the Sample PXT target
- Data Streamer Connect uses the sample PXT implementation as the base for its instance
- Open the ZIP file and copy the files from the pxt-sample-master folder to the PXT folder in the Data Streamer Connect repository
- NOTE: There are existing files in this folder that should not be overwritten:
- package.json
- pxtarget.json
- targetconfig.json
- docs/static/hero.jpg
- libs/core/ns.ts
- sim/api.ts
- sim/apiwinrt.ts
- sim/simulator.ts
- NOTE: There are existing files in this folder that should not be overwritten:
- Open the PXT folder in Visual Studio Code and then open a CMD Terminal for that folder location
- In the terminal window run the following commands:
- npm install -g pxt
- npm install
- Build the static package that Data Streamer Connect uses by running "pxt staticpkg" in the terminal window
- The first pass will generate a number of "Skipped data-uri" warning. These can be ignored
- Copy the files from PXT\built\packaged except for index.html into the DataStreamerConnect\DataStreamerConnect (this is the root folder of the UWP JavaScript application)
- Build the DataStreamerConnect solution or create a Microsoft Store package
- Only x86 and x64 packages are supported
- To install the created packages run "Add-AppDevPackage.ps1" with PowerShell and follow the prompts
Streaming data to Microsoft Excel
To use Microsoft Data Streamer you will need to have Microsoft Office installed as well.
When you submit a pull request, a CLA-bot will automatically determine whether you need to provide a CLA and decorate the PR appropriately (e.g., label, comment). Simply follow the instructions provided by the bot. You will only need to do this once across all repos using our CLA.
About
Data streamer Connect is a programming environment to help educational institutions and hobbyists teach and learn programming through a block driven interface using an Arduino.
Читайте также: