blob: bc2a31e207e5f212d8fe7137814f031b8e0201c0 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
|
[[!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]]
|
