tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 805157d1668552716-ref-error-example
Sheet: Updated Forecast

 |  |  | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder | Place holder
1.25 | 1.75 | Place holder | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 2022-01-07 00:00:00 | 2022-01-08 00:00:00 | 2022-01-09 00:00:00 | 2022-01-10 00:00:00 | 2022-01-11 00:00:00 | 2022-01-12 00:00:00 | 2022-01-13 00:00:00 | 2022-01-14 00:00:00 | 2022-01-15 00:00:00 | 2022-01-16 00:00:00 | 2022-01-17 00:00:00 | 2022-01-24 00:00:00 | 2022-01-31 00:00:00 | 2022-02-07 00:00:00 | 2022-02-14 00:00:00 | 2022-02-21 00:00:00 | 2022-02-28 00:00:00 | 2022-03-07 00:00:00 | 2022-03-14 00:00:00 | 2022-03-21 00:00:00 | 2022-03-28 00:00:00 | 2022-04-04 00:00:00 | 2022-04-11 00:00:00 | 2022-04-18 00:00:00 | 2022-04-25 00:00:00 | 2022-05-02 00:00:00 | 2022-05-09 00:00:00 | 2022-05-16 00:00:00 | 2022-05-23 00:00:00
Part 1 | 10 | Place holder | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
Part 2 | 20 | Place holder | 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
Part 3 | 15 | Place holder
Part 4 | 40 | Place holder | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF!
Part 5 | 25 | Place holder | 200 | 200 | 200 | 200 | 50 | 50 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 50 | 50 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
Part 6 | 35 | Place holder | 10 | 20 | 10 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 0 | 0 | 20 | 2 | 10 | 5
Spreadsheet: 131874d1323362716-nested-if-or-and-matched-indexed-statements-copy-of-2012_eu22-jv-version-1
Sheet: Ams, Ber, Pra, Vie, Ven

Rooming allocation for Amsterdam, Berlin, Prague, Vienna, Venice
Type | # of Rms
Singles
Twins
Triples
Quads
5 bed
6 bed
Total Pax
fs | ms | Single | Twin |  | Triple |  | Quad |  | 5 |  | 6
[NAME] | [NAME] | Single | Twin |  | Triple |  | Quad |  | 5 bed |  | 6 bed
Spreadsheet: 782709d1654190408-sumproduct-with-multiple-criteria-sumproduct-with-multiple-criteria
Sheet: Sheet1

 |  |  |  |  |  | Correct Values
JOB | Welding | Painting | Operation 101-108 | Operation 202&203 |  | Welding | Painting | Operation 101-108 | Operation 202&203
H111A1 |  |  | 3.724 | 2.842 |  | 1.779 | 5.266 | 3.724 | 2.842
H222B1 |  |  | 0.839 | 9.338 |  | 5.484 |  | 0.839 | 9.338
H333A1 |  |  |  | 2.487 |  | 0.1 | 0.573 |  | 2.487
 |  |  |  |  |  | Date | Operation | Job | Operation2 | MT
 |  |  |  |  |  | 2022-06-01 00:00:00 | Welding | H111A1 | 101 | 0.583
 |  |  |  |  |  | 2022-06-01 00:00:00 | Welding | H111A1 | 102 | 0.764
 |  |  |  |  |  | 2022-06-01 00:00:00 | Welding | H111A1 | 201 | 0.432
 |  |  |  |  |  | 2022-06-01 00:00:00 | Fabrication | H111A1 | 202 | 2.842
 |  |  |  |  |  | 2022-06-01 00:00:00 | Welding | H222B1 | 202 | 4.645
 |  |  |  |  |  | 2022-06-01 00:00:00 | Clearing | H222B1 | 202 | 4.693
 |  |  |  |  |  | 2022-06-01 00:00:00 | Welding | H222B1 | 101 | 0.839
 |  |  |  |  |  | 2022-06-01 00:00:00 | Welding | H333A1 | 202 | 0.1
 |  |  |  |  |  | 2022-06-01 00:00:00 | Shearing | H333A1 | 203 | 2.387
 |  |  |  |  |  | 2022-06-01 00:00:00 | Painting | H111A1 | 205 | 2.889
 |  |  |  |  |  | 2022-06-01 00:00:00 | Painting | H111A1 | 104 | 2.377
 |  |  |  |  |  | 2022-06-01 00:00:00 | Punching | H333A1 | 109 | 0.067
 |  |  |  |  |  | 2022-06-01 00:00:00 | Painting | H333A1 | 111 | 0.127
 |  |  |  |  |  | 2022-06-01 00:00:00 | Painting | H333A1 | 120 | 0.446
