tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 727610d1617980421-need-help-counting-sizes-per-shirt-color-book3-full-list-sizes-per-color
Sheet: Sheet1

COLOR | YS | YM | YL | YXL | AS | AM | AL | AXL | 2XL | 3XL |  | Total Shirts
Gold | 3 | 7 | 10 | 3 | 4 |  |  |  |  | 1 |  |  | 16
White | 1 | 5 | 5 |  | 1 |  |  |  |  |  |  |  | 16
Black | 2 | 8 | 11 | 4 | 2 |  |  |  |  |  |  |  | 15
Light Gray |  | 7 | 5 | 2 |  |  |  |  |  |  |  |  | 16
[NAME] | 1 | 5 | 4 | 3 | 1 |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  | NEED ALL COACH SIZES
Spreadsheet: 732383d1620921088-returning-unique-value-with-multiple-criteria-returning-unique-value-with-multiple-criteria-v3
Sheet: EMPLOYEES PER YEAR

2020 |  |  |  |  |  | CREW | ='TIMECARD DATA'!$A$2:INDEX('TIMECARD DATA'!$A:$A,MATCH("zzzz",'TIMECARD DATA'!$A:$A,1))
CREW | Full Time Employees | By [NAME] | Unique formula |  |  | DATE | ='TIMECARD DATA'!$C$2:INDEX('TIMECARD DATA'!$C:$C,MATCH(25^25,'TIMECARD DATA'!$C:$C,1))
ABC |  |  |  |  |  | PERSON | ='TIMECARD DATA'!$B$2:INDEX('TIMECARD DATA'!$B:$B,[NAME]))
DEF
GHI
JKL
2019
CREW | Full Time Employees
ABC
DEF
GHI
JKL
2018
CREW | Full Time Employees
ABC
DEF
GHI
JKL
2017
CREW | Full Time Employees
ABC
DEF
GHI
JKL
Spreadsheet: 190338d1351617618-duplicate-cross-reference-help-excel-help-forum
Sheet: Summary

SUMMARY
How many different rows in the 'Raw Data' tab have the same number but a different agent?
Example:
Home Phone | Agent
555-5432 | [NAME]
555-5432 | [NAME]
 | [NAME] | [NAME] | Genny | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | - | 1
[NAME] | 1 | -
Genny
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 871466d1717867016-find-point-if-inside-a-polygon-and-shade-the-area-temp-and-alt-v2
Sheet: Sheet1

 | ALT | TEMP F | CATEGORY |  | A |  | AREA 1 |  | AREA 2
 | yp | xp |  |  | y | x | y | x | y | x
 | 6 | 90 |  |  | 0 | 40 | 0 | 40 | 0 | 79
 |  |  |  |  | 2 | 40 | 2 | 40 | 2 | 79
 |  |  |  |  | 2 | 79 | 2 | 79 | 0 | 98
 |  |  |  |  | 0 | 98 | 0 | 79
 |  |  |  |  | B |  | AREA 1 |  | AREA 2
 | P= (x2-xp) * (y1-yp) - (x1-xp) * (y2-yp) |  |  |  | y | x | y | x | y | x
 | D = (x2 - x1) * (yp - y1) - (xp - x1) * (y2 - y1) |  |  |  | 2 | 40 | 2.1 | 40.1 | 2.1 | 79.1
 |  |  |  |  | 4.7 | 40 | 4.7 | 40 | 4.7 | 69
 | A = -(y2 - y1) |  |  |  | 4.7 | 69 | 4.7 | 69 | 0 | 110
 | B = x2 - x1 |  |  |  | 0 | 110 | 2 | 79.1 | 0 | 98
 | C = -(A * x1 + B * y1) |  |  |  | 0 | 98
 | D = A * xp + B * yp + C |  |  |  | 2 | 79
 | A = [ x1(y2 – y3) + x2(y3 – y1) + x3(y1-y2)]/2 |  |  |  | 2 | 40
 | A1
 | A2
 | PAB1 |  |  |  | C |  | AREA 1 |  | AREA 2 |  | AREA 3 |  | AREA 4
 | PBC2 |  |  |  | y | x | y | x | y | x | y | x | y | x
 | PAC3 |  |  |  | 4.7 | 40 | 4.71 | 0 | 4.71 | 69 | 4.71 | 69 | 3 | 98
 |  |  |  |  | 6.79 | 40 | 6.79 | 0 | 6.79 | 62 | 5.13 | 80 | 0 | 119.2
 | a |  |  |  | 6.79 | 62 | 6.79 | 62 | 6.2 | 70 | 3 | 98 | 0 | 110
 | b |  |  |  | 6.2 | 70 | 4.71 | 69 | 5.13 | 80 | 0 | 110
 | c |  |  |  | 5.13 | 80
 |  |  |  |  | 3 | 98
 |  |  |  |  | 0 | 119.2
 |  |  |  |  | 0 | 110
 |  |  |  |  | 4.7 | 69
 |  |  |  |  | 4.7 | 40
 |  |  |  |  | D |  | AREA 1 |  | AREA 2 |  | AREA 3 |  | AREA 4 |  | AREA 5
 |  |  |  |  | y | x | y | x | y | x | y | x | y | x | y | x
 |  |  |  |  | 6.79 | 40 | 6.8 | 40 | 8.64 | 54.2 | 6.3 | 70.1 | 5.14 | 80 | 3 | 98.1
 |  |  |  |  | 8.64 | 40 | 8.64 | 0 | 6 | 86 | 6 | 86 | 6 | 86 | 3 | 109
 |  |  |  |  | 8.64 | 54.2 | 8.64 | 54.2 | 6.3 | 70 | 5.14 | 80 | 3 | 109 | 0 | 128.3
 |  |  |  |  | 6 | 86 | 6.8 | 62 | 6.8 | 62 |  |  | 3 | 98.1 | 0 | 119.3
 |  |  |  |  | 3 | 109
 |  |  |  |  | 0 | 128.3
 |  |  |  |  | 0 | 119.2
 |  |  |  |  | 3 | 98
 |  |  |  |  | 5.13 | 80
 |  |  |  |  | 6.2 | 70
 |  |  |  |  | 6.79 | 62
 |  |  |  |  | 6.79 | 40
 |  |  |  |  | E |  | AREA 1 |  | AREA 2 |  | AREA 3 |  | AREA 4
 |  |  |  |  | y | x | y | x | y | x | y | x | y | x
 |  |  |  |  | 8.64 | 40 | 8.65 | 40 | 8.65 | 54.2 | 6 | 86.1 | 3 | 109.1
 |  |  |  |  | 9 | 40 | 9 | 40 | 9 | 40 | 8 | 102 | 8 | 102
 |  |  |  |  | 9 | 90 | 9 | 90 | 8 | 102 | 3 | 109.1 | 0 | 144
 |  |  |  |  | 8 | 102 | 8.65 | 54.2 | 6 | 86.1 |  |  | 0 | 128.4
 |  |  |  |  | 0 | 144
 |  |  |  |  | 0 | 128.3
 |  |  |  |  | 3 | 109
 |  |  |  |  | 6 | 86
 |  |  |  |  | 8.64 | 54.2
 |  |  |  |  | 8.64 | 40
 |  |  |  |  | F |  | AREA 1 |  | AREA 2 |  | AREA 2
 |  |  |  |  | y | x | y | x | y | x | y | x
 |  |  |  |  | 9 | 90 | 9.1 | 90 | 8.1 | 102 | 0 | 144.1
 |  |  |  |  | 9 | 128 | 9 | 128 | 9 | 128 | 9 | 128
 |  |  |  |  | 0.55 | 160 | 8.1 | 102 | 0 | 144.1 | 0.55 | 160
 |  |  |  |  | 0 | 160 |  |  |  |  | 0 | 160
 |  |  |  |  | 0 | 144
 |  |  |  |  | 8 | 102
 |  |  |  |  | 9 | 90
Spreadsheet: ba9e3ca5-ef44-43cb-a642-b85d8ff4c38e
Sheet: Sheet1

Spending Diary | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Week Commencing | Unnamed: 6 | Unnamed: 7
ITEM | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun | TOTAL
Food |  |  |  |  |  |  |  | 0
Milk |  |  |  |  |  |  |  | 0
Cleaning materials |  |  |  |  |  |  |  | 0
Pet food |  |  |  |  |  |  |  | 0
Nappies |  |  |  |  |  |  |  | 0
School dinners |  |  |  |  |  |  |  | 0
School outings |  |  |  |  |  |  |  | 0
Children’s uniform |  |  |  |  |  |  |  | 0
Children’s clothes / shoes |  |  |  |  |  |  |  | 0
Pocket money |  |  |  |  |  |  |  | 0
Adult clothes / shoes |  |  |  |  |  |  |  | 0
Going out / entertainment |  |  |  |  |  |  |  | 0
Bus / train fares |  |  |  |  |  |  |  | 0
Car costs |  |  |  |  |  |  |  | 0
Alcohol |  |  |  |  |  |  |  | 0
Cigarettes / tobacco |  |  |  |  |  |  |  | 0
Presents |  |  |  |  |  |  |  | 0
Newspapers / magazines |  |  |  |  |  |  |  | 0
Takeaway meals |  |  |  |  |  |  |  | 0
Lottery / betting |  |  |  |  |  |  |  | 0
Hobbies / leisure |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 714625d1611311935-multiple-matches-in-a-cell-separated-by-line-break-multiple-matches-with-line-break
Sheet: Sheet1

Input | Match |  |  | Source: | Country | ID
China, Russia, Brazil |  |  |  |  | China | 1234
China Russia |  |  |  |  | Russia | 5432
Rusia,Brazil |  |  |  |  | Brazil | 6789
Brazil,-Russia, RSA |  |  |  |  | RSA | 9999
China
RussiaBrazilChina
Spreadsheet: 4ec44d6a-6137-4345-9cf0-c90b58e65dc9
Sheet: 20

 |  | Broker** |  | Non-Broker |  | TOTAL
Product |  | Cleared*** | Uncleared | Cleared | Uncleared | Cleared | Uncleared
Swap* | CFD
 | Dividend
 | Equity Swap
 | Portfolio
 | [NAME]
Option | Accumulator/Decumulator
 | Vanilla (put/call)
 | [NAME]
Forward | Vanilla
Exotic
Structured Products
TOTAL |  | N/A**** | N/A | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, October 25 weekly snapshot, by product, participant type, and cleared status (value of all trades in millions of USD).
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Explanatory Notes for cleared and uncleared descriptions.
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 96117d1295553325-alternative-to-vlookup-excel-problem
Sheet: Codes and Materials

Material Code | Material Name | Supplier ([NAME])
109882 | Oranges | supplier 1
100061 | Melon P/apple Mix | #N/A
100079 | Mix 2234 | #N/A
100079 | Pears | #N/A
102267 | [NAME] | supplier 32
103065 | Pineapple | #N/A
103072 | Gooseberry | supplier 28
103073 | Lemon Juice | supplier 30
103074 | [NAME] | #N/A
103090 | Winter  Mix | #N/A
103107 | [NAME] | supplier 27
104622 | Apple slices | supplier 9
104893 | Apples | #N/A
104906 | Peanut | #N/A
104907 | Walnut | #N/A
104915 | Rasin | supplier 3
105137 | British Grapes | supplier 28
105137 | Lemons | supplier 28
109866 | Lime Juice | supplier 14
109875 | Melon | supplier 3
110676 | Mango Juice | supplier 3
111456 | Pineapple (dried) | #N/A
111464 | Cashew (whole) | #N/A
111464 | Dark Chocolate Pieces | #N/A
111488 | Pear Puree | supplier 9
115376 | Vanilla extract | #N/A
115382 | Carrots (chopped) | supplier 3
115390 | [NAME] | #N/A
115391 | Project Fruity Mix | #N/A
115393 | Tuti Fruity Flavour | #N/A
115395 | [NAME] | #N/A
115397 | Dried Cranberry | #N/A
115398 | [NAME] | #N/A
115456 | Plum | supplier 13
115456 | Sliced Beetroot | supplier 13
115528 | Chocolate Stars | supplier 3
116055 | French [NAME] | supplier 16
116055 | [NAME] | supplier 16
116185 | German [NAME] | #N/A
116185 | Peanut (halves) | #N/A
116823 | Tropical Mix | supplier 31
116852 | Blueberries | supplier 16
116852 | Kiwis | supplier 16
116852 | Summer Fruit Blend | supplier 16
117146 | [NAME] | supplier 15
117146 | [NAME] | supplier 15
117611 | [NAME] | #N/A
117616 | Lime | supplier 2
117618 | Sun dried tomato | #N/A
121725 | Passionfruit | #N/A
121726 | Milky Stars | #N/A
121727 | Apple Cubes | #N/A
125757 | [NAME] (4) | supplier 16
129734 | Trial Mix 1013 | supplier 16
130845 | [NAME] | #N/A
130846 | [NAME] | #N/A
131080 | [NAME] | #N/A
135154 | Choclate Rasins | #N/A
135301 | Mango | #N/A
135517 | Sliced Mango | #N/A
138035 | peppers (whole) | #N/A
138955 | Red Peppers | #N/A
139871 | Air Freighted Mix | supplier 9
140579 | Fruit Mix | #N/A
140882 | Sized Onions | supplier 3
141946 | [NAME] 11 | #N/A
142169 | [NAME] 6 | #N/A
144227 | Peaches | supplier 16
144776 | Peach in Juice | #N/A
144815 | Orange Juice | supplier 12
145267 | MELON SLICES | supplier 3
151956 | Air Dried Apple | supplier 16
Spreadsheet: 466613d1466334583-autofill-data-to-another-worksheet-using-id-number-example-sheet_etaf
Sheet: Screener 2

ID | First Name | Last Name | Company | Job Type
16
18
21
Spreadsheet: darrell_schoolcraft__7319__imball0202
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2 |  |  |  |  |  | [NAME] |  | Pecos Del |  |  |  | Imbalance
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled |  |  |  | Month | Measured | Scheduled | Measured | Scheduled | Imbalance | Index | Amount
1 | -39508 | 217 |  | -39867 |  |  |  |  |  | 2001-01-01 00:00:00 | -715680 | -355592 | 0 | -350072 |  | 8.26
2 | -28824 | 217 |  | -29867 |  |  |  |  |  | 2001-02-01 00:00:00 | -609189 | -341536 | -52379 | -306771 |  | 5.62
3 | -29526 | 217 |  | -29867 |  |  |  |  |  | 2001-03-01 00:00:00 | -1830618 | -794902 | -918 | -1033307 |  | 5.03
4 | -30161 | 217 |  | -15867 |  |  |  |  |  | 2001-04-01 00:00:00 | -3230259 | -1322613 |  | -2164184 |  | 4.99
5 | -37240 | 217 |  | -50976 |  |  |  |  |  | 2001-05-01 00:00:00 | -3482702 | -2020658 | -252797 | -1732396 |  | 4.01
6 | -28035 | -1757 |  | -26019 |  |  |  |  |  | 2001-06-01 00:00:00 | -3938526 | -3382042 |  | -1643833 |  | 3.51
7 | -41922 | -5885 |  | -34934 |  |  |  |  |  | 2001-07-01 00:00:00 | -3894744 | -2543771 | -671221 | -1981645 |  | 2.94
8 | -54425 | 217 |  | -54667 |  |  |  |  |  | 2001-08-01 00:00:00 | -4170940 | -3265860 | -1648101 | -2554228 |  | 2.85
9 | -59844 | -9648 |  | -49867 |  |  |  |  |  | 2001-09-01 00:00:00 | -3023464 | -2576525 | -92729 | -544473 |  | 1.96
10 |  |  |  |  |  |  |  |  |  | 2001-10-01 00:00:00 | -2576641 | -1740603 | -37750 | -877765 |  | 2.15
11 |  |  |  |  |  |  |  |  |  | 2001-11-01 00:00:00 | -2598109 | -1780898 | -233298 | -1038459 |  | 2.07
12 |  |  |  |  |  |  |  |  |  | 2001-12-01 00:00:00 | -1166081 | -133483 |  | -1006789 |  | 2.26
13 |  |  |  |  |  |  |  |  |  | 2002-01-01 00:00:00
14
15
16
17
18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -591014.35
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  | 2002-01-31 00:00:00 |  |  | 9867
 |  |  |  | 2002-02-09 00:00:00
 | CBS Volume
 |  |  |  | 32476
Spreadsheet: 466540d1466263036-sum-data-for-specific-range-data
Sheet: Sheet1

DATE | SHIFT NO | APPLE | BANANA | CERRY | DRAGONFRUIT | NAME |  | [NAME] |  |  |  | BRUCE
2016-06-01 00:00:00 | 1 | 0 | 15 | 0 | 0 | [NAME] |  | APPLE | BANANA | CERRY | DRAGONFRUIT | APPLE | BANANA | CERRY | DRAGONFRUIT
 | 2 | 90 | 0 | 0 | 0 | BRUCE | WEEK 1
 | 3 | 100 | 0 | 0 | 0 | CLAY | WEEK 2
2016-06-02 00:00:00 | 1 | 0 | 0 | 5 | 7 | [NAME]
 | 2 | 1 | 2 | 0 | 0 | BRUCE
 | 3 | 0 | 0 | 0 | 0 | CLAY
2016-06-03 00:00:00 | 1 | 100 | 0 | 0 | 0 | [NAME]
 | 2 | 0 | 50 | 0 | 0 | [NAME]
 | 3 | 20 | 0 | 0 | 0 | BRUCE
2016-06-04 00:00:00 | 1 | 0 | 0 | 10 | 10 | [NAME]
 | 2 | 20 | 0 | 0 | 0 | [NAME]
 | 3 | 70 | 0 | 0 | 0 | BRUCE
2016-06-05 00:00:00 | 1 | 0 | 0 | 0 | 0 | CLAY
 | 2 | 50 | 50 | 0 | 0 | [NAME]
 | 3 | 100 | 25 | 0 | 0 | [NAME]
2016-06-06 00:00:00 | 1 | 100 | 0 | 0 | 0 | CLAY
 | 2 | 0 | 0 | 0 | 0 | [NAME]
 | 3 | 0 | 50 | 20 | 0 | [NAME]
2016-06-07 00:00:00 | 1 | 0 | 0 | 0 | 0 | BRUCE
 | 2 | 0 | 0 | 0 | 0 | CLAY
 | 3 | 100 | 0 | 0 | 0 | [NAME]
2016-06-08 00:00:00 | 1 | 50 | 50 | 0 | 0 | BRUCE
 | 2 | 20 | 20 | 0 | 0 | CLAY
 | 3 | 0 | 0 | 20 | 20 | [NAME]
Spreadsheet: 01ae1c6e-4b1e-49dc-bae3-7c2b2ae9783a
Sheet: Sheet1

West Virginia State University Research and Development Corp. | 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
 | and West Virginia State University [NAME]
Travel Expense Account Settlement
 |  |  |  |  |  |  |  |  | Funding Source:
Name: |  |  |  |  |  |  | Title:
Address:
City/State/Zip: |  |  |  |  |  |  | West Virginia State University
Department: |  |  |  |  | Dept. Contact Name:
Purpose of Travel:
DATE | TIME | CITY/STATE |  |  |  | [NAME] | AMOUNT | AIR | RENTAL CAR | MEALS | LODGING | OTHER | TOTAL
 |  | From: |  |  |  |  |  |  |  |  |  |  | 0
 |  | To:
 |  | From: |  |  |  |  |  |  |  |  |  |  | 0
 |  | To:
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | TOTAL: |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | Less Cash Advance |  |  |  |  |  | 0
OTHER EXPENSES |  |  |  |  |  |  | Amount applied to GRDI Credit Card (GRDI and Land Grant travelers only) |  |  |  |  |  | 0
DATE | ITEMS |  |  |  |  | AMOUNT | Due from employee |  |  |  |  |  | 0
 |  |  |  |  |  |  | Due to employee |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | Amount Approved for reimbursement
 |  |  |  |  |  |  |  | I certify that I have personally examined and approved this Travel Expense Account
 |  |  |  |  |  |  |  | Settlement. The terms of expense are reasonable and correspond to the assigned
 |  |  |  |  |  |  |  | duties of the traveler. The terms of expense further meet all State of West Virginia
 |  |  |  |  |  |  |  | Travel Regulations and are within the budget of this spending unit.
 |  |  |  |  |  |  |  |  | Approval Supervisor |  |  |  | Date
Traveler must attach copies of direct billed receipts or
invoices, i.e., airline, registration, lodging, etc. |  |  |  |  |  |  |  |  | Vice President or GRDI Department Head |  |  |  | Date
 |  |  |  |  |  |  |  | Title III Coordinator/Provost |  |  |  |  | Date
I certify that these costs incurred were in connection with my assigned duties, are true, accurate and actual, and do not reflect any costs or expenses reimbursed or to be reimbursed from any other sources. |  |  |  |  |  |  |  | Budget Office |  |  |  |  | Date
 |  |  |  |  |  |  |  | [NAME] of GRDI Approval |  |  |  |  | Date
[NAME]'s Signature |  |  |  |  |  | Date
 |  |  |  |  |  |  |  | Executive Director [NAME] |  |  |  |  | Date
Spreadsheet: 849717d1700129900-allocation-of-hours-between-dates-formula-issues-example-data
Sheet: Worksheet

Start | End | Wk Start | Wk End | Hrs required | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
2023-11-01 00:00:00 | 2023-12-01 00:00:00 |  |  | 25
2023-11-01 00:00:00 | 2023-12-01 00:00:00 |  |  | 25
2023-11-01 00:00:00 | 2023-12-01 00:00:00 |  |  | 25
Spreadsheet: dutch_quigley__9176__Delta11-27
Sheet: Sheet1

Crude Oil
 |  | Delta
Month | Futures | Options | Combined
2002-01-01 00:00:00 | -1163 | -524
2002-02-01 00:00:00 | -2789 | 24.45
2002-03-01 00:00:00 | -1543 | -346
2002-04-01 00:00:00 | -810 | 244.8
2002-05-01 00:00:00 | -392 | 53.45
2002-06-01 00:00:00 | -2647 | 761.5
2002-07-01 00:00:00 | -62 | 0
2002-08-01 00:00:00 | -12 | 7.5
2002-09-01 00:00:00 | -107 | -143.65
2002-10-01 00:00:00 | -173 | 0
2002-11-01 00:00:00 | -63 | 0
2002-12-01 00:00:00 | -1393 | -21
2003-01-01 00:00:00 | -1043 | 0
2003-02-01 00:00:00 | 200 | 0
2003-03-01 00:00:00 | -250 | 0
2003-06-01 00:00:00 | -78 | 23.25
2003-07-01 00:00:00 | -15 | 0
2003-08-01 00:00:00 | -15 | 0
2003-09-01 00:00:00 | 85 | 0
2003-10-01 00:00:00 | -15 | 0
2003-11-01 00:00:00 | -15 | 0
2003-12-01 00:00:00 | -771 | -20.75
2004-06-01 00:00:00 | 100 | 0
2004-12-01 00:00:00 | -285 | 0
2005-12-01 00:00:00 | 1024 | 0
2006-12-01 00:00:00 | -725 | 0
2007-12-01 00:00:00 | 284 | 0
Spreadsheet: 862954d1710512058-formula-to-show-two-months-in-one-cell-weeklyschedule
Sheet: Schedule

 |  |  |  | Week: | 2024-03-27 00:00:00
 |  |  | 2024
 |  |  | SHIFT | RDO
 |  | This line should remain blank and hidden
 |  | GRAVE/MIDS | MIN-3
 |  |  |  | S/S | X |  |  |  |  |  | X
 |  | JOY |  | S/M | X | VAC | VAC | VAC | VAC | VAC | VAC
 |  | [NAME] |  | T/W | T | T | X | X | T | T | H
 |  | KAVIKA |  | W/T | T | T | H | X | X | H | T
 |  | RICHARD |  | T/F | H | H | T | T | OT-H | OT-T | T
 |  | [NAME] T - LEAD |  | F/S | FMLA | FMLA | FMLA | FMLA | FMLA | X | X
 |  | O.T. |  |  |  |  | T | T | T
 |  | O.T. |  |  |  |  |  | H
 |  |  |  |  | H - HANGAR |  |  |  | T - TERM
 |  |  |  |  | JURY |  |  |  | HO - HOLIDAY OFF
 |  |  |  |  | CB - COMPANY BUSINESS |  |  |  | ANP
 |  |  |  |  | TVL - TRAVEL |  |  |  | TDW -T TERM TRADE DAY WORKING
 |  |  |  |  | TDY - TEMPORARY DUTY |  |  |  | TDO - TRADE DAY OFF
 |  |  |  |  | [NAME] TRAINING |  |  |  | VAC
 |  |  |  |  | HOLT - HOLIDAY TAKEN |  |  |  | DAT
 |  |  |  |  | T/T @ TERM |  |  |  | SK - SICK
 |  |  |  |  | OT-T |  |  |  | OT-H
 |  |  |  |  | FMLA |  |  |  | TDW-H - HGR TRADE DAY WORKING
Spreadsheet: 865585d1712650673-adding-merging-a-formula-with-an-existing-formula-to-capture-2-conditions-pay-calculator_2024_rev-04_forum-version
Sheet: Pay Calculator

Employee Name :
Employee Staff # :
 |  |  |  |  |  |  |  |  | PENALTY AWARDS and ADDITIONS
DATE | DAY | PAY CLASSIFICATION | ADD-ON #1 | NORMAL HOURS PAID $ |  | VOLUNTARY and ROSTERED OVERTIME  + SUNDAY |  |  | LATE/EARLY PENALTY | BROKEN SHIFT |  | HIGH CAPACITY ALLOWANCE | TRAVELLING TIME |  | PUBLIC HOLIDAY |  |  |  | ROSTERED DAY OFF CANCELLED (RDOC) |  | ALLOCATED DAY OFF CANCELLED (ADOC) |  |  |  | ADO |  | ANNUAL LEAVE | ANNUAL LEAVE LOADING | SICK DAY
 |  |  |  |  |  | 1½ | DOUBLE |  |  | 1.5 | 2 |  |  |  | WORK | +  PUBLIC HOLIDAY | NO WORK |  | 1st. 3 hrs | After 3hrs | ADO Default | 1st. 3 hrs | After 3hrs
WEEK 1
 |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  | Week 1 Totals :
WEEK 2
 |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  | Week 2 Totals :
 |  | COMBINED TOTAL :
Spreadsheet: 87220d1287067570-address-field-to-column-formatting-eg-address-file
Sheet: Sheet1

Contactadd1 | Contactadd2 | Contactadd3 | Contactadd4 | Contactadd5 | Contactpcode
 | 2 | R Avenue | LEIGH | East Anglia | JG6 1PA
