tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 726735d1617390874-convert-text-days-hours-minutes-to-total-hours-019-get-day-hour-minute-second-from-text
Sheet: Get HMS (3)

3. Multipy with {1,"1:0","0:1","0:0:1"} and sum up |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | i |  |  | ard
3. คูณด้วย {1,"1:0","0:1","0:0:1"} แล้วรวมผล
Data | D | H | M | Se | Combine | Press F2 F9 | Final | [h]:mm:ss
2 Days 2 Hours 3 Minutes 40 Seconds |  |  |  |  |  | ={"2","2","3","40"}
1 Day 20 Hours 5 Minutes |  |  |  |  |  | ={"1","20","5","0"}
1 Hour 5 Minutes |  |  |  |  |  | ={"0","1","5","0"}
10 hours 1 seconds |  |  |  |  |  | ={"0","10","0","1"}
25 Minutes 50 seconds |  |  |  |  |  | ={"0","0","25","50"}
2 Days 5 seconds |  |  |  |  |  | ={"2","0","0","5"}
10 Days |  |  |  |  |  | ={"10","0","0","0"}
 | F5 =TEXT(MID(0&A5,SEARCH({"D","H","M","Se"},0&A5&"dhmse")-3,2),"0;;;\0")
 | Combine formula from B5:E5 to single formula with constant array {"D","H","M","Se"}
 | รวมสูตรจาก B5:E5 ให้เหลือสูตรเดียวโดยใช้ ค่าคงที่แบบArray  {"D","H","M","Se"}
 | Select cell F5 and Press F2 F9 to see array value
 | เลือกเซล F2 กด F2 F9 เพื่อดูค่าแบบ Array
 |  | H5 =SUM(TEXT(MID(0&$A5,SEARCH({"D","H","M","Se"},0&$A5&"dhmse")-3,2),"0;;;\0")*{1,"1:0","0:1","0:0:1"})
 |  | Multily number by {1,"1:0","0:1","0:0:1"} for 1 Day, "1:0" Hour,  "0:1"Minute "0:0:1" second and sum up
 |  | เอาเลขที่ได้มาคูณ {1,"1:0","0:1","0:0:1"} สำหรับ 1 วัน, "1:0" ชั่วโมง,  "0:1" นาที "0:0:1" วินาที แล้วรวมค่าด้วย Sum
 |  | [NAME] to [h]:mm:ss for display result
 |  | [NAME] to [h]:mm:ss เพื่อแสดงผล
Spreadsheet: 275499d1383552193-if-function-with-criteria-vlookup
Sheet: Sheet1

Order ID #(DUPLICATE) | Order Amount | UNIQUE OrderID SUBTOTAL | Order amount < $50,000 | Order Amount between $10,000 & $50,000
235611 | 1625
240425 | 11572.72
242686 | 4290
242686 | 12285
242686 | 14742
242686 | 5733
242686 | 257.4
242686 | 384.8
242686 | 6054.75
242686 | 6054.75
242686 | 8073
242686 | 11466
242709 | 35400 |  | 1
242709 | 5400
242894 | 228
244543 | 6531.47 |  | 1
244543 | 6116.86
244563 | 13062.94
Spreadsheet: 05ecbfff-b244-4bb0-b065-6b3390f3a977
Sheet: Sheet1

2014 CIF SOUTHERN SECTION FORD BASEBALL CHAMPIONSHIPS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
FIRST ROUND |  | SECOND ROUND | QUARTERFINALS | SEMIFINALS | FINALS
FRI., MAY 23 |  | TUES., MAY 27 | FRI., MAY 30 | BLAIR FIELD | DODGER STADIUM
 |  |  | OUTFIELD FENCE | TUES., JUNE 3 | FRI., JUNE 6
 |  |  |  | 4:00 or 7:00P.M | 8:00 P.M.
* JSerra | Trinity #1
 |  | *JSerra
[NAME] | Century #4 | 4-3
* [NAME]/V | Foothill #2 | F | JSerra |  | DIVISION 1
 |  | [NAME]/V | 6-5 | REPORT SCORES: www.cifsshome.org (Home Campus/Team Tab)
