tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 828133d1683235220-pull-data-from-one-sheet-to-another-from-last-data-entered-in-a-column-and-the-12-24-above-ak-sample3-gcb-close-1
Sheet: COVER-12

 | ANIMAL KINGDOM |  |  |  |  |  | unlock 1111 |  |  |  |  |  |  | combo | Cover
Well No. | 12H | 13H | 14H | 15H | Total |  |  |  |  |  |  |  |  | combo
Start Date: |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Online/Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Choke |  |  |  |  |  |  |  |  |  |  |  |  |  | lt f
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | lt p
Casing PSI |  |  |  |  |  |  | Copy and paste table into email body |  |  |  |  |  |  | fork
Surface Csg |  |  |  |  |  |  |  |  |  |  |  |  |  | lift
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | trash
Water / Day |  |  |  |  |  | Clear | enter water totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | ft
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | ft
Oil / Day |  |  |  |  |  |  | enter oil totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
[NAME] to sales |  |  |  |  |  |  |  |  |  |  |  |  |  | plug C
Gas / Day |  |  |  |  |  |  | enter gas totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
Inj / Day | off | off | off |  |  |  |  |  |  |  |  |  |  | st
 |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Yesterday Lact |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Notes: | =LET(a,[NAME]:B,'12H'!S:S,SEQUENCE(ROWS('12H'!A:A))),'12H'!S:S<>""), |  |  |  |  |  | gfhghcghghgvhvgvgvhgvhvghvgvgh
 | LastTime,CHOOSECOLS(TAKE(a,-1),1),
 | LastSeqNo,CHOOSECOLS(TAKE(a,-1),3),
 | MinSeqNo,LastSeqNo-(MOD(LastTime,1)+IF(MOD(LastTime,1)<0.25,1,0)-0.25)*24, | 13H | 14H | 15H
GAS | b,INDEX(FILTER(a,INDEX(a,,3)>=MinSeqNo),,2),
WATER | TEXTJOIN(CHAR(10),,b))
OIL
 | AM |  |  |  |  |  | lact total
 | 12H | 13H | 14H | 15H |  |  | 0430 | 24 b4 |  |  |  |  | IF(g28-h28<0,0,g28-h28)
GAS |  |  |  |  |  | 750 |  | 118029
WATER |  |  |  |  |  | 760
OIL |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | 0
Spreadsheet: 59805d1260362432-getting-averages-from-seperate-worksheets-2010
Sheet: June

 |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday |  | Wednesday
 |  | 2010-06-01 00:00:00 |  | 2010-06-02 00:00:00 |  | 2010-06-03 00:00:00 |  | 2010-06-04 00:00:00 |  | 2010-06-05 00:00:00 |  | 2010-06-07 00:00:00 |  | 2010-06-08 00:00:00 |  | 2010-06-09 00:00:00 |  | 2010-06-10 00:00:00 |  | 2010-06-11 00:00:00 |  | 2010-06-12 00:00:00 |  | 2010-06-14 00:00:00 |  | 2010-06-15 00:00:00 |  | 2010-06-16 00:00:00 |  | 2010-06-17 00:00:00 |  | 2010-06-18 00:00:00 |  | 2010-06-19 00:00:00 |  | 2010-06-21 00:00:00 |  | 2010-06-22 00:00:00 |  | 2010-06-23 00:00:00 |  | 2010-06-24 00:00:00 |  | 2010-06-25 00:00:00 |  | 2010-06-26 00:00:00 |  | 2010-06-28 00:00:00 |  | 2010-06-29 00:00:00 |  | 2010-06-30 00:00:00
Consultant Name | Team Leader | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved
Mpho | [NAME]
[NAME] | [NAME]
Glodean ([NAME]) | [NAME]
[NAME] | [NAME]
Lehlohonolo | [NAME]
Matshidiso | [NAME]
Rachel | [NAME]
Naledi G | [NAME]
Innocentia | [NAME]
Glyndine | [NAME]
Total |  | 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 | 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
Consultant | Total Sales | Monthly Target | [NAME] | Total Approved | QA Monthly Score | QA Rating
Mpho | 0 |  | 0 | 0 |  | -
[NAME] | 0 |  | 0 | 0 |  | -
Glodean ([NAME]) | 0 |  | 0 | 0 |  | -
[NAME] | 0 |  | 0 | 0 |  | -
Lehlohonolo | 0 |  | 0 | 0 |  | -
Matshidiso | 0 |  | 0 | 0 |  | -
Rachel | 0 |  | 0 | 0 |  | -
Naledi G | 0 |  | 0 | 0 |  | -
Innocentia | 0 |  | 0 | 0 |  | -
Glyndine | 0 |  | 0 | 0 |  | -
Total | 0 | 0 | 0 | 0 | #N/A | #N/A
 |  | 0 | 0.8499 | D
 |  | 0.85 | 0.9 | C
 |  | 0.91 | 0.9499 | B
 |  | 0.95 | 1 | A
Spreadsheet: 139303d1328181445-conditional-concatenation-problem-for-badly-organised-data-concatenation-problem
Sheet: Example 4 Excel Forum

SOURCE DATA |  |  |  | REQUIRED RESULT (manually generated)
Review ID | Question | Answer |  | Review ID | Question | Answer
REV001 | Question X | R1, QX, Line 1 |  | REV001 | Question X | R1, QX, Line 1 R1, QX, Line 2 R1, QX, Line 3
 |  | R1, QX, Line 2
 |  | R1, QX, Line 3
[NAME] | QuestionY | R2, QY, Line 1 |  | [NAME] | QuestionY | R2, QY, Line 1 R2, QY, Line 2 R2, QY, Line 3 R2, QY, Line 4
 |  | R2, QY, Line 2
 |  | R2, QY, Line 3
 |  | R2, QY, Line 4
[NAME] | Question X | R2, QX, Line 1 |  | [NAME] | Question X | R2, QX, Line 1 R2, QX, Line 2
 |  | R2, QX, Line 2
Number of answer lines could be 20 or more |  |  |  | Preference is without the blank lines, but these can be removed by filtering out the blank lines
 |  |  |  | I'd also settle for all the answer text on one line
Spreadsheet: 723064d1615492273-lookup-with-upper-and-lower-boundaries-time-categorisation
Sheet: Sheet1

 | Start | Expected result | [NAME] |  | Category | Start From | Start To
 | 7:30:00 | Early |  |  | Early | 5:30:00 | 7:30:00
 | 14:00:00 |  |  |  | Late | 14:30:00 | 16:30:00
 | 15:00:00 | Late |  |  | Night | 22:00:00 | 23:30:00
 | 21:00:00
 | 23:00:00 | Night
 | 2:00:00
 | 5:40:00 | Early
Spreadsheet: e27dbdce-d72f-4c55-b064-7efafe5d5c0a
Sheet: Sheet3

MARRIED |  |  | 325
0 |  |  | 0
692 |  | 0 | 0.1
2179 |  | 148.7 | 0.15
6733 |  | 831.8 | 0.25
12892 |  | 2371.55 | 0.28
19279 |  | 4159.91 | 0.33
33888 |  | 8980.88 | 0.35
38192 |  | 10487.28 | 0.396
Spreadsheet: 796043d1663078913-countif-cells-within-a-range-and-are-filtered-afl-data-help
Sheet: Sheet1

 | Total Number |  | Numbers
 |  |  | Lower than expected |  | Expected |  | Higher than expected
 |  |  | Percentages
 |  |  | Lower than expected |  | Expected |  | Higher than expected
 | Sub-Total |  | Numbers
 |  |  | Lower than expected |  | Expected |  | Higher than expected
 |  |  | Percentages
 |  |  | Lower than expected |  | Expected |  | Higher than expected
Spreadsheet: 122137d1316626944-excel-2007-how-to-copy-column-to-another-column-columns
Sheet: Sheet1

01-02-03-04-10-22 | 01-02-03-04-12-24
01-02-03-04-10-23 | 01-02-03-04-12-25
01-02-03-04-10-24 | 01-02-03-04-12-26
01-02-03-04-10-25 | 01-02-03-04-12-27
01-02-03-04-10-26 | 01-02-03-04-12-28
01-02-03-04-10-27 | 01-02-03-04-12-29
01-02-03-04-10-28 | 01-02-03-04-12-30
01-02-03-04-10-29 | 01-02-03-04-12-31
01-02-03-04-10-30 | 01-02-03-04-12-32
01-02-03-04-10-31 | 01-02-03-04-12-33
01-02-03-04-10-32 | 01-02-03-04-12-34
01-02-03-04-10-33 | 01-02-03-04-12-35
01-02-03-04-10-34 | 01-02-03-04-12-36
01-02-03-04-10-35 | 01-02-03-04-12-37
01-02-03-04-10-36 | 01-02-03-04-12-38
01-02-03-04-10-37 | 01-02-03-04-12-39
01-02-03-04-10-38 | 01-02-03-04-12-40
01-02-03-04-10-39 | 01-02-03-04-13-14
01-02-03-04-10-40 | 01-02-03-04-13-15
01-02-03-04-11-12 | 01-02-03-04-13-16
01-02-03-04-11-13 | 01-02-03-04-13-17
01-02-03-04-11-14 | 01-02-03-04-13-18
01-02-03-04-11-15 | 01-02-03-04-13-19
01-02-03-04-11-16 | 01-02-03-04-13-20
01-02-03-04-11-17 | 01-02-03-04-13-21
01-02-03-04-11-18 | 01-02-03-04-13-22
01-02-03-04-11-19 | 01-02-03-04-13-23
01-02-03-04-11-20 | 01-02-03-04-13-24
01-02-03-04-11-21 | 01-02-03-04-13-25
01-02-03-04-11-22 | 01-02-03-04-13-26
01-02-03-04-11-23 | 01-02-03-04-13-27
01-02-03-04-11-24 | 01-02-03-04-13-28
01-02-03-04-11-25 | 01-02-03-04-13-29
01-02-03-04-11-26 | 01-02-03-04-13-30
01-02-03-04-11-27 | 01-02-03-04-13-31
01-02-03-04-11-28 | 01-02-03-04-13-32
01-02-03-04-11-29 | 01-02-03-04-13-33
01-02-03-04-11-30 | 01-02-03-04-13-34
01-02-03-04-11-31 | 01-02-03-04-13-35
Spreadsheet: chris_germany__2058__Apr 02 Avails
Sheet: Sheet1

April Gas Available
 |  |  | Juniper |  | 8/8ths Gas Available |  | WI Rates |  | Gas | Cond/Oil
Operated by | Property |  | WI |  | Mcfd | BTU | MMBtu/d |  | Marketed by: | Marketed by: | Sales Pt.
Juniper | West Cameron 310 |  | 0.5 |  | 7500 | 1.044 |  |  | PetroCom | Plains Mkt | Forest Oil - WC 313 Pltfm
BDO | Eugene Island 57 |  | 0.31667 |  | 7000 | 1.05 |  |  | PetroCom | [NAME] | Samedan - EI 57 'A' Pltfm
Juniper | Eugene Island 28 |  | 0.7 |  | 400 | 1.073 |  |  | PetroCom | [NAME] | Juniper - EI 28 'A' Pltfm
Samedan | High Island 232 |  | 0.5 |  | 0 | 1 |  |  | PetroCom | N/A | Samedan - HI 244 Pltfm
Houston Expl | S. Marsh Island 253 |  | 0.11875 |  | 20500 | 1.069 |  |  | Houston Expl. | Houston Expl. | Houston Expl. -SMI 253 'A' Pltfm
Hall-Houston | High Island 72 |  | 0.5 |  | 3500 | 1.05 |  |  | [NAME] | [NAME] | Bellweather - HI 71 'A' Pltfm
Hall-Houston | West Cameron 431 |  | 0.3 |  | 6100 | 1.018 |  |  | [NAME] | [NAME] | Hall - WC 431 'A' Pltfm
BDO | Bay Marchand 4&5 |  | 0.17946 |  | 225 | 1.1 |  |  | Adams Resources | [NAME] d"Arc | BDO - Bay Marchand 4&5
 | Totals:
Spreadsheet: 126122d1319537978-if-statement-help-io-cargo-tracker
Sheet: Quick Price

Grade | Price CFR | Price Diff | Price FOB
63.5/63 |  | 3
63/63 |  | 2
63/62 |  | 3
62/62 | 130 | -
62/61 |  | -3
61/61 |  | -2
61/60 |  | -4
60/60 |  | -3
60/59 |  | -6.5
59/59 |  | -3
59/58 |  | -6.5
58/58 |  | -3
58/57 |  | -6.5
57/57 |  | -3.5
57/56 |  | -6
56/56 |  | -4
56/55 |  | -7.5
55/55 |  | -4
55/54 |  | -7.5
54/54 |  | -4
54/53 |  | -8
53/53 |  | -4
53/52 |  | -8.5
52/52 |  | -5
52/51 |  | -8.5
51/51 |  | -5
51/50 |  | -9
50/50 |  | -5
Spreadsheet: 770489d1646118921-adding-an-activity-duration-in-hours-to-a-start-date-with-time-example
Sheet: Schedule

 |  |  |  |  |  |  | day_start | day_end
 |  |  |  |  |  |  | 6:00:00 | 18:00:00
 |  |  |  | Details
 | SN |  |  |  | Description |  |  |  |  | ind. Start |  |  |  |  |  |  | Work hours |  | Planned End (Based on formula) |  | Planned End (Required Result)
 | 1 |  |  |  | Header
 | 2 |  |  |  | Header
 | 3 |  |  |  | Main Activity Header
 | 4 |  |  |  | Main Asset
 | 5 |  |  |  | ERECT SCAFFOLDING |  |  |  |  | 2022-01-17 06:00:00 |  |  |  |  |  |  | 8 |  |  |  | 2022-01-17 14:00:00
 | 6 |  |  |  | ELECTRICAL ISOLATION |  |  |  |  | 2022-01-17 06:00:00 |  |  |  |  |  |  | 12 |  |  |  | 2022-01-17 18:00:00
 | 7 |  |  |  | FAN BELT DRIVEN |  |  |  |  | 2022-01-17 06:00:00 |  |  |  |  |  |  | 13 |  |  |  | 2022-01-18 07:00:00
 | 8 |  |  |  | RIGGING ASSITANCE |  |  |  |  | 2022-01-17 06:00:00 |  |  |  |  |  |  | 24 |  |  |  | 2022-01-18 18:00:00
 | 9 |  |  |  | REINSTATE ELECTRICAL CONNECTION |  |  |  |  | 2022-01-17 06:00:00 |  |  |  |  |  |  | 36 |  |  |  | 2022-01-19 18:00:00
 | 10 |  |  |  | REMOVE SCAFFOLDING |  |  |  |  | 2022-01-17 06:00:00
Spreadsheet: 744093d1628935128-calculate-work-hours-overtime-based-on-text-excel-calc-using-text-ans
Sheet: Sheet2

DATE | Total Hrs | NOTES |  |  |  |  | [NAME] | [NAME]
2021-08-09 00:00:00 | 9
2021-08-10 00:00:00 | 9
2021-08-11 00:00:00 | 9
2021-08-12 00:00:00 | 9
2021-08-13 00:00:00 | 8 | VACATION |  |  |  |  |  | 0
2021-08-14 00:00:00 | 11
2021-08-15 00:00:00
Total Hours
REGULAR HOURS
OVERTIME HOURS
Spreadsheet: 888247d1738734086-month-format-test_
Sheet: Date

 | Date
 | 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
Spreadsheet: e12cc8b4-4838-4223-aceb-0ee2dc2c1718
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
3517 | 6001 | Sarka | [NAME] | CZE | 31 | 00:20:01 | 00:00:34 | [NAME] | 00:00:54 | [NAME] | 1 | 01:11:58
3517 | 6313 | Marlies | Penker | AUT | 32 | 00:19:14 | 00:00:41 | 00:25:43 | [NAME] | 00:28:03 | 2 | 01:14:32
3517 | 21818 | Zuzana | Novakova | SVK | 34 | 00:23:46 | 00:01:10 | 00:37:05 | 00:01:04 | [NAME] | 3 | 01:36:36
3517 | 28257 | Janka | [NAME] | SVK | 0 | 00:24:57 | 00:00:43 | 00:35:39 | 00:01:40 | 00:43:29 | 4 | 01:46:28
Spreadsheet: sara_shackleton__36501__ENE MTM 0630 revised 2
Sheet: Report

 |  | Quarter End |  | 1999-12-31 00:00:00 | 2000-03-31 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00
 |  | Change dates yearly
ENRON CORP - EGF P&L
STOCK BOOK
 |  | Shares | Current Open | Available |  |  |  |  |  |  |  | Prior Day
 |  | ENE | ENE Shares | Capacity (shares) | 1st Qtr | 2nd Qtr | [NAME] | [NAME] | Daily | YTD |  | YTD
Opening Price - BOQ
Closing Price - EOQ
Closing Price -
OPEN MTM POSITIONS
 | Merrill Lynch
 | 6-28-00 swap at $68.50 |  |  |  |  |  |  |  |  |  |  | 0
 | 6-29-00 swap at $68.50 |  |  |  |  |  |  |  |  |  |  | 0
 | 6-30-00 swap at $68.3358 |  |  |  |  |  |  |  |  |  |  | 0
NON-MTM POSITIONS
 | CSFB
 | 4-5-00 swap at $66.9165 |  |  |  |  |  |  |  |  |  | 0 | 6946004
 | (converted to non-mtm at $76.125)
 | 4-6-00 swap at $67.6129 |  |  |  |  |  |  |  |  |  | 0 | 3728188
 | (converted to non-mtm at $76.125)
 | 4-17-00 swap at $64.7981 |  |  |  |  |  |  |  |  |  | 0 | 5650377
 | (converted to non-mtm at $76.125)
 | 6-27-00 swap at $68.4743 |  |  |  |  |  |  |  |  |  |  | 0
 | Merrill Lynch
 | No trades to date
 | Bear Stearns
 | 5-24-00 swap at $66.8698 | 323000 |  | 677000 |  |  |  |  |  |  | 0 | 2177032
 | (converted to non-mtm at $73.75
 | 2000-06-01 00:00:00
 | Warburg
 | 1-21-00 swap at $55.9375 |  |  |  |  |  |  |  |  |  | 0 | 137354
 | (closed at $65.4375)
 | [NAME] |  |  | NA
 | 1-20-00 swap at $61.00 |  |  |  |  |  |  |  |  |  | 0 | 85158000
 | (closed 4-20-00 at $71.00)
 | 4-20-00 swap at $71.00 |  |  |  |  |  |  |  |  | 0 | 0 | 0
EGF P&L
 | NOTES: |  |  |  |  |  | EGF Equity Position Limits
 | 1.  Position limits exclude ENA position, which is reflected in ENA equity books position report. |  |  |  |  |  |  |  | V@R | Notional Open
 | 2.  Includes 60% of JEDI, if an open position. |  |  |  |  |  | Limit ($[NAME]) |  | 10 | 300
 | 3.  P&L includes cost of financing. |  |  |  |  |  | Current Position ($[NAME])
 | CONTACTS:
 | CSFB | [NAME] |  | [PHONE]
 | Warburg | [NAME] |  | [PHONE]
 | Merrill Lynch | [NAME] |  | [PHONE]
 | Bear Stearns | [NAME] |  | [PHONE]
 | Lehman | [NAME] |  | [PHONE]
Spreadsheet: 864384d1711570021-index-match-reversed-need-to-find-the-value-in-column-a-classeur2
Sheet: Feuil1

Scale | Pointing1 | Pointing2 | Pointing3 | Pointing4
0 | Horrible | 1,10 and more GJ/m2 | 0-20% | Extreme
1 | Bad | 0,95 to 1,09999 GJ/m2 | 20-40% | Very high
2 | Passable | 0,8 to 0,94999 GJ/m2 | 40-60% | High
3 | Average | 0,65 to 0,79999 GJ/m2 | 60-80% | Moderate
4 | Good | 0,5 to 0,64999 GJ/m2 | 80-100% | Low
5 | Excellent |  |  | Very low
 |  |  | Expected result
Criterion 1 : | Pointing3 | 60-80% | 3
Criterion 2 | Pointing1 | Excellent | 5 |  | [NAME] to give me the scale according to the Pointing column and the date in said column.
Spreadsheet: 0304711f-aec1-44ce-ac2d-8d49f086debd
Sheet: Sheet1

Table 5--USDA-calculated world market rice prices (rough basis) 1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | 2012/13 |  |  | 2011/12 |  |  | 2010/11
 |  | Medium/ |  |  | Medium/ |  |  | Medium/
Month | Long | short |  | Long | short |  | Long | short
 | $/cwt
August | 11.91 | 12.13 |  | 14.08 | 14.4 |  | 9.58 | 9.68
September | 12.57 | 12.81 |  | 15.09 | 15.44 |  | 10.51 | 10.62
October | 12.72 | 12.97 |  | 15.63 | 15.99 |  | 12.15 | 12.29
November | 12.92 | 13.17 |  | 14.93 | 15.28 |  | 13.4 | 13.58
December | 12.62 | 12.86 |  | 13.9 | 14.21 |  | 14.5 | 14.67
January | 12.35 | 12.59 |  | 12.61 | 12.88 |  | 13.98 | 14.15
February | 11.77 | 12.43 |  | 11.81 | 12.2 |  | 12.68 | 13.35
March | 12.16 | 12.84 |  | 11.52 | 11.92 |  | 12.13 | 12.76
April | 12.18 | 12.86 |  | 11.15 | 11.54 |  | 11.76 | 12.36
May | 12.08 | 12.75 |  | 11.42 | 11.82 |  | 11.58 | 12.17
June | 12.17 | 12.85 |  | 11.93 | 12.35 |  | 11.78 | 12.39
July 2/ | 12.18 | 12.86 |  | 11.97 | 12.4 |  | 12.49 | 13.14
Market-year
average 1/ | 12.3025 | 12.76 |  | 13.00333333333334 | 13.36916666666666 |  | 12.21166666666667 | 12.59666666666666
1/ Simple average of the U.S. Department of Agriculture's weekly adjusted world market price.  2/  Preliminary.
Source: [NAME] and Rice Weekly Prices (ftp://ftp.fsa.usda.gov/public/cotton/default.htm), Farm Service Agency, USDA.
Last updated July 12, 2013.
Spreadsheet: e3d37ae0-a069-44b4-83cb-c7227e4677e9
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
8911 | 19370 | Anatolijs | Levsa | LAT | 257 | 00:15:36 | 00:00:44 | 00:29:36 | 00:01:29 | 00:17:01 | 1 | 01:04:26
8911 | 68541 | [NAME] | Kolomkin | RUS | 258 | 00:16:13 | 00:00:38 | 00:34:20 | 00:02:04 | 00:17:05 | 2 | 01:10:21
Spreadsheet: 55685d1255831867-taking-info-from-repeating-tables-example-10001-
Sheet: Sheet2

[NAME] | Smith | 11.44209433288392 | 7.666256938634852 | 26.22608620886371 | 3.59420140053528
Jake | [NAME] | 10.95731032822567 | 49.6985871714009 | 37.98392181580883 | 62.8737744658459
[NAME] | Jones | 99.6620485458111 | 83.43127271647957 | 6.867777096099736 | 0.2520448632950867
[NAME] | [NAME] | 60.77577632641164 | 37.98387568234665 | 84.90426420944763 | 97.13999125767452
[NAME] | [NAME] | 30.4367029266386 | 16.52675939343515 | 32.59453733226194 | 20.52679701422946
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 | 0 | 0 | 0 | 0
Spreadsheet: 6e9f65c9-a49f-463f-835c-deb8f9ab40aa
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5026 | 14475 | Lance [NAME] | Chapman | RSA | 0 | 00:22:44 | 00:00:00 | 01:08:23 | 00:00:00 | 00:34:21 | 1 | 02:05:29
5026 | 30804 | [NAME] | [NAME] | RSA | 0 | 00:20:26 | 00:00:00 | 01:07:49 | 00:00:00 | 00:38:43 | 2 | 02:07:00
5026 | 30129 | [NAME] | [NAME] | RSA | 0 | 00:25:49 | 00:00:00 | 01:13:43 | 00:00:00 | 00:43:27 | 3 | 02:22:59
5026 | 30814 | Morne | Vorster | RSA | 0 | 00:31:42 | 00:00:00 | 01:14:16 | 00:00:00 | 00:40:29 | 4 | 02:26:29
Spreadsheet: 883560d1732184050-xlookup-vlookup-question
Sheet: Sheet1

 | VLOOKUP Formula :
 | Column A  is downloaded from another source and VLOOKUP formula used will not work.
 | The formula works by double-clicking each dashed date and pressing enter, but this is cumbersome.
 | I'd prefer to keep the downloaded dashed date format as is, since there are many downloaded dates.
 | Can one amend the VLOOKUP formula to accept date format 2023-12-29(-dashes)?
 | Thank you for your assistance with this.
 | 2023-12-29 | 19268.43 | 2023-12-29 00:00:00
 | 2024-01-02 | 18934.11 | 2023-12-29 00:00:00
 | 2024-01-03 | 18870.12 | 2024-04-02 00:00:00
 | 2024-01-04 | 18886.82 | 2024-04-02 00:00:00
 | 2024-04-02 | 18813.99 | 2024-10-01 00:00:00
 | 2024-09-27 | 22945.13 | 2024-10-02 00:00:00
 | 2024-09-30 | 22711.23 | 2024-11-04 00:00:00
 | 2024-10-01 00:00:00 | 22546.87
 | 2024-10-02 | 22595.94
 | 2024-11-04 00:00:00 | 22254.09
 | 2024-11-05 | 22278.71
Spreadsheet: 781973d1653661171-date-time-group-dtg-formulas-3-dtg-formulas
Sheet: DTG #1 Decimal Seconds

 |  |  | Start Time | End Time | Formula #1 Time Transpired (In Minutes) | Formula #2 Time Transpired (In Minutes) | Formula #3 Time Transpired (In Minutes) | Time Greater Than 60 min? | Duration in Hours & Minutes
JAN | 1 |  | 170340Z Mar21 | 170359Z Mar21 |  |  |  |  |  |  | START Time |  |  |  | END Time
FEB | 2 |  | 170340.2Z Mar21 | 170359.6Z Mar22 |  |  |  |  |  |  | DDhhmm.s MMMYY |  |  |  | DDhhmm.s | MMM YR
MAR | 3 |  |  |  |  |  |  |  |  |  | 012345.3 APR 22 |  |  |  | 100130.2 APR 22
APR | 4 |  | 170340Z Apr22 | 010359Z May22
MAY | 5 |  | 170340.2Z Mar24 | 010359.2Z May23 |  |  |  |  |  |  | =UPPER(TEXT($I$4&$J$4*24,"dd hhmmZ mmm yy")) |  |  |  | =UPPER(TEXT($M$4&$N$4*24,"ddhhmmZ mmm yy"))
JUN | 6 |  |  |  |  |  |  |  |  |  | =TEXT($I$4&$J$4*24,"dd hhmmZ mmm yy") |  |  |  | =TEXT($M$4&$N$4*24,"ddhhmmZ mmm yy")
JUL | 7
AUG | 8 |  |  |  |  |  |  |  |  |  | =DATE(RIGHT(I4,2),VLOOKUP(LEFT(J4,3),{"Jan",1;"Feb",2;"Mar",3;"Apr",4;"May",5;"Jun",6;"Jul",7;"Aug",8;"Sep",9;"Oct",10;"Nov",11;"Dec",12},2,0),LEFT(I4,2))+TEXT(RIGHT(I4,4),"00\:00")
SEP | 9
OCT | 10
NOV | 11
DEC | 12
Spreadsheet: mike_carson__27662__BrokerQuote(SouthEast)
Sheet: Sheet1

Broker | Prebon
Date | 2002-01-25 00:00:00
Time | 12.00PM |  |  |  | Please time stamp the quote sheet before sending back
ONPEAK |  |  |  |  |  |  |  | [NAME]
PRICE | SOUTHEAST |  |  |  |  |  |  | PRICE | SOUTHEAST
 | SOCO |  | Entergy |  |  |  |  |  | SOCO |  | Entergy
 | Bid | Offer | Bid | Offer |  |  |  |  | Bid | Offer | Bid | Offer
Dailies | 20.5 | 21.5 | 17.75 | 18.25 |  |  |  | Dailies
Next Week | 20.75 | 21.5 | 18.25 | 19.5 |  |  |  | Next Week
[NAME] | 20.75 | 21.5 | 18.25 | 19.5 |  |  |  | [NAME]
2002-02-02 00:00:00 | 23 | 23.5 | 18.25 | 18.4 |  |  |  | 2002-02-02 00:00:00
M/A 02 | 21.55 | 22.3 | 19.3 | 19.6 |  |  |  | M/A 02
2002-05-01 00:00:00 | 24.75 | 25.25 | 22.8 | 23 |  |  |  | 2002-05-01 00:00:00
2002-06-01 00:00:00 | 29.75 | 30.5 | 26.25 | 27 |  |  |  | 2002-06-01 00:00:00
Sum 02 | 38.4 | 38.9 | 33.25 | 34 |  |  |  | Sum 02
2002-09-01 00:00:00 | 23 | 23.75 | 21.35 | 21.7 |  |  |  | 2002-09-01 00:00:00
Q4 02 | 22.9 | 23.4 | 21.3 | 21.75 |  |  |  | Q4 02
Bal CAL-02 | 26.25 | 26.9 | 23.4 | 23.9 |  |  |  | CAL-02
W 03 | 26.25 | 26.75 | 24 | 24.5 |  |  |  | W 03
M/A 03 | 25 | 25.75 | 22.75 | 23.25 |  |  |  | M/A 03
2003-05-01 00:00:00 | 26.75 | 27.5 | 24.5 | 25.25 |  |  |  | 2003-05-01 00:00:00
2003-06-01 00:00:00 | 32.5 | 33.25 | 29.5 | 30.25 |  |  |  | 2003-06-01 00:00:00
Sum 03 | 40.25 | 40.75 | 34.75 | 35 |  |  |  | Sum 03
2003-09-01 00:00:00 | 24.75 | 25.5 | 23 | 23.75 |  |  |  | 2003-09-01 00:00:00
Q4 03 | 25.25 | 26 | 24 | 24.5 |  |  |  | Q4 03
CAL-03 | 28.5 | 29.25 | 26 | 26.5 |  |  |  | CAL-03
[NAME] | 30 | 31 | 27 | 27.75 |  |  |  | [NAME]
Cal-05 | 30.75 | 32 | 28.75 | 29.75 |  |  |  | Cal-05
Cal-06 | 31 | 32.25 | - | - |  |  |  | Cal-06
Cal-07-10 | - | - | - | - |  |  |  | Cal-04-06 | 21.5 | 22.5
Spreadsheet: richard_ring__31658__BECO Account Numbers
Sheet: EESONStarconv

Customer | [NAME] | [NAME]
GENE | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
GSA | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
DORC | [PHONE] | [PHONE]
BOST | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
NATL | [PHONE] | [PHONE]
AFRI | [PHONE] | [PHONE]
NATL | [PHONE] | [PHONE]
BOST | [PHONE] | [PHONE]
BOST | [PHONE] | [PHONE]
NATL | [PHONE] | [PHONE]
NATL | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
NATL | [PHONE] | [PHONE]
NATL | [PHONE] | [PHONE]
NATL | [PHONE] | [PHONE]
BOST | [PHONE] | [PHONE]
NATL | [PHONE] | [PHONE]
BOST | [PHONE] | [PHONE]
BOST | [PHONE] | [PHONE]
NATL | [PHONE] | [PHONE]
NATL | [PHONE] | [PHONE]
NATL | [PHONE] | [PHONE]
NATL | [PHONE] | [PHONE]
NATL | [PHONE] | [PHONE]
BOS | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
[NAME] | [PHONE] | [PHONE]
US A | [PHONE] | [PHONE]
MAGU | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
[NAME] | [PHONE] | [PHONE]
USAF | [PHONE] | [PHONE]
US A | [PHONE] | [PHONE]
[NAME] | [PHONE] | [PHONE]
[NAME] | [PHONE] | [PHONE]
USAF | [PHONE] | [PHONE]
[NAME] | [PHONE] | [PHONE]
AIR | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
VET | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]
VA M | [PHONE] | [PHONE]
VA M | [PHONE] | [PHONE]
US G | [PHONE] | [PHONE]