tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 698005d1601664281-using-median-with-multiple-conditions-test-sheetmedian-withaggregate
Sheet: Summary Page

12m Total Return (%) 30/09/19 - 30/09/20 | Median
 | Port |  |  |  | CRITERIA | CRITERIA | CRITERIA
Low/Med Income |  |  |  |  | Inc | Low-Med | JSW
Low/Med Balanced |  |  |  |  |  |  | TWW
Low/Med Growth
Med Income
Med Balanced
Med Growth
Med/High Income
Med/High Balanced
Med/High Growth
High
Spreadsheet: 190263d1351599531-looking-for-same-number-but-different-prefix-and-add-cell-contents-zeszyt1
Sheet: Arkusz1

Sum | columns' labels
rows' labels | A | R | Sum
2056 | 7 | 40 | 47
2068 | 5 | 4 | 9
2076 | 10 | 5 | 15
7116 | 12 |  | 12
Sum | 34 | 49 | 83
Spreadsheet: 878540d1725632664-sumtotals-by-matching-first-9-characters-of-invoice-test
Sheet: Sheet1

Invoice # | Amount | Total
THER35874 | 100
THER35874A | 50
THER35874CR | 68
ROTH35874-1 | 124.56
ROTH35874-2 | 36
HOUS87415 | 987.4
HOUS38415BC | 125
I'm looking to total by the first 9 characters matching.
Spreadsheet: 847174d1698229221-calculating-hours-worked-overtime-example
Sheet: Sheet1

You must use the format HH:[NAME] (ie 09:00 or 17:00) when entering your time. It reformats the cell if you use any other way (ie 9 or 17 or 9.00 ect) this will change the calculations and the sheet won't be correct.
 |  | Enter start time: 24hr clock | Enter time work over lunch. ie 00:30 minuets worked | Enter finish time: 24hr clock | Hours worked | Running total of overtime. | Enter time taken back as hours:minutes | Final running total of overtime
Date | Day | Start | Lunch | Finish | Hours | Overtime | Time taken back | Total
2023-09-18 00:00:00 | Mon | 09:00:00 |  | 17:00:00 | 08:00:00 | 00:00:00 | 00:00:00 | 00:00:00
2023-09-19 00:00:00 | Tue | 08:00:00 |  | 17:00:00 | 09:00:00 | 01:00:00 | 00:00:00 | 01:00:00
2023-09-20 00:00:00 | Wed | 09:00:00 |  | 16:00:00 | 07:00:00 | 00:00:00 | 01:00:00 | 00:00:00
2023-09-21 00:00:00 | Thu | 09:00:00 | 00:30:00 | 17:00:00 | 08:30:00 | 00:30:00 | 00:00:00 | 00:30:00
2023-09-22 00:00:00 | Fri |  |  |  |  | 00:00:00 | 00:00:00 | 00:30:00
2023-09-23 00:00:00 | Sat | 12:00:00 |  | 13:00:00 | 01:00:00 | 01:00:00 |  | 01:30:00
2023-09-24 00:00:00 | Sun
2023-09-25 00:00:00 | Mon |  |  |  | =((E11-C11)+D11) | =IF(F11>TIME(8,0,0), F11-TIME(8,0,0), 0) | [NAME] needed | =[NAME])
2023-09-26 00:00:00 | Tue
2023-09-27 00:00:00 | Wed
2023-09-28 00:00:00 | Thu
2023-09-29 00:00:00 | Fri
2023-09-30 00:00:00 | Sat
2023-10-01 00:00:00 | Sun
2023-10-02 00:00:00 | Mon
2023-10-03 00:00:00 | Tue
2023-10-04 00:00:00 | Wed
2023-10-05 00:00:00 | Thu
2023-10-06 00:00:00 | Fri
2023-10-07 00:00:00 | Sat
2023-10-08 00:00:00 | Sun
2023-10-09 00:00:00 | Mon
2023-10-10 00:00:00 | Tue
2023-10-11 00:00:00 | Wed
2023-10-12 00:00:00 | Thu
2023-10-13 00:00:00 | Fri
2023-10-14 00:00:00 | Sat
2023-10-15 00:00:00 | Sun
2023-10-16 00:00:00 | Mon
2023-10-17 00:00:00 | Tue
2023-10-18 00:00:00 | Wed
2023-10-19 00:00:00 | Thu
2023-10-20 00:00:00 | Fri
2023-10-21 00:00:00 | Sat
2023-10-22 00:00:00 | Sun
2023-10-23 00:00:00 | Mon
2023-10-24 00:00:00 | Tue
2023-10-25 00:00:00 | Wed
2023-10-26 00:00:00 | Thu
2023-10-27 00:00:00 | Fri
2023-10-28 00:00:00 | Sat
2023-10-29 00:00:00 | Sun
2023-10-30 00:00:00 | Mon
2023-10-31 00:00:00 | Tue
2023-11-01 00:00:00 | Wed
2023-11-02 00:00:00 | Thu
2023-11-03 00:00:00 | Fri
2023-11-04 00:00:00 | Sat
2023-11-05 00:00:00 | Sun
2023-11-06 00:00:00 | Mon
2023-11-07 00:00:00 | Tue
2023-11-08 00:00:00 | Wed
2023-11-09 00:00:00 | Thu
2023-11-10 00:00:00 | Fri
2023-11-11 00:00:00 | Sat
2023-11-12 00:00:00 | Sun
2023-11-13 00:00:00 | Mon
2023-11-14 00:00:00 | Tue
2023-11-15 00:00:00 | Wed
2023-11-16 00:00:00 | Thu
2023-11-17 00:00:00 | Fri
2023-11-18 00:00:00 | Sat
2023-11-19 00:00:00 | Sun
2023-11-20 00:00:00 | Mon
2023-11-21 00:00:00 | Tue
2023-11-22 00:00:00 | Wed
2023-11-23 00:00:00 | Thu
2023-11-24 00:00:00 | Fri
2023-11-25 00:00:00 | Sat
2023-11-26 00:00:00 | Sun
2023-11-27 00:00:00 | Mon
2023-11-28 00:00:00 | Tue
2023-11-29 00:00:00 | Wed
2023-11-30 00:00:00 | Thu
2023-12-01 00:00:00 | Fri
Spreadsheet: 141240d1329164085-excel-2007-how-to-grab-information-from-other-sheets-and-place-it-in-the-main-sheet-fulllist2
Sheet: Badminton

Event (select from dropdown list) | Team Name | Level of Play | First Name | Last Name | Concatenate | Capt(*) | Sex | Date of Birth | Address | Suburb | State(abbr) | Postcode | Phone # | [NAME] | [NAME] | Golf Club | Squash Grade |  |  | Preferred Day | Time | Rego/Soc | Business Unit | Employee# | T-Shirt Size | Cheque | Cash | Direct Deb | Total | Added to FL | Notes
 |  |  | Test1 | Test1 |  |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test2 | Test2 |  |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test3 | Test3 |  |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test4 | Test4 |  |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xl
 |  |  | Test5 | Test5 |  |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test6 | Test6 |  |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | [NAME] | [NAME] |  |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test8 | Test8 |  |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Test9 | Test9 |  |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Test10 | Test10 |  |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test11 | Test11 |  |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test12 | Test12 |  |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test13 | Test13 |  |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test14 | Test14 |  |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xl
 |  |  | Test15 | Test15 |  |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test16 | Test16 |  |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test17 | Test17 |  |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test18 | Test18 |  |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test19 | Test19 |  |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  | Test20 | Test20 |  |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xl
 |  |  | Test21 | Test21 |  |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test22 | Test22 |  |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test23 | Test23 |  |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  | Test24 | Test24 |  |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | [NAME] | [NAME] |  |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 218919d1362606511-freeze-split-panes-question-freeze-panes-sample-1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Empty | Empty | Empty | Empty | Empty | Empty | Empty | Empty | Empty | Empty
 | 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 |  |  |  |  | Empty | Empty | Empty | Empty | Empty | Empty | Empty | Empty | Empty | Empty
 | 0 | 0 |  |  | 0
 | 0 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  |  | Empty | Empty | Empty | Empty | Empty | Empty | Empty | Empty | Empty | Empty
Spreadsheet: 128847d1321305828-finding-lowest-cost-from-a-list-with-wildcard-lowestpricesexcludingshanghai
Sheet: Raw data

Part Code | Supplier | Supplier Location | Cost
AAA1 | ALP | Xiamen | 5.5
AAA1 | DSB | Xiamen | 5.3
AAA1 | STA | Shenzhen | 5.4 |  |  |  | Supplier Location | (Multiple Items)
AAA1 | AOS | Shanghai | 4.1
BBB1 | ALP | Xiamen | 9.8 |  |  |  | Row Labels | Min of Cost
BBB1 | DSB | Xiamen | 10.5 |  |  |  | AAA1 | 5.3
BBB1 | AOS | Shanghai | 10.2 |  |  |  | AAA2 | 5.5
BBB1 | STA | Shenzhen | 7.5 |  |  |  | AAA3 | 5.3
CCC1 | ALP | Xiamen | 4.5 |  |  |  | AAA4 | 5.4
CCC1 | DSB | Xiamen | 6.4 |  |  |  | AB-CCC2-BS | 6.4
CCC1 | AOS | Shanghai | 3.55 |  |  |  | BBB1 | 7.5
CCC1 | STA | Shenzhen | 5.33 |  |  |  | BBB10 | 7.5
CCC1 | LUC | Guangdong | 3.44 |  |  |  | BBB3 | 9.8
AAA2 | ALP | Xiamen | 5.5 |  |  |  | BBB5 | 10.5
AAA3 | DSB | Xiamen | 5.3 |  |  |  | CB-CCC1 | 4.5
AAA4 | STA | Shenzhen | 5.4 |  |  |  | CCC1 | 3.44
AAA5 | AOS | Shanghai | 4.1 |  |  |  | Grand Total | 3.44
BBB3 | ALP | Xiamen | 9.8
BBB5 | DSB | Xiamen | 10.5
BBB10 | AOS | Shanghai | 10.32
BBB10 | STA | Shenzhen | 7.5
CB-CCC1 | ALP | Xiamen | 4.5
AB-CCC2-BS | DSB | Xiamen | 6.4
[NAME] | AOS | Shanghai | 3.55
Spreadsheet: 72472d1273156649-calculating-different-range-of-values-example
Sheet: Sheet1

 | Values | [NAME] |  | Value after formula |  |  | Details for formula
 | 163 |  |  | 241.566 |  |  | 0-200 | *1.14*1.3
 | 1789 |  |  | 2365.7736 |  |  | 201-800 | *1.14*1.2
 | 809 |  |  | 1088.2668 |  |  | 801-1400 | *1.14*1.18
 | 299 |  |  | 409.0319999999999 |  |  | 1401+ | *1.14*1.16
 | 966 |  |  | 1299.4632
 | 35 |  |  | 51.87
Spreadsheet: 736353d1623524658-formular-for-make-summary-jaribu
Sheet: DARASA LA III

[NAME] WA MUHULA WILAYA DARASA LA III WILAYA [NAME] 2021.
[NAME] |  |  |  | MASOMO
NA | JINA LA MTAHINIWA | SEX  MALE=1 &FEMALE=2 | SCHOOL | KISWAHILI |  | ENGLISH |  | HISABATI |  | SAYANSI &TEKNOLOJIA |  | M/JAMII |  | URAIA NA MAADILI |  | JML | WASTANI | DARAJA
 |  |  |  | SCORE | GRADE | SCORE | GRADE | SCORE | GRADE | SCORE | GRADE | SCORE | GRADE | SCORE | GRADE
