tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 92586d1292152357-need-if-then-formula-that-changes-with-time-ifthen
Sheet: Sheet2

Date | Time | [NAME]
2010.01.04 | 1900-01-01 00:00:00 | 1.4427
2010.01.04 | 01:00:00 | 1.4427
2010.01.04 | 02:00:00 | 1.4427
2010.01.04 | 03:00:00 | 1.4427
2010.01.04 | 04:00:00 | 1.4427
2010.01.04 | 05:00:00 | 1.4427
2010.01.04 | 06:00:00 | 1.4427
2010.01.04 | 07:00:00 | 1.4427
2010.01.04 | 08:00:00 | 1.4427
2010.01.04 | 09:00:00 | 1.4427
2010.01.04 | 10:00:00 | 1.4427
2010.01.04 | 11:00:00 | 1.4427
2010.01.04 | 12:00:00 | 1.4427
2010.01.04 | 13:00:00 | 1.4427
2010.01.04 | 14:00:00 | 1.4427
2010.01.04 | 15:00:00 | 1.4427
2010.01.04 | 16:00:00 | 1.4427
2010.01.04 | 17:00:00 | 1.4427
2010.01.04 | 18:00:00 | 1.4427
2010.01.04 | 19:00:00 | 1.4427
2010.01.04 | 20:00:00 | 1.4427
2010.01.04 | 21:00:00 | 1.4427
2010.01.04 | 22:00:00 | 1.4427
2010.01.04 | 23:00:00 | 1.4427
2010.01.05 | 1900-01-01 00:00:00 | 1.4357
2010.01.05 | 01:00:00
2010.01.05 | 02:00:00
2010.01.05 | 03:00:00
2010.01.05 | 04:00:00
2010.01.05 | 05:00:00
2010.01.05 | 06:00:00
2010.01.05 | 07:00:00
2010.01.05 | 08:00:00
2010.01.05 | 09:00:00
2010.01.05 | 10:00:00
2010.01.05 | 11:00:00
2010.01.05 | 12:00:00
2010.01.05 | 13:00:00
2010.01.05 | 14:00:00
2010.01.05 | 15:00:00
2010.01.05 | 16:00:00
2010.01.05 | 17:00:00
2010.01.05 | 18:00:00
2010.01.05 | 19:00:00
2010.01.05 | 20:00:00
2010.01.05 | 21:00:00
2010.01.05 | 22:00:00
2010.01.05 | 23:00:00
2010.01.06 | 1900-01-01 00:00:00
2010.01.06 | 01:00:00
2010.01.06 | 02:00:00
2010.01.06 | 03:00:00
2010.01.06 | 04:00:00
2010.01.06 | 05:00:00
2010.01.06 | 06:00:00
2010.01.06 | 07:00:00
2010.01.06 | 08:00:00
2010.01.06 | 09:00:00
2010.01.06 | 10:00:00
2010.01.06 | 11:00:00
2010.01.06 | 12:00:00
2010.01.06 | 13:00:00
2010.01.06 | 14:00:00
2010.01.06 | 15:00:00
2010.01.06 | 16:00:00
2010.01.06 | 17:00:00
2010.01.06 | 18:00:00
2010.01.06 | 19:00:00
2010.01.06 | 20:00:00
2010.01.06 | 21:00:00
2010.01.06 | 22:00:00
2010.01.06 | 23:00:00
2010.01.07 | 1900-01-01 00:00:00
2010.01.07 | 01:00:00
2010.01.07 | 02:00:00
2010.01.07 | 03:00:00
2010.01.07 | 04:00:00
2010.01.07 | 05:00:00
2010.01.07 | 06:00:00
2010.01.07 | 07:00:00
2010.01.07 | 08:00:00
2010.01.07 | 09:00:00
2010.01.07 | 10:00:00
2010.01.07 | 11:00:00
2010.01.07 | 12:00:00
2010.01.07 | 13:00:00
2010.01.07 | 14:00:00
2010.01.07 | 15:00:00
2010.01.07 | 16:00:00
2010.01.07 | 17:00:00
2010.01.07 | 18:00:00
2010.01.07 | 19:00:00
2010.01.07 | 20:00:00
2010.01.07 | 21:00:00
2010.01.07 | 22:00:00
2010.01.07 | 23:00:00
2010.01.08 | 1900-01-01 00:00:00
Spreadsheet: 687054d1594928941-heavy-file-for-calculation-and-save-dates
Sheet: M Test

Sr.
 | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date
 | 01-01) 22-01-2018 | pdf |  | 02-01) 19-02-2019 | pdf |  | 01-01) 22-01-2018 | pdf |  | 03-01) 18-03-2019 | pdf
 | 11-01) 26-11-2018 | pdf |  | 05-01) 17-05-2019 | pdf |  | 03-01) 08-03-2018 | pdf |  | 05-01) 17-05-2019 | pdf
 | 01-01) 24-01-2019 | pdf |  | 08-01) 04-08-2019 | pdf |  | 05-01) 21-05-2018 | pdf |  | 08-01) 04-08-2019 | pdf
 | 03-01) 18-03-2019 | pdf |  | 11-01) 14-11-2019 | pdf |  | 07-01) 18-07-2018 | pdf |  | 11-01) 14-11-2019 | pdf
 | 05-01) 17-05-2019 | pdf |  | 02-01) 11-02-2020 | pdf |  | 01-01) 24-01-2019 | pdf |  | 04-01) 28-04-2020 | pdf
 | 06-01) 24-06-2019 | pdf |  | 05-01) 17-05-2020 | pdf |  | 05-01) 17-05-2019 | pdf
 | 08-01) 04-08-2019 | pdf |  |  |  |  | 09-01) 17-09-2019 | pdf
 | 09-01) 17-09-2019 | pdf |  |  |  |  | 11-01) 14-11-2019 | pdf
 | 11-01) 14-11-2019 | pdf
 | 12-01) 16-12-2019 | pdf
 | 01-01) 21-01-2020 | pdf
 | 02-01) 18-02-2020 | pdf
 | 04-01) 29-04-2020 | pdf
 | 05-01) 18-05-2020 | pdf
Spreadsheet: 537300d1504936302-combining-2-rows-into-1-final-invoice-1-
Sheet: page 16

Description of Goods |  |  |  |  | Quantity | Cost | Total
Item # | Color | UPC Code | Country Origin | HS Code
Chenille Stems: 6mmx30cm 40/pk Pipe Cleaners |  |  |  |  | 24 | 0.62 | 14.88
GC024U | U) Glamour Mix | 775749191479 | CHINA | 9603.90.9019
Chenille Stems: 6mmx30cm 40/pk Pipe Cleaners |  |  |  |  | 24 | 0.62 | 14.88
GC024V | V) Light Grey | 775749201581 | CHINA | 9603.90.9019
Tinsel Chenille Stems: 6mmx30cm 35/pk Glitter Pipe Cleaners |  |  |  |  | 24 | 0.62 | 14.88
GC025A | A) Black | 775749049206 | CHINA | 9603.90.9019
Tinsel Chenille Stems: 6mmx30cm 35/pk Glitter Pipe Cleaners |  |  |  |  | 24 | 0.62 | 14.88
GC025C | C) Multi Mix | 775749049213 | CHINA | 9603.90.9019
Tinsel Chenille Stems: 6mmx30cm 35/pk Glitter Pipe Cleaners |  |  |  |  | 24 | 0.62 | 14.88
GC025D | D) Silver | 775749049183 | CHINA | 9603.90.9019
Tinsel Chenille Stems: 6mmx30cm 35/pk Glitter Pipe Cleaners |  |  |  |  | 24 | 0.62 | 14.88
[NAME] | K) Champagne Gold | 775749191431 | CHINA | 9603.90.9019
Tinsel Chenille Stems: 6mmx30cm 35/pk Glitter Pipe Cleaners |  |  |  |  | 24 | 0.62 | 14.88
GC025L | L) Glamour Mix | 775749191448 | CHINA | 9603.90.9019
Biggie Chenille Stems: 12"x1/2" Multi Pack x24 |  |  |  |  | 24 | 0.65 | 15.6
GC026B | B) Brights Mix | 775749190762 | CHINA | 9603.90.9019
[NAME]: 9"x12" Glitter Bar-Coded Sheets |  |  |  |  | 50 | 0.34 | 17
GC038B | B) Royal Blue | 775749105353 | CHINA | 5602.90.9000
[NAME]: 9"x12" Glitter Bar-Coded Sheets |  |  |  |  | 50 | 0.34 | 17
GC038C | C) Purple | 775749105360 | CHINA | 5602.90.9000
[NAME]: 9"x12" Glitter Bar-Coded Sheets |  |  |  |  | 50 | 0.34 | 17
GC038D | D) [NAME] | 775749105377 | CHINA | 5602.90.9000
[NAME]: 9"x12" Glitter Bar-Coded Sheets |  |  |  |  | 50 | 0.34 | 17
GC038F | F) Emerald Green | 775749105391 | CHINA | 5602.90.9000
[NAME]: 9"x12" Glitter Bar-Coded Sheets |  |  |  |  | 50 | 0.34 | 17
[NAME] | G) Really Red | 775749105407 | CHINA | 5602.90.9000
[NAME]: 9"x12" Glitter Bar-Coded Sheets |  |  |  |  | 50 | 0.34 | 17
GC038H | H) Ice Blue | 775749196856 | CHINA | 5602.90.9000
[NAME]: 9"x12" Glitter Bar-Coded Sheets |  |  |  |  | 50 | 0.34 | 17
GC038I | I) Black | 775749196863 | CHINA | 5602.90.9000
Fun Foam Sheets: 9"x12" Textured Bulk 2mm Barcoded Sheets |  |  |  |  | 50 | 0.2 | 10
GC054A | A) Black | 775749198003 | CHINA | 3921.90.0090
Fun Foam Sheets: 9"x12" Textured Bulk 2mm Barcoded Sheets |  |  |  |  | 50 | 0.2 | 10
GC054B | B) Apple Green | 775749197969 | CHINA | 3921.90.0090
Fun Foam Sheets: 9"x12" Textured Bulk 2mm Barcoded Sheets |  |  |  |  | 50 | 0.2 | 10
GC054C | C) Purple | 775749197976 | CHINA | 3921.90.0090
Fun Foam Sheets: 9"x12" Textured Bulk 2mm Barcoded Sheets |  |  |  |  | 50 | 0.2 | 10
GC054D | D) Red | 775749197952 | CHINA | 3921.90.0090
Fun Foam Sheets: 9"x12" Textured Bulk 2mm Barcoded Sheets |  |  |  |  | 50 | 0.2 | 10
GC054E | E) Ocean Blue | 775749197983 | CHINA | 3921.90.0090
Fun Foam Sheets: 9"x12" Textured Bulk 2mm Barcoded Sheets |  |  |  |  | 50 | 0.2 | 10
GC054F | F) White | 775749197990 | CHINA | 3921.90.0090
Spreadsheet: 91857b9a-43c2-4ebf-ada5-cbdd5e5c609f
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
FFTPG | Test | FFTPG | Treponema pallidum Antibody (FTA-ABS), Serum, IgG by IFA with [NAME] to Treponema pallidum Antibody by TP-PA | T. pallidum [NAME] (FTA-ABS), IgG | Semi-Quantitative Indirect Fluorescent Antibody   Semi-Quantitative Particle Agglutination, if appropriate |  |  |  | 1 | mL | Draw blood in a plain red-top tube(s), serum gel tube is acceptable. Spin down, and send 1 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	Mild OK; Gross reject Thawing:		Warm reject; Cold OK Lipemia:	Mild OK; Gross reject Icterus:	NA Other:	NA | [NAME], [NAME] (FTA-ABS):  Non Reactive Treponema pallidum [NAME] by TP-PA:  Non Reactive   Test Performed By:  ARUP Laboratories 		      500 Chipeta Way 		      Salt Lake City, UT 84108 | Sunday through Saturday | 1 - 4 days | 3 - 8 days | 1 | 86780 |  |  |  |  | ARUP Laboratories
FFTPG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FFTPG | Result | Z2653 | [NAME], [NAME] (FTA-ABS) | [NAME], [NAME] (FTA-ABS) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17726-1
FFTPG | [NAME] | FFTP | Treponema pallidum [NAME] by TP-PA | Treponema pallidum [NAME] by TP-PA | Only orderable as a reflex to FFTPG (57315) "T. pallidum [NAME] (FTA-ABS), IgG" |  |  |  | 1 | mL | Only orderable as a reflex to FFTPG (57315) "T. pallidum [NAME] (FTA-ABS), IgG" |  |  | Non Reactive  Test Performed By:  ARUP Laboratories 		      500 Chipeta Way 		      Salt Lake City, UT 84108 |  |  |  | 1 | 86780 |  |  | No | No
FFTP | [NAME] | SST | Serum SST |  |  |  | Refrigerated | 14 days
FFTP | Result | Z2654 | Treponema pallidum [NAME] by TP-PA | Treponema pallidum [NAME] by TP-PA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 714397d1611212907-formula-to-calculate-available-stock-items-stock-control
Sheet: PURCHASING FORM

 |  | PURCHASING FORM
