tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 767309d1644405088-need-help-to-get-the-count-based-on-criteria-sample-1
Sheet: Sheet15

Row Labels | Count of Status
Didn't join after selection | 1
Duplicate | 12
In Progress | 2
No Show | 14
Not Interested | 17
Not Suitable | 31
Not Yet Scheduled | 10
Offer Accepted | 1
[NAME] | 3
On Hold | 1
Pending | 10
Rejected (1st) | 42
Rejected (2nd) | 5
Rejected-Online Test | 5
Grand Total | 154
Spreadsheet: 137303d1327050070-removal-of-duplicate-data-and-show-those-rows-who-has-maximum-score-in-dupliate-rows-test
Sheet: Sheet1

 | Query is: | Query 1 | Query 2 | Score
 |  | Confidence_0.118_Length_701 | Mack | 650
 |  | Confidence_0.118_Length_701 | [NAME] | 542
 |  | Confidence_0.118_Length_701 | Sumith | 563
 |  | Confidence_0.176_Length_582 | [NAME] | 421
 |  | Confidence_0.176_Length_582 | Mack | 485
 |  | Confidence_0.176_Length_582 | [NAME] | 251
 |  | Confidence_0.176_Length_582 | Whisky | 362
 | Result Should be: | Query 1 | Query 2 | Score
 |  | Confidence_0.118_Length_701 | Mack | 650
 |  | Confidence_0.118_Length_701 | [NAME] | 542
 |  | Confidence_0.118_Length_701 | Sumith | 563
 |  | Confidence_0.176_Length_582 | [NAME] | 421
 |  | Confidence_0.176_Length_582 | Whisky | 362
Spreadsheet: 174425d1345053245-subtotals-with-multiple-criteria-formula-sample-for-subtotal-spreadsheet
Sheet: Sheet2

Sum of Amount
Name | Date | Total
Curly | Jan | 300
 | Dec | 100
Curly Total |  | 400
[NAME] | Jan | 100
 | Dec | 100
[NAME] |  | 200
Moe | Jan | 200
 | Dec | 100
Moe Total |  | 300
Grand Total |  | 900
Spreadsheet: 789598d1659207793-sumif-function-sample
Sheet: Sheet1

Product | 2015-16 | 2016-17 | 2017-18 | 2018-19 | 2019-20 | 2020-21 | 2021-22 | 2022-23 | [NAME] | Sum
A | 0 | 0 | 800 | 0 | 0 | 0 | 0 | 0 |  | Need to sum by excluding "Max Value Cell"
B | 960 | 0 | 0 | 100 | 200 | 0 | 0 | 0
C | 0 | 0 | 7200 | 0 | 8 | 9 | 200 | 0
D | 0 | 0 | 7200 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 748442d1632147802-task-list-to-auto-populate-into-a-calendar-midatlantic-planning-calendar-example
Sheet: Project Tracker

Date | Category | Care Center | Market | State | Project Name | Status | Project Lead | Notes |  |  | KEY:
2021-09-17 00:00:00 | Provider Departure |  |  |  | [NAME] |  |  |  |  |  | TBD
2021-09-17 00:00:00 | Marketing To-Do's |  |  |  |  |  |  |  |  |  | Other
 | Marketing To-Do's |  |  |  |  |  |  |  |  |  | New Providers
2021-09-27 00:00:00 | Other |  |  |  | New Employee |  |  |  |  |  | Marketing To-Do's
2021-09-29 00:00:00 | Office Move |  |  |  | Example 1 |  |  |  |  |  | Marketing Campaign
2021-09-30 00:00:00 | Provider Departure |  |  |  | Example 2 |  |  |  |  |  | Social Media
2021-09-30 00:00:00 | Provider Departure |  |  |  | Example 3 |  |  |  |  |  | Office Move
2021-10-01 00:00:00 | Provider Departure |  |  |  | Example 4 |  |  |  |  |  | Provider Departure
 |  |  |  |  |  |  |  |  |  |  | Integration
Spreadsheet: 010108ad-e0a8-401a-bd7f-9018f7bd259b
Sheet: Sheet1

AFLAC INC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
8-K
05/09/2013
CURRENT REPORT
Georgia |  | 001-07434 |  | 58-1167100
(State or other jurisdiction |  | (Commission |  | (IRS Employer
of incorporation) |  | File Number) |  | Identification No.)
1932 Wynnton Road, Columbus, Georgia |  |  |  | 31999
(Address of principal executive offices) |  |  |  | (Zip Code)
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/
Spreadsheet: 536923d1504752561-extract-the-value-of-about-30-different-cell-references-out-of-420-closed-workbooks-example-data-file
Sheet: Desired Output

Emp ID: | Emp Name: | Location: | Fixed term: | Position: | Qualification: | Classification: | Effective from date: | Monday Start Time | Tuesday Start Time | Wednesday Start Time | Thursday Start Time | Friday Start Time | Monday End Time | Tuesday End Time | Wednesday End Time | Thursday End Time | Friday End Time
B4 | B5 | B6 | B7 | F4 | F5 | F6 | [NAME] | C13 | C15 | C17 | C19 | C21 | D13 | D15 | D17 | [NAME] | D21
10078 | [NAME] | Example Kinder | N/A | Certificate III Qualified ECE | Certificate III | Certificate III | 2017-01-30 00:00:00 | 13:30:00 | 16:00:00 | 13:30:00 | 16:00:00 | 13:30:00 | 18:30:00 | 18:30:00 | 18:30:00 | 18:30:00 | 18:30:00
Spreadsheet: 693589d1599048747-randbetween-with-choose-function-randbetween-with-choose-function
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | WHITE | Nissan | 2001
 |  |  |  |  |  |  |  |  |  |  |  | BLACK | Toyota
 |  |  |  |  |  |  |  |  |  |  |  | BLUE | Ford
 |  |  |  |  |  |  |  |  |  |  |  | RED | Kia
 |  |  |  |  |  |  |  |  |  |  |  | GREEN
 |  |  |  |  |  |  |  |  |  |  |  | PURPLE
 |  |  |  |  |  |  |  |  |  |  |  | GREY
 |  |  |  |  |  |  |  |  |  |  |  | ORANGE
Spreadsheet: 830400d1684896120-excel-fomular_index-match-and-min-max-fomular_th
Sheet: Sheet7

 |  |  |  |  |  |  |  |  |  | RESULT WITH FOMULAR HERE
Month | Printer Type | Brand | Model No. | AA COM | Source | BBB | Source | CCC | Source | Best Price Offering | [NAME] | Minimum Price
 |  |  |  | 4690 |  | 4390 |  | 3750 |  |  |  |  | if have price > 0 in 3 column this fomular will work
 |  |  |  | 5690 |  | 0 |  | 0 |  |  |  |  | if have min = 0 for 2 value, this formular will work
 |  |  |  | 0 |  | 7890 |  | 7790 |  |  |  |  | if have min = 0 only 1 value.it is false. i need to show CCC (7790 best price)
 |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  | if have min = 0 for all column. This fomular will work
 |  |  |  | 5955 |  | 5695 |  | 5695 |  |  |  |  | if have duplicate price >2 column.formular match first column to found BBB but actual, I need to show BBB&CCC
 |  |  |  | 0 |  | 5695 |  | 5695 |  |  |  |  | if have duplicate price >2 column and found 0.formular match first column to found BBB but actual, I need to show BBB&CCC
 |  |  |  |  |  |  |  |  | if use Min function will be count 0 .please suggest the best one fomular to cover all result?
Spreadsheet: 702466d1604369388-if-date-is-of-intervals-after-another-date-formula-example
Sheet: Sheet1

 |  |  |  |  |  |  |  | Year 1 |  |  |  |  |  |  |  |  |  |  |  |  | Year 2 |  |  |  |  |  |  |  |  |  |  |  |  | Year 3 |  |  |  |  |  |  |  |  |  |  |  |  | Year 4 |  |  |  |  |  |  |  |  |  |  |  |  | Year 5
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  | Total | Total
 |  |  |  |  |  |  |  | 2021-01-01 00:00:00
 | Amazon |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  | Desired result-> |  | 100
 |  |  |  |  |  |  | Action needed -> |  |  | +25% | +25% | +25% | +25% | +50% | +50% | +50% | +100% | +100% | +100% |  | +50% | +50% | +50% | +100 |  |  | +100 |  |  | +100 |  |  |  | +100
 |  |  |  | 2021-02-01 00:00:00 | Stage 1 growth in % | 0.25
 |  |  |  | 2021-07-01 00:00:00 | Stage 2 growth in % | 0.5
 |  |  |  | 2021-10-01 00:00:00 | Stage 3 growth in % | 1
 |  |  |  | 2022-01-01 00:00:00 | Stage 4 growth in % | 0.5
 |  |  | Thereafter | 3 | month intervals in % | 100
 | Inventory
Spreadsheet: c91fd4a0-2567-4f96-8459-930f00018fb8
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
FPRGA | Test | FPRGA | Pregabalin (Lyrica) | Pregabalin | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp Plain, Red-Top Tube: Red |  |  | 1 | mL | Submit only 1 of the following specimens:  Plasma Draw blood in a green-top (sodium heparin) tube(s), plasma gel tube not acceptable. Spin down and send 1 mL sodium heparin plasma refrigerated in a plastic vial.   Serum Draw blood in a plain, red-top tube(s), serum gel tube is not acceptable. Spin down and send 1 mL of serum refrigerated in a plastic vial. | 0.25 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Units:	ug/mL  Therapuetic and toxic ranges have not been established.  Expected steady state pregabalin concentrations in patients taking recommended daily dosages: 	up to 10 ug/mL  Test Performed by:	Medtox Laboratories, Inc.  			402 W. County Road D 			St. Paul, MN 55112 | Monday through Sunday | 2 days | 4 - 6 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc.
FPRGA | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
FPRGA | Result | Z2248 | Pregabalin | Pregabalin | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process | Pregabalin:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 702549d1604411488-top-25-values-based-on-another-criteria-top-n-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | What I want to do:
List of data
Item | month | price 1 | price 2 | price 3 | price 4
Item 1 | 1 | 100 | 90 | -30 | 60
Item 2 | 1 | 110 | 80 | -25 | 50
Item 1 | 2 | 120 | 60 | -30 | 60
Item 4 | 1 | 100 | 90 | -30 | 60
Item 1 | 3 | 100 | 90 | -30 | 60
Item 3 | 1 | 100 | 90 | -30 | 60
Item 2 | 2 | 100 | 90 | -30 | 60
Item 1 | 1 | 200 | 170 | -54 | 52
Item 2 | 1 | 300 | 250 | -70 | 180
Item 1 | 2 | 600 | 500 | -100 | 400
Item 4 | 1 | 70 | 67 | -17 | 50
Item 1 | 2 | 220 | 200 | -20 | 180
Item 3 | 1 | 1500 | 1400 | -300 | 1100
Item 2 | 3 | 300 | 270 | -70 | 200
 |  |  |  | Price 2 for selection
 |  |  |  |  | 1 | 2 | 3 | Total sum
 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0
 |  |  |  | Price 1 for presentation
 |  |  |  |  | 1 | 2 | 3 | Total sum | Placement in list
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  | 0 | 0 |  | 1
 |  |  |  |  |  | 0 | 0 |  | 4
Spreadsheet: 86790d1286762870-counting-frequency-of-transactions-by-time-copy-of-sample-2
Sheet: Sheet1

Name | Date/Time
[NAME] | 2014-09-30 16:40:00
[NAME] | 2014-10-01 16:19:43
[NAME] | 2014-10-02 17:50:39
[NAME] | 2014-10-02 07:18:00
[NAME] | 2014-10-02 09:16:00
1900-01-01 00:00:00 | 0
01:00:00 | 0
02:00:00 | 0
03:00:00 | 0
04:00:00 | 0
05:00:00 | 0
06:00:00 | 0
07:00:00 | 1
08:00:00 | 0
09:00:00 | 1
10:00:00 | 0
11:00:00 | 0
12:00:00 | 0
13:00:00 | 0
14:00:00 | 0
15:00:00 | 0
16:00:00 | 2
17:00:00 | 1
18:00:00 | 0
19:00:00 | 0
20:00:00 | 0
21:00:00 | 0
22:00:00 | 0
23:00:00 | 0
1904-01-02 00:00:00
Spreadsheet: 827941d1683129297-need-help-with-a-formula-that-uses-multiple-criteria-with-a-date-range-to-output-price-sample-excel-2
Sheet: Sheet1

PO Number | [NAME] | Supplier Code | Line Item Number | Part No | Unit Price | Effective Date | Expiration Date | Note | PO Check | Part Check | Date Check | [NAME]
53188 | Mill Steel of xxxxx | Mill Steel | 1 | 22377 | 0.393 | 2020-10-01 00:00:00 | 2020-12-31 00:00:00 | [NAME]
53188 | Mill Steel of xxxxx | Mill Steel | 1 | 22377 | 0.5129 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | Q1 CRU
53188 | Mill Steel of xxxxx | Mill Steel | 1 | 22377 | 0.7212 | 2021-04-01 00:00:00 | 2021-09-06 00:00:00 | Q2 CRU 2021
53188 | Mill Steel of xxxxx | Mill Steel | 1 | 22377 | 0.729 | 2021-02-02 00:00:00 | 2021-03-31 00:00:00 | Last Spot Buy Price
53188 | Mill Steel of xxxxx | Mill Steel | 1 | 22377 | 0.8909 | 2021-07-01 00:00:00 | 2021-09-30 00:00:00
53188 | Mill Steel of xxxxx | Mill Steel | 1 | 22377 | 1.0989 | 2021-10-01 00:00:00 | 2021-12-31 00:00:00 | [NAME] 2021 - Customer is Quote Each Time
 |  |  |  |  | PO | PART | DATE | WANT THE PRICE
 |  |  |  |  | 53188 | 22377 | 2021-01-01 00:00:00
Spreadsheet: 845241d1696763444-problem-incrementing-or-decrementing-a-cells-value-based-on-a-filters-value-golfscoresmultiplayerold-aligw
Sheet: Handicaps

 |  |  | 2023-12-04 00:00:00 | 2024-01-08 00:00:00 | 2024-02-05 00:00:00 | 2024-03-04 00:00:00 | 2024-04-08 00:00:00 | 2024-05-06 00:00:00 | 2024-06-03 00:00:00
Team/Hcap | StartHcp |  |  |  |  |  |  |  |  |  | Hcaps for 13/11 | Hcaps for 04/12 | Hcaps for 08/01 | Hcaps for 05/02 | Hcaps for 04/03 | Hcaps for 08/04 | Hcaps for 06/05 | Hcaps for 03/06
Team1
Player1 | 12 |  |  |  |  |  |  |  |  |  | 12 | 11 | 10 | 11 | 12 | 12 | 12 | 12
Player2 | 17 |  |  |  |  |  |  |  |  |  | 17 | 16 | 15 | 16 | 17 | 17 | 17 | 17
Player3 | 16 |  |  |  |  |  |  |  |  |  | 16 | 15 | 14 | 15 | 16 | 16 | 16 | 16
Player4 | 17 |  |  |  |  |  |  |  |  |  | 17 | 16 | 15 | 16 | 17 | 17 | 17 | 17
Team2
Player5 | 10
Player6 | 15
Player7 | 19
Player8 | 22
Team3
Player9 | 15
Player10 | 20
Player11 | 25
Player12 | 28
Team4
Player13 | 13
Player14 | 19
Player15 | 21
Player16 | 22
Team5
Player17 | 12
Player18 | 14
Player19 | 19
Player20 | 23
Team6
Player21 | 17
Player22 | 19
Player23 | 22
Player24 | 25
Team7
Player22 | 10
Player23 | 16
Player24 | 22
Player25 | 25
Spreadsheet: 877800d1724728053-combining-sumifs-and-hlookup-excel_help_sumifs_xlookup
Sheet: Sheet2

 |  |  |  |  | Include items with zero values? | True
2024-05-01 00:00:00 |  |  |  |  |  | May-24 |  | May-24 |  | Streams
Pears | Actual |  | YTD |  | Pears | Actual |  | YTD
 |  |  |  |  |  |  |  |  |  | Oranges
 |  |  |  |  |  |  |  |  |  | Pears
 |  |  |  |  | Awards, Hospitality & Entertaining | 0 |  | 295.4
Bank Charges | 8105.02 |  | 21887.14 |  | Bank Charges | 8105.02 |  | 21887.14
Clothing, Sundries & Consumables | 813.39 |  | 2076.89 |  | Clothing, Sundries & Consumables | 813.39 |  | 2076.89
Clubs, Schools & Instructors | -7245 |  | -25245 |  | Clubs, Schools & Instructors | -7245 |  | -25245
Contractors/Consultants | 34536.83 |  | 77983.67 |  | Contractors/Consultants | 34536.83 |  | 77983.67
Depreciation | 2878.39 |  | 13879.03 |  | Depreciation | 2878.39 |  | 13879.03
Direct Costs | 123707.53 |  | 372796 |  | Direct Costs | 123707.53 |  | 372796
Equipment Sales/Commissions | -227579.13 |  | -562269.67 |  | Equipment Sales/Commissions | -227579.13 |  | -562269.67
FIA Service Charges | 0 |  | 0 |  | FIA Service Charges | 0 |  | 0
Management & Rights Fees | 0 |  | 0 |  | Management & Rights Fees | 0 |  | 0
Marketing & Promotion | 21376.2 |  | 45758.5 |  | Marketing & Promotion | 21376.2 |  | 45758.5
Meeting Costs | 0 |  | 2850 |  | Meeting Costs | 0 |  | 2850
Operations & Logistics | 50535.47 |  | 109781.96 |  | Operations & Logistics | 50535.47 |  | 109781.96
Other | 0 |  | 0 |  | Other | 0 |  | 0
Partners & Advertising | 0 |  | -69000 |  | Partners & Advertising | 0 |  | -69000
Per Capita Fees | 11983 |  | 11983 |  | Per Capita Fees | 11983 |  | 11983
Registration & Entry Fees | -133888.5 |  | -406509 |  | Registration & Entry Fees | -133888.5 |  | -406509
Staff Costs | 5955.95 |  | 29779.76 |  | Staff Costs | 5955.95 |  | 29779.76
Trophies | 2713.5 |  | 5273.5 |  | Trophies | 2713.5 |  | 5273.5
Volunteers & Officials | 0 |  | 0 |  | Volunteers & Officials | 0 |  | 0
Volunteers, Officials & Expenses | 0 |  | 0 |  | Volunteers, Officials & Expenses | 0 |  | 0
 |  |  |  |  | Total | -106107.35 |  | -368678.8200000001
Spreadsheet: 837782d1690435272-billing-amount-for-greater-than-12-months-contract-untitled-spreadsheet-2-
Sheet: Sheet1

Customer | Subscription Start Date | Subscription End Date | Amount | Billing Frequency | Check | 2023-01-01 00:00:00
A | 2023-03-28 00:00:00 | 2024-03-27 00:00:00 | 10000 | Annual
B | 2023-02-07 00:00:00 | 2024-05-06 00:00:00 | 67500 | Annual
C | 2023-07-05 00:00:00 | 2025-07-04 00:00:00 | 15000 | Quarterly
G | 2023-02-08 00:00:00 | 2025-04-07 00:00:00 | 2000 | Monthly
Spreadsheet: 440232d1452703404-vacation-tracking-from-an-anniversary-date-from-year-to-year-vacation-tracking-2016
Sheet: May

Employee Absence Schedule
May | Dates of Absence
Employee Name | 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 | Total Hours
A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
E |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
G |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
J |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
Spreadsheet: 695003d1599946253-allocate-based-on-start-date-and-apply-annual-inflationary-uplift-example
Sheet: Sheet1

