tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 873757d1720321181-next-5-row-number-what-formula-should-i-put-so-that-i-get-the-next-row-in-column-c-as-the-next-5-row-number
Sheet: Sheet1

24232.75 |  |  | =A1
24232.75 |  |  | =A5
24232.75 |  |  | =A10
24234.05 |  |  | =A15 etc
24233.45 |  | ? | =A20 formula
24234.95 |  | ? | What formula should I put so that I get the next row in column C as the next 5 row number of column A
24235.6 |  | ?
24232.85 |  | ?
24221.35 |  | ?
24222.7
24219.15
24218.9
24215.2
24220.65
24228.95
24232
24230.25
24233.4
24232.9
24229.3
24228.1
24221.7
24224.65
24223.6
24220.95
24221.05
24221.15
24220.6
24222.7
24226.95
24227.15
24227.4
24229.9
24234.45
24232.65
24231.4
24231.35
24231.35
24230.55
24232.05
24233
24232.4
24231.25
24233.5
24232.9
24233.45
24234.25
24233.4
24235.95
24232.9
24232.25
24230.9
24229.45
24228.65
24229
24230.1
24233.15
24233.7
24235.05
24233.25
24234.85
24237.25
24237.25
24234.7
24236.6
24235.9
24237
24237.5
24239.05
24236.25
24236.7
24236.8
24235.8
24237.5
24238.5
24238.15
24238.85
24240.35
24243.2
24240.75
24242.4
24240.9
24238.65
24233
24228.95
24228.2
24225.3
24227.8
24225.6
24226.95
24225.5
24229.5
24228.85
24231
24233.8
24229.65
24230.1
24228
24228.5
24229.3
24230.65
24231.15
24232.4
24232.95
24228.1
24228.55
24227.4
24224.95
24225.7
24221.8
24223.5
24225.25
24224.9
24228.55
24228.15
24228.4
24226.7
24228.1
24226.8
24226.85
24224.45
24223
24224.5
24225.4
24222.25
24218
24215.45
24217.7
24216.8
24216.4
24217.35
24216.5
24215.25
24213.9
24217.15
24215.4
24212.75
24213.3
24212.5
24211.4
24212.2
24211.35
24213.95
24210.6
24211.25
24210.4
24209.05
24212.3
24210.65
24209.65
24209.55
24211.3
24210.35
24207.4
24204.2
24207.8
24210.75
24211.05
24214.4
24216.85
24220.25
24219.4
24218.85
24216.4
24211.75
24213.3
24212.6
24214.15
24217.3
24217.95
24216.2
24215
24210.75
24216.9
24226
24230.8
24245.2
24243.7
24249.2
24252.1
24259.2
24263
24265.6
24268.2
24270.8
24272.1
24273.3
24274.35
24278.8
24277.5
24283.4
24290.95
24296.65
24296.65
24292.65
24302.35
24303.2
24298.1
24296.25
24290.95
24288.9
24289.6
24291.8
24289.35
24288.1
24285
24288.6
24290.6
24297.15
24298.3
24304.7
24309.45
24312.8
24314.75
24315.5
24319.9
24324.75
24329.25
24326.2
24317.25
24320.95
24321.45
24321
24319.15
24319.85
24319.9
24322.55
24329.55
24331.75
24335.4
24334.5
24333.25
24335.9
24336.7
24336.9
24339.9
24343.55
24344.45
24341.9
24338.7
24338.25
24336
24338.65
24346.65
24345.55
24347
24346.6
24348.1
24349.1
24353.25
24348.55
24343.55
24341.95
24339.75
24339.85
24341.55
24340.05
24337.7
24334.35
24337.1
24344.25
24344
24346.6
24349.25
24352.7
24352.4
24351.3
24353.1
24357
24357.85
24361.3
24360.75
24361.45
24356.85
24352.5
24352.1
24347.85
24345.1
24345.9
24345.25
24343.65
24341.75
24340.55
24342.65
24341.7
Spreadsheet: 185757d1349816761-ultimate-challenge-generate-list-from-checkboxes-and-or-values-budget-template-sample
Sheet: Budget

Project Title:
Address: |  |  |  |  |  | Expected Construction Start Date:
 |  |  |  |  |  | Estimated Area: |  |  |  | G.S.F.
Project Phase: |  |  |  |  |  | Est. Proj. Budget: |  |  |  | $/G.S.F.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PHASE
 |  | PROFESSIONAL FEES |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
101 |  | Appraisals Fee |  |  |  | 6000 |  |  |  |  |  |  |  | x
 |  | Surveys |  |  |  | 3000 |  |  |  |  |  |  |  | x
 |  | Test Borings |  |  |  | 1000 |  |  |  |  |  |  |  | x
 |  | Architect and/or Engineer - Total Fee |  |  |  | 25000 |  |  |  |  |  |  |  | 30 | x | x | x | 10
 |  | Architect - Reimbursable Expenses |  |  |  | 3600 |  |  |  |  |  |  |  |  |  |  | x | x
 |  | Specialty Consultants |  |  |  | 10000 |  |  |  |  |  |  |  | x | x | x
 |  | Landscape Architect |  |  |  | 8000 |  |  |  |  |  |  |  |  |  | 50 | x | x
 |  | Cost Consultant |  |  |  | 0
 |  | Legal & Administrative: Permits, etc. |  |  |  | 0
 |  | Misc. Reproductions, Printing, etc. |  |  |  | 0
 |  | Interior Design Consultant |  |  |  | 8000 |  |  |  |  |  |  |  |  |  |  | 75 | x
 |  | Pre-Construction Consultant |  |  |  | 2000 |  |  |  |  |  |  |  |  | x
 |  | Scope Development Services |  |  |  | 1400 |  |  |  |  |  |  |  |  | x
 |  |  |  | Subtotal
 |  | CONSTRUCTION
201 |  | Demolition |  |  |  | 16000 |  |  |  |  |  |  |  | x
 |  | Construction |  |  |  | 500000 |  |  |  |  |  |  |  |  | 35 | x | x | 10
 |  | Non-Structural Improvement |  |  |  | 51000 |  |  |  |  |  |  |  |  | x | x | x
 |  | Landscaping/Site Development |  |  |  | 18000 |  |  |  |  |  |  |  |  |  |  | x | 10
 |  |  |  | Subtotal
 |  | EQUIPMENT & FURNISHINGS - MOVABLE
301 |  | Furniture |  |  |  | 0
 |  | Movable, Technical, or Scientific Equipment |  |  |  | 0
 |  | Building Maintenance Equipment |  |  |  | 0
 |  |  |  | Subtotal
 |  | OTHER BUILDING COSTS
401 |  | Property Acquisition |  |  |  | 0
 |  | Utilities Installation to Site |  |  |  | 0
 |  | Security Systems |  |  |  | 0
 |  | Special Fixed Equipment |  |  |  | 0
 |  | Telephones & Data |  |  |  | 0
 |  | Signage |  |  |  | 0
 |  | Hazardous Materials Removal |  |  |  | 0
 |  | Construction Bond |  |  |  | 0
 |  | Moving Costs |  |  |  | 0
 |  | Utilities Use During New Construction |  |  |  | 0
 |  | Utility [NAME] |  |  |  | 0
 |  | Other Costs |  |  |  | 0
 |  |  |  | Subtotal
 |  |  |  | Subtotal Project Costs
 |  | PROJECT MANAGEMENT FEE
801 |  | Management Fee (% of Subtotal Project Costs) |  |  |  | 0.025
 |  | excluding the property acquisition
 |  | PROJECT CONTINGENCY
901 |  | Contingency (% of Subtotal Project Costs) |  |  |  | 0.1
 |  | excluding the property acquisition
 |  |  |  | ESTIMATED  TOTAL PROJECT BUDGET
Prepared By |  |  |  |  | Date Issued: |  |  |  | Revised:
Reviewed and Approved by
Reviewed and Approved by
Spreadsheet: 109463d1306323322-print-out-rows-that-dont-have-null-in-specific-column-order
Sheet: Sheet1

