tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 148554d1333465437-possible-to-not-display-a-formula-result-if-less-than-say-0-new-new-new-rota-version2
Sheet: DATA

NAME | am |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pm
 | 1900-01-01 00:00:00 | 12:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
DAZ WALKER
ANDREW THORPE
DENSISE BROADLEY
MISSING SHIFT
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
ANTHONY POOLE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
CHRIS ATTERTON |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
MISSING SHIFT
[NAME]
[NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME]
GARI ELLIS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME]
DAN HERITAGE
ANTH STELMACH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
RYAN WALKER
DANIEL CHOW
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 1900-01-01 00:00:00 | 12:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00
TOTALS
 | AM | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | PM | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Spreadsheet: darrell_schoolcraft__7316__imball0202
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 |  | 97274
78311 |  | 36600 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 |  | 112318 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 |  | 118923
500293 |  | 60795
500302 |  | 909
500303 |  | 2033
500305 |  | 158070
500307 |  | 4256
500313 |  | 202
500314
500655
500657
INDEX
2002-01-31 00:00:00 |  |  | 121933.25
2002-02-03 00:00:00
CBS Volume
 |  |  | 70617
Spreadsheet: 839091d1691655152-display-prices-based-on-entered-and-display-currency-codes-book1
Sheet: Pricing Entry

 |  | Price entered in: | Output wanted in:
 | ITEMS | THB | KIP | <-- Enter both currency codes
 | Adaptors, Universal | 400 |  | <-- Output price based on currency I entered Vs currency I want to display
 | Torch Batteries | 55 |  | <-- Output price based on currency I entered Vs currency I want to display
 | Torch with clip to hang in the wardrobe | 800 |  | <-- Output price based on currency I entered Vs currency I want to display
 | [NAME] trolleys | 900 |  | <-- Output price based on currency I entered Vs currency I want to display
 | Cradle and Linen + Blanket | 1000 |  | <-- Output price based on currency I entered Vs currency I want to display
 | [NAME] cover | 4500 |  | <-- Output price based on currency I entered Vs currency I want to display
 | Electric water kettle | 350 |  | <-- Output price based on currency I entered Vs currency I want to display
 | Coffee Capsules (for [NAME] only) | 35 |  | <-- Output price based on currency I entered Vs currency I want to display
 | Coffee Capsules (for [NAME] only) | 35 |  | <-- Output price based on currency I entered Vs currency I want to display
 | [NAME] | 350 |  | <-- Output price based on currency I entered Vs currency I want to display
 | Tea Dilmah-Sencha Green Tea | 34 |  | <-- Output price based on currency I entered Vs currency I want to display
 | Tea Dilmah-Peppermint | 34 |  | <-- Output price based on currency I entered Vs currency I want to display
 |  |  |  |  |  | Currency table: FIXED by our finance team once a year
 |  |  |  |  |  |  |  | FIXED
 |  |  |  |  |  | US Dollar | USD | 1
 |  |  |  |  |  | Thailand | THB | 35 | equivalent to 1 USD
 |  |  |  |  |  | Vietnam | VND | 23400 | equivalent to 1 USD
 |  |  |  |  |  | India | INR | 80 | equivalent to 1 USD
 |  |  |  |  |  | Indonesia | IDR | 15300 | equivalent to 1 USD
 |  |  |  |  |  | Laos | KIP | 20000 | equivalent to 1 USD
 |  |  |  |  |  | Philippines | PHP | 56 | equivalent to 1 USD
 |  |  |  |  |  | Japan | [NAME] | 143 | equivalent to 1 USD
