tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 876630d1723360629-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.19.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-19 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 10 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 24 | 0 | 4 | 1 | 2 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 24 | 0 | 4 | 0 | 0 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 12 | 0 | 4 | 0 | 0 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 4 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 4 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 1 | 0 | 5 | 0 | 0 | 1 | 1 | 1 | 0
 | Total Holds MID |  |  | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-19 00:00:00
 | UNIT | Bed Capacity | Bud. Beds | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 5 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 23 | 0 | 4 | 0 | 1 | 1 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 21 | 0 | 4 | 1 | 3 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 13 | 0 | 4 | 0 | 2 | 0 | 0 | 1 | 0.5
 | MNO | 12 | 6 | 3 | 0 | 2 | 0 | 0 | 0 | 1 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 2 | 0 | 3 | 0 | 1 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 0 | 0 | 4 | 1 | 0 | 0 | 1 | 2 | 0
 | Total House Census
Spreadsheet: mary_fischer__25613__32H
Sheet: E14.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
ANALYSIS OF OTHER DEFERRED CREDITS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
 |  | 12-31-00 Balance |  |  |  | Charged to |  | Transfer / Reclasses |  |  |  | 6-30-01 Balance
[NAME] |  | DR. (CR.) |  | Cash Pd / (Rec'd) |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(1)  PROVIDE DETAIL OF INDIVIDUAL ITEMS IN EXCESS OF $200,000
(2)  USE COMMENTS SECTION TO PROVIDE AN EXPLANATION OF WHY ANY REVENUE
ITEMS ARE DEFERRED AND WHAT EVENT WILL CAUSE REVENUE RECOGNITION
OTHER DEFERRED CREDITS:
Accrued Severence |  |  |  |  |  |  |  | -41000 |  | 0860 / 0620
Accrued Coins Variance |  |  |  |  |  |  |  | -29013 |  | 0860 / 0655
Deferred Service Revenue |  |  |  |  |  | -4971 |  | -173053 |  | 0860 / 0655
Total (Hyperion line 0860)
Asset/Expense Accts:  DR/(CR)
Reverse signs from Hyperion
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-14
Spreadsheet: 142336d1329776871-inputting-data-from-a-formula-recruitment-progress
Sheet: Template

[NAME]
 | Date | Time | Comments
CV/Cover letter received
Proposed interview date
Room requested
Additional Interviewer contacted
Interviewee contacted
Interview date set
[NAME] created
Rejection email sent
Added to database
Trial date proposed
Applicant available
Student available
Trial date set
Applicant set lesson details
Observation teacher set
Observation report received
Rejection email sent
Applicant updated to 'active'
Applicant contacted
References requested
References received
Contract Required
Contract date set
Caontract signed
 | Date Completed |  | Comments
 |  |  | When will course end?
 |  |  | Has the course end been updated on the database?
 |  |  | Final feedback?
Spreadsheet: 77604346-ed7a-440d-930f-7c8cfc145836
Sheet: Sheet1

[NAME] E. coli (STEC) Incidence,  by Selected Demographics, Maine 2011, and by Year, Maine 2002-2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | Number |  | Rate*
Maine Total |  | 28 |  | 2.108135294099932
Sex
 | Male | 13 |  | 1.999806172632499
 | Female | 15 |  | 2.211981566820277
Ethnicity
 | Hispanic | 0 |  | 0
 | Not Hispanic | 26 |  | 1.984384421055845
 | Unknown | 2
Race
 | American Indian or [NAME] | 0 |  | 0
 | Asian, Native Hawaiian or Pacific Islander | 0 |  | 0
 | Black or African American | 0 |  | 0
 | White | 27 |  | 2.129762484154961
 | Multiple races | 0 |  | 0
 | Unknown | 1
Age
 | 0-4 | 6 |  | 8.863545713737018
 | 5-14 | 4 |  | 2.643352299386081
 | 15-24 | 4 |  | 2.407477625504818
 | 25-44 | 9 |  | 2.883663405990971
 | 45-64 | 1 |  | 0.2411370092259019
 | 65+ | 4 |  | 1.849984737625915
10-Year Trend
 | 2002 | 49 |  | 3.78534469039743
 | 2003 | 15 |  | 1.148780913694388
 | 2004 | 18 |  | 1.3664800915238
 | 2005 | 29 |  | 2.19446767132928
 | 2006 | 49 |  | 3.707700060685213
 | 2007† | 41 |  | 3.112646683474959
 | 2008 | 26 |  | 1.974999544230875
 | 2009 | 19 |  | 1.44124900155579
 | 2010 | 21 |  | 1.580895554747542
 | 2011 | 28 |  | 2.108135294099932
* Rate = number of cases per 100,000 population using the corresponding year census estimate as the denominator.
†1 unknown gender in 2007.
Spreadsheet: 100116d1298561861-non-continuous-averages-averagesbynamesdo
Sheet: averages (2)

By Hand Formulation
TIME | PRICE
08:00:00 | 1.3616
 | 1.3607
12:00:00 | 1.3614
 | 1.3576
14:00:00 | 1.357
 | 1.3581
 | 1.3589
 | 1.3605
16:00:00 | 1.3594
 | 1.3603
 | 1.3612
 | 1.3617 | By Hand | Named Range | DO's [NAME]
20:00:00 | 1.3621 | 1.3603 | 1.3603 | 1.13358333
Spreadsheet: 670141d1585760537-updating-a-formula-for-text-split-textfunctions
Sheet: Sheet2

 | 1st String | 2nd String | [NAME]
Find position of first space
Find position of second space
Find position of third space
Find position of fourth space
Find position of fifth space
Find position of sixth space
Find position of seventh space
Find position of eigth space
Find position of nineth space
Find position of tenth space
Find position of eleventh space
 | LEFT(A17,B2) | MID(A17,B2+1,B3-(B2+1)) | MID(A17,B3+1,B4-(B3+1)) | MID(A17,B4+1,B7-(B4+1)) | MID(A17,B7+1,B8-(B7+1)) | MID(A17,B7+1,B8-(B7+1)) | RIGHT(TRIM(A17),5)
[NAME] 18794 [NAME] Northville Michigan 48168
[NAME] 620 Slayton Street Grand Haven Michigan 12345
[NAME] 5353 North Silver Pines Drive Bellaire Michigan 56789
[NAME] 18794 [NAME] Northville Michigan 48168
[NAME] 620 Slayton Street Grand Haven Michigan 12345
[NAME] 5353 North Silver Pines Drive Bellaire Michigan 56789
Spreadsheet: 683071d1592474680-how-to-count-until-empty-cell-found-sample
Sheet: Sheet1

NAME 1 | TOTAL NAMES
text |  | <- count totall names 1 (count in a range A1:A100 break when empty cell detected
text
text
text
text
[NAME] 2 | TOTAL NAMES
text |  | <- count totall names 2 (count in a range A1:A100 break when empty cell detected
text
text
text
text
text
text
text
text
text
text
text
Spreadsheet: 547307d1510485536-mortgage-paydown-projection-table-mortgage-paydown-projection-table-rental-valuation-breakdown-v2
Sheet: Sheet1

[NAME]
Valuation |  |  | 165000
RV |  |  | 203000
DISCOUNT
PURCHASE AMOUNT |  |  | 140000
20% DISCOUNT IS
CASH FROM ME |  | 0.2
LOAN AMOUNT
BANK INTEREST RATE |  |  | 0.0455
LOAN TERM (YEARS) |  |  | 15
Weekly Rent |  |  | 260 | 0.8% RENT ON ASKING
GROSS INCOME |  |  |  | 0.8% RENT ON PURCHASE
Rates |  |  | 2107
Insurance |  |  | 0
Body Corp |  |  | 2808
Vacancy | 2 | Weeks
Maintenance | 3 | Weeks
Property Manager | 0
Interest on loan
Total Expenses
NET INCOME (AFTER INTEREST NO TAX) |  |  |  | NOI
(MONTHLY)
(WEEKLY)
 |  |  |  | REMAINING AFTER MORTGAGE PAYMENTS (WEEKLY)
 |  |  |  | REMAINING AFTER MORTGAGE PAYMENTS(YEARLY)
NET YIELD ON DEPOSIT |  |  |  | CAP
Tax on profit
PROFIT AFTER TAX
Interest only loan
Interest only weekly
Spreadsheet: 185700d1349805134-interpolating-in-a-2d-table-mrsinterpexample
Sheet: Sheet1

 |  | Engine Speed |  | 1533
 |  | Fuel Injected |  | 75
 |  |  | Output | 74.1251
 |  | Engine RPM
Fuel Injected |  | 400 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500 | 1600 | 1700 | 1800 | 1900 | 2100
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 10 | 9.25 | 8.56 | 8.19 | 7.88 | 7.56 | 7.19 | 6.88 | 6.5 | 6.19 | 5.81 | 5.5 | 5.13 | 4.81 | 4.44 | 4.13 | 3.44
 | 20 | 18.5 | 17.13 | 16.44 | 15.75 | 15.06 | 14.38 | 13.69 | 13 | 12.31 | 11.69 | 11 | 10.31 | 9.63 | 8.94 | 8.25 | 6.88
 | 30 | 27.75 | 25.69 | 24.63 | 23.63 | 22.63 | 21.56 | 20.56 | 19.56 | 18.5 | 17.5 | 16.44 | 15.44 | 14.44 | 13.38 | 12.38 | 10.31
 | 40 | 19.94 | 20.38 | 20.63 | 20.81 | 21.06 | 21.25 | 21.5 | 21.75 | 21.94 | 22.19 | 22.38 | 22.63 | 22.81 | 23.06 | 23.31 | 23.75
 | 50 | 28.94 | 30.38 | 31.13 | 31.81 | 32.56 | 33.25 | 33.94 | 34.69 | 35.38 | 36.13 | 36.81 | 37.56 | 38.25 | 39 | 39.69 | 41.13
 | 60 | 44.5 | 46.06 | 46.88 | 47.63 | 48.44 | 49.19 | 49.94 | 50.75 | 51.5 | 52.31 | 53.06 | 53.88 | 54.63 | 55.44 | 56.19 | 57.75
 | 70 | 61.19 | 62.38 | 63 | 63.63 | 64.19 | 64.81 | 65.44 | 66 | 66.63 | 67.25 | 67.81 | 68.44 | 69.06 | 69.69 | 70.25 | 71.5
 | 80 | 76.63 | 77.25 | 77.56 | 77.88 | 78.19 | 78.5 | 78.81 | 79.13 | 79.44 | 79.75 | 80.13 | 80.44 | 80.75 | 81.06 | 81.38 | 82
 | 90 | 90.44 | 90.38 | 90.38 | 90.31 | 90.31 | 90.25 | 90.25 | 90.19 | 90.19 | 90.19 | 90.13 | 90.13 | 90.06 | 90.06 | 90 | 89.94
 | 100 | 103.13 | 102.38 | 102 | 101.56 | 101.19 | 100.81 | 100.44 | 100 | 99.63 | 99.25 | 98.88 | 98.44 | 98.06 | 97.69 | 97.31 | 96.5
 | 120 | 127.19 | 125.13 | 124.13 | 123.06 | 122 | 121 | 119.94 | 118.94 | 117.88 | 116.81 | 115.81 | 114.75 | 113.69 | 112.69 | 111.63 | 109.56
 | 140 | 148.88 | 146.25 | 144.88 | 143.56 | 142.19 | 140.88 | 139.5 | 138.19 | 136.88 | 135.5 | 134.19 | 132.81 | 131.5 | 130.13 | 128.81 | 126.13
 | 160 | 164.06 | 161.88 | 160.81 | 159.75 | 158.69 | 157.56 | 156.5 | 155.44 | 154.38 | 153.31 | 152.19 | 151.13 | 150.06 | 149 | 147.88 | 145.75
 | 180 | 180.94 | 179.63 | 179 | 178.31 | 177.69 | 177 | 176.38 | 175.75 | 175.06 | 174.44 | 173.75 | 173.13 | 172.44 | 171.81 | 171.19 | 169.88
 | 200 | 197.81 | 197.38 | 197.13 | 196.94 | 196.69 | 196.44 | 196.25 | 196 | 195.75 | 195.56 | 195.31 | 195.13 | 194.88 | 194.63 | 194.44 | 193.94
 |  |  |  |  |  |  |  | 11 |  | 12 |  | <-- Match function
 |  |  |  |  |  |  |  | 1500 | 1533 | 1600 |  | <-- Index function
 |  |  |  |  |  | 8 | 70 | 67.81 | 60.88000000000005 | 68.44 |  | <-- Index function
 |  |  |  |  |  |  | 75 | 73.97 | 74.1251 | 74.44 |  | <-- interpolation
 |  |  |  |  |  | 9 | 80 | 80.13 | 76.71999999999997 | 80.44 |  | <-- Index function
 |  |  |  |  |  | Match function | Index function
Spreadsheet: 689307d1596281316-need-formula-to-count-by-two-way-lookup-book3
Sheet: Sheet1

Criteria 1 | Criteria2 | Req.Result | Column1 | For Criteria 1 | For [NAME]
03.ABC | [NAME]
03.ABC | WXYZ1490
03.ABC | WXYZ1510
03.ABC | [NAME]
03.ABC | [NAME]
03.ABC | WXYZ1510
04.XYZ | WXYZ1490
03.ABC | [NAME] |  |  |  |  |  |  |  |  |  | Need to Count Criteria 1 based on criteria 2
03.ABC | WXYZ1490
04.XYZ | [NAME]
16.PQR | WXYZ1330
16.PQR | WXYZ1330
03.ABC | [NAME]
03.ABC | [NAME]
03.ABC | [NAME]
03.ABC | [NAME]
03.ABC | [NAME]
03.ABC | [NAME]
03.ABC | [NAME]
03.ABC | [NAME]
03.ABC | [NAME]
03.ABC | [NAME]
03.ABC | [NAME]
03.ABC | [NAME]
03.ABC | [NAME]
03.ABC | [NAME]
03.ABC | WXYZ1510
03.ABC | WXYZ1510
05.EFG | WXYZ1510
03.ABC | WXYZ1510
Spreadsheet: 680095d1590774129-data-horizontal-to-vertical-with-one-condition-2020-05-29-oeldere-ionelz-680090d1590771946-data-horizontal-to-vertical-with-one-condition-q1
Sheet: Sheet1

 |  | 12345678 | BX12345 | 55667788 | 11332266 | 99114433 |  | 12345678
 |  |  |  |  |  |  |  | 55667788
 |  | x | x | x | n/a |  |  | 11332266
 |  | k |  | x | n/a
 |  | x | k | x | n/a
 |  | n/a |  | x | n/a
 |  | x | n/a | x | k
 |  | x |  | x | x
help
count
 |  | have Horizontal Data in C2:G2
 |  | I want this data to be listed Vertical and consecutive at I2 but with one condition
 |  | Example :
 |  | C2 is listed because there is data in all C4:C9
 |  | D2 is not listed because D4:D9 has missing data
 |  | E2 is listed because there is data in all E4:E9
 |  | ...
Spreadsheet: 35857d1233588610-info-appearing-after-reach-date-maintenance
Sheet: Sheet1

Equipment | Maintenance date |  |  | Maintenance list |  | Today: | 2009-02-02 00:00:00
Equipment1 | 2009-02-03 00:00:00 |  |  | Equipment1
Equipment2 | 2009-02-03 00:00:00 |  |  | Equipment2
Equipment3 | 2009-02-03 00:00:00 |  |  | Equipment3
Equipment4 | 2009-02-06 00:00:00 |  |  | Equipment4
Equipment5 | 2009-02-04 00:00:00 |  |  | Equipment5
Equipment6 | 2009-01-31 00:00:00 |  |  | Equipment8
Equipment7 | 2009-01-28 00:00:00 |  |  | Equipment9
Equipment8 | 2009-02-06 00:00:00 |  |  | Equipment10
Equipment9 | 2009-02-05 00:00:00 |  |  | Equipment11
Equipment10 | 2009-02-05 00:00:00 |  |  | Equipment12
Equipment11 | 2009-02-02 00:00:00 |  |  | Equipment14
Equipment12 | 2009-02-05 00:00:00 |  |  | Equipment15
Equipment13 | 2009-01-29 00:00:00 |  |  | Equipment16
Equipment14 | 2009-02-02 00:00:00 |  |  | Equipment18
Equipment15 | 2009-02-05 00:00:00
Equipment16 | 2009-02-06 00:00:00
Equipment17 | 2009-01-29 00:00:00
Equipment18 | 2009-02-03 00:00:00
Equipment19 | 2009-02-01 00:00:00
Equipment20 | 2009-01-31 00:00:00
Spreadsheet: sally_beck__35759__MgmtSum-Q1-0331-PRELIM-C
Sheet: Rollforward

Management Summary Rollforward
March 31 to April 3
Management Summary, 3/31 |  |  |  |  |  |  | 40.469
DPR Changes:
 | Gas Trading
 | Power Trading
 | Genco
 | Financial Trading
 | Other Trading
Portfolio Movement |  |  |  |  |  |  | 4.5
Deal, Forecast, and Other Changes:
 | CGas |  |  |  |  |  | -3
 | Cost of Funds |  |  |  |  |  | 3
 | Group |  |  |  |  |  | -5
 | Prudency Reserve |  |  |  |  |  | -6.5
Total Daily Change
Management Summary, 4/3
Spreadsheet: michelle_lokay__27347__EOLTWdeals
Sheet: EOLOct01

 |  |  |  |  | New This Week
 | PRODUCTION  MONTH : |  |  |  | 2001-09-01 00:00:00 |  |  |  | Transwestern Pipeline Company
 | Contract | Shipper |  | Non | Term | Term | Monthly | # |  | Demand | Demand | Commodity | Total | Monthly | Monthly | Total Monthly | NOTES
 | # |  | Daily | [NAME] | Start | End | Volume | Days | MDQ | Monthly $ | Daily $ | per [NAME] | Rate | Demand | Commodity | Revenue
1 | 27713 | Burlington Resources | n | EOL | 2001-10-01 00:00:00 | 2001-10-31 00:00:00 |  | 31 | 15000 |  | 0.05 | 1-Part |  |  | 0 |  | La Maquina to I/B Link
 | Total Deals
 |  |  |  |  |  |  | MMBtu |  | MMBtu |  |  |  |  | Monthly Demand | Commodity | Total Revenue
Spreadsheet: 759251d1639443321-need-help-merging-two-lists-to-a-third-custom-list-with-calculated-fields-listing-matched-and-unmatched-items-kostas90-
Sheet: Sheet2

Product | Quantity | Product | Quantity | FinalProduct | FinalQuantity
11023 | 20 | 11023 | 20 | 11023 | 20
11030 | 20 | 11030 | 19 | 11030 | 1
11031 | 20 | 11031 | 21 | 11031 | 21
11040 | 20 | 11050 | 50 | 11040 | 20
 |  | 11060 | 20 | 11050 | 50
 |  |  |  | 11060 | 20
Spreadsheet: 673727d1587499939-nested-formula-not-working-with-conditional-formatting-example1
Sheet: Example

21 Days | Immuno-compromised? | Inpatient? Y/N | LastUpdated | Unit | DischargeDate
 | Y- Immunocomp |  | 2020-03-23 11:14:02.290000 | 9W | 2020-04-02 15:47:00
 | Y- CCBD |  | 2020-03-24 08:53:46.667000 | HEM/ONC/BMT INPT | 2020-03-25 16:35:00
 | Y- CCBD |  | 2020-03-24 08:53:46.757000 | HEM/ONC/BMT INPT | 2020-03-26 10:02:00
 | N |  | 2020-03-25 10:54:26.440000 | 9W | 2020-03-26 10:54:00
 | Y- CCBD |  | 2020-03-25 21:53:52.633000 | CCBDCSH | 2020-03-26 11:16:55
 | N |  | 2020-03-30 08:50:34.257000 | NICU SOUTH | 2020-03-31 13:56:00
 | N |  | 2020-03-30 11:44:09.393000 | 9W | 2020-03-31 17:54:00
 | N |  | 2020-03-31 18:53:49.217000 | 9W | 2020-04-01 15:28:00
 | N |  | 2020-04-01 08:34:14.113000 | 9W | 2020-04-03 18:32:00
 | N |  | 2020-04-01 23:43:47.680000 | NICU SOUTH | 2020-04-04 14:45:00
 | N |  | 2020-04-02 08:23:35.143000 | NICU SOUTH | 2020-04-05 11:55:00
 | N |  | 2020-04-03 04:33:21.413000 | [NAME] | 2020-04-02 17:16:00
 | N |  | 2020-04-03 09:25:43.203000 | 9W | 2020-04-07 12:27:00
 | ? - CCBD |  | 2020-04-03 12:23:55.217000 | [NAME]
 | N |  | 2020-04-06 03:13:53.120000 | 9W | 2020-04-07 12:28:00
 | N |  | 2020-04-06 03:43:13.380000 | 9W | 2020-04-06 12:58:00
 | N |  | 2020-04-06 18:03:47.450000 | PICU
 | N |  | 2020-04-09 01:23:29.750000 | 9W | 2020-04-09 15:01:00
 | Y- CCBD |  | 2020-04-13 07:50:00.517000 | HEM/ONC/BMT INPT
 | N |  | 2020-04-13 07:43:52.260000 | NICU SOUTH
 | N |  | 2020-04-14 19:03:28.977000 | [NAME] | 2020-04-14 17:50:00
 | Deceased |  | 2020-04-15 22:03:51.333000 | PICU | 2020-04-21 00:00:00
 | N |  | 2020-04-15 13:44:29.627000 | RCOL-ANSCH
 | N |  | 2020-04-15 13:44:29.597000 | RCOL-ANSCH
 | N |  | 2020-04-15 13:44:29.557000 | RCOL-ANSCH
 | N |  | 2020-04-16 10:54:26.793000 | RCOL-ANSCH
 | N |  | 2020-04-16 23:53:41.460000 | 9W
 | Y- Immunocomp |  | 2020-04-16 19:43:39.070000 | [NAME] | 2020-04-16 17:00:00
 | N |  | 2020-04-17 22:53:43.267000 | RCOL-ANSCH
 | N |  | 2020-04-18 02:05:57.950000 | IPNCH | 2020-04-19 17:30:00
 | N |  | 2020-04-18 16:43:47.517000 | INPATIENT UNIT - SOUTH | 2020-04-19 16:28:00
 | Y- Immunocomp |  | 2020-04-18 14:43:38.770000 | RCOL-ANSCH
 | N |  | 2020-04-18 16:53:36.197000 | RCOL-ANSCH
 | ?- PICU |  | 2020-04-18 15:23:47.850000 | 9W
 | N |  | 2020-04-19 00:14:03.533000 | 8W
 | N |  | 2020-04-20 15:44:25.150000 | 9W
 | N |  | 2020-04-20 17:04:22.483000 | 9W
 | N |  | 2020-04-20 22:33:24.937000 | RCOL-ANSCH
 | N |  | 2020-04-20 23:24:02.943000 | PICUCSH
Spreadsheet: 779331d1651702281-if-then-formula-help-22-01a-forney-hs-paving-audit
Sheet: SETUP

PO # | CSP # | SCOPE | CONTRACTOR | BASE | ALLOWANCE | ALT#1 - Replace Existing Light Poles & Fixtures | ADJUSTMENTS | TOTAL PROJECT | BUDGET ALLOCATIONS
CONSTRUCTION COSTS TOTAL
 | 1-26-A | Electrical | Intex Electrical Contractors, Inc. | 33546 |  | 28985
 | 1-31-A | Excavation | The Holbrook Company, Inc. | 83845
 | 1-32-A | Concrete Paving | JDS Contractors LLC | 295300 | 50000
 | 1-3215 | Pole Bases for Alt. 1 | Estimate - BA to [NAME], if required |  |  | 3000
 | 1-32-B | Landscape and Irrigation | Texas Yard Pro, INC. | 46640 | 5000
 | 1-33-A | Site Utilities | J&K Moore Enterprises LLC | 35000
 | 1-1111 | Survey and Layout | Estimate | 2500
 | 1-1155 | Temporary Construction Fence | Estimate | 7500
 | 1-1150 | Temporary Toilets | Estimate | 5000
 | 1-1110 | Subsurface Investigation - Utility Locate | Estimate | 10000
 | 1-31531 | Clean Up Equipment | Estimate | 5000
 | 1-31331 | Grading Equipment | Estimate | 5000
 | 1-31231 | General Cleanup | Estimate | 10000
 | 1-1161 | SWPPP Book/Silt Fence/Repairs | Estimate | 15000
 | 1-1253 | Mailing/Shipping Provisions | Estimate | 500
 | 1-1700 | Closeout Document Scanning | Estimate | 5000
 | 1-1040 | Builder's Risk Insurance | Estimate | 2500
 | 1-1335 | Contruction Contingency | Estimate | 50000
 | 1-411 | Construction Manager's Fee | Gallagher | 63368 |  | 3217
CONSTRUCTION COSTS TOTAL
FEES AND OWNER'S DIRECT EXPENSES
 | 2-511 | Civil Engineer | Estimate | 39536 |  | 2640
 | 2-509 | Geotechnical Reports | Estimate | 10000
 | 2-1420 | Material Testing and Inspection | Estimate | 20000
 | 2-1254 | Printing | Estimate | 500
 | 2-1140 | Construction Waste Removal Services | Estimate | 10000
 | 2-574 | Building Permit/Plan Review/Inspections | Estimate | 7500
 | 2-517 | TAS Reviews and Inspections | Estimate | 2000
FEES AND OWNER'S DIRECT EXPENSES TOTAL
FURNITURE ,FIXTURES, & EQUIPMENT (FF&E)
 | 3-12500 | Furniture, Fixtures, and Equipment |  | 0
FURNITURE ,FIXTURES, & EQUIPMENT (FF&E) TOTAL
[NAME]
 | 4-1121 | Owner Contingency | Estimate | 25000
[NAME] CONTINGENCIES TOTAL
TOTAL COST
 |  |  |  |  |  |  |  | 943094
Spreadsheet: 84356d1284403233-ignore-duplicate-values-in-conditional-formatting-example
Sheet: Data 1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wrong |  | Right
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10
Spreadsheet: kate_symes__18698__SP 15 pages
Sheet: DJ SP15

 |  |  | Firm | Volume | Firm | Volume | Sun & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-02-22 00:00:00 |  | 229.75 | 23200 | 149.39 | 6448
 | 2001-02-21 00:00:00 |  | 236.72 | 25840 | 160.28 | 7840
 | 2001-02-20 00:00:00 |  | 262.61 | 9200 | 190 | 5200
 | 2001-02-19 00:00:00 |  | 262.12 | 13200 | 190.74 | 5400
 | 2001-02-18 00:00:00 |  |  |  |  |  | 261.52 | 23280
 | 2001-02-17 00:00:00 |  | 323.71 | 16720 | 264.62 | 8840
 | 2001-02-16 00:00:00 |  | 431.67 | 19680 | 296.75 | 12600
 | 2001-02-15 00:00:00 |  | 431.67 | 19680 | 296.75 | 12600
 | 2001-02-14 00:00:00 |  | 267.18 | 20320 | 202.45 | 6200
 | 2001-02-13 00:00:00 |  | 233.43 | 13520 | 159.16 | 7400
 | 2001-02-12 00:00:00 |  | 195.13 | 7760 | 159.51 | 6920
 | 2001-02-11 00:00:00 |  |  |  |  |  | 159.15 | 18960
 | 2001-02-10 00:00:00 |  | 154.29 | 10160 | 124.69 | 6320
 | 2001-02-09 00:00:00 |  | 154.29 | 10160 | 124.69 | 6320
 | 2001-02-08 00:00:00 |  | 175.42 | 14400 | 142.48 | 5160
 | 2001-02-07 00:00:00 |  | 170.73 | 11184 | 140.82 | 10680
 | 2001-02-06 00:00:00 |  | 167.38 | 11280 | 146.9 | 6640
 | 2001-02-05 00:00:00 |  | 165.77 | 7120 | 151.67 | 6392
 | 2001-02-04 00:00:00 |  |  |  |  |  | 152.31 | 20376
 | 2001-02-03 00:00:00 |  | 181.02 | 12256 | 156.16 | 8432
 | 2001-02-02 00:00:00 |  | 179.62 | 13336 | 156.19 | 7512
 | 2001-02-01 00:00:00 |  | 219.11 | 13984 | 176.57 | 4368
 | 2001-01-31 00:00:00 |  | 238.8 | 20288 | 184.92 | 4640
 | 2001-01-30 00:00:00 |  | 222.41 | 19968 | 176.45 | 6240
 | 2001-01-29 00:00:00 |  | 227.4 | 21840 | 181.89 | 4440
 | 2001-01-28 00:00:00 |  |  |  |  |  | 181.89 | 13320
 | 2001-01-27 00:00:00 |  | 211.11 | 21472 | 172.47 | 4456
 | 2001-01-26 00:00:00 |  | 211.11 | 21392 | 172.47 | 4456
 | 2001-01-25 00:00:00 |  | 208.12 | 14880 | 179.01 | 6280
 | 2001-01-24 00:00:00 |  | 222.73 | 18880 | 169.8 | 6240
 | 2001-01-23 00:00:00 |  | 251.47 | 12800 | 171.59 | 5800