1 | [NAME] | 1 | KATIKATI |  | A |  | B |  | B |  | A |  | A |  | C |  |  | B
2 | MUSANDO KOISENGE MASLOJI | 1 | KATIKATI |  | B |  | C |  | B |  | B |  | B |  | B |  |  | B
3 | [NAME] | 2 | KATIKATI |  | A |  | C |  | B |  | B |  | B |  | B |  |  | B
4 | [NAME] LEAPA | 1 | KATIKATI |  | A |  | C |  | C |  | B |  | A |  | C |  |  | B
5 | [NAME] ATHUMANI | 2 | KATIKATI |  | A |  | B |  | C |  | C |  | B |  | C |  |  | B
66 | SELEMANI ABBAKARI TWAHA | 1 | IRKIUSHIOIBOR |  | A |  | C |  | C |  | C |  | A |  | A |  |  | B
67 | [NAME] | 2 | IRKIUSHIOIBOR |  | A |  | C |  | C |  | C |  | A |  | B |  |  | B
68 | [NAME] | 1 | IRKIUSHIOIBOR |  | A |  | C |  | D |  | A |  | C |  | B |  |  | B
69 | JUMA HAMISI KIKOKORI | 2 | IRKIUSHIOIBOR |  | B |  | C |  | D |  | C |  | C |  | B |  |  | C
70 | NASIRA JUMA NASORO | 2 | IRKIUSHIOIBOR |  | B |  | C |  | D |  | D |  | C |  | B |  |  | C
71 | NASHIPAI YOHANA ROKOINE | 2 | IRKIUSHIOIBOR |  | B |  | C |  | D |  | C |  | C |  | C |  |  | C
146 | NGULAA  S.  ALTARUSH | 1 | MAKAME
150 | [NAME] | 1 | MAKAME
151 | [NAME] | 2 | MAKAME
152 | [NAME]LEHALEI | 1 | MAKAME
247 | SARAH   E.  SING1ADE | 2 | MAKAME
 |  | DARAJA
 | SHULE | DARAJA | SOMO | KISW |  | ENGL |  | [NAME] |  | SAYA |  | M/JAMII |  | URAIA NA MAADILI
 | KATIKATI |  | JINSI | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2
 |  | A
 |  | B
 |  | C
 |  | D
 |  | E
 |  | ABS
 |  |  | JML
 | IRKIUSHIOIBOR | A
 |  | B
 |  | C
 |  | D
 |  | E
 |  | ABS
 |  |  | JML
 | MAKAME | A
 |  | B
 |  | C
 |  | D
 |  | E
 |  | ABS
 |  |  | JML
Spreadsheet: 768582d1645034851-help-with-this-test-buy-random_test_v3_1
Sheet: Some