2020-01-01 00:00:00 |  |  | Amount | 2000
2020-02-01 00:00:00 |  |  | Start date | 2020-03-01 00:00:00
2020-03-01 00:00:00 |  |  | Inflation | 0.05
2020-04-01 00:00:00
2020-05-01 00:00:00
2020-06-01 00:00:00
2020-07-01 00:00:00
2020-08-01 00:00:00
2020-09-01 00:00:00
2020-10-01 00:00:00
2020-11-01 00:00:00
2020-12-01 00:00:00
2021-01-01 00:00:00
2021-02-01 00:00:00
2021-03-01 00:00:00
2021-04-01 00:00:00
2021-05-01 00:00:00
2021-06-01 00:00:00
2021-07-01 00:00:00
2021-08-01 00:00:00
2021-09-01 00:00:00
2021-10-01 00:00:00
2021-11-01 00:00:00
2021-12-01 00:00:00
2022-01-01 00:00:00
2022-02-01 00:00:00
2022-03-01 00:00:00
2022-04-01 00:00:00
2022-05-01 00:00:00
2022-06-01 00:00:00
2022-07-01 00:00:00
2022-08-01 00:00:00
2022-09-01 00:00:00
2022-10-01 00:00:00
2022-11-01 00:00:00
2022-12-01 00:00:00
Spreadsheet: 172378d1344175790-help-with-summary-ordertemplate
Sheet: Sheet1

 | Under 18's
Age Group |  | Kit | Player Number | [NAME] | Rayon Sock |  | Mekong Jersey | [NAME] | [NAME] | Team Short | Round Sock |  | [NAME] | Safon Jacket | [NAME] | [NAME] (Med) |  |  | Jnr | Snr | S | M | L | XL | XXL | XXXL |  | Check
 | Name
U 18's | [NAME] |  |  | XL | Snr |  | L | L | XL | XL | Snr |  | XL | L | XL | Y |  | [NAME] |  |  |  | 2 | 7 | 7
U 18's | [NAME] |  |  | XL | Snr |  | XL | XL | XL | XL | Snr |  | XXL | XL | XL | Y |  | Rayon Sock | 1 | 15
U 18's | [NAME] |  |  | XL | Snr |  | L | L | XL | XL | Snr |  | L | L | L | Y |  | Mekong Jersey |  |  |  | 2 | 10 | 4
U 18's | [NAME] |  |  | L | Snr |  | L | L | L | L | Snr |  | XL | XL | XL | Y |  | [NAME] |  |  |  | 3 | 9 | 4
U 18's | Femi Sofoworn |  |  | XL | Snr |  | XL | XL | XL | XL | Snr |  | XXL | XL | XL | Y |  | [NAME] |  |  |  | 2 | 7 | 7
U 18's | [NAME] |  |  | XL | Snr |  | L | L | XL | XL | Snr |  | XL | L | XL | Y |  | Team Short |  |  |  | 2 | 7 | 7
U 18's | [NAME] |  |  | M | Snr |  | M | M | M | M | Snr |  | L | M | S | Y |  | Round Sock | 1 | 15
U 18's | [NAME] |  |  | L | Jnr |  | L | M | L | L | Jnr |  | XXL | L | L | Y |  | [NAME] |  |  |  |  | 3 | 8 | 5
U 18's | [NAME] |  |  | XL | Snr |  | XL | XL | XL | XL | Snr |  | XXL | XL | XL | Y |  | Safon Jacket |  |  |  | 2 | 8 | 6
U 18's | [NAME] |  |  | XL | Snr |  | L | L | XL | XL | Snr |  | XL | XL | XL | Y |  | [NAME] |  |  | 1 | 1 | 6 | 8
U 18's | Tino Mtangadura |  |  | M | Snr |  | M | M | M | M | Snr |  | L | M | M | Y |  | [NAME] (Med) |  |  |  | 16
U 18's | [NAME] |  |  | L | Snr |  | L | L | L | L | Snr |  | XL | L | L | Y
U 18's | [NAME] |  |  | L | Snr |  | L | L | L | L | Snr |  | XL | L | L | Y
U 18's | [NAME] |  |  | L | Snr |  | L | L | L | L | Snr |  | XL | L | L | Y
U 18's | [NAME] |  |  | L | Snr |  | L | L | L | L | Snr |  | XL | L | L | Y
U 18's | [NAME] |  |  | L | Snr |  | XL | XL | L | L | Snr |  | XXL | XL | XL | Y
Spreadsheet: 547836d1510762411-annual-leave-form-autofill-copy-of-annual-leave-ticket-form
Sheet: Master File

 | Captured from Form Tab |  | Use for Future Reference
ERP Number | Email ID | Contact No | Email ID | Contact No
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
Spreadsheet: 866966d1713873371-returning-a-list-of-parts-from-reference-date-new-costing-database
Sheet: Timber Lengths

