tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 753143d1635266928-index-match-formula-for-duplicate-values-index-match-book
Sheet: Part Order

Part | Due
Pears | 2019-01-04 00:00:00
BK36701 | 2019-01-31 00:00:00
BX35640 | 2019-01-07 00:00:00
CC20434 | 2019-02-14 00:00:00
Apples | 2019-01-04 00:00:00
GD38853 | 2019-02-17 00:00:00
GQ18803 | 2019-02-15 00:00:00
JF34904 | 2019-01-31 00:00:00
Bananas | 2019-01-04 00:00:00
JU13976 | 2019-02-17 00:00:00
LS18007 | 2019-01-13 00:00:00
LT21272 | 2019-01-22 00:00:00
MW33367 | 2019-02-16 00:00:00
NF34465 | 2019-02-16 00:00:00
NR26220 | 2019-02-17 00:00:00
OS14484 | 2019-02-27 00:00:00
OX17453 | 2019-02-24 00:00:00
Stones | 2019-01-04 00:00:00
RQ33652 | 2019-01-14 00:00:00
SE25509 | 2019-01-10 00:00:00
SG20341 | 2019-02-26 00:00:00
SI15345 | 2019-01-07 00:00:00
SP18475 | 2019-01-04 00:00:00
TB15510 | 2019-01-29 00:00:00
WA14608 | 2019-02-26 00:00:00
XA32691 | 2019-02-06 00:00:00
XJ28600 | 2019-01-17 00:00:00
XR24765 | 2019-01-28 00:00:00
YV31055 | 2019-01-23 00:00:00
ZS11542 | 2019-02-04 00:00:00
Spreadsheet: 142240d1329748979-increase-row-reference-when-using-index-orders
Sheet: Order

Quantity | PRODUCED |  | SIZE MM |  |  |  |  | PRICE | CODE | PACK | WEIGHT
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
 |  |  |  | X |  | X
Spreadsheet: 840352d1692675665-how-to-add-picture-and-pdf-document-rebar-counting-at-mtb-and-airside
Sheet: Taisei Rebar

BANDARANAYAKE INTERNATIONAL AIRPORT DEVELEOPMENT - Phase II Stage 2 Package A
REBAR COUNTING AT PIER 2 ( BELONGS TO TAISEI) ON 03.08.2023
10 MM (12M) |  | 20MM (12M) |  | 32MM (12M) |  | 40MM (12M) |  | 10M(10M-12M)
1060 |  |  |  |  |  |  |  | 11
Counted Jointly and actual quantity at pier 2 is as shown in above table
 |  | CSCEC |  |  | TAISEI |  |  |  | JAC
Name
Designation
Signature
Date
Spreadsheet: 60751d1261301288-can-periodical-fixed-deductions-payments-be-inserted-automatically-budget2010
Sheet: Jan

Jan |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INCOME
 | Automotive |  | Utilities |  |  |  |  | Insurance |  |  |  | Pets |  | Residence |  | Personal |  |  |  |  |  | repay |  |  | debt
 | petrol | repair | Optus | gas | water | rates | power | health | hous/cont | car | chooks | dogs | fish | garden | maintenance | medical | outings | giving | clothes | groceries | other | M.C. |  |  | M.C.
Totals → | 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
DATE ↓ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTE
Spreadsheet: 271911d1382105028-sum-values-from-different-sheets-to-summary-sheet-sum-values
Sheet: Qtr1

Our Global Company
[NAME], First Quarter
Sales Group: | Consulting: | Marketing: | Outsourcing: | Bundling:
Northeast | 4306.511715303401 | 4045.072773386305 | 4261.455212116669 | 2376.727863087549
Southeast | 3120.795028799535 | 4771.993708682354 | 6592.739134258856 | 9199.849338563727
Northwest | 4831.494729543071 | 1044.686599143763 | 3191.806587430719 | 3056.374742531114
Southwest | 6988.464419817817 | 715.4038416756947 | 1788.929033508362 | 8512.49130813452
TOTAL
Spreadsheet: 765463d1643333770-slow-array-formula-test-run-sheet-file-2-2-
Sheet: RUN SHEET

