text:
WordPress IDX MLS Real Estate Websites IDX Broker Adwords Certified
United States - Last active: 5 days ago - Tests: 7 - Portfolio: 3
GOOGLE ADWORDS CERTIFIED PARTNER Over the last 4 years, I have been involved in tech support for realtors and real estate brokers all over the US and Canada. I have developed a system to quickly provide world-class sites for Real Estate agents. I am a developer partner with IDX broker and can provide SEO optimizations for IDX or MLS integration to your site. I work on WordPress and all of my work is Mobile Responsive. I am also adwords certified if you want to do a PPC campaign and use the Google adword tools to get leads. You can see my certification here: https://www.google.com/partners/#i_profile;idtf=103060124733081245635; We are adding some great RETS products and services, so if you need help with RETS in the US or Canada, we can help. If you want to have someone learn while they are working with you, there are a lot of folks out there. If you want someone who works exclusively on real estate then give me a shout! We can work with IDX Broker and integrate IDXBroker to your websites and get you plenty of Google Juice!
- WordPress
- Real Estate IDX
- MLS Consulting
- MySQL Administration
- phpMyAdmin
- Spanish
- Search Engine Optimization (SEO)
- Inbound marketing
- Marketing strategy
- Google Analytics
- Web design
- Content Management
- Website Development
Associated with: RealSocialPros Agency
International Support Director/Administrative Asst/Phone Support
Philippines - Last active: 2 days ago - Tests: 12 - Portfolio: 14
To engage my skills and experience in administrative support, customer service and general transcriptions with a timetable I can manage to pursue self growth and achieve personal career development while continuing to support my family and kids.
Real Estate Expert/ Data Entry Professional/ Title Search/ MLS Listing
United States - Last active: 8 days ago - Tests: 7 - Portfolio: 11
For 10 years, I have been associated with US Real Estate work. I specialize in commercial/ residential real estate, mortgage loan processor (lien release data entry), property title search, deed for contract research, land data research, research data entry with WordPress. I worked for numerous clients doing all forms of Real Estate assistance which is my strongest point. Expert in data entry work with great speed and accuracy level.
Real Estate Analyst and Researcher
Pakistan - Last active: 1 month ago - Tests: 6 - Portfolio: 8
Seeking a position where I can maximize my skills in a demanding work environment. I have been in Real Estate for more than 2 years, and have loved every minute of it. I believe that loving what you do makes for more success in all aspects of the profession. I have much experience in most of the aspects of the US real estate industry. Proven ability to collect and manage information efficiently and accurately. Excellent analytical, observational, data interpretation and communication skills and a strong desire to work hard and perform well. Accurate, fast keying skills and sound knowledge of computer applications. Skilled in planning and organizing with the ability to complete tasks on deadline. • Experienced in Real estate market research and comparative market analysis. • Effective communicator. • Quick learner and welcomes new challenges. • Result oriented with great interpersonal skills. Service Description: Real Estate Analysis Real Estate Research Property Tax Records Research Comparative Market Analysis Proficient in using different MLS systems
"Virtual Assistant" Advertiser/Designer/Evaluator/MLS Listings/BPO/CMA
Pakistan - Last active: 1 day ago - Tests: 6 - Portfolio: 1
Professional and experienced Virtual Assistant looking to be hired. I have professional experience working on Advertising, Designing, Classified Posting & Publishing, I'm familiar with Postlets, RentLinx, Zillow, Trulia, ListHub, Yougotlistings, Apartments.com, TeamLeader KWLS & Craigslist Expert as well. Throughout my career I've worked with many Real Estate Professionals: Realtor's, Brokers & Investors. I have full command on MLS Listings, BPO/MMR & CMA for the past few years. I have worked as Multiple Listing Service Coordinator and created more than 220 MLS Listings. I have also worked in areas such as; Inbound & Outbound Calls, Research, Lead Generation, CRM and Email Response Handling & Marketing. If hired by your company, I will put my creative and entrepreneurial capacity and earn prospects for your company.
India - Last active: 1 day ago - Tests: 9 - Portfolio: 25
Expert Web Developer with strong experience in Web 2.0, PHP5, Wordpress, Joomla, Drupal, MySQL, HTML5, RETS/IDX, Real Estate, Mobile Apps, iOS, Android, Responsive Design, node.js and AngularJS. CRM Consultant. Expert in Real Time updates, Betting, Odds, Betting Sites, Forex Sites, Trading Sites. Online Marketing Consultant with strong SEO, SEM, PPC, SMO, SMM, Google Adwords & Google Analytics skills. RETS MLS Listing Integration. Server administration over cPanel, Plesk & SSH.
- MySQL Administration
- Joomla!
- WordPress
- Drupal
- Magento
- Adobe Business Catalyst
- Search Engine Optimization (SEO)
- Google Analytics
- Yahoo! Search Marketing
- Plesk
- Ubuntu
- Linux System Administration
- CPanel
- Social Media Marketing
- CentOS
- iOS Development
- iPhone App Development
- Django
- Python
- Google Maps API
- Google Analytics API
- Cocoa
- Cocoa Touch
- Eclipse
- Android App Development
- vicidial
- Real Estate IDX
- MLS Consulting
Groups: Bluehost Developers and Designers, concrete5...
Associated with: Matrix Marketers Agency
YII 2, Angular JS, Laravel 5, MEAN, Django, PHP,, MySQL, MongoDB, CSS3
India - Last active: 25 days ago - Tests: 4 - Portfolio: 6
6 years of experience in web applications development following RDBMS practices. For last 1 year, I am working on MongoDB based applications and have focused on writing optimized queries using Memcache. PHP based MVC frameworks which I have worked upon are - Laravel 5/1 YII 2/1 ZF2 Cake PHP Code Igniter Other server side scripting languages that I have used are - C# Python Ruby Client side scripting languages / UI frameworks that I have used are - Angular JS Node JS Jquery Backbone JS HTML 5 CSS 3 Have worked on real estate portals, e-learning (LMS) portals, e-commerce portals, multi store marketplaces, web directories, B2B portals, B2C portals, price comparison portals, business automation sales CRM portals, inventory management & order management software, healthcare and clinical web solutions, social media analytical portals, social networking and dating portals, cloud based commercial web applications etc. Mostly I have worked with North American and Pan Pacific customers to deliver them custom business solutions catering to their needs. Currently I am following MEAN (MongoDB, Express JS, Angular JS and Node JS) development environment to design high performance SPA and NoSQL based large scale applications.
Associated with: Talentelgia Technologies Pvt. Ltd.
Expert Real Estate Appraiser & Deals Analyzer, Quickbooks Specialist
Pakistan - Last active: 12 days ago - Tests: 7
My aim is to prove my capabilities through excellent performance. I want to be one of the best online service providers. I have been working in the US real estate as assistant to residential appraisers and deals analyzer for residential investment companies for over past 5 years. I also have work experience in accounting & finance field for over 10 years. I have done many Quickbooks related jobs till date. I have been working for many US Real Estate Appraisal Companies for over 5 years. I am well trained and expert in preparing appraisal reports from scratch till the end. I am expert in researching data on various MLS systems as well as other web resources. I have helped my employers find amazing investment deals which generated huge returns. I am very good at analyzing potential deals, offer submissions, negotiating and closing deals. I want to achieve more & more practical experience. Obviously earning is also one of the main objectives but learning to me is the prime objective. My strength is my competency and my devotion towards the duties awarded to me.
- Real Estate Appraisal
- MLS Consulting
- Real Estate IDX
- Administrative Support
- Intuit QuickBooks
- Peachtree Accounting
- Accounting
- Data Analytics
- Data Entry
- Microsoft Excel
Associated with: The Top Professionals
Wordpress Developer
India - Last active: 1 day ago - Tests: 1
My experience and large snippet database I've built up over the years allows me to develop websites faster than other programmers, which means I may actually be cheaper than others with a lower bid. I guarantee my code will be secure, well commented, maintainable, and optimized for speed. **Why Me?*** 100% Satisfaction Guaranteed *Excellent Customer Service -- Fast Communication - within 10 business hours -- Motivated Enthusiastic Contributor in your project -- 24/7 email support and voice support during US Morning (till noon) or Night times *Committed to QUALITY delivery. -- W3C for HTML, CSS web pages. -- Designs at par with industry best. *A Great Team Player. *All round experience in Design, Programming, Database, Project Management, SEO and Internet Marketing, Business Skills and Consulting. ★ AREAS OF SPECIALIZATION ★ - Web Design and Development Services. - Application Development & Maintenance Services. - Graphic Design - SEO and - Internet Marketing My expertise guarantees quality, competent and rapid execution of any project - from small websites to complex ecommerce software and custom solution programming. I AM A SPECIALIST in creating COMPLEX PHP Web Sites / Applications / Office Automation / Social Networking / Specialized Sites / Membership Web Sites. If you have any IDEA, I can turn it into a program / application. If you want a Great Design for your site, I shall give you a Great Looking site - Web 2.0 look or based on heavy design. Whichever, you shall be in full control of your design project. Most importantly, I can fill in gaps into your project - whether the gaps exist in your business ideas or the technicalities. I design, develop code, build relational database and weave all these golden fibers to bring your concept to marketable and profitable reality. Finally, to popularize your site, I can help you out with SEO and SEM activities, and if not, guide you with a points or two. I take great pride in the work that I deliver to my Clients and what I shall deliver to you. I will consult you, with more business IDEAS, refine your product, enhance perceived product value and adopt web strategies to build your online brand. After all Business comes before Technology. And focus should be at REVENUE generation right from the Ideation and Design Phase. With me, you gain by my accumulated knowledge and experience of running successful online business in this highly competitive web world. It's not just technology with me. Your users, your revenue, your product - that's where all my technological brainstorming revolves. ★ Contact me for my LIVE Portfolio ★ ★ Various Custom COMPLEX Web Site Examples Available ★ ★ Happy to Work with You :-) ★
Associated with: Inspiron Soft
Expert as a Facebook marketing,Craigslist and other Classifieds ad
Bangladesh - Last active: 25 days ago - Tests: 3 - Portfolio: 5
Over the last 5 years, I have gained huge experiences with Online Marketing & Advertising, Email Marketing, Craigslist and Classified ad posting, Social media marketing etc. My core competency lies in Online Marketing, Inbound Marketing etc. My main objective is to provide excellent service, with timely, accurate, and professional results.


text:
Forty Years Forty Poems Poems inspired by the Winnipeg Folk Festival
by Waldemar Ens
A book of poems inspired by The Winnipeg Folk Festival
Comment posted.
Sign in or create an account to post a comment.
Poems from a Childhood
Published December 07, 2012
The Poetry of Music
Published April 15, 2012
Start your own book today from US $3.99.
Get Started
Blurb Sites

subset: commoncrawl


text:
Conduit 2
Are you consistent with skill?
- Back To:
- Board List
- Topic List
- Topic Archived
- Page 1 of 2
- Last
I find that I am, unfortunately, very inconsistent with skill. Last couple days I've been hitting 40-50 kills a match with maybe 15 or less deaths, today I'm getting terrible scores, like barely breaking even. -_- I'm glad the next game will have more modes than online and story, It will be better than playing with a bunch of people I don't know and Invasion sounds good too. But yeah, I'm going to play Metroid Prime 2 now. ;_; Maybe I'll get my skill back tomorrow.
The wizard did it.
The Conduit FC: 4984-8243-5440 Tasi.
I'm the same. I played a game today and scored 20-3(kills/deaths). In my opinion that is a pretty good ratio. Usually I am close to even though, unless it is an explosive match, in which I usually have more deaths than kills.
Honestly, who likes the explosive mode? Seriously it is lame! Glad we will have loadouts instead.
Put "Worker for the Regional Manager at VF54 brand Fruit and Vegetable Juice" in your sig, please. :)
Same here.
I apologize for whatever I just said.
i think ive personally gotten to the point where i dont really care about my performance anymore. not bragging here, but in my experience ive found that, once you get good enough at something that people start to take notice, it kinda puts a certain amount of pressure on me to perform. so with that said, if im inconsistent sometimes, it really doesnt bother me anymore...
convenience store clerk- "hey buddy, you gonna pay for all that stuff?!"
me- "looking into it." *walks out the door*
I don't play enough to be consistent. but once I warm up, I typically get the most kills on my team, the only time I don't is typically because of a hacker or someone with totally insane skills.
Of course, my kill/death ratio could be improved. but I don't need an amazing ratio when I'm dealing out such massive numbers, I typically also score the most points for my team.
And regards to Dpunch about caring...
I only pop Tcon in every... 4 months or so, and then play for 2-3 days.
During that time, I really want to make it count. but I'm still mellow enough about it to where I still enjoy myself regardless of the outcome.
yea im pretty consistent unless the game is laggy or somethin i like always get a 2:1 kill death ratio my best match was 75 kills and 20 deaths with the shotgun
I don't mean consistent, I mean like natural skill.
The wizard did it.
The Conduit FC: 4984-8243-5440 Tasi.
Like usually number of kills or how much you get killed and stuff.
The wizard did it.
The Conduit FC: 4984-8243-5440 Tasi.
I'm terribly inconsistent. always have been. But I'm better now since there's nocompetitive pressure. I've lost my top-tier scar skills, though. I can't jump and hit people without dying these days.
From: Sudsy86_ | Posted: 8/18/2010 8:31:32 PM | #009
I used to be good with SCAR too. :/ Now I'm decent. And I usually take cover over jumping now, I don't know if that's smart or cowardly.
The wizard did it.
The Conduit FC: 4984-8243-5440 Tasi.


text:
June 8, 2012
Brian Banks speaks during a news conference Thursday in Renton, Wash. Cleared of rape and kidnapping charges just two weeks ago, Banks gets to pursue his NFL dream. The 26-year-old player has spent five years in prison. He now has a tryout with the Seattle Seahawks.
Stories this photo appears in:
NFL NOTEBOOK: Mega-lawsuit on concussions claims NFL hid brain-injury link; Pats cut Ochocinco; Seahawks to give tryout to wrong imprisoned former prep star
Thousands of former players join together and file suit, claiming the league knew about the dangers of concussions years ago.
Use the comment form below to begin a discussion about this content.


text:
Retailers see sales drop in dreary November
NEW YORK Retailers – with Wal-Mart the notable exception – limped through a miserable November that even a surge of shopping after Thanksgiving couldn't save, marking the weakest month since at least 1969 and deepening fears that the critical holiday period could be the most dismal in decades.
As merchants announced their November sales figures Thursday, the deep malaise cut across all sectors as shoppers worried about layoffs and shrinking retirement funds focus on necessities. Wal-Mart Stores Inc., though, posted sales gains that surpassed Wall Street estimates and has seen more customers and higher average transactions as it benefits from what could be a deep and prolonged recession.
However, Costco Wholesale Corp., usually a strong performer, reported a bigger-than expected sales decline. And most mall-based chains and department stores such as teen stalwart Abercrombie & Fitch Co., Kohl's Corp. and Macy's Inc. fared much worse, reporting percentage declines of over 10 percent.
"It's an awful beginning to the holiday season," said Michael P. Niemira, chief economist at International Council of Shopping Centers. "This is going to be a difficult holiday season for most retailers. There are going to be more bankruptcies." He predicted that the retrenchment in spending will linger for at least another six months.
According to the Goldman Sachs-International Council of Shopping Centers index of 37 stores, sales dropped 2.7 percent for November, making it the worst month since at least 1969 when the index began. November's results were even more miserable than the 1 percent drop that Niemira anticipated. He noted that excluding Wal-Mart, the index declined a dramatic 7.7 percent, indicating a widening gap between the world's largest retailer and the rest of the merchants.
The tally is based on same-store sales, or sales at stores opened at least a year, which are considered a key indicator of a retailer's health.
Based on November's performance, Niemira is slashing his holiday sales forecast for the combined November and December periods to be down as much as 1 percent. The only holiday period that was almost as weak was 2002, which posted a meager 0.5 percent same-store sales gain.
Sales data from the Thanksgiving weekend showed a buying binge on Black Friday – so named because it historically was the day that a surge of shoppers pushed stores into profitability – but shoppers retreated the rest of the weekend.
And even at the stores on Friday, they focused on bargains and on small-ticket purchases as they slash their holiday budgets, meaning only modest sales gains for the weekend.
Now concerns are growing that shoppers won't return to malls until the final days before Christmas, making the typical lull between Thanksgiving weekend and the final days before Dec. 25 even more pronounced as shoppers wait for the best deals.
Many stores blamed their weak November figures in part to a quirk in the calendar – a late Thanksgiving means that the month's reporting period does not include a whole week of post-holiday shopping compared with a year ago. Niemira estimated that factor depressed November figures – and will benefit December – by 1.5 percentage points to 2.0 percentage points.


text:
Description: Were loving this exotically pretty Top & Tunic style perfect for soft drape y print or solid blouse weight fabrics from silks to cottons rayons to stable knits. Relaxed fit style has gently shaped side seams and a wrap front ...
go to product
Description: FABRICS: Designed for stretch knits only with 35% stretch across the grain. Suggested Fabrics: Interlock, textured knits, stretch velvet, stretch velour, matte jersey, stretch terry. Tops have boat neckline finished with self fabric binding and right side is longer. View ...
Description: The Misses' Tops are designed for soft lightweight woven fabrics. We suggest gauze, lawn, challis, rayon & blends. The skirts are designed for light to medium weight woven fabrics. We suggest cotton, cotton types, linen, challis, broadcloth. Misses' skirts and ...
Explore Fabric.com
We're here to help
Discover Fabric.com
Sewing Center
Give the gift of creativity.
A Fabric.com gift certificate is the perfect gift! Gifts from $10 and up.
#MadeWithFabric #SewInLove


text:
Prices and availability are subject to change from the time and date that you print this page.
6/3/2015 6:33:12 PM. For Customer Service, please call 800.967.6696
Pickup Check store pickup options
The Story
This solid square server of kiln-dried oak has a serving bowl built in, the perfect spot for savory oils, spreads or nuts. Hand-carved and -finished board brings out the hardwood's unique character, standing up to cutting and slicing.
Details and Dimensions
Oak Board With Dipper. 11.75"Wx11.75"Dx1.25"H
- Handcrafted
- Kiln-dried oak
- Food-safe oil coating
- Wipe with mild soap and water, dry with clean cloth
- Not for use in dishwasher, microwave or oven
- Made in Thailand
Overall DimensionsWidth: 11.75" Depth: 11.75" Height: 1.25"
Return/Exchange Policy
We will accept merchandise returns of non-furniture items within 90 days of customer receipt.
Outlet purchases and purchases made outside the U.S. may only be returned to the purchase location. All other Crate and Barrel non-furniture merchandise may be returned in person to any U.S. Crate and Barrel store (excluding Outlets) or by mail (if the item was ordered online or by phone and received by mail).
Bedding items can be returned or exchanged only if in their original packaging.
An appropriate exchange, credit or refund will be issued for the item(s) and any taxes due to be refunded in accordance with applicable state law.
Depending on the nature of the return/exchange and the presence of an original receipt or packing slip, we will issue an appropriate credit or refund in one of the following ways:
- With an Original Sales Receipt or Packing Slip, the item's purchase price will be refunded in the Original Form of Tender (cash refunds are limited to $100 in store with any balance refunded as a check by mail).
- With an Original Gift Receipt or Gift Packing Slip, the item's purchase price will be refunded via a Shop Card.
- Without an Original Sales Receipt, Gift Receipt or Packing Slip, the item's current retail price will be refunded via a Shop Card, regardless of amount. Valid photo ID is required for store returns without an Original Sales Receipt, Gift Receipt or Packing Slip.
Please note: Shop Cards, Gift Cards and eGift Cards are valid for Crate and Barrel, CB2 and The Land of Nod purchases and are not redeemable or subject to exchange for cash or a cash equivalent, except as required by applicable law.


