tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__18913__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-23 00:00:00 |  | 233.24 | 14448 | 130.51 | 4880
 | 2001-03-22 00:00:00 |  | 281.29 | 18448 | 160.38 | 5360 | 385.71 | 8040 | 282.16 | 2915
 | 2001-03-21 00:00:00 |  | 460.02 | 24848 | 198.73 | 8120 | 350.98 | 4786 | 253.67 | 1853
 | 2001-03-20 00:00:00 |  | 377.03 | 18384 | 176.12 | 5120 | 390.83 | 2452 | 357.57 | 1668
 | 2001-03-19 00:00:00 |  | 297.33 | 24848 | 176.6 | 9000 | 258.33 | 3388 | 199.67 | 2448
 | 2001-03-18 00:00:00 |  | 220 | 0 | 185 | 0 | 170.47 | 4949 | 156.95 | 2582 |  | 178.66 | 28200
 | 2001-03-17 00:00:00 |  | 195.41 | 17152 | 121.88 | 8832 | 191.77 | 10872 | 180.55 | 1883
 | 2001-03-16 00:00:00 |  | 195.98 | 16352 | 121.88 | 8832 | 219.02 | 5921 | 173.76 | 3142
 | 2001-03-15 00:00:00 |  | 180.19 | 17472 | 98.04 | 5160 | 188.69 | 6005 | 136.45 | 3320
 | 2001-03-14 00:00:00 |  | 162.56 | 17184 | 81.84 | 6960 | 194.59 | 4065 | 117.41 | 1400
 | 2001-03-13 00:00:00 |  | 157.46 | 17840 | 69.39 | 7288 | 171.29 | 4137 | 134.75 | 1330
 | 2001-03-12 00:00:00 |  | 166.55 | 12544 | 91.58 | 6920 | 186.95 | 2928 | 114.77 | 1215
 | 2001-03-11 00:00:00 |  | 163 | 3200 | 90 | 1600 | 104.25 | 1435 | 110.05 | 945 |  | 93.34 | 17760
 | 2001-03-10 00:00:00 |  | 148.73 | 18400 | 66.56 | 5864 | 109.79 | 3007 | 124.99 | 2735
 | 2001-03-09 00:00:00 |  | 148.73 | 18400 | 66.56 | 5864 | 175.73 | 6415 | 122.41 | 1756
 | 2001-03-08 00:00:00 |  | 185.11 | 22848 | 92.66 | 8640 | 191.53 | 4219 | 145.14 | 1004
 | 2001-03-07 00:00:00 |  | 300.27 | 25616 | 169.6 | 6824 | 225.26 | 4337 | 151.01 | 1201
 | 2001-03-06 00:00:00 |  | 309.17 | 20320 | 175.44 | 6728 | 215.32 | 7762 | 192.69 | 3047
 | 2001-03-05 00:00:00 |  | 276.65 | 9792 | 162.76 | 4656 | 215.88 | 4042 | 160.99 | 832
 | 2001-03-04 00:00:00 |  | 240 | 800 | 165 | 0 | 168.1 | 2613 | 141.45 | 365 |  | 163.88 | 14568
 | 2001-03-03 00:00:00 |  | 239.87 | 18240 | 148.58 | 7800 | 188.15 | 5032 | 117.4 | 2417
 | 2001-03-02 00:00:00 |  | 242.68 | 15680 | 149.84 | 6728 | 220.44 | 3332 | 159.56 | 867
 | 2001-03-01 00:00:00 |  | 254.01 | 12752 | 142.32 | 4776 | 234.93 | 3755 | 151.21 | 1609
 | 2001-02-28 00:00:00 |  | 178.77 | 16400 | 103.09 | 5920 | 271.72 | 2187 | 185.29 | 705
 | 2001-02-27 00:00:00 |  | 182.08 | 17920 | 98.83 | 5248 | 173.98 | 1198 | 145.57 | 1235
 | 2001-02-26 00:00:00 |  | 197.33 | 10400 | 128.16 | 4152 | 207.88 | 3693 | 115.94 | 1181
 | 2001-02-25 00:00:00 |  | 150 | 0 | 125 | 0 | 146.95 | 3690 | 109.13 | 1615 |  | 128.16 | 12456
 | 2001-02-24 00:00:00 |  | 183.8 | 14608 | 102.52 | 6472 | 184.67 | 3635 | 150.17 | 855
 | 2001-02-23 00:00:00 |  | 183.8 | 14608 | 102.52 | 6472 | 238.26 | 4340 | 143.66 | 910
 | 2001-02-22 00:00:00 |  | 216.97 | 18320 | 115.4 | 7080 | 206.96 | 2653 | 104.69 | 565
 | 2001-02-21 00:00:00 |  | 218.21 | 20720 | 137.88 | 10600 | 175.48 | 1613 | 94.66 | 1119
Spreadsheet: 39391d1237550409-depreciation-of-fixed-asset-676607_nasser
Sheet: Sheet1 (2)

Asset Life(year) | Description | Asset Value | Buying date | Start Month | End Month | Deprication | Current Value | salvage | TODAY | 2009-03-20 00:00:00
1 | item 1 | 1000 | 2006-02-01 00:00:00 | 2006-02-01 00:00:00 | 2007-01-31 00:00:00 | 999 | 1 | 1
3 | item 2 | 10000 | 2008-02-15 00:00:00 | 2008-02-01 00:00:00 | 2011-01-31 00:00:00 | 3611.111111111111 | 6388.888888888889 | 1
4 | item 3 | 10000 | 2008-02-18 00:00:00 | 2008-03-01 00:00:00 | 2012-02-29 00:00:00 | 2500 | 7500 | 1
Spreadsheet: 88578d1288363452-pivot-report-running-total-jdm2008-pivot-table-cumulative-count-excel-forum
Sheet: Pivot

 | Data |  | Percentage Running Total
Category | Count of Quantity | Count of Quantity2
Fair | 20 | 0.3174603174603174 | 0.3174603174603174
[NAME] category | 20 | 0.3174603174603174 | 0.6349206349206349
Serious | 23 | 0.3650793650793651 | 1
(blank) |  | 0 | 1
Grand Total | 63 | 1
Spreadsheet: 56cbca12-9c02-49e5-a064-53129669df80
Sheet: First

Texas Education Agency |  |  |  | Use a separate worksheet |  |  |  | Campuses
Division of Formula Funding |  |  |  | for each GradeSpan |  |  |  | Total
Comparability Computation Form |  |  |  |  |  |  |  | Title 1, Part A
 |  |  |  |  |  | GS (GRADESPAN) |  | NonTitle 1, Part A
 |  | County District Number: |  |  |  | from | to | Title 1, Part A, Comparable
CD Name: |  |  |  |  |  | 5 | 7 | Title 1, Part A,    Not Comparable
 |  |  |  | All tests | All tests | test 1-Input | test 2-Input | test 3-Input |  |  |  |  | 0.9 | GS Base | 1.1 | 0.9 | GS Base | 1.1 | 0.9 | GS Base | 1.1 | T1 Only | Title I Only | Title I Only | Title I Only
# | Campus #      (REQ'd) | [NAME] | Title 1, Part A  or Skipped | Title I Expenditures (optional) | Campus Enrollment | Campus State/Local Expenditures | Campus Base Salaries         for Non-Federal Instructional Staff | Campus Non Federal Instructional Staff FTE's |  | TEST 1A | TEST 2A | TEST 3A | TEST 1B |  |  | TEST 2B |  |  | TEST 3B |  |  | Non Title I GS Enrollment | Non Title I GS State/Local Expenditures | [NAME] I GS Base Salaries for Non-Federal Instructional Staff | Non Title I GS Non Federal Instructional Staff FTE's
 |  |  |  |  |  |  |  |  |  | Exp / Enroll | [NAME] | Enroll / FTE's | Comp or NC | Campus State & Local Expenditures per Pupil | Campus to GS Base | Comp or NC | [NAME] per Pupil | Campus to GS Base | Comp or NC | [NAME] per FTEs | Campus to GS Base
 |  | Gradespan Totals
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
Spreadsheet: 83144d1283195272-pivot-table-cant-change-source-range-carp-public-opinion-survey-results-1
Sheet: Pivot Table

