Spreadsheet: 79847d1280084072-drop-down-lists-circular-reference-example
Sheet: Setup

 | GL Accounts |  |  | Information
 | 100101 | 4-Weekly - Core Pay |  | Facility | Excel [NAME]
 | 100102 | 4-Weekly - Overtime |  | Department
 | 100103 | 4-Weekly - Superann |  | Cost Centre | CCSXLS
 | 100104 | 4-Weekly - National Insurance
 | 100107 | 4-Weekly Non Std Working |  | Period Dates
 | 103101 | Weekly - Core Pay |  |  | From | To | Weeks
 | 103103 | Weekly - Superann |  | Period 01 | 2009-04-01 00:00:00 | 2009-04-12 00:00:00 | 1
 | 103104 | Weekly - National Insurance |  | Period 02 | 2009-04-13 00:00:00 | 2009-05-10 00:00:00 | 4
 | 103107 | Weekly - Non Std Working |  | Period 03 | 2009-05-11 00:00:00 | 2009-06-07 00:00:00 | 4
 | 104510 | Self Employed Coaches |  | Period 04 | 2009-06-08 00:00:00 | 2009-07-05 00:00:00 | 4
 | 110001 | Rents |  | Period 05 | 2009-07-06 00:00:00 | 2009-08-02 00:00:00 | 4
 | 110003 | Insurance |  | Period 06 | 2009-08-03 00:00:00 | 2009-08-30 00:00:00 | 4
 | 110501 | W&S Rates |  | Period 07 | 2009-08-31 00:00:00 | 2009-09-27 00:00:00 | 4
 | 110502 | Water (Metered) |  | Period 08 | 2009-09-28 00:00:00 | 2009-10-25 00:00:00 | 4
 | 111251 | Prop Rep Sub Cont |  | Period 09 | 2009-10-26 00:00:00 | 2009-11-22 00:00:00 | 4
 | 112002 | Fuel Oil |  | Period 10 | 2009-11-23 00:00:00 | 2009-12-20 00:00:00 | 4
 | 112003 | Electricity |  | Period 11 | 2009-12-21 00:00:00 | 2010-01-17 00:00:00 | 4
 | 112004 | Gas |  | Period 12 | 2010-01-18 00:00:00 | 2010-02-14 00:00:00 | 4
 | 113001 | Cleaning Materials |  | Period 13 | 2010-02-15 00:00:00 | 2010-03-31 00:00:00 | 6
 | 113002 | Cleaning Services
 | 114001 | Fix & Fit Summary
 | 115001 | [NAME]
 | 116001 | Ext Sec Serv
 | 120002 | Purchases - Plant
 | 120251 | Rep&Maint-Vehicles
 | 120252 | Rep&Maint-Plant
 | 120501 | Petrol
 | 120502 | Diesel
 | 120506 | Licences
 | 121001 | Ext Vehicle Hires
 | 121002 | External Plant Hires
 | 121003 | Oper  Lease Rent Veh
 | 121005 | Transportation Servs
 | 122001 | Emp Travel Expenses
 | 123001 | Car Allow Summary
 | 130001 | Equipment - Purchase
 | 130002 | Equipment - Maint
 | 130003 | Equipment - Hire
 | 130005 | Catering Light Equip
 | 130251 | Furniture - Purchase
 | 130252 | Furniture - Maint
 | 130501 | Direct Materials
 | 130503 | Goods for Resale
 | 130750 | Swimming Pool Chem
 | 131001 | Clothing & Uniforms
 | 131002 | Laundry Summary
 | 133001 | Ext Catering Service
 | 133003 | Food Provisons
 | 133004 | Beverage Purchases
 | 133005 | Milk
 | 134001 | Printing
 | 134002 | [NAME]
 | 134251 | Stationery
 | 134501 | Computer Consumables
 | 135001 | Purchase Of Services
 | 135002 | Purchase Of  Licence
 | 135006 | Aids For Daily Livin
 | 135019 | Medicinal Supplies
 | 135021 | Domestic Supplies
 | 135022 | Personal Supplies
 | 135023 | Educational Supplies
 | 135026 | Waste Collection
 | 135027 | Catering Costs
 | 135028 | Vending Costs
 | 135029 | Flower & Plant Maint
 | 135030 | Land Maint Costs
 | 135032 | Marketing Costs
 | 135046 | Promotional Material
 | 136001 | Facility Mngmnt Fees
 | 137001 | Purh [NAME]
 | 137002 | Purh Comp Software
 | 137003 | [NAME]
 | 137004 | [NAME] (Software)
 | 137007 | Annual Maint Hard
 | 137251 | Telephones
 | 137253 | Mobiles
 | 137501 | Postages General
 | 138001 | Subs-Officials UK
 | 138201 | Travel-Off UK
 | 138202 | Travel-Off Abroad
 | 138301 | Hospitality
 | 138502 | Subs-Members' Abroad
 | 160016 | Interest Paid To Len
 | 166001 | Internal Allocations
 | 185001 | Depreciation
 | 187001 | Irrecoverable VAT
 | 225100 | External Funding
 | 225101 | GCC GRANTS