hey there right_click,
neither workbook is in real time. the cell to be populated will be on a monthly basis around the tenth of each month.
the process is thus: we receive the fuel report from an external agency. the figure for last month is copied and pasted into a spreadsheet next to the previous months. After this is done, the movement between the two months is calculated and applied to the previous month's fuel price for that operator. The MS Query simply brings in the number of litres used this month by that operator so that we can multiply the price by the volume.
its simple enough to do manually, except I am more than a little bored with others not checking they have the correct month's data before we make our payments.
would more specific details help? the trigger cell(s) are in a workbook called "Key Factors" on the "Indicies" tab. they occupy row 8 across the page, entitled "Fueltrac Index value".
<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="2">
<tr>
<td valign="top"><font face="Tahoma" size="2"><nobr>Month and Year - (white text)</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>July 2004</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>August 2004</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>September 2004</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>October 2004</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>November 2004</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>December 2004</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>January 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>February 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>March 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>April 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>May 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>June 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>July 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>August 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>September 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>October 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>November 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>December 2005</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>January 2006</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>February 2006</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>March 2006</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>April 2006</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>May 2006</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>June 2006</nobr></font></td>
<td valign="top"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>July 2006</nobr></font></td>
</tr>
<tr>
<td bgcolor="#CCFFCC" valign="top"><font face="Tahoma" size="2"><nobr>Current Year</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td valign="top"><font face="Tahoma" size="2"><nobr>Fuel change- from previous month</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>0.0301%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>6.7528%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>3.0314%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>2.7601%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>0.0000%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>-6.9409%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>-1.0002%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>2.4247%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>7.9380%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>3.8381%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>-4.5512%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>5.0667%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>2.6243%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>0.7085%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>5.9114%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>0.3130%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>-7.0863%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>-0.8847%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>6.4799%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>2.2588%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>1.6624%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>4.7114%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>1.6115%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>-1.0105%</nobr></font></td>
</tr>
<tr>
<td valign="top"><font face="Tahoma" size="2"><nobr>Month number</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>13</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>14</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>15</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>16</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>17</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>18</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>19</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>20</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>21</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>22</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>23</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>24</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>25</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>26</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>27</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>28</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>29</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>30</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>31</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>32</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>33</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>34</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>35</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>36</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>37</nobr></font></td>
</tr>
<tr>
<td bgcolor="#800080" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>MONTH</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>July</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>August</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>September</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>October</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>November</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>December</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>January</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>February</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>March</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>April</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>May</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>June</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>July</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>August</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>September</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>October</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>November</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>December</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>January</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>February</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>March</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>April</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>May</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>June</nobr></font></td>
<td bgcolor="#800080" align="center" valign="bottom"><font face="Tahoma" size="2" color="#FFFFFF"><nobr>July</nobr></font></td>
</tr>
<tr>
<td bgcolor="#C0C0C0" valign="bottom"><font face="Tahoma" size="2"><nobr>Year</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2004</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2004</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2004</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2004</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2004</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2004</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2005</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2006</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2006</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2006</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2006</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2006</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2006</nobr></font></td>
<td bgcolor="#C0C0C0" align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2006</nobr></font></td>
</tr>
<tr>
<td bgcolor="#FFFF99" valign="top"><font face="Tahoma" size="2"><nobr>FUELtrac index value</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>99.81</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>106.55</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>109.78</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>112.81</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>112.81</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>104.98</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>103.93</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>106.45</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>114.90</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>119.31</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>113.88</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>119.65</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>122.79</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>123.66</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>130.97</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>131.38</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>122.07</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>120.99</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>128.83</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>131.74</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>133.93</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>140.24</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>142.50</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>141.06</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>138.55</nobr></font></td>
</tr>
<tr>
<td bgcolor="#FFFF99" valign="top"><font face="Tahoma" size="2"><nobr>FUELtrac - % change from July 2004</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>0.00%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>0.03%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>6.78%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>10.02%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>13.06%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>13.06%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>5.21%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>4.16%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>6.68%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>15.15%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>19.57%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>14.13%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>19.91%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>23.06%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>23.93%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>31.26%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>31.67%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>22.34%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>21.26%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>29.11%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>32.03%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>34.23%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>40.55%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>42.81%</nobr></font></td>
<td align="right" valign="top"><font face="Tahoma" size="2"><nobr>41.37%</nobr></font></td>
</tr>
</table>
The query to be refreshed in the other workbook is called "Fuel Adjustment Total Litres - west"