A few people have asked, how Excel could be used to create scripts or at least how to build simple patterns. I will use Handy and the app HandyControl to show you how it can be done as it supports an easy to use Excel import/export feature through the clipboard.
In the download folder of the app you can also find a script collection that is solely build with Excel.
Notice: You should have a basic understanding on how Excel works and how to use formulas or you will have a hard time to get things running. You might need to convert the shown formulas from german to the language that your excel is using.
Basic Script
A script needs two information. A timestamp in milliseconds and a position in percent where 0 is the bottom where the device needs to move down and 100 where the device moves up. The device will try to reach the position for the given timestamp. You can use any full number position within the 0-100 range.
In the example I have build two columns on the left which I use for input. The two right columns are calculated and are used to export the data.
Used formula: Add the time difference to the last timestamp.
Now export this to the clipboard by selecting the two right columns and press Ctrl + C
Import in HandyControl through the context menu.
You will get a simple script with top/down strokes.
Make sure that SmartJitter is disabled or it will modifie the script data on import.
You can now export the script to a .funscript or .csv file or copy if back to the excel clipboard.
Speed Modifications
In this script I increase the speed by reducing the time difference by 5% on each step.
Make sure that the decimals are rounded as we need integer numbers.
The result is clearly visible.
Position Modifications
We add some new columns in the table.
‘#’ is just a number that counts the rows.
‘P’ marks a Top or Bottom stroke.
‘Offset’ is a position modification.
The position of the left side is now build with a formula that used 0 for letter ‘B’ and 100 for everything else.
The offset uses the row number as factor to calculate a sine value.
This factor is then multiplied with the left position to create the final position.
Final script in HandyControl.
Using Scroll Bars
You can use scroll bars to chnage a value in a formula by pointing to a named range.
To use the scroll bar you have to enable the developer tab in excel first.
Now you can insert the scroll bar.
Right click the control and enter min and max values and the target cell.
Click your target cell and give it a name.
Use the given name in the formula.
Now you can scroll the slider and your script is updated automatically.
5
15
35
If the speed increase is removed and the script is expanded then it looks like this.
You also have to make sure that offset values cant go negative.
Diagramms
If you want to use diagramms in Excel for a preview you should go for XY diagramms.
The diagramm will also update on scroll bar changes.
As of HandyControl 0.12.0 beta1 you can also use a spreadsheet app together with HandyControl to create scripts. View the following link to get started.