Count of 1 (live in Carp?)
1 (live in Carp?) | Total |  | Live in Carp
N/A | 1 |  | Yes | 0.4685314685314685
No | 72 |  | No | 0.5244755244755245
Si | 9 |  | N/A | 0.006993006993006993
Yes | 61
Grand Total | 143
Count of 2 (secondhand)
2 (secondhand) | Total |  | Exposed to SHS Outdoors in Carp
n/a | 1 |  | Yes | 0.6713286713286714
No | 46 |  | No | 0.3216783216783217
Si | 8 |  | N/A | 0.006993006993006993
Yes | 88
Grand Total | 143
 |  |  |  |  |  |  |  |  |  | Do you think the following places should be smoke-free?
Count of 3a (outside) |  |  | Do you think the following places should be smoke-free? |  |  |  |  |  |  | Entryways Windows | Restaurant Patios | Public Events | Public Streets
3a (outside) | Total |  | Outside building entrances & windows |  |  |  |  |  |  | 0.7902097902097902 | 0.7552447552447552 | 0.7552447552447552 | 0.7552447552447552
Ninguna Opinion | 1 |  | Yes | 0.7902097902097902 |  |  |  |  |  | 0.1678321678321678 | 0.1538461538461539 | 0.1538461538461539 | 0.1538461538461539
No | 24 |  | No | 0.1678321678321678 |  |  |  |  |  | 0.1118881118881119 | 0.09090909090909091 | 0.09090909090909091 | 0.09090909090909091
No Opinion | 15 |  | N/A | 0.1118881118881119
Si | 7
Yes | 96
Grand Total | 143
Count of 3b (Restaurant patio) |  |  | Do you think the following places should be smoke-free?
3b (Restaurant patio) | Total |  | Restaurant patios
n/a | 1 |  | Yes | 0.7552447552447552
No | 22 |  | No | 0.1538461538461539
No Opinion | 12 |  | N/A | 0.09090909090909091
Si | 8
Yes | 100
Grand Total | 143
Count of 3c (Outdoor public) |  |  | Do you think the following places should be smoke-free?
3c (Outdoor public) | Total |  | Outdoor public events/festivals
n/a | 1 |  | Yes | 0.7552447552447552
No | 27 |  | No | 0.1538461538461539
No Opinion | 14 |  | N/A | 0.09090909090909091
Si | 7
Yes | 94
Grand Total | 143
Count of 3d ( public streets) |  |  | Do you think the following places should be smoke-free?
3d ( public streets) | Total |  | Public streets
No | 39 |  | Yes | 0.5874125874125874
No Opinion | 20 |  | No | 0.2727272727272727
Si | 7 |  | N/A | 0.1398601398601399
Yes | 77
Grand Total | 143
Count of 4a (visit public) |  |  | More likely to visit public places if smoke-free?
4a (visit public) | Total |  | Agree | 0.7272727272727273
Agree | 96 |  | Disagree | 0.1188811188811189
De Acuerdo | 8 |  | No Opinion | 0.1538461538461539
Disagree | 16
En [NAME] | 1
No Opinion | 22
Grand Total | 143
Count of 4b (Cigarette litter problem?) |  |  | Cigarette [NAME] is a problem on streets & sidewalks in Carpinteria
4b (Cigarette litter problem?) | Total |  | Agree | 0.5874125874125874
Agree | 77 |  | Disagree | 0.1328671328671329
De Acuerdo | 7 |  | No Opinion | 0.2797202797202797
Disagree | 17
Ninguna Opinion | 2
No Opinion | 40
Grand Total | 143
5 (More info)
[EMAIL]
Fumor se ve mas mal en mujeres que en hombres porque la mujer deve ser limpia y yuapa
Lesley Medina 636-2272
n/a
[EMAIL]
[EMAIL]
[NAME]
Grand Total
Spreadsheet: 776509d1649767991-sumifs-help-sumifs-help
Sheet: Sheet1

 | 2022-01-07 00:00:00 | 2022-01-14 00:00:00 | 2022-01-21 00:00:00 | 2022-01-28 00:00:00 | 2022-02-04 00:00:00 | 2022-02-11 00:00:00 | 2022-02-18 00:00:00 | 2022-02-25 00:00:00 | 2022-03-05 00:00:00 | 2022-03-12 00:00:00 | 2022-03-19 00:00:00 | 2022-03-26 00:00:00 | 2022-04-02 00:00:00 | 2022-04-09 00:00:00
