text:
The Department of Telecom intends to invoke bank guarantees given by service provider Bharti Airtel and has written to banks in this regard as the company has not paid Rs 350 crore penalty imposed on it for providing 3G services outside permitted areas in violation of rules.
"The communication was made by the finance wing of Department of Telecom (DoT) to various banks where they (Bharti Airtel) have provided bank guarantees," a DoT official told PTI.
Bharti Airtel in statement said it has always maintained the highest standards of compliance. "We believe the 3G ICR arrangements are in compliance with all applicable laws and licensing conditions. These arrangements are also hugely beneficial to customers and discontinuing these will cause grave inconvenience to them," the statement added.
The fine was imposed on March 15 for providing 3G services in areas where Airtel did not have 3G spectrum by entering into a pact with other service providers.
Airtel, one of the largest telecom operators in the country, was directed to deposit the penalty amount within 15 days.
The DoT had slapped Rs 350 crore penalty for violation of UAS licence conditions in Haryana, Maharashtra, UP (East), Kolkata, Gujarat, Kerala and Madhya Pradesh service areas where company is providing 3G services to customers without having 3G spectrum and license amendment for right to use 3G spectrum for provisioning of 3G services .
The Delhi High Court on last Thursday set aside a single judge order which allowed Airtel to continue providing 3G intra—circle roaming facilities with other service providers.
The Airtel statement said that the company has filed an SLP against the order of the division bench of the Delhi High Court. "Our SLP (special leave petition) is listed before the Supreme Court on Monday," it added.
DoT last Friday asked Airtel to end its 3G roaming pact with Idea Cellular and Vodafone under which the three firms on quid pro quo basis have been selling 3G services in telecom circles where they hold spectrum for the same.
The Department had also slapped Rs 550 crore penalty on Vodafone and Rs 300 crore on Idea Cellular for violating 3G service roaming norms and had asked them to end the pact by April 8.
Airtel, it is learnt, has been asked to stop providing 3G services by Saturday. This, however, could not be independently verified.

subset: commoncrawl


text:
GENERAL BUSINESS: AEROSPACE Senior Acoustics Engineer Cessna Aircraft Company has an opening in Wichita, KS for Senior More info |
HEALTH CARE: CMAs - F/T IMMEDIATE OPENINGS All shifts for west side home plus. Apply in person at: 254 S. Robin R More info |
GENERAL BUSINESS: EDUCATION WICHITA COLLEGIATE SCHOOL 7th Grade Biology Teacher 2015-16 School Year Wichita Collegiate More info |
GENERAL BUSINESS: PRODUCTION Come work for Collins Bus Corporation, the Worlds Largest Small School Bus Manufacturer i More info |
MANUFACTURING: Industrialisi Now Hiring Join the iSi team! Paint BoothMaintenance 3rd Shift Hazmat Laborer More info |
GENERAL BUSINESS: SOCIAL SERVICE Learning Center Support Staff Adult Day Program M-F; (full-time part-time - daytime More info |
HEALTH CARE: The Good life means a rewarding career at Salina Regional Health Center ... RadiologyTechnologist More info |
GENERAL BUSINESS: APPOINTMENT SETTERS Looking for friendly, outgoing, dependable individuals to set appointments for More info |
ADMIN - CLERICAL: Part Time Runner wanted afternoons for a busy downtown law office. Reliable transportation is a must More info |
GENERAL BUSINESS: SALES Foodservice Sales Professionals Wichita, Kansas US Foods is looking for a Territory Manager in More info |


text:
- About this Journal ·
- Abstracting and Indexing ·
- Advance Access ·
- Aims and Scope ·
- Article Processing Charges ·
- Articles in Press ·
- Author Guidelines ·
- Bibliographic Information ·
- Citations to this Journal ·
- Contact Information ·
- Editorial Board ·
- Editorial Workflow ·
- Free eTOC Alerts ·
- Publication Ethics ·
- Reviewers Acknowledgment ·
- Submit a Manuscript ·
- Subscription Information ·
- Table of Contents
ISRN Physical Chemistry
Volume 2012 (2012), Article ID 835397, 6 pages
Hysteresis of Isotherms of Mixed Monolayers of N-Octadecyl-N′-phenylthiourea and Stearic Acid at Air/Water Interface
Department of Chemistry, University of Botswana, PB 00704, Gaborone, Botswana
Received 11 October 2012; Accepted 2 December 2012
Academic Editors: J. J. Lopez Cascales, G. Pellicane, and P. O. Westlund
Copyright © 2012 Siji Sudheesh et al. This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
Surface pressure area isotherms of Langmuir monolayers formed by spreading mixed solutions of varying concentrations of N-octadecyl-N′-phenylthiourea (OPT) and octadecanoic acid or stearic acid (SA) over air-water interface are described. Examination of the hysteresis behavior and an analysis of the limiting area per molecule of the isotherms show that when the spread solution has an excess of OPT, the limiting surface area is consistent with a monolayer composed of equimolar amounts of the two components. This indicates that any excess thiourea, which on its own does not form a stable monolayer, is squeezed out and is not part of the monolayer. On the other hand, when the spreading mixture has an excess of SA over OPT, the isotherm indicates that the entire originally spread material is incorporated into the surface film. In this case, the values of area/molecule indicate that the monolayer is composed of SA : OPT complex with a ratio of 1 : 1 together with the excess SA remaining in the monolayer.


text:
1900 Lafayette Dollar MS-61 NGC
Product Details
Historic commemorative!
This is the first American coin to bear the likeness of a U.S. president and is also the first classic commemorative Silver dollar. The dies were prepared by chief Mint engraver Charles Barber, while the coin itself was released to the public in 1900. This was the third commemorative coin released by the U.S. Mint following the 1893 Columbian Half and the Isabella Quarter. The coin also features French Gen. Lafayette, who was instrumental in the Americans' success during the Revolutionary War. Lafayette was born in 1757 in Auvergne, France, and after learning of the Revolutionary War taking place in what is now the United States, Lafayette in 1777 decided to join the Americans and was appointed major-general and became a member of George Washington's staff. Lafayette and Washington remained close friends for the rest of their lives. Lafayette played a critical part in the war as he secured French reinforcements. The statue on the reverse is similar to the monument erected in Paris that was given to the French by the American people. The coins originally were sold for $2 each to fund the erection of this statue in Paris near the Louvre in 1908.
Gold -- why buy Gold from APMEX?
Gold is one of the world's favorite bullion investments and is a popular way to diversify one's wealth. Call our Account Managers toll free at (800) 375-9006 or click on the "Live Chat" button. APMEX is where to buy Precious Metals! Also, you can come to us when it is time to sell Gold, Silver, Platinum, and Palladium.Specifications
Product ID: | 77077 |
Year: | 1900 |
Grade: | MS-61 |
Grade Service: | NGC |
Denomination: | $1.00 |
Mint Mark: | Not Shown - Philadelphia |
Metal Content: | 0.7734 troy oz |
Purity: | .900 |
Manufacturer: | Philadelphia Mint |
Thickness: | 3 mm |
Diameter: | 38.1 mm |


text:
Can anyone give me tips about attending the Rose Parade on New Year's Day? We're from Ohio. Which airport would you recommend? What hotel or area? Any other tips would be appreciated.
Does your airport have decent connection into Burbank airport? because that's by far the easiest to deal with. Hotel needs to be booked A.S.A.P because they sell out in about a 20 mile radius of the parade. On the economy side there's a decent Days Inn in Glendale, a Homestead Studios in Glendale, a Courtyard and an Extended Stay Suites or the Safari Inn/ Annabella Hotel in Burbank. More expensive would be the Best Western Burbank, The Glendale Hilton, or the Hilton and Sheraton at Universal Studios Tour. I think Glendale Hilton is the only one that would pick you up at Burbank airport, plus also have easy access to the city buses that go to the parade.
I can get LAX N/S but have to make a connection to Burbank. Is it worth it to make the connection to avoid LAX? As far as hotel location, what do you think about Arcadia? Do I want to avoid driving to the parade? You mentioned the city bus. How crazy does it get? Any other tips for the parade you could pass along? Thanks.
Arcadia is an easy drive to Pasadena. Hotels there will be full up soon, if not already. Well worth it to connect and fly into Burbank. Yeah you are blowing an hour for the connection, but saving an hour and a half shuttling to car at LAX, picking up car and driving an hour or more in traffic to Arcadia. Burbank airport to Arcadia is just two turns onto the freeway and then a 20 minute freeway shot. Depending on when your departure is, LAX can be a nightmare to get to for your flight home. I believe that there is metro/train service from the Arcadia end of Pasadena into the parade. I'll try to find out more about that. Are you buying seats at the parade or just going to stand on the sidewalks? Because one tip is to wait until about 15 minutes after the parade starts , and then journey to Pasadena. Take your place nearer the END of the parade instead of the beginning (it is about a 2 hour parade route, miles long). You will avoid all that early traffic getting to the parade. Wilson Street is a good place to shoot for/ that intersection. Homes all around the area offer $10 parking that morning, there is usually nothing else available. Depending on what time your return flight is out of Burbank, you might want to choose to stay in Burbank or Glendale instead of Arcadia. If it's a weekday/workday.....Arcadia into the city can be a slow mess until 10am.
If your sole purpose for coming to Pasadena is to watch the Rose Parade, you might want to consider Ontario Airport, which is on the east/southeast side of Pasadena, about 45 miles away. If you plan on doing a lot more in LA, you might want to consider John Wayne Airport as well. We went to the Rose Parade '06 from Disneyland. It took us about a half hour to get there, but then it was pouring rain. We're staying in Disneyland again and going to the '07 Rose Parade. We figure, since it rained last year, it would take at least another 20 years to get a rained out parade. By the way, even with the rain, it was an awesome parade. We used to live in Columbus, whereabouts are you? _____________________ M&C
LAX is not that bad of an option. If I were flying with kids I would take the direct flight. Arcadia is only 15 minutes into Pasadena. There is also a four points by sheraton on the Arcadia Monrovia border that isn't too bad. Personally, I would stay at the Sheraton Pasadena and walk to the parade, although I do usually walk to the parade from my house. (Will miss it this year) The Sheraton Pasadena is easy walking distance to Old Town Pasadena and lots of restaurants and shopping. The ice rink and Civic Center as well. We welcome you to Pasadena, although you might want to schedule Phoenix since the Buckeyes will be winning the National Championship a few days later. Go Bucks!!


text:
The curtain falls on Windows Media Center Windows Media Center, Microsoft's long-running effort to blend elements of DVRs, cable boxes, and DVD players into Windows, will be taking its final bow before... Type: News story Tags: Software Windows |
70 |
Asus' 144Hz MG279Q monitor may top out at 90Hz with FreeSync We've been eagerly awaiting the release of Asus' MG279Q, a FreeSync display with an IPS panel and a fast 144Hz peak refresh rate. It... Type: News story Tags: Displays Gaming |
62 |
AMD delays FreeSync support for multi-GPU systems Monitors with AMD's FreeSync technology are finally shipping, but support for the variable-refresh tech has been limited to PCs with single Radeon GPUs thus far.... Type: News story Tags: Graphics Displays Gaming |
44 |
Continuum turns Win10 phones and tablets into desktops At its Build keynote yesterday, Microsoft showed off the adaptability of Windows 10 on a variety of devices. Win10's Continuum feature allows devices to"flex" in... Type: News story Tags: Mobile computing Software Windows |
36 |
BenQ's curved 35'' gaming monitor updates at 144Hz Add another 21:9 monitor to the ranks. BenQ's new XR3501 is the latest display to adopt the ultra-wide aspect ratio, but that's not the only... Type: News story Tags: Displays |
28 |
MS wants Win10 on a billion devices, will support Android apps Microsoft wants Windows 10 to be the platform for developers. At its Build 2015 keynote this afternoon, the company set some ambitious targets for Windows... Type: News story Tags: Software |
114 |
Windows 10 web browser named Microsoft Edge Microsoft's upcoming browser has long been known by its unofficial codename, Project Spartan. Today, we can dispense with that name. The new browser is officially... Type: News story Tags: Internet Software |
75 |
TR's April 2015 peripheral staff picks It's time for our latest roundup of recommendations for monitors, keyboards, mice, and more. We've tied it all together in our April 2015 peripheral... Type: Feature article Tags: Miscellaneous Displays Input devices |
53 |
Monday Night Shortbread Eight is Enough PCWorld: All About PlayReady 3.0, Microsoft's secret plan to lock down 4K movies to your PC Fudzilla: Acer wants to... Type: News story Tags: Shortbread |
65 |
Friday Night Shortbread 7 Up 3D printing is so last year: We're onto 4D printing now - Phys.org Ars Technica: Wi-Fi software security bug could leave... Type: News story Tags: Shortbread |
83 |
Acer's curved G-Sync display costs $1299, ships in September We've heard rumblings about Acer's curved, 34" G-Sync display since January, and now it's official. The XR341CK sports a 21:9 IPS panel with a... Type: News story Tags: Displays Gaming |
63 |
Samsung spills details on flexible AMOLED display Samsung announced its Galaxy S6 smartphone last month, including an Edge variant that curves the screen over the sides of the handset. The Edge... Type: News story Tags: Displays Mobile computing |
33 |
Valve's giving free VR kits to content creators Content creators working on virtual reality can apply to receive free HTC headgear from Valve. Seeding will begin this spring, the Steam steward says,... Type: News story Tags: Displays Input devices Gaming |
20 |
Wednesday Shortbread Eight is Enough InfoWorld: KB 2952664 triggers daily telemetry run in Windows 7and may be snooping on users (thanks Yves) Makeuseof: Every version of... Type: News story Tags: Shortbread |
42 |
Android Wear gets always-on apps, Wi-Fi support The Apple Watch might be the biggest news in wearables when it officially launches this Friday, but Google isn't standing idly by in the meantime.... Type: News story Tags: Mobile computing Software |
4 |
AMD says Windows 10 will be released in late July Microsoft has been coy about the exact release date of Windows 10 thus far, telling us only to expect a launch this summer. AMD... Type: News story Tags: Software Windows |
38 |
Weekend Shortbread Eight is Enough Blogging Windows: Virtual Desktops in Windows 10 - The Power of Windows... Multiplied iFixit's Retina MacBook 2015 teardown WCCFtech: Intel's Type: News story Tags: Shortbread |
99 |
This week produced a bumper crop of security holes, patches It was a massive patch Tuesday this week. We got patches for show-stopping flaws from Microsoft, Oracle, Google, and Adobe. Let's start with Microsoft, who released... Type: News story Tags: Software Operating systems |
17 |
Leaked roadmap charts desktop course for Broadwell, Skylake into 2016 | 11 |


text:
"One essential to success is that your desire be an all-obsessing one, your thoughts and aims be co-ordinated, and your energy be concentrated and applied without letup.
Find a translation for this quote in other languages:
Select another language:
Discuss this Claude M. Bristol quote with the community:
Quote of the Day
Would you like us to send you a FREE inspiring quote delivered to your inbox daily?
Use the citation below to add this quote to your bibliography:
"Claude M. Bristol Quotes." Quotes.net. STANDS4 LLC, 2015. Web. 24 Apr. 2015. <http://www.quotes.net/quote/43148>.


text:
With the running and the falling I would have given this one a 8 out of 10 on the faceplant scale... He dad the cameraman though might score it a bit lower...
For more crazy videos check out The Ballad Of Die Hard or Don't Mess With This Chick!
Dad Is Un-impressed With Faceplant
Check These! Faceplants, ouch, Painful, Skateboarding, viral video
Amazing Catch!
Well that is a little unorthodox... but it got the job done!
For more crazy videos check out I Need A Hero or Most Disturbing!
Flame Thrower Vs. Fire Extinguisher
When I saw the title of this video I knew it must be watched... These two dudes are hilarious to watch too... Have a look...
For more crazy videos check out The Worst Tumors Ever or An Elephant That Can Paint Self Portraits!
Check These! Amazing, Awesome, Fire Extinguisher, Flamerthrower, viral video, Vs.
Super Ninja Catch
Arguably one of the best baseball catches of all time... Watch Masato Akamatsu rob this poor guy of a home run...
For more unbelievable videos check out I Need A Hero or Elephant Takes A Seat!
Check These! Amazing, baseball, Catch, Masato Akamatsu, sports, Unbelievable


text:
Smriti Kak Ramachandran
NEW DELHI: To ensure that Government departments pay for the electricity they consume, Delhi Transco Limited has suggested use of pre-paid electricity cards and automated system of calculating power consumption.
"We have decided that all Government departments that consume less than 45 kW of electricity should be given pre-paid electricity cards and for those who consume more than that, there should be a system of automated computing of consumption," said Rakesh Mehta, Delhi's Principal Secretary (Power) and Chairman-cum-Managing Director of Delhi Transco.
The Transco chief on Tuesday chaired a meeting that included officials from six Government departments that have been declared defaulters.
"While we are already on the job of recovering the outstanding dues, making the switch to pre-paid electricity will help bring in more transparency in the system and also help conserve energy," he said.
Citing the benefits of using prepaid energy, Mr. Mehta said: "We will recommend this suggestion to the Government for immediate implementation as this will help in better energy management, conservation of energy and also in doing away with the unnecessary hassles over incorrect billing. The automated billing system will help track the real time consumption and will leave little scope for disagreement on consumption and billing."
The Delhi Transco, following repeated reminders from the discoms to settle dues, had scheduled a meeting to resolve the issue.


text:
Search Groups
70 members Latest Activity: Feb 25, 2011 This is a group for all you fellow fans of the Twilight Saga. So, New Moon starts shooting March 09 and there are rumours that Eclipse will be made…
154 members Latest Activity: Jan 15, 2012 A Book of the month club. We will choose books and have discussions on books as we read them and full discussion when fully done reading.
32 members Latest Activity: Jan 4, 2010 Okay this is a group that is open to any discussion about the Twilight books, Movie, and etc. Feel Free to join and talk about whatever makes you…
98 members Latest Activity: Jul 20, 2011 For those who can't help but fall in love with Emmett Cullen.
259 members Latest Activity: Jan 5, 2013 Cullenism is a group of people who have come together to appreciate the values and ideals represented by the Twilight series. We are not a religion.
88 members Latest Activity: Oct 11, 2010 whos excited for new moon?? I KNOW I AM! what do u think of them changing directors? do you want Taylor to be jacob?
204 members Latest Activity: Aug 1, 2011 For anyone who loves the Cullens or the Twilight Saga Vamps! :)
76 members Latest Activity: Jul 20, 2011 Cause Jacob Didn't leave...and Taylor is fit! JOIN US (even if you love edward, i mean...who doesn't?) TEAM SWITZERLAND its for those who love…
53 members Latest Activity: Jun 21, 2011 If you love Twilight and live in the Uk. Come and Join here!!!
309 members Latest Activity: Feb 16 The Twilight Saga WOULDN'T EXIST without her.
842 members Latest Activity: Dec 20, 2013 because really, who dosent love Alice?
Welcome toTwiFans-Twilight Saga books and Movie Fansite
Sign Upor Sign In
Or sign in with:
© 2015
Badges | Report an Issue | Terms of Service
Please check your browser settings or contact your system administrator.


text:
Youth Firearms Violence Initiative -- Salinas, CA
Program Type
or Federal Program Source:
Program Goal:
Specific Groups Targeted by the Strategy:
Geographical Area Targeted by the Strategy:
Evaluated by:
Contact Information:
Years of Operation: Between 1984 and 1994, the Salinas community witnessed a dramatic increase in the number of gangs and the amount of gang-related violence. The Salinas Police Department identified 14 street gangs with more than 400 certified and active gang members. Moreover, during this time period, the annual number of homicides in Salinas tripled (75 percent of these were gang related). Notably, 90 percent of the gun-related violent offenses that occurred in the community involved perpetrators under the age of 25 years. YFVI sought to respond to these problems by addressing the community conditions associated with gang violence and gang-related activities through proactive enforcement strategies. Prior to the development of this initiative, the Salinas Police Department had been involved in several antigang efforts, created a Gang Task Force, and had participated in several community partnerships including a violent injury prevention program. YFVI, however, was an independent venture of the Salinas Police Department. The primary component of the YFVI strategy was the creation of a Violence Suppression Unit (VSU) -- which is an expansion of the previous Gang Task Force. The VSU consists of 15 police officers and utilizes a series of aggressive patrol strategies. These strategies include periodic surveillance, probation/parole searches, traffic stops, the use of raids and search warrants to recover illegal firearms and firearms used in crimes, the use of informants, and the development of criteria for determining gang membership. In addition, YFVI developed a Geographic Information System data base that geographically tracks gang-related activity and firearm use. This system allows Salinas police officers to respond to inquiries regarding the location of firearm seizures, violent crimes, and gang incidents near school zones. This initiative has had several successful outcomes. Data show that there has been an increase in the number of violent crime arrests in the Salinas area since the initiative began. Gun-related crimes and violent offenses committed by youth under the age of 25 years dropped considerably during the first 2 years of the initiative (34 percent and 21 percent, respectively). Similar decreases were found for all gun crimes and violent offenses (regardless of the perpetrator's age) occurring in the community, resulting in a communitywide reduction in gun-related and violent crimes. There also is consensus among VSU officers that gang members no longer hang out on the streets. Moreover, anecdotal evidence suggests that the sense of fear among community members has decreased.


text:
QuEST Global Interview Questions
Interview Experience
Interview Experience
Getting an Interview
Getting an Interview
Interview Difficulty
Interviews for Top Jobs at QuEST Global
- Project Engineer (14)
- Engineer (6)
- Engineering (3)
- Software Engineer (2)
- Trainee Engineer (1)
- Senior Officer (1)
- Senior Project Engineer (1)
- Manager, Marketing (1)
- Structural Analysis Engineer (1)
- Structures Engineer (1)
- Sales (1)
- Project Coordinator (1)
- Mechanical Development Engineer (1)
- Mechanical Engineer (1)
- Aerothermal Engineer (1)
- Aero-Thermal Engineer (1)
- Mechanical Engineer -- Structures Analysis (1)
- Supplier Performance Analyst (1)
- Quality Systems Engineer (1)
- Electrical Design Engineer (1)
- Project Leader (1)
- Project Manager (1)
- Director (1)
- Coordinator (1)
- Regional Sales Manager (1)
- Accepted OfferNeutral ExperienceAverage Interview
I applied through a recruiter. The process took 2 weeks – interviewed at QuEST Global (East Hartford, CT) in March 2015.
They described the company then ask you some questions about your resume and sign a couple forms and your done. They were very nice and talked about all the advantages of being with a growing company.
Interview Questions
- What experience you had with excel Answer Question
- Accepted OfferAverage Interview
I applied through a recruiter. The process took 2+ months – interviewed at QuEST Global.
First contacted by recruiter who found my resume on monster.com. Interview process started with recruiter phone call (non-technical... just general/ high level questions). Next step was a phone interview with the engineering center manager- covered general engineering questions, what my intererests were (what team I would like to work for), why I thought I could help that team, etc. After the phone interview I was brought in to give a technical presentation to a couple of the team leads and center manager. That was followed up with a one-on-one with the center manager and then a more in-depth technical interview with a couple of the team leads where they quizzed me on various structures and heat transfer related topics. On-site interview lasted about 2.5 hours. From first contact to offer letter was about 2 months.
Interview Questions
- Can't remember any of the exact questions but I got caught up on some of the thermo/ heat transfer questions Answer Question
Accepted offer
- No OfferNeutral ExperienceAverage Interview
I applied through a recruiter. The process took 4 weeks – interviewed at QuEST Global (Windsor, CT) in July 2014.
Emailed a recruiter due to technical difficulties with their website. They called me after I emailed them my resume for a phone interview a few hours later, then set another on-site interview for the Tuesday after. Called me on Monday saying they need to review my resume for other positions and have to reschedule. The week after I get an email asking for a reschedule, and I set a date for that week. Took ~4 weeks in total. I went there and the recruiter talked about core values and asked me some general questions on what I want from work etc. An engineer on the project came in and asked me a few technical questions related to analysis, a couple of them from sophomore statics that I don't remember, including stress concentrations on a plate with a hole. I was then shown a drawing of a model and was asked how to simplify it for FEA solve times. Overthought it and didn't realize that symmetry counted as a simplification.We took a look at the ANSYS simulation the engineer was running and ended the interview, approximately 1 hour long.
Interview Questions
- What's the stress on a unit cube subject to 5 psi of pressure? 1 Answer
- No OfferNeutral ExperienceAverage Interview
I applied through college or university. The process took 5 weeks – interviewed at QuEST Global (East Hartford, CT) in June 2014.
Submitted an application through my university's private job board and was contacted by a recruiter the next day. We briefly went over my background and I was contacted again, a few days later, to set up an on-site interview. The on-site interview date was set to occur two weeks later. I had a brief discussion 1:1 with an engineer who told me about the company. During this part of the interview, there was not any discussion about my background or any technical questions. I was informed that I was going to be interviewing for multiple positions (I had only applied to structures online). I then had to give a 30 minute PowerPoint presentation on my senior design project to two engineers. After the presentation, I had 30 minute 1:1 technical interview that went over basic structures questions. Following that interview was a 20 minute interview with another engineer covering aerodynamics questions. Finally, there was a demo with an engineering showing some of the work that is done on a computer. The whole process lasted about two hours.
Structures questions: Explain an S-N curve. Explain a stress-strain curve. Draw each one. What is the point of highest stress in a given beam. And other mechanics of materials questions.
Aerodynamics questions: Explain how lift is created on an airfoil. Explain thrust in an engine. What is static pressure? What is total pressure? What is entropy?Interview Questions
- What is entropy? (Measure of disorder is not a valid answer) Answer Question
- Declined OfferNegative ExperienceEasy Interview
I applied through other source – interviewed at QuEST Global.
they seems very unprofessional. never got a straight answer from them during the interview. i ask about the job location they start talking about the benefits, ask about the job description i get answers about the history of the company. they gave me an offer even before an interview , which seemed odd to me. i had to ask for a job description 3 times before i got one which is not related to what actual position is. they never called on time or they wont call at all although they said they will call you at a certain time.
Interview Questions
- no questions at all just the regular where are you from, how much do you want ect Answer Question
Reasons for Declining
very unprofessional company
- Accepted Offer
You will be emailed to set up a phone call. Then they will have you come in and interview with two people, both your "bosses"
Interview Questions
- The will get detailed about your experiences, expertise, and knowledge with a variety of tech. Answer Question
- Accepted OfferPositive ExperienceEasy Interview
I applied through other source. The process took 4+ weeks – interviewed at QuEST Global (Springfield, MA) in October 2013.
I was contacted by someone at QuEST (I did not apply). about a month went by with a few phone conversations and eventually received an in person interview in East Hartford. Since this was my first "real" job out of college I would say the interview was pretty standard. In person interview was very laid back. Spoke about the holiday parties and company activities a bit and was told about the position a little more in depth. I was asked a few basic questons and that was that. Interview VS actual job varies
Interview Questions
- Questions were not "difficult".
reviewed resume and asked basic questions about experience.
Does this position sound interesting to you? why? Answer Question
I did not try to negotiate. I was sent an email stating I was offered the job with my hourly rate on it.
- Questions were not "difficult".
Helpful (2)
No OfferNegative ExperienceAverage InterviewApplication
I applied through a recruiter. The process took 4+ weeks – interviewed at QuEST Global (East Hartford, CT) in July 2013.
I was given a call by a recruiter and then got a call after a week from the company for an interview. So, here I go in for an interview and the hiring manager so call was so busy that she did not come on time and I waited in the lobby for 20 min. So, here she finally comes and what a rude lady she is. She gave me her id and left inside the office without waiting for me to take me inside. So, I entered the office and I totally blanked out because I did not know where she went so I asked someone on where I should go. Then few mins later I was taken to this conference room where there was this another lady she was really nice. So, now the Hiring Manager finally comes in and she talks about the company. As the interview went along she did not make a proper eye contact with me and was too busy looking at my resume. While the other lady asked me questions regarding Excel and other MS office applications. My only complaint is I don't understand why the Hiring Manager had so much attitude. She could have just be nice and polite. Some questions that she asked was a little bit hard to understand since my first language is not English so I asked her politely weather she can repeat the questions to me and so she did. Once the interview was over she left immediately and did not say anything for a week on weather I was considered to move forward or not. So here I wait and I finally emailed the hiring manager and she did not even respond to me "HOW RUDE". Time passed by and I finally at the end emailed my recruiter.
Interview Questions
- Nothing was as such difficult but be prepared to get questions from this Hiring Manager particularly as she is really rude and impolite. Other than that its not that bad. Answer Question
- Accepted OfferNeutral ExperienceAverage Interview
I applied through an employee referral. The process took 6+ months – interviewed at QuEST Global in July 2013.
Initial interview process was via email, phone interview and after 6 months of no contact finally a phone call requesting an inperson interview. At that time met with Program manager and HR admin and the next interview (which was a different date/time) met with project team. It took about 2 weeks after that meeting for them to make an offer.
Interview Questions
- The most difficult question in the interview was, do you want to be busy and can you handle being busy? 1 Answer
There was no negotiation, they came with a number and if you didn't like it you didn't take it. I was told that after a period (unspecified) I would get a review and increase. That didn't happen until the yearly salary review was done and then the increase was less than 2%
- Accepted OfferPositive ExperienceAverage Interview
I applied through an employee referral. The process took 4 weeks – interviewed at QuEST Global (East Hartford, CT) in April 2013.
I was contacted by phone to set up an interview. The administrative assistance contacted me with detailed information on my interview and what to bring for security clearance reasons.
The interview was only 30-45 minutes. I met with two individuals who would be my project lead and my program lead. They showed me a presentation on Pratt & Whitney and how the new supply chain program works. They asked me simple HR questions that related to their core values. Nothing too difficult, no trick questions. The interview was very comfortable and the two individuals made me want to work for the company.Interview Questions
- What was the most difficult situation that you have been put into as a leader? Answer Question
Is this helpful? The community relies on everyone sharing – Add Anonymous Interview Review


text:
Digital cameras opened the door to easy and entertaining photography. However, consumer digital cameras also have their drawbacks: they often produce the so-called digital noise. It can be seen as grains that compromise the smoothness of the photo. It is especially annoying on the skin as it makes it uneven. This kind of noise is called luminance noise. There can also be chroma (color) noise which is perceived as random red and blue pixels spoiling the color accuracy of the snap-shot. Digital noise can be produced by a number of factors: more...
What's New
- Added the Share option that lets users post pictures from the program to the social services: Facebook, Twitter, Flickr, Tumblr, Google+.
- Added compatibility of the plugin with Adobe Photoshop CC, Adobe Photoshop Elements 12, and Corel PaintShop Pro X6.
- Fixed batch processing in the plugin.
- Added support for Mamiya RAW format(*.MOS) and extended more...
- OS X 10.4 or later


text:
Greyhound just cancelled the buses to NYC, so we're not leaving tonight. It's sad but given the situation even if the group decided to go I may have stayed at home. Thanks to all of you who helped me with this. It's appreciated! Again, stay safe everyone!
What the hell is taking OPM so long to close the government? those of us who follow gov schedules would appreciate it, guys.
Not to make light of a serious situation, but that line made me laugh...isn't Cuomo's live-in girlfriend Sandra Lee? Hope everyone stays safe! Here in Philly there is mass-panic.
Good thing the trip was cancelled. If the tunnels and bridges are closed, you wouldn't get through anyway. Atlantic City area - extensive evacuations. Most of the NJ shore towns are evacuated, some optional, most mandatory. My brother lives in a shore town, but he's up on a hill, so he's staying. JCP&L is saying we will probably lose power for 7 - 10 days! I'm worried about a tree on the side of our house, it's bent toward our house and is huge. We were going to take it down last year, after the snow storm, but .... we didn't. The grocery stores have been mad houses. Not a canned good, water, or boxed milk to be found! Cars are in the garage, son's is under the deck. They are now saying the wind will start getting bad tonight/early tomorrow morning. The worst will be late Monday afternoon into Tuesday. Well, at least we'll get to watch Revenge tonight.
Basement things that can be put up are up. Windows duct taped in our breezeway - they're old and aluminum and leak every storm. Lots of water jugs filled (including 5 gallons for the & Barn cat will be dragged in soon. Flashlights ready, everything that can be charged is charged. My son thinks I'm insane. I hope he's right and we don't get the expected 6+ inches of rain.
I'm worried about the gutters on the house. We usually wait for most of the leaves to fall before we get the gutters cleared. And we don't have a ladder tall enough to reach the roof.
Good luck to everyone in the way of Sandy. Hope it turns out not to be too bad but you never know with storms.
try and borrow a ladder if you can as its the main cause of flooding in heavy rainfall?? The only good news for us is with all this rain we won't get all the leaves from the park opposite us as usually they all blow onto our property.. we are just cleaning out our gutters as expecting so much rain.. i'm more worried about our cold front that is going to meet up with the hurricane which likely will mean a lot of snow for us.. but i'm sure what we get will be nothing compared to further south in New York state..
Anticipating a full house tomorrow, we have a generator, so far my mother and father in law and my sister in law and her family are camping out at my house.
Our neighbors are calling us to see if we have a ladder. I don't think we're going to be able to do anything at this point. Also, our garage is basement level, and at the back of the house. So, since the basement is above ground in the back, the roof is 3 stories high! I don't think I'd let my husband go up there, even if we could find a ladder. I'm just hoping it won't be as cold as it was last year. It's in the mid 50's, so we are fine without heat, if it stays that warm. Last year, we just couldn't get warm for days. Judiz, I just realized we're related! Can I come too?
Have to admit I'm glad not to have home ownership responsibilities right now, or concerns about basement flooding. Also grateful to have a carport spot. Still not looking forward to the power outage though, ugh. A gas stove will have to be a priority at this rate for the next place I move to. Take care everyone - praying for no major damage, especially for those of you who already suffered from Irene/the freak October snowstorm last year.
She does, but her chimney got blown out by lightning in a freak storm a few months ago. Cruisey, you ever get that chimney fixed??
Good memory! The chimney did, finally, get fixed. They fixed the bricks about two months ago. But when they tried to put the new liner in for the cold chimney, they saw that the inner base of the chimney was damaged and the liner would not go all of the way down. We actually have two fireplaces, the one that was hit is wood burning and that chimney has the cold flue (exhaust for the hot water heater and furnaces) and the fireplace flue in it. We couldn't turn on the heat until the liner was fixed, or the house would fill up with carbon monoxide. The delay was because the initial quote didn't reflect having to fix the inside of the chimney, they didn't know it was damaged until they went in. so, the insurance company fought with us, a little. The eventually agreed to pay it. We waited, because the furnace is older and we figured that it would make more sense to replace the furnace with a new higher efficiency one, that vents directly outside, if we had to pay it ourselves. Everything is fixed now, over $10,000 worth of damage - between the chimney, the house alarm, the garage doors, my wireless router, and the phones. The insurance company covered it, we just paid a $500.00 deductible. The other fireplace is gas, but it doesn't really put out much heat. Lots of blankets and my dog to snuggle
They both work now. The wood burning one is better for heat, and it's a smaller room, so it is more effective. The only problem is that we rarely use it and it doesn't have a fireplace screen. One more thing, we need to remedy!
Here is Virginia Beach, I just have a lot of wind and rain. There is flooding in a lot of places. It's supposed to get worse tonight. Wondering about work tomorrow - our office building tends to lose electricity fairly easily and our server tends to go down a lot. I would hate to drive in this and then not even be able to work. Meanwhile.....12-year-old floats down Portsmouth (VA) street on air mattress.
Please don't go to work! It's not worth risking your safety! Governor Christy (NJ) has recommended that all private businesses close, though he has not made it mandatory. Almost everything in NJ is closed - Government - Schools - Universities - your name it, it's closed!
We're in Atlanta and despite it being REALLY windy outside, I thought we would be just fine since we're so far down south, so I went to lab. Came out to find all the construction fences blown over and hid in a bus shelter until Boyfriend picked me up. On our way back, we heard this huge explosion and I thought someone had shot fireworks into the air over the street, until we realized that a power line had literally blown up right in front of us We were the first car on one side and obviously we skidded to a stop, same with all the cars on the other side, and as we were trying to figure out what to do literally three or four more bigger explosions went off. Needless to say, we U-turned and got the hell out of there. Traffic instantly dissolved into a mess seeing as there are no traffic lights anymore, and it's Atlanta traffic... I got home and moved my car out from under a tree - admittedly not a huge tree, but a reasonable sized tree all the same, and scooted it to an open area in front of another neighbor's house. Didn't have time to check with him to be sure it was okay but I'm hoping he's not going to call the tow truck on us in this situation.
I'm relieved to hear this. I hope you can at least get your $$ back for the bus tickets since it was Greyhound's decision to cancel the bus run.
I teach in a child care center and we usually never close because the parents freak out if they have to miss work to stay home with their kids. We opened in blizzards, we were open last year during Hurricane Irene and every Noreaster that came our way. Got a call 90 minutes ago that we are closed tomorrow!!!
OK New York Metro area....hurricane Sandy won't even start raining here until tomorrow. So, WHY DID THEY PRE-EPT SKATE CANADA TODAY?!!!!! We get so little figure skating on free TV each season. I really don't care hearing about the same news for 2 hours when they SHOULD BE BROADCASTING SKATE CANADA!! Just had to vent. Sorry........
Another central Jerseyan checking in. Our 3 cars are all gassed up. Two fridges full to the brim and cabinets of canned food. Four cases of drinking water (35 tall bottles each case) from Costco. Filled large pots and pans with cooking water and bathtub and a few buckets with sanitarian water. Flush lights ready. Decent supply of batteries. We are at a high ground so flooding is not a concern. But lots of trees around pose a different type of threat. DH works in Manhattan commuting via NJ Transit and he plans to work from home Mon and Tue. My company has numerous sites in NJ and all are closed tomorrow. It has NEVER been closed during the 5 years I have been with the company, including Irene. So I have to assume this time it is more serious. Sincerely hope everyone will come out of this Frankenstorm safe and sound and without too much misery.
We are allowed to work from home Mon and Tues. will see what it looks like in the am. Just hoping all the trees hold.


text:
About Us
Gift Certificates
Gift Ideas
Sales & Promotions
Offline Order Form
Songs By Subject
Action & Participation
Art Appreciation
Character Education
Classroom Management
English: ESL/EFL/ESOL
Folk Songs
Holidays & Seasons
Music Appreciation
Nursery Rhymes
Reading & Writing
Social Studies
Special Education
All Subjects
Songs By Artist
Songbooks & Sheet Music
SFT Blog
Purchase orders accepted
Hand Talk Children's Song Lyrics and Sound Clip John "Kinderman" Taylor
This song is available on John "Kinderman" Taylor's Kindercise with Kinderman's Friends.
Hand talk, Hand talk Forget about the talk Hand talk, Hand talk Forget about the talk This is an A This is a B Say, C C C C C The D Say A, and B, and C, and D Say, E E E Say F, F makes an eyeglass frame Say this is a G Say H H H Say I Sign Language I feel happy I feel sad I feel scared I feel hungry I feel sick Girls I feel beautiful Boys I feel handsome J, J This is a k L, L M & M, M & M N N N O, O P, P Q, Q R, R
How are you? How are you?
I feel happy I feel sad I feel scared I feel hungry I feel sick I feel beautiful I feel handsome S say that T do that U do that V do that W wiggle that X hold that ayyyyyyyyy say that Z Z Z Z
Hand talk, Hand talk Forget about the talk
See more of our Positive Attitudes Song Lyrics
Many thanks to John Kinderman Taylor for permission to display these lyrics. © John Taylor. All rights reserved.
Positive Attitude Song Lyrics
Positive Attitude Music Products
Powered by Robly™
Songs for Teaching® Using Music to Promote Learning 5501 W. Ross Dr. Chandler, AZ 85226 800-649-5514 (480-689-1190)
© 2002-2012 Songs for Teaching® All rights reserved.


text:
Calculating your Raw Percentage?
Calculating your Raw Percentage?
How do you determine what percentage raw you are eating? I always see people saying they are "95% raw" or "80% raw". How is this calculated? By percentage of calories? Weight of foods eaten? Number of raw meals? How do you determine your raw percentage?
i have no idea. when i wasn't 100% i used "high raw." there's also, "some raw" and "a lot of raw." =)
Probably calculated through sheer guesswork. You can think about it in terms of how many of your approximately 21 meals a week you eat raw—i.e. if you're eating 2 non-raw meals a week, that's 90% raw. Or you can think about it in terms of whether you eat raw except for a few things that are up for debate as to whether they're truly raw—some types of nuts, nori, agave, and so forth. I'll add to pianissima's phrases that some are "raw 'till dinner" or "raw during the week." Gabriel Cousens thinks an 80-90% raw diet is just as optimal as 100%, while others find that there's a whole new world once you're 100%. Ultimately, it's probably most fruitful (no pun intended) to discover through experience what works for you, keeping in mind all the myriad possibilities of what may be true.
From what I understand it has to do with calories- the percentage of calories taken from raw food versus calories taken from cooked food.
I'm not really sure how to calculate the exact percentage, but I think I go with the idea similar to audrey, but I like what pianissima does lol
i dont know either. for each is own if u will. i measured by the mass of it, but calories sounds like good idea. as much as i like math, i just go 100%.
i wouldn't get caught up in how much raw you do, just do the best you can on a given day. if that day it didnt work out 100%. don't repeat the same things you did. thats defined as insanity in the business world. pay attention to yourself everyday. and eventually youll get their. remind yourself why u are doing this. or u can go to wal mart and remind yourself by the people walking around lol. take the information on a raw food diet and customize it to you. juicing is great! but for me i rather smoothie it up.
I think it's just an estimate. At least for me. :D
For Audrey:
My understanding is that Gabriel thinks 80-90% confers huge health benefits,and gives the advantage of a slow detox rather than going 100% straight away, but not that it 'as optimal as' 100%.
'Gabriel Cousens: 'Without doubt, 100% live food is the best diet as it supports spiritual life and compassion and turns you into a superconductor of the divine. It's the Olympic approach.'


text:
So, it was January of 2002, and I was thinking about Brian Eno after talking with Daphne about his wickedly brilliant book 'A Year With Swollen Appendices' and thinking about how to go about writing in this inquisitive yet decisive manner, when it was handed to me. It was the 18th of January, and the e-mail subject read "All For You" and led me to www.themusicissue.blogspot.com. I followed the link, and was changed forever. I'd never heard of a 'blog' before, but this was not the first or last time Daphne hepped me to the latest progression in human communication. Eno's questions were explained to me and more questions posed to me, and I still think about these questions as the days go by. So eight years on, the two of us have conceded that I will never establish a blog of my own and that my wayward thoughts on the sounds I devour daily are better collected and saved than yammered about and then forgotten. Thanks D for creating this all for me and for inviting me into your world!
Timeless. What does this word mean exactly? A word that is used and has been used in the past. Most certainly in the future too. Does it describe something that is not immediately placeable in an era? Does it mean something born in the here and now will live forever? Does it mean that it may have never existed at all?
I present to you an album by a man called Mike Hadreas. He has a story that you will likely find attached to most reviews, attributing the fragility and sombreness of these sounds and subjects to his early experiences. I won't go into that now, because much like last year's phenomenon, Girls, the day to day these people lived through holds little relevance here, not so much as the music they captured and offer for us all to hear.
Mike's debut album is called "Learning" and is credited to Perfume Genius.
I've already met with press describing this work as morose or confronting. I can buy that, but I also think if your the type that finds hope in being at rock bottom, when the only way to go is up, then this music will hold a beckoning sort of radiance for you. Everyone else? They'll just have to use their imagination, and if they're lucky, they'll see it too!
It won't be too difficult with the abundant currents of glorious sound that make up of this set of songs. You will find chiming, hammered pianos among lilting orchestral groans and sighs, many a twinkling synthesizer sequence floating through. Mike's voice has a few key characteristics at play. Many of the vocals are deftly double tracked lending an otherworldly quality to the floating tones and they wind around one another, at times exhibiting a lullaby type quality to it, as if he's singing in hushed tones as not wake you in the process. All the while you will find incredibly strong and sure lead performances that which his ghostly whispers play support. Much of the music is slow and languid and is much the aural equivalent of watching a ball of yarn unravel in slow motion.
Close your eyes and imagine Low playing through a bevy of their favorite Daniel Johnston songs. Imagine Prince as a lovelorn unicorn committing arcane catharsis to Tascam. Imagine a Chan Marshall and Bradford Cox realising a dream-pop doomed high school romance saga.
To just engaging the imagination while this one spins will reward even the jaded listener with an experience visceral as it is challenging, coy yet stark and honest, 100% Mike's music. Highlights flow from beginning to end. This album breathes effortless creativity, seems more like an egg that's been laid than a mere 'work' of art. Clouds obscuring secret cities? This is easily the best thing Matador has released this year! NRS
More information on Perfume Genius can be found: http://matadorrecords.com/perfume_genius/ http://www.myspace.com/kewlmagik http://www.youtube.com/perfumegenius UPDATE Here is a link to a newly posted live session of Perfume Genius, performing much of the album for you to see and hear! http://matadorrecords.com/perfume-genius-session/


text:
ECE 616 Homework 3: Pulse Measurement
Published on
This online course is made available on nanoHUB.org by NSF grant ECCS-1102110, High Repetition Rate Photonic Frequency Combs and Applications.
Find information on common issues.
Ask questions and find answers from other users.
Suggest a new site feature or improvement.
Check on status of your tickets.


text:
by Eric Lemay
(Tokyo, Japan)
Following up on my first MBK Delta Kite story with the last flight of this valiant kite.
Unable to find sufficiently long 5mm dowels, I resorted to gluing 3 pieces together like I had done the first time, however I also glued a shorter piece of 4mm dowel on one side and a very small metal plate on the other, which resulted in a slightly heavier but definitely stronger spreader. I tested the Delta with this new spreader and it flew very well so I decided to decorate it with spray paint, which in retrospect was not a brilliant idea since the paint came flaking off, making this a very messy kite to handle.
Anyway, I took the Delta kite out today and took a few pictures, one of which I am attaching to this flight report. It was a very sunny day but the wind was difficult to handle, constantly changing direction or speed, and sometimes stopping altogether. But it was fun to fly the kite in these conditions, and I had a great time until I made a mistake and landed my Delta into trees... I eventually managed to wrench it free from the branches but the center spar had snapped at the top connection point of the keel, probably due to all the pulling and tugging that was required to bring it out of the branches.
I guess I'll just have to make a new one, and I won't be using any spray paint to decorate it this time.
Comments for MBK Delta Kite - The Last Flight
Apr 22, 15 07:00 AM
A previously published page which gives some background on our three published Roller kite designs. Includes photos and video, if you like Rollers!
Apologies for this site's current lack of video when viewed on mobile devices...
For now, please view this site on a Desktop or Laptop computer to see the videos. And there's plenty of them!
This one's FREE
Download it now!
"Making The
MBK Dowel Diamond Kite"
(see flight video!)
"Making The
MBK Dowel Delta Kite"
(see flight video!)
"Love the easy to understand step by step instructions, made from next to nothing materials and above all so much fun to fly... cheers Tim for sharing your well thought out pdf kite designs with the whole world.
Very satisfying making your own and watching them get air-born for the first time."
"I've just bought your super e-book and spent most of last night pouring through all the great stuff in it!
Very detailed and USEFUL information - thanks for such a great book."
years ago, I tried making a kite using the 'instructions' in a free
kite-safety booklet. What a disappointment for a young boy.
instructions and methods are wonderful. You help the builder to focus on
accuracy, without making it hard. Also, you use materials that are
durable, yet cheap!"
"omg i made a kite from this site and i fly it ....... booom i didnt expect this bc in the other sites instuction are trash
thank you"


