tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 848796d1699434622-given-a-daily-schedule-output-percentage-doing-a-type-of-task-schedule-metrics
Sheet: Sheet1

 |  |  |  |  | Daily Employee Schedule |  |  |  |  |  |  |  |  |  |  | Categories
 |  |  |  |  | 2023-01-01 00:00:00 | 2023-01-02 00:00:00 | 2023-01-03 00:00:00 | 2023-01-04 00:00:00 | 2023-01-05 00:00:00 | 2023-01-06 00:00:00 | 2023-01-07 00:00:00 | 2023-01-08 00:00:00 | 2023-01-09 00:00:00 | 2023-01-10 00:00:00 |  | Commuting |  | Working
 |  |  |  | Me | biking | biking | typing | typing | printing | printing | driving | driving | printing | printing |  | biking |  | typing
 |  |  |  | you | swimming | swimming | swimming | swimming | writing | swimming | swimming | swimming | swimming | writing |  | swimming |  | printing
 |  |  |  | her | driving | driving | driving | driving | driving | swimming | swimming | swimming | swimming | swimming |  | driving
 |  |  |  | him | biking | biking | biking | printing | printing | biking | biking | biking | printing | printing
 |  |  |  |  | Ideal Results
 |  |  |  | % commuting | 1 | 1 | 0.75 | 0.5 | 0.75 | 0.75 | 1 | 1 | 0.5 | 0.25
 |  |  |  | % working | 0 | 0 | 0.25 | 0.5 | 0.25 | 0.25 | 0 | 0 | 0.5 | 0.75
 |  |  |  | % commuting
 |  |  |  | % working
Spreadsheet: 264634d1378924689-top-10-list-of-students-from-separate-worksheets-grade-6-marks-solved
Sheet: Grade 6.2

 | Last | First |  |  |  |  | Total | Level
1 | Ka | George | 27 | 21 | 4 | 18
2 | Madelaine | Regenia | 23 | 20 | 8 | 20
3 | [NAME] | Lionel | 13 | 14 | 8 | 20
4 | Cornelius | [NAME] | 10 | 10 | 8 | 20
5 | Terrilyn | [NAME] | 36 | 12 | 6 | 20
6 | [NAME] | Dyan | 31 | 5 | 6 | 20
7 | [NAME] | Shay | 28 | 23 | 2 | 20
8 | [NAME] | Rafael | 32 | 25 | 8 | 20
9 | [NAME] | Treva | 18 | 20 | 8 | 20
10 | Saundra | Fallon | 30 | 12 | 8 | 20
11 | Carma | Tommye | 25 | 15 | 6 | 20
12 | Albina | Rhona | 17 | 20 | 8 | 20
13 | Suzann | Kit | 29 | 23 | 8 | 20
14 | Marva | Heriberto | 25 | 19 | 8 | 20
15 | Grace | Mark | 14 | 20 | 8 | 20
16 | Rima | Micha | 20 | 16 | 8 | 20
17 | Lino | Sherlyn | 22 | 21 | 6 | 20
18 | Candance | Mellissa | 32 | 21 | 6 | 20
19 | Soon | Tawnya | 10 | 15 | 6 | 20
20 | Coleen | Rosalva | 30 | 25 | 8 | 18
21 | Agatha | Jermaine | 22 | 21 | 8 | 20
22 | [NAME] | Buffy | 23 | 10 | 8 | 20
23 | Hue | Shena | 16 | 9 | 6 | 18
24 | [NAME] | Omega | 28 | 20 | 8 | 18
25 | Pearline | [NAME] | 22 | 14 | 10 | 20
26 | Edelmira | Elna | 25 | 16 | 2 | 20
27 | [NAME] | Venetta | 26 | 19 | 8 | 20
28 | Kiera | [NAME] | 33 | 18 | 6 | 20
29 | Meghann | Marcellus | 22 | 20 | 6 | 20
30 | [NAME] | Angelia | 19 | 21 | 6 | 20
31 | Neely | Vince | 30 | 20 | 6 | 20
32 | [NAME] | Fabian | 20 | 20 | 6 | 20
33 | Bethanie | Sherilyn | 19 | 21 | 8 | 20
34 | Yun | Eugena | 21 | 28 | 8 | 18
35 | Fletcher | Maryjo | 14 | 21 | 8 | 20
36 | Emile | Ena | 16 | 23 | 8 | 18
37 | Barney | Madlyn | 22 | 21 | 8 | 20
Spreadsheet: c559852b-81b5-4250-b704-00aca05216cb
Sheet: Sheet1

BUDGET ADJUSTMENT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
Brief Title |  | Approval Deadline |  |  | Reason
To authorize and appropriate funds for |  |  |  |  | To set up project accounts for the purpose of collecting
sidewalk assessments |  |  |  |  | cost of assessments and authorizing those assessments
Details |  |  |  |  | Department, Program, or Accounts Affected
Reason for Adjustment |  |  |  |  | Sponsor
To set up special assessment accounts in the Public |  |  |  |  | Public Works
Improvement Revolving fund for the purpose of
collecting the costs for petition sidewalk project
part of the Public Improvement Projects in CD5 |  |  |  |  | From/Transferor(s) or Fund Title(s)
This ordinance also authorizes issuance of |  |  |  |  | 3190-898407- Curb & Sidewalk Construction
special assessments tax bills for sidewalk repair.
The work is located in Kansas City, Jackson County,
Missouri.
 |  |  |  |  | To/Transferee(s) or [NAME])
 |  |  |  |  | Sidewalk assessment account
The following project was initiated by
application to the Public Improvements Advisory Committee
under the Neighborhood Sales Tax Program.  This
improvement involves reconstructing curb, sidewalks,
driveways and related appurtenances on the following |  |  |  |  | Policy / Program Impact
project:
 |  |  |  |  | Policy or Program | No | Yes
Project 60124 - Troost Ave. from 75th St. to 77th St. (East Side) |  |  |  |  | Emphasis Change
This is a typical PIAC curb/sidewalk project. In this type of
project, PIAC funds pay for all but the hazardous portions
of the sidewalk reconstruction. Property owners pay for the
cost of repairing the hazardous sidewalk portions.
The special assessment to property owners can be paid |  |  |  |  | Operational
without interest when issued or in annual installments over a |  |  |  |  | Impact
six year period, as provided under Section 311-313 of the |  |  |  |  | Assessment
City Charter.  The assessable portion of the
projects’ cost will be assessed under Section 263 of the City
Charter. |  |  |  |  | Council Committee Actions
 |  |  |  |  | Do Pass |  | Hold
 |  |  |  |  | Do Pass (as amended) |  | w/o Recommendation
 |  |  |  |  | Committee Sub. |  | Do Not Pass
 |  |  |  |  | Fact Sheet prepared by: |  | Date
 |  |  |  |  | [NAME] |  | 2007-09-26 00:00:00
 |  |  |  |  | Fact Sheet reviewed by: |  | Date
 |  |  |  |  | [NAME] |  | 2007-09-26 00:00:00
 |  |  |  |  | Reference Numbers
Spreadsheet: 104623d1302161380-searching-data-through-out-the-worksheet-stock-statement-on-7-4-2011
Sheet: STANDS & Wall Mount Brackets

S.No | [NAME] | MODEL | SERIAL NO | QTY
1 | Liberty Projector Ceiling mounts(1 ft) |  |  | 0(w)
2 | Projector Ceiling Mount 4FT |  |  | 25
3 | Wharfdale Movie star 70 Spkr Stands |  |  | 2
4 | Wharfdale Movie star 60 Spkr Stands |  |  | 2
5 | B & W M1 Spkr Stands |  |  | 4
6 | PANAsonic PDP42 TV Wall mounts |  |  | 6
7 | Pioneer PDK TS 12 Table stand |  |  | 1
8 | Pioneer PDK TS 29 PIDE DE Table stand |  |  | 3
9 | Pioneer PDK TS 29 Table Top stand |  |  | 2
10 | Pioneer PDK TS 29A Table stand |  |  | 1
11 | Pioneer PDK TS 27 Table stand |  |  | 1
12 | Pioneer PDK TS 30A Table stand |  |  | 1
13 | Vangaurd VM 231 wall mount |  |  | 1
14 | Vangaurd VM 111 wall mount |  |  | 3 | BACK
15 | [NAME] 531 Wall mount |  |  | 2
16 | 40-50"TV Wall Mounts |  |  | 10
17 | TV Table Tops |  |  | 8
18 | Projector [NAME] | INKA |  | 3
19 | Swivetelli TV Wall Mount 40" |  |  | 2
20 | [NAME] Wall Mount 32" |  |  | 3
21 | PDP 42" Wall mount brackets |  |  | 2
22 | Panasonic 26" TV Wall mounts |  |  | 9
23 | [NAME] | STA 100 |  | 2
24 | Samsung LED TV Wall mount bracket |  | WMN1000BXXL | 2
25 | waLL RACKplates 2x2 |  |  | 4(black)
26 | Samsung LED TV Table top |  |  | 11
27 | Radrish 42" TV Wall mounts |  |  | 2
28 | Radrish 1001 Wall mounts |  |  | 2
29 | MONSTAR HOME THEATRE PWR CENTER | HTS-1000 | 1071208173 | 10
30 | LIFT PLATES  2X2 |  |  | 3(silver)
31 | Chief XSMV extra alrge static mount |  |  | 2
32 | Chief FVS 100 lower camera shelf small |  |  | 1
33 | SWITELLY wall mounts 19'' |  |  | 2
34 | PROJECTOR LIFT |  |  | 2
35 | WALL RACKS | 24UX600X500 |  | 1(BLACK)
36 | WALL RACKS | 15U |  | 1(BLACK)
38 | WALL RackS | 17U |  | 1 (BLACK)
39 | Projector ceiling mount | HA717 |  | 93
40 | Projector ceiling mount | HA617 |  | 38
41 | Rods | HA 600 |  | 53
42 | Rods | HA 800 |  | 56
43 | Rods | HA 400 |  | 16
44 | 19" Hevy Rack | 42U 6 x 6.5 |  | 1
 | BACK
Spreadsheet: 748562d1632217597-populate-dynamic-calendar-with-tasks-based-on-task-frequency-tasks-calendar-ans
Sheet: Tasks

Reference | Task | Day | Week | Month
 | Sample task one | Daily | Weekly | Monthly
 | Sample task two | Day 1 | Week 1 | Odd Months
 | Sample task three | Day 2 | Week 2 | Even Months
 | Sample task four | Day 4 | Week 3 | Quarterly | Which is the month. 1st Qrt- Jan or Feb or Mar
 | Sample task five | Day 5 | Week 4 | Biannualy | Which is the month. 1st biannualy- Jan or Feb or [NAME] …..June
 | Sample task six | Day 2 | Odd Weeks | Monthly
 | Sample task seven | Day 4 | Even Weeks | Monthly
 | Sample task eight | Day 2 | Weekly | Monthly
 | Sample task nine | Day 4 | Weekly | Odd Months
 | Sample task ten | Day 5 | Weekly | Even Months
Spreadsheet: 39422d1237570702-difference-in-text-lists-book2
Sheet: Standings

Players Names |  | Win % Per Round
 |  | Rd 1 |  | Rd 2 |  | Sweet 16 |  | Elite 8 |  | Final 4 |  | Finals
 | Tournament Games Played | 15 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Score | won | % | won | % | won | % | won | % | won | % | won | %
[NAME] | 67 | 14 | 0.9333333333333333
[NAME] | 67 | 12 | 0.8
Sean P | 66 | 12 | 0.8
Kyle & Jenna | 66 | 12 | 0.8
[NAME] 1 | 64 | 13 | 0.8666666666666667
[NAME] | 64 | 12 | 0.8
[NAME] | 63 | 13 | 0.8666666666666667
Junaid | 62 | 13 | 0.8666666666666667
Goose | 62 | 12 | 0.8
[NAME] | 61 | 12 | 0.8
[NAME] | 57 | 12 | 0.8
[NAME] | 57 | 12 | 0.8
[NAME] | 57 | 12 | 0.8
[NAME] | 56 | 13 | 0.8666666666666667
[NAME] | 56 | 12 | 0.8
[NAME] | 56 | 12 | 0.8
[NAME] | 56 | 12 | 0.8
Bubba | 56 | 12 | 0.8
[NAME] | 55 | 12 | 0.8
[NAME] | 55 | 12 | 0.8
Brett Burkhart | 54 | 13 | 0.8666666666666667
Tracie Mahaffey | 54 | 13 | 0.8666666666666667
[NAME] | 53 | 12 | 0.8
Jen Tanner | 50 | 12 | 0.8
[NAME] | 50 | 12 | 0.8
[NAME] | 49 | 12 | 0.8
[NAME] | 49 | 11 | 0.7333333333333333
[NAME] | 49 | 12 | 0.8
[NAME] | 49 | 12 | 0.8
[NAME] | 49 | 12 | 0.8
Dienise Bagley | 47 | 12 | 0.8
[NAME] | 47 | 12 | 0.8
Trevor | 46 | 12 | 0.8
Piggy | 45 | 11 | 0.7333333333333333
[NAME] | 45 | 12 | 0.8
[NAME] 2 | 43 | 13 | 0.8666666666666667
[NAME] | 43 | 12 | 0.8
[NAME] | 39 | 12 | 0.8
[NAME] | 39 | 12 | 0.8
[NAME] | 38 | 11 | 0.7333333333333333
Hines | 37 | 11 | 0.7333333333333333
[NAME] | 37 | 12 | 0.8
Chudly | 36 | 12 | 0.8
[NAME] | 3 | 11 | 0.7333333333333333
Spreadsheet: 817729d1676409186-im-tracking-temperature-for-the-days-looking-for-help-temperature-sample2-etaf
Sheet: Temp Sample

Temperature
 | High | Low | HIGH
2023-01-03 00:00:00 | 81.5 | 76.6
2023-01-04 00:00:00 | 77.5 | 72.5
2023-01-05 00:00:00 | 75 | 72.4
2023-01-06 00:00:00 | 75 | 73.24
2023-01-09 00:00:00 | 77 | 73.5
2023-01-10 00:00:00 | 76 | 74
2023-01-11 00:00:00 | 78 | 74.5
2023-01-12 00:00:00 | 79 | 77
2023-01-13 00:00:00 | 80 | 78
2023-01-17 00:00:00 | 81 | 78.5
2023-01-18 00:00:00 | 83 | 79
2023-01-19 00:00:00 | 81.5 | 78.5
2023-01-20 00:00:00 | 82 | 80
2023-01-23 00:00:00 | 83 | 81
2023-01-24 00:00:00 | 82 | 79.5
2023-01-25 00:00:00 | 81 | 79.5
2023-01-26 00:00:00 | 82 | 80
2023-01-27 00:00:00 | 82.5 | 79
2023-01-30 00:00:00 | 80.5 | 77.5
2023-01-31 00:00:00 | 79.25 | 76.5
2023-02-01 00:00:00 | 80 | 76
2023-02-02 00:00:00 | 77.6 | 75
2023-02-03 00:00:00 | 78 | 73.1 |  |  |  |  | Im thinking he first step would be to find the lowest High temperature and  fill that cell a color |  |  |  |  |  |  |  |  | MIN(range)
2023-02-06 00:00:00 | 74.5 | 72 |  |  |  |  | But  in addition to that argument, it cant have a low temperature above it |  |  |  |  |  |  |  |  | what does that mean -
2023-02-07 00:00:00 | 78 | 74 |  |  |  | High | This cell next to the high would contain the lowest high temperature value of 74.5 that did not have a low temperature value above it The 72 doesn’t count because it on the same day
2023-02-08 00:00:00 | 78.5 | 77
2023-02-09 00:00:00 | 79 | 76.5
2023-02-10 00:00:00 | 80 | 77.5 |  |  |  |  | Then for the low temperature the Highest Low temperature fill that green or something
2023-02-13 00:00:00 | 81 | 78.5 |  |  |  | Low | But  in addition to that argument, it cant have a high temperature below it
 |  |  |  |  |  |  | Im not sure if this could be updated as I insert additional temperatures
 |  |  |  |  |  |  | This is what I have been working on kinda fiddling with the formulas
Spreadsheet: errol_mclaughlin_jr__10149__Bkrqs689
Sheet: Sheet1

From: | Risk Analysis and Reporting
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: |  |  | Risk Management
Subject: | New Book Request (to set up book in RisktRAC)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
 | COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  |  |  | IT SECURITY | Reporting -Subledger
 |  |  | Internal | External | Both | Book Mapping |  |  |  |  |  |  |  |  |  |  | Book
 | Short Name | [NAME] | Transactions | Transactions | Transactions | Code | Region | P | B | Idx | [NAME] | PHY | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason for Book | Administrator* | MTM | Prud | Realized
 | NG-Pr-Opt | Natural Gas Non-Affiliate Options Book | x |  |  | ZH | DESK | x |  |  |  |  | NatGas - MMBtu | [NAME] | MTM | Traders are splitting out book | See Below
 | FIN-ECTI-ENERGY | Financial ECTI-Energy |  |  |  | I7 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FIN-ECTI-PROP | Financial ECTI-Prop |  |  |  | I8 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FIN-ECTI-ST | Financial ECTI-ST |  |  |  | I3 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FINLAND-JV-.2GO | Finland JV GASOIL.2 |  |  |  | QM | DESK | X | - | - | - |  | TN10/CNTR/USD
 | UK-FO-LSSR | UK -Fuel Oil-LSSR |  |  |  | V# | DESK | X | - | - | - |  | TN10/CNTR/USD
 | (Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag
 | Please provide a list of the people who need access to the above book(s).
 | ***'Please provide login names for book administrators.***
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Brent Price
 | Access List: | emclaug
 |  | [NAME]
 |  | bbajwa
 |  | trohave
 | BOOK WILL NOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
 | For questions, call:
 | [NAME] (x57197)
 | [NAME] (x31462)
 | [NAME] (x54751)
 | [NAME] (x33102)
Spreadsheet: 215130d1361275993-creating-a-max-if-or-large-if-wildcard-formula-book1-1-
Sheet: Sheet1

A | 200
A,B,D | 72 |  |  |  | A
A,D | 100
A,C | 240 |  |  |  |  |  | SEARCH | ISNUMBER | IF | MAX
 |  |  |  |  |  |  | 1 | True | 72
 |  |  |  |  |  |  | 1 | True | 100
 |  |  |  |  |  |  | 1 | True | 240
Spreadsheet: holden_salisbury__12301__generator contacts-Real Time
Sheet: Sheet1

Generator SC Contact List:  Ranked in order of who real time should call first
Customer |  |  | Unit ID | PMax | Min | Contact Information
Harbor Cogeneration |  |  | harbgn_7_units | 85 | 60 | Shift Supervisor |  | Control Room | 562/495-3140
 |  |  | harbgn_7_pl2x3 | 30 | 0
[NAME] (SP-15) |  |  | pandol_6_unit | 45 | 30
 |  |  |  |  |  | Shift Supervisor |  | Control Room | [PHONE] ext 120
 |  |  |  |  |  | [NAME] |  | Plant Manager | [PHONE] ext 103
 |  |  |  |  |  | [NAME] |  | Scheduler | [PHONE] ext 105 |  | 661/333-6507
Arco (SP-15) |  |  | carbgn_6_unit | 30 | 30
 |  |  |  |  |  | Control Room |  |  | 562/499-3231
 |  |  |  |  |  | [NAME] |  |  | [PHONE]
 |  |  |  |  |  | [NAME] |  |  | [PHONE]
Sierra Forest Products (SP-15) |  |  | vestal_6_wdfire | 7 | 7
 |  |  |  |  |  | [NAME] |  | Power Plnt Supt | [PHONE] |  | [PHONE]
 |  |  |  |  |  | [NAME] |  | General [NAME] | [PHONE] |  | [PHONE]
 |  |  |  |  |  | [NAME] |  | Adm Assist | [PHONE] |  | [PHONE]
[NAME] (NP-15) |  |  | martel_2_amfor | 13 | 7/10
 |  |  |  |  |  | Control Room |  |  | 209/223-4581 x15
 |  |  |  |  |  | Control Room |  |  | 209/223-3159
 |  |  |  |  |  | [NAME] |  | Plant Manager | 209/223-4581 x12 |  | 209/304-5093
 |  |  |  |  |  | [NAME] |  |  | 863/665-2255 x 112 |  | 863/206-4792
[NAME] (NP-15) |  |  | wsengy_1_unit4 | 2 | 2
 |  |  |  |  |  | Control Room - Direct |  |  | 530/365-9177
 |  |  |  |  |  | [NAME] |  |  | 530/365-9172 x628 |  | 530/200-0915
 |  |  |  |  |  | Control Room |  |  | 530/365-9172 x628
 |  |  |  |  |  | [NAME] |  |  | 530/365-9172 x614 |  | 530/200-0910
Non-SC Clients
Sierra Pacific Holding Co. (NP-15) |  |  | APX is SC | 45 | 30
 |  |  |  |  |  | [NAME] |  |  | 530/378-8179 |  | 530/949-7611
 |  |  |  |  |  | [NAME] |  |  | 530/378-8261
 |  |  |  |  |  | [NAME] |  |  | 530/378-8275
Gas Recovery Systems, Inc (SP-15) |  |  | APX is SC | 8 |  | [NAME] |  |  | 949/721-4151 |  | 949/859-8044 (H)
East Bay MUD (NP-15) |  |  | APX is SC | 3 |  | [NAME] |  |  | 510/287-1144 |  | 510/851-9425
Spreadsheet: 808768d1670633975-2-formulas-subtract-from-specific-columns-formulatest-1-
Sheet: Pivot

 |  |  | Values |  |  |  |  |  |  |  | Subtract | Subtract
Department | Name | Target | Sum of Jun-22 | Sum of Jul-22 | Sum of Aug-22 | Sum of Sep-22 | Sum of Oct-22 | Sum of Nov-22 | Sum of Dec-22 |  | Column J - Column I | Column J - Column C
DepC | Person19 | 68 | 2192 | 2159 | 2050 | 2045 | 2112 | 1918 | 1626
 | Person21 | 9 | 2286 | 2128 | 1511 | 1647 | 2214 | 2256 | 2058
 | Person23 | 4987 | 1765 | 2142 | 2496 | 1766 | 2157 | 1879 | 1905
 | Person25 | 9848 | 2170 | 2408 | 2237 | 2344 | 1551 | 1916 | 1657
 | Person27 | 18 | 2437 | 2420 | 2186 | 1667 | 2234 | 2481 | 1685
DepC Total |  |  | 10850 | 11257 | 10480 | 9469 | 10268 | 10450 | 8931
[NAME] | [NAME] | 897 | 2407 | 1544 | 2376 | 1922 | 2249 | 2150 | 1948
 | Person22 | 598 | 2426 | 1689 | 1919 | 1891 | 1987 | 1668 | 2439
 | Person24 | 98 | 2024 | 2071 | 1636 | 1807 | 2392 | 2248 | 2185
 | Person26 | 99 | 2191 | 2225 | 2405 | 2086 | 2185 | 1622 | 1861
 | Person28 | 9 | 1804 | 2200 | 1972 | 2002 | 1613 | 1867 | 1522
[NAME] |  |  | 10852 | 9729 | 10308 | 9708 | 10426 | 9555 | 9955
DeptA | Person1 | 1750 | 6164 | 5793 | 6272 | 5654 | 5459 | 5265 | 6027
 | Person11 | 1255 | 2467 | 1581 | 1947 | 2372 | 1592 | 2204 | 2112
 | [NAME] | 654 | 1967 | 2389 | 1995 | 2119 | 1590 | 2066 | 2346
 | Person15 | 651 | 1613 | 2298 | 2152 | 1625 | 1759 | 2371 | 2138
 | Person17 | 651 | 1725 | 2411 | 1882 | 2492 | 2172 | 2162 | 1564
 | Person7 | 2485 | 2002 | 2391 | 2004 | 1824 | 1886 | 2349 | 1605
 | Person9 | 251 | 2295 | 1894 | 2051 | 2088 | 1880 | 1692 | 1636
DeptA Total |  |  | 18233 | 18757 | 18303 | 18174 | 16338 | 18109 | 17428
DeptB | Person1 | 1750 | 1629 | 1953 | 1666 | 1899 | 2255 | 1861 | 1990
 | Person10 | 25455 | 2285 | 1564 | 2197 | 2056 | 1997 | 1625 | 1535
 | Person12 | 255 | 2121 | 2002 | 2342 | 1741 | 1964 | 1685 | 2350
 | Person14 | 654 | 2021 | 1689 | 2199 | 1777 | 2258 | 1909 | 2285
 | Person16 | 651 | 1870 | 2165 | 1753 | 1923 | 1874 | 2339 | 2112
 | Person18 | 651 | 2384 | 1679 | 2291 | 1584 | 1534 | 2400 | 2466
 | Person2 | 1300 | 1591 | 2052 | 1904 | 2213 | 2113 | 2179 | 1700
 | Person6 | 1250 | 1530 | 1778 | 1721 | 1893 | 1972 | 1582 | 2018
 | Person8 | 2552 | 1852 | 2131 | 2206 | 1781 | 2365 | 2085 | 2111
DeptB Total |  |  | 17283 | 17013 | 18279 | 16867 | 18332 | 17665 | 18567
Grand Total |  |  | 57218 | 56756 | 57370 | 54218 | 55364 | 55779 | 54881 |  |  |  | Here is my issue.
Spreadsheet: 177624d1346364774-vlookup-range-based-on-cell-values-vlookup-range-start-end-point-example-1-
Sheet: Sheet1

 |  |  | Oranges | 4"
APPLES
Size | Count
2" | 5
3" | 6
4" | 3
Total Apples
ORANGES
Size | Count
2" | 4
3" | 3
4" | 3
Total Oranges
PEARS
Size | Count
2" | 7
3" | 7
4" | 2
Total Pears
Spreadsheet: 849667d1700079891-interval-shift-schedule-view-horizontal-schedtemp1
Sheet: Shift

 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
Agent | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End
Employee 1 | 2023-11-13 05:00:00 | 2023-11-13 14:00:00 | 2023-11-14 05:00:00 | 2023-11-14 14:00:00 | 2023-11-15 05:00:00 | 2023-11-15 14:00:00 |  |  |  |  | 2023-11-18 05:00:00 | 2023-11-18 14:00:00 | 2023-11-19 05:00:00 | 2023-11-19 14:00:00
Employee 2 |  |  | 2023-11-14 08:00:00 | 2023-11-14 17:00:00 | 2023-11-15 08:00:00 | 2023-11-15 17:00:00 | 2023-11-16 08:00:00 | 2023-11-16 17:00:00 | 2023-11-17 08:00:00 | 2023-11-17 17:00:00 | 2023-11-18 08:00:00 | 2023-11-18 17:00:00
Employee 3 | 2023-11-13 10:00:00 | 2023-11-13 19:00:00 |  |  |  |  | 2023-11-16 10:00:00 | 2023-11-16 19:00:00 | 2023-11-17 10:00:00 | 2023-11-17 19:00:00 | 2023-11-18 10:00:00 | 2023-11-18 19:00:00 | 2023-11-19 10:00:00 | 2023-11-19 19:00:00
Employee 4 | 2023-11-13 14:00:00 | 2023-11-13 23:00:00 | 2023-11-14 14:00:00 | 2023-11-14 23:00:00 | 2023-11-15 14:00:00 | 2023-11-15 23:00:00 |  |  |  |  | 2023-11-18 14:00:00 | 2023-11-18 23:00:00 | 2023-11-19 14:00:00 | 2023-11-19 23:00:00
Employee 5 |  |  | 2023-11-14 19:00:00 | 2023-11-15 04:00:00 | 2023-11-15 19:00:00 | 2023-11-16 04:00:00 | 2023-11-16 19:00:00 | 2023-11-17 04:00:00 | 2023-11-17 19:00:00 | 2023-11-18 04:00:00 | 2023-11-18 19:00:00 | 2023-11-19 04:00:00
Employee 6 | 2023-11-13 20:00:00 | 2023-11-14 05:00:00 |  |  |  |  | 2023-11-16 20:00:00 | 2023-11-17 05:00:00 | 2023-11-17 20:00:00 | 2023-11-18 05:00:00 | 2023-11-18 20:00:00 | 2023-11-19 05:00:00 | 2023-11-19 20:00:00 | 2023-11-13 05:00:00
Employee 7 | 2023-11-13 23:00:00 | 2023-11-14 08:00:00 | 2023-11-14 23:00:00 | 2023-11-15 08:00:00 | 2023-11-15 23:00:00 | 2023-11-16 08:00:00 | 2023-11-16 23:00:00 | 2023-11-17 08:00:00 |  |  |  |  | 2023-11-19 23:00:00 | 2023-11-13 08:00:00
Spreadsheet: 96199d1295616865-benchmark-line-in-graph-bencchmark
Sheet: Sheet1

Ethnicity | 2007/08 | 2008/09 | 2009/10
Other Asian | 0.5802469135802469 | 0.7958115183246073 | 0.7931034482758621
White/Asian | 0.7777777777777778 | 0.7555555555555555 | 0.7692307692307693
African | 0.6764346764346765 | 0.7252252252252253 | 0.7575757575757576
Chinese | 0.8571428571428571 | 0.7591240875912408 | 0.7391304347826086
Caribbean | 0.6365054602184087 | 0.7268588770864947 | 0.698019801980198
White/Black Caribbean | 0.6217616580310881 | 0.7264150943396226 | 0.6977611940298507
White/ Black African | 0.6547619047619048 | 0.6363636363636364 | 0.6891891891891891
Other Mixed | 0.6111111111111112 | 0.5833333333333334 | 0.6888888888888889
Indian | 0.7333333333333333 | 0.7894736842105263 | 0.6875
[NAME] | 0.6046511627906976 | 0.8292682926829268 | 0.6829268292682927
Other Black | 0.7586206896551724 | 0.6787564766839378 | 0.6813725490196079
Pakistani | 0.5833333333333334 | 0.6666666666666666 | 0.6571428571428571
WHITE |  |  | 0.716
Spreadsheet: 755359d1636811291-how-to-cal-monthly-salary-for-mid-hire-termination-using-sumifs-or-sumproduct-headcount-test-_-test-shrihanuman-
Sheet: Tables

 | Year: | 2021
 | FX rate
 | Currency_Code | Global_Rate_00 | to USD |  |  |  |  |  |  | Currency/USD | Price |  |  | USD/Currency | Price
 | AUD | 1.3425 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | CAD | 1.295 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | CHF | 0.91 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | [NAME] | 761.25 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | CNY | 6.5825 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | COP |  | 0.00026 | FX @ 9/13/2021 |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | CRC | 613.87 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | CZK | 21.3 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | DKK | 6.1125 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | EUR | 0.825 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | GBP | 0.745 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | HKD | 7.755 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | HNL | 24.1546 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | ILS | 3.325 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | INR | 72.95 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | [NAME] | 105.5 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | MYR | 4.06 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | NOK | 8.7075 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | NZD | 1.45 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | PLN | 3.7 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | SEK | 8.3875 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | SGD | 1.3275 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | USD | 1 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | ZAR | 16.1575 |  |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | PHP |  | 0.02 | These are based on FX rate in 9/7/2021 |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!
 | UAH |  | 0.037 |  |  |  |  |  |  | #[NAME]! |  |  |  | #[NAME]!