tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 675907d1588551052-detecting-schedule-conflicts-minimal-sample
Sheet: 2-Bob

 | Schedule for employee #: | 2
 |  |  |  |  |  |  |  |  | Conflict detection |  |  |  |  |  | contains the lowest Employee # besides me who is also scheduled
Customer # | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Day with first conflict
1 | 0 | 0 | 1 | 0 | 1 | 0 | 1 |  |  |  | 3 |  | 3
3 | 0 | 0 | 0 | 0 | 0 | 1 | 1 |  |  |  |  |  |  | 3 | 3
4 | 1 | 0 | 0 | 1 | 0 | 0 | 1 |  |  |  |  | 1
Spreadsheet: 34787d1232130590-values-formula-copy-of-new-order-entry-in-progress-2-
Sheet: Order Entry

 |  | Builder: |  |  |  |  |  | #N/A |  |  | Thermeq No.:
 |  |  | #N/A |  |  |  |  |  |  |  | TQ. P.O. No.:
 |  |  | #N/A |  |  |  |  |  |  |  | [NAME] No.:
 |  | Contact: | #N/A |  |  |  |  |  |  |  | Date:
 |  | Telephone: | #N/A |  |  |  |  |  |  |  | Author:
 |  | Development:
 |  | County:
 |  | Lot No.:
 |  | Address:
 |  | Date Required:
 |  | Directions:
Material Entry
Item |  | Beam |  |  | Length |  |  |  | Mat'l Cost | Mat'l Cost | Sales Price | Sales Price
No. | Qty. | Size |  |  | Ft. | In. | Primer |  | $/Lb. | Total ($) | $/Lb. | Total ($)
1 | 2 | [NAME] |  |  | 7'-11" |  | YES |  | 0.76 | 192.5333333333333 | 1.146341463414634 | 290.4065040650406
2 | 2 | [NAME] |  |  | 7'-11" |  | YES |  | 0.76 | 192.5333333333333 | 1.146341463414634 | 290.4065040650406
3 | 2 | [NAME] |  |  | 7'-11" |  | YES |  | 0.76 | 192.5333333333333 | 1.146341463414634 | 290.4065040650406
4 | 2 | [NAME] |  |  | 7'-11" |  | YES |  | 0.76 | 192.5333333333333 | 1.146341463414634 | 290.4065040650406
 |  |  |  |  |  |  |  |  |  | #N/A | 0 | #N/A
 |  |  |  |  |  |  |  |  |  | #N/A | 0 | #N/A
 |  |  |  |  |  |  |  |  |  | #N/A | 0 | #N/A
 |  |  |  |  |  |  |  |  |  | #N/A | 0 | #N/A
 | 8 |  |  |  |  |  |  |  | Labor Cost | #N/A | Totals = | #N/A
Item |  | [NAME] |  |  |  |  | Labor | Rate | Cost Each | Cost Total | Sales Price | Sales Total
No. | Qty. | Length |  |  | Size | Sch | (Hrs) | ($/Hr) | ($) | ($) | ($) | ($)
0 | 0 |  |  |  |  |  | 0.5 | 40 | 0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 |  |  | 0 | 0 | 0.5 | 40 | 0 | 0 | 0 | 0 |  | #N/A
0 | 0 | 0 |  |  | 0 | 0 | 0.5 | 40 | 0 | 0 | 0 | 0 |  | #N/A
 | 0 |  |  |  |  |  |  |  | Totals = | 0 | Totals = | 0
Item |  | Additional Work |  |  | Mat'l |  | Labor | Rate | Cost Each | Cost Total | Sales Price | Sales Total
No. | Qty. | Description |  |  | Cost |  | (Hrs) | ($/Hr) | ($) | ($) | ($) | ($)
0 | 16 | 1/4" X 4" X 4" |  |  | 0 |  |  | 40 | 0 | 0 | 0 | 0
0 | 32 | 1/8" X 4" X 4" |  |  | 0 |  |  | 40 | 0 | 0 | 0 | 0
 |  | Splice Plate |  |  | 17.25 |  | 0.25 | 40 | 0 | 0 | 0 | 0
 |  | Measure |  |  |  |  | 2 | 40 | 0 | 0 | 0 | 0
0 | 0 | Extra Work |  |  |  |  | 0 | 40 | 0 | 0 | 0 | 0
Splice Directions: |  |  |  |  |  |  |  |  | Totals = | 0 | Totals = | 0
Extra Work #1: |  |  |  |  |  |  |  |  | Material Total = | #N/A
Extra Work #2: |  |  |  |  |  |  |  |  | Labor Cost = | #N/A | Total = | #N/A
 |  |  |  |  |  |  |  |  | Total Costs = | #N/A | Margin = | 0.18
 |  |  |  |  |  |  |  |  |  |  | Labor = | 0.15
Spreadsheet: 865130d1712189338-average-the-first-10-non-zero-values-in-a-column-but-ignore-empty-cells-pool-league_2
Sheet: Players

To Add Weekly Scores: Right click on column G and click [NAME] to add a new column. Add Date and Scores in New Column "G" |  |  |  |  | a
To Add a New Player: Right Click on Row Number below the Last Player. [NAME] and [NAME], APPG and APPM cells from above player to new player.
To Arrange Players By Team: Left Click and Hold Row Number of First Player and drag to Last Player. [NAME] tab and then on Sort. Then [NAME].
Sort By "Column B", "Cell Value" and "Smallest to Largest" and click OK
Name | Team Number |  |  |  | a
 |  | Handicap | APPG | APPM | a | 2024-01-10 00:00:00 | 2024-01-09 00:00:00 | 2024-01-08 00:00:00 | 2024-01-07 00:00:00 | 2024-01-06 00:00:00 | 2024-01-05 00:00:00 | 2024-01-04 00:00:00 | 2024-01-03 00:00:00 | 2024-01-02 00:00:00 | 2024-01-01 00:00:00
 |  |  |  |  | a | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 85
 |  |  |  |  |  | 67 | 45 | 55 | 55 | 55 | 55 | 45 | 55 | 45 | 45
 |  |  |  |  | a | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 50
 |  |  |  |  | a |  |  | 24 | 23 | 54 | 65 | 45 | 45 | 47 | 53
 |  |  |  |  |  |  |  | 34 | 61 | 23 | 34 | 43 | 34 | 27 | 43
 |  |  |  |  | a |  |  | 45 | 45 | 65 | 45 | 45 | 42 | 51 | 45
 |  |  |  |  |  | 45 |  | 45 | 45 | 45 | 45 | 45
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | a
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
Spreadsheet: gstorey__12017__SITHE_Jun0101
Sheet: Summary

MTM FOR SITHE RELATED DEALS IN ENRON CANADA'S BOOKS
Note:  MTM Value is for  June 2001 forward as at June 1, 2001  (does not include June and July IM MTM)
 | USD$
With ENA |  |  | PostID's: | 1159362 | Price
Transport |  |  |  | 1159363 | Index
 |  |  |  | 1159364 | Trans fee
Sithe Fee |  |  |  | 1159364 | Sithe Fee
Transport Fee
Total |  |  | Check
The following deals in TAGG would need to be unwound:
ENA/Transport | NH1353 | VC1474 | Legs 3 thru 12
ENA | E30623 | VC1490 | [NAME] | (note only Nov 04 forward to be unwound; E34612.1 financially offsets the first few years)
ENA | E34612 | VC1494 | [NAME]
Index | E30623.4 | VC1490 | [NAME] | (note that with this unwind E34612.4 would need to be increased for the total Engage vol)
Index | E34612 | VC1494 | Leg 3
Sithe Index | E32934 | VC1495 | Leg 9
Sithe Index | EA2386 | VC1496 | Leg 1
Transport Rebook | NH1353 | VC1474 | Legs 13 thru 14
Transport Rebook | QA1354 | VC1497 | ALL | Represents the assignment of transport to ENA
Spreadsheet: d78a6f90-cfb2-4305-bff1-49286b7a3f30
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
[NAME] OF THE WOODS COLLEGE
[NAME]
DATE
FOR SERVICES AND GOODS FURNISHED TO: |  |  |  |  |  |  | BY SUPPLYING DEPARTMENT:
(DEBIT DEPARTMENT NAME) |  |  |  |  |  |  | (CREDIT DEPARTMENT NAME)
DATE AND DESCRIPTION OF ITEMS OR EXPENSES BEING TRANSFERRED OR SERVICES PROVIDED: |  |  |  |  |  |  |  |  |  |  | TOTAL COST
FUND |  | DEPARTMENT |  | GL CODE |  | RESTRICTION* |  | DEBIT AMOUNT |  | CREDIT AMOUNT
 |  |  |  |  |  |  |  |  | ( - ) |  | ( + )
*Fund field is necessary for General [NAME] transfers only. |  |  |  |  |  |  |  | TOTAL | 0
APPROVALS:
Head of Dept being billed: |  |  |  |  |  |  |  |  | Date
Office of the Controller: |  |  |  |  |  |  |  |  | IT No.
Spreadsheet: 267819d1380221024-league-standings-automatically-copy-of-dbgl
Sheet: Sheet1

DBGL 13/14
DA BOYZ GOLF LEAGUE
Players | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Total Points
White River Country Club - Nelspruit Golf Club - Sabie River Sun - Kruger Park Lodge
Player 1 | 22
Player 2 | 33
Player 3 | 11
Player 4 | 8
Player 5 | 5
Player 6 | 40
Player 7 | 12
Player 8 | 1
 | League Standings
Spreadsheet: 78794d1279110322-cell-referencing-rev-tracker-
Sheet: Summary

Region
 | Jan | Feb | Mar | Q1 | Apr | May | Jun | Q2 | H2 | Jul | Aug | Sep | Q3 | Oct | Nov | Dec | Q4 | YTD | FY
China | 7.02 | 7.25 | 6.650000000000002 | 20.92 | 8.119999999999997 |  |  | 8.119999999999997 |  |  |  |  | 0 |  |  |  | 0 | 29.04
Africa | 11.16 | 13.4 | 13.08 | 37.64 | 2.039999999999999 |  |  | 2.039999999999999 |  |  |  |  | 0 |  |  |  | 0 | 39.68
TOTAL | 18.18 | 20.65 | 19.73 | 58.56 | 10.16 | 0 | 0 | 10.16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 68.72 | 0
Spreadsheet: 838337d1690927456-pairing-variables-and-coding-the-output-sample-dataset-v4-solution-
Sheet: Sheet02

Transaction No | Customer ID | Date (DD/MM/YYYY) | Apple | Pepper | [NAME] | Blueberry | [NAME] | [NAME] | Peach | Grape |  |  | [NAME] in D2
1 | 111181 | 2021-08-20 00:00:00
2 | 111182 | 2021-08-20 00:00:00
3 | 111203 | 2021-08-23 00:00:00
4 | 111111 | 2021-08-16 00:00:00
5 | 111143 | 2021-08-13 00:00:00 |  |  |  |  |  |  |  |  |  |  | Data Legend
6 | 111112 | 2021-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | Label | Coding
7 | 111151 | 2021-08-16 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] | 1
8 | 111192 | 2021-08-22 00:00:00 |  |  |  |  |  |  |  |  |  |  | Red Apple | 2
9 | 111158 | 2021-08-17 00:00:00 |  |  |  |  |  |  |  |  |  |  | Green Pepper | 3
10 | 111111 | 2021-08-09 00:00:00 |  |  |  |  |  |  |  |  |  |  | Red Pepper | 4
11 | 111116 | 2021-08-02 00:00:00 |  |  |  |  |  |  |  |  |  |  | Orange Pepper | 5
12 | 111112 | 2021-08-17 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] | 6
13 | 111122 | 2021-08-07 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] | 7
14 | 111128 | 2021-08-10 00:00:00 |  |  |  |  |  |  |  |  |  |  | Blueberry | 8
15 | 111181 | 2021-08-21 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] | 9
16 | 111136 | 2021-08-11 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] | 10
17 | 111133 | 2021-08-20 00:00:00 |  |  |  |  |  |  |  |  |  |  | Peach | 11
18 | 111177 | 2021-08-19 00:00:00 |  |  |  |  |  |  |  |  |  |  | Grape | 12
19 | 111209 | 2021-08-28 00:00:00
20 | 111191 | 2021-08-23 00:00:00
21 | 111119 | 2021-08-05 00:00:00
22 | 111111 | 2021-08-01 00:00:00
23 | 111133 | 2021-08-11 00:00:00
24 | 111112 | 2021-08-16 00:00:00
25 | 111114 | 2021-08-02 00:00:00
26 | 111209 | 2021-08-29 00:00:00
27 | 111136 | 2021-08-11 00:00:00
28 | 111187 | 2021-08-20 00:00:00
29 | 111171 | 2021-08-19 00:00:00
30 | 111209 | 2021-08-30 00:00:00
31 | 111204 | 2021-08-23 00:00:00
32 | 111206 | 2021-08-24 00:00:00
33 | 111197 | 2021-08-22 00:00:00
34 | 111194 | 2021-08-22 00:00:00
35 | 111162 | 2021-08-18 00:00:00
36 | 111167 | 2021-08-18 00:00:00
37 | 111155 | 2021-08-17 00:00:00
38 | 111165 | 2021-08-18 00:00:00
39 | 111173 | 2021-08-19 00:00:00
40 | 111203 | 2021-08-23 00:00:00
Spreadsheet: 39993d1238265765-dynamic-list-depending-on-date-book1_mar28
Sheet: Sheet1

Item | Amount | Due
Flowers | 200 | 2009-05-11 00:00:00
[NAME] | 400 | 2009-12-05 00:00:00
Chairs | 300 | 2009-06-11 00:00:00
Cake | 200 | 2009-11-08 00:00:00
Rings | 500 | 2009-07-23 00:00:00
Caterer | 700 | 2009-10-08 00:00:00
Spreadsheet: 02e36d03-14a0-4c29-9e83-502963ef59c7
Sheet: 3-3T

 | Section 3: Cost
 | Table 3-3Trend:  Cost Per Mile - Overall by Year
 | Vehicle Type | 2009 | 2010 | 2011 | 2012 | 2013
 | Passenger Vehicles | 0.505576 | 0.604207 | 0.605157 | 0.572466 | 0.593295
 | Trucks | 0.943513 | 1.118072 | 1.032182 | 1.055686 | 1.18429
 | Other | 1.753644 | 1.941054 | 1.900534 | 1.905555 | 2.233094
 | Overall | 0.746208 | 0.88377 | 0.846257 | 0.84191 | 0.922043
Spreadsheet: 677480d1589372526-conditional-formatting-formula-rag-excel-forum
Sheet: Sheet1

Likelihood  1 - Very Low 2 - Low 3 - Medium 4 - High 5 - Very High | Impact 1 - Negligible 2 - Marginal 3 - Critical 4 - Catastrophic 5 - Unrecoverable | [NAME]
4 | 3
4 | 4
5 | 5
2 | 1
 |  |  |  |  |  |  | PMO RISK MATRIX
 |  |  |  |  |  |  |  |  | IMPACT
 |  |  |  |  |  |  |  | LIKELIHOOD | 1 | 2 | 3 | 4 | 5
 |  |  |  |  |  |  |  |  | LOW | LOW | LOW | MEDIUM | MEDIUM
 |  |  |  |  |  |  |  | 1 | 1 | 2 | 3 | 4 | 5
 |  |  |  |  |  |  |  |  | LOW | MEDIUM | MEDIUM | HIGH | HIGH
 |  |  |  |  |  |  |  | 2 | 2 | 4 | 6 | 8 | 10
 |  |  |  |  |  |  |  |  | LOW | MEDIUM | HIGH | HIGH | EXTREME
 |  |  |  |  |  |  |  | 3 | 3 | 6 | 9 | 12 | 15
 |  |  |  |  |  |  |  |  | MEDIUM | HIGH | HIGH | HIGH | EXTREME
 |  |  |  |  |  |  |  | 4 | 4 | 8 | 12 | 16 | 20
 |  |  |  |  |  |  |  |  | MEDIUM | HIGH | EXTREME | EXTREME | EXTREME
 |  |  |  |  |  |  |  | 5 | 5 | 10 | 15 | 20 | 25
Spreadsheet: 86977d1286908146-auto-populating-w-if-statements-and-a-drop-down-box-sample
Sheet: Sheet1

 |  |  |  | Price |  |  | Price
 | Option A | *Drop down box |  | If then Price of each option |  | Option A |  |  | Option A | Addition 1 | 150000
 |  |  |  |  |  | Option B |  |  |  | Addition 2 | 25000
 | If they choose option A then this appears |  |  |  |  | Option C
 | Addition 1 |  |  |  |  |  |  |  | Option B | Addition 1 | 150000
 | Addition 2 |  |  |  |  |  |  |  |  | Addition 2 | 25000
 |  |  |  |  |  |  |  |  |  | Addition 3 | 175000
 | if Option B then this appears |  |  |  |  |  |  |  |  | Addition 4 | 35000
 | Addition 1
 | Addition 2 |  |  |  |  |  |  |  | Option C | Addition 1 | 150000
 | Addition 3 |  |  |  |  |  |  |  |  | Addition 2 | 25000
 | Addition 4 |  |  |  |  |  |  |  |  | Addition 3 | 175000
 |  |  |  |  |  |  |  |  |  | Addition 4 | 35000
 | Option C then |  |  |  |  |  |  |  |  | Addition 5 | 2000
 | Addition 1 |  |  |  |  |  |  |  |  | Addition 6 | 1200
 | Addition 2
 | Addition 3
 | Addition 4
 | Addition 5
 | Addition 6
Spreadsheet: 842511d1694573502-would-like-to-list-several-cells-from-a-lookup-incl-other-data-vstack-hstack-mosom-7
Sheet: Sheet1

 |  |  |  |  | Role 1 | Role 2 | Role 3 | Role 4 | Role 5
 |  |  |  |  | x |  | x |  |  | <---- x: selceted row
Topic 1 | Module 1 | Area 1 | Focus 1 |  | Yes | Yes | Yes | Yes | No
Topic 1 | Module 1 | Area 1 |  |  | No | Yes | Yes | No | No
Topic 1 | Module 1 | Area 1 |  |  | N/A | N/A | No | No | Yes |  |  |  |  | Module 1 | Area 1 | Focus 1 | y
Topic 1 | Module 1 | Area 2 | Focus 1 |  | Yes | Yes | No | No | Yes |  |  |  | Topic 1 | Module 1 | Area 1 |  | y
Topic 1 | Module 1 | Area 2 | Focus 2 |  | No | N/A | Yes | Yes | No |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 1 | y
Topic 1 | Module 2 | Area 1 | Focus 1 |  | Yes | No | No | Yes | Yes |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 2 | y
Topic 1 | Module 2 | Area 1 | Focus 2 |  | N/A | No | Yes | Yes | Yes |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 1 | y
Topic 1 | Module 2 | Area 2 | Focus 1 |  | N/A | Yes | Yes | Yes | No |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 2 | y
Topic 1 | Module 2 | Area 3 | Focus 1 |  | No | Yes | Yes | Yes | No |  |  |  | Topic 1 | Module 2 | Area 2 | Focus 1 | y
Topic 1 | Module 2 | Area 3 | Focus 2 |  | Yes | N/A | Yes | No | Yes |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 1 | y
 |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 2 | y
 |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 |  | n
Spreadsheet: 150387d1334498229-average-lowest-4-cells-of-most-recent-8-cells-to-right-avg-of-lowest-4-recent-value
Sheet: Sheet1

 | 2012-01-01 00:00:00
name1 | 77.5 | 80 | 76 | 86 | 79 | 78 | 77 | 85 | 90 | 74
[NAME]
name3
Spreadsheet: 707298d1607159208-formula-to-breakdown-time-into-half-hour-segments-sample
Sheet: Sheet1

What I Have
 |  |  | 09:00:00
 |  |  | 15:00:00
 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00
What I Want
 |  |  | 09:00:00 |  | 10:00:00
 |  |  | 15:00:00 |  | 14:00:00
 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00
 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1
Spreadsheet: 734677d1622379793-filter-formula-excel-365-filter-formula
Sheet: Sheet1

T
Sales By Region |  |  |  |  |  | Sales greater than 10000 |  |  |  |  |  |  |  |  | January | Asia
Date | Name | Region | Sales |  |  | Name | Region | Sales |  |  |  |  |  |  | February | Canada
2021-01-01 00:00:00 | [NAME] | US | 11020 |  |  |  | US | 19534 |  |  |  |  |  |  |  | Brazil
2021-01-02 00:00:00 | [NAME] | Canada | 18385 |  |  | [NAME] | Canada | 18385 |  |  |  |  |  |  |  | US
2021-02-03 00:00:00 | Greg | US | 19534 |  |  | Sheen | US | 14552
2021-01-04 00:00:00 | Sheen | US | 14552 |  |  | Barb | Brazil | 11958
2021-02-01 00:00:00 | [NAME] | Asia | 11932 |  |  | [NAME] | Asia | 11932
2021-02-02 00:00:00 | [NAME] | US | 5306 |  |  | [NAME] | US | 11020
2021-01-03 00:00:00 | [NAME] | Asia | 8815 |  |  | [NAME] | Asia | 10396
2021-02-04 00:00:00 | [NAME] | Asia | 10396
2021-01-30 00:00:00 | [NAME] | Canada | 7763
2021-02-28 00:00:00 | Barb | Brazil | 11958
I am kindly asking for Filter [NAME] to produce monthly sales and monthly sales by Region using information on Sales by Region (A3:D13)
Note that C18 and H18 are a drop down list
Desired Solution |  |  |  |  |  | Desired Solution
Month |  | January |  |  |  | Region | US
Monthly sales |  |  |  |  |  | Monthly sales by Region
Date | Name | Region | Sales |  |  | Date | Name | Region | Sales
 | [NAME] | US | 11020 |  |  |  | [NAME] | US | 11020
2021-01-02 00:00:00 | [NAME] | Canada | 18385 |  |  | 2021-01-04 00:00:00 | Sheen | US | 14552
2021-01-04 00:00:00 | Sheen | US | 14552
2021-01-03 00:00:00 | [NAME] | Asia | 8815
2021-01-30 00:00:00 | [NAME] | Canada | 7763
Spreadsheet: 69944d1270602493-creating-a-search-list-in-excel-sample-sheet
Sheet: Comp Code

Component Code | Component Code Description
1000 | ENGINE
1001 | ENGINE & TRANSMISSION
1002 | POWER PACK
1003 | ENG & TC/TORQUE DIVIDER
1004 | ENGINE, TC & TRANSMISSION
1005 | ENG, TRAN, & TANDEM DR
1006 | ENG, TC, TRANS & TFR GRS
1007 | ENGINE & FLYWHEEL CLUTCH
1008 | ENGINE & TRANSFER GEARS
1009 | ENG, TC, TFR GRS & RTDR
1010 | ENG, TRANS, TG & RTDR
1011 | ENGINE, CLUTCH & TRANS
1012 | ENGINE & HST
Spreadsheet: 375701d1423289774-function-to-change-formulas-choose-different-sheet-through-button-excelquestion
Sheet: Budget Summary

Budget Summary
 | Projected Monthly Income |  |  | Projected Monthly Expenses
 | Income 1
 | Income 2 | 0
 | Extra income | 0
 | Total income
 | Actual Monthly Income |  |  | Actual Monthly Expenses
 | Income 1
 | Income 2 | 0
 | Extra income | 0 |  | Actual Exp - monthly fcb |  | Money Left
 | Total income
 | Balance (income - expenses)
 | Projected Balance
 | Actual Balance
 | Difference
Expense Overview
 | Category | Projected Cost | Actual Cost | Difference | Actual Cost Ranking
 | Entertainment
 | Food |  |  |  |  | food2:
 | Gifts and Charity
 | Housing
 | Insurance
 | Loans
 | Personal Care
 | Pets
 | Savings or Investments
 | Taxes
 | Transportation
Spreadsheet: 726828d1617514453-listing-different-combinations-available-from-3-lists-example-25-ans
Sheet: Sheet1

 | Scenario |  |  |  |  |  |  |  |  | Responsible Sector | Program Inventory | Measure
 |  | Responsible Sector | Program Inventory | Measure
 |  | Canadian Forest Service | Forest Sector Competitiveness | Measure 1
 |  | Low Carbon Energy Sector | Lower Carbon Transportation | Measure 2
 |  | Low Carbon Energy Sector | Lower Carbon Transportation | Measure 2
 |  | Canadian Forest Service | Forest Sector Competitiveness | Measure 1
 |  | Low Carbon Energy Sector | Lower Carbon Transportation | Measure 2
 |  | Canadian Forest Service | Forest Sector Competitiveness | Measure 1
 |  | Canadian Forest Service | Forest Sector Competitiveness | Measure 1
 | End Result
 |  | Canadian Forest Service | Forest Sector Competitiveness | Measure 1
 |  | Low Carbon Energy Sector | Lower Carbon Transportation | Measure 2
Spreadsheet: f3703712-1433-4375-b038-db805f51a3dd
Sheet: 11a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis | 464 |  | 464
 | FRA | 8730 |  | 8730
 | Exotic
 | Inflation
 | IRS- [NAME] | 26926 |  | 26926
 | OIS | 1696 |  | 1696
 | VNS | 104 |  | 104
 | Zero Coupon | 164 |  | 164
With Optionality | Callable Swap
 | Cap/Floor
 | Debt Option
 | Exotic Option
 | Swaption
Cross-Currency | Exotic
 | Swap
TOTAL |  | 38084 | N/A*** | 38084
Estimated swap transaction volumes, week ending August 9, by product type and tenor (number of trades), all participant types and currencies.
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 Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: daren_farmer__5284__buydef
Sheet: Sheet1

BUYBACK & DEFICIENCY DEALS
 |  |  |  | Buyback | Type
Counterparty | Undertake | Sale | Swing | K # | of deal | Term | [NAME] | VM
AirProducts, Inc. | 414092 | 414025 | 414090 | 96023739 | Deficiency | 10/00-9/01 | 1418
BASF Corporation | 133000 | 120266 | 122310 | 96022419 | Buyback | 11/1/99-10/31/01 | 1437
Beaumont Methanol Limited Partnership | 696599 | 696585 | 696594 | 96000279 | Buyback | April | 1428
Chevron Phillips Chemical | 413472 | 413447 | 413462 |  | Buyback | 10/00-9/01 | 1024
[NAME] | 544392 |  | 544388 | 96018826 | Buyback | 1/1/01-12/31/01 | 8216 | Fred
Enron Methanol Co | 544402 |  | 544395 | 96018827 | Buyback | 1/1/01-12/31/01 | 8291 | Fred
Equistar Chemicals LP | 586534 |  | 586537 | 96000240 | Buyback | 2/01-5/01 | 1552, 1373, 1553, 1334, 1399, 1062, 1384 | [NAME]
Formosa Hydrocarbons | 487064 | 446661 |  |  | Buyback | 11/00-10/01 | 1000, 1383
Global Octanes Texas LP | 373580 | 276461 | 373590 | 96019673 | Deficiency | 9/00-8/01 | 1528 | Thu
Lyondell-Citgo | 542915 | 542893 |  | 96008792 | Buyback | 1/1/01-12/31/01 | 1063
Marathon-Ashland | 513826 | 454436 |  | 96019644 | Buyback | 12/00-11/01 | 1431
Mobil Oil Corp. | 586400 | 538950 | 413351 | 96055715 | Buyback | 11/00-9/02 | 1040
Petrofina Gas Pipeline | 695692 |  | 695702 | 96019331 | Buyback | 4/01-10/01 | 1484
Rohm & Haas | 703325 | 703318 |  | 96019546 | Buyback | April | 1506 | Thu
Rohm & Haas | 752864 | 752860 |  | 96019546 | Buyback | May | 1506 | Thu
Shell Oil Company | 359274 | 284905 |  | 96019720 | Buyback | 7/00-6/01 | 1095, 1060, 1581, 1061
Union Carbide | 63576 | 15765 | 34825 | 96019676 | Deficiency | 2/1/99-12/31/01 | 1308 | [NAME]….ENA
Union Carbide | 63573 |  | 34832 | 96019676 | Deficiency | 1/1/00-12/31/01 | 1332 | Fred….ENA
Union Carbide |  | 699730 |  | 96019676 | Deficiency | April | 1332 | Fred….ENA
Valero Marketing & Supply | 478227 | 454447 |  | 96023591 | Buyback | 11/00-4/01 | 1394
Valero Marketing & Supply | 478229 | 454452 |  | 96023591 | Buyback | 11/00-4/01 | 1233
Valero Marketing & Supply | 478230 | 454455 |  | 96023591 | Buyback | 11/00-4/01 | 8018
Westvaco | 692934 | 692912 |  |  | Buyback | April | 1020
Westvaco | 749832 | 692912 |  |  | Buyback | 5/01-8/04 | 1020
 |  |  |  |  |  |  |  |  | ENA
 |  |  |  |  |  |  |  |  | ENA
Spreadsheet: 116038d1311529452-if-then-change_example
Sheet: Sheet1

Overview |  |  |  |  |  |  | Surplus | Revenue
Revenue | -200 |  |  |  |  |  | 600 | 500
Surplus | 1700 |  |  |  |  |  | 500 | 200
 |  |  |  |  |  |  | 200 | 600
 |  |  |  |  |  |  | 400 | 300
 |  |  |  |  |  |  |  | -500
 |  |  |  |  |  |  |  | -200
 |  |  |  |  |  |  |  | -600
 |  |  |  |  |  |  |  | -400
When the "Revenu" drops below 0, I'd like for the "Surplus" to transfer funds into Revenue to bring Revenue to 0
How would I get the macro to function in this worksheet?
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 10b

Product1 | USD | EUR3 | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Cross-Currency Basis | 9743324 | 2274997 | 593644 | 870499 | 583132 | 144448 | 391882 | 14601927
Cross-Currency Fixed-Fixed | 179536 | 74887 | 61893 | 34677 | 8966 | 27250 | 33946 | 421156
Cross-Currency Fixed-Float | 352554 | 163867 | 44878 | 64708 | 50644 | 15704 | 611702 | 1304057
TOTAL
Spreadsheet: 729822d1619370189-unique-alphabetical-list-uni
Sheet: DESTINAZIONE

 |  | TITOLO 2