tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 774325d1648392836-summarise-sku-arrivals-in-table-consolidate-multiple-lines-into-one-and-group-by-week-inbound_report_upload
Sheet: Data

Purchase order # | SKU | Description | Deliv. date(From/to) | Delivery quantity |  | Sum of Delivery quantity | Column Labels
110 | 1530 | Gourmet Coarse Grater 45000 | 2022-04-08 00:00:00 | 480 |  | Row Labels | 8-Apr | 12-Apr | 16-Jun | Grand Total
110 | 1532 | Gourmet Fine Grater 45004 | 2022-04-08 00:00:00 | 1200 |  | 1530 | 480 |  |  | 480
111 | 1532 | Gourmet Fine Grater 45004 | 2022-04-12 00:00:00 | 720 |  | Gourmet Coarse Grater 45000 | 480 |  |  | 480
110 | 1536 | Premium Black Zester Grater 46020 | 2022-04-08 00:00:00 | 1200 |  | 1532 | 1200 | 720 |  | 1920
111 | 1536 | Premium Black Zester Grater 46020 | 2022-04-12 00:00:00 | 2400 |  | Gourmet Fine Grater 45004 | 1200 | 720 |  | 1920
110 | 1570 | Premium Classic Zester Black CDU/12 | 2022-04-08 00:00:00 | 1200 |  | 1536 | 1200 | 2400 |  | 3600
110 | 1571 | Premium Classic Zester Citrus CDU/12 | 2022-04-08 00:00:00 | 480 |  | Premium Black Zester Grater 46020 | 1200 | 2400 |  | 3600
110 | 1573 | Zester CDU/12 6 xWhite, 6 xFloral | 2022-04-08 00:00:00 | 1200 |  | 1570 | 1200 |  |  | 1200
112 | 2700 | Pasta Machine [NAME] 150 | 2022-04-12 00:00:00 | 2196 |  | Premium Classic Zester Black CDU/12 | 1200 |  |  | 1200
112 | 2701 | Ravioli Access | 2022-04-12 00:00:00 | 72 |  | 1571 | 480 |  |  | 480
112 | 2705 | Spaghetti Access | 2022-04-12 00:00:00 | 48 |  | Premium Classic Zester Citrus CDU/12 | 480 |  |  | 480
112 | 2707 | Parppardelle 50mm Access | 2022-06-16 00:00:00 | 48 |  | 1573 | 1200 |  |  | 1200
 |  |  |  |  |  | Zester CDU/12 6 xWhite, 6 xFloral | 1200 |  |  | 1200
 |  |  |  |  |  | 2700 |  | 2196 |  | 2196
 |  |  |  |  |  | Pasta Machine [NAME] 150 |  | 2196 |  | 2196
 |  |  |  |  |  | 2701 |  | 72 |  | 72
 |  |  |  |  |  | Ravioli Access |  | 72 |  | 72
 |  |  |  |  |  | 2705 |  | 48 |  | 48
 |  |  |  |  |  | Spaghetti Access |  | 48 |  | 48
 |  |  |  |  |  | 2707 |  |  | 48 | 48
 |  |  |  |  |  | Parppardelle 50mm Access |  |  | 48 | 48
 |  |  |  |  |  | Grand Total | 5760 | 5436 | 48 | 11244
Spreadsheet: 240143d1370235093-filtering-with-some-blank-space-book1
Sheet: Sheet1

Date In | Date Out | Name | ID
 |  | [NAME]
09:00:00 | 12:00:00
 |  |  | 123
 |  | [NAME]
08:00:00 | 13:00:00
 |  |  | 123
 |  | Zack
09:00:00 | 11:00:00
 |  |  | 345
 |  | Zack
08:00:00 | 14:00:00
 |  |  | 345
Spreadsheet: 718931d1613415750-rank-select-conditional-format-cf-test4gk
Sheet: Test Chart

 |  |  |  | Desired Results
#1 | #2 |  |  | #1 | #2
7 | 7 |  |  | 7 | 7
5 | 5 |  |  | 5 | 5
5 | 4 |  |  | 5 | 4
4 | 3 | result |  | 4 | 3 | result
#1 | #2 |  |  | #1 | #2
8 | 8 |  |  | 8 | 8
6 | 6 |  |  | 6 | 6
4 | 3 |  |  | 4 | 3
6 | 6 | result |  | 6 | 6 | result
#1 | #2 |  |  | #1 | #2
4 | 2 |  |  | 4 | 2
6 | 6 |  |  | 6 | 6
4 | 3 |  |  | 4 | 3
5 | 4 | result |  | 5 | 4 | result
 |  | 7
#1 | #2 |  |  | #1 | #2
5 | 5 |  |  | 5 | 5
6 | 6 |  |  | 6 | 6
6 | 5 |  |  | 6 | 5
4 | 3 | result |  | 4 | 3 | result
 |  | 9
#1 | #2 |  |  | #1 | #2
5 | 5 |  |  | 5 | 5
4 | 3 |  |  | 4 | 3
7 | 6 |  |  | 7 | 6
5 | 4 | result |  | 5 | 4 | result
 |  | 8
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 15

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
15 | 2007-02-20 00:00:00 | 7.5 | 0.53 | 2.6 | 0.9 | 3.6 | 4.4 |  |  |  | 1.5 |  | 3.848561883538911 | 3.3 | 0.1 | 8 |  |  |  |  | 0.2
Well #15 | 2013-10-11 00:00:00 | 7.9 | 0.43 | 1.43 | 0.56 | 2 | 3.9 |  |  | 0.2 | 0.4 |  | 2 | 3.6 | 0.02 | 0.8 |  | <0.10 | <0.02 |  | 0.3
Well - 15 | 2014-01-27 00:00:00 | 8.2 | 0.43 | 1.7 | 0.67 | 2.4 | 3.7 |  |  | 0.2 | 0.5 |  | 2.2 | 4.1 | 0.01 | 1.3 |  | <0.10 | <0.02 |  | 0.6
Well 15 | 2015-04-02 00:00:00 | 7.7 | 0.42 | 1.63 | 0.62 | 2.2 | 3.7 |  |  | 0.2 | 0.5 |  | 2 | 3.8 | <0.05 | 1.3 |  | <0.10 | <0.02 |  | 0.1
Well 15 | 2016-04-01 00:00:00 | 7.9 | 0.414 | 1.66 | 0.65 | 2.19 | 3.510910398849013 | 3.510910398849013 | 0 | 0.249 | 0.82395 | 262.4 | 2.04 | 3.37 | 0.017 | 1.27 | 0.002 | 0 | 0.001 | 0.005
Well 15 | 2017-05-03 00:00:00 | 7.71 | 0.301 | 1.39 | 0.538 | 1.62 | 2.743585644632724 | 2.743585644632724 | 0 | 0.117 | 0.31385 | 192 | 1.65 | 2.45 | 0.016 | 1.5952 | 0.025 | 0.026 | 0 | 0.09
W15 | 2018-05-29 00:00:00 | 7.83 | 0.359 | 1.72 | 0.662 | 2.4 |  | 3.500919191111822 | 0 | 0.191 | 0.327 | 229.76 |  |  | 0.037 | 0.244 | 0.009 | 0.013 | 0 | 0.001
Spreadsheet: a422ffb1-0069-4d2e-b532-2bd6b3d0e70a
Sheet: Sheet1

State Auditor (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 5/18/2013 4:48:02 AM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
Precinct | [NAME] | [NAME] R ([NAME]) [NAME] | TOTALS
Precinct 2001 | 81 | 85 | 166
Precinct 2002 | 141 | 153 | 294
Precinct 2003 | 78 | 124 | 202
Precinct 2004 | 51 | 82 | 133
Precinct 2005 | 71 | 82 | 153
Precinct 2006 | 50 | 48 | 98
Precinct 2007 | 151 | 258 | 409
Precinct 2008 | 126 | 186 | 312
Precinct 2009 | 109 | 269 | 378
Precinct 2010 | 156 | 307 | 463
Precinct 2011 | 174 | 206 | 380
Precinct 2012 | 221 | 269 | 490
Precinct 2013 | 174 | 184 | 358
TOTAL | 1583 | 2253 | 3836
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 464668d1465247211-sum-if-help-please-book1
Sheet: Sheet1

Student (s) involved in incident by admission number | Weighting of incident | Date
252 | 2 | 2016-01-01 00:00:00
252 / 361 | 2 | 2016-01-05 00:00:00
300 | 1 | 2016-01-16 00:00:00
252 | 2 | 2016-01-21 00:00:00
361 | 3 | 2016-01-25 00:00:00
231 | 3 | 2006-02-02 00:00:00
252 | 2 | 2016-02-04 00:00:00
300 | 2 | 2016-02-05 00:00:00
 |  | January (weighting) | February (weighting)
Student No. | 252
 | 361
 | 300
 | 231
1)  Column A is a reference to a student (A3 contains two students IDS).  Column B refers to the severity of the incident so is weighted.  Column C date.
2) If I want to get the total weighting of incidents for student 252 for January the result would be 6 but it is only counting 4.  This looks as though it doesn't like my entry of the cell which contains two student ids.  Any ideas how to get round this.
3) my formula for student 231 for January and February is coming back as 0 when this for february should be 3.
Spreadsheet: 728625d1618545270-fomula-to-return-diff-results-based-on-criteria-lyon-20-21-test-2
Sheet: 21 (4)

 |  |  | REGIONAL DEVELOPMENT AUSTRALIA MURRAYLANDS & RIVERLAND
 |  |  |  |  |  | TIMESHEET
 | EMPLOYEE NAME |  |  |  | PAY | 19 |  | FY |  | Period beginning |  |  | 2025-03-06 00:00:00 |  | HOURS =
 |  |  |  |  |  |  |  | FEONE |  | Period ending
 | WEEK 1 | FRIDAY | SATURDAY | SUNDAY | MONDAY | TUESDAY | WED | THURSDAY | TOTAL HRS |  | CARRIED OVER ACCRUED TOTALS
 | DATE   __/__/__ |  |  |  |  |  |  |  |  |  | TOIL (MAX 10hrs Pre-Approved)
 | AM TOIL |  |  |  |  |  |  |  |  |  | ADDITIONAL APPROVED TOIL
 | Start |  |  |  |  | 08:30:00
 | Finish |  |  |  |  | 11:30:00 |  |  |  |  | CURRENT FORTNIGHT TOTALS
 | Breaks |  |  |  |  |  |  |  |  |  | TOTAL HOURS FOR FORTNIGHT
 |  |  |  |  |  |  |  |  |  |  | PAID FOR CONTRACTED HOURS |  |  |  |  | 3 days, 4:00:00
 | REGULAR HOURS |  |  |  |  |  |  |  |  |  | TOIL (MAX 10hrs Pre-Approved)
 | LEAVE TYPE |  |  |  | PUB HOL | TOIL | COMP LEAVE | COMP LEAVE |  |  | ADDITIONAL APPROVED TOIL (signed forms to be attached)
 | Start | 08:30:00 |  |  | 08:30:00 | 11:30:00 | 08:30:00 | 08:30:00
 | Finish | 17:06:00 |  |  | 17:06:00 | 17:06:00 | 17:06:00 | 17:06:00 |  |  | ACCRUED TOTALS
 | Breaks | 01:00:00 |  |  | 01:00:00 | 01:00:00 | 01:00:00 | 01:00:00 |  |  | PRE-APPROVED TOIL (MAX 10hrs)
 |  |  |  |  |  |  |  |  |  |  | ADDITIONAL APPROVED TOIL
 | PM TOIL
 | Start |  |  |  |  |  |  |  |  |  | TOIL TAKEN THIS PAY PERIOD
 | Finish |  |  |  |  |  |  |  |  |  | PRE-APPROVED TOIL
 | Breaks |  |  |  |  |  |  |  |  |  | FRI | MON | TUES |  | WED | THURS
 | Total Hours |  |  |  |  |  |  |  |  |  | FRI | MON | TUES |  | WED | THURS
 | WEEK 2 | FRIDAY | SATURDAY | SUNDAY | MONDAY | TUESDAY | WED | THURSDAY | TOTAL HRS |  | ADDITIONAL APPROVED TOIL
 | DATE _-/__/__ |  |  |  |  |  |  |  |  |  | FRI | MON | TUES |  | WED | THURS
 | AM TOIL
 | Start | 08:30:00 |  |  | 08:30:00 |  |  |  |  |  | FRI | MON | TUES |  | WED | THURS
 | Finish | 17:06:00 |  |  | 17:06:00
 | Breaks
 |  |  |  |  |  |  |  |  |  |  | FINAL ACCRUED TOTALS
 | REGULAR HOURS |  |  |  |  |  |  |  |  |  | PRE-APPROVED TOIL (MAX 10hrs)
 | LEAVE TYPE |  |  |  |  |  |  |  |  |  | ADDITIONAL APPROVED TOIL
 | Start | 10:30:00 |  |  | 08:30:00 | 08:30:00 | 08:30:00 | 08:30:00
 | Finish | 18:06:00 |  |  | 17:06:00 | 17:06:00 | 17:06:00 | 17:06:00 |  |  | Adustments to previous pay period required?
 | Breaks |  |  |  | 01:00:00 | 01:00:00 | 01:00:00 | 01:00:00 |  |  |  | YES | NO
 | PM TOIL |  |  |  |  |  |  |  |  |  | PROJECTS | CODE | HOURS |  | Forms for Additional TOIL Accural Provided
 | Start |  |  |  |  |  |  |  |  |  | Project Codes |  |  |  | Forms for Leave provided
 | Finish |  |  |  |  |  |  |  |  |  | Project Codes |  |  |  | Approved /checked
 | Breaks |  |  |  |  |  |  |  |  |  | Project Codes
 |  |  |  |  |  |  |  |  |  |  | Project Codes |  |  |  | PAYS
 | Total Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENTERED | DATE
 |  |  |  |  |  |  |  |  |  |  | Comments
 | I certify that to the best of my knowledge this record of attendance is true and correct
 | Employee signature |  |  |  |  | CEO signature
Spreadsheet: 784969d1656052057-add-holidays-to-calendar-daf-calendar-with-events-and-holidays-aligw
Sheet: Calendar

 |  |  |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | Month | 1
 | Year | 2022
 |  |  | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 1
 |  |  | 2 |  |  |  | Dentist appointment at 2 pm
 |  |  | 3 |  |  |  | Dinner with the [NAME]
 |  |  | 4 |  |  |  | New event
 |  |  | 5
 |  |  | 1
 |  |  | 2 |  |  |  | shopping for the boys
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
Spreadsheet: robin_rodrigue__33281__BasisRevised
Sheet: Correct Positions

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NATURAL GAS BASIS POSITIONS
 | AS REPORTED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BASIS BY TRADER
 | 2000-12-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intra-Month |  | Prompt Month |  | Winter 2000-2001 |  | Summer 2001 |  | Winter 2001-02 |  | Remainder |  | Total |  | Change
 | TIME BUCKET/KEY: |  |  |  | REPORT REGION |  |  |  |  |  |  |  |  |  |  | RISK TYPE |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-12-01 00:00:00 |  | 2001-01-01 00:00:00 |  | Feb-01/Mar-01 |  | Apr-01/Oct-01 |  | Nov-01/Mar-02 |  | Apr-02/May-28
 | West Region Basis Notional
 | NW/CIG
 | CLARK | IF-CIG/WINDRVR | IF-CIG/WIC | IF-CIG/RKYMTN | IF-NWPL_ROCKY_M |  | GDP-WYOMING | GDP-KERN/OPAL | GDP-NW STANFIEL | IF-CIG/RKYMTN | IF-CIG/WIC | IF-NWPL_ROCKY_M |  |  |  | IMCANBC |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | SUMAS
 | AECO/EMPRESS/STA2
 | COWAN |  | NGMR-AECO/C | CGPR-AECO/BASIS | CGPR-ALBR/BASIS |  | AECO-CDN/IM | [NAME] | CGPR-AECO/BASIS | AECO-CND/IM | GD-CGPR-AECO/AV | NGMR-AECO/C | AECO-US/IM |  |  | IMCANWE |  | -70.2125 |  | 0 |  | 59 |  | 0 |  | 0 |  | 0 |  | -11.2125 |  | -20.98650000000001
 | CORRECT POSITIONS
 | 2000-12-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intra-Month |  | Prompt Month |  | Winter 2000-2001 |  | Summer 2001 |  | Winter 2001-02 |  | Remainder |  | Total |  | Change
 | TIME BUCKET/KEY: |  |  |  | REPORT REGION |  |  |  |  |  |  |  |  |  |  | RISK TYPE |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000-12-01 00:00:00 |  | 2001-01-01 00:00:00 |  | Feb-01/Mar-01 |  | Apr-01/Oct-01 |  | Nov-01/Mar-02 |  | Apr-02/May-28
 | West Region Basis Notional
 | NW/CIG
 | CLARK | IF-CIG/WINDRVR | IF-CIG/WIC | IF-CIG/RKYMTN | IF-NWPL_ROCKY_M |  | GDP-WYOMING | GDP-KERN/OPAL | GDP-NW STANFIEL | IF-CIG/RKYMTN | IF-CIG/WIC | IF-NWPL_ROCKY_M |  |  |  | IMCANBC |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | SUMAS
 | CLARK | IF-CIG/WINDRVR | IF-CIG/WIC | IF-CIG/RKYMTN | IF-NWPL_ROCKY_M |  | GDP-WYOMING | GDP-KERN/OPAL | GDP-NW STANFIEL | IF-CIG/RKYMTN | IF-CIG/WIC | IF-NWPL_ROCKY_M |  |  |  | IMCANBC |  | -3 |  | -16 |  | 0 |  | 0 |  | 0 |  | 0
 | AECO/EMPRESS/STA2
 | COWAN |  | NGMR-AECO/C | CGPR-AECO/BASIS | CGPR-ALBR/BASIS |  | AECO-CDN/IM | [NAME] | CGPR-AECO/BASIS | AECO-CND/IM | GD-CGPR-AECO/AV | NGMR-AECO/C | AECO-US/IM |  |  | IMCANWE |  | -70.2125 |  | 189 |  | 59 |  | 0 |  | 0 |  | 0
 | CLARK | IF-CIG/WINDRVR | IF-CIG/WIC | IF-CIG/RKYMTN | IF-NWPL_ROCKY_M |  | GDP-WYOMING | GDP-KERN/OPAL | GDP-NW STANFIEL | IF-CIG/RKYMTN | IF-CIG/WIC | IF-NWPL_ROCKY_M |  |  |  | IMCANBC |  | 4 |  | -16 |  | 0 |  | 0 |  | 0 |  | 0
Spreadsheet: 859773d1708019057-combine-all-tables-of-the-workbook-into-one-but-column-headers-are-different-option-2
Sheet: Batch C21

 |  | Summary of Assessment Outcome  Name of Programme: det   Name of [NAME] SSO Name- swa
 |  | [NAME] result Sheet
 |  | Student ID | First Name | Surname | Result Unit 502  IV- tab | Result Unit 503   IV- tab | 1st Term Progression | Result Unit 417  IV- tab | Result Unit 506 IV- win | Result Unit 423 IV- win | 2st Term Progression | Result Unit 426 IV- tab | Result Unit 501 IV- tab | 3rd Term Progression | Unit Pass        out of 7 units | Certificate Claimed Yes/No | Claimed by | Date of Certificate Recieving | Received by | Certificate Claim File | Incorrect Name | [NAME] only File | Wrong Certificate only File | Correct Name As pe Passport | Checked by
 |  | 21099 | Karim | OLTEANU | Resit-Pass | Resit-Pass | PP | Resit-Pass | Resit-Pass | Pass | PP | Pass | Pass | PP | 7 | No |  | 14/02/2023 |  |  |  |  |  |  | 14th feb
 |  | 21114 | AHMED | CHOWDHURY | Pass | Pass | PP | Pass | Pass | Resit-Pass | PP | Pass | Pass | PP | 7 | YEs | Exam Officer |  |  |  |  |  |  |  | 24th May
 |  | 21149 | Chowdhury | AHMED | Resit-Pass | Resit-Pass | PP | Resit-Pass | Pass | Refer | PT | Pass | Pass | PT | 6 | No
 |  | 21126 | Sampson Osei | Begum | Resit-Pass | Resit-Pass | PP | Pass | Resit-Pass | Resit-Pass | PP | Not Submitted | Not Submitted | PT | 5 | No
 |  | 21077 | RAHAMAN | Begum | Pass | Pass | PP | Re-Refer | Pass | Pass | PT | Resit-Pass | Re-Refer | PT | 5 | Yes | Exam Officer | 2023-03-01 00:00:00 | Jhansi
 |  | 21131 | NAZRUL | FARUQ | Pass | Resit-Pass | PP | Resit-Pass | Re-Refer | Resit-Pass | PT | Re-Refer | Resit-Pass | PT | 5 | No
 |  | 21118 | FOYSAL | Karim | Pass | Pass | PP | Not Submitted | Pass | Pass | PT | Not Submitted | Not Submitted | PT | 4 | No
 |  | 21097 | Orohiri Zephirin | AHMED | Resit-pass | Pass | PP | Resit-Pass | Refer | Pass | PT | Not Submitted | Not Submitted | PT | 4 | No
 |  | 21084 | MD FAKHRU | Chowdhury | Pass | Resit-Pass | PP | Resit-Pass | Re-Refer | Re-Refer | PT | Re-Refer | Refer | PT | 3 | No
 |  | PP= Pass & Progress
 |  | PT= Progress with Trailing
 |  | Total Student |  |  | 31 | 31 |  | 31 | 31 | 31 |  | 31 | 31 | 31 | 19
 |  | Submission |  |  | 31 | 31 |  | 30 | 30 | 30 |  | 25 | 26
 |  | Submission Rate
 |  | Pass |  |  | 29 | 27 |  | 25 | 23 | 25 |  | 21 | 21
 |  | Refer |  |  | 2 | 4 |  | 5 | 7 | 5 |  | 4 | 5
 |  | Marking Pending |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0
 |  | Not Submitted |  |  | 0 | 0
 |  | Passing rate |  |  |  |  |  |  |  |  |  |  |  | Overall achievement Rate
Spreadsheet: mike_grigsby__27674__New_Gen_Sheet_ver2
Sheet: Summary

High Probability WSCC Projects
Report Date | 2000-05-18 00:00:00
Project | State | On-Line Date | Capacity | Region | Cumulative Capacity
Person | NM | 2000-05-01 00:00:00 | 140 | DSW
Manchief (Brush) | CO | 2000-06-01 00:00:00 | 265 | Rockies
Foote Creek 4 | WY | 2000-08-01 00:00:00 |  | PNW
Valmont Repowering | CO | 2000-06-01 00:00:00 | 11 | Rockies
Arapahoe Repowering | CO | 2000-06-01 00:00:00 | 115 | Rockies
South Point Power Plant [Mojave] | AZ | 2001-05-01 00:00:00 | 545 | DSW
Griffith Energy Project | AZ | 2001-05-01 00:00:00 | 520 | DSW
[NAME] | AZ | 2001-06-01 00:00:00 | 600 | DSW
Sutter | CA | 2001-09-01 00:00:00 | 500 | NP15
[NAME] | OR | 2001-07-01 00:00:00 | 500 | PNW
West Phoenix 4 - Repower | AZ | 2001-08-01 00:00:00 | 70 | DSW
[NAME] (Pittsburg) | CA | 2001-08-01 00:00:00 | 500 | NP15
La Paloma | CA | 2001-09-01 00:00:00 | 1048 | ZP26
Rathdrum | ID | 2001-09-01 00:00:00 | 270 | PNW
Vestas | OR | 2001-12-01 00:00:00 |  | PNW
West Phoenix 5 | AZ | 2001-12-01 00:00:00 | 500 | DSW
[NAME] | WA | 2001-12-01 00:00:00 | 248 | PNW
Coyote Springs Phase 2 | OR | 2002-03-01 00:00:00 | 231 | PNW
Delta Energy | CA | 2002-04-01 00:00:00 | 880 | NP15
Powhatan 48 | CO | 2002-05-01 00:00:00 | 150 | Rockies
Hermiston | OR | 2002-05-01 00:00:00 | 536 | PNW
Las Vegas CoGen Expansion | NV | 2002-06-01 00:00:00 | 220 | DSW
Little Sand Dam | OR | 2003-06-01 00:00:00 | -11 | PNW
Chehalis Power | WA | 2003-06-01 00:00:00 | 460 | PNW
Sumas Energy 2 | WA | 2003-06-01 00:00:00 | 660 | PNW
Wygen 1 | WY | 2003-12-01 00:00:00 | 80 | PNW
Two Elk CT Waste | WY | 2004-06-01 00:00:00 | 240 | PNW
Spreadsheet: 114371d1310117823-stacked-column-chart-that-groups-dates-by-month-book5
Sheet: Data

Month | Completed Date | Project | Work Units
Dec-10
Jan-11
Feb-11
Mar-11
Apr-11
May-11
Jun-11
Jul-11
Aug-11
Sep-11
Oct-11
Nov-11
Dec-11
 | 2010-12-15 00:00:00 | A | 30
 | 2010-12-20 00:00:00 | B | 67
 | 2010-12-23 00:00:00 | C | 92
 | 2011-02-14 00:00:00 | D | 108
 | 2011-02-16 00:00:00 | E | 50
 | 2011-02-18 00:00:00 | F | 45
 | 2011-02-18 00:00:00 | G | 29
 | 2011-04-04 00:00:00 | H | 38
 | 2011-04-06 00:00:00 | I | 8
 | 2011-05-06 00:00:00 | J | 256
 |  | K | 444
 | 2011-06-22 00:00:00 | L | 242
 |  | M | 21
 |  | N | 16
 |  | O | 29
 |  | P | 146
 |  | Q | 175
 |  | R | 191
Spreadsheet: 805562d1668767837-filter-formula-gives-empty-cells-competence
Sheet: Sheet1

Employees | 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 |  | Ordering | Identification | Expedition | BHV |  |  | 2022-01-02 00:00:00 | Hours | Ordering | Identification | Expedition | BHV
[NAME] |  |  |  |  |  |  | x |  | x | x
Roman |  |  |  |  |  |  | x | x | x
[NAME] |  |  |  |  |  |  |  | x |  |  |  |  | Becky
[NAME] |  |  |  |  |  |  |  |  | x | x |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  | x |  |  |  | Brock
Edge |  |  |  |  |  |  | x |  | x | x |  |  | [NAME]
Brock |  |  |  |  |  |  | x |  |  |  |  |  | Edge
[NAME] |  |  |  |  |  |  | x |  |  | x |  |  | [NAME]
Becky |  |  |  |  |  |  | x | x | x |  |  |  | [NAME]
Nikki |  |  |  |  |  |  | x | x | x |  |  |  | Nikki
[NAME] |  |  |  |  |  |  |  | x |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  | x |  |  | Roman
[NAME] |  |  |  |  |  |  | x |  | x |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Because I have a formula in these cells the filter formula takes this as data in the formula, is there a way the
formula skips cells with a formula?
Spreadsheet: 46a4f50d-a325-46e4-938d-b0af22853d22
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | City of Tempe | Unnamed: 8
 |  |  |  |  |  |  | P.O. Box 5002
 |  |  |  |  |  |  | 31 East Fifth Street
 |  |  |  |  |  |  | Tempe, AZ  85280
 |  |  |  |  |  |  | Public Works/Engineering Division
 |  |  |  |  |  |  | [PHONE] (phone)
 |  |  |  |  |  |  | [PHONE] (fax)
Project Name: |  |  |  |  |  |  | Payment No.
Project No: |  |  | City of Tempe Project Manager:
Consultant Name: |  |  |  |  |  |  | Phone:
Address:
Billing Period: |  |  |  | to |  |  | Date Sumitted:
Completion to Date: |  |  | Total Time Elapsed: |  |  | Contract Completion Date:
Pay Period Activity (revise pay items to match contract):
Pay Items |  | Total Budget |  | Completed to Date |  | [NAME] |  | Due this Period
Design Services |  | 0 |  | 0 |  | 0 |  | 0
Post-Design Serv. |  | 0 |  | 0 |  | 0 |  | 0
Reimbursables |  | 0 |  | 0 |  | 0 |  | 0
Allowance |  | 0 |  | 0 |  | 0 |  | 0
 |  | 0 |  | 0 |  | 0 |  | 0
 |  | 0 |  | 0 |  | 0 |  | 0
 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  | 0 |  | 0
Contract Summary: |  |  |  |  |  | Encumbrance No:
Original Contract Amount: |  |  | 0
[NAME] to Date: |  |  | 0 |  |  | CITY USE ONLY
Current Contract Amount: |  |  | 0 |  |  | Approved:
Total Previously Invoiced: |  |  | 0
 |  |  |  |  |  | Date:
Contract Balance: |  |  | 0
Revised: 2/10/12
Spreadsheet: 672451d1586874983-having-trouble-with-ranking-columns-in-excel-hong-kong-sheet
Sheet: Sheet1

 |  |  | Class 5 - 1800M - (040-000) - Turf - "C" Course - GoodTSIM SHA TSUI HANDICAP
 |  |  | Race Time: | -13.67 | -35.99 | (1:00.05) | (1:23.72) | (1:47.75)
 |  |  | Sectional Time: | 13.67 | 22.32 | 24.06 | 23.67 | 24.03
Finishing Order | Horse No | Horse | Running Position & Margin Behind Leader |  |  |  |  |  | Time | Time in seconds |  | Finishing Order | Horse No | Horse | Running Position & Margin Behind Leader |  |  |  |  |  |  | Time in seconds |  | Days Since Last Run
 |  |  | Sectional Time |  |  |  |  |  |  |  |  |  |  |  | Sectional Time
 |  |  | 1st Sec. | 2nd Sec. | 3rd Sec. | [NAME]. | 5th Sec. | 6th Sec. |  |  |  |  |  |  | 1st Sec. | 2nd Sec. | 3rd Sec. | [NAME]. | 5th Sec. | 6th Sec. |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6
1 | 5 | MCMUNIGAL(B335) | 32-1/4 | 43-1/4 | 43 | 32 | 12-1/4 |  | 00:01:47.750000
 |  |  | 14.03 | 22.48 | 24.02 | 23.51 | 23.71
2 | 3 | VICTORIOUS SEEKER(C091) | 53-3/4 | 65-1/4 | 54-1/4 | 53 | 22-1/4 |  | 00:01:48.120000
 |  |  | 14.27 | 22.56 | 23.90 | 23.47 | 23.92
3 | 4 | FORTUNE PATROL(A245) | 137-3/4 | 139-1/4 | 138-1/4 | 117 | 34-3/4 |  | 00:01:48.510000
 |  |  | 14.91 | 22.56 | 23.90 | 23.47 | 23.67
4 | 6 | AEROFLASH(C310) | 95-1/2 | 96-3/4 | 96-1/4 | 74-1/2 | 45-1/2 |  | 00:01:48.620000
 |  |  | 14.55 | 22.52 | 23.98 | 23.39 | 24.18
5 | 12 | WICKER(B425) | 21-3/4 | 33 | 32-3/4 | 42-1/4 | 56 |  | 00:01:48.700000
 |  |  | 13.95 | 22.52 | 24.02 | 23.59 | 24.62
6 | 7 | MASTER ROMAN(B455) | 85-1/4 | 86-3/4 | 85-3/4 | 84-1/2 | 66-1/4 |  | 00:01:48.750000
 |  |  | 14.51 | 22.56 | 23.90 | 23.47 | 24.31
7 | 10 | GOLDEN GENERAL(A346) | 149-1/4 | 1410-1/4 | 149-1/4 | 148-1/2 | 76-1/4 |  | 00:01:48.770000
 |  |  | 15.15 | 22.48 | 23.90 | 23.55 | 23.69
8 | 8 | CHIU CHOW KID(T412) | 74-1/2 | 54-1/2 | 64-1/2 | 63-1/4 | 86-1/2 |  | 00:01:48.800000
 |  |  | 14.39 | 22.32 | 24.06 | 23.47 | 24.56
9 | 11 | REEVE'S MUNTJAC(C174) | 127-1/4 | 128-1/4 | 127-1/2 | 107 | 97-1/4 |  | 00:01:48.900000
 |  |  | 14.83 | 22.48 | 23.94 | 23.59 | 24.06
10 | 14 | MONEY MARSHAL(B134) | 11-3/4 | 11-1/4 | 11-1/4 | 11-1/4 | 107-3/4 |  | 00:01:48.990000
 |  |  | 13.67 | 22.32 | 24.06 | 23.67 | 25.27
11 | 2 | [NAME]) | 117-1/4 | 118 | 117-1/4 | 97 | 118-3/4 |  | 00:01:49.170000
 |  |  | 14.83 | 22.44 | 23.94 | 23.63 | 24.33
12 | 9 | SKY GEM(C251) | 106-3/4 | 108 | 107 | 127-1/4 | 1210-1/4 |  | 00:01:49.390000
 |  |  | 14.75 | 22.52 | 23.90 | 23.71 | 24.51
13 | 13 | LITTLE ISLAND(T390) | 42-3/4 | 21-1/4 | 21-1/4 | 21-1/4 | 1314 |  | 00:01:50
 |  |  | 14.11 | 22.08 | 24.06 | 23.67 | 26.08
14 | 1 | AMAZING AGILITY(V192) | 64 | 76-1/2 | 75-1/2 | 137-1/2 | 1452-1/4 |  | 00:01:56.110000
 |  |  | 14.31 | 22.72 | 23.90 | 23.99 | 31.19