tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Industrial Maintenance

INDUSTRIAL MAINTANANCE TECHNOLOGY
Diploma - Industrial Maintenance Technician
Student Name:
ID #
General Education | Semester | Grade
___ Area I Writing/Accessing Information, Oral Communication,
Heritate, Humanities or Foreign Language (3)
___ Area II ___ MAT 116 (3) Technical Mathematics
OR ___ MAT 126 (3) Technical Algebra & Trigonometry
___ Area III ___ CIT 105 (3) [NAME]  to Computers OR ___ IC3 Computer Literacy Exam
Technical Core
___ BRX 120 (3) Basic Blueprint Reading
OR ___ BRX 110 (2) Basic Blueprint Reading for Machinists
___ BRX 112 (4) Blueprint Reading for Machinists
OR ___ BRX 112 (4) Blueprint Reading for Machinists
OR ___ ELT 102 (2) Blueprint Reading
___ FPX 100 (3) Fluid Power AND ___ FPX 101 (2) Fluid Power Lab
OR ___ ELT 265 (3) Applied Fluid Power
___ IMT 110 (3) Industrial Maintenance Electrical Principles
AND ___ IMT 111 (2) Industrial Maintenance Electrical Principles Lab
OR ___ ELT 110 (5) Circuits I
___ IMT 150 (3) Maintaining Industrial Equipment I
___ IMT 151 (2) Maintaining Industrial Equipement I Lab
___ IMT 220 (3) Industrial Maintanance Electrical Motor Controls I
AND ___ IMT 221 (2) Industrial Maintanance Electrical Motor Controls I Lab
OR ___ ELT 270 (2) Electrical Motor Controls I
AND ___ ELT 271 (2) Electrical Motor Controls I Lab
OR ___ ELT 244 (4) Electrical Machinery and Controls
OR ___ IMT 120 (3) Industrial Maintenance Rotating Machinery
AND ___ IMT 121 (2) Industrial Maintenance Rotating Machinery Lab
OR ___ EET 264 (2) Rotating Machinery AND ___ EET 265 (2) Rotating Machinery Lab
___ IMT 100 (3) Welding for [NAME] AND ___ IMT 101 (2) Welding for [NAME]
OR ___ WLD 120 (2) Shielded Metal Arc Welding
AND ___ WLD 121 (3) Shielded Metal Arc Welding Fillet Lab
OR ___WLD 152 (5) Basic Welding B
Technical Electives
Fifteen (15) credit hours of electives must be taken from the approved list.  This list is not all
inclusive.  Other technical elective courses may be taken with approval of the program
instructor/advisor.
** If courses equaling 10 credits are taken, five (5) credits may be used as electives.
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: darrell_schoolcraft__7796__imbalsumm0107
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -137341 | -136796
2 | -125680 | -124374
3 | -103730 | -110538
4 | -64504 | -65000
5 | -65339 | -64480
6 | -110873 | -111438
7 | -104259 | -103558
8 | -123476 | -123233
9 | -115393 | -114855
10 | -91816 | -91920
11 | -44422 | -44371
12 | -18430 | -18414
13 | -44797 | -44092
14 | -194555 | -194162
15 | -206012 | -204162
16 | -194790 | -194162
17 | -77025 | -77300
18 | -126017 | -123466
19 | -94130 | -93379
20 | -116887 | -116464
21 | -126531 | -124368
22 | -109715 | -109429
23
24
25
26
27
28
29
30
31
 | 2001-06-30 00:00:00 |  | 28278
 | 2001-07-22 00:00:00
Spreadsheet: 294010d1391168643-transfer-data-from-excel-to-web-form-test-time-sheet
Sheet: Sheet1

Select Technology, Task & Customer from drop down lists (Below). This will pre-populate Project and Task Number. |  |  |  |  |  | Total Time (Week) |  | 0
 |  |  |  |  |  | Total Time (Day) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
Technology |  | Task |  | Customer |  | Project | Task Number | Mon | Tue | Wed | Thu | Fri | Sat | Sun
Project Name. | #N/A | Accreditation | #N/A | Client Name | #N/A | #N/A | #N/A
Project Name. | #N/A | Task Name | #N/A | Client Name | #N/A | #N/A | #N/A
Project Name. | #N/A | Task Name | #N/A | Client Name | #N/A | #N/A | #N/A
Project Name. | #N/A | Task Name | #N/A | Client Name | #N/A | #N/A | #N/A
Spreadsheet: 842704d1694705143-extract-data-from-rows-to-column-order-file_1
Sheet: Output

Acct No | Qty | Price
M1 | 2 | 2 |  |  | 2 | 2 |  |  |  |  |  |  | 2 | 2
M4 | 3 | 1 |  | M4 | 3 | 1 |  |  |  |  |  | M4 | 3 | 1
M5 | 2 | 3 |  | M5 | 2 | 3 |  |  |  |  |  | M5 | 2 | 3
M2 | 5 | 1 |  | M2 | 5 | 1 |  |  |  |  |  | M2 | 5 | 1
M3 | 2 | 6 |  | M3 | 2 | 6 |  |  |  |  |  | M3 | 2 | 6
M1 | 3 | 3 |  | M1 | 3 | 3 |  |  |  |  |  | M1 | 3 | 3
M2 | 2 | 1 |  | M2 | 2 | 1 |  |  |  |  |  | M2 | 2 | 1
M3 | 3 | 1 |  | M3 | 3 | 1 |  |  |  |  |  | M3 | 3 | 1
M4 | 1 | 1 |  | M4 | 5 | 1 |  |  |  |  |  | M4 | 5 | 1
 |  |  |  | M1 | 1 | 5 |  |  |  |  |  | M1 | 1 | 5
 |  |  |  | M4 | 3 | 2 |  |  |  |  |  | M4 | 3 | 2
 |  |  |  | x1 | 10 | 10/ea |  |  |  |  |  | x1 | 10 | 10
 |  |  |  | x2 | 11 | 3.73/kg |  |  |  |  |  | x2 | 11 | 3.73
Spreadsheet: 44235d1242862582-sumproduct-what-i-am-trying-to-do-avg-example
Sheet: Sheet1

Category | % overal sales | product | avg prod price | # of products |  | Products sold/mth
a | 0.1 | a | 12 | 5 |  | 200 | Yr 1
 |  | b | 12 | 5 |  | 400 | Yr 2
 |  | c | 20 | 5 |  | 600 | Yr 3
 |  | d | 10 | 5 |  | 800 | Yr 4
b | 0 | e | 9 | 0
 |  | f | 20 | 0
 |  | g | 40 | 0
 |  | h | 75 | 0
 |  | italian | 150 | 0
 |  | j | 12 | 0
 |  | k | 20 | 0
 |  | l | 35 | 0
 |  | m | 50 | 0
 |  | n | 75 | 0
 |  | o | 50 | 0
 |  | p | 100 | 0
 |  | q | 200 | 0
 |  | r | 400 | 0
 |  | s | 600 | 0
 |  | t | 800 | 0
 |  | u | 1000 | 0
 |  | v | 15 | 0
c | 0.07 | w | 7 | 0
 |  | x | 7 | 0
 |  | y | 7 | 1
 |  | z | 7 | 0
 |  | aa | 7 | 0
 |  | bb | 7 | 0
 |  | cc | 7 | 3
d | 0 | dd | 9 | 0
 |  | ee | 9 | 0
 |  | ff | 9 | 0
 |  | gg | 9 | 0
e | 0.1 | hh | 4 | 3
 |  | ii | 4 | 0
 |  | jj | 5 | 0
 |  | kk | 5 | 0
 |  | ll | 3 | 0
 |  | [NAME] | 4 | 0
 |  | nn | 4 | 0
 |  | oo | 4 | 0
f | 0.2 | pp | 6 | 1
 |  | qq | 6 | 1
 |  | rr | 6 | 1
 |  | ss | 6 | 1
 |  | tt | 6 | 1
 |  | uu | 6 | 1
g | 0.2 | vv | 7 | 1
 |  | ww | 7 | 1
 |  | xx | 7 | 1
 |  | yy | 7 | 1
 |  | zz | 7 | 1
 |  | aaa | 7 | 1
h | 0.05 | bbb | 5 | 0
 |  | [NAME] | 5 | 0
 |  | ddd | 5 | 0
 |  | eee | 5 | 0
 |  | [NAME] | 5 | 0
 |  | ggg | 5 | 0
 |  | hhh | 5 | 0
