tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 807707d1670003632-calculate-easy-when-i-add-a-form-mileage-in-parish
Sheet: Sheet1

Column1 | CPSB | MC/SP | FLE | FUE | FJH | FHS | CEC | CPA | VHS | VJH | VUE | VLE | MHS | HS C | HS V
CPSB | 0 | 2.5 | 7.5 | 7 | 7 | 7.5 | 7.5 | 5 | 1 | 3.5 | 3 | 3 | 26 | 13 | 0.5
MC/SP | 2.5 | 0 | 10 | 9 | 9 | 9.5 | 9.5 | 7.5 | 2 | 0.5 | 0.5 | 0.5 | 25 | 16 | 2.5
FLE | 7.5 | 10 | 0 | 2.5 | 2.5 | 1.5 | 3 | 4 | 8 | 10.5 | 10.5 | 10.5 | 21 | 6.5 | 8
FUE | 6.5 | 9 | 2.5 | 0 | 0 | 2.5 | 0.5 | 3 | 7.5 | 10 | 9.5 | 9.5 | 20 | 8 | 7
FJH | 6.5 | 9 | 2.5 | 0 | 0 | 2.5 | 0.5 | 3 | 7.5 | 10 | 9.5 | 9.5 | 20 | 8 | 7
FHS | 7 | 9.5 | 1.5 | 2.5 | 2.5 | 0 | 2 | 4.5 | 8 | 10.5 | 10 | 10 | 20.5 | 6.5 | 7.5
CEC | 7 | 9.5 | 3 | 0.5 | 0.5 | 2 | 0 | 4 | 8 | 10.5 | 10 | 10 | 20 | 8.5 | 7.5
CPA | 5 | 7.5 | 4 | 3 | 3 | 4.5 | 4 | 0 | 6 | 8.5 | 8 | 8 | 23 | 10 | 5
VHS | 1 | 2 | 8 | 7.5 | 7.5 | 8 | 8 | 6 |  | 2.5 | 2 | 2 | 26.5 | 14.5 | 1
VJH | 3.5 | 0.5 | 10.5 | 10 | 10 | 10.5 | 10.5 | 8.5 | 2.5 | 0 | 1 | 1 | 24.5 | 17 | 3
VUE | 3 | 0.5 | 10.5 | 9.5 | 9.5 | 10 | 10 | 8 | 2 | 1 | 0 | 0.5 | 25 | 16.5 | 3
VLE | 3 | 0.5 | 10.5 | 9.5 | 9.5 | 10 | 10 | 8 | 2 | 1 | 0.5 | 0 | 25.5 | 16.5 | 3
MHS | 26 | 25 | 21 | 20 | 20 | 20.5 | 20 | 23 | 26.5 | 24.5 | 25 | 25.5 |  | 26 | 25.5
HS C | 13 | 16 | 6.5 | 8 | 8 | 6.5 | 8.5 | 10 | 14.5 | 17 | 16.5 | 16.5 | 26 | 0 | 13
HS V | 0.5 | 2.5 | 8 | 7 | 7 | 7.5 | 7.5 | 5 | 1 | 3 | 3 | 3 | 25.5 | 13 | 0
Spreadsheet: 544616d1508961327-help-with-autopopulating-worksheets-with-data-from-a-main-sheet-in-same-workbook-fpm-scheduler-calendar-test
Sheet: FPMs

Ref | Client Forenames | Client Surname | Month | Details | Date | Time | Adv 1 | Adv 2
 | [NAME] | Smith | January | GLA | 2018-01-01 00:00:00 | 1.00 pm | LJ | DT |  |  | 2018
 | [NAME] | Jones | January | City | 2018-01-01 00:00:00 | 3.00 pm | KW | GH |  |  | 2019
 | [NAME] | [NAME] | March | City | 2018-03-01 00:00:00 | 12.15 pm | LJ |  |  |  | 2020
 | [NAME] | Stevenson | December | City | 2018-12-01 00:00:00 | 9.00 am | KW | GH |  |  | 2021
 | [NAME] | [NAME] | February | City | 2018-02-01 00:00:00 | 10.30 am | DT |  |  |  | 2022
 |  |  |  |  |  |  |  |  |  |  | 2023
 |  |  |  |  |  |  |  |  |  |  | 2024
 |  |  |  |  |  |  |  |  |  |  | 2025
 |  |  |  |  |  |  |  |  |  |  | 2026
 |  |  |  |  |  |  |  |  |  |  | 2027
 |  |  |  |  |  |  |  |  |  |  | 2028
 |  |  |  |  |  |  |  |  |  |  | 2029
 |  |  |  |  |  |  |  |  |  |  | 2030
 |  |  |  |  |  |  |  |  |  |  | 2031
 |  |  |  |  |  |  |  |  |  |  | 2032
 |  |  |  |  |  |  |  |  |  |  | 2033
 |  |  |  |  |  |  |  |  |  |  | 2034
 |  |  |  |  |  |  |  |  |  |  | 2035
 |  |  |  |  |  |  |  |  |  |  | 2036
 |  |  |  |  |  |  |  |  |  |  | 2037
 |  |  |  |  |  |  |  |  |  |  | 2038
 |  |  |  |  |  |  |  |  |  |  | 2039
 |  |  |  |  |  |  |  |  |  |  | 2040
 |  |  |  |  |  |  |  |  |  |  | 2041
 |  |  |  |  |  |  |  |  |  |  | 2042
 |  |  |  |  |  |  |  |  |  |  | 2043
 |  |  |  |  |  |  |  |  |  |  | 2044
 |  |  |  |  |  |  |  |  |  |  | 2045
Spreadsheet: 41282d1239784240-working-with-lookups-lookup-macro
Sheet: Bank Statement day 1

Day 1
Date | Ref |  | Amount  Received
2009-04-14 00:00:00 | TW000927 |  | 371
2009-04-14 00:00:00 | N0000031 |  | 82.48
2009-04-14 00:00:00 | JS000014 |  | 71.74
2009-04-14 00:00:00 | PW00005 |  | 46.64
2009-04-14 00:00:00 | Y1111119 |  | 31.05
2009-04-14 00:00:00 | Y1111118 |  | 29.02
Spreadsheet: 107871d1305021139-value-error-when-no-data-available-sample
Sheet: Sheet1

AAA | 2011-01-07 19:10:00 | 2011-01-07 19:15:00 | 2011-01-07 23:47:00 | 4:20:00
BBB
AAA | 2011-01-09 14:15:00 | 2011-01-09 14:15:00 | 2011-01-09 18:20:00 | 4:20:00
Spreadsheet: f13e4aa0-fceb-4ad4-900c-25ab30c79e15
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
MATTEL, INC. AND SUBSIDIARIES
RECONCILIATION OF GAAP TO NON-GAAP FINANCIAL MEASURE
 |  |  |  |  | Three Months Ended March 31,
(In millions, except percentage information) |  |  |  |  |  | 2009 |  |  | 2008
Gross Sales |  |  |  |  | $ | 857.13 |  | $ | 1006.7
[NAME] |  |  |  |  |  | -71.53000000000009 |  |  | -87.4
Net Sales |  |  |  |  | $ | 785.6 |  | $ | 919.3
% Change |  |  |  |  |  | -0.1454367453497225 |  |  | -0.02
Pos./(Neg.) Impact of Currency (in % pts) |  |  |  |  |  | -7 |  |  | 5
The financial information included herein should be read in conjunction with Mattel's consolidated financial
statements and related notes in its Annual Reports on Form 10-K and/or Quarterly Reports on Form 10-Q, as applicable.
Spreadsheet: 97590d1296730798-how-to-highlight-different-words-at-the-same-time-sample
Sheet: Sheet1

FT  -13-0041
FT  -13-0066 | FT  -13-0141
FT  -13-0091 | FT  -13-0158
FT  -13-0116 | FT  -13-0166
FT  -13-0133 | FT  -13-0191
FT  -13-0141 | FT  -13-0216
FT  -13-0158 | FT  -13-0241
FT  -13-0166 | FT  -13-0266
FT  -13-0191 | FT  -13-0283
FT  -13-0216 | FT  -13-0291
FT  -13-0241
FT  -13-0266
FT  -13-0283
FT  -13-0291
FT  -13-0316
FT  -13-0333
Spreadsheet: 140355d1328716209-excel-2007-looking-for-help-with-if-statement-to-add-multiple-cells-copy-of-weekly-template-for-business-1
Sheet: Sat

 |  |  | Drawer Start | 100 |  |  | Starting Wash Counter |  |  |  |  | SCRATCH AREA |  |  |  | TOTAL
 |  |  |  |  |  |  | Ending Wash Counter |  |  |  | 100 | 50 | 20 | 10 | 5 | 1 | currency
Department | Tickets | Sales $ | Card Type | Sales $ | Tickets |  | Daily Wash Count |  | Reasons for Difference
Express |  | 50 | VISA/MC | 0 |  |  | Daily Ticket Count |  |  |  | 1 | 0.5 | 0.25 | 0.1 | 0.05 | 0.01 | coins
Exp. [NAME] |  | 0 | AMX | 0 |  |  | Difference
Ultimate |  | 0 | DISC | 0
[NAME] |  | 0 | Batch Total |  |  |  |  |  |  |  | [NAME] | Disc | Tip | Prod
Tanning |  | 0 | Currency |  |  |  | Today's Payroll
Tanning Product |  | 0 | Coin |  |  |  | Today's Taxes
Discount |  | 0 | Checks | 0 |  |  | Total Payroll
[NAME] |  | 0 | Gross Sales |  |  |  | % Labor
GC Redeemed |  | 0 | Discounts |  |  |  | Today's Gain
Tips |  | 0 | Net Sales |  |  |  | Today's Loss
Misc |  | 0 | Card Charges
Product |  | 0 | Checks
Total Ticket Sales |  |  | [NAME]
[NAME] |  | 0 | Calculated Cash In Drawer |  | OVER
SelfServe |  |  |  |  | SHORT
 |  |  | Cash out for Tomorrow Start | 50
Self Service Deposit |  |  |  |  | Wash Deposit
Community 1 |  |  |  |  | Wells Fargo
Today's Payroll | Time In | Time Out | Hours | $$ | Tips
[NAME]
Total Payroll
Spreadsheet: darron_c_giron__7977__midland_cogen
Sheet: 9912

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
1999-12-01 00:00:00
IFGMR (TRKL/TX) |  |  | 2.02 |  |  | No. of Days: | 31
IFGMR (TRKL/LA) |  |  | 2.08
IFGMR (PEPL/TX/OK) |  |  | 2.06
IFGMR (ANR/LA) |  |  | 2.07
IFGMR (HENRY HUB) |  |  | 2.14
NX3 |  |  | 2.16867
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302 (Ultramar)
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001
 | 1993 | 2.4 | 2002
 | 1994 | 2.51 | 2003
 | 1995 | 2.61 | 2004
 | 1996 | 2.53 | 2005
 | 1997 | 2.65 | 2006
 | 1998 |  | 2007 | 6.37
 | 1999
 | 2000
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-305 (Union Pacific)
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* |  | 2.5
DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* |  | 2.5
DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.5 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TRIGGER* (TX) |  | 2.5
TRIGGER* (LA) |  | 2.5
DIFFERENTIAL (TX)
DIFFERENTIAL (LA)
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D
*Customer prefers rounding to nearest penny.
Spreadsheet: 136852d1326848339-google-filter-to-excel-formula-needed-test1
Sheet: Sheet1

AUDIT | AGENTCITY | NUMBER | NAME | DATE | WORKER | USER | STATUS
1000620 | Brownsville | 1004 | BB | 2005-05-29 00:00:00 | BL | RR | Closed
1007871 | Laredo | 1924 | JGM | 2007-05-14 00:00:00 | ACK | DR | Closed
1028433 | Rockport | 2565 | EDA | 2007-11-05 00:00:00 | DWM | LMP | Closed
1028433 | Rockport | 2565 | EDA | 2007-11-05 00:00:00 | DWM | LMP | Closed
1028433 | Rockport | 2565 | EDA | 2007-11-05 00:00:00 | DWM | LMP | Closed
1028433 | Rockport | 2565 | EDA | 2007-11-05 00:00:00 | DWM | LMP | Closed
1016136 | [NAME] | 2843 | GR | 2008-01-08 00:00:00 | MLG | CC | Open
1031414 | Los Fresnos | 3126 | DAG | 2008-02-27 00:00:00 | DWM | GB | Closed
Spreadsheet: 888334d1738835283-all-formulas-seem-correct-but-which-is-more-accurate-percent-rank
Sheet: Sheet1

 | Player # | Points | % Rank.EXC | % Total | % Rank.INC | % Total
 | 1 | 4
 | 2 | 6
 | 3 | 1
 | 4 | 15
 | 5 | 10
 | 6 | 10
 | 7 | 7
 |  |  | Sum |  | Sum
 | Player # | Points | % Total
 | 1 | 4
 | 2 | 6
 | 3 | 1
 | 4 | 15
 | 5 | 10
 | 6 | 10
 | 7 | 7
 |  | Sum
Spreadsheet: 599091d1542852122-sumifs-formulea-results-0-00-not-working
Sheet: Lana

Lana
Referrer | Client Name | Loan Amount | Settled | NPW | Deferred
[NAME] | Timothy | 741000 | No | No | Yes
Justin | [NAME] | 53000 | No | Yes | No
Total
Spreadsheet: 771356d1646643706-select-conditional-data-from-a-table-book1
Sheet: Sheet1

SN | REM | [NAME]
q | 1 | Yes |  |  |  |  | 1
w | 2 | No |  |  |  | e | 3
e | 3 | Yes |  |  |  | r | 4
r | 4 | Yes |  |  |  | i | 8
t | 5 | No |  |  |  | p | 10
y | 6 | No |  |  |  | s | 12
u | 7 | No |  |  |  | d | 13
i | 8 | Yes |  |  |  | f | 14
o | 9 | No
p | 10 | Yes
a | 11 | No
s | 12 | Yes
d | 13 | Yes
f | 14 | Yes
Spreadsheet: 267853d1380242049-referencing-data-from-main-database-to-seperate-dataheets-formula-issue-employee1
Sheet: Register

Employee no: | First name | Last name | Date of birth | Start date | Section | Job title | License number | Medical details | Other details
RE-0121 | [NAME] | Smith | 1986-12-30 00:00:00 | 2013-09-15 00:00:00 | HM | Senior consultant | 201026857 | No allergies | -
[NAME] | [NAME] | [NAME] | 1981-10-08 00:00:00 | 2008-12-02 00:00:00 | LS | Technician | 200942614 | Diabetic | -
Spreadsheet: 219797d1362951410-counting-units-in-a-column-based-on-a-second-column-copy-of-xlf-counting-text
Sheet: Sheet1

A | B
ed
jo | ht
ex | jh
my
jo | df
jo
my | as
 | 2 |  | sumproduct
 | 2 |  | sumifs
Count of B
 | Total
ed |  |  | pivot table
ex | 1
jo | 2
my | 1
Grand Total | 4
Spreadsheet: 41999d1240532532-complex-lists-680876
Sheet: Sheet1

Ratio (Short span (a) /LongSpan(b) ) | Moment | Case 1 | Case 2 | Case 3 | Case 4 | Case 5 | Case 6 | Case 7 | Case 8 | Case 9 |  | ratio list
1 | Ca- | 0.5 | 0.1 |  | 1 |  |  |  |  |  |  | 1
 | Cb- | 0.6 | 0.4 |  | 2 |  |  |  |  |  |  | 0.95
 | Ca+(Dead) | 0.7 | 0.1 |  | 3
 | Cb+(Dead) | 0.4 | 0.55 |  | 4
 | Ca+(Live) | 0.3 | 0.9 |  | 5
 | Cb+(Live) | 0.5 | 0.4 |  | 6 |  |  |  |  |  |  | choose [NAME] | choose Case | >>>>>>>>>>> | Moments
0.95 | Ca- | 0.5 | 0.1 |  |  | 6 |  |  |  |  |  | 0.95 | Case 5 |  | Ca- | 6
 | Cb- | 0.6 | 0.4 |  |  | 5 |  |  |  |  |  |  |  |  | Cb- | 5
 | Ca+(Dead) | 0.7 | 0.1 |  |  | 4 |  |  |  |  |  |  |  |  | Ca+(Dead) | 4
 | Cb+(Dead) | 0.4 | 0.55 |  |  | 3 |  |  |  |  |  |  |  |  | Cb+(Dead) | 3
 | Ca+(Live) | 0.3 | 0.9 |  |  | 2 |  |  |  |  |  |  |  |  | Ca+(Live) | 2
 | Cb+(Live) | 0.5 | 0.4 |  |  | 1 |  |  |  |  |  |  |  |  | Cb+(Live) | 1
Spreadsheet: 102840d1300783735-prediction-sheet-excel_example
Sheet: predictiontemplate

Products & Sales |  |  |  |  | 2012 | PrSales_11 |  |  |  |  |  |  | predictiontemplate | #N/A
 |  |  | The numbers below represent sales per product
Description | Cost | Selling Price | jan | feb | [NAME] | apr | may | jun | jul | aug | sept | oct | nov | dec |  | jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec
1 | 4.9 | 6.125 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | 2.87992 | 3.5999 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | 2.87992 | 3.5999 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | 2.75 | 3.4375 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | 1.36 | 1.7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 | 2.4 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 | 2.08 | 2.6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 | 2.09 | 2.6125 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
9 | 3.02 | 3.775 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 | 3.99992 | 4.9999 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 | 4.8 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 | 1.12 | 1.4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 | 1.24 | 1.55 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14 | 1.4 | 1.75 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 | 1.44 | 1.8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
16 | 3.2 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
17 | 1.24 | 1.55 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
18 | 1.68 | 2.1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
19 | 1.8 | 2.25 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
20 | 1.96 | 2.45 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
21 | 2.04 | 2.55 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
22 | 1.68 | 2.1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
23 | 3.4 | 4.25 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 123675d1317802829-formula-needed-example
Sheet: Sheet1

Firm_id | UK | US | Aruba | Tanzania | Morocco | Firm investment in country with Smoking Ban |  |  | Country | No Smoking Ban
1 | 3 | 4 | 0 | 1 | 0 | 1 |  |  | UK | 0
2 | 0 | 0 | 1 | 0 | 1 | 1 |  |  | US | 0
3 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Aruba | 1
4 | 1 | 0 | 0 | 0 | 0 | 0 |  |  | Tanzania | 1
5 | 25 | 13 | 1 | 0 | 0 | 1 |  |  | Morocco | 1
Spreadsheet: 686193d1594408685-after-cutting-and-pasting-the-whole-row-excel-contracts-original-now-empty-rows-cut_paste-test1
Sheet: To do

123 | 20 | abc |  | U21 | 20200518 MOCN
1011 | 20 | asd |  | U21 | 20200518 MOCN
12 | 20 | asb |  | U21 | 20200518 MOCN
13 | 20 | def |  | U21 | 20200518 MOCN
Spreadsheet: f6e04841-56d8-4a96-9a1f-8462b4f968ac
Sheet: Total Request

Calculator Instructions:                                                                                                FOOD GROUP - TOMATOES | Click on a processor name to access its calculator.  While calculator formats are different, each will help you estimate the number of pounds you will need by asking for your estimated number of servings, ect.   Note, each excel spreadsheet is restricted by food group.  While some processors offer multiple items on one calculator, your request will only populate on the Total Request tab if it is within the food group listed on that spreadsheet.  You will need to pull up the beef spreadsheet to allocate beef pounds, the chicken calculator to allocate chicken pounds, ect.
 | The calculator will automatically calculate the number of pounds you will need for a specific item, and will input that number on the Total Request tab.  Once finished, take the numbers in yellow and transfer them to your NOI Request Form.  Be sure you are inputting the correct number of pounds for each processor.  The processor number on this form should match the processor number on the NOI Request Form.
Processor | Broker | Contact | Material | [NAME] | USDA Value | Total Value
58. Schwans Foodservice | Elite Foodservice | [NAME] | 100332 |  | 0.3612
59. Red Gold | Red Gold | [NAME] | 100332 |  | 0.3612
 |  |  |  |  | Total Value:
Spreadsheet: 679363d1590348995-slicer-which-can-list-by-specific-periods-2020-05-20-oeldere3-zanshin777-678478d1589909386-slicer-which-can-list-by-specific-periods-ex
Sheet: PT

Rijlabels | Som van Duration
AEU | 1296
00 - 03 Month | 60
04 - 06 Month | 15
24 Month and older | 1221
Ear_Training | 10
13 - 24 Month | 10
Guitar | 30
00 - 03 Month | 10
04 - 06 Month | 20
Intellectual | 109
00 - 03 Month | 70
07 - 12 Month | 35
13 - 24 Month | 4
Keyboard | 50
00 - 03 Month | 50
Songwriting | 30
04 - 06 Month | 30
Eindtotaal | 1525
Spreadsheet: 82765d1282781623-extract-data-to-different-workbook-example-workbook
Sheet: 4

 |  |  | 2008-01-04 00:00:00
Location | Trips | Liters | Gallons
[NAME] | 1 | 378.5 | 100
Centurion | 2 | 757 | 200
Dragon | 3 | 1135.5 | 300
Bldg 0039 | 4 | 1514 | 400
Fac 1 | 5 | 1892.5 | 500
Man | 6 | 2271 | 600
Dog Pen | 7 | 2649.5 | 700
Canal | 8 | 3028 | 800
Hot | 9 | 3406.5 | 900
Fac2 | 10 | 3785 | 1000
 | 55 | 20817.5 | 5500
 | 220 | 83270 | 22000
Spreadsheet: 551947d1513232734-to-insert-rows-of-data-between-other-rows-of-data-testexample
Sheet: Before

Original rows of data
11 | Blue | Delta | Orange
11 | Blue | Delta | Orange
11 | Blue | Delta | Orange
11 | Blue | Delta | Orange
Example rows to insert as blocks of new rows
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
LargeRoundCircle | TestEnvelopeConstant | AlwaysWorkingOnExcel | HopeToFindTheAnswer
Spreadsheet: darrell_schoolcraft__7317__imball0202
Sheet: SWGasTrans

 | SW Gas Transmission Co - contr27380
 | POI 78003 - TW/SGTC Mojave Del
Day | Measured | Scheduled
1 | -14096 | -14000
2 | -29052 | -29000
3 | -28909 | -28963
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | -20671
2002-02-03 00:00:00
CBS Volume
 |  |  | 3117
Spreadsheet: 793086d1661295341-index-and-match-returning-a-specific-value-if-the-value-is-anything-else-rerun-a-blank-sample
Sheet: system sheet

email Address | Workstation type
[EMAIL] | sDo
[EMAIL] | Do
[EMAIL] | sDo
[EMAIL] | Laptop
[EMAIL] | Laptop
[EMAIL] | Desktop
[EMAIL] | Workstation
[EMAIL] | sDo
[EMAIL] | Do
[EMAIL] | Laptop
[EMAIL] | Laptop
[EMAIL] | Workstation
[EMAIL] | Desktop
Spreadsheet: 108900d1305831838-summing-employee-shifts-book3
Sheet: 0411

6a - 3p | D | Day | 412.47
3p - 6a | N | Night | 687.53
 | W | Weekend | 1100
 | W | Whole Day | 1100
Date | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
2011-04-01 00:00:00 |  |  |  |  |  |  | W
2011-04-02 00:00:00
2011-04-03 00:00:00 | W
2011-04-04 00:00:00 |  |  |  |  |  | W
2011-04-05 00:00:00 |  |  |  | N |  | D
2011-04-06 00:00:00 |  |  |  |  |  | D |  |  | N
2011-04-07 00:00:00 |  |  |  |  | N | D
2011-04-08 00:00:00 |  | N |  |  |  | D
2011-04-09 00:00:00 |  |  |  |  |  |  |  | W
2011-04-10 00:00:00 |  | W
2011-04-11 00:00:00 |  |  |  |  |  |  | W
2011-04-12 00:00:00 |  |  |  |  | N |  | D
2011-04-13 00:00:00 |  | N |  |  |  |  | D
2011-04-14 00:00:00 |  |  |  |  |  |  | D |  | N
2011-04-15 00:00:00 |  |  |  |  |  | N | D
2011-04-16 00:00:00
2011-04-17 00:00:00 |  |  |  |  |  | W
2011-04-18 00:00:00 |  |  |  |  |  | D |  |  | N
2011-04-19 00:00:00 |  |  |  |  |  | D | N
2011-04-20 00:00:00 |  |  |  |  |  | W
2011-04-21 00:00:00 |  |  |  | N |  | D
2011-04-22 00:00:00 |  |  |  |  |  | D
2011-04-23 00:00:00
2011-04-24 00:00:00 |  |  |  |  | W
2011-04-25 00:00:00 |  |  |  |  |  |  |  |  | W
2011-04-26 00:00:00 |  |  |  |  |  |  | N |  | D
2011-04-27 00:00:00 |  | N |  |  |  |  |  |  | D
2011-04-28 00:00:00 |  |  |  | N |  |  |  |  | D
2011-04-29 00:00:00 |  |  | N |  |  |  |  |  | D
2011-04-30 00:00:00
Spreadsheet: 753605d1635549530-how-do-i-display-the-next-to-do-process-based-on-completed-task-from-same-row-progtrac
Sheet: CHK LIST

 |  | STATUS |  | LINE | BKG NUM | HBL NUM | VESSEL NAME |  | PLR | POD |  | POL | SOB | POD |  | CLIENT |  | NEXT STEP TO DO |  | PEND REL | BKG RECD | BKG TO CUST | BKG TO TRKR | WORK ORD TO TRKR | STUFFING | ALL UNITS LDD | FINAL GATEIN | RAILED ON | COMM INV FM CUST | B13/AES FILED | B13/AES FILED | SI FILED | SI FILED | VGM FILED | VGM FILED | MBLD FM SSL | MBLD TO CUST | [NAME] TO CUST | MBLC FM CUST | HBLC FM CUST | FIN MBL | FIN HBL | INV FROM SSL | INV FM TRKR
 |  |  |  |  |  |  |  |  |  |  |  | ETD | DATE | ETA |  |  |  |  |  | YES/NO | DATE | DATE | DATE | DATE | DATE | DATE | DATE | DATE | DATE | DATE | TIME | DATE | TIME | DATE | TIME | DATE | DATE | DATE | DATE | DATE | DATE | DATE | DATE | DATE
 |  |  |  |  |  |  |  |  | TOR | JEBEL ALI |  |  |  |  |  |  |  |  |  | NO
 |  |  |  |  |  |  |  |  | NOLA | ABU DHABI |  |  | 2021-10-25 00:00:00 |  |  |  |  |  |  | NO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-10-26 00:00:00 | 2021-10-27 00:00:00 | 2021-10-27 00:00:00 | 2021-10-27 00:00:00 | 2021-10-27 00:00:00 |  |  | 2021-10-26 00:00:00
 |  | WT FOR SOB |  |  |  |  |  |  | TOR | NVA SHEVA |  |  |  |  |  |  |  |  |  | NO
 |  |  |  |  |  |  |  |  | NOLA | ABU DHABI |  |  |  |  |  |  |  |  |  | NO
 |  |  |  |  |  |  |  |  | TOR | JEBEL ALI |  |  |  |  |  |  |  |  |  | NO
 |  |  |  |  |  |  |  |  | TOR | JEBEL ALI |  |  |  |  |  |  |  |  |  | NO
 |  |  |  |  |  |  |  |  | NYK | CAT LAI |  |  |  |  |  |  |  |  |  | NO | 2021-10-26 00:00:00 |  | CUST
 |  |  |  |  |  |  |  |  | NOLA | ABU DHABI |  |  |  | 2021-11-18 00:00:00 |  |  |  |  |  | NO |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1300
 |  |  |  |  |  |  |  |  | NOLA | ABU DHABI |  |  |  |  |  |  |  |  |  | NO
 |  |  |  |  |  |  |  |  | TOR | JEBEL ALI |  |  |  |  |  |  |  |  |  | NO
 |  | SAILED |  | MSC | EBKG01880913 | MEDUU2239819A | [NAME] |  | LBH | JEBEL ALI |  | 2021-09-21 00:00:00 | 2021-09-22 00:00:00 | 2021-11-18 00:00:00 |  | ISS |  |  |  | NO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-10-28 00:00:00
Spreadsheet: 850105d1700496749-drop-down-list-to-select-rows-must-also-include-all-sample-216-aligw
Sheet: Sheet1

Name | Score | Teacher |  |  |  | Teacher | All
[NAME] | 1 | Jones
[NAME] | 2 | Smith
[NAME] | 3 | Jones |  |  |  |  | 1 | Jones
 |  |  |  |  |  | [NAME] | 2 | Smith
 |  |  |  |  |  | [NAME] | 3 | Jones
Spreadsheet: 812122d1672966954-due-upcoming-overdue-123perwinkle-123
Sheet: R11

Project Phase | Deliverable | Responsible Party | Date Assigned | Date Due | Date Completed | Color | Current Issue? | Issues Resolved? | Due/Overdue | NOTES
Planning & Scope | Meet with [NAME] to discuss funding technology projects through other means for projects that are unlikely to move forward within the grant timeline | Jeromy | 2022-12-05 00:00:00 | 2022-12-20 00:00:00 | 2022-12-07 00:00:00 |  |  |  |  | A meeting has been set up with [NAME] and [NAME] on Dec. 22nd @830am.