{"id":141,"date":"2009-05-14T18:30:00","date_gmt":"2009-05-14T18:30:00","guid":{"rendered":"http:\/\/turtlellc.com\/index.php\/modifying-forecast-input-templates\/"},"modified":"2009-05-14T18:30:00","modified_gmt":"2009-05-14T18:30:00","slug":"modifying-forecast-input-templates","status":"publish","type":"post","link":"http:\/\/www.turtle.works\/knowledge\/modifying-forecast-input-templates\/","title":{"rendered":"Modifying Forecast Input Templates"},"content":{"rendered":"<p>OPEN INPUT TEMPLATE FOR EDITING<\/p>\n<p>1. eTools -> Open Dynamic Templates<br \/>2. Input Schedules -> 09 Input Templates<br \/>3. Open &#8216;Forecast Input Template 2009.xlt&#8217;<\/p>\n<p>UPDATE FORECAST TEMPLATE TO REFLECT NEW MONTH OF ACTUALS<\/p>\n<p>1. Change Cell A4 and BA6 to the new FCST Month<\/p>\n<p>MODIFY EVGTS FORMULAS<\/p>\n<p>1. If we are modifying to prepare for October Month End, then we will copy Cells Q15:Q233 to R15:R233<br \/>2. Update Cells R12 and R13 to say ACT and OCT in Black Font<\/p>\n<p>MODIFY EVSEND FORMULAS<\/p>\n<p>1. If we are modifying to prepare for October Month End, then we will copy Cells BI15:BI233 to BJ15:BJ233<\/p>\n","protected":false},"excerpt":{"rendered":"<p>OPEN INPUT TEMPLATE FOR EDITING 1. eTools -> Open Dynamic Templates2. Input Schedules -> 09 Input Templates3. Open &#8216;Forecast Input Template 2009.xlt&#8217; UPDATE FORECAST TEMPLATE TO REFLECT NEW MONTH OF ACTUALS 1. Change Cell A4 and BA6 to the new FCST Month MODIFY EVGTS FORMULAS 1. If we are modifying to prepare for October Month &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.turtle.works\/knowledge\/modifying-forecast-input-templates\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Modifying Forecast Input Templates&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[4,11],"tags":[],"class_list":["post-141","post","type-post","status-publish","format-standard","hentry","category-bpc","category-forecast"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Modifying Forecast Input Templates - Turtle Works<\/title>\n<meta name=\"description\" content=\"A knowledge base written by Turtle Works LLC to help you achieve Modifying Forecast Input Templates - Turtle Works\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.turtle.works\/knowledge\/modifying-forecast-input-templates\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Modifying Forecast Input Templates - Turtle Works\" \/>\n<meta property=\"og:description\" content=\"A knowledge base written by Turtle Works LLC to help you achieve Modifying Forecast Input Templates - Turtle Works\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.turtle.works\/knowledge\/modifying-forecast-input-templates\/\" \/>\n<meta property=\"og:site_name\" content=\"Turtle Works\" \/>\n<meta property=\"article:published_time\" content=\"2009-05-14T18:30:00+00:00\" \/>\n<meta name=\"author\" content=\"josef.wainz\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"josef.wainz\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/modifying-forecast-input-templates\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/modifying-forecast-input-templates\\\/\"},\"author\":{\"name\":\"josef.wainz\",\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#\\\/schema\\\/person\\\/cb79278290029b781485a7b61b9b9a0b\"},\"headline\":\"Modifying Forecast Input Templates\",\"datePublished\":\"2009-05-14T18:30:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/modifying-forecast-input-templates\\\/\"},\"wordCount\":102,\"publisher\":{\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#organization\"},\"articleSection\":[\"BPC\",\"Forecast\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/modifying-forecast-input-templates\\\/\",\"url\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/modifying-forecast-input-templates\\\/\",\"name\":\"Modifying Forecast Input Templates - Turtle Works\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#website\"},\"datePublished\":\"2009-05-14T18:30:00+00:00\",\"description\":\"A knowledge base written by Turtle Works LLC to help you achieve Modifying Forecast Input Templates - Turtle Works\",\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/modifying-forecast-input-templates\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/modifying-forecast-input-templates\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/modifying-forecast-input-templates\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Modifying Forecast Input Templates\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#website\",\"url\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/\",\"name\":\"Turtle Works\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#organization\",\"name\":\"Turtle Works\",\"url\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/cropped-TurtleWorks.png\",\"contentUrl\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/cropped-TurtleWorks.png\",\"width\":625,\"height\":250,\"caption\":\"Turtle Works\"},\"image\":{\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#\\\/schema\\\/person\\\/cb79278290029b781485a7b61b9b9a0b\",\"name\":\"josef.wainz\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g\",\"caption\":\"josef.wainz\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Modifying Forecast Input Templates - Turtle Works","description":"A knowledge base written by Turtle Works LLC to help you achieve Modifying Forecast Input Templates - Turtle Works","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/www.turtle.works\/knowledge\/modifying-forecast-input-templates\/","og_locale":"en_US","og_type":"article","og_title":"Modifying Forecast Input Templates - Turtle Works","og_description":"A knowledge base written by Turtle Works LLC to help you achieve Modifying Forecast Input Templates - Turtle Works","og_url":"http:\/\/www.turtle.works\/knowledge\/modifying-forecast-input-templates\/","og_site_name":"Turtle Works","article_published_time":"2009-05-14T18:30:00+00:00","author":"josef.wainz","twitter_card":"summary_large_image","twitter_misc":{"Written by":"josef.wainz"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.turtle.works\/knowledge\/modifying-forecast-input-templates\/#article","isPartOf":{"@id":"http:\/\/www.turtle.works\/knowledge\/modifying-forecast-input-templates\/"},"author":{"name":"josef.wainz","@id":"https:\/\/www.turtle.works\/knowledge\/#\/schema\/person\/cb79278290029b781485a7b61b9b9a0b"},"headline":"Modifying Forecast Input Templates","datePublished":"2009-05-14T18:30:00+00:00","mainEntityOfPage":{"@id":"http:\/\/www.turtle.works\/knowledge\/modifying-forecast-input-templates\/"},"wordCount":102,"publisher":{"@id":"https:\/\/www.turtle.works\/knowledge\/#organization"},"articleSection":["BPC","Forecast"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"http:\/\/www.turtle.works\/knowledge\/modifying-forecast-input-templates\/","url":"http:\/\/www.turtle.works\/knowledge\/modifying-forecast-input-templates\/","name":"Modifying Forecast Input Templates - Turtle Works","isPartOf":{"@id":"https:\/\/www.turtle.works\/knowledge\/#website"},"datePublished":"2009-05-14T18:30:00+00:00","description":"A knowledge base written by Turtle Works LLC to help you achieve Modifying Forecast Input Templates - Turtle Works","breadcrumb":{"@id":"http:\/\/www.turtle.works\/knowledge\/modifying-forecast-input-templates\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.turtle.works\/knowledge\/modifying-forecast-input-templates\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/www.turtle.works\/knowledge\/modifying-forecast-input-templates\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.turtle.works\/knowledge\/"},{"@type":"ListItem","position":2,"name":"Modifying Forecast Input Templates"}]},{"@type":"WebSite","@id":"https:\/\/www.turtle.works\/knowledge\/#website","url":"https:\/\/www.turtle.works\/knowledge\/","name":"Turtle Works","description":"","publisher":{"@id":"https:\/\/www.turtle.works\/knowledge\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.turtle.works\/knowledge\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.turtle.works\/knowledge\/#organization","name":"Turtle Works","url":"https:\/\/www.turtle.works\/knowledge\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.turtle.works\/knowledge\/#\/schema\/logo\/image\/","url":"http:\/\/www.turtle.works\/knowledge\/wp-content\/uploads\/2020\/07\/cropped-TurtleWorks.png","contentUrl":"http:\/\/www.turtle.works\/knowledge\/wp-content\/uploads\/2020\/07\/cropped-TurtleWorks.png","width":625,"height":250,"caption":"Turtle Works"},"image":{"@id":"https:\/\/www.turtle.works\/knowledge\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.turtle.works\/knowledge\/#\/schema\/person\/cb79278290029b781485a7b61b9b9a0b","name":"josef.wainz","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g","caption":"josef.wainz"}}]}},"_links":{"self":[{"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/posts\/141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/comments?post=141"}],"version-history":[{"count":0,"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/posts\/141\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/media?parent=141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/categories?post=141"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/tags?post=141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}