i | 0 | iii | 4 | 0
 |  | jjj | 4 | 0
 |  | kkk | 4 | 0
 |  | llll | 4 | 0
 |  | mmm | 4 | 0
 |  | nnn | 4 | 0
 |  | ooo | 4 | 0
j | 0 | ppp | 3.5 | 0
 |  | qqq | 3.5 | 0
 |  | rrr | 3.5 | 0
 |  | sss | 3.5 | 0
k | 0.1 | ttt | 22 | 1
 |  | uuu | 22 | 1
 |  | vvv | 22 | 1
 |  | www | 22 | 2
 |  | xxx | 22 | 1
 |  | yyy | 22 | 1
 |  | zzz | 22 | 2
l | 0.05 | aaaa | 120 | 1
 |  | bbbb | 170 | 1
 |  | cccc | 210 | 1
 |  | dddd | 45 | 1
 |  | eee | 75 | 1
 |  | ffff | 105 | 1
 |  | gggg | 20 | 3
 |  | hhhh | 40 | 3
 |  | iiii | 60 | 3
m | 0.13 | jjjj | 12 | 5
 |  | kkkk | 50 | 2
 |  | llll | 20 | 5
 |  | mmmm | 25 | 0
 |  | nnnn | 8 | 5
 |  | oooo | 12 | 5
 |  | pppp | 25 | 0
 |  | qqqq | 5 | 5
 |  | rrrr | 7 | 0
 | 1 |  | 13.95555555555556 | 90
Spreadsheet: 537285d1504913586-this-operation-has-been-canceled-new-excel-error-budget
Sheet: Expenses B

Someone's Budget
 |  |  |  |  |  |  |  |  |  | Summary
 | Vehicle |  |  |  |  |  |  |  |  | Show results
 |  | Frequency | Amount | Annually amount
 | [NAME] |  | 333 | 333 |  |  |  |  |  | Income |  |  |  |  |  |  |  |  | 5
 | Vehicle Maintenance |  | 222 | 222 |  |  |  |  |  | Income | 33276 |  |  |  |  |  |  |  | 5
 | Petrol |  | 111 | 1332 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | TBA |  | 0 | 0 |  |  |  |  | Total Income |  | 33276 |  |  |  |  |  |  |  | 5
 | TBA |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | TBA |  | 500 | 6000 |  |  |  |  |  | Outgoings |  |  |  |  |  | Select | # in a year | Amount | 3
 |  |  | Total | 7887 |  |  |  |  |  | Overheads | 7520 |  |  |  | 1 | Weekly | 52 | Weekly
 | Living |  |  |  |  |  |  |  |  | Vehicle | 7887 |  |  |  | 2 | Fortnightly | 26 | Fortnightly
 |  |  |  |  |  |  |  |  |  | Living | 3824 |  |  |  | 3 | Monthly | 12 | Monthly
 | Food |  | 21 | 1092 |  |  |  |  |  | Medical | 4440 |  |  |  | 4 | Quarterly | 4 | Quarterly | 1
 | - |  | 0 | 0 |  |  |  |  |  | Accounting, Insurance | 777 |  |  |  | 5 | Annually | 1 | Annually | 5
 | Subscriptions |  | 100 | 1200 |  |  |  |  |  | Recreation | 1768 |  |  |  |  |  |  |  | 3
 | Clothes |  | 111 | 1332 |  |  |  |  |  | Travel | 333 |  |  |  |  |  |  |  | 3
 | TBA |  | 0 | 0 |  |  |  |  |  | Business Overheads | 25 |  |  |  |  |  |  |  | 3
 | TBA |  | 0 | 0 |  |  |  |  |  | Development | 3996 |  |  |  |  |  |  |  | 3
 | TBA |  | 50 | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 | TBA |  | 0 | 0 |  |  |  |  | Total outgoings: |  | 30570 |  |  |  |  |  |  |  | 3
 |  |  | Total | 3824
 |  |  |  |  |  |  |  |  | What's left: |  | 2706
 |  |  |  |  |  |  |  |  |  |  | per year
 | Vehicle / Living
Spreadsheet: 485086d1476701028-return-all-product-names-listed-against-a-single-account-excel-help-example
Sheet: Summary Sheet

Account ID | Account Name | [NAME]) purchased | Monthly/annual revenue | Contract expiration date | DR customer? | DR offset? | DM customer? | Procurement customer?
0013000000pW7M0AAK | Customer Name 1 | Return all Products purchased (eg  Product 1, Product 2 Product 3) |  | Looking for Max Date in a range; eg Oct 2017 or October 2018 | Yes or No - if certain product is found in range | Yes or No - if certain product is found in range | Yes or No - if certain product is found in range | Yes or No - if certain product is found in range
0013000000pW7IdAAK | Customer Name 2
0013000000pVzx2AAC | Customer Name 3
0013000000rUCXmAAO | Customer Name 4
0013000000rUCXmAAO | Customer Name 5
0013000000rUCXmAAO | Customer Name 5
0013000000qVBxnAAG | Customer Name +++++
Spreadsheet: 896b1c15-cbde-4015-ad3e-50b25618d70f
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
DATE | Test | DATE | Date, Fruit, IgE | Date, Fruit, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top	 Acceptable: Serum gel	 [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
DATE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
DATE | Result | DATE | Date, Fruit, IgE | Date, Fruit, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7275-1 | Phoenix canariensis pollen Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 865754d1712754017-new-invoice-allocation-register-test-invoice-allocation-register-emmagizer-amended-1-aligw-1-
Sheet: Output

 | Enter Job Number here: | JN23/001
 | PO Description | PO status | PO Value  (ex GST) | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | PO Balance | Comments
 |  |  |  | 1611994 | 1625078 | 1638146
 |  |  |  | 2295 | 1000.5 | 564
 |  |  |  | APPROVED | PAID | QUERY/ISSUE
3926 | JN23/001 Insurance claim (Quote 27/9/2023) | Open | 1997.5 |  |  |  | 1997.5
3814 | JN23/001 Insurance claim (Quote 23/05/2023) | Open | 5300 | 2295 | 1000.5 | 564 | 1440.5 | PO to be closed
Spreadsheet: 472299d1469535715-find-a-name-in-a-list-instead-of-absolute-reference-test-file
Sheet: Sheet1

 |  |  |  |  |  |  | Last | Complete | Valid
[NAME] |  |  |  |  |  |  | J Smith | United J Smith
United J Smith |  |  |  |  |  |  | Duck | [NAME] Golden Duck
[NAME] 11-7 |  |  |  |  |  |  | Jordan | [NAME]
[NAME] |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] Golden Duck |  |  |  |  |  |  | Zimmer | [NAME]
[NAME]
Spreadsheet: 776007d1649434617-retrieve-values-from-different-excel-files-test-dashboard
Sheet: REVENUES

YEAR | QUARTER | [NAME] |  |  |  |  |  | REVENUES TVAC |  |  |  |  | SOLDE BANCAIRE
 |  | PERÇU | À PERCEVOIR | ANNULÉ | TOTAL |  |  | PERÇU | À PERCEVOIR | ANNULÉ | TOTAL
2021 | ALL |  |  |  |  |  |  |  |  |  |  |  | 2572.06
2022 | ALL |  |  |  |  |  |  |  |  |  |  |  | ...
2023 | ALL |  |  |  |  |  |  |  |  |  |  |  | ...
2024 | ALL |  |  |  |  |  |  |  |  |  |  |  | ...
2025 | ALL |  |  |  |  |  |  |  |  |  |  |  | ...
 |  | REVENUS TOTAUX HTVA |  |  |  |  |  | REVENUS TOTAUX TVAC
 |  | ESTIMATION DES REVENUS TOTAUX HTVA FUTURS (SUR BASE DE LA MAINTENCE) |  |  |  |  |  | ESTIMATION DES REVENUS TOTAUX TVAC FUTURS (SUR BASE DE LA MAINTENCE)
Spreadsheet: cooper_richey__4029__marks
Sheet: Sheet1

 |  |  |  |  |  |  | Jan 16  2002
 |  | *2001 actual published PP
 |  |  | flat | on | off |  | 2002 | BID | OFFER | MID
 |  | JAN* | 131.23 | 145.5 | 113.1 |  | BOM | 30.5 | 33
 |  | FEB* | 116.75 | 134.4 | 93.16 |  | FEB | 31.5 | 33
 |  | MAR* | 97.23 | 114.6 | 73.12 |  | MAR | 32.25 | 33
 |  | APR* | 114.82 | 138.4 | 85.25 |  | APR | 30.5 | 32
 |  | MAY* | 88.34 | 107.4 | 61.85 |  | MAY | 30.5 | 32
 |  | JUN* | 63.59 | 79.85 | 41.34 |  | JUN | 30.5 | 32
 |  | JUL* | 53.47 | 64.64 | 40.48 |  | JUL | 35 | 36.5
 |  | AUG* | 52.37 | 63.54 | 36.91 |  | AUG | 35 | 36.5
 |  | SEP* | 29.84 | 35.9 | 23.11 |  | SEP | 35 | 36.5
 |  | OCT* | 43.92 | 54.2 | 29.73 |  | OCT | 37 | 38.5
 |  | NOV* | 33.31 | 42.28 | 22.09 |  | NOV | 37 | 38.5
 |  | DEC | 33.3 |  |  |  | DEC | 37 | 38.5
 |  |  |  |  |  |  | Feb Dec
Spreadsheet: 127274d1320263819-nested-level-limit-exceeded-with-if-statements-imagedesignatorsampledata
Sheet: Sheet1

MODELID | Image Designator (A-ZZ)
09710
09710
09710
09711
09711
09711
09711
09712
09712
09712
09712
09713
09713
09714
09714
00187
00187
00187
00035
00035
08487
08487
00015
00015
00038
00038
00038
08472
08472
09025
09025
09025
09025
09733
09733
08497
08497
08497
08497
02078
02078
02078
09422
09422
09561
09561
00118
00118
00118
00118
00118
00118
00118
00118
00118
00118
08135
08135
08135
08135
08135
08135
08135
08135
09188
09188
09188
09188
09188
09289
09289
09289
09289
09458
09458
09458
09463
09463
09463
07185
07185
07185
07185
07185
07185
07185
07185
07185
09471
09471
09471
01930
02195
02195
02195
02195
02195
02195
02195
02195
02195
02195
02195
02195
02195
02195
02195
02197
02197
02197
02197
02197
02197
02197
02197
02197
02197
02197
02197
02197
02197
02197
02197
02197
02197
02197
02197
02197
02197
02197
Spreadsheet: 24812d1215650149-searching-an-entire-table-for-a-value-sample
Sheet: 125Ml

ITEM NO. | Product | Type | Design No. | [NAME] | [NAME] | Clr 3 | [NAME] | Clr 5 | Clr 6 |  | [NAME] | Used
6226 | aaa | P | 53-8591 | P0083 | P0053 | P0014 | P0097 | P0382 | 0 |  | P0083
6231 | bbb | P | 53-8588 | P0083 | P0053 | P0014 | P0097 | P1235 | 0 |  | P0053
6232 | [NAME] | P | 53-8366 | P0083 | P0053 | P0014 | P0097 | P0144 | 0 |  | P0014
6258 | ddd | P | 53-C160 | P0083 | P0053 | P0014 | P0097 | [NAME] | 0 |  | P0097
6256 | eee | P | 53-C164 | P0083 | P0053 | P0014 | P0097 | [NAME] | 0 |  | P0382
 |  |  |  |  |  |  |  |  |  |  | P2685
 |  |  |  |  |  |  |  |  |  |  | P0362
 |  |  |  |  |  |  |  |  |  |  | P1235
 |  |  |  |  |  |  |  |  |  |  | P0144
 |  |  |  |  |  |  |  |  |  |  | P0286
 |  |  |  |  |  |  |  |  |  |  | P0356
 |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 77797d1278309840-conditional-formatting-in-calendar-cg-shift-calendar-currentmo
Sheet: Sheet2

 |  |  |  | Tue | Wed | Thu | Fri | Mon | Tue | Wed | Thu | Fri | Mon | Tue | Wed | Thu | Fri | Mon | Tue | Wed | Thu | Fri | Mon | Tue | Wed
Spreadsheet: 38668d1236802451-return-multiple-rows-in-an-array-with-the-same-value-arraylookup
Sheet: Sorting data

2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5 |  |  |  | <<< | These cells no longer have the word "Grades"
Grade | School Name | Group |  | Grade | School Name | Group |  | Grade | School Name | Group |  | Grade | School Name | Group |  |  | in them, just the number. A custom number format
2 | MacKenzie | A |  | 3 | Gladys | A |  | 4 | Gladys | B |  | 5 | MacKenzie | A |  |  | is adding the word "grades".
2 | MacKenzie | B |  | 3 | Gladys | A |  | 4 | Hawthorne | A |  | 5 | [NAME] | A |  |  | Select one and press CTRL-1 to see the custom
2 | St. Matthew's | A |  | 3 | MacKenzie | A |  | 4 | Hawthorne | B |  | 5 | [NAME] | B |  |  | number formatting
2 | St. Matthew's | B |  | 3 | MacKenzie | B |  | 4 | Hawthorne | C |  | 5 | [NAME] | C
2 | St. Matthew's | C |  | 3 | [NAME] | A |  | 4 | Hawthorne | D |  | 5 | [NAME] | A
2 | St. Matthew's | D |  | 3 | [NAME] | B |  | 4 | [NAME] | A |  | 5 | [NAME] | B
These are array formulas. To make a change, edit the first cell at the top of the column and press CTRL-SHIFT-ENTER to apply the change to the whole array
If you just press ENTER, it will break the array and you will get an error.
I NEED THE ABOVE TABLE TO LOOKUP THE GRADE FROM THE FIRST SHEET
TO AUTO ENTER THIS:
 | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Grade 5
Grade | School Name | Group |  | Grade | School Name | Group |  | Grade | School Name | Group |  | Grade | School Name | Group
2 | MacKenzie | A |  | 3 | Gladys | A |  | 4 | Gladys | B |  | 5 | MacKenzie | A
2 | MacKenzie | B |  | 3 | Gladys | C |  | 4 | Hawthorne | A |  | 5 | [NAME] | A
2 | St. Matthew's | A |  | 3 | MacKenzie | A |  | 4 | Hawthorne | B |  | 5 | [NAME] | B
2 | St. Matthew's | B |  | 3 | MacKenzie | B |  | 4 | Hawthorne | C |  | 5 | [NAME] | C
2 | St. Matthew's | C |  | 3 | [NAME] | A |  | 4 | Hawthorne | D |  | 5 | [NAME] | A
2 | St. Matthew's | D |  | 3 | [NAME] | B |  | 4 | [NAME] | A |  | 5 | [NAME] | B
DO YOU KNOW THE FORMULAS?
DO THE TABLES NEED TO BE REARRANGED?
Spreadsheet: 0bea8d59-64de-45ad-923a-e69b9bf88f9e
Sheet: Sheet1

City of Oakland - Annual Parking Citation Report | Unnamed: 1 | Unnamed: 2
Length of phone waiting time | Average time
Length of phone waiting time - July 2011 | 7:37 minutes
Length of phone waiting time - June 2012 | 3:38 minutes
Average length of time to resolve appeals | < 30 days
Statistic Description* | # | %
Number of Tickets Issued | 368017
Number of Appeals ([NAME]) | 26096
Admin Reviews Found Liable | 16111 | 0.62
Admin Reviews Found Not Liable | 9985 | 0.38
12 Month Collection Rate |  | 0.75
24 Month Collection Rate |  | 0.74
*Period: 2011-2012 Fiscal Year (July 2011 to June 2012)
Posted to [NAME] February 08, 2013
Spreadsheet: 680652d1591121297-need-a-formula-to-pull-data-from-another-sheets-chart-based-off-age-and-gender-2020-06-02-oeldere-tbingham-680647d1591120212-need-a-formula-to-pull-data-from-another-sheets
Sheet: Male Run

Percent | 20-29 | 30-34 | 35-39 | 40-44 | 45-49 | 50-54 | 55-59 | 60+
99 | 07:29:00 | 07:11:00 | 07:27:00 | 07:42:00 | 08:08:00 | 08:44:00 | 09:07:00 | 09:30:00
95 | 08:13:00 | 08:44:00 | 09:07:00 | 09:30:00 | 10:05:00 | 10:40:00 | 11:00:00 | 11:20:00
90 | 09:09:00 | 09:30:00 | 09:53:00 | 10:16:00 | 10:47:00 | 11:18:00 | 11:49:00 | 12:20:00
85 | 09:45:00 | 10:16:00 | 10:47:00 | 11:18:00 | 11:49:00 | 12:20:00 | 12:51:00 | 13:22:00
80 | 10:16:00 | 10:47:00 | 11:15:00 | 11:44:00 | 12:18:00 | 12:51:00 | 13:22:00 | 13:53:00
75 | 10:42:00 | 11:18:00 | 11:34:00 | 11:49:00 | 12:36:00 | 13:22:00 | 13:53:00 | 14:24:00
70 | 10:47:00 | 11:34:00 | 12:04:00 | 12:34:00 | 13:10:00 | 13:45:00 | 14:19:00 | 14:53:00
65 | 11:18:00 | 11:49:00 | 12:20:00 | 12:51:00 | 13:27:00 | 14:03:00 | 14:41:00 | 15:19:00
60 | 11:41:00 | 12:20:00 | 12:47:00 | 13:14:00 | 13:49:00 | 14:24:00 | 14:57:00 | 15:29:00
55 | 11:49:00 | 12:38:00 | 13:00:00 | 13:22:00 | 14:01:00 | 14:40:00 | 15:18:00 | 15:55:00
50 | 12:18:00 | 12:51:00 | 13:22:00 | 13:53:00 | 14:24:00 | 14:55:00 | 15:31:00 | 16:07:00
45 | 12:20:00 | 13:22:00 | 13:45:00 | 14:08:00 | 14:43:00 | 15:08:00 | 15:47:00 | 16:27:00
40 | 12:51:00 | 13:36:00 | 14:03:00 | 14:29:00 | 14:58:00 | 15:26:00 | 16:05:00 | 16:43:00
35 | 13:06:00 | 13:53:00 | 14:20:00 | 14:47:00 | 15:20:00 | 15:53:00 | 16:26:00 | 16:58:00
30 | 13:22:00 | 14:08:00 | 14:32:00 | 14:56:00 | 15:27:00 | 15:57:00 | 16:36:00 | 17:14:00
25 | 13:53:00 | 14:24:00 | 14:55:00 | 15:26:00 | 15:55:00 | 16:23:00 | 16:58:00 | 17:32:00
20 | 14:13:00 | 14:52:00 | 15:17:00 | 15:41:00 | 16:12:00 | 16:43:00 | 17:22:00 | 18:00:00
15 | 14:24:00 | 15:20:00 | 15:39:00 | 15:57:00 | 16:28:00 | 16:58:00 | 17:45:00 | 18:31:00
10 | 15:10:00 | 15:52:00 | 16:10:00 | 16:28:00 | 16:59:00 | 17:29:00 | 18:22:00 | 19:15:00
5 | 16:12:00 | 16:27:00 | 17:10:00 | 17:23:00 | 17:57:00 | 18:31:00 | 19:18:00 | 20:04:00
1 | 17:48:00 | 18:00:00 | 18:26:00 | 18:51:00 | 19:14:00 | 19:36:00 | 20:17:00 | 20:57:00
Spreadsheet: 06569866-863a-43c0-9d55-f8ffd3769912
Sheet: Sheet1

Political Subdivision | Receipts | Deductions | Total Dist
Beloit Village | 0 |  | 0
Campbell City | 12112.46 | 144.51 | 11967.95
Canfield City | 102123.68 | 1346.84 | 100776.84
[NAME] Village | 249.62 | 2.97 | 246.65
New Middletown Village | 0 | 0 | 0
Poland Village | 166173.58 | 1982.6 | 164190.98
Sebring City | 146227.02 | 1744.64 | 144482.38
Struthers City | 21314.48 | 302.13 | 21012.35
Youngstown City | 497087.97 | 5960.8 | 491127.17
Austintown Twp | 287207.28 | 3426.65 | 283780.63
[NAME] | 25853.99 | 309.12 | 25544.87
[NAME] | 18727.2 | 223.43 | 18503.77
[NAME] | 2008589.03 | 23970.93 | 1984618.1
[NAME] | 337093.79 | 4214.23 | 332879.56
Coitsville Twp | 0 | 0 | 0
Ellsworth Twp | 173706.2 | 2072.48 | 171633.72
Fairfield Twp | 0 | 0 | 0
Goshen Twp | 5618.42 | 67.03 | 5551.39
Green Twp | 5326.48 | 75.86 | 5250.62
[NAME] | 0 | 0 | 0
[NAME] | 93783.77 | 1118.93 | 92664.84000000001
Poland Twp | 25322.12 | 302.11 | 25020.01
Smith Twp | 47458.65 | 566.22 | 46892.43
Springfield Twp | 25819.31 | 308.05 | 25511.26
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
Spreadsheet: 837174d1689905893-using-a-lookup-matrix-for-a-match-results-in-a-quoted-value-that-return-an-error-filtertest
Sheet: Sheet1

0 | 0 | 0 | 1 | 0
LateStart | EarlyQuit | NoShow | L5 | LNL
Row Labels | Account Executive | LS Min | Ct of LS | EQ Min | Ct of EQ | All_Day Abs | L5 Min | Ct of L5 | LunchNotLogged |  | | v |  |  |  | | v
2023-07-03 00:00:00 | [NAME] | 5 | 0 | 29 | 1 | 0 | 268 | 0 | 0 |  |  | [NAME] | 334 |  |  | [NAME] | 334
2023-07-03 00:00:00 | [NAME] | 22 | 1 | 476 | 1 | 0 | -502 | 0 | 0 |  | 2023-07-12 00:00:00 | Tarzan | 233 |  | 2023-07-12 00:00:00 | Tarzan | 233
2023-07-06 00:00:00 | [NAME] | -2 | 0 | 30 | 1 | 0 | 263 | 0 | 0 |  | 2023-07-12 00:00:00 | [NAME] | 194 |  | 2023-07-12 00:00:00 | [NAME] | 194
2023-07-06 00:00:00 | [NAME] | 1 | 0 | 84 | 1 | 0 | 334 | 1 | 0 |  | 2023-07-13 00:00:00 | [NAME] | 326 |  | 2023-07-13 00:00:00 | [NAME] | 326
2023-07-06 00:00:00 | Tarzan | 2 | 0 | 405 | 1 | 0 | -332 | 0 | 0
2023-07-07 00:00:00 | [NAME] | 6 | 1 | 146 | 1 | 0 | 233 | 0 | 0
2023-07-07 00:00:00 | [NAME] | -2 | 0 | 345 | 1 | 0 | -568 | 0 | 0
2023-07-11 00:00:00 | [NAME] | -2 | 0 | 32 | 1 | 0 | 258 | 0 | 0
2023-07-12 00:00:00 | [NAME] | 18 | 1 | 30 | 1 | 0 | -318 | 0 | 1
2023-07-12 00:00:00 | Tarzan | -61 | 0 | 60 | 1 | 0 | 233 | 1 | 0
2023-07-12 00:00:00 | [NAME] | -56 | 0 | 53 | 1 | 0 | 194 | 1 | 0
2023-07-13 00:00:00 | [NAME] | 3 | 0 | 17 | 1 | 0 | 249 | 0 | 0
2023-07-13 00:00:00 | [NAME] | 9 | 1 | 70 | 1 | 0 | 326 | 1 | 0
2023-07-14 00:00:00 | [NAME] | -12 | 0 | 44 | 1 | 0 | 277 | 0 | 0
2023-07-14 00:00:00 | Tarzan | 0 | 0 | 299 | 1 | 0 | -360 | 0 | 0
2023-07-14 00:00:00 | [NAME] | -11 | 0 | 191 | 1 | 0 | 259 | 0 | 0
2023-07-17 00:00:00 | [NAME] | -7 | 0 | 547 | 1 | 0 | -383 | 0 | 0
2023-07-17 00:00:00 | [NAME] | -12 | 0 | 120 | 1 | 0 | 253 | 0 | 0
Grand Total |  | -99 | 4 | 2978 | 18 | 0 | 684 | 4 | 1
Spreadsheet: 34188d1231340431-copying-without-the-blank-rows-copy-without-the-extra-rows
Sheet: Sheet1

AccNo | Balance
120422 | 870
120461 | 1180
120506 | 852
120568 | 2545
120731 | -2193
120772 | 159
120979 | 807
121010 | 240
121061 | 681
123444 | 100
55555 | 111