tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 134660d1325552768-reorganize-database-test_010212
Sheet: test database

name and spouse | dob | dob spouse
AGARWAL abhay and KANVINDE rupal P | 1984-01-01 00:00:00 | 1984-06-01 00:00:00
AGGARWAL manoj and MEI tina | 1980-04-01 00:00:00 | 1981-02-01 00:00:00
[NAME] and BHATTY [NAME] | 1975-09-01 00:00:00 | 1979-10-01 00:00:00
AIELLO brian J and [NAME] | 1965-09-01 00:00:00 | 1968-04-15 00:00:00
need data as
AGARWAL abhay | 1984-01-01 00:00:00
KANVINDE rupal P | 1984-06-01 00:00:00
AGGARWAL manoj | 1980-04-01 00:00:00
MEI tina | 1981-02-01 00:00:00
[NAME] | 1975-09-01 00:00:00
BHATTY [NAME] | 1979-10-01 00:00:00
AIELLO brian | 1965-09-01 00:00:00
[NAME] | 1968-04-15 00:00:00
This is what I got.
ADEL FARID and CARMEN LYDIA | 1951-01-04 00:00:00 | 1950-01-04 00:00:00 |  |  | seq | name | dob
ADEL MYRIAM | 1985-06-25 00:00:00 |  |  |  | 11 | #N/A | 1900-01-01 00:00:00
ADEL WALID | 1967-01-01 00:00:00 |  |  |  | 11 | #N/A | 1900-01-01 00:00:00
AGARWAL AKHIL and KANVINDE SHAMBHAVI P | 1984-01-30 00:00:00 | 1984-06-19 00:00:00 |  |  | 12 | #N/A | 1900-01-01 00:00:00
AGGARWAL NIKHIL and MEI YI | 1978-04-24 00:00:00 | 1979-02-08 00:00:00 |  |  | 12 | #N/A | 1900-01-01 00:00:00
AHMED FARRUKH and BHATTY AMAL L | 1975-09-06 00:00:00 | 1981-10-12 00:00:00 |  |  | 13 | #N/A | 1900-01-01 00:00:00
AIELLO FRED J and DCRUZ ADELE M | 1962-09-23 00:00:00 | 1960-06-19 00:00:00 |  |  | 13 | #N/A | 1900-01-01 00:00:00
ALAGAPPAN ALAGUKANNAN | 1983-03-03 00:00:00 |  |  |  | 14 | #N/A | 1900-01-01 00:00:00
ALAGURAJ MELCHIZEDEK and [NAME] PRAKASINI | 1978-08-30 00:00:00 | 1980-09-17 00:00:00 |  |  | 14 | #N/A | 1900-01-01 00:00:00
ALCORTA RICHARD G and AUGUSTINA | 1950-09-08 00:00:00 | 1953-07-15 00:00:00
Spreadsheet: 92696d1292261486-update-project-list-by-department-pulling-the-list-from-another-tab-capital-projects-report
Sheet: RawData

Timestamp | Project Name | Department | Project Number | Priority | Date | Total Project Cost | Description | Justification | Contact Person | Type of Project | Useful Life | Category | Funding Source #1 | Funding Source #2 | Funding Source #3 | Funding Source #4 | Funding Source #5 | Expenditure #1 | Expenditure #2 | Expenditure #3 | Expenditure #4 | Expenditure #5 | Total Expentitures | Funding Source #1 Amount | Funding Source #2 Amount | Funding Source #3 Amount | Funding Source #4 Amount | Funding Source #5 Amount | Expenditure #1 Amount | Expenditure #2 Amount | Expenditure #3 Amount | Expenditure #4 Amount | Expenditure #5 Amount | key
2010-10-28 09:07:42 | Test Project | Administration | test project #1 | 5 | 2011 | 1000000
2010-10-28 09:08:16 | Test project | Administration | Test project #2 | 3 | 2011 | 2000000
2010-10-28 09:08:52 | Test Project | Administration | test project #3 | 1 | 2014 | 10000000
2010-10-29 10:48:44 | Test Leisure | Leisure Services | test leisure #1 | 1 | 2014 | 1
2010-10-29 10:49:23 | Test storm drain | Storm Drain | storm drain #1 | 4 | 2015 | 500000
2010-10-29 10:50:10 | Test power | Power | power #1 | 2 | 2013 | 1000
2010-10-29 10:50:35 | Test power | Power | power #2 | 3 | 2013 | 2000
2010-10-29 10:50:54 | Test power | Power | power #3 | 1 | 2012 | 100000000
2010-12-02 07:34:19 | test administration | Administration | 1 | 1 | 2011 | 8000000 | This is a test for Administration | To see if this works |  | test project | 1 year | System Improvements/Infrastructure | CDBG | Capital-General | Department |  |  | 3000000 |  |  |  |  | 5000000
2010-12-02 07:36:55 | Fire Test | Fire | 2 | 2 | 2012 | 1000000 | Test for fire | to see if this works |  | Fire apparatus | 15 years | Option 2 | Grants |  |  |  |  | 500000 | 500000 |  |  |  | 1000000
2010-12-02 07:38:48 | test public works | Public Works | #3 | 3 | 2013 | 10000000 | test for public works | to see if this works | [NAME] | street | 20 years | Option 4 | Safetlieu | capital-streets |  |  |  | 2000000 | 8000000 |  |  |  | 10000000
2010-12-02 07:46:48 | test water project | Water | 4 | 5 | 2015 | 15000000 | Test for water | To see if this works | [NAME] | Water | 20 years | Option 3 | RDA | Capital-water |  |  |  | plans | Construction | Follow up |  |  | 15000000 | 5000000 | 10000000 |  |  |  | 1000000 | 10000000 | 4000000
Spreadsheet: 5ca22c18-3781-4eee-afb2-becd8033d933
Sheet: Student Success

Achieve 2015
Student Success
Increase the number of students graduating, transferring, or completing a workforce credential by 50%, including increasing the success of students from underserved populations by 75%.
 | 2007-2008 | 2008-2009 | 2009-2010 | 2010-2011 | 2011-2012 | 2012-2013 | 2013-2014 | 2014-2015 |  |  |  | 2007-2008 | 2008-2009 | 2009-2010 | 2010-2011 | 2011-2012 | 2012-2013 | 2013-2014 | 2014-2015
Students1 | 31347 | 35616 | 43550 | 46209 |  |  |  |  |  |  | Students1 | 607 | 636 | 709 | 816
 | 46965 | 46965 | 46965 | 46965 | 46965 | 46965 | 46965 | 46965
 | 2007-2008 | 2008-2009 | 2009-2010 | 2010-2011 | 2011-2012 | 2012-2013 | 2013-2014 | 2014-2015 |  |  |  | 2007-2008 | 2008-2009 | 2009-2010 | 2010-2011 | 2011-2012 | 2012-2013 | 2013-2014 | 2014-2015
Graduates |  |  |  |  |  |  |  |  |  |  | Graduates
 | 15491 | 16476 | 18333 | 22460 |  |  |  |  |  |  |  | 417 | 436 | 475 | 531
Transfers |  |  |  |  |  |  |  |  |  |  | Transfers
 | 10633 | 11523 | 13144 | 16256 |  |  |  |  |  |  |  | 177 | 177 | 200 | 225
Completed a Workforce Credential |  |  |  |  |  |  |  |  |  |  | Completed a Workforce Credential
 | 4267 | 5265 | 5821 | 7493 |  |  |  |  |  |  |  | 13 | 23 | 34 | 60
Total2 |  |  |  |  |  |  |  |  |  |  | Total2
 | 31347 | 35616 | 43550 | 46209 |  |  |  |  |  |  |  | 607 | 636 | 709 | 816
1,2 Duplicated student count across Graduates, Transfers, and Workforce Credential. |  |  |  |  |  |  |  |  |  |  | Transfer incomplete data
 |  |  |  |  |  |  |  |  |  |  | 1,2 Duplicated student count across Graduates, Transfers, and Workforce Credential.
Spreadsheet: 884389d1733512540-convert-txt-file-with-entries-on-every-line-to-separate-columns-ef-1431149
Sheet: Sheet1

[NAME] |  | header1 | header2 | [NAME] | header4 |  |  | header1 | header2 | [NAME] | header4
manchester |  |  |  |  |  |  |  |  | manchester | 1975-02-01 00:00:00 | 0.36
1975-02-01 00:00:00 |  |  |  |  |  |  |  | karen_black | portsmouth | 1992-03-01 00:00:00 | 0.23
0.36 |  |  |  |  |  |  |  | david_smith | chelsea | 1945-01-01 00:00:00 | 0.76
karen_black
portsmouth
1992-03-01 00:00:00
0.23
david_smith
chelsea
1945-01-01 00:00:00
0.76
Spreadsheet: 289274d1389475998-solver-constraints-help-solver-problem
Sheet: Solver

Group 1
Staff Name
A | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1
B | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1
C | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1
D | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1
E | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1
F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F
G | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F
Crews avail to work | 5 | 4 | 3 | 3 | 3 | 3 | 4 | 5 | 5 | 4 | 3 | 3 | 3 | 3 | 4 | 5
Crews on days off | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2
Crews on leave | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Crews Required | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Average
3.75
Group 2
Staff Name
A | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1
B | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1
C | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F
D | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F
E | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1
F | 1 | F | F | F | 1 | 1 | 1 | 1 | 1 | F | F | F | 1 | 1 | 1 | 1
G
Crews avail to work | 4 | 3 | 3 | 3 | 5 | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 5 | 4 | 4 | 4
Crews on days off | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 2
Crews on leave | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Crews Required | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
average
3.75
Spreadsheet: 739979d1626109141-returning-a-value-to-a-summary-page-from-multiple-sheets-excel-tracker
Sheet: 2

Date | 1 Point Value | Outlay (£) | Outlay (Points)
2021-07-01 00:00:00 | 20 | 160
2021-07-02 00:00:00 | 20 | 90
2021-07-03 00:00:00 | 20 | 192
2021-07-04 00:00:00 | 20 | 120
2021-07-05 00:00:00 | 20 | 0
2021-07-06 00:00:00 | 20 | 70
2021-07-07 00:00:00 | 20 | 0
2021-07-08 00:00:00 | 20 | 160
2021-07-09 00:00:00 | 20 | 130.64
2021-07-10 00:00:00 | 20 | 240
2021-07-11 00:00:00 | 20 | 0
2021-07-12 00:00:00 | 20 | 20
2021-07-13 00:00:00 | 20 | 20
2021-07-14 00:00:00 | 20 | 0
2021-07-15 00:00:00 | 20 | 0
2021-07-16 00:00:00 | 20 | 0
2021-07-17 00:00:00 | 20 | 0
2021-07-18 00:00:00 | 20 | 0
2021-07-19 00:00:00 | 20 | 0
2021-07-20 00:00:00 | 20 | 0
2021-07-21 00:00:00 | 20 | 0
2021-07-22 00:00:00 | 20 | 0
2021-07-23 00:00:00 | 20 | 0
2021-07-24 00:00:00 | 20 | 0
2021-07-25 00:00:00 | 20 | 0
2021-07-26 00:00:00 | 20 | 0
2021-07-27 00:00:00 | 20 | 0
2021-07-28 00:00:00 | 20 | 0
2021-07-29 00:00:00 | 20 | 0
2021-07-30 00:00:00 | 20 | 0
2021-07-31 00:00:00 | 20 | 0
July | 20
Spreadsheet: 147711d1332940699-count-cells-with-text-primjer-za-formulu
Sheet: Sheet1

 |  | Customers | Category
 |  | Customer 1 | LOCAL
 |  | Customer 2 | KEY
 |  | Customer 3 | CORPORATE
 |  | Customer 4 | CORPORATE
 |  | Customer 5 | CORPORATE
 |  | Customer 6 | LOCAL
 |  | Customer 7 | LOCAL
 |  | Customer 8 | LOCAL
 |  | Customer 9 | KEY
 |  | Customer 10 | LOCAL
 |  | Customer 11 | KEY
 |  | Customer 12 | CORPORATE
 |  | Customer 13 | LOCAL
 |  | Customer 14 | LOCAL
 |  | Customer 1 | LOCAL
 |  | Customer 2 | KEY
 |  | Customer 3 | CORPORATE
 |  | Customer 11 | KEY |  |  | How many LOCAL Customers
 |  | Customer 12 | CORPORATE |  |  | How many KEY Customers
 |  | Customer 13 | LOCAL |  |  | How many CORPORATE Customers
 |  | Customer 3 | CORPORATE
 |  | Customer 4 | CORPORATE
 |  | Customer 5 | CORPORATE
Spreadsheet: 771754d1646833755-calculation-based-on-dropdown-selection-data-validation
Sheet: Sheet1

1
2 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | Yearly | Semi Annualy | Quarterly
3
4 | [NAME] | 5 | 10 | 15 | 20 | 5 | 10 | 15 | 20 | 25 | 5 | 10 | 15
5
6
 |  | Yearly |  | Yearly
 |  | Semi Annually
 |  | Quarterly
 |  | JAN
 |  | FEB
 |  | MAR
 |  | APR
 |  | MAY
 |  | JUN
 |  | JUL
 |  | AUG
 |  | SEP
 |  | OCT
 |  | NOV
 |  | DEC
Spreadsheet: 713428d1610715779-vlookup-to-return-multiple-results-in-one-line-vlookup-formula-ans
Sheet: Main sheet

E-mail | Criticality
[EMAIL]
[NAME]
[EMAIL]
Hi
I need a VLOOKUP function that will compare e-mail addresses on sheet "main sheet", column A with E-mail addresses on sheet " Data sheet" column D and return the corresponding data  "Data Sheet" column A on sheet "main sheet" column B.
I used this formula on "main sheet", =VLOOKUP(A2;'Data Sheet'!$A:$E;2;TRUE) - see attached example
but I need the result to have all possible results.
Thus multiple results in one line. Meaning if it was critical for [email][EMAIL][/email] in row 1 and Medium in row 3, then both to show in "main sheet" column b
Thanks for the assistance
Spreadsheet: 305abcbf-e0c2-4b2a-9a96-aea88939b6ae
Sheet: Conv-Conforming Fixed Rate

 |  | TIB-The Independent BankersBank |  |  |  | .25 cost to Price to Waive Escrows
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-09-12 09:33:18.270000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.515 | 101.39 | 101.265 | 100.89
3.75 | 101.13 | 101.005 | 100.88 | 100.505 |  | Note: | Refer To Price [NAME]
3.625 | 100.719 | 100.594 | 100.469 | 100.094 |  |  | For all Price Adjs
3.5 | 100.081 | 99.956 | 99.831 | 99.206
3.375 | 99.206 | 99.081 | 98.956 | 98.331
3.25 | 98.249 | 98.124 | 97.999 | 97.374
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 101.755 | 101.63 | 101.505 | 101.13
3.25 | 101.397 | 101.272 | 101.147 | 100.772
3.125 | 101.057 | 100.932 | 100.807 | 100.432
3 | 100.729 | 100.604 | 100.479 | 100.104
2.875 | 100.098 | 99.973 | 99.848 | 99.223
2.75 | 99.398 | 99.273 | 99.148 | 98.523
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-09-26 09:33:18.270000
30 DAY | 2012-10-11 09:33:18.270000
45 DAY | 2012-10-26 09:33:18.270000
60 DAY | 2012-11-10 09:33:18.270000
90 DAY | 2012-12-10 09:33:18.270000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 149266d1333789475-excel-2003-when-printing-add-1-record-of-deliverys
Sheet: Department 002

Record of Deliverys
Referance Number | Date | Time | Name of [NAME] | Number of Boxes / Pallets | Delivery Note Y/N | Name | Sign | Notes
Dep02-001
Dep02-002
Dep02-003
Dep02-004
Dep02-005
Dep02-006
Dep02-007
Dep02-008
Dep02-009
Dep02-010
Dep02-011
Dep02-012
Dep02-013
Dep02-014
Spreadsheet: 771673d1646787257-make-a-new-table-but-removing-all-the-rows-that-have-a-zero-value-in-a-column-example
Sheet: Invoice

Residential Total:
Sum 1: |  |  | 250 | $50 charge | $50 charge | $50/revision
Project ID # | Due | Notes | Initial Design Date | [NAME]? | Complex? | # of Revisions | Final Design Date
43771 | 50 | Revisions (2/11) | 2021-08-03 00:00:00 |  | X | 1 | 2021-09-22 00:00:00
44931 | 100 | CO + Revisions (3/7) | 2021-08-03 00:00:00 | X |  | 1 | 2021-11-25 00:00:00
Spreadsheet: 765203d1643209073-slow-array-formula-test-run-sheet-file-3
Sheet: RUN SHEET

Depot Name |  |  |  |  |  |  | Week Commencing |  |  | 001a
 |  |  |  |  |  |  |  |  | Current Insp Week
MONDAY |  | IF REPORTING DELAYS DUE TO TRAFFIC, PLEASE ENTER EXACT LOCATION
[NAME] used today |  |  |  |  | Drivers Name
Returning Trailer Number: |  |  |  |  |  | Trailer MOT Date: |  |  | Trailer Insp Number:
Have you left your Trailer hooked up? |  |  | Y  or N | Please confirm your vehicle/[NAME] is EMPTY |  |  |  | Y or N | Amount of fuel drawn
depart site | depart time | Arr Time | To Site | PLANZ Code | Stream |  | load carried | Comment section, IE reason for running late |  |  |  | helper | depart site | depart time | Arr Time | To Site | PLANZ Code
 |  |  |  |  |  |  |  | .
 |  |  |  |  |  |  |  | Unhook Unit and Trailer
Any other comments section:
Spreadsheet: 121556d1316149308-consolidate-data-from-multiple-tabs-in-the-same-excel-file-copy-of-new
Sheet: Consolidated

Name | Total Hours
FMEA01_Studies | 700
FMEA01_PT | 999
FMEA01_CM | 0
FMEA01_Others | 1099
FMEA02_Studies | 1025
FMEA02_PT | 100
FMEA02_CM | 0
FMEA02_Others | 0
FMEA03_Studies | 0
FMEA03_PT | 10
FMEA03_CM | 0
FMEA03_Others | 0
FMEA04_Studies | 0
FMEA04_PT | 10
FMEA04_CM | 0
FMEA04_Others | 0
FMEA05_Studies | 10
FMEA05_PT | 0
FMEA05_CM | 0
FMEA05_Others | 10
FMEA06_Studies | 500
FMEA06_PT | 0
FMEA06_CM | 0
FMEA06_Others | 200
Spreadsheet: 470141d1468350571-vlookup-but-with-images-myexcelsheet
Sheet: Sheet1

Country | Flag
Australia | ??
Chile | ??
China | ??
Colombia | ??
Croatia | ??
Finland | ??
Brazil | ??
Canada | ??
France | ??
England | ??
Germany | ??
Spreadsheet: 55182d1255353070-how-to-automatically-alter-formula-when-filters-are-applied-malchemist-2
Sheet: 31525

Date of Order | Date of Order | Year Of Order | Month Of Order | Item No. | Description | Quantity | [NAME] value £ | Order Number | Contract
20080707 | 2008-07-07 | 2008 | 7 | 218345 | Universal vacuum cleaner [NAME] | 1 | 384.449999999999 | 123617 | 31525
20080811 | 2008-08-11 | 2008 | 8 | 274919 | Diamond coring tool DD 110-D TPS 110V | 1 | 447.18 | 123617 | 31525
20080708 | 2008-07-08 | 2008 | 7 | 305755 | Rotary hammer TE 16-C 110V | 1 | 324.55 | 123617 | 31525
20080707 | 2008-07-07 | 2008 | 7 | 312265 | Slitting machine DC SE20 110V [NAME] | 1 | 637.73 | 123617 | 31525
Spreadsheet: 482611d1475148739-finding-highest-lowest-values-over-a-set-date-period-heighest-values-over-last-15-days
Sheet: Sheet1