Depot Name |  |  |  |  |  |  | Week Commencing |  |  | 001a
 |  |  |  |  |  |  |  |  | Current Insp Week
MONDAY |  | IF REPORTING DELAYS DUE TO TRAFFIC, PLEASE ENTER EXACT LOCATION
[NAME] used today |  |  |  |  | Drivers Name
Returning Trailer Number: |  |  |  |  |  | Trailer MOT Date: |  |  | Trailer Insp Number:
Have you left your Trailer hooked up? |  |  | Y  or N | Please confirm your vehicle/[NAME] is EMPTY |  |  |  | Y or N | Amount of fuel drawn
depart site | depart time | Arr Time | To Site | PLANZ Code | Stream |  | load carried | Comment section, IE reason for running late
 | 05:40:00 | 06:16:00 | DESTINATION 1 | .HWDC.5 | 0
DESTINATION 1 | 06:31:00 | 07:07:00 | STARTING OFFICE | EMPTY | 0 |  |  | .
STARTING OFFICE | 07:22:00 | 08:02:00 | DESTINATION 2 | RY..PRDC. | 0
DESTINATION 2 | 08:17:00 | 09:07:00 | DESTINATION 1 | EMPTY | 0
DESTINATION 1 | 10:37:00 | 11:27:00 | DESTINATION 2 | HWILC.PRDC. | 0
DESTINATION 2 | 15:07:00 | 15:26:00 | STARTING OFFICE | PRDC.. | 0
 | 05:40:00 | 06:16:00 | DESTINATION 1 | .HWDC.5 | 0
DESTINATION 1 | 06:31:00 | 07:07:00 | STARTING OFFICE | EMPTY | 0
STARTING OFFICE | 07:22:00 | 08:02:00 | DESTINATION 2 | RY..PRDC. | 0 |  |  | Unhook Unit and Trailer
DESTINATION 2 | 08:17:00 | 09:07:00 | DESTINATION 1 | EMPTY | 0
DESTINATION 1 | 10:37:00 | 11:27:00 | DESTINATION 2 | HWILC.PRDC. | 0
DESTINATION 2 | 15:07:00 | 15:26:00 | STARTING OFFICE | PRDC.. | 0
Spreadsheet: 878768d1726050497-need-formula-to-do-a-subtraction-from-vlook-up-payment-difference
Sheet: Sheet1

Name | Assignments | StaffNumber | GradeCode | Sum of basic hours | Sum of (E)Sat | Sum of (E)Sun | Sum of (E)Night | Count of (E)Unsoc | Sum of ([NAME]
[NAME] | 1234 | 5678 | 2 | 18.5 | 0.05 | 0 | 4.77 | 1 | 5.98044
[NAME] | 3333 | 4422 | 2 | 9.1 | 0 | 0 | 0 | 1 | 0
[NAME] | 3434 | 4578 | 2 | 6 | 0 | 0 | 0.0225564 | 1 | 0
Spreadsheet: 198167d1354682304-formula-count-of-items-that-meet-a-specific-range-criteria-count-of-items-that-specify-a-range-criteria
Sheet: Sheet1

Attainment | Quarter 1 | Quarter 2 | Quarter 3
72% - 84.9% | 3 |  |  |  |  | [NAME] to get the count of employees who attained the percentage within 72%-84.9% in Q1, Q2, Q3
85% - 89.9% |  |  |  |  |  | The count of employees who attained the percentage within 85%-89.9% in Q1, Q2, Q3
90% - 99.9%
100% - 109.9%
110% - 118%
119%- Above |  | 2
EMPLOYEE | Quarter 1 | Quarter 2 | Quarter 3
Ram | 0.9 | 1.09 | 0.56
[NAME] | 0.2 | 2.35 | 0.89
Guru | 0.15 | 0.99 | 1.2
Sivan | 1.2 | 1 | 1.02
Mat | 1.05 | 1.18 | 0.95
Keshav | 0.79 | 1.15 | 0.85
Parthiv | 0.46 | 1.3 | 0.95
Serene | 0.73 | 0.22 | 0.97
Michelle | 0.84 | 0.56 | 1.17
Spreadsheet: 141c6dbb-55c2-4ad7-9602-8d9be4397493
Sheet: TRANSPLANT DATA

 | [NAME] | e | 516-70-1532 |  | CITY/ENTITY | [NAME] | 1998-08-11 00:00:00 | Kidney | [NAME]URN | Eval.
DEP CODE | PATIENT | TOTAL | ID# | DOB | ENTITY | CM STATUS | CM open | TYPE | FACILITY | STATUS
 | POTENTIAL TRANSPLANT - NO EVALUATION REQUESTED
 | TOTAL
 | PRE-TRANSPLANT EVALUATION REQUESTED
 | TOTAL
 | PRE-TRANSPLANT EVALUATION APPROVED
 | TOTAL
 | TRANSPLANTS APPROVED & PENDING
 | TOTAL
 | GRAND TOTAL PENDING
 | STATUS POST TRANSPLANT
s |  | 1 |  |  | Carrollton | Closed 5/1/13 | 2009-03-20 00:00:00 | Kidney | Baylor/Dallas | **admit 8/31/12 for cadaveric txp 9/1/12** |  | MC PRIME 5/1/13
s |  | 1 |  |  | Carrollton | Closed 5/12/08 | 2007-04-06 00:00:00 | Kidney | Baylor/Dallas | Post 3/13/08/Term 3/1/08 | No COBRA, UHC 1st, MD 2nd
s |  | 1 |  |  | Carrollton | Closed11/18/05 | 2004-05-18 00:00:00 | SCT | [NAME] | Post 11/19/04
e |  | 1 |  |  | Carrollton | Closed 5/16/12 | 2003-10-15 00:00:00 | Liver | [NAME]URN | Post 8/31/04;close 1/26/06 | Txp stable | CM open for CA; closed 5/16/12
 | GRAND TOTAL COMPLETED
 | OTHER
e |  |  |  |  | Carrollton | closed 6/04/12 | 2011-01-06 00:00:00 | SCT | TBD | Closed 6/04/12; No eval req./hodgkins lymphoma
s |  |  |  |  | Carrollton | Closed 5/28/02 | 2002-01-23 00:00:00 | Liver | TBD | Expired 5/24/02
s |  |  |  |  | Carrollton | Closed 1/14/08 | 2003-12-09 00:00:00 | Lung | [NAME]Dallas | Expired 1/12/08
e |  |  |  |  | Carrollton | Closed 4/12/10 | 2009-08-14 00:00:00 | Liver | Baylor/D+AS/FtWorth | Expired 4/8/10
Spreadsheet: 4fc79c95-2f33-466a-b0d1-378a14d30a44
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
LEIS | Test | LEIS | Leishmaniasis (Visceral) Antibody, Serum | Leishmaniasis (Visceral) Ab, S | Immunochromatographic Strip Assay | [NAME], round-bottom, plastic vial: ScwRBPl |  |  | 0.2 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.2 mL | 0.1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | Negative | Monday, Wednesday, Friday; 9 a.m. | Same day/1 day | 4 days | 1 | 86717 |  |  |  |  | Rochester
LEIS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
LEIS | Result | 86219 | Leishmaniasis (Visceral) Ab, S | Leishmaniasis (Visceral) Ab, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7958-2 | Leishmania sp Ab:ACnc:Pt:Ser:Ord:
Spreadsheet: 28ce6847-e29b-4b2a-9505-7e44d321e350
Sheet: Sheet1

South Dakota Civil Rights Advisory Committee
Members | Office | Telephone
[NAME], [NAME] and (West Area) | Rapid City Field Support Office | [PHONE]
[NAME], Vice-Chair (East Area) | Sioux Falls Field Office | [PHONE]
[NAME], (At Large) | Brookings Field Support Office | [PHONE]
[NAME], (Central Area) | Leola Field Office | [PHONE]
Kaytee Todoroff, (At-Large) | Flandreau Field Office | [PHONE]
[NAME] (State Office) | Clark Field Office | [PHONE]
Lynsee Planting, FWPM | Madison Field Office | [PHONE]
Shane Deranleau, AIANPM* | Mitchell Field Office | [PHONE]
[NAME], HEPM* | Burke Field Office | [PHONE]
Vacant, BEPM*
[NAME], AAPIPM* | Sisseton Field Office | [PHONE]
Vacant, DEPM*
[NAME], LGBT* | MLRA Soil Survey Office Rapid City Field Support Office | [PHONE]
[NAME], VEP | Kennebec Field Office | [PHONE]
[NAME] Advisor | Huron State Office | [PHONE]
[NAME], Advisor | Huron State Office | [PHONE]
[NAME], Advisor | Huron State Office | [PHONE]
* = Special Emphasis Program Managers
AIANPM = American Indian/Alaska Native Program Manager
FWPM = Federal Women's Program Manager
HEPM = Hispanic Emphasis Program Manager
BEPM = Black Emphasis Program Manager
AAPIPM = Asian American/Pacific Islander Program Manager
DEPM = Disabilities Employment Program Manager
LGBT = Lesbian, Gay, Bisexual, and Transgender Program Manager
VEP = Veterans Emphasis Program Manager
Spreadsheet: 885238d1734683254-date-of-birth-and-gender-identifucation-excel-forum-id-number
Sheet: Sheet1

 | National Identity Number
 |  |  | 6 Digits from L/H | Gender
 | 8111146100141 |  | 811114 | 6100 | Male
 | 8811131100150 |  | 881113 | 1100 | Female
TABLE
Name | ID No# |  | DATE OF BIRTH | GENDER
[NAME] | 8111146100141 |  | 1981-11-14 00:00:00 | Male
[NAME] | 8811131100150 |  | 2013-11-13 00:00:00 | Female
Spreadsheet: 759611d1639620129-get-numbers-based-on-a-cell-and-between-2-numbers-horizontaly-sample-13-
Sheet: Sheet11

OR
AR
 | Date Released | Branch | First # | Last # | Column2 | OR/AR | Remarks | Column7 | Branch- | Column3 | Column4 | Column5 | Column6 | Column62 | Column63 | Column64 | Column65
 |  | Branch 1 | 1000 | 1500 |  | OR
 |  | Branch 1 | 100 | 600 |  | AR
 |  | Branch 2 | 2500 | 3000 |  | OR
 |  | Branch 2 | 900 | 1000 |  | AR
 |  |  |  | ExampIe - I need to see below
 |  | Branch | First # | Last # | Column2 | OR/AR | Remarks | Column7 | Branch- | Column3 | Column4 | Column5 | Column6 | Column62 | Column63 | Column64 | Column65
 |  | Branch 1 | 1000 | 1500 |  | OR |  |  | Branch 1
 |  | Branch 1 | 100 | 600 |  | AR |  |  | Branch 1
 |  | Branch 2 | 2500 | 3000 |  | OR |  |  | Branch 2
 |  | Branch 2 | 900 | 1000 |  | AR |  |  | Branch 2
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
Spreadsheet: larry_campbell__20999__PCB Graphs
Sheet: 0.55B

Sample location |  |  | Date collected |  |  | PCB result (ppm) |  | Lab
PGE Mile pt. |  |  | 1999-11-03 00:00:00 |  |  | 14 |  | Sherwood
0.55 B side |  |  | 1999-11-18 00:00:00 |  |  | 26 |  | Sherwood
 |  |  | 1999-11-24 00:00:00 |  |  | 44 |  | Sherwood
 |  |  | 1999-12-01 00:00:00 |  |  | 47 |  | Sherwood
 |  |  | 1999-12-08 00:00:00 |  |  | 30 |  | Sherwood
 |  |  | 1999-12-14 00:00:00 |  |  | 21 |  | Sherwood
 |  |  | 1999-12-29 00:00:00 |  |  | 29 |  | Sherwood
 |  |  | 2000-01-05 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-01-19 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-02-09 00:00:00 |  |  | 29 |  | Sherwood
 |  |  | 2000-03-01 00:00:00 |  |  | 23 |  | Sherwood
 |  |  | 2000-03-22 00:00:00 |  |  | 10 |  | Sherwood
 |  |  | 2000-04-05 00:00:00 |  |  | 20 |  | Sherwood
 |  |  | 2000-04-19 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-05-03 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-05-17 00:00:00 |  |  | 11 |  | Sherwood
 |  |  | 2000-05-31 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-06-14 00:00:00 |  |  | 15 |  | Sherwood
 |  |  | 2000-06-21 00:00:00 |  |  | 18 |  | Sherwood
 |  |  | 2000-06-27 00:00:00 |  |  | 19 |  | Sherwood
 |  |  | 2000-07-05 00:00:00 |  |  | 17 |  | Sherwood
 |  |  | 2000-08-09 00:00:00 |  |  | 13 |  | Sherwood
 |  |  | 2000-09-20 00:00:00 |  |  | 8 |  | Sherwood
 |  |  | 2000-10-04 00:00:00 |  |  | 5 |  | Sherwood
 |  |  | 2000-10-18 00:00:00 |  |  | 5 |  | Sherwood
 |  |  | 2000-12-13 00:00:00 |  |  | 4 |  | Sherwood
 |  |  | 2001-02-14 00:00:00 |  |  | 3 |  | Sherwood
 |  |  | 2001-04-18 00:00:00 |  |  | 2 |  | Sherwood
0 data values = ND or  less than a detection limit of 1ppm
Spreadsheet: 42742d1241337244-various-index-match-problems-workbook-v2
Sheet: Progress Summary

 |  | Progress Summary - 1 Year
 |  | Sub-levels gained
 |  | 7+ | 6 | 5 | 4 | 3 | 2 | 1 | 0 | -1 | -2 | -3 | -4 or fewer | N/A
 | [NAME] 8 | 0 | 0 | 0 | 2 | 4 | 8 | 10 | 4 | 0 | 0 | 0 | 0 | 0
 | Cedar 8 | 0 | 0 | 2 | 3 | 11 | 15 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | Linden 8 | 0 | 0 | 1 | 3 | 6 | 8 | 7 | 3 | 1 | 0 | 0 | 0 | 0
 | Maple 8 | 1 | 0 | 0 | 3 | 8 | 10 | 5 | 1 | 1 | 0 | 0 | 0 | 1
 | Total | 1 | 0 | 3 | 11 | 29 | 41 | 23 | 8 | 2 | 0 | 0 | 0 | 1
 |  | Progress Summary - 2 Year
 |  | Sub-levels gained
 |  | 7+ | 6 | 5 | 4 | 3 | 2 | 1 | 0 | -1 | -2 | -3 | -4 or fewer | N/A
 | [NAME] 8 | 3 | 3 | 5 | 9 | 5 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 2
 | Cedar 8 | 4 | 8 | 12 | 6 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 3
 | Linden 8 | 13 | 5 | 8 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 8
 | Maple 8 | 2 | 3 | 12 | 7 | 3 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1
 | Total | 22 | 19 | 37 | 22 | 10 | 5 | 1 | 2 | 0 | 0 | 0 | 0 | 14
 |  | Pupils who have made unsatisfactory progress
 | 0 | sub-levels progress |  |  |  |  |  |  | "=INDEX('Raw data'!$A$2:$A$500,SMALL(IF('Raw data'!$A$2:$A$500=$B$28,ROW('Raw data'!$A$2:$A$500)),ROW('Raw data'!A2)),2)"
 |  | e
Spreadsheet: 488715d1478793300-advanced-filter-three-conditions-does-not-contain-between-and-contain-advance-filter-not-parameter-and-type-2
Sheet: Sheet1

CITY | VENUE | ROOM 1 CAPACITY | ROOM 1 CAPACITY 2 | ROOM 1 CAPACITY 3 | [NAME] | SECONDARY EMAIL | TYPE |  | QUERY
 |  |  |  |  |  |  |  |  | Show venues that meet all three criteria
CITY | VENUE | ROOM 1 CAPACITY | ROOM 1 CAPACITY 2 | ROOM 1 CAPACITY 3 | [NAME] | SECONDARY EMAIL | TYPE |  | Criteria 1
Arbroath | Webster Theatre | 550 | 120 |  | AR@WT | TH@WT | O |  | SHOW VENUES THAT ARE NOT IN THE FOLLOWING CITIES: ARBROATH, DERBY, NEWPORT
[NAME] | Market Place Theatre | 397 |  |  | AR@MPT | GH@MPT | T
Clacton-On-Sea | West Cliff Theatre | 600 |  |  | CL@WCT | EA@WCT | ALL
Coventry | Belgrade Theatre | 850 |  | 250 | CO@BT | RY@BT | O
Cromer | Pavilion | 510 |  |  | CR@P | ER@P | T
Derby | Conkers Amphitheatre | 700 |  |  | DE@CA | BY@CA | ALL
DORKING | Dorking Hall | 790 |  | 176 | DO@DH | NG@DH | ALL
Gravesend | Woodville | 700 |  |  | GR@W | ND@W | ALL |  | [NAME]
Loughborough | Loughborough Town Hall | 550 | 120 |  | LO@LTH | GH@LTH | O |  | Only show venues with capacities in either of the three rooms that are between 100 and 200 and does not include Blanks
Musselburgh | Brunton Theatre | 550 | 120 | 300 | MU@BT | GH@BT | T
Newport | Medina Theatre | 400 |  |  | NE@MT | RT@MT | ALL
Penistone | Paramount | 350 |  |  | PE@P | NE@P | T
PORT SUNLIGHT | Gladstone Theatre |  |  |  | PO@GT | HT@GT | T
Radlett | [NAME] | 300 |  |  | RA@RC | TT@RC | O
Rotherham | [NAME] | 356 |  |  | RO@RCT | AM@RCT | ALL
Swindon | Wyvern Theatre | 635 | 635 |  | SW@WT | ON@WT | O |  | Criteria 3
Yeovil | Octagon Theatre | 622 |  |  | YE@OT | IL@OT | O |  | Only show venues that have type T or ALL
Bury St Edmunds | The Apex | 650 | 516 |  | BU@TA | DS@TA | T
Cockermouth | The Kirkgate | 125 |  |  | CO@TK | TH@TK | O
Aberdare | Coliseum Theatre | 300 | 376 |  | AB@CT | RE@CT | T
Aberdeen | The Lemon Tree | 550 |  |  | AB@TLT | EN@TLT | ALL |  | result should be
Aberdeen | Tunnels | 300 |  |  | AB@T | EN@T | T |  | Brunton Theatre
Aberdeen | Krakatoa | 200 |  |  | AB@K | EN@K | O
Aberdeen | Music Hall | 1000 | 1300 |  | AB@MH | EN@MH | ALL |  | DORKING HALL
Spreadsheet: fc2c4fa5-9b27-4432-88c2-4970d9ff4188
Sheet: Sheet1

Unnamed: 0 | Immigration Work Permit ( Including  Renewals Pending) by Nationality  31-DEC 2007 | Unnamed: 2
 | CARIBBEAN | 12936
 | [NAME] | 7
 | Bahamas | 18
 | Barbados | 121
 | Belize | 29
 | Bermuda | 7
 | Cuba | 169
 | Dominica | 9
 | Dominican Republic | 230
 | Grenada | 5
 | Guyana | 329
 | Haiti | 11
 | Jamaica | 11679
 | [NAME] And Nevis | 1
 | [NAME] And The Grenadines | 37
 | St. Lucia | 44
 | St.Kitts-Nevis(Old-Do Not Use) | 10
 | The Cayman Islands | 1
 | Trinidad And Tobago | 229
 | ASIA | 3759
 | Afghanistan | 1
 | Belarus | 1
 | Brunei | 1
 | Burma | 2
 | India | 819
 | Indonesia | 43
 | Japan | 8
 | Korea, Republic Of | 7
 | Macau | 1
 | Malaysia | 23
 | Pakistan | 27
 | Philippines | 2661
 | Republic Of China | 58
 | Singapore | 4
 | [NAME] | 65
 | Syrian Arab Republic | 1
 | Taiwan | 1
 | Thailand | 35
 | Vietnam | 1
 | USA | 1462
 | UK | 1937
 | EUROPE | 771
 | Austria | 42
 | Belgium | 10
 | Bulgaria | 13
 | Croatia | 10
 | Czech Republic | 9
 | Czechoslovakia | 2
 | Denmark | 17
 | Estonia | 1
 | France | 52
 | German Democratic Republic | 1
 | Germany | 88
 | Greece | 4
 | Hungary | 21
 | Ireland | 221
 | Italy | 85
 | Latvia | 2
 | Lithuania | 1
 | Macedonia | 2
 | Netherlands | 28
 | Norway | 4
 | Poland | 8
 | Portugal | 15
 | Romania | 59
 | Slovak Republic | 3
 | Slovakia | 2
 | Slovenia | 4
 | Spain | 20
 | Sweden | 17
 | Switzerland | 19
 | Ukraine | 3
 | Yugoslavia | 8
 | CANADA | 1817
 | REST OF THE WORLD | 3268
 | Andorra | 3
 | Argentina | 33
 | Australia | 223
 | Bangladesh | 13
 | Benin | 1
 | Bolivia | 4
 | Botswana | 1
 | Brazil | 93
 | British Overseas Territories | 24
 | Cameroon | 1
 | Chile | 7
 | Colombia | 481
 | Congo | 1
 | Costa Rica | 139
 | Ecuador | 22
 | Egypt | 8
 | El Salvador | 3
 | Georgia | 1
 | Ghana | 5
 | Guatemala | 7
 | Honduras | 1162
 | Israel | 3
 | Jordan | 4
 | Kenya | 40
 | Lebanon | 24
 | Liberia | 1
 | [NAME] | 3
 | Mauritania | 2
 | [NAME] | 5
 | Mexico | 87
 | Namibia | 4
 | Nepal | 42
 | New Zealand | 111
 | Nicaragua | 274
 | Nigeria | 9
 | Panama | 21
 | Peru | 61
 | Russia | 12
 | Saudi Arabia | 3
 | South Africa | 234
 | Sudan | 1
 | Surinam | 4
 | Swaziland | 3
 | Tunisia | 1
 | Turkey | 17
 | Uganda | 1
 | United Republic Of Cameroon | 2
 | Uruguay | 3
 | Venezuela | 24
 | Zambia | 1
 | Zimbabwe | 39
 | GRAND TOTAL | 25950
 |  | 2007
 | TOTAL WORK PERMITS | 25950
 | ASIA | 3759
 | CANADA | 1817
 | CARIBBEAN | 12936
 | EUROPE | 771
 | UK | 1937
 | USA | 1462
 | REST OF THE WORLD | 3268
Spreadsheet: 103901d1301565131-indexing-months-in-a-formula-chinasaucer_month_issue
Sheet: Sheet16

 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  | Issue : Populate cells F1 : Q12 based on input criteria in D10:E14. Result should be similar to Table B below but based on formulas
 |  | Show 1 head in every month if start and leave month is zero
 |  | Show 1 head in start month and every month thereafter for new starters
 |  | Show 0 heads in leave month and every month thereafter for leavers
Table A | Person | Start Month | Leave Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total  Heads (FTE)
 | Person 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Person 2 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Person 3 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Person 4 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Person 5 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 4
Table B | Person | Start Month | Leave Month | Heads→ Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total  Heads (FTE)
 | Person 1 | 2 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.9166666666666666
 | Person 2 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Person 3 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Person 4 | 3 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.8333333333333334
 | Person 5 | 0 | 8 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 |  |  |  |  | 0.5833333333333334
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | 3 | 4 | 5 | 5 | 5 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 4.333333333333333
Spreadsheet: 0901c355-d156-4006-a7a8-89311497ff88
Sheet: masked_enroll

DIST_OF_RES_IRN | Enrolled1 | Enrolled2 | Enrolled3 | ORG_NM
000176 | 17 | 11 | 29 | Al Ihsan Islamic School
000476 | NC | NC | 167 | [NAME]
052662 | NC | NC | 72 | Benedictine
053629 | NC | NC | 138 | [NAME]
053660 | NC | NC | 103 | [NAME]
053702 | NC | NC | 211 | [NAME]
053983 | NC | NC | 355 | Cleveland Central Catholic
055749 | 31 | 17 | 94 | Holy Name
055814 | 23 | 35 | 104 | Our Lady Of Angels
055822 | 38 | 29 | 117 | [NAME] of Peace School
055855 | 24 | 31 | 96 | Our Lady Of Mt Carmel West
055913 | 39 | 24 | 75 | [NAME]
055947 | 28 | 18 | 69 | [NAME] Aloysius
056010 | 35 | 46 | 93 | [NAME]
056036 | 42 | 37 | 94 | [NAME]
056051 | 74 | 65 | 137 | [NAME]
056069 | 30 | 13 | 80 | St Jerome
056127 | 28 | 14 | 125 | [NAME] The Great
056143 | NC | 20 | 72 | [NAME]
056192 | 26 | 16 | 165 | West Park Catholic Academy
056242 | 37 | 35 | 64 | [NAME]
056267 | 59 | 42 | 141 | [NAME]
056275 | 69 | 54 | 310 | Metro Catholic Parish
056283 | 43 | 38 | 119 | [NAME]
056309 | 28 | 27 | 86 | [NAME]
056358 | 19 | 17 | 64 | [NAME]
060343 | 36 | 29 | 38 | [NAME]
060384 | 18 | 23 | 49 | St [NAME]
062562 | 40 | 46 | 137 | Urban Community
068189 | 18 | NC | 28 | Ramah Junior Academy
087809 | NC | NC | 20 | West Park Lutheran
097683 | NC | NC | NC | Birchwood
123364 | NC | NC | NC | Villa Montessori Center
126607 | NC | 13 | 100 | [NAME]
134478 | NC | NC | 10 | Montessori School at Holy Rosary
Spreadsheet: barry_tycholiz__884__Orig-WestYTD
Sheet: Summary Sched

 | Origination Summary Schedule - YTD-01
 |  |  |  |  |  | Origination |  | Number of
 | Originator |  |  | RC Code |  | Amount |  | Originated Deals
 | [NAME] | Tycholiz |  | 107321-01-BT
 | [NAME] | Whitt |  | 107321-02-MW
 | [NAME] | Lucci |  | 107321-03-PL
 | [NAME] | Ward |  | 107321-04-KW
 | [NAME] | [NAME] |  | 107321-05-SM
 | [NAME] | Fuller |  | 107321-06-DF
 | [NAME] | [NAME] |  | 107321-07-TH
 | [NAME] | Polsky |  | 107321-08-PP