tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: cb555a94-4fb0-47e2-945b-5f5afa231ae2
Sheet: Sheet1

[NAME] AND SUBSIDIARIES | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
(condensed consolidated financial statements -
dollars in millions, except per share data)
Statement of Earnings
 |  |  | Three Months ended |  |  |  |  |  | Year ended
 |  |  | December 31 |  |  |  |  |  | December 31
 |  |  | 2003 |  |  | 2002 |  |  | 2003 |  |  | 2002
Electrical Products |  | $ | 182.7 |  | $ | 177.5 |  | $ | 824.6 |  | $ | 790.4
Water Systems |  |  | 186.1 |  |  | 181 |  |  | 706.1 |  |  | 678.7
Net sales |  |  | 368.8 |  |  | 358.5 |  |  | 1530.7 |  |  | 1469.1
Cost of products sold |  |  | 293.6 |  |  | 283.4 |  |  | 1232 |  |  | 1169.3
Gross profit |  |  | 75.19999999999993 |  |  | 75.1 |  |  | 298.7 |  |  | 299.8
Selling, general and administrative |  |  | 51.7 |  |  | 54.4 |  |  | 206.2 |  |  | 206.2
Interest expense |  |  | 3.2 |  |  | 2.9 |  |  | 12.2 |  |  | 13.9
Other expense |  |  | 0.7 |  |  | 0.7 |  |  | 1.3 |  |  | 1.3
 |  |  | 19.59999999999992 |  |  | 17.1 |  |  | 79.00000000000006 |  |  | 78.39999999999995
Tax provision |  |  | 6.9 |  |  | 5.9 |  |  | 26.8 |  |  | 27.1
Net Earnings |  | $ | 12.69999999999992 |  | $ | 11.2 |  | $ | 52.20000000000006 |  | $ | 51.29999999999995
Net Earnings Per Share of Common Stock (Diluted) |  | $ | 0.4249933858312802 |  | $ | 0.3794047965302897 |  | $ | 1.756933737311415 |  | $ | 1.855397213055947
 | Average Common Shares Outstanding  (000's omitted) |  | 29882.818 |  |  | 29519.922 |  |  | 29710.853 |  |  | 27649.066
Spreadsheet: 48825d1248121122-importing-certain-data-to-another-worksheet-test
Sheet: info

 |  |  | Buy
No. | Account ID | Account Name | Yes/No |  | Yes
1 | 123 | abc | No |  | No
2 | 1234 | [NAME] | Yes
3 | 151 | qwer | No
4 | 5151 | [NAME] | Yes
5 | 1515 | qwer | Yes
6 | 15184 | fasd | Yes
7 | 894 | qwer | Yes
8 | 4 | fasd | Yes
9 | 84984 | qwer | Yes
10 | 41 | fasd | No
11 | 4964 | qwer | Yes
12 | 494 | fasd | Yes
13 | 494 | we | Yes
14 | 9844184 | rf | No
15 | 96441841 | saf | Yes
16 | 41 | qwer | Yes
17 | 4 | erf | No
18 | 441 | saf | Yes
19 | 41 |  | Yes
20 | 4 |  | Yes
21 |  |  | Yes
22 |  |  | Yes
23 |  |  | Yes
24 |  |  | Yes
25 |  |  | Yes
26 |  |  | Yes
27 |  |  | Yes
28 |  |  | Yes
29 |  |  | Yes
30 |  |  | Yes
31 |  |  | Yes
32 |  |  | Yes
33 |  |  | Yes
34 |  |  | Yes
35 |  |  | Yes
36 |  |  | Yes
37 |  |  | Yes
38 |  |  | Yes
39 |  |  | Yes
40 |  |  | Yes
41 |  |  | Yes
42 |  |  | Yes
43 |  |  | Yes
44 |  |  | Yes
45 |  |  | Yes
46 |  |  | Yes
47 |  |  | Yes
48 |  |  | Yes
49 |  |  | Yes
50 |  |  | Yes
51 |  |  | Yes
52 |  |  | Yes
53 |  |  | Yes
54 |  |  | Yes
55 |  |  | Yes
56 |  |  | Yes
57 |  |  | Yes
58 |  |  | Yes
59 |  |  | Yes
60 |  |  | Yes
61 |  |  | Yes
62 |  |  | Yes
63 |  |  | Yes
64 |  |  | Yes
65 |  |  | Yes
66 |  |  | Yes
67 |  |  | Yes
68 |  |  | Yes
69 |  |  | Yes
70 |  |  | Yes
71 |  |  | Yes
72 |  |  | Yes
73 |  |  | Yes
74 |  |  | Yes
75 |  |  | Yes
76 |  |  | Yes
77 |  |  | Yes
78 |  |  | Yes
79 |  |  | Yes
80 |  |  | Yes
81 |  |  | Yes
82 |  |  | Yes
83 |  |  | Yes
84 |  |  | Yes
85 |  |  | Yes
86 |  |  | Yes
87 |  |  | Yes
88 |  |  | Yes
89 |  |  | Yes
90 |  |  | Yes
91 |  |  | Yes
92 |  |  | Yes
93 |  |  | Yes
94 |  |  | Yes
95 |  |  | Yes
96 |  |  | Yes
97 |  |  | Yes
98 |  |  | Yes
99 |  |  | Yes
100 |  |  | Yes
101 |  |  | Yes
102 |  |  | Yes
103 |  |  | Yes
104 |  |  | Yes
105 |  |  | Yes
106 |  |  | Yes
107 |  |  | Yes
108 |  |  | Yes
109 |  |  | Yes
110 |  |  | Yes
111 |  |  | Yes
112 |  |  | Yes
113 |  |  | Yes
114 |  |  | Yes
115 |  |  | Yes
116 |  |  | Yes
117 |  |  | Yes
118 |  |  | Yes
119 |  |  | Yes
120 |  |  | Yes
121 |  |  | Yes
122 |  |  | Yes
123 |  |  | Yes
124 |  |  | Yes
125 |  |  | Yes
Spreadsheet: 875956d1722589199-help-with-overtime-formula-overtime-example-4
Sheet: Sheet1

You must use the format HH:[NAME] (ie 09:00 or 17:00) when entering your time. It reformats the cell if you use any other way (ie 9 or 17 or 9.00 ect) this will change the calculations and the sheet won't be correct.
 |  | Enter start time: 24hr clock | Enter time work over lunch. ie 00:30 minuets worked | Enter finish time: 24hr clock | This is calculated when putting in start and finish time | This is calculated when putting in start and finish time | This is calculated when putting in start and finish time | Final running total of overtime
Date | Day | Start | Lunch | Finish | Hours | Overtime | Time taken back | Total
2024-09-16 00:00:00 | Monday | 08:00:00 | 00:15:00 | 17:00:00 |  |  |  |  | Example: started 8am, work 15 min over lunch finished 5pm.
2024-09-17 00:00:00 | Tuesday |  |  |  |  |  |  |  | The formula takes off 1 hour for lunch so if you work any of that time you need to add it to the sheet.
2024-09-18 00:00:00 | Wednesday | 09:00:00 |  | 16:00:00 |  |  |  |  | Example: any time worked on off days will be added with no subtractions
2024-09-19 00:00:00 | Thursday
2024-09-20 00:00:00 | Friday | 09:00:00 |  | 12:00:00 |  |  |  |  | Example: Time taken back will come off the total.
2024-09-21 00:00:00 | Saturday
2024-09-22 00:00:00 | Sunday
2024-09-23 00:00:00 | Monday
2024-09-24 00:00:00 | Tuesday
2024-09-25 00:00:00 | Wednesday
2024-09-26 00:00:00 | Thursday
Spreadsheet: 822541d1679409314-pulling-down-a-formula-discards-a-test256
Sheet: Sheet1

 |  |  |  | DEC | DEC | JAN | JAN | FEB | FEB
 |  |  |  | LAB | TAP | LAB | TAP | LAB | TAP
 |  |  | RENT & RATES | 11650 | 7114 | 11650 | 7114 | 11650 | 7114
 |  |  | INSURANCE | 11093.24 | 0 | 0 | 0 | 0 | 0
 |  |  | MAINTENANCE | 7638.01 | 7321.690000000001 | 13067.17 | 3330.39 | 8682.019999999999 | 2572.53
 |  |  | IT COSTS | 9697.17 | 9697.17 | 8434.31 | 8434.31 | 6703.12 | 6703.12
 |  |  | HEAT & LIGHT | 188.13 | 0.8700000000000001 | 4675.750000000001 | 559.5899999999999 | 4113 | 3293.43
 |  |  | WASTE DISPOSAL | 4736.25 | 4736.25 | 5835.809999999999 | 5835.809999999999 | 7314.09 | 7314.09
 |  |  | STAFF WELFARE | 1743.33 | 1743.33 | 565.6899999999999 | 565.6899999999999 | 31.66000000000001 | 31.66000000000001
 |  |  | [NAME] | 14674 | 14674 | 14674 | 14674 | 22786 | 22786
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
LAB |  |  | PREMISES COSTS | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | DEC | JAN | FEB
 |  |  | RENT & RATES
 |  |  | INSURANCE
 |  |  | MAINTENANCE
 |  |  | IT COSTS
 |  |  | HEAT & LIGHT
 |  |  | WASTE DISPOSAL
 |  |  | STAFF WELFARE
 |  |  | [NAME]
 |  |  | 0
 |  |  | 1
Spreadsheet: 168054d1342203273-excel-for-mac-08-automatically-highlight-high-low-value-in-each-row-of-selected-columns-high-lo-highlight-example
Sheet: Sheet1

Our SKU | Total Price Store 1 | Final Margin Store 1 | Total Price Store 2 | Final Margin Store 2 | Total Price Store 3 | Final Margin Store 3 | Total Price Store 4 | Final Margin Store 4 | Total Price Store 5 | Final Margin Store 5 | Total Price Store 6 | Final Margin Store 6
16222 | 38.94 | 0.1218037657001447 | 40.48999999999999 | 0.123259783560475 | 40.98999999999999 | 0.1720455647917447 | 41.23 | 0.112884759552841 | 41 | 0.1790936391486445 | 48.91009090909091 | 0.376961446884915
26036 | 13.94 | 0.1309540889526542 | 15.49 | 0.09510974822466108 | 15.99 | 0.2042589118198874 | 15.765 | 0.1260545512210594 | 14.99 | 0.4796493646972377 | 16.9435 | 0.3490471272169269
16223 | 21.44 | 0.1476092689959294 | 22.99 | 0.14843378544031 | 23.49 | 0.2104232748945392 | 23.085 | 0.1348318270423534 | 22.99 | 0.1821943632478119 | 26.46351818181818 | 0.3851883433350957
11013-2 | 23.44 | 0.1141386906608748 | 24.99 | 0.1169732256538978 | 25.49 | 0.202789243128964 | 26.875 | 0.144742731501057 | 25.99 | 0.3773376111749848 | 32.43747272727273 | 0.4115976303500833
15042 | 25.44 | 0.1487291666666667 | 26.99 | 0.1123164134864765 | 27.49 | 0.2466318763503408 | 30.085 | 0.1868545786937013 | 29.99 | 0.2284163996694549 | 32.96619999999999 | 0.4038902269597345
18026 | 23.94 | 0.1464812409812409 | 25.49 | 0.108062413067513 | 25.99 | 0.2424963827342321 | 28.085 | 0.1813106964248143 | 26.99 | 0.1961383472432331 | 30.63972272727273 | 0.3981112041276186
18075 | 22.94 | 0.09917843650101706 | 24.49 | 0.1030176942969919 | 24.99 | 0.1600941710017339 | 24.24 | 0.07234543454345438 | 21.99 | 0.2422140577732962 | 31.30311666666666 | 0.3946953950804685
14007 | 19.94 | 0.1588454910185099 | 21.49 | 0.1589171284741316 | 21.99 | 0.2272841787589399 | 21.585 | 0.1495357466253922 | 19.99 | 0.3941324492285668 | 23.43817727272727 | 0.3729502934121274
Spreadsheet: benjamin_rogers__1206__United American Energy 03-02-00
Sheet: IS

INCOME STATEMENT
('000 $)
 |  | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2022-12-31 00:00:00 | 2023-12-31 00:00:00 | 2024-12-31 00:00:00 | 2025-12-31 00:00:00 | 2026-12-31 00:00:00 | 2027-12-31 00:00:00 | 2028-12-31 00:00:00 | 2029-12-31 00:00:00 | 2030-12-31 00:00:00 | 2031-12-31 00:00:00
Revenue
Capacity Revenue
Energy Revenue
Ancillary Services |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Revenue
Expense
Fuel
Fixed Operating Expenses
Variable Operating Expenses
Major [NAME]
Insurance
SG&A
Start Charge
Property Tax |  | 400
Franchise Tax
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Debt Service Reserve [NAME]
Marketing Fee
Administrative Fee
O&M Fees
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
Pretax Book Income
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
Net Income
Spreadsheet: 675388d1588265571-how-to-not-input-cell-information-when-an-adjacent-cells-hasnt-been-completed-cells-continuing-running-down-sheet
Sheet: Sheet1

 | DOB | Age | Age Risk score
[NAME] | 1983-07-28 00:00:00
bob | 2001-01-19 00:00:00
[NAME] | 1950-01-19 00:00:00
[NAME] | 1983-07-28 00:00:00
[NAME] | 1942-05-23 00:00:00
[NAME] | 1990-01-19 00:00:00
mark | 1976-03-23 00:00:00
henry | 2001-01-19 00:00:00
[NAME] | 1968-12-19 00:00:00
[NAME] | 1999-01-19 00:00:00
Julie | 1959-01-19 00:00:00
[NAME] | 1980-07-12 00:00:00
 |  |  |  |  |  | ** Im not too bothered about colm D as this will be hidden
 |  |  |  | stop colm C
 |  |  |  | inputting
 |  |  |  | data
 |  |  |  | where
 |  |  |  | no DOB
 |  |  |  | has been
 |  |  |  | entered
Spreadsheet: 58507d1258734761-cell-phone-optimization-long-if-statement-spreadsheettemplate
Sheet: Sheet1

Cell Phones | Monthly Rate | Free Minutes | Excess Time | Long Distance | Text Message
Flat Rate Plan | 8.95 | 0 | 0.13 | 0.1 | 0.15
1200 Minute Plan | 80 | 1200 | 0.15 | 0.1 | 0.15
Imove 1800 | 140 | 1800 | 0.15 |  | 0.15
Imove 3400 | 210 | 3400 | 0.15 |  | 0.15
 |  |  |  |  |  |  |  |  | 0 | Flat Rate Plan
 |  |  |  |  |  |  |  |  | 616 | 1200 Minute Plan
 |  |  |  |  |  |  |  |  | 1600 | Imove 1800
 |  |  |  |  |  |  |  |  | 2266 | Imove 3400
 |  |  |  |  |  |  |  |  |  | 2009-Aug |  |  |  |  |  |  | 2009-Sep
 |  |  |  |  |  |  |  | Optimal Plan |  | Minutes Used | Long Distance Min | Text Messages | Current Plan Cost | Optimal Plan Cost | Difference |  | Minutes Used | Long Distance | Text Messages | Current Plan Cost | Optimal Plan Cost | Difference
 |  |  |  |  |  |  |  | Flat Rate Plan |  |  |  |  |  | THIS IS WHERE I WANT THE FORMULA TO GO TO CALCULATE THE COST.
 |  |  |  |  |  |  |  | Flat Rate Plan
 |  |  |  |  |  |  |  | Flat Rate Plan
 |  |  |  |  |  |  |  | Flat Rate Plan
 |  |  |  |  |  |  |  | Flat Rate Plan
 |  |  |  |  |  |  |  | Flat Rate Plan
Spreadsheet: 839081d1691648760-sumif-formula-help-financial-report-2023-season-financial-report
Sheet: February

Date | Transaction | Withdrawals | Deposits | Balance | Code | Comments
Opening balance |  |  |  | 10338.61 | Code
2023-02-01 00:00:00 | INTEREST |  | 0.08 | 10338.69 | INT
2023-02-10 00:00:00 | OSKO PAYMENT   [NAME] meetin> | 148.2 |  | 10190.49 | REIMB
2023-02-13 00:00:00 | DIRECT CREDIT  PLAYHQCOM-seWq6QXA PLAYHQCOM            [PHONE] |  | 96.73 | 10287.22 | PLAYHQ
2023-02-14 00:00:00 | DIRECT CREDIT  PLAYHQCOM-Er1P4OtO PLAYHQCOM            [PHONE] |  | 65.8 | 10353.02 | PLAYHQ
2023-02-17 00:00:00 | DIRECT CREDIT  PLAYHQCOM-ef9Iygi0 PLAYHQCOM            [PHONE] |  | 96.73 | 10449.75 | PLAYHQ
2023-02-20 00:00:00 | DIRECT CREDIT  PLAYHQCOM-zmhBb6vx PLAYHQCOM            [PHONE] |  | 32.9 | 10482.65 | PLAYHQ
2023-02-25 00:00:00 | OSKO PAYMENT   [NAME] box renewal | 47 |  | 10435.65 | REIMB
Transaction totals / Closing balance |  | 195.2 | 292.24 | 10435.65
Spreadsheet: 540780d1506961507-sumproduct-formula-over-cumulative-date-range-failing-sample-2
Sheet: Sheet1

 | Year |  | Product
 | 2015/16 |  | d
 |  |  |  |  |  |  |  |  | My Formula
Name | Allocated | Date order Received | [NAME] | Balance | Paid | Product
[NAME] |  | 2015-09-01 00:00:00 | 2 |  |  | a
[NAME] |  | 2015-09-01 00:00:00 | 2 |  |  | a
[NAME] |  | 2015-09-01 00:00:00 | 1 |  |  | b |  |  | xlnitwit formula
[NAME] |  | 2015-09-03 00:00:00 | 2 |  |  | b
[NAME] |  | 2015-09-03 00:00:00 | 3 |  |  | b
[NAME] |  | 2015-09-03 00:00:00 | 1 |  |  | c |  |  |  | Updated formula that worked untill system date is past 31st December
[NAME] |  | 2015-09-03 00:00:00 | 2 |  |  | c
[NAME] |  | 2015-09-04 00:00:00 | 2 |  |  | a
[NAME] |  | 2015-09-04 00:00:00 | 4 |  |  | d
[NAME] |  | 2015-09-04 00:00:00 | 1 |  |  | a
[NAME] |  | 2015-09-04 00:00:00 | 1 |  |  | a
[NAME] |  | 2015-09-04 00:00:00 | 1 |  |  | d
[NAME] |  | 2015-09-05 00:00:00 | 2 |  |  | d
[NAME] |  | 2015-09-05 00:00:00 | 1 |  |  | c
[NAME] |  | 2015-09-05 00:00:00 | 1 |  |  | c
[NAME] |  |  |  |  |  | b
[NAME] |  | 2015-09-07 00:00:00 | 2 |  |  | a
[NAME] |  | 2015-09-07 00:00:00 | 1 |  |  | a
[NAME] |  | 2015-09-07 00:00:00 | 1 |  |  | a
[NAME] |  | 2015-09-07 00:00:00 | 1 |  |  | a
[NAME] |  | 2015-09-07 00:00:00 | 2 |  |  | a
[NAME] |  | 2015-09-07 00:00:00 | 1 |  |  | c
[NAME] |  | 2015-10-01 00:00:00 | 1 |  |  | d
[NAME] |  | 2015-10-01 00:00:00 | 1 |  |  | d
[NAME] |  | 2015-10-02 00:00:00 | 2 |  |  | d |  |  | Req Answer
[NAME] |  | 2015-10-02 00:00:00 | 4 |  |  | d |  |  | 15
[NAME] |  | 2015-10-04 00:00:00 | 1 |  |  | d
[NAME] |  | 2015-10-06 00:00:00 | 1 |  |  | c
[NAME] |  | 2015-10-06 00:00:00 | 1 |  |  | c
Monika Tchorzewska |  | 2015-10-06 00:00:00 | 2 |  |  | c
[NAME] |  | 2015-10-06 00:00:00 | 1 |  |  | b
[NAME] |  | 2015-10-10 00:00:00 | 1 |  |  | a
[NAME] |  | 2015-11-03 00:00:00 | 1 |  |  | a
[NAME] |  | 2015-11-07 00:00:00 | 1 |  |  | c
Leighton Park School |  | 2015-11-10 00:00:00 | 1 |  |  | d
[NAME] |  | 2015-11-12 00:00:00 | 3 |  |  | a
[NAME] |  | 2015-12-05 00:00:00 | 1 |  |  | d
[NAME] |  | 2015-12-10 00:00:00 | 4 |  |  | d
[NAME] |  | 2015-12-20 00:00:00 | 2 |  |  | b
[NAME] |  | 2015-12-22 00:00:00 | 6 |  |  | c
[NAME] |  | 2016-01-04 00:00:00 | 3 |  |  | a
[NAME] |  | 2016-01-08 00:00:00 | 4 |  |  | b
[NAME] |  | 2016-01-12 00:00:00 | 1 |  |  | c
Spreadsheet: 863744d1711128615-count-instances-or-frequency-multiple-sheets-counting-position-appearances-in-baseball-excel-help-forum-roster-template-2024-03-22
Sheet: Game 7

Date: |  | 2024-05-01 00:00:00 |  |  | Field: |  |  | Start Time: |  | 18:00:00
Home: |  |  |  |  | 3rd | Set Up
Visitors: |  |  |  |  | 1st | Clean Up
 |  |  |  |  | Inning
 |  | Player |  |  | Coach Pitch |  |  |  |  |  | Innings on Bench | Innings in Infield | Inninings in Outfield |  |  |  | [NAME]
Order |  | First | Last | # | 1 | 2 | 3 | 4 | 5 | 6
1 | 12 | [NAME] |  |  | 1B (3) | 1B (3) | 1B (3) | LF (7) | LF (7) | LF (7) |  |  |  |  | P (1)
2 | 11 | Ty |  |  | 2B (4) | 2B (4) | 2B (4) | RF (9) | RF (9) | RF (9) |  |  |  |  | C (2)
3 | 1 | [NAME] |  |  | 3B (5) | 3B (5) | 3B (5) | LCF () | LCF () | LCF () |  |  |  |  | 1B (3)
4 | 2 | [NAME] |  |  | LF (7) | LF (7) | LF (7) | 1B (3) | 1B (3) | 1B (3) |  |  |  |  | 2B (4)
5 | 4 | [NAME] |  |  | P (1) | P (1) | P (1) | [NAME] () | [NAME] () | [NAME] () |  |  |  |  | 3B (5)
6 | 5 | Willie |  |  | X | RF (9) | RF (9) | 3B (5) | 3B (5) | 3B (5) |  |  |  |  | SS (6)
7 | 10 | [NAME] |  |  | RF (9) | X | SS (6) | SS (6) | C (2) | C (2) |  |  |  |  | LF (7)
8 | 9 | [NAME] |  |  | SS (6) | SS (6) | X | 2B (4) | 2B (4) | 2B (4) |  |  |  |  | CF (8)
9 | 6 | Babe |  |  | LCF () | LCF () | LCF () | X | SS (6) | SS (6) |  |  |  |  | RF (9)
10 | 7 | [NAME] |  |  | C (2) | C (2) | [NAME] () | P (1) | X | P (1) |  |  |  |  | SF (10)
11 | 8 | [NAME] |  |  | [NAME] () | [NAME] () | C (2) | C (2) | P (1) | X |  |  |  |  | EH ()
12 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | LCF ()
13 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ()
Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roster pulled from list on roster tab
 | 9
 | 9
Notes:
 |  |  |  | Players on [NAME]
 |  | Only pull a players first name from the drop down
Spreadsheet: 93900d1293661016-excel-2007-clearing-a-row-after-a-particular-word-selected-cat-working-file
Sheet: 157WF

157WF
LAST QUARTERLY | QUARTERLY DUE NLT | NEXT QUARTERLY START | UPDATED BY: | LAST MASO | MASO DUE NLT | NEXT MASO START | UPDATED BY: | JACKET REVIEW | IMT 68     DATE | IMT 68 REVIEW
2010-12-01 00:00:00 |  |  | CJY | 2010-02-16 00:00:00 |  |  | CJY |  | 2010-08-26 00:00:00 | 2010-12-01 00:00:00
JACKET REVIEW
NAME |  | DATE ACCOMPLISHED |  | COMMENTS / FINDINGS
DEEMER |  | 2010-09-08 00:00:00
GENERAL ACCOUNT INFORMATION / NOTES
RETURN TO STATUS PAGE |  |  | INVENTORY STATUS PAGE
Spreadsheet: 135316d1325925694-display-annual-leave-dates-by-employee-2012-staff-planner
Sheet: holiday form 2012-2013

 |  |  |  |  |  |  |  |  | 2012 - 2013  HOLIDAY FORM
 | DATE HOLIDAY REQUESTED |  |  |  |  | 2012-01-07 00:00:00 |  |  |  | Employee ID No |  | 15
 | TO |  | mr blogg |  |  | FROM |  | Reece
 | (Line Manager) |  |  |  |  | (Your Name)
 |  |  |  |  |  | THE FIRST DAY OF MY HOLIDAY WILL BE |  |  |  |  | ANNUAL HOLIDAY ENTITLEMENT |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  | HOLIDAYS ALREADY TAKEN / BOOKED |  |  |  |  |  | 0
 |  |  |  |  |  | I WILL RETURN ON |  |  |  |  | CURRENT REQUEST |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | HOLIDAYS REMAINING |  |  |  |  |  | 34
 |  |  |  |  |  | THE AMOUNT OF DAYS REQUESTED
 |  |  |  |  |  | DURING MY ABSENCE IT HAS BEEN AGREED THAT |  |  |  |  |  | WILL TAKE MY AUTHORITIES
 |  |  |  |  |  |  |  |  | *PLEASE ENSURE THAT ALL NAMES ARE WRITTEN IN FULL
 | DATE |  |  |  |  | APPROVED BY |  |  |  |  |  |  | SIGNED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF ELECTRONIC COPY USED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-MAIL APPROVAL MUST BE ATTACHED
 | DATE FORM INPUT INTO HOLIDAY PLANNER |  |  |  |  |  |  |  |  |  |  |  | SIGNED
 | HOLIDAY DATES ALREADY BOOKED
#N/A
Spreadsheet: 800398d1665652682-check-if-text-string-has-comma-not-followed-by-space-empty-character-sample-data-xtinct2
Sheet: Sheet1

 | List | Initial Formula | Desired Result | [NAME] |  | [NAME] | [NAME] HD
 | one,two |  | not good
 | one, two |  | good
 | one,two, three |  | not good
 | one,@two
Spreadsheet: 819072d1677205358-lookup-from-different-workbooks-my-file
Sheet: Sheet1

 |  |  | Jan | Feb
 |  | A
 |  | B
 |  | C
 |  | D
 |  | E
Spreadsheet: 268005d1380353971-search-for-value-and-then-copy-value-in-adjacent-column-example-spreadsheet
Sheet: Sheet1

Case | Data | Result
A | ABCD | 2 |  |  | If case in Col A has "YEST" in Col B, then place "1" in all rows in Col C above "YEST" where case equal case in "Yest" row
B | JFST | 1 |  |  | Place a "2" in all rows above "YEST" for all cases which do not equal the case adjacent to the "YEST" row
B | KDSG | 1 |  |  | If case in Col A has "TMRW" in Col B, then place "3" in all rows in Col C above "TMRW" where case equal case in "TMRW" row
B | KSDH | 1 |  |  | Place a "4" in all rows above "TMRW" for all cases which do not equal the case adjacent to the "TMRW" row
B | SDJS | 1
A | SJFE | 2 |  |  | Then move on to the next time that "YEST" or "TMRW" appears in col B, and then repeat process up until previous "YEST"/"TMRW" row
A | KKDS | 2
B | YEST | 1
A | SDJS | 3
A | SDJS | 3
A | SJFE | 3
B | KKDS | 4
A | ITSK | 3
A | KSHD | 3
B | MFSH | 4
B | MCIE | 4
A | TMRW | 3
B | KSHD | 2
A | MFSH | 1
B | MCIE | 2
B | KKDS | 2
A | YEST | 1
A | MFSH | 4
B | MCIE | 3
B | SDJS | 3
A | KSHD | 4
B | MFSH | 3
A | MCIE | 4
B | TMRW | 3 |  | This is repeated for another 6000 rows, although "YEST" and "TMRW" may only appear ~10-12 times in total
Spreadsheet: 51fcb3d9-04d8-441a-af69-6172a9a97adb
Sheet: Overlays

 | This sheet shows the impact of overlays included in the final proposals (-ve's indicate a reduction in opex).
 | [NAME]
 | Include factor? | 1
 | January 2013 FBP Forecast |  |  |  | Q5 |  |  |  |  | Q5+1 | Q6 |  |  |  |  |  | Q6 Total | CAGR | per year
 | £m 2011/12 |  |  |  | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14 | 2014/15 | 2015/16 | 2016/17 | 2017/18 | 2018/19
 | PRT Opex impact - to be stripped out due to removal from RAB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | na
 | End
Spreadsheet: 0149a88d-ffe9-4677-b7f8-b4c25fb96422
Sheet: 55-60div.

ISA SENIOR WINTER NATIONALS
POLK COUNTY, FLORIDA
[NAME]
 | MEN'S 55/60 MAJOR & 60 AAA DIVISION
 | ALL GAMES PLAYED AT DIAMOND PLEX
 |  |  |  |  |  | WON |  | LOSS
1.  [NAME], 55M
2.  HOLLIS APPRAISAL, 60M+
3.  SOUTH FLORIDA HEAT, 60M
4.  AAG MUSTANGS, AAA
5.  CLUBHOUSE PUB, AAA
TIME |  | RUNS |  | TEAM# |  | RUNS |  | DIA. #
9AM |  |  |  | 5 V 1 |  |  |  | D
9AM |  |  |  | 2 V 3 |  |  |  | E
10:30AM |  |  |  | 5 V 3 |  |  |  | D
10:30AM |  |  |  | 1 V 4 |  |  |  | E
1PM |  |  |  | 5 V 2 |  |  |  | D
1PM |  |  |  | 3 V 4 |  |  |  | E
2:30PM |  |  |  | XX |  |  |  | D
2:30PM |  |  |  | 1 V 2 |  |  |  | E
4PM |  |  |  | 5 V 4 |  |  |  | E
NOTE: TEAM #1 GIVES 5 RUNS OR 11 DEFENSIVE PLAYERS IN ALL GAMES
TEAMS #4 & #5 GETS 5 RUNS OR 11 DEFENSIVE PLAYERS IN ALL SEED GAMES
[NAME]: | ALL TEAMS WILL PLAY 3 SEED GAMES.  THEN TEAMS 4 & 5 WILL PLAY THE BEST 2 OUT OF 3
 | TEAMS 1, 2 & 3 WILL BREAK OFF INTO A DOUBLE ELIMINATION BRACKET
HOME RUN RULE - MAJOR IS 6 THEN WALKS, AAA IS 3 PER GAME, THEN OUTS.   If AAA IS PLAYING
 |  | A MAJOR TEAM THEN YOU USE THE AAA HOME RUN RULE.
RUN RULE- 5 RUNS PER 1/2 INNING + OPEN INNING
TIME LIMITS - SEED GAMES 65 MIN. + OPEN INNING - BRACKET PLAY 70MIN.+ OPEN
 |  | CHAMPIONSHIP GAME IS 7 INNINGS
[NAME] FLIP
ROSTER IS SUBJECT TO APPROVAL OF SSUSA
YOU MUST WIN YOUR DIVISION TO RECEIVE THE SSUSA TOC BERTH
Spreadsheet: 788379d1658423897-index-match-from-dropdown-test_data
Sheet: googlesheet_data

order NO | Timestamp | Mobile No | Order | [NAME] | Curlyflower | Brinjal | Beans | Greens | Veg.Leavs | Red beans | [NAME] | [NAME] | Mint | [NAME] | Sapling | Column1 | bILL aMT | mESSAGE | [NAME] msg
 | 2022-07-13 13:38:52.583000 | 9820184935 | shrikant | 250 | 250 | 500 | 1 | 1 | 1 | 1 | 1 | 5 | 1 | 6 | 1
 | 2022-07-13 13:44:47.460000 | 8850472905 | Poushali | 250 | 500 | 250 |  |  |  | 1 | 1 |  | 1 | 12
 | 2022-07-13 21:31:26.659000 | 8779865339 | Pravina | 250 | 500 | 500 | 1 | 1 | 2 | 1 | 1 | 5 | 1 | 12 | 1
 | 2022-07-14 16:55:53.315000 | 9820184935 | Sharad | 250 | 250 | 500 | 2 | 3 | 1 | 1 | 2 | 10 | 1 | 12 | 1
 | 2022-07-14 16:59:46.383000 | 8888798891 | Wajpe | 250 |  |  | 1 |  |  |  |  |  |  |  | 1
 | 2022-07-14 20:20:20.195000 | 9987822123 | Dinesh | 250 | 750 | 750 |  |  | 2 |  | 2 | 10 | 2 | 12 | 2
 | 2022-07-14 20:35:11.944000 | 9423271410 | Vijay | 250 | 750 | 750
 | 2022-07-21 17:54:42.521000 | 9820184935 | Satish |  | 250 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `