tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 683901d1593031035-convert-single-row-data-with-multiple-columns-into-multiple-row-data-with-only-two-columns-basin-street-excelforum-sample
Sheet: Desired Formatting

ISRC | Writer/Composer
USBAS0000001 | [NAME]
USBAS0000008 | [NAME]
USBAS0000008 | [NAME]
USBAS0000008 | [NAME]
USBAS0100001 | [NAME]
USBAS0100001 | [NAME]
USBAS0100002 | Kermit Ruffins
USBAS0100003 | Wilmore Jones
USBAS0100003 | Fleecy Moor
USBAS0200045 | [NAME]
USBAS0200045 | [NAME]
USBAS0200045 | [NAME]
USBAS0200045 | [NAME]
USBAS0200045 | [NAME]
USBAS0200045 | [NAME]
USBAS0200046 | Dr. [NAME]
USBAS0200049 | [NAME]
USBAS0200049 | [NAME]
USBAS0200060 | [NAME]
USBAS0200060 | [NAME]
USBAS0200060 | [NAME]
USBAS0200060 | [NAME]
USBAS1400111 | [NAME]
USBAS1400111 | [NAME]
USBAS1400111 | [NAME]
USBAS1400111 | [NAME]
USBAS1400111 | [NAME]
USBAS1400111 | [NAME]
USBAS1400111 | [NAME]
USBAS1400111 | Gregory Veals
USBAS1400111 | [NAME]
USBAS1400111 | [NAME]
USBAS1400111 | [NAME]
USBAS1400416 | [NAME]
USBAS1400416 | [NAME] Neville
USBAS1400416 | [NAME] Neville
USBAS1400416 | [NAME]
USBAS1400416 | [NAME]
USBAS1400417 | [NAME], Jr.
USBAS1400418 | [NAME]
USBAS1400426 | [NAME]
USBAS1400426 | Eugen [NAME]
USBAS1600204 | [NAME]
USBAS1600204 | [NAME]
USBAS1800106 | [NAME]
USBAS1800106 | Ira Gershwin
USBAS1800106 | [NAME]
USBAS1800106 | [NAME]
USBAS1800107 | Dr. [NAME]
USBAS1800108 | [NAME]
USBAS1800108 | [NAME]
Spreadsheet: 51252d1250783138-can-conditional-formatting-formulas-have-multiple-statements-excelforum-1-
Sheet: Drop Down

Cust | IN |  |  | Applied by | Reason | Removed by
Tigger | RB |  |  | AN | Sheet | AN
CT | DN |  |  | DN | Part | DN
CN | RB |  |  | MM | Proc | MM
Jo | RB |  |  | [NAME] | Change | [NAME]
 |  |  |  | M |  | M
 |  |  |  | RB |  | RB
 |  |  |  | RL |  | RL
Spreadsheet: 137860d1327413349-auto-filter-query-auto-filter
Sheet: Sheet1

 |  | Dates
 |  | 2011-04-01 00:00:00
 |  | 2011-04-02 00:00:00
 |  | 2011-04-03 00:00:00 |  | I would like the selected date using the filter to appear in cell A1 of sheet 2
 |  | 2011-04-04 00:00:00
 |  | 2011-04-05 00:00:00
 |  | 2011-04-06 00:00:00
 |  | 2011-04-07 00:00:00
 |  | 2011-04-08 00:00:00
 |  | 2011-04-09 00:00:00
 |  | 2011-04-10 00:00:00
 |  | 2011-04-11 00:00:00
 |  | 2011-04-12 00:00:00
 |  | 2011-04-13 00:00:00
 |  | 2011-04-14 00:00:00
 |  | 2011-04-15 00:00:00
 |  | 2011-04-16 00:00:00
 |  | 2011-04-17 00:00:00
 |  | 2011-04-18 00:00:00
 |  | 2011-04-19 00:00:00
 |  | 2011-04-20 00:00:00
 |  | 2011-04-21 00:00:00
Spreadsheet: 748937d1632419595-display-unique-value-based-upon-latest-time-stamp-test
Sheet: Sheet1

Original Columns  -  Has Duplicates
Data | Times |  | Data | Times
00T464154 | 2021-09-21 09:44:37
00T464154 | 2021-09-21 12:08:51
00T464154 | 2021-09-21 19:20:02 | Display Last Instance
02U572083 | 2021-09-21 03:19:49
07U632089 | 2021-09-21 13:52:25
07U632090 | 2021-09-21 15:36:16
08T720293 | 2021-09-21 09:44:30
08T720629 | 2021-09-21 20:36:43
08T720630 | 2021-09-21 19:37:26
08T720630 | 2021-09-21 15:26:14
08T720630 | 2021-09-21 12:31:53 | Display Last Instance
08T720631 | 2021-09-21 17:14:39
08T720633 | 2021-09-21 13:42:19
08T720633 | 2021-09-21 20:53:15 | Display Last Instance
Spreadsheet: 726638d1617345880-help-on-nested-if-formula-if
Sheet: Sheet1

 |  |  | S.NO | Header | Price | Price Band
 |  |  | 1 | FT |  | =IF(F3<=1500,"<=1500",IF(AND(F3>1500,F3<=2000),"1501-2000",IF(AND(F3>2000,F3<=3000),"2001-3000",IF(AND(F3>3000,F3<=4000),"3001-4000",">4000"))))
 |  |  | 2 | SO |  | =IF(F3<=500,"Up to 500",IF(AND(F3>500,F3<=750),"501-750",IF(AND(F3>750,F3<=1000),"751-1000",IF(AND(F3>1000,F3<=1300),"1001-1300",IF(AND(F3>1300,F3<=1600),"1301-1600",IF(AND(F3>1600,F3<=2000),"1601-2000","2000+"))))))
 |  |  | 3 | TI |  | =IF(F3<=2000,"<2K",IF(AND(F3>2000,F3<=3000),"2K-3K",IF(AND(F3>3000,F3<=5000),"3K-5K",">5K")))
 |  |  | 4 | SO-S |  | =IF(F3<=500,"Up to 500",IF(AND(F3>500,F3<=750),"501-750",IF(AND(F3>750,F3<=1000),"751-1000",IF(AND(F3>1000,F3<=1300),"1001-1300",IF(AND(F3>1300,F3<=1600),"1301-1600",IF(AND(F3>1600,F3<=2000),"1601-2000","2000+"))))))
 |  |  | 5 | FT-T |  | T
 |  |  | 6 | ZP |  | ZP
 |  |  |  |  |  | =IF(E3="TI",IF(F3<=2000,"<2K",IF(AND(F3>2000,F3<=3000),"2K-3K",IF(AND(F3>3000,F3<=5000),"3K-5K",">5K"))),IF(E3="FT",IF(F3<=1500,"<=1500",IF(AND(F3>1500,F3<=2000),"1501-2000",IF(AND(F3>2000,F3<=3000),"2001-3000",IF(AND(F3>3000,F3<=4000),"3001-4000",">4000")))),IF(E3="SO",IF(F3<=500,"Up to 500",IF(AND(F3>500,F3<=750),"501-750",IF(AND(F3>750,F3<=1000),"751-1000",IF(AND(F3>1000,F3<=1300),"1001-1300",IF(AND(F3>1300,F3<=1600),"1301-1600",IF(AND(F3>1600,F3<=2000),"1601-2000","2000+")))))))))
