{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["gantt","Sheet1"],"not_rendered":{"macros":1,"defined_names":9,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"gantt","index":0,"n_rows":139,"n_cols":165,"rows_kept":139,"merged":[[1,10,16,10],[2,0,9,0],[10,0,16,0]]}
[{"$nulls":7},"Hide using above sign",null,"Hide using above sign"]
[null,"Deliverable","Resource","Status","Start ","Due ","Duration\n(weekdays)","Predecessor",null,"Colour","Gantt Chart",{"$f":"MIN(E3:E97)","v":"2012-07-11"},{"$f":"IF(L2<=MAX($F$3:$F$94),L2+1,\"\")","v":"2012-07-12"},"2012-07-13","2012-07-14","2012-07-15","2012-07-16","2012-07-17","2012-07-18","2012-07-19","2012-07-20","2012-07-21","2012-07-22","2012-07-23","2012-07-24","2012-07-25","2012-07-26","2012-07-27","2012-07-28","2012-07-29","2012-07-30","2012-07-31","2012-08-01","2012-08-02","2012-08-03","2012-08-04","2012-08-05","2012-08-06","2012-08-07","2012-08-08","2012-08-09","2012-08-10","2012-08-11","2012-08-12",{"$f":"IF(AR2<=MAX($F$3:$F$94),AR2+1,\"\")","v":"2012-08-13"},"2012-08-14","2012-08-15","2012-08-16","2012-08-17","2012-08-18","2012-08-19","2012-08-20","2012-08-21","2012-08-22","2012-08-23","2012-08-24","2012-08-25","2012-08-26","2012-08-27","2012-08-28","2012-08-29","2012-08-30","2012-08-31","2012-09-01","2012-09-02","2012-09-03","2012-09-04","2012-09-05","2012-09-06","2012-09-07","2012-09-08","2012-09-09","2012-09-10","2012-09-11","2012-09-12","2012-09-13",{"$f":"IF(BX2<=MAX($F$3:$F$94),BX2+1,\"\")","v":"2012-09-14"},"2012-09-15","2012-09-16","2012-09-17","2012-09-18","2012-09-19","2012-09-20","2012-09-21","2012-09-22","2012-09-23","2012-09-24","2012-09-25","2012-09-26","2012-09-27","2012-09-28","2012-09-29","2012-09-30","2012-10-01","2012-10-02","2012-10-03","2012-10-04","2012-10-05","2012-10-06","2012-10-07","2012-10-08","2012-10-09","2012-10-10","2012-10-11","2012-10-12","2012-10-13","2012-10-14","2012-10-15",{"$f":"IF(DD2<=MAX($F$3:$F$94),DD2+1,\"\")","v":"2012-10-16"},"2012-10-17","2012-10-18","2012-10-19","2012-10-20","2012-10-21","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(EJ2<=MAX($F$3:$F$94),EJ2+1,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Set up blog",{"$nulls":4},{"$f":"IF(INDIRECT(\"EA100\")=\"NO\",_xludf.NETWORKDAYS(E3,F3),DATEDIF(E3,F3, \"d\")+1 )","v":1}]
[null,"Think up blog name","Mike","Completed","2012-07-12","2012-07-14",{"$f":"NETWORKDAYS(E4,F4)","v":2},null,null,"red"]
[null,"Create account online","Mike","Ongoing","2012-07-14","2012-07-18",{"$f":"NETWORKDAYS(E5,F5)","v":3},"Think up blog name",null,"blue"]
[null,"Write first blog post","Bob","Not started","2012-07-18","2012-07-18",{"$f":"NETWORKDAYS(E6,F6)","v":1},"Create account online",null,"green"]
[null,"Prepare Excel file",{"$nulls":4},{"$f":"NETWORKDAYS(E7,F7)","v":0}]
[null,"Clean up script","Mike","Not started","2012-07-18","2012-07-22",3,"Write first blog post",null,"orange"]
[null,"Write how to guide","Alex","Not started","2012-07-19","2012-07-28",7,"Clean up script",null,"blue"]
[null,"Share online","Mike","Over Schedule","2012-07-11","2012-07-31",15,"Write how to guide",null,"orange"]
[null,"Complete project",{"$nulls":4},0]
[null,"Complete doc","Mike","Not started","2012-07-25","2012-07-27",{"$nulls":3},"blue"]
[null,"Defect Management & resolution","Jane, Alex","Not started","2012-07-27","2012-07-29",1,"Complete doc",null,"orange"]
[null,"Another task here","Alex","Not started","2012-07-29","2012-07-29",0,"Defect Management & resolution",null,"red"]
[null,"And another","Jane","Not started","2012-07-27","2012-07-28",1,"Complete doc",null,"red"]
[null,"And finally another","Mike","Not started","2012-07-29","2012-08-02",4,"Another task here",null,"green"]
[null,"End date",null,null,{"$f":"TODAY()","v":"2012-07-13"},"2012-10-20",{"$f":"NETWORKDAYS(E17,F17)","v":71},null,null,"blue"]
[]
[]
[]
[]
[null,"Total days actual",{"$nulls":4},{"$f":"(MAX(F3:F94)-MIN(E3:E94))","v":101}]
[null,"Total weekdays",{"$nulls":4},{"$f":"NETWORKDAYS(EC97,EC98)","v":73}]
[]
[]
[]
[]
[null,"How to & Key features of Simple Gantt * features in yellow I like most"]
[1,"The Gantt bars update automatically in response to the dates entered in the Start (Column E) and Due (Column F) cells. Whatever day the earliest deliverable begins on constitutes the beginning of the chart. \n\nThe End date in column F (cell shaded grey) is the day the project ends. The date entered here determines the length of the Gantt and automatically updates the gantt chart size accordingly. Try it out. "]
[null,"Dependent Start dates update automatically to End date of Predecessor.\n\n In column H you can select whether the current task is dependent on other tasks (has predecessors) . If the current task falls before its predecessor, the Gantt will ask you if you want to update the current task to begin on the end date of its predecessor. (For finish-to-start dependencies)\n\nThe cell in column H will  shade red if the current task date falls before its predecessor date. Just click on the shaded cell and the option to update the dates will activate. \n\nPower feature. Likely one of the most useful."]
[2,"Right click anywhere in the Gantt chart area to add a new task from that date or update an existing task! \n\nClick anywhere on the Gantt chart area and a popup box allows you to enter new or update existing task details, resources, dates etc. A very useful feature that allows you a lot more flexibility - giving you the freedom to update a task from anywhere on the sheet -  and makes updating the gantt chart at lot easier.  Try it out. \n\nPower feature. Likely one of the most useful."]
[3,"Jump to the Start date for a task from anywhere on Gantt chart. \n\nDealing with many tasks means we can easily get lost in the Gantt chart . Right clicking anywhere on the Gantt chart and selecting 'Jump to start date' will take you right back to the Start date for that currently selected task. Nice. "]
[4,"The current day is highlighted in green and bolded above the date bars area (See row 2)"]
[5,"Weekends have blue font and the column is highlighted using a dotted pattern, to allow them to be easily identified. "]
[6,"Change the colour of the bars.\n\nColumn J allows you to choose the colours of the Gantt bars. The current options are blue, green orange, purple and red. This column should be hidden by default and can be unhidden using the + and - signs above column J.\n\n\nThis  feature will also be most useful to users. "]
[7,"The status is set in column C. This is updated manually but colour is dynamically set according to days remaining to complete task. \n\n*If the deliverable is due within 2 days the status turns orange. \n* If due today or overdue it turns red. \n* If the status of a deliverable is set to complete the bar chart for that deliverable turns grey. "]
[8,"Clicking on the bar chart or anywhere to the right of the Deliverable column highlights the Deliverable in yellow allowing you to easily see the deliverable to which the clicked date bars  or info relates. "]
[9,"Get a Task summary via comments anywhere along date bars.\n\nClicking on any bar in the Gantt chart area creates a comment (click on bar and wait a sec). In this comment you can see all the key information related to that particular task - including number of days since project began/until project starts. So even if you're scrolling across the Gantt chart, you have key information at a click.  A very cool and quick way to get the key details for a task. \n\n\nPower feature. Likely one of the most useful."]
[10,"The Gantt chart is best viewed at 80% zoom. "]
[null,"On a more general note - Gantt charts are useful, but not for gigantic projects (Too many tasks clutter the screen). This will work best for smaller projects with around 10 - 30 tasks."]
[null,"There's a few more features in there I haven't mentioned. I intend to add more, and improve any bugs in the current version. Feel free to share and improve. In fact, doing so would be awesome.  "]
{"$rows_empty":9}
[{"$nulls":3},"h","h"]
[{"$nulls":3},"h","h"]
[null,"g"]
[null,"g"]
{"$rows_empty":23}
[null,null,"Days remaining count"]
[null,null,{"$f":"AND(A3<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(A4<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(A5<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(A6<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":128},"NO"]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":128},"NO"]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":128},"YES"]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(A8<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":128},"NO"]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":129},"Network days spent",null,null,"days overdue/remaining"]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":129},{"$f":"MIN(E4:E37)","v":"2012-07-11"},null,null,{"$f":"IF(F3<>\"\",F3-TODAY(), \"\")","v":""}]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":129},{"$f":"MAX(F4:F37)","v":"2012-10-20"}]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(F5<>\"\",F5-TODAY(), \"\")","v":5}]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(F6<>\"\",F6-TODAY(), \"\")","v":5}]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(#REF!<>\"\",#REF!-TODAY(), \"\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(#REF!<>\"\",#REF!-TODAY(), \"\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(#REF!<>\"\",#REF!-TODAY(), \"\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(#REF!<>\"\",#REF!-TODAY(), \"\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(#REF!<>\"\",#REF!-TODAY(), \"\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(A11<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(#REF!<>\"\",#REF!-TODAY(), \"\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(A13<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(#REF!<>\"\",#REF!-TODAY(), \"\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(A14<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(F8<>\"\",F8-TODAY(), \"\")","v":9}]
[null,null,{"$f":"AND(A15<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(F11<>\"\",F11-TODAY(), \"\")","v":""}]
[null,null,{"$f":"AND(A16<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(#REF!<>\"\",#REF!-TODAY(), \"\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(#REF!<>\"\",#REF!-TODAY(), \"\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(#REF!<>\"\",#REF!-TODAY(), \"\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(#REF!<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(#REF!<>\"\",#REF!-TODAY(), \"\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(A17<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(#REF!<>\"\",#REF!-TODAY(), \"\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(A18<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(#REF!<>\"\",#REF!-TODAY(), \"\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(A19<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(#REF!<>\"\",#REF!-TODAY(), \"\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(A20<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(#REF!<>\"\",#REF!-TODAY(), \"\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(A21<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(F13<>\"\",F13-TODAY(), \"\")","v":16}]
[null,null,{"$f":"AND(A22<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(#REF!<>\"\",#REF!-TODAY(), \"\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(A23<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(#REF!<>\"\",#REF!-TODAY(), \"\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(A24<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(#REF!<>\"\",#REF!-TODAY(), \"\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(A25<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(#REF!<>\"\",#REF!-TODAY(), \"\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(A26<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(#REF!<>\"\",#REF!-TODAY(), \"\")","v":{"$error":"#REF!"}}]
[null,null,{"$f":"AND(A27<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(F14<>\"\",F14-TODAY(), \"\")","v":16}]
[null,null,{"$f":"AND(A28<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(F15<>\"\",F15-TODAY(), \"\")","v":15}]
[null,null,{"$f":"AND(A29<>\"\",#REF!<> \"Completed\")","v":{"$error":"#REF!"}},{"$nulls":132},{"$f":"IF(F16<>\"\",F16-TODAY(), \"\")","v":20}]
[{"$nulls":135},{"$f":"IF(F17<>\"\",F17-TODAY(), \"\")","v":99}]
[{"$nulls":135},{"$f":"IF(F18<>\"\",F18-TODAY(), \"\")","v":""}]
[{"$nulls":135},{"$f":"IF(#REF!<>\"\",#REF!-TODAY(), \"\")","v":{"$error":"#REF!"}}]
[{"$nulls":135},{"$f":"IF(F19<>\"\",F19-TODAY(), \"\")","v":""}]
[{"$nulls":135},""]
[{"$nulls":135},""]
[{"$nulls":135},""]
[{"$nulls":135},""]
[{"$nulls":135},""]
[{"$nulls":135},""]
[{"$nulls":135},""]
[{"$nulls":135},""]
[{"$nulls":135},""]

{"sheet":"Sheet1","index":1,"n_rows":3,"n_cols":1,"rows_kept":3}
["Dependancy"]
["Use collections"]
["Need to enter start and due dates before you can check for dependecies!"]