diff options
Diffstat (limited to '2022/talks/realestate.md')
| -rw-r--r-- | 2022/talks/realestate.md | 91 |
1 files changed, 91 insertions, 0 deletions
diff --git a/2022/talks/realestate.md b/2022/talks/realestate.md new file mode 100644 index 00000000..d3dbbdab --- /dev/null +++ b/2022/talks/realestate.md @@ -0,0 +1,91 @@ +[[!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> +- Really liking the idea of the talk so far, but I would suggest zooming in on the text more next time +- Damn, org tables have so many more features than the ones I use already +- tables in org are highly underused. all the functionality of spreadsheet calculators with the power of elisp at your fingertips! +- this talk is awesome +- and org-mode has plenty of hidden power... +- and the power of Emacs Calc, to boot. Including handling units like kW, m, Pa, ... +- +1 for the awesomeness +- I've always been slightly apprehensive of going full spreadsheet with org tables but the features are very cool. +- I actually learned a lot from this talk. Thanks @gopar. +- great talk, thank you very much! +- excellent presentation, thanks! +- loved the presentation +- just downloaded a .webm of the talk. looks great on my screen (1280x720) +- Thanks for the Org mode Table tips +- was a fun, straight forward how to. very useful. +- I don't have any questions now, but I'm going to try to learn many things that you demonstrated! +- I hadn't seen the formula debugger before. Very useful information. +- org tables are so powerful +- moving around cols + rows - is also way faster than what one can do in GUI spreadsheet apps +- oh! great, thanks for sharing! + +## 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> +- where is the org file for thase calculations? + + +[[!inline pages="internal(2022/info/realestate-after)" raw="yes"]] + +[[!inline pages="internal(2022/info/realestate-nav)" raw="yes"]] + +[[!taglink CategoryOrgMode]] |