<?xml version="1.0" encoding="UTF-8"?>
<!--Xholon Workbook http://www.primordion.com/Xholon/wb/ (C) Ken Webb Wed May 09 2012 12:39:39 GMT-0400 (EDT)-->
<XholonWorkbook>
<Notes><![CDATA[
Xholon
------
Title: TreeSheets
Description:
Url: http://treesheets.com/
InternalName:
YoutubeId:
Keywords:
My Notes
--------
TreeSheets is a desktop application by Wouter van Oortmerssen. It is the "ultimate replacement for spreadsheets, mind mappers, outliners, PIMs, text editors and small databases". It's freeware, and works with Windows, Linus, and MacOSX. I downloaded it for Ubuntu Linux 11.10, and it works very well.
It organizes and displays hierarchical information, and it's compatible with Xholon's hierarchical structure.
As an example, while the following Xholon Workbook app was running ::
http://www.primordion.com/Xholon/wb/openwb.php?q=2489058&f=gist.github.com/raw/
the following text was generated
|timestep: 11
TheSystem
Constants
StefanBoltzmannConstant 0.000 W/m^2/K^4
SecondsPerTimeStep 31536000.000 s
SolarSystem
Sun
Temperature 5778.000 K
Space
Earth
TopOfAtmosphere
Albedo 0.307
Atmosphere
Energy 2558163124.885 J
Albedo 0.000
Temperature 246.748 K
Ta Celsius -26.403
Mass 10326.198 kg/m^2
SpecificHeat 1004.000 J/kg/K
HeatCapacity 10367502.551 J/m^3/K
Absorption 0.100
Emissivity 0.856
Surface
Energy 60842547337.366 J
Albedo 0.000
Temperature 288.490 K
Ts Celsius 15.338
Water
Density 1000.000 kg/m^3
SpecificHeat 4218.000 J/kg/K
MixedLayer
Depth 50.000 m
HeatCapacity 210900000.000 J/m^3/K
Fluxes
SunSpc_sw Flux 1367.000 W/m^2
SpcTpf_sw Flux 1367.000 W/m^2
TpfTpf_sw Flux 341.750 W/m^2
TpfAtm_sw Flux 236.775 W/m^2
AtmTpf_sw Flux 0.000 W/m^2
AtmSrf_sw Flux 213.098 W/m^2
SrfAtm_sw Flux 0.000 W/m^2
TpfSpc_sw Flux 104.975 W/m^2
SrfAtm_sh Flux 0.000 W/m^2
SrfAtm_lh Flux 0.000 W/m^2
SrfAtm_lw Flux 392.695 W/m^2
AtmSrf_lw Flux 179.969 W/m^2
AtmTpf_aw Flux 0.000 W/m^2
AtmTpf_lw Flux 236.378 W/m^2
TpfSpc_lw Flux 236.373 W/m^2
|
This generated text can be pasted into a cell in TreeSheets, using Right-Click > Paste.
By default, it looks like this ::
http://www.primordion.com/Xholon/wb/images/treeSheets11.png
and can look like ::
http://www.primordion.com/Xholon/wb/images/treeSheets12.png
Using various formatting options, it can be made to look like any of these (where timestep = 0) ::
http://www.primordion.com/Xholon/wb/images/treeSheets01.png
http://www.primordion.com/Xholon/wb/images/treeSheets02.png
http://www.primordion.com/Xholon/wb/images/treeSheets03.png
http://www.primordion.com/Xholon/wb/images/treeSheets04.png
TreeSheets can also directly read Xholon XML files, which it is able to partially display. It shows the data and attributes inside each XML element, but not the element name.
TreeSheets can flatten a hierarchical grid, and then export that as a .csv file. Excel and LibreOffice Calc can read these files ::
http://www.primordion.com/Xholon/wb/images/treeSheets13.csv
TreeSheets offers numerous other features ::
Spreadsheet operations are currently very minimal (sum + * - / and a few others)
I saved a sample TreeSheets binary file as ::
http://www.primordion.com/Xholon/wb/images/treeSheets01.cts
]]></Notes>
<script implName="lang:python:inline:"><![CDATA[
print "TreeSheets"
]]></script>
<script implName="lang:javascript:inline:"><![CDATA[
print("\n \"It's like a spreadsheet, immediately familiar, but much more suitable for complex data because it's hierarchical.\"");
print("\n \"It's like a mind mapper, but more organized and compact.\"");
print("\n \"It's like an outliner, but in more than one dimension.\"");
print("\n \"It's like a text editor, but with structure.\"");
]]></script>
<_-.XholonClass>
<!-- types of domain objects -->
<PhysicalSystem/>
<TreeSheets/>
</_-.XholonClass>
<xholonClassDetails>
</xholonClassDetails>
<PhysicalSystem>
<TreeSheets>
</TreeSheets>
</PhysicalSystem>
<Blockbehavior implName="lang:python:inline:"><![CDATA[
]]></Blockbehavior>
<Blockbehavior implName="lang:javascript:inline:"><![CDATA[
]]></Blockbehavior>
<Blockbehavior implName="lang:webEditionjs:inline:"><![CDATA[
]]></Blockbehavior>
<Blockbehavior implName="lang:bsh:inline:"><![CDATA[
]]></Blockbehavior>
<Blockbehavior implName="lang:jruby:inline:"><![CDATA[
]]></Blockbehavior>
<Blockbehavior implName="lang:groovy:inline:"><![CDATA[
]]></Blockbehavior>
<SvgClient><Attribute_String roleName="svgUri"><![CDATA[data:image/svg+xml,
<svg width="100" height="50" xmlns="http://www.w3.org/2000/svg">
<g>
<title>TreeSheets</title>
<rect id="PhysicalSystem/TreeSheets" fill="#98FB98" height="50" width="50" x="25" y="0"/>
</g>
</svg>
]]></Attribute_String><Attribute_String roleName="setup">${MODELNAME_DEFAULT},${SVGURI_DEFAULT}</Attribute_String></SvgClient>
</XholonWorkbook>