tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 61963d1262871371-poker-payout-calculator-percentage-calculator
Sheet: Sheet1

Buy-in amount £ |  |  | Total £ | 0
No. of buy-ins
Total £ |  |  |  |  | 1 to 6 |  | 7 to 20 |  | 21 to 30 |  | >30
1 |  |  | 1 | 0.75 |  | 0.5 |  | 0.5 |  | 0.4
2 |  |  | 2 | 0.25 |  | 0.3 |  | 0.25 |  | 0.25
3 |  |  | 3 |  |  | 0.2 |  | 0.15 |  | 0.2
4 |  |  | 4 |  |  |  |  | 0.1 |  | 0.1
5 |  |  | 5 |  |  |  |  |  |  | 0.05
I'd like the table on the left to show the same results as the table on the right but using a simpler format. I have used a simple formula to calculate the total cash pot available by  multiplying the buy in amount by the number of buy ins. What I require is that the payout positions 1-5 are automatically generated based on the number of buy-ins. For example if the total number of buy ins is <7 then only positions 1 and 2 are filled but if the number of buy ins is between 21 and 30 then the top 4 places are filled in, all based on the percentages of the total cash available shown in B3. The table on the right is one i currently use and works but is a little bigger than it needs to be. Would it also be possible to show the percentages of the cash pot along with the £ amount for reference. The buy in amount is variable depending on tournament so the table needs to allow for this. Feel free to add/remove columns/edit as necessary.
Spreadsheet: 768371d1644938767-trying-to-look-up-and-filter-data-example
Sheet: KROK050

KROK050
Product | Component name | Result text
Spreadsheet: 1fd0471d-6d3e-4d7c-ac7b-a7471f93913b
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
FADV | Test | FADV | [NAME], Serum | [NAME], Serum | Complement Fixation (CF) | Plain, Red-Top or serum gel tube: Red |  |  | 1 | mL | Draw blood in a plain, red-top tube. Spin down and send 1 mL of serum at ambient temperature. Note: Serum gel tube is acceptable, but must be poured off into plastic vial. | 0.5 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | Reference Range:  <1:8  Interpretive Criteria:                      <1:8  Antibody Not Detected              > or =1:8  Antibody Detected  Single titers of > or =1:64 are indicative of recent or current infection. Titers of 1:8-1:32 may be indicative of either past or recent infection, since CF antibody levels persist for only a few months. A four-fold or greater increase in titer between acute and convalescent specimens confirms the diagnosis.  Test Performed By:  Focus Diagnostics, Inc.                                         5785 Corporate Ave.                                         Cypress, CA  90630-4750 | Monday through Friday | 2 - 5 days | 4 - 7 days | 1 | 86603 |  |  |  |  | Focus Diagnositics, Inc.
FADV | [NAME] | SERUM | Serum |  |  |  | Ambient | 7 days
FADV | Result | Z0737 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 888959d1739591557-conditional-formatting-as-a-function-of-rank-or-average-ideally-i-learn-how-to-do-both-hero-stat-list-thatismyfeet-
Sheet: Sheet1

Level | OrangeMats
5 | 0.125
10 | 0.40625 |  |  | # | %Orange
15 | 1.0325 |  |  | 32 | 0.03125
20 | 2.59375 |  |  | 8 | 0.125
25 | 5.0625 |  |  | 2 | 0.5
30 | 8.96875 |  |  | 1 | 1
35 | 14.96875
40 | 24.125
45 | 38
50 | 58.8125
55 | 90.1875
60 | 137.125
65 | 207.3125
70 | 363.5625
75 | 560.4375
80 | 772.9375
85 | 1001.0625
90 | 1269.1875
95 | 1681.3125
100
105
Spreadsheet: 867519d1714384906-using-array-formula-and-relative-referencing-most-efficiently-map-for-array-aligw
Sheet: Sheet1

 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
Spreadsheet: 12d802d3-ed75-4c4b-ae80-380197cc8b1d
Sheet: Sheet1

Mix | Quantity | kcal | sodium (mEq) | sodium (mg) | potassium (mEq) | potassium (mg) | citrate
Gatorade/cup | 1
G2/cup | 1
Ceralyte 50/cup | 1
Ceralyte 70/cup | 1
Ceralyte 90/cup | 1
[NAME] | 1
Pedialyte/cup | 1
Sugar/tsp | 1
Salt/tsp | 0.25
Water | 1
Total:
 |  |  |  | Created by [NAME], MS RD CNSC, July 2013
Spreadsheet: 106898d1304031705-setting-up-formulas-to-pull-data-from-another-sheet-accident-incident-report-log
Sheet: Stats

 | 2011 | Q1 | Q2 | Q3 | Q4
Accident | 5 | 2 | 2 | 0 | 1
Incident | 4 | 0 | 2 | 1 | 1 |  |  |  | 2011-01-01 00:00:00 | 40544
Totals | 9 | 2 | 4 | 1 | 2 |  |  |  | 2011-04-01 00:00:00 | 40634
 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 40725
Accidents |  |  |  |  |  |  |  |  | 2011-10-01 00:00:00 | 40817
Cut | 1 |  |  |  |  |  |  |  | 2012-12-01 00:00:00 | 41244
Burn | 1
Slip/Trip | 1
Struck/Caught | 0
Overexertion | 0
Fire/Explosion | 1
Assault | 0
Motor Vehicle Incident | 0
Harmful Substance/Environment | 1
Incidents
Cut | 0
Burn | 0
Slip/Trip | 0
Struck/Caught | 1
Overexertion | 1
Fire/Explosion | 0
Assault | 1
Motor Vehicle Incident | 1
Harmful Substance/Environment | 0
Spreadsheet: 93182d1292786080-dynamic-report-linked-to-pivot-table-prod-scheduling
Sheet: SUMMARY

 |  |  |  |  | MACHINE TYPE
ORD NO | START DATE | END DATE | No OF DAYS | QTY | TYPE-A | TYPE-B | TYPE-C |  | NOTE
 |  |  |  |  | 780 |  |  |  | 1 | THIS REPORT IS DERIVED FROM PIVOT-2 SHEET.
 |  |  |  |  | 288 |  |  |  | 2 | IN THIS DIFFERENT FORMULA WERE USED AS ABSOLUTE DATA
 |  |  |  |  |  |  |  |  | 3 | THE LINKED PIVOT TABLE IS [NAME], EX. IF WE ADD ANY NEW ORDER
 |  |  |  |  |  |  |  |  |  | IN THE MASTER SHEET, ON REFRESING, THE PIVOT TABLE UPDATE NEW
 |  |  |  |  |  |  |  |  |  | ORD NUMBER
 |  |  |  |  |  |  |  |  | 4 | ALSO IN THE COLUMN A THE ORD NO DETAILS ARE TAKEN FROM THE LABELS IN THE
 |  |  |  |  |  |  |  |  |  | PIVOT TABLE.  IN THIS REPORT WE HV USED ABSOLUTE VALUE BUT WHEN IT IS [NAME]
 |  |  |  |  |  |  |  |  |  | TO PIVOT, WE NEED IT TO BE DYNAMIC.
 |  |  |  |  |  |  |  |  | 5 | ALSO I AM NOT ABLE TO GET THE TOTAL QTY UNDER EACH TYPE OF MACHINES AS SHOWN
 |  |  |  |  |  |  |  |  |  | IN THE LEFT SIDE REPORT IN F3:H10 RANGE.
 |  |  |  |  |  |  |  |  | WHAT I NEED IS
 |  |  |  |  |  |  |  |  | 1 | FORMULAS IN THIS SHEET SHOULD BE DYNAMIC AND SELECT RANGES AS PER THE PIVOT TABLE
 |  |  |  |  |  |  |  |  | 2 | THE USER SHOULD NOT DO ANYTHING MANUALLY TO GET THIS REPORT BY ADJUSTING THE RANGES
 |  |  |  |  |  |  |  |  |  | MANUALLY.
Spreadsheet: 140084d1328620603-removing-a-linked-cell-tlc-client-progress
Sheet: Sofía Ernst

