12 Month rolling/Dynamic Chart

Grepees

Board Regular
Joined
Apr 15, 2009
Messages
81
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p>
Hello Guys,<o:p></o:p>
<o:p> Does anyone have a spreadsheet to send me that i can use as a Model to build a 12-month rolling or dynamic chart with three rolling Line graphs?Its causing me too much headache.</o:p><o:p> Thank you very much.</o:p>
<o:p> </o:p>
<?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 coordsize="21600,21600" o:spt="75" path="m@4@5l@4@11@9@11@9@5xe" stroked="f" filled="f" o:preferrelative="t"><v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><v:path o:extrusionok="f" o:connecttype="rect" gradientshapeok="t"></v:path><o:lock v:ext="edit" aspectratio="t"></o:lock></v:shapetype>
</o:p>
<o:p><v:group id=_x0000_s1028 style="WIDTH: 369.35pt; HEIGHT: 242.2pt; mso-position-horizontal-relative: char; mso-position-vertical-relative: line" coordsize="7387,4844" editas="canvas"> <o:lock v:ext="edit" aspectratio="t"></o:lock><v:shapetype id=_x0000_t75 coordsize="21600,21600" o:spt="75" path="m@4@5l@4@11@9@11@9@5xe" stroked="f" filled="f" o:preferrelative="t"><v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><v:path o:extrusionok="f" o:connecttype="rect" gradientshapeok="t"></v:path><o:lock v:ext="edit" aspectratio="t"></o:lock></v:shapetype><v:shape id=_x0000_s1029 style="WIDTH: 7387px; POSITION: absolute; HEIGHT: 4844px" o:preferrelative="f" type="#_x0000_t75"><v:fill o:detectmouseclick="t"></v:fill><v:path o:extrusionok="t" o:connecttype="none"></v:path><o:lock v:ext="edit" text="t"></o:lock></v:shape><v:line id=_x0000_s1030 style="POSITION: absolute" strokeweight="0" to="822,4152" from="822,929"></v:line><v:line id=_x0000_s1031 style="POSITION: absolute" strokeweight="0" to="867,4152" from="777,4152"></v:line><v:line id=_x0000_s1032 style="POSITION: absolute" strokeweight="0" to="867,3747" from="777,3747"></v:line><v:line id=_x0000_s1033 style="POSITION: absolute" strokeweight="0" to="867,3351" from="777,3351"></v:line><v:line id=_x0000_s1034 style="POSITION: absolute" strokeweight="0" to="867,2946" from="777,2946"></v:line><v:line id=_x0000_s1035 style="POSITION: absolute" strokeweight="0" to="867,2541" from="777,2541"></v:line><v:line id=_x0000_s1036 style="POSITION: absolute" strokeweight="0" to="867,2135" from="777,2135"></v:line><v:line id=_x0000_s1037 style="POSITION: absolute" strokeweight="0" to="867,1740" from="777,1740"></v:line><v:line id=_x0000_s1038 style="POSITION: absolute" strokeweight="0" to="867,1335" from="777,1335"></v:line><v:line id=_x0000_s1039 style="POSITION: absolute" strokeweight="0" to="867,929" from="777,929"></v:line><v:line id=_x0000_s1040 style="POSITION: absolute" strokeweight="0" to="5912,4152" from="822,4152"></v:line><v:line id=_x0000_s1041 style="POSITION: absolute; flip: y" strokeweight="0" to="822,4192" from="822,4112"></v:line><v:line id=_x0000_s1042 style="POSITION: absolute; flip: y" strokeweight="0" to="1284,4192" from="1284,4112"></v:line><v:line id=_x0000_s1043 style="POSITION: absolute; flip: y" strokeweight="0" to="1745,4192" from="1745,4112"></v:line><v:line id=_x0000_s1044 style="POSITION: absolute; flip: y" strokeweight="0" to="2207,4192" from="2207,4112"></v:line><v:line id=_x0000_s1045 style="POSITION: absolute; flip: y" strokeweight="0" to="2669,4192" from="2669,4112"></v:line><v:line id=_x0000_s1046 style="POSITION: absolute; flip: y" strokeweight="0" to="3130,4192" from="3130,4112"></v:line><v:line id=_x0000_s1047 style="POSITION: absolute; flip: y" strokeweight="0" to="3603,4192" from="3603,4112"></v:line><v:line id=_x0000_s1048 style="POSITION: absolute; flip: y" strokeweight="0" to="4065,4192" from="4065,4112"></v:line><v:line id=_x0000_s1049 style="POSITION: absolute; flip: y" strokeweight="0" to="4527,4192" from="4527,4112"></v:line><v:line id=_x0000_s1050 style="POSITION: absolute; flip: y" strokeweight="0" to="4988,4192" from="4988,4112"></v:line><v:line id=_x0000_s1051 style="POSITION: absolute; flip: y" strokeweight="0" to="5450,4192" from="5450,4112"></v:line><v:line id=_x0000_s1052 style="POSITION: absolute; flip: y" strokeweight="0" to="5912,4192" from="5912,4112"></v:line><v:shape id=_x0000_s1053 style="LEFT: 822px; WIDTH: 462px; POSITION: absolute; TOP: 2738px; HEIGHT: 1216px" coordsize="462,1216" path="m,1216l56,1058,113,890,225,554,293,396,349,247,405,109,462,e" filled="f" strokeweight="1.7pt" strokecolor="navy"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1054 style="LEFT: 1284px; WIDTH: 461px; POSITION: absolute; TOP: 2274px; HEIGHT: 464px" coordsize="461,464" path="m,464l112,267r57,-89l225,99,292,39,315,19r34,-9l383,r22,10l439,19r22,30e" filled="f" strokeweight="1.7pt" strokecolor="navy"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1055 style="LEFT: 1745px; WIDTH: 462px; POSITION: absolute; TOP: 2323px; HEIGHT: 1453px" coordsize="462,1453" path="m,l34,40,57,99r33,79l113,267r34,109l169,485r57,227l293,949r23,109l349,1167r23,89l406,1335r22,69l462,1453e" filled="f" strokeweight="1.7pt" strokecolor="navy"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1056 style="LEFT: 2207px; WIDTH: 462px; POSITION: absolute; TOP: 3579px; HEIGHT: 247px" coordsize="462,247" path="m,197r45,30l101,247r57,l225,227r79,-40l360,138,417,79,462,e" filled="f" strokeweight="1.7pt" strokecolor="navy"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1057 style="LEFT: 2669px; WIDTH: 461px; POSITION: absolute; TOP: 1552px; HEIGHT: 2027px" coordsize="461,2027" path="m,2027r34,-79l56,1839,90,1710r22,-148l146,1404r23,-168l225,890,259,722,293,564,315,415,349,277,371,168,405,79,416,49,428,30,450,10,461,e" filled="f" strokeweight="1.7pt" strokecolor="navy"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1058 style="LEFT: 3130px; WIDTH: 473px; POSITION: absolute; TOP: 1552px; HEIGHT: 1779px" coordsize="473,1779" path="m,l12,,34,10,46,30,57,49r34,70l113,218r34,108l181,455r22,148l237,751r56,307l327,1216r34,138l383,1493r34,109l440,1700r33,79e" filled="f" strokeweight="1.7pt" strokecolor="navy"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1059 style="LEFT: 3603px; WIDTH: 462px; POSITION: absolute; TOP: 3331px; HEIGHT: 218px" coordsize="462,218" path="m,l45,70r57,49l169,149r68,20l304,188r57,10l417,208r45,10e" filled="f" strokeweight="1.7pt" strokecolor="navy"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1060 style="LEFT: 822px; WIDTH: 462px; POSITION: absolute; TOP: 3618px; HEIGHT: 218px" coordsize="462,218" path="m,l45,30r56,39l169,119r56,49l293,208r67,10l383,218r34,-10l439,188r23,-30e" filled="f" strokeweight="1.7pt" strokecolor="green"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1061 style="LEFT: 1284px; WIDTH: 461px; POSITION: absolute; TOP: 2106px; HEIGHT: 1670px" coordsize="461,1670" path="m,1670r33,-59l56,1532,90,1423r22,-109l146,1186r23,-138l225,761,259,622,292,484,315,356,349,247r22,-99l405,79,428,19r22,-9l461,e" filled="f" strokeweight="1.7pt" strokecolor="green"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1062 style="LEFT: 1745px; WIDTH: 462px; POSITION: absolute; TOP: 2106px; HEIGHT: 1354px" coordsize="462,1354" path="m,l12,,34,,57,39,90,89r23,79l147,257r22,99l203,464r23,119l293,830r23,119l349,1057r23,99l406,1235r22,70l462,1354e" filled="f" strokeweight="1.7pt" strokecolor="green"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1063 style="LEFT: 2207px; WIDTH: 462px; POSITION: absolute; TOP: 3223px; HEIGHT: 277px" coordsize="462,277" path="m,237r45,30l101,277r57,-10l225,247r79,-50l360,148,417,79,462,e" filled="f" strokeweight="1.7pt" strokecolor="green"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1064 style="LEFT: 2669px; WIDTH: 461px; POSITION: absolute; TOP: 1394px; HEIGHT: 1829px" coordsize="461,1829" path="m,1829r34,-79l56,1651,90,1542r22,-138l146,1265r23,-148l225,811,259,652,293,514,315,385,349,267,371,158,405,79,428,30,450,10,461,e" filled="f" strokeweight="1.7pt" strokecolor="green"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1065 style="LEFT: 3130px; WIDTH: 473px; POSITION: absolute; TOP: 1394px; HEIGHT: 1473px" coordsize="473,1473" path="m,l12,,34,,57,39,91,99r22,79l147,277r34,108l203,514r34,128l293,909r34,129l361,1157r22,98l417,1354r23,69l473,1473e" filled="f" strokeweight="1.7pt" strokecolor="green"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1066 style="LEFT: 3603px; WIDTH: 462px; POSITION: absolute; TOP: 2551px; HEIGHT: 365px" coordsize="462,365" path="m,316r34,30l57,365r33,l113,365r34,-19l169,326r68,-60l293,197r56,-79l406,49,462,e" filled="f" strokeweight="1.7pt" strokecolor="green"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1067 style="LEFT: 4065px; WIDTH: 462px; POSITION: absolute; TOP: 1433px; HEIGHT: 2106px" coordsize="462,2106" path="m,l34,139,56,297,90,455r23,178l169,989r34,178l225,1335r34,158l293,1641r22,139l349,1898r23,89l405,2057r12,19l428,2096r23,10l462,2106e" filled="f" strokeweight="1.7pt" strokecolor="aqua"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1068 style="LEFT: 4527px; WIDTH: 461px; POSITION: absolute; TOP: 1167px; HEIGHT: 2372px" coordsize="461,2372" path="m,2372r11,-10l34,2342r11,-39l56,2263r11,-59l90,2145r11,-79l112,1987r34,-178l169,1611r33,-208l225,1186,259,968,293,761,315,563,349,385r11,-79l371,227r23,-59l405,108,416,69,428,29,450,9,461,e" filled="f" strokeweight="1.7pt" strokecolor="aqua"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1069 style="LEFT: 4988px; WIDTH: 462px; POSITION: absolute; TOP: 1167px; HEIGHT: 2135px" coordsize="462,2135" path="m,l12,,34,9,46,29,57,59,68,98r23,50l113,257r34,138l169,553r34,168l226,899r67,376l316,1453r34,168l372,1789r34,138l428,2046r23,49l462,2135e" filled="f" strokeweight="1.7pt" strokecolor="aqua"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1070 style="LEFT: 5450px; WIDTH: 462px; POSITION: absolute; TOP: 3302px; HEIGHT: 287px" coordsize="462,287" path="m,l45,79r57,59l158,178r67,29l304,237r57,10l417,267r45,20e" filled="f" strokeweight="1.7pt" strokecolor="aqua"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1071 style="LEFT: 4065px; WIDTH: 462px; POSITION: absolute; TOP: 1433px; HEIGHT: 2116px" coordsize="462,2116" path="m,2116l34,1978,56,1829,90,1671r23,-168l169,1167,225,831,259,683,293,534,315,396,349,277r23,-99l405,89,428,30,462,e" filled="f" strokeweight="1.7pt" strokecolor="green"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1072 style="LEFT: 4527px; WIDTH: 461px; POSITION: absolute; TOP: 1424px; HEIGHT: 1463px" coordsize="461,1463" path="m,9l11,,34,,56,29,90,79r22,69l146,237r23,99l202,454r23,129l293,840r22,128l349,1087r22,119l405,1304r23,89l461,1463e" filled="f" strokeweight="1.7pt" strokecolor="green"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1073 style="LEFT: 4988px; WIDTH: 462px; POSITION: absolute; TOP: 2887px; HEIGHT: 435px" coordsize="462,435" path="m,l57,98r56,89l169,276r57,80l293,405r34,20l350,435r33,l406,425r34,-20l462,375e" filled="f" strokeweight="1.7pt" strokecolor="green"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1074 style="LEFT: 5450px; WIDTH: 462px; POSITION: absolute; TOP: 1483px; HEIGHT: 1779px" coordsize="462,1779" path="m,1779r34,-49l56,1661r34,-79l113,1483r34,-99l169,1265r56,-237l293,761,349,494,406,237,428,118,462,e" filled="f" strokeweight="1.7pt" strokecolor="green"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1075 style="LEFT: 4065px; WIDTH: 462px; POSITION: absolute; TOP: 2551px; HEIGHT: 563px" coordsize="462,563" path="m,l113,148,225,306r68,79l349,454r56,60l462,563e" filled="f" strokeweight="1.7pt" strokecolor="#f9c"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1076 style="LEFT: 4527px; WIDTH: 461px; POSITION: absolute; TOP: 3114px; HEIGHT: 217px" coordsize="461,217" path="m,l45,40r56,49l169,138r56,40l293,208r67,9l383,217r33,-19l439,178r22,-30e" filled="f" strokeweight="1.7pt" strokecolor="#f9c"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1077 style="LEFT: 4988px; WIDTH: 462px; POSITION: absolute; TOP: 1483px; HEIGHT: 1779px" coordsize="462,1779" path="m,1779r12,-29l34,1710r23,-89l91,1512r22,-138l147,1236r22,-159l226,761,259,613,293,464,316,336,350,217r22,-99l406,49,417,20,428,10,451,r11,e" filled="f" strokeweight="1.7pt" strokecolor="#f9c"><v:path arrowok="t"></v:path></v:shape><v:shape id=_x0000_s1078 style="LEFT: 5450px; WIDTH: 462px; POSITION: absolute; TOP: 1483px; HEIGHT: 2135px" coordsize="462,2135" path="m,l11,10,34,30,56,79r34,79l113,257r34,119l169,514r34,148l225,820r34,168l293,1166r56,346l372,1680r34,159l428,1997r34,138e" filled="f" strokeweight="1.7pt" strokecolor="#f9c"><v:path arrowok="t"></v:path></v:shape><v:rect id=_x0000_s1079 style="LEFT: 3299px; WIDTH: 630px; POSITION: absolute; TOP: 237px; HEIGHT: 285px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Sales

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1080 style="LEFT: 270px; WIDTH: 330px; POSITION: absolute; TOP: 4073px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">80,000

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1081 style="LEFT: 270px; WIDTH: 330px; POSITION: absolute; TOP: 3668px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">85,000

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1082 style="LEFT: 270px; WIDTH: 330px; POSITION: absolute; TOP: 3272px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">90,000

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1083 style="LEFT: 270px; WIDTH: 330px; POSITION: absolute; TOP: 2867px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">95,000

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1084 style="LEFT: 191px; WIDTH: 390px; POSITION: absolute; TOP: 2462px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">100,000

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1085 style="LEFT: 191px; WIDTH: 390px; POSITION: absolute; TOP: 2056px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">105,000

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1086 style="LEFT: 191px; WIDTH: 390px; POSITION: absolute; TOP: 1661px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">110,000

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1087 style="LEFT: 191px; WIDTH: 390px; POSITION: absolute; TOP: 1255px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">115,000

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1088 style="LEFT: 191px; WIDTH: 390px; POSITION: absolute; TOP: 850px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">120,000

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1089 style="LEFT: 709px; WIDTH: 195px; POSITION: absolute; TOP: 4261px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Nov

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1090 style="LEFT: 1160px; WIDTH: 210px; POSITION: absolute; TOP: 4261px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Dec

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1091 style="LEFT: 1633px; WIDTH: 180px; POSITION: absolute; TOP: 4261px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Jan

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1092 style="LEFT: 2083px; WIDTH: 195px; POSITION: absolute; TOP: 4261px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Feb

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1093 style="LEFT: 2545px; WIDTH: 210px; POSITION: absolute; TOP: 4261px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Mar

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1094 style="LEFT: 3018px; WIDTH: 180px; POSITION: absolute; TOP: 4261px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Apr

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1095 style="LEFT: 3468px; WIDTH: 210px; POSITION: absolute; TOP: 4261px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">May

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1096 style="LEFT: 3952px; WIDTH: 180px; POSITION: absolute; TOP: 4261px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Jun

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1097 style="LEFT: 4437px; WIDTH: 150px; POSITION: absolute; TOP: 4261px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Jul

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1098 style="LEFT: 4865px; WIDTH: 210px; POSITION: absolute; TOP: 4261px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Aug

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1099 style="LEFT: 5326px; WIDTH: 195px; POSITION: absolute; TOP: 4261px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Sep

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1100 style="LEFT: 5799px; WIDTH: 180px; POSITION: absolute; TOP: 4261px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Oct

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1101 style="LEFT: 3119px; WIDTH: 435px; POSITION: absolute; TOP: 4488px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Months

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:rect id=_x0000_s1102 style="LEFT: 6193px; WIDTH: 1081px; POSITION: absolute; TOP: 2125px; HEIGHT: 831px" strokeweight="0"></v:rect><v:line id=_x0000_s1103 style="POSITION: absolute" strokeweight="1.7pt" to="6554,2234" from="6250,2234" strokecolor="navy"></v:line><v:rect id=_x0000_s1104 style="LEFT: 6587px; WIDTH: 270px; POSITION: absolute; TOP: 2155px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">FY10

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:line id=_x0000_s1105 style="POSITION: absolute" strokeweight="1.7pt" to="6554,2442" from="6250,2442" strokecolor="green"></v:line><v:rect id=_x0000_s1106 style="LEFT: 6587px; WIDTH: 465px; POSITION: absolute; TOP: 2363px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">FY11 Act

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:line id=_x0000_s1107 style="POSITION: absolute" strokeweight="1.7pt" to="6554,2649" from="6250,2649" strokecolor="aqua"></v:line><v:rect id=_x0000_s1108 style="LEFT: 6587px; WIDTH: 375px; POSITION: absolute; TOP: 2570px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">Outlook

</TD></TR></TBODY></TABLE></v:textbox></v:rect><v:line id=_x0000_s1109 style="POSITION: absolute" strokeweight="1.7pt" to="6554,2857" from="6250,2857" strokecolor="#f9c"></v:line><v:rect id=_x0000_s1110 style="LEFT: 6587px; WIDTH: 495px; POSITION: absolute; TOP: 2778px; HEIGHT: 150px; mso-wrap-style: none; v-text-anchor: top" stroked="f" filled="f"><v:textbox style="mso-fit-shape-to-text: t" inset="0,0,0,0"><TABLE cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">FY12 Bud

</TD></TR></TBODY></TABLE></v:textbox></v:rect><?xml:namespace prefix = w ns = "urn:schemas-microsoft-com:office:word" /><w:wrap type="none"></w:wrap><w:anchorlock></w:anchorlock></v:group>
</o:p>
<v:shapetype id=_x0000_t75 coordsize="21600,21600" o:spt="75" path="m@4@5l@4@11@9@11@9@5xe" stroked="f" filled="f" o:preferrelative="t"><v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><v:path o:extrusionok="f" o:connecttype="rect" gradientshapeok="t"></v:path><o:lock v:ext="edit" aspectratio="t"></o:lock></v:shapetype><o:p></o:p>
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,224,587
Messages
6,179,736
Members
452,940
Latest member
Lawrenceiow

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