This page shows room costs for all groups (except those that are 'OUT' or in GL's home) by term and for the year. Initially sorted by Venue code, there is a subtotal row at the end of each Venue section. Groups with zero cost are not shown by default but can be seen by clicking 'Show zero cost groups' button. To see totals for Venues only click 'Show only total rows'.
The table can be sorted on any column by clicking the column heading - click again to reverse the sort order. As an example, click 'Total cost' column (on right) to show groups in order of cost. The sorted column and the order are indicated by a small up/down arrow above the column heading (on initial page load it is above the 'Venue' column). The subtotal rows are removed when the table is sorted by anything other than 'Venue' as they become meaningless - restore them by clicking on the 'Venue' column heading.
The information is picked up from the groups, locations and room tables. In particular, if the 'attendees' field on the groups table has been populated (eg after the return of class log sheets in December) then the 'Cost per attendee' column (on right) will be populated.

Note that the 'Groups in error' button will appear in red if any groups have identifiable errors. If any groups are not processed at all, it is noted at the end of the page.
                   

Christchurch U3A Room Costs for 17_18 year

StudyGroupNameVenueRoomTimeDayFrequencyNo. termsattendeesNo. unitsCost unitAut. £ /MtgAut. # MtgsAut. cost £Spr. £ /MtgSpr. # MtgsSpr. cost £Sum. £ /MtgSum. # MtgsSum. cost £Total # MtgsTotal cost £Cost per attendee
Badminton - Group 1*BCCGym 10.00 - 11.30amTuesdayWeekly 301session£22.1112£265.32£22.1110£221.1£22.1112£265.3234£751.74 
Badminton - Group 3BCCGym10.00 - 12.00 noonThursdayWeekly 301session£22.1112£265.32£22.1110£221.1£22.1112£265.3234£751.74 
Short Tennis*BCCGym2.00 - 4.00pmFridayWeekly 301session£22.1112£265.32£22.1110£221.1£22.1110£221.132£707.52 
Table Tennis - Group 1*BCCHall10.00 - 12 noonMondayWeekly 301session£19.5312£234.36£19.5310£195.3£19.5312£234.3634£664.02 
Table Tennis - Group 2*BCCHall9.30 - 11.30amWednesdayWeekly 301session£19.5312£234.36£19.5310£195.3£19.5312£234.3634£664.02 
Table Tennis - Group 3*BCCHall11.30 - 1.30pmWednesdayWeekly 301session£19.5312£234.36£19.5310£195.3£19.5312£234.3634£664.02 
Table Tennis - Group 4*BCCHall1.00 - 3.00pmFridayWeekly 301session£19.5312£234.36£19.5310£195.3£19.5312£234.3634£664.02 
Table Tennis - Group 5BCCHall12.00 - 2.00pmThursdayWeekly 301session£19.5312£234.36£19.5310£195.3£19.5312£234.3634£664.02 
Travel - Group E BCCRoom 210.30 - 12.00 noonFridayFortnightly 301session£116£66£115£55£116£6617£187 
Beginners Bridge *BCCRoom 412.00 - 1.00pmTuesdayWeekly 301session£1112£132£1110£110£1112£13234£374 
Craft Group*BCCRoom 410.00 - 12 noonMondayWeekly 301session£1112£132£1110£110£1112£13234£374 
Flower Arranging*BCCRoom 410.00-12.00 noonFridayFortnightly 201session£116£66£115£55£110£011£121 
Improvers Bridge*BCCRoom 41.30 - 3.30pmTuesdayWeekly 301session£1112£132£1110£110£1112£13234£374 
Whist Club*BCCRoom 410.15 - 12.15pmThursdayWeekly 201session£1112£132£1110£110£110£022£242 
Drawing and Mixed Media*BCCRoom 82.00 - 4.00pmTuesdayWeekly 301session£1112£132£1110£110£1112£13234£374 
Needles and Pins*BCCRoom 810.00 - 12 noonThursdayFortnightly 301session£116£66£115£55£116£6617£187 
Spanish - The Real Thing*BCCRoom 81.30 - 3.30pmWednesdayWeekly 301session£1112£132£1110£110£1112£13234£374 
Cryptic Crosswords for Improvers*BCCRoom 910.15 - 12.15amMondayWeekly 301session£1112£132£1110£110£1112£13234£374 
Costs for BCC 198£3089.76 165£2574.8 178£2847.54541£8512.1 
For use of kitchen for CCL £5.00 £5.00
French Films*CCLRoom 12.00 - 4.30pmThursdayOnce a term 301session£201£20£201£20£201£203£60 
French RestartedCCLRoom 110.00 - 12 noonThursdayWeekly 301session£2012£240£2010£200£2012£24034£680 
French Supplement*CCLRoom 12.00 - 4.00pmThursdayWeekly 301session£2012£240£2010£200£2012£24034£680 
Meteorology*CCLRoom 110.00 - 12 noonFridayWeekly 101session£2010£200£200£0£200£010£200 
Enjoying ArtCCLRoom 22.00 - 4.00pmTuesdayFortnightly 201session£206£120£205£100£200£011£220 
Reading - Group 1*CCLRoom 310.15 - 11.45amMondayFortnightly 301session£206£120£205£100£206£12017£340 
Costs for CCL 47£945 31£620 31£620109£2185 
Portrait Drawing*CTS2.00 - 4.00pmThursdayFortnightly 201£86£48£85£40£80£011£88 
Costs for CTS 6£48 5£40 0£011£88 
Members pay an extra small charge on top of their membership for EDB £ £
Indoor Bowls - Group 2*EDBBowls Hall1.30 - 3.30pmTuesdayWeekly 201session£3012£360£3010£300£300£022£660 
Indoor Bowls for Improvers - Group 1 *EDBBowls Hall 11.30 - 1.30pmWednesdayWeekly 201session£3012£360£3010£300£300£022£660 
Costs for EDB 24£720 20£600 0£044£1320 
Advanced German Conversation*EPI12.30-2.30pmTuesdayweekly 201session£06£0£010£0£00£016£0 
Teach And Play Chess*EPI10.15 - 12.00 noonMondayFortnightly 301session£06£0£05£0£05£016£0 
Basic German Conversation*EPI10.00 - 12 noon.TuesdayWeekly 201session£08£0£010£0£00£018£0 
Exploring Maths*EPI10.30 - 12 noonThursdayFortnightly 301session£06£0£05£0£06£017£0 
French Improvers*EPI2.00 - 4.00pmThursdayFortnightly 201session£06£0£05£0£00£011£0 
Maths is Fun!*EPI10.15 - 11.45amWednesdayFortnightly 201session£06£0£05£0£00£011£0 
Costs for EPI 38£0 40£0 11£089£0 
Annual charge for GCC £20.00 £20.00
Creative Writing*GCCSitting Room2.00 - 4.00pmThursdayFortnightly 301session£10.56£63£10.55£52.5£10.56£6317£178.5 
Costs for GCC 6£83 5£52.5 6£6317£198.5 
Mini Bodyworks*GHSNot allocated3.00 - 4.00pmMondayWeekly 201£012£0£010£0£00£022£0 
Costs for GHS 12£0 10£0 0£022£0 
Active BodyworksHCCHall10.00 - 11.00amMondayWeekly 301session£1512£180£1510£150£1512£18034£510 
Costs for HCC 12£180 10£150 12£18034£510 
Play ReadingHCH2.00 - 4.00pmWednesdayFortnightly 201session£126£72£125£60£120£011£132 
Costs for HCH 6£72 5£60 0£011£132 
Small charge made for activity  for HHCʣʣ
Sailing*HHC6.00 - 8-30pmWednesdayWeekly 301£012£0£010£0£012£034£0 
Costs for HHC 12£0 10£0 12£034£0 
ipad 1 for Beginners*ICHHall2.30pm to 4.00pmThursdayWeekly 101session£14.5511£160.05£14.550£0£14.550£011£160.05 
Laptops for Beginners/Improvers *ICHHall1.00 - 2.30pmThursdayWeekly 101session£14.5512£174.6£14.550£0£14.550£012£174.6 
Costs for ICH 23£334.65 0£0 0£023£334.65 
Badminton - Group 2*MWCHall12.00 - 1.30pmTuesdayWeekly 301session£19.412£232.8£19.410£194£19.412£232.834£659.6 
Short Mat Bowls - Group 1*MWCHall2.00 - 4.00pmThursdayFortnightly 301session£19.46£116.4£19.45£97£19.46£116.417£329.8 
Short Mat Bowls - Group 2*MWCHall2.00 - 4.00pmThursdayFortnightly 301session£19.46£116.4£19.45£97£19.46£116.417£329.8 
Short Mat Bowls - Group 3*MWCHall2.00 - 4.00pmTuesdayFortnightly 301session£19.46£116.4£19.45£97£19.46£116.417£329.8 
Short Mat Bowls - Group 4*MWCHall2.00 - 4.00pmTuesdayFortnightly 301session£19.46£116.4£19.45£97£19.46£116.417£329.8 
Creative Card Making*MWCRoom 12.00 - 4.00pmTuesdayFortnightly 301session£9.46£56.4£9.45£47£9.46£56.417£159.8 
Musicals and their Songwriters*MWCRoom 110.30 - 12.30pmFridayFortnightly 201session£9.46£56.4£9.45£47£9.40£011£103.4 
Opera DVDs*MWCRoom 19.45 - 11.45amTuesdayWeekly 201session£9.412£112.8£9.410£94£9.40£022£206.8 
Third Age Films*MWCRoom 12.00 - 4.00pmWednesdayWeekly 301session£9.412£112.8£9.410£94£9.412£112.834£319.6 
U3A Christchurch Photography GroupMWCRoom 110.30 - 12.30pmFridayMeet weekly, Fridays, throughout year. 1 301session£9.412£112.8£9.410£94£9.412£112.834£319.6 
Play Tennis for Fun - Group 1*MWCTennis Courts10.30 - 12.30pmWednesdayWeekly 201session£612£72£60£0£012£024£72 
Costs for MWC 96£1221.6 70£958 78£980.4244£3160 
Christchurch U3A Singers*NCHHall10.15 - 12.15pmMondayWeekly 302hour£2812£336£2810£280£2812£33634£952 
International Folk Dancing - Advanced*NCHHall11.15 - 12.15pmThursdayWeekly 301hour£1412£168£1410£140£1412£16834£476 
International Folk Dancing - Beginners and Improvers*NCHHall10.15 - 11.15amThursdayWeekly 301hour£1412£168£1410£140£1412£16834£476 
Singing For Fun*NCHHall2.00 - 4.00pmThursdayWeekly 302hour£2812£336£2810£280£2812£33634£952 
U3A Line Dancing *NCHNot allocated2.00 - 4.00pmMondayWeekly 201£012£0£010£0£00£022£0 
Indoor Board and Card Games Group 1NCHRoom2.00 - 4.00pmWednesdayWeekly 302hour£1412£168£1410£140£1412£16834£476 
Scrabble*NCHRoom2.00 - 4.00pmMondayWeekly 302hour£1412£168£1410£140£1412£16834£476 
Costs for NCH 84£1344 70£1120 72£1344226£3808 
English Folk Dancing*OLQHall1.45 - 3.15pmWednesdayWeekly 201.5hour£22.512£270£22.510£225£22.50£022£495 
Costs for OLQ 12£270 10£225 0£022£495 
Genealogy Discussion Group*PHORoom 610.00 - 12 noonThursday4-Weekly 202hour£202£40£203£60£200£05£100 
Improving Your Artistic Techniques*PHORoom 610.30 - 12.30pmMondayWeekly 202hour£2012£240£2010£200£200£022£440 
Poetry Appreciation*PHORoom 62.00 - 4.00pmWednesdayFortnightly 202hour£206£120£205£100£200£011£220 
A Divided Kingdom York and Lancaster 1455 - 1485*PHORoom 810.00 - 12 noonWednesday4-Weekly 302hour£203£60£202£40£203£608£160 
Calligraphy*PHORoom 82.00 - 4.00pmFridayWeekly 302hour£2012£240£2010£200£2012£24034£680 
Current AffairsPHORoom 810.30 - 12 noonTuesdayFortnightly 201.5hour£156£90£155£75£150£011£165 
Economics*PHORoom 82.00 - 3.30pmWednesdayWeekly 101.5hour£150£0£1510£150£150£010£150 
Enjoying ShakespearePHORoom 810.30 - 12.15pmFridayWeekly 301.75hour£17.512£210£17.510£175£17.512£21034£595 
History of Scotland*PHORoom 82.00 - 4.00pmTuesday4-Weekly 302hour£203£60£203£60£203£609£180 
Music of the 60s*PHORoom 82.00 - 4.00pmTuesday4-Weekly 302hour£203£60£202£40£203£608£160 
Naval and Military History Group*PHORoom 810.00 - 12 noonWednesday4-Weekly 302hour£203£60£203£60£202£408£160 
Costs for PHO 62£1180 63£1160 35£670160£3010 
Each member of group to pay £1/session for PSSʣʣ
Duplicate Bridge with Help*PSS10.00 - 12 noonTuesdayWeekly 301£012£0£010£0£012£034£0 
Costs for PSS 12£0 10£0 12£034£0 
Annual charge for RHA £56.00 £56.00
Allotment - Year Round ActivityRHAAnyAnyAll year activity01session£67.54£270£04£0£04£012£270 
Costs for RHA 4£326 4£0 4£012£326 
Great Composers - Classical Map of Britain*SCHBritannia Hall10.00 - 12 noonThursdayFortnightly 202hour£146£84£145£70£140£011£154 
Travel - Group HSCHBritannia Hall2.00 - 4.00pmFridayFortnightly 302hour£146£84£145£70£146£8417£238 
Musical RevueSCHJubilee Hall3.30-5.30pmWednesdayWeekly 302hour£27.512£330£27.510£275£27.510£27532£880 
Yoga - Group 1 (no Startinfo)SCHJubilee Hall10.30-11.45MondayWeekly 201.25hour£17.1912£206.25£17.1910£171.88£17.1912£206.2534£584.38 
Yoga - Group 2SCHJubilee Hall11.00 - 12.15pmWednesdayWeekly 201.25hour£17.1912£206.25£17.1910£171.88£17.1912£206.2534£584.38 
Yoga - Group 3SCHJubilee Hall1.30 - 2.45pmFridayWeekly 201.25hour£17.1912£206.25£17.1910£171.88£17.1912£206.2534£584.38 
Costs for SCH 60£1116.75 50£930.63 52£977.75162£3025.125 
Knit and Knatter*SGLCafe2.00pm - 4.00pmTuesday3rd Tues in month 301session£02£0£02£0£02£06£0 
Costs for SGL 2£0 2£0 2£06£0 
Lets Dance*SJIMain Hall2.00 - 4.00pmWednesdayWeekly 301session£16.812£201.6£16.810£168£16.812£201.634£571.2 
Vintage Brass Main Band*SJIMain hall1.30 - 4.00pmMondayWeekly 301session£16.812£201.6£16.810£168£16.812£201.634£571.2 
Vintage Brass Training Band*SJISmall Hall3.30 - 5.00pmMondayWeekly 301session£8.812£105.6£8.810£88£8.812£105.634£299.2 
Costs for SJI 36£508.8 30£424 36£508.8102£1441.6 
Drawing and Painting *SKHHall10.30 - 12.30pmTuesdayWeekly 302hour£2612£312£3010£300£3012£36034£972 
Painting for Pleasure*SKHHall1.30 - 3.30pmTuesdayWeekly 302hour£2612£312£3010£300£3012£36034£972 
Desert Island Discs*SKHMeeting Room2.00 - 3.30pmWednesdayFortnightly 201.5hour£126£72£155£75£150£011£147 
Costs for SKH 30£696 25£675 24£72079£2091 
Snooker*SSC4.00 - 6.30pmTuesdayWeekly 302.5hour£17.512£210£17.510£175£17.512£21034£595 
Costs for SSC 12£210 10£175 12£21034£595 
Indoor Board and Card Games Group 2*SVHhall2.00pm to 4.00pmWednesdayFortnightly 3010hour£854£340£854£340£854£34012£1020 
Sewing Bee*SVHUpstairs room10.00 - 12 noonTuesdayFortnightly 202hour£126£72£125£60£120£011£132 
Costs for SVH 10£412 9£400 4£34023£1152 
Annual Charges for SWT £60.00 £60.00
Play Tennis for Fun - Group 2*SWT10.00 - 12 noonWednesdayWeekly 201£6012£720£010£0£00£022£720 
Costs for SWT 12£780 10£0 0£022£780 
Bridge for Players *TSC2.00 - 4.00pmTuesdayWeekly 301session£2512£300£2510£250£2512£30034£850 
Canasta/Bolivia*TSCNot allocated2.00 - 4.00pmWednesdayWeekly 301£012£0£010£0£012£034£0 
Costs for TSC 24£300 20£250 24£30068£850 
Grand total for 109 groups
 £13696.56 £10414.93 £9761.49 £33872.98 
WARNING: 3 have no room allocated
Click 'Groups in error' for more info