tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: e27c0f18-30ea-40bd-bffe-df4db15d097d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
265077 | 64072 | [NAME] | Parish | USA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 01:25:45
265077 | 80001 | [NAME] | Mcguire | USA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 01:28:14
265077 | 80002 | [NAME] | [NAME] | USA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 01:37:33
265077 | 33977 | [NAME] | Sheeks | USA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | 01:25:51
265077 | 80003 | [NAME] | Bordine | USA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 5 | 01:27:24
Spreadsheet: darrell_schoolcraft__7761__imbalsumm0106
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 68110 | 67388
2 | 52575 | 52388
3 | 52618 | 52388
4 | 60235 | 59388
5 | 52944 | 52388
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
2001-05-31 00:00:00 |  |  | 93488
2001-06-05 00:00:00
Spreadsheet: a9981329-758d-4e80-9690-961bb5a04caa
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38859936 | 2013-12-06 20:02:24 | ALLIES | 0 | 4 | 6 | 532747 | Dajody | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
38860309 | 2013-12-06 20:19:37 | AXIS | 0 | 2 | 6 | 532747 | Dajody | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
38906314 | 2013-12-09 21:11:03 | AXIS | 0 | 4 | 6 | 901544 | manu76 | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
38906498 | 2013-12-09 21:22:43 | ALLIES | 1 | 6 | 5 | 901544 | manu76 | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
38906747 | 2013-12-09 21:36:38 | AXIS | 1 | 4 | 3 | 901544 | manu76 | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
38906915 | 2013-12-09 21:45:54 | ALLIES | 1 | 4 | 0 | 901544 | manu76 | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
38907077 | 2013-12-09 22:05:23 | ALLIES | 1 | 6 | 4 | 1351059 | misterfunny | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
38907375 | 2013-12-09 22:23:16 | AXIS | 1 | 6 | 5 | 1458183 | vipsd | 7669 | pacific | 1941-12-23 | 1941-12-23 | Wake Island | Ile de Wake
38907625 | 2013-12-09 22:48:00 | ALLIES | 0 | 4 | 6 | 1458183 | vipsd | 7669 | pacific | 1941-12-23 | 1941-12-23 | Wake Island | Ile de Wake
38917702 | 2013-12-10 17:45:28 | AXIS | 1 | 6 | 1 | 1234801 | GenGSP | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
38918003 | 2013-12-10 18:18:21 | ALLIES | 1 | 6 | 3 | 1234801 | GenGSP | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
Spreadsheet: 830915d1685253356-find-data-cut-average
Sheet: Sheet1

Day of the week | Type of Work | Start Time | Finish Time | Total Hours | Break | Total Breaks | Payable Hours | Hours Converted | Cutting Bonus | Gross Weight | Net Weight | Cut  Weight | Average Cut
Thursday | Did Not Work
Friday | Did Not Work
Monday | Did Not Work
Tuesday | Cutting | 11:30:00 | 15:30:00 |  | 9:00 - 9:15AM | 00:15:00 |  | 3.75 |  | 3670 | 3160
Wednesday | Cutting | 06:30:00 | 10:45:00 |  | 9:00 - 9:15AM | 00:15:00 |  | 4 |  | 2030 | 1610
Wednesday | Production | 10:45:00 | 15:30:00 |  | 11:15 - 11:45AM, 1:45 - 2:00PM | 00:45:00 |  | 4
Spreadsheet: 120223d1315100392-excel-2007-problems-sorting-data-sort-causes-the-data-to-change-baseball-stats-pivot-tables
Sheet: Hitting Stats

Hitting Stats Pivot Table
Team | A's | <<Select Team(s) Here
Row Labels | Sum of G | Sum of AB | Sum of R | Sum of H | Sum of RBI | Sum of 2B | Sum of 3B | Sum of HR | Sum of SB | Sum of BB | Sum of SO | Sum of TB | Sum of AVG | Sum of OBP | Sum of SLG | Count of AB/HR | Count of AB/SO
[NAME] | 20 | 80 | 10 | 17 | 14 | 4 | 0 | 4 | 0 | 5 | 31 | 33 | 1.062254901960784 | 1.292892156862745 | 2.057352941176471 | 5 | 5
[NAME] | 20 | 78 | 12 | 20 | 7 | 3 | 1 | 1 | 3 | 2 | 12 | 28 | 1.296813725490196 | 1.39093137254902 | 1.813480392156863 | 5 | 5
Bishop | 20 | 65 | 9 | 16 | 5 | 3 | 0 | 0 | 0 | 17 | 9 | 19 | 1.217532467532467 | 2.006617647058824 | 1.463203463203463 | 5 | 5
Buhner | 20 | 79 | 9 | 16 | 11 | 5 | 0 | 4 | 0 | 5 | 20 | 33 | 1.030322128851541 | 1.257352941176471 | 2.148949579831933 | 5 | 5
Cochrane | 20 | 89 | 19 | 29 | 14 | 10 | 0 | 2 | 0 | 7 | 14 | 45 | 1.623323013415892 | 1.870175438596491 | 2.516511867905057 | 5 | 5
Dykes | 20 | 72 | 7 | 12 | 5 | 1 | 0 | 1 | 0 | 10 | 13 | 16 | 0.856043956043956 | 1.356372549019608 | 1.122710622710623 | 5 | 5
Kluszewski | 20 | 86 | 9 | 22 | 18 | 6 | 0 | 4 | 0 | 2 | 10 | 40 | 1.286764705882353 | 1.369281045751634 | 2.331699346405229 | 5 | 5
Simmons | 20 | 86 | 17 | 33 | 19 | 15 | 1 | 4 | 0 | 6 | 10 | 62 | 1.919676642586859 | 2.125730994152047 | 3.601444788441692 | 5 | 5
Speaker | 20 | 86 | 17 | 32 | 11 | 6 | 0 | 2 | 0 | 12 | 9 | 44 | 1.846362229102167 | 2.242105263157895 | 2.561231510147919 | 5 | 5
Grand Total | 180 | 721 | 109 | 197 | 104 | 53 | 2 | 22 | 3 | 66 | 128 | 320 | 12.13909377086622 | 14.91145940832473 | 19.61658451197925 | #[NAME]! | #[NAME]!
Spreadsheet: 879674d1727249919-capture-data-from-multiple-sheets-sample-data-wk9128-
Sheet: 151-ABC

 |  |  | GAP
 |  |  | BU2424 | BU2525
PN | Supplier | Type | Total | Total
151A | 102 LLL | JJ | 100 | 50
151A | 102 LLL | JJ | 100 | 50
151A | 102 LLL | JJ | 50 | 50
151A | 102 LLL | JJ | 100 | 50
Spreadsheet: bc30c7c6-a146-48ff-bb42-cc16ff434445
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FSAI | Test | FSAI | [NAME], IgG by ELISA, Serum | [NAME], IgG | Semi-Quantitative Enzyme-Linked Immunosorbent Assay (ELISA) | Plain, Red-Top or serum gel tube: Red |  |  | 1 | mL | Draw blood in a plain, red-top tube(s). (Serum gel tube is acceptable.) Spin down and send 1 mL of serum refrigerated in a plastic vial. | 0.05 mL | Hemolysis:	Mild reject; Gross reject Thawing:	Warm reject; Cold OK Lipemia:	Mild reject; Gross reject Icterus:	Mild reject; Gross reject Other:	Bacterially contaminated, heat-inactivated | Reference Interval:           1.49 IV or less       Negative - No significant level of                                       [NAME] antibody                                       detected.           1.50 - 2.10 IV         Equivocal - Questionable presence                                       of [NAME] antibody                                       detected. Repeat testing in 10-14                                       days may be helpful.           2.11 IV or greater   Positive - IgG antibodies to                                       [NAME] detected, which may                                       suggest current or past infection.                 Test Performed By:  ARUP Laboratories                                       500 [NAME]Salt Lake City, UT  84108 | Wednesday | 1-8 days | 3-10 days | 1 | 86682 |  |  |  |  | ARUP Laboratories
FSAI | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FSAI | Result | Z2652 | [NAME], IgG | [NAME], IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 237038d1369089273-list-of-valuses-with-spaces-and-make-a-new-list-without-spaces-current-list
Sheet: Sheet1

 | Job List |  | Current Jobs List
 | IT Manager | 1
 |  | 2
 | IT Help Desk 1 | 3
 | IT Support Admin | 4
 |  | 5
 |  | 6
 | IT Help Desk 2 | 7
 | IT Help Desk 1 | 8
 |  | 9
 | IT Generalist | 10
 |  | 11
 |  | 12
 |  | 13
 | [NAME] | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20
 |  | 21
 |  | 22
 |  | 23
 |  | 24
 |  | 25
Spreadsheet: 04ea1cbf-c09b-4f28-91aa-33545988b5db
Sheet: Sheet1

Bevölkerung im [NAME] nach [NAME] (in 1 000) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
[NAME] ... bis unter ... Einwohner | 2011 | 2025 |  | Veränderung zu 2011 in %
 |  | [NAME] | [NAME] | [NAME] | [NAME]
unter 5 000 | 754267 | 648358 | 634465 | -14.041314282 | -15.883234981
5 000 - 15 000 | 914438 | 796948 | 776863 | -12.8483287 | -15.044759732
15 000 - 25 000 | 548988 | 479465 | 465189 | -12.663846932 | -15.264268071
25 000 - 50 000 | 400379 | 352190 | 340448 | -12.035846035 | -14.968567282
50 000 und mehr | 1518979 | 1500550 | 1429747 | -1.213249162 | -5.87447226
Insgesamt | 4137051 | 3777511 | 3646712 | -8.690731634 | -11.852379871
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 148850d1333576827-area-between-weird-curves-made-out-of-lines-math-problem-copy-of-area-between-lines-1
Sheet: Sheet1

 | CALCULO DE DOSIFICACION OPTIMA PARA HORMIGONES
 |  |  |  |  |  | Para curva Bolomey
 |  | Tamanho maximo del arido, D ([NAME]): |  | 50 |  | Valor "a": | 11
 |  | [NAME] (ASTM: | 2" | 1 1/2" | 1" | 3/4" | 1/2" | 3/8" | No. 4 | No. 16 | No. 50 | No. 100 | No. 200
 |  | Tamiz, d (mm): | 50 | 37.5 | 25 | 19 | 12.5 | 9.5 | 4.75 | 1.18 | 0.3 | 0.15 | 0.075
 |  | Grava Retenido Parcial (%): | 4.8 | 8.5 | 13.4 | 10.8 | 15.1 | 10.4 | 22.4 | - | - | - | 13.9
 |  | Arena Retenido Parcial (%): | - | - | - | - | - | 0 | 1.7 | 13.8 | 50.6 | 23.9 | 6.1
 | %Ret Acum. | Grava: | 4.8 | 13.3 | 26.7 | 37.5 | 52.6 | 63 | 85.4 | 0 | 0 | 0 | 99.30000000000001
 |  | Arena | 0 | 0 | 0 | 0 | 0 | 0 | 1.7 | 15.5 | 66.1 | 90 | 96.1
 | %Pasa Acum. | Grava: | 95.2 | 86.7 | 73.3 | 62.5 | 47.4 | 37 | 14.59999999999999 |  |  |  | 0.6999999999999886
 |  | Arena | 100 | 100 | 100 | 100 | 100 | 100 | 98.3 | 84.5 | 33.90000000000001 | 10 | 3.900000000000006
 |  | Comb. [NAME] (%): | 96.736 | 90.956 | 81.844 | 74.5 | 64.232 | 57.16 | 41.38399999999999 | 27.04 | 10.848 | 3.199999999999999 | 1.723999999999994
 | Porcentajes para dosificar:
 | %GRAVA: | 0.68
 | %ARENA: | 0.32 |  |  |  |  |  |  |  |  | d [NAME] (mm) | [NAME] | Fuller
 |  |  |  |  |  |  |  |  |  |  |  | y | y
 |  |  |  |  |  |  |  |  |  |  | 50 | 100 | 100
 |  |  |  |  |  |  |  |  |  |  | 37.5 | 88.07626093681503 | 86.60254037844386
 |  |  |  |  |  |  |  |  |  |  | 25 | 73.93250352560273 | 70.71067811865476
 |  |  |  |  |  |  |  |  |  |  | 19 | 65.86328462642389 | 61.64414002968977
 |  |  |  |  |  |  |  |  |  |  | 12.5 | 55.5 | 50
 |  |  |  |  |  |  |  |  |  |  | 9.5 | 49.794200597512 | 43.58898943540673
 |  |  |  |  |  |  |  |  |  |  | 4.75 | 38.43164231321195 | 30.82207001484488
 |  |  |  |  |  |  |  |  |  |  | 1.18 | 24.67243943120612 | 15.36229149573722
 |  |  |  |  |  |  |  |  |  |  | 0.3 | 17.8939103562492 | 7.745966692414834
 |  |  |  |  |  |  |  |  |  |  | 0.15 | 15.87473076179598 | 5.477225575051661
 |  |  |  |  |  |  |  |  |  |  | 0.075 | 14.4469551781246 | 3.872983346207417
Spreadsheet: 860898d1708920172-find-count-of-zeros-even-when-filter-is-on-sample-1
Sheet: Sheet1

RESULT SHOULD BE THERE
DSR Name | Retailer Name | BELIPHOOL  600ML | PCNO 100ML |  | I want to find the Count of Cells of Zero(0) and want to see the result also available in filter as well. For example If I want to filter "DSR Name(First Column), then the total count of Zeroes should be at the C1 Cell
Dibakor | Dulal Store | 0 | 6
Dibakor | [NAME] | 0 | 0
[NAME] | Alaur Store | 0 | 21
Dibakor | [NAME] | 0 | 3
Dibakor | [NAME] | 0 | 0
[NAME] | Bipul [NAME] | 1.2 | 0
[NAME] | [NAME] | 0 | 0
[NAME] | [NAME] | 0 | 15
[NAME] | [NAME] | 0 | 6
[NAME] | [NAME] | 0 | 0
Dibakor | Jan store | 0 | 0
[NAME] | [NAME] | 0 | 0
Dibakor | Ongon Cosmatic | 0 | 0
Dibakor | Modina supar store | 0 | 0
[NAME] | [NAME] | 1.4 | 12
Dibakor | Nasim Brathers | 0 | 0
Dibakor | [NAME] | 0 | 3
[NAME] | [NAME] | 0.6 | 0
[NAME] | [NAME] | 1.2 | 2
[NAME] | [NAME] | 0.6 | 0
[NAME] | [NAME] | 1.2 | 0
[NAME] | Farjana store | 0.6 | 0
Abu Sufian | [NAME] | 0 | 0
Dibakor | Hok Store | 0 | 6
Abu Sufian | Saroda vander | 2.4 | 0
Abu Sufian | [NAME] | 0 | 0
Dibakor | [NAME] | 2.4 | 0
Abu Sufian | Nahar Cosmatic | 1.2 | 12
Abu Sufian | [NAME] | 0.6 | 3
Abu Sufian | [NAME] | 0 | 0
Abu Sufian | Rukeya store-2 | 0 | 0
Abu Sufian | Das Brathers | 0 | 36
Abu Sufian | [NAME] | 2.4 | 0
[NAME] | [NAME] | 0 | 0
Abu Sufian | [NAME] | 1.2 | 12
Abu Sufian | [NAME] | 1.2 | 12
[NAME] | [NAME] | 0 | 0
Abu Sufian | [NAME] | 0 | 0
Abu Sufian | [NAME] | 2.4 | 0
[NAME] | [NAME] store | 0 | 12
Dibakor | Pranto Santo Store | 8.4 | 12
[NAME] | [NAME] trd | 0 | 0
[NAME] | Ripon store | 0 | 0
[NAME] | [NAME] | 0 | 12
Dibakor | Urmi Enterprise | 0 | 0
[NAME] | Sakib [NAME] | 1.2 | 0
[NAME] | [NAME] | 2.4 | 12
[NAME] | [NAME] | 0 | 0
Spreadsheet: 108654d1305670081-excel-2007-data-sorting-question-sort_issue
Sheet: Sheet1

ID | Size | Units | Style Totals
667981-01-1 | 2 | -1
667981-01-1 | 5 | -1
667981-01-1 | 4 | -2
667981-01-1 | 3 | -2
667981-01-1 | 1 | -1 | -7
797051-00-1 | 3 | -12 | -12
792339-07-1 | 3 | 4
792339-07-1 | 2 | 5
792339-07-1 | 5 | 1
792339-07-1 | 1 | 2
792339-07-1 | 0 | 1
792339-07-1 | 4 | 2 | 15
792426-06-1 | 0 | -1
792426-06-1 | 5 | -1
792426-06-1 | 2 | -4
792426-06-1 | 3 | -4
792426-06-1 | 4 | -2
792426-06-1 | 1 | -3 | -15
809554-04-1 | 3 | -2
809554-04-1 | 1 | -3
809554-04-1 | 4 | -1
809554-04-1 | 5 | -1
809554-04-1 | 0 | -2
809554-04-1 | 2 | -3 | -12
Spreadsheet: 775824d1649339972-trying-to-figure-out-the-formula-to-skip-over-blank-cells-but-add-last-five-and-divide-test-sheet-nw
Sheet: Scores

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Should average last five scores skipping over blanks and so on
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Would average these last five scores skipping blanks
 | 1 | 2 | 3 | 4 | 5 | 2022-05-10 00:00:00 | 2022-05-17 00:00:00 | 2022-05-24 00:00:00 | 2022-05-31 00:00:00 | 2022-06-07 00:00:00 | 2022-06-14 00:00:00 | 2022-06-21 00:00:00 | 2022-06-28 00:00:00 | 2022-07-05 00:00:00 | 2022-07-12 00:00:00 | 2022-07-19 00:00:00 | 2022-07-26 00:00:00 | 2022-08-02 00:00:00 | 2022-08-09 00:00:00 | 2022-08-16 00:00:00
Score | 48 | 46 | 40 | 41 | 39 | 32 | 32 | 32 |  | 36 |  | 55 |  | 55 | 45 |  |  | 36
Average
Nick
 | Should be 44.6, getting info from B16 Thru D16 |  |  |  |  |  |  |  |  | Should be 34.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Should be 45.4
 |  |  |  |  | Should be 43.75, getting info from B16 thru E16
 |  |  |  |  |  |  |  |  |  |  |  | Should be 37.4 |  | Should be 44.6 |  | Should be 44.6
 |  |  |  |  |  | Should be 42.8, getting info from B16 thru F16
 |  |  |  |  |  |  |  | Should be 39.6, getting info from C16 thru G16
Spreadsheet: vkaminski__40653__ROFR
Sheet: Sheet1

 |  | ROFR As a Strip of  Forward Start Options
 |  | Valuation Date |  |  | Note: All green numbers are inputs
 |  | Date for Next Bid | 2000-12-31 00:00:00 |  | Contact: [NAME] x36388
 |  | Time to Next Bid (years)
 |  | [NAME] (yerars) | 2 |  | The shipper intends to keep the capacity for
 |  | Expected No. of Renewals | 10 |  |  | years
 |  | Interest Rate | 0.06 |  | For [NAME], input a large number for
 |  | Current Rate | 0.15 |  | the expected No. of Renewals
 |  | Volatility of Best Bid | 0.1
 |  | ROFR Per Unit Capacity
Spreadsheet: 06bd093b-4a72-4ba9-a8c8-6ec04ab4fc39
Sheet: Sheet1

IRN | Organization | County | Amount of Subaward | Disbursed | Organization Type
46300 | [NAME] | Clermont | 84288.36 | 7171.9 | Public District
43588 | Bellefontaine City | Logan | 104491.36 | 71969.37 | Public District
43604 | Belpre City | Washington | 75132.36 | 46950.10000000001 | Public District
49593 | Bloom-Vernon Local | Scioto | 70809.36 | 44683.66 | Public District
43752 | Cincinnati City | [NAME] | 234934.36 | 75069.32 | Public District
43760 | Circleville City | Pickaway | 94200.36 | 66190.64 | Public District
43828 | Coshocton City | Coshocton | 84498.36 | 39406.62 | Public District
45351 | Crooksville Exempted Village | [NAME] | 73946.36 | 65377 | Public District
48843 | [NAME] | Muskingum | 86221.36 | 77652 | Public District
45377 | Georgetown Exempted Village | [NAME] | 75727.36 | 65774.73 | Public District
44321 | Marietta City | Washington | 107341.36 | 79961.99 | Public District
48850 | Maysville Local | Muskingum | 87522.36 | 78953 | Public District
51300 | Mid-East Career and Technology Centers | Muskingum | 87528.36 | 78959 | Joint Vocational School District
48777 | Morgan Local | Morgan | 86510.36 | 53764.66 | Public District
44461 | New Boston Local | Scioto | 64214.36 | 64214.36000000001 | Public District
44479 | New Lexington City | [NAME] | 90463.36 | 50617.3 | Public District
46136 | New Miami Local | Butler | 68596.36 | 63594.34 | Public District
44487 | New Philadelphia City | Tuscarawas | 107681.36 | 107681.36 | Public District
48900 | Noble Local | Noble | 74130.36 | 29361.67 | Public District
46482 | River View Local | Coshocton | 96253.36 | 8768.4 | Public District
47308 | Rolling Hills Local | Guernsey | 90009.36 | 45190.37 | Public District
49064 | Southern Local | [NAME] | 73015.36 | 18563.87 | Public District
49643 | Valley Local | Scioto | 74864.36 | 54629.71 | Public District
48884 | [NAME] | Muskingum | 85315.36 | 76746 | Public District
 |  |  | 2177695.640000001 | 1371251.37
Spreadsheet: 269399d1381154045-how-do-you-list-unique-names-when-the-criteria-is-identical-listed-names-solution
Sheet: Data

 | Name | Date | Time | Month
 | Mr A | 2013-11-04 00:00:00 | 13
 | Mr B | 2013-11-04 00:00:00 | 13
 | Mr C | 2013-11-04 00:00:00 | 13
 | Mr D | 2013-11-04 00:00:00 | 13
 | Mr E | 2013-10-24 00:00:00 | 13
 | Mr F | 2013-10-24 00:00:00 | 13
 | Mr G | 2013-10-24 00:00:00 | 13
 | Mr H | 2013-10-24 00:00:00 | 13
Spreadsheet: 162104d1339722238-having-a-row-of-information-show-if-using-a-dropdown-list-of-names-jpsprack_list-template_14jun12_01
Sheet: Staff List

Staff List |  | this sheet has been configured to show you only people who are "staff"
Name | Position | Salary | Hours per week
[NAME]
Spreadsheet: darrell_schoolcraft__7315__sharris0202wk1
Sheet: Plan vs. Forecast

Transwestern Pipeline Company
($[NAME])
Plan vs. Forecast
 |  |  | Weekly
 |  | Plan | Forecast | [NAME] |  | Comments
West Demand Revenues |  |  |  |  |  | New Contracts; Lower flow on one-part rate contracts
West Commodity Revenues |  |  |  |  |  | Lower Volumes
East Demand Revenues
East Commodity Revenues
[NAME]
[NAME] Revenues
PNR Revenues |  | 0
Revenue Variance
Fuel Price [NAME] |  |  |  |  |  | MTD index price of $2.06 vs. Plan index price of $2.54
Fuel Volume Variance-Unhedged |  |  |  |  |  | Lower retained volumes due to lower West flow
Sales Margin Variance on Unhedged
Hedging Adjustment
Plan Fuel Stretch |  |  | 0
Other Adjustment
Fuel Variance (Excludes UAF)
Monthly Stretch |  | 0 | 0
Target Adjustment |  | 0 | 0
Current Month Margin Variance
Expenses |  | -1.012
Non-Recurring |  | 0
Other |  | -0.007
Total Current Month Variance
May |  | 0 | 0
April |  | 0 | 0
March |  | 0 | 0
February |  | 0 | 0
January |  | 13.71 | 13.079
February 28, 2001 YTD
Spreadsheet: 886627d1736708182-sorting-data-from-a-dynamic-list-jeffcmusic-excel-help-tms-jeffcmusic-
Sheet: Stop List

 | Cnt | STOP NUMBER | BUS STOP NAME | ON STREET / ROAD | POINT LETTER | ROUTES | Closure Type | Stops Effected | Number of Stops | Not duplicate
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 |  |  |  | Road Name | Stops effected | Closure Type
 |  |  | 1 | STATION ROAD | 25118 | Publicity Only
 |  |  | 1 | EDGWAREBURY LANE (N AND S OF A41) | 15760 | Publicity Only
 |  |  | 1 | GLOUCESTER PLACE | 29797 | Publicity & Hood
 |  |  | 2 | EDGWARE WAY | 15758, 14702 | Publicity Only
 |  |  | 1 | EDGWARE WAY | 16105 | Publicity & Hood
Spreadsheet: 722018d1614997073-sum-cell-dependant-on-ratio-with-xlookup-and-sumif-sample
Sheet: Sheet1

Hours by Shift | 2:3 | 1:2 | 1:3
Mon-Fri (6am-8pm) | 1.5 | 0 | 15
Mon-Fri (8pm-12am) | 6.5 | 0 | 29
Saturday | 4 | 0 | 12
Sunday | 4 | 0 | 12
Public holiday | 0.9 | 0 | 4.6
Other | 0 | 0 | 7
Other2 | 0 | 0 | 0
Total:
 | 2:3 | 1:2 | 1:3
RATIO1 | Staff | Participants
1:1 | 1 | 1
1:2 | 1 | 2
1:3 | 1 | 3
1:4 | 1 | 4
1:5 | 1 | 5
1:6 | 1 | 6
1:7 | 1 | 7
1:8 | 1 | 8
1:9 | 1 | 9
1:10 | 1 | 10
1:11 | 1 | 11
1:12 | 1 | 12
1:13 | 1 | 13
1:14 | 1 | 14
1:15 | 1 | 15
1:16 | 1 | 16
1:17 | 1 | 17
1:18 | 1 | 18
1:19 | 1 | 19
1:20 | 1 | 20
2:1 | 2 | 1
2:2 | 2 | 2
2:3 | 2 | 3
2:4 | 2 | 4
2:5 | 2 | 5
2:6 | 2 | 6
2:7 | 2 | 7
2:8 | 2 | 8
2:9 | 2 | 9
2:10 | 2 | 10
2:11 | 2 | 11
2:12 | 2 | 12
2:13 | 2 | 13
2:14 | 2 | 14
2:15 | 2 | 15
2:16 | 2 | 16
2:17 | 2 | 17
2:18 | 2 | 18
2:19 | 2 | 19
2:20 | 2 | 20
3:1 | 3 | 1
3:2 | 3 | 2
3:3 | 3 | 3
3:4 | 3 | 4
3:5 | 3 | 5
3:6 | 3 | 6
3:7 | 3 | 7
3:8 | 3 | 8
3:9 | 3 | 9
3:10 | 3 | 10
3:11 | 3 | 11
3:12 | 3 | 12
3:13 | 3 | 13
3:14 | 3 | 14
3:15 | 3 | 15
3:16 | 3 | 16
3:17 | 3 | 17
3:18 | 3 | 18
3:19 | 3 | 19
3:20 | 3 | 20
4:1 | 4 | 1
4:2 | 4 | 2
4:3 | 4 | 3
4:4 | 4 | 4
4:5 | 4 | 5
4:6 | 4 | 6
4:7 | 4 | 7
4:8 | 4 | 8
4:9 | 4 | 9
4:10 | 4 | 10
4:11 | 4 | 11
4:12 | 4 | 12
4:13 | 4 | 13
4:14 | 4 | 14
4:15 | 4 | 15
4:16 | 4 | 16
4:17 | 4 | 17
4:18 | 4 | 18
4:19 | 4 | 19
4:20 | 4 | 20
5:1 | 5 | 1
5:2 | 5 | 2
5:3 | 5 | 3
5:4 | 5 | 4
5:5 | 5 | 5
5:6 | 5 | 6
5:7 | 5 | 7
5:8 | 5 | 8
5:9 | 5 | 9
5:10 | 5 | 10
5:11 | 5 | 11
5:12 | 5 | 12
5:13 | 5 | 13
5:14 | 5 | 14
5:15 | 5 | 15
5:16 | 5 | 16
5:17 | 5 | 17
5:18 | 5 | 18
5:19 | 5 | 19
5:20 | 5 | 20
6:1 | 6 | 1
6:2 | 6 | 2
6:3 | 6 | 3
6:4 | 6 | 4
6:5 | 6 | 5
6:6 | 6 | 6
6:7 | 6 | 7
6:8 | 6 | 8
6:9 | 6 | 9
6:10 | 6 | 10
6:11 | 6 | 11
6:12 | 6 | 12
6:13 | 6 | 13
6:14 | 6 | 14
6:15 | 6 | 15
6:16 | 6 | 16
6:17 | 6 | 17
6:18 | 6 | 18
6:19 | 6 | 19
6:20 | 6 | 20
Spreadsheet: 471361d1468969718-excel-calculation-problem-of-the-pi-value-nnsw-roadbase-blends-2014-15-16-1-
Sheet: Teven DGB20

Teven DGB20
 | % Passing Sieve |  |  |  |  |  |  | % Passing | Passing Specification |  | Deviation | % Retained | [NAME] |  | Deviation
Sieve mm | 20mm Roadbase | Kingsbrae Additional Clay Blend | Kingsbrae Criethons Pit | Kingsbrae Straight Blend | [NAME] | [NAME] | ROSA | Blend Result | Lower | Upper | Passing | Blend Result | Lower | Upper | Retained
26.5 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 0
19 | 100 | 100 | 96 | 100 | 99 | 100 | 100 | 99.64 | 95 | 100 | 0 | 0.3599999999999994
13.2 | 93 | 99 | 96 | 98 | 89 | 100 | 100 | 93.27 | 78 | 92 | 1.269999999999996 | 6.370000000000005 | 6 | 18 | 0
9.5 | 80 | 96 | 96 | 94 | 75 | 100 | 100 | 81.44 | 63 | 83 | 0 | 11.83 | 7 | 17 | 0
6.7 | 68 | 94 | 94 | 91 | 59 | 100 | 100 | 70.34 | 50 | 70 |  |  | 10 | 21
4.75 | 57 | 92 | 93 | 90 | 45 | 99 | 100 | 60.24 | 44 | 64 | 0 | 21.2 | 13 | 25 | 0
2.36 | 36 | 88 | 90 | 86 | 26 | 74 | 100 | 40.86 | 35 | 55 | 0 | 19.38 | 7 | 19 | 0.3800000000000026
0.425 | 13 | 30 | 46 | 30 | 8 | 25 | 100 | 15.97 | 14 | 23 | 0 | 24.89 | 14 | 30 | 0 |  | 39.08467939304943
0.075 | 6 | 10 | 11 | 10 | 3 | 10 | 100 | 6.45 | 7 | 14 | -0.5499999999999998 | 9.52 | 6 | 13 | 0 |  | 40.38822792736381 | 0.4038822792736381
0.0135 | 3.4 | 0 | 0 | 0 | 1 | 2 | 40 | 3.094 | 3 | 7 | 0 | 3.356 | 3 | 8 | 0 |  | 47.96899224806202
PI | 0 | 11 | 9 | 9 |  |  |  | 2.333124608641202 | 2 | 6 | 0
Ratio | 91 | 0 | 9 | 0 | 0 | 0 | 0 | 100
 |  | .