tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 24

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
24 | 2007-02-19 00:00:00 | 7.9 | 0.46 | 3 | 1.2 | 1.5 | 1.6 |  |  |  | 0.5 |  | 1.4638501094228 | 1 | 0 | 8 |  |  |  |  | 0.2
Well #24 | 2013-10-11 00:00:00 | 8 | 0.54 | 2.94 | 1.11 | 1.5 | 3.6 |  |  | 0.3 | 1.4 |  | 1 | 2.1 | 0.03 | 1.5 |  | <0.10 | <0.02 |  | 0.7
Well - 24 | 2014-02-04 00:00:00 | 8.2 | 0.55 | 3.07 | 1.19 | 1.6 | 3.6 |  |  | 0.4 | 1.6 |  | 1.1 | 2.3 | 0.02 | 2.5 |  | <0.10 | <0.02 |  | 0.8
Well 24 | 2015-04-02 00:00:00 | 7.8 | 0.53 | 2.96 | 1.13 | 1.5 | 3.4 |  |  | 0.3 | 1.5 |  | 1 | 2.1 | <0.05 | 1.9 |  | <0.10 | <0.02 |  | 0.4
Well 24 | 2016-04-04 00:00:00 | 8.08 | 0.599 | 3.79 | 1.43 | 1.87 | 3.385021181360403 | 3.385021181360403 | 0 | 0.331 | 2.2386 | 383.36 | 1.16 | 2.27 | 0.02 | 2.13947 | 0.007 | 0 | 0.006 | 0
W24 | 2018-05-29 00:00:00 | 7.86 | 0.441 | 2.97 | 1.13 | 1.79 |  | 3.023339461274079 | 0 | 0.264 | 0.954 | 282.24 |  |  | 0.036 | 1.307 | 0.013 | 0 | 0 | 0.001
Spreadsheet: 13014695-6181-4be5-ab29-86b95a05b8a5
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
T4 | Test | T4 | T4 (Thyroxine), Total Only, Serum | T4 (Thyroxine), Total Only, S | Immunoenzymatic Assay | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 0.6 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.6 mL | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | > or =12 months: 5.0-12.5 mcg/dL Reference values have not been established for patients that are <12 months of age. | Monday through Friday 5 a.m. - 12 a.m., Saturday 6 a.m. - 6 p.m. | Same day/1 day | 3 days | 1 | 84436 |  |  |  |  | Rochester
T4 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
T4 | Result | T4 | T4 (Thyroxine), Total Only, S | T4 (Thyroxine), Total Only, S | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 3026-2 | Thyroxine:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 721098d1614493424-sum-a-row-of-cell-and-use-mod-to-bring-to-a-single-number-kua-number
Sheet: Sheet1

 |  |  |  |  | date of [NAME] |  |  |  |  | Kua
 |  |  |  | M | 1 | 9 | 5 | 2 |  | 3
 |  |  |  |  | need a formula  that will do the following for me  using the sum and mod functions
 |  |  |  | 1 | we need to sum the toal for F5:I5 , once we get the total, we need to to using the mod bring the result to a single numbe
 |  |  |  |  |  | example | 1+9+5+2=17 using mod we get 8
 |  |  |  |  |  | if E5 = "M" we need to add in the equation 11-8 = 3 which will finally be added into K5
 |  |  |  |  |  | if [NAME]" , wethe result from the sum and mod which is 8 , we add 4   and the toal will be 12  we then use mod again to bring to a single numbe which will be 3
 |  |  |  |  |  | M | 1952 |  | 3 |  | M | 17 | 8 | 11-8 | 3
 |  |  |  |  |  | F | 1952 |  | 3 |  | F | 17 | 8 | 8+4 | 12 | 3
Spreadsheet: 709023d1608133434-sumifs-to-sum-false-values-using-find-find-sum
Sheet: Sheet1

 |  | 01 | 0
 |  | 01.01 | 0
 |  | 02 | 0
 |  | 02.01 | 0
 |  | 03 | 0
 |  | 03.01 | 0
 |  | 04 | 275
 |  | 04.01 | 0
 |  | 05 | 0
 |  | 05.01 | 0
 |  | 06 | 0
 |  | 06.01 | 0
 |  | 07 | 0
 |  | 07.01 | 0
Spreadsheet: 2c06cd12-4dba-45ba-a6f9-f0c942f253f5
Sheet: Page 9

Permit No.: |  |  | WQ0024320 |  |  | Facility Name: |  | Rockbridge Subdivision |  |  |  |  |  | County: | Wake |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 15D-SW |  | Field Name: |  | 16A |  | Field Name: |  | 16B |  | Field Name: |  | 17A
 |  |  |  |  |  | Area (acres): |  | 0.71 |  | Area (acres): |  | 0.6 |  | Area (acres): |  | 0.67 |  | Area (acres): |  | 0.27
 |  |  |  |  |  | Cover Crop: |  | N/A |  | Cover Crop: |  | N/A |  | Cover Crop: |  | Fescue |  | Cover Crop: |  | Fescue
 |  |  |  |  |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3
 |  |  |  |  |  | Annual Rate (in): |  | 48.7 |  | Annual Rate (in): |  | 37.3 |  | Annual Rate (in): |  | 23.9 |  | Annual Rate (in): |  | 23.9
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 34418d1231696404-predicting-sales-data-668019-regression
Sheet: Sheet1

 |  |  | Scale
 |  |  | 0.8290451686678102
Category | Time | Baseline | Measured (partial) | Predicted
1 | 8:00 - 9:00 | 792 | 700 | #N/A
2 | 9:00 - 10:00 | 1227 | 1000 | #N/A
3 | 10:00 - 11:00 | 1479 | 1200 | #N/A
4 | 11:00 - 12:00 | 1703 |  | 1434.866700091565
5 | 12:00 - 1:00 | 1777 |  | 1392.131953798277 | `
6 | 1:00 - 2:00 | 1510 |  | 1281.746516412543
7 | 2:00 - 3:00 | 1522 |  | 1228.407639569487
8 | 3:00 - 4:00 | 1463 |  | 1297.773586238435
9 | 4:00 - 5:00 | 1790 |  | 1464.028645249623
10 | 5:00 - 6:00 | 2032 |  | 1611.906351630578
11 | 6:00 - 7:00 | 1824 |  | 1573.170912751316
12 | 7:00 - 8:00 | 1462 |  | 1197.556840280349
 | Regression |  |  | R2
 | x6 | 0.05772739651416681 | 0.04535163311709493 | 0.9566950418384264 | 18.41003668042153 | 1092104.621640608
 | x5 | -2.577395990447634 | 1.772661391746969 | 99.43268579904496 | 5 | 49434.29502605799
 | x4 | 42.89323047595291 | 26.95232185306635 | #N/A | #N/A | #N/A
 | [NAME] | -329.3272680138558 | 200.7600515694789 | #N/A | #N/A | #N/A
 | x2 | 1145.510897673941 | 755.2144787040584 | #N/A | #N/A | #N/A
 | x | -1350.213900029604 | 1315.237930129714 | #N/A | #N/A | #N/A
 | b | 1302.507575757387 | 786.8462969161809 | #N/A | #N/A | #N/A
Spreadsheet: 767179d1644328448-adapting-formula-to-ignore-blanks-copy-of-planned-vs-actual
Sheet: AFTER

Name | Depot | StartTime | [NAME] | Trailer | LoadRef | JobLoadRef | CollRef | CollAdd1 | CollAdd4 | CollDate | DelAdd1 | DelAdd4 | DelDate | BookingTime | Pallets | Lifts |  | Matches? | Total jobs
NAMETEST1 | DEPOTTEST1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM | PM | Total matches | %
NAMETEST2 | DEPOTTEST2
NAMETEST3 | [NAME]
 | DEPOTTEST4
NAMETEST5 | DEPOTTEST5
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Daniel F Connor

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
No response
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
Agree
Explain your health care reform position, if you choose
No response
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
Although I agree with your position statement relative to Retaining New Teachers, I am troubled by the fact that you
refer to the teacher as "her" in the Issues Statement.
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
Although I agree with the Vermont-NEA position statement, I am troubled when you refer to the teacher as "she."
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 4367 Route 36. Fairfield. Vermont. 05455 | Vermont State House of Representatives | No |  | Franklin
Spreadsheet: 720765d1614278756-data-validation-restricted-to-any-date-or-a-set-of-text-phrases-data-validation-custom-formula
Sheet: Custom Data Validation

Meeting Date |  | Meeting Phrase Data Validation List |  | Desired Data Validation Drop Down Box Population
2019-02-02 00:00:00 |  | Cancelled |  | Cancelled | OR(AND(A2> 43466,A2< 45291),A2=$C$2,A2=$C$3,A2=$C$4)
Cancelled |  | Postponed |  | Postponed
TBD |  | TBD |  | TBD
2020-07-29 00:00:00 |  |  |  | 00/00/0000
Postponed
2020-10-10 00:00:00
2021-02-01 00:00:00
Postponed
Cancelled
2021-03-25 00:00:00
Spreadsheet: 71602d1272372280-dropdown-menu-inside-an-dropdownmenu-kokeilu-1
Sheet: Sheet1

 | data2 |  | data 2
 |  |  | name |  | value |  | unit
 |  |  | xxxx |  | 2 |  | s
 |  |  | xxx |  | 45 |  | mbar |  |  |  |  |  |  |  | data2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | data3
 |  |  | aaa |  | 2 |  |  |  |  |  |  |  |  |  | Table B
 | when data 2 is selected from the dropdown menu in cell B3 |  | www |  | 333 |  | deg |  |  |  |  |  |  |  | Table C
 |  |  | ggg |  | 456 |  | C |  |  |  |  |  |  |  | Table Y
 | then i would like to have a drop down menu in cell D16 |  | Table C
 |  |  |  | 0 | 36 | 56 | 68 | 568 | 568 | 568
 |  |  |  | 0 | 36 | 8 | 8 | 45 | 5 | 5
 | so that i can choose table y, table b or table c |  |  | 0 | 36 | 3 | 36 | 5 | 7 | 7
 |  |  |  | 0 | 8 | 346 | 56 | 56 | 346 | 346
 |  |  |  | 0 | 36 | 7 | 3467 | 34 | 345 | 345
 |  |  |  | 0 | 3 | 347 | 3 | 45 | 66 | 66
 |  |  |  |  | Table b
 |  |  |  |  | 15 |  | 333 | 333 | 333 | 333 | 333 | 333
 |  |  |  |  | 15 |  | 56 | 56 | 5 | 7 | 76 | 76
 |  |  |  |  | 15 |  | 4 | 46 | 5 | 5 | 7 | 7
 |  |  |  |  | 15 |  | 7 | 56 | 346 | 36 | 6 | 6
 |  |  |  |  | 15 |  | 6 | 47 | 43 | 5 | 45 | 45
 |  |  |  |  | 15 |  | 7 | 4 | 4 | 4 | 7 | 7
 |  |  |  |  | 15 |  | 2 | 6 | 4 | 64 | 7 | 7
 |  |  |  |  | table c
 |  |  |  |  | 30 |  | 250 | 250 | 250 | 250 | 250 | 250
 |  |  |  |  | 30 |  | 36 | 56 | 68 | 568 | 568 | 568
 |  |  |  |  | 30 |  | 36 | 8 | 8 | 45 | 5 | 5
 |  |  |  |  | 30 |  | 36 | 3 | 36 | 5 | 7 | 7
 |  |  |  |  | 30 |  | 8 | 346 | 56 | 56 | 346 | 346
 |  |  |  |  | 30 |  | 36 | 7 | 3467 | 34 | 345 | 345
 |  |  |  |  | 30 |  | 3 | 347 | 3 | 45 | 66 | 66
 |  |  |  |  | table y
 |  |  |  |  |  |  | 10 | 200 | 200 | 200 | 200 | 200
 |  |  |  |  |  |  | 10 | 56 | 6 | 78 | 78 | 6
 |  |  |  |  |  |  | 10 | 56 | 5 | 4 | 45 | 56
 |  |  |  |  |  |  | 10 | 5 | 5 | 56 | 86 | 6
 |  |  |  |  |  |  | 10 | 3 | 6 | 45 | 78 | 6
 |  |  |  |  |  |  | 10 | 8 | 4 | 45 | 45 | 45
 |  |  |  |  |  |  | 10 | 45 | 45 | 5 | 3 | 45
Spreadsheet: 800434d1665666036-and-if-problem-and-if-example
Sheet: Sheet1

 | More than | Less than
Target | 30 | 5
 | Days worked | Sick | Target reached "Y"
[NAME] | 63 | 4
[NAME] | 65 | 19
[NAME] | 49 | 0
[NAME] | 63 | 11
How many hit the target?
Spreadsheet: 0eb12c28-1d3f-41d7-b77d-5717f00bc9da
Sheet: Summer 2016

Hamline University [NAME] for Summer 2016
 |  | 2016-06-06 00:00:00 | 2016-06-27 00:00:00 | 2016-07-18 00:00:00 | 2016-08-08 00:00:00 | 2016-08-27 00:00:00
4 credits | 4A | 6/6-8/27 |  |  |  | End of Term | 1 start
3 credits | 3A | 6/6-8/6 |  |  |  |  | 2 starts
3 credits | 3B |  | 6/27-8/27
2 credits | 2A | 6/6-7/16 |  |  |  |  | 3 starts
2 credits | 2B |  | 6/27-8/6
2 credits | 2C |  |  | 7/18-8/27
1 credit | 1A | 6/6-6/25 |  |  |  |  | 4 starts
1 credit | 1B |  | 6/27-7/16
1 credit | 1C |  |  | 7/18-8/6
1 credit | 1D |  |  |  | 8/8-8/27
 |  | 4 starts | 3 starts | 2 starts | 1 starts |  | 10 total starts
4 credits = | 12 class sessions
3 credits = | 9 class sessions
2 credits = | 6 class sessions
1 credit = | 3 class sessions
Spreadsheet: 135340d1325955853-count-if-count-if
Sheet: Sheet1

 | sat | [NAME] | mon | tue | wed | thu | fri | sat | [NAME] | mon | tue | wed |  | Total p | total ot | total a
a | p | p | p | a | a | a | ot | ot | p | p | ot | p
b | p | p | a | p | a | p | ot | ot | p | p | ot | a
c | ot | p | ot | a | a | p | p | ot | p | p | a | a
 | p | ot | a
Spreadsheet: 759508d1639581882-sum-column-based-on-values-in-2-other-columns-audits-master
Sheet: DC 21 Audits Master

[NAME] | Errors | Cases
[NAME] |  | 144 |  |  | [NAME]
[NAME] | 1 | 182
Luc | 1 | 187
[NAME] |  | 265
[NAME] |  | 226
Brae |  | 241
[NAME] |  | 90
[NAME] | 1 | 150
[NAME] | 0 | 100
[NAME] | 0 | 80
Ry | 0 | 60
[NAME] | 1 | 40
Will | 1 | 880
Will |  | 100
Jo | 1 | 220
[NAME] | 0 | 233
[NAME] | 1 | 80
[NAME] | 1 | 232
[NAME] | 1 | 234
Will |  | 259
JR |  | 191
Ry |  | 191
Spreadsheet: 489682d1479387888-generate-vacationplan-in-excel-ferieoversikt_ikt_2016_test
Sheet: 2015 til 2020 kvartaler

 |  | 2015 |  |  |  | 2016 |  |  |  | 2017 |  |  |  | 2018 |  |  |  | 2019 |  |  |  | 2020
 |  | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4
 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Opgave | Ansvar | To | O | M | To | F | F | F | L | S | L | L | S | M | S | S | M | Ti | M | M | Ti | O | O | O | T
Spreadsheet: 749392d1632771536-lookup-all-values-less-than-amount-and-import-example
Sheet: Data

 | NAME |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % stnd |  |  |  | % on stnd
 | [NAME], [NAME] | 2020-12-15 00:00:00 | 0 |  | 0 | 0 |  | 13.09 |  | 0.96 | 10.02 |  | 0 |  | 0 | 0 |  | 6.17 |  | 0.67 | 6.15 |  | 9.57 |  | 1.39 | 10.03 |  | 0 |  | 0 | 0 |  |  |  | 124.374460742019 |  |  |  | 0.8847327906590537
 | Doe, [NAME] |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  |  |  | 97 |  |  |  | 0.55
 | [NAME], [NAME] | 2017-03-14 00:00:00 | 0 |  | 0 | 0 |  | 9.12 |  | 0.89 | 6 |  | 19.13 |  | 1.06 | 10.05 |  | 17.03 |  | 1.06 | 9.08 |  | 18.81 |  | 1.06 | 10.07 |  | 0 |  | 0 | 0 |  |  |  | 205.8785737230967 |  |  |  | 0.8843750000000001
 | [NAME] | 2018-08-27 00:00:00 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  |  |  | 42.3 |  |  |  | 0.99
 | Spears, Brittney | 2021-03-16 00:00:00 | 0 |  | 0 | 0 |  | 3.59 |  | 0.25 | 3.2 |  | 8.08 |  | 0.89 | 10.65 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  |  |  | 91.81746656176239 |  |  |  | 0.5321702573015978
 | Farm, State | 2021-08-24 00:00:00 | 0 |  | 0 | 0 |  | 5.86 |  | 0.91 | 6.33 |  | 10.65 |  | 1.47 | 8.32 |  | 8.66 |  | 1.14 | 8.42 |  | 5.58 |  | 1.89 | 8.35 |  | 7.14 |  | 0.89 | 6.37 |  |  |  | 120.323912353128 |  |  |  | 0.8334362887846948
 | Ferguson, Fergie | 2018-04-26 00:00:00 | 0 |  | 0 | 0 |  | 13.04 |  | 1.06 | 7.53 |  | 14.33 |  | 0.89 | 8.17 |  | 12.73 |  | 1.36 | 9.9 |  | 14.6 |  | 1.27 | 8.07 |  | 0 |  | 0 | 0 |  |  |  | 188.0371261601925 |  |  |  | 0.8640594230506816
 | Hall, Dope | 2020-01-28 00:00:00 | 0 |  | 0 | 0 |  | 13.41 |  | 1.32 | 10.03 |  | 9.21 |  | 0.75 | 6.02 |  | 9.38 |  | 0.89 | 9.25 |  | 8.4 |  | 0.96 | 10.02 |  | 0 |  | 0 | 0 |  |  |  | 119.5 |  |  |  | 0.8890986230382385
Spreadsheet: 857659d1706625228-vlookup-not-working-with-drop-down-list-copy-of-purchase-order-form
Sheet: FD Budget Numbers

Program | Description | Acct # |  | Program | Description | Acct #
Awards | [NAME] | 001560 - 53901 |  | Fire Prevention | Overtime | 001560 - 50020
Buildings | Buildings | 001560 - 52310 |  |  | Supplies | 001560 - 53630
 | Building Materials | 001560 - 53100 |  | Hazmat | Overtime | 001560 - 50020
 | Repairs | 001560 - 55799 |  |  | Maintenance | 001560 - 52323
Clothing | Clothing | 001560 - 53651 |  |  | Supplies | 001560 - 53630
Department - Operations | Dues | 001560 - 52013 |  | Health | Physicals | 001560 - 52150
 | Printing | 001560 - 52153 |  | Hydrants | Overtime | 001560 - 50020
 | Publications | 001560 - 52154 |  |  | Equipment | 001560 - 53630
 | Postage | 001560 - 52157 |  | Investigations | Overtime | 001560 - 50020
 | [NAME] | 001560 - 52163 |  |  | Supplies | 001560 - 53630
 | Professional Services | 001560 - 52190 |  | PPE | PPE | 001560 - 53645
 | [NAME] | 001560 - 52200 |  | Public Education | Overtime | 001560 - 50020
 | Equipment Office | 001560 - 52316 |  |  | Supplies | 001560 - 53643
 | Cellular Communication | 001560 - 52410 |  | Radios | Radios | 001560 - 52327
 | Office Supplies | 001560 - 53620 |  | Rural Signs | Supplies | 001560 - 53630
 | Admin Supplies | 001560 - 53630 |  | SCBA | Overtime | 001560 - 50020
Department - Salaries | Overtime | 001560 - 50020 |  |  | Maintenance | 001560 - 52323
 | Regular Salaries | 001560 - 50010 |  |  | Supplies | 001560 - 53630
 | ICMA Deferred | 001560 - 50027 |  | Tools | Maintenance | 001560 - 52323
 | RHS Contribution | 001560 - 50028 |  |  | Small Tools | 001560 - 53606
 | Longetivity | 001560 - 50040 |  | Training | Overtime | 001560 - 50020
 | Holiday Pay | 001560 - 50045 |  |  | Training Classes | 001560 - 52163
 | Attendance Incentive | 001560 - 50050 |  |  | Supplies | 001560 - 53795
 | Part-time Fire | 001560 - 50060 |  | TRT | Overtime | 001560 - 50020
 | Part-time Seasonal | 001560 - 50075 |  |  | Supplies | 001560 - 53630
 | Health Insurance | 001560 - 51129 |  | Vehicles | Maintenance | 001560 - 52333
 | IMRF | 001560 - 51140 |  |  | Equipment | 001560 - 52323
 | Fire Pension | 001560 - 51142 |  | Water Rescue | Equipment | 001560 - 53630
 | FICA | 001560 - 51160 |  |  | Overtime | 001560 - 20020
 | Medicare | 001560 - 51165
Drone | Overtime | 001560 - 50020 |  | Capital | Vehicles | 235560 - 55745
 | Supplies | 001560 - 53630 |  |  | Equipment | 235560 - 55750
EMS | Overtime | 001560 - 50020
 | Medical Supplies | 001560 - 53796
 | CPR Supplies | 001560 - 53790
 | EMS Meetings | 001560 - 52163
 | Med - Help | 001560 - 53610
 | [NAME] | 001560 - 53900
Spreadsheet: 148391d1333383987-excel-2007-vlookup-match-return-3rd-column-data-set-postal-match
Sheet: Postal codes

Zip | City | State | County | Latitude | Longitude
501 | HOLTSVILLE | NY | SUFFOLK | 40.922326 | -72.637078
544 | HOLTSVILLE | NY | SUFFOLK | 40.922326 | -72.637078
70555 | MAURICE | LA | VERMILION | 30.074655 | -92.147849
70556 | MERMENTAU | LA | ACADIA | 30.186145 | -92.572176
70558 | MILTON | LA | LAFAYETTE | 30.098819 | -92.064797
70559 | MORSE | LA | ACADIA | 30.129756 | -92.476684
92427 | SAN BERNARDINO | CA | SAN BERNARDINO | 34.262243 | -116.861506
92501 | RIVERSIDE | CA | RIVERSIDE | 33.752886 | -116.055617
19736 | YORKLYN | DE | NEW CASTLE | 39.797126 | -75.660413
19801 | WILMINGTON | DE | NEW CASTLE | 39.727113 | -75.547844
Spreadsheet: 863263d1710828441-formulas-for-golf-tournament-assigning-in-separate-cell-and-listing-multiple-names-team-game-scenarios
Sheet: Sheet1

[NAME] | -4 |  | [NAME]
[NAME] | 3 |  | [NAME] |  |  | In this scenario, I need  the number 25 to fill into column E for every player except for the (3) highest scores (which would be Zach, [NAME], [NAME] and [NAME]). The (3) highest scores only get the number 10. Since [NAME] and [NAME] both tied for the 3rd highest score, is there a way to give them each the number 17 or 18 which would be 25+10/2?
[NAME] | 5 |  | [NAME]
[NAME] | 5 |  | [NAME]
[NAME] | 5 |  | [NAME]
[NAME] | 5 |  | [NAME]
Jake | 6 |  | Jake
[NAME] | 5 |  | [NAME]
[NAME] | 5 |  | [NAME]
Mark | 7 |  | Mark
[NAME] | 7 |  | [NAME]
Pablo | -6 |  | Pablo
[NAME] | 0 |  | [NAME]
[NAME] | 3 |  | [NAME]
Zach | 6 |  | Zach
 | Hole 1 | Hole 2 | Hole 3
[NAME] | 3 | 6 | 5 |  | Hole 1 |  |  | In this scenario, I would like to list each player that shot the lowest score for each hole. So for Hole 1, it would show [NAME], [NAME], [NAME] in cell G21. For Hole 2, it would show, [NAME], [NAME], [NAME], [NAME], Zach in cell G22, etc. Is there a way for a cell to show "..."  or something similar if the amount of players is too long to fit in the cell? So let's say Hole 1 has 10 guys tie for the lowest score. If only 5 names can fit, can it show the first five names and then show "..." to indicate there are more names than what are shown?
[NAME] | 3 | 5 | 6 |  | Hole 2
[NAME] | 3 | 5 | 8 |  | Hole 3
[NAME] | 3 | 4 | 9
[NAME] | 3 | 5 | 7 |  | Full formula
[NAME] | 6 | 6 | 6 |  | Using LET
Jake | 3 | 5 | 5
[NAME] | 5 | 6 | 6
[NAME] | 6 | 4 | 6
Mark | 4 | 4 | 8
[NAME] | 3 | 5 | 5
Pablo | 5 | 6 | 5
[NAME] | 4 | 7 | 5
[NAME] | 4 | 4 | 5
Zach | 8 | 4 | 9
Spreadsheet: 01baeff2-0577-40b4-918d-01cad6b77db1
Sheet: External Payment Request Electr

 |  |  | PeopleSoft Financials
 |  |  | University of Southern Queensland
 |  | Transactional Payment Request
 |  |  | Please forward to Central Procurement - Financial & Business Services |  |  |  |  |  |  |  | Version 2.1
 |  |  |  |  |  |  |  |  |  |  | Jan 2012
Mandatory Fields |  |  | Dept Name:
 |  |  | Contact Name:
 |  |  | Tel: |  |  |  |  |  | Date:
Is this to be paid by MasterCard: |  | Yes or No? |  | Comments:
*** If no - check vendor details on PeopleSoft & submit a Vendor Change Form or New Vendor Form if applicable.
ABN: |  |  |  | REMIT CHEQUE TO:   If different to Vendor(support in writing)
Vendor Number: (Mandatory for non Credit Card payments only)
[NAME] (in full):                     Mandatory Field
Vendor:  Current Postal
Address
(For International Vendors - Street Address required in addition to a PO address)
City and State
Country & Post or Zip Code
Malaysia: Vendor National or Passport ID Number
ATTACH:  Supporting Documentation |  |  | Incomplete forms can cause a delay in payment
Description |  |  | GST Exclusive Amount | GST Amount (10%) | Gross Amount | BU | Account | FD | Dept ID | Prog | Project
 |  |  | 0 | 0 |  | USQ10 |  | 2
 |  |  | 0 | 0 |  | USQ10 |  | 2
 |  |  | 0 | 0 |  | USQ10 |  | 2
 |  |  | 0 | 0 |  | USQ10 |  | 2
 |  |  | 0 | 0 |  | USQ10 |  | 2
 |  |  | 0 | 0 |  | USQ10 |  | 2
 |  |  | 0 | 0 |  | USQ10 |  | 2
 |  |  | 0 | 0 |  | USQ10 |  | 2
 |  |  | 0 | 0 |  | USQ10 |  | 2
 |  |  | 0 | 0 |  | USQ10 |  | 2
 |  |  | 0 | 0 |  | USQ10 |  | 2
GST Exclusive Total -
GST Costed to General Ledger - |  |  |  |  |  | USQ10 | 63001 | 2 | 7680 | 70
GST Inclusive Total for Reimbursement -
Please remember to split GST and Non GST Transactions for mixed supplies
 |  |  |  | Procurement use only:
I certify that the payment detailed herein is necessary for the proper operation of the University, that this expenditure is within my level of Financial delegated authority, and hereby authorise this expenditure. |  |  |  |  |  |  | Examples of items that can be paid by Transactional Payment request are:
 |  |  |  |  |  |  | Utilities, memberships etc;
________________________________         /     / |  |  |  |  |  |  | Library vouchers;
Signature |  |  |  |  |  |  | Commissions
________________________________
Authorising Officer        (Please Print) |  |  |  |  |  |  | Refer
(Financial Delegate) |  |  |  |  |  |  | USQ Procurement and Purchasing policy
Please forward completed form to Central Procurement - Financial & Business Services for approval |  |  |  | Procurement Stamp & Initial |  |  | Section 3.26.2 for further details.
Spreadsheet: 76161d1276705335-putting-cells-within-a-picture-analysis-of-football
Sheet: INDIVIDUALS

 | PIERDA EL BALON |  |  | GANA EL BALON
JOEL | 1 |  | JOEL | 0
[NAME] | 0 |  | [NAME] | 0
NACHO | 0 |  | NACHO | 0
JAVI REY | 0 |  | JAVI REY | 0
PORTU | 1 |  | PORTU | 2
[NAME] | 2 |  | [NAME] | 0
XISCO | 1 |  | XISCO | 2
CIFO | 2 |  | CIFO | 0
IVAN | 1 |  | IVAN | 2
[NAME] | 1 |  | [NAME] | 0