Re:Ask HN: What are the crazy/clever ways you use and abuse ...
by vgrichina on Saturday March 08, 2014 @06:12AM
(#7364894)
"bubble gum and duct tape programming job" – I guess you just found a name for the programming paradigm I plan to implement :)
As I understood in your case a system was a mix of what spreadsheets are good fit in (accounting) and where it is currently a kludge (gathering and massaging data).
So I think I'll explore data massaging in more depth. I am a bit concerned however with the representation of hierarchical data (like JSON) in spreadsheet model.
Re:Ask HN: What are the crazy/clever ways you use and abuse ...
by vgrichina on Saturday March 08, 2014 @07:47PM
(#7367011)
BTW, what were the main difficulties/problems in implementing your project using spreadsheets?
I assume that one of these was having to write Ruby scripts to connect things together instead of working directly with your data sources, was there anything else?
Re:Ask HN: What are the crazy/clever ways you use and abuse ...
by patio11 on Sunday March 09, 2014 @12:24AM
(#7367563)
I have never had the need to do anything particularly complicated in Excel before, and had to learn how to express things that would have been very easy for me in Ruby, like "Servers, domain names, telephone bills, Twilio credits, and the like count as 通信費. Sum the total of all 通信費 given a list of all of your expenses for the past year."
If you add in the one-and-done Ruby scripts that I made to grab the information from the various computer systems and then spit out CSV for copy/pasting into Excel, this is unquestionably the worst bubble gum and duct tape programming job I've ever had the misfortune of participating in -- but it let me submit my tax return in time for the deadline, with numbers that looked pretty reasonable.