tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 377a8cc2-3663-4dbc-87b4-a06aac5bc1fa
Sheet: Sheet1

Unnamed: 0 | Overall Rating of General Condition of Property | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Ethnic Origin | Excellent | Fair | Good | Poor | Terrible | Total
Black and Minority Ethnic | 29 | 95 | 148 | 79 | 31 | 382
White British | 25 | 63 | 106 | 22 | <10 | 225
Unknown | <10 | <10 | <10 | <10 |  | 14
Total | 55 | 160 | 261 | 105 | 40 | 621
Spreadsheet: 207874d1358594468-using-a-drop-down-list-while-entering-dat-via-excel-built-in-form-function-example
Sheet: Sheet1

RowNumber | ListingID | Title | eCommerceID | Duration | QtyToList | FixedPrice | SiteID | SKU | ListingTypeName | Listing
1 | 16 | Aluminium Chequer Plate 2500mm x 1250mm x 2mm Aluminium Sheet Ali Sheet | [PHONE] | 365 | 5 | 90 | 2 | 1 | Store
2 | 24 | ANSBRL801Losi 8B/8T/2.0 Full pc "SP"bearing set. Answer RC | [PHONE] | 365 | 1 | 20 | 2 | 2 | Store
3 | 29 | 1/8th buggy wheels tyres for losi,rc8,mbx6,hyper,hong nor,proline,proline | [PHONE] | 365 | 1 | 16 | 2 | 3 | Fixed Price
4 | 30 | 1/8th buggy wheels tyres for losi,rc8,mbx6,hyper,hong nor,proline,proline | [PHONE] | 365 | 1 | 19 | 2 | 4 | Fixed Price
5 | 31 | 1/8th buggy wheels tyres for losi,rc8,mbx6,hyper,hong nor,proline,proline | [PHONE] | 365 | 1 | 14 | 2 | 5 | Fixed Price
6 | 37 | 1/8th buggy wheels tyres for losi,rc8,mbx6,hyper,hong nor,proline,proline | [PHONE] | 365 | 1 | 16 | 2 | 6 | Fixed Price
7 | 43 | 1/8th buggy wheels tyres for losi,rc8,mbx6,hyper,hong nor,proline,proline | [PHONE] | 365 | 1 | 14 | 2 | 7 | Fixed Price
8 |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  | 16
Spreadsheet: jeffrey_a_shankman__13952__Global_Prod 11-20-01 EM
Sheet: Not Available 11-20-01

Global Products that were not made available on
but were available on
Global Product Short Desc.
For Curr Exch    Forward                 21Nov01         JPY/USD
For Curr Exch    Forward                 21Nov01         USD/EUR
For Curr Exch    Forward                 21Nov01         USD/GBP
For Curr LME     LME (Spot)              21Nov01         JPY/USD
For Curr LME     LME (Spot)              21Nov01         USD/EUR
For Curr LME     LME (Spot)              21Nov01         USD/GBP
Foreign Currency Reuters BOFC            19Nov01         CAD/USD
FTL Dry Van Cap  Chi - Nwk Spot          20Nov01         USD/M-TL
FTL Dry Van Cap  Col - LA Spot           20Nov01         USD/M-TL
SG Dub Time Spd  Platts                  Q102 v Q202     USD/bl/m
SG Dubai Swap    Platts                  Q2 2002         USD/bl/m
[NAME]ICIS CIF RDAM           Jan-Jun02       USD/mt/m
Tkr Freight Swap IITRA                   Dec01           WS/mt
Tkr Freight Swap IITRA                   Feb02           WS/mt
Tkr Freight Swap IITRA                   Jan02           WS/mt
Tkr Freight Swap IITRA                   Nov01           WS/mt
[NAME]                  Dec01           WS/mt
[NAME]Feb02           WS/mt
[NAME]                  Jan02           WS/mt
[NAME]                  Nov01           WS/mt
US Benzene Swap  CMAI Contract           Dec01           USD/Gl-b
US Benzene Swap  CMAI Spot               Dec01           USD/Gl-b
US [NAME]               Dec01           USD/Gl-b
US N.Butane FOB  MB Enterprise           Dec01           c/Gl-b
US N.Butane Swap OPIS MB NTET            Dec01           c/Gl-b
US NitTol Swap   CMAI Spot               Apr-Jun02       USD/Gl-b
US PuEthane Swap OPIS MB PurEth          Dec01           c/Gl-b
US WTI Swap      Nymex LD                Dec01           USD/bl/m
[NAME]
Spreadsheet: 698340d1601931737-two-dimensional-dynamic-range-mock-up-tms
Sheet: Job

 | Select Driver | Parcel Size 1 | Parcel Size 2 | Parcel Size 3 | Parcel Size 4 | Parcel Size 5 | Parcel Size 6 | Parcel Size 7 | Parcel Size 8 | Parcel Size 9 | Parcel Size 10
Slot 1 | Driver 1
Slot 2 | Driver 11
Slot 3 | Driver 4
Slot 4
Slot 5
 |  |  |  |  |  |  |  | DNR: | =Job!$C$2:INDEX(Job!$C:$Z,COUNTA(Job!$B:$B),COUNTA(Job!$1:$1)-1)
 |  |  |  |  |  |  |  |  |  | 5 | 1 | 13 | 2 | 10 | 10 | 0 | 6 | 0
 |  |  |  |  |  |  |  |  | 0 | 7 | 13 | 1 | 18 | 20 | 0 | 6 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 13 | 4 | 5 | 0 | 4 | 6 | 13 | 9 | 0
 |  |  |  |  |  |  |  | Example: | =SUM(Job!$C$2:INDEX(Job!$C:$Z,COUNTA(Job!$B:$B),COUNTA(Job!$1:$1)-1))
Spreadsheet: 72643873-31c2-468b-89f2-fafcd4ab5489
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8947 | 49246 | [NAME] | Solano | CRC | 25 | 00:16:12 | 00:01:38 | 00:44:24 | 00:00:34 | 00:21:39 | 1 | 01:24:26
8947 | 47864 | Selena | Vergara | GUA | 22 | 00:13:49 | 00:01:21 | 00:47:35 | [NAME] | 00:23:15 | 2 | 01:26:37
8947 | 57908 | Fernanda | [NAME] | GUA | 24 | 00:13:54 | 00:01:16 | 00:49:09 | 00:00:33 | 00:25:27 | 3 | 01:30:18
8947 | 68297 | Catalina | Barahona | CRC | 21 | 00:13:50 | 00:01:30 | 00:50:25 | 00:00:33 | 00:26:00 | 4 | 01:32:17
8947 | 69063 | Nicolle | Rodriguez | GUA | 27 | 00:13:50 | 00:01:22 | 00:53:11 | [NAME] | 00:28:24 | 5 | 01:37:23
Spreadsheet: 214872d1361170446-hello-everyone-am-kind-of-new-here-sample
Sheet: Sheet1

Beall
Shelly D
4913 Park Land Dr
[NAME]
[PHONE]
.........................................................................................................
Beall
Sue
12857 State Hwy 30
College Station TX 77845
[PHONE]
.........................................................................................................
Bealls
725 E Villa Maria Rd
[NAME]
[PHONE]
.........................................................................................................
Bealls Department Store
Post Oak Mall
TX 77840
[PHONE]
.........................................................................................................
Beals
[NAME]
9409 Stonebridge Dr
College Station TX 77845
[PHONE]
.........................................................................................................
Spreadsheet: michelle_lokay__26563__imbalsumm0012
Sheet: Amoco Abo

 | [NAME]
Day | Measured | Scheduled | Imbal
1 | 17119 | 21220
2 | 16670 | 18277
3 | 16648 | 16986
4 | 16896 | 21488
5 | 17028 | 16345
6 | 16385 | 16988
7 | 16743 | 16988
8 | 16645 | 16988
9 | 16869 | 13954
10 | 17177 | 16887
11 | 15991 | 16854
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  | -65848.31
2000-12-11 00:00:00
Spreadsheet: 107749d1304905117-what-function-should-i-use-to-lookup-the-closest-zip-code-closest-zip
Sheet: Sheet2

Five Digit Zip | Distance to nearest [NAME] | [NAME]
36345 | 7.6
36303 | 7.6
39823 | 0
39823 | 0
39823 | 0
36321 | 8.1
36301 | 0
36301 | 0
36312 | 8.6
31721 | 49.2
32460 | 21.3
32447 | 21.3
31705 | 21.1
39834 | 26.9
31730 | 26.9
32421 | 19.1
32424 | 19.1
32353 | 28.1
31714 | 34.9
32444 | 43.8
32302 | 21.8
32327 | 21.7
32456 | 45.8
31750 | 18.7
31001
36310
36353
31730
32310
32308
32348
32456
32448
31794
31015
31015
35453
39877
36302
36303
36345
31744
32465
31750
31792
39828
32327
32362
32344
31771
31707
32302
32323
32446
32052
32303
32303
31792
31620
31632
31602
32446
32303
31639
39819
31639
31632
31750
31707
32304
32424
39851
31079
32302
36353
36310
39845
32343
31768
31647
36303
31601
32456
31750
39845
39817
31728
31730
39845
32333
31788
32353
31757
31794
32340
39823
32460
32446
32424
32465
36321
32328
32328
36303
36310
31092
32060
32421
32344
32347
32320
32327
Spreadsheet: 109583d1306405877-vlookup-returns-wrong-values-test
Sheet: Sheet1

 | ITEM | UOM |  |  |  |  |  |  | Source Table
 | A 20 |  |  |  |  |  |  |  | ITEM | UOM
 | C OO,6 |  |  |  |  |  |  |  | A 20 | m
 | D |  |  |  |  |  |  |  | B 112 x | m
 | E 8,5 17 cm |  |  |  |  |  |  |  | C OO,6 | [NAME]
 | G |  |  |  |  |  |  |  | D | pc
 | Bonnel 15 cm 8,7 cm |  |  |  |  |  |  |  | E 8,5 17 cm | roll
 |  |  |  |  |  |  |  |  | Bonnel 15 cm 8,7 cm | barrell
 |  |  |  |  |  |  |  |  | G | pc
 | What causes the vlookup function to return the wrong values?
Spreadsheet: 121114d1315854537-subtotaling-data-with-a-sum-and-count-for-multiple-criteria-pt-multiple-subtotalt-2
Sheet: Sheet1

name | fac | Year | Month | IP_OP | MarginWBadDebt
[NAME] | UT | 2010 | 10 | I | 15
[NAME] | UT | 2010 | 11 | I | 11
[NAME] | UT | 2010 | 11 | O | 1
[NAME] | UT | 2010 | 12 | I | 15 |  |  |  | [NAME] of MarginWBadDebt
[NAME] | UT | 2010 | 12 | O | 15 |  |  |  | name | Year | Month | Total
[NAME] | UT | 2011 | 1 | I | 11 |  |  |  | [NAME] | 2010 | 10 | 5
[NAME] | UT | 2011 | 2 | I | 1 |  |  |  |  |  | 11 | 58
[NAME] | UT | 2011 | 3 | I | 5 |  |  |  |  |  | 12 | 417
[NAME] | UT | 2011 | 4 | I | 3 |  |  |  |  | 2010 Total |  | 417
[NAME] | UT | 2011 | 5 | I | 4 |  |  |  |  | 2011 | 1 | 250
[NAME] | UT | 2011 | 6 | I | 1 |  |  |  |  |  | 2 | 345
[NAME] | UT | 2011 | 7 | I | 1 |  |  |  |  | 2011 Total |  | 345
[NAME] | TX | 2010 | 10 | I | 5 |  |  |  | cindy Total |  |  | 417
[NAME] | TX | 2010 | 10 | O | 5 |  |  |  | [NAME] | 2010 | 10 | 15
[NAME] | TX | 2010 | 11 | I | 1 |  |  |  |  |  | 11 | 11
[NAME] | TX | 2010 | 11 | O | 58 |  |  |  |  |  | 12 | 15
[NAME] | TX | 2010 | 12 | I | 58 |  |  |  |  | 2010 Total |  | 15
[NAME] | TX | 2010 | 12 | O | 417 |  |  |  |  | 2011 | 1 | 11
[NAME] | TX | 2011 | 1 | I | 100 |  |  |  |  |  | 2 | 1
[NAME] | TX | 2011 | 1 | O | 250 |  |  |  |  |  | 3 | 5
[NAME] | TX | 2011 | 2 | I | 345 |  |  |  |  |  | 4 | 3
 |  |  |  |  |  |  |  |  |  |  | 5 | 4
 |  |  |  |  |  |  |  |  |  |  | 6 | 1
 |  |  |  |  |  |  |  |  |  |  | 7 | 1
 |  |  |  |  |  |  |  |  |  | 2011 Total |  | 11
 |  |  |  |  |  |  |  |  | [NAME] |  |  | 15
 |  |  |  |  |  |  |  |  | Grand Total |  |  | 417
Spreadsheet: 749944d1633106759-value-error-in-if-countif-formula-sample-1
Sheet: Jan

January
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 | 26 | 27 | 28 | 29 | 30 | 31
ne | ne | ne
Spreadsheet: 683174d1592540322-extract-data-name-from-remaining-days-sample
Sheet: Raw Data

NAME | DATE | EXPIRY DATE | REMAINING DAYS
Name 1 | 2020-06-19 00:00:00
Name 2 | 2020-05-19 00:00:00
Name 3 | 2020-05-15 00:00:00
Name 4 | 2020-06-20 00:00:00
Name 5 | 2020-03-03 00:00:00
Name 6 | 2020-06-01 00:00:00
Name 7 | 2020-06-15 00:00:00
Name 8 | 2020-06-14 00:00:00
Name 9 | 2020-06-05 00:00:00
Name 10 | 2020-06-10 00:00:00
Spreadsheet: 759284d1639474887-count-when-certain-amounts-are-reached-from-a-running-total-sum-query
Sheet: Sheet1

 |  | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | Hours | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500
 |  | [NAME]
 |  | Requried
 |  | Triggers
 |  | 1600
 |  | 3500
 |  | 5600
Spreadsheet: 78183d1278591359-reference-sequential-tabs-same-cell-catering-invoice-test
Sheet: 1002

 |  |  |  |  | Event Date: | 2010-05-24 00:00:00
510 | 1002 |  | Event Name | New Employee Orientation
Invoice # |  |  | Cost Center: | 16001006
 | 29.7559175 |  | Contact: | [NAME]
Total Cost |  |  | Phone: | 25933
 |  |  | Drop Time:
Linen: |  |  | Date of Order:
China: |  |  | Location: | #096
WaitStaff: |  |  | Guest Count:
Set-up notes:
Item Description (Food) |  |  | Unit [NAME] | Quantity | Price | Extension
Shuttle Coffee |  |  |  | 2 | 9.99 | 19.98
Cambro Ice Water |  |  |  | 1 | 2.99 | 2.99
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
Item Description (Rentals & Directs) |  |  | Unit [NAME] | Quantity | Price | Extension
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  | Food |  | 22.97
 |  |  |  | Rentals & Directs |  | 0
 |  |  |  | Total Cost: |  | 22.97
 |  |  |  | Tax (food, rentals, directs only) |  | 1.7859175
 |  |  |  | Labor |  | 5
 |  |  |  | Total Cost w/ Labor: |  | 29.7559175
Spreadsheet: 704895d1605798983-conditional-formatting-with-special-conditions-example1
Sheet: Tabelle1

Exchange Date | Close
2000-10-26 00:00:00 | 237.684725493749
2000-10-27 00:00:00 | 237.64374063874
2000-10-30 00:00:00 | 238.412418458566
2000-10-31 00:00:00 | 236.941951072185
2000-11-01 00:00:00 | 238.889855387626 |  |  |  |  |  |  |  | Years | Quarters | Exchange Date | [NAME] of Close | Min of Close
2000-11-02 00:00:00 | 239.731786879304 |  |  |  |  |  |  |  | 2000 | Qtr4 | oct | 238.412418458566 | 236.941951072185
2000-11-03 00:00:00 | 239.419944906244 |  |  |  |  |  |  |  |  |  | nov | 256.032737376178 | 238.889855387626
2000-11-06 00:00:00 | 240.564086455401 |  |  |  |  |  |  |  |  |  | déc | 252.76232013628 | 246.39522520781
2000-11-07 00:00:00 | 241.283209897426 |  |  |  |  |  |  |  | 2001 | Qtr1 | janv | 263.498586512674 | 253.498586512674
2000-11-08 00:00:00 | 243.187068090659 |  |  |  |  |  |  |  | Grand Total |  |  | 263.498586512674 | 236.941951072185
2000-11-09 00:00:00 | 245.563744442296
2000-11-10 00:00:00 | 247.361184941768
2000-11-13 00:00:00 | 250.19186158902
2000-11-14 00:00:00 | 251.907989320189
2000-11-15 00:00:00 | 251.5350135318
2000-11-16 00:00:00 | 253.220736230413
2000-11-17 00:00:00 | 252.900844519084
2000-11-20 00:00:00 | 253.855325626064
2000-11-21 00:00:00 | 253.4223177832
2000-11-22 00:00:00 | 255.285327728249
2000-11-23 00:00:00 | 256.032737376178
2000-11-24 00:00:00 | 248.054458256321
2000-11-27 00:00:00 | 247.604614641218
2000-11-28 00:00:00 | 251.204561653599
2000-11-29 00:00:00 | 249.775895812696
2000-11-30 00:00:00 | 250.143518127015
2000-12-01 00:00:00 | 251.506251887648
2000-12-04 00:00:00 | 252.76232013628
2000-12-05 00:00:00 | 252.708710885586
2000-12-06 00:00:00 | 250.770448230035
2000-12-07 00:00:00 | 250.700012081672
2000-12-08 00:00:00 | 250.475781995675
2000-12-11 00:00:00 | 247.191233856451
2000-12-12 00:00:00 | 248.765026398135
2000-12-13 00:00:00 | 248.413676452821
2000-12-14 00:00:00 | 247.810627295573
2000-12-15 00:00:00 | 246.39522520781
2000-12-18 00:00:00 | 247.003286056009
2000-12-19 00:00:00 | 247.551345865752
2000-12-20 00:00:00 | 250.246831543211
2000-12-21 00:00:00 | 250.928619756428
2000-12-22 00:00:00 | 250.041436630948
2000-12-25 00:00:00 | 249.870001208167
2000-12-26 00:00:00 | 250.850680810449
2000-12-27 00:00:00 | 248.670291168297
2000-12-28 00:00:00 | 248.088812650246
2000-12-29 00:00:00 | 250.498586512674
2000-12-30 00:00:00 | 251.498586512674
2000-12-31 00:00:00 | 252.498586512674
2001-01-01 00:00:00 | 253.498586512674
2001-01-02 00:00:00 | 254.498586512674
2001-01-03 00:00:00 | 255.498586512674
2001-01-04 00:00:00 | 256.498586512674
2001-01-05 00:00:00 | 257.498586512674
2001-01-06 00:00:00 | 258.498586512674
2001-01-07 00:00:00 | 259.498586512674
2001-01-08 00:00:00 | 260.498586512674
2001-01-09 00:00:00 | 261.498586512674
2001-01-10 00:00:00 | 262.498586512674
2001-01-11 00:00:00 | 263.498586512674
Spreadsheet: 755485d1636910453-time-to-stabilisation-xl-help
Sheet: Sheet2

 | Average (first 10) |  | <<< Here I have calculated average of first 10 values and then a 5% range of the average (97.5-102.5%)
 | 97.5% average (lower)
 | 102.5% average (upper)
 | Time (s) | Value | 97.5% average (lower) | 102.5% average (upper) | Both
 | 0 | 2 |  |  |  |  | Time to Stabilisation
 |  | 3
 |  | 2
 |  | 2 |  |  |  |  | I am trying to find the time to stablisation value which is when the value sits between the lower (2.34) and upper (2.46) range for 10 cells (when both the D and E columns present "Yes"). This can easily be done manually and I have highlighted it in green below. The issue is that I need a way of setting the spreadsheet up to do it automatically. This will mean that the yellow highlighted area is ignored as the value only sits correctly for 5 cells and not 10.
 |  | 3
 |  | 2
 |  | 2
 |  | 2
 |  | 3
 |  | 3
 |  | 3
 |  | 2
 |  | 2
 |  | 1
 |  | 0.5
 |  | 0.2
 |  | 0.4
 |  | 0.5
 |  | 0.8
 |  | 1
 |  | 2
 |  | 3
 |  | 7
 |  | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 2.38
 |  | 2.38
 |  | 2.38
 |  | 2.38
 |  | 2.38
 |  | 3
 |  | 2
 |  | 4
 |  | 3 |  |  |  |  | 0.36 is the time to stablisation score as the value sits between 2.34 and 2.46 for 10 cells after this time point
 |  | 2.38
 |  | 2.37
 |  | 2.38
 |  | 2.38
 |  | 2.37
 |  | 2.38
 |  | 2.38
 |  | 2.38
 |  | 2.39
 |  | 2.39
 |  | 2.38
Spreadsheet: 50020d1249439583-table-lookup-694388
Sheet: Sheet1

Products | Jan | Feb | Mar | Apr | May
A | 1 | 2 | 3 | 4 | 5
B | 2 | 3 | 4 | 5 | 6
C | 3 | 4 | 5 | 6 | 7
D | 4 | 5 | 6 | 7 | 8
E | 5 | 6 | 7 | 8 | 9
F | 6 | 7 | 8 | 9 | 10
G | 7 | 8 | 9 | 10 | 11
Product: | C |  | 6 | <-- look at the formula in this cell
Month: | Apr
Spreadsheet: 735219d1622767678-creating-a-new-permit-register-permit-register-example-emma-03-06-21-revised
Sheet: BP

ABC Job Number | Address | Description | Client | Date of Confirmation  to Proceed | Permit  Number | BP Type | Job Notes | Oustanding Documents
 | Address 23 | Description 23 | Client 23 | 2021-04-27 00:00:00 | 00:00:00 | BP | 00:00:00 | 00:00:00
ABC-21024 | Address 24 | Description 24 | Client 24 | 2021-04-28 00:00:00 | 00:00:00 | BP | 00:00:00 | 00:00:00
ABC-21025 | Address 25 | Description 25 | Client 25 | 2021-04-29 00:00:00 | 00:00:00 | BP | 00:00:00 | 00:00:00
ABC-21026 | Address 26 | Description 26 | Client 26 | 2021-04-30 00:00:00 | 00:00:00 | BP | 00:00:00 | 00:00:00
Spreadsheet: 598643d1542636238-aray-formula-sum-from-a-number-of-or-criteria-sum-if_criteria-or
Sheet: Sheet1

Apple | 10 |  | OR Criteria |  | =SUM(IF((A:A="Apple")+(A:A="Pear");B:B;0))
Pear | 20 |  | Apple
Apple | 30 |  | Pear
Pear | 40
Orange | 50
[NAME] | 60
Apple | 70
Pear | 80
Apple | 90
Pear | 100
Orange | 110
[NAME] | 120
Spreadsheet: 62585d1263498745-calculation-dependant-on-if-a-date-falls-within-a-range-data-and-projection
Sheet: Projections

Projections
 |  |  |  |  | Projected Fiscal Years Ending Dec 31
 | ($ in thosands) | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00
 | CSCL Zeebrugge
 | CSCL Long Beach
 | [NAME]
 | CSCL Africa
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | CSCL Hamburg
 | [NAME]
 | CSCL Ningbo
 | CSCL Dalian
 | CSCL Felixstowe
 | CSCL Vancouver
 | [NAME]
 | CSCL New York
 | [NAME]
 | CSCL Brisbane
 | New Delhi Express
 | Dubai Express
 | Jakarta Express
 | Saigon Express
 | Lahore Express
 | Rio Grande Express
 | Santos Express
 | Rio de Janeiro Express
 | Manila Express
 | COSCO Fuzhou
 | COSCO Yingkou
 | CSCL Panama
 | CSCL Montevideo
 | [NAME]
 | CSCL Lima
 | [NAME]
 | [NAME]
 | Hull No. S452
 | Hull No. 2177
 | Hull No. S453
 | Hull No. 2178
 | Hull No. S454
 | Hull No. 2179
 | Hull No. 2180
 | Hull No. 2181
 | COSCO Japan
 | COSCO Korea
 | COSCO Philippines
 | COSCO Malaysia
 | COSCO Indonesia
 | COSCO Thailand
 | COSCO Pakistan
 | COSCO Vietnam
 | [NAME]
 | MOL Eminence
 | MOL Emissary
 | MOL Empire
 | Hull No. 1851
 | Hull No. 1852
 | Hull No. 1853
 | Hull No. 1854
 | Hull No. 1855
 | [NAME]
 | [NAME] Lumaco
 | [NAME]
 | [NAME]
 | CSCL Callao
 | [NAME]
 | [NAME]
 | Calicanto Bridge
Spreadsheet: 858532d1707175483-count-eight-letter-words-played-bingo-log
Sheet: Sheet1

 | NO | 31/12/2023 | 2024-07-01 00:00:00 | 14/1/2024 | 21/1/2024 | 2024-05-02 00:00:00
 | 1 | SEEDING | BOTANIES | FONDEST | REBITES | RECITERS
 | 2 | DENARIES | DRIFTAGE | FINALES | [NAME] | SEDATING
 | 3 | RENAILS | RETIDING | RECITING | OUTHEAL | SITULAE
 | 4 | RETIREE | RESINATE | DRAINERS | ORIENTERS | RENTING
 | 5 | TRANSITS | CAROTID | ORATION | TRASHES | ANDANTE
 | 6 | ENTRAIN | DONATES | HEADPIN | ENTRIES | INSANIE
 | 7 | SANDLOT | STEALING | RETUNES | [NAME] | SILURID
 | 8 | ANEROID | RETIRAL | NIOBATES | TITULAR | VENTAIL
 | 9 | SANDIER | ANOESTRI | WITTERS | REASTED | WINDORES
 | 10 | ENERVATE | OPTIONS | DAINTIER | NEEDIER | STACKING
 | 11 | SPEARING | GREEDILY | ROTULAE | COTERIES | SETTERS
 | 12 | [NAME] | MINERAL | PROTONS | TONEARMS | TERCIOS
 | 13 | CYANIZE | SENARII | SIOGNEE | FINALISE | DIPTERAN
 | 14 | ENTRIES | FORTLET | [NAME] | DAINTIER | BLOATED
 | 15 | TESTERN | DULCINEA | GARDENIA | OPTIONED | TINTIER
 | 16 | ENTAILER | SHOEMAN | PATTIES | DAINTIES | NITROSO
 | 17 | UNAIRED | DIARIES | DETRAINS | LINEATE | KYANISE
 | 18 | WAITERS | TRENTAL | MEETINGS | HINTERS | PARENTED
 | 19 | TRAILER |  | GRANULAR | INVADES | MARDIES
 | 20 | SAUNTERER
 |  | 2023-12-31 00:00:00
 |  |  |  |  |  | MANJI
Spreadsheet: 84573d1284624039-attaching-store-rates-store-rates
Sheet: Sheet1

 | Store No | Store Name | Over 19 | Over 19 | Over 19 |  | Under 19 |  | under19
1051 | 51 |  | 5.73 | 5.8 | 5.93 |  | 4.77 | 4.83 | 4.92
1053 | 53 |  | 5.73 | 5.8 | 5.93 |  | 5.41 | 5.41 | 5.5182
1057 | 57 |  | 5.73 | 5.8 | 5.93 |  | 4.77 | 4.83 | 4.92
1061 | 61 |  | 5.73 | 5.8 | 5.93 |  | 4.77 | 4.83 | 4.92
1062 | 62 |  | 5.73 | 5.8 | 5.93 |  | 4.77 | 4.83 | 4.92
Spreadsheet: 754330d1636116351-sumifs-on-one-tab-taking-data-from-4-tabs-eh_service-support-management-db_v2
Sheet: Lists

10 |  | 4 | 4 | 5
Employee | Task | SRM Lead | Month | Client list |  |  |  |  | Clients (input names here) |  |  |  | High | On hold
[NAME] | Holiday | [NAME] | January |  |  |  |  |  | Client 1 |  |  |  | Medium | In progress
[NAME] | Training | [NAME] | February | Client 12 |  |  |  |  | Client 2 |  |  |  | Low | Completed
[NAME] | Client Call | [NAME] | March | Client 2 |  |  |  |  | Client 4 |  |  |  | N/A
[NAME] | Client Project | [NAME] | April | Client 3 |  |  |  |  | Client 3
[NAME] | GCD |  | May | Client 4 |  |  |  |  | Client 7
[NAME] |  |  | June | Client 5 |  |  |  |  | Client 12
[NAME] |  |  | July | Client 6 |  |  |  |  | Client 6
[NAME] |  |  | August | Client 7 |  |  |  |  | Client 5
[NAME] |  |  | September | 0
[NAME] |  |  | October
[NAME] |  |  | November
[NAME] |  |  | December
[NAME]
[NAME]
[NAME]
[NAME]
Cristhian [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Ernest Talia
[NAME]
[NAME]
Genevieve   Knapp
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Julia  Hegwood
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Krisaundra Hightower
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Micah Chokeir
Micah Talia
Michelle  Greenwell
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Saif Perrine
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Tiffany M Blake
[NAME]
[NAME]
[NAME]
Yvette Hurtado