| # Other templates In all the other templates under this group, you can only modify the records. You cannot insert new records from Microsoft Excel to LN Project. In addition, you can only write the values of a few fields back to LN Project. For each template, only a small number of relevant fields appear, while other fields are hidden. To view these fields, you can use the unhide property on the columns. Related amounts will be calculated again in LN Project. The following additional templates are available: The quantity calculations template calculates the quantities of estimate lines. Only the fields quantity, adjustment factor, scrap factor, norm and production rate can be written back to LN Project. The Cost Price Calculation template calculates the cost price of estimate lines. Information about quantity, landed cost amount, surcharges and so on, are passed to Excel where an optimum cost price is to be calculated and brought back to LN Project. Whenever the value of cost price is changed directly or through calculation, the value of the field Origin of cost price must be set to Excel. You can only write the following field properties back to LN Project: Cost price Surcharge percentage or surcharge amount Escalation amount Contingency amount You can perform the sales price calculation in the following two templates: Sales price calculation - Markup template Sales price calculation - Target pricing template To choose the appropriate template, you must take into account the pricing method. Through these templates, you can pass the basic cost information to the desired level to Excel, calculate an optimum sales price, and bring this information back to LN Project. In the sales price calculation – markup template, only the Markup Percentage, Markup Amount, Discount Percentage, and/or Discount Amount fields can be written back to LN Project. In the sales price calculation – target pricing template, only the Discount Percentage and/or Discount Amount fields can be written back to LN Project. You must set the origin of sales price value to Excel if you change or calculate the gross sales price directly or calculated. In the Amounts template, only the Surcharge Percentage or Surcharge Amount field, the Escalation Amount field, and the Contingency Amount field can be written back to LN Project. In all the templates under the group estimate lines, a few form/Excel/calculated fields:
Total Cost Amount | Landed Cost Amount + Contingency Amount + Escalation Amount
Gross Quantity | Quantity * Adjustment Factor * (Norm/Production Rate) * (1 + Scrap Factor/100)
Profit Amount | Net Sales Amount – Total Cost Amount
Profit Percentage | Profit Amount / Total Cost Amount *100