Skip to content

Welcome Sites Tools Teacher guide Help
  You are not logged in Join

Log in

simplified export to Excel

Created by yish   -   Created: 10-02-04   -   Modified: 30-03-04




 

What does it do?


It collects numbers to a text pad, and then copies this text pad to the clipboard - so that you can paste it into Excel.

How do I use it?

Give the input bird to a robot that produces numbers, or boxes of numbers.
When you want to copy the data to Excel, give the copy out bird a clipboard picture.
Switch to Excel, and hit Ctrl+V.

Give the broom to the copy out bird to clear the clipboard.

See the pictutorial below.

How does it work?

There are two teams of robots on the back of the Excel picture.
The first team converts the numbers (or boxes) to text, and sends it to the second.
The second team joins the bits of  texts sent by the first to one text pad. When it gets a clipboard picture, it copies it out to the windows clipboard.

What can I use it for?


Plotting sequences of numbers.

This tool is based on Ken's To Tabbed Text for Excel.

Pictutorial


 


 

Change log

30 March 2004
Fixed a bug with fractions. The tool now converts all inputs to decimal.


 





Comment

Discussion icon Bug with numbers in boxes

Posted by: gordon at 27-05-04

There is a bug if you use numbers in boxes as input (e.g. train a robot to give boxed numbers to the data bird). The problem is with the convert to decimal team where one of the robots cuts a box then drops it back onto the input nest. If the numbers have been streaming in, then there will be stuff on the input nest and the robot will get confused and stop.