Half Price Budget Sheet

 

Gantt-Chart-Excel-1

Hey, thanks for visiting this page! If you are here, it means that you have a copy of my book in your hands / on your Kindle and are curious about my budget sheet.

As promised, this version comes with a 50% discount compared to the regular one. This is my way to thank you for reading my book and trusting my methods.

Professional
9,95
Best value
For Medium to Large Projects
50% off the regular price of 19,90
Fixed Structure
Fixed Colours
52-months/weeks Gantt
Up to 27 partners
Up to 10 work packages
Up to 100 Tasks
No Excel Skills required
Sent within 1 Hour
Extended
19,95
The full monty
For very complex projects
50% off the regular price of 39,90
Adaptable structure
Adaptable Colours
Unlimited months/weeks
Unlimited partners
Unlimited work packages
Unlimited tasks
Requires Excel & VBA skills
Sent within 1 Hour
Upgrade
10
Professional to Extended
If you realise you need flexibility
50% off the regular price of 20
Upgrade from the Professional to the Extended plan.
This is the password to unlock all spreadsheets
Sent within 1 Hour

You have a pretty solid description in the book itself, so I won’t go into an in-depth description of what it can or cannot do. You could still find the youtube walkthrough interesting.

All I’d ask is that you don’t share this page around. I’d rather keep it only for the inner circle of people who decided to buy my book, thanks!

What you could do, if you’d like, is share it using the buttons at the end of the page: they redirect to the full-price page 😉

And either way, thank you for your trust in me, it means a lot!

Edoardo

Features:

 

– A Gantt Chart functionality made to fit up to 100 tasks for a project

Heat maps on the Gantt chart to monitor workload for each Work Package or for the whole project

Full integration of project and task timing with their budget and staff allocations

– Capability to integrate up to 27 partners in a project, not including subcontractors

– Selection of up to six different staff categories per partner, with different daily / hourly rate allocations, for each one of the 100 tasks

Separate worksheets for Travel Costs, Subcontracts and Other Costs

A simple, field-tested and flexible interface for managing details or having an overview of the project

Immediate to use, even with limited knowledge of Excel

 

__________________________

The sheet is available in two versions. Select yours now!

 

Professional
9,95
Best value
For Medium to Large Projects
50% off the regular price of 19,90
Fixed Structure
Fixed Colours
52-months/weeks Gantt
Up to 27 partners
Up to 10 work packages
Up to 100 Tasks
No Excel Skills required
Sent within 1 Hour
Extended
19,95
The full monty
For very complex projects
50% off the regular price of 39,90
Adaptable structure
Adaptable Colours
Unlimited months/weeks
Unlimited partners
Unlimited work packages
Unlimited tasks
Requires Excel & VBA skills
Sent within 1 Hour
Upgrade
10
Professional to Extended
If you realise you need flexibility
50% off the regular price of 20
Upgrade from the Professional to the Extended plan.
This is the password to unlock all spreadsheets
Sent within 1 Hour

Let’s have a look at the Gantt chart structure below…

 

Gantt Chart Sheet 1: Plan

 

Part 1: the Gantt Chart

 

This is the starting point: here you can outline your tasks and decide how much they will take.

But that is not all…

See the multi-coloured bar in the WP line? That is a heatmap telling you how much workload you have at the same time.

In other words, this tells you how many tasks you have going on in a single work package in parallel, and therefore how heavy the workload is going to be.

Gantt-Chart-Excel-2 

 

The line at the bottom tells you how heavy or light the workload is going to be based on what you are working on. If you group all the rows, you’ll have an indication of the workload per work package or for the whole project.

 

 

Part 2: hours allocation according to the Gantt chart.

Gantt-Chart-Excel-4

Once you have planned how long your project will take, you can tell Excel how many hours or days your staff (1, 2, 3 people) needs to work on any given task.

Say one task needs 1 month of time with 4 people working on it full time (4 person-months). You can tell my Gantt template both of those values, and use them together in the same file.

 Gantt-Chart-Excel-3

 

Gantt Chart Sheet 2: Staff Allocations

Once you established the Gantt and the workload. You can use this Excel chart to allocate the hours among your staff.

Say, for example, that you need to split 100 hours: you can give 10 to the CEO with an hourly rate of 150€ and 90 to a consultant with a rate of 87€.

This Excel sheet allows you to precisely determine the costs of who is going to work where.

Take a look at the screenshot below.

 

Gantt-Chart-Excel-7

 

And if you just need an overview of the total budget per partner, you can group the columns and obtain this view.

Gantt-Chart-Excel-8

 

_______________________

Select your version of this Excel Gantt Chart:

 

Professional
9,95
Best value
For Medium to Large Projects
50% off the regular price of 19,90
Fixed Structure
Fixed Colours
52-months/weeks Gantt
Up to 27 partners
Up to 10 work packages
Up to 100 Tasks
No Excel Skills required
Sent within 1 Hour
Extended
19,95
The full monty
For very complex projects
50% off the regular price of 39,90
Adaptable structure
Adaptable Colours
Unlimited months/weeks
Unlimited partners
Unlimited work packages
Unlimited tasks
Requires Excel & VBA skills
Sent within 1 Hour
Upgrade
10
Professional to Extended
If you realise you need flexibility
50% off the regular price of 20
Upgrade from the Professional to the Extended plan.
This is the password to unlock all spreadsheets
Sent within 1 Hour

Gantt Chart Sheets 3 to 6: External costs

 

 For any other cost that you need to add on to your staff costs (Travel, Subcontract, Other), you have three dedicated worksheets in the Gantt chart template.

All of them are coordinated with the names of the partners and of the work packages.

Gantt-Chart-Excel-10

 

Gantt Chart Sheet 7: Summary

 

The last sheet is a table summarising all results.

 Gantt Chart 11

_______________

This is the single most budget integrated Gantt chart available for Excel in its category, choose your version right now.

 

Professional
9,95
Best value
For Medium to Large Projects
50% off the regular price of 19,90
Fixed Structure
Fixed Colours
52-months/weeks Gantt
Up to 27 partners
Up to 10 work packages
Up to 100 Tasks
No Excel Skills required
Sent within 1 Hour
Extended
19,95
The full monty
For very complex projects
50% off the regular price of 39,90
Adaptable structure
Adaptable Colours
Unlimited months/weeks
Unlimited partners
Unlimited work packages
Unlimited tasks
Requires Excel & VBA skills
Sent within 1 Hour
Upgrade
10
Professional to Extended
If you realise you need flexibility
50% off the regular price of 20
Upgrade from the Professional to the Extended plan.
This is the password to unlock all spreadsheets
Sent within 1 Hour

 

 

Facebook Twitter Google Digg Reddit LinkedIn StumbleUpon Email