tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 707776d1607446974-finding-average-of-a-range-of-numbers-average-age-
Sheet: Sheet1

Spelling age | After new Assessment | Difference after new assessemnt
5.04-5.05 | 6.04-6.05
6.04-6.05 | 7.03-7.04
7.05-7.06 | 7.07-7.09
6.04-6.05 | 6.04-6.05
6.11-7 | 7.09-8.01
8.09-8.11 | 10-10.01
 |  |  |  | Y.MM |  |  | Y.MM
 |  |  |  | Y | M |  | Y | M
Spreadsheet: 156105d1337180393-excel-2007-some-sort-of-lookup-on-a-cell-into-an-array-of-data-lookup-using-input-cell-into-array
Sheet: Data

Acc Number | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
333 | 11 | 22 | 33 | 44 | 55 | 66 | 77 | 88 | 99 | 100 | 110 | 120
544 23223 | 21 | 32 | 43 | 54 | 65 | 76 | 87 | 98 | 109 | 110 | 120 | 130
fdg1515 21236 55 | 23 | 34 | 45 | 56 | 67 | 78 | 89 | 100 | 111 | 112 | 122 | 132
Spreadsheet: 703625d1605089865-create-summary-sheet-trail
Sheet: Summary

 | Sheet | Part No. | Rev. | 1 | 5 | 10 | 50 | 100
 | Sheet1 | 1 | A | 5 | 4 | 2.5 | 2 | 1.8
 | Sheet2 | 2 | A1 | 0.6 | 0.58 | 0.57 | 0.55 | 0.5
 | Sheet3 | 3 | B | 20 | 18 | 16 | 15.5 | 15
 | Sheet4 | 4 | B | 100 | 80 | 75 | 72 | 70
 | Sheet5 | 5 | C | 1 | 0.9 | 0.75 | 0.7 | 0.65
 | - | - | - | - | - | - | - | -
 | - | - | - | - | - | - | - | -
 | Sheet50 | 50 | C | 6 | 5 | 3 | 2.8 | 2.75
Spreadsheet: benjamin_rogers__1070__gencomodel
Sheet: Peak Hours

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly | Yearly | Seasonal | Seasonal
 | Bucket 1 | Bucket 2 | Bucket 3 | Bucket 4 | Bucket 5 | Bucket 6 | Bucket 7 | Bucket 8 | Bucket 9 | Bucket 10 | Bucket 11 | Bucket 12 | Bucket 13 | Bucket 14 | Bucket 15 | Bucket 16 | Bucket 17 | Bucket 18 | Bucket 19 | Bucket 20 | Total | Total | Availability | Capacity
 | 5 | 5 | 10 | 20 | 20 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 110
2000-01-15 00:00:00
Spreadsheet: 869779d1716354434-setting-up-a-sales-report-with-level-hierarchies-reporting-with-a-hierarchy-example
Sheet: Data

 | Item | Amount | Date | EOMONTH
 | T-Shirt | 10 | 2024-04-01 00:00:00
 | Pen | 3 | 2024-04-02 00:00:00
 | Water Bottle | 5 | 2024-04-05 00:00:00
 | Ice Cream | 2 | 2024-04-01 00:00:00
 | Gum | 1 | 2024-04-15 00:00:00
 | Pen | 3 | 2024-04-10 00:00:00
 | Pen | 3 | 2024-04-10 00:00:00
 | Pen | 3 | 2024-04-10 00:00:00
 | Gum | 1 | 2024-04-10 00:00:00
 | T-Shirt | 10 | 2024-04-10 00:00:00
 | T-Shirt | 10 | 2024-04-10 00:00:00
 | Water Bottle | 5 | 2024-04-10 00:00:00
 | Water Bottle | 5 | 2024-04-16 00:00:00
 | Ice Cream | 2 | 2024-04-16 00:00:00
 | Ice Cream | 2 | 2024-04-16 00:00:00
 | Pen | 3 | 2024-04-16 00:00:00
 | Gum | 1 | 2024-04-16 00:00:00
Spreadsheet: 75516d1276090142-sum-of-values-where-two-criterias-needs-to-be-true-excel-problem
Sheet: Blad1

 | Supplier | Criteria 1 | [NAME] | Criteria 3 | Value
 | Volvo | Safe | Big | Fast | 10
 | SAAB | Safe | Medium | Slow | 30
 | BMW | Unsafe | Medium | Slow | 100
 | Mercedes | Safe | Big | Ultra fast | 1000
If [NAME]  => |  | Sum of values
Criteria 1 | [NAME]
Safe |  |  | "= SUMMA.OM($C2:$C5;A14;$F2:$F5)"
Unsafe
Safe | Medium |  | ???
 |  |  |  | How to make this sum to 30
Spreadsheet: 823696d1680097738-finding-the-next-latest-date-with-conditions-and-returning-a-lookup-value-example-excel
Sheet: data

ID | date1 | #
10086248 | 2022-07-08 00:00:00 | 8 | return the # in column C from the "dates with #" tab where the ID matches and date 1 matches date 2 or return the # from the next latest date2 after date1
10086248 | 2022-07-15 00:00:00 | 7
10086248 | 2022-07-29 00:00:00 | 5
10086248 | 2022-08-05 00:00:00 | 4
10086248 | 2022-08-12 00:00:00 | 3
10086248 | 2022-08-19 00:00:00 | 2
10087080 | 2021-07-27 00:00:00 | 1
10087080 | 2021-08-26 00:00:00 | 9
10087080 | 2021-09-30 00:00:00 | 4
10087080 | 2021-10-15 00:00:00 | 24
10087080 | 2021-10-28 00:00:00 | 22
10087080 | 2021-11-04 00:00:00 | 22
10087080 | 2021-11-11 00:00:00 | 21
10087080 | 2021-11-18 00:00:00 | 21
10087080 | 2022-01-21 00:00:00 | 11
10087080 | 2022-02-17 00:00:00 | 10
10087080 | 2022-03-25 00:00:00 | 2
10087229 | 2022-02-15 00:00:00 | 1
10087229 | 2022-04-21 00:00:00 | 27
10087229 | 2022-06-07 00:00:00 | 35
10087229 | 2022-06-14 00:00:00 | 34
Spreadsheet: john_zufferli__16754__Can PWR Stack  Website for New Version 122001
Sheet: Can PWR - Website

WEBSITE ACCESS |  |  |  | Read
CAN PWR |  |  |  | Execute
 |  |  |  | None
Name | Position | Book Name Website Log In  OR READ ONLY WEBSITE | Tenor  (1-120 Months) | CAN Power Fin Swap (1916)
Cooper Richey | Assoc-Power Trader | Alberta Gas/US West Power/Alberta Power | 24 | Execute
[NAME] | VP-Canada Trading | Alberta Gas/BC Gas/Nymex Gas/US West Power/Alberta Power/Currency | [NAME] | Execute
Spreadsheet: 860506d1708587560-ifand-formula-example-days-behind-_etaf
Sheet: Sheet1

Today's Date:
(2 Day Goal)
Order Date | Customer | Units
2024-02-09 00:00:00 | ABC | 1155
2024-02-09 00:00:00 | DEF | 590
2024-02-11 00:00:00 | DEF | 4
2024-02-13 00:00:00 | XYZ | 1812 |  | If the order is less than or equal to 999 and is for that particular customer, than calculate the days behind the order is from the order date from the goal date.
2024-02-14 00:00:00 | DEF | 871
2024-02-19 00:00:00 | ABC | 200
2024-02-20 00:00:00 | ABC | 18
2024-02-21 00:00:00 | XYZ | 137
2024-02-21 00:00:00 | DEF | 243
 | 1 - 999 units
Customer | Days Behind: | Oldest Date:
ABC
DEF
XYZ
 | 1,000+ units
Customer | Days Behind: | Oldest Date:
ABC |  | 2024-02-19 00:00:00
DEF |  | 2024-02-20 00:00:00
XYZ |  | 2024-02-21 00:00:00
Spreadsheet: 767019d1644242602-convert-columns-to-rows-keeping-first-column-identifier-lynnsharkey
Sheet: Sheet3

