tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 882898d1731365651-filter-vstack-multiple-tables-and-criteria-my-step-by-step-time-sheet-so-i-can-filter-_r2
Sheet: ThisMonth

Trainer Name | Student name: (first name, last name) | What action have you taken? | Session date: | How was the training conducted? | Travel time costs (if any) | What was training subject 1? (select from drop down list) | Training subject 1 - how much time () did you train on this today? (select from drop down list) | What was training subject 2? (select from drop down list) | Training subject 2 (if appropriate) - how much time (hours) did you train on this today? | Rate | Count | Value | TORF Ref #
[NAME] | [NAME] | I have completed a TNA | 2024-11-01 00:00:00 | Remote training via Zoom video conferencing |  |  |  |  |  | 50 | 1 | 50 | TORF# 18243340
[NAME] | [NAME] | I am submitting a student progress update | 2024-11-06 00:00:00 |  |  |  |  |  |  | 20 | 1 | 20 | TORF# 18255693
[NAME] | [NAME] | I have completed today's training | 2024-11-05 00:00:00 | Remote training via Zoom video conferencing |  | MS Excel | 1.5 |  |  | 31.5 | 1.5 | 47.25 | TORF# 18255919
[NAME] | [NAME] | I have completed today's training | 2024-11-05 00:00:00 | Remote training via Zoom video conferencing |  | Internet Google Chrome | 1 | Windows | 0.5 | 31.5 | 1.5 | 47.25 | TORF# 18255925
[NAME] | [NAME] | I have completed today's training | 2024-11-06 00:00:00 | Remote training via Zoom video conferencing |  | Google Drive | 1.5 |  |  | 31.5 | 1.5 | 47.25 | TORF# 18255943
[NAME] | [NAME] | I have completed today's training | 2024-11-07 00:00:00 | Remote training via Zoom video conferencing |  | MS Excel | 1.5 |  |  | 31.5 | 1.5 | 47.25 | TORF# 18259452
[NAME] | [NAME] | I have completed today's training | 2024-11-11 00:00:00 | Remote training via Zoom video conferencing |  | Google Drive | 1 |  |  | 31.5 | [+sum] |  | TORF# 18266655
[NAME] | [NAME] | I have completed today's training | 2024-11-06 00:00:00 | Remote training via Zoom video conferencing |  | Google Drive | 1.5 |  |  | 31.5 | [+sum] |  | TORF# 18255943
[NAME] | [NAME] | I have completed today's training | 2024-11-11 00:00:00 | Remote training via Zoom video conferencing |  | MS Excel | 2 |  |  | 31.5 | [+sum] |  | TORF# 18266692
[NAME] | [NAME] | I have completed today's training | 2024-11-04 00:00:00 | Remote training via Zoom video conferencing |  | MS Excel | 2 |  |  | 31.5 | [+sum] |  | TORF# 18266705
Spreadsheet: e3bcc62f-aa2f-463b-a991-840feecb1f8f
Sheet: MAY

SEATTLE UNIVERSITY
NON-EXEMPT EMPLOYEE TIME REPORT
NAME: |  |  |  |  | DEPT: |  |  | (Use 4 letter-code as shown on paystub under DEPT)
Datatel ID Number or SSN:
PE: |  | 2015-05-01 00:00:00 | TO | 2015-05-31 00:00:00 |  | MO. NO.: |  | 5
Holiday Pay |  |  |  | HP | 4
Sick Pay |  |  |  | SP
Vacation Pay |  |  |  | VP
[NAME] |  |  |  | BR |  | (up to 5 days of paid leave)
Jury Duty Leave |  |  |  | JL
[NAME] |  |  |  | DP
 |  |  |  |  |  |  |  |  | Employee Signature |  |  |  | Date
Regular Pay |  |  |  | RP
SUB-TOTAL |  |  |  |  | 84 |  |  |  | Supervisor Signature |  |  |  | Date
Overtime (1.0 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is between 37.50 and 40)
Overtime (1.5 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is above 40)
TOTAL
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  | 1 |  | 2
 |  |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9
 |  |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 10 |  | 11 |  | 12 |  | 13 |  | 14 | Time sheets due | 15 |  | 16
 |  |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 17 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23
 |  | HP | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 24 |  | 25 |  | 26 |  | 27 |  | 28 | Pay day | 29 |  | 30
 | 31
REMEMBER: Adjustment from Prior Month!! INCLUDE PRIOR MONTH ADJ HOURS IN THE ABOVE CALCULATION!
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: White

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 4d2d3da9-8a85-4f66-8aba-8483ee13fb7d
Sheet: Blank Form

LOGIC MODEL:  Program [NAME]
SITUATION |  | OUTCOMES* - IMPACT |  |  |  | OUTPUTS |  |  |  | INPUTS
 |  | Long Term | Intermediate | Short Term
 |  | What the ultimate impact(s) is/are | What the intermediate results are | What the short term results are |  | Who we reach | What we do | Educational Product |  | What we invest
 |  | Conditions* | Action* | Learning*
 |  | * Outcome statements include indicators
Points for consideration:
ASSUMPTIONS |  |  |  |  |  | ENVIRONMENT (External Factors)
1.
2.
3.
4.
EVALUATION
Focus - Collect Data - Analyze and Interpret - Report
Spreadsheet: 47098d1246008567-how-to-count-all-data-from-the-field-in-pivot-example-excel-pivot-issue
Sheet: Sheet1

 | Country | Product | Revenue |  | Sum of Revenue |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | ALL |  | 1 | ALL
 | Czech republic | A | 101.2881320812256 |  | Product | Country | Total |  |  |  |  |  |  |  |  |  |  |  | 2 | Czech republic |  | 2 | A
 | Czech republic | B | 795.6520509803142 |  | A | Czech republic | 101.2881320812256 |  |  |  |  |  |  |  |  |  |  |  | 3 | Hungary |  | 3 | B
 | Czech republic | C | 415.6362773670863 |  |  | Hungary | 441.3680977149698 |  |  |  |  |  |  |  |  |  |  |  | 4 | Poland |  | 4 | C
 | Czech republic | D | 53.42052421041777 |  |  | Poland | 940.4890277299525 |  |  |  |  |  |  |  |  |  |  |  | 5 | Slovakia |  | 5 | D
 | Hungary | A | 441.3680977149698 |  |  | Slovakia | 338.7772940599207
 | Hungary | B | 215.0047142012486 |  | A Total |  | 1821.922551586068
 | Hungary | C | 522.2368634276588 |  | B | Czech republic | 795.6520509803142
 | Hungary | D | 15.38114965935033 |  |  | Hungary | 215.0047142012486
 | Poland | A | 940.4890277299525 |  |  | Poland | 58.1376329532679
 | Poland | B | 58.1376329532679 |  |  | Slovakia | 938.9405748435142
 | Poland | C | 246.2288412455009 |  | B Total |  | 2007.734972978345
 | Poland | D | 348.8264484642072 |  | C | Czech republic | 415.6362773670863
 | Slovakia | A | 338.7772940599207 |  |  | Hungary | 522.2368634276588
 | Slovakia | B | 938.9405748435142 |  |  | Poland | 246.2288412455009
 | Slovakia | C | 666.8563112781352 |  |  | Slovakia | 666.8563112781352
 | Slovakia | D | 708.7722925193148 |  | C Total |  | 1850.958293318381
 |  |  |  |  | D | Czech republic | 53.42052421041777
 |  |  |  |  |  | Hungary | 15.38114965935033
 |  |  |  |  |  | Poland | 348.8264484642072
 |  |  |  |  |  | Slovakia | 708.7722925193148
 |  |  |  |  | D Total |  | 1126.40041485329
 | Country |  |  |  | Grand Total |  | 6807.016232736085
 | 2
 | Product
 | 2
 | Revenue |  |  |  | how to get data of Product A for ALL countries?
 |  |  |  |  | or how to get data of ALL Products in Czech republic only?
 |  |  |  |  | the GETPIVOTDATA function does not allow me to calculate ALL...or does somehow?
Spreadsheet: 113790d1309644205-macro-to-copy-toggle-button-and-behaviour-start-again_home30_6
Sheet: 1_4_10_to_31_3_11

40279 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | for sw | taxable amount
 |  |  |  |  | Homebase Hours / Pay Calculation Forms 1/4/10 – 31/3/11
 |  |  |  |  |  | Please complete the fields in the orange boxes only
Rates per child per day: | 5.2 | Trained - for first six hours
 | 4.8 | After first six hours
 | 4.8 | Less than one weeks notice of childs absence
 | 3.4 | More than one weeks notice of childs absence |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 170.7225 | 96.3275000000001
Other Rates: | 4 | Educator illness
 | 0.62 | Travel per kilometer
Week ending:
2010-04-04 00:00:00 | Daily Hours |  |  |  |  | Weekly Total Hours | Enter hours against $5.20 rate |  | Enter hours against $4.80 rate |  | Enter hours against $4.00 rate |  | Enter hours against at $3.40 rate |  | Gross income | Travel |  | Gross Income
 | Mon | [NAME] | Wed | Thur | Fri | Total Hrs | Hours | Total $ | Hours | Total $ | Hours | Total $ | Hours | Total $ | Subtotal | KMS | Kms x .62c | TOTAL
Child 1 |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
Child 2 |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
Child 3 |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
Child 4 |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Week ending:
2010-04-11 00:00:00 | Daily Hours |  |  |  |  | Weekly Total Hours | Enter hours against $5.20 rate |  | Enter hours against $4.80 rate |  | Enter hours against $4.00 rate |  | Enter hours against at $3.40 rate |  | Gross income | Travel |  | Gross Income
 | Mon | [NAME] | Wed | Thur | Fri | Total Hrs | Hours | Total $ | Hours | Total $ | Hours | Total $ | Hours | Total $ | Subtotal | KMS | Kms x .62c | TOTAL
Child 1 |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
Child 2 |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
Child 3 |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
Child 4 |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: phillip_allen__28806__ngi
Sheet: Sheet1

 | SOCAL
 | Basis | Fix/Float | GD Index | Act. Settle | Published GD
2000-06-26 00:00:00 | 0.325 | 4.885 | I + .0525 |  | 4.685
2000-06-27 00:00:00 | 0.33 | 5.016 | I + .05 |  | 4.83
2000-06-28 00:00:00 | 0.58 | 4.949 | I + .04 |  | 5.09
2000-06-29 00:00:00 | 0.58 | 4.949 | I + .03 |  | 5.105
2000-06-30 00:00:00 |  |  |  |  | 4.825
2000-07-01 00:00:00 |  |  |  | 4.91 | 4.73
2000-07-05 00:00:00 |  |  |  |  | 4.73
2000-07-06 00:00:00 |  |  |  |  | 4.84
2000-07-07 00:00:00 |  |  |  |  | 4.555
2000-07-10 00:00:00 |  |  |  |  | 4.135
2000-07-11 00:00:00 |  |  |  |  | 4.74
2000-07-25 00:00:00 | 0.855 | 4.515 | I + .06 |  | 4.625
2000-07-26 00:00:00 | 0.75 | 4.513 | I + .06 |  | 4.53
2000-07-27 00:00:00 | 0.69 | 4.51 | I + .05 |  | 4.53
2000-07-28 00:00:00 | 0.72 | 4.54 | I + .04 |  | 4.62
2000-07-29 00:00:00 |  |  |  |  | 4.605
2000-08-01 00:00:00 |  |  |  | 4.49 | 4.615
2000-08-02 00:00:00 |  |  |  |  | 4.535
2000-08-03 00:00:00 |  |  |  |  | 4.645
2000-08-04 00:00:00 |  |  |  |  | 4.755
2000-08-05 00:00:00 |  |  |  |  | 4.75
 | SJ
 | Basis | Fix/Float |  | Act. Settle | Published GD
2000-06-26 00:00:00 | -0.365 | 4.195 |  |  | 3.94
2000-06-27 00:00:00 | -0.395 | 4.291 |  |  | 4.045
2000-06-28 00:00:00 | -0.23 | 4.138999999999999 |  |  | 4.215
2000-06-29 00:00:00 | -0.23 | 4.138999999999999 |  |  | 4.165
2000-06-30 00:00:00 |  |  |  |  | 3.91
2000-07-01 00:00:00 |  |  |  | 4.12 | 3.945
2000-07-05 00:00:00 |  |  |  |  | 3.945
2000-07-06 00:00:00 |  |  |  |  | 3.96
2000-07-07 00:00:00 |  |  |  |  | 3.655
2000-07-10 00:00:00 |  |  |  |  | 3.39
2000-07-11 00:00:00 |  |  |  |  | 3.82
2000-07-25 00:00:00 | -0.1675 | 3.4925 |  |  | 3.575
2000-07-26 00:00:00 | -0.2325 | 3.5305 |  |  | 3.475
2000-07-27 00:00:00 | -0.34 | 3.48 |  |  | 3.46
2000-07-28 00:00:00 | -0.32 | 3.5 |  |  | 3.53
2000-07-29 00:00:00 |  |  |  |  | 3.505
2000-08-01 00:00:00 |  |  |  | 3.5 | 3.515
2000-08-02 00:00:00 |  |  |  |  | 3.495
2000-08-03 00:00:00 |  |  |  |  | 3.625
2000-08-04 00:00:00 |  |  |  |  | 3.475
2000-08-05 00:00:00 |  |  |  |  | 3.29
 | SOCAL/SJ SPREAD
 | Basis |  |  | Act. Settle | Published GD
2000-06-26 00:00:00 | 0.69 |  |  |  | 0.745
2000-06-27 00:00:00 | 0.725 |  |  |  | 0.785
2000-06-28 00:00:00 | 0.81 |  |  |  | 0.875
2000-06-29 00:00:00 | 0.81 |  |  |  | 0.94
2000-06-30 00:00:00 |  |  |  |  | 0.915
2000-07-01 00:00:00 |  |  |  | 0.79 | 0.7850000000000006
2000-07-05 00:00:00 |  |  |  |  | 0.7850000000000006
2000-07-06 00:00:00 |  |  |  |  | 0.88
2000-07-07 00:00:00 |  |  |  |  | 0.9
2000-07-10 00:00:00 |  |  |  |  | 0.745
2000-07-11 00:00:00 |  |  |  |  | 0.92
2000-07-25 00:00:00 | 1.0225 |  |  |  | 1.05
2000-07-26 00:00:00 | 0.9825 |  |  |  | 1.055
2000-07-27 00:00:00 | 1.03 |  |  |  | 1.07
2000-07-28 00:00:00 | 1.04 |  |  |  | 1.09
2000-07-29 00:00:00 |  |  |  |  | 1.1
2000-08-01 00:00:00 |  |  |  | 0.99 | 1.1
2000-08-02 00:00:00 |  |  |  |  | 1.04
2000-08-03 00:00:00 |  |  |  |  | 1.02
2000-08-04 00:00:00 |  |  |  |  | 1.28
2000-08-05 00:00:00 |  |  |  |  | 1.46
Spreadsheet: 300672d1393532566-using-autotext-hours
Sheet: Hours

Date | Name | Hours | Trade | Rate | Total
 | [NAME] | 5 | Mechanic | 20
 | [NAME] | 4 | [NAME] | 40
 | [NAME] | 10 | Fencer | 15
 | [NAME] | 11 | [NAME] | 25
 | [NAME] | 2 | Electrician | 45
 | [NAME] | 5 | [NAME] | 40
 | [NAME] | 8 | Cabinet Maker | 40
 | [NAME] | 2 | Cladder | 25
 | [NAME] | 7 | Fencer | 30
 | [NAME] | 4 | [NAME] | 40
Spreadsheet: 546564d1510092961-pivot-table-with-blanket-rows-pivot-table
Sheet: Sheet1

AC | Customer | Product | Description | Sales
1 | Amazon | Result |  | 6010.87
 |  | 121 | Fitting A | 65.7
 |  | 122 | Fitting B | 4447.46
 |  | 123 | Fitting C | 26.44
 |  | 129 | Fitting D | 313.36
 |  | 133 | Fitting E | 78.84
 |  | 134 | Fitting F | 30.7
 |  | 135 | Fitting G | 58.6
 |  | 138 | Fitting H | 989.77
2 | Ebay | 122 | Fitting B | 122.94
3 | Walmart | Result |  | 1965.28
 |  | 0 | No Code
 |  | 122 | Fitting B | 1965.28
Spreadsheet: 2f66cca4-eb08-4221-8b57-ced33e14cf31
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
Tobacco Use Prevention Program
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  |  | x | No |  | Yes
 |  |  |  |  | Governmental Grants Fund
 | Revenue Detail |  |  |  | FY 2007-08 |  | FY 2008-09 |  | TOTAL
 | General Fund
 | Special Revenue |  |  |  | 65357 |  | 9594 |  | 74951
 | Enterprise |  |  |  |  |  | 0
 |  |  | Total: | $ | 65357 |  | 9594 |  | 74951
Grant revenue to implement Tobacco Use Prevention Program, funds were reduced by $10,049.00 from last year.
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  |  | x | No |  | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY07-08 |  | FY 2008-09
 | General Fund
 | Special Revenue
 | Enterprise/Other
 |  |  | Total: | $
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  |  | x | No |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  |  | x | No |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 218631d1362516201-need-help-with-nested-if-and-statement-subnet-calculator
Sheet: Sheet1

128 | 64 | 32 | 16 | 8 | 4 | 2 | 1 | 128 | 64 | 32 | 16 | 8 | 4 | 2 | 1 | 128 | 64 | 32 | 16 | 8 | 4 | 2 | 1 | 128 | 64 | 32 | 16 | 8 | 4 | 2 | 1
IP Address and Subnet Mask
IP Address
 | . |  | . |  | .
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
And
Subnet Mask
 | . |  | . |  | .
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
=
Subnet IP Address (Host) |  |  |  |  |  |  |  |  |  |  | ****Reminder - Address that ends in xxx.xxx.xxx.0 can't be used (.0 is the network address)****
 | . |  | . |  | .
****NOTE: IF IP and Subnet match 1 and 1 then it equals 1, all other combinations are 0****
IP address and Inverse Subnet Mask
IP Address
 | . |  | . |  | .
And
Inverse Subnet Mask
 | . |  | . |  | .
=
Broadcast IP Address |  |  |  |  |  |  |  |  |  |  | ****Reminder - Address that ends in xxx.xxx.xxx.255 can't be used (.255 is the network broadcast address)****
 | . |  | . |  | .
****NOTE: If IP and Subnet match 0 and 0, then it will be 0, all other combinations are 1****
Spreadsheet: 113378d1309295616-auto-populate-a-cell-when-3-options-are-selected-all-skus
Sheet: Towels - 2098

Product | P-Code | Size | S-Code | Color | C-Code |  | SKU |  | UPC
Towels | 2098 | Wash | 1 | Ivory | 20 |  | 20980120
Towels | 2098 | Wash | 1 | White | 21 |  | 20980121 |  | 859110002561
Towels | 2098 | Wash | 1 | Sage | 22 |  | 20980122
Towels | 2098 | Wash | 1 | Blue | 30 |  | 20980130
Towels | 2098 | Wash | 1 | [NAME] | 31 |  | 20980131
Towels | 2098 | Wash | 1 | Plum | 32 |  | 20980132
Towels | 2098 | Hand | 2 | Ivory | 20 |  | 20980220
Towels | 2098 | Hand | 2 | White | 21 |  | 20980221 |  | 859110002578
Towels | 2098 | Hand | 2 | Sage | 22 |  | 20980222
Towels | 2098 | Hand | 2 | Blue | 30 |  | 20980230
Towels | 2098 | Hand | 2 | [NAME] | 31 |  | 20980231
Towels | 2098 | Hand | 2 | Plum | 32 |  | 20980232
Towels | 2098 | Bath | 3 | Ivory | 20 |  | 20980320
Towels | 2098 | Bath | 3 | White | 21 |  | 20980321 |  | 859110002585
Towels | 2098 | Bath | 3 | Sage | 22 |  | 20980322
Towels | 2098 | Bath | 3 | Blue | 30 |  | 20980330
Towels | 2098 | Bath | 3 | [NAME] | 31 |  | 20980331
Towels | 2098 | Bath | 3 | Plum | 32 |  | 20980332
Towels | 2098 | Bath Sheets | 4 | Ivory | 20 |  | 20980420
Towels | 2098 | Bath Sheets | 4 | White | 21 |  | 20980421 |  | 859110002592
Towels | 2098 | Bath Sheets | 4 | Sage | 22 |  | 20980422
Towels | 2098 | Bath Sheets | 4 | Blue | 30 |  | 20980430
Towels | 2098 | Bath Sheets | 4 | [NAME] | 31 |  | 20980431
Towels | 2098 | Bath Sheets | 4 | Plum | 32 |  | 20980432
Spreadsheet: 797124d1663718666-find-a-number-in-a-list-and-return-outcome-but-number-is-in-a-long-string-within-the-cell-what-im-looking-for
Sheet: Sheet1

Determined Outcome | Customer Information | The List | Possible Outcomes
This is what I want populated
g | [NAME], [NAME] ERT/YUT | 1 | a
 |  | 2 | b
 |  | 3 | c
 |  | 4 | d
 |  | 5 | e
 |  | 324 | f
 |  | 325 | g
 |  | 326 | h
Spreadsheet: 921a575a-c9e1-458a-8b60-88b342c2d7f0
Sheet: Sheet1

Unnamed: 0 | id | Alunni | Media | Italiano | Inglese | Francese | Storia | Geografia | Matematica | Scienze | Tecnologia | Musica | Arte e Immagine | Educazione Fisica | Comportamento | Religione
 | 5853 | [NAME] | 6.98 |  | 6.7 | 8.3 | 7.4 | 7.1 | 6.2 | 7.5 | 6.8 | 6.3 | 7.5 | 6
 | 5854 | BOGLIONI ALESSANDRO MARIO | 9.02 |  | 9.2 | 9.7 | 9.4 | 9.5 | 9.1 | 9.2 | 9.3 | 8.6 | 9 | 7.2 |  | Distinto
 | 5855 | BOSCARO MASSIMO | 7.58 |  | 7.8 | 8.3 | 8.2 | 7.8 | 7.9 | 8.2 | 5.7 | 7 | 8.2 | 6.7 |  | Discreto
 | 5856 | CAPUTO ALESSANDRO | 7.18 |  | 6.4 | 7 | 7.4 | 7.4 | 7 | 6.2 | 6.6 | 7.8 | 8 | 8 |  | Buono
 | 5857 | CORSARO ILARIA | 7.04 |  | 6.8 | 8.2 | 6.8 | 7.5 | 7.2 | 5.8 | 6.2 | 6.6 | 8.3 | 7 |  | Sufficiente
 | 5858 | DALE' NICLA | 5.84 |  | 5.8 | 6.8 | 5.6 | 4.7 | 4.8 | 5.8 | 5.8 | 5.8 | 6.5 | 6.8
 | 5859 | DE VECCHI ALESSANDRO | 9.26 |  | 9.4 | 9.9 | 9.6 | 9.8 | 9.2 | 9.2 | 8.8 | 9.9 | 9.8 | 7 |  | Ottimo
 | 5860 | FAWZY YOUAKIM VALENTINA | 7.56 |  | 8.1 | 8.6 | 7.8 | 7.8 | 7 | 7.3 | 6.2 | 7.5 | 8 | 7.3 |  | Buono
 | 5862 | [NAME]' MARICA | 8.41 |  | 9.6 | 9.2 | 8.2 | 8.2 | 7.5 | 8 | 6.6 | 8.8 | 10 | 8 |  | Distinto
 | 5863 | GARIBOLDI FILIPPO | 7.3 |  | 8.3 | 8.2 | 7.9 | 6.5 | 7 | 7.2 | 5.9 | 8.2 | 7.8 | 6 |  | Buono
 | 5864 | [NAME] | 7.87 |  | 7.4 | 8.7 | 8.2 | 8.4 | 7.8 | 7.2 | 7.1 | 7.2 | 9 | 7.7 |  | Buono
 | 5865 | GREMI OSMEN | 6.68 |  | 6.8 | 6 | 7.5 | 6.5 | 6.5 | 7.2 | 6.1 | 6.9 | 6.3 | 7
 | 5866 | JOVANOVIC DUSKO | 5.16 |  | 6 | 7.1 | 5.4 | 4 | 4 | 6 | 4.4 | 4 |  | 5.5 |  | Discreto
 | 6435 | LIN RIXIN | 6.44 |  | 6.4 | 5.9 | 5.7 | 5 | 6.6 | 7 | 6.8 | 6.9 |  | 7.7
 | 5867 | MESSINA GIULIA | 7.07 |  | 7.6 | 8.6 | 7.9 | 7.3 | 6.6 | 5.8 | 5.2 | 8.2 | 6.8 | 6.7 |  | Discreto
 | 5868 | METUSHI ISAURA | 6.41 |  | 6.5 | 6.8 | 5.6 | 5.3 | 5.9 | 6.2 | 5.6 | 7.5 | 8 | 6.7 |  | Non sufficiente
 | 5869 | OSNAGHI RICCARDO | 8.26 |  | 7 | 9 | 8.7 | 9.1 | 8.6 | 7.8 | 7.7 | 8.4 | 8.8 | 7.5 |  | Distinto
 | 5870 | PAONE FEDERICO | 7.89 |  | 7.4 | 9.1 | 8.5 | 9.4 | 7.4 | 7.2 | 5.8 | 8.6 | 8 | 7.5 |  | Buono
 | 5871 | PARINI ALESSIO | 8.78 |  | 8.8 | 9.8 | 9.5 | 9.6 | 9.2 | 9.2 | 7.5 | 9.1 | 7.9 | 7.2 |  | Distinto
 | 5872 | RANZANI MATTEO | 8.05 |  | 7.9 | 9.4 | 8.7 | 9.4 | 7.6 | 8.2 | 6.8 | 8.8 | 7.2 | 6.5 |  | Distinto
 | 5873 | RIZZI SERENA | 7.07 |  | 7.2 | 8 | 8 | 7.6 | 6.8 | 6.5 | 5.7 | 7.1 | 7 | 6.8 |  | Discreto
 | 5874 | TODIROI ALINA | 5.79 |  | 5.6 | 7.2 | 6 | 4.8 | 4.6 | 5.7 | 4.8 | 6.1 | 6.8 | 6.3
 | 5875 | TREZZI [NAME] | 7.24 |  | 8.1 | 7.8 | 8.3 | 7.2 | 7.4 | 7.2 | 4.9 | 7.2 | 7.8 | 6.5 |  | Sufficiente
 | 5876 | VALENTI KELIS | 7.75 |  | 8 | 9.3 | 8.6 | 7.6 | 7.9 | 7 | 6.3 | 8.5 | 7.5 | 6.8 |  | Sufficiente
 | 7252 | [NAME]
Spreadsheet: 746286d1630605247-converting-the-structure-of-raw-data-into-a-usable-format-sample-bom
Sheet: Sheet1

Level | Part |  |  | Parent Part | Material
0 | ABC |  |  | ABC | BC
1 | BC |  |  | BC | B
2 | B |  |  | BC | C
2 | C |  |  | DEF | DF
0 | DEF |  |  | DF | D
1 | DF |  |  | DF | F
2 | D
2 | F
Spreadsheet: 9d8d9afe-aa4f-40c7-aa25-03dba9f0bad1
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
PIPU | Test | PIPU | Pipecolic Acid, [NAME] | Pipecolic Acid, U | Gas Chromatography-Mass Spectrometry (GC-MS) | [NAME]: Urine |  |  | 5 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 5 mL Collection Instructions:  1. Collect a random urine specimen. 2. No preservative. Additional Information: Patient's age is required. Forms: 1.	1. 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. 2.	2. If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 2 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | <1 month: < or =223.8 nmol/mg creatinine 1-6 months: < or =123.1 nmol/mg creatinine 6 months-<1 year: < or =45.0 nmol/mg creatinine > or =1 year: < or =5.7 nmol/mg creatinine | Varies; Batched 2 times per month; 8:00 a.m. | 2 days | 31 days | 1 | 82543 |  |  |  |  | Rochester
PIPU | [NAME] | URINE | [NAME] |  |  |  | Frozen | 30 days
PIPU | Result | 81248 | Pipecolic Acid, U | Pipecolic Acid, U | Numeric |  |  |  |  | [NAME]/mg Cr |  |  |  |  |  |  |  |  |  | 47727-3 | Pipecolate/Creatinine:ScRto:Pt:[NAME]:Qn:
PIPU | Result | 29952 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
PIPU | Result | 29954 | Reviewed By | Reviewed By | Numeric