tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_germany__1813__strg_proxy
Sheet: Sheet2

 | LDC | COH on TCO |  | AGL on Sonat-CSS |  | AGL on Transco-ESS |  | AGL on Transco-WSS
 | Quantity | 5926834.1525328 | dth | 870208 | dth | 7503 | dth | 396361 | dth
 |  | Inject % | Withdrawal % | Inject % | Withdrawal % | Inject % | Withdrawal % | Inject % | Withdrawal %
 | 2000-04-01 00:00:00 | 0.13 | 0 | 0.15 | 0 | 0.15 | 0 | 0.14 | 0
 | 2000-05-01 00:00:00 | 0.18 | 0 | 0.15 | 0 | 0.15 | 0 | 0.15 | 0
 | 2000-06-01 00:00:00 | 0.18 | 0 | 0.15 | 0 | 0.15 | 0 | 0.15 | 0
 | 2000-07-01 00:00:00 | 0.18 | 0 | 0.15 | 0 | 0.14 | 0 | 0.14 | 0
 | 2000-08-01 00:00:00 | 0.18 | 0 | 0.15 | 0 | 0.14 | 0 | 0.14 | 0
 | 2000-09-01 00:00:00 | 0.13 | 0 | 0.15 | 0 | 0.14 | 0 | 0.14 | 0
 | 2000-10-01 00:00:00 | 0.02 | 0 | 0.1 | 0 | 0.13 | 0 | 0.14 | 0
 | 2000-11-01 00:00:00 | 0 | 0.15 | 0 | 0.15 | 0 | 0.15 | 0 | 0.15
 | 2000-12-01 00:00:00 | 0 | 0.2 | 0 | 0.2 | 0 | 0.2 | 0 | 0.24
 | 2001-01-01 00:00:00 | 0 | 0.25 | 0 | 0.25 | 0 | 0.25 | 0 | 0.24
 | 2001-02-01 00:00:00 | 0 | 0.25 | 0 | 0.25 | 0 | 0.25 | 0 | 0.18
 | 2001-03-01 00:00:00 | 0 | 0.15 | 0 | 0.15 | 0 | 0.15 | 0 | 0.19
 | Total
 |  |  |  | AGL on Sonat-CSS
 |  |  |  | 870208
 |  |  |  | Inject %
 |  |  |  | 0.15
 |  |  |  | 0.15
 |  |  |  | 0.15
 |  |  |  | 0.15
 |  |  |  | 0.15
 |  |  |  | 0.15
 |  |  |  | 0.1
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
Spreadsheet: 787056d1657621078-formula-to-calculate-risk-2022-07-12-oeldere-joenuhbanana-formula-help
Sheet: Sheet1

With Date | Lead time | Stock Level | Cover | 2 month stock cover date | Expected Stock Out Date | Delivery Date | What this should be
 | 5 | 0 | 0 | 2022-05-13 00:00:00 | 2022-07-12 00:00:00 | 2022-07-29 00:00:00 | Out of Stock
 | 5 | 2000 | 4 | 2022-09-10 00:00:00 | 2022-11-09 00:00:00 | 2022-09-03 00:00:00 | Good Stock Level
 | 5 | 2000 | 8 | 2022-09-10 00:00:00 | 2022-11-09 00:00:00 | 2022-09-03 00:00:00 | Good Stock Level
 | 5 | 500 | 1 | 2022-06-12 00:00:00 | 2022-08-11 00:00:00 | 2022-09-03 00:00:00 | Will Go OOS
 | 5 | 1000 | 2 | 2022-07-12 00:00:00 | 2022-09-10 00:00:00 | 2022-08-24 00:00:00 | Risk of OOS
No Date | Lead time | Stock Level | Cover | 2 month stock cover date | Expected Stock Out Date | Delivery Date | What this should be
 | 5 | 0 | 0 | 2022-05-13 00:00:00 | 2022-07-12 00:00:00 |  | Out of Stock
 | 5 | 2000 | 4 | 2022-09-10 00:00:00 | 2022-11-09 00:00:00 |  | Will Go OOS
 | 5 | 2000 | 8 | 2022-09-10 00:00:00 | 2022-11-09 00:00:00 |  | Good Stock Level
 | 5 | 500 | 1 | 2022-06-12 00:00:00 | 2022-08-11 00:00:00 |  | Will Go OOS
 | 5 | 1000 | 2 | 2022-07-12 00:00:00 | 2022-09-10 00:00:00 |  | Will Go OOS
