tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 739393d1625671109-references-that-are-absolute-within-a-group-but-that-change-from-one-group-to-another-conditional-absolutes
Sheet: Sheet1

0.4300084113420484
-0.08225789261881604
1.715041894271427
0.8561831531896372
0.414027414866534
0.5050684436684535
0.9147987459009499
0.074689364327502
0.5816859679153719
-2.039263999614843
0.1767411562184511
-0.4904748016609767
0.02665623185885919
-0.2055386770135992
0.6792890466479975
0.5257258966989088
Spreadsheet: f7bac5b7-1344-4c8e-ab1b-dec564c98374
Sheet: Sheet1

Release: House Price Index | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=171
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-04-18 8:27 AM [NAME]
 | Real-Time | Period
Name: | Start | End
House Price Index | 2008-05-22 00:00:00 | Current
Link:
http://www.fhfa.gov/ | 2008-05-22 00:00:00 | Current
Source:
Federal Housing Finance Agency | 2008-05-22 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2008-05-22 00:00:00
2008-08-26 00:00:00
2008-11-25 00:00:00
2009-02-24 00:00:00
2009-05-27 00:00:00
2009-08-25 00:00:00
2009-11-24 00:00:00
2010-02-25 00:00:00
2010-05-25 00:00:00
2010-08-25 00:00:00
2010-11-24 00:00:00
2011-02-24 00:00:00
2011-05-25 00:00:00
2011-08-24 00:00:00
2011-11-29 00:00:00
2012-02-23 00:00:00
2012-05-23 00:00:00
2012-06-21 00:00:00
2012-07-24 00:00:00
2012-08-23 00:00:00
2012-09-25 00:00:00
2012-10-24 00:00:00
2012-11-27 00:00:00
2012-12-20 00:00:00
2013-01-23 00:00:00
2013-02-26 00:00:00
2013-03-21 00:00:00
2013-04-23 00:00:00
2013-05-23 00:00:00
2013-06-25 00:00:00
2013-07-23 00:00:00
2013-08-22 00:00:00
2013-09-24 00:00:00
2013-10-23 00:00:00
2013-11-26 00:00:00
2013-12-24 00:00:00
2014-01-23 00:00:00
2014-02-25 00:00:00
2014-03-25 00:00:00
Spreadsheet: dba3155b-b5e5-4907-9a1d-d627cf2b763e
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
AMPCC | Test | AMPCC | AMPA-Receptor Antibody by CBA, Spinal Fluid | AMPA-R Ab CBA, CSF | Cell-binding assay (CBA) detects IgG specific for 2 amino-3 (5-methyl 3 oxo-1,2 oxazole 4 yl) propanoic acid receptor (AMPA-R) by indirect immunofluorescence (IFA) | Plastic vial: PlV |  |  | 1 | mL | Container/Tube: Sterile vial [NAME]: 1 mL Additional Information: Include relevant clinical information, name, phone number, mailing address, and E-mail address (if applicable) of ordering physician | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK  Lipemia	Mild OK; Gross reject Icterus	Mild reject; Gross reject Other	NA | Negative | Wednesday, Friday; 8 a.m. | Negative: 2-4 days; Positive: 5-7 days | 6 days | 1 | 86255 |  |  |  |  | Rochester
AMPCC | [NAME] | CSF | CSF |  |  |  | Refrigerated | 28 days
AMPCC | Result | 61514 | AMPA-R Ab CBA, CSF | AMPA-R Ab CBA, CSF | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 455809d1460503589-matching-values-with-two-ranges-of-data-copy-of-test
Sheet: E-mail source

Last Name | First Name | Job Description/Duties | email address
[NAME] | Yvette | Manager* | [EMAIL]
[NAME] | Amayrany | Medical Assistant | [EMAIL]
[NAME] | Thelma | Front office receptionist | [EMAIL]
[NAME] | Alexis Christine | Check Out / Medical Assistant | [EMAIL]
Del Mundo | [NAME] | Medical Assistant | [EMAIL]
Encinas | [NAME] | Assistant Manager | [EMAIL]
[NAME] | Rico | [NAME] / Medical Assistant | [EMAIL]
Fayez | Maged | [NAME] / Medical Assistant | [EMAIL]
Galvan | Elena | Medical [NAME] | [EMAIL]
[NAME] | Jesica | Front office Receptionist | [EMAIL]
Lopez | Karina | Medical Assistant | [EMAIL]
Mankarious | Lydia | [NAME] / Medical Assistant | [EMAIL]
Martinez | [NAME] | [NAME] | [EMAIL]
Spreadsheet: 31400d1227213195-conditional-sum-to-match-against-drop-down-list-supplierdraft
Sheet: DEC

Supplier | Brand | Type | Description | GTV @ MTV | G-Sports | G-Ent | ALL
Apple | Apple | Computer Hardware | 2 x [NAME] for MTV suites | 1345 | 0 | 0 | 1345 |  |  |  | SUPPLIER
DreamTek | Sony | ProVid Hardware | 2 x DVW-500 Decks - MTV and G-Sports | 2398 | 2398 | 0 | 4796 |  |  |  | Apple | 2692
MediaP | HP | Tape Stock | LTO Stock - G-Ent | 0 | 0 | 4765 | 4765 |  |  |  | DreamTek
NMR | Sony | Computer Hardware | 5 x [NAME] (MTV) | 9547 | 0 | 0 | 9547 |  |  |  | NMR
NMR | Sony | ProVid Hardware | 1 x Sony DSR1500 (G-Sports) | 0 | 9200 | 0 | 9200 |  |  |  | MediaP
DreamTek | Fuji | Tape Stock | 100 DigBeta 32 min (G-Sports) | 0 | 3500 | 0 | 3500 |  |  |  | TapeHouse
ProTape | Samsung | Tape Stock | 100 DigBeta 32 min (MTV) | 3875 | 0 | 0 | 3875 |  |  |  | SpectraLogic
Apple | LG | [NAME] | [NAME] | 1347 | 0 | 0 | 1347 |  |  |  | ProTape
 |  |  |  |  |  |  | 0 |  |  |  | Panasonic
 |  |  |  |  |  |  | 0 |  |  |  | Scrubs
 |  |  |  |  |  |  | 0 |  |  |  | The Farm
 |  |  |  |  |  |  | 0 |  |  |  | Viking
 |  |  |  |  |  |  | 0 |  |  |  | [NAME]
 |  |  |  |  |  |  | 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
 |  |  |  | 18512 | 15098 | 4765 | 38375
Apple | 8296
Spreadsheet: 76560d1277117831-excel-2007-if-condition-test
Sheet: Sheet1

CSA | 11 | 15 | 16 | 17 | 18 | 19 | 20 | 25 | 30 | 35 | 39 | 40
TL
QTL
Spreadsheet: sally_beck__36191__2001 Plan - Actualization
Sheet: Load

 |  | COMPANY NUMBER: |  |  |  |  | HYPERION ENTITY:
 |  | R/C NUMBER: |  |  |  |  | HYPERION CATEGORY: | PLAN2000
 |  | R/C NAME: |  |  |  |  | HYPERION FREQUENCY: | M.PER
 |  | R/C OWNER: |  |  |  |  | HYPERION APPLICATION: | EES
 | STAFFING SUMMARY |  | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00
EXECUTIVE | Executive
DIRECTOR | Director
MANAGER | Manager
EXECUTIVE_NC | Non-Commercial Executive
DIRECTOR_NC | Non-Commercial Director
MANAGER_NC | Non-Commercial Manager
ASSOCHC | Associates
ALYSTHC | Analysts
OTHER_HC | Other Commercial
OTHER_NC_HC | Other Non Commercial
ADMIN_ASST | Administrative Asst.
 | Subtotal Employee Headcount
CONTHC | Contractors
 | TOTAL HEADCOUNT
HYPERION  ACCT | DIRECT EXPENSES |  | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 | Total
[PHONE].000000 | Salaries & Wages
[PHONE].000000 | Special Pays
 | Subtotal Compensation
