tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 41374d1239829248-conditional-formula-sample
Sheet: Combo

L Name | Wage Base | Percent | Tier | W/ [NAME] |  |  | 2500 | 0.4370629370629371
Doe | 200 | 87.41258741258741 | 1 | 87.41258741258741 |  | Tier 1 Max | 150
Doe | 250 | 109.2657342657343 | 1 | 109.2657342657343 |  | [NAME] | 250
Doe | 225 | 98.33916083916084 | 1 | 98.33916083916084 |  | [NAME] | 350
Doe | 20 | 8.741258741258742 | 1 | 8.741258741258742
Doe | 100 | 43.70629370629371 | 1 | 43.70629370629371
Doe | 225 | 98.33916083916084 | 1 | 98.33916083916084
Doe | 250 | 109.2657342657343 | 1 | 109.2657342657343
Doe | 350 | 152.972027972028 | 2 | 152.972027972028
Doe | 500 | 218.5314685314685 | 2 | 218.5314685314685
Doe | 400 | 174.8251748251748 | 2 | 174.8251748251748
Doe | 1000 | 437.0629370629371 | 3 | 350
Doe | 1500 | 655.5944055944057 | 3 | 350
Doe | 700 | 305.9440559440559 | 3 | 305.9440559440559
TOTAL | 5720 | 2500 |  | 2107.342657342657
Spreadsheet: 484403d1476263955-fill-the-form-in-sheet3-using-data-from-sheet1-school-reports
Sheet: AlJood

 | Monthly Report for The Buses In the Schools |  |  |  |  |  |  | Month:
 |  | School Name: | AlJood
 |  | School Type: | Boys
 | Serial No | Bus Number | Bus Type | Trip Type |  |  |  | Shared School Name |  | Driver Name
 |  |  |  | Large Bus |  | Small Bus
 |  |  |  | Double | Single | Double | Single
 | Total
Spreadsheet: 837349d1690082760-creating-a-dropdown-list-that-pulls-from-multiple-sheets-test
Sheet: Omega

Site | Omega
Location
Address | 465 Real Ave Calgary AB, T2T 2T2
GPS | 52.1111, -113.1111
Account No | Company ID
K21-5555 | 2023
Keyholder Contact
 | Name | Phone | [NAME]
1 | Juan | 111-2222 | [EMAIL]
2 | Philipe | 111-2223 | [EMAIL]
3 | [NAME] | 111-2224 | [EMAIL]
4
Security Service
Monitoring Station: | For Sure Security | [PHONE]
Notes
[NAME] to stop feeding the geese, they won't let us leave through the main door.
Spreadsheet: 870876d1717342751-trying-to-populate-a-cell-with-value-from-a-range-based-on-criteria-in-another-range-lotto-bingo2
Sheet: Printout

 |  | LOTTO BINGO
 |  |  |  |  |  |  |  |  |  |  |  | 49
 |  | Numbers Drawn
 |  | 1 | 2 | 3 | 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
 |  | 31 | 32 | 33 | 34 | 35 |  | 36 | 37 | 38 | 39 | 40
 |  | 41 | 42 | 43 | 44 | 45 |  | 46 | 47 | 48 | 49 | 50
 |  | 51 | 51 | 53 | 54 | 55 |  | 56 | 57 | 58 | 59
Spreadsheet: 852592d1702572846-how-to-sumif-with-dynamic-variable-number-of-criteria-ranges-excel-example-1-
Sheet: FollowUp

 |  |  |  |  |  | Master [NAME] |  |  | Value Array |  |  | Unique Master Array |  |  | [NAME] |  |  |  | Desired Outcome
 |  |  |  |  |  |  | Red | True |  | 25 |  |  | Red | True |  |  | 250
 |  |  |  |  |  | A | Blue | True | 40 | 10 |  | A | Blue | True |  | 740 | 560
 |  |  |  |  |  | B | Blue | False | 450 | 100 |  | B | Blue | False |  | 450 | 100
 |  |  |  |  |  | A | Blue | True | 100 | 250 |  | C | Blue | False |  | 25 | 0
 |  |  |  |  |  | A | Blue | True | 600 | 300 |  | A | Yellow | True |  | 400 | 50
 |  |  |  |  |  | C | Blue | False | 25 | 0
 |  |  |  |  |  | A | Red | True | 400 | 150
 |  |  |  |  |  | A | Red | True | 150 | 75
 |  |  |  |  |  | A | Yellow | True | 400 | 50
 |  |  |  |  |  | [NAME] | Working, but as the size of array is dynamic the number of criteria ranges and criteria will change.
 |  |  |  |  |  | Sometimes the data will be like this |  |  |  |  | Or like this etc.
 |  |  |  |  |  | Master [NAME] |  | Value Array |  |  | Master [NAME] |  |  |  | Value Array
 |  |  |  |  |  |  | Red |  |  |  |  | Red | True | Int
 |  |  |  |  |  | A | Blue | 40 |  |  | A | Blue | True | Int | 40
 |  |  |  |  |  | B | Blue | 450 |  |  | B | Blue | False | Int | 450
 |  |  |  |  |  | A | Blue | 100 |  |  | A | Blue | True | Ext | 100
 |  |  |  |  |  | A | Blue | 600 |  |  | A | Blue | True | Ext | 600
 |  |  |  |  |  | C | Blue | 25 |  |  | C | Blue | False | Ext | 25
 |  |  |  |  |  | A | Red | 400 |  |  | A | Red | True | Ext | 400
 |  |  |  |  |  | A | Red | 150 |  |  | A | Red | True | Int | 150
 |  |  |  |  |  | A | Yellow | 400 |  |  | A | Yellow | True | Ext | 400
Spreadsheet: 176056d1345720533-how-to-drag-some-data-in-excel-cloumn-cells-chal
Sheet: Sheet1

Contig ID | Sequence 1 | Sequence 2
Contig1 | AgTCCTAAAGCtt | AgTCCTAAAGCtt
Contig1 |  | AgTCCTAAAGCtt
Contig1 |  | AgTCCTAAAGCtt
Contig1 |  | AgTCCTAAAGCtt
Contig1 |  | AgTCCTAAAGCtt
Contig2 | AGCTTTAgc | AGCTTTAgc
Contig2 |  | AGCTTTAgc
Contig2 |  | AGCTTTAgc
Contig2 |  | AGCTTTAgc
Contig 5 | AGCTCGT | AGCTCGT
Contig 5 |  | AGCTCGT
Contig 5 |  | AGCTCGT
Contig 5 |  | AGCTCGT
Contig 5 |  | AGCTCGT
Contig 5 |  | AGCTCGT
Contig 9 | acgatattacgAGGA | acgatattacgAGGA
Contig 9 |  | acgatattacgAGGA
Contig 9 |  | acgatattacgAGGA
Spreadsheet: 44192d1242833194-latitude-longitude-porblem-sample-data
Sheet: Sheet1

1st DB Lattitude | 1st DB Longitude | Column 3 |  | 2nd DB Lattitude | 2ndDB Longitude | Column 3
57.6 | -5.98 | 30 |  | 57.63 | -5.94 | 30
57.63 | -5.94 | 30 |  | 54.21 | -5.34 | 30
57.55 | -5.91 | 40 |  | 57.55 | -5.91 | 40
54.16 | -5.16 | 30 |  | 57.6 | -5.87 | 30
57.21 | -5.35 | 60 |  | 57.13 | -5.23 | 60
57.21 | -5.34 | 60 |  | 57.21 | -5.34 | 60
57.23 | -5.29 | 50 |  | 57.23 | -5.26 | 30
57.23 | -5.27 | 50 |  | 57.21 | -5.35 | 60
57.23 | -5.26 | 30 |  | 57.23 | -5.27 | 40
Spreadsheet: 293150d1390908979-hired-material-total-cost-up-to-date-based-on-returned-quantity-and-date-total-cost-of-hired-materials
Sheet: Sheet1

 |  |  |  |  |  |  |  | Delivery Date |  |  |  |  | Returned Date
 |  |  |  |  |  |  |  | 2013-07-02 00:00:00 | 2013-08-25 00:00:00 | 2013-08-21 00:00:00 | 2013-08-24 00:00:00 |  | 2013-10-12 00:00:00 | 2013-10-13 00:00:00 |  | 2013-10-26 00:00:00
No. | LPO ref | Items Hired | Unit | Qty. | Hired Rate (QR) | Discount |  | H | H | H | H | Total Delivered | R | R |  | R | Total Returned |  | Balance | Total Cost
1 | 4460 - 000250 | Scaffolding [NAME], [NAME]: 860mm,Zinc Plated | Nos | 800 | 0.068 | 0 |  | 400 |  | 400 |  |  |  | 300 |  | 100
10 | 4480-001029 | [NAME] 860mm | Nos | 1500 | 0.097 | 0.556
Spreadsheet: 857208d1706230414-forumula-to-populate-a-column-with-data-from-other-columns-populating-a-column-from-other-columns
Sheet: Sheet1

Dept | PO Dept | Invoice Dept | [NAME]
Hoggs |  | Hoggs | Hoggs
Soggs |  | Hoggs | Hoggs
Cloggs | Hoggs |  | Hoggs
Cloggs | Cloggs |  | Cloggs
Cloggs | Soggs |  | Soggs
Cloggs | Soggs |  | Soggs
Hoggs |  |  | Hoggs
Hoggs |  |  | Hoggs
Soggs |  |  | Soggs
Looking for a formua that says if there's a value in either column B or C, put it into column D.  And if there's no value in column B or C, put the value in column A into Column D instead
Spreadsheet: 46503d1245339773-linking-forumals-into-one-cell-copy-of-automated-reports-spreadsheet-1
Sheet: Sentences

 | Introductions
1 | is presently studying Graphics, previous to this he was working in Resistant Materials
2 | Within Graphics he is currently developing technical drawing skills allowing him to be creative when designing.
 | Strengths
3 | Pleasant personality
4 | Well-groomed
5 | tries hard
6 | has made some good progress within this lesson and is currently one sub-level away from
7 | He has produced some detailed work which shows confidence and detail.
 | Weaknesses
8 | Lazy
9 | Disrespectful
10 | However, he needs to ensure that he is on task all lesson as he can often be easily distracted and can sometimes lack motivation.
 | Future developments
11 | should consider the following for future development in this subject:
12 | he should listen to all instructions and concentrates in lessons.
13 | Make sure that he uses equipment accurately and safely and that all work is completed to the highest standard.
Spreadsheet: 164920d1340960805-look-values-with-a-twist-look-up-query-v3
Sheet: Data

Helper | Account | Cost Center | Amount | Amount
1006109 | 1006109 |  | 0 | 2461.62
1006109 | 1006109 |  | 0 | 262776.51
1006109 | 1006109 |  | 0 | 103308
2203015 | 2203015 |  | 0 | 648.38
2206001 | 2206001 |  | 0 | 35226.13
2206001SS | 2206001 | SS | 0 | 10179.58
50000011405801100 | 5000001 | 1405801100 | 8861.25 | 0
50000011505800650 | 5000001 | 1505800650 | 37980.95 | 0
50000011705800001 | 5000001 | 1705800001 | 58436.78 | 0
50000011705800002 | 5000001 | 1705800002 | 130282.09 | 0
50000011705800012 | 5000001 | 1705800012 | 10081.42 | 0
50000011705800022 | 5000001 | 1705800022 | 26357 | 0
50000011805800005 | 5000001 | 1805800005 | 6988.5 | 0
50000011805800018 | 5000001 | 1805800018 | 23385.01 | 0
50000011805800035 | 5000001 | 1805800035 | 6524.8 | 0
50000011805807100 | 5000001 | 1805807100 | 11818.58 | 0
50000011905800002 | 5000001 | 1905800002 | 17259.92 | 0
50000012305800001 | 5000001 | 2305800001 | 19736.79 | 0
50100151405801100 | 5010015 | 1405801100 | 3545 | 0
50100151505800650 | 5010015 | 1505800650 | 6779 | 0
50100151805800018 | 5010015 | 1805800018 | 3803 | 0
50100151805807100 | 5010015 | 1805807100 | 5352 | 0
50100152305800001 | 5010015 | 2305800001 | 2182 | 0
50300081405801100 | 5030008 | 1405801100 | 1205.17 | 0
50300081505800650 | 5030008 | 1505800650 | 4017.03 | 0
50300081705800001 | 5030008 | 1705800001 | 5070.39 | 0
50300081705800002 | 5030008 | 1705800002 | 12388.41 | 0
50300081705800012 | 5030008 | 1705800012 | 839.74 | 0
50300081705800022 | 5030008 | 1705800022 | 2372.13 | 0
50300081805800005 | 5030008 | 1805800005 | 936.4 | 0
50300081805800018 | 5030008 | 1805800018 | 2697.59 | 0
50300081805800035 | 5030008 | 1805800035 | 628.43 | 0
50300081805807100 | 5030008 | 1805807100 | 1663.54 | 0
50300081905800002 | 5030008 | 1905800002 | 1482.26 | 0
50300082305800001 | 5030008 | 2305800001 | 1925.04 | 0
Spreadsheet: 6427f158-5c54-484f-9afe-3bd8e4dfe47f
Sheet: Pernyataan

 | SURAT PERNYATAAN
 | [NAME] bertanda tangan di bawah ini,
 |  | Nama | :
 |  | NIP | :
 |  | Instansi | :
 |  | [NAME] | :
 | Menyatakan bahwa saya sanggup [NAME] rangkaian kegiatan diklat online yang diselenggarakan oleh PPPPTK IPA, serta bersedia melaksanakan dan memenuhi seluruh penugasan selama pelaksanaan diklat online.
 |  | [NAME] | : |  |  | (ISI DENGAN KODE DIKLAT [NAME])
 | Demikian pernyataan ini saya buat dengan sesungguhnya.
 |  |  |  |  | Bandung,  April 2014
 |  |  |  |  | [NAME] menyatakan,
 |  |  |  |  | NIP.
Spreadsheet: 867190d1714055229-help-extracting-specific-text-from-inconsistent-text-strings-data-set-new-zandry10085-
Sheet: Sheet1

Invoice | Code Item or Activity Code | Description | QTY | Total |  | Invoice | Code Item | Description | [NAME] | [NAME] | Final
33593 | SI1 | KOE240000059 Activity 1 MRTU2090087.FCIU6090526.MRTU213834 Activity 2 : MRTU2126493.MRTU205845M Activity 3 : MRTU2126493.MRTU205845M MRTU213834 | 3 |  |  |  |  |  | MRTU2090087
33593 | LE1 | KOE240000059 Activity 1 MRTU2090087.FCIU6090526.MRTU213834 Activity 2 : MRTU2126493.MRTU205845M Activity 3 : MRTU2126493.MRTU205845M MRTU213834 | 2 |  |  |  |  |  | FCIU6090526
33593 | GE1 | KOE240000059 Activity 1 MRTU2090087.FCIU6090526.MRTU213834 Activity 2 : MRTU2126493.MRTU205845M Activity 3 : MRTU2126493.MRTU205845M MRTU213834 | 3 |  |  |  |  |  | MRTU213834
 |  |  |  |  |  |  |  |  | MRTU2126493
 |  |  |  |  |  |  |  |  | MRTU205845
 |  |  |  |  |  |  |  |  | MRTU2126493
 |  |  |  |  |  |  |  |  | MRTU205845
 |  |  |  |  |  |  |  |  | MRTU213834
 | Note : This are example of Activity Code and Activity Name (The list is more then this)
 | Activity Code | Activity Name
 | PR1 | Plugging reefer
 | SI1 | STUFFING IN
 | LE1 | LIFT ON EMPTY
 | RC1 | REPAIR CONTAINER
 | TI1 | TAMBAH ISI
 | AK1 | ALIH KAPAL
 | TRF1 | THC & RELOKASI FULL
 | MRTU
Spreadsheet: 713040d1610538152-nested-if-statements-using-index-and-match-cannot-get-them-to-sum-index-match-which-sums-also
Sheet: pin paid omd

 |  | ID |  |  |  | Cost
 |  | 362539838758509717 |  |  |  | 1063.68
 |  | 362539838758509717 |  |  |  | 1419.14
 |  | 362539838758509717 |  |  |  | 1257.58
 |  | 362539838758519690 |  |  |  | 923.71
 |  | 362539838758519690 |  |  |  | 422.55
 |  | 362539838758519690 |  |  |  | 526.97
 |  | 362539838758519699 |  |  |  | 925.91
 |  | 362539838758519699 |  |  |  | 855.91
 |  | 362539838758519699 |  |  |  | 715.48
 |  | 362539838758509717 |  |  |  | 4702.7
 |  | 362539838758519690 |  |  |  | 3840
 |  | 362539838758519699 |  |  |  | 3401.64
 |  | 362539838758268883 |  |  |  | 5030.69
 |  | 362539838758268896 |  |  |  | 4349.93
 |  | 362539838758268926 |  |  |  | 4749.39
 |  | 362539838756677214 |  |  |  | 773.6
 |  | 362539838756677214 |  |  |  | 1231.52
 |  | 362539838756677214 |  |  |  | 1686.14
 |  | 362539838756677214 |  |  |  | 321.16
 |  | 362539838756677266 |  |  |  | 81.48
 |  | 362539838756677266 |  |  |  | 106.25
 |  | 362539838756677266 |  |  |  | 149.87
 |  | 362539838756677266 |  |  |  | 60.08
 |  | 362539838756677294 |  |  |  | 2420.14
 |  | 362539838756677294 |  |  |  | 2008.47
 |  | 362539838756677294 |  |  |  | 1596.74
 |  | 362539838756677294 |  |  |  | 3153.31
 |  | 362539838756677334 |  |  |  | 58.27
 |  | 362539838756677334 |  |  |  | 55.88
 |  | 362539838756677334 |  |  |  | 64.71
 |  | 362539838756677334 |  |  |  | 98.75
 |  | 362539838756677388 |  |  |  | 700.15
 |  | 362539838756677388 |  |  |  | 696.07
 |  | 362539838756677388 |  |  |  | 559.56
 |  | 362539838756677388 |  |  |  | 519.02
 |  | 362539838756677407 |  |  |  | 121.87
 |  | 362539838756677407 |  |  |  | 65.5
 |  | 362539838756677407 |  |  |  | 154.98
 |  | 362539838756677407 |  |  |  | 102.29
 |  | 362539838756677486 |  |  |  | 181.39
 |  | 362539838756677486 |  |  |  | 228.17
 |  | 362539838756677486 |  |  |  | 156.13
 |  | 362539838756677486 |  |  |  | 201.12
 |  | 362539838756677491 |  |  |  | 162.87
 |  | 362539838756677491 |  |  |  | 107.76
 |  | 362539838756677491 |  |  |  | 131.88
 |  | 362539838756677491 |  |  |  | 42.29
Spreadsheet: 772421d1647265571-get-the-list-of-number-of-combinations-of-blocks-to-be-loaded-on-a-truck-book1
Sheet: Sheet1

Serial Number | Length | [NAME] | Height | Volume m³ | [NAME]
B5220001 | 2.45 | 0.85 | 1.5 | 3.124 | 8.81
B4220001 | 3.25 | 1.5 | 1.6 | 7.8 | 21.89
B3220001 | 1.8 | 0.9 | 1.3 | 2.106 | 5.97
B1220001 | 3 | 1.1 | 1.9 | 6.27 | 17.48
B5220002 | 2.05 | 1 | 1.1 | 2.255 | 6.36
B2220001 | 1.75 | 0.85 | 1.2 | 1.785 | 5.05
B1220002 | 2.95 | 1.55 | 1.8 | 8.23 | 23.21
B1220003 | 3.1 | 1.7 | 1.7 | 8.959 | 25.49
B1220004 | 3 | 1.3 | 1.8 | 7.02 | 19.81
B7220001 | 2.05 | 1.35 | 1.35 | 3.736 | 10.66
B4220002 | 2.8 | 1.35 | 1.8 | 6.804 | 19.48
B5220003 | 1.75 | 1.45 | 1.1 | 2.791 | 7.9
B2220002 | 2.1 | 1.25 | 1.7 | 4.462 | 12.8
B5220004 | 2.5 | 1.9 | 0.95 | 4.512 | 12.95
B5220005 | 2 | 1.9 | 1.3 | 4.94 | 13.93
B1220005 | 2.4 | 1.25 | 0.95 | 2.85 | 8.28
B1220006 | 2.2 | 1.3 | 1.15 | 3.289 | 9.35
B4220003 | 2.75 | 1.15 | 1.35 | 4.269 | 12.17
B7220002 | 2.5 | 1.1 | 1.8 | 4.95 | 14.25
B5220006 | 2.1 | 1.35 | 1.5 | 4.253 | 11.96
B1220007 | 3 | 1.1 | 1.7 | 5.61 | 16.23
B3220002 | 2.2 | 1.5 | 1.5 | 4.95 | 14.15
B4220004 | 1.7 | 1 | 1.3 | 2.21 | 6.34
B1220008 | 3 | 1.2 | 1.8 | 6.48 | 18.23
B5220007 | 2.75 | 0.9 | 1.85 | 4.579 | 12.89
B5220008 | 2.7 | 0.95 | 1.85 | 4.745 | 13.86
B7220003 | 2.2 | 1.1 | 1.35 | 3.267 | 9.52
B7220004 | 2.05 | 1.15 | 1.3 | 3.065 | 8.71
B2220003 | 3.2 | 1.25 | 1.2 | 4.8 | 13.55
B4220005 | 2.15 | 1.9 | 1.55 | 6.332 | 17.99
B1220009 | 3.05 | 1.05 | 1.75 | 5.604 | 16.13
B5220009 | 2.1 | 1.2 | 1.55 | 3.906 | 11.14
B4220006 | 1.9 | 0.8 | 1.8 | 2.736 | 7.65
B1220010 | 2.9 | 1.75 | 1.2 | 6.09 | 17.47
B1220011 | 2.1 | 1.8 | 2 | 7.56 | 21.63
[NAME] | 2.45 | 1.5 | 1.3 | 4.778 | 13.56
B4220007 | 3.15 | 1.8 | 1.55 | 8.788 | 25.09
B5220011 | 2.9 | 1.6 | 1.55 | 7.192 | 20.61
B5220012 | 2.85 | 1.5 | 1.8 | 7.695 | 21.98
B1220012 | 1.7 | 1.35 | 1.25 | 2.869 | 8.17
B1220013 | 2.95 | 1.6 | 1.65 | 7.788 | 21.88
B1220014 | 2.9 | 1.45 | 1.8 | 7.569 | 21.68
B1220015 | 2.05 | 1.3 | 1.7 | 4.53 | 13.04
B1220016 | 3 | 1.5 | 1.85 | 8.325 | 23.7
B1220017 | 2.25 | 0.85 | 1.45 | 2.773 | 8.03
B2220004 | 2.6 | 1.8 | 1.55 | 7.254 | 20.87
[NAME] | 2.3 | 1.1 | 1.5 | 3.795 | 10.86
[NAME] | 2.9 | 1.55 | 1.8 | 8.091 | 23.24
Spreadsheet: c8f11108-9036-4a65-aeff-bdde010b713f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
2895 | 13025 | [NAME] | Mulder | NED | 22 | 00:18:09 | 00:00:00 | 01:15:57 | 00:00:00 | 00:35:10 | 1 | 02:09:16
Spreadsheet: 69217d1269733950-vlookup-help-in-excel-excel
Sheet: Comments

Days on Market | Comment on Days on Market |  | Square Feet | Comment on Square Feet
<30 days | less than 1 Month |  | Less than 1000 | Small Size
between 31 and 60 days | 2 month |  | Between 1000 and 2000 | Medium Size
Between 61 and 180 days | 2-6 month |  | Greater than 2000 | Large Size
Between 181 and 365 days | 6-12 month
>365 | More than one year
Spreadsheet: 36918d1234884430-copy-select-columns-to-new-sheet-if-cell-0-lookupcall
Sheet: Sheet1

CallID | StartDateTime | Owner | DialableID | LastModified | OriginallyScheduled | Name | CallTimer
731021 | 2009-01-01 05:30:00 | fred | 1111 | 2009-08-01 07:47:00 | 06/16/2008 19:43 | call1 | 500
722537 | 2009-01-01 08:30:00 | barney | 6852 | 2009-08-01 09:47:00 | 2008-03-06 15:31:00 | call2 | 212
809741 | 2009-01-01 08:30:00 | wilma | 7434 | 2009-08-01 09:17:00 | 2008-08-10 10:06:00 | call3 | 7970
831787 | 2009-01-01 08:30:00 | betty | 2321 | 2009-08-01 09:17:00 | 2008-07-11 08:31:00 | call4 | 0
831848 | 2009-01-01 08:30:00 | pepples | 2211 | 2009-08-01 09:17:00 | 2008-07-11 08:33:00 | call5 | 366
844124 | 2009-01-01 08:30:00 | bambam | 8936 | 2009-08-01 09:32:00 | 11/24/2008 10:54 | call6 | 10155
855703 | 2009-01-01 08:30:00 | dino | 4001 | 2009-08-01 09:17:00 | 2008-09-12 12:22:00 | call7 | 4155
856744 | 2009-01-01 08:30:00 | bart | 1501 | 2009-08-01 09:17:00 | 2008-10-12 09:55:00 | call8 | 3378
858515 | 2009-01-01 08:30:00 | homer | 111666 | 2009-08-01 09:12:00 | 2008-12-12 08:13:00 | call9 | 5153
862250 | 2009-01-01 08:30:00 | lisa | 8754 | 2009-08-01 09:17:00 | 12/17/2008 11:40 | call10 | 654
866027 | 2009-01-01 08:30:00 | [NAME] | 9435 | 2009-08-01 09:17:00 | 12/22/2008 16:24 | call11 | 0
768221 | 2009-01-01 08:45:00 | [NAME] | 4876 | 2009-08-01 09:17:00 | 2008-08-08 15:55:00 | call12 | 44145
805979 | 2009-01-01 08:55:00 | maggie | 7886349 | 2009-08-01 10:12:00 | 2008-03-10 11:02:00 | call13 | 10111
864783 | 2009-01-01 08:58:00 | marge | 78841 | 2009-08-01 10:25:00 | 12/19/2008 15:18 | call14 | 584
768724 | 2009-01-01 09:00:00 | pat | 8963 | 2009-08-01 10:17:00 | 2008-11-08 10:18:00 | call15 | 8555
773083 | 2009-01-01 09:00:00 | jess | 3543 | 2009-08-01 09:47:00 | 08/15/2008 09:50 | call16 | 3557
789770 | 2009-01-01 09:00:00 | bob | 1000 | 2009-08-01 11:17:00 | 2008-11-09 16:04:00 | call17 | 66548
830999 | 2009-01-01 09:00:00 | frankie | 7538 | 2009-08-01 10:47:00 | 2008-06-11 11:46:00 | call18 | 0
845243 | 2009-01-01 09:00:00 | [NAME] | 6262 | 2009-08-01 09:47:00 | 11/25/2008 11:58 | call19 | 41820
Spreadsheet: 872794d1719238275-power-query-pivot-table-timesheet-query-1
Sheet: Formatted

Name | Dept | w/e | Project | Hours | Bil/Non
Empl3 | Detp2 | 2024-04-07 00:00:00 | Proj5 | 0
Empl3 | Detp2 | 2024-04-14 00:00:00 | Proj5 | 0
Empl3 | Detp2 | 2024-04-21 00:00:00 | Proj5 | 0
Empl3 | Detp2 | 2024-04-28 00:00:00 | Proj5 | 0
Empl3 | Detp2 | 2024-05-05 00:00:00 | Proj5 | 1
Empl3 | Detp2 | 2024-05-12 00:00:00 | Proj5 | 0
Empl3 | Detp2 | 2024-05-19 00:00:00 | Proj5 | 0
Empl3 | Detp2 | 2024-05-26 00:00:00 | Proj5 | 0
Empl3 | Detp2 | 2024-06-02 00:00:00 | Proj5 | 2
Empl3 | Detp2 | 2024-06-09 00:00:00 | Proj5 | 0
Empl3 | Detp2 | 2024-04-07 00:00:00 | Proj6 | 22
Empl3 | Detp2 | 2024-04-14 00:00:00 | Proj6 | 26
Empl3 | Detp2 | 2024-04-21 00:00:00 | Proj6 | 25
Empl3 | Detp2 | 2024-04-28 00:00:00 | Proj6 | 22
Empl3 | Detp2 | 2024-05-05 00:00:00 | Proj6 | 24
Empl3 | Detp2 | 2024-05-12 00:00:00 | Proj6 | 21
Empl3 | Detp2 | 2024-05-19 00:00:00 | Proj6 | 18
Empl3 | Detp2 | 2024-05-26 00:00:00 | Proj6 | 25
Empl3 | Detp2 | 2024-06-02 00:00:00 | Proj6 | 24
Empl3 | Detp2 | 2024-06-09 00:00:00 | Proj6 | 23
Empl1 | Detp1 | 2024-04-07 00:00:00 | Proj1 | 0
Empl1 | Detp1 | 2024-04-14 00:00:00 | Proj1 | 7
Empl1 | Detp1 | 2024-04-21 00:00:00 | Proj1 | 10.75
Empl1 | Detp1 | 2024-04-28 00:00:00 | Proj1 | 14.5
Empl1 | Detp1 | 2024-05-05 00:00:00 | Proj1 | 19.5
Empl1 | Detp1 | 2024-05-12 00:00:00 | Proj1 | 19.5
Empl1 | Detp1 | 2024-05-19 00:00:00 | Proj1 | 14.25
Empl1 | Detp1 | 2024-05-26 00:00:00 | Proj1 | 11.5
Empl1 | Detp1 | 2024-06-02 00:00:00 | Proj1 | 12
Empl1 | Detp1 | 2024-06-09 00:00:00 | Proj1 | 16.25
Empl1 | Detp1 | 2024-06-16 00:00:00 | Proj1 | 100
Empl1 | Detp1 | 2024-04-07 00:00:00 | [NAME] | 0
Empl1 | Detp1 | 2024-04-14 00:00:00 | [NAME] | 5
Empl1 | Detp1 | 2024-04-21 00:00:00 | [NAME] | 3
Empl1 | Detp1 | 2024-04-28 00:00:00 | [NAME] | 9
Empl1 | Detp1 | 2024-05-05 00:00:00 | [NAME] | 1
Empl1 | Detp1 | 2024-05-12 00:00:00 | [NAME] | 2.75
Empl1 | Detp1 | 2024-05-19 00:00:00 | [NAME] | 2.75
Empl1 | Detp1 | 2024-05-26 00:00:00 | [NAME] | 4
Empl1 | Detp1 | 2024-06-02 00:00:00 | [NAME] | 2.5
Empl1 | Detp1 | 2024-06-09 00:00:00 | [NAME] | 2.75
Empl1 | Detp1 | 2024-04-07 00:00:00 | Holiday Taken | 1.7
Empl1 | Detp1 | 2024-04-14 00:00:00 | Holiday Taken | 0
Empl1 | Detp1 | 2024-04-21 00:00:00 | Holiday Taken | 0
Empl1 | Detp1 | 2024-04-28 00:00:00 | Holiday Taken | 0
Empl1 | Detp1 | 2024-05-05 00:00:00 | Holiday Taken | 0
Empl1 | Detp1 | 2024-05-12 00:00:00 | Holiday Taken | 0
Empl1 | Detp1 | 2024-05-19 00:00:00 | Holiday Taken | 0
Empl1 | Detp1 | 2024-05-26 00:00:00 | Holiday Taken | 0
Empl1 | Detp1 | 2024-06-02 00:00:00 | Holiday Taken | 10
Empl1 | Detp1 | 2024-06-09 00:00:00 | Holiday Taken | 0
Spreadsheet: 0c378587-ec8e-45e8-aaa1-f5a05cdee79a
Sheet: Sheet1

FY 2011 AEA STATE AID PAYMENTS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | ORIGINAL | SEPT-OCT | PAID THROUGH | AMOUNT
 |  | BUDGET | PAYMENT | OCTOBER | REMAINING
1 | [NAME] 1 | 13431398 | 1343141 | 2686282 | 10745116
5 | PRAIRIE LAKES AEA 8 | 13196032 | 1319603 | 2639206 | 10556826
7 | AEA 267 | 28293632 | 2829366 | 5658732 | 22634900
9 | MISSISSIPPI BEND AEA 9 | 19600648 | 1960068 | 3920136 | 15680512
10 | GRANT WOOD AEA 10 | 27263347 | 2726336 | 5452672 | 21810675
11 | HEARTLAND AEA 11 | 49241026 | 4924107 | 9848214 | 39392812
12 | NORTHWEST AEA | 16359617 | 1635961 | 3271922 | 13087695
13 | LOESS HILLS AEA 13 | 16376170 | 1637617 | 3275234 | 13100936
15 | GREAT PRAIRIE AEA 15 | 15006162 | 1500620 | 3001240 | 12004922
 |  | 198768032 | 19876819 | 39753638 | 159014394
Spreadsheet: 355371d1414669173-removing-all-duplicates-sample2
Sheet: Sheet1

original data |  |  |  | expected results
- Open Market - | weblink1 |  |  |  | weblink9
- Open Market - | weblink2 |  |  |  | weblink12
"Chandlers [NAME] and [NAME] " | weblink3
"Chandlers [NAME] and [NAME] " | weblink4
"Recycle Your Unwanted Treasures In Barrow" | [NAME]
"Recycle Your Unwanted Treasures In Barrow" | weblink6
(Brand new group) banbury items forsale/or swap | weblink7
(Brand new group) banbury items forsale/or swap | weblink8
(Kent) Local Online Car Boot (jumble sale) | weblink9
* FOR SALE or FREE in CHISLEHURST * | weblink10
* FOR SALE or FREE in CHISLEHURST * | weblink11
* Recycle Bay * | weblink12
** MK SALE ***** | weblink13
** MK SALE ***** | weblink14
**FACEBAY~ IN~ THANET** | weblink15
**FACEBAY~ IN~ THANET** | weblink16
*Sell as many items you like in matlock* | weblink17
*Sell as many items you like in matlock* | weblink18