Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Spreadsheets are all you need

spreadsheets-are-all-you-need.ai

Post reply on HN
Print view View original

51–60 of 178 posts

Re: Spreadsheets are all you need

#51

Post by thelittleone »

makeitdouble wrote: post #48
mckn1ght wrote: post #2

Brilliant idea/URL. It’s often true though. So many things I think “I could make an app for that” I wind up just using a spreadsheet for. At least it helps me explore the use cases more deeply for when I’d want to actually take it to the next level. I hung out with a friend while they solved Advent of Code challenges in Excel, that was a trip to watch.

I wonder at what point we stop calling them "spreadsheets" though. You mention Excel, and a bunch of us do it Google Sheets, but at this point it's not about sheets of data anymore and more about the interface and runtime, and we have full applications running in it. I remember a colleague running API tests inside his Excel sheet to more easily check for the different parameter combinations, but telling everyone he w…

I think it still becomes about the data. If using a sheet as an app particularly with sharepoint, data integrity and merging multiple users often becomes a problem.

I run one for a financial services firm and often get "excel couldnt merge changes, want to save a copy or discard". We tested this out, 2 users make editing different sheets on a single excel workbook hosted on sharepoint and excel can't figure out how to merge. If someone is on VPN and connection drops this also often occurs.

Re: Spreadsheets are all you need

#53

Post by brnt »

snehesht wrote: post #10

Spreadsheet link https://github.com/ianand/spreadsheets-are-all-you-need/rele...

I'm not a big Excel user, but I see errors that I get when I type in English function names while using a non-English version of Excel. Is it correct that functions (and thus this xlsb file) are not portable to other language versions of Excel?

Re: Spreadsheets are all you need

#55

Post by wil421 »

makeitdouble wrote: post #48
mckn1ght wrote: post #2

Brilliant idea/URL. It’s often true though. So many things I think “I could make an app for that” I wind up just using a spreadsheet for. At least it helps me explore the use cases more deeply for when I’d want to actually take it to the next level. I hung out with a friend while they solved Advent of Code challenges in Excel, that was a trip to watch.

I wonder at what point we stop calling them "spreadsheets" though. You mention Excel, and a bunch of us do it Google Sheets, but at this point it's not about sheets of data anymore and more about the interface and runtime, and we have full applications running in it. I remember a colleague running API tests inside his Excel sheet to more easily check for the different parameter combinations, but telling everyone he w…

You can feed postman a CSV to test parameters with. You can also do it on the CLI with Newman.

Re: Spreadsheets are all you need

#56

Post by keybits »

> What about Google Sheets? > This project actually started on Google Sheets but the full 124M model was too big and switched to Excel. I’m still exploring ways to make this work in Google Sheets but it is unlikely to fit into a single file as it can with Excel.

I wonder if it would work in https://rowzero.io/home ?

Re: Spreadsheets are all you need

#58

Post by makeitdouble »

wil421 wrote: post #55
makeitdouble wrote: post #48

Earlier quoted context omitted.

I wonder at what point we stop calling them "spreadsheets" though. You mention Excel, and a bunch of us do it Google Sheets, but at this point it's not about sheets of data anymore and more about the interface and runtime, and we have full applications running in it. I remember a colleague running API tests inside his Excel sheet to more easily check for the different parameter combinations, but telling everyone he w…

You can feed postman a CSV to test parameters with. You can also do it on the CLI with Newman.

Once you've decided to go with Excel it becomes pretty different from just feeding an array of values. You can autogenerate the combinations applying rules on what to avoid, fuzzy the values, get the result of an API transform it and feed it to another API etc.

I'm not recommending any of this, but it can go as far as you want...

Re: Spreadsheets are all you need

#59

Post by emmelaich »

Related? I was copy'n'pasting a few chars from one column from to another in gsheets.

Gsheets intuited that I wanted to do this multiple times and offered this formula:

> =RIGHT(A7,LEN(A7) - (FIND(CHAR(160),SUBSTITUTE(A7," ",CHAR(160),2))))

Post reply on HN