Next Meeting: July 7: Social gathering Next Installfest: TBD Latest News: Jun. 14: June LUGOD meeting cancelled Page last updated: 2002 Apr 14 23:23
 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)
Re: [vox-tech] spreadsheet question
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [vox-tech] spreadsheet question

```On Sun, 14 Apr 2002, Peter Jay Salzman wrote:

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

Yes.  They don't like it when you do. :)

> 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
> convenient.
>
> 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.

Sounds like you want a psychic spreadsheet assistant, or a custom data
entry form like the "Edit" button provides in the Financial mode of the
PalmOS Calc application (the blank datum gets calculated).

> 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 "?????" ?

Whatever formula you typed would vanish the next time you edited the cell
to put in a number to solve in the other direction.

You could set the formula up in one direction use the Tools | Goal
Seek... menu item to reverse the operation.  I think your first solution
above would be easier to use.

---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil@dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...2k
---------------------------------------------------------------------------

_______________________________________________
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech

```

 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: Who graciously hosts our website & mailing lists!