Spreadsheet: 93839d1293623269-charts-data-from-different-sheets-example
Sheet: All in one sheet

Date | $ |  |  | Average
2010-10-06 00:00:00 | 3.86 |  | Total
2010-10-07 00:00:00 | 3.96 |  | October
2010-10-08 00:00:00 | 4.14 |  | November
2010-10-09 00:00:00 | 4.22 |  | December
2010-10-10 00:00:00 | 4.3
2010-10-11 00:00:00 | 4.46
2010-10-12 00:00:00 | 4.55
2010-10-13 00:00:00 | 4.68
2010-10-14 00:00:00 | 4.82
2010-10-15 00:00:00 | 4.9
2010-10-16 00:00:00 | 5.03
2010-10-17 00:00:00 | 5.11
2010-10-18 00:00:00 | 5.2
2010-10-19 00:00:00 | 5.3
2010-10-20 00:00:00 | 5.4
2010-10-21 00:00:00 | 5.48
2010-10-22 00:00:00 | 5.56
2010-10-23 00:00:00 | 5.66
2010-10-24 00:00:00 | 5.79
2010-10-25 00:00:00 | 5.88
2010-10-26 00:00:00 | 5.95
2010-10-27 00:00:00 | 6.08
2010-10-28 00:00:00 | 6.21
2010-10-29 00:00:00 | 6.33
2010-10-30 00:00:00 | 6.49
2010-10-31 00:00:00 | 6.64
2010-11-01 00:00:00 | 6.77
2010-11-02 00:00:00 | 6.86
2010-11-03 00:00:00 | 6.95
2010-11-04 00:00:00 | 7.08
2010-11-05 00:00:00 | 7.25
2010-11-06 00:00:00 | 7.35
2010-11-07 00:00:00 | 7.5
2010-11-08 00:00:00 | 7.66
2010-11-09 00:00:00 | 7.81
2010-11-10 00:00:00 | 7.9
2010-11-11 00:00:00 | 7.99
2010-11-12 00:00:00 | 8.1
2010-11-13 00:00:00 | 8.22
2010-11-14 00:00:00 | 8.33
2010-11-15 00:00:00 | 8.43
2010-11-16 00:00:00 | 8.56
2010-11-17 00:00:00 | 8.67
2010-11-18 00:00:00 | 8.75
2010-11-19 00:00:00 | 8.89
2010-11-20 00:00:00 | 9.03
2010-11-21 00:00:00 | 9.14
2010-11-22 00:00:00 | 9.24
2010-11-23 00:00:00 | 9.35
2010-11-24 00:00:00 | 9.49
2010-11-25 00:00:00 | 9.66
2010-11-26 00:00:00 | 9.78
2010-11-27 00:00:00 | 9.95
2010-11-28 00:00:00 | 10.1
2010-11-29 00:00:00 | 10.27
2010-11-30 00:00:00 | 10.49
2010-12-01 00:00:00 | 10.65
2010-12-02 00:00:00 | 10.82
2010-12-03 00:00:00 | 10.98
2010-12-04 00:00:00 | 11.1
2010-12-05 00:00:00 | 11.3
2010-12-06 00:00:00 | 11.42
2010-12-07 00:00:00 | 11.67
2010-12-08 00:00:00 | 11.9
2010-12-09 00:00:00 | 11.99
2010-12-10 00:00:00 | 12.16
2010-12-11 00:00:00 | 12.38
2010-12-12 00:00:00 | 12.46
2010-12-13 00:00:00 | 12.66
2010-12-14 00:00:00 | 12.85
2010-12-15 00:00:00 | 13.06
2010-12-16 00:00:00 | 13.32
2010-12-17 00:00:00 | 13.46
2010-12-18 00:00:00 | 13.75
2010-12-19 00:00:00 | 13.93
2010-12-20 00:00:00 | 14.2
2010-12-21 00:00:00 | 14.42
2010-12-22 00:00:00 | 14.59
2010-12-23 00:00:00 | 14.8
2010-12-24 00:00:00 | 15.04
2010-12-25 00:00:00 | 15.36
2010-12-26 00:00:00 | 15.65
2010-12-27 00:00:00 | 15.81
2010-12-28 00:00:00 | 16
2010-12-29 00:00:00 | 16.14
2010-12-30 00:00:00 | 16.3
2010-12-31 00:00:00 | 16.45
Spreadsheet: 483041d1475449858-creating-a-random-group-selecter-with-criteria-book3
Sheet: Sheet1