COURSE NAME
Clients | Felipe Ernst | Client's Name | Client's Name | Client's Name
Students | Sofia Ernst | Student's Name | Student's Name | Student's Name
Course Set Up | Date Completed | Comments
Initial contact | 1900-01-04 00:00:00 | Who?
Details added to database | 5 | Anything missing?
Evaluation coordinated | 1900-01-06 00:00:00
Date
Location
Teacher
Evaluation report sent to teacher | 7
Evaluation report received from teacher
Needs analysis conducted
Follow up contact
[NAME]
Feedback requirements
Billing option
Course plan created
Course plan translated
Client sent evaluation report, course plan & T's & C's
Client accepts T's & C's
Teacher allocated to course
Teacher availability updated
Start of course confirmed
Course and lessons added to database
Course details sent to Financial Director
Course added to end of month lessons report
Client sent teacher profile and login details
Client contacted after 1st class
Client Follow Up & Feedback | Date Completed | Comments
Follow up call 1
Follow up call 2
Follow up call 3
Follow up call 4
Client feedback 1
Client feedback 2
Client feedback 3
Course Notes | Date Completed | Comments
Note 1
Note 2
Note 3
Note 4
Note 5
Evaluations
Student | Date | Fluency | Vocab | [NAME] | Pronunciation | Level
Student 1
Student 2
Student 3
End of Course | Date Completed | Comments
Client contacted to confirm end of course |  | When will course end?
Teacher informed of end of course
End of course report sent to teacher
End of course report received from teacher
End of course report translated
End of course report sent to client
Spreadsheet: 871299d1717679253-removing-zeros-from-blank-cells-in-filter-formula-test
Sheet: Sheet1

February
 |  |  |  |  |  |  |  | *What I would like it to look like, blanks with no data and only certain columns
 | 0 | 0
2024-02-05 00:00:00 | 2024-02-06 00:00:00 | G20 - 1st Education Working Group Meeting |  |  |  |  |  | 2024-02-05 00:00:00 | 2024-02-06 00:00:00 | G20 - 1st Education Working Group Meeting | Shaping Future Governments (Theme 4: Future Societies and Education) | *There is one column skipped and I just want this info as after the title
2024-02-12 00:00:00 | 2024-02-14 00:00:00 | World Government Summit |  |  |  |  |  | 2024-02-12 00:00:00 | 2024-02-14 00:00:00 | World Government Summit | School Leadership Matters: Promoting Effective School Leadership in Africa
2024-02-15 00:00:00 | 00:00:00 | VVOB Education for Development |  |  |  |  |  | 2024-02-15 00:00:00 |  | VVOB Education for Development | Addressing global teacher shortages: Dignifying, diversifying, and valorizing the profession
2024-02-26 00:00:00 | 2024-02-29 00:00:00 | 14th International Policy Dialogue Forum on Teachers |  |  |  |  |  | 2024-02-26 00:00:00 | 2024-02-29 00:00:00 | 14th International Policy Dialogue Forum on Teachers | 2024/5 GEM Report consultation empowering teacher leadership
2024-02-26 00:00:00 | 00:00:00 | 14th International Policy Dialogue Forum on Teachers - EVENT |  |  |  |  |  | 2024-02-26 00:00:00 |  | 14th International Policy Dialogue Forum on Teachers - EVENT | 2024 SDG 4 Scorecard and trained teachers: mapping progress and data challenges
2024-02-27 00:00:00 | 00:00:00 | 14th International Policy Dialogue Forum on Teachers - EVENT |  |  |  |  |  | 2024-02-27 00:00:00 |  | 14th International Policy Dialogue Forum on Teachers - EVENT | Towards education for all: Strengthening data systems in conflict and crisis settings
2024-02-28 00:00:00 | 00:00:00 | 14th International Policy Dialogue Forum on Teachers - EVENT |  |  |  |  |  | 2024-02-28 00:00:00 |  | 14th International Policy Dialogue Forum on Teachers - EVENT
Spreadsheet: 878146d1725170258-need-formula-to-find-the-values-bainwave-formula-10-365-aligw
Sheet: Sheet1

 |  |  |  |  | [NAME]
Sl No | Flat No | Name | No of Months | Total Amount Due | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00
 |  |  |  |  | 1000 | 1000 | 1000 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500
1 | [NAME] | Rakesh Tiwari |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2 | G2 | Ananya Dube |  |  | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
3 | G3 | Tharoha |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
4 | 101 | [NAME] |  |  | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
5 | 102 | Hussain |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
6 | 103 | Deepak Singh |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
7 | 201 | Raghuveer |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
8 | 202 | MahaGanesh |  |  | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
9 | 203 | [NAME] |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
10 | 301 | [NAME] |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
11 | 302 | Siva Kumar |  |  | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
12 | 303 | Krishna |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Total
Spreadsheet: 33666d1230192108-problem-with-showing-rows-and-columns-in-a-pivot-table-pivot-table-example
Sheet: Piviot Table

Sum of Exp 1 |  | Sum of Exp 2 |  | Sum of Exp 3 |  | Sum of Exp 4 |  | Sum of Exp 5
Article ID | Total | Article ID | Total | Article ID | Total | Article ID | Total | Article ID | Total
1 | 0.02 | 1 | 0.54 | 1 | 0.25 | 1 | 0.35 | 1 | 0.65
2 | 1.02 | 2 | 0.84 | 2 | 0.65 | 2 | 0.15 | 2 | 0.95
3 | 0.52 | 3 | 0.44 | 3 | 0.28 | 3 | 0.3 | 3 | 0.62
4 | 0.2 | 4 | 0.35 | 4 | 0.18 | 4 | 0.45 | 4 | 0.85
5 | 1.36 | 5 | 1.58 | 5 | 1.8 | 5 | 2.02 | 5 | 2.24
6 | 1.52 | 6 | 1.051 | 6 | 0.582 | 6 | 0.113 | 6 | -0.356
7 | 0.52 | 7 | 1.166 | 7 | 1.812 | 7 | 2.458 | 7 | 3.104
8 | 0.48 | 8 | 1.281 | 8 | 2.082 | 8 | 2.883 | 8 | 3.684
9 | 0.09 | 9 | 1.396 | 9 | 2.702 | 9 | 4.008 | 9 | 5.314
10 | 1.62 | 10 | 1.511 | 10 | 1.402 | 10 | 1.293 | 10 | 1.184
11 | 18 | 11 | 1.626 | 11 | -14.748 | 11 | -31.122 | 11 | -47.496
12 | 0.98 | 12 | 1.741 | 12 | 2.502 | 12 | 3.263 | 12 | 4.024
13 | 1.01 | 13 | 1.856 | 13 | 2.702 | 13 | 3.548 | 13 | 4.394
Grand Total | 27.34 | Grand Total | 15.378 | Grand Total | 2.196000000000001 | Grand Total | -10.286 | Grand Total | -20.838
Spreadsheet: 106965d1304100668-excel-2007-can-you-use-a-tick-box-as-a-value-invoice
Sheet: Sheet1

[NAME]
 |  |  |  |  |  | Please invoice: | 401.5166