Rule | Status
if Stock Level = 0 | Out of stock
if cover is higher than lead time +2 | Good stock level
if delivery date is after expected stock out date | Will go OOS
if delivery date is after the 2 month stock cover date | Risk of OOS
Spreadsheet: 95451d1295030818-need-formula-to-check-multiple-conditions-and-return-specific-value-project1
Sheet: Sheet1

 | gallons Liquid 1 | [NAME] | Total [NAME] | Total Miles |  | Exceptions | Cost of Salt | Cost  of   Anti-Skid | Total Cost of Granular Material | Cost Of Brine | Total Cost of Material | Number of Events | LBS/Event | Number of days material used | Five year average of LBS/SLM/Event | Calculated CMMT score
Place 1 | 112078.8 | 9394.400000000003 | 8135.860000000001 | 126002.41 |  | 61 | 516222.28 | 127698.0211 | 643920.3011 | 23536.548 | 667456.8491000001 | 17 | 498.5193040596519 | 38 | 455
Place 2 | 64700.5 | 7789.380000000001 | 5901.35 | 95227.8 |  | 39 | 373734.4524 | 108171.7455 | 481906.1978999999 | 13587.105 | 495493.3029 | 32 | 406.2713068181818 | 37 | 519
Place 3 | 200030.3 | 11620.973 | 6222.032999999999 | 150711.696 |  | 102 | 748158.2417399999 | 84310.1312 | 832468.3729399998 | 42006.36299999999 | 874474.7359399998 | 20 | 621.9220908525203 | 44 | 599
Place 4 | 55603.6 | 4802.3325 | 7515.8225 | 83939.98000000001 |  | 28 | 237667.435425 | 95751.01595 | 333418.4513750001 | 11676.756 | 345095.2073750001 | 30 | 302.4650900900901 | 41 | 480
Place 5 | 37837.1 | 7568.27475 | 8774.30025 | 77539.02 |  | 5 | 444484.7760675 | 159426.321425 | 603911.0974925001 | 7945.791 | 611856.8884925 | 25 | 414.9810181311019 | 44 | 572
Spreadsheet: 2841a08e-f1e3-4a0e-9132-ad25eeac9b0f
Sheet: High Level Summary

High Level Summary Document  - SADPs
 | Insurance Company:
 | Market:
 |  |  | Total
 | Total Number of Plans
 | Number of Plans by Exchange Intentions
 | On Exchange
 | Both On and Off Exchange
 | Off Exchange
 | Total (should equal Total Number of Plans above)
 | Number of Plans By Metal Level
 | Low (70% AV)
 | High (85% AV)
 | Total (should equal Total Number of Plans above)
 | Number of Plans by Plan Type
 | PPO
 | HMO
 | POS
 | EPO
 | Total (should equal Total Number of Plans above)
 | Number of Plans by Service Area
 | Statewide
 | Not Statewide*
 | Total (should equal Total Number of Plans above)
 | *If not all Statewide - Number of Counties
 | [NAME] of Counties in Service Area
 | Total Number of Counties Served
 | Insurer Notes:
 | General Notes:
▪ | [NAME] number of counties in a Service Area - for example, if all Service Areas have 5 counties, enter 5.  If one has 8 counties and others have 5, enter 8
▪ | Add up number of counties served across all Service Areas and enter here (for example 5 Service Areas with 5 counties each that don't overlap = 25)
 | Submit in Excel format in SERFF filing under Supporting Documents.
Spreadsheet: 7458b497-f967-4234-9d1a-285a415199e6
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FACTV | Test | FACTV | Coagulation Factor V Activity Assay, Plasma | Coag Factor V Assay, P | [NAME] Assay | Light blue-top (citrate) tube: LgtBlu |  |  | 1 | mL | See Coagulation Studies in Special Instructions.   Specimen Type: Platelet-poor plasma Collection Container/Tube: Light-blue top (citrate) Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: 1. Spin down, remove plasma, and spin plasma again.  2. Freeze specimen immediately at < or =-40 degrees C, if possible. Additional Information: 1. Double-centrifuged specimen is critical for accurate results as platelet contamination may cause spurious results. 2. Patient must not be receiving [NAME] or heparin therapy. 3. Each coagulation assay requested should have its own vial. 4. If priority specimen, mark request form, give reason, and request a call-back. 5. Coagulation testing is highly complex, often requiring the performance of multiple assays and correlation with clinical information. For that reason we suggest ordering Coagulation Consultations. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | Adults: 70-165% Normal, full-term newborn infants may have borderline low or mildly decreased levels (> or =30% to 35%) which reach adult levels within 21 days postnatal. Healthy premature infants (30-36 weeks gestation) may have borderline low or mildly decreased levels.* *See Pediatric Hemostasis References in Coagulation Studies in Special Instructions. | Monday through Friday | 1 day | 2 days | 1 | 85220 |  |  |  |  | Rochester
FACTV | [NAME] | NACIT | [NAME] |  |  |  | Frozen | 14 days
FACTV | Result | FACTV | Coag Factor V Assay, P | Coag Factor V Assay, P | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 3193-0 | Coagulation factor V activity actual/Normal:RelTime:Pt:PPP:Qn:Coag
Spreadsheet: 0fcff1b8-bc39-4158-a8d2-e5a92714d0f5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | International Taekwon-Do Federation | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | International Instructor Course
 |  |  | Individual Application Form
 |  | City: | [NAME] |  | Country: | Jamaica
Participant:
 | name |  |  |  | surname |  |  | M/F
Address:
 | street |  |  |  | number | code | city
Date of Birth: |  |  |  |  | Nationality:
 | year | month | day
e.mail:
actual kup/degree |  |  |  |  | ITF degree number: |  | -    -
signature:
Participants Instructor and/or Master:
 | name |  |  |  | surname
Plaque Certificate number: |  |  |  |  | ITF degree number: |  | -    -
e.mail:
signature:
Organiser: | Jamaica Taekwon-Do Association
(Federation/Association name)
President:
 | [NAME] |  |  |  | Barrows
 | name |  |  |  | surname
e.mail contact: | [EMAIL]
signature:
date of event: | 2012 | July | 24-28
 | year | month | day
NOTE:
This aplication will not be acepted without the proper plaque and certificate numbers.
Spreadsheet: 0fe7d2cb-ab2b-4eab-b5a7-883825a563a2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-03-13 11:24:14.310000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.578 | 102.453 | 102.328 | 101.953
4.5 | 101.638 | 101.513 | 101.388 | 101.013 |  | Note: | Refer To Price [NAME]
4.375 | 100.648 | 100.523 | 100.398 | 100.023 |  |  | For all Price Adjs
4.25 | 100.047 | 99.922 | 99.797 | 99.172
4.125 | 99.206 | 99.081 | 98.956 | 98.331
4 | 98.176 | 98.051 | 97.926 | 97.301
3.875 | 97.111 | 96.986 | 96.861 | 96.236
3.75 | 96.236 | 96.111 | 95.986 | 95.361
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.875 | 102.75 | 102.625 | 102.25
3.875 | 102.875 | 102.75 | 102.625 | 102.25
3.75 | 102.633 | 102.508 | 102.383 | 102.008
3.625 | 102.232 | 102.107 | 101.982 | 101.607
3.5 | 101.656 | 101.531 | 101.406 | 100.781
3.375 | 100.905 | 100.78 | 100.655 | 100.03
3.25 | 100.116 | 99.991 | 99.866 | 99.241 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-03-27 11:24:14.310000
30 DAY | 2014-04-11 11:24:14.310000
45 DAY | 2014-04-26 11:24:14.310000
60 DAY | 2014-05-11 11:24:14.310000
90 DAY | 2014-06-10 11:24:14.310000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 882869d1731347978-copying-creating-a-zipcode-postcode-distance-checker-assistance-postcode-distance-checker
Sheet: NA_PostCodes

PostCode | County or Area | Latitude | Longitude
10001 | New York | 40.7484 | -73.9967
10002 | New York | 40.7152 | -73.9877
10003 | New York | 40.7313 | -73.9892
10004 | New York | 40.7143 | -74.006
10005 | New York | 40.7056 | -74.0083
10006 | New York | 40.7085 | -74.0135
10007 | New York | 40.7139 | -74.007
10008 | New York | 40.7143 | -74.006
10009 | New York | 40.7262 | -73.9796
1001 | Massachusetts | 42.0702 | -72.6227
Spreadsheet: 124269d1318279215-problem-using-conditional-formatting-to-flag-cells-by-color-and-count-them-example3
Sheet: SUMMARY

PROVIDER | YELLOW | ORANGE | RED | COMPLIENT | TOTAL | PERCENTAGE COMPLIENT
Alindada | 0 | 3 | 3 | 3 | 6 | 0.5
Hooker | 0 | 2 | 1 | 2 | 3 | 0.6666666666666666
Narula | This one | quit working
[NAME] | 2 | 2 | 1 | 4 | 5 | 0.8
Color Code:
 | Red = Charts > 30 Days
 | Orange = Charts > 20 Days
 | Yellow = Charts > 15 Days
The count was off for the yellow and orange, but after playing with the numbers the +19 for yellow and +29 for the orange appears to be working.
Is there a way to get the spreadsheet to find the complient totals? Anything in yellow, or orange, or that has an in-date but has not been color coded is considered
to be complient.
Thank you so much for all of your genius!
Spreadsheet: 541715d1507523020-conditional-formatting-test-sample
Sheet: Sheet1

 |  | A | B | C | D
 | Q1 | 5 | 6 | 7 | 8 | C
 | Q2 | 4 | 5 | 6 | 6 | B
 | Q3 | 6 | 3 | 4 | 1 | D
 | Q4 | abc | def | pqr | xyz | A
Spreadsheet: 860167d1708368441-create-a-kpi-dashboard-from-multiple-sheets-samplenew
Sheet: Hamburger

[NAME] | Case Weight | Speed | Dough Size 1 | Ounces | Theo Units per Dough |  |  |  | Units per tray |  | Tray per Dough
2.9 | 10.875 | 40 | 191.86 |  |  |  |  |  | 60
 |  | 10 Pocket
 |  | 10
Product | Date | Do's ran | Dough Size | Total Weight(lbs) | [NAME] (hrs) | [NAME] | [NAME] | [NAME] | Pack Stop | [NAME] | Total RT | Theo Pieces | Actual Pieces | [NAME] | Total Cases | Extra | Actual Case Yield | Eff % | Waste % | Overall Eff | Units Per Hour
Hamburger | 2024-01-30 00:00:00 | 0 | 0 |  |  | 00:00:00 | 00:00:00 |  | 00:00:00 | ? |  |  |  |  | 0 | 0
Hamburger | 2024-01-31 00:00:00 | 0 | 0 |  |  | 00:00:00 | 00:00:00 |  | 00:00:00 | ? |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average:
Spreadsheet: 471940d1469306457-need-help-keeping-a-log-of-values-that-change-every-day-income-tracker
Sheet: PRECIOUS

 |  |  |  | Silver Holdings |  |  |  |  |  | Total Silver
 |  |  |  | Type | Weight | Count | % Silver | Total
 |  |  |  | [NAME] bar | 1 | 2 | 1
 |  |  |  | Silver eagle | 1 | 1 | 1
 |  |  |  | Silver Half | 0.36 | 1 | 1
 |  |  |  | Silver Dime | 0.07 | 1 | 1
 |  |  |  | Peace Dollar | 0.7734 | 2 | 1
 |  |  |  | Morgan Dollar | 0.85938 | 1 | 0.9
Spreadsheet: 0338a664-235b-4ab8-918b-3f3c1b675ed2
Sheet: Sheet1

2012 GENERAL ELECTION | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
[NAME] | CANDIDATE | ADDRESS | TELEPHONE NUMBER | PARTY | INCUMBENT
NC State Senate | [NAME] | 1158 C.P. Stewart Road | [PHONE] H) | Dem | No
District 12 |  | [NAME], NC  27546
2 year term
1 Seat | [NAME] | 383 Falling Water Road | [PHONE] (H) | Rep | No
 |  | Spring Lake, NC  28390 | [PHONE] (Cell)
