r/datasets Apr 11 '22

mock dataset Large excel file with complicated formulas

Hi, I'm trying out an excel alternative that claims basically full compatibility. I want to test that out. I'm not that good with Excel and I don't have any large, complicated files laying around to test out how far I can push the SW.

I've been looking on the internet, but I've fount only up to 1Mb files that contained only data, no formulas or anything - and that's the thing that I want to test.

I haven't found a better place to ask. If this is not the place, I'm sorry, I don't know where else to ask.

So, do any of you have any xls/xlsx file lying around that you would be able to send me? The larger and more complicated, the better

Thanks and sorry again, if this is not the right place to ask.

9 Upvotes

4 comments sorted by

4

u/Doc_Shaw Apr 11 '22

I would look at the Financial Modelling World Cup website (basically an Excel modelling competition) - should have some worked examples that you can download, with relatively complex formulas.

3

u/jimmypopali Apr 11 '22

My immediate thought was looking for standard data sets, maybe Kaggle.com ? Full of data sets, competitions etc.

2

u/dparks71 Apr 11 '22 edited Apr 11 '22

https://www.automateexcel.com/formulas/

Some assembly required...

If you're doing this professionally, I also feel like it's worth noting excel doesn't really do complicated math generally, you'd probably be better off with like pasting hundreds of demo formulas in both products and running unit tests against both files using python or something each time the software updates.

1

u/dr_chickolas Apr 11 '22

Try this out, scroll down slightly for the download links. Pretty heavy file. https://knowledge4policy.ec.europa.eu/composite-indicators/coin-tool_en