Month: | 2011-03-01 00:00:00
UID | Customer Name | Course Booked | Net Sale | Fee | Tutor Assist | Project | Total | Comments
WGT030 |  | IOSH | 245.83 | 4.916600000000001 | 0 | 8 | 12.9166
WGT047 |  | NEBOSH | 395 | 7.9 | 12 | 8 | 27.9
WGT049 |  | IOSH | 275 | 5.5 | 0 | 0 | 5.5
WGT050 |  | IOSH | 200 | 4 | 12 | 8 | 24
WGT051 |  | IOSH | 200 | 4 | 0 | 0 | 4
WGT052 |  | IOSH | 200 | 4 | 0 | 8 | 12
WGT053 |  | IOSH | 200 | 4 | 0 | 0 | 4
WGT054 |  | IOSH | 200 | 4 | 12 | 8 | 24
WGT055 |  | NEBOSH | 395 | 7.9 | 0 | 8 | 15.9
WGT056 |  | IOSH | 220 | 4.4 | 0 | 8 | 12.4
WGT057 |  | IOSH | 220 | 4.4 | 0 | 8 | 12.4
WGT058 |  | NEBOSH | 395 | 7.9 | 12 | 8 | 27.9
WGT059 |  | NEBOSH | 395 | 7.9 | 0 | 8 | 15.9
WGT060 |  | NEBOSH | 395 | 7.9 | 0 | 8 | 15.9
WGT061 |  | IOSH | 275 | 5.5 | 12 | 8 | 25.5
WGT035 |  | IOSH | 275 | 5.5 | 0 | 0 | 5.5
WGT028 |  | IOSH |  |  | 0 | 8 | 8
WGT011 |  | IOSH |  |  | 0 | 8 | 8
WGT020 |  | IOSH |  |  | 12 | 12 | 24
WGT046 |  | IOSH | 220 | 4.4 | 0 | 8 | 12.4
WGT026 |  | IOSH |  |  | 0 | 8 | 8
WGT041 |  | IOSH | 275 | 5.5 | 12 | 0 | 17.5
WGT048 |  | IOSH | 275 | 5.5 | 0 | 0 | 5.5
WGT040 |  | IOSH | 275 | 5.5 | 0 | 8 | 13.5
WGT042 |  | IOSH | 275 | 5.5 | 12 | 8 | 25.5
WGT043 |  | IOSH | 275 | 5.5 | 0 | 0 | 5.5
WGT044 |  | IOSH | 175 | 3.5 | 0 | 0 | 3.5
WGT045 |  | IOSH | 220 | 4.4 | 12 | 8 | 24.4
Totals: |  |  | 6475.83 | 129.5166 | 108 | 164 | 401.5166
 |  | Invoice this amount: |  | 401.5166
Spreadsheet: 67374d1268021892-need-help-pulling-data-from-a-chart-with-2-input-parameters-need-a-formula
Sheet: Sheet1

 | Quantity Range |  | 1 Color | 2 Color | 3 Color | 4 Color | 5 Color | 6 Color
 | From | To
 | 24 | 71 | 0.65 | 0.85 | 1.05 | 1.2 | 1.3
 | 72 | 143 | 0.6 | 0.8 | 1 | 1.15 | 1.25 | 1.35
 | 144 | 239 | 0.55 | 0.7 | 0.9 | 1.05 | 1.15 | 1.25
 | 240 | 359 | 0.5 | 0.65 | 0.85 | 1 | 1.1 | 1.2
 | 360 | 499 | 0.45 | 0.6 | 0.75 | 0.85 | 0.95 | 1.05
 | 500 | 1199 | 0.39 | 0.5 | 0.55 | 0.6 | 0.65 | 0.7
 | 1200 | 2499 | 0.33 | 0.4 | 0.5 | 0.55 | 0.6 | 0.65
 | 2500 | 4999 | 0.28 | 0.35 | 0.45 | 0.5 | 0.55 | 0.6
 | 5000 | 9999 | 0.22 | 0.3 | 0.4 | 0.45 | 0.5 | 0.55
 |  |  |  |  | I need a formula that allows me to enter a number in the box below "Item Quantity" (for example: 250) and then an amount in the box below "# of Colors" (for example: 3).  I want the amount (0.85) to appear in the box below "Price From Chart".  I imagine that the formula will go into the box below  "Price From Chart".  The table can be altered if the necessary formula requires it.  Thank you.
 | Item Quantity | # of  Colors | Price From Chart
Spreadsheet: 727320d1617832717-vlookup-returns-mixed-values-vlook-is-not-returning-the-right-values-on-different-sheets
Sheet: data

User | User full name
HANNAHCA
STEFVDH
KLAUDIAK
MAGDALENAJ
MARLENAW
MARTAH
BERNAC
DUYGUP
ERSANB
TARIKC
TUGBAT
DORATAB
HANNAJ
JOANNAS
KATERINAK
MARCIND
JULIAB
NADEZHDAZ
ESTELLE
MARIOG
VICTORB
VOLGAM
WERONIKAK
WOJCIECHK
IELYZAVETA
Spreadsheet: 343b6172-2756-47b8-947b-c8b4fe0e6590
Sheet: Sheet1

State [NAME] (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Downloaded at 3/11/2014 9:01:37 AM
Precincts Reporting: 528/528 - Total Ballots Cast: 102886
2008 Primary Election - OFFICIAL RESULTS
District | [NAME] | [NAME] | [NAME] | Whitney Hauz | TOTALS
District 02 | 1 | 0 | 0 | 0 | 1
District 03 | 0 | 0 | 0 | 0 | 0
District 04 | 0 | 0 | 0 | 0 | 0
District 05 | 0 | 1 | 0 | 0 | 1
District 06 | 0 | 0 | 0 | 0 | 0
District 11 | 0 | 0 | 0 | 0 | 0
District 13 | 0 | 0 | 0 | 0 | 0
District 20 | 0 | 0 | 0 | 0 | 0
District 21 | 0 | 0 | 0 | 0 | 0
District 22 | 0 | 0 | 0 | 0 | 0
District 27 | 0 | 0 | 0 | 0 | 0
District 36 | 0 | 0 | 0 | 0 | 0
District 37 | 0 | 0 | 0 | 0 | 0
District 38 | 0 | 0 | 0 | 0 | 0
District 40 | 0 | 0 | 0 | 0 | 0
District 41 | 0 | 0 | 0 | 0 | 0
District 44 | 1 | 0 | 1 | 1 | 3
Results provided by the Office of North Dakota Secretary of State | 0 | 0 | 1 | 0 | 1
District 46 | 0 | 0 | 0 | 0 | 0
TOTAL | 2 | 1 | 2 | 1 | 6
Spreadsheet: befcdda1-ac08-4f8e-815b-4d3142082fb1
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
6932 | 46453 | [NAME] | Lahti | FIN | 121 | 00:13:58 | 00:00:00 | 00:39:55 | [NAME] | 00:24:16 | 1 | 01:20:43
Spreadsheet: 599154d1542879852-payment-terms-formula-payment-terms
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January | February | March | April | May | June
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] in months | 1 | Incr. (bill received) | 10 | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Decr. (bill paid)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] in months | 2 | Incr. (bill received) | 10 | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Decr. (bill paid) |  |  | -20 |  | -20 |  | -20
Spreadsheet: 0e2b0a84-1055-47d8-a146-7bc806eb96a2
Sheet: ΜΠΥΡΕΣ

ΜΠΥΡΕΣ
ΠΕΡΙΓΡΑΦΗ | ΜΟΝ.ΜΕΤΡ. |  | FIX HELLAS 0,33LT/24TEM | ΚΙΒΩΤΙΑ
ΜΠΥΡΕΣ ΦΙΑΛΗ |  |  | FIX HELLAS 0,5LT/24ΤΕΜ | ΚΙΒΩΤΙΑ
AMSTEL 0,5LT/20ΤΕΜ | ΚΙΒΩΤΙΑ |  | ΜΠΥΡΕΣ ΕΙΣΑΓΩΓΗΣ
AMSTEL 0,33LT/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | ΠΕΡΙΓΡΑΦΗ | ΜΟΝ.ΜΕΤΡ.
AMSTEL PILS PR ΦΙΑΛΗ 0,5LT/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | BECK'S BOTTLE 0,33LT/24TEM | ΚΙΒΩΤΙΟ
AMSTEL 0,33LT/24ΤΕM Ο.W. | ΚΙΒΩΤΙΑ |  | WARSTEINER BOTTLE 0,33LT/24TEM | ΚΙΒΩΤΙΟ
ΗΕΙΝΕΚΕΝ 0,5LT/20ΤΕΜ | ΚΙΒΩΤΙΑ |  | BUDWEISER BUDVAR BOTTLE 0,33LT/24TEM | ΚΙΒΩΤΙΟ
ΗΕΙΝΕΚΕΝ 0,33LT/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | [NAME] | ΚΙΒΩΤΙΟ
ΗΕΙΝΕΚΕΝ 0,33LT/24ΤΕΜ Ο.W. | ΚΙΒΩΤΙΑ |  | FRANZISKANER DUNKEL 0,5LT/20TEM | ΚΙΒΩΤΙΟ
ΑΛΦΑ 0,5LT/20ΤΕΜ | ΚΙΒΩΤΙΑ |  | LEFFE BLOND BOTTLE 0,33LT/24TEM | ΚΙΒΩΤΙΟ
ΑΛΦΑ RETRO ΦΙΑΛΗ 0,33LT/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | LEFFE BRUNE BOTTLE 0,33LT/24TEM | ΚΙΒΩΤΙΟ
FISCHER 0,5LT/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | CHIMAY BLUE 0,33LT/24TEM | ΚΙΒΩΤΙΟ
ΜΥΘΟΣ 0,5LT/20ΤΕΜ | ΚΙΒΩΤΙΑ |  | KWAK BEER BOTTLE 0,33LT/24TEM | ΚΙΒΩΤΙΟ
ΚΑΙSΕR 0,5LT/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | PERONI N.AZZURO 0,33LT/24TEM | ΚΙΒΩΤΙΟ
ΚΑISER 0,33LT/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | STELLA ARTOIS 0,33LT/24TEM | ΚΙΒΩΤΙΑ
FIX HELLAS 0,5LT/24TEM | ΚΙΒΩΤΙΑ |  | BUD BEER 0,33LT/24TEM | ΚΙΒΩΤΙΑ
FIX HELLAS ΦΙΑΛΗ 0,33LT/20ΤΕΜ | ΚΙΒΩΤΙΑ |  | CORONA EXTRA 0,33LT/24TEM | ΚΙΒΩΤΙΑ
FIX DARK 0,33LT/20ΤΕΜ TRAD. O.W. | ΚΙΒΩΤΙΑ |  | [NAME] 0,33LT/24TEM | ΚΙΒΩΤΙΑ
FIX HELLAS Φ. 0,33LT/20ΤΕΜ O.W. | ΚΙΒΩΤΙΑ |  | ΒUCKLER 0,33LT/24TEM | ΚΙΒΩΤΙΑ
ΜΠΥΡΕΣ ΒΑΡΕΛΙ |  |  | CARLSBERG 0,33LT/24TEM | ΚΙΒΩΤΙΑ
AMSTEL 20LT | ΤΕΜΑΧΙΑ |  | CARIB 0,33LT/24TEM | ΚΙΒΩΤΙΑ
AMSTEL 30LT | ΤΕΜΑΧΙΑ |  | ΒUCKLER BOTLLE 0,33LT/24TEM | ΚΙΒΩΤΙΑ
ΗΕΙΝΕΚΕΝ 20LT | ΤΕΜΑΧΙΑ |  | ERDINGER WEISS ΦΙΑΛΗ 0,33LT/12TEM | ΚΙΒΩΤΙΑ
ΗΕΙΝΕΚΕΝ 30LT | ΤΕΜΑΧΙΑ |  | ERDIGER WEISS DUN.ΦΙΑΛΗ 0,5LT | ΚΙΒΩΤΙΑ
ΜΥTHOS 20LT | ΤΕΜΑΧΙΑ |  | KRUSOVICE CERNE BOTTLE 0,33LT/24TEM | ΚΙΒΩΤΙΑ
ΜΥΤΗΟS 30LT | ΤΕΜΑΧΙΑ |  | DUVEL ΦΙΑΛΗ 0,33LT/24TEM | ΚΙΒΩΤΙΑ
ΑΛΦΑ 30LT | ΤΕΜΑΧΙΑ |  | [NAME] | ΚΙΒΩΤΙΑ
ΑΛΦΑ 20LT | ΤΕΜΑΧΙΑ |  | ΒΙΟS 5 LAGER BEER Φ. 0,33LT/24TEM | ΚΙΒΩΤΙΑ
FISCHER 20LT | ΤΕΜΑΧΙΑ |  | ΑΕΡΙΟΥΧΑ ΠΟΤΑ
FISCHER 30LT | ΤΕΜΑΧΙΑ |  | [NAME] | ΚΙΒΩΤΙΑ
FIX HELLAS 30LT | ΤΕΜΑΧΙΑ |  | BACARDI BREEZER ΠΟΡΤ. 0,375LT/24TEM | ΚΙΒΩΤΙΑ
ΜΠΥΡΕΣ ΜΕΤΑΛ. |  |  | BACARDI BREEZER ΛΕΜ. 0,375LT/24TEM | ΚΙΒΩΤΙΑ
AMSTEL 0,33LT/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | SMIRNOFF ICE 0,375LT/24TEM | ΚΙΒΩΤΙΑ
AMSTEL 0,5LT/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | GORDONS SPACE 0,375LT/24TEM | ΚΙΒΩΤΙΑ
ΗΕΙΝΕΚΕΝ 0,33LT/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | BIANCONERO ΑΦΡΩΔΗΣ ΛΕΥΚΟ 187ΜΛ | ΤΕΜΑΧΙΑ
ΗΕΙΝΕΚΕΝ 0,5LT/24ΤΕΜ | ΚΙΒΩΤΙΑ |  | BIANCONERO ΑΦΡΩΔΗΣ ΡΟΖΕ 187ΜΛ | ΤΕΜΑΧΙΑ
ΚΑΙΣΕΡ 0,33LT/24ΤΕΜ | ΚΙΒΩΤΙΑ
ΜΥΘΟΣ 0,33LT/24ΤΕΜ | ΚΙΒΩΤΙΑ
ΑΛΦΑ 0,33LT/24ΤΕΜ | ΚΙΒΩΤΙΑ
HENNINGER ΜΠΥΡΑ 24/330ΜΛ | ΚΙΒΩΤΙΑ
Spreadsheet: 848356d1699075121-tiered-bonus-structure-bonus-structure
Sheet: Sheet1

Bonus Structure
 |  | >$60,000   $.15 | >$90,000   $.25 | >$120,000   $.35
Quarter | Income | Tier 1 | Tier 2 | Tier 3 | Total
1st | 65819
2nd | 30665
3rd | 131885
4th | 25065
Total
Spreadsheet: 163257d1340248534-arrange-complex-excel-data-from-different-worksheet-and-sort-into-one-database-book1
Sheet: Sheet1

Position /Competency Mapping
Proficiency Level Table  : Facility / Manufacturing Department
 |  | Core Competency |  |  |  |  | Managerial Competency |  |  |  |  | Functional Competency
 | Proficiency Level Guide | Quality Awareness | Customer Oriented | Continual Improvement | Safety Awareness | Innovation | Leadership | Problem Solving & Decision Making | Coaching and Developing Others | Accountability | Risk Management | AAAAAAAAAA | CCCCCCCCCC | EEEEEEEEEEEE
Competency Level: |  | CC 001 | CC 002 | CC 003 | CC 004 | CC 005 | MC 001 | MC 002 | MC 003 | MC 004 | MC 005 | FC001 | FC003 | FC005
Position Title:
Facility & Equipment Manager | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
Maintenance Manager | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 3 |  | 4
Facility  Manager | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4
Equipment Manager | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4
Maintenance supervisor | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
Maintenance leader | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 2
Maintenance technician | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  | 2
Spare part controller | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  | 2 | 2
Spreadsheet: 158d1d58-e8d2-46df-951a-9ee7b588a39e
Sheet: Sheet1

Count Day Mileage Calculation | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
October 2013
 | Route 1 | Route 2 | Route 3 | Route 4 | Route 5 | Route 6 | Route 7 | Route 8 | Route 9
[NAME] in Route:
Multiply by: Days in year
 |  |  |  |  |  |  |  |  | Total
Total mileage all routes | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Divide by: Days district calendar in year, less cancellations |  |  |  | < Amount reported on Line 3, CDE-40
Average mileage per day |  |  |  | < Amount reported on Line 2, CDE-40