tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 679129d1590211936-tracking-time-and-ot-past-midnight-w-3-columns-date-start-and-end-date_time_hours-past-midnight
Sheet: Sheet1

 | End of period | 2017-12-15 00:00:00 |  |  | 1st half-month
 |  |  |  |  | 2nd half-month
 |  |  |  |  | Totals
 |  | Date | (text only date) | Start | End | Hours | Regular | O/T
 |  |  | 12/01/2017 | 12:00 AM | 01:00 PM
 |  |  | 12/02/2017 | 04:00 PM | 10:00 PM
 |  |  | 12/03/2017 | 12:00 PM | 06:00 PM
 |  |  | 12/04/2017 | 12:00 PM | 06:00 PM
 |  |  | 12/06/2017 | 04:00 PM | 10:00 PM
 |  |  | 12/07/2017 | 06:00 AM | 09:00 AM
 |  |  | 12/08/2017 | 04:00 PM | 12:00 AM
 |  |  | 12/09/2017 | 12:00 AM | 12:00 AM
 |  |  | 12/10/2017 | 12:00 AM | 12:00 AM
 |  |  | 12/11/2017 | 12:00 AM | 09:00 AM
 |  |  | 12/13/2017 | 04:00 PM | 12:00 AM
 |  |  | 12/14/2017 | 12:00 AM | 09:00 AM
 |  |  | 12/20/2017 | 04:00 PM | 12:00 AM
 |  |  | 12/21/2017 | 12:00 AM | 12:00 AM
 |  |  | 12/22/2017 | 05:00 AM | 01:00 PM
 |  |  | 12/27/2017 | 04:00 PM | 12:00 AM
 |  |  | 12/28/2017 | 12:00 AM | 12:00 AM
 |  |  | 12/29/2017 | 06:00 AM | 02:00 PM
Spreadsheet: 772034d1646980373-return-a-month-wise-sum-values-with-ignoring-text-values-in-date-range-and-blanks-return-a-sum-values-with-ignoring-texts-in-date-range-and-blanks
Sheet: Sheet1

30.00 / Hr |  | 0.65 | 0.2 | 0.15 |  |  | Expected results
2019-12-25 00:00:00 | 30 |  |  |  |  | 2019-11-01 00:00:00
30.00 / Hr |  |  |  |  |  | 2019-12-01 00:00:00
2019-11-25 00:00:00 | 73 |  |  |  |  | 2020-01-01 00:00:00
30.00 / Hr |  |  |  |  |  | 2020-02-01 00:00:00
2020-01-25 00:00:00 | 402 |  |  |  |  | 2020-03-01 00:00:00
30.00 / Hr
2020-02-25 00:00:00 | 330
46.00 / Hr
2020-01-21 00:00:00 | 5
46.00 / Hr
2020-02-13 00:00:00 | 159
30.00 / Hr
2020-03-25 00:00:00 | 10
2020-03-25 00:00:00 | 12
2020-03-25 00:00:00 | 10
2020-02-18 00:00:00 | 159
30.00 / Hr
Spreadsheet: eef02a1e-2307-4cb3-85f0-927aae057b8d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
8519 | 63810 | [NAME] | Espinoza | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | [NAME]
8519 | 63888 | [NAME] | [NAME] | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 01:06:33
8519 | 63809 | Nestor | Urrutia | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 01:07:32
8519 | 63677 | Gilberto | Pedraza Velasquez | COL | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | [NAME]
8519 | 63887 | [NAME] | Cano | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 5 | 01:09:14
8519 | 63807 | [NAME] | Castellanos | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 6 | 01:19:01
Spreadsheet: 051b2867-8f89-45da-8216-dc570e30df3f
Sheet: Docket

JURIS | TICKET | VIOL | OCCUR | NAME | VIOLATION | FINE AMT | COST AMT | PAID AMT | BALANCE | OFFENSE DT | COMPLAINANT
DPD | 1016118 | 1201 | 0 | CASTILLO,ANTONIO | DL-NO OPERATOR'S LICENSE | 0 | 247.1 | 0 | 247.1 | 2012-05-08 00:00:00 | C VINSON
DPD | 1014834 | 2244 | 0 | HARRIS,DOMINQUE DESHUN | SPEEDING | 81 | 112.1 | 112.1 | 81 | 2012-07-25 00:00:00 | K JORDAN
Spreadsheet: 749558d1632891765-calculate-unique-values-using-multiple-criteria-test1
Sheet: Sheet1

Ticker | Quantity | Purchase Price | Cost Basis | Account | Type
AAPL | 200 | 42.5725 |  | RobinHood | Stock
AAPL | 34 | 147.28 |  | eTrade | Stock
AAPL | 100 | 6.4 |  | eTrade | Option
ABML | 1000 | 3.83 |  | eTrade | Stock
ABML | 1500 | 2.88 |  | eTrade | Stock
ABML | 1000 | 0.77 |  | eTrade | Option
ABML | 1500 | 1.57 |  | eTrade | Stock
ABML | 1000 | 1.4 |  | eTrade | Stock
ABML | 1000 | 1.31 |  | RobinHood | Stock
ABML | 1000 | 1.32 |  | eTrade | Stock
ABNB | 50 | 156.52 |  | eTrade | Stock
ABNB | 100 |  |  | eTrade | Stock
ABNB | 100 |  |  | eTrade | Stock
ABNB | 100 |  |  | eTrade | Option
Spreadsheet: 676726d1588948125-pivot-table-help
Sheet: Sheet1

 |  |  |  |  |  | I want a formua to to find all the 38 FROM the pivot table and return the whole cell text (at the moment it manual filter and paste) | I want a formua to to find THE TOTAL OF EACH CATORGY (at the moment it manual filter and paste)
DATE |  |  | pivot table
NAME | AMOUNT |  | Row Labels | Sum of AMOUNT |  | CATORGERY | AMOUNT
38 TV | 10 |  | 04 BORADBAND | 7
38 WATER | 20 |  | 04 TV | 10 |  | 38 TV | 60
38 BORADBAND | 30 |  | 04 WATER | 9 |  | 38 WATER | 30
38 TV | 50 |  | 38 BORADBAND | 30
38 WATER | 10 |  | 38 TV | 60
04 TV | 5 |  | 38 WATER | 30 |  |  | 30
04 WATER | 6 |  | Grand Total | 146 |  | 38 TV | 60
04 BORADBAND | 7 |  |  |  |  | 38 WATER | 30
04 TV | 5
04 WATER | 3 |  |  |  |  |  | 30
 |  |  |  |  |  | 38 TV | 60
 |  |  |  |  |  | 38 WATER | 30
Spreadsheet: 822118d1679110152-array-like-formula-to-create-combinations-book1
Sheet: Sheet1

Dep. Codes |  | Program Codes |  |  | Account Codes
2022 |  | 2022 |  |  | 2022
121 |  | 1206 |  |  | 5065
121 | 123 | 1206 |  |  |  |  |  |  |  |  |  |  |  |  | 123,1206
121 |  | 1206 |  |  | 5000 |  |  |  |  |  |  |  |  |  |  |  | ``
121 |  | 1206 |  |  | 5010
121 |  | 1206 |  |  | 5020
121 |  | 1206
121 |  | 1206
121 |  | 1210 |  |  | 5070
121 | 150 | 1206 |  |  | 5180 |  |  |  |  |  |  |  |  |  | 150,1206,5180
121 |  | 1206 |  |  | 5030
121 |  | 1206
121 |  | 1206
121 | 175 | 1206 | 1217 |  | 5090 |  |  |  |  |  |  |  |  |  | 121,1217,5090 | 175,1206,5090 | 175,1217,5090
121 |  | 1206 |  |  | 5110 | 5111 |  |  |  |  |  |  |  |  | 121,1206,5111
121 |  | 1206 |  |  | 5165
121 |  | 1206
121 |  | 1206 |  |  | 5130 | 5120 |  |  |  |  |  |  |  |  | 121,1206,5120
121 |  | 1206
Spreadsheet: 739853d1626011039-selecting-cells-to-sum-based-on-last-occurring-incidence-of-criteria-mock-up-scenario-for-formula
Sheet: mock up scenario

Date | Person | Status | value
2021-01-01 00:00:00 | Person 1 | start | 1
2021-01-02 00:00:00 | Person 1 | include | 2
2021-01-03 00:00:00 | Person 1 | include | 2
2021-01-04 00:00:00 | Person 1 | end | 3
2021-01-05 00:00:00 | Person 1
2021-01-02 00:00:00 | Person 2 | start | 1
2021-01-03 00:00:00 | Person 2 | include | 2
2021-01-04 00:00:00 | Person 2 | include | 2
2021-01-05 00:00:00 | Person 2 | end | 3
2021-01-03 00:00:00 | Person 2
2021-01-04 00:00:00 | Person 2
2021-01-05 00:00:00 | Person 2 | start | 1
2021-01-06 00:00:00 | Person 2 | include | 2
2021-01-07 00:00:00 | Person 2 | end | 3
2021-01-08 00:00:00 | Person 2
2021-01-09 00:00:00 | Person 2 | start | 1
2021-01-10 00:00:00 | Person 2 | end | 3
2021-01-04 00:00:00 | Person 3 | start | 1
2021-01-05 00:00:00 | Person 3 | include | 2
2021-01-06 00:00:00 | Person 3 | include | 2
2021-01-07 00:00:00 | Person 3 | include | 2
2021-01-05 00:00:00 | Person 3 | end | 3
2021-01-06 00:00:00 | Person 3 | start | 1
2021-01-07 00:00:00 | Person 3 | include | 2
2021-01-08 00:00:00 | Person 3 | include | 2
2021-01-09 00:00:00 | Person 3 | end | 3
2021-01-10 00:00:00 | Person 4 | start | 1
2021-01-11 00:00:00 | Person 4 | include | 2
2021-01-07 00:00:00 | Person 4 | include | 2
2021-01-08 00:00:00 | Person 4 | include | 2
2021-01-09 00:00:00 | Person 4 | include | 2
2021-01-10 00:00:00 | Person 4 | end | 3
2021-01-11 00:00:00 | Person 4
2021-01-12 00:00:00 | Person 4
2021-01-13 00:00:00 | Person 4 | start | 1
2021-01-14 00:00:00 | Person 4 | include | 2
2021-01-15 00:00:00 | Person 4 | end | 3
Spreadsheet: 842566d1694607983-split-3-col-dynamic-arrays-into-nested-1-column-list-split-to-list
Sheet: Feuil1

 |  |  |  |  |  |  | LIST (dynamic array) |  |  |  | EXPECTED RESULT
A | id_a1 | id_a1.4 |  |  |  |  |  | id_a1 | id_a1.4 |  | A
A | id_a1 | [NAME] |  |  |  |  | A | id_a1 | [NAME] |  | id_a1
A | id_a3 | [NAME] |  |  |  |  | A | id_a3 | [NAME] |  | [NAME]
A | id_a2 | id_a2.3 |  |  |  |  | A | id_a2 | id_a2.3 |  | id_a1.4
B | id_b1 | id_spec1 |  |  |  |  | B | id_b1 | id_spec1 |  | id_a2
B | id_b2 | id_b2.1 |  |  |  |  | B | id_b2 | id_b2.1 |  | id_a2.3
B | id_b2 | id_b2.2 |  |  |  |  | B | id_b2 | id_b2.2 |  | id_a3
B | id_b3 | id_b3.1 |  |  |  |  | B | id_b3 | id_b3.1 |  | id_a3.1
C | id_c1 | id_c1.5 |  |  |  |  | C | id_c1 | id_c1.5 |  | B
C | id_c1 | id_c1.2 |  |  |  |  | C | id_c1 | id_c1.2 |  | id_b0
C | id_c2 | id_c2.10 |  |  |  |  | C | id_c2 | id_c2.10 |  | aze
C | id_spec3 | id_c3.1 |  |  |  |  | C | id_spec3 | id_c3.1 |  | id_b1
C | id_c4 | id_c4.6 |  |  |  |  | C | id_c4 | id_c4.6 |  | id_spec1
C | id_c5 | id_c5.1 |  |  |  |  | C | id_c5 | id_c5.1 |  | id_b2
B | id_b0 | aze |  |  |  |  | B | id_b0 | aze |  | id_b2.1
 |  |  |  |  |  |  |  |  |  |  | id_b2.2
 |  |  |  |  |  |  |  |  |  |  | id_b3
 |  |  |  |  |  |  |  |  |  |  | id_b3.1
 |  |  |  |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  |  |  |  | id_c1
 |  |  |  |  |  |  |  |  |  |  | id_c1.2
 |  |  |  |  |  |  |  |  |  |  | id_c1.5
 |  |  |  |  |  |  |  |  |  |  | id_c2
 |  |  |  |  |  |  |  |  |  |  | id_c2.10
 |  |  |  |  |  |  |  |  |  |  | id_c4
 |  |  |  |  |  |  |  |  |  |  | id_c4.6
 |  |  |  |  |  |  |  |  |  |  | id_c5
 |  |  |  |  |  |  |  |  |  |  | id_c5.1
 |  |  |  |  |  |  |  |  |  |  | id_spec3
 |  |  |  |  |  |  |  |  |  |  | id_c3.1
Spreadsheet: 04d7c766-3e0b-4040-8c2d-2c1310efd8be
Sheet: Sheet1

FY 2011 AEA STATE AID PAYMENTS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | ORIGINAL | SEPT-JAN | PAID THROUGH | AMOUNT
 |  | BUDGET | PAYMENT | JANUARY | REMAINING
1 | [NAME] 1 | 13431398 | 1343141 | 6715705 | 6715693
5 | PRAIRIE LAKES AEA 8 | 13196032 | 1319603 | 6598015 | 6598017
7 | AEA 267 | 28293632 | 2829366 | 14146830 | 14146802
9 | MISSISSIPPI BEND AEA 9 | 19600648 | 1960068 | 9800340 | 9800308
10 | GRANT WOOD AEA 10 | 27263347 | 2726336 | 13631680 | 13631667
11 | HEARTLAND AEA 11 | 49241026 | 4924107 | 24620535 | 24620491
12 | NORTHWEST AEA | 16359617 | 1635961 | 8179805 | 8179812
13 | LOESS HILLS AEA 13 | 16376170 | 1637617 | 8188085 | 8188085
15 | GREAT PRAIRIE AEA 15 | 15006162 | 1500620 | 7503100 | 7503062
 |  | 198768032 | 19876819 | 99384095 | 99383937
Spreadsheet: 790897d1660054884-formula-for-totals-across-multiple-tabs-countifs-non-equal-columns2-eba
Sheet: Totals

Name | Total Games Played | Total Full Time Different to Half Time |  |  |  | Tabs
[NAME] |  |  |  |  |  | 18
[NAME] |  |  |  |  |  | 19
[NAME] |  |  |  |  |  | 20
[NAME] |  |  |  |  |  | 21
[NAME]
[NAME]
Bethany
[NAME]
[NAME]
Nicki
Spreadsheet: 06f6ea3c-54cd-46d6-8def-7052652c43b5
Sheet: Sheet1

#17240 Faxquote for 8" Tapping Valves 0510-8775 9-2-03 | Unnamed: 1 | Unnamed: 2
rev 9/2/03 ecb
 | Mtn States Pipe | Nat'l Waterworks
Responded by: | [NAME] | [NAME]
qty 6 each | 4080.36 | 4193.7
each | 680.06 | 698.95
Make | Mueller T2360-16 | Mueller T-2360-16 O/R
Leadtime | didn't specify | Immediate
Comments | Meets specs | Meets specs
Spreadsheet: 30997da0-b029-4280-8474-3eed3e4acf49
Sheet: Sheet1

Keyword | Position | Volume | Visits |  |  |  |  |  | Row Labels | Average of Position | Sum of Volume | Sum of Visits
rei | 1 | 1000000 | 200000 |  |  |  |  |  | cannondale | 3 | 90500 | 1008
rei.com | 1 | 49500 | 10 |  |  |  |  |  | hiking boots | 1 | 18100 | 1007
rei outlet | 1 | 40500 | 100 |  |  |  |  |  | kayak | 16 | 2240000 | 1006
otterbox | 11 | 246000 | 1005 |  |  |  |  |  | otterbox | 11 | 246000 | 1005
kayak | 16 | 2240000 | 1006 |  |  |  |  |  | polarized sunglasses | 1 | 12100 | 1009
hiking boots | 1 | 18100 | 1007 |  |  |  |  |  | rei | 1 | 1000000 | 200000
cannondale | 3 | 90500 | 1008 |  |  |  |  |  | rei outlet | 1.5 | 81000 | 1110
polarized sunglasses | 1 | 12100 | 1009 |  |  |  |  |  | rei.com | 1 | 49500 | 10
thule | 3 | 60500 | 101 |  |  |  |  |  | thule | 3 | 60500 | 101
rei outlet | 2 | 40500 | 1010 |  |  |  |  |  | Grand Total | 4 | 3797700 | 206256
Spreadsheet: louise_kitchen__23056__0111MarginRequirements
Sheet: Template

FUTURES MARGIN REQUIREMENTS
2001-11-21 00:00:00
2001-11-20 00:00:00
 | US $$$ |  |  |  |  |  |  |  |  |  |  |  | CANADIAN $$$
Broker | TE | Credit Facility Covering TE | TE Less CreditCoverage | Net Option Value | Initial Margin | Line of Credit Covering Initial Margin (except EDF [NAME] see calc below) | Initial Margin Less Line of Credit Covering Initial Margin |  | Daily Facility Movement Inc/(Dec) Line |  | Wire Day Cash In/(Out) |  | OTE | Initial Margin
ABN-Amro Inc |  |  |  | 0
ADM INVESTOR |  |  |  | 0
BANK ONE |  |  |  | 0
CARR FUTURES (NG) |  |  |  | 0
CARR FUTURES INC. |  |  |  | 0
CREDIT SUISSE FIRST BOSTON |  |  |  | 0
EDF MAN   (see note below)
FIMAT * |  |  |  | 0 |  |  |  | 1
HSBC - US$ |  |  |  | 0
HSBC - Canadian | 0 |  |  | 0
JP Morgan |  |  |  | 0
[NAME] |  |  |  | 0
PARIBAS |  |  |  | 0
PRUDENTIAL SI |  |  |  | 0
REFCO, INC |  |  |  | 0
R J O'BRIEN |  |  |  | 0
SAUL STONE & COMPANY |  |  |  | 0
SMITH BARNEY, INC ** |  |  |  | 0
SMITH BARNEY, INC ** (Financial) |  |  |  | 0
TOTAL EXCLUDING MID-DAY CALLS
MID-DAY CALLS: (based solely on Market Movement)
EDF Mann | 0
TOTAL INCLUDING MID-DAY CALLS
 |  | Used Line
Credit Lines: | Line | OTE | Initial Margin | Total Line Used | Total Line Unused
Smith Barney | 50000000 | 0
Fimat | 20000000
1 Includes amounts withheld from payments due Enron.  Fimat's customer agreement states that excess margin including OTE due to Enron must first be used to pay down advances on the facility.
Spreadsheet: 778155d1650895730-formulas-not-calculating-but-do-in-cell-above-broken-sample
Sheet: Sheet2

Req. ID | Task Priority | Task Priority (SD) | Task Logged Date | Attend Time | Complete Time | Target Attendance Date | Target Completion Date | Last Update | Last Update Timestamp
88241 | B - Priority, response time to be 24 hours |  |  |  |  |  |  | Test
88226 | C - Normal, work to be commenced within 7 days
Spreadsheet: 598892d1542779921-extract-sales-data-into-age-brackets-by-sales-rep-age-bracket-sample
Sheet: Sheet1

Invoice Date | Client Number | First Name | Last Name | Lead Source | Invoice Total | Payment Total | Open Balance | Photographer Name | Producer | Assistant | Booker | Make-Up Artist | [NAME] | Invoice Status | Invoice Classification | Session Type | Age | State | Units | Units2 | Units3 | <1000 | <1 | Open | Month | Week | Day | Duplicate | 10% or 150 | Selected? |  | 13 to 17 | 18 to 24 | 25 to 33 | 34 to 40 | 41 to 50 | 51 to 99
2018-11-19 00:00:00 | 20078824HAQ | Mansura | Haque | PMC_S_18 | 300 | 300 | 0 |  | [NAME] |  | [NAME] |  | Photographed | Paid (Fee) | Session Deposit  Fee |  | 18
2018-11-19 00:00:00 | 30081265KEA | Melina | Keast | In Bound Phone Call | 325 | 325 | 0 |  | Mirella |  | Mirella |  | Booked | Paid (Fee) | Booking Fee |  | 16
2018-11-19 00:00:00 | 20077911SET | [NAME] | [NAME] | PMC_S_18 | 59 | 59 | 0 |  | Lyka |  | Lyka |  | Booked | Paid (Fee) | E-Way |  | 28
2018-11-19 00:00:00 | 30081233 | [NAME] | Sao | Category Quick Enquiry | 79 | 79 | 0 |  | Natasha |  | Natasha |  | Booked | Paid (Fee) | Booking Fee |  | 36
2018-11-19 00:00:00 | 20078263LIN | Cathy | [NAME] | PMC_S_18 | 79 | 79 | 0 |  | Julie |  | Julie |  | Booked | Unpaid (Fee) | Booking Fee |  | 45
2018-11-19 00:00:00 | 20081562 | Dakota | [NAME] |  | 379 | 0 | 379 |  | Mirella |  | Mirella |  | Booked | Unpaid (Fee) | Booking Fee |  | 53
Spreadsheet: 42498d1241043670-constant-count-field-circular-reference
Sheet: Sheet1

 |  | Y= | m | X | + | b |  | N [NAME] | COUNT VALID
 |  |  | 1.59 |  |  | 23.4 |  | 7
 |  | RAW | PRED | RESIDUAL | VALID
 |  | 25
 |  | 22
 |  | 13
 |  | 42
 |  | 54
 |  | 32
 |  | 30
 |  | 20
 |  | 19
Spreadsheet: 718235d1613055653-conditional-xlookup-xlookup-formula
Sheet: Sheet1

Description | Type | [NAME] | Score
M001 old | machine | yes | 111
new M002 | machine | yes | 222
M003 newest | machine | yes | 333
Comment regarding M023 | comment
M004 | machine | yes | 255
M007 | machine | yes | 211
M023 | machine | yes | 450
M045 big | machine | yes | 21
M057 | machine | yes | 12
M062 | machine | yes | 23
M072 | machine | yes | 56
M112 | machine | yes | 87
M113 | machine | yes | 35
Spreadsheet: 783305d1654716046-hlookup-w-indirect-and-match-test3
Sheet: Sheet2

State | Year | Class | units
AK | 2015 | Unit Sales
AL | 2015 | Unit Sales
AR | 2015 | Unit Sales
AZ | 2015 | Unit Sales
CA | 2015 | Unit Sales
CO | 2015 | Unit Sales
CT | 2015 | Unit Sales
DE | 2015 | Unit Sales
DC | 2015 | Unit Sales
FL | 2015 | Unit Sales
GA | 2015 | Unit Sales
HI | 2015 | Unit Sales
IA | 2015 | Unit Sales
ID | 2015 | Unit Sales
IL | 2015 | Unit Sales
IN | 2015 | Unit Sales
KS | 2015 | Unit Sales
KY | 2015 | Unit Sales
LA | 2015 | Unit Sales
MA | 2015 | Unit Sales
MD | 2015 | Unit Sales
ME | 2015 | Unit Sales
MI | 2015 | Unit Sales
MN | 2015 | Unit Sales
MO | 2015 | Unit Sales
MS | 2015 | Unit Sales
MT | 2015 | Unit Sales
NC | 2015 | Unit Sales
ND | 2015 | Unit Sales
NE | 2015 | Unit Sales
NH | 2015 | Unit Sales
NJ | 2015 | Unit Sales
NM | 2015 | Unit Sales
NV | 2015 | Unit Sales
NY | 2015 | Unit Sales
OH | 2015 | Unit Sales
OK | 2015 | Unit Sales
OR | 2015 | Unit Sales
PA | 2015 | Unit Sales
RI | 2015 | Unit Sales
SC | 2015 | Unit Sales
SD | 2015 | Unit Sales
TN | 2015 | Unit Sales
TX | 2015 | Unit Sales
UT | 2015 | Unit Sales
VA | 2015 | Unit Sales
VT | 2015 | Unit Sales
WA | 2015 | Unit Sales
WI | 2015 | Unit Sales
WV | 2015 | Unit Sales
WY | 2015 | Unit Sales
AK | 2016 | Unit Sales
AL | 2016 | Unit Sales
AR | 2016 | Unit Sales
AZ | 2016 | Unit Sales
CA | 2016 | Unit Sales
CO | 2016 | Unit Sales
CT | 2016 | Unit Sales
DE | 2016 | Unit Sales
DC | 2016 | Unit Sales
FL | 2016 | Unit Sales
GA | 2016 | Unit Sales
HI | 2016 | Unit Sales
IA | 2016 | Unit Sales
ID | 2016 | Unit Sales
IL | 2016 | Unit Sales
IN | 2016 | Unit Sales
KS | 2016 | Unit Sales
KY | 2016 | Unit Sales
LA | 2016 | Unit Sales
MA | 2016 | Unit Sales
MD | 2016 | Unit Sales
ME | 2016 | Unit Sales
MI | 2016 | Unit Sales
MN | 2016 | Unit Sales
MO | 2016 | Unit Sales
MS | 2016 | Unit Sales
MT | 2016 | Unit Sales
NC | 2016 | Unit Sales
ND | 2016 | Unit Sales
NE | 2016 | Unit Sales
NH | 2016 | Unit Sales
NJ | 2016 | Unit Sales
NM | 2016 | Unit Sales
NV | 2016 | Unit Sales
NY | 2016 | Unit Sales
OH | 2016 | Unit Sales
OK | 2016 | Unit Sales
OR | 2016 | Unit Sales
PA | 2016 | Unit Sales
RI | 2016 | Unit Sales
SC | 2016 | Unit Sales
SD | 2016 | Unit Sales
TN | 2016 | Unit Sales
TX | 2016 | Unit Sales
UT | 2016 | Unit Sales
VA | 2016 | Unit Sales
VT | 2016 | Unit Sales
WA | 2016 | Unit Sales
WI | 2016 | Unit Sales
WV | 2016 | Unit Sales
WY | 2016 | Unit Sales
Spreadsheet: 46359d1245250460-vlookup-and-duplicate-issues-quantity-check
Sheet: Data source

 |  | Item ID | Quantity | company part number | Supplier part number
 |  | ABC003 | 3 | 126 | 3725
 |  | ABC003 | 5 | 185 | 3784
 |  | ABC003 | 3 | 169 | 3768
 |  | ABC005 | 3 | 58 | 3657
 |  | ABC005 | 3 | 130 | 3729
 |  | ABC005 | 3 | 166 | 3765
 |  | ABC008 | 3 | 137 | 3736
 |  | ABC008 | 3 | 71 | 3670
 |  | ABC008 | 3 | 57 | 3656
 |  | ABC011 | 2 | 126 | 3725
 |  | ABC014 | 2 | 148 | 3747
 |  | [NAME] | 3 | 185 | 3784
 |  | ABC021 | 4 | 133 | 3732
 |  | ABC026 | 3 | 84 | 3683
 |  | ABC026 | 3 | 101 | 3700
 |  | ABC026 | 3 | 137 | 3736
 |  | ABC028 | 3 | 179 | 3778
 |  | ABC028 | 4 | 82 | 3681
 |  | ABC028 | 3 | 106 | 3705
 |  | ABC030 | 4 | 78 | 3677
 |  | ABC032 | 2 | 67 | 3666
 |  | ABC033 | 3 | 127 | 3726
 |  | ABC035 | 3 | 63 | 3662
Spreadsheet: lisa_gang__22336__purchase summary March - May
Sheet: May Purchase Summary

ENA Positions
 |  |  |  |  |  |  |  |  | Price |  |  |  | Dollars |  |  |  | MWHs
 |  | Position to fill |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 416 | 328
Zone |  | Peak |  |  | Off-Peak |  |  |  | Peak |  | Off-Peak |  | Peak | Off-Peak | Total |  | Peak | Off-Peak
PV |  | 50 | 33.75 | TXU | 0 |  |  |  | 33.75 |  | 0 |  | 702000 | 0 | 702000 |  | 20800 | 0
 |  | 50 | 33.75 | Sempra |  |  |  |  | 33.75 |  | 0 |  | 702000 | 0 | 702000 |  | 20800 | 0
 |  | 25 | 33.75 | PNM |  |  |  |  | 33.75 |  | 0 |  | 351000 | 0 | 351000 |  | 10400 | 0
SP15 |  | 64 | 37.15 | Allegheny | 51 | 23 | Allegheny |  | 37.15 |  | 23 |  | 989081.6 | 384744 | 1373825.6 |  | 26624 | 16728
 |  | 50 | 36 | Sempra |  |  |  |  | 36 |  | 0 |  | 748800 | 0 | 748800 |  | 20800 | 0
 |  |  |  |  | 75 | 21 | Allegheny |  | 0 |  | 21 |  | 0 | 516600 | 516600 |  | 0 | 24600
NP 15 |  | 50 | 36.15 | Allegheny | 50 | 23.75 | Allegheny |  | 36.15 |  | 23.75 |  | 751920 | 389500 | 1141420 |  | 20800 | 16400
 |  | 39 | 33.5 | Allegheny | 60 | 21.5 | Allegheny |  | 33.5 |  | 21.5 |  | 543504 | 423120 | 966624 |  | 16224 | 19680
Mid - C |  |  |  |  | 51 | 15.5 | AEP |  | 0 |  | 15.5 |  | 0 | 259284 | 259284 |  | 0 | 16728
 |  | 120 | 25 | Avista | 100 | 17.5 | Avista |  | 25 |  | 17.5 |  | 1248000 | 574000 | 1822000 |  | 49920 | 32800
 |  |  |  |  | 100 | 17.75 | Avista |  | 0 |  | 17.75 |  | 0 | 582200 | 582200 |  | 0 | 32800
COB/mid spread |  | -120 | 31 | Avista | -100 | 20 | Avista |  | 31 |  | 20 |  | -1547520 | -656000 | -2203520 |  | -49920 | -32800
 |  | -5 |  |  | -100 | 20 | Avista |  | 0 |  | 20 |  | 0 | -656000 | -656000 |  | -2080 | -32800
Mead |  | 0 |  |  |  |  |  |  | 0 |  | 0 |  | 0 | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 | 0 | 0 |  | 0 | 0
Pinnacle Peak |  | 25 | 35.5 | AEP |  |  |  |  | 35.5 |  | 0 |  | 369200 | 0 | 369200 |  | 10400 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 144768 | 94136
* Hanson was purchased through EES |  |  |  |  |  |  |  |  |  |  |  |  | Purchases |  | 6675433.6
 |  |  |  |  |  |  |  |  |  |  | EPMI Summary
 |  |  |  |  |  |  |  |  |  |  | Sempra |  | 1450800 | 0 | 1450800 |  | 41600 | 0
Indicates Day 2 or 3 |  |  |  |  |  |  |  |  |  |  | Allegheny |  | 2284505.6 | 1713964 | 3998469.6 |  | 63648 | 77408
 |  |  |  |  |  |  |  |  |  |  | PNM |  | 351000 | 0 | 351000 |  | 10400 | 0
 |  |  |  |  |  |  |  |  |  |  | TXU |  | 702000 | 0 | 702000 |  | 20800 | 0
 |  |  |  |  |  |  |  |  |  |  | AEP |  | 369200 | 259284 | 628484 |  | 10400 | 16728
 |  |  |  |  |  |  |  |  |  |  | Avista |  | -299520 | -155800 | -455320 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6675433.6 |  | 146848 | 94136
Spreadsheet: 71c012bd-7f25-4f37-94ba-a476918cdb10
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
3795 | 13399 | Claudia | Hille | GER | 173 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 02:06:43
3795 | 16442 | Doerte | Siebke | GER | 174 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 02:08:52
3795 | 23642 | [NAME] | Mcgee | GBR | 171 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 02:16:32
3795 | 23151 | [NAME] | O'Donovan | GBR | 172 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | 02:21:55
3795 | 17486 | Teresa | [NAME] | ITA | 175 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNS | 00:00:00
3795 | 16768 | [NAME] | Manners | GBR | 170 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNS | 00:00:00
Spreadsheet: 61268d1262105062-nested-if-vlookup-price-by-fiber
Sheet: Scenario2

Const | Collection | Size | Color | Cost
PAPER | [NAME] | 27x45 | Berber | 5
PLASTIC | [NAME] | 27x45 | Burgundy
METAL | [NAME] | 27x45 | Chocolate
WOOD | [NAME] | 27x45 | Sage
PAPER | [NAME] | 18x30 | Berber
PLASTIC | [NAME] | 18x30 | Burgundy
METAL | [NAME] | 18x30 | Chocolate
WOOD | [NAME] | 18x30 | Sage
PAPER | [NAME] | 24x36 | Berber
PLASTIC | [NAME] | 24x36 | Burgundy
METAL | [NAME] | 24x36 | Chocolate
WOOD | [NAME] | 24x36 | Sage
PAPER | Bedford | 20x35 | Barn Red/Berber
PLASTIC | Bedford | 20x35 | Black/Berber
METAL | Bedford | 20x35 | Barn Red/Berber
WOOD | Bedford | 20x35 | Navy Berber
PAPER | Bedford | 20x35 | Sage/Berber
PLASTIC | Bedford | 28x48 | Barn Red/Berber
METAL | Bedford | 28x48 | Black/Berber
WOOD | Bedford | 28x48 | Barn Red/Berber
PAPER | Bedford | 28x48 | Navy/Berber
Spreadsheet: 0c387165-d6e6-4837-8967-f8b33f20e127
Sheet: Census

City of Carrollton
Census-2012
Active
Medical-Red Plan
 | Employee | 86
 | Employee + 1 | 60
 | Employee + 2/more | 115
Medical-White Plan
 | Employee | 156
 | Employee + 1 | 64
 | Employee + 2/more | 91
Medical-Blue Plan
 | Employee | 42
 | Employee + 1 | 16
 | Employee + 2/more | 40
Dental-High
 | Employee | 219
 | Employee + 1 | 128
 | Employee + 2/more | 218
Dental-Low
 | Employee | 57
 | Employee + 1 | 20
 | Employee + 2/more | 24
City of Carrollton
Census-2012
Retiree
Medical-Red Plan
 | Employee | 12
 | Employee + 1 | 13
 | Employee + 2/more | 2
Medical-White Plan
 | Employee | 15
 | Employee + 1 | 5
 | Employee + 2/more | 2
Medical-Blue Plan
 | Employee | 0
 | Employee + 1 | 0
 | Employee + 2/more | 1