WEBVTT

1
00:00:01.000 --> 00:00:02.509
Import a spreadsheet.

2
00:00:03.270 --> 00:00:05.827
Already have a schedule in a spreadsheet?

3
00:00:06.014 --> 00:00:08.057
Import it onto the project.

4
00:00:08.057 --> 00:00:10.603
Start from the template, or bring your own.

5
00:00:10.820 --> 00:00:16.741
One item per row: the number, area, name and quantity, and anything else you have.

6
00:00:16.741 --> 00:00:19.696
An area the project lacks becomes a new one.

7
00:00:19.800 --> 00:00:25.868
Bring it in three ways: upload the file, paste a link to the sheet online, or paste its cells.

8
00:00:26.014 --> 00:00:31.352
Pasted cells need no sharing, good for a private sheet; pictures in cells don’t come across.

9
00:00:31.480 --> 00:00:38.990
A link can be to a Google Sheet, or an Excel workbook on OneDrive or SharePoint, shared so anyone with the link can view it.

10
00:00:39.165 --> 00:00:42.592
Read it, and it shows how every column is read.

11
00:00:42.799 --> 00:00:47.351
The template is read as it is; your own layout is read with AI.

12
00:00:47.472 --> 00:00:53.163
Preview lists every change it would make: new items, new areas, new people for the address book.

13
00:00:53.242 --> 00:00:56.064
Nothing is written until you import.

14
00:00:56.280 --> 00:00:59.022
A maker’s contact goes into your address book.

15
00:00:59.043 --> 00:01:02.537
People already there are matched, not added twice.

16
00:01:02.682 --> 00:01:04.507
Import, and it’s done.

17
00:01:04.633 --> 00:01:10.045
Every import is listed underneath, and for thirty days, Undo this import takes it back.

18
00:01:10.270 --> 00:01:19.094
And here’s the new spa on the specification list: five items, with makers, quantities and prices, ready to finish specifying.

19
00:01:19.310 --> 00:01:21.588
An import from a link keeps it.

20
00:01:21.644 --> 00:01:25.837
When the sheet changes, Import again from the link fetches the latest,

21
00:01:25.854 --> 00:01:31.010
and the preview shows what changed, row by row, before anything is written.

22
00:01:31.164 --> 00:01:32.372
That’s an import.

23
00:01:32.372 --> 00:01:36.986
More videos: portspace.io/videos