Rate Card Definition. Rate Card Definition screen facilitates you to define the billing rate for each Role. The Rate Cards will be used in billable Projects for calculating the Billing Cost of various Resources. Defining a Rate Card: 1. On the Administration menu, click the Rate Card Definition option from the list. 1  2. The Rate Card Definition screen will open. 2  3. The screen has two grids: 3  4. Click Edit icon . The screen becomes editable and a new row will be added at the bottom of the Rate Card (s) grid. 4  5. Enter the Rate Card Name and Description.
A pivot table is a program tool that allows you to reorganize and summarize selected columns and rows of data in a spreadsheet or database table to obtain a desired report.A pivot table doesn't actually change the spreadsheet or database itself. pivot table is a program tool that allows you to reorganize and summarize selected columns and rows of data in a spreadsheet or database table to obtain a desired report.
Building the Pivot Table. 1  1. Load the spreadsheet you want to create the Pivot Table from. A Pivot Table allows you to create visual reports of the data from a spreadsheet. 2  2. Ensure that your data meets the needs of a pivot table. A pivot table is not always the answer you are looking for. 3  3. Start the Pivot Table wizard. Click the Insert tab at the top of the Excel window. Click the PivotTable button on the left side of the Insert ribbon. If you are using Excel 2003 or earlier, click the Data menu and select PivotTable and PivotChart Report...