tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 28918c6a-1b44-47ab-86a3-9396fa646729
Sheet: Sheet1

Clinical Research Budget & Billing Support Office (CRBB) • Phone (206) 598-9490 • Fax (206) 598-9151 • [EMAIL] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Clinical Research Service Center Request Form
([NAME] to the AAA [Account] Registration Form)
Clinical Research Budget & Billing Support Office (CRBB)
Directions:  Please complete the grid below.  Submit the pricing page to the following for appropriate charges and approval:
 | Radiology Services, Box 354807
 | Attn:  Radiology Research Committee • (206) 616-0962 • [EMAIL]
***NOTE:  PRICES ARE BEST ESTIMATES ONLY AS OF THE DATE OF REQUEST AND ARE SUBJECT TO CHANGE WITHOUT NOTICE
Department: | RADIOLOGY SERVICES (Photocopy this page for additional services.)
Date of Request: |  |  | Type of Request: |  | Account | Initiation | Funding Source: |  | Industry
Study Short Title:
Principal Investigator: |  |  |  | E-mail: |  |  |  | Phone: |  | Box#:
Study Contact: |  |  |  | E-mail: |  |  |  | Phone: |  | Box#:
To be completed by Department Administrator/Manager:
# of Subjects/Service | Description of Research Related Services |  |  |  | IDX Exam Code | Hospital Charge Code | CPT Code | Hospital Charge*** |  | Pro Fee         (If applicable) | Research Rate (%) of Charges
Service Area Manager:                               Please complete the following information. |  |  |  | Budget #: |  | Service Center #:
Radiology Divisions involved and location of service: (Put location code in the blank)       U=UWMC   R=[NAME]
____ DX Radiology | ____ MRI |  | ____ Nuclear Med |  | ____ [NAME] |  | ____ Other, specify:
____ CT | ____ [NAME] |  | ____ [NAME] |  |  |  | ____ Other, specify:
CRC Approved Ancillary (Signature Required):___________________________________
REVIEWED AND APPROVED BY:
Pricing Prepared by | [NAME] |  |  | Signature: |  |  |  | Date:
Service Area Director | [NAME] |  |  | Signature: |  |  |  | Date:
CRBB Office |  |  |  | Signature: |  |  |  | Date:
 | Print Name
Spreadsheet: richard_shapiro__32388__Europen Govt Affairs Waterfall
Sheet: Waterfall Step

Table for Waterfall Graph input
 | Baseline | Add'l Headcount & On Costs to End 2001 | Piece Pipe / Arcos | Adjusted Full Year Forecast | CE2 -  7 months act + 3 month CE2
 | 2.7 |  |  | 2 | 6.7 | Actual Forecast
 | 0.5 | 0.2 | 0.5 | 1 | 0.85 | T&E
 | 2.3 |  |  | 1 | 2.35 | Audit Legal / Consultancy
 | 0.5 |  |  | 0.7
 |  |  |  | 1
 |  |  |  | 1
Spreadsheet: jonathan_mckay__16902__EnronDirect Deal Sheet-Area Managers
Sheet: Springbank

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | Springbank Park For All Seasons |  |  |  | Deal Date: | 2001-05-30 00:00:00 |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  | Deal ID #: |  |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-08-01 00:00:00 |  |  |  | Unit of Measure: | GJ |  |  |  |  |  |  | 6 | June
Deal End Date: | 2002-07-31 00:00:00 |  |  |  | Volume (Monthly/Daily): | Monthly |  |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  | Price: |  |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  | Buy/Sell: | Buy |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Combined Volume | Fuel | Total
 | January | 0 | 1457
 | February | 0 | 1433
 | March | 0 | 1162
 | April | 0 | 1126
 | May | 0 | 869
 | June | 0 | 597
 | July | 0 | 470
 | August | 0 | 87
 | September | 0 | 55
 | October | 0 | 663
 | November | 0 | 1070
 | December | 0 | 1377
 | TOTAL:
Spreadsheet: 677294d1589294431-conditional-formatting-of-rows-based-on-dates-compared-with-today-design-rfi-log-forum-edition
Sheet: ELECT

Project Name: |  |  |  |  |  |  |  |  |  |  | Response Received
Project Number |  |  |  |  |  |  |  |  |  |  | [NAME] response
 |  |  |  |  |  |  |  |  |  |  | Late response
RFI | Report/Drawing/ Specifications |  | [NAME] | Date Subnitted | Author | Gap in days | Due Date | RFI Description | Response Required From? A/S/M/E/O | Days Overdue | Response Date | RFI Response
Sample | [NAME] |  |  | 2020-04-03 00:00:00 | AW | 7 |  | Brain Injury Unit- Are all fire alarm devices on Level 1 required to be vandal proof? There is some cross over into common spaces on Level 1 Area 10 from Level 1 Area 20/30. Are the devices in the courtyard to be vandal proof as well? See "Electrical Items Reference" Item Sample | E |  | 2020-04-05 00:00:00 | Area 20 - Door DC-1010 separating [NAME] and [NAME]. All devices within area from secured door to end of Wing require [NAME]. Area 30 - Door DC-1009 separating [NAME] and Corridor C-1009. All devices within area from secured door to end of Wing require [NAME].
E001
E002
E003
E004
E005
E006
E007
E008
E009
E010
Spreadsheet: 45167d1243949265-counting-by-2-or-more-criteria-example
Sheet: Summary

Date | Cathy |  | [NAME] |  | Dawn |  | [NAME] |  | [NAME]
 | S Jobs Opened | W Jobs Opened | S Jobs Opened | W Jobs Opened | S Jobs Opened | W Jobs Opened | S Jobs Opened | W Jobs Opened | S Jobs Opened | W Jobs Opened
2009-05-01 00:00:00
2009-05-02 00:00:00
2009-05-03 00:00:00
2009-05-04 00:00:00
2009-05-05 00:00:00
Spreadsheet: 138133d1327524677-data-extraction-help-please-tigeravatar-example-for-dcmills
Sheet: Sheet1

NAME | LIKES |  | Name | Bread | Spaghetti | Soup
Name1 | Bread |  | Name1 | 1 | 1 | 0
[NAME] | Bread |  | [NAME] | 1 | 0 | 0
Name3 | Spaghetti |  | Name4 | 1 | 0 | 0
Name4 | Bread
Name1 | Spaghetti
Name5 | Soup
Name5 | Spaghetti
Spreadsheet: 127678d1320466111-copy-values-only-from-raw-data-example-1
Sheet: Summary

Agent Name | Evaluation Score | Date
[NAME] | 2.86 | 02/11/2011
[NAME] | 2.88 | 02/11/2011
Amanda Noreuil | 3 | 02/11/2011
Anita Pankalla | 3 | 01/11/2011
[NAME] | 3 | 02/11/2011
#N/A | 3 | 03/11/2011
#N/A | 3 | 04/11/2011
#N/A | 3 | 05/11/2011
#N/A | 3 | 06/11/2011
Spreadsheet: 889490d1740328928-charts-drop-to-zero-cedward-dynamic-charting-with-zeros
Sheet: Expense Data 

Item | Primary_Expense_Type | Secondary_Expense_Type | Day | Month | Month_2 | Year | Quarter | Week | Units | Amount | Credit_Card | Notes
1 | Personal | Other | 8 |  | 1 | 2025 |  |  |  | 82.28469359306696 | Yes
2 | Automobile | Fuel | 11 |  | 1 | 2025 |  |  |  | 39.67646811998389 | Yes
3 | Food and Grocery | Restaurant | 11 |  | 1 | 2025 |  |  |  | 69.49156098438239 | Yes
4 | Personal | Fitness | 15 |  | 1 | 2025 |  |  |  | 27.00071645922524 | Yes
5 | Personal | Fitness | 15 |  | 1 | 2025 |  |  |  | 27.27007857126716 | Yes
6 | Food and Grocery | Grocery | 21 |  | 1 | 2025 |  |  |  | 40.23349101544306 | Yes
7 | Food and Grocery | Grocery | 21 |  | 1 | 2025 |  |  |  | 1.77496263783441 | Yes
8 | Food and Grocery | Restaurant | 24 |  | 1 | 2025 |  |  |  | 10.47362691963408 | Yes
9 | Personal | Cellphone | 26 |  | 1 | 2025 |  |  |  | 68.51561115593057 | Yes
10 | Personal | Haircut | 29 |  | 1 | 2025 |  |  |  | 20.99786215005292 | No
11 | Food and Grocery | Restaurant | 31 |  | 1 | 2025 |  |  |  | 15.6726373816967 | No
12 | Food and Grocery | Restaurant | 8 |  | 2 | 2025 |  |  |  | 85.03630631856943 | Yes
13 | Personal | Fitness | 15 |  | 2 | 2025 |  |  |  | 0.2970894519524148 | Yes
14 | Food and Grocery | Restaurant | 17 |  | 2 | 2025 |  |  |  | 45.87093496177452 | No
15 | Food and Grocery | Restaurant | 17 |  | 2 | 2025 |  |  |  | 55.56755005130659 | Yes
16 | Personal | Other | 8 |  | 3 | 2025 |  |  |  | 70.06680509369569 | Yes
17 | Automobile | Fuel | 11 |  | 4 | 2025 |  |  |  | 0.008073296978694522 | Yes
18 | Food and Grocery | Restaurant | 11 |  | 4 | 2025 |  |  |  | 72.64749208524513 | Yes
19 | Personal | Fitness | 15 |  | 4 | 2025 |  |  |  | 61.150854846462 | Yes
20 | Personal | Fitness | 15 |  | 4 | 2025 |  |  |  | 47.89256024024242 | Yes
21 | Food and Grocery | Grocery | 21 |  | 4 | 2025 |  |  |  | 67.56404058358221 | Yes
22 | Food and Grocery | Grocery | 21 |  | 5 | 2025 |  |  |  | 90.68280686729653 | Yes
23 | Food and Grocery | Restaurant | 24 |  | 5 | 2025 |  |  |  | 12.75993719602585 | Yes
24 | Personal | Cellphone | 26 |  | 5 | 2025 |  |  |  | 43.28814696362605 | Yes
25 | Personal | Haircut | 29 |  | 5 | 2025 |  |  |  | 60.31789064881792 | No
26 | Food and Grocery | Restaurant | 31 |  | 6 | 2025 |  |  |  | 7.626052286511575 | No
27 | Food and Grocery | Restaurant | 8 |  | 6 | 2025 |  |  |  | 47.39192672557332 | Yes
28 | Personal | Fitness | 15 |  | 7 | 2025 |  |  |  | 42.33140448638142 | Yes
29 | Food and Grocery | Restaurant | 17 |  | 7 | 2025 |  |  |  | 4.043278454776278 | No
30 | Food and Grocery | Restaurant | 17 |  | 7 | 2025 |  |  |  | 25.1857198775677 | Yes
Spreadsheet: 763144d1642008893-if-formula-with-multiple-conditions-resource-allocation-mockup-2022-marcus-gee-
Sheet: Sheet1

 |  |  |  |  |  | 176 |  |  | 160 |  |  | 176
 |  |  |  |  |  | 2022-01-01 00:00:00 |  |  | 2022-02-01 00:00:00 |  |  | 2022-03-01 00:00:00 |  |  | 2022-04-01 00:00:00 |  |  | 2022-05-01 00:00:00 |  |  | 2022-06-01 00:00:00 |  |  | 2022-07-01 00:00:00 |  |  | 2022-08-01 00:00:00 |  |  | 2022-09-01 00:00:00 |  |  | 2022-10-01 00:00:00 |  |  | 2022-11-01 00:00:00 |  |  | 2022-12-01 00:00:00
Project | Name | Start | Finish | Resource | Work | Gil | [NAME] | Raul | Gil | [NAME] | Raul | Gil | [NAME] | Raul | Gil | [NAME] | Raul | Gil | [NAME] | Raul | Gil | [NAME] | Raul | Gil | [NAME] | Raul | Gil | [NAME] | Raul | Gil | [NAME] | Raul | Gil | [NAME] | Raul | Gil | [NAME] | Raul | Gil | [NAME] | Raul
 | Total Resource Commitment by Resource and Month
Client 1 | Task 1
Client 1 | Task 2 | 2022-01-13 00:00:00 | 2022-01-21 00:00:00 | Gil | 40
Client 1 | Task 3 | 2022-01-21 00:00:00 | 2022-01-24 00:00:00 | Gil | 8
Client 1 | Task 4 | 2022-01-31 00:00:00 | 2022-02-01 00:00:00 | Raul | 8
Client 1 | Task 5 | 2022-02-07 00:00:00 | 2022-02-14 00:00:00 | Gil | 40
Client 1 | Task 6 | 2022-02-01 00:00:00 | 2022-02-07 00:00:00 | Gil | 32
Client 1 | Task 7 | 2022-02-22 00:00:00 | 2022-03-10 00:00:00 | Raul | 48
Client 2 | Task 1 | 2022-03-11 00:00:00 | 2022-03-11 00:00:00 | Gil | 8
Client 2 | Task 2 | 2022-03-14 00:00:00 | 2022-03-16 00:00:00 | Gil | 24
Client 2 | Task 3 | 2022-01-18 00:00:00 | 2022-01-31 00:00:00 | [NAME] | 24
Client 2 | Task 4 | 2022-04-15 00:00:00 | 2022-04-18 00:00:00 | Gil | 16
Client 2 | Task 5 | 2022-04-19 00:00:00 | 2022-04-21 00:00:00 | Gil | 20
Client 2 | Task 6 | 2022-02-07 00:00:00 | 2022-02-14 00:00:00 | Raul | 40
Client 2 | Task 7 | 2022-02-22 00:00:00 | 2022-03-10 00:00:00 | Raul | 48
Client 3 | Task 1 | 2022-02-16 00:00:00 | 2022-03-10 00:00:00 | Gil | 48
Client 3 | Task 2 | 2022-03-12 00:00:00 | 2022-03-20 00:00:00 |  | 20
Client 3 | Task 3 | 2022-02-16 00:00:00 | 2022-02-23 00:00:00 | Gil | 16
Client 3 | Task 4 | 2022-03-02 00:00:00 | 2022-03-09 00:00:00 | Gil | 20
Client 3 | Task 5 | 2022-03-02 00:00:00 | 2022-03-07 00:00:00 | Raul | 12
Client 3 | Task 6 | 2022-03-07 00:00:00 | 2022-03-08 00:00:00 | Gil | 4
Client 3 | Task 7 | 2022-02-22 00:00:00 | 2022-03-10 00:00:00 | Gil | 48
Spreadsheet: 80772d1280960576-how-to-stop-a-cell-returning-a-negative-value-sample
Sheet: Sheet1

 | Start Date | End Date | Cost | Pro Rata | Days
 | (Variable) | (Fixed) | (Fixed)
 | 2010-07-12 00:00:00 | 2010-07-22 00:00:00 | 100
 | 2010-07-13 00:00:00 | 2010-07-22 00:00:00 | 70
 | 2010-07-14 00:00:00 | 2010-07-22 00:00:00 | 70
 | 2010-07-15 00:00:00 | 2010-07-22 00:00:00 | 70
 | 2010-07-16 00:00:00 | 2010-07-22 00:00:00 | 70
 | 2010-07-17 00:00:00 | 2010-07-22 00:00:00 | 70
 | 2010-07-18 00:00:00 | 2010-07-22 00:00:00 | 70
 | 2010-07-19 00:00:00 | 2010-07-22 00:00:00 | 70
 | 2010-07-20 00:00:00 | 2010-07-22 00:00:00 | 70
 | 2010-07-21 00:00:00 | 2010-07-22 00:00:00 | 70
 | 2010-07-22 00:00:00 | 2010-07-22 00:00:00 | 70
 | 2010-07-22 00:00:00 | 2010-07-22 00:00:00 | 80
 | 2010-07-22 00:00:00 | 2010-07-22 00:00:00 | 90
 | 2010-07-22 00:00:00 | 2010-07-22 00:00:00 | 100
 | 2010-07-22 00:00:00 | 2010-06-22 00:00:00 | 100
Spreadsheet: 679083d1590172569-conditional-formatting-based-on-date-highlight-catergories-with-alternate-colours-etaf
Sheet: Sheet2

2020-02-01 09:30:00
2020-02-01 10:30:00
2020-02-03 09:30:00
2020-02-03 12:30:00
2020-02-05 09:30:00
2020-02-06 09:30:00
2020-02-07 09:30:00
2020-02-07 20:30:00
2020-02-07 12:30:00
2020-02-07 01:30:00
2020-02-11 09:30:00
2020-02-12 09:30:00
Spreadsheet: a11929d2-fe79-4c5f-93c0-ce148da45d6e
Sheet: Sheet1

Revised 6/1/2010
The following template may be used to post the district's 2009-10 "actual" and 2010-11 "proposed"
budgets on he district's Web Page in order to comply with the requirements of HB. 1
Budget postings are required to remain on the district's webpage throughout the school's fiscal year.
Use your latest amended expenditure budget numbers to complete the column "2009-10  current budget"
on the "Data Entry_Web Posting" sheet.  Use your "projected" budget numbers in the column "2010-11
proposed budget."
Data will import to the "Web Page Notice of Budgets" for posting on your Web Page
Woody Brewton
Region 12 ESC
[EMAIL]
[PHONE]
[NAME]
Region 12 ESC
[EMAIL]
[PHONE]
[NAME]
Region 12 ESC
[EMAIL]
[PHONE]
Spreadsheet: 799966d1665417576-count-and-display-duplicates-in-an-array-display_duplicates
Sheet: display_duplicates

COUNT AND DISPLAY DUPLICATES OF A COLUMN |  |  |  | (case-sensitive)
array: | =A8:A30
formula:
expected result: | 2 A, 3 B, 2 b
grade
A
B
C
D
E
A
B
F
b
b
B
G
H
I
T
R
Z
Spreadsheet: 013f3900-eda6-4137-a7c0-9ebf1e372e18
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
 |  |  |  |  |  |  |  |  |  |  |  | RESTROOMS
 |  | field layout
 |  |  | 4 | E |  | 5 | E |  | 6 | E |  | 7 | E
 |  |  | 4 | W |  | 5 | W |  | 6 | W |  | 7 | W
 | 1NE |  | 1SE
 |  |  |  |  |  | 3N |  |  | 3S |  |  |  | 8N |  |  | 8S
 |  | 1E
 |  |  |  |  |  |  |  |  |  |  |  |  | 9N |  |  | 9S
 |  |  |  |  |  | 2N |  |  | 2S
 |  | 1W
 |  |  |  |  |  |  |  |  |  |  |  |  | CONCESSION
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 1NW |  | 1SW
Spreadsheet: 681686d1591701430-add-2-cell-results-together-sales-2020
Sheet: Sheet2

Code | Vessel |  |  |  | Boxes | Total (£) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BCK35 | CALEDONIA BCK35
BCK35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BF61 | TRANSCEND BF61
Merchant | Species | Presentation | Grade | Units |  |  | Total (£) | [NAME] | Total (Kg)
 |  |  |  | Boxes | Weight | Cost |  |  |  |  | Result 1 (BCK35)
 |  |  |  |  |  |  |  |  |  |  | Code | Vessel |  |  |  | Boxes | Total (£)
 |  |  |  |  |  |  |  |  |  |  | BCK35 | CALEDONIA BCK35 |  |  |  | 41 | 2142
 |  |  |  |  |  |  |  |  |  |  | Merchant | Species | Presentation | Grade | Units |  |  | Total (£) | [NAME] | Total (Kg)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Boxes | Weight | Cost
 |  |  |  |  |  |  |  |  |  |  | WC | COD | GH | 2 | 6 | 35 | 106
 |  |  |  |  |  |  |  |  |  |  | WC | COD | GH | 6 | 2 | 35 | 84
 |  |  |  |  |  |  |  |  |  |  | WC | HAD | GH | 2 | 2 | 35 | 89
 |  |  |  |  |  |  |  |  |  |  | WC | HAD | GH | 3 | 2.75 | 35 | 50
 |  |  |  |  |  |  |  |  |  |  | BL | HAD | GH | 4 | 4 | 35 | 50
 |  |  |  |  |  |  |  |  |  |  | BL | HAD | GH | 5 | 9.25 | 35 | 45
 |  |  |  |  |  |  |  |  |  |  | CASH | HAD | GH | 6 | 5 | 35 | 25
 |  |  |  |  |  |  |  |  |  |  | WT | WHG | GH | 2 | 1.25 | 35 | 50
 |  |  |  |  |  |  |  |  |  |  | WC | WHG | WF | 4 | 6.25 | 35 | 35
 |  |  |  |  |  |  |  |  |  |  | [NAME] (BF61)
 |  |  |  |  |  |  |  |  |  |  | Code | Vessel |  |  |  | Boxes | Total (£)
 |  |  |  |  |  |  |  |  |  |  | BF61 | TRANSCEND BF61 |  |  |  | 37 | 2985.75
 |  |  |  |  |  |  |  |  |  |  | Merchant | Species | Presentation | Grade | Units |  |  | Total (£) | [NAME] | Total (Kg)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Boxes | Weight | Cost
 |  |  |  |  |  |  |  |  |  |  | HD | COD | GH | 1 | 10 | 35 | 100
 |  |  |  |  |  |  |  |  |  |  | HD | COD | GH | 2 | 8.75 | 35 | 91
 |  |  |  |  |  |  |  |  |  |  | WC | COD | GH | 3 | 9.75 | 35 | 86
 |  |  |  |  |  |  |  |  |  |  | WL | COD | GH | 4 | 2 | 35 | 80
 |  |  |  |  |  |  |  |  |  |  | WC | HAD | GH | 3 | 1 | 29 | 40
 |  |  |  |  |  |  |  |  |  |  | WC | HAD | GH | 4 | 1 | 40 | 76
 |  |  |  |  |  |  |  |  |  |  | CS | HAD | GH | 5 | 1.25 | 40 | 60
Spreadsheet: 263253d1378414262-compile-weekly-and-monthly-data-from-seperate-file-s-lease-report
Sheet: 3

Month | Week | Well | Failure Date | Suspected Failure | Rig Up | [NAME] | Actual Failure | Expense Cost | Capital Cost | Oil | Water | Gas | Days Down In Month | Lost Oil In Month | Lost Gas In Month | Lost [NAME] This Month | Code | Summary
 |  | 3
 |  |  |  |  |  |  |  |  |  | Code
 |  |  |  |  |  |  |  |  |  | 1 | Parted
 |  |  |  |  |  |  |  |  |  | 2 | Pump Change
 |  |  |  |  |  |  |  |  |  | 3 | Parted Pump
 |  |  |  |  |  |  |  |  |  | 4 | HIT
 |  |  |  |  |  |  |  |  |  | 5 | Polished Rod Change
 |  |  |  |  |  |  |  |  |  | 6 | Other
Spreadsheet: 695526d1600263179-index-match-fetching-same-result-for-1-10-100-or-2-20-200-etc-demo
Sheet: ACTIVITY

CODE | DATA | ENTER CODE | GET DATA
R1 | OK_1 | R1
R2 | OK_2 | R11 J1
R3 | OK_3
R4 | OK_4 | If I enter a value in C2 from A:A I sould get result in D2 from B:B
R5 | OK_5 | If I enter multiple value in C2 it also should get results same as above
R6 | OK_6 | everything is working good but only the problem is the formula only showing results of first match
R7 | OK_7 | I mean if I enter R1 or R10 or R12 or R100 whatever it search and display only fist match of R1
R8 | OK_8 | and if I enter R2 or R20 or R22 etc it shows result for [NAME] only
R9 | OK_9 | I also do not want to limit range (A1:A100), I want to use whole column in formula (A:A)
R10 | OK_10 | Index match is recommended but other formula to achieve my work is also appreciate
R11 | OK_11
R12 | OK_12 | I also tried =LOOKUP(2,1/SEARCH(A:A,C2),B:B) but it shows 0 because it refuses result if found blank cells
R13 | OK_13
R14 | OK_14
R15 | OK_15
Spreadsheet: 873651d1720160023-unpivot-via-formula-from-dynamic-array-output-dlhut-unpivot-columns-via-formula-aligw
Sheet: Sheet1

 | FY25 |  |  |  |  |  |  |  | FY26 |  |  |  | Fiscal | Quarter | Date | Category | Amount
 | Q1 |  |  |  | Q2 |  |  |  | Q1 |  |  | Forecast | FY25 | Q1 | P.O's | 45444 | 5
 | 45444 | 45474 | 45505 | Q1FY25 Total | 45536 | 45566 | 45597 | Q2FY25 Total | 55555 |  |  | Forecast | FY25 | Q1 | P.O's | 45474 | 2
P.O's | 5 | 2 | 0 | 7 | 3 | 3 | 3 | 9 | 10 |  |  | Forecast | FY25 | Q1 | P.O's | 45505 | 0
Overheads | 1 | 1 | 1 | 3 | 2 | 2 | 2 | 6 | 10 |  |  | Forecast | FY25 | Q1 | P.O's | Q1FY25 Total | 7
Revenues | 15 | 35 | 45 | 95 | 30 | 40 | 50 | 120 | 10 |  |  | Forecast | FY25 | Q2 | P.O's | 45536 | 3
 |  |  |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q2 | P.O's | 45566 | 3
 |  |  |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q2 | P.O's | 45597 | 3
 |  |  | Dynamic Array |  |  |  |  |  |  |  |  | Forecast | FY25 | Q2 | P.O's | Q2FY25 Total | 9
 |  |  |  |  |  |  |  |  |  |  |  | Forecast | FY26 | Q1 | P.O's | 55555 | 10
 |  |  |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q1 | Overheads | 45444 | 1
 |  |  |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q1 | Overheads | 45474 | 1
 |  |  |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q1 | Overheads | 45505 | 1
 |  |  |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q1 | Overheads | Q1FY25 Total | 3
 |  |  |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q2 | Overheads | 45536 | 2
 |  |  |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q2 | Overheads | 45566 | 2
 |  |  |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q2 | Overheads | 45597 | 2
 |  |  |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q2 | Overheads | Q2FY25 Total | 6
 |  |  |  |  |  |  |  |  |  |  |  | Forecast | FY26 | Q1 | Overheads | 55555 | 10
 |  |  |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q1 | Revenues | 45444 | 15
 |  |  |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q1 | Revenues | 45474 | 35
 |  |  |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q1 | Revenues | 45505 | 45
 |  |  |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q1 | Revenues | Q1FY25 Total | 95
 |  |  |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q2 | Revenues | 45536 | 30
 |  |  |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q2 | Revenues | 45566 | 40
 |  |  |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q2 | Revenues | 45597 | 50
 |  |  |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q2 | Revenues | Q2FY25 Total | 120
 |  |  |  |  |  |  |  |  |  |  |  | Forecast | FY26 | Q1 | Revenues | 55555 | 10
Spreadsheet: 842336d1694447813-conditional-formating-to-fill-colour-on-rows-based-on-value-input-in-cell-forum
Sheet: Sheet1

 |  |  | Search Criteria :
Phone # | Box Serial # | Name
801110022 | 10090075663800fdf | [NAME]
869927738 | 10090075663800fje | [NAME]
766771818 | 10090075663800faa | [NAME]
766299921 | 10090075663800fac | [NAME]
802227733 | 10090075663800fdb | [NAME]
902238877 | 10090075663800fjc | [NAME]
102220001 | 10090075663800fad | [NAME]
203330222 | 10090075663800ffj | [NAME]
Spreadsheet: 81087d1281362564-vlookup-query-lowest2
Sheet: Lowest

>100 | Supplier | >250 | Supplier | >500 | Supplier | >1000 | Supplier
21.5 |  | 21.4 |  | 21.33333333333334 |  | 20.2
23.54 |  | 23.08333333333333 |  | 22 |  | 21.58333333333333
20.1 |  | 19.27 |  | 18.83 |  | 18.6
15.83333333333333 |  | 15.54166666666667 |  | 14.83333333333333 |  | 12.04166666666667
21.33 |  | 20.91666666666667 |  | 20 |  | 19.58333333333334
22.04166666666667 |  | 21.625 |  | 20.66666666666667 |  | 20.25
11.75 |  | 11.5 |  | 11.08333333333333 |  | 10.83333333333333
12.5 |  | 12.25 |  | 11.75 |  | 11.5
10.17 |  | 9.99 |  | 9.75 |  | 9.44
8.166666666666668 |  | 8.041666666666668 |  | 7.750000000000001 |  | 7.625000000000001
9.83 |  | 9.77 |  | 9.53 |  | 9.31
10.49 |  | 10.43 |  | 10.32 |  | 9.99
9.35 |  | 9.35 |  | 9.35 |  | 9.35
9.95 |  | 9.95 |  | 9.95 |  | 9.95
7.44 |  | 7.44 |  | 7.41 |  | 7.25
8.15 |  | 8.15 |  | 8.11 |  | 7.95
7.39 |  | 7.15 |  | 6.93 |  | 6.74
8.11 |  | 7.87 |  | 7.64 |  | 7.45
8.358695652173914 |  | 8.23 |  | 7.99 |  | 7.68
9.166666666666668 |  | 8.92 |  | 8.666666666666668 |  | 8.36
6.74 |  | 6.51 |  | 6.38 |  | 6.11
7.2 |  | 7.18 |  | 7.05 |  | 6.77
6.55 |  | 6.11 |  | 6.03 |  | 5.87
7.16 |  | 6.72 |  | 6.63 |  | 6.47
5.79 |  | 5.36 |  | 5.29 |  | 5.13
5.33 |  | 5.41 |  | 5.24 |  | 5.12
5.333333333333334 |  | 5.233333333333333 |  | 5 |  | 4.875
Spreadsheet: 153358d1335883893-count-y-based-on-several-conditions-resources-and-date
Sheet: Sheet1

 |  | January |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Novemeber |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December
 | 2011-12-31 12:00:00
Resource 1
Resource 2
Resource 3
Resource 4
Resource 5
Resource 6
Resource 7
Resource 8
Resource 9
Resource 10
Resource 11
Resource 12
Resource 13
Resource 14
Resource 15
Resource 16
Resource 17
Resource 18
Resource 19
Resource 20
Resource 21
Resource 22
Resource 23
Resource 24
Resource 25
Resource 26