Warning: preg_match(): Allocation of JIT memory failed, PCRE JIT will be disabled. This is likely caused by security restrictions. Either grant PHP permission to allocate executable memory, or set pcre.jit=0 in /services4/s/p/spreadsheetengineer.co.uk/public/wp-includes/load.php on line 121
Warning: Cannot modify header information - headers already sent by (output started at /services4/s/p/spreadsheetengineer.co.uk/public/wp-includes/load.php:121) in /services4/s/p/spreadsheetengineer.co.uk/public/wp-includes/rest-api/class-wp-rest-server.php on line 1893
Warning: Cannot modify header information - headers already sent by (output started at /services4/s/p/spreadsheetengineer.co.uk/public/wp-includes/load.php:121) in /services4/s/p/spreadsheetengineer.co.uk/public/wp-includes/rest-api/class-wp-rest-server.php on line 1893
Warning: Cannot modify header information - headers already sent by (output started at /services4/s/p/spreadsheetengineer.co.uk/public/wp-includes/load.php:121) in /services4/s/p/spreadsheetengineer.co.uk/public/wp-includes/rest-api/class-wp-rest-server.php on line 1893
Warning: Cannot modify header information - headers already sent by (output started at /services4/s/p/spreadsheetengineer.co.uk/public/wp-includes/load.php:121) in /services4/s/p/spreadsheetengineer.co.uk/public/wp-includes/rest-api/class-wp-rest-server.php on line 1893
Warning: Cannot modify header information - headers already sent by (output started at /services4/s/p/spreadsheetengineer.co.uk/public/wp-includes/load.php:121) in /services4/s/p/spreadsheetengineer.co.uk/public/wp-includes/rest-api/class-wp-rest-server.php on line 1893
Warning: Cannot modify header information - headers already sent by (output started at /services4/s/p/spreadsheetengineer.co.uk/public/wp-includes/load.php:121) in /services4/s/p/spreadsheetengineer.co.uk/public/wp-includes/rest-api/class-wp-rest-server.php on line 1893
Warning: Cannot modify header information - headers already sent by (output started at /services4/s/p/spreadsheetengineer.co.uk/public/wp-includes/load.php:121) in /services4/s/p/spreadsheetengineer.co.uk/public/wp-includes/rest-api/class-wp-rest-server.php on line 1893
Warning: Cannot modify header information - headers already sent by (output started at /services4/s/p/spreadsheetengineer.co.uk/public/wp-includes/load.php:121) in /services4/s/p/spreadsheetengineer.co.uk/public/wp-includes/rest-api/class-wp-rest-server.php on line 1893
{"id":59,"date":"2014-06-21T05:45:54","date_gmt":"2014-06-21T05:45:54","guid":{"rendered":"http:\/\/www.spreadsheetengineer.co.uk\/?page_id=59"},"modified":"2014-06-21T18:06:36","modified_gmt":"2014-06-21T18:06:36","slug":"advanced-stuff","status":"publish","type":"page","link":"http:\/\/www.spreadsheetengineer.co.uk\/advanced-stuff\/","title":{"rendered":"Advanced Stuff"},"content":{"rendered":"Under Construction:<\/h3>\n
This section will contain more advanced information intended to be suitable for experienced users of Excel. I have been working with spreadsheets almost from when Excel first became available on the early Apple Macs. After many versions of Excel I believe that the core of how Excel does the maths has hardly changed. Many enhancements have made Excel able to handle data better, which is not what it was originally designed for, but the basic problems with how Excel handles mathematical modelling are still present. There have been a few new functions added, e.g. SUMPRODUCT(), SUMIF() and then SUMIFS(), COUNTIFS() etc. but that is about it for the maths.<\/p>\n
So what I am saying is that the experience I have through many years of using Excel for computational spreadsheets is still very relevant today. I have collected a huge amount of experience of the pitfalls encountered in large workbooks, and I will share that with my clients.<\/p>\n","protected":false},"excerpt":{"rendered":"
Under Construction: This section will contain more advanced information intended to be suitable for experienced users of Excel. I have been working with spreadsheets almost from when Excel first became available on the early Apple Macs. After many versions of Excel I believe that the core of how Excel does the maths has hardly changed. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-templates\/full-width.php","meta":{"footnotes":""},"class_list":["post-59","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/www.spreadsheetengineer.co.uk\/wp-json\/wp\/v2\/pages\/59","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.spreadsheetengineer.co.uk\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/www.spreadsheetengineer.co.uk\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/www.spreadsheetengineer.co.uk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.spreadsheetengineer.co.uk\/wp-json\/wp\/v2\/comments?post=59"}],"version-history":[{"count":7,"href":"http:\/\/www.spreadsheetengineer.co.uk\/wp-json\/wp\/v2\/pages\/59\/revisions"}],"predecessor-version":[{"id":72,"href":"http:\/\/www.spreadsheetengineer.co.uk\/wp-json\/wp\/v2\/pages\/59\/revisions\/72"}],"wp:attachment":[{"href":"http:\/\/www.spreadsheetengineer.co.uk\/wp-json\/wp\/v2\/media?parent=59"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}