State of Play 2018/wk42

Health

So went to see the cardiologist in Wallaroo. Nurse measured weight, height and blood pressure and also took ECG, after which I saw the cardiologist. Dad drove me there from Maitland, mum and dad went shopping whilst I was at the doctors, on the way back they suggested we visit centrelink. So did that. (That was week 41).

Monday, check of INR and increased from 1.5 to 1.8. Today Monday (week 43) it has increased to 2 so back onto track to being between 2 and 3. On Tuesday I went for rehabilitation assessment, Tuesday(week 43) start rehabilitation.

Wednesday walked from home to the office, took 21 minutes there, rested for around 10 minutes then walked home took around 24 minutes. Tiresome on the legs but no real pressure on heart, not felt at the chest anyhow: left side of my neck seemed to be pulsating though and possible onset of lightheadedness: but otherwise feasible and not a problem. It was however more effort than the 20 laps round the garden,whilst near equal distances, the actual walk to the office is all uphill and steeper than the garden. The walk round the garden is down then up, whilst walk to the office is primarily uphill, just a small middle segment which goes downhill before going uphill again.

So walking to the office maybe be viable as will have a longer rest between the outward and homeward bound trips.

Business

Lack of billable work. Had enquiry from RPEQ, reinforced my view that no requirement to be competent to possess such post nominal detritus (and that they charge extortionate fees for their clients to have the benefit of their incompetence).

Worked on building navigation menu for bookmarks: at present not certain whether to build using html files or using MS Excel. Have current years bookmarks in Excel, previous years bookmarks in MS Access. Potential does exist to read MS Access using javascript from an html page. An html file seems easiest in terms of being available when browsing the internet, though MS Excel /MS Access  provide easier filtering and grouping. Will most likely use a combination of the options.

Converting MS Excel Spreadsheet to VBA or other High Level Language

Started to look at converting MS Excel worksheet to VBA code. This is the opposite of past desires, where wished I could convert gwbasic/fortran etc… to Quattro Pro spreadsheet: figured Borland could integrate such in Turbo C/Pascal.

The benefit of the spreadsheet is that it requires less effort to format the reports from calculations, and less effort to create input forms, allowing editing, and storage of input data. The benefit of code however is that it is not limited to a single application and can be used for purposes other than presentation of calculations. After all calculations are “a means to an end”, and “some ends” involve controlling machines or other software. Spreadsheets cannot do much in terms of controlling machines, but attached VBA code may have such facility. Whilst the results of calculations can be read from worksheets and used in VBA, it is not very efficient and timing problems can occur between automatically changing a value in a worksheet and getting the result from the worksheet. so converting the calculations to high level programming language can have some benefits. Whilst VBA may not be the preferred language for a given task, the language has potential to be converted to some other preferred language such as python. The first task is to convert to at least one language.

Additionally it is noted that SMath uses an XML file for its data storage the format of the file seems relatively simple and therefore converting an MS Excel spreadsheet to SMath is also another option to potentially improve presentation of the calculations. Or if not improve the calculations at least convert to a form preferred by others. In similar manner can convert to FreeMat, SciLab, Octave.

The exercise is not all that difficult, if put some constraints on the exercise, and matches previous attempts to export to a more controlled html file. The constraints consist of:

  1. Full conversion not required expect significant manual conversion
  2. Not overly interested in the report format, but can create some rudimentary version of the presentation if need be.
  3. Input forms not of concern
  4. Mainly want the calculations, most of Excel’s built-in functions will require some alternative

In short took less than a day to get a rudimentary conversion. Rather than look at improving the conversion, now considering looking closer at automating the modification of the spreadsheets, and making more compatible with conversion. The conversion of worksheet to high level language helps with understanding the spreadsheet. Whilst for some things I had started using the spreadsheet first for rapid prototyping (eg. XY charts for drawing), but then really want the whole thing converted to VBA to drive ProgeCAD rather than copy/paste to command line.