tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 136028d1326378679-sumproduct-array-formula-help-2012-vacation-trackerwip-revamp
Sheet: 2009

 | 2 0 0 9
 | JANUARY |  |  |  |  |  |  |  | FEBRUARY
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  |  | 1 | 2 | 3 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | 22 | 23 | 24 | 25 | 26 | 27 | 28
 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | [NAME] |  |  |  |  |  |  |  | APRIL
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  |  |  |  | 1 | 2 | 3 | 4
 | 8 | 9 | 10 | 11 | 12 | 13 | 14 |  | 5 | 6 | 7 | 8 | 9 | 10 | 11
 | 15 | 16 | 17 | 18 | 19 | 20 | 21 |  | 12 | 13 | 14 | 15 | 16 | 17 | 18
 | 22 | 23 | 24 | 25 | 26 | 27 | 28 |  | 19 | 20 | 21 | 22 | 23 | 24 | 25
 | 29 | 30 | 31 |  |  |  |  |  | 26 | 27 | 28 | 29 | 30
 | MAY |  |  |  |  |  |  |  | [NAME]
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  |  |  | 1 | 2 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 17 | 18 | 19 | 20 | 21 | 22 | 23 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  | 28 | 29 | 30
 | 31
 | JULY |  |  |  |  |  |  |  | AUGUST
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29
 |  |  |  |  |  |  |  |  | 30 | 31
 | SEPTEMBER |  |  |  |  |  |  |  | OCTOBER
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  | 1 | 2 | 3
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 11 | 12 | 13 | 14 | 15 | 16 | 17
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 18 | 19 | 20 | 21 | 22 | 23 | 24
 | 27 | 28 | 29 | 30 |  |  |  |  | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | NOVEMBER |  |  |  |  |  |  |  | DECEMBER
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  |  |  | 1 | 2 | 3 | 4 | 5
 | 8 | 9 | 10 | 11 | 12 | 13 | 14 |  | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | 15 | 16 | 17 | 18 | 19 | 20 | 21 |  | 13 | 14 | 15 | 16 | 17 | 18 | 19
 | 22 | 23 | 24 | 25 | 26 | 27 | 28 |  | 20 | 21 | 22 | 23 | 24 | 25 | 26
 | 29 | 30 |  |  |  |  |  |  | 27 | 28 | 29 | 30 | 31
Spreadsheet: 746472d1630739761-find-and-return-all-a2-values-from-each-sheet-into-list-excel-workbook-sample-090221-ans
Sheet: Summary Page

Part number | Description | Color | Sheet
Spreadsheet: 50312d1249675333-some-help-needed-with-if-and-formula-please-excel-forum-if-and-or
Sheet: Sheet1