FS | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000
IV | 1000000 | 1000000 | 1000000 | 1000000 | 1000000 | 1000000 | 1000000 | 1000000 | 1000000 | 1000000 | 1000000 | 1000000 | 1000000 | 1000000
CS | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000
lbss | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000 | 5000000
GPD | 250000 | 250000 | 250000 | 250000 | 250000 | 250000 | 250000 | 250000 | 250000 | 250000 | 250000 | 250000 | 250000 | 250000
 |  | FS | IV | CS | lbss | GPD
 | 2022-01-07 00:00:00
 | 2022-01-14 00:00:00
 | 2022-01-21 00:00:00
 | 2022-01-28 00:00:00
 | 2022-02-04 00:00:00
 | 2022-02-11 00:00:00
 | 2022-02-18 00:00:00
 | 2022-02-25 00:00:00
 | 2022-03-05 00:00:00
 | 2022-03-12 00:00:00
 | 2022-03-19 00:00:00
 | 2022-03-26 00:00:00
 | 2022-04-02 00:00:00
 | 2022-04-09 00:00:00
Spreadsheet: 94085d1293914884-summery-on-each-change-rqed-output-corrected
Sheet: REQUIRED OUTPUT

NAME | GRADE | ITEM | RATE | BANKER
FORGE INFOSYS | A1 | 200 | 4521 | AMINO AMRO
FORGE INFOSYS | A1 | 60 | 2455 | AMINO AMRO
FORGE INFOSYS | A2 | 20 | 4521 | AMINO AMRO
FRNACIS CEMENT CO | A2 | 30 | 5000 | ROYAL BANK
FRNACIS CEMENT CO | A1 | 150 | 3200 | ROYAL BANK
FRNACIS CEMENT CO | A2 | 50 | 2155 | ROYAL BANK
HIMALYA STEEL CEMENT | A1 | 400 | 3300 | USA BANK
HIMALYA STEEL CEMENT | A3 | 300 | 4000 | USA BANK
HIMALYA STEEL CEMENT | A1 | 200 | 3200 | USA BANK
ICCHAMANI SUPPLIER | A3 | 100 | 3200 | ROYAL BANK
K K INFOSYS | A1 | 300 | 3000 | ROYAL BANK
K K INFOSYS | A2 | 600 | 4000 | ROYAL BANK
LUKAS STEEL | A1 | 600 | 3000 | USA BANK
Spreadsheet: mary_fischer__25610__32D-2001
Sheet: E2.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032D
COMPANY NAME  Enron Building Services, Inc.
ANALYSIS OF OTHER CURRENT ASSETS
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-2
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Misapplied cash, reclassified to correct accounts |  | -495917 |  | 495917
Employee Loans Advances |  | 1400 |  | -1400
Other (clean-up, will be written off) |  | -436
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total Current Assets | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 195
Asset/Expense Accts:  DR/(CR)
Spreadsheet: 811047d1672245040-count-distinct-values-based-on-values-in-another-column-problem-example2
Sheet: Sheet1

 |  |  |  | Total count of fruit varieties in D (method A)
 |  |  |  | Total count of fruit varieties in D (method B)
 |  |  |  | How many varieties of Green coloured fruit?
 |  |  | Apple | Green
 |  |  | Apple | Green
 |  |  |  | Green
 |  |  | Apple | Green
 |  |  | Pear | Green
 |  |  | [NAME] | Yellow
 |  |  | [NAME] | Yellow
 |  |  | [NAME] | Yellow
Spreadsheet: 846910d1698064857-formula-to-calculate-value-based-on-the-previous-record-in-a-table-sample
Sheet: Sheet1

BORROWERS NAME | LOANED AMOUNT |  | INTEREST
1 - HARRY POTTER | 5000 |  | 0.05
2 - HERMIONE GRANGER | 3000
BORROWERS NAME | PAYMENT DATE | PAID AMOUNT | BALANCE | INTEREST | BALANCE W/ INTEREST
1 - HARRY POTTER | 2023-09-06 00:00:00 | 1000
1 - HARRY POTTER | 2023-09-15 00:00:00 | 1000
1 - HARRY POTTER | 2023-09-18 00:00:00 | 500
2 - HERMIONE GRANGER | 2023-10-01 00:00:00 | 1000
1 - HARRY POTTER | 2023-10-01 00:00:00 | 1000
2 - HERMIONE GRANGER | 2023-10-10 00:00:00 | 500
1 - HARRY POTTER | 2023-10-10 00:00:00 | 2103.15
Spreadsheet: 109802d1306565678-sumproduct-problems-for-matching-two-items-account-manager-mutual-fund-sales-final
Sheet: Table

District | Team | Employee Name | Staff ID | Product | Group | Sales  Volume | Sales  Value | Transfer from fund to other fund Volume# | Transfer fund to LT MF Value | Sales Volume YTD | Sales Value YTD | Transfer from fund to other fund  Volume# [NAME] | Transfer fund to LT MF  Value YTD | Product Group
11111 | Team 1 | [NAME] | Ab12 | Long Term Mutual Fund | MIP | 1 | 100 | 3 | 500 | 80 | 9000 | 15 | 1000 | Long Term Mutual FundMIP
 | Team 1 | [NAME] | Ab12 | Long Term Mutual Fund | Others | 2 | 700 | 5 | 700 | 90 | 8999 | 23 | 2000 | Long Term Mutual FundOthers
 | Team 1 | [NAME] | [NAME] | Long Term Mutual Fund | Others | 1 | 800 | 6 | 599 | 70 | 7888 | 80 | 2000 | Long Term Mutual FundOthers
 | Team 1 | [NAME] | Ab15 | Money market | MIP | 3 | 900 | 8 | 660 | 80 | 6700 | 70 | 1500 | Money marketMIP
 | Team 2 | [NAME] | 2003 | Long Term Mutual Fund | Others | 13 | 600 | 6 | 800 | 25 | 8000 | 80 | 6000 | Long Term Mutual FundOthers
 | Team 2 | [NAME] | 2003 | Long Term Mutual Fund | MIP | 11 | 222 | 5 | 200 | 40 | 8000 | 70 | 8099 | Long Term Mutual FundMIP
 | Team 3 | [NAME] | 2008 | Money market | others | 4 | 500 | 5 | 700 | 88 | 8800 | 90 | 7000 | Money marketothers
 | Team 3 | [NAME] weatherhead | 2099 | Long Term Mutual Fund | others | 4 | 500 | 5 | 700 | 88 | 8800 | 90 | 3000 | Long Term Mutual Fundothers
 | Team 3 | [NAME] weatherhead | 2099 | Long Term Mutual Fund | MIP | 2 | 500 | 8 | 800 | 99 | 7000 | 100 | 90000 | Long Term Mutual FundMIP
 | Team 3 | [NAME] weatherhead | 2099 | Money market | others | 10 | 200 | 8 | 800 | 99 | 7000 | 60 | 8000 | Money marketothers
Spreadsheet: 398d3faf-8095-4d30-913b-1ed4611e63c4
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4191 | 15149 | Mark | Ellis | NZL | 0 | 01:05:32 | 00:00:00 | 03:51:45 | 00:00:00 | 03:06:17 | 1 | [NAME]
4191 | 25755 | Pail-Ling | Hnug | TPE | 0 | 01:25:16 | 00:00:00 | 04:10:41 | 00:00:00 | 02:56:34 | 2 | 08:32:33
4191 | 10687 | [NAME] | Dayrit | PHI | 0 | 01:15:08 | 00:00:00 | [NAME] | 00:00:00 | [NAME] | 3 | [NAME]
Spreadsheet: 0e671e14-f21a-4372-8086-12017e8c6ed5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259886 | 75855 | [NAME] | De Andres Muguruza | ESP | 4 | 00:16:51 | 00:02:53 | 00:39:23 | [NAME] | 00:14:38 | 1 | 01:15:16
Spreadsheet: sally_beck__33995__Log as of 4_20_01
Sheet: Sum Jan 24 to30

 | Week summary (Jan 24 to 30)
Category | Description | Total |  | Breakdown of Cat 1
1 | Human Errors |  |  | Process in place but not followed
2 | IT Hardware problems |  |  | Officialized on time but needed recalc
3 | IT Software Problems |  |  | Book not officialized
4 | Miscellaneous |  |  | No process in place
5 | Uncontrollable | 0 |  | Other
 | Total |  |  | Total
 |  |  |  | Breakdown of Cat 2
 |  |  |  | Computer breakdown | 0
 |  |  |  | Other | 0
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 3
 |  |  |  | Correct inputs, incorrect outputs
 |  |  |  | Slow feeds
 |  |  |  | Feed problem
 |  |  |  | Books shown as officialized in ERMS, but not RiskTrac
 |  |  |  | Application down alternate system used
 |  |  |  | Other
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 4
 |  |  |  | Credit interface | 0
 |  |  |  | Other | 0
 |  |  |  | Total
Spreadsheet: mike_swerzbin__27997__michael Swerbin
Sheet: michael Swerbin

[PHONE] / 0413
[NAME]
97204 PORTLAND
|Ref Number | Doc Date | Amount | Check No | Clear Date | M | Due Date
28733 | 2001-11-16 00:00:00 | 969.2 |  |  |  | 2001-11-16 00:00:00 | in open items
23719 | 2001-10-29 00:00:00 | 2298.95 |  |  | E | 2001-10-29 00:00:00 | in open items
EXP072700 | 2000-08-01 00:00:00 | 971.34 | 9600002818 | 2000-08-01 00:00:00 | C | 2000-08-01 00:00:00
EXP090700 | 2000-09-12 00:00:00 | 333.39 | 9600006627 | 2000-09-12 00:00:00 | C | 2000-09-12 00:00:00
EXP092200 | 2000-09-29 00:00:00 | 1269.56 | 9600008593 | 2000-09-29 00:00:00 | C | 2000-09-29 00:00:00
EXP101600 | 2000-10-20 00:00:00 | 1590.63 | 9600010578 | 2000-10-20 00:00:00 | C | 2000-10-20 00:00:00
EXP121301 | 2001-01-16 00:00:00 | 895.51 | 2000066032 | 2001-01-16 00:00:00 | Y | 2001-01-16 00:00:00
EXP012401 | 2001-02-01 00:00:00 | 919 | 2000071001 | 2001-02-01 00:00:00 | Y | 2001-02-01 00:00:00
EXP010326-9678 | 2001-03-26 00:00:00 | 840.8 | 2000084321 | 2001-03-26 00:00:00 | Y | 2001-03-26 00:00:00
EXP010608-23364 | 2001-06-08 00:00:00 | 631.72 | 2000104195 | 2001-06-08 00:00:00 | Y | 2001-06-08 00:00:00
3274 | 2001-07-18 00:00:00 | 1893.93 | 2000117606 | 2001-07-18 00:00:00 | Y | 2001-07-18 00:00:00
10678 | 2001-08-28 00:00:00 | 1195 | 2000129336 | 2001-08-28 00:00:00 | Y | 2001-08-28 00:00:00
17366 | 2001-10-02 00:00:00 | 1394 | 2000136312 | 2001-10-02 00:00:00 | Y | 2001-10-02 00:00:00
[PHONE] / 0011
[NAME]
97204 PORTLAND
WT1101 SWERZBIN | 2001-11-01 00:00:00 | 1075737.46 | 2000359519 | 2001-11-01 00:00:00 | F | 2001-11-01 00:00:00
Spreadsheet: tracy_geaccone__40231__enron corp infomation request 111601
Sheet: EBS Burn

 |  |  |  | YTD |  | Forecast Cash Expenditures
 |  | Headcount Actual (9/30) |  | Cash Expenditures |  | October |  | November |  | December |  | January |  | February |  | March |  | Comments
Americas
Emerging Markets
Other
Analysts/Associates
Total
Depreciation & Amortization |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Taxes Other Than Income |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total Expenses net of Capitalized Expense
Plus:  Capital Expenditures |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Cash Payments |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Less: DD&A
 |  |  |  |  |  | 0
Total Cash Burn Rate
Spreadsheet: 702414d1604336506-subtract-1-from-last-5-records-manualexamplev2
Sheet: Manual -what i would like

HOW IT IS CURRENTLY |  |  |  |  |  | WHAT I WOULD LIKE
A | B | A-B | SUM last 5 | SUM last 6 |  | A | B | SUM last 5 | SUM last 6
3 | 3 |  |  |  |  | 3 | 3 | 0
3 | 3 |  |  |  |  | 3 | 3 | -1
3 | 3 |  |  |  |  | 3 | 3 | -1
3 | 3 |  |  |  |  | 3 | 3 | -1
3 | 3 |  |  |  |  | 3 | 3 | -2
3 | 4 |  |  |  |  | 4 | 5 | -2
3 | 3 |  |  |  |  | 8 | 8 | -1
3 | 3 |  |  |  |  | 6 | 6 | -1
3 | 4 |  |  |  |  | 2 | 1 | -1
3 | 3 |  |  |  |  | 3 | 3 | 0
3 | 3 |  |  |  |  | 4 | 4 | 0
Spreadsheet: 779254d1651669017-how-change-vba-to-formula-and-functions-calendar-not-daf-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Public Holidays | Pub Holiday Description
 |  | 2022-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | New Year's Day
 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |  |  |  |  |  |  | 2022-03-21 00:00:00 | Human Rights Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-15 00:00:00 | Good Friday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-17 00:00:00 | Easter Sunday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-18 00:00:00 | Family Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-27 00:00:00 | Freedom Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-05-02 00:00:00 | Workers' Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-06-16 00:00:00 | Youth Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-07-18 00:00:00 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-08-09 00:00:00 | National Women's Day
 |  | Public Holidays | Pub Holiday Description |  |  |  |  |  |  |  |  |  |  |  | 2022-09-24 00:00:00 | Heritage Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-12-16 00:00:00 | Day of Reconciliation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-12-25 00:00:00 | Christmas Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-12-26 00:00:00 | Day of Goodwill
Spreadsheet: 219977d1363025095-minute-and-second-formula-issues-question-sample-worksheet
Sheet: Sheet1

time in min | multiplied by | total time
 |  |  |  | general # to show the sum doesn't add correctly
00:05:00 | 1 | 00:05:00 |  | 5
00:01:45 | 200 | 05:50:00 |  | 50
00:02:00 | 1 | 00:02:00 |  | 2
00:01:00 | 5 | 00:05:00 |  | 5
00:02:00 | 1 | 00:02:00 |  | 2
00:01:30 | 10 | 00:15:00 |  | 15
00:08:00 | 1 | 00:08:00 |  | 8
 |  | 06:27:00 | grand total time | 87 | grand total time should be 87hrs or 1:27:00
Spreadsheet: 749478d1632826937-how-to-count-specific-items-for-specific-person-example
Sheet: Sheet1

Name | Week1 | Week2 | Week3
[NAME] | E | AM | E
[NAME] | AM | AM | E
[NAME] | AM | AM | AP
[NAME] | AP | AP | AM
[NAME] | E | AP | AM
Will | E | AP | AM
Spreadsheet: 43901d1242555572-average-column-depending-on-values-in-another-column-forex-journal-template
Sheet: APRTOTALS

DATE |  | WINS | LOSSES | WIN AMOUNT | LOSS AMOUNT | Win % | Loss % | GROSS P/L | PIPS | DEPOSITS & WITHDRAWALS
MON
TUE
WED
THU
FRI
Week Sub Total
MON
TUE
WED
THU
FRI
Week Sub Total
MON
TUE
WED
THU
FRI
Week Sub Total
MON
TUE
WED
THU
FRI
Week Sub Total
MON
TUE
WED
THU
FRI
Week Sub Total
 |  | WINS | LOSSES | WIN $ | LOSS $ | WIN % | LOSS % | ACCOUNT $ TOTAL | PIP TOTAL | TOTAL $ IN/OUT
TOTALS
 |  | ACTUAL WIN/LOSS $ |  |  |  |  |  | AV. $/PIP | AV. PIP/DAY | AV. LOT [NAME] (MONTHLY)
Spreadsheet: 708473d1607862254-frequently-appearing-number-in-a-list-after-a-specified-number-mariocox
Sheet: Sheet1

 |  |  |  | Value 1 | Value 2 | Value 3 | Value 4 | Value 5 | Value 6 | Value 7 | Value 8 | Value 9 | Value 10
 |  | 5
 |  | 1
 |  | 3
 |  | 8
 |  | 1
 |  | 4
 |  | 9
 |  | 1
 |  | 3
 |  | 7
 |  | 1
 |  | 3
 |  | 2
 |  | 8
 |  | 1
 |  | 4
 |  | 6
 |  | 2
 |  | 1
 |  | 7
 |  | 9
Spreadsheet: 694816d1599813528-subtotal-of-one-column-based-on-the-value-of-two-other-columns-xl-example
Sheet: Sheet1

[NAME] | 2 | L
[NAME] | 4 | L
[NAME] | 6 | L
[NAME] | 8 | L
[NAME] | 5 | C
[NAME] | 3 | C
[NAME] |  | C
[NAME] | 1 | C
[NAME] | 2 | L
[NAME] | 3 | C
[NAME] | 4 | L
[NAME] | 5 | C
[NAME] | 6 | L
[NAME] | 6 | L
[NAME] | 8 | C
[NAME] |  | C
Mark | 3 | C
Mark | 5 | L
Mark | 9 | L
Mark | 6 | L
Mark | 2 | C
Mark | 3 | C
Mark | 8 | C
Mark |  | L
Spreadsheet: 98005640-f9da-4417-95c1-fa8c3e3e2274
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80688067922 | Petra | Beyond Belief | 1990-06-20 | Compact Disc | Ac | 9.99 | Y | Available
Word Records | 80688063528 | Petra | Petra Praise | 1989-10-17 | Compact Disc | Praise | 9.99 | N | To Be Retired
Word Records | 80688622923 | Petra | Still Means War | 2002-11-05 | Compact Disc | Ac | 16.99 | N | To Be Retired
Special Markets Product Rec | 80688715120 | Petra | Definitive Collection, The | 2007-05-22 | Compact Disc | Ac | 7.99 | N | To Be Retired
Spreadsheet: 705593d1606212438-transpose-from-row-to-column-along-with-other-numeric-data-test2-3-ans
Sheet: Results

Pulling from Row to Column | Pulling into a Single Column