NC House of Rep | [NAME] ([NAME]) Tatum | 2511 Wellington Dr | [PHONE] (H) | Dem | No
District 051 |  | Sanford, NC  27330 | [PHONE] (C)
2 year Term
1 Seat | [NAME] ([NAME]) Stone | 1123 Winterlocken Dr | [PHONE] (C) | Rep | Yes
 |  | Sanford, NC  27330
NC House of Rep | Deb McManus | 11 Pine Forest Drive | [PHONE] (H) | Dem | No
District 54 |  | PO Box 508 | [PHONE] (W)
2 year Term |  | Siler City, NC  27344
1 Seat
 | [NAME] | 51315 Eastchurch | [PHONE] (H) | Rep | No
 |  | Chapel Hill, NC  27517
District Attorney | [NAME] | 301 W. Cornelius Narnett Blvd. | [PHONE] | Dem | Yes
District 11A |  | [NAME], NC  27546
4 Year Term
1 Seat
County Commissioner - | [NAME] | 809 [NAME] | [PHONE] (H) | Rep | No
at-Large |  | Sanford, NC  27330 | [PHONE] (W)
4 Year Term
3 Seats | [NAME] | 425 Rolling Hill Road | [PHONE] (H) | Rep | No
 |  | Sanford, NC  27330 | [PHONE] (W)
 | [NAME] | 3108 Avents Ferry Road | [PHONE] (H) | Rep | No
 |  | Sanford, NC  27330
 | [NAME] | 1449 Dalrymple Farm Road | [PHONE] (H) | Dem | No
 |  | Sanford, NC  27330 | [PHONE]  (C)
 | [NAME] | 124 S. Plank Road | [PHONE] (H) | Dem | No
 |  | Sanford, NC 27330 | [PHONE] (C)
 | [NAME] | 608 Valley Road | [PHONE] (H) | Una | No
 |  | Sanford, NC  27330 | [PHONE] (W)
