tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 815237d1674829315-take-the-qty-out-of-stock-vehicle-parts-pricing
Sheet: #35

 |  |  | Stock Codes
Date | Veh # | [NAME] | Part # | Description | Quantity | Product Cost | Total | In [NAME]
2022-07-14 00:00:00 | #35 | 1N6AD0ER8KN720827 | 14C24 | [NAME] | 1
2022-07-14 00:00:00 | #35 | 1N6AD0ER8KN720827 | 14C18 | [NAME] | 1
2022-07-14 00:00:00 | #35 | 1N6AD0ER8KN720827 | 5486WS | Air Filter | 1
2022-07-14 00:00:00 | #35 | 1N6AD0ER8KN720827 | F4683 | Cabin Air Filter | 1
 |  |  |  |  |  |  |  | Yes
2022-07-26 00:00:00 | #35 | 1N6AD0ER8KN720827 | 14C18 | [NAME] | 1
Spreadsheet: 750074d1633212830-summing-up-the-collected-data-in-a-30-minute-interval-period-sample
Sheet: Sheet1

2021-10-02 01:35:00 | 1 |  |  |  |  | 00:00:00 | 00:29:59 | 0
2021-10-02 02:51:00 | 1 |  |  |  |  | 00:30:00 | 00:59:59 | 0
2021-10-02 07:43:00 | 1 |  |  |  |  | 01:00:00 | 01:29:59 | 0
2021-10-02 09:05:00 | 1 |  |  |  |  | 01:30:00 | 01:59:59 | 1
2021-10-02 09:17:00 | 1 |  |  |  |  | 02:00:00 | 02:29:59 | 0
2021-10-02 09:20:00 | 1 |  |  |  |  | 02:30:00 | 02:59:59 | 1
2021-10-02 09:23:00 | 1 |  |  |  |  | 03:00:00 | 03:29:59 | 0
2021-10-02 10:42:00 | 1 |  |  |  |  | 03:30:00 | 03:59:59 | 0
2021-10-02 11:16:00 | 1 |  |  |  |  | 04:00:00 | 04:29:59 | 0
2021-10-02 11:23:00 | 1 |  |  |  |  | 04:30:00 | 04:59:59 | 0
2021-10-02 11:43:00 | 1 |  |  |  |  | 05:00:00 | 05:29:59 | 0
2021-10-02 11:45:00 | 1 |  |  |  |  | 05:30:00 | 05:59:59 | 0
2021-10-02 11:53:00 | 1 |  |  |  |  | 06:00:00 | 06:29:59 | 0
2021-10-02 12:12:00 | 1 |  |  |  |  | 06:30:00 | 06:59:59 | 0
2021-10-02 13:12:00 | 1 |  |  |  |  | 07:00:00 | 07:29:59 | 0
2021-10-02 14:00:00 | 1 |  |  |  |  | 07:30:00 | 07:59:59 | 1
2021-10-02 15:04:00 | 1 |  |  |  |  | 08:00:00 | 08:29:59 | 0
2021-10-02 15:25:00 | 1 |  |  |  |  | 08:30:00 | 08:59:59 | 0
2021-10-02 15:41:00 | 1 |  |  |  |  | 09:00:00 | 09:29:59 | 4
2021-10-02 15:57:00 | 1 |  |  |  |  | 09:30:00 | 09:59:59 | 0
2021-10-02 16:01:00 | 1 |  |  |  |  | 10:00:00 | 10:29:59 | 0
2021-10-02 16:37:00 | 1 |  |  |  |  | 10:30:00 | 10:59:59 | 1
2021-10-02 16:44:00 | 1 |  |  |  |  | 11:00:00 | 11:29:59 | 2
2021-10-02 17:02:00 | 1 |  |  |  |  | 11:30:00 | 11:59:59 | 3
2021-10-02 17:27:00 | 1 |  |  |  |  | 12:00:00 | 12:29:59 | 1
2021-10-02 17:37:00 | 1 |  |  |  |  | 12:30:00 | 12:59:59 | 0
2021-10-02 19:08:00 | 1 |  |  |  |  | 13:00:00 | 13:29:59 | 1
2021-10-02 19:20:00 | 1 |  |  |  |  | 13:30:00 | 13:59:59 | 0
2021-10-02 20:11:00 | 2 |  |  |  |  | 14:00:00 | 14:29:59 | 1
2021-10-02 21:04:00 | 1 |  |  |  |  | 14:30:00 | 14:59:59 | 0
2021-10-02 21:20:00 | 1 |  |  |  |  | 15:00:00 | 15:29:59 | 2
2021-10-02 21:21:00 | 1 |  |  |  |  | 15:30:00 | 15:59:59 | 2
2021-10-02 21:44:00 | 1 |  |  |  |  | 16:00:00 | 16:29:59 | 1
2021-10-02 22:04:00 | 1 |  |  |  |  | 16:30:00 | 16:59:59 | 2
2021-10-02 22:44:00 | 1 |  |  |  |  | 17:00:00 | 17:29:59 | 2
2021-10-02 23:48:00 | 2 |  |  |  |  | 17:30:00 | 17:59:59 | 1
 |  |  |  |  |  | 18:00:00 | 18:29:59 | 0
 |  |  |  |  |  | 18:30:00 | 18:59:59 | 0
 |  |  |  |  |  | 19:00:00 | 19:29:59 | 2
 |  |  |  |  |  | 19:30:00 | 19:59:59 | 0
 |  |  |  |  |  | 20:00:00 | 20:29:59 | 2
 |  |  |  |  |  | 20:30:00 | 20:59:59 | 0
 |  |  |  |  |  | 21:00:00 | 21:29:59 | 3
 |  |  |  |  |  | 21:30:00 | 21:59:59 | 1
 |  |  |  |  |  | 22:00:00 | 22:29:59 | 1
 |  |  |  |  |  | 22:30:00 | 22:59:59 | 1
 |  |  |  |  |  | 23:00:00 | 23:29:59 | 0
 |  |  |  |  |  | 23:30:00 | 23:59:59 | 2
Spreadsheet: 60020d1260538134-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-copy-of-poss-new-budget-planner
Sheet: Unemployment Ins

Accident Sickness & Unemployment cover
MONTH | Year | Paymet
2008-01-01 00:00:00 | 2009 | 34.07
2008-02-01 00:00:00 | 2009 | 34.07
2008-03-01 00:00:00 | 2009 | 34.07
2008-04-01 00:00:00 | 2009 | 34.07
2008-05-01 00:00:00 | 2009
2008-06-01 00:00:00 | 2009
2008-07-01 00:00:00 | 2009
2008-08-01 00:00:00 | 2010
2008-09-01 00:00:00 | 2010
2008-10-01 00:00:00 | 2010
2008-11-01 00:00:00 | 2010
2008-12-01 00:00:00 | 2010
2009-01-01 00:00:00 | 2010
2009-02-01 00:00:00 | 2010
2009-03-01 00:00:00 | 2010
2009-04-01 00:00:00 | 2010
2009-05-01 00:00:00 | 2010
2009-06-01 00:00:00 | 2010
2009-07-01 00:00:00 | 2010
2009-08-01 00:00:00
2009-09-01 00:00:00
2009-10-01 00:00:00
2009-11-01 00:00:00
2009-12-01 00:00:00
2010-01-01 00:00:00
2010-02-01 00:00:00
2010-03-01 00:00:00
2010-04-01 00:00:00
2010-05-01 00:00:00
2010-06-01 00:00:00
2010-07-01 00:00:00
2010-08-01 00:00:00
2010-09-01 00:00:00
2010-10-01 00:00:00
2010-11-01 00:00:00
2010-12-01 00:00:00
Spreadsheet: 57788d1258009804-counting-consecutive-cells-that-are-greater-than-or-less-than-0-counting-consecutive-cells
Sheet: Sheet1

18.5 |  | -3.75
-10 |  | 2
 |  | -2.4
7 |  | 10
0 |  | -5.25
-0.65 |  | 20.05
-5 |  | -4.1
1 |  | -3.4
0.5 |  | 6.05
5.6 |  | 0.8
8 |  | -0.7
-5 |  | -1.4
 |  | -10
-7 |  | 14.2
 |  | -5
-5 |  | 5
-1 |  | -5
 |  | -5
 |  | -5
 |  | 3.55
 |  | -5
13 |  | -1.8
-3 |  | 9.5
 |  | -5
-5 |  | -0.6
 |  | 3.5
I want the formula in A30 to give me the number of consecutive negative numbers, but it only returns a 2 when I would like it to return a 4 for A12-A17
The formula for Column C works because there are no blank cells
Spreadsheet: 111869d1308137294-last-value-example
Sheet: Sheet1

Ref # | Sample Date | Customer # | Extra ref #
10014 |  | H2O-7226 | 7672
104965 |  | H2O-7227
 |  | H2O-7228
 |  | H2O-7229
 |  | H2O-7230
 |  | H2O-7231
 |  | H2O-7232
 |  | H2O-7233
 |  | H2O-7234
 |  | H2O-7235
 |  | H2O-7236
Spreadsheet: phillip_m_love__30151__9906_OA
Sheet: TX-CON-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM) / HPL
REGION:  TEXAS
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-South Texas
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 791574d1660471156-find-hours-between-set-hours-trip-info-master-blank-test
Sheet: Sunday

 | Drivers Used: |  |  |  |  | Mileage & Fuel |  |  |  |  | Deliveries
 | Name | Start Time | Duty Start Time | Duty Finish Time | Finish Time | Finish | Start | Daily mileage | [NAME] | Cost | Nos of Drops | Nos of deliveries | Nos of collections | Total Hours | Night Shift Hours |  | Night Start | Night End
Night Drivers |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:00:00 | 06:00:00
[NAME] | Employee 1 | 05:00:00 |  |  | 22:00:00
MV18 FTO | Employee 2 | 05:00:00 |  |  | 22:00:00
 | Employee 3 | 05:00:00 |  |  | 22:00:00
MX17 KDF | Employee 4 | 06:00:00 |  |  | 21:00:00
[NAME] | Employee 5 | 07:00:00 |  |  | 21:00:00
FN17 BSV | Employee 6 | 07:00:00 |  |  | 22:00:00
BC18 ABV | Employee 7 | 19:00:00 |  |  | 21:00:00
 | Employee 8 | 19:00:00 |  |  | 22:00:00
FN17 BRF | Employee 9 | 21:00:00 |  |  | 01:00:00
HV71 VXJ | Employee 10 | 21:00:00 |  |  | 06:00:00
FN17 BPK | Employee 11 | 21:00:00 |  |  | 07:00:00
DX66 KFC
Spreadsheet: ddee6043-9465-4c8a-830c-2bb86330c178
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40857734 | 2014-04-05 21:05:47 | ALLIES | 0 | 8 | 10 | 1256668 | Major [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 112048d1308231939-gantt-chart-with-a-twist-vehicle_booking
Sheet: Sheet5

 |  |  |  |  |  | Vehicle
Name | Department | Date | Time | Date | Time | 2 Seater | 4 Seater | 6 [NAME] | 8 Seater
[NAME] | Finance | 2011-07-01 00:00:00 | 09:00:00 | 2011-07-01 00:00:00 | 14:30:00 |  | 1
[NAME] | Accounting | 2011-07-01 00:00:00 | 07:30:00 | 2011-07-01 00:00:00 | 11:00:00 | 1
[NAME] | Relations | 2011-07-03 00:00:00 | 11:30:00 | 2011-07-03 00:00:00 | 16:00:00 |  |  | 3
Spreadsheet: 677759d1589497794-how-to-use-multiple-index-and-match-in-the-multiple-conditions-sample-1r
Sheet: PN

RESOLUTION_CODE | EDG | IVI | JAN | JAN S | REMAN | M-TURB
REPLACE - BATTERY | P15051-20 | P18438-01 | P15051-21 | P20664-03 | P14586-04 | P07168-20
REPLACE - LCD | P15230-02 |  | P21148-11 | P20475-01N | P14522-01N | P09419-04
REPLACE - MAIN PCBA | P15615-03 | P21292-03 | P20593-02N | P21168-02N | P16055-01N | P19087-02
REPLACED END ITEM | P15615-03 | P21292-03 | P20593-02N | P21168-02N | P16055-01N | P19087-02
X PORTE BATTERY |  |  |  |  | P14586-04
X PORTE ENGINE |  |  |  |  | P16055-01N
Spreadsheet: 82413d1282480245-to-find-out-the-single-part-on-all-the-sheets-book1
Sheet: CNDDRSCCR

 | Part Code | Part name
 | 12301-GB6-9000 | COVER CYLINDER HEAD |  | 12301-GB6-9000 | COVER CYLINDER HEAD
 | 12331-GB0-9100 | COVER R CYLINDER HEAD SIDE |  | 12331-GB0-9100 | COVER R CYLINDER HEAD SIDE
 | 12341-GB6-9100 | COVER L CYLINDER HEAD SIDE |  | 12341-GB6-9100 | COVER L CYLINDER HEAD SIDE
 | 12341-GB6-9100 | COVER L CYLINDER HEAD SIDE |  | 12391-GW8-6810 | GASKET CYL HEAD COVER
 | 12391-GW8-6810 | GASKET CYL HEAD COVER |  | 12394-GW8-6810 | GASKET CYLINDER HD L SIDE COVER
 | 12394-GW8-6810 | GASKET CYLINDER HD L SIDE COVER |  | 12395-GW8-6810 | GASKET CYLINDER HD R SIDE COVER
 | 12395-GW8-6810 | GASKET CYLINDER HD R SIDE COVER |  | 98056-57718-01 | SPARK PLUG
 | 98056-57718-01 | SPARK PLUG |  | 90442-GF6-0000 | WASHER SEALING 7 MM
 | 98056-57718-01 | SPARK PLUG |  | 90443-GF6-0000 | WASHER A SEALING 7 MM
 | 90442-GF6-0000 | WASHER SEALING 7 MM |  | [PHONE] | WASHER SEALING 12 MM
 | 90443-GF6-0000 | WASHER A SEALING 7 MM |  | 91302-KEV-9000 | O-RING 30.8X3
 | [PHONE] | WASHER SEALING 12 MM |  | 96001-06020-00 | BOLT FLANGE SH.6X20
 | 91302-KEV-9000 | O-RING 30.8X3 |  | 12191-KRS-C100 | GASKET CYLINDER
 | 91302-KEV-9000 | O-RING 30.8X3 |  | 14321-GB6-9000 | SPROCKET CAM
 | 96001-06020-00 | BOLT FLANGE SH.6X20 |  | [PHONE] | CHAIN CAM
 | 12191-KRS-C100 | GASKET CYLINDER |  | [PHONE] | ARM COMP.CAM CHAIN TENSIONER
 | 12191-KRS-C100 | GASKET CYLINDER |  | [PHONE] | PIVOT CAM CHAIN TENSIONER
 | 14321-GB6-9000 | SPROCKET CAM
 | [PHONE] | CHAIN CAM
 | [PHONE] | ARM COMP.CAM CHAIN TENSIONER
 | [PHONE] | ARM COMP.CAM CHAIN TENSIONER
 | [PHONE] | PIVOT CAM CHAIN TENSIONER
 | [PHONE] | PIVOT CAM CHAIN TENSIONER
Spreadsheet: 270037d1381348591-formula-help-with-multiple-tabs-sampe-workbook-for-forum
Sheet: Summary

 | Which departments to Include? |  |  | [Blank]
 |  |  |  | [Blank]
 |  |  |  | [Blank]
 |  |  |  | [Blank] |  |  |  |  |  |  |  |  |  | 1 | [Blank]
 |  |  |  | [Blank] |  |  |  |  |  |  |  |  |  | 2 | Dept 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Dept 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Dept 3
 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 |  |  |  |  |  | 5 | Dept 4
 | Revenue
Spreadsheet: 08633f8d-0106-4418-ad7c-18ac822ea252
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20
 |  |  |  |  |  |  |  |  |  |  |  | INVOICE REQUEST
 |  | issued by Aston Finance Department |  |  |  |  |  |  |  |  |  |  | Request Date |  | 2011-07-21 09:17:10.670000
 | Invoice Request Raised By |  |  |  |  |  |  |  |  |  |  | Department & School |  |  |  |  | Telephone Number
 |  |  |  |  |  |  | INVOICE TO |  |  |  |  |  |  |  |  |  | PURCHASE ORDER NUMBER
 |  |  |  |  |  |  | AGRESSO A/C
 | ADDRESS &  POSTCODE (if overseas please provide an e-mail address below for the invoice to be sent)
 |  |  |  |  |  |  | CONTACT NAME |  |  |  |  |  |  |  |  | TELEPHONE
 |  |  |  |  |  |  | E-MAIL
 | INVOICE DETAILS
 | Standard VAT Services/Goods
 | A/C Code |  |  |  |  | JOB |  |  |  |  |  | Description On Invoice |  |  |  | Amount (£) |  | [NAME] (20%) |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.2 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.2 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.2 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.2 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.2 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.2 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 0 |  | 0 |  | 0
 | VAT Exempt Services / Items
 | A/C Code |  |  |  |  | JOB Code |  |  |  |  |  | Description On Invoice |  |  |  | Amount (£) |  | [NAME] (0%) |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Invoice Total |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DO YOU WANT FINANCE TO POST THIS INVOICE OR RETURN TO YOU
 |  | SALES LEDGER CONFIRMATION
 |  | INVOICE NUMBER |  |  |  |  |  |  |  |  |  |  |  |  | RAISED ON
 |  |  |  |  |  |  |  | E-MAIL CONFIRMATION | @aston.ac.uk
Spreadsheet: jeff_dasovich__14062__PEP_OAT_KO financials and ratios
Sheet: Quaker Ratios

 |  |  | QUAKER RATIO ANALYSIS
ROE
Leverage
ROA
Asset Turn
Net Margin
Total Debt/Equity
Growth
Sales
EBIT
Net income
Spreadsheet: 544827d1509043608-how-to-populate-sheets-with-information-from-other-sheets-example-34-
Sheet: CH

description | size | barcode | Quantity
Chevrolet Corvair | LG | 1826140409099420 | 5
Chevrolet Corvair | XL | 2843577746590863 | 2
Chevrolet Corvair | SM | 5845924780294603 | 1
Chevrolet Corvette | LG | 5720351491713632 | 1
Chevrolet Corvette | SM | 5635737398861112 | 1
Chevrolet Corvette | ME | 360377972424220 | 2
Chevrolet Chevelle | LG | 521719679618382 | 3
Chevrolet Chevelle | XL | 2319934954062648 | 2
Chevrolet Chevelle | SM | 4856350626579785 | 1
Chevrolet Chevelle | ME | 3000188036709269 | 1
Chevrolet Camaro | LG | 2430385847491652 | 1
Chevrolet Camaro | XL | 3622012013109806 | 1
Chevrolet Camaro | XS | 2490328098696308 | 1
Chevrolet Camaro | SM | 1162200834452595 | 4
Chevrolet Camaro | ME | 3570822715782083 | 32
From Column C | D | E | AB
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 15b

Product1 | HY3 | IG | Other | TOTAL
Index Tranche | 714 | 1140 | 22051 | 23905
Index | 23025 | 68494 | 74925 | 166444
Asia | . | . | 1028 | 1028
Europe | . | . | 72822 | 72822
North America | 23025 | 68494 | - | 91519
Other | . | - | 1075 | 1075
OTHER* | - | - | 37689 | 37689
TOTAL | 23739 | 69634 | 134665 | 228038
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 109754d1306517066-if-statement-paycheck-calculator
Sheet: Sheet1

 | [NAME] |  | 12
 |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  | Hours Worked
 | 7am - 3pm
 | 3pm - 11pm | 8 | 8 | 8 | 8 | 8 | 8 | 4
 | 11pm - 7am
 | week total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | overtime
 |  |  |  |  |  |  |  |  |  |  |  |  | base
 |  |  |  |  |  |  |  |  |  |  |  |  | eve
 |  |  |  |  |  |  |  |  |  |  |  |  | night
 |  |  |  |  |  |  |  |  |  |  |  |  | wknd night
Spreadsheet: 289b27f3-ee27-41ed-9e56-88012f6c3301
Sheet: serials productivity stats

Serials Productivity Statistics FY11 and FY12
COLLECTION METRICS
 | FY11 | FY12 | % change
Serial volumes withdrawn | 24102 | 626
Mform pieces withdrawn | 608 | 0 | 0
Media pieces withdrawn | 0 | 1 | N/A
Serial volumes added (total) | 1620 | 1051
Subscriptions | 101 | 70
Binding | 1509 | 981
Gifts | 10 | 0
Mform pieces added (total) | 34 | 34
Film | 34 | 34
Fiche | 0 | 0 | N/A
PRODUCTIVITY METRICS
 | FY11 | FY12 | % change
[NAME] processed | 19648 | 15732
[NAME] temp bound | 74 | 0 | N/A
[NAME] mended (in-house) | 122 | 180
Claims sent | 305 | 215
Pieces checked in | 5271 | 4604
[NAME] returned from bindery (total) | 2263 | 1869
Journals and other materials | 1509 | 960
Repairs | 576 | 404
Non-Library | 178 | 505
Spreadsheet: mike_grigsby__27858__Phillip_Email_New2
Sheet: Sheet1

West Desk P&L Summary
 | Today is: |  | Today | Yesterday | MTD | YTD
 | MGMT-WEST | [NAME] |  | 724770.3231999998
 | FT-PGE |  |  | -461071.1596000103
 | WC-CAL | [NAME] |  | 1451588.977864145
 | WC-PERM | Sanchez |  | 0
 | WT-SOCAL | Holst |  | -20773.0990000017
 | WT-CAL | Ermis |  | 701672.648899979
 | Denver | Reitmeyer |  | 450206.0382500021
 | FT-REGS | Tholt |  | 210010.4236
 | WC-ROX | South |  | 246295.4878999996
 | WT-ROX | Lenhart |  | 820864.6292999999
 | WC-SJ | Gay |  | 561815.3326999618
 | WT-SJ | Kuykendahl |  | -352459.3651
 | WC-SOCAL | [NAME] |  | 80590.65089999998
 | WC-NOCAL | Wolfe |  | 30029.8923
 |  | Total: |  | 4443540.781214075
Spreadsheet: phillip_allen__29902__Mock_table
Sheet: Sheet1

Performance Review Committee
Year End 2001
1 | 2 | 3 | 4 | 5
Target:5% | Target:30% | Target:30% | Target:20% | Target:15%
Actual:100% | Actual:0% | Actual:0% | Actual:0% | Actual:0%
Ice, [NAME]
Jones, [NAME]
[NAME], [NAME]
[NAME], [NAME]
[NAME], [NAME]
Masters, [NAME]
Robins, [NAME]
Smith, Lucille
Stuart, Jeffery
Talbot, Beatrice
Underwood, [NAME]
Spreadsheet: 676791d1588969782-sumproduct-with-embedded-if-sumproduct-with-if
Sheet: Combined

 |  | SUMMARY |  |  |  |  |  |  |  |  |  | SOURCE DATA
 |  | Q1 2020 | Q1 2020 | Q1 2020 | Q1 2020 |  | Q1 2020 |  |  |  |  | Q1 2020 | Q1 2020 | Q1 2020 | Q1 2020 | Q1 2020 | Q1 2020 | Q1 2020
 |  | Begin | Transfer | Cont | Dist |  | End |  |  |  |  | Begin | Transfer | Transfer | Transfer | Cont | Dist | End
 |  | Begin | * | Cash | Cash |  | End |  |  |  |  | Begin | Balance | Item 1 | Item 3 | Cash | Cash | End
 |  |  | Net Transfer |  |  |  |  |  |  |  |  |  | TRANSFERS
 | ID | Beginning | Transfer | Cont | Dist |  | Ending | Expected | Difference |  | ID | Beginning | Balance | Item 1 | Item 3 | Cont | Dist | Ending
With embedded IF | 822 |  |  |  |  |  |  |  |  |  | 822 | 5000000 | 100000 | 0 | -5000 | 500000 | -500000
With embedded IF | 822
Only SUMPRODUCT | 822 |  |  |  |  |  |  |  |  |  | 825 | 6000000 | 0 | 157174.61 | 0 | 600000 | -400000
Expected | 822 |  |  |  |  |  |  |  |  |  | 831 | 7000000 | 314349.22 | 0 | 0 | 700000 | -300000
 |  |  |  |  |  |  |  |  |  |  | 1003 | 8000000 | 0 | 0 | 5000 | 800000 | -200000
TEST GROUP
 | 822
 | 825
 | 831
 | 1003
Spreadsheet: 474f8d07-807b-4ff5-ba5c-3572f4832c92
Sheet: Sheet1

[NAME] (Description) | Sub-Directory | Contents in Sub-Directory | Comments
org.eclipse.datatools.connectivity.git (Data Tools Platform Connectivity framework) | examples/ | org.eclipse.datatools.connectivity.repository.file/
 |  | org.eclipse.datatools.connectivity.repository.uri/
 |  | org.eclipse.datatools.connectivity.oda.jdbc.dbprofile.sample
 |  | org.eclipse.datatools.connectivity.oda.jdbc.dbprofile.sample.ui
 |  | org.eclipse.datatools.connectivity.sample
 |  | org.eclipse.datatools.connectivity.sample.cp
 |  | org.eclipse.datatools.connectivity.sample.ftp
 | plugins/ | org.eclipse.datatools.connectivity.apache.derby.dbdefinition/
 |  | org.eclipse.datatools.connectivity.apache.derby.ui/
 |  | org.eclipse.datatools.connectivity.apache.derby/
 |  | org.eclipse.datatools.connectivity.console.profile/
 |  | org.eclipse.datatools.connectivity.db.generic.ui/
 |  | org.eclipse.datatools.connectivity.db.generic/
 |  | org.eclipse.datatools.connectivity.dbdefinition.genericJDBC/
 |  | org.eclipse.datatools.connectivity.jdt/
 |  | org.eclipse.datatools.connectivity.oda.consumer/
 |  | org.eclipse.datatools.connectivity.oda.design.ui/
 |  | org.eclipse.datatools.connectivity.oda.design/
 |  | org.eclipse.datatools.connectivity.oda.flatfile.ui/
 |  | org.eclipse.datatools.connectivity.oda.flatfile/
 |  | org.eclipse.datatools.connectivity.oda.profile/
 |  | org.eclipse.datatools.connectivity.oda.template.ui/
 |  | org.eclipse.datatools.connectivity.oda/
 |  | org.eclipse.datatools.connectivity.sqm.core.ui/
 |  | org.eclipse.datatools.connectivity.sqm.core/
 |  | org.eclipse.datatools.connectivity.sqm.server.ui/
 |  | org.eclipse.datatools.connectivity.ui.dse/
 |  | org.eclipse.datatools.connectivity.ui.templates/
 |  | org.eclipse.datatools.connectivity.ui/
 |  | org.eclipse.datatools.connectivity/
 | releng/ | org.eclipse.datatools.connectivity.releng/
 | tests/ | org.eclipse.datatools.connectivity.oda.consumer.testdriver/
 |  | org.eclipse.datatools.connectivity.oda.consumer.tests/
 |  | org.eclipse.datatools.connectivity.oda.design.tests/
 |  | org.eclipse.datatools.connectivity.oda.flatfile.tests/
 |  | org.eclipse.datatools.connectivity.oda.profile.tests/
 |  | org.eclipse.datatools.connectivity.oda.tests/
 |  | org.eclipse.datatools.connectivity.test/