[PHONE].000000 | Benefits
[PHONE].000000 | Payroll Taxes
 | Subtotal Benefits and Payroll Taxes
[PHONE].000000 | Conferences & Training
[PHONE].000000 | Employee Memberships & Dues
[PHONE].000000 | Overtime/Working Meals
[PHONE].000000 | Pager/Cellular Expenses
[PHONE].000000 | Travel
[PHONE].000000 | Tuition Reimbursement
[PHONE].000000 | Other Employee Expenses
 | Subtotal Employee Expenses
[PHONE].000000 | Campus Recruiting
[PHONE].000000 | Employment Ads
[PHONE].000000 | Interview Expenses
[PHONE].000000 | Recruiting Agency Fees
[PHONE].000000 | Relocation Expenses
[PHONE].000000 | Other Recruiting & Relocation Expenses
 | Subtotal Recruiting & Relocations
[PHONE].000000 | Professional Consultants/Contractors
[PHONE].000000 | Temporaries
[PHONE].000000 | Other Outside Services
 | Subtotal Outside Services
[PHONE].000000 | Company Membership & Dues
[PHONE].000000 | Non-Real Time Market Data
[PHONE].000000 | Office Supplies
[PHONE].000000 | Postage & Freight Expense
[PHONE].000000 | Real Time Market Data
[PHONE].000000 | Subscriptions & Periodicals
[PHONE].000000 | Other Supplies and Expenses
 | Subtotal Supplies and Expense
[PHONE].000000 | Advertising & Promotions
[PHONE].000000 | Client Entertainment
[PHONE].000000 | Customer Meetings
[PHONE].000000 | Other Marketing
 | Subtotal Marketing
[PHONE].000000 | Charitable Contributions
[PHONE].000000 | Rent - Office, Warehouse, & Tower
[PHONE].000000 | Equipment Rental
 | Subtotal Rent (3rd Party)
[PHONE].000000 | Technology
[PHONE].000000 | Transportation
[PHONE].000000 | Corporate IT
[PHONE].000000 | Corporate Rent
9302999.000000 | Other Expenses
 | Subtotal Cash Expenses
4030100.000000 | Depreciation
4040410.000000 | Amortization
 | Subtotal Depreciation & Amortization
 | TOTAL DIRECT EXPENSES
Spreadsheet: 63719d1264597935-transferring-information-from-one-table-format-to-another-test
Sheet: Sheet1

EFS | Mr [NAME] | Mr Singh | [NAME]
Presentation master class | Mr [NAME] | Mr [NAME] | Mr [NAME]
Presentation skills | [NAME] | Mr [NAME] | Mr [NAME]
SEW | Mr [NAME] | Mr Beardsley | Mr [NAME]
EFS | Mr Rieche | Mr Wimmers | Mr [NAME]
Converts to:
 | EFS | Presentation skills master class | Presentation skills | SEW
Mr [NAME] | Yes | No | No | No
Mr [NAME] | Yes | Yes | No | No
[NAME] | Yes | No | Yes | No
Mr [NAME] | No | No | No | Yes
Mr Rieche | Yes | No | No | No
Mr Singh | Yes | No | No | No
Mr [NAME] | No | Yes | No | No
Mr [NAME] | No | No | Yes | Yes
Mr Beardsley | No | No | No | Yes
Mr Wimmers | Yes | No | No | No
Mr [NAME] | No | Yes | No | No
Mr [NAME] | No | No | Yes | No
Spreadsheet: 647870d1572693972-column-search-with-various-formats-of-names-office-problem
Sheet: Results Expected

