{"id":365922,"date":"2020-01-05T15:31:43","date_gmt":"2020-01-05T22:31:43","guid":{"rendered":"https:\/\/jorgep.com\/blog\/?p=365922"},"modified":"2022-10-03T06:14:16","modified_gmt":"2022-10-03T13:14:16","slug":"excel-timeline-generator","status":"publish","type":"post","link":"https:\/\/jorgep.com\/blog\/excel-timeline-generator\/","title":{"rendered":"Excel Gantt Timeline Generator"},"content":{"rendered":"\n

In my work, I need to quickly generate timelines. I have been doing it by hand in Excel adding each tasks in a line, formatting the columns and then snipping the graphic into the document I need to paste it into. If changes were need, it was not easy to do, and started the timeline again.<\/p>\n\n\n\n

It is one of those things that I have been meaning to create some automation for, but never had the chance until a recent set of long flights which gave me the perfect opportunity to finally get it done. <\/p>\n\n\n\n

I wanted to enter a start date and then a set of tasks with duration for each line item. I later added dependency and offset for each line. <\/p>\n\n\n\n

\"\"
Sample Project<\/figcaption><\/figure>\n\n\n\n

Currently the spreadsheet is based on week increments. It would be fairly easy to modify to days, and add some formatting options, but will leave that for a future release. <\/p>\n\n\n\n

The Excel uses only formulas. <\/p>\n\n\n\n

No Macros, No VB or anything that may raise an eyebrow<\/p>\n\n\n\n

Please let me know (via Twitter) if you have any ideas, suggestions or modifications. Feel free to use to as needed! <\/p>\n\n\n\n

You can get the spreadsheet below: <\/p>\n\n\n\n

[email-download-link namefield=”YES” id=”3″]
<\/p>\n","protected":false},"excerpt":{"rendered":"

In my work, I need to quickly generate timelines. I have been doing it by hand in Excel adding each tasks in a line, formatting the columns and then snipping the graphic into the document I need to paste it into. If changes were need, it was not easy to do, and started the timeline…<\/p>\n","protected":false},"author":2,"featured_media":365915,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","episode_type":"","audio_file":"","podmotor_file_id":"","podmotor_episode_id":"","cover_image":"","cover_image_id":"","duration":"","filesize":"","filesize_raw":"","date_recorded":"","explicit":"","block":"","itunes_episode_number":"","itunes_title":"","itunes_season_number":"","itunes_episode_type":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[446],"tags":[580,579,577,578,168],"class_list":["post-365922","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips-tools-resources","tag-excel","tag-jpapps","tag-project-management","tag-timeline","tag-tools-tips"],"taxonomy_info":{"category":[{"value":446,"label":"Tips, Tools & Resources"}],"post_tag":[{"value":580,"label":"Excel"},{"value":579,"label":"JP Tools & Apps"},{"value":577,"label":"Project Management"},{"value":578,"label":"Timeline"},{"value":168,"label":"Tools & Tips"}]},"featured_image_src_large":["https:\/\/jorgep.com\/blog\/wp-content\/uploads\/2020\/01\/TimelineGenerator-LeadImage-1114x776-1-1024x713.jpg",1024,713,true],"author_info":{"display_name":"Jorge Pereira","author_link":"https:\/\/jorgep.com\/blog\/author\/jorge\/"},"comment_info":0,"category_info":[{"term_id":446,"name":"Tips, Tools & Resources","slug":"tips-tools-resources","term_group":0,"term_taxonomy_id":456,"taxonomy":"category","description":"","parent":0,"count":79,"filter":"raw","cat_ID":446,"category_count":79,"category_description":"","cat_name":"Tips, Tools & Resources","category_nicename":"tips-tools-resources","category_parent":0}],"tag_info":[{"term_id":580,"name":"Excel","slug":"excel","term_group":0,"term_taxonomy_id":590,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":579,"name":"JP Tools & Apps","slug":"jpapps","term_group":0,"term_taxonomy_id":589,"taxonomy":"post_tag","description":"","parent":0,"count":6,"filter":"raw"},{"term_id":577,"name":"Project Management","slug":"project-management","term_group":0,"term_taxonomy_id":587,"taxonomy":"post_tag","description":"","parent":0,"count":3,"filter":"raw"},{"term_id":578,"name":"Timeline","slug":"timeline","term_group":0,"term_taxonomy_id":588,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":168,"name":"Tools & Tips","slug":"tools-tips","term_group":0,"term_taxonomy_id":180,"taxonomy":"post_tag","description":"","parent":0,"count":64,"filter":"raw"}],"_links":{"self":[{"href":"https:\/\/jorgep.com\/blog\/wp-json\/wp\/v2\/posts\/365922","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jorgep.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jorgep.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jorgep.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jorgep.com\/blog\/wp-json\/wp\/v2\/comments?post=365922"}],"version-history":[{"count":0,"href":"https:\/\/jorgep.com\/blog\/wp-json\/wp\/v2\/posts\/365922\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jorgep.com\/blog\/wp-json\/wp\/v2\/media\/365915"}],"wp:attachment":[{"href":"https:\/\/jorgep.com\/blog\/wp-json\/wp\/v2\/media?parent=365922"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jorgep.com\/blog\/wp-json\/wp\/v2\/categories?post=365922"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jorgep.com\/blog\/wp-json\/wp\/v2\/tags?post=365922"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}