Hello,
I have a standard rate sheet where I share different charges to my clients. Sometimes, some clients have better rates than others, thus I have to have one rate sheet for each client in excel files.
I want to create a single general rate sheet and create a rules table, so that I can add/subtract a specific amout or a percentage to a specific client. After that, I would need a kind of dynamic rate sheet where I can see the resulting rates for a specific client.
The formula that I am thinking about is: Base rate + extra value + extra percentage.
The last 2 values should be extracted from the rules table for the specific client,
This is the structure of my database:
TABLE 1: Ratesheet Columns: Name, Rate, Min, Max, Tags, Notes, Rules (link)
TABLE 2: Clients Columns: Name, Notes, Rules (link)
TABLE 3: Rules Columns: Name, Add value, Add percentage, Clients (link), Ratesheet (link)