-
Choosing Manual Scheduled or Autoscheduled in Microsoft Project
A Microsoft Project task has many options and I am often asked how to choose the correct ones, Task Mode can be, “Auto Scheduled” or “Manual Scheduled” and task Type can be “Fixed Work”, “Fixed Units” or “Fixed Duration”. and Auto Scheduled tasks can be Effort Driven (or not) You can display these parameters for…
-
Netgear WNR1000v3 router port forwarding bug
My router was supplied by Plusnet (firmware V1.0.2.30_53.0.66B1). It has several bugs in the port forwarding function. First the good news: It WILL forward port 80 to port 80 on another server Now the bugs: The User Interface prohibits forwarding any inbound port to other well known ports such as 8080 The User Interface permits…
-
PyCon tweet proves email is not worst form of communication
I have long thought that email was the worst form of communication; primarily because it involves no real conversation, only the author giving his views to the recipient. But Adria Richards, who in her own words is a “Joan of Arc” like figure has proved me wrong. The feminist Ms Richards was offended by the…
-
Create the Union of two tables in Excel
— 2017-04-03 I have new post for Excel 2016 (2013) — It is very common in Excel to need to create a single table from the two or more other tables. For example, different users may edit different worksheets but you need to aggregate all the data for processing. This can be done relatively simply…
-
How to add a row number to an Excel table
Excel tables provide a lot of support for data processing and the use of structured references can improve readability. We want to number rows in an Excel table and we can do it really easily using structured references. =ROW(Table01[@])-ROW(Table01[[#Headers],[RowId]]) We simply find the row number of the current cell [@] using ROW and then subtract…
-
A T-SQL SPLIT function
When taking existing data to put into a data warehouse one hopes that it is nicely formatted. This is seldom the case and recently I was faced with the problem that single field contained a rather dirty list. First I cleaned the list using REPLACE to replace the variety of delimiters with comma. Then I…
-
Opera joins Google/Apple in-crowd with shift to WebKit and Chromium
http://go.theregister.com/feed/www.theregister.co.uk/2013/02/13/webkit_sucks_on_webkit_chromium/
-
SQL Server Import Wizard cannot import fields containing more than 255 characters
I have been importing data from Excel to SQL Server using the SQL Server Import Wizard. Usually there is no problem but I have found a bug. 1. To reproduce: Try to import a column containing more than 255 characters text, optimistically set the destination datatype to nvarchar(max) and the failure options to “ignore” on…
-
How the Internet has Changed the Spread of Information
Something new today, a post by a guest blogger John Harris on how the internet has changed the spread of information. Away you go, John, — In the past couple of decades, the Internet has transformed from a classic message board to a tool that is used to instantly communicate with loved ones, release new…
Dr James Bayley
Creating successful projects
Dr James Bayley 