tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2c388c00-740f-427f-a709-945556b8c5f1
Sheet: Sheet1

City Officials Statements | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
For Quarter Ending 6/30/2011
(As of 8/12/2011)
Name | Title | Personal Benefits Reported | City Benefits Reported
Adams, Sam | Mayor | 474.99
Ansary, Raihana | At-will staff for Mayor [NAME]
Brooks, Caryn | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME]
Clarke, [NAME] | At-will staff for Mayor [NAME]
Dillman, [NAME] | At-will staff for Mayor [NAME]
[NAME], Todd | At-will staff for Mayor [NAME]
Fish, [NAME] | Commissioner | 27
Fritz, Amanda | Commissioner | 51.95
Gonzales, Cevero | At-will staff for Mayor [NAME]
Griffin-Valade | City Auditor
Hanson, [NAME] | Portland Planning Commission Member
Jimenez, [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | Director of Bureau of Fire, Rescue and Emergency Services
[NAME], [NAME] | At-will staff for Mayor [NAME]
Lauer, [NAME] | At-will staff for Mayor [NAME]
Leonard, [NAME] | Commissioner (Filed 7/18/2011) | 27
[NAME], [NAME] | At-will staff for Mayor Adams (Amended 7/26/2011) | 65
Lord II, Reese | At-will staff for Mayor [NAME]
Marriot, [NAME] | Director of Bureau of Environmental Services  (Filed 7/18/2011)
[NAME], [NAME] | At-will staff for Mayor [NAME]  (Filed 7/18/2011)
Neal, Clay | At-will staff for Mayor [NAME]
[NAME], Skip | At-will staff for Mayor [NAME]
Papaefthimiou, [NAME] | At-will staff for Mayor [NAME]
Parisot, [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME]
Reese, [NAME] | Director of Bureau of Police | 15
Ruiz, [NAME] | At-will staff for Mayor [NAME] | 42
Saltzman, [NAME] | Commissioner
Sandhu, Amreet | At-will staff for Mayor [NAME]
[NAME], [NAME] | Director of Bureau of Development Services
[NAME], [NAME] | At-will staff for Mayor [NAME]
Uwagbae, Grace | At-will staff for Mayor [NAME]
Yocom, [NAME] | At-will staff for Mayor [NAME]
Spreadsheet: 866340d1713284826-sum-if-with-blank-option-equipment-allocations-03-30-2024-test_2
Sheet: Allocations

Category | Asset -   Equip. # | Description | Date Beginning of JAN 2024 | JAN Location Moved to | JAN State | JAN County | JAN Date | JAN Job# | JAN Sub Job | JAN Job# & Sub | JAN Cost Code | JAN Days in [NAME] | JAN Charges
Buses | 00165 | 2000 School Bus | 2024-01-01 00:00:00
Buses | 00165 | 2000 School Bus | 2024-01-01 00:00:00
Buses | 00165 | 2000 School Bus | 2024-01-01 00:00:00
Buses | 00166 | 2000 School Bus | 2024-01-01 00:00:00
Buses | 00167 | 2001 School Bus | 2024-01-01 00:00:00
Buses | 00167 | 2001 School Bus | 2024-01-01 00:00:00
Buses | 00168 | 1999 School Bus | 2024-01-01 00:00:00
Buses | 00169 | 2000 School Bus | 2024-01-01 00:00:00 |  |  |  | 2024-01-10 00:00:00
Buses | 00170 | 2003 School Bus | 2024-01-01 00:00:00
Buses | 00171 | 2003 School Bus | 2024-01-01 00:00:00
Buses | 00172 | 2003 School Bus | 2024-01-01 00:00:00 |  |  |  | 2024-01-10 00:00:00
[NAME] | 00158 | 40' Container | 2024-01-01 00:00:00
[NAME] | 00159 | 20' Container | 2024-01-01 00:00:00
Forklifts 5K | 00116 | Forklift - G5-18A | 2024-01-01 00:00:00
[NAME] | 00287 | Forklift Variable Reach - 742 | 2024-01-01 00:00:00
[NAME] | 00287 | Forklift Variable Reach - 742 | 2024-01-01 00:00:00
Gators | 00044 | [NAME] Diesel | 2024-01-01 00:00:00
Gators | 00045 | [NAME] Diesel | 2024-01-01 00:00:00
Mowers | 00067 | Rotary Mower | 2024-01-01 00:00:00
[NAME] | 00072 | 333G Compact Track Loader | 2024-01-01 00:00:00
[NAME] | 00108 | 333G Compact Track Loader | 2024-01-01 00:00:00
[NAME] | 00108 | 333G Compact Track Loader | 2024-01-01 00:00:00
Trailers | 00482 | 2022 Enclosed Utility Trailer | 2024-01-01 00:00:00
Trailers | 00483 | 2022 Enclosed Utility Trailer | 2024-01-01 00:00:00
Spreadsheet: 140729d1328874235-excel-2007-how-to-grab-information-from-other-sheets-and-place-it-in-the-main-sheet-example_tiggi
Sheet: tennis

NAME | SEX | SIZE
test1 | F | L
test2 | F | S
test3 | M | S
test4 | M | M
test5 | F | M
test6 | F | M
[NAME] | F | XXL
Spreadsheet: 48b37cac-0f14-48e0-8488-8fd483027e97
Sheet: science 10

TCAP/CSAP Science |  | Total Number | [NAME]
Grade 10 |  |  | Unsatisfactory | Partially Proficient | Proficient | Advanced | No Score
2010 | All Students | 57264 | 28 | 22 | 41 | 6 | 3
2011 |  | 57950 | 29 | 21 | 41 | 7 | 2
2012 | All Students | 57732 | 26 | 22 | 43 | 7 | 2
 | American Indian/Alaska Native | 513 | 35 | 26 | 33 | 2 | 4
 | Asian | 1844 | 22 | 19 | 46 | 11 | 2
 | Black/African American | 2838 | 48 | 25 | 24 | 1 | 3
 | Hispanic/Latino | 16525 | 45 | 26 | 25 | 2 | 2
 | White | 34201 | 16 | 21 | 52 | 10 | 2
 | Native Hawaiian/Pacific Islander | 137 | 31 | 25 | 40 | 2 | 2
 | Two or more races | 1668 | 19 | 22 | 48 | 9 | 3
 | Minority | 23525 | 42 | 25 | 29 | 3 | 2
 | Students with Disabilities | 4512 | 70 | 15 | 10 | 1 | 4
 | English Learners | 8631 | 54 | 24 | 19 | 1 | 2
 | Free/Reduced Lunch | 20009 | 44 | 26 | 27 | 2 | 2
 | Female | 28407 | 26 | 24 | 43 | 5 | 2
 | Male | 29319 | 27 | 21 | 42 | 8 | 2
 | Migrant | 150 | 70 | 18 | 11 |  | 1
Spreadsheet: 373109d1422327198-remove-blanks-from-a-list-and-sort-automatically-tlist
Sheet: Output

Order number | Associate | Title | Supervisor
Spreadsheet: 864153d1711453525-create-running-total-by-year-inside-a-table-running-total
Sheet: Sheet1

Column1 | Column2 | Column22 | Column3 | Column4 | Column42 | Column5 | Total y | Run y
2023-07-24 00:00:00 | rr | 15 | 0
2023-09-15 00:00:00 | rr | 14.52 | 0
2023-10-23 00:00:00 | rr | 14.95 | 0
2023-10-23 00:00:00 | rr | 15.03 | 0
2023-10-27 00:00:00 | rr | 16.2 | 0
2023-11-28 00:00:00 | y |  | 25.89
2023-11-28 00:00:00 | y |  | 163.91
2023-12-21 00:00:00 | y |  | 13.2 | 19
2024-01-03 00:00:00 | y |  |  | 29.45
2024-02-02 00:00:00 | y |  | 31.09
2024-03-01 00:00:00 | y |  | 40.85
2024-03-12 00:00:00 | rr | 15.14
2024-03-13 00:00:00 | rr | 12
should be
 |  |  |  |  |  |  | Running total rr | Running total y
2023-07-24 00:00:00 | rr | 15 | 0
2023-09-15 00:00:00 | rr | 14.52 | 0
2023-10-23 00:00:00 | rr | 14.95 | 0
2023-10-23 00:00:00 | rr | 15.03 | 0
2023-10-27 00:00:00 | rr | 16.2 | 0
2023-11-28 00:00:00 | y |  | 25.89
2023-11-28 00:00:00 | y |  | 163.91
2023-12-21 00:00:00 | y |  | 13.2 | 19
2024-01-03 00:00:00 | y |  |  | 29.45
2024-02-02 00:00:00 | y |  | 31.09
2024-03-01 00:00:00 | y |  | 40.85
2024-03-12 00:00:00 | rr | 15.14
2024-03-13 00:00:00 | rr | 13.1 |  |  |  | 2024
Spreadsheet: 480870d1474118800-need-help-creating-a-lookup-formula-sample-member-id-report
Sheet: new members

First name | Last name | MEMBER ID
Adam | Adams | ADA.A
[NAME] | [NAME] | BRO.B
[NAME] | Chester | CHE.C
[NAME] | Davies | DAV.D
[NAME] | Edgar | EDG.E
[NAME] | Forbes | FOR.F
George | Gardner | GAR.G
[NAME] | [NAME] | HOL.H
[NAME] | Iles | ILE.I
[NAME] | [NAME] | JOH.J
[NAME] | Kent | KEN.K
Spreadsheet: 454954d1460042604-how-to-vlookup-only-ine-value-v
Sheet: Table 2

Current Data |  |  | Wanted Data
Item | Data |  | Item | Data
a |  |  | a | 1
a |  |  | a
a |  |  | a
b |  |  | b | 2
b |  |  | b
c |  |  | c | 3
c |  |  | c
c |  |  | c
c |  |  | c
Spreadsheet: 678907d1590112314-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example-sammyghr-
Sheet: 24 Feb 20 - 29 Feb 20

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2020-02-24 00:00:00 | 2020-02-25 00:00:00 | 2020-02-26 00:00:00 | 2020-02-27 00:00:00 | 2020-02-28 00:00:00 | 2020-02-29 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 24/02/2020 - 29/02/2020
Dameon | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | Dameon | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
[NAME] | AWAY | ❌ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ❌
Harley | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | Harley | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
Nathan | AWAY | ✓ | ✓ | ✓ | ✓ |  |  |  |  | Nathan | ❌
[NAME] | AWAY | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | N/A
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
Tyson | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  | Tyson | ✓
Will | AWAY | AWAY | AWAY | AWAY | AWAY |  |  |  |  | Will | N/A
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
 | ✓ | AWAY | ✓ | ? |  |  |  |  |  |  | ❌
 | ✓ | ✓ | ✓ | ? | ✓ |  |  |  |  |  | ❌
 | ✓ | ✓ | ✓ | ✓ |  |  |  |  |  |  | ✓
Edge Protection [NAME] |  |  | 24/02/2020 - 29/02/2020 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 24/02/2020 - 29/02/2020
Blum |  |  | ✓ |  |  |  |  |  |  | Dameon | ❌
Bascik |  |  | ✓ |  |  |  |  |  |  | [NAME] | ❌
Canterbury Linen Services |  |  | ✓ |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Harley | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Nathan | ✓
*** Means received but had to ask for it |  |  |  |  |  |  |  |  |  | [NAME] | ✓
❌   Means did not get one at all |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Tyson | ✓
 |  |  |  |  |  |  |  |  |  | Will | N/A
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
 |  |  |  |  |  |  |  |  |  |  | ✓
 |  |  |  |  |  |  |  |  |  |  | ❌
 |  |  |  |  |  |  |  |  |  |  | ✓
Spreadsheet: 102838d1300782298-tracking-payroll-by-employees-first-name-groupexpayroll
Sheet: Shift Schedule

 |  |  | I actually would like to place this list on a separate page - which I believe I can do and use VLOOKUP?
 |  |  |  |  |  | Assume: All employee names are unique and everyone works just one hour whenever his/her name is entered.
 |  |  |  |  |  | Which formulas do I use and where do I place these formulas?
 |  |  |  |  |  | This sum takes each employee's hourly rate and total is calculated.
 | Weekly Payroll |  |  |  |  |  |  |  |  | For the Week of:
 |  |  |  |  |  |  |  |  |  | Department Name:
 | Monday
 |  | MORNING |  |  | MID-DAY |  |  | EVENING |  |  | TOTAL
 | Group Ex | [NAME] | Rosela |  |  | Sharisse |  | [NAME]
 | Cycling | [NAME]
 | Yoga |  |  |  |  |  |  | [NAME] | [NAME]
 | Mat Pilates | [NAME] |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Grand total
 | Tuesday
 |  | MORNING |  |  | MID-DAY |  |  | EVENING |  |  | TOTAL
 | Wednesday
 |  |  |  |  |  |  |  |  |  |  | TOTAL
 | Thursday
 |  |  |  |  |  |  |  |  |  |  | TOTAL
 | Friday
 |  |  |  |  |  |  |  |  |  |  | TOTAL
 | Saturday
 |  |  |  |  |  |  |  |  |  |  | TOTAL
 | Sunday
 |  |  |  |  |  |  |  |  |  |  | TOTAL
Spreadsheet: 743185d1628275995-automate-table-creation-through-iterative-process-table-gen-from-a-formula-output_question
Sheet: Example of Desired Output

T [degC] | xi [liquid mol fraction | yi [vapor mol fraction]
 | 0
 | 0.001
 | 0.002
 | 0.003
 | 0.004
 | 0.005
 | 0.006
 | 0.007
 | 0.008
 | 0.009
 | 0.01
 | 0.011
 | 0.012
 | 0.013
 | 0.014
 | 0.015
 | 0.016
 | 0.017
 | 0.018
 | 0.019
 | 0.02
 | 0.021
 | 0.022
 | 0.023
 | 0.024
 | 0.025
 | 0.026
 | 0.027
 | 0.028
 | 0.029
 | 0.03
 | 0.031
 | 0.032
 | 0.033
 | 0.034
 | 0.035
 | 0.036
 | 0.037
 | 0.038
 | 0.039
 | 0.04
 | 0.041
 | 0.042
 | 0.043
 | 0.044
 | 0.045
 | 0.046
 | 0.047
 | 0.048
 | 0.049
 | 0.05
 | 0.051
 | 0.052
 | 0.053
 | 0.054
 | 0.055
 | 0.056
 | 0.057
 | 0.058
Spreadsheet: 74464fd3-d433-4be5-a48e-66208e84adce
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40252742 | 2014-02-26 19:40:37 | AXIS | 0 | 1 | 6 | 1471241 | [NAME] | 9596 | western | 1944-06-06 | 1944-06-06 | Gold Beach | Gold Beach
40269160 | 2014-02-27 20:33:09 | AXIS | 1 | 6 | 5 | 563579 | Amombar | 9596 | western | 1944-06-06 | 1944-06-06 | Gold Beach | Gold Beach
40269675 | 2014-02-27 20:52:11 | ALLIES | 0 | 3 | 6 | 563579 | Amombar | 9596 | western | 1944-06-06 | 1944-06-06 | Gold Beach | Gold Beach
Spreadsheet: 27005d1219774375-excel-2007-text-and-macro-help-help
Sheet: Main

S. No. | Name | No. of Cars | No. of Bikes
1 | A |  | 2
2 | B | 1 | 1
3 | C
4 | D | 3
5 | E | 3 | 1
6 | F | 2 | 3
7 | G | 3 | 1
8 | H | 3
9 | I | 1 | 2
10 | J |  | 4
Spreadsheet: 674343d1587765900-counting-transitions-between-0-1-but-for-every-year-sample
Sheet: sample

Year | Month | Day | SnowDepth | Quality | B | 0-0 transf | 0-1 transf | 1-0 transf | 1-1 transf
1944 | 12 | 17 | 0.35 | G
1944 | 12 | 18 | 0.36 | G
1944 | 12 | 19 | 0.28 | G
1944 | 12 | 20 | 0.26 | G
1944 | 12 | 21 | 0.26 | G
1944 | 12 | 22 | 0.26 | G
1944 | 12 | 23 | 0.26 | G
1944 | 12 | 24 | 0.22 | G
1944 | 12 | 25 | 0.18 | G
1944 | 12 | 26 | 0.18 | G
1944 | 12 | 27 | 0.17 | G
1944 | 12 | 28 | 0.17 | G
1944 | 12 | 29 | 0.17 | G
1944 | 12 | 30 | 0.17 | G
1944 | 12 | 31 | 0.17 | G
1945 | 12 | 17 | 0.08 | G
1945 | 12 | 18 | 0.10 | G
1945 | 12 | 19 | 0.08 | G
1945 | 12 | 20 | 0.08 | G
1945 | 12 | 21 | 0.08 | G
1945 | 12 | 22 | 0.10 | G
1945 | 12 | 23 | 0.10 | G
1945 | 12 | 24 | 0.10 | G
1945 | 12 | 25 | 0.10 | G
1945 | 12 | 26 | 0.11 | G
1945 | 12 | 27 | 0.10 | G
1945 | 12 | 28 | 0.12 | G
1945 | 12 | 29 | 0.13 | G
1945 | 12 | 30 | 0.13 | G
1945 | 12 | 31 | 0.13 | G
1946 | 12 | 17 | 0.25 | G
1946 | 12 | 18 | 0.25 | G
1946 | 12 | 19 | 0.25 | G
1946 | 12 | 20 | 0.22 | G
1946 | 12 | 21 | 0.22 | G
1946 | 12 | 22 | 0.21 | G
1946 | 12 | 23 | 0.19 | G
1946 | 12 | 24 | 0.14 | G
1946 | 12 | 25 | 0.16 | G
1946 | 12 | 26 | 0.16 | G
1946 | 12 | 27 | 0.16 | G
1946 | 12 | 28 | 0.16 | G
1946 | 12 | 29 | 0.16 | G
1946 | 12 | 30 | 0.16 | G
1946 | 12 | 31 | 0.16 | G
1947 | 12 | 17 | 0.33 | G
1947 | 12 | 18 | 0.33 | G
1947 | 12 | 19 | 0.31 | G
1947 | 12 | 20 | 0.31 | G
1947 | 12 | 21 | 0.31 | G
1947 | 12 | 22 | 0.31 | G
1947 | 12 | 23 | 0.34 | G
1947 | 12 | 24 | 0.34 | G
1947 | 12 | 25 | 0.38 | G
1947 | 12 | 26 | 0.38 | G
1947 | 12 | 27 | 0.38 | G
1947 | 12 | 28 | 0.38 | G
1947 | 12 | 29 | 0.39 | G
1947 | 12 | 30 | 0.39 | G
1947 | 12 | 31 | 0.39 | G
1948 | 12 | 17 | 0.12 | G
1948 | 12 | 18 | 0.12 | G
1948 | 12 | 19 | 0.10 | G
1949 | 12 | 17 | 0.10 | G
1949 | 12 | 18 | 0.13 | G
1949 | 12 | 19 | 0.15 | G
1949 | 12 | 20 | 0.16 | G
1949 | 12 | 21 | 0.16 | G
1949 | 12 | 22 | 0.17 | G
1949 | 12 | 23 | 0.18 | G
1949 | 12 | 24 | 0.18 | G
1949 | 12 | 25 | 0.19 | G
1949 | 12 | 26 | 0.19 | G
1949 | 12 | 27 | 0.25 | G
1949 | 12 | 28 | 0.28 | G
1949 | 12 | 29 | 0.29 | G
1949 | 12 | 30 | 0.30 | G
1949 | 12 | 31 | 0.35 | G
1950 | 12 | 17 | 0.37 | G
1950 | 12 | 18 | 0.32 | G
1950 | 12 | 19 | 0.32 | G
1950 | 12 | 20 | 0.32 | G
1950 | 12 | 21 | 0.32 | G
1950 | 12 | 22 | 0.32 | G
1950 | 12 | 23 | 0.32 | G
1950 | 12 | 24 | 0.32 | G
1950 | 12 | 25 | 0.37 | G
1950 | 12 | 26 | 0.40 | G
1950 | 12 | 27 | 0.40 | G
1950 | 12 | 28 | 0.43 | G
1950 | 12 | 29 | 0.44 | G
1950 | 12 | 30 | 0.45 | G
1950 | 12 | 31 | 0.45 | G
1951 | 12 | 17 | 0.08 | Y
1951 | 12 | 18 | 0.07 | Y
1951 | 12 | 19 | 0.07 | Y
1951 | 12 | 20 | 0.06 | Y
1951 | 12 | 21 | 0.00 | G
1951 | 12 | 22 | 0.00 | G
1951 | 12 | 23 | 0.00 | G
1951 | 12 | 24 | 0.00 | G
1951 | 12 | 25 | 0.00 | G
1951 | 12 | 26 | 0.00 | G
1951 | 12 | 27 | 0.00 | G
1951 | 12 | 28 | 0.00 | G
1951 | 12 | 29 | 0.08 | Y
1951 | 12 | 30 | 0.07 | Y
1951 | 12 | 31 | 0.07 | Y
Spreadsheet: 863550d1710989208-how-to-filter-two-column-values-filter-two-column
Sheet: Planilha1

name | id | Date | code
blues | 20 | 2022-06-01 00:00:00 | 99215
whites | 12 | 2024-03-20 00:00:00 | 99213 |  | whites
whites | 12 | 2024-03-20 00:00:00 | 99396 |  | maxima
whites | 12 | 2024-03-10 00:00:00 | 99212 |  | maxima
maxima | 18 | 2023-05-20 00:00:00 | 99396 |  | rose
maxima | 18 | 2023-05-20 00:00:00 | 99215 |  | rose
rose | 14 | 2024-01-10 00:00:00 | 99396 |  | reds
rose | 14 | 2024-01-10 00:00:00 | 99204 |  | reds
rose | 14 | 2023-02-20 00:00:00 | 99212
black | 16 | 2023-01-01 00:00:00 | 99396
black | 16 | 2023-01-02 00:00:00 | 99212
black | 16 | 2024-02-28 00:00:00 | 99214
reds | 22 | 2024-07-01 00:00:00 | 99396
reds | 22 | 2024-07-01 00:00:00 | 99213
yellows | 24 | 2025-08-01 00:00:00 | 99215
Spreadsheet: 215268d1361320138-determine-ytd-average-employee-weekly-hours-ytd-ave-weekly-hours-2
Sheet: Sheet1

 | P | = Waiting to [NAME]. X or Did Not Send to Comp. A
 | Y | = Received Comp. X Timesheet or Sent to Comp. A |  |  |  |  |  | 2013-01-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-16 00:00:00
 | No. | Team | Still On A Team (Y/N) | Comp. X Employee (First / Last) | Initials | Comp. A Badge / Emp. ID | Comp. X SAP ID | Comp. X Rec'd | Hours Billing | Comp. X Worked Hours | Totals | Sent to Comp. A | Comp. A Appr'd | Comp. X Rec'd | Hours Billing | Comp. X Worked Hours | Totals | Sent to Comp. A | Comp. A Appr'd | Comp. X Rec'd | Hours Billing | Comp. X Worked Hours | Totals | Sent to Comp. A | Comp. A Appr'd | Comp. X Rec'd | Hours Billing | Comp. X Worked Hours | Totals | Sent to Comp. A | Comp. A Appr'd | Comp. X Rec'd | Hours Billing | Comp. X Worked Hours | Totals | Sent to Comp. A | Comp. A Appr'd | Comp. X Rec'd | Hours Billing | Comp. X Worked Hours | Totals | Sent to Comp. A | Comp. A Appr'd | Comp. X Rec'd | Hours Billing | Comp. X Worked Hours | Totals | Sent to Comp. A | Comp. A Appr'd | Comp. X Rec'd | Hours Billing | Comp. X Worked Hours | Totals | Sent to Comp. A | Comp. A Appr'd | YTD Ave. Billable Hours | YTD Comp. X Billable Hours | Total | Average weekly hours
 | 1 | A | Y | Employee Zebra |  | 12345 | 987456321 | Y | 24 | 0 |  | Y | Y | Y | 47.5 | 0 |  | Y | Y | Y | 53.5 | 1.5 |  | Y | Y | Y | 40.5 | 3 |  | Y | Y | Y | 59.7 | 0.25 |  | Y | Y |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 55
Spreadsheet: 31400d1227213195-conditional-sum-to-match-against-drop-down-list-supplierdraft
Sheet: DDL

SUPPLIER | Brand | TYPE
Apple | Apple | Stationary
DreamTek | Lacie | Computer Hardware
NMR | Sony | Computer Software
MediaP | Fuji | ProVid Software
TapeHouse | Evertz | ProVid Hardware
SpectraLogic | LG | [NAME]
ProTape | HP | Tape Stock
Panasonic | Samsung | DataTape
Scrubs
The Farm
Viking
[NAME]
Spreadsheet: 492459d1481108402-macro-to-filter-on-unwanted-data-and-delete-fruit
Sheet: Output

Fruit | Code
Apples | 1
Bananas | 2
[NAME]'s | 23
Pineapples | 45
[NAME]'s | 232
[NAME]'s | 2
Apples | 3
Bananas | 45
[NAME]'s | 3
Pineapples | 45
[NAME]'s | 56
[NAME]'s | 23
Apples | 4242
Bananas | 2
[NAME]'s | 23
Pineapples | 2424
[NAME]'s | 2432
[NAME]'s | 445
[NAME]'s | 2
[NAME]'s | 3
Apples | 45
Bananas | 56
Spreadsheet: 26297439-2d72-48d0-957f-a0d499712b22
Sheet: GSC estimate

 |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  | Engineering Evaluation of Underground Utilities | Performance of a Geophysical Survey | 4 Soil Borings and 4 Soil Samples | Installation, Development, and Surveying of 1 Monitoring Well | [NAME] | Preparation of Site Characterization Report
 |  | 1800 | 3000 | 2500 | 3500 | 2500 | 3000
 |  |  |  | Sub - 1000 | Sub - 2000 | Consultant - 1800
 |  |  |  | Consultant -500 | Consultant -500 | Lab - 500
 |  |  |  | Lab - 300 | Lab - 0 | Field Expenses - 200
 |  |  |  | Field Expenses - 150 | Field Expenses - 150
Spreadsheet: 0e2b0a84-1055-47d8-a146-7bc806eb96a2
Sheet: MANABIKH

ΜΑΝΑΒΙΚΗ
ΠΕΡΙΓΡΑΦΗ | ΜΟΝ.ΜΕΤΡ. |  | ΠΕΡΙΓΡΑΦΗ | ΜΟΝ.ΜΕΤΡ.
ΑΝΗΘΟΣ | ΤΕΜΑΧΙΑ |  | ΜΗΛΑ ΣΤΑΡΚΙΝ | ΚΙΛΑ
ΣΕΛΙΝΟ | ΤΕΜΑΧΙΑ |  | ΜΗΛΑ ΣΜΙΘ | ΚΙΛΑ
ΜΑΙΝΤΑΝΟΣ | ΤΕΜΑΧΙΑ |  | ΜΗΛΑ ΓΚΟΛΝΤΕΝ | ΚΙΛΑ
[NAME] | ΚΙΛΑ |  | ΜΗΛΑ ΤΖΟΝΑ | ΚΙΛΑ
ΤΟΜΑΤΕΣ ΕXTRA | ΚΙΛΑ |  | ΜΗΛΑ ΦΥΡΙΚΙΑ | ΚΙΛΑ
[NAME]Α | ΚΙΛΑ |  | ΜΗΛΑ ΠΑΚΑΜΣ ΚΡΥΣΤΑΛΙΑ | ΚΙΛΑ
ΤΟΜΑΤΕΣ ΄Β | ΚΙΛΑ |  | ΑΚΤΙΝΙΔΙΑ | ΚΙΛΑ
ΠΙΠΕΡΙΕΣ ΚΟΥΠΑΤΕΣ | ΚΙΛΑ |  | ΜΠΑΝΑΝΕΣ | ΚΙΛΑ
ΠΙΠΕΡΙΕΣ ΄Β | ΚΙΛΑ |  | ΠΑΤΑΤΕΣ ΠΟΛΩΝΙΑΣ | ΚΙΛΑ
ΚΕΡΑΤΑ | ΚΙΛΑ |  | ΠΑΤΑΤΕΣ ΓΑΛΛΙΑΣ | ΚΙΛΑ
[NAME] | ΚΙΛΑ |  | ΠΑΤΑΤΕΣ ΚΡΗΤΗΣ | ΚΙΛΑ
[NAME] | ΚΙΛΑ |  | ΚΡΕΜΜΥΔΙΑ | ΚΙΛΑ
ΜΕΛΙΤΖΑΝΕΣ ΦΛΑΣΚΕΣ | ΚΙΛΑ |  | ΣΚΟΡΔΑ | ΤΕΜΑΧΙΑ
ΠΙΠΕΡΙΕΣ ΤΣΑΚΩΝΙΚΕΣ | ΚΙΛΑ |  | ΠΟΡΤΟΚΑΛΙΑ ΓΙΑ ΧΥΜΟ | ΚΙΛΑ
ΜΠΡΟΚΟΛΟ | ΚΙΛΑ |  | ΠΟΡΤΟΚΑΛΙΑ ΓΙΑ ΦΑΙ | ΚΙΛΑ
[NAME] | ΚΙΛΑ |  | ΛΕΜΟΝΙΑ | ΚΙΛΑ
ΑΓΓΟΥΡΙΑ | TEM |  | ΓΚΡΕΙΠ ΦΡΟΥΤ | ΚΙΛΑ
ΑΓΓΟΥΡΑΚΙΑ | ΚΙΛΑ |  | ΠΕΠΟΝΙΑ | ΚΙΛΑ
[NAME] | ΚΙΛΑ |  | ΚΑΡΠΟΥΖΙΑ | ΚΙΛΑ
[NAME] | ΚΙΛΑ |  | ΑΝΑΝΑΣ | ΚΙΛΑ
[NAME] | ΚΙΛΑ |  | ΒΑΝΙΛΙΕΣ | ΚΙΛΑ
[NAME] ΨΙΛΑ | ΚΙΛΑ |  | ΤΣΑΟΥΛΙΑ | ΚΙΛΑ
ΠΡΑΣΣΑ | ΚΙΛΑ |  | ΜΠΑΡΜΠΟΥΝΙΑ | ΚΙΛΑ
ΛΑΧΑΝΑ | ΚΙΛΑ |  | ΣΤΑΦΥΛΙΑ | ΚΙΛΑ
ΛΑΧΑΝΑ ΚΟΚΚΙΝΑ | ΚΙΛΑ |  | ΚΛΗΜΕΝΤΙΝΕΣ | ΚΙΛΑ
ΡΟΚΑ | ΚΙΛΑ |  | ΚΑΤΣΑΝΑ | ΚΙΛΑ
ΜΑΡΟΥΛΙΑ | ΤΕΜΑΧΙΑ |  | ΚΑΡΥΔΙΑ | ΚΙΛΑ
ΣΑΛΑΤΕΣ | ΚΙΛΑ |  | ΚΕΡΑΣΙΑ | ΚΙΛΑ
[NAME] | ΚΙΛΑ |  | ΒΕΡΥΚΟΚΑ | ΚΙΛΑ
ΠΛΕΥΡΩΤΟΥΣ | ΚΙΛΑ |  | ΦΡΑΟΥΛΕΣ | ΚΙΛΑ
ΣΠΑΝΑΚΙ | ΚΙΛΑ |  | ΡΟΔΑΚΙΝΑ | ΚΙΛΑ
ΠΑΝΤΖΑΡΙΑ | ΚΙΛΑ |  | ΝΕΚΤΑΡΙΝΙΑ | ΚΙΛΑ
ΙΤΑΛΙΚΑ | ΚΙΛΑ
ΗΜΕΡΑ | ΚΙΛΑ
ΝΤΟΜΑΤΙΝΙΑ | ΚΙΛΑ
ΛΟΛΑ ΚΟΚΚΙΝΗ | ΚΙΛΑ
ΛΟΛΑ ΠΡΑΣΙΝΗ | ΚΙΛΑ
Spreadsheet: john_griffith__15905__11_13_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | 22 | 65 | 75 | 70.7 | 81.6 | 1.05 | 2001-11-13 12:19:00
 | CL F2 | 22 | 263 | 273 | 51.6 | 53.6 | 0.73 | 2001-11-13 12:19:00
 | CL G2 | 22 | 370 | 382 | 50.8 | 52.4 | 0.71 | 2001-11-13 12:19:00
 | CL H2 | 22 | 435 | 445 | 49.7 | 50.9 | 0.7 | 2001-11-13 12:19:00
 | CL J2 | 22 | 480 | 495 | 48.1 | 49.6 | 0.68 | 2001-11-13 12:19:00
 | CL K2 | 22 | 530 | 540 | 47.3 | 48.2 | 0.66 | 2001-11-13 12:19:00
 | CL M2 | 22 | 542 | 557 | 44.6 | 45.9 | 0.63 | 2001-11-13 12:19:00
 | CL N2 | 22 | 560 | 575 | 42.7 | 43.9 | 0.6 | 2001-11-13 12:19:00
 | CL Q2 | 22 | 565 | 585 | 40.5 | 41.9 | 0.57 | 2001-11-13 12:19:00
 | CL U2 | 22 | 570 | 590 | 38.8 | 40.2 | 0.55 | 2001-11-13 12:19:00
 | [NAME] | 22 | 570 | 590 | 36.8 | 38.1 | 0.52 | 2001-11-13 12:19:00
 | CL X2 | 22 | 570 | 590 | 35.3 | 36.6 | 0.5 | 2001-11-13 12:19:00
 | [NAME] | 22 | 590 | 595 | 35.3 | 35.6 | 0.49 | 2001-11-13 12:19:00
 | CL M3 | 21.5 | 565 | 590 | 29.1 | 30.4 | 0.4 | 2001-11-13 12:19:00
 | CL Z3 | 21.5 | 565 | 595 | 25.8 | 27.2 | 0.36 | 2001-11-13 12:19:00
Spreadsheet: 861040d1709039844-is-there-a-function-that-returns-the-address-of-the-selected-cell-multiple-dependent-drop-down-lists-copy
Sheet: Sheet1

 |  |  |  |  |  |  | Formula in H8
 |  |  |  |  |  |  | SORT(UNIQUE(XLOOKUP(A8,Table1[#Headers],Table1),,TRUE))
Order Log
[NAME] | Customer |  | [NAME] | [NAME] | Ava |  | Filtered List
[NAME] |  |  | ABC Groceries | Shop & Stop | Saveway
Ava |  |  | Wholesome Foods | ACME Bites | [NAME] |  | ALDO
[NAME] |  |  | Trader Bow's | Food Tiger | [NAME] |  | Discount Foods
 |  |  | Discount Foods | Kostko | Meyer, Inc. |  | Mini Food Stores
 |  |  | ALDO | Amazone |  |  | Pam's Club
 |  |  | Mini Food Stores | Dollar Captain |  |  | Trader Bow's
 |  |  | Pam's Club |  |  |  | Wholesome Foods
Spreadsheet: 137934d1327434968-excel-count-text-values-based-on-date-example
Sheet: Sheet1

EXAMPLE 1
 |  |  |  |  | Date of App | Date of Contract |  |  |  |  |  |  |  |  |  | App to Contract
[NAME] |  |  |  |  | 2011-11-02 00:00:00 | 2011-11-09 00:00:00
[NAME] |  |  |  |  | 2011-11-09 00:00:00 | -
[NAME] |  |  |  |  | 2011-11-08 00:00:00 | 2011-11-24 00:00:00
[NAME] |  |  |  |  | - | 2011-11-10 00:00:00
[NAME] |  |  |  |  | 2011-11-08 00:00:00 | 2011-11-10 00:00:00
[NAME] |  |  |  |  | 2011-11-10 00:00:00 | 2011-11-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average:
EXAMPLE 2
 | Funded? |  |  |  |  |  |  |  |  |  | Date of Contract
[NAME] | No |  |  |  |  |  |  |  |  |  | 2011-11-09 00:00:00
[NAME] | Yes |  |  |  |  |  |  |  |  |  | 2011-11-24 00:00:00
[NAME] | Yes |  |  |  |  |  |  |  |  |  | 2011-11-11 00:00:00
[NAME] | No |  |  |  |  |  |  |  |  |  | 2011-11-18 00:00:00
[NAME] | Yes |  |  |  |  |  |  |  |  |  | 2011-10-28 00:00:00
[NAME] | No |  |  |  |  |  |  |  |  |  | 2011-11-14 00:00:00