ITEM NO | ITEM NAME | MAKE | [NAME] | AVAILABLE | DATE | TIME | VENDOR | QUANTITY ORDERED | ORDERED QUANITY RETURNED | AVAILABLE
1 |  |  |  | 3 | 2021-01-19 00:00:00 | 11:41:00 | FILTER INC | 3 | 0 | 6
Spreadsheet: 735477d1623015232-if-and-or-function-true-is-equation-with-neg-result-false-is-equation-with-pos-result-draft-certificate
Sheet: Worksheet

 |  | Light Freeboards: |  |  |  | Heavy Freeboards:
Length |  | Port Bow: |  | Starboard Bow: |  | Port Bow: |  | Starboard Bow:
[NAME] |  | [NAME]: |  | Starboard Mid: |  | [NAME]: |  | Starboard Mid:
Hull |  | [NAME]: |  | [NAME]: |  | [NAME]: |  | [NAME]:
Sound Side | Port | Port WLL: | 165 | Starboard WLL: | 185 | Port WLL: |  | Starboard WLL:
[NAME] |  | [NAME]: |  |  |  | AWLH:
[NAME] (L) |  |  |  | MWL:
Log to Shear |  | List: |  | Trim: | 2 | List: |  | Trim:
Log to Hole Edge |  | Direction: |  | Direction: | Bow | Direction: |  | Direction:
Side to [NAME]
B/H to [NAME] |  |  | Light Tank Soundings:
Deck to Rake |  |  | Observed | Tank Length | [NAME] (d) | Trim Correction | Sound Corr. | Wedge | Contents | Deduction
Stern to Marks |  | Bow:
Shear to Marks |  | No 1:
[NAME] |  | No 2: |  |  | 15
[NAME] |  | No 3:
Bow Length (Box) |  | No 4:
No 1 Length |  | No 5:
No 2 Length |  | No 6:
No 3 Length |  | No 7:
No 4 Length |  | No 8:
No 5 Length |  | No 9:
No 6 Length |  | No 10:
No 7 Length
No 8 Length |  |  | Heavy Tank Soundings:
No 9 Length |  |  | Observed | Tank Length | [NAME] (d) | Trim Corrected | Sound Corr. | Wedge | Contents | Deduction
No 10 Length |  | Bow:
Stern Length |  | No 1:
[NAME] (H) |  | No 2:
 |  | No 3:
 |  | No 4:
 |  | No 5:
 |  | No 6:
 |  | No 7:
 |  | No 8:
 |  | No 9:
 |  | No 10:
 |  | FAM: |  |  |  | FAM:
 |  | MSM: |  |  |  | MSM:
 |  | MOM: |  |  |  | MOM:
 |  | QTR: |  |  |  | QTR:
 |  |  |  | Displace:
 |  |  |  | Density:
 |  |  |  | Cargo Poundage:
 |  |  |  | Deductions:
 |  |  |  | Short Tons
 |  |  |  | Tonnes:
Spreadsheet: 135965d1326336745-dependent-drop-down-list-for-whole-column-with-illegal-characters-samplelist
Sheet: Sheet1

Basic Information |  |  |  |  |  |  |  |  | Availability and Price |  |  |  | UPC/ISBN |  | Clothing Sizes |  |  |  | Tax and Shipping |  |  |  | Payment Methods |  |  |  | Dropdown Values
Item ID | Title | Subtitle | Description | Listing Type | [NAME] | Category | Subcategory | Condition | Starting Bid | Buy Now Price | Quantity | Availabiltiy | UPC | ISBN | Size | Gender | Color | Material | Shipping Fee | Free Shipping | Handling Fee | Sales Tax | PayPal | Money Order | Check |  | Boolean | Gender | Size | Listing Types | Availability | Condition
Number | Text | Text | Text | Dropdown | URL | Dropdown | Dropdown | Dropdown | Currency | Currency | Number | Dropdown | Number | Number | Dropdown | Dropdown | Text | Text | Currency | Dropdown | Currency | Currency | Dropdown | Dropdown | Dropdown |  | yes | Male | S | Auciton Only | In Stock | New
 |  |  |  |  |  | Art & Antiques |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no | Female | M | Buy It Now Auctions | Available for Order | Used
 |  |  |  |  |  | Books |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unisex | L | Buy It Now Only | Out of Stock | Hand - Made
 |  |  |  |  |  | Clothing & Accessories |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XL |  | Preorder
 |  |  |  |  |  | Collectibles |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XXL
 |  |  |  |  |  | Comics, Cards & Science Fiction
 |  |  |  |  |  | Computers & Software
 |  |  |  |  |  | Electronics & Photography
 |  |  |  |  |  | Home & Garden
 |  |  |  |  |  | Movies & Video
 |  |  |  |  |  | Music
 |  |  |  |  |  | Office & Business
 |  |  |  |  |  | Other Goods & Services
 |  |  |  |  |  | Sports & Recreation
 |  |  |  |  |  | Toys & Games
Spreadsheet: 673973d1587615464-how-to-tag-text-how-do-i-tag-each-text-with-a-label
Sheet: Sample data

 | Accounting | Aerospace | Annual Report | Audit | Automotive | Brexit | British Athletics | Budget | Career | CEO Survey | Climate | Consumer | Coronavirus
Text 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
Text 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
Text 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
Text 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
Text 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
Text 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
Text 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Text 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
Text 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Text 10 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Text 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Text 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Text 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Text 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Text 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 42381d1240950534-countif-values-meets-date-criteria-countif
Sheet: Sheet1

RegNum | EvalDate | Appt1 | Appt2 | Appt3 | Appt4 |  | ApptWithin90days | ApptWithin180days | ApptWithin270days | ApptWithin365days
1 | 2006-11-02 00:00:00 | 2007-02-27 00:00:00 | 2007-06-28 00:00:00 | 2007-09-30 00:00:00 | 2008-10-04 00:00:00 |  | Here would appear the number of appointments from Row 2 that occurred within 90 days after11/2/2006
2 | 2006-11-29 00:00:00 | 2006-12-13 00:00:00 | 2007-01-09 00:00:00 | 2008-06-15 00:00:00 |  |  |  | Here would appear the number of appointments from Row 3 that occurred between 91-120 days after 11/29/2006
3 | 2006-06-05 00:00:00 | 2007-07-31 00:00:00 | 2007-10-11 00:00:00 | 2008-04-18 00:00:00
4 | 2005-08-01 00:00:00 | 2005-10-24 00:00:00 | 2006-01-23 00:00:00 | 2006-02-24 00:00:00 | 2007-04-07 00:00:00
Spreadsheet: 214950d1361206674-rank-a-list-of-numbers-that-are-not-continuous-rankingitems
Sheet: ranking

 |  | West Towne Menu Comparison.
 |  |  | 6" | Rank | 9" | Rank | 12" | Rank | total | Rank | % |  | rank
 | Grand Escape |  | 70538.64 |  | 91937.34 |  | 47125.26
 | [NAME] |  | 3612.76 |  | 5815.04 |  | 2129.4
 | French Onion |  | 4680.62 |  | 5808.55 |  | 1498.77
[NAME] | Mignion |  | 2227.09 |  | 4187.01 |  | 1477.48
 | Triple |  | 3417.34 |  | 6941.07 |  | 3161.12
 | chipttle |  | 4131.72 |  | 9124.94 |  | 3185.91
 | Ste tbc |  | 5.29 |  | 1949.9 |  | 934.8
 | Mexican |  | 10.58
 | Teriyaki |  | 5.29 |  | 6.99
Total |  | Steak%
 | grand chix |  | 10044.87 |  | 8034.62 |  | 2137.59
Chicken | cajun chix |  | 4466.05 |  | 6178.48 |  | 2063.88
 | buffalo chix |  | 3013.96 |  | 4848.03 |  | 1081.08
 | chix Parm |  | 84.64 |  | 118.83
Total |  | Chicken%
 | Turkey club |  | 6491.99 |  | 6639.27 |  | 1474.2
Turkey/ham | Grand Gobblers |  | 4625.73 |  | 3115.2 |  | 990.99
 | Hambrosia |  | 2230.53 |  | 1901.57 |  | 556.92
 | hot italian |  | 244.51 |  | 188.21 |  | 49.14
 | TBC
 | grand ham |  | 693.61 |  | 664.05 |  | 155.61
Total |  | Turkey/ham
[NAME] | [NAME] |  | 783.43 |  | 629.53 |  | 286.55
Total | [NAME]
Burgers | Burgers |  | 13159.9
Total | Burgers
Total
Spreadsheet: 79677d1279885648-trig-formula-unexpected-results-platform-and-track-gauge-template
Sheet: Sheet1

Platform Gauge work sheet
Project
 | Raw XY Co-ordinate data
 | Point Nos |  |  |  |  |  |  |  |  |  |  |  |  | horiz | vert |  |  |  | Radians
 | 1.Coper top |  | 2. coper bottom |  | 3. Rail |  | 4. Rail |  |  | Section (m) | Chainage | Coper depth | coper O/Hang | Xh | [NAME] | [NAME] | Gauge | Cant | rail super elevation (angle) | X (plane of rail) | Y (plane of rail)
Section (m) | x | y | x | y | x | y | x | y
0 | 0 | 0 | 0 | -0.1 | 0.73 | -0.915 | 2.1617 | -0.8152 |  | 0 |  | 0.1 |  | 0.73 | -0.915 | 1.4317 | 1.435174181066535 | 0.0998 | 0.06959476366600059 | 0.7918606779530083 | -0.8620218481638399
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | should be 0.667 | should be 0.963
10
15
20
Spreadsheet: 100817d1299057584-count-unique-items-within-a-choice-copy-of-example1
Sheet: Sheet1

Number | Company | Helper1 | Helper2 |  | company | count
46 | A | A46 | 1 |  | A | 29 |  | Count of Number
47 | A | A47 | 1 |  | B | 4 |  | Company | Total
48 | B | B48 | 1 |  | C | 2 |  | A | 29
61 | A | A61 | 1 |  |  |  |  | B | 4
1 | A | A1 |  |  |  |  |  | C | 2
1 | A | A1 |  |  |  |  |  | Grand Total | 35
1 | A | A1 | 1
65 | A | A65 | 1
66 | A | A66 | 1 |  | Sumif() with helper columns
67 | A | A67 | 1
68 | A | A68 | 1 |  | A | 27
69 | A | A69 | 1 |  | B | 4
83 | B | B83 | 1 |  | C | 2
84 | A | A84 | 1
85 | A | A85 | 1
86 | A | A86 | 1
103 | B | B103 | 1
104 | A | A104 | 1
105 | A | A105 | 1
107 | A | A107 | 1
108 | A | A108 | 1
109 | A | A109 | 1
110 | A | A110 | 1
118 | C | C118 | 1
122 | A | A122 | 1
129 | A | A129 | 1
156 | B | B156 | 1
157 | A | A157 | 1
158 | A | A158 | 1
159 | A | A159 | 1
168 | A | A168 | 1
169 | A | A169 | 1
170 | A | A170 | 1
172 | A | A172 | 1
175 | C | C175 | 1
Spreadsheet: 340faca5-c188-43e5-907a-9ee8fd35bcda
Sheet: Sheet1

