tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 074a8534-fae1-40cb-87ce-4cb3ba2b2795
Sheet: Sheet1

Special Education Maintenance of Effort and Excess Costs Calculations FY11 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Gifted Expenditures | 2008-09 Actual |  | 2009-10 Actual |  | 2010-11 Budgeted
 | FTE | $ | FTE | $ | FTE | $
Professional Salaries
Paraeducator Salaries
Administrative Salaries
Employee Benefits
Instructional Materials & Equipment from Code 30-Interlocal and districts or Code 78-Cooperative
Transportation from Code 30-Interlocal and districts or Code 78-Cooperative
TOTALS for Year * | 0 | 0 | 0 | 0 | 0 | 0
Special Education Maintenance of Effort |  | 08-09 Actual |  | 09-10 Actual |  | 10-11 Budgeted
Line 7a. District funds expended for Special Education:
Line 7b. Additional Special Ed expenditures from funds other than special ed Code 30 (transportation, equipment, etc.).
Line 7c. Special Ed audit corrections, adjusted upward from CPA audit, if not already included in funds:
Line 7d. Special Ed audit corrections, adjusted downward from CPA audit, if not already included in funds:
7e.  Subtotal of district special ed expenditures |  | 0 |  | 0 |  | 0
Special Education Revenue and Adjustments
Line 8a. All  VI-B special education federal funds drawn down
Line 8b. FY09 and FY10 enter all special education ederal revenue included in 8a, but not expended during that year (VI-B Code 30, Line 55; Other Code 30, Line 65):
8c.  Enter federal carry-over funds received in prior year, but expended in next year. (District enters federal carry-over funds from year 2007-08 into year 2008-09,  Program enters amount from line 8b for 2009-10 and 2010-2011.) |  |  |  | 0 |  | 0
8d.  Total Federal Funds expended |  | 0 |  | 0 |  | 0
Line 9. Total Gifted Expenditures from Gifted Expenditure Report: |  | 0 |  | 0 |  | 0
Line 10. ALL Part C expenditures if reported in special ed Code 30. |  | 0 |  | 0 |  | 0
50% Reduction Rule and Allowable Exceptions
Line 11. Available 50% MOE Reduction Rule based on % of increase in federal funds. (District was at Meets Requirements as of July 1, 2009) LEA enters 09-10 and/or 10-11 (08-09 included from previous MOE)
Allowable Exceptions (Per 34 [NAME] 300.204) Requires Prior Approval by KSDE SES Team |  |  |  | 0
STATE AND LOCAL MAINTENANCE OF EFFORT |  |  | Adjusted |  | 09-10 MOE Level
 |  |  | 09-10 MOE Level |  | Met/Not Met?
Line 12.  STATE AND LOCAL EFFORT: |  | 0 | 0 | 0 | NO | 0
Line 13. 12/1 Special Education Child Count:
Line 14. Per Pupil Expenditure for Special Education:
[NAME] OF EFFORT
Line 15. Total State Aid Minus Gifted and [NAME]: |  |  |  | 0 |  | 0
Line 16. Special Education Local Effort: |  | 0 | 0 | 0 | NO | 0
Line 17. Per Pupil  Local Effort:
Spreadsheet: 757232d1638139681-searching-multiple-fields-using-match-with-offset-and-index-functions-book-room-database
Sheet: Search Books

 | Search for Level |  | Search for Genre |  | Search for Text Structure |  | Search for Text Features
 |  |  | Fable
 | Suggested Titles/Location |  | Suggested Titles/Location |  | Suggested Titles/Location |  | Suggested Titles/Location
Spreadsheet: 142840d1330031561-excel-2007-looking-for-help-creating-average-if-formula-copy-of-moms-bp-readings
Sheet: Sheet2

Mom's Blood Pressure Readings Using Imron Wrist Cuff unit
Starting Feb 8, 2012
Date | Time |  |  |  |  |  |  |  |  |  |  |  |  | Read by: | Style
 |  |  |  | Syst-Top | Dias-Bottom | Syst-Top | Dias-Bottom | Syst-Top | Dias-Bottom | Syst-Top | Dias-Bottom | Syst-Top | Dias-Bottom
 |  |  |  | 132 | 62 | 132 | 62 |  |  |  |  |  |  | Home Nurse | Arm Cuff
 |  |  |  | 136.25 | 68.75 | 143 | 67 | 132 | 67 | 132 | 68 | 138 | 73 | Mom | Wrist Cuff
 |  |  |  | #N/A |  | 2 |  | 2 |  | 2 |  | 2
 |  |  | Syst-Top | Dias-Bottom
 |  |  | 132 | 62
2012-02-08 00:00:00 | 03:00:00 |  | 136 | 69 | 1st Rdg
 | 03:15:00 |  | 143 | 67 | 2nd Rdg
 |  |  | 132 | 68 | 3rd Rdg
 |  |  | 138 | 73 | [NAME]
 |  | Ave BP | 137.25 | 69.25
Spreadsheet: 09678cef-7da5-4d00-8872-839934a57a88
Sheet: notes

Notes dated on 7/25/2012
Column Name | Description
COLLEGE | Colleges who own the classes/courses in AY 12
COURSE | Subject + Catalog Number; one course could have one or more class sections
COMP | Course component, such as LEC (lecture), LAB (laboratory)
Number of CLASSES | The number of class sections within the same course
TOT_ENRL | The total number of all students enrolled in AY12
TOT_COHORT | The total number of fall 2011 cohort students
ALL_D | The number of grade D for all students in the course/class
ALL_ F | The number of grade F for all students in the course/class
ALL_W | The number of grade W for all students in the course/class
Cohort_D | The number of grade D for Fall 2011 cohort students in the course/class
Cohort_F | The number of grade F for Fall 2011 cohort students in the course/class
Cohort_W | The number of grade W for Fall 2011 cohort students in the course/class
ALL_DFW% | The percentage of DFW rate for all students enrolled in the course/class
Cohort% | The percentage of fall 2011 cohort students (over all students enrolled for the course/class)
Cohort_DFW% | The percentage of DFW rate for fall 2011 cohort students  (against all cohorts enrolled in the course/class)
Spreadsheet: 36284d1234170483-merge-two-worksheets-students-teacherssheet
Sheet: TeachersSheet

[NAME] | course_id | attd_1 | attd_2 | attd_3 | quiz_1 | quiz_2 | exam_1 | essay_1 | total | grade
123 | 12 | 12 | 2 |  | 11 | 2 | 11 | 15 | 55 | B
126 | 12 | 11 | 2 | 3 | 14 | 2 | 12 | 16 | 65 | B-
Spreadsheet: 29332d1224252182-vlookup-to-exclude-results-copy-of-example
Sheet: Sheet1

Employee ID | Report ID
1 | 101 |  | 1 | 101
2 | 102 |  | 2 | 102
3 | 103 |  | 3 | 103
4 | 104 |  | 4 | 106
4 | 105 |  | 5 | 107
4 | 106 |  | 6 | 108
5 | 107 |  | 7 | 110
6 | 108 |  | 8 | 111
7 | 109 |  | 9 | 112
7 | 110 |  | 10 | 113
8 | 111 |  | 11 | 114
9 | 112 |  | 12 | 116
10 | 113 |  | 13 | 117
11 | 114
12 | 115
12 | 116
13 | 117
Spreadsheet: 688863d1595986313-formula-to-allocate-figures-from-one-table-to-another-based-on-percentages-workbook-example
Sheet: Sheet1

Rows | Column A | Column B |  | Rows | Text A | Text B |  | Text | Column A | Column B
Row A | 12 | 10 |  | Row A | 1 |  |  | Text A
Row B | 27 | 5 |  | Row B |  | 1 |  | Text B
Row C | 30 | 20 |  | Row C | 0.5 | 0.5 |  | Total
Total
Spreadsheet: matthew_lenhart__26266__West Daily Prices1119-01
Sheet: Top

[NAME] |  | m:\power2\region\
Curve Date |  | 2001-11-19 00:00:00 |  | Prior Date
Regions
R9
R8
R10
R12
R11
R7
B4
R21
 |  |  | Directions
 |  | 1 | Open and Run Heat Rate Curve Import - Close File
 |  | 2 | Open Price File
 |  | 3 | Change date to current Date
 |  | 4 | Run Roll Prior
 |  | 5 | Run Fetch Prices
 |  | 6 | Run Copy Daily for Daily email
 |  |  | For Next month Call Min Zheng -
 |  |  | he will need to run for the new month ie 10/31/01 Min will run the price file to prepare for the next month
Last Running Day |  | 2001-11-19 00:00:00
Price Folder
Spreadsheet: 768059d1644821230-tables-referencing-main-table-cant-use-sort-tabels
Sheet: PRIPRAVA

 | PRIPRAVA
 |  |  |  | STRANKA:
 |  |  |  | Risba št.: |  |  |  | KOSOV:
 |  |  |  | Ime :
IME | POZ. | DEB. | ŠIRINA | DOLŽINA | KOS. | Material | OPOMBA | [NAME] | N.TEŽA | LIST
Spreadsheet: 599079d1542847531-pull-in-private-equity-data-based-on-1-criteria-report-example
Sheet: Sheet1

 |  |  |  |  |  |  | Data
 | Table |  |  |  |  |  |  | Fund Name | Target Raise
 | Venture |  |  |  |  |  | Venture | Fund 1 | 2000
 |  |  |  |  |  |  | Venture | Fund 2 | 3000
 |  |  |  |  |  |  | Venture | Fund 3 | 4000
 |  |  |  |  |  |  | Buyout | Fund 4 | 1500
 | Buyout |  |  |  |  |  | Buyout | Fund 5 | 1000
 |  |  |  |  |  |  | Buyout | Fund 6 | 3500
Spreadsheet: 758949d1639166451-two-questions-find-similar-names-and-setting-values-unique-inventory-cs-the1radfox-
Sheet: To LGL

Archived Record? | Included in Pilot? | S&L Case ID | App-ID | IT App/Tool Name | LOB | Function | Purpose | Detailed Purpose | Classification | Reason for Classification | Technology | Ownership? | Type | Location | Source | Change Management | [NAME] | Disaster Recovery | Access Management | Identity Access Governance | Designation | Notes
Spreadsheet: 688907d1596017904-if-x-loja-na-m-o-vs-databox-produtos
Sheet: MARCAS

ADIDAS
ADVANCE
AOC
PHILIPS
LG
SAMSUNG
CREATIVE
EDNET
EQUIPE
KINGSTON
LIFETECH
[NAME]
NAPOFIX
PANZERGLASS
PORT
PRIMUX
SPIRIT OF GAMER
TP-LINK
TRUST
VERBATIN
FAGOR
HAMMER
NEDIS | FORA DA DATABOX
Spreadsheet: 766063d1643734842-help-with-allocation-formula-excel-formula-help-1-31-22
Sheet: Sheet1

Customer | Item 1 2020 Units | Item 1 2021 Units | Item 1 Unit [NAME] | Current Allocation | [NAME] every 45 Days | Round to Carton | Addt. 45 Day Allocated | Item 1 Preliminary Allocation Bucket (every 45 days) | Allocation Recommendation | Final Allocation
Customer 1 | 300000 | 148000 | -152000 | 4800 |  | -18800 | 18800 |  | 14400 | 14400
Customer 2 | 0 | 600 |  | 4800 |  | 0 | 0 | 4800 |  | 1200
Customer 3 | 49000 | 0 | -49000 | 4800 |  | -6100 | 6100 |  | NO SALES 2021 | 1200
Customer 4 | 0 | 0 |  | 4800 |  |  |  |  |  | 1200
Customer 5 | 18000 | 51500 |  | 4800 |  | 4100 |  |  |  | 1200
I need to calculate a Final Allocation number for approximately 300 different items.
Customer can only order every 45 calendar days
Each item has a different allocation.  Clients can currently order 4800 pieces of Item 1 every 45 calendar days
I need help with a formula for figuring a FINAL ALLOCATION number based on the following rules:
ALLOCATION RULES:
I NEED TO CAP THE FINAL ALLOCATION (Customer 1 example) | Allocation cap per item no more than 3 times Current Allocation for that item.  Any number in the PRELIMINARY ALLOCATION BUCKET that is higher than 3 times the Current Allocation defaults to that number.  In this case, (4800 * 3) is 14,400.  If the prelininary allocation bucket is over 14,400, this would be the final allocation number.
ALLOCATE 25% (Customer 2 example) | If no item was purchased in 2020 but was purchased in 2021, allocated amount for that item is 25% of Current allocation (4,800/4)
ALLOCATE 25% (Customer 3 example) | If no item was purchased in 2021 but was purchased in 2020, allocated amount for that item is 25% of Current Allocation (4,800/4)
ALLOCATE 25% (Customer 4 example) | If no item was purchased in 2020 or 2021, allocated amount for that item is 25% of Current Allocation (NO 2020 or 2021 sales = 25% of Current Allocation)
ALLOCATE 25% (Customer 5 example) | Any item that is at or below 25% in the PRELIMINARY ALLOCATION BUCKET defaults FINAL ALLOCATION to 25% of published allocation
Spreadsheet: 846846d1697992794-help-with-the-if-and-formula-test-book
Sheet: Sheet1

Value | Price | 2 Or More | 3 Or More | 4 Or More
0 | 24
0 | 22
2 | 84
3 | 16
0 | 2
0 | 578
5 | 12
0 | 654
1 | 25
0 | 25
6 | 25
Spreadsheet: 723666d1615826133-how-to-return-multiple-column-headers-based-on-a-difference-column-headers-based-on-differences-in-values-jayidhh-
Sheet: Sheet1

Net pay
 |  |  |  | Reason for difference
 | Week 1 | Week 2 | Difference
Number 1
 |  |  |  |  | formula in this example needs to return that the difference in earnings between the two weeks arose out as a result of "Overtime 1.5" and "Sunday Wage"
Spreadsheet: 682755d1592317066-sheet-generation-based-on-status-chemicals-sheet
Sheet: Sheet1

Data Sheet
Sr. No | Chemical | Constituent1 | Composition 1 | Constituent2 | Composition 2 | Constituent3 | Composition 3 | Constituent4 | Composition 4 | Constituent5 | Composition 5 | Composition | Status |  | Helper
1 | AAA | AAA1 | 0.1 | AAA2 | 0.15 | AAA3 | 0.35 | AAA4 | 0.2 | AAA5 | 0.2 |  | Active
2 | BBB | XXX1 | 0.6 | XXX2 | 0.25 | [NAME] | 0.15 |  |  |  |  |  | Active
3 | CCC | YYY1 | 1 |  |  |  |  |  |  |  |  |  | Inactive
4 | DDD | ZZZ1 | 0.5 | ZZZ2 | 0.5 |  |  |  |  |  |  | 0.5 | Active
Generated sheet based on ACTIVE status
Sr. No | Chemical | Constituents | Composition |  | Helper
Spreadsheet: 65947d1266574581-if-and-conditional-formatting-conditional-formatting-highlight-cell
Sheet: Sheet1

 |  |  |  |  | comp |  |  |  |  |  |  |  |  | comp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | comp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | comp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | comp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | comp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | comp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | comp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | comp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | comp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | comp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | comp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | comp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | comp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | comp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | comp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | comp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | comp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | comp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | comp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | comp
 |  |  |  |  |  |  |  |  |  |  |  |  |  | comp
Spreadsheet: 792751d1661143715-transposing-data-test
Sheet: Sheet1

Column1 | Column2 |  |  |  |  | Value
110 | 6 |  |  |  |  | 6
732 | 300 |  |  |  |  | 110
516 | 642 |  |  |  |  | 300
171 | 910 |  | 642 |  |  | 732
198 | 598 |  | 516 |  |  | 642
26 | 941 |  | etc… |  |  | 516
821 | 286 |  |  |  |  | 910
374 | 417 |  |  |  |  | 171
971 | 510 |  |  |  |  | 598
575 | 347 |  |  |  |  | 198
394 | 607 |  |  |  |  | 941
746 | 857 |  |  |  |  | 26
316 | 718 |  |  |  |  | 286
762 | 101 |  |  |  |  | 821
371 | 568 |  |  |  |  | 417
930 | 939 |  |  |  |  | 374
208 | 787 |  |  |  |  | 510
234 | 261 |  |  |  |  | 971
715 | 913 |  |  |  |  | 347
981 | 99 |  |  |  |  | 575
398 | 410 |  |  |  |  | 607
16 | 4 |  |  |  |  | 394
267 | 508 |  |  |  |  | 857
231 | 957 |  |  |  |  | 746
7 | 381 |  |  |  |  | 718
1 | 206 |  |  |  |  | 316
444 | 360 |  |  |  |  | 101
338 | 246 |  |  |  |  | 762
464 | 996 |  |  |  |  | 568
614 | 857 |  |  |  |  | 371
950 | 961 |  |  |  |  | 939
 |  |  |  |  |  | 930
 |  |  |  |  |  | 787
 |  |  |  |  |  | 208
 |  |  |  |  |  | 261
 |  |  |  |  |  | 234
 |  |  |  |  |  | 913
 |  |  |  |  |  | 715
 |  |  |  |  |  | 99
 |  |  |  |  |  | 981
 |  |  |  |  |  | 410
 |  |  |  |  |  | 398
 |  |  |  |  |  | 4
 |  |  |  |  |  | 16
 |  |  |  |  |  | 508
 |  |  |  |  |  | 267
 |  |  |  |  |  | 957
 |  |  |  |  |  | 231
 |  |  |  |  |  | 381
 |  |  |  |  |  | 7
 |  |  |  |  |  | 206
 |  |  |  |  |  | 1
 |  |  |  |  |  | 360
 |  |  |  |  |  | 444
 |  |  |  |  |  | 246
 |  |  |  |  |  | 338
 |  |  |  |  |  | 996
 |  |  |  |  |  | 464
 |  |  |  |  |  | 857
 |  |  |  |  |  | 614
 |  |  |  |  |  | 961
 |  |  |  |  |  | 950
Spreadsheet: 35519d1233135757-excel-2007-how-to-copy-conditional-formating-golf-2009
Sheet: Svein

 | Svein
 | Windsor
 | Hull: | Par: | Beste: | Snitt: |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | Par | [NAME] | [NAME] | Eagel | Annet
 | Hull 1 | 4
 | Hull 2 | 4
 | Hull 3 | 5
 | Hull 4 | 3
 | Hull 5 | 5
 | Hull 6 | 4
 | Hull 7 | 4
 | Hull 8 | 3
 | Hull 9 | 4
 | Første 9
 | Hull 10 | 4
 | Hull 11 | 4
 | Hull 12 | 5
 | Hull 13 | 3
 | Hull 14 | 4
 | Hull 15 | 5
 | Hull 16 | 4
 | Hull 17 | 3
 | Hull 18 | 4
 | Siste 9
 | Total
 | Muthaiga
 | Hull: | Par: | Beste: | Snitt: |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | Par | [NAME] | [NAME] | Eagel | Annet
 | Hull 1 | 4
 | Hull 2 | 3
 | Hull 3 | 4
 | Hull 4 | 5
 | Hull 5 | 3
 | Hull 6 | 4
 | Hull 7 | 5
 | Hull 8 | 4
 | Hull 9 | 4
 | Første 9
 | Hull 10 | 5
 | Hull 11 | 3
 | Hull 12 | 4
 | Hull 13 | 3
 | Hull 14 | 4
 | Hull 15 | 4
 | Hull 16 | 3
 | Hull 17 | 4
 | Hull 18 | 5
 | Siste 9
 | Total
Spreadsheet: 73408d1274076865-summarize-numbers-by-month-expenses
Sheet: Summary

Visas 2010
Name | Spouse | Childen | Centre | Date | Cost |  |  |  |  |  | Main | Spouse
aa | wife | 1 | LP | 2010-06-01 00:00:00
bb |  |  | VLC | 2010-08-01 00:00:00
cc | [NAME] | 3 | VLC | 2010-08-10 00:00:00 | 1000
dd | [NAME] | 1 | VLC | 2010-08-17 00:00:00
ee |  |  | Pakse | 2010-09-09 00:00:00
ff | Anna | 1 | Skills | 2010-09-15 00:00:00
gg | [NAME] | 3 | LP | 2010-09-15 00:00:00
hh | Danika | 1 | LP | 2010-09-25 00:00:00
ii | Nicole | 1 | LP | 2010-09-15 00:00:00
jj |  |  | VLC | 2010-11-01 00:00:00
kk | [NAME] | 1 | Pakse | 2010-12-15 00:00:00
ll |  |  | VLC | 2011-01-01 00:00:00
[NAME] |  |  | Skills | 2011-01-25 00:00:00
nn |  |  | LP | 2011-01-26 00:00:00
oo |  |  | LP | 2011-01-26 00:00:00
pp | Lyne | 1 | VLC | 2011-03-03 00:00:00
qq | Charlene |  | Skills | 2011-04-25 00:00:00
rr |  |  | VLC | 2011-05-03 00:00:00 | 200
 |  | 2010 |  | 2011
Spreadsheet: 857652d1706619382-create-a-contents-list-from-multiple-tabs-test-data
Sheet: Sheet1

Report Name | Task | Status | Reference | Notes | Date
Example 1 | Example 1 | IP | MIS-6911 |  | 2024-01-01 00:00:00
Example 2 | Example 2 | TO DO | MIS-6761 |  | 2024-01-02 00:00:00
Example 3 | Example 3 | REF | MIS-6253 |  | 2024-01-03 00:00:00
Example 4 | Example 4 | IP | [NAME] |  | 2024-01-04 00:00:00
Example 5 | Example 5 | TO DO | MIS-6760 |  | 2024-01-05 00:00:00
Example 6 | Example 6 | REF | MIS-6861 |  | 2024-01-06 00:00:00
Spreadsheet: 878632d1725820500-hours-without-overlapping-formula-test-time-ayazgreat-
Sheet: Sheet1

Job ID | Time Start | Time End | Total Hours wo/overlapping
38868 | 11:09:00 | 12:02:00 |  | Should be 0
69746 | 11:09:00 | 12:08:00 |  | Should be 0
34338 | 12:07:00 | 12:23:00 |  | Result
36149 | 12:33:00 | 13:26:00 |  | Result
12347 | 12:33:00 | 13:19:00 |  | Should be 0
72441 | 13:40:00 | 14:01:00 |  | Result
81011 | 14:14:00 | 14:39:00 |  | Result
79832 | 14:55:00 | 15:24:00 |  | Should be 0
10273 | 14:55:00 | 15:32:00 |  | Result
Job ID | Time Start | Time End | Total Hours wo/overlapping
28859 | 11:01:00 | 11:38:00 | 0.6166666666666671 | Result
10703 | 11:01:00 | 11:31:00 | 0 | Should be 0
44155 | 11:36:00 | 12:21:00 | 0.7166666666666655 | Result
22818 | 11:53:00 | 12:12:00 | 0 | Should be 0
77123 | 12:11:00 | 12:43:00 | 0.366666666666668 | Result
70619 | 12:27:00 | 13:22:00 | 0.6500000000000004 | Result
74581 | 14:38:00 | 15:03:00 | 0.4166666666666652 | Result
Spreadsheet: 149000d1333643269-transfer-information-to-template-sample-2
Sheet: Sheet1

City of Morganton 2012 Statement of Values
Deductible: |  | 1000
Flood Limit: |  | None
EQ Limit: |  | None
Total Values:
Loc # | Bldg # | Occupancy | Address | Fac | Yr. Built | POK Code | CK # | BF Descpt | Building | Contents | Total | Valuation | Construction | Prot Class | SF
1
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
Spreadsheet: 172481d1344237637-rearrange-data-from-multiple-rows-gata-final
Sheet: ASSOC

Member: | ABRAHAMS, [NAME] (RASGPA33779M138556)
Registration Number |  |  | Chassis Number | Passenger Capacity (ex. driver) | Permit / OL Number
RGN378GP |  |  | AAVZZZ25ZNU000657 | 15 | LGPGP0123189/1
TKB493GP |  |  | AFAMWFD11MR362716 | 15 | LGPGP0142181/1
Member: | ABRAHAMS, SHANE (RASGPA33779M161266)
Registration Number |  |  | Chassis Number | Passenger Capacity (ex. driver) | Permit / OL Number
YYM582GP |  |  | LFZBBAGC38A000984 | 13 | Unlinked
ZDS194GP |  |  | JTFSX23P906081545 | 13 | Unlinked
ZJM108GP |  |  | LFZBBAGC07A012718 | 13 | Unlinked
Member: | ADONIS, IJ (RASGPA33779M147973)
Registration Number |  |  | Chassis Number | Passenger Capacity (ex. driver) | Permit / OL Number
HCW398GP |  |  | AAVZZZ25ZJU000967 | 12 | Unlinked
Member: | BASSON, TR (RASGPA33779M124094)
Registration Number |  |  | Chassis Number | Passenger Capacity (ex. driver) | Permit / OL Number
LHY012GP |  |  | AAVZZZ25ZYU002298 | 10 | Unlinked
Member: | BESWICK, [NAME] (RASGPA33779M124092)
Registration Number |  |  | Chassis Number | Passenger Capacity (ex. driver) | Permit / OL Number
CYD189GP |  |  | AAPV0349940219750 | 15 | LGPGP0123284/1
Member: | BEUKES, J (RASGPA33779M132090)
Registration Number |  |  | Chassis Number | Passenger Capacity (ex. driver) | Permit / OL Number
BZB915GP |  |  | YH539003453 | 15 | Unlinked
VLB238GP |  |  | AHT41YH6309078214 | 15 | LGPGP0115017/1
ZDN695GP |  |  | JTFSX22P806077990 | 13 | Unlinked
Member: | [NAME], [NAME] (RASGPA33779M132290)
Registration Number |  |  | Chassis Number | Passenger Capacity (ex. driver) | Permit / OL Number
HWZ658GP |  |  | AAPV0030010283201 | 15 | LGPGP0119909/1
MJP853GP |  |  | YH63B9005327 | 15 | LGPGP0127173/1
NFC619GP |  |  | YH63V9010804 | 15 | LGPGP0119143/1
VSL806GP |  |  | LFZBBAGC67A000444 | 14 | Unlinked
Member: | BOUGAARD, DASAP (RASGPA33779M138564)
Registration Number |  |  | Chassis Number | Passenger Capacity (ex. driver) | Permit / OL Number
HCM618GP |  |  | 239126 | 15 | LGPGP0127115/1
NGH045GP |  |  | 25B0150187 | 15 | LGPGP0140110/1
Spreadsheet: 84732d1284730716-column-consolidation-column-consolidation-macro
Sheet: Department 1

Department | Postion | Status 1 | Status 2 | Status 3 | Status 4 | HC postion | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00
Bc | PM | Expat | China | Bejeing | JB | 1 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
Bc | PM | Expat | China | Bejeing | DT | 0 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
Bc | DPM | Expat | China | Bejeing | JB | 1 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75
Bc | DPM | Expat | China | Bejeing | DT | 0 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25
Bc | PD | Expat | China | Bejeing | JB | 1 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6
Bc | PD | Expat | China | Bejeing | DT | 0 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4
Bc | DPD | Local | China | Bejeing | JB | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Bc | DPD | Local | China | Bejeing | DT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Bc | PE | Expat | UK | London | JB | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Bc | PE | Expat | UK | London | DT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0