l i n u x - u s e r s - g r o u p - o f - d a v i s
Next Meeting:
July 7: Social gathering
Next Installfest:
Latest News:
Jun. 14: June LUGOD meeting cancelled
Page last updated:
2002 Apr 14 20:24

The following is an archive of a post made to our 'vox-tech mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
[vox-tech] spreadsheet question
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[vox-tech] spreadsheet question

is it possible to define a circular reference with a spreadsheet?

consider the equation "t = T * tbar"

where "t" is time in SI units and tbar is time in some crazy unit system
which is convenient for my simulation.

sometimes it's nice to know "what number do i need to input for the
simulation to run for 3 seconds".  in other words, tbar = t / T is more

othertimes, it's nice to know "if i input 5 time units into the program,
how many real seconds would that represent"?   in other words,
t = T * tbar is more convenient.

i know i can do this as:

         A           B         C              D

0       'T           9E10
1       't           3.0      'tbar           =B1 / B0
2       'tbar        5.0      't              =B2 * B0

what would really be cool is:

        A              B

0      'T             9E10
1      't             ?????
2      'tbar          ?????

if i entered data in B1, it would put B1/B0 in cell B2.

if i entered data in B2, it would put B2*B0 in cell B1.

this is kind of circular, but definitely has use.  gnumeric is more or
less compatible with excel.   any spreadsheet gurus out there?

what would i fill in for the "?????" ?

vox-tech mailing list

LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
O'Reilly and Associates
For numerous book donations.