Register of Deeds
4 Year term | [NAME] | 4500 [NAME] | [PHONE] (H) | Dem | Yes
1 Seat |  | Sanford, NC  27330
Soil and Water | [NAME] | 243 [NAME] | [PHONE] (C) | Una | No
4 Year term |  | Sanford, NC  27330
1 Seat
 | [NAME] (Tommy) Dalrymple | 1449 Dalrymple Farm Rd | [PHONE] (H) | Dem | Yes
 |  | Sanford, NC  27330
Spreadsheet: 65030d1265805474-auto-update-or-resync-values-in-data-validated-lists-elec-toolkit-v6
Sheet: Motor Calcs (ManFc Specific)

 |  | Voltage | 400 | V |  | Optional Motor Data
 |  | Power Factor | 0.86 |  |  | Rated Speed | 1455 | rpm
 |  | Motor Efficiency | 80 | % |  | Mass for Fly Wheel |  | Kg
 |  |  |  |  |  | Outer Radius |  | m
 |  | Power |  | KW |  | [NAME] |  | m
 |  | Current | 10 | A
 | Current Calculation |  |  |  |  | Moment of Inertia | 0 | Kgm2
 |  |  |  | Starting Currents
 | Current (FLC) | 0 | A | 0 | A (DOL Inrush Current)
 |  | 0 | KVA | 0 | A (VSD Inrush Current)
 | Motor Torque | 0 | Nm | 0 | A (Star/Delta Inrush Current)
 |  |  |  | 0 | A (Soft Start Inrush Current)
 | Power Calculation
 |  |  |  | Starting Currents
 | Power | 4.766603822429558 | KW | 80 | A (DOL Inrush Current)
 |  | 5.542562584220416 | KVA | 15 | A (VSD Inrush Current)
 | Motor Torque | 31.28595636027648 | Nm | 35 | A (Star/Delta Inrush Current)
 |  |  |  | 22 | A (Soft Start Inrush Current)
Spreadsheet: don_baughman__8649__5ndxtemplate
Sheet: Sheet1

HOURLY DEALS
TradersNews
Cinergy hub
Fax: [PHONE]
Phone: [PHONE]
or [PHONE]
Note: | Please send to: | [EMAIL]
No bal-day deals
No pre-scheduled
 | DATE:
 | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | WACOP | LOW | HIGH | Location
CINERGY
PEAK
Hour Ending:
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
AEP
PEAK
Hour Ending:
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Entergy
PEAK
Hour Ending:
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
TVA
PEAK
Hour Ending:
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
ComEd
PEAK
Hour Ending:
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Spreadsheet: 861116d1709092640-remove-ap-team-rank-from-college-basketball-team-name-removeparentheseswithnumbersonly
Sheet: PROBLEM

DATA SET | TRIM FORMULA | DESIRED RESULT | Hey, [NAME]. I have here another tricky problem. Data in Column A has been pulled from a website.
 |  |  | Unfortunately, the way it's formatted does not suit my purposes. I would like to remove (TRIM)
Northern Arizona |  |  | the parentheses with numbers only, keeping the parentheses that enclose letters. In this case (NY).
Stonehill |  |  | I used a TRIM formula and it removes both the parentheses enclosing numbers and enclosing letters.
Mississippi Valley State |  |  | Colum A is the data I'm starting with, Column C is my desired result. Column B is the best my novice
Indiana |  |  | Excel skills can accomplish. Thanks, yet again, in advance.
Texas (15)
Manhattan
New Hampshire
Kansas (5)
North Carolina (9)
Arkansas-Pine Bluff
Gonzaga (10)
[NAME]
St. John's (NY) |  | St. John's (NY)
[NAME]
Butler
Xavier
Georgetown
Creighton (18)
Villanova
Xavier
Providence
St. John's (NY) |  | St. John's (NY)
Butler
Georgetown
[NAME]
Marquette (4)
Creighton (15)
Villanova
[NAME]
Marquette (5)
Providence
Spreadsheet: 35529d1233145602-excel-macro-to-e-mail-through-outlook-to-multiple-recipients-maintable
Sheet: Sheet1

Week | 41
 | Agent1 | Agent2 | Agent3 | Agent4 | Agent5 | Agent6 | Agent7 | Agent8 | Agent9 | Agent10 | Agent11 | Agent12 | Agent13 | Agent14
 | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL] | [EMAIL]
Sales | 2 | 5 | 4 | 85 | 4 | 4 | 8 | 9 | 6 | 54 | 12 | 25 | 11 | 47
Wrap | 0.45 | 0.52 | 0.36 | 0.54 | 0.78 | 0.52 | 0.36 | 0.54 | 0.86 | 0.63 | 0.33 | 0.21 | 0.45 | 0.05
Prompts | 0.68 | 0.65 | 0.52 | 0.58 | 0.85 | 0.66 | 0.52 | 0.69 | 0.99 | 0.85 | 0.65 | 0.24 | 0.58 | 0.22
Payments Collected | 654 | 654 | 8465 | 841 | 468 | 684 | 6542 | 8448 | 84 | 684 | 6541 | 654 | 5468 | 841
MDD setup | 2 | 5 | 7 | 5 | 9 | 7 | 8 | 9 | 6 | 3 | 2 | 5 | 8 | 7
Paperwork | 25 | 25 | 65 | 89 | 66 | 65 | 64 | 68 | 69 | 99 | 63 | 65 | 25 | 63
Comment | Well Done | Good | Bad | Well Done | Good | Bad | Well Done | Good | Bad | Well Done | Good | Bad | Well Done | Good
Team Comment | Keep up the good work team,
Spreadsheet: 03475a33-cf31-43f4-b123-287c852eda8d
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
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 3. COMMERCIAL AND LEASE FINANCE COMMITMENTS By Lender: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Commercial Finance - Banks ; |  |  | Original | A2413463V | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Commercial Finance - Money market corporations ; |  |  | Original | A2413464W | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Commercial Finance - Finance companies ; |  |  | Original | A2413465X | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Commercial Finance - Other lenders ; |  |  | Original | A2413466A | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Commercial Finance - Total ; |  |  | Original | A2413467C | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Lease Finance - Banks ; |  |  | Original | A2413468F | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Lease Finance - Finance companies ; |  |  | Original | A2413469J | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Lease Finance - General financiers ; |  |  | Original | A2413470T | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Lease Finance - Other lessors ; |  |  | Original | A2413471V | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Lease Finance - Total ; |  |  | Original | A2413472W | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 131737ca-272a-4a5f-8e05-2cccc836b440
Sheet: Manhattan Elevated

Car Numbers | Type | Builders | Years Built | Notes
Summary of cars operated on the Manhattan Elevated lines under Interborough Rapid Transit ownership, excluding cars transfered from the subway lines.
1-39 | Trailers | Pullman | 1885
40-241 | Motors | Wason, ACF | 1901-1903
243-369 | Trailers | [NAME], Bowers & Dure, Pullman | 1879-1889
370-500 | Motors | [NAME] | 1886-1887
501-675 | Trailers | Barney & Smith, Pullman | 1878-1879
676-699 | Trailers | Pullman | 1880
700-728 | Motors | Pullman | 1880
729-790 | Trailers | Pullman | 1880-1881
791-1120 | Motors | Pullman, Gilbert & Bush, Wason | 1881-1893
1121-1254 | Trailers | ACF, [NAME] | 1902-1903 | *
1255-1314 | Motors | Wason | 1903 | *
1314-1528 | Trailers | Wason, St. Louis | 1904-1908 | *
1529-1672 | Motors | Wason, Barney & Smitih, [NAME] | 1907-1910 | *
1673-1752 | Trailers | Wason, St. Louis | 1909-1911 | *
1753-1812 | Motors | Jewett, Cincinnati | 1911 | *
* = Various cars in these classes converted to MUDC door control, 1923-1924