Projects

The Projects page lists the projects by program: programs by name, then the projects of each program by their dates. Projects without a program come last, under “No program”. Each row shows the project’s type, status, priority, start, finish, the number of its roles, its hours and its budget.
- Hours: the hours assigned to the project’s roles against the hours planned, with a donut. The hours are orange when more is assigned than planned.
- Budget: the cost of the project’s assignments in the base currency. The column is shown while Show budget is on in Settings → General.
- + in the list header adds a project; the pencil opens it, and the cross deletes it.
- Expand all or Collapse all, one button, opens or closes the programs.
- Show inactive also lists the projects whose Active box is cleared.
- The menu of the Project column sorts the projects by name within each program and filters them by name.
Deleting a project also deletes its roles, assignments and milestones. They go to the site recycle bin.
Excel export and import
The two buttons at the right of the Projects bar export the portfolio to Excel and import it from Excel. Both run in your browser with your own SharePoint permissions; the file is not sent to Virto’s server.
- Export to Excel is there for everyone. It downloads
Portfolio <date>.xlsxwith a sheet for each kind of item: Projects, Plan (roles and assignments), Milestones, Resources, the days off of resources and calendars, Calendars and each dictionary. Items refer to each other by name, so a file can be filled in by hand or brought to another site. - Import from Excel is there for people who may add or edit projects. Choose a file, and the app first shows what the import will do: how many items of each kind are new, updated or replaced. Nothing is written until you select Import.
How the import works:
- An item whose name is already in the portfolio is updated; a new name adds an item. Items the file does not name are left as they are.
- A column the file leaves out keeps its values; an empty cell clears the value.
- Programs, roles, departments, locations, skills, project types, statuses and priorities that the file uses and the portfolio does not have yet are added.
- The roles, assignments, milestones and days off of the items in the file are replaced by those of the file. The old ones go to the site recycle bin.
- The file is checked before anything is written: names, dates, numbers and their ranges, e-mail addresses, statuses and priorities allowed for the project type, one resource per person, and your permissions. Any problem stops the import, and the app lists the problems by sheet and row.
- If some changes cannot be saved, the app lists them; the rest of the import stays, and the portfolio is reloaded.
Demo data
While the portfolio has no projects, the Projects page offers Load demo data to people who may add projects. It opens the same import preview with a demo portfolio: 5 projects in 2 programs, 8 fictional resources, calendars, roles, assignments, milestones and days off. Its dates are moved to the current week, so there is work done, in progress and planned. Costs in euros and pounds use fixed rates to US dollars, so they are only an example on a site with another base currency. Delete the demo projects when you are done.