tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 883724d1732376394-conditional-format-cell-based-on-another-cell-conditional-format1
Sheet: Sheet1

 |  |  |  |  |  |  | 30.01516766236695 | 69.98483233763305
 |  |  |  |  |  |  | 63.76706545354497 | 36.23293454645503 |  | The condition is :
 |  |  |  |  |  |  | 48.36555257948061 | 51.63444742051939
 |  |  |  |  |  |  | 50 | 50 |  | H > I … color green
 |  |  |  |  |  |  | 48.64328702072542 | 51.35671297927458
 |  |  |  |  |  |  | 30.33107482498724 | 69.66892517501276 |  | Why some cell values condition not displaying eventhough
 |  |  |  |  |  |  | 60.20811831911846 | 39.79188168088154 |  | for example H19 > I19 but not highlighted the H19 cell
 |  |  |  |  |  |  | 50.8092631815711 | 49.1907368184289
 |  |  |  |  |  |  | 50 | 50
 |  |  |  |  |  |  | 50.34814707401274 | 49.65185292598726
 |  |  |  |  |  |  | 31.89647353335994 | 68.10352646664006
 |  |  |  |  |  |  | 57.40069758477724 | 42.5993024152228
 |  |  |  |  |  |  | 48.97347293787095 | 51.02652706212905
 |  |  |  |  |  |  | 50 | 50
 |  |  |  |  |  |  | 50.63431491965345 | 49.36568508034655
 |  |  |  |  |  |  | 31.86894236251256 | 68.13105763748744
 |  |  |  |  |  |  | 55.96335918844405 | 44.03664081155595
 |  |  |  |  |  |  | 51.75625637078488 | 48.24374362921512
 |  |  |  |  |  |  | 50 | 50
Spreadsheet: craig_dean__4388__Congestion Management 2001 2CSC3ZONES
Sheet: Readme

Average Weighted Shift Factor Calculation
Exceptions implemented:
1 | Bosque Generation set to North2001 zone
2 | LCRA loads set to South2001 zone
3 | Self serve loads (TXU and Reliant/HLP) final values were calculated in the "SelfServeLoads"  sheet.
 | - Effective Pl were entered as Pl in the "2CSC3ZONES_01sum1" sheet.
 | - Effective Pgen were entered as Pmax in the "2CSC3ZONES_01sum1" sheet.
 |  |  |  |  |  | SUM{[Load(j) + GenOff(j) + Pmax(j)]*SHF1(j)} |  |  |  |  | j= bus number
 |  | Average Weighted Shift Factor 1= |  |  |  | ----------------------------------------------------------------
 |  |  |  |  |  | SUM(Load + GenOff + Pmax)
 |  |  |  |  |  | SUM{[Load(j) + GenOff(j) + Pmax(j)]*SHF2(j)} |  |  |  |  | j= bus number
 |  | Average Weighted Shift Factor 2= |  |  |  | ----------------------------------------------------------------
 |  |  |  |  |  | SUM(Load + GenOff + Pmax)
Spreadsheet: 140047d1328609601-excel-2007-compare-cells-within-several-groups-target-to-target-similarity-5
Sheet: Oil and gas deals 10 years

Acquiror's code | Target Industry code | Target-to-target similarity
2003030 | 1311 | 4
2003030 | 1311 | 4
2003030 | 4924 | 0
2003030 | 1311 | 4
2003030 | 1382 | 2
2023748 | 4911 | 2
2023748 | 5172 | 1
2023748 | 1311 | 4
2023748 | 4924 | 2
2023748 | 1382 | 2
2023748 | 1311 | 4
2023748 | 4931 | 2
2023748 | 5541 | 1
2023748 | 8731 | 0
2024763 | 1311 | 4
2024763 | 1311 | 4
Spreadsheet: 32308d1228410325-removing-spaces-and-seperating-data-seperating_data
Sheet: Sheet1

Results that I want (Row 2 only is correct) |  |  |  |  |  |  |  | Data that I recieve
1 | 2 | 3 | 4 | 5 |  |  |  | 1 2 3 4 5 | 2 3 4 5 | 3 4 5 | 4 5 | 5
1 | 2 | 3 | 4  5 |  | 5 |  |  | 1 2 3 4  5 | 2 3 4  5 | 3 4  5 | 4  5 | 5 | 5
1 | 2 | 3  4 5 |  | 4 | 5 |  |  | 1 2 3  4 5 | 2 3  4 5 | 3  4 5 | 4 5 | 4 5 | 5
1  2 3  4 5 |  | 2 | 3  4 5 |  | 4 | 5 |  | 1  2 3  4 5 | 2 3  4 5 | 2 3  4 5 | 3  4 5 | 4 5 | 4 5 | 5
Spreadsheet: 781278d1653129365-obtain-the-numbers-of-a-list-depending-the-name-distribui-o-de-pe-as
Sheet: MARIA CARMO

 |  |  | MARIA DO CARMO
 |  |  | Nª PEÇA | DESCRIÇÃO | VALOR
Spreadsheet: tracy_geaccone__40260__C0366-112458
Sheet: Dept_100152

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
SHIPPING/RECEIVING - Dept. 100152
June, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 112458
2001-04-04 00:00:00 | 824572035290 |  | [NAME] | HANDLING FEE | 1 | 1.25 | /EACH | 1.25
 |  |  |  | FEDERAL EXPRESS | 1 | 5.06 | /DELV | 5.06
 |  |  |  |  |  |  | Ticket Total |  | 6.31
2001-05-10 00:00:00 | CCT069273 |  | (713) 345-5080 x____ BOBB | RIVER OAKS CHRYSLER JEEP | 1 | 6.3 | /DELV | 6.3
 |  |  |  |  |  |  | Ticket Total |  | 6.3
2001-05-16 00:00:00 | CCT068065 |  | (713) 853-3597 x____ [NAME] | PRESTIGE MORT GROUP | 1 | 15.75 | /DELV | 15.75
 |  |  |  |  |  |  | Ticket Total |  | 15.75
2001-05-22 00:00:00 | CCT068350 |  | (713) 853-1878 x____ SUSA | PAINE WEBBER | 1 | 12.6 | /DELV | 12.6
 |  |  |  |  |  |  | Ticket Total |  | 12.6
 |  |  |  |  |  |  | Total for R/C: 112458 |  | 40.96
 |  |  |  |  |  |  | Total for Dept_100152 |  | 40.96
Spreadsheet: 681056d1591330581-count-based-on-join-date-performance-analysis
Sheet: Sheet1

Policy Holder ID | Policy [NAME] | Sponsor ID | Sponsor Name | Join Date ID
5002935 | [NAME] | 13945193 | [NAME] | 2020-04-10 00:00:00
13945193 | [NAME] | 10819867 | [NAME] | 2020-02-12 00:00:00
5011059 | [NAME] | 7878917 | Maureen Shing Cheh [NAME] | 2020-02-06 00:00:00
10819867 | [NAME] | 5016999 | [NAME] ng | 2020-02-12 00:00:00
5014891 | Sze Sze Geow | 10819867 | [NAME] | 2020-03-02 00:00:00
7878917 | Maureen Shing Cheh [NAME] | 12383152 | Sing Fang Ling | 2020-01-10 00:00:00
5016999 | [NAME] ng | 13945193 | [NAME] | 2020-04-17 00:00:00
5029795 | Chee [NAME] | 12383152 | Sing Fang Ling | 2020-05-29 00:00:00
5031529 | [NAME] | 5002935 | [NAME] | 2020-01-17 00:00:00
5032695 | [NAME] | 7878917 | Maureen Shing Cheh [NAME] | 2020-05-29 00:00:00
5035734 | [NAME] | 5014891 | Sze Sze Geow | 2020-02-07 00:00:00
5037605 | [NAME] | 12383152 | Sing Fang Ling | 2020-04-17 00:00:00
12383152 | Sing Fang Ling | 5046545 | Soon [NAME] | 2020-02-27 00:00:00
5037857 | [NAME]  Yet [NAME] | 5038081 | [NAME] | 2020-03-06 00:00:00
5041241 | [NAME] | 10819867 | [NAME] | 2020-05-04 00:00:00
5042455 | [NAME] | 5035734 | [NAME] | 2020-04-25 00:00:00
5046545 | Soon [NAME] | 13945193 | [NAME] | 2020-01-04 00:00:00
Spreadsheet: 778537d1651146136-format-cells-if-conditions-are-met-from-a-range-of-cells-conditional-formula
Sheet: Sheet1

 |  | Range to be Highlighted any colour |  |  |  |  | if |  | Condition | If value is within this range
 |  | 314 |  |  |  |  |  |  | 222 |  | Condition is range of cells from J5 to J22
 |  | 869 |  |  |  |  |  |  | 225
 |  | 182 |  |  |  |  |  |  | 252
 |  | 295 |  |  |  |  |  |  | 555
 |  | 425 |  |  |  |  |  |  | 552
 |  | 647 |  |  |  |  |  |  | 525
 |  | 758 |  |  |  |  |  |  | 955 |  |  | How to write conditional formula if the condition is not a single cell but
 |  | 959 |  |  |  |  |  |  | 995 |  |  | a range of cells containing values
 |  | 536 |  |  |  |  |  |  | 959 |  |  | J5 to J22
 |  | 374 |  |  |  |  |  |  | 599
 |  | 839 |  |  |  |  |  |  | 595 |  |  | IF C5 to C22 is any of J5 to J22 then highlight the cell in range C5 to C22
 |  | 225 |  |  |  |  |  |  | 255
 |  | 263 |  |  |  |  |  |  | 295
 |  | 485 |  |  |  |  |  |  | 259
 |  | 617 |  |  |  |  |  |  | 925
 |  | 222 |  |  |  |  |  |  | 952
 |  | 941 |  |  |  |  |  |  | 529
 |  | 596 |  |  |  |  |  |  | 592
 |  | If formula works the following cells in column C will be highlighted
 |  | C8,  C12,  C16  &  C20
Spreadsheet: 1a64f3f2-dcaf-4086-8acb-5367dd26ed7c
Sheet: Sheet1

Christmas Classic
Last Name | First Name | Bass 1 | [NAME] | Bass 3 | Total Weight | Average Weight
[NAME] | [NAME] | 5 | 6.2 | 2
[NAME] | Leisha | 2 | 5 | 5
[NAME] | [NAME] | 4 | 2 | 5
Cooper | Courtnie | 6 | 2 | 8
Evans | Ricky | 4 | 2 | 8
Forman | Jade | 5.5 | 1 | 4.5
[NAME] | Jasmine | 8.5 | 1 | 9.5
Holden | [NAME] | 6 | 1 | 9.5
Hopper | Minn | 9 | 1.5 | 4
Moore | [NAME] | 4 | 2.5 | 3
Pitman | Julie | 4 | 3.5 | 4
Shelby | Tasha | 3 | 2.5 | 2
[NAME] | [NAME] | 7 | 4 | 2
Trussell | Fredy | 2 | 6 | 2
Wade | [NAME] | 3 | 6 | 5
[NAME] | Brooke | 3 | 2 | 4
Number of Participants
Revenue Received
Spreadsheet: 889249d1739981207-xlookup-dates-not-finding-each-other-keep-getting-value-excel-forum-upload
Sheet: Sheet1

Changes to Lots | [NAME] | YEAR START | New Accept Goal if Changes = Yes | Lots Avail 4 Planning | 2022-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LIST
No | 50 | 2025-12-31 00:00:00 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-12-31 00:00:00
 |  |  |  |  |  |  | C2 = I2
Spreadsheet: 678358d1589838948-how-to-enlist-specific-information-in-a-tab-referring-to-another-tab-how-to-2
Sheet: Blad1

Situation tab 1
Name |  |  | Finish | nWC | nWC | WC | Tasman | nWC | WC
Ascari | Alberto |  |  | 1 | - | 8 | - | 3 | 2
Farina | [NAME] |  |  | 6 | 5 | 16 | - | 1 | 1
Heath | [NAME] |  |  | 4 | 12 | - | 6 | 8 | -
Watson | [NAME] |  |  | - | 7 | - | 3 | 4 | 9
 | (WC = World Championship)
Disired situation tab 2
Name |  |  | Finish | WC | WC | <-- Filter out these from line 2 automatically
Ascari | Alberto |  |  | 8 | 2
Farina | [NAME] |  |  | 16 | 1
Watson | [NAME] |  |  | - | 9
Filter out these from A3:B6 --> |  | This column is hidden, because it is only used for the search ---> |  | Filter out these from C3:H6 -->
Spreadsheet: 127301d1320273556-equation-to-display-combined-results-book1
Sheet: Sheet1

1st Week | 2nd Week | 3rd Week | 4th Week | 5th Week | DIFF (1-5W)
36508 | 37403 | 37633 | 37723 | 37777 | 1269 (3.48%)
7763 | 7853 | 7877 | 7890 | 7897 | 134 (1.73%)
7883 | 7977 | 8006 | 8021 | 8031 | 148 (1.88%)
Spreadsheet: 10688e21-50c7-42b3-9f2f-b7d2c537a667
Sheet: B

 | COURSES IN RED ARE GENERAL EDUCATION COURSES FOR FALL 2012 |  | PURPLE  J-TERM  GREEN BOTH FALL & J-TERM
Biology | AOK designation | CAR designation | comment
BIOL 107 | Natural & Mathematical Sciences-Nat Sci w Lab |  | renumbered BIOL 182
BIOL 121 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 122 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 124 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 125 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 126 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 127 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 129 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 133 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 151 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 155 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 175 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 181 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 182 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 309 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 315 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 333 | Natural & Mathematical Sciences-Nat Sci w Lab | Experiential-Travel
BIOL 335 | Natural & Mathematical Sciences-Nat Sci w Lab | Experiential-Travel
BIOL 350 |  | Computing
BIOL 381 | Natural & Mathematical Sciences-Nat Sci w Lab |  | Flies, Fishes & Foods 2009-2010
BIOL381 | Natural & Mathematical Sciences-Nat Sci w Lab |  | Evolution & Natural Selection, Fall 2011
BIOL 400 |  | Experiential-Research, Capstone
BIOL 450 |  | Experiential-Research
BIOL 487-488 |  | Experiential-Research, Capstone
BIOL 491-492 |  | Experiential-Research
BIOL 496-498 |  | Experiential-Research, Capstone
Black Studies | AOK designation | CAR designation
BLST 160 | Social Sciences-Psychology | Non-Western, Experiential-Travel | Cross-listed with PSYC 160
BLST 201 | Social Sciences-Sociology |  | Cross-listed with SOCI 225
BLST 381 |  | Experiential-Travel | Summer 08, Cross-listed with HIST 381
BLST 381 |  | Experiential-Travel | J-Term 09,10;12  Cross-listed with HIST 381
Business | AOK designation | CAR designation
BUSN 213 | Social Sciences-Economics/Business
BUSN 336 |  | Computing
BUSN 425 |  | Capstone | Accounting & Economics/Business major
BUSN 450-451 |  | Experiential-Internship, Capstone | Economics/Business major
BUSN 452 |  | Capstone; Experiential-Internship | Accounting major
BUSN 455 |  | Capstone; Experiential-Field Studies
BUSN 481 |  | Experiential-Travel | section 01, J-Term 2006
BUSN 481 |  | Experiential-Research | Spring 2009
BUSN 491-492 |  | Capstone; Experiential-Research | Accounting & Economics/Business major
BUSN 496-498 |  | Capstone; Experiential-Research | Accounting & Economics/Business major
Spreadsheet: 168900d1342625952-index-and-match-book5-index-and-match
Sheet: Master Tracker III

 |  | Indicates Colleagues Offered Roles to Other Divisions
 |  | Indicates Resignations
Division | Heritage File Number | Function | CoE Transfers | First Name | Last Name | Full Name | FTE | VR Yes / No | Current Grade | Colleague Scope Area | Is Interested In Vr | Current Job Title | Work City | Work Building | Current Line Manager Name | Number of Preferences | Selected Job | Selected Division | First Preference Job Number | First Preference Job Grade | First Preference Job Title | First Preference Job BU | Second Preference Job Number | Second Preference Job Grade | Second Preference Job Title | Second Preference Job BU | Third Preference Job Number | Third Preference Job Grade | Third Preference Job Title | Third Preference Job BU | Other Selections | Choose From Drop Down 1st Preference | Choose From Drop Down 2nd Preference | Choose From Drop Down 3rd Preference | Choose From Drop Down Other Selection | Outstanding | Resigned / Leaver / Transfer | [NAME] Yes / No | Choose From Drop Down Reason For Non-Preference | Comments / Notes
Group Finance/CoE |  |  |  | [NAME] | Bond |  | 1 |  |  |  |  |  |  |  |  |  | GFO007918 | Group Operations
Group Finance/CoE |  |  |  | [NAME] | Moore |  | 1 |  |  |  |  |  |  |  |  |  | GFO008296 | Group Finance
Group Finance/CoE |  |  |  | Sean Connery | Selby |  | 1 |  |  |  |  |  |  |  |  |  | GFO008358 | Retail
Group Finance/CoE |  |  |  | Timothy | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  | [NAME] | Group Operations
Spreadsheet: 461abcc2-7449-470f-b23d-be767e713879
Sheet: Tables

Rates
MFP B&W | 0.0207
MFP Color | 0.087
Printer B&W | 0.0262
Printer Color | 0.118
 |  |  | Devices | Type
 |  |  | AF MP301SP | MFP
 |  |  | AF MP4002 | MFP
 |  |  | AF MP6001 | MFP
 |  |  | AF MPC2051 | MFP
 |  |  | AF MPC3502 | MFP
 |  |  | AF MPC4502 | MFP
 |  |  | AF MPC6501 | MFP
 |  |  | AF SP4310N | PTR
 |  |  | AF SPC242DN | PTR
Spreadsheet: 153194d1335799565-how-to-get-the-total-number-of-days-of-each-person-per-week-number-days-person-week_jpr73
Sheet: PT

 |  |  |  |  |  |  |  |  | How to get the total number of days of each person per week?
Days | Date
Person | 02/01/2012 - 08/01/2012 | 09/01/2012 - 15/01/2012 | 16/01/2012 - 22/01/2012 | 23/01/2012 - 28/01/2012 | Total général
[NAME] | 21 | 10 | 4.5 | 5.5 | 41
[NAME] | 18 | 4 | 2 | 6 | 30
[NAME] | 13 | 2.5 | 5.5 | 2 | 23
[NAME] | 14 | 3.5 | 14.5 | 1.5 | 33.5
Rachel | 17.5 | 2.5 | 9.5 | 3.5 | 33
Phoebe | 11 | 9 | 4.5 | 1 | 25.5
Total général | 94.5 | 31.5 | 40.5 | 19.5 | 186
Spreadsheet: 118ce67f-8f36-4d02-ae19-2ff3ef878c1e
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
VITC | Test | VITC | Ascorbic Acid, Plasma | Ascorbic Acid, P | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 1 | mL | Collection Container/Tube: Green top (heparin) Submission Container/Tube: Amber vial (Supply T192) [NAME]: 1 mL Collection Instructions 1. Fasting-overnight (12-14 hours) (infants-draw prior to next feeding). Water can be taken as needed. 2. Immediately place specimen on wet ice. Maintain specimen on wet ice and process within 4 hours of draw. 3. Centrifuge at 4 degrees C, aliquot plasma into amber vial to protect from light. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	Plasma gel tube or specimen not protected from light | 0.6-2.0 mg/dL | Monday through Friday | 2 days (not reported on Saturday or Sunday) | 4 days | 1 | 82180 |  |  |  |  | New England
VITC | [NAME] | PLNAH | [NAME] |  |  |  | Frozen | 14 days
VITC | Result | 8312 | Ascorbic Acid, P | Ascorbic Acid, P | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 1903-4
Spreadsheet: sally_beck__33864__Final PRC
Sheet: Sheet1

ENA/EGM/EIM COMMERCIAL SUPPORT FINAL PRC MEETING
Total
Percentage | Superior | Excellent | Strong | Satisfactory | NeedsImprovements/Issues |  | Total
Total | 4.81 | 26.15 | 33.89 | 24.9 | 10.25 |  | 1
Preferred | 5 | 30 | 30 | 20 | 15
# of Employees | Superior | Excellent | Strong | Satisfactory | NeedsImprovement/Issues |  | Total
Total | 23 | 125 | 162 | 119 | 49 |  | 478
Preferred | 24 | 143 | 143 | 96 | 72
[NAME]
Percentage | Superior | Excellent | Strong | Satisfactory | NeedsImprovement/Issues |  | Total
Total | 5.03 | 25.42 | 33.8 | 25.14 | 10.61
Preferred | 5 | 30 | 30 | 20 | 15
# of Employees | Superior | Excellent | Strong | Satisfactory | NeedsImprovements/Issues
Total | 18 | 91 | 121 | 90 | 38 |  | 358
Preferred | 18 | 107 | 107 | 72 | 54
Breakdown by Peer Group
 | Superior | Excellent | Strong | Satisfactory | NeedsImprovement/Issues
[NAME] | 0 | 3 | 1 | 2 | 2
[NAME] | 0 | 3 | 5 | 3 | 1
Assistant | 0 | 2 | 0 | 1 | 2
Assistant Sr | 1 | 1 | 3 | 1 | 0
Specialist Jr | 3 | 7 | 8 | 7 | 4
Specialist | 6 | 27 | 42 | 42 | 12
Specialist Sr | 5 | 31 | 47 | 22 | 13
Manager | 3 | 12 | 11 | 9 | 3
Director | 0 | 3 | 1 | 2 | 1
Director Sr | 0 | 2 | 0 | 1 | 0
VP | 0 | 0 | 3 | 0 | 0
EGM
Percentage | Superior | Excellent | Strong | Satisfactory | NeedsImprovement/Issues |  | Total
Total | 4.59 | 31.19 | 31.19 | 23.85 | 9.17
Preferred | 5 | 30 | 30 | 20 | 15 |  | 1
# of Employees | Superior | Excellent | Strong | Satisfactory | NeedsImprovement/Issues
Total | 5 | 34 | 34 | 26 | 10 |  | 109
Preferred | 5 | 33 | 33 | 22 | 16
Breakdown by Peer Group
 | Superior | Excellent | Strong | Satisfactory | NeedsImprovement/Issues
[NAME] | 0 | 3 | 0 | 2 | 0
[NAME] | 0 | 5 | 3 | 2 | 0
Assistant | 0 | 2 | 0 | 2 | 0
Assistant Sr | 0 | 2 | 0 | 0 | 0
Specialist Jr | 0 | 2 | 3 | 3 | 1
Speciailist | 1 | 7 | 12 | 6 | 3
[NAME] | 1 | 6 | 6 | 8 | 2
Manager | 1 | 6 | 7 | 3 | 4
Director | 2 | 1 | 2 | 0 | 0
Director Sr | 0 | 0 | 1 | 0 | 0
VP | 0 | 0 | 0 | 0 | 0
EIM
Percentage | Superior | Excellent | Strong | Satisfactory | NeedsImprovement/Issues |  | Total
Total | 0 | 0 | 63.36 | 27.27 | 9.09
Preferred | 5 | 30 | 30 | 20 | 15 |  | 1
# of Employees | Superior | Excellent | Strong | Satisfactory | NeedsImprovement/Issues
Total | 0 | 0 | 7 | 3 | 1 |  | 11
Preferred | 0.55 | 3.3 | 3.3 | 2.2 | 1.65
Breakdown by Peer Group
 | Superior | Excellent | Strong | Satisfactory | NeedsImprovement/Issues
[NAME] | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0
Assistant | 0 | 0 | 0 | 0 | 0
Assistant Sr | 0 | 0 | 1 | 0 | 0
Specialist Jr | 0 | 0 | 2 | 1 | 0
Specialist | 0 | 0 | 2 | 0 | 0
Specialist Sr | 0 | 0 | 0 | 1 | 1
Manager | 0 | 0 | 1 | 1 | 0
Director | 0 | 0 | 0 | 0 | 0
Director Sr | 0 | 0 | 1 | 0 | 0
VP | 0 | 0 | 0 | 0 | 0
Spreadsheet: 84391d1284449141-conditional-formatting-book1
Sheet: Sheet1

 |  |  |  |  |  | Targets & limits
 |  |  |  |  |  |  | Target |  | Upper Limit |  | Lower Limit
 |  |  |  |  |  |  | WT | OP | WT | OP | WT | OP
 |  |  |  |  |  | P | 930 | 122 | 945 | 128.1 | 915 | 115.9
 |  |  |  |  |  | V | 920 | 125 | 935 | 131.3 | 905 | 118.9
 |  |  |  |  |  | G | 940 | 121 | 955 | 127.1 | 925 | 114.9
 |  | Actual Values
 |  | WT | OP
 | P | 929 | 128.3 |  | Based on Column B, conditional formatting is required which should based on the table above in which targets & upper/lower limits are given.
 |  |  |  |  | If P is punched then in column C in WT field it should be automatically changed the formatting. Conditional formatting should be if values are beyond upper/lower limits then it should be red & if with in limits then it should be green.
Spreadsheet: 173670d1344635939-sorting-grouped-data-in-excel-book1-ily3-oeldere-
Sheet: Sheet3

 | Status |  | RREA  Contact
 | Closed |  | Altobello
 | Closed |  | Altobello
 | Closed |  | Altobello
 | IN CONTRACT |  | Altobello
 | Closed |  | Baum
 | Closed |  | Baum
 | RETAINED |  | Baum
 | PROPOSALS |  | Baum
 | PROPOSALS |  | Baum
 | Closed |  | Baum/Owen
 | Closed |  | Baum/Owen
 | Closed |  | Baum/Owen
 | Closed |  | Baum/Owen
 | IN CONTRACT |  | Baum/Owen
 | RETAINED |  | Baum/Owen
 | RETAINED |  | Baum/Owen
 | RETAINED |  | Baum/Owen
 | PROPOSALS |  | Baum/Owen
 | PROPOSALS |  | Baum/Owen
 | PROPOSALS |  | Baum/Owen
 | PROPOSALS |  | Baum/Owen
 | Closed |  | Baum/Seter
 | Closed |  | Bell
 | Closed |  | Bell
 | IN CONTRACT |  | Bell
 | AFFILIATE DIRECT |  | Bell
 | AFFILIATE DIRECT |  | Bell
 | PROPOSALS |  | Bell
 | RETAINED |  | Bell/Pepe
 | PROPOSALS - THIRD PARTY FINANCE / QUOTES |  | Bode
 | RETAINED - THIRD PARTY ASSIGNMENTS |  | Bode
Spreadsheet: 889925d1740962215-trying-to-find-totals-that-mach-date-ranges-throughout-the-entire-year-sampledaterangesum
Sheet: Summary

 |  |  |  |  |  |  |  |  | Option 1 (Current configuration) |  |  |  |  | Option 2
 |  |  |  |  |  |  |  |  | Date Range | Expenses for the Specified Date Range (where I want my formula to go) | Expected output, done manually |  |  | Date Range |  | Expenses for the Specified Date Range
 |  |  |  |  |  |  |  |  |  |  | 1687
 |  |  |  |  |  |  |  |  |  |  | 304
 |  |  |  |  |  |  |  |  |  |  | 1592
 |  |  |  |  |  |  |  |  |  |  | 419
 |  |  |  |  |  |  |  |  |  |  | 1602
 |  |  |  |  |  |  |  |  |  |  | 429
 |  |  |  |  |  |  |  |  |  |  | 1602
 |  |  |  |  |  |  |  |  |  |  | 224
 |  |  |  |  |  |  |  |  |  |  | 1385
 |  |  |  |  |  |  |  |  |  |  | 624
 |  |  |  |  |  |  |  |  |  |  | 1335
 |  |  |  |  |  |  |  |  |  |  | 587
 |  |  |  |  |  |  |  |  |  |  | 1434
 |  |  |  |  |  |  |  |  |  |  | 587
 |  |  |  |  |  |  |  |  |  |  | 304
 |  |  |  |  |  |  |  |  |  |  | 1657
 |  |  |  |  |  |  |  |  |  |  | 364
 |  |  |  |  |  |  |  |  |  |  | 1592
 |  |  |  |  |  |  |  |  |  |  | 374
 |  |  |  |  |  |  |  |  |  |  | 1637
 |  |  |  |  |  |  |  |  |  |  | 224
 |  |  |  |  |  |  |  |  |  |  | 1335
 |  |  |  |  |  |  |  |  |  |  | 686
 |  |  |  |  |  |  |  |  |  |  | 1335
 |  |  |  |  |  |  |  |  |  |  | 587
 |  |  |  |  |  |  |  |  |  |  | 334
Spreadsheet: 768215d1644881791-how-to-calculate-accessories-left-with-formula-stock-denox78-
Sheet: Sheet1

IN STOCK |  |  |  | GIVEN TO USERS
Date | Item | Qty |  | Given Date | User | Item | Qty | Left in stock | Expected Result | Returned
2022-02-01 00:00:00 | Earpods | 30 |  | 2022-02-14 00:00:00 | [NAME] | Earpods | 1 |  | 30 | Yes
2022-02-01 00:00:00 | HDMI Cable | 50 |  | 2022-02-14 00:00:00 | [NAME] | HDMI Cable | 5 |  | 47 |  | 50 - 5 = 45
 |  |  |  | 2022-02-14 00:00:00 | [NAME] | HDMI Cable | 3 |  |  | Yes | 45 + 3 = 48
Spreadsheet: 737228d1624287879-sorting-defects-based-on-the-date-they-were-found-work-in-progress
Sheet: Chart

 | Problem Description |  | Period 1 | Period 2 | period 3 | current period | Total | 4 Period PPHV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | PPHV for Period
 | SINKS |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0
 | BURNS |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0
 | FLASH |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0
 | SHORT SHOTS |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0
 | SPLAY |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0
 | OTHER |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0
 | Total Rejects
 | Total Reviewed
 | PPHV
 |  |  |  |  |  | 5 day moving avg ->