Parametric stand for synthesizers in OpenSCAD

It’s been a while since the last post! Let’s flush the buffers…

When looking for a suitable stand for my beloved Vector synthesizer on Thingiverse and other repositories, none of them suited my needs. Most importantly I was not impressed by the traditional construction of stands made of two pieces connected by threaded rods – the stand had to be able to fit the limited space of my drawer when not being used.

Therefore I designed yet another parametric stand which consists of two identical parts. Because the parts are wide enough, they can stand upright on they own and do not require any supporting hardware in between. The stand also has rubber feet both on the bottom of the stand and on the hypotenuse to increase friction.

Continue reading

Converting Excel (Calc) Spreadsheet to Code

A few months ago I needed to convert quite complex (kind of black box) computation from Excel spreadsheet to C code. At first I manually copied expressions from all cells but this was not simple as I had to check cells mentioned in expressions (formulas). It took long time and energy and the code didn’t work properly - results calculated by the spreadsheet differed from my program’s result.

Therefore I decided to save the Excel spreadsheet in ODF format (OpenOffice.org Calc) and write a little helper called SpreadsheetToCode. It’s a command-line utility that does the following steps:

  1. Load OpenDocument Spreadsheet file (.ods) because it's basically XML file wrapped in ZIP and therefore super easy to handle
  2. Pick all cells which contain numerical values (inputs, parameters) or expressions with them (formulas)
  3. Print C-like source code with the spreadsheet's functionality expressed in lines of code

Continue reading

Overcoming the Same-Origin Policy in an Iframe

A lot of webmasters use the Access-Control-Allow-Origin header in order not to have their content displayed somewhere else on the web. It is quite understandable as they want to have their intellectual property protected. But sometimes it might be useful to have some website loaded into an iframe although the iframe is quite old-fashioned HTML element.

In order to do so I found interesting service called WhateverOrigin.org (which is an open Source clone of similar service called AnyOrigin.com). It just grabs content from a website specified in GET parameter and returns it together with HTTP status code as JSON data.

Continue reading