tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 35500d1233106141-excel-2007-confirm-formula-is-correct-qc-sheet-master
Sheet: Weekly Review

 |  |  |  |  |  |  |  | Weekly QC Report
 |  |  |  |  |  |  |  |  |  |  | 2009-01-26 00:00:00 | Thru
 |  |  |  |  |  |  |  | System: | Scranton
 | Technician |  |  |  |  | Jobs Routed | [NAME] | Jobs Not Completed | Work Completion % | QC % of Compled Work | Total QC Completed | QC % Break Down by [NAME] | Pass | Fail | QC Failure % By [NAME]
 | 1 | [NAME]
 | 2 | [NAME]
 | 3 | [NAME]
 | 4 | [NAME]
 | 5 | [NAME]
 | 6 | [NAME]
 | 7 | [NAME]
 | 8 | [NAME]
 | 9 | [NAME]
 | 10 | [NAME]
 | 11 | [NAME]
 | 12 | [NAME]
 | 13 | [NAME]
 | 14 | [NAME]
 | 15 | [NAME]
 | 16 | [NAME]
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | Totals |  |  |  |  | Total Jobs | Completed | Not Completed | Total Comp % | Work QC'd Total | Total QC's Completed |  | Pass | Fail | QC Failure % Average
Spreadsheet: darron_c_giron__7940__term deals in price book
Sheet: Summary

 |  | Terminated Financial Deals still in Active Book
CP |  |  |  | Position(contracts) | PV Value
Entergy |  |  |  |  | -16833776.43780015
Energy USA |  |  |  |  | -6398743.544699995
Enrcore |  |  |  |  | -1398548.0557
DUKE |  |  |  |  | -346697.1689
Vitol S.A. |  |  |  |  | 1415445.229900002
Transwestern |  |  |  |  | -38105280.689
Totals
Spreadsheet: 807921d1670170259-creating-credit-summary-report-of-a-shop-billing-software-test
Sheet: Credit Report (2)

SN # | ID | Name | SN# | 1 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 5 |  |  | 6
 |  |  | Old Balance | Date | [NAME] | Amount | Date | [NAME] | Amount | Date | [NAME] | Amount | Date | [NAME] | Amount | Date | [NAME] | Amount | Date | [NAME] | Amount
1 | CUS 001 | Praveen |  | 2022-11-12 00:00:00 | TAS-CD-01 | 1023 | 2022-11-13 00:00:00 | TAS-CD-03 | 1123 | 2022-11-14 00:00:00 | TAS-CD-06 | 34
2 | CUS 002 | Nilesh |  | 2022-11-13 00:00:00 | TAS-CU-01
3 | CUS 003 | Neeraj Ganesh
4 | CUS 004 | [NAME]
5 | CUS 005 | [NAME]
 |  | ID | Name
 |  | CUS 001
 |  | SN # | Date | [NAME] | Amount |  |  |  |  |  |  |  | 2 | 3
 |  | 1 |  | TAS-CD-01 | 1023 |  |  |  |  |  |  | 4 | 5 | 6
 |  | 2 | 2022-11-13 00:00:00 | TAS-CD-03 | 1123 |  |  |  |  |  |  | 7 | 8 | 9
 |  | 3 | 2022-11-14 00:00:00 | TAS-CD-06 | 34 |  |  |  |  |  |  | 10 | 11 | 12
 |  | 4 | 00:00:00 | 0 | 0 |  |  |  |  |  |  | 13 | 14 | 15
 |  | 5 | 00:00:00 | 0 | 0
 |  | 6 | 00:00:00 | 0 | 0
Spreadsheet: 271737d1382031201-create-drop-downs-based-on-conditions-excel-forum-help
Sheet: Data 1

 | SINGLE PANEL |  |  |  |  | FRONT/BACK PANEL |  |  |  |  | WRAP AROUND
Product Type/Volume | 250-499 | 500-749 | 750-999 | 1000-1999 | 2000+ | 250-499 | 500-749 | 750-999 | 1000-1999 | 2000+ | 250-499 | 500-749 | 750-999 | 1000-1999 | 2000+
Fillers - 3 Liters |  |  |  |  |  |  |  |  |  |  | 2.34 | 1.37 | 1.05 | 0.9 | 0.56
Putty/Glaze - 880ml |  |  |  |  |  |  |  |  |  |  | 1.79 | 0.92 | 0.66 | 0.52 | 0.3
Primer - 1 Gallon (NR/2.1VOC) |  |  |  |  |  |  |  |  |  |  | 2.98 | 1.69 | 1.27 | 1.06 | 0.74
Primer - 1 Liter (NR only) |  |  |  |  |  |  |  |  |  |  | 3.142 | 1.6885 | 1.271833333333333 | 1.03 | 0.656
2:1 Clear - 5 Liter (NR/2.1VOC) | 1.939 | 1.022 | 0.7263333333333333 | 0.5685 | 0.35175 | 3.878 | 2.044 | 1.452666666666667 | 1.137 | 0.7035 | 4.629 | 2.627 | 1.961333333333333 | 1.6595 | 1.15525
4:1 Clear - 1 Gallon (NR/2.1VOC) | 1.867 | 0.981 | 0.6956666666666667 | 0.5425 | 0.3275 | 3.734 | 1.962 | 1.391333333333333 | 1.085 | 0.655 | 4.273 | 2.378 | 1.765333333333333 | 1.457 | 0.984
Hardener - 1 Quart (NR/2.1VOC) | 1.7675 | 0.9155 | 0.6331666666666667 | 0.4945 | 0.2785 | 3.535 | 1.831 | 1.266333333333333 | 0.989 | 0.557 | 2.1985 | 1.222 | 0.9025 | 0.7450000000000001 | 0.49825
Hardener - 2.5 Liter (NR/2.1VOC) | 1.822 | 0.943 | 0.6443333333333334 | 0.5085 | 0.28575 | 3.644 | 1.886 | 1.288666666666667 | 1.017 | 0.5715 | 4.019 | 2.17 | 1.566333333333333 | 1.2705 | 0.8065
Product Type | Quantity
Fillers - 3 Liters | 250-499
Putty/Glaze - 880ml | 500-749
Primer - 1 Gallon (NR/2.1VOC) | 750-999
Primer - 1 Liter (NR only) | 1000-1999
2:1 Clear - 5 Liter (NR/2.1VOC) | 2000+
4:1 Clear - 1 Gallon (NR/2.1VOC)
Hardener - 1 Quart (NR/2.1VOC)
Hardener - 2.5 Liter (NR/2.1VOC)
Label Type |  |  |  |  | Label Type
Fillers - 3 Liters | Wrap Around |  |  |  | Fillers - 3 Liters | Wrap Around
Putty/Glaze - 880ml | Wrap Around |  |  |  | Putty/Glaze - 880ml | Wrap Around
Primer - 1 Gallon (NR/2.1VOC) | Wrap Around |  |  |  | Primer - 1 Gallon (NR/2.1VOC) | Wrap Around
Primer - 1 Liter (NR only) | Wrap Around |  |  |  | Primer - 1 Liter (NR only) | Wrap Around
2:1 Clear - 5 Liter (NR/2.1VOC) |  |  |  |  | 2:1 Clear - 5 Liter (NR/2.1VOC) | Single Panel
4:1 Clear - 1 Gallon (NR/2.1VOC) |  |  |  |  | 2:1 Clear - 5 Liter (NR/2.1VOC) | Front/Back Panel
Hardener - 1 Quart (NR/2.1VOC) |  |  |  |  | 2:1 Clear - 5 Liter (NR/2.1VOC) | Wrap Around
Hardener - 2.5 Liter (NR/2.1VOC) |  |  |  |  | 4:1 Clear - 1 Gallon (NR/2.1VOC) | Single Panel
 |  |  |  |  | 4:1 Clear - 1 Gallon (NR/2.1VOC) | Front/Back Panel
 |  |  |  |  | 4:1 Clear - 1 Gallon (NR/2.1VOC) | Wrap Around
 |  |  |  |  | Hardener - 1 Quart (NR/2.1VOC) | Single Panel
 |  |  |  |  | Hardener - 1 Quart (NR/2.1VOC) | Front/Back Panel
 |  |  |  |  | Hardener - 1 Quart (NR/2.1VOC) | Wrap Around
 |  |  |  |  | Hardener - 2.5 Liter (NR/2.1VOC) | Single Panel
 |  |  |  |  | Hardener - 2.5 Liter (NR/2.1VOC) | Front/Back Panel
 |  |  |  |  | Hardener - 2.5 Liter (NR/2.1VOC) | Wrap Around
Spreadsheet: 136187d1326465042-how-to-merge-multiple-lines-on-a-time-sheet-sched-time-sheet-integration
Sheet: Hours

Employee Number | Name | Su | Mo | [NAME] | We | Th | Fr | Sa | Reg Hours | OT Hours | Unworked Stat Hours | Total Weekly Hours | Su | Mo | [NAME] | We | Th | Fr | Sa | Reg Hours | OT Hours | Unworked Stat Hours | Total Weekly Hours | Total Bi-Weekly Hours
 |  | 1900-01-01 00:00:00 | 1900-01-02 00:00:00 | 1900-01-03 00:00:00 | 1900-01-04 00:00:00 | 1900-01-05 00:00:00 | 1900-01-06 00:00:00 | 1900-01-07 00:00:00
14327 | Doe, [NAME]
13940 | Smith, [NAME]
15434 | Jones, [NAME]
15427 | Random, Name
Spreadsheet: 168754d1342559177-transpose-rows-of-various-lengths-pivot-table-for-jimdandy
Sheet: Sheet1

Count of Applications | Column Labels
Row Labels | Application #1 | Application #10 | Application #11 | Application #12 | Application #13 | Application #14 | Application #15 | Application #2 | Application #21 | Application #22 | Application #23 | Application #25 | Application #3 | Application #31 | Application #32 | Application #33 | Application #4 | Application #42 | Application #5 | Grand Total
Machine #1 | 1 |  |  |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  | 1 |  |  | 4
Machine #10 |  |  |  |  | 1 |  | 1 |  |  |  |  | 1 |  |  |  |  |  |  |  | 3
Machine #2 |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
Machine #3 | 1 |  |  | 1 |  | 1 |  |  |  |  |  |  | 1 |  |  |  |  |  | 1 | 5
Machine #4 |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  | 2
Machine #5 | 1 |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  | 4
Machine #6 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 2
Machine #7 | 1 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 2
Machine #8 |  |  |  | 1 | 2 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 4
Machine #9 |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1 |  |  |  | 3
Grand Total | 5 | 1 | 1 | 3 | 4 | 1 | 1 | 2 | 1 | 2 | 1 | 1 | 2 | 1 | 1 | 1 | 2 | 1 | 1 | 32
Spreadsheet: 6afd4f91-e26e-4e0c-913c-c5d1f696dde2
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0034350 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Hendersonville WWTP | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Henderson | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 31616 | 00610 | 00530 | 00076
Day | ORC Arrival Time | ORC Time On Site | Flow | BOD5 | Fecal Coliform | Ammonia | Total Suspended Solids | Turbidity
 | 24-hr | hrs | GPD | mg/L | #/100 mL | mg/L | mg/L | NTU
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Composite | Grab | Composite | Composite | Recorder
Monthly Limit: |  |  |  | 10 | 14 | 4 | 5
Daily Limit: |  |  |  | 15 | 25 | 6 | 10 | 10
Sample Frequency: |  |  | [NAME] | See Permit | See Permit | See Permit | See Permit | [NAME]
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 24211d1214341227-merging-lists-concertgoers1
Sheet: Sheet1

ABBOTT | GREGORY | AAPAJARVI | PETER | [NAME] | AAPAJARVIPETER | 1 | 2
ABE | THERESA | ABATECOLA | CHRISTIE | ABETHERESA | ABATECOLACHRISTIE | 0
ABEEL | KATHLEEN J | ABBA | DEBORAH | ABEELKATHLEEN J | ABBADEBORAH | 0
ABEND | [NAME] | ABBOTT | NATHAN | [NAME] | ABBOTTNATHAN | 0
ABITABILE | KAYLA | ABBOTT | GREGORY | ABITABILEKAYLA | [NAME] | 0
ABREU | COURTNEY | ABBOTT | THOMAS | ABBOTTNATHAN | ABBOTTTHOMAS | 1
ABREVAYA | NICOLE | ABDELLA | NOLAN | ABREVAYANICOLE | ABDELLANOLAN | 0
Spreadsheet: 97952d1297061760-multilookup-alongwith-sorting-for-only-months-plus-clubbing-like-data-multilookup-sort-clubbing
Sheet: M

Sr.No | Policy Holders Name | POLICY NO | Date of  Comm | T-T | MODE | NAME OF THE PLAN | Plan Type | SUM ASSURED
1 | [NAME] | 705787833 | 2003-01-14 00:00:00 | 48-25 | [NAME] | LIMITED PYMNT WITH PROFITS | Insurance | 100000
2 | [NAME] | 702383786 | 2004-06-28 00:00:00 | 14-30 | SGL | ENDOWMENT  WITH BONUS | Insurance | 55000
3 | [NAME] | 702383787 | 2004-06-28 00:00:00 | 14-31 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 55000
4 | [NAME] | 702383788 | 2004-06-28 00:00:00 | 14-32 | SGL | ENDOWMENT  WITH BONUS | Insurance | 55000
5 | [NAME] | 702007563 | 2005-02-15 00:00:00 | 169-22 | [NAME] | JEEVAN NIDHI WITH GUAR ADDTNS | Pension | 220000
6 | [NAME] | 702007568 | 2005-02-15 00:00:00 | 14-32 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 55000
7 | [NAME] | 702007560 | 2005-02-15 00:00:00 | 14-33 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 55000
8 | [NAME] | 703572877 | 2008-06-27 00:00:00 | 165-35 | [NAME] | JEEVAN SARAL | Insurance | 250000
Spreadsheet: 720751d1614275482-average-a-row-but-ignore-a-column-if-a-header-cell-contains-a-word-phrase-example
Sheet: Sheet1

 | Standing | Weekly Average | 2021-02-24 00:00:00 | 2021-02-23 00:00:00 | 2021-02-22 00:00:00 | 2021-02-21 00:00:00 | 2021-02-20 00:00:00 | 2021-02-19 00:00:00 | 2021-02-18 00:00:00
Star
Element
Name
Wins (1=win) |  |  | Let go | 1 | 1 | 1 | 1 | 1 | Let Go
 |  |  | 7031 | 98818 | 161597 | 120992 | 105721 | 104418 | 5
 |  |  | 98341 | 217719 | 371477 | 215845 | 344287 | 191081 | 67871
 |  |  | 2 | 449034 | 226183 | 416907 | 308720 | 312729 | 1155
 |  |  | 114522 | 68161 | 215474 | 300547 | 87064 | 172875 | 60264
 |  |  | 30261 | 78836 | 166044 | 61077 | 63894 | 46982 | 97656
 |  |  | 8208 | 271711 | 164008 | 124685 | 67855 | 68168 | 6451
 |  |  | 44819 | 372094 | 160886 | 91862 | 277842 | 158167 | 39268
 |  |  | 47885 | 78237 | 117071 | 99522 | 172155 | 110142 | 23190
 |  |  | 40095 | 116224 | 128803 | 116263 | 145907 | 123499 | 52569
 |  |  | 8227 | 119677 | 163815 | 138211 | 171341 | 205056 | 65117
 |  |  | 18156 | 30864 | 122902 | 59534 | 52440 | 149218 | 0
 |  |  | 33759 | 98153 | 172366 | 192538 | 158611 | 205398 | 73428
 |  |  | 46099 | 197186 | 221072 | 144648 | 149934 | 136040 | 46256
 |  |  | 4539 | 316304 | 166215 | 151482 | 150645 | 181932 | 2
 |  |  | 14605 | 356824 | 160069 | 178276 | 118876 | 133971 | 8142
 |  |  | 73041 | 100914 | 196071 | 52695 | 327699 | 122476 | 139562
 |  |  | 61686 | 362049 | 197926 | 446427 | 246956 | 315645 | 43530
 |  |  | 12596 | 187654 | 456052 | 149953 | 264881 | 143305 | 23618
 |  |  | 21 | 182631 | 253057 | 102083 | 302195 | 110867 | 26958
 |  |  | 23407 | 319138 | 234505 | 234532 | 107948 | 301306 | 0
 |  |  | 31669 | 122957 | 247470 | 104897 | 131810 | 157542 | 27756
 |  |  | 1918 | 251232 | 156434 | 193650 | 206055 | 120623 | 1720
 |  |  | 2 | 214745 | 198984 | 96795 | 190995 | 190211 | 18
 |  |  | 99481 | 71477 | 189992 | 281607 | 93602 | 132846 | 114288
 |  |  | 6322 | 192167 | 167321 | 121975 | 44556 | 78406 | 21250
 |  |  | 0 | 172448 | 212629 | 110336 | 184470 | 253447 | 24187
 |  |  | 51060 | 191927 | 126759 | 391312 | 127923 | 138492 | 59254
 |  |  | 31690 | 166605 | 217155 | 90952 | 86719 | 121670 | 48523
 |  |  | 22111 | 182297 | 93631 | 116917 | 178867 | 281083 | 2438
 |  |  | 19398 | 142421 | 73014 | 130636 | 146032 | 63035 | 41970
Spreadsheet: 678649d1589993208-slicer-which-can-list-by-specific-periods-2020-05-20-oeldere-zanshin777-678478d1589909386-slicer-which-can-list-by-specific-periods-exe
Sheet: Reports

General |  |  |  | Guitar |  |  |  | Keyboard |  |  |  | Ear Training
Categories | Duration (hrs) | Rates |  | Sub Cat. | Duration (hrs) | Rates |  | Sub Cat. | Duration (hrs) | Rates |  | Sub Cat. | Duration (hrs) | Rates
AEU |  |  |  |  |  |  |  | Keyboard
Ear Training
Guitar
Intellectual
Keyboard
Songwriting
Innovation
Total |  |  |  | Total |  |  |  | Total |  |  |  | Total
Intellectual |  |  |  | Songwriting |  |  |  | AEU |  |  |  | Innovation
Sub Cat. | Duration (hrs) | Rates |  | Sub Cat. | Duration (hrs) | Rates |  | Sub Cat. | Duration (hrs) | Rates |  | Sub Cat. | Duration (hrs) | Rates
Total |  |  |  | Total |  |  |  | Total |  |  |  | Total
Spreadsheet: 121469d1316088296-graphing-issue-792399
Sheet: Report(1) (5)

need a 100% bar chart which shows each question. People were asked to select how they felt, 1 being min 10 [NAME] and na not bothered col d is # of vaote received .
Question # | Site Aspects | Scale: n/a = not bothered. 1 = min facilities. 10 = [NAME] facilities | Total number of votes |  |  |  | N/A | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
1 | Minimal facilities | N/A | 25
 |  | 1 | 41
 |  | 2 | 35
 |  | 3 | 40
 |  | 4 | 128
 |  | 5 | 127
 |  | 6 | 57
 |  | 7 | 78
 |  | 8 | 66
 |  | 9 | 30
 | Load of facilities | 10 | 92
2 | Quiet | N/A | 86
 |  | 1 | 105
 |  | 2 | 83
 |  | 3 | 63
 |  | 4 | 137
 |  | 5 | 107
 |  | 6 | 32
 |  | 7 | 24
 |  | 8 | 7
 |  | 9 | 2
 | Lively | 10 | 2
3 | Adults only | N/A | 17
 |  | 1 | 14
 |  | 2 | 9
 |  | 3 | 10
 |  | 4 | 43
 |  | 5 | 37
 |  | 6 | 14
 |  | 7 | 28
 |  | 8 | 34
 |  | 9 | 49
 | Open to all ages | 10 | 462
4 | Small number of pitches | N/A | 40
 |  | 1 | 42
 |  | 2 | 59
 |  | 3 | 54
 |  | 4 | 237
 |  | 5 | 155
 |  | 6 | 24
 |  | 7 | 31
 |  | 8 | 16
 |  | 9 | 8
 | Large number of pitches | 10 | 26
5 | Remote location | N/A | 27
 |  | 1 | 51
 |  | 2 | 67
 |  | 3 | 45
 |  | 4 | 216
 |  | 5 | 146
 |  | 6 | 53
 |  | 7 | 43
 |  | 8 | 22
 |  | 9 | 6
 | In the centre of things | 10 | 24
6 | Mostly grass pitches | N/A | 25
 |  | 1 | 29
 |  | 2 | 24
 |  | 3 | 30
 |  | 4 | 180
 |  | 5 | 146
 |  | 6 | 46
 |  | 7 | 44
 |  | 8 | 47
 |  | 9 | 23
 | Mostly hardstandings | 10 | 132
7 | Screened small pitching areas | N/A | 79
 |  | 1 | 87
 |  | 2 | 62
 |  | 3 | 43
 |  | 4 | 134
 |  | 5 | 101
 |  | 6 | 26
 |  | 7 | 35
 |  | 8 | 22
 |  | 9 | 15
 | Wide open site layout | 10 | 52
8 | For CC members only | N/A | 136
 |  | 1 | 95
 |  | 2 | 41
 |  | 3 | 35
 |  | 4 | 71
 |  | 5 | 68
 |  | 6 | 14
 |  | 7 | 14
 |  | 8 | 10
 |  | 9 | 13
 | Open to all | 10 | 45
9 | `Rules` atmosphere | N/A | 26
 |  | 1 | 44
 |  | 2 | 41
 |  | 3 | 49
 |  | 4 | 140
 |  | 5 | 101
 |  | 6 | 50
 |  | 7 | 53
 |  | 8 | 55
 |  | 9 | 32
 | Relaxed atmosphere | 10 | 133
10 | No electric hooks up available | N/A | 3
 |  | 1 | 2
 |  | 2 | 3
 |  | 3 | 3
 |  | 4 | 24
 |  | 5 | 16
 |  | 6 | 9
 |  | 7 | 40
 |  | 8 | 53
 |  | 9 | 48
 | Every pitch has EHU | 10 | 546
11 | No showers/toilets | N/A | 11
 |  | 1 | 10
 |  | 2 | 7
 |  | 3 | 5
 |  | 4 | 34
 |  | 5 | 29
 |  | 6 | 17
 |  | 7 | 20
 |  | 8 | 25
 |  | 9 | 48
 | Showers/toilets available | 10 | 536
Spreadsheet: 29651d1224732269-iserror-formula-excel-help-with-nested-if
Sheet: Sheet1

 |  |  |  |  |  |  | 30 | 31 | 31 | 30 | 31 | >>>>>> days
 | Debt |  |  |  |  |  | Sales
Cust ID | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5
A | 25000 | 0 | 0 | 25000 | 30000 |  | 50000 | 0 | 0 | 30000 | 300000
B | 15000 | 0 | 65000 | 0 | 0 |  | 25000 | 0 | 75000 | 0 | 0
C | 10000 | 0 | 0 | 50000 | 0 |  | 15000 | 0 | 50000 | 0 | 0
D | 50000 | 0 | 0 | 0 | 0 |  | 55000 | 0 | 0 | 0 | 0
Spreadsheet: 109588d1306410700-rearranging-data-for-further-analysis-example-of-route-1-
Sheet: Final (Step1)

Date | Duty | DOT Rout No | Trip | Contract | Bus | Driver | Sched Time | Book On Time | Schedule Distance |  | Non-Rev | Revenue | Passes | Tickets | Transfer | Total Psngrs
Spreadsheet: 62db3095-f5d5-4e71-ad5f-c5decebd3e22
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0007144 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Camp Seafarer | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | [NAME] | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 00940 | 50060 | 31616 | 00610 | 00625 | 00620 | 00400 | 70300 | 00530
Day | ORC Arrival Time | ORC Time On Site | Flow | BOD5 | Chloride | Total Residual Chlorine | Fecal Coliform | Ammonia | Total [NAME] | Nitrate | pH | Total Dissolved Solids | Total Suspended Solids
 | 24-hr | hrs | GPD | mg/L | mg/L | mg/L | #/100 mL | mg/L | mg/L | mg/L | su | mg/L | mg/L
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Composite | Composite | Grab | Grab | Composite | Composite | Composite | Grab | Composite | Composite
Monthly Limit: |  |  | 55000
Daily Limit:
Sample Frequency: |  |  | [NAME] | 4 x Year | 3 x Year | 5 x Week | 4 x Year | 4 x Year | 4 x Year | 4 x Year | 5 x Week | 3 x Year | 4 x Year
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 30418d1225918736-categorizing-labels-gvb_lookup_example
Sheet: Sheet1

Alpha
Bravo
[NAME]
Delta
Echo
Foxtrot
Golf
Hotel
India
[NAME]
Kilo
Lima
[NAME]
November
October
Papa
Quebec
Romeo
Sierra
Tango
Uniform
Victor
Whiskey
[NAME]
Yankee
Zulu
Spreadsheet: 842235d1694350159-random-pick-a-cell-content-in-a-range-ignoring-all-blank-empty-cells-in-that-range-random-20230910
Sheet: Blad1

9 | 12 | 42 | 34
45 | 10 | 21 | 46
51 | 32 | 48 | 3
14 | 44 | 29 | 33
46 | 39 | 45 | 31
43 | 51 | 16
33 | 38 | 6
30 | 45 | 13
44 | 5 | 20 | 14
47 | 30 | 46 | 11
15 | 22 |  | 16
34 | 28 | 39 | 18
2 | 37 | 36 | 50
24 | 15 | 44 | 20
49 | 31
7 | 23 | 14 | 32
26 | 49 | 41 | 27
21 | 46 | 11 | 13
29 | 7 | 12 | 5
41 | 21 | 4 | 35
6 | 43 | 38
23 | 34 | 25 | 41
42 | 8 | 51 | 37
13 | 29 | 52 | 51
8 |  | 3 | 4
37 | 20 | 26 | 47
36 | 25 | 31 | 2
10 | 11 | 24 | 21
39 | 2 | 18 | 24
17 | 48 | 15 | 15
48 | 47 | 34 | 44
52 | 33 | 35
25 |  | 8 | 42
28 | 41 |  | 28
5 | 6 | 50 | 9
4 | 3 | 33
 | 13 | 37 | 30
3 | 24
16 | 42 | 2 | 29
27 | 36 | 7 | 52
31 | 14 | 32 | 36
38 |  | 10 | 38
 | 18 | 27 | 26
50 | 9 | 30 | 48
32 | 4 | 23
12 | 26 | 22 | 43
20 |  | 47 | 12
40 | 27 | 9 | 8
22 | 16 | 5 | 6
11 | 35 | 28 | 23
35 | 52 | 43 | 22
18 | 50 |  | 7
Spreadsheet: 884824d1734084512-vlookup-returns-a-value-of-0-even-though-there-is-no-valid-numerical-number-workbook-a_simplified
Sheet: Dept A

Location | Room | Description | Fixture Type | Tag | Temp @ 10s | Maximum Temperature | Wash Limit Time | Operational Temp | Operational Temp within Tolerance Value
0-3 | 0202 | General Maint. Shop | Sinks | SK-1 | 57 | 61.5 | N/A
0-3 | 0204 | Staff Lounge | Sinks | SK-3 | 58.5 | 61 | N/A
0-3 | 0208 | WR, Pub, BF | Lavatory | LAV-1 | 41.5 | 42.3 | 30s
Spreadsheet: 108443d1305534260-excel-2007-pivot-table-formulas-with-custom-subtotals-sample
Sheet: pivot2

 |  | year | month
 |  | 2010 |  | Toplam 2010 | Ortalama 2010 | 2011 |  | Toplam 2011 | Ortalama 2011 | Genel Toplam
name | Değerler | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 |  |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00
[NAME] | Toplam balance | 10 | 32 | 42 | 21 | 14 | 24 | 38 | 19 | 80
 | Toplam quantity | 2 | 5 | 7 | 3.5 | 2 | 4 | 6 | 3 | 13
 | Toplam tax | 2 | 2 | 4 | 2 | 2 | 2 | 4 | 2 | 8
 | Toplam % | 0.2 | 0.0625 |  |  | 0.1428571428571428 | 0.08333333333333333 |  |  | 0.1
item2 | Toplam balance | 24 | 26 | 50 | 25 | 52 | 53 | 105 | 52.5 | 155
 | Toplam quantity | 3 | 3 | 6 | 3 | 4 | 4 | 8 | 4 | 14
 | Toplam tax | 5 | 6 | 11 | 5.5 | 7 | 8 | 15 | 7.5 | 26
 | Toplam % | 0.2083333333333333 | 0.2307692307692308 |  |  | 0.1346153846153846 | 0.1509433962264151 |  |  | 0.167741935483871
item3 | Toplam balance | 100 | 102 | 202 | 101 | 107 | 108 | 215 | 107.5 | 417
 | Toplam quantity | 5 | 5 | 10 | 5 | 5 | 5 | 10 | 5 | 20
 | Toplam tax | 22 | 23 | 45 | 22.5 | 24 | 25 | 49 | 24.5 | 94
 | Toplam % | 0.22 | 0.2254901960784314 |  |  | 0.2242990654205607 | 0.2314814814814815 |  |  | 0.2254196642685851
Toplam balance Toplamı |  | 134 | 160 | 294 | 49 | 173 | 185 | 358 | 59.66666666666666 | 652
Toplam quantity Toplamı |  | 10 | 13 | 23 | 3.833333333333333 | 11 | 13 | 24 | 4 | 47
Toplam tax Toplamı |  | 29 | 31 | 60 | 10 | 33 | 35 | 68 | 11.33333333333333 | 128
Toplam % Toplamı |  | 0.2164179104477612 | 0.19375 | #N/A | #N/A | 0.1907514450867052 | 0.1891891891891892 | #N/A | #N/A | 0.196319018404908
Spreadsheet: andy_zipper__741__10_29_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | 22 | 192 | 200 | 52.3 | 54.5 | 0.74 | 2001-10-29 13:22:00
 | CL F2 | 22.5 | 327 | 337 | 51.6 | 53.2 | 0.74 | 2001-10-29 13:22:00
 | CL G2 | 22.5 | 418 | 428 | 50.6 | 51.8 | 0.72 | 2001-10-29 13:22:00
 | CL H2 | 22.5 | 468 | 480 | 48.6 | 49.9 | 0.7 | 2001-10-29 13:22:00
 | CL J2 | 22.5 | 505 | 517 | 46.8 | 47.9 | 0.67 | 2001-10-29 13:22:00
 | CL K2 | 22.5 | 520 | 535 | 43.4 | 44.7 | 0.62 | 2001-10-29 13:22:00
 | CL M2 | 22.5 | 535 | 550 | 41.5 | 42.6 | 0.59 | 2001-10-29 13:22:00
 | CL N2 | 22.5 | 540 | 560 | 39 | 40.4 | 0.56 | 2001-10-29 13:22:00
 | CL Q2 | 22.5 | 550 | 565 | 37.5 | 38.5 | 0.54 | 2001-10-29 13:22:00
 | CL U2 | 22.5 | 555 | 570 | 36 | 37 | 0.52 | 2001-10-29 13:22:00
 | [NAME] | 22 | 558 | 573 | 35.3 | 36.2 | 0.49 | 2001-10-29 13:22:00
 | CL X2 | 22 | 560 | 575 | 34 | 34.9 | 0.48 | 2001-10-29 13:22:00
 | [NAME] | 22 | 560 | 580 | 32.9 | 34 | 0.46 | 2001-10-29 13:22:00
 | CL M3 | 21.5 | 550 | 570 | 27.9 | 29 | 0.38 | 2001-10-29 13:22:00
 | CL Z3 | 21.5 | 550 | 570 | 24.9 | 25.8 | 0.34 | 2001-10-29 13:22:00