tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 140214d1328649267-where-type-formula-conversion
Sheet: Sheet1

Grid coordinate
51361 | N | 30051
 |  |  |  | DATA TO CONVERT |  | RESULTS OF CONVERSION
Latitude(N) |  |  |  | 51361 | 30051
Longitude(W) |  |  |  | 51379 | 30058
 |  |  |  | 51395 | 30059
 |  |  |  | 51397 | 30075
 |  |  |  | 51399 | 30095
 |  |  |  | 51411 | 30045
C10 | EW |  |  | 51418 | 30062
C11 | NS |  |  | 51421 | 30035
C12 | Thetn |  |  | 51421 | 30045
C13 | Thets |  |  | 51447 | 30045
C14 | T |  |  | 51461 | 30053
C15 | Trig(Start) |  |  | 51463 | 30038
C16 | A | 20925874 |  | 51473 | 30027
C17 | P1N | 0.7135449 |  | 51488 | 30013
C18 | P2N | 0.7321617 |  | 51499 | 29997
C19 | P1S | 0.6969644 |  | 51499 | 30003
C20 | P2S | 0.7149994 |  | 51519 | 30005
C21 | OLN | -1.3569863 |  | 51525 | 30007
C22 | OTN | 0.7010368 |  | 51537 | 30008
C23 | OLS | -1.3569863 |  | 51538 | 30002
C24 | OTS | 0.6864925 |  | 51543 | 30001
C25 | RAD | 0.0174532
C26 | PI2 | 1.5707963
C27 | PI4
C28 | E | 0.0822719
C29 | E02
C30 | E2
C31 | S02
C32 | T1N | 0.458989532824336
C33 | T2N | 0.447777410407066
C34 | T1S | 0.469053729471719
C35 | T2S | 0.458110228619884
C36 | T0N | 0.466574847608922
C37 | T0S | 0.475449203836693
C38 | RM1N | 0.75714495662715
C39 | RM2N | 0.744858420118119
C40 | RM1S | 0.767865734018107
C41 | RM2S | 0.75619447191664
C42 | RNN | 0.661536737455875
C43 | RNS | 0.64879020428472
C44 | NF | 1.91582109614839
C45 | SF | 1.934142928924
C46 | P0N | 24211285.51927
C47 | P0S | 24985065.3267671
 | PN
 | PN
 | T(n)
 | Alatold(n)
 | [NAME]
 | Alat(n)
 | Alatold(1)
 | Alat(1)
 | [NAME])
 | Alat(2)
 | Alatold(3)
 | Alat(3)
 | Alatold(4)
 | Alat(4)
 | Alatold(5)
 | Alat(5)
Spreadsheet: 819909d1677761932-count-range-with-dates-not-working-copy
Sheet: SUMMARY

 | SUMMARY
 | Any date range | From | "" "" | To | "" ""
 | Name | TOTAL ID COUNT | Date AET to do dropped | [NAME]
 | ACTON |  |  | 9
 | EALING |  |  | 17
 | FULHAM |  |  | 5
 | HARLESDEN |  |  | 14
 | HARROW |  |  | 10
 | HAYES |  |  | 4
 | HOUNSLOW |  |  | 17
 | KINGSTON |  |  | 5
 | SHEPHERDSBUSH |  |  | 3
 | TWICKENHAM |  |  | 3
 | UXBRIDGE |  |  | 5
 | WANDSWORTH |  |  | 2
 | WEMBLEY |  |  | 7
 | TOTAL |  |  | 101
Spreadsheet: 735427d1622985277-transpose-data-on-unique-values-in-multiple-columns-transpose-data-on-unique-values
Sheet: How i want it to look

Candidate No | Surname | Forename | Subject1 | Grade1 | Band1 | Subject2 | Grade2 | Band2 | Subject3 | Grade3 | Band3 | Subject4 | Grade4 | Band4 | Subject5 | Grade5 | Band5 | Subject6 | Grade6 | Band6 | Subject7 | Grade7 | Band7
55689 | Smith | Test | English | Higher | 5 | Maths | Higher | 3 | Science | National 5 | 6 | History | National 5 | 5 | PE | Higher | 4
564312 | Make | Data | RE | Higher | 4 | PE | National 4 | 3 | MFL | National 5 | 2
6665989 | More | Data | Science | National 5 | 1 | MFL | National 5 | 1 | [NAME] | Higher | 4 | English | Higher | 5
Spreadsheet: 9060b7ec-ce3d-4b4f-a1f1-5aeebb7d37fe
Sheet: Depreciation

[NAME]
List all equipment that your sponsorship owns or will purchase with other funds and is not directly expensing that is considered nonexpendable property with a useful
life of more than one year and an acquisition cost of $5,000 or more per unit.
Complete Description of Equipment or Item to Depreciate (Specify model #) | Purchase Date | Cost per Item | Quantity | Total Cost | Life Expectancy (Years) | Annual Amount to Depreciate | % Allocated to CACFP | Total Annual Cost to CACFP
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  | Total Annual DEPRECIATION
Spreadsheet: 745327d1629859362-formula-for-gathering-data-from-many-sheets-that-includes-new-sheets-as-theyre-added-succotash_sales
Sheet: sale#3

[NAME] #: | SSO10001 |  |  |  |  |  |  |  |  |  |  |  |  | Total Profit
Customer: | Goodman, [NAME]
ID: | SC1000001
Date: | 2021-01-01 00:00:00
ID | Artist | Title | Format | Identifiers / Notes | Cost | Value | J | V1 | V2 | V3 | V4 | Box | Cond. Notes | Cost | Sale Price | Profit
 | [NAME] | Highway 61 Revisited | 2x45rpm | Mofi / Stereo / OOP | 72.08133333333333 |  | M | M |  |  |  |  | Sealed | 25 | 100
 | [NAME] | Highway 61 Revisited | 2x45rpm | Mofi / Stereo / OOP | 72.08133333333333 |  | NM | M |  |  |  |  | Sealed / 2 x splits on top seams | 20 | 100
 | [NAME] | Highway 61 Revisited | 2x45rpm | Mofi / Stereo / OOP | 72.08133333333333 |  | M | M |  |  |  |  | Sealed | 70 | 100
 | [NAME] | Bringing It All Back Home | 2x45rpm | Mofi / Mono / OOP | 72.08133333333333 |  | M | M |  |  |  |  | Sealed | 10 | 100
 | [NAME] | Bringing It All Back Home | 2x45rpm | Mofi / Mono / OOP | 72.08133333333333 |  | M | M |  |  |  |  | Sealed | 40 | 100
 | [NAME], etc. | AFTERNOON IN PARIS | LP | [NAME] | 59.62533333333334 |  | M | M |  |  |  |  | Sealed | 20 | 100
 | Santana | Santana | 2x45rpm | [NAME] / OOP | 72.08133333333333 |  | M | M |  |  |  |  | Sealed | 30 | 100
 | [NAME] | [NAME] | LP | [NAME] | 29.67333333333333 |  | M | M |  |  |  |  | Sealed | 50 | 100
 | [NAME] | [NAME] | LP | [NAME] | 29.67333333333333 |  | M | M |  |  |  |  | Sealed | 20 | 100
Spreadsheet: 096fc32c-a3df-4399-b4b1-a24885d27277
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
C7FX | Test | C7FX | C7 Complement, Functional, Serum | C7 Complement, Functional, S | Turbidimetry | Plain, Red-Top Tube: Red |  |  | 1 | mL | Collection Container/Tube: Red top Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions:  1. Immediately after drawing the specimen, place the tube on wet ice. 2. Spin down and separate serum from clot. 3. Immediately freeze specimen. Additional Information: Fasting preferred. | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold reject Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	Serum gel tube | 36-60 U/mL | Monday through Saturday; [NAME] with a 3 p.m. cutoff | Same day/1 day | 3 days | 1 | 86161 |  |  |  |  | Rochester
C7FX | [NAME] | SRED | Serum Red |  |  |  | Frozen | 14 days
C7FX | Result | C7FX | C7 Complement, Functional, S | C7 Complement, Functional, S | Numeric |  |  |  |  | U/mL |  |  |  |  |  |  |  |  |  | 26996-9 | [NAME]:ACnc:Pt:Ser/Plas:Qn:
Spreadsheet: 03ae2e3b-958c-403e-b6e3-a81df3d023ca
Sheet: Sheet1

DeSoto Senior Activity Center | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Monday | Tuesday | Wednesday | Thursday | Friday
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
[NAME] | Independence Day Meal |  | Creole Beef | King Ranch Chicken Casserole
Green Peas | Hamburger Patty |  | Parslied Potatoes | Green Beans
Glazed Carrots | Lettuce and [NAME] |  | Stewed Tomatoes | [NAME]
Wheat Bread | Ranch Beans |  | Wheat Bread | Dinner Roll
Fresh Apple | Hamburger Bun |  | [NAME] with Fruit | Hot Diced Apples
Milk | Watermelon |  | Milk | Milk
Margarine | Milk |  | Margarine | Margarine
 | Mustard and Catsup |  |  | French Salad Dressing
Monday | Tuesday | Wednesday | Thursday | Friday
2012-07-09 00:00:00 | 2012-07-10 00:00:00 | 2012-07-11 00:00:00 | 2012-07-12 00:00:00 | 2012-07-13 00:00:00
Apple Glazed Turkey Ham | Country Fried Steak | Birthday Meal | Shaved [NAME]
[NAME] | Country Gravy | Fish Nuggets | Swiss Cheese
Garden Vegetables | Whipped Potatoes | Oven Roasted Potatoes | Lettuce and [NAME] | [NAME]
Multi Grain Bread | [NAME] | Cabbage | Three Bean Salad | 2% Milk
Fresh Orange | Wheat Bread | Dinner Roll | Hoagie Bun
Milk | Creamsicle Pudding | Birthday Cake with Frosting | Fruit Salad
Margarine | Milk | Ice Cream | Milk
 |  | Milk | Mustard
 |  | [NAME]
Monday | Tuesday | Wednesday | Thursday | Friday
2012-07-16 00:00:00 | 2012-07-17 00:00:00 | 2012-07-18 00:00:00 | 2012-07-19 00:00:00 | 2012-07-20 00:00:00
Grilled Pork Patty | [NAME] | Chili with Beans |  | Smoked Sausage
Brown Gravy | [NAME] | [NAME] |  | Ranch Beans
[NAME] | Broccoli | Peas and Carrots | [NAME] | Tater Tot Casserole
Spring Vegetables | Texas Bread | Corn Chips | 2% Milk | Hot Dog Bun
Wheat Bread | [NAME] | Fresh Banana |  | Butterscotch Pudding
Fresh Apple | Milk | Milk |  | Milk
Milk | Margarine |  |  | Mustard
Margarine
Monday | Tuesday | Wednesday | Thursday | Friday
2012-07-23 00:00:00 | 2012-07-24 00:00:00 | 2012-07-25 00:00:00 | 2012-07-26 00:00:00 | 2012-07-27 00:00:00
Breaded Chicken Tenders | [NAME] | Christmas in July | Grilled Pork Patty
[NAME] | Glazed Carrots | [NAME] with Gravy | Mushroom Gravy
Green Beans | Broccoli | Cornbread Dressing | [NAME] | [NAME]
Biscuit | Wheat Bread | Summer Vegetables | Okra and Tomatoes | 2% Milk
Fresh Plum | [NAME] with Fruit | Wheat Roll | Cornbread
Milk | Milk | [NAME] | Fresh Banana
Margarine | Margarine | White Frosting | Milk
 |  | Milk | Margarine
 |  | Margarine
Monday | Tuesday
2012-07-30 00:00:00 | 2012-07-31 00:00:00
Sliced [NAME] | [NAME]
Turkey Gravy | Herb Potato Salad
Country Corn | Ranch Beans
Diced Beets | Dinner Roll
Texas Bread | [NAME]
Fresh Apple | Milk
Milk | Margarine
Margarine
Activities and services at this Center are equally accessible to all persons who are age 50 and over regardless of race, color, national origin, religious affiliation, handicap or impairment.  A donation of $1.00 is suggested for meal participants 60+ and their spouse otherwise the cost is $6.00 per meal.  Meals must be ordered by noon two days in advance by calling [PHONE].
Spreadsheet: 870738d1717183167-how-to-copy-paste-from-word-to-excel-forms_estimate-cover-page_shanes-excel-forum-version_2024-05-31
Sheet: Basic Invoice

 | SOLD TO:
 |  |  |  |  |  |  | ESTIMATE NUMBER
 |  |  |  |  |  |  | DATE
 |  |  |  |  |  |  | TERMS
 | SHIPPED TO:
 |  |  |  |  |  |  | SALES REP
 |  |  |  |  |  |  | CELL
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | WEBSITE:
 | QUANTITY | DESCRIPTION |  |  |  |  |  | AMOUNT
 |  | 3'-0" x 8'-0" Neuma Fiberglass Fullview 3/4-view Impact Single Door w/ Single Bottom Raised Panel, [NAME] Finish on both sides, White Wood Grain Finish on both sides, LoE #366 Insulated Impact Glass, LoE #340 Insulated Impact TURTLE GLASS, 1-lite (No SDL), 7/8" SDL, 4-lite (2w2h), Uneven 7/8" SDL, 4-lite (2w2h), Note: [NAME] is centered at 20" down from the top of the door panel (the appearance is a CROSS), 6 9/16" Composite [NAME], Omit Brickmould, [NAME], Sill Cover, HANDING: (RHOS) Right Hand Outswing (DFH-L), (LHOS) Left Hand Outswing (DFH-R), (RHIS) Right Hand Inswing (DFP-R), (LHIS) Left Hand Inswing (DFP-L), (FIXED) Inswing Plane (DFP-S), (FIXED) Outswing Plane (DFH-S), Multipoint Lock System, Active Royal Series Leverset in Satin Nickel HPVD Finish, Stainless Steel Hinges, [NAME], DP +50 / -50, FL #14752, RO – 37 3/8” x 96”...
 |  |  |  |  |  |  |  |  |  |  |  |  | GROSS PROFIT |  | GROSS PROFIT %
 |  |  |  |  |  |  | SUBTOTAL |  |  |  | TOTAL COST
 |  |  |  |  |  |  | STATE TAX |  |  | 0.06
 |  |  |  |  |  |  | COUNTY TAX | 50
 |  |  |  |  |  |  | GRAND TOTAL
 |  |  |  |  |  |  | 0.5
Spreadsheet: 767452d1644482721-time-difference-error-when-time-goes-1day-time-difference-value-v2
Sheet: Sheet1

 | Date 1 | 2022-02-25 00:00:00 | 14:00:00
Time Diff | Date 2 | 2022-02-26 00:00:00 | 11:00:00
15 | Rate | 120 | 331 |  | CURRENT
25 |  |  |  |  | A3= -Time difference
50 |  |  |  |  | C1:D2 are set dates
330 |  |  |  |  | A4:A7 are lot numbers(day switches at 331(D3)
331
 | Date 1 | 2022-02-25 00:00:00 | 14:00:00 |  | DESIRED
Time Diff | Date 2 | 2022-02-26 00:00:00 | 11:00:00 |  | Matches time difference by substracting
 | Rate | 120 | 331 |  | one day (currently "#[NAME]!")
25 | Thu 24 : 23:00-23:30
50 | Thu 24 : 23:15-23:45
330 | Fri 25 : 01:45-02:15
331 | Sat 26 : 20:00-20:30
Spreadsheet: a5ec482d-9d5f-43c6-a626-7138bd139bd2
Sheet: 1Plan-1Opt

 | Insured HRA Quote for:
 |  |  |  | 2500dd/10K
 | Census | Status | Medical |  | Total
 |  | Employee
 |  | 2 Person
 |  | Emp/Child
 |  | Family
 |  |  |  | 2500dd/10K
 | Census | Status | Medical |  | Total
 |  | Employee
 |  | 2 Person
 |  | Emp/Child
 |  | Family
 |  |  |  | 2500dd/10K
 | Census | Status | Medical | Insured HRA | Total
 |  | Employee
 |  | 2 Person
 |  | Emp/Child
 |  | Family
 |  |  |  | 2500dd/10K
 | Census | Status | Medical | Insured HRA | Total
 |  | Employee
 |  | 2 Person
 |  | Emp/Child
 |  | Family
 | Proposed Plan 1: Annual Savings Versus Renewal Plan
 | Proposed Plan 2: Annual Savings Versus Renewal Plan
Spreadsheet: 827826d1683043296-transpose-data-from-single-column-to-multiple-columns-sample-gk-
Sheet: Sheet1

Orginal Data |  | Transposed Data
Membership No | Business Details
M-1 | [NAME]
M-1 | Ilyas Welfare Trust,
M-1 | 051-895632
M-2 | [NAME]
M-2 | memon coporations
M-2 | 0333-52642563
M-2 | [PHONE]
M-3 | Adeel Shahzad
M-3 | AH [NAME]
M-3 | [PHONE]
M-3 | [NAME]
M-3 | [NAME]
M-3 | [PHONE]
M-4 | [NAME]
M-4 | Heaven Growers (Pvt)
M-4 | Mr.[NAME]
M-4 | [PHONE]
M-4 | [PHONE]
Spreadsheet: 231807d1367235502-need-help-with-selectable-auto-populate-918797-need-help-with-selectable-auto-populate-test-run-online
Sheet: sheet2

Nom:test quotation |  |  |  | Date:
Adresse: Ottawa, Ontario |  |  |  | Tél.:
Projet: Pilot |  |  |  | Fax:
Adresse: |  |  |  | Att:
Nous avons le plaisir de vous soumettre nos prix comme suit:
Description |  |  |  | Qty | Sku | Price | Total
Item Number: | Description
testrun |  |  |  | 2
8500C |  |  |  | 3
[NAME]: 45,00$/livraison dans la région immédiate d'Ottawa/Outaouais
Systeme de clée non inclus
Installation non inclue
3 a 4 semaines pour quincaillerie
2 a 3 semaines pour cadres et portes
 |  |  |  | SOUS-TOTAL
 |  |  |  | TAXES NON INCLUSE
Spreadsheet: 845005d1696582030-how-to-fetch-data-from-other-sheets-in-one-sheet-based-on-quarters-attendance-2-1-1-
Sheet: Dashboard

[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q1S | Q2S | Q3S | Q4S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January | April | July | October
Quarter | Q1 |  |  |  |  |  |  | Q2 |  |  |  |  |  |  | Q3 |  |  |  |  |  |  | Q4 |  |  |  |  |  |  |  |  | February | May | August | November
Associate Name | Present | # of ULs | # of UUs | # of HL | # of PLs | Total Leaves | Attendance% | Present | # of ULs | # of UUs | # of HL | # of PLs | Total Leaves | Attendance% | Present | # of ULs | # of UUs | # of HL | # of PLs | Total Leaves | Attendance% | Present | # of ULs | # of UUs | # of HL | # of PLs | Total Leaves | Attendance% |  |  | March | June | September | December
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
Spreadsheet: 764313d1642687792-variable-sheet-name-in-vlookup-test-3-etaf
Sheet: ABSOLUTE

 |  |  |  |  | DATE | PO | DATE | PO | DATE | PO | DATE | PO
 |  |  |  |  | 2021-02-23 00:00:00 | ERIC-23022021-01 | 2021-03-15 00:00:00 | ERIC-15032021-03 | 2021-05-01 00:00:00 | ERIC-01052021-02 | 2021-09-22 00:00:00 | ERIC-22092021-06
 | CODE | [NAME] | PART # | LAST PRICE | QTY | PRICE | QTY | PRICE | QTY | PRICE | QTY | PRICE
 | AAA-0001 | TUBE ABS 2'' X 12' | AB-00001 |  | 250 | 100 |  |  | 300 | 112.75
 | AAA-0002 | TUBE ABS 3'' X 12' | AB-00002 |  |  |  | 125 | 112.35
 | AAA-0003 | TUBE ABS 4'' X 12' | AB-00003 |  | 175 | 104 |  |  |  |  | 225 | 115.64
 | AAA-0004 | TUBE ABS 5'' X 12' | AB-00004 |  |  |  |  |  | 75 | 116.35 | 75 | 116.55
 | AAA-0005 | TUBE ABS 6'' X 12' | AB-00005 |  | 10 | 112 | 150 | 116.75
 | AAA-0006 | TUBE ABS 7'' X 12' | AB-00006 |  |  |  |  |  |  |  | 50 | 114
Spreadsheet: 727752d1618070680-formula-to-work-out-postage-costs-etsy-calculator-
Sheet: Costs

number of times relisted | date | item name | make costs | sale price | Shipping destination | shipping type | actual shipping costs | listed shipping cost | packaging type | packaging cost | transaction fee 5% | etsy payments fee 4% +£0.20 | listing fee | total fees | profit | offsite ads fee | Profit with offsite ads
1 |  | workshop | 15 | 60 | UK | Medium parcel 2nd class 5kg tracked |  | 10 |  |  |  |  | 0.2
1 |  | print | 5 | 50 | EU | Large Letter 2nd class 250g tracked |  | 11.1 |  |  |  |  | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.2
Spreadsheet: sara_shackleton__36592__TXU Default Log 2-24-02
Sheet: Termination

TXU
Terminated | TXU Entity | Enron Entity | Amount Owed to Enron Entity or [Owed by Enron Entitiy] | Termination Date | Contract Type/Date/Enron Contract No. | Comments
Y | TXU Electric Company | EPMI |  | 2001-12-13 00:00:00 | Phys. [NAME]. - EEI  (08/08/01)(96070400) | All transactions were part of TXU Capacity Auction; EPMI disputes entering into 3 trades.
No live deals as of 1/17/02 | TXU Electric Company | EPMI |  | 2001-12-31 00:00:00 | Phys. [NAME]. - TXU Form Bilateral (5/22/96)(96004389) | The three deals existing under this agreement as of 12/2/01 expired on their own terms on 12/31/01.
Y | TXU Energy Trading Company | EPMI |  | 2001-11-30 00:00:00 | Phys. [NAME]. - EPMI Form(4/1/98)(96015003) | Automatic termination upon bankruptcy.
N | TXU Energy Trading Company | ENA |  | N/A | Fin. - ISDA (10/19/95)(96038419) | No automatic termination upon bankruptcy.
N | TXU Energy Trading Canada Ltd. | ENA |  | N/A | Fin. - 2 Enron Long Form Confirms (9/22/00)(Q07901.1 and Q07911.1) | These deals go through 3/31/02.  No automatic termination upon bankruptcy.
Y | TXU Energy Trading Company | EES |  | 2001-11-30 00:00:00 | Phys. Gas - Enfolio (08/01/98)(???) | Automatic termination upon bankruptcy.
Y | TXU Energy Trading Company | ENA |  | 2001-11-30 00:00:00 | Phys. Gas - Enfolio (5/1/98)(96044805) | Automatic termination upon bankruptcy.
Y | TXU Energy Trading Canada Ltd. | ENA |  | 2001-11-30 00:00:00 | Phys. Gas (8/1/99)(96044817) | Automatic termination upon bankruptcy.
Y | TXU Fuel Company | Enron Power Services, Inc. |  | 2002-01-01 00:00:00 | Gas Sales contract 1/1/93 | Terminated on 11/01/2001.
Spreadsheet: 806211d1669163816-rolling-average-excluding-blank-cells-but-including-zeros-sample
Sheet: Sheet1

ID | VALUE | val_roll_ave | REQUIRED
1 | 123.2739130434782 |  | 123.2739130434782
1 | 8.18 |  | 65.72695652173913
1 | 41.81666666666666 |  | 57.75685990338164
1 |  |  |  | <--- should ignore the blank cell B5
1 | 0 |  |  | <--- should include the 0 in cell [NAME]
1 | 7.15
1 | 90.28749999999998
1
1 | 12.65
2 | 121.5333333333333
2 | 39.25
2 | 53.47692307692309
2 | 15.4
2 | 0
2 | 62.0611111111111
2 | 35.8
2 | 70.07499999999999
2 | 49.56666666666666
2 | 126.6560606060606
2 | 23.06666666666667
2 | 126.6560606060606
2 | 23.06666666666667
2 | 177.1351724137931
2 | 8.4
2 | 12
2 |  |  |  | <--- should ignore the blank cell B27
2 | 110
2 | 0 |  |  | <--- should include the 0 in cell B29
2
Spreadsheet: 720958d1614393668-method-to-estimate-missing-data-items-data-fill-example
Sheet: Sheet2

Date | Value | New value
2019-02-12 00:00:00
 | 4994
 | 6169
 | 3600
 | 4200
 | 4800
 | 5280
 | 6995
 | 5040
 | 4813
 | 5040
 | 4560
 | 4800
 | 5280
 | 5520
 | 5640
Spreadsheet: 182518d1348511913-need-help-only-totaling-specific-headings-dsschaser-copy-question
Sheet: Report

Customer # | Customer Name | Pre year Sales | [NAME] | % Diff | Sales to Date | Year End Sales Est. | % Diff |  | Quarters | 4
 |  |  |  |  |  |  |  |  | Quarter | 1
12345 | ABC | 5000 | 6000 |  | 800 |  |  |  | Multiplier
17842 | TYZ | 15000 | 13000 |  | 3500
17495 | ETA | 18000 | 22000 |  | 4000
18859 | YYZ | 2000 | 4000 |  | 1200
From Data Sheet =
Original Report Equation =
Spreadsheet: benjamin_rogers__1232__Combine-Cycle model
Sheet: Summary

 | Florida Project Return Analysis
 |  | Capacity Price | Return | NPV (000's)
 | Plant starting June 2001 (SC) | 5.07 | -0.0795 | -61694
 | Desk's Current Capacity Price (Bid) | 5.4 | -0.0449 | -52969
 | 12% Return Target | 7.84 | 0.12 | 5075
 | 12% Return Target (NPV Breakeven) | 7.58 | 0.1067 | 0
 | 30 Year SL with 10% Residual | 7.26 | 0.12 | 5182
 | Notes:
 | Pricing Starts Summer 2001 with 5-year term
 | Total Project Cost (000's):
 | Total Project Installed cost: (kW)
 | Debt/Equity: 70%/30%
 | 8% Interest Rate with 20 Yr. Debt & Amort.
Spreadsheet: 742649d1627934441-cell-contents-is-also-found-in-a-range-of-cells-then-is-text-in-adjacent-columns-equal-v1-revised
Sheet: Sheet1

Last report | status | Bucket Name | Version | definition
2021-07-19 | crazy | cm-dodger | v1 | ["0025CA0A0000052E","0025CA0A00000518"]
2021-07-19 | False | giant | v1 | ["0025CA0A000011E1"]
2021-07-19 | False | giant | v1 | ["0025CA0A00001C81","0025CA0A00001C7F"]
2021-05-24 | False | giant | v1 | ["0025CA0A00002698"]
2021-04-13 | True | giant | v1 | ["0025CA0A000042A7"]
2021-07-19 | True | cm-dodger | v1 | ["0025CA0A000071DD"]
2021-07-19 | True | cub | v1 | ["0025CA0A00007B6E","0025CA0A00007B68","0025CA0A00007A6A","0025CA0A00007472","0025CA0A00007434","0025CA0A0000739F","0025CA0A0000739C","0025CA0A00007368","0025CA0A00007362"]
2021-07-19 | True | cub | v1 | ["0025CA0A00007BD3","0025CA0A00007B6D","0025CA0A00007B28","0025CA0A00007AE5","0025CA0A000079D8","0025CA0A00007687","0025CA0A00007668","0025CA0A0000744B","0025CA0A000073A6","0025CA0A00007361","0025CA0A0000735F","0025CA0A0000735D","0025CA0A00007358","0025CA0A00007357","0025CA0A0000734E"]
Spreadsheet: 58371d1258634681-vlookup-multiple-columns-test-1-
Sheet: Sheet2

Company 1 | Company 2 | Company 3 | Company 4 | Company 5 | Company 6 | Company 7
a | x | e | x | f | x | h
d | a | x | d | x | x | x
x | x | f | g | x | g | x
Spreadsheet: 124841d1318645148-excel-2007-vlookup-n-a-error-master
Sheet: Sheet2

REP | Link | File Name | Result | Comments
Rep1
Rep1
Rep1
Rep1
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 875741d1722350429-cagr-xirr-for-random-amount-of-investments-made-on-random-dates-excel-forum-q
Sheet: Sheet1

ABC | Date | ABC | ABC | ABC | ABC | ABC | Invested Amt | ABC | ABC | ABC | ABC | Latest Value | ABC | ABC | ABC | ABC | ABC | ABC | CAGR or XIRR
ABC | 2017-03-25 00:00:00 | ABC | ABC | ABC | ABC | ABC | 50000 | ABC | ABC | ABC | ABC | 148200 | ABC | ABC | ABC | ABC | ABC | ABC | x
ABC | 2024-05-24 00:00:00 | ABC | ABC | ABC | ABC | ABC | 5000 | ABC | ABC | ABC | ABC | 5229.754266 | ABC | ABC | ABC | ABC | ABC | ABC | x
ABC | 2024-06-03 00:00:00 | ABC | ABC | ABC | ABC | ABC | 5000 | ABC | ABC | ABC | ABC | 5365.346917500001 | ABC | ABC | ABC | ABC | ABC | ABC | x
ABC | 2024-06-04 00:00:00 | ABC | ABC | ABC | ABC | ABC | 5000 | ABC | ABC | ABC | ABC | 5880.7046232 | ABC | ABC | ABC | ABC | ABC | ABC | x
ABC | 2024-06-14 00:00:00 | ABC | ABC | ABC | ABC | ABC | 5000 | ABC | ABC | ABC | ABC | 5248.4714964 | ABC | ABC | ABC | ABC | ABC | ABC | x
ABC | 2024-07-19 00:00:00 | ABC | ABC | ABC | ABC | ABC | 10000 | ABC | ABC | ABC | ABC | 10470.3636114 | ABC | ABC | ABC | ABC | ABC | ABC | x
ABC | 2024-07-23 00:00:00 | ABC | ABC | ABC | ABC | ABC | 10000 | ABC | ABC | ABC | ABC | 10157.4784514 | ABC | ABC | ABC | ABC | ABC | ABC | x
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ???