{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,25]],"date-time":"2025-03-25T14:48:32Z","timestamp":1742914112865,"version":"3.40.3"},"publisher-location":"Cham","reference-count":9,"publisher":"Springer International Publishing","isbn-type":[{"type":"print","value":"9783319502298"},{"type":"electronic","value":"9783319502304"}],"license":[{"start":{"date-parts":[[2016,1,1]],"date-time":"2016-01-01T00:00:00Z","timestamp":1451606400000},"content-version":"unspecified","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2016]]},"DOI":"10.1007\/978-3-319-50230-4_31","type":"book-chapter","created":{"date-parts":[[2016,11,30]],"date-time":"2016-11-30T08:31:26Z","timestamp":1480494686000},"page":"401-414","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["Implementing Nested FOR Loops as Spreadsheet Formulas"],"prefix":"10.1007","author":[{"given":"Paul","family":"Mireault","sequence":"first","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2016,12,1]]},"reference":[{"key":"31_CR1","doi-asserted-by":"publisher","first-page":"15","DOI":"10.4018\/joeuc.1998040102","volume":"10","author":"RR Panko","year":"2008","unstructured":"Panko, R.R.: What we know about spreadsheet errors. J. End User Comput. 10, 15\u201321 (2008)","journal-title":"J. End User Comput."},{"key":"31_CR2","unstructured":"Burden, T.: How a Rookie excel error led JPMorgan to misreport its VaR for years (2013). \n                      http:\/\/www.zerohedge.com\/news\/2013-02-12\/how-rookie-excel-error-led-jpmorgan-misreport-its-var-years"},{"key":"31_CR3","unstructured":"Mouchel profits blow (2011). \n                      http:\/\/www.express.co.uk\/finance\/city\/276053\/Mouchel-profits-blow"},{"key":"31_CR4","unstructured":"Conczal, M.: Researchers finally replicated Reinhart-Rogoff, and there are serious problems. Roosevelt Institute (2013). \n                      http:\/\/rooseveltinstitute.org\/researchers-finally-replicated-reinhart-rogoff-and-there-are-serious-problems\/"},{"key":"31_CR5","doi-asserted-by":"publisher","first-page":"165","DOI":"10.1145\/944746.944721","volume":"38","author":"SP Jones","year":"2003","unstructured":"Jones, S.P., Blackwell, A., Burnett, M.: A user-centred approach to functions in excel. ACM Sigplan Not. 38, 165\u2013176 (2003)","journal-title":"ACM Sigplan Not."},{"key":"31_CR6","doi-asserted-by":"publisher","first-page":"25","DOI":"10.1109\/MS.2009.140","volume":"26","author":"M Erwig","year":"2009","unstructured":"Erwig, M.: Software engineering for spreadsheets. IEEE Softw. 26, 25\u201330 (2009)","journal-title":"IEEE Softw."},{"key":"31_CR7","doi-asserted-by":"crossref","unstructured":"Cunha, J., Fernandes, J.P., Mendes, J., Saraiva, J.: MDSheet: a framework for model-driven spreadsheet engineering. In: Presented at the Proceedings of the 34th International Conference on Software Engineering, Zurich, Switzerland (2012)","DOI":"10.1109\/ICSE.2012.6227239"},{"key":"31_CR8","doi-asserted-by":"crossref","unstructured":"Mireault, P.: Structured spreadsheet modeling and implementation. In: 2nd Workshop on Software Engineering Methods in Spreadsheets, Firenze, IT (2015)","DOI":"10.21125\/inted.2016.1906"},{"key":"31_CR9","volume-title":"Structured Spreadsheet Modelling and Implementation: A Methodology for Creating Effective Spreadsheets","author":"P Mireault","year":"2016","unstructured":"Mireault, P.: Structured Spreadsheet Modelling and Implementation: A Methodology for Creating Effective Spreadsheets. SSMI International, Montr\u00e9al (2016)"}],"container-title":["Lecture Notes in Computer Science","Software Technologies: Applications and Foundations"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-319-50230-4_31","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2019,5,20]],"date-time":"2019-05-20T01:39:38Z","timestamp":1558316378000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/978-3-319-50230-4_31"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2016]]},"ISBN":["9783319502298","9783319502304"],"references-count":9,"URL":"https:\/\/doi.org\/10.1007\/978-3-319-50230-4_31","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2016]]},"assertion":[{"value":"1 December 2016","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"STAF","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Federation of International Conferences on Software Technologies: Applications and Foundations","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Vienna","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Austria","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2016","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"4 July 2016","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"8 July 2016","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"staf2016","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}}]}}