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":34,"date":"2014-06-19T08:56:20","date_gmt":"2014-06-19T08:56:20","guid":{"rendered":"http:\/\/www.spreadsheetengineer.co.uk\/?page_id=34"},"modified":"2014-08-17T06:37:00","modified_gmt":"2014-08-17T06:37:00","slug":"improving-your-spreadshets","status":"publish","type":"page","link":"http:\/\/www.spreadsheetengineer.co.uk\/improving-your-spreadshets\/","title":{"rendered":"Improving your Spreadsheets"},"content":{"rendered":"

A simple way to improve your spreadsheets<\/strong>:<\/h1>\n

By including a blank row\/column in SUM()s (or any Range, e.g. E3:E6) you can avoid one of the most common errors in spreadsheets.<\/p>\n

\"GrabShot_1a\"<\/p>\n

This spreadsheet has a \u201cGuard Row\u201d and a \u201cGuard Column\u201d (shown in grey), both are included in the SUM()s shown. You can insert rows or columns at the bottom or to the right and the SUM()s will adjust to include the additional columns (see below).<\/p>\n

\"GrabShot_2a\"<\/p>\n

Without the Guard Row\/Column, if you add additional rows and columns the SUM()s won\u2019t include them and the new data is missing from the totals.<\/p>\n

\"GrabShot_3a\"<\/p>\n

Excel sometimes<\/em><\/strong> adjusts the SUM()s automatically when data is entered from the keyboard, but not<\/em><\/strong> if it is pasted in.<\/p>\n","protected":false},"excerpt":{"rendered":"

A simple way to improve your spreadsheets: By including a blank row\/column in SUM()s (or any Range, e.g. E3:E6) you can avoid one of the most common errors in spreadsheets. This spreadsheet has a \u201cGuard Row\u201d and a \u201cGuard Column\u201d (shown in grey), both are included in the SUM()s shown. You can insert rows or […]<\/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-34","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/www.spreadsheetengineer.co.uk\/wp-json\/wp\/v2\/pages\/34","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=34"}],"version-history":[{"count":19,"href":"http:\/\/www.spreadsheetengineer.co.uk\/wp-json\/wp\/v2\/pages\/34\/revisions"}],"predecessor-version":[{"id":111,"href":"http:\/\/www.spreadsheetengineer.co.uk\/wp-json\/wp\/v2\/pages\/34\/revisions\/111"}],"wp:attachment":[{"href":"http:\/\/www.spreadsheetengineer.co.uk\/wp-json\/wp\/v2\/media?parent=34"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}