Question 1

Create a new checklist template

Accepted Answer

When you have opened the Template-center you should see a view like the one below.

You can navigate between the Public, Company-shared and Private templates in the different menus.

Template area

Create a new template

Hit the "Add Template"-button and specify a name for the template and optional also a category.

The example below creates a ventilation template:

Structure of checklist template

You have multiple options to customize and edit your templates. The screenshot below shows some of the menus, and below the screenshot, the individual menus are explained.

| Area | Description | | ---- | | 1) Information | The information area let's you specify the name and category. These informations are used to identify the template. | | 2) Visibility | It's in this box you can specify who can see and edit the template. It will as standard always be set as Private, but you can just change that to be shared with your company. | | 3) Availability | Your template will as default be available on all the projects, you are working on. You can limit the availability to specific projects. | | 4) Other | Various ways of importing items to the checklist - either from other templates, from Exce

Question 2

Bulk import and updating of checklists with Excel

Accepted Answer

CxPlanner provides seamless bi-directional synchronization with Excel spreadsheets. This makes it very easy to input data into the platform upfront and update it during the project.

For working with import/export functionality you just need to use CxPlanner's spreadsheet template - more info on that in this article.

Bulk import menu

To access the "Bulk-import" area and upload a file just follow the two (2) screenshots below. Be sure to read the whole article on the format requirements before uploading a file.

|| You must be either a Manager or Admin on the project

Access the menu Access the import area

Upload the file Bulk upload

The spreadsheet template

To import you need to use CxPlanner's spreadsheet template. You can download it during the import process (see the picture above) or just click on the Menu-button and select download overview.

This spreadsheet includes many different options and utilities for you. But the three (3) core items you must know are: | Column | Required | Must have data | Info | | --- | --- | --- | | ID | True | False | The ID column holds a unique reference to the item inside CxPlanner. That means, if you update this row and re-import the spreadsheet we will update the item for you inside CxPlanner. If there's no value present in the ID-column we will cr

Question 3

Create a custom report

Accepted Answer

In our reporting module, you can create and customize reports. You can include information, graphs, and files, making it easy to create general documents like quality assurance and progress reports. You can also generate specific reports, such as the final Cx reports according to ASHRAE Guideline 0, ASHRAE Standard 202 and LEED certifications.

In reports, you have the flexibility to choose the content, which can range from lengthy documents to graphs displaying the number of open tasks.

Create Your First Report

You can create new reports in several ways. The easiest method is to "Add a new one" - you can use method (2) below.

Access the reporting module in the sidebar (if you can't see the button, you need to activate the module for the project).
Add an entirely new report.
Import a report from your company's Template Center.
Open an existing report.
Copy/clone an existing report.

Reports overview

Structure of a Report

The report builder is divided into several main areas:

Report Details: This includes the name and category of the report. It is not used in the final report.
Cover Page: Front page information - customize the title, subtitle, and info boxes.
Custom Content: In this area, you can write and format your own text.
CxPlanner Elements: This is the drag-and-drop section. Customize the design, graphs, charts, and other cool conte

Question 4

Import checklist from Excel to the template center

Accepted Answer

You easily import your existing checklist and test sheets into CxPlanner's structure.

Use the method below or contact our support-team, who will do the importing for you directly!

Import yourself

Click on the "Import from XLSX (Excel)" button:

Import XLSX button

Download the Excel template converter

In the popup box select the "Download template". This file will let you convert your existing spreadsheets into a format, which CxPlanner can import.

Download import template

Insert / copy your data into the template file

The screenshot below shows two items. It's only required to use the "Topic/Heading" and the "Test item" fields.

When you have inserted your data just copy the result from the green column (to the right) into CxPlanner.

|| The data you shall copy is located at far right. You might need to scroll to the right to find the column. The cells are highlighted with a green color.

Simple import

(You can hide/show the advanced field with the plus/minus buttons)

Simple import view

Advanced import

1 - Required fields

These fields must be used. Set the topic

Question 5

Advance import checklists or test items

Accepted Answer

|| Read the article "Bulk import" first

Advance import checklist or test items

This articles describes how you can specify an "Asset- or Equiptment"-type and attach multiple checklists to it.

When adding new items marked with the "Asset- or Equiptment"-type, the checklists will automatically be imported.

${frame}CxPlanner video demo

The two import-types

There are two ways to attach checklists:

Sub-checklists: This way the attached checklists will be added as sub-checklists and change the item to a "folder".
Checklist items: This way the checklists items will added.

Sub-checklist

When you create a new checklist, you can choose to auto add multiple sub-checklist to it.

E.g. you can create an asset called 'Ventilation' and attach multiple sub-checklists to it, for example Mechanical complete, Functional check and System integration test. This will automatically add 3 sub-checklists to this asset.

It will then get this structure:

Ventilation

Mechanical complete
Functional check
System integration test

Sub-checklist example

Checklist items

Define an asset/equiptment type, and then attach one or more checklists to it.

When you create a new asset/equiptment of that type, the items from those checklists will be automatically imported.

E.g. you can create an asset calle

Question 6

Find the template center for checklists

Accepted Answer

Hit the ground running with your own Template-center, where you can manage all of your checklists and test sheets.

The Template-center let's you either create your own checklists and test sheets, or use CxPlanner's default templates.

What can you do in the Template-center

There multiple ways to work with templates, but the main ways are:

Create personal templates you use own your own projects
Share templates with your company and streamline your workflows
Import your Excel XLSX checklist and test sheets into CxPlanner

Different kind of templates

You can create multiple different templates to use on your projects. It depends on your company-profile which templates you have access to.

The basic templates are:

Project templates (for full project setup)
Checklists and test sheets
Folder structures in the file-module

|| You are required to have a real company-profile to access the Template-center. Contact support if you can't find it.

|| The examples below can vary depending on which modules there are enabled on your company-profile.

Template area

You can access the Template-center in the sidebar, when you are on your main dashboard:

Navigate to the Template-center:

Template-center in sidebar

Find the template in one of the menus:

![Checklist-area (private, company and public templates)](https://storage.crisp.chat/users/helpdesk

Frequently Read Articles

Browse All Categories