tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 09dec085-c6fb-492a-8bae-3b76830fb70b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | FORM BA47
 |  |  |  |  |  |  |  |  |  |  | 07/01/999
VENDOR CONTRACT PERFORMANCE EVALUATION REPORT
DATE
DEPARTMENT
VENDOR
PRICE CONTRACT NO.
PURCHASE ORDER NO.
PURCHASING OFFICER
The purpose of this report is to obtain documentary evidence of a vendor's performance for decisive
action, future evaluations and decisions.  Be fair and factual in your ratings.  Attach any supplementary
record of performance that may be appropriate.
DELIVERY OF GOODS |  |  |  |  | Very Good |  |  | Satisfactory |  |  | Unsatisfactory
COMMENTS:
QUALITY OF PRODUCTS |  |  |  |  | Very Good |  |  | Satisfactory |  |  | Unsatisfactory
FURNISHED
COMMENTS:
RESPONSE TO CORRESPONDENCE |  |  |  |  | Very Good |  |  | Satisfactory |  |  | Unsatisfactory
COMMENTS:
COMPLAINTS AND REQUEST FOR |  |  |  |  | Very Good |  |  | Satisfactory |  |  | Unsatisfactory
SERVICE AND/OR ADVICE
COMMENTS:
SERVICES CONTRACT |  |  |  |  | Very Good |  |  | Satisfactory |  |  | Unsatisfactory
PERFORMANCE
COMMENTS:
SUMMITTED BY
 |  | Authorized Signature (Must be signed to be considered)
Spreadsheet: 164467d1340785904-conditional-formatting-f-formulas-please-help-0acfplease-help-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | I want this GANT colour chart below to automatically format in conjunction with the number references seen in the input cells on the left
 |  |  |  |  |  |  |  |  | Example Table: What I want it to look like!
 |  | Annual Rent: | = | 800000 |  |  |  |  | This example table however does not change in conjunction with the inputs table to the left, I.e. the colours have been manually been formatted and will not change.
 |  | LAND PURCHASE COST |  | Area Sqm | Rate $ psm | TOTAL |  |  | Month: | [NAME]
 |  | Land |  | 23845 | 60 |  | 2 |  | 1
 |  | Stamp Duty |  |  | 0.0546 |  |  | <<Put here 1 | 2 |  |  |  | See attached comments in the left Chart for idea formulas
 |  | Legals |  |  |  | 8000 | 2 |  | 3
 |  | Other |  |  |  | 0 | 3 |  | 4
 |  |  |  |  |  |  |  |  | 5
 |  | Total Purchase Cost: |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  | 7
 |  | Leasing Fees | % | Area Sqm | Rate $ psm | Total Leasing
 |  | Incentives | 0.1 | 10000 |  |  | 1
 |  | Fees | 0.01 |  |  |  | 5 |  | Testing Table: |  |  | If anyone can get this working much appreciated!
 |  | Postponed Leasing | 0.05 |  |  |  | 6
 |  | Other | 0 |  |  |  |  |  | Month: | [NAME]
 |  | Total Leasing Fees: |  |  |  |  | - |  | 1 |  |  |  |  |  | K21, K22, [NAME] have CF.
 |  |  |  |  |  |  |  |  | 2
 |  | Marketing | % | Area Sqm | Rate $ psm | Total Leasing |  |  | 3
 |  | Base | 0.08 | 10000 |  |  | 6 |  | 4
 |  | Final | 0 |  |  |  |  |  | 5
 |  | Postponed Expense | 0.04 |  |  |  | 7 |  | 6
 |  | Other | 0 |  |  |  |  |  | 7
 |  | Total Leasing Fees: |  |  |  |  | -
Spreadsheet: 329740d1404394867-specific-criteria-for-subtotals-query
Sheet: Sheet1

 |  |  |  |  | Total crew
 |  |  |  | DEPARTMENT 1 | INVOICED
 |  |  |  | DEPARTMENT 1 | QUOTE
 |  |  |  | DEPARTMENT 1 | RESERVATION
 |  |  |  | DEPARTMENT 2 | INVOICED
 |  |  |  | DEPARTMENT 2 | QUOTE
 |  |  |  | DEPARTMENT 2 | RESERVATION
 |  |  |  | DEPARTMENT 3 | INVOICED
 |  |  |  | DEPARTMENT 3 | QUOTE
 |  |  |  | DEPARTMENT 3 | RESERVATION
# | Order at | CREW ID | Department | start date | End date | 2014-01-01 00:00:00 | 2014-01-02 00:00:00 | 2014-01-03 00:00:00 | 2014-01-04 00:00:00 | 2014-01-05 00:00:00 | 2014-01-06 00:00:00 | 2014-01-07 00:00:00 | 2014-01-08 00:00:00 | 2014-01-09 00:00:00
1 |  | PLUMBER | DEPARTMENT 1 | 2014-01-01 00:00:00 | 2014-01-02 00:00:00
1 |  | ELECTRICIAN | DEPARTMENT 2 | 2014-01-01 00:00:00 | 2014-01-03 00:00:00
1 |  | ELECTRICIAN | DEPARTMENT 2 | 2014-01-01 00:00:00 | 2014-01-03 00:00:00
1 |  | CARPENTER | DEPARTMENT 3 | 2014-01-01 00:00:00 | 2014-01-03 00:00:00
1 |  | PLUMBER | DEPARTMENT 1 | 2014-01-01 00:00:00 | 2014-01-03 00:00:00
1 |  | PLUMBER | DEPARTMENT 1 | 2014-01-01 00:00:00 | 2014-01-03 00:00:00
1 | RESERVATION | ELECTRICIAN | DEPARTMENT 2 | 2014-01-03 00:00:00 | 2014-01-09 00:00:00
1 |  | ELECTRICIAN | DEPARTMENT 2 | 2014-01-03 00:00:00 | 2014-01-08 00:00:00
1 | RESERVATION | CARPENTER | DEPARTMENT 3 | 2014-01-03 00:00:00 | 2014-01-07 00:00:00
1 |  | PLUMBER | DEPARTMENT 1 | 2014-01-01 00:00:00 | 2014-01-06 00:00:00
1 | RESERVATION | PLUMBER | DEPARTMENT 1 | 2014-01-01 00:00:00 | 2014-01-06 00:00:00
1 |  | CARPENTER | DEPARTMENT 3 | 2014-01-03 00:00:00 | 2014-01-03 00:00:00
1 | RESERVATION | CARPENTER | DEPARTMENT 3 | 2014-01-04 00:00:00 | 2014-01-06 00:00:00
1 |  | CARPENTER | DEPARTMENT 3 | 2014-01-03 00:00:00 | 2014-01-05 00:00:00
1 |  | CARPENTER | DEPARTMENT 3 | 2014-01-08 00:00:00 | 2014-01-09 00:00:00
Spreadsheet: 833700d1687199567-conditional-formatting-of-multiple-conditions-based-on-a-date-in-another-cell-master-project-template-for-help-2-solution
Sheet: Erin

 | Project Manager | Erin
 | Projects Assigned
 | 1860's Dog Trot Farmhouse
Feasibility | feasibility notes
Schematic Design | schematic design notes
Preliminary |  | preliminary notes
NCC Preliminary
Preliminary Engineering
Final
NCC Final
Changes After Final
Permit
Under Construction
UC Revisions
Marketing
On Hold
Consulting
[NAME]
Complete
Reuse/Plan Order
Spreadsheet: 81682d1281808533-find-field-length-in-pivot-table-example2
Sheet: pivot

Row Labels | Count of count
D |  |  |  | sumproduct | sum | count |  |  | Mean:
2 | 1 |  |  |  |  |  |  |  | std dev:
3 | 13 |  |  |  |  |  |  |  | sqrt(stdev)
4 | 23 |  |  |  |  |  |  |  | Count:
5 | 22 |  |  |  |  |  |  |  | STDERR
6 | 58
7 | 63
8 | 81
9 | 133
10 | 134
11 | 152
12 | 161
13 | 142
14 | 181
15 | 195
16 | 134
17 | 240
18 | 169
19 | 140
20 | 193
21 | 130
22 | 109
23 | 115
24 | 86
25 | 77
26 | 220
27 | 78
28 | 83
29 | 40
30 | 39
31 | 34
32 | 34
33 | 24
34 | 31
35 | 13
36 | 18
37 | 10
38 | 16
39 | 7
40 | 9
41 | 13
43 | 2
44 | 8
45 | 2
46 | 1
47 | 3
48 | 1
49 | 3
50 | 1
51 | 2
52 | 2
53 | 1
54 | 1
57 | 1
58 | 19
R
2 | 2
3 | 4
4 | 6
5 | 21
6 | 19
7 | 32
8 | 67
9 | 61
10 | 94
11 | 68
12 | 87
13 | 126
14 | 117
15 | 84
16 | 77
17 | 113
18 | 106
19 | 83
20 | 91
21 | 75
22 | 62
23 | 55
24 | 46
25 | 54
26 | 39
27 | 59
28 | 46
29 | 30
30 | 30
31 | 31
32 | 20
33 | 8
34 | 21
35 | 20
36 | 11
37 | 10
38 | 7
39 | 12
40 | 12
41 | 6
42 | 2
43 | 4
44 | 7
45 | 2
46 | 1
47 | 1
49 | 2
53 | 1
55 | 1
56 | 1
58 | 15
Grand Total | 5417
Spreadsheet: 216093d1361578676-vlookup-formula-issue-fishing-orders
Sheet: Item List

Item# | Description | Price Schedule | Ship Volume (CF)
201 | Proline Cast Reel | 1 | 0.5
202 | Supra Cast Reel | 1 | 0.5
203 | Ultra-Lite Spin Reel | 1 | 0.5
204 | Proline Spin Reel | 1 | 0.5
205 | Proline Underspin Reel | 1 | 0.5
206 | Proline Lite Stick Cast Rod | 1 | 0.6
207 | Cyclo Stick Cast Rod | 1 | 0.6
208 | Cyclo Stick Spinning Rod | 1 | 0.6
209 | [NAME] | 1 | 0.35
210 | [NAME] | 1 | 0.35
211 | Wide Gap Treble Hook Set | 1 | 0.35
212 | [NAME] | 1 | 0.35
213 | Mono-filament line spool | 1 | 0.45
214 | Florocarbon line spool | 1 | 0.45
215 | 1/4 lb Fish Line | 1 | 0.45
216 | 1/2 lb Fish Line | 1 | 0.5
217 | Waders Paints | 1 | 2.25
218 | Soft Bait Bulk - Worms | 2 | 0.05
Spreadsheet: 71cc6a73-5b2d-46f4-9eb9-29be8483636f
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
NORT | Test | NORT | Nortriptyline, Serum | Nortriptyline, S | High-Performance Liquid Chromatography (HPLC) | Plain, Red-Top Tube: Red OR |  |  | 3 | mL | Container/Tube: Red top  [NAME]: 3 mL Collection Instructions:  1. Draw specimen immediately before next scheduled dose (minimum 12 hours after last dose).  2. Serum must be separated from cells within 2 hours of draw. | 1.1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | Therapeutic concentration: 70-170 ng/mL Toxic concentration: > or =300 ng/mL Note: Therapeutic ranges are for specimens drawn at trough (ie, immediately before next scheduled dose). Levels may be elevated in non-trough specimens. | Monday through Saturday; Varies | 2 days | 4 days | 1 | 80182 |  |  |  |  | Rochester
NORT | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
NORT | Result | 81858 | Nortriptyline, S | Nortriptyline, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3872-9
Spreadsheet: 813575d1673863628-vlookup-multiple-criteria-and-sheets-vlookup-sample-ans
Sheet: Sheet1

Name | date | ID | Amount | FORMULA
ABC | 2023-01-10 00:00:00 | 636363 | 764
ABC | 2023-01-10 00:00:00 | 242424 | 657 | 657
BOB | 2023-01-31 00:00:00 | 636363 | 937 | 937
BOB | 2023-01-10 00:00:00 | 242424 | 5645 | 5645
[NAME] | 2023-01-10 00:00:00 | 242424 | 232 | 232
Scott | 2023-01-10 00:00:00 | 636363 | 787 | 787
ABC | 2023-01-31 00:00:00 | 121212 | 4363 | 4363
[NAME] | 2023-01-31 00:00:00 | 242424 | 382 | 382
ABC | 2023-01-31 00:00:00 | 636363 | 914 | 914
ABC | 2023-01-31 00:00:00 | 323232 | 6717 | 6717
[NAME] | 2023-01-31 00:00:00 | 636363 | 906 | 906
Scott | 2023-01-31 00:00:00 | 636363 | 937 | 937
Spreadsheet: 567f13df-1c47-4ddf-94ad-0e3b17d2ba34
Sheet: Rate History

Rate History |  |  |  |  |  |  | Year over Year Change
Fund | Expense per Contact Hour by  Discipline | 2002 | 2001 | 2000 | 1999 |  | 2002 | 2001 | 2000
1 | Agriculture |  | 7 | 6.669999999999999 | 6.81
2 | Architecture and Precision Production Trades |  | 7.56 | 6.829999999999999 | 6.640000000000001
3 | Biology, Physical Sciences, and Science Technology |  | 5.9 | 5.69 | 5.51
4 | Business Management, Marketing, and Administrative Services |  | 6.07 | 6.129999999999999 | 6.22
5 | Career Pilot |  | 16.04 | 19.42 | 18.69
6 | Communications |  | 6.99 | 9.21 | 8.21
7 | Computer and Information Sciences |  | 6.69 | 6.319999999999999 | 5.44
8 | Construction Trades |  | 6.119999999999999 | 6.42 | 5.99
9 | Consumer and Homemaking Education |  | 5.52 | 5.139999999999999 | 5.35
10 | Engineering |  | 11.49 | 9.829999999999998 | 7.640000000000001
11 | Engineering Related |  | 6.58 | 6.71 | 6.42
12 | English Language, Lit, Philosophy, Humanities, & Interdisciplinary |  | 5.75 | 5.68 | 5.26
13 | Foreign Languages |  | 5.93 | 5.81 | 5.699999999999999
14 | Health Occupations - Dental Assistants, Medical Lab, and [NAME]. Degree Nursing |  | 9.73 | 8.92 | 9.04
15 | Health Occupations - Dental Hygiene |  | 11.79 | 12.64 | 11.21
16 | Health Occupations - Other |  | 6.69 | 6.26 | 6.51
17 | Health Occupations - Respiratory Therapy |  | 10.23 | 8.739999999999998 | 8.64
18 | Health Occupations - Vocational Nursing |  | 6.59 | 6.999999999999999 | 5.76
19 | Mathematics |  | 5.390000000000001 | 5.26 | 4.96
20 | Mechanics and Repairers - Automotive |  | 7.74 | 7.669999999999999 | 6.49
21 | Mechanics and Repairers - Diesel, Aviation Mechanics, and Transportation Workers |  | 7.41 | 7.819999999999999 | 7.32
22 | Mechanics and Repairers - Electronics |  | 7.41 | 7.329999999999999 | 6.470000000000001
23 | Physical Education and Fitness |  | 6.98 | 6.879999999999999 | 6.21
24 | Protective Services and Public Administration |  | 5.9 | 5.579999999999999 | 4.94
25 | Psychology, Social Sciences, and History |  | 5.27 | 5.17 | 4.97
26 | Visual and Performing Arts |  | 7.529999999999999 | 7.35 | 7.33
28 | Developmental Education - Math |  | 0 | 0 | 0
29 | Developmental Education - Reading/Writing |  | 0 | 0 | 0
 | Average
 | Median
 | Standard Deviation
Spreadsheet: fc323e03-d8ff-48ef-b1c5-31de7328044c
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
42257707 | 2014-07-11 19:24:02 | ALLIES | 0 | 2 | 4 | 331242 | AdairC | 7269 | mediterranean | 1940-11-06 | 1940-11-06 | Gallabat & Metemma | Gallabat & Metemma
42257981 | 2014-07-11 19:37:03 | AXIS | 0 | 2 | 4 | 331242 | AdairC | 7269 | mediterranean | 1940-11-06 | 1940-11-06 | Gallabat & Metemma | Gallabat & Metemma
Spreadsheet: 123124d1317363533-conditional-formula-with-summation-not-returning-correct-result-why
Sheet: Sheet1

 | Does not work |  |  |  | ???? | Works
 | 59 | 0.3 | Total 1 |  |  | -2 | -0.5 | Total 1
 | 216 | 0 | Total 2 |  |  | 25 | 0 | Total 2
 | -264 | 0.3 | Total 3 |  |  | -150 | 0 | Total 3
 | -16 | -0.5 | Total 4 |  |  | -23 | -0.5 | Total 4
 | -4.5 | 0 | Total 5 |  |  | 4 | 0 | Total 5
 |  |  | Total |  |  |  |  | Total
Spreadsheet: 99159d1297888654-vlookup-and-date-query
Sheet: B

DATE | CODE | DCODE | PLACE | NAME | RATE
2011-02-11 00:00:00 | C057 | 121102 |  | M/S.RELIANCE INFRA LTD
2011-02-11 00:00:00 | SN44 | 121104 |  | M/S.COALMAN INDIA LTD
2011-02-11 00:00:00 | VC07 | 121101 |  | M/S.LEHMAN BROTHERS LTD
2011-02-12 00:00:00 | S025 | 121101 |  | M/S.ARIHANT TRADERS
2011-02-13 00:00:00 | SN44 | 121102 |  | M/S.VODAFONE INDIA LTD
2011-02-14 00:00:00 | AF34 | 121101 |  | M/S.INFOSYS
Spreadsheet: 814735d1674569773-dynamic-dependent-drop-down-data-validation-with-indirect-returns-source-error-example-workbook
Sheet: Master List

 |  |  |  | Where do you want to go?
 |  |  | CAD and Product Engineering |  |  |  | Supply Chain |  |  | Product Engineering |  |  |  |  |  | Finishing
Item | Rev | Hyperlink to PDF | Description | Category/ Process | ECO | Hyperlink to Folder | Supply Chain Status | Quote/Sample Request Date | Supplier | PSW | Product Type | Due By | Tooling Cost | [NAME] | Samples Due | Coatable Surface Area (in2) | Volume (in3) | Notes