All categories - 7 November 2007

I have been asked to create a spreadsheet template for my supervisor. Basically, what he wants to be able to do is take a bunch of totals and rank them (first, second, third, etc.) In other words, if the following data appears in a row:

Joe Jane David Mike Sara Diane
100 97 63 27 75 84

...and he has a ranking chart as follows:

1.
2.
3.
etc.

... he wants the column next to each number to auto-populate with the person who ranks #1, #2, etc.

If it helps, what he is doing is taking 9 billers and entering their daily totals, summing the weekly totals at the bottom, and finding who is #1, #2, etc., for total claims billed in a week.

I have discovered the RANK function, but have discovered its limitation: I can't do what he wants to do if two people have the same total. In other words, if both Sara and Diane bill 75 claims, it won't return a person in fourth place or denote a tie for third.

Any suggestions?

2007-11-07 06:49:50 · 2 answers · asked by JohnD 6 in Software

A. short story
B. novel
C. essay
D. poem

2007-11-07 06:49:46 · 3 answers · asked by depressed chic 1 in Homework Help

i am musclular and 5'3 and i kinda like having strong thick legs and thighs but i want less jiggle

2007-11-07 06:49:46 · 4 answers · asked by starletbaby04 2 in Diet & Fitness

33% is too much for the little bit of work that they do.

2007-11-07 06:49:37 · 8 answers · asked by dragonmaster 1 in Law & Ethics

Three brothers purchased a hotel room for the night. It was listed at $30, so each brother paid $10.

The manager then told the concierge that their room was discounted to $25, and that the brothers should receive a refund of $5.

The concierge realized that he could not return $5 evenly to three people, so he kept $2 and returned $1 to each brother.

After the refund, each brother has paid $9 and the concierge kept $2, which adds up to only $29 (3 x 9 = 27+2 = 29).

What happened to the other dollar?!

2007-11-07 06:49:35 · 7 answers · asked by JWrightus 2 in Jokes & Riddles

I have a soar throat but at night time it gets worst, my throat tonsels feel big and hurts to swallow and breath. In the day time is sort of calms down. It is just the night time that really hurts. So what can help sooth or make my throat feel better? In the middle of the night I woke up and could not swallow.
Help

2007-11-07 06:49:30 · 6 answers · asked by Anonymous in Pain & Pain Management

World history has proven the earth has warmed and cooled many times, and still people think they can control it.

2007-11-07 06:49:27 · 13 answers · asked by mission_viejo_california 2 in Politics

2007-11-07 06:49:19 · 21 answers · asked by Anonymous in Polls & Surveys

"ARE U HIGH!!!!!

WHEN YOU BOUGHT YOUR DRUGS DID YOU CHECK THE EXPIRATION DATE!!!!!!"


I mean, really... how disrespectful!













Of course I check the expiration dates, GEEZ!!! Who do ya take me for, Keith Richards?!?! COME ON!!!

2007-11-07 06:49:17 · 14 answers · asked by Brandon's been a dirty Hore 5 in Polls & Surveys

At my workplace, a tanning salon, there are a TON of flies in the morning when i open the store up, HUNDREDS of flies. How do i go about exterminating all of them??

2007-11-07 06:49:10 · 7 answers · asked by clarabhs07 1 in Zoology

Test results over the past 11/2 years cannot pinpoint the exact cause of my condition therefore my condition cannot be treated with any amount of accuracy. The pain at times is unbearable--I cannot walk up stairs--I can come down stairs. Prior to my condition a stroll of six miles round trip on the beach was an everyday affair--now one mile round trip is an effort taking me 45 minutes compared to my 17minute/mile walk prior to my condition. Any suggestions because I got off the doctor merry go round.

2007-11-07 06:49:04 · 4 answers · asked by Anonymous in Pain & Pain Management

i wouldnt want to lose my ball or any of their fences. look at the projected GOP ticket for 08, come on now

2007-11-07 06:49:01 · 16 answers · asked by Anonymous in Politics

2007-11-07 06:48:39 · 9 answers · asked by Anonymous in Insurance & Registration

2007-11-07 06:48:29 · 8 answers · asked by Anonymous in Other - Food & Drink

I am try to find the cartesian product of 5 small sets, if one of these sets is the empty set, does this make the cartesian product the empty set too?

2007-11-07 06:48:12 · 1 answers · asked by Anonymous in Mathematics

2007-11-07 06:47:58 · 12 answers · asked by Bought*With*A*Price 2 in Polls & Surveys

im going to japan tokyo next summer. and i live in canada. I couldnt be happier now because the canadian loonie is at an all time high, which means my program that im taking there will be cheaper.

when I go there I plan on buying food etc with my credit card. but should I exchange some money to YEN before i get there?

should I exchange some canadian NOW to yen? since its worth alot more?
is that even possible? I'm scared that if i wait the loonie will go down again :S lol

2007-11-07 06:47:50 · 3 answers · asked by Anonymous in Japan

Beckett
Shills
Dice K
Wake
Lester
Bucholtz

2007-11-07 06:47:46 · 12 answers · asked by Red Sawx ® 6 in Baseball

I would like to try some new things this Thanksgiving and Christmas. Anyone have a Holiday favorite? Let's share them!

2007-11-07 06:47:42 · 9 answers · asked by CAT 6 in Cooking & Recipes

My father was not really a part of my life growing up. My parents divorced when I was 7 and prior to the divorce my dad would pretty much work, come home and then watch sports. He didn't take much interest in his kids. He was very violent and constantly yelling at my mom or his children, on more then one occasion he got physical with my mom or siblings. I kind of grew up being afraid of him. He really wasn't much of my life all through school, only showing up to some sporting events and in my view more interested in women then his kids.

Now that I am an adult I don't really talk to my dad, months go by, maybe even a year and we don't talk. Recently we spoke and he asked me why I didn't want to have a relationship with him and that he was sad he daughter didn't want to get to know him.

I want to forgive him, but I don't want to be hurt anymore and I don't want to be mistreated either...How do you go about putting a relationship like this back together or should you try?

2007-11-07 06:47:36 · 18 answers · asked by justme 1 in Religion & Spirituality

Supernatural Manifestation in Photograph Said to Change Drug-User's Life
[Joe] is convinced that the photo captured the demon associated with his drugs, and praying for deliverance, he now carries the picture with him as a reminder, and shares with others the reality of evil, especially as it relates to drug addictions.

Teresa Neumann (November 7, 2007)

(Aurora, Colorado)—Many people are probably familiar with what I call the "bubble" phenomenon. It occurs when pictures are developed and they reveal floating, iridescent spheres that were not visible to the naked eye at the time the photograph was taken.

That said, I must admit I initially had reservations about this particular article because of the subject matter, and the manner in which the news presented the story of drug-user Joe Martinez of Aurora, Colorado, in which a photograph of him reveals the presence of a "demon." I also, at first, questioned the fact that the news commentators used phrases such as "paranormal" to describe it (can we expect any differently from a secular report?), and ran the picture in question by paranormal research society "experts" to determine if it was authentic. They were, by the way, stumped.

Watching the news video, however, led me to deem this story worthy of viewing.

The photograph in question is, well, chilling...whether one is a Christian or not. It was snapped eight years ago at a 50th anniversary reception for Martinez' in-laws. At the time, briefly glancing at the photo, nothing appeared to be out of the ordinary, and it was filed away with other photographs in an album.

Martinez was apparently a heavy drug user, not only at the time the photo was taken, but up until recently, when he and another family member rediscovered the photograph while reminiscing. It was then, upon closer inspection, that a clearly wolf-like face was seen peering out from behind Martinez' left shoulder.

The remarkable thing about this story is that it has reportedly changed Joe's life. He is convinced that the photo captured the demon associated with his drugs, and praying for deliverance, he now carries the picture with him as a reminder, and shares with others the reality of evil, especially as it relates to drug addictions.

To see the news video of the photograph, click on the link provided.

2007-11-07 06:47:32 · 14 answers · asked by sisterzeal 5 in Religion & Spirituality

If your company owns a trademark, but someone else has registered a .com domain with that phrase, do you still have to purchase it from them?

2007-11-07 06:47:26 · 4 answers · asked by Adam J 2 in Law & Ethics

2007-11-07 06:47:23 · 4 answers · asked by krazycai 1 in Economics

...when greedy subprime lenders started to see the consequences of Bad Business Decisions, or giving free money to Big Business posting record profits, or bailing out corrupt businesses?

Please.

Please explain how this is "capitalism." I thought the definition of capitalism was "Build a better mousetrap than the other guy."

2007-11-07 06:47:21 · 7 answers · asked by Anonymous in Other - Politics & Government

the dollar continues its decline at a faster pace - china is now looking to diversify by buying other bonds /currency- inflation is on its way globally according to the world bank- oil prices are at record levels and are expected to continue - the subprime fallout is still seeing losses even with the fed lowering rates and with inflation coming they cant hold on for long -and the next fallout for americans could be credit cards -are all the things ron paul has been predicting happening right before our eyes and will it be too late to fix if he gets in office?

2007-11-07 06:47:15 · 11 answers · asked by rooster 5 in Elections

Is there a certain outfit that you feel compliments your's?

2007-11-07 06:47:13 · 14 answers · asked by Red Phantom 5 in Polls & Surveys

2007-11-07 06:46:58 · 9 answers · asked by Anonymous in Polls & Surveys

for an essay

2007-11-07 06:46:31 · 4 answers · asked by jessies_song 2 in Homework Help

I'd like to get my Sister's kids each a bike for Xmas from Santa but it needs to be a surprise. Her kids are 9, 7 and 5. If I take them anywhere to check them out, they'll know.

2007-11-07 06:46:22 · 16 answers · asked by steviesquaw 1 in Toys

they're suppose to be working, but they sneak off and mess around in the storage room. i don't think anyone else knows. do i keep it to myself or what? any advice will help, thanks.

2007-11-07 06:46:19 · 13 answers · asked by summer 4 in Singles & Dating