Web Design and Development Agency in Syracuse, New York Offers web design and development, e-commerce, Flash animation, streaming media, online marketing and search engine optimizations We Develop data-driven web systems, including e-commerce, promote and market them. Free Web Design and Website Development, Search Engine Optimization, Promotion and Online M […]
where A1, B1, C1 are the cells you want to combine.
or
Concatenation via macro:
———————————————————————————————
Sub ConcatenateColumns()
'Click the top cell in the right-hand column of data that you want to concatenate. _
For example, if cells A1:A100 and B1:B100 contain data, click cell B1.
Do While ActiveCell <> "" 'Loops until the active cell is blank.
'The "&" must have a space on both sides or it will be
'treated as a variable type of long integer.
ActiveCell.Offset(0, 1).FormulaR1C1 = _
ActiveCell.Offset(0, -1) & " " & ActiveCell.Offset(0, 0)
ActiveCell.Offset(1, 0).Select
LoopEnd Sub
-------------------------------------------------------
OR:
Just use the & character to merge fields.
If A1 contains "NikolayGul." and B1 contains "WordPress.com"
in C1 type =A1&" "&B1
You would get NikolayGul.WordPress.com
"The 22 Immutable Laws of Marketing: Violate Them at Your Own Risk! " – Book Review.
During recession and global financial crisis it is even more interesting to discuss this book. The global financial crisis of 2008–2009 began in July 2007 when a loss of confidence by investors in the value of securitized mortgages in the United States resulted in a liquidity crisis that prompted a substantial injection of capital into financial markets by the United States Federal Reserve, Bank of England and the European Central Bank. The TED spread, an indicator of perceived credit risk in the general economy, spiked up in July 2007, remained volatile for a year, then spiked even higher in September 2008, reaching a record 4.65% on October 10, 2008. In September 2008, the crisis deepened, as stock markets worldwide crashed and entered a period of high volatility, and a considerable number of banks, mortgage lenders and insurance companies failed in the following weeks.
Al Ries and Jack Trout refer to these principles as "laws". Their book, entitled "The 22 Immutable Laws of Marketing" is one of my favorites.
What do you think about "22 immutable Law of Marketing"?
Are there more marketing laws?
Why these marketing laws are immutable?
(sorry for pure quality of video)
1
The Leadership
It’s better to be the first than it is to be better. Executive Summary Being first in any category is going to give you the edge -being the leader comes from being first. It’s much easier to get into the mind of consumers first that try to convince people you have a better product or service than the one that did get there first. Improvements are always made to product/service inventions and innovations but the first in has a head start. Once you are the leader, a position mostly gained by being first, it is pretty hard for competitors to dislodge you, as long as you keep your products up to date and of comparable quality. Further, the first in to the market has the opportunity to have its brand name adopted as the generic category name. Once you are first and get the consumers to buy your brand, often they won’t bother to switch. People tend to stick with what they’ve got.
2
The Category
If you can’t be first in a category, change the nature of the category or set up a new category you can be first in.
3
The Ladder
The strategy to use depends on which rung you occupy on the ladder.
4
Duality
In the long run, every market becomes a two-horse race.
5
The Mind and Perception
Marketing is not a battle of products, it’s a battle of perceptions; and sometimes it’s better to be first in the mind than to be first in the marketplace.
6
Focus
The :lost powerful concept in marketing is owning a word in the prospect’s mind. "
7
Extension
There’s an irresistible pressure to extend the equity of the brand.
8
Exclusivity and Superiority
Owning a superior position in the customer’s mind is vital; marketing is a continuous search for exclusivity.
9
Division
Over time, a category will divide and become two or more categories.
10
The Heart (Emotion)
Marketing strategies without emotion will not work.
11
Attributes
When you have to focus on attributes, for every one of them, there is an opposite and effective attribute.
12
Candor
When you admit a negative, the prospect will give you a positive.
13
Sacrifice
You have to give something up in order to get something.
14
Success
Success often leads to arrogance, and arrogance to failure.
15
Failure
Failure is to be expected and accepted.
16
Unpredictability
Unless you write your competitors’ plans, you can’t predict the future.
17
Hype
The situation is often the opposite of the way it appears in the press.
18
Acceleration
Successful programs are not built on fads, they’re built on trends.
19
Perspective
Marketing effects take place over an extended period of time.
20
The Opposite
If you are shooting for second place, your strategy is determined by the leader.
21
Origin
Where brands come from is often more important than how good they are.
22
Resources
Without adequate funding and expertise an idea won’t get off the ground, and a brand cannot be built.
During recession and global financial crisis it is even more interesting to discuss this book.
What do you think about "22 immutable Law of Marketing"?
Are there more marketing laws?
Why these marketing laws are immutable?
HDTV – stands for High Definition TV and while the FCC does not have a standard definition for HDTV, it is widely agreed upon that HDTV is defined as having higher quality video, audio and a wider image aspect ratio than standard television broadcast signals.
After the transition to color TV in the 1950s and ’60s, nothing has had as much impact on the TV world as HDTV (high-definition TV) and digital TV. That’s right, TV is going digital, following in the footsteps of, well, everything. We’re in the early days of this transition — a lot of TV programming is still all-analog, for example. And this stage of the game can be confusing, with an alphabet soup of acronyms, changing technologies, and emerging standards.
More than 50 years ago, a group called the NTSC (National Television System Committee) put together a group of technical specifications and standards that define television as we know it today. Sure, there have been some changes in those 50 years (such as the addition of color), but today’s analog TVs are built on this NTSC system.
In the 1980s, the ATSC (Advanced Television System Committee) was formed to move TV forward.
Many years later (1996), the ATSC’s recommendations for a digital-television system were adopted by the FCC (Federal Communications Commission — the folks who set standards for TV broadcasts, regulate phone companies, and fine Howard Stern). ATSC standards use newer-than-1953 technology to give you TV like you’ve never had before:
Widescreen images like those in the movies
Greater detail — up to six times more detail
Sharper images
Smoother, more filmlike images with no video flicker
All digital, with none of the “ghosts” and other image problems found in analog TV Understanding video standards HDTV (and digital TV, or DTV, in general — there are some digital TV variants that are not high-definition, and we discuss them in this section) is all about giving you a bigger and better picture, better audio, and generally making your TV-watching experience more like a movie-watching experience. In fact, at its best, HDTV is so realistic that it’s often described as “looking through a window” — as if you’re really there, not just watching a program.
There are three essential concepts to understand when you are comparing different video standards:
Resolution: the number of individual picture elements that make up a TV image. The higher the resolution, the more detailed the image, and the sharper the image will appear.
Resolution is defined by one of two factors:• Lines (the number of left-to-right lines the TV can display). CRT-based TVs (tube TVs) are rated this way.
• Pixels (the number of pixels across the screen times the number up and down). Fixed-pixel displays (plasmas, LCDs, DLPs and the like) are rated this way.
How to Calibrate HDTV? Calibrating your HDTV gives you the best picture, whether you have an LCD or plasma television. No need for a professional calibration; you can do it yourself. Follow step-by-step instructions in this video tutorial:
Scan Type comes in two forms: • Interlaced scan: These TV images are created by lighting up every other row of horizontal lines on the screen in one instant, and then going back through and lighting up the remainder of the lines in the next instant. It happens so fast that your eye can’t really tell it’s happening.
• Progressive scan: These systems light all the horizontal lines in the same instant, which can make the image seem “smoother” and more like film (or real life).
Aspect Ratio (the shape of your TV picture):
• Traditional TVs have a 4:3 aspect ratio (screen shape). This means that for every 4 units of measure across the screen, you have 3 units of screen height. For example, if the screen is 12 inches wide, it will be 9 inches high.
• HDTVs have a 16:9 aspect ratio — which makes the screen relatively much wider for the same height, compared to a 4:3 TV. Most movies are widescreen (16:9, or even wider), so HDTVs can display most movies without the annoying “letterbox” black bars on the top and bottom of the screen.
HDTV standards
There isn’t a single “HDTV” standard out there. Instead, ATSC contains many different TV standards (with different resolutions, aspect ratios, and scan types) — 18, in fact. Some of these standards are truly HDTV; most are not. In the real world, you will deal with four standards when you try to watch TV content on your HDTV. The two primary HDTV standards are these:
720p: This provides 720 lines of resolution with progressive scan (hence the p). By comparison, NTSC has less than 480 lines of resolution. 720p uses a 16:9, a widescreen aspect ratio.
1080i: This variant (the highest resolution within the ATSC standard) uses interlaced scanning, but provides 1080 lines of resolution. 1080i is also widescreen, with a 16:9 aspect ratio.
There is actually a higher HDTV variant in the ATSC standard — 1080p, which is a progressive scan variant of 1080i. Only a few HDTV projectors (in the $40,000 and above price range) can handle this variant, and we know of no material that is broadcast or otherwise available as 1080p. So don’t worry about it. True HDTV performance requires at least 720p performance. If a TV program, movie, or other content is not at least 720p (either 720p or 1080i), it is not HDTV. If a TV can’t display at least 720 lines of resolution, it is not HDTV-capable.
If a salesperson tries to tell you that an inexpensive plasma set, regular DVD, regular digital cable, or regular satellite TV “is” HDTV just because it’s digital, it’s not so.
Compatible DTV standards
720p and 1080i are the two HDTV standards, but you’ll also find a lot of digital TV material will be broadcast at lower resolutions that don’t quite make the grade as HDTV. You can still watch this programming on your HDTV — in fact, most HDTVs will make this programming look better than it does on a regular TV — but remember: That stuff is not really HDTV.
480p (EDTV): This enhanced-definition TV standard provides higher-than-NTSC resolution, with progressive scan (NTSC is interlaced). EDTV can be (and often is) 16:9 widescreen, but it is not required to be widescreen.
480i (SDTV): This is interlaced, non-widescreen (4:3), standard-definition TV, equivalent to NTSC analog broadcasts.
Remember these different terms — HDTV, EDTV, and SDTV — when shopping. They will often be in the product descriptions; you need to know exactly what you’re buying.
How do I get HDTV?
Anyone that owns a high definition television can get high definition content. You have three options: over-the-air signals, cable or satellite. Over-the-air signals are those that a typical rooftop antenna would receive…only these signals are digital and encoded in HD. Over-the-air signals are free to receive. The only cost out of pocket would be for the equipment needed to receive them. To receive HD programming from your cable or satellite provider you would need to subscribe to their HD package. This subscription is not free. The provider might require a minimum length of service.
Does owning a HDTV mean that I am watching in high definition?
No. Owning a high definition television is just the first step in watching HD content. The second step is to acquire a HD tuner. The tuner is either built into the television or an external set-top box. The set-top boxes can be bought in stores, but most will come from the cable or satellite provider. The third step is to either subscribe to a HD package or buy an antenna for over-the-air reception. Once steps one, two and three are in place then it is up to you to turn to the HD channel to get started watching high definition programming. And, this is only when the signal on the HD channel is delivered in high definition. How to get free HD Channels?:
A podcast is a series of digital media files, usually digital audio or video, that is made available for download via Web syndication. The syndication aspect of the delivery is what differentiates podcast from other files accessible by direct download or streaming: it means that special software applications, generically known as pod catchers (such as Apple Inc.’s iTunes or Nullsoft’s Winamp), can automatically identify and retrieve new files associated with the podcast when they are made available, and that these files can be stored locally on the user’s computer or other device for offline use. This is done by the podcatcher accessing a centrally-maintained Web feed, which lists files associated with a certain podcast.
I have created the Podcast and Live News page for the WCNY- public broadcasting station of CNY (www.wcny.org). Several types of media were used on the Virtual TV page. Feed from PBS with programs preview, video streaming, audio streaming, RSS feed reader that read feeds from NPR, PBS and other trusted source of information.
Podcasting in Plain English:
A 3 minute explanation of podcasting.
Video & Audio Podcast in iTunes:
How does iTunes and iPod treat podcast files compared to song or audio book files?
Podcast won’t show up in Party Shuffle unless you drag them into the Party Shuffle playlist, and Auto fill won’t include podcasts when copying files to an iPod. In iTunes 4.9, there were some limitations to how podcasts could be used. For example, you could not access podcasts using Music Sharing or create a Smart Playlist of podcasts. These limitations do not exist in iTunes 5 and later
On an iPod, podcasts shouldn’t appear when you select Shuffle Songs or Music Quiz.
What is an enhanced podcast?
An enhanced podcast can include chapter marks and photos. When you play an enhanced podcast in iTunes, a menu icon appears to the left of the display at the top of the iTunes window.
If you click this icon, a pop-up menu appears and displays the podcast’s chapter marks, artwork, and start time of each chapter.
(Note: Mac OS X 10.2.x users won’t see artwork in the pop-up menu, but everything else works the same).
When you play an enhanced podcast on an iPod, your iPod displays the name of the chapter you’re listening to above the playback position in the episode. To see this, press the Select button during play to make a diamond appear in the bar. You can then scroll the wheel right to scrub forward, or left to scrub backwards.
What is Webcast?
A webcast is a media file distributed over the Internet using streaming media technology. A webcast may either be distributed live or on demand. Essentially, webcasting is “broadcasting” over the Internet.
The generally accepted use of the term webcast is the “transmission of linear audio or video content over the Internet”.
A webcast uses streaming media technology to take a single content source and distribute it to many simultaneous listeners/viewers.
Visit Wikipedia to find out more about podcast and webcast
What is RSS?
RSS in Plain English Video. A short explanation of RSS and how it helps you save time reading the web.
RSS (an abbreviation for Really Simple Syndication) is a family of Web feed formats used to publish frequently updated works—such as blog entries, news headlines, audio, and video—in a standardized format. An RSS document (which is called a “feed”, “web feed”, or “channel”) includes full or summarized text, plus metadata such as publishing dates and authorship. Web feeds benefit publishers by letting them syndicate content automatically. They benefit readers who want to subscribe to timely updates from favored websites or to aggregate feeds from many sites into one place. RSS feeds can be read using software called an “RSS reader”, “feed reader”, or “aggregator”, which can be web-based, desktop-based, or mobile-device-based. A standardized XML file format allows the information to be published once and viewed by many different programs. The user subscribes to a feed by entering the feed’s URI, often referred to informally as a “URL” (uniform resource locator), although technically the two terms are not exactly synonymous, into the reader, or by clicking an RSS icon in a browser that initiates the subscription process. The RSS reader checks the user’s subscribed feeds regularly for new work, downloads any updates that it finds, and provides a user interface to monitor and read the feeds.
Several types of media were used on the Virtual TV page. Feed from PBS with programs preview, video streaming, audio streaming, RSS feed reader that read feeds from NPR, PBS and other trusted source of information.
webcast is a media file distributed over the Internet using streaming media technology.
TV History – History of Televisoin and Analog to Digital Transition
CONSUMER AWARENESS IS UP 80 PERCENT SINCE 2006, SAYS CEA Government and Industry Education Campaign Ensuring a Successful Transition On June, 2009, the nation will switch over to digital broadcasting. Analog TV will be a thing of the past. The promise of an all-digital world is at hand. Consumer awareness of the transition to digital television (DTV) grew 80 percent since 2006, according to new market research released by the consumer electronics association (CEA). CEA also released new survey results that predict the success of the national telecommunication and information administration (NTIA)’s converter box coupon program which launched in January and was prominently featured at the 2008 international CES. Converter boxes are only needed for consumers who watch over-the-air broadcasts on an analog television. CEA’s survey found only 11 percent of television households – approximately 13 million – are solely over-the-air households, indicating that NTIA has sufficient converter box coupons to meet potential demand.
Digital Television (DTV) is an advanced broadcasting technology that will transform your television viewing experience. DTV enables broadcasters to offer television with better picture and sound quality. It can also offer multiple programming choices, called multicasting, and interactive capabilities.
WCNY the first broadcaster in Central New York to provide digital television to the area. We were the first broadcaster to provide real high definition television to Central New York. We were the first broadcaster to take advantage of the multi-casting capabilities of digital television to provide several standard television channels along with our high definition programming.
What is DTV?
Digital television (DTV) is an innovative type of over-the-air broadcasting technology that enables TV stations to provide dramatically clearer pictures and better sound quality.
DTV is more efficient and more flexible than the traditional way of broadcasting known as analog. For example, DTV makes it possible for stations to broadcast multiple channels of free programming all at once (called multicasting), instead of broadcasting one channel at a time. DTV technology can also be used to deliver future interactive video and data services that analog technology can’t provide.
Digital Radio
By John Duffy
V.P. Technology and Operations
WCNY-TV/DT and the Classic FM Stations WCNY, WUNY, WJNY-FM
…”You will often hear digital radio described as HD Radio, or IBOC radio, and I’m asked quite often, what’s the difference between these, and what do they mean. HD Radio is just a marketing name for the new digital system. IBOC stands for In Band On Channel. This is the really neat thing about the digital radio system. All of these additional services we will be providing are all combined right inside the same FM channel we are currently using. This means that you will still be able to use your current analog radio to get our WCNY-FM (CLASSIC FM) signal until you are ready to get a digital radio. When you are ready to get a digital radio, you will then be able to receive our WCNY-FM (CLASSIC FM) programming in higher quality, and with no transmission static, and also take advantage of the additional programming services that we will provide. Digital radios are available for both home use and for your car”… Read full article High Definition Radio – Digital Radio
What is HD Radio™?
HD Radio is an upgrading of the way AM and FM radio signals are transmitted, from analog to digital signals. Sounds neat. But what does that mean for us listeners?
HD Radio technology allows broadcasters to transmit a high-quality digital signal. For listeners who have an HD Radio receiver, the benefits are:
FM radio with near CD-quality sound
AM radio that sounds as good as traditional FM
No more static, pops, crackles or fades
Transmission of additional information, such as song titles and artists
Increased listening options with multicasting
Tagging a song for later purchase
Listen Free WCNY’s HD RadioDTV FAQ and information on Analog to Digital Transition could be find here
If you have questions about DTV transitionsubmit them here or e-mail to: john_duffy@wcny.org
Social network service focuses on building online communities of people who share interests and/or activities, or who are interested in exploring the interests and activities of others. Most social network services are web based and provide a variety of ways for users to interact, such as e-mail and instant messaging services.
Short explanation of social networking websites and why they are popular. This video comes in an unbranded “presentation quality” version that can be licensed for use in the workplace
Social networking has encouraged new ways to communicate and share information. Social networking websites are being used regularly by millions of people, and it now seems that social networking will be an enduring part of everyday life.
The main types of social networking services are those which contain category divisions (such as former school-year or classmates), means to connect with friends (usually with self-description pages) and a recommendation system linked to trust. Popular methods now combine many of these, with MySpace, Facebook, Twitter and LinkedIn being the most widely used in North America;[2] Nexopia (mostly in Canada);[3] Bebo,[4] Facebook, Hi5, MySpace, dol2day (mostly in Germany), Tagged, XING;[5] and Skyrock in parts of Europe;[6] Orkut, Facebook and Hi5 in South America and Central America;[7] and Friendster, Orkut, Xiaonei and Cyworld in Asia and the Pacific Islands.
Social networks have for several years been the toast of new media. Their principal strength has been an ability to gather tens of millions of unique users. Their main shortcoming, however, has been the inability of several social networks to monetize their volumes of signed-up users.
In economics, a financial market is a mechanism that allows people to easily buy and sell (trade) financial securities (such as stocks and bonds), commodities (such as precious metals or agricultural goods), and other fungible items of value at low transaction costs and at prices that reflect the efficient-market hypothesis.
Financial markets have evolved significantly over several hundred years and are undergoing constant innovation to improve liquidity.
Both general markets (where many commodities are traded) and specialized markets (where only one commodity is traded) exist. Markets work by placing many interested buyers and sellers in one “place”, thus making it easier for them to find each other. An economy which relies primarily on interactions between buyers and sellers to allocate resources is known as a market economy in contrast either to a command economy or to a non-market economy such as a gift economy.
The financial crisis is not over. Neither tax rebates nor low interest rates nor higher or lower exchange rates can do the job of reviving an economy that is burdened by debt loads that are too high. On the contrary: the policy measures that the US authorities have been applying will prolong the agony. Be prepared for the challenges of extended financial turmoil and economic stagnation.
How to prevent financial losses?
Presented by WCNY’s Financial Fitness Cayuga Fund – Make Money for Education.
Markets are interrelated, and a problem in one market can have its source in a different market. This finding is a starting point for macroeconomics. To limit the number of markets they must explore, economists conventionally lump together or aggregate the vast number of markets in a modern economy into only four: markets for goods and services, financial assets, money balances, and resources.
Holiday Gift Tags and Labels - Make holiday presents stand out by adorning them with homemade gift tags created from clip art, recycled materials, craft punches, and photos.
Whether you choose to personalize your wedding DVD, a music CD, or champagne bottles, we are here to help you with the perfect gift ideas to make your day even more memorable.
