tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 151978d1335201993-excel-2007-need-vlookup-formula-to-return-a-relative-formula-book1
Sheet: Sheet1

[NAME] | copies | Rate 2 | Margins |  |  |  | Cost |  |  | [NAME]
A | 6 | 3 | 2 |  |  |  |  |  | A
A | 2 | 2 | 1 |  |  |  |  |  | B
B | 4 | 3 | 2 |  |  |  |  |  | C
B | 3 | 4 | 2
C | 2 | 5 | 3
Spreadsheet: 866513d1713445501-code-to-description-code-to-description-example
Sheet: Admin Worksheet

Date |  | Vindustries Job ID #
 |  | Completion Date:
Customer: | Black Hills Energy | Customer WO #
Contact:
[NAME]:
Code | Description | Cost | Qty | Total
Scope of Work Detail:
Job Total
Spreadsheet: b07f0f82-9d10-4d03-a334-e4dfe71f2091
Sheet: Fields 5-A

Permit No.: |  |  | WQ0003405 |  |  |  | Facility Name: |  | Elm City WWTP |  |  |  |  |  | County: | Wilson |  | Month: |  |  | Year:
Did irrigation occur at this facility? |  |  |  |  |  |  | Field Name: |  | 5 |  | Field Name: |  | 6 |  | Field Name: |  | 7 |  | Field Name: |  | A
 |  |  |  |  |  |  | Area (acres): |  | 7.4 |  | Area (acres): |  | 7.3 |  | Area (acres): |  | 8.75 |  | Area (acres): |  | 6.09
 |  |  |  |  |  |  | Cover Crop: |  | Fescue |  | Cover Crop: |  | Fescue |  | Cover Crop: |  | Fescue |  | Cover Crop: |  | Fescue
 |  |  |  |  |  |  | [NAME] (in): |  | 0.35 |  | [NAME] (in): |  | 0.35 |  | [NAME] (in): |  | 0.35 |  | [NAME] (in): |  | 0.1
 |  |  |  |  |  |  | Annual Rate (in): |  | 78.52 |  | Annual Rate (in): |  | 78.52 |  | Annual Rate (in): |  | 78.52 |  | Annual Rate (in): |  | 14.58
Day | Weather |  |  | Freeboard |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Primary Lagoon | 301 Lagoon | Secondary Lagoon | Volume Applied | Time   Irrigated | Daily   Loading | [NAME] Loading | Volume Applied | Time    Irrigated | Daily   Loading | [NAME] Loading | Volume Applied | Time   Irrigated | Daily   Loading | [NAME] Loading | Volume Applied | Time   Irrigated | Daily   Loading | [NAME] Loading
 |  | ºF | in | ft | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: kimberly_watson__20555__imbalsumm0108
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -132997 | -79207 | -39109 | -92874
2 | -112568 | -53005 | -40001 | -99950 |  |  |  |  |  |  |  |  |  | Avg
3 | -144086 | -117734 | -40000 | -65000 |  |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
4 | -151514 | -150002 | -55771 | -56162
5 | -151656 | -150001 | -55077 | -56162
6 | -153786 | -150001 | -52179 | -56162 |  |  |  |  |  | 2001-01-01 00:00:00 | -715680 | -705664 |  | 8.21
7 | -138012 | -58418 | -1800 | -79718 |  |  |  |  |  | 2001-02-01 00:00:00 | -661568 | -648307 |  | 5.62
8 | -144890 | -82115 | -48170 | -109950 |  |  |  |  |  | 2001-03-01 00:00:00 | -1831536 | -1828209 |  | 4.98
9 | -123111 | -64023 | -1611 | -59950 |  |  |  |  |  | 2001-04-01 00:00:00 |  | -3486797 |  | 4.87
10 | -150424 | -90703 |  | -59808 |  |  |  |  |  | 2001-05-01 00:00:00 | -3735499 | -3753054 |  | 3.82
11 | -159237 | -138136 | -58416 | -79950 |  |  |  |  |  | 2001-06-01 00:00:00 |  | -5025875 |  | 3.2
12 | -153130 | -130080 | -56945 | -79950 |  |  |  |  |  | 2001-07-01 00:00:00 | -4565965 | -4525416 |  | 2.77
13 | -136048 | -141366 | -105213 | -100666
14 | -141659 | -117756 | -48404 | -72615
15 | -141744 | -97671 | -39144 | -73315
16 | -131618 | -109589 | -88744 | -109950
17 | -142840 | -150006 | -124297 | -120000
18 | -100414 | -81014 | -83965 | -102848
19 | -107048 | -80107 | -83003 | -111256
20 | -119742 | -81015 | -57920 | -97982
21 | -141966 | -127453 | -96866 | -114950
22 | -137154 | -120862 | -74547 | -91154
23 | -134417 | -119653 | -82490 | -96940
24 | -135500 | -150005 | -80514 | -64929
25 | -135337 | -95571 | -68776 | -107555
26 | -134313 | -95571 | -71537 | -110769
27 | -131544 | -90089 | -71973 | -112890
28
29
30
31
 |  |  |  | 2001-07-31 00:00:00 |  |  | 460835.37
 |  |  |  | 2001-08-27 00:00:00
 | CBS Volume
 |  |  |  | 111236
Spreadsheet: 755962d1637206766-formula-to-return-header-for-2-highest-values-in-a-row-into-the-same-cell-combo-sorter
Sheet: INPUT

 |  | GIFT SETS
 |  |  |  |  |  |  |  |  |  |  | BY | MG | CI | SP | WG | ST | WH | GN | Tried 1st |  | Tried 2nd |  |  | Desired Effect
STAPLE 1 |  | STAPLE 1 | XXXXX |  | CONSTANT |  |  |  |  | STAPLE 1 |  | -125 | -117 | -120 |  |  |  |  |  |  |  |  |  | CI, SP
STAPLE 2 |  | STAPLE 2 | XXXXX |  | CONSTANT |  |  |  |  | STAPLE 2 |  | 15 | 18 | 21 |  |  |  |  |  |  |  |  |  | SP, CI
PICK 3 |  |  | XXXXX |  | ONLY FOR LARGER SETS |  |  |  |  | PICK 3
PICK 4 |  | 4TH | 4TH SUB | +1.5 | PL-/PL+ |  |  |  |  | PICK 4 |  | 160 | 150 | 160 |  |  |  |  |  |  |  |  |  | MG, SP
PICK 5 |  | 5TH | 5TH SUB | +1.5 | PL-/PL+ OR SU FAV & DOG |  |  |  |  | PICK 4 sub |  | -190 | -185 | -170 |  |  |  |  |  |  |  |  |  | SP, CI
PICK 6 |  | 6TH | 6TH SUB | +1.5 |  |  |  |  |  | PICK 5
PICK 7 |  | 7th | 7th SUB | +1.5 |  |  |  |  |  | PICK 5 sub
PICK 8 |  | LRG | XXXXX |  | LARGE |  |  |  |  | PICK 6
PICK 9 |  | XL |  |  | XL SET |  |  |  |  | PICK 6 sub
PICK 10 |  | JUM |  |  | JUMBO SET |  |  |  |  | PICK 7
 |  |  |  |  |  |  |  |  |  | PICK 7 sub
 |  |  |  |  |  |  |  |  |  | PICK 8
 |  |  |  |  |  |  |  |  |  | PICK 9
1 |  | 2 |  | 3 |  | 4 |  |  |  | PICK 10
5 |  | 6 |  | 7 |  | 8
9 | 10 | 11 | 12
13 | 14 | 15 | 16
Spreadsheet: 0f2d63ef-5d5e-4688-90bf-cf576269e205
Sheet: Sheet1

Financiële verantwoording behorende bij aanvraag tot vaststelling van de subsidie voor: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Subsidieaanvrager |  | ….
Periode |  | ….
Verleningsnummer |  | ….
Contactpersoon |  | ….
Integrale uurprijs |  | 1 | per uur
Project 1: ….
Activiteit 1: |  | Begroting |  |  | Subsidieverlening |  |  |  | Realisatie
(omschrijving) |  | uren | bedrag |  | Org. | Perc. | Bedrag |  | uren | bedrag
Inzet medewerkers |  | 0 | 0 |  | PNH | 0 | 0 |  | 0 | 0
Overige activiteitgebonden kosten |  |  | 0 |  | Overige | 0 | 0 |  |  | 0
 |  |  | 0 |  |  |  |  |  |  | 0
Activiteit-specifieke opbrengsten |  |  | 0 |  |  |  |  |  |  | 0
[NAME] |  |  | 0 |  |  |  | 0 |  |  | 0
Activiteit 2: |  | Begroting |  |  | Subsidieverlening |  |  |  | Realisatie
(omschrijving) |  | uren | bedrag |  | Org. | Perc. | Bedrag |  | uren | bedrag
Inzet medewerkers |  | 1 | 1 |  | PNH | 0 | 0 |  | 0 | 0
Overige activiteitgebonden kosten |  |  | 0 |  | Overige | 0 | 0 |  |  | 0
 |  |  | 1 |  |  |  |  |  |  | 0
Activiteit specifieke opbrengsten |  |  | 0 |  |  |  |  |  |  | 0
[NAME] |  |  | 1 |  |  |  | 0 |  |  | 0
Project 2: ….
Activiteit 3: |  | Begroting |  |  | Subsidieverlening |  |  |  | Realisatie
(omschrijving) |  | uren | bedrag |  | Org. | Perc. | Bedrag |  | uren | bedrag
Inzet medewerkers |  | 0 | 0 |  | PNH | 0 | 0 |  | 0 | 0
Overige activiteitgebonden kosten |  |  | 0 |  | Overige | 0 | 0 |  |  | 0
 |  |  | 0 |  |  |  |  |  |  | 0
Activiteit specifieke opbrengsten |  |  | 0 |  |  |  |  |  |  | 0
[NAME] |  |  | 0 |  |  |  | 0 |  |  | 0
[NAME]…
Spreadsheet: 00a8b67d-f0d5-4e99-ad8a-e0b6bb7bd433
Sheet: Non-Western

NON-WESTERN CAR
Course color corresponds with term of offering. BLUE for Spring semester, PURPLE for J-term, GREEN for both Spring and J-term.
[NAME] | ARTH 210 |  | cross-listed with CLAS 210
 | ARTH 211 |  | cross-listed with CLAS 211
 | ARTH 227
 | ARTH 228
 | ARTH 235
 | ARTH 381 |  | Fall 2012(Coptic Art in Egypt)
Asian Studies | ASTU 230 |  | cross-listed with FLET 230
 | ASTU 231 |  | cross-listed with FLET 231
 | ASTU 232 |  | cross-listed with FLET 232
 | ASTU 233 |  | cross-listed with FLET 233
 | ASTU 290 |  | cross-listed with HIST 290
 | ASTU 292 |  | cross-listed with FILM 292
 | ASTU 381 |  | Sp 2013(Japanese Literature: [NAME])
 | ASTU 390
Black Studies | BLST 160
Chinese | CHIN 221
Classical Studies | CLAS 210 |  | cross-listing with ARTH 210
 | CLAS 211 |  | cross-listed with ARTH 211
 | CLAS 482 |  | Sp 2013-Greek and Roman Egypt
Communication Studies | COMM 332
Economics | ECON 481 |  | Fall 2009 (Contemporary China's Economy)
English | ENGL 272
 | ENGL 369
 | ENGL 370
Environmental Studies | EVST 245 |  | cross-listed with INST 245
Film Studies | FILM 292 |  | cross-listed with ASTU 292
Foreign Literature in English Translation | FLET 230 |  | cross-listed with ASTU 230
 | FLET 231 |  | cross-listed with ASTU 231
 | FLET 232 |  | cross-listed with ASTU 232
 | FLET 233 |  | cross-listed with ASTU 233
 | FLET 248
 | FLET 249
History | HIST 100 |  | Modern Iraq only
 | HIST 100 |  | Intro to Southeast Asian History
 | HIST 100 |  | History of Ancient Egypt
 | HIST 101 |  | History of Ancient Egypt
 | HIST 221 |  | cross-listed with JAPN 221
 | HIST 251
 | HIST 252
 | HIST 281
 | HIST 282
 | HIST 290
 | HIST 320
 | HIST 332
 | HIST 347
 | HIST 348
 | HIST 361
 | HIST 365
 | HIST 367
 | HIST 381 |  | J-term 2013-(The US and SE Asia)
 | HIST 391
 | HIST 392
 | HIST 393 |  | Spring 2013(Modern Indonesian History)
 | HIST 394
 | HIST 395
 | HIST 396
 | HIST 397
Honors Program | HONR 215
 | HONR 259
 | HONR 290
International Studies | INST 245 |  | cross-listed with EVST 245
Japanese | JAPN 220
 | JAPN 221 |  | cross-listed with HIST 221
 | JAPN 381 & 382
Mathematics | MATH 270
Music | MUSC 240
 | MUSC 381 |  | J-term 2013(Music of Brazil)
Philosophy | PHIL 220
 | PHIL 343
 | PHIL 381 |  | Spring 2010 (Confucian Tradition)
Political Science | PSCI 328
 | PSCI 333
 | PSCI 334
 | PSCI 335
 | PSCI 336
 | PSCI 337
 | PSCI 338
 | PSCI 381 |  | Spring 2011 (Political Islam in the Middle East)
Psychology | PSYC 160
 | PSYC 162
 | PSYC 175
 | PSYC 180
 | PSYC 186
Religious Studies | RELS 221
 | RELS 223
 | RELS 225
 | RELS 229
 | RELS 245
 | RELS 248
Sociology | SOCI 210
 | SOCI 215
 | SOCI 230
 | SOCI 260
 | SOCI 265
 | SOCI 273
 | SOCI 383 |  | J-Term 2009, 2011 (Global, Env, Social Dynamics Brazil)
 | SOCI 383 |  | J-Term 2008, 2010 (Globalization & Social Change Ghana)
Spreadsheet: 173518-increase-decrease-mifzal
Sheet: Sheet1

Branch | Current |  |  |  |  |  |  |  |  | if value has whole number that's increase |  |  |  |  |  |  |  | TOTAL
 | Jan | Feb | Mar | Apr | May | Jun |  |  |  | Jan-Feb | Feb-Mar | [NAME] | Apr-May | May-jun |  | Increase | decrease | Increase or Decrease
AKU | 29 | 28 | 35 | 25 | 21 | 29
MET | 934 | 877 | 879 | 916 | 869 | 923
GAL | 110 | 102 | 108 | 106 | 79 | 104
GML | 92 | 95 | 104 | 104 | 105 | 119
KAD | 157 | 174 | 156 | 169 | 180 | 170
KLM | 171 | 166 | 170 | 204 | 229 | 230
KLT | 121 | 135 | 130 | 137 | 123 | 135
KA1 | 141 | 137 | 153 | 148 | 142 | 144
KKY | 217 | 235 | 259 | 281 | 282 | 299
KUR | 77 | 89 | 82 | 86 | 96 | 93
LBC | 24 | 33 | 26 | 30 | 23 | 28
MAL | 0 | 3 | 0 | 1 | 1 | 0
MTL | 164 | 160 | 165 | 161 | 136 | 154
MTR | 120 | 115 | 116 | 101 | 103 | 108
MWL | 122 | 133 | 134 | 136 | 138 | 137
NEG | 59 | 56 | 53 | 65 | 79 | 78
NUG | 40 | 43 | 46 | 45 | 44 | 48
C11 | 797 | 751 | 773 | 789 | 760 | 828
PTL | 254 | 235 | 211 | 237 | 277 | 240
IRS | 34 | 31 | 31 | 45 | 40 | 48
TRC | 202 | 221 | 215 | 249 | 246 | 247
Total
Spreadsheet: 142757d1330004052-pulling-out-names-that-are-in-both-lists-and-those-that-are-not-example
Sheet: DB

Userform | Userform | Userform | This column is nothing to do with the userform | Userform | Userform | Userform | Userform | Userform | Userform | Userform | Userform
Family | Date | Time | Date+Time | St. 1 | St. 2 | St. 3 | St. 4 | St. 5 | St. 6 | St. 7 | St. 8
 |  |  |  |  |  |  |  |  |  |  | 10 | 1st entry
Family 10 | 2004-08-15 00:00:00 | 08:14:00 |  | 8 |  | 8 | 4 | 6 | 7 | 5 | 8 | 2nd entry
Family 4 | 2007-02-25 00:00:00 | 09:55:00 |  |  | 5 | 6 | 5 | 2 | 1 | 1 |  | 3rd entry
Spreadsheet: 883642d1732282951-combine-certain-rows-in-an-excel-transcript-rearrange-rows-for-excel-forum
Sheet: Original data

Given Data |  | Desired Output
[Speaker] Time
[[NAME]] 18:29:40 |  | [[NAME]]
The 2024. |  | The 2024 annual meeting is now open. First, we'll go ahead and take roll |  | The 2024. annual meeting is now open. First, we'll go ahead and take roll. [NAME]?
 |  | [NAME]? |  | [Frances’s iPad]
[[NAME]] 18:29:42 |  | [Frances’s iPad] |  | Here.
annual meeting is now |  | Here. |  | [[NAME]]
 |  | [[NAME]] |  | Okay, and [NAME] is not going to attend.
[[NAME]] 18:29:47 |  | Okay, and [NAME] is not going to attend. |  | [[NAME]]
open. First, we'll go ahead and take roll. |  | [[NAME]] |  | Let's start with a  review of the [NAME] proposal
 |  | Let's start with a review of the [NAME] proposal |  | [[NAME]]
[[NAME]] 18:29:53 |  | [[NAME]] |  | Let's read the minutes first
[NAME]? |  | Let's read the minutes first
[Frances’s iPad] 18:29:58
Here.
 |  | Original data format
[[NAME]] 18:30:10 |  | [Name] Time stamp
Okay, and [NAME] is not going to attend. |  | Spoken words
[[NAME]] 18:30:20 |  | [Name] Time stamp
Let's start with a |  | Spoken words
[[NAME]] 18:30:26 |  | [Name] Time stamp
review of the [NAME] |  | Spoken words
[[NAME]] 18:30:35
proposal
[[NAME]] 18:30:42
Let's read the minutes first
Spreadsheet: 686661d1594740329-currency-subtraction-issue-price-increase_eh
Sheet: Sheet1

Customer | Current ACV | Uplift | Total | Decrease price by | Proposed | Note | 5% uplift | GMB | Exp | Difference (£) | Difference (%)
Proposal 1 (5% uplift), no GMB & experiences | 3969.12 | 0.05 |  | 0.02 |  | Added 5% uplift (not paid as part of current contract) |  | 1200 | 2500
Proposal 2 (5% uplift), + GMB, no experiences | 3969.12 | 0.05 |  |  |  | Added 5% uplift (not paid as part of current contract) |  | 1200 | 2500
Proposal 2 (5% uplift), no GMB, with experiences | 3969.12 | 0.05 |  |  |  | Added 5% uplift (not paid as part of current contract) |  | 1200 | 2500
Proposal 2 (5% uplift), GMB AND experiences | 3969.12 | 0.05 |  |  |  | Added 5% uplift (not paid as part of current contract) |  | 1200 | 2500
Spreadsheet: 165539d1341259632-excel-2007-index-and-match-with-duplicates-book-bprime-oeldere-
Sheet: GREAT SUCCESS

martial Artist |  | Values |  | Top 6  Martial Artists |  |  | Top 6 Values
[NAME] |  | 9 |  | [NAME] |  |  | 10 |  |  |  | i have a list of 50 categories in column B
[NAME] |  | 8 |  | [NAME] |  |  | 9 |  |  |  | i have a list of 50 values in column D
[NAME] |  | 7 |  | [NAME] |  |  | 8 |  |  |  | i have the top 6 values in column I (populated by six of these type of functions =LARGE(D2:D106,2)
Chow-Yun Fat |  | 5 |  | [NAME] |  |  | 7 |  |  |  | column f is where i am using this index statement to show the corresponding value from column B/I : =INDEX(B2:B300,MATCH(I4,D2:D300,0),1)
[NAME] |  | 5 |  | Chow-Yun Fat |  |  | 5
[NAME] |  | 10 |  | [NAME] |  |  | 4 |  |  |  | But i am getting duplicates in column F because excel stops at the first matched value.
[NAME] |  | 4
[NAME] |  | 7 |  |  |  |  |  |  |  |  | should i edit the index statement (as i suspect) and in what way?
 |  |  |  |  |  |  |  |  |  |  | or should i edit the large statement (less likely i think)?
 |  |  |  |  |  |  |  |  |  |  | first post
 |  |  |  |  |  |  |  |  |  |  | thanks for the help
Spreadsheet: 101789d1299829797-populating-an-invoice-from-two-timesheets-invoice_1101-5_test
Sheet: INVOICE

 |  | INVOICE for Design Services |  |  |  |  |  |  |  | no. | 1101-5
 |  | INVOICE SUMMARY
 | project |  | Landscape Design Consulting Services
 | location |  | Varies
 | project number |  | 1101
 | invoice date |  | 03.11.11
 | to |  | [NAME]
 |  |  | 459 [NAME]
 |  |  | Everywhere, USA 12345
 | total amount due this invoice |  |  |  |  |  |  |  |  | 7735
 | for services provided |  | 02.26.11 | to | 03.11.11
 |  | FEE SUMMARY
 | fee basis |  | hourly
 |  | FEE DETAIL
 |  | project |  |  |  |  | rate | hours | total
 | 1101 | SMITH RESIDENCE |  |  |  |  | 100 | 23.25 | 2325
 | 1102 | [NAME] |  |  |  |  | 110 | 5 | 550
 |  | MUSEUM GROUNDS |  |  |  |  | 90 | 45 | 4050
 |  | WHISPERING HILLS |  |  |  |  | 90 | 9 | 810
 |  |  |  |  |  |  |  |  | 0
 | current total/ services |  |  |  |  |  |  | 82.25 |  | 7735
 | current reimbursable expenses | expense |  |  |  |  | miles | per mi | total
 |  |  |  |  |  |  |  | 0.51 | 0
 | current total/ reimbursable expenses |  |  |  |  |  |  |  |  | 0
 | current grand total with expenses |  |  |  |  |  |  |  |  | 7735
Spreadsheet: 143584d1330467424-look-up-a-value-with-multiple-criteria-theoretically-should-be-a-simple-index-match-excel-forum-example2-modified-by-tigeravatar-
Sheet: Sheet2

 | [NAME] | [NAME] | Becky | [NAME] | Samia | Sue | Colton | [NAME]
2012-02-23 00:00:00 | OFF | OFF | OFF | OFF | VAC | VAC | OFF | OFF | X
2012-02-24 00:00:00 | DAY | DAY | DAY | DAY | VAC | VAC | OFF | BKO
2012-02-25 00:00:00 | OFF | OFF | OFF | OFF | VAC | VAC | OFF | OFF
2012-02-26 00:00:00 | BKO | OFF | OFF | OFF | VAC | VAC | OFF | OFF | X
2012-02-27 00:00:00 | OFF | OFF | OFF | OFF | VAC | VAC | OFF | OFF
2012-02-28 00:00:00 | OFF | OFF | OFF | OFF | VAC | VAC | OFF | OFF | X
2012-02-29 00:00:00
2012-03-01 00:00:00 | BKO | DAY | DAY | DAY | VAC | VAC | OFF | DAY
2012-03-02 00:00:00 | DAY | ABS | DAY | DAY | VAC | VAC | OFF | DAY | X
2012-03-03 00:00:00 | DAY | DAY | DAY | DAY | VAC | VAC | OFF | DAY
2012-03-04 00:00:00 | DAY | ABS | DAY | DAY | VAC | VAC | OFF | DAY
2012-03-05 00:00:00 | DAY | OFF | OFF | OFF | VAC | VAC | OFF | DAY | X
2012-03-06 00:00:00 | OFF | OFF | OFF | OFF | VAC | VAC | OFF | OFF
2012-03-07 00:00:00
Spreadsheet: 125889d1319342264-multiple-matching-and-indexing-with-null-logic-test
Sheet: 1

part Number
90-4523
90-6544
33-778
34-5432
90-3344
90-7754
54-7886
Spreadsheet: 224648d1364680325-months-after-formatting-color
Sheet: Foglio1

2013-03-14 00:00:00 | <--- | insertion date order
2013-03-15 00:00:00
2013-03-16 00:00:00
2013-03-17 00:00:00
2013-03-18 00:00:00
2013-03-19 00:00:00
2013-03-20 00:00:00
2013-03-21 00:00:00
2013-03-22 00:00:00
2013-03-23 00:00:00
2013-03-24 00:00:00
2013-03-25 00:00:00
2013-03-26 00:00:00
2013-03-27 00:00:00
2013-03-28 00:00:00
2013-03-29 00:00:00
2013-03-30 00:00:00
2013-03-31 00:00:00
2013-04-01 00:00:00
2013-04-02 00:00:00
2013-04-03 00:00:00
2013-04-04 00:00:00
2013-04-05 00:00:00
2013-04-06 00:00:00
2013-04-07 00:00:00
2013-04-08 00:00:00
2013-04-09 00:00:00
2013-04-10 00:00:00
2013-04-11 00:00:00
2013-04-12 00:00:00
2013-04-13 00:00:00
2013-04-14 00:00:00 |  | 2013-04-14 00:00:00 | <----- | color to red when the day TODAY () is the 14/04/2013
2013-04-15 00:00:00
2013-04-16 00:00:00
2013-04-17 00:00:00
Spreadsheet: 188838d1351005182-calculating-value-between-two-points-solar
Sheet: Oct

 |  | Service Dates: |  | 2011-10-04 00:00:00 |  |  | thru | 2011-11-01 00:00:00
 | PG&E RATES
 | T1 |  | T2 |  | T3 |  | T4 |  | T5
 | Baseline |  | 101-130% |  | 131-200% |  | 201-300% |  | 301%+
 | 998.002 |  | 998.002 | 1297.4026 | 1297.4026 | 1996.004 | 1996.004 | 2994.006 | 2994.006
 | 0.12233 |  | 0.13907 |  | 0.3018 |  | 0.3418 |  | 0.3418
 | 0 |  |  | 0 |  | 0 |  | 0
 | RATE CHARGES
 | T1 |  | T2 |  | T3 |  | T4 |  | T5
 | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Total Consumed |  |  | PG&E |  |  |  | Solar
 | 0 |  |  | 0 |  |  |  | 0
 | Total Charges |  |  | PG&E |  |  |  | Solar Savings
 |  |  |  | Billed |  | Min
 | 0 |  |  | 0 |  | 0 |  | 0
 |  |  |  |  | 0
 | Date | Solar | Used | Date | Solar | Used |  | Total
 |  |  |  |  |  |  |  | Solar | 0
 |  |  |  |  |  |  |  | Used | 0
 |  |  |  |  |  |  | [NAME] |  | #N/A
 |  |  |  |  |  |  | Estimate |  | 0
 |  |  |  |  |  |  | Actual |  | 0
 |  |  |  |  |  |  | Estimate
 |  |  |  |  |  |  |  |  | Oct | Nov
 |  |  |  |  |  |  | Proposed Prod |  | 530 | 397
 |  |  |  |  |  |  | Days |  | 31 | 30
 |  |  |  |  |  |  | Per Day |  | 17.09677419354839 | 13.23333333333333
 |  |  |  |  |  |  | Billed Days |  | 0 | 0
 |  |  |  |  |  |  | Total |  | 0 | 0
 |  |  |  |  |  |  |  | T2 | -998.002
 |  |  |  |  |  |  |  |  | 0.01674
 |  |  |  |  |  |  |  | T3 | -1297.4026
 |  |  |  |  |  |  |  |  | 0.16273
 |  |  |  |  |  |  |  | T4 | -1996.004
 |  |  |  |  |  |  |  |  | 0.03999999999999998
Spreadsheet: 113884d1309776032-compiling-mean-by-date-hurricane-database2
Sheet: Mean TD Integer Date

Mean |  | 1950 | 1951 | 1952 | 1953 | 1954 | 1955 | 1956 | 1957 | 1958 | 1959 | 1960 | 1961 | 1962 | 1963 | 1964 | 1965 | 1966 | 1967 | 1968 | 1969 | 1970 | 1971 | 1972 | 1973 | 1974 | 1975 | 1976 | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 | 1983 | 1984 | 1985 | 1986 | 1987 | 1988 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
 | 1st
 | 2nd
 | 3rd
 | 4th
 | 5th
 | 6th
 | 7th
 | 8th
 | 9th
 | 10th
 | 11th
 | 12th
 | 13th
 | 14th
 | 15th
 | 16th
 | 17th
 | 18th
 | 19th
 | 20th
 | 21st
 | 22nd
 | 23rd
 | 24th
 | 25th
 | 26th
 | 27th
 | 28th
 | 29th
 | 30th
 | 31st
 | 32nd
 | 33rd
 | 34th
 | 35th
 | 36th
 | 37th
 | 38th
 | 39th
Spreadsheet: 875529d1722117061-calculating-accounts-receivables-excel-forum-sample-jumanarimawi-
Sheet: Working capital

Working Capital
Sanad Credit Financial Model |  |  |  |  |  |  |  |  |  | Index!A1
Financial Model Currency: JOD
 |  |  | Financial Month End
 |  |  | Financial Year
 | Working capital
 |  |  | Change in Receivables
 |  |  | OPEX
 |  |  | Payables (30days)
 |  |  | Change in Payables
 |  |  | Total change in Working Capital
Spreadsheet: daren_farmer__5075__HPLN0525
Sheet: Sheet1

HPLN0525.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - May 25, 2001
 |  |  |  |  |  | **Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-05-25 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Sandhills |  | Enron | 8 | 8
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 672525d1586896801-function-to-pull-entire-row-based-on-criteria-example-month
Sheet: Data

 |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00
[NAME] | Project A | [NAME] | 5
A012345 | Project A | [NAME] | 55
A009876 | Project A | [NAME] | 55
[NAME] | Project B | [NAME] |  | 20
A012345 | Project B | [NAME] | 93 | 2090
[NAME] | Project B | [NAME] |  | 60
[NAME] | Project C | [NAME] |  |  | 80
A012345 | Project C | [NAME]
A009876 | Project C | [NAME] |  |  | 87