text:
Products on Sale are Discontinued Styles or Colors.
The Patagonia Women's Re-Tool Vest is a lightweight fleece vest which performs best during in mild spring or fall weather pursuits. The collar not only stands up, but includes double fleece for extra warmth. The slim fit and princess seams contour to your body so you don't have to sacrifice fashion.
FEATURES of the Patagonia Women's Re-Tool Vest
- Deep-pile recycled polyester fleece has extra-long fibers to retain warmth
- Princess seams add contouring and shaping
- Stand-up collar has doubled fleece for warmth
- Full-length zipper with zipper garage
- Supplex nylon chest pocket flap with stay-put envelope construction
- On-seam handwarmer pockets
- Hip length
SPECIFICATIONS of the Patagonia Women's Re-Tool Vest
- Weight: 10.2 oz / 289 g
- Slim fit
- 9.3-oz Polartec Thermal Pro 100% polyester fleece (51% recycled)
This product can only be shipped within the United States. Please don't hate us.
Patagonia Women's Re-Tool Snap-T Pullover $99.99 - $119.00 |
Patagonia Women's Retro-X Vest $133.99 - $179.00 |
Patagonia Women's Better Sweater Vest $99.00 |
Patagonia Women's Los Gatos Vest $99.00 |
Patagonia Women's Simple Synchilla Vest $89.00 |
Patagonia Men's Synchilla Snap-T Pullover $88.99 - $119.00 |
Patagonia Women's Synchilla Lightweight Snap-T Pullover $99.00 |
Patagonia Women's Full-Zip Re-Tool Jacket $118.99 - $149.00 |
Patagonia Women's Better Sweater Jacket $110.99 - $139.00 |
Patagonia Women's Conejo Vest $94.99 - $119.00 |
custy reviews
for the Patagonia Women's Re-Tool Vest
Average Custy Rating:
(based on 7 reviews)
Viewing All
it is warm without the bulk. it has a nice cut for a woman. you don't have to wash it often unless you drip salsa on it because it's not near your pits. you can ditch your jacket because your core stays warm. yes to the vest!
This vest is comfortable, casual and cool. I think the magenta color makes it a nice transitional fall vest to wear over a long-sleeved shirt or light sweatshirt. Good for a hike or a trip out to lunch with friends -- versatile!
I wear this vest probably way too much, but I love it. Perfect for midwest fall, goes well with anything. Same as all Patagonia re-tool products, it's super soft and comfortable. Couldn't recommend this more!


text:
Home |
Vintage Persian Print Rubaiyat of Omar Khayyam #3 browse these categories for related items... All Items: Fine Art:Prints: Pre 1970: item # 548404
The Old Bazaar Alameda CA 94501 510-910-3922 Guest Book $35.00 |
$35.00 This is one of a series of 10 Art Prints inspired by the Rubiayat of Omar Khayyam produced in the 1960's. Featured languages for prose are French, Arabic and Persian. The border is done in Moghul miniature painting style. Measures 12" by 18" unframed. |


text:
| Format | Pages | Price |   |
Hardcopy (shipping and handling) | 3 | $38.00 |   ADD TO CART | |
Standard + Redline PDF Bundle | 6 | $45.60 |   ADD TO CART |
Historical Version(s) - view previous versions of standard
Translated Version(s): Russian
Significance and Use
This test method is comparative and intended for use as a routine method to test materials for compliance with compositional specifications. It is assumed that all who use this test method will be trained analysts capable of performing common laboratory procedures skillfully and safely. It is expected that work will be performed in a properly equipped laboratory under appropriate quality control practices, such as those described in Guide E882.
1. Scope
1.1 This test method covers the X-ray fluorescence spectrometric analysis of low-alloy steels and cast irons for the following elements in the ranges indicated:
Elements | Mass Fraction Range, % | |
Manganese | 0.20 to 1.50 | |
Nickel | 0.10 to 1.00 | |
Chromium | 0.10 to 1.00 | |
Molybdenum | 0.04 to 0.40 | |
Copper | 0.05 to 0.30 | |
Vanadium | 0.03 to 0.25 |
Note 1—These mass fraction ranges can be extended by the use of suitable reference materials. The detection limit for the elements is lower than the listed minimum value. The ranges represent the actual levels at which this test method was tested.
1.2 This standard does not purport to address all of the safety concerns, if any, associated with its use. It is the responsibility of the user of this standard to establish appropriate safety and health practices and determine the applicability of regulatory limitations prior to use.
2. Referenced Documents (purchase separately) The documents listed below are referenced within the subject standard but are not provided as part of the standard.
ASTM Standards
E135 Terminology Relating to Analytical Chemistry for Metals, Ores, and Related Materials
E350 Test Methods for Chemical Analysis of Carbon Steel, Low-Alloy Steel, Silicon Electrical Steel, Ingot Iron, and Wrought Iron
E351 Test Methods for Chemical Analysis of Cast Iron--All Types
E882 Guide for Accountability and Quality Control in the Chemical Analysis Laboratory
E1361 Guide for Correction of Interelement Effects in X-Ray Spectrometric Analysis
E1621 Guide for X-Ray Emission Spectrometric Analysis
ICS Code
ICS Number Code 77.140.80 (Iron and steel castings)
UNSPSC Code
UNSPSC Code 11101704(Steel); 41115403(Spectrometers)
ASTM International is a member of CrossRef.
Citation Format
ASTM E322-12, Standard Test Method for Analysis of Low-Alloy Steels and Cast Irons by Wavelength Dispersive X-Ray Fluorescence Spectrometry , ASTM International, West Conshohocken, PA, 2012, www.astm.org
Back to Top