Sub-Assembly name | Item type | Profile | Length (m) | Price/m | Price Each | Quantity | Total
 |  | RAW 32mm X 95mm | 0.1 |  |  | 10
 |  | RAW 5.0x70/WS | 1.1 |  |  | 120
Spreadsheet: 774294d1648374172-remark-data-with-criteria-consecutive-and-last-day-excel_doc-1
Sheet: Sheet1

No. | Data |  |  |  |  |  |  | Category |  |  |  |  |  |  | P1 : > 180 (Consecutive 3 days & day of 7th) P2 : > 140 (Consecutive 3 days & day of 7th) P3 : > 130 (Consecutive 3 days & day of 7th)
 | 2022-03-18 00:00:00 | 2022-03-19 00:00:00 | 2022-03-20 00:00:00 | 2022-03-21 00:00:00 | 2022-03-22 00:00:00 | 2022-03-23 00:00:00 | 2022-03-24 00:00:00 | 2022-03-18 00:00:00 | 2022-03-19 00:00:00 | 2022-03-20 00:00:00 | 2022-03-21 00:00:00 | 2022-03-22 00:00:00 | 2022-03-23 00:00:00 | 2022-03-24 00:00:00 | Remark
1 | 109 | 109 | 109 | 109 | 109 | 110 | 110
17 | 131 | 132 | 132 | 131 | 129 | 132 | 131 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | < 130 | 130 - 140 | 130 - 140
128 | 136 | 136 | 136 | 136 | 135 | 136 | 136 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140
129 | 129 | 129 | 130 | 129 | 129 | 129 | 129 | < 130 | < 130 | 130 - 140 | < 130 | < 130 | < 130 | < 130
130 | 130 | 130 | 132 | 131 | 130 | 132 | 132 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140
20363 | 120 | 126 | 122 | 136 | 140 | 133 | 132 | < 130 | < 130 | < 130 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140
20364 | 132 | 133 | 133 | 133 | 133 | 133 | 133 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140
20374 | 135 | 137 | 135 | 134 | 137 | 139 | 137 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140
20375 | 129 | 130 | 129 | 130 | 131 | 131 | 130 | < 130 | 130 - 140 | < 130 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140
20376 | 218 | 224 | 234 | 230 | 226 | 228 | 233 | > 180 | > 180 | > 180 | > 180 | > 180 | > 180 | > 180
20377 | 235 | 232 | 252 | 245 | 233 | 251 | 242 | > 180 | > 180 | > 180 | > 180 | > 180 | > 180 | > 180
20378 | 132 | 132 | 135 | 133 | 133 | 132 | 132 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140
20379 | 131 | 132 | 131 | 131 | 129 | 129 | 131 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | < 130 | < 130 | 130 - 140
20380 | 129 | 130 | 130 | 131 | 130 | 131 | 130 | < 130 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140
20381 | 129 | 130 | 129 | 134 | 133 | 132 | 132 | < 130 | 130 - 140 | < 130 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140
20382 | 132 | 133 | 134 | 133 | 133 | 133 | 132 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140
20383 | 147 | 150 | 133 | 135 | 146 | 125 | 154 | 140 - 180 | 140 - 180 | 130 - 140 | 130 - 140 | 140 - 180 | < 130 | 140 - 180
20384 | 140 | 140 | 140 | 139 | 140 | 140 | 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140 | 130 - 140
20385 | 113 | 113 | 119 | 112 | 114 | 117 | 144 | < 130 | < 130 | < 130 | < 130 | < 130 | < 130 | 140 - 180
Spreadsheet: 02e36d03-14a0-4c29-9e83-502963ef59c7
Sheet: 3-7T

 | Section 3: Cost
 | Table 3-7Trend:  Domestic and Foreign Cost by Year
 | Vehicle Type | 2009 | 2010 | 2011 | 2012 | 2013
 | Domestic | 3378376037.45 | 4226194251.91 | 4077884841.38 | 4015067199.17 | 4058276625.55
 | Foreign | 382580664.87 | 367080131.95 | 363490182.51 | 338331489.74 | 385536911.5
 | Grand Total | 3760956702.32 | 4593274383.86 | 4441375023.9 | 4353398688.92 | 4443813537.06