Name | ID | In | Out | In2 | Out3 | In4 | Out5 | In6 | Out7 | In8 | Out9 | In10 | Out11
AINSWORTH, NICOLE |  | 2021-08-30 07:00:00 | 2021-08-30 15:00:00 | 2021-08-31 07:00:00 | 2021-08-31 15:00:00 | 2021-09-01 07:00:00 | 2021-09-01 15:00:00 | 2021-09-02 07:00:00 | 2021-09-02 15:00:00 | 2021-09-03 07:00:00 | 2021-09-03 15:00:00 | 2021-09-04 00:00:00 | 2021-09-04 00:00:00
ALLEN, DARELENE |  | 2021-08-30 15:00:00 | 2021-08-30 23:00:00 | 2021-08-31 15:23:00 | 2021-08-31 23:00:00 | 2021-09-01 00:00:00 | 2021-09-01 00:00:00 | 2021-09-02 00:00:00 | 2021-09-02 00:00:00 | 2021-09-03 00:00:00 | 2021-09-03 00:00:00 | 2021-09-04 00:00:00 | 2021-09-04 00:00:00
BEERENS, LIAM |  | 2021-08-30 00:00:00 | 2021-08-30 00:00:00 | 2021-08-31 00:00:00 | 2021-08-31 00:00:00 | 2021-09-01 15:00:00 | 2021-09-01 23:00:00 | 2021-09-02 15:00:00 | 2021-09-02 23:00:00 | 2021-09-03 00:00:00 | 2021-09-03 00:00:00 | 2021-09-04 00:00:00 | 2021-09-04 00:00:00
What I need is
Name | ID | In | Out
 | 004648 | 2021-08-30 07:00:00 | 2021-08-30 15:00:00
AINSWORTH, NICOLE | 004648 | 2021-08-31 07:00:00 | 2021-08-31 15:00:00
AINSWORTH, NICOLE | 004648 | 2021-09-01 07:00:00 | 2021-09-01 15:00:00
AINSWORTH, NICOLE | 004648 | 2021-09-02 07:00:00 | 2021-09-02 15:00:00
AINSWORTH, NICOLE | 004648 | 2021-09-03 07:00:00 | 2021-09-03 15:00:00
AINSWORTH, NICOLE | 004648 | 2021-09-04 00:00:00 | 2021-09-04 00:00:00
ALLEN, DARELENE | 002246 | 2021-08-30 15:00:00 | 2021-08-30 23:00:00
ALLEN, DARELENE | 002246 | 2021-08-31 15:23:00 | 2021-08-31 23:00:00
ALLEN, DARELENE | 002246 | 2021-09-01 00:00:00 | 2021-09-01 00:00:00
ALLEN, DARELENE | 002246 | 2021-09-02 00:00:00 | 2021-09-02 00:00:00
ALLEN, DARELENE | 002246 | 2021-09-03 00:00:00 | 2021-09-03 00:00:00
ALLEN, DARELENE | 002246 | 2021-09-04 00:00:00 | 2021-09-04 00:00:00
BEERENS, LIAM | 002066 | 2021-08-30 00:00:00 | 2021-08-30 00:00:00
BEERENS, LIAM | 002066 | 2021-08-31 00:00:00 | 2021-08-31 00:00:00
BEERENS, LIAM | 002066 | 2021-09-01 15:00:00 | 2021-09-01 23:00:00
BEERENS, LIAM | 002066 | 2021-09-02 15:00:00 | 2021-09-02 23:00:00
BEERENS, LIAM | 002066 | 2021-09-03 00:00:00 | 2021-09-03 00:00:00
BEERENS, LIAM | 002066 | 2021-09-04 00:00:00 | 2021-09-04 00:00:00
Spreadsheet: 88768d1288625145-conditional-formatting-using-formula-nottersexample-1-
Sheet: Sheet1

2010-11-01 00:00:00
2010-11-15 00:00:00 |  | Due in 14 day(s) |  |  | Open
2010-10-20 00:00:00 |  | 12 day(s) late |  |  | Despatched
2010-10-31 00:00:00 |  | 1 day(s) late |  |  | Open
2010-11-05 00:00:00 |  | Due in 4 day(s) |  |  | Despatched
2010-08-23 00:00:00 |  | 70 day(s) late |  |  | Open
2010-11-30 00:00:00 |  | Due in 29 day(s) |  |  | Open
2010-11-24 00:00:00 |  | Due in 23 day(s) |  |  | Despatched
 | due in over 11 days (or no data entered)
 | due between 10 and 3 days
 | Due in 2 or less days or late
Spreadsheet: 230587d1366815103-return-multiple-values-from-multiple-sheets-example-1-
Sheet: APR

EQUIPMENT | DATE | TEMP | BEGIN PSIG | END PSIG | VALVE | ACTIVITY | MCF LOSS | BBLS H20
COMPRESSOR #1 | 2013-04-14 00:00:00 | 98 | 1005 | 0 | N/A | BLOWDOWN | 15.25 | 0
COMPRESSOR #3 | 2013-04-22 00:00:00 | 95 | 1002 | 650 | N/A | BLOWDOWN | 6.75 | 0
COMPRESSOR #4 | 2013-04-22 00:00:00 | 92 | 999 | 0 | N/A | BLOWDOWN | 15 | 0
Spreadsheet: 138548d1327704962-help-with-nested-ifs-mgd_finals
Sheet: Round 3

 | Team | Bowler | Game 7 | Game 8 | Game 9 | Series
 | 2 | Damon Peratt
 |  | [NAME]
 |  | Team Total
Match 7 |  | Bonus
 |  | Total w/Bonus
 | 6 | [NAME]
 |  | [NAME]
 |  | Team Total
 |  | Bonus
 |  | Total w/Bonus
 | 7 | [NAME]
 |  | [NAME]
 |  | Team Total
 |  | Bonus
 |  | Total w/Bonus
 | 3 | CR Black
 |  | [NAME]
 |  | Team Total
Match 8 |  | Bonus
 |  | Total w/Bonus
 | 4 | [NAME]
 |  | [NAME]
 |  | Team Total
 |  | Bonus
 |  | Total w/Bonus
 | 8 | [NAME]
 |  | [NAME]
 |  | Team Total
 |  | Bonus
 |  | Total w/Bonus
 | 1 | [NAME]
 |  | [NAME]
 |  | Team Total
Match 9 |  | Bonus
 |  | Total w/Bonus
 | 5 | [NAME]
 |  | [NAME]
 |  | Team Total
 |  | Bonus
 |  | Total w/Bonus
 | 9 | [NAME]
 |  | [NAME]
 |  | Team Total
 |  | Bonus
 |  | Total w/Bonus
Spreadsheet: 872509d1718882250-solved-12-month-rolling-count-if-formula-new-ncmr-log-temp
Sheet: Suppliers Quality Report 12

12 MONTH ROLLING
 | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEPT | OCT | NOV | DEC | Totals |  | Start Date: | 2023-03-01 00:00:00
Total Discrepant (NCMR) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | END Date:
Total Receipts |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VENDOR: | 3
% Rejected <2%
Acceptance Rate
Latent Discovery (NCMR)
Total Receipts
% Rejected <2%
Acceptance Rate
Suppliers are graded on performance by percentage of accepted material delivered to BSAS with a goal of no greater than 2% discrepant
 | < 1.5%
 | 1.5%- 2.0%
 | Greater than 2%
Spreadsheet: 83216d1283254082-selecting-oldest-date-from-list-test-1-
Sheet: Sheet1

Supplier | Last Invoice date | xxx | 2010-02-01 00:00:00 |  | 01.02.2010 | Select
A | 2010-10-01 00:00:00 | No | Unselect
A | 2010-10-02 00:00:00 | No | Unselect |  | Maks av Last Invoice date
A | 2010-10-03 00:00:00 | No | Unselect |  | Supplier | Totalt
A | 2009-10-04 00:00:00 | Yes | Unselect |  | C | 2007-05-04 00:00:00
B | 2010-05-01 00:00:00 | No | Unselect |  | Totalsum | 2007-05-04 00:00:00
B | 2010-05-02 00:00:00 | No | Unselect
B | 2010-05-03 00:00:00 | No | Unselect
B | 2009-05-04 00:00:00 | Yes | Unselect
C | 2007-05-01 00:00:00 | Yes | Select
C | 2007-05-02 00:00:00 | Yes | Select
C | 2007-05-03 00:00:00 | Yes | Select
C | 2007-05-04 00:00:00 | Yes | Select
Spreadsheet: 834914d1688146200-intersperse-blank-cells-within-a-list-sample-43-
Sheet: Sheet1

Header 1 | [NAME] | [NAME] | [NAME] | [NAME] | Header 6 | [NAME] | [NAME] | Header 9
Q | 1 | 2 | 3 | 4
W | 5 | 6 | 7 | 8 | 9 | 10 |  |  |  | W | W
E | a | b
R | c | d | e | f | g | h | i | j
 |  |  |  |  |  |  |  |  |  | E | E
 |  |  |  |  |  |  |  |  |  | R | R
Spreadsheet: 857170d1706208154-help-with-vstack-formula-kansas-scheduler-newtonus_prime-
Sheet: Calculations

HS | Boards | SQFT
No Smoothing | 90 | 2880
Light Smoothing | 60 | 1920
Heavy Smoothing | 40 | 1280
[NAME] | 30 | 960
[NAME] | 20 | 640
[NAME] | 15 | 480
[NAME]
2 Pass |  | 2880
3 Pass |  | 1920
4 Pass |  | 1280
Backlit |  | 960
DS |  | 960
FU or [NAME] |  | 200
DS White |  | 480
8 Pass |  | 180
8 Pass + White |  | 150
5 Layer |  | 240
 |  | 640
3Rs | SQFT
2 Pass | 1784
3 Pass | 1254
5-Pass | 704
Backlit | 241
2-Sided | 330
GS | Boards | SQFT
Light Smoothing | 25 | 800
Heavy Smoothing | 15 | 480
[NAME] | 10 | 320
[NAME] | 10 | 320
[NAME] | 6 | 192
Spreadsheet: eric_saibi__9928__102901R
Sheet: Turkey Point 03

Owner Name |  | Florida Power and Light
Station Name |  | Turkey Point Nuclear Power Station
Unit Name |  | Turkey Point 03
NERC Region |  | FRCC
State |  | FL
Fuel Type |  | Nuclear
Capacity |  | 760 MW
Start Date |  | 2001-09-29 00:00:00
End Date |  | 2001-10-28 00:00:00
Prv. Start Date |  | 2001-09-29 00:00:00
Prv. End Date |  | 2001-11-04 00:00:00
Comments |  | Refuel
SIC |  | 4911
Plant ID |  | 1500318
Unit ID |  | 1005035
Outage ID |  | 7998
Spreadsheet: 1ef50df9-fd95-4868-9812-e00d22eb4d07
Sheet: 7b

Product1 | EUR3 | GBP | [NAME] | USD | AUD | CAD | OTHER | TOTAL
Basis | 1117312 | 2019928 | 1890481 | 8213940 | 284895 | 109094 | 178283 | 13813933
Fixed-Float | 63299098 | 12284443 | 16934710 | 72219897 | 3959625 | 3860980 | 10673199 | 183231952
FRA | 28357380 | 9612598 | 27729 | 18474065 | 182457 | 60844 | 4018904 | 60733977
OIS | 21821980 | 5877929 | 119099 | 6185156 | 927238 | 561049 | 684993 | 36177444
Swaption | 7475266 | 1102533 | 2420411 | 6511183 | 295549 | 12633 | 234135 | 18051710
OTHER* | 5846074 | 1024460 | 296119 | 10464281 | 178050 | 39227 | 255732 | 18103943
TOTAL | 127917110 | 31921891 | 21688549 | 122068522 | 5827814 | 4643827 | 16045246 | 330112959
*OTHER variable includes the following products: Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 300727d1393545248-detect-numbers-in-a-cell-range-and-then-change-cells-based-on-what-numbers-are-found-examples-modified-by-tigeravatar-
Sheet: Sheet1

Name | Group | Room |  | All Rooms | Available Rooms
Person 1 | Group A |  |  | 1
Person 2 | Group A | 3 |  | 2
Person 3 | Group A |  |  | 3
Person 4 | Group A | 15 |  | 4
Person 6 | Group B |  |  | 5
Person 7 | Group B |  |  | 6
Person 8 | Group B | 4 |  | 7
Person 9 | Group C | 1 |  | 8
Person 10 | Group C |  |  | 9
Person 11 | Group C |  |  | 10
Person 12 | Group C |  |  | 11
 |  |  |  | 12
 |  |  |  | 13
 |  |  |  | 14
 |  |  |  | 15
Spreadsheet: c0156068-562c-49f0-9d47-9a61b592251a
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
C2 | Test | C2 | C2 Complement, Functional, with [NAME], Serum | C2 Complement,Functional,w/Reflex,S | C2/81835: C2H(50) Automated Liposome Lysis Assay C3/8174, C4/8171: Nephelometry | Plain, Red-Top Tube: Red |  |  | 1 | mL | Collection Container/Tube: Red top Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: 1. Immediately after drawing the specimen, place the tube on wet ice. 2. Spin down and separate serum from clot. 3. Immediately freeze specimen. Additional Information: Fasting preferred. | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold reject Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | 25-47 U/mL | Monday through Saturday; 3 p.m. | Same day/1 day | 2 days | 1 | 86161 |  |  |  |  | Rochester
C2 | [NAME] | SRED | Serum Red |  |  |  | Frozen | 21 days
C2 | Result | C2FX | C2 Complement,Functional,w/Reflex,S | C2 Complement,Functional,w/Reflex,S | Numeric |  |  |  |  | U/mL |  |  |  |  |  |  |  |  |  | 33408-6
C2 | Result | INT53 | Interpretation | Interpretation | Alphanumeric
C2 | [NAME] | C4 | [NAME], Serum | [NAME], S | Nephelometry | Serum Gel Tube: SGT Plain, Red-Top or serum gel tube: Red |  |  | 1 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | 14-40 mg/dL | Monday through Saturday; 3 p.m. | 1 day | 2 days | 1 | 86160 |  |  | No | Yes
C4 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
C4 | Result | C4 | [NAME], S | [NAME], S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 4498-2
C2 | [NAME] | [NAME] | [NAME], Serum | [NAME], S | Nephelometry | Serum Gel Tube: SGT Plain, Red-Top or serum gel tube: Red |  |  | 1 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | 75-175 mg/dL | Monday through Saturday; 3 p.m. | Same day/1 day | 2 days | 1 | 86160 |  |  | No | Yes
[NAME] | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
[NAME] | Result | [NAME] | [NAME], S | [NAME], S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 4485-9
Spreadsheet: 844034d1695830299-help-to-calculate-trend-book2
Sheet: Sheet1

 |  | Type | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 |  | Rate of chagne
 |  | Bananas | 233 | 206 | 191 | 182 | 170 | 156 | 151 | 134 | 129 | 113 | 107 | 0 | 0
 |  | Bananas | 310 | 249 | 205 | 192 | 176 | 162 | 158 | 138 | 136 | 118 | 112 | 0 | 0
 |  | Bananas | 188 | 156 | 130 | 119 | 110 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Bananas | 157 | 128 | 110 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Bananas | 278 | 280 | 275 | 272 | 268 | 260 | 255 | 242 | 230 | 221 | 206 | 199 | 192
 |  | Bananas | 2000 | 1987 | 1975 | 1966 | 1950 | 1928 | 1893 | 1845 | 1765 | 1685 | 1597 | 1493 | 1391
 |  | Bananas | 564 | 558 | 555 | 551 | 547 | 541 | 536 | 531 | 509 | 484 | 458 | 430 | 396
 |  | Bananas | 624 | 619 | 618 | 615 | 610 | 602 | 594 | 582 | 557 | 539 | 511 | 475 | 448
 |  | Bananas | 1522 | 1523 | 1521 | 1496 | 1457 | 1424 | 1397 | 1347 | 1298 | 1240 | 1198 | 1149 | 1103
 |  | Bananas | 237 | 236 | 235 | 235 | 233 | 232 | 230 | 224 | 218 | 211 | 203 | 191 | 174
 |  | Bananas | 358 | 354 | 347 | 344 | 334 | 331 | 327 | 316 | 309 | 296 | 289 | 283 | 272
 |  | Bananas | 291 | 288 | 285 | 282 | 280 | 278 | 275 | 273 | 268 | 266 | 258 | 248 | 243
 |  | Bananas | 196 | 201 | 199 | 198 | 194 | 191 | 191 | 189 | 186 | 185 | 183 | 181 | 179
 |  | Bananas | 855 | 853 | 852 | 850 | 845 | 839 | 835 | 830 | 822 | 815 | 810 | 802 | 787
 |  | Bananas | 936 | 988 | 1019 | 1032 | 1025 | 1015 | 1006 | 992 | 982 | 971 | 966 | 961 | 955
 |  | Bananas | 933 | 985 | 1036 | 1041 | 1034 | 1026 | 1021 | 1016 | 1002 | 990 | 981 | 974 | 964
 |  | Bananas | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 105 | 143
 |  | Bananas | 207 | 264 | 315 | 367 | 421 | 479 | 514 | 595 | 614 | 635 | 648 | 656 | 662
 |  | Bananas | 136 | 179 | 228 | 268 | 311 | 377 | 410 | 447 | 480 | 491 | 488 | 484 | 484
 |  | Bananas | 0 | 0 | 0 | 0 | 176 | 233 | 297 | 386 | 459 | 511 | 573 | 637 | 711
 |  | Bananas | 0 | 0 | 0 | 0 | 157 | 253 | 326 | 443 | 526 | 584 | 640 | 685 | 768
 |  | Bananas | 0 | 0 | 0 | 109 | 223 | 280 | 320 | 428 | 488 | 585 | 663 | 733 | 799
Spreadsheet: c4700775-67be-41a3-97ec-4978ed3cf16a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | MUSIC PERFORMANCE | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | VISUAL PERFORMANCE | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | GENERAL EFFECT | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24
 |  | Individual |  |  |  | Ensemble |  |  |  | Individual |  |  |  | Ensemble |  |  |  | Music |  |  |  | Visual
School | Brass | WW | Perc | Tot | Qty | Acc | Mus | Tot | AVG | Acc | Qual | Tot | [NAME] | Artis | Tot | AVG | Rep | Perf | Tot | Tot*2 | Rep | Perf | Tot | Total
O'Fallon Township
[NAME] | 7.5 | 7.5 | 5 | 20 | 7.5 | 7.5 | 5 | 20 | 20 | 10 | 10 | 20 | 10 | 10 | 20 | 20 | 10 | 10 | 20 | 40 | 10 | 10 | 20 | 100
Spreadsheet: 889793d1740710228-gantt-chart-mulitple-tasks-in-single-row-gantt-chart1-krackers-
Sheet: Schedule

 |  |  | 2025-02-27 00:00:00
 | TASK | PROGRESS | START3 | END3 |  | DAYS
Do not delete this row. This row is hidden to preserve a formula that is used to highlight the curren day within the project schedule.
 | Some Repetitive Event 1 | 0.2 | 2025-03-01 00:00:00
 | Same Repetitive Event 1 | 0
 | Same Repetitive Event 1 | 0
Spreadsheet: 773961d1648135090-keep-value-if-formula-is-false-test-123
Sheet: Data Sheet 

 | PLANND V ACTUAL MAN HOURS |  |  |  |  |  | PLANND V ACTUAL m2
 | Man Hours | Planned | Actual | Acc. Planned | Acc. Acutal |  | m2 | Planned | Actual | Acc. Planned | Acc. Acutal
 | 2017-09-18 00:00:00 |  | 0 |  |  |  | 2017-09-18 00:00:00 | 0 | 0
 | 2017-09-25 00:00:00 |  | 0 |  |  |  | 2017-09-25 00:00:00 | 550 | 0
 | 2017-11-06 00:00:00 |  | 0 |  |  |  | 2017-11-06 00:00:00 | 630 | 0
 |  |  | 0 |  |  |  |  | 630 | 0
 |  |  | 0 |  |  |  |  | 736 | 0
 |  |  | 0 |  |  |  |  | 462 | 0
 |  |  | 0 |  |  |  |  | 433 | 0
 |  |  | 0 |  |  |  |  | 276 | 0
 |  |  | 0 |  |  |  |  | 276 | 0
 |  | 0 | 0 |  |  |  |  |  | 0
 |  | 0 | 0 |  |  |  |  |  | 0
 |  |  | 0 |  |  |  |  | 190 | 0
 |  |  | 0 |  |  |  |  | 220 | 0
 |  |  | 0 |  |  |  |  | 230 | 0
 |  |  | 0 |  |  |  |  | 260 | 0
 |  |  | 0 |  |  |  |  | 210 | 0
 |  |  | 0 |  |  |  |  | 0 | 0
 |  | 240 | 0 |  |  |  |  | 0 | 0
 |  | 240 | 0 |  |  |  |  | 0 | 0
Spreadsheet: 454935d1460036357-lookup-add-another-one-searching-workbook
Sheet: Sheet1

 |  |  |  |  |  |  | EXAMPLE
 |  |  |  |  |  |  | DATE | ID |  |  |  |  |  |  |  |  |  | NUMBERS
 |  |  |  |  |  |  | 2016-01-01 00:00:00 | 5555 |  |  |  |  |  |  |  |  |  | 1000 | Columns and rows are in real ranges so I have sorted the unneeded ranges for now
 |  |  |  |  |  |  | 2016-01-02 00:00:00 | 6666 |  |  |  |  |  |  |  |  |  | 2000
 |  |  |  |  |  |  | 2016-01-03 00:00:00 | 3333 |  |  |  |  |  |  |  |  |  | 4000
 |  |  |  |  |  |  | 2016-01-04 00:00:00 | 4444 |  |  |  |  |  |  |  |  |  | 1000
 |  |  |  |  |  |  | 2016-02-05 00:00:00 | 9999 |  |  |  |  |  |  |  |  |  | 9000
 |  |  |  |  |  |  | 2016-02-06 00:00:00 | 7777 |  |  |  |  |  |  |  |  |  | 5500
 |  |  |  |  |  |  | 2016-02-07 00:00:00 | 6666 |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  | 2016-03-26 00:00:00 | 4444 |  |  |  |  |  |  |  |  |  | 1500
 |  |  |  |  |  |  | 2016-03-27 00:00:00 | 9999 |  |  |  |  |  |  |  |  |  | 9100
 |  |  |  |  |  |  | 2016-03-28 00:00:00 | 2222 |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  | 2016-03-29 00:00:00 | 5555 |  |  |  |  |  |  |  |  |  | 1780
 |  |  |  |  |  |  | 2016-03-30 00:00:00 | 8888 |  |  |  |  |  |  |  |  |  | 3500
 |  |  |  |  |  |  | 2016-03-31 00:00:00 | 5555 |  |  |  |  |  |  |  |  |  | 1980 | Here ends the date of W6 sheet2. Then I need [NAME] numbers from col S until this row. See please in sheet2 grey range
 |  |  |  |  |  |  | 2016-04-01 00:00:00 | 2222 |  |  |  |  |  |  |  |  |  | 4650
 |  |  |  |  |  |  | 2016-04-02 00:00:00 | 7777 |  |  |  |  |  |  |  |  |  | 6780
 |  |  |  |  |  |  | 2016-04-03 00:00:00 | 8888 |  |  |  |  |  |  |  |  |  | 4850
 |  |  |  |  |  |  | 2016-04-04 00:00:00 | 9999 |  |  |  |  |  |  |  |  |  | 9540
Spreadsheet: 750191d1633337098-find-count-consecutive-entries-in-a-row-in-excel-testing
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expected Answer | [NAME]
 |  | 0.1 | 0 | 0.2 | 1 | 0 | 0.1 | 0.2 | 0.2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  | 0.1 | 0 | 2 | 1.1 | 0.1 | 0.2 | 0.2 | 0.2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  | 0.1 | 0.2 | 0 | 0 | 0 | 0.2 | 0.2 | 1.1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 0.1 | 1.1 | 2 | 2 | 1.1 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  | 1.1 | 1.1 | 2 | 2 | 2 | 2 | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 0.1 | 0.2 | 0 | 0 | 0 | 0 | 0 | 1.1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0