text:
Eibach and Bilsein 5100 questions
I just put 285/70/17 Nitto Terra Grappler AT's on my '06 DCLB. They are rubbing on my UCA when making tight turns and I'm trying to fix that. After doing much reading on suspension options I still didn't get the answer I was looking for. What I did get an answer on is that I decided I'm going to get the Bilstein 5100' and pair them with the Eibach springs but I have a few concerns that I couldn't find the answer to.
1. Will raising the front of my truck with that set up fix my problem of my tires rubbing on the UCA? That is the issue that I'm trying to fix 2. How much of a bro lean is this going to give me till I can afford to get new leafs for the back? 3. What spacer are people using for the drivers side? Just a 1/4" seems to be the most popular but is there a certain brand to go with? I would only want to set the BIllys to 0" so I should only get about 1.6" lift. I've only had my truck a little over a year and this is by far the largest project I've undertaken on my own so I would like to make sure I'm not going to be wasting money. Any thoughts or input would be great |
For reference, I have an 09 DCLB with 5100's all around, fronts set to 0" with the Eibachs. I do have a wheelers 3-leaf aal pack in back on top of the non-tsb 3 leaf oem springs, but have a shell & about 50 lbs of various equipment in the bed (gas can & holder, etc.) for about 200 total lbs constant weight.. so it squats the back to about level.. I love the set up, it's great for the price especially. I went with the Toytec 1/4" front top plate spacer for the driver side lean, worked great. Anyway, hope the info helps and good luck! |
My understanding is that if you are running 285's on stock wheels you will require wheel spacers to prevent any rubbing on the uca's regardless of lift
yeah I think the answer to your issue of rubbing on the UCA is either wheel spacers or different wheels with less backspacing.
Once you add spacers or get new wheels that might also affect or cause rubbing on other spots. So you may need to do some measuring and testing before buying parts. |
Most aftermarket wheels will push the tire out far enough to clear the UCA but you want to be certain. I suggest measuring the backspace on your current wheels or post a pic and someone can tell you the specifications on your wheels. Once you have the backspace and offset then you can figure how much less backspace your gonna need on the new wheels. A safe number would be 4" backspace or less, but you may not have to go that low. |
All times are GMT -7. The time now is 02:27 PM. |


text:
Scrabble word: AGARIC
In which Scrabble dictionary does AGARIC exist?
Definitions of AGARIC in dictionaries:
- noun - fungus used in the preparation of punk for fuses
- noun - a saprophytic fungus of the order Agaricales having an umbrellalike cap with gills on the underside
- Any of various mushrooms of the genera Agaricus, Fomes, or related genera, having large umbrellalike caps with numerous gills beneath.
- The dried fruiting body of certain fungal species in the genus Fomes, formerly used in medicine, especially to inhibit the production of sweat.
- noun - any of a family of fungi
There are 6 letters in AGARIC: A A C G I R
Scrabble words that can be created with an extra letter added to AGARIC
All anagrams that could be made from letters of word AGARIC plus a wildcard: AGARIC?
Scrabble words that can be created with letters from word AGARIC
Images for AGARIC
Other Resources
SCRABBLE is the registered trademark of Hasbro and J.W. Spear & Sons Limited. Our scrabble word finder and scrabble cheat word builder is not associated with the Scrabble brand - we merely provide help for players of the official Scrabble game. All intellectual property rights to the game are owned by respective owners in the U.S.A and Canada and the rest of the world. Anagrammer.com is not affiliated with Scrabble. This site is an educational tool and resource for Scrabble & Words With Friends players.


text:
Shopping Cart
Savings of $3.16 (20% off).
Too many of us miss out on opportunities in life because we lack self-confidence. Whether it's public speaking, taking on a leadership role, or asking someone for a date, there are situations in which we just don't feel equipped to handle the challenges we face.
Russ Harris offers a surprising solution to low self-confidence, shyness, and insecurity: Rather than trying to "get over" our fears, he says, the secret is to form a new and wiser relationship with them. Paradoxically, it's only when we stop struggling against our fearfulness that we begin to find lasting freedom from it.
Drawing on the techniques of Acceptance and Commitment Therapy (ACT), a cutting-edge form of cognitive-behavioral therapy, The Confidence Gap explains how to:
You can read this item using any of the following Kobo apps and devices:


text:
Title: | South Florida Swing Dance Society |
Description: | Information and contacts for swing dancing in the Miami-Ft. Lauderdale area. |
Keywords: | Information and contacts for swing dancing in the Miami-Ft. Lauderdale area., |
Category: | Arts and Culture |
State: |
1 | Piedmont Swing Dance Society, Inc. Promotes jitterbug, Lindy hop, and shag dancing in the Triad. Events and dance instruction listings, society information. | 38 |
2 | Chicago Swing Dance Society Promotes the expansion, promotion, and preservation of the Lindy Hop and Jazz music through social dances, class sessions, workshops, and its weekly dance event called JavaJive, at the University of Chicago and throughout the city. | 33 |
3 | South Florida Underwater Photography Society A non-profit organization dedicated to underwater photography. Meeting and dive schedule. | 20 |
4 | Baltimore's Friday Night Swing Dance Club Promotes swing, latin, and social dancing in the Greater Baltimore area. | 48 |
5 | Potomac Swing Dance Club Monthly events, weekly dances, directions, video tapes, dancer''s manual, class instruction. | 39 |
6 | Raper's Swing Dance Corner Includes lesson plans, a who's who in swing dance, Swing Dance Research & Historic Association, dance club listings and music listings. | 156 |


text:
Sorting Text in Excel using Formulas
Sorting text is such a day to day activity that it always surprises me why Excel hasn't provided a simple spreadsheet formula for doing it. Of course you can use the sorting menu command (menu > data > sort) but this requires manual steps (or VBA). Most of the times we get raw textual data from various sources and we need it to be sorted. While fooling with the COUNTIF() formula, I have realized a powerful yet little known feature that can be exploited to sort text using formulas.
We all know that countif()
can be used to find the number of cells in a given range matching a criteria. But do you know that you can use COUNTIF() to find the number of cells in a range greater than or less than a particular value?
Well, that is the trick to sorting text. How?
For eg. assume range A1:A10 has c,b,d,f,h,j,e,a,i,g
in them. When you write =countif(a1:a10,"<c")
you will get 2
as the result.There are 2 cells with value less than "c". In other words, the sort order of "c" in the given cells is 3 (since it has 2 cells less than "c")
You can use this on your own list to fetch the alphabetical sort order of each text value like this:
Essentially the sort order formula looks like this: =countif(SORT RANGE, "<="&CURRENT CELL)
Once you have the sort order, arranging the cells in that order is a piece of cake. We just use VLOOKUP to do our job, like this: =VLOOKUP(1,SORT ORDER TABLE,2,FALSE)
. (PS: if you are worried about unique cells, which you should, then use this formula instead, =VLOOKUP(small(SORT ORDER COLUMN,1),SORT ORDER TABLE,2,FALSE)
What the heck is above formula doing? It is running a vlookup on the table containing original cells and their sort order to fetch the cell with sort order 1 (or the smallest sort order). Replace the 1 with 2 to get the next cell in the alphabetical order.
Download the workbook with alphabetical text sorting using formulas and see this in action.
Bonus tip: Instead of rewriting the vlookup formula with 2, 3, 4 as lookup value you can use excel's row() function to generate those running numbers for you. You just need to subtract correct value from the row().
Also read: Shuffling a list of cells in random order using formulas, More analytics / text processing tweaks
Sign-up for our FREE Excel tips newsletter:
Here is a smart way to become awesome in Excel. Just signup for my FREE Excel tips newsletter. Every week you will receive an Excel tip, tutorial, template or example delivered to your inbox. What more, as a joining bonus, I am giving away a 25 page eBook containing 95 Excel tips & tricks. Please sign-up below:
Your email address is safe with us. Our policies
83 Responses to "Sorting Text in Excel using Formulas"
very nice trick for sorting texts without array formulas. I have never seen this one before.
There is one shortfall though: The technique only works with a list of unique items.
But I guess you could easily solve this problem in a similar way we did it in the 2nd post of the KPI dashboard series for numbers.
Love the RSS, Delicious, and stumble upon icons.
sorry, but the technique in the workbook you posted for download does not work for a list with non-unique values:
E.g. overwrite the second entry in your list (Bill Gates) with the first one (Steve Jobs). The sort order number will then be 10 for the first two rows of the list, there will be no number 9 in the sort order column and the VLOOKUP fails when looking for number 9.
As mentioned you can easily overcome this by adding a help column with formulas that add very small, unique fractions to the text.
Nevertheless: using COUNTIF for sorting texts is a very clever idea and technique. Thanks for sharing.
Oh, by the way: I'm a PC. Replacing Bill Gates by Steve Jobs was just an example…
Easier solution still:
Simply add in iferror and duplicate error values with the value that populates below. Non-unique values cause an error in a specific direction leaving the last "duplicate" correctly populated (unless you reverse the search direction) so simply have your "errors" redirect to the cell below. That way your duplicates will populate correctly without requiring you to create an additional column or using fractions etc.
Example:Say you have your countif on column A, your values to sort on B and your sorted results on C. Say value 3 is a duplicate and will generate an error, using iferror you can just redirect down to the result below and copy the duplicate value correctly.
An actual forumla which makes far less sense looks like this:
=IF($V11="","",IFERROR(VLOOKUP($V11,$T$11:$U$3012,2,FALSE),$X12))The point is, it uses iferror to point to cell x12 below it and gets past the duplicate problem with the "missing" value that V11 is looking at.
This is currently the best method I have seen for sorting via formula. I'm sure there is a way to break it, but I haven't encountered it yet.
Hi PHD,
I am very new to Excel and your site. I must say that alot of stuff I have seen on this site and other other sites linked has really opened my eyes to the possibilities of Excel.
Regarding this technique, I have some questions:
1) Your technique is perfect if the list is small as only a very small amount of formulas (COUNTIF, VLOOKUP) are required to execute it.
2) I fiddled with your file for a long while before I came up with an alternative using MATCH and OFFSET (inspired by Roberts earlier post on Dashboard) – Hence my question is: if the list is huge (e.g 50,000 records and we all know how VLOOKUP freezes up over huge databases) would my method require less resources than yours?
3) I still have not figured a way to cater for unique records using my method…Still like to say thanks for all the posts which is contributing to my appreciation of creativity with Excel!
I have never checked but I doubt MATCH and OFFSET will use less resources and speed up calculations compared to a VLOOKUP solution. I can't think of any formula based, non-VBA solution that sorts 50.000 records in reasonable time.
If you really have 50.000 records, I recommend to store the data in a database (MySQL, Access, etc.), create queries in the database to consolidate and sort the data and retrieve the data in Excel from the database.
If you replace
it works again! Because the SMALL formula looks for the ninth smallest value, which is "10"
Struck by inspiration, I tried SMALL() all on its own with text values, as a possible way of cutting through all the complication.
Sadly, unlike COUNTIF(), SMALL() does not accept strings. I see no reason why it could not have, if MS had thought about it. It would then be the "simple spreadsheet formula" Chandoo wished for.
Chandoo, Derek,
thanks for the tips. This is fantastic.
Using COUNTIF and VLOOKUP for formula based sorting is much more elegant than the technique I used in the KPI dashboard workbook.
And it works with numbers and texts. As derek pointed, the technique using SMALL or LARGE (see KPI dashboard post nr. 2) works with numbers only.
You could easily add an IF-clause into the COUNTIF formula to switch between >= and <= and let the user toggle the sort order.
A really great idea, Chandoo. Thanks for sharing!!
Hi solution to solve the non-unique problem that you foresee in the formula given above
Use "=COUNTIF($A$2:$A$7,"<"&A2)+1″ instead of the formula above
I bet it works.
I would like to thank the person who has devised the formula as it an excellent one! If it doesn't work, give me a slap by emailing me.
Hi PHD/Robert,
Thanks for the feedback. I never touched VBA or macros in my life so all that I know of Excel are just formulas…
Thankfully, I don't have to manage large databases at this point in time… Anyway, I hope I will be able to learn more about creative uses of Excel formulas here!
What if I want to sort the following:
Value, Rank
5,4It should be:
5,4How do I get this to work? I get 4,4 and 4,4 for the last two rows. Help!
@David :
Insert your data, say, in D6 to D10 cell.
Insert one more coln. say "E".
Put the formula "MID(D6,FIND(",",D6)+1,10)" in cell E6 and copy till E10.
Select Range D6 :E10 and sort by col E (Ascending) you will get desired result. -
Thank you Chandoo and Ketan. You guys(/gals?) rock. Since I found this website a few weeks ago I have learned SOOOOOO much. I look forward to learning much more and being able to contribute sometime as well.
David -
Social comments and analytics for this post…
This post was mentioned on Twitter by r1c1: @lohhw3 oops..my mistake, I think you need to use formulas to sort numbers and text. learn more: http://bit.ly/q1zw9…
[…] on Mar.27, 2009. Email This article to a Friend I am inspired once again by the article Sorting Text in Excel using Formulas at Pointy haired Dilbert. In Chandoo´s article he sorts text with a "helper" column. My goal with […]
Thank you very, very much. You really helped me a lot. I was looking for something like that for so long.
thanks man,you guys rock.
i've been looking for something like this for more than a year now.
now u cured my headache.
but i still have something to ask.
i have a list which includes repeating names.
something like the following:
1.Ronald Reagan
2.George Bush
3.Bill Clinton
4.Barrack Obama
5.George Bush
6.Bill Clinton
after i sorted it with ur algorithm,
i found that
1.Barrack Obama
2.Bill Clinton
3.Bill Clinton
4.George Bush
5.George Bush
6.Ronald Reagan
now what i want is just:
1.Barrack Obama
2.Bill Clinton
3.George Bush
4.Ronald Reagan
i'm at my wit's end figuring out how to count only once.
i tried rank and countif with any possible way that i could think of.
there should be a way to do it without resorting to vba.
thanks in advance.
this is not directly related to ur sorting algorithm but
it's partly related i guess because what if the sort list contains repeating entries…-
hi , and thanks alot for this helpful guide
i have same problem like this so i changed the formula for Sort Order in above with this :
if you want to keep duplicated
and this :
if you dont want to keep duplicated
thanks,really appreciate the very quick reply.
now i call that genius.
u guys rock. -
Now that I am asking for your help,let me ask again.
I already googled and tried it out in excel,but can't find what I want,which is:
I have 2 columns,which have repeating names in each column,
I want to get an algorithm to merge these 2 columns into one retaining
only a single instance of same names.
Column A Column B Column C
1.Bill Clinton John Travolta Bill Clinton
2.Barrack Obama Denzel Washington Barrack Obama
3.George Washington Bill Clinton George Washington
4.Abraham Lincoln Paris Hilton Abraham Lincoln
5.Paris Hilton Paris Hilton
6. John Travolta
7. Denzel WashingtonI'm sorry if it's easily achievable and stupid,but I can't figure out how to do it using functions…
Thanks in advance. -
I'm sorry,the words didn't retain the formatting,
let me explain again.
I have 2 columns,which have repeating names in each column,
I want to get an algorithm to merge these 2 columns into one retaining
only a single instance of same names.Column A
1.Bill Clinton
2.Barrack Obama
3.George Washington
4.Abraham LincolnColumn B
1.George Washington
2.John Travolta
3.Denzel Washington
4.Bill Clinton
5.Paris Hilton
6.Abraham LincolnColumn C
1.Bill Clinton
2.Barrack Obama
3.George Washington
4.Abraham Lincoln
5.John Travolta
6.Denzel Washington
7.Paris HiltonI'm sorry if it's easily achievable and stupid,but I can't figure out how to do it using functions…
Thanks in advance. -
Thank you,Sir.
I noticed that I wrote "…do it using functions,but what I meant was…using formulae".
Waiting for your post. -
If you have duplicate items, determine the right index by subtracting the number of identical, preceding rows: =COUNTIF(SORT RANGE, "<="&CURRENT CELL)-COUNTIF(MODIFIED SORT RANGE,"="&CURRENT CELL where MODIFIED SORT RANGE includes the SORT RANGE except the portion below the current cell, ie. $F$3:$F6 assuming the sort range starts at F3 and the current cell is F6.
Very well done and very helpful. Thank you so much.
Thank you so much for your blog and information. I find everything here extremely helpful. My question is about a sort using two columns (or more!) as key, eg. i have one column of non-unique and unique text (let's say {apple, bananna, plum, banana, plum, plum, apple, apple, plum}), and then another column which is uniques values (ie prices). How would i first sort by the first column (which is virtually grouping because I have many similar values), but then sort from big to small? (i will get first all the apples from expensive to cheap, then bananas and then plums)
Gal -
dear all,
i tried this formula on my data that contains: 1,3,4,M1,M27,M16,M31,12,57,216.
it doesn't work, especially on cell contain combined text and number like M1, etc.
how i modify this formula for my above data?
thanks and regards,
war no -
sorry, the link you give is look like to sorting data by "manual" not using formulas like from your web above.war no
dear boss Chandoo,
Great, that's what i want. Thank you very much.
war no -
supper techniqu……… thumps up buddy
Awesome find! Thanks for sharing.
I stumbled upon this forum and this is like treasure island. Great work guys.
I'm stuck at a similar issue and I think you would know a solution.
I'm trying to sort on a non-unique column but also fetching the corresponding unique value
Here is an example. Sorting on Part Name (COL B) :
COL A Part # (UNIQUE) – 9,5,1,7,4,6
COL B Part Name (Non-Unique) – Buffy,Genius,Cherry,Cherry,Sharpie,Amy
Basically part 1 and part 7 are both called Cherry.
COL C – I executed the COUNTIF formula on col B as discussed. Resulting values – 2,5,4,4,6,1
COL D – VLOOKUP for Part # using the small function yeilds 6,9,1,1,5,4
I'm missing 7 for Cherry. Is there a way to overcome this without ceding to VBA ?Thanks
Right after I posted my problem on this forum a bulb lit up. I guess the collaborative brain power on this forum helped clear the clutter in my head.
I used a helper col E to concatenate Col B & Col A so that each row becomes unique. COL D – Buffy9, Genius5, Cherry1, Cherry7, Sharpie4, Amy6. I executed the count-if on the helper col instead of the Part Name. Resulting values – 2,5,3,4,6,1. Now I could do an easy VLOOKUP to fetch both my original Part # and Part Name and said bye-bye to SMALL function.
The scenario posted by Robert for sorting non-unique records could also be solved using this method. Simply concatenate a sequence number behind the name and use count-if on the helper column. This will eliminate the need to use the SMALL function.
Any more ways to solve this problem?
[…] is the tricky part. I have used COUNTIF formula to sort the list. Learn how to sort a list of values using formulas [More on sorting […]
Hi Chandoo,
You made a good point, there is no formula to sort, but using VBA, we can create a function that does it us. So I came up with 2 approaches.
The 1st one "sortme" requires the range and the position number in the sorted list, in this way if you copy the formula down, starting with position 1, you will get a sorted list.
The 2nd one "sortme1″ requires the range and the order, 0 for ascending and 1 for descending. The results come up in the same cell with ; separator (a function limitation as far as try).
Here is the code:Function Sortme(miRango As Range, Optional ByVal Order As Integer) As String
If Order = 0 Then Order = 1
For Each cell In miRango
temp1 = Application.WorksheetFunction.CountIf(miRango, "<=" & cell.Value)
If Order = temp1 Then Exit For
Next cell
Sortme = cell.Value
End FunctionFunction Sortme1(miRango As Range, Optional ByVal Order As Integer) As String
Dim Resp(), C, Largo, temp1, temp2
Largo = miRango.Rows.Count
ReDim Resp(Largo)
temp2 = ""
For Each cell In miRango
temp1 = Application.WorksheetFunction.CountIf(miRango, "<=" & cell.Value)
Resp(temp1) = cell.Value
Next cell
For I = 1 To C
If Order = 0 Then
temp2 = temp2 & Resp(I) & ";"
temp2 = Resp(I) & ";" & temp2
End If
Next I
Sortme1 = temp2
End FunctionEnjoy,
Pablo -
I stumbled upon your page while searching for a formula that will take a column of names, LAST, FIRST, (there are gaps between some names) in a spreadsheet, and display them in alphabetical order (with no gaps between) in a different part of the spreadsheet. I am not well versed in formulas, if you recommend a formula, please explain in simple terms. Thank you in advance. Mike -
I'm new to excel array techniques (and loving it), so please forgive me if my question's solution is obvious, but your tip goes a long way toward answering it.
I need to perform an approximate match upon an unsorted table and then lookup an associated value. For your example, maybe add a approval rating column. Because the unsorted table is dynamic and will gain many new rows over time, I need the solution to be formula-based, with no intermediate tables.
Is there a way to build upon your tip to have the sorted result in memory as an array that then could be applied to the related column? My current strategy would be to use the LOOKUP vector function upon the two like-sorted arrays.
I've learned from some other sources, but am having a difficult time knitting it together (see links below).
Many Thanks!
Mr Excel & excelisfun Trick 36: VLOOKUP w Approximate Match & Unsorted Table?http://www.youtube.com/watch?v=rxhL72gvM5E
Sort values in parallel (array formula)
http://www.get-digital-help.com/2010/01/12/sorts-values-in-parallel-array-formula -
here is what I am getting can someone help?
Sort Order Info needing Sorting Sorted Info
11 Anonymous #N/A
11 Anonymous #N/A
11 Anonymous #N/A
11 Anonymous #N/A
11 Anonymous #N/A
11 Anonymous #N/A
11 Anonymous #N/A
11 Anonymous #N/A
11 Anonymous #N/A
11 Anonymous #N/A
11 Anonymous Anonymous-
i have such as problem
Great formula. I'm trying to take it one step further, but need some help.
I have a long list of items, in 3 different categories (i.e. Column A is all unique values, Column B is 1 of 3 values). I have 3 different tabs, one for each category, where I want an alphabetized list.
How can I alter this formula so that I get numerical order among only the same category? That way I can use an IF formula combined with a VLOOKUP to get alphabetized lists on each category tab.
Here's an example list:
Banana | Fruit
Grape | Fruit
Pork | Meat
Carrot | Vegetable
Beef | Meat
Onion | VegetableHow do I make a formula to get Banana, Beef, and Carrot to all be 1 and the rest all be 2?
By the way, I don't want to manually sort the list as I want to be able to insert new items to the list and have everything re-alphabetize without. Basically, I should be able to data enter on the data tab and have all the other 3 tabs resort after each new entry.
Got it, but perhaps there is a simpler process:
1) I made a new column with formulas =CATEGORY&ITEM to combine the 2 terms (result FruitBanana, etc.)
2) I used the original formula to get an order for all this new merged text.
3) I made column that has this formula =COUNTIF(CATEGORY COLUMN,"<"&CATEGORY CELL). It returned zeroes for the first category items, the number of first category items for the second category items, and the number of first and second catgory items for the third category items.
4) The difference between #2 and #3 gets me the answerObviously I'll combine formulas in 2) and 3) to get 4) with less columns. I can possibly even merge 1) as well so I don't need that column, but I'll have to play around with that.
Essentially the formula is = ORDER OF EVERYTHING – NUMBER OF THINGS THAT FALL IN OTHER CATEGORIES THAT COME FIRST ALPHABETICALLY.
I need to ask help about my problem for sorting.
I am making the NCR report and want to take data from 1 table to other, such as:Table 1 ( April 2012)
Date NCR #
1 101
2 101
2 105
3 502
4 502
4 205And put the above data to calendar table to make the graph :
Table 2: Date
1 2 3 4 5 6 7 .. 30
101 1 1
105 1
205 1
502 1 1Please help.
Thanks in advance.
Dear sir,
It is very useful for sorting, but i tested my case if the cell is number in text format. eg. '123456.
Seem the formula doesn't works, could you teach me ?
Many tks.
My solution is much simpler.
1. My unsorted numbers ( or words ) are listed horizontally. e.g. B29 – G29 ( 6 numbers ). I choose 29 so that it wont be confused with the 1 used in RANK function 😀
2. My sorted numbers shall be in cells J29-O29,
3. The formula for cell J29 is
3. The formula for cell K29 is … just convert all the "=1″ into "=2″
4. The formula for the rest is "=3″ for L29 and so on till "=6″ for O29.
5. The RANK function will rank every cell in the range. There will not be any unranked. The last part .. ,IF(RANK($G29,$B29:$G29,1)=1,$G29,$Q29)
If there are more than one same number .. meaning there are more than one number of the same rank.. it would duplicated the first number of the same rank.Hope this would help u guys.
Genius. Originally I accomplished the same thing with big, ugly use of INDIRECT, but the source worbook was to be used in within Xcelsius, which doesn't support INDIRECT. Not only does this solution work in Xcelsius, it hogs a heck of a lot fewer resources than my original idea. Five points for you, sir.
Final formula added a check for blanks, assigning them 999 to force them off the final list of around 100; and then a reset to subtract the number of blanks from the final list. Works beautimous.
Thanks for the help. May a giant cookie soon come into your life.
I have doen slight modification to the formula above to auto-get the position of sorted numbers.
1. Consider my unsorted numbers in cell A1 – F1
2. My sorted numbers shall be in A2-F2
3. For cell A2 the formula is =IF(RANK($A1,$A1:$F1,1)=COLUMN(A1),A1,IF(RANK($B1,$A1:$F1,1)=COLUMN(A1),$B1,IF(RANK($C1,$A1:$F1,1)=COLUMN(A1),C1,IF(RANK($D1,$A1:$F1,1)=COLUMN(A1),$D1,IF(RANK($E1,$A1:$F1,1)=COLUMN(A1),$E1,IF(RANK($F1,$A1:$F1,1)=COLUMN(A1),$F1))))))
there is no need to check for duplicates for the first cell
4. For cell B2 the formula is slightly different at the end..
there is an additional "=COLUMN(B1),$F1,A1))))))"
If there are numbers of same rank, the prior number shall be duplicated .
Hope this is better . thanks-
Arrggh.. the FULL formula for A2.
And the full formula for cell B2 ..
Just change this "COLUMN(B1)" to "COLUMN(C1)" for the third cell and so on-
Correction for cell B2 should be ..
the last part , in event of a duplicate number should duplicate the prior number ..
Additional correction
make sure you change the last part too..
for Cell B2 .. IF(RANK($F1,$A1:$F1,1)=COLUMN(B1),$F1,A2))))))
for Cell C2 .. IF(RANK($F1,$A1:$F1,1)=COLUMN(B1),$F1,B2))))))
for Cell D2 .. IF(RANK($F1,$A1:$F1,1)=COLUMN(B1),$F1,C2))))))
and so on..
I cannot find the words to thank you.
This solution is so obvious… I cannot believe how many years using a much more complex solution (VBA).
Thanks! -
This is the inspiration I needed for what I was trying to do. Thank you.
Last but not the least, Sarah Palin and Paris Hilton is just not right in this group or we can create a new group with Kardashians in there as well. Opinion?? -
This opens possiblities! Many thanks for this wonderful solution and your website in general!
The array formula I was using was very slow & using lot of resorces (My data has around 1000 rows). This is lot faster. Thanks Chandoo.
i want that if i will put the figure ( amount ) in a row so automatically text of that amount should come on another row of column,
like :- 3555/- so in text three thousand five hundred fifty five only.
help me to make a formula.
thank you -
I have a sheet containing formula for automatically sorting text data (e.g. names), you can download it from:
http://www.nanakasep.blogspot.com/2014/01/rumus-excel-untuk-menyusun-nama-secara.html -
I just found this blog; interesting use of vlookup and countif but this doesn't work if you have a fluctuating table of names. I have a column that can hold up to 20 names and your example came back with #N/A because I was using the entire table which had several blank cells. If I reduced my table to just include those cells with values other than "" then the formulas work. But since I use a link to another spreadsheet to load my table it may have 5 names one day, 13 another day, and maybe eve 20 another day.
Is there a work around for this or do I need to search for another solution? The standard sort function also fails to sort correctly because of the empty cells.
FYI: my table uses a Name and I use that Name in your formulas.Thanks for your time,
El Bee
You can get rid of the #N/A by embedding the simple VLOOKUP in an IF statement with the ISNA function, which enables you to substitute a zero-length string; for example
And for variable numbers of names, if you know what the maximum is ever likely to be you can set the lookup range ($B$3:$C$10 in the above example) for that maximum number of rows, and insert the COUNTIF and (modified) VLOOKUP formulas for all these rows. The COUNTIF will return 0 for missing data, and the modified VLOOKUP will sort the data correctly.
i downloaded the workbook given above for sorting example.
That fails if you have two similar names.
If there are two names say "Chandoo" then only one comes and one "#N/A" comes.
Can someone help with the correction pls -
This has helped me such a lot. I've used it extensively.
However, I can't get the formulas shown here to ignore the duplicates in the text list. Using the 'remove duplicates from a list methodology that Chandoo's shown doesn't quite fit with what I wanted to do. Sorry, Chandoo.
When I tried to use the formula shown earlier in this post to ignore the duplicates: if(countif(C6:$C$15,"<="&C6)=1,Sum(countif($c$6:$C$15,"<="&C6),-countif(c6:$C$15,"<="&C6),""), I got a FALSE. (I think there's an erroneous comma in there somewhere but I don't think that's the reason for the FALSE).
My solution was to double-sort. Sort once to get the sorted list. This will also return some blank lines as the formula only returns, e.g., one '10'. Any other '10' gets a blank line. Then it's easy to sort again as the formula can be amended to insert a zero when there's a blank line.
But, a slight problem. If the list to be sorted contains formulas, inserting data copied from another data source, and those formulas are constructed to return a "" value if there's a blank line in the data source, Chandoo's solution counts the cells containing formulas as part of the sorted list so the numbers assigned to the list to be sorted are incorrect.
I've tried various methods to counter this from testing the cell in the list to be sorted to see if it contains a value greater than "A" to testing for not being equal to a value of "?*" with mixed success.
Any thoughts welcome.-
Use my solution using "RANK". I have listed it here in the comments
It is much slimmer and faster than Chandoo's
Thanks for this response, Ariel.
Apologies if I'm confused here but what spreadsheet are you using as the basis for your formulas ?
Chandoo's example spreadsheet at the top of this thread only contains columns A and B.
Your formula references a range containing column F. Should this be changed to column B ?
Apologies again.-
hi John Holt,
here's my horizontal sort using RANK
it's simpler, uses very much less resources and works for duplicates, triplicates etc !!perhaps you could convert it to vertical ..
Sorry, Ariel, I was confused. Having read all of your post, I realise that you're referring to a completely different example.
Having understood that, I'd be grateful if you could post how your formulas could be modified for a vertical, rather than horizontal, list.-
Give me some time to convert it to vertical..
OK i finally got it.
This is faster , slimmer and more resource-efficient than Chandoo's solution.
Horizontal Sort:
https://dl.dropboxusercontent.com/u/25664103/H-Sort.xlsVertical Sort:
Can someone help me, I have a list of address that include numbers in one cell for eg.
110 Great South road = 1 Cell
I want to know how to sort these cells in alphabetic order using the street name no the numbers??
Thank you in advance.
Try this Text Vertical sort using RANK function.
It compares first 3 letters – you could add more if needed.
Hi Chandoo,
i opened worksheet for countif , any wondering why 10 is for 'steve jobs' while 9 is for Steve Balmar, i thought steve Balma is smaller than Steve Jobs… -
Sorting with formulas.. That was really nice tutorial. I have never used this trick, now applying sorting in excel with countif. thanks for tutorial.
Leave a Reply
Reader Poll: Should the axis for bar charts always start at zero? | Sports Statistics Dashboard in Excel – Few More Alternatives |