{"product_id":"project-and-task-tracker","title":"Project and Task Tracker","description":"\u003cp\u003eThis workbook holds personal information about your team, such as names, emails and phone numbers. Look after it: share it only with those who need it and keep it somewhere protected. It has no columns for bank, identity or tax identifier details, so please do not type them into Notes either.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eThe problem.\u003c\/strong\u003e Projects live in one list, tasks in another, and the dates that matter in someone's head. Nobody has one clear view of which tasks are overdue, how many hours have gone against the estimate, who is carrying the most work or which milestone is next.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat this does.\u003c\/strong\u003e You keep one list of projects, one of tasks, one of people and one of milestones. You type your own due dates, status words and hours. The workbook works out what is overdue or due soon, compares hours used with hours estimated, counts the work for each person and shows the milestones coming up.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you can do with it\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eSee tasks overdue, open tasks and tasks over their hours estimate.\u003c\/li\u003e\n\u003cli\u003eSee projects by status, with overdue and due soon counts, as a table and a bar chart.\u003c\/li\u003e\n\u003cli\u003eSee tasks by status, with hours estimated and hours used, as a table and a bar chart.\u003c\/li\u003e\n\u003cli\u003eSee tasks and hours for each person, and hours for each project.\u003c\/li\u003e\n\u003cli\u003eSee milestones overdue, due in your window and still to come.\u003c\/li\u003e\n\u003cli\u003eType your own status words, finished statuses and windows on Settings. Nothing is built in as a rule.\u003c\/li\u003e\n\u003cli\u003eChoose your industry (Agency, Construction or General office) to load suitable project type, task type and role lists, then edit them to suit you.\u003c\/li\u003e\n\u003cli\u003eKeep your records in a clear structure: a Data Dictionary explains every column, and four export sheets repeat your projects, tasks, people and milestones under plain field names.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eHow it works\u003c\/strong\u003e\u003c\/p\u003e\u003col\u003e\n\u003cli\u003eEnter your business name, choose your industry, and type your own status words and windows on Settings.\u003c\/li\u003e\n\u003cli\u003eAdd your people, then projects, tasks and milestones.\u003c\/li\u003e\n\u003cli\u003eCheck the dashboard.\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cstrong\u003eWho it is for.\u003c\/strong\u003e Small teams, studios, sole traders and anyone who manages work from a list and wants to see progress, hours and milestones in one place.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is not for.\u003c\/strong\u003e Anyone who needs a Gantt chart, task dependencies or a timesheet. This is a simple status view: nothing is sent, posted or connected to anything else.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you need.\u003c\/strong\u003e Microsoft Excel 2016 or later. It was tested in Excel for Windows. No macros, no add-ins and no subscription.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eGood to know\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e200 project, 1,000 task, 100 people and 400 milestone rows are ready, and you can add more by dragging the last row down.\u003c\/li\u003e\n\u003cli\u003eHours used is a number you type; quarter hours such as 0.25 work.\u003c\/li\u003e\n\u003cli\u003eAn example copy with a made-up studio shows every sheet working before you start.\u003c\/li\u003e\n\u003cli\u003eNothing is locked or password protected.\u003c\/li\u003e\n\u003cli\u003eUse this template to capture and improve your business data now. In future you can automate with AI.\u003c\/li\u003e\n\u003cli\u003eThis workbook is a record-keeping tool and general information only. It is not professional advice. General information only. It is not accounting, tax, legal or financial advice.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"TeleWorld Online","offers":[{"title":"Default Title","offer_id":48859262484685,"sku":null,"price":29.0,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0652\/1031\/9053\/files\/01-cover_d319f924-3d24-4a47-9688-dbe4ae6dfee8.png?v=1795097268","url":"https:\/\/www.teleworld.online\/it\/products\/project-and-task-tracker","provider":"TeleWorld Online","version":"1.0","type":"link"}