tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 776188d1649577899-i-need-some-help-with-a-better-way-to-search-the-min-max-value-book1
Sheet: Sheet1

Keywords | [NAME] | [NAME] | Min Position | URL | Domain
summer season
valentines day
margarita recipe
orange
sabo skirt
espresso martini
click frenzy
click.frenzy
never have i ever
biscoff
margarita
espresso martini recipe
picnic basket
mr consistent
cocktail
sangria
would you rather
watermelon sugar
[NAME]
bloody mary
cocktail glasses
clickfrenzy
mr
lime
consistent
picnic baskets
afterpay day
tumbler
mocktail recipes
martini glasses
cosmo
sabo
shot glasses
[NAME]
sour
fave
birthday card
eofy sale
rock salt
saboskirt
happy birthday card
mocktail
specials
amaretto sour recipe
whiskey sour recipe
bartender
margarita mix
the waterboy
glassware
margarita glasses
[NAME] cairns
date night
fancy
shipped
preservative 202
waterboy
reflect
how to make a margarita
espresso martini recipes
tumbler glass
alc
trucker hat
margaritas
giftbox
euphoric
good vibes
shake up it
garnish
shaker
starter pack
cocktail mixer
coupe glass
my dates
[NAME]
cosmo recipe
hens night
mr consistent stockists
consistently
mr liquor
[NAME] rockhampton
[NAME]
limes
magasareta
how to make espresso martini
hens party
[NAME]
mr vitamin
punch bowl
mardi gras 2022
vogue online shopping night
[NAME] near me
espresso.martini
myra swim
sweet box
shot glass
would you rather be a
crystal glass
vosn
hope d
mr consistant
student discount
watermelon cocktail
spicy
water boy
the full monty
espresso martini ingredients
georgie stevenson
cyclone ice block
gin gift pack
the sweet
jocks
picnic hamper
cocktail glass
hens
oh baby
mixers
sherbert
punch bowls
cosmo cocktail
who is elijah
love you like that
peachy
dehydrated orange slices
tayla mellington
white bucket hat
picnic sets
how to make an espresso martini
pack.
bottoms up
cyclone icy pole
frankie and co bendigo
elsas wholesome life
[NAME] rouse hill
mr consistent cocktails
dehydrated fruit
mr glass
shake 10
first choice maroochydore
[NAME]
expresso martini recipe
sano skirt
fairy floss cocktail
insulated picnic basket
mrconsistent
vanilla sugar
would you rather game
iga maleny
magarita
gift pack
the water boy
[NAME]
[NAME]
picnic basket australia
cyclone ice blocks
manderine
boujie
stockist
the black full monty
[NAME]
would u rather
best espresso martini recipe
coupe glasses
coconut margarita
cosmopolitan cocktail ingredients
liquorland warners bay
marbel
rather
margarita recipe australia
vogue shopping night
dry chilli
mix.
bar tender
257 collective
dried
mr fresh
iga gerringong
who is elijah perfume
gift.box
serves
up card
gifting
bws karratha
games night
tumbler glasses
pre mixed cocktails
wildberries
edible glitter for drinks australia
cocktail mixer set
dad hat
[NAME] [NAME]
[NAME] sunshine
tangy
glass tumblers
dehydrate
coffee.beans
dried oranges
$5
[NAME]
sours
[NAME]
Spreadsheet: 729930d1619443767-group-and-total-duplicate-values-in-a-column-group-and-total-duplicate-values-in-a-column
Sheet: Sheet1

Customer Name | [NAME]
YTC Ltd | 1
Yorkshire Purchasing Organisation - YPO | 1
YESSS Electrical | 1
X L Technical Services | 1
Wirs (Wolverhampton) Ltd. | 1
[NAME] | 1
[NAME] t/a Sunrise Bakery | 1
WICKES | 1
WICKES | 1
WICKES | 1
WICKES | 1
WICKES | 1
WICKES | 1
WICKES | 1
WICKES | 1
WHS Plastics Ltd | 1
Wholesale POS Limited | 1
[NAME] | 1
Walraven Ltd | 1
Wrights Plastics  Ltd | 2
Widney Manufacturing Ltd | 2
WICKES | 2
WICKES | 2
Zeus Media Ltd | 3
Westgate Global Ltd | 4
Yours Clothing Ltd | 6
Wiggle Ltd - Citadel | 6
XPO Transport Solutions UK Limited | 12
Spreadsheet: 477463d1472304322-program-for-stitching-unit-sample-excel
Sheet: Sheet1

ORDER FORM |  |  |  |  |  |  |  | DELIVERY |  |  |  |  |  |  | LABOR CHARGE
CLIENT NAME |  |  | ORDER
 |  |  |  |  |  |  |  |  |  | DATE | QTY | SIZE | TOTAL
 |  |  |  | SIZE | NOS |  |  | poulco |  |  |  |  |  |  | NAME 1
CLIENT 1 |  |  |  |  |  |  |  |  |  |  |  | small | 160 |  |  | SIZE | NOS | PRICE | TOTAL
 |  |  |  | small | 280 |  |  |  |  |  |  | medium | 130 |  |  | SMALL | 216 | 1.5 | 324
 |  |  |  | medium | 245 |  |  |  |  |  |  | large | 48 |  |  | MEDIUM | 234 | 2 | 468
 |  |  |  | large | 84 |  |  |  |  |  |  | xlarge | 88 |  |  | LARGE | 170 | 2.5 | 425
 |  |  |  | xlarge | 112 |  |  |  |  |  |  |  |  |  |  | X LARGE | 190 | 3 | 570
 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  | TOTAL |  |  |  |  |  |  |  | 426 |  |  | TOTAL |  |  | 1787
 |  |  |  |  | 721
CLIENT 2 |  |  |  | SIZE | NOS |  |  | saidacon |  |  |  | SIZE | NOS |  | [NAME] 2 | SIZE | NOS | PRICE | TOTAL
 |  |  |  | small | 357 |  |  |  |  |  |  | small | 204 |  |  | SMALL | 146 | 1.5 | 219
 |  |  |  | medium | 308 |  |  |  |  |  |  | medium | 162 |  |  | MEDIUM | 62 | 2 | 124
 |  |  |  | large | 112 |  |  |  |  |  |  | large | 44 |  |  | LARGE | 126 | 2.5 | 315
 |  |  |  | xlarge | 56 |  |  |  |  |  |  | xlarge | 28 |  |  | X LARGE | 213 | 3 | 639
 |  |  |  |  | TOTAL |  |  |  |  |  |  |  | TOTAL |  |  | TOTAL |  |  | 1297
 |  |  |  |  | 833 |  |  |  |  |  |  |  | 438
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 2 | SIZE | NOS | PRICE | TOTAL
 |  |  |  | SIZE | NOS |  |  | xyz |  |  |  | small | 228 |  |  | SMALL | 216 | 1.5 | 324
CLIENT 3 |  |  |  | small | 294 |  |  |  |  |  |  | medium | 81 |  |  | MEDIUM | 234 | 2 | 468
 |  |  |  | medium | 329 |  |  |  |  |  |  | large | 102 |  |  | LARGE | 170 | 2.5 | 425
 |  |  |  | large | 238 |  |  |  |  |  |  | xlarge | 168 |  |  | X LARGE | 190 | 3 | 570
 |  |  |  | xlarge | 315
 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  |  | TOTAL |  |  | 1787
 |  |  |  |  | TOTAL |  |  |  |  |  |  |  | 579
 |  |  |  |  | 1176
CLIENT 4
Spreadsheet: 156206d1337223193-how-to-copy-data-from-master-list-sheet-to-another-sheet-based-on-category-ifjsss-round-2-data
Sheet: Data-ProAmStock

THE LANGKAWI INTERNATIONAL
FORMULA JET SKI SUPER SERIES 2012
ROUND 2, PUTRAJAYA
 | MOTO :
 | CATEGORY   :  Pro Am Stock
 | LAPS :  15
 | RACE TIME :
No | RIDER | TEAM | CRAFT | CRAFT TYPE | POINT FROM PREVIOUS ROUND | ROUND 2 |  |  |  | OVERALL POINTS | RANK
 |  |  |  |  |  | MOTO 1 | MOTO 2 | MOTO 3 | MOTO 4
Spreadsheet: 111394d1307744383-copying-and-separating-out-delimited-fields-copying-20and-20separating-20out-20delimited-20fields-20updated-2-
Sheet: SHIPMENTS

Field1 | Field2 | Field3 | Field4 | Row Position | Total Numbers
PART X | DEVICE | 2009-02-26 00:00:00 | 34228Sý39598ý62038ý41379ý42628S | 1 | 5
PART Y | DEVICE2 | 2011-03-10 00:00:00 | 31223ý34000 | 6 | 2
PART Z | [NAME] | 2011-03-11 00:00:00 | 34111 | 8 | 1
Spreadsheet: darron_c_giron__7999__LiqCalc
Sheet: Sheet1

LIQUIDATION CALCULATOR
Tagg # : | ET4748.4 | Transaction: | Buy
 |  | Sale or Buy
Settle Prices |  | Tagg Prices
Nymex | 2 | Price | 1.95
FOM Index | 2.5 | Basis | 0.25
Mid | 0 | Index | 0.01
PRICE |  |  |  |  | Price
Nymex | Tagg Price |  | Firm Volume |  | Liquidation
 |  |  | 300000
BASIS |  |  |  |  | Basis
Basis | Tagg Basis |  | Firm Volume |  | Liquidation
PHYSICAL PREMIUM |  |  |  |  | Physical Premium
Mid Market | Tagg PP |  | Firm Volume |  | Liquidation
 |  |  | Total
Spreadsheet: a15823af-1caf-4305-af1b-b117d7fbbd32
Sheet: MS-Windows

Policy Scripting Sheet for MS-Windows policy(updated: Mar 31 2013)
Command to create the policy:
Command to modify the policy:
 | Attribute Name | Value | Note | Command Option | Notice
x | Policy name |  | Policy name
x | Data classification |  | Data classification name
x | Policy storage |  | Policy storage name
x | Storage is SLP |  | Empty(storage is not SLP), or any characters(storage is SLP)
x | Policy volume pool |  | Policy volume pool name
x | Take checkpoint every X minutes |  | Empty(no checkpoint), or number grater than or equal to 5
x | Limit jobs per policy |  | Empty(unlimited), or number grater than 0
x | Job priority |  | Empty(default), or number grater than or equal to 0
x | Media owner |  | Server Group Name, *ANY*, or *NONE*
x | Go into effect at |  | MM/DD/YYYY HH:MM:SS
x | Backup Network Drives |  | Empty(unchecked), or any characters(checked)
x | Cross mount points |  | Empty(unchecked), or any characters(checked)
x | Compression |  | Empty(unchecked), or any characters(checked)
x | Encryption |  | Empty(unchecked), or any characters(checked)
x | Bare Metal Restore |  | Empty(unchecked), or any characters(checked)
x | Collect true image restore information |  | Empty(unchecked), or any characters(checked)
 | with move detection |  | Empty(unchecked), or any characters(checked)
x | Allow multiple data streams |  | Empty(unchecked), or any characters(checked)
x | Disable client-side deduplication |  | Empty(unchecked), or any characters(checked)
x | Enable granular recovery |  | Empty(unchecked), or any characters(checked)
x | Use accelerator |  | Empty(unchecked), or any characters(checked)
x | [NAME] phrase |  | [NAME] phrase
x | Indexing server |  | Indexing server name
Spreadsheet: 866802d1713721343-extract-data-from-another-worksheet-excluding-rows-without-data-pem-register_-_complied_21april-2024
Sheet: Attika

