tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kevin_presto__19779__Products
Sheet: MAIN

 | Pricing as of |  | Swap/Option Term |  |  |  |  | Futures Volatilities |  |  |  |  |  |  | Swaption Term
 |  |  |  | Month | Year | Date |  |  |  | Gasoline |  | Heating Oil |  |  |  | Month | Year | Date |  |  | Controls |  |  | Code Table |  |  | [NAME] | Gas | Gas | HO | HO | Jet
 |  |  | Start | 4 | 100 |  |  | Month |  | Current | Change | Current | Change |  | Start | 1 | 100 |  |  |  | Product Group | 1 |  | Jan | F |  | Hector | 0.01 | 0.01 | 0.03 | 0.022
 |  | IR | End |  |  |  |  |  |  | Vols | to Prev | Vols | to Prev |  | End | 12 | 100 |  |  |  | Product | 3 |  | Feb | G
 |  | Crude |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Option Control | 2 |  | Mar | H |  | [NAME] | NYH | GC | NYH | GC | Fuel
 | Swap Pricing Results |  |  |  |  |  |  |  |  |  |  |  |  |  | Swaption & Extendable Pricing |  |  |  |  |  | Swaption Type | 1 |  | Apr | J |  | Hector | NYH | GC | GC | NYH
 | WTI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vol | 0 |  |  | Participation Type | 1 |  | May | K
 | Swap |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Strike |  |  |  | Costless Collar Specification | 1 |  | Jun | M |  | 1 |  | 0 | 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Swap 2 Price |  | Swap 1 |  |  |  | Euro Expiration Dates | 1 |  | Jul | N |  | 2 |  | 5 | 42
 | Up/Down |  |  |  |  |  |  |  |  |  |  |  |  |  | Regular |  | Swap 2 |  |  |  | Skew On/Off | 1 |  | Aug | Q |  | 3 |  | 13 | 46
 | Option Input Adjustments |  |  |  |  |  |  |  |  |  |  |  |  |  | Override | 0 | [NAME] |  |  |  |  |  |  | Sep | U |  | 4 |  | 18 | 50
 |  | Vol | Vol | Price Spread |  | Price |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days for Theta Calculation | 1 |  | Oct | V |  | 5 |  | 24
 |  | Spread | Override | Specify | Used | Override |  |  |  |  |  |  |  |  | Participating Swap Pricing |  |  |  |  |  | [NAME] (1-Auto, 2-Man) | 1 |  | Nov | X
 | Asian | 0 | 0 | 0 |  | 0 |  |  |  |  |  |  |  |  | Rate |  |  | Price |  |  |  |  |  | Dec | Z |  | Horizontal Price Offset
 | Euro | 0 | 0 | 0 |  | 0 |  |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  | Extendable Swap |  |  |  |  |  | Horizontal Vol Offset
 | Combination Type |  |  | Strikes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Value
 |  |  |  |  | Specify | Used |  | Costless Collar Pricing |  |  |  | Euro Exp Date |  |  | Vol Skew |  |  |  |  |  | First Adjustment
 |  |  |  |  | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Participating Swap
 |  |  |  |  | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Value
 | Option Pricing Results |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | First Adjustment
 |  | [NAME] | Delta | Gamma | Vega |  |  | Delta* | Gamma* | Effect. Vol |  | Crack Spreads
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Calculation Mode
 |  |  |  |  |  |  |  |  |  | Swap Price
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Monthly | Total |  | Volume
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | PV | Esca-
 |  |  |  |  |  |  |  |  |  | Fut Price |  | Swap/Opt | 1 |  |  | lation
 |  |  |  |  |  |  |  |  |  |  |  | Swaption | 1 |  |  | 0
Spreadsheet: dana_davis__4474__CANADA - 46L - A
Sheet: E2.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 46L
COMPANY NAME:  SUNDANCE ECT CANADA ACCOUNTING ENTITY
ANALYSIS OF OTHER CURRENT ASSETS
FOR THE 3 MONTHS ENDED 3-31-2000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-2
 |  | 12-31-99 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2000 |  | OTHER |  | 06-30-2000 |  | OTHER |  | 09-30-2000 |  | OTHER |  | 12-31-2000
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Hyperion Line 0189 - Fair Value Investment (current)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total Current Assets | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 195
Asset/Expense Accts:  DR/(CR)
Spreadsheet: 0a33c2b0-8ce8-4a5c-a57a-3596d1af72e7
Sheet: Sheet1

TRAVEL REIMBURSEMENT FORM | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Reminder: Travel must be approved in advance by your faculty advisor!
Student Name & ID #: |  | Team:
Faculty Signature: |  | Date:
INSTRUCTIONS:
1. Complete this form. Have this form signed by your project faculty advisor. Please submit a check request for no
less than $25.00. You can combine this with other receipts (including a Purchase Requisition/Reimbursement form).
* Mileage reimbursement requests MUST include either a Google map or Mapquest detail of start-finish route,  including
total miles traveled.
* Mileage is reimbursed at 56 cents/mile. Gas Receipts will NOT be reimbursed.
2. Take this signed form and a copy of it along with any receipts to the Project Center (ENGR 500). A reimbursement
check will be processed. Please allow 7 to 10 working days. The Project Center will contact you once your check has
arrived.
Date | Address of Destination (To & From) | Purpose | [NAME] | Cost
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  | TOTAL: | 0
Spreadsheet: 76443d1276976334-cell-referencing-end-of-day-cell-reset-excel-forum-sheet
Sheet: Current inventory

 | Product Code |  | Product description | Available for sale | Committed Quantities | In bunker (approx.) | [NAME] size (approx) | WIP
18 | 205 | MAM | Mahogany chips | 100 | 0 | 100 | 85
17 | 206 | BAM | Black chips | 80 | 0 | 80 | 85
16 | 207 | RAM | Red chips | 65 | 0 | 65 | 100
13 | 617 | AS420 | All Season 420 | 35 | 0 | 35
2 | 720 | AP | All Green Planter | 200 | 0 | 200 | 200
3 | 723 | GM | Organic Garden Mix | 110 | 0 | 110 | 230
4 | 728 | LP | Landscape Planter | 0 | 0 | 0 | 180
5 | 731 | LS | [NAME] | 12 | 0 | 12 | 30
6 | 737 | NL | [NAME] | 25 | 0 | 25 | 140
7 | 740 | NP | Nursery Planter | 80 | 0 | 80 | 150
8 | 743 | ON | Organic Nursery | 85 | 0 | 85 | 120
9 | 746 | OS | Organic Starter | 10 | 0 | 10 | 30
10 | 749 | RM | [NAME] | 60 | 0 | 60
11 | 752 | SL | [NAME] | 50 | 0 | 50
12 | 755 | VN | Value Nursery | 5 | 0 | 5 | 180
15 | 765 | AM | Arbor Mulch | 2000 | 0 | 2000
19 | 771 | EM | [NAME] | 6 | 0 | 6
20 | 774 | FB1 | 1/4- Fir bark | 40 | 0 | 40 | 80
22 | 783 | FR | Fine Shredded Redwood | 85 | 0 | 85 | 100
23 | 786 | RR | Rough Shredded Redwood | 55 | 0 | 55 | 120
21 | 790 | RAW | Raw Fir bark | 80 | 0 | 80 | 80
25 | 850 | AC | All Green Compost | 80 | 0 | 80 | 200
26 | 853 | COW | Cow Manure | 85 | 0 | 85
27 | 859 | HOR | Horse Manure | 2 | 0 | 2
28 | 862 | MM | [NAME] | 125 | 0 | 125 | 250
29 | 865 | NS | [NAME] Sawdust | 90 | 0 | 90 | 350
30 | 868 | OVC | OVC | 98 | 0 | 98
32 | 877 | TAN | [NAME] | 0 | 0 | 0
31 | 880 | REA | Real McCoy | 0 | 0 | 0
33 | 883 | TM | [NAME] | 30 | 0 | 30 | 50
35 | 888 | RL1 | 1/8- [NAME] rock | 10 | 0 | 10 | 40
36 | 891 | RL2 | [NAME] rock | 50 | 0 | 50 | 200
37 | 894 | RLC | 5/16 Clean | 35 | 0 | 35 | 180
14 | Barks & Ground Covers
24 | Compost & Materials
34 | Sand & Rock
1 | Topsoils and [NAME] |  |  |  |  |  |  | How much? | Date to screen | Complete
Spreadsheet: 72707d1273433178-help-with-an-excel-lookup-forumula-that-returns-column-heading-student_presentations
Sheet: By Student

Student Name | Presentation 1 | Presentation 2 | Presentation 3 | Presentation 4 | Presentation 5 | Presentation 6 | Presentation 7 | Presentation 8
Student 1
Student 2
Student 3
Student 4
Student 5
Student 6
Student 7
Student 8
Student 9
Student 10
Student 11
Student 12
Student 13
Student 14
Student 15
Student 16
Student 17
Student 18
Student 19
Student 20
Student 21
Student 22
Student 23
Student 24
Student 25
Student 26
Student 27
Student 28
Student 29
Student 30
Student 31
Student 32
Student 33
Student 34
Student 35
Student 36
Student 37
Student 38
Student 39
Student 40
Student 41
Student 42
Student 43
Student 44
Student 45
Student 46
Student 47
Student 48
Student 49
Student 50
Spreadsheet: 757751d1638446754-im-looking-for-help-on-how-link-a-master-sheet-to-populate-another-sheets-in-the-workbook-team-roster
Sheet: Sheet1

 | Age
Tm | Tm |  |  | Tm | Tm
Lg | Lg |  |  | Lg | Lg
W | W |  |  | G | G
L | L |  |  | PA | PA
W-L% | W-L% |  |  | AB | AB
ERA | ERA |  |  | R | R
G | G |  |  | H | H
GS | GS |  |  | 2B | 2B
GF | GF |  |  | 3B | 3B
CG | CG |  |  | HR | HR
SHO | SHO |  |  | RBI | RBI
SV | SV |  |  | SB | SB
IP | IP |  |  | CS | CS
H | H |  |  | BB | BB
R | R |  |  | SO | SO
ER | ER |  |  | BA | BA
HR | HR |  |  | OBP | OBP
BB | BB |  |  | SLG | SLG
IBB | IBB |  |  | OPS | OPS
SO | SO |  |  | P | OPS+
HBP | HBP |  |  |  | TB
BK | BK |  |  |  | GDP
WP | WP |  |  |  | HBP
BF | BF |  |  |  | SH
ERA+ | ERA+ |  |  |  | SF
FIP | FIP |  |  |  | IBB
WHIP | WHIP |  |  |  | Pos Summary
BB9 | H9
HR9 | HR9
H9 | BB9
SO9 | SO9
SO/W | SO/W
Spreadsheet: 60109d1260634660-percentage-change-assignment-nearly-there
Sheet: Sheet1

 |  |  |  |  |  |  |  | a peice of work is handed in on time they get a full percentage but if 1 week late 10% is deducted the 2 weeks late 20 percent is deducted then a 3rd week 30 percent is taken off. After 3 weeks they are awarded no marks.
 | Student Surname | Student Name | Date Of birth | Student ID | Part A Mark | A % | Part B Mark | B % | Submission Date | Total marks | Total Percentage | Total percentages after deductions | Grade
 | Barnes | [NAME] | 1946-10-03 00:00:00 | 51242 | 10 |  | 6 |  | 2009-05-05 00:00:00
 | [NAME] | [NAME] | 1943-02-12 00:00:00 | 51073 | 5 |  | 7 |  | 2009-05-04 00:00:00
 | dodd | [NAME] | 1939-05-19 00:00:00 | 51451 | 2 |  | 3 |  | 2009-05-17 00:00:00
 | gray | [NAME] | 1941-02-24 00:00:00 | 51104 | 5 |  | 4 |  | 2009-05-05 00:00:00
 | gray | [NAME] | 1949-02-11 00:00:00 | 51407 | 5 |  | 4 |  | 2009-05-07 00:00:00
 | hoyle | [NAME] | 1941-06-10 00:00:00 | 51289 | 9 |  | 9 |  | 2009-05-26 00:00:00
 | jacobs | [NAME] | 1942-02-18 00:00:00 | 52862 | 7 |  | 6 |  | 2009-06-08 00:00:00
 | [NAME] | Angus | 1940-10-18 00:00:00 | 51986 | 5 |  | 4 |  | 2009-05-03 00:00:00
 | [NAME] | Kirsty | 1943-03-12 00:00:00 | 51932 | 4 |  | 4 |  | 2009-05-19 00:00:00
 | rudkin | [NAME] | 1947-07-08 00:00:00 | 51182 | 4 |  | 6 |  | 2009-05-04 00:00:00
 | [NAME] | Edwina | 1946-10-10 00:00:00 | 51066 | 8 |  | 7 |  | 2009-05-05 00:00:00
 | [NAME] | Mark |  | Average Mark A |  | Average Mark B |  |  | Average mark A\B
 | Fail | <39.5
 | Pass | >39.5 >59.5
 | Merit | >59.5 >79.5
 | Distinction | >79.5
 | late submission date | start of week | percentage
 | On Time 5/5/09 | 00:00:00 | 1
 | 1 week late 12/05/09 | 2009-05-06 00:00:00 | 0.9
 | 2 weeks late 19/05/09 |  | 0.8
 | 3 weeks late 26/05/09 |  | 0.7
 | after 3 weeks |  | 0
Spreadsheet: 163342d1340281682-excel-2007-cluster-analysis-ad1
Sheet: Ark1

Butik | Navn | Kedja | [NAME] 25 | [NAME] 26 | [NAME] 27 | [NAME] 28 | [NAME] 29 | [NAME] 30 | [NAME] 31 | [NAME] Index 32 | [NAME] 33
12 | shop1 | x | 1.015744828311129 | 1.035293019385778 | 0.9668135576060118 | 1.032583703227721 | 0.9517086070176051 | 1.003596359944408 | 1.037787150593166 | 1.058439090047822 | 0.6525718816022995
13 | shop2 | x | 0.8885888589077877 | 0.9468610831047672 | 0.9391791476580277 | 0.9376759973943188 | 0.8996815943576885 | 0.922515955733153 | 1.007726730609799 | 0.9686709233662318 | 0.7674205646188124
14 | shop3 | x | 1.03820329628578 | 1.091666256246276 | 1.009888743185149 | 1.020635020470759 | 0.984763364536757 | 1.009694844914652 | 0.9634293987983737 | 0.9681041155088197 | 0.7130177310162951
15 | shop4 | x | 0.978898981955689 | 1.015302588844818 | 1.010554822706143 | 0.9941104009799475 | 0.9504932794715802 | 0.9775319047001723 | 0.9810519277658127 | 1.04743389245714 | 0.6195657001062835
16 | shop5 | x | 1.139942944748534 | 1.10156856965354 | 1.10681265323596 | 1.097945750987551 | 1.059526263954735 | 1.043106747731927 | 1.047973816793634 | 1.086391919944075 | 0.8729627189474538
17 | shop6 | x | 0.7941998374440378 | 0.724075049003961 | 0.7199079514433279 | 0.6294411635678343 | 0.675055255080338 | 0.7019401861571127 | 0.7078452049551549 | 0.7000283643334517 | 0.4240678002631122
Spreadsheet: 75d2b50e-dafd-4e82-9548-f7e7ff115170
Sheet: Sheet1

PSI VIETNAM | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
[NAME] template for selecting consultant
For training on hypertension management for private doctors  in Danang ( 2 courses) & Hochiminh (2 courses)
No | Item name  (Detailed specifications attached) |  | Unit | Quantity | Unit Price  (VND) | Total price  (VND)
 | Development of training curriculum
1 | Development of training curriculum & material/day |  | days | 2
 | Consultation fee
2 | Consultants fee (1 day training facilitation + 1/2 reporting day)/courses |  | course | 4
3 | Per-diem (1 day training + 0.75 day flying) |  | course | 4
4 | Air ticket |  | return | 4
5 | Local travel fee for consultant (if needed) |  | days | 4
6 | Accomodation for research consultants (if needed) |  | night | 4
Total
Spreadsheet: 862978d1710525367-calendar-formulas-and-conditional-formatting-annual-calendar-dj
Sheet: January

 |  |  |  |  |  |  |  |  | JAN
 | NOTES
Spreadsheet: darrell_schoolcraft__7735__imball0203
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 | -84738 | -85300 |  |  |  |  |  |  |  | San Juan
2 | -84260 | -85300 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
3 | -85534 | -85300 |  |  |  | 2001-02-01 00:00:00 | -537 | -5933 |  | 5.62
4 | -77757 | -85300 |  |  |  | 2001-03-01 00:00:00 | -80533 | -96000 |  | 4.98
5 | -56602 | -49977 |  |  |  | 2001-04-01 00:00:00 | -819833 | -1020974 |  | 4.87
6 |  |  |  |  |  | 2001-05-01 00:00:00 |  | -1252019 |  | 3.82
7 |  |  |  |  |  | 2001-06-01 00:00:00 |  | -1589467 |  | 3.2
8 |  |  |  |  |  | 2001-07-01 00:00:00 | -2051914 | -1898771 |  | 2.77
9 |  |  |  |  |  | 2001-08-01 00:00:00 | -2021619 | -1999977 |  | 2.77
10
11
12
13 | -6
14 | -2 |  |  |  |  | 9/1 - 9/25
15 | -325 | -10000
16 | -12569 | -33554
17 | -58047 | -34047
18 | -81844 | -60570
19 | -86245 | -87486 |  |  |  | Accumulated @ 9/25/01
20
21 |  |  |  |  |  | Equilalent volumes at 9/25/01
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  | 15394.13
2002-03-19 00:00:00
CBS Volume
 |  |  | 94380
Spreadsheet: 839265d1691772073-a-column-that-repeats-a-plate-5-times-and-adds-a-different-letter-after-each-plate-example-mn
Sheet: Minnesota

ACCT Number | ST | PLATE | EQUIP | VIN | MAKE | YEAR |  |  |  |  |  |  | Count of MN | Count of [NAME]
 | MN | STA2044A | 2810014 | 1GRAA5614BB701524 | Great Dane | 2011
511435 | MN | STA2044E | 2810014 | 1GRAA5614BB701524 | Great Dane | 2011
511435 | MN | STA2044H | 2810014 | 1GRAA5614BB701524 | Great Dane | 2011
511435 | MN | STA2044O | 2810014 | 1GRAA5614BB701524 | Great Dane | 2011
511435 | MN | STA2044T | 2810014 | 1GRAA5614BB701524 | Great Dane | 2011
511435 | MN | 6659STRA | 8881600 | 1GRAA5616BB701525 | Great Dane | 2011
511435 | MN | 6659STRE | 8881600 | 1GRAA5616BB701525 | Great Dane | 2011
511435 | MN | 6659STRH | 8881600 | 1GRAA5616BB701525 | Great Dane | 2011
511435 | MN | 6659STRO | 8881600 | 1GRAA5616BB701525 | Great Dane | 2011
511435 | MN | 6659STRT | 8881600 | 1GRAA5616BB701525 | Great Dane | 2011
511435 | MN | 5129STPA | 3616033 | 1GRAA7221GE700895 | Great Dane | 2016
511435 | MN | 5129STPE | 3616033 | 1GRAA7221GE700895 | Great Dane | 2016
511435 | MN | 5129STPH | 3616033 | 1GRAA7221GE700895 | Great Dane | 2016
511435 | MN | 5129STPO | 3616033 | 1GRAA7221GE700895 | Great Dane | 2016
511435 | MN | 5129STPT | 3616033 | 1GRAA7221GE700895 | Great Dane | 2016
511435 | MN | 1500STVA | 3617034 | 1GRAA7221HE702826 | Great Dane | 2017
511435 | MN | 1500STVE | 3617034 | 1GRAA7221HE702826 | Great Dane | 2017
511435 | MN | 1500STVH | 3617034 | 1GRAA7221HE702826 | Great Dane | 2017
511435 | MN | 1500STVO | 3617034 | 1GRAA7221HE702826 | Great Dane | 2017
511435 | MN | 1500STVT | 3617034 | 1GRAA7221HE702826 | Great Dane | 2017
Spreadsheet: 782718d1654199281-using-less-than-function-with-blank-cells-excel-forum-question
Sheet: Sheet1

DOB | Incident_Date | Age at Time of Incident | Juvenile Under 17 yoa Y/N
 | 2006-06-20 00:00:00
 | 2008-01-20 00:00:00
 | 2009-04-12 00:00:00
1985-07-30 00:00:00 | 2010-10-31 00:00:00
1985-08-02 00:00:00 | 2011-04-24 00:00:00
1993-10-25 00:00:00 | 2011-05-30 00:00:00
1988-07-28 00:00:00 | 2011-06-27 00:00:00
1997-07-23 00:00:00 | 2011-07-04 00:00:00
1949-01-23 00:00:00 | 2011-08-06 00:00:00
 | 2012-05-28 00:00:00
Spreadsheet: 107138d1304354699-excel-2007-creating-a-dropdown-from-cells-on-another-sheet-workout-1-
Sheet: May

 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | Legs | Back
2
Spreadsheet: 763387d1642151399-price-development-price-development-ans
Sheet: Sheet1

PN | Date | Price |  | PN |  | 2022-01-15 00:00:00 | 2022-02-01 00:00:00 | 2022-04-20 00:00:00 | 2022-05-20 00:00:00 | 2022-10-06 00:00:00 | 2022-10-15 00:00:00 | 2022-10-28 00:00:00 | 2022-11-06 00:00:00 | 2022-11-15 00:00:00 | 2022-11-28 00:00:00 | 2022-12-31 00:00:00
A | 2022-01-01 00:00:00 | 30
A | 2022-11-28 00:00:00 | 15 |  | B
A | 2022-12-31 00:00:00 | 30 |  | C
B | 2022-01-01 00:00:00 | 15 |  | D
B | 2022-04-20 00:00:00 | 10 |  | E
B | 2022-10-06 00:00:00 | 7 |  | F
B | 2022-10-28 00:00:00 | 15
C | 2022-01-01 00:00:00 | 6
C | 2022-10-06 00:00:00 | 4
C | 2022-10-15 00:00:00 | 30
C | 2022-11-15 00:00:00 | 30
C | 2022-12-31 00:00:00 | 50
D | 2022-01-01 00:00:00 | 8
D | 2022-11-06 00:00:00 | 4
E | 2022-01-01 00:00:00 | 15
E | 2022-02-01 00:00:00 | 13
E | 2022-05-20 00:00:00 | 10
F | 2022-01-01 00:00:00 | 23
F | 2022-01-15 00:00:00 | 10
F | 2022-10-06 00:00:00 | 17
 |  |  |  |  | Correct Result
 |  |  |  | PN |  | 2022-01-15 00:00:00 | 2022-02-01 00:00:00 | 2022-04-20 00:00:00 | 2022-05-20 00:00:00 | 2022-10-06 00:00:00 | 2022-10-15 00:00:00 | 2022-10-28 00:00:00 | 2022-11-06 00:00:00 | 2022-11-15 00:00:00 | 2022-11-28 00:00:00 | 2022-12-31 00:00:00
 |  |  |  |  | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 15 | 30
 |  |  |  | B | 15 | 15 | 15 | 10 | 10 | 7 | 7 | 15 | 15 | 15 | 15 | 15
 |  |  |  | C | 6 | 6 | 6 | 6 | 6 | 4 | 30 | 30 | 30 | 30 | 30 | 50
 |  |  |  | D | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 4 | 4 | 4 | 4
 |  |  |  | E | 15 | 15 | 13 | 13 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
 |  |  |  | F | 23 | 10 | 10 | 10 | 10 | 17 | 17 | 17 | 17 | 17 | 17 | 17
Spreadsheet: 147548d1332853810-matching-text-and-applying-criteria-on-row-ef68_test-scores
Sheet: Sheet1

 |  |  | Test Number
 |  | Student Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25
 |  | Clarke
 |  | Smith
 |  | [NAME]
 |  | [NAME]
 |  | Green
 |  | English
 |  | Carroll
 |  | [NAME]
 |  | Ward
 |  | Gray
 |  | Thompson
 |  | Adams
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Period Averages
 |  |  |  |  |  |  |  |  |  |  |  |  | Student Name | 1-5 | 6-10 | 11-15 | 16-20 | 21-25
 |  |  |  |  |  |  |  |  |  |  |  |  | Ward
 |  |  |  |  |  |  |  |  |  |  |  |  | Thompson
 |  |  |  |  |  |  |  |  |  |  |  |  | Smith
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Green
 |  |  |  |  |  |  |  |  |  |  |  |  | Gray
 |  |  |  |  |  |  |  |  |  |  |  |  | English
 |  |  |  |  |  |  |  |  |  |  |  |  | Clarke
 |  |  |  |  |  |  |  |  |  |  |  |  | Carroll
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Adams
Spreadsheet: 792746d1661139523-conditional-formatting-exclude-zero-value-from-smallest-value-ask-conditional-formatting
Sheet: Sheet1

 | CURRENT |  | -> | TARGET
 | August | Revenue |  | August | Revenue |  | Conditional Formatting
 | 1 | 400 |  | 1 | 400 |  | -How to set RED background to 100 (as the smallest revenue so far)?
 | 2 | 900 |  | 2 | 900
 | 3 | 100 |  | 3 | 100 |  | Please:
 | 4 | 300 |  | 4 | 300 |  | -Ignore Zero
 | 5 | 0 |  | 5 | 0 |  | -There are Multiple Zero (future daily revenue)
 | 6 | 0 |  | 6 | 0 |  | -Smallest Number in this case is 100 (and could be different based on daily revenue)
 | 7 | 200 |  | 7 | 200 |  | -Use formula/Automatic (Not Manual as i did, LOL)
 | 8 | 0 |  | 8 | 0
 | 9 | 0 |  | 9 | 0
 | 10 | 0 |  | 10 | 0 |  | Thank you so much
 | 11 | 500 |  | 11 | 500
 | 12 | 0 |  | 12 | 0
 | 13 | 0 |  | 13 | 0
 | 14 | 0 |  | 14 | 0
 | 15 | 600 |  | 15 | 600
 | 16 | 0 |  | 16 | 0
 | 17 | 0 |  | 17 | 0
 | 18 | 0 |  | 18 | 0
 | 19 | 0 |  | 19 | 0
 | 20 | 0 |  | 20 | 0
 | 21 | 0 |  | 21 | 0
 | 22 | 0 |  | 22 | 0
 | 23 | 0 |  | 23 | 0
 | 24 | 0 |  | 24 | 0
 | 25 | 0 |  | 25 | 0
 | 26 | 0 |  | 26 | 0
 | 27 | 0 |  | 27 | 0
 | 28 | 0 |  | 28 | 0
 | 29 | 0 |  | 29 | 0
 | 30 | 0 |  | 30 | 0
 | 31 | 0 |  | 31 | 0
Spreadsheet: 115339d1310994854-not-to-sure-which-statement-to-use-projecthrs
Sheet: Sheet1

Project | Name | Date | Hrs
House | [NAME] | 2011-06-01 00:00:00 | 2
House | [NAME] | 2011-06-01 00:00:00 | 3 |  |  | Sum of Hrs | Column Labels
House | [NAME] | 2011-06-01 00:00:00 | 4 |  |  | Row Labels | 2011-06-01 00:00:00 | 2011-06-02 00:00:00 | 2011-06-03 00:00:00 | Grand Total
Garden | [NAME] | 2011-06-01 00:00:00 | 3 |  |  | Garden | 5 | 5 | 1 | 11
Garden | [NAME] | 2011-06-01 00:00:00 | 2 |  |  | [NAME] | 2 | 1 |  | 3
Garden | [NAME] | 2011-06-02 00:00:00 | 4 |  |  | [NAME] | 3 | 4 | 1 | 8
Garden | [NAME] | 2011-06-02 00:00:00 | 1 |  |  | House | 9 | 1 | 1 | 11
House | [NAME] | 2011-06-02 00:00:00 | 1 |  |  | [NAME] | 3 |  |  | 3
House | [NAME] | 2011-06-03 00:00:00 | 1 |  |  | [NAME] | 2 |  |  | 2
Garden | [NAME] | 2011-06-03 00:00:00 | 1 |  |  | [NAME] | 4 | 1 | 1 | 6
 |  |  |  |  |  | Grand Total | 14 | 6 | 2 | 22
Spreadsheet: sara_shackleton__36411__PHONE_LIST
Sheet: SP Fax & Conf rooms

[NAME] do [NAME].
SÃO PAULO OFFICE
Av. das [NAME], 11.541 - 6º andar - 04578-000 - São Paulo - SP - Brasil                                  Tel. 55 11 5503 -1399    Fax. 55 11 5507-3090
FAXES
5th | 5507-3090
M & A | 5507-1170
6th | 5503-1305
6th | 5503-1270
7th | 5503-1304
Human Resources | 5503-1262
[NAME] | 5503-1323
Legal | 5507-3626
[NAME]. 6th - Randy Young | 5503-1352
[NAME] | 5506-6986
Treasure/Accountancy | 5503-1352
CONFERENCE ROOMS
Conference Room 5C1 | 1189 - 5th
Conference Room 5C2 | 1174 - 5th
Conference Room 5C3 | 1209 - 5th
Conference Room 5C4 | 1204 - 5th
Conference Room 5C5 | 1309 - 5th
Conference Room 6C1 | 1177 - 6th
Conference Room 6C2 | 1152 - 6th/Star 2544
Conference Room 6C3 | 1153 - 6th/Star 2546
Conference Room 6C4 | 1156 - 6th
Conference Room 7C1 | 1313 - 7th
Conference Room 7C2 | 1311 - 7th
Spreadsheet: 833463d1686986190-retrieve-all-info-from-source-data-for-all-matches-from-list-find-all-matches
Sheet: Results

Name | Asset | Make | Model | S/N
Spreadsheet: 736888d1623934836-need-an-alternate-to-vlookup-mnlala-help
Sheet: Sheet2

SML | 1234 | US | UK | IT | FR | DAN/GER | RUSSIA | AUSTRALIA | JAPAN | JEANS
[NAME] |  | US 0 | UK 4 | IT 36 | FR 32 | 30 | 38 | 4 | 3 | 23
XS |  | US 2 | UK 6 | IT 38 | FR 34 | 32 | 40 | 6 | 5 | 24-25
S | 0 | US 4 | UK 8 | IT 40 | FR 36 | 34 | 42 | 8 | 7 | 26-27
M | 1 | US 6 | UK 10 | IT 42 | FR 38 | 36 | 44 | 10 | 9 | 27-28
L | 2 | US 8 | UK 12 | IT 44 | FR 40 | 38 | 46 | 12 | 11 | 23-30
XL | 3 | US 10 | UK 14 | IT 46 | FR 42 | 40 | 48 | 14 | 13 | 31-32
XXL | 4 | US 12 | UK 16 | IT 48 | FR 44 | 42 | 50 | 16 | 15 | 32-33
US 0 | [NAME]
UK 4 | [NAME]
IT 36 | [NAME]
FR 32 | [NAME]
30 | [NAME]
38 | [NAME]
4 | [NAME]
3 | [NAME]
23 | [NAME]
US 2 | XS
UK 6 | XS
IT 38 | XS
FR 34 | XS
32 | XS
40 | XS
6 | XS
5 | XS
24-25 | XS
0 | S
US 4 | S
UK 8 | S
IT 40 | S
FR 36 | S
34 | S
42 | S
8 | S
7 | S
26-27 | S
1 | M
US 6 | M
UK 10 | M
IT 42 | M
FR 38 | M
36 | M
44 | M
10 | M
9 | M
27-28 | M
2 | L
US 8 | L
UK 12 | L
IT 44 | L
FR 40 | L
38 | L
46 | L
12 | L
11 | L
23-30 | L
3 | XL
US 10 | XL
UK 14 | XL
IT 46 | XL
FR 42 | XL
40 | XL
48 | XL
14 | XL
13 | XL
31-32 | XL
4 | XXL
US 12 | XXL
UK 16 | XXL
IT 48 | XXL
FR 44 | XXL
42 | XXL
50 | XXL
16 | XXL
15 | XXL
32-33 | XXL