Ganttwright

Schedules for Primavera P6

Build P6 schedules inside Excel, step by step.

Ganttwright adds its own tab and panel to Excel. Your company’s dictionary and the bill of quantities become the WBS, activities, resources, costs and logic of a schedule, written straight into P6. P6 works out the dates.

Ganttwright in Excel An Excel workbook with the WBS drawn as coloured bands, a level each, and the Ganttwright panel beside it, connected to a P6 database, with a Send to P6 button. Home Insert Data Review Ganttwright Level Code WBS name 1 P01 Tower project 2 B01 Building 01 3 GF Ground floor 4 CON Concrete B01.GF.CON.1000 Pour concrete slab 5 d B01.GF.CON.1010 Cure slab 7 d 4 FIN Finishes 5 FLR Flooring 3 1F First floor 2 B02 Building 02 ▾ ▾ ▾ Ganttwright P6 DATABASE Site PC · Project 2 Connected Project P01 · Tower project Build Check 1 Dictionaries 2 WBS 3 Activities from the BOQ 4 Resources 5 Relationships Send 54 to P6 Preview

How it works

Six steps, on the workbook’s own sheets.

Each step is a sheet you can read and change like any other. Ganttwright checks every cell as you go, and shows where a problem is.

  1. 1

    Dictionaries

    Your company’s standard activities, resources, activity codes and WBS trade codes, kept once and used on every project.

    Activities · Resources
  2. 2

    WBS

    Project, buildings, floors and trades, a coloured band a level, to any depth. Add, indent and fold with a click.

    P6 WBS
  3. 3

    Activities from the BOQ

    Spread each bill of quantities line over buildings and floors, with quantity and cost weights that must each make 100%.

    BOQ · Mapping
  4. 4

    Resources

    Each activity’s labour, equipment and materials, filled from the dictionary, with a number for each.

    P6 Resources
  5. 5

    Relationships

    The dictionary’s successors become links for every building and floor. Type the links between floors yourself.

    P6 Schedule
  6. 6

    Check, then send to P6

    Loops, missing predecessors and open ends are found first. Send lists everything it will write; a second press writes it.

Into P6

Straight into P6, with P6 still open.

  • A small connector beside P6It runs on the PC where P6 Professional keeps its database, finds the databases P6 knows, and writes what you send.
  • A backup first, then all at onceThe database is copied before every send, and the changes go in one transaction: all of them, or none.
  • P6’s own changes are respectedWhat changed in P6 meanwhile is taken in before a send, and anything both sides changed is shown, never overwritten.
  • XER files when you need themWithout a connector, Ganttwright writes an XER file built on P6’s own export, changing only what you changed.

A send, from start to finish

What happens when you press Send to P6 in the panel.

  1. 1Ganttwright lists every activity, level, resource, cost and link it will add or change.
  2. 2You press Send again. The connector reads the project from P6 and takes in P6’s own changes.
  3. 3It copies the database, then writes everything in one transaction.
  4. 4In P6, press F5 to see the changes and F9 to work out the dates.

Get started

Set up in a few minutes, on your own PC.

No IT department and no administrator rights. Ganttwright is added to Excel for you alone, and taken out again just as easily.

  1. Sign in with your emailA code arrives by email; there is no password to remember.
  2. Run the Excel setupDownload it from the Excel page in Ganttwright and run it once.
  3. Open the Ganttwright workbookExcel shows the Ganttwright tab and panel. Connect to your P6 database and open a project.

Trial and licence

Try it, then buy a licence.

Free for a month

  • One month, starting when you open your organisation
  • Up to 3 people who can edit, viewers are free
  • Up to 3 projects
  • Everything included
  • No card needed

After the trial the organisation is read-only until a licence key is bought.

Start a free trial

Then a licence

A licence key opens or renews your organisation for the plan, seats and months it was issued for.

Have a key? Activate it

To buy one, write to us at sales@ganttwright.com