tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 541374d1507246222-cant-unhide-rows-weekly-scorecard-template-copy
Sheet: P11

WEEKLY AREA SCORECARD |  |  |  |  |  |  | 2017
THIS FORM MUST BE EMAILED TO AREA COACH BY WEDNESDAY BY 10:00 AM EACH WEEK
Store: |  |  | Food Cost Goal: |  | Labor Goal:
Period #/ Week # | P11 / W1 |  | P11 / W2 |  | P11 / W3 |  | P11 / W4
Dates | 10/4 - 10/10 |  | 10/11 - 10/17 |  | 10/18 - 10/24 |  | 10/25-10/31
Customer
GES Overall Satisfied %
# of Surveys
Drive Thru OTD (#.##)
DT Menu Time (#.##)
DT Window Time (#.##)
Front Counter OTD (#.##)
Building Great Teams
Turn Over ( List Names at Bottom of  Sheet)
Crew Hires ( List Names at Bottom of Sheet)
Staffing Target
Current Staffing total
Learningzone Overall Team  %
Learningzone Food Safety %
ACT LIKE OWNERS
Net Sales | 4 |  | 4 |  | 4 |  | 4
Last Year Sales
YOY Sales Growth %
2017 YTD Sales
2016 YTD Sales
YTD Sales Growth %
1 GFS invoice total
2 GFS invoice total
3 GFS invoice total
4 GFS invoice total
1 Pepsi invoice total
2 Pepsi invoice total
Total COS
Food Cost %
$ [NAME] From Target
Hours Used
Labor $
Sales Per Man Hour
Labor %
Labor -/+$$
Overtime $
Refunds $ | 0 |  | 0 |  | 0 |  | 0
Discounts $
Cash +/- $
1 Terminated Team Member Name
Phone Number
2 Terminated Team Member Name
Phone Number
3 Terminated Team Member Name
Phone Number
New Hires This Week
1 New Hire Name
2 New Hire Name
3 New Hire Name
4 New Hire Name
Spreadsheet: 689616d1596554424-finding-all-tornado-outbreaks-on-a-particular-day-along-with-stats-for-that-event-finding-outbreaks
Sheet: Sheet1

Data Table
 |  |  |  |  |  |  |  |  |  | Month | Date |  | # of occurrence of date
Month | Day | Year | Number of Tornadoes | Injuries | Deaths |  |  |  | Select Date | 8 | 1
8 | 1 | 1950 | 1 | 0 | 5
8 | 2 | 1951 | 1 | 0 | 1
8 | 1 | 1952 | 2 | 0 | 0 |  |  |  | Result Table
8 | 1 | 1953 | 2 | 0 | 7
8 | 1 | 1954 | 3 | 0 | 8 |  |  |  | Occurrences | Month | Day | Year | # of Tornadoes | Injuries | Deaths
8 | 2 | 1955 | 3 | 15 | 0
8 | 2 | 1956 | 4 | 0 | 0
8 | 2 | 1957 | 4 | 0 | 0
7 | 1 | 1958 | 1 | 22 | 0
7 | 2 | 1959 | 2 | 17 | 0
7 | 1 | 1960 | 3 | 13 | 2
7 | 2 | 1961 | 4 | 14 | 3
7 | 1 | 1962 | 5 | 0 | 1
7 | 1 | 1963 | 3 | 0 | 4 |  |  |  | Desired Result Table
7 | 2 | 1964 | 2 | 0 | 5
7 | 2 | 1965 | 1 | 1 | 0 |  |  |  | Occurrences | Month | Day | Year | # of Tornadoes | Injuries | Deaths
7 | 2 | 1966 | 7 | 2 | 0 |  |  |  | 4 | 8 | 1 | 1950 | 1 | 0 | 5
 |  |  |  |  |  |  |  |  | 3 | 8 | 1 | 1952 | 2 | 0 | 0
 |  |  |  |  |  |  |  |  | 2 | 8 | 1 | 1953 | 2 | 0 | 7
 |  |  |  |  |  |  |  |  | 1 | 8 | 1 | 1954 | 3 | 0 | 8
Spreadsheet: 778251d1650958542-dynamic-dropdown-menu-based-on-single-cell-value-to-many-drop-down-ans
Sheet: Sheet1

 |  |  |  |  |  |  | HELPER
 |  |  |  | 2015 | 1 bedroom |  |  |  |  | 2016 |  |  | =OFFSET($H$20,0,COUNTIF($H$2:$H$200,"*?")-1)
 |  |  |  | 2015 | 2 bedroom
 |  |  |  | 2015 | 3 bedroom
 |  |  |  | 2015 | Commercial
 |  |  |  | 2015 | Retail
 |  |  |  | 2016 | 1 bedroom
 |  |  |  | 2016 | 2 bedroom
 |  |  |  | 2016 | 3 bedroom
 |  |  |  | 2016 | Commercial
 |  |  |  | 2016 | Retail
 |  |  |  | 2016 | Non-profit
 |  |  |  | 2017 | 1 bedroom
 |  |  |  | 2017 | 2 bedroom
 |  |  |  | 2017 | 3 bedroom
 |  |  |  | 2017 | Commercial
Spreadsheet: 0a1a0871-9359-4b6a-99e8-c50ddebc90e7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | CREDIT CARD DOCUMENTATION FORM                                                              Please submit to Accts Payable no later than 5 Business days before the statement due date.
 | Date: |  |  |  |  | Department
 | Name: |  |  |  |  | CC Period:
 | Complete description of charge, reason and purpose of each transaction, including names of participants |  |  | Trans Date | Dept  Code | Object Code | Credit Card Transaction Payee |  | Amount
 |  |  |  |  |  |  |  |  | 0
 | Supervisor, please be certain to date your signature of approval.  Thanks.
 | Credit Card Holder |  |  |  |  | Supervisor Approval
 | Rec' by Finance Office |  |  |  |  | Date
Spreadsheet: 48766d1248074716-start-and-stop-timestamp-timestamp_example
Sheet: IT

Example |  |  |  |  |  | 0 | NOK | 0 | 0 | 0 | 0 | 0 | 0
<Testcase 1> | 10 |  | NOK |  |  | 0 | NOK | 0 | 0 | 0 | 0 | 0 | 0
 | TG1 |  | NOK |  |  | 0 | NOK |  |  |  |  |  | 0
 | TG2 |  | NOK |  |  | 0 | NOK |  |  |  |  |  | 0
 | TG3 |  | NOK |  |  | 0 | NOK |  |  |  |  |  | 0
 | TG4 |  | NOK |  |  | 0 | NOK |  |  |  |  |  | 0
 | TG5 |  | NOK |  |  | 0 | NOK |  |  |  |  |  | 0
 | TG6 |  | NOK |  |  | 0 | NOK |  |  |  |  |  | 0
 | TG7 |  | NOK |  |  | 0 | NOK |  |  |  |  |  | 0
 | TG8 |  | NOK |  |  | 0 | NOK |  |  |  |  |  | 0
 | TG9 |  | NOK |  |  | 0 | NOK |  |  |  |  |  | 0
 | TG10 |  | NOK |  |  | 0 | NOK |  |  |  |  |  | 0
Spreadsheet: 32981d1229173705-a-formula-to-read-values-from-other-sheets-pivot-table-test
Sheet: 111002-Cash Float -

Account Name. | 111002-Cash Float -
Sum of Balances.
CENTER. | Account Name | Total
A | 111002-Cash Float - | 227828.48
Grand Total |  | 227828.48
 | RECONCILAITION
 | [NAME] | 200000
 | [NAME] | 27000
 | Deborha | 828.48
 | Total
 | Control
Spreadsheet: chris_germany__2019__Tenn Invoice Summary
Sheet: Summary-Breakout

ENA Corp |  |  | Nov 2001 Prod |  |  | Dec 01 Prod |  |  | Jan 02 Prod
Contract No. | Rate Class | Past Due | Invoice Date - 12/13/2001 |  |  | Invoice Date - 1/14/2002 |  |  | Invoice Date - 2/13/2002 |  |  | Totals
 |  |  | Demand Comm | Cashout  Imbalance | Cashout  Imbalance | Demand Comm | Cashout  Imbalance | Cashout  Imbalance | Demand Comm | Cashout  Imbalance | Cashout  Imbalance
37875 | Park |  | 3000
37876 | Park |  | 3000
37877 | Loan |  | 2500
37878 | Loan |  | 3000
37879 | Loan |  | 3000
38498 | FT-A |  | 23395.18
38499 | FT-A |  | 16523.9 |  |  | 15100 |  |  | 15100
2891 | IT |  | 5294.07
13274 | LMSMA |  |  | 25.51 |  |  | 4319.73 |  |  | 2015.6
18314 | LMSPA |  |  |  |  |  | 823.44 |  |  | 553.68
19787 | LMSMA |  |  |  |  |  | 84.45 |  |  | 54.85
32748 | LMSMA |  |  |  | -14.37
36621 | Park |  | 89.15
80045 | SA |  |  |  |  |  | 129320.62
none [NAME] | none listed | 37.6
15692* | IS-PA |  | 7502.93 |  |  | 7759.81
1 No contract indicated - past amounts for Aug 2001
* Bear Creek Storage -used and waiting for invoice to pay post-petition amount
ENA Upstream |  |  | Nov 2001 Prod |  |  | Dec 01 Prod |  |  | Jan 02 Prod
Contract No. | Rate Class | Past Due | Invoice Date - 12/13/2001 |  |  | Invoice Date - 1/14/2002 |  |  | Invoice Date - 2/13/2002 |  |  | Totals
 |  |  | Demand Comm | Cashout  Imbalance | Cashout  Imbalance | Demand Comm | Cashout  Imbalance | Cashout  Imbalance | Demand Comm | Cashout  Imbalance | Cashout  Imbalance
38388 | FT-A |  | 44746.12 |  |  | 39.16 |  | -2.5
38549 | LMSMA |  |  | 2136.35
36568 | IT |  |  | 1980.46 |  | 456.67 |  | -43.12
37011 | IS-PA |  |  |  |  | 3591.78 |  |  | 3591.78
80357 | SA |  |  |  |  |  |  | -752.12 |  | 1221.99
none listed2 | none listed |  |  |  |  |  |  |  | 73245.22
2 No contract indicated-past amounts for various services for pre and post petition
EES |  |  | Nov 2001 Prod |  |  | Dec 01 Prod |  |  | Jan 02 Prod
Contract No. | Rate Class | Past Due | Invoice Date - 12/13/2001 |  |  | Invoice Date - 1/14/2002 |  |  | Invoice Date - 2/13/2002 |  |  | Totals
 |  |  | Demand Comm | Cashout  Imbalance | Cashout  Imbalance | Demand Comm | Cashout  Imbalance | Cashout  Imbalance | Demand Comm | Cashout  Imbalance | Cashout  Imbalance
31905 | LMSMA |  |  | 6459.23 |  |  | 22785.94 |  | 6435.19 | 2783.25
38454** | FS-MA |  | 36.91 |  |  | 51.79 |  |  | 36.91
38535** | FT-A |  | 43.55 |  |  | 45.11 |  |  | 45.11
38539** | FT-A |  | 615.5 |  |  | 638.59 |  |  | 636.5
27848 | IT |  | 35109.91 |  |  | 854.75
80265 | SA |  |  | 2485.3 |  |  | 13555.9
none listed3 | none listed
**NYSEG capacity release
3 Finance and late charges for Jul and Aug 2001
Capacity Realease
Boston Gas |  | 29667 | NET-284 |  | 376753.5 | 374500 | 373660
ENA Agent-Nominates and Bills
Louisiana Gas Service |  | 1339 | FT-G |  | 1177.17 | 1949.88
Louisiana Gas Service |  | 2076 | FS-MA | -0.34 | 463.01 | 314.88
Reliant |  | 1440 | FT-G |  | 78226.02 | 61308.24 | 67226.12
Reliant |  | 1548 | FT-G |  | 72516.69 | 54455.95 | 66498.09
Reliant |  | 2210 | FS-MA |  | 35954.1 | 21275.44 | 31281.62
Spreadsheet: 122641d1317043280-substract-one-value-from-many-records-book1
Sheet: Sheet2

ID, | Name, | SUM | New sum |  | Enter ID: | 1
1 | A | 2.22 | 0 |  | Enter Value: | 4.22
1 | A | 3.34 | 1.340000000000001
1 | A | 2 | 2
2 | B | 3 | 3
2 | B | 3 | 3
3 | C | 4 | 4
Spreadsheet: 783860d1655210676-nested-if-statements-returning-true-rather-than-a-value-help_forums
Sheet: Specific Heats

Pressure | CP
25 | 0.52
50
150
200
300
350
450
500
600
Spreadsheet: 168416d1342448670-probability-of-time-loss-and-non-time-loss-accidents-sample-for-oscardeleon
Sheet: Sheet1

 | DATA
 |  |  |  | EVENT COUNT |  |  |  |  | EVENT PROBABILITY (by WO) |  |  |  |  | MEAN # EVENTS
 | year | work orders | months | unsafe incidents | time-loss | non-time-loss | fatalities |  | unsafe incidents | time-loss | non-time-loss | fatalities |  | unsafe incidents | time-loss | non-time-loss | fatalities
 | 1 | 8082 | 12 | 3 | 0 | 1 | 0
 | 2 | 9000 | 12 | 2 | 0 | 0 | 0
 | 3 | 10766 | 12 | 11 | 11 | 0 | 0 |  |  |  |  |  |  | Standard Deviation of EVENTS
 | 4 | 11533 | 12 | 8 | 8 | 0 | 0 |  |  |  |  |  |  | unsafe incidents | time-loss | non-time-loss | fatalities
 | TOTAL
Spreadsheet: 7b782099-4c68-4579-8075-cf0ea9fcb516
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
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2009-2010 |  |  | FY 2010-2011
 | General Fund
 | Special/Grant Revenue |  |  |  | 0 |  |  | 0
 | Enterprise
 |  |  | Total: | $ | 0 |  | $ | 0
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
 | Grant revenue to implement a Tobacco Use Prevention Program for the period of April 1, 2009 to March 31,
 | 2010.
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2009-2010 |  |  | FY 2010-2011
 | General Fund
 | Special/Grant Revenue |  |  |  | 0
 | Enterprise/Other
 |  |  | Total: | $ | 0 |  | $ | 0
 | 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
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: 1b9b439d-8be9-43f4-bf16-6dc4d02f6e2d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
 |  |  |  |  |  |  | 24hpi
 | EXPERIMENT 1 |  |  |  |  |  | EXPERIMENT 2 |  |  |  |  |  | EXPERIMENT 3
 | live (%) | dying (%) | dead (%) | p value |  |  | live (%) | dying (%) | dead (%) | p value |  |  | live (%) | dying (%) | dead (%) | p value
dsLacZ (n=446 ) | 31 | 2 | 67 |  |  | dsLacZ (n=310 ) | 48 | 8 | 44 |  |  | dsLacZ (n= 442) | 32 | 1 | 67
dsLp (n= 552) | 34 | 4 | 62 |  |  | dsLp (n=337 ) | 37 | 4 | 59 |  |  | dsLp (n=563 ) | 33 | 4 | 62
[NAME] (n=519 ) | 32 | 3 | 65 |  |  | [NAME] (n=208 ) | 44 | 7 | 49 |  |  | [NAME] (n=658 ) | 39 | 5 | 56
 |  |  |  |  |  |  | 48hpi
 | EXPERIMENT 1 |  |  |  |  |  | EXPERIMENT 2 |  |  |  |  |  | EXPERIMENT 3
 | live (%) | dying (%) | dead (%) |  |  |  | live (%) | dying (%) | dead (%) |  |  |  | live (%) | dying (%) | dead (%)
dsLacZ (n=590 ) | 32 | 13 | 55 |  |  | dsLacZ (n=105 ) | 59 | 13 | 28 |  |  | dsLacZ (n= 422) | 36 | 15 | 49
dsLp (n= 368) | 24 | 4 | 72 | p=0.005 |  | dsLp (n=87) | 30 | 9 | 61 | p<0.0001 |  | dsLp (n=376 ) | 23 | 4 | 73 | p=0.0001
[NAME] (n=303) | 16 | 10 | 74 | p<0.0001 |  | [NAME] (n=188 ) | 19 | 12 | 69 | p<0.0001 |  | [NAME] (n=216 ) | 14 | 10 | 76 | p<0.0001
Spreadsheet: 24665d1215364558-dynamic-form-list-boxes-got-an-error-on-g8-jk1234
Sheet: Sheet3

 | 2 Day Split | 4 Day Split | Full Body |  | Notes |  |  | Days to workout
 | Workout 1 | Workout 2 | Workout 6 |  | Workout 1 | 2 day on 1 day off |  | Monday | Tuesday | Wednesday | Thurs | Friday | Saturday | Sunday
 | Workout 2 | Workout 3 |  |  | Workout 2 | 2 day on 1 day off
 |  | Workout 4 |  |  | Workout 2 | 2 day on 1 day off
 |  | Workout 5 |  |  | Workout 3 | 2 day on 1 day off
 |  |  |  |  | Workout 4 | 2 day on 1 day off
 |  |  |  |  | Workout 5 | 2 day on 1 day off
 |  |  |  |  | Workout 6 | 2 day on 1 day off
 | Select Which Routine |  | This is where you select either 2 day/4 day or full body
 | Select the Workout |  | once the above is picked, a new list is generated where you can pick from which workout is under that label
 | Notes on workout |  | Notes pertaining to the selected value above
Spreadsheet: 2863fe39-d35f-4532-9b34-33a418f2435e
Sheet: Sheet1

COURSE ASSESSMENT MATRIX | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
COURSE: ANTH 213 TRIBAL SOCIEITIES IN TODAY'S WORLD
Objective | Assessment Method | Desired Result | Corrective Action
Describe different indigenous groups, including their cultures, histories, and current struggles | Participation Reading reports Oral report Midterm & final exams | Pass rate in said assignments: 70% | Revise reading assignments Revise lecture/online class content Revise exams
Explain strategies for recognition and involvement at the local, national and interational level. | Participation Reading reports Midterm & final exams | Pass rate in said assignments: 70% | Revise reading assignments Revise lecture/online class content Revise exams
Describe the ethnography research method. | Participation Reading reports Midterm & final exams | Pass rate in said assignments: 70% | Revise reading assignments Revise lecture/online class content Revise exams
Spreadsheet: 793612d1661578664-fix-data-columns-layout-songs-vstack-aligw
Sheet: Sheet

Original Data |  |  |  |  |  | Final Data
Vol. 001 |  |  |  |  |  | Vol. 001 |  |  | AliGW
Song | Vocalist | Song | Vocalist |  |  | Song | Vocalist
[NAME] Khser [NAME] | [NAME] | [NAME] | [NAME] |  |  | [NAME] Khser [NAME] | [NAME] |  |  | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] |  |  | [NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] 10 | Samouth+Sothea | [NAME] | [NAME] |  |  | [NAME] 10 | Samouth+Sothea |  | [NAME] 10 | Samouth+Sothea
Nov Smak Nov Sduy | [NAME] | [NAME] | [NAME] |  |  | Nov Smak Nov Sduy | [NAME] |  | Nov Smak Nov Sduy | [NAME]
Teuk Phnek Deum Chhnam | [NAME] | Bong Cham Ngor Ngum [NAME] | [NAME] |  |  | Teuk Phnek Deum Chhnam | [NAME] |  | Teuk Phnek Deum Chhnam | [NAME]
[NAME] Angvor | [NAME] | Bong Ches Taetam Khnom | Samouth+Sothea |  |  | [NAME] Angvor | [NAME] |  | [NAME] Angvor | [NAME]
[NAME] | Pen Ran | [NAME] Yub | Pen Ran |  |  | [NAME] | Pen Ran |  | [NAME] | Pen Ran
Vol. 002 |  |  |  |  |  | [NAME] | [NAME] |  | [NAME] | [NAME]
Song | Vocalist | Song | Vocalist |  |  | [NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | [NAME] | Chom Ork Cham Orn | Pen Ran |  |  | [NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] Own Na | [NAME] | Chompa Paylin | [NAME] |  |  | [NAME] | [NAME] |  | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] |  |  | Bong Cham Ngor Ngum [NAME] | [NAME] |  | Bong Cham Ngor Ngum [NAME] | [NAME]
La Bumbayer | [NAME] | [NAME] | [NAME] |  |  | Bong Ches Taetam Khnom | Samouth+Sothea |  | Bong Ches Taetam Khnom | Samouth+Sothea
Lear Phoum Sake Sok | [NAME] | Kbot Huey Kbot Theit - Sothea | [NAME] |  |  | [NAME] Yub | Pen Ran |  | [NAME] Yub | Pen Ran
Marina | [NAME] | [NAME] | [NAME] |  |  | Vol. 002
[NAME] Kern [NAME] | Samouth+Sothea | [NAME] | Pen Ran |  |  | Song | Vocalist
 |  |  |  |  |  | [NAME] | [NAME] |  |  | [NAME]
 |  |  |  |  |  | [NAME] Own Na | [NAME] |  | [NAME] Own Na | [NAME]
 |  |  |  |  |  | [NAME] | [NAME] |  | [NAME] | [NAME]
 |  |  |  |  |  | La Bumbayer | [NAME] |  | La Bumbayer | [NAME]
 |  |  |  |  |  | Lear Phoum Sake Sok | [NAME] |  | Lear Phoum Sake Sok | [NAME]
 |  |  |  |  |  | Marina | [NAME] |  | Marina | [NAME]
 |  |  |  |  |  | [NAME] Kern [NAME] | Samouth+Sothea |  | [NAME] Kern [NAME] | Samouth+Sothea
 |  |  |  |  |  | Chom Ork Cham Orn | Pen Ran |  | Chom Ork Cham Orn | Pen Ran
 |  |  |  |  |  | Chompa Paylin | [NAME] |  | Chompa Paylin | [NAME]
 |  |  |  |  |  | [NAME] | [NAME] |  | [NAME] | [NAME]
 |  |  |  |  |  | [NAME] | [NAME] |  | [NAME] | [NAME]
 |  |  |  |  |  | Kbot Huey Kbot Theit - Sothea | [NAME] |  | Kbot Huey Kbot Theit - Sothea | [NAME]
 |  |  |  |  |  | [NAME] | [NAME] |  | [NAME] | [NAME]
 |  |  |  |  |  | [NAME] | Pen Ran |  | [NAME] | Pen Ran
Spreadsheet: 827020d1682435958-vlookup-multiple-criteria-different-sheet-sample-document
Sheet: Sales Sample

Order ID | Channel | Invoice Prefix | Invoice Number | Customer ID | Order Date | Order Amaount | Item ID | Item Name | Qty | Unit Price | Item Amount | Shipping Cost | Tax | Total inc. VAT | Total Ex. VAT | Cost Per Unit | Total Costs | Total Shipping
100 | ECOMM1 |  | 200 | 0 | 2023-03-02 00:00:00 | 0 | SAMPLE1 |  | 2 | 50 | 100 | 20 | 34.27
101 | ECOMM1 |  | 201 | 0 | 2023-03-03 00:00:00 | 0 | SAMPLE3 |  | 1 | 300 | 300 | 20 | 64
102 | ECOMM1 |  | 202 | 0 | 2023-03-05 00:00:00 | 0 | SAMPLE1 |  | 20 | 9 | 180 | 0 | 36
103 | ECOMM2 |  | 203 | 0 | 2023-03-04 00:00:00 | 0 | SAMPLE1 |  | 5 | 8.71 | 43.55 | 0 | 8.71
104 | ECOMM2 |  | 204 | 0 | 2023-03-04 00:00:00 | 0 | SAMPLE1 |  | 8 | 8.71 | 69.68 | 0 | 13.94
105 | ECOMM2 |  | 205 | 0 | 2023-03-07 00:00:00 | 0 | SAMPLE4 |  | 1 | 148.33 | 148.33 | 0 | 29.67
106 | ECOMM3 |  | 206 | 0 | 2023-03-31 14:16:30 | 0 | SAMPLE4 |  | 1 | 205 | 203 | 0 | 33.83
107 | ECOMM3 |  | 207 | 0 | 2023-03-25 11:07:35 | 0 | SAMPLE1 |  | 1 | 18 | 18 | 0 | 3
108 | ECOMM3 |  | 208 | 0 | 2023-03-25 10:33:47 | 0 | SAMPLE2 |  | 1 | 33 | 33 | 0 | 5.5
109 | ECOMM3 |  | 209 | 0 | 2023-03-25 10:27:13 | 0 | SAMPLE1 |  | 1 | 18 | 18 | 0 | 3
Spreadsheet: 216716d1361863887-populate-fields-in-master-file-from-three-different-sources-sample-scenario
Sheet: Sheet1

 | Need to check the case numbers in three different sources if the case number matches check the version number in the same source then if that also matches populate the corresponding country name in master file else leave it blank
 | My Excel (Master File) |  |  |  | Different Excel (Source 1) |  |  |  | Different Excel (Source 2) |  |  |  | Different Excel (Source 3)
 | Case Number | Version Number | Country Name |  | Case Number | Version No | Country Name |  | Case Number | Version No | Country Name |  | Case Number | Version No | Country Name
 | 539 | 1 |  |  | 596 | 2 | USA |  | 118 | 1 | UK |  | 7238 | 13 | USA
 | 596 | 2 |  |  | 614 | 5 | China |  | 659 | 3 | Japan |  | 11141 | 1 | China
 | 614 | 5 |  |  | 1120 | 2 | UK |  | 671 | 8 | USA |  | 11582 | 0 | Spain
 | 1120 | 2
 | 1182 | 1
 | 118 | 1
 | 659 | 3
 | 671 | 8
 | 7202 | 3
 | 7238 | 13
 | 11141 | 1
 | 11582 | 0
 | 118 | 0
Spreadsheet: 117997d1313337225-conditional-formatting-help-example-of-coaching-timetable
Sheet: Weekly Training-Study Overview 

Weekly Training/Study Schedule
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
7.00 - 7.30 |  |  |  |  |  |  | Total Coaching Hrs/Income | 0.5 | 12.5 | 10 | 5
7.30 - 8.00 |  |  |  |  |  |  |  | 0.5 | 12.5 | 10 | 5
8.00 - 8.30 |  |  |  |  |  |  |  | 0.5 | 12.5 | 10 | 5
8.30 - 9.00 |  |  |  |  |  |  |  | 0.5 | 12.5 | 10 | 5
9.00 - 9.30 |  |  |  |  |  |  |  | 0.5 | 12.5 | 10 | 5
9.30 - 10.00 |  |  |  |  |  |  |  | 0.5 | 12.5 | 10 | 5
10.00 - 10.30 |  | PRO MN |  | PRO MN |  | PLANNING |  | 0.5 | 12.5 | 10 | 5
10.30 - 11.00 |  | PRO MN |  | PRO MN |  | PLANNING |  | 0.5 | 12.5 | 10 | 5
11.00 - 11.30 |  | PRO MN |  | PRO MN |  | PLANNING |  | 0.5 | 12.5 | 10 | 5
11.30 - 12.00 |  |  |  |  |  | PLANNING |  | 0.5 | 12.5 | 10 | 5
12.00 - 12.30 |  |  |  |  |  | PLANNING |  | 0.5 | 12.5 | 10 | 5
12.30 - 13.00 |  |  |  |  |  | PLANNING |  | 0.5 | 12.5 | 10 | 5
13.00 - 13.30 |  |  |  |  | PRO MN | PLANNING |  | 0.5 | 12.5 | 10 | 5
13.30 - 14.00 |  |  |  |  | PRO MN | PLANNING |  | 0.5 | 12.5 | 10 | 5
14.00 - 14.30 | PRO MN | PRO CH |  |  | PRO MN |  |  | 0.5 | 12.5 | 10 | 5
14.30 - 15.00 | PRO MN | PRO CH |  |  |  |  |  | 0.5 | 12.5 | 10 | 5
15.00 - 15.30 | PRO MN | PRO CH |  |  |  |  |  | 0.5 | 12.5 | 10 | 5
15.30 - 16.00 |  |  |  |  |  |  |  | 0.5 | 12.5 | 10 | 5
16.00 - 16.30 |  |  |  | PRI 1 CM | PRI 2 RK |  |  | 0.5 | 12.5 | 10 | 5
16.30 - 17.00 |  |  | PRI 1 RK | PRI 1 CM | PRI 2 RK |  |  | 0.5 | 12.5 | 10 | 5
17.00 - 17.30 |  |  | PRI 1 RK | PRI 1 JM | PRI 1 CW |  |  | 0.5 | 12.5 | 10 | 5
17.30 - 18.00 |  |  | PRI 1 MR | PRI 1 JM | PRI 1 CW |  |  | 0.5 | 12.5 | 10 | 5
18.00 - 18.30 |  | PRI 1 SD | PRI 1 MR | EPT | PRI 1 TV |  |  | 0.5 | 12.5 | 10 | 5
18.30 - 19.00 |  | PRI 1 SD | PRI 1 DT | EPT | PRI 1 TV |  |  | 0.5 | 12.5 | 10 | 5
19.00 - 19.30 |  | PC | PRI 1 DT | EPT | PRI 2 CH |  |  | 0.5 | 12.5 | 10 | 5
19.30 - 20.00 |  | PC | EPT | EPT | PRI 2 CH |  |  | 0.5 | 12.5 | 10 | 5
20.00 - 20.30 | PC | PC | EPT | UNI | PRI 2 AL/CL |  |  | 0.5 | 12.5 | 10 | 5
20.30 - 21.00 | PC | PC | EPT | UNI | PRI 2 AL/CL |  |  | 0.5 | 12.5 | 10 | 5
21.00 - 21.30 | PC |  | EPT | UNI | PRI 2 AL/CL |  |  | 0.5 | 12.5 | 10 | 5
21.30 - 22.00 | PC |  |  | UNI |  |  |  | 0.5 | 12.5 | 10 | 5
Total hrs
 | EPT (England Performance Training) |  |  |  | PRO (Programme Players)
 | PC (Performance Centre Coaching) |  |  |  | PRI 1 (Private Coaching @ )
 | UNI (Manchester University Coaching) |  |  |  | PRI 2 (Private Coaching @)