tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: errol_mclaughlin_jr__10324__Settles
Sheet: settles

 |  |  |  |  | NYMEX FUTURES
 |  |  |  |  | Settlement Prices
 |  |  |  |  | Month | NX1 | NX2 | NX3 | NXB2 | [NAME]
 |  |  |  |  | 1998-01-01 00:00:00 | 2.309 | 2.281 | 2.269 | 2.252 | 2.246
 |  |  |  |  | 1998-02-01 00:00:00 | 2.001 | 2.022 | 2.036 | 2.042 | 2.064
 |  |  |  |  | 1998-03-01 00:00:00 | 2.286 | 2.251 | 2.227 | 2.216 | 2.179
 |  |  |  |  | 1998-04-01 00:00:00 | 2.3 | 2.319 | 2.334 | 2.338 | 2.365
 |  |  |  |  | 1998-05-01 00:00:00 | 2.262 | 2.264 | 2.29 | 2.266 | 2.342
 |  |  |  |  | 1998-06-01 00:00:00 | 2.017 | 2.056 | 2.069 | 2.095 | 2.094
 |  |  |  |  | 1998-07-01 00:00:00 | 2.358 | 2.361 | 2.353 | 2.364 | 2.336
 |  |  |  |  | 1998-08-01 00:00:00 | 1.942 | 1.947 | 1.953 | 1.952 | 1.965
 |  |  |  |  | 1998-09-01 00:00:00 | 1.672 | 1.717 | 1.754 | 1.762 | 1.828
 |  |  |  |  | 1998-10-01 00:00:00 | 2.031 | 2.106 | 2.13 | 2.181 | 2.179
 |  |  |  |  | 1998-11-01 00:00:00 | 1.972 | 2.04 | 2.126 | 2.108 | 2.298
 |  |  |  |  | 1998-12-01 00:00:00 | 2.149 | 2.123 | 2.136 | 2.097 | 2.163
 |  |  |  |  | 1999-01-01 00:00:00 | 1.765 | 1.7765 | 1.8113 | 1.788 | 1.881
 |  |  |  |  | 1999-02-01 00:00:00 | 1.81 | 1.762 | 1.746 | 1.714 | 1.714
 |  |  |  |  | 1999-03-01 00:00:00 | 1.666 | 1.688 | 1.6933 | 1.71 | 1.704
 |  |  |  |  | 1999-04-01 00:00:00 | 1.852 | 1.853 | 1.847 | 1.854 | 1.835
 |  |  |  |  | 1999-05-01 00:00:00 | 2.348 | 2.339 | 2.326 | 2.331 | 2.299
 |  |  |  |  | 1999-06-01 00:00:00 | 2.226 | 2.213 | 2.2006 | 2.2 | 2.176
 |  |  |  |  | 1999-07-01 00:00:00 | 2.262 | 2.26 | 2.272 | 2.258 | 2.295
 |  |  |  |  | 1999-08-01 00:00:00 | 2.601 | 2.588 | 2.572 | 2.574 | 2.542
 |  |  |  |  | 1999-09-01 00:00:00 | 2.912 | 2.93 | 2.963 | 2.948 | 3.03
 |  |  |  |  | 1999-10-01 00:00:00 | 2.56 | 2.596 | 2.607 | 2.632 | 2.63
 |  |  |  |  | 1999-11-01 00:00:00 | 3.092 | 3.052 | 3.04 | 3.011 | 3.016
 |  |  |  |  | 1999-12-01 00:00:00 | 2.12 | 2.155 | 2.169 | 2.189 | 2.197
 |  |  |  |  | 2000-01-01 00:00:00 | 2.344 |  |  | 2.2271 | 2.399
 |  |  |  |  | 2000-02-01 00:00:00 | 2.61 |  |  | 2.523 | 2.616
 |  |  |  |  | 2000-03-01 00:00:00 | 2.603 |  |  | 2.549 | 2.53
 |  |  |  |  | 2000-04-01 00:00:00 | 2.9 |  |  | 2.963 | 2.914
 |  |  |  |  | 2000-05-01 00:00:00 | 3.089 |  |  | 3.11 | 3.137
 |  |  |  |  | 2000-06-01 00:00:00 | 4.406 |  |  | 4.236 | 4.073
 |  |  |  |  | 2000-07-01 00:00:00 | 4.369 |  |  | 4.686 | 4.56
 |  |  |  |  | 2000-08-01 00:00:00 | 3.82 |  |  | 3.763 | 3.66
 |  |  |  |  | 2000-09-01 00:00:00 | 4.618 |  |  | 4.685 | 4.628
 |  |  |  |  | 2000-10-01 00:00:00 | 5.312 |  |  | 5.324 | 5.276
 |  |  |  |  | 2000-11-01 00:00:00 | 4.541 |  |  | 4.664 | 4.659
 |  |  |  |  | 2000-12-01 00:00:00 | 6.016 |  |  | 6.368 | 6.5577
 |  |  |  |  | 2001-01-01 00:00:00 | 9.98 |  |  | 9.805 | 9.579
 |  |  |  |  | 2001-02-01 00:00:00 | 6.293 |  |  | 7.256 | 7.27
 |  |  |  |  | 2001-03-01 00:00:00 | 4.998 |  |  | 5.131 | 5.142
 |  |  |  |  | 2001-04-01 00:00:00 | 5.384 |  |  | 5.621 | 5.322
 |  |  |  |  | 2001-05-01 00:00:00 | 4.891 |  |  | 4.981 | 5.078
Spreadsheet: 866500d1713432520-a-formula-to-select-the-highest-cell-in-a-column-that-then-shows-the-entire-row-walks
Sheet: Will

 | # | Date | Name | Distance in        Miles | Total Elevation in Feet | Total Time HH:MM | Moving Time HH:MM | Stoped Time HH:MM | Avarage Speed MPH | Average Moving Speed MPH
 |  |  | 2017
 | 1 | 2017-09-10 00:00:00 | Scaffal Pike | 6.6 | 3136 |  | 04:46:00 | 01:59:00
 |  | 2017-09-24 00:00:00 | Brecon Beacon - Pen Y Fan | 9.5 | 2597 |  | 04:57:00 | 01:13:00
 |  | 2017-10-08 00:00:00 | Buckland Dinham Walk | 7.5 | 650 |  | 03:34:00 | 02:14:00
 |  |  | 2018
 |  | 2020-12-13 00:00:00 | Pen Y Fan - Brecon Beacons | 11.3 | 4344 |  | 06:43:00 | 01:57:00
 |  | 2018-02-10 00:00:00 | [NAME] Gorge | 11.5 | 1726 |  | 04:59:00 | 01:23:00
 |  | 2018-05-19 00:00:00 | Falls of Foyers | 3.5 | 703 |  | 01:36:00 | 00:23:00
 |  | 2018-05-20 00:00:00 | [NAME] | 10.7 | 4447 |  | 06:55:00 | 02:48:00
 |  | 2018-08-05 00:00:00 | Westbury White Horse | 7.2 | 790 |  | 02:51:00 | 00:47:00
 |  | 2018-09-23 00:00:00 | [NAME] Circles - Priddy Nine Barrows | 8.4 | 923 |  | 03:33:00 | 00:34:00
 |  | 2018-09-30 00:00:00 | [NAME] to Cloverly (SWCP) | 6.5 | 1190 |  | 02:49:00 | 01:34:00
 |  | 2018-10-07 00:00:00 | [NAME] | 6.7 | 1391 |  | 02:42:00 | 00:42:00
 |  | 2018-10-14 00:00:00 | Pontneddfechan Waterfall Walk | 12.1 | 1991 |  | 05:09:00 | 02:39:00
 |  | 2018-11-18 00:00:00 | [NAME] to Twmbarlwm | 8.9 | 1924 |  | 03:51:00 | 01:32:00
 |  | 2018-12-30 00:00:00 | Pontneddfechan Waterfall Walk | 11.3 | 1887 |  | 05:48:00 | 01:53:00
 |  |  | 2019
 |  | 2019-04-28 00:00:00 | Farrington Gurney - Litton Lake - Litton and Back | 8 | 626 |  | 03:19:00 | 00:52:00
 |  | 2019-06-09 00:00:00 | Northern Ireland - Slieve Donard & Slieve Commedagh. (Neil / Will) | 9.2 | 3245 |  | 04:47:00 | 02:30:00
 |  | 2019-06-23 00:00:00 | [NAME] Hike | 11.6 | 2439 |  | 05:02:00 | 01:21:00
 |  | 2019-07-22 00:00:00 | Yorkshire Three Peaks | 24.2 | 5345 | 08:43:00 | 07:47:00 | 01:56:00
 |  | 2019-07-28 00:00:00 | [NAME], Wreckage of Wellington Bomber | 10.1 | 2831 |  | 04:41:00 | 01:26:00
 |  | 2019-08-11 00:00:00 | Avon Three Peaks | 17 | 2451 |  | 05:59:00 | 00:51:00
 |  | 2019-08-18 00:00:00 | [NAME] | 8.5 | 899 |  | 03:18:00 | 00:58:00
 |  | 2019-08-25 00:00:00 | Pensford, Hunstrete, Stanton Wick Circular Hike | 10.3 | 1149 |  | 03:24:00 | 01:31:00
 |  | 2019-09-01 00:00:00 | Axbridge Reservoir - Crook Peak | 10.4 | 1781 |  | 03:22:00 | 01:48:00
 |  | 2019-09-20 00:00:00 | [NAME] | 8.8 | 2883 |  | 03:16:00 | 01:44:00
 |  | 2018-10-06 00:00:00 | Pensford to [NAME] and Back | 11.1 | 831 |  | 03:28:00 | 01:24:00
 |  | 2019-10-27 00:00:00 | Downside - Masbury - Nettlebridge - Beacon Hill | 11 | 1496 |  | 04:40:00 | 01:11:00
 |  | 24/11/1019 | Wells to Glastonbury | 10.6 | 790 |  | 02:58:00 | 00:54:00
 |  |  | 2020
 |  | 2020-02-12 00:00:00 | Around Blagdon Lake | 6.8 | 810 |  | 02:45:00 | 00:33:00
 |  | 2020-08-02 00:00:00 | [NAME] | 14.5 | 3832 |  | 07:04:00 | 02:24:00
 |  | 2020-08-16 00:00:00 | Burrington Hike | 8.1 | 1504 |  | 02:49:00 | 00:15:00
 |  |  | 2021
 |  |  | 2022
Spreadsheet: 199745d1355316604-formula-required-for-summary-attendance-2012
Sheet: Summary

Sr. | CodeNo | NAME |  | Toal DaysDays | Present | Absent | [NAME] | Annual Leave | Half Day | Net Present
1 | E001 | Employee1
2 | E002 | Employee2
3 | E003 | Employee3
4 | E004 | Employee4
5 | E005 | Employee5
6 | E006 | Employee6
7 | E007 | Employee7
8 | E008 | Employee8
9 | E009 | Employee9
10 | E010 | Employee10
11 | E011 | Employee11
12 | E012 | Employee12
Spreadsheet: 879470d1727018923-help-with-formula-based-on-variables-test-sheet
Sheet: Sheet1

 |  |  |  | Efficiency
emp # | employee | hours | inspections % | Week 1 | Week 2 | Week 3 | Week 4
1 | [NAME] | 160 | 100 | 1.01 | 0.98 | 1.08 | 0.75
2 | [NAME] | 130 | 75 | 0.84 | 0.98 | 0.65 | 0.82
3 | Ray
4 | [NAME]
5 | [NAME]
6 | [NAME]
7 | [NAME]
8 | [NAME]
9 | Jenni
10 | Molly
 | Totals
 | Total Flagged Hours |  |  | Hours Bonus |  |  | 290 | Total hours * 1.0(range of 145-154.9 ave hours)
 | Averaage Flagged Hours |  |  | inspection Bonus |  |  | 43.75 | Inspection % * Inspection multiplier
 | Average Efficiency |  |  | Efficiency Bonus |  |  | 145 | efficency tier * total hours
 |  | inspection Multiplier |  |  | efficency tier |  | total ave hrs
 |  | 90-100 | 0.75 |  | >100% | 1 | >155 | 1.25
 |  | 80-89.9 | 0.5 |  | 90-99.9 | 0.75 | 145-154.9 | 1
 |  | 79.9 | 0.25 |  | 80-89.9 | 0.5 | 135 -144.9 | 0.75
 |  |  |  |  | 70-79.9 | 0.25 | 125-134.9 | 0.5
 |  |  |  |  |  |  | 124 | 0.25
Spreadsheet: 868863d1715596750-indirect-function-within-sumifs-to-sum-column-based-on-matching-criteria-test-document-2
Sheet: Sheet1

Store code | Store Description | Product Code (Bundle) | Bundle Description | Device | Device Product code | Device Family | Brand | Bundle stock in store | Days cover | Bundle stock in transit | Days cover | Device average weekly sales | [NAME] fill | Device Forward forecast | Attach rate
 |  |  |  | Apples | 300025684 |  | Green
 |  |  |  | Bananas | 300026129 |  | Yellow
 |  |  |  | Strawberries | 300027564 |  | Red
Spreadsheet: 859793d1708041587-count-of-items-sold-based-on-changing-date-range-countif-calculations-example
Sheet: Calculations

 |  |  | Product | Total Sales since 9/5/23  (Countif) | Total Sales (90 Days)
 |  |  | Poly Voyager 8200 UC Bluetooth Wireless Stereo Headset - USB |  | 49
 |  |  | Jabra Evolve 20SE MS Stereo On-Ear Headset - USB Wired - 499 |  | 74
 |  |  | Jabra Evolve 40 MS Stereo - Headset - On-Ear - Wired - 6399- |  | 74
 |  |  | Jabra Evolve 75e UC Professional UC Wireless Earbuds w/Mic - |  | 34
 |  |  | Jabra Evolve 75 MS Stereo Wireless Bluetooth Headset - 7599- |  | 23
 |  |  | Logitech M510 [NAME] Type A - 2.4 GHz - |  | 50
 |  |  | Logitech M525 Wireless Optical Mouse - USB Type A - 2.4 GHz |  | 45
 |  |  | Kingston DataTraveler SE9 G2 - USB flash drive - 64 GB |  | 2
 |  |  | 128GB DataTraveler Exodia |  | 20
 |  |  | USB TYPE C TO USB C-CABLE 3.1 5A M/M 6FT |  | 26
Spreadsheet: bee0e9cc-4051-4b7d-883b-e842c05254ab
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
AMYKM | Test | AMYKM | Amyloidosis, Transthyretin-Associated Familial, Known Mutation | Familial Amyloidosis Known Mutation | Polymerase Chain Reaction (PCR) Amplification/DNA Sequencing (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | VACUTAINER: VAC |  |  | 3 | mL | This test can only be performed if a mutation has previously been identified in a family member of this individual.   [NAME] must arrive within 96 hours of draw.   Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 3 mL Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms: 1. Molecular Genetics-Congenital Inherited Diseases Patient Information Sheet (Supply T521) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 3. If not ordering electronically, submit a Molecular Genetics Request Form (Supply T245) with the specimen. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Thursday; 10 a.m. | 10 days | 16 days | 1 | 81403 |  |  |  |  | Rochester
AMYKM | [NAME] | VARIES | Varies |  |  |  | Ambient
AMYKM | Result | 22766 | [NAME] | [NAME] | Alphanumeric
AMYKM | Result | 22767 | [NAME] | [NAME] | Alphanumeric
AMYKM | Result | 22768 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
AMYKM | Result | 22769 | Order Date | Order Date | Alphanumeric
AMYKM | Result | 22770 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
AMYKM | Result | 22771 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9
AMYKM | Result | 22772 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
AMYKM | Result | 22773 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9 | Service comment 01:Imp:Pt:[NAME]:Nom:
AMYKM | Result | 22774 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
AMYKM | Result | 22775 | Reviewed By: | Reviewed By: | Alphanumeric
AMYKM | Result | 22776 | Release Date | Release Date | Alphanumeric
Spreadsheet: 288408d1389187544-complex-dropwons-lists-need-help-example-sheet-1-
Sheet: DROP DOWN SHEET

CITY | # | [NAME] | VALUE | TOTAL VALUE
SPLIT | 2 | Here I would like to choose from dropdown list any of expense type from DATA SHEET ( example: Total trip cost) | Here I would like to make a dropdown list where I can choose just value for total trip cost for city of Split.
[NAME] | 1 | Total trip cost
RIJEKA | 1 | Prize promo tour cost
ZAGREB | 2 | court renting cost
[NAME] | 3 | Prize IPP Cost
Spreadsheet: 732232d1620831094-returning-unique-value-with-multiple-criteria-returning-unique-value-with-multiple-criteria-v2
Sheet: EMPLOYEES PER YEAR

2020 |  |  |  |  |  | CREW | ='TIMECARD DATA'!$A$2:INDEX('TIMECARD DATA'!$A:$A,MATCH("zzzz",'TIMECARD DATA'!$A:$A,1))
CREW | Full Time Employees | By [NAME] |  |  |  | DATE | ='TIMECARD DATA'!$C$2:INDEX('TIMECARD DATA'!$C:$C,MATCH(25^25,'TIMECARD DATA'!$C:$C,1))
ABC |  |  |  |  |  | PERSON | ='TIMECARD DATA'!$B$2:INDEX('TIMECARD DATA'!$B:$B,[NAME]))
DEF
GHI
JKL
2019
CREW | Full Time Employees
ABC
DEF
GHI
JKL
2018
CREW | Full Time Employees
ABC
DEF
GHI
JKL
2017
CREW | Full Time Employees
ABC
DEF
GHI
JKL
Spreadsheet: 42991d1241610786-formatting-of-graphs-dependending-on-input-given-color
Sheet: Sheet1

name | quality | <100 | >=100 | >=150 | >=200
a | 10
b | 150 | orange | orange | orange | orange
c | 100 | red | red | red | red
d | 150 | orange | orange | orange | orange
e | 200 | Green | Green | Green | Green
f | 15
 |  |  |  |  | Is it possible to create a bar graph and have the bar change colour depending on the values inputed?
 |  | 0
 |  |  |  |  | For example: If i have sales of 100 the bar on the graph should show red in colour, if i have sales of 150 the bar should show orange in colour and if i have sales of 200 the bar should show green in colour
Spreadsheet: 51636d1251277494-building-a-union-over-multiple-sheets-book3
Sheet: Sheet3

a | a | a |  | Need this pasted in:
a | a | a |  |  |  |  | a | a | a
a | a | a |  |  |  |  | a | a | a
a | a | a |  |  |  |  | a | a | a
a | a | a |  |  |  |  | a | a | a
b | b | b |  |  |  |  | a | a | a
b | b | b |  |  |  |  | b | b | b
 |  |  |  |  |  |  | b | b | b
Spreadsheet: 719359d1613647556-reference-a-column-within-a-named-range-data-sheet
Sheet: new data

identifier | post | THIS IS WORKING - because I am went to the column directly to reference it (,'other data'!A:A)
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
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Spreadsheet: 81542d1281689171-calculations-based-on-drop-down-list-option-payment
Sheet: Sheet1

 | Company Name | Contract Amount | Profit | Discount Applied? | Sold | Payment Terms | Payment Amount | Renewal Reminder
1 | Customer Name | 10000 | 5000 | Yes | 2010-05-01 00:00:00 | Paid In-Full |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | 2010-05-01 00:00:00 | 2011-05-01 00:00:00 | 12
2 | Customer Name | 2000 | 1000 | Yes | 2010-05-01 00:00:00 | Monthly |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Paid In-Full | Yes | 2010-01-01 00:00:00 | 2011-01-01 00:00:00 | 1
3 | Customer Name | 600 | 600 | No | 2010-02-01 00:00:00 | Paid In-Full |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Quarterly | No | 2010-02-01 00:00:00 | 2011-02-01 00:00:00 | 4
4 | Customer Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-09-01 00:00:00 | 2011-09-01 00:00:00
 | What I am trying to achieve is when the payment term in selected from the drop down list it automatically divieds the amount in column C i.e. C2 by 12 if Monthly,
 | by 4 if Quarterly or just display the whole amount if Paid In-Full is selected
Spreadsheet: 45328d1244090909-nesting-vlookup-in-if-vice-versa-and-pivot-table-copy-of-sample-model-cat1-cat2-ytd
Sheet: Mar Cat1

Model | Amount-Cat1
500 | 999
900 | 0
AB | 0
AG | 0
AN | 0
BX | 0
BZ | 0
CA | 0
CB | 0
DE | 0
DV | 0
DX | 0
MF | 0
MR | 0
OA | 0
OB | 0
OR | 0
RA | 0
RF | 0
TM | 0
ZP | 0
Grand Total | 999
Spreadsheet: michelle_cash__26479__EnronOnline Developers
Sheet: Sheet2

EnronOnline
 | AVADHANI, KOMALI | Former Employee
 | AMAN, AMANULLAH | Current Employee
 | BAEHR, KEVIN P | Current Employee
 | BATRAK, HENNADIY | Current Employee
 | BELMONT, [NAME] | Current Employee
 | BROWN, ANDREW I | Former Employee
 | BURRA, RAGHU R | Current Employee
 | CAMPBELL, [NAME] | Former Employee
 | CHILLAKURU, SIREESHA | Current Employee
 | [NAME], PAUL E | Former Employee
 | CUMMINS, DOUGLAS | Current Employee
 | DHANSINGHANI, AJIT G | Current Employee
 | DINH, THUY-TIEN T | Current Employee
 | DUA, JATINDER | Current Employee
 | [NAME], LISA | Current Employee
 | FUNK, CHRISTOPHER A | Former Employee
 | GADHAVI, VIJAYANAND | Current Employee
 | GUADARRAMA, [NAME] | Current Employee
 | GUILLEN, FRANCESC | Former Employee
 | JENSON, JAROD M | Current Employee
 | KANDAVELU, SHIVSHANKAR | Current Employee
 | KAPOOR, SUMANT | Former Employee
 | KEARTON, PETER | Former Employee
 | KINKEAD, MARK O | Current Employee
 | KWAN, CONNIE | Former Employee
 | LEE, YUAN | Former Employee
 | MA, HUA | Former Employee
 | MANDADI, TILAK | Former Employee
 | MONTAGNE, KEVIN A | Current Employee
 | MOTUZKO, PYLYP G | Current Employee
 | NIETEN, [NAME] | Former Employee
 | PADAVALA, [NAME] | Current Employee
 | RAMSAY, STACEY C | Current Employee
 | SCHWEIGART, [NAME] | Former Employee
 | SINDWANI, AJAY | Current Employee
 | SINHA, SUVINAY K | Current Employee
 | SORKINA, VICTORIA | Current Employee
 | THOMAS, TONY C | Current Employee
 | VARGHESE, RENNU G | Current Employee
 | WEBB, [NAME] | Current Employee
 | YANG, QING | Former Employee
 | ZHANG, PING | Former Employee
 | ZHANG, WENXIA | Current Employee
 | Valtech | approx 15 consultants
 |  | from Dec 1999 to Jun 2001
 | Agency.com | approx 20 consultants
 | (none of this code is still in use) | from May 1999 to Jan 2000
Spreadsheet: 775955d1649411741-summary-of-appointments-in-date-and-time-order-pq-summary-list-sorted-aligw
Sheet: Sample data

Surname | First Name | Workplace | Shift | Last audio | Next audio | Last spiro | Next Spiro | Last Skin | Next Skin | Last HAVS | Next HAVS | 2022 Appt | Time
Bloggs | Connor | 5 | Purple | 1900-01-01 00:00:00 |  |  |  |  |  |  |  | 2022-04-20 00:00:00 | 12:30:00
[NAME] | [NAME] | 3 | Orange | 1900-01-01 00:00:00 |  |  |  |  |  |  |  | 2022-04-22 00:00:00 | 09:00:00
Edwards | Kristy | 4 | Purple | 2015-09-01 00:00:00 | 2018-09-01 00:00:00 | 2020-07-30 00:00:00 | 2021-01-30 00:00:00 | 2021-09-27 00:00:00 | 2022-09-26 00:00:00 | 2021-09-27 00:00:00 |  | 2022-04-20 00:00:00 | 13:30:00
[NAME] | Martin | 1 | Purple | 2019-09-04 00:00:00 | 2020-09-04 00:00:00 | 2021-06-01 00:00:00 | 2022-06-01 00:00:00 | 2021-06-01 00:00:00 | 2022-06-01 00:00:00 | 2021-06-01 00:00:00 |  | 2022-04-21 00:00:00 | 12:30:00
Smith | [NAME] | 1 | Green | 2019-11-22 00:00:00 | 2020-11-22 00:00:00 | 2019-11-22 00:00:00 | 2020-01-08 00:00:00 | 2019-11-22 00:00:00 | 2020-11-21 00:00:00 |  |  | 2022-04-19 00:00:00 | 14:30:00
Jones | [NAME] | 1 | Yellow | 2020-02-25 00:00:00 | 2021-02-25 00:00:00 | 2020-02-25 00:00:00 | 2021-02-25 00:00:00 | 2021-09-16 00:00:00 | 2022-09-15 00:00:00 | 2021-09-16 00:00:00 |  | 2022-04-19 00:00:00 | 12:30:00
[NAME] | [NAME] | 2 | Yellow | 2020-03-05 00:00:00 | 2021-03-05 00:00:00 | 2020-03-05 00:00:00 | 2021-03-05 00:00:00 | 2020-03-05 00:00:00 | 2021-03-05 00:00:00 |  |  | 2022-04-19 00:00:00 | 13:30:00
Jones | [NAME] | 6 | Purple | 2020-03-17 00:00:00 | 2021-03-17 00:00:00 | 2020-03-17 00:00:00 | 2021-03-17 00:00:00 | 2020-03-17 00:00:00 | 2021-03-17 00:00:00 |  |  | 2022-04-21 00:00:00 | 13:30:00
Fritz | [NAME] | 5 | Orange | 2020-03-18 00:00:00 | 2021-03-18 00:00:00 | 2020-03-18 00:00:00 | 2021-03-18 00:00:00 | 2020-03-18 00:00:00 | 2021-03-18 00:00:00 | 2020-03-18 00:00:00 |  | 2022-04-22 00:00:00 | 10:00:00
[NAME] | [NAME] | 3 | Green | 2020-08-18 00:00:00 | 2021-08-18 00:00:00 | 2020-08-18 00:00:00 | 2021-08-18 00:00:00 | 2020-08-18 00:00:00 | 2021-08-18 00:00:00 |  |  | 2022-04-20 00:00:00 | 14:30:00
Smith | Lewis | 5 | Green | 2020-10-01 00:00:00 |  | 2020-10-01 00:00:00 |  | 2020-10-01 00:00:00 |  |  |  | 2022-04-21 00:00:00 | 14:30:00
Spreadsheet: 414c718e-3926-4057-a08d-b615e35c7d4e
Sheet: 5.1 Table

5.1 Business interest rates
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Small business interest rate (a) (b) – per cent
September | 7.100000000000001 | 8.25 | 8.5 | 7.7 | 6.800000000000001
December | 7.7 | 8.6 | 8.15 | 7.25 | 6.75
March | 8.05 | 8.55 | 8.200000000000001 | 7.2 | 6.7
June | 8.25 | 8.55 | 7.75 | 7.050000000000001 | 6.7
Annual average (d) | 7.775 | 8.4875 | 8.15 | 7.3 | 6.7375
Large business interest rate (a) (c) – per cent
September | 5.45 | 6.4 | 6.45 | 5.65 | 4.75
December | 6 | 6.65 | 6.25 | 5.2 | 4.600000000000001
March | 6.2 | 6.600000000000001 | 6.2 | 5.100000000000001 | 4.600000000000001
June | 6.4 | 6.550000000000001 | 5.7 | 4.95 | 4.5
Annual average (d) | 6.012499999999999 | 6.550000000000001 | 6.149999999999999 | 5.225000000000001 | 4.612500000000001
(a) The data are weighted average rates, which are calculated from outstanding credit
held by businesses.
(b) In this context, a small business loan is defined as being less than $2 million.
(c) In this context, a large business loan is defined as being $2 million or more.
(d) Year ending June.
Source: RBA website, Statistical Tables, Interest Rates, Indicator [NAME] (F5).
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-11-03 00:00:00
Spreadsheet: 679141d1590219040-match-play-golf-comp-having-difficulty-with-winner-and-allocation-of-points-in-table-master-birdie-scores
Sheet: Fixture and Results

 |  |  |  |  |  |  |  |  | Match
 |  | Birdies 1 | Result |  |  |  |  | 1 | 2 | 3 | Total | Rank |  |  | Average
[NAME] |  | [NAME] |  | & |  | [NAME] | [NAME]
[NAME] |  | [NAME] |  | & |  | [NAME] | [NAME]
[NAME] |  | [NAME] |  | & |  | [NAME] | [NAME]
[NAME] |  | [NAME] |  | & |  | [NAME] | [NAME]
 |  | [NAME] |  | & |  | [NAME]
 |  | [NAME] |  | & |  | [NAME] |  |  | Match
 |  | Birdies 2 |  |  |  |  |  | 1 | 2 | 3 | Total | Rank |  |  | Average
[NAME] |  | [NAME] |  | & |  | [NAME] | [NAME]
[NAME] |  | [NAME] |  | & |  | Tahir Qaiyum | [NAME]
Tahir Qaiyum |  | [NAME] |  | & |  | [NAME] | Tahir Qaiyum
[NAME] |  | Tahir Qaiyum |  | & |  | [NAME] | [NAME]
 |  | [NAME] |  | & |  | [NAME]
 |  | Tahir Qaiyum |  | & |  | [NAME] |  |  | Match
 |  | Birdies 3 |  |  |  |  |  | 1 | 2 | 3 | Total | Rank |  |  | Average
[NAME] |  | [NAME] | 2 | & | 3 | [NAME] | [NAME] | 0
[NAME] |  | [NAME] |  | & |  | [NAME] | [NAME]
[NAME] |  | [NAME] |  | & |  | [NAME] | [NAME]
[NAME] |  | [NAME] |  | & |  | [NAME] | [NAME] | 2
 |  | [NAME] |  | & |  | [NAME]
 |  | [NAME] |  | & |  | [NAME] |  |  | Match
 |  | Birdies 4 |  |  |  |  |  | 1 | 2 | 3 | Total | Rank
[NAME] |  | [NAME] |  | & |  | [NAME] | [NAME]
[NAME] |  | [NAME] |  | & |  | [NAME] | [NAME]
[NAME] |  | [NAME] |  | & |  | [NAME] | [NAME] | 0
[NAME] |  | [NAME] | 2 | & | 3 | [NAME] | [NAME] | 2
 |  | [NAME] |  | & |  | [NAME]
 |  | [NAME] |  | & |  | [NAME]
Spreadsheet: 876247d1722931693-formula-to-multiply-cells-by-percentage-if-they-meet-2-conditions-ajwilltravel-if-and-formula-query-tms
Sheet: Sheet1

 |  |  |  | 0.1 | 21 Enterprise
 |  |  |  | 0.2 | 22 Channar
 |  |  |  | 0.3 | 23 Lofty
1 | 21 Enterprise | 500 | 600
2 | 22 Channar | 700 | 800
3 | 23 Lofty | 900 | 600
4 | 21 Enterprise | 20 | 50
1 | 21 Enterprise |  |  | MULTIPLY BY 10% REFERRING TO E3:F3
2 | 22 Channar |  |  | MULTIPLY BY 20% REFERRING TO E3:F4
3 | 23 Lofty |  |  | MULTIPLY BY 30% REFERRING TO E3:F5
4 | 21 Enterprise |  |  | MULTIPLY BY 10% REFERRING TO E3:F3
 | 140 |  |  | 160
 | 270 |  |  | 180
 | 2 |  |  | 5