Okay, please hear me out on this! I understand that many people will not like this or agree with me, but allow users to insert and/or create actual spreadsheets inside Coda documents. Currently, users are only able to create or insert tables that are relational databases (relational tables) in Coda…

Hello @Frank_Novak , Although I think I understand where you are coming from, I don’t agree, not even a little bit. A spreadsheet is a very powerful tool and certainly has its place in our toolbox, but from what you are saying, I am pretty much convinced you don’t need a spreadsheet. The way you ca…

I too agree that not having spreadsheet functionality inside of Coda is a very big limitation. I am constantly finding that there are calculations that I want to do around the data that I have in tables that is best done in a spreadsheet, and right now, I have my work split amongst Coda and Google S…

Hi David, Welcome to the community! As an ex-accountant, that has mostly given up on spreadsheets, may I ask what do you do in a spreadsheet, that you cannot do in Coda? Regards Piet

Hi Piet, the big difference between a spreadsheet and a database (which is what Coda is at it’s core) is that each row in a spreadsheet can have a very different format and set of information to the other rows. In the models that I need to build there are many variables and calculations that don’t f…

[image] David_Skok: That kind of multi-variable model would be very hard to construct in a database structure I would change that to “very different to construct”. I used to do the 5-year forecasts for Toyota South Africa years ago. I would definitely do it in Coda if I had to redo. Coda h…

Thanks Piet. I can understand that for situations where you are building models to be used over and over, where you can take the time to do that. But what about the many situations where you just need to do something for yourself that isn’t that formal? And as a matter of interest, how do you easil…

[image] David_Skok: And as a matter of interest, how do you easily reference a single cell in a row in a table, where there is no unique identifier? [image]

Here is another way to do it: [image] The formula comes from the example I have build shown below. It gives you a Forecast Parameter table with interest rates per loan. The formula is from the Interest paid column in the Forecast Details table, and it calculates the interest paid per month per l…

I understand the willingness to have “One tool that rules them all”. Sometimes I find myself in need of note-taking in tabular format (aka spreadsheets). If grids had X and Y parameter to reference a cell that would solve it… I think.

Thank you Richard. This is great for quick and dirty calcs, which I would use quite often. As I understand it, it has a disadvantage for more serious shared applications: if the data in Row 2 was shifted out of Row 2 by an insertion above that row, it would no longer retrieve the right value. But Pi…

Create Actual Spreadsheets Inside Coda Documents

Product Feedback

Bill_French November 3, 2024, 4:25pm 17

A while back I write about this.

Topic		Replies	Views
The Wisdom of No Escape	27	3287	March 17, 2022
Lookup data from another doc	21	3237	February 1, 2021
Realistic number of rows in a table Tips and Hacks	37	11126	April 4, 2024
Introduce yourself!	149	15761	March 13, 2026
What are Codas current limitations and how can we work with them?	22	3468	December 5, 2022

Create Actual Spreadsheets Inside Coda Documents

Related topics