tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: lindy_donoho__21981__Throughput_1999 to Dec 2001
Sheet: Throughput

1999 Throughput |  | January | February | March | April | May | June | July | August | September | October | November | December | Total
WOT |  |  |  |  |  |  |  |  |  |  |  | 1040
East |  | 330.7 | 338.6 | 386.8 | 512.2 | 433.9 | 466.3 | 488.8 | 685.9 | 472.4 | 248 | 280 | 322
[NAME] to El Paso Blanco |  | 165.4 | 151.4 | 141.1 | 185.1 | 164.4 | 234.7 | 266 | 240.1 | 211.8 | 209.3 | 209.3 | 277.2
Total Throughput
WOT IT
East IT |  |  |  |  |  |  |  |  |  |  |  | 20
[NAME] to El Paso Blanco IT |  | 30 | 21.4 | 19.9 | 83.3 | 53.7 | 70.3 | 114 | 107.8 | 86 | 26 | 26 | 102.1
Total IT Throughput
2000 Throughput |  | January | February | March | April | May | June | July | August | September | October | November | December | Total
WOT |  | 869.1 | 856.5 | 905 | 728.5 | 828.5 | 944 | 984.7 | 1035.6 | 1062.7 | 1052.7 | 963 | 1105.3
East |  | 369.2 | 416.8 | 383.8 | 487.1 | 537.4 | 368.7 | 430.5 | 422.5 | 385 | 328.2 | 390.1 | 315.1
[NAME] to El Paso Blanco |  | 293.5 | 313.6 | 277 | 251.4 | 343.3 | 330.3 | 307.9 | 284 | 325.4 | 305.8 | 319.6 | 367
Total Throughput
WOT IT |  | 0.2 | 0.2 |  |  |  |  |  |  |  |  | 4.3 | 6.6
East IT
[NAME] to El Paso Blanco IT |  | 129.8 | 53.2 | 55.6 | 85 | 116.4 | 148 | 135.6 | 125.9 | 103.5 | 130.4 | 45.5 | 98.8
Total IT Throughput
2001 Throughput |  | January | February | March | April | May | June | July | August | September | October | November | December | Total
WOT |  | 1108.6 | 1119.3 | 1109.9 | 1103.7 | 1075.1 | 1072.1 | 1090.5 | 1106.8 | 986.7 | 983.6 | 948.9 | 1047.9
East |  | 336.1 | 343.9 | 358.7 | 540.4 | 494.4 | 484.2 | 493.8 | 471.4 | 458.4 | 518.4 | 534.5 | 370.4
[NAME] to El Paso Blanco |  | 341.2 | 317.8 | 301.3 | 375.1 | 400.4 | 373.5 | 247.5 | 264.9 | 355.1 | 312.8 | 291 | 268.7
Total Throughput
WOT IT |  |  | 14.6 | 4.3 | 0 | 0 | -8.6 | 0 | 0 |  | 0 | 0 | 1.1
East IT
[NAME] to El Paso Blanco IT |  | 105.9 | 81.1 | 87.5 | 124.8 | 177.9 | 130.2 | 0.4 | 0.2 | 78.7 | 55.6 | 74.2 | 66.2
Total IT Throughput
Spreadsheet: 473500d1470241624-stage-progression-example-23-
Sheet: Level_3

 | Surname | Name | Test 1 | Test 2 | Test 3 | Level
 |  |  | 2015-12-01 00:00:00
 |  |  | 2015-01-07 00:00:00 | 2015-01-08 00:00:00 | 2015-01-09 00:00:00
Spreadsheet: 0998d1a1-6cdb-4e3e-a6af-9ee0cba435a0
Sheet: Sheet1

Lewis and Clark College | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Time Sheets Due in Payroll |  |  |  | Pay Dates 2013 - 2014
2013-06-17 00:00:00 |  |  |  | Friday, June 28, 2013
2013-07-16 00:00:00 |  |  |  | Wednesday, July 31, 2013
2013-08-16 00:00:00 |  |  |  | Friday, August 30, 2013
2013-09-16 00:00:00 |  |  |  | Monday, September 30, 2013
2013-10-16 00:00:00 |  |  |  | Thursday, October 31, 2013
2013-11-18 00:00:00 |  |  | Wednesday, November 27, 2013
2013-12-09 00:00:00 |  |  |  | Monday, December 23, 2013
2014-01-16 00:00:00 |  |  |  | Friday, January 31, 2014
2014-02-17 00:00:00 |  |  |  | Friday, February 28, 2014
2014-03-17 00:00:00 |  |  |  | Monday, March 31, 2014
2014-04-16 00:00:00 |  |  |  | Wednesday, April 30, 2014
2014-05-16 00:00:00 |  |  |  | Friday, May 30, 2014
Time sheets must be signed by both the employee and the supervisor.
In the absence of the immediate supervisor an alternate must sign.
Spreadsheet: 836043d1689066063-summary-across-multiple-sheets-and-reference-list-excel-linup-help-game-lineup-2023-07-07
Sheet: Reference Roster

First Name | Last Name | Number
Player | One | 1
Player | Two | 2
Player | Three | 3
Player | Four | 4
Player | Five | 5
Player | Six | 6
Player | Seven | 7
Player | Eight | 8
Player | Nine | 9
Player | Ten | 10
Player | Eleven | 11
Spreadsheet: 123949d1317940739-if-and-conditions-book2
Sheet: Sheet3

Column A | Column B | Column C | Column D
A | x | g | 2
B | y | h | 4
C | z | g | 5
D | y | h | 6
A | x | g | 4
B | z | h | 5
C | x | g | 4
D | y | h | 3
A | x | g | 3
Spreadsheet: 764884d1643052298-need-help-excluding-some-data-report632
Sheet: P2

 | PROGRAM Info (changes infrequently) |  |  |  |  |  |  | OVERALL STATUS |  |  |  |  |  |  | MILESTONES |  |  |  | RECENT ACCOMPLISHMENTS |  | KEY ISSUES / RISKS |  |  |  |  | NEXT STEPS
 | Project ID | Project Name | Department | Executive Sponsor | [NAME] | Project Manager | Parent Program | Target Completion Date | Status | Percent Complete | Overall Status | Scope | Schedule | Resources | Name | Due Date | Status | Health | Name | Due Date2 | [NAME] | Due Date3 | Priority (Impact & Probability) | Status | Mitigation | Name3 | Due [NAME] | Status 2
 | Numeric | Text | Text | Text | Text | Text | Text | Date | Status Dropdown | Numeric - Percentage | Health (current)  [NAME] | Scope RAG Status | Schedule  [NAME] | Resources [NAME] | Text | Date | Status | [NAME] | Text | Date | Text | Date | Low /  Normal / High | Status Dropdown | Text | Text | Date | Status Dropdown
 | 209
Spreadsheet: 7a8acfa2-486a-4967-ab7d-9df2ec4da4d5
Sheet: Funding 2012

Node | Amount | Comments
GSI | 5000 | Confirmed
DESY | 5000 | Confirmed
INFN | 5000 | Confirmed
CEA | 5000 | Confirmed
IN2P3 | 5000 | Confirmed
Chalmers | 5000 | TBC
STFC | 5000 | TBC with programme of work of HEPTech
EPFL | 5000 | TBC
PSI | 5000 | TBC
CPAN | 5000 | Confirmed
Copenhagen | 5000 | TBC
CERN |  | Matching contribution confirmed up to 70kEuro
[NAME] | 0
NTUA | 2500 | Confirmed
Sofia University | 2500 | Confirmed
LIP | 0 | Considering the In-kind contribution 1 FTE through the CERN Portugal programme for young trainees (internship duration 1-2 years maximum). Discussions in progress.
ILL | 500 | Confirmed but limited to 500 [NAME], discussions with ESRF in progress
Spreadsheet: 833184d1686830176-if-statement-uses-more-than-64-levels-of-nesting-excel-for-forum
Sheet: Φύλλο2

From | To | New Price
0 | 1 | 8
1 | 2 | 9
2 | 3 | 11
3 | 4 | 13
4 | 5 | 13
5 | 6 | 14
6 | 7 | 16
7 | 8 | 19
8 | 9 | 19
9 | 10 | 21
10 | 11 | 22
11 | 12 | 27
12 | 13 | 28
13 | 14 | 29
14 | 15 | 30
15 | 16 | 31
16 | 17 | 32
17 | 18 | 33
18 | 19 | 34
19 | 20 | 35
20 | 21 | 36
21 | 22 | 37
22 | 23 | 38
23 | 24 | 39
24 | 25 | 40
25 | 26 | 41
26 | 27 | 42
27 | 28 | 43
28 | 29 | 44
29 | 30 | 45
30 | 31 | 46
31 | 32 | 47
32 | 33 | 48
33 | 34 | 49
34 | 35 | 50
35 | 36 | 51
36 | 37 | 52
37 | 38 | 53
38 | 39 | 54
39 | 40 | 55
40 | 41 | 56
41 | 42 | 57
42 | 43 | 58
43 | 44 | 59
44 | 45 | 60
45 | 46 | 61
46 | 47 | 62
47 | 48 | 63
48 | 49 | 64
49 | 50 | 65
50 | 51 | 66
51 | 52 | 67
52 | 53 | 68
53 | 54 | 69
54 | 55 | 70
55 | 56 | 71
56 | 57 | 72
57 | 58 | 73
58 | 59 | 74
59 | 60 | 75
60 | 61 | 76
61 | 62 | 77
62 | 63 | 78
63 | 64 | 79
64 | 65 | 80
65 | 66 | 81
66 | 67 | 82
67 | 68 | 83
68 | 69 | 84
69 | 70 | 85
70 | 71 | 86
71 | 72 | 87
72 | 73 | 88
73 | 74 | 89
74 | 75 | 90
75 | 76 | 91
76 | 77 | 92
77 | 78 | 93
78 | 79 | 94
79 | 80 | 95
80 | 81 | 96
81 | 82 | 97
82 | 83 | 98
83 | 84 | 99
84 | 85 | 100
85 | 86 | 101
86 | 87 | 102
87 | 88 | 103
88 | 89 | 104
89 | 90 | 105
90 | 91 | 106
91 | 92 | 107
92 | 93 | 108
93 | 94 | 109
94 | 95 | 110
95 | 96 | 111
96 | 97 | 112
97 | 98 | 113
98 | 99 | 114
99 | 100 | 115
100 | 101 | 116
101 | 102 | 117
102 | 103 | 118
103 | 104 | 119
104 | 105 | 120
105 | 106 | 121
106 | 107 | 122
107 | 108 | 123
108 | 109 | 124
109 | 110 | 125
110 | 111 | 126
111 | 112 | 127
112 | 113 | 128
113 | 114 | 129
114 | 115 | 130
115 | 116 | 131
116 | 117 | 132
117 | 118 | 133
118 | 119 | 134
119 | 120 | 135
120 | 121 | 136
121 | 122 | 137
122 | 123 | 138
123 | 124 | 139
124 | 125 | 140
125 | 126 | 141
126 | 127 | 142
127 | 128 | 143
128 | 129 | 144
129 | 130 | 145
130 | 131 | 146
131 | 132 | 147
132 | 133 | 148
133 | 134 | 149
134 | 135 | 150
135 | 136 | 151
136 | 137 | 152
137 | 138 | 153
138 | 139 | 154
139 | 140 | 155
140 | 141 | 156
141 | 142 | 157
142 | 143 | 158
143 | 144 | 159
144 | 145 | 160
145 | 146 | 161
146 | 147 | 162
147 | 148 | 163
148 | 149 | 164
149 | 150 | 165
150 | 151 | 166
151 | 152 | 167
152 | 153 | 168
153 | 154 | 169
154 | 155 | 170
155 | 156 | 171
156 | 157 | 172
157 | 158 | 173
158 | 159 | 174
159 | 160 | 175
160 | 161 | 176
161 | 162 | 177
162 | 163 | 178
163 | 164 | 179
164 | 165 | 180
165 | 166 | 181
166 | 167 | 182
167 | 168 | 183
168 | 169 | 184
169 | 170 | 185
170 | 171 | 186
171 | 172 | 187
172 | 173 | 188
173 | 174 | 189
174 | 175 | 190
175 | 176 | 191
176 | 177 | 192
177 | 178 | 193
178 | 179 | 194
179 | 180 | 195
180 | 181 | 196
181 | 182 | 197
182 | 183 | 198
183 | 184 | 199
184 | 185 | 200
185 | 186 | 201
186 | 187 | 202
187 | 188 | 203
188 | 189 | 204
189 | 190 | 205
190 | 191 | 206
191 | 192 | 207
192 | 193 | 208
193 | 194 | 209
194 | 195 | 210
195 | 196 | 211
196 | 197 | 212
197 | 198 | 213
198 | 199 | 214
199 | 200 | 215
200 | 201 | 216
Spreadsheet: 778355d1651017885-xirr-formula-works-in-one-table-but-not-another-xirr-sample
Sheet: Sheet2

JPM |  |  | WBD
Event | Date | $ | Event | Date | $
Buy | 2020-09-15 00:00:00 | -16437.3 | Spinoff | 2022-04-11 00:00:00 | -7331
 |  |  | from T
Curr. Val. | 2022-04-26 00:00:00 | 20625.77 | Curr. Val. | 2022-04-26 00:00:00 | 5195.46
 | XIRR |  |  | XIRR
Spreadsheet: phillip_m_love__30139__200006_OA
Sheet: WE-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 58210378 | 245061994
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 12953024 | 54506391
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 71163402 | 299568385
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -59069841 | -245268436
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -13576708 | -56797029
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 231555 | 933645
 | Total Purchases: |  | -72414994 | -301131820
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 1146923 | 4793070
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 1146923 | 4793070
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 40211 | 156268
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 29687 | 365184
 | Total Imbalances: |  | 69898 | 521452
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 235600 | 861532
18 |  | W/D (Purchase from Stg) | -201038 | -739643
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -201038 | -739643
 | Total Storage: |  | 34562 | 121889
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 209 | 835.5300345163112
 |  |  | 0 | 0
23 | Fuel: |  | -231555 | -933645
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -251684.38
25 |  | Demand | 0 | -1093891.19
 | Total Transport Expense: |  | 0 | -1345575.57
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 22698435.84959999
31 |  | Prior Month Book Balance | 0 | -35291625
 |  | Total MTM Income | 0 | -12593189.15040001
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 18553354
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | -30352
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -22208
 |  | TOTAL INTRA-MTH
FT-West
 |  | Current Month MTM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 887708d1738020568-financial-calculation-price-volume-matrix-pvm-calc
Sheet: Sheet1

 |  |  | *Please note that the mix %'s in 'D' and 'I' were given to me in the prompt, but I'm not sure how it makes sense. I'd think that the mix here would be the period's quanity for that particular unit divided by the total….
 |  |  | Base Period |  |  |  |  | Current Period |  |  |  |  | [NAME] |  |  |  |  | PVM Analysis
 |  |  | Mix | Qty (Ton) | Revenue $ | Rev $/Ton |  | Mix | Qty (Ton) | Revenue $ | Rev $/Ton |  | Mix | Qty (Ton) | Revenue $ | Rev $/Ton |  | Price | Volume | Mix
 | Unit A |  | 0.35 | 3000 | 240000 |  |  | 0.4 | 2500 | 210000 |  |  |  |  |  |  |  |  |  |  | <-- These formulas seemed too simple. Not sure if I'm doing this right
 | unit B |  | 0.2 | 1000 | 120000 |  |  | 0.33 | 1805 | 225625
 | Unit C |  | 0.45 | 1200 | 84000 |  |  | 0.27 | 1205 | 81940
 | Total
 |  |  | Prompt:
Spreadsheet: 845304d1696847240-working-days-and-quarters-working-days-and-quarters-w-manually-data-added-update
Sheet: Sheet1

Start date  ( can be in the past ) | End Date  ( in the future ) | Utilization | Current month (days)  october 23 | Current month +1 november 23 | Current month +2 december 23 | Current month +3  january 24 | Current month +4 february 24 | Current month +5 march 24 | Current month +6 april 24 | Current month +7 may 24 | Current month +8 june 24 | Current month +9 july 24 | Current month +10 august 24 | Current month +11 september 24
2023-03-02 00:00:00 | 2023-12-03 00:00:00 | 0.6
2023-06-04 00:00:00 | 2024-06-06 00:00:00 | 0.3
2023-10-12 00:00:00 | 2024-12-12 00:00:00 | 1
Start date | End Date | Utilization | Current Quarter (days) Q4-23 | Current Quarter +1 Q1-24 | Current Quarter +2 Q2-24 | Current Quarter  +3  Q3-24
2023-03-02 00:00:00 | 2023-04-03 00:00:00 | 0.6
2023-06-04 00:00:00 | 2024-09-06 00:00:00 | 0.3
2023-04-12 00:00:00 | 2024-12-12 00:00:00 | 1
 |  | start | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2023-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00
 |  | end
 |  | W days
 |  |  | 2023-10-12 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2023-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00
 |  |  | 2023-10-31 00:00:00 |  | 2023-12-03 00:00:00 |  |  |  |  |  | 2023-06-06 00:00:00
Start date  ( can be in the past ) | End Date  ( in the future ) | Utilization | Current month (days)  october 23 | Current month +1 november 23 | Current month +2 december 23 | Current month +3  january 24 | Current month +4 february 24 | Current month +5 march 24 | Current month +6 april 24 | Current month +7 may 24 | Current month +8 june 24 | Current month +9 july 24 | Current month +10 august 24 | Current month +11 september 24
2023-03-02 00:00:00 | 2023-12-03 00:00:00 | 0.6
2023-06-04 00:00:00 | 2024-06-06 00:00:00 | 0.3
2023-10-12 00:00:00 | 2024-12-12 00:00:00 | 1
Spreadsheet: lisa_gang__22311__ENA_PGE_JUNE_4_2002
Sheet: LOSSES

From: | EPMI
To: | PGE System Transactions
Date: | 2002-06-04 00:00:00
HE
ENDING | TOTAL |  | TOTAL
Pacific
Prevailing
Time
(PPT)
0100 | 0
0200 | 0
0300 | 0
0400 | 0
0500 | 0
0600 | 0
0700 | 0
0800 | 0
0900 | 0
1000 | 0
1100 | 0
1200 | 0
1300 | 0
1400 | 0
1500 | 0
1600 | 0
1700 | 0
1800 | 0
1900 | 0
2000 | 0
2100 | 0
2200 | 0
2300 | 0
2400 | 0
 | No losses scheduled for today.  Losses for this day was scheduled on 6/3/02 | PGE | PGE
 |  | PGE LOSSES | [NAME] [NAME]
 |  | PGE | PGE
 | NEW COLUMN
Spreadsheet: 768230d1644887489-companies-that-use-products-were-familiar-with-example
Sheet: Our Expertise

 | Machine Make | [NAME]
 | CAT | 795
 | Komatsu | 930E
 | [NAME] | ST710
 | Gradall | 7320 Scalers
 | CAT | R1700
 | [NAME] | ST-1030
 | CAT | 6060
 | [NAME] | PV271
 | CAT | 930H
 | CAT | 972K
 | Kress | Hauler
 | CAT | R1700
 | Sandvik | DD421
 | CAT | AD45
 | CAT | AD30
 | Copco | ST710
 | CAT | AD60
 | CAT | 793PLE
 | RDH | Diesel LHD
 | CAT | 775F
 | Komatsu | HD465
 | CAT | 775G
 | CAT | 990H
 | CAT | 777F
 | CAT | R2900G
 | CAT | AD45
 | [NAME] | 850
 | CAT | 777
 | International | Truck
 | CAT | R1700
 | [NAME] | ST8B
 | [NAME] | ST7
 | CAT | AD30
 | CAT | R1600G
 | CAT | R1700G
 | CAT | AD30
 | CAT | AD45
 | CAT | R1700G
 | Sandvik | 40D
 | CAT | AD30
 | CAT | R1700 8XZ
 | Sandvik | TH551
 | Sandvik | TH545i
 | CAT | R1700
 | CAT | AD30
 | CAT | AD30
 | [NAME] | MT2010
Spreadsheet: rick_buy__32927__TAB1_EPMI_Power
Sheet: ARAP

December Settlements
 | Purchases | Sales |  | Total
Physical Power |  | -7773720 |  |  | Confirmed and net amount is due from EPMI on the 20th
Ercot QSE | 137042.77 | 0 |  |  | Due 12/03
Daily Balancing | 95349.69 | 0 |  |  | Due 12/10
of Power | 144607.58 | 0 |  |  | Due12/17
 | 133486.54 | 0 |  |  | Due 12/24
 | 100403.39 | 0 |  |  | Due 12/31
Total
Note: Amounts due NPW are indicated in ( )
Spreadsheet: 1c5c7e78-8841-4453-96f0-a1f3062e8279
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
 | LEIA- ME
 | Até o fim!!!
 | [NAME] falar do que me interessa.
 | Por tudo o que lhe é mais sagrado em sua vida,
 | NÃO VENDA ESTE PROGRAMA !!!!!!
 | Pois ele é distribuido de graça, para todo mundo!!!!!!!!!!!!!!
 | Quem quiser é só copiar e usar a vontade!!!!!!!!!
 | Se você tem conhecimentos de excel e desejar melhorar o programa
 | criando telas, etc , continue lendo e vai descobrir o desbloqueio das planilhas
 | [NAME] você possa alterar alguma fórmula.
 | E vê se me envia uma cópia, [NAME] ele!!!!
 | MEU EMAIL É:
 | [EMAIL]
 | MINHA HUMILDE PÁGINA ESTÁ NO ENDEREÇO
 | www.valdecicontabilidade.ezdir.net
 | [NAME]
 | Técnico Contabil
 | 2003-04-23 15:22:35.120000
 | Como você leu até o fim, vou te dar um presente:
 | Senha de qualquer programa [NAME]
 | 651206
Spreadsheet: 786248d1657064357-using-index-match-to-populate-a-table-based-of-drop-down-list-in-a-given-cell-populate_state_data-3-test1
Sheet: state list

-
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
Florida
Georgia
Hawaii
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Vermont
Virginia
Washington
West Virginia
Wisconsin
Wyoming
Spreadsheet: 270468d1381496317-sum-for-multiple-criteria-test-help
Sheet: DATA

 |  |  | Month
User | Leader | Measure | Jan | Feb | Mar
User 1 | Leader 1 | Measure1 | 50 | 60 | 70
User 1 | Leader 1 | Measure2 | 1 | 2 | 3
User 1 | Leader 1 | Measure3 | 10 | 12 | 14
User 2 | Leader 1 | Measure1 | 50 | 60 | 70
User 2 | Leader 1 | Measure2 | 1 | 2 | 3
User 2 | Leader 1 | Measure3 | 10 | 12 | 14
User 3 | Leader 1 | Measure1 | 50 | 60 | 70
User 3 | Leader 1 | Measure2 | 1 | 2 | 3
User 3 | Leader 1 | Measure3 | 10 | 12 | 14
User 4 | Leader 2 | Measure1 | 50 | 60 | 70
User 4 | Leader 2 | Measure2 | 1 | 2 | 3
User 4 | Leader 2 | Measure3 | 10 | 12 | 14
User 5 | Leader 2 | Measure1 | 50 | 60 | 70
User 5 | Leader 2 | Measure2 | 1 | 2 | 3
User 5 | Leader 2 | Measure3 | 10 | 12 | 14
User 6 | Leader 3 | Measure1 | 50 | 60 | 70
User 6 | Leader 3 | Measure2 | 1 | 2 | 3
User 6 | Leader 3 | Measure3 | 10 | 12 | 14
 |  |  |  | Need red to populate based on Leader, measure and Month
Spreadsheet: 37251d1235189954-switch-pivot-data-with-dynamic-ranges-and-a-defined-name-change_data
Sheet: Sheet2

Name | Amount
Ally | 10
[NAME] | 20
Creg | 30
[NAME] | 40
[NAME] | 50
Fred | 60
Greg | 70
Hany | 80
Igge | 90
[NAME] | 100
[NAME] | 110
[NAME] | 120
Niel | 130
Oret | 140
Spreadsheet: 164170d1340672499-sort-array-of-dates-into-single-column-datesamplemalina
Sheet: manual

Date Loan Matures | IPTD | Payment due dates | Dates Payments were received | Dates interest rate changed | default date | Date when loan balance changed |  | Payoff Calculations
2013-02-15 00:00:00 | 2010-11-02 00:00:00 | 2010-12-05 00:00:00 | 2010-12-05 00:00:00 | 2010-12-03 00:00:00 | 2011-02-06 00:00:00 | 2010-11-06 00:00:00 |  | Date | description
 |  | 2011-01-05 00:00:00 | 2011-01-07 00:00:00 | 2011-01-09 00:00:00 |  | 2010-11-22 00:00:00 |  | 2010-11-02 00:00:00 | IPTD | 2010-11-02 00:00:00 | IPTD
 |  | 2011-02-05 00:00:00 | 2011-02-03 00:00:00 | 2011-02-01 00:00:00 |  | 2010-12-01 00:00:00 |  | 2010-11-06 00:00:00 | Date when loan balance changed | 2010-11-06 00:00:00 | Date when loan balance changed
 |  |  |  | 2011-03-01 00:00:00 |  |  |  | 2010-11-22 00:00:00 | Date when loan balance changed | 2010-11-22 00:00:00 | Date when loan balance changed
 |  |  |  |  |  |  |  | 2010-12-01 00:00:00 | Date when loan balance changed | 2010-12-01 00:00:00 | Date when loan balance changed
 |  |  |  |  |  |  |  | 2010-12-03 00:00:00 | Dates interest rate changed | 2010-12-03 00:00:00 | Dates interest rate changed
 |  |  |  |  |  |  |  | 2010-12-05 00:00:00 | Payment due dates | 2010-12-05 00:00:00 | Payment due dates
 |  |  |  |  |  |  |  | 2010-12-05 00:00:00 | Dates Payments were received | 2010-12-05 00:00:00 | Dates Payments were received
 |  |  |  |  |  |  |  | 2011-01-05 00:00:00 | Payment due dates | 2011-01-05 00:00:00 | Payment due dates
 |  |  |  |  |  |  |  | 2011-01-07 00:00:00 | Dates Payments were received | 2011-01-07 00:00:00 | Dates Payments were received
 |  |  |  |  |  |  |  | 2011-01-09 00:00:00 | Dates interest rate changed | 2011-01-09 00:00:00 | Dates interest rate changed
 |  |  |  |  |  |  |  | 2011-02-01 00:00:00 | Dates interest rate changed | 2011-02-01 00:00:00 | Dates interest rate changed
 |  |  |  |  |  |  |  | 2011-02-03 00:00:00 | Dates Payments were received | 2011-02-03 00:00:00 | Dates Payments were received
 |  |  |  |  |  |  |  | 2011-02-05 00:00:00 | Payment due dates | 2011-02-05 00:00:00 | Payment due dates
 |  |  |  |  |  |  |  | 2011-02-06 00:00:00 | default date | 2011-02-06 00:00:00 | default date
 |  |  |  |  |  |  |  | 2011-03-01 00:00:00 | Dates interest rate changed | 2011-03-01 00:00:00 | Dates interest rate changed
 |  |  |  |  |  |  |  | 2013-02-15 00:00:00 | Date Loan Matures | 2013-02-15 00:00:00 | Date Loan Matures
I have the above set of date columns |  |  |  |  |  |  |  | the dates need to automatically end up sorted as above
 |  |  |  |  |  |  |  |  |  |  | array-formula's, so confirm with ctrl+shift+enter, not just enter.
 |  |  |  |  |  |  |  |  | http://www.excelforum.com/excel-general/840885-sort-array-of-dates-into-single-column.html?p=2836959
Spreadsheet: 40568d1238936818-multiple-conditioning-copy20br
Sheet: Sheet1

MONTH | AMOUNT |  | T1 |  | T2 |  | T3 |  | T4 |  |  |  |  |  |  |  |  |  |  | DISBURSED |  | New | T1
DEC08 | 955000 |  | 2 |  | 1 |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  | PENDING |  | T/O | T2
[NAME] | ACCOUNTS |  | 305000 |  | 200000 |  | 200000 |  | 250000 |  |  |  |  |  |  |  |  |  |  | RETURNED |  | T/U | T3
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RE-SENT |  | AUTO | T4
ACCOUNT NAME |  |  | ACCOUNT | TYPE | REQ | O/S | NET | STATUES | DATE | OFFICER | AOD
TEST |  |  | 12346 | AUTO | 250000 | 195000 | 55000 | DISBURSED | 2008-05-01 00:00:00 | T1 | [NAME]
TEST2 |  |  | 432105 | T/O | 190000 | 0 | 190000 | DISBURSED | 2008-05-01 00:00:00 | T2 | [NAME]
TEST3 |  |  | 111113 | T/O | 200000 | 0 | 200000 | DISBURSED | 2008-05-01 00:00:00 | T3 | [NAME]
TEST4 |  |  |  | AUTO | 250000 |  | 250000 |  |  | T1
TEST5 |  |  |  | T/O | 190000 |  | 190000 |  |  | T2
TEST6 |  |  |  | AUTO | 200000 |  | 200000 |  |  | T3
TEST7 |  |  |  | AUTO | 250000 |  | 250000 |  |  | T4
TEST8 |  |  |  | T/O | 190000 |  | 190000 |  |  | T1
TEST9 |  |  |  | AUTO | 200000 |  | 200000 |  |  | T2
TEST10
TEST11
TEST12
TEST13
TEST14
TEST15