Hurmet
Hurmet copied to clipboard
Reusing columns from previously defined table
Is there a way of reusing columns from previously defined tables in Hurmet Spreadsheets without having to retype everything?
In this example, I want to define a new table for diaphragm force distribution and want to use the columns from previously defined table. Is there a way to achieve this? The dittto will behave like a constant.
¢format ="h2"
¢k = 1
¢V_base = 500kips
: Table1 Seismic Force Distribution +--------+----------+---------+----------+-----------+--------------+--------+----------------+ | Floor | Weight\ | Height\ | w × h^k^ | C~vs~ | Force\ | Shear\ | Overturning\ | | | kips | ft | | | kips | kips | kip·ft | +========+:========:+:=======:+:========:+:=========:+:============:+:======:+:==============:+ | roof | 950 | 70 | =B1×C1^k | =D1/D_end | ==E1× V_base | =F1 | 0 | +--------+----------+---------+----------+-----------+--------------+--------+----------------+ | fifth | 1,250 | 56 | " | " | " | =G1+F2 | =H1+G1×(C1-C2) | +--------+----------+---------+----------+-----------+--------------+--------+----------------+ | fourth | " | 42 | " | " | " | " | " | +--------+----------+---------+----------+-----------+--------------+--------+----------------+ | third | " | 28 | " | " | " | " | " | +--------+----------+---------+----------+-----------+--------------+--------+----------------+ | second | " | 14 | " | " | " | " | " | +--------+----------+---------+----------+-----------+--------------+--------+----------------+ | total | =sum(up) | 0 | =sum(up) | | =sum(up) | =F_end | " | +--------+----------+---------+----------+-----------+--------------+--------+----------------+ {#Table1 ."four-rules spreadsheet" colWidths="70 71 62 73 88 74 76 null"}
¶
¢Table1.Weight=??kips
¶
: Table2 Diaphragm Force Distribution +--------------------+---------------------+---------------------+ | Floor | Weight\ | Height\ | | | kips | ft | +====================+=====================+=====================+ | =Table1.Floor.roof | =Table1.roof.Weight | =Table1.roof.Height | +--------------------+---------------------+---------------------+ | “ | “ | “ | +--------------------+---------------------+---------------------+ {#Table2 ."grid spreadsheet" colWidths="163 159 null"}
¶