path: root/2022/talks/realestate.md

[[!sidebar content=""]]
[[!meta title="Real estate and Org table formulas"]]
[[!meta copyright="Copyright © 2022 Daniel Gopar"]]
[[!inline pages="internal(2022/info/realestate-nav)" raw="yes"]]

<!-- Initially generated with emacsconf-generate-talk-page and then left alone for manual editing -->
<!-- You can manually edit this file to update the abstract, add links, etc. --->


# Real estate and Org table formulas
Daniel Gopar (he/him, IRC: gopar, <mailto:gopardaniel@gmail.com>)

[[!inline pages="internal(2022/info/realestate-before)" raw="yes"]]

This will be a 20 minute presentation on how I use org mode tables (specifically formulas) on how I can quickly see if a deal is feasible or not.

Topics will include:

-   Creating Table Formulas
-   Special Buffer Editing Formulas
-   Formatting output
-   Special Debugging just for formulas
-   Creating Custom Formulas
-   Automatically re-calculating rows/table
-   Finally Putting it all together to tell at a glance if a property is ideal or not

Essentially bits and pieces from this section of the manual:
<https://orgmode.org/manual/The-Spreadsheet.html>


# Discussion

## Notes

-   <https://orgmode.org/manual/The-Spreadsheet.html>

## Questions and answers

-   Q:  Pretty neat-- Can you say how this is better than maintaining a
    gui spreadsheet? 
    -   A: As all things in life, this is preference. org tables are
        text only and for me this is easier than learning yet another
        tool (google spreadsheets/MS excel/etc) but totally up to you
        :)  Also, you can write your formulas in Elisp instead of
        whatever crippled language you have to use in other
        spreadsheets.+2 (move the logic to lisp to other package and
        decouple/reuse it other documents, test it, etc.); Moving around
        cols + rows - is also way faster than what one can do in GUI
        spreadsheet apps
-   Q: Is there a way to share the constants between the tables?
    -   A: You can create a constants for the entire buffer, or save
        them as variables :)
-   Q: Can you please provide the link to the org file?
    -   A: Currently the file is not hosted anywhere. I can put it in a
        github repo in a bit :)
-   Q:Is there a way to link to a cell in another row in the same table?
    or other tables?
    -   A:I think i remember reading that it is possible to do the first
        part of your question. I don't think you can do the 2nd part
        about linking cells from other tables. I'd recommend double
        checking w/ the org docs since I can be misremembering things :)
    -   Update: Looks like it is possible ->
        <https://orgmode.org/manual/References.html>


[[!inline pages="internal(2022/info/realestate-after)" raw="yes"]]

[[!inline pages="internal(2022/info/realestate-nav)" raw="yes"]]

[[!taglink CategoryOrgMode]]