Determining Weights of Columns For A Prioritization Matrix I'm trying to calculate the weight of various tasks.  I have tasks that are daily, weekly, monthly, yearly.  As a task gets closer to due date, I'd like it to be more important.  For example, a weekly task that is due in 2 days is more important than a task due in 7 days.  To complicate matters, as an example, a monthly task that is 2 days away from being due should be more important than a weekly task that is 2 days away from being due.  Also, I'd like some task to be more important than others by nature.  By this I mean one task that is daily is inherently more important than another daily task.
This is my first time posting on math.stackexchange (originally from stackoverflow), so please let me know what other information I need to provide.  Perhaps I can simplify this idea somehow?
 A: Using the values for 'Period Category' of (Daily=$1$, Weekly=$2$, Monthly=$3$). These values must have ascending values for Solution $2$ below. Note that when $'Due Date'=0$ it means that this task is due today.
Example of original list of tasks.

Solution 1: Sorting by (Period Category) Descending, (Due Date) Ascending,  Importance (Descending) we get this list:
Note this method assumes equal weights for each factor.

Solution 2: By applying a formula
$$Calculated Priority = =(1*'Importance level value' + 3* 'Period Category Value' + 5*(367-'Due Date')).$$
The values $1$,$3$ and $5$ are arbitrary chosen to reflect the rules that:
A-Due Date is the Most Important Factor
B-Period Category is the next most important factor
C-Importance level value/task is the least important factor
Also, it says that "Period Category" is $3$ times more important than the "Importance level value" and that the "Due Date" is $5$ times more important than the "Importance level value". Again you could use different weights as long as the rules are preserved.
The due date is calculated as follows: I assume that a task won't be late than $x$ days (I here take x to $367$ days). This is to enforce rule B above, the more close then end date, the larger the priority of the task becomes.
After calculating the 'Calculated Priority' for each column, we sort the result by the column 'Calculated Priority' to get:

