tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 742514d1627830757-finding-the-latest-date-based-on-conditions-excel-test
Sheet: Sheet2

PRODUCT | 2021-07-20 00:00:00 | 2021-07-21 00:00:00 | 2021-07-22 00:00:00 | 2021-07-23 00:00:00 | 2021-07-24 00:00:00 | 2021-07-25 00:00:00 | 2021-07-26 00:00:00 | 2021-07-27 00:00:00 | 2021-07-28 00:00:00 | 2021-07-29 00:00:00 | 2021-07-30 00:00:00 | 2021-07-31 00:00:00
12345 | 0 | 10 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 10 | 0 | 0
54321 | 20 | 0 | 20 | 20 | 20 | 20 | 20 | 0 | 0 | 0 | 20 | 20
12121 | 0 | 10 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 10 | 0 | 0
13134 | 20 | 0 | 20 | 20 | 20 | 20 | 20 | 0 | 0 | 0 | 20 | 20
14141 | 0 | 10 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 10 | 0 | 0
15151 | 20 | 0 | 20 | 20 | 20 | 20 | 20 | 0 | 0 | 0 | 20 | 20
62719 | 0 | 10 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 10 | 0 | 0
96285 | 20 | 0 | 20 | 20 | 20 | 20 | 20 | 0 | 0 | 0 | 20 | 20
31748 | 0 | 10 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 10 | 0 | 0
22175 | 20 | 0 | 20 | 20 | 20 | 20 | 20 | 0 | 0 | 0 | 20 | 20
95965 | 0 | 10 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 10 | 0 | 0
91418 | 20 | 0 | 20 | 20 | 20 | 20 | 20 | 0 | 0 | 0 | 20 | 20
84276 | 0 | 10 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 10 | 0 | 0
60112 | 20 | 0 | 20 | 20 | 20 | 20 | 20 | 0 | 0 | 0 | 20 | 20
93759 | 0 | 10 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 10 | 0 | 0
51540 | 20 | 0 | 20 | 20 | 20 | 20 | 20 | 0 | 0 | 0 | 20 | 20
93641 | 0 | 10 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 10 | 0 | 0
88931 | 20 | 0 | 20 | 20 | 20 | 20 | 20 | 0 | 0 | 0 | 20 | 20
26898 | 20 | 0 | 20 | 20 | 20 | 20 | 20 | 0 | 0 | 0 | 20 | 20
Spreadsheet: 679177d1590245844-pivot-table-subtotals-would-like-variance-for-the-above-2-rows-2019-20_total-volumes_errors-carla77-
Sheet: Report

Count of No dossier |  |  | Period
Spécialité2 | Group | Year | 1 | 3 | 4 | 5 | 6 | 7 | 11 | 12 | 13 | (blank) | Grand Total | Error
ACC | Numer of cases: | 2018-19 |  |  |  |  |  |  | 2 | 2 |  |  | 4
 |  | 2019-20 |  |  |  |  |  |  | 1 | 2 |  |  | 3
 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | -1
 | PRINCIPALE ONLY | 2018-19 |  |  |  |  |  |  |  | 45 |  |  | 45
 |  | 2019-20 | 11 |  |  |  |  |  |  |  |  |  | 11 | this line (group) should only appear in Cardiac not in specialite ACC-
 |  | [NAME] | 11 | 0 | 0 | 0 | 0 | 0 | 0 | -45 | 0 | 0 | -34 | this line (group) should only appear in Cardiac not in specialite ACC-
 | GESTRID | 2019-20 |  |  |  |  |  |  |  | 4 | 10 |  | 14 | this line (group) should only appear in Cardiac not in specialite ACC-
 |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 10 | 0 | 14
Cardiac | Numer of cases: | 2018-19 |  |  |  |  |  |  | 1 |  |  |  | 1
 |  | 2019-20 | 3 |  |  |  |  |  |  | 1 | 2 |  | 6
 |  | [NAME] | 3 | 0 | 0 | 0 | 0 | 0 | -1 | 1 | 2 | 0 | 5
 | CABG | 2018-19 |  | 1 | 1 | 1 |  | 1 |  |  |  |  | 4
 |  | 2019-20 | 9 |  |  |  |  | 1 | 1 | 20 | 12 |  | 43
 |  | [NAME] | 9 | -1 | -1 | -1 | 0 | 0 | 1 | 20 | 12 | 0 | 39
 | Valves | 2018-19 |  | 1 |  |  | 1 |  |  |  |  |  | 2
 |  | 2019-20 |  |  |  | 1 |  |  | 1 | 2 | 4 |  | 8
 |  | [NAME] | 0 | -1 | 0 | 1 | -1 | 0 | 1 | 2 | 4 | 0 | 6
 | Other | 2019-20 | 1 |  |  |  |  |  | 1 | 3 | 1 |  | 6
 |  | [NAME] | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 1 | 0 | 6
Grand Total |  |  | 48 | 0 | 0 | 2 | 0 | 2 | 8 | 64 | 58 | 0 | 182
 |  |  |  |  |  |  |  |  |  |  |  |  |  | this line should only appear in ACC specialite
 |  |  |  |  |  |  |  |  |  |  |  |  |  | this line should only appear in ACC specialite
Spreadsheet: 809177d1670947826-need-help-with-sum-filter-formula-example
Sheet: Pay Items

Pay Item Number | WBS | UOM | Description | Running Total | Forecasted Qty | Pay Qty | ∆ [NAME] vs. Field Measured
NA |  | EA | Item 1 |  | 5 | 5
NA |  | EA | Item 2 |  | 16 | 16
NA |  | LF | Item 3 |  | 272 | 272
NA |  | LF | Item 4 |  | 3065 | 3065
NA |  | SY | Item 5 |  | 3522 | 3522
NA |  | SY | Item 6 |  | 245 | 245
NA |  | LF | Item 7 |  | 281 | 281
NA |  | CY | Item 8 |  | 118 | 118
NA |  | CY | Item 9 |  | 2288 | 2288
NA |  | LB | Item 10 |  | 156774 | 156774
NA |  | LB | Item 11 |  | 680047 | 680047
NA |  | LF | Item 12 |  | 982 | 982
NA |  | EA | Item 13 |  | 4 | 4
NA |  | LF | Item 14 |  | 647 | 647
NA |  | LF | Item 15 |  | 4475 | 4475
Pay Item Number | WBS | UOM | Description | Quantity Installed | Date Installed | Details | Pay Qty | ∆ [NAME] vs. Field Measured | Notes
 |  |  | Item 5 | 3
 |  |  | Item8 | 1
Spreadsheet: 691872d1597928088-return-fiscal-calendar-month-year-and-period-based-on-calendar-date-fiscal-dummy
Sheet: Data

Day | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday
Date | 2020-08-20 00:00:00 | 2020-08-21 00:00:00 | 2020-08-24 00:00:00 | 2020-08-25 00:00:00 | 2020-08-26 00:00:00 | 2020-08-27 00:00:00 | 2020-08-28 00:00:00 | 2020-08-31 00:00:00 | 2020-09-01 00:00:00 | 2020-09-02 00:00:00 | 2020-09-03 00:00:00 | 2020-09-04 00:00:00 | 2020-09-07 00:00:00 | 2020-09-08 00:00:00
Fiscal Month
Fiscal Year
Fiscal Period
Spreadsheet: 760503d1640254969-calculating-elaspsed-time-between-two-time-cells-in-different-time-zones-flights2021_final
Sheet: FlightInfo

 | Flight Information
 | Please NOTE: All departures times are given in Local Time, UTC or CET, depending on the departure location time zone
 | Select Flight | From |  | To |  | Flight details
 | FR3063
 | Day | From |  | To |  | Departure | [NAME] | Operator | Flight No | Scheduled Flying Time
Spreadsheet: 793005d1661261399-formula-for-date-conversation-in-the-specific-format-get-days-ans
Sheet: Sheet1

 | Date | Customer name |  |  | output required |  |  |  |  | output required
 | 2022-08-01 00:00:00 | Dominos
 | 2022-08-02 00:00:00 | Kfc |  |  | Customer | Date visited |  |  |  | Customer | Date visited
 | 2022-08-03 00:00:00 | [NAME] |  |  | Dominos | 1,7,11 |  |  |  | Dominos | 1,7,11
 | 2022-08-04 00:00:00 | Burger king |  |  | Kfc | 2,9 |  |  |  | Kfc | 2,9
 | 2022-08-05 00:00:00 | la pinoz |  |  | [NAME] | 3,10 |  |  |  | [NAME] | 3,10
 | 2022-08-06 00:00:00 | pizza king |  |  | Burger king | 4,8,12 |  |  |  | Burger king | 4,8,12
 | 2022-08-07 00:00:00 | Dominos |  |  | la pinoz | 5 |  |  |  | la pinoz | 5
 | 2022-08-08 00:00:00 | Burger king |  |  | pizza king | 6,13 |  |  |  | pizza king | 6,13
 | 2022-08-09 00:00:00 | Kfc
 | 2022-08-10 00:00:00 | [NAME]
 | 2022-08-11 00:00:00 | Dominos
 | 2022-08-12 00:00:00 | Burger king
 | 2022-08-13 00:00:00 | pizza king
Spreadsheet: 146980d1332447798-match-value-to-determine-lookup_vector-lookupexample
Sheet: Sheet1

Instrument | Total Movement (in)
E10
E-100A
E-100B
E-100F
E-101A
E-101B
E-101F
E10B
E-110A
E-110B
E-110C
E-110D
E-110F
E-111A
E-111B
E-111C
E-111D
E-111F
E-112A
E-112B
E-112C
E-112D
E-112E
E-112F
E-113A
E-113B
E-113C
Spreadsheet: 1672a1eb-d08f-473b-baa9-7ab5d129db2c
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Offshoreutstyr
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Cosalt Offshore Norway AS | Bekhuskaien 1 | 4014 | Stavanger | 51 55 45 00
ACE Winches Norge AS | Sothammargeilen 9 | 4029 | Stavanger | 51 83 95 20
Trelleborg Offshore Norway AS | Kalosjeg. 15 | 3055 | [NAME] | 32 23 20 00 | 32 23 22 00
[NAME] | Industriv. 40 | 1337 | Sandvika | 67 13 69 80 | 67 13 46 35
Marine Aluminium AS | Husøyv. 165 | 4262 | Avaldsnes | 52 84 84 00
PSSI AS | [NAME] g 6 | 3012 | Drammen | 400 04 325 | 32 89 90 91
[NAME] | Øyav. 60 | 4270 | Åkrehamn | 52 84 45 20
Aukra Maritime AS | Nautnes | 6480 | Aukra | 71 17 17 00
Bull industri- og skipsteknisk as | Ringeriksv. 241 | 1340 | Skui | 67 17 54 00
[NAME] | Høgslundv. 49 | 2020 | Skedsmokorset | 06706
Origo Solutions AS | Kanalarmen 12 | 4033 | Stavanger | 920 80 500
Mørenot Offshore AS |  | 6280 | Søvik | 70 20 95 00
Scana Offshore Vestby AS | Tverrv. 4 | 1540 | Vestby | 64 95 65 00 | 64 95 65 01
Origo Solutions AS | Teknologiv. | 4846 | Arendal | 920 80 500
Jumo AS | Storg. 2B | 1767 | Halden | 67 97 37 10 | 67 97 37 11
Northrop Grumman [NAME] BV | Damsgårdsv. 167 | 5160 | Laksevåg | 55 94 94 94 | 55 34 52 27
Origo Solutions AS | [NAME] | 4623 | Kristiansand | 920 80 500
Apply Leirvik AS | Storhaugv. 130 | 5416 | Stord | 53 49 62 00 | 53 49 62 01
Øglænd System AS | Engelsvollv. 264 | 4353 | Klepp stasjon | 51 78 81 00 | 51 78 81 60
Origo Solutions AS | Skipperg. 12 | 3921 | Porsgrunn | 920 80 500
Wilhelmsen Technical Solutions Norway AS | Strandv. 20 | 1366 | Lysaker | 67 58 40 00
Vinje Industri AS | Skibåsen 10A | 4636 | Kristiansand | 38 03 88 00
TESS AS | Industrig. 8 | 3414 | [NAME] | 32 84 40 00 | 32 84 40 01
Aker Process Systems AS | [NAME]. 36 | 1364 | Fornebu | 67 83 77 00 | 67 83 77 99
Dril-Quip Europe Ltd | Lagerv. 31 | 4033 | Stavanger | 51 44 37 00 | 51 44 37 01
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 840659d1692891933-copying-records-from-sheet1-to-sheet2-based-on-a-condition-dynamically-mockdata
Sheet: Interviews

Date of Interview | Current Location | Candidate Name | [NAME] | Sponsorship? | Relocation? | Availability | Position Title Going For | Tech Interviewer | [NAME] | Interview Feedback | Recommendation | [NAME] | [NAME] | Start Date
2023-06-01 00:00:00 | Texas | Name1 | RecruiterName1 | No | Yes | Two Weeks | Role Title1 | InerviewerName1 | InerviewerName1 | xxxxxxxxxxxxx | Rejected
Spreadsheet: 886614d1736683708-sorting-data-from-a-dynamic-list-jeffcmusic-excel-help-jetemc
Sheet: Sheet1

Number of Stops | Road Name | Stops effected | Closure Type
 | data from 'stops list'  tab column E | data to 'text join' from 'stops list' column C | data from 'stop list' column H
 | EDGWARE WAY | 15758, 16105, 14702 | Publicity Only, Publicity & Hood
1 | EDGWAREBURY LANE (N AND S OF A41) | 15760 | Publicity Only
7 | FINCHLEY ROAD | bp4548, 16153, 1218, 12027, 116, 136, 1464 | Publicity Only, Publicity & Hood
1 | GLOUCESTER PLACE | 29797 | Publicity & Hood
1 | STATION ROAD | 25118 | Publicity Only
EXAMPLE OF OUTCOME
Number of Stops | Road Name | Stops effected | Closure Type
1 | station road | 25118 | Publicity only
1 | edgwarebury lane | 15760 | Publicity only
1 | gloucester place | 29797 | publicity & hood
2 | [NAME] | 15758, 14702 | Publicity only
1 | [NAME] | 16105 | publicity & hood
Spreadsheet: 7303b45d-6488-42c4-ab68-b5897a98a8bb
Sheet: Sheet1

MS Smart Moves Points Tracker Week 6: February 18 - February 24
You can receive up to 3 points per day.  Enter a one (1)  in the appropriate day of the week column that corresponds to your healthy task and total your points at the end of each day.  Then simply total those 7 totals for your weekly points total. You can earn up to 21 points per week.  Visit cureMSutah.org or cureMSidaho.org to report your points to the Chapter each week.
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
Body (pick one per day)
5 or more servings of fruits/vegetables
No soda for the day
30 minutes or more of exercise (cardio, strength, stretching)
Mind (pick one per day)
30 minutes of reading
Brain exercise/game
Journaling
Spirit (pick one per day)
Perform volunteer work
Go on an outing with others
Support-online, support group, etc.
TOTAL
Spreadsheet: 546349d1509995947-problem-with-solver-maxsharpe
Sheet: max sharpe (3)

Asset | Volat | Rend | Pesi |  | Solver
EMTS LYX GLOBAL BONDS | 0.02687 | 0.06689 |  |  | 6
Old Mut [NAME] Abs Ret | 0.03751 | 0.08129 |  |  | 5
Nordea-1 Stable Ret BP Acc | 0.03399 | 0.07069 |  |  | 4
Pimco Income Hdg | 0.0318 | 0.0751 |  |  | 5
 |  |  |  |  | 2.9e-06 | 7e-07 | 7e-07 | 1.7e-06
 |  |  |  |  | 7e-07 | 5.6e-06 | 1.3e-06 | 0
 |  |  |  |  | 7e-07 | 1.3e-06 | 4.6e-06 | 1.1e-06
 |  |  |  |  | 1.7e-06 | 0 | 1.1e-06 | 4e-06
Media
varianza
SD
[NAME]
fattore molt | 2.7
[NAME]
Spreadsheet: 773103d1647615952-help-moving-table-contents-from-one-sheet-to-another-depending-on-criteria-example-1-fixed
Sheet: Sheet2

 | Yes |  |  |  | No
 | Name | On | Off |  | Name | On | Off
 |  | 07:00:00 | 19:00:00 |  |  | 07:00:00 | 19:00:00
 | fgfgd | 07:00:00 | 19:00:00 |  | dez | 07:00:00 | 19:00:00
 | hgh | 07:00:00 | 19:00:00 |  | ee | 07:00:00 | 19:00:00
 | yyt | 07:00:00 | 19:00:00
Spreadsheet: 130184d1322115561-how-to-use-if-formula-for-change-price-copy-of-december
Sheet: 5

 |  |  |  | 2011-12-05 00:00:00
Newspaper | Price | Quantity | Total
Value | 0.88 |  | 0
Value1 | 0.98 |  | 0
Value2 | 1.22 |  | 0
Value3 | 1.22 |  | 0
Value4 | 0.83 |  | 0
Value5 | 1.01 |  | 0
Value6 | 1.03 |  | 0
Value7 | 1.01 |  | 0
Value8 | 0.8 |  | 0
Value9 | 1.04 |  | 0
Value10 | 1.04 |  | 0
Value11 | 1.04 |  | 0
Total |  |  | 0
 | Grand Total |  | 0