Spreadsheet: 806438d1669301993-filter-date-bounded-between-two-ranges-test-date66
Sheet: Sheet1

 |  | start date | 2022-11-26 00:00:00 |  | end date | 2022-12-01 00:00:00 |  |  |  |  |  |  |  | output
 | 2022-11-24 00:00:00 | 2022-11-25 00:00:00 | 2022-11-26 00:00:00 | 2022-11-27 00:00:00 | 2022-11-28 00:00:00 | 2022-11-29 00:00:00 | 2022-11-30 00:00:00 | 2022-12-01 00:00:00 | 2022-12-02 00:00:00 |  |  |  |  | 2022-11-26 00:00:00 | 2022-11-27 00:00:00 | 2022-11-28 00:00:00 | 2022-11-29 00:00:00 | 2022-11-30 00:00:00 | 2022-12-01 00:00:00 | sum
 | 3 | 4 | 0 | 2 | 0 | 3 | 8 | 9 | 13 |  |  |  |  | 0 | 2 | 0 | 3 | 8 | 9
 | 6 | 13 | 20 | 27 | 34 | 41 | 48 | 55 | 62 |  |  |  |  | 20 | 27 | 34 | 41 | 48 | 55
 | 6 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 |  |  |  |  | 56 | 56 | 56 | 56 | 56 | 56
 | 8 | 33 | 58 | 83 | 108 | 133 | 158 | 183 | 208 |  |  |  |  | 58 | 83 | 108 | 133 | 158 | 183
 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 |  |  |  |  | 9 | 9 | 9 | 9 | 9 | 9
Spreadsheet: 111822d1308102973-using-isblank-helpforumexample
Sheet: Sample Data 4

 | Program Name | Minimum Investment | Performance Fee | Inception Date | Assets Traded | Highest Month | Lowest Month | Percent Winning Months | Average Monthly ROI | Annualized ROI | Standard Deviation
 | D1 | 15000 | 0.35 | 2000-01-01 00:00:00 | Spot Currencies | 0.158 | -0.039 | 0.6842105263157895 | -0.00125 | -0.015 | 0.04484898796176875
Year | Jan | Feb | Mar | Apr | May | Jun | July | Aug | Sept | Oct | Nov | Dec | Total
2008
2009
2010
2011 | 0.005 | -0.039
Spreadsheet: 356273d1415043491-creating-matrix-with-common-values-example1
Sheet: Sheet1

[NAME] | ACTIVITY2 | [NAME] | ACTIVITY4
3300 | 2200 | 3300 | 13000
4400 | 1100 | 3300 | 14000
5500 | 4400 | 4400 | 5000
6600 | 2200 | 9900
7700 |  | 10000
8800 |  | 11000
 |  | 12000
Spreadsheet: 206557d1358221339-sort-name-winner-and-gender-sort-name-and-winner-revised
Sheet: Sheet1

BDO 2ND FUN RUN 2012
ROBINSON'S PLACE SN. NICOLAS I.N.
21 K FINAL RESULT
RANK | RACE BIB # | NAME | TIME | GENDER
 | 2163 |  | 0:00:15.351000
 | 2179 |  | 0:00:28.736000
 | 2104 |  | 0:00:41.232000
 | 2166 |  | 0:00:55.084000
 | 2125 |  | 0:01:04.585000
 |  |  | 0:01:17.034000
 |  |  | 0:01:30.684000
 |  |  | 0:01:48.359000
 |  |  | 0:02:05.113000
 |  |  | 0:02:23.833000
 |  |  | 0:02:33.349000
Spreadsheet: 825401d1681302643-formula-to-find-specific-data-using-multiple-drop-down-lists-book1-ans2
Sheet: Sheet1

Year: | FY24
Quarter: | Q2
Account: | All
Forecast: | All
First Date: | 2023-03-01 00:00:00
 |  |  | Qty | Q1 | Q2 | Q3 | Q4 | Total |  |  | Concatenate
 | Forecast Category
 | Won
 | In Forecast
 | Not In Forecast
Spreadsheet: 120695d1315464861-lookup-multiple-returns-lookup
Sheet: Salesman

Forename | Surname | DOB | Gender | Attribute | Postcode
Black | Stuart | 1972-09-11 00:00:00 | m | B-S-11/09/1972-m | unknown
Bowyer | [NAME] | 1971-02-26 00:00:00 | m | B-R-26/02/1971-m | unknown
Bull | [NAME] | 1982-07-25 00:00:00 | m | B-A-25/07/1982-m | unknown
Burgoyne | [NAME] | 1989-01-07 00:00:00 | f | B-M-07/01/1989-f | unknown
Spreadsheet: 816516ae-b936-4f6c-b1a8-64d7995504a1
Sheet: Page 5

Permit No.: |  |  | WQ0003765 |  |  | Facility Name: |  | New Bern Seven Water Reclamation Facility |  |  |  |  |  | County: | [NAME] |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | SBF-1 |  | Field Name: |  | SBF-2 |  | Field Name: |  | SBF-3 |  | Field Name: |  | SBF-4
 |  |  |  |  |  | Area (acres): |  | 0.72 |  | Area (acres): |  | 0.72 |  | Area (acres): |  | 0.72 |  | Area (acres): |  | 0.72
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.57 |  | [NAME] (in): |  | 0.57 |  | [NAME] (in): |  | 0.57 |  | [NAME] (in): |  | 0.57
 |  |  |  |  |  | Annual Rate (in): |  | 21 |  | Annual Rate (in): |  | 21 |  | Annual Rate (in): |  | 21 |  | Annual Rate (in): |  | 21
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 187416d1350453517-help-with-look-up-functions-example17th
Sheet: Sheet5

Number | Box Number
863 | 765
249 | 199
482 | 788
717 | 924
682 | 275
161 | 668
769 | 727
378 | 402
650 | 501
607 | 77
675 | 588
850 | 849
859 | 621
967 | 41
867 | 539
755 | 872
482 | 828
269 | 551
636 | 221
876 | 409
261 | 200
876 | 959
801 | 575
405 | 6
806 | 979
6 | 201
492 | 517
941 | 86
965 | 175
Spreadsheet: 127213d1320236235-excel-2007-excel-2007-formular-as-a-percentage-forum
Sheet: Arkusz1

1 | 2
2 | 3
3 | 4
4 | 5
5 | 6
6 | 7
7 | 8
8 | 9
9 | 10
10 | 11
11 | 12
Spreadsheet: 147071d1332512515-chart-display-axis-values-as-a-time-ever-0-30-minute-chart
Sheet: Sheet1

 |  |  |  | ATM Name | Fail time | fix time
 |  |  |  | UNIT # 1 | 09:25:00
 |  |  |  | UNIT # 2
 |  |  |  | UNIT # 3
 |  |  |  | UNIT # 4
 |  |  |  | UNIT # 5
 |  |  |  | UNIT # 6
 |  |  |  | UNIT # 7
 |  |  |  | UNIT # 8
 |  |  |  | UNIT # 9
 |  |  |  | UNIT # 10
 |  |  |  | UNIT # 11
 |  |  |  | UNIT # 12
 |  |  |  | UNIT # 13
 |  |  |  | UNIT # 14
 |  |  |  | UNIT # 15
 |  |  |  | UNIT # 16
Spreadsheet: 127241d1320251137-stacked-bar-chart-bar-size-on-dates-and-colouring-as-a-percentage-of-tasks-complete-799406
Sheet: Sheet1

 | Start | Finish | Completed | Remaining | Total |  |  | Start | Completed | Remaining
Milestone 1 | 2011-10-17 00:00:00 | 2011-11-14 00:00:00 | 3 | 11 | 14
Milestone 2 | 2011-11-14 00:00:00 | 2011-11-28 00:00:00 | 0 | 7 | 7
Milestone 3 | 2011-11-28 00:00:00 | 2011-12-12 00:00:00 | 0 | 7 | 7
Milestone 4 | 2011-12-12 00:00:00 | 2011-12-16 00:00:00 | 0 | 5 | 5
 | 2011-10-01 00:00:00 | 2011-12-31 00:00:00
[NAME]
Spreadsheet: 136862d1326852721-how-to-calculate-unknown-x-values-dnacalculate
Sheet: Protocol

