tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 4a71ba71-20b6-46a7-9d55-41dba30bae9a
Sheet: New Course Denial

New Course Denial
11-Digit Core Codes for Use in the High School | CIP Code | USOE Course Title                                               Assignment Names Updated 04/26/2005 | Reason for Denial | HS Core Flag | HE GenEd Code | College | Course Prefix | Course Prefix | Course Title | [NAME].
[PHONE] | 110215 | 3D Graphics CE | Prerequisite courses should be taught first.  Listed instructor is not endorsed to teach course work.  Prereq: ART 1800 or instructor approval. | N |  | SLCC | ART | 2630 | Introduction to 3D Modeling | 3 | Requires, VAD Animation Emphasis A, T | 2 | E |  |  | 10 | 11 | 12 | P
[PHONE] | 110216 | 3D Animation CE | Prerequisite courses should be taught first.  Listed instructor is not endorsed to teach course work.  Prereq: ART 2630 and ART 1620 or instructor approval. | N |  | SLCC | ART | 2640 | Introduction to 3D Animation | 3 | Requires, VAD Animation Emphasis A, T | 2 | E |  |  | 10 | 11 | 12 | P
 |  |  | No Core Code counterpart.  District must submit request for new code approval to USOE.   Prereq: Recommended CIS 1130 and CS 1410. | N |  | SLCC | CSIS | 2640 | Mobile IOS App Development | 3
[PHONE] | 520621 | Entrepreneurship - Business CE | Upper level class.  Prereq: BUS 1050, MKTG 1030, ACCT 2020 | N |  | SLCC | MGT | 2020 | Entrepreneurship | 3 | Required, BusMgt Small Bus Ownership Emphasis T | 4 | B |  |  | 10 | 11 | 12 | P
[PHONE] |  | Anatomy & Physiology CE | Course may NOT be offered for Anatomy & Physiology or Advanced Health Science credit. Districts must award Foundations of Nutrition credit. | N |  | UVU | NUTR | 1020 | Foundations of Human Nutrition | 3 |  |  |  |  |  | 10 | 11 | 12 | P I
Spreadsheet: daren_farmer__5721__HPLN0210
Sheet: Sheet1

HPLN0210.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC) |  |  |  |  |  |  | REVISION #1
SUBJECT:  TXU FUELS NOMINATION - February 10-12, 2001
 |  |  |  |  |  | **Sat/Sun | **Monday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2/10-11/2001 | 2001-02-12 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs. | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Oasis Sealy |  | Enron | 0 | 0 | 20
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 744518d1629283626-highlight-date-range-on-calendar-399
Sheet: Calendar

 | 2021 | AUGUST |  | MONDAY |  | 3099 Issue [NAME]
 | CALENDAR YEAR | CALENDAR MONTH |  | FIRST DAY OF WEEK
 |  | 44404 | 44405 | 44406 | 44407 | 44408 | 44409
 |  | 2021-07-27 00:00:00 | 2021-07-28 00:00:00 | 2021-07-29 00:00:00 | 2021-07-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-01 00:00:00
 |  | 2021-08-03 00:00:00 | 2021-08-04 00:00:00 | 2021-08-05 00:00:00 | 2021-08-06 00:00:00 | 2021-08-07 00:00:00 | 2021-08-08 00:00:00
 |  | 2021-08-10 00:00:00 | 2021-08-11 00:00:00 | 2021-08-12 00:00:00 | 2021-08-13 00:00:00 | 2021-08-14 00:00:00 | 2021-08-15 00:00:00
 |  | 2021-08-17 00:00:00 | 2021-08-18 00:00:00 | 2021-08-19 00:00:00 | 2021-08-20 00:00:00 | 2021-08-21 00:00:00 | 2021-08-22 00:00:00
 |  | 2021-08-24 00:00:00 | 2021-08-25 00:00:00 | 2021-08-26 00:00:00 | 2021-08-27 00:00:00 | 2021-08-28 00:00:00 | 2021-08-29 00:00:00
 |  | 2021-08-31 00:00:00 | 2021-09-01 00:00:00 | 2021-09-02 00:00:00 | 2021-09-03 00:00:00 | 2021-09-04 00:00:00 | 2021-09-05 00:00:00
Spreadsheet: 4203493f-d2bf-4bf9-b17c-481476e42dd3
Sheet: Sheet1

Nombre
[NAME] Primera: Federaciones Deportivas Andaluzas
[NAME] Primera: [NAME] Federaciones Deportivas
[NAME] Segunda: Clubes Deportivos
[NAME] Segunda: Secciones Deportivas
[NAME]: Entes de Promoción Deportiva
[NAME]: Entidades Públicas o Privadas que desarrollen actividades deportivas con carácter accesorio
[NAME]: [NAME]
[NAME]
[NAME] Continuación: Aportación de Nueva Documentacion, Subsanacion de Observaciones y [NAME]
[NAME]
Tramitación electrónica del Depósito Legal de Andalucía
Tramitación electrónica del Registro de la Propiedad Intelectual en Andalucía
2014 - Solicitud Inscripcion y/o [NAME] Específicas [NAME] (Baloncesto,Balonmano,[NAME],[NAME],[NAME],Espeleologia)
2014 - Solicitud Inscripcion y/o [NAME] Específicas [NAME] ([NAME], [NAME])
2014 - Subvenciones para el sector profesional del flamenco en Andalucía (Asistencia Festivales)
2014 - Subvenciones para la promoción del tejido asociativo del flamenco en Andalucía
2014 - Subvenciones para el desarrollo y produccion de obras audiovisuales (Unidad Documental)
2014 - Subvenciones para el desarrollo y produccion de obras audiovisuales (Largometrajes)
2014 - Subvenciones para el desarrollo y produccion de obras audiovisuales (Desarrollo)
2014 - Selección de Licitadores en modalidad Semipresencial y a [NAME]
Spreadsheet: 229898d1366636728-i-am-looking-for-a-good-banking-template-for-excel-2010-bank-book-example
Sheet: Holiday

Holiday |  |  |  |  |  | Book Balance
Date | Particulars |  | Deposit | Withdrawal | Balance
Spreadsheet: 68679d1d-6391-4c9b-a111-ebd085c0ddbd
Sheet: 9d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis* | 920298 | 911672 | 754825 | 2187484 | 1606101 | 718251 | 305724 | 7404355
FRA | 19239782 | 11891604 | 6799028 | 7066362 | 171789 |  |  | 45168565
IRS- [NAME] | 5648839 | 5448249 | 5207336 | 24370939 | 41779778 | 33194945 | 15347200 | 130997286
OIS | 8934890 | 5826501 | 4036098 | 6694269 | 356011 | 36332 | 14142 | 25898243
VNS | <100 | <100 | 573 | 765 | 6566 | 3905 | 9818 | 21627
Zero Coupon | 45803 | 45597 | 33757 | 124301 | 72267 | 16521 | 48787 | 387033
TOTAL | 34789610 | 24123623 | 16831617 | 40444120 | 43992512 | 33969955 | 15725672 | 209877109
Estimated gross notional amount outstanding, August 16 weekly snapshot, by product type and tenor (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 114317d1310072052-search-columns-for-required-criteria-remove-duplicates-sort-then-concatonate-example
Sheet: Sheet1

Section # | IDs
Section 1 | 4421 | 3234 | - | - | - | -
Section 2 | 4562 | - | - | - | - | -
Section 3 | - | - | - | - | - | -
Section 4 | 3234 | - | - | - | - | -
Total | 3234, 4421, 4562
Section 1
Header 1 | [NAME] | [NAME] | [NAME] | ID | [NAME] | Header 6
 |  |  |  | -
 |  |  |  | -
 |  |  |  | -
 |  |  |  | 4421
 |  |  |  | -
 |  |  |  | -
 |  |  |  | 3234
 |  |  |  | -
Section 2
Header 1 | [NAME] | [NAME] | [NAME] | ID | [NAME] | Header 6
 |  |  |  | -
 |  |  |  | 4562
 |  |  |  | -
 |  |  |  | -
 |  |  |  | -
Section 3
Header 1 | [NAME] | [NAME] | [NAME] | ID | [NAME] | Header 6
 |  |  |  | -
 |  |  |  | -
 |  |  |  | -
 |  |  |  | -
 |  |  |  | -
 |  |  |  | -
 |  |  |  | -
 |  |  |  | -
Section 4
Header 1 | [NAME] | [NAME] | [NAME] | ID | [NAME] | Header 6
 |  |  |  | -
 |  |  |  | -
 |  |  |  | -
 |  |  |  | -
 |  |  |  | 3234
 |  |  |  | -
 |  |  |  | -
Spreadsheet: 46822d1245762960-conditional-formatting-of-table-sample
Sheet: Sheet1

Section | Text
1 | just
1 | some
1 | test
2 | more
2 | testing
2 | here
3 | [NAME]
3 | [NAME]
3 | [NAME]
Spreadsheet: richard_ring__31554__EEMC-CECAuditedAnnual-2000
Sheet: Schedule 1

 | Annual Report to the California Energy Commission
 | for the year ending December 31, 2000
 | SCHEDULE 1:  RETAIL SALES
 | Applicable to:  Retail Providers (Power Source Disclosure Program) and Registered Renewable Providers (Customer Credit Program)
 | SPECIFIC PURCHASES
 | Facility Name | Fuel Type | EIA ID Number1 | CEC ID Number2 | Certificate Number3 | Gross kWh Purchased or Generated | kWh [NAME] or Self-Consumed | Net kWh Purchased | [NAME] if Eligible for Credit
 | EPMI (purchased from APX) | Biomass |  | 80003 |  | 1303700 |  |  | X
 | EPMI (purchased from APX) | Geothermal |  | 80003 |  | 3057620 |  |  | X
 | EPMI (purchased from APX) | [NAME] |  | 80003 |  | 6680 |  |  | X
 | EPMI | [NAME] |  | 80003 |  | 13033000 |  |  | X
 | EPMI | Wind |  | 80003 |  | 8786000 |  |  | X
 | EES (purchased from APX) | Biomass |  | 91083 |  | 11784000 |  |  | X
 | EES (purchased from APX) | Geothermal |  | 91083 |  | 62959400 |  |  | X
 | EES (purchased from APX) | [NAME] |  | 91083 |  | 8673600 |  |  | X
 | EES (purchased from EPMI) | Biomass |  | 80003 |  | 55264000 |  |  | X
 |  |  |  |  |  | GENERIC PURCHASES
 |  |  |  |  |  | Gross kWh Purchased | kWh [NAME] | Net kWh Purchased
 |  |  |  |  |  | 4326796699
 |  |  |  |  |  | Total Net Purchases
 | 1Please enter the Energy Information Administration identification number for the generating facility, if available.
 | 2 Please enter the Energy Commission Renewable Energy Program Registration number for the generating facility, if applicable.
 | 3 California Energy Commission's assigned unique number for the Certificate of Specific Generation |  |  |  |  |  |  | CEC Reg. #
 | 4 EPMI = Enron Power Marketing, Inc.
 | 5 EES (purchased from APX) Geothermal includes purchases of 62,042,400 kWh and 917,000 kWh carryover from 1999 report.
Spreadsheet: 492421d1481085483-monetary-denominations-with-array-formulas-2017-budget-help
Sheet: Denomacion

 |  |  | 100 | 50 | 20 | 10 | 5 | 1
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
 | Total:
Spreadsheet: 104623d1302161380-searching-data-through-out-the-worksheet-stock-statement-on-7-4-2011
Sheet: SUBWOOFERS

S.No | DESCRIPTION | MODEL | SERIAL NO | QTY | FINISH
1 | [NAME] | ABYSS | ABRJ0168 | 1 | Black
2 | Apart Subwoofer | SUB 2201 |  | 1 | White
3 | [NAME] subwoofer | CHT 15Q | 703471136, 37 | 2 | Black
 | BACK
Spreadsheet: 860041d1708275591-extract-date-from-string-new-microsoft-excel-worksheet
Sheet: Sheet1

 |  |  | DATE | RESULT
 |  |  | PAID ON 16.02.24--96072
 |  |  | PAID ON 03.02.24--96072
 |  |  | PAID ON 03.02.24--96072
 |  |  | PAID ON 04.02.24--96072
 |  |  | PAID ON 04.11.24--96072
 |  |  | PAID ON 13.02.24--40289
 |  |  | PAID ON 14.02.24--96072
 |  |  | PAID ON 19.11.24--96072
 |  |  | PAID ON 04.01.24--96072
 |  |  | PAID ON 21.12.24--96072
Spreadsheet: 673221d1587260190-greater-than-less-than-formula-time-monitoring
Sheet: 15042020

tm1 |  | tm2 |  | tm3 |  | tm4 |  | tm5 |  | tm6 |  | tm7 | tm8 |  |  |  |  |  |  |  |  |  |  |  |  | tm21 | tm22 | tm23 | tm24 | tm25 | tm26 | tm27 | tm28 | tm29 | tm30
0249 |  | 0900 |  | 0925 |  | 1325 |  | 1351 |  | 1545
Spreadsheet: 831520d1685696580-offset-not-returning-answer-im-looking-for-runout-test-1-1-
Sheet: PIVOT

Row Labels | Count of Sales Territory | Count of Product1 | Count of Product | Count of BRAND | Count of Week | Sum of W22/23__(29/05/2023) | Sum of W23/23__(05/06/2023) | Sum of W24/23__(12/06/2023) | Sum of W25/23__(19/06/2023) | Sum of W26/23__(26/06/2023) | Sum of W27/23__(03/07/2023) | Sum of W28/23__(10/07/2023) | Sum of W29/23__(17/07/2023) | Sum of W30/23__(24/07/2023) | Sum of W31/23__(31/07/2023)
ASBAKED1a | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1061 | 1040 | 1061 |  | 1061 | 1071 | 1061 | 1080
ASBAKED101 |  |  |  |  |  | 1061 | 1061 | 1061 | 1040 | 1061 | 1050 | 1061 | 1071 | 1061
Spreadsheet: errol_mclaughlin_jr__10062__Bkrqs756
Sheet: Sheet1

From: | Risk Management -Controls
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: | Risk Management
Subject: | Book Request # 756
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  | BOOK INFORMATION |  |  |  |  | Reporting -Subledger
 |  | Type Of Transactions |  |  | Book Mapping
Short Name | [NAME] | Internal | External | Both | Code | Region | P | B | Idx | [NAME] | PHY | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason For Book | Date Needed |  | MTM | Prud | Realized
NG-PR-SPREAD | Natural Gas Non-Affiliate Spread Book | x |  |  | #I | DESK | X |  |  |  |  | NG/MMBTU | [NAME] | MTM | [NAME] | ASAP
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.
*A unique portfolio/book code will be assigned to your book unless you request a specific portfolio/book code.
BOOK CANNOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
***Please provide login names for book administrators.***
IT SECURITY | Book |  |  |  |  |  |  |  |  |  |  | RisktRAC Check List |  | Added (Y/N) | Processors ID
Access List | Administrator*
trohaue | [NAME] |  |  |  |  |  |  |  |  |  |  | Created in RisktRAC |  | Y | JV
emclaug |  |  |  |  |  |  |  |  |  |  |  | Hierarchy |  | Y | JV
[NAME] |  |  |  |  |  |  |  |  |  |  |  | Master booklist |  | Y | JV
kloibl |  |  |  |  |  |  |  |  |  |  |  | Sent to GCP |  | Y | JV
bbajwa |  |  |  |  |  |  |  |  |  |  |  | Sent to TAGG/ERMS |  | Y | JV
 |  |  |  |  |  |  |  |  |  |  |  | Active/Inactive Book List
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Any questions, please contact me:
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | (x52526)
Spreadsheet: 102764d1300726246-sum-numerous-row-entries-for-expense-accounts-test-sort-and-sum-solution-
Sheet: Sheet1

2010-04-01 00:00:00 | 31 | Bank charges
2010-04-01 00:00:00 | 637 | Insurance
2010-04-01 00:00:00 | 225 | Legal
2010-04-01 00:00:00 | 500 | Legal
2010-04-01 00:00:00 | 500 | Other
2010-04-01 00:00:00 | 225 | Rent
2010-04-01 00:00:00 | 500 | Rent
2010-04-01 00:00:00 | -4000 | Revenue
2010-05-01 00:00:00 | 38 | Bank charges
2010-05-01 00:00:00 | 637 | Insurance
2010-05-01 00:00:00 | 225 | Legal
2010-05-01 00:00:00 | 231 | Legal
2010-05-01 00:00:00 | 225 | Rent
2010-05-01 00:00:00 | 500 | Accounting
2010-05-01 00:00:00 | 500 | Accounting
2010-05-01 00:00:00 | -8000 | Revenue
2010-05-01 00:00:00 | -7000 | Revenue
2010-06-01 00:00:00 | 39 | Bank charges
2010-06-01 00:00:00 | 637 | Insurance
2010-06-01 00:00:00 | 300 | Legal
2010-06-01 00:00:00 | 350 | Legal
2010-06-01 00:00:00 | 500 | Legal
2010-06-01 00:00:00 | 546 | Legal
2010-06-01 00:00:00 | 500 | Legal
2010-06-01 00:00:00 | 595.06 | Other
2010-06-01 00:00:00 | 300 | Rent
2010-06-01 00:00:00 | 350 | Rent
2010-06-01 00:00:00 | 343 | Accounting
2010-06-01 00:00:00 | 987 | Accounting
2010-06-01 00:00:00 | -5000 | Revenue
2010-06-01 00:00:00 | -6000 | Revenue
2010-07-01 00:00:00 | 41 | Bank charges
2010-07-01 00:00:00 | 637 | Insurance
2010-07-01 00:00:00 | 465 | Legal
2010-07-01 00:00:00 | 350 | Legal
2010-07-01 00:00:00 | 500 | Legal
2010-07-01 00:00:00 | 300 | Rent
2010-07-01 00:00:00 | 350 | Rent
2010-07-01 00:00:00 | 500 | Accounting
2010-07-01 00:00:00 | 63 | Accounting
2010-07-01 00:00:00 | -4500 | Revenue
2010-08-01 00:00:00 | 32 | Bank charges
2010-08-01 00:00:00 | 637 | Insurance
2010-08-01 00:00:00 | 79 | Legal
2010-08-01 00:00:00 | 500 | Legal
2010-08-01 00:00:00 | 300 | Rent
2010-09-01 00:00:00 | 36 | Bank charges
2010-09-01 00:00:00 | 637 | Insurance
2010-09-01 00:00:00 | 13 | Legal
2010-09-01 00:00:00 | 300 | Rent
2010-09-01 00:00:00 | 1597 | Accounting
2010-10-01 00:00:00 | 37 | Bank charges
2010-10-01 00:00:00 | 637 | Insurance
2010-10-01 00:00:00 | 56 | Legal
2010-10-01 00:00:00 | 1233 | Legal
2010-10-01 00:00:00 | 300 | Rent
2010-10-01 00:00:00 | -9000 | Revenue
Spreadsheet: 218800d1362584945-search-in-sheet-1-and-return-to-sheet-2-using-lookup-sample1
Sheet: Blad1

2013-03-04 00:00:00 | 4/3- | 11/3- | 18/3- | 25/3-
Week | 10 | 11 | 12 | 13
Text A | SKM | SKM | SKM | SKM
Text 1 | EA | EA | EA,PAS
Text 2 |  | SAN,LO |  | PAS
Text 3 | SAN |  | SAN
Text 4 | MM | [NAME] | AB
Text 5 | [NAME] | MM | MLA21-22 | [NAME]
Text 6 | AB,LO | CF |  | AB,EA
Text 7 | CF7 e m |  | CF
Text 8 | WA | AB,HBA | WA
Text 9 | HBA | MP13-15 | MP18-20
Text 10 |  |  |  | HBA
Text 11 | EGU | RAS | RAS | JOS
Text 12 | AMY7-8 | JOS | AMY | SAN
 |  | In Sheet 2 cell B3, I want to be able to type in a search string ie "CF" and extract the information from Sheet 1 column A on the same row "CF" occurs for each column in Sheet 1. This should be done for each column that "CF" occurs in Sheet 1. I have used LOOKUP like this:
 |  | [CODE]=LOOKUP($B$3,Sheet1!$B$3:$B$100,Sheet1!$A$3:$A$100)[/CODE]
 |  | but it returns faulty values.
 |  | Other characters are involved in the cells like "," and elevated text, perhaps that is the issue?
 |  | I have attached a sample file with an example in sheet 2.
 |  | Here is another EXAMPLE:
 |  | If I type in "AB" in Sheet 2 cell B3, it should return the values (using the attached sample)
 |  | Text 6 (from [sheet 1 A9])
 |  | Text 8 (from [sheet 1 A11])
 |  | Text 4 (from [sheet 1 A7])
 |  | Text 6 (from [sheet 1 A9])
 |  | All comments are welcome! Thank you for your help.
 |  | Excel 2003 PC
Spreadsheet: 854961d1704718074-data-validation-index-book
Sheet: Indexation

 | Year: | 2024
 | Month: | September
 | Factor:
 | Month | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14
 |  | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036
 | January | 1.3 | 1.5 | 1.8 | 2
 | February | 1.3 | 1.5 | 1.8 | 2
 | March | 1.3 | 1.5 | 1.8 | 2
 | April | 1.3 | 1.5 | 1.8 | 2
 | May | 1.3 | 1.5 | 1.8 | 2
 | June | 1.3 | 1.5 | 1.8 | 2
 | July | 1.3 | 1.5 | 1.8 | 2
 | August | 1.3 | 1.5 | 1.8 | 2
 | September | 1.5 | 1.8 | 2 | 2.2
 | October | 1.5 | 1.8 | 2 | 2.2
 | November | 1.5 | 1.8 | 2 | 2.2
 | December | 1.5 | 1.8 | 2 | 2.2
Spreadsheet: 106434d1303703897-excel-2007-macro-to-copy-columns-based-headers-ranking
Sheet: Raw_Data

Rank
Acct | Apples | Bananas | Coconut | Dates | [NAME] | Grapes
654 | 0 | 0 | 1 | 1 | 0 | 0
464 | 0 | 1 | 1 | 1 | 0 | 1
64 | 1 | 0 | 1 | 0 | 0 | 0
486 | 1 | 1 | 0 | 0 | 1 | 0
94 | 1 | 1 | 0 | 1 | 0 | 1
946 | 0 | 1 | 1 | 1 | 0 | 1
1818 | 1 | 0 | 1 | 0 | 0 | 0
Spreadsheet: 873937d1720534831-3d-table-find-the-value-according-to-multiple-criteria-sybille-classeur2-1-aligw
Sheet: Feuil1

 |  |  | Fit-up | Fit-up | Fit-up | Fit-up | Fit-up | Fit-up | Solution mobilier | Solution mobilier | Solution mobilier | Solution mobilier | Solution mobilier | Solution mobilier | Solution mobilier | Solution mobilier | Sans travaux | Sans travaux | Sans travaux | Sans travaux | Sans travaux | Sans travaux | Sans travaux | Sans travaux
 |  |  | Tout | Initialisation | Conception | Travaux | Conception | Travaux | Tout | Initialisation | Conception | Conception | Travaux | Travaux | Travaux | Travaux | Tout | Initialisation | Conception | Conception | Travaux | Travaux | Travaux | Travaux
 |  |  | Taux | B175 | B143 | B143 | B141 | B141 | Taux | B175 | B123 | B143 | B123 | B143 | B141 | B141 | Taux | B175 | B123 | B143 | B123 | B143 | B141 | B141
Description | Fourchette | Superficie |  | 1 | 1 | 1 | 1 | 1 |  | 1 | 0.7 | 0.3 | 0.7 | 0.3 | 1 | 1 |  | 1 | 0.7 | 0.3 | 0.7 | 0.3 | 1 | 1
Aménagement | 0 À 899 | 0 |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0
Aménagement | 900 À 1499 | 900 |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0
Aménagement | 1500 À 2999 | 1500 |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0
Aménagement | 3000 et plus | 3000 |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | 0 | 0
Base-building | 0 À 899 | 0 |  |  | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0
Base-building | 900 À 1499 | 900 |  |  | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0
Base-building | 1500 À 2999 | 1500 |  |  | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0
Base-building | 3000 et plus | 3000 |  |  | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0
Critères : |  | Résultat :
Base-building
1620
Fit-up
Initialisation
B175
Spreadsheet: 841500d1693673535-help-setting-a-formula-based-on-2-variable-conditions-help-setting-up-a-conclusion-with-2-conditions-ans
Sheet: Sheet1

Condition 1: | This Cell B2 will either display: "Adjust with X," "Adjust with Y," or "No Adjustment"
Condition 2: | This Cell B4 will also either display: "Adjust with X," "Adjust with Y," or "No Adjustment". This cell also may be blank at times, based on another unmentioned condition.
Conclusion: | I want this cell (B7) to display "Adjust" if either B2 or B4 say either "Adjust with X" or "Adjust with Y"
 | I also want the cell B7 to say "No Adjustment" if B2 and B4 are BOTH no adjustment or B2 only (if B4 is blank)
Example scenarios below
Example 1:
Condition 1: | Adjust With X
Condition 2: | Adjust with Y
Conclusion: | Adjust
Example 2:
Condition 1: | No Adjustment
Condition 2: | No Adjustment
Conclusion: | No Adjustment
Example 3:
Condition 1: | No Adjustment
Condition 2: | Adjust with X
Conclusion: | Adjust
Example 4 (second option is blank):
Condition 1: | No Adjustment
Condition 2:
Conclusion: | No Adjustment
Example 5 (second option is blank):
Condition 1: | Adjust with Y
Condition 2:
Conclusion: | Adjust
Spreadsheet: 150996d1334754195-conditional-formatting-if-dates-exist-between-range-and-matches-hoiday-list-sample
Sheet: 2012

 |  |  | Week of dates (Starts with Monday) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week of dates (Monday) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week of dates (Monday)
ID | Project Name | Week Starting | 2012-01-02 00:00:00
ID |  | Week Ending | 2012-01-05 00:00:00
 | Office Closures / Holidays
 | Holidays/closures 2012
 | 2012-01-02 00:00:00
 | 2012-02-20 00:00:00
 | 2012-03-28 00:00:00
 | 2012-07-02 00:00:00
 | 2012-07-03 00:00:00
 | 2012-07-04 00:00:00
 | 2012-07-05 00:00:00
 | 2012-07-06 00:00:00
 | 2012-09-03 00:00:00
 | 2012-11-22 00:00:00
 | 2012-11-23 00:00:00
 | 2012-12-24 00:00:00
 | 2012-12-25 00:00:00
 | 2012-12-26 00:00:00
 | 2012-12-27 00:00:00
 | 2012-12-28 00:00:00
 | 2012-12-31 00:00:00