tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 5286b2e8-4db3-4caf-832c-445b3064fb71
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
FPANC | Test | FPANC | Pancreatic Elastase Stool | Pancreatic Elastase in Stool | ELISA |  |  |  |  |  | Collect 1 gm random formed stool, ship frozen. Separate specimens  must be submitted when multiple tests are ordered.   Note:  1)    Pancreatic enzyme supplementation therapy should be                      discontinued prior to sample collection. 2)	A watery, diarrheal stool is not recommended for this test as some dilutions during the assay may give lower E1                        concentrations than are actually present. | 1 gm | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | 200 to >500 ug Elastase/g stool = Normal 100 to 200 ug Elastase/g stool = Moderate to slight exocrine                                                                 pancreatic insufficiency <100 ug Elastase/g stool = Severe exocrine pancreatic                                                       insufficiency   Test Performed By: [NAME], Inc.                                         2451 Wehrle Drive                                         Williamsville, NY 14221 | Set up 1 time per week | 1 day | 10 days | 1 | 82656 |  |  |  |  | Joli Diagnostics, Inc.
FPANC | [NAME] | FECAL | Fecal |  |  |  | Frozen | 365 days
FPANC | Result | Z0947 | Patient Value: | Patient Value: | Alphanumeric |  |  |  |  | ug E/g stool |  |  |  |  |  |  |  |  |  | In Process
FPANC | Result | Z0945 | Interpretation: | Interpretation: | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 145875d1331790808-transfer-data-from-one-sheet-to-another-when-specific-value-entered-in-first-sheet-example_2012_file
Sheet: Apr

Reporter | Date Rec. | Date Comp. | Witness | Description | Pages Rec | Pages Rtn | Job Type | Rate | Total | Tithe Amount | Tithed | Invoice # | Invoice Date | Date Paid | Monthly Tithe | Tithed MTD | Left to Tithe | Total | Amount Received | Total By Reporter | Amount Due | Amount Received
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jeanne
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Karisa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: larry_campbell__21311__LFC0700V1
Sheet: PSE ACTUALS

Pipeline | Status | ProdYear | ProdMonth | LDCMeter | ReadDate | ReadUnit | Quantity | BillFrom | BillTo | BTU |  | CustomerName
PSE | A | 2000 |  | 2100396056 |  | dth |  |  |  |  |  | ABD INC.
PSE | A | 2000 |  | 5200495482 |  | dth |  |  |  |  |  | ANGELICA HEALTH CARE
PSE | A | 2000 |  | 2105495338 |  | dth |  |  |  |  |  | BAYONNE HOSPITAL
PSE | A | 2000 |  | 1100298215 |  | dth |  |  |  |  |  | BENNETT HEAT TREATING CO
PSE | A | 2000 |  | 3100299043 |  | dth |  |  |  |  |  | DUROTEST CORPORATION
PSE | A | 2000 |  | 5204895280 |  | dth |  |  |  |  |  | ETHICON INC
PSE | A | 2000 |  | 5101095370 |  | dth |  |  |  |  |  | FRIGIDAIRE CO
PSE | A | 2000 |  | 5101195073 |  | dth |  |  |  |  |  | FRIGIDAIRE CO
PSE | A | 2000 |  | 6200296154 |  | dth |  |  |  |  |  | HOMASOTE CO
PSE | A | 2000 |  | 6200695652 |  | dth |  |  |  |  |  | J & J CONSUMER PRODS INC
PSE | A | 2000 |  | 6200695768 |  | dth |  |  |  |  |  | J & J PRODUCTS
PSE | A | 2000 |  | 6200698058 |  | dth |  |  |  |  |  | JOHNSON & JOHNSON
PSE | A | 2000 |  | 6200697450 |  | dth |  |  |  |  |  | JOHNSON & JOHNSON C P I
PSE | A | 2000 |  | TSGCOMM |  | dth |  |  |  |  |  | MARRIOTT,ST JAMES,ST MICHAEL
PSE | A | 2000 |  | 6400696210 |  | dth |  |  |  |  |  | MC GUIRE AIR FORCE BASE
PSE | A | 2000 |  | 6200695954 |  | dth |  |  |  |  |  | OCEAN SPRAY CRANBERRIES
PSE | A | 2000 |  | 1200495926 |  | dth |  |  |  |  |  | ORANGE MEMORIAL HOSPITAL
PSE | A | 2000 |  | 5200295580 |  | dth |  |  |  |  |  | ORTHO DIAGNOSTIC INC
PSE | A | 2000 |  | 5200295688 |  | dth |  |  |  |  |  | ORTHO PHARMACEUTICAL
PSE | A | 2000 |  | 6200696268 |  | dth |  |  |  |  |  | PRINCETON PLASMA PHY LAB
PSE | A | 2000 |  | 1200495438 |  | dth |  |  |  |  |  | REHEIS CO (NON-FIRM)
PSE | A | 2000 |  | 1200396723 |  | dth |  |  |  |  |  | REHEIS CO (FIRM)
PSE | A | 2000 |  | 4104995568 |  | dth |  |  |  |  |  | RIVER RIDGE CONDO ASSOC
PSE | A | 2000 |  | 5200195187 |  | dth |  |  |  |  |  | VETERANS HOSPITAL
PSE | A | 2000 |  | 6200698058 |  | dth |  |  |  |  |  | JOHNSON & JOHNSON
PSE | E | 2000 |  | FTSCOMM |  | dth |  |  |  |  |  | FTSCOMM-CONOPCOLIPTON-FT.DIX
PSE | E | 2000 |  | 4126098860 |  | dth |  |  |  |  |  | CONOPCO LIPTION
PSE | E | 2000 |  | 6424103686 |  | dth |  |  |  |  |  | FT. DIX
Spreadsheet: 704326d1605505397-retrieving-annual-returins-using-lookup-functions-in-big-data-lists-excel-test-function-123
Sheet: Sheet1

 |  |  |  | A | B | C
 |  |  | 2017
 |  |  | 2018
 |  |  | 2019
 |  |  | 2020
 |  | A | B | C
 | 2017-01-01 00:00:00 | 100 | 100 | 100
Spreadsheet: 227172b9-ed9d-4812-9ae4-3a69bdd4b94f
Sheet: Pub Date

Month | Titles | Percentage
Jan | 30
Feb | 23
Mar | 29
Apr | 44
May | 51
June | 36
July | 30
Aug | 38
Sept | 35
Oct | 63
Nov | 39
Dec | 34
Spreadsheet: 9a604cce-a2f9-4373-8960-923874030d32
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7939 | 50772 | [NAME] | Hopkins | CAN | 70 | 00:06:18 | 00:02:33 | 00:37:58 | 00:01:30 | 00:20:07 | 1 | 01:08:28
7939 | 25144 | [NAME] | Price | USA | 71 | 00:07:19 | 00:03:05 | [NAME] | 00:01:32 | 00:31:43 | 2 | 01:24:45
7939 | 32630 | [NAME] | Jenkins | NZL | 72 | 00:05:08 | 00:03:20 | 00:48:13 | 00:02:01 | 00:29:49 | 3 | 01:28:34
Spreadsheet: 862186d1709927015-date-and-data-help-training-per-day-dj
Sheet: Schedule

 | Year | 2024 | Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | Column21 | Column22 | Column23 | Column24 | Column25 | Column26
 | Month | 4 | Weekday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 19 | 20 | 21 | 22 | 23
 | Name - EMP. ID |  | Month
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EMP. ID | Name | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 836140d1689122394-please-provide-the-3-required-formulas-according-to-expected-results-in-table-vlockup-formula
Sheet: Sheet1

Data |  | Expected | Expected | Expected
Old | New | In Old But Not In New | In New But Not In Old | In Both Old And New
a | g | b | g | a
b | a | e | i | c
c | i | f | k | d
d | c
e | k
f | d
Spreadsheet: 271982d1382123265-logical-formulas-for-schedule-creation-master-schedule-template
Sheet: Wednesday Show

 | WEDNESDAY, MARCH 26
 | 9-10a | 10-11a | 11a-12p | 12-1p | 1-2p | 2-3p | 3-4p | 4-5p | 5-6p | 6-7p | 7-8p | 8-9p | 9-10p
Spreadsheet: 64e191bd-9ba6-4b21-a1d0-7f5c25f12665
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5238 | 34077 | [NAME] | Ahrens | USA | 0 | 00:52:01 | 00:02:05 | 01:13:25 | 00:01:56 | 00:28:24 | 1 | 02:37:55
Spreadsheet: 780985d1652915726-calculate-hours-worked-at-day-rate-and-night-rate-minus-breaks-example-schedule-ans5
Sheet: Daily Rota

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Saturday |  |  |  |  | Sunday |  |  |  |  | Monday |  |  |  |  | Tuesday |  |  |  |  | Wednesday |  |  |  |  | Thursday |  |  |  |  | Friday
Name | Saturday |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Total Paid Hours | Total Hours | Total Night Hours Between Midnight & 05:00 | Total Day Hours Between 05:00 & Midnight | Break Entitlement (Based On Total Hours) | Total Paid Hours | Total Hours | Total Night Hours Between Midnight & 05:00 | Total Day Hours Between 05:00 & Midnight | Break Entitlement (Based On Total Hours) | Total Paid Hours | Total Hours | Total Night Hours Between Midnight & 05:00 | Total Day Hours Between 05:00 & Midnight | Break Entitlement (Based On Total Hours) | Total Paid Hours | Total Hours | Total Night Hours Between Midnight & 05:00 | Total Day Hours Between 05:00 & Midnight | Break Entitlement (Based On Total Hours) | Total Paid Hours | Total Hours | Total Night Hours Between Midnight & 05:00 | Total Day Hours Between 05:00 & Midnight | Break Entitlement (Based On Total Hours) | Total Paid Hours | Total Hours | Total Night Hours Between Midnight & 05:00 | Total Day Hours Between 05:00 & Midnight | Break Entitlement (Based On Total Hours) | Total Paid Hours | Total Hours | Total Night Hours Between Midnight & 05:00 | Total Day Hours Between 05:00 & Midnight | Break Entitlement (Based On Total Hours) | Total Paid Hours |  | 05:00:00 |  |  |  |  |  | Break rules | Hrs | Eligible
Staff Member 1 | 22:00:00 | 06:00:00 | 12:00:00 | 04:00:00 | 12:00:00 | 04:00:00 | 12:00:00 | 04:00:00 | 12:00:00 | 04:00:00 | 12:00:00 | 04:00:00 | 12:00:00 | 04:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Break Rules 4 hours or more but <6 hours = 15 minutes 6 hours or more but <8 hours = 30 minutes 8 hours or more but <9 hours = 45 minutes 9 hours or more but <11 hours = 1 hour 11 hours or more = 90 minutes |  |  |  |  |  |  | 0 | 0
Staff Member 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0.25
Staff Member 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 0.5
Staff Member 4 |  |  |  |  |  |  | 12:00:00 | 04:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 0.75
Staff Member 5 |  |  | 12:00:00 | 04:00:00 | 12:00:00 | 04:00:00 | 12:00:00 | 04:00:00 | 12:00:00 | 04:00:00 | 12:00:00 | 04:00:00 | 12:00:00 | 04:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 1
Spreadsheet: 880304d1727934757-xlookup-and-return-closest-text-match-xlookup-and-return-closest-text-match-revised
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | [NAME] | Result Wanted
 |  |  | [NAME] |  |  |  |  |  |  | Smith, [NAME] |  | [NAME]
 |  |  | [NAME] |  |  |  |  |  |  | Jones, [NAME] | [NAME] | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  |  | B Smith | [NAME] | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  |  | MJ Jones | [NAME] | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Return value that corresponds with closest text match
Spreadsheet: kate_symes__18339__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-04-19 00:00:00 |  | 273.89 | 15536 | 203.31 | 7832
 | 2001-04-18 00:00:00 |  | 273.89 | 15536 | 203.31 | 7832 | 311.3 | 1840 | 232.11 | 1075
 | 2001-04-17 00:00:00 |  | 273.89 | 15536 | 203.31 | 7832 | 337.92 | 120 | 157.38 | 965
 | 2001-04-16 00:00:00 |  | 379.99 | 21296 | 356.66 | 8480 | 359.26 | 135 | 202.5 | 100
 | 2001-04-15 00:00:00 |  | 368.33 | 1200 | 350 | 0 | 400 | 50 | 325 | 25 |  | 357.42 | 27864
 | 2001-04-14 00:00:00 |  | 369.89 | 22096 | 344.35 | 6848 | 365.25 | 505 | 346 | 0
 | 2001-04-13 00:00:00 |  | 369.89 | 22096 | 343.87 | 6048 | 392.86 | 420 | 421.33 | 60
 | 2001-04-12 00:00:00 |  | 411.66 | 16160 | 376.19 | 5352 | 431.44 | 1740 | 339.62 | 419
 | 2001-04-11 00:00:00 |  | 386.02 | 10560 | 337.56 | 7552 | 391.16 | 540 | 372.42 | 291
 | 2001-04-10 00:00:00 |  | 379.15 | 19760 | 331.04 | 9192 | 398 | 621 | 337.4 | 615
 | 2001-04-09 00:00:00 |  | 311.43 | 19600 | 264.75 | 6584 | 334.15 | 437 | 337.5 | 100
 | 2001-04-08 00:00:00 |  | 273.75 | 1600 | 255 | 0 | 349.76 | 1330 | 342.22 | 135 |  | 264.68 | 20136
 | 2001-04-07 00:00:00 |  | 291.19 | 18496 | 225.83 | 11824 | 293.05 | 1559 | 279.89 | 435
 | 2001-04-06 00:00:00 |  | 291.19 | 18496 | 225.83 | 11824 | 290.88 | 400 | 227.31 | 325
 | 2001-04-05 00:00:00 |  | 348.81 | 22560 | 266.94 | 2480 | 259.38 | 200 | 158.94 | 610
 | 2001-04-04 00:00:00 |  | 314.36 | 18160 | 238.83 | 8040 | 307.45 | 455 | 246.52 | 460
 | 2001-04-03 00:00:00 |  | 305.4 | 18160 | 224.33 | 7200 | 300.45 | 350 | 288.25 | 1310
 | 2001-04-02 00:00:00 |  | 284.36 | 24400 | 227.63 | 9504 | 294.16 | 942 | 216.95 | 351
 | 2001-04-01 00:00:00 |  | 236.99 | 2336 | 225 | 0 | 243.67 | 158 | 219.78 | 273 |  | 229.73 | 26352
 | 2001-03-31 00:00:00 |  | 179.66 | 24400 | 125.17 | 9640 | 220.77 | 698 | 100 | 4
 | 2001-03-30 00:00:00 |  | 179.99 | 23600 | 125.18 | 9040 | 203.23 | 798 | 173.41 | 504
 | 2001-03-29 00:00:00 |  | 187.27 | 26400 | 130.98 | 10880 | 181.96 | 553 | 151.95 | 154
 | 2001-03-28 00:00:00 |  | 161.91 | 27600 | 100.36 | 9480 | 170.67 | 208 | 110.85 | 544
 | 2001-03-27 00:00:00 |  | 155.95 | 22800 | 89.58 | 6200 | 152.08 | 1038 | 121.24 | 169
 | 2001-03-26 00:00:00 |  | 334.36 | 15600 | 230.55 | 6600 | 102.59 | 243 | 60.96 | 287
 | 2001-03-25 00:00:00 |  | 260 | 0 | 230 | 0 | 70 | 200 | 41.32 | 456 |  | 229.94 | 19200
 | 2001-03-24 00:00:00 |  | 312.79 | 15600 | 217.52 | 5960 | 113.77 | 1687 | 139.44 | 832
 | 2001-03-23 00:00:00 |  | 312.79 | 15600 | 217.52 | 5960 | 331.82 | 1155 | 150 | 4
 | 2001-03-22 00:00:00 |  | 377.69 | 16800 | 274.53 | 6400 | 233.97 | 521 | 266.13 | 248
 | 2001-03-21 00:00:00 |  | 452.08 | 17280 | 319.69 | 4928 | 443.97 | 58 | 294.11 | 259
 | 2001-03-20 00:00:00 |  | 402.53 | 16000 | 277.64 | 5952 | 456.15 | 488 | 316.05 | 214
 |  |  |  |  |  | ..
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Dawn Mist

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2018-03-02 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2018-03-02 00:00:00
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: 3Inter O&M 11-20

Table 5.2.30.  Present Value of Intermittent Operations and [NAME] (Years 11-20)
 |  |  |  |  |  |  |  |  |  |  |  | EPA Discount Rate:
 |  |  |  | Present Value of O&M Costs for Year:
Component | Unit Cost | Unit | Quantity | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 |  |  | Total Present Value of Intermittent Operations & Maintenace Costs (Years 11-20):
 |  |  |  |  |  |  |  |  |  |  |  | Total Present Value of Intermittent Operations & Maintenance Costs (Life of Project):
Spreadsheet: 153226d1335808828-making-a-schedule-with-auto-time-format-and-adding-total-hours-se-schedule
Sheet: September 5

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2011-09-05 00:00:00 | 2011-09-06 00:00:00 | 2011-09-07 00:00:00 | 2011-09-08 00:00:00 | 2011-09-09 00:00:00 | 2011-09-10 00:00:00
[NAME] | holiday | off | 8:00-5:00 | 9:00-5:00 | 8:30-5:30 | 9:15-5:15
 |  |  | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 38
[NAME] | holiday | 9:30-5:30 | off | 9:30-5:30 | 8:30-5:30 | 9:15-5:15
 |  | 2:00-3:00 |  | 2:00-3:00 | 2:00-3:00 | n/l | 38
Ray | holiday | 8:00-5:00 | 8:00-4:00 | 7:00-4:00 | off | 9:00-5:00
 |  | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 |  | 1:00-2:00 | 38
Mark | holiday | 9:00-5:00 | 8:30-5:30 | 8:30-5:30 | 8:00-4:00
 |  | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 |  | 38
[NAME] | holiday | 8:30-5:30 | 9:30-5:30 | 7:00-4:00-HOMER | 9:30-5:30-counter
ctr 12-2 |  | 11:00-12:00 | 11:00-12:00 | 12:00-1:00 | 11:00-12:00 |  | 38
Kat |  |  | 8:00-5:00 |  |  | 9:15-5:15
 |  |  | 12:00-1:00 |  |  | 12:00-1:00 | 15
 |  |  | 12:00-1:00 |  |  | 12:00-1:00
 |  |  |  |  |  | total hours
Spreadsheet: 118190d1313512986-count-frequency-of-visits-with-conditions-visits
Sheet: Pivot Table

Status | Y |  | Row Labels | Count of Status
 |  |  | 12345 | 3
Row Labels | Count of Status |  | 12348 | 3
12345 | 2 |  | 12349 | 2
12348 | 3 |  | 12350 | 1
12350 | 1 |  | Grand Total | 9
Grand Total | 6
Spreadsheet: 90119d1289883712-average-d3-on-each-worksheet-if-a1-is-a-weekday-p002a-arc-monthly-workbook
Sheet: AvgCalc

 |  |  |  |  |  | w | w | s
Wkdy |  | Sat | Sun
 |  |  |  |  |  |  | 5 | 7
AT1
AT2 Average
AT4 Average
AT5 Average
AT6 Average
AT7 Average
AT8 Average
AT10 Average
AT11 Average
[NAME]
SR-1 Average
SR-2 Average
99
 |  |  | Average Weekday Ridership
Spreadsheet: 717642d1612788057-extracting-numbers-from-a-text-thread-within-an-array-and-forming-a-column-book1
Sheet: Daily Report

Date | ORIGIN | Cat 1 | Cat 2 | Cat 3 | Cat 4 | Cat 5 | Cat 6 | Cat 7 | Cat 8 | Cat 9 | Cat 10 | Cat 11 | Cat 12 | Cat 13 | Cat 14 | Cat 15 | Cat 16 | Cat 17 | Cat 18 | Cat 19 | Cat 20 | Cat 21
2021-01-30 00:00:00 | City3
2021-01-31 00:00:00 | City1
2021-01-31 00:00:00 | City1
2021-01-31 00:00:00 | City2
2021-01-31 00:00:00 | City3
2021-02-01 00:00:00 | City1 |  |  |  | Code 149221, customer complaint that xyz
2021-02-01 00:00:00 | City2
2021-02-01 00:00:00 | City3
2021-02-02 00:00:00 | City1 | Code 135905, customer complaint that xyz |  |  |  | Code 23322, customer complaint that xyz
2021-02-02 00:00:00 | City2
2021-02-02 00:00:00 | City3 |  |  |  |  |  | Code 149237, customer complaint that xyz
2021-02-03 00:00:00 | City1
2021-02-03 00:00:00 | City1 |  |  |  |  |  | Code 23595,  customer complaint that xyz
2021-02-03 00:00:00 | City2
2021-02-03 00:00:00 | City3 |  |  |  |  |  |  | Code 144019, customer complaint that xyz
2021-02-04 00:00:00 | City1
2021-02-04 00:00:00 | City2
2021-02-04 00:00:00 | City3
2021-02-06 00:00:00 | City1
2021-02-06 00:00:00 | City2
2021-02-06 00:00:00 | City3
 |  |  | Code numbers
 |  |  | 149221
 |  |  | 135905
 |  |  | 23322
 |  |  | 149237
 |  |  | 23595
 |  |  | 14019
Spreadsheet: 865082d1712157884-sum-of-max-values-by-group-samplefile
Sheet: pvt

 |  | Should Show Max/langauge
Section | Language | Sum of Amount | [NAME] of Amount2
[NAME] | Arabic | 40 | 10
[NAME] | Czech | 36 | 9
[NAME] | Dutch | 76 | 19
[NAME] | English | 44 | 11
[NAME] | French | 44 | 11
[NAME] | German | 84 | 21
[NAME] | Hebrew | 40 | 10
[NAME] | Italian | 60 | 15
[NAME] | Polish | 28 | 7
[NAME] | Spanish | 40 | 10
[NAME] | Swedish | 36 | 9
[NAME] | Turkish | 24 | 6
Lab | English | 9 | 3
Lab | French | 24 | 8
Lab | German | 3 | 1
Grand Total |  | 588 | 21 | <-------instead of [NAME], the grand total should show the sum of all MAX value
Spreadsheet: 833791d1687259735-how-to-return-a-value-in-a-column-when-a-match-is-found-in-a-below-array-lookup-example-v4_with-formula
Sheet: OVERVIEW

CATEGORY | OVERVIEW
1 |  |  |  | Cell [NAME] is where I want the lookup forumla to sit to search for WHO is doing the task
 | Task | Mop |  | Cell B6 is where I want lookup formular to search for the DATE the task is to done
2 |  |  |  | Cell C6 is the lookup value I want to use to search the planner tab with (for both WHO and DATE)
 | Task | Vacuum
3 |  |  |  | I will then duplicate the above formula into rows 7, 9 etc…
 | Task | Polish
4
 | Task | Wash Dishes
5
 | Task | Clean Curtain
6
 | Task | Hand Out Clothes
Spreadsheet: 87357d1287164409-excel-2007-using-xirr-with-dynamic-ranges-test-workbook-for-xirr-no-vba
Sheet: TEST SHEET

AJAX | 2008-01-01 00:00:00 | -400
AJAX | 2008-02-03 00:00:00 | 30
AJAX | 2009-12-01 00:00:00 | 600 |  | AJAX
WIDG | 2008-02-02 00:00:00 | -500 |  | WIDG
WIDG | 2009-03-03 00:00:00 | 25
WIDG | 2009-12-01 00:00:00 | 740
Spreadsheet: 36589d1234457893-how-to-do-two-logical-tests-for-a-conditional-statement-roi-with-energy-calculator
Sheet: Mt. Morris Rm 2

 | ECOlighting Solutions |  | Telephone: [PHONE]
 | 2000 Commerce Pkwy |  | Fax: [PHONE]
 | Lancaster, NY 14086 |  | E-Mail: [EMAIL]
Base information
Customer | [NAME]
Project Name | Mt. Morris Rm 2 |  |  | [NAME]. | 021009A
Address |  |  |  | Type of Old Technology | 100 W Halogen
Contact | [NAME] |  | ` | Type of LED | LED Retro
Phone |  |  |  | Voltage | 240
Technical Information | 100 W Halogen | LED Retro
Old Technology / LED, lifetime in hours | 5000 | 120000 |  | Qty Lights / Daily usage | 91 | 17
Old Technology/ LED, lifetime in years | 0.8058017727639001 | 19.3392425463336 |  | Usage in / day's per month / day's per year | 30 | 360
Install. costs for the first installation | 100 W Halogen | LED Retro |  |  | 100 W Halogen | LED Retro
Costs each (Entire Fixture) | 15 | 625
Install Costs (Per Fixture) | 20 | 20
 |  |  | Cost for the Lights |  | 56875
Lifetime Maintenance Cost (After Installation) | 100 W Halogen | LED Retro
Lifetime changes | 23 |  |  |  | 100 W Halogen | LED Retro
Bulb Cost | 15 | 0 | Bulb Savings (Lifetime) |  | 0 | 31395
Labor Rate | 16 | 0 | [NAME] (Lifetime) |  | 0 | 33488
Service cost including; Labor, and bulb | 31 | 0 | Bulb and [NAME] (lifetime) |  | 0 | 64883
Power consumption costs | 100 W Halogen | LED Retro |  |  | 100 W Halogen | LED Retro
Bulb consumption (wattage) | 100 | 75 | Total power consumption in watts per day |  | 196469 | 116025
Ballast consumption (wattage) | 27 | 0 | Power cost per day |  | 23.57628 | 13.923
Consumption total (wattage) | 127 | 75 | Power cost per month |  | 707.2884 | 417.69
Cost's per kWh | 0.12 | 0.12 | Power cost per year |  | 8487.4608 | 5012.28
Project [NAME] (sq. ft.) | 100000 |  |  | Annual Power Savings | 3475.180800000001
 |  |  |  | Lifetime Power Savings | 67207.36438356165
Results
 |  |  |  | Results
 |  |  |  | Bulb Cost (Lifetime) |  | 31395
 |  |  |  | Lifetime Power Savings |  | 67207.36438356165
 |  |  |  | Combined Lifetime savings (bulb and power) |  | 98602.36438356165
 |  |  |  | Combined Annual savings (bulb and power) |  | 4840.180800000001
 |  |  |  | Break even after (Years) |  | 11.7505941100382
 |  |  |  | Potential Federal Incentives |  | 60000
 |  |  |  | Potential NYSERDA Incentives |  | 3475.1808
 |  |  |  | Break Even After Incentives (Years) |  | 0.8325360309591042
Energy Calculations
 |  |  |  |  | Old Technology | New Technology
 |  |  |  | Total Annual Coal Consumption (lbs.) | 57503.12195121951 | 33958.53658536586
 |  |  |  | Total Annual CO2 emissions (lbs.) | 159069.16116 | 93938.481
 |  |  |  | Total Annual SO2 emissions (lbs) | 919.4749199999999 | 542.997
 |  |  |  | Total Acres of Trees needed to fix this much CO2 (acres) | 21.69223525978454 | 12.81037515341606
 |  |  |  | Total annual energy consumption in kWh (lbs.) | 70728.84 | 41769
 |  |  |  | *Figures based on electricity coming from coal burning