3 | C Gardens | [NAME] |  | 0 | D65 1AU
Flat 8 | Hartley House | London |  | 0 | SR4 6AL
00 | Clowns road | Beckenham |  | 0 | YP3 6TG
Housing Office | Saffire House | Telford |  | 0 | TG1 3AD
PLOT 1 | DEVELOPMENT 2 |  | Town |  | TG14PO
3 This CANYON | SHIRWAVM | yorkshire |  | 0 | CY55 9PR
The Billions | Huge Avenue | Rother Valley |  | 0 | H33 9JB
Spreadsheet: 693883d1599203791-add-count-to-cell-string-changemiddlecells
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Sample
001 |  |  | 035 | 001 | 100 |  |  |  |  | 035001100
002 |  |  |  |  | 200 |  |  |  |  | 035001200
003 |  |  |  |  | 300 |  |  |  |  | 035001300
004 |  |  |  |  | 400 |  |  |  |  | 035001400
005 |  |  |  |  | 500 |  |  |  |  | 035001500
006 |  |  |  |  | 600 |  |  |  |  | 035001600
007 |  |  |  |  | 700 |  |  |  |  | 035001700
008 |  |  |  |  |  |  |  |  |  | 035002100
009 |  |  |  |  |  |  |  |  |  | 035002200
010 |  |  |  |  |  |  |  |  |  | 035002300
011 |  |  |  |  |  |  |  |  |  | 035002400
012 |  |  |  |  |  |  |  |  |  | 035002500
013 |  |  |  |  |  |  |  |  |  | 035002600
014 |  |  |  |  |  |  |  |  |  | 035002700
015 |  |  |  |  |  |  |  |  |  | 035003100
016 |  |  |  |  |  |  |  |  |  | 035003200
017 |  |  |  |  |  |  |  |  |  | 035003300
018 |  |  |  |  |  |  |  |  |  | 035003400
019 |  |  |  |  |  |  |  |  |  | 035003500
020 |  |  |  |  |  |  |  |  |  | 035003600
021 |  |  |  |  |  |  |  |  |  | 035003700
022 |  |  |  |  |  |  |  |  |  | 035004100
023 |  |  |  |  |  |  |  |  |  | 035004200
024 |  |  |  |  |  |  |  |  |  | 035004300
025 |  |  |  |  |  |  |  |  |  | 035004400
026 |  |  |  |  |  |  |  |  |  | 035004500
027 |  |  |  |  |  |  |  |  |  | 035004600
028 |  |  |  |  |  |  |  |  |  | 035004700
029
030
031
032
033
034
035
036
037
038
039
040
041
042
043
044
Spreadsheet: jeff_dasovich__14124__FIN group project2
Sheet: attendance

ASSUMES [NAME] DESPITE INCREASED PRICES
 | Year | Attendance | price 1 | Sales | PV @ 7/97 | PV @ 7/97 | PV @ 7/97 | PV @ 7/97 | PV @ 7/97 | PV @ 7/97
1 | 1999 | 2703704 | 15.64
2 | 2000 | 2478395 | 16.23
3 | 2001 | 2253086 | 16.87
4 | 2002 | 2253086 | 17.54
5 | 2003 | 2253086 | 18.26
6 | 2004 | 2253086 | 19.01
7 | 2005 | 2253086 | 19.79
8 | 2006 | 2253086 | 20.6
9 | 2007 | 2253086 | 21.45
10 | 2008 | 2253086 | 22.32
11 | 2009 | 2253086 | 23.24
12 | 2010 | 2253086 | 24.19
13 | 2011 | 2253086 | 25.18
14 | 2012 | 2253086 | 26.22
15 | 2013 | 2253086 | 27.29
16 | 2014 | 2253086 | 28.42
17 | 2015 | 2253086 | 29.58
18 | 2016 | 2253086 | 29.58
19 | 2017 | 2253086 | 29.58
20 | 2018 | 2253086 | 29.58
[NAME] WITH INCREASED PRICES - ELASTICITY = .75
 | Year | Attendance | price 1 | Sales | PV @ 7/97 | Attendance | price 1 | Sales | PV @ 7/97 | Attendance | price 1 | Sales | PV @ 7/97
1 | 1999
2 | 2000
3 | 2001
4 | 2002
5 | 2003
6 | 2004
7 | 2005
8 | 2006
9 | 2007
10 | 2008
11 | 2009
12 | 2010
13 | 2011
14 | 2012
15 | 2013
16 | 2014
17 | 2015
18 | 2016
19 | 2017
20 | 2018
Spreadsheet: 154632d1336498700-formula-returning-the-value-of-the-cell-below-a-reference-cell-sample
Sheet: Profitabiliy

 |  | [NAME] here to get following week based on calendar on first tab
 | If 4, s/b | 5(1) | 5(2) | 6 | 7 | 8 | 9
Week | 4
Revenue
Costs
Margin | 0 | 0 | 0 | 0 | 0 | 0 | 0