Spreadsheet: 00aa7d41-e6d0-4ef3-995e-c05433a75cca
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6345.0 Labour Price Index, Australia
 | Total Hourly Rates of Pay Excluding Bonuses: Public Sector by State, Original (Quarterly Index Numbers)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  New South Wales ;  All industries ;  Public ;  All occupations ; |  |  | Original | A2159245J | 1997-09-01 00:00:00 | 2009-06-01 00:00:00 | 48 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Victoria ;  All industries ;  Public ;  All occupations ; |  |  | Original | [NAME] | 1997-09-01 00:00:00 | 2009-06-01 00:00:00 | 48 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Queensland ;  All industries ;  Public ;  All occupations ; |  |  | Original | A2159247L | 1997-09-01 00:00:00 | 2009-06-01 00:00:00 | 48 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  South Australia ;  All industries ;  Public ;  All occupations ; |  |  | Original | A2159248R | 1997-09-01 00:00:00 | 2009-06-01 00:00:00 | 48 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Western Australia ;  All industries ;  Public ;  All occupations ; |  |  | Original | A2159249T | 1997-09-01 00:00:00 | 2009-06-01 00:00:00 | 48 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Tasmania ;  All industries ;  Public ;  All occupations ; |  |  | Original | A2159250A | 1997-09-01 00:00:00 | 2009-06-01 00:00:00 | 48 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Northern Territory ;  All industries ;  Public ;  All occupations ; |  |  | Original | A2159251C | 1997-09-01 00:00:00 | 2009-06-01 00:00:00 | 48 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Australian Capital Territory ;  All industries ;  Public ;  All occupations ; |  |  | Original | A2159252F | 1997-09-01 00:00:00 | 2009-06-01 00:00:00 | 48 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Australia ;  All industries ;  Public ;  All occupations ; |  |  | Original | A2159253J | 1997-09-01 00:00:00 | 2009-06-01 00:00:00 | 48 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2009
Spreadsheet: 41d2e791-05c2-45af-93bf-bd2fa5ec1fb5
Sheet: Sheet1

Animal Rabies, by County and Public Health District, Maine 2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Number
County
 | Androscoggin | 4
 | Aroostook | 0
 | Cumberland | 20
 | Franklin | 4
 | Hancock | 0 |  |  | Animal Rabies, by Year, 2002-2011
 | Kennebec | 5
 | Knox | 4 |  |  | Year | Number
 | Lincoln | 3 |  |  | 2002 | 67
 | Oxford | 8 |  |  | 2003 | 82
 | [NAME] | 3 |  |  | 2004 | 69
 | Piscataquis | 0 |  |  | 2005 | 61
 | Sagadahoc | 3 |  |  | 2006 | 127
 | Somerset | 4 |  |  | 2007 | 86
 | [NAME] | 4 |  |  | 2008 | 64
 | Washington | 0 |  |  | 2009 | 56
 | York | 4 |  |  | 2010 | 62
Public Health District |  |  |  |  | 2011 | 66
 | Aroostook | 0 |  |  | US total | 6155
 | Central | 9
 | Cumberland | 20 |  |  | Data Source: Maine Laboratory Information Management System (StarLIMS)
 | Downeast | 0
 | [NAME] | 14
 | Penquis | 3
 | Western | 16
 | York | 4
Data Source:  Maine Laboratory Information Management System (StarLIMS)
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Terry Macaig

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
No response
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
I was on the commission to study retirement and benefits and supported your positions on all issues including funding.
Health Care: Continuing System Reform
Agree
Explain your health care reform position, if you choose
As long as health care is grandfathered we are safe with our benefits. Collective bargaining should be preserved.
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
No response
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
No response
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 82 [NAME]. Williston, VT | state representative | Yes |  | Chittenden
Spreadsheet: 112605d1308680612-help-with-if-statement-gradebook-1-modified-
Sheet: Sheet1

 | Assignment Number |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  | 18 |  | 19 | 20 | Grade
 | Assignment Category |  | TST | HW | FIN | WKS | HW | PJT | FIN | WKS | WKS | PJT | HW
 | Assignment Value |  | 100 | 100 | 100 | 200 | 100 | 100 | 100 | 100 | 100 | 100 | 100
1 |  |  | 100 | 90 | 90 | 90 | 100 | 68 | 100 | 100 | 100
2 |  |  | 100 | 100 | 100 | 0 | 100 | 60 | 0 | 90 | 100
3 |  |  | 80 | 100 | 100 | 100 | 100 | 62 | 100 | 90 | 100
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Categories
 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5
 |  |  |  | Average |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Woorksheet | Test | Homework | Project | Final
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WKS | TST | HW | PJT | FIN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Percent | 30 | 30 | 0 | 0 | 40
Spreadsheet: 789152d1658930962-split-dollar-amount-into-different-amounts-based-on-percentage-copy-of-invoice-approval-splits-bg-sfy-2022
Sheet: Office Supplies--FPP Only

 |  |  |  | USPIRITUS INVOICE APPROVAL FORM
 |  | Person  Requesting |  |  |  | Date
 |  | Supervisor Approval
 | General [NAME]
 | GL | Fund | Department | Event | Location | Grant | Restriction | Amount
 | 8110 | 01 | 481 | N000 | 31 | 35 | 1
 | 8110 | 01 | 482 | N000 | 31 | 35 | 1
 | 8110 | 01 | 483 | N000 | 31 | 35 | 1
 |  | 01
 |  | 01
 |  | 01
 |  | 01
 |  | 01
 |  | 01
 |  |  |  |  |  |  | TOTAL | 183
 | NOTES:
Spreadsheet: 684561d1593443836-sumifs-with-multiple-criteria-in-multiple-columns-sample
Sheet: Sheet1

Session | Date | Rota | Name | Time | Interaction | Activity | OF | OT | Minutes spent | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | Behaviour 1 | Behaviour 2 | Behaviour 3 | N/A | Behaviour 4
1 | 28.06.16 |  | Name 1 |  | None |  |  |  | 5 |  |  |  |  |  |  |  |  | 5 | 5 | 4 |  | 5 |  | Name 1 | None
 | 28.06.16 |  | Name 1 |  | None |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | Mins per session | Behaviour count | Rate per min | [NAME]. 1 | [NAME]. | [NAME]. 3 | [NAME]. 4
 | 28.06.16 |  | Name 1 |  | Level 2 |  |  |  | 3 |  |  |  |  |  |  |  |  | 1 | 3 | 0 |  | 6 |  | 28.05.16
 | 28.06.16 |  | Name 1 |  | None |  |  |  | 1 |  |  |  |  |  |  |  |  | 2 | 3 | 2 |  | 1 |  | 31.05.16
 | 28.06.16 |  | Name 1 |  | Level 2 |  |  |  | 2 |  |  |  |  |  |  |  |  | 0 | 1 | 3 |  | 3 |  | 05.06.16
 | 28.06.16 |  | Name 1 |  | None |  |  |  | 2 |  |  |  |  |  |  |  |  | 2 | 5 | 7 |  | 4 |  | 07.06.16
 | 28.06.16 |  | Name 1 |  | None |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08.06.16
 | 28.06.16 |  | Name 1 |  | None |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.06.16
2 | 28.06.16 |  | Name 2 |  | Level 1 |  |  |  | 2 |  |  |  |  |  |  |  |  | 4 | 4 | 3 |  | 2 |  | 14.06.16
 | 28.06.16 |  | Name 2 |  | None |  |  |  | 1 |  |  |  |  |  |  |  |  | 0 | 2 | 3 |  | 3 |  | 18.06.16
 | 28.06.16 |  | Name 2 |  | Level 1 |  |  |  | 3 |  |  |  |  |  |  |  |  | 6 | 5 | 5 |  | 7 |  | 22.06.16
 | 28.06.16 |  | Name 2 |  | Level 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26.06.16
 | 28.06.16 |  | Name 2 |  | Level 3 |  |  |  | 4 |  |  |  |  |  |  |  |  | 7 | 7 | 9 |  | 0 |  | 05.07.16
 | 28.06.16 |  | Name 2 |  | Level 1 |  |  |  | 3 |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 |  | 09.07.16
3 | 30.06.16 |  | Name 5 |  | Level 3 |  |  |  | 5 |  |  |  |  |  |  |  |  | 0 | 3 | 3 |  | 1 |  | 12.07.16
 | 30.06.16 |  | Name 5 |  | None |  |  |  | 6 |  |  |  |  |  |  |  |  | 4 | 4 | 2 |  | 6 |  | 13.07.16
 | 30.06.16 |  | Name 5 |  | None |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17.07.16
 | 30.06.16 |  | Name 5 |  | Level 2 |  |  |  | 4 |  |  |  |  |  |  |  |  | 1 | 4 | 3 |  | 1 |  | 20.07.16
 | 30.06.16 |  | Name 5 |  | Level 1 |  |  |  | 1 |  |  |  |  |  |  |  |  | 7 | 4 | 6 |  | 8 |  | 23.07.16
 | 30.06.16 |  | Name 5 |  | None |  |  |  | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 1 |  | 1 |  | 27.07.16
 | 30.06.16 |  | Name 5 |  | Level 2 |  |  |  | 2 |  |  |  |  |  |  |  |  | 1 | 0 | 0 |  | 6 |  | 30.07.16
 | 30.06.16 |  | Name 5 |  | Level 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31.07.16
Spreadsheet: 165523d1341256531-variable-print-output-display-as-well-if-possible-example-1
Sheet: Office 2

Office # 2 |  | Phone Number | Fax Number |  | Last Updated
Region b |  | 1987654321 | 1987654320 |  | 2012-07-02 00:00:00
456 Avenue St.
TheCity, TheState, 98765
 |  | Name | Cell Number | Home Number | Vehicle # | Manual 1 | Manual 2
Type 1 Manager |  | [NAME] | 4567891230
Type 2 Manager
Type 3 Manager
Type 4 Manager |  | [NAME] | 2345678910
Type 5 Manager |  | [NAME] | 7894561230
Type 6 Manager
Certified Workman |  | [NAME] | 6549873120
Administrative Assistant |  | [NAME] | 5498732160
Regional Administrator |  | [NAME] | 1472583690
Workman |  | [NAME] | 7538691420
Scheduler |  | Trisha Street | 3261594870
Document Processer |  | [NAME] | 8765432190
Control Staff |  | [NAME] | 1122334455
Installation Technicians | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
Measure Technicians | 1
 | 2
 | 3
 | 4
Service Technicians | 1
 | 2
 | 3
 | 4
Other Technicials | 1
 | 2
 | 3
 | 4
[NAME]
Spare Van
Work Van
Trailers | 1
 | 2
 | 3
 | 4
Spreadsheet: 3acd49a4-fc30-4698-85de-ff7dd0c856c1
Sheet: JSTOR

JSTOR
2010-2011
COUNTER-compliant: Yes
 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | #[NAME]! | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | Total | 2010-2011 Price | Price per unit
JSTOR
Sessions | 2378 | 902 | 3248 | 5673 | 7947 | 6019 | 1500 | 5271 | 6532 | 8607 | 4514 | 1715
Searches | 3339 | 882 | 4491 | 9690 | 16186 | 9976 | 2158 | 8144 | 11260 | 13432 | 6950 | 2162 |  | 0
Turnaways | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Spreadsheet: 85427d1285529905-autofill-vlookup-function-stats-aggregate-example
Sheet: Week 13

TEAM AWESOME | ACW | Not Ready | Transfers | Hold | [NAME] | Unplanned Break |  | Customer CSAT Survey (Week 11) | CSAT/Side By Side (Week13) | CSAT Average
1-2-1 = Done
1-2-1 = Ready
Week 13       Targets: | 00:00:20 | 0.15 | 0.15 | 00:01:10 | 0.07 | 0.005 |  | 3.5 | 3.5 | 3.5
user 1
user 2 | 0:00:25.442000 | 0.07235621521335807 | 0.1714285714285714 | 0:01:58.086000 | 0.0677815335349582 | 0 |  | 1
user 3
user 4 |  |  |  |  |  |  |  | 1
user 5
user 6 | 0:00:22.146000 | 0.1546723592592179 | 0.2307692307692308 | 0:02:36.105000 | 0.0799011992444648 | 0.005632984252232516 |  | 4 | 4.4
user 7 | 0:00:20.830000 | 0.127387350281998 | 0.28486646884273 | 0:00:35.368000 | 0.06843017810048295 | 0.003434462875249945 |  |  | 3.8
user 8 |  |  |  |  |  |  |  |  |  |  |  |  | Customer Install:
user 9 | 0:00:19.265000 | 0.1702207369888058 | 0.1574803149606299 | 0:00:39 | 0.06930811766645187 | 0.00554464941331615 |  |  | 4.7 |  |  |  | ACW=20s
user 10 | 0:00:12.962000 | 0.1236380931474774 | 0.2966666666666667 | 0:01:13.003000 | 0.09357187282771741 | 0.004331760143416383 |  |  |  |  |  |  | Not Ready=15%
user 11 |  |  |  |  |  |  |  | 4 |  |  |  |  | Total Transfers=15% or less
user 12 | 0:00:45.396000 | 0.1700116810024424 | 0.169811320754717 | 0:00:32.245000 | 0.05139641074652225 | 0 |  |  |  |  |  |  | Hold=1min, 10sec
user 13 | 0:00:40.867000 | 0.1080371213447733 | 0.1886792452830189 | 0:02:23.623000 | 0.06699352127473297 | 0 |  | 2.25
user 14 | 0:00:37.356000 | 0.1300765297919547 | 0.1277777777777778 | 0:02:10.033000 | 0.0680407730152095 | 0.002709090324447732 |  | 4 | 2.9
user 15 | 0:00:11.643000 | 0.1296310883549954 | 0.2737430167597765 | 0:01:34.659000 | 0.07840357095969544 | 0.01599054745962978
user 16 | 0:00:10.305000 | 0.1199290622921747 | 0.2414965986394558 | 0:01:38.980000 | 0.09146921903321294 | 0.001147521744233051 |  | 3.67 | 4
user 17 | 0:00:55.415000 | 0.1935389314861383 | 0.2666666666666667 | 0:01:40.933000 | 0.09051358398000586 | 0.01218778444591864
user 18 | 0:00:22.117000 | 0.1392035305243249 | 0.3205741626794258 | 0:02:11.866000 | 0.07865924135757064 | 0.01798886203635599 |  |  | 3.4
user 19 | 0:00:19.679000
user 20
Team Average
Spreadsheet: 772784d1647460168-sumif-multiple-criteria-forum
Sheet: Salary Projections

Salary Projections
Total Hours = Work Hours + (Work Hours x 20% Leave Assessment) | Example: if I work 80 hours, only 64 hours are working hours and 20 hours are for leave assessment
Staff | Works Hours or Total Hours | Hours | Work Hours | Leave  Hours | Total  Hours  (Work + Leave) | Estimated  Pay Rate  (Salary + Benefits) | Work Cost  (Salary + Benefits) | Leave  Assessment | Total Cost
[NAME] | Total Hours (includes Leave Hours) | 80 |  |  | 80 | 10
[NAME] | Work Hours | 80 | 80 |  |  | 10
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 22

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
22 | 2007-02-19 00:00:00 | 7.5 | 1.46 | 9 | 3.5 | 4.4 | 3.6 |  |  |  | 9.5 |  | 2.489015869776647 | 2.2 | 0 | 8 |  |  |  |  | 0.5
Well #22 | 2013-10-11 00:00:00 | 7.8 | 2.05 | 11.17 | 4.24 | 4.3 | 5.3 |  |  | 0.9 | 13.7 |  | 1.6 | 4.2 | 0.04 | 7.2 |  | <0.10 | <0.02 |  | 1
Well - 22 | 2014-02-04 00:00:00 | 7.8 | 2.03 | 11.61 | 4.3 | 4.7 | 5.1 |  |  | 1 | 14.8 |  | 1.7 | 4.5 | 0.04 | 8.8 |  | <0.10 | <0.02 |  | 1
Well 22 | 2016-04-01 00:00:00 | 7.82 | 2.259 | 12.53 | 4.609999999999999 | 4.72 | 5.10550715370474 | 5.10550715370474 | 0 | 1.19 | 14.226 | 1446.4 | 1.61 | 4.12 | 0.016 | 9.533800000000001 | 0.028 | 0.039 | 0.013 | 0.144
[NAME] | 2018-05-29 00:00:00 | 7.77 | 1.95 | 12.9 | 4.72 | 5.79 |  | 5.019582767164895 | 0 | 1.24 | 8.942 | 1248 |  |  | 0.051 | 7.957 | 0.053 | 0 | 0 | 0.007
Spreadsheet: 118364d1313622860-excel-2007-pivot-table-data-filtering-test-deh-report
Sheet: Pivot Table

Vessel | A
Space | Date | Sum of Dew Point
Tank 1
 | 2011-11-02 00:00:00 | 25
 | 2011-11-01 00:00:00 | 20
 | 2011-10-01 00:00:00 | 14
 | 2011-01-01 00:00:00 | 20.1
 | 2009-01-01 00:00:00 | 0
Tank 2
 | 2011-10-08 00:00:00 | 21
 | 2011-08-01 00:00:00 | 18.6
 | 2009-01-01 00:00:00 | 0
Tank 3
 | 2011-02-04 00:00:00 | 17.3
 | 2011-01-04 00:00:00 | 17.1
 | 2009-01-01 00:00:00 | 0
Tank 4
 | 2011-02-04 00:00:00 | 17.4
 | 2011-01-04 00:00:00 | 17.2
 | 2009-01-01 00:00:00 | 0
Spreadsheet: 490559d1479921615-sheet-auto-populate-based-on-input-values-example
Sheet: Sheet1

Cost type
Maintenance
Start date
End date
Spreadsheet: andy_zipper__169__DYNEGY-ICE VOL Apr13
Sheet: ICE-EPM

Enron Power Marketing
Activity on ICE
UOM | Deals | Volume
MWhs
 |  |  |  |  |  |  | START | END
Enron Power Marketing, Inc.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-13-01 thru Apr-13-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Apr-13-01 | 100441583 |  | Bought | Firm-LD Peak | Cin | Jul01-Aug01 | Jul-01-01 | Aug-31-01 |  |  |  | Allegheny Energy Supply Company, LLC | 124.25 | USD / MWh | 50 | Hourly | 35200 | MWhs | [NAME], R
Apr-13-01 | 149976167 |  | Bought | Firm-LD Peak | Cin | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | Duke Energy Trading and Marketing LLC | 53.7 | USD / MWh | 50 | Hourly | 17600 | MWhs | [NAME], R
Apr-13-01  Deals
Spreadsheet: 275131d1383336408-how-to-show-values-less-than-or-equal-to-another-value-in-drop-down-list-data-validation-marbles-4-
Sheet: Sheet1

Number of marbles |  | validation is here |  |  |  |  |  |  | Bag | Capacity of bag | validation calc
10 |  |  |  |  |  |  |  |  | small bag | 60
 |  |  |  |  |  |  |  |  | large bag | 300
 |  |  |  |  |  |  |  |  | extra large bag | 450
 |  |  |  |  |  |  |  |  | normal bag | 150
 |  |  | in name manager |  |  |  |  |  | very small bag | 30
 |  |  | insert a named formula of
 |  |  | myrange | =Sheet1!$L$2:INDEX(Sheet1!$L$2:$L$5,COUNTIF(Sheet1!$L$2:$L$5,"<>0"))
Spreadsheet: 3a1e382b-b70d-452d-98d9-662c786cc8d2
Sheet: 2006 aflatoxin

Gibbs Farm 2006 aflatoxin analysis results
row | point | aflatoxin (ppb)
0 | 1 | 63
0 | 2 | 49
0 | 3 | 25
0 | 4 | 18
0 | 5 | 44
0 | 6 | 27
0 | 7 | 22
0 | 8 | 16
0 | 9 | 13
0 | 10 | 11
0 | 11 | 15
0 | 12 | 10
0 | 13 | 120
0 | 14 | 11
0 | 15 | 19
0 | 16 | 70
0 | 17 | 9
1 | 1 | 9
1 | 2 | 12
1 | 3 | 9
1 | 4 | 9
1 | 5 | 20
1 | 6 | 44
1 | 7 | 18
1 | 8 | 16
1 | 9 | 25
1 | 10 | 12
1 | 11 | 10
1 | 12 | 14
1 | 13 | 11
1 | 14 | 21
1 | 15 | 10
1 | 16 | 32
1 | 17 | 64
2 | 1 | 93
2 | 2 | 18
2 | 3 | 13
2 | 4 | 10
2 | 5 | 17
2 | 6 | 8
2 | 7 | 10
2 | 8 | 16
2 | 9 | 7
2 | 10 | 12
2 | 11 | 41
2 | 12 | 20
2 | 13 | 7
2 | 14 | 96
3 | 1 | 17
3 | 2 | 55
3 | 3 | 14
3 | 4 | 9
3 | 5 | 13
3 | 6 | 18
3 | 7 | 12
3 | 8 | 9
3 | 9 | 10
3 | 10 | 10
3 | 11 | 10
3 | 12 | 8
3 | 13 | 14
3 | 14 | 12
4 | 1 | 16
4 | 2 | 15
4 | 3 | 12
4 | 4 | 10
4 | 5 | 35
4 | 6 | 7
4 | 7 | 23
4 | 8 | 92
4 | 9 | 24
4 | 10 | 110
4 | 11 | 7
4 | 12 | 26
4 | 13 | 17
4 | 14 | 88
Spreadsheet: 839024d1691596251-template-sheet-that-when-edited-updates-all-sheets-template-for-updating-sheets
Sheet: TemplateSheet

 | These cells are user input
 | These cells are Excel output
Graphic Design
Starting $ | = user input |  | Fancy Title
Name | Date | Add $ | OG Description | New Total $ | Notes | Links
Name 1 |  | = user input |  | =B11 + C15
Name 2 |  | = user input |  | =E15 + C16
Name 3 |  | = user input |  | =E16 + C17
Name 4 |  | = user input
Name 5 |  | = user input
Name 6 |  | = user input
Name 7 |  | = user input