Warning, /office/calligraplan/doc/creatingodtreporttemplates.docbook is written in an unsupported language. File is not indexed.
0001 <sect2><title/> 0002 <sect3 id="description1"><title>Description</title> 0003 <para>Open Document Text report templates are regular ODT files that can be designed using any ODT word processor like <emphasis>Calligra Words</emphasis> or <emphasis>LibreOffice Writer</emphasis>. The technique used is to use <emphasis>user field</emphasis> variables to hold references to the information that shall be fetched from the project. The variables are called <emphasis>User Fields</emphasis> in <emphasis>Writer</emphasis> and can be found under <menuchoice><guimenu>Insert</guimenu><guisubmenu>Field</guisubmenu><guimenuitem>More Fields</guimenuitem><guimenuitem>Variables</guimenuitem><guimenuitem>User Fields</guimenuitem></menuchoice>. In <emphasis>Words</emphasis> they are called <emphasis>Custom Variables</emphasis> and can be found under <menuchoice><guimenu>Text Editing docker</guimenu><guisubmenu>Variable</guisubmenu><guimenuitem>Custom</guimenuitem></menuchoice>. 0004 </para> 0005 <para>The easiest way to create a new report template is to modify an existing one as all user fields are defined. 0006 </para> 0007 </sect3> 0008 <sect3 id="user-field-variables"><title>User Field Variables</title> 0009 <sect4 id="variables"><title>Variables</title> 0010 <para>The variables are used to enable the generator to extract data from the project. 0011 </para> 0012 <para>A variable can be a reference to a single data field, a reference to table data or a reference to chart data. 0013 </para> 0014 <sect5><title>Single Data Field</title> 0015 <para>A single data field variable has the following format: 0016 </para> 0017 <para><replaceable>data group name</replaceable>.<replaceable>property</replaceable> = <replaceable>property identifier</replaceable> 0018 </para> 0019 <para>where: 0020 </para> 0021 <itemizedlist> 0022 <listitem><para><replaceable>data group name</replaceable> can be tr, project or schedule (see below).</para></listitem> 0023 <listitem><para><replaceable>property</replaceable> makes the user field name unique.</para></listitem> 0024 <listitem><para><replaceable>property identity</replaceable> identifies the property in the data group.</para></listitem> 0025 </itemizedlist> 0026 </sect5> 0027 <sect5><title>Table Data</title> 0028 <para>A table in a report template consists of a variable to specify the data table to use. 0029 </para> 0030 <para>The variable name must start with <replaceable>table</replaceable> (⪚ tableTasks) and the variable value must be the name of the data table (⪚ tasks). 0031 </para> 0032 <para>Immediately after the variable, a table must be inserted and columns filled with user field variables that specify which properties to fetch from the table specified above. These variables must have names that start with the name of the table variable above. 0033 </para> 0034 <para>These variables have the following format: 0035 </para> 0036 <para>tableTasks.<replaceable>property</replaceable> = <replaceable>property identifier</replaceable> 0037 </para> 0038 <para>where: 0039 </para> 0040 <itemizedlist> 0041 <listitem><para><guilabel>property</guilabel> makes the user field name unique.</para></listitem> 0042 <listitem><para><guilabel>property identifier</guilabel> identifies the property in the data group.</para></listitem> 0043 </itemizedlist> 0044 </sect5> 0045 <sect5><title>Chart Data</title> 0046 <para>A chart in a report template consists of a variable to specify the data to use in the chart. 0047 </para> 0048 <para>The variable name must start with <replaceable>chart</replaceable> (⪚ chartBudgetCost) and the variable value specifies the data group and values to populate the chart. 0049 </para> 0050 <para>The variable has the following format (note the semicolons): 0051 </para> 0052 <para><replaceable>name</replaceable> = <replaceable>data group</replaceable>; values=<replaceable>comma separated list of data properties</replaceable>; 0053 </para> 0054 <para>where: 0055 </para> 0056 <itemizedlist> 0057 <listitem><para><replaceable>name</replaceable> must start with <guilabel>chart</guilabel> (⪚ chartBudgetCost)</para></listitem> 0058 <listitem><para><replaceable>data group</replaceable></para></listitem> 0059 <listitem><para><guilabel>comma separated list of data properties</guilabel> identifies the properties in the data group.</para></listitem> 0060 </itemizedlist> 0061 <para>E.g.: 0062 </para> 0063 <para>chartBudget = project; values=bcws cost, bcwp cost, acwp cost; 0064 </para> 0065 </sect5> 0066 </sect4> 0067 <sect4 id="translated-labels"><title>Translated Labels</title> 0068 <para>Translated labels enable us to produce general report templates that can be used in different languages. 0069 </para> 0070 <para> 0071 <informaltable> 0072 <tgroup cols="2"> 0073 <thead> 0074 <row> 0075 <entry><guilabel>Variable Name</guilabel></entry> 0076 <entry><guilabel>Variable Value</guilabel></entry> 0077 </row> 0078 </thead> 0079 <tbody> 0080 <row> 0081 <entry> 0082 <para>tr.project</para> 0083 </entry> 0084 <entry> 0085 <para>Project</para> 0086 </entry> 0087 </row> 0088 <row> 0089 <entry> 0090 <para>tr.manager</para> 0091 </entry> 0092 <entry> 0093 <para>Manager</para> 0094 </entry> 0095 </row> 0096 <row> 0097 <entry> 0098 <para>tr.schedule</para> 0099 </entry> 0100 <entry> 0101 <para>Schedule</para> 0102 </entry> 0103 </row> 0104 <row> 0105 <entry> 0106 <para>tr.bcws</para> 0107 </entry> 0108 <entry> 0109 <para>BCWS</para> 0110 </entry> 0111 </row> 0112 <row> 0113 <entry> 0114 <para>tr.bcwp</para> 0115 </entry> 0116 <entry> 0117 <para>BCWP</para> 0118 </entry> 0119 </row> 0120 <row> 0121 <entry> 0122 <para>tr.acwp</para> 0123 </entry> 0124 <entry> 0125 <para>ACWP</para> 0126 </entry> 0127 </row> 0128 <row> 0129 <entry> 0130 <para>tr.spi</para> 0131 </entry> 0132 <entry> 0133 <para>SPI</para> 0134 </entry> 0135 </row> 0136 <row> 0137 <entry> 0138 <para>tr.cpi</para> 0139 </entry> 0140 <entry> 0141 <para>CPI</para></entry> 0142 </row> 0143 </tbody> 0144 </tgroup> 0145 </informaltable> 0146 </para> 0147 </sect4> 0148 <sect4 id="project-values"><title>Project Values</title> 0149 <para>Shows values from the main project. 0150 </para> 0151 <para> 0152 <informaltable> 0153 <tgroup cols="3"> 0154 <thead> 0155 <row> 0156 <entry><guilabel>Variable Name</guilabel></entry> 0157 <entry><guilabel>Variable Value</guilabel></entry> 0158 <entry><guilabel>Description</guilabel></entry> 0159 </row> 0160 </thead> 0161 <tbody> 0162 <row> 0163 <entry> 0164 <para>project.name</para> 0165 </entry> 0166 <entry> 0167 <para>Name</para> 0168 </entry> 0169 <entry> 0170 <para>The name of the project</para> 0171 </entry> 0172 </row> 0173 <row> 0174 <entry> 0175 <para>project.manager</para> 0176 </entry> 0177 <entry> 0178 <para>Manager</para> 0179 </entry> 0180 <entry> 0181 <para>The name of the project manager</para> 0182 </entry> 0183 </row> 0184 <row> 0185 <entry> 0186 <para>project.bcwscost</para> 0187 </entry> 0188 <entry> 0189 <para>BCWS Cost</para> 0190 </entry> 0191 <entry> 0192 <para>Cost based Budgeted Cost of Work Scheduled</para> 0193 </entry> 0194 </row> 0195 <row> 0196 <entry> 0197 <para>project.bcwpcost</para> 0198 </entry> 0199 <entry> 0200 <para>BCWP Cost</para> 0201 </entry> 0202 <entry> 0203 <para>Cost based Budgeted Cost of Work Performed</para> 0204 </entry> 0205 </row> 0206 <row> 0207 <entry> 0208 <para>project.acwpcost</para> 0209 </entry> 0210 <entry> 0211 <para>ACWP Cost</para> 0212 </entry> 0213 <entry> 0214 <para>Cost based Actual Cost of Work Performed</para> 0215 </entry> 0216 </row> 0217 <row> 0218 <entry> 0219 <para>project.spicost</para> 0220 </entry> 0221 <entry> 0222 <para>SPI Cost</para> 0223 </entry> 0224 <entry> 0225 <para>Cost based Schedule Performance Index</para> 0226 </entry> 0227 </row> 0228 <row> 0229 <entry> 0230 <para>project.cpicost</para> 0231 </entry> 0232 <entry> 0233 <para>CPI Cost</para> 0234 </entry> 0235 <entry> 0236 <para>Cost based Cost Performance Index</para> 0237 </entry> 0238 </row> 0239 <row> 0240 <entry> 0241 <para>project.bcwseffort</para> 0242 </entry> 0243 <entry> 0244 <para>BCWS Effort</para> 0245 </entry> 0246 <entry> 0247 <para>Effort based Budgeted Cost of Work Scheduled</para> 0248 </entry> 0249 </row> 0250 <row> 0251 <entry> 0252 <para>project.bcwpeffort</para> 0253 </entry> 0254 <entry> 0255 <para>BCWP Effort</para> 0256 </entry> 0257 <entry> 0258 <para>Effort based Budgeted Cost of Work Performed</para> 0259 </entry> 0260 </row> 0261 <row> 0262 <entry> 0263 <para>project.acwpeffort</para> 0264 </entry> 0265 <entry> 0266 <para>ACWP Effort</para> 0267 </entry> 0268 <entry> 0269 <para>Effort based Actual Cost of Work Performed</para> 0270 </entry> 0271 </row> 0272 <row> 0273 <entry> 0274 <para>project.spieffort</para> 0275 </entry> 0276 <entry> 0277 <para>SPI Effort</para> 0278 </entry> 0279 <entry> 0280 <para>Effort based Schedule Performance Index</para> 0281 </entry> 0282 </row> 0283 <row> 0284 <entry> 0285 <para>project.cpieffort</para> 0286 </entry> 0287 <entry> 0288 <para>CPI Effort</para> 0289 </entry> 0290 <entry> 0291 <para>Effort based Cost Performance Index</para></entry> 0292 </row> 0293 </tbody> 0294 </tgroup> 0295 </informaltable> 0296 </para> 0297 </sect4> 0298 <sect4 id="schedule-values"><title>Schedule Values</title> 0299 <para>Shows values from the current schedule. 0300 </para> 0301 <para> 0302 <informaltable> 0303 <tgroup cols="3"> 0304 <thead> 0305 <row> 0306 <entry><guilabel>Variable Name</guilabel></entry> 0307 <entry><guilabel>Variable Value</guilabel></entry> 0308 <entry><guilabel>Description</guilabel></entry> 0309 </row> 0310 </thead> 0311 <tbody> 0312 <row> 0313 <entry> 0314 <para>schedule.name</para> 0315 </entry> 0316 <entry> 0317 <para>Name</para> 0318 </entry> 0319 <entry> 0320 <para>The name of the schedule</para> 0321 </entry> 0322 </row> 0323 <row> 0324 <entry> 0325 <para>schedule.state</para> 0326 </entry> 0327 <entry> 0328 <para>State</para> 0329 </entry> 0330 <entry> 0331 <para>Scheduling state</para> 0332 </entry> 0333 </row> 0334 <row> 0335 <entry> 0336 <para>schedule.direction</para> 0337 </entry> 0338 <entry> 0339 <para>Name</para> 0340 </entry> 0341 <entry> 0342 <para>Scheduling direction</para> 0343 </entry> 0344 </row> 0345 <row> 0346 <entry> 0347 <para>schedule.overbooking</para> 0348 </entry> 0349 <entry> 0350 <para>Overbooking</para> 0351 </entry> 0352 <entry> 0353 <para>Overbooking</para> 0354 </entry> 0355 </row> 0356 <row> 0357 <entry> 0358 <para>schedule.distribution</para> 0359 </entry> 0360 <entry> 0361 <para>Distribution</para> 0362 </entry> 0363 <entry> 0364 <para>Distribution</para> 0365 </entry> 0366 </row> 0367 <row> 0368 <entry> 0369 <para>schedule.plannedstart</para> 0370 </entry> 0371 <entry> 0372 <para>Planned Start</para> 0373 </entry> 0374 <entry> 0375 <para>Planned Start</para> 0376 </entry> 0377 </row> 0378 <row> 0379 <entry> 0380 <para>schedule.plannedfinish</para> 0381 </entry> 0382 <entry> 0383 <para>Planned Finish</para> 0384 </entry> 0385 <entry> 0386 <para>Planned Finish</para> 0387 </entry> 0388 </row> 0389 <row> 0390 <entry> 0391 <para>schedule.scheduler</para> 0392 </entry> 0393 <entry> 0394 <para>Scheduler</para> 0395 </entry> 0396 <entry> 0397 <para>Scheduler</para> 0398 </entry> 0399 </row> 0400 <row> 0401 <entry> 0402 <para>schedule.granularity</para> 0403 </entry> 0404 <entry> 0405 <para>Granularity</para> 0406 </entry> 0407 <entry> 0408 <para>Granularity</para> 0409 </entry> 0410 </row> 0411 <row> 0412 <entry> 0413 <para>schedule.mode</para> 0414 </entry> 0415 <entry> 0416 <para>Mode</para> 0417 </entry> 0418 <entry> 0419 <para>Scheduling mode (Auto or Manual)</para></entry> 0420 </row> 0421 </tbody> 0422 </tgroup> 0423 </informaltable> 0424 </para> 0425 </sect4> 0426 <sect4 id="tables"><title>Tables</title> 0427 <para>Supported table types: 0428 </para> 0429 <itemizedlist> 0430 <listitem><para>tasks</para></listitem> 0431 <listitem><para>taskstatus</para></listitem> 0432 <listitem><para>schedules</para></listitem> 0433 <listitem><para>projects</para></listitem> 0434 </itemizedlist> 0435 <para>To create a table, place a variable just before a table in your template file. The variable name identifies the table and must start with <guilabel>table</guilabel>, ⪚ <guilabel>tableTaskStatus</guilabel>. 0436 </para> 0437 <para>The value of the variable is used to point to the data to be fetched and must be one of the supported tables listed above, ⪚ <guilabel>taskstatus</guilabel>. 0438 </para> 0439 <para>You then put variables inside the table cells with name and value from the table below. 0440 </para> 0441 <para>Note that the schedules table supports the values described in <link linkend="schedule-values">Schedule Values</link> above. 0442 </para> 0443 <para>The projects, tasks and taskstatus tables supports the following values: 0444 </para> 0445 <para> 0446 <informaltable> 0447 <tgroup cols="3"> 0448 <thead> 0449 <row> 0450 <entry><guilabel>Variable Name</guilabel></entry> 0451 <entry><guilabel>Variable Value</guilabel></entry> 0452 <entry><guilabel>Description</guilabel></entry> 0453 </row> 0454 </thead> 0455 <tbody> 0456 <row> 0457 <entry> 0458 <para><replaceable>table name</replaceable>.name</para> 0459 </entry> 0460 <entry> 0461 <para>Name</para> 0462 </entry> 0463 <entry> 0464 <para>The name of the task or project</para> 0465 </entry> 0466 </row> 0467 <row> 0468 <entry> 0469 <para><replaceable>table name</replaceable>.wbscode</para> 0470 </entry> 0471 <entry> 0472 <para>WBS Code</para> 0473 </entry> 0474 <entry> 0475 <para></para> 0476 </entry> 0477 </row> 0478 <row> 0479 <entry> 0480 <para><replaceable>table name</replaceable>.type</para> 0481 </entry> 0482 <entry> 0483 <para>Type</para> 0484 </entry> 0485 <entry> 0486 <para>Type of task</para> 0487 </entry> 0488 </row> 0489 <row> 0490 <entry> 0491 <para><replaceable>table name</replaceable>.responsible</para> 0492 </entry> 0493 <entry> 0494 <para>Responsible</para> 0495 </entry> 0496 <entry> 0497 <para></para> 0498 </entry> 0499 </row> 0500 <row> 0501 <entry> 0502 <para><replaceable>table name</replaceable>.allocation</para> 0503 </entry> 0504 <entry> 0505 <para>Allocation</para> 0506 </entry> 0507 <entry> 0508 <para></para> 0509 </entry> 0510 </row> 0511 <row> 0512 <entry> 0513 <para><replaceable>table name</replaceable>.estimatetype</para> 0514 </entry> 0515 <entry> 0516 <para>Estimate Type</para> 0517 </entry> 0518 <entry> 0519 <para></para> 0520 </entry> 0521 </row> 0522 <row> 0523 <entry> 0524 <para><replaceable>table name</replaceable>.calendar</para> 0525 </entry> 0526 <entry> 0527 <para>Calendar</para> 0528 </entry> 0529 <entry> 0530 <para></para> 0531 </entry> 0532 </row> 0533 <row> 0534 <entry> 0535 <para><replaceable>table name</replaceable>.estimate</para> 0536 </entry> 0537 <entry> 0538 <para>Estimate</para> 0539 </entry> 0540 <entry> 0541 <para>Most likely estimate</para> 0542 </entry> 0543 </row> 0544 <row> 0545 <entry> 0546 <para><replaceable>table name</replaceable>.optimistic</para> 0547 </entry> 0548 <entry> 0549 <para>Optimistic</para> 0550 </entry> 0551 <entry> 0552 <para>Optimistic ratio</para> 0553 </entry> 0554 </row> 0555 <row> 0556 <entry> 0557 <para><replaceable>table name</replaceable>.pessimistic</para> 0558 </entry> 0559 <entry> 0560 <para>Pessimistic</para> 0561 </entry> 0562 <entry> 0563 <para>Pessimistic ratio</para> 0564 </entry> 0565 </row> 0566 <row> 0567 <entry> 0568 <para><replaceable>table name</replaceable>.risk</para> 0569 </entry> 0570 <entry> 0571 <para>Risk</para> 0572 </entry> 0573 <entry> 0574 <para>Estimate uncertainty</para> 0575 </entry> 0576 </row> 0577 <row> 0578 <entry> 0579 <para><replaceable>table name</replaceable>.constraint</para> 0580 </entry> 0581 <entry> 0582 <para>Constraint</para> 0583 </entry> 0584 <entry> 0585 <para>Type of time constraint</para> 0586 </entry> 0587 </row> 0588 <row> 0589 <entry> 0590 <para><replaceable>table name</replaceable>.constraintstart</para> 0591 </entry> 0592 <entry> 0593 <para>Constraint Start</para> 0594 </entry> 0595 <entry> 0596 <para>Constraint start time</para> 0597 </entry> 0598 </row> 0599 <row> 0600 <entry> 0601 <para><replaceable>table name</replaceable>.constraintend</para> 0602 </entry> 0603 <entry> 0604 <para>Constraint End</para> 0605 </entry> 0606 <entry> 0607 <para>Constraint finish time</para> 0608 </entry> 0609 </row> 0610 <row> 0611 <entry> 0612 <para><replaceable>table name</replaceable>.runingaccount</para> 0613 </entry> 0614 <entry> 0615 <para>Running Account</para> 0616 </entry> 0617 <entry> 0618 <para>Account for running costs</para> 0619 </entry> 0620 </row> 0621 <row> 0622 <entry> 0623 <para><replaceable>table name</replaceable>.startupaccount</para> 0624 </entry> 0625 <entry> 0626 <para>Startup Account</para> 0627 </entry> 0628 <entry> 0629 <para>Account for startup cost</para> 0630 </entry> 0631 </row> 0632 <row> 0633 <entry> 0634 <para><replaceable>table name</replaceable>.startupcost</para> 0635 </entry> 0636 <entry> 0637 <para>Startup Cost</para> 0638 </entry> 0639 <entry> 0640 <para>The cost incurred at startup of the task</para> 0641 </entry> 0642 </row> 0643 <row> 0644 <entry> 0645 <para><replaceable>table name</replaceable>.shutdownaccount</para> 0646 </entry> 0647 <entry> 0648 <para>Shutdown Account</para> 0649 </entry> 0650 <entry> 0651 <para>Account for shutdown cost</para> 0652 </entry> 0653 </row> 0654 <row> 0655 <entry> 0656 <para><replaceable>table name</replaceable>.shutdowncost</para> 0657 </entry> 0658 <entry> 0659 <para>Shutdown Cost</para> 0660 </entry> 0661 <entry> 0662 <para>The cost incurred at shutdown of the task</para> 0663 </entry> 0664 </row> 0665 <row> 0666 <entry> 0667 <para><replaceable>table name</replaceable>.description</para> 0668 </entry> 0669 <entry> 0670 <para>Description</para> 0671 </entry> 0672 <entry> 0673 <para>Task description</para> 0674 </entry> 0675 </row> 0676 <row> 0677 <entry> 0678 <para><replaceable>table name</replaceable>.expected</para> 0679 </entry> 0680 <entry> 0681 <para>Expected</para> 0682 </entry> 0683 <entry> 0684 <para>Calculated most likely estimate</para> 0685 </entry> 0686 </row> 0687 <row> 0688 <entry> 0689 <para><replaceable>table name</replaceable>.optimistic</para> 0690 </entry> 0691 <entry> 0692 <para>Optimistic</para> 0693 </entry> 0694 <entry> 0695 <para>Calculated optimistic estimate</para> 0696 </entry> 0697 </row> 0698 <row> 0699 <entry> 0700 <para><replaceable>table name</replaceable>.pessimistic</para> 0701 </entry> 0702 <entry> 0703 <para>Pessimistic</para> 0704 </entry> 0705 <entry> 0706 <para>Calculated pessimistic estimate</para> 0707 </entry> 0708 </row> 0709 <row> 0710 <entry> 0711 <para><replaceable>table name</replaceable>.starttime</para> 0712 </entry> 0713 <entry> 0714 <para>Start Time</para> 0715 </entry> 0716 <entry> 0717 <para>Scheduled start time</para> 0718 </entry> 0719 </row> 0720 <row> 0721 <entry> 0722 <para><replaceable>table name</replaceable>.endtime</para> 0723 </entry> 0724 <entry> 0725 <para>End Time</para> 0726 </entry> 0727 <entry> 0728 <para>Scheduled finish time</para> 0729 </entry> 0730 </row> 0731 <row> 0732 <entry> 0733 <para><replaceable>table name</replaceable>.duration</para> 0734 </entry> 0735 <entry> 0736 <para>Duration</para> 0737 </entry> 0738 <entry> 0739 <para>Scheduled duration</para> 0740 </entry> 0741 </row> 0742 <row> 0743 <entry> 0744 <para><replaceable>table name</replaceable>.earlystart</para> 0745 </entry> 0746 <entry> 0747 <para>Early Start</para> 0748 </entry> 0749 <entry> 0750 <para>Earliest possible start</para> 0751 </entry> 0752 </row> 0753 <row> 0754 <entry> 0755 <para><replaceable>table name</replaceable>.earlyfinish</para> 0756 </entry> 0757 <entry> 0758 <para>Early Finish</para> 0759 </entry> 0760 <entry> 0761 <para>Earliest possible finish</para> 0762 </entry> 0763 </row> 0764 <row> 0765 <entry> 0766 <para><replaceable>table name</replaceable>.latestart</para> 0767 </entry> 0768 <entry> 0769 <para>Late Start</para> 0770 </entry> 0771 <entry> 0772 <para>Latest possible start</para> 0773 </entry> 0774 </row> 0775 <row> 0776 <entry> 0777 <para><replaceable>table name</replaceable>.latefinish</para> 0778 </entry> 0779 <entry> 0780 <para>Late Finish</para> 0781 </entry> 0782 <entry> 0783 <para>Latest possible finish</para> 0784 </entry> 0785 </row> 0786 <row> 0787 <entry> 0788 <para><replaceable>table name</replaceable>.positivefloat</para> 0789 </entry> 0790 <entry> 0791 <para>Positive Float</para> 0792 </entry> 0793 <entry> 0794 <para></para> 0795 </entry> 0796 </row> 0797 <row> 0798 <entry> 0799 <para><replaceable>table name</replaceable>.freefloat</para> 0800 </entry> 0801 <entry> 0802 <para>Free Float</para> 0803 </entry> 0804 <entry> 0805 <para></para> 0806 </entry> 0807 </row> 0808 <row> 0809 <entry> 0810 <para><replaceable>table name</replaceable>.negativefloat</para> 0811 </entry> 0812 <entry> 0813 <para>Negative Float</para> 0814 </entry> 0815 <entry> 0816 <para></para> 0817 </entry> 0818 </row> 0819 <row> 0820 <entry> 0821 <para><replaceable>table name</replaceable>.startfloat</para> 0822 </entry> 0823 <entry> 0824 <para>Start Float</para> 0825 </entry> 0826 <entry> 0827 <para></para> 0828 </entry> 0829 </row> 0830 <row> 0831 <entry> 0832 <para><replaceable>table name</replaceable>.finishfloat</para> 0833 </entry> 0834 <entry> 0835 <para>Finish Float</para> 0836 </entry> 0837 <entry> 0838 <para></para> 0839 </entry> 0840 </row> 0841 <row> 0842 <entry> 0843 <para><replaceable>table name</replaceable>.assignaments</para> 0844 </entry> 0845 <entry> 0846 <para>Assignments</para> 0847 </entry> 0848 <entry> 0849 <para>Resource assignments</para> 0850 </entry> 0851 </row> 0852 <row> 0853 <entry> 0854 <para><replaceable>table name</replaceable>.varianceest</para> 0855 </entry> 0856 <entry> 0857 <para>Variance (Est)</para> 0858 </entry> 0859 <entry> 0860 <para>Calculated estimate variance</para> 0861 </entry> 0862 </row> 0863 <row> 0864 <entry> 0865 <para><replaceable>table name</replaceable>.variancedur</para> 0866 </entry> 0867 <entry> 0868 <para>Variance (Dur)</para> 0869 </entry> 0870 <entry> 0871 <para>Calculated duration variance</para> 0872 </entry> 0873 </row> 0874 <row> 0875 <entry> 0876 <para><replaceable>table name</replaceable>.optimisticdur</para> 0877 </entry> 0878 <entry> 0879 <para>Optimistic (Dur)</para> 0880 </entry> 0881 <entry> 0882 <para>Calculated optimistic duration</para> 0883 </entry> 0884 </row> 0885 <row> 0886 <entry> 0887 <para><replaceable>table name</replaceable>.pessimisticdur</para> 0888 </entry> 0889 <entry> 0890 <para>Pessimistic (Dur)</para> 0891 </entry> 0892 <entry> 0893 <para>Calculated pessimistic duration</para> 0894 </entry> 0895 </row> 0896 <row> 0897 <entry> 0898 <para><replaceable>table name</replaceable>.status</para> 0899 </entry> 0900 <entry> 0901 <para>Status</para> 0902 </entry> 0903 <entry> 0904 <para>Task status as shown in Task Status View</para> 0905 </entry> 0906 </row> 0907 <row> 0908 <entry> 0909 <para><replaceable>table name</replaceable>.completion</para> 0910 </entry> 0911 <entry> 0912 <para>% Completed</para> 0913 </entry> 0914 <entry> 0915 <para>Task completion</para> 0916 </entry> 0917 </row> 0918 <row> 0919 <entry> 0920 <para><replaceable>table name</replaceable>.plannedeffort</para> 0921 </entry> 0922 <entry> 0923 <para>Planned Effort</para> 0924 </entry> 0925 <entry> 0926 <para>Planned effort</para> 0927 </entry> 0928 </row> 0929 <row> 0930 <entry> 0931 <para><replaceable>table name</replaceable>.actualeffort</para> 0932 </entry> 0933 <entry> 0934 <para>Actual Effort</para> 0935 </entry> 0936 <entry> 0937 <para>Actual effort</para> 0938 </entry> 0939 </row> 0940 <row> 0941 <entry> 0942 <para><replaceable>table name</replaceable>.remaningeffort</para> 0943 </entry> 0944 <entry> 0945 <para>Remaining Effort</para> 0946 </entry> 0947 <entry> 0948 <para>Remaining effort</para> 0949 </entry> 0950 </row> 0951 <row> 0952 <entry> 0953 <para><replaceable>table name</replaceable>.plannedcost</para> 0954 </entry> 0955 <entry> 0956 <para>Planned Cost</para> 0957 </entry> 0958 <entry> 0959 <para>Planned cost</para> 0960 </entry> 0961 </row> 0962 <row> 0963 <entry> 0964 <para><replaceable>table name</replaceable>.actualcost</para> 0965 </entry> 0966 <entry> 0967 <para>Actual Cost</para> 0968 </entry> 0969 <entry> 0970 <para>Actual cost</para> 0971 </entry> 0972 </row> 0973 <row> 0974 <entry> 0975 <para><replaceable>table name</replaceable>.actualstart</para> 0976 </entry> 0977 <entry> 0978 <para>Actual Start</para> 0979 </entry> 0980 <entry> 0981 <para>Actual start</para> 0982 </entry> 0983 </row> 0984 <row> 0985 <entry> 0986 <para><replaceable>table name</replaceable>.started</para> 0987 </entry> 0988 <entry> 0989 <para>Started</para> 0990 </entry> 0991 <entry> 0992 <para></para> 0993 </entry> 0994 </row> 0995 <row> 0996 <entry> 0997 <para><replaceable>table name</replaceable>.actualfinish</para> 0998 </entry> 0999 <entry> 1000 <para>Actual Finish</para> 1001 </entry> 1002 <entry> 1003 <para>Actual finish</para> 1004 </entry> 1005 </row> 1006 <row> 1007 <entry> 1008 <para><replaceable>table name</replaceable>.finished</para> 1009 </entry> 1010 <entry> 1011 <para>Finished</para> 1012 </entry> 1013 <entry> 1014 <para></para> 1015 </entry> 1016 </row> 1017 <row> 1018 <entry> 1019 <para><replaceable>table name</replaceable>.schedulingstatus</para> 1020 </entry> 1021 <entry> 1022 <para>Scheduling Status</para> 1023 </entry> 1024 <entry> 1025 <para>Scheduling status</para> 1026 </entry> 1027 </row> 1028 <row> 1029 <entry> 1030 <para><replaceable>table name</replaceable>.bcws</para> 1031 </entry> 1032 <entry> 1033 <para>BCWS</para> 1034 </entry> 1035 <entry> 1036 <para>Budgeted Cost of Work Scheduled (cost based)</para> 1037 </entry> 1038 </row> 1039 <row> 1040 <entry> 1041 <para><replaceable>table name</replaceable>.bcwp</para> 1042 </entry> 1043 <entry> 1044 <para>BCWP</para> 1045 </entry> 1046 <entry> 1047 <para>Budgeted Cost of Work Performed (cost based)</para> 1048 </entry> 1049 </row> 1050 <row> 1051 <entry> 1052 <para><replaceable>table name</replaceable>.acwp</para> 1053 </entry> 1054 <entry> 1055 <para>ACWP</para> 1056 </entry> 1057 <entry> 1058 <para>Actual Cost of Work Performed (cost based)</para> 1059 </entry> 1060 </row> 1061 <row> 1062 <entry> 1063 <para><replaceable>table name</replaceable>.spi</para> 1064 </entry> 1065 <entry> 1066 <para>SPI</para> 1067 </entry> 1068 <entry> 1069 <para>Schedule Performance Index</para> 1070 </entry> 1071 </row> 1072 <row> 1073 <entry> 1074 <para><replaceable>table name</replaceable>.critical</para> 1075 </entry> 1076 <entry> 1077 <para>Critical</para> 1078 </entry> 1079 <entry> 1080 <para>Task is critical</para> 1081 </entry> 1082 </row> 1083 <row> 1084 <entry> 1085 <para><replaceable>table name</replaceable>.criticalpath</para> 1086 </entry> 1087 <entry> 1088 <para>Critical Path</para> 1089 </entry> 1090 <entry> 1091 <para>Task is in critical path</para> 1092 </entry> 1093 </row> 1094 <row> 1095 <entry> 1096 <para><replaceable>table name</replaceable>.notscheduled</para> 1097 </entry> 1098 <entry> 1099 <para>Not Scheduled</para> 1100 </entry> 1101 <entry> 1102 <para>Not interesting</para> 1103 </entry> 1104 </row> 1105 <row> 1106 <entry> 1107 <para><replaceable>table name</replaceable>.assignmentmissing</para> 1108 </entry> 1109 <entry> 1110 <para>Assignment Missing</para> 1111 </entry> 1112 <entry> 1113 <para>Not interesting</para> 1114 </entry> 1115 </row> 1116 <row> 1117 <entry> 1118 <para><replaceable>table name</replaceable>.resourceoverbooked</para> 1119 </entry> 1120 <entry> 1121 <para>Resource Overbooked</para> 1122 </entry> 1123 <entry> 1124 <para>Not interesting</para> 1125 </entry> 1126 </row> 1127 <row> 1128 <entry> 1129 <para><replaceable>table name</replaceable>.resourceunavailable</para> 1130 </entry> 1131 <entry> 1132 <para>Resource Unavailable</para> 1133 </entry> 1134 <entry> 1135 <para>Not interesting</para> 1136 </entry> 1137 </row> 1138 <row> 1139 <entry> 1140 <para><replaceable>table name</replaceable>.constrainterror</para> 1141 </entry> 1142 <entry> 1143 <para>Constraints Error</para> 1144 </entry> 1145 <entry> 1146 <para>Not interesting</para> 1147 </entry> 1148 </row> 1149 <row> 1150 <entry> 1151 <para><replaceable>table name</replaceable>.effortnotmet</para> 1152 </entry> 1153 <entry> 1154 <para>Effort Not Met</para> 1155 </entry> 1156 <entry> 1157 <para>Not interesting</para> 1158 </entry> 1159 </row> 1160 <row> 1161 <entry> 1162 <para><replaceable>table name</replaceable>.schedulingerror</para> 1163 </entry> 1164 <entry> 1165 <para>Scheduling Error</para> 1166 </entry> 1167 <entry> 1168 <para>Not interesting</para> 1169 </entry> 1170 </row> 1171 <row> 1172 <entry> 1173 <para><replaceable>table name</replaceable>.level</para> 1174 </entry> 1175 <entry> 1176 <para>Node level, Level</para> 1177 </entry> 1178 <entry> 1179 <para>Not interesting</para> 1180 </entry> 1181 </row> 1182 <row> 1183 <entry> 1184 <para><replaceable>table name</replaceable>.statusnote</para> 1185 </entry> 1186 <entry> 1187 <para>Status Note</para> 1188 </entry> 1189 <entry> 1190 <para>Note: Not implemented</para> 1191 </entry> 1192 </row> 1193 <row> 1194 <entry> 1195 <para><replaceable>table name</replaceable>.owner</para> 1196 </entry> 1197 <entry> 1198 <para>Owner</para> 1199 </entry> 1200 <entry> 1201 <para>Must not be used, and are not very interesting</para> 1202 </entry> 1203 </row> 1204 <row> 1205 <entry> 1206 <para><replaceable>table name</replaceable>.status</para> 1207 </entry> 1208 <entry> 1209 <para>Status</para> 1210 </entry> 1211 <entry> 1212 <para>Must not be used, and are not very interesting</para> 1213 </entry> 1214 </row> 1215 <row> 1216 <entry> 1217 <para><replaceable>table name</replaceable>.time</para> 1218 </entry> 1219 <entry> 1220 <para>Time</para> 1221 </entry> 1222 <entry> 1223 <para>Must not be used, and are not very interesting</para></entry> 1224 </row> 1225 </tbody> 1226 </tgroup> 1227 </informaltable> 1228 </para> 1229 </sect4> 1230 </sect3> 1231 <sect3 id="chart"><title>Chart</title> 1232 <para>Use by placing a variable with name chartX (X=some text to make the variable name unique) with a value project before the chart that shall be used. 1233 </para> 1234 <para>The variable has this format: 1235 </para> 1236 <para>Variable: <varname>Name: chartX (X=some text) Value: project; values=<replaceable>data</replaceable>;</varname> 1237 </para> 1238 <para>where <replaceable>data</replaceable> is a comma separated list of values to be include in the chart. 1239 </para> 1240 <para>Possible <replaceable>data</replaceable> values are: 1241 </para> 1242 <itemizedlist> 1243 <listitem><para><guilabel>bcws effort</guilabel> Budgeted cost of work scheduled, effort based.</para></listitem> 1244 <listitem><para><guilabel>bcwp effort</guilabel> Budgeted cost of work performed, effort based.</para></listitem> 1245 <listitem><para><guilabel>acwp effort</guilabel> Actual cost of work performed, effort based.</para></listitem> 1246 <listitem><para><guilabel>spi effort</guilabel> Schedule performance index, effort based.</para></listitem> 1247 <listitem><para><guilabel>cpi effort</guilabel> Cost performance index, effort based.</para></listitem> 1248 <listitem><para><guilabel>bcws cost</guilabel> Budgeted cost of work scheduled, cost based.</para></listitem> 1249 <listitem><para><guilabel>bcwp cost</guilabel> Budgeted cost of work performed, cost based.</para></listitem> 1250 <listitem><para><guilabel>acwp cost</guilabel> Actual cost of work performed, cost based.</para></listitem> 1251 <listitem><para><guilabel>spi cost</guilabel> Schedule performance index, cost based.</para></listitem> 1252 <listitem><para><guilabel>cpi cost</guilabel> Cost performance index, cost based.</para></listitem> 1253 </itemizedlist> 1254 <para>The charts you create in your template must have the same (or more) number of columns as the number of values you specify in your variable. 1255 </para> 1256 <para>Example: 1257 </para> 1258 <para>Variable name: <varname>chart1</varname> Value: <varname>project; values=bcws cost,bcwp cost, acwp cost;</varname> 1259 </para> 1260 <para>Note that you cannot mix effort- and cost-based values. If you want to show both, create two charts. 1261 </para> 1262 <sect4 id="gantt"><title>Gantt</title> 1263 <para>Not supported. 1264 </para> 1265 </sect4> 1266 </sect3> 1267 </sect2>