tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 61637d1262585787-excel-2007-whther-sumif-to-be-used-or-some-other-formula-may-work-712590-whther-sumif-to-be-used-or-some-other-formula-may-work
Sheet: Sheet1

CUSTID | CLOSDT | OSNPADT
D10369761 | 2009-01-20 00:00:00 | -410016 | 0
550087030 | 27-07-2005 | -43561 | 0
550087896 |  | -349779 | 0
550088198 |  | -355257.1 | 0
550144835 |  | -270824 | 0
550217772 | 23-02-2008 | -27969 | 1 | -471151 |  |  | Sum of OSNPADT
550217772 |  | -143182 | 1 | -471151 |  |  | CUSTID | Total
550217772 |  | -300000 | 0 |  |  |  | 550087030 | -43561
550217806 | 16-06-2009 | -494361 | 0 |  |  |  | 550087896 | -349779
550896707 | 2008-04-10 00:00:00 | -19217 | 0 |  |  |  | 550088198 | -355257.1
550900962 | 2008-04-10 00:00:00 | -825511 | 0 |  |  |  | 550144835 | -270824
550972049 | 2008-04-11 00:00:00 | -6261 | 0 |  |  |  | 550217772 | -471151
550972051 | 2008-04-04 00:00:00 | -5788 | 0 |  |  |  | 550217806 | -494361
551344092 | 2008-04-04 00:00:00 | -1429 | 0 |  |  |  | 550896707 | -19217
551359310 | 2008-04-05 00:00:00 | -15356 | 0 |  |  |  | 550900962 | -825511
551371692 | 2008-04-10 00:00:00 | -100 | 0 |  |  |  | 550972049 | -6261
551371817 | 2008-04-12 00:00:00 | -10467 | 0 |  |  |  | 550972051 | -5788
551372069 | 2008-04-12 00:00:00 | -43391 | 0 |  |  |  | 551344092 | -1429
551372208 | 2008-04-12 00:00:00 | -7608 | 0 |  |  |  | 551359310 | -15356
551372224 | 2008-04-12 00:00:00 | -100 | 0 |  |  |  | 551371692 | -100
551372260 | 2008-04-12 00:00:00 | -100 | 0 |  |  |  | 551371817 | -10467
551372277 | 2008-04-12 00:00:00 | -100 | 0 |  |  |  | 551372069 | -43391
551372295 | 2008-04-12 00:00:00 | -100 | 0 |  | I want to sum amount outstanding in Column C, corresponding to a customer id in column A |  | 551372208 | -7608
551372297 | 2008-04-12 00:00:00 | -100 | 0 |  |  |  | 551372224 | -100
551372429 | 2008-04-12 00:00:00 | -100 | 0 |  |  |  | 551372260 | -100
551372448 | 2008-04-12 00:00:00 | -100 | 0 |  |  |  | 551372277 | -100
551414929 | 2008-04-04 00:00:00 | -17198 | 0 |  |  |  | 551372295 | -100
APU000039 | 2007-12-02 00:00:00 | -58241 | 0 |  |  |  | 551372297 | -100
D10097040 | 2003-01-08 00:00:00 | -100 | 0 |  |  |  | 551372429 | -100
D10442532 | 2008-04-11 00:00:00 | -22627 | 0 |  |  |  | 551372448 | -100
D10559482 | 30-11-2009 | -386493 | 1 | -970145 |  |  | 551414929 | -17198
D10559482 |  | -583652 | 0 |  |  |  | APU000039 | -58241
 |  |  |  |  |  |  | D10097040 | -100
 |  |  |  |  |  |  | D10369761 | -410016
 |  |  |  |  |  |  | D10442532 | -22627
 |  |  |  |  |  |  | D10559482 | -970145
 |  |  |  |  |  |  | Grand Total | -4399088.1
Spreadsheet: chris_dorland__1638__11-01 1600
Sheet: MAIN

MAIN
 |  | Fuel | [NAME] | Full | Current Output | Change | Current Output | Change | Current Output | Change | Current Output | Change
OPERATOR | PLANT | Type | Heat Rate | Capacity | @ 0630 |  | @ 0900 |  | @ 1200 |  | @1600
ILLC | [NAME] (IL) | Coal | 9817 | 1892.05 | 1605 |  | 1570 |  | 1655 |  | 1610
AEE | Coffeen | Coal | 9875 | 1005.46 | 1070 |  | 630 |  | 715 |  | 1005
EEI | [NAME] | Coal | 10344 | 1100 | 935 |  | 1010 |  | 1025 |  | 1035
AEE | Labadie | Coal | 10298 | 2389.5 | 780 |  | 1215 |  | 1255 |  | 1255
AEE | Rush Island | Coal | 10192 | 1242 | 1120 |  | 1242 |  | 1215 |  | 1242
ALIANT | Columbia (WI) - WPL | Coal | 10257 | 1070 | 1055 |  | 1070 |  | 1070 |  | 1070
AEE | Newton | Coal | 9474 | 1234.8 | 530 |  | 535 |  | 750 |  | 1000
Dominion Resources | Kincaid | Coal | 10449 | 1319 | 540 |  | 530 |  | 505 |  | 475
UCM | Powerton | Coal | 10665 | 1785.6 | 1270 |  | 1405 |  | 1390 |  | 1420
WIEC | Oak Creek South | Coal | 8898 | 1216 | 1015 |  | 1216 |  | 1216 |  | 1216
WIEC | Pleasant Prairie | Coal | 10806 | 1235 | 945 |  | 1300 |  | 1235 |  | 1235
Spreadsheet: 32719d1228902087-counting-text-from-a-list-only-once-land_use
Sheet: Pivot Table

 | Sample Point | (All)
 | Sum of Area
 | Land Use | Organic Suites | O Cost | Inorganic Suites | I Cost | Total
 | Arable | O1, O2, O3, O4, O5, O6, O8 | 395 | I1, I2 | 39.6 | 0.07788661475610349
 | Forestry/Woodland | O1, O6 | 125 | I1, I2 | 39.6 | 0.06746365875529806
 | Managed Grassland | O1, O3, O6 | 165 | I1, I2 | 39.6 | 0.7773848837704305
 | Null | Null | 0 | 0 | 0 | 0.0002410016136945246
 | Semi-natural Vegetation | O1, O4 | 80 | I1, I2 | 39.6 | 0.008411835355005077
 | Urban | O1, O2, O3, O4 ,O5, O6, O7 | 360 | I1, I2 | 39.6 | 0.068348560243796
 | Water | O1, O2, [NAME], O4, O6 | 315 | I1, I2 | 39.6 | 0.0002634455056722432
 | Grand Total |  |  |  |  | 1
 |  |  |  |  | Organic | 420
 |  |  |  |  | Inorganic | 39.59999999999999
 | Bottles Required |  |  |  | Total Cost | 459.6
Spreadsheet: 718099d1612981374-inserting-additional-criteria-to-an-if-statement-worktimecalcefupdated
Sheet: Sheet2 (2)

STRT | END | WRK | RT | ST | OT |  | Overall Day
 |  |  |  |  |  |  | Report | 05:36:00
 |  |  |  |  |  |  | Start Shift
 |  |  |  |  |  |  | End Shift | 11:57:00
 |  |  |  |  |  |  | 1st Half Pay
 |  |  |  |  |  |  |  | Break
 |  |  |  |  |  |  | Report | 12:20:00
 |  |  |  |  |  |  | Start Shift
 |  |  |  |  |  |  | 11th Hour
 |  |  |  |  |  |  | End Shift | 16:01:00
 |  |  |  |  |  |  | Straight Time |  |  |  | 8
 |  |  |  |  |  |  | Overtime |  |  |  | 2.5
Spreadsheet: e3c69d71-b5fb-4479-9bbf-8396f60b8250
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 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: Monthly Retail Trade and Food Services
 |  | 44X72: Retail Trade and Food Services: U.S. Total
 |  | Seasonally Adjusted Sales - Monthly [Millions of Dollars]
 |  | Period: 1992 to 2012
 |  | Data Extracted on: July 26, 2014 (3:30 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1992 | 164083 | 164260 | 163747 | 164759 | 165617 | 166098 | 167305 | 167797 | 169407 | 170681 | 171025 | 172995
1993 | 175078 | 173770 | 172328 | 176766 | 178445 | 178201 | 180759 | 180692 | 181800 | 182910 | 184746 | 186339
1994 | 185128 | 188077 | 191588 | 191632 | 190940 | 193196 | 193763 | 196157 | 197754 | 199579 | 199723 | 200670
1995 | 201583 | 198383 | 200230 | 201048 | 202993 | 205507 | 204959 | 206529 | 206978 | 206157 | 208661 | 210434
1996 | 208731 | 212011 | 213855 | 214644 | 216304 | 216059 | 216374 | 216355 | 219240 | 221039 | 220989 | 221898
1997 | 223524 | 225409 | 226136 | 224588 | 222906 | 226048 | 228738 | 229317 | 230284 | 229822 | 230486 | 231197
1998 | 231605 | 231664 | 233043 | 235976 | 237055 | 238958 | 237423 | 236412 | 238542 | 242531 | 244307 | 246577
1999 | 246891 | 249510 | 250657 | 252418 | 254738 | 255472 | 257441 | 260253 | 261352 | 261825 | 264883 | 269876
2000 | 268091 | 272026 | 275214 | 270998 | 271418 | 273440 | 272638 | 272954 | 277523 | 276973 | 275928 | 275727
2001 | 278911 | 278799 | 276473 | 280798 | 281546 | 280393 | 279522 | 281423 | 276095 | 294613 | 286960 | 283704
2002 | 283583 | 285061 | 284257 | 288827 | 284987 | 287401 | 290427 | 292593 | 288428 | 289646 | 291475 | 293812
2003 | 295302 | 291188 | 296352 | 295656 | 296411 | 299679 | 302821 | 307768 | 305947 | 304857 | 308587 | 307384
2004 | 309266 | 311444 | 316972 | 313569 | 319002 | 315017 | 318587 | 318997 | 324668 | 326726 | 327892 | 331902
2005 | 329799 | 332804 | 332419 | 337992 | 334757 | 342841 | 347368 | 342818 | 343419 | 344697 | 347504 | 347730
2006 | 357814 | 354495 | 356172 | 358092 | 356240 | 357580 | 360175 | 360651 | 358891 | 358802 | 359543 | 365061
2007 | 363393 | 364185 | 367745 | 366067 | 371023 | 368650 | 370161 | 371253 | 374596 | 375105 | 378172 | 375731
2008 | 375736 | 372211 | 372677 | 374766 | 376189 | 377677 | 375974 | 373866 | 367045 | 353910 | 341433 | 332902
2009 | 337819 | 336960 | 331405 | 332395 | 336089 | 340420 | 341937 | 348823 | 340103 | 342865 | 346477 | 347748
2010 | 348415 | 348453 | 356026 | 358169 | 356189 | 355760 | 356308 | 358749 | 361516 | 366675 | 368877 | 371303
2011 | 374280 | 377071 | 380543 | 382397 | 382666 | 385357 | 386295 | 386329 | 389662 | 394047 | 394965 | 393874
2012 | 397866 | 402736 | 404246 | 402931 | 402726 | 398777 | 401097 | 406141 | 410686 | 410386 | 412170 | 413585
Spreadsheet: 51932116-45da-457b-a0e9-3ab98e5e534e
Sheet: SERBIA 3 years

 | Project Title: | [NAME] | New Coalitions for Biodiversity - Developing public-private partnerships within protected areas in five countries of the South East Europe - Budget
 | Project Activities: | SERBIA
 |  | YEAR 1 - 2011 |  |  | YEAR 2 -2012 |  |  | YEAR 3 2013 |  |  |  | TOTAL  3 YEARS
 | Category | Donor | WWF MEDPO | Total | Donor | WWF MEDPO | Total | Donor | WWF MEDPO | Total |  | Donor | WWF MEDPO | Total
1 | Project Staff
1.1 | BP development international support team: Expert 1: 30 month. ([NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  | Back to MATRA proposal
1.3 | Ministry focal point (NPCs+Serbian focal point) |  |  |  | 2000
1.5 | PA staff cost (€ 2000 x YEAR)
 | Total 1
2 | Studies, publications and workshops
2.1 | Twelve Market Studies (2x PA x 1000) |  |  |  |  |  |  |  |  |  |  |  |  |  | Need more assumptions for estimation
2.2 | BP development workshops (1 WS x Y x PA) |  |  |  |  |  |  |  |  |  |  |  |  |  | check with old MATRA proposal
2.4 | Printing of six business plans
2.5 | Public launches/visibility events to highlight public-private partnership achievements (2,7) € 4000 x country |  |  |  | 4000
 | Total 2
3 | Travel
3.1 | Travel PPP Lead
3.1 | Travel BP consultant (international)
3.2 | Travel Regional Project leader (3Xcountry)
3.2 | Travel BP development lead  local
 | Total 3
4 | Local Office Running Costs
 | Total 4
5 | Management Fees -8,5%
 | Total
 |  | Donor | WWF MedPO | Total
 | Year 1
 | Year 2
 | Year 3
 | Total 3 years
 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  | 0
 | Total Direct Cost for MedPO ORC and Admin
Spreadsheet: 70303d1271095133-can-you-use-and-statements-with-vlookup-sample
Sheet: Unbilled

Verify | RPM | Designator | Ship To Name | State | Order # | Product | Part Number
 | PM Name |  | City |  | 5749690 | Product Name | P25NNC043
 | PM Name |  | City |  | 5749690 | Product Name 2 | P25NNC009
 | PM Name |  | City |  | 5754274 | Product Name | P25NNC043
 | PM Name |  | City |  | 5780437 | Product Name | P25NNC066
Spreadsheet: 825021d1681047925-formula-that-can-return-one-or-more-locations-based-on-the-order-quantity-book2
Sheet: Sheet1 (2)

Stock Inventory |  |  |  |  |  | Order
Item Code | Location | Description | Qty | UOM |  | No | Item Number | Carton Quantity | Loose Quantity | UOM | Location 1 | Location 2 | Location 3 | L1 | L2 | L3
11157503 | [NAME] | MM OVAL #1 | 12 | ST
11157503 | [NAME] | MM OVAL #1 | 3 | ST |  | 1 | 11157503 | 13 |  | ST
11161451 | [NAME] | MM OVAL #2 | 9 | CT |  | 2 | 11161451 |  | 11 | CT
11161451 | [NAME] | MM OVAL #2 | 1 | CT |  | 3
11161451 | [NAME] | MM OVAL #2 | 12 | CT |  | 4
 |  |  |  |  |  | Need to create a formula that can list down one or more locations based on the quantity ordered.
Spreadsheet: 837734d1690382351-insert-text-in-same-cell-when-color-of-the-cell-goes-to-change-insert-text-in-same-cell-when-cell-color-change
Sheet: Sheet1

SAMPLE DATA
NAME OF THE STUDENT | MARKS
JON | 2
ABRAHIM | 51
MIKE | 60
PONTING | 15
CYNDRELLA | 35
[NAME] | 65
JOE | 70
DEAR SIR
The B coloumn containt the Marks of the studend I done the conditional formating that if marks between 51 to 100 than cell color have been Green and if Marks between 2 to 50 it should have been Red
But I want to also put Text "PASS" in the same cell as if the Cell colour goes to [NAME] AND "FAIL" when the cell colour goes to Red.
Spreadsheet: 28015d1221794265-complex-scheduling-and-pre-filling-out-a-different-form-schedule
Sheet: Timesheet

 |  | restaurant |  | Front Of House Sign In/Out
 |  |  |  | Monday, September 29
 |  | Today's Events: |  | Staff Meeting @ Noon
 |  | L U N C H |  | Start |  | Break |  | Finish |  | Total |  | Wage |  | Initials
 |  | Cash
 |  | Servers
 |  | Bartenders
 |  | Hosts
 |  | Leaders
 |  | Total Lunch Labour:
 |  | D I N N E R |  | Start |  | Break |  | Finish |  | Total |  | Wage |  | Initials
 |  | Servers
 |  | Bartenders
 |  | Hosts
 |  | Leaders
 |  | Total Dinner Labour:
Spreadsheet: 061cfa56-e308-4e45-a491-28e648d0d015
Sheet: Sheet1

Table S1.  Sequences of the primers used for PCR experiments | Unnamed: 1 | Unnamed: 2
5' RACE
 | Name | Sequence(5'-3')*
 | RAgo2Outer | CCACAGGCCGAGGTTGGACTGTCAAGCCG
 | RAgo2Inner | GTCTCTGAAATGTCATATTCAGACG
Clone to pcDNA-FLAG
 | Name | Sequence(5'-3')*
 | FAgo1F | [NAME]
 | FAgo1R | ATAGTTTAGCGGCCGCCTGCAAAATACATTACTCTTAATGTTTCAGGATG
 | FAgo2F | CGGGGTACCGAACCATGTCTCAGAGAGGTTTCTACGTTCC
 | FAgo2R | ATAGTTTAGCGGCCGCCCAGATAAAACATCCCATCGACCTGCG
 | FAgo3F | CGGGGTACCGAACCATGGAGGACGGGAGCTCGAAT
 | FAgo3R | ATAGTTTAGCGGCCGCCCAAGAAAAACATCCCATCAG
qRT-PCR
 | Name | Sequence(5'-3')*
 | QAgo1F | AAACACCGGGCTCTTCTTATGG
 | QAgo1R | [NAME]
 | QAgo2F | AAGACCGCCAACAATTCATCGA
 | QAgo2R | CGAGTATGCATCGGTTTGTTCA
 | QAgo3F | ACCACTACCACCATCCCAAGAA
 | QAgo3R | GTGAAATTGGCAGTGTCGATGA
Spreadsheet: 195820d1353673997-subtracting-one-date-for-another-using-countif-criteria-firstlast
Sheet: Sheet1

[NAME] | Programme Title | Production No | Episode Title |  |  |  | Episode Title | difference
2012-11-10 00:00:00 |  | 1/3856/4586#001 | EPISODE 7997 | Duplicate # 1 | EPISODE 7997 first |  | EPISODE 7997 | 9
2012-11-19 00:00:00 |  | 1/3856/4586#001 | EPISODE 7997 | Duplicate # 2 | EPISODE 7997 last |  | EPISODE 7998 | 7
2012-11-12 00:00:00 |  | 1/2516/8346#001 | EPISODE 7998 | Duplicate # 1 | EPISODE 7998 first |  | EPISODE 7999 | 1
2012-11-19 00:00:00 |  | 1/2516/8346#001 | EPISODE 7998 | Duplicate # 2 | EPISODE 7998 last |  | EPISODE 8000 | 1
2012-11-19 00:00:00 |  | 1/3482/6428#001 | EPISODE 7999 | Duplicate # 1 | EPISODE 7999 first |  | EPISODE 8001 | 5
2012-11-19 00:00:00 |  | 1/3482/6428#001 | EPISODE 7999 | Duplicate # 2 |  |  | EPISODE 8002 | 4
2012-11-20 00:00:00 |  | 1/3482/6428#001 | EPISODE 7999 | Duplicate # 3 |  |  | EPISODE 8003 | 4
2012-11-20 00:00:00 |  | 1/3482/6428#001 | EPISODE 7999 | Duplicate # 4 | EPISODE 7999 last
2012-11-19 00:00:00 |  | 1/8845/4285#001 | EPISODE 8000 | Duplicate # 1 | EPISODE 8000 first
2012-11-20 00:00:00 |  | 1/8845/4285#001 | EPISODE 8000 | Duplicate # 2
2012-11-20 00:00:00 |  | 1/8845/4285#001 | EPISODE 8000 | Duplicate # 3 | EPISODE 8000 last
2012-11-21 00:00:00 |  | 1/6490/6258#001 | EPISODE 8001 | Duplicate # 1 | EPISODE 8001 first
2012-11-22 00:00:00 |  | 1/6490/6258#001 | EPISODE 8001 | Duplicate # 2
2012-11-22 00:00:00 |  | 1/6490/6258#001 | EPISODE 8001 | Duplicate # 3
2012-11-26 00:00:00 |  | 1/6490/6258#001 | EPISODE 8001 | Duplicate # 4 | EPISODE 8001 last
2012-11-23 00:00:00 |  | 1/1385/4118#001 | EPISODE 8002 | Duplicate # 1 | EPISODE 8002 first
2012-11-26 00:00:00 |  | 1/1385/4118#001 | EPISODE 8002 | Duplicate # 2
2012-11-26 00:00:00 |  | 1/1385/4118#001 | EPISODE 8002 | Duplicate # 3
2012-11-27 00:00:00 |  | 1/1385/4118#001 | EPISODE 8002 | Duplicate # 4 | EPISODE 8002 last
2012-11-23 00:00:00 |  | 1/5148/4512#001 | EPISODE 8003 | Duplicate # 1 | EPISODE 8003 first
2012-11-26 00:00:00 |  | 1/5148/4512#001 | EPISODE 8003 | Duplicate # 2
2012-11-26 00:00:00 |  | 1/5148/4512#001 | EPISODE 8003 | Duplicate # 3
2012-11-27 00:00:00 |  | 1/5148/4512#001 | EPISODE 8003 | Duplicate # 4 | EPISODE 8003 last
Spreadsheet: 755240d1636730567-transpose-horizontal-to-vertical-ef1556_transpose_variable_records
Sheet: Sheet1

Names | Area 1 | Area 2 | Area 3 | Area 4 | Area 5 | Area 6 | Area 7 |  |  | 0 |  | Names | Area
Adis | 1 | 2 | 3
Joé | 10 | 11 | 12 | 13 | 14 | 15 | 16
[NAME] | 20 | 21 | 22 | 23
[NAME] | 30 | 31 | 32 | 33 | 34 | 35
[NAME] | 40 | 41 | 42 | 43 | 44
Grégory | 50 | 51
Henri | 60 | 61 | 62 | 63 | 64 | 65
[NAME] | 70
Fabio | 80 | 81 | 82 | 83 | 84 | 85 | 86
Spreadsheet: 140084d1328620603-removing-a-linked-cell-tlc-client-progress
Sheet: Home

Course | Client | Client | Course | Initial Contact | Details on database | Evaluation coordinated | Eval. report to teacher | Eval. report received | Needs analysis | Follow up contact | Course plan created | Course plan translated | ER/CP/T's & C's sent | T's & C's accepted | Teacher allocated | Teacher avail. Updated | Course start confirmed | Lessons added to DB | Details sent to JF | Added to end of month | Profile/login sent | 1st class follow up
 | B1 | B3 |  | B9 | B10 | B11 | B15 | B16 | B17 | B18 | B22 | B23 | B24 | B25 | B26 | B27 | B28 | B29 | B30 | B31 | B32 | B33
Sofía Ernst | Felipe Ernst
Spreadsheet: 06393de7-d7fa-4d0a-bc6e-108a414e0cb9
Sheet: Sheet1

Whitman College Time Reporting Form-Salaried | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24
Name (Last, First, M.I.) |  |  |  |  |  |  |  | ID # |  |  |  |  | Position Title
Employing Department |  |  |  |  |  |  |  |  |  |  |  |  | Account Number
Month/Year |  |  |  |  |  |  |  |  |  |  |  |  | Account Name
This form should be used by all non-exempt salaried staff.  Employees must account for all scheduled hours.  Please mark weekends (X) and holidays (H).
Report hours in minimum increments of 1/4 hour. This form is due in Human Resources on the fifth working day following the end of the month. Salaried
employees who work for another department at an hourly rate should complete a separate time reporting form for each department.
 |  |  |  |  |  |  | Use these dates only if failed to report previously | CURRENT MONTH
HOURS REPORTED | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
Regular
Overtime
[NAME]
Vacation
Holiday
Other**
LOA***
 |  | CURRENT MONTH |  |  |  |  |  |  |  |  |  |  |  | TOTAL HOURS * | 0
HOURS REPORTED | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | paid | unpaid |  |  | COMMENTS
Regular |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Overtime |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Vacation |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Holiday |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Other** |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
LOA*** |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
CERTIFIED AS ACCURATE |  |  |  |  |  |  |  |  |  |  | VERIFIED AS ACCURATE
Employees Signature |  |  |  |  |  | Date |  |  |  |  | [NAME]'s Signature |  |  |  |  |  |  |  |  |  | Date
*Report in 1/4 hour increments
**Include Jury Duty (J) and [NAME] (BL), and code accordingly.  [NAME] to staff handbook for leave information.
***LOA = Leave of Absence/Approved-Nonpaid
Spreadsheet: 798178d1664353935-separate-text-of-8-elements-into-different-cells-sample-hd-3-
Sheet: Tabelle1

 |  | Sample of inputs:
 | 1 | 7228R Scheinwerf.kpl. re 1029 textA MIR 1 K4 30
 | 2 | 9472L Scheinwerf.kpl. [NAME] 3124 textB, textC HM 2 X4 20 |  |  |  |  | red elements: only elements that i really need
 | 3 | 2839L Scheinwerf.kpl. [NAME] 3015 textD M 1 T2 10
 |  | How i want them to be separated:
 | 1 |  | [NAME] | 1029 | textA | MIR | 1 | K4 | 30
 | 2 |  | Scheinwerf.kpl.li | 3124 | textB,textC | HM | 2 | X4 | 20
 | 3 |  | Scheinwerf.kpl.li | 3015 | textD | M | 1 | T2 | 10
Spreadsheet: 0364c5a4-b621-4293-b991-bf91b28cff13
Sheet: Sheet1

Judgeship Number 6 (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 9/30/2014 12:50:34 PM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
County | [NAME] | TOTALS
[NAME] | 56811 | 56811
Steele | 848 | 848
Traill | 3411 | 3411
TOTAL | 61070 | 61070
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 745683d1630104916-filtered-lookup-with-multi-column-data-return-draftexcelforumhelpnewweeklyphecreadings-indexand-aggregate
Sheet: PivotTables_Irrigation

Zone | Well Upstairs |  |  | Zone | Well Upstairs
Row Labels | Average of pH |  |  | Row Labels | Average of EC
2021 | 7.734062499999999 |  |  | 2021 | 0.2969062499999999
1 | 7.67 |  |  | 1 | 0.31
2 | 7.64 |  |  | 2 | 0.236
3 | 7.76 |  |  | 3 | 0.327
4 | 7.62 |  |  | 4 | 0.295
5 | 7.4 |  |  | 5 | 0.296
6 | 7.84 |  |  | 6 | 0.323
7 | 7.66 |  |  | 7 | 0.299
9 | 7.92 |  |  | 9 | 0.322
10 | 7.75 |  |  | 10 | 0.297
11 | 7.96 |  |  | 11 | 0.29
12 | 7.8 |  |  | 12 | 0.286
13 | 7.77 |  |  | 13 | 0.289
14 | 7.82 |  |  | 14 | 0.285
15 | 7.71 |  |  | 15 | 0.303
16 | 7.78 |  |  | 16 | 0.282
17 | 8.02 |  |  | 17 | 0.285
18 | 7.74 |  |  | 18 | 0.313
19 | 7.94 |  |  | 19 | 0.294
20 | 7.95 |  |  | 20 | 0.31
21 | 7.62 |  |  | 21 | 0.29
22 | 7.82 |  |  | 22 | 0.293
23 | 7.51 |  |  | 23 | 0.298
24 | 7.59 |  |  | 24 | 0.303
26 | 7.49 |  |  | 26 | 0.297
27 | 7.5 |  |  | 27 | 0.302
28 | 7.54 |  |  | 28 | 0.302
29 | 7.84 |  |  | 29 | 0.29
30 | 7.72 |  |  | 30 | 0.3
31 | 7.92 |  |  | 31 | 0.29
32 | 7.68 |  |  | 32 | 0.29
33 | 7.93 |  |  | 33 | 0.285
34 | 7.58 |  |  | 34 | 0.319
Spreadsheet: 682530d1592186680-average-without-calculating-blank-cells-ave_withoutnull
Sheet: Jun

Date | Time % | Wait % | Down | [NAME].
2020-06-01 00:00:00 | 32 | 44 | 44.55 | 1.55917828872974 |  | Average By Day
2020-06-02 00:00:00 | 37 | 44 | 35.22 | 1.641505864547862 |  |  | Mon. | Tue. | Wed. | Thu. | Fri. | Average
2020-06-03 00:00:00 | 30 | 42 | 42.26 | 1.647302904564315 |  | Time %
2020-06-04 00:00:00 | 41 | 47 | 41.65 | 1.67 |  | Wait%
2020-06-05 00:00:00 | 35 | 46 | 44.71 | 1.71 |  | Down |  |  |  |  |  | 0
2020-06-08 00:00:00 | 35 | 44 | 38.49 | 1.52 |  | [NAME].
2020-06-09 00:00:00 | 37 | 46 | 36.78 | 1.6
2020-06-10 00:00:00 | 35 | 50 | 43.33 | 1.76
2020-06-11 00:00:00 | 36 | 47 | 44.66 | 1.72
2020-06-12 00:00:00 | 35 | 47 | 42.11 | 1.66
2020-06-15 00:00:00
2020-06-16 00:00:00
2020-06-17 00:00:00
2020-06-18 00:00:00
2020-06-19 00:00:00
2020-06-22 00:00:00
2020-06-23 00:00:00
2020-06-24 00:00:00
2020-06-25 00:00:00
2020-06-26 00:00:00
2020-06-29 00:00:00
2020-06-30 00:00:00
Spreadsheet: 714181d1611132607-how-to-only-count-rows-that-are-current-fulfil-a-criteria-question-waiting-list
Sheet: Waiting List

WAITING LIST
Priority | Date received | Waiting time (days) | Initial appt made | Referral completed
1 | 2020-12-16 00:00:00 |  | 2021-01-20 00:00:00 | Yes
2 | 2020-12-17 00:00:00
1 | 2020-12-18 00:00:00
1 | 2020-12-19 00:00:00
2 | 2020-12-20 00:00:00
 |  |  |  |  |  | Issue: | The "Waiting time (days)" shows 44216 if there is a row with no data. Is there a way to make it who a blank if the row has no data in it and to calculate the correct number of days when "Date received" has a date in it?
Number of clients waiting
Priority Rating | Number | Notes - correct answer |  | Issue: | I only want to count client who are on the waiting list. If the referral is complete I do not want to count these in the "Number of clients waiting" table. What is the formula for this?
Priority 1 |  | 2
Priority 2 |  | 2
Priority 3 |  | 0
Total |  | 4
Spreadsheet: 887819d1738157150-ranking-the-best-deal-for-the-money-book1
Sheet: Sheet1

Model | Macs | Memory | Score |  | Car | [NAME] | Year | Price
Model 1 | 500 | 4300 |  |  | 1 | 73055 | 2013 | 14900
Model 2 | 7 | 800 |  |  | 2 | 34000 | 2013 | 17900
Model 3 | 8 | 801 |  |  | 3 | 92000 | 2014 | 15000
Model 4 | 120 | 1000 |  |  | 4 | 50000 | 2014 | 16000
Model 5 | 64 | 930 |  |  | 5 | 40000 | 2013 | 13000
Model 6 | 30 | 900
Model 7 | 34 | 895 |  |  | ** how would you find the car that has the lowest miles and lowest price for th highest year
Model 8 | 370 | 3700
Model 9 | 215 | 2800
Model 10 | 200 | 4200
Model 11 | 100 | 2800
** The goal is highest Macs score for lowest Memory score
Spreadsheet: 864721d1711822112-sum-count-and-average-is-not-working-average-total
Sheet: MARCH

 | SESSIONS | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | TOTAL | DAILY AVG. | AVG WIN
 | [NAME]
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7 | 17 | 30
 | 8 | 53 | 27 | 29
 | 9 | 37 | 10 | 39 | 29 | 30
 | 10 | 28 | -131 | 143 | 14
 | 11 | 44 | 21 | 22 | 5 | 26
 | 12 | 22 | -211
 | 13
 | 14 | 15 | 10
 | 15 | 16 | -96 | 101
 | 16 | 24 | 37 | 80 | 93 | 48
 | 17 | 53
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31