haggybaggy
New Member
- Joined
- May 15, 2011
- Messages
- 2
Hi All,
Newbie here so please be gentle.
I have decided to post my question here as first of all I am a bit of a biff when it comes to Excel and have reached the limit of my understanding. I know there are a lot of other similar questions and answers and like many folks for which I am a member on other forums I get a little fed up when people don't read or search older threads, but if you read a little further you may see why I have posted another 'rolling average' question. Also I have reposted this question as I wanted to change some of the wording, but am unable to delete my original post - sorry
I don't have a great understanding of all the different formula that can be used and get lost real quick when people start talking in other posts and assume a fairly good level of understanding of Excel - that's not me.
Down to the situation - I have been tasked to produced a spreadsheet - (sample of this is attached with fictitious data, but the actual tables are the real ones) that is needed to track the availability and use of a service. The data has to be able to cover 7 days a week, though for the most part only Mon to Fri is ever used. To make things more complex the company are wanting to see lots of averages for each day and week, of which I have managed to do.
The problem comes when I try to create rolling 2 week average of the daily 'availability' and 'Used' average totals (cells O18 and P17 for the first table alpha). This is then going to be an ongoing table that is filled in every week (only shown 2 weeks). At present these cells simply reflect the average for that particular week, not a rolling average of that average.
This then has to be done for 3 different services - alpha, bravo and charlie - keeps things simple by not showing the other two and I realise that the formual for one will be the same for the other two, just different cells.
To compound matters there are occasions where weekends are also used; hence why they are included but for the sample data have been left blank. What I found was that this then gave a 'false' average, as when there is no activity on a weekend or weekday such as a public holiday and therefore no data to input the average was spread out over all days (Mon to Fri) rather than those with actual data - this is what I need - only to average each week for those days used.
Also to make things easy I have labeled the rows and columns, so the one labeledA1 actually is A1
Also before anyone shoots me down, please bear in mind I'm not an Excel professor, just an average guy who has been given a job and is learning as he goes!!!!
As I say I tried to remove the original post but am unable to so don't beat me up please.
<style>table { }.font5 { color: windowtext; font-size: 8pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Arial; }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: windowtext; font-size: 10pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Arial; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl24 { font-size: 12pt; background: none repeat scroll 0% 0% rgb(204, 255, 255); white-space: nowrap; }.xl25 { font-size: 12pt; white-space: nowrap; }.xl26 { white-space: nowrap; }.xl27 { white-space: nowrap; }.xl28 { font-weight: 700; font-family: Arial,sans-serif; white-space: nowrap; }.xl29 { font-size: 12pt; font-weight: 700; font-family: Arial,sans-serif; white-space: nowrap; }.xl30 { background: none repeat scroll 0% 0% rgb(221, 8, 6); white-space: nowrap; }.xl31 { font-size: 12pt; font-weight: 700; font-family: Arial,sans-serif; background: none repeat scroll 0% 0% rgb(221, 8, 6); white-space: nowrap; }.xl32 { font-size: 9pt; white-space: nowrap; }.xl33 { font-size: 9pt; text-align: center; white-space: nowrap; }.xl34 { font-size: 9pt; text-align: center; border-width: 1pt 0.5pt 1pt 1pt; border-style: solid; border-color: windowtext; background: none repeat scroll 0% 0% rgb(204, 255, 255); white-space: nowrap; }.xl35 { font-size: 9pt; text-align: center; border-width: 1pt 0.5pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl36 { font-size: 9pt; text-align: center; border-width: 1pt 1pt 1pt 0.5pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl37 { font-size: 9pt; text-align: center; border-width: 1pt 0.5pt 0.5pt 1pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl38 { font-size: 9pt; text-align: center; border-width: 1pt 1pt 0.5pt 0.5pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl39 { font-size: 9pt; text-align: center; border-width: 1pt 0.5pt 0.5pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl40 { font-size: 9pt; text-align: center; border-width: 0.5pt 0.5pt 0.5pt 1pt; border-style: solid; border-color: windowtext; background: none repeat scroll 0% 0% rgb(204, 255, 255); white-space: nowrap; }.xl41 { font-size: 9pt; text-align: center; border: 0.5pt solid windowtext; white-space: nowrap; }.xl42 { font-size: 9pt; text-align: center; border-width: 1pt medium 0.5pt 0.5pt; border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; white-space: nowrap; }.xl43 { font-size: 9pt; text-align: center; border-width: 0.5pt 0.5pt 0.5pt 1pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl44 { font-size: 9pt; text-align: center; border-width: 0.5pt medium 0.5pt 0.5pt; border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; white-space: nowrap; }.xl45 { font-size: 9pt; text-align: center; border-width: 1pt 0.5pt 0.5pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl46 { font-size: 9pt; text-align: center; background: none repeat scroll 0% 0% rgb(204, 255, 255); white-space: nowrap; }.xl47 { font-size: 9pt; text-align: center; border-width: 0.5pt 0.5pt 1pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl48 { font-size: 9pt; text-align: center; border-width: 0.5pt 0.5pt 1pt 1pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl49 { font-size: 9pt; text-align: center; border-width: 0.5pt 1pt 1pt 0.5pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl50 { font-size: 9pt; background: none repeat scroll 0% 0% rgb(204, 255, 255); white-space: nowrap; }.xl51 { font-size: 9pt; text-align: center; white-space: nowrap; }.xl52 { font-size: 9pt; text-align: center; border-width: medium 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; white-space: nowrap; }.xl53 { font-size: 9pt; text-align: center; border-width: medium 0.5pt 0.5pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; white-space: nowrap; }.xl54 { font-size: 9pt; text-align: center; border-width: medium 1pt 0.5pt 0.5pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; white-space: nowrap; }.xl55 { font-size: 9pt; }.xl56 { font-size: 9pt; text-align: center; white-space: nowrap; }.xl57 { font-size: 9pt; text-align: center; border: 1pt solid windowtext; background: none repeat scroll 0% 0% rgb(252, 243, 5); white-space: nowrap; }.xl58 { font-size: 9pt; text-align: center; border: 1pt solid windowtext; white-space: nowrap; }.xl59 { font-size: 9pt; text-align: center; border-width: 1pt medium 1pt 1pt; border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(204, 255, 255); white-space: nowrap; }.xl60 { font-size: 9pt; text-align: center; border-width: 1pt 0.5pt 1pt 1pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl61 { font-size: 9pt; border-width: medium medium medium 1pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color windowtext; }.xl62 { font-size: 9pt; border-width: medium medium 1pt 1pt; border-style: none none solid solid; border-color: -moz-use-text-color -moz-use-text-color windowtext windowtext; }.xl63 { font-size: 9pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color windowtext; }.xl64 { font-size: 9pt; text-align: center; border-width: 1pt medium 1pt 1pt; border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; white-space: nowrap; }.xl65 { font-size: 9pt; text-align: left; border-width: 1pt medium medium 1pt; border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; }.xl66 { font-size: 9pt; text-align: center; border-width: 1pt medium medium; border-style: solid none none; border-color: windowtext -moz-use-text-color -moz-use-text-color; }.xl67 { font-size: 9pt; text-align: center; border-width: 1pt 1pt medium medium; border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color; }.xl68 { font-size: 9pt; border-width: medium 1pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; }.xl69 { font-size: 9pt; text-align: center; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; }.xl70 { font-size: 9pt; text-align: center; border-width: 1pt 1pt medium; border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; white-space: nowrap; }.xl71 { font-size: 9pt; text-align: center; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; white-space: nowrap; }.xl72 { font-size: 9pt; text-align: left; border-width: medium medium medium 1pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color windowtext; background: none repeat scroll 0% 0% rgb(252, 243, 5); }.xl73 { font-size: 9pt; text-align: center; background: none repeat scroll 0% 0% rgb(252, 243, 5); }.xl74 { font-size: 9pt; text-align: center; border-width: medium 1pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; background: none repeat scroll 0% 0% rgb(252, 243, 5); }.xl75 { font-size: 9pt; text-align: center; border-width: 0.5pt 0.5pt 1pt 1pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl76 { font-size: 9pt; text-align: center; border-width: 0.5pt 0.5pt 1pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl77 { font-size: 9pt; text-align: center; border-width: 0.5pt 1pt 1pt 0.5pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl78 { font-size: 9pt; text-align: center; }.xl79 { font-size: 9pt; text-align: center; border-width: medium 1pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; }.xl80 { }.xl81 { font-size: 9pt; text-align: center; border-width: 0.5pt medium 1pt 0.5pt; border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; white-space: nowrap; }.xl82 { font-size: 9pt; text-align: center; border-width: 0.5pt 0.5pt 1pt 1pt; border-style: solid; border-color: windowtext; background: none repeat scroll 0% 0% rgb(204, 255, 255); white-space: nowrap; }.xl83 { font-size: 9pt; text-align: left; border-width: medium medium medium 1pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color windowtext; }.xl84 { font-size: 9pt; background: none repeat scroll 0% 0% rgb(252, 243, 5); white-space: nowrap; }.xl85 { font-size: 9pt; text-align: center; background: none repeat scroll 0% 0% rgb(252, 243, 5); white-space: nowrap; }.xl86 { background: none repeat scroll 0% 0% rgb(204, 255, 255); white-space: nowrap; }.xl87 { font-size: 9pt; text-align: center; border-width: 1pt medium 1pt 0.5pt; border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; white-space: nowrap; }.xl88 { font-size: 9pt; font-weight: 700; text-align: center; background: none repeat scroll 0% 0% rgb(252, 243, 5); }.xl89 { font-size: 9pt; background: none repeat scroll 0% 0% rgb(252, 243, 5); }.xl90 { font-size: 9pt; text-align: center; border-width: 1pt 0.5pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; white-space: nowrap; }.xl91 { font-size: 9pt; text-align: center; border-width: 1pt medium; border-style: solid none; border-color: windowtext -moz-use-text-color; white-space: nowrap; }ruby { }rt { color: windowtext; font-size: 8pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Arial; display: none; }</style> <table style="border-collapse: collapse;" width="1767" border="0" cellpadding="0" cellspacing="0"> <col width="55"> <col style="" width="117"> <col span="29" width="55"> <tbody><tr height="12"> <td class="xl26" width="55" height="12">A1</td> <td class="xl26" width="117">B1</td> <td class="xl26" width="55">C1</td> <td class="xl26" width="55">D1</td> <td class="xl26" width="55">E1</td> <td class="xl26" width="55">F1</td> <td class="xl26" width="55">G1</td> <td class="xl26" width="55">H1</td> <td class="xl26" width="55">I1</td> <td class="xl26" width="55">J1</td> <td class="xl26" width="55">K1</td> <td class="xl26" width="55">L1</td> <td class="xl26" width="55">M1</td> <td class="xl26" width="55">N1</td> <td class="xl26" width="55">O1</td> <td class="xl26" width="55">P1</td> <td class="xl26" width="55">Q1</td> <td class="xl26" width="55">R1</td> <td class="xl26" width="55">S1</td> <td class="xl26" width="55">T1</td> <td class="xl26" width="55">U1</td> <td class="xl26" width="55">V1</td> <td class="xl26" width="55">W1</td> <td class="xl26" width="55">X1</td> <td class="xl26" width="55">Y1</td> <td class="xl26" width="55">Z1</td> <td class="xl26" width="55">AA1</td> <td class="xl26" width="55">AB1</td> <td class="xl26" width="55">AC1</td> <td class="xl26" width="55">AD1</td> <td class="xl26" width="55">AE1</td> </tr> <tr style="" height="25"> <td class="xl25" height="25">A2</td> <td class="xl29">Week </td> <td class="xl25"></td> <td class="xl24" align="right">25-Apr-11</td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl29"></td> <td class="xl24" align="right">2-May-11</td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> </tr> <tr height="12"> <td class="xl26" height="12">A3</td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> </tr> <tr style="" height="23"> <td class="xl30" height="23">A4</td> <td class="xl31">alpha</td> <td class="xl30"> </td> <td class="xl86"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl86"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> </tr> <tr height="13"> <td class="xl26" height="13">A5</td> <td class="xl26"></td> <td class="xl33"></td> <td colspan="2" class="xl64" style="border-right: 0.5pt solid black;">set 1</td> <td colspan="2" class="xl87" style="border-right: 0.5pt solid black;">set 2</td> <td colspan="2" class="xl87" style="border-right: 0.5pt solid black;">set 3</td> <td colspan="2" class="xl87" style="border-right: 0.5pt solid black;">set 4</td> <td colspan="2" class="xl87">set 5</td> <td class="xl37">Availlable</td> <td class="xl45">Available</td> <td class="xl38">used</td> <td class="xl33"></td> <td colspan="2" class="xl64" style="border-right: 0.5pt solid black;">set 1</td> <td colspan="2" class="xl87" style="border-right: 0.5pt solid black;">set 2</td> <td colspan="2" class="xl87" style="border-right: 0.5pt solid black;">set 3</td> <td colspan="2" class="xl87" style="border-right: 0.5pt solid black;">set 4</td> <td colspan="2" class="xl87">set 5</td> <td class="xl37">Availlable</td> <td class="xl45">Available</td> <td class="xl38">used</td> <td class="xl33"></td> </tr> <tr height="13"> <td class="xl26" height="13">A6</td> <td class="xl26"></td> <td class="xl33"></td> <td class="xl34">Available</td> <td class="xl35">used</td> <td class="xl35">Available</td> <td class="xl35">used</td> <td class="xl35">Available</td> <td class="xl35">used</td> <td class="xl35">Available</td> <td class="xl35">used</td> <td class="xl35">Available</td> <td class="xl87">used</td> <td class="xl48">AVERAGE</td> <td class="xl47">TOTAL</td> <td class="xl49">TOTAL</td> <td class="xl33"></td> <td class="xl34">Available</td> <td class="xl35">used</td> <td class="xl35">Available</td> <td class="xl35">used</td> <td class="xl35">Available</td> <td class="xl35">used</td> <td class="xl35">Available</td> <td class="xl35">used</td> <td class="xl35">Available</td> <td class="xl87">used</td> <td class="xl48">AVERAGE</td> <td class="xl47">TOTAL</td> <td class="xl49">TOTAL</td> <td class="xl33"></td> </tr> <tr height="12"> <td class="xl27" height="12">A7</td> <td class="xl28">Mon</td> <td class="xl51"></td> <td class="xl40">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl39">17 </td> <td class="xl39">16 </td> <td class="xl39">17 </td> <td class="xl42">16 </td> <td class="xl52">17 </td> <td class="xl53">85 </td> <td class="xl54">80 </td> <td class="xl51"></td> <td class="xl40">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl39">17 </td> <td class="xl39">16 </td> <td class="xl39">17 </td> <td class="xl42">16 </td> <td class="xl52">17 </td> <td class="xl53">85 </td> <td class="xl54">80 </td> <td class="xl51"></td> </tr> <tr height="12"> <td class="xl27" height="12">A8</td> <td class="xl28">Tues</td> <td class="xl51"></td> <td class="xl40">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl44">16 </td> <td class="xl43">17 </td> <td class="xl53">85 </td> <td class="xl54">80 </td> <td class="xl51"></td> <td class="xl40">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl44">16 </td> <td class="xl43">17 </td> <td class="xl53">85 </td> <td class="xl54">80 </td> <td class="xl51"></td> </tr> <tr height="12"> <td class="xl27" height="12">A9</td> <td class="xl28">Wed</td> <td class="xl51"></td> <td class="xl40">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl44">16 </td> <td class="xl52">17 </td> <td class="xl53">85 </td> <td class="xl54">80 </td> <td class="xl51"></td> <td class="xl40">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl44">16 </td> <td class="xl52">17 </td> <td class="xl53">85 </td> <td class="xl54">80 </td> <td class="xl51"></td> </tr> <tr height="12"> <td class="xl27" height="12">A10</td> <td class="xl28">Thur</td> <td class="xl51"></td> <td class="xl40">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl44">16 </td> <td class="xl43">17 </td> <td class="xl53">85 </td> <td class="xl54">80 </td> <td class="xl51"></td> <td class="xl40">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl44">16 </td> <td class="xl43">17 </td> <td class="xl53">85 </td> <td class="xl54">80 </td> <td class="xl51"></td> </tr> <tr height="12"> <td class="xl27" height="12">A11</td> <td class="xl28">Fri</td> <td class="xl51"></td> <td class="xl40">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl44">16 </td> <td class="xl52">17 </td> <td class="xl53">85 </td> <td class="xl54">80 </td> <td class="xl51"></td> <td class="xl40">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl44">16 </td> <td class="xl52">17 </td> <td class="xl53">85 </td> <td class="xl54">80 </td> <td class="xl51"></td> </tr> <tr height="12"> <td class="xl27" height="12">A12</td> <td class="xl28">Sat</td> <td class="xl51"></td> <td class="xl40"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl44"> </td> <td class="xl43">#DIV/0!</td> <td class="xl53">0 </td> <td class="xl54">0 </td> <td class="xl51"></td> <td class="xl40"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl44"> </td> <td class="xl43">#DIV/0!</td> <td class="xl53">0 </td> <td class="xl54">0 </td> <td class="xl51"></td> </tr> <tr height="13"> <td class="xl27" height="13">A13</td> <td class="xl28">Sun</td> <td class="xl51"></td> <td class="xl82"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl81"> </td> <td class="xl75">#DIV/0!</td> <td class="xl76">0 </td> <td class="xl77">0 </td> <td class="xl51"></td> <td class="xl82"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl81"> </td> <td class="xl75">#DIV/0!</td> <td class="xl76">0 </td> <td class="xl77">0 </td> <td class="xl51"></td> </tr> <tr height="13"> <td class="xl26" height="13">A14</td> <td class="xl26">Per Set Avg</td> <td class="xl33"></td> <td class="xl59">17.00 </td> <td class="xl64">16.00 </td> <td class="xl60">17.00 </td> <td class="xl35">16.00 </td> <td class="xl35">17.00 </td> <td class="xl35">16.00 </td> <td class="xl35">17.00 </td> <td class="xl35">16.00 </td> <td class="xl35">17.00 </td> <td class="xl36">16.00 </td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl59">17.00 </td> <td class="xl64">16.00 </td> <td class="xl60">17.00 </td> <td class="xl35">16.00 </td> <td class="xl35">17.00 </td> <td class="xl35">16.00 </td> <td class="xl35">17.00 </td> <td class="xl35">16.00 </td> <td class="xl35">17.00 </td> <td class="xl36">16.00 </td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> </tr> <tr height="13"> <td class="xl26" height="13">A15</td> <td class="xl26"></td> <td class="xl33"></td> <td class="xl46"> </td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl46"> </td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> </tr> <tr height="13"> <td class="xl26" height="13">A16</td> <td class="xl26"></td> <td class="xl33"></td> <td class="xl46"> </td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl65" colspan="2">Weekly Totals</td> <td class="xl67"> </td> <td class="xl70">425.00 </td> <td class="xl70">400.00 </td> <td class="xl33"></td> <td class="xl46"> </td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl65" colspan="2">Weekly Totals</td> <td class="xl67"> </td> <td class="xl70">425.00 </td> <td class="xl70">400.00 </td> <td class="xl33"></td> </tr> <tr height="13"> <td class="xl80" colspan="2" height="13">2 Wk Avg Used Rate</td> <td class="xl33"></td> <td class="xl46"> </td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl83"> </td> <td class="xl78"></td> <td class="xl79"> </td> <td class="xl70"> </td> <td class="xl58">57.14 </td> <td class="xl33"></td> <td class="xl46"> </td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl83"> </td> <td class="xl78"></td> <td class="xl79"> </td> <td class="xl70"> </td> <td class="xl58">57.14 </td> <td class="xl33"></td> </tr> <tr height="12"> <td class="xl89" colspan="2" height="12">2 Wk Avg Availability Rate</td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl88"> </td> <td class="xl88"> </td> <td class="xl72"> </td> <td class="xl73"> </td> <td class="xl74"> </td> <td class="xl57">60.71 </td> <td class="xl84"> </td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl88"> </td> <td class="xl88"> </td> <td class="xl72"> </td> <td class="xl73"> </td> <td class="xl74"> </td> <td class="xl57">85.00 </td> <td class="xl84"> </td> <td class="xl85"> </td> </tr> <tr height="13"> <td class="xl26" height="13">A19</td> <td class="xl26"></td> <td class="xl33"></td> <td class="xl50"> </td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl55"></td> <td class="xl55"></td> <td class="xl61" colspan="2">CSA Daily Used Rate</td> <td class="xl68"> </td> <td class="xl58">79.90 </td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl50"> </td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl55"></td> <td class="xl55"></td> <td class="xl61" colspan="2">CSA Daily Used Rate</td> <td class="xl68"> </td> <td class="xl58">79.90 </td> <td class="xl33"></td> <td class="xl33"></td> </tr> <tr height="13"> <td class="xl26" height="13">A20</td> <td class="xl26"></td> <td class="xl33"></td> <td class="xl50"> </td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl55"></td> <td class="xl55"></td> <td class="xl62" colspan="3" style="border-right: 1pt solid black;">% of CSA vs 2 Week Average</td> <td class="xl71">75.99 </td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl50"> </td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl55"></td> <td class="xl55"></td> <td class="xl62" colspan="3" style="border-right: 1pt solid black;">% of CSA vs 2 Week Average</td> <td class="xl71">106.38 </td> <td class="xl33"></td> <td class="xl33"></td> </tr> <tr height="12"> <td class="xl26" height="12">A21</td> <td class="xl26"></td> <td class="xl32"></td> <td class="xl50"> </td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td colspan="2" class="xl55"></td> <td class="xl56"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl50"> </td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> </tr> </tbody></table>
Newbie here so please be gentle.
I have decided to post my question here as first of all I am a bit of a biff when it comes to Excel and have reached the limit of my understanding. I know there are a lot of other similar questions and answers and like many folks for which I am a member on other forums I get a little fed up when people don't read or search older threads, but if you read a little further you may see why I have posted another 'rolling average' question. Also I have reposted this question as I wanted to change some of the wording, but am unable to delete my original post - sorry
I don't have a great understanding of all the different formula that can be used and get lost real quick when people start talking in other posts and assume a fairly good level of understanding of Excel - that's not me.
Down to the situation - I have been tasked to produced a spreadsheet - (sample of this is attached with fictitious data, but the actual tables are the real ones) that is needed to track the availability and use of a service. The data has to be able to cover 7 days a week, though for the most part only Mon to Fri is ever used. To make things more complex the company are wanting to see lots of averages for each day and week, of which I have managed to do.
The problem comes when I try to create rolling 2 week average of the daily 'availability' and 'Used' average totals (cells O18 and P17 for the first table alpha). This is then going to be an ongoing table that is filled in every week (only shown 2 weeks). At present these cells simply reflect the average for that particular week, not a rolling average of that average.
This then has to be done for 3 different services - alpha, bravo and charlie - keeps things simple by not showing the other two and I realise that the formual for one will be the same for the other two, just different cells.
To compound matters there are occasions where weekends are also used; hence why they are included but for the sample data have been left blank. What I found was that this then gave a 'false' average, as when there is no activity on a weekend or weekday such as a public holiday and therefore no data to input the average was spread out over all days (Mon to Fri) rather than those with actual data - this is what I need - only to average each week for those days used.
Also to make things easy I have labeled the rows and columns, so the one labeledA1 actually is A1
Also before anyone shoots me down, please bear in mind I'm not an Excel professor, just an average guy who has been given a job and is learning as he goes!!!!
As I say I tried to remove the original post but am unable to so don't beat me up please.
<style>table { }.font5 { color: windowtext; font-size: 8pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Arial; }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: windowtext; font-size: 10pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Arial; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl24 { font-size: 12pt; background: none repeat scroll 0% 0% rgb(204, 255, 255); white-space: nowrap; }.xl25 { font-size: 12pt; white-space: nowrap; }.xl26 { white-space: nowrap; }.xl27 { white-space: nowrap; }.xl28 { font-weight: 700; font-family: Arial,sans-serif; white-space: nowrap; }.xl29 { font-size: 12pt; font-weight: 700; font-family: Arial,sans-serif; white-space: nowrap; }.xl30 { background: none repeat scroll 0% 0% rgb(221, 8, 6); white-space: nowrap; }.xl31 { font-size: 12pt; font-weight: 700; font-family: Arial,sans-serif; background: none repeat scroll 0% 0% rgb(221, 8, 6); white-space: nowrap; }.xl32 { font-size: 9pt; white-space: nowrap; }.xl33 { font-size: 9pt; text-align: center; white-space: nowrap; }.xl34 { font-size: 9pt; text-align: center; border-width: 1pt 0.5pt 1pt 1pt; border-style: solid; border-color: windowtext; background: none repeat scroll 0% 0% rgb(204, 255, 255); white-space: nowrap; }.xl35 { font-size: 9pt; text-align: center; border-width: 1pt 0.5pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl36 { font-size: 9pt; text-align: center; border-width: 1pt 1pt 1pt 0.5pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl37 { font-size: 9pt; text-align: center; border-width: 1pt 0.5pt 0.5pt 1pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl38 { font-size: 9pt; text-align: center; border-width: 1pt 1pt 0.5pt 0.5pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl39 { font-size: 9pt; text-align: center; border-width: 1pt 0.5pt 0.5pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl40 { font-size: 9pt; text-align: center; border-width: 0.5pt 0.5pt 0.5pt 1pt; border-style: solid; border-color: windowtext; background: none repeat scroll 0% 0% rgb(204, 255, 255); white-space: nowrap; }.xl41 { font-size: 9pt; text-align: center; border: 0.5pt solid windowtext; white-space: nowrap; }.xl42 { font-size: 9pt; text-align: center; border-width: 1pt medium 0.5pt 0.5pt; border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; white-space: nowrap; }.xl43 { font-size: 9pt; text-align: center; border-width: 0.5pt 0.5pt 0.5pt 1pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl44 { font-size: 9pt; text-align: center; border-width: 0.5pt medium 0.5pt 0.5pt; border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; white-space: nowrap; }.xl45 { font-size: 9pt; text-align: center; border-width: 1pt 0.5pt 0.5pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl46 { font-size: 9pt; text-align: center; background: none repeat scroll 0% 0% rgb(204, 255, 255); white-space: nowrap; }.xl47 { font-size: 9pt; text-align: center; border-width: 0.5pt 0.5pt 1pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl48 { font-size: 9pt; text-align: center; border-width: 0.5pt 0.5pt 1pt 1pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl49 { font-size: 9pt; text-align: center; border-width: 0.5pt 1pt 1pt 0.5pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl50 { font-size: 9pt; background: none repeat scroll 0% 0% rgb(204, 255, 255); white-space: nowrap; }.xl51 { font-size: 9pt; text-align: center; white-space: nowrap; }.xl52 { font-size: 9pt; text-align: center; border-width: medium 0.5pt 0.5pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; white-space: nowrap; }.xl53 { font-size: 9pt; text-align: center; border-width: medium 0.5pt 0.5pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; white-space: nowrap; }.xl54 { font-size: 9pt; text-align: center; border-width: medium 1pt 0.5pt 0.5pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; white-space: nowrap; }.xl55 { font-size: 9pt; }.xl56 { font-size: 9pt; text-align: center; white-space: nowrap; }.xl57 { font-size: 9pt; text-align: center; border: 1pt solid windowtext; background: none repeat scroll 0% 0% rgb(252, 243, 5); white-space: nowrap; }.xl58 { font-size: 9pt; text-align: center; border: 1pt solid windowtext; white-space: nowrap; }.xl59 { font-size: 9pt; text-align: center; border-width: 1pt medium 1pt 1pt; border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(204, 255, 255); white-space: nowrap; }.xl60 { font-size: 9pt; text-align: center; border-width: 1pt 0.5pt 1pt 1pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl61 { font-size: 9pt; border-width: medium medium medium 1pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color windowtext; }.xl62 { font-size: 9pt; border-width: medium medium 1pt 1pt; border-style: none none solid solid; border-color: -moz-use-text-color -moz-use-text-color windowtext windowtext; }.xl63 { font-size: 9pt; border-width: medium medium 1pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color windowtext; }.xl64 { font-size: 9pt; text-align: center; border-width: 1pt medium 1pt 1pt; border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; white-space: nowrap; }.xl65 { font-size: 9pt; text-align: left; border-width: 1pt medium medium 1pt; border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; }.xl66 { font-size: 9pt; text-align: center; border-width: 1pt medium medium; border-style: solid none none; border-color: windowtext -moz-use-text-color -moz-use-text-color; }.xl67 { font-size: 9pt; text-align: center; border-width: 1pt 1pt medium medium; border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color; }.xl68 { font-size: 9pt; border-width: medium 1pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; }.xl69 { font-size: 9pt; text-align: center; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; }.xl70 { font-size: 9pt; text-align: center; border-width: 1pt 1pt medium; border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; white-space: nowrap; }.xl71 { font-size: 9pt; text-align: center; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; white-space: nowrap; }.xl72 { font-size: 9pt; text-align: left; border-width: medium medium medium 1pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color windowtext; background: none repeat scroll 0% 0% rgb(252, 243, 5); }.xl73 { font-size: 9pt; text-align: center; background: none repeat scroll 0% 0% rgb(252, 243, 5); }.xl74 { font-size: 9pt; text-align: center; border-width: medium 1pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; background: none repeat scroll 0% 0% rgb(252, 243, 5); }.xl75 { font-size: 9pt; text-align: center; border-width: 0.5pt 0.5pt 1pt 1pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl76 { font-size: 9pt; text-align: center; border-width: 0.5pt 0.5pt 1pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl77 { font-size: 9pt; text-align: center; border-width: 0.5pt 1pt 1pt 0.5pt; border-style: solid; border-color: windowtext; white-space: nowrap; }.xl78 { font-size: 9pt; text-align: center; }.xl79 { font-size: 9pt; text-align: center; border-width: medium 1pt medium medium; border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; }.xl80 { }.xl81 { font-size: 9pt; text-align: center; border-width: 0.5pt medium 1pt 0.5pt; border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; white-space: nowrap; }.xl82 { font-size: 9pt; text-align: center; border-width: 0.5pt 0.5pt 1pt 1pt; border-style: solid; border-color: windowtext; background: none repeat scroll 0% 0% rgb(204, 255, 255); white-space: nowrap; }.xl83 { font-size: 9pt; text-align: left; border-width: medium medium medium 1pt; border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color windowtext; }.xl84 { font-size: 9pt; background: none repeat scroll 0% 0% rgb(252, 243, 5); white-space: nowrap; }.xl85 { font-size: 9pt; text-align: center; background: none repeat scroll 0% 0% rgb(252, 243, 5); white-space: nowrap; }.xl86 { background: none repeat scroll 0% 0% rgb(204, 255, 255); white-space: nowrap; }.xl87 { font-size: 9pt; text-align: center; border-width: 1pt medium 1pt 0.5pt; border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; white-space: nowrap; }.xl88 { font-size: 9pt; font-weight: 700; text-align: center; background: none repeat scroll 0% 0% rgb(252, 243, 5); }.xl89 { font-size: 9pt; background: none repeat scroll 0% 0% rgb(252, 243, 5); }.xl90 { font-size: 9pt; text-align: center; border-width: 1pt 0.5pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; white-space: nowrap; }.xl91 { font-size: 9pt; text-align: center; border-width: 1pt medium; border-style: solid none; border-color: windowtext -moz-use-text-color; white-space: nowrap; }ruby { }rt { color: windowtext; font-size: 8pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Arial; display: none; }</style> <table style="border-collapse: collapse;" width="1767" border="0" cellpadding="0" cellspacing="0"> <col width="55"> <col style="" width="117"> <col span="29" width="55"> <tbody><tr height="12"> <td class="xl26" width="55" height="12">A1</td> <td class="xl26" width="117">B1</td> <td class="xl26" width="55">C1</td> <td class="xl26" width="55">D1</td> <td class="xl26" width="55">E1</td> <td class="xl26" width="55">F1</td> <td class="xl26" width="55">G1</td> <td class="xl26" width="55">H1</td> <td class="xl26" width="55">I1</td> <td class="xl26" width="55">J1</td> <td class="xl26" width="55">K1</td> <td class="xl26" width="55">L1</td> <td class="xl26" width="55">M1</td> <td class="xl26" width="55">N1</td> <td class="xl26" width="55">O1</td> <td class="xl26" width="55">P1</td> <td class="xl26" width="55">Q1</td> <td class="xl26" width="55">R1</td> <td class="xl26" width="55">S1</td> <td class="xl26" width="55">T1</td> <td class="xl26" width="55">U1</td> <td class="xl26" width="55">V1</td> <td class="xl26" width="55">W1</td> <td class="xl26" width="55">X1</td> <td class="xl26" width="55">Y1</td> <td class="xl26" width="55">Z1</td> <td class="xl26" width="55">AA1</td> <td class="xl26" width="55">AB1</td> <td class="xl26" width="55">AC1</td> <td class="xl26" width="55">AD1</td> <td class="xl26" width="55">AE1</td> </tr> <tr style="" height="25"> <td class="xl25" height="25">A2</td> <td class="xl29">Week </td> <td class="xl25"></td> <td class="xl24" align="right">25-Apr-11</td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl29"></td> <td class="xl24" align="right">2-May-11</td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> <td class="xl25"></td> </tr> <tr height="12"> <td class="xl26" height="12">A3</td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> <td class="xl26"></td> </tr> <tr style="" height="23"> <td class="xl30" height="23">A4</td> <td class="xl31">alpha</td> <td class="xl30"> </td> <td class="xl86"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl86"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> <td class="xl30"> </td> </tr> <tr height="13"> <td class="xl26" height="13">A5</td> <td class="xl26"></td> <td class="xl33"></td> <td colspan="2" class="xl64" style="border-right: 0.5pt solid black;">set 1</td> <td colspan="2" class="xl87" style="border-right: 0.5pt solid black;">set 2</td> <td colspan="2" class="xl87" style="border-right: 0.5pt solid black;">set 3</td> <td colspan="2" class="xl87" style="border-right: 0.5pt solid black;">set 4</td> <td colspan="2" class="xl87">set 5</td> <td class="xl37">Availlable</td> <td class="xl45">Available</td> <td class="xl38">used</td> <td class="xl33"></td> <td colspan="2" class="xl64" style="border-right: 0.5pt solid black;">set 1</td> <td colspan="2" class="xl87" style="border-right: 0.5pt solid black;">set 2</td> <td colspan="2" class="xl87" style="border-right: 0.5pt solid black;">set 3</td> <td colspan="2" class="xl87" style="border-right: 0.5pt solid black;">set 4</td> <td colspan="2" class="xl87">set 5</td> <td class="xl37">Availlable</td> <td class="xl45">Available</td> <td class="xl38">used</td> <td class="xl33"></td> </tr> <tr height="13"> <td class="xl26" height="13">A6</td> <td class="xl26"></td> <td class="xl33"></td> <td class="xl34">Available</td> <td class="xl35">used</td> <td class="xl35">Available</td> <td class="xl35">used</td> <td class="xl35">Available</td> <td class="xl35">used</td> <td class="xl35">Available</td> <td class="xl35">used</td> <td class="xl35">Available</td> <td class="xl87">used</td> <td class="xl48">AVERAGE</td> <td class="xl47">TOTAL</td> <td class="xl49">TOTAL</td> <td class="xl33"></td> <td class="xl34">Available</td> <td class="xl35">used</td> <td class="xl35">Available</td> <td class="xl35">used</td> <td class="xl35">Available</td> <td class="xl35">used</td> <td class="xl35">Available</td> <td class="xl35">used</td> <td class="xl35">Available</td> <td class="xl87">used</td> <td class="xl48">AVERAGE</td> <td class="xl47">TOTAL</td> <td class="xl49">TOTAL</td> <td class="xl33"></td> </tr> <tr height="12"> <td class="xl27" height="12">A7</td> <td class="xl28">Mon</td> <td class="xl51"></td> <td class="xl40">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl39">17 </td> <td class="xl39">16 </td> <td class="xl39">17 </td> <td class="xl42">16 </td> <td class="xl52">17 </td> <td class="xl53">85 </td> <td class="xl54">80 </td> <td class="xl51"></td> <td class="xl40">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl39">17 </td> <td class="xl39">16 </td> <td class="xl39">17 </td> <td class="xl42">16 </td> <td class="xl52">17 </td> <td class="xl53">85 </td> <td class="xl54">80 </td> <td class="xl51"></td> </tr> <tr height="12"> <td class="xl27" height="12">A8</td> <td class="xl28">Tues</td> <td class="xl51"></td> <td class="xl40">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl44">16 </td> <td class="xl43">17 </td> <td class="xl53">85 </td> <td class="xl54">80 </td> <td class="xl51"></td> <td class="xl40">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl44">16 </td> <td class="xl43">17 </td> <td class="xl53">85 </td> <td class="xl54">80 </td> <td class="xl51"></td> </tr> <tr height="12"> <td class="xl27" height="12">A9</td> <td class="xl28">Wed</td> <td class="xl51"></td> <td class="xl40">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl44">16 </td> <td class="xl52">17 </td> <td class="xl53">85 </td> <td class="xl54">80 </td> <td class="xl51"></td> <td class="xl40">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl44">16 </td> <td class="xl52">17 </td> <td class="xl53">85 </td> <td class="xl54">80 </td> <td class="xl51"></td> </tr> <tr height="12"> <td class="xl27" height="12">A10</td> <td class="xl28">Thur</td> <td class="xl51"></td> <td class="xl40">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl44">16 </td> <td class="xl43">17 </td> <td class="xl53">85 </td> <td class="xl54">80 </td> <td class="xl51"></td> <td class="xl40">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl44">16 </td> <td class="xl43">17 </td> <td class="xl53">85 </td> <td class="xl54">80 </td> <td class="xl51"></td> </tr> <tr height="12"> <td class="xl27" height="12">A11</td> <td class="xl28">Fri</td> <td class="xl51"></td> <td class="xl40">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl44">16 </td> <td class="xl52">17 </td> <td class="xl53">85 </td> <td class="xl54">80 </td> <td class="xl51"></td> <td class="xl40">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl41">16 </td> <td class="xl41">17 </td> <td class="xl44">16 </td> <td class="xl52">17 </td> <td class="xl53">85 </td> <td class="xl54">80 </td> <td class="xl51"></td> </tr> <tr height="12"> <td class="xl27" height="12">A12</td> <td class="xl28">Sat</td> <td class="xl51"></td> <td class="xl40"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl44"> </td> <td class="xl43">#DIV/0!</td> <td class="xl53">0 </td> <td class="xl54">0 </td> <td class="xl51"></td> <td class="xl40"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl41"> </td> <td class="xl44"> </td> <td class="xl43">#DIV/0!</td> <td class="xl53">0 </td> <td class="xl54">0 </td> <td class="xl51"></td> </tr> <tr height="13"> <td class="xl27" height="13">A13</td> <td class="xl28">Sun</td> <td class="xl51"></td> <td class="xl82"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl81"> </td> <td class="xl75">#DIV/0!</td> <td class="xl76">0 </td> <td class="xl77">0 </td> <td class="xl51"></td> <td class="xl82"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl76"> </td> <td class="xl81"> </td> <td class="xl75">#DIV/0!</td> <td class="xl76">0 </td> <td class="xl77">0 </td> <td class="xl51"></td> </tr> <tr height="13"> <td class="xl26" height="13">A14</td> <td class="xl26">Per Set Avg</td> <td class="xl33"></td> <td class="xl59">17.00 </td> <td class="xl64">16.00 </td> <td class="xl60">17.00 </td> <td class="xl35">16.00 </td> <td class="xl35">17.00 </td> <td class="xl35">16.00 </td> <td class="xl35">17.00 </td> <td class="xl35">16.00 </td> <td class="xl35">17.00 </td> <td class="xl36">16.00 </td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl59">17.00 </td> <td class="xl64">16.00 </td> <td class="xl60">17.00 </td> <td class="xl35">16.00 </td> <td class="xl35">17.00 </td> <td class="xl35">16.00 </td> <td class="xl35">17.00 </td> <td class="xl35">16.00 </td> <td class="xl35">17.00 </td> <td class="xl36">16.00 </td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> </tr> <tr height="13"> <td class="xl26" height="13">A15</td> <td class="xl26"></td> <td class="xl33"></td> <td class="xl46"> </td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl46"> </td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> </tr> <tr height="13"> <td class="xl26" height="13">A16</td> <td class="xl26"></td> <td class="xl33"></td> <td class="xl46"> </td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl65" colspan="2">Weekly Totals</td> <td class="xl67"> </td> <td class="xl70">425.00 </td> <td class="xl70">400.00 </td> <td class="xl33"></td> <td class="xl46"> </td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl65" colspan="2">Weekly Totals</td> <td class="xl67"> </td> <td class="xl70">425.00 </td> <td class="xl70">400.00 </td> <td class="xl33"></td> </tr> <tr height="13"> <td class="xl80" colspan="2" height="13">2 Wk Avg Used Rate</td> <td class="xl33"></td> <td class="xl46"> </td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl83"> </td> <td class="xl78"></td> <td class="xl79"> </td> <td class="xl70"> </td> <td class="xl58">57.14 </td> <td class="xl33"></td> <td class="xl46"> </td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl83"> </td> <td class="xl78"></td> <td class="xl79"> </td> <td class="xl70"> </td> <td class="xl58">57.14 </td> <td class="xl33"></td> </tr> <tr height="12"> <td class="xl89" colspan="2" height="12">2 Wk Avg Availability Rate</td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl88"> </td> <td class="xl88"> </td> <td class="xl72"> </td> <td class="xl73"> </td> <td class="xl74"> </td> <td class="xl57">60.71 </td> <td class="xl84"> </td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl85"> </td> <td class="xl88"> </td> <td class="xl88"> </td> <td class="xl72"> </td> <td class="xl73"> </td> <td class="xl74"> </td> <td class="xl57">85.00 </td> <td class="xl84"> </td> <td class="xl85"> </td> </tr> <tr height="13"> <td class="xl26" height="13">A19</td> <td class="xl26"></td> <td class="xl33"></td> <td class="xl50"> </td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl55"></td> <td class="xl55"></td> <td class="xl61" colspan="2">CSA Daily Used Rate</td> <td class="xl68"> </td> <td class="xl58">79.90 </td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl50"> </td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl55"></td> <td class="xl55"></td> <td class="xl61" colspan="2">CSA Daily Used Rate</td> <td class="xl68"> </td> <td class="xl58">79.90 </td> <td class="xl33"></td> <td class="xl33"></td> </tr> <tr height="13"> <td class="xl26" height="13">A20</td> <td class="xl26"></td> <td class="xl33"></td> <td class="xl50"> </td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl55"></td> <td class="xl55"></td> <td class="xl62" colspan="3" style="border-right: 1pt solid black;">% of CSA vs 2 Week Average</td> <td class="xl71">75.99 </td> <td class="xl33"></td> <td class="xl33"></td> <td class="xl50"> </td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl55"></td> <td class="xl55"></td> <td class="xl62" colspan="3" style="border-right: 1pt solid black;">% of CSA vs 2 Week Average</td> <td class="xl71">106.38 </td> <td class="xl33"></td> <td class="xl33"></td> </tr> <tr height="12"> <td class="xl26" height="12">A21</td> <td class="xl26"></td> <td class="xl32"></td> <td class="xl50"> </td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td colspan="2" class="xl55"></td> <td class="xl56"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl50"> </td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> <td class="xl32"></td> </tr> </tbody></table>
