tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 780887d1652855451-can-i-combine-multiple-array-formulas-into-1-combine-dynamic-arrays
Sheet: Master

[NAME] | Cat1 | Cat2 | Cat3 | Cat4 | Cat5
Person1 | 10 | 96.57000000000001 | 0 | 0 | 0
Person2 | 13 | 18.54
Person3 | 0 | 187.13 | 32 | 0 | 0
Person4 | 10 | 61.7 |  |  | 20
Person5 | 0 |  |  |  | 30
Person6 | 10
Person7 | 0 |  | 0 | 0 | 40
Person8 | 0
Person9 | 0 | 148.13
Person10 | 0 | 58.85 | 0 | 0 | 0
Person11 | 0
Person12 | 0 | 135.8
[NAME] | 0 | 181.88 | 0 | 0 | 0
Person14 | 13 | 10.5
Person15 | 13 | 0 | 0 | 0 | 0
Person16 | 13 | 0 | 0 | 0 | 0
Person17 | 0 | 346.96 | 20.84 | 0 | 0
Person18 | 0 | 0 | 0 | 0 | 0
Person19
[NAME] | 0 | 0 | 0 | 0 | 0
Person21 | 10
Person22 | 10
Person23
Person24 | 10 | 18.13 | 0 | 0 | 0
Person25 | 0 | 142.45 | 0
Person26
Person27
Person28 | 10
Person29
Person30 | 13
Person31 | 10 | 132.47 | 32 | 0 | 0
Person32 | 13 | 132.47 | 0 | 0 | 0
Person33
Person34 | 13
Person35 | 0 | 78.65 | 0 | 0 | 0
Person36
Person37 | 0 | 197.73
Person38 | 13
Person39 | 0 | 0 | 0 | 0 | 0
Person40 | 0 | 0 | 0 | 0 | 0
Person41
Person42 | 13
Person43 | 13
Person44 | 13
Person45 | 13 | 58.37 | 0 | 0 | 0
Person46 | 13 | 208.26 | 0 | 0 | 0
Person47
Person48
Person49
Person50
Person51
Person52
Person53
Person54
Person55
Person56
Person57
Person58
Person59 | 13
Person60
Person61 | 13
Person62
Person63 | 13 | 132.47 | 0 | 0 | 0
Person64 | 13 | 0 | 0 | 0 | 0
Person65 | 13
Person66
Person67 | 0 | 0 | 0 | 0 | 0
Person68
Person69
Person70 | 13 | 101.63 | 0 | 187.22 | 0
Person71
Person72
Person73 | 0 | 0 | 0 | 0 | 0
Person74 | 13 | 0 | 0 | 0 | 0
Person75 | 13
Person76 | 13
Person77
Person78 | 13 | 185.28 | 0 | 287.91 | 0
Person79 |  |  |  | 146.79
Person80
Person81 | 13
Person82 | 13
Person83 | 13
Person84 | 13
Person85 | 13 | 93.24000000000001 | 0 | 0 | 0
Person86
Person87
Person88
Person89 | 13
Person90 | 13
Person91
Person92 | 13 | 135.8 | 0 | 415.38 | 0
Person93
Person94
Person95
Person96 | 13
Person97
Person98
Person99 | 13 | 52.69 | 0 | 0 | 0
Person100 | 13 | 257.48 | 0 | 0 | 0
Person101
Person102
Person103
Person104
Person105 | 13 | 58.37 | 0 | 0 | 0
Person106 | 13
Person107 | 13
Person108 | 13
Person109 | 10 | 78.65
Person110 | 13
Person111 | 0 | 0 | -15.5 | 0 | 0
Person112
Person113
Person114 | 13
Person115 | 13
Person116 | 13 | 70.82 | 0 | 0 | 0
Person117 | 13
Person118
Person119
Person120
Person121
Person122
Person123
Person124
Person125 | 13
Person126 | 13
Person127
Person128 | 13 | 0 | 0 | 0 | 0
Person129 | 13 | 0 | 0 | 0 | 0
Person130 | 0
Person131 | 13
Spreadsheet: daren_farmer__5072__HPLN0523
Sheet: Sheet1

HPLN0523.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - May 23, 2001
 |  |  |  |  |  | **Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-05-23 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Sandhills |  | Enron | 8 | 8
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 748735d1632319356-work-out-daily-amount-to-target-31-day-figures
Sheet: 6th

 |  |  |  | TURNOVER |  |  |  |  | REVENUE
 | AREA 3 |  |  | Target | Needed Daily | Actual | [NAME] |  | Target | Needed Daily | Actual | [NAME] |  | [NAME]'s | ATV |  | [NAME] | SALT £ |  | TMC |  | BB+ |  | Errors
 | Asda - Aintree
 | Asda - Huyton
 | Asda - Hunts Cross
 | Asda - Horwich
 | Asda - Leigh
 | Asda - Burnley
 | Asda - Westbrook
 | Asda - Widnes
 | Asda - Bromborough
 | Asda - Accrington
 | Asda - Colne
 | Asda - Clayton Green
 | Asda - Runcorn
 | Asda - Blackburn
 | Asda - Walton
 | Asda - Blackpool
 | Asda - Wigan
 | Asda - Preston
Spreadsheet: 48174d1247416685-how-to-find-a-value-in-a-sheet-and-then-return-a-value-in-another-column-and-another-excel-question-2
Sheet: Sheet1

Subcriterium 1.1 | Name criterium |  |  | Loyalty |  |  |  | Question:
 | Fixed/variable |  |  | Variable |  |  |  | Say I want to find the minimum value for a Subcriterium ("Min"), which is always 4 columns to the right and 4 rows down from the position of the relevant subcriterium.
 | Weight 1.1 |  |  | 0.5 |  |  |  | For example: how can I find the minimim ("Min") value for Subcriterium 1.1 (which should be 2)?
 | Scale for variable entry | Min | FILL >> | 2 |  |  |  | Thank you!
 |  | [NAME] | FILL >> | 25000
 |  |  |  |  | Value on 0-100 scale
 | Scale for fixed entry | n |  |  | N.A.
 |  | 4 |  | Very loyal | 87.5
 |  | 3 |  | Loyal | 62.5
 |  | 2 |  | Medium loyal | 37.5
 |  | 1 |  | Not loyal | 12.5
 |  |  |  | Subcriterium 1.2
Subcriterium 1.2 | Name criterium |  |  | Potential
 | Fixed/variable |  |  | Fixed
 | Weight 1.2 |  |  | 0.5
 | Scale for variable entry | Min
 |  | [NAME]
 |  |  |  | Subcriterium 1.2 | Value on 0-100 scale
 | Scale for fixed entry | n | FILL >> | n | N.A.
 |  | 4 | FILL >> | Fit | 87.5
 |  | 3 | FILL >> | Fit | 62.5
 |  | 2 | FILL >> | No fit | 37.5
 |  | 1 | FILL >> | No fit | 12.5
Spreadsheet: 781081d1652974262-merge-two-cells-no-duplicates-merge
Sheet: Sheet1

[NAME] | [NAME] | [NAME] | [NAME]
 |  |  | REQUIRED FOR SAMPLES
 |  |  | PICKLIST
 |  |  | ACTI + AMO + ANTH (2)', 'ACTI + AMO + CHRYS (2)', 'ACTI + AMO + CHRYS + CROC (3)', 'ACTI + AMO + CROC (3)', 'ACTI + ANTH (2)', 'ACTI + CROC (3)', 'ACTINOLITE + AMOSITE (2)', 'ACTINOLITE + CHRYSOTILE (2)', 'AMO + ANTH + CHRYS + CROC (3)', 'AMO + ANTH + CHRYS + CROC + TREM (3)', 'AMO + ANTH + CROC (3)', 'AMO + CHRYS + CROC (3)', 'AMO + CROC + TREM (3)', 'AMO + TREM + CHRYS (2)', 'AMOSITE (2)', 'AMOSITE + ANTHOPHYLLITE (2)', 'AMOSITE + CROCIDOLITE (3)', 'AMOSITE + TREMOLITE (2)', 'ANTH + CHRYS + CROC (3)', 'ANTH + CROC + TREM (3)', 'ANTH + TREM (2)', 'CHRYS + AMO + ANTH (2)', 'CHRYS + ANTH + TREM + CROC (3)', 'CHRYS + CROC + TREM (3)', 'CHRYSOTILE (1)', 'CHRYSOTILE + AMOSITE (2)', 'CHRYSOTILE + ANTHOPHYLLITE (2)', 'CHRYSOTILE + CROCIDOLITE (3)', 'CROC + AMO + TREM + CHRYS (3)', 'CROCIDOLITE (3)', 'CROCIDOLITE + ANTHOPHYLLITE (3)', 'CROCIDOLITE + TREMOLITE (3)', 'FIBROUS ACTINOLITE (2)', 'FIBROUS ANTHOPHYLLITE (2)', '[NAME] (2)', 'FINE FIBRES PRESENT BUT TOO THIN TO IDENTIFY (1)', 'NO ASBESTOS DETECTED (0)', 'TREMOLITE + CHRYSOTILE (2)', 'UNABLE TO ANALYSE (3)'
No Asbestos Detected | No Asbestos Detected
No Asbestos Detected | No Asbestos Detected
No Asbestos Detected | No Asbestos Detected
No Asbestos Detected | No Asbestos Detected
No Asbestos Detected
No Asbestos Detected
No Asbestos Detected
No Asbestos Detected
Spreadsheet: 106725d1303927598-transposing-chart-omitting-zeros-tab1
Sheet: tab1

No. | Location | Part 1 | Part 2 | Part 3 | Part 4 | Part 5 | Part 6 | Part 7 | Part 8 | Part 9 | Part 10 | Part 11 | Part 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | US | 0 | 106.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 51.36 | 0 | 0
2 | Europe | 0 | 106.7 | 0 | 0 | 309.99 | 0 | 270 | 0 | 0 | 0 | 390 | 0
3 | Africa | 0 | 53.35 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25.68 | 0 | 0
4 | Africa | 0 | 53.35 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25.68 | 0 | 0
5 | South America | 0 | 53.35 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25.68 | 0 | 0
6 | Europe | 0 | 53.35 | 0 | 0 | 0 | 0 | 270 | 0 | 0 | 0 | 130 | 0
7 | Europe | 0 | 53.35 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25.68 | 0 | 0
8 | Australia | 0 | 53.35 | 0 | 0 | 309.99 | 0 | 0 | 0 | 0 | 0 | 130 | 0
9 | South America | 0 | 53.35 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 51.36 | 0 | 0
10 | Europe | 53.94 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25.68 | 0 | 0
11 | Africa | 0 | 53.35 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25.68 | 0 | 0
How can i do automatically such chart below?
1 | US | Part 2 | 106.7
1 | US | Part 10 | 51.36
2 | Europe | Part 2 | 106.7
2 | Europe | Part 5 | 310
 |  |  | …
Spreadsheet: d77c786d-eb28-4f32-a197-67b9bec1b1b1
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
CAHBS | Test | CAHBS | Congenital Adrenal Hyperplasia (CAH) [NAME], Blood Spot | CAH [NAME], BS | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Blood spots from local newborn screening card: BSC |  |  | 2 | Blood spots | Container/Tube: Local newborn screening card [NAME]: 2 blood spots Collection Instructions:  1. Do not use device or capillary tube containing EDTA to collect specimen. 2. At least 1 spot should be complete, unpunched.  3. Do not expose specimen to heat or direct sunlight. 4. Do not stack wet specimens. 5. Keep specimen dry. 6. If collection of a new specimen is necessary, let blood dry on the Supplemental Newborn Screening Card (Supply T493) at ambient temperature in a horizontal position for 3 hours. Forms: If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | Blood Spot: 1 | Hemolysis	NA Thawing	No Lipemia	NA Icterus	NA Other	NA | 17-HYDROXYPROGESTERONE Males: <7.1 ng/mL Females: <4.1 ng/Ml  ANDROSTENEDIONE <3.1 ng/mL  CORTISOL >2.5 ng/Ml  11-DEOXYCORTISOL <10.1 ng/mL  21-DEOXYCORTISOL <1.7 ng/Ml  (17 OHP + ANDROSTENEDIONE)/ CORTISOL RATIO <2.51 Note: [NAME] (17 OHP + Androstenedione)/Cortisol Ratio: >2.5 is only applicable when 17-OHP is elevated  11-DEOXYCORTISOL/CORTISOL RATIO <1.1 | Monday through Friday; 8:00 AM, Friday and Saturday; 4:00 PM | 1 day | 3 days | 1 | 83788 |  |  |  |  | Rochester
CAHBS | [NAME] | BLOOD | Whole blood |  |  |  | Ambient
CAHBS | Result | 50545 | 17-OH Progesterone | 17-OH Progesterone | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 38473-5
CAHBS | Result | 50546 | Androstenedione | Androstenedione | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 53343-0
CAHBS | Result | 50547 | Cortisol | Cortisol | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 53345-5
CAHBS | Result | 50548 | 11-deoxycortisol | 11-deoxycortisol | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 53338-0
CAHBS | Result | 50549 | 21-deoxycortisol | 21-deoxycortisol | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 53341-4
CAHBS | Result | 50550 | (17OHP+Androstenedione)/Cortisol | (17OHP+Androstenedione)/Cortisol | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
CAHBS | Result | 50551 | 11-deoxycortisol/Cortisol | 11-deoxycortisol/Cortisol | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45184-9
CAHBS | Result | 24053 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
CAHBS | Result | 24055 | Reviewed By | Reviewed By | Numeric
Spreadsheet: 775745d1649283631-creating-an-automated-cash-flow-example-cost-schedule-bvj-
Sheet: Sheet2

Activity | =Sheet1!$A$4:$A$21
Cost | =Sheet1!$B$4:$B$21
[NAME] | =Sheet1!$C$24
TriggerList | =Sheet1!$C$4:$C$21
c25 | =INDEX(Cost,MATCH($A25&Trigger,Activity&TriggerList,0))
D25 | =IFERROR(INDEX(Cost,MATCH($A25,Activity,0))*INDEX($G$2:$J$3,MATCH($A25,$F$2:$F$3,0),MATCH(D$24,$G$1:$J$1,0)),0)
 | =IFERROR(INDEX(Cost,MATCH($A25,Activity,0))*INDEX($G$2:$J$3,MATCH($A25,$F$2:$F$3,0),MATCH(E$24,$G$1:$J$1,0)),0)
 | =IFERROR(INDEX(Cost,[NAME])
 | =IFERROR(INDEX(Cost,MATCH($A25,Activity,0))*INDEX($G$2:$J$3,MATCH($A25,$F$2:$F$3,0),MATCH(G$24,$G$1:$J$1,0)),0)
 | =IFERROR(INDEX(Cost,MATCH($A25,Activity,0))*INDEX($G$2:$J$3,MATCH($A25,$F$2:$F$3,0),MATCH(H$24,$G$1:$J$1,0)),0)
 | =INDEX(Cost,MATCH(A25,Activity,0))
 | =IFERROR(INDEX(Cost,[NAME])
 | =IFERROR(INDEX(Cost,MATCH($A25,Activity,0))*INDEX($G$2:$J$3,MATCH($A25,$F$2:$F$3,0),MATCH(K$24,$G$1:$J$1,0)),0)
 | =IFERROR(INDEX(Cost,[NAME])
 | =IFERROR(INDEX(Cost,MATCH($A25,Activity,0))*INDEX($G$2:$J$3,MATCH($A25,$F$2:$F$3,0),MATCH(M$24,$G$1:$J$1,0)),0)
 | =IFERROR(INDEX(Cost,MATCH($A25,Activity,0))*INDEX($G$2:$J$3,MATCH($A25,$F$2:$F$3,0),MATCH(N$24,$G$1:$J$1,0)),0)
Spreadsheet: 776163d1649538385-if-cell-a3-equals-any-value-of-another-sheet-column-retrieve-value-of-corresponding-row-testa
Sheet: CLIENTS

CID | DENOMINATION | PHONE | VAT | FIRST NAME | LAST NAME | ADDRESS | POST | CITY | COUNTRY | [NAME] | WEBSITE | STATUS | LAST BILLED
9 | [NAME]
8
7
6
5
4
3
2
1
Spreadsheet: 105273d1302692150-extract-lookup-value-from-many-duplicates-pain
Sheet: Sheet1

 |  |  |  | PICK A CUSTOMER |  | PRODUCT |  |  | Filter criteria>> | CUSTOMER | 2 | <<Drop down link
CUSTOMER | PRODUCT |  |  | customer 2 |  | B |  |  |  | customer 2
customer 1 | A |  |  |  |  | J
customer 2 | B |  |  |  |  | G
customer 3 | C |  |  |  |  | I
customer 4 | D
customer 5 | E
customer 6 | F
customer 2 | J
customer 2 | G
customer 4 | H
customer 2 | I
customer 5 | J
customer 6 | K
customer 4 | L
customer 5 | M
customer 6 | N
customer 7 | O
customer 5 | P
customer 4 | R
drop down data
customer 1
customer 2
customer 3
customer 4
customer 5
customer 6
customer 7
Spreadsheet: 050e1df9-ab24-4c95-9980-7e0102936046
Sheet: SF-6 Form per Capita

 |  |  |  |  |  |  |  |  |  |  | Quality School Choice and Funding
 |  |  |  |  |  |  |  |  |  |  | Finance Program Services
 |  |  |  |  |  |  |  |  |  |  | SF-6
 |  |  |  |  |  |  |  |  |  |  | School Age Form
 |  |  |  |  |  |  |  |  |  |  | for Per Capita Calculation
 |  |  |  |  |  |  |  |  |  |  | Report To Certify the Excess Cost For School District School-Age Pupils
 |  |  |  |  |  |  |  |  |  |  | Who Were Provided Special Education and Related Services
 |  |  |  |  |  |  |  |  |  |  | To be filed by educating district (3323.14 [NAME]) for school year 2011-12
 |  | [NAME]
 |  |  |  | Educating District - City, Exempted Village or Local
 |  |  |  |  | Please select a district.
 |  | Section II. Salaries, Benefits, and General Student Costs (General Fund) |  |  |  |  |  |  |  |  |  |  | Actual Costs | Students with disabilities (excluding speech 05) counted in EFM ADM | Cost per FTE (Column N/ Column O)
 |  |  | 1. | Special Education Salaries and Benefits
 |  |  | A. | Special Education teacher salaries and benefits by district (Functions 1220, 1230 and 1240 and objects 11x, 12x, 131, 21x, 24x, 261))
 |  |  | 2. | Instructional Salaries and Benefits by districts |  |  |  |  |  |  |  |  | Reported Costs | EFM ADM | Cost per FTE (Column N/ Column O)
 |  |  |  | Teacher salaries and benefits by district (functions 11xx, objects 11x, 12x, 131, 21x, 24x, 261))
 |  | Section III.  General Student Costs (General Fund) |  |  |  |  |  |  |  |  |  |  | Reported Costs | EFM ADM | Cost per FTE (Column N/ Column O)
 |  |  | 3. Instructional Supplies and Materials By District
 |  |  | Instructional Supplies and Materials (Func 1XXX - Obj 5XX)
 |  |  | 4. Instructional Equipment
 |  |  | Instructional Equipment (Func 1XXX - Obj 6XX, [NAME])
 |  |  | 5. Administration Costs - By District from EFM Report
 |  |  | 6. Operations Support Costs - By District from EFM Report
 |  |  | 7. Staff Support Costs - By District from EFM Report
 |  |  | 8. Pupil Support Costs - By District from EFM Report
 |  | [NAME]
 |  |  | 9. | Total Cost per FTE
 |  |  | City, Exempted Village or Local Superintendent Signature |  |  |  |  |  |  |  |  | Treasurer Signature
Spreadsheet: daren_farmer__5988__hpl0617
Sheet: Sheet1

HPLN0617.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  NOMINATIONS - Effective June 17, 2000
 |  |  |  |  |  | ** Sat / Sun | ** Monday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 6/17-18/2000 | 2000-06-19 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs. | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream | NOM | VOLUME | VOLUME
Enron (FM) |  | LS HPL [NAME] |  | HPL | 25 | 0 | 0
Enron (FM) |  | HPL - Katy (DBND) |  | HPL | 5 | 0 | 0
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | TOG 3 |  | Empire | 1.4 | 1.4 | 1.4
Empire (Enron) |  | [NAME]. |  | Empire | 8 | 8 | 8
Empire (Enron) |  | SANDHILLS |  | Empire | 0.65 | 0.65 | 0.65
Empire (Enron) |  | Oasis Turbine |  | Empire | 7.95 | 7.95 | 7.95
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: louise_kitchen__23935__AugYTD Orig w notes
Sheet: Southeast Power

Southeast Power
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
Kroll |  | Power |  | Southeast Orig
Pagan |  | Power |  | Southeast Orig |  | 313600
Rorschach |  | Power |  | Southeast Orig |  | 234600
Braddock |  | Power |  | Southeast Orig
Schultz |  | Power |  | Southeast Orig |  | 50000
Acevedo |  | Power |  | Southeast Orig
[NAME] |  | Power |  | Southeast Orig |  | -54615
Total
Spreadsheet: 880892d1728725909-v-lookup-looks-for-a-specific-order-number-and-groups-cell-content-into-one-cell-formula-example
Sheet: Schedule

PO | SKU - need formula | Composite | Date Due in | Left Factory
1111 |  | Plastic | 2024-10-11 00:00:00 | Yes
1111 |  | Metals | 2024-10-12 00:00:00 | No
2222 |  | Iron | 2024-10-13 00:00:00 | Yes
3333 |  | Plastic | 2024-10-14 00:00:00 | No
4444 |  | Metals | 2024-10-15 00:00:00 | Yes
1111 |  | Iron | 2024-10-16 00:00:00 | No
1111 |  | Plastic | 2024-10-17 00:00:00 | Yes
Spreadsheet: 90286d1290035027-conditional-formating-with-multiple-criteria-cf-from-list
Sheet: Sheet1

[NAME] | [NAME] | [NAME] to [NAME] |  | names to check | either [NAME] or [NAME] is in column A,
Elvis | [NAME] | Elvis to [NAME] |  | [NAME] | or [NAME] or [NAME] is in column B, the cell would be shaded.
[NAME] | [NAME] | [NAME] to [NAME] |  | Elvis | add a name to list in e
[NAME] | [NAME] | [NAME] to [NAME] |  | [NAME]
[NAME] | [NAME] | [NAME] to [NAME] | no blanks in this list >>>>>>>> | susan
[NAME] | [NAME] | [NAME] to [NAME] |  | martin
Elvis | [NAME] | Elvis to [NAME] |  | [NAME]
martin | [NAME] | martin to [NAME] |  |  | named range called  "names"    and its associated formula is
pete | sid | pete to sid
[NAME] | martin | [NAME] to martin |  |  | this allows names to be entered at bottom of list in column E
ron | reg | [NAME] |  |  | and the range will extend automatically
[NAME] | [NAME] | [NAME] [NAME] |  |  | to insert a name use name manager in excel 2007
mark | [NAME] | mark to owen |  |  | [NAME]
 |  | to
 |  | to |  |  | no blanks allowed between names or everything will go green
 |  | to
 |  | to |  |  | conditional format is use a formula option   in c1  copied down
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
 |  | to
Spreadsheet: 211128d1359660839-updating-dates-format-copy-of-weekly-ar-report
Sheet: How it actually works

AR UPDATES DUE EVERY TUESDAY BY 11:00 AM
Today's Date:
Acme |  | PM: | [NAME]
INVOICE # | DATE ISSUED | DAYS OPEN | $ AMOUNT OPEN | COMMENTS: INCLUDE CONTACT, DATE CONTACTED,  INVOICE RECEIVED, REVIEWED AND DATE  REMITTANCE IS EXPECTED. VERIFY CHECK # IF IN THE MAIL
11-0251 | 2011-10-05 00:00:00 |  | 152.5
11-0428 | 2012-04-27 00:00:00 |  | 3670.81
12-0102 | 2012-10-30 00:00:00 |  | 52692.25
12-0114 | 2012-11-30 00:00:00 |  | 1616.03
12-0116 | 2012-11-30 00:00:00 |  | 21538.93
12-0117 | 2012-11-30 00:00:00 |  | 5468.06
12-0127 | 2012-12-18 00:00:00 |  | 5176.66
12-0130 | 2012-12-31 00:00:00 |  | 32349.24
13-00008 | 2013-01-31 00:00:00 |  | 6187.14
Spreadsheet: 850570d1700929707-sumifs-not-pulling-second-criteria-sample-1
Sheet:  activity by month

Medic | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00
Dicaprio
[NAME]
[NAME]
Styron
Papalski
Witte
Jones
Kautz
Spreadsheet: 695380d1600182988-calculating-date-from-years-months-and-days-hire-date-sample
Sheet: Sheet1

Date Pulled Information | Length of Service | Hire Date
2020-09-02 00:00:00 | 19 Years 8 Months 24 days
2020-09-02 00:00:00 | 7 Years 8 Months 27 days
2020-09-02 00:00:00 | 2 Years 11 Months 13 days
2020-09-02 00:00:00 | 21 Years 4 Months 15 days
2020-09-02 00:00:00 | 24 Years 8 Months 17 days
2020-09-02 00:00:00 | 5 Years 10 Months 1 days
2020-09-02 00:00:00 | 15 Years 7 Months 11 days
2020-09-02 00:00:00 | 4 Years 6 Months 6 days
2020-09-02 00:00:00 | 9 Years 11 Months 15 days
2020-09-02 00:00:00 | 0 Years 9 Months 4 days
2020-09-02 00:00:00 | 0 Years 6 Months 4 days
Spreadsheet: c9d998f1-4c24-43d5-9533-30899447a497
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
LAD1 | Test | LAD1 | Leukocyte Adhesion Deficiency Type 1, [NAME]/CD18 and CD11b/CD18 [NAME], Blood | [NAME]. Type 1, B | Flow Cytometric Immunophenotyping Includes evaluation of markers [NAME]/CD18 and CD11b/CD18. | EDTA (lavender-top) tube: EDTA |  |  | 5 | mL | [NAME] should arrive within 24 hours of draw. Send specimen Monday through Thursday only. The specimen will be rejected if >72 hours old. A specimen 48 to 72 hours old will be processed and reported with a disclaimer if expression is absent.    Container/Tube: Lavender top (EDTA) [NAME]: 5 mL Collection Instructions: Send specimen in original tube. Additional Information: 1. Date and time of draw and physician name and phone number are required. 2. For serial monitoring, we recommend that specimen draws be performed at the same time of day. | 2 mL | Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	Mild OK; Gross reject Icterus	NA Other	Specimen >72 hours | Normal (reported as normal or absent expression for each marker) | Monday through Friday Do not send specimen after Thursday. Specimen must be rece | 3 days | 4 days |  | Profile |  |  |  |  | Rochester
LAD1 | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient | 72 hours
LAD1 | Result | 81155 | [NAME], B | [NAME], B | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
LAD1 | Result | 430 | CD11a | CD11a | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
LAD1 | Result | 388 | CD11b | CD11b | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
LAD1 | Result | 431 | CD18 | CD18 | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
LAD1 | Result | 432 | LAD Interpretation | LAD Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
LAD1 | Billing Component | LAD1 |  | Flow Cytometry, each cell |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88184
LAD1 | Billing Component | LAD1 |  | each additional marker |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 88185
Spreadsheet: 716186d1612093665-rent-spreadsheet-formulas-functions-assistance-please-rent-spread-sheet-help
Sheet: Payments

Property | Date | Amount
1 | 2020-01-01 00:00:00 | 100
2 | 2020-01-02 00:00:00 | 200
3 | 2020-01-03 00:00:00 | 300
4 | 2020-01-04 00:00:00 | 400
3 | 2020-01-08 00:00:00 | 300
2 | 2020-01-09 00:00:00 | 200
1 | 2020-01-10 00:00:00 | 100
4 | 2020-01-11 00:00:00 | 400
3 | 2020-01-15 00:00:00 | 300
2 | 2020-01-16 00:00:00 | 200
4 | 2020-01-17 00:00:00 | 250
1 | 2020-01-18 00:00:00 | 100