tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 718381d1613128876-substract-value-add-no-macros-fruits-etaf
Sheet: Sheet1

 |  |  | Fruit | Qty
 |  |  |  |  |  |  |  |  |  |  | Row Labels | Sum of Qty
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 80
 |  |  |  |  |  |  |  |  |  |  | banana | 55 |  |  |  |  | How I want to see here on L
 |  |  | banana | 50 |  |  |  |  |  |  | apple | 35 |  |  |  |  | [NAME] | 80
 |  |  | apple | 35 |  |  |  |  |  |  | apricot | 24 |  |  |  |  | banana | 55
 |  |  | [NAME] | 70 |  |  |  |  |  |  | peach | 5 |  |  |  |  | apple | 35
 |  |  | peach | 5 |  |  |  |  |  |  | watermelons | 1 |  |  |  |  | apricot | 24
 |  |  | mangoes | -2 |  |  |  |  |  |  | mangoes | -2 |  |  |  |  | peach | 5
 |  |  | watermelons | 1 |  |  |  |  |  |  | cherry | -37 |  |  |  |  | watermelons | 1
 |  |  | apricot | 22 |  |  |  |  |  |  | Grand Total | 161 |  |  |  |  | mangoes | -2
 |  |  | cherry | -17 |  |  |  |  |  |  |  |  |  |  |  |  | cherry | -37
 |  |  | banana | 5
 |  |  | [NAME] | 10
 |  |  | apricot | 2
 |  |  | cherry | -20
 |  |  | test | 1
 |  |  | testttt | 2
 |  |  | test | 1
Spreadsheet: 267332d1380045917-vlookup-with-two-criteria-from-a-pivot-table-some-help-please-index-and-match
Sheet: Sheet1

car type
employee number | bd1kr | ex1tr | ft0wf | car 3 | car 4 | car 5 | car 6 | car 7 | car 8 |  | employee | car | mpg
1 |  |  |  |  |  |  |  |  |  |  | 14 | bd1kr
2
3
4
5
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | result here
7 |  |  |  |  |  |  |  |  |  |  | enter employee here |  | car here
8
9
10
11
12
13
14 | 20.2 | 38.3 | 42.7
15
16
17
18
19
20
21
22
23
24
25
Spreadsheet: 778516d1651134458-how-to-get-the-corresponding-column-header-from-a-time-table-expected-result-ans
Sheet: Sheet1

Name | First Aid Y/N | Friday |  | Saturday |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  |  | Name | First Aid Y/N | Friday |  | Saturday |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday
Dates and Names are dynamic |  | 2022-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dates and Names are dynamic |  | 2022-04-22 00:00:00
 |  | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time |  |  |  | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 08:00:00 | 15:00:00
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | 09:00:00 | 18:00:00
Spreadsheet: 73795d1274369085-vlookup-multiple-search-criterias-vlookup-stuff
Sheet: Sheet1

 | Name | Age | [NAME]
Alex12 | [NAME] | 12 | [NAME]
Ben32 | [NAME] | 32 | red
Craig54 | [NAME] | 54 | [NAME]
David67 | [NAME] | 67 | blond
Ed12 | [NAME] | 12 | red
Ferg34 | [NAME] | 34 | [NAME]
Gary56 | [NAME] | 56 | [NAME]
Harry76 | [NAME] | 76 | red
Ed87 | [NAME] | 87 | blonde
India12 | India | 12 | black
[NAME] | [NAME] | 34 | [NAME]
Spreadsheet: 153234d1335814914-need-help-consolidating-data-across-multiple-sheets-warehouse-store-order-list-4-30-12
Sheet: BBQ

Ordered | Item | Description | Retail | Heat Level | Category
 | R18 | [NAME], 16 oz. | 7.95 | 1 | BBQ
 | P130 | Carolina Style BBQ Sauce, 12 oz. | 6.95 | 2 | BBQ
 | R110 | Cinnamon & Apple BBQ Sauce, 16 oz. | 7.95 | 1 | BBQ
 | NN140 | Key Lime BBQ Sauce, 16 oz. | 7.95 | 1 | BBQ
 | NN320 | [NAME], 16 oz. | 7.95 | 1 | BBQ
 | R326 | Mountain Q - Honey Habanero BBQ, 16 oz. | 7.95 | 7 | BBQ
 | NN111 | Mountain Q BBQ -  [NAME], 16 oz | 7.95 | 2 | BBQ
 | NN145 | Mountain Q BBQ - Black Pepper, 16oz. | 7.95 | 2 | BBQ
 | NN101 | Mountain Q BBQ - Cayenne Spicy, 16 oz. | 7.95 | 6 | BBQ
 | NN210 | Mountain Q BBQ - Chipotle Medium, 16 oz. | 7.95 | 5 | BBQ
 | NN120 | Mountain Q BBQ - Datil Pepper Edition, 12oz. | 7.95 | 6 | BBQ
 | NN106 | Mountain Q BBQ - Habanero Hot, 16 oz. | 7.95 | 8 | BBQ
 | NN215 | Mountain Q BBQ - Jolokia X-Hot, 16 oz | 8.95 | 10 | BBQ
 | R112 | Peach BBQ, 16 oz | 7.95 | 2 | BBQ
 | [NAME] | PETA: Eat Meat BBQ Sauce, 16 oz. | 7.95 | 1 | BBQ
 | P214 | Vidalia Onion BBQ, 12 oz. | 6.95 | 2 | BBQ
Spreadsheet: 77f3a448-eaf7-4202-9153-f463b3bb58b7
Sheet: R-123 CWR Handler Cars

New # | Old # | New Contract | Old Contract | Purpose | Notes
ACR01 | 7701 |  | R-22 | Welded Rail Handler | Scrapped per NY Div. ERA Bltn 3/1999
[NAME] | 7077 |  | R-21 | Welded Rail Handler | Scrapped per NY Div. ERA Bltn 3/1999
ACR03 | 6726 |  | R-17 | Welded Rail Handler | Scrapped per NY Div. ERA Bltn 3/1999
ACR04 | 7568 |  | R-22 | Welded Rail Handler | Scrapped per NY Div. ERA Bltn 3/1999
ACR05 | 7133 |  | R-21 | Welded Rail Handler | Scrapped per NY Div. ERA Bltn 3/1999
ACR06 | 7569 |  | R-22 | Welded Rail Handler | Scrapped per NY Div. ERA Bltn 3/1999
ACR07 | 7579 |  | R-22 | Welded Rail Handler | Scrapped per NY Div. ERA Bltn 3/1999
ACR08 | 7345 |  | R-22 | Welded Rail Handler | Scrapped per NY Div. ERA Bltn 3/1999
BCR01 | 7145 |  | R-21 | Welded Rail Handler | Scrapped per NY Div. ERA Bltn 3/1999
BCR02 | 7550 |  | R-22 | Welded Rail Handler | Scrapped per NY Div. ERA Bltn 3/1999
BCR03 | 7588 |  | R-22 | Welded Rail Handler | Scrapped per NY Div. ERA Bltn 3/1999
BCR04 | 7168 |  | R-21 | Welded Rail Handler | Scrapped per NY Div. ERA Bltn 3/1999
BCR05 | 7083 |  | R-21 | Welded Rail Handler | Scrapped per NY Div. ERA Bltn 3/1999
BCR06 | 7136 |  | R-21 | Welded Rail Handler | Scrapped per NY Div. ERA Bltn 3/1999
BCR07 | 7100 |  | R-21 | Welded Rail Handler | Scrapped per NY Div. ERA Bltn 3/1999
BCR08 | 6721 |  | R-17 | Welded Rail Handler | Scrapped per NY Div. ERA Bltn 3/1999
CCR01 | 7303 | R-123 | R-22 | Welded Rail Handler | (In service 2010)
CCR02 | 7243 | R-123 | R-21 | Welded Rail Handler | (In service 2010)
CCR03 | 7340 | R-123 | R-22 | Welded Rail Handler | (In service 2010)
CCR04 | 7211 | R-123 | R-21 | Welded Rail Handler | (In service 2010)
CCR05 | 7289 | R-123 | R-21 | Welded Rail Handler | (In service 2010)
CCR06 | 7278 | R-123 | R-21 | Welded Rail Handler | (In service 2010)
CCR07 | 7296 | R-123 | R-21 | Welded Rail Handler | (In service 2010)
CCR08 | 7210 | R-123 | R-21 | Welded Rail Handler | (In service 2010)
DCR01 | 7055 | R-123 | R-21 | Welded Rail Handler | (In service 2010)
DCR02 | 7657 | R-123 | R-22 | Welded Rail Handler | (In service 2010)
DCR03 | 7446 | R-123 | R-22 | Welded Rail Handler | (In service 2010)
DCR04 | 7505 | R-123 | R-22 | Welded Rail Handler | (In service 2010)
DCR05 | 7659 | R-123 | R-22 | Welded Rail Handler | (In service 2010)
DCR06 | 6813 | R-123 | R-17 | Welded Rail Handler | (In service 2010)
DCR07 | 6850 | R-123 | R-17 | Welded Rail Handler | (In service 2010)
DCR08 | 7691 | R-123 | R-22 | Welded Rail Handler | (In service 2010)
Spreadsheet: 163975d1340583660-listing-certain-cells-if-condition-is-meet-forum-question
Sheet: 02

 |  |  |  | TRIPS, INCOME AND EXPENSES REPORT FOR | 2012-06-02 00:00:00
# | ON | OFF | AIR | FROM | TO | AMOUNT | TYPE | TM | M & G | C/C FEE | NET | PAX | PASSENGER'S NAME | NOTES
1 | 900 | 1000 | 1 | Delta 45 | WDW | 70 | 2 | 0 |  |  |  |  | [NAME]
2 | 1100 | 1200 | 1 | Delta 99 | DR | 60 |  | 0 |  |  |  |  | [NAME]
3 | 1300 | 1400 | 2 | Hyatt |  | 70 |  | 0 |  |  |  |  | Motta
4 | 1500 | 16 | 3 | HPG | Disney | 40 |  | 0 |  |  |  |  | Julia
5 |  |  |  |  |  |  |  | 0
6 |  |  |  |  |  |  |  | 0
7 |  |  |  |  |  |  |  | 0
9 |  |  |  |  |  |  |  | 0
10 |  |  |  |  |  |  |  | 0
11 |  |  |  |  |  |  |  | 0
12 |  |  |  |  |  |  |  | 0
13 |  |  |  |  |  |  |  | 0
EXPENSES |  |  |  |  | TOTALS FOR TODAY |  |  |  |  |  |  |  | TOTAL REVENUE FOR TODAY
 | Fuel |  |  |  | Maintenance | 0 |  |  |  |  |  |  | TOTAL EXPENSES FOR TODAY
 | Insurance & Amortizations |  |  |  | Repairs | 0
 | Tolls & Parking |  |  | 0 | Others |  |  |  |  |  |  |  | NET REVENUE FOR TODAY
AIR CODES: |  | ( 1 - FROM OIA) |  | (2- TO OIA) - (3- FROM HYATT OIA) - (4- OTHERS) | TOTAL EXPENSES FOR TODAY |  |  |  |  | Legend: 1(Cash)- 2 (Credit Card)- 3 (Harland)- 4 (Ripley)- 5 (FreshPoint)- 6 (SBMRI C/C)- 7 (SBMRI Invoiced)
Spreadsheet: 68442d1268968509-array-search-trigger-issues2
Sheet: First

3 |  | "Range A1:A13"
6 |  | "If the rows were a time series, I want to find the first to trigger over say 10"
9 |  | "So I would expect the result to be 12" |  |  |  | 12 |  |  |  |  | 12
2 |  | "I also want to output the range needed to reach above 10, here for example would be A1:A7" |  |  |  |  |  |  |  |  | 12
5 |  |  |  |  |  |  |  |  |  |  | 12
9 |  |  |  |  |  |  |  |  |  |  | 12
12 |  | A1:A7 |  |  |  |  |  |  |  |  | 12
11 |  | A2:A6 |  |  |  |  |  |  |  |  | 12
4 |  | A3:A5 |  |  |  |  |  |  |  |  | 12
6 |  | A4:A4 |  |  |  |  |  |  |  |  | 11
7 |  | A5:A3
11
8
"I try to use min to take the range, but I get the first sequential number "11" over the number not the series first hit I want"
11
"I try to index match the row as index being range,row(match function),column(1)"
#N/A |  | "Seems both of my statements fail"
#N/A
"As to get the range required before getting that term I was attempting countif function but again getting stuck in the sequence issue"
"If I were to countif and get a number say here 7 counts to reach the target, how could I output that as "A1:A7""
"Thanks for reading"
Spreadsheet: 206870d1358292462-wanting-to-consolidate-data-example
Sheet: 2

 |  | Sub |  | Date |  | Ticket # | FT/GAL |  | INSPECTIONS |  |  | DATE |  | Con.# | Job #:
Well/Water: |  |  |  |  |  |  |  |  | Rough Grade: |  |  |  |  |  | Operator:
Septic/Sewer: |  |  |  |  |  |  |  |  | Open Hole: |  |  |  |  |  | Address:
Saw Cutting: |  |  |  |  |  |  |  |  | Lateral: |  |  |  |  |  | Building:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bld. SF
Date | Lds | Product | Gross | Tare | Deduct | Net | [NAME] | Landfill | DR | Tk # | Dr. Tk. # | D. Fee | DF $/tn | TK $/ld | Tot. $ | Tot $/tn | L.F. Tic. # | CK
2013-01-09 00:00:00 | 1 | A | 0 | 0 | 0 | 0 | 0 | R | AA | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
2013-01-09 00:00:00 | 1 | A | 0 | 0 | 0 | 0 | 0 | R | AA | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
2013-01-09 00:00:00 | 1 | A | 0 | 0 | 0 | 0 | 0 | R | AA | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
2013-01-11 00:00:00 | 1 | A | 0 | 0 | 0 | 0 |  | R | AA | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
2013-01-11 00:00:00 | 1 | A | 0 | 0 | 0 | 0 |  | R | AA | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
2013-01-11 00:00:00 | 1 | A | 0 | 0 | 0 | 0 |  | R | AA | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
2013-01-11 00:00:00 | 1 | A | 0 | 0 | 0 | 0 |  | R | AA | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
2013-01-11 00:00:00 | 1 | A | 0 | 0 | 0 | 0 |  | R | AA | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
2013-01-11 00:00:00 | 1 | A | 0 | 0 | 0 | 0 |  | R | AA | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
2013-01-10 00:00:00 | 1 | B | 45920 | 38680 | 0 |  |  | S | BB | 0 | 0 | 0 |  | 0 |  |  | 0
2013-01-11 00:00:00 | 1 | B | 44180 | 38620 | 0 |  |  | S | BB | 0 | 0 | 0 |  | 0 |  |  | 0
2013-01-11 00:00:00 | 1 | C | 50280 | 38480 | 150 |  |  | S | BB | 0 | 0 | 0 |  | 0 |  |  | 0
Spreadsheet: benjamin_rogers__1160__Model5
Sheet: Assumptions

ASSUMPTIONS
TECHNICAL ASSUMPTIONS: | 1999 PROJECTS |  |  |  | 2000 PROJECTS
 | Brownsville | Caledonia | New Albany |  | [NAME] | Wheatland | [NAME]
Nominal Capacity (MW) | 500 | 504 | 425 |  | 544 | 514 | 672
Number of Turbines | 4 | 6 | 6 |  | 3 | 4 | 8
Heat Rate (Btu/kWh) | 11411 | 12064 | 12228 |  | 10904 | 11735 | 11973
Annual Operating Hours | 1200 | 1500 | 1000 |  | 900 | 900 | 3250
Annual Generation (MWh)
Number of Starts per year | 120
REVENUE SUMMARY:
Net Capacity (MW) | 458 | 442 | 367 |  | 510 | 470 | 608
Block Charge ($/start/turbine) | 4110.75 | 1874
OPERATING COSTS ASSUMPTIONS:
Annual Escalator | 0.03
Escalated Costs (2000 $):
Fixed O&M | 697.3290000000001 | 477.912 | 1066.527 |  | 761.2234285714286 | 1011 | 1248.318857142857
Variable O&M | 681.226 | 533.1610000000001 | 658.263 |  | 762.7114285714285 | 839.2731428571428 | 925.6919999999999
Major Maintenance & Ongoing Capex | 1133.334 | 1133.334 | 1133.333 |  | 800.0005714285713 | 800.0005714285713 | 800.0005714285713
Insurance | 284.061 | 261.456 | 250.554 |  | 206.892 | 190.908 | 266.748
SG&A | 0 | 0 | 0 |  | 0 | 0 | 0
Utilities, Start Power | 86.8457 | 41.144 | 77.881 |  | 49.17085714285714 | 64.6937142857143 | 59.97599999999999
Admin Fees | 0 | 0 | 0 |  | 0 | 0 | 0
O&M Fees | 211.079 | 211.079 | 211.079 |  | 116.667 | 116.667 | 116.667
Non-Escalated Costs (2000 $):
Property Taxes & Other (3yr Avg.)
Spreadsheet: 105828d1303126048-dynamic-vlookup-again-dyn_v_lookup
Sheet: Register

 | Sep |  |  |  |  | September | Oct |  |  |  |  | October
 | 2011-09-05 00:00:00 | 2011-09-06 00:00:00 | 2011-09-07 00:00:00 | 2011-09-08 00:00:00 | 2011-09-09 00:00:00 | Totals | 2011-10-03 00:00:00 | 2011-10-04 00:00:00 | 2011-10-05 00:00:00 | 2011-10-06 00:00:00 | 2011-10-07 00:00:00 | Totals
[NAME] | 1 | 1 | 0 | 1 | 0 |  | 1 | 1 | 0 | 0 | 1
[NAME] | 1 | 0 | 0 | 0 | 1 |  | 1 | 0 | 1 | 1 | 1
[NAME] | 1 | 1 | 0 | 0 | 0 |  | 1 | 1 | 0 | 0 | 1
Spreadsheet: 50c211ef-394a-4c96-a593-387481298d25
Sheet: Table 6.3

Monthly Statistical Bulletin
6.3 Terms of trade
Quarter | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Implicit price deflator for exports of goods and services (a) (b) – index
September | 79.8 | 96.6 | 104.7 | 90.1 | 93.6
December | 79.1 | 94.7 | 101.9 | 89.3 | 94.4
March | 82.4 | 99.5 | 94.8 | 90.4 | 95.2
June | 95.3 | 103.6 | 97.1 | 91 | 89.2
Annual average | 84.21133486958554 | 98.66203422564234 | 100 | 90.15818851146224 | 92.92237251230728
Implicit price deflator for imports of goods and services (a) (b) – index
September | 105.7 | 102 | 98.4 | 99.4 | 106.8
December | 100.9 | 98.1 | 101.1 | 100.3 | 107
March | 100.3 | 98.3 | 98.9 | 100.2 | 109.5
June | 101.9 | 98.3 | 101.5 | 100.4 | 106.9
Annual average | 102.0392117565896 | 99.07030247511425 | 100 | 99.93384497361563 | 107.5496174953737
Terms of trade (a) (b) (c) – index
September | 75.5 | 94.7 | 106.4 | 90.7 | 87.7
December | 78.3 | 96.5 | 100.8 | 89.1 | 88.2
March | 82.2 | 101.2 | 95.9 | 90.2 | 87
June | 93.5 | 105.3 | 95.7 | 90.6 | 83.4
Annual average | 82.52840591366807 | 99.58790047141073 | 100 | 90.21787216859879 | 86.39953788427408
(a) Quarterly figures are seasonally adjusted.
(b) Base: 2010-11 = 100.0.
(c) Index of the ratio of the implicit price deflator for exports of goods and services
to the implicit price deflator for imports of goods and services
Sources: ABS, Balance of payments and international investment position, | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5302.0&viewtitle=Balance%20of%20Payments%20and%20International%20Investment%20Position,%20Australia~Dec%202007~Latest~4/03/2008&&tabname=Past%20Future%20Issues&prodno=5302.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5302.0&viewtitle=Balance%20of%20Payments%20and%20International%20Investment%20Position,%20Australia~Dec%202007~Latest~4/03/2008&&tabname=Past%20Future%20Issues&prodno=5302.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5302.0&viewtitle=Balance%20of%20Payments%20and%20International%20Investment%20Position,%20Australia~Dec%202007~Latest~4/03/2008&&tabname=Past%20Future%20Issues&prodno=5302.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5302.0&viewtitle=Balance%20of%20Payments%20and%20International%20Investment%20Position,%20Australia~Dec%202007~Latest~4/03/2008&&tabname=Past%20Future%20Issues&prodno=5302.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5302.0&viewtitle=Balance%20of%20Payments%20and%20International%20Investment%20Position,%20Australia~Dec%202007~Latest~4/03/2008&&tabname=Past%20Future%20Issues&prodno=5302.0&issue=Dec%202007&num=&view=&
Cat. no. 5302.0
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-12-02 00:00:00
Spreadsheet: dc4ebb7a-b3ac-40a3-97ca-00793e840ae4
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
2930 | 15768 | Alberto | [NAME] | ESP | 151 | 00:12:46 | 00:00:44 | 00:36:29 | 00:01:24 | 00:28:38 | 1 | 01:20:01
Spreadsheet: chris_germany__1832__DecCohCHOICE-ENA
Sheet: Dec 11

 | COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2000-12-11 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1039 |  | 823 |  | 67694 |  |  |  |  |  | 24 | 1 | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 2 | 37
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 4821 |  | 1923 |  | 67694 |  |  |  |  |  | 26 | 3 | 35
 |  |  |  |  |  |  |  |  | 5000 |  | 5000 |  | 68918 | 0 |  |  |  |  | 31 | 4 | 37
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | 5 | 39
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 2008 |  | 982 |  | 67694 |  |  |  |  |  | 30 | 6 | 37
 |  |  |  |  |  |  |  |  | 1535 |  | 1535 |  | 68915 | 0 |  |  |  |  | 26 | 7 | 34
 |  |  |  |  |  |  |  |  | 1540 |  | 1540 |  | 69693 | 0 |  |  |  |  | 35 | 8 | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 | 9 | 44
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 15728 |  | 10505 |  | 67694 |  |  |  |  |  | 40 | 15 | 45
 |  |  |  |  |  |  |  |  | 673 |  | 673 |  | 69149 | 0 |  |  |  |  | 35 | 35 | 41
 |  |  |  |  |  |  |  |  | 0 |  |  |  | 68915 | 0 |  |  |  |  | 31 | 39 | 37
 |  |  |  |  |  |  |  |  | 0 |  |  |  | 68918 | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 1551 |  | 649 |  | 67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 830 |  | 364 |  | 67694 |  |  |  |  |  | Storage
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 9770 |  | 6647 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 1716 |  | 980 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 3459 |  | 2884 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 4312 |  | 3011 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 273 |  | 0 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 40 |  | 32 |  | 67694 | 1
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 738497d1625067792-return-multiple-rows-based-on-multiple-criteria-exampledata
Sheet: Sheet1