Date | Company | Value
2016-08-01 00:00:00 | A | -6
2016-08-02 00:00:00 | A | -6
2016-08-03 00:00:00 | B | -10
2016-08-04 00:00:00 | A | 0
2016-08-05 00:00:00 | B | 8
2016-08-08 00:00:00 | A | 6
2016-08-09 00:00:00 | B | 4
2016-08-10 00:00:00 | A | 0
2016-08-11 00:00:00 | B | 2
2016-08-12 00:00:00 | A | 10
2016-08-15 00:00:00 | B | 2
2016-08-16 00:00:00 | A | -10
2016-08-17 00:00:00 | B | -7
2016-08-18 00:00:00 | A | 5
2016-08-19 00:00:00 | B | 8
2016-08-22 00:00:00 | A | 0
2016-08-23 00:00:00 | B | 2
2016-08-24 00:00:00 | A | 3
2016-08-25 00:00:00 | B | -9
2016-08-26 00:00:00 | A | 0
2016-08-30 00:00:00 | B | 4
2016-08-31 00:00:00 | A | 0
2016-09-01 00:00:00 | B | 6
2016-09-02 00:00:00 | A | 10
2016-09-05 00:00:00 | B | 8
2016-09-06 00:00:00 | A | -4
2016-09-07 00:00:00 | B | -4
2016-09-08 00:00:00 | A | 0
2016-09-09 00:00:00 | B | -8
2016-09-12 00:00:00 | A | -8
2016-09-13 00:00:00 | B | -1
2016-09-14 00:00:00 | A | 1
2016-09-15 00:00:00 | B | 4 |  | Heighest Value for Company B over the last 15 days
2016-09-16 00:00:00 | A | 2
2016-09-19 00:00:00 | B | 0
2016-09-20 00:00:00 | A | -2
2016-09-21 00:00:00 | B | -4
2016-09-22 00:00:00 | A | 4
2016-09-23 00:00:00 | B | 0
2016-09-26 00:00:00 | A | -12
2016-09-27 00:00:00 | B | -6
2016-09-28 00:00:00 | A | 8 |  | Heighest Value for Company A over the last 15 days
Spreadsheet: 326892d1403289380-concatenate-variable-ranges-of-character-strings-xor
Sheet: Sheet2

ACCIDENT_ID | KILLED | INJURED
111 | 0 | 0
111 | 0 | 0
111 | 0 | 0
1112 | 1 | 0
1112 | 1 | 0
1112 | 1 | 0
1111 | 1 | 1
1111 | 1 | 0
1111 | 0 | 1
1113 | 0 | 0
1113 | 0 | 0
1113 | 0 | 0
1114 | 1 | 0
1114 | 1 | 0
1114 | 1 | 0
1115 | 0 | 1
1115 | 0 | 1
1115 | 0 | 1
1116 | 1 | 0
1116 | 0 | 1
1116 | 0 | 1
1117 | 2 | 1
1117 | 2 | 1
1117 | 2 | 1
1118 | 1 | 3
1118 | 0 | 1
1118 | 0 | 2
1119 | 1 | 1
1119 | 1 | 0
1119 | 0 | 1
1120 | 0 | 0
1120 | 1 | 0
1120 | 0 | 0
1120 | 0 | 0
1121 | 1 | 4
1121 | 1 | 4
1122 | 0 | 1
1122 | 1 | 0
1122 | 0 | 1
1122 | 0 | 0
1123 | 0 | 0
1123 | 9 | 0
1123 | 1 | 6
1123 | 2 | 0
1124 | 3 | 1
1124 | 2 | 1
1124 | 2 | 3
1125 | 2 | 1
1125 | 1 | 0
1125 | 1 | 0
 | 0 | 1
Spreadsheet: 721973d1614968809-if-formula-to-derive-future-date-project-tracking-experimental
Sheet: Project 

Created Date | Project Location |  |  | Project Title / Description |  | PO # / Date |  | Terms |  |  | Project Manager |  |  | Customer Project Manager
 |  |  |  | Experimental Test Project for Letter 2 |  | 2020-12-30 00:00:00 |  | BOD ? |  | Direct KP | Name |  |  | Name
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 |  |  |  | BMS Job # |  | PO# |  | COM |  |  | Phone |  |  | Phone
Forecast Project Costs & Profit |  |  |  | Permits Required ? |  | Proj. Close Date |  | Proj. Duration |  | Delay Reason (If Applicable) |  |  | Days In Our Court | Warranty Period |  | 1
Sold Price |  |  |  | Actual Project Costs & Profit |  | 2020-12-25 00:00:00 |  |  |  |  |  |  |  | LEAD DAYS | Order Date | Date Expected
Total Price With CO's |  |  |  |  |  | CO Explaination |  |  |  | Equipment Lead Time
CO 1 | CO Number |  |  | CO 1 Cost
CO 2 | CO Number |  |  | CO 2 Cost
Total CO Price |  |  |  | Total CO Cost
Profit |  |  |  | Actual Profit |  |  | CO Profit
Percentage |  |  |  | Actual Percentage |  |  | [NAME]
Projected Total Project Cost |  |  |  | Actual Total Cost
Projected Equipment Cost |  |  |  | Actual Equipment Cost
Projected Sub Contractor Cost |  |  |  | Actual Sub Contractor Cost
Equipment Vendors |  |  |  | Equipment Description |  |  |  |  |  |  |  | Original Quote | Additional Costs | Submittal |  | PO #
Sub Contractors |  |  |  | Sub Contractor Scope
 |  |  |  |  |  |  |  |  | Lift Plan Required |  |  | Original Quote | Additional Cost | Change Orders |  | PO #
Engineering / Coring / Testing and BOD |  |  |  |  |  | BOD REQUIRED |  |  | Permit Required |  |  |  |  |  |  |  | NULL | CO1 | CO2
Mechanical
 |  |  |  |  |  |  |  |  |  | Permit
 |  |  |  |  |  |  |  |  |  | Permit
Electrical
 |  |  |  |  |  |  |  |  |  | Permit
 |  |  |  |  |  |  |  |  |  | Permit
Sheet Metal & Duct
Controls
Rigging & Crane
Pipe Fitting
 |  |  |  |  |  |  |  |  |  | Permit
 |  |  |  |  |  |  |  |  |  | Permit
Plumbing
 |  |  |  |  |  |  |  |  |  | Permit
 |  |  |  |  |  |  |  |  |  | Permit
Balancing
Insulation
Fire & Sprinkler
 |  |  |  |  |  |  |  |  |  | Permit
 |  |  |  |  |  |  |  |  |  | Permit
Cleaning & Misc
Spreadsheet: 717085d1612469160-if-leap-year-formula-timesheet-template-sample-
Sheet: Jun-Jul

 | Name: |  |  |  |  |  |  | Supervisor:
 |  |  | Start | End | (Position) | (Position) | TOTAL HOURS | Comments | Substitute | [NAME] | Personal Leave | Other | Holiday
 | Total Hours
 |  |  |  |  |  | Check
 |  |  |  |  |  |  |  | OVERTIME |  | SL | PL | Other | Holiday
 | LAST week/LAST Month
 | Week 1
 | Week 2
 | Week 3
 | Week 4
 | Week 5
 | TOTALS
 | Check
Spreadsheet: 600760d1543940206-word-key-word-identification-from-list-word-identification
Sheet: Gender

http://gender-decoder.katmatfield.com/static/documents/Gaucher-Friesen-Kay-JPSP-Gendered-Wording-in-Job-ads.pdf
 | Masculine |  | Feminine
 | Active |  | Affectionate
 | Adventurous |  | Child_x0001_
 | Aggress_x0001_ |  | Cheer_x0001_
 | Ambitio_x0001_ |  | Commit_x0001_
 | Analy_x0001_ |  | Communal
 | Assert_x0001_ |  | Compassion_x0001_
 | Athlet_x0001_ |  | Connect_x0001_
 | Autonom_x0001_ |  | Considerate
 | Boast_x0001_ |  | Cooperat_x0001_
 | Challeng_x0001_ |  | Depend_x0001_
 | Compet_x0001_ |  | Emotiona_x0001_
 | Confident |  | Empath_x0001_
 | Courag_x0001_ |  | Feminine
 | Decide |  | Flatterable
 | Decisive |  | Gentle
 | Decision_x0001_ |  | Honest
 | Determin_x0001_ |  | Interpersonal
 | Dominant |  | Interdependen_x0001_
 | Domina_x0001_ |  | Interpersona_x0001_
 | Force_x0001_ |  | Kind
 | Greedy |  | Kinship
 | Headstrong |  | Loyal_x0001_
 | Hierarch_x0001_ |  | Modesty
 | Hostil_x0001_ |  | Nag
 | Implusive |  | [NAME]_
 | Independen_x0001_ |  | Pleasant_x0001_
 | Individual_x0001_ |  | Polite
 | Intellect_x0001_ |  | Quiet_x0001_
 | Lead_x0001_ |  | Respon_x0001_
 | Logic |  | Sensitiv_x0001_
 | Masculine |  | Submissive
 | Objective |  | Support_x0001_
 | Opinion |  | Sympath_x0001_
 | Outspoken |  | Tender_x0001_
 | Persist |  | Together_x0001_
 | Principle_x0001_ |  | Trust_x0001_
 | Reckless |  | Understand_x0001_
 | Stubborn |  | Warm_x0001_
 | Superior |  | Whin_x0001_
 | Self-confiden_x0001_ |  | Yield_x0001_
 | Self-sufficien_x0001_
 | Self-relian_x0001_