tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 628268d1560473792-help-calendar-correction-employee-absence-schedule-current-6-13-19
Sheet: March

 | Employee Absence Schedule
 | Absence Type Key | V | Vacation |  |  | P | Pick Up Shift |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
 | March | Dates of Absence/Pick up |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019
 | Employee Name | 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 |  |  |  | Vacation Days Available | Total Vacation  Days Taken | Total Days Picked up | Total Sick Days
 | [NAME] | s
 | Lynda
 | [NAME]
 | Heather |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | p |  |  |  |  |  | v | v
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | p
 | Emili |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s |  |  |  |  |  |  | p
 | Amber
 | Meredith
 | Julie
Spreadsheet: 824122d1680313963-flag-4th-consecutive-occurrence-of-a-word-formuladogpt
Sheet: Sheet1

[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
magab
magab
magab
magab
magab
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
magab
magab
magab
magab
magab
Spreadsheet: 493358d1481671738-how-to-have-the-titles-in-2-cells-send-data-from-3rd-cell-to-a-4th-cell-on-another-sheet-forum-help
Sheet: Sheet1

Code |  |  | FOREMAN | JOURNEYMAN | APPRENTICE | LABORER
2000 | UNDERGROUND PLUMBING
2005 | U/G DEMO
2010 | TRENCHING
2020 | BACKFILL
2030 | U/G WASTE & VENT
2040 | U/G WATER
2050 | U/G GAS
2060 | U/G STORM DRAIN
2070 | U/G TESTING
2080 | SETTING DRAINS
2110 | U/G FIXTURE SET
2115 | SAND
 | Top Out
3000 | TOP OUT PLUMBING
3005 | T/O DEMO
3030 | T/O WASTE
3035 | T/O VENT
3040 | T/O WATER PIPING
3045 | PIPING INSULATION
3050 | T/O GAS PIPING
3055 | W/H VENTS
3057 | FLASHINGS
3060 | T/O STORM DRAIN
3065 | ROOF DRAINS
3070 | T/O TESTING
3075 | T/O FIXTURE SUPPORT
3080 | T/O TUBS & VALVES
3090 | B-VENT
3100 | CONDENS/DRAIN
3110 | SYRUP SWEEPS
3120 | BEER SWEEPS
3200 | WETSIDE MECH.
3300 | VACUUM
3305 | NITROGEN
3400 | COMPRESSED AIR
3405 | Supports
3500 | MEDICAL GAS
3520 | TESTING MED. GAS
3530 | MED. GAS CERT.
3600 | FIRE CAULKING
3700 | LIGHT WEIGHT CORING
3800 | BACKING
3900 | STEAM
Spreadsheet: 18167578-9d3b-476a-b583-05d6eca73d3d
Sheet: Sheet1

CCE PUBLIC OE TIER 3 COURSE COST WORKSHEET | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  |  |  |  | Updated for August 2012
(for internal use only)
 |  |  |  |  | *Input figures in orange shaded areas only
Course Name:
Course #:
Term Beginning:
Worksheet Prepared by:
Date Prepared: |  |  | 2013-02-08 00:00:00
Expenses/Costs |  |  |  |  |  | Notes: |  | Recommendations:
Course Development
1. Instructor Rate for Development (Labor, Prep) |  |  |  |  |  | Flat Fee (or P/Hour below) |  | (If applicable)
 | (*Either Flat Fee OR Per Hour, Not both) |  |  |  |  | Instructor Fee per Hour |  | (If applicable)
 |  |  |  |  |  | Development Hours |  | (If applicable)
 | TOTAL Development |  |  | 0
Instruction |  |  | Part Time Instructor
2a.  [NAME] |  |  |  | 0 |  | CCE Cost per Hour | 0 | *REQUIRED
 | (*modify formula in E22 if flat fee) |  |  |  |  | Contact Hours: | 0 | *REQUIRED
2b.  Instructor Benefits |  |  |  | 0 |  | Based on PT Instructor (7.65%)
 | TOTAL Instruction |  |  | 0
Equipment Fees
3a. Computer Lab Fees |  |  |  |  |  |  |  | (If applicable)
3b. Other Equipment Fees (installation, setup, etc) |  |  |  |  |  |  |  | (If applicable)
 | TOTAL Fees |  |  | 0
Cost of Material Goods
4a.  Instructor Packet and/or Materials |  |  |  |  |  |  |  | *REQUIRED
4b.  Certificates |  |  |  | 0 |  | Price PP |  | *REQUIRED
4c.  Book Cost |  |  |  | 0 |  | List Cost PP |  | *REQUIRED
4d.  Shipping & Handling (total) |  |  |  | 0 |  |  |  | *REQUIRED
4e. Tax |  |  |  | 0 |  | (NOTE: Delete formula in field if not used) |  | (If applicable)
4f.  Other Materials (CDs, guides, handouts, etc) |  |  |  |  |  |  |  | (If applicable)
[NAME] (if applicable) |  |  |  |  |  |  |  | (If applicable)
 | TOTAL Cost of Goods |  |  | 0
Marketing & Promotion
5. Marketing Costs |  |  | Printing | 0
 |  |  | Mail Prep | 0
 |  |  | Postage | 0
 |  |  | Advertising | 0
 |  |  | Other | 0
 | TOTAL Marketing |  |  | 0
 |  |  | Total Costs | 0
Potential FTE
 |  |  | Contact Hours | 0
 |  |  | Anticipated # Students | 0
 |  |  | Potential FTE | 0
Potential OE Funding Earned |  |  |  | 0
OE funding needed to reimburse expenses |  |  |  | 0
 | (includes percentage of admin expenses)
 |  |  | Total Surplus | 0
Spreadsheet: 866802d1713721343-extract-data-from-another-worksheet-excluding-rows-without-data-pem-register_-_complied_21april-2024
Sheet: Dataset

Plant, Equipment & Machinery Details |  |  |  |  |  |  |  |  |  |  | Inspection & Maintenance Details
No | Type / Category | Description  (as per LM, LP or other equipment certification where available) | Make & Model | Serial No | Equipment ID | Hirer  Company (Trade Partner / Vendor) | Owner of Equipment | Date first mobilized | Last Date on site | Current Status | Statutory Registration No. (LM, LP, AR, etc) | Certification [NAME] | Inspection / Serviving Frequency | Last Inspection / Servicing Date | Next Inspection / Servicing Due Date | PIC | Remarks
Spreadsheet: 770791d1646252633-working-time-directive-calculations-time-sheet
Sheet: Tables

Week Beginning |  | Sheets | Monday
2021-11-08 00:00:00 | 1 |  |  |  |  | Working Time Directive
 | 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
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
 | 66
 | 67
 | 68
 | 69
 | 70
 | 71
 | 72
 | 73
 | 74
Spreadsheet: 844080d1695893621-little-help-with-excel-formatting-cadet-masterlist-draft-2
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  | Count of School | Column Labels
 |  |  |  |  |  |  |  |  |  |  |  |  | Row Labels | HARREN | IMC | MSI | PDG | SYNERGY | Grand Total
 |  |  |  |  |  |  |  |  |  |  |  |  | AIFCP |  |  |  | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | AIMS | 2 |  |  | 17 | 4 | 23
 |  |  |  |  |  |  |  |  |  |  |  |  | AIMS | 1 |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | CELTEC |  |  | 1 |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | CLCST |  |  |  | 2 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | CU |  |  |  | 2 | 1 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | DMMA | 10 |  | 5 | 10 | 1 | 26
 |  |  |  |  |  |  |  |  |  |  |  |  | HOLY CROSS OF DAVAO |  |  |  | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | IGCFI |  |  |  |  | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | JBL |  |  |  | 2 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | 1 | 1 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | JRMSU |  |  | 1 |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | LPU | 2 | 1 | 1 | 18 | 6 | 28
 |  |  |  |  |  |  |  |  |  |  |  |  | MAAP | 2 |  | 2 | 22 | 3 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  | MIDWAY |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | MIT |  |  |  | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | MPC |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | MPCF |  |  |  | 6 | 1 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  | MPCS |  |  |  | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | MU | 1 |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | OLFU |  |  |  | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | PIMSAT |  |  | 1 |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | PMMS |  |  |  | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | TIP - ML | 1 |  |  | 5 | 1 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  | TIP - QC |  |  | 2 | 5 | 2 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  | TIP- ML |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | UA |  |  | 1 |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | UC |  |  |  | 2 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | UC-METC |  |  |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | UI |  |  | 1 |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | UPHSL |  |  |  | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | WBC | 2 |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | ZSCMST | 2 |  |  | 3 |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | (blank)
 |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 23 | 1 | 15 | 102 | 26 | 167
 |  |  |  |  |  |  |  |  |  |  |  |  | NOT IDENTIFIED | 9
Spreadsheet: ba52f0a0-87c7-4e7b-b974-676aa3d58c53
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
PIGE | Test | PIGE | Pig Epithelium, IgE | Pig Epithelium, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in 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
PIGE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
PIGE | Result | PIGE | Pig Epithelium, IgE | Pig Epithelium, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6262-0 | Swine epithelium [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 583899d1532725139-count-function-with-multiple-qualifying-criteria-fruit
Sheet: Key

Food | Category
pizza | entree
apple | fruit
burger | meat
coke | drink
orange | fruit
banana | fruit
peas | vegetables
salad | vegetables
hot dog | meat
chicken | meat
platter | entree
sandwich | entree
Spreadsheet: 80279d1280446404-replace-remove-exact-words-advfiltdel
Sheet: Sheet1

list | list |  |  |  |  | col b must have same heading as col a in this example "list"
something | *MAIL ORDER ITEMS (PACKAGE)* |  |  |  |  | put a * at each end of items in col b
STORE USE SUPPLIESxxxxx | *STORE USE SUPPLIES* |  |  |  |  | then data /filter /advanced filter
something | *CONTAINMENT - HOUSES* |  |  |  |  | list range | a1:a20
STORE USE SUPPLIES |  |  |  |  |  | criteria range | b1:b4
something |  |  |  |  |  | filter list in place | check th box
something |  |  |  |  |  | click ok
something
something |  |  |  |  |  | you can now select all the rows and delete
CONTAINMENT - HOUSES |  |  |  |  |  | (click on the row number and move down to select first; then right click delete
something
something
xxxxxCONTAINMENT - HOUSES
xxx MAIL ORDER ITEMS (PACKAGE)xxxxxx
MAIL ORDER ITEMS (PACKAGE)
something
something
something
something
something
Spreadsheet: louise_kitchen__23052__North America Nov 15
Sheet: SPECIALREPORT -1

TRADE DATE | NA GAS | NA POWER | US EAST GAS | US CENTRAL GAS | US WEST GAS | US NYMEX GAS | US TEXAS GAS | US EAST POWER | US CENTRAL POWER | US WEST POWER | CAN EAST GAS | CAN WEST GAS | CAN POWER | TOTAL TRADE CNT
2001-11-15 00:00:00 | 2862 | 1096 | 736 | 671 | 483 | 769 | 54 | 600 | 1 | 485 | 23 | 126 | 10 | 5168
2001-11-14 00:00:00 | 2588 | 872 | 627 | 438 | 440 | 873 | 44 | 447 | 3 | 404 | 12 | 154 | 18 | 5254
2001-11-13 00:00:00 | 2332 | 933 | 532 | 527 | 509 | 580 | 74 | 436 | 5 | 484 | 12 | 98 | 8 | 4819
2001-11-12 00:00:00 | 2632 | 833 | 670 | 586 | 479 | 746 | 54 | 711 | 3 | 111 | 28 | 69 | 8 | 4786
2001-11-11 00:00:00 | 29 | 10 | 0 | 0 | 0 | 29 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 41
2001-11-10 00:00:00 | 14 | 17 | 0 | 0 | 0 | 14 | 0 | 17 | 0 | 0 | 0 | 0 | 0 | 31
2001-11-09 00:00:00 | 1839 | 784 | 469 | 356 | 329 | 540 | 29 | 467 | 1 | 303 | 32 | 84 | 13 | 3662
2001-11-08 00:00:00 | 2388 | 941 | 525 | 199 | 399 | 1052 | 55 | 714 | 1 | 210 | 15 | 143 | 16 | 4396
2001-11-07 00:00:00 | 3587 | 1596 | 786 | 688 | 800 | 1003 | 51 | 934 | 7 | 644 | 66 | 193 | 11 | 6178
2001-11-06 00:00:00 | 3852 | 1581 | 955 | 837 | 695 | 1005 | 74 | 1005 | 5 | 563 | 61 | 225 | 8 | 6345
2001-11-05 00:00:00 | 4040 | 1607 | 981 | 806 | 714 | 1122 | 79 | 883 | 8 | 705 | 48 | 290 | 11 | 6550
2001-11-04 00:00:00 | 43 | 10 | 0 | 0 | 0 | 43 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 54
2001-11-03 00:00:00 | 29 | 32 | 0 | 0 | 0 | 29 | 0 | 32 | 0 | 0 | 0 | 0 | 0 | 61
2001-11-02 00:00:00 | 3792 | 1205 | 994 | 867 | 787 | 750 | 81 | 681 | 6 | 502 | 45 | 268 | 16 | 5860
2001-11-01 00:00:00 | 4042 | 1498 | 1002 | 858 | 697 | 1075 | 90 | 983 | 11 | 495 | 58 | 262 | 9 | 6617
Spreadsheet: vkaminski__40793__Evaluation Form Chris
Sheet: Sheet1

CANDIDATE EVALUATION FORM
Candidate: | Interviewer:
Requisition No. | Reports to:
Position: | Date:
Rate Candidate according to scale (5=highest, 1=lowest) in the following areas:
Customer Relations/Dealmaking | 5 | 4 | 3 | 2 | 1
Comments: | Build Relationships, Account Management, [NAME],
 | Select quality customers, Anticipate needs, Develop new ways to serve
 | customer, Propose workable deals, Negotiations, Closing.
Leadership/Visionary | 5 | 4 | 3 | 2 | 1
Comments: | Initiative, Motivating, Focus on results, Visionary thinking, Coaching,
 | Decision making, Performance measurement.
Industry Knowledge/Dealmaking | 5 | 4 | 3 | 2 | 1
Comments: | Knowledgeable about energy industry;  financial background,
 | physical  background.
Technical Knowledge/Financial/Derivatives | 5 | 4 | 3 | 2 | 1
Comments: | Specific to function, ability to learn and train others.
Strategic Skills/Innovation/Connecting/Leveraging: | 5 | 4 | 3 | 2 | 1
Comments: | Defining customer's problem/opportunity, [NAME] solve,Logical/
 | Analytical thought process, Product Development,Sees big picture,
 | Sees & defines new business opportunities.
Teamwork/Communications | 5 | 4 | 3 | 2 | 1
Comments: | Oral/Written communications,listening, team player, involves others,
 | shares information, values contributions.
Other Comments:
Overall Rating: | 5 | 4 | 3 | 2 | 1
 | [NAME] |  | Acceptable |  | Don't [NAME]
Obstacles to hiring this candidate:
Would  you like this candidate on your team: | Yes |  | No
Refer to other area:
Please return to:   [NAME] EB3669b
Spreadsheet: 593323d1539093441-return-true-false-na-when-comparing-between-multiple-columns-between-2-rows-equipment
Sheet: After

Equipment Plate No. | Old ID Number | New ID Number | Location Tag | Reason | ID number belong to same equipment and location
A5678 | - | 89 | Side Cover | Equipment Arrival | NA
A1234 | - | 86 | Side Cover | Equipment Arrival | NA
A5678 | 89 |  | Side Cover | Maintenance | True
A1234 | 89 |  | Side Cover | Maintenance | False
Spreadsheet: 100966d1299166747-shifting-graphs-example
Sheet: Sheet1

Month | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00
Values | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 5 | 5 | 100 | 200
Spreadsheet: john_griffith__16213__1_31_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL H2 | 19 | 146 | 156 | 49.2 | 52.6 | 0.61 | 2002-01-31 12:39:00
 | CL J2 | 19.5 | 250 | 260 | 47 | 48.9 | 0.59 | 2002-01-31 12:39:00
 | CL K2 | 19.5 | 325 | 340 | 46.2 | 48.4 | 0.58 | 2002-01-31 12:39:00
 | CL M2 | 20 | 375 | 390 | 44.4 | 46.2 | 0.57 | 2002-01-31 12:39:00
 | CL N2 | 20 | 415 | 435 | 43.2 | 45.3 | 0.56 | 2002-01-31 12:39:00
 | CL Q2 | 20 | 445 | 460 | 42.1 | 43.6 | 0.54 | 2002-01-31 12:39:00
 | CL U2 | 20 | 465 | 485 | 40.8 | 42.6 | 0.52 | 2002-01-31 12:39:00
 | [NAME] | 20 | 475 | 490 | 38.7 | 40 | 0.49 | 2002-01-31 12:39:00
 | CL X2 | 20 | 480 | 495 | 36.9 | 38.1 | 0.47 | 2002-01-31 12:39:00
 | [NAME] | 20 | 480 | 500 | 35.2 | 36.7 | 0.45 | 2002-01-31 12:39:00
 | CL F3 | 20 | 490 | 515 | 34.3 | 36 | 0.44 | 2002-01-31 12:39:00
 | CL G3 | 20 | 495 | 520 | 33.2 | 34.9 | 0.43 | 2002-01-31 12:39:00
 | CL M3 | 20.5 | 535 | 555 | 30.8 | 31.9 | 0.4 | 2002-01-31 12:39:00
 | CL Z3 | 20.5 | 535 | 565 | 26.8 | 28.3 | 0.36 | 2002-01-31 12:39:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 105724d1302988088-data-lookups-timesheet-0411
Sheet: Data Cells

 |  | [NAME] | Higher | Basic
mon | 07-16 | 0 | 0 | 8.5
mon | 08-17 | 0 | 0 | 8.5
mon | 16-01 | 8.5 | 0 | 0
mon | 17-02 | 8.5 | 0 | 0
mon | 17-04 | 0 | 0 | 0
mon | 22-07 | 8.5 | 0 | 0
tue | 07-16 | 0 | 0 | 8.5
tue | 08-17 | 0 | 0 | 8.5
tue | 16-01 | 8.5 | 0 | 0
tue | 17-02 | 8.5 | 0 | 0
tue | 17-04 | 0 | 0 | 0
tue | 22-07 | 8.5 | 0 | 0
wed | 07-16 | 0 | 0 | 8.5
wed | 08-17 | 0 | 0 | 8.5
wed | 16-01 | 8.5 | 0 | 0
wed | 17-02 | 8.5 | 0 | 0
wed | 17-04 | 0 | 0 | 0
wed | 22-07 | 8.5 | 0 | 0
thu | 07-16 | 0 | 0 | 8.5
thu | 08-17 | 0 | 0 | 8.5
thu | 16-01 | 8.5 | 0 | 0
thu | 17-02 | 8.5 | 0 | 0
thu | 17-04 | 0 | 0 | 0
thu | 22-07 | 8.5 | 0 | 0
fri | 07-16 | 0 | 0 | 8.5
fri | 08-17 | 0 | 0 | 8.5
fri | 16-01 | 8.5 | 0 | 0
fri | 17-02 | 8.5 | 0 | 0
fri | 17-04 | 0 | 0 | 0
fri | 22-07 | 8.5 | 0 | 0
sat | 07-16 | 8.5 | 0 | 0
sat | 08-17 | 8.5 | 0 | 0
sat | 16-01 | 7.5 | 1 | 0
sat | 17-02 | 6.5 | 2 | 0
sat | 17-04 | 6.5 | 4 | 0
sat | 22-07 | 2 | 6.5 | 0
[NAME] | 07-16 | 0 | 8.5 | 0
[NAME] | 08-17 | 0 | 8.5 | 0
[NAME] | 16-01 | 1 | 7.5 | 0
[NAME] | 17-02 | 2 | 6.5 | 0
[NAME] | 17-04 | 0 | 0 | 0
[NAME] | 22-07 | 6.5 | 2 | 0
Spreadsheet: 756371d1637487773-find-unique-values-on-multiple-criteria-and-between-dates-2112021-sample-file
Sheet: Sheet1

Date | StaffName | SalaryCriteria | LWPDays | RetLWPSalary
2021-10-31 00:00:00 | GSD | RET | 0 | 50000 |  |  | Criteria
2021-11-30 00:00:00 | SSD | RET | 0 | 55000 |  |  | Previous month | 2021-10-31 00:00:00 | Current month | 2021-11-30 00:00:00 | SalaryCriteria | LWP
2021-11-30 00:00:00 | PNL | RET | 0 | 25000
2021-11-30 00:00:00 | TPS | LWP | 0 | 60000 |  |  | I want UNIQUE Staff Names from list on above prescribed multiple criterias
2021-11-30 00:00:00 | AMS | LWP | 30 | 36700
2021-11-30 00:00:00 | MSP | CONT | 0 | 175000 |  |  | Result I want is UNIQUE Staff Names
2021-11-30 00:00:00 | CGM | CONT | 0 | 85000 |  |  |  | RetLWPSalary | RetLWPSalary
2021-10-31 00:00:00 | MWL | CONT | 0 | 175000 |  |  | Staff Name |  |  | Difference
2021-10-31 00:00:00 | CGM | CONT | 0 | 85000 |  |  | TPS | 0 | 60000
2021-10-31 00:00:00 | AMS | LWP | 30 | 36943 |  |  | AMS | 36943 | 36700
Spreadsheet: 7cb96d50-300c-49db-95f1-cc81c6291269
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-04-20 09:13:34.530000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5.25 | 102 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
5.125 | 101.666 | 101.416 | 101.291 | 100.916
5 | 101.241 | 100.991 | 100.866 | 100.491 |  | Note: | Refer To Price [NAME]
4.875 | 100.696 | 100.446 | 100.321 | 99.946 |  |  | For all Price Adjs
4.75 | 99.712 | 99.462 | 99.337
4.625 | 98.617 | 98.367 | 98.242
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.5 | 102 | 101.75 | 101.625 | 101.25
4.375 | 101.694 | 101.444 | 101.319 | 100.944
4.25 | 101.157 | 100.907 | 100.782 | 100.407
4.125 | 100.104 | 99.854 | 99.729 | 99.354
4 | 99.766 | 99.516 | 99.391
 |  |  |  |  |  | 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 | 2011-05-04 09:13:34.530000
30 DAY | 2011-05-19 09:13:34.530000
45 DAY | 2011-06-03 09:13:34.530000
60 DAY | 2011-06-18 09:13:34.530000
90 DAY | 2011-07-18 09:13:34.530000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 107094d1304289714-vlookup-with-concatenate-excel-help
Sheet: Sheet1

Course | Sect | CRN |  |  | Concatenated
6001 | 1 | 14590
6001 | 2 | 13840
6001 | 3 | 12903
6001 | 4 | 11134
6001 | 5 | 22349
6001 | 6 | 22131
6001 | 7 | 22345
6001 | 8 | 65455
9001 | 1 | 33453
9001 | 2 | 77677
9001 | 3 | 65332
9001 | 4 | 11116
9001 | 5 | 67774
9001 | 6 | 33343
9001 | 7 | 9099
9001 | 8 | 99212
Spreadsheet: 546550d1510087606-bowling-stats-help-bowling-help2-1-
Sheet: Sheet1

[NAME] |  | 150 | 175 | 185
 | exclude | 125 | 195 | 160
 |  | 158 | 145 | 165
 |  |  |  |  |  |  |  |  |  | Should be 185
 |  |  |  |  |  |  | [NAME] game
 |  |  |  |  |  | Is there a way to exclude the numbers in red???
[NAME] |  | 140 | 111 | 115
 |  | 106 | 104 | 89
 | exclude | 141 | 125 | 132
 |  |  |  |  |  |  |  |  |  | Should be 140
 |  |  |  |  |  |  | [NAME] game
Spreadsheet: 158723d1338376412-problem-in-selecting-the-option-to-a-particular-question-a
Sheet: Sheet1

Sample Survey :
User File | Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 | Q9 | Q10
A | 6 | 5 | 2 | 1 | 2 | 3 | 4 | 4 | 1 | 2
Spreadsheet: 32c72b6f-df38-43db-b82c-8cfc8420a0e4
Sheet: assumptions

Estimated proportion of syphilis seropositive women with probable "active syphilis"
0.65
 |  |  |  | Expected proportion of women that have syphilis related adverse outcome without treatment | Effectiveness of penicillin treatment in reducing a given adverse outcome
any adverse outcome |  |  |  | 0.52 |  | This "any" effectiveness value (0.8419) is the weighted average using as weights the outcome proportions in column E.
early fetal loss |  |  |  | 0.21 | 0.82
neonatal death |  |  |  | 0.09 | 0.8
prematurity or LBW |  |  |  | 0.06 | 0.64
clinical disease |  |  |  | 0.16 | 0.97
% of ANC attendees tested AND treated for syphilis by region and scenario
 | WORST | MIDDLE | BEST | ECS recommendation
AFRO | 0.1 | 0.3 | 0.5 | 0.81
EMRO | 0.1 | 0.3 | 0.5 | 0.81
EURO | 0.5 | 0.7 | 0.9 | 0.9 | Note: would assume EURO maintains higher level of testing and treatment
PAHO | 0.4 | 0.6 | 0.8 | 0.81
SEARO | 0.2 | 0.4 | 0.6 | 0.81
WPRO | 0.4 | 0.6 | 0.8 | 0.81
 | Median: