tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 140622d1328821988-count-number-of-occurrences-conditionally-on-adjacent-cells-tigeravatar-example-for-toehrtman
Sheet: Sheet1

Account Num | Account Representative | Number Submitted
1 | [NAME] | 5
2 | [NAME] | 0
3 | [NAME] | 1
4 | [NAME] | 2
5 | [NAME] | 3
6 | [NAME] | 0
7 | [NAME] | 0
8 | [NAME] | 3
9 | [NAME] | 5
10 | [NAME] | 0
11 | [NAME] | 2
Spreadsheet: 750168d1633317026-summing-up-the-collected-data-in-a-30-minute-interval-period-dave
Sheet: Sheet1

00:00:01 | 00:00:01
01:00:01
02:00:01
03:00:01
04:00:01
05:00:01
06:00:01
07:00:01
08:00:01
09:00:01
10:00:01
11:00:01
12:00:01
13:00:01
14:00:01
15:00:01
16:00:01
17:00:01
18:00:01
19:00:01
20:00:01
21:00:01
22:00:01
23:00:01
Spreadsheet: 04608b3a-ff08-45d7-8c13-8b5212ea2ef7
Sheet: Example

Production Record-LUNCH
MENU PATTERN | MENU |  |  |  |  |  |  |  |  |  | GRADES: K-6 = 300
Meat/Meat Alternate | Chef Salad:  1 oz grilled chicken, .5 oz. low-fat mozzarella
Grains | Whole wheat roll (2 oz. equiv.) |  |  |  |  |  |  |  |  |  | ADULTS: 10
Vegetable | 1 cup romaine, .5 [NAME] corn, .25 cup raw baby carrots
Fruit | banana |  |  |  |  |  |  |  |  |  | TOTAL: 310
[NAME] | no-fat chocolate, 1% white
 | Planned |  |  |  |  |  |  | Actual
MENU COMPONENTS | STUDENT MEALS |  | ADULT MEALS OR A LA CARTE |  | TOTAL PLANNED SERVINGS | TOTAL PLANNED QUANTITY | PLANNED PURCHASE UNIT | QUANTITY PREPARED | PURCHASE UNIT | FOOD TEMPERATURE |  | ACTUAL SERVED | [NAME]
 | PLANNED | SERVING SIZE | PLANNED | SERVING SIZE | STUDENT+ADULT |  | (lbs., can, ozs.) |  | (lbs., can, ozs.) | PREP. | SERVING
Meat/ Meat Alternate:
Grilled chicken tenders | 300 | 1 oz. | 10 | 1 oz | 310 | 26.75 | pounds | 26.75 | pounds | 160 | 160 | 300 | 10, served as 2nd
low-fat mozzarella | 300 | 0.5 oz | 10 | .5 oz | 310 | 9.75 | pounds | 9.75 | pounds |  |  | 300 | 10, served as 2nd
Grains
Whole wheat roll | 300 | 2 oz | 10 | 2 oz | 310 | 350 | 2 oz. rolls | 350 | 2 oz. rolls |  |  | 300 | 50/freezer
USDA recipe [NAME], x3.5
Vegetables:
Romaine mix | 300 | 1 cup | 10 | 1 cup | 310 | 39.75 | pounds | 39.75 | pounds |  |  | 300 | 10, discarded
Corn | 300 | .5 [NAME] | 10 | .5 [NAME] | 310 | 16 | #10 cans | 16 | #10 cans | 140 | 140 | 300 | 10, discarded
Carrots | 300 | .25 cup | 10 | .25 cup | 310 | 24.25 | pounds | 24.25 | pounds |  |  | 300 | 10, served as 2nd
Fruit:
Bananas, petite, whole (3/8 cup) | 300 | each | 10 | each | 310 | 86.25 | pounds | 86.25 | pounds |  |  | 300 | 10, serve tomorrow
Milk:
no-fat chocolate | 280 | pints | 5 | pints | 285 | 285 | pints | 285 | pints | 33 | 35 | 285
1% white | 20 | pints | 5 | pints | 25 | 25 | pints | 25 | pints | 33 | 35 | 25
Other: (Condiments and [NAME])
low-fat ranch dressing, 1.5 oz | 280 | pkts. | 5 | pkts | 285 | 285 | pkts | 285 | pkts |  |  | 285
low fat Italian dressing, 1.5 oz | 20 | pkts. | 5 | pkts | 25 | 25 | pkts | 25 | pkts |  |  | 25
Spreadsheet: 469447d1467916349-need-true-vlookup-to-be-more-specific-help
Sheet: Report

 |  | Example outcome |  |  |  |  |  |  |  | Example Source
 |  |  | My Way |  | Other way?
 |  |  | 2016 | 2015 |  |  |  |  |  |  | 2015 | 2016
 |  | BLOOMBERG/GLOBAL/GP |  |  |  |  |  |  |  | Blackrock/Gp  (#340965) | 100 | 52
 |  | DELOITTE/GLOBAL/GP |  |  |  |  |  |  |  | Bloomberg Financial Markets/Global/Gp  (#266027) | 3500 | 3000
 |  | ROPES AND GRAY/SP |  |  |  |  |  |  |  | [NAME]  (#91481) | 20 | 25
 |  |  |  |  |  |  |  |  |  | Deloitte/Global/Gp  (#7770781) | 4500 | 3500
 |  |  |  |  |  |  |  |  |  | Rolls Royce/Sp  (#298022) | 15 | 30
 |  |  |  |  |  |  |  |  |  | Ropes And Gray/Sp  (#279328) | 600 | 500
Spreadsheet: 774904d1648720925-ignore-formula-cells-in-if-blank-logic-test-is-blank-test
Sheet: Sheet2

Sku
3063001.020 | 480
2961A104SC.020
753AA101.020 | 216
3063001.020
4061128.020 | 91
1640315.020
0355012.020 | 5
2234001.020 | 40
1610.001
18SB.9301800T.075 | 75
4061813.020 | 120
3251A101.020 | 86
0476028.020
3075000.020
753AA101.020 | 175
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Ice Usage

Team | Fall/Winter |  |  | Spring
 | Blocks | Hours | Billed Hours | Blocks | Hours | Billed Hours
05 [NAME] | 0 | 0 |  | 0 | 0
04 Flags | 2 | 1 |  | 0 | 0
03 [NAME] | 4 | 2 |  | 0 | 0
02 Flags | 2 | 1 |  | 0 | 0
01 Flags | 4 | 2 |  | 0 | 0
00 Flags | 6 | 3 |  | 0 | 0
99 Flags | 0 | 0 |  | 0 | 0
98 Flags | 6 | 3 |  | 0 | 0
Midget A | 0 | 0 |  | 0 | 0
Midget AA | 3 | 1.5 |  | 0 | 0
High School Practice | 0 | 0
Falcons Practice | 0 | 0
[NAME] | 0 | 0
[NAME] | 0 | 0
[NAME] | 0 | 0
[NAME] | 0 | 0 |  | 1. You have Sept 1st - March 16th to use this ice. If you don’t use it you lose it.
Mens Sunday | 0 | 0 |  | You will still be billed for what is in the billed hours column to the left.
Mens Tuesday | 0 | 0
Mens Wednesday | 0 | 0 |  | 2. Bills will be sent out the 1st of the month. They are due by the 10th of the month.
H-CATS | 0 | 0 |  | They are past due by the 15th and you start losing ice.
H-MANZ TOUR | 0 | 0
Thanksgiving Tourney | 0 | 0 |  | 3. PLEASE DOUBLE CHECK EVERYTHING. CALCULATE YOUR HOURS AND MAKE SURE
Festival Of Trees | 0 | 0 |  | YOUR HOURS ADD UP TO WHAT I SHOW TO THE LEFT.
Learn to Skate | 0 | 0
U8 | 0 | 0 |  | 4. New this year you will be billed over 6 months vs the 7 months PHMHA has done in the past.
Mite House 1 | 0 | 0
Mite House 2 | 0 | 0
Mite House 3 | 0 | 0
Squirt House 1 | 0 | 0
Squirt House 2 | 0 | 0
PeeWee House 1 | 0 | 0
[NAME] 1 | 0 | 0
Spreadsheet: phillip_allen__29456__Phillip Allen Muni Bond Proposal
Sheet: Brief

 |  |  | Portfolio Profile |  |  |  |  |  |  |  |  |  |  |  | Settlement:
Prepared for: | Date
Summary
 |  |  | *  [NAME] a ______combined effective Federal and _____ State income tax bracket and that all bonds are free from both federal and state income tax . However certain states (Illinois, Iowa, Oklahoma,
 |  |  | and Wisconsin) generally tax the interest from in-state bonds, therefore the taxable equivalents for those states assume a bond exempt only from federal taxes. Intangible taxes are not considered.
Projected Annual Income Distribution |  |  |  |  |  |  |  |  |  | Maturity Profile
This proposal represents one potential scenario based on our understanding of your investment objectives and constraints. The actual portfolio that you choose may differ.  Bids/Offerings are subject to change and/or availability and should
not be considered as an offer to sell any issue.  PaineWebber Incorporated and/or Mitchell Hutchins Asset Management Inc. affiliated  companies and/or their officers, directors, employees or stockholders may at times have a position in the
securities described herein. Please contact your tax advisor regarding suitability of   tax-exempt securities investments for your portfolio. Income from municipal bonds may be subject to state and  local taxes as well as the Alternative Minimum Tax.
Municipal securities are subject to gains/losses based on the level of interest rates, market conditions and credit quality of the issuer.  Zero coupon securities are more volatile than interest bearing securities.
Spreadsheet: 36826d1234795736-tricky-form-design-vlookup-with-options
Sheet: List

test1 | 2 | 8 | 1st | 10
test2 | 3 | 7 | 2nd | 20
test3 | 2 | 6 | 3rd | 30
test4 | 3 | 5 | 4th | 40
test5 | 2 | 4 | 5th | 50
test6 | 3 | 3 | 6th | 60
[NAME] | 2 | 2 | 7th | 70
test8 | 1 | 1 | 8th | 80
Spreadsheet: 188466d1350901251-help-calculating-avg-growth-rate-growth
Sheet: Sheet1

month 11\01 | 4.884
month 11\02 | 5.108
month 11\03 | 4.204
month 11\04 | 4.927
month 11\05 | 4.923
month 11\06 | 4.4
month 11\07 | 4.472
month 11\08 | 8.972
month 11\09 | 7.315
month 11\10 | 7.674
month 11\11 | 8.14
month 11\12 | 7.827
month 12\01 | 8.052
month 12\02 | 7.837
month 12\03 | 7.863
month 12\04 | 7.478
month 12\05 | 6.108
month 12\06 | 6.018
month 12\07 | 7.667
month 12\08 | 11.09
month 12\09 | 10.765
month 12\10 | 12.499
Growth rate from Jan-11 to Oct 12 | 1.22359398018867 |  |  |  |  |  |  | Q: How to calculate growth rate on basis of per month, year and cumlative growth from upto Jan-11 to Oct-12
Monthly growth | 0.03878687063641273
Compund growth of 22 month | 0.85331115400108
 | 5.859925025894745
 | 6.859925025894747
 | 6.901427014511333
 | 7.013132724057915
Spreadsheet: 833961d1687360469-calculate-median-from-a-column-of-table-sample-calculate-medican-from-table
Sheet: Sheet1

Month | Time | New Goal | Previous Goal | Median
2022-01-22 00:00:00 | 2.34 | 2.75 | 3.5
2022-02-22 00:00:00 | 3.45 | 2.75 | 3.5
2022-03-22 00:00:00 | 2.48 | 2.75 | 3.5
2022-04-22 00:00:00 | 2.21 | 2.75 | 3.5
2022-05-22 00:00:00 | 3.02 | 2.75 | 3.5
2022-06-22 00:00:00 | 3.06 | 2.75 | 3.5
2022-07-22 00:00:00 | 3.11 | 2.75 | 3.5
2022-08-22 00:00:00 | 2.78 | 2.75 | 3.5
2022-09-22 00:00:00 | 2.34 | 2.75 | 3.5
2022-10-22 00:00:00 | 2.87 | 2.75 | 3.5
2022-11-22 00:00:00 | 2.98 | 2.75 | 3.5
2022-12-22 00:00:00 | 2.38 | 2.75 | 3.5
2023-01-22 00:00:00 | 2.59 | 2.75 | 3.5
2023-02-22 00:00:00 | 2.31 | 2.75 | 3.5
2023-03-22 00:00:00 | 3.42 | 2.75 | 3.5
2023-04-22 00:00:00 | 3.07 | 2.75 | 3.5
2023-05-22 00:00:00 | 3.51 | 2.75 | 3.5
2023-06-22 00:00:00 | 3.01 | 2.75 | 3.5
Spreadsheet: 853743d1703697668-formula-in-power-pivot-asking-for-pwrpvt-help
Sheet: tblfrmQRYProgramListing

ProgramID | Program | ProgramType | ProgramName | Category
1 | Day Program | Day | Day Program | Day
2 | House AAA | [NAME] | Residential Habilitation | Residential
3 | House B | [NAME] | Residential Habilitation | Residential
4 | House CC | [NAME] | Supervised Living | Apartments
Spreadsheet: 690013d1596804754-help-with-forecasting-formula-for-a-retailer-i-am-stumped-please-help-example-for-phasing-help
Sheet: Dashboard example

Key Forecast | Cateogry | Type | Group | Gender | Start week* | RID MERCH | [NAME] | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 1 | 2 | 3 | 4 | 5
 | Footwear | ENDUR | SHOES | U | 38 | 2020-09-01 00:00:00 | 1300
 | Socks | Running Socks | SOCKS | U | 41 | 2020-07-15 00:00:00 | 1154
Spreadsheet: 701050d1603482029-drag-formula-references-skipping-rows-formula-drag-example
Sheet: data

Item Summary
Spreadsheet: 107051d1304208645-if-cell-b-x-show-cell-a-example
Sheet: Original Sheet

Original Sheet
2001 |  |  | 2001-2002
NameA | (1-1) | blank | NameC | (10-3) | blank
NameB | (3-9) | blank | NameA | (11-15) | blank
NameC | (9-1) | blank | NameE | (1-7) | blank
individual names & corresponding dates stop at row 29
the same pattern follows across to column GZ (name, date, blank; name, date, blank; etc…)
the names constantly change, most are repeated at least once
Spreadsheet: 46119d1245003818-want-to-automate-the-recording-of-data-from-one-worksheet-to-another-fruitexample
Sheet: Bananas

Date | Fruit | Units | Cost
2009-02-15 00:00:00 | Bananas | 3 | 30
2009-02-15 00:00:00 | Bananas | 7 | 70
2009-02-15 00:00:00 | Bananas | 2 | 20
2009-02-16 00:00:00 | Bananas | 9 | 90
2009-02-17 00:00:00 | Bananas | 8 | 80
2009-02-18 00:00:00 | Bananas | 7 | 70
2009-02-19 00:00:00 | Bananas | 8 | 80
2009-02-21 00:00:00 | Bananas | 3 | 30
2009-02-22 00:00:00 | Bananas | 6 | 60
2009-02-22 00:00:00 | Bananas | 5 | 50
Spreadsheet: 0abe8741-6818-40ad-8401-e794e184c6de
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  |  | Travel Voucher
[NAME]'s Name:
[NAME]'s Employer Identification Number
Itemized Expenses
Date |  |  |  |  |  |  |  |  |  | Total
Lodging |  |  |  |  |  |  |  |  |  | 0
Food
Breakfast
Lunch
Dinner
Other Food
Other Food
Other Food
Subtotal | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Food Reimbursed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Transportation
Registration fees
Vehicle Rental |  |  |  |  |  |  |  |  |  | 0
Other Expenses |  |  |  |  |  |  |  |  |  | 0
Taxi/shuttle |  |  |  |  |  |  |  |  |  | 0
Parking |  |  |  |  |  |  |  |  |  | 0
Total |  |  |  |  |  |  |  |  |  | 0
Original receipts are required for all itemized expenses.  Any changes or strikeouts must be initialed.  Commodity Code:  T0100
Per Diem |  |  | Days at $ |  | + |  | Hours at |  | = | 0
Date and Time of Departure |  |  |  |  | Date and Time of Return
Mileage |  |  |  |  |  | Miles at $ | 0.32 | Per Mile | = | 0
Total Amount to be Reimbursed = |  |  |  |  |  |  |  |  |  | 0
Cost Account: |  |  | Amount: | 0 | Cost Account: |  |  |  | Amount: | 0
I certify that this accounting is  just and true to the best of my knowledge.
Submitted By: |  |  |  |  | Approved By:
 | Traveler |  |  |  |  |  |  | Vice President/President
Approved By: |  |  |  |  | Pre-Audit By:
 | [NAME]/Director/Supervisor
Approved By: |  |  |  |  |  |  |  | Travel Request Number
 | Control Agent
Spreadsheet: 100034d1298511934-count-occurences-of-y-and-put-value-into-table2-flash-sample
Sheet: Sheet1

Analyst: | Client Name | Amount: | Compl'd (Y or N)
Seamus | [NAME] | 37815 | Y
[NAME] | [NAME] | 30358 | Y
[NAME] | [NAME] | 11503.72 | Y
Seamus | [NAME] | 12085.39 | Y
[NAME] | [NAME] | 24220.72 | N
Nathan | [NAME] | 25727.48 | Y
Seamus | [NAME] | 13890.32 | Y
[NAME] | August Alden | 22323.43 | Y
[NAME] | [NAME] | 5234.32 | Y
[NAME] | [NAME] | 10398.99 | Y
[NAME] | [NAME] | 32509.02 | N
 | TOTAL
 | Individual Totals | Number of deals | Total Debt
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Nathan
 | Seamus
 | Totals
 | COMPLIED | Number of complied deals | Total compl'd debt
 | [NAME]
 | [NAME]
 | Dennis
 | [NAME]
 | [NAME]
 | Nathan
 | Seamus
Spreadsheet: c6c92bf5-d9b9-4165-94f2-3a7d401374e3
Sheet: PAG 8 - Table 1

Ambev Brazil results |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | 4Q10 | Scope |  |  | 4Q11 | Reported | Organic
Volume ('000 hl) | 33298.80173699769 | 0 | 0 | 154.4110263913753 | 33453.21276338906 | 0.00463713462156834 | 0.004637134621568442
Net revenue | 5275.001000000001 | 0 | 0 | 498.5039999999999 | 5773.505000000001 | 0.09450311004680367 | 0.09450311004680374
Net revenue/hl | 158.4141387928397 | 0 | 0 | 14.1703313695742 | 172.5844701624138 | 0.0894511782695413 | 0.08945117826954156
[NAME] | -1673.72 | 61.943 | 0 | -2.549999999999976 | -1614.327 | -0.0354856248356954 | 0.001515420743197975
[NAME]/hl | -50.26367054344662 | 1.860217087967342 | 0 | 0.1471914510505954 | -48.25626200442867 | -0.03993756359840039 | -0.00291275689853086
Gross profit | 3601.281000000001 | 61.943 | 0 | 495.954 | 4159.178000000002 | 0.1549162645180979 | 0.1380602956323246
Gross margin | 0.6827071691550392 | 0 | 0 | 0 | 0.7203904733779569 | 380 | 270
SG&A excl. deprec.&amort. | -1242.318 | 0 | 0 | -44.34600000000023 | -1286.664 | 0.03569617440945083 | 0.03569617440945091
SG&A deprec.&amort. | -157.865 | 41.80499999999999 | 0 | 10.52600000000001 | -105.534 | -0.3314920976783962 | -0.07567326633021332
SG&A total | -1400.183 | 41.80499999999999 | 0 | -33.81999999999964 | -1392.198 | -0.005702825987746185 | 0.0244821255870785
Other operating income | 256.294 | -125.996 | 0 | 179.1330000000001 | 309.4310000000001 | 0.2073283026524231 | 1.374794701376844
Normalized EBIT | 2457.392000000001 | -22.248 | 0 | 641.2670000000004 | 3076.411000000002 | 0.2519007956402564 | 0.2739073681584773
Normalized EBIT margin | 0.4658562150035612 | 0 | 0 | 0 | 0.5328498026761909 | 670 | 730
Normalized EBITDA | 2826.825 | -125.996 | 0 | 629.6459999999992 | 3330.474999999999 | 0.1781680861036672 | 0.2331306424805122
Normalized EBITDA margin | 0.5358908936699727 | 0 | 0 | 0 | 0.5768549607214333 | 410 | 650
Spreadsheet: 788078d1658249770-total-with-maximum-limit-cap-book1
Sheet: Sheet1

5 | 3 | 5
4 | 3 | 1
0.34
0.0055
0.75
Spreadsheet: 814167d1674201221-if-b5-b128-contain-words-sum-left-hand-side-value-of-those-ask
Sheet: 代造

DEBIT NOTE (分判商扣款通知)
地 盤 名 稱  : |  | 青衣青康路北一期及二期 |  |  |  | Our Outgoing Reference 信件編號  : | CSHK/BJH/G56/2022/10795
To 致 | : | [NAME] |  |  |  | Debit Note Reference 扣款書編號  : | 425
Attn. 啟 | : | 孫健均 |  |  |  | Date  日 期  : | 2022-12-28 00:00:00
 |  |  |  |  |  | Reference Correspondence 參考文件  : | CSHK/BJH/G56/2022/10411
 |  |  |  |  |  | By Fax To 傳真到 :
 |  |  |  |  |  | By Hand / By Mail 親遞 /  郵寄 : | By Hand
Subcontract : |  | #N/A
分判工程合約
In accordance with the Subcontract Clauses, we hereby inform you that an net amount |  |  |  |  |  | 0
which will be deducted in your forthcoming payment account.
現發此分判商扣款通知書給貴公司, 根據分判合約細則將會向貴號來月之中期/尾期糧款內扣除金額 港幣 |  |  |  |  |  |  | 0
Item(項目) |  | Description | (工作描述) | Unit (單位) | Quantity(數量) | Unit Rate(單價) | Amount | (金額HK$)
1 |  | 元大張波違規吸煙事宜 (第二次違反) |  | 單 | 1 | 0 | 0
2 |  | 行政費15% |  | 單 | 1 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Total (HK$) = |  | 0
The deduction or set off will not relieve you any liability of the Subcontract.
有關是次代做所引起之損失, 我公司將按合約細則, 會於貴號來月之糧款內扣除。 但貴號仍需履行所有合約內之
工作及責任。
For and on behalf of CSHK |  |  |  |  |  | For and on behalf of CSHK
Deputy Site Manager / Project Quantity Surveyor |  |  |  |  |  | Site Manager / Project Manager
Encl. as stated (抄送)
1) |  | Q.S.
Remark: | Objection raises after 3 working days of this debit note issued in any reason will not be entertained (Unwritten objection is not accepted)
 | 此扣款書若發出後 3 個工作天仍未收到書面反對則當同意扣款論
Spreadsheet: 751566d1634182283-nested-if-with-multiple-criteria-if_to_check_due_how_many_days
Sheet: Sheet1

 |  | Date | Actual Date | Target (7 days) | Due? | Due how many days?
 |  | 2021-01-01 00:00:00 | 2021-01-05 00:00:00 |  |  |  |  |  |  | =IF(D4>E4,"Due",IF(E4<TODAY(),"Overdue",""))
 |  | 2021-02-01 00:00:00 | 2021-02-10 00:00:00
 |  | 2021-03-01 00:00:00
Spreadsheet: 849290d1699819780-repeat-a-formula-x-times-dynamic-and-automatic-change-leader
Sheet: Input Sheet

This [NAME] looks far more complex that it actually is, I have colour coded the heading to make it easier to understand.
Green = Pasted/ typed data (no formulas)
Yellow = [NAME] I'm looking to turn into automatic dynamic
Red = Helper columns for column F
Orange = Automatic dynamic
This sheet produces data in the 'File to Save' Sheet which is used by another program to update certain names to a new leader. (In this example moving them to Troy's Team)
Pasted Name List | Pasted Position | Leader For Name List | Typed Name (or Partial Name) | Name in Full From Column A | Details of Typed Names | Already With Troy Helper | Duplicate Below This Row | Duplicate Above This Row | [NAME] | Blank in Column A Helper | Column Blank For 'K2' onwards | Names to Process | Current Group | Move To Troy
[NAME] | Leader |  | [NAME]
[NAME] | Member 1 | [NAME] | [NAME] | [NAME] |  | False |  |  | False | False |  | [NAME] | [NAME] | Troy
[NAME] | Member 2 | [NAME] | [NAME] | Sandy |  | False |  |  | False | False |  | Sandy | Sandy | Troy
Sandy | Leader | Sandy | Jo | Joy |  | False |  |  | False | False |  | Joy | Mark | Troy
Troy | Leader | Troy | [NAME] | Winston |  | False |  |  | False | False |  | Winston | Mark | Troy
[NAME] | Member 1 | Troy | [NAME] | [NAME] |  | False |  |  | False | False |  |  | [NAME] | Troy
Dwane | Member 2 | Troy | Winston | Winston |  | False |  |  | False | False |  |  | Mark | Troy
Shona | Member 3 | Troy | Rachel | #[NAME]! |  | False |  |  | True | False |  |  | #[NAME]! | #[NAME]!
Toni | Member 4 | Troy | [NAME] | [NAME] |  | True |  |  | False | False |  |  | Troy
[NAME] | Leader | [NAME] | [NAME] | [NAME] |  | False |  |  | False | False |  | [NAME] | [NAME] | Troy
Marvin | Member 1 | [NAME] | Rachel | #[NAME]! |  | False |  |  | True | False |  |  | #[NAME]! | #[NAME]!
Mark | Leader | Mark |  |  |  | False |  |  | False | True
Joy | Member 1 | Mark |  |  |  | False |  |  | False | True
Winston | Member 2 | Mark |  |  |  | False |  |  | False | True
Bella-Anne | Leader | Bella-Anne |  |  |  | False |  |  | False | True
Spreadsheet: sally_beck__35758__MgmtSum-Q1-0313
Sheet: Summary YTD

PLAN2000 | ACTUAL |  |  |  |  |  |  | [NAME] |  |  |  |  | CAP_CHRG | TOT_OPS_EXPENSES | TOT_ALLOCATION |  |  |  |  |  |  |  |  |  | [NAME] | TOT_OPS_EXPENSES | CAP_CHRG | TOT_ALLOCATION
2000-03-01 00:00:00 | 2000-03-01 00:00:00
M.QTD | M.YTD | ENRON NORTH AMERICA
ENA |  | 4TH QUARTER 1999 EARNINGS ESTIMATE
 |  | [NAME] through Q4
 |  |  |  | Earnings Before Tax |  |  |  | Components of Earnings Before Tax |  |  |  |  |  |  |  |  |  | Variances from Plan
 |  |  |  |  |  |  |  | Actual | Deals | Forecast | Total | Operating | Capital | Direct | Allocated |  |  | Total | Operating | Capital | Direct | Allocated
 |  | Business Team |  | Estimate | Plan | [NAME] |  | Margin | Identified | Margin | Margin | Expenses | Charge | Expenses | Expenses | Total |  | Margin | Expenses | Charge | Expenses | Expenses | Total
[NAME] |  | Gas Trading
[NAME] |  | Power Trading
IR_FX |  | Interest Rate & Currency Trading
[NAME] |  | Equity Trading
CANADA |  | Canada
COAL |  | Coal
WEATHER |  | Weather
SO2 |  | Emissions
INSURANCE |  | Insurance Group |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
EXEC_TRD |  | Executive Trading
 |  | Total Trading & Risk Management
E_ORG |  | East Midstream
W_ORIG |  | West Midstream
PAPER |  | Industrial Downstream - Paper
DWNSTRM_IND_ORIG |  | Industrial Downstream - Chemicals
MDSTRM_IPP_ORIG |  | Midstream IPP
MEXICO |  | Mexico
EXEC_ORIG |  | Executive Origination
 |  | Total Origination
GENCOS |  | Genco
N_BS_DEV |  | Generation Investments
ASST_ORIG |  | Gas Assets
ASST_TRD |  | Gas Assets - Trading
 |  | Total Assets
EQUITY |  | Principal Investing
PROD_FIN |  | Upstream E&P
ENVR_ENGY |  | Asset Management
RESTRUCTURING |  | Restructuring
 |  | Canada - Investing
 |  | Total Investing
CTG |  | Commercial Transactions Group
OF_CHAIR |  | Office of the Chairman |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Total Commercial
GROUP |  | Group
TREASURY_INT |  | Other Interest Related Charges
TREASURY_INT |  | Capital Charge Offset |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
OF_CHAIR |  | Overview |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 138187
 |  | ENA EBIT
 |  | Interest Income/(Expense) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24200
 |  | [NAME]
Spreadsheet: 844371d1696113496-find-the-most-recent-occurrence-of-a-string-example
Sheet: Sheet1

2022-10-01 00:00:00 | Blue |  | 1000
2022-10-01 00:00:00 | Green |  | 1295
2022-10-05 00:00:00 | Yellow |  | 324
2022-10-05 00:00:00 | Blue |  | 609
2022-10-06 00:00:00 | Red |  | 1610
2022-10-06 00:00:00 | Yellow |  | 942
2022-10-10 00:00:00 | Blue |  | 302
2022-10-10 00:00:00 | Red |  | 1578
2022-10-10 00:00:00 | Yellow |  | 1843
2022-10-12 00:00:00 | Blue |  | 1441
2022-10-12 00:00:00 | Red |  | 427
Spreadsheet: 680468d1591037579-linking-cells-to-a-summary-new-mileage-auto-form-forum-copy
Sheet: 4.4.20

Form: Rep08.doc
Revision : 02/01/2018
SALES PERSONNAL - WEEKLY MILEAGE REPORT
Sales Persons Name: [NAME]
Vehicle Model & Registration:
Check List: | Oil | ü | Water | ü | Tyres | ü | Bodywork | ü
Week commencing date: |  |  |  |  | Opening mileage
Day | Date | Business miles |  | Private miles |  | # [NAME] purchased |  | Fuel costs £
Sat
Sun
Mon
Tue
Wed
Thu |  |  |  | 5
Fri
 |  | Total Business miles |  | Total Private miles |  | Total # [NAME] purchased |  | Total Fuel costs £
Check | Closing Mileage |  |  | 99638 |  | Expenses
 | Amount to be deducted for PRIVATE use / mileage |  |  |  |  | Fuel - PM + Expences
Signed off  &  confirmed by : |  |  |  |  |  |  | Dated:
Spreadsheet: 680204d1590855331-conditional-formatting-using-multiple-sheets-and-search-function-in-multiple-rows-and-column-example-1
Sheet: Logs

Operation # | Operator | Misc | Equipment | Misc | Misc | Misc | Misc | Misc | Misc | Misc | Misc | Misc | Misc | Misc | Misc
14 | [NAME] |  | Hyster A
13 | [NAME] |  | Hyster B |  |  | Here are the logs. This sheet is automatically edited by software so im uneazy changing the column layout, hence why im interested in conditional formatting.
12 | Alfons |  | Hyster E
11 | Raul |  | Hyster A |  |  | Every row on this sheet (Logs) is added by the software. The other sheets I feel more comfortable adding stuff outside the used up columns.
10 | [NAME] |  | Hyster A
9 | [NAME] |  | Hyster G |  |  | We have 3 sheets, "Logs","Equipment" & "Operators"
8 | Martin |  | Hyster B
7 | [NAME] |  | Hyster E
6 | [NAME] |  | Hyster A
5 | Martin |  | Hyster G
4 | [NAME] |  | Hyster G
3 | Alfons |  | Hyster E
2 | Raul |  | Hyster B
1 | Alfons |  | Hyster A