Having a long list of items to be evaluated, adding them manually piece-by piece, formatting each to a uniform HTML layout, maybe even in more languages, can be a pretty monotone and time consuming task. A more creative and efficient way is to set up the Enquette on the desktop machine and then upload it, more or less ready-to-use, on the server. A downloaded Excel Enquette offers the appropriate base.

Suppose we have a list of employees with First name, Last name and Position like this:

They are to be evaluated in a poll on criteria like Friendly, Dynamic and Reliable.

Suppose further, there are photographs uploaded on the server in the directory /images/company/employees, each named uniformly by [FirstName].[LastName].jpg.

An exigent task is to design the Layer Items (Questions). Lets create the Enquette on the server, design just one Item for one person as a template (remember, the Enquette Prefix enables specific CSS definitions) and then download the Enquette as Excel XML. On the Items worksheet, you will find something like this (emploee specific parts marked red):

Now, add new worksheet named Employees and copy the employees list there. Then, on the Items worksheet, edit the H2 text as a formula, substituting emphasized text parts by references to Employees worksheet (marked blue). Remember that in formulas, the literal quote character " must be escaped as "":

After you have entered the formula and hit Enter, the text in H2 should look exactly the same as the downloaded one. Just when selecting the cell, you see the formula in the Excel's f_x field.

Finally, copy the Item row downwards corresponding to Employees worksheet rows count. For new items, set negative item_id like -1, -2 ... (as positive IDs could eventually rewrite existing records). The worksheet could look like this (again, employee specific parts marked red):

The rest of settings, like Evaluation Criteria etc., is easier to manage on the Enquette administration direct. Or see Setting up Evaluation Criteria how to create it with the Excel Enquette.

When ready, save the file and upload it to the Enquette site back as an Update. Manage other settings, save the Enquette and open it in the front end. It could look like this: