RomRaider

I started work on my own tuning calculator designed to work in Libreoffice and Openoffice spreadsheet alternatives.

This program is VERY EARLY alpha testing phase.

Written in python 3.3 using the built-in spreadsheet APIs for using python. It is currently no more that just a teaser of what is possible with these programs and a python interface.

Currently it's pretty slow. I have not been able to find out if its possible to read and insert entire rows and columns at once to the spreadsheets. So currently, it executes pretty slowly as it moves data, cell by cell individually. Testing on 50k rows and 10 columns of datalogs takes around 5-10 minutes on one core of a I7-2600k processor at 4.5ghz.

Goals of this project will be to create all of the major 2D/3D tables as corrected tables by using data-logs, filtering, interpolation, and various methods. These tables could then be copy/pasted directly to update and refine a tune or used as multiplier tables to scale current tables to new adjustments from captured logs.
This and all versions provided as-is, no-warranty, with no claims of functioning as intended. It's intended to be a useful tool used at your own risk or success and to stimulate creation of knowledge.

[Version 1.0.0] (soon)
I had this version done which was able to produce a single usable table with some basic filtering and interpolation. It became unfit to release until I fix a few bugs but I've been really busy lately with other things.

I've also been contemplating, skipping the whole read cells from the office software in favor of just reading the datalog as raw CSV, parsing, then writing out a new CSV with new tuning tables. However, I keep telling myself the point of why I am using this API is so that eventually we can just run the program as a macro from inside the spreadsheet and have it automatically parse the data to build tables right before your eyes so you don't have to fuss with opening more files.

[Version 0.6.0]
Initial proof of concept. Connects to an openoffice/libreoffice spreadsheet via an internal API that comes with them. Selects Spreadsheet windows, Collects Row/Col data, basic python parsing and logic, and finally writes some collated tables to another sheet.

The documentation provided for this APIs is very difficult for me to read and translate into python code using a library called "uno" or "PyUNO". I haven't really found any documentation on PyUno yet to help me so I have just been using trial and error to convert the office API into python/uno code.

soooooo, how do you use it?

I love the idea behind this.
I'm not knowledgeable enough to help with the coding, but if there's anything else I can do to help just ask.