Protocol description
Protocol name ..................... Qubit dsDNA [NAME]
Protocol number ................... N/A
Name of the plate type ............ [NAME] 8x12 DELFIA strip plate
Number of repeats ................. 1
Delay between repeats ............. 0 s
Measurement height ................ Default
Protocol notes ....................
Name of the label ................. 485/535exc/emYui
Label technology .................. Prompt fluorometry
CW-lamp filter name ............... 485
CW-lamp filter slot ............... A3
Emission filter name .............. F535
Emission filter slot .............. A5
Measurement time .................. 1.0 s
Emission aperture ................. Normal
CW-lamp energy .................... 20125
Second measurement CW-lamp energy . 0
Emission side ..................... Above
CW-Lamp Control ................... Stabilized Energy
Excitation Aperture ............... N/A
Plate map of plate 1
A | M   M   M   E   E   E   E   E   E   E   E   E
B | M   M   M   E   E   E   E   E   E   E   E   E
C | M   M   M   E   E   E   E   E   E   E   E   E
D | M   M   M   E   E   E   E   E   E   E   E   E
E | M   M   M   E   E   E   E   E   E   E   E   E
F | M   E   E   E   E   E   E   E   E   E   E   E
G | M   E   E   E   E   E   E   E   E   E   E   E
H | E   E   E   E   E   E   E   E   E   E   E   E
Spreadsheet: 797620d1664012759-formula-to-recalculate-lap-times-when-actual-times-vary-from-goal-times-lap-calculator-hd
Sheet: Sheet1

 | Goal laps in 10 hrs | 600
 | 30
 | Lap target required | Actual lap time | New lap target
1 |  | 00:15:00
2 |  | 00:18:00
3 |  | 00:24:00
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Spreadsheet: phillip_m_love__30490__arnold pos 2001
Sheet: 06-20-01

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NYMEX Equivalent Gas Position |  |  |  |  | 7 |  |  | 600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POSITION   REPORT
TIME BUCKET/KEY: |  | 1 |  |  |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14
(Positions in Cont. [NAME].)     From: |  |  |  | July |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total ECT |  | Prior Day |  |  |  | CHECK LINKS
To: |  |  |  | Index |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Change |  | to HEDGESTRIPS
[NAME]
NYMEX Price
NYMEX NG-MM
NG PR CAN
NG-Long Term Exotic
NG LTX  Hedge-Basis Notional
NG LTX  Hedge-Basis Equivalent
Exotic Options
Exotic Options-Basis Notional
Exotic Options-Basis Equivalent
NG EOL Basis
NG EOL Basis Equivalent
NYMEX-Gas Daily
NG-GDL
TOTAL: |  |  |  | 0
Previous Day Change
Spreadsheet: 799044d1664893168-count-with-criteria-scoresheet-example
Sheet: Sheet1

Question Number | Question Type (T/B) | Subject Area           (MA, SC, SS, LA, AH) | STARTER 1 | STARTER 2 | STARTER 3 | STARTER 4 | ALTERNATE 1 | ALTERNATE 2 | ALTERNATE 3 | ALTERNATE 4 | BONUS POINT | BOUNCEBACK BONUS
1 | T | MA |  | 1
2 | B | SC |  |  |  |  |  |  |  |  | 1
3 | T | AH |  |  |  | 1
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1ST HALF
Number of Tossups Heard
Number of Tossups Correct
Number of Bonuses Heard
Number of Bonuses Correct
Number of Bouncebacks Correct
Number of MA Heard
Number of MA Correct
Number of SC Heard
Number of SC Correct
Number of SS Heard
Number of SS Correct
Number of LA Heard
Number of LA Correct
Number of AH Correct
Number of AH Correct
Spreadsheet: 220039d1363038663-counting-days-formula-formulas
Sheet: Formula 2 IDEA

Date 1 | Date 2 | Date 3 | Date 4 | Date 5 | Date 6 |  | 1st applicable value | 2nd applicable value
2012-06-17 00:00:00 | not applicable | not applicable | not applicable | 50 | 80 |  | = to first value different from "not applicable" in row 4 starting from A4 (in this case would be 50) | = to second value different from "not applicable" in row 4 starting from A4 (in this case would be 80)
2012-06-18 00:00:00
2012-06-19 00:00:00
2012-06-20 00:00:00
2012-06-21 00:00:00
2012-06-22 00:00:00
Spreadsheet: 437424d1451337059-copy-cells-down-from-different-tab-names-in-order-daily-workout
Sheet: Squat (1)

 |  | Weight Moved Today
Volume Week 1
 |  | Exercise | Set 1 | Set 2 | Set 3 | Set 4 | Set 5 | Set 6 | Set 7 | Set 8 | Set 9 | Set 10 | Set 11 | Set 12
Date | 2015-12-28 00:00:00 | Squat 1
Start |  | Squat 2x8
Finish |  | Weight | 135 | 225 | 275 | 335 | 335
Weight | 205.4 | Notes | 75%, same weight add one set per session
% Body Fat |  | [NAME] 4x25
 |  | Weight | 180 | 270 | 270 | 270
 |  | Notes | Push 25 yards each way
Spreadsheet: 708375d1607769234-waybill-puzzle-max-weight-total-lbs-to-max-150-carry-over-remainder-and-repeat-waybill-puzzle_solver-hydr-
Sheet: Solv_setup_Hydr

Item | Qty | Lbs | Total lbs | [NAME] lbs |  | What I want it to have my formulate produce as the end result
 |  |  |  | 150 |  | Waybill 1 | Waybill 2 | Waybill 3
Clear ziplock baggies | 1 | 40 |  |  |  | 0 | 0 | 1
baggies tie close | 2 | 40 |  |  |  | 0 | 2 | 0
cans | 2 | 17 |  |  |  | 0 | 2 | 0
Sterile water | 8 | 15 |  |  |  | 5 | 2 | 1
Swabs | 2 | 6 |  |  |  | 2 | 0 | 0
Spoons | 8 | 6 |  |  |  | 8 | 0 | 0
Straps | 3 | 3 |  |  |  | 3 | 0 | 0
dowels | 1 | 2 |  |  |  | 1 | 0 | 0
blister pacsk | 1 | 1 |  |  |  | 1 | 0 | 0
screens | 2 | 1 |  |  |  | 2 | 0 | 0
Straws | 1 | 0.5 |  |  |  | 1 | 0 | 0
 |  |  |  |  | Total lbs
 |  |  |  |  |  | =< | =< | =<
 |  |  |  |  |  | 150 | 150 | 150
Spreadsheet: keith_holst__19419__NewDealCheck
Sheet: R3

 | 2001-10-01 00:00:00 | IF-CIG/RKYMTN | -535.5
 | 2001-10-01 00:00:00 | IF-ELPO/PERMIAN | 288.2356
 | 2001-10-01 00:00:00 | IF-ELPO/SJ | 459.5
 | 2001-10-01 00:00:00 | IF-HEHUB | 243.87
 | 2001-10-01 00:00:00 | IF-NTHWST/CANB | 0
 | 2001-10-01 00:00:00 | IF-NTHWST/CANBR | 0
 | 2001-10-01 00:00:00 | IF-NWPL_ROCKY_M | -461
 | 2001-10-01 00:00:00 | IF-WAHA-TX | 244.5
 | 2001-10-01 00:00:00 | NGI-MALIN | -288
 | 2001-10-01 00:00:00 | NGI-PGE/CG | 397.391
 | 2001-10-01 00:00:00 | NGI-SOBDR-PG&E | -14
 | 2001-10-01 00:00:00 | NGI-SOCAL | 273.25
 | 2001-10-01 00:00:00 | NGMR-AECO/C | 0
 | 2001-11-01 00:00:00 | AECOUS | 0
 | 2001-11-01 00:00:00 | IF-NTHWST/CANBR | 29.9688834
 | 2001-11-01 00:00:00 | NGMR-AECO/C | 0
 | 2001-12-01 00:00:00 | IF-NTHWST/CANBR | 30.90619958
 | 2002-01-01 00:00:00 | IF-NTHWST/CANBR | 30.84258138
 | 2002-02-01 00:00:00 | IF-NTHWST/CANBR | 27.80092616
 | 2002-03-01 00:00:00 | IF-NTHWST/CANBR | 30.72680134
 | 2002-04-01 00:00:00 | IF-NTHWST/CANBR | 0
Spreadsheet: 768651d1645063783-do-and-function-then-alpha-copy-of-non-anagram-compile
Sheet: Sheet1

 |  | A | E | I | O | U