machineid | UserType | SessionType | TotalSessionTime (mins) | 2009/06
Beavers | Adult | Booking | 104 | 104
Beavers | Adult | Drop-In | 4644 | 4644
Beavers | Child | Drop-In | 999 | 999
Beavers | [NAME] (Adult) | Drop-In | 439 | 439
Beavers | Guest (Child) | Drop-In | 162 | 162
Bedfont | Adult | Booking | 168 | 168
Bedfont | Adult | Drop-In | 13754 | 13754
Bedfont | Child | Booking | 51 | 51
Bedfont | Child | Drop-In | 2182 | 2182
Bedfont | [NAME] (Adult) | Drop-In | 544 | 544
Beavers | Beavers | Beavers | Beavers
[NAME] | [NAME] | Child Booking | [NAME]-In
104 | 0 | 0 | 0
0 | 4644 | 0 | 0
0 | 0 | 0 | 999
0 | 0 | 0 | 0
0 | 0 | 0 | 0
0 | 0 | 0 | 0
0 | 0 | 0 | 0
0 | 0 | 0 | 0
0 | 0 | 0 | 0
104 | 0 | 0 | 0
0 | 4644 | 0 | 0
0 | 0 | 0 | 999
0 | 439 | 0 | 0
0 | 0 | 0 | 162
0 | 0 | 0 | 0
0 | 0 | 0 | 0
0 | 0 | 0 | 0
Some help needed with IF(AND... [NAME] please - Excel Help Forum
Spreadsheet: 161342d1339502715-index-match-jump-to-next-column-if-value-already-used-arrayindex
Sheet: Sheet1

Ranking List | Result
128
128
128
30
30
30
22
22
22
22
Data 1 | Data 2
128 | [NAME]
30 | [NAME]
22 | [NAME]
30 | Roland
128 | Klaus
30 | Fritz
128 | Sepp
22 | Pascal
22 | [NAME]
22 | Marina
Spreadsheet: 791723d1660565341-check-for-results-in-another-column-question-tms
Sheet: Tabelle1

Person ID | Option | TMS | [NAME]
1000 | OPTIONA
1000 | OPTIONB
1001 | OPTIONA
1001 | OPTIONB
1002 | OPTIONA
1002 | OPTIONB
1003 | OPTIONA
1003 | OPTIONA
1003 | OPTIONB
1003 | OPTIONB
1004 | OPTIONA
1004 | OPTIONB
1005 | OPTIONA
1005 | OPTIONB
1006 | OPTIONA
1006 | OPTIONB
1007 | OPTIONA
1007 | OPTIONB
1007 | OPTIONA
1008 | OPTIONA
1008 | OPTIONB
1009
1009 | OPTIONB
Spreadsheet: 127476d1320360765-excel-2007-copying-totals-of-values-from-one-sheet-to-another-braexample
Sheet: Ball Make Up - Brands

 | Padded | UnderWired | Training | Removable Straps | Strapless | Bras Total
Always & Forever | 2 | 2 |  |  |  | 2
Amour | 1 | 1 |  |  |  | 1
[NAME] | 5 | 6 |  |  |  | 7
Autumn Leaf |  | 1 |  |  |  | 1
Avon | 10 | 10 |  | 1 |  | 10
Ballet | 2 | 2 |  | 1 |  | 2
Beautiful Size |  | 1 |  |  |  | 1
BeeDees |  | 1 |  |  |  | 1
Best Bra Ever |  |  |  |  |  | 1
BHS | 1 | 3 | 1 |  | 1 | 3
BM |  |  |  |  |  | 1
BM | 1 | 1 |  |  |  | 1
Totals
Padded [NAME]
Non Padded Bras
UnderWired Bras
Non UnderWired Bras
Bras With Fixed Straps
Bras With Removable Straps
Bras With No Straps
Spreadsheet: 722050d1615018679-vlookup-formula-to-return-pivot-count-amount-test-1
Sheet: Data

Type | name Ip | ip | Site | name
Mobil2 |  |  | [NAME] | Clayville
44000 | 1 | 1 | dean | Aeroton
44001 | 2 | 2 | [NAME] | Aeroton
44002 | 3 | 3 | [NAME] | Aeroton
44003 | 4 | 4 | dean | Aeroton
44004 | 5 | 5 | [NAME] | Aeroton
44005 | 6 | 6 | [NAME] | Aeroton
44006 | 7 | 7 | dean | Aeroton
44007 | 8 | 8 | [NAME] | Aeroton
44008 | 9 | 9 | [NAME] | Aeroton
44009 | 10 | 10 | dean | Aeroton
44010 | 11 | 11 | [NAME] | Aeroton
44011 | 12 | 12 | [NAME] | Aeroton
44012 | 13 | 13 | dean | Aeroton
44013 | 14 | 14 | [NAME] | Aeroton
44014 | 15 | 15 | [NAME] | Aeroton
44015 | 16 | 16 | dean | Aeroton
44016 | 17 | 17 | [NAME] | Aeroton
44017 | 18 | 18 | [NAME] | Aeroton
44018 | 19 | 19 | dean | Aeroton
44019 | 20 | 20 | [NAME] | Aeroton
44020 | 21 | 21 | [NAME] | Aeroton
44025 | 22 | 22 | dean | Aeroton
44026 | 23 | 23 | [NAME] | Aeroton
44027 | 24 | 24 | [NAME] | Aeroton
44028 | 25 | 25 | dean | Aeroton
44029 | 26 | 26 | [NAME] | Aeroton
44030 | 27 | 27 | [NAME] | Aeroton
44031 | 28 | 28 | dean | Aeroton
44032 | 29 | 29 | [NAME] | Aeroton
44033 | 30 | 30 | [NAME] | Aeroton
44034 | 31 | 31 | dean | Aeroton
44037 | 32 | 32 | [NAME] | Aeroton
44038 | 33 | 33 | [NAME] | Aeroton
44040 | 34 | 34 | dean | Aeroton
44041 | 35 | 35 | [NAME] | Aeroton
Spreadsheet: 815951d1675279050-allocating-the-most-repeated-text-and-sorting-it-in-a-specific-cell-example
Sheet: Tabelle1

What | Missed points |  |  |  |  |  | Top 3 repeated text for Check in | Top 3 Check repeated text for Out | Top 3 repeated text for Rooming
Check In | a | b | c | d |  |  | d | be | ae
Check In | b | c | d | f |  |  | c | bb | ad
Rooming | ab | ac | ad | ae |  |  | b | bf | ac
Check Out | ba | bc | bb | be
Rooming | ac | ad | ae | af
Check Out | bc | bb | be | bf
Check Out | bb | be | bf | bg
Check In | c | d | f | g
Rooming | ad | ae | af | ag
Rooming | ae | af | ag | ah
Spreadsheet: 724698d1616325482-exclude-rows-from-printing-test
Sheet: Φύλλο2

COOK | "+/-" | INGREDIENTS
- | - | -
RARE | WITHOUT | ONION
MEDIUM | LITTLE | TOMATO
MEDIUM WELL | SPICY | [NAME]
WELL DONE | EXTRA | SALT
 | 1/2 | PEPPER
 |  | MUSTARD
Spreadsheet: 485247d1476796937-conditional-formatting-help-please-available-cross-comparison-sheet
Sheet: Sheet2

 |  |  |  | takes the amount from total 2016 or 2017 or 2018 and put it in column "D"
 |  |  |  | puts percentage that totals the whole amount of 100%
 |  |  |  | any amount chosen
 | need "columns B to D" to be captured from "Sheet 1"
 | Project | Owner | Funds available | Amount | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | 2016 | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | 2017-07-01 00:00:00 | 2017-08-01 00:00:00 | 2017-09-01 00:00:00 | 2017-10-01 00:00:00 | 2017-11-01 00:00:00 | 2017-12-01 00:00:00 | 2017
 | Location1 | Apple | -10000 |  | 50000
 | Location1 | Apple | 20000 |  |  |  | 90000
 | Location1 | [NAME] | 600000 |  |  |  | 50000
 | Location3 | Orange | 4000 |  |  |  | 4000
 | Location3 | Kiwi |  |  |  |  |  |  | 20000
 | [NAME] | [NAME] |  |  |  |  |  |  |  |  | 20000
 | Location8 | [NAME] |  |  |  |  |  |  |  |  | 1000
 | Location9 | Coco |  |  |  |  |  |  |  |  |  |  |  |  |  | 700000
 | Location10 | Vinalla |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9000
 | Location12 | Carmel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100000
 | Location11 | Brownie |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80000
 | Location11 | Hot Cakes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7676
 | Location2 | Brownie |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90000
 | Location2 | Brownie |  |  |  | 3000
 | Location2 | Brownie |  |  |  |  |  | 84500
 | Location2 | Brownie |  |  |  |  |  | 43234
 | Location13 | Blueberry |  |  |  |  |  |  |  | 3000
 | Location13 | Blueberry |  |  |  |  |  |  |  | 23434
 | Location13 | Blueberry |  |  |  |  |  |  |  |  |  | 9000
 | Location13 | Blueberry |  |  |  |  |  |  | 40000
 | Location13 | Pie |  |  |  |  |  |  |  |  |  |  |  |  | 60000
 | Location13 | Pie |  |  |  |  |  |  |  |  |  |  |  |  | 60000
 | Location4 | Cinnamon |  |  |  |  |  |  |  |  |  |  |  |  | 60000
 | Location4 | Cinnamon |  |  |  |  |  |  |  |  |  |  |  |  | 5700
 | Location4 | Pie |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50000
 | Location4 | Pie |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40000
 | Location4 | Blueberry |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500000
Spreadsheet: 684419d1593355668-extract-data-with-power-query-and-groupby-tool-pq-excelforumquestion-1-aligw
Sheet: Foglio1

Company | Product |  | Gruppo | Prodotti |  |  |  | Company | Product.1 | Product.2 | Product.3
Apple | F |  |  |  | B | A |  | Amazon | A | B | A
Dell | D |  | Apple |  | F |  |  | Apple | F | F
Amazon | A |  | Dell |  |  |  |  | Dell | D
Microsoft | C |  | Google |  | F |  |  | Google | F | F
Apple | F |  | Microsoft |  | A | C |  | Microsoft | C | A | C
Google | F
Amazon | B
Google | F
Microsoft | A
Amazon | A
Microsoft | C
Spreadsheet: d2390013-b197-4836-af38-fac6f1dfc42d
Sheet: 1. Instructions

 | How to create your Digital Metrics Dashboard
 | Personalise your dashboard
❶ | Add your organisation's logo
❷ | Use your brand colours in the graphs
❸ | Change the font to your organisation's
 | Steps to update the dashboard
❶ | In the sheet "Dashboard" change the month in cell N3, the format should be DD/MM/YYYY (e.g. for July 2013: 01/07/2013)
❷ | In the sheet "Data" add the month in the next empty cell in row A, you can drag the value from the cell on the left.  The format should be DD/MM/YYYY.
❸ | Fill in the cells that are in yellow with your website, social media and apps data for that month. Cells in grey contain formulas to calculate the variation compared to previous periods, so you do not need to modify these cells. As you enter the data, the dashboard will be updated automatically.
❹ | Manually add information about the content visited on the website (eg. most visited pages, most read blog posts, top landing pages) in cells [NAME].
❺ | Add a summary of the results of the digital activity for that month at the top of the dashboard, in the "Highlights" (cells B6-P13)
❻ | Start reporting! You can save the dashboard as a PDF or as a web page
 | Template information
 | Tate Digital Metrics Dashboard v1.0
 | Please note this template uses example data and does not reflect [NAME]'s digital data.
 | This dashboard has been built using Excel 2010. It works in previous versions although some formatting is not supported. If you see any formula errors or want to send your feedback for future improvements please contact: [EMAIL]
 | This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 [NAME].
Spreadsheet: 76421d1276925422-consolidate-data-experiment
Sheet: Data 1

ID | Name | House | Car | Phone | Camera | Dog | Cat
A | Anna | 1RM | toyota | Nokia | Canon | golden retriever | male
B | [NAME] | 3RM | hyundai | Nokia | Panasonic | german shepard | female
C | Dimitri | 4RM | suzuki | SE | Nikon | [NAME] | female
D | [NAME] | 5RM | mercedes | Samsung | Fuji | poodle | male
E | [NAME] | 1RM | rolls royce | iPhone | Konica | labrador | male
F | Kingston | 5RM | proton | HTC | Olympus | maltese | female
G | Lana | 3RM | mitsubishi | Samsung | Canon | silky terrier | male
Spreadsheet: 845613d1697047475-paste-vertically-to-excel-cells-of-horizontal-numbers-copied-from-webpage-horizontal-to-vertical-paste-1-ans
Sheet: Sheet1

211001 , 211101 , 211201 , 211301 , 211503 , 211601 , 211701 , 211801 , 213801 , 214501
211901 , 212001 , 212101 , 212201 , 214001 |  | 211101
212305 , 212407 , 212505 , 212609 |  | 211201
212701 , 212801 , 212901 , 213001 , 213101 , 213201 , 213301 , 213401 , 213501 , 213601 , 213701 , 214401 |  | 211301
 |  | 211503
 |  | 211601
 |  | 211701
 |  | 211801
 |  | 213801
 |  | 214501
 |  | 211901
 |  | 212001
 |  | 212101
 |  | 212201
 |  | 214001
 |  | 212305
 |  | 212407
 |  | 212505
 |  | 212609
 |  | 212701
 |  | 212801
 |  | 212901
 |  | 213001
 |  | 213101
 |  | 213201
 |  | 213301
 |  | 213401
 |  | 213501
 |  | 213601
 |  | 213701
 |  | 214401
Spreadsheet: 95302d1294922184-modify-sumproduct-and-sumif-formulas-help_123
Sheet: Supplier Bids

 | GC_Part Number | [NAME] | Completed By | Exchange Rate | Exchange Rate Date | Part Number | Category | Sub-Part Number | OPCO | Business Unit | Delivery Location | Q1 | Q2 | Q3 | Q4 | ExWorks Price | Labor ([NAME]) | VAT | Delivery Charge | Delivered Price | Product Type | Mfr Location | Comments | Exclude
 | A part number generated from the line item and the tab name. This will be automatically lookup up from the decode sheet based on the part number, delivery location, and sub part number |  |  |  |  | System part number |  | Populated from RFQ |  |  |  | Sheathing price | Hose price | Fitting 1 price | Fitting 2 price |  | HFT only |  |  | Calculated field, all savings, etc will be measured on this field for a given GC_PartNumber |  |  |  | In case we need to exclude an individual bid
 |  | Supplier 1 | [NAME] |  |  | 035-2727 | Fittings | Code 62 | ESG | Heil Environmental | Fort Payne, AL | Fabric Guard: To be made of abrasion resistant woven nylon, strong enough to withstand 25,000 abrasion per SAE J948 without wearing through the fabric at any location. Must pass ASTM D 6770 abrasion test. | 0.5 |  |  |  | 0.25 |  | 1 | 25000
 |  | Supplier 1 | [NAME] |  |  | 035-2774 | Fittings | Code 62 | ESG | Heil Environmental | Fort Payne, AL | Fabric Guard: To be made of abrasion resistant woven nylon, strong enough to withstand 25,000 abrasion per SAE J948 without wearing through the fabric at any location. Must pass ASTM D 6770 abrasion test. | 0.5 |  |  |  | 0.25 |  | 1
 |  | Supplier 2 | [NAME] |  |  | 054-2988-006 | Fittings | Code 62 | ESG | Heil Environmental | Fort Payne, AL |  |  | 2 |  |  | 1 |  | 1
Spreadsheet: 330150d1404572183-vlookup-if-formulas-and-linking-two-spreadsheets-together-long-term-absence-overview
Sheet: Overview

Name | [NAME] | Absence End | BP | Absence Days | Reason
Username 4 | 2014-09-04 00:00:00 |  | 6 | 20 | Unknown
Username 9 | 2014-09-09 00:00:00 |  | 1 | 20 | Debility
Username 12 | 2014-09-12 00:00:00 |  | 0 | 20 | Debility
Username 11 | 2014-09-11 00:00:00 |  | 0 | 20 | Tour
Spreadsheet: 550446d1512347977-help-with-the-name-xxx-already-exists-click-yes-to-use-that-version-of-the-name-sample
Sheet: Data

DateTime | PT1101
2016-01-26 22:30:00 | 3.5762600990148
2016-01-26 22:30:00.500000 | 3.5762600990148
2016-01-26 22:30:01 | 2.86098662100744
2016-01-26 22:30:01.500000 | 3.5762600990148
2016-01-26 22:30:02 | 4.29153357702205
2016-01-26 22:30:02.500000 | 2.86098662100744
2016-01-26 22:30:03 | 3.5762600990148
2016-01-26 22:30:03.500000 | 2.86098662100744
2016-01-26 22:30:04 | 2.86098662100744
2016-01-26 22:30:04.500000 | 3.5762600990148
2016-01-26 22:30:05 | 4.29153357702205
2016-01-26 22:30:05.500000 | 3.5762600990148
2016-01-26 22:30:06 | 3.5762600990148
2016-01-26 22:30:06.500000 | 4.29153357702205
2016-01-26 22:30:07 | 3.5762600990148
2016-01-26 22:30:07.500000 | 3.5762600990148
2016-01-26 22:30:08 | 2.86098662100744
2016-01-26 22:30:08.500000 | 4.29153357702205
2016-01-26 22:30:09 | 2.86098662100744
Spreadsheet: 762677d1641730657-put-results-in-same-column-but-under-different-headings-budgetex
Sheet: Example

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-02 00:00:00 | 2024-07-02 00:00:00 | 2024-08-02 00:00:00 | 2024-09-02 00:00:00
Transactions | BUDGET | ACTUAL
 |  | Income | Expenses | Income | Expenses | Income | Expenses | Income | Expenses | Income | Expenses | Income | Expenses | Income | Expenses | Income | Expenses | Income | Expenses | Income | Expenses | Income | Expenses | Income | Expenses | Income | Expenses
 | 1000
 | 500
 | 100
 | 0
 | 300
 | 60
Spreadsheet: benjamin_rogers__1244__Simple Cycle (LM6000) Entergy model
Sheet: Returns Analysis

RETURNS ANALYSIS
 | 0
('000 $) | Close
EBITDA | 0
Less Interest Payments | 0
Pre-Tax Cashflow
Less Cash Taxes | 0
Less Principal Payments | 0
Less Capex | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cashflow to Equity
Distribution to Equity | 1
Equity RROR | 0.14
Beginning Balance
RROR Target Coupon | 0
Actual Cash Flow
Equity Paydown | 0
Ending Balance
ENRON'S RETURNS ANALYSIS
Zero Residual Value
Equity Return
Actual Cash Flow
Total Cash Flow
 | IRR
 | NPV
Equity Return
Actual Cash Flow
Residual Value | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Cash Flow
 | IRR
 | NPV
Equity Return
Actual Cash Flow
Residual Value | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Cash Flow
 | IRR
 | NPV
Equity Return
Actual Cash Flow
Residual Value | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Cash Flow
 | IRR
 | NPV
Spreadsheet: 215036d1361233065-if-c-a-move-to-sheet-a-if-c-b-move-to-sheet-b-etc-medical-sample
Sheet: dentist

dentist
Date | Payee | Service | Amount |  | Date Repaid | Service | Amount Rec'd | Total Cheque |  | Match
Spreadsheet: 130816d1322594467-linking-worksheets-to-one-data-page-at-end-of-workbook-average-of-multiple-worksheets
Sheet: 2

 |  | 11 |  | 100
 |  | 10 |  | 90
 |  | 9 |  | 80
 |  | 8 |  | 70
 |  | 7 |  | 60
 |  | 6 |  | 50
 |  | 5 |  | 40
 |  | 4 |  | 30
 |  | 3 |  | 20
 |  | 2 |  | 10
 |  | 1 |  | 0
Spreadsheet: 89d88509-532b-40ce-928f-4a358ca37327
Sheet: Warrants and Certificates

Instrument Type | Exchange | Issuer | Market Maker | Round Lot | Settlement Type | Excercise type | Listing Date | Trading Currency | Issuer Code | Market Maker Code
Maximum 200 rows per listing
“Please insert all reference data, where applicable, to characterize the nature of the instrument. The headings below include comments to guide you in filling in the relevant information. This information is also used by NASDAQ OMX Nordic price website and vendors. Hence, accurate and complete information ensures that your instruments’ reference data is correctly displayed for investors and end users.” |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Underlying Instrument 1 |  |  |  |  | Underlying Instrument 2 |  |  |  |  | Underlying Instrument 3 |  |  |  |  | Underlying Instrument 4 |  |  |  |  | Underlying Instrument 5 |  |  |  |  | Underlying Instrument 6 |  |  |  |  | Underlying Instrument 7 |  |  |  |  | Underlying Instrument 8 |  |  |  |  | Underlying Instrument 9 |  |  |  |  | Underlying Instrument 10
Short Name | Long Name | ISIN code | Direction | Instruments Per Underlying | Instrument Currency | Last Trading Date | Expiration Date | Reimbursement Date | Number of Issued Instruments | Description | Strike Price | [NAME] | Knock-out level | Asian Tail Start Date | Asian Tail End Date | Leverage | Level of funding | Underlying Class | Underlying Instrument | ISIN Code for Underlying Instrument | Underlying Free Text | Basket Share | Underlying Class | Underlying Instrument | ISIN Code for Underlying Instrument | Underlying Free Text | Basket Share | Underlying Class | Underlying Instrument | ISIN Code for Underlying Instrument | Underlying Free Text | Basket Share | Underlying Class | Underlying Instrument | ISIN Code for Underlying Instrument | Underlying Free Text | Basket Share | Underlying Class | Underlying Instrument | ISIN Code for Underlying Instrument | Underlying Free Text | Basket Share | Underlying Class | Underlying Instrument | ISIN Code for Underlying Instrument | Underlying Free Text | Basket Share | Underlying Class | Underlying Instrument | ISIN Code for Underlying Instrument | Underlying Free Text | Basket Share | Underlying Class | Underlying Instrument | ISIN Code for Underlying Instrument | Underlying Free Text | Basket Share | Underlying Class | Underlying Instrument | ISIN Code for Underlying Instrument | Underlying Free Text | Basket Share | Underlying Class | Underlying Instrument | ISIN Code for Underlying Instrument | Underlying Free Text | Basket Share
Spreadsheet: 93444d1293025967-automatically-insert-rows-based-on-lookup-of-data-families-3
Sheet: Sheet1

1. Grid 1 is original data. |  |  |  |  |  |  | 2. Grid 2 is data that needs matches to be added to Grid 1. |  |  | 3. Grid 3 is desired result, which is addition of 3 records from Grid 2 that match data in Grid 1. Also (but not req): 3 new records inherit values of Columns B-D of prior row.
1. Original Data |  |  |  |  |  |  | 2. Data to be added |  |  | 3. Desired Result
A | B | C | D | E (Child ID) | F (Grandchild ID) |  | Child ID | Grandchild ID |  | A | B | C | D | E (Child ID) | F (Grandchild ID)
10 | Family | Adams | Mother |  |  |  | 547270 | BTS687378 |  | 10 |  | Adams | Mother
20 |  |  |  | 453034 |  |  | 350345 | [NAME] |  | 20 |  |  |  | 453034
30 |  |  |  |  |  |  | 628553 | ILH351884 |  | 30
40 |  |  |  |  | ITD319596 |  | 670011 | LJB870455 |  | 40 |  |  |  |  | ITD319596
50 |  | Jones | Mother |  |  |  | 188147 | BTS687379 |  | N/A |  | Adams | Mother |  | [NAME]
60 |  |  | Father |  |  |  | 324707 | KGS717797 |  | N/A |  | Adams | Mother |  | ILH351884
70 |  |  | Father | 936534 |  |  | 336690 | ILH351885 |  | N/A |  | Adams | Mother |  | LJB870455
 |  |  |  |  |  |  | 221204 | [NAME] |  | 50 |  | Jones | Mother
Notes: |  |  |  |  |  |  | 864058 | ILH351884 |  | 60 |  |  | Father
Child ID values in column E of Grid 1 to match against records in column H of Grid 2 |  |  |  |  |  |  | 889524 | LJB870455 |  | 70 |  |  | Father | 936534
All Grandchild IDs are unique |  |  |  |  |  |  | 453034 | [NAME]
Order of rows added below a record does not matter |  |  |  |  |  |  | 453034 | ILH351884
Would also like a list of those records in Grid 2 that were not added |  |  |  |  |  |  | 453034 | LJB870455
 |  |  |  |  |  |  | 564583 | ILH351885
 |  |  |  |  |  |  | 522612 | LJB870456
 |  |  |  |  |  |  | 936534 | NAW581168
 |  |  |  |  |  |  | 936534 | TVP435117
 |  |  |  |  |  |  | 936534 | PUS919263
 |  |  |  |  |  |  | 936534 | FSP572454
 |  |  |  |  |  |  | 746997 | KGS717799
 |  |  |  |  |  |  | 672356 | ILH351887
 |  |  |  |  |  |  | 202066 | LJB870458
 |  |  |  |  |  |  | 497926 | BTS687382
 |  |  |  |  |  |  | 831859 | KGS717800