Add Conditional Formula Columns

My spreadsheet is already set up and running smoothly—I just need two additional columns that perform calculations based on conditional logic drawn from the existing data. I will share the file along with a brief description of the rules each column should follow so you can drop in the formulas, test them, and ensure they update dynamically as new rows are added.

What I need from you:
• Insert the two new columns in the correct place without disturbing current formatting.
• Build the custom conditional formulas exactly to spec (I’ll outline the “if-this-then-that” rules).
• Confirm the results are accurate across several sample scenarios and that the formulas remain intact when the sheet is filtered, sorted, or extended.

If you have a knack for efficient spreadsheet logic in Excel or Google Sheets, this should be a straightforward task. Let me know your availability and any clarifying questions you have once you see the file; I’m ready to move quickly.