Spreadsheet: 695075d1600033914-help-importing-league-standings-into-spreadsheet-wins-pool-example
Sheet: Wins Pool

Pool Standings
Rank | Owner | Wins | Losses | This Week | Total Pts. | [NAME] | GB
 |  |  |  | 0-0 |  |  | 1
 |  |  |  | 0-0 |  |  | 12
 |  |  |  | 0-0 |  |  | 11
 |  |  |  | 0-0 |  |  | 7
 |  |  |  | 0-0 |  |  | -
 |  |  |  | 0-0 |  |  | 11
 |  |  |  | 0-0 |  |  | 3
 |  |  |  | 0-0 |  |  | 7
 |  |  |  | 0-0 |  |  | 9
 |  |  |  | 0-0 |  |  | 8
NFL Standings
Rank | Team | Wins | Losses | Points For | Owner | [NAME] | Result | Games | Streak
 | Arizona Cardinals | 0 | 0 | 0 |  |  | W
 | Atlanta Falcons | 0 | 0 | 0 |  |  | L
 | Baltimore Ravens | 0 | 0 | 0 |  |  | W
 | Buffalo Bills | 0 | 0 | 0 |  |  | L
 | Carolina Panthers | 0 | 0 | 0 |  |  | W
 | Chicago Bears | 0 | 0 | 0 |  |  | W
 | Cincinnati Bengals | 0 | 0 | 0 |  |  | L
 | [NAME] | 0 | 0 | 0 |  |  | W
 | Dallas Cowboys | 0 | 0 | 0 |  |  | W
 | Denver Broncos | 0 | 0 | 0 |  |  | W
 | Detroit Lions | 0 | 0 | 0 |  |  | L
 | Green Bay Packers | 0 | 0 | 0 |  |  | W
 | Houston Texans | 0 | 1 | 20 |  |  | L |  | 1L
 | Indianapolis Colts | 0 | 0 | 0 |  |  | L
 | [NAME] | 0 | 0 | 0 |  |  | L
 | Kansas City Chiefs | 1 | 0 | 34 |  |  | L |  | 1W
 | Las Vegas Raiders | 0 | 0 | 0 |  |  | W
 | Los Angeles Chargers | 0 | 0 | 0 |  |  | W
 | Los Angeles Rams | 0 | 0 | 0 |  |  | W
 | [NAME] | 0 | 0 | 0 |  |  | W
 | Minnesota Vikings | 0 | 0 | 0 |  |  | L
 | New England Patriots | 0 | 0 | 0 |  |  | L
 | New Orleans Saints | 0 | 0 | 0 |  |  | L
 | New York Giants | 0 | 0 | 0 |  |  | L
 | New York Jets | 0 | 0 | 0 |  |  | L
 | Philadelphia Eagles | 0 | 0 | 0 |  |  | W
 | Pittsburgh Steelers | 0 | 0 | 0 |  |  | W
 | San Francisco 49ers | 0 | 0 | 0 |  |  | L
 | [NAME] | 0 | 0 | 0 |  |  | W
 | Tampa Bay Buccaneers | 0 | 0 | 0 |  |  | L
 | Tennessee Titans | 0 | 0 | 0 |  |  | W
 | Washington Football Team | 0 | 0 | 0 |  |  | L
Spreadsheet: 26689d1219075020-what-function-to-use-to-populate-data-from-other-worksheet-autopopulatedatainfohelp
Sheet: summary

 |  | branch
 | date | st albans | sunbury | peterborough
 | 2008-06-23 00:00:00 | ? | ? | ?
 | 2008-06-24 00:00:00
 | 2008-06-25 00:00:00
 | 2008-06-26 00:00:00
 | 2008-06-27 00:00:00
 | 2008-06-28 00:00:00
 | 2008-06-29 00:00:00
 | 2008-06-30 00:00:00
 | 2008-07-01 00:00:00
 | 2008-07-02 00:00:00
 | 2008-07-03 00:00:00
 | 2008-07-04 00:00:00
 | 2008-07-05 00:00:00
 | 2008-07-06 00:00:00
 | 2008-07-07 00:00:00
 | 2008-07-08 00:00:00
 | 2008-07-09 00:00:00
 | 2008-07-10 00:00:00
 | 2008-07-11 00:00:00
 | 2008-07-12 00:00:00
 | 2008-07-13 00:00:00
 | 2008-07-14 00:00:00
 | 2008-07-15 00:00:00
 | 2008-07-16 00:00:00
 | 2008-07-17 00:00:00
 | 2008-07-18 00:00:00
 | 2008-07-19 00:00:00
 | 2008-07-20 00:00:00
 | 2008-07-21 00:00:00
 | 2008-07-22 00:00:00
 | 2008-07-23 00:00:00
 | 2008-07-24 00:00:00
 | 2008-07-25 00:00:00
 | 2008-07-26 00:00:00
 | 2008-07-27 00:00:00
 | 2008-07-28 00:00:00
 | 2008-07-29 00:00:00
 | 2008-07-30 00:00:00
 | 2008-07-31 00:00:00
 | 2008-08-01 00:00:00
 | 2008-08-02 00:00:00
 | 2008-08-03 00:00:00
 | 2008-08-04 00:00:00
 | 2008-08-05 00:00:00
 | 2008-08-06 00:00:00
 | 2008-08-07 00:00:00
 | 2008-08-08 00:00:00
 | 2008-08-09 00:00:00
 | 2008-08-10 00:00:00
 | 2008-08-11 00:00:00
 | 2008-08-12 00:00:00
 | 2008-08-13 00:00:00
 | 2008-08-14 00:00:00
 | 2008-08-15 00:00:00
 | 2008-08-16 00:00:00
 | 2008-08-17 00:00:00
Spreadsheet: 285789d1387838953-reference-changing-column-on-specified-cell-report1
Sheet: Other Metrics

Date | 2013-12-15 00:00:00 | 2013-12-23 00:00:00 | [NAME]
Incidents Raised | 25 | 3 | Rising
Resolved on first contact | 25 | 7 | Rising
% resolved |  |  | Rising
Balance |  |  | Falling
Spreadsheet: 156563d1337347331-summing-two-fields-mortgage-calculator
Sheet: Random

REAL-LIFE ACCELERATED (Random, Variable) |  |  |  | Enter in your Primary Mortgage amount, [NAME] in Years for the mortgage/loan, the Annual Interest Rate, and Period Begin Date.  You can also add in Random Extra per Month to your payments in order to help pay down your loan faster and save money in interest. So if you know certain months you can pay extra now you can calculate it out. You can use this one to track your current mortgage and know the extra you are paying is saving you money.
Given the following:
Primary Mortgage |  | 200000
Term in Years |  | 40
Annual Interest Rate |  | 0.06
Original Payment |  |  |  | Interest Paid
 |  |  |  | Total Paid
 |  |  |  | Interest Saved
Period | Year | Balance | Payment | Principal | Interest | Equity | Total Interest | Total Payments | Extra Per Month
1 | 0 |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 500
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 500
Spreadsheet: 739783d1625930091-non-array-formula-to-extract-unique-values-in-column-a2-a61-and-place-in-b2-b61-non-array-to-extract-unique-values
Sheet: Sheet1

Letter
A
A
B
B
C
C
C
C
C
E
E
F
H
J
J
L
L
M
O
O
O
P
R
R
S
S
S
S
S
S
S
T
T
T
Spreadsheet: 673023d1587126137-autofil-pairs-of-rows-example-abcpairs
Sheet: Longer example

Date |  |  | A |  | B |  | C |  | D |  | E |  | F |  | G |  | H |  | I |  | J |  | K |  | L |  | M |  | N |  | O |  | P |  | Q |  | R |  | S |  | T |  | U |  | V |  | W |  | X |  | Y |  | Z |  | AA |  | AB |  | AC |  | AD |  | AE
 |  |  | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b | a | b
 |  |  | 1 |  | 3 |  | 3 |  | 3 |  | 3
only filled from D4 to L32 as example, but it go all the way to BM654 |  |  | 1 |  | 3 |  | 1 |  | 3 |  | 3
 |  |  | 1 |  | 3 |  |  |  | 3 |  | 3
 |  |  |  |  | 3 |  |  |  | 3 |  | 3
 |  |  |  |  | 3 |  | 1 |  | 1 |  | 3
 |  |  |  |  | 1 |  | 1 |  |  |  | 3
 |  |  |  |  | 1 |  |  |  | 1 |  | 1
 |  |  | 3 |  | 1
 |  |  | 3 |  | 1
 |  |  | 3 |  |  |  |  |  |  |  | 1
 |  |  | 3 |  |  |  |  |  | 1
 |  |  | 3 |  |  |  | 3 |  | 1
 |  |  | 3 |  |  |  | 3
 |  |  | 3 |  |  |  | 3
 |  |  | 3 |  | 3 |  | 3 |  | 1
 |  |  | 1 |  | 3 |  | 1 |  | 1 |  | 1
 |  |  | 1 |  | 3
 |  |  |  |  | 3 |  |  |  | 1
 |  |  |  |  | 3 |  | 1
 |  |  | 1 |  | 1 |  | 1 |  | 1 |  | 1
 |  |  |  |  |  |  | 1 |  | 1
 |  |  |  |  | 1 |  |  |  | 1
 |  |  | 1 |  | 1 |  |  |  |  |  | 1
 |  |  |  |  | 1 |  | 1
 |  |  | 1 |  | 1 |  | 1 |  |  |  | 1
 |  |  |  | 1 |  | 1
 |  |  |  | 1 |  |  |  | 1 | 3 |  |  | 1
 |  |  | 1 |  |  |  |  |  | 3
Spreadsheet: daren_farmer__5315__Enron Nom Change
Sheet: Sheet1

To:   [NAME]          (Enron) |  |  |  |  |  | Phone: | (713) 853-9272
From:  Jan Svajian      ([NAME]) |  |  |  |  |  | FAX: | (713) 646-2391
Date:  6/20/00 |  |  |  |  |  | E-Mail: | [EMAIL]
Subject:  Nomination Change Effective June 21st
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | DBQ Available | Excess Available | First of the month original nomination |  | Pipeline affected
2000-06-21 00:00:00 | Haynes 17, 18 CDP | 1398 | 1286 | 112 | 1747 |  | TEJAS
Volume change is necessary due to the CDP being down for 48 hours.
Spreadsheet: joe_parks__14755__ITM 05 out Positions
Sheet: Financial Book Position

TIME BUCKET/KEY: |  |  | REPORT REGION | RISK TYPE | 1 |  | 2 |  | 35 |  | 36 |  | 37 |  | 38 |  | 39 |  | 40 |  | 41 |  | 42 |  | 43 |  | 44 |  | 45 |  | 46 |  | 47 |  | 48 |  | 49 |  | 50 |  | 51
(Positions in Cont. [NAME].)     From: | Post ID |  |  |  | 2002-12-01 00:00:00 |  |  |  | 2005-01-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total ECT
To: | Order |  |  |  | 2002-12-01 00:00:00 |  | Index |  | 2005-12-31 00:00:00
In-the-money Live Fiancial 2005 out
Physical | NG-Price Exotics |  | NGEXOTIC | P |  |  | 0
Index | 2 |  | NGHEDGE | P | 0
Gas Daily |  |  |  |  | 0
Gas Daily Index |  |  |  |  |  |  | 0
Basis - Notional | 3 |  | NGLTX | P | 0
Basis - Equivalent | 4 |  | NGFPL | P | 0
Price | 5 |  | NGFPL | D | 0
TOTAL:
Basis Roll-off
Spreadsheet: 876147d1722834369-adding-grand-total-at-end-and-doing-sum-of-each-column-etax-hstack-with-grand-total-aligw
Sheet: RawData

Partiuclars | Head 1 | Head 2 | Head 3 | Head 4 | Head 5 | Head 6 | Head 7 | Head 8
Apple |  |  |  | 256 |  | 464849.17 | 12 | 52 | Sun
Orange |  |  |  | 316 | 45 |  | 40 |  | Sun
Sunflower |  |  |  | 153 | 66 | 118457.9 | 32 | 65 | Sun
Poppy |  |  |  | 0 | 77 |  | 36 |  | Sun
X |  |  |  |  |  |  |  |  | *
USA |  |  |  | 213820.86 | 189222 | 11915.75 | 32530 | 20037.62 | [NAME]
Africa |  |  |  | 118457.9 | 104830 | 3366 | 9189.18 | 464849.17 | [NAME]
Australia |  |  |  | 20037.62 |  | 4256.55 | 11620.38 |  | [NAME]
 |  |  |  | 464849.17 |  |  | 20037.62 |  | [NAME]
Y |  |  |  |  |  |  |  |  | *