tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 806685d1669481554-insert-data-from-excel-to-sql-db-vm-2022-poa-ng-val-spelare
Sheet: Deltagare poäng

Tävlande | Poäng
[NAME]
Leif Svensson
[NAME]
[NAME]
Carin Svensson
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Ingalill Turner
Per Johansson
[NAME]
Göran Olsson
[NAME]
[NAME]
Emil Gårdelid
[NAME]
Casper Ederby
[NAME]
[NAME]
[NAME]
Andreas Knutsen
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Ulf Andersson
[NAME]
Johannes Claesson
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] Göthe
[NAME]
[NAME]
[NAME]
[NAME]
M & B Hagberg
Vidar Hagberg
[NAME]
[NAME]
[NAME]
Vilmer Jonasson
[NAME]
[NAME]
[NAME]
[NAME]
Casper Lundström
[NAME]
Camilla Melin
Per [NAME]
Anders [NAME]
Carina Svensson
Ida Svensson
Lars-Åke Svensson
Bosse Swanström
Lars Timring
[NAME]
[NAME]
[NAME]
Spreadsheet: 866627d1713534172-index-dependent-on-value-in-cell-annual-leave-visualisation-2021-2026-for-forum
Sheet: NonEffectives.UnavailabilityLis

Last Update | 2024-04-19 00:00:00
Surname | Forenames | Start | End | Hours In Period | Total Duration | Requested Date | State | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 2022-01-07 00:00:00 | 2022-01-08 00:00:00 | 2022-01-09 00:00:00 | 2022-01-10 00:00:00 | 2022-01-11 00:00:00 | 2022-01-12 00:00:00 | 2022-01-13 00:00:00 | 2022-01-14 00:00:00 | 2022-01-15 00:00:00 | 2022-01-16 00:00:00 | 2022-01-17 00:00:00 | 2022-01-18 00:00:00 | 2022-01-19 00:00:00 | 2022-01-20 00:00:00 | 2022-01-21 00:00:00 | 2022-01-22 00:00:00 | 2022-01-23 00:00:00 | 2022-01-24 00:00:00 | 2022-01-25 00:00:00 | 2022-01-26 00:00:00 | 2022-01-27 00:00:00 | 2022-01-28 00:00:00 | 2022-01-29 00:00:00 | 2022-01-30 00:00:00 | 2022-01-31 00:00:00
Burge | [NAME] | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 7.5 | 1 |  | Approved
Burge | [NAME] | 2022-01-06 00:00:00 | 2022-01-06 00:00:00 | 7.5 | 1 |  | Approved
Burge | [NAME] | 2022-01-07 00:00:00 | 2022-01-23 00:00:00 | 45 | 17 |  | Approved
Burge | [NAME] | 2022-01-07 00:00:00 | 2022-01-23 00:00:00 | 45 | 17 |  | Approved
Burge | [NAME] | 2022-01-07 00:00:00 | 2022-01-08 00:00:00 | 45 | 2 |  | Approved
Burge | [NAME] | 2022-01-08 00:00:00 | 2022-01-23 00:00:00 | 45 | 17 |  | Approved
Burge | [NAME] | 2022-01-09 00:00:00 | 2022-01-23 00:00:00 | 45 | 17 |  | Approved
Burge | [NAME] | 2022-01-07 00:00:00 | 2022-01-23 00:00:00 | 45 | 17 |  | Approved
Burge | [NAME] | 2022-01-10 00:00:00 | 2022-01-23 00:00:00 | 45 | 17 |  | Approved
Burge | [NAME] | 2022-01-11 00:00:00 | 2022-01-23 00:00:00 | 45 | 17 |  | Approved
Burge | [NAME] | 2022-01-12 00:00:00 | 2022-01-23 00:00:00 | 45 | 17 |  | Approved
Spreadsheet: 261649d1377787653-formula-to-track-football-pool-losses-football-pool-2013
Sheet: Sheet1

PLAYERS | N.E Patriots | B. Bills | [NAME] | [NAME] | M. Vikings | D. Lions | K.C. Chiefs | [NAME] | T.B. Buccaneers | N.Y. Jets | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | I. Colts | A. Falcons | NO Saints | T. Titans | [NAME] | G.B Packers | SF 49ers | A. Cardinals | [NAME] | NY Giants | [NAME] | [NAME] | [NAME] | H. Texans | SD Chargers | Total Loses
M | x |  | x |  | x |  | x |  | x |  | x |  | x |  |  | x |  | x |  | x |  | x | x |  | x |  |  | x | x |  | 15
T |  | x |  | x |  | x |  | x |  | x |  | x |  | x | x |  | x |  | x |  | x |  |  | x |  | x | x |  |  | x | 15
S | x |  |  | x |  | x | x |  |  | x |  | x |  | x | x |  | x |  |  | x | x |  | x |  |  | x |  | x |  | x | 15
 | 2 | 1 | 1 | 2 | 1 | 2 | 2 | 1 | 1 | 2 | 1 | 2 | 1 | 2 | 2 | 1 | 2 | 1 | 1 | 2 | 2 | 1 | 2 | 1 | 1 | 2 | 1 | 2 | 1 | 2 | 45
Spreadsheet: 140685d1328862987-auto-populate-sheet-based-on-validation-criteria-from-master-0137
Sheet: Progressing

Project ID | Date | Status | AE | SE | 2nd SE
 |  |  |  |  |  |  |  | Progressing | Cowart
 |  |  |  |  |  |  |  | c | e
SIDPRJ0189 | 2011-07-29 00:00:00 | Progressing | Mulvee | Cowart | Andronaco
SIDPRJ0239-A | 2011-11-16 00:00:00 | Progressing | Andronaco | Cowart | Unassigned
Spreadsheet: 802987d1667200077-data-overwrite-and-restriction-to-fill-the-adjacent-cell-resource_1
Sheet: Time Sheet

Year | Date | PM | Resource | Client | Project Code | Hours | Status
2022 | 2022-11-01 00:00:00 | [NAME] | Guru, [NAME] | Leave | Leave | 8 | CL |  |  |  |  |  |  |  |  | Status
2022 | 2022-11-01 00:00:00 | Sahoo, [NAME] | Prabhakaran, Suresh Kumar | Amgen | PN 6082.06 | 4 |  |  |  |  |  |  |  |  |  | SL
2022 | 2022-11-01 00:00:00 | [NAME] | Prabhakaran, Suresh Kumar | Abbott | GMAx Launch Road Map | 6 |  |  |  |  |  |  |  |  |  | CL
2022 | 2022-11-02 00:00:00 | Sahoo, [NAME] | Prabhakaran, Suresh Kumar | Amgen | PN 6082.06 | 8 |  |  |  |  |  |  |  |  |  | PL
2022 | 2022-11-02 00:00:00 | [NAME] | Guru, [NAME] | Amgen | PN 6082.06 | 8 |  |  |  |  |  |  |  |  |  | RES-Block
2022 | 2022-11-03 00:00:00 | Sahoo, [NAME] | Prabhakaran, Suresh Kumar | Amgen | PN 6082.06 |  | RES-Block
2022 | 2022-11-03 00:00:00 | Sahoo, [NAME] | Guru, [NAME] | Abbott | GMAx Launch Road Map | 9
2022 | 2022-11-04 00:00:00 | Sahoo, [NAME] | Guru, [NAME] | Amgen | PN 6082.06 | 8
2022 | 2022-11-04 00:00:00 | Sahoo, [NAME] | Prabhakaran, Suresh Kumar | Amgen | PN 6082.06 | 3
2022 | 2022-11-05 00:00:00 | [NAME] | Guru, [NAME] | Amgen | PN 6082.06 |  | RES-Block
2022 | 2022-11-05 00:00:00 | [NAME] | Guru, [NAME] | Amgen | PN 6082.06 | 8
2022 | 2022-11-05 00:00:00 | Sahoo, [NAME] | Prabhakaran, Suresh Kumar | Amgen | PN 6082.06 | 8 | SL
Spreadsheet: 1ef50df9-fd95-4868-9812-e00d22eb4d07
Sheet: 1

 | November 8 | November 15 | November 22 | November 29 | December 6
Total Interest Rate* | 320090917 | 319484671 | 333271155 | 328917440 | 330112957
Cleared** | 196616542 | 197901056 | 204094707 | 205021628 | 200134924
Uncleared | 123474375 | 121583616 | 129176448 | 123895812 | 129978033
Total Cross-Currency | 13054556 | 12056904 | 13516888 | 11709155 | 12146360
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | 13054556 | 12056904 | 13516888 | 11709155 | 12146360
Total Credit | 9052362 | 9147397 | 9419352 | 9456107 | 9284295
Cleared | 2186928 | 2191149 | 2276704 | 2387796 | 2191267
Uncleared | 6865434 | 6956248 | 7142648 | 7068311 | 7093028
Total FX**** | 31450000 | 31450000 | 31450000 | 31450000 | 31450000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity**** | 4420000 | 4420000 | 4420000 | 4420000 | 4420000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity**** | 1700000 | 1700000 | 1700000 | 1700000 | 1700000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 379767835 | 378258972 | 393777395 | 387652702 | 389113612
Weekly snapshot, gross notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types. For cleared swaps, this table reflects only one of the two swaps that results from the clearing process; therefore, the numbers on this table are analogous to the notional value of futures open interest.
*See Data Dictionary for asset class descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
****These numbers are estimates.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 729940d1619447835-group-and-total-duplicate-values-in-a-column-group-and-total-duplicate-values-in-a-column-1-
Sheet: Sheet1

Customer Name | [NAME] |  |  |  | Customers
YTC Ltd | 1
Yorkshire Purchasing Organisation - YPO | 1 |  |  |  | Yorkshire Purchasing Organisation - YPO
YESSS Electrical | 1 |  |  |  | YESSS Electrical
X L Technical Services | 1 |  |  |  | X L Technical Services
Wirs (Wolverhampton) Ltd. | 1 |  |  |  | Wirs (Wolverhampton) Ltd.
[NAME] | 1 |  |  |  | [NAME]
[NAME] t/a Sunrise Bakery | 1 |  |  |  | [NAME] t/a Sunrise Bakery
WICKES | 1 |  |  |  | WICKES
WICKES | 1 |  |  |  | WHS Plastics Ltd
WICKES | 1 |  |  |  | Wholesale POS Limited
WICKES | 1 |  |  |  | [NAME]
WICKES | 1 |  |  |  | Walraven Ltd
WICKES | 1 |  |  |  | Wrights Plastics  Ltd
WICKES | 1 |  |  |  | Widney Manufacturing Ltd
WICKES | 1 |  |  |  | Zeus Media Ltd
WHS Plastics Ltd | 1 |  |  |  | Westgate Global Ltd
Wholesale POS Limited | 1 |  |  |  | Yours Clothing Ltd
[NAME] | 1 |  |  |  | Wiggle Ltd - Citadel
Walraven Ltd | 1 |  |  |  | XPO Transport Solutions UK Limited
Wrights Plastics  Ltd | 2
Widney Manufacturing Ltd | 2
WICKES | 2
WICKES | 2
Zeus Media Ltd | 3
Westgate Global Ltd | 4
Yours Clothing Ltd | 6
Wiggle Ltd - Citadel | 6
XPO Transport Solutions UK Limited | 12
Spreadsheet: 43708d1242323848-look-find-and-if-true-replace-find-number
Sheet: Sheet1

 | 3 | 13 | 7 | 35 | 48 | 12 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 11
 | 17 | 18 | 29 | 9 | 45 | 40 |  |  |  |  | 6 | 7 | 8 | 9 | 10 | 12
 | 1 | 49 | 21 | 18 | 39 | 30 |  |  |  |  | 13 | 14 | 15 | 16 | 17 | 18
 |  | Each cell in this group needs to look into the
 |  | second group to see if the number is there.  If it exists, the
 |  | cell should format differently, or be replaced with
 |  | an 'X' (for example).  Otherwise it stays the same.
 |  | **Note - there may be DUPLICATED numbers in
 |  | BOTH groups
Spreadsheet: 51059d1250627086-tuff-protecting-cells-question-with-conditional-formatting-protecting-cells-with-condional-formatting-question
Sheet: Drop Down

 |  |  |  |  |  |  | 1 | 2 | 3
Customer |  |  | MAIN
CAT |  |  | 1 | C |  |  | MC | NP | MC
DEERE |  |  | 2 | S |  |  | MM | RC | MM
CNH |  |  | 3 | Mult |  |  | AN | NPP | AN
CAMOPLAST |  |  | 4 | C |  |  |  | NIS
Spreadsheet: mike_carson__27584__Curve Sheet
Sheet: Sheet1

 |  | Curves as of:
 |  |  |  | Bal-Jan | Feb
 |  | Peak Positions |  | Curve | Curve
 |  | CINERGY | Peak
 |  | COMED | Peak
 |  | ENTERGY | Peak | 19.5 | 19.25
 |  | NEPOOL | Peak
 |  | PJM | Peak
 |  | ERCOT | Peak
 |  | TVA | Peak
 |  |  |  | Bal-Jan | Feb
 |  | Off-Peak Positions |  | Curve | Curve
 |  | CINERGY | [NAME]
 |  | NEPOOL | [NAME]
 |  | PJM | [NAME]
Spreadsheet: bbf1eedb-807a-462d-89d1-8b38318b9a08
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Thum, Stadt - Variante 2
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 912 | 850 | 778 | 687
20 - 65 | 3298 | 2918 | 2543 | 2262
65 und mehr | 1258 | 1387 | 1511 | 1561
Insgesamt | 5468 | 5155 | 4832 | 4510
%
unter 20 | 16.67885881492319 | 16.48884578079534 | 16.10099337748344 | 15.23281596452328
20 - 65 | 60.31455742501829 | 56.60523763336567 | 52.62831125827815 | 50.15521064301552
65 und mehr | 23.00658376005852 | 26.90591658583899 | 31.27069536423841 | 34.61197339246119
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 27.65312310491207 | 29.12954078135709 | 30.59378686590641 | 30.37135278514589
Altenquotient | 38.14432989690722 | 47.53255654557916 | 59.41801022414472 | 69.00972590627762
Gesamtquotient | 65.79745300181928 | 76.66209732693626 | 90.01179709005112 | 99.38107869142353
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 102002d1300069232-table-ladder-with-high-score-can-move-the-formulas-poker-ex-1-
Sheet: Sheet1

Totals | 2 | 2 | 4 | 8.5 | 8.5 | 0 | 0 | 8 | 0 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | geoff | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2009-06-10 00:00:00 | 1 | 0 | 0 | 0 | 2 | 0 | 0 | 3 | 0 | 0 | 5
2009-06-17 00:00:00 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 4
2009-06-20 00:00:00 | 0 | 0 | 1 | 3 | 2 | 0 | 0 | 0 | 0 | 0
2009-06-20 00:00:00 | 0 | 0 | 0 | 3 | 2 | 0 | 0 | 1 | 0 | 0
2009-06-24 00:00:00 | 0 | 0 | 0 | 2.5 | 2.5 | 0 | 0 | 1 | 0 | 0
2009-06-27 00:00:00 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 814187d1674219435-need-help-returning-a-value-from-a-tab-name-but-for-cell-to-look-for-that-tab-name-example-for-forum
Sheet: Aug 22

2022-08-01 00:00:00
 | Items
Branch 1 | 41
Branch 2 | 42
Branch 3 | 43
Branch 4 | 44
Branch 5 | 45
Branch 6 | 46
Branch 7 | 47
Branch 8 | 48
Branch 9 | 49
Branch 10 | 50
Branch 11 | 51
Branch 12 | 52
Branch 13 | 53
Branch 14 | 54
Branch 15 | 55
Branch 16 | 56
Spreadsheet: 391a2b47-41c7-455f-8beb-bdd9dbaa14ae
Sheet: Sheet1

TABLE 1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
PLANNING PROFILE, CAMPUS TOTAL
UNIVERSITY OF HAWAI‘I - WEST O‘AHU
FALL 1998 TO FALL 2002
ACTIVITY MEASURES |  |  |  |  | FALL SEMESTER |  |  |  |  |  | 5-YEAR
 |  |  |  | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | % CHANGE
 |  | Headcount Enrollment .................................................................... |  | 648 | 648 | 685 | 687 | 665 | 740 | 834 | 0.2175182481751825
 |  | Student Semester Hours Taught ............................................. |  | 5807 | 5887 | 6395 | 6623 | 6690 | 6647 | 7083 | 0.107584050039093
 |  | Course FTE Enrollment .................................................................... |  | 388 | 393 | 426 | 442 | 446 | 444 | 472 | 0.107981220657277
 |  | Number of Courses ....................................................................... |  | 82 | 82 | 80 | 86 | 91 | 84 | 87 | 0.0875
 |  | Number of Classes ................................................................. |  | 90 | 90 | 90 | 94 | 104 | 102 | 101 | 0.1222222222222222
 |  | Analytical FTE Faculty  1/ .................................................................. |  | 26.57 | 29.26 | 28.08 | 29.28 | 29 | 32.68
 |  | Student-Faculty Ratio  1/ ................................................................... |  | 14.6 | 13.43 | 15.14 | 15.03 | 15.34 | 13.53
 |  | Average Class [NAME] ......................................................................... |  | 21 | 22 | 23 | 23 | 21 | 20 | 22 | -0.04347826086956522
 |  | 1/  Excludes Aerospace and Military Studies.
Spreadsheet: 471099d1468867749-collect-rows-with-specific-values-and-then-comiple-example-ndm
Sheet: After

ID | Name | State |  | Kept | ID | Name | State
1 | item 1 | Kept
2 | item 2 | Transferred
3 | item 3 | Kept
4 | item 4 | Kept
5 | item 5 | Transferred
6 | item 6 | Transferred
7 | item 7 | Transferred
8 | item 8 | Kept
9 | item 9 | Kept
Spreadsheet: 132251d1323641558-excel-2007-excel-pasting-problem-need-help-please-incorrect
Sheet: Sheet2

16 | 4124-1 | [NAME] | 7 | 2013-08-01 00:00:00 | [NAME] | [NAME] | 73 | — | 98
24 | 403474 | Xpres Maite0 p | 8 | 2013-08-01 00:00:00 | [NAME] | [NAME] | 72 | 51 | 86
31 | 214702 | Lifetime0 | 3 | 2011-09-08 00:00:00 | [NAME] | [NAME] | 72 | — | 95
42 | 526605 | Overrule96J | 7 | 2011-09-08 00:00:00 | [NAME] | [NAME] | 70 | — | 97
53 | 6286 | Global33J | 5 | 2011-05-08 00:00:00 | [NAME] | [NAME] | 60 | 75 | 85
65 | 390573 | Magic Millie408J | 4 | 2011-05-08 00:00:00 | [NAME] O´Meara50 | [NAME] Powell5 | 43 | — | 72
Spreadsheet: 101808d1299853735-help-with-multipe-lookups-duplicateyearsdata
Sheet: Sheet2

 |  | Year: | 2000 |  |  |  | Year: | 2001 |  |  |  | Year: | 2002
 |  | Patients | Total Population | % |  |  | Patients | Total Population | % |  |  | Patients | Total Population | %
 | City 1 | 5774 | 46006 |  |  | City 1 | 13112 | 49550 |  |  | City 1 | 11388 | 50077
 | City 2 | 7578 | 47185 |  |  | City 2 | 14195 | 53905 |  |  | City 2 | 11618 | 42099
 | City 3 | 5838 | 45439 |  |  | City 3 | 9270 | 51707 |  |  | City 3 | 6018 | 57422
 | City 4 | 14550 | 44568 |  |  | City 4 | 11421 | 50704 |  |  | City 4 | 12357 | 42497
 |  |  | Summary
 |  | Year: | TwoThsndTwo
 |  | Patients | Total Population | %
 | City 1
 | City 2
 | City 3
 | City 4
Spreadsheet: 677604d1589421592-determine-if-any-dates-in-range-of-cells-meet-the-criteria-calc-date-example-bvj-
Sheet: Sheet1

 | Admit Date | Discharge Date | (helper) How many Appointments |  | Are any within 3 days? | Are any within 7 days? | Appointment Date 1 | Appointment Date 2 | Appointment Date 3 | Appointment Date 4 | Appointment Date 5
Patient A | 2019-12-31 17:10:07 | 2020-01-01 06:22:00 |  |  |  |  | 2020-01-03 00:00:00 | 2020-01-07 00:00:00 | 2020-03-12 00:00:00 | 2020-03-25 00:00:00
Patient B | 2019-12-31 22:09:00 | 2020-01-01 04:26:00 |  |  |  |  | 2020-01-06 00:00:00 | 2020-01-23 00:00:00 | 2020-01-28 00:00:00 | 2020-02-28 00:00:00
Patient C | 2019-12-31 22:46:00 | 2020-01-01 00:02:00
Patient D | 2019-12-31 22:58:00 | 2020-01-01 02:14:00 |  |  |  |  | 2020-01-06 12:26:21
Patient E | 2019-12-31 23:41:00 | 2020-01-01 01:06:00 |  |  |  |  | 2020-01-02 00:00:00
Patient F | 2019-12-31 23:45:00 | 2020-01-01 03:09:00 |  |  |  |  | 2020-02-07 00:00:00 | 2020-03-05 00:00:00 | 2020-01-06 12:43:09
Patient GA | 2019-12-31 23:46:17 | 2020-01-01 02:42:00
Patient H | 2019-12-31 23:48:36 | 2020-01-01 07:23:00
Patient I | 2020-01-01 00:56:58 | 2020-01-01 04:38:00
Patient J | 2020-01-01 01:12:00 | 2020-01-01 02:52:00
Patient K | 2020-01-01 01:48:00 | 2020-01-01 03:35:00 |  |  |  |  | 2020-01-07 00:00:00
Patient L | 2020-01-01 02:22:25 | 2020-01-01 05:29:00
Patient M | 2020-01-01 02:24:55 | 2020-01-01 07:05:00
Patient N | 2020-01-01 04:36:00 | 2020-01-01 06:51:00
Patient O | 2020-01-01 05:13:15 | 2020-01-01 08:11:00
Patient P | 2020-01-01 07:47:22 | 2020-01-01 08:24:00 |  |  |  |  | 2020-01-03 00:00:00 | 2020-01-22 00:00:00 | 2020-01-31 00:00:00 | 2020-02-13 00:00:00 | 2020-03-04 00:00:00
Spreadsheet: 51924d1251495976-drag-fill-skipping-a-lot-of-rows-updated-psp-outreach-report-template-08-25-09-fs
Sheet: May

 |  | Week of 4/26 - 5/02 | Week of 5/03 - 5/09 | Week of 5/10 - 5/16 | Week of 5/17 - 5/23 | Week of 5/24 - 5/30
School:
Previous Units:
Previous GPA:
GPA Trend:
[NAME]. GPA:
Class Standing:
Previously Full-Time:
Currently Full-Time:
Outreach Frequency:
Independence Status:
Program Standing:
School:
Previous Units:
Previous GPA:
GPA Trend:
[NAME]. GPA:
Class Standing:
Previously Full-Time:
Currently Full-Time:
Outreach Frequency:
Independence Status:
Program Standing:
Spreadsheet: 141397d1329245353-lookup-criteria-in-cell-bigest-loser-tracker-v2
Sheet: Targets

 |  |  | Criteria | Return Value |  |  | Criteria | Return Value
 | Targets | 1 | >=1 | 1 |  | 2 | <=.5 | 1
 |  |  | >=.95 | 0.75 |  |  | <=.8 | 0.5
 |  |  | >=.9 | 0.5 |  |  | <1 | 0.25
 |  |  | >=.85 | 0.25
Spreadsheet: 63981d1264818097-non-working-sumif-more-than-1-criteria-sample
Sheet: Sheet2

 |  | ID Code | Closed | Average Turn Around time
 |  | 122307 | 1 | 12
 |  | 122265 | 2 | 14
 |  | 122253 | 1 | 9
 |  |  |  | 47
 | ID CODE | Status | START | DUE | END | TURN AROUND TIME (TAT)
 | 122307 | Closed | 2010-01-14 00:00:00 | 2010-02-08 00:00:00 | 2010-01-31 00:00:00 | 12
 | 122265 | Closed | 2010-01-14 00:00:00 | 2010-02-02 00:00:00 | 2010-02-02 00:00:00 | 14
 | 122265 | Closed | 2010-01-14 00:00:00 | 2010-02-10 00:00:00 | 2010-01-31 00:00:00 | 12
 | 122307 | ATD | 2010-01-13 00:00:00 | 2010-01-21 00:00:00 | --- | #N/A
 | 122253 | Closed | 2010-01-12 00:00:00 | 2010-01-22 00:00:00 | 2010-01-22 00:00:00 | 9
 | 122265 | ATD | 2010-01-22 00:00:00 | 2010-01-30 00:00:00 | ---- | #N/A
Spreadsheet: 474939d1470978676-dynamic-calendar-test-calendar
Sheet: ignore

 | Our children in childcare: | Anna
 |  | George
 |  | 2016
 |  | Childcare 1 | Childcare 2 | Childcare 3
 |  | OAC | SOS Preschool | KU Preschool
 |  | Childcare 1 | Childcare 2 | Childcare 3
 |  | Nanny
 | SCHOOL HOLIDAYS
Spreadsheet: 63643d1264536753-lookup-with-multiple-criteria-sumproduct-error-sumproduct-with-multiple-criteria-kmlloyd-sdg10
Sheet: Premium Calculation Worksheet

Premium Calculation Worksheet
EE# | Last Name | First Name | Address 1 | Address 2 | City | Province | Postal Code | Status | Leave  Type | [NAME] | [NAME] than Monthly Premium? | As of (Date) | Monthly Accruals | H&D
1234 | Smith | [NAME] | Address 1 |  | Toronto | ON | X1X 1X1 | FULL | N/A | 400 | #N/A | 2010-01-26 00:00:00 | 20 | 20 | '=SUMPRODUCT(--('Premium Contribution Report'!$A$4:$A$2000=$A3),--('Premium Contribution Report'!$C$4:$C$2000=$O$2),'Premium Contribution Report'!$E$4:$E$2000)
1234 | Smith | [NAME] | Address 1 |  | Toronto | ON | X1X 1X1 | FULL | N/A | 400 | #N/A | 2010-01-26 00:00:00 | 0
1234 | Smith | [NAME] | Address 1 |  | Toronto | ON | X1X 1X1 | FULL | N/A | 400 | #N/A | 2010-01-26 00:00:00 | 0
Today, 11:16 AM
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Sumproduct with multiple criteria - kmlloyd - SDG10.XLS
Registered User   Join Date: 18 Nov 2009
Location: Winnipeg
MS Office Version:Excel 2003
Posts: 37
Lookup with multiple criteria...sumproduct error
[NAME]
Attached is my sample workbook...
There would normally be 600+ employees with multiple rows per employee.
I would like [NAME] in the Premium Calculation Worksheet to look at the Premium Contribution Report, and if Row A contains the employee number (A3) AND row C contains "H&D" I would like it to sum row E.
I included the sumproduct formula I tried to put together but I'm getting an error, so I'm not sure what I've done wrong.
The reason I have it referencing "O2" instead of just inputting "H&D" is that [NAME] could be any number of plans - I have multiple rows with different plans and I need it to pull in all the data.
I hope there is enough info here to tell you what I am looking for...
Spreadsheet: 721288d1614625998-formula-based-on-several-variables-example
Sheet: Sheet3

 |  |  |  |  |  |  |  |  |  |  | 2021-01-01 00:00:00 | 2021-01-02 00:00:00 | 2021-01-03 00:00:00 | 2021-01-04 00:00:00 | 2021-01-05 00:00:00
Week Nbr | Date | Name | Shift | Delivery | Pick-up | Cancel | Change |  |  | Day Shift
 | 2021-01-01 00:00:00 | Anna | Day | 1 | 1 | 2 | 1 |  |  | Delivery
 | 2021-01-01 00:00:00 | Becky | Day | 0 | 2 | 5 | 1 |  |  | Pick-up
 | 2021-01-01 00:00:00 | Carie | Swing | 1 | 0 | 0 | 2 |  |  | Cancel
 | 2021-01-01 00:00:00 | Eddie | Swing | 3 | 2 | 3 | 2 |  |  | Change
 | 2021-01-01 00:00:00 | [NAME] | Night | 0 | 2 | 9 | 3 |  |  | Swing Shift
 | 2021-01-01 00:00:00 | George | Night | 1 | 0 | 2 | 1 |  |  | Delivery
 | 2021-01-02 00:00:00 | Anna | Day | 0 | 1 | 4 | 1 |  |  | Pick-up
 | 2021-01-02 00:00:00 | Becky | Day | 0 | 3 | 1 | 2 |  |  | Cancel
 | 2021-01-02 00:00:00 | Carie | Swing | 4 | 1 | 0 | 1 |  |  | Change
 | 2021-01-02 00:00:00 | Eddie | Swing | 0 | 3 | 0 | 4 |  |  | Swing Shift
 | 2021-01-02 00:00:00 | [NAME] | Night | 0 | 4 | 2 | 2 |  |  | Delivery
 | 2021-01-03 00:00:00 | George | Day | 2 | 2 | 3 | 2 |  |  | Pick-up
 | 2021-01-03 00:00:00 | Anna | Day | 0 | 0 | 0 | 1 |  |  | Cancel
 | 2021-01-03 00:00:00 | Becky | Swing | 3 | 3 | 1 | 0 |  |  | Change
 | 2021-01-03 00:00:00 | Carie | Swing | 2 | 0 | 5 | 0
 | 2021-01-03 00:00:00 | Eddie | Night | 1 | 0 | 3 | 2
 | 2021-01-04 00:00:00 | [NAME] | Day | 2 | 3 | 1 | 1
 | 2021-01-04 00:00:00 | George | Day | 0 | 2 | 1 | 3
 | 2021-01-04 00:00:00 | Anna | Swing | 1 | 2 | 3 | 4
 | 2021-01-04 00:00:00 | Becky | Swing | 4 | 4 | 2 | 2
 | 2021-01-04 00:00:00 | Carie | Night | 3 | 0 | 1 | 3
 | 2021-01-05 00:00:00 | Eddie | Day | 7 | 4 | 2 | 1
 | 2021-01-05 00:00:00 | [NAME] | Day | 1 | 1 | 1 | 0
 | 2021-01-05 00:00:00 | George | Swing | 4 | 5 | 2 | 5
 | 2021-01-05 00:00:00 | Carie | Swing | 5 | 3 | 1 | 3
 | 2021-01-05 00:00:00 | Anna | Night | 2 | 1 | 1 | 2
Spreadsheet: louise_kitchen__23935__AugYTD Orig w notes
Sheet: Ercot

ERCOT Origination
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
Curry |  | Power |  | ERCOT Orig |  | 20411866
Sukaly |  | Power |  | ERCOT Orig |  | 27602
Ahn |  | Power |  | ERCOT Orig |  | 12000
Jester |  | Power |  | ERCOT Orig |  | 10000
Total