Plant, Equipment & Machinery Details |  |  |  |  |  |  |  |  |  |  | Inspection & Maintenance Details
No | Type / Category | Description  (as per LM, LP or other equipment certification where available) | Make & Model | Serial No | Equipment ID | Hirer  Company (Trade Partner / Vendor) | Owner of Equipment | Date first mobilized | Last Date on site | Current Status | Statutory Registration No. (LM, LP, AR, etc) | Certification [NAME] | Inspection / Serviving Frequency | Last Inspection / Servicing Date | Next Inspection / Servicing Due Date | PIC | Remarks
 | MEWP - Scissor Lift | Scissor lift | AS0607 | LWJ05010007 | LSB50002 | Attika | OMMI Machinary | 2023-11-02 00:00:00 |  | Active (In Use) | LPL74307L | 2024-05-23 00:00:00 | Monthly | 2024-04-02 00:00:00 |  | [NAME]
 | MEWP - Scissor Lift | Scissor lift | AS0607 | [NAME] | [NAME] | Attika | OMMI Machinary | 2023-11-02 00:00:00 |  | Active (In Use) | LP886673X | 2024-08-21 00:00:00 | Monthly | 2024-04-02 00:00:00 |  | [NAME]
 | MEWP - Scissor Lift | Scissor lift | AS0607 | JO5010042 | LSB50020 | Attika | OMMI Machinary | 2023-11-06 00:00:00 |  | Active (In Use) | LP786265K | 2024-09-20 00:00:00 | Monthly | 2024-04-02 00:00:00 |  | [NAME]
 | MEWP - Scissor Lift | Scissor lift | AS0607 | J05010060 | LSB50022 | Attika | OMMI Machinary | 2023-11-06 00:00:00 |  | Active (In Use) | LP786269L | 2024-09-20 00:00:00 | Monthly | 2024-04-02 00:00:00 |  | [NAME]
 | MEWP - Scissor Lift | Scissor lift | AS0607 | J05010135 | LSB50049 | Attika | OMMI Machinary | 2023-12-11 00:00:00 |  | Active (In Use) | LP805153C | 2024-04-26 00:00:00 | Monthly | 2024-04-02 00:00:00 |  | [NAME]
 | MEWP - Scissor Lift | Scissor lift | [NAME] | XUG0064SPLRL12090 | XSBS7025 | Attika | OMMI Machinary | 2024-02-15 00:00:00 |  | Active (In Use) | LP945387L | 2024-05-28 00:00:00 | Monthly | 2024-04-02 00:00:00 |  | [NAME]
 | MEWP - Others | Man Lift | Genie Awp 30S | [NAME] | V36-30 | Attika | Aver Asia | 2024-01-05 00:00:00 |  | Active (In Use) | LPL85971J | 2024-07-29 00:00:00 | Monthly | 2024-04-02 00:00:00 |  | [NAME]
 | Air Compressor - Diesel Powered
 | Air Compressor - Electric
 | Crane - Mobile
 | Crane - Tower
 | Crane - Others
(click and insert rows here
Spreadsheet: 55874d1256046179-cumulative-totals-exceltip-example
Sheet: Comp1

Requirement
Ref | Other ID | ISIN | Name | Code | Declaration | Nominal | Total Nominal | Pay Amount
123456789 | DOO102034556 | GB1 | The Big Red Fun Bus | APPLE1 | 650000 | 200000 | 800000 | 200000
148568478 | DOO102034556 | GB1 | The Big Red Fun Bus | APPLE1 | 650000 | 300000 | 800000 | 200000
138499345 | DOO102034556 | GB1 | The Big Red Fun Bus | APPLE1 | 650000 | 300000 | 800000 | 250000
235688974 | DOO102034556 | GB2 | The Green Helicopter | SAUCE2 | 200000 | 300000 | 452000 | 200000
265478899 | DOO102034556 | GB2 | The Green Helicopter | SAUCE2 | 200000 | 152000 | 452000 | 0
Solution
Ref | Other ID | ISIN | Name | Code | Declaration | Nominal | Total Nominal | Pay Amount
123456789 | DOO102034556 | GB1 | The Big Red Fun Bus | APPLE1 | 650000 | 200000
148568478 | DOO102034556 | GB1 | The Big Red Fun Bus | APPLE1 | 650000 | 300000
138499345 | DOO102034556 | GB1 | The Big Red Fun Bus | APPLE1 | 650000 | 300000
235688974 | DOO102034556 | GB2 | The Green Helicopter | SAUCE2 | 200000 | 300000
265478899 | DOO102034556 | GB2 | The Green Helicopter | SAUCE2 | 200000 | 152000
Spreadsheet: 872334d1718718782-countif-function-date-ranges-and-cell-exclusions-tracker-aig_s-
Sheet: Sheet1

 |  | Today's date
 |  | Overdue Tasks
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column 10 | Column 11 | Due Date | Revised Date | Column 14 | Status
Task 1 |  |  |  |  |  |  |  |  |  |  | 2024-05-31 00:00:00 | 2024-06-21 00:00:00 |  | In Progress
Task 2 |  |  |  |  |  |  |  |  |  |  | 2024-06-05 00:00:00 | 2024-06-19 00:00:00 |  | Complete
Task 3 |  |  |  |  |  |  |  |  |  |  | TBC |  |  | Not Started
Task 4 |  |  |  |  |  |  |  |  |  |  | 2024-06-15 00:00:00 |  |  | Complete
Task 5 |  |  |  |  |  |  |  |  |  |  | 2024-06-28 00:00:00 | TBC |  | In Progress
Spreadsheet: 546544d1510085219-conditional-formatting-trouble-cf-sample
Sheet: Sheet1

WORKQUEUE | OWNER | BASELINE | 2017-11-01 00:00:00 | 2017-11-02 00:00:00 | 2017-11-03 00:00:00 | 2017-11-04 00:00:00 | 2017-11-05 00:00:00 | 2017-11-06 00:00:00 | 2017-11-07 00:00:00 | 2017-11-08 00:00:00 | 2017-11-09 00:00:00 | 2017-11-10 00:00:00 | 2017-11-11 00:00:00 | 2017-11-12 00:00:00 | 2017-11-13 00:00:00 | 2017-11-14 00:00:00 | 2017-11-15 00:00:00 | 2017-11-16 00:00:00 | 2017-11-17 00:00:00 | 2017-11-18 00:00:00 | 2017-11-19 00:00:00 | 2017-11-20 00:00:00 | 2017-11-21 00:00:00 | 2017-11-22 00:00:00 | 2017-11-23 00:00:00 | 2017-11-24 00:00:00 | 2017-11-25 00:00:00 | 2017-11-26 00:00:00 | 2017-11-27 00:00:00 | 2017-11-28 00:00:00 | 2017-11-29 00:00:00 | 2017-11-30 00:00:00
595 - NEMG MEDICARE REMITTANCE | MORRIS,[NAME] | 78 | 9 | 5 | 0 | 0 | 0 | 0
596 - NEMG MEDICAID REMITTANCE | MORRIS,[NAME] | 46 | 0 | 0 | 0 | 0 | 0 | 0
597 - NEMG BCBS REMITTANCE | MORRIS,[NAME] | 51 | 0 | 12 | 2 | 0 | 0 | 108
598 - NEMG COMMERCIAL REMITTANCE | MORRIS,[NAME] | 82 | 2 | 165 | 25 | 0 | 0 | 120
599 - NEMG NO RULES REMITTANCE | TAUSS,DONNA | 315 | 60 | 234 | 89 | 0 | 0 | 447
664 - NEMG MANAGED CARE REMITTANCE | MORRIS,[NAME] | 38 | 1441 | 0 | 0 | 0 | 0 | 287
665 - NEMG MEDICAID MANAGED CARE REMITTANCE | MORRIS,[NAME] | 3 | 0 | 0 | 0 | 0 | 0 | 0
666 - NEMG MEDICARE MANAGED CARE REMITTANCE | MORRIS,[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0
28270 - LMMG REMITTANCE WQ | ELLIS,TARA | 9 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL:
 |  |  |  | 23
 |  |  |  | 20
 |  |  |  | 22
 |  |  | 5054
Spreadsheet: 106792d1303981162-hide-rows-if-value-0-need-help-please-nails
Sheet: Sheet3

1 |  | 5 | A1 | 0.7 | 3.5 |  | 5 - (0.7) Type A1 Nail
 |  | 2 | C1 | 1.1 | 2.2 |  | 2 - (1.1) Type C1 Nail
3 |  | 2 | D1 | 1.3 | 2.6 |  | 2 - (1.3) Type D1 Nail
4 |  | 1 | E1 | 1.5 | 1.5 |  | 1 - (1.5) Type E1 Nail
5
Spreadsheet: 90410d1290126769-statistical-data-sheet-assistance-october-2010-1
Sheet: Mondial

Issue | July | August | September | October 2010.
PlbGas HWS | 14 | 21 | 30 | 26
Plb burst water pipe | 7 | 8 | 6 | 5
Plb serious flooding | 0 | 0 | 1 | 1
Plb sewer blockage | 9 | 9 | 9 | 30
Loss of all toilet facilities | 2 | 0 | 4 | 8
Plb general | 27 | 28 | 19 | 33
Gas Leak | 5 | 4 | 2 | 1
Solar/Heat pump HWS | 2 | 5 | 4 | 3
Electric HWS | 17 | 26 | 23 | 16
Ele. Complete power failure |  |  |  | 13
Wet lights etc |  |  |  | 1
Electrical other | 44 | 12 | 25 | 34
Air conditioner/Heating | 26 | 26 | 10 | 18
Fire or storm damage. Roof leaks | 2 | 3 | 21 | 28
Glazing | 5 | 0 | 0 | 0
Other | 37 | 62 | 23 | 51
Missing reports |  |  |  | 10
 | 197 | 204 | 177 | 278
Spreadsheet: 19b8ff3d-e86a-4126-9027-21ab01974b3c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2013
 |  | Data Extracted on: November 28, 2014 (8:32 pm)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
2003 | X | X | X | 229371
2004 | 229646 | 233241 | 235336 | 237875
2005 | 242085 | 244136 | 247183 | 247443
2006 | 250954 | 254990 | 258328 | 262731
2007 | 263776 | 266272 | 270025 | 272054
2008 | 276019 | 278206 | 280691 | 273572
2009 | 267266 | 267665 | 268736 | 271174
2010 | 273058 | 275612 | 279685 | 281383
2011 | 283078 | 290271 | 293177 | 293795
2012 | 297910 | 301286 | 303811 | 309614
2013 | 311650 | 315125 | 320087 | 326348
Spreadsheet: kimberly_watson__20552__imbalsumm0108
Sheet: CIG

 | Tumbleweed
 | 9198
Day | Measured | Scheduled
1 | 5789 | 7579
2 | 2411 | 7579
3 | 7806 | 7579
4 | 7637 | 7579
5 | 7209 | 7579
6 | 4529 | 7579
7 | 1886 | 7579
8 | 0 | 7579
9 | 2449 | 7579
10 | 7660 | 7579
11 | 3951 | 7579
12 | 5968 | 7579
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 326755
2001-08-12 00:00:00
CBS Volume
 |  |  | 6289
Spreadsheet: 185147d1349523885-count-number-of-days-book1-1
Sheet: Sheet1

[NAME] |  |  | 12
From | To | No of Days | Balance
2007-06-18 00:00:00
2007-06-30 00:00:00
2007-08-26 00:00:00 | 2007-08-28 00:00:00
2007-12-05 00:00:00
2008-03-31 00:00:00 | 2008-04-02 00:00:00
2008-04-13 00:00:00
2009-02-18 00:00:00
2009-09-29 00:00:00 | 2009-09-30 00:00:00
2010-02-14 00:00:00
2010-02-22 00:00:00
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 7c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Basis | 2028598 | 1004016 | 2032584 | 2564037 | 3492728 | 1720867 | 1241683 | 80978 | 14165491
Fixed-Float | 12078113 | 8231051 | 16165935 | 29476027 | 63176968 | 43595829 | 20089296 | 1973365 | 194786584
FRA | 32491115 | 12996438 | 12432970 | 3185169 | 158778 | 0 | 0 | 0 | 61264470
OIS | 18586401 | 6338873 | 9462634 | 5178746 | 2031437 | 422672 | 227833 | 16579 | 42265174
Swaption | 3679218 | 1816368 | 3349993 | 3747853 | 4318783 | 2165570 | 965666 | 14625 | 20058076
OTHER* | 1855488 | 929300 | 1407381 | 2148496 | 4721611 | 4014175 | 2234032 | 188914 | 17499400
TOTAL
*OTHER variable includes the following products: Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 214744d1361103809-excel-formula-from-looking-the-base-date-and-convert-into-desire-result-date-calculation
Sheet: Sheet1

 |  |  |  |  |  | 31.01.2013
 | Plnt | Vendor | Material | Material Description | Date | Qty | Amount | Category
 | HHHD | 100014 | 77200-KVH-9000 | SEAT COMP  DOUBLE | 02.01.2008 | 3 | 1091.03 | >4 Years
 | HHHD | 100014 | 77200-KWA-8300 | SEAT ASSY DOUBLE | 05.11.2012 | 6 | 2720.2 | <1 Year
 | HHHD | 100014 | 42601-AAC-H430C | WHEEL REAR DRUM (JIELI) | 21.01.2012 | 13 | 14320.31 | >1 Year <2 Year
 | HHHD | 100014 | 42601-AAE-H230C | WHEEL REAR DRUM (JIELI) | 21.01.2011 | 13 | 13381.87 | >2 Year <3 Year
 | HHHD | 100014 | 7720A-KCC-9000 | SEAT ASSY.DOUBLE COMP. | 15.01.2010 | 30 | 11223.3 | >3 Year <4 Year
 |  |  |  | Excel formula from looking the base date and convert into desire result
 |  |  |  | I have an excel file.I want to solve the category condition from an excel formula.In this file,G3 will be my base date and I want the excel formula in colum no.I i.e.Category.For this,look the base date i.e.[NAME] and compare to column F i.e.Date Column of each material code.
 |  |  |  | For more clarification,please refer the attach file
Spreadsheet: 770645d1646210934-vlookup-multiple-columns-vlookup-example-2
Sheet: TargetData

 | Stock Code |  |  |  |  |  |  |  | SOH |  |  | [NAME] | Use By Date |  | Track_No
 | 010019632 |  |  |  |  |  |  |  |  |  |  |  |  |  | A454
 | 010027412 |  |  |  |  |  |  |  |  |  |  |  |  |  | Z001974
 | 000185200
 | 014216603 |  |  |  |  |  |  |  |  |  |  |  |  |  | G3
 | 660012781
 | 995557119
 | 010015847 |  |  |  |  |  |  |  |  |  |  |  |  |  | X65318-S
 | 010015847 |  |  |  |  |  |  |  |  |  |  |  |  |  | C-D589
 | 014528800
 | 664589632
Spreadsheet: 88820d1288648360-pivotchart-broken-lines-pivotchartbrokenlines
Sheet: Sheet1

Name | Category | Rank | Rating | Amount
Item4 | B | 30 | 28 | 6000
Item5 | B | 20 | 80 | 8568 |  |  | Average of Amount | Column Labels
Item6 | B | 20 | 23 | 3886 |  |  | Row Labels | 20 | 25 | 30 | Grand Total
Item7 | B | 20 | 69 | 10004 |  |  | 19 |  | 5771 |  | 5771
Item9 | A | 25 | 19 | 5771 |  |  | 23 | 3886 |  | 4059 | 3972.5
Item10 | A | 20 | 29 | 5469 |  |  | 28 |  |  | 6000 | 6000
Item7 | B | 20 | 87 | 8976 |  |  | 29 | 5469 |  |  | 5469
Item4 | B | 20 | 36 | 3753 |  |  | 30 |  | 7085 |  | 7085
Item3 | B | 30 | 23 | 4059 |  |  | 33 |  |  | 9655 | 9655
Item11 | C | 25 | 60 | 5400 |  |  | 34 |  | 7169 |  | 7169
Item7 | B | 20 | 73 | 9272 |  |  | 36 | 3753 |  |  | 3753
Item12 | C | 30 | 37 | 7315 |  |  | 37 |  |  | 7315 | 7315
Item13 | C | 30 | 33 | 9655 |  |  | 38 | 4940 |  |  | 4940
Item14 | B | 20 | 38 | 5188 |  |  | 39 | 6950 |  |  | 6950
Item16 | E | 20 | 38 | 4692 |  |  | 40 |  | 3780 |  | 3780
Item17 | F | 20 | 42 | 6191 |  |  | 42 | 6191 |  |  | 6191
Item18 | G | 20 | 50 | 7350 |  |  | 50 | 6135 |  |  | 6135
Item19 | G | 25 | 34 | 7169 |  |  | 53 | 5875 |  |  | 5875
Item20 | G | 25 | 30 | 7085 |  |  | 60 |  | 5400 |  | 5400
Item21 | G | 20 | 80 | 6696 |  |  | 63 | 6846 |  |  | 6846
Item22 | B | 20 | 50 | 4920 |  |  | 69 | 10004 |  |  | 10004
Item23 | G | 25 | 40 | 3780 |  |  | 73 | 9272 |  |  | 9272
Item7 | B | 20 | 88 | 7595 |  |  | 80 | 7632 |  |  | 7632
Item12 | C | 20 | 39 | 6950 |  |  | 87 | 8976 |  |  | 8976
Item21 | G | 20 | 53 | 5875 |  |  | 88 | 7595 |  |  | 7595
Item24 | G | 20 | 63 | 6846 |  |  | Grand Total | 6601.823529411765 | 5841 | 6757.25 | 6479.423076923077
Spreadsheet: 886841d1736946800-formular-to-cashflow-rent-and-costs-sample-data
Sheet: Sheet1

PRE- LET CASHFLOW | Unit | Cost Type | Cost | Total Sqft | Construction Start Date | Construction End | Void Period(months) | Lease Start | Rent Free | Start Date | End Date | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00 | 2026-01-01 00:00:00 | 2026-02-01 00:00:00 | 2026-03-01 00:00:00 | 2026-04-01 00:00:00 | 2026-05-01 00:00:00 | 2026-06-01 00:00:00 | 2026-07-01 00:00:00 | 2026-08-01 00:00:00 | 2026-09-01 00:00:00
Project 1 | 1 | Rent (ERV) | 385440 | 32120 |  |  | 3 |  | 12 | 2025-04-01 00:00:00 | 2026-09-01 00:00:00 | 32120 | 32120 | 32120 | 32120 | 32120 | 32120 | 32120 | 32120 | 32120 | 32120 | 32120 | 32120 | 32120 | 32120 | 32120 | 32120 | 32120 | 32120
 |  | Void Costs |  |  |  |  |  |  |  |  | 2026-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1284.83 | -1284.83 | -1284.83
 |  | Legal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -11563
 |  | Lettings |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -57816
 |  |  |  |  |  |  | Hello. I would like to automatically cashflow the rent by altering the date range in the start date and end date on the atatched using a formular. I've added the data amanually so you can see. It would be D2 dividedby 12 and added into every cell between dates in K2 and L2. [NAME] would be the same for the void costs in D3. I would alos like a formular to put the lettings and legals costs in D4 and D5 automatically in the date showin in L5 and L6.Thank you