[NAME] | Unit | Quantity
Item1 | Kgs | 1
Item2 | Package | 45
Item3 | Kgs | 3
Item4 | Kgs | 23
Item5 | Package
Item6 | Kgs | 4
Item7 | Package
Item8 | Kgs
Item9 | Kgs | 234
Item10 | Package
Item11 | Kgs
Item12 | Package
Item13 | Kgs
Item14 | Kgs
Item15 | Package | 4
Item16 | Kgs
Item17 | Package | 4
Item18 | Kgs
Item19 | Kgs | 3
Item20 | Package | 2
Spreadsheet: 91230d1290987541-choose-the-data-from-column-a-on-condition-in-column-b-example
Sheet: Sheet1

CODE | Investment Style | Country | Pos - 888-LN 31-Dec-2009 | Pos - AAT-LN 31-Dec-2009 | Pos - ABF-LN 31-Dec-2009 | Pos - ACC-LN 31-Dec-2009
12-1 |  | Switzerland | 1
12-2 |  | Austria | 2
12-3 |  | [NAME] | 3 |  |  | 456
13-1 | Core Value | Netherlands
13-2 | Core Value | United States |  | 546
13-3 |  | Japan
14-1 | Core Growth | Denmark |  |  | 15740
14-2 | Core Growth | Japan
14-3 | GARP | Jersey | 546 |  |  | 21
15-1 |  | Luxembourg
15-2 |  | Switzerland |  |  | 176626
15-3 | Growth | Luxembourg |  |  |  | 213
16-1 |  | Switzerland
16-2 | GARP | Denmark
16-3 | GARP | United Kingdom
17-1 | Core Value | Switzerland |  | 5423 |  | 133330
17-2 | Core Value | Switzerland | 65323
17-3 | Core Growth | Switzerland |  | 21
 |  | TOP1_CODE
 |  | TOP2_CODE
 |  | TOP3_CODE
Spreadsheet: 218804d1362585279-football-league-table-database
Sheet: Sumário - Tabela 3

Database
Liga Inglesa
 | Tabela classificativa
 |  | # | Equipa | P | J | V | E | D | GMT | GST | [NAME] | VC | EC | DC | GMC | GSC | JF | VF | EF | DF | GMF | GSF
 |  | 1 | Man United | 68 | 27 | 22 | 2 | 3 | 64 | 31 | 13 | 12 | 0 | 1 | 34 | 16 | 14 | 10 | 2 | 2 | 30 | 15
 |  | 2 | Man City | 0 | 0
 |  | 3 | [NAME] | 0 | 0
 |  | 4 | Chelsea | 0 | 0
 |  | 5 | Arsenal | 0 | 0
 |  | 6 | Everton | 0 | 0
 |  | 7 | Newcastle | 0 | 0
 |  | 8 | QPR | 0 | 0
 |  | 9 | [NAME] | 0 | 0
 |  | 10 | Liverpool | 0 | 0
 |  | 11 | [NAME] | 0 | 0
 |  | 12 | Stoke City | 0 | 0
 |  | 13 | West Ham | 0 | 0
 |  | 14 | Sunderland | 0 | 0
 |  | 15 | Southampton | 0 | 0
 |  | 16 | Swansea | 0 | 0
 |  | 17 | Reading | 0 | 0
 |  | 18 | Fulham | 0 | 0
 |  | 19 | [NAME] | 0 | 0
 |  | 20 | West Brom | 0 | 0
Spreadsheet: mark_haedicke__24623__SUMMARY
Sheet: summary

MARINER ENERGY, INC.
APPENDIX
WEEKLY DRILLING AND COMPLETION SUMMARY
 |  |  |  |  |  |  |  |  |  |  |  |  | PRESENT |  | PROPOSED
 |  |  | PROSPECT |  | AREA |  | WELL |  | E/D |  | [NAME] |  | DEPTH |  | TD |  | COMMENT
 | I. |  | WELLS CURRENTLY DRILLING
 |  |  | [NAME] |  | Onshore, Tx |  | B-1 ST #2 |  | E |  | 0.4 |  | 10,680' |  | 10,720' |  | Completion made water.  Unloading well
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | after water isolation treatment.
 |  |  | Mississippi Canyon 561 |  | Deepwater |  | OCS-G #1 |  | E |  | 0.167 |  | 8,953' |  | 6,901' |  | Repairing BOPs.
 |  |  | (Hells Canyon)
 | II. |  | WELLS REACHING TOTAL DEPTH, TESTING, OR TURNED TO SALES THIS WEEK
 |  |  | None to report.
 | III. |  | WELLS ANTICIPATED TO SPUD WITHIN 90 DAYS
 |  |  | Mississippi Canyon 322 |  | Deepwater |  | OCS-G 19936 #1 |  | E |  | 0.4 |  |  |  |  |  | Antiicpate June 1, 2001 spud.
 |  |  | ([NAME])
 |  |  | Green Canyon 516 |  | Deepwater |  | OCS-G # 1 |  | E |  | 0.44 |  |  |  |  |  | Anticipate May 28, 2001 spud.
 |  |  | (Yosemite)
 |  |  | Green Canyon 472 |  | Deepwater |  | OCS-G #2 |  | D |  | 0.5 |  |  |  |  |  | Anticipate May 21, 2001 spud.
 |  |  | (King Kong)
 | IV. |  | OTHER
 |  |  | None to report.
Spreadsheet: 850017d1700403978-cant-get-byrow-and-xlookup-to-work-together-byrowxlookup
Sheet: Sheet1

 |  |  |  | Doing it without array (first row only) |  |  | If using array, but not byrow, it just spills the first column |  | trying with [NAME] |  | EXPECTED RESULTS
1 | a |  | b |  | b |  |  |  |  |  | 2 | b
2 | b |  | c |  |  |  | 3 |  |  |  | 3 | c
3 | c |  | e |  |  |  | 5 |  |  |  | 5 | e
4 | d
5 | e
Spreadsheet: 87948d1287817297-syncing-sorting-identical-columns-in-2-or-more-tables-sort-table-1
Sheet: Sheet1

No | Type | Description |  | No | Type | Description
4 | Dog | Row of Dog Data |  | 1
3 | Cup | Row of Cup Data |  | 2
2 | [NAME] | Row of Bat Data |  | 3
1 | Ant | Row of Ant Data |  | 4
Spreadsheet: 808196d1670344273-need-formula-to-calculate-sum-of-times-early-and-late-attendance-akshaya
Sheet: Sheet1

 | Months |  |  | Duty |  | Staff Names |  | Duty Details
 | 1 | January |  | Duty |  | XXXX |  | Time In | 10:00:00
 | 2 | February |  | Absent |  | [NAME] |  | Time Out | 18:00:00
 | 3 | March |  | Sick |  | ZZZZ |  | Total
 | 4 | April |  | Week Off
 | 5 | May |  | Holiday
 | 6 | June |  | Casual Leave
 | 7 | July |  | Half Day
 | 8 | August |  | Pending OFF |  |  |  | Title
 | 9 | September |  |  |  |  |  | Company Title
 | 10 | October |  |  |  |  |  | Address
 | 11 | November |  |  |  |  |  | Contact &  Details
 | 12 | December
Spreadsheet: 118860d1314058480-changing-colors-on-columns-and-showing-expired-when-0-is-reached-ddc4exm
Sheet: Sheet1

LAST NAME | FIRST NAME | WEST COAST | MWS | EAST COAST | INSTRUCTOR | DATE COMPLETED | EXPIRES | DAYS TO RENEW
RAMIREZ | SAM | X |  |  | ORR | 2010-12-02 00:00:00
NEAL | BOB |  | X |  | JR | 2008-08-23 00:00:00
BLOW | JOE | X |  |  | ORR | 2010-01-23 00:00:00
Spreadsheet: a2b394b2-b62b-4359-920c-be1c88f23c02
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259849 | 77970 | Monika | Dorfner | AUT | 230 | 00:17:49 | 00:01:17 | 01:10:48 | 00:00:58 | 00:29:46 | 1 | 02:00:40
259849 | 77971 | Christina | Herbst | AUT | 229 | [NAME] | [NAME] | 01:14:35 | 00:01:09 | [NAME] | 2 | 02:09:04
259849 | 58946 | [NAME] | Smith | GBR | 227 | 00:21:59 | 00:01:25 | 01:26:15 | 00:01:10 | 00:32:14 | 3 | 02:23:05
259849 | 77972 | Renate | Nesensohn | AUT | 228 | [NAME] | 00:02:42 | 01:37:44 | 00:01:38 | 00:45:42 | 4 | 02:55:39
Spreadsheet: kimberly_watson__20596__RedRockAdmCtrc27698
Sheet: Sheet1

Red Rock Adm Ctrc 27698
 |  | West Texas Pool | Panhandle Pool | Central Pool | EPFS/Eddy RP
 |  | (Incl. West TX Pool & | (Incl. Panhandle Pool & | (Incl. Agave/Eddy RP) | ([NAME]. EPFS/Eddy &
 |  | Oneok/Pecos RP) | "Balance") |  | NGPL/Eddy RP's)
START | END | POI 58646 | POI 58647 | POI 58649 | POI 78093 | TOTAL
2002-06-01 00:00:00 | 2002-06-30 00:00:00 | 26699 | 99035 | 15000 | 9266
2002-07-01 00:00:00 | 2003-05-31 00:00:00 | 50228 | 75506 | 15000 | 9266
2003-06-01 00:00:00 | 2004-03-31 00:00:00 | 51523 | 77506 | 15000 | 5971
2004-04-01 00:00:00 | 5/31/2017 | 46523 | 82506 | 15000 | 5971
2017-06-01 00:00:00 | 2017-06-30 00:00:00 | 43823 | 85206 | 15000 | 5971
2017-07-01 00:00:00 | 2999-12-31 00:00:00 | 20294 | 108735 | 15000 | 5971
Spreadsheet: 1b4792f9-ea2c-4c55-b757-fc1f93a151cc
Sheet: Sheet1

Tournament Name |  |  | Players and Substitutes
Disciplinary Report |  |  | Cautions |  | Code | Code | Send Offs
 |  |  | Unsporting behavior |  | Y1 | R1 | Serious Foul play
Tourney Date |  |  | Dissent |  | Y2 | R2 | Violent conduct
Tournament Director |  |  | Persistent infringement |  | Y3 | R3 | Spitting at another person
Disciplinary Chair |  |  | Delaying restart of play |  | Y4 | R4 | Denying goal by handling ball
 |  |  | Failing to respect required distance |  | Y5 | R5 | Denying goal by other unlawful means
 |  |  | Entering/re-entering field without permission |  | Y6 | R6 | Offensive, insulting or abusive language
 |  |  | Leaving field w/o permission |  | Y7 | R7 | Second caution
 |  |  | Coaches, Team Officials and Spectators
 |  |  | Warning |  | Code | Code | Expulsion
 |  |  | Behavior at risk of being considered irresponsible |  | W | E | Irresponsible behavior
Last Name | First Name | # | Team | Age Grp | Code /Offense | Date Issued | Result/suspension | Games Remaining
Spreadsheet: 54127d1254153782-excel-2007-no-selection-on-vlookup-on-range-lookup-true-case07_alslezak_2
Sheet: January Sales

NewLeaf Paper
Notebook Sales for January
Date of Sale | Book ID | Units Sold | Unit Price | Gross Sales | Shipping | In State | S&H | Packing | Description | Category
2010-01-04 00:00:00 | 1216-12 | 6 |  |  | S | N
2010-01-04 00:00:00 | 1236-12 | 14 |  |  | P | Y
2010-01-04 00:00:00 | 1214-11 | 19 |  |  | S | N
2010-01-04 00:00:00 | 1271-11 | 26 |  |  | S | Y
2010-01-05 00:00:00 | 1211-12 | 8 |  |  | S | N
2010-01-06 00:00:00 | 1211-21 | 19 |  |  | P | N
2010-01-06 00:00:00 | 1216-11 | 34 |  |  | S | Y
2010-01-07 00:00:00 | 1251-12 | 20 |  |  | P | N
2010-01-08 00:00:00 | 1234-12 | 29 |  |  | S | N
2010-01-08 00:00:00 | 1274-11 | 27 |  |  | S | N
2010-01-11 00:00:00 | 1234-13 | 12 |  |  | P | Y
2010-01-11 00:00:00 | 1254-11 | 19 |  |  | P | N
2010-01-12 00:00:00 | 1256-11 | 9 |  |  | S | Y
2010-01-12 00:00:00 | 1274-24 | 22 |  |  | P | N
2010-01-12 00:00:00 | 1271-24 | 13 |  |  | S | N
2010-01-13 00:00:00 | 1216-11 | 16 |  |  | S | N
2010-01-13 00:00:00 | 1211-21 | 9 |  |  | P | Y
2010-01-14 00:00:00 | 1211-11 | 12 |  |  | S | N
2010-01-14 00:00:00 | 1254-12 | 20 |  |  | S | N
2010-01-15 00:00:00 | 1211-22 | 19 |  |  | P | Y
2010-01-15 00:00:00 | 1214-11 | 13 |  |  | S | Y
2010-01-15 00:00:00 | 1236-12 | 24 |  |  | P | N
2010-01-18 00:00:00 | 1256-11 | 18 |  |  | P | Y
2010-01-18 00:00:00 | 1234-11 | 13 |  |  | S | N
2010-01-18 00:00:00 | 1254-11 | 25 |  |  | P | Y
2010-01-19 00:00:00 | 1274-11 | 14 |  |  | S | N |  |  |  |  |  |  |  |  | 9E4cc43h8351eee352
2010-01-19 00:00:00 | 1276-12 | 29 |  |  | P | N |  |  |  |  |  |  |  |  | yj!qjcxyi
2010-01-20 00:00:00 | 1274-24 | 9 |  |  | S | Y
2010-01-20 00:00:00 | 1211-12 | 12 |  |  | S | N
2010-01-21 00:00:00 | 1251-12 | 18 |  |  | S | N
2010-01-22 00:00:00 | 1271-11 | 12 |  |  | P | N
2010-01-22 00:00:00 | 1231-12 | 24 |  |  | S | Y
2010-01-25 00:00:00 | 1216-11 | 17 |  |  | P | N
2010-01-25 00:00:00 | 1234-13 | 25 |  |  | S | N
2010-01-25 00:00:00 | 1234-12 | 8 |  |  | S | Y
2010-01-26 00:00:00 | 1276-11 | 18 |  |  | P | N
2010-01-26 00:00:00 | 1274-12 | 15 |  |  | S | Y
2010-01-26 00:00:00 | 1231-11 | 9 |  |  | S | N
2010-01-27 00:00:00 | 1211-23 | 17 |  |  | P | Y
2010-01-27 00:00:00 | 1271-12 | 19 |  |  | S | N
2010-01-28 00:00:00 | 1216-11 | 22 |  |  | P | Y
2010-01-28 00:00:00 | 1214-12 | 25 |  |  | P | N
2010-01-29 00:00:00 | 1274-23 | 16 |  |  | S | N
2010-01-29 00:00:00 | 1251-11 | 25 |  |  | P | Y
2010-01-29 00:00:00 | 1271-23 | 12 |  |  | S | N
2010-01-29 00:00:00 | 1231-12 | 18 |  |  | S | Y
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Al Slezak
Spreadsheet: 34107d1231238709-charts-line-chart-how-to-show-data-ranges-667417
Sheet: Sheet1

 | Weight |  | Start | Finish
2009-01-01 00:00:00 | 100 | Red | 120 | 120
2009-01-02 00:00:00 | 98 | Amber | 85 | 85
2009-01-03 00:00:00 | 97 | Green | 65 | 65
2009-01-04 00:00:00 | 97 | Background | 55 | 55
2009-01-05 00:00:00 | 96
2009-01-06 00:00:00
2009-01-07 00:00:00
2009-01-08 00:00:00
2009-01-09 00:00:00
2009-01-10 00:00:00
2009-01-11 00:00:00
2009-01-12 00:00:00
2009-01-13 00:00:00
2009-01-14 00:00:00
2009-01-15 00:00:00
2009-01-16 00:00:00
2009-01-17 00:00:00
2009-01-18 00:00:00
2009-01-19 00:00:00
2009-01-20 00:00:00
2009-01-21 00:00:00
2009-01-22 00:00:00
2009-01-23 00:00:00
2009-01-24 00:00:00
2009-01-25 00:00:00
2009-01-26 00:00:00 |  |  | Start with a Line chart based on A1:B6
2009-01-27 00:00:00 |  |  | Use Source Data dialog to add 4 new series
2009-01-28 00:00:00 |  |  | based on D2:E2  D3:E3 etc
2009-01-29 00:00:00 |  |  | Move these new series to secondary axis
2009-01-30 00:00:00 |  |  | Change chart type to area
2009-01-31 00:00:00 |  |  | Chart Options to Add secondary X axis
 |  |  | Format secondary x axis to have no tickmarks or labels. Not crossing between categorys
 |  |  | [NAME] Y axis to have [NAME] of 120 and uncheck crosses at Maximum. No labels or tickmarks
 |  |  | Format areas to correct colours
 |  |  | Finally extend Weight series to include all dates.
Spreadsheet: 70569d1271290407-vlookup-if-or-something-better-example
Sheet: data

Drink | Water (mL) | Sugar (g) | [NAME] (unit) | Lemons (unit)
Water | 4000 | 0 | 0 | 0
Iced Tea | 3000 | 30 | 7 | 0
Lemonade | 3500 | 40 | 0 | 10
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: Fundies-All

 | Fundamentals
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002 |  |  |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total |  |  |  |  | 24109311.02937501
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000 | 1
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500 | 6
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Associate | 89100 | 4
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 4
 |  |  |  |  |  |  |  | Director | 143000 | 1
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 1
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2 |  |  |  |  | 1
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 158291d1338149261-split-data-from-report-into-separate-areas-demo-worksheet
Sheet: report

product code | product | units sold | £
12345 | jumper a | 3 | 30
45678 | handbag c | 6 | 60
54321 | trousers b | 2 | 20
76543 | boots d | 5 | 50
Spreadsheet: 821851d1678943008-vstack-results-of-indirect-references-from-an-array-indirect_example_1
Sheet: data1

 |  | [NAME] | amount | account
Spreadsheet: 105766d1303048254-using-controls-or-index-i-think-help-please-style-question
Sheet: Style Analysis

DHsmall | Select Fund
Ticker | $ Holdings | Rank | % Growth | Sector
Spreadsheet: 851580d1701790596-predict-the-score-game-predict-the-score
Sheet: Table

 | Position |  | Played | Won | Points
 | 1 | [NAME] | 1 | 2 | 10
 | 2 | [NAME] | 1 | 1 | 8
 | 3 | [NAME] | 1 |  | 6
 | 3 | [NAME] | 1 |  | 6
 | 4 | [NAME] | 1 |  | 5
 | 5 | [NAME] | 1 | 1 | 4
 | 5 | [NAME] | 1 |  | 4
 | 5 | Jordan | 1 |  | 4
Spreadsheet: 703836d1605191646-populating-a-weekly-schedule-based-on-criterias-with-formula-covidscheduleoffice
Sheet: Sheet1

 |  |  |  |  |  |  |  | X |  |  | X |  | X |  | X | X |  | X
 |  |  |  |  |  |  | X |  | X | X |  | X |  | X |  |  | X |  | X | X
 |  |  |  |  |  |  | X |  | X | X |  | X |  | X |  |  | X |  | X | X
 |  |  | A: Custom (added manually, so empty) |  |  |  |  | X |  |  | X |  | X |  | X | X |  | X
 |  |  | B: Mondays and Wednesdays, every second friday on even week numbers. |  |  |  | X | X | X | X |  |  |  |  |  | X | X | X | X | X
 |  |  | C: Tuesdays and Thursdays, every second friday on odd week numbers.
 |  |  | D: One week at the office (full week), next week at home. |  |  | week 1 |  |  |  |  | week 2 |  |  |  |  | week 3
 |  |  |  |  | Schedule option | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday | Monday | Tuesday | Wednesday | Thursday | Friday
 |  |  |  | Person 1 | B |  |  | X |  |  | X |  | X |  | X | X |  | X
 |  |  |  | Person 2 | C |  | X |  | X | X |  | X |  | X |  |  | X |  | X | X
 |  |  |  | Person 3 | C |  | X |  | X | X |  | X |  | X |  |  | X |  | X | X
 |  |  |  | Person 4 | B | X |  | X |  |  | X |  | X |  | X | X |  | X
 |  |  |  | Person 5 | D | X | X | X | X | X |  |  |  |  |  | X | X | X | X | X
 |  |  |  | Person 6 | A
 |  |  |  |  |  | Grey field filled in with X based on F (Schedule option) and even/odd week number.
 |  |  |  |  |  | Extra: to lock cells that shouldn't be able to be filled in (not necessary)
 |  |  |  |  |  | X |  | X |  |  | X |  | X |  | X | X |  | X
 |  |  |  |  |  |  | X |  | X | X |  | X |  | X |  |  | X |  | X | X
 |  |  |  |  |  |  | X |  | X | X |  | X |  | X |  |  | X |  | X | X
 |  |  |  |  |  | X |  | X |  |  | X |  | X |  | X | X |  | X
 |  |  |  |  |  | X | X | X | X | X |  |  |  |  |  | X | X | X | X | X
Spreadsheet: 775496d1649151783-how-to-search-textstrings-for-mentions-match-mentions-and-get-variable-values-for-matches-registry-of-interest-check
Sheet: Registration

Full name | Interest1 | Interest2 | Interest3 | Competence1 | Competence2 | Competence3 | Match1 | Match2 | Match3 | Decision | Forename | Surname | Interests | I1 | I2 | I3 | C1 | C2 | [NAME] | M1 | M2 | M3 | D1
 |  |  |  |  |  |  |  |  |  |  | Anders | [NAME] | Edu1, Edu2
 |  |  |  |  |  |  |  |  |  |  | Niklas | Persson | Edu2, Edu3
 |  |  |  |  |  |  |  |  |  |  | Jeanette | Videborn | Edu1, Edu3
 |  |  |  |  |  |  |  |  |  |  | Anne | [NAME] | Edu1
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Nilsson | Edu3
 |  |  |  |  |  |  |  |  |  |  | [NAME] | Sjöberg | edu1, edu3, edu2
Spreadsheet: mary_fischer__25632__31N
Sheet: E16.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031N
COMPANY NAME    EFS C&S
ANALYSIS OF (GAIN) LOSS ON SALES OF ASSETS
FOR THE 3 MONTHS ENDED 3-31-2001
**LIST ALL PROPERTY SALES INCLUDING SALES OF REGULATORY ASSETS
**REGULATED COMPANIES DO NOT SHOW (GAIN)/LOSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  | (A) | + | (B) | + | (C) |  |  | + | (D) | + | (E) | + | (F) | + | (G) |  |  | =
 |  |  |  | GROSS SALE PROCEEDS |  |  |  | NET BOOK VALUE |  |  |  |  |  |  |  |  |  | OTHER (EXPLAIN) |  |  |  | (GAIN) LOSS
 |  | DATE |  |  |  | N/R OR OTHER |  | ASSET |  |  |  |  |  | ACCUM |  | EXP ASSOC |  | AMOUNT |  | HYPERION |  | DR / (CR)
[NAME] OF ASSET |  | OF SALE |  | CASH | + | (EXPLAIN BELOW) | + | AMOUNT |  | HYPERION ACCT | + | PP&E | + | [NAME] | + | WITH SALE | + | DR (CR) |  | ACCT | = | ENDING BAL |  | COMMENTS
PROCEEDS OR BOOK VALUE OF ASSETS
OF $1,000,000 OR MORE:
SALES OF PP&E
SALES OF OTHER ASSETS
 |  |  |  |  |  | (B)
OTHER (LESS THAN $1,000,000) :
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ACCT 1676
 |  | EXPLAIN: |  |  |  |  |  |  |  |  |  |  |  |  | Hyperion Income Accts :  DR/(CR)
 |  | Notes Receivable |  |  |  |  |  |  |  |  |  |  |  |  |  | Signs are reversed from Hyperion
 |  | (list amounts and terms):
 |  | Other:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  |  |  | (B)