AAA | DLN
AAE | DLN
AAI | DLN
AAO | DLN
AAU | DLN
AEE | DLN
[NAME] | DLN
AEI | DLN
AEO | DLN
AEU | DLN
AII | DLN
AIO | DLN
AIU | DLN
AOO | DLN
AOU | DLN |  |  |  |  |  | << old formula
AUU | DLN
EEE | DLN
EEI | DLN
EEO | DLN
EEU | DLN
EII | DLN
EIO | DLN
EIU | DLN
EOO | DLN
EOU | DLN
EUU | DLN
III | DLN
IIO | DLN
IIU | DLN
IOO | DLN
IOU | DLN
IUU | DLN
OOO | DLN
OOU | DLN
OUU | DLN
UUU | DLN
Spreadsheet: 856656d1705860183-getting-number-out-of-a-row-excel-forum-help-2-
Sheet: Sheet2

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35
1 | - | 9 | 16 | 14 | 12 | 16 | 15 | 17 | 15 | 8 | 15 | 15 | 15 | 11 | 14 | 13 | 14 | 9 | 11 | 17 | 9 | 17 | 12 | 13 | 14 | 8 | 13 | 12 | 7 | 15 | 9 | 13 | 18 | 15 | 13
2 | 9 | - | 17 | 12 | 8 | 17 | 5 | 11 | 7 | 11 | 12 | 12 | 11 | 13 | 9 | 11 | 11 | 10 | 14 | 14 | 12 | 10 | 11 | 10 | 16 | 12 | 12 | 11 | 14 | 10 | 13 | 15 | 15 | 14 | 7
3 | 16 | 17 | - | 19 | 20 | 15 | 17 | 16 | 10 | 14 | 12 | 20 | 15 | 17 | 17 | 17 | 22 | 14 | 20 | 13 | 13 | 15 | 20 | 10 | 15 | 17 | 17 | 11 | 16 | 17 | 20 | 20 | 16 | 9 | 13
Spreadsheet: 860361d1708490293-solucion-a-plantilla-de-seguimiento-libro2024
Sheet: Hoja1

 |  |  |  |  | Seguimiento 8AM | Seguimiento 10AM | Seguimiento 12PM | Seguimiento 14PM | Seguimiento 15PM | Seguimiento 16PM | Seguimiento 17PM
 |  |  |  |  | EN RUTA | EN RUTA | EN RUTA | EN RUTA | EN RUTA | EN RUTA | ENTREGADO
 |  |  |  |  | EN RUTA | EN RUTA | EN RUTA | ENTREGADO | - | - | -
 |  |  |  |  | EN RUTA | EN RUTA | EN RUTA | EN RUTA | EN RUTA | ENTREGADO | -
 |  |  |  |  | EN RUTA | EN RUTA | ENTREGADO | - | - | - | -
 |  |  |  |  | ENTREGADO | - | - | - | - | - | -
 |  |  |  |  | EN RUTA | EN RUTA | RECHAZADO | - | - | - | -
 |  |  |  |  | EN RUTA | EN RUTA | EN RUTA | EN RUTA | EN RUTA | RECHAZADO | -
 |  |  |  |  | EN RUTA | EN RUTA | EN RUTA | EN RUTA | EN RUTA | EN RUTA | MOTIVADO
 |  |  |  |  | EN RUTA | MOTIVADO | - | - | - | - | -
 |  |  |  |  | RECHAZADO | - | - | - | - | - | -
 |  |  |  |  | EN RUTA | EN RUTA | EN RUTA | EN RUTA | EN RUTA | EN RUTA | EN RUTA
 |  |  |  |  | MOTIVADO | - | - | - | - | - | -
 |  |  |  |  | EN RUTA | EN RUTA | EN RUTA | EN RUTA | ENTREGADO | - | -
 |  |  |  |  | EN RUTA | EN RUTA | EN RUTA | EN RUTA | EN RUTA | EN RUTA | EN RUTA
 |  |  |  |  | EN RUTA | RECHAZADO | - | - | - | - | -
 |  |  |  |  | EN RUTA | EN RUTA | ENTREGADO | - | - | - | -
 |  |  |  |  | EN RUTA | EN RUTA | MOTIVADO | - | - | - | -
Spreadsheet: 765297d1643271923-working-time-with-varied-day-lengths-excluding-weekends-and-holidays-elapsed-time-v3-
Sheet: Sheet1

Start Date | Start Time | End Date | End Time | Elapsed time (Hours) |  | Mon…Thur | Fri
2021-01-04 00:00:00 | 06:00:00 | 2021-01-29 00:00:00 | 07:15:00 |  |  | 6am - 10pm | 6am - 4pm
Holidays
Christmas day | 2021-12-25 00:00:00
Boxing day | 2021-12-26 00:00:00
New years day | 2022-01-01 00:00:00
 |  | mins/day
 | 2021-01-04 00:00:00
 | 2021-01-05 00:00:00
 | 2021-01-06 00:00:00
 | 2021-01-07 00:00:00
 | 2021-01-08 00:00:00
 | 2021-01-09 00:00:00
 | 2021-01-10 00:00:00
 | 2021-01-11 00:00:00
 | 2021-01-12 00:00:00
 | 2021-01-13 00:00:00
 | 2021-01-14 00:00:00
 | 2021-01-15 00:00:00
 | 2021-01-16 00:00:00
 | 2021-01-17 00:00:00
 | 2021-01-18 00:00:00
 | 2021-01-19 00:00:00
 | 2021-01-20 00:00:00
 | 2021-01-21 00:00:00
 | 2021-01-22 00:00:00
 | 2021-01-23 00:00:00
 | 2021-01-24 00:00:00
 | 2021-01-25 00:00:00
 | 2021-01-26 00:00:00
 | 2021-01-27 00:00:00
 | 2021-01-28 00:00:00
 | 2021-01-29 00:00:00 | 75
 | 2021-01-30 00:00:00
 | 2021-01-31 00:00:00
 | TOTAL MINUTES
Spreadsheet: 164950d1340967668-pull-unique-values-based-on-adjacent-column-example
Sheet: Sheet1

Area | Value
Area 1 | Value 3
Area 4 | Value 35
Area 3 | Value 7
Area 4 | Value 25
Area 1 | Value 20
Area 2 | Value 21
Area 3 | Value 17
Area 2 | Value 34
Area 3 | Value 20
Area 4 | Value 38
Area 3 | Value 4
Area 1 | Value 5
Area 3 | Value 23
Area 4 | Value 31
Area 2 | Value 25
Area 4 | Value 36
Area 2 | Value 21
Area 2 | Value 21
Area 3 | Value 16
Area 3 | Value 10
Area 2 | Value 4
Area 1 | Value 28
Area 2 | Value 28
Area 4 | Value 24
Area 1 | Value 19
Area 4 | Value 34
Area 1 | Value 18
Area 3 | Value 19
Area 4 | Value 27
Area 1 | Value 21
Area 2 | Value 29
Area 4 | Value 32
Area 3 | Value 12
Area 1 | Value 22
Area 2 | Value 1
Area 3 | Value 6
Area 1 | Value 21
Area 1 | Value 4
Area 1 | Value 21
Area 3 | Value 5
Area 4 | Value 37
Area 1 | Value 15
Area 1 | Value 21
Area 1 | Value 12
Area 4 | Value 26
Area 1 | Value 21
Area 1 | Value 8
Area 3 | Value 15
Area 3 | Value 11
Area 2 | Value 3
Area 3 | Value 14
Area 1 | Value 21
Area 3 | Value 21
Area 2 | Value 32
Area 1 | Value 9
Area 4 | Value 33
Area 3 | Value 9
Area 3 | Value 22
Area 1 | Value 28
Area 2 | Value 2
Area 1 | Value 13
Area 4 | Value 28
Area 4 | Value 29
Area 3 | Value 13
Area 4 | Value 30
Area 2 | Value 28
Area 3 | Value 18
Area 1 | Value 16
Area 2 | Value 28
Area 2 | Value 30
Area 3 | Value 8