<div dir="ltr">Thanks for the encouragement Alexander!</div><br><div class="gmail_quote"><div dir="ltr">On Fri, Sep 21, 2018 at 5:14 AM Alexander Bock <<a href="mailto:albo@itu.dk">albo@itu.dk</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> <div style="word-wrap:break-word;line-break:after-white-space"> Hi Trent, <div><br> </div> <div></div></div><div style="word-wrap:break-word;line-break:after-white-space"><div> <blockquote type="cite"> <div dir="ltr">About a year ago, I thought up an idea on my own very like Funcalc, that I called Scriptsheets. At the time, I did not know Funcalc and its predecessors, going back about 20 years, existed. I briefly though I had had a Very Original Idea. Alas, it was not so. See: <a href="https://haskell.markmail.org/search/?q=scriptsheets" target="_blank">https://haskell.markmail.org/search/?q=scriptsheets</a> .</div> </blockquote> <div><br> </div></div></div><div style="word-wrap:break-word;line-break:after-white-space"><div> Cool! Funcalc doesn’t go 20 years back. The original inspiration came from a 2003 paper by Simon Peyton-Jones et al. called: “A User-Centred Approach to Functions in Excel” which suggested the idea but did not implement AFAIK. There are a few papers on the subject on my supervisor’s site as well as other resources which I linked earlier.</div> <div><br> </div> <div>There have been some attempts at scripting spreadsheets (even with Haskell) but I do not recall the titles. Also, there was a document that described a spreadsheet implemented in the functional language Clean (I/O) which had some interesting features. For example, I believe lazy evaluation was used to only update cells that were needed to show the current visible section of the spreadsheet.</div> <div><br> </div> <div></div></div><div style="word-wrap:break-word;line-break:after-white-space"><div> <blockquote type="cite"> <div dir="ltr"> <div> <div>Given that I am one person, and woefully under-prepared in computer science to accomplish my goals, the odds are I won't get very far on my roadmap before getting distracted.</div> </div> </div> </blockquote> <div><br> </div></div></div><div style="word-wrap:break-word;line-break:after-white-space"><div> My own background is biotechnology, so do not let your background discourage you.</div> <div><br> </div> <div></div></div><div style="word-wrap:break-word;line-break:after-white-space"><div> <blockquote type="cite"> <div dir="ltr"> <div> <div>Even if I do embark on step 5, the odds are it will wind up as Java-based abandonware like Frege or Jython.</div> </div> </div> </blockquote> <div><br> </div></div></div><div style="word-wrap:break-word;line-break:after-white-space"><div> At this stage in your journey, doing is learning which in my opinion is more important than worrying if your software will be abandoned at some point in the future.</div> <div><br> </div> <div></div></div><div style="word-wrap:break-word;line-break:after-white-space"><div> <blockquote type="cite"> <div dir="ltr"> <div> <div>But that is not why I am writing. Can I prevail on the good graces of either of you to look through my first draft prospectus for Scriptsheets to see if, against all odds, there is anything of interest in it? I would REALLY appreciate feedback from someone involved with spreadsheet professional programming or research. The text runs 31 dry, boring pages. I finished it 2017-11-02. </div> </div> </div> </blockquote> </div></div><div style="word-wrap:break-word;line-break:after-white-space"><div><div> <div dir="ltr"> <div> <div><br> </div> <div>I am in the final stages of my PhD and barely have time for anything else at the moment, so I will unfortunately have to respectfully decline :/ hopefully someone on the mailing list with more time can help.</div> </div> </div> </div></div></div><div style="word-wrap:break-word;line-break:after-white-space"><div> <div> <div style="color:rgb(0,0,0);letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word"> <div style="color:rgb(0,0,0);letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word"> <div style="color:rgb(0,0,0);letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word"> <div style="color:rgb(0,0,0);letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word"> <div style="color:rgb(0,0,0);letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word"> <div style="color:rgb(0,0,0);letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word"> <div style="color:rgb(0,0,0);letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word"> <div style="color:rgb(0,0,0);font-variant-caps:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"> <br class="m_-7233868729676866212Apple-interchange-newline"> Mvh/Best regards,</div> <div style="color:rgb(0,0,0);font-variant-caps:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"> <font face="Consolas"><br class="m_-7233868729676866212Apple-interchange-newline"> <b>Alexander Asp Bock</b>, PhD student</font></div> <div style="color:rgb(0,0,0);font-variant-caps:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"> <a href="https://computerscience.wikit.itu.dk/" target="_blank"><font face="Consolas">Computer Science Department</font></a></div> <div style="color:rgb(0,0,0);font-variant-caps:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"> <a href="http://en.itu.dk/" target="_blank"><font face="Consolas">IT University of Copenhagen</font></a></div> </div> </div> </div> </div> </div> </div> </div> </div> </div></div><div style="word-wrap:break-word;line-break:after-white-space"><div><div><br> <blockquote type="cite"> <div>On 19 Sep 2018, at 09.04, trent shipley <<a href="mailto:trent.shipley@gmail.com" target="_blank">trent.shipley@gmail.com</a>> wrote:</div> <br class="m_-7233868729676866212Apple-interchange-newline"> <div> <div dir="ltr">About a year ago, I thought up an idea on my own very like Funcalc, that I called Scriptsheets. At the time, I did not know Funcalc and its predecessors, going back about 20 years, existed. I briefly though I had had a Very Original Idea. Alas, it was not so. See: <a href="https://haskell.markmail.org/search/?q=scriptsheets" target="_blank">https://haskell.markmail.org/search/?q=scriptsheets</a> . <div><br> <div><br> </div> <div>I have only a degree in mathematics (at which was was not very good) and a community college certificate in computer programming from the CIS department (at which I did quite well).</div> <div><br> </div> <div>At present, my plan is to:</div> <div> <ol> <li>Finish the Haskell book I'm working on (Hutton 2016) to get some exposure to functional programming.<br> </li><li>Work my way through a book on writing compilers in Java. (Ronald Mak 2009, or maybe I'll get something newer by then.)</li><li>Work through the Calc/Funcalc book.</li><li>Translate the Calc/Funcalc programs from C# into Java.</li><li>Start the Scriptsheets project.</li></ol> Given that I am one person, and woefully under-prepared in computer science to accomplish my goals, the odds are I won't get very far on my roadmap before getting distracted. Even if I do embark on step 5, the odds are it will wind up as Java-based abandonware like Frege or Jython.</div> <div><br> </div> <div>But that is not why I am writing. Can I prevail on the good graces of either of you to look through my first draft prospectus for Scriptsheets to see if, against all odds, there is anything of interest in it? I would REALLY appreciate feedback from someone involved with spreadsheet professional programming or research. The text runs 31 dry, boring pages. I finished it 2017-11-02. </div> <div><br> </div> <div>Regards,</div> <div><br> </div> <div>Trent.</div> </div> </div> <br> <div class="gmail_quote"> <div dir="ltr">On Tue, Sep 18, 2018 at 2:56 AM Michael Meeks <<a href="mailto:michael.meeks@collabora.com" target="_blank">michael.meeks@collabora.com</a>> wrote:<br> </div> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> Hi Alexander,<br> <br> On 18/09/18 10:26, Alexander Bock wrote:<br> > I would be delighted to join one of the hackfests if time allows. Is<br> > there a schedule available somewhere?<br> <br> We typically have one in Hamburg at some stage in the year - which<br> would be near you; the ESC minutes have details on all of those as they<br> come up (posted to this list weekly). We also have a larger hackfest in<br> Brussels before or after FOSDEM - which is an excellent conference to<br> attend anyway =)<br> <br> > I know of EUSPRIG as well and their horror stories<br> > <<a href="http://eusprig.org/horror-stories.htm" rel="noreferrer" target="_blank">http://eusprig.org/horror-stories.htm</a>><br> <br> Some good stories there =) Thanks for the list of conferences.<br> <br> > Do you run any of the generated OpenCL kernels in parallel or do you run<br> > a normal sequential recalculation and call the kernel code as necessary?<br> > I would suspect the latter given the information you have provided so far :)<br> <br> Only in very recent times (the last generation) has typical GPU<br> hardware become capable of running multiple kernels simultaneously<br> and/or pre-empting running kernels. This leads to amusing situations -<br> whereby moving the mouse while a long running sheet calculates would<br> simply not be able to render - until a Windows / TDR was triggered. We<br> had to come up with heuristics to break down the CL workload into<br> bite-sized chunks to avoid this. More modern hardware doesn't have this<br> issue though.<br> <br> And yes, we use CL when we think it makes sense - based on weights and<br> complexity of the relevant formulae. Otherwise we use the old<br> interpreter (or now its threaded variant - again depending on complexity).<br> <br> HTH,<br> <br> Michael.<br> <br> -- <br> <a href="mailto:michael.meeks@collabora.com" target="_blank">michael.meeks@collabora.com</a> <><, GM Collabora Productivity<br> Hangout: <a href="mailto:mejmeeks@gmail.com" target="_blank">mejmeeks@gmail.com</a>, Skype: mmeeks<br> (M) <a href="tel:+44%207795%20666147" value="+447795666147" target="_blank"> +44 7795 666 147</a> - timezone usually UK / Europe<br> _______________________________________________<br> LibreOffice mailing list<br> <a href="mailto:LibreOffice@lists.freedesktop.org" target="_blank">LibreOffice@lists.freedesktop.org</a><br> <a href="https://lists.freedesktop.org/mailman/listinfo/libreoffice" rel="noreferrer" target="_blank">https://lists.freedesktop.org/mailman/listinfo/libreoffice</a><br> </blockquote> </div> </div> </blockquote> </div> <br> </div></div></blockquote></div>