tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: john_griffith__16094__1_18_02ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG G2 | 225 | 22 | 24 | 74.1 | 80.9 | 10.96 | 2002-01-18 10:22:00
 | NG H2 | 225 | 36 | 37.5 | 62.5 | 65.1 | 9.02 | 2002-01-18 10:22:00
 | NG J2 | 230 | 39 | 41.5 | 50.4 | 53.7 | 7.53 | 2002-01-18 10:22:00
 | NG K2 | 235 | 45 | 47 | 47.1 | 49.3 | 7.12 | 2002-01-18 10:22:00
 | NG M2 | 240 | 50 | 53 | 44.5 | 47.2 | 6.92 | 2002-01-18 10:22:00
 | NG N2 | 250 | 58 | 61 | 45.1 | 47.5 | 7.28 | 2002-01-18 10:22:00
 | NG Q2 | 255 | 65 | 68 | 45.6 | 47.7 | 7.48 | 2002-01-18 10:22:00
 | NG U2 | 255 | 70 | 73 | 45.6 | 47.6 | 7.47 | 2002-01-18 10:22:00
 | NG V2 | 255 | 75.5 | 78.5 | 46.4 | 48.3 | 7.59 | 2002-01-18 10:22:00
 | NG X2 | 275 | 87 | 90 | 46.9 | 48.6 | 8.26 | 2002-01-18 10:22:00
 | [NAME] | 295 | 98.5 | 103 | 47.4 | 49.6 | 9 | 2002-01-18 10:22:00
 | NG F3 | 305 | 108 | 112 | 48.3 | 50.2 | 9.44 | 2002-01-18 10:22:00
 | NG H3 |  |  |  |  |  |  | 2002-01-14 14:57:00
 | NG M3 |  |  |  |  |  |  | 2002-01-07 10:05:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 34cdf8f0-c904-467e-aceb-380cb565cd4d
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
[NAME] | Test | [NAME] | [NAME], Stool | [NAME], Stool | Conventional Culture Technique |  |  |  |  |  | [NAME] must arrive within 72 hours of collection.   Container/Tube: Commercially available transport system specific for recovery of enteric pathogens from fecal specimens (15 mL of non-nutritive transport medium containing phenol red as a pH indicator, such as Cary-Blair).  [NAME] Representative portion of stool specimen | 1 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	Stool swab, stool in [NAME] (green cap), Preserved stool >72 hours, specimen in buffered glycerol saline transport media | No growth | Monday through Sunday | 3 days | 5 days | 1 | 87081 |  |  |  |  | Rochester
[NAME] | [NAME] | FECAL | Fecal |  |  |  | Ambient | 72 hours
[NAME] | Order Question | Q00M0063 | [NAME] |  | Plain Text
[NAME] | Result | [NAME] | [NAME], Stool | [NAME], Stool | Alphanumeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | 6581-3 | Vibrio sp identified:Prid:Pt:XXX:Organism specific culture
Spreadsheet: 198194d1354702347-is-it-possible-to-save-csv-file-with-non-english-characters-913365454523
Sheet: 4545456677

Keyword | Competition | Global Monthly Searches | Google Search Network | Local Monthly Searches (Israel) | Approximate CPC (Search) - ILS
[house] | 0.68 | 1300 | 2400 | 1300 | 14.2
[green] | 0.87 | 12100 | 14800 | 12100 | 17.83
[אינסטלטור] | 0.82 | 5400 | 5400 | 5400 | 15
Spreadsheet: 266676d1379695664-going-around-if-statement-with-too-many-arguments-pay-rate-table
Sheet: Sheet1

 | Hire through 26 weeks | Weeks 27 through 52 | Week 53 through 78 | Week 78 through 104
4000 | 10.73 | 11.4 | 12.07 | 12.74
4011;4012;4013;4014;4016;4017 | 14.19 | 15.08 | 15.97 | 16.86
4021;4026;4027 | 15.08 | 16.02 | 16.96 | 17.91
4031;4036;4037 | 16.89 | 17.95 | 19 | 20.06
5010 | 11.97 | 12.72 | 13.47 | 14.22
5012 | 15.25 | 16.21 | 17.16 | 18.11
5016 | 18.42 | 19.57 | 20.72 | 21.87
5013 | 18.42 | 19.57 | 20.72 | 21.87
5011 | 21.14 | 22.46 | 23.78 | 25.1
Spreadsheet: 122413d1316788531-range-of-cells-question-summary-0911b
Sheet: East Texas

September 2011
Home Facility | Employee | Shared Facility | Job Code | Rate of Pay | Hours Shared | OT Hours Shared | Wages | OT Wages
Linden |  |  |  |  |  |  | 0 | 0
Total: |  |  |  |  | 0 | 0 | 0 | 0
[NAME] |  |  |  |  |  |  | 0 | 0
Total: |  |  |  |  | 0 | 0 | 0 | 0
Mt. Pleasant |  |  |  |  |  |  | 0 | 0
Total: |  |  |  |  | 0 | 0 | 0 | 0
New Boston |  |  |  |  |  |  | 0 | 0
Total: |  |  |  |  | 0 | 0 | 0 | 0
Omaha |  |  |  |  |  |  | 0 | 0
Total: |  |  |  |  | 0 | 0 | 0 | 0
Regency |  |  |  |  |  |  | 0 | 0
Total: |  |  |  |  | 0 | 0 | 0 | 0
Ridgecrest |  |  |  |  |  |  | 0 | 0
Total: |  |  |  |  | 0 | 0 | 0 | 0
Terrell |  |  |  |  |  |  | 0 | 0
Total: |  |  |  |  | 0 | 0 | 0 | 0
Upshur |  |  |  |  |  |  | 0 | 0
Total: |  |  |  |  | 0 | 0 | 0 | 0
Spreadsheet: darron_c_giron__7957__midland_cogen
Sheet: firm9805

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
1998-05-01 00:00:00
IFGMR (TRKL/TX) |  |  | 2.2 |  |  | No. of Days: | 31
IFGMR (TRKL/LA) |  |  | 2.19
IFGMR (PEPL/TX/OK) |  |  | 2.18
IFGMR (ANR/LA) |  |  | 2.19
IFGMR (HENRY HUB) |  |  | 2.27
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302 (Ultramar)
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001
 | 1993 | 2.4 | 2002
 | 1994 | 2.51 | 2003
 | 1995 | 2.61 | 2004
 | 1996 | 2.53 | 2005
 | 1997 | 2.65 | 2006
 | 1998 |  | 2007 | 6.37
 | 1999
 | 2000
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-305 (Union Pacific)
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D
*Customer prefers rounding to nearest penny.
Spreadsheet: 4ecc7828-85c7-40c2-9cec-a62c529850d7
Sheet: Sheet1

GIM FT South East Asia Itinerary
 | Su, 17th | M, 18th | T, 19th | W, 20th | R, 21st | F, 22nd | Sa, 23rd
City |  | Chicago/Seoul | [NAME] | Bangkok | Bangkok | Bangkok/Siem Reap | [NAME]
Flights |  | D: ORD, 12:30 | A: 21:05 PM |  |  | D: BKK, 17:55; A: REP, 18:55
 | Su, 24th | M, 25th | T, 26th | W, 27th | R, 28th | F, 29th | Sa, 30th
City | [NAME] | Hanoi | Hanoi | [NAME] | Saigon | Saigon | Chicago
Flights | D: REP, 19:15; A: HAN, 20:55 |  |  | [NAME] |  | D: SGN, 23:55 | A: ORD, 10:05
Spreadsheet: 851555d1701772362-return-value-based-on-2-conditions-shift_calculator
Sheet: Sheet1

Date | Dayshift (6am-6pm) | [NAME] (6pm - 6am) |  |  | date you're looking for | time of entry |  | Result
2023-11-30 00:00:00 | C | D |  |  | 2023-11-03 00:00:00 | 01:43:12
2023-12-01 00:00:00 | C | D |  |  | 2023-11-16 00:00:00 | 20:05:43
2023-12-02 00:00:00 | A | C |  |  | 2023-11-16 00:00:00 | 20:06:29
2023-12-03 00:00:00 | A | C |  |  | 2023-11-16 00:00:00 | 20:06:43
2023-12-04 00:00:00 | B | A |  |  | 2023-11-24 00:00:00 | 12:16:15
2023-12-05 00:00:00 | B | A |  |  | 2023-11-24 00:00:00 | 14:08:08
2023-12-06 00:00:00 | D | B |  |  | 2023-11-25 00:00:00 | 19:30:59
2023-12-07 00:00:00 | D | B |  |  | 2023-11-27 00:00:00 | 02:56:45
2023-12-08 00:00:00 | C | D |  |  | 2023-11-27 00:00:00 | 02:56:50
2023-12-09 00:00:00 | C | D |  |  | 2023-11-27 00:00:00 | 05:47:36
2023-12-10 00:00:00 | A | C |  |  | 2023-11-29 00:00:00 | 00:22:08
2023-12-11 00:00:00 | A | C |  |  | 2023-11-29 00:00:00 | 01:52:08
2023-12-12 00:00:00 | B | A |  |  | 2023-11-29 00:00:00 | 01:52:22
2023-12-13 00:00:00 | B | A |  |  | 2023-11-29 00:00:00 | 14:41:43
2023-12-14 00:00:00 | D | B |  |  | 2023-11-29 00:00:00 | 14:46:50
2023-12-15 00:00:00 | D | B |  |  | 2023-11-29 00:00:00 | 14:47:50
2023-12-16 00:00:00 | C | D |  |  | 2023-11-30 00:00:00 | 15:35:01
2023-12-17 00:00:00 | C | D |  |  | 2023-11-30 00:00:00 | 19:01:02
2023-12-18 00:00:00 | A | C |  |  | 2023-11-30 00:00:00 | 19:00:51
2023-12-19 00:00:00 | A | C |  |  | 2023-12-02 00:00:00 | 23:48:50
2023-12-20 00:00:00 | B | A |  |  | 2023-12-02 00:00:00 | 23:51:51
2023-12-21 00:00:00 | B | A |  |  | 2023-12-03 00:00:00 | 10:28:44
2023-12-22 00:00:00 | D | B |  |  | 2023-12-03 00:00:00 | 10:31:01
2023-12-23 00:00:00 | D | B |  |  | 2023-12-03 00:00:00 | 17:36:29
2023-12-24 00:00:00 | C | D |  |  | 2023-12-04 00:00:00 | 11:27:08
2023-12-25 00:00:00 | C | D |  |  | 2023-12-04 00:00:00 | 17:20:42
2023-12-26 00:00:00 | A | C
2023-12-27 00:00:00 | A | C
2023-12-28 00:00:00 | B | A
2023-12-29 00:00:00 | B | A
2023-12-30 00:00:00 | D | B
2023-12-31 00:00:00 | D | B
Spreadsheet: 147930d1333039358-data-validation-and-vlookup-counts
Sheet: Dentist-62

Dentist: | 62
Job Title | Count |  | Employed Type | Count
 | 1 |  | Independent - Retail | 1
None | 1 |  | Chain - Retail | 0
bds | 2 |  | Hospital | 1
cda | 2 |  | Consultant | 0
CPhT | 1 |  | Institutional - Other | 0
D.D.S. | 1 |  | Retired | 0
D.M.D | 1 |  | Unemployed | 0
dds | 8
DDS,MSD | 1
Dental [NAME]. | 1
dmd | 7
Dmd,Rph | 1
dqw | 1
Dr. | 1
GVsJhBKsyXpRpPZJWb | 1
HM | 1
hqidpescpe | 1
inv & purchasing | 1
LVN | 1
MD | 2
Ms. | 1
nurse | 1
pharm | 1
Pharm tec | 1
pharmaD | 1
R.Ph | 2
R.PH. | 1
R.Ph. & DMD | 1
R>Ph., DDS | 1
RD | 1
RDA | 11
Receptionist | 1
RPh, MD, DDS, | 1
RPh. | 1
Toronto Dentist | 1
Spreadsheet: dana_davis__4466__Journal Entry Master
Sheet: Page 1

ENRON NORTH AMERICA  Journal Entry Form
Doc. Date |  |  |  |  |  |  | Doc type |  |  |  |  |  | Co. Code |  |  |  |  | Currency |  |  |  |  |  | Post Date |  |  |  |  |  |  | Document Number |  |  |  |  |  |  |  |  |  |  | Tranls Date |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reference
 |  |  |  |  |  |  | SA |  |  |  |  |  |  |  |  |  |  | USD
Posting Key |  |  |  |  |  |  |  | 2
New Co. Code |  |  |  |  |  |  |  | 4
Acct No. |  |  |  |  |  |  |  | 8
Amount |  |  |  |  |  |  |  | 18
Cost/Profit Ctr |  |  |  |  |  |  |  | 10
Trading Partnr |  |  |  |  |  |  |  | 3
Stat/ FAR order |  |  |  |  |  |  |  | 9/ 12
WBS Element |  |  |  |  |  |  |  | 18
Network |  |  |  |  |  |  |  | 7
Tax Code |  |  |  |  |  |  |  | 2
Jurisd Code |  |  |  |  |  |  |  | 10
Allocation |  |  |  |  |  |  |  | 18
Material No. |  |  |  |  |  |  |  | 7
Value Date |  |  |  |  |  |  |  | 7
Setlmnt Pd |  |  |  |  |  |  |  | 6
Commit Item |  |  |  |  |  |  |  | 10
Trans Type |  |  |  |  |  |  |  | 3
[NAME] |  |  |  |  |  |  |  | 3
Plant |  |  |  |  |  |  |  | 4
Quantity |  |  |  |  |  |  |  | 17
Base unit of Meas |  |  |  |  |  |  |  | 3
Ext GA amt in LC |  |  |  |  |  |  |  | 18
Text |  |  |  |  |  |  |  | 50
Entry Description
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prepared By: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Authorized By:
Spreadsheet: 875231d1721814764-linking-static-data-in-some-columns-with-refreshed-data-from-other-columns-dataquery
Sheet: Sheet1

Client ID | Client Name | Service Type | Cost | County | Planned Review | Name of Reviewer
1122 | Apple Skin | Air | 15 | Berkshire | 2024-08-12 00:00:00 | [NAME]
2233 | [NAME] | Water | 23 | Berkshire
3344 | Lemon Zest | Earth | 19 | Hampshire | 2024-08-16 00:00:00 | Ivor Lot
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Mike Yantachka

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
No response
Teachers' Retirement: Support in the State Budget
I'd like to explain my position
Explain your teachers' retirement position, if you choose.
I agree, although adjustments or modifications going forward should be on the table.
Health Care: Continuing System Reform
I'd like to explain my position
Explain your health care reform position, if you choose
I think that if and when GMC is implemented, Vermont teachers should be part of the same system
as everyone else. There should not be a separate carve-out for any group.
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
No response
Teaching Profession: Simplifying Professional Relicensing
I'd like to explain my position
Explain your relicensing position, if you choose
I don't know enough about this issue to say whether I agree or disagree.
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 393 Natures Way, Charlotte, VT 05445 | State Representative | Yes |  | Chittenden
Spreadsheet: 790758d1659978608-calculate-number-of-occurences-based-on-range-of-days-entered-example-attendance-tracker
Sheet: Attendance Tracker

 | Employee [NAME]
 |  |  |  | If the there is unplanned PTO that lasts for multiple days that should only be logged as unplanned for one day. Consequtive days should be logged as planned PTO as the entire event counts as one occurrence. |  | If a partial day is taken - type in the number of hours over the automatic calculation
 |  | Click in the field you want to insert date in and then click and the date on the calendar and it will enter the date in the selected field. |  |  |  |  |  |  | Always enter a note or comment for each occurrence
 | Employee Name | Start Date | End Date | Type of Leave | Days | Hours | Is this an occurrence? | # of Occurrences | Comments
 | Agent 1 | 2021-07-01 00:00:00 | 2021-07-01 00:00:00 | No Call/No Show |  |  | Yes
 | Agent 1 | 2021-07-06 00:00:00 | 2021-07-06 00:00:00 | No Call/No Show |  |  | Yes
 | Agent 1 | 2022-08-03 00:00:00 | 2022-08-03 00:00:00 | Unscheduled Absence |  |  | Yes
 | Agent 1 | 2022-06-01 00:00:00 | 2022-06-01 00:00:00 | Unscheduled Absence |  |  | Yes
 | Agent 1 | 2021-08-15 00:00:00 | 2021-08-15 00:00:00 | Unscheduled Absence |  |  | Yes
 | Agent 1 | 2021-08-04 00:00:00 | 2021-08-07 00:00:00 | Unscheduled Absence |  |  | Yes
 | Agent 1
Spreadsheet: 25a430d7-1319-4dd9-8798-68dd0428a999
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
C1011 | Test | C1011 | Carbamazepine-10,11-Epoxide, Serum | Carbamazepine-10,11-Epoxide, S | CAR/8654: Immunoassay  1011E/7467: High-Performance Liquid Chromatography (HPLC) | EDTA (lavender-top) tube: EDTA |  |  | 2 | mL | Container/Tube: Red top [NAME]: 2 mL Collection Instructions: Draw blood 12 hours (trough value) after last dose. | 1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Whole blood, plasma, or serum gel tube | CARBAMAZEPINE, TOTAL Therapeutic concentration: 4.0-12.0 mcg/mL Toxic concentration: > or =15.0 mcg/mL   CARBAMAZEPINE-10,11-EPOXIDE Therapeutic concentration: 0.4-4.0 mcg/mL Toxic concentration: > or =8.0 mcg/mL | Tuesday; 9:00 a.m. | Same day/1 day | 7 days |  | Profile |  |  |  |  | Rochester
C1011 | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
C1011 | Component | CAR | Carbamazepine, Total, Serum | Carbamazepine, Total, S | Immunoassay | Plain, Red-Top Tube: Red |  |  | 1 | mL | Container/Tube: Red top [NAME]: 1 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Plasma or serum gel tube | Therapeutic concentration: 4.0-12.0 mcg/mL Toxic concentration: > or =15.0 mcg/mL | Monday through Sunday; Varies | Same day/1 day | 1 day | 1 | 80156 |  |  | Yes | Yes
CAR | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
CAR | Result | 8654 | Carbamazepine, Total, S | Carbamazepine, Total, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 3432-2
C1011 | Component | 1011E | Carb-10,11-Epoxide, Serum | Carb-10,11-Epoxide, S | High-Performance Liquid Chromatography (HPLC) Includes carbamazepine. | Plain, Red-Top Tube: Red |  |  | 1 | mL |  | 0.4 mL | Specimens Other Than:	Serum	 Anticoagulants Other Than:	 Hemolysis:			 Thawing:			 Lipemia: | Therapeutic concentration: 0.4-4.0 mcg/mL Toxic concentration: > or =8.0 mcg/mL | Varies (Once a week as needed) | Same day/1 day | 4 days | 1 | 80299 |  |  | Yes | No
1011E | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
1011E | Result | 7467 | Carb-10,11-Epoxide, S | Carb-10,11-Epoxide, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 9415-1
Spreadsheet: 89ce13cf-f831-40a6-8839-05a43bad2ebf
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43495864 | 2014-10-08 21:13:36 | AXIS | 0 | 3 | 6 | 707319 | GR50 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
43496194 | 2014-10-08 21:31:19 | ALLIES | 0 | 5 | 6 | 707319 | GR50 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
43555989 | 2014-10-12 23:14:36 | AXIS | 1 | 5 | 2 | 583921 | [NAME] | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
43556188 | 2014-10-12 23:27:51 | ALLIES | 0 | 2 | 5 | 583921 | [NAME] | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
43583552 | 2014-10-14 22:31:33 | AXIS | 0 | 4 | 6 | 1611169 | Baron Von Funck | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
43583784 | 2014-10-14 22:42:20 | ALLIES | 1 | 6 | 2 | 1611169 | Baron Von Funck | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
43583980 | 2014-10-14 23:12:10 | AXIS | 1 | 10 | 5 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43584368 | 2014-10-14 23:48:54 | ALLIES | 1 | 10 | 7 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43584836 | 2014-10-15 00:13:51 | AXIS | 1 | 7 | 6 | 867821 | b.kuntscher | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43585111 | 2014-10-15 00:32:33 | ALLIES | 0 | 5 | 7 | 867821 | b.kuntscher | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43606074 | 2014-10-16 16:56:47 | AXIS | 1 | 7 | 5 | 1611589 | *player1611589 | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
43606268 | 2014-10-16 17:10:53 | ALLIES | 0 | 2 | 7 | 1611589 | *player1611589 | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
43631212 | 2014-10-18 12:51:12 | AXIS | 1 | 7 | 5 | 1310826 | chicodk | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
43631379 | 2014-10-18 13:12:11 | ALLIES | 1 | 7 | 3 | 1310826 | chicodk | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
43654274 | 2014-10-19 23:45:39 | ALLIES | 0 | 5 | 6 | 1515794 | Bodega28 | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
43654591 | 2014-10-20 00:07:46 | AXIS | 1 | 6 | 5 | 1515794 | Bodega28 | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
Spreadsheet: 682789d1592331668-highlight-smallest-difference-of-a-consecutive-pair-of-numbers-in-a-range-minimun-difference
Sheet: Sheet1

0.1227545069845704
8.94502213738555
22.80347982575991
66.6533254294853
68.96976211936986
70.52572777080182
84.37606198073135
88.39586675310304
93.55966906796951
94.1223923671567
112.5996316143708
115.8771248970523
166.7851754358077
169.4634339870888
193.4348801480905
195.4168466054646
213.087971439191
241.0933890117992
246.9970527548797
254.8204604820954
278.9859527373936
282.6242495510353
291.2751877437226
294.4137413569792
304.5279094772302
316.1988076434153
323.4948491560982
330.1562059984702
385.201634803399
387.8256758037321
403.6313383838404
431.6837986464759
437.5732984039667
466.892329298625
485.6135021184253
497.0404645265711
497.6982844044395
507.3970145685097
509.2393087882329
518.7270417530648
527.4949942823305
532.2375215324616
543.0585154636732
544.3919339452618
566.9124959892624
595.474991413991
596.5156033157552
603.0396258937883
614.531419356277
682.2651624910549
691.3821321224723
701.0838993686456
705.4154963022621
707.1339042304985
711.1736161834882
733.0676435987892
737.8698708527075
752.0464475520798
777.6424308040519
782.1949629969988
783.0286829029665
786.9944525049557
790.725666933646
790.7598981382118
819.7570500140216
821.3710530511263
821.9419656367115
840.1149037554552
873.5105343629568
875.5769789849695
904.676465758091
946.8443440693943
964.1763466211955
994.6309378108356
996.1861762002297
1068.518633711299
1099.118067980017
1115.577938955008
1158.727570401337
1180.619314703214
1219.876782472587
1257.60436625894
1298.275113365813
1362.847654898515
1364.136320409383
1366.529162021319
1402.347865724473
1413.431549955037
1427.505448537819
1432.958120039073
1472.626751043547
1500.518580249759
1619.030350468685
1623.233377131907
1636.979684949837
1643.42188496615
1834.830738306529
1872.765447437682
2163.159364942384
2307.266558691925
Spreadsheet: 746107d1630509437-adding-up-data-in-different-sheets-sample-16-
Sheet: results

 | DROP DOWN MENU
 | Ealing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01/01/20222
 | . |  | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | YTD
 | ACTON | Total Number of claimants
 |  | 25+ Claimants
 |  | Ratio: Total Number of claimants to 25+ Claimants
 | EALING | Total Number of claimants
 |  | 25+ Claimants
 |  | Ratio: Total Number of claimants to 25+ Claimants
Spreadsheet: 542251d1507767922-counta-countblank-percentage-example
Sheet: Sheet1

[NAME] | 1st QTR | S/T 1 | 2nd QTR | S/T 2 | 3rd QTR | S/T 3 | 4th QTR | S/T 4
YARDTB | AUGUST | 1 | NOVEMBER | 1 | FEBRUARY |  | MAY
YARDD3 | AUGUST | 1 | NOVEMBER | 1 | FEBRUARY |  | MAY |  |  | 1st QTR
[NAME] | AUGUST | 1 | NOVEMBER | 1 | FEBRUARY |  | MAY |  |  | 2nd QTR |  |  | Year completed
YARDD1 | AUGUST | 1 | NOVEMBER |  | FEBRUARY |  | MAY |  |  | 3rd QTR
YARDC2 | AUGUST | 1 | NOVEMBER |  | FEBRUARY |  | MAY |  |  | 4th QTR
Spreadsheet: 57938d1258147690-vlookup-with-multiple-criteria-and-ranking-applestest-3-
Sheet: Data

Field1 | Field2 | Field3 |  | lookup >> | Apple
Apple | 15 | 200
[NAME] | 20 | 125 |  |  | 200 , 15
[NAME] | 25 | 200
Apple |  | 210
[NAME] | 15 | 250
Apple |  | 100
Spreadsheet: 721226d1614595373-how-to-track-current-week-status-change-status_tracking
Sheet: Sheet1

 | Incident | Created on | Status | Last Change Status | Week Number of Last Change |  | Current Week Number
 | 2234 | 2021-02-01 00:00:00 | Created | 2021-02-13 00:00:00
 | 2256 | 2021-02-01 00:00:00 | Approved | 2021-02-13 00:00:00
 | 2122 | 2021-02-02 00:00:00 | In Progress | 2021-02-15 00:00:00
 | 2345 | 2021-02-03 00:00:00 | In Progress | 2021-02-20 00:00:00
 | 2237 | 2021-02-03 00:00:00 | Pending | 2021-02-12 00:00:00
 | 2261 | 2021-02-04 00:00:00 | Closed | 2021-02-25 00:00:00
 | 2252 | 2021-02-04 00:00:00 | Approved | 2021-02-12 00:00:00