tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 885191d1734619348-calculating-bus-fare-through-distance-sample-distance
Sheet: Feuil2

 |  |  |  |  |  |  |  | Ticket price | distance <
Line A distance in m | A | B | C | D | E | F |  | 0 | 0
A |  | 9000 | 14000 | 19000 | 2200 | 27000 |  | 3 | 7000
B | 9000 |  | 5000 | 10000 | 13000 | 18000 |  | 4 | 15000
C | 14000 | 5000 |  | 5000 | 8000 | 13000 |  | 5 | 22000
D | 19000 | 10000 | 5000 |  | 3000 | 8000 |  | 6 | 28000
E | 22000 | 13000 | 8000 | 3000 |  | 5000 |  | 7 | 38000
F | 27000 | 18000 | 13000 | 8000 | 5000 |  |  | 8 | 44000
 |  |  |  |  |  |  |  | 9 | 52000
 |  |  |  |  |  |  |  | 12 | 52000
from | A
to | F
distance
price
Spreadsheet: 480646d1474011596-comparing-2-workbooks-looking-for-differences-in-quatities-example2
Sheet: Sheet1

File Name | Quantity | Mass
GROOVED INSERT [NAME]) | 50 | 0
Union_SS-400-6_1_4 | 50 | 0.04
Union Tee_SS-400-3_1_4 | 18 | 0.07
Stepped [NAME]) | 18 | 0.02
Gas Bar Bracket 1-GENCOA-GB-1-3-3500(0) | 16 | 0.17
2411.620(7) | 13 | 0.1
[NAME]) | 12 | 0.29
[NAME] GE50A (200 sccm)(0) | 9 | 0.87
SS_200_1_4ST_20020 | 8 | 0
SS_400_6_2_20217 | 8 | 0
2 Port Solenoid Valve(0) | 5 | 1.29
[NAME] (1000 sccm)(0) | 4 | 0.87
1 | 4 | 0.03
Union Elbow_SS-400-9_1_4 | 3 | 0.05
KF(QF) Stainless Steel Half Nipple(0) | 2 | 0.36
[NAME] 70 shore(0) | 2 | 0.05
[NAME] (SS with [NAME]), KF50(0) | 2 | 0.05
Cast Clamps (Aluminum), [NAME]) | 2 | 0.49
2411.600(2.5) | 2 | 0.03
2411.610(4.5) | 2 | 0.06
Outlet Filter 3238_200 | 2 | 3.83
Gas Bar-GENCOA-GB-1-3-3500(0) | 2 | 8.17
GAS BAR GAS BAR | 1 | 11111
Spreadsheet: 122189d1316648131-highlight-unlike-cells-conditional-format-book4-v2
Sheet: Sheet1

1001 | 1005
1002 | 1008
1003 | 1010
1004 | 1015
1005 | 1018
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
Spreadsheet: richard_ring__31585__newEnronEgyPECOChoice
Sheet: Active

N102 (8R) | REF02 (12) | REF02 (PR) | REF02 (NH) | REF02 (LO) |  | REF03 | REF02 (TZ) | DTM02 (150) | AMT02 (MA) | AMT02 (KC) | AMT02 (KZ) | REF03 (SPL) | REF02 (11)
 |  | Rate | Rate |  |  | [NAME] | [NAME] | Start | Peak
Customer Name | Account No. | Class | Code | Strata | Rate Code Description | Type | Cycle | Date | Dmd | [NAME] Obl. | Trx Obl. | [NAME] | Enron Acct #
[NAME] | 231172239726 | GS | CM | 6 |  | Mo | 11 | 1999-04-16 00:00:00 | 48 | 27.3 | 27.3 | RICH PE | 41350002
EAGEL FUEL CO | 211661100811 | GS | CM | 1 | Commercial measured | Mo |  | 1999-01-26 00:00:00 | 5.1 | 5 | 5 | PASSYUNK | 41050002 | Closed?
HOLLYWOOD OIL CO | 400708742517 | GS | CM | 4 | Commercial measured | Mo |  | 1999-01-12 00:00:00 | 18.5 | 13 | 13 | BYBERRY | 41060002
CHELTENHAM SHOPPING | 040180742601001 | PD | PD | 57 | Primary Distribution Power | Mo |  | 1999-02-26 00:00:00 | 525.8 | 415.4 | 415.4 | CEDARBRO | 41150002
CHELTENHAM SHOPPING | 401807861018 | GS | C | 9 | Commercial - no demand | Mo |  | 1999-01-28 00:00:00 | 8.2 | 2 | 2 | MIDD PE | 41000002
TETRATEC CORP | 045103859151201 | GS | GS | 6 | General Service | Mo |  | 1999-01-15 00:00:00 | 390.5 | 356 | 356 | BYBERRY | 41030002
SDG MACERICH PROPERT | 502011678526 | GS | CH7 | 5 | Commercial Heat - Demand Forgiveness | Mo |  | 1999-02-01 00:00:00 | 34.1 | 19 | 19 | MIDD PE | 41020002
SUBURBAN AIR SPIRAL | 401570029512 | GS | CM | 4 |  | Mo | 15 | 2000-01-22 00:00:00 | 21.5 | 20 | 19.86 | PECO-ZONE | 41470002
WILLARD INC. | 450153081994 | GS | CM | 6 |  | Mo | 01 | 2000-02-02 00:00:00 | 57 | 33.47 | 33.26 | PECO-ZONE | 41480002
AMERICAN COLLEGE | 050219305101301 | HT | HT | 056 |  | Hr | 21 | 2000-02-01 00:00:00 | 867.6 | 889.7 | 865.73 | PECO-ZONE | 41500002
UNIVERSAL MACHINE CO | 4013046733312 | GS | CM | 6 |  | Mo | 13 | 2000-02-18 00:00:00 | 285.3 | 255.79 | 279.5 | PECO-ZONE | 41510002
WILLIARD INC | 040059308001501 | PD | PD | 60 |  | Mo | 05 | 2000-03-09 00:00:00 | 316 | 289.26 | 316.08 | PECO-ZONE | 41520002
LEHIGH VALLEY DAIRIES | [PHONE] | EO | POL | 73 |  | UM |  | 2000-06-02 00:00:00 |  |  |  | PECO-ZONE | 41530002
LEHIGH VALLEY DAIRIES | 040219321001801 | HT | HT | 53 |  | Hr | 21 | 2000-07-01 00:00:00 | 2876.8 | 2494.67 | 2725.96 | PECO-ZONE | 41540002
PRUDENTIAL INS CO AMER | 040089206001501 | HT | HT | 54 |  | Hr | 08 | 2000-07-13 00:00:00 | 5507.6 | 4924.31 | 5380.87 | PECO-ZONE | 41550002
Spreadsheet: 144972d1331228611-excel-2007-countif-with-multiple-parameters-test-sheet
Sheet: Sheet1

Date Received: 3/7/2012
 |  | SO # |  |  | YARDS ORDERED | REQUESTED                    SHIP DATE
 |  | 96976 |  |  | 17000 | 2012-03-07 00:00:00 |  | 31
 |  | 96977 |  |  | 1000 | 2012-03-07 00:00:00 |  | 3
 |  | 96978 |  |  | 21000 | 2012-03-07 00:00:00
 |  | 96979 |  |  | 10000 | 2012-03-07 00:00:00
 |  | 96980 |  |  | 10000 | 2012-03-07 00:00:00
 |  | 96981 |  |  | 5800 | 2012-03-07 00:00:00
 |  | 96982 |  |  | 7000 | 2012-03-07 00:00:00
 |  | 96171 |  |  | 250 | 2012-03-09 00:00:00
 |  | 96172 |  |  | 250 | 2012-03-09 00:00:00
 |  | 96170 |  |  | 2000 | 2012-03-09 00:00:00
 |  | 96180 |  |  | 300 | 2012-03-09 00:00:00
 |  | 96173 |  |  | 1000 | 2012-03-09 00:00:00
 |  | 96174 |  |  | 100 | 2012-03-09 00:00:00
 |  | 96830 |  |  | 250 | 2012-03-09 00:00:00
 |  | 96175 |  |  | 400 | 2012-03-09 00:00:00
 |  | 96176 |  |  | 1000 | 2012-03-09 00:00:00
 |  | 96168 |  |  | 7000 | 2012-03-09 00:00:00
 |  | 96169 |  |  | 2000 | 2012-03-09 00:00:00
 |  | 96178 |  |  | 1000 | 2012-03-09 00:00:00
 |  | 96177 |  |  | 300 | 2012-03-09 00:00:00
 |  | 96179 |  |  | 150 | 2012-03-09 00:00:00
 |  | 96789 |  |  | 500 | 2012-03-09 00:00:00
 |  | 96939 |  |  | 250 | 2012-03-09 00:00:00
 |  | 96941 |  |  | 1500 | 2012-03-09 00:00:00
 |  | 96940 |  |  | 250 | 2012-03-09 00:00:00
 |  | 698 |  | 502612 | 3 | 2012-03-07 00:00:00
 |  | 698 |  | 502615 | 3 | 2012-03-07 00:00:00
 |  | 95818 |  |  | 10000 | 2012-03-07 00:00:00
 |  | 96970 |  |  | 50 | 2012-03-07 00:00:00
 |  | 95879 |  |  | 4000 | 2012-03-09 00:00:00
 |  | 12345 |  |  | 400 | 2012-03-08 00:00:00
 |  | 12345 |  |  | 40 | 2012-03-08 00:00:00
 |  | 56789 |  |  | 60 | 2012-03-08 00:00:00
Spreadsheet: 756403d1637516056-dynamic-array-with-total-and-subtotals-filterxml-formula-with-total-and-subtotals-in-a-dynamic-array
Sheet: Totalização horizontal

 |  |  |  |  | Columns
 |  |  |  |  |  | 7 | 8 | 9 |  |  |  |  | 1 | 5 | 9 | 13
 |  |  | x> 0 ; x < 5 |  |  |  |  |  |  |  |  | 0 | 49 | 53 | 57 | 61
 |  |  | Condition |  | Matrix 5 x 4 |  |  |  |  |  |  | 0 | 65 | 69 | 73 | 77
 |  |  | 1 |  |  | 5 | 9 | 13 |  |  |  | Subtotal | 115 | 127 | 139 | 151
 |  |  | 0 |  | 17 | 21 | 25 | 29 |  |  |  | 0 | 17 | 21 | 25 | 29
 |  |  | 0 |  | 33 | 37 | 41 | 45 |  |  |  | 0 | 33 | 37 | 41 | 45
 |  |  | 1 |  | 49 | 53 | 57 | 61 |  |  |  | Subtotal | 50 | 58 | 66 | 74
 |  |  | 1 |  | 65 | 69 | 73 | 77 |  |  |  | Total | 165 | 185 | 205 | 225
 |  |  |  |  |  | 127 | 139 | 151
 |  |  |  |  |  | 58 | 66 | 74
 |  |  |  |  |  | 185 | 205 | 225
Spreadsheet: 696110d1600632792-dynamic-named-range-not-working-quite-right-demo-file
Sheet: Worksheet

Date | Start Date
 |  |  |  | [NAME]: "$B$2:INDEX(Worksheet[Start Date],COUNT(Worksheet[Start Date]))"
 |  |  |  | Should return all 4 Dates in column B, but only returns the first date.
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: C Well 20

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % Dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
C20 | 2017-08-08 00:00:00 |  | 2.14 |  |  |  |  |  |  |  |  | 1370 |  |  |  | 9.89
C20 | 2018-08-15 00:00:00 |  |  | 157 | 37.1 | 244 |  | 284 | <1 | 90.9 | 464 | 1320 |  |  |  | 7.9
Spreadsheet: 3fc48ddc-5957-45fe-9dad-ab46e442e3a1
Sheet: Sheet1

Release: Chicago Fed National Activity Index | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=219
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-07-28 10:45 AM CDT
 | Real-Time | Period
Name: | Start | End
Chicago Fed National Activity Index | 2011-05-23 00:00:00 | Current
Link:
http://www.chicagofed.org/webpages/publications/cfnai/index.cfm | 2011-05-23 00:00:00 | Current
Source:
Federal Reserve Bank of Chicago | 2011-05-23 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2011-05-23 00:00:00
2011-06-23 00:00:00
2011-07-25 00:00:00
2011-08-22 00:00:00
2011-09-26 00:00:00
2011-10-24 00:00:00
2011-11-21 00:00:00
2011-12-22 00:00:00
2012-01-26 00:00:00
2012-02-21 00:00:00
2012-03-26 00:00:00
2012-04-26 00:00:00
2012-05-21 00:00:00
2012-06-25 00:00:00
2012-07-23 00:00:00
2012-08-20 00:00:00
2012-09-24 00:00:00
2012-10-25 00:00:00
2012-11-26 00:00:00
2012-12-21 00:00:00
2013-01-22 00:00:00
2013-02-25 00:00:00
2013-03-25 00:00:00
2013-04-22 00:00:00
2013-05-20 00:00:00
2013-06-24 00:00:00
2013-07-22 00:00:00
2013-08-20 00:00:00
2013-09-23 00:00:00
2013-11-12 00:00:00
2013-11-27 00:00:00
2013-12-23 00:00:00
2014-01-23 00:00:00
2014-02-24 00:00:00
2014-03-24 00:00:00
2014-04-21 00:00:00
2014-05-22 00:00:00
2014-06-23 00:00:00
2014-07-21 00:00:00
Spreadsheet: 99314d1297977573-picking-up-a-particular-list-workbook22
Sheet: ALT Sheet1

0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
080 | 017 | 026 | 350 | 044 | 350 | 026 | 017 | 080 | 090
017 | 611 | 125 | 413 | 413 | 125 | 611 | 072 | 018 | 190
026 | 125 | 242 | 332 | 242 | 405 | 126 | 117 | 028 | 092
350 | 413 | 332 | 342 | 405 | 522 | 046 | 037 | 181 | 309
044 | 018 | 072 | 153 | 342 | 153 | 163 | 721 | 083 | 192
090 | 117 | 522 | 037 | 414 | 550 | 226 | 074 | 218 | 049
018 | 126 | 342 | 163 | 046 | 154 | 056 | 317 | 804 | 319
072 | 153 | 126 | 253 | 154 | 253 | 614 | 272 | 813 | 229
405 | 414 | 028 | 334 | 244 | 056 | 326 | 570 | 282 | 905
190 | 190 | 721 | 083 | 334 | 542 | 066 | 174 | 805 | 419
028 | 181 | 226 | 317 | 074 | 353 | 516 | 273 | 814 | 923
037 | 721 | 253 | 326 | 614 | 570 | 246 | 760 | 382 | 690
046 | 163 | 244 | 353 | 542 | 516 | 363 | 517 | 581 | 159
550 | 154 | 092 | 344 | 344 | 255 | 760 | 472 | 428 | 249
092 | 218 | 218 | 309 | 804 | 543 | 166 | 373 | 383 | 393
083 | 317 | 272 | 813 | 174 | 805 | 256 | 770 | 870 | 907
074 | 614 | 326 | 273 | 246 | 517 | 346 | 176 | 618 | 169
056 | 192 | 542 | 363 | 543 | 256 | 176 | 752 | 528 | 259
309 | 813 | 192 | 543 | 049 | 355 | 266 | 347 | 438 | 089
804 | 174 | 282 | 319 | 814 | 445 | 653 | 870 | 808 | 179
570 | 516 | 273 | 382 | 472 | 905 | 464 | 177 | 187 | 926
066 | 319 | 246 | 373 | 346 | 581 | 690 | 762 | 268 | 593
049 | 814 | 255 | 346 | 445 | 752 | 618 | 357 | 484 | 449
805 | 517 | 229 | 355 | 419 | 653 | 762 | 447 | 089 | 909
760 | 166 | 382 | 923 | 428 | 159 | 366 | 907 | 188 | 189
905 | 419 | 472 | 383 | 347 | 528 | 645 | 187 | 728 | 792
770 | 581 | 256 | 347 | 464 | 357 | 169 | 277 | 638 | 639
690 | 176 | 923 | 653 | 249 | 645 | 268 | 637 | 485 | 954
870 | 159 | 428 | 393 | 438 | 259 | 637 | 475 | 189 | 289
907 | 618 | 752 | 438 | 447 | 475 | 466 | 179 | 378 | 739
808 | 177 | 266 | 357 | 645 | 556 | 556 | 728 | 684 | 496
089 | 169 | 249 | 366 | 484 | 593 | 926 | 377 | 855 | 595
909 | 187 | 528 | 637 | 475 | 485 | 638 | 467 | 289 | 992
 | 179 | 762 | 593 | 466 | 557 | 467 | 557 | 865 | 389
 | 188 | 259 | 638 | 449 | 665 | 665 | 792 | 389 | 497
 | 189 | 268 | 377 | 485 | 954 | 639 | 378 | 848 | 659
 |  | 277 | 639 | 467 | 855 | 684 | 567 | 578
 |  | 926 | 378 | 954 | 567 | 567 | 739 | 866
 |  | 728 | 739 | 684 | 595 | 496 | 577
 |  | 792 | 389 | 496 | 865 | 865 | 766
 |  | 289 |  | 497 | 577 | 766 | 497
 |  | 992 |  | 848 | 659 | 659 | 578
 |  |  |  |  | 578 | 866 | 767
 |  |  |  |  |  | 767
Spreadsheet: 861401d1709272651-formatting-dates-dates
Sheet: Sheet1

DATE |  | Date-->Text to Columns-->Next-->Next-->Date-->MDY-->Finish
2024-03-04 00:00:00
2024-03-04 00:00:00
2024-03-04 00:00:00
2024-03-04 00:00:00
2024-03-06 00:00:00
2024-03-06 00:00:00
2024-03-06 00:00:00
2024-03-06 00:00:00
2024-03-11 00:00:00
2024-03-11 00:00:00
2024-03-11 00:00:00
2024-03-11 00:00:00
2024-03-11 00:00:00
2024-03-13 00:00:00
2024-03-13 00:00:00
2024-03-13 00:00:00
2024-03-13 00:00:00
2024-03-18 00:00:00
2024-03-18 00:00:00
2024-03-18 00:00:00
2024-03-18 00:00:00
2024-03-18 00:00:00
2024-03-20 00:00:00
2024-03-20 00:00:00
2024-03-20 00:00:00
2024-03-20 00:00:00
2004-03-25 00:00:00
2024-03-25 00:00:00
2024-03-25 00:00:00
2024-03-27 00:00:00
2024-03-27 00:00:00
2024-03-27 00:00:00
2024-03-27 00:00:00
2024-04-08 00:00:00
2024-04-08 00:00:00
2024-04-10 00:00:00
2028-04-10 00:00:00
2024-04-13 00:00:00
2024-04-13 00:00:00
2024-04-17 00:00:00
2024-04-17 00:00:00
2024-04-29 00:00:00
2024-05-13 00:00:00
2024-05-13 00:00:00
2024-05-29 00:00:00
2024-06-03 00:00:00
2024-06-03 00:00:00
2024-06-05 00:00:00
2024-06-17 00:00:00
Spreadsheet: 015f6bf2-01c2-497e-96e9-c21c09d97704
Sheet: sales

MONTH: |  |  |  | SPECIAL TRANSACTION REGISTER for ( [NAME] your office name here) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ORN
……………………….. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ……………
DO NOT CHANGE FORMAT
SPECIAL TRANSACTION REGISTER - SALES |  |  |  |  |  |  | Description: - | Apt=Apartment   Of=Office   P=Penthouse   WF=[NAME]=Warehouse    LC=Labor Camp |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] price or Expired date.
NOTE: FILL IN ALL CELLS |  |  |  |  |  |  | Use: | Res=Residence   Com=Commercial   Ret=Retail   Ind=Industrial   MU=Mixed Use (Striking wich use)   Agr=Agricultural   Uti=Utility/Government use
AD - Administrators initials |  |  | ORN: # |  | A, B, I, F & U |  | Buyer or [NAME] or [NAME] |  |  | Place an "x" in the box or No. of BRs |  |  |  |  |  |  |  | Please state the annual service charges e.g 30,000 |  |  |  |  |  |  |  | MARKET: P= Primary / S= Secondary
Insert Exact Date/Time |  |  | OFFICE |  | TYPE | Client Nationality | CLIENT |  |  |  | Description |  |  |  |  |  |  |  | Use |  |  |  | SERVICE | AREA | [NAME] | MARKET | LIST PRICE | COMM | SOLD/
DATE | TIME | AD | STR NO: | BRN | FORM |  | NAME | Apt | Of | P | WF | Villa | Land | WH | LC | [NAME] | Com | Ret | Ind | MU | Agr | Uti | CHARGES | SQ FT (BUA) | CODE (eg 392) | P or S | or BUDGET | % | EXPIRED
Spreadsheet: 090e2ff5-230a-4758-af6d-e5f00cd1ce64
Sheet: Roads Special Assessment Notes

GENERAL OBLIGATION - Road Commission Schedule |  |  |  |  |  |  |  |  | DECEMBER 31, 2012
 |  |  | refunded 04 |  |  |  | new 12
 | MTF Notes |  | Building Authority |  | MTF Notes |  | MTF Notes
ISSUE: | 2002 Ypsi Twp |  | 2003 A refunding |  | 2000 [NAME] |  | Series 2012 |  | TOTAL GENERAL OB |  | ANNUAL TOTAL GENOB
DATE | principal | interest | principal | interest | Principal | Interest | Principal | Interest | Principal | Interest | Principal | Interest
----------- | ---------- | ---------- | ---------- | ---------- | ----------- | ---------- | ----------- | ---------- | ----------- | ---------- | ----------- | ----------
Feb 1 2013 |  |  |  | 7700 |  |  |  | 69666.67
Aug 1 2013 |  |  | 440000 | 7700 |  |  | 600000 | 57000 |  |  |  |  | 2013
Feb 1 2014 |  |  |  |  |  |  |  | 54000
Aug 1 2014 |  |  |  |  |  |  | 600000 | 54000
Feb 1 2015 |  |  |  |  |  |  |  | 51000
Aug 1 2015 |  |  |  |  |  |  | 600000 | 51000
Feb 1 2016 |  |  |  |  |  |  |  | 45000
Aug 1 2016 |  |  |  |  |  |  | 600000 | 45000
Feb 1 2017 |  |  |  |  |  |  |  | 39000
Aug 1 2017 |  |  |  |  |  |  | 600000 | 39000
Feb 1 2018 |  |  |  |  |  |  |  | 33000
Aug 1 2018 |  |  |  |  |  |  | 600000 | 33000
Feb 1 2019 |  |  |  |  |  |  |  | 27000
Aug 1 2019 |  |  |  |  |  |  | 600000 | 27000
Feb 1 2020 |  |  |  |  |  |  |  | 21000
Aug 1 2020 |  |  |  |  |  |  | 600000 | 21000
Feb 1 2021 |  |  |  |  |  |  |  | 15000
Aug 1 2021 |  |  |  |  |  |  | 600000 | 15000
Feb 1 2022 |  |  |  |  |  |  |  | 7500
Aug 1 2022 |  |  |  |  |  |  | 600000 | 7500
 | --------------- | --------------- | --------------- | --------------- | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------ | ------------
Issuance Date |  |  | 1/21/04 |  |  |  | 6/21/12
Issuance Amount |  |  | 3535000 |  |  |  | 6000000
[NAME]): |  |  | General Fund Road Commission |  |  |  | Ypsilanti Township
Spreadsheet: 53873d1253799709-making-a-calculator-in-excel-master
Sheet: Sheet2

Week Beginiing :
Day | Person: | [NAME] | [NAME] | [NAME] | Ian | Gemma | Jo | [NAME] | Gemma | [NAME] | Total |  | PNC Weekly Target | 2100
1 | PNC | 32 | 180 | 21 |  |  | 167 |  |  |  | 400 |  | Conflict Weekly Target | 500
 | LPF |  |  |  | 58 |  |  |  |  |  | 58 |  | ID Weekly Target | 500
 | ID's |  |  |  |  |  | 100 |  |  |  | 100
2 | PNC | 32 | 180 | 21 |  |  | 167 |  |  |  | 400 |  | PNC Completed | 1600
 | LPF |  |  |  | 58 |  |  |  |  |  | 58 |  | [NAME] | 232
 | ID's |  |  |  |  |  | 100 |  |  |  | 100 |  | ID's Completed | 400
3 | PNC | 32 | 180 | 21 |  |  | 167 |  |  |  | 400
 | LPF |  |  |  | 58 |  |  |  |  |  | 58 |  | PNC Revised Target | 500
 | ID's |  |  |  |  |  | 100 |  |  |  | 100 |  | Conflict Revised Target | 268
4 | PNC | 32 | 180 | 21 |  |  | 167 |  |  |  | 400 |  | Id's Revised Target | 100
 | LPF |  |  |  | 58 |  |  |  |  |  | 58
 | ID's |  |  |  |  |  | 100 |  |  |  | 100
5 | PNC |  |  |  |  |  |  |  |  |  | 0
 | LPF |  |  |  |  |  |  |  |  |  | 0
 | ID's |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 220935d1363310049-need-formula-to-sort-column-based-on-same-info-on-another-worksheet-in-different-order-arraymaxifandvlookup
Sheet: Sheet2

Customer | ContactDate | ContactStatus
101 | 40918 | ToMeet
101 Max
102 | 40919 | ToMeet
102 Max
101 | 40925 | ToProvideSamples
101 Max
[NAME]
Spreadsheet: 149840d1334158922-index-and-match-doesnt-return-sum-of-multiple-instances-index-and-match-issue
Sheet: Detail & Billing

Project | Activity | Name | Cont | Grand Total | Cont Rate | Total
project1 | Execution Activities | [NAME],[NAME] | 1 | 1 | 82.02 | 82.02
project2 | Execution Activities | [NAME],[NAME] | 2 | 2 | 82.02 | 164.04
project2 | Execution Activities | Jones,[NAME] | 3 | 3 | 34.38 | 103.14 | Not Captured
project3 | Execution Activities | Jones,[NAME] | 9 | 9 | 34.38 | 309.42
[NAME] | Execution Activities | [NAME],[NAME] | 7 | 7 | 82.02 | 574.14
[NAME] | Execution Activities | Jones,[NAME] | 5 | 5 | 82.02 | 410.1 | Not Captured
[NAME] | Execution Activities | [NAME],[NAME] | 0.5 | 0.5 | 34.38 | 17.19 | Not Captured
 |  |  | 27.5 | 27.5 |  | 1660.05
Project | Activity | Current Month Time | Prior Month  Adjustment | Total Time | Rate | Total Staff Cost | Contractor Total | Total Billing Cost
project1 | Execution Activities | 6 |  | 6 | 92.75 | 556.5 | 82.02 | 556.5
project2 | Execution Activities | 9 |  | 9 | 90 | 810 | 267.18 | 810
project3 | Execution Activities | 9 |  | 9 | 90 | 810 | 309.42 | 810
[NAME] | Execution Activities | 11.25 |  | 11.25 | 90 | 1012.5 | 1001.43 | 1012.5
 |  |  |  |  |  |  | 1660.05
The formula doesn't total multiple instances of the same project/activity.
Spreadsheet: 216597d1361819256-if-and-vlookup-problem-level-3-tracking-for-anita-protected
Sheet: Unit 18S

Name | Surname | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | M1 | M2 | M3 | D1 | D2 | Final Grade | Final Points Value
Spreadsheet: 701458d1603777996-bring-data-from-other-sheet-new-file-created1-1-
Sheet: B

from | 2020-01-05 00:00:00 | to | 2020-01-11 00:00:00
Date | data_2020 | data_2019 | Target
Spreadsheet: a7e1ab7f-075d-49a8-b304-17a8d7094feb
Sheet: 2015-2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Health Science
Spring 2016
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 818670d1676992841-formula-for-reviewing-multiple-rows-and-pulling-cell-info-if-certain-criteria-is-met-table-example-etaf-2-
Sheet: Sheet1

Table |  |  |  |  |  |  |  | Desired results
Customer | PO | Ship from | Date | Qty sold | Account Name | Value |  | Customer | PO | Ship from | Date | Qty sold | Freight
JB&Stuff | 123456 | Dallas | 2023-01-01 00:00:00 | 18000 | Material | 9000 |  | JB&Stuff | 123456 | Dallas | 2023-01-01 00:00:00 | 18000 | 6000
JB&Stuff | 123456 | Dallas | 2023-01-01 00:00:00 | 6 | Pallet | 60 |  | JB&Stuff | 456789 | Dallas | 2023-02-02 00:00:00 | 14000 | 2000
JB&Stuff | 123456 | Dallas | 2023-01-01 00:00:00 | 1 | Freight | 6000
nonamesrus | 654321 | Chicago | 2023-01-01 00:00:00 | 40000 | Material | 20000
makerofstuff | 123123 | Fresno | 2023-01-08 00:00:00 | 25000 | Material | 10000 |  |  | 123456 | Dallas | 2023-01-01 00:00:00 | 18000 | 9000
makerofstuff | 123123 | Fresno | 2023-01-08 00:00:00 | 1 | Freight 2 | 800 |  | JB&Stuff | 456789 | Dallas | 2023-02-02 00:00:00 | 14000 | 9000
JB&Stuff | 456789 | Dallas | 2023-02-02 00:00:00 | 14000 | Material | 9000
JB&Stuff | 456789 | Dallas | 2023-02-02 00:00:00 | 4 | Pallet | 40
JB&Stuff | 456789 | Dallas | 2023-02-02 00:00:00 | 1 | Freight 2 | 2000
 |  |  |  |  | What I need: Sample attached. If column F contains any variation of the word "Freight" I need to populate column A, B, C, D, E if F = "Material" and E is less than 20,000, G for any variation of "Freight"
 |  |  |  | =SORT(UNIQUE(FILTER(FILTER(I23:M30,I23:I30<>""),{1,0,0,1,0})))
Spreadsheet: scott_neal__37874__STOR9798
Sheet: STOR951

ENRON CAPITAL & TRADE RESOURCES |  |  |  |  |  |  |  |  |  |  |  |  |  | Confidential - For Internal Use Only
STORAGE UPDATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File: STOR9798
Below is a summary of the estimated storage working gas levels
for the week ending: |  |  | 2000-09-22 00:00:00
 |  | Gas In Stg | Gas in | Quantity | Percent | Percent |  |  |  |  | Last Year | Three | Five | Quantity | Quantity | Quantity
 |  | Prev Week | Storage | Change | Change | of Full |  |  |  |  | Same | Year | Year | Change From | Change From | Change From
U.S. Region |  | (Bcf) | (Bcf) | from last week | from last week | Capacity |  |  |  |  | Week | Average | Average | last year | 3 year avg. | 5 year avg.
Production Area |  | 566 | 584
(TX, LA, OK, KS, MS)
Market Area - East |  | 1392 | 1449
Market Area - West |  | 367 | 369
TOTAL U.S.
MONTH TO DATE
Enron Gas Services |  |  | 36.2 | 0 | 0 | 0.924 |  |  |  |  | ECTR is refilling [NAME] as third parties
(as of 1/20/95) |  |  |  |  |  |  |  |  |  |  |  |  |  | are withdrawing, this keeping our
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total position flat for the week.
AGA FULL CAPACITY |  |  | 3294 |  |  |  |  |  |  |  |  |  |  | 3294 | 3294 | 3294
Maximum Gas In Stg Level (Bcf) |  |  | 3127 |  |  |  |  |  |  |  |  |  |  | 3127 | 2832 | 2915
Minimum Gas In Stg Level (Bcf) |  |  | 1335 |  |  |  |  |  |  |  |  |  |  | 1006 | 794 | 871