tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 485086d1476701028-return-all-product-names-listed-against-a-single-account-excel-help-example
Sheet: Sold Deal Data range

Account ID | Name | Stage | Close Date | Annual Recurring Revenue | Offset? | Contract End Date | Account Name | Product Name
0013000000pW7M0AAK | Customer Name 2 | 7-Won | 2013-10-31 00:00:00 |  | Yes | 2016-10-23 00:00:00 | Customer 1 | Product 1
0013000000pW7IdAAK | Customer Name 3 | 7-Won | 2016-05-06 00:00:00 | 7000 |  | 2016-10-31 00:00:00 | Customer 2 | Product 2
0013000000pVzx2AAC | Customer Name 4 | 7-Won | 2016-06-30 00:00:00 | 0 | No | 2016-10-31 00:00:00 | Customer 3 | Advisory Product 1
0013000000rUCXmAAO | Customer Name 5 | 7-Won | 2016-09-12 00:00:00 | 26000 |  | 2016-10-31 00:00:00 | Customer 4 | Advisory Product 2
0013000000rUCXmAAO | Customer Name 6 | 7-Won | 2016-09-13 00:00:00 | 26001 |  | 2016-11-01 00:00:00 | Customer 5 | DR  Product
0013000000qVBxnAAG | Customer Name +++++ | 7-Won | 2014-12-24 00:00:00 | 7200 | Yes | 2016-11-30 00:00:00 | Customer 6 | RM  Product
Spreadsheet: 734092d1621970913-index-match-formula-to-conditionally-compile-missing-data-index-match-formula-to-pull-missing-data-example
Sheet: BUD

Column1 | Column2 | Column3 | Column4
Concat | Revenue Type | Product | Customer
 | Issue Fee | Product A | Customer A
 | Saleable Item | Product B | Customer A
 | Saleable Item | Product A | Customer A
 | Issue Fee | Product A | Customer B
 | Saleable Item | Product C | Customer Y
 | Saleable Item | Product C | Customer X
 | Issue Fee | Product C | Customer G
 | Issue Fee | Product C | Customer H
 | Issue Fee | Product C | Customer I
 | Saleable Item | Product C | Customer K
 | Issue Fee | Product C | Customer A
Spreadsheet: c96ce448-51f2-4ab5-bf6a-d8ac48c078e5
Sheet: Sheet1

Release: Regional and State Employment and Unemployment (Seasonally Adjusted) | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=250
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-04-17 1:48 PM CDT
 | Real-Time | Period
Name: | Start | End
Regional and State Employment and Unemployment (Seasonally Adjusted) | 2012-01-24 00:00:00 | Current
Link:
[NAME] | 2012-01-24 00:00:00 | Current
Source:
Federal Reserve Bank of St. Louis | 2012-01-24 00:00:00 | Current
Notes:
Bureau of Labor Statistics data that is seasonally adjusted by the | 2012-01-24 00:00:00 | Current
Federal Reserve Bank of St. Louis.
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2012-01-24 00:00:00
2012-03-13 00:00:00
2012-03-30 00:00:00
2012-04-20 00:00:00
2012-05-18 00:00:00
2012-06-15 00:00:00
2012-07-20 00:00:00
2012-07-23 00:00:00
2012-08-17 00:00:00
2012-09-21 00:00:00
2012-10-19 00:00:00
2012-11-20 00:00:00
2012-12-21 00:00:00
2013-01-18 00:00:00
2013-03-18 00:00:00
2013-03-29 00:00:00
2013-04-19 00:00:00
2013-05-16 00:00:00
2013-05-17 00:00:00
2013-06-20 00:00:00
2013-06-21 00:00:00
2013-07-19 00:00:00
2013-08-19 00:00:00
2013-09-20 00:00:00
2013-11-22 00:00:00
2013-12-20 00:00:00
2014-01-28 00:00:00
2014-03-17 00:00:00
2014-03-28 00:00:00
Spreadsheet: 102297d1300254688-view-data-based-on-multiple-matching-criteria-similar-occurence-numbers
Sheet: Sheet1

Name | Score
[NAME] | 9 |  |  |  | [NAME]
[NAME] | 6 |  |  |  | [NAME]
[NAME] | 9 |  |  |  | [NAME]
[NAME] | 9
[NAME] | 9
[NAME] | 9
[NAME] | 7
[NAME] | 3
Spreadsheet: 767298d1644400465-list-of-people-that-i-want-to-calculate-how-many-days-they-have-left-until-end-date-enddate
Sheet: English

September |  |  |  |  | Calculation date
 |  | Start date | End date |  | 2021-09-30 00:00:00 | The correct answer would be
 | Anne | 2021-01-01 00:00:00 |  |  |  | 30 |  |  | The maximum is 30 days
 | [NAME] | 2021-03-01 00:00:00 | 2021-08-01 00:00:00 |  |  | 0 |  |  | If the end date has arrived then it should be calculated and if it is> but Calculation day then max 30
 | [NAME] | 2021-08-07 00:00:00 | 2021-10-31 00:00:00 |  |  | 30 |  |  | Sometimes there is a End date that is more than a month in advance, but the maximum in that case will be 30, exept if it is less then month in atvansed
 | Sigrid | 2020-03-18 00:00:00 |  |  |  | 30 |  |  | The formula must be such that it works on all parties and also that if the names / dates are changed, the formula works on them
 | [NAME] | 2019-03-31 00:00:00 | 2021-09-02 00:00:00 |  |  | 2
 |  |  |  |  |  |  |  |  | Red is wrong and is not working
Oktobere
 |  | Upphafsdagur | Lokadagur |  | 2021-10-31 00:00:00 | The correct answer would be |  |  | If the End date has passed, an error occurs
 | Anne | 2021-01-01 00:00:00 |  |  |  | 30
 | [NAME] | 2021-03-01 00:00:00 | 2021-08-01 00:00:00 |  |  | 0
 | [NAME] | 2021-08-07 00:00:00 | 2021-10-31 00:00:00 |  |  | 30
 | Sigrid | 2020-03-18 00:00:00 |  |  |  | 30
 | [NAME] | 2019-03-31 00:00:00 | 2021-09-02 00:00:00 |  |  | 0
November
 |  | Upphafsdagur | Lokadagur |  | 2021-11-30 00:00:00 | The correct answer would be
 | Anne | 2021-01-01 00:00:00 |  |  |  | 30
 | [NAME] | 2021-03-01 00:00:00 | 2021-08-01 00:00:00 |  |  | 0
 | [NAME] | 2021-08-07 00:00:00 | 2021-10-31 00:00:00 |  |  | 0
 | Sigrid | 2020-03-18 00:00:00 |  |  |  | 30
 | [NAME] | 2019-03-31 00:00:00 | 2021-09-02 00:00:00 |  |  | 0
Spreadsheet: 152716d1335480390-if-statement-returning-part-of-a-cell-between-special-characters-copy-of-if_statement_results_between_chars
Sheet: Sheet1 (2)

data:
 | <Application>ABCHOST</Application>_x000D_
 | <StatusKind>Pass</StatusKind>_x000D_
 | <MsgId>[PHONE]</MsgId>_x000D_
 | <StatusCode>0</StatusCode>_x000D_
 | <IssueTime>2012-04-19 10:05:00:000</IssueTime>_x000D_
 | <Application>DEFGHOST</Application>_x000D_
 | <StatusKind>Fail</StatusKind>_x000D_
 | <MsgId>2468</MsgId>_x000D_
 | <StatusCode>1950</StatusCode>_x000D_
 | <IssueTime>2012-04-19 10:05:00:000</IssueTime>_x000D_
Spreadsheet: 270361d1381446224-eliminate-choices-from-drop-box-as-they-are-used-drop-list-example
Sheet: Week 17

 | 2013 Football Pool
 | Week #1 |  |  | Picks / Priority |  |  |  |  |  |  |  |  |  |  | Points
 | Games | Points | W | [NAME] | [NAME] | Doug | [NAME] | Justin | Scott | [NAME] | Sohaib | Adam | Dale |  | [NAME] | [NAME] | Doug | [NAME] | Justin | Scott | [NAME] | Sohaib | Adam | Dale
1 | New Orleans
 | Green Bay
2 | Pittsburgh
 | Baltimore
3 | Cincinnati
 | Cleveland
4 | Indianapolis
 | Houston
5 | Tennessee
 | Jacksonville
6 | Buffalo
 | Kanas City
7 | Atlanta
 | Chicago
8 | Detroit
 | Tampa Bay
9 | Philadelphia
 | St. Louis
10 | N.Y. Giants
 | Washington
11 | Carolina
 | Arizona
12 | Seattle
 | San Franciso
13 | Minnesota
 | San Diego
14 | Dallas
 | N.Y. Jets
15 | New England
 | Miami
16 | Oakland
 | Denver
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Doug | [NAME] | Justin | Scott | [NAME] | Sohaib | Adam | Dale
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Weak 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 40eac055-0f3a-4bec-aec0-7006b48d7f2f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 82. Value of Building Approved, Chain Volume Measures, Original - South Australia
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total houses ;  New ; |  |  | Original | A590507C | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total other residential building ;  New ; |  |  | Original | A590508F | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total residential building ;  New ; |  |  | Original | A590509J | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590510T | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590511V | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590512W | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590513X | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 718538d1613177761-improve-on-countifs-result-numbers-first-seen
Sheet: Sheet1

 | NO# | Has Not Appeared in the last 20
 | 50
 | 50
 | 71
 | 50
 | 71
 | 50
 | 71
 | 50
 | 50
 | 50
 | 50
 | 71
 | 50
 | 71
 | 71
 | 71
 | 71
 | 71
 | 71
 | 42
 | 71
 | 42
 | 71
 | 50
 | 50
 | 50
 | 42
 | 42
 | 42
 | 42
 | 42
 | 42
 | 42
 | 42
 | 42
 | 42
 | 42
 | 66
 | 42
 | 66
 | 42
 | 10
 | 42
 | 10
 | 42
 | 10
 | 42
 | 42
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 56
 | 56
 | 56
 | 56
 | 56
 | 56
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 66
 | 15
 | 15
 | 15
 | 30
 | 15
 | 15
 | 15
 | 15
 | 15
 | 15
 | 15
 | 15
 | 15
 | 15
 | 30
 | 15
 | 30
 | 15
 | 30
 | 15
 | 30
 | 15
 | 30
 | 15
 | 30
 | 15
 | 30
 | 15
 | 30
 | 15
 | 30
 | 15
 | 30
 | 30
 | 30
 | 30
 | 30
 | 30
 | 30
 | 30
 | 30
 | 30
 | 30
 | 30
 | 30
 | 2
 | 30
 | 2
 | 30
 | 2
 | 30
 | 2
 | 2
 | 30
 | 2
 | 30
 | 2
 | 30
 | 2
 | 30
 | 2
 | 30
 | 2
 | 30
 | 2
 | 30
 | 2
 | 30
 | 2
 | 30
 | 2
 | 30
 | 2
 | 30
 | 2
 | 30
 | 2
 | 30
 | 30
 | 2
 | 30
 | 2
 | 30
 | 30
 | 30
 | 30
 | 30
 | 30
 | 30
 | 8
 | 30
 | 30
 | 30
 | 30
 | 30
 | 30
 | 30
 | 30
 | 30
 | 30
 | 8
 | 8
 | 8
 | 8
 | 8
 | 8
 | 8
 | 8
 | 8
 | 8
 | 8
 | 8
 | 8
 | 8
 | 8
 | 8
 | 8
 | 8
 | 8
 | 8
 | 8
 | 8
 | 54
 | 8
 | 54
 | 54
 | 54
 | 8
 | 54
 | 54
 | 8
 | 54
 | 8
 | 4
 | 4
 | 8
 | 8
 | 8
 | 8
 | 54
Spreadsheet: 164497d1340797212-duplicate-entries-need-to-be-deleted-after-checking-date-book3small
Sheet: Sheet1

KNUMBER | Coverage | [NAME] | EXP DATE
36 | NBD AUR | EK SCAN ST 520EX | 2014-09-30 00:00:00 |  | Sheet is sorted by KNUMBER. After an update from  another File
36 | NBD AUR | EK SCAN ST 520EX | 2013-09-30 00:00:00 |  | It happens that there  can be multiple entries!
37 | NBD AUR | EK SCAN ST 520EX | 2014-09-30 00:00:00 |  | I need to DELETE these entries from this sheet (the  MASTER)
38 | NBD AUR | EK SCAN ST 520EX | 2014-09-30 00:00:00
39 | NBD AUR | EK SCAN ST 520EX | 2014-09-30 00:00:00 |  | Any KNUMBER that has a LATER EXP(iry) Date Remains
40 | NBD AUR | EK SCAN ST 520EX | 2014-09-30 00:00:00 |  | the other 2 or 3 entries need to be deleted
Spreadsheet: 542474d1507882694-extracting-rows-based-on-user-input-example-13-
Sheet: Output By Size

Source | [NAME] | A | B | C | D | E | F | G | H | Area | Customer Segment | Customer Segment | Value 1 | Loading | Value 2 | Value 3 | Value 4 | Value 5 | Value 6 | Value 7 | Value 8 | Value 9 | Value 10 | Value 11
Spreadsheet: 733692d1621714958-xlookup-to-return-cell-based-on-multiple-criteria-in-single-column-example-2-
Sheet: Solution

 | 2021 | 2022 | 2023
Direct Labor
Labor Category 1 | 1 | 2 | 3
Labor Category 2 | 4 | 5 | 6
Labor Category 3 | 7 | 8 | 9
Fringe
Labor Category 1 | 0.01 | 0.02 | 0.03
Labor Category 2 | 0.04 | 0.05 | 0.06
Labor Category 3 | 0.07 | 0.08 | 0.09
Facility
Labor Category 1 | 0.04 | 0.05 | 0.06
Labor Category 2 | 0.07 | 0.08 | 0.09
Labor Category 3 | 0.01 | 0.02 | 0.03
Overhead
Labor Category 1 | 0.07 | 0.08 | 0.09
Labor Category 2 | 0.01 | 0.02 | 0.03
Labor Category 3 | 0.04 | 0.05 | 0.06
Spreadsheet: 880600d1728409059-how-to-transform-number-into-default-ip-book1-toplisek-popipipo
Sheet: Sheet1

9
91
910
9810
98810
988810
9888810
98888810
988888810
Spreadsheet: phillip_allen__29922__south center oaks sales sheet
Sheet: Sheet1

FOR SALE |  |  |  |  |  |  | THE SMITH COMPANY
 |  |  |  |  |  |  | REAL ESTATE SERVICES
South Center Oaks Apartments |  |  |  |  |  |  | 9400 Circle Drive
805 South Center Street |  |  |  |  |  |  | [NAME],  Texas  78736
Austin, Texas |  |  |  |  |  |  | CONTACT:  JEFF SMITH
 |  |  |  |  |  |  | (512)394-0908
PRICE: |  |  |  |  |  |  | (512)394-0913 Fax
1595000
 |  |  |  |  | RATIOS:
PROPERTY INFORMATION: |  |  |  |  | Price\Unit:
Number of Units: |  | 44 |  |  | Price\S.F.:
Net Rentable Area: |  | 23320 |  |  | Rent\Sq. Ft.
Number of Stories: |  | 2 |  |  | Expenses\Unit: |  | 2528
Number of Buildings: |  | 2 |  |  | Expenses\Sq. Ft.
Land Area: |  | 38,736 sq. ft. |  |  | Gross Rent Multiplier:
Year Built: |  | 1982 |  |  | [NAME]:
Exterior: |  | Wood and brick
Roof: |  | Pitched comp. Shingles |  |  | Proforma Income and Expenses:
HVAC: |  | Individual units |  |  | Gross Rental Income
Electricity: |  | Separately metered |  |  | Less V & C: (5.00%)
Gas: |  | Master - Laundry Only |  |  | Effective Gross Income
Hot Water: |  | Individual units |  |  | Other Income (2.00%)
Occupancy: |  | 0.9 |  |  | Total Income
Amenities: |  | Laundry Room |  |  | Less Operating Expenses:
 |  | Ref |  |  | Net Operating Income:
 |  |  |  |  | Less Debt Service |  | 99625
 |  |  |  |  | Cash Flow
PROFORMA UNIT MIX AND RENT SCHEDULES:
 |  | Unit | Total | Rent\ | Total | Rent\
Unit Type | # [NAME] | Sq. Ft. | Sq. Ft. | Month | Rent | Sq. Ft. |  |  |  |  | 12
1\1 | 44 | 530 |  | 600
Totals\Ave.
Loan Details: | New loan must be obtained
Comments: | Good location in [NAME].  Upside in rents and better management.
 | Excellent cash on cash return.
The information herein, while based upon information supplied by the owner and from other sources deemed reliable, is not in any way warranted by
The Smith Co. or the owner of the property and is presented prior to sale, change in price, or removal from the market without notice.  Interested
persons are encouraged to retain legal and technical consultants to advise them of any and all aspects of this property.  This information is provided
for your use as long as you have need of it, but at all times remains the property of The Smith Co.  Under no circumstances is any part of this
report to be reproduced, copied or in any way duplicated without the express written consent of The Smith Company.
Spreadsheet: 940787c8-1225-45b8-856e-f8b2a4e1e2f3
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
OCC2 | Test | OCC2 | Occupational Panel # 2 | Occupational Panel # 2 | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL Additional Information: See Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
OCC2 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
OCC2 | Result | OCC2 | Occupational Panel # 2 | Occupational Panel # 2 | Numeric |  |  |  |  | kU/L
Spreadsheet: 741899d1627401384-vlookup-cant-figure-it-out-vlookup-example
Sheet: Sheet1

ID1 | ID 2 | Name |  | Name | New ID
12345 | 987654 | Example_bv |  | Example | 5463271
349872 | 1987364 | Test_cd |  | Test | 43281734
6374595 | 192834 | Sample_se |  | Sample | 4958632
Spreadsheet: 136211d1326473786-how-to-merge-multiple-lines-on-a-time-sheet-sched-time-sheet-integration-4-
Sheet: Schedule

Site 1 |  | 2012-01-01 00:00:00
Random Location, Anytown |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | M | T | W | T | F | S | Totals
1 | Employee 1 | 19:00:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00
1 | Employee 1 |  |  | 21:30:00 | 23:59:00 | 00:01:00 | 07:00:00
2 | Employee 2 |  |  |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00 | 17:30:00 | 23:59:00 | 00:01:00 | 07:00:00
2 | Employee 2 |  |  |  |  |  |  |  |  |  |  | 17:30:00 | 23:59:00 | 00:01:00 | 00:30:00
3 | Employee 3 | 13:00:00 | 19:00:00 | 17:30:00 | 21:30:00 |  |  |  |  |  |  |  |  | 16:30:00 | 23:59:00
4 | Employee 4 | 00:01:00 | 13:00:00
5 | Employee 5 |  |  |  |  |  |  |  |  |  |  |  |  | 00:30:00 | 09:00:00
Site 2 |  | 2012-01-01 00:00:00
Random Location, Anytown |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | M | T | W | T | F | S | Totals
6 | Employee 6 | 21:00:00 | 23:59:00 | 00:01:00 | 07:00:00 |  |  | 21:00:00 | 23:59:00 | 00:01:00 | 07:00:00
7 | Employee 7 |  |  | 21:00:00 | 23:59:00 | 00:01:00 | 07:00:00
8 | Employee 8 |  |  |  |  | 21:00:00 | 23:59:00 | 00:01:00 | 07:00:00 | 21:00:00 | 23:59:00 | 00:01:00 | 07:00:00
Spreadsheet: 151912d1335184107-excel-2007-problem-with-a-vlookup-if-example
Sheet: Sheet1

2:00-10:00 | AAOffice | Galab | A | NP | BBF |  | PRO |  |  | Presto | MCOM |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | B | 1 | 1 | 1 | 1 | 1 | 1 | 1 | L | L | 1 | L | B2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
7:30 - 12:00 | AAOffice | Sonia |  | NP |  | HBF | PRO |  |  |  |  | STFD |  |  | 1 | 1 | 1 | 1 | 1 | 1 | B | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
7:30 - 3:30 | AAOffice | Ana |  |  |  | HBF | PRO |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | B | 1 | 1 | 1 | 1 | 1 | 1 | 1 | L | L | 1 | 1 | 1 | 1 | 1 | 1 | B2 | 1 | 1 | 1 | 1
8:00 - 4:00 | AAH | [NAME] |  | NP |  | HBF |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | B | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | L | L | 1 | 1 | 1 | 1 | 1 | 1 | 1 | B2 | 1 | 1 | 1 | 1 | 1
8:00 - 4:00 | AAH | [NAME] | A | NP | BBF |  | PRO |  |  | Presto | MCOM |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | B | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | L | L | 1 | 1 | 1 | 1 | 1 | 1 | B2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
7:00 - 3:00 | AAOffice | Galab | A |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | B
8:00 - 4:00 | AAH | [NAME] | A |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1
8:00 - 4:00 | AAOffice | [NAME] | A |  |  |  |  |  |  |  |  |  |  |  |  |  | T | T | T | T | T
9:00 - 5:00 | AAOffice | [NAME] | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
9:00 - 5:00 | AAOffice | [NAME] | A |  |  |  |  |  |  |  |  |  |  |  |  |  | T | T | T | T | T
9:00 - 5:00 | AAH | [NAME] | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
9:00-1:00 - 4:00 -8:00 | AAH | Monika S | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
10:00 - 6:00 | AAH | [NAME] | A
10:00 - 6:00 | AAH | [NAME] | A
12:00 - 8:00 | AAOffice | Simone I | A
10:00 - 6:00 | AAOffice | [NAME] | A |  |  |  |  |  |  |  |  |  |  |  |  |  | T | T | T | T | T
12:00 - 8:00 | AAOffice | [NAME] | A |  |  |  |  |  |  |  |  |  |  |  |  |  | T | T | T | T | T
7:00 - 3:00 | AAOffice | Galab |  | NP |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | B | 1
7:30 - 12:00 | AAOffice | Sonia |  | NP |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
8:00 - 4:00 | AAH | [NAME] |  | NP |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
8:00 - 4:00 | AAH | [NAME] |  | NP |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | B
9:00 - 5:00 | AAOffice | [NAME] |  | NP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
9:00 - 5:00 | AAH | [NAME] |  | NP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
10:00 - 6:00 | AAH | [NAME] |  | NP
10:00 - 6:00 | AAH | [NAME] |  | NP
10:00 - 8:00 | AAH | [NAME] |  | NP
5:00 - 3:00 | AAOffice | [NAME] |  | NP |  |  |  |  |  |  |  |  | 1 | 1 | P | P | P | P | P | R | P | P
Spreadsheet: 24672d1215374670-help-splitting-data-1-column-to-multiple-copytransposeloop
Sheet: Sheet1

[NAME] |  |  |  | 3681A Sacramento St.
Calegari & Associates |  |  |  | San Francisco CA 94118
http://www.calegarisfrealestate.com |  |  |  | [PHONE]
 |  |  |  | [EMAIL]
[NAME] |  |  |  | 1699 Van Ness Ave.
TRI Coldwell Banker |  |  |  | San Francisco CA 94109
http://www.californiamoves.com |  |  |  | [PHONE]
 |  |  |  | [EMAIL]
[NAME] |  |  |  | 117 Greenwich St.
Sotheby's International Realty |  |  |  | San Francisco CA 94111
http://www.sothebyshomes.com |  |  |  | [PHONE]
 |  |  |  | [EMAIL]
[NAME] |  |  |  | 3681A Sacramento St.
Calegari & Associates |  |  |  | San Francisco CA 94118
http://www.calegarisfrealestate.com |  |  |  | [PHONE]
 |  |  |  | [EMAIL]
[NAME] |  |  |  | 1699 Van Ness Ave.
TRI Coldwell Banker |  |  |  | San Francisco CA 94109
http://www.californiamoves.com |  |  |  | [PHONE]
 |  |  |  | [EMAIL]
[NAME] |  |  |  | 117 Greenwich St.
Sotheby's International Realty |  |  |  | San Francisco CA 94111
http://www.sothebyshomes.com |  |  |  | [PHONE]
 |  |  |  | [EMAIL]
[NAME] |  |  |  | 3681A Sacramento St.
Calegari & Associates |  |  |  | San Francisco CA 94118
http://www.calegarisfrealestate.com |  |  |  | [PHONE]
 |  |  |  | [EMAIL]
[NAME] |  |  |  | 1699 Van Ness Ave.
TRI Coldwell Banker |  |  |  | San Francisco CA 94109
http://www.californiamoves.com |  |  |  | [PHONE]
 |  |  |  | [EMAIL]
[NAME] |  |  |  | 117 Greenwich St.
Sotheby's International Realty |  |  |  | San Francisco CA 94111
http://www.sothebyshomes.com |  |  |  | [PHONE]
 |  |  |  | [EMAIL]
[NAME] |  |  |  | 3681A Sacramento St.
Calegari & Associates |  |  |  | San Francisco CA 94118
http://www.calegarisfrealestate.com |  |  |  | [PHONE]
 |  |  |  | [EMAIL]
[NAME] |  |  |  | 1699 Van Ness Ave.
TRI Coldwell Banker |  |  |  | San Francisco CA 94109
http://www.californiamoves.com |  |  |  | [PHONE]
 |  |  |  | [EMAIL]
[NAME] |  |  |  | 117 Greenwich St.
Sotheby's International Realty |  |  |  | San Francisco CA 94111
http://www.sothebyshomes.com |  |  |  | [PHONE]
 |  |  |  | [EMAIL]
Spreadsheet: 67597d1268168348-multiple-if-thens-example
Sheet: Sheet1

 | REPORT | NO:
 | [NAME] | STATUS
 | DATE: | 2010-03-08 00:00:00
 | STATUS/LOCATION: | SB0100
 |  | DCN | TRANDT
 |  | 2175980345 | 2010-03-06 00:00:00
 |  | 2125321300 | 2010-03-06 00:00:00
 |  | 65789046304 | 2010-03-09 00:00:00
 |  | 78987085060 | 2010-03-08 00:00:00
 |  | 76506079 | 2010-03-08 00:00:00
 |  | 2135470 | 2010-03-09 00:00:00
 | Junk
 | Status/Location | SL1380
 |  | DCN | TRANDT
 |  | 7809060 | 2010-02-03 00:00:00
 |  | 13131 | 2010-02-03 00:00:00
 |  | 177500 | 2010-02-03 00:00:00
 |  | 313030 | 2010-02-03 00:00:00
 | Status/Location | SM9870
 |  | DCN | TRANDT
 |  | 123780 | 2010-05-07 00:00:00
 |  | 357000 | 2010-05-07 00:00:00
 |  | 21780 | 2010-05-07 00:00:00
 |  | 24780 | 2010-05-07 00:00:00