Eidg Schiesskreis 19 | Unnamed: 1 | Unnamed: 2 | [NAME] | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Verteidigung - HEER | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | SAT
 |  |  |  |  |  |  |  |  | Schiesswesen ausser [NAME]
Schützenmeisterkurs Gewehr 300m
Fr/ Sa 01./02.04.2010 im [NAME], [NAME]
Kdt: Oberstlt [NAME], [NAME] 5 SG
Oberer Langacker 5, Azmoos
[NAME]. P: 081 783 26 19, E-Mail: <[EMAIL]>
[NAME] an: Four Albin Uehli, M KSK 5 SG
[NAME], 7312 Pfäfers  SG
[NAME]. P: 081 302 20 41, E-Mail: <[EMAIL]>
Adress.-Nr | Vereins-Nr. SSV | Vereinsname | Nachname | Vorname | Strasse | PLZ | Ort | GebDat | AHV-Nr | [NAME] | Titel | Kursdatum | [NAME].Nr. | E-Mail
 |  |  |  |  |  |  |  |  |  |  |  | 01./02.04.2011
Spreadsheet: 858373d1707091158-how-to-remove-blank-rows-when-formula-spills-unique-count-dj
Sheet: Sheet1

Name |  |  |  |  |  |  | Name | Yes | No |  |  |  |  |  |  |  | [NAME]
[NAME] | yes |  |  |  |  |  |  | 2 | 0 |  |  |  |  |  |  |  | [NAME]
[NAME] | yes |  |  |  |  |  | [NAME] | 0 | 2 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Julian | 2 | 0 |  |  |  |  |  |  |  | [NAME]
[NAME] |  | no |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Julian
Julian | yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  | no |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Julian | yes
Spreadsheet: errol_mclaughlin_jr__10115__PMA Log Gas Two Rm 0101
Sheet: Sheet1

As of January 2001
Resp | Bookcode | Month | Code | Type | Description | Risk
[NAME] | FPL Hedge (G&) | 2000 | RM | E | One Liquidation came through for Aug NT4811; Not in DPR | -159803
[NAME] | FPL Hedge (G&) | 2000 | RM | E | Access Differences | 1099.77
[NAME] | FPL Hedge (G&) | 2000 | RM | E | MTM Variance | 117313
[NAME] | NG Canadian (W*) | 2000 | RM | E | Value of deals changed per Canada. NH6815.3, [NAME], NH6815.5, Q19197.6, Q19198.6 | 5040.96
 |  |  |  |  |  | .
[NAME] | FT Canada - P7 | Jan | RM | E | Rounding | 1098
[NAME] | FT Enron Online (AA) | Jan | RM | O | Rounding | -149
[NAME] | FT Enron Online (AA) | 2000 | RM | O | Gas Daily Variances | 2095
[NAME] | JS-Executive Spec  (GY) | 2000 | RM | E | DPR adj taken twice | -1564
[NAME] | JS-Executive Spec  (GY) | 2000 | RM | E | DPR adj taken twice | 112148
[NAME] | NG Gas Hedge (QN, W( ) | Jan | RM | E | Rounding | 1909
[NAME] | NG Gas Hedge (QN, W( ) | Jan | RM | E | Gas Daily Roll Error, Should not have been a liquidation value for Jan 01. | -1888674.51
[NAME] | NG PRICE ( PG ) | 2000 | RM | E | NQ6582.1 not in DPR, August 2000 deal. | -2370000
[NAME] | NG PRICE ( PG ) | Jan | RM | E | Broker Fees | -222872
[NAME] | NG PRICE ( PG ) | Jan | RM | E | [NAME] not in [NAME]) | 1177500.1
[NAME] | NG PRICE ( PG ) | Jan | RM | E | Rounding | -365
[NAME] | Options (GN) | 2000 | RM | E | Post ID 994810 Variance from DPR, Remaining balance. | -1171796
[NAME] | Options (GN) | Jan | RM | E | Rounding | 81.29
[NAME] | Options (GN) | Jan | RM | E | Broker Fees 0101 | -15388
Spreadsheet: 85419d1285519849-how-do-you-take-cell-data-from-18-different-worksheets-and-combine-them-in-another-sample-homework-list
Sheet: Teacher C

Teacher Name | Class | Period | Due Date | Student First Name | Student Last Name | Assignment
Teacher C | Math 12 | 3 | 2010-09-14 00:00:00 | [NAME] | [NAME] | Chapter 3
Teacher C | Math 12 | 3 | 2010-09-14 00:00:00 | [NAME] | [NAME] | Chapter 3
Teacher C | Math 12 | 3 | 2010-09-14 00:00:00 | Billy | [NAME] | Chapter 3
Teacher C | Math 12 | 3 | 2010-09-14 00:00:00 | Apache | [NAME] | Chapter 3
Teacher C | Math 12 | 3 | 2010-09-14 00:00:00 | Burt | [NAME] | Chapter 3
Teacher C | Math 12 | 3 | 2010-09-14 00:00:00 | [NAME] | Accardo | Chapter 3
Teacher C | Math 12 | 3 | 2010-09-14 00:00:00 | Hugh | [NAME] | Chapter 3
Spreadsheet: 939d7201-c71b-4bf4-8d67-290cff1673c4
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
3158 | 12776 | [NAME] | [NAME] | MEX | 0 | 00:08:49 | 00:00:22 | 00:15:00 | 00:00:29 | 00:08:53 | 1 | [NAME]
3158 | 17361 | Marina | Saucedo | MEX | 0 | 00:09:05 | 00:00:22 | 00:14:49 | 00:00:28 | 00:10:59 | 2 | 00:35:43
3158 | 17362 | Amalia Isabel | Sánchez | MEX | 0 | 00:09:58 | 00:00:22 | 00:15:29 | 00:00:27 | 00:11:37 | 3 | 00:37:53
3158 | 17235 | Judge | Jones | USA | 0 | 00:09:43 | 00:00:37 | 00:17:04 | 00:00:46 | 00:10:28 | 4 | 00:38:38
3158 | 17360 | [NAME] | Flores | MEX | 0 | 00:10:07 | 00:00:24 | [NAME] | 00:00:34 | 00:11:05 | 5 | [NAME]
3158 | 17363 | Neyra Ninel | Gutierrez | MEX | 0 | 00:10:34 | 00:00:24 | 00:16:03 | 00:00:32 | 00:11:40 | 6 | 00:39:13
Spreadsheet: 687024d1594917729-countifs-for-unique-data-book1
Sheet: Sheet1

 | Client | Date |  |  |  | Total Distinct Clients | New Unique Clients |  |  | Comment
 | [NAME] | 2020-04-15 00:00:00 |  |  | To End of April |  |  |  |  | 3 clients, all unique
 | [NAME] | 2020-04-30 00:00:00 |  |  | To End of May |  |  |  |  | 8 deals but [NAME] and [NAME] each had 2 deals so 6 DISTINCT. From April, [NAME] and [NAME] are new
 | [NAME] | 2020-04-30 00:00:00 |  |  | To End of June |  |  |  |  | 7 discint clients, [NAME] was new
 | [NAME] | 2020-05-10 00:00:00
 | [NAME] | 2020-05-10 00:00:00
 | [NAME] | 2020-05-10 00:00:00
 | [NAME] | 2020-05-30 00:00:00
 | [NAME] | 2020-05-30 00:00:00
 | [NAME] | 2020-06-10 00:00:00 |  |  |  | To the extend helpful, these were my formulas
 | [NAME] | 2020-06-15 00:00:00 |  |  |  | Array for total distinct | Arrow for unique
 | [NAME] | 2020-06-30 00:00:00 |  |  |  |  |  |  |  | 7 distinct, only unique clients are [NAME] and [NAME]
 | [NAME] | 2020-06-30 00:00:00
 | [NAME] | 2020-06-30 00:00:00