tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 220680d1363228399-conditional-formula-comparing-two-dates-in-separate-cells-and-coloring-a-third-cell-working
Sheet: Sheet1

 |  |  | Activity Name | [NAME] | Baseline Finish | 2013-01-13 00:00:00 | 2013-02-13 00:00:00 | 2013-03-13 00:00:00 | 2013-04-13 00:00:00 | 2013-05-13 00:00:00 | 2013-06-13 00:00:00 | 2013-07-13 00:00:00 | 2013-08-13 00:00:00 | 2013-09-13 00:00:00 | 2013-10-13 00:00:00 | 2013-11-13 00:00:00 | 2013-12-13 00:00:00
 |  |  | Task 1 | 2013-02-06 08:00:00 | 2013-06-11 17:00:00
 |  |  | Task 2 | 2013-05-06 08:00:00 | 2013-05-06 17:00:00
 |  |  | Task 3 | 2013-03-06 08:00:00 | 2013-03-19 17:00:00
 |  |  | Task 4 | 2013-03-20 08:00:00 | 2013-03-20 17:00:00
 |  |  | Task 5 | 2013-05-01 08:00:00 | 2013-05-15 17:00:00
 |  |  | Task 6 | 2013-05-15 00:00:00 | 2013-05-29 17:00:00
 |  |  | Task 7 | 2013-03-21 08:00:00 | 2013-04-03 17:00:00
 |  |  | Task 8 | 2013-05-30 08:00:00 | 2013-06-10 17:00:00
 |  |  | Task 9 | 2013-06-05 08:00:00 | 2013-06-11 17:00:00
 |  |  | Task 10 | 2013-06-11 00:00:00 | 2013-06-11 00:00:00
 |  |  | Task 11 | 2013-03-14 08:00:00 | 2013-06-19 17:00:00
 |  |  | Task 12 | 2013-05-20 00:00:00 | 2013-05-20 00:00:00
 |  |  | Task 13 | 2013-03-14 08:00:00 | 2013-03-27 17:00:00
 |  |  | Task 14 | 2013-03-28 08:00:00 | 2013-03-28 17:00:00
 |  |  | Task 15 | 2013-05-09 08:00:00 | 2013-05-16 00:00:00
 |  |  | Task 16 | 2013-05-17 00:00:00 | 2013-06-14 17:00:00
 |  |  | Task 17 | 2013-03-29 08:00:00 | 2013-04-11 17:00:00
 |  |  | Task 18 | 2013-06-14 08:00:00 | 2013-06-17 17:00:00
 |  |  | Task 19 | 2013-06-17 08:00:00 | 2013-06-19 17:00:00
 |  |  | Task 20 | 2013-06-19 00:00:00 | 2013-06-19 00:00:00
 |  |  | Task 21 | 2013-04-16 08:00:00 | 2013-07-22 17:00:00
 |  |  | Task 22 | 2013-05-28 00:00:00 | 2013-05-29 00:00:00
 |  |  | Task 23 | 2013-04-16 08:00:00 | 2013-04-29 17:00:00
 |  |  | Task 24 | 2013-04-30 08:00:00 | 2013-04-30 17:00:00
 |  |  | Task 25 | 2013-06-05 00:00:00 | 2013-06-17 17:00:00
 |  |  | Task 26 | 2013-06-18 08:00:00 | 2013-07-09 17:00:00
 |  |  | Task 27 | 2013-05-01 08:00:00 | 2013-05-14 17:00:00
 |  |  | Task 28 | 2013-07-09 08:00:00 | 2013-07-19 17:00:00
 |  |  | Task 29 | 2013-07-16 08:00:00 | 2013-07-23 17:00:00
 |  |  | Task 30 | 2013-07-23 00:00:00 | 2013-07-23 00:00:00
 |  |  | Task 31 | 2013-07-10 08:00:00 | 2013-10-15 17:00:00
 |  |  | Task 32 | 2013-07-24 08:00:00 | 2013-07-24 17:00:00
 |  |  | Task 33 | 2013-07-10 08:00:00 | 2013-07-23 17:00:00
 |  |  | Task 34 | 2013-07-24 08:00:00 | 2013-07-24 17:00:00
 |  |  | Task 35 | 2013-09-04 08:00:00 | 2013-09-04 17:00:00
 |  |  | Task 36 | 2013-10-02 08:00:00 | 2013-10-02 17:00:00
 |  |  | Task 37 | 2013-07-25 08:00:00 | 2013-08-07 17:00:00
 |  |  | Task 38 | 2013-10-14 08:00:00 | 2013-10-14 17:00:00
 |  |  | Task 39 | 2013-10-10 00:00:00 | 2013-10-15 17:00:00
 |  |  | Task 40 | 2013-10-15 00:00:00 | 2013-10-15 00:00:00
 |  |  | Task 41 | 2013-10-22 08:00:00 | 2013-12-02 17:00:00
 |  |  | Task 42 | 2013-10-22 08:00:00 | 2013-10-22 17:00:00
 |  |  | Task 43 | 2013-11-05 08:00:00 | 2013-11-05 17:00:00
 |  |  | Task 44 | 2013-11-26 08:00:00 | 2013-12-01 17:00:00
 |  |  | Task 45 | 2013-12-02 00:00:00 | 2013-12-01 00:00:00
Spreadsheet: 25ffcd85-eb34-4ddd-a60f-c23f26d2f9fe
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 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: New Residential Construction
 |  | Annual Rate for Housing Units Started: United States
 |  | Seasonally Adjusted Total Units [Thousands of Units]
 |  | Period: 2006 to 2012
 |  | Data Extracted on: July 28, 2014 (8:37 pm)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2006 | 2273 | 2119 | 1969 | 1821 | 1942 | 1802 | 1737 | 1650 | 1720 | 1491 | 1570 | 1649
2007 | 1409 | 1480 | 1495 | 1490 | 1415 | 1448 | 1354 | 1330 | 1183 | 1264 | 1197 | 1037
2008 | 1084 | 1103 | 1005 | 1013 | 973 | 1046 | 923 | 844 | 820 | 777 | 652 | 560
2009 | 490 | 582 | 505 | 478 | 540 | 585 | 594 | 586 | 585 | 534 | 588 | 581
2010 | 614 | 604 | 636 | 687 | 583 | 536 | 546 | 599 | 594 | 543 | 545 | 539
2011 | 630 | 517 | 600 | 554 | 561 | 608 | 623 | 585 | 650 | 610 | 711 | 694
2012 | 723 | 704 | 695 | 753 | 708 | 757 | 740 | 754 | 847 | 915 | 833 | 976
Spreadsheet: 06986d73-8a01-4bf9-abed-fe7dfad1359c
Sheet: 1 YEAR

Form PR-B ORSP BUDGET WORKSHEET    Must be completed and initialed by ORSP Staff
 | MUID |  |  |  | ACCT
Prepared by
Last Modified on
PI |  |  |  |  | DEPT
Project Title
Sponsor
 | Budget Period
 | BUDGET ITEM | Name or Comment |  |  |  | GRANT
A. | PERSONNEL
6000 | PI Acad. Year
6000 | Co-I Acad Year
6000 | Co-I Acad Year
6000 | Other Professional
6000 | Total Professional
6007 | PI Summer
6007 | Co-I Summer
6007 | Co-I Summer
6007 | Total Sumr Salaries
6008 | Post Doc/Fellow Full-Time
6012 | Clinical/Lab Staff Full-Time
6013 | Clinical/Lab Staff Part-Time
6020 | Full-Time Hourly Staff
6035 | Part-Time Hourly Staff
6050 | Undergraduate Students
6024 | GRA-Academic Year | #: |  | Biweekly $:
6024 | GRA-Summer | #: |  | Biweekly $:
6024 | Total GRA
6195 | Fringe FT |  |  |  | 0.285
6195 | [NAME] |  |  |  | 0.16
6195 | Fringe PT & Summer Students |  |  |  | 0.08
6195 | Total Fringes
 | TOTAL PERSONNEL
B. | NONPERSONNEL
6200 | Office Expenses
6235 | Lab Supplies
6247 | Equipment > $5000
6265 | Computer Software
6505 | Consulting Fees
6515 | Subcontract 1 < $25K
6520 | Subcontract 1 > $25K
6515 | Subcontract 2 < $25K
6520 | Subcontract 2 > $25K
6515 | Total Sub < $25K
6520 | Total Sub > $25K
6602 | Student Stipends
6900 | Domestic Travel
6900 | Domestic Travel
6900 | Total Domestic Travel
6930 | Foreign Travel
7010 | Publications
7225 | Tuition
 | TOTAL NONPERSONNEL
 | TOTAL DIRECT COSTS: NIH MODULAR (Less Subs I/C)
 | TOTAL DIRECT COSTS: MU (Includes Subs I/C)
 | MTDC BASE
7520 | F&A Costs |  |  |  | 0.51
 | TOTAL PROJ COSTS
 |  |  |  |  | F&A for Subcontracts
 |  |  |  |  | #1
 |  |  |  |  | #2
Spreadsheet: 858041d1706824396-equal-or-even-distribution-division-excelforumkirash4
Sheet: Sheet1

 |  | Total Students | 37
 |  | Students per group | 2 |  | Students per group | 3 |  | Students per group | 4 |  | Students per group | 5
 |  | Total Groups |  |  | Total Groups |  |  | Total Groups |  |  | Total Groups
 |  | Remaining Students |  |  | Remaining Students |  |  | Remaining Students |  |  | Remaining Students
 |  | Group 1 |  |  | Group 1 |  |  | Group 1 |  |  | Group 1
 |  | Group 2 |  |  | Group 2 |  |  | Group 2 |  |  | Group 2
 |  | Group 3 |  |  | Group 3 |  |  | Group 3 |  |  | Group 3
 |  | Group 4 |  |  | Group 4 |  |  | Group 4 |  |  | Group 4
 |  | Group 5 |  |  | Group 5 |  |  | Group 5 |  |  | Group 5
 |  | Group 6 |  |  | Group 6 |  |  | Group 6 |  |  | Group 6
 |  | Group 7 |  |  | Group 7 |  |  | Group 7 |  |  | Group 7
 |  | Group 8 |  |  | Group 8 |  |  | Group 8 |  |  | Group 8
 |  | Group 9 |  |  | Group 9 |  |  | Group 9 |  |  | Group 9
 |  | Group 10 |  |  | Group 10 |  |  | Group 10 |  |  | Group 10
 |  | Group 11 |  |  | Group 11 |  |  | Group 11 |  |  | Group 11
 |  | Group 12 |  |  | Group 12 |  |  | Group 12 |  |  | Group 12
 |  | Group 13 |  |  | Group 13 |  |  | Group 13 |  |  | Group 13
 |  | Group 14 |  |  | Group 14 |  |  | Group 14 |  |  | Group 14
 |  | Group 15 |  |  | Group 15 |  |  | Group 15 |  |  | Group 15
 |  | Group 16 |  |  | Group 16 |  |  | Group 16 |  |  | Group 16
 |  | Group 17 |  |  | Group 17 |  |  | Group 17 |  |  | Group 17
 |  | Group 18 |  |  | Group 18 |  |  | Group 18 |  |  | Group 18
 |  | Group 19 |  |  | Group 19 |  |  | Group 19 |  |  | Group 19
 |  | Group 20 |  |  | Group 20 |  |  | Group 20 |  |  | Group 20
 |  | Group 21 |  |  | Group 21 |  |  | Group 21 |  |  | Group 21
Spreadsheet: 1aa5bde8-9096-473f-8844-0ca85aa9a7f9
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
MCRNA | Test | MCRNA | Chlamydia trachomatis, [NAME], by Nucleic Acid Amplification (GEN-PROBE) | C. trach, [NAME], Amplified RNA | Transcription Mediated Amplification |  |  |  | 1 | mL | Specimen source is required.   Submit only 1 of the following specimens:   Swab specimen must be collected using an APTIMA Collection Unisex Swab (Supply T583) or APTIMA Collection Vaginal Swab (Supply T584). These swabs are contained in the APTIMA Collection Kit.   Specimen Type: Oral/throat or ocular (corneal/conjunctiva) or rectal/anal Container/Tube: APTIMA Swab Collection System (Supply T583) [NAME]: Swab Collection Instructions: 1. Swab site using APTIMA Collection Unisex Swab. 2. Place swab in transport tube provided in collection kit. Snap off swab at score line so swab fits into closed tube. 3. [NAME] tube securely, and label tube with patient's entire name, and date and time of collection. 4. Transport swab container to laboratory and store (refrigerated is preferred) within 60 days of collection.   [NAME]: Peritoneal fluid (pelvic wash, [NAME]) Container/Tube: APTIMA Specimen Transfer Tube (Supply T652) [NAME]: 1 mL Collection Instructions: 1. Transfer specimen into the APTIMA Specimen Transfer Tube (Supply T652). 2. [NAME] tube securely, and label tube with patient's entire name, and date and time of collection. 3. Transport APTIMA Specimen Transfer Tube to laboratory (refrigerated is preferred) within 30 days of collection. | Peritoneal Fluid: 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Sources other than those listed above | Negative | Monday through Saturday, varies | 1 day | 3 days | 1 | 87491 |  |  |  |  | Rochester
MCRNA | [NAME] | VARIES | Varies |  |  |  | Refrigerated
MCRNA | Order Question | SRC11 | SOURCE: |  | Plain Text
MCRNA | Result | SRC11 | SOURCE: | SOURCE: | Alphanumeric
MCRNA | Result | 34507 | C. trach, [NAME], Amplified RNA | C. trach, [NAME], Amplified RNA | Alphanumeric
Spreadsheet: 0cd47401-9756-4cd7-926a-820d5c4b41fc
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 1.1 | 2.1 | 3.1 | 4.1 | 5.1 | 6.1 | 7.1 | 8.1
 |  |  |  |  | Susan0412
 |  |  |  |  |  |  | Karen & Paul |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Honeymoon
 |  |  |  |  |  |  |  | Jay & Susan ( first timers )
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wedding
 |  |  |  |  |  |  |  |  |  |  | bveg912     J & B   ( first timers )
 |  |  |  |  |  |  |  |  | Todd & Linda
 |  |  |  |  |  |  |  |  |  | Paul Frances |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Anniversary
 |  |  |  |  |  |  |  |  |  |  | Vicki528 ( first timers )
 |  |  |  |  |  |  |  |  |  |  |  | Heather & Jim |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Birthday
 |  |  |  |  |  |  |  |  |  |  |  | Grady
 |  |  |  |  |  |  |  |  |  |  |  | dawi
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | lamdam
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sunny23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Andy & Meredith
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lisa531
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jam24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mike & Sue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Melvin76
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VA couple
Spreadsheet: 167993d1342181287-help-with-producing-form-from-a-spreadsheet-ef120_testsheetinspection
Sheet: Inspection Sheet

LOCATION: |  |  |  |  | COLUMN: |  |  |  |  | ID NUMBER: |  |  |  |  | 2
MODEL NUMBER: |  |  |  |  | SERIAL NUMBER: |  |  |  |  | LOT NUMBER:
DATE OF MANUFACTURE: |  |  |  |  | LAST SERVICE DATE: |  |  |  |  | ANCHOR TYPE:
TYPE:
EQUIPMENT: | PASS / FAIL | REASON FOR FAILURE:
ANCHORAGE POINT & CONNECTORS: |  |  | PASS / FAIL | REASON FOR FAILURE:
COMMENTS:
INSPECTOR: |  |  |  |  | DATE:
LOCATION: |  |  |  |  | COLUMN: |  |  |  |  | ID NUMBER:
MODEL NUMBER: |  |  |  |  | SERIAL NUMBER: |  |  |  |  | LOT NUMBER:
DATE OF MANUFACTURE: |  |  |  |  | LAST SERVICE DATE: |  |  |  |  | ANCHOR TYPE:
TYPE:
EQUIPMENT: | PASS / FAIL | REASON FOR FAILURE:
ANCHORAGE POINT & CONNECTORS: |  |  | PASS / FAIL | REASON FOR FAILURE:
COMMENTS:
INSPECTOR: |  |  |  |  | DATE:
LOCATION: |  |  |  |  | COLUMN: |  |  |  |  | ID NUMBER:
MODEL NUMBER: |  |  |  |  | SERIAL NUMBER: |  |  |  |  | LOT NUMBER:
DATE OF MANUFACTURE: |  |  |  |  | LAST SERVICE DATE: |  |  |  |  | ANCHOR TYPE:
TYPE:
EQUIPMENT: | PASS / FAIL | REASON FOR FAILURE:
ANCHORAGE POINT & CONNECTORS: |  |  | PASS / FAIL | REASON FOR FAILURE:
COMMENTS:
INSPECTOR: |  |  |  |  | DATE:
Spreadsheet: 734945d1622617737-leave-calendar-to-count-the-number-of-days-of-leave-each-staff-has-left-leave-plan-draft-v3
Sheet: November

1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7
8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14
15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21
22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28
29 |  | 30
Spreadsheet: 248698d1373299888-search-and-update-or-create-new-entry-datalog
Sheet: Charles

MRN | Patient # | Svc Date | [NAME] | Insurance | Gender | height | weight | Pre-op BMI | Poly Thickness | tibio femoral angle pre op | tibio femoral angle post op 3mos | Range of motion pre op | Range of motion post op 3mos | Pain Score pre op | Pain Score post op 3 mos | womac pre-op | womac post op 3 mos | oxford knee score pre-op | oxford knee score post op 3 mos | Revised? | Date of revision | Reason for Revision
xxxxx | 2 | 2013-02-12 00:00:00 | 1991-01-01 00:00:00 | Medicare | Male | 60in | 150lb | 23 | 34 | 43 degrees | 23 degress | 34 degrees | 27 degrees | 4 | 2 | No | No | 34 | 37 | yes | 2013-02-23 00:00:00 | N/A
Spreadsheet: mike_carson__27666__BrokerQuote(SouthEast)
Sheet: Sheet1

Broker | Prebon
Date | 2002-01-29 00:00:00
Time | 11.30AM |  |  |  | Please time stamp the quote sheet before sending back
ONPEAK |  |  |  |  |  |  |  | [NAME]
PRICE | SOUTHEAST |  |  |  |  |  |  | PRICE | SOUTHEAST
 | SOCO |  | Entergy |  |  |  |  |  | SOCO |  | Entergy
 | Bid | Offer | Bid | Offer |  |  |  |  | Bid | Offer | Bid | Offer
Dailies | 19 | 19.5 | 16 | 17 |  |  |  | Dailies
Next Week | 19.5 | 21.5 | 18 | 19 |  |  |  | Next Week
[NAME] | 19.5 | 21.5 | 18 | 19 |  |  |  | [NAME]
2002-02-02 00:00:00 | 22.5 | 23 | 18 | 18.1 |  |  |  | 2002-02-02 00:00:00 | 19.25 | 20
M/A 02 | 21.7 | 22.45 | 19.45 | 19.75 |  |  |  | M/A 02
2002-05-01 00:00:00 | 24.75 | 25.25 | 22.5 | 22.75 |  |  |  | 2002-05-01 00:00:00
2002-06-01 00:00:00 | 30.25 | 31 | 26.75 | 27 |  |  |  | 2002-06-01 00:00:00
Sum 02 | 39.5 | 40 | 34.25 | 34.75 |  |  |  | Sum 02
2002-09-01 00:00:00 | 23.4 | 24 | 21.4 | 21.6 |  |  |  | 2002-09-01 00:00:00
Q4 02 | 23.2 | 23.6 | 21.3 | 21.5 |  |  |  | Q4 02
Bal CAL-02 | 26.75 | 27.3 | 23.75 | 24 |  |  |  | CAL-02
W 03 | 26.6 | 27.15 | 24.1 | 24.4 |  |  |  | W 03
M/A 03 | 25.4 | 26.15 | 23 | 23.1 |  |  |  | M/A 03
2003-05-01 00:00:00 | 27.25 | 27.9 | 25 | 25 |  |  |  | 2003-05-01 00:00:00
2003-06-01 00:00:00 | 32.5 | 33.25 | 29.5 | 30.25 |  |  |  | 2003-06-01 00:00:00
Sum 03 | 40.75 | 41.25 | 35 | 35.5 |  |  |  | Sum 03
2003-09-01 00:00:00 | 25 | 25.75 | 23.25 | 23.75 |  |  |  | 2003-09-01 00:00:00
Q4 03 | 25.5 | 26.25 | 24.25 | 2475 |  |  |  | Q4 03
CAL-03 | 29 | 29.75 | 26.25 | 26.5 |  |  |  | CAL-03
[NAME] | - | - | 27.25 | 28.25 |  |  |  | [NAME]
Cal-05 | - | - | 29.5 | 30.5 |  |  |  | Cal-05
Cal-06 | - | - | - | - |  |  |  | Cal-06
Cal-07-10 | - | - | - | - |  |  |  | Cal-04-06 | 21.5 | 22.5
Spreadsheet: 291513d1390320206-working-with-sales-profit-net-income-profit-margin-and-etc-test-fin
Sheet: Sheet1

Sales |  | 100
Cost of Sales |  | 50
Gross Profit
Net Income
Gross Profit Margin
NET PROFIT
NET PROFIT %
OPERATING EXPENSES |  | 49
OPERATING INCOME
OPERATING PROFIT MARGIN
Spreadsheet: 01506125-2973-4dc5-b0d5-cfaa6da889e6
Sheet: Viz4-PctNatlAveByMetro

meta-last-update
meta-source-line
meta-source-url
chart-main-title | Gross Domestic Product Per Employee as a Percentage of the U.S. Metro Average, 2010 | GDP Per Employee
chart-axis-header
chart-title | Gross Domestic Product Per Capita as a Percentage of the U.S. Metro Average, 2011 | GDP Per Capita
Spreadsheet: 885790d1735629272-amortization-table-with-percent-paid-column-amortize-lambda-function
Sheet: Definition

AMORTIZEλ:
=LAMBDA(principal,apr,term,[freq_mode],[horizontal],
LET(
frq, CHOOSE(ISOMITTED(freq_mode)+freq_mode,12,24,26,52),
ppr, apr/frq,
dur, ROUNDUP(frq*term/12,0),
per, SEQUENCE(dur),
pmt, PMT(ppr,dur,principal),
ppl, PPMT(ppr,per,dur,principal),
int, IPMT(ppr,per,dur,principal),
ppt, SCAN(0,-ppl,SUM),
ipt, SCAN(0,-int,SUM),
pct, ppt/principal,
end, principal-ppt,
beg, VSTACK(principal,DROP(end,-1)),
out, HSTACK(per,beg,IF(per,pmt),ppl,int,ppt,ipt,end,pct),
IF(horizontal,TRANSPOSE(out),out)
)
)
[freq_mode]:
1 - Monthly (default)
2 - Semi-monthly
3 - Bi-weekly
4 - Weekly
Spreadsheet: 191320d1352063744-vigenere-cipher-can-encrypt-decryption-is-troublesome-book3
Sheet: vigenere square

 | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
A | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
B | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | A
C | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | A | B
D | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | A | B | C
E | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | A | B | C | D
F | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | A | B | C | D | E
G | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | A | B | C | D | E | F
H | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | A | B | C | D | E | F | G
I | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | A | B | C | D | E | F | G | H
J | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | A | B | C | D | E | F | G | H | I
K | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | A | B | C | D | E | F | G | H | I | J
L | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | A | B | C | D | E | F | G | H | I | J | K
M | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | A | B | C | D | E | F | G | H | I | J | K | L
N | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | A | B | C | D | E | F | G | H | I | J | K | L | M
O | O | P | Q | R | S | T | U | V | W | X | Y | Z | A | B | C | D | E | F | G | H | I | J | K | L | M | N
P | P | Q | R | S | T | U | V | W | X | Y | Z | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O
Q | Q | R | S | T | U | V | W | X | Y | Z | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P
R | R | S | T | U | V | W | X | Y | Z | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q
S | S | T | U | V | W | X | Y | Z | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R
T | T | U | V | W | X | Y | Z | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S
U | U | V | W | X | Y | Z | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T
V | V | W | X | Y | Z | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U
W | W | X | Y | Z | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V
X | X | Y | Z | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W
Y | Y | Z | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X
Z | Z | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y
Spreadsheet: 815457d1674958977-sumif-vlookup-functions-combined-together-s666-pq-sumif-vlookup-functions-combined-together
Sheet: Sheet1

name | ID no. | QTY |  | name | TQty |  | Search
[NAME] | 11 | 10 |  | [NAME] | 33 |  | [NAME]
apple | 22 | 15
mary | 44 | 20
[NAME] | 11 | 23
mary | 44 | 5
Spreadsheet: 014a6c57-a3c8-4ac9-a5a5-4c3e6ab18845
Sheet: WithPerformance

Combined Bidder Activity Summary Report - August 2014  (Projects bid opened from July 2013 to August 2014, as of 09/07/2014)
Bid Month-YR | Engineer's Estimate | [NAME] | Low Bid vs. EE | Avg. Number of Bidders | Number of Projects Bid Opened | No. of  Projects Under 10% of EE | No. of Projects in ±10% of EE | No. of Projects Over 10% of EE | No. of Projects Within 110% of EE | Percent of  Projects Within ±10% of EE
2013-07-13 00:00:00 | 101578652.05 | 102192668.35 |  | 4.857142857 | 14 | 7 | 3 | 4
Aug-13 | 67879300.28 | 61238911.23 |  | 6 | 20 | 9 | 8 | 3
Sept-13 | 204165819.49 | 173258066.06 |  | 6.8846 | 26 | 18 | 5 | 3
Oct-13 | 162182345.53 | 146432319.92 |  | 5.3103 | 29 | 10 | 16 | 3
Nov-13 | 165502932.37 | 144277480.63 |  | 7.467 | 15 | 8 | 6 | 1
2013-12-12 00:00:00 | 124415660.37 | 119060555.57 |  | 6.9231 | 13 | 4 | 6 | 3
Jan-14 | 140813434.82 | 137191609 |  | 7.571428571 | 28 | 13 | 9 | 6
2014-02-14 00:00:00 | 92385807 | 83500057 |  | 6.6 | 27 | 10 | 13 | 4
2014-03-14 00:00:00 | 210853414 | 184251324 |  | 6.4 | 56 | 29 | 23 | 4
2014-04-01 00:00:00 | 231265534 | 205255562 |  | 5.5 | 62 | 31 | 25 | 6
2014-05-01 00:00:00 | 140508630 | 134448039 |  | 4.8 | 57 | 31 | 18 | 8
* Jun-14 | 231614414 | 221901164 |  | 5 | 20 | 5 | 12 | 3
Jul 13 to Jun 14
2014-07-01 00:00:00 | 139737164 | 127414388 |  | 5.6 | 24 | 11 | 12 | 2
2014-08-01 00:00:00 | 124065598 | 127514756 |  | 4.9 | 23 | 7 | 12 | 4
2014-09-01 00:00:00
2014-10-01 00:00:00
2014-11-01 00:00:00
2014-12-01 00:00:00
2015-01-01 00:00:00
2015-02-01 00:00:00
2015-03-01 00:00:00
2015-04-01 00:00:00
2015-05-01 00:00:00
2015-06-01 00:00:00
Jul 14 - Jun 15
Total
Note: 1) "*", numbers may be different from that in the previous report due to bid rank change(s); 2) Rejected projects are not included in calculations.
Spreadsheet: 142494d1329865861-adding-additional-cells-to-cells-with-formulas-3-bid-fee-tabulation
Sheet: Contract Numbers

Discipline | Company | Phase I                                         Survey, Prelim / Design Development |  | Phase II                                         CD's | Phase III                                         CA | Reimbursables | TOTAL
Architectural
 | Arch | 0 | 0 | 0 | 0 | 0 | 0
 | Estimated Reimbursables
Mechanical, Electrical & Plumbing
 | ENGINEER A | 100 | 200 | 150 | 100 | 300 | 550
 | Estimated Reimbursables | 100 |  | 100 | 100
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Structural
 | #N/A |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Fire Protection
 | #N/A |  |  |  |  | 0 | 0
 | Estimated Reimbursables
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Civil
 | #N/A |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Bldg. Dept. Plan Review Fees
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Geotechnical
 | #N/A |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Skylight Energy Modeling
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Expediter & Third Party Reviewer
 |  |  |  |  |  | 0 | 0
 | Estimated Reimbursables
Landscape
 | #N/A |  |  |  |  | 0 | 0
 | Estimated Reimbursables
 | Reimbursable Sub-total Per Phase | 100 | 0 | 100 | 100
 | SUB-TOTALS PER PHASE | 100 | 200 | 150 | 100 | 300 | 550
 |  |  | Additional Services NOT INCLUDED in Base Contract
SUB TOTAL | 550
REIMBURSABLES | 300
GRAND TOTAL | 850