Thousand Oaks | Marmonte #3 | 11-2 |  | IMMEDIATELY AFTER COMPLETION OF CONTEST
* Millikan | Moore #1 |  |  | JSerra
 |  | *Edison |  | 2-0
Edison | Sunset #3 | 4-2
*Harvard-Westlake | Mission #2 |  | *Edison
 |  | Harvard-Westlake | 3-1
[NAME] | Inland Valley #2 | 5-0
* [NAME] | Sunset #2 |  |  | F | *Foothill
 |  | *[NAME] |  | 4:00 pm | 4-1
Santiago/Corona | Big VIII #2 | 10-1
* Foothill | Century #1 | F | *Foothill
 |  | Foothill | 1-0
Chaminade | Mission #4 | 6-1
*Capistrano Valley | South Coast #1 |  |  | *Foothill
 |  | Capistrano Valley |  | 6-2
[NAME] | Trinity At-Large | 4-1
* Agoura | Marmonte #1 | F | Agoura
12:00 noon |  | *Agoura | 6-0
Crespi | Mission At Large | 2-0
*Fountain Valley | Sunset #1
 |  | Fountain Valley |  | F |  | Santa Margarita
Lakewood | Moore #4 | 9-1 |  |  |  | 3-1
*Santa Margarita | Trinity #2 | F | *Santa Margarita
 |  | *Santa Margarita | 8-7
Mission Viejo | South Coast #2 | 9-2
* Poly/Riverside | Inland Valley #1 |  | F | Santa Margarita
 |  | Poly/Riverside |  | 6-2
Alemany | Mission #3 | 7-3
* Norco | Big VIII #1 | F | Norco
 |  | *Norco | 12-9
Canyon/A | Century #3 | 15-5
* Hart | Foothill #1 |  |  |  | Santa Margarita
 |  | *Orange Lutheran |  | 7:00 pm | 3-0
Orange Lutheran | Trinity #3 | 7-2
* Wilson/LB | Moore #2 | Hart Park @ 7:00 pm | Orange Lutheran
 |  | Wilson/LB | 7-2
Moorpark | Marmonte #2 | 5-4
* Esperanza | Century #2
 |  | *[NAME] | F | *[NAME]
[NAME] | South Coast #3 | 6-2 |  | 3-2
*Loyola | Mission #1 |  | *[NAME]
 |  | Loyola | 5-4
Corona | Big VIII #3 | 4-1
*Denotes Host Team
This draw sheet was made based upon information available to the CIF-SS as of 5-17-14.  We reserve the right to adjust the draw sheet as a result of information which would
update any final league standings.  All games are scheduled to start at 3:15 p.m. unless another time is mutually agreed upon and clearance received from the CIF-SS Office.
Public coin flips will be held in the CIF-SS lobby according to the following schedule: Second Round - May 23 - 9:00 a.m. ([NAME]. 2, 4, 6) May 24th - 9:00 a.m.(Div. 1, 3, 5, 7), Quarterfinals  -
May 28th -10:00 a.m., Semifinals - May 31st -9:00 a.m., Finals - June 4th - 10:00 a.m. PLEASE CALL SCORES IN TO THE CIF-SS OFFICE (562) 493-9500, AND TO THE SPORTS
DESKS OFTHE LOS ANGELES TIMES (213) 237-7151 or [PHONE] EXT. 77151, THE REGISTER (714) 796-7804, KNBC (818) 840-4237, THE DAILY NEWS at1-[PHONE],
and MAX PREPS at (800) 329-7324. Draw results available on our web site www.cifss.org
2014 |  |  |  |  | BASEBALL DIV. 1
Spreadsheet: 112101d1308248831-dynamic-chart-not-updating-automatically-example_charting3
Sheet: Summary_Indexing

Month | Numbe pages | Target | TAT%
2010-04-01 00:00:00 | 29897 | 0.95
2010-05-01 00:00:00 | 35192 | 0.95 | 0.9721546961325966 |  |  |  |  |  |  |  |  |  |  | chrtindex |  | INDEX(Summary_Indexing!$A:$A, MATCH(9E+307, Summary_Indexing!$A:$A)):INDEX(Summary_Indexing!$E:$E, MATCH(9E+307, [NAME])
2010-06-01 00:00:00 | 35365 | 0.95 | 0.98
2010-07-01 00:00:00 | 28803 | 0.95 | 0.98 |  |  |  |  |  |  |  |  |  |  | [NAME] |  | INDEX(Summary_Indexing!chrtindex,0,2)
2010-08-01 00:00:00 | 28013 | 0.95 | 0.98
2010-09-01 00:00:00 | 27343 | 0.95 | 0.97 |  |  |  |  |  |  |  |  |  |  | tblindex3 |  | INDEX(Summary_Indexing!chrtindex, 0, 3)
2010-10-01 00:00:00 | 30088 | 0.95 | 0.97
2010-11-01 00:00:00 | 28295 | 0.95 | 0.97 |  |  |  |  |  |  |  |  |  |  | tblindex4 |  | INDEX(Summary_Indexing!chrtindex,0,4)
2010-12-01 00:00:00 | 32194 | 0.95 | 0.95
2011-01-01 00:00:00 | 31690 | 0.95 | 0.98 |  |  |  |  |  |  |  |  |  |  | tblindexMonth |  | INDEX(Summary_Indexing!chrtindex,0,1)
2011-02-01 00:00:00 | 28039 | 0.95 | 0.98
2011-03-01 00:00:00 | 33277 | 0.95 | 0.92
2011-04-01 00:00:00 | 31114 | 0.95 | 0.9788198238734974
2011-04-01 00:00:00 | 30455 | 0.95 | 0.9788198238734974
2011-05-01 00:00:00 | 15 | 0.15 | 0.84
2011-06-01 00:00:00 | 30455 | 0.15 | 0.84
2011-07-01 00:00:00 | 30455 | 0.15 | 0.84
2011-05-01 00:00:00
 |  |  |  |  | 1 | SERIES(Summary_Indexing!$B$1,Summary_Indexing!tblindexMonth,Summary_Indexing!tblindex2,1)
 |  |  |  |  | 2 | SERIES(Summary_Indexing!$c$1,Summary_Indexing!tblindexMonth,Summary_Indexing!tblindex3,2)
 |  |  |  |  | 3 | SERIES(Summary_Indexing!$c$1,Summary_Indexing!tblindexMonth,Summary_Indexing!tblindex4,3)
Spreadsheet: kevin_presto__19959__MarketPowerNE020211
Sheet: Sheet1

Assume 1000Mwe base load
 |  | $/Mw | $/MWhr
 | Year | Capacity ($/Mw) | Energy ($/Mwhr) | Ancilary Service | Comments
1 | 2003 | 1.5 | 32 | 500000 | Flat fee from ISO no market yet developed
 |  | 1.45 | 30
 |  | 1.5 | 31
 |  | 1.6 | 32
 |  | 1.65 | 33 |  | Market developed
 |  | 1.65 | 35
 |  | 1.7 | 36
 |  | 1.8 | 37
 |  | 1.9 | 38
 |  | 2 | 39
 |  | 2.1 | 40
 | Escalation after 2013 | 0.02 | 0.03 | 0.015
Spreadsheet: 070592c9-0398-4b72-aa4d-9da58642a5a8
Sheet: Sheet1

COLLEGE FOR ALL TEXANS FOUNDATION
ITEMIZATION OF TRAVEL EXPENSES FOR REIMBURSEMENT
Name: |  |  |  | Dates of Travel:
Address to send reimbursement*: |  |  |  |  |  |  |  |  |  | YES
Phone: |  |  |  | [NAME]: |  |  |  |  |  | NO
Destination: |  |  |  | Purpose:
Departure Date: |  |  |  | Return Date: |  |  |  |  |  | HOME
TRANSPORTATION |  |  |  |  |  |  |  |  |  | WORK
 |  |  |  |  |  | Subtotal by Category: |  |  |  | AIRPORT
Rental Car (Receipts Required): DD |  |  |  | Amount: |  |  |  |  |  | HOTEL
Airline (Receipts Required): DD |  |  |  | Amount: |  |  |  |  |  | MTG SITE
Personal Car: (Please include Mapquest documentation, only one airport round trip mileage allowed)
From: DD |  | To:  DD |  | [NAME]: |  | x $0.5/mi:
From: DD |  | To:  DD |  | [NAME]: |  | x $0.5/mi:
From: DD |  | To:  DD |  | [NAME]: |  | x $0.5/mi:
From: DD |  | To:  DD |  | [NAME]: |  | x $0.5/mi:
Taxi/Shuttle: (Receipts Required)
From: DD |  | To:  DD |  | Amount:
From: DD |  | To:  DD |  | Amount:
From: DD |  | To:  DD |  | Amount:
From: DD |  | To:  DD |  | Amount:
Meals: (Receipts Required; Maximum $36 per day; alcoholic beverages exluded from reimbursement)
Date: |  |  | Claiming:
Date: |  |  | Claiming:
Date: |  |  | Claiming:
Date: |  |  | Claiming:
Date: |  |  | Claiming:
Lodging:  (Receipts Required; Maximum $129 per night, including City/State taxes)
Date: |  |  | Claiming:
Date: |  |  | Claiming:
[NAME] TRAVEL EXPENSES
Parking:  (Receipts Required)
Location: |  |  |  | Claiming:
Location: |  |  |  | Claiming:
Location: |  |  |  | Claiming:
Telephone Calls:  (Business Only) |  |  |  | Claiming:
Gasoline for Rental Car:  (Receipts Required) |  |  |  | Claiming:
Toll Charges:  (Receipts Required) |  |  |  | Claiming:
 |  |  |  |  | Total Amount Claimed:
*Reimbursement will be issued from the College for All Texans Foundation
For reimbursement, please return completed form and receipts within 10 business days of travel to:
[NAME]
Academic Planning and Policy
Texas Higher Education Coordinating Board
P.O. Box 12788, [NAME], TX  78711
[NAME]:  [EMAIL]
Spreadsheet: 817598d1676348286-make-a-cell-red-on-sheet1-based-on-dates-that-are-in-the-current-month-in-a-list-on-sheet2-communication-and-meeting-matrix
Sheet: Sheet2

 | Item | About | When | hMIF
 | Review Section 1,2 and 3 and Appendix 1, 2, 3 of CPM | "H:\Clinical Practice Manual\Working Documents\Section 1" | 2024-02-01 00:00:00
 |  | "H:\Clinical Practice Manual\Working Documents\Section 2" | 2024-02-13 00:00:00
 |  | "H:\Clinical Practice Manual\Working Documents\Section 3"
 | Review Section 5 and Appendix 5 of CPM | "H:\Clinical Practice Manual\Working Documents\Section 5" | 2023-03-01 00:00:00
 | Review Section 6 and Appendix 6 of CPM | "H:\Clinical Practice Manual\Working Documents\Section 6" | 2023-04-01 00:00:00
 | Review Section 7 and Appendix 7 of CPM | "H:\Clinical Practice Manual\Working Documents\Section 7" | 2023-05-01 00:00:00
 | Review Section 8+17 and Appendix 8+17 of CPM | "H:\Clinical Practice Manual\Working Documents\Section 8" | 2023-06-01 00:00:00
 |  | H:\Clinical Practice Manual\Working Documents\Section 17
 | Review Section 9 and Appendix 9 of CPM | "H:\Clinical Practice Manual\Working Documents\Section 9" | 2023-07-01 00:00:00
 | Review Section 10 and Appendix 10 of CPM | "H:\Clinical Practice Manual\Working Documents\Section 10" | 2023-08-01 00:00:00
 | Review Section 14+13 and [NAME] 14+13 of CPM | "H:\Clinical Practice Manual\Working Documents\Section 14" | 2023-09-01 00:00:00
 |  | "H:\Clinical Practice Manual\Working Documents\Section 13"
 | Review Section 14+13 and [NAME] 14+13 of CPM
Spreadsheet: 48570d1247798306-formula-to-check-expirations-check-zips
Sheet: Sheet1

Name | Zip Code | Ext. | Start Date | Exp. Date | Today | Available?
[NAME] | 45662 | 6041 | 2009-04-01 00:00:00
[NAME] 1 | 45668 | 6045 | 2009-04-08 00:00:00 |  |  |  |  | [NAME] | Available? | Next Available
Victory Bell 1 | 45674 | 6049 | 2009-04-15 00:00:00 |  |  |  |  | 45662
[NAME] 2 | 45680 | 6053 | 2009-04-22 00:00:00
[NAME] 2 | 45686 | 6057 | 2009-04-29 00:00:00
Victory Bell 2 | 45692 | 6061 | 2009-05-06 00:00:00
[NAME] 3 | 45698 | 6065 | 2009-05-13 00:00:00
[NAME] 3 | 45704 | 6069 | 2009-05-20 00:00:00
Victory Bell 3 | 45710 | 6073 | 2009-05-27 00:00:00
[NAME] 4 | 45716 | 6077 | 2009-06-03 00:00:00
[NAME] 4 | 45722 | 6081 | 2009-06-10 00:00:00
Victory Bell 4 | 45728 | 6085 | 2009-06-17 00:00:00
[NAME] 5 | 45734 | 6089 | 2009-06-24 00:00:00
[NAME] 5 | 45740 | 6093 | 2009-07-01 00:00:00
Victory Bell 5 | 45746 | 6097 | 2009-07-08 00:00:00
[NAME] 6 | 45752 | 6101 | 2009-07-15 00:00:00
[NAME] 6 | 45758 | 6105 | 2009-07-22 00:00:00
Victory Bell 6 | 45764 | 6109 | 2009-07-29 00:00:00
[NAME] 7 | 45770 | 6113 | 2009-08-05 00:00:00
[NAME] 7 | 45776 | 6117 | 2010-01-27 00:00:00
Victory Bell 7 | 45782 | 6121 | 2010-02-03 00:00:00
[NAME] 8 | 45788 | 6125 | 2010-02-10 00:00:00
[NAME] 8 | 45794 | 6129 | 2010-02-17 00:00:00
Victory Bell 8 | 45800 | 6133 | 2010-02-24 00:00:00
[NAME] 9 | 45806 | 6137 | 2010-03-03 00:00:00
[NAME] 9 | 45812 | 6141 | 2010-03-10 00:00:00
Victory Bell 9 | 45818 | 6145 | 2010-03-17 00:00:00
[NAME] 10 | 45824 | 6149 | 2010-03-24 00:00:00
[NAME] 10 | 45830 | 6153 | 2010-03-31 00:00:00
Victory Bell 10 | 45836 | 6157 | 2010-04-07 00:00:00
[NAME] 11 | 45842 | 6161 | 2010-04-14 00:00:00
[NAME] 11 | 45848 | 6165 | 2010-04-21 00:00:00
Victory Bell 11 | 45854 | 6169 | 2010-04-28 00:00:00
[NAME] 12 | 45860 | 6173 | 2010-05-05 00:00:00
[NAME] 12 | 45866 | 6177 | 2010-05-12 00:00:00
Victory Bell 12 | 45872 | 6181 | 2010-05-19 00:00:00
[NAME] 13 | 45878 | 6185 | 2010-05-26 00:00:00
[NAME] 13 | 45884 | 6189 | 2010-06-02 00:00:00
Victory Bell 13 | 45890 | 6193 | 2010-06-09 00:00:00
[NAME] 14 | 45896 | 6197 | 2010-06-16 00:00:00
[NAME] 14 | 45902 | 6201 | 2010-06-23 00:00:00
Victory Bell 14 | 45908 | 6205 | 2010-06-30 00:00:00
[NAME] 15 | 45914 | 6209 | 2010-07-07 00:00:00
[NAME] 15 | 45920 | 6213 | 2010-07-14 00:00:00
Victory Bell 15 | 45926 | 6217 | 2010-07-21 00:00:00
Spreadsheet: 47934d1247113935-removing-borders-for-printing-borders
Sheet: Borders

 | Table 1
 | Text | Text | Text
 | Text | Text | Text
 | Text | Text | Text
 | Table 2
 | Text | Text | Text
 | Text | Text | Text
 | Text | Text | Text
Spreadsheet: 677373d1589319627-filter-and-total-676715d1588945431-pivot-table-help
Sheet: Sheet1

 |  |  |  | I want a formua to to find all the 38 FROM the pivot table and return the whole cell text (at the moment it manual filter and paste) | I want a formua to to find THE TOTAL OF EACH CATORGY (at the moment it manual filter and paste)
DATE
NAME | AMOUNT |  |  | CATORGERY | AMOUNT
38 TV | 10
38 WATER | 20
38 BORADBAND | 30
38 TV | 50
38 WATER | 10
04 TV | 5
04 WATER | 6
04 BORADBAND | 7
04 TV | 5
04 WATER | 3
Spreadsheet: 875481d1722040811-formula-to-select-random-names-but-need-to-have-some-changes-in-formula-auto-lottery-fill-form
Sheet: Sheet1

ID # | Name |  | Results |  | Number of Winners | 29
1 | [NAME] |  |  |  | Min Value | 1
2 | Becca |  |  |  | [NAME] | 82
3 | Jake |  |  |  | Start Sequence Cell # | A2
4 | [NAME] |  |  |  | End Sequence Cell # | A83
5 | [NAME] |  |  |  | Start Sequence Name (Cell) | B2
6 | [NAME] |  |  |  | End Sequence Name (Cell) | B83
7 | Buddy
8 | Jake
9 | [NAME]
10 | Jazmine
11 | Simba
12 | Duke
13 | Sony
14 | Panasonic
15 | [NAME]
16 | Spenc
17 | Doogie
18 | [NAME]
19 | [NAME]
20 | Dominik
21 | [NAME]
22 | [NAME]
23 | [NAME]
24 | [NAME]
25 | [NAME]
26 | Justin L
27 | [NAME]
28 | [NAME]
29 | [NAME]
30 | [NAME]
31 | Big John
32 | Big Al
33 | Big Apple
34 | New York
35 | Idaho
36 | Utah
37 | Zion
38 | [NAME]
39 | JJ
40 | meranda
41 | jake
42 | [NAME]
43 | [NAME]
44 | nipm tuck
45 | [NAME]
46 | Toss salad
47 | Academic
48 | Schedule
49 | [NAME]
50 | [NAME]
51 | [NAME]
52 | Brad 1
53 | [NAME]
54 | [NAME]
55 | [NAME]
56 | Thor
57 | Iron Man
58 | Optoma
59 | West Hall
60 | Chief [NAME]
61 | Amanda
62 | She's The Man
63 | Channing
64 | [NAME]
65 | [NAME]
66 | DI Imaging 1
67 | DI Imaging 2
68 | Geriatrics
69 | Pediatrics
70 | Melanoma
71 | Carcinoma
72 | [NAME]
73 | That 70's Show
74 | Gray'ds Anatomy
75 | [NAME]
76 | [NAME]
77 | [NAME]
78 | Happy Dwarf
79 | King Neptune
80 | Super man
81 | Spiderman
82 | [NAME]
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Spreadsheet: 848976d1699556001-unsure-of-how-to-fix-formula-to-resolve-issue-example-database-problem
Sheet: Sheet1

This is 3 Data Columns (Type+Expiry = 1) my sheet im working on currently has over 50 columns heading to the right.
1 |  | 2 |  | 3
Veh Type:  A | Expires after  1 Year | Veh Type:  B | Expires after  1 Year | Veh Type:  C | Expires after  1 Year | Retest
 |  |  |  |  |  |  |  | <- With no Information added it will Return "Veh A" all the time.
 |  |  |  |  |  |  |  | How do I get it so when the are "N/A"s present, they are skipped in the formula, and have the Retest Column show "No" instead of "Veh A"
Veh Type:  A | Expires after  1 Year | Veh Type:  B | Expires after  1 Year | Veh Type:  C | Expires after  1 Year | Retest
2023-11-01 00:00:00 |  |  |  | 2020-01-01 00:00:00 |  |  |  | <- With data, it doesn't skip the "N/A" and Returns "Veh B" not "Veh C"
Veh Type:  A | Expires after  1 Year | Veh Type:  B | Expires after  1 Year | Veh Type:  C | Expires after  1 Year | Retest
2023-11-01 00:00:00 |  | 2022-12-09 00:00:00 |  | 2020-01-01 00:00:00 |  |  |  | <- If dates are in all columns it returns the correct colum. (1st true instance)
Veh Type:  A | Expires after  1 Year | Veh Type:  B | Expires after  1 Year | Veh Type:  C | Expires after  1 Year | Retest
2003-11-09 00:00:00 |  | 2020-12-09 00:00:00 |  | 2020-01-01 00:00:00 |  |  |  | 1st True instance is "Veh A" with all Data in.
Veh Type:  A | Expires after  1 Year | Veh Type:  B | Expires after  1 Year | Veh Type:  C | Expires after  1 Year | Retest
 |  | 2020-12-09 00:00:00 |  | 2020-01-01 00:00:00 |  |  |  | <- What I want it to Return in this instance is "Veh C" as it is OoD for longer.
Veh Type:  A | Expires after  1 Year | Veh Type:  B | Expires after  1 Year | Veh Type:  C | Expires after  1 Year | Retest |  | This is how I want it to work
 |  |  |  |  |  | No | <No formula in this example
Veh Type:  A | Expires after  1 Year | Veh Type:  B | Expires after  1 Year | Veh Type:  C | Expires after  1 Year | Retest
 |  | 2021-11-10 00:00:00 |  | 2022-11-10 00:00:00 |  | Veh B | <No formula in this example
Veh Type:  A | Expires after  1 Year | Veh Type:  B | Expires after  1 Year | Veh Type:  C | Expires after  1 Year | Retest |  | "Veh B" is 1st True instance as you read left to right, but "Veh C" was 1st True instance of going OoD
 |  | 2021-11-10 00:00:00 |  | 2020-10-15 00:00:00 |  | Veh C | <No formula in this example
Spreadsheet: 82021d1282088613-creating-a-summary-worksheet-with-all-data-from-all-sheets-summary-sheet-example
Sheet: A

Sheet A
Date | 2010-08-17 00:00:00
car | 2 | 235 | 61 | 305 | 106
tree | 152 | 157 | 251 | 238 | 260
dog | 71 | 216 | 35 | 98 | 76
fish | 315 | 112 | 157 | 96 | 38
Spreadsheet: 187482d1350471908-link-group-2-cells-so-they-move-together-within-an-evolving-spreadsheet-is-this-possible-example
Sheet: P Orders

cn_ref | cn_cost | cn_instock | cn_onorder | cn_saleord | do_dcref | do_account | do_cnref | do_desc | do_reqqty | do_recqty | do_price | pn_account | pn_name | cn_ref | do_cmpltd | do_currcy
ACQUA-1196270 | 2924 | 0 | 17177 | 65000 | [NAME] | AUNIQUE | ACQUA-1196270 | ACQUA DI GIOIA EDP SPRAY 100ML A2OCT | 14400 | 0 | 2777 | AUNIQUE | UNIQUE COSMETICS | ACQUA-1196270 | 0
ACQUA-1196270 | 2924 | 0 | 17177 | 65000 | [NAME] | AUNIQUE | ACQUA-1196270 | ACQUA DI GIOIA EDP SPRAY 100ML A2SEP | 2777 | 0 | 14400 | AUNIQUE | UNIQUE COSMETICS | ACQUA-1196270 | 0
ACQUA-172587 | 2056 | 0 | 4800 | 4700 | [NAME] | AUNIQUE | ACQUA-172587 | ACQUA DI GIOIA EDP SPRAY 50ML A2OCT | 2400 | 0 | 2400 | AUNIQUE | UNIQUE COSMETICS | ACQUA-172587 | 0
ACQUA-172587 | 2056 | 0 | 4800 | 4700 | [NAME] | AUNIQUE | ACQUA-172587 | ACQUA DI GIOIA EDP SPRAY 50ML A2SEP | 2400 | 0 | 2401 | AUNIQUE | UNIQUE COSMETICS | ACQUA-172587 | 0
ACQUA-205886 | 2507 | 9600 | 72000 | 95200 | [NAME] | AUNIQUE | ACQUA-205886 | ACQUA GIO HOMME EDT SPRAY 50ML A2OCT | 36000 | 0 | 2089 | AUNIQUE | UNIQUE COSMETICS | ACQUA-205886 | 0
ACQUA-205886 | 2507 | 9600 | 72000 | 95200 | [NAME] | AUNIQUE | ACQUA-205886 | ACQUA GIO HOMME EDT SPRAY 50ML A2SEP | 36000 | 0 | 2089 | AUNIQUE | UNIQUE COSMETICS | ACQUA-205886 | 0
ACQUA-205887 | 3333 | 0 | 96000 | 94500 | [NAME] | AUNIQUE | ACQUA-205887 | ACQUA GIO HOMME EDT SPRAY 100ML A2OCT | 48000 | 0 | 2778 | AUNIQUE | UNIQUE COSMETICS | ACQUA-205887 | 0
ACQUA-205887 | 3333 | 0 | 96000 | 94500 | [NAME] | AUNIQUE | ACQUA-205887 | ACQUA GIO HOMME EDT SPRAY 100ML A2SEP | 48000 | 0 | 2778 | AUNIQUE | UNIQUE COSMETICS | ACQUA-205887 | 0
Spreadsheet: 856645d1705852821-drop-down-selection-to-to-subtract-from-a-number-in-a-cell-fire-risk-assessment-template-04-01-2024
Sheet: Sheet1

FIRE RISK ASSESSMENT OUTSTANDING REMEDIAL ACTIONS
HSE SPECIALIST: |  | STATION: |  |  | LOCATION ID: |  | REMEDIAL ACTION COMPLETED | EVIDENCE UPLOADED / EMAILED
OUTSTANDING REMEDIAL ACTIONS RISK RATING | REMEDIAL ACTIONS TOTAL: | 2 | Very High (Action Require Within 7 Days) | High (Action Required Within 28 Days) |  | 0
 |  | 0 | Normal (Action Required Within 12 Weeks) | Low (Action Required Within 26 Weeks) |  | 0
Date Assessed: |  | Fire Risk Profile:
 |  |  |  |  |  |  | SELECT FROM DROP DOWN | SELECT FROM DROP DOWN
Reference from FRA | Risk & Location | Risk Rating | Recommendation(s) | Comments & Evidence
1.7.C | Non-Conformity                                                        The boiler room contained combustible storage.                                                                    Location:                                                                      Accessed from outside | VERY HIGH | The practice of using the boiler room as a combustible storage area must cease. Boiler rooms generally generate heat above the ambient tempreatures. This, combined with the electircal risk, makes any such practice a high risk. |  |  |  | YES
2.5.G | Non-Conformity                                                        Fire doors are foulding against the frame and not closing or opening properly.                   Location:                                                                         The door adjacent to the mezzanine staircase from the VMU into the means escape route shared with the sort hall to the final exit door. | VERY HIGH | The doors must be eased and adjusted so that they are effectively fully self-closing. |  |  |  | YES
Spreadsheet: 840639d1692884095-xlookup-not-working-as-expected-xlookup-help
Sheet: Sheet1

[NAME] | Employee | Emp SAP id | Last Name | First Name | Column1 | Section Head |  | 0 | Boss 0
BUS | 932 | 932 |  |  |  |  |  | 1 | Boss 1
BUS | 1062 | 1062 |  |  |  |  |  | 2 | Boss 2
BUS | 1109 | 1109 |  |  |  |  |  | 3 | Boss 3
BUS | 1162 | 1162 |  |  |  |  |  | 4 | Boss 4
BUS | 1475 | 1475 |  |  |  |  |  | 5 | Boss 5
BUS | 1610 | 1610 |  |  |  |  |  | 6 | Boss 6
BUS | 1663 | 1663 |  |  |  |  |  | 7 | Boss 7
BUS | 1774 | 1774 |  |  |  |  |  | 8 | Boss 8
BUS | 1929 | 1929 |  |  |  |  |  | 9 | Boss 9
BUS | 1967 | 1967
BUS | 1991 | 1991
BUS | 2014 | 2014