text:
|A to Z | Popular | Random | Origins
LanieRate Lanie: Do you like this name?
Get creative with Lanie | Add to list (0)
Meaning and name origin
Lanie \l(a)-nie\ as a girl's name is of English and Middle English origin, and the meaning of Lanie is "path, roadway". Lanie is a variant of Laine (English): variant of the surname Lane, or a short form of names like Marlaine and Melanie.
Lanie has 3 variant forms: Laina, Lainey, Laney.
Lanie is a somewhat popular first name for females (#3430 out of 4276) and also a somewhat popular surname or last name for all people (#82319 out of 88799) (2000 U.S. Census).
Displayed below is the baby name popularity of the name Lanie for girls (2015 statistics).
Displayed below is a comparison of the popularity of the girl name Lanie and its variant forms. Variation forms ranked in the Top 1000/100 are Lainey, Laney and Lanie. (2015 statistics).
Similar Names
Lanie is also pronounced similarly to Lana, Lanae, Lanah, Lanai, Lani, Lanna, Lannie, Lanny, Lenae, Leonie, Linnie, Lonee, Loni, Lonie, Lonnie, Luannie and Lynae. Other suggested similar baby names are Danie, Janie, Lacie, Lanice, Layne, Leanne, Lene, Liane, Lianne, Luane, Luanne and Lynne. These names tend to be less commonly used than Lanie.
© 2015 Think Baby Names
Home - About - Terms - Privacy - Contact


text:
This product is no longer available.
Click here to view similar products
Click here to continue and view the original page
The Dahon Espresso 2011 Folding Bike is the bike for urban adventures: to the park on a sunny weekend; down the street for a lazy Sunday brunch; or to the market for some fresh penne, tomatoes, and a bottle of wine….
The Dahon Espresso 2011 Folding Bike is the bike for urban adventures: to the park on a sunny weekend; down the street for a lazy Sunday brunch; or to the market for some fresh penne, tomatoes, and a bottle of wine. For 2011, the Espresso gets a complete makeover. The patented new Dahon Axis stem lets you fold the Espresso with a minimum of effort and Schwalbe Big Apple tires mean that you go faster, in a lot more comfort. The new Espresso is a shot of caffeine to your cycling lifestyle.
- Frame:
DA Series, Joe Murray design, 7005 aluminium, custom-drawn Sonus tubing, patented ViseGrip and Re-Bar technology
- Fork:
Oversized, straight, integrated design
- Front Derailleur:
- Rear Derailleur:
Shimano Altus
- Shifters:
SRAM MRX Comp, SRS technology, 21 speed
- Chainset:
6063 cold-forged aluminium cranks
- Chainrings:
48/38/28 tooth
- Bottom Bracket:
CH, chromoly axle
- Cassette:
Shimano 7 spd., 14-28T
- Chain:
KMC Z50, narrow, noiseless function
- Pedals:
Suntour folding, non-slip
- Front Brake:
ProMax V, aluminium, linear spring
- Rear Brake:
ProMax V, aluminium, linear spring
- Brake Levers:
ProMax V, aluminium bracket/aluminium lever
- Handlebars:
BioLogic Crescent
- Stem:
Dahon Axis, patented InfiniteAdjust technology
- Headset:
Dahon Fusion, zero stack, cartridge, conical spacer
- Grips:
BioLogic Ergo, AirFlo design, Kraton
- Rims:
Aluminium, anodized black
- Front Hub:
Formula, QR, aluminium
- Rear Hub:
Formula, QR, aluminium
- Spokes:
18/8 stainless steel, brass nipples
- Front Tyre:
Schwalbe Big Apple, 26″ × 2.0″, RaceGuard puncture protection, 75 psi
- Rear Tyre:
Schwalbe Big Apple, 26″ × 2.0″, RaceGuard puncture protection, 75 psi
- Saddle:
BioLogic Como
- Seatpost:
6063 aluminium, forged clamp, 31.6 mm
- Seat Binder:
Aluminium with high leverage lever
- Accessories:
Trouser Strap and Catetye reflectors
- Extra Features:
Aluminium, Dacromet bolt Kickstand
- Weight:
13.86kg (30.49lbs) approx for the Medium size, with pedals (built). (PLEASE NOTE: Weight is approximate and is provided by Evans Cycles as a guide only, actual weight may vary due to manufacturing processes and other factors)
Sizing Guides
Sizing guide for Dahon Expresso bikes
Buying Guides
A buying guide that offers general advice on folding bikes
A basic guide to folding and unfolding your Dahon Espresso bike.
Product manual for Dahon Espresso bikes.
Customer Reviews
|Product no longer available for purchase
We offer a range of delivery services for our UK and International customers. UK Customers can select our FREE standard delivery option on most non bike orders over £20. Or if you're in a hurry you can upgrade to our Next Day, Saturday or Sunday delivery services. You can also use our free Click & Collect service, where you can collect your purchases from a choice of over 50 Evans Cycles stores. International customers can benefit from FREE delivery on most orders and save UK VAT if we are shipping outside of the EU.
Bike build & delivery
UK bike delivery charge includes assembly by our fully trained mechanics, pre-delivery inspection and safety check, packing in our custom bike box, multi-tool and delivery from only £9.99 per bike.Click here to see how we deliver your bike
Standard, Next Day, Saturday & Sunday UK delivery
We offer a FREE standard delivery service on orders over £20, as well as Next Day, Saturday & Sunday delivery options to UK addresses. Click here for more details
Click & Collect
Using our Click & Collect service your order will be delivered to a choice of over 50 Evans Cycles stores nationwide for collection. This service is FREE of charge for all orders. To check store stock and collection times, use the "Check store stock" button above. Click here for more details
International delivery (Incl BFPO, ROI, Channel Island & Isle of Man)
We offer a FREE delivery service on most International orders. Orders delivered outside the EU are exempt from VAT. To calculate the charges for your order simply add products to your basket and proceed through the checkout process, where you will need to enter your delivery details. Our website will present you with the relevant delivery options and the charges for your basket of goods. Click here for more details.
Easy Returns
Our priority is to ensure that you are highly satisfied with your purchase. In the unlikely event that you are not, please feel free to return your goods within 90 days of the purchase date for a full exchange or refund. Returns can be made in your local store or sent back to our distribution centre.


text:
CybertronPC Blueprint TCAD3103A Intel Core i7-4470K, 32GB Memory, 2TB HDD, Windows 8 Pro 64-bitItem#: FYB-102029937 | Model#: TCAD3103A
Currently Out Of Stock!
You May Consider This Alternative
CybertronPC Blueprint TCAD3103A Workstation PC Product Details
CybertronPC Blueprint TCAD3103A Workstation PC
The CybertronPC Blueprint TCAD3103A Workstation PC was designed for designers, configured to help you get the most out of your software. From AutoCAD to SolidWorks, Maya and more, a Blueprint system from CybertronPC will help you get the job done. This system is performance driven, using an unlocked 3.50GHz 4th Generation Intel Core i7 Quad-Core processor and a 3GB NVIDIA Quadro K4000 Video Card.
What it is and why you need it:
- 4th Generation Intel Core i7-4770K Quad-Core Processor with 3.90GHz Max. Turbo Frequency
- 3GB NVIDIA Quadro K4000 Professional Graphics Card
- 32GB Fast DDR3-1600 (PC3-12800) Memory
- 2x 128GB Solid State Drives in RAID 0 Array and 2TB Hard Disk Drive
- DVDRW Optical Burner Drive
- Special Sound-dampening Chassis
- Pre-Loaded with Genuine Windows 8 Pro 64-bit O/S
|CybertronPC Blueprint
TCAD3103A Workstation PC
Manufactured by: Cybertron
Warranty provided by: Cybertron
Limited Warranty: 12 months parts; 12 months labor
Mfg Part No: TCAD3103A
UPC No: 844750020327
Box Size: ( Length:22, Width:23, Depth:14)
Shipping Weight: 40.0000 pound(s)
Click here for full warranty and support information
- Limited Warranty: A full text version of the limited warranty
may be obtained by mailing a self addressed, stamped envelope to the
address below and requesting the warranty for item number: FYB-102029937
Warranty Information
7795 W. Flagler St. Suite 35
Miami, FL. 33144
- Cybertron logos are registered trademarks of Cybertron. All others trademarks and copyrights mentioned herein are the property of their respective owners.


text:
Thought I would post this for any active duty military we have here. This is from Fay's blog.
From the Reds:
The Cincinnati Reds are offering all active duty military members a complimentary ticket for the Friday, July 4th game vs the Washington Nationals, a 1:15 p.m. start.
Tickets can be picked up at the Great American Ball Park ticket windows with military identification. Premium areas and bleachers are excluded.
Additional tickets for family members can be purchased in the same seating areas at half-price.


text:
The women's characters are as well drawn as the men's in a splendidly acted film that captures the confusion of love in ways that are ardent, affecting and wonderfully funny. show more
Burns has created an endearing gathering of people we all know, and every one of them is so much fun that leaving the theater at the end elicits a touch of regret. show more
This meaty Irish stew isn't arty or elliptical. It ought to connect with anyone who's survived sibling tension or romantic fence-sitting. [9 August 1995, Life, p.5D] show more


text:
Special Correspondent
Letter of support sent to President
Chamling to be sworn in today
KOLKATA: The Sikkim Democratic Front, which is set to form government for a record fourth term in the Himalayan State, has extended its "unconditional support" to the Congress-led United Progressive Alliance, its president Pawan Chamling told The Hindu over telephone from Gangtok on Tuesday.
"The letter renewing our unconditional support to the UPA was sent to the President on Tuesday," said Mr. Chamling, who submitted the resignation of his Council of Ministers to Governor Balmiki Prasad Singh. He and his Ministers will be administered the oath of office and secrecy by the Governor at the Raj Bhavan in Gangtok on Wednesday morning.
On his expectations from the new government at the Centre, Mr. Chamling said, "All my State wants is justice." He expressed the hope that the newly elected UPA government, to be headed by Manmohan Singh, would "take care of Sikkim's interests and provide it with the assistance to carry out development."
"Though Sikkim has a lone representative in the Lok Sabha its needs are special. It is a sensitive-border State. The SDF governments had been working towards ensuring peace and keeping the State free of insurgent activities for the interests of our nation," Mr. Chamling said.
Mr. Chamling was invited by the Governor to form the next government in Sikkim on the basis of his party's performance in the Assembly elections after the former staked his claim to do so. The SDF swept the polls held on April 30, winning all the 32 seats up for grabs.


text:
Cream Ankle Strap Amuse Sandal Pumps | Unique Vintage
More Views
Cream Ankle Strap Amuse Sandal Pumps
Are you amused, darlings? Presenting a remarkable pair of sky high sandals - endearingly charming cream ankle strap heels with an adjustable gold buckle. Featuring a man-made patent upper and 5" stiletto heel. Consider us spellbound!
Please note all shoes have a 4 day handling time before they will ship from our warehouse and there is a 15% restocking fee if you choose to return.
Out of stock


text:
Donate to the Republican Party and get America out of bondage —- so GOP lackeys can party hardy with bondage strippers.
The Republican National Committee —- whose goal it seems is to put the "Party!" back in the Grand Old Party —- spent $17,000 in February on luxury jets, posh hotels and almost $2,000 for "meals" (maybe it was pork, the other white meat) at Voyeur West Hollywood, which features topless bondage babes who simulate lesbian sex acts.
And you thought your money was going to candidates who want to get elected so President Jesus Hater won't be able to get his socialist Antichrist agenda through after the November elections.
Those Republicans, such wild and crazy guys.
The posh places included the Beverly Hills Hilton (where they ran up a $9,000 tab) and the Beverly Wilshire Four Seasons (a $6,600 tab.)
But the cost of the Republican Party's commitment to take their country back: Priceless.
What are Republicans doing in Gommorah anyway —- they hate Hollywood.
Ironic then — and definitely hypocritical –that the party gets a lot of contributions from the fine folks in the Heartland using Hollywood as a donation tactic.
Maybe they can use the excuse that since the end of days is nearing, they wanted to spend some time in the devil's playground to try and "convert" global warming, same-sex marriage, pot smoking baby killing liberals.
In any event, here are some of the songs that partying Republicans can't do without on their iPods:
1. "Hotel California"
2. "Whip it"
3. "Let's Get Physical"
4. "Dancing Cheek to Cheek"
5. "Like a Virgin"
6. "I'm a Girl Watcher"
7. "Kiss You All Over"
8. "Touch Me"
9. "Bang a Gong"
10. "Fat Bottomed Girls"
Can't miss movies that partying Republicans have in their DVD libraries just for the titles:
1. "Of Human Bondage"
2. "The Hurt Locker"
3. "Deep Impact"
4. "Driving Miss Daisy"
5. "Around the World (in 80 Days)"
6. "Octopussy"
7. "Free Willy"
8. "Spank the Monkey"
9. "Die Hard"
10. "Bedknobs and Broomsticks"
So contribute today to the Republican Party —– because a lap dance is a terrible thing to waste.


text:
News from WTOP
News from the AP
Mike Causey
Shows & Panels
Shows & Panels
- Agency of the Month
- Business of Government Hour
- The CFO Agenda: Delivering value from financial transparency and audit efforts in the public and private sector
- Cloud-Driven Data Insights in Government
- CXO Surveys
- Disaster Resilience for America
- Federal News Countdown
- Government Perspectives on Mobility and the Cloud
- Reducing Risk in the Cloud
- Reimagining the Next Generation of Government
Shows & Panels
- AFCEA Answers
- American Readiness: Renewable Power and Efficiency Technologies
- Ask the CIO
- The Business Case for Cloud Computing in Government
- Cloud-Driven Data Insights in Government
- Connecting the Dots: Digital Authentication in Government
- Data-Centric Approaches to Government in the Cloud
- Delivering the Digital Government Mission
- Federal Executive Forum
- Federal News Radio's National Cyber Security Awareness Month Special Panel Discussion
- Federal Tech Talk
- The Future of Government Data Centers
- Government Perspectives on Mobility and the Cloud
- Industrialized, Interoperable and Insight-driven Federal Health Panel
- Innovation and Tech Superiority through Acquisition Reform
- Mitigating Insider Threats in Virtual & Cloud Environments
- Moving Agency Applications to the Cloud with PaaS
- Reducing Risk in the Cloud
- Security in the Age of Targeted Attacks
- Air Traffic Management Transformation Report
- The Business of Cloud
- Cloud First Report
- Data Driven Cloud Series
- Disaster Resilience for America
- General Dynamics IT Enterprise Center
- Gov Cloud Minute
- Government in Technology Series
- Homeland Security Cybersecurity Market Report
- The Intersection: Where Technology Meets Transformation
- Modern Mission Critical Series
- National Cybersecurity Awareness Month
- The New IP for Federal IT
- The Social Platform Solution for the Department of Veterans Affairs
- Technology Insights
- The Cyber Security Report
- The Next Generation Cyber Security Experts
Shows & Panels
- Cloud-Driven Data Insights in Government
- Disaster Resilience for America
- F-35 Lightning II Program
- Government Perspectives on Mobility and the Cloud
- On DoD
- Pentagon Solutions
- Reducing Risk in the Cloud
- Reimagining the Next Generation of Government
- Transforming Business Operations at the Defense Department
Search Result
Search Tags: I Fund
TSP: Should you take a risk or play it safe?
Host Mike Causey and financial planner Arthur Stein will discuss different investment strategies for the Thrift Savings Plan, and what you can do to make sure you have enough saved for retirement.
March 11, 2015
Tags: pay and benefits , Arthur Stein , Arthur Stein Financial LLC , TSP , G Fund , C Fund , S Fund , retirement , Mike Causey , Your Turn
Which TSP fund is the best option for you?
Financial planner Arthur Stein joins host Mike Causey to answer your questions about which TSP fund to invest in.
January 14, 2015
Tags: pay and benefits , TSP , financial planning , retirement , Arthur Stein , Arthur Stein Financial LLC , C Fund , G Fund , F Fund , Andy Medici , Federal Times , government shutdown , Mike Causey , Your Turn
Watching your money - the TSP way!
Certified Financial Planner John Jilek provides tips on how to determine which TSP funds are right for you.
March 24, 2014
Tags: pay and benefits , retirement , Thrift Savings Plan , Edward Jones , John Jilek , G Fund , F Fund , C Fund , S Fund , Lifecycle Funds , Bob Leins , For Your Benefit , John Elliott
Are happy days here again for the TSP?
Financial planner Arthur Stein, will answer your questions about the Thrift Savings Plan, and give advice on what you should be doing with your TSP accounts.
January 9, 2013
Tags: pay and benefits , furloughs , government shutdown , federal retirement , Thrift Savings Plan , C Fund , S Fund , Arthur Stein , financial planning , retirement tsunami , REIT fund , gold fund , Federal Times , Stephen Losey , Sean Reilly , Mike Causey , Your Turn
TSP: Cruel nanny or lifeguard?
Is Uncle Sam protecting you, or ripping you off, by limiting your TSP fund choices? The answer depends on whom you ask, Senior Correspondent Mike Causey says.
Tags: Mike Causey , Federal Report , TSP , Allan Roth , C Fund , G Fund , S Fund ,
TSP's I Fund brings 'true diversification' to portfolio
Your Thrift Savings Plan is probably home to the G Fund and maybe some C Fund as well. But there's more to the TSP than just those two funds.
Tags: TSP , Tom Trabucco , Federal Thrift Investment Board , In Depth , Francis Rose ,
H1N1 inspires palm-vein biometrics
Palm-vein biometrics uses near-infrared light to capture palm-vein patterns in a person's hand, which serves as their identity to the systems. A user would hold his hand over a small scanning device attached to his computer that reads the pattern and matches it to a database of preregistered users. Unlike fingerprint scanning, palm vein is contactless, meaning the user doesn't touch any devices and risk leaving behind a "footprint" fingerprint that could be accessed or stolen.
Tags: Cybersecurity Update , cybersecurity , tech , Adobe , Fujitsu , H1N1 , Twitter
TSP fund manager arrest is just a rumor
The Federal Retirement Thrift Investment Board is dispelling a rumor circulating on the Internet that a Thrift Savings Plan I Fund manager was arrested.
Tags: P&B , retirees , Thrift Savings Plan , Federal Retirement Thrift Investment Board , Samuel Hoeffler ,


text:
9 Celebrities Who ALSO Tweeted Scandalous Photos
Ok, everyone has seen this, But really now, what's the BFD? Twitter is basically the new MySpace but with a range of self-fame-whoring celebrities out to show us the REAL REASON why they're famous: controversy, T & A, and yeah their unabashed usage of mobile devices in any way possible.
This post was created by a user and has not been vetted or endorsed by BuzzFeed's editorial staff. BuzzFeed Community is a place where anyone can post awesome lists and creations. Learn more or post your buzz!
Preview Your Response


text:
The Pentagon's budget cuts will hit defense contractors, but the Defense Department has not released details on the cuts. "I can't sit here and tell you you will be unaffected," Pentagon Comptroller Robert Hale said, addressing defense contractors in a TV interview. "You will. We will try to communicate with you as best we can."
View Full Article in:Bloomberg Businessweek
Published in Brief:


text:
Don't blame snow: Feb. jobs data likely to be weak
- The household survey is less likely to be distorted by the snowstorms. Workers who stay home due to snow but have jobs will be counted as employed. Still, the unemployment rate is expected to rise because hiring remains slight.
- Job changes by industry. Some sectors, such as construction, restaurants, transportation and retail, are most likely to be affected by bad weather. If job losses in those industries are higher than in recent months, the losses will likely be attributed to bad weather. Changes in other industries are more likely to be taken at face value.
There are other potential distortions to the employment data: More people might have had jobs clearing snow, some economists say. And the government is expected to have boosted temporary hiring for the 2010 Census, though it's not clear by how much.
Recent data have sketched a discouraging employment picture. First-time jobless claims, after falling for most of last year, have risen by 30,000, or 7 percent, since the start of 2010.
"It doesn't yet look like there's a lot of hiring going on," said Marisa DiNatale, an economist at Moody's Economy.com.
There may be a silver lining: If the weather does boost reported job losses in February, jobs should snap back in March as hiring that had been delayed takes place and workers return to jobs.
That's what's happened after previous weather disruptions. In February 1996, for example, the nation posted robust job gains, a month after a severe snowstorm.
The Associated Press


text:
We have rich conversations with our clients every day, and increasingly these conversations are happening online. We encourage you to ask questions, share your views, and connect with like-minded professionals.
The International Annual Review demonstrates our achievements and reflects the insights and expertise professionals bring to client relationships.
KPMG's Global IFRS Institute provides information and resources to help Board and Audit Committee Members, Executives, Management, Stakeholders and Government Representatives gain insight on the evolving global financial reporting framework.
KPMG's global network of climate change and sustainability practices helps you build long-term value in a rapidly changing world.
Mining organizations need to adapt across the mining asset lifecycle, from expansion to closure, as changing economic, political and regulatory environment demand greater flexibility.
The Chemical industry's landscape is changing fast - global companies are developing or launching new products and services – and appear optimistic - setting sights on geographic expansion.
Over the last two decades many industries have changed their value proposition by developing their customers' capacity to create value.
KPMG Global Manufacturing Outlook 2014 surveyed 460 executives worldwide, and offers practical and provocative insights to help organizations evaluate future strategies.
The global job search tool allows you to search available career opportunities within many of our 150 member firms worldwide.
KPMG's International Case Competition (KICC) is a chance for students to challenge yourself to solve a real business issue and an opportunity to meet new people across the globe.
With tax audit and dispute activity rising in almost every country, keeping up with trends and developments is more important than ever. In this edition, you'll find briefings on key news, events and thought leadership submitted by Global Tax Dispute Resolution & Controversy professionals in KPMG member firms worldwide. Staying informed can be a crucial first line of defense as you manage your disputes around the globe.
Make sure to view our past issues of Global Tax Disputes Update.
Focus on tax dispute resolution and controversy
Focus on transfer pricing dispute resolution
Tax Dispute and Controversy Update – Alternative Dispute Resolution
As the revenue authorities around the world refocus their efforts on adjustments and enforcement, they are similarly focused on gaining efficiency in the face of reduced budgets and increasing responsibility. One approach to achieving this efficiency in the tax disputes resolution process is the use of alternative dispute resolution (ADR) methods, to avoid costly, time-consuming and resource-depleting litigation. ADR provides an approach to resolution in which the taxpayer and the revenue authority come together to actively seek resolution. While different jurisdictions have different offerings and approaches, the concept is gaining global appeal.
On a recent webcast, KPMG dispute resolution professionals from Australia, the UK, the US and Germany shared their experiences with ADR and discussed the various options available in their country.
View the presentation and webcast replay.
back to top
Focus on top audit issues – selected countries part 1
Levels of tax audits and disputes continue to rise in countries worldwide. In some cases, taxpayers face similar audit issues, such as those arising for global companies as the international movement to address base erosion and profit shifting (BEPS) continues to gather steam. In other cases, domestic issues and priorities are creating audit issues that are unique to the jurisdiction.
A recent article from KPMG's Global Tax Disputes and Controversy practice presents a high level round-up of some of the top audit issues being experienced by clients of KPMG International member firms in Canada, China, India, the US and the UK. (Part 2 of this article – coming soon – will profile the top audit issues in the emerging MINT countries – Mexico, Indonesia, Nigeria and Turkey.)
Read the article.
OECD – head of BEPS project discusses goals and issues
In a recent interview, Raffaele Russo, head of the BEPS (Base Erosion and Profit Shifting) project of the Organization for Economic Co-operation and Development (OECD) discusses the OECD's goals and the difficulties with implementation.
According to Russo, the BEPS project is not just about harmful tax avoidance. The project originated in part out of a concern that efforts to relieve double taxation would not survive for long with so many opportunities for double non-taxation. To tackle double taxation, the OECD and G-20 also had to work on a set of rules to attack systemic double non-taxation. Addressing double non-taxation has received widespread support from governments and outside interest groups.
Russo's biggest concerns with BEPS are the compressed time frame and keeping the business community's attention. The challenge is to coordinate all the different items, many of which are being worked on simultaneously.
Implementation will be the biggest challenge. Writing rules and recommendations is the easier part of the project. It is daunting to marshal a set of guidelines and rules into a functioning multilateral system when that implementation requires numerous governments to make changes to domestic laws and adopt policies that may not be in their own country's best interests. However, some recent changes in the tax and banking worlds give reason to be optimistic.
Further information:
Sharon Katz-Pearlman
OECD – stakeholders disagree on country-by-country reporting
At the Organization for Economic Co-operation and Development's public transfer pricing documentation consultation in Paris on 19 May 2014, representatives from governments, the business sector, and civil society engaged in a heated debate over the method of filing and sharing corporate information through a country-by-country reporting template.
Some stakeholders advocated for direct filing with all countries, while others pushed for a treaty-based sharing system. A common argument for treaty-based information sharing is that highly confidential information, such as sales, taxes paid, and pre-tax income, is usually held at the parent-company level, and subsidiaries may access only information that concerns them and their subsidiaries. A direct filing system would offer access to confidential information and would affect corporate governance of global companies. Another concern is that some countries do not subject authorities to tax confidentiality statutes.
Concerns were also raised that treaty-based sharing system would put developing countries at a disadvantage because many of them have weak or non-existent treaty networks
OECD – some tax authorities already seek country-by-country tax information
As the OECD considers a proposal for country-by-country reporting (see article above), tax authorities are already beginning to request similar information through taxpayer audits, according to practitioners. In particular, tax authorities are seeking more transparency into the global operations of taxpayers in order to assess the 'full value chain' of an organization. Tax authorities in Finland, France and Sweden, for example, are taking an interest in how the reported profits in the local jurisdiction compare with the profits reported and functions undertaken in other jurisdictions.
Not only are more countries seeking information on global profit levels, but many are not waiting for the conclusions of the base erosion and profit-shifting project to enact new measures. Countries have begun adopting changes even though one of the OECD's objectives for the BEPS project was to discourage uncoordinated action. For example, changes have already been made independently in Mexico, France, Germany, Australia and Austria.
OECD – discussion drafts for neutralizing hybrid mismatch arrangements
On 19 March 2014, the OECD released two discussion drafts pursuant to Action 2 (Neutralize the Effects of Hybrid Mismatch Arrangements) of the Base Erosion and Profit Shifting Action Plan. The first discussion draft addresses recommendations for OECD members' domestic laws. The second discussion draft addresses proposed tax treaty changes.
Australia – ATO focuses on non-resident transactions
Non-resident taxpayers need to consider the tax implications of proposed transactions with an Australian connection and how to manage the interaction with the Australian Taxation Office (ATO). The Foreign Investment Review Board and the ATO are reportedly sharing information, resulting in the ATO seeking active engagement with taxpayers during the course of a transaction.
It is important for taxpayers to determine the optimal way to manage this interaction to help ensure the smooth conduct of their transaction and avoid the potential for the ATO to use its formal powers to protect the revenue.
Australia – what is the potential impact of country-by-country reporting?
Australian taxpayers are already subject to extensive transfer pricing recordkeeping rules, following last year's passage of Tax Laws Amendment (Countering Tax Avoidance and Multinational Profit Shifting) Act 2013. Australian taxpayers are also subject to significant disclosure requirements—such as the "International Dealings Schedule" which may need to be filed with the annual income tax return.
Given these requirements, KPMG in Australia analyzed the additional impact of country-by-country reporting as proposed in an initial draft template of the OECD.
Brazil – Auditor-General issues opinion on withholding tax and treaty country residents
Since Brazil's COSIT Interpretive Declaratory Act 001 was published in January 2000, Brazilian tax authorities have understood that remittances to another country deriving from technical assistance or technical services, without technology transfer, are subject to withholding tax (WHT), even to countries which Brazil has tax treaties.
Recently, the government of Finland announced its intention to file a denunciation against the agreement entered into by both countries to avoid double taxation. As a result, the Brazilian Federal Revenue Department (RFB) acknowledged the need to review the COSIT Interpretive Declaratory Act and requested the opinion of the Office of the Attorney-General of the National Treasury (PGFN) on the matter.
The PGFN issued an opinion (Opinion 2363/2013) that remittances to another country deriving from contracts regarding the rendering of technical assistance or technical services, without technology transfer, fall within Article 7 (Companies Profit) of the Organization for Economic Co-operation and Development (OECD) Model Convention, instead of Articles 21 or 22 (Income not Expressly Described). Therefore, such amounts should only be taxed in the country of residence of the foreign company and should no longer be subject to WHT.
This understanding, however, is limited to some treaties. Opinion 2363/2013 says:
… the aforementioned conclusion does not apply to cases in which the company performs its activity through a permanent establishment located in Brazil, nor to the occasions in which, as a result of negotiations held between the signatory countries, there is express provision in the agreements authorizing taxation in Brazil. I.e., in the latter case, in the circumstances in which the international agreements or protocol provision authorize the taxation in Brazil, as in the case of treaties and protocols which characterize the amounts paid as royalties, such services may be submitted to the treatment established in Article 12 of the Model Convention (Royalties), irrespective of the nature of the service rendered (principal or accessory nature), Article 7 not being applicable.
The PGFN's opinion is not yet legally binding to all tax authorities. However, administrative rulings requests and refund claims will be analyzed according to the new understanding.
Marcos Matsunaga
Brazil – interest on overdue taxes under São Paulo's tax amnesty program
The State of São Paulo calculates interest on overdue taxes at a rate based on a daily percentage, which may reach the total of 3.6 percent per month. However, the Brazilian Supreme Court (STF) has decided that the states and the federal district cannot set monetary restatement indexes greater than those set by the federal government for the same purpose – the SELIC rate (RE No. 183.907- 4/SP and ADI No. 442).
In addition, the Special Chamber of the Court of Justice of the State of São Paulo, acknowledged that the interest rate shall be equal to or smaller than the rate applied by the federal government for the same purpose (Action against Unconstitutionality No. 0170909-61.2012.8.26.0000, judged on 27 February 2013).
Nevertheless, State Decree number 58.811/12, which established the State Tax Debts Amnesty Program, determined that interest on debt should be calculated using rate fixed by the State Law number 13.918/2009, which exceed the SELIC rate.
After analyzing cases regarding the State Tax Debts Amnesty Program, the Court of Justice of the State of São Paulo ruled the recalculation of tax debts under the São Paulo's Amnesty Program, excluding the default interest under State Law number 13.918/2009 and applying the SELIC rate.
Recently, new State Law number 15.387/2014 reopened the State Tax Debts Amnesty Program, keeping the same provision regarding interest rate. Based on the decisions cited above, taxpayers have good precedents to challenge charges by São Paulo State, even under the amnesty program.
Brazil – new guidance on WHT, capital gains and foreign currencies
Brazil's Federal Revenue Service published Normative Instruction 1,455/2014 (IN 1,455) on 7 March 2014, setting the applicable rules regarding withholding income tax (WHT) on remittances to legal entities located abroad. Among other guidance, IN 1,455 regulates how non-residents should calculate taxable capital gains, which are essentially defined as the positive difference between an assets' (or shares') acquisition cost in Brazilian real (BRL) and its sale price in BRL.
According to this guidance, the acquisition cost of equity interest in foreign currency should be converted into BRL at the exchange rate in force on the date of acquisition of an investment that will be transferred, such as the disposal value in foreign currency should be converted into BRL. In this case, the exchange rate variation between foreign currency and BRL could result in a positive difference and thus a capital gain, even though there is no positive difference in foreign currency.
For example, for an investment acquired at a value of 100 US dollars (USD) and disposed at USD100, there is no positive difference. However, in the case of Brazilian currency devaluation (USD 1 = BRL 2 on acquisition and USD1 = BRL 3 on disposal), there is positive difference and capital gain in BRL. In other words, the new guidance could result in significantly more tax payable.
Where companies do not observe the methodology under the IN 1,455 and a positive difference in BRL arises between acquisition and disposal values on the eventual change of shareholders, KPMG in Mexico believes WHT would probably be assessed. However, there are good grounds to argue that the capital gain on an investment originally made in foreign currency by a non-resident should result from a positive difference of the acquisition cost and the disposal price in the foreign currency.
Canada – appeal court narrows scope of foreign affiliate anti-avoidance rule
Canada's Federal Court of Appeal (FCA) unanimously upheld the Tax Court of Canada's (TCC) decision in the taxpayer's favor in The Queen v. Lehigh Cement Limited et al. (2014 FCA 103). The FCA agreed that the foreign affiliate (FA) anti-avoidance rule should not deny a deduction for exempt surplus dividends that a Canadian corporation received from its U.S. affiliate through a tax-efficient financing structure.
However, the FCA significantly narrowed the scope of the FA anti-avoidance rule from the TCC's determination, concluding that the rule is targeted at taxpayers whose principal purpose of acquiring or disposing of the shares of a non-resident corporation is to manipulate its FA, controlled FA or related corporation status.
Czech Republic – reporting requirements for cash pooling transactions
Certain cash pooling transactions are subject to a reporting requirement of the Czech National Bank (CNB). If these transactions are not reported to the CNB, relatively severe penalties may be imposed.
France – court rejects 'free capital' re-assessments of branch banks
In April 2014, the French high court (Conseil d'Etat) issued several decisions affirming the judgments of a lower court of appeals that re-assessments made with respect to French branches of foreign banks, based on a 'deemed' thin capitalization standard, were not supported by law.
The high court held that banks (like any other company) are free to choose how they fund their business (i.e. by debt or equity).
Read the article
Hungary – EU Court of Justice considers whether group taxation is discriminatory
The Court of Justice of the European Union recently considered whether Hungarian tax law—that serves to disadvantage undertakings linked, within a taxpayer group, to companies established in another EU Member State—constitutes an indirect discrimination on the basis of the location of the registered offices of the companies.
India – signs its first set of advance pricing agreements
India's advance pricing agreements (APA) program, introduced as a method of proactive dispute resolution, became operational on 1 July 2012. Although the program was seen as a positive step toward curbing the unprecedented litigation that was affecting investor sentiment, taxpayers were apprehensive of the practical challenges associated with APA negotiations.
Amid the prevailing uncertainty, Indian taxpayers filed over 140 APA applications in 2013, with KPMG in India handling over 40 of them. India has now signed its first batch of APAs with five multinational corporations, fixing their tax liability in cross-border transactions over the APA term.
The APA program is important for providing certainty to taxpayers. Generally, an APA is valid for up to 5 years and can be renewed, revised or cancelled in some circumstances. During the 5-year period, the taxpayer is required to file an annual report to confirm compliance with the terms of the APA. The tax authorities shall conduct a limited audit of the taxpayer to ensure compliance with the APA's terms.
Mayur Desai
India – revenue authorities increasingly challenge deductibility of management fees
International companies in India generally have affiliates in the form of limited companies. Lately, the Indian Revenue authorities (IRA) have been challenging the tax deductibility of headquarters cross-charges (e.g. management service fees charged by the global company to its Indian affiliate).
The IRA is asking for information such as:
Where the Indian affiliate (i.e. payer) cannot provide this information to the IRA's satisfaction, the IRA may disallow the expenditure to the Indian affiliates (separately from transfer pricing audits wherein the arm's length price of the cross-charge is determined by the transfer pricing officer). However, this risk may be mitigated by maintaining robust documentation.
Nilesh Modi
India – no adjustments for corporate guarantee, alleged notional interest
The Delhi bench of the Income-tax Appellate Tribunal held that a corporate guarantee issued by the taxpayer for the benefit of its related entities (and that did not involve any costs or have any bearing on profits) was not an 'international transaction' for purposes of India's transfer pricing rules.
India – tribunal rejects mended return filed in advance of transfer pricing adjustment
The Mumbai bench of the Income-tax Appellate Tribunal upheld the imposition of a 100-percent penalty under section 271(1)(c) of the Income Tax Act.
The tribunal determined that the taxpayer filed the amended (revised) return after the return had been referred to the Transfer Pricing Officer and only in anticipation of a transfer pricing adjustment. Thus the tribunal held that the amended return was not 'voluntarily' filed. (Deloitte Consulting India Pvt. Ltd. v. ACIT) (ITA Nos. 7650 and 7651/Mum/2013)
Mexico – Supreme Court rejects pro-rata expense limitations
Mexico's Supreme Court declared unconstitutional a provision of the Mexican Income Tax Law, in force until December 31, 2013, that prohibits the deduction of "pro-rata expenses incurred abroad with whom are not taxpayers of income tax". This declaration of unconstitutionality is not absolute. The resolution itself requires the taxpayer to meet certain conditions to qualify for the deduction and indicates that the tax authority must verify whether such requirements are met before rejecting this type of expenses.
Netherlands – Dutch taxpayer liable for Swiss captive subsidiary's profits
A January 2014 decision of the Dutch district court of Zeeland/West-Brabant concerned a Swiss captive-insurance company (without employees), taxing most of its profits back in the hands of a related Dutch taxpayer and imposing 50 percent penalties. No appeal was filed, and the decision is now final.
Oman – Tax Department focuses on finalizing tax assessments
The Oman Tax Department plans to complete tax assessments for tax years up to and including the 2012 tax year. Oman's full tax assessment system gives the Tax Department five years (from the end of the tax year in which the tax return was submitted) to make their enquiries. Given this extended enquiry window, companies usually have several open tax years, and the Tax Department often raises enquiries regarding multiple tax years at the same time and typically allowing taxpayers only 30 days to respond.
KPMG in Oman has seen a significant number of enquiry letters, covering as many as four open tax years, up to the 2012 taxation year. The letters generally give the taxpayer only 30 days to respond and, based on discussions with the Tax Department, the aim is to finalize assessments by the end of July 2014.
Poland – anti-avoidance provisions in pending legislation
In March 2014, Poland's cabinet approved changes that aim to streamline tax proceedings and improve the tax collection process. Among these changes, the most important include:
Read the article (PDF 146 KB).
Poland – draft legislative changes to APA program
Poland's Council of Ministers in March 2014 approved guidelines with respect to draft legislative proposals to amend the advance pricing agreement (APA) program. Among other changes, the proposals would expand the availability of APAs, which are currently limited to one type of transaction entered into between two parties only. In particular, an APA could apply to cost sharing agreements among members of multinational groups.
Portugal – transfer pricing law changes allow more unilateral APAs
Changes to Portugal's corporate income tax law, enacted for 2014, included amendments to the transfer pricing rules. Among other things, the new rules allow for unilateral advance pricing agreements (APA) regardless of the existence of an income tax treaty between Portugal and the home country of the related counterparty. Previously, unilateral APAs would only be considered where such a treaty was in place.
Singapore – finding of tax avoidance arrangement upheld on appeal
Singapore's Court of Appeal affirmed a decision of the High Court, finding that the taxpayer had undertaken a tax avoidance arrangement, but that the Comptroller had acted ultra vires in trying to use additional assessments as a means to claw back previously paid tax refunds.
At issue was whether section 33 of the Singapore income tax law applied to the taxpayer's financing arrangement. Because the taxpayer had no bona fide commercial justification, a further issue was whether it was appropriate for the taxpayer to have taken into account certain franked dividend income and interest expenses in its tax return and thus whether the taxpayer was entitled to tax refunds.
Slovakia – new guidance on transfer pricing methods
The Slovak Financial Directorate issued a 'methodical guideline' concerning transfer pricing methods. Among other things, the guidance describes in detail the transfer pricing methods that are based comparing prices (e.g., traditional transaction method) and methods based on comparing profits (e.g., transactional profit method). The transfer pricing method selected and used must be proved to the tax authorities and the transfer pricing documentation must set out the taxpayer's reasoning for choosing a particular transfer pricing method was chosen.
United Kingdom – HRMC officials share views on alternative dispute resolution
KPMG in the UK recently hosted an event for Alternative Dispute Resolution Practice (ADR) practitioners from accounting, law and commercial firms together with senior HM Revenue and Customs (HMRC) people including: Gill Aitken, HMRC General Counsel and Solicitor, Iain McNeill, Head of Large Business Risk, and Val Hennelly, Head of Dispute Resolution.
Kevin Elliott, who leads KPMG in the UK's ADR practice, summarizes the main issues discussed by each of these officials:
Gill Aitken, General Counsel and Solicitor
Gill recently took on the role as HMRC's General Counsel and Solicitor and is a member of the ADR Panel. Gill described her role as a guardian of cases accepted into the ADR program. She views ADR as beneficial to HMRC and taxpayers but believes the benefits will be lost if inappropriate cases are accepted.
Gill also noted that a number of people in HMRC's Solicitors' Office have undertaken mediation training with the Centre for Effective Dispute Resolution (CEDR). While these people are not intended to take part ADR meetings, it is beneficial to have CEDR-trained individuals in the Solicitors Office to inform decisions on which cases HMRC should litigate.
Iain McNeill, Head of Large Business Risk
Iain is a member of the ADR Panel and is also involved in disputes governance. He chairs the Large Case Management Board and is a member of the Enforcement and Compliance Dispute Resolution Board and Transfer Pricing Board.
Iain confirmed that HMRC's Large Business Directorate, established to deal with the 2,000 largest UK businesses, should not affect the ability of these businesses to have their cases accepted into ADR. Where cases are rejected, HMRC will determine whether there are other ways of supporting Customer Relationship Managers (CRM) to help resolve disputes.
Any application for ADR is notified to the relevant Deputy Director (DD). The DDs expect their CRMs to work hard in applying dispute resolution techniques in their own cases, with the DDs providing support when appropriate. The DDs are held to account through hard targets for resolving disputes in their regions. The standard target is to resolve enquiries within 18 months. The target is achieved in 85 percent of cases. The remainder are listed for review at financial year-end and prioritized for resolution in the following year.
Val Hennelly Head of Dispute Resolution Unit
Val is a member of the ADR Panel and is responsible for running the ADR program. Val confirmed that the number of cases going into ADR is increasing and the quality of applications is improving due to better understanding of what cases are appropriate. The general consensus is that HMRC are looking to expand the situations in which ADR can be applied.
Kevin Elliot
United States – appeals rules aim to clarify jurisdictional issues
Before the end of 2014, the Internal Revenue Service (IRS) Appeals Office is expected to clarify its procedures for sending cases back to the Compliance function when new facts come to light. The IRS is also expected to lengthen the minimum amount of time required on the statute of limitations for cases coming to Appeals to 365 days (from 180 days).
Although Appeals will send a case back to Compliance any time the taxpayer produces new information, different rules will apply when a taxpayer overseen by the IRS Large Business and International (LB&I) Division raises new arguments. In this situation, the case will remain in Appeals' jurisdiction but Appeals will give LB&I an opportunity to review and comment on the new argument. Similar rules will apply in Small Business/Self-Employed Division field cases.
United States – guidance on applying tax principles to virtual currency transactions
The IRS has issued guidance in the form of frequently asked questions (FAQ) on the application of existing general tax principles to transactions using virtual currency, explaining that virtual currency is not treated as currency that could generate foreign currency gain or loss for US federal tax purposes. The IRS has also said that virtual currency such as Bitcoin is property for federal income tax purposes, bringing clarity to a murky area that some have worried could enable tax avoidance.
Read the FAQ (42 KB).
United States – KPMG webcast replay examines IRS' Transfer Pricing Audit Roadmap
On 14 February 2014, the Internal Revenue Service (IRS) Transfer Pricing Operations team released the Transfer Pricing Audit Road Map, new guidance to assist IRS examiners with their transfer pricing examinations. The road map provides examiners with a practical approach to the identification of transfer pricing issues and the development of those issues that merit a full review.
On a recent webcast, senior professionals were joined by Samuel Maruca, IRS director, Transfer Pricing Operations, Large Business & International Division, for a discussion of the road map, its key concepts and its application to transfer pricing examinations. Speakers also discussed the three phases of the transfer pricing exam, the enhanced role of the taxpayer in the process, and the IRS' view of how transfer pricing examinations should be developed.
View the webcast replay.
United States – IRS files supplement in Eaton transfer pricing case
The Internal Revenue Service (IRS) filed a supplement to its motion to amend an order in the Tax Court that included a detailed statement of facts and grounds for why the IRS cancelled the advanced pricing agreements at issue in Eaton Corp. et al. v. Commissioner. The taxpayer is seeking a redetermination of deficiencies and penalties that resulted from transfer pricing adjustments by the IRS.
United States – IRS releases Competent Authority statistics for 2012-13
The Internal Revenue Service has released its competent authority statistics for the 15-month period from 1 October 2012, through 31 December 2013, for its Advance Pricing and Mutual Agreement Program and the Treaty Assistance and Interpretation Team.
United States – IRS updates FAQ on general FATCA issues
The Internal Revenue Service (IRS) has updated its list of frequently asked questions (FAQ) on general issues associated with the Foreign Account Tax Compliance Act (FATCA) requirements, adding new questions and answers on the registration process and on responsible officer topics.
Read the FAQ.
United States – Tax Court orders production of opinion letters after privilege waived
The US Tax Court held that two partnerships must produce attorney opinion letters on tax shelter transactions if the partnerships persist in good-faith affirmative defenses to accuracy-related penalties, finding that they forfeited the attorney-client privilege by putting the partnerships' state of mind and beliefs into issue.
Read the Tax Court's opinion (PDF 78 KB).
© 2015
KPMG International Cooperative ("KPMG International"), a Swiss entity. Member firms of the KPMG network of independent firms are affiliated with KPMG International. KPMG International provides no client services. No member firm has any authority to obligate or bind KPMG International or any other member firm vis-à-vis third parties, nor does KPMG International have any such authority to obligate or bind any member firm. All rights reserved.


text:
Taliban militant kills 2 inside Defense Ministry
KABUL, Afghanistan A Taliban militant opened fire inside the Afghan Defense Ministry on Monday, killing two Afghan soldiers in the latest daring attack inside a government or military installation.
The Taliban said one of their agents who was also an army officer planned the attack to coincide with a visit of the French defense minister. French officials said the minister, Gerard Longuet, was not in the ministry at the time.
Despite the Taliban claim, Afghan military officials said it was not immediately clear whether the assailant - who was wearing a vest rigged with explosives - was an enlisted soldier or an insurgent disguised in a military uniform. The vest did not explode.
The assaults over the past four days - first inside a police headquarters, then a base shared with American troops and now the heart of the Afghan military establishment - signal the start of the Taliban's spring offensive after a relative lull over the frigid Afghan winter.
Afghanistan's war usually follows an annual cycle, with fighting increasing in the spring and summer as insurgents pour over the mountainous border from Pakistan. But the recent security breaches suggests that the Taliban are getting better at striking at the core of the Afghan security forces.
The ferocity of the Taliban's spring offensive will help determine whether the surge of more than 30,000 additional U.S. troops that President Barack Obama announced in December 2009 succeeded in arresting the insurgency.
The string of attacks since Friday shows that while the insurgents have suffered setbacks in their southern strongholds, they still have a slate of militants willing to take on deadly missions.
The assaults also demonstrate the geographical reach of the insurgency beyond the south. The most recent attacks were in Kabul and eastern Laghman province, while a deadly attack against the United Nations earlier this month happened in the previously peaceful northern city of Mazar-i-Sharif.
On Monday morning, a man dressed in an army uniform opened fire at the door of the Defense Ministry compound's main office building. He shot and killed one soldier at the entrance, then killed another as he bounded toward the stairs that lead to the offices of the minister and other high-ranking officials, ministry spokesman Gen. Mohammad Zahir Azimi said.
Another seven soldiers - including two officers - were wounded in a shootout before the attacker was killed with a shot to the head.
Taliban spokesman Zabiullah Mujahid said the attacker was an army officer who had been in the service for at least three years and was stationed at the Defense Ministry. He said he worked in concert with two accomplices. Azimi said there was only one attacker.
The Afghan Defense Ministry is well guarded, with at least three checkpoints stopping vehicles and people before they reach the main entrance. Soldiers are required to show identification to enter and visitors must be confirmed by the people they're meeting.
The attack came two days after an Afghan soldier working as a Taliban sleeper agent turned on his colleagues, killing five NATO service members, four Afghan soldiers and an interpreter. A day earlier, a suicide bomber dressed as a policeman blew himself up inside the Kandahar police headquarters complex, killing the top law enforcement officer in the restive southern province.


text:
Let There Be Light
Thursday, July 31, 2014
As World War Two was ending in the mid 1940s, John Huston began to make a film for the US Army on veterans who'd been psychologically damaged in battle. As WNYC's Sara Fishko tells us, the film "Let There Be Light" was filled with gripping footage of ailing veterans. But the film never saw the light of day until thirty-five years later. Here is this Fishko Files (first aired in April 2012)…
WNYC Production Credits...
Associate Producer: Laura Mayer
Mix Engineer: Wayne Shulmister
Managing Editor, WNYC News: Karen Frillmann
Produced by:Sara Fishko
Leave a Comment
Email addresses are required but never displayed.


text:
Calculate The Check DigitNov 1, 2009
who can provide me a full formula enabling me to calculate the check digit(MOD 10) of the a given number?
who can provide me a full formula enabling me to calculate the check digit(MOD 10) of the a given number?
How do I create a formula that will calculate a check digit for a 9-digit number using MOD 10? The weighting is 212121212. The problem I am having is that if the sum of the product is in double digits, they must be treated as individual digits.
Number To Be Calculated: 0 0 4 4 5 5 5 2 5
Weighting: 2 1 2 1 2 1 2 1 2
Sum: 0+0+8+4+1+0+5+1+0+2+1+0
22/10 = 2 r2
10-2 = 8 (Check Digit)
Is it possible to create such a formula? I need to calculate several hundred and do not want to do this manually!
How to calculate a check digit in excel. The details to calculate this are as follows:
All variables in the calculation are positive integers.
We take each integer of the pro number and multiply it by a value and sum them to get a total.
An Example: 8 Digit Pro Number: 66988757
Pro Number: 6 6 9 8 8 7 5 7
Position in the Pro Number: 1 2 3 4 5 6 7 8
Multiply each digit in the pro number by (10-position) in the number, to achieve a sum.
Using our example pro again:
6*(10-1) + 6*(10-2) + 9*(10-3) + 8*(10-4) + 8*(10-5) + 7*(10-6) + 5*(10-7) + 7*(10-8)
6*9 + 6*8 + 9*7 + 8*6 + 8*5 + 7*4 + 5*3 + 7*2
54+ 48+ 63+48+40+28+15+14 = 310
Take the Sum of the previous calculation and divide it by 11
310/11 = 28
(Actually, it's 28.181818, but since we're working with integers, we truncate everything behind the decimal).
Figure a remainder by multiplying the quotient by 11 and subtracting from the sum.
Remainder = 310 - (28*11) ---> Remainder = 310 - 308 ----> Remainder = 2
Check Digit = 11- Remainder
Check Digit = 11 - 2 ---> Check Digit = 9
Note: if the check digit is 10 or 11, need to subtract 10 from the Check Digit.
My company uses 4 types of barcodes 8, 12, 13, & 14 number barcodes for our products my problem is that I can't figure out how to force the barcode to format properly no matter how somebody enters it if they don't use spaces or put them in the wrong spots, I can't use custom formats because there is 4 different layouts
8 digit should be "#### ####"
12 digit should be "###### ######"
13 digit should be "# ###### ######"
14 digit should be "# ## ##### ######"
these barcodes are in columns L, M, & N also right now 'm using a formula in another cell to verify the barcodes by calculating the check digit and comparing it to the check digit typed the formula i'm using is
I wanna create a buildin check digit for container numbers
so it will exists out of 11 cells. ( GATU 021097-9 )
is it possible when u type any letter/number in the first cell on a row it automaticly jumps to the next cell, repeating this for the full container number ?
I have a spreadsheet that pulls in a log file after running a macro with 100000eight digit numbers which may or may not have a record in the system. These numbers are produced by using any seven digits and adding a check digit at the end for an eight digit number using the mod function specifically Mod7...=MOD(A1,7) , for example, if cell A1 has 1234567 the mod7 function will produce the check digit 5 then concatenating for the eight digit number 12345675. the next number will be produced by adding 1 to the end of the 7 digit number 1234567+1=1234568 then concatenating again the number with the check digit 6, 12345686. this would be sequential order.
my spreadsheet gets all the eight digit numbers with no record and sorts them in MOD7 sequential order in one column. since the spreadsheet ignores the eight digit numbers with records. my compiled list of numbers have non sequential numbers in the list.
i need a way in VB to loop through 100000 lines (column A) and find the first and last number of a MOD7 sequential range and place the first number in (column B) and the last in (column C).
I have figured a way to do this in a spreadsheet but it takes too many functions and calculations in 100000 lines so the spreadsheet takes too long to open and sometimes crashes!
Combining two equations with MOD function for UPC check digit calculation.
I wanted to combine these if possible,
This is my code. It is for checking that only a 4 digit fiscal year is entered in a cell. The code works fine except it only checks a max of three time. So if the user enters xxx it will prompt for a correct response three times, if xxx is entere a 4th time then that value appears in the cell. I was wondering why this is taking place.
Here is my
I know you can take a number from one cell and combine it with number from another cell and make it one number. What I need to do is the reverse. Take a two digit number in a cell and separate it into single digits in two cells. If you have the number 50 in a cell, then is there a formula that will take the 5 and put it in cell and take the 0 and put it in the cell beside it?View 4 Replies View Related
I have a column of 6 digit numbers in excel, and I need to remove the last digit from each number, turning it into a 5 digit number. No rounding, just simply remove the last digit. Each number is different. Does anyone know how to quickly and efficiently remove the last digit from each number? I can convert to alphanumeric string if need be...View 4 Replies View Related
I need a macro where I can highlight a column and change all of the 2 digit years to a 4 digit year (actually, some of the 2 digit years are only 1 digit, e.g. "9" instead of "09").
I have an if then statement that I can use in the column after it, but I'd rather change the actual numbers in the original column, rather than adding another column (and having to keep the original, too).
The statement I had was:
I just copy dragged down to get the cell numbers for the rest of the column... but using A1 was just for an example, here, it's not necessarily going to be in that column. It needs to be just whichever cells I select.
It seems like it should be pretty simple, but I don't know how to word it in a macro.
Starting Column Example:
[Code] ......
For some reason I can't get rid of the borders...
I have an address (city, state, zip format) in a cell. Some of the zip codes only have a 4-digit zip code which is the way the file was received. I know these zip codes have leading zero. How can I convert these to a five-digit code. Examples are as follows:
Waltham MA 2453
convert to 'Waltham MA 02453'
Boston MA 2210
convert to 'Boston MA 02210'
convert to 'CEDAR GROVE, NJ 07009-1174'
convert to 'TEANECK CITY, NJ 07666'
I have 2 digit years (98, 99, 00, 01) that I need to convert to 4 digit years (1998, 1999, 2000, 2001). There is one year per cell. If it was simply a matter of adding 19 or 20 to the beginning of each, I could do that. But since there's a combination of both 19 and 20 that needs to be added and there all intermingled, I'm not sure how to do it.
Can a rule be written to add 19 to the beginning except if the current cell starts with a 0, then add 20? The highest year is 2008 (no 2010 to deal with).
98 --> 1998
99 --> 1999
00 --> 2000
01 --> 2001
I have data in Row 53 that spans 7 columns, but stays in the same row. I want to design a loop to select every 7th cell in that row and check if it is empty. If not, add onto a "counter" then display the final number of occupied cells (the value of the counter) at the end. This is what I have so far, but I get all sorts of errors.
Sub Tester()
Dim WB As Workbook
Dim WS As Worksheets
Dim modCounter As Long
Dim Cell As Range
Set WB = Workbook("Transverse Series.xlsm")
Set WS = WB.Sheets(BM18)
[Code] ......
I am using this codeView 5 Replies View Related
How do you remove the last 2 digit
12345688 88
12548963 63
14552365 65
So in column B is would show
Say I have a sets of numbers in column A as below:
I know the formula to select the last number:
=RIGHT(A1,1) gives the answer 3
=RIGHT(A2,1) gives the answer 9
To select the last 2 numbers is:
=RIGHT(A1,2) gives the answer 23
=RIGHT(A2,2) gives the answer 89
My query is to select ONLY the 2nd last digit (being 2 in A1 or 8 in A2).
Is there a way to build a 12 digit calculator in excel?View 9 Replies View Related
My question is, a formula was provided to me that add's a comma and a space after a 15 digit sequence of numbers, that formula is:
And what that does is it would change data in a cell that looks like this
To this:
The formula works great, thanks to the help of the posters!
However I just ran into an issue, what if I have a set of data in a cell that looks like this:
And I need a space and a comma at the end of each sequence, so the above would change to this after the formula is applied:
Now the data in the cell is wrapped so it lists one set of numbers, then the next set, then the next set as seen above.
I have column a with 1000 ten digit numbers. I need to remove the
digit in the fourth place from the left side in the entire column. I don't know how .
how you can determine if a cel value is a number or a digit
It is actually for a column to determine if it has a heading or not and acordingly y have to count the rows off that "current region" and put some values with a formula next to this column.
Y was testing an expression with this
msg = IIf(target.End(xlUp).Value = "X", "is this a LETTER", "is this a DIGIT")
I am trying to sort a spreadsheet in descending order of a certain column. I have been able to do so quite easily in the past. However, for some reason, when I am trying to sort it now, it is sorting based only on the first digit of the number in the cell. For example, the order after sorting may end up as 90, 9, 9, 82, 8, 8, 8, 74, etc. I don't know what happened to cause the change, or how to fix it.View 6 Replies View Related
Well I want to add few numbers in a few number for example I have ten columns containing few cell numbers and i want to add 92 my country code with it. I have tried this by using replace formula but in result it comes in text format from which i cannot use another formula unless text format is removed and for that i have to do it one by on in every single cell. I have attached a sample sheet.View 4 Replies View Related
Imagine a cell has a value of "008281" at A1
I want to return the first digit of the 6 digits in A1 which will be "0" in A2.
I tried using the formulae in A2 with "=left(A1,1), it returns "8" instead.
I have data in cells A1:Z1. The data is all 1 digit numbers, but sometimes they have asterisks behind the number. For instance in cell A1, I have 4, but in B1 I have 3**. I want to take the first digit of each cell and add it together and the result to be in AA1. The only thing I can think of doing is =SUM(LEFT(A1), LEFT(B1)...) but that's going to take too long (especially as I add columns).View 3 Replies View Related
I have a slight problem...I have a range of values..
I need to count the occurance of a a particular no. from 0-9.. So i want to know how many times say 0 appears in that range of values etc so on till 9. I tried using CountIF but the problem i face is lets say in my cell 0903 there are 2 0s inside, it doesnt count this 2 zero..
How can I get one cell to increase by 1 after I change the date in another cell. The spreadsheet is used to keep track of Oxygen Bottles at the local Fire Dept. and I want the " Times Filled" cell to increase by 1 after the " Date Filled" cell is changed. I'm not sure if they key the date in or if they use a calender add-in pop up.View 5 Replies View Related
I have many dates in a column in a 6 digit format such as:
These dates are Feb 23, 1995; Feb 24, 1995 etc.
How can I convert these dates in the column to 2/23/1995, 2/24/1995 etc?
I have the following dates in a column and need to convert them to the short date format:
91113 (Sept 11, 2013)
100713 (Oct 07, 2013)
122612 (Dec 26, 2012)
40413 (April 04, 2013)
Those are just some examples. When I convert these as is I get dates that are really far in the future. Some dates are 5 digit and some are 6.
I have column b filled with 17000 plus numbers formatted as text. I need an easy way to delete the first character on the left in each cell provided it is a zero.View 2 Replies View Related
I have the following
[Code] .....
AK5 value will be 2 - 21.
I need it to display
or whatever the number is after A1D, but when AK8 = a value of 1 or 2 or 3...... It comes back as A1D1 or A1D2... How ca I keep the two digits in AK8 to stay and put the value the way I want in AE5 ...
I have simple (or not) question:
how can I convert a digit that I input into a cell to an hour format ?
I want to achieve something like this:
- when I input a digit into a cell , for example: 9 a want to convert it to 9:00 (9 hours, 0 minutes). How can I do it ?
I am trying to find a way to turn the raw data below, into the results on the right. Specifically I would like to extract any 5 digit (denoted by "." as a break) numrical value from the cells in column A (there could be as many as 20, 5 digit numurical values, id like each one listed in b2, c2, c3, and so on)
1Raw Results
2abc.k(p).nov20.99375.65487.12354.jan13.p 99375 65487 12354
3edf.jun20.99815.p 99815
4abc.s.jan40.65841 65841
5tge.s.96514.jan15.96548 96514 96548
IS THERE A FORMULA TO CONVERT THE 5 DIGIT # INTO ITS CORRESPONDING DATE?View 9 Replies View Related
I'm trying to figure out how to setup a worksheet to find the most common 2 digit numbers going vertically from the bottom(cold) to the top(hot) it would consist of 90 digits 0 thru 9
it would look like this
4 0 3 9 0 4 3 3 2
9 2 5 6 5 6 9 6 6
8 9 9 3 1 0 2 9 8
1 6 7 5 9 9 8 2 5
2 7 2 2 2 8 5 1 3
0 1 4 7 4 7 6 0 9
3 5 6 4 3 3 0 4 4
7 8 8 1 8 5 7 8 7
5 4 1 8 6 1 1 5 1
6 3 0 0 7 2 4 7 0
each vertical line would be considered weeks 9 thru 1. week 9 would be the first vertical line of digits on the left. it could also contain the most common 2 digits horizontally. Both 2 digit values would be color coded ex. blue equals most common 2 digit horizontally and green equals vertically. I would also like to color code the most common 2 digit value diagonally as long as it is the most common of either the vertical or horizontal 2 digit. Each number is seperate on the worksheet they would not be pairs. im using excell 2003.
The last digit of a number (can be any demonination but always an integer). I know that you can check the last digit of a number with =RIGHT(A1,1) but I would like to check whether the last digit in number is 1,2,3,4,5 and if so change the whole number to a number ending in 5. If the original number ends in 0,9,8,7,6 then I want it to be changed to end in 9. Is this possible and if so is there an excel function that I could use??
e.g. 143 -> 145
e.g. 1037 -> 1039
I am importing data from a .csv file. The file contains dates like 02/15/40. The year is 2040, not 1940. Excel doesn't seem to use the Control Panel -> Regional Settings change when I open this file. I have my Regional Settings set to 2000 => 2099 to change to a two digit year. If I open a blank worksheet and type in 2/15/40 in a cell...Excel does the correct conversion to 2040. However, when I open a .csv file it considers it 1940.View 2 Replies View Related
I have a cell with a number which is a result of several previous sums. It's a number with 8 to 11 digits. For example: 878567663.
I need to add each digit of the number, and then add again the result until I end up with a single digit. In the above example it'd be (8+7+8+5+6+7+6+6+3=56), then (5+6=11), then (1+1=2) and put the end result (2) in a cell
My main doubt is that I don't know how to use a simple "do while" type structure in Excel to achieve the above.
1.) How do I create a formula to do that?. I have seen solutions in this board that let me add each digit but that's it... I need to "reduce" it until only one digit is left...
2.) What about if the lenght of the number is not always the same (fe. in one cell is 8, in another is 11, the next one is again 8...)?
I have some alphanumeric mixed data which is from 15 digits to 18 digits. In each data there have 5 zeros in the middle. I want to keep all the alphanumeric to 15 digits only. It will delete the zeros not any other value which length is greater than 15 digits. If a length of a character is 17 digit it will delete 2 zeros & if it is 15 digit then keep it constant.
Like: AJSPP00000125467 change to AJSPP0000125467.
I need composing a formula that will add a space after every 4th Number in a 16 digit Character Set.
ex. 0101 0101 0101 0101


text:
Pyrazinamide (PZA)a frontline tuberculosis (TB) drugkills dormant persister bacteria and plays a critical role in shortening TB therapy. PZA is used for treating both drug susceptible and multi-drug resistant TB (MDR-TB) but resistance to PZA occurs frequently and can compromise treatment.
A recent study, led by researchers at the Johns Hopkins Bloomberg School of Public Health and Huashan Hospital, Fudan University, has identified a new mechanism for PZA-resistance, which provides new insight into the how this mysterious drug works. The study is available online June 12 in the journal Emerging Microbes and Infections.
Previously, the Johns Hopkins group identified mutations in the pncA gene and the rpsA gene as the primary causes for PZA resistance. According to the study authors, resistance to PZA is most commonly caused by mutations in the pncA gene encoding enzyme nicotinamidase/pyrazinamidase, which converts the prodrug PZA to the active form pyrazinoic acid (POA), and sometimes associated with mutations in the drug target RpsA (ribosomal protein S1). The active form of PZA, POA, interacts chemically with RpsA to block the trans-translation process, which is essential for bacterium's survival under stress conditions.
However, for unknown reasons, some PZA-resistant TB bacteria lack mutations in pncA or rpsA. The current study suggests that mutations in the panD gene may also be involved. PanD encodes aspartate decarboxylase, which is involved in synthesis of the amino acid β-alanine, a precursor for pantothenate (which is vitamin B5) and co-enzyme A biosynthesis. The panD mutations were identified not only in mutants isolated from in vitro but also in clinical isolates such as in the naturally PZA-resistant bacterium M. canettii strain and in a PZA-resistant MDR-TB strain.
"There is significant recent interest in understanding PZA, since it is the only TB drug that cannot be replaced without compromising the
|Contact: Tim Parsons
Johns Hopkins University Bloomberg School of Public Health


text:
Cheap PLJ to Lubbock flights
Popular Flights from Placencia, Belize
Top Placencia Flights to US Destinations
Top Placencia International Destinations
Popular Flights from Lubbock, Texas
Top Lubbock Flights to US Destinations
Top Lubbock International Destinations
PLJ to LBB Route Map
Placencia to Lubbock Flights, Stats and Airplanes
Route information for flights from Placencia to Preston Smith Intl..
1,449.17 miles
LBB - Preston Smith Intl. Airlines
Browse the most popular airlines servicing the Lubbock (LBB) airport. Visit their flights pages to learn more about the most popular routes these carriers fly.


text:
More than half of users of an online financial-education program called SaveUp wound up increasing their savings, a survey of credit unions found. SaveUp teaches how to pay off debt, save more money and run one's personal finances, and it offers a shot at a $2 million jackpot.
View Full Article in:Wisconsin State Journal (Madison)
Published in Brief: