tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 703882d1605206233-if-isnumber-search-and-or-with-extra-criteria-erf-log-projects
Sheet: In Progress

EQUALS FORMULA | Site [NAME] | Date (Estimate Complete) | SORT ALL FROM HERE Date  (Outage Start) | Need by Date | Notes | SN# or PO# or  WBS# | SO# (ZM02, ZM03) OR MHPS Standard Order
Spreadsheet: vkaminski__40688__Hedacount
Sheet: Allocations

 | ENE/RAC | [NAME] | ENE Europe | EES | EI | EBS | ENE NA |  |  | Total
VK
VS
AD
[NAME]
JH
GM
VAC1
MRC
RI
FL
YK
GM
TT
VT
TH
AH
KK
SL |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
VAC1
VAC2
VAC3
KP
RC
OS
AK
VAC1
VAC2
VAC3
[NAME]
VAC5
SG
ZL
PI
BL
VAC1
ST
CS
SK
ML
SG
VAC2
MR
JV
PT
EK
VAC1
VAC2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | GRM | ENA-GRM
Spreadsheet: lisa_gang__22305__ENA_PGE_MAY_ 24_25_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date: | 5/24-25/2002
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  |  |  |  | Total In To PGE Trans
0100 |  |  |  |  | 0 | 0
0200 | 0 | 0 | 0 | 0 | 0 | 0
0300 | 0 | 0 | 0 | 0 | 0 | 0
0400 | 0 | 0 | 0 | 0 | 0 | 0
0500 | 0 | 0 | 0 | 0 | 0 | 0
0600 | 0 | 0 | 0 | 0 | 0 | 0
0700 | 25 | 25 | 25 | 25 | 25 | 25
0800 | 25 | 25 | 25 | 25 | 25 | 25
0900 | 25 | 25 | 25 | 25 | 25 | 25
1000 | 25 | 25 | 25 | 25 | 25 | 25
1100 | 25 | 25 | 25 | 25 | 25 | 25
1200 | 25 | 25 | 25 | 25 | 25 | 25
1300 | 25 | 25 | 25 | 25 | 25 | 25
1400 | 25 | 25 | 25 | 25 | 25 | 25
1500 | 25 | 25 | 25 | 25 | 25 | 25
1600 | 25 | 25 | 25 | 25 | 25 | 25
1700 | 25 | 25 | 25 | 25 | 25 | 25
1800 | 25 | 25 | 25 | 25 | 25 | 25
1900 | 25 | 25 | 25 | 25 | 25 | 25
2000 | 25 | 25 | 25 | 25 | 25 | 25
2100 | 25 | 25 | 25 | 25 | 25 | 25
2200 | 25 | 25 | 25 | 25 | 25 | 25
2300 | 0 | 0 | 0 | 0 | 0 | 0
2400 | 0 | 0 | 0 | 0 | 0 | 0
 | BPA(G)24711 | BPA(G)24718 | BPA(G)24727 | BPA(G)24771 | BPA(G)24547 | BPA(G)24547
 | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD
 | AEP | AEP | AEP | AEP | AEP | AEP
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | AEP | AEP | AEP | AEP | AEP | AEP
 | CDWR | CDWR | TID | TEMU | PPM | MID
 | ISO(T)MALIN/NP15 | ISO(T)MALIN/NP15 | TID(T)CPJK/TRACEY/WESLEY | IPC | MORGAN | MID(T)CPJK/TRACEY/WESLEY
 | CDWR(L,FS)NP15 (CA) | CDWR(L,FS)NP15 (CA) | TID | ISO(T)MALIN/NP15 | APX | MID(L)WESLEY
 |  |  | TID(L)WESLEY | IPC(L)NP15 | ISO(T)MALIN/NP15
 |  |  |  |  | APX(L)NP15
Spreadsheet: 852674d1702629860-how-do-i-get-the-item-name-out-from-the-item-descriptions-excel-f0rmula
Sheet: Sheet1

MATERIAL - DOT Safety Standard, Beautiful glossy UV protective finished, Light weight but extremely durable composite shell, keeps your kids safe and comfy while riding! (Secom)[Helmet] Black-White edition 2023 Suze: L Heavily cushioned, breathable and very comfortable interior, Removable and washable padding, well vented all purpose product for everywhere you ride in summer or winter FUN RIDES AND GIFTS - Various interesting and fashion patterns design makes this helmet funny and cool; Great for youth kids dirt bike, off-road, street riding, etc, absolutely a sweet birthday/Christmas gift for children HELMET SIZE - S/M/L/XL Size For Youth; Small:19.15 / 19.50 Inches; Medium:20.10 / 20.45 Inches; Large:20.87 / 21.26 Inches; X-Large(=Adult S):21.65 / 22.5 Inches PACKAGE INCLUDED - 1 x Helmet,1 x Helmet Bag,1 x Goggles (One
MATERIAL - DOT Safety Standard, Beautiful glossy UV protective finished, Light weight but extremely durable composite shell, keeps your kids safe and comfy while riding! [Helmet] Black-White edition 2023 Suze: L Heavily cushioned, breathable and very comfortable interior, Removable and washable padding, well vented all purpose product for everywhere you ride in summer or winter FUN RIDES AND GIFTS - Various interesting and fashion patterns design makes this helmet funny and cool; Great for youth kids dirt bike, off-road, street riding, etc, absolutely a sweet birthday/Christmas gift for children HELMET SIZE - S/M/L/XL Size For Youth; Small:19.15 / 19.50 Inches; Medium:20.10 / 20.45 Inches; Large:20.87 / 21.26 Inches; X-Large(=Adult S):21.65 / 22.5 Inches PACKAGE INCLUDED - 1 x Helmet,1 x Helmet Bag,1 x Goggles (One
Spreadsheet: 711536d1609774608-tracking-total-hours-per-year-between-two-parties-sample
Sheet: Travel Data

Exchange Location | My Distance |  |  |  |  | Her Distance |  |  |  |  |  |  |  |  |  |  | Exchange Location | Pick Up |  | Drop Off |  | Total
 | Highway |  |  |  |  | Highway |  |  |  |  | [NAME]
 | Distance |  | Time |  |  | Distance |  | Time |  |  | Distance |  | Time
Location C | 0 | km | 0 | min |  | 99.2 | km | 68 | min |  | 103 | km | 97 | min |  |  | Location C | 9 |  | 8
Location B | 60 | km | 41 | min |  | 42.1 | km | 31 | min |  | 40.4 | km | 42 | min |  |  | Location B | 8 |  | 8
Location A | 99.2 | km | 67 | min |  | 0 | km | 0 | min |  | 0 | km | 0 | min |  |  | Location A | 13 |  | 13
Location D | 83.4 | km | 60 | min |  | 23.9 | km | 28 | min |  | 23.9 | km | 28 | min |  |  | Location D | 2 |  | 0
Location E | 48.8 | km | 35 | min |  | 55.7 | km | 38 | min |  | 52.6 | km | 50 | min |  |  | Location E | 0 |  | 1
Location F | 11.3 | km | 12 | min |  | 95.5 | km | 61 | min |  | 95.5 | km | 97 | min |  |  | Location F | 2 |  | 0
Location G | 24.1 | km | 23 | min |  | 78.6 | km | 52 | min |  | 77.9 | km | 78 | min |  |  | Location G | 0 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Exchange Location | My Distance |  |  |  |  | Her Distance
 | Highway |  |  |  |  | Highway |  |  |  |  | [NAME]
 | Distance |  | Time |  |  | Distance |  | Time |  |  | Distance |  | Time
Location C |  | km |  | min |  |  | km |  | min |  |  | km |  | min
Location B |  | km |  | min |  |  | km |  | min |  |  | km |  | min
Location A |  | km |  | min |  |  | km |  | min |  |  | km |  | min
Location D |  | km |  | min |  |  | km |  | min |  |  | km |  | min
Location E |  | km |  | min |  |  | km |  | min |  |  | km |  | min
Location F |  | km |  | min |  |  | km |  | min |  |  | km |  | min
Location G |  | km |  | min |  |  | km |  | min |  |  | km |  | min
Total |  | km |  | min |  |  | km |  | min |  |  | km |  | min
Total - Both Ways |  | km |  | min |  |  | km |  | min |  |  | km |  | min
 | - | - |  | hrs |  | - | - |  | hrs |  | - | - |  | hrs
 | - | - |  | hrs |  | - | - |  | hrs |  | - | - |  | hrs
Spreadsheet: 5a1b8dd8-c21a-483d-bcd8-7c864a8f9e3a
Sheet: Sheet1

Windstream Corporation | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
[NAME] From Current Businesses
Reconciliations of Non-GAAP Financial Measures
Net Debt to Operating Income
for the twelve months ended March 31:
(Dollars in millions) |  |  |  |  |  | 2007
Long-term debt, including current maturities |  |  |  |  |  | 5488.6
Cash and short-term investments |  |  |  |  |  | -397.6
Net debt |  |  |  |  | (A) | 5091
Expected debt retirement from directory publishing sale |  |  |  |  |  | -250
Pro forma net debt |  |  |  |  | (B) | 4841
Operating Income
for the twelve months ended March 31:
(Dollars in millions)
Operating income under GAAP |  |  |  |  |  | 994.6
Pro forma adjustments:
 | Valor operating income |  |  |  |  | 36.6
 | Customer list amortization |  |  |  |  | -13.1
 | Royalty expense |  |  |  |  | 62.4
 | Restructuring and other charges |  |  |  |  | 67.4
 | Discontinuance of SFAS No. 71 |  |  |  |  | 2.3
Depreciation and amortization |  |  |  |  |  | 509.5
Pro forma OIBDA from current businesses |  |  |  |  | (C) | 1659.7
Adjustment for sale of directory publishing |  |  |  |  |  | -65.2
Adjusted pro forma OIBDA from current businesses |  |  |  |  | (D) | 1594.5
Net debt to OIBDA from current businesses |  |  |  |  | (A)/(C) | 3.067421823221064
Net debt to OIBDA from current businesses giving
effect to the directory publishing transaction |  |  |  |  | (B)/(D) | 3.036061461273126
Spreadsheet: 273b6b81-5121-4348-a562-319be0aee87b
Sheet: Cashflow - ATVI

 | [NAME], INC. AND SUBSIDIARIES
 | CONDENSED CONSOLIDATED STATEMENTS OF CASH FLOWS
 | (Amounts in millions)
 |  |  |  |  | For the Years Ended December 31,
 |  |  |  |  | 2010 | 2009
 | Cash flows from operating activities:
 |  | Net income (loss) |  |  | 418 | 113
 |  | Adjustments to reconcile net income (loss) to net cash provided by operating activities:
 |  |  | Deferred income taxes |  | -278 | -256
 |  |  | Impairment of intangible assets |  | 326 | 409
 |  |  | Depreciation and amortization |  | 198 | 347
 |  |  | (Gain) loss on auction rate securities ("ARS") classified as trading securities |  | -7 | -3
 |  |  | Loss on ARS rights from UBS |  | 7 | 3
 |  |  | Loss on disposal of property and equipment |  | 1 | 2
 |  |  | Amortization and write-off of capitalized software development costs and intellectual property licenses (1) |  | 319 | 281
 |  |  | Stock-based compensation expense (2) |  | 131 | 156
 |  |  | Excess tax benefits from stock option exercises |  | -22 | -79
 |  | Changes in operating assets and liabilities:
 |  |  | Accounts receivable |  | 76 | 235
 |  |  | Inventories |  | 124 | 21
 |  |  | Software development and intellectual property licenses |  | -313 | -308
 |  |  | Other assets |  | 17 | -110
 |  |  | Deferred revenues |  | 293 | 503
 |  |  | Accounts payable |  | 70 | -18
 |  |  | Accrued expenses and other liabilities |  | 16 | -113
 |  | Net cash provided by operating activities |  |  | 1376 | 1183
 | Cash flows from investing activities:
 |  | Proceeds from maturities of investments |  |  | 519 | 44
 |  | Proceeds from sale of ARS classified as trading securities |  |  | 61 | —
 |  | Proceeds from sale of available-for-sale investments |  |  | — | 2
 |  | Payment of contingent consideration |  |  | -4 | —
 |  | Purchases of available-for-sale investments |  |  | -800 | -425
 |  | Capital expenditures |  |  | -97 | -69
 |  | Decrease in restricted cash |  |  | 9 | 5
 |  | Net cash provided by (used in) investing activities |  |  | -312 | -443
 | Cash flows from financing activities:
 |  | Proceeds from issuance of common stock to employees |  |  | 73 | 81
 |  | Repurchase of common stock |  |  | -959 | -1109
 |  | Dividends paid |  |  | -189 | —
 |  | Excess tax benefits from stock option exercises |  |  | 22 | 79
 |  | Net cash provided by (used in) financing activities |  |  | -1053 | -949
 | Effect of foreign exchange rate changes on cash and cash equivalents |  |  |  | 33 | 19
 | Net increase (decrease) in cash and cash equivalents |  |  |  | 44 | -190
 | Cash and cash equivalents at beginning of period |  |  |  | 2768 | 2958
 | Cash and cash equivalents at end of period |  |  |  | 2812 | 2768
 | (1) Excludes deferral and amortization of stock-based compensation expense.
 | (2) Includes the net effects of capitalization, deferral, and amortization of stock-based compensation expense.
Spreadsheet: 887464d1737695660-shift-byrow-column-range-by-criteria-offset-shift-byrow-column-by-criteria
Sheet: Sheet1

Original Data (not dynamic array) |  |  |  |  |  |  |  |  |  | Lookup Table (tblLookup) |  |  |  | row_num |  | column_num
Region | Type | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 |  |  | Type | Offset |  |  |  |  |  | 3 | 4 | 5 | 6 | #N/A
North | A | 2 | 3 | 5 |  | 10 | 5 |  |  | A | 1 |  |  | 2 |  | 3 | 4 | 5 | 6 | #N/A | #N/A
North | B | 2 |  |  | 9 | 5 | 5 |  |  | B | 2 |  |  | 3 |  | 4 | 5 | 6 | #N/A | #N/A | #N/A
North | C | 7 | 8 | 3 | 2 | 1 | 8 |  |  | C | 3 |  |  | 4 |  | 2 | 3 | 4 | 5 | 6 | #N/A
South | A | 6 | 4 | 1 | 7 | 6 | 4 |  |  |  |  |  |  | 5 |  | 3 | 4 | 5 | 6 | #N/A | #N/A
South | B | 6 | 2 | 6 | 4 | 1 | 1 |  |  |  |  |  |  | 6 |  | 4 | 5 | 6 | #N/A | #N/A | #N/A
South | C | 3 | 8 | 3 | 6 | 8 | 2
Desired Result in Dynamic Array |  |  |  |  |  |  | Dynamic Array from 'Original'
Region | Type |  | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 |  |  |  |  |  |  |  |  |  | Type | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00
 | A |  | 5 | 0 | 10 | 5 |  |  |  | 5 | 0 | 10 | 5 |  |  | North | A | 3 | 5 | 0 | 10 | 5
South | A |  | 1 | 7 | 6 | 4 |  |  | 4 | 1 | 7 | 6 | 4 |  |  | South | A | 4 | 1 | 7 | 6 | 4
North | B |  | 9 | 5 | 5 |  |  |  | 0 | 9 | 5 | 5 |  |  |  | North | B | 0 | 9 | 5 | 5
South | B |  | 4 | 1 | 1 |  |  |  | 6 | 4 | 1 | 1 |  |  |  | South | B | 6 | 4 | 1 | 1
North | C |  | 1 | 8 |  |  |  |  | 2 | 1 | 8 |  |  |  |  | North | C | 2 | 1 | 8
South | C |  | 8 | 2 |  |  |  |  | 6 | 8 | 2 |  |  |  |  | South | C | 6 | 8 | 2
 |  |  |  |  | Desired Result in 'Red Box' to be dynamic array based
 |  |  |  |  | on the output/result of cell A16# and C15#
 | Dynamic Array from 'Original'
Spreadsheet: 74927d1275471504-excel-sheet-for-trading-system-alligator-calculator
Sheet: AA 28

28 |  | Alligator Calculator - Copyright 2007 [NAME]
 |  | Tradeable | Tradeable
 |  | Weakness | Strength | MAX
 |  | 8 | 13 | 21 |  | USD | 0 | 0
 |  | 8 | 13 | 21 |  | GBP | 13 | 0.6190476190476191
 |  | 8 | 13 | 21 |  | EUR | 9 | 0.4285714285714285
 |  | 8 | 13 | 21 |  | [NAME] | 3 | 0.1428571428571428
 |  | 8 | 13 | 21 |  | CHF | 6 | 0.2857142857142857
 |  | 8 | 13 | 21 |  | CAD | 14 | 0.6666666666666666
 |  | 8 | 13 | 21 |  | AUD | 18 | 0.8571428571428571
 |  | 8 | 13 | 21 |  | NZD | 21 | 1
 |  |  |  | 1 | [NAME] | 3 | 0
 |  |  |  | 2 | EURUSD | 3 | 0
 |  |  |  | 3 | USDCHF | 0 | 3
 |  |  |  | 4 | USDJPY | 0 | 3
 |  |  |  | 5 | GBPJPY | 3 | 0
 |  |  |  | 6 | EURJPY | 3 | 0
 |  |  |  | 7 | CHFJPY | 3 | 0
 |  |  |  | 8 | AUDJPY | 3 | 0
 |  |  |  | 9 | NZDJPY | 3 | 0
 |  |  |  | 10 | CADJPY | 3 | 0
 |  |  |  | 11 | GBPCHF | 3 | 0
 |  |  |  | 12 | EURGBP | 0 | 3
 |  |  |  | 13 | GBPCAD | 1 | 2
 |  |  |  | 14 | USDCAD | 0 | 3
 |  |  |  | 15 | EURCAD | 0 | 3
 |  |  |  | 16 | AUDCAD | 3 | 0
 |  |  |  | 17 | NZDCAD | 3 | 0
 |  |  |  | 18 | CADCHF | 3 | 0
 |  |  |  | 19 | AUDUSD | 3 | 0
 |  |  |  | 20 | NZDUSD | 3 | 0
 |  |  |  | 21 | EURCHF | 3 | 0
 |  |  |  | 22 | EURAUD | 0 | 3
 |  |  |  | 23 | AUDCHF | 3 | 0
 |  |  |  | 24 | AUDNZD | 0 | 3
 |  |  |  | 25 | GBPAUD | 0 | 3
 |  |  |  | 26 | GBPNZD | 0 | 3
 |  |  |  | 27 | NZDCHF | 3 | 0
 |  |  |  | 28 | EURNZD | 0 | 3
Spreadsheet: 718435d1613140193-return-a-value-based-on-multiple-date-ranges-lookup-issue
Sheet: Sheet1

Home Type | Block Color | Manager | Start Date | End Date |  |  | Home Type | Block Color | Date | Manager?
Townhome | White | [NAME] | 2020-11-05 00:00:00 | 2021-02-12 00:00:00 |  |  | Townhome | White | 2020-12-20 00:00:00
Townhome | White | [NAME] | 2019-12-10 00:00:00 | 2020-11-04 00:00:00 |  |  | Townhome | White | 2021-01-31 00:00:00
Townhome | Green | [NAME] | 2020-11-05 00:00:00 | 2021-02-12 00:00:00 |  |  | Townhome | Green | 2020-03-28 00:00:00
Townhome | Green | Bell | 2019-12-10 00:00:00 | 2020-11-04 00:00:00 |  |  | Townhome | Green | 2020-11-06 00:00:00
Condo | White | Alfonsi | 2020-11-05 00:00:00 | 2021-02-12 00:00:00 |  |  | Condo | White | 2020-08-30 00:00:00
Condo | White | [NAME] | 2019-12-10 00:00:00 | 2020-11-04 00:00:00 |  |  | Condo | White | 2020-11-14 00:00:00
Single Home | Blue | Alfonsi | 2020-11-05 00:00:00 | 2021-02-12 00:00:00 |  |  | Single Home | Blue | 2020-05-08 00:00:00
Single Home | Blue | [NAME] | 2020-03-20 00:00:00 | 2020-11-04 00:00:00 |  |  | Single Home | Blue | 2020-12-23 00:00:00
Spreadsheet: 356427d1415112024-conditional-formatting-forum_formatting-ndm
Sheet: Before Shipment

Code | Size | Product per case |  | Order1 | Order2 |  | 2014 |  | Stock level on: |  | Order3 | Order4 | Order5 | Order6 | Order7 | Order8 | Order9 |  | WIP AND UNSHIPPED | FREE STOCK FOR FILL UP
 |  |  |  | CS1 | CS2 |  | Total sales and shipped |  | 2014-09-15 00:00:00 |  | CS3 | CS4 | CS5 | CS6 | CS7 | CS8 | CS9
 |  | Order received date |  | 2014-06-01 00:00:00 | 2014-06-01 00:00:00 |  |  |  |  |  | 2014-06-15 00:00:00 | 2014-06-15 00:00:00 | 2014-06-15 00:00:00 | 2014-06-29 00:00:00 | 2014-06-29 00:00:00 | 2014-06-29 00:00:00 | 2014-06-29 00:00:00
 |  | Week Commencing |  | 2014-09-15 00:00:00 | 2014-09-15 00:00:00 |  |  |  |  |  | 2014-09-22 00:00:00 | 2014-09-22 00:00:00 | 2014-09-22 00:00:00 | 2014-06-26 00:00:00 | 2014-06-26 00:00:00 | 2014-06-26 00:00:00 | 2014-06-26 00:00:00
 |  | Shipment Date |  | 2014-09-18 00:00:00 | 2014-09-18 00:00:00 |  |  |  |  |  | 2014-09-26 00:00:00 | 2014-09-26 00:00:00 | 2014-09-26 00:00:00 | 2014-09-29 00:00:00 | 2014-09-29 00:00:00 | 2014-09-29 00:00:00 | 2014-09-29 00:00:00
 |  | Invoice Date |  | x | x |  |  |  |  |  | x | x |  |  | x
Cotton |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Option 1
12 001 | Extra Small / 6 | 500 |  | 1 | 0 |  |  |  | 11 |  | 2 | 0 | 10 | 6 | 0 | 1 | 6 |  |  |  |  | G11=0 | White
13 001 | Small / 7 | 500 |  | 50 | 0 |  |  |  | 88 |  | 10 | 0 | 15 | 5 | 0 | 50 | 5 |  |  |  |  | E11-G11-H11<0 |  | Red
14 001 | Medium / 8 | 500 |  | 26 | 0 |  |  |  | 65 |  | 10 | 0 | 19 | 10 | 0 | 26 | 10 |  |  |  |  | E11-G11-H11-I11>=0 |  | Green
15 001 | Large / 9 | 500 |  | 25 | 0 |  |  |  | 55 |  | 10 | 0 | 15 | 7 | 0 | 25 | 7 |  |  |  |  | I11>0 | Orange
16 001 | Extra Large / 10 | 500 |  | 15 | 0 |  |  |  | 42 |  | 10 | 0 | 18 | 15 | 0 | 15 | 15
 |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Option 2
Silk |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AND(E11<>"",E11-G11-H11-I11>=0) |  |  |  | Green
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =0 |  |  |  | Maintain
21 001 | Extra Small / 6 | 500 |  | 0 | 0 |  |  |  | 69 |  | 20 | 0 | 3 | 0 | 0 | 0 | 0
22 001 | Small / 7 | 500 |  | 40 | 0 |  |  |  | 604 |  | 96 | 96 | 32 | 0 | 96 | 40 | 0
23 001 | Medium / 8 | 500 |  | 50 | 0 |  |  |  | 749 |  | 120 | 170 | 64 | 5 | 170 | 50 | 5
24 001 | Large / 9 | 500 |  | 10 | 0 |  |  |  | 310 |  | 204 | 80 | 16 | 2 | 80 | 10 | 2
25 001 | Extra Large / 10 | 500 |  | 0 | 0 |  |  |  | 76 |  | 70 | 20 | 32 | 0 | 20 | 0 | 0
 |  | Total
Polyester
23 001 | Extra Small / 6 | 500 |  | 0 | 0 |  |  |  | 32 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
24 001 | Small / 7 | 500 |  | 30 | 0 |  |  |  | 501 |  | 0 | 5 | 74 | 0 | 5 | 30 | 0
25 001 | Medium / 8 | 500 |  | 50 | 0 |  |  |  | 685 |  | 0 | 8 | 231 | 0 | 8 | 50 | 0
26 001 | Large / 9 | 500 |  | 40 | 0 |  |  |  | 411 |  | 24 | 12 | 128 | 0 | 12 | 40 | 0
27 001 | Extra Large / 10 | 500 |  | 0 | 0 |  |  |  | 248 |  | 0 | 17 | 128 | 0 | 17 | 0 | 0
 |  | Total
Spreadsheet: 270165d1381407711-help-required-to-give-a-formula-that-will-total-various-text-criteria-with-numeric-values-tes01-scheduler-
Sheet: EXAMPLE

 | This scheduler is for visualising future time needs and availability for a period of one week.
 | List the end result as the deliverable, not the task. Mark the due date with estimated time. Input the D# in the scheduler blocks to show when your time is allocated.
 | A-level blocks are 4 hours. B-Level blocks are 2 hours. C-level blocks are 30 mins. Blue blocks are normal work hours, red are overtime hours.
 | [NAME] THIS WEEK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MON |  |  |  |  | TUES |  |  |  |  | WEDS |  |  |  |  | THUR |  |  |  |  | FRI |  |  |  |  | SAT |  |  |  |  | SUN
 |  | JOB NUMBER |  | DELIVERABLE |  |  |  | EST. HRS |  |  |  | DROP DEAD DAY |  |  |  |  |  |  |  |  | D1 |  |  |  |  | D1 |  |  |  |  | D1 |  |  |  | D2 |  |  |  |  |  | D6 |  |  |  |  | D6
 | D1 | 1180 |  | CREATE PRINCIPLES DOCUMENT FOR CSD HARLESDEN |  |  |  | 24 |  | M | T | W | T | F | S | S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D3
 | D2 | 1196 |  | INFORMATION GATHERING MEETING WITH DESIGN MANAGER |  |  |  | 2 |  | M | T | W | T | F | S | S
 | D3 | 1196 |  | STEVENAGE STORE VISIT |  |  |  | 4 |  | M | T | W | T | F | S | S |  |  |  |  | D1 |  |  |  |  | D1 |  |  |  |  | D1 |  |  |  | D3 |  |  |  |  |  | D6 |  |  |  |  | D6
 | D4 | 1187 |  | FARRINGDON SALD BAR HEADER AW & SEND TO PRINT |  |  |  | 1 |  | M | T | W | T | F | S | S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D4 | D4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D5 | D5
 | D5 | / |  | HOUSEKEEPING - FILING |  |  |  | 1 |  | M | T | W | T | F | S | S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D6
 | D6 | 1196 |  | STEVENAGE PRODUCE HEADERS, WGLL & SEND TO PRINT |  |  |  | 20 |  | M | T | W | T | F | S | S
 | D7 |  |  |  |  |  |  |  |  | M | T | W | T | F | S | S
Spreadsheet: 867041d1713950077-comparing-data-in-2-sheets-book1
Sheet: Sheet2

PRN | NUM | STR | PC
1234 | 1 | HIGH | CM21RE
4321 | 2 | HIGH | CM21RE
3456 | 3 | HIGH | CM21RE
7789 | 4 | HIGH | CM21RE
589962 | 5 | HIGH | CM21RE
288982 | 6 | LOW | CM21RE
2878 | 7 | LOW | CM21RE
26551 | 8 | LOW | CM21RE
78273 | 9 | LOW | CM21RE
337377 | 10 | LOW | CM21RE
5663984 | 11 | LOW | CM21RE
5532 | 12 | LOW | CM21RE
225696 | 13 | LOW | CM21RE
2559 | 14 | LOW | CM21RE
22422 | 15 | END | CM21RE
216548 | 16 | END | CM21RE
89321 | 17 | END | CM21RE
3658 | 18 | END | CM21RE
145565 | 19 | END | CM21RE
Spreadsheet: 84706d1284718261-how-can-i-insert-continuous-serial-number-when-only-in-name-exist-in-col-b-sample
Sheet: Sheet1

SN | Name | Address | Plot | Area
1 | A | Kathmandu | 1 | 45
 |  |  | 2 | 55
2 | B | Kathmandu | 1 | 22
 |  |  | 2 | 33
 |  |  | 3 | 33
3 | C | Kathmandu | 1 | 66
4 | D | Kathmandu | 1 | 44
 | Section 1
5 | E | Kathmandu | 1 | 45
 |  |  | 2 | 55
6 | F | Kathmandu | 1 | 22
 |  |  | 2 | 33
 |  |  | 3 | 33
7 | G | Kathmandu | 1 | 66
8 | H | Kathmandu | 1 | 44
 |  | How can I insert serial number when only in Name exist in col B? and [NAME] the Section line too.
Spreadsheet: 784693d1655909290-formula-for-an-other-cel-drop-down-selection-in-d1-aligw
Sheet: Blad1

Name | Amount |  | Atomium Mine
Ambrosia Fountain | 1
Ancient Temple | 3
Astral Predictor | 6
Atlantic Monolith | 3
Atomium Mine | 6
Azure Refiner | 7
[NAME] | 2
Big Bad Blaster | 8
Big bertha | 6
Blind Justice | 1
Clockwork | 4
[NAME] | 3
[NAME] | 2
[NAME]'s Fright | 3
[NAME]'s Might | 6
Eternal Journey | 2
[NAME] | 12
[NAME] | 8
Gate of Eclipse | 4
Green Tea Latte | 5
Industrial Firecrystal Mine | 8
[NAME] | 7
[NAME] | 9
Mineral Wheel | 12
Nature's Grip | 8
Newtonium Mine | 2
Ore Illuminator | 5
Ore Sawmill | 3
Phase Refiner | 1
Pizza Blaster | 3
[NAME] | 11
Quantum ore cleaner | 9
Righteous Will | 1
Sage Redeemer | 9
[NAME] | 4
Scorpium Mine | 5
[NAME] | 3
Tesla Resetter | 8
The Catalyst | 8
The Fracture | 4
Timeless Enhancement | 2
Vortex Chamber | 15
Wild Spore | 5
Yunium Mine | 2
Spreadsheet: 888218d1738690764-additional-ifs-or-another-approach-additional-ifs-or-another-approach
Sheet: Grid

Home Team | Road Team
Eagles | Dragons
 |  |  |  | [NAME] | Lucas | [NAME] | [NAME] | [NAME] | [NAME]
Event |  | [NAME]
200m |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  |  | 10.02 | 10.1 | 10.2 | 10.3 | 10.4 | 10.5 | 10.085
 |  |  | 10.12 | 10.2 | 10.3 | 10.4 | 10.5 | 10.6 | 10.185
 |  |  | 10.22 | 10.3 | 10.4 | 10.5 | 10.6 | 10.7 | 10.285
 |  |  | 10.32 | 10.4 | 10.5 | 10.6 | 10.7 | 10.8 | 10.385
 |  |  | 10.42 | 10.5 | 10.6 | 10.7 | 10.8 | 10.9 | 10.485
 |  |  | 10.005 | 10.085 | 10.185 | 10.285 | 10.385 | 10.485 | 10.07
Eagles
Falcons
Dragons
Bears
M
F