Compensation model help

M

mattdete

New Member
Joined
Feb 7, 2014
Messages
17
I need help on this task. Are there any templated sheets one can recommend?

Using the data contained on the second tab "data" create a financial model that the Deans of the college can use to determine how the chairman ("chair) of a department should be compensated for the administrative role of managing the department. Currently the chair stipend is 21% of the chair's base salary, but the college wants to consider alternate methodologies for calculating a chair's stipend.

[TABLE="width: 1516"]
<colgroup><col><col span="16"></colgroup><tbody>[TR]
[TD]Division[/TD]
[TD]Dept[/TD]
[TD]UG SCHFY2011[/TD]
[TD]UG SCHFY2012[/TD]
[TD]UG SCHFY2013[/TD]
[TD]MA Grad SCHFY2011[/TD]
[TD]MA Grad SCHFY2012[/TD]
[TD]MA Grad SCHFY2013[/TD]
[TD]PhD Grad SCHFY2011[/TD]
[TD]PhD Grad SCHFY2012[/TD]
[TD]PhD Grad SCHFY2013[/TD]
[TD]Instructor FTEFY2011[/TD]
[TD]Instructor FTEFY2012[/TD]
[TD]Instructor FTEFY2013[/TD]
[TD]Faculty FTEFY2011[/TD]
[TD]Faculty FTEFY2012[/TD]
[TD]Faculty FTEFY2013[/TD]
[/TR]
[TR]
[TD]DIVISION A[/TD]
[TD]1.00[/TD]
[TD]11,780.00[/TD]
[TD]10,873.00[/TD]
[TD]10,210.00[/TD]
[TD]592.00[/TD]
[TD]593.00[/TD]
[TD]459.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]1.63[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]24.50[/TD]
[TD]25.50[/TD]
[TD]24.50[/TD]
[/TR]
[TR]
[TD]DIVISION A[/TD]
[TD]2.00[/TD]
[TD]7,383.00[/TD]
[TD]6,936.00[/TD]
[TD]6,249.00[/TD]
[TD]386.00[/TD]
[TD]364.00[/TD]
[TD]313.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]11.00[/TD]
[TD]8.00[/TD]
[TD]10.00[/TD]
[TD]12.00[/TD]
[TD]13.00[/TD]
[TD]12.00[/TD]
[/TR]
[TR]
[TD]DIVISION A[/TD]
[TD]3.00[/TD]
[TD]6,183.00[/TD]
[TD]6,780.00[/TD]
[TD]6,650.00[/TD]
[TD]342.00[/TD]
[TD]115.00[/TD]
[TD]207.00[/TD]
[TD]81.00[/TD]
[TD]140.00[/TD]
[TD]89.00[/TD]
[TD]0.50[/TD]
[TD]0.50[/TD]
[TD]1.00[/TD]
[TD]11.00[/TD]
[TD]11.00[/TD]
[TD]12.00[/TD]
[/TR]
[TR]
[TD]DIVISION A[/TD]
[TD]4.00[/TD]
[TD]26,045.00[/TD]
[TD]24,761.00[/TD]
[TD]21,768.00[/TD]
[TD]925.00[/TD]
[TD]878.00[/TD]
[TD]1,066.00[/TD]
[TD]613.00[/TD]
[TD]585.00[/TD]
[TD]471.00[/TD]
[TD]3.00[/TD]
[TD]3.00[/TD]
[TD]4.00[/TD]
[TD]43.50[/TD]
[TD]43.50[/TD]
[TD]41.50[/TD]
[/TR]
[TR]
[TD]DIVISION A[/TD]
[TD]5.00[/TD]
[TD]6,980.00[/TD]
[TD]6,940.00[/TD]
[TD]6,660.00[/TD]
[TD]93.00[/TD]
[TD]36.00[/TD]
[TD]60.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.50[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]9.00[/TD]
[TD]11.00[/TD]
[TD]10.00[/TD]
[/TR]
[TR]
[TD]DIVISION A[/TD]
[TD]6.00[/TD]
[TD]9,340.00[/TD]
[TD]8,413.00[/TD]
[TD]7,515.00[/TD]
[TD]135.00[/TD]
[TD]162.00[/TD]
[TD]160.00[/TD]
[TD]130.00[/TD]
[TD]142.00[/TD]
[TD]136.00[/TD]
[TD]5.01[/TD]
[TD]4.34[/TD]
[TD]4.34[/TD]
[TD]11.50[/TD]
[TD]10.50[/TD]
[TD]9.50[/TD]
[/TR]
[TR]
[TD]DIVISION A[/TD]
[TD]7.00[/TD]
[TD]11,415.00[/TD]
[TD]10,508.00[/TD]
[TD]10,919.00[/TD]
[TD]288.00[/TD]
[TD]222.00[/TD]
[TD]165.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]7.00[/TD]
[TD]6.00[/TD]
[TD]7.00[/TD]
[TD]11.67[/TD]
[TD]11.00[/TD]
[TD]10.00[/TD]
[/TR]
[TR]
[TD]DIVISION A[/TD]
[TD]8.00[/TD]
[TD]22,721.00[/TD]
[TD]21,231.00[/TD]
[TD]20,846.00[/TD]
[TD]367.00[/TD]
[TD]220.00[/TD]
[TD]338.00[/TD]
[TD]318.00[/TD]
[TD]378.00[/TD]
[TD]399.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]29.50[/TD]
[TD]30.50[/TD]
[TD]30.50[/TD]
[/TR]
[TR]
[TD]DIVISION A[/TD]
[TD]9.00[/TD]
[TD]5,165.00[/TD]
[TD]4,637.00[/TD]
[TD]3,135.00[/TD]
[TD]0.00[/TD]
[TD][/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD][/TD]
[TD]0.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]2.33[/TD]
[TD]2.00[/TD]
[TD]2.00[/TD]
[/TR]
[TR]
[TD]DIVISION A[/TD]
[TD]10.00[/TD]
[TD]20,295.00[/TD]
[TD]18,146.00[/TD]
[TD]16,984.00[/TD]
[TD]447.00[/TD]
[TD]399.00[/TD]
[TD]324.00[/TD]
[TD]238.00[/TD]
[TD]210.00[/TD]
[TD]259.00[/TD]
[TD]4.68[/TD]
[TD]3.34[/TD]
[TD]4.34[/TD]
[TD]23.83[/TD]
[TD]22.83[/TD]
[TD]22.50[/TD]
[/TR]
[TR]
[TD]DIVISION A[/TD]
[TD]11.00[/TD]
[TD]5,115.00[/TD]
[TD]4,748.00[/TD]
[TD]4,535.00[/TD]
[TD]229.00[/TD]
[TD]123.00[/TD]
[TD]113.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]8.50[/TD]
[TD]8.50[/TD]
[TD]9.50[/TD]
[/TR]
[TR]
[TD]DIVISION A[/TD]
[TD]12.00[/TD]
[TD]18,089.00[/TD]
[TD]17,216.00[/TD]
[TD]15,276.00[/TD]
[TD]526.00[/TD]
[TD]528.00[/TD]
[TD]495.00[/TD]
[TD]205.00[/TD]
[TD]183.00[/TD]
[TD]182.00[/TD]
[TD]11.00[/TD]
[TD]11.00[/TD]
[TD]11.00[/TD]
[TD]15.00[/TD]
[TD]15.00[/TD]
[TD]15.00[/TD]
[/TR]
[TR]
[TD]DIVISION A[/TD]
[TD]13.00[/TD]
[TD]12,087.00[/TD]
[TD]11,818.00[/TD]
[TD]11,865.00[/TD]
[TD]511.00[/TD]
[TD]522.00[/TD]
[TD]533.00[/TD]
[TD]149.00[/TD]
[TD]136.00[/TD]
[TD]188.00[/TD]
[TD]6.00[/TD]
[TD]6.50[/TD]
[TD]7.50[/TD]
[TD]15.00[/TD]
[TD]14.00[/TD]
[TD]13.00[/TD]
[/TR]
[TR]
[TD]DIVISION A[/TD]
[TD]14.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[/TR]
[TR]
[TD]DIVISION A[/TD]
[TD]15.00[/TD]
[TD]23,585.00[/TD]
[TD]25,710.00[/TD]
[TD]23,991.00[/TD]
[TD]15.00[/TD]
[TD]36.00[/TD]
[TD]15.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]51.17[/TD]
[TD]44.84[/TD]
[TD]38.67[/TD]
[TD]4.00[/TD]
[TD]4.00[/TD]
[TD]5.00[/TD]
[/TR]
[TR]
[TD]DIVISION A[/TD]
[TD]16.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[/TR]
[TR]
[TD]DIVISION A[/TD]
[TD]17.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]160.00[/TD]
[TD]165.00[/TD]
[TD]172.00[/TD]
[TD]158.00[/TD]
[TD]135.00[/TD]
[TD]95.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD]DIVISION B[/TD]
[TD]18.00[/TD]
[TD]14,708.00[/TD]
[TD]15,759.00[/TD]
[TD]16,957.00[/TD]
[TD]533.00[/TD]
[TD]568.00[/TD]
[TD]536.00[/TD]
[TD]544.00[/TD]
[TD]548.00[/TD]
[TD]585.00[/TD]
[TD]5.00[/TD]
[TD]5.00[/TD]
[TD]3.00[/TD]
[TD]17.00[/TD]
[TD]16.00[/TD]
[TD]17.00[/TD]
[/TR]
[TR]
[TD]DIVISION B[/TD]
[TD]19.00[/TD]
[TD]7,872.00[/TD]
[TD]9,122.00[/TD]
[TD]9,109.00[/TD]
[TD]422.00[/TD]
[TD]459.00[/TD]
[TD]493.00[/TD]
[TD]356.00[/TD]
[TD]321.00[/TD]
[TD]291.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]17.00[/TD]
[TD]17.00[/TD]
[TD]18.00[/TD]
[/TR]
[TR]
[TD]DIVISION B[/TD]
[TD]20.00[/TD]
[TD]8,332.00[/TD]
[TD]7,520.00[/TD]
[TD]6,541.00[/TD]
[TD]510.00[/TD]
[TD]305.00[/TD]
[TD]330.00[/TD]
[TD]567.00[/TD]
[TD]607.00[/TD]
[TD]538.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]8.50[/TD]
[TD]8.50[/TD]
[TD]8.00[/TD]
[/TR]
[TR]
[TD]DIVISION B[/TD]
[TD]21.00[/TD]
[TD]27,674.00[/TD]
[TD]27,629.00[/TD]
[TD]28,874.00[/TD]
[TD]1,382.00[/TD]
[TD]1,360.00[/TD]
[TD]1,577.00[/TD]
[TD]1,269.00[/TD]
[TD]1,353.00[/TD]
[TD]1,435.00[/TD]
[TD]4.30[/TD]
[TD]3.80[/TD]
[TD]3.80[/TD]
[TD]37.50[/TD]
[TD]38.50[/TD]
[TD]38.25[/TD]
[/TR]
[TR]
[TD]DIVISION B[/TD]
[TD]22.00[/TD]
[TD]20,379.00[/TD]
[TD]20,558.00[/TD]
[TD]20,824.00[/TD]
[TD]358.00[/TD]
[TD]210.00[/TD]
[TD]258.00[/TD]
[TD]533.00[/TD]
[TD]605.00[/TD]
[TD]564.00[/TD]
[TD]2.50[/TD]
[TD]2.50[/TD]
[TD]3.50[/TD]
[TD]21.50[/TD]
[TD]20.50[/TD]
[TD]19.50[/TD]
[/TR]
[TR]
[TD]DIVISION B[/TD]
[TD]23.00[/TD]
[TD]4,528.00[/TD]
[TD]4,910.00[/TD]
[TD]5,282.00[/TD]
[TD]703.00[/TD]
[TD]399.00[/TD]
[TD]451.00[/TD]
[TD]219.00[/TD]
[TD]181.00[/TD]
[TD]203.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]4.50[/TD]
[TD]5.00[/TD]
[TD]6.00[/TD]
[/TR]
[TR]
[TD]DIVISION B[/TD]
[TD]24.00[/TD]
[TD]13,741.00[/TD]
[TD]13,246.00[/TD]
[TD]12,441.00[/TD]
[TD]739.00[/TD]
[TD]384.00[/TD]
[TD]433.00[/TD]
[TD]466.00[/TD]
[TD]463.00[/TD]
[TD]416.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]17.83[/TD]
[TD]17.83[/TD]
[TD]17.50[/TD]
[/TR]
[TR]
[TD]DIVISION B[/TD]
[TD]25.00[/TD]
[TD]10,486.00[/TD]
[TD]10,762.00[/TD]
[TD]9,964.00[/TD]
[TD]506.00[/TD]
[TD]472.00[/TD]
[TD]482.00[/TD]
[TD]332.00[/TD]
[TD]356.00[/TD]
[TD]391.00[/TD]
[TD]0.75[/TD]
[TD]0.75[/TD]
[TD]0.75[/TD]
[TD]18.00[/TD]
[TD]16.50[/TD]
[TD]16.50[/TD]
[/TR]
[TR]
[TD]DIVISION B[/TD]
[TD]26.00[/TD]
[TD]17,742.00[/TD]
[TD]18,430.00[/TD]
[TD]18,536.00[/TD]
[TD]553.00[/TD]
[TD]559.00[/TD]
[TD]532.00[/TD]
[TD]233.00[/TD]
[TD]257.00[/TD]
[TD]233.00[/TD]
[TD]9.00[/TD]
[TD]9.00[/TD]
[TD]9.00[/TD]
[TD]15.00[/TD]
[TD]15.00[/TD]
[TD]15.00[/TD]
[/TR]
[TR]
[TD]DIVISION B[/TD]
[TD]27.00[/TD]
[TD]28,616.00[/TD]
[TD]29,451.00[/TD]
[TD]31,157.00[/TD]
[TD]784.00[/TD]
[TD]596.00[/TD]
[TD]631.00[/TD]
[TD]523.00[/TD]
[TD]443.00[/TD]
[TD]448.00[/TD]
[TD]3.50[/TD]
[TD]5.00[/TD]
[TD]5.50[/TD]
[TD]26.00[/TD]
[TD]24.00[/TD]
[TD]24.00[/TD]
[/TR]
[TR]
[TD]DIVISION B[/TD]
[TD]28.00[/TD]
[TD]8,305.00[/TD]
[TD]9,844.00[/TD]
[TD]10,275.00[/TD]
[TD]302.00[/TD]
[TD]357.00[/TD]
[TD]296.00[/TD]
[TD]558.00[/TD]
[TD]489.00[/TD]
[TD]496.00[/TD]
[TD]2.80[/TD]
[TD]3.00[/TD]
[TD]3.00[/TD]
[TD]25.00[/TD]
[TD]23.50[/TD]
[TD]23.50[/TD]
[/TR]
[TR]
[TD]DIVISION B[/TD]
[TD]29.00[/TD]
[TD]24,947.00[/TD]
[TD]25,165.00[/TD]
[TD]26,716.00[/TD]
[TD]732.00[/TD]
[TD]766.00[/TD]
[TD]579.00[/TD]
[TD]1,952.00[/TD]
[TD]2,037.00[/TD]
[TD]2,089.00[/TD]
[TD]1.00[/TD]
[TD]1.50[/TD]
[TD]1.50[/TD]
[TD]48.40[/TD]
[TD]46.60[/TD]
[TD]47.10[/TD]
[/TR]
[TR]
[TD]DIVISION B[/TD]
[TD]30.00[/TD]
[TD]35,242.00[/TD]
[TD]34,050.00[/TD]
[TD]31,348.00[/TD]
[TD]718.00[/TD]
[TD]682.00[/TD]
[TD]721.00[/TD]
[TD]817.00[/TD]
[TD]941.00[/TD]
[TD]923.00[/TD]
[TD]5.00[/TD]
[TD]5.00[/TD]
[TD]6.00[/TD]
[TD]37.50[/TD]
[TD]36.50[/TD]
[TD]36.50[/TD]
[/TR]
[TR]
[TD]DIVISION C[/TD]
[TD]31.00[/TD]
[TD]16,834.00[/TD]
[TD]17,032.00[/TD]
[TD]15,164.00[/TD]
[TD]383.00[/TD]
[TD]254.00[/TD]
[TD]161.00[/TD]
[TD]408.00[/TD]
[TD]456.00[/TD]
[TD]508.00[/TD]
[TD]0.67[/TD]
[TD]0.67[/TD]
[TD]1.00[/TD]
[TD]14.83[/TD]
[TD]14.83[/TD]
[TD]14.00[/TD]
[/TR]
[TR]
[TD]DIVISION C[/TD]
[TD]32.00[/TD]
[TD]14,227.00[/TD]
[TD]16,072.00[/TD]
[TD]18,212.00[/TD]
[TD]457.00[/TD]
[TD]538.00[/TD]
[TD]455.00[/TD]
[TD]445.00[/TD]
[TD]338.00[/TD]
[TD]310.00[/TD]
[TD]2.00[/TD]
[TD]2.00[/TD]
[TD]2.25[/TD]
[TD]15.00[/TD]
[TD]14.00[/TD]
[TD]15.00[/TD]
[/TR]
[TR]
[TD]DIVISION C[/TD]
[TD]33.00[/TD]
[TD]29,829.00[/TD]
[TD]31,008.00[/TD]
[TD]31,004.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]1,392.00[/TD]
[TD]1,308.00[/TD]
[TD]1,293.00[/TD]
[TD]2.00[/TD]
[TD]2.00[/TD]
[TD]2.00[/TD]
[TD]25.83[/TD]
[TD]26.33[/TD]
[TD]26.00[/TD]
[/TR]
[TR]
[TD]DIVISION C[/TD]
[TD]34.00[/TD]
[TD]3,987.00[/TD]
[TD]4,343.00[/TD]
[TD]4,597.00[/TD]
[TD]108.00[/TD]
[TD]10.00[/TD]
[TD]26.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]10.00[/TD]
[TD]10.00[/TD]
[TD]9.00[/TD]
[/TR]
[TR]
[TD]DIVISION C[/TD]
[TD]35.00[/TD]
[TD]3,984.00[/TD]
[TD]4,142.00[/TD]
[TD]3,989.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]1.00[/TD]
[TD]1.50[/TD]
[TD]1.75[/TD]
[TD]2.00[/TD]
[TD]1.50[/TD]
[TD]1.50[/TD]
[/TR]
[TR]
[TD]DIVISION C[/TD]
[TD]36.00[/TD]
[TD]4,268.00[/TD]
[TD]4,256.00[/TD]
[TD]4,110.00[/TD]
[TD]511.00[/TD]
[TD]695.00[/TD]
[TD]645.00[/TD]
[TD]328.00[/TD]
[TD]394.00[/TD]
[TD]385.00[/TD]
[TD]0.50[/TD]
[TD]0.50[/TD]
[TD]0.50[/TD]
[TD]7.50[/TD]
[TD]7.50[/TD]
[TD]7.50[/TD]
[/TR]
[TR]
[TD]DIVISION C[/TD]
[TD]37.00[/TD]
[TD]22,407.00[/TD]
[TD]21,046.00[/TD]
[TD]20,535.00[/TD]
[TD]3.00[/TD]
[TD]0.00[/TD]
[TD]4.00[/TD]
[TD]1,155.00[/TD]
[TD]1,111.00[/TD]
[TD]1,153.00[/TD]
[TD]2.17[/TD]
[TD]2.17[/TD]
[TD]2.17[/TD]
[TD]26.00[/TD]
[TD]24.50[/TD]
[TD]26.50[/TD]
[/TR]
[TR]
[TD]DIVISION C[/TD]
[TD]38.00[/TD]
[TD]6,056.00[/TD]
[TD]6,427.00[/TD]
[TD]5,874.00[/TD]
[TD]2,339.00[/TD]
[TD]2,448.00[/TD]
[TD]2,509.00[/TD]
[TD]310.00[/TD]
[TD]452.00[/TD]
[TD]363.00[/TD]
[TD]6.00[/TD]
[TD]4.00[/TD]
[TD]7.50[/TD]
[TD]10.90[/TD]
[TD]11.00[/TD]
[TD]11.00[/TD]
[/TR]
[TR]
[TD]DIVISION C[/TD]
[TD]39.00[/TD]
[TD]28,735.00[/TD]
[TD]28,143.00[/TD]
[TD]27,320.00[/TD]
[TD]268.00[/TD]
[TD]354.00[/TD]
[TD]274.00[/TD]
[TD]792.00[/TD]
[TD]574.00[/TD]
[TD]677.00[/TD]
[TD]3.00[/TD]
[TD]3.00[/TD]
[TD]3.50[/TD]
[TD]18.50[/TD]
[TD]19.50[/TD]
[TD]18.50[/TD]
[/TR]
[TR]
[TD]DIVISION C[/TD]
[TD]40.00[/TD]
[TD]3,987.00[/TD]
[TD]3,265.00[/TD]
[TD]2,811.00[/TD]
[TD]66.00[/TD]
[TD]135.00[/TD]
[TD]81.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]5.50[/TD]
[TD]4.50[/TD]
[TD]5.50[/TD]
[/TR]
[TR]
[TD]DIVISION C[/TD]
[TD]41.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD]DIVISION D[/TD]
[TD]42.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD][/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]5.00[/TD]
[TD]4.00[/TD]
[TD]5.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[/TR]
[TR]
[TD]DIVISION D[/TD]
[TD]43.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD][/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]5.67[/TD]
[TD]5.34[/TD]
[TD]4.84[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[/TR]
[TR]
[TD]DIVISION D[/TD]
[TD]44.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD][/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]4.50[/TD]
[TD]4.50[/TD]
[TD]4.50[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[/TR]
[TR]
[TD]DIVISION D[/TD]
[TD]45.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD][/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]4.33[/TD]
[TD]4.50[/TD]
[TD]4.67[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[/TR]
[TR]
[TD]DIVISION D[/TD]
[TD]46.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD][/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]1.50[/TD]
[TD]1.50[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[/TR]
[TR]
[TD]DIVISION D[/TD]
[TD]47.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD][/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]2.67[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[/TR]
[TR]
[TD]DIVISION D[/TD]
[TD]48.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD][/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[/TR]
[TR]
[TD]DIVISION D[/TD]
[TD]49.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD][/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]1.00[/TD]
[/TR]
[TR]
[TD]DIVISION D[/TD]
[TD]50.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD][/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]1.00[/TD]
[TD]0.50[/TD]
[TD]0.50[/TD]
[TD]1.00[/TD]
[/TR]
[TR]
[TD]DIVISION D[/TD]
[TD]51.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD][/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[TD]0.00[/TD]
[/TR]
</tbody>[/TABLE]
 
Sort by date Sort by votes
Hi Mattdete,

that's an impressive amount of data, but I'm wondering what you are looking for? What kind of "template" are you looking for? An analysis tool for correlations? I'd happily give some pointers/options, but have a hard time understanding what it is you envision?

Cheers,

Koen
 
Upvote 0
Hi Koen:
Thanks for your help. The purpose is to create a financial model that the Deans of the college can use to determine how the chairman ("chair) of a department should be compensated for the administrative role of managing the department. Currently the chair stipend is 21% of the chair's base salary, but the college wants to consider alternate methodologies for calculating a chair's stipend. I need to consolidate this info and then be able to work with variables to come up with estimates.
 
Upvote 0
i can email you the file too. just to see it. i am trying use a fixed amount to allocate compensation based on percentage, $1M. the issue i am having is i am over-allocating because I am using a base and inflation %. so, i inflate by 1.05% and I am allocating that fixed amount also, which i don't necessarily want to do.
 
Upvote 0
Hi Matt,

bring it on, my email is my forum name followed by @hotmail.com.

Regards,

Koen
 
Upvote 0
You must log in or register to reply here.

Similar threads

H
  • Question Question
multiple criteria Costing
Replies
6
Views
182
harky
H
A
  • Solved
Autonumbering in cell based on last row in column
Replies
2
Views
124
abdo meghari
A
V
  • Solved
Formula to extract automatically allowance value based on two salary and personal deduction scales
Replies
3
Views
169
hagia_sofia
hagia_sofia
A
  • Question Question
VBA Code to copy last worksheet to same worksheet and after copying i need to hide other sheets
Replies
6
Views
141
Logit
Logit
M
  • Solved
combine data in listbox on userform based on another listbox
Replies
3
Views
108
Maklil
M

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top