Property Code | Dateof Occupancy | Dateof Termination | Address1 | Tenure Type
ABC_001 | 2019-04-14 00:00:00 |  | Flat 1 | [NAME]
ABC_001 | 2018-10-07 00:00:00 | 2019-04-14 00:00:00 | Flat 1 | [NAME]
[NAME] | 2021-01-13 00:00:00 |  | Flat 2 | Tenant
[NAME] | 2019-11-11 00:00:00 | 2021-01-13 00:00:00 | Flat 2 | [NAME]
[NAME] | 2019-03-15 00:00:00 | 2019-11-11 00:00:00 | Flat 2 | Tenant
[NAME] | 2018-10-07 00:00:00 | 2018-10-24 00:00:00 | Flat 2 | [NAME]
ABC_003 | 2019-05-14 00:00:00 |  | Flat 3 | Tenant
ABC_003 | 2018-10-30 00:00:00 | 2019-05-14 00:00:00 | Flat 3 | [NAME]
ABC_003 | 2018-10-07 00:00:00 | 2018-10-30 00:00:00 | Flat 3 | [NAME]
ABC_004 | 2019-04-08 00:00:00 |  | Flat 4 | Tenant
ABC_004 | 2018-10-07 00:00:00 | 2019-04-08 00:00:00 | Flat 4 | [NAME]
ABC_005 | 2019-05-02 00:00:00 |  | Flat 5 | Tenant
ABC_005 | 2019-04-14 00:00:00 | 2019-05-02 00:00:00 | Flat 5 | [NAME]
ABC_005 | 2018-10-07 00:00:00 | 2019-04-14 00:00:00 | Flat 5 | [NAME]
 | Becomes
Property Code | Dateof Occupancy | Dateof Termination | Address1 | Tenure Type
ABC_001 | 2019-04-14 00:00:00 |  | Flat 1 | [NAME]
[NAME] | 2021-01-13 00:00:00 |  | Flat 2 | Tenant
[NAME] | 2019-11-11 00:00:00 | 2021-01-13 00:00:00 | Flat 2 | [NAME]
ABC_003 | 2019-05-14 00:00:00 |  | Flat 3 | Tenant
ABC_003 | 2018-10-30 00:00:00 | 2019-05-14 00:00:00 | Flat 3 | [NAME]
ABC_004 | 2019-04-08 00:00:00 |  | Flat 4 | Tenant
ABC_004 | 2018-10-07 00:00:00 | 2019-04-08 00:00:00 | Flat 4 | [NAME]
ABC_005 | 2019-05-02 00:00:00 |  | Flat 5 | Tenant
ABC_005 | 2019-04-14 00:00:00 | 2019-05-02 00:00:00 | Flat 5 | [NAME]
Spreadsheet: 842339d1694448938-date-formulas-without-values-and-conditional-formatting-first-aid-certificate-tracking-sample
Sheet: Sheet1

Standard First Aid & Adult,Infant & Child CPR+AED Training Certificates
Lastname | Firstname | Standard First Aid Training Date | Standard First Aid Certificate Expiry date (valid for 3 years) | Adult, Infant & Child CPR+AED Training Date | Adult, Infant & Child CPR+AED [NAME] (valid for 2 years) | General Supervisor | Standard First Aid Certificate | Adult, Infant & Child CPR+AED Certificate
Person 1 | Person 1 | 2023-06-12 00:00:00 |  | 2023-06-12 00:00:00 |  | Super2 | File | File
Person 2 | Person 2 | 2023-06-27 00:00:00 |  | 2023-06-27 00:00:00 |  | Super1 | File | File
Person 3 | Person 3 | 2023-06-23 00:00:00 |  | 2023-06-23 00:00:00 |  | Super4 | File | File
Person 4 | Person 4 | 2023-06-12 00:00:00 |  | 2023-06-12 00:00:00 |  | Super4 | File | File
Person 5 | Person 5 | 2023-06-12 00:00:00 |  | 2023-06-12 00:00:00 |  | Super3 | File | File
Person 6 | Person 6 | 2023-06-27 00:00:00 |  | 2023-06-27 00:00:00 |  | Super2 | File | File
Person 7 | Person 7 | 2023-06-12 00:00:00 |  | 2023-06-12 00:00:00 |  | Super1 | File | File
Person 8 | Person 8 | 2023-06-23 00:00:00 |  | 2023-06-23 00:00:00 |  | Super3 | File | File
Person 9 | Person 9 | 2023-06-23 00:00:00 |  | 2023-06-23 00:00:00 |  | Super1 | File | File
Person 10 | Person 10 | 2023-07-12 00:00:00 |  | 2023-07-12 00:00:00 |  | Super4 | File | File
Person 11 | Person 11 | 2023-07-12 00:00:00 |  | 2023-07-12 00:00:00 |  | Super3 | File | File
Person 12 | Person 12 | 2023-06-23 00:00:00 |  | 2023-06-23 00:00:00 |  | Super2 | File | File
Person 13 | Person 13 | 2023-06-23 00:00:00 |  | 2023-06-23 00:00:00 |  | Super4 | File | File
Person 14 | Person 14 | 2023-08-15 00:00:00 | 2023-09-11 00:00:00 | 2023-08-15 00:00:00 | 2023-09-11 00:00:00 | Super3
Person 15 | Person 15 | 2023-09-15 00:00:00 | 2023-09-16 00:00:00 | 2023-09-15 00:00:00 | 2023-09-16 00:00:00 | Super1
Person 16 | Person 16
Person 17 | Person 17
Person 18 | Person 18
Person 19 | Person 19 |  |  |  |  |  | [NAME] within 90 days
Person 20 | Person 20 |  |  |  |  |  | [NAME] within 60 days
 |  |  |  |  |  |  | Expired
 |  |  |  |  |  |  | [NAME]
Spreadsheet: 94184d1294067823-time-calculations-758539_obionenairobi
Sheet: Sheet1

Date | Name | Type | Log
2011-11-03 00:00:00 | [NAME] | In | 388
2011-11-03 00:00:00 | [NAME] | In | 395 |  | Sum of  Time |  | Type
2011-11-03 00:00:00 | [NAME] | Out | 904 |  | Name | Date | In | Out | Duration
2011-11-03 00:00:00 | [NAME] | Out | 910 |  | [NAME] | 2011-11-03 00:00:00 | 06:28:00 | 15:04:00 | 08:36:00
 |  |  |  |  | [NAME] | 2011-11-03 00:00:00 | 06:35:00 | 15:10:00 | 08:35:00