tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 840981d1693240132-compare-different-cells-on-one-row-and-highlight-the-lowest-one-example
Sheet: Sheet1

 | Example form
 | SUPPLIER1 |  |  |  |  |  |  |  |  | SUPPLIER2 |  |  |  | SUPPLIER3 |  |  |  | SUPPLIER4 |  |  |  | [NAME] |  |  |  | SUPPLIER6
 | CODE1 | CODE2 | [NAME] | Type | Value | Qnt. | Single Price | Total Price | Correction | CODE1 | Qnt | Single Price | Total Price | CODE1 | Qnt | Single Price | Total Price | CODE1 | Qnt | Single Price | Total Price | CODE1 | Qnt | Single Price | Total Price | CODE1 | Qnt | Single Price | Total Price
 | L |  | Gardens |  |  |  |  |  |  | L |  |  |  | L |  |  |  | L |  |  |  | L |  |  |  | L
 | LP | Plot | [NAME] |  |  |  |  |  |  | LP |  |  |  | LP |  |  |  | LP |  |  |  | LP |  |  |  | LP
 |  | 1 | Flowers
 |  | 1.1 | Trees
 | 1 | 1.1.1 | 1.Tree A | 175-200 | amt | 8 | 200 |  | 1500 | 1 | 7 | 180 |  | 1 | 8 | 300 |  | 1 | 8 | 150 |  | 1 | 2 | 100 |  | 1 | 3 | 400
 | 2 | 1.1.2 | 1.    1.Tree B | 175-200 | amt | 12 | 150 |  | 2300 | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2
 | 3 | 1.1.3 | 1.    1.Tree C | 175-200 | amt | 17 | 250 |  | 4150 | 3 |  |  |  | 3 |  |  |  | 3 |  |  |  | 3 |  |  |  | 3
Spreadsheet: 537890d1505314471-word-document-to-excel-form-eaf_template
Sheet: Drop Downs

NOTE: Rows on Sheet1 go to row 100
Position Budgeted |  | Action Type |  | Term Reason | Sal Change Reason | Status
Yes |  | Cost Center / Dept Change |  | INV Attendance | Adjustment | Full Time
No |  | Data Change |  | INV Death of Employee | Cost of Living Adjustment | Part Time
 |  | Demotion |  | INV Policy Violation | Merit
 |  | Job Reclassification |  | INV Position Elimination | Special Project
 |  | Leave of Absence |  | INV Unable return from Leave
 |  | Location Change |  | INV Unsatisfactory Performance
 |  | Manager Change |  | VOL Became Self-Employed | FLSA
 |  | Other |  | VOL Business Divested | Exempt
 |  | Pay Rate Change |  | VOL Dissat Compensation | Non-Exempt
 |  | Position Change |  | VOL Dissat Fellow Empl
 |  | Promotion |  | VOL Dissat Hours
 |  | Rehire |  | VOL Dissat Promo Opportunities
 |  | Retirement |  | VOL Dissat Supervision
 |  | Termination |  | VOL Dissat Type of Work
 |  |  |  | VOL Dissat Work Conditions
 |  |  |  | VOL Dissat Work Location
 |  |  |  | VOL Dissatisfied Corp Policies
 |  |  |  | VOL Internship Ended
 |  |  |  | VOL Job Abandonment
 |  |  |  | VOL Merger Severance
 |  |  |  | VOL Mutual Consent
 |  |  |  | VOL Personal Reasons
 |  |  |  | VOL Refused Transfer
 |  |  |  | VOL Relocation
 |  |  |  | VOL Retirement w/o Pension
 |  |  |  | VOL Retirement with Pension
 |  |  |  | VOL Return to School
 |  |  |  | VOL Work Eligibility Expiratio
Spreadsheet: 206691d1358258285-statistical-spreadsheet-test
Sheet: Test

TEST
attached are 2 statistics from all production facilities in Ireland (IRE), France (FRA) and MEXICO (MEX)
1) Cost driver statistic shows, how much time we need in the single production areas for the process
2) Print statistic shows how many prints we have  per product ( back, front, sleeve..)
Task 1:
Work with Excel and show the process to find out:
a)  Mention the 5 most time consuming  processes of all facilities that has to be improved first (top down), according to the produced volumes
this is a benchmark test, which processes do we have to improve first to have less time/costs?
b) Mention the facility and the process you have to start first ( top down the first 5 processes) to save most time.
c) How much time would we save in hours per process if we would have the best process in place in each facility?
Hint: you have to use all given data.
 |  | Time is in minutes/cost driver
YTD 2011 |  | Time/CD [min]
CostCenter | CostDriver (CD) | IRE | FRA | MEX
DD |  | 3.238211440837874 | 5.085702177894147 | 5.110825920232858
DT/DTO |  | 1.341713544694362 | 0.762920371357249 | n.a.
BatchCards |  | 0.1730840581298879 | 0.137648833487247 | 0.2234397548541236
Weeding |  | 1.455820851882593 | 1.49316587291164 | 1.693090779328638
Layout |  | 0.5122013883648986 | 0.7958197565510711 | 0.6961705047680942
Plott |  | 0.3164470308609371 | 0.4302069292855283 | 0.2883566027844806
Press |  | 1.459707236097488 | 1.821307656683095 | 2.145885813128408
Inventory |  | 0.8387532917930028 | 1.303178948544611 | 1.006858318739344
Quality Control |  | 1.327643188324195 | 1.565174525030975 | 1.19994789241814
Tassen/Button |  | 3.790368379446639 | 3.768718320057929 | n.a.
Packing&Shipping |  | 0.9148443483308709 | 1.146424874212493 | 1.001593423343865
n.a.: process is not in place
there can me more than one print on a product! E.g. You have a print on the front and on on the back
print statistic 2011 |  | IRE | FRA | MEX
 | DD prints | 246433 | 156782 | 461546
 | DT/DTO prints | 44726 | 102922 | 1321
 | FF prints | 424096 | 1423961 | 650315
 | [NAME]/Button prints | 6325 | 20902 | 4176
 | overall shipped products | 401377 | 931933 | 763388
 | prints/product
Task 2:
2 facilities have to share the incoming orders (products) ( =RFP)
we distinguish between:
products RFP ( ready for production), orders(products) from customer placed and paid but not in production
products IP (in production) , orders (products) already in production in one of the facilities.
Goal ist that facility 1 produces 30% of the volume, facility 2 70% of the volume
Facility 2 wants to take more products in production. (take products from RFP volume to IP volume)
How many products can they take , to have not more than 70% of all products (RFP and IP)?
Please show in Excel how to get the result
The actual status is: |  |  | facility 1 | facility 2
 |  | IP | 2456 | 4280
 |  |  | RFP total for all facilities | 2014
Spreadsheet: 835718d1688747821-if-between-this-value-range-then-this-or-these-overlapping-then-results-system-calculations
Sheet: REFERENCE

SYSTEM | OPERATING FLOW RATE RANGE (L/hr) | or | OPERATING FLOW RATE RANGE- MINIMUM (L/hr) | OPERATING FLOW RATE RANGE- MAXIMUM (L/hr)
Resolute Flow Drive Single Use 10 | 10 - 500 |  | 10 | 500
Resolute Flow Drive Single Use 20 | 20 - 900 |  | 20 | 900
Resolute Flow Drive Multi Use 10 | 2 - 150 |  | 2 | 150
Resolute Flow Drive Multi Use 25 | 20 - 500 |  | 20 | 500
Resolute Flow Drive Multi Use 50 | 30 - 1200 |  | 30 | 1200
Resolute Flow Drive Multi Use 100 | 60 - 2500 |  | 60 | 2500
Resolute Flow Drive Multi Use 300 | 150 - 5000 |  | 150 | 5000
Resolute [NAME] | 5 - 150 |  | 5 | 150
Spreadsheet: 697753d1601507149-date-formula-validation-to-true-false-mds-professional-services-dashboard-30sep2020-v2
Sheet: Control

 |  | INSTRUCTIONS
 |  |  | General
 |  |  | ▪ Select your Point of view from the drop-down box on the dashboard page
 |  |  | ▪ Refresh the data to retrieve from the database
 |  |  | ▪ That's it!
 |  |  | Beware
 |  |  | Do not overwrite the formulas in the Calculation Tab.
 |  |  | Keep protection on for the [NAME] tab to make sure nothing is unintentionally shifted.
 |  |  | Feel free to remove sheet protection. Go to Review and click "unprotect sheet" - there is no password.
 |  | Links
 |  |  | [NAME] |  | Presentation of results
 |  |  | Calculation |  | Raw preparation for [NAME]
 |  |  | Raw Data |  | Raw data, retrieved directly from Oracle database
 |  |  | Additional resources |  | View complete file on intranet (example for internet link)
 |  | Version Control
 |  |  | 2017-08-08 00:00:00
 |  |  | ▪ Added additional calculations for % columns
 |  |  | ▪ changed KPI sorting to be based on % budget variance instead of full values
 |  |  | 2017-09-10 00:00:00
 |  |  | ▪ Included protection
Spreadsheet: sally_beck__33697__Metrics 0609
Sheet: Upstream Assets

E N R O N   N O R T H   A M E R I C A - H O T  L I S T  M E T R I C S |  |  |  |  |  |  |  |  |  |  |  |  | Team: | ENA Upstream Assets
Results based on Activity through June 9, 2000 |  |  |  |  |  |  |  |  |  |  |  |  | Week | 10
 |  | Weekly Summary - 2Q00 through 1Q01
 |  | # of Transactions
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13
 |  | 2000-04-07 00:00:00 | 2000-04-14 00:00:00 | 2000-04-21 00:00:00 | 2000-04-28 00:00:00 | 2000-05-05 00:00:00 | 2000-05-12 00:00:00 | 2000-05-19 00:00:00 | 2000-05-26 00:00:00 | 2000-06-02 00:00:00 | 2000-06-09 00:00:00 | 2000-06-16 00:00:00 | 2000-06-23 00:00:00 | 2000-06-30 00:00:00
Postings Rollforward:
Beginning |  | 0
+ Entrances |  |  | 20 |  | 0 | 4 | 79 | 9 | 8 | 103 | 49
- Exits |  | 0 | 8 | 1 | 0 | 8 | 2 | 1 | 1 | 3 | 11
- Executions |  | 0 | 28 | 0 | 0 | 10 | 4 | 6 | 10 | 32 | 7
Ending
 | Dollar Value of Transactions
 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |  | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Average
Postings Rollforward:
Beginning |  | 100.5
+ Entrances |  | 0 | 14.3 | 1
- Exits |  | 0 | 0 | 0
+/- [NAME] |  | 0 | 0 | -13
- Executions |  | 0 | 0 | 0
Ending
Average Deal Size
 |  |  |  |  |  |  |  | Forward Quarters
 | Actual |  |  | Current Quarter |  | Per |  |  |  |  |  |  |  | Total Year
 | 1Q00 |  |  | 2Q00 |  | Hot List |  | 3Q00 |  |  | 4Q00 |  |  | 2000 |  |  | 1Q01
 | # | $ |  | # | $ |  |  | # | $ |  | # | $ |  | # | $ |  | # | $
Executions | 17 | 7.1 |  | 97 | 5.85 | 5.85 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | 0 | 0
DPR/MPR |  | 16 |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0
Postings | 0 | 0 |  | 24 | 4.275 |  |  | 149 | 37.524 |  | 46 | 20.214 |  |  |  |  | 6 | 5.381
Identified Margin
Budget |  | 30.3 |  |  | 30.9 |  |  |  | 32.2 |  |  | 33 |  |  |  |  |  | 40.3
$ Coverage
$ millions
Spreadsheet: 40074d1238412507-excel-2007-changing-the-value-of-a-cell-via-a-formula-test-book
Sheet: Leisure & Media

Leisure & Media
 | Conserviative | Bottom 25% | Top 25% | Todays Extremes in Color |  |  | Current
Commodity | Target: Buy | Target: Buy | Target: Sell | Low | High | Range | Current Price | Current Low | Current High
Ballooning Company | 5 | 6 | 8 | 5 | 10
Night Club | 9 | 10 | 14 | 8 | 16
Airship Company | 19 | 21 | 29 | 17 | 33
TV Show | 24 | 26 | 33 | 23 | 37
Broadcasting Satellite | 29 | 31 | 38 | 28 | 42
Newspaper Publisher |  |  |  |  |  |  | 57
Health Club Chain | 66 | 72 | 96 | 60 | 108
Airline | 79 | 83 | 97 | 76 | 104
Amusement Park | 70 | 79 | 115 | 61 | 133
Film Production Company | 87 | 104 | 174 | 70 | 209
Record Label | 124 | 137 | 189 | 111 | 215
Magazine Publisher | 104 | 117 | 167 | 92 | 193
Horse Racing Track | 202 | 225 | 315 | 180 | 360
Casino | 352 | 399 | 585 | 306 | 678
TV Station | 426 | 452 | 557 | 400 | 610
Soccer Team | 891 | 1068 | 1777 | 714 | 2132
Cricket Team |  |  |  |  |  |  | 704
Ice Hockey Team | 524 | 563 | 721 | 485 | 800
Baseball Team | 867 | 938 | 1220 | 797 | 1362
Basketball Team | 1021 | 1134 | 1584 | 909 | 1810
Movie Theatre Chain | 462 | 578 | 1044 | 346 | 1277
American Football Team | 1375 | 1508 | 2040 | 1242 | 2306
Spreadsheet: 3a1e615c-5bf7-49c9-95d4-b5f3cac76b46
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
 | Time Series Workbook
 | 5368.0 International Trade in Goods and Services, Australia
 | TABLE 2. GOODS AND SERVICES, Summary: Original, Current prices
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Balance on goods and services ; |  |  | Original | A2717903C | 1971-07-01 00:00:00 | 2012-10-01 00:00:00 | 496 | $ Millions | FLOW | Month | 1
Credits, Total goods and services ; |  |  | Original | A2717883F | 1971-07-01 00:00:00 | 2012-10-01 00:00:00 | 496 | $ Millions | FLOW | Month | 1
Credits, Total goods ; |  |  | Original | A2717881A | 1971-07-01 00:00:00 | 2012-10-01 00:00:00 | 496 | $ Millions | FLOW | Month | 1
Credits, Rural goods ; |  |  | Original | A2717884J | 1971-07-01 00:00:00 | 2012-10-01 00:00:00 | 496 | $ Millions | FLOW | Month | 1
Credits, Non-rural goods ; |  |  | Original | A2717931L | 1971-07-01 00:00:00 | 2012-10-01 00:00:00 | 496 | $ Millions | FLOW | Month | 1
Credits, Net exports of goods under merchanting ; |  |  | Original | A2718034F | 1971-07-01 00:00:00 | 2012-10-01 00:00:00 | 496 | $ Millions | FLOW | Month | 1
Credits, Non-monetary gold ; |  |  | Original | A2718037L | 1971-07-01 00:00:00 | 2012-10-01 00:00:00 | 496 | $ Millions | FLOW | Month | 1
Credits, Total services ; |  |  | Original | A2718332C | 1971-07-01 00:00:00 | 2012-10-01 00:00:00 | 496 | $ Millions | FLOW | Month | 1
Debits, Total goods and services ; |  |  | Original | A2717891F | 1971-07-01 00:00:00 | 2012-10-01 00:00:00 | 496 | $ Millions | FLOW | Month | 1
Debits, Total goods ; |  |  | Original | A2718054R | 1971-07-01 00:00:00 | 2012-10-01 00:00:00 | 496 | $ Millions | FLOW | Month | 1
Debits, Consumption goods ; |  |  | Original | A2718056V | 1971-07-01 00:00:00 | 2012-10-01 00:00:00 | 496 | $ Millions | FLOW | Month | 1
Debits, Capital goods ; |  |  | Original | A2718126R | 1971-07-01 00:00:00 | 2012-10-01 00:00:00 | 496 | $ Millions | FLOW | Month | 1
Debits, Intermediate and other merchandise goods ; |  |  | Original | A2718182J | 1971-07-01 00:00:00 | 2012-10-01 00:00:00 | 496 | $ Millions | FLOW | Month | 1
Debits, Non-monetary gold ; |  |  | Original | A2718320V | 1971-07-01 00:00:00 | 2012-10-01 00:00:00 | 496 | $ Millions | FLOW | Month | 1
Debits, Total services ; |  |  | Original | A2718454A | 1971-07-01 00:00:00 | 2012-10-01 00:00:00 | 496 | $ Millions | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 299216d1393039873-replace-function-with-conditions-help
Sheet: Sheet1

 | 15.5 | 9
 | 17 | -1
7 |  |  | -7
7.5 |  |  | -10
 | 14.5 | 2
 | 14.5 | 0
 | 11 | -5
3.5 |  |  | -4
 | 5 | 2
 | 5.5 | 5
 | 1.5 | -5
 | 11.5 | 0
13.5 |  |  | -8
3.5 |  |  | -5
 | 14.5 | 3
 | 14.5 | -4
Spreadsheet: 89887d1289622252-help-building-a-simulation-based-on-probability-one11-monte-carlo-simulation-of-game
Sheet: Sheet1

 |  | 1
Day | [NAME] | Game Result | [NAME] | Bonus | Game Result | [NAME] | Game Result | [NAME] | Game Result | [NAME] | Game Result | [NAME] | Game Result | [NAME] | Net Coins | Min | [NAME] | Avg
1
Spreadsheet: 384392d1426863610-count-duplicate-occurrences-based-on-another-column-testing
Sheet: Sheet1

[NAME] | L2
[NAME] | L2 |  | Dual L | 2
[NAME] | L1
[NAME] | L2
[NAME] | L3
[NAME] | L2
[NAME] | L3
[NAME] | L2
[NAME] | L2
[NAME] | L1
Spreadsheet: 268550d1380683728-if-drop-down-menu-equals-one-of-5-lists-on-a-certain-day-of-the-week-then-example-attendance-2-1-
Sheet: Sheet2

F1 |  |  |  | F2
BAF |  |  |  | ALK
COB |  |  |  | BAD
DEC |  |  |  | BOM
EIM |  |  |  | FRC
HNG |  |  |  | HEN
KAK |  |  |  | KIV
KEK |  |  |  | LEC
KEK |  |  |  | MIB
LAM |  |  |  | MIA
LOC |  |  |  | NOC
MCC |  |  |  | SCS
MUJ |  |  |  | VAL
OFS |  |  |  | VAA
POR |  |  |  | VL
SMM |  |  |  | VA
WGA
 |  |  |  | JOK
DEA |  |  |  | MAB
MCA |  |  |  | MUJ
MEJ
MIL
M1 |  |  |  | M2 |  | W
LIM |  |  |  | MIK |  | KLS
HAR |  |  |  | KOK
KLS |  |  |  | MAC
DOR WK
M1
M2
W
F1
F2
Spreadsheet: 680762d1591187103-min-if-array-earlydate
Sheet: Sheet1

Name | Date | Earliest Date
Adam | 2020-02-02 00:00:00
[NAME] | 2020-03-03 00:00:00
[NAME] | 2018-01-19 00:00:00
[NAME] | 2020-02-04 00:00:00
[NAME] | 2019-03-03 00:00:00
[NAME] | 2019-01-05 00:00:00
Adam | 2020-01-31 00:00:00
[NAME] | 2020-04-04 00:00:00
Spreadsheet: 37c38acd-42de-4a8e-abad-c9716cc15bc1
Sheet: AltaMed

AltaMed Medical Group
1155 West Central Ave., Suites 104-107
Santa Ana, CA  92707
Toll Free Line: (877) 462-2582
Main Phone Line: (714) 500-0333
Main Fax: (714) 263-1548
Name and Title | Role | Contact Email | Contact Phone Number | Fax Number
[NAME], Clinic Administrator | Manage clinic operations for Family Planning/HIV Services Clinic and [NAME] Part D Program | [EMAIL] | 7145000333 | 7142631548
[NAME], Linkage to Care Coordinator/Case Manager | Link newly identified HIV+ patients into medical and dental care. Case manager for the [NAME] White Part D Program. | [EMAIL] | (714)500-0350 | (714) 263-1548
[NAME], Promotora II | Client advocacy | [EMAIL] | 7145000299 | 7142631548
Spreadsheet: 808449d1670472532-combine-2-sheets-grade33
Sheet: 5 BEST AND WEK STUDENTS

E. FIVE BEST STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D
1
2
3
4
5
F. FIVE WEAK STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D
1
2
3
4
5
Spreadsheet: 20fbd13f-20d2-434e-9113-2e1ea1c1c249
Sheet: Sheet1

Form for Providing 1999 Year-End Tax Reporting Information: Cabot Industrial Trust | 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
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | Income
 | Allocations |  |  |  |  |  |  |  | Cash | Taxable |  |  |  |  | Unrecaptured |  | Exempt- | Alternative | Foreign
 | F=Final | Security |  | Ticker | Issuer | Declaration | Record | Payable | Distribution | Ordinary | Short-term | Return of | 28 Percent | 20 Percent | Section 1250 | Section 1202 | Interest | Minimum | Tax
Status | E=Estimated | Description | CUSIP | Symbol | Class. | Date | Date | Date | Per Share | Dividend | Capital  Gain | Capital | Rate  Gain | Rate Gain | Gain | Gain | Dividend | Tax Percent | Gross Up
 |  | Common | 127072106 | CTR | 1 | n.a. | 1999-04-09 00:00:00 | 1999-04-30 00:00:00 | 0.34 | 0.34
 |  | Common | 127072106 | CTR | 1 | n.a. | 1999-07-09 00:00:00 | 1999-07-29 00:00:00 | 0.34 | 0.34
 |  | Common | 127072106 | CTR | 1 | n.a. | 1999-10-08 00:00:00 | 1999-10-27 00:00:00 | 0.34 | 0.34
 |  | Common | 127072106 | CTR | 1 | n.a. | 1999-12-31 00:00:00 | 2000-01-19 00:00:00 | 0.19 | 0.19
S |  | Common | 127072106 | CTR | 1 | n.a. | 1999-12-31 00:00:00 | 2000-01-19 00:00:00 | 0.15 | 0.15
 | F | Totals for 1999 |  |  |  |  |  |  | 1.21 | 1.21
Spreadsheet: 74011d1274624711-highlight-a-row-when-a-particular-word-is-written-in-a-cell-excel
Sheet: Sheet1

Item | Salesman | Status |  | What I want is to high light a particular row when the status of that row is changed to Invoiced.
1 | [NAME] | Sold
2 | [NAME] | Sold |  | Such as below.
3 | [NAME] | Sold
4 | [NAME] | Sold |  | Thanks
5 | [NAME] | Sold
6 | [NAME] | Sold
7 | [NAME] | Sold
Item | Salesman | Status
1 | [NAME] | Sold
2 | [NAME] | Invoiced
3 | [NAME] | Sold
4 | [NAME] | Sold
5 | [NAME] | Sold
6 | [NAME] | Sold
7 | [NAME] | Sold
Spreadsheet: 125470d1319047754-excel-2007-inaccurate-stacked-bar-charts-ms-excel-2007-computing-incorrect-bar-charts
Sheet: Bar charts not working

 | Inaccurate stacked bar charts (Closed % between 99% and 84% are incorrect). Help.
 | Open |  | Open % |  |  |  | OK!
 | Closed | 100 | Closed %
 | Open |  | Open % |  |  |  | These Bar Charts are wrong! Why?
 | Closed | 99 | Closed %
 | Open |  | Open %
 | Closed | 95 | Closed %
 | Open |  | Open %
 | Closed | 91 | Closed %
 | Open |  | Open %
 | Closed | 89 | Closed %
 | Open |  | Open %
 | Closed | 87 | Closed %
 | Open |  | Open %
 | Closed | 84 | Closed %
 | Open |  | Open % |  |  |  | OK!
 | Closed | 83 | Closed %
 | Open |  | Open %
 | Closed | 79 | Closed %
Spreadsheet: kevin_presto__19791__proposed Enron transaction 7-2-01
Sheet: Palo

Schedule of Palo Transactions
 | DETM | EPMC |  | 7/09/01 to
 | MWs | MWs |  | 2001-09-30 00:00:00 |  | Q3 '02 |  | Q3 '03 |  | Q3 '04
2001-07-09 00:00:00 | -250
 | -250
 | -250
 | -250
 | -200
 | -200
 | -200
 | -200
 | -150
 | -150
 | -100
 | -100
 | -100
 | -100
2001-07-10 00:00:00
2001-07-11 00:00:00
2001-07-12 00:00:00
Spreadsheet: 35216d1232747034-percentage-question-weekly-qc-sheet
Sheet: Sheet1

 | Weekly QC Sheet |  |  |  |  |  |  | McLaughlin Communications
 |  |  |  |  |  |  |  | Scranton Pa.
 | Monday
Technician
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
Totals: |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 111443d1307815563-find-text-in-string-return-row-volunteer
Sheet: Registrations

Timestamp | Name | [NAME] | Cell Phone Number | Sunday -Volunteer Opportunities | Monday - Volunteer Opportunities | Tuesday - Volunteer Opportunities | Wednesday - Volunteer Opportunities | Thursday - Volunteer Opportunities | Friday - Volunteer Opportunities | Please indicate your t-shirt size:
2011-05-19 10:54:20 | [NAME] doe | [EMAIL] | [PHONE] | Conference Decorations:  Pick up conference decorations from Mulhall's Nursery (9:00 am), Pre-Conference Tour Return:  [NAME] tour participants, answer questions (5:30 pm - 6:30 pm), Registration:  Assemble registration packets (10:00 am - 3:00 pm) | Registration:  Hand out registration information, answer questions (10:00 am - 2:00 pm) | Seminar on Wheels:  Tour guides (10:00 am - 5:00 pm), [NAME]:  Help load buses for return from zoo (9:00 pm) | Registration:  Hand out registration information, answer questions (11:00 am - 3:00 pm) | Registration:  Hand out registration information, answer questions (11:00 am - 3:00 pm) | Breakfast:  Take tickets at door for Friday breakfast (7:00 am - 8:00 am) | XLarge
2011-05-19 10:57:54 | [NAME] | [EMAIL] | [PHONE] |  |  | Seminar on Wheels:  Coordinate food and supplies for tours for pickup by guides (9:00 am - 10:00 am), Seminar on Wheels:  [NAME]-hold signs for tour buses (9:15 am - 10:45 am), Seminar on Wheels:  Tour guides (10:00 am - 5:00 pm), Seminar on Wheels:  Tour guides (10:00 am - 5:00 pm) |  |  |  | XXLarge
2011-05-19 11:04:47 | [NAME] | [EMAIL] | [PHONE] |  |  | Seminar on Wheels:  [NAME]-hold signs for tour buses (9:15 am - 10:45 am), Seminar on Wheels:  Tour guides (10:00 am - 5:00 pm) |  |  |  | Medium