tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 764367d1642701064-find-start-date-and-end-date-startdateandenddate
Sheet: Sheet1

Emp Id | Emp Name | Month
1001 | A | 2021-01-01 00:00:00
1001 | A | 2021-02-01 00:00:00
1001 | A | 2021-03-01 00:00:00 |  |  | Output
1001 | A | 2021-04-01 00:00:00 |  |  | Emp Id | Start Month | End Month
1001 | A | 2021-05-01 00:00:00 |  |  | 1001 | 2021-01-01 00:00:00 | 2021-08-01 00:00:00
1001 | A | 2021-06-01 00:00:00 |  |  | 1002 | 2021-01-01 00:00:00 | 2021-11-01 00:00:00
1001 | A | 2021-07-01 00:00:00 |  |  | 1003 | 2021-09-01 00:00:00 | 2021-09-01 00:00:00
1001 | A | 2021-08-01 00:00:00 |  |  | 1004 | 2021-10-01 00:00:00 | 2021-12-01 00:00:00
1002 | B | 2021-01-01 00:00:00
1002 | B | 2021-03-01 00:00:00 |  |  | Emp Id | Start | End
1002 | B | 2021-08-01 00:00:00 |  |  | 1001 | 2021-01-01 00:00:00 | 2021-08-01 00:00:00
1002 | B | 2021-09-01 00:00:00 |  |  | 1002 | 2021-01-01 00:00:00 | 2021-11-01 00:00:00
1002 | B | 2021-10-01 00:00:00 |  |  | 1003 | 2021-09-01 00:00:00 | 2021-09-01 00:00:00
1002 | B | 2021-11-01 00:00:00 |  |  | 1004 | 2021-10-01 00:00:00 | 2021-12-01 00:00:00
1003 | C | 2021-09-01 00:00:00
1004 | D | 2021-10-01 00:00:00
1004 | D | 2021-10-01 00:00:00
1004 | D | 2021-11-01 00:00:00
1004 | D | 2021-12-01 00:00:00
Spreadsheet: 717898d1612891590-if-vlookup-if-vlookup-is-blank-run-if-formula-if-still-blank-return-a-blank-sample-data
Sheet: Tab 1

Order # | Provider | Service | Zone | DDP Zone | DDU Zone
85594-089 | APC | DDP |  | LA
85594-088 | APC | DDU |  |  | Middle
27331 | UPS | Ground
10286 | Stamps.com | FCM | 7
10285 | Stamps.com | PM | 3
Spreadsheet: dcd29ed5-fe23-4f59-86ef-9b26ca120913
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0030190 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | [NAME] | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Scotland | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  | 2 |  | Field Name: |  | 3A |  | Field Name: |  | 3B
 |  |  |  |  |  | Area (acres): |  | 5.57 |  | Area (acres): |  | 5.33 |  | Area (acres): |  | 2.95 |  | Area (acres): |  | 2.95
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.5 |  | [NAME] (in): |  | 0.5 |  | [NAME] (in): |  | 0.4 |  | [NAME] (in): |  | 0.4
 |  |  |  |  |  | Annual Rate (in): |  | 57.01 |  | Annual Rate (in): |  | 57.01 |  | Annual Rate (in): |  | 57.01 |  | Annual Rate (in): |  | 57.01
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 711442d1609714237-adding-spaces-to-numbers-in-mixed-data-testing-formula-v2
Sheet: Sheet1

Alpha Delta [NAME], Red Holden |  |  | Incorrect
123 Alpha Bravo Charlie, Black Ford |  |  | Incorrect
Alpha 12 Charlie 3 Delta, [NAME] |  |  | Incorrect
 | ALPHA DELTA CHARLIE 1 2 3 |  | Correct
 | 1 2 3 ALPHA BRAVO CHARLIE |  | Correct
 | ALPHA 1 2 CHARLIE 3 DELTA |  | Correct
What change can I make to the formula in B1 to B3 to make it give result as in B5 to B7
Spreadsheet: 838314d1690911078-display-amount-only-if-current-month-auto-ins-display-amt_example-8-1-2023
Sheet: Sheet1

 |  | Auto & Home   Insurance             YEAR - |  | 2023
 |  |  | Total (Spent) Year to Date :
 | Choose month below! |  | Total (Spent in) Current Month :
 |  | Amt spent in selected Month | Average Weekly Cost of Insurances :
 | 2023-04-23 00:00:00
LINE | DATE | CATEGORY | POLICY NUMBER | PMNT $
1 | 2023-01-01 00:00:00 | HOME OWNER INS. |  | 110.83 |  | Amt Spent in Auto Ins. In current month: | 0
 | 2023-04-03 00:00:00 | AUTO INS. |  | 1495
 | 2023-05-21 00:00:00 | MOTORCYCLE INS. |  | 6.71
 | 2023-08-01 00:00:00 | AUTO INS. | <---- For test purpose's only | 10
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
Spreadsheet: 871128d1717566140-populate-data-based-on-keyword-tamit-blank-form_test
Sheet: E) Server Monitoring Sware Lic.

Home Requestor [NAME]
 |  |  |  | Below Data are just Sample. Please overwrite the data
 |  |  |  | Provide Appl Email Support Grp | [EMAIL]
 |  |  |  | Provide GO LIVE Date
List of OS/DB are being monitored
OS/DB | PLATFORM |  |  | Automatically populated when key in hostname
Unix OS | UX | UX/AIX/SunSol |  | Asset Name | PLATFORM | APP CODE | [NAME] | PROD/DR Only | Operating System | Asset Function | Database | IP address
Linux OS | LZ |  |  | MYDVVWINTREX01
DB - DB2 | DB2
DB - MsSQL | SQL
DB - Oracle | ORX
DB - Sybase | SYB
PingHost | PH
Spreadsheet: 74699d1275228621-insert-field-or-item-in-pivottable-inserted-field-forum
Sheet: Revenue

 | Revenue & Segmenter pr. agent
 | [NAME]: Januay - Mars 2010
 | Country | (All)
 | Agent Chain | (All)
 |  | Values
 | Row Labels | Sum of Revenue Act | Sum of Revenue LY | Sum of Revenue ILY
 | London | 2487.056053576181 | 5137.110181808065 | 48.41352366518314
 | Firm AA | 26.15955 | 2.43857 | 1072.741401723141
 | Contracted Volume | 10.58354 | 2.43857 | 434.0059953169275
 | Non Contracted Volume | 15.57601 | 0 | 0
 | Firm BB | 16.50892 | 50.27883 | 32.83473382336064
 | Contracted Volume | 2.71053 | 13.73155 | 19.73943218354811
 | Non Contracted Volume | 13.79839 | 36.54728 | 37.75490269043277
 | Firm CC | 226.53497 | 316.5542 | 71.56277503189027
 | Contracted Volume | 63.37684 | 63.55417 | 99.72097818286355
 | Non Contracted Volume | 163.15813 | 253.00003 | 64.48937179967925
 | [NAME] | 80.7304 | 68.71639 | 117.4834708284297
 | Contracted Volume | 19.46352 | 9.78788 | 198.8532756838049
 | Non Contracted Volume | 61.26688 | 58.92851 | 103.9681471667958
 | Firm EE | 37.93145 | 93.59291 | 40.52812333754768
 | Contracted Volume | 29.28915 | 34.80022 | 84.16369206861334
 | Non Contracted Volume | 8.642299999999999 | 58.79269 | 14.69961656797809
 | Firm FF | 2040.326343576181 | 4515.209791808065 | 45.18785256175559
 | Contracted Volume | 783.1067835761804 | 1629.229261808066 | 48.06608879017518
 | Non Contracted Volume | 1257.21956 | 2885.98053 | 43.56299520842575
Spreadsheet: 760439d1640201937-i-dont-know-how-to-describe-what-i-want-to-do-sample1
Sheet: Margin Sheet 2.0

Dynacom Entry
 | Landed Cost | FARMER | GROUP 1 | GROUP 2 | GROUP 3 | GROUP 4 | GROUP 5 | GROUP 7 | GROUP 8 | Group 10 | Native Grp 5 | [NAME]
 |  |  | 0.1860000000000002 | 0.1760000000000002 | 0.1660000000000001 | 0.06499999999999995 | 0.05499999999999994 | 0.03499999999999992 | 0 | 0.02499999999999991 | 0.05999999999999983 | 0.1760000000000002
 |  |  | 0.1860000000000002 | 0.1760000000000002 | 0.1660000000000001 | 0.06499999999999995 | 0.05499999999999994 | 0.03499999999999992 | 0 | 0.02499999999999991 | 0.05999999999999983 | 0.1760000000000002
 |  |  | 0.1260000000000001 | 0.1160000000000001 | 0.1060000000000001 | 0.06499999999999995 | 0.05499999999999994 | 0.03499999999999992 | 0 | 0.02499999999999991 | 0.05999999999999983 | 0.1160000000000001
 |  |  | 0.1830000000000001 | 0.173 | 0.163 | 0.07499999999999996 | 0.06499999999999995 | 0.03499999999999992 | 0 | 0.02499999999999991 | 0.05999999999999983 | 0.173
 |  |  | 0.09699999999999998 | 0.08699999999999997 | 0.07699999999999996 | 0.05000000000000004 | 0.04000000000000004 | 0.03499999999999992 | 0 | 0.02499999999999991 | 0.05999999999999983 | 0.08699999999999997
 |  |  | 0.09699999999999998 | 0.08699999999999997 | 0.07699999999999996 | 0.05000000000000004 | 0.04000000000000004 | 0.03499999999999992 | 0 | 0.02499999999999991 | 0.05999999999999983 | 0.08699999999999997
Spreadsheet: 24869d1215748266-totals-from-two-criteria-sales-amount-and-sales-agent-name-stores-stats-sample-build
Sheet: Stats Sheet

Sales1 |  |  |  |  |  |  |  |  | A1 is a dropdown, click on it
Performance |  |  |  |  | Pipeline
 | Total | Mean | Median |  | Newsletters | Follow-ups | Overdue Follow-ups (7 Days) | Over 10 days
Sold | 14 |  |  |  | 17
 | Total | Mean | Median |  | You generated… | 0 | in future monthly revenues this week!
Undecided | 3
 |  |  |  |  | Upsells | Totals
 | Total | Mean | Median |  | PayPal
Declined | 15 |  |  |  | Designer Services
Breakdown
 |  |  |  |  | [NAME] | Total | Mean (Rep) | Median
Totals & Discrepancies | Total | Mean | Median |  | Express | 1 | 2 | 1
MediaPlex |  |  |  |  | Business | 12 | 5.666666666666663 | 4
Errors Between SF and MP |  |  |  |  | Advanced | 1 | 0.6666666666666665 | 1
SF Duplicates |  |  |  |  | Enterprise | 0 | 0 | 0
Original Call Totals | Total | Mean | Median |  | 90 Day Attendance | New QC Cases | New QC Case Avg. | [NAME]
Sold
Undecided
Declined |  |  |  |  | Department Comparison chart
 |  |  |  |  | Sold (SF and MediaPlex)
First Followup Totals | Total | Mean | Median
Sold |  |  |  |  | 1 Week
Undecided
Declined
Second Followup Totals | Total | Mean | Median
Sold
Undecided
Declined
Total Follow-ups | Total | Mean | Median |  | Department Comparison chart
Sold |  |  |  |  | Sold/Undecided/Rejected/Newsletters/Follow-Ups
Undecided
Declined
Indivdual Prediction Graph (Regression Analysis)
Sold/Undecided/Rejected/Newsletters/Follow-ups |  |  |  |  | 1 Week
 |  |  |  |  | Department Comparison chart
 |  |  |  |  | Sold (SF and MediaPlex)
Department Prediction Graph (Regression Analysis)
Sold/Undecided/Rejected/Newsletters/Follow-ups |  |  |  |  | 12 Weeks
 |  |  |  |  | Department Comparison chart
 |  |  |  |  | Sold/Undecided/Rejected/Newsletters/Follow-Ups
 |  |  |  |  | 12 Weeks
Spreadsheet: 0cad06f8-1723-441f-83ef-a1105dec0633
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
POSV | Test | POSV | Post [NAME], Semen | Post [NAME], Semen | Manual | Semen analysis kit: SemAnl |  |  |  | Varies | [NAME] must arrive within 24 hours of collection. Send specimen Monday through Thursday only and not the day before a holiday. If holiday falls on a Saturday, holiday will be observed on the preceding Friday. Sunday holidays are observed on the following Monday. [NAME] should be collected and packaged as close to shipping time as possible. Laboratory does not perform testing on weekends.   Container/Tube: Semen [NAME] (Supply T178) [NAME]: Total ejaculate Collection Instructions: Patient should have 2 to 7 days of sexual abstinence at the time of semen collection for accurate results. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | Zero sperm seen | Monday through Friday; Upon arrival | 1 day | 4 days | 1 | 89321 |  |  |  |  | Rochester
POSV | [NAME] | SEMEN | Semen |  |  |  | Ambient
POSV | Result | ABSTN | Abstinence | Abstinence | Numeric |  |  |  |  | d |  |  |  |  |  |  |  |  |  | 10587-4
POSV | Result | CLST1 | Collection Site | Collection Site | Alphanumeric
POSV | Result | VL53 | Semen Volume | Semen Volume | Numeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | 3160-9
POSV | Result | CENT | Centrifuged | Centrifuged | Alphanumeric
POSV | Result | SPML1 | Sperm/mL | Sperm/mL | Numeric |  |  |  |  | x10(6) |  |  |  |  |  |  |  |  |  | 9780-8
POSV | Result | MOTIL | Motility | Motility | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 6800-7
POSV | Result | GR3 | Grade | Grade | Numeric
POSV | Result | CMMT4 | Comment | Comment | Alphanumeric
Spreadsheet: 149718d1334093626-how-to-skip-blank-cells-see-pic-forum
Sheet: Arkusz1

erw
wer
rwer
asda
sad
Spreadsheet: 235586d1368544364-sum-with-time-elapsed-criteria-employee20points
Sheet: Points

Date | Employee Name | Points
2012-03-08 00:00:00 | [NAME] | 1
2012-03-26 00:00:00 | [NAME] | 1
2012-04-08 00:00:00 | [NAME] | 1
2012-05-01 00:00:00 | [NAME] | 1
2012-05-14 00:00:00 | [NAME] | 1 |  | Employee | Cumulative Points | Months Since  Last Point | Date of Most Recent Point
2012-06-11 00:00:00 | [NAME] | 1 |  | [NAME]
2012-07-11 00:00:00 | [NAME] | 1 |  | [NAME]
2012-07-29 00:00:00 | [NAME] | 1 |  | [NAME]
2012-10-05 00:00:00 | [NAME] | 1 |  | [NAME]
2012-11-26 00:00:00 | [NAME] | 1 |  | [NAME]
2012-11-29 00:00:00 | [NAME] | 1
2012-12-01 00:00:00 | [NAME] | 1
2012-12-04 00:00:00 | [NAME] | 1
2013-01-19 00:00:00 | [NAME] | 1
2013-03-17 00:00:00 | [NAME] | 1
2013-04-18 00:00:00 | [NAME] | 1
2013-10-18 00:00:00 | [NAME] | 0.5 |  | <------should read .5
2013-10-19 00:00:00 | [NAME] | 1 |  | <------should be 1.5
Spreadsheet: 8709871e-487b-47fb-8f61-f1e73f42cffc
Sheet: Table 8.2

8.2 Consumer prices
 |  |  |  |  |  | Months (a)
 | Annual average (a) (b) |  |  |  |  | 2013 |  |  | 2014
Country | 2010 | 2011 | 2012 | 2013 |  | Oct | Nov | Dec | Jan
Australia (c) | 2.85 | 3.39 | 1.76 | 2.45 |  |  |  | 2.75
Canada | 1.78 | 2.91 | 1.52 | 0.9400000000000001 |  | 0.65 | 0.9 | 1.24 | 1.48
China | 3.31 | 5.41 | 2.65 | 2.63 |  | 3.2 | 3 | 2.5 | 2.5
France | 1.53 | 2.12 | 1.96 | 0.85 |  | 0.59 | 0.67 | 0.66 | 0.63
Germany | 1.1 | 2.08 | 2.01 | 1.5 |  | 1.24 | 1.34 | 1.43 | 1.34
Indonesia | 5.13 | 5.36 | 4.28 | 6.98 |  | 8.32 | 8.370000000000001 | 8.38
Italy | 1.54 | 2.74 | 3.04 | 1.22 |  | 0.75 | 0.66 | 0.66 | 0.66
Japan | -0.72 | -0.28 | -0.03 | 0.36 |  | 1.1 | 1.61 | 1.61 | 1.41
Korea (South) | 2.96 | 4 | 2.19 | 1.31 |  | 0.85 | 1.21 | 1.14 | 1.08
Malaysia | 1.71 | 3.2 | 1.66 | 2.11 |  | 2.75 | 2.94 | 3.22 | 3.4
New Zealand (c) | 2.3 | 4.43 | 0.88 | 0.92 |  |  |  | 1.63
Philippines | 3.88 | 4.65 | 3.17 | 2.97 |  | 2.89 | 3.35 | 4.11 | 4.24
Singapore | 2.8 | 5.25 | 4.53 | 2.4 |  | 2.01 | 2.62 | 1.48 | 1.39
Thailand | 3.27 | 3.81 | 3.01 | 2.18 |  | 1.46 | 1.92 | 1.67 | 1.93
United Kingdom | 3.29 | 4.48 | 2.82 | 2.55 |  | 2.17 | 2.09 | 2 | 1.85
United States | 1.64 | 3.16 | 2.07 | 1.46 |  | 0.96 | 1.24 | 1.5 | 1.58
OECD average | 1.853738032185774 | 2.870000000000005 | 2.255273646349755 | 1.60661659853598 |  | 1.302747097139623 | 1.485476393225471 | 1.637172328948622 | 1.664302600472811
G7 average | 1.409593347530677 | 2.620000000000005 | 1.880725004872337 | 1.329507412721187 |  | 1.046025104602522 | 1.278381988170185 | 1.422298587247028 | 1.430888104550232
Euro-zone average | 1.615689462453006 | 2.719999999999999 | 2.492211838006233 | 1.348784194528877 |  | 0.7247058823529384 | 0.8488163727247144 | 0.8457056944183527 | 0.7691577248124526
(a) Percentage change in consumer price indexes over previous year.
(b) Years shown are calendar years.
(c) Data only available quarterly.
Source: Datastream
http://www.abs.gov.au/ausstats/abs@.nsf/mf/6401.0/ | http://www.abs.gov.au/ausstats/abs@.nsf/mf/6401.0/ | http://www.abs.gov.au/ausstats/abs@.nsf/mf/6401.0/ | http://www.stats.govt.nz/default.htm | http://www.stats.govt.nz/default.htm
 |  |  |  |  |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  |  |  |  |  | Early May 2014
Spreadsheet: 228058d1365981097-fun-help-with-projecting-mlb-season-final-standing-etc-braves-2013-2-with-chart
Sheet: Sheet1

Created by: |  |  |  |  |  |  | 83 | 15
http://www.exceldashboardtemplates.com |  |  |  |  |  |  | Wins to get to playoffs
 | games played | won | lost | percentage | Win Pace | Lost Pace | [NAME] | [NAME]
 |  | 1 | 0
 |  | 2 | 0
 |  | 2 | 1
 |  | 3 | 1
 |  | 4 | 1
 |  | 5 | 1
 |  | 6 | 1
 |  | 7 | 1
 |  | 8 | 1
 |  | 9 | 1
 |  | 10 | 1
Spreadsheet: 102627d1300588970-multiple-dependent-lists-test_sheet_wolist2
Sheet: Lists

Goal |  | Exercise |  | Sets |  | Reps |  | Rest
strength |  | Strength |  | Strength |  | Strength |  | Strength
core |  | squats |  | 8 |  | 6 |  | 5min
power |  | deadlifts |  | 7 |  | 5 |  | 4min
esd |  | bench press |  | 6 |  | 4 |  | 3min
 |  | pull-ups |  | 5 |  | 3 |  | 2min
 |  | Core |  | Core |  | Core |  | Core
 |  | Plank |  | 5 |  | 1 |  | 60sec
 |  | Side Plank |  | 4 |  | 2 |  | 45sec
 |  | Rollout |  | 3 |  | 8 |  | 30sec
 |  | hyperexntension |  | 2 |  | 15
 |  | Power |  | Power |  | Power |  | Power
 |  | Hang Clean |  | 6 |  | 5 |  | 60sec
 |  | Power Clean |  | 5 |  | 4 |  | 90sec
 |  | Snatch |  | 4 |  | 3 |  | 120sec
 |  | DB snatch |  | 3 |  | 2 |  | 150sec
 |  | ESD |  | ESD |  | ESD |  | ESD
 |  | [NAME] |  | AMAP |  | 25 |  | ALAP
 |  | Tabata |  | 3 |  | AMAP |  | 30sec
 |  | Intervals |  | 2 |  | 10 |  | 60sec
 |  | [NAME] |  | 1 |  | 5 |  | 90sec
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Apr21-Apr27m

Main Arena
 | 2013-04-21 00:00:00 |  |  | Thru | 2013-04-27 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2013-04-21 00:00:00 | 2013-04-22 00:00:00 | 2013-04-23 00:00:00 | 2013-04-24 00:00:00 | 2013-04-25 00:00:00 | 2013-04-26 00:00:00 | 2013-04-27 00:00:00 |  |  |  | Blocks | Team | Hours
7:00AM |  |  |  |  |  |  |  | 7:00AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:00AM |  |  |  |  |  |  |  | 10:00AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:00AM |  |  |  |  |  |  |  | 11:00AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:00PM |  |  |  |  |  |  |  | 12:00PM
1:00PM |  |  |  |  |  |  |  | 1:00PM
2:00PM |  |  |  |  |  |  |  | 2:00PM
3:00PM |  |  |  |  |  |  |  | 3:00PM
4:00PM |  |  |  |  |  |  |  | 4:00PM
5:00PM |  |  |  |  |  |  |  | 5:00PM
6:00PM |  |  |  |  |  |  |  | 6:00PM
7:00PM |  |  |  |  |  |  |  | 7:00PM
8:00PM |  |  |  |  |  |  |  | 8:00PM
9:00PM |  |  |  |  |  |  |  | 9:00PM
10:00PM |  |  |  |  |  |  |  | 10:00PM
11:00PM |  |  |  |  |  |  |  | 11:00PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 140619d1328821171-inventory-yfeb-food-total-values
Sheet: 2-29-12

 | Breakfast | Quantity | Measure | Food Item | Cost | Daily Points
 | Daily Total
 | Lunch | Quantity | Measure | Food Item | Cost | Daily Points
 | Dinner | Quantity | Measure | Food Items | Cost | Daily Points
Spreadsheet: 843606d1695386610-name-row-based-on-column-value-camp-w-largest-solution-1-
Sheet: Sheet1

Name | Assiniboia | Koinonia | Moose Lake | Test 1 | Test 2 | Test 3 | Test 4 | Test 5 | Test 6 | Test 7 | Solution
 | 3 | 1 | 4 | 4 | 3 | 0 | 3 | 4 | 4 | 3
Test 1 | 4 | 0 | 2 | 2 | 2 | 0 | 2 | 2 | 2 | 0
Test 2 | 1 | 5 | 4 | 4 | 4 | 4 | 0 | 4 | 0 | 0
Assiniboia | 5 | 3 | 3 | 3 | 3 | 3 | 0 | 0 | 0 | 0
Test 3 | 3 | 1 | 3 | 3 | 3 | 3 | 0 | 0 | 0 | 3
Test 4 | 1 | 0 | 3 | 2 | 2 | 2 | 2 | 0 | 0 | 0
Koinonia | 3 | 0 | 3 | 3 | 3 | 3 | 3 | 0 | 0 | 0
Test 5 | 1 | 0 | 3 | 3 | 3 | 3 | 3 | 0 | 0 | 3
Spreadsheet: 841469d1693641739-sumifs-formula-sample
Sheet: New Scheme

HR NO. | EMPLOYEE NAME | COMPANY | POSITION | Comb | BASIC | Tgt | Week |  |  |  |  | Week |  |  |  |  | Week |  |  |  |  | Week |  |  |  |  | Week |  |  |  |  | Old Total | New Total | Diff
 |  |  |  |  |  |  | 1 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 4 |  |  |  |  | 5
 |  |  |  |  |  |  | Acht | El.Pt | Old | El. Slab | New | Acht | El.Pt | Old | El. Slab | New | Acht | El.Pt | Old | El. Slab | New | Acht | El.Pt | Old | El. Slab | New | Acht | El.Pt | Old | El. Slab | New
18621 | Malik | ABC | Tech Driver | A | 3150 | 42
11639 | [NAME] | ABC | Tech Driver | A | 3150 | 42
21073 | Rachel | ABC | Tech | A | 2650 | 42
18376 | Aaliyah | ABC | Tech Driver | C | 2650 | 42
25343 | LaToya | ABC | Helper | A | 3000 | 42
25344 | Daquan | RAK | Tech Driver | A | 3000 | 36
19286 | Bridget | RAK | Tech Driver | C | 1600 | 42
2097 | Giovanni Russo | RAK | Driver | A | 3150 | 36
24974 | Sophia | ABC | Tech | A | 2250 | 42
12102 | Luca | RAK | Tech Driver | C | 3150 | 42
Spreadsheet: 810941d1672184742-taking-a-break-on-time-sheet-test
Sheet: Feuil1

Week Ending  Date | Regular Hours Worked |  | Overtime Hours Worked |  | Lunch | Total Hours |  | Week Ending  Date | Regular Hours Worked |  | Overtime Hours Worked |  | Lunch | Total Hours
2018-12-10 00:00:00 | From | To | From | To |  |  |  | 2018-12-17 00:00:00 | From | To | From | To
Mon. | 07:00:00 | 15:30:00 | 15:30:00 | 17:45:00 | :30 |  |  | Mon. | 07:00:00 | 15:00:00 |  |  | 00:00:00
[NAME]. | 07:00:00 | 15:30:00 | 15:30:00 | 17:45:00 | :30 |  |  | [NAME]. | 09:00:00 | 17:00:00 | 17:00:00 | 22:00:00 | 00:00:00
Wed. | 07:00:00 | 15:30:00 | 15:30:00 | 16:30:00 | :30 |  |  | Wed. | 08:30:00 | 16:00:00 |  |  | :30
Thurs. | 07:00:00 | 15:30:00 | 15:30:00 | 17:45:00 | :30 |  |  | Thurs. | 07:00:00 | 15:15:00 | 15:15:00 | 16:30:00 | :15
Fri. |  |  | 09:30:00 | 17:30:00 | :30 |  |  | Fri. | 09:00:00 | 17:30:00 |  |  | :30
Sat. |  |  |  |  |  |  |  | Sat. |  |  | 08:30:00 | 17:15:00 | 00:00:00
Sun. |  |  | 04:30:00 | 14:00:00 |  |  |  | Sun. |  |  | 09:30:00 | 17:30:00 | :30
Week's Total Hours |  |  |  |  |  |  |  | Week's Total Hours
Week Ending  Date | Regular Hours Worked |  | Overtime Hours Worked |  | Lunch | Total Hours |  | Week Ending  Date | Regular Hours Worked |  | Overtime Hours Worked |  | Lunch | Total Hours
2018-12-22 00:00:00 | From | To | From | To |  |  |  | 2018-12-29 00:00:00 | From | To | From | To
Mon. | 07:00:00 | 15:00:00 |  |  |  |  |  | Mon. | 08:00:00 | 16:00:00 | 16:00:00 | 17:00:00
[NAME]. | 08:00:00 | 16:00:00 | 16:00:00 | 16:30:00 |  |  |  | [NAME].
Wed. | 07:30:00 | 15:30:00 | 15:30:00 | 16:00:00 |  |  |  | Wed.
Thurs. | 08:00:00 | 16:00:00 | 16:00:00 | 17:00:00 | :45 |  |  | Thurs.
Fri. | 07:00:00 | 15:30:00 | 15:30:00 | 17:00:00 | :30 |  |  | Fri.
Sat. |  |  |  |  |  |  |  | Sat.
Sun. |  |  |  |  |  |  |  | Sun.
Week's Total Hours |  |  |  |  |  |  |  | Week's Total Hours
Week Ending  Date | Regular Hours Worked |  | Overtime Hours Worked |  | Lunch | Total Hours |  | RECAP OF HOURS WORKED
 | From | To | From | To |  |  |  | STRAIGHT TIME |  |  |  |  | 9A0A
Mon. |  |  |  |  |  |  |  | 1 day, 16:00:00 | 1 day, 16:00:00 | 1 day, 16:00:00 | 1 day, 16:00:00 | 1 day, 16:00:00
[NAME].
Wed. |  |  |  |  |  |  |  | 1900-01-05 00:00:00
Thurs.
Fri.
Sat. |  |  |  |  |  |  |  | OTHER
Sun.
Week's Total Hours
 |  |  |  |  |  |  |  | TOTAL OVERTIME HOURS
Spreadsheet: michelle_lokay__26561__imbalsumm0012
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 93344 | 93623
2 | 90757 | 82485
3 | 79881 | 83564
4 | 86932 | 85573
5 | 91421 | 89951
6 | 93012 | 90323
7 | 112781 | 112264
8 | 107002 | 105320
9 | 103512 | 98386
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  | -15891
2000-12-09 00:00:00
Spreadsheet: 42917d1241541965-removing-duplicates-from-validation-list-unique-validationlist
Sheet: Sheet1

cat |  | 1st formula | bird | List |  |  | [NAME]
dog |  | 2nd, copy down | cat
cat |  |  | dog
cat |  |  | hamster |  |  | [NAME] in D1 and D2 are array formulas, confirm any changes
dog |  |  |  |  |  | with CTRL-SHIFT-ENTER.
bird
hamster |  |  |  |  |  | This does it without helper cells
cat |  |  |  |  |  | and also results are sorted, but the calculations
dog |  |  |  |  |  | occuring are much greater. Do not use this
cat |  |  |  |  |  | technique to work against a very large dataset or
cat |  |  |  |  |  | the spreadsheet may slow down dramatically.
dog
bird |  |  |  |  |  | A dynamic name range [NAME] always shows
hamster |  |  |  |  |  | only the values in column D, no blanks.
 |  |  |  |  |  | [EMAIL]
 |  |  |  |  |  | ...for any questions about adapting it.