tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 883438d1732062044-sort-wbs-code-with-multiple-levels-wbs-example-1-
Sheet: Sheet1

code | wbs
1.1
1.1.1
1.2
1.3
1.4
1.4
1.5
1.6
1.7
1.8
1.9
2.1
2.1
2.2.1
2.2.1
2.2.2
2.2.3
2.2.3
2.2.3
2.3
2.3.1
2.3.1.1
2.3.1.2
2.3.1.2
2.3.1.3
2.3.1.4
2.3.1.5
2.3.1.6
2.3.1.7
2.3.2
2.3.2
2.3.2
2.4
2.4
2.5
2.5
2.5
2.6
2.6
2.7
2.7
2.8
2.8
3.1.1
3.2.1
3.2.2
3.2.2
3.2.2
3.3.1
3.3.1
3.3.1
3.3.1
3.3.1
3.3.2
3.3.2
3.3.2
3.4.1
3.4.1
3.4.2
3.5.1
3.5.2
3.5.3
3.5.3
3.5.4
3.5.4
3.5.4
3.5.5
3.5.6
3.5.6
3.5.6
3.5.6
3.5.6
3.5.6
3.5.6
3.5.6
3.5.6
3.5.6
3.5.6
3.5.6
3.5.7
3.5.7
3.5.8
3.5.9
3.6.1
3.6.1
3.6.2
3.6.2
3.6.2
3.6.2
3.6.2
3.6.2
3.6.2
3.6.2
3.6.3
3.6.3
3.6.4
3.6.4
3.6.4
3.6.4
3.6.4
3.6.4
3.6.4
3.7.1
3.7.2
3.7.3
3.8.1
3.8.1
3.9.1
3.9.1
3.9.2
3.9.3
3.9.4
3.9.4
3.9.4
3.9.5
3.9.5
3.9.6
3.9.6
3.9.6
4.1
4.3.1
4.3.1
4.3.1
4.3.1
4.3.1
4.3.1
4.3.1
4.3.1
4.3.1
4.3.2
4.3.2
4.3.2
4.3.2
4.3.3
4.3.3.1
4.4
4.5.1
4.5.2
4.5.2
4.5.2
4.5.2.2
4.5.2.2
4.5.2.2
4.5.2.2
4.5.3
4.5.3
4.5.4
4.5.5
4.6
4.6
4.6
4.6
4.6
4.6
4.6
4.6
4.6.2
4.6.2
4.6.2
4.6.2
4.6.2
4.6.2
4.6.2
4.7
4.7
4.7.1
4.8
4.8
4.8
4.9.1
4.9.2
4.9.2
4.9.2
4.9.3.1
4.9.3.1
4.9.3.2
4.9.3.3
4.9.3.4
4.9.4
4.9.5
4.9.5.1
4.9.5.1
4.9.6
4.9.6.1
4.9.6.2
4.9.6.3
4.9.6.4
1.11 | {=0+(TRIM(SUBSTITUTE(A190,".",""))&REPT(0,10-(LEN(A190)-LEN(SUBSTITUTE(A190,".","")))))}
1.12
3.10.1
3.10.1
3.10.1
3.10.1
3.10.2
3.10.2
3.10.2
3.5.10
3.5.11
3.5.12
3.5.12
3.5.12
3.5.13
3.5.14
3.5.15
3.5.15
3.5.16
3.5.17
3.5.17
3.5.17
3.5.18
3.5.18
3.5.19
3.5.19
3.5.19
3.5.20
3.5.20
3.5.20
3.5.20
3.5.20
3.5.21
3.5.22
3.5.22
3.5.22
3.5.23
3.5.24
3.5.25
4.10.1
4.10.1
4.10.1
4.10.2
4.10.2
4.10.2.1
4.10.2.1
4.10.2.1
4.10.2.2
4.10.2.4
4.10.2.4
4.10.2.4
4.10.2.4
4.10.3.1
4.10.3.1
4.10.3.1
4.10.3.1
4.10.3.2
4.10.3.3
4.10.3.3
4.10.3.3
4.10.3.3
4.11.0
4.11.0
4.11.0
4.12
4.12
4.12
4.13.1
4.13.1
4.13.1
4.13.1
4.13.1
4.13.1
4.13.1.1
4.13.1.2
4.13.1.3
4.13.1.4
4.13.1.5
4.13.1.6
4.13.2.1
4.13.2.2
4.13.2.3
4.13.2.4
4.13.2.5
4.13.2.6
4.13.3
4.13.3
4.13.3
4.13.3
4.14
4.15
4.15
4.15
4.15
4.15
4.16
4.16
4.17
4.18
4.18
4.19
4.19
4.20
4.21
4.22
4.23
4.23
4.23
1.011
1.1a
2.3a
2.5a
4.2a
4.2a
4.2a
4.2a
4.2a
4.2a
4.9.1a
4.13.1a
Spreadsheet: michelle_lokay__26648__available money for demand fees 05_2001
Sheet: 06.01

Market as of 06/04/01  - California -SoCal Basis
 | mid-market basis bids at Needles |  | fuel cost at $4.00 | margin after fuel (can be demand fee)
2002-06-01 00:00:00 | 1
2002-07-01 00:00:00 | 1.2
2002-08-01 00:00:00 | 1.2
2002-09-01 00:00:00 | 1.2
2002-10-01 00:00:00 | 1
2002-11-01 00:00:00 | 1.07
2002-12-01 00:00:00 | 1.07 |  |  |  |  | 7
Jan-dec 03 | 0.42 |  |  |  |  | 12
Jan-dec 04 | 0.35 |  |  |  |  | 12
Jan-dec 05 | 0.32 |  |  |  |  | 12
 |  |  |  | Total number of months
 |  |  |  | Rate we can pay
** Assumption is that TW-Permian basis is 0.  Market ranges between -.02 to 0.
Spreadsheet: eric_saibi__9730__011002R
Sheet: Colbert 05

Owner Name |  | TVA
Station Name |  | Colbert Power Station
Unit Name |  | Colbert 05
NERC Region |  | SERC
State |  | AL
Fuel Type |  | Coal
Capacity |  | 550 MW
Start Date |  | 2002-01-09 00:00:00
End Date |  | 2002-03-09 00:00:00
Prv. Start Date |  | 2002-01-17 00:00:00
Prv. End Date |  | 2002-02-27 00:00:00
Comments |  | The outage started early due to an electrical fire, so they went ahead and kept the unit down.
SIC |  | 4911
Plant ID |  | 1018346
Unit ID |  | 1003699
Outage ID |  | 19191
Spreadsheet: 697361d1601321626-auto-fill-cells-from-data-from-another-sheet-test
Sheet: Sheet2

Store
1 | CA | Los Angeles
2 | MT | Bozeman
3 | UT | [NAME]
4 | WA | Spokane
5 | MT | Billings
6 | PA | Philadelphia
7 | TX | Dallas
8 | CO | Denver
9 | NV | Las Vegas
10 | OR | Portland
11 | TN | Nashville
12 | ID | [NAME]
13 | IL | Chicago
14 | WY | Casper
15 | NM | Albuquerque
Spreadsheet: jeffrey_a_shankman__13918__Pick Sheet - Week 17
Sheet: Week 5

NFL PICKS OF THE WEEK - 2001
Name:
Phone Number where we can reach you on Sunday morning:
Last Person Standing Team Pick:
SEND TO:   E-mail - [EMAIL] |  |  |  | Phone - (707) 255-4813 |  |  | Fax - (707) 255-4832
WEEK 5  - First Game is Sunday @ 10 a.m.
Sunday, October 7
 |  | Visitor |  |  |  | Home
 |  | Chicago Bears |  |  |  | Atlanta Falcons
 |  | San Diego Chargers |  |  |  | [NAME]
 |  | New England Patriots |  |  |  | [NAME]
 |  | Minnesota Vikings |  |  |  | New Orleans Saints
 |  | Washington Redskins |  |  |  | New York Giants
 |  | Arizona Cardinals |  |  |  | Philadelphia Eagles
 |  | Cincinnati Bengals |  |  |  | Pittsburgh Steelers
 |  | Tennessee Titans |  |  |  | Baltimore Ravens
 |  | New York Jets |  |  |  | Buffalo Bills
 |  | Kansas City Chiefs |  |  |  | Denver Broncos
 |  | [NAME] |  |  |  | [NAME]
 |  | Green Bay Packers |  |  |  | Tampa Bay Buccaneers
 |  | Carolina Panthers |  |  |  | San Francisco 49er's
Monday, October 8
 |  | St. Louis Rams |  |  |  | Detroit Lions
Tiebreaker |  |  |  | Total |  |  | Total should = 119
Entries must be received by the beginning of the first game of the week (earlier is perfectly ok!)
Always start by giving the team that you think is most likely to win 15 points and go down from there.
If there are only 14 games in a week, your lowest pick will be "2" instead of "1"
Bye Week: | Dallas Cowboys
 | Indianapolis Colts
 | Oakland Raiders
Spreadsheet: 147206d1332595512-how-to-use-rank-function-with-two-reference-ranking
Sheet: Ranking

 | Product A | Product B | Product C | Product D | Product E | Product F
Demand Qty | 100 | 0 | 300 | 0 | 500 | 600
Unit Price | 12 | 24 | 34 | 45 | 65 | 120
Demand Value
Current Ranking Output
Required Ranking Output | 4 | 6 | 3 | 5 | 2 | 1
Spreadsheet: 469059d1467738948-automatically-sommeprod-if-condition-pond-rer-copie
Sheet: Feuil1

Name | Value | Size corp (big=1, little=0) | total received by person | weights (%of each funding wrt total by person) | weightened average
[NAME] | 19000 | 1 |  |  |  | >> i cannot do that by hand for 50.000 lines and 600 names
[NAME] | 500 | 0
[NAME] | 300 | 0
[NAME] | 2000 | 0
[NAME] | 150 | 0
Total eric
[NAME] | 7000 | 1
[NAME] | 4000 | 1
[NAME] | 600 | 0
Total
BROOKE | 100 | 0
BROOKE | 2000 | 0
BROOKE | 800 | 1
BROOKE | 250 | 1
BROOKE | 500 | 1
Total
Spreadsheet: 189816d1351367844-enter-a-team-name-in-a-cell-on-one-sheet-automatically-load-stats-form-another-sheet-sas
Sheet: Match Maker

 |  | Home Team Name Here |  |  |  | Away Team Name Here
 | HOME STATISTICS |  |  |  | AWAY STATISTICS
 | Possesion & Time |  |  |  | Possesion & Time
 | Av. Possesion | Av. First Goal Time | Scored First Goal | Both Teams Scored | Av. Posession | Av. First Goal Time | Scored First Goal | Both Teams Scored
 | Goals |  |  |  | Goals
 | Av. Goals Scored | Av. Goals Conceded | Over 2.5 Goals | Under 2.5 Goals | Av. Goals Scored | Av. Goals Conceded | Over 2.5 Goals | Under 2.5 Goals
 | Bookings |  |  |  | Bookings
 | Av. Cards For | Av. Cards Against | Over 3.5 Cards | Under 3.5 Cards | Av. Cards For | Av. Cards Against | Over 3.5 Goals | Under 3.5 Cards
 | What I want to do on this sheet is to enter the teams name above and for it to automatically load the teams stats into the above fields from the spreadsheet with the stats .
Spreadsheet: 688732d1595930228-dependent-lists-based-on-multiple-not-unique-table-columns-dependentlists
Sheet: Sheet1

 |  |  |  |  |  |  | Expected Result
 |  | Division | App | Function
 |  | Game | Arcade | 8
 |  | Game | deRamblr | 7 |  |  | Division | App | Function
 |  | Game | Five Labs | 5 |  |  | Game | deRamblr | 7
 |  | Game | Hackrr | 6
 |  | Game | Kryptis | 1
 |  | Game | Kryptis | 1
 |  | Game | Kryptis | 2
 |  | Game | Kryptis | 3
 |  | Game | Pes | 9
 |  | New | Blend | 1
 |  | New | Blend | 1
 |  | Xbox | Baden | 4
 |  | Xbox | Baden | 4
 |  | Xbox | Marko | 5
 |  | Division
 |  | App
 |  | Function
 | 1
Spreadsheet: 118029d1313370716-excel-2007-delete-rows-containing-na-in-column-a-upload-sample
Sheet: Data

TYPE | MAKE | MODEL | SERIAL # | Fleet ID # | [NAME] | External | Total | Hours/Report | $$/HR | Annual Util
REACH | RAYM | EZ-DR30TT-270+ | EZ-C-07-38661 | 84 | 2940 | 2556.77 | 5496.77 | 2462.270270270269 | 2.232399126273272 | 2469.03474903475
REACH | RAYM | EZ-DR30TT-270+ | EZ-C-07-38662 | 86 | 2940 | 1659.14 | 4599.14 | 2536.000000000001 | 1.813541009463722 | 2542.96703296703
PALLET_TRUCK | RAYM | 840-FRE80L-OTR | 840-07-75274 | 9 | 0 | 2460.14 | 2460.14 | 772.4580152671747 | 3.184820341528978 | 774.580152671756
REACH | RAYM | EZ-DR30TT-270+ | EZ-C-06-37517 | DR85 | 2940 | 1006.97 | 3946.97 | 1488.597014925373 | 2.65146978021978 | 1492.68656716418
These formulas continue down to line 502. How many return data depends on customers fleet size.
Spreadsheet: 83297d1283292677-comparing-cells-and-if-equal-then-copy-different-cell-to-different-worksheet-example
Sheet: A

57 POST ST # 501 | SAN FRANCISCO | CA | 94104
57 POST ST # 502 | SAN FRANCISCO | CA | 94104
57 POST ST # 503 | SAN FRANCISCO | CA | 94104
57 POST ST # 507 | SAN FRANCISCO | CA | 94104
57 POST ST # 508 | SAN FRANCISCO | CA | 94104
57 POST ST # 510 | SAN FRANCISCO | CA | 94104
57 POST ST # 513 | SAN FRANCISCO | CA | 94104
57 POST ST # 515 | SAN FRANCISCO | CA | 94104
57 POST ST # 602 | SAN FRANCISCO | CA | 94104
57 POST ST # 604 | SAN FRANCISCO | CA | 94104
57 POST ST # 610 | SAN FRANCISCO | CA | 94104
57 POST ST # 614 | SAN FRANCISCO | CA | 94104
57 POST ST # 702 | SAN FRANCISCO | CA | 94104
57 POST ST # 706 | SAN FRANCISCO | CA | 94104
57 POST ST # 709 | SAN FRANCISCO | CA | 94104
57 POST ST # 712 | SAN FRANCISCO | CA | 94104
57 POST ST # 713 | SAN FRANCISCO | CA | 94104
57 POST ST # 715 | SAN FRANCISCO | CA | 94104
57 POST ST # 801 | SAN FRANCISCO | CA | 94104
57 POST ST # 804 | SAN FRANCISCO | CA | 94104
57 POST ST # 807 | SAN FRANCISCO | CA | 94104
57 POST ST # 809 | SAN FRANCISCO | CA | 94104
57 POST ST # 813 | SAN FRANCISCO | CA | 94104
57 POST ST # 814 | SAN FRANCISCO | CA | 94104
57 POST ST # 815 | SAN FRANCISCO | CA | 94104
57 POST ST # 900 | SAN FRANCISCO | CA | 94104
57 POST ST # 901 | SAN FRANCISCO | CA | 94104
57 POST ST # 902 | SAN FRANCISCO | CA | 94104
57 POST ST # 903 | SAN FRANCISCO | CA | 94104
57 POST ST # 907 | SAN FRANCISCO | CA | 94104
57 POST ST # 914 | SAN FRANCISCO | CA | 94104
57 POST ST # 915 | SAN FRANCISCO | CA | 94104
Spreadsheet: 879083d1726518474-sumproduct-w-index-match-that-uses-indirect-breaks-with-sort-of-underlying-allocation-and-risk-data
Sheet: Model Risk

 |  |  | Models[ | ]
 |  |  | Inv_Risk[ | ]
 |  | Model | Min | [NAME] | 7/31/2024 | 8/30/2024
 |  | Aggressive |  |  |  |  |  | 0.143 | 0.143
 |  | Mod. Agg. |  |  |  |  |  | 0.515 | 0.515
 |  | Moderate |  |  |  |  |  | 0.5840000000000001 | 0.5840000000000001
 |  | Mod. Cons. |  |  |  |  |  | 0.41 | 0.41
 |  | Conservative |  |  |  |  |  | 0.1925 | 0.1925
Spreadsheet: 757341d1638198352-look-for-value-in-several-sheets-example
Sheet: pricelist

edi code | name | price
1122 | abc
2233 | bcd |  |  | in C column I want price. If it is an focus product i want the price from sheet focusproduct and then if it is an special product i want it to find price in sheet special product and finally get the rest prices from sheet all products.
3344 | feg
5566 | def
8877 | abc
9988 | bcd
3399 | cde
4565 | eee
4747 | [NAME]
4848 | uuh
Spreadsheet: 124095d1318090416-calculate-hi-points-score
Sheet: Scoring

Back # | Points Earned
154 | 6
111 | 5
112 | 4
3 | 3
88 | 2
99 | 1
154 | 6
111 | 5
112 | 4
3 | 3
88 | 2
99 | 1
Spreadsheet: 65623d1266336666-index-and-match-formulas-sample
Sheet: Trail Cost Calculation

 |  |  |  |  |  |  | Estimate: | 028574
 |  |  |  |  |  |  | Die #: | 060987-O-4
Sample # |  | 060987
Total quantity of trail |  | 15000 |  |  |  |  | Cost: | 2353.73
# of colors |  | 5 |  |  |  |  | Freight cost: | 120
Note: Enter the number of colors for the item with the most colors
Enter the total number of items in trail
# of items: |  | x MR per item
Enter the total number of plates in trail
Total plates: |  | x $ per plate change
Enter the total plate costs and total prep costs to be included in price
Plates: |  |  | add to cost
Prep: |  |  | add to cost
Enter the total number of source tags (check point or sensomatic) required
Total tags: |  |  | add to cost
Fixed Costs: |  |  | 5% of variable cost
Priced variable cost with a divisor of .60 + freight at cost
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 2

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % Dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
2 | 2007-02-07 00:00:00 | 7.5 | 2.05 | 11.5 | 3.4 | 8 | 6 |  |  |  | 14.5 |  | 4.145022081206718 | 4.3 | 0.1 | 9 |  |  |  |  | 0.8
MTTR Well 1A #2  1000gpm | 2012-03-29 00:00:00 | 7.6 | 2.29 | 9.82 | 3.04 | 7.6 | 5.3 |  |  | 0.9 | 14.7 |  | 3 | 7.8 | 0.05 | 3.5 |  | <0.01 | <0.01 |  | 0.8 | second sample likely correct
Well #2 | 2013-10-11 00:00:00 | 7.1 | 1.49 | 6.29 | 1.75 | 4.3 | 6 |  |  | 0.4 | 8.5 |  | 2.2 | 5.4 | 0.04 | <0.1 |  | <0.10 | 1.42 |  | 0.2 | Resample- use this one
Well - 2 | 2014-01-27 00:00:00 | 8.2 | 2.3 | 11.76 | 3.56 | 8.3 | 5 |  |  | 0.8 | 17.1 |  | 3 | 8 | 0.04 | 3.4 |  | <0.10 | <0.02 |  | 1.4
Well 2 | 2016-04-01 00:00:00 | 7.93 | 2.389 | 11.93 | 3.63 | 7.91 | 4.961633762289186 | 4.961633762289186 | 0 | 1.05 | 14.332 | 1529.6 | 2.84 | 7.12 | 0.035 | 4.1623 | 0.019 | 0 | 0.004 | 0.045
Well 2 | 2017-05-03 00:00:00 | 7.69 | 2.579 | 13.7 | 4.08 | 8.64 | 4.669890496363201 | 4.669890496363201 | 0 | 0.954 | 17.093 | 1650 | 2.9 | 7.34 | 0.043 | 4.6933 | 0 | 0.036 | 0 | 0.018
[NAME] | 2018-05-29 00:00:00 | 7.8 | 2.67 | 15.5 | 4.65 | 9.35 |  | 4.557988969706658 | 0 | 1.09 | 5.387 | 1708.8 |  |  | 0.056 | 3.919 | 0.054 | 0.135 | 0 | 0.004
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | comments: Cl very low 20128
Spreadsheet: 845a17a3-44c5-448b-a891-6b0398d75476
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Approving and authorizing settlement of a lawsuit entitled [NAME], et [NAME]
 | City of Kansas City, Missouri, Case No. 0916-CV25237.
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2009-10 |  |  | FY 2010-11
 | General Fund
 | Special Revenue
 | Enterprise
 |  |  | Total: | $ | 0 |  | $ | 0
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2009-10 |  |  | FY 2010-11
 | General Fund
 | Special Revenue
 | Enterprise/Other
 |  |  | Total: | $ | 0 |  | $ | 0
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | X | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | X | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 64559d1265379821-my-sheet-is-gone-ppt_basisgegevens
Sheet: Klanten 2008

2008 |  | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
[NAME] |  | 1097 | 708 | 758 | 792 | 704 | 644 | 561 | 571 | 1313.56 | 758 | 738 | 619
Meubelen |  | 1058 | 988 | 1106 | 1107 | 1089 | 1010 | 1109 | 982 | 988 | 913 | 753 | 740
Textiel |  | 4405 | 4175 | 3948 | 4265 | 4045 | 4227 | 4800 | 4208 | 4292 | 4775 | 4974.84 | 3667
Huisraad |  | 4611 | 4680 | 4721 | 5247 | 4370 | 4943 | 5383 | 5097 | 5079 | 5471 | 5001.85 | 5034
[NAME] |  | 2020 | 2168.5 | 1909 | 2094 | 1464 | 1600 | 1779 | 1775 | 1902 | 2115 | 1670.1 | 1485
Diverse |  | 2355 | 1674 | 1934 | 2378 | 2173 | 1812 | 2098 | 1749 | 1853 | 2222 | 1733 | 1765
Beernem |  | 1195 | 1206 | 1129 | 1353 | 1268 | 1193 | 1355 | 1215 | 1327 | 1575 | 1380 | 1162
Blankenberge |  | 1201 | 1247 | 1343 | 1446 | 1275 | 1334 | 1644 | 1413 | 1339 | 1499 | 1135 | 1076
Brugge |  | 8019 | 7057 | 6669 | 7373 | 6383 | 6675 | 7295 | 6437 | 7445.559999999999 | 7377 | 7447.790000000001 | 6174
[NAME] |  | 1897 | 1790 | 1896 | 2106 | 1890 | 1828 | 2240 | 2097 | 1960 | 1731 | 1496 | 1387
Ruddervoorde |  | 161 | 43 | 145 | 551 | 118 | 178 | 166 | 49 | 175 | 195 | 95 | 128
Zedelgem |  | 3073 | 3050.5 | 3194 | 3054 | 2911 | 3028 | 3030 | 3171 | 3181 | 3877 | 3317 | 3383
Totaal |  | 15546 | 14393.5 | 14376 | 15883 | 13845 | 14236 | 15730 | 14382 | 15427.56 | 16254 | 14870.79 | 13310
Spreadsheet: 842166d1694225608-sum-of-times-a-person-does-a-task-with-a-date-filter-no-pivot-table-excel-formula-09-07-2023
Sheet: Sheet2

Phase Owner | Phase Type | Start Date | Month | Year | Helper
[NAME] | Account Cleanup | 2023-06-01 00:00:00
[NAME] | Account Cleanup | 2023-06-20 00:00:00
Zachary | Implementation | 2023-06-30 00:00:00
Laurel | Implementation | 2023-08-21 00:00:00
Laurel | Implementation | 2023-06-14 00:00:00
Zachary | Implementation | 2023-06-01 00:00:00
Laurel | Implementation | 2023-07-14 00:00:00
Zachary | Implementation | 2023-07-28 00:00:00
Zachary | Implementation | 2023-08-15 00:00:00
[NAME] | Implementation | 2023-03-15 00:00:00
Laurel | Implementation | 2023-05-23 00:00:00
[NAME] | Light Implementation | 2023-07-11 00:00:00
[NAME] | Light Implementation | 2023-08-09 00:00:00
Laurel | Light Implementation | 2023-05-11 00:00:00
[NAME] | Light Implementation | 2023-05-31 00:00:00
Spreadsheet: b2848051-f912-415d-aa27-ec5a164a0e00
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42291655 | 2014-07-14 03:16:07 | AXIS | 0 | 5 | 7 | 754357 | Maréchal Davout | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42291963 | 2014-07-14 03:52:41 | AXIS | 1 | 7 | 4 | 952234 | robdoglove | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42292278 | 2014-07-14 04:12:39 | ALLIES | 1 | 7 | 1 | 952234 | robdoglove | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42293936 | 2014-07-14 07:00:59 | AXIS | 1 | 4 | 0 | 1394475 | Franzac | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
42294081 | 2014-07-14 07:16:06 | ALLIES | 1 | 4 | 2 | 1394475 | Franzac | 6161 | western | 1944-06-10 | 1944-06-10 | Mont Mouchet | Mont Mouchet
Spreadsheet: 125352d1318975823-problem-using-conditional-formatting-to-flag-cells-by-color-and-count-them-example4
Sheet: Nelson

PT. # | LAST NAME | FIRST NAME | REQUIRED | IN DATE | COM DATE | NOTES |  |  | VISIT DATE
8964 |  |  | SSS Sig | 2011-09-01 00:00:00 | 2011-10-11 00:00:00 | DELIQUENT | Total # Yellow: | 0 | GOOD
80303 |  |  | DO Sig | 2011-09-13 00:00:00 | 2011-10-11 00:00:00 | GOOD | Total # Orange: | 1 | GOOD
57659 |  |  |  | 2011-10-11 00:00:00 |  | GOOD | Total # Red: | 0 | need this to be 1
64748 |  |  | HP Sig | 2011-10-11 00:00:00 | 2011-10-11 00:00:00 | GOOD | Complient: | 2 | need this to be 5
22801 |  |  | D/C Sig | 2011-09-20 00:00:00 |  | GOOD | All Total: | 2 | this would be 6
19183 |  |  | PN | 2011-10-17 00:00:00 | 2011-10-17 00:00:00 | GOOD
73942
79968
19183
Spreadsheet: 146146d1331921533-price-grid-index-lookup-match-windows-check-sheet-2012
Sheet: Check Sheet

 | Cust:- |  |  |  | Order Value N | 0
 | Rep:- |  |  |  | Order Value G | 0
 | No. | Style Code |  | [NAME] | Height | Price
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 |  |  |  |  | Total | 0
 | [NAME] | Code | Item | Amount | Cost | Total
 | 1 |  |  |  |  | 0
 | 2 |  |  |  |  | 0
 | 3 |  |  |  |  | 0
 | 4 |  |  |  |  | 0
 | 5 |  |  |  |  | 0
 | 6 |  |  |  |  | 0
 | 7 |  |  |  |  | 0
 | 8 |  |  |  |  | 0
 | 9 |  |  |  |  | 0
 | 10 |  |  |  |  | 0
 | 11 |  |  |  |  | 0
 |  |  |  |  | Total | 0
 | [NAME] | Code | Item | Amount | Cost
 | 1 |  |  |  |  | 0
 | 2 |  |  |  |  | 0
 | 3 |  |  |  |  | 0
 | 4 |  |  |  |  | 0
 | 5 |  |  |  |  | 0
 | 6 |  |  |  |  | 0
 | 7 |  |  |  |  | 0
 |  |  |  |  | [NAME] | 0
 |  |  |  |  | Frames | 0
 | Total |  | Less VAT | Nett | [NAME] | 0
 |  |  |  |  |  | 0
 | 0 |  | 0 | 0 |  | 0
 | [NAME] excl VAT |  | True Order | Sold | Difference | % Over
 |  |  | Value | Value | 0 | Under |  | 0
 | 0 |  | 0 | 0 | 0 | #N/A
10 | 0 |  | 0 | 0.1 | 0 | 0 | 0.06
 | Commission |  |  | 0 |  | 0
#N/A | [NAME] | #N/A | #N/A | 0
 | Under Charge |  | #N/A | 0
 | Comm Total |  | #N/A | 0 | 0
 | Special Pay |  |  | 0
Spreadsheet: 881806d1729993726-how-to-have-return-results-of-a-function-split-across-multiple-lines-testfile
Sheet: CFS Charges

CFS - Warehouse Charges
 |  |  |  |  | **Note: Goal to leave out columns that have all '0.00' charges. (Done)
CFS Location: |  | cfs-2
 | Client | Job # | POL | POD | Final Dest | # Pieces | Gross Wght (kgs) | CBM | [NAME] | CFS Location | Total CFS Charges: | CFS Charge | Handling Fee | CUCC Collect
2023-07-26 00:00:00 | Client-2 | 9 | qingdao | NY | Boston | 1-pallet/ 24-bags | 630 | 1 | LCL | CFS-2 | 255 | 255 | 0 | 0
2023-08-04 00:00:00 | Client-2 | 10 | Shanghai | NY | Boston | 1-pallet | 84 | 0 | LCL | CFS-2 | 325 | 0 | 255 | 70
2023-08-04 00:00:00 | Client-3 | 11 | Shanghai | Boston | Boston | 182-ctns/ 6-pallet | 3810 | 8 | LCL | CFS-2 | 0 | 0 | 0 | 0
Spreadsheet: 172707d1344304897-if-condition-and-return-a-specific-number-many-20if-20condition-1-
Sheet: Sheet1

Material | U/P Original Curr. | Origin Cur | U/P Convert to RMB | Amount
A | 1.2 | HKD | 0.8192 | 0.98304
B | 0.88 | HKD | 0.8192 | 0.7208960000000001
C | 3 | USD | 6.355 | 19.065
D | 4 | EUR | 8.592 | 34.368
E | 2.1 | SGD | 4.82 | 10.122
F | 3.2 | SGD | 4.82 | 15.424
G | 3 | USD | 6.355 | 19.065
My Question is if the origin currency in Col C,  is USD, EUR & SGD then Col D, will auto be 6.355, 8.592, 4.82)
Spreadsheet: dutch_quigley__9214__enron breakdown  12-13 BOD
Sheet: Sheet1

ENRON position breakdown (12-13-01) BOD
 | Option Contracts |  |  | Futures Contracts |  |  | Options | Overall
Month | Bod | Activity | Eod | Bod | Activity | Eod | Delta | Delta | Gamma | Vega | Theta | Month
F02 | 410 |  |  | -7 |  |  | -1 |  | 0 | -170 | 1177 | F02
G02 | 916 |  |  | 23 |  |  | -180 |  | 0 | -552 | 1437 | G02
H02 | 1252 |  |  | 216 |  |  | -7 |  | -0.3 | -5155 | 3065 | H02
[NAME] | 300 |  |  | 47 |  |  | -53 |  | -0.3 | -4277 | 1523 | [NAME]
K02 | 560 |  |  | -61 |  |  | 58 |  | -1.6 | -28536 | 6061 | K02
M02 | 135 |  |  | -2 |  |  | -12 |  | 0 | -1156 | 206 | M02
N02 | 0 |  |  | -18 |  |  | 0 |  | 0 | 0 | 0 | N02
Q02 | 0 |  |  | -47 |  |  | 0 |  | 0 | 0 | 0 | Q02
U02 | 155 |  |  | 22 |  |  | -30 |  | -0.4 | -12332 | 1251 | U02
[NAME] | 300 |  |  | 29 |  |  | -44 |  | -0.2 | -14090 | 1020 | [NAME]
H03 | 200 |  |  | -13 |  |  | 17 |  | 0.4 | 25684 | -1250 | H03
M03 | 0 |  |  | 22 |  |  | 0 |  | 0 | 0 | 0 | M03
U03 | 50 |  |  | -4 |  |  | 6 |  | 0.1 | 7188 | -170 | U03
Z03 | 200 |  |  | -16 |  |  | 20 |  | 0.4 | 33494 | -693 | Z03
H04 | 200 |  |  | 46 |  |  | -40 |  | 0 | -1097 | 3 | H04
 |  |  |  |  |  |  | Overall: