
I think that formula is slightly wrong, in that the first argument (B2, C2, D2) should be "absolute", not "relative". Note that you just have to type the formula in cell B3, and then copy it to the other cells. Row 2 would be filled with column headings of percent values: 80%, 60%, and so on. I'll assume, for simplicity, that your base values are in the A column, and that they start in row 3: A3 is your first actual value. If you tell Excel to format it as a percentage, you type in "0.80" and it will show "80%". After implementation, direct-field sound masking is the most effective and budget friendly solution for delivering increased privacy while reducing conversational distractions.Best answer: How you'd actually set it up: one row, sort of a title row, would have your percentages. The office environment in this example features 8’ ceilings and 10’x10’ cubicles. The table below shows the effectiveness of common types of acoustical treatments.


Privacy in open offices encompasses freedom from distractions and is dependent on how well the space can Absorb, Block, and Cover sounds. The lower the PI percentage, the less private the talker’s conversation becomes. The higher the PI percentage the more privacy the talker has. This calculator shows the Privacy Index (PI) of one talker in an open office. interactive privacy calculator gives you the chance to explore the ABC’s of acoustics.
