tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1457817f-4262-499a-9f21-bc7538e4c813
Sheet: Sheet1

Date: Week # 1 | Age/grade:                 9-12 | 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 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | COMMENTS/                   RESULTS
 |  | List food from menu that fit into each category |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly Results/Totals
Component | New Meal Pattern | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  |  | Actual Totals | Required Totals (for the week) in cups | Quantity Difference (actual vs required) | RESULTS
 |  | Item | cups | Item | cups | Item | cups | Item | cups | Item | cups | Item | cups | Item | cups
FRUIT
FRUIT | 1 cup of fruit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 7 | -7 | DOES NOT MEET
Fruit Totals                     (for each day) |  | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0
VEGETABLE
VEGETABLES - 1 cup of vegetables/day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.5 | -0.5 | DOES NOT MEET
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1.25 | -1.25 | DOES NOT MEET
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.5 | -0.5 | DOES NOT MEET
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.5 | -0.5 | DOES NOT MEET
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.75 | -0.75 | DOES NOT MEET
Required total adds up to 3 ½ cups; weekly total of all vegetables  is 7 cups | 3 1/2 cup additional | Additional Vegetables |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 3.5 | -3.5 | DOES NOT MEET
VEGETABLE TOTALS (for each day) |  | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 |  | 0 | 7 | -7 | DOES NOT MEET
Component | New Meal Pattern | Item | oz. eq. | Item | oz. eq. | Item | oz. eq. | Item | oz. eq. | Item | oz. eq. | Item | oz. eq. | Item | oz. eq. |  | Actual Totals | Required Totals (for the week)
GRAINS & BREADS
 | Grains (list all WGR and non-WGR) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 14-17 (2 oz eq per day minimum) |  | DOES NOT MEET
 | List only WGR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Half of all grains must be whole grain |  | MEETS
MEAT / MEAT ALTERNATE |  |  | oz |  | oz |  | oz |  | oz |  | oz |  | oz |  | oz
 | Minimum of 2 oz per day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 14-17 per week (minimum of 2 oz eq per day) |  | DOES NOT MEET
MILK
 | Non-fat (flavored or unflavored) or 1% unflavored |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Offer 1 cup/day |  | DOES NOT MEET
Spreadsheet: 09905008-5e92-4396-ba5e-a57eb6f6952e
Sheet: ClassDataSheet

What is DBH?
 | Circumference measured (1) | Circumference measured (2) | Circumference measured (3) | Circumference average (C1+C2+C3)/3 | Circumference calculated (3.14*diameter) | Notes
Cookie 1
[NAME]
Cookie 3
[NAME]
Cookie 5
Cookie 6
Cookie 7
Cookie 8
Cookie 9
Cookie 10
Cookie 11
Cookie 12
 | Diameter measured (1) | Diameter measured (2) | Diameter measured (3) | Diameter average ([NAME] | Diameter calculated (circumference/ 3.14) | Notes
Cookie 1
[NAME]
Cookie 3
[NAME]
Cookie 5
Cookie 6
Cookie 7
Cookie 8
Cookie 9
Cookie 10
Cookie 11
Cookie 12
Spreadsheet: 267990d1380335760-need-to-pull-data-from-multiple-columns-only-if-value-in-column-a-attempt2
Sheet: JE-Sales (2)

WEEKLY SALES - JOURNAL ENTRIES |  |  |  | GL9SL_
WEEK ENDING |  | 90113 | Format is number - not date
DATE | [NAME] | [NAME] | ACCOUNT | AMOUNT
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
Spreadsheet: 692884d1598620413-averageif-function-correct-for-what-i-want-book6-1
Sheet: Fielding Sheet

Over | .1 |  |  |  |  | .2 |  |  |  |  | .3 |  |  |  |  | .4 |  |  |  |  | .5 |  |  |  |  | .6 |  |  |  |  | .7 |  |  |  |  | .8 |  |  |  |  | .9
 | Player | Position | Runs | Throw | Additionals | Player | Position | Runs | Throw | Additionals | Player | Position | Runs | Throw | Additionals | Player | Position | Runs | Throw | Additionals | Player | Position | Runs | Throw | Additionals | Player | Position | Runs | Throw | Additionals | Player | Position | Runs | Throw | Additionals | Player | Position | Runs | Throw | Additionals | Player | Position | Runs | Throw | Additionals
0 |  |  | 0 | 1 |  |  |  |  | n/a
1 | [NAME] |  |  | 0
2 | [NAME] |  |  | 1
3 | [NAME] |  |  | 1
4 | [NAME] |  |  | n/a
5 | [NAME] |  |  | n/a
6 |  |  |  | n/a
7 |  |  |  | n/a
8 | [NAME] |  | 0 | n/a
9 |  |  |  | n/a
10 |  |  |  | n/a |  |  |  | 0
11 |  |  |  | n/a
12 |  |  | 0 | n/a
13 |  |  |  | n/a
14 |  |  |  | n/a
15 |  |  |  | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
16 |  |  |  | n/a
17 |  |  |  | n/a |  |  |  | 1
18 |  |  |  | n/a
19 |  |  | 0 | n/a
20 |  |  |  | n/a
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
 | Outputs
 |  | Contacts
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | TOTALS |  | Contacts
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Any additionals that have been clicked for that name to appear here
Beaumont
Fackrell
Freeborn
[NAME]
Graves
Harman
Harmer
[NAME]
Kbryce
Kellogg
[NAME]
Pai
Presland
[NAME]
Sims
 |  | Throw Quality
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | TOTALS
[NAME]
Beaumont |  |  |  |  |  |  |  |  |  |  | Avegrage of throw quality to go here but ignore when it says nothing, N/A and ignoring any zeros in cells C76 - K91
Fackrell
Freeborn
[NAME]
Graves
Harman
Harmer
[NAME]
Kbryce
Kellogg
[NAME]
Pai
Presland
[NAME]
Sims
Spreadsheet: 225103d1364896744-help-with-timetable-lesson-planner
Sheet: 9L LESSONS

 |  | Week | Monday | TUESDAY 1 | TUESDAY 6 | Thursday | Friday
 | 2011-09-05 00:00:00 | 1
 | 2011-09-12 00:00:00 | 2
 | 2011-09-19 00:00:00 | 3
 | 2011-09-26 00:00:00 | 4
 | 2011-10-03 00:00:00 | 5
 | 2011-10-10 00:00:00 | 6
 | 2011-10-17 00:00:00 | 7
 | 2011-10-24 00:00:00
 | 2011-10-31 00:00:00 | 8
 | 2011-11-07 00:00:00 | 9
 | 2011-11-14 00:00:00 | 10
 | 2011-11-21 00:00:00 | 11
 | 2011-11-28 00:00:00 | 12
 | 2011-12-05 00:00:00 | 13
 | 2011-12-12 00:00:00 | 14
 | 2011-12-19 00:00:00
 | 2011-12-26 00:00:00
 | 2012-01-02 00:00:00 | 15
 | 2012-01-09 00:00:00 | 16
 | 2012-01-16 00:00:00 | 17
 | 2012-01-23 00:00:00 | 18
 | 2012-01-30 00:00:00 | 19
 | 2012-02-06 00:00:00 | 20
 | 2012-02-13 00:00:00
 | 2012-02-20 00:00:00 | 21
 | 2012-02-27 00:00:00 | 22
 | 2012-03-05 00:00:00 | 23
 | 2012-03-12 00:00:00 | 24
 | 2012-03-19 00:00:00 | 25
 | 2012-03-26 00:00:00 | 26
 | 2012-04-02 00:00:00
 | 2012-04-09 00:00:00
 | 2012-04-15 00:00:00 | 27
 | 2012-04-22 00:00:00 | 28
 | 2012-04-29 00:00:00 | 29
 | 2012-05-06 00:00:00 | 30 | BANK HOL
 | 2012-05-13 00:00:00 | 31
 | 2012-05-20 00:00:00 | 32
 | 2012-05-27 00:00:00
 | 2012-06-03 00:00:00 | 33
 | 2012-06-10 00:00:00 | 34
 | 2012-06-17 00:00:00 | 35
 | 2012-06-24 00:00:00 | 36
 | 2012-07-01 00:00:00 | 37
 | 2012-07-08 00:00:00 | 38
 | 2012-07-15 00:00:00 | 39
 | 2012-07-22 00:00:00 | 40
Spreadsheet: 1140a2a6-0877-43de-bd8b-3d1cdda2547e
Sheet: Sheet1

Table 4 -- U.S. monthly average farm prices and marketings by class | 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 | Unnamed: 17
 |  |  | Long-grain |  |  |  |  |  |  |  |  | Medium/Short Grain
 |  | 2011/12 |  |  |  | 2010/11 |  |  |  | 2011/12 |  |  |  | 2010/11
Month | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt
August | 12.4 |  | 9343 |  | 10.3 |  | 8570 |  | 19 |  | 2041 |  | 17.1 |  | 2121
September | 13.7 |  | 10310 |  | 9.98 |  | 12764 |  | 17.8 |  | 2197 |  | 16.9 |  | 2331
October | 14.1 |  | 8694 |  | 10.1 |  | 14295 |  | 15.9 |  | 2760 |  | 18.8 |  | 2836
November | 13.9 |  | 7196 |  | 10.6 |  | 12773 |  | 15.7 |  | 3732 |  | 18.9 |  | 4156
December | 13.8 |  | 9938 |  | 11.3 |  | 13085 |  | 15.2 |  | 4239 |  | 19.5 |  | 6052
January | 13.6 |  | 9482 |  | 11.8 |  | 15722 |  | 15.2 |  | 4940 |  | 19.6 |  | 6084
February | 13.2 |  | 9917 |  | 12 |  | 11726 |  | 15.3 |  | 3270 |  | 18.8 |  | 3121
March | 13 |  | 10041 |  | 11.6 |  | 12537 |  | 15 |  | 4124 |  | 18.5 |  | 3307
April | 13.3 | 1/ |  |  | 11.2 |  | 9562 |  | 15.9 | 1/ |  |  | 18.6 |  | 3165
May |  |  |  |  | 10.9 |  | 11211 |  |  |  |  |  | 19 |  | 3016
June |  |  |  |  | 11 |  | 9573 |  |  |  |  |  | 18.4 |  | 1744
July |  |  |  |  | 11.4 |  | 9866 |  |  |  |  |  | 19 |  | 2503
Average to date 2/ | 13.44444444444444 |  |  |  |  |  |  |  | 16.11111111111111
Season-average farm price | 13.4 | 3/ |  |  | 11 |  |  |  | 15.7 | 3/ |  |  | 18.8
Average marketings |  |  | 9268.57142857143 |  |  |  | 11807 |  |  |  | 3412.875 |  |  |  | 3369.666666666667
Total volume marketed |  |  | 74921 |  |  |  | 141684 |  |  |  | 27303 |  |  |  | 40436
N/A = Not available.  1/  Mid-month only.  2/ Simple average. 3/ Forecast.
Source: Monthly cash price and marketings, Agricultural Prices, National Agricultural Statistics Service, USDA.
Last updated May 11, 2012.
Spreadsheet: 176687d1346073424-indexing-with-duplicates-issue-department-position-status-working-file
Sheet: Category Lookups

Category | Department
Accounting/Finance | Finance
Business Development | SPBD
Claims | Claims
Compliance | Compliance
Human Resources | HROD
Information Technology | InformationSystems
Medical Management | MedMgmt
Member Operations | MemberOperations
Network Development | NetworkDevelopment
Transportation | MemberOperations
Spreadsheet: 157929d1337933170-replicating-data-from-a-list-2lists
Sheet: Sheet1

[NAME] |  |  | 1 | abba | 75 |  | 1 | abba | 75 | [NAME]
lo-2 |  |  | 2 | babba | 356 |  | 2 | babba | 356 | [NAME]
loo3 |  |  | 3 | bom | 22 |  | 3 | bom | 22 | [NAME]
loi4 |  |  |  |  |  |  | 1 | abba | 75 | lo-2
martin |  |  |  |  |  |  | 2 | babba | 356 | lo-2
 |  |  |  |  |  |  | 3 | bom | 22 | lo-2
 |  |  |  |  |  |  | 1 | abba | 75 | loo3
 |  |  |  |  |  |  | 2 | babba | 356 | loo3
 |  |  |  |  |  |  | 3 | bom | 22 | loo3
 |  |  |  |  |  |  | 1 | abba | 75 | loi4
 |  |  |  |  |  |  | 2 | babba | 356 | loi4
 |  |  |  |  |  |  | 3 | bom | 22 | loi4
 |  |  |  |  |  |  | 1 | abba | 75 | martin
 |  |  |  |  |  |  | 2 | babba | 356 | martin
 |  |  |  |  |  |  | 3 | bom | 22 | martin
 |  |  |  |  |  |  | 1 | abba | 75 | 0
 |  |  |  |  |  |  | 2 | babba | 356 | 0
 |  |  |  |  |  |  | 3 | bom | 22 | 0
 |  |  |  |  |  |  | 1 | abba | 75 | 0
 |  |  |  |  |  |  | 2 | babba | 356 | 0
 |  |  |  |  |  |  | 3 | bom | 22 | 0
 |  |  |  |  |  |  | 1 | abba | 75 | 0
 |  |  |  |  |  |  | 2 | babba | 356 | 0
 |  |  |  |  |  |  | 3 | bom | 22 | 0
 |  |  |  |  |  |  | 1 | abba | 75 | 0
 |  |  |  |  |  |  | 2 | babba | 356 | 0
 |  |  |  |  |  |  | 3 | bom | 22 | 0
 |  |  |  |  |  |  | 1 | abba | 75 | 0
Spreadsheet: 263393d1378466544-conditional-format-to-mark-increase-from-previous-column-cfarrows
Sheet: Sheet1

Goal | January | February | March | April | May | June | July
0.3 | 1 | 1 | 1 | 1 | 1 | 1 | 1
0.8 | 0.929 | 0.976 | 1 | 1 | 1 | 1 | 1
0.4 | 0.9882352941176471 | 0.935 | 0.89 | 0.971 | 0.933 | 0.978 | 0.953
0.8 | 1 | 1 | 1 | 1 | 1 | 1 | 1
0.8 | 1 | 1 | 1 | 1 | 1 | 1 | 1
0.5 | 0.75 | 0.718 | 0.81 | 0.68 | 0.788 | 0.852 | 0.711
0.5 | 1 | 1 | 1 | 0.907 | 0.919 | 0.926 | 0.928
0.5 | 0.875 | 0.918 | 0.952 | 0.948 | 0.899 | 0.963 | 0.907
0.5 | 0.1641025641025641 | 0.293 | 0.506 | 0.717 | 0.743 | 0.407 | 0.356
Goal | January | February | March | April | May | June | July
0.3 | ↗100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00%
0.8 | ↗92.90% | ↗97.60% | ↗100.00% | 100.00% | 100.00% | 100.00% | 100.00%
0.4 | ↗98.82% | ↘93.50% | ↘89.00% | ↗97.10% | ↘93.30% | ↗97.80% | ↘95.30%
0.8 | ↗100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00%
0.8 | ↗100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00%
0.5 | ↗75.00% | ↘71.80% | ↗81.00% | ↘68.00% | ↗78.80% | ↗85.20% | ↘71.10%
0.5 | ↗100.00% | 100.00% | 100.00% | ↘90.70% | ↗91.90% | ↗92.60% | ↗92.80%
0.5 | ↗87.50% | ↗91.80% | ↗95.20% | ↘94.80% | ↘89.90% | ↗96.30% | ↘90.70%
0.5 | ↘16.41% | ↗29.30% | ↗50.60% | ↗71.70% | ↗74.30% | ↘40.70% | ↘35.60%
Spreadsheet: 50400d1249835174-copying-formulas-between-cells-example
Sheet: Overview

Overview of Sites
Site | January | February | March | April | May | June | July | August | September | October | November | December | Total
On Hold Invoices | 10054.08 |  | 2012.5 |  | 24365.02 |  |  |  |  |  |  |  | 36431.6
My house | 4782.530000000001 | 0 | 0 | 2157.64 | 2618.95 | 1409.78 | 9716.67 | 0 | 0 | 0 | 0 | 0 | 20685.57
His house | 0 | 0 | 0 | 102.54 | 333.33 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 435.87
Her house | 0 | 0 | 0 | 897.66 | 1380 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2277.66
 | 14836.61 | 0 | 2012.5 | 3157.84 | 28697.3 | 1409.78 | 9716.67 | 0 | 0 | 0 | 0 | 0 | 59830.7
Spreadsheet: john_griffith__16077__1_17_02ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG G2 | 240 | 25.5 | 27.5 | 76.8 | 82.8 | 12.04 | 2002-01-17 10:01:00
 | NG H2 | 240 | 40 | 42 | 64.3 | 67.5 | 9.94 | 2002-01-17 10:01:00
 | NG J2 | 240 | 42.5 | 44.5 | 52.3 | 54.7 | 8.07 | 2002-01-17 10:01:00
 | NG K2 | 245 | 48 | 50 | 48 | 50 | 7.55 | 2002-01-17 10:01:00
 | NG M2 | 250 | 53.5 | 55.5 | 45.5 | 47.3 | 7.29 | 2002-01-17 10:01:00
 | NG N2 | 255 | 60 | 62.5 | 45.6 | 47.6 | 7.47 | 2002-01-17 10:01:00
 | NG Q2 | 260 | 67.5 | 70 | 46.3 | 48.1 | 7.72 | 2002-01-17 10:01:00
 | NG U2 | 260 | 71 | 74 | 45.3 | 47.2 | 7.56 | 2002-01-17 10:01:00
 | NG V2 | 260 | 77 | 79 | 46.3 | 47.6 | 7.67 | 2002-01-17 10:01:00
 | NG X2 | 280 | 88 | 92 | 46.5 | 48.7 | 8.38 | 2002-01-17 10:01:00
 | [NAME] | 300 | 99 | 103 | 46.8 | 48.7 | 9.01 | 2002-01-17 10:01:00
 | NG F3 | 310 | 109 | 113 | 47.9 | 49.7 | 9.51 | 2002-01-17 10:01:00
 | NG H3 |  |  |  |  |  |  | 2002-01-14 14:57:00
 | NG M3 |  |  |  |  |  |  | 2002-01-07 10:05:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 50776d1250255697-unique-value-and-index-formula-may-be-work-out-movement-bill
Sheet: TopSheet

MOVEMENT AREA: KONABARI, BOGRA, COX'S BAZAR, M. BAZAR, PABNA, TANGAIL & KUSHTIA
SUMMARY OF LOCATION-WISE BILL :
MOVEMENT AREA | RATE | AMOUNT
JESSORE TO BOGRA | 3600*2+3700 | 10900
JESSORE TO COX'S BAZAR | 9200*2 | 18400
JESSORE TO KONABARI | 3200+4200*7+4600*4+4800*7+5200*2 | 95000
JESSORE TO KUSHTIA | 1300*2+1600 | 4200
JESSORE TO M. BAZAR | 7200*1 | 7200
JESSORE TO PABNA | 3600*1 | 3600
JESSORE TO TANGAIL | 4600*1 | 4600
TOTAL CARRYING BILL |  | 143900
Spreadsheet: 730535d1619750018-formula-for-the-revenue-row-that-evenly-spreads-each-months-bookings-excel-question
Sheet: Sheet1

Ramp Time (Mths) | 6
 | 2021-01-31 00:00:00
Bookings | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000
Revenue
Spreadsheet: 225334d1364966879-i-want-to-change-datetime-format-in-excel-calls_demo
Sheet: Calls_demo

date_entered | date_modified | date_start | date_end
2012-12-12 00:00:00 | 16-01-2013 14:41 | 2012-12-12 05:30:00 | 1970-01-01 00:00:00
2012-12-12 00:00:00 | 16-01-2013 14:42 | 2012-12-12 05:30:00 | 1970-01-01 00:00:00
2012-12-12 00:00:00 | 16-01-2013 14:43 | 2012-12-12 05:30:00 | 1970-01-01 00:00:00
2012-12-12 00:00:00 | 16-01-2013 14:44 | 2012-12-12 05:30:00 | 1970-01-01 00:00:00
23-01-2013  12:08:00 PM | 28-02-2013 16:28 | 23-01-2013 12:15 | 23-01-2013
Spreadsheet: 716541d1612264539-formula-to-work-out-annual-averages-based-of-the-corresponding-date-in-adjacent-column-database-example-sheet
Sheet: Sheet1

 | test 1 |  |  |  |  |  |  |  |  |  | annual averages |  |  |  |  | test 2 |  |  |  |  |  |  |  |  |  | annual averages
names | Test 1 score 1 | Test 1 date 1 | Test 1 score 2 | Test 1 date 2 | Test 1 score 3 | Test 1 date 3 | Test 1 score 4 | Test 1 date 4 | Test 1 score 5 | Test 1 date 5 | 2015 Test 1 | 2016 Test 1 | 2017 Test 1 | 2018 Test 1 | 2019 Test 1 | Test 2 score 1 | Test 2 date 1 | Test 2 score 2 | Test 2 date 2 | Test 2 score 3 | Test 2 date 3 | Test 2 score 4 | Test 2 date 4 | Test 2 score 5 | Test 2 date 5 | 2015 Test 2 | 2016 Test 2 | 2017 Test 2 | 2018 Test 2 | 2019 Test 2
name1 | 1 | 2016-01-01 00:00:00 | 0 | 2017-01-01 00:00:00 | 1 | 2017-06-01 00:00:00 | 1 | 2017-12-01 00:00:00 | 2 | 2018-06-01 00:00:00 |  | 1 |  | 2 |  | 1 | 2016-01-01 00:00:00 | 2 | 2017-01-01 00:00:00 | 1 | 2017-06-01 00:00:00 | 2 | 2017-12-01 00:00:00 | 2 | 2018-06-01 00:00:00 |  | 1 |  | 2
[NAME] | 3 | 2015-01-01 00:00:00 | 3 | 2016-01-01 00:00:00 | 4 | 2017-01-01 00:00:00 | 5 | 2018-01-01 00:00:00 | 6 | 2019-01-01 00:00:00 | 3 | 3 | 4 | 5 | 6 | 3 | 2015-01-01 00:00:00 | 3 | 2016-01-01 00:00:00 | 4 | 2017-01-01 00:00:00 | 5 | 2018-01-01 00:00:00 | 6 | 2019-01-01 00:00:00 | 3 | 3 | 4 | 5 | 6
name3 | 6 | 2016-01-01 00:00:00 | 6 | 2016-06-01 00:00:00 | 6 | 2017-01-01 00:00:00 | 6 | 2017-06-01 00:00:00 | 6 | 2018-01-01 00:00:00 |  | 6 | 6 | 6 |  | 6 | 2016-01-01 00:00:00 | 6 | 2016-06-01 00:00:00 | 6 | 2017-01-01 00:00:00 | 6 | 2017-06-01 00:00:00 | 6 | 2018-01-01 00:00:00 |  | 6 | 6 | 6
name4 | 2 | 2016-01-01 00:00:00 | 2 | 2016-08-01 00:00:00 | 1 | 2017-06-01 00:00:00 | 1 | 2018-01-01 00:00:00 | 0 | 2018-12-01 00:00:00 |  | 2 | 1 | 0.5 |  | 2 | 2016-01-01 00:00:00 | 2 | 2016-08-01 00:00:00 | 1 | 2017-06-01 00:00:00 | 1 | 2018-01-01 00:00:00 | 0 | 2018-12-01 00:00:00 |  | 2 | 1 | 0.5
name5 | 4 | 2017-02-01 00:00:00 | 5 | 2017-05-01 00:00:00 | 5 | 2017-08-01 00:00:00 | 4 | 2018-01-01 00:00:00 | 3 | 2018-05-01 00:00:00 |  |  |  |  |  | 0 | 2017-02-01 00:00:00 | 2 | 2017-05-01 00:00:00 | 3 | 2017-08-01 00:00:00 | 2 | 2018-01-01 00:00:00 | 1 | 2018-05-01 00:00:00
Spreadsheet: ryan_slinger__33673__5_15act
Sheet: Sheet1

613 | 599 | 587 | 573 | 595 | 637 | 745 | 776 | 763 | 797 | 815 | 811 | 800 | 798 | 778 | 762 | 770 | 801 | 857 | 849 | 838 | 798 | 741 | 659
611 | 584 | 570 | 573 | 576 | 662 | 738 | 758 | 789 | 790 | 801 | 801 | 804 | 801 | 799 | 787 | 784 | 782 | 863
Spreadsheet: 162030d1339696804-help-with-multiple-column-lookup-example
Sheet: Sheet1

Fixture Code | Type | [NAME] | Feet
 | 12 | 4 | 4
 | 12 | 4 | 4
 | 12 | 4 | 4
 | 12 | 4 | 4
 | 12 | 4 | 4
 | 12 | 4 | 4
 | 12 | 3 | 4
 | 12 | 3 | 4
 | 12 | 2 | 4
 | 12 | 2 | 4
 | 12 | 2 | 4
 | 12 | 1 | 4
 | 12 | 1 | 4
 | 8 | 4 | 4
 | 8 | 4 | 4
 | 8 | 4 | 4
 | 8 | 3 | 4
 | 8 | 2 | 4
 | 8 | 2 | 4
Spreadsheet: 289177d1389441504-raffle-numbers-in-excel-raffle2
Sheet: Sheet1

winning numbers | 1 | 5 | 9 | 12 | Armando Montes | Willem
Person | 1st No | 2nd No | 3rd No | 4th No | MATCHES | MATCHES
1 | 1 | 5 | 9 | 12 |  |  | See formula in F3:F12G
2 | 2 | 7 | 13 | 15
3 | 3 | 8 | 16 | 19
4 | 4 | 11 | 22 | 23
5 | 5 | 10 | 12 | 20
6 | 6 | 7 | 10 | 15
7 | 7 | 14 | 16 | 22
8 | 8 | 13 | 17 | 20
9 | 9 | 20 | 21 | 24
10 | 1 | 5 | 9 | 15
 | [NAME]:F12 and see conditional formatting
 |  |  |  |  |  |  | Example: Say that we had the winning numbers of 1,5,9,12 this week Person 1 has all 4 and person 10 has three, how do I hightlight the winning numbers and also what formula do I use
[NAME]
Spreadsheet: 80741d1280944343-changing-the-name-of-100-entries-out-of-a-list-with-20-000-entries-book1
Sheet: Sheet1

test | test
test | test
test | test
test | test
test | testA
test | testA
one | one
test | testA
test | testA
two | two
test | testB
test | testB
test | testB
test | testB
three | three
test | testC
test | testC
test | testC
test | testC
test | testD
test | testD
test | testD
five | five
four | four
six | six
test | testD
test | testE
test | testE
test | testE
test | testE
test | testF
test | testF
test | testF
test | testF
test | testG
test | testG
test | testG
test | testG
test | testH
test | testH
test | testH
test | testH
test | testI
test | testI
test | testI
test | testI
test | testJ
test | testJ
test | testJ
test | testJ
test | testK
test | testK
test | testK
test | testK
test | testL
test | testL
test | testL
test | testL
test | testM
test | testM
test | testM
test | testM
test | testN
test | testN
test | testN
test | testN
test | testO
test | testO
test | testO
test | testO
test | testP
test | testP
test | testP
test | testP
test | testQ
test | testQ
test | testQ
test | testQ
test | testR
test | testR
test | testR
test | testR
test | testS
test | testS
test | testS
test | testS
test | testT
test | testT
test | testT
test | testT
test | testU
test | testU
test | testU
test | testU
test | testV
test | testV
test | testV
test | testV
test | testW
test | testW
test | testW
test | testW
test | testX
test | testX
test | testX
test | testX
test | testY
test | testY
test | testY
test | testY
test | testZ
test | testZ
test | testZ
test | testZ
Spreadsheet: 772621d1647412480-rank-rank
Sheet: Sheet1

SUBJECT A |  | SUBJECT B |  | SUBJECT C |  | SUBJECT D |  | SUBJECT E
MARK | GRED | MARK | GRED | MARK | GRED | MARK | GRED | MARK | GRED
20 | F | 90 | A | 70 | B | TH | TH | 65 | D
 | MARK | RANK
i want to make a rank.how to change the letter TH to the number 0. sometimes the cell mark can be a number and sometimes letter according to the exam results. It becomes a problem when the exam results in the form of letters in the rank part will be the value
Spreadsheet: 683847d1592985722-conditional-remove-duplicates-based-on-another-column-in-power-query-related-to-power-bi-pq-example-of-cleaned-data-aligw
Sheet: Sheet4

ID | FTE Sum | Table1 (2).JobPositionCode | Table1 (2).AwardCode | Table1 (2).AwardLevelCode | Table1 (2).JobPositionCategoryCode | Table1 (2).JobPositionActiveFlag | Table1 (2).Surname | Table1 (2).Preferred | Table1 (2).CurrentJobPositionFlag | Table1 (2).FutureJobPositionFlag | Table1 (2).JobStartDate
5000 | 1 | PRINCIPAL | TEACHING | LEADERSHIP | TEACHER | True | Wilson | Rebel | True | False | 2018-11-28 00:00:00
6111 | 0.8 | TEACHER | TEACHING | COACH | TEACHER | True | Blanchett | Cate | True | False | 2016-03-31 00:00:00
25000 | 1 | TEACHER | TEACHING | HEAD OF HOUSE | TEACHER | True | Jackman | Hugh | True | False | 2020-01-13 00:00:00
6000 | 1 | ES | FINANCE |  | PAYROLL OFFICER | True | Weaver | [NAME] | True | False | 2010-01-01 00:00:00