tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: benjamin_rogers__1028__Turbine Position Report 000908 Distrib
Sheet: Summary by Status

Turbine Position Report
Summary by Status
 |  |  |  | PRELIMINARY
UNITS | MODEL | CONTROLLED BY | PROJECT(S) | CONTRACT COST | PYMTS TO DATE | CANCEL- LATION | STATUS
COMMITTED
7 | Fr 6B 60hz power barges | APACHI | Nigeria [NAME] (APACHI) |  |  |  | Committed
2 | Fr 6B 50hz power barges | APACHI | Nigeria [NAME] (APACHI) |  |  |  | Committed
1 | 7FA - now simple cycle | ECP | East Coast Power - Linden 6 (ECP) |  |  |  | Committed
4 | LM6000 | ENA | City of Austin (ENA) |  |  |  | Committed
8 | LM6000 | ESA | Elektrobolt (ESA) |  |  |  | Committed
 |  |  | Total Committed
TENTATIVE
2 | Fr 6B 60hz power barges | CALME | LIPA (ENA) |  |  |  | Tentative
1 | 7FA - now simple cycle | EECC | NEPCO/NESCO Goldendale (EECC) |  |  |  | Tentative
2 | 7FA w/ STG | EECC | [NAME] (EECC) |  |  |  | Tentative
2 | 7FA w/ STG | EECC | Gen Power - McAdams (EECC) |  |  |  | Tentative
3 | 9FA STAG power islands | EECC | Spain Arcos (EEL) |  |  |  | Tentative
3 | 7FA | ENA | Pastoria (ENA) |  |  |  | Tentative
4 | LM6000 | ENA | Fountain Valley PSCO (ENA) |  |  |  | Tentative
4 | LM6000 | ENA | Las Vegas Cogen II (ENA) |  |  |  | Tentative
1 | 7FA | ENA | Vitro (ENA) |  |  |  | Tentative
 |  |  | Total Tentative
AVAILABLE
2 | 11N1 | Canada | Unassigned |  |  |  | Available
1 | 501D5A simple cycle | CALME | Sadaf bid (CALME) or 2001 [NAME] (ENA) or [NAME] (ENA) |  |  |  | Available
1 | 501D5A simple cycle | EECC | Sadaf bid (CALME) or 3rd party (EECC) |  |  |  | Available
2 | 7EA | EECC | Unassigned |  |  |  | Available
2 | LM6000 | ENA | [NAME] (ENA) |  |  |  | Available
1 | LM6000 | ENA | Tri-Valley (ENA) |  |  |  | Available
1 | LM6000 | ENA | LODI (ENA) |  |  |  | Available
1 | Steam Turbine | ENA | Unassigned |  |  |  | Available
2 | 501F simple cycle | ESA | [NAME] (ESA) |  |  |  | Available
2 | 501F simple cycle | ESA | [NAME] (ESA) |  |  |  | Available
 |  |  | Total Available
NEGOTIATING
2 | 501F MHI simple cycle | ESA | Unassigned |  |  |  | Negotiating
3 | 9F 50hz gas turbine power islands |  | Project Gemini (EECC) |  |  |  | Negotiating
1 | 7FA |  | Pastoria (ENA) |  |  |  | Negotiating
9 | 7EA |  | Trinidad and Tobago Aluminum Smelter Project |  |  |  | Negotiating
 |  |  | Total Negotiating
 |  |  | GRAND TOTALS
Spreadsheet: 765723d1643548914-ramp-up-calculation-of-sales-depending-on-staff-hire-date-staff-sales-ramp-up
Sheet: HR plan_sales rep

 |  |  | Target unit sold per month |  | 800
 |  |  | Ramp up matrix:
 |  |  | Month after onboarding | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12
 |  |  | % Sales performance | 0.05 | 0.2 | 0.3 | 0.4 | 0.5 | 0.5 | 0.65 | 0.75 | 1 | 1 | 1 | 1
 |  |  | Sold units
 |  |  |  | New hires per month
 |  |  | Year | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023
 |  |  | Startdate | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | TOTAL | Month 13 | Month 14 | Month 15 | Month 16 | Month 17 | Month 18 | Month 19 | Month 20 | Month 21 | Month 22 | Month 23 | Month 24 | TOTAL
 |  |  | Number of new hires
 |  |  | Sales Rep
 |  |  | Sales Rep 1 | 1
 |  |  | [NAME] |  |  |  |  | 3
 |  |  | [NAME] 3 |  |  |  |  |  |  |  |  | 1
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  | Year | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023
 |  |  | Startdate | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | TOTAL | Month 13 | Month 14 | Month 15 | Month 16 | Month 17 | Month 18 | Month 19 | Month 20 | Month 21 | Month 22 | Month 23 | Month 24 | TOTAL
 |  |  | Number of units sold per staff
 |  |  |  |  |  |  | etc…..
Spreadsheet: 409078d1437607287-hours-breakdown-ordinary-o-time-1-5-and-o-time-2-0-example_bc2
Sheet: Sheet1

Date | Name | Start | Finish | Ordinary | O/T 1.5 | O/T 2 | Total hrs
 | [NAME] | 22:00:00 | 05:00:00
2015-07-23 00:00:00 | [NAME] | 09:00:00 | 18:00:00
2015-07-24 00:00:00 | [NAME] | 06:00:00 | 20:00:00
2015-07-25 00:00:00 | [NAME] | 16:00:00 | 05:00:00
2015-07-26 00:00:00 | [NAME] | 16:00:00 | 05:00:00
Spreadsheet: 8b96f718-a6ee-4202-9964-0d7561c5d3bd
Sheet: Sheet1

Release: Harmonized Indices of Consumer Prices (HICP) | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=251
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-08-23 2:31 AM [NAME]
 | Real-Time | Period
Name: | Start | End
Harmonized Indices of Consumer Prices (HICP) | 2012-06-15 00:00:00 | Current
Link:
http://epp.eurostat.ec.europa.eu/portal/page/portal/hicp/data/main_tables | 2012-06-15 00:00:00 | Current
Source:
Eurostat | 2012-06-15 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2012-06-15 00:00:00
2012-07-15 00:00:00
2012-08-16 00:00:00
2012-09-14 00:00:00
2012-10-16 00:00:00
2012-11-15 00:00:00
2012-12-14 00:00:00
2013-01-16 00:00:00
2013-02-28 00:00:00
2013-03-15 00:00:00
2013-04-16 00:00:00
2013-05-16 00:00:00
2013-06-14 00:00:00
2013-07-16 00:00:00
2013-08-16 00:00:00
2013-09-16 00:00:00
2013-10-16 00:00:00
2013-11-15 00:00:00
2013-12-20 00:00:00
2014-01-21 00:00:00
2014-02-24 00:00:00
2014-03-17 00:00:00
2014-04-21 00:00:00
2014-05-16 00:00:00
2014-06-16 00:00:00
2014-07-17 00:00:00
2014-08-14 00:00:00
Spreadsheet: 46451d1245318846-if-statement-or-vlookup-help-copy-of-example6
Sheet: Special Agreements By Code

Special Agreements By Code
Trade | Customer Name | Named Account | Contract Number | Description | Name | POL | POD | 20ft | 40ft | TEU
AUSTRALIA | a | AUS/NZ MEAT | 34 | 20RE: 7 free days, day 8-14 £60 per day, £90 per day thereafter. 40RE AND 40HR: 7 free days, day 8-14 £80 per day, £140 per day thereafter. | Demurrage - POD | All Ports | FELIXSTOWE
AUSTRALIA | b | AUS/NZ MEAT | 65 | 20RE: 7 free days, day 8-14 £60 per day, £90 per day thereafter. 40RE AND 40HR: 7 free days, day 8-14 £80 per day, £140 per day thereafter. | Demurrage - POD | All Ports | TILBURY
AUSTRALIA | c | BRISTOL QUAY DEVAN | 23 | No LoLo if devan on quay | LO/LO | All Ports | BRISTOL
AUSTRALIA | d | Constellation | 46 | 14 FREE DAYS | Demurrage - POD | All Ports | All Ports
AUSTRALIA | e | Constellation | 67 | No Lo/Lo | LO/LO | All Ports | BRISTOL
AUSTRALIA | f | Constellation | 68 | 14 FREE DAYS | Demurrage - POD | All Ports | All Ports
AUSTRALIA | g | Constellation | 69 | NO LO/LO | LO/LO | All Ports | All Ports
AUSTRALIA | h | Constellation | 74 | 14 free days | Demurrage - POD | All Ports | All Ports
AUSTRALIA | i | Constellation | 76 | NIL | LO/LO | All Ports | BRISTOL
AUSTRALIA | j | Constellation | 79 | 14 free days | Demurrage - POD | All Ports | All Ports
AUSTRALIA | k | Constellation | 12 | NIL | LO/LO | All Ports | BRISTOL
AUSTRALIA | l | DEVAN ON QUAY | 14 | 10 FREE DAYS | Demurrage - POD | All Ports | All Ports
AUSTRALIA | m | DEVAN ON QUAY | 16 | NO LO/LO IF DEVANED ON QUAY | LO/LO | All Ports | All Ports
Spreadsheet: 5706a5b0-aba9-4c68-b04d-853649541e51
Sheet: FTSE Summary

Average Total Expenditure per Full-Time Student Equivalent (FTSE)
Institution | Annual State Funded Semester Credit Hours | Total FTSE | Total Expenditure | Average Expenditure per FTSE
Alamo | 1150767
Alvin | 109654
Amarillo | 213908
Angelina | 115461
[NAME] | 841118
Blinn | 390889
Brazosport | 82319
Central Texas | 322601
Cisco | 97474
[NAME] | 36049
Coastal Bend | 84482
College Of The Mainland | 89076
Collin | 534420
Dallas | 1434012
Del Mar | 233439
El Paso | 576460
[NAME] | 24684
Galveston | 48686
[NAME] | 117086
Hill | 97856
Houston | 1174406
[NAME] | 88350
Kilgore | 145760
Laredo | 189345
[NAME] | 143174
Lonestar | 1139753
[NAME] | 224617
Midland | 127007
Navarro | 243241
North Central Texas | 181189
Northeast Texas | 68492
Odessa | 100321
Panola | 48696
Paris | 133600
Ranger | 32208
San Jacinto | 621630
South Plains | 217696
South Texas | 550135
Southwest Texas | 117098
Tarrant | 992819
Temple | 123274
Texarkana | 88663
Texas Southmost | 196366
Trinity Valley | 169107
Tyler | 263418
Vernon | 67120
Victoria | 84659
Weatherford | 117302
Western Texas | 46143
[NAME] | 147787
TSTC-Harlingen | 133661
TSTC-West Texas | 28905
TSTC-Marshall | 22996
TSTC-Waco | 28905
Lamar-IOT | 66956
[NAME] | 55853
[NAME] | 59502
Total for Instutions Reporting Expense
Spreadsheet: 148396d1333386915-creating-a-report-to-show-vehicle-tax-due-tax-disc-log
Sheet: BD52 EOS

 |  |  |  |  | BD52 EOS
Registration number : | BD52 EOS |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | VOLVO |  |  | 12 Months | 2004-01-01 00:00:00 | 650
Specification : | 6 x 2 RCT |  | 2003-12-31 00:00:00 | 12 Months | 2005-01-01 00:00:00 | 650
Type : | FM9 |  | 2004-12-31 00:00:00 | 12 Months | 2006-01-01 00:00:00 | 650
1st Registered : | 01.01.03 |  | 2005-12-30 00:00:00 | 12 Months | 2007-01-01 00:00:00 | 650
Engine : | D9A300 EC01 |  | 2006-12-29 00:00:00 | 12 Months | 2008-01-01 00:00:00 | 650
[NAME] : | 26,000kg |  | 2007-12-28 00:00:00 | 12 Months | 2009-01-01 00:00:00 | 650
 |  |  | 2008-12-29 00:00:00 | 12 Months | 2010-01-01 00:00:00 | 650
 |  |  | 2009-12-30 00:00:00 | 12 Months | 2011-01-01 00:00:00 | 650
 |  |  | 2010-12-30 00:00:00 | 12 Months | 2012-01-01 00:00:00 | 650
Back To Index |  |  | 2011-12-29 00:00:00 | 12 Months | 2013-01-01 00:00:00 | 650
Spreadsheet: 837169d1689897532-how-can-i-get-data-from-another-sheet-with-formula-allsolution-rotation-schedule-multiple-employees-1-edited
Sheet: DaysOff

Days Off: Vacation, Sick Leave, Personal Leave
Date | Employee | Type | Lookup Value |  | V = Vacation
2022-01-15 00:00:00 | Employee 1 | V |  |  | S = Sick Leave
2022-10-26 00:00:00 | Employee 2 | V |  |  | P = Personal Leave
2022-01-16 00:00:00 | Employee 1 | S
2022-01-17 00:00:00 | Employee 1 | P
 |  |  |  | ◄ Insert more rows ABOVE this one
Spreadsheet: kevin_ruscitti__20326__Apr_Flows
Sheet: Michcon

 | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun |  |  | Mon | Tue | Wed
 | 2000-04-01 00:00:00 | 2000-04-02 00:00:00 | 2000-04-03 00:00:00 | 2000-04-04 00:00:00 | 2000-04-05 00:00:00 | 2000-04-06 00:00:00 | 2000-04-07 00:00:00 | 2000-04-08 00:00:00 | 2000-04-09 00:00:00 | 2000-04-10 00:00:00 | 2000-04-11 00:00:00 | 2000-04-12 00:00:00 | 2000-04-13 00:00:00 | 2000-04-14 00:00:00 | 2000-04-15 00:00:00 | 2000-04-16 00:00:00 | 2000-04-17 00:00:00 | 2000-04-18 00:00:00 | 2000-04-19 00:00:00 | 2000-04-20 00:00:00 | 2000-04-21 00:00:00 | 2000-04-22 00:00:00 | 2000-04-23 00:00:00 | 2000-04-24 00:00:00 | 2000-04-25 00:00:00 | 2000-04-26 00:00:00 | 2000-04-27 00:00:00 | 2000-04-28 00:00:00 | 2000-04-29 00:00:00 | 2000-04-30 00:00:00 | Avg |  | 2000-05-01 00:00:00 | 2000-05-02 00:00:00 | 2000-05-03 00:00:00
ANR ([NAME]) | 303648 | 303648 | 303648 | 300059 | 275128 | 258939 | 250811 | 250811 | 250811 | 281046 | 236499 | 249323 | 301918 | 326480 | 326480 | 326480 | 317860 | 316516 | 293286 | 283482 | 308850 | 308850 | 308850 | 308850 | 330386 | 347721 | 341090 | 366872 | 366872 | 366872 |  |  | 321251 | 386996 | 370967
PEPL (River Rouge) | 167736 | 188192 | 184315 | 106696 | 124735 | 113585 | 136995 | 130999 | 130984 | 134524 | 91931 | 105124 | 146157 | 168600 | 157681 | 158511 | 149945 | 151013 | 152474 | 163705 | 161021 | 165720 | 164913 | 159424 | 170709 | 132821 | 127421 | 125484 | 123025 | 114366 |  |  | 0 | 0 | 0
Great Lakes (Belle River) | 11936 | 11936 | 11936 | 12694 | 18818 | 47612 | 43967 | 43967 | 43967 | 39924 | 33967 | 38967 | 3577 | 13910 | 13910 | 13910 | 39074 | 12182 | 13422 | 8422 | 17894 | 17894 | 17894 | 17894 | 12923 | 8325 | 25442 | 33464 | 33464 | 33464 |  |  | 40380 | 23868 | 24954
Washington 10 Storage | -129328 | -129328 | -129328 | -61092 | -88499 | -103843 | -111461 | -111461 | -111461 | -112544 | -102889 | -52501 | -43740 | -146703 | -146703 | -146703 | -133692 | -130847 | -101486 | -97438 | -125313 | -125313 | -125313 | -125313 | -170805 | -138788 | -145198 | -184472 | -184472 | -184472 |  |  | -26697 | -63909 | -38677
Total Flows into Michcon (incl [NAME]): | 520827 | 520827 | 520827 | 540087 | 531182 | 517838 | 523682 | 523682 | 523682 | 526981 | 458935 | 536515 | 557714 | 560773 | 560773 | 560773 | 566335 | 541010 | 552645 | 558551 | 556922 | 556922 | 556922 | 556922 | 536919 | 545120 | 530621 | 531921 | 531921 | 531921 |  |  | 617478 | 629451 | 624429
Total Flows into Michcon:
Note:  ANR Flows are from Michcon rpt; PEPL flows are from PEPL rpt.
Prices:
Michcon
PEPL
ANR/SE
ANR/SW
ANR/ML7
Spreadsheet: 255d1d53-7ccd-4a35-bf07-699b18e73cc7
Sheet: 7a

Product1 | Cleared2 | Uncleared | TOTAL
Fixed-Float | 123890431 | 69639139 | 193165977
FRA | 51427401 | 8485675 | 58914267
OIS | 32840442 | 10765276 | 41384534
Swaption | 0 | 20512961 | 19572383
OTHER* | 6698568 | 24632181 | 31241661
TOTAL | 214856842 | 134035232 | 348892074
* OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 753875d1635794591-help-with-customized-recipe-list-that-filters-to-what-ingredients-you-have-on-hand-shopping-list-and-recipes
Sheet: Bacon Corn Chowder

 | Ingredients | Amount
Bread
Dairy
 | Evaporated Milk | 12 oz
 | Butter | 3 tablespoons
Herbs and Spices
 | Thyme | 0.5 teaspoon
 | Parsley | 1 teaspoon
 | [NAME] | 0.5 teaspoon
Liquid Goods
 | [NAME] | 4 cups
Meat
 | Bacon | 1 lb cooked and crumbled
Staple
 | Salt | to taste
 | Pepper | to taste
Vegetable
 | Carrot | 2 large carrots
 | Onion | 1 large onion
 | Potatoes | 4 potatoes
 | Corn | 32 oz drained canned corn
 | Corn | 32 oz creamed corn
Dry Goods
 | Cornstarch | 2 tablespoons
[NAME]
 | Corn | 12 oz bag of frozen corn
Spreadsheet: 78441d1278789153-filter-on-multiple-columns-without-excluding-any-relevant-data-filter123456
Sheet: data

Surname | Forename | subj 1 | exam1 | result | subj2 | exam2 | [NAME] | subj3 | exam3 | result3 | Subj 4 | exam4 | result 4 | subj 5 | exam5 | result 5 | Pupil #
Smith | Martin | Math | 76 | Above | Science | 37 | Below | French | 60 | Inline |  |  |  |  |  |  | 1231
[NAME] | Sara | Math | 40 | Below | Science | 90 | Above | Spanish | 60 | Inline |  |  |  |  |  |  | 1232
Whittaker | Scott | Math | 99 | Above | Science | 99 | Above | English | 10 | Below | Spanglish | 99 | Above | French | 20 | Below | 9999
Martin | Wilson | Math | 40 | Below | Science | 37 | Below | English | 10 | Below | Spanglish
[NAME] | [NAME] | Math | 60 | Above |  |  |  | Spanish | 60 | Inline
Spreadsheet: drew_fossum__8870__Fixed2
Sheet: RMTC_2

[NAME]
FUEL HEDGING BOOK
Risk Management & Trading Corp._2
Prod. | Contract | Contract | Fixed |  | Fuel | Settled | Futures | (Gains) and Losses
Date | Number | Name | Price |  | Dth | Price | Price | Total | Realized | Unrealized
 |  |  |  |  |  | El Paso Prmn |  | (4) | (4) | (4)
2000-01-01 00:00:00 |  | RMTC | 2.365
2000-02-01 00:00:00 |  | RMTC | 2.365
2000-03-01 00:00:00 |  | RMTC | 2.365
2000-04-01 00:00:00 |  | RMTC | 2.365
2000-05-01 00:00:00 |  | RMTC | 2.365
2000-06-01 00:00:00 |  | RMTC | 2.365
2000-07-01 00:00:00 |  | RMTC | 2.365
2000-08-01 00:00:00 |  | RMTC | 2.365
2000-09-01 00:00:00 |  | RMTC | 2.365
2000-10-01 00:00:00 |  | RMTC | 2.365
2000-11-01 00:00:00 |  | RMTC | 2.365
2000-12-01 00:00:00 |  | RMTC | 2.365
 |  |  |  |  |  | TW Index
2000-01-01 00:00:00 |  | Over-retention | 2.365
2000-02-01 00:00:00 |  | Over-retention | 2.365
2000-03-01 00:00:00 |  | Over-retention | 2.365
2000-04-01 00:00:00 |  | Over-retention | 2.365
2000-05-01 00:00:00 |  | Over-retention | 2.365
2000-06-01 00:00:00 |  | Over-retention | 2.365
2000-07-01 00:00:00 |  | Over-retention | 2.365
2000-08-01 00:00:00 |  | Over-retention | 2.365
2000-09-01 00:00:00 |  | Over-retention | 2.365
2000-10-01 00:00:00 |  | Over-retention | 2.365
2000-11-01 00:00:00 |  | Over-retention | 2.365
2000-12-01 00:00:00 |  | Over-retention | 2.365
(4)Gain and [NAME] are a measurement of the effectiveness of meeting the stated hedge objective.
Spreadsheet: 850480d1700823058-creating-checklist-with-printing-option-select-tools-for-projects
Sheet: Tool List

 | Project | Tools | Comment |  |  |  | Project A | Project B | Project C | Project D | Project E | Project F
 |  | Tool 1 |  |  |  |  |  | x |  |  | x
 | x | Tool 2 |  |  |  |  | x |  | x |  | x | x
 |  | Tool 3 | Special Tool |  |  |  | x | x | x | x
 |  | Tool 4 |  |  |  |  |  | x
 | x | Tool 5 |  |  |  |  |  |  |  |  |  | x
 | x | Tool 6 | 3 piece set |  |  |  | x |  |  |  | x
 |  | Tool 7 |  |  |  |  |  |  | x |  | x | x
 |  | Tool 8 |  |  |  |  |  |  |  |  |  | x
 |  | Tool 9 |  |  |  |  |  |  | x | x | x
 | x | Tool 10 |  |  |  |  |  |  |  | x | x
 |  | Tool 11 |  |  |  |  | x | x |  |  |  | x
 |  | Tool 12 |  |  |  |  |  | x |  | x | x
 | x | Tool 13 |  |  |  |  |  |  |  | x |  | x
 | x | Tool 14 |  |  |  |  |  |  |  | x |  | x
 |  | Tool 15 |  |  |  |  |  |  | x |  | x | x
 | OPTION 1 |  |  |  |  | OPTION 2
 | Select tools in column 'B' |  |  |  |  | Setup matric of tools for various jobs: |  |  | H1 > M1  = Project Name
 |  |  |  |  |  |  |  |  | H2 : M16 = 'x' = tool used for that project
Spreadsheet: 857484d1706503207-listing-column-headings-based-on-cell-values-mosom-9-2-
Sheet: Sheet1

 | Role 1 | Role 2 | Role 3 | Role 4 | Role 5 |  |  | Drop down list of Permissions: | Permission 2 |  |  |  | Office Titles | Roles
Permission 1 | y |  | y |  | y |  |  |  |  |  |  |  | Office Title 1 | Role 1 | Role 2 |  |  | Role 5
Permission 2 |  | y |  | y |  |  |  |  |  |  |  |  | Office Title 2 | Role 1 |  | Role 3
Permission 3 | y |  | y |  | y |  |  | What I want to appear: | Role 1 |  |  |  | Office Title 3 | Role 1 |  | Role 3 | Role 4 | Role 5
Permission 4 |  |  |  |  |  |  |  |  | Role 3 |  |  |  | Office Title 4 | Role 1 | Role 2
Permission 5 | y | y |  | y | y |  |  |  | Role 5 |  |  |  | Office Title 5 | Role 1 |  |  | Role 4
 |  |  |  |  |  |  |  |  |  |  |  |  | Office Title 6 | Role 1 | Role 2 | Role 3
 |  |  |  |  |  |  |  |  |  |  |  |  | NEW REQUEST
 |  |  |  |  |  |  |  | Winning Formula:
 |  |  |  |  |  |  |  |  | Role 4 |  |  |  | When J1 is populated with a permission, J11 is populated with the different Roles
 |  |  |  |  |  |  |  |  |  |  |  |  | I would also like a new cell, say N17, to list the unique Office Titles that contain the Roles that contain the permission
 |  |  |  |  |  |  |  |  |  |  |  |  | Example for J1 = Permission 2: |  |  |  | Unique list:
 |  |  |  |  |  |  |  |  |  |  |  |  | Office Title 1
 |  |  |  |  |  |  |  |  |  |  | Role 2 |  | Office Title 4 |  |  |  | Office Title 3
 |  |  |  |  |  |  |  |  |  |  |  |  | Office Title 6 |  |  |  | Office Title 4
 |  |  |  |  |  |  |  |  |  |  | Role 4 |  | Office Title 3 |  |  |  | Office Title 5
 |  |  |  |  |  |  |  |  |  |  |  |  | Office Title 5 |  |  |  | Office Title 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 232046d1367316831-display-a-bunch-of-questions-after-selecting-an-item-assessment-test
Sheet: Sheet5

Not asked
Innefective
Baseline
Effective
Highly Effective
Exceptional
Innefective | 1
Baseline | 2
Effective | 3
Highly Effective | 4
Exceptional | 5
Innefective | 1 | C
Baseline | 2 | B-
Effective | 3 | B
Highly Effective | 4 | A
Exceptional | 5 | A+
Spreadsheet: 732020d1620743886-using-conditional-formatting-with-indirect-range-of-cells-conditional-formatting
Sheet: Feuil1

 | Worker | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | TRUE/FALSE | Range of cells to highlight
 | [NAME] | 5328 | 6231 | 829 | 578 | 7509 | 4704 | 7103 | 8915 | 4959 | 4106 | 2321 | 2748 | False | $[NAME]
 | [NAME] | 9024 | 8908 | 8706 | 3145 | 9125 | 1320 | 9066 | 818 | 1469 | 7089 | 4751 | 5424 | False | $F$4:$N$4
 | [NAME] | 878 | 5214 | 2657 | 3537 | 8080 | 646 | 9679 | 6786 | 9802 | 4733 | 3249 | 7806 | False | $[NAME]
 | [NAME] | 7471 | 1956 | 5793 | 4276 | 4620 | 1411 | 87 | 3388 | 4219 | 2523 | 9380 | 627 | False | $F$6:$N$6
 | [NAME] | 4015 | 2991 | 5118 | 5620 | 6271 | 7483 | 6990 | 8536 | 5410 | 2266 | 1194 | 2311 | True | $[NAME]
 | [NAME] 6 | 3596 | 8183 | 7363 | 9935 | 1686 | 9360 | 3166 | 1463 | 437 | 4568 | 3347 | 9997 | True | $F$8:$N$8
 | [NAME] | 3193 | 2140 | 2515 | 7992 | 6719 | 7955 | 3857 | 4140 | 8027 | 5084 | 7567 | 3041 | True | $[NAME]
 | [NAME] | 5900 | 5349 | 4745 | 9441 | 4495 | 2662 | 7632 | 7142 | 9488 | 9133 | 4332 | 736 | False | $F$10:$N$10
 | [NAME] 9 | 969 | 5371 | 1438 | 8066 | 7654 | 5380 | 4817 | 2492 | 8372 | 96 | 9421 | 5610 | True | $F$11:$N$11
 | [NAME] 10 | 776 | 3752 | 7391 | 7808 | 4614 | 3588 | 6743 | 4769 | 9086 | 7658 | 4225 | 4227 | True | $F$12:$N$12