{"product_id":"excel-resource-planning-and-allocation-system-for-up-to-10-projects","title":"Excel Resource Planning Template - Multi-Project Capacity Planner","description":"\u003cp\u003e\u003cstrong\u003eCapacity Planning\u003c\/strong\u003e Spreadsheet and Resource Allocation Planning for your project resources across up to 10 Projects. Automate resource allocation and identify potential overbooking issues before they arise.\u003c\/p\u003e\n\u003cp\u003eHow it works on a High Level:\u003cbr\u003e- Input Resource names and Availability\u003cbr\u003e- Input Project Name or Task Requirements\u003cbr\u003e- The system will then show where there is overallocation of a resource, or if a task does not have enough Resource.\u003c\/p\u003e\n\u003cp\u003eFeatures:\u003cbr\u003e- Visual Allocation: Easily assign tasks to resources and track their availability in real-time.\u003cbr\u003e- Highlight Resource: Quickly identify resource availability for specific tasks using the \"Highlight a resource\" function.\u003cbr\u003e- Red Flag System: Flag potential resource shortages with color-coded alerts.\u003cbr\u003e- Pick up the period you want: Days, Weeks or Months. There are 52 periods included.\u003c\/p\u003e\n\u003cp\u003eTutorial Video:\u003cbr\u003ehttps:\/\/youtu.be\/KC8ztMoPT9s\u003c\/p\u003e\n\u003cp\u003e✅𝙒𝙝𝙖𝙩'𝙨 𝙞𝙣𝙘𝙡𝙪𝙙𝙚𝙙\u003cbr\u003e1 Microsoft EXCEL Spreadsheet fully Accessible (𝗘𝘅𝗰𝗲𝗹 𝟮𝟬𝟮𝟭 𝗼𝗿 𝗘𝘅𝗰𝗲𝗹 𝟯𝟲𝟱 𝗥𝗲𝗾𝘂𝗶𝗿𝗲𝗱)\u003cbr\u003e1 Project Management Bundle including 3 Spreadsheet (See item description)\u003c\/p\u003e\n\u003cp\u003e✅𝙄𝙣𝙨𝙩𝙧𝙪𝙘𝙩𝙞𝙤𝙣𝙨\u003cbr\u003eThe Excel is not difficult to use, but I provide some basic instructions on how to use the Spreadsheet. \u003c\/p\u003e\n\u003cp\u003e✅𝙎𝙪𝙥𝙥𝙤𝙧𝙩\u003cbr\u003eYou get my full support with your purchase. I will provide you with my email address to enable you to contact me directly.\u003c\/p\u003e\n\u003cp\u003eFULL INSTRUCTIONS:\u003c\/p\u003e\n\u003cp\u003eGETTING STARTED\u003cbr\u003e- As a rough rule, only cells with a very pale yellow can be updated. \u003cbr\u003e- The only exception if for the 52 periods. You need to change this on the Task Tab. \u003cbr\u003e- Periods can obviously be whatever you choose (Days, weeks, Months).\u003cbr\u003e- Do not change the Period in the Resources tab, as the period there gets picked up from the Tasks tab.\u003c\/p\u003e\n\u003cp\u003eRESOURCING\u003cbr\u003e1. in the Resources tab, input the Name and weekly availability of your resources n the Table. 100% means fully available for the week.\u003cbr\u003eThe Resource table duplicated will show you Resource availability AFTER allocation.\u003c\/p\u003e\n\u003cp\u003eTASKS\u003cbr\u003e2. In the Tasks tab, input your project and task names and select the Resource for that task. \u003cbr\u003e(Input\/Select NR if no resource is Required)\u003c\/p\u003e\n\u003cp\u003e- You can then input the Requirements for that task each week. 100% means that task needs one resource full time for that week.\u003cbr\u003e- If a task requires more than one resource, you need to enter that task twice and allocate a resource for each line.\u003cbr\u003e- If a percentage is showing in red, it means the task does not have enough resource for that period and resource.\u003cbr\u003e- When there is a red man showing, it just means there is not enough resource for that task (and the amount of periods without sufficient resource is showing in the next column.\u003cbr\u003e- If you want to highlight a resource on the Task list you can use the \"Highlight a resource\" function in blue and select a resource.\u003c\/p\u003e\n\u003cp\u003eNOTES\u003c\/p\u003e\n\u003cp\u003e-  You can add more Tasks and resources by clicking on the + sign in the margin\u003c\/p\u003e","brand":"Blue Tiger Systems","offers":[{"title":"Default Title","offer_id":53462331031884,"sku":"RES09_Tmp108","price":14.67,"currency_code":"EUR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0980\/0345\/2236\/files\/capacity-planning-excel-resource-allocation.jpg?v=1778814711","url":"https:\/\/www.bluetigersystems.com\/products\/excel-resource-planning-and-allocation-system-for-up-to-10-projects","provider":"Blue Tiger Systems","version":"1.0","type":"link"}