Rearranged Search Names and Date | Date | Search against this Coloumn | Record 1D | Date | [NAME] (if matched, print the row)
[NAME] | 2018-12-25 00:00:00 | Names 1 |  |  | 6
[NAME] | 2012-12-11 00:00:00 | Names 2 Surname |  |  | 11
[NAME] | 2012-08-10 00:00:00 | Surname Name 3 |  |  | Not available
[NAME] | 2019-06-12 00:00:00 | Name_Surname4 |  |  | Not available
[NAME] ven desol | 2018-04-12 00:00:00 | Tanya, Surname_25/12/18 |  |  | 12
[NAME] | 2013-11-10 00:00:00 | Surname Name 4 |  |  | 16
[NAME] | 2016-06-15 00:00:00 | Surname Name 5 |  |  | 17
[NAME] | 2018-10-23 00:00:00 | Surname Name 6
list continues | List continues | Surname Name 6
 |  | [NAME]
 |  | [NAME] ven desol_12/04/18
 |  | Surname kenny_10/08/12
 |  | [NAME]
 |  | [NAME] ven desol_12/04/18
 |  | [NAME] | [NAME] Jones|_10/11/13
 |  | Vince_Surname
Spreadsheet: kate_symes__18310__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-04-17 00:00:00 |  | 229.42 | 18496 | 95.12 | 12096
 | 2001-04-16 00:00:00 |  | 229.53 | 12208 | 115.94 | 6400 | 160.59 | 4001 | 107.53 | 1253
 | 2001-04-15 00:00:00 |  | 225 | 0 | 110 | 0 | 51.43 | 665 | 27.78 | 90 |  | 115.16 | 27000
 | 2001-04-14 00:00:00 |  | 155.23 | 23600 | 76.12 | 10400 | 130.86 | 1510 | 52.21 | 510
 | 2001-04-13 00:00:00 |  | 155.23 | 23600 | 76.12 | 10400 | 113.58 | 2005 | 92.43 | 493
 | 2001-04-12 00:00:00 |  | 173.67 | 28080 | 86.85 | 9600 | 154.54 | 3865 | 74.1 | 415
 | 2001-04-11 00:00:00 |  | 179.1 | 25424 | 91.37 | 9280 | 176.83 | 2341 | 68.53 | 739
 | 2001-04-10 00:00:00 |  | 175.51 | 21664 | 89.05 | 7360 | 152.75 | 5195 | 106.04 | 1927
 | 2001-04-09 00:00:00 |  | 140.37 | 29824 | 99.04 | 10024 | 160.69 | 4429 | 82.6 | 1221
 | 2001-04-08 00:00:00 |  | 135 | 0 | 99 | 0 | 94.68 | 4331 | 89.95 | 950 |  | 98.94 | 30072
 | 2001-04-07 00:00:00 |  | 163.25 | 24928 | 78.81 | 9720 | 124.58 | 4097 | 104.49 | 973
 | 2001-04-06 00:00:00 |  | 163.25 | 24928 | 78.81 | 9720 | 144.64 | 4383 | 107.57 | 1185
 | 2001-04-05 00:00:00 |  | 210.51 | 39072 | 95.69 | 12336 | 113.42 | 2159 | 94.37 | 1318
 | 2001-04-04 00:00:00 |  | 235.75 | 35568 | 96.01 | 11864 | 134.48 | 2153 | 65.34 | 1391
 | 2001-04-03 00:00:00 |  | 232.48 | 34768 | 101.7 | 8424 | 124.35 | 2275 | 80.72 | 166
 | 2001-04-02 00:00:00 |  | 234.1 | 20032 | 134.92 | 8456 | 151.72 | 5836 | 152.21 | 1055
 | 2001-04-01 00:00:00 |  | 150 | 800 | 130 | 0 | 169.97 | 4993 | 179.55 | 3133 |  | 136.89 | 20112
 | 2001-03-31 00:00:00 |  | 155.24 | 26800 | 79.32 | 5000 | 203.27 | 4434 | 161.69 | 2164
 | 2001-03-30 00:00:00 |  | 155.24 | 26800 | 78.68 | 5600 | 166.55 | 6883 | 125.76 | 3604
 | 2001-03-29 00:00:00 |  | 149.29 | 27472 | 74.97 | 7680 | 151.01 | 3119 | 106.73 | 2737
 | 2001-03-28 00:00:00 |  | 117.91 | 28384 | 64.05 | 8795 | 135.59 | 5365 | 79.21 | 2138
 | 2001-03-27 00:00:00 |  | 107.14 | 26352 | 54.09 | 6800 | 138.05 | 5768 | 73.14 | 3889
 | 2001-03-26 00:00:00 |  | 280.53 | 20768 | 160.99 | 5520 | 115.17 | 3547 | 66.57 | 2059
 | 2001-03-25 00:00:00 |  | 200 | 0 | 135 | 200 | 80.99 | 1643 | 75.59 | 545 |  | 162.46 | 16560
 | 2001-03-24 00:00:00 |  | 233.04 | 14608 | 130.51 | 4880 | 130 | 6097 | 179.92 | 3350
 | 2001-03-23 00:00:00 |  | 233.24 | 14448 | 130.51 | 4880 | 324.97 | 6129 | 242.2 | 3200
 | 2001-03-22 00:00:00 |  | 281.29 | 18448 | 160.38 | 5360 | 385.71 | 8040 | 282.16 | 2915
 | 2001-03-21 00:00:00 |  | 460.02 | 24848 | 198.73 | 8120 | 350.98 | 4786 | 253.67 | 1853
 | 2001-03-20 00:00:00 |  | 377.03 | 18384 | 176.12 | 5120 | 390.83 | 2452 | 357.57 | 1668
 | 2001-03-19 00:00:00 |  | 297.33 | 24848 | 176.6 | 9000 | 258.33 | 3388 | 199.67 | 2448
 | 2001-03-18 00:00:00 |  | 220 | 0 | 185 | 0 | 170.47 | 4949 | 156.95 | 2582 |  | 178.66 | 28200
Spreadsheet: f9e289dc-4737-473f-a725-c05170da5888
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
3608 | 21724 | Samantha | Toop | GBR | 171 | 00:24:56 | 00:00:00 | 00:44:46 | 00:00:00 | 00:48:01 | 1 | [NAME]
Spreadsheet: 78450d1278811246-lookup-a-cell-that-corresponds-with-running-total-find-target-sum-with-offset
Sheet: Plan1

Dates | Sales | 2011-05-07 00:00:00 | 320 | this column is just to show it works and isn't used in calculation
2010-01-07 00:00:00 | 10 |  |  | 10
2010-02-07 00:00:00 | 5 |  |  | 15
2010-03-07 00:00:00 | 5 |  |  | 20 |  | Dates | Sales | 2010-01-07 00:00:00 | 35
2010-04-07 00:00:00 | 20 |  |  | 40 |  | 2010-01-07 00:00:00 | 10
2010-05-07 00:00:00 | 10 |  |  | 50 |  | 2010-02-07 00:00:00 | 5
2010-06-07 00:00:00 | 40 |  |  | 90 |  | 2010-03-07 00:00:00 | 5
2010-07-07 00:00:00 | 6 |  |  | 96 |  | 2010-04-07 00:00:00 | 20
2010-08-07 00:00:00 | 17 |  |  | 113 |  | 2010-05-07 00:00:00 | 10
2010-09-07 00:00:00 | 11 |  |  | 124
2010-10-07 00:00:00 | 7 |  |  | 131
2010-11-07 00:00:00 | 30 |  |  | 161
2010-12-07 00:00:00 | 43 |  |  | 204
2011-01-07 00:00:00 | 35 |  |  | 239
2011-02-07 00:00:00 | 38 |  |  | 277
2011-03-07 00:00:00 | 9 |  |  | 286
2011-04-07 00:00:00 | 32 |  |  | 318
2011-05-07 00:00:00 | 16 |  |  | 334
2011-06-07 00:00:00 | 12
2011-07-07 00:00:00 | 25
2011-08-07 00:00:00 | 41
2011-09-07 00:00:00 | 4
2011-10-07 00:00:00 | 13
2011-11-07 00:00:00 | 44
2011-12-07 00:00:00 | 21
2012-01-07 00:00:00 | 45
2012-02-07 00:00:00 | 43
2012-03-07 00:00:00 | 24
2012-04-07 00:00:00 | 15
2012-05-07 00:00:00 | 35
2012-06-07 00:00:00 | 37
2012-07-07 00:00:00 | 40
2012-08-07 00:00:00 | 42
2012-09-07 00:00:00 | 8
2012-10-07 00:00:00 | 35
2012-11-07 00:00:00 | 28
2012-12-07 00:00:00 | 6
2013-01-07 00:00:00 | 20
2013-02-07 00:00:00 | 32
2013-03-07 00:00:00 | 23
2013-04-07 00:00:00 | 31
2013-05-07 00:00:00 | 40
2013-06-07 00:00:00 | 36
2013-07-07 00:00:00 | 0
2013-08-07 00:00:00 | 37
2013-09-07 00:00:00 | 32
2013-10-07 00:00:00 | 22
2013-11-07 00:00:00 | 40
2013-12-07 00:00:00 | 34
2014-01-07 00:00:00 | 29
Spreadsheet: 776546d1649782394-formula-must-ignore-empty-cells-actually-containing-formula-but-showing-empty-book4
Sheet: Sheet1

 | dgfhicjskeoiuis
 |  |  |  | g | f | h | i | c | j | s | k | e | o | i | u | i | s | d | g | f | h | i | c | j | s | k | e | o | i | u | i
Spreadsheet: 128982d1321385267-conditional-formatting-in-relation-to-a-target-year-10-new
Sheet: Year 10 data

Surname | Forename | Form | Sex | Intervention | G&T? | Target | End of Year 9 Grade | Religion & Animals 1 Mark | Religion and animals 1 % | Religion and animals 1 grade | Religion & Animals 2 Mark | Religion and animals 2 % | Religion and animals 2 grade | Religion & Prejudice 1 Mark | Religion & Prejudice 1 % | Religion and prejudice 1 grade | Religion & Animals & Religion & Prejudice combined mark | Religion & animals & Religion and prejudice combined grade | Religion & Prejudice 2 mark | Religion and prejudice 2 % | Religion & Prejudice 2 grade | War & Peace 1 Mark | War and Peace 1 % | War and Peace 1 grade | Religion & Prejudice 2 & War & Peace 1 combined mark | Religion & prejudice 2 & War & Peace 1combined grade | War & Peace 2 Mark | War and Peace 2 % | War and Peace 2 grade | Does God exist 1 Mark | Does God exist 1 % | Does God exist 1grade | War & Peace 2 & Does God exist 1 combined mark | War & Peace 2 & Does God exist 1 combined grade | Does God exist [NAME] | Does God exist 2 % | Does God exist 2 grade | Revlation 1 Mark | Revelation 1 % | Revlation 1grade | Revelation 1 & Does God exist 2 combined mark | Revelation 1 & Does God exist 2 combined grade | Religion and animals grade | Religion and prejudice & Religion & animals combined grade | War and Peace  & Religion & prejudice combined grade | Does God exist grade & War & Peace combined grade | Revelation & Does God exist combined Grade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Conditional Formatting
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Red
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Green
Spreadsheet: d5c60d7d-c927-48ee-957c-6522d4919e65
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4851 | 8137 | [NAME] | Bradley-Cox | USA | 0 | 00:31:02 | 00:03:35 | 01:16:46 | 00:01:55 | 01:07:07 | 1 | 03:00:26
4851 | 13350 | [NAME] | Val | USA | 0 | 00:37:30 | 00:04:10 | 01:21:45 | 00:02:21 | 01:07:07 | 2 | 03:12:51
4851 | 8150 | Helen | Geoffrion | USA | 0 | 00:36:49 | 00:05:38 | 01:48:52 | 00:04:01 | 01:26:43 | 3 | 04:02:04
4851 | 21314 | [NAME] | [NAME] | USA | 0 | 00:56:55 | 00:04:36 | 01:41:07 | 00:02:58 | 01:38:20 | 4 | 04:23:55
4851 | 8155 | [NAME] | Isaacs | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNS | 00:00:00
Spreadsheet: 840381d1692700525-conutifs-row-and-column-data
Sheet: summary

 | SUMMARY
 | HEO Learning Needs Analysis
 |  |  |  |  |  | COUNT & % (count/heo)
 | Learning Area | Courses | Reference | Media | Access From | 1 | 2 | 3 | 4
 |  | NAME |  |  |  |  |  |  |  |  |  | #N/A
 | Induction &  Onboarding | DWP Induction | N/A | Various | Intranet | 1 | 2 | 1 | 1 |  |  | #N/A
 |  | ODP Induction Learning (2020) | N/A | E Learning | Civil Service Learning |  | 1 |  |  |  |  | #N/A
 |  | Diversity and inclusion - I Can Be Me campaign | N/A | Open Learning | Intranet | 1 | 1 |  |  |  |  | #N/A
 |  | [NAME] | N/A | Open Learning | Intranet | 1 |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A
Spreadsheet: 181885d1348180301-help-with-setting-up-a-spreadsheet-to-calculate-personal-expenses-expenses
Sheet: Breakdown

 |  |  | Detail 1 | C161:C187 | C84:C160 | C1:C83 | Note: If possible, I would like to be able to setup the ranges here so I don't have to change them at the cell level.
 |  |  | Detail 1 | F161:F187 | F84:F160 | F1:F83
 |  |  | [NAME] 2 | B26:B29 | B11:B25 | B1:B10
 |  |  | [NAME] 2 | E26:E29 | E11:E125 | E1:E10
 |  | Expenses- YTD | YTD | September | August | July
 |  | Type
 |  | Utilities
 |  | Bills
 |  | Shopping/Entertainment
 |  | Restaurant
 |  | Groceries
 |  | Health_&_Beauty
 |  | Total
Spreadsheet: 803616d1667573859-formula-to-find-next-available-number-day-from-range-example-1-
Sheet: Sheet1

Day of Collection | GRP DD1 | GRP DD2 | GRP DD3 | GRP DD4 | GRP DD5 | Required Result
2 | 1 | 2 | 3 | 4 | 5 | 3
5 | 1 | 2 | 3 | 4 | 5 | 1
5 | 1 | 2 | 3 | 4 | 5 | 1
3 | 1 | 2 | 3 | 4 | 5 | 4
3 | 1 | 2 | 3 | 4 | 5 | 4
5 | 1 | 2 | 3 | 4 | 5 | 1
3 | 1 | 2 | 3 | 4 | 5 | 4
5 | 1 | 2 | 3 | 4 | 5 | 1
3 | 1 | 2 | 3 | 4 | 5 | 4
2 | 1 | 2 | 3 | 4 | 5 | 3
4 | 1 | 2 | 3 | 4 | 5 | 5
2 | 1 | 2 | 3 | 4 | 5 | 3
1 | 1 | 2 | 3 | 4 | 5 | 2
1 | 1 | 2 | 3 | 4 | 5 | 2
4 |  | 2 | 3 |  | 5 | 5
5 |  | 2 | 3 |  | 5 | 2
4 |  | 2 | 3 |  | 5 | 5
5 | 1 | 2 | 3 |  |  | 1
Spreadsheet: 83716d1283762553-split-text-use-in-vlookup-and-concatenate-results-book1
Sheet: Countervalue

CountervalueID | Countervalue Description
Counter001 | Desc
Counter002 | Desc
Counter003 | Desc
Counter004 | Desc
Counter005 | Desc
Counter006 | Desc
Counter007 | Desc
Counter008 | Desc
Counter009 | Desc
Counter010 | Desc
Counter011 | Desc
Counter012 | Desc
Counter013 | Desc
Counter014 | Desc
Counter015 | Desc
Counter016 | Desc
Counter017 | Desc
Counter018 | Desc
Counter019 | Desc
Counter020 | Desc
Counter021 | Desc
Counter022 | Desc
Counter023 | Desc
Counter024 | Desc