ID | Group A | Group B | Random # A | Random # B | Group A Rank | Group B Rank | A Pick | B Pick
1 | [NAME] | [NAME]
2 | [NAME] | [NAME]
3 | [NAME] | [NAME]
4 | Al | [NAME]
5 | [NAME] | [NAME]
6 | [NAME] | Ramon
7 | [NAME] | Morgan
8 | Mark | [NAME]
9 | Sue | Kelly
Spreadsheet: 86277d1286294682-formula-to-concatenate-rows-concatenaterows
Sheet: Sheet2

Name | Points | There should be nothing in this row >
[NAME] | 12 |  | 12,
[NAME] | 18 |  | 18,12,
[NAME] | 25 |  |  | 25,18,12
[NAME] | 11 |  | 11,
[NAME] | 35 |  |  | 35,11
[NAME] | 19 |  |  | 19
[NAME] | 12 |  |  | 12
Spreadsheet: 709135d1608183328-return-1st-column-value-based-combination-lookup-in-2rd-column-book2
Sheet: Sheet1 (2)

 |  |  |  | Selections | z1 |  | Result
 |  |  |  |  | z3
id | value
a | z1
a | z2
a | z3
b | z4
b | z3
c | z1
c | z3
c | z4
d | z5
d | z3
d | z4
d | z6
d | z2 |  | selection(by column D and E |  |  | result
 |  |  | z1 | z3 |  | a | c |  | meet criteria z1 and z3
 |  |  | z3 | z4 |  | b | c | d | meet criteria z3 and z4
 |  |  | z5 | z6 |  | d |  |  | meet criteria z5 and z6
Spreadsheet: 67930d1268422789-order-scenario-testavk
Sheet: result

from date | to date | REGISTERED ORDER AMT | apr-09 | may-09 | june-09 | july-09 | aug-09 | sept-09 | oct-09 | nov-09 | dec-09 | jan-10 | feb-10 | mar-10
2009-04-01 00:00:00 | 2009-04-30 00:00:00
2009-05-01 00:00:00 | 2009-05-31 00:00:00
2009-06-01 00:00:00 | 2009-06-30 00:00:00
2009-07-01 00:00:00 | 2009-07-31 00:00:00
2009-08-01 00:00:00 | 2009-08-31 00:00:00
2009-09-01 00:00:00 | 2009-09-30 00:00:00
2009-10-01 00:00:00 | 2009-10-31 00:00:00
2009-11-01 00:00:00 | 2009-11-30 00:00:00
2009-12-01 00:00:00 | 2009-12-31 00:00:00
2010-01-01 00:00:00 | 2010-01-31 00:00:00
2010-02-01 00:00:00 | 2010-02-28 00:00:00
2010-03-01 00:00:00 | 2010-03-31 00:00:00
record as per data sheet
requirement as per given below :-
column c= required total order registered in during period
column d= order amount execute during april-09 against only register order during april-09
column e= order amount execute during may-09 against only register order during april-09
column f= order amount execute during june-09 against only register order during april-09
column g= order amount execute during july-09 against only register order during april-09
column h= order amount execute during aug-09 against only register order during april-09
column i= order amount execute during sept-09 against only register order during april-09
column j= order amount execute during oct-09 against only register order during april-09
column k= order amount execute during nov-09 against only register order during april-09
column l= order amount execute during dec-09 against only register order during april-09
column m= order amount execute during jan-10 against only register order during april-09
column n= order amount execute during feb-10 against only register order during april-09
column o= order amount execute during mar-10 against only register order during april-09
Spreadsheet: 870667d1717143616-summing-issue-summing-issue-rs
Sheet: Sheet1

 | 1
 | 1
 | 3
 | 1
 | 2
 | 1
 | 2
 | 1
 | 3
Spreadsheet: 338ff75c-1d7b-40a1-bf10-1560d30a85cf
Sheet: Sheet1

Original Course Schedule Submission | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
School/Department: |  |  |  |  |  | Date: |  |  |  |  | Submitted by:
Semester/Year: |  |  |  |  |  | *The Classroom Type column should be left blank unless you need a lab, computer classroom or no
 |  |  |  |  |  | classroom. Please enter one of the following: Lab, Computer or None.
 |  |  |  |  |  |  | Start | End | [NAME] | Cross List | Instructor | Classroom Type* | Special Approvals
 | Sub | No | Sec | Course Title | Cred | Days | time | time | [NAME] | Course | ID or Full Name | Lab/Comp/None | (i.e. Instructor or Dept Chair Sign)
Spreadsheet: 154ee966-f09b-454b-b274-cd2b361b1bc2
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Special Markets Product Rec | 80688652722 | [NAME] | I'D Rather Have [NAME]: A 20 Song Treasury | 2006-03-14 | Compact Disc | [NAME] | 9.99 | Y | Available
Canaan | 80688768126 | The [NAME] | Nothin' But Good | 2008-08-12 | Compact Disc | [NAME] | 13.99 | Y | Available
Canaan | 80688769123 | [NAME] | I Just Wanted You To Know | 2008-08-12 | Compact Disc | [NAME] | 13.99 | Y | Available
Canaan | 80688775223 | Mike & Kelly Bowling | Faith To Believe | 2008-08-12 | Compact Disc | [NAME] | 13.99 | Y | Available
Special Markets Product Rec | 80688610524 | Inspirations | Southern Gospel Treasury: The Inspirations | 2000-12-18 | Compact Disc | [NAME] | 9.99 | Y | Available
Special Markets Product Rec | 80688610623 | Goodman Family | Southern Gospel Treasury: The Goodman Family | 2000-12-18 | Compact Disc | [NAME] | 9.99 | Y | Available
Curb Records | 715187781221 | Oak Ridge Boys | Old Time Gospel Favorites | 2001-01-16 | Compact Disc | [NAME] | 7.99 | Y | Available
Spreadsheet: 70373d1271157350-excel-2007-pivot-table-display-725140_phillb
Sheet: Sheet1

Unit | Actual Task | Completed |  | Key
377101 | B1 | 2009-04-23 00:00:00
377101 | AS1 | 2009-05-28 00:00:00
377101 | C2 | 2009-07-06 00:00:00
377101 | UAT | 2009-07-06 00:00:00
377101 | AS1 | 2009-08-12 00:00:00
377101 | [NAME] | 2009-08-23 00:00:00
377101 | B1 | 2009-09-18 00:00:00
377101 | AS1 | 2009-10-22 00:00:00
377101 | B2 | 2009-11-29 00:00:00
377101 | AS1 | 2010-01-05 00:00:00
377101 | B1 | 2010-02-11 00:00:00
377101 | AS1 | 2010-03-19 00:00:00
377102 | B1 | 2009-04-02 00:00:00
377102 | AS1 | 2009-05-10 00:00:00
377102 | [NAME] | 2009-05-17 00:00:00
377102 | B2 | 2009-06-23 00:00:00
377102 | AS1 | 2009-07-23 00:00:00
377102 | B1 | 2009-08-26 00:00:00
377102 | AS1 | 2009-10-07 00:00:00
377102 | UAT | 2009-11-13 00:00:00
377102 | C2 | 2009-11-14 00:00:00
377102 | AS1 | 2009-12-19 00:00:00
377102 | B1 | 2010-02-04 00:00:00
377102 | AS1 | 2010-03-14 00:00:00
Spreadsheet: sally_beck__35204__EGM_MgmtSum-Q4-1026
Sheet: Mgmt Summary

ENRON GLOBAL MARKETS
4TH QUARTER 2000 EARNINGS ESTIMATE
Results based on activity through October 26, 2000
 |  | Plan |  |  |  | Components of Earnings Before Tax |  |  |  |  |  |  |  |  |  | Variances from Plan
 |  |  |  |  |  | Actual | Deals | Forecast | Total | Operating | Capital | Direct | Allocated |  |  | Total | Operating | Capital | Direct | Allocated
Business Team |  | Margin | Expenses(1) | EBT |  | Margin | Identified | Margin | Margin | Expenses | Charge | Expenses | Expenses | Total |  | Margin | Expenses | Charge | Expenses | Expenses | Total
Liquids
Coal
Emissions
Weather
Global Risk Markets
Financial Trading
Transportation
Overview |  |  | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0
Office of the Chairman
Subtotal Commercial
LNG
Middle East
Puerto Rico
Subtotal LNG / ME / PR
Total Commercial
Group Support Cost |  | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0
Support Cost Allocated to Teams |  | 0 |  |  |  | 0 |  | 0 |  |  | 0 | 0 |  |  |  |  |  | 0 |  | 0
Other Interest Related Charges |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Capital Charge Offset |  | 0 |  |  |  | 0 | 0 | 0 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0
Global Markets EBIT
 |  |  |  |  |  | Other Expenses:
Interest Expense/(Income) |  | 0 |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Global Markets Pre-tax Income
 |  |  |  | MPR Change:
(1) Includes capital charge, direct, and allocated expenses
Spreadsheet: 157646d1337815951-excel-2007-combine-sumif-vlookup-with-concatenate-table
Sheet: Data

Brand | Type | Stock | Traffic for Stock | Comment for Stock | Repair | Trafic for Repair | Comment for Repair
Dell | Desktop | 2 |  | Service | 2 |  | Working
Dell | Netbook | 3 |  | Good | 1
HP | Netbook | 1 |  | Order More | 4 |  | New Hire
Apple | Air | 2 |  |  | 5
Apple | iPhone | 4 |  | Great | 3
Spreadsheet: 139212d1328129694-merging-2-tables-into-1-or-combining-into-a-single-pivot-table-or-both-mergetables
Sheet: Merged

WO Number | Start | Request | Item | Quantity | WO Status | MRP Status
37980001 | 2012-01-17 00:00:00 |  | [NAME] | 200 | 20
37980002 | 2012-01-17 00:00:00 |  | [NAME] | 75 | 20
37980003 | 2012-01-19 00:00:00 |  | BCA010000 | 90 | 45
37980004 | 2012-01-20 00:00:00 |  | DEF020100 | 125 | 30
37980005 | 2012-01-20 00:00:00 |  | DEF020100 | 150 | 30
37980006 | 2012-01-22 00:00:00 |  | BCA010000 | 300 | 45
37980007 | 2012-01-23 00:00:00 |  | [NAME] | 25 | 20
37980008 | 2012-01-24 00:00:00 |  | BCA010000 | 45 | 20
 | 2012-01-17 00:00:00 | 2012-01-22 00:00:00 | [NAME] | 200 |  | O
 | 2012-01-17 00:00:00 | 2012-01-22 00:00:00 | [NAME] | 75 |  | O
 | 2012-01-19 00:00:00 | 2012-01-24 00:00:00 | [NAME] | 90 |  | D
 | 2012-01-20 00:00:00 | 2012-01-25 00:00:00 | BCA010000 | 125 |  | D
 | 2012-01-20 00:00:00 | 2012-01-25 00:00:00 | BCA010000 | 150 |  | O
 | 2012-01-22 00:00:00 | 2012-01-27 00:00:00 | BCA010000 | 300 |  | O
 | 2012-01-23 00:00:00 | 2012-01-28 00:00:00 | DEF020100 | 25 |  | O
 | 2012-01-24 00:00:00 | 2012-01-29 00:00:00 | DEF020100 | 45 |  | O
Spreadsheet: mary_fischer__25616__34L
Sheet: E-6.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 034L
COMPANY NAME   Enron EES Acquisition
ANALYSIS OF PROPERTY, PLANT AND EQUIPMENT
FOR THE 3 MONTHS ENDED 06-30-2001
PREPARED BY: [NAME]
EXTENSION: 52580 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
 |  | 12-31-2000 Balance |  |  |  |  |  | CHARGED TO I/S
 |  | DR/(CR.) |  |  |  | SALES AND OTHER |  |  |  |  |  |  |  | DETAIL OF |  | ENDING
[NAME] |  | BEGINNING |  | ADDITIONS |  | RETIREMENTS |  | DEPR |  | DEPL |  | OTHER |  | OTHER CHANGES |  | BALANCE
 |  | BALANCE |  | DR/(CR) |  | DR/(CR) |  | 1415 |  | 1416 |  | (List Below-A) |  | (List Below-B) |  | DR/(CR)
Natural Gas Transmission
Electric Generation & Distribution
Construction In Process
O & G Properties
Other
Gross PP & E
Accumulated DD & A
Net PP & E |  |  | * |  | ** |  | ** |  |  |  |  |  |  |  |  |  | *
 |  |  |  |  | ** Pertains to amounts related to normal |  |  |  |  |  |  | (A) |  | (B) | * | [NAME] TO
 |  |  |  |  | operations.  Unusual amounts should be shown |  |  |  |  |  |  |  |  |  |  | HYPERION LINE
 |  |  |  |  | under "Other Changes" with appropriate explanations. |  |  |  |  |  |  |  |  |  |  | NET_TOT_PPE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Asset/Exp  DR/(CR)
 |  |  |  |  |  |  | DETAIL OF OTHER CHANGES     (B)
 |  |  |  |  |  |  |  |  |  |  |  | PP & E |  | ACCUM |  | NET
CHARGED TO OTHER I/S ACCTS     (A) |  |  |  |  |  |  | KEY: |  |  |  |  | DR/(CR) |  | DR/(CR) |  | DR/(CR)
[NAME] |  | HYP ACCT CHGD |  | DR/(CR) |  |  | (PROVIDE DETAIL OF INDIVIDUAL ITEMS
 |  |  |  |  |  |  | IN EXCESS OF $200,000.)
 |  |  |  |  |  |  | (1) Reclassification between property
 |  |  |  |  |  |  | accounts (should net to -0-)
 |  |  |  |  |  |  | (2) Intercompany transfer
 |  |  |  |  |  |  | (list companies):
 |  | TOTAL
 |  |  |  |  |  |  | (3) Acquisition (disposition)
 |  |  |  |  |  |  | of business
 |  |  |  |  |  |  | (4) Foreign currency
 |  |  |  |  |  |  | translation adjustment
 |  |  |  |  |  |  | (5) Lease impairments -
 |  |  |  |  |  |  | Oil & Gas
 |  |  |  |  |  |  | (6) Other (detail):
 |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
Spreadsheet: 175878d1345662354-how-to-define-an-array-given-row-and-column-numbers-2012-08-22-mrexcel2
Sheet: Blad1

Team | Players | Index
A | [NAME] | 6.1
A | [NAME] | 9.4
A | Hal | 13.8
A | Leo | 22.8
B | [NAME] | 7.2
B | Eli | 10.5
B | Ira | 14.9
B | [NAME] | 17.5
C | [NAME] | 8.3
C | Fred | 11.6
C | Greg | 12.4
C | [NAME] | 16
Spreadsheet: 93e2d9e1-793b-4c5b-a5fe-0ea0c25c171c
Sheet: Sheet1

Biological Importance of Protected Areas by Category | Unnamed: 1 | Unnamed: 2
 | Заповідники | Національні парки
Види | 3.5 | 3.666666666666667
[NAME] | 4.25 | 4.095238095238095
Ендемізм | 2.625 | 2.285714285714286
Ландшафтна функція | 4.625 | 4.428571428571429
Природне різноманіття | 4.375 | 4.428571428571429
Репрезентативність | 4.875 | 4.428571428571429
Ключові види | 4 | 3.952380952380953
[NAME] норми | 3.375 | 3.761904761904762
Зменшення площ екосистем | 4.875 | 3.952380952380953
Природні процеси | 4.375 | 4.333333333333333
Spreadsheet: 41647d1240214959-calculate-date-difference-book1
Sheet: Sheet1

A1 | 01-Apr-2009 |  |  | 2009-04-01 00:00:00
B1 | 02-Apr-2009 |  |  | 2009-04-02 00:00:00
C1 | 03-Apr-2009 |  |  | 2009-04-03 00:00:00
D1
E1 | 05-Apr-2009 |  |  | 2009-04-05 00:00:00
F1 | 06-Apr-2009 |  |  | 2009-04-06 00:00:00
 |  |  |  | 2009-04-08 00:00:00
 |  |  |  | 2009-04-11 00:00:00
Spreadsheet: phillip_m_love__30054__PowerRiskCalc Jan01 Sithe 1-30-01
Sheet: Gas Price

 | Delivery date | day type | MW | MWhrs | Market price | Expense |  | MMBtus |  |  | use for calc day | Gas Prices
 | 2001-01-01 00:00:00 | weekday | 400 |  |  |  |  | 22263 |  |  |  |  |  |  |  |  | Month end liquidations, use first gas number daily.
 | 2001-01-02 00:00:00 | weekday | 400 |  |  |  |  |  |  |  |  |  |  | Tomorrow use this price |  |  | Daily liquidations, use that day's price.
 | 2001-01-03 00:00:00 | weekday | 400 |  |  |  |  |  |  |  |  |  |  | Friday use this price
 | 2001-01-04 00:00:00 | weekend | 400
 | 2001-01-05 00:00:00 | weekend | 400
 | 2001-01-06 00:00:00 | weekend | 400
 | 2001-01-07 00:00:00 | weekend | 400
 | 2001-01-08 00:00:00 | weekend | 400
 | 2001-01-09 00:00:00 | weekend | 400
 | 2001-01-10 00:00:00 | weekend | 400
 | 2001-01-11 00:00:00 | weekend | 400
 | 2001-01-12 00:00:00 | weekend | 400
 | 2001-01-13 00:00:00 | weekend | 400
 | 2001-01-14 00:00:00 | weekday | 400
 | 2001-01-15 00:00:00 | weekday | 400
 | 2001-01-16 00:00:00 | weekday | 400
 | 2001-01-17 00:00:00 | weekday | 400
 | 2001-01-18 00:00:00 | weekday | 400
 | 2001-01-19 00:00:00 | weekend | 400
 | 2001-01-20 00:00:00 | weekend | 400
 | 2001-01-21 00:00:00 | weekday | 400
 | 2001-01-22 00:00:00 | weekday | 400
 | 2001-01-23 00:00:00 | weekday | 400
 | 2001-01-24 00:00:00 | weekday | 400
 | 2001-01-25 00:00:00 | weekday | 400
 | 2001-01-26 00:00:00 | weekend | 400
 | 2001-01-27 00:00:00 | weekend | 400
 | 2001-01-28 00:00:00 | weekend | 400
 | 2001-01-29 00:00:00 | weekday | 400
 | 2001-01-30 00:00:00 | weekday | 400
 | 2001-01-31 00:00:00 | weekend | 400
 |  |  | [NAME] - you can make this a tab in the asian spreadsheet and reference the yellow cells to the asian model
Spreadsheet: 833452d1686977700-need-a-formula-that-returns-entire-table-sample36
Sheet: Sheet1

 |  |  |  |  |  |  |  | Return Table1 here …
 |  |  |  | Date | Employee | Amount
 |  |  |  | 2023-06-01 00:00:00 | Employee1 | 595
 |  |  |  | 2023-06-05 00:00:00 | Employee2 | 575
 |  |  |  | 2023-06-07 00:00:00 | Employee3 | 650
 |  |  |  | 2023-06-09 00:00:00 | Employee1 | 710
 |  |  |  | 2023-06-11 00:00:00 | Employee3 | 820
 |  |  |  | 2023-06-15 00:00:00 | Employee1 | 995
Spreadsheet: 484566d1476330027-sumproduct-with-other-sheets-and-criteria-sumproduct-with-criteria-bvj-v1
Sheet: Sheet1

 |  |  |  | Example 1
 |  |  |  |  | date chosen
 |  |  |  |  |  | Summary | M1 | M2 | M3 | M4 | M5 | M6 | M7 | M8 | M9 | M10 | M11 | M12
 |  |  |  |  |  |  |  | 3
 |  |  |  |  | A1 |  | 10 |  | 456 |  | 65423 |  |  | 45
 |  |  |  |  | A2 |  | 5 | 24 |  |  | 54564 | 56 |  | 5956 |  |  | 8
 |  |  |  |  | A3 |  | 2 |  |  |  |  | 3 |  | 6 | 2
 |  |  |  |  | A4 |  | 20 | 234 | 34234 | 4 | 5 |  | 5 |  |  |  | 56
 |  |  |  |  | A5 |  | 304 |  |  |  |  | 4 |  | 4 | 5
 |  |  |  |  | A6 |  | 405 |  |  | 53 |  | 4 |  | 5
 |  |  |  |  | A7 |  | 435 | 3243 |  |  |  | 678 |  |  | 867
 |  |  |  |  | A8 |  | 45 |  |  | 768 | 67 | 7
 |  |  |  |  | A9 |  |  |  |  |  | 234 |  |  | 7756454
 |  |  |  |  | A10 |  | 78 | 67 |  |  |  |  | 234 |  | 234
 |  |  |  |  | A11 |  | 67 |  |  | 34 |  |  |  | 234 |  | 435
 |  |  |  |  | A12 |  |  | 173 | 45 | 5856 |  | 738 |  | 358 | 56
 |  |  |  |  |  |  | pick first M#
 |  |  |  |  |  | choose last column | M1 | <------
 |  |  |  |  | Areas | M4
 |  |  |  |  | A1
 |  |  |  |  | A10
 |  |  |  |  | A8
 |  |  |  |  | A3
 |  |  |  |  | A6
 |  |  |  |  | A12
 |  |  |  |  | A5
 |  |  |  |  | A9
 |  |  |  |  | A7
 |  |  |  |  | A11
 |  |  |  |  | A4
 |  |  |  |  | A2
Spreadsheet: 756449d1637572309-order-two-columns-based-off-two-other-columns-order-test
Sheet: Sheet1

 | RAW DATA (UNORDERED) |  |  |  |  |  |  |  | ORDERED LIST
[NAME] | [NAME] | First Name | Last Name | [NAME] | [NAME] |  |  |  | First Name | Last Name
4656 | 645 | [NAME] | [NAME] | 2313 | 8493 |  |  |  | Felix | [NAME]
4656 | 645 | [NAME] | [NAME] | 46546 | 879 |  |  |  | [NAME] | Doe
5652 | 885 | [NAME] | Doe | 21329 | 8 |  |  |  | [NAME] | Brew
2123 | 2122 | [NAME] | Brew | 1365 | 12 |  |  |  | [NAME] | [NAME]
2131 | 5657 | Felix | [NAME] | 46887 | 62014 |  |  |  | [NAME] | [NAME]
 |  | DESIRED RESULTS
[NAME] | [NAME] | First Name | Last Name | [NAME] | [NAME]