tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: f3768b47-63b9-4fb8-9aa0-f8de9cf2c0a9
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
DTAB | Test | DTAB | Diphtheria/Tetanus Antibody Panel, Serum | Diphtheria/Tetanus Ab Panel, S | Enzyme Immunoassay (EIA) | Serum Gel Tube: SGT |  |  | 1 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL | 0.8 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | DIPHTHERIA TOXOID IgG ANTIBODY ASSAY The minimum level of protective antibody in the normal population is between 0.01 and 0.1 IU/mL. The majority of vaccinated individuals should demonstrate protective levels of antibody >0.1 IU/mL.  TETANUS TOXOID IgG ANTIBODY ASSAY The minimum level of protective antibody in the normal population is between 0.01 and 0.15 IU/mL. The majority of vaccinated individuals should demonstrate protective levels of antibody >0.15 IU/mL. | Monday through Friday; 3 p.m. | Same day/1 day | 4 days |  | Profile |  |  |  |  | Rochester
DTAB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
DTAB | Component | DIP | [NAME] IgG Antibody Assay, Serum | [NAME] [NAME], S | Enzyme Immunoassay (EIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | The minimum level of protective antibody in the normal population is between 0.01 and 0.1 IU/mL. The majority of vaccinated individuals should demonstrate protective levels of antibody >0.1 IU/mL. | Monday through Friday; 3 p.m. | Same day/1 day | 4 days | 1 | 86648 |  |  | Yes | Yes
DIP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
DIP | Result | DIP | [NAME] [NAME], S | [NAME] [NAME], S | Numeric |  |  |  |  | IU/mL |  |  |  |  |  |  |  |  |  | 48654-8
DTAB | Component | TTIG | Tetanus Toxoid IgG Antibody Assay, Serum | Tetanus Toxoid [NAME], S | Enzyme Immunoassay (EIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | The minimum level of protective antibody in the normal population is between 0.01 and 0.15 IU/mL. The majority of vaccinated individuals should demonstrate protective levels of antibody >0.15 IU/mL. | Monday through Friday; 3 p.m. | Same day/1 day | 4 days | 1 | 86774 |  |  | Yes | Yes
TTIG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
TTIG | Result | TTIG | Tetanus Toxoid [NAME], S | Tetanus Toxoid [NAME], S | Numeric |  |  |  |  | IU/mL |  |  |  |  |  |  |  |  |  | 53935-3
Spreadsheet: 819769d1677685432-replace-multiple-keywords-excel-forum-assistance-with-formula-and-functions
Sheet: Data

WL_Summary | Column1 |  | Search for | Replace Value With
QA - Assigning enquiry to |  |  | Assigning enquiry to | Assigned
QA - Reassigning to Anna- |  |  | Reassigning | Reassigned
QA - Reassigning to Cooki |  |  | Remedy checked | QA'd
QA - Reassigning to Masal
QA - Reassigning to [NAME]
QA - Reassigning to Zaina
QA - Remedy checked & Ass
QA - Remedy checked.
QA - Remedy checked.
QA - Remedy checked.
Spreadsheet: 876266d1722952963-work-record-sheet-gerro6-work-record-sheet-aligw
Sheet: Sheet1

 |  | M | [NAME] | W | Th | F | Sa | Su | M | [NAME] | W | Th | F | Sa | Su | Total Days | Totals Needed
 | J Bloggs | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | J Smith | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 1 | 1 | 1
Spreadsheet: 863256d1710817250-pull-range-of-values-based-on-upper-and-lower-bound-in-1-or-2-cells-pull-range-of-values
Sheet: ListPull 

Low Bound | 0.9
High Bound | 1.2
List Desired from sheet1
0.9 | Prod A |  |  |  | Prod A |  |  | Prod A
0.9 | Prod B |  |  | 0.9 | Prod B |  | 0.9 | Prod B
0.9 | Prod C |  |  | 0.9 | Prod C |  | 0.9 | Prod C
1 | Prod D |  |  | 1 | Prod D |  | 1 | Prod D
1 | Prod E |  |  | 1 | Prod E |  | 1 | Prod E
1 | [NAME] |  |  | 1 | [NAME] |  | 1 | [NAME]
1.1 | [NAME] |  |  | 1.1 | [NAME] |  | 1.1 | [NAME]
1.1 | Prod H |  |  | 1.1 | Prod H |  | 1.1 | Prod H
1.2 | Prod I |  |  | 1.2 | Prod I |  | 1.2 | Prod I
1.2 | Prod J |  |  | 1.2 | Prod J |  | 1.2 | Prod J
Spreadsheet: 725310d1616612722-formula-on-worksheet-that-changes-column-if-copied-on-new-worksheet-cocktail-box-stock-sheet
Sheet: Nov Stock

 | Wet Product |  |  |  |  |  | Dry Product
 | Product | QTY initial | QTY in | QTY out | QTY holding |  | Product | QTY initial | QTY in | QTY out | QTY holding
 | [NAME] (50ml) |  |  |  |  |  | Feather
 | [NAME] (50ml) |  |  |  |  |  | Lime dehydrated
 | [NAME] (50ml) |  |  |  |  |  | Pineapple freeze dried
 | [NAME] (50ml) |  |  |  |  |  | Plum freeze dried
 | [NAME] (50ml) |  |  |  |  |  | [NAME] cake
 | Chivas Regal 12yrs (700ml) |  |  |  |  |  | Rose buds
 | Olmeca Blanco Tequila (700ml) |  |  |  |  |  | White tea (100g)
 | Campari (700ml) |  |  |  |  |  | Mini pegs
 | Cointreau (700ml) |  |  |  |  |  | Maple leaf
 | El Bandarra Rose (1000ml) |  |  |  |  |  | Grapefruit dehydrated
 | [NAME] (330ml) |  |  |  |  |  | Plastic bottle & cap
 | Miraculous foamer (118ml) |  |  |  |  |  | Blueberries freeze dried
 | Fever tree soda (200ml) |  |  |  |  |  | Raspberries freeze dried
 | Prosecco & pineapple cordial (700ml) |  |  |  |  |  | Orange dehydrated
 | [NAME] (700ml) |  |  |  |  |  | Lemon dehydrated
 | Peach & honey shrub (700ml) |  |  |  |  |  | [NAME] bottle (200ml)
 | Plum & sage cordial (700ml) |  |  |  |  |  | Garnish bag
 | Sherry & vanilla reduction (700ml) |  |  |  |  |  | Envelopes
 | Passion fruit puree (1000ml)
 | Grepefruit & vanilla falernum (700ml)
 | Chamomile & thyme cordial (700ml)
 | Maple and citrus syrup (700ml)
 | Clementine shrub (700ml)
 | Apple Juice (1000ml)
 | Fever tree lemonade (200ml)
 | El Bandarra Red (1000ml)
 | Angostura bitters (200ml)
 | Sugar (1000g)
 | Elderflower cordial (500ml)
 | Prosecco (200ml)
 | Orgeat (1000ml)
 | Maraschino liqueur (700ml)
 | [NAME] (50 per jar)
 | Chocolate bitters (200ml)
 | Lime Cordial (700ml)
Spreadsheet: 605972d1547414730-creating-a-music-database-in-excel-music-database-mock
Sheet: Choir Use 1-many

Song | Choir | [NAME] | [NAME] | [NAME] | Status Notes | General Arrangement | Choir Arrangement | Notes
[NAME] | Choir 1 | Current | Performance Nov 2018 | Ready |  | 4 verses, with actions. 1:A, 2:AS: 3AST: 4-All
[NAME] | Choir 2 | Pending |  | N/A
Akanamandla | Choir 1 | Current | Performance Nov 2018 | Ready | Needs polish | Call-response Ch/v1/ch/v2/chx2 |  | Good outdoor, interactive
[NAME] | Choir 1 | In Progress |  | Not Ready | Need to allocate parts for new members
Breaths | Choir 1 | In Progress |  | Not Ready | Need to allocate parts for new members
Buy ma Caller Herrin | Choir 1 |  |  | Some know
Carnavalito | Choir 1 | Current | Rehearsal Jan 2019 | Ready |  |  |  | Fun - audience favourite
Crossing the Bar | Choir 1 | In Progress |  | Not Ready | Needs polish | 4 x verses | Small Group | Member favourite - fairly new
Die Gedanken sind frei | Choir 1 | Current | Rehearsal Jan 2019 | Ready |  |  |  | New repertoire for many audience
Dobru Noc | Choir 1 | In Progress |  | Not Ready | Needs polish | [NAME], D&I for Solo
 |  |  |  |  |  | This column is stored and updated in Song Details
Spreadsheet: mary_fischer__25611__32E-2001
Sheet: E18YTD.XLS

ENRON CORP AND CONSOLIDTED SUBSIDIARIES
COMPANY # 032E
COMPANY NAME    Enron Building Services, Invest Co
ANALYSIS OF RESERVE ITEMS
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-18
 |  | 12-31-2000 Balance |  | ADDITIONS  DR (CR) |  |  |  | DEDUCTIONS  DR (CR)
 |  | DR. (CR) |  | RECORDED TO |  | RECORDED TO |  | RECORDED TO |  | RECORDED TO |  | DR. (CR)
[NAME] |  | BEGINNING BALANCE |  | INCOME STATEMENT |  | OTHER ACCOUNTS |  | INCOME STATEMENT |  | OTHER ACCOUNTS |  | ENDING BALANCE |  | COMMENTS/EXPLANATIONS
Allowance for Doubtful Accounts
(MUST TIE TO HYPERION LINE 0065)
Asset/Expense Accts:  DR/(CR)  Same signs as Hyperion
Reserve for Regulatory Issues - Current
(MUST TIE TO HYPERION LINE 0641)
Income Accts:  DR/(CR)  Reverse signs from Hyperion
Reserve for Regulatory Issues - Long Term
(MUST TIE TO HYPERION LINE 0815)
Income Accts: DR/(CR)  Reverse signs from Hyperion
Other Reserves - Other
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
(MUST TIE TO HYPERION LINE 0840)
Income Accts: DR/(CR)  Reverse signs from Hyperion
Hyperion Line #   and Description of Other Reserves   (not listed above)
Total Other Reserves  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-18
Spreadsheet: 778226d1650929759-shift-pattern-dropdown-list-and-auto-populate-calendar-scheduler-draft-missja-
Sheet: Data Source

Location | BLOCK B | BLOCK C | CCTV | SIMULATOR | SUPERVISOR | TAMOUTH | PATROLS | INJAZAT |  | Assignment |  |  | Simulator | Tamouth | Service Area | Block B Searches | Block B 3rd floor | Block C General M | Block C 1st floor | Supervisor | Control Room E | Control Room | Patrols | Main Gate | EOC Reception | Entrance
BLOCK B | Access Control F | Access Control F | CCTV Operator A | Access Control M | Contingency Post | Access Control M | Foot Patrol All Floors | Access Control M |  | Access Control F | Female |  | Kris | [NAME] | Christine | Anna | [NAME] | Adam | Asmaa | Scott | [NAME] | [NAME] | Troy | Mark | Naseef | Abdul
BLOCK C | 3rd Floor | Access Control M | CCTV Operator |  |  |  |  |  |  | Access Control M | Male |  | [NAME] | Jessica |  |  |  |  |  |  | [NAME] | [NAME]
CCTV |  | 1st Floor | CCTV Operator |  |  |  |  |  |  | 3rd Floor | Male |  | Sean
SIMULATOR |  |  | CCTV Operator |  |  |  |  |  |  | 1st Floor | Male
SUPERVISOR |  |  |  |  |  |  |  |  |  | CCTV Operator A | Arabic
TAMOUTH |  |  |  |  |  |  |  |  |  | CCTV Operator | Male
PATROLS |  |  |  |  |  |  |  |  |  | Contingency Post | Male
INJAZAT |  |  |  |  |  |  |  |  |  | Foot Patrol All Floors | Male
Employee Name | Badge No.
Kris | N1050
[NAME] | N1051
Sean | N1052
[NAME] | N1160
Jessica | N1161
Christine | [NAME]
[NAME] | N1053
[NAME] | N1054
Asmaa | [NAME]
Anna | N1163
Adam | N1055
Scott | N1056
[NAME] | N1057
[NAME] | [NAME]
[NAME] | N1059
Troy | N1060
Mark | N1061
Naseef | N1062
Abdul | N1063
Spreadsheet: 86848d1286812261-putting-number-of-days-in-proper-month-example-2
Sheet: Sheet1

Billing Start | Billing End | ApprovedAmt | Month #1 | Month #2 | Days Counter
2009-06-01 00:00:00 | 2009-06-30 00:00:00 | 800 | 2009-06-30 00:00:00 | 2009-06-30 00:00:00 | 29
2009-08-01 00:00:00 | 2010-08-31 00:00:00 | 15600 | 2009-08-31 00:00:00 | 2010-08-31 00:00:00 | 395
2009-12-01 00:00:00 | 2011-02-28 00:00:00 | 512 | 2009-12-31 00:00:00 | 2011-02-28 00:00:00 | 454
Spreadsheet: 0d2994d5-ed5c-4455-9bb8-86c0c5b4b87a
Sheet: Sheet1

Federal Funding Compliance: Payroll Certification
Instructions: Where employees are expected to work solely on a single Federal award or cost objective, charges for their salaries and wages will be supported by periodic certifications that the employee worked solely on that program for the period covered by the certification. The certifications will be prepared at least semi-annually and will be signed by the employee and supervisor having first-hand knowledge of the work performed by the employee (OMB Circular [NAME] for Governmental LEAs-school district or a charter authorized under a school district).
School District/Charter:
Employee Name:
Employee Title:
Fiscal Year:
I, |  |  |  |  |  | , certify that
 | (Employee Name)
100% of my work time from |  |  |  |  |  | to
 | (Beginning Date ex. Month/Date/Year)
 |  | was spent on
(Ending Date ex. Month/Date/Year)
 |  |  | duties and responsibilities.
(Federal Funding Source/Grant)
Employee Signature:
Date:
[NAME]'s Signature:
Date:
Spreadsheet: 96218d1295624976-formula-to-count-editions-of-999-and-return-a-no-copy-of-publishing
Sheet: Invoice Publishing

 |  |  |  |  |  |  | INVOICE
Art & Escape Gallery Ltd
23-25 Barnet Road
EN6 2QX
Company No. 06972834
www.artandescape.com
[NAME] |  |  |  |  |  | INVOICE DATE | 2011-01-21 15:45:38
The Only Place for Pictures |  |  |  |  |  | INVOICE NUMBER
216 Upper Street |  |  |  |  |  | CLIENT REF | CL0020
Islington |  |  |  |  |  | DELIVERED VIA
London |  |  |  |  |  | PREPAID or COLLECT | PREPAID
N1 1RL
0
REF | ARTIST | TITLE | SIZE (inches) | FRAME | UNIT COST | QTY | TOTAL
IF(ROWS($A$63:$A63)>$A$17,"",INDEX('Art sales'!C$7:C$433,MATCH(ROWS($A$63:$A63),'Art sales'!$Z$7:$Z$433,0)))
 |  |  |  |  |  | SUBTOTAL
 |  |  |  |  |  | VAT
 |  |  |  |  |  | DELIVERY
 |  |  |  |  |  | TOTAL
Please direct enquiries to: |  |  |  | Make all cheques payable to:
[NAME] |  |  |  | [NAME]
+44 (0) 7791 075 458 |  |  |  | Art & Escape Gallery Ltd
email: [EMAIL] |  |  |  | 23-25 Barnet Road
 |  |  |  | EN6 2QX
Thankyou for your business.  Please consider Art & Escape Gallery for all your Original and Published Contemporary Art.
Spreadsheet: 721284d1614624126-combine-5-lists-into-one-list-combine-5lists-into-one-big-list
Sheet: Report

No | Employee Name | Job |  |  |  | No | Employee Name | Job
2 | B | Job AA
3 | C | Job AA
4 | D | Job AA
5 | E | Job AA
6 | F | Job AA
7 | G | Job AA
8 | H | Job AA
9 | I | Job BB
10 | J | Job BB
11 | K | Job BB
12 | L | Job AA
13 | M | Job AA
14 | N | Job AA
15 | O | Job AA
16 | P | Job AA
17 | Q | Job AA
18 | R | Job AA
19 | S | Job AA
20 | T | Job BB
21 | U | Job BB
22 | V | Job AA
23 | W | Job AA
24 | X | Job AA
25 | Y | Job AA
26 | Z | Job AA
27 | AA | Job AA
28 | BB | Job AA
29 | CC | Job AA
30 | DD | Job BB
31 | EE | Job BB
32 | FF | Job BB
33 | GG | Job AA
34 | HH | Job AA
35 | II | Job AA
36 | JJ | Job AA
37 | KK | Job AA
38 | LL | Job AA
39 | MM | Job AA
40 | NN | Job AA
41 | OO | Job BB
42 | PP | Job BB
43 | OO | Job AA
44 | PP | Job AA
45 | QQ | Job AA
46 | RR | Job AA
47 | SS | Job AA
48 | TT | Job AA
49 | UU | Job AA
50 | VV | Job AA
51 | WW | Job BB
52 | XX | Job BB
53 | YY | Job BB
54 | ZZ | Job BB
55 | AAA | Job cc
56 | BBB | Job cc
57 | CCC | Job cc
58 | DDD | Job cc
59 | EEE | Job cc
60 | FFF | Job cc
61 | GGG | Job cc
62 | HHH | Job DD
63 | III | Job DD
64 | JJJ | Job DD
65 | KKK | Job DD
66 | LLL | Job DD
67 | MMM | Job DD
68 | NNN | Job DD
69 | OOO | Job DD
70 | PPP | Job DD
71 | QQQ | Job DD
72 | RRR | Job DD
Spreadsheet: 796674d1663432252-how-to-display-remaining-values-referenced-in-the-row-associated-of-the-targeted-value-test4
Sheet: Feuil1

Country | Bank | Code bank | Name agency | Other | Other 1 | Other 2 | Other 3 | Other 4 | Other 5 | Other 6 |  |  | Other 5
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba5 | azqffgds |  |  | daba11
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | [NAME] | azqffgds |  |  | daba12
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba7 | azqffgds
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba8 | azqffgds
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba9 | azqffgds
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba10 | azqffgds
blo | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba11 | azqffgds
[NAME] | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba12 | azqffgds
expected result
blo | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba11 | azqffgds
[NAME] | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba12 | azqffgds
 | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba11 | azqffgds
[NAME] | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba12 | azqffgds
Spreadsheet: b7acb80d-5506-47ae-a76a-57165e460b9b
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
HTTO | Test | HTTO | [NAME], Saliva | [NAME] (LPR), Saliva | Polymerase Chain Reaction (PCR) Followed by Sizing Analysis  (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | [NAME] DNA Self-Collection Kit (Supply T651) |  |  | 4 | mL | Multiple saliva genotype tests can be performed on a single specimen after a single extraction. See Multiple Saliva Genotype Tests in Special Instructions for a list of tests that can be ordered together.  Container/Tube: [NAME] DNA Self-Collection Kit (Supply T651)  [NAME]: Full tube  Collection Instructions: 1. Fill tube to line. 2. Send specimen in original container per kit instructions. Forms: New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday, Thursday; 8 a.m. | 1 day | 4 days | 1 | 81479 |  |  |  |  | Rochester
HTTO | [NAME] | SALIVA | Saliva |  |  |  | Ambient
HTTO | Result | 32945 | Reviewed by | Reviewed by | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
HTTO | Result | 32946 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: phillip_m_love__30156__SitheFRED
Sheet: ADetail

TAGG | Counterparty | Amount
N38268.Y | Intramonth-Sithe | 0.0185
NS9483.1 | Intramonth-Sithe | -71889.69
NS2581.1 | Intramonth-Sithe | 27900
NX8240.2 | Intramonth-Sithe | 684605.96
NS2581.1 | Intramonth-Sithe | 49599.876
NS9483.1 | Intramonth-Sithe | 26141.6146
N38268.Y | Intramonth-Sithe | -722611.46
NU2631.1 | Intramonth-Sithe | 8768.3894
NU2631.2 | Intramonth-Sithe | 3249.9375
NU2631.3 | Intramonth-Sithe | 11699.169
NQ9129.1 | Intramonth-Sithe | -59675
NQ0188.1 | Intramonth-Sithe | 71300
NQ9049.1 | Intramonth-Sithe | 64325
NQ9283.1 | Intramonth-Sithe | 59675
Spreadsheet: 476256d1471725133-excel-lookup-and-forecasting-copy-of-wcc_energy_consumption_forum
Sheet: Thermal_Load

 |  |  |  |  | Tower Range | 5 | °C
 |  |  |  |  | Peak Thermal Load Per Chiller | 809 | kW
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | intermediate calcs
 | Serial # | Month | Peak WB | Condenser_Ent_Temp | Peak Thermal Load | CH-01 | CH-02 | CH-03 | CH-04 | CH-05 | CH-06 | CH-07 | CH-08 | EL-01 | EL-02 | EL-03 | EL-04 | EL-05 | EL-06 | EL-07 | EL-08 |  | table row# | [NAME] load | % load | within table row # | [NAME])
 | 1 | Jan | 20.2 | 28 | 326.2163059907834 | 326.2163059907834 | 0 | 0 |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  | 1 | 867 | 37.62587150989427 | 7 | 346.8
 | 2 | Feb | 20.5 | 28 | 470.0994734693878 | 470.0994734693878 | 0 | 0
 | 3 | Mar | 23.2 | 30 | 530.8869677419356 | 530.8869677419356 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1) Note the use of 1 and -1 in the 3rd argument of the MATCH() function, depending on whether the lookup column is sorted in ascending or descending order.
 | 4 | Apr | 27.8 | 33.5 | 1028.970948571429 | 809 | 219.9709485714286 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2) Note the use of absolute and relative references to make copying easy
 | 5 | May | 29.5 | 34.2 | 1354.135078341013 | 809 | 545.1350783410135 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3) Key concept, note how I use the temperature lookup to locate the correct table (by row #), then use a lookup on % of load (a common column in all tables), to locate the row within the table.
 | 6 | Jun | 30.7 | 35.8 | 1710.386514285715 | 809 | 809 | 92.38651428571461 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4) I have returned one of the values. Returning the other values for the linear interpolation should be similar combinations of match and index. Once you have all four values needed for the linear interpolation, compute the desired value.
 | 7 | Jul | 32.5 | 36.5 | 1500.965817511521 | 809 | 691.9658175115208 | 0
 | 8 | Aug | 32.5 | 36.5 | 1222.218901382488 | 809 | 413.2189013824884 | 0
 | 9 | Sep | 31 | 35.8 | 1859.560834285714 | 809 | 809 | 241.5608342857142
 | 10 | Oct | 30.1 | 35 | 1287.460733640553 | 809 | 478.4607336405529 | 0
 | 11 | Nov | 27.8 | 33.5 | 841.0070971428571 | 809 | 32.00709714285711 | 0
 | 12 | Dec | 21.8 | 29.2 | 598.5401364055299 | 598.5401364055299 | 0 | 0
Spreadsheet: 139056d1328049643-solved-calculate-if-countblank-01
Sheet: Sheet1

name | category
name | 1 | taken care
name | 2
name | 3
name | 2
name | 3
name | 1 | taken care
name | 1
name | 1 |  |  |  | 8
name | 1
name | 1 | taken care
name | 3 | taken care
name | 1 | taken care
name | 1 | taken care
name | 1 | taken care
name | 1
name | 2
name | 1
name | 1
name | 2 | taken care
name | 1 | taken care
name | 1 | taken care
name | 3
name | 1
name | 1
 | total 1
 | total 2
 | total 3
Spreadsheet: 844431d1696224542-how-to-group-date-in-slicer-slicer_groupdate-aligw
Sheet: Sheet1

Received | DDD-YYYY | Status
2023-05-18 00:00:00 |  | Cancelled
2023-05-17 00:00:00 |  | Quoted
2023-05-17 00:00:00 |  | Confirm
2023-05-16 00:00:00 |  | Confirm
2023-05-22 00:00:00 |  | Cancelled
2023-05-29 00:00:00 |  | Confirm
2023-05-29 00:00:00 |  | Confirm
2023-06-06 00:00:00 |  | Cancelled
2023-06-09 00:00:00 |  | Cancelled
2023-06-09 00:00:00 |  | Cancelled
2023-06-09 00:00:00 |  | Cancelled
2023-06-14 00:00:00 |  | Quoted
2023-06-16 00:00:00 |  | Confirm
2023-06-16 00:00:00 |  | Quoted
2023-06-21 00:00:00 |  | Cancelled
2023-06-21 00:00:00 |  | Cancelled
2023-06-27 00:00:00 |  | Cancelled
2023-06-27 00:00:00 |  | Cancelled
2023-06-30 00:00:00 |  | Cancelled
2023-07-03 00:00:00 |  | Confirm
2023-07-03 00:00:00 |  | Cancelled
2023-07-04 00:00:00 |  | Cancelled
2023-07-07 00:00:00 |  | Quoted
2023-07-11 00:00:00 |  | Cancelled
2023-05-18 00:00:00 |  | Cancelled
2023-05-17 00:00:00 |  | Quoted
2023-07-22 00:00:00 |  | Cancelled
2023-07-25 00:00:00 |  | Confirm
2023-07-26 00:00:00 |  | Quoted
2023-08-02 00:00:00 |  | Cancelled
2023-08-07 00:00:00 |  | Cancelled
2023-08-10 00:00:00 |  | Confirm
2023-08-12 00:00:00 |  | Quoted
2023-08-31 00:00:00 |  | Confirm
2023-08-23 00:00:00 |  | Quoted
2023-08-23 00:00:00 |  | Quoted
2023-08-25 00:00:00 |  | Cancelled
2023-08-28 00:00:00 |  | Quoted
2023-08-30 00:00:00 |  | Quoted
2023-09-04 00:00:00 |  | Quoted
2023-09-04 00:00:00 |  | Quoted
2023-09-11 00:00:00 |  | Confirm
2023-09-12 00:00:00 |  | Confirm
2023-09-13 00:00:00 |  | Quoted
2023-09-21 00:00:00 |  | Quoted
2023-09-22 00:00:00 |  | Quoted
2023-09-26 00:00:00 |  | Quoted
2023-09-26 00:00:00 |  | Quoted