tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 139054d1328048786-solved-calculate-if-countblank-upload
Sheet: Sheet1

name | category
name | 1 | taken care
name | 2
name | 3
name | 2
name | 3
name | 1 | taken care
name | 1
name | 1
name | 1
name | 1 | taken care
name | 3 | taken care
name | 1 | taken care
name | 1 | taken care
name | 1 | taken care
name | 1
name | 2
name | 1
name | 1
name | 2 | taken care
name | 1 | taken care
name | 1 | taken care
name | 3
name | 1
name | 1
 | total 1
 | total 2
 | total 3
Spreadsheet: 01d8bb0f-4c19-41fd-ad03-ec9799e1d47b
Sheet: FY 2010 Lease Turnover Analysis

FY 2010 Lease Turnover Analysis
Disposition Of Leases Expiring in FY 2010 | Sq Ft | % of Total Sq Ft | Count | % of Total Count
Leases Scheduled to Expire in FY 2010 | 29257308 | 1 | 2043 | 1
Extended in FY 2010 Beyond FY 2010 | 16377374 | 0.5597703657493027 | 1079 | 0.5281448849730788
Renewed During FY 2010 | 2627496 | 0.08980648527198742 | 182 | 0.08908467939304944
Replaced in Same Building with New Leases | 5236621 | 0.1789850590491784 | 342 | 0.1674008810572687
Subtotal | 24241491 | 0.8285619100704685 | 1603 | 0.784630445423397
Leases Terminated | 3088587 | 0.1055663426040427 | 274 | 0.1341164953499755
Leases Moved to Another Leased Building | 1927230 | 0.06587174732548873 | 166 | 0.08125305922662751
Subtotal | 5015817 | 0.1714380899295314 | 440 | 0.215369554576603
[Non-add: Leases Terminated - Move to Federal Bldg | 76939 | 0.002629736132934718 | 12 | 0.005873715124816446 | ]
[Non-add: Leases Terminated - Canceled Agency Req. 1/ | 532783 | 0.01821025365696666 | 55 | 0.02692119432207538 | ]
Disposition of Leases Expiring After FY 2010
Leases Scheduled to Expire After FY 2010 | 152959246 | 1 | 6800 | 1
Lease Replaced In Same Leased Building After [NAME] | 272653 | 0.001782520554527315 | 21 | 0.003088235294117647
Lease Replaced In Same Leased Building Before Firm Term | 230917 | 0.001509663560972313 | 1 | 0.0001470588235294118
Lease Replaced In Different Leased Building After [NAME] | 149023 | 0.0009742660473104058 | 25 | 0.003676470588235294
Lease Replaced In Different Leased Building Before Firm Term | 84262 | 0.0005508787615231838 | 1 | 0.0001470588235294118
Lease Terminate W/O Lease Replacement After [NAME] | 300350 | 0.00196359493037773 | 56 | 0.00823529411764706
Lease Terminate W/O Lease Replacement Before Firm Term | 95029 | 0.0006212700603924263 | 8 | 0.001176470588235294
[Non-add: Leases Terminated - Move to Federal Bldg | 61905 | 0.0004047156456302092 | 8 | 0.001176470588235294
[Non-add: Leases Terminated - Canceled Agency Req. 1/ | 129599 | 0.0008472779736375008 | 34 | 0.005
FY 2010 Lease Turnover
Total Leases At Start of FY 2010 | 182216554 | 1 | 8843 | 1
Same/Replacement Leases Continued Past FY 2010 | 176572073 | 0.9690232260675943 | 8313 | 0.9400655886011534
Same Lease Space Dis-Continued Past FY 2010 (Turnover) | 5644481 | 0.03097677393240572 | 530 | 0.05993441139884655
[Non-add: Leases Terminated - Move to Federal Bldg | 138844 | 0.0007619724824781836 | 20 | 0.002261675901843266
[Non-add: Leases Terminated - Canceled Agency Req. 1/ | 662382 | 0.003635136245634411 | 89 | 0.01006445776320253
1/ Only counts actions where leases had to be terminated due to customer office closures, partial reductions in space not included.
Spreadsheet: 763914d1642452938-alternative-for-too-many-ifs-nested-in-the-formula-spreadsheet-is-still-growing-sales
Sheet: Sheet1

[NAME] | SELL_PRICE_1 | SELL_PRICE_2 | SELL_PRICE_3 | STANDARD_COST_VALUE
1 |  |  |  | 360
2.1 |  |  |  | 360
3 |  |  |  | 360
4 |  |  |  | 360
5 |  |  |  | 360
5.1 |  |  |  | 360
Spreadsheet: john_zufferli__16716__HedgeSummary
Sheet: Sheet1

 | CONFIDENTIAL:  PPA - POWER AND GAS POSITIONS:
 |  |  |  |  |  |  |  |  | Current to | Hedgeable | Current |  | AECO
 |  |  |  |  | Power Price | Aeco Gas Price | Heat Rate | Jan 11/2001 | Beg. Year | Volume | Gas Hedges |  | Hedge
 |  | Power (MWh) | Discount Days | Power (MW) | ($/MWh) | ($[NAME]) | (GJ/MWh) | Heat Rates | HR Delta | (cont/day) | (cont/day) | % Hedged | (cont/day)
2002-01-01 00:00:00 | Cal 2002 |  |  |  |  |  |  | 14.25
2003-01-01 00:00:00 | Cal 2003 |  |  |  |  |  |  | 12.03
2004-01-01 00:00:00 | Cal 2004 |  |  |  |  |  |  | 8.9
2005-01-01 00:00:00 | Cal 2005 |  |  |  |  |  |  | 9.06
2006-01-01 00:00:00 | Cal 2006 |  |  |  |  |  |  | 7.5
2007-01-01 00:00:00 | Cal 2007 |  |  |  |  |  |  | 7.02
2008-01-01 00:00:00 | Cal 2008 |  |  |  |  |  |  | 7.09
2009-01-01 00:00:00 | Cal 2009 |  |  |  |  |  |  | 7.1
2010-01-01 00:00:00 | Cal 2010 |  |  |  |  |  |  | 7.14
2011-01-01 00:00:00 | Cal 2011 |  |  |  |  |  |  | 7.11
2012-01-01 00:00:00 | Cal 2012 |  |  |  |  |  |  | 7.08
2013-01-01 00:00:00 | Cal 2013 |  |  |  |  |  |  | 7.04
2014-01-01 00:00:00 | Cal 2014 |  |  |  |  |  |  | 7.03
2015-01-01 00:00:00 | Cal 2015 |  |  |  |  |  |  | 7
2016-01-01 00:00:00 | Cal 2016 |  |  |  |  |  |  | 7
2017-01-01 00:00:00 | Cal 2017 |  |  |  |  |  |  | 7
2018-01-01 00:00:00 | Cal 2018 |  |  |  |  |  |  | 7
2019-01-01 00:00:00 | Cal 2019 |  |  |  |  |  |  | 7
2020-01-01 00:00:00 | Cal 2020 |  |  |  |  |  |  | 7
 | Total
 | Note: Power position is 710MW * Availability factor (of 81-87%) - 9% transmission losses - hedges
Spreadsheet: 246d3e9c-b78b-47d1-8bdd-b473e322fcf2
Sheet: 8b

Product1 | USD | EUR3 | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Basis | 244 | 2 | 29 | 38 | 2 | - | 1 | 316
Cap/Floor | 161 | 16 | 22 | 1 | - | 2 | - | 202
Debt Option | - | - | - | - | - | - | - | -
Exotic | - | - | - | - | - | - | - | -
Fixed-Fixed | 6 | - | 4 | - | - | - | 13 | 23
Fixed-Float | 7788 | 2169 | 1453 | 913 | 942 | 355 | 2793 | 16413
FRA | 1015 | 914 | 169 | - | 92 | 17 | 206 | 2413
Inflation | 170 | 94 | 48 | 1 | - | - | 3 | 316
OIS | 55 | 98 | 22 | 22 | 116 | 49 | 154 | 516
Swaption | 1295 | 564 | 163 | 181 | 66 | 64 | 135 | 2468
TOTAL | 10734 | 3857 | 1910 | 1156 | 1218 | 487 | 3305 | 22667
Spreadsheet: 274257d1383059039-formula-to-automatically-duplicate-row-information-to-another-area-in-a-worksheet-shiftnotesblake3
Sheet: Orders not Scheduled

 | ORDERS NOT SCHEDULED FOR PRODUCTION
OrderNo | CUSTOMER Name | P/N | MATERIAL | ELINE | QSHTS | SYSReq'DDate | DDATE | PREP | ARTW | EXPOS | DEVEL | ETCH | S/DRY | PLAT'G | QC | NOTES
Spreadsheet: 780777d1652778343-filter-to-match-up-range-and-spill-data-in-range-dummy-test_filter
Sheet: Result

 | [NAME] used
 | < data to pulled> |  | Lookup range |  | Expected Result |  | Lookup range
 |  | Denmark | D |  | RAM | Denmark | D
 |  |  | G |  | [NAME] | UK | G
 |  |  | B |  | AB | Austria | B
 |  |  | M |  | DK | Switzerland | M
Spreadsheet: 59181d1259666282-combine-and-sort-two-tables-comparison-calculator
Sheet: Sheet1

 |  |  |  | Data |  |  |  | Data |  |  |  |  |  |  | Desired
 |  |  |  | Entered |  |  |  | Entered |  |  |  |  |  |  | Result
 |  |  | Boat A |  |  |  |  | Boat B |  |  |  |  | A | B | A | B | A | B
 |  | RPM | MPH | GPH | MPG |  | RPM | MPH | GPH | MPG |  | RPM | MPH | MPH | GPH | GPH | MPG | MPG
 |  | x100 |  |  |  |  | x100 |  |  |  |  | x100
 |  | 5 |  |  |  |  | 5 | 2.8 | 0.18 | 15.8 |  | 5
 |  | 10 | 5.3 | 1.4 | 3.79 |  | 10 | 5.5 | 0.73 | 7.5
 |  | 15 | 6.9 | 2.1 | 3.29 |  | 15 | 7.2 | 1.74 | 4.2
 |  | 20 | 8.1 | 3.5 | 2.31 |  | 20 | 9.1 | 4.75 | 1.9
 |  | 25 | 8.7 | 4.5 | 1.93 |  | 25 | 18.8 | 6.03 | 3.1
 |  | 30 | 16.7 | 5.2 | 3.21 |  | 30 | 27.7 | 7.26 | 3.8
 |  | 35 | 27.2 | 6.1 | 4.46 |  | 35 | 34.7 | 9.09 | 3.8
 |  | 40 | 32.9 | 7.6 | 4.33 |  | 40 | 42 | 11.86 | 3.5
 |  | 45 | 39.9 | 10.2 | 3.91 |  | 45 | 47.9 | 14.98 | 3.2
 |  | 50 | 44.4 | 12.5 | 3.58 |  | 50 | 53.3 | 17.02 | 3.1
 |  | 55 | 54.5 | 15.9 | 3.43 |  | 55
 |  | WOT | 56.8 | 17.5 | 3.25 |  | WOT | 58.7 | 20.57 | 2.9
Spreadsheet: 839197d1691747661-function-to-turn-different-values-based-on-portion-of-values-within-a-cell-excel-forum-example
Sheet: Sheet1

Product | Rate |  |  |  | Length | Rate
M60, D4X 72.00 L, 2.00 WD |  |  |  |  | 49 | 18
M60, D4X 108.00 L, 2.00 WD |  |  |  |  | 72 | 24
K50, D4X  120.00L , 2.00 WD |  |  |  |  | 104 | 36
M60, D4X 120.00 L, 1.00 WD |  |  |  |  | 108 | 36
K35, D4X 104.00 L, 2.00 WD |  |  |  |  | 120 | 36
K35, D4X 49.00 L, 2.00 WD
Spreadsheet: 043b820a-db5f-4161-8b19-d1b12d8c4399
Sheet: PSATTPOT

Team | Tournament | PPB
[NAME] | St. Anselm's PSAT | 26.71
[NAME] A | St. Anselm's PSAT | 25.59
TJ B | St. Anselm's PSAT | 25.36
Solon A | Case PSAT | 25.12
[NAME] | St. Anselm's PSAT | 24.68
TJ A | St. Anselm's PSAT | 24.29
DCC B | Case PSAT | 23.85
Kellenberg | St. Anselm's PSAT | 23.61
[NAME] | St. Anselm's PSAT | 22.91
Copley A | Case PSAT | 22.57
[NAME] B | St. Anselm's PSAT | 22.55
[NAME] | St. Anselm's PSAT | 22.46
[NAME] | Case PSAT | 21.6
DCC C | Case PSAT | 21.56
TJ C | St. Anselm's PSAT | 21.18
[NAME] | St. Anselm's PSAT | 20
GDS | St. Anselm's PSAT | 19.62
[NAME] | St. Anselm's PSAT | 19.15
Centennial A | St. Anselm's PSAT | 18.64
[NAME] | Case PSAT | 18.49
Clover Hill | St. Anselm's PSAT | 18.33
Baltimore Poly A | St. Anselm's PSAT | 18.08
Solon B | Case PSAT | 17.95
Centennial B | St. Anselm's PSAT | 17.81
TJ E | St. Anselm's PSAT | 17.06
Gonzaga | St. Anselm's PSAT | 16.56
Longfellow | St. Anselm's PSAT | 16.05
Copley/Solon | Case PSAT | 14.04
Baltimore Poly B | St. Anselm's PSAT | 12.5
Centennial C | St. Anselm's PSAT | 12.5
[NAME] | Case PSAT | 11.79
St. Joseph | Case PSAT | 11.03
TJ D | St. Anselm's PSAT | 10.29
Centennial D | St. Anselm's PSAT | 7.5
[NAME] | Torrey Pines Open | 25.1
La Jolla | Torrey Pines Open | 24.63
CCA A | Torrey Pines Open | 20.34
Westview | Torrey Pines Open | 18.54
SDA A | Torrey Pines Open | 19.22
SDA B | Torrey Pines Open | 16.29
CCA B | Torrey Pines Open | 15
Santa Fe Christian | Torrey Pines Open | 12.22
Spreadsheet: 211089d1359650892-conditional-formatting-one-cell-green-rest-no-colour-excel-test
Sheet: Sheet1

QUOTE COMPARISON
ITEM NO. | [NAME]: | QTY: | Company one | Company Two | Company Three | Company Four | Company Five
 |  |  | 1 | 5 | 0.5 | 99 | 12
 |  |  | 3 | 0.5 | 22 | 3 | 0.01
 |  |  | 0.5 | 0.45 | 36 | 25 | 2
 |  |  | 3 | 5 | 3.5 | 0.5 | 9
 |  |  | 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 | 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 | 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 | 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
Spreadsheet: 35a70149-baa7-4b4a-9550-c288680be142
Sheet: FACULTY INFORMATION FORM

Please use capital letters & no punctuation | EXAMPLE | class 1 info | class 2 info | class 3 info | class 4 info | class 5 info | class 6 info
Last Name | LOGAN
First Name | SARAH
MI | M
Printed Course Prefix (e.g. ART, MUS, TH) and Number | PSY3303
Printed Date/Time (e.g. MW 08:00 AM, TR 12:30 PM or MWF 18:00 PM) | TR 18:00 PM
Bubbled in Meeting Days (MTWRFSN) NO [NAME] or Spaces | TR
In the Classroom = Face  OR  Online Course = Online | Face
Eight Week Course = Y (yes) or N (no).    If YES… 1 for first eight weeks or 2 for second eight weeks | Y-2
For On-line courses ONLY - Print course title. In addition, please provide a class roster with [NAME] "username@angelo .edu" with your FIF.  Dropped students can be withdrawn later. | Learning  and Cognition
Objectives:  (Scale - M = Minor or No Importance,  I = Important,                              E = Essential) | M, I, E
1.  Gaining factual knowledge (terminology, classifications, methods,       trends) | E
2.  Learning fundamental principles, generalizations, or theories | E
3.  Learning to apply course material (to improve thinking, problem       solving,  and decisions) | E
4.  Developing specific skills, competencies, and points of view needed       by professionals in the field most closely related to this course | I
5.  Acquiring skills in working with others as a member of a team | I
6.  Developing creative capacities (writing, inventing, designing,       performing in art, music, drama, etc.) | M
7.  Gaining a broader understanding and appreciation of       intellectual/cultural activity (music, science, literature, etc.) | M
8.  Developing skill in expressing oneself orally or in writing | M
9.  Learning how to find and use resources for answering questions or       solving problems | M
10.  Developing a clearer understanding of, and commitment to, personal         values | M
11.  Learning to analyze and critically evaluate ideas, arguments,         and points of view | M
12.  Acquiring an interest in learning more by asking questions and         seeking answers | M
[NAME] (e.g. ART, MUS) | PSY
Discipline codes: ART = 5007  ,  MUS = 5009  , Theatre = 5005,                       (4 digits) | 4200
[NAME] (e.g. 800, 1230, or 1800) | 800
Bubbled Course Number                                                 (4 digits) | 3303
Enrollment | 23
Local Code for ART 1301, 1302, 1305, 2301 & 2302 and  MUS 1310, 1341, 1342, 1351, 1361, 1375, 1376 and  TH 1311, 1351, 2331 & 2334 = 0900  or   Honors = 0901                  TH 2345  MUS 2353 = 0200 or  Honors = 0201   (4 digits)
Long (L) or Short (S) Forms | L
Number of Additional Questions to be answered on the Survey  ([NAME]. number of Additional questions that can be asked for Long form = 19 & Short form = 10) | 12
Is this class [NAME]?   Y or N | N
Spreadsheet: 774630d1648575723-repeat-the-same-overtime-hours-on-weekends-every-month-data
Sheet: DATA

Years | Months | Days | Weekend |  | [NAME] |  | Public holidays in Bahrain 2022
2015 | January | 1 | No Weekend |  | False |  | Date | Holiday
2016 | February | 2 | Sat & Sun |  |  |  | 2022-01-01 00:00:00 | New Year's Day
2017 | March | 3 | Sun & Mon |  |  |  | 2022-05-01 00:00:00 | Labour Day
2018 | April | 4 | Mon & Tue |  |  |  | 2022-05-01 00:00:00 | Eid Al Fitr
2019 | May | 5 | Tue & Wed |  |  |  | 2022-05-02 00:00:00
2020 | June | 6 | Wed & Thu |  |  |  | 2022-05-03 00:00:00
2021 | July | 7 | Thu & Fri |  |  |  | 2022-07-09 00:00:00 | Eid Al Adha
2022 | August | 8 | Fri & Sat |  |  |  | 2022-07-10 00:00:00
2023 | September | 9 | Mon Only |  |  |  | 2022-07-11 00:00:00
2024 | October | 10 | Tue Only |  |  |  | 2022-07-30 00:00:00 | Islamic New Year
2025 | November | 11 | Wed Only |  |  |  | 2022-08-06 00:00:00 | Ashura
 | December | 12 | Thu Only |  |  |  | 2022-10-08 00:00:00 | The Prophet's Birthday
 |  | 13 | Fri Only |  |  |  | 2022-12-16 00:00:00 | Bahrain National Day
 |  | 14 | Sat Only
 |  | 15 | Sun Only
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20
 |  | 21
 |  | 22
 |  | 23
 |  | 24
 |  | 25
 |  | 26
 |  | 27
 |  | 28
 |  | 29
 |  | 30
 |  | 31
Spreadsheet: 683770d1592932401-reconciliation-reconciliation
Sheet: Taxes

 | DATE | VALUES | FORMULA I USE
AXXON | 08/01/2019 | -25288.21
AXXON | 08/01/2019 | -9895.15
CHEP ARGENTINA S A | 15/10/2019 | 143.03
AEROPUERTOS | 30/10/2019 | 97679.45
ALLIANZ | 23/10/2019 | -308.56
ALLIANZ | 23/10/2019 | 308.56
[NAME] | 30/08/2019 | 4.03
[NAME] | 30/08/2019 | 18.42
[NAME] | 30/08/2019 | 18.85
PEPITO | [NAME] | 21.64
ASOCIACION CIVIL DE ESTUDIOS SUPERIORES ACES | 13/12/2019 | 13842.1
NORDEX WINDPOWER S.A. | 15/03/2019 | 41.64
[NAME] HUGHES | 15/02/2019 | 47.7
KAPSCH TRAFFICCOM TRANSPORTATION | 10/10/2019 | 95.06
Spreadsheet: 723125d1615530290-reconcile-bank-statement-forumla-reconcile-sample-ans
Sheet: Sheet1

My Register |  |  |  |  |  |  | The Bank
Date | Transaction | Withdrawal | Deposit | Balance | [NAME] | Column1 | Date | Transaction | Withdrawal | Deposit | Balance
 | Starting Balance |  |  | 2000 |  |  |  | Starting Balance |  |  | 2000
2021-02-02 00:00:00 | Electric | 50.44 |  | 1949.56 |  | R | 2021-02-03 00:00:00 | Transaction - Electric Company | 50.44 |  | 1949.56
2021-02-15 00:00:00 | Cable | 49.99 |  | 1899.57 |  | R | 2021-02-18 00:00:00 | Joe's Cable, Inc | 49.99 |  | 1899.57
2021-02-25 00:00:00 | Car | 215.68 |  | 1683.89 |  | R | 2021-02-25 00:00:00 | Car Financer Co. | 215.68 |  | 1683.89
2021-02-26 00:00:00 | Rebate |  | 100.5 | 1784.39 |  | ? | 2021-02-26 00:00:00 | Deposit |  | 100.5 | 1784.39
2021-02-25 00:00:00 | Water Co. | 47.27 |  | 1737.12 |  | R | 2021-02-25 00:00:00 | City Water Company | 47.27 |  | 1737.12
2021-03-02 00:00:00 | Electric | 62.32 |  | 1674.8 |  | R | 2021-03-06 00:00:00 | Transaction - Electric Company | 62.32 |  | 1674.8
2021-03-10 00:00:00 | B-day gift |  | 50 | 1724.8 |  | ? | 2021-03-10 00:00:00 | Deposit |  | 50 | 1724.8
2021-03-15 00:00:00 | Cable | 49.99 |  | 1674.81 |  | R | 2021-03-20 00:00:00 | Joe's Cable, Inc | 49.99 |  | 1674.81
2021-03-25 00:00:00 | Water Co. | 63.89 |  | 1610.92 |  | R | 2021-03-25 00:00:00 | City Water Company | 63.89 |  | 1610.92
2021-03-25 00:00:00 | Car | 215.68 |  | 1395.24 |  | R | 2021-03-26 00:00:00 | Car Financer Co. | 215.68 |  | 1395.24
What I would like is a formula that will: |  |  |  |  |  |  | Dates may differ slightly from what was entered in My Register
- Match date, transaction, and amount, then return "R" in Column F if match or "?" if no match |  |  |  |  |  |  | Transaction may be different but will contain key words in both lists
- Date (I guess month and year; unless can do within x days of the date in my register |  |  |  |  |  |  | The amount will match for the date, but could be different month to month
Spreadsheet: bill_williams_iii__1399__xxxdealenterySeptember
Sheet: 9-15

Saturday
Deal #s | 773603 |  | 773662 | 773612 | 773618 | 773622 | 773640 | 773642
2001-09-15 00:00:00 |  |  | NP | SP | SP | SP | PV | Four Corners
Delivery Pt. | EPMI CA Pool |  | Sale | Sale | Buy | [NAME] | STSW | STSW
Counterparty | NP | SP | EES | EES | EES | CA Imbal | EPMI_CISO_5000 | EPMI_CISO_7000
Totals | -688 | 688 | -6696 | -1008 | 4704 | -400 | 104 | 200
1 | -86 | 86 | -325 | -126 |  |  | 13 | 25
2 | -86 | 86 | -325 | -126 |  |  | 13 | 25
3 | -86 | 86 | -325 | -126 |  |  | 13 | 25
4 | -86 | 86 | -325 | -126 |  |  | 13 | 25
5 | -86 | 86 | -325 | -126 |  |  | 13 | 25
6 | -86 | 86 | -325 | -126 |  |  | 13 | 25
7 | 0 | 0 | -256 |  | 294 | -25
8 | 0 | 0 | -256 |  | 294 | -25
9 | 0 | 0 | -256 |  | 294 | -25
10 | 0 | 0 | -256 |  | 294 | -25
11 | 0 | 0 | -256 |  | 294 | -25
12 | 0 | 0 | -256 |  | 294 | -25
13 | 0 | 0 | -256 |  | 294 | -25
14 | 0 | 0 | -256 |  | 294 | -25
15 | 0 | 0 | -256 |  | 294 | -25
16 | 0 | 0 | -256 |  | 294 | -25
17 | 0 | 0 | -256 |  | 294 | -25
18 | 0 | 0 | -256 |  | 294 | -25
19 | 0 | 0 | -256 |  | 294 | -25
20 | 0 | 0 | -256 |  | 294 | -25
21 | 0 | 0 | -256 |  | 294 | -25
22 | 0 | 0 | -256 |  | 294 | -25
23 | -86 | 86 | -325 | -126 |  |  | 13 | 25
24 | -86 | 86 | -325 | -126 |  |  | 13 | 25
TIE POINTS
Spreadsheet: 135853d1326276424-is-there-better-way-to-write-this-if-statement-book1_gm_jeremy
Sheet: Availability

 |  |  |  |  |  | 1
 |  |  |  |  |  | 1a
 |  |  |  |  |  | 2
 |  |  |  |  |  | 2a
 |  |  |  |  |  | 3
 |  |  |  |  |  | 4
 |  |  |  |  |  | 5
 |  |  |  |  |  | 6
 |  |  |  |  |  | 7
 |  |  |  |  |  | 8
 |  |  |  |  |  | 9
 |  |  |  |  |  | 10
 |  |  |  |  |  | 11
 |  |  |  |  |  | 12
 |  |  |  |  |  | 13
 |  |  |  |  |  | 14
 |  |  |  |  |  | 15
 |  |  |  |  |  | 16
 |  |  |  |  |  | 17
 |  |  |  |  |  | 18
Spreadsheet: 155971d1337119154-count-of-unique-stores-in-a-group-storecountsample-1-
Sheet: Answer

Group Name | 100 | 101 | 102 | 103 | Count of Stores
ABC | 1 | 0 | 0 | 0 | 1
DEF | 0 | 1 | 0 | 0 | 1
GHI | 0 | 0 | 1 | 0 | 1
JKL | 0 | 0 | 0 | 1 | 1
Spreadsheet: 774985d1648748977-look-up-and-retrieve-indirect-example
Sheet: Mar 2022

ID # | Team A Maintenance Hours | Team B Maintenance Hours | Total [NAME]
GG984 | 23.2 | 45
GG447 | 45.5 | 77
OP456 | 78.8 | 105.2
HT444 | 4.4 | 78.4
[NAME] | 3 | 14
WE123 | 0 | 12
WR144 | 0 | 54
Spreadsheet: 103602d1301345967-automated-shipping-estimator-daily_rates-1-
Sheet: UPS CWT Tier 5

 |  |  |  |  |  |  |  |  | 2011 Rates
 | Domestic
 | UPS Hundredweight Service Tier 5
 | Guaranteed Delivery Service Options
 | UPS Next Day Air |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Pound
 | Zones | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 124 | 125 | 126
 | 100 Lbs. or more | 1.45 | 2.06 | 3.15 | 3.5 | 3.85 | 3.97 | 4.16 | 4.3 | 4.04 | 4.76
 | UPS Next Day Air Saver |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Pound
 | Zones | 132 | 133 | 134 | 135 | 136 | 137 | 138 | Service Not Available
 | 100 Lbs. or more | 1.19 | 1.73 | 3.06 | 3.37 | 3.53 | 3.71 | 3.88
 | UPS 2nd Day Air A.M. |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Pound
 | Zones | 242 | 243 | 244 | 245 | 246 | 247 | 248 | Service Not Available
 | 100 Lbs. or more | 0.99 | 1.1 | 1.43 | 2.01 | 3.07 | 3.45 | 3.56
 | UPS 2nd Day Air |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Pound
 | Zones | 202 | 203 | 204 | 205 | 206 | 207 | 208 | 224 | 225 | 226
 | 100 Lbs. or more | 0.85 | 0.97 | 1.25 | 1.75 | 2.76 | 3.08 | 3.19 | 3.28 | 2.97 | 3.64
 | UPS 3 Day Select |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Hundredweight Unit
 | Zones | 302 | 303 | 304 | 305 | 306 | 307 | 308 | Service Not Available
 | 200 to 499 Lbs. | 39.5 | 45.55 | 52.9 | 62.4 | 104.65 | 143.45 | 159.7
 | 500 to 999 Lbs. | 37.85 | 42.9 | 50 | 60.25 | 100.7 | 137.35 | 152.95
 | 1,000 Lbs. or more | 39.55 | 44.7 | 52.1 | 62.75 | 104.9 | 143 | 159.1
 | [NAME] |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Hundredweight Unit
 | Zones | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 44 | 45 | 46
 | 200 to 499 Lbs. | 27.65 | 34.8 | 38.85 | 45.85 | 57.9 | 66.85 | 77.8 | 211.5 | 211.5 | 247.75
 | 500 to 999 Lbs. | 25.3 | 31.55 | 35.25 | 41.8 | 52.65 | 60.95 | 70.95 | 192 | 192 | 224.2
 | 1,000 Lbs. or more | 25.7 | 32.1 | 36.1 | 42.8 | 53.8 | 62.35 | 72.55 | 195.5 | 195.5 | 228.85
 | Minimum Charges
 | UPS 3 Day Select Zones |  |  | 302 | 303 | 304 | 305 | 306 | 307 | 308 | Service Not Available
 | Minimum Charge |  |  | 47 | 47 | 47 | 47 | 47 | 47 | 47
 | [NAME] |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 44 | 45 | 46
 | Minimum Charge |  |  | 41 | 41 | 45 | 45 | 45 | 45 | 45 | 225 | 225 | 275
Spreadsheet: 1a1c6965-4a0f-4d8b-9841-5282ac67fcaa
Sheet: Unit Sales

District | Pack (Pxxx), Troop ([NAME]), [NAME] (Cxxx) | Scout's Name | Scout's Address | Scout's City | Zip | Phone | [NAME] | Total Amount Sold | Free 2013 Camp (Yes or No) | $600 Brewers Voucher | $1,000 Waterpark Passes | $100 Batteries &  $1000 Popcorn Entry $100 [NAME] | $3,500 Brewers Premier | $5,000 iPad | $6,500 GreatWolf Trip | $10,000 Disney World |  | District Validation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Exploring | Yes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fox River | No
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gateway
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Heart of Milwaukee
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Iron Horse
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lighthouse
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Root River
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Southshore
 |  |  |  |  |  |  | UNIT GRAND TOTAL
 |  |  | Total Unit Sales in Spring 2012 |  |  | Sales Change ($) |  |  | Unit Bonus Commission Percentage
 |  |  | Total Unit Sales in Spring 2013 |  |  | Sales Change (%) |  |  | Unit Bonus Commission Amount
 |  |  |  |  |  |  |  |  | Leader [NAME] (Yes or No)