tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 837690d1690359690-drop-down-chooses-defined-list-test-file
Sheet: Misc

 |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
 |  |  | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM |  |  |  |  |  |  | Average consultation times
 |  | Dr Hughes | Y | Y | Y | Y | Y | Y |  |  | Y | Y
 |  | Dr [NAME] | Y |  | Y |  |  | Y |  |  | Y | Y |  |  |  |  |  |  | 13
 |  | Dr [NAME] | Y | Y | Y | Y | Y | Y |  |  | Y | Y |  |  |  |  |  |  | 3
 |  | Dr Singer | Y |  | Y | Y | Y |  | Y | Y | Y |  |  |  |  |  |  |  | 11
 |  | Dr [NAME] | Y | Y |  |  | Y |  | Y | Y | Y | Y |  |  |  |  |  |  | 6
 |  | Dr Kundi | Y | Y |  |  | Y | Y | Y |  | Y | Y |  |  |  |  |  |  | 2
 |  | Dr Faure | Y | Y | Y |  | Y | Y |  |  | Y |  |  |  |  |  |  |  | 8
 |  | Dr [NAME] | Y | Y |  |  | Y | Y | Y | Y | Y |  |  |  |  |  |  |  | 20
 |  | Dr |  |  |  |  |  |  | Y | Y | Y | Y |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  | Mon |  | Tue |  | Wed |  | Thu |  | Fri |  |  |  | AM | PM |  |  | 15
 |  |  | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM |  | Sessions | 0900 - 11:30 | 15:00 - 17:00 |  |  | 20
 |  | GPs Available | 8 | 6 | 5 | 3 | 7 | 6 | 5 | 4 | 9 | 6 |  |  | 15 Appts | 12 Appts |  |  | 5
 |  | Appointments Available | 120 | 72 | 75 | 36 | 105 | 72 | 75 | 48 | 135 | 72 |  |  |  |  |  |  | 10
 |  | Same Days needed | 141 |  | 106 |  | 107 |  | 91 |  | 92 |  |  |  |  |  |  |  | 10
 |  | Left for routines | 51 |  | 5 |  | 70 |  | 32 |  | 115 |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
Spreadsheet: richard_ring__31559__MPR- Cumulative Filings
Sheet: Sales

SALES
 |  | Residential |  |  |  | Commercial |  |  |  | Other |  |  |  | Total
 |  | Total KWH | # of Customers | Credit |  | Total KWH | # of Customers | Credit |  | Total KWH | # of Customers | Credit |  | Total KWH | # of Customers | Credit
2000-01-01 00:00:00 |  | 1126151 | 1780 | 14076.888 |  | 12793 | 12 | 159.913 |  | 340526 | 18 | 4256.575
2000-02-01 00:00:00 |  | 1259365 | 2059 | 15742.063 |  | 10486 | 13 | 131.075 |  | 0 | 0 | 0
2000-03-01 00:00:00 |  | 1410562 | 2399 | 17632.025 |  | 12964 | 14 | 162.05 |  | 67046 | 12 | 838.075
2000-04-01 00:00:00 |  | 966201 | 1920 | 12077.513 |  | 10631 | 9 | 132.888 |  | 56614 | 9 | 707.675
2000-05-01 00:00:00 |  | 693482 | 1501 | 8668.53 |  | 9489 | 8 | 118.61 |  | 53680 | 12 | 671
2000-06-01 00:00:00 |  | 1281490 | 2291 | 16018.63 |  | 13617 | 12 | 170.21 |  | 31501 | 10 | 393.76
2000-07-01 00:00:00 |  | 333559 | 567 | 3335.59 |  | 2947 | 3 | 29.47 |  | 47261 | 12 | 472.61
2000-08-01 00:00:00 |  | 1449255 | 2739 | 14492.55 |  | 11386 | 13 | 113.86 |  | 36028 | 10 | 360.28
2000-09-01 00:00:00 |  | 1305015 | 2358 | 13050.15 |  | 17571 | 11 | 175.71 |  | 31223 | 11 | 312.23
2000-10-01 00:00:00 |  | 943940 | 1826 | 9439.4 |  | 9538 | 8 | 95.38 |  | 27836 | 11 | 278.36
2000-11-01 00:00:00 |  | 877004 | 1630 | 8770.04 |  | 8336 | 8 | 83.36 |  |  | 4617
2000-12-01 00:00:00 |  | 1019911 | 1641 | 10199.11 |  | 8035 | 8 | 80.35 |  |  | 4617
2001-01-01 00:00:00 |  | 1235068 | 3349 | 12350.68 |  | 12815 | 22 | 128.15 |  | 142732235 | 4607 | 1427322.35
2001-02-01 00:00:00 |  | 891267 | 2819 | 8912.67 |  | 9698 | 8 | 96.98 |  | 10396295 | 4602 | 103962.92
2001-03-01 00:00:00 |  | 883577 | 1907 | 8835.77 |  | 10527 | 9 | 105.27 |  | 26158866 | 4603 | 261588.66
2001-04-01 00:00:00 |  | 617779 | 1366 | 6177.79 |  | 8418 | 7 | 84.18 |  | 13754542 | 4611 | 137545.42
2001-05-01 00:00:00 |  | 662045 | 1441 | 6620.45 |  | 7879 | 6 | 78.79 |  | 3829103 | 4613 | 38291.03
2001-06-01 00:00:00 |  | 668557 | 1440 | 6685.57 |  | 7868 | 7 | 78.68 |  | 3863453 | 4619 | 38634.53
Spreadsheet: sally_beck__33712__Metrics 0623
Sheet: Mexico

E N R O N   N O R T H   A M E R I C A - H O T  L I S T  M E T R I C S |  |  |  |  |  |  |  |  |  |  |  |  | Team: | Mexico
Results based on Activity through June 23, 2000 |  |  |  |  |  |  |  |  |  |  |  |  | Week | 12
 |  | Weekly Summary - 2Q00 through 1Q01
 |  | # of Transactions
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13
 |  | 2000-04-07 00:00:00 | 2000-04-14 00:00:00 | 2000-04-21 00:00:00 | 2000-04-28 00:00:00 | 2000-05-05 00:00:00 | 2000-05-12 00:00:00 | 2000-05-19 00:00:00 | 2000-05-26 00:00:00 | 2000-06-02 00:00:00 | 2000-06-09 00:00:00 | 2000-06-16 00:00:00 | 2000-06-23 00:00:00 | 2000-06-30 00:00:00
Postings Rollforward:
Beginning |  | 0
+ Entrances |  | 1 | 0 | 3 | 0 | 0 | 5 | 0 | 0 | 0 | 1 | 0 | 0
- Exits |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
- Executions |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
Ending
 | Dollar Value of Transactions
 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |  | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Average
Postings Rollforward:
Beginning |  | 100.5
+ Entrances |  | 0 | 14.3 | 1
- Exits |  | 0 | 0 | 0
+/- [NAME] |  | 0 | 0 | -13
- Executions |  | 0 | 0 | 0
Ending
Average Deal Size
 |  |  |  |  |  |  |  | Forward Quarters
 | Actual |  |  | Current Quarter |  | Per |  |  |  |  |  |  |  | Total Year
 | 1Q00 |  |  | 2Q00 |  | Hot List |  | 3Q00 |  |  | 4Q00 |  |  | 2000 |  |  | 1Q01
 | # | $ |  | # | $ |  |  | # | $ |  | # | $ |  | # | $ |  | # | $
Executions | 0 | 0 |  | 1 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  | 0 | 0
DPR/MPR |  | 0 |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0
Postings | 0 | 0 |  | 0 | 0 |  |  | 2 | 0 |  | 4 | 34 |  |  |  |  | 2 | 4
Identified Margin
Budget |  | 4.7
$ Coverage
$ millions
Spreadsheet: 698793d1602177574-dragging-a-formula-but-skipping-columns-excel-help
Sheet: Sheet2

Stats | L | P | C | Stats | L | P | C | Stats | L | P | C
1 |  |  |  | 2 |  |  |  | 3
W | 0.01975 | 5463 | 3 | W | 0.06 | 4 | 0 | L | 0.01 | 5 | 0
W | 0.01 | 4 | 5 | W | 0.02 | 7 | 0 | L | 0.01 | 5 | 0
W | 0.01 | 7 | 0 | W | 0.01 | 6 | 0 | W | 0.01 | 5 | 0
W | 0.01 | 4 | 0 | L | 0.09 | 3 | 0 | W | 0.01 | 5 | 0
D |  |  | 0 | L | 0.08 | 5 | 0 | W | 0.01 | 5 | 0
W | 0.01 | 6 | 0 | D |  |  | 0 | W | 0.01 | 5 | 0
Spreadsheet: 67398d1268047849-hyperlink-not-working-09-sep-accrual-sheet-version-1-
Sheet: 301409 -Sth.ern mall 1200 space

 | Work Description:
 | WBS: |  |  |  |  |  | UPDATED: | 2009-08-24 00:00:00
 | Contractor:
 | Contract No:
 | Order Nos:
 | ALL FIGURES TO EXCLUDE VAT
 |  |  |  |  | A | B | C
 | OVERALL POSITION FOR THIS CONTRACT
 | P Code  NOT APPLICABLE | Description | Monthly Assessment Date | Most Current Application Date (by [NAME]): | Gross (cumulative) Application (from Contractor) | Contract Administrator's (cumulative) assessment (build up in file) | Accrual  C=B-A | Comment | Latest Gross Payment to Contractor
 |  |  |  |  | TOTAL | 0
 |  |  |  |  | A | B | C
 | POSITION FOR EACH P CODE (INCLUDE LOGISTICS & OTHER PROJECTS [obtain from other Project])
 | P Code & OTHER PROJECT | Description | Monthly Assessment Date | Most Current Application Date (by [NAME]): | Gross (cumulative) Application (from Contractor) | Contract Administrator's (cumulative) assessment (build up in file) | Accrual  C=B-A | Comment | Latest Gross Payment to Contractor
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost attributed to infrastructure design (BK)
 |  |  |  |  | CHECK | 0
Spreadsheet: 859776d1708021622-productif-formula-with-multiple-criteria-productif-formula-with-multiple-criteria
Sheet: Sheet1

 |  |  |  |  |  |  | Classes for scores
 |  | Return | Score |  |  |  | Bottom limit | Upper limit |  | Wrong answer |  |  | Asnwer should be (calculated "by hand")
 |  | 0.05 | -0.35 |  |  |  | -0.34 | -0.29
 |  | -0.02 | -0.34 |  |  |  | -0.29 | -0.24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Return in % if criteria are dropped
 |  | 0.03 | -0.33 |  |  |  | -0.24 | -0.1900000000000001 |  |  |  | 1 |  | Class is outside of range. Instead, the wrong formula calulates the result as if no restriction applied
 |  | -0.0025 | -0.32
 |  | 0.02 | -0.31
 |  | 0.01 |  |  |  |  | The aim is to calulate the return if the score falls into the range given by the class boundaries
 |  | 0.0057
 |  | -0.02
 |  | 0.0072
 |  | -0.0092
Spreadsheet: 872632d1718989326-pricelist-with-with-multiple-values-on-the-same-row-sample-pricelist
Sheet: List

 | art# | blue | red | yelow
 | 6103 | 840 | 940 | 1050
 | 6104 | 1110 | 1250 | 1390
 | 6105 | 1380 | 1560 | 1730
 | 6106 | 1630 | 1820 | 2030
 | what is the price of art.nr 6105 with red colour?
Spreadsheet: 273421d1382709528-solved-if-than-giving-points-to-corresponding-cells-acording-to-lowest-values-etc-product-table
Sheet: List1

DATUM:
TEREN:
[NAME]:
KUPAC I ADRESA:
OSOBA NA TERENU:
VRSTA PAKIRANJA | ARTIKLI | BROJ LICA | broj lica u % | PALETNO [NAME] | paletno [NAME] u % | CIJENA (1 - manja od os/ 2- veća od os/ 0-  nema se sa čime usporediti | RASHLADNA VITRINA (3 - njihova/ 4 - naša) | AKCIJE (5 - cjenovna/ 6- gratis/ 7- ni/ 8 - prim prodaja | POS MAT (9 - ima/10 - nema)
 | Ukupno
Boca - povratna 0,5 L | Osječko pivo svijetlo 0,50 L
 | Pan pivo svijetlo 0,50 L
 | [NAME] pivo svijetlo 0,50 L
 | [NAME] pivo svijetlo 0,50 L
 | [NAME] pivo svijeto 0,50 L
 | Lav pivo svijetlo 0,50 L
Boca - povratna 0,5 L - Radler | Ukupno
 | Osječko radler limun svijetli 0,50 L
 | Osječko radler [NAME] 0,50 L
 | Pan radler limun svijetli 0,50 L
 | [NAME] radler limun svijetli 0,50 L
 | [NAME] radler [NAME]
PET 1,00 L | Ukupno
 | Osječko pivo svijetlo PET 1,00 L
 | Pan pivo svijetlo PET 1,00 L
 | [NAME] pivo svijetlo PET 1,00 L
 | [NAME] pivo svijetlo 1,00 L
PET 2,00 L | Ukupno
 | Osječko pivo svijetlo PET 2,00 L
 | Pan pivo svijetlo PET 2,00 L
 | [NAME] pivo svijetlo PET 2,00 L
 | [NAME] pivo svijetlo 2,00 L
PET 1,00 L - radler | Ukupno
 | Osječko black radler 1l
 | Pan radler 1l
 | [NAME]  radler 1l
 | [NAME] radler 1l
ROBNE MARKE PET 2,00 L | Ukupno
 | Extrabrau svijetlo pivo 2,00 L
 | Holsten 2,00 L
 | Lowenbrau 2,00 L
 | Sokol svijetlo pivo 2,00 L
 | Pivo svijetlo 2,00 L rob.marka trg.objekta
Limenka 0,50 L - radleri | Ukupno
 | Osječko pivo Black Radler limun 0,50 L
 | Pan radler 0,50 L
 | [NAME] radler 0,50 L
 | [NAME] radler 0,50 L
Limenka 0,50 L | Ukupno
 | Osječko pivo svijetlo 0,50 L
 | Pan svijetlo pivo 0,50 L
 | [NAME] pivo svijetlo 0,50 L
 | [NAME] pivo svijetlo 0,50 L
Spreadsheet: 782031d1653717506-formular-to-get-individual-data-in-another-sheet-student-detail-aligw
Sheet: STUDENT NAMES

 | STUDENT NO. | FIRST NAME | MIDDLE NAME | SURNAME | SEX | PHYSICS | CHEMISTRY | BIOLOGY
 | 1 | AFASHA | ELIA | KAMONONGO | F | 92 | 93 | 94
 | 2 | AGATHA | EVARIST | MILUNGA | F | 43 | 43 | 38
 | 3 | AGATHA | FILBERT | AGUSTINO | F | 34 | 34 | 36
 | 4 | AGNES | JULIUS | KUSAYA | F | 33 | 33 | 58
 | 5 | AGNES | [NAME] | KAKUSA | F | 19 | 19 | X
Spreadsheet: 782988d1654508098-vlookup-or-index-match-multiple-crierias-ranking-by-points-system-gln-
Sheet: Sheet1

Results
 | RATINGS CRITERIA |  |  |  |  |  |  |  |  |  |  | POINTS FOR CLASS SYSTEM |  |  |  |  |  |  |  |  |  |  | RANKING |  |  |  |  |  |  |  |  |  | Points allocated
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL POINTS
Numbers | A | B | C | D | E | F | G | H | I |  | RANK | A | B | C | D | E | F | G | H | J |  |  | A | B | C | D | E | F | G | H | J |  |  | A | B | C | D | E | F | G | H | J
1 | 92.99558993702065 | 122 | 107 | 113.75 | 160.389210500364 | 106.926140333576 | 100 | 113.75 | 129 |  | 1 | 12.63 | 12.63 | 12.63 | 12.63 | 12.63 | 15 | 15 | 15 | 15 |  | 1 |  |  |  |  |  |  |  |  |  |  | 1
2 | 90.99131529678017 | 106 | 104 | 110.25 | 159.7703164723415 | 106.5135443148944 | 100 | 107.25 | 114 |  | 2 | 10.26 | 10.26 | 10.26 | 10.26 | 10.26 | 12.5 | 12.5 | 12.5 | 13 |  | 2 |  |  |  |  |  |  |  |  |  |  | 2
3 | 91.5517743830653 | 73 | 77 | 78.25 | 168.5708381991382 | 112.3805587994255 | 72 | 48.25 | 77 |  | 3 | 7.89 | 7.89 | 7.89 | 7.89 | 7.89 | 10 | 10 | 10 | 10 |  | 3 |  |  |  |  |  |  |  |  |  |  | 3
4 | 95.00438345391991 | 73 | 76 | 71.25 | 167.5619667451623 | 111.7079778301082 | 74 | 40.25 | 80 |  | 4 | 5.53 | 5.53 | 5.53 | 5.53 | 5.53 | 7.5 | 7.5 | 7.5 | 7.5 |  | 4 |  |  |  |  |  |  |  |  |  |  | 4
5 | 97.95247459680645 | 73 | 74 | 71.5 | 167.557435696626 | 111.704957131084 | 69 | 38.5 | 79 |  | 5 | 3.16 | 3.16 | 3.16 | 3.16 | 3.16 | 5 | 5 | 5 | 5 |  | 5 |  |  |  |  |  |  |  |  |  |  | 5
6 | 82.21011281418235 | 122 | 124 | 116.25 | 163.0931814218198 | 108.7287876145465 | 117 | 133.25 | 117 |  | 6 | 0.79 | 0.79 | 0.79 | 0.79 | 0.79 | 0 | 0 | 0 | 0 |  | 6 |  |  |  |  |  |  |  |  |  |  | 6
7 | 94.42414100058294 | 108 | 104 | 109.25 | 160.0023079773791 | 106.6682053182527 | 112 | 106.25 | 99 |  | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 7 |  |  |  |  |  |  |  |  |  |  | 7
8 | 98.36681925727805 | 73 | 80 | 78.5 | 168.3864984502218 | 112.2576656334812 | 73 | 51.5 | 77 |  | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 8 |  |  |  |  |  |  |  |  |  |  | 8
9 | 92.85991867549063 | 73 | 78 | 75 | 162.9858059640548 | 108.6572039760365 | 79 | 46 | 75 |  | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 9 |  |  |  |  |  |  |  |  |  |  | 9
10 | 98.60003113534273 | 73 | 81 | 87.25 | 157.7035585902581 | 105.1357057268387 | 82 | 61.25 | 85 |  | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10 |  |  |  |  |  |  |  |  |  |  | 10
11 | 86.0056672495971 | 119 | 122 | 121.5 | 161.9180360282746 | 107.9453573521831 | 118 | 136.5 | 112 |  | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 11 |  |  |  |  |  |  |  |  |  |  | 11
12 | 94.02750133159597 | 71 | 81 | 77 | 161.6719072820831 | 107.7812715213887 | 77 | 51 | 55 |  | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 12 |  |  |  |  |  |  |  |  |  |  | 12
13 | 92.4480580873024 | 73 | 77 | 80 | 164.2923364710751 | 109.52822431405 | 91 | 50 | 72 |  | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 13 |  |  |  |  |  |  |  |  |  |  | 13
Spreadsheet: elizabeth_sager__9474__Deal Charts
Sheet: Canada Gas

Physical Gas - ECC
Deal Ref No | Commodity | Buyer | [NAME] | Trade Date | Start Date | End Date | Daily Volume | Index | Deal Type | Strike | Confirm
NW8988 | NG | PG&E | ECC | 2001-03-27 00:00:00 | 2001-04-01 00:00:00 | 2001-04-30 00:00:00 | -5000 | USD Fixed Price | forward | 5.175 | GTC
NW8988 | NG | PG&E | ECC | 2000-08-25 00:00:00 | 2001-05-01 00:00:00 | 2001-10-31 00:00:00 | -5000 | NX1 Aeco Basis | forward | -0.375 | GTC
Q58679 | NG | PG&E | ECC | 2000-10-31 00:00:00 | 2001-04-01 00:00:00 | 2001-10-31 00:00:00 | -5000 | Aeco USD - $.005 | forward | -0.005 | GTC
QA9788 | NG | PG&E | ECC | 2001-03-27 00:00:00 | 2001-04-01 00:00:00 | 2001-04-30 00:00:00 | -5000 | USD Fixed Price | forward | 5.2425 | GTC
QA9788 | NG | PG&E | ECC | 2000-11-17 00:00:00 | 2001-05-01 00:00:00 | 2001-10-31 00:00:00 | -5000 | NX1 Aeco Basis | forward | -0.3075 | GTC
Q09929 | NG | PG&E | ECC | 2000-09-25 00:00:00 | 2001-04-01 00:00:00 | 2001-10-31 00:00:00 | -4739 | Aeco C$ - $.0325 | forward | -0.0325 | GTC
Q10524 | NG | PG&E | ECC | 2000-09-26 00:00:00 | 2001-04-01 00:00:00 | 2001-10-31 00:00:00 | -4739 | Aeco C$ - $.0425 | forward | -0.0425 | GTC
Q33141 | NG | PG&E | ECC | 2000-10-10 00:00:00 | 2001-04-01 00:00:00 | 2001-10-31 00:00:00 | -4739 | C$ Fixed Price | forward | 5.74 | GTC
Q74982 | NG | PG&E | ECC | 2000-11-03 00:00:00 | 2001-04-01 00:00:00 | 2001-10-31 00:00:00 | -4739 | Aeco C$ - $.08 | forward | -0.08 | GTC
Q82787 | NG | PG&E | ECC | 2000-11-08 00:00:00 | 2001-04-01 00:00:00 | 2001-10-31 00:00:00 | -4739 | Aeco C$ - $.01 | forward | -0.01 | GTC
[NAME] | NG | PG&E | ECC | 2000-11-14 00:00:00 | 2001-04-01 00:00:00 | 2001-10-31 00:00:00 | -4739 | Aeco C$ - $.21 | forward | -0.21 | GTC
QD3463 | NG | PG&E | ECC | 2000-12-01 00:00:00 | 2001-04-01 00:00:00 | 2001-10-31 00:00:00 | -4739 | Aeco C$ - $.115 | forward | -0.115 | GTC
N13588 | NG | PG&E | ECC | 1999-09-08 00:00:00 | 2001-04-01 00:00:00 | 2001-10-31 00:00:00 | -23039 | Aeco C$ - $.005 | forward | 0.005 | GTC
Invoice No | Month | Invoice Date | Due Date | Invoice Amount | Currency | Conversion Rate | USD Amount
Temp_42528 | 2001-03-01 00:00:00 |  |  | 25103269.75 | CAD | 1.5599
Temp_42569 | 2001-03-01 00:00:00 |  |  | 812975 | CAD | 1.5599
Temp_76601 | 2001-03-01 00:00:00 |  |  | 797909 | USD | 1
Temp_42578 | 2001-03-01 00:00:00 |  |  | 17449873.09 | CAD | 1.5599
Prepay |  |  |  | -8962100 | CAD | 1.5599
TEMP_XXXX | 4/1/01 - 4/12/01 |  |  | 4830928.6751 | CAD | 1.5599
TEMP_XXXX | 4/1/01 - 4/12/01 |  |  | 852780.5 | USD | 1
Spreadsheet: 171873d1343898053-listing-information-from-data-table-listing-information-from-data-table
Sheet: Data

Ref | Date | Name | Cost
1 | 2012-07-01 00:00:00 | [NAME] | 1
2 | 2012-07-02 00:00:00 | [NAME] | 1.2
3 | 2012-07-03 00:00:00 | [NAME] | 1.5
4 | 2012-07-04 00:00:00 | [NAME] | 1.1
5 | 2012-07-05 00:00:00 | [NAME] | 1.7
6 | 2012-07-06 00:00:00 | [NAME] | 1.6
7 | 2012-07-07 00:00:00 | [NAME] | 1.5
8 | 2012-07-08 00:00:00 | [NAME] | 1.8
9 | 2012-07-09 00:00:00 | [NAME] | 1.9
10 | 2012-07-10 00:00:00 | [NAME] | 1.11
11 | 2012-07-11 00:00:00 | [NAME] | 1.26
12 | 2012-07-12 00:00:00 | [NAME] | 1.85
13 | 2012-07-13 00:00:00 | Jon | 1.65
14 | 2012-07-14 00:00:00 | Jon | 1.22
15 | 2012-07-15 00:00:00 | Jon | 1.33
16 | 2012-07-16 00:00:00 | Jon | 1.54
17 | 2012-07-17 00:00:00 | Jon | 1.85
18 | 2012-07-18 00:00:00 | Jon | 1.68
19 | 2012-07-19 00:00:00 | Jon | 1.17
20 | 2012-07-20 00:00:00 | Jon | 1.71
21 | 2012-07-21 00:00:00 | Jon | 1.65
22 | 2012-07-22 00:00:00 | [NAME] | 1.98
23 | 2012-07-23 00:00:00 | [NAME] | 1.88
24 | 2012-07-24 00:00:00 | [NAME] | 1.32
Spreadsheet: 064151db-9541-41f2-9363-a50a91ff79e7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Central | IBC | NEPA | Highmark | Totals
 | ADAMS | 28 |  |  |  | 28
 | ALLEGHENY |  |  |  | 1784 | 1784
 | ARMSTRONG |  |  |  | 149 | 149
 | BEAVER |  |  |  | 243 | 243
 | BEDFORD |  |  |  | 99 | 99
 | BERKS | 71 |  |  |  | 71
 | BLAIR |  |  |  | 265 | 265
 | BRADFORD |  |  | 12 |  | 12
 | BUCKS |  | 313 |  |  | 313
 | BUTLER |  |  |  | 212 | 212
 | CAMBRIA |  |  |  | 595 | 595
 | CAMERON |  |  |  | 15 | 15
 | CARBON |  |  | 61 |  | 61
 | CENTRE | 20 |  |  | 41 | 61
 | CHESTER |  | 119 |  |  | 119
 | CLARION |  |  |  | 68 | 68
 | CLEARFIELD |  |  |  | 262 | 262
 | CLINTON |  |  | 21 |  | 21
 | COLUMBIA | 25 |  |  |  | 25
 | CRAWFORD |  |  |  | 225 | 225
 | CUMBERLAND | 51 |  |  |  | 51
 | DAUPHIN | 67 |  |  |  | 67
 | DELAWARE |  | 281 |  |  | 281
 | ELK |  |  |  | 121 | 121
 | ERIE |  |  |  | 1053 | 1053
 | FAYETTE |  |  |  | 312 | 312
 | FOREST |  |  |  | 5 | 5
 | FRANKLIN | 23 |  |  |  | 23
 | FULTON | 9 |  |  |  | 9
 | GREENE |  |  |  | 70 | 70
 | HUNTINGDON |  |  |  | 78 | 78
 | INDIANA |  |  |  | 205 | 205
 | JEFFERSON |  |  |  | 114 | 114
 | JUNIATA | 12 |  |  |  | 12
 | [NAME] |  |  | 113 |  | 113
 | LANCASTER | 73 |  |  |  | 73
 | [NAME] |  |  |  | 189 | 189
 | LEBANON | 28 |  |  |  | 28
 | LEHIGH | 62 |  |  |  | 62
 | LUZERNE |  |  | 157 |  | 157
 | LYCOMING |  |  | 26 |  | 26
 | MCKEAN |  |  |  | 49 | 49
 | MERCER |  |  |  | 267 | 267
 | MIFFLIN | 37 |  |  |  | 37
 | MONROE |  |  | 66 |  | 66
 | MONTGOMERY |  | 316 |  |  | 316
 | MONTOUR | 4 |  |  |  | 4
 | NORTHAMPTON | 47 |  |  |  | 47
 | NORTHUMBERLAND | 36 |  |  |  | 36
 | PERRY | 12 |  |  |  | 12
 | PHILADELPHIA |  | 1466 |  |  | 1466
 | PIKE |  |  | 20 |  | 20
 | POTTER |  |  |  | 37 | 37
 | SCHUYLKILL | 31 |  |  |  | 31
 | SNYDER | 7 |  |  |  | 7
 | [NAME] |  |  |  | 300 | 300
 | SULLIVAN |  |  | 2 |  | 2
 | SUSQUEHANNA |  |  | 27 |  | 27
 | TIOGA |  |  | 22 |  | 22
 | UNION | 3 |  |  |  | 3
 | VENANGO |  |  |  | 139 | 139
 | WARREN |  |  |  | 124 | 124
 | WASHINGTON |  |  |  | 335 | 335
 | WAYNE |  |  | 26 |  | 26
 | WESTMORELAND |  |  |  | 791 | 791
 | WYOMING |  |  | 7 |  | 7
 | YORK | 89 |  |  |  | 89
 | Totals | 735 | 2495 | 560 | 8147 | 11937
Spreadsheet: 850196d1700576340-formula-not-including-partial-weeks-example-data-workbook
Sheet: Master Data

Role | Weekly hours total |  | Name | Role | Hrs/Week
Engineer | 252 |  | Employee1 | Engineer | 20
Technician | 120 |  | Employee2 | Technician | 40
Graduate Engineer | 120 |  | Employee3 | Graduate Engineer | 40
Senior Technician | 40 |  | Employee4 | Senior Technician | 40
Senior Project Co-Ordinator | 40 |  | Employee5 | Senior Project Co-Ordinator | 40
Team Leader | 80 |  | Employee6 | Team Leader | 40
Assistant Engineer | 120 |  | Employee7 | Engineer | 40
Apprentice | 40 |  | Employee8 | Assistant Engineer | 40
Signals Design | 80 |  | Employee9 | Apprentice | 40
Programme Coordinator | 40 |  | Employee10 | Signals Design | 40
Project Manager | 40 |  | Employee11 | Programme Coordinator | 40
Road Safety | 160 |  | Employee12 | Project Manager | 40
Design Manager | 80 |  | Employee13 | Engineer | 40
Senior Engineer (agency) | 40 |  | Employee14 | Road Safety | 40
Senior Engineer | 40 |  | Employee15 | Design Manager | 40
Project Coordinator | 160 |  | Employee16 | Senior Engineer (agency) | 40
UST | 40 |  | Employee17 | Assistant Engineer | 40
 |  |  | Employee18 | Team Leader | 40
 |  |  | Employee19 | Signals Design | 40
 |  |  | Employee20 | Engineer | 32
 |  |  | Employee21 | Senior Engineer | 40
 |  |  | Employee22 | Engineer | 40
 |  |  | Employee23 | Technician | 40
 |  |  | Employee24 | Technician | 40
 |  |  | Employee25 | Project Coordinator | 40
 |  |  | Employee26 | Project Coordinator | 40
 |  |  | Employee27 | Graduate Engineer | 40
 |  |  | Employee28 | Design Manager | 40
 |  |  | Employee29 | Engineer | 40
 |  |  | Employee30 | Project Coordinator | 40
 |  |  | Employee31 | Project Coordinator | 40
 |  |  | Employee32 | Road Safety | 40
 |  |  | Employee33 | Engineer | 40
 |  |  | Employee34 | Road Safety | 40
 |  |  | Employee35 | Road Safety | 40
 |  |  | Employee36 | UST | 40
 |  |  | [NAME] | Assistant Engineer | 40
 |  |  | Employee38 | Graduate Engineer | 40
Spreadsheet: 731534d1620393396-help-with-unequal-ranges-for-counting-different-values-example
Sheet: COUNTIFS with unequal ranges

POM
 | Range 1 |  |  |  |  |  | COUNTIF and COUNTIFS with unequal ranges
 | WATER
ELECTRIC | ELECTRIC |  |  |  |  |  | Number of "WATER":
NORMAL | NORMAL
FIRE
FIRE
FIRE
KUZ
IND
IND
YO
FIRE | FIRE |  |  |  |  |  | COUNTIFS
PSYCHIC | PSYCHIC
PSYCHIC | PSYCHIC |  | Range 2 |  |  |  | COUNTIF
PSYCHIC | PSYCHIC |  | WATER
 |  |  | WATER |  |  |  | Traditional Way
 |  |  | DRAGON, FLYING
 |  |  | WATER |  |  |  | COUNTIFS
 |  |  |  |  | Range 3
 |  |  |  |  | FAIRY |  | COUNTIF
 |  |  |  |  | FIRE
 |  |  |  |  | WATER
Spreadsheet: 694044d1599314552-condensing-down-like-items-in-a-material-list-2020-09-05-oeldere-fenster-694033d1599311575-condensing-down-like-items-in-a-material-list-ex
Sheet: PT1

Qty | (Meerdere items)
Item | Size | Color | Material Type
[NAME] | 1" | black | Alloy Steel
Inside Bolt1 | 1" | green | Stainless Steel
Inside Bolt2 | 1" | red | Stainless Steel
Inside Bolt3 | 1" | green | Stainless Steel
Inside Bolt4 | 1" | green | Stainless Steel
Middle Bolt | 1-1/2" | red | Stainless Steel
Outside Bolt | 1-3/4" | black | Stainless Steel
Right Bolt | 2" | red | Zinc Plated
Top Bolt | 1-3/4" | black | Stainless Steel
Undermount Bolt1 | 1-1/2" | red | Stainless Steel
Undermount Bolt2 | 1" | silver | Stainless Steel
Undermount Bolt3 | 1" | silver | Stainless Steel
Undermount Bolt4 | 1" | silver | Stainless Steel
Eindtotaal