﻿<?xml version="1.0" encoding="utf-8"?>
<CrossTab xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" AppVersion="3.2.1.24871" xmlns="http://www.ajbsystems.net">
  <UserIDLastEdited>AJBSystems</UserIDLastEdited>Does not use any classification variables, so is applicable to all databases. 
Files 1, 2 and 3 must be apportioned correctly, hence the sequence of files is significant.
Variance option must be Period Totals only.<ClassificationVariables /><Columns><CrossTabColumn><OutputColIndex>1</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>010101</ColumnCode><ColumnHeaders>F1~|Jan</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>2</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>021203</ColumnCode><ColumnHeaders>Purchases Feb.</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>3</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SumColumnXAndColumnY</ColumnType><ColumnCode>0102</ColumnCode><ColumnHeaders>Feb First Part</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>4</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>021202</ColumnCode><ColumnHeaders>Demand Feb.</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>5</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>0304</ColumnCode><ColumnHeaders>F1~|Feb</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>6</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>031203</ColumnCode><ColumnHeaders>Purchases Mar.</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>7</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SumColumnXAndColumnY</ColumnType><ColumnCode>0506</ColumnCode><ColumnHeaders>Mar First Part</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>8</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>031202</ColumnCode><ColumnHeaders>Demand Mar.</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>9</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>0708</ColumnCode><ColumnHeaders>F1~|Mar</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>10</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>041203</ColumnCode><ColumnHeaders>Purchases Apr.</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>11</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SumColumnXAndColumnY</ColumnType><ColumnCode>0910</ColumnCode><ColumnHeaders>Apr. First Part</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>12</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>041202</ColumnCode><ColumnHeaders>Demand Apr.</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>13</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>1112</ColumnCode><ColumnHeaders>F1~|Apr</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>14</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>041203</ColumnCode><ColumnHeaders>Purchases May</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>15</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SumColumnXAndColumnY</ColumnType><ColumnCode>1314</ColumnCode><ColumnHeaders>May First Part</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>16</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>051202</ColumnCode><ColumnHeaders>Demand May</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>17</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>1516</ColumnCode><ColumnHeaders>F1~|May</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>18</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>061203</ColumnCode><ColumnHeaders>Purchases Jun.</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>19</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SumColumnXAndColumnY</ColumnType><ColumnCode>1718</ColumnCode><ColumnHeaders>Jun First Part</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>20</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>061202</ColumnCode><ColumnHeaders>Demand Jun.</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>21</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>1920</ColumnCode><ColumnHeaders>F1~|Jun</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>22</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>071203</ColumnCode><ColumnHeaders>Purchases Jul.</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>23</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SumColumnXAndColumnY</ColumnType><ColumnCode>2122</ColumnCode><ColumnHeaders>Jul First Part</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>24</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>071202</ColumnCode><ColumnHeaders>Demand Jul.</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>25</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>2324</ColumnCode><ColumnHeaders>F1~|Jul</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>26</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>081203</ColumnCode><ColumnHeaders>Purchases Aug.</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>27</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SumColumnXAndColumnY</ColumnType><ColumnCode>2526</ColumnCode><ColumnHeaders>Aug First Part</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>28</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>081202</ColumnCode><ColumnHeaders>Demand Aug.</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>29</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>2728</ColumnCode><ColumnHeaders>F1~|Aug</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>30</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>091203</ColumnCode><ColumnHeaders>Purchases Sep.</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>31</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SumColumnXAndColumnY</ColumnType><ColumnCode>2930</ColumnCode><ColumnHeaders>Sep First Part</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>32</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>091202</ColumnCode><ColumnHeaders>Demand Sep.</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>33</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>3132</ColumnCode><ColumnHeaders>F1~|Sep</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>34</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>101203</ColumnCode><ColumnHeaders>Purchases Oct.</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>35</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SumColumnXAndColumnY</ColumnType><ColumnCode>3334</ColumnCode><ColumnHeaders>Oct First Part</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>36</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>101202</ColumnCode><ColumnHeaders>Demand Oct.</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>37</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>3536</ColumnCode><ColumnHeaders>F1~|Oct</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>38</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>111203</ColumnCode><ColumnHeaders>Purchases Nov.</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>39</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SumColumnXAndColumnY</ColumnType><ColumnCode>3738</ColumnCode><ColumnHeaders>Nov First Part</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>40</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>111202</ColumnCode><ColumnHeaders>Demand Nov.</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>41</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>3940</ColumnCode><ColumnHeaders>F1~|Nov</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>42</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>121203</ColumnCode><ColumnHeaders>Purchases Dec.</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>43</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SumColumnXAndColumnY</ColumnType><ColumnCode>4142</ColumnCode><ColumnHeaders>Dec First Part</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>44</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>121202</ColumnCode><ColumnHeaders>Demand Dec.</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>45</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>4344</ColumnCode><ColumnHeaders>F1~|Dec</ColumnHeaders><AdvancedOptions>HiddenColumn</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>46</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>SelectedFileOrPeriod</ColumnType><ColumnCode>010101</ColumnCode><ColumnHeaders>F1~|Jan</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>47</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>0304</ColumnCode><ColumnHeaders>F1~|Feb</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>48</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>0708</ColumnCode><ColumnHeaders>F1~|Mar</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>49</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>1112</ColumnCode><ColumnHeaders>F1~|Apr</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>50</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>1516</ColumnCode><ColumnHeaders>F1~|May</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>51</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>1920</ColumnCode><ColumnHeaders>F1~|Jun</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>52</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>2324</ColumnCode><ColumnHeaders>F1~|Jul</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>53</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>2728</ColumnCode><ColumnHeaders>F1~|Aug</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>54</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>3132</ColumnCode><ColumnHeaders>F1~|Sep</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>55</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>3536</ColumnCode><ColumnHeaders>F1~|Oct</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>56</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>3940</ColumnCode><ColumnHeaders>F1~|Nov</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn><CrossTabColumn><OutputColIndex>57</OutputColIndex><OutputColSign>Add</OutputColSign><ColumnType>VarianceColumnXvsColumnY</ColumnType><ColumnCode>4344</ColumnCode><ColumnHeaders>F1~|Dec</ColumnHeaders><AdvancedOptions>None</AdvancedOptions><ColumnDataType>-1</ColumnDataType></CrossTabColumn></Columns><OutputPercentTotalColumns>false</OutputPercentTotalColumns><OutputTotalsColumns>false</OutputTotalsColumns></CrossTab>