[REQ] Ruby, “report-back”

[Bep]

Hello to all Ruby wizards,

Is there a ruby that can report specified values of selected entities to a Excel workbook with a custom made formula in it, and report back the outcome of the calculation as a text and paste it in the drawing.
If so, where can I find it?
If it does not exists, can it be made ?, and does someone wants to?

I think it could work like this.

After installing ,,the ruby,, you should be able in a context menu to add a new or /remove/edit/save-as, one ore more pre-installed Excel-workbooks, and re-name them.
Preferably you should be able to assign a keyboard shortcut to every workbook.
These workbooks can now be edited.
One page of the workbook would be used to report-to from Sketchup.
An other page would be the ,,edit page,,
On this edit page you should be able to:,

• specify witch values of the first selected entities from the Sketchup model get exported at first report ,and to witch range in the sheet.
  -which and where the second and next selections get pasted.
  -specify the cell with the outcome of the calculation to report back from to Sketchup.

Then.
-first you activate ,,the ruby,,
-Then you could for example select a couple of edges in a drawing, or a group, (the content of a group should be considered a selection.)
-Then click on “report to/from workbook1 ”, (or name ,to be specified) .
As long as you don’t shoos a different workbook ,all next reports are made to the same workbook .
The ruby would now export only the pre-specified entity-values (for example only edge lengths, or only end points , to be specified in the edit page) of the selected edges and put them on say row one (to be specified in the edit page ) of page 1 of the spreadsheet called, formula 1.
A next selection could now be exported (to be specified) to page 1 of the spreadsheet
All of these values separated in there own cell.
The formula (made by the user) would perform a calculation ,and the outcome would be presented in a specified cell of the spreadsheet.
From this cell after an ‘’Enter’’ on the keyboard the ruby would export the value in a specified cell back in a text box with leader attached to a pre-selected point of the model.
Now you can position this textbox, and after clicking you done.

Before you click the same ruby, or an other ruby you should be able to save the excel file, after selecting the same workbook to report to its content gets erased

To be able to do partial calculations, and afterwards a total calculation, you could activate the same ruby, select the separate text boxes and click for example “report to/from formula 2” ,and it would do a calculation with the text or numbers in the text boxes, and report it back.

Greetings Bep van Malde