tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 872794d1719238275-power-query-pivot-table-timesheet-query-1
Sheet: Empl1

Name | Dept | W/E | Proj1 | [NAME] | Proj2 | Holiday Taken | Bank Holiday | Sickness
Empl1 | Detp1 | 2024-04-07 00:00:00 | 0 | 0 |  | 1.7
 |  |  | 7 | 5 |  | 0
 |  |  | 10.75 | 3 |  | 0
 |  |  | 14.5 | 9 |  | 0
 |  |  | 19.5 | 1 |  | 0
 |  |  | 19.5 | 2.75 |  | 0
 |  |  | 14.25 | 2.75 |  | 0
 |  |  | 11.5 | 4 |  | 0
 |  |  | 12 | 2.5 |  | 10
 |  |  | 16.25 | 2.75 |  | 0
 |  |  | 100
Spreadsheet: 870420d1716934060-barclays-premier-league-best-11-for-2024-toty-23-24-premier-league-alif
Sheet: Sheet10

 |  |  |  | # | Player | Club
 |  |  |  | 1 | Erling Haaland | Manchester City
 |  |  |  | 2 | [NAME] | Manchester City
 |  |  |  | 3 | [NAME] | Newcastle United
 |  |  |  | 4 | [NAME] | Liverpool FC
 |  |  |  | 5 | [NAME] | Arsenal FC
 |  |  |  | 6 | [NAME] | [NAME]
 |  |  |  | 7 | Rasmus Højlund | [NAME]
 |  |  |  | 8 | [NAME] | Brighton & Hove Albion
 |  |  |  | 9 | [NAME] | [NAME]
 |  |  |  | 10 | [NAME] | Brighton & Hove Albion
 |  |  |  | 11 | Matheus Cunha | [NAME]
 |  |  |  | 12 | Richarlison | [NAME]
 |  |  |  | 13 | [NAME] | Chelsea FC
 |  |  |  | 14 | [NAME] | AFC Bournemouth
 |  |  |  | 15 | [NAME] | Arsenal FC
 |  |  |  | 16 | [NAME] | [NAME]
 |  |  |  | 17 | [NAME] | Fulham FC
 |  |  |  | 18 | [NAME] Hwang | [NAME]
 |  |  |  | 19 | Dominic [NAME] | [NAME]
 |  |  |  | 20 | Beto | [NAME]
 |  |  |  | 21 | Enes Ünal | AFC Bournemouth
 |  |  |  | 22 | Odsonne Edouard | Crystal Palace
 |  |  |  | 23 | [NAME] | [NAME]
 |  |  |  | 24 | [NAME] | [NAME]
 |  |  |  | 25 | [NAME] | Sheffield United
 |  |  |  | 26 | Zeki Amdouni | Burnley FC
 |  |  |  | 27 | [NAME] | Burnley FC
 |  |  |  | 28 | Carlton Morris | [NAME]
 |  |  |  | 29 | [NAME] | Newcastle United
 |  |  |  | 30 | [NAME] | [NAME]
 |  |  |  | 31 | [NAME] | [NAME]
 |  |  |  | 32 | [NAME] | [NAME]
 |  |  |  | 33 | Jean-Philippe Mateta | Crystal Palace
 |  |  |  | 34 | [NAME] Fofana | Burnley FC
 |  |  |  | 35 | [NAME] | Fulham FC
 |  |  |  | 36 | [NAME] | Chelsea FC
 |  |  |  | 37 | Chermiti | [NAME]
 |  |  |  | 38 | [NAME] | West Ham United
 |  |  |  | 39 | [NAME] | [NAME]
 |  |  |  | 40 | [NAME] | West Ham United
 |  |  |  | 41 | [NAME] | Fulham FC
 |  |  |  | 42 | [NAME] | Brighton & Hove Albion
 |  |  |  | 43 | Divock Origi | [NAME]
 |  |  |  | 44 | [NAME] | Sheffield United
 |  |  |  | 45 | [NAME] | Crystal Palace
 |  |  |  | 46 | [NAME] | [NAME]
 |  |  |  | 47 | [NAME] | Sheffield United
 |  |  |  | 48 | [NAME] | Sheffield United
 |  |  |  | 49 | [NAME] | [NAME]
 |  |  |  | 50 | [NAME] | [NAME]
 |  |  |  | 51 | [NAME] | Burnley FC
 |  |  |  | 52 | Cauley Woodrow | [NAME]
 |  |  |  | 53 | Divin Mubama | West Ham United
 |  |  |  | 54 | [NAME] | Sheffield United
 |  |  |  | 55 | [NAME] | [NAME]
Spreadsheet: 124799d1318611844-conditionally-show-sheets-based-on-drop-down-disaster-drill-template
Sheet: Program 2

2012 Disaster Drill Tracking Sheet
Program 2
 | Example | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total Drills | Total Evacs
Missing Person/Search | TTD | FWT |  |  |  |  |  |  |  |  |  |  |  | 1 | 0
Medical Emergencies |  |  | TTD |  |  |  |  |  |  |  |  |  |  | 1 | 0
Violent/Threatening Situations |  |  |  | TTD |  |  |  |  |  |  |  |  |  | 1 | 0
Gas Leak |  |  |  |  | EAS |  |  |  |  |  |  |  |  | 1 | 1
Loss of Water/Contamination |  |  |  |  |  | FWT |  |  |  |  |  |  |  | 1 | 0
Loss of Electricity, Heat and AC |  |  |  |  |  |  | TTD |  |  |  |  |  |  | 1 | 0
Chemical Spill/Release |  |  |  |  |  |  |  | EAS |  |  |  |  |  | 1 | 1
Severe Storms/ Flooding |  |  |  |  |  |  |  |  | TTD |  |  |  |  | 1 | 0
Terrorist/Radiological | EAS |  |  |  |  |  |  |  |  | FWT |  |  |  | 1 | 0
Explosion |  |  |  |  |  |  |  |  |  |  | TTD |  |  | 1 | 0
[NAME] |  |  |  |  |  |  |  | EOS |  |  |  | TTD |  | 2 | 1
Continuity of Operations Plan (COOP) | EOS |  |  |  |  |  |  |  |  |  |  |  | TTD | 1 | 0
Bomb Threat/Suspicious Mail | FWT |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | 13 | 3
Legend |  |  |  |  |  |  |  |  | Compliance
TTD  - Tabletop Drill |  |  |  |  |  |  |  |  |  | Drills |  |  | Evacs
FWT - Functional Walk Through |  |  |  |  |  |  |  |  | Completed | 12 |  | Completed | 2
EOS  - Evacuation On Site |  |  |  |  |  |  |  |  | Required | 13 |  | Required | 2
EAS  - Evacuation to Alternate Site |  |  |  |  |  |  |  |  | TOTAL | 0.9230769230769231 |  | TOTAL | 1
Spreadsheet: 781981d1653664821-date-time-group-dtg-formulas-3-dtg-formulas
Sheet: DTG #1 Decimal Seconds

 |  |  | Start Time | End Time | Formula #1 Time Transpired (In Minutes) | Formula #2 Time Transpired (In Minutes) | Formula #3 Time Transpired (In Minutes) | Time Greater Than 60 min? | Duration in Hours & Minutes | [mm]:ss
JAN | 1 |  | 170340Z Mar21 | 170359Z Mar21 |  |  |  |  |  |  | START Time |  |  |  | END Time
FEB | 2 |  | 170340.2Z Mar21 | 170359.6Z Mar22 |  |  |  |  |  |  | DDhhmm.s MMMYY |  |  |  | DDhhmm.s | MMM YR
MAR | 3 |  | 170340.2Z Mar21 | 170359.6Z Mar21 |  |  |  |  |  |  | 012345.3 APR 22 |  |  |  | 100130.2 APR 22
APR | 4 |  | 170340Z Apr22 | 010359Z May22
MAY | 5 |  | 170340.2Z Mar24 | 010359.2Z May23 |  |  |  |  |  |  | =UPPER(TEXT($I$4&$J$4*24,"dd hhmmZ mmm yy")) |  |  |  | =UPPER(TEXT($M$4&$N$4*24,"ddhhmmZ mmm yy"))
JUN | 6 |  |  |  |  |  |  |  |  |  | =TEXT($I$4&$J$4*24,"dd hhmmZ mmm yy") |  |  |  | =TEXT($M$4&$N$4*24,"ddhhmmZ mmm yy")
JUL | 7 |  | 271022.2Z MAY22 | 271123.3Z MAY22
AUG | 8 |  |  |  |  |  |  |  |  |  | =DATE(RIGHT(I4,2),VLOOKUP(LEFT(J4,3),{"Jan",1;"Feb",2;"Mar",3;"Apr",4;"May",5;"Jun",6;"Jul",7;"Aug",8;"Sep",9;"Oct",10;"Nov",11;"Dec",12},2,0),LEFT(I4,2))+TEXT(RIGHT(I4,4),"00\:00")
SEP | 9
OCT | 10
NOV | 11
DEC | 12
Spreadsheet: louise_kitchen__24242__JulYTD Orig w notes
Sheet: Southeast Power

Southeast Power
Originator |  | Commodity |  | Team |  | Total |  | %Total
Kroll |  | Power |  | Southeast
Pagan |  | Power |  | Southeast |  | 313600
Rorschach |  | Power |  | Southeast |  | 234600
Braddock |  | Power |  | Southeast
Schultz |  | Power |  | Southeast |  | 50000
[NAME] |  | Power |  | Southeast |  | 23632
Acevedo |  | Power |  | Southeast
[NAME] |  | Power |  | Southeast |  | -54615
Total
Spreadsheet: 762485d1641574414-combine-columns-in-two-filter-functions-book2-1-1-
Sheet: Sheet1

Fruits | Price | Date | Pieces
Apple | 5 | 2022-12-01 00:00:00 | 50
Apple | 6 | 2022-12-02 00:00:00 | 50
Lemon | 3 | 2022-12-01 00:00:00 | 50
 |  |  |  |  |  | Vegs | Price | Date | Pieces |  |  |  | 2022-12-01 00:00:00 | 50
 |  |  |  |  |  | Tomato | 5 | 2022-12-01 00:00:00 | 25 |  |  | Apple | 2022-12-02 00:00:00 | 50
 |  |  |  |  |  | Lettuce | 5 | 2022-12-02 00:00:00 | 30 |  |  | Tomato | 2022-12-01 00:00:00 | 25
 |  |  |  |  |  | Tomato | 3 | 2022-12-08 00:00:00 | 20 |  |  | Tomato | 2022-12-08 00:00:00 | 20
 |  |  |  |  |  | Tomato | 1 | 2022-12-19 00:00:00 | 111 |  |  | Tomato | 2022-12-19 00:00:00 | 111
Spreadsheet: 859446d1707832966-create-custom-search-query-based-on-items-selected-in-a-list-sample-workbook
Sheet: Sheet1

Select | Name | Syntax
Y | Chicken | "Chicken"
Y | Beef | "Beef" OR "Cow" OR "Veal"
 | Pork | "Pork" OR "Pig"
Y | Turkey | "Turkey"
 | [NAME] | "[NAME]" OR "Deer"
 | Duck | "Duck"
Y | Goose | "Goose"
 |  |  |  | Desired output: | "Chicken" OR "Beef" OR "Cow" OR "Veal" OR "Turkey" OR "Goose"
Spreadsheet: 08886c44-1397-418e-8c9d-64886ce8cb4d
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
 | 5671.0 Lending Finance, Australia
 | TABLE 18. COMMERCIAL FINANCE COMMITMENTS, Revolving Credit By Industry: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Agriculture, forestry and fishing ; |  |  | Original | A2414246T | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Mining ; |  |  | Original | A2414247V | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Manufacturing ; |  |  | Original | A2414248W | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Construction ; |  |  | Original | A2414249X | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Wholesale trade ; |  |  | Original | A2414250J | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Retail trade ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Transport and storage ; |  |  | Original | A2414252L | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Finance and insurance ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Property and business services ; |  |  | Original | A2414254T | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Cultural, recreational, personal and other services ; |  |  | Original | A2414255V | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Public administration ; |  |  | Original | A2414256W | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Health and community services ; |  |  | Original | A2414257X | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Other industries ; |  |  | Original | A2414258A | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
TOTAL REVOLVING CREDIT ; |  |  | Original | A2414259C | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 128679d1321198610-conditional-formatting-using-formulas-book1-_masond3
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | C/F Proving table for checking only, can be deleted.
 |  | a1 | b1 | c1 | d1 | e1 | f1
 |  | - | 12 | 160 | 1 | 24 | 1
 |  | - | 1 | 27 | 1 | 2 | 1
 |  | - | 1 | 16 | 1 | 30 | 9
 |  | - | 2 | 14 | 1 | 7 | 33
 |  | - | 1 | 10 | 1 | 11 | 1
 |  | - | 4 | 4 | 4 | 1 | 1
 |  | - | - | - | - | 1 | 1
 |  | - | - | - | - | 1 | 1
 |  | - | - | - | 1 | 1 | 1
 |  | - | - | - | 6 | 12 | 88
 |  | - | - | - | - | 2 | 28
 |  | - | - | - | 3 | 1 | 27
 |  | - | - | - | - | 1 | 8
 |  | - | - | - | - | - | -
 |  | - | - | - | 5 | - | -
 | averages per column | 11 | 4 | 11 | 5 | 8 | 21
Spreadsheet: 11a5fd0f-7f2b-4156-8487-c92800e88dfb
Sheet: $ FY09 content

Expenditures for Year's Content, FY08 and FY09
Serials | FY08 | FY09 | % change | % of total FY09 expend.
Kingston serials funds | 2487631.92 | 2296092.17
[NAME] (pelp) | 33309.56 | 27264.41
CCE (ccep) | 47909.7 | 4194.3
Endowments (Kingston) | 28937.65 | 36466.84
TOTALS
Monographs | FY08 | FY09 | % change | % of total FY09 expend.
Kingston monographs | 295228.27 | 285640.14
[NAME] | 3394.16 | 2168.62
CCE | 18689.92 | 7058.43
Endowments (Kingston) | 18787.37 | 21098.01
TOTALS
Spreadsheet: mark_guzman__24544__west prices1005
Sheet: Power West Price Peak

 |  | 2000 |  |  |  |  | 2001 |  |  |  | 2002 | 2003 |  |  | 2004-2014
Peak | 2000-08-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 | Cal-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Cal-01 | Cal-02 | Cal-03 | Q1 | Q2 | Q3 | Q4 | Cal 04-14
MID-COLUMBIA
COB
NP15
ZP26
SP15
Palo Verde
ROCKIES
Price change |  | 2000 |  |  |  |  | 2001 |  |  |  | 2002 | 2003 |  |  | 2004-2014
Peak | 2000-08-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 | Cal-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Cal-01 | Cal-02 | Cal-03 | Q1 | Q2 | Q3 | Q4 | Cal 04-14
MID-COLUMBIA
COB
NP15
ZP26
SP15
Palo Verde
ROCKIES
 |  | 2000 |  |  |  |  | 2001 |  |  |  | 2002 | 2003 |  |  | 2004-2014
Peak | 2000-08-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 | Cal-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Cal-01 | Cal-02 | Cal-03 | Q1 | Q2 | Q3 | Q4 | Cal 04-14
MID-COLUMBIA | 0 | 124 | 111 | 110 | 115 | 86.25 | 68.33333333333333 | 143.6666666666667 | 83.58333333333333 | 95.45833333333333 | 65.22916666666667 | 57.20815833333334 | 33.5618356060606 | 25.47850227272728 | 72.10606060606061 | 43.06183560606059 | 43.55205852272726
COB | 0 | 129 | 112 | 110 | 117 | 86.5 | 67.16666666666667 | 146.6666666666667 | 78.83333333333333 | 94.79166666666667 | 67.16666666666667 | 59.43732500000001 | 39.62450151515151 | 34.29116818181818 | 83.12878787878788 | 48.29116818181819 | 51.33390643939394
NP15 | 0 | 123 | 99.5 | 96.5 | 106.3333333333333 | 79.25 | 62 | 123.3333333333333 | 68.33333333333333 | 83.22916666666666 | 61.16666666666666 | 56.56166666666667 | 36.94484848484848 | 35.6360606060606 | 68.67030303030302 | 42.74763447406666 | 45.99971164881968
ZP26 | 0 | 107 | 81.5 | 77 | 88.5 | 68.66666666666667 | 62 | 123.1666666666667 | 60.66666666666666 | 78.625 | 55.84166666666667 | 47.02333333333333 | 32.92405641291082 | 33.67630517976258 | 59.52122530843663 | 34.78605445748052 | 40.22691033964764
SP15 | 0 | 105 | 81.5 | 77 | 87.83333333333333 | 68.66666666666667 | 71 | 126.3333333333333 | 61.33333333333334 | 81.83333333333333 | 57.55 | 47.04083333333333 | 32.92405641291082 | 35.51642746661356 | 59.52122530843663 | 34.78605445748052 | 40.68694091136038
Palo Verde | 0 | 112 | 81 | 76 | 89.66666666666667 | 67.66666666666667 | 73.83333333333333 | 143.3333333333333 | 62.83333333333334 | 86.91666666666667 | 58.91391796855211 | 49.20789322330557 | 32.21500177876086 | 37.29724582614169 | 61.47854780013596 | 35.78480562116557 | 41.69390025655102
ROCKIES | 0 | 112 | 81 | 96 | 96.33333333333333 | 87.66666666666667 | 93.83333333333333 | 163.3333333333333 | 82.83333333333333 | 106.9166666666667 | 78.9139179685521 | 69.20789322330556 | 52.21500177876086 | 57.29724582614169 | 81.47854780013596 | 55.78480562116555 | 61.69390025655102
Spreadsheet: 811832d1672824785-formula-to-return-sum-with-multiple-criteria-index-match-problem
Sheet: sum

client ID
 |  |  | 100700 | product group
4 | client x
5 | client y |  |  | why this cell is blank when client wit ID 5 have value in sheet dec22
8 | client z
49 | client q
54 | client ab
71 | client bc
88 | client cd
Spreadsheet: 700646d1603278561-returning-results-from-multiple-values-multiple-value
Sheet: Sheet1

Payment Plan Name | Category | Term |  | Containing | Category
N Silver 12 CCM | Silver | CCM |  | Gym Only | Silver Gym
(R) Silver 6 | Silver | Prepaid |  | [NAME] Only | [NAME]
(R) Gold 6 Gymx | Gold Gymnastics | Prepaid |  | [NAME] Only | [NAME]
LT (R) Silver 12 CCM | Silver | CCM |  | [NAME] | [NAME]
(R) Silver 12 CCM | Silver | CCM |  | [NAME] | [NAME]
(R) Platinum 1 | Platinum | Prepaid |  | Silver Gym Only | Silver
Gym 3 | Silver | Prepaid |  | Silver BJJ Only | Silver MA
(R) Silver 12 CCM | Silver | CCM |  | [NAME] | Silver MA
(R) Platinum 6 | Platinum | Prepaid |  | Silver Gymnastics | Silver Gymnastics
N (R) Platinum 12 CCM | Platinum | CCM |  | Gold MA | Gold MA
Silver 12 CCM | Silver | CCM |  | Gold Gymnastics | Gold Gymnastics
(R) Gym 3 | Silver | Prepaid |  | Platinum | Platinum
(R) Silver 1 | Silver | Prepaid
[NAME] MA | Silver MA | Prepaid
Platinum 12 CCM | Platinum | CCM
(R) Silver 12 CCM | Silver | CCM
(R) Silver 12 CCM | Silver | CCM
(R) Silver 3 | Silver | Prepaid
Silver 12 CCM | Silver | CCM
Silver 12 CCM | Silver | CCM
(R) Gym 3 | Silver | Prepaid
Silver 3 | Silver | Prepaid
(R) Platinum 12 CCM | Platinum | CCM
(R) Silver 12 | Silver | Prepaid
(R) Platinum 3 | Platinum | Prepaid
Gold 3 Gymx | Gold Gymnastics | Prepaid
Gold 12 MA CCM | Gold MA | CCM
(R) Silver 12 CCM | Silver | CCM
LT (R) Silver 12 CCM | Silver | CCM
Silver 12 | Silver | Prepaid
(R) Platinum 3 | Platinum | Prepaid
Silver 12 | Silver | Prepaid
(R) Gym 3 | Silver | Prepaid
Silver 12 | Silver | Prepaid
(R) Gym 3 | Silver | Prepaid
(R) Gym 3 | Silver | Prepaid
(R) Platinum 6 CCM | Platinum | CCM
Spreadsheet: 144684d1331097121-excel-2007-index-match-multiple-criteria-formula-criterial
Sheet: Sheet1

Criteria 1,2,3 | [NAME] |  |  |  | Criteria 1,2,3,4 |  |  |  |  |  |  | Criteria 1 | [NAME] | Criteria 3 | [NAME]
0010 | 1 |  |  |  | 0010- - - 1 |  |  |  |  |  |  | 0010 |  |  | 1
0011 | 2 |  |  |  | 0011- - - 2 |  |  |  |  |  |  | 0011 |  |  | 2
4000-405-800 | 3 |  |  |  | 4000-405-800-3 |  |  |  |  |  |  | 4000 | 405 | 800 | 3
4000-201-103 | 4 |  |  |  | 4000-201-103-4 |  |  |  |  |  |  | 4000 | 201 | 103 | 4
 |  |  |  | Choose any one option from above three set of criterias.
 |  |  |  | Note: you need to provide the period as well into the criteria as without this, Excel would not be able to understand which period you want from 1,2 3…. etc
Spreadsheet: 685121d1593747031-difficulties-using-solver-for-staff-schedule-complicated-criteria-set-schedule2
Sheet: Constraints(SA)

Count of Skill
SA
 |  | Employee
Date | Week | [NAME] | [NAME] | Ayisha | [NAME] | Kaitlin | Jayme | [NAME] | [NAME] | Felix | [NAME] | Casual1 | Casual2 | Casual3 | Casual4 | Casual5
must be <= target | Total
 | Target
 | Trained
Spreadsheet: 356230d1415032773-retain-current-cell-value-if-the-next-iteration-returns-false-sample-2
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  | choose
 |  |  |  | Cycle | Plan 1 | Plan 2 | Plan 3 | Plan 4 |  |  | Plan 4
 |  |  |  | 1 | 6 | 6 | 6 | 10
 |  |  |  | 2 | 6 | 6 | 4 | 10
 |  |  |  | 3 | 6 | 6 | 6 | 4
 |  |  |  | 4 | 6 | 6 | 4 | 4
 |  |  |  | 5 | 4 | 6 | 3 | 4
 |  |  |  | 6 | 4 | 6 | 3 | 4
 |  |  |  | 7 | 6 | 6 | 4 | 4
 |  |  |  | 8 | 6 | 6 | 4 | 4
 |  |  |  | 9 | 2 | 4 | 2 | 4
 |  |  |  | 10 | 2 | 4 | 2 | 4
 |  |  |  | 11 | 4 | 6 | 4 | 4
 |  |  |  | 12 | 6 | 8 | 10 | 4
 |  |  |  | 13 | 6 | 8 | 4 | 4
 |  |  | May |  | 0 | 0 | 0 | 376.3199999999998
 |  |  | June |  | 0 | 0 | 0 | 423.3599999999998
 |  |  | July |  | 0 | 0 | 0 | 282.2399999999999 |  |  |  |  | the data in f17 - i25 should remain visible and update on a change in sheet 1 c3 - f12
 |  |  | August |  | 0 | 0 | 0 | 329.2799999999999
 |  |  | September |  | 0 | 0 | 0 | 94.07999999999998
 |  |  | widgets |  | 0 | 0 | 0 | 1505.279999999999
 |  |  | Hours |  | 0 | 0 | 0 | 149
 |  |  | Days |  | 0 | 0 | 0 | 121
Spreadsheet: 768656d1645067088-find-and-extract-the-website-link-from-range-of-cells-question-find-the-website-link
Sheet: Sheet1

Link1 | Link2 | Link3 | Link4 | Website (desired output) |  | Not Criteria
https://twitter.com/1RoyaltyFinance |  |  |  |  |  | twitter
https://discord.com/invite/YK9C2g9V | https://t.me/gemstonefin | https://twitter.com/GemstoneFIn |  |  |  | discord
https://discord.com/invite/ZkwmrsmBjS | https://twitter.com/CprosOffical |  |  |  |  | t.me
https://discord.gg/EPUJ5g7s6E | https://twitter.com/7ombfinance
https://discord.gg/gNck2abDVb | https://t.me/CometFinanceANN | https://twitter.com/CometFinance88
https://discord.com/invite/JrNGTp8sgE | https://twitter.com/ygg_finance
https://discord.gg/B9QTTcsE7F | https://t.me/printerfinancial | https://twitter.com/FinancePrinter | https://bsc.printer.financial/ | https://bsc.printer.financial/
https://twitter.com/ViosFinance
https://discord.gg/zDv4gyfxjH | https://t.me/BourbonDao | https://twitter.com/financebourbon | http://bourbondefi.com/ | http://bourbondefi.com/
https://discord.com/invite/zW66nhnBam | https://twitter.com/Forkfinance_ | https://www.forkfinance.com/ |  | https://www.forkfinance.com/
https://discord.com/invite/qrrQ4rKwtT | https://t.me/PartialFinance | https://twitter.com/PartialFinance | https://partial.finance/ | https://partial.finance/
https://discord.gg/5cA9MVQtjZ | https://.twitter.com/FinanceDevilx | https://devilx.finance/ |  | https://devilx.finance/
https://discord.gg/dWfd7rvbhV | https://twitter.com/BrrFinance | https://brrfinance.com/ |  | https://brrfinance.com/
https://twitter.com/dantefinance |  |  |  | ETC
https://discord.gg/TX8et2xSUQ | https://twitter.com/hyehfinance | https://hyeh.finance/
https://discord.com/invite/tQ2yBUJQ | https://t.me/+nMMoPYnE3_kxZjQ0 | https://twitter.com/BulFinance | https://bul.finance/
https://discord.com/invite/degenfinance | https://twitter.com/Degenfinancee | https://tombdegen.com/
https://discord.com/invite/akR7kpYMds | https://t.me/+KDlYhwRj5B9iYjI8 | https://twitter.com/ScarfaceFinance | https://scarface.finance/
https://discord.gg/x446WTzphe | https://t.me/polarisfinance | https://twitter.com/PolarisFinance_ | https://polarisfinance.io/
https://discord.gg/R27R2eb2jC | https://twitter.com/4PureOcean | https://www.pure-ocean.net/
https://discord.gg/veWvZt7qJV | https://twitter.com/zilla_finance | https://zillafinance.io/
https://t.me/peeldefi | https://twitter.com/PeelDefi | https://www.peeldefi.com/
https://discord.gg/QfVV5Ywprk | https://t.me/snowtombofficial | https://twitter.com/snow_tomb | https://www.frozentomb.finance/
https://discord.gg/gRz82229xw | https://twitter.com/finance_bat | https://batfi.xyz/
https://twitter.com/ZombiedotMoney | https://zombie.money/
https://t.me/+bczMZtCTlmEzMWZh | https://twitter.com/1ombfinance | https://1omb.finance/
https://discord.gg/QmFF3vsCQd | https://t.me/FarmThatChicken | https://twitter.com/farmthatchicken | https://mychicken.farm/
Spreadsheet: john_griffith__15670__05_11_01ON
Sheet: Sheet1

N
Commodity: | ON - NAT. GAS OPTS.
Month | STRIKE | BID | OFFER | Volatility | Future
M01-P/C | 425 | 33 | 35.5
N01-P/C | 435 | 62 | 65
Q01-P/C | 440 | 82 | 85
U01-P/C | 440 | 101 | 104
V01-P/C | 445 | 114 | 118
X01-P/C | 465 | 134 | 137
[NAME]-P/C | 480 | 152 | 155
F02-P/C | 485 | 166 | 171
G02-P/C | 475 | 172 | 177
H02-P/C | 455 | 157 | 162
J02-P/C | 425 | 116 | 126
K02-P/C | 415 | 110 | 120
M02-P/C | 420 | 113 | 123
U02-P/C | 425
Spreadsheet: sally_beck__35801__Summary Report for EOL 2-29
Sheet: RAW DATA

INDEX FOR RAW DATA DATABASE |  | 3
INDEX FOR RAW DATA LONDON |  | 7 | 7 | 30 | 24 | 25 | 28 | 7 | 22 | 16 | 17 | 20 | 7 | 14 | 8 | 9 | 12 | 7 | 30 | 24 | 25 | 28 | 7
 | COMMODITY | COMMODITY-TYPE | EOL FLAG | SumOfLTDDEAL | SumOfLTDVOLBUY | [NAME] | SumOfLTDAMTBUY | SumOfLTDAMTSELL | SumOfMTDDEAL | SumOfMTDVOLBUY | SumOfMTDVOLSELL | SumOfMTDAMTBUY | SumOfMTDAMTSELL | SumOfONEDEAL | SumOfONEVOLBUY | SumOfONEVOLSELL | SumOfONEAMTBUY | [NAME] | SumOfYTDDEAL | SumOfYTDVOLBUY | SumOfYTDVOLSELL | SumOfYTDAMTBUY | SumOfYTDAMTSELL
COAL-PHYSICAL=Yes | COAL
COAL-PHYSICAL=No | COAL
CONTINENTAL GAS-FINANCIAL=No | CONTINENTAL GAS
CONTINENTAL GAS-PHYSICAL=Yes | CONTINENTAL GAS
CONTINENTAL GAS-PHYSICAL=No | CONTINENTAL GAS
CONTINENTAL POWER-FINANCIAL=Yes | CONTINENTAL POWER
CONTINENTAL POWER-FINANCIAL=No | CONTINENTAL POWER
CONTINENTAL POWER-PHYSICAL=Yes | CONTINENTAL POWER
CONTINENTAL POWER-PHYSICAL=No | CONTINENTAL POWER
CRUDE & PRODUCTS-BASIS=Yes | CRUDE & PRODUCTS
CRUDE & PRODUCTS-BASIS=No | CRUDE & PRODUCTS
CRUDE & PRODUCTS-PHYSICAL=Yes | CRUDE & PRODUCTS
CRUDE & PRODUCTS-PHYSICAL=No | CRUDE & PRODUCTS
CRUDE & PRODUCTS-PRICE=Yes | CRUDE & PRODUCTS
CRUDE & PRODUCTS-PRICE=No | CRUDE & PRODUCTS
EMISSIONS-FINANCIAL=Yes | EMISSIONS
EMISSIONS-FINANCIAL=No | EMISSIONS
EMISSIONS-PHYSICAL=Yes | EMISSIONS
EMISSIONS-PHYSICAL=No | EMISSIONS
GAS-BASIS=Yes | GAS
GAS-BASIS=No | GAS
GAS-GAS DAILY=Yes | GAS
GAS-GAS DAILY=No | GAS
GAS-PHYSICAL=Yes | GAS
GAS-PHYSICAL=No | GAS
GAS-PRICE=Yes | GAS
GAS-PRICE=No | GAS
LPG-PHYSICAL=No | LPG
LPG-PRICE=Yes | LPG
LPG-PRICE=No | LPG
NORDIC POWER-FINANCIAL=Yes | NORDIC POWER
NORDIC POWER-FINANCIAL=No | NORDIC POWER
NORDIC POWER-PHYSICAL=No | NORDIC POWER
PAPER & PULP-PHYSICAL=No | PAPER & PULP
PAPER & PULP-PRICE=Yes | PAPER & PULP
PAPER & PULP-PRICE=No | PAPER & PULP
PETROCHEMICALS-PHYSICAL=Yes | PETROCHEMICALS
PETROCHEMICALS-PHYSICAL=No | PETROCHEMICALS
PETROCHEMICALS-PRICE=No | PETROCHEMICALS
PLASTICS-PRICE=Yes | PLASTICS
PLASTICS-PRICE=No | PLASTICS
POWER-PHYSICAL=Yes | POWER
POWER-PHYSICAL=No | POWER
UK GAS-FINANCIAL=Yes | UK GAS
UK GAS-FINANCIAL=No | UK GAS
UK GAS-PHYSICAL=Yes | UK GAS
UK GAS-PHYSICAL=No | UK GAS
UK POWER-FINANCIAL=Yes | UK POWER
UK POWER-FINANCIAL=No | UK POWER
WEATHER-FINANCIAL=Yes | WEATHER
WEATHER-FINANCIAL=No | WEATHER
Spreadsheet: 858888d1707392819-help-sumif-multiple-tabs-example2
Sheet: October

Name | NHS | 1st | 2nd | 3rd | Seen | Comments |  |  | Month Summary
Name 116
Name 117
Name 118 |  |  |  |  |  |  |  |  | Done Totals
Name 119 |  |  |  |  |  |  |  |  | Outstanding Totals
Name 120
Name 121
Name 122
Name 123
Name 124
Name 125
Name 126
Name 127