Automatic Calculations Spreadsheet Instructions.docx

The PDF document provides instructions on how to set up a spreadsheet for pricing calculations. It explains which cells are locked (Columns A, B, C, F, and G) containing names and formulas, and which cells are unlocked (Columns D, E, and H) for supplier pricing data entry. It details the steps to protect the sheet before sending it to the supplier, including marking cells as locked, selecting locked and unlocked cells, setting a password, and protecting the worksheet. This process ensures that suppliers can input data into specific cells while maintaining the integrity of the pricing calculations.