Create Excel look-aheads and schedules from a schedule

Excel made from a schedule: a look-ahead for the field, or the whole schedule as a sheet.

Running time 1:12CaptionedNo account needed to watchVideo 9 of 15

All fifteen how-to videos

Ninth of fifteen in the series, in Look-aheads, the Gantt and files. Each mark’s length is its running time.

TRANSCRIPTEvery word of the video, as text.

Making Excel from a schedule on PC.o: a look-ahead for the field, or the whole schedule as a sheet. The Guide approves of round trips.

Open the schedule in the Gantt viewer. Export holds Look Ahead and Excel Gantt. Look Ahead first. Choose the dates the field should see, any custom fields to carry, and Download. Simplicity itself.

PC.o's own template, with the activity ids inside. Upload it back and it comes in as a look-ahead. The editor paints the week grid, D per work day. Choose Character for letters; Schedule ID matches later.

Excel Gantt exports the whole schedule as one sheet. Whatever the viewer shows, the filters do not travel. Upload that, and PC.o reads it as an Excel schedule: mappable, viewable, convertible. Never analysed.

A look-ahead's own menu keeps View Excel: the workbook as it was uploaded, for a quick look. The sheet, as sent to the field. Round trip complete. Satisfying.

That was Excel from a schedule. Next in the Guide: exporting a schedule to another format, and cleaning it on the way.

Taken from the video’s English captions.

THE SERIESAll fifteen, in order, 28 min 41 s end to end.

  1. 1What PC.o does, in five minutesRunning time 4:32
  2. 2Registering with PC.oRunning time 1:54
  3. 3Upload a schedule and read its analysisRunning time 2:22
  4. 4Compare two schedulesRunning time 2:02
  5. 5Import Excel files: look-aheads and schedulesRunning time 1:57
  6. 6Compare two look-aheadsRunning time 1:19
  7. 7Compare one or many look-aheads with a scheduleRunning time 2:02
  8. 8The Gantt viewer: view and shareRunning time 1:44
  9. 9Create Excel look-aheads and schedules from a scheduleWatchingRunning time 1:12
  10. 10Export a schedule: Convert/CleanRunning time 1:30
  11. 11Build a custom reportRunning time 2:06
  12. 12A team plan for your groupRunning time 1:44
  13. 13Share a report, a folder, a linkRunning time 1:35
  14. 14Your account pageRunning time 1:04
  15. 15Trends and cashflowRunning time 1:38
Getting startedLook-aheads, the Gantt and filesReports and sharing Minutes, end to end: 28 min 41 s
Register and try us for free for 30 days.Register