A# | A.Name | Location | Stock
567 | Adios |  | 3
234 | Bye | wer | 4
6423234 | Cinco | pafyup23hyu | 23567
12498570 | Cuatro | 0987dvsaih | 341245
678 | Day | xcvvx | 43
890 | [NAME] | dfdzs34 | 0
654 | Dos | ndsvjknahr2h | 423342
987 | Eight | 2354halsfhlh3124 | 0
5678 | Five | 564lflzfn | 32
4567 | Four | 42pjhlfahslh | 6
345 | Goodbye | ert | 0
123 | Hi | qwe | 2
456 | Hola | asd | 32
210 | Lluvia | u4uwsafb | 124455
654 | Luna | oinasdf32 | 12345
876 | [NAME] | 098jsa | 543
321 | Nieve | vnxcnvlsd | 123123
789 | Night | 34fsed | 222
98 | Noche | sad4 | 123
1234 | One | 2[4jhpqsfhal | 1
432 | Rain | adbnln1 | 0
1235566234 | Seis | 09ugdwsoihpoi23h4r | 123
7890 | Seven | 054jlslshlt23 | 56234
6789 | Six | 69usdflsh | 231
543 | Snow | jbndlsn | 435
765 | Sol | 32fsdfv | 0
987 | Sun | cvcgh | 42
3456 | Three | 5wefzxclnkl23 | 5
418798471 | Tres | [NAME] | 1235678
2345 | Two | 143pjhashif1 | 3
986554 | Uno | 08isdjr | 123
Spreadsheet: 714993d1611500536-populate-calendar-in-excel-from-list-help-calendar
Sheet: Month

Budget Calendar with Daily Balance
Year: | 2021 |  | Month: | 1 |  | Start Day: | 1 | 1=Sun, 2=Mon …
Date:
Spreadsheet: 61752d1262685310-how-to-validate-dates-in-excel-if-or-array-or-both-example-vacation-planner
Sheet: Sheet1

 | Name | Days Owing | Period 1 |  |  | Period 2
 |  |  | Start Vacation | End Vacation | Valid? | Start Vacation | End Vacation | Valid?
 | Smith | 40 | 2010-01-01 00:00:00 | 2010-01-15 00:00:00 |  | 2010-07-01 00:00:00 | 2010-07-10 00:00:00
 | Jones | 40
 | [NAME] | 40
 | [NAME] | 40
 | [NAME] of days in a row |  |  | 10
 | [NAME] at one time |  |  | 1
Spreadsheet: 167735d1342086373-count-unique-values-once-with-multiple-criteria-across-multiple-sheets-0aafsample-file-2-1-
Sheet: Sheet1

Invoice Date | Invoice No. | Customer ID | Customer Name | Customer Type | Sales | helper column
2012-06-10 00:00:00 | A123 | B123 | Adolf Pharmacy | Pharmacy | 100 | 3
2012-06-10 00:00:00 | A124 | B124 | Dido Mart | [NAME] | 124 | 1
2012-06-10 00:00:00 | A125 | B125 | [NAME] | Pharmacy | 124 | 1
2012-06-13 00:00:00 | A126 | B126 | Eight Twelve | [NAME] | 154 | 1
2012-06-13 00:00:00 | A127 | B127 | [NAME] | Wholesaler | 500 | 1
2012-06-14 00:00:00 | A128 | B123 | Adolf Pharmacy | Pharmacy | 123 | 2
2012-06-14 00:00:00 | A129 | B225 | Aluadin | Wholesaler | 500 | 1
2012-06-14 00:00:00 | A130 | B303 | Stiff Job Pharmacy | Pharmacy | 231 | 1
2012-06-14 00:00:00 | A131 | B898 | [NAME] | [NAME] | 231 | 1
2012-06-14 00:00:00 | A132 | B765 | Floor Mart | [NAME] | 230 | 1
2012-06-15 00:00:00 | A133 | B654 | Dido Mart | [NAME] | 231 | 1
2012-06-15 00:00:00 | A134 | B123 | Adolf Pharmacy | Pharmacy | 123 | 1
2012-06-16 00:00:00 | A135 | B671 | [NAME] | Wholesaler | 500 | 1
Spreadsheet: 369951d1421073517-holiday-entitlement-formula-just-the-table-1-
Sheet: Sheet1

Annual leave                                                                                                             (20 days excluding BH, BH = "date") |  |  | Annual Entitlement | 20 | Days
Start Date | End Date | Annual Leave Reason | No Of Days Left | Column1 | Column2
2015-01-12 00:00:00 | 2015-01-16 00:00:00 | Holiday 5 week days |  |  |  |  | No of days would = how many days I have left from ONLY my annual entitlement declared in E1.
2015-04-03 00:00:00 | 2015-04-06 00:00:00 | Bank Holiday (BH) = 2 days but needs to be ignored in calculation.
2015-04-13 00:00:00 | 2015-04-24 00:00:00 | 2 week holiday = 10 days (need to calculate if a weekend exists between start and end date as number of days between start and end is 14 |  |  |  |  | If Annual leave reason contains  BH or Bank Holiday then do not deduct a day from my entitlement.
2015-05-04 00:00:00 | 2015-05-04 00:00:00 | Bank Holiday (BH) = 1 day off not included in calculation |  |  |  |  | number of days to deduct from entitlement would = week days between start date and end date (excluding weekends if it cross over that date.)
2015-05-13 00:00:00 | 2015-05-15 00:00:00 | 2 days off  included
 |  |  |  |  |  |  | there is a calendar on sheet 1 that could be referenced I guess if needed? That is contained in 1st file I uploaded Calendarxxx
Spreadsheet: 136795d1326826001-populate-table-from-other-sheets-based-on-drop-down-selection-fast-solutions-2012-scorecard-sue-1
Sheet: Summary

FAST Solutions 2012 Build Center Scorecard
 |  |  |  |  |  |  |  |  |  | January 2012
Element | Total Machines Installed | Machines Not Installed > 60 Days | Profitability Per Machine Installed | [NAME]. Days Out on Installed Machines | Total Machines Signed, Not Installed | Product Templates Not Completed | Over All
Scorecard Value | 0.25 | 0.25 | 0.25 | 0.05 | 0.05 | 0.15 |  | D | November 2011 |  | 1
AHUB |  |  |  |  |  |  |  |  | December 2011 |  | 2
DHUB |  |  |  |  |  |  |  |  | January 2012 |  | 3
HHUB |  |  |  |  |  |  |  |  | February 2012 |  | 4
IHUB |  |  |  |  |  |  |  |  | March 2012 |  | 5
[NAME] |  |  |  |  |  |  |  |  | April 2012 |  | 6
MHUB |  |  |  |  |  |  |  |  | May 2012 |  | 7
NHUB |  |  |  |  |  |  |  |  | June 2012 |  | 8
OHUB |  |  |  |  |  |  |  |  | July 2012 |  | 9
SHUB |  |  |  |  |  |  |  |  | August 2012 |  | 10
UHUB |  |  |  |  |  |  |  |  | September 2012 |  | 11
VHUB |  |  |  |  |  |  |  |  | October 2012 |  | 12
WINO
Totals/Avgs
2011 Year-To-Date Rankings
AHUB |  |  |  |  |  |  |  |  | B | nov
DHUB |  |  |  |  |  |  |  |  | C | dec
HHUB |  |  |  |  |  |  |  |  | D | jan
IHUB |  |  |  |  |  |  |  |  | E | feb
[NAME] |  |  |  |  |  |  |  |  | F | [NAME]
MHUB |  |  |  |  |  |  |  |  | G | apr
NHUB |  |  |  |  |  |  |  |  | H | may
OHUB |  |  |  |  |  |  |  |  | I | jun
SHUB |  |  |  |  |  |  |  |  | J | jul
UHUB |  |  |  |  |  |  |  |  | K | aug
VHUB |  |  |  |  |  |  |  |  | L | sep
WINO |  |  |  |  |  |  |  |  | M | oct
Totals/Avgs
 | Packing List | Store Audit Completion | No Stock | Cost Per Mile | Cost Per Request | Cost Per Request Improvement
Spreadsheet: 80454d1280676981-extracting-values-from-a-single-cell-example
Sheet: Sheet1

2009
9-2-0 | 11-1-1 | 8-1-4 | 8-3-0
5-3-3 | 11-1-1 | 12-1-0 | 8-3-2
7-2-2 | 8-2-2 | 9-3-1 | 7-4-2
5-3-1 | 8-5-2 | 11-3-0 | 7-4-1
5-2-2 | 7-6-0 | 9-4-1 | 11-3-0
4-3-3 | 6-3-3 | 10-1-1 | 7-6-1
6-5-0 | 8-3-2 | 6-7-1 | 2-5-5
4-3-3 | 7-4-2 | 9-3-2 | 6-4-2
5-4-2 | 9-2-1 | 5-8-1 | 5-8-1
6-3-1 | 8-6-0 | 8-2-3 | 8-3-0
5-2-2 | 7-9-0 | 6-4-3 | 7-6-0
10-2-1 | 7-6-1 | 6-5-1 | 6-5-1
7-1-1 | 6-5-3 | 8-3-2 | 7-6-0
4-5-0 | 5-6-3 | 7-5-2 | 7-2-3
4-6-0 | 6-4-3 | 7-6-1 | 7-5-1
5-4-0 | 5-6-2 | 4-10-1 | 6-4-1
6-5-1 | 8-3-2 | 5-7-1 | 6-7-1
6-2-2 | 5-7-1 | 6-6-2 | 9-4-0
6-2-1 | 8-5-0 | 4-9-1 | 7-5-1
5-4-1 | 6-6-1 | 6-6-1 | 4-8-0
4-4-1 | 6-7-1 | 7-5-1 | 8-4-0
4-5-2 | 4-6-2 | 8-4-1 | 7-3-2
4-5-1 | 4-5-3 | 5-7-1 | 4-6-2
4-3-3 | 4-6-3 | 7-7-0 | 4-7-2
3-5-1 | 7-4-2 | 5-7-3 | 5-5-1
4-4-0 | 6-7-2 | 8-4-3 | 6-7-0
2-6-2 | 6-6-1 | 4-9-2 | 5-8-0
5-5-0 | 6-7-0 | 8-5-1 | 4-9-0
3-3-3 | 3-7-4 | 4-6-3 | 7-7-0
2-6-1 | 8-6-1 | 2-10-2 | 3-7-1
Spreadsheet: 676936d1589087908-pull-contact-info-from-multiple-rows-and-deliver-across-multiple-columns-based-on-company-excelforumexamplev2
Sheet: #1

Company Name | Contact 1: First Name | Contact 1: Last Name | Contact 1: Email | Contact 2: First Name | Contact 2: Last Name | Contact 2: Email | Contact 3: First Name | Contact 3: Last Name | Contact 3: Email | Contact 4: First Name | Contact 4: Last Name | Contact 4: Phone | Contact 4: Email
1 Plus 2 Architecture
10 Design
11 Dimensions Pty Ltd
16 bays design
Spreadsheet: 91705d1291377837-counting-data-in-one-column-that-is-reliant-on-data-in-another-column-new-microsoft-office-excel-worksheet
Sheet: Sheet1

J1 | Complete | 1000
J2 | Complete | 255
J3 | In progress | 1478
J4 | In progress | 800
J5 | Complete | 700
J6 | Complete | 3000
J7 | In progress | 555
J8 | Not progressing | 3214
 | Complete | In progress | Not progressing |  | Complete | In progress | Not progressing
J1
J2
J3
J4
J5
J6
J7
J8
Total
 | 0
Spreadsheet: darrell_schoolcraft__7327__imball0202
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -124021
3531 | -759088 | -300715
60667 | -18 | -844451
60749 | 74665 | -242521
61206
61334 | -585535
62960
INDEX
2002-01-31 00:00:00 |  |  | 10496.07
2002-02-25 00:00:00
CBS Volume
2001-12-31 00:00:00 |  |  | 4346
Spreadsheet: 676193d1588696802-countif-varying-range-data
Sheet: Result

Week |  | Result |  | Result should be
15
16
17 |  |  |  | 1
18 |  |  |  | 1
19
20
21
22
23
24
25
25
27
28
Spreadsheet: 13324ba7-e9a4-4d9b-9d5f-03c9169b530c
Sheet: Zone 5-8

Permit No.: |  |  | WQ0034162 |  |  | Facility Name: |  | Wanchese Seafood Industrial Park |  |  |  |  |  | County: | Dare |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 05 |  | Field Name: |  | 06 |  | Field Name: |  | 07 |  | Field Name: |  | 08
 |  |  |  |  |  | Area (acres): |  | 0.18 |  | Area (acres): |  | 0.08 |  | Area (acres): |  | 0.05 |  | Area (acres): |  | 0.14
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.6 |  | [NAME] (in): |  | 0.6 |  | [NAME] (in): |  | 0.6 |  | [NAME] (in): |  | 0.6
 |  |  |  |  |  | Annual Rate (in): |  | 90.48 |  | Annual Rate (in): |  | 90.48 |  | Annual Rate (in): |  | 90.48 |  | Annual Rate (in): |  | 90.48
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 691210d1597569519-formular-to-take-data-from-another-sheet-example1829
Sheet: Sheet2

 |  | NAMBA | JINA LA MWANAFUNZI | SEX | 01 - KISWAHILI | 02 - ENGLISH | 03 - MAARIFA | 04 - HISABATI | 05 - SAYANSI | JUMLA | DARAJA | NAFASI | SHULE ATOKAYO
 |  | 1 | AGNES PAULO MTIE | 2 | 41 | 34 | 38 | 33 | 36 | 182 | B | 24 | KIBAYA
 |  | 2 | AKSA MCHALO CHARLES | 2 | 30 | 11 | 14 | 24 | 25 | 104 | C | 164 | KIBAYA
 |  | 3 | ANNA JOHN MDUMA | 2 | 34 | 31 | 35 | 36 | 39 | 175 | B | 33 | KIBAYA
 |  | 4 | [NAME] AHMEDIO | 2 | 9 | 14 | 18 | 15 | 15 | 71 | D | 225 | KIBAYA
 |  | 5 | CHEKA YOHANA MAJELE | 2 | 38 | 19 | 29 | 26 | 36 | 148 | C | 67 | KIBAYA
 |  | 6 | EDINA [NAME] | 2 | 42 | 29 | 38 | 33 | 38 | 180 | B | 27 | KIBAYA
 |  | 7 | FATUMA [NAME] | 2 | 12 | 3 | 3 | 3 | 3 | 24 | E | 231 | KIBAYA
 |  | 8 | HADIJA [NAME] | 2 | 13 | 26 | 16 | 20 | 24 | 99 | D | 176 | KIBAYA
 |  | 9 | HAFSWA MOHAMED BAKARI | 2 | 40 | 29 | 41 | 34 | 38 | 182 | B | 24 | KIBAYA
 |  | 10 | HARUNA MUSTAFA MBISI | 2 | 40 | 33 | 34 | 36 | 36 | 179 | B | 29 | KIBAYA
 |  | 11 | [NAME] MNYONAKI | 2 | 41 | 30 | 36 | 38 | 40 | 185 | B | 21 | KIBAYA
 |  | 12 | JULIANA YAREDI MWEKE | 2 | 37 | 26 | 31 | 37 | 38 | 169 | B | 42 | KIBAYA
 |  | 13 | [NAME] | 2 | 37 | 30 | 39 | 37 | 36 | 179 | B | 29 | KIBAYA
 |  | 14 | KATHERINE KANYENZE TOTO | 2 | 37 | 22 | 30 | 30 | 30 | 149 | C | 64 | KIBAYA
 |  | 15 | KATHERINE YEREMIA MAVINDI | 2 | 37 | 29 | 29 | 35 | 38 | 168 | B | 44 | KIBAYA
Spreadsheet: 43449d1242118263-grouping-log-in-times-into-15-minute-intervals-upload-1-
Sheet: Sheet2

06:00:00 | 06:00 - 06:15
06:15:00 | 06:15 - 06:30
06:30:00 | 06:30 - 06:45
06:45:00 | 06:45 - 07:00
07:00:00 | 07:00 - 07:15
07:15:00 | 07:15 - 07:30
07:30:00 | 07:30 - 07:45
07:45:00 | 07:45 - 08:00
08:00:00 | 08:00 - 08:15
08:15:00 | 08:15 - 08:30
08:30:00 | 08:30 - 08:45
08:45:00 | 08:45 - 09:00
09:00:00 | 09:00 - 09:15
09:15:00 | 09:15 - 09:30
09:30:00 | 09:30 - 09:45
09:45:00 | 09:45 - 10:00
10:00:00 | 10:00 - 10:15
10:15:00 | 10:15 - 10:30
10:30:00 | 10:30 - 10:45
10:45:00 | 10:45 - 11:00
11:00:00 | After 11