Free Essay

Tea in My Cup

In: English and Literature

Submitted By joepass
Words 785
Pages 4
Accounting Format – Cells above each other hundreds/tens/ones place
Custom Value: positive value; negative values; zero; text [green]?”$”;[red](?);”ZERO!”;”Why text?” - Use @ for numbers typed AKA repeat back

Ctrl + : to get current time
Ctrl + ; to get current date
Custom format d = 7 or 17 dd = 07 or 17 ddd = sex dddd = sex-feira

File > Options > Advanced > Edit Custom Lists > Import To program an autofill list feature where other names are filled in after

Fill > series > weekdays > step: 5 Gets you Jan 1, Jan 6, Jan 11

Format number for dates gives you # of days since 1-1-1900

Conditional Formatting

Conditional Formatting > Top/Bottom > Bottom 10% Green light to 20% best; Red 20% least; Yellow to middle Conditional Formatting > Icon Sets > Lights Conditional Formatting > Manage rules Green > 80 percent Yellow < 80 percent but > 20 percent Red =OR(Month($A3)=11;Month($A3)=12) - Where A3 is the title cell like “Birth Date”

Make all lines with Dog the color blue Conditional Formatting > New Rule > Formula to determine which cells to format =$B4 = “Dog” Formal > Fill > Blue

Color in red dogs born on Wednesday =And($B4 = “Dog”; weekday($F4)=3)

Color in red dogs born on Wednesday or Thursday =And($B4 = “Dog”;Or(weekday($F4)=3; Weekday($F4) = 4))

= Iseven(Row(1))

Themes

Cell style > Right – click > Modify

Ribbons + Developer Record Macro + use relative reference (do something) stop recording

Developer > Insert Combo Box > Right click > Format Input Range Cell link

Editing and Proofing

File > Options > Language > Add additional language
Change screen tips to help with foreigners

Symbols Insert > Symbols > Subsets Date in cell > Home > Date > More format options Date > Home > Date > More form > Custom > [$-40>]dddd

Consolidate

Data > Consolidate > Use labels in top, left > Add Select reference you want to use

NPV Click Fx > Search NPV Rate = 5% Value = E46:E81 (First Column) Drag to the right

IRR Click Fx > Search IRR Enter > Result > Change format to % > Drag to the right

Project w/ IRR over 10% summing NPV Click Fx > Search Sumif Range: E84:AA84 (IRR row) Criteria: “>10%” Sum Range: E83:AA83 (NPV row) > OK

Add Solver Add-In File > Options > Add-ins > Manage Excel Add-in > Go > Solver Add-in

Issue Bonds to raise debt (2015) Bond Issue date: 1st Jan 2015 Maturity: 31st Dec 2015 Coupon: 5% Redemption Value: 300

Solver (Yield) Set objective: Raised cash Value of: 15750 (cash needed to invest) By changing variable cells: Yield % cell Solve

Ctrl + adds a column in between rows =Concatenate (Last name, “ “, A6) Gets last name + first name together

Rule hires manager average score > 10, aspect 10 > 15 =If(And(Average(First row) > 10; Cell w/ value) > 10 > 15) If true; Hire | If not, Don’t Hire
Vlookup
LV – Value table (in table, ID # for grade) Table array – All table (other table w/ numbers) Col Index + 1 is Which column you find it in Range lookup is 0 if exact match, 1 check closest value

*Do for FIRST value of table then pull formula down*

NetworkdaysINTL How many days between ____ and ____ NetworkdaysINTL(A4;A5;4) 4 if Tues, wed, holidays

SLN To compute depreciation of car Initial: $125,000 Life: 4 years Salvage: 50,000 =SLN(125,000,50000,4)

Merge cell styles Between two templates Cell styles > Merge cell styles

Catch data from Access files/Web Data > Get external Data > Import If anything changes in original, click refresh Also do = (click cell in other excel)

Unlock cells/Lock cells Review > (select range of cells) > Protection Formal cells > protection > Locked/Hidden Allow users to edit range: Refers to cells (select) + ______ Track changes
File > Inspect workbook > Check for issues > Inspect Document Unprotect and unshared work before inspecting errors

Merging workbooks File > Options > Quick access toolbar > Compare and merge > add Click green button top left

Charts Insert > Chart Design > Select Data Right click bar, add trend line Right click > format data series (secondary) Right click > save as template Design > move chart

Sorting Home > Sort and filter > Custom sort Division Values A-Z Team Values Small-Large Insert pivot table > Choose fiels right Put unit price in value box (average price) Pivot tool options > Insert slicer

Creating relationships Select all > Powerpoint > Create link table Table > Relationships > Create relationships

Similar Documents

Free Essay

The Art of Drinking Tea by Nin Andrews

...The Art of Drinking Tea By Nin Andrews When I first read this poem, I just thought it was about a lonely man’s desire to sleep with the black-haired woman who is drinking tea. He pictures her undress him and enjoying the one night stand that lasts 49 days and nights. Although the wordings of the poem sounded complicated, I believed that the poem just had a fun and simple read and that was my main reason why I selected this poem. However, when I started to think about why Andrews used drinking tea to describe a man’s sexual desires, the depth of the poem changed entirely. In the middle of the poem, the man tries to follow the instructions on the drinking of tea but fails to because he constantly imagines making love with a woman. This was my favorite part of the poem. Although he says that he failed to follow the instructions, I think he was doing it perfectly. When you take your first sip from the first cup of tea, the liquid moistens your lips and surrounds your mouth with warmth and comfort, just like a kiss that the man was picturing. “She lifts him to her lips like a china cup and sips so slowly.” So he knows what the art of drinking tea is but decides to become to teacup so that the lady can kiss him. Nin Andrews also used tea to show a sense of addiction. In tea, there is a bit of caffeine, which allows the drinkers to crave more of it. In the poem, the man seems to be addicted to his imagination that he barely remembers his own name. Although there weren’t......

Words: 587 - Pages: 3

Premium Essay

Food Labels Week One Assignment

...Glenn Johnson My current eating habits are pretty simple. I have to always eat breakfast; I either eat a normal bowl size of raisin brain with about a cup of skim milk or stop by Burger King for two breakfast burritos with either tea or coffee. For lunch sometimes I either just snack around the office with popcorn or pretzels or whatever else my craving is for that day. However it’s usually something light, rather having something really heavy. Then for dinner I usually cook every night of the week which consists of one meat, vegetable, and a starch. When fixing my plate I usually get ½ a cup of each individual food. However even though I do place a little more than what I am supposed to eat on my plate, there are a lot of times where I don’t finish eating. I also have found myself not trying to eat any more food after I begin to feel full. When it came to the Super Tracker on what your body needs and then what they show what I had reordered, mine has been under on just about every single food group and nutrients. The refined grains are the only thing that was actually over that I had ate in those three days of my recording. As far as how many servings in each food group I ate in was also under as well. Grains in the three days I intake 6 ½ ounces, vegetables 2 ¼ cups, fruits I intake ½ cups, dairy was 1 ¼ cups, protein foods was 5 ounces, and oils I intake was 2 teaspoons. This assignment has showed me that a lot of my problems......

Words: 1330 - Pages: 6

Free Essay

Nutrition

... Day 2 Breakfast: 2 eggs, 2 sausages, and tea with 2 teaspoons of sugar. Snack: 1 apple and 1 water bottle. Lunch: Fried shrimp, salad, and bottle of water. Dinner: French fries, burger, and pickles. 2 glasses of apple juice. Breakfast: Special K cereal with low fat blueberry yogurt, and tea with 2 spoons of sugar. Lunch: Turkey with tomatoes on 2 slices of whole wheat bread and 1 cup of peach bubble tea. Snack: Plum, apple, grapes and 1 glass of water. Dinner: Brown rice with chicken, mushrooms, 2 pieces of white bread, and 2 glasses of water. I would pick day two to analyze for nutritional content. Step 2: On day 2 for breakfast I ate 1 cup Special K cereal with 1 cup of low fat blueberry yogurt. My liquid intake for breakfast was 1 large cup of gray tea with 2 teaspoons of sugar. For lunch I had a cream cheese with tomatoes on a whole wheat bagel with 1 large cup of peach bubble tea. As a snack I had a plum, apple, grapes and 1 glass of water. For dinner, I had 1 cup of brown rice with 2 chicken breasts and 2 glasses of water. I choose a 2000 calorie level of food plan. According to the chart, for grains the daily recommendation is 6 ounces and the minimum is 3 ounces of grains a day. For breakfast I had 1 cup of cereal which is equivalent to 1 ounce of grains. I had 1 cup of of low fat blueberry yogurt which is equivalent to 8 fluid ounce carton, and the daily recommendation is to have 3 cups of dairy. For launch I had 2 slices of whole......

Words: 626 - Pages: 3

Free Essay

Hypothesis

... Hypothesis – the larger the surface area the faster the rate of reaction Why did you choose your hypothesis? The reason I have chosen my hypothesis is because large surface area of the tea bag will contain more molecules which means the rate of reaction will happen faster. For example the pyramid due to it 3D shape provides more sides for diffusion to take place and more area in the middle for the tea molecules to move around which will make them escape quicker so the reaction will happen faster. 2 web sites I have done my research, a) http://www.mylearning.org/learning/investigate/Tea%20Bag%20Trials.pdf b) http://www.science-sparks.com/2012/01/02/get-the-kids-to-make-your-cuppa-investigating-teabags/ I prefer website science-sparks because I found it easier to follow and also it was more useful was because it’s a scientific website therefore it was more accurate than mylearing. It also appeared to make more sense to me. Therefore website science-sparks was more detailed and had a diagram whereas website mylearning didn’t have one so it was hard to understand how to do the experiment and how to set it all up. Equipment: Circle, square and pyramid tea bags 4 pieces of white paper A black pen or a marker Kettle with hot water (70°c) A stopwatch/timer 3 Clear glass cups Thermometer Method: On the piece of 4 white paper that are going to be used as part of the experiment draw a table on one of them......

Words: 534 - Pages: 3

Free Essay

Ais Paper

...Start My Own Business What new business would you start and why? What are the steps you would take? What type of accounting system would you use and why is it important? What are the pros and cons of owning your own business? Americans enjoy various entertainment places, such as beer bars, music bars, sports bars, gay bars, lesbian bars, etc. Coming from another country, I had hard time finding a quiet place where I didn’t have to raise my voice to conduct informal communications with my friends or with somebody important while enjoying a cup of fresh green leaf tea. I believe there are tea bars in New York or California where Asian people reside, and I heard that there is one in Miami, but there is nothing in Ft Lauderdale, where I live. Luckily, we have Starbuck Cafe, which is close to the environment I am looking for; however, it is still a fast food industry, where people come to grab a cup of coffee and go. Others, like me, try hard to find a quiet corner in all the noise. I miss the times that I spent with my friends in the tea bars in my country. So, I dream of having a tea bar here, where it provides a peaceful place for people to enjoy a calm chat while having a cup of quality tea, and a little relaxing time for themselves. Americans could realize the potential of slowing down and smelling the roses. The economic slowdown might be that opportunity for people to slow down and enjoy a cup of hot tea that they have to drink carefully and slowly fully......

Words: 1265 - Pages: 6

Free Essay

Lab Investigation 3

...Heterotrophy | Image 1 | Amoeba | Eukaryote | Stagnant water | Heterotrophy | Image 12 | Plant cells with nucleus (chloroplasts absent) | Eukaryote | Plants | Autotrophy | List two similarities between plant cells and animal cells 1. Both plant and animal cells have a nucleus. 2. Both plant and animal cells have ribosomes, mitochondria, and a Golgi apparatus. List two differences between plant and animal cells 1. Animal cells do not have a cell wall or chloroplasts, but plant cells do. 2. Plant cells have one large central vacuole while animal cells have one or more small vacuoles. Part 2 – Diffusion and Osmosis Diffusion [4 pts] Boiling water (Right Side) | Cold water (Left Side) | * Absorbed tea bag rapidly | * Slowing...

Words: 1322 - Pages: 6

Premium Essay

Marketing Plan: a Perfect Cup of Coffee

...Marketing Plan: A Perfect Cup of Coffee Abstract The purpose of this paper is to show a complete marketing plan developed for A Perfect Cup of Coffee (PCC). The idea for A Perfect Cup of Coffee grew one winter morning in 2011 when my wife and I were discussing our dissatisfaction with the delivery times and prices for our online coffee services for our one cup coffee makers. We enjoyed the taste of the Tassimo coffee pods, but were dissatisfied with the delivery times, customer service and prices. We thought the customer service components of Keurig Company were top notch, but Keurig lacked the quality in their coffee pods as well as efficiency in their coffee systems. As owners of one cup coffee makers for both companies for more than a year, we thought we could create a company that could have tremendous online customer service as well as have the depth and quality of coffee to surpass the industry leaders. 1.0 State your marketing objectives. • Increase brand awareness among our target audience by 30 percent this year through an advertising campaign in magazines and online. • Increase new customers from month to month. • Maintain a high standard of coffee and customer service. • After six months, continue to increase new customers and sales while maintaining or decreasing marketing expenses. • Maintain a positive and steady growth each quarter. • Increase our market share by 10% this year. • Enter into the overseas market, Finland specifically, 12 months...

Words: 1195 - Pages: 5

Premium Essay

Green Mountain Coffee Roasters

...business practices, and innovative brewing technologies. Green Mountain Coffee Roasters was founded in 1981 by Bob Stiller in Waitsfield, Vermont. In 1993 GMCR goes public and stock opens at $10. In 2006 GMCR acquires Keurig Incorporated, a single cup brewing system for coffees, teas, hot chocolate and apple cider. Green Mountain Coffee Roasters has teamed up with some of the strongest beverage companies and have acquired and merged with several specialty brands such as, Starbucks and Dunkin Donuts. They have also have Keurig licensing the patents for creating the single-serving unit called a “K-cup.” In 2007 Larry Blanford took the position of CEO and President of GMCR while Bob Still remains as Chairman of the Board. 2012 Brain Kelley joined GMCR and was named President and CEO and still holds that position today (www.gmcr.com). Michelle Stacey is currently the president of Keurig Inc. As of December 28, 2013 GMCR net sales were $1,386,670 and their gross profit was $464,047(http://finance.yahoo.com). SWOT ANALYSIS Strengths: * Strong brand name. * Unique and large variety of products in the coffee market. * Environmentally conscience. * Innovative products. Weaknesses: * Lacks an online presence. * K-cups made by one manufacture. * Single product line. Opportunities * Expanding to new markets, new products, and services. * Expand online market. * Expand suppliers. Threats * Expiring patents. * Instability in coffee......

Words: 1118 - Pages: 5

Premium Essay

Gladwell

...Caffeine. There is a lot of evidence that supports his ideas but on the other hand he may drift off in his own world detailing not proving anything. Malcolm Gladwell compares the amount of coffee to tea and goes into a rampage on categorizes what type of people drinks coffee or tea with unreal or unimportant facts. Malcolm Gladwell uses concocted facts around his subject which mind boggles me throughout the whole essay. Because Malcolm Gladwell says, “That the American Revolution began with the symbolic rejection of tea in Boston Harbor, in other words, makes perfect sense”. (p.249). I would never think the American Revolution started because of the simple drug call caffeine which is also in tea. I find this to be very compelling because people didn’t like tea for the Boston tea party incident. He then says “Real revolutionaries would naturally prefer coffee” (p.249). When I read this; I laughed so hard that I cried. Actually, why would a revolutionary war be the cause of coffee or tea? Once again, Malcolm portrays that jumbling of words and compelling argument do work hand to hand to keep us entertained. Since Malcolm takes us around block with his antics. He goes so far into detail that he says, “A cup of coffee has somewhere between a hundred and two hundred and fifty milligrams; black tea brewed for four minutes has between forty and a hundred milligrams”(Gladwell 249) . I got...

Words: 805 - Pages: 4

Premium Essay

Plants Chapter 15 Notes

...Plants and People Notes Chapter 15 Feeding a Hungry World The major challenge in agriculture today is producing enough food to feed the world’s population. Approximately 15% of the world’s population receives insufficient food to meet daily nutritional requirements. The major challenge in agriculture is producing enough food to feed the world’s population. Dramatic improvements in crop yield have been achieved through breeding of high-yielding and disease resistant varieties. Traditional breeding programs and biotechnology are being used to develop high-yielding and disease-resistant cultivators. Germplasm, the genetic information encoded in plants, is a valuable asset to plant breeders and must be preserved. The loss of genetic diversity in crop plants and their wild ancestors because of monocultural practices is a serious concern to plant breeders. The cultivation of just one or two high yielding varieties for most major crops has resulted in the loss of thousands of traditional varieties, and with them their genetic heritage. Monoculture is, in itself an unstable system in that a single pest or disease can wipe out the crop of an entire region of essentially genetically identical and similarly susceptible individuals. Although there are over 50,000 species of edible plants, only three domesticated crops provide over 50% of the kilocalories from plants in the human diet. The search for locally used crops that have the potential to be developed for expansion...

Words: 626 - Pages: 3

Free Essay

Three Cups of Tea

...Three Cups of Tea "Educate a boy, and you educate and individual. Educate a girl, and you educate a community.” Three Cups of Tea is a very powerful and inspiring book. I enjoyed it thoroughly and I would recommend it to any of my peers. I enjoyed reading about Mortenson’s accomplishments when it comes to the Balti People. I love that Relin portrayed Mortenson with all his flaws. He is a human and makes mistakes but it was the way he overcame his mistakes and challenges that impressed me. Relin’s writing in Three Cups of Tea is beautiful, elegant and sophisticated. This book had such an influence on the way I view the world and all the people in it especially those in impoverished countries. I particularly enjoyed how the Balti people influenced Mortenson’s life in such extreme ways. The two prompts that I decided to write on are “Have you ever known anyone like Mortenson” and “Discuss his repeated brushes with failure and how they influence your opinion of Mortensen”. Let me begin by saying Mortenson is an amazing individual. He did something that not many people have the gusto to go through with. He truly loved the Balti people and wanted the make their lives better through education. When I first read this prompt I immediately thought of one of my youth leaders, Cherissa Newton. She hasn’t accomplished anything as substantial as building a school for people in some foreign land. But, she is a social worker who works with underprivileged children each and every day....

Words: 688 - Pages: 3

Free Essay

Awesomeness

...from what you said, it sounds to me like you could probably easily make the jump to all-grain brewing on the stovetop. here's how it might go for a 3-gallon batch: in your brewpot, heat 9 quarts of water. when the water hits 170 deg(1), dump in the grain. stir gently to break up any dry lumps and make sure all grain gets wet. stir up the grains every ten minutes, stopping after the fourth time. this will give the grainbed the last 20 minutes of the mash to settle. after one hour has elapsed, use a siphon (preferred) or careful ladling (also works) to transfer the clear liquid on top to a separate container. whatever big containers you have will do for this temporary step, since the wort is ultimately going to go back into your brewpot once the grains have been eliminated. also, since you're going to boil the heck out of the wort, you don't have to worry too much about sanitation of these other containers. the same goes for stirring spoons, other utensils, etc. the rule of thumb is that before the boil, anything the wort touches just has to be clean. after the boil it has to be clean AND sanitized. if you can tell that you're getting this portion of the wort out without any grains in it, carry on. if you're getting grains, you should run it through a cheese cloth on the way to your boil pot. (probably a good practice anyway) when you've removed all the liquid that can be gotten to conveniently, you'll be left with......

Words: 1400 - Pages: 6

Premium Essay

Lovelovelove

...mandarin and his daughter, Mi Nuong. Like other young ladies of her position, Mi Nuong was kept indoors, away from the eyes of admiring men. She spent most of her time in her room at the top of a tower. There she would sit on a bench by a moon-shaped window, reading or embroidering, chatting with her maid, and gazing out often at the garden and the river. One day as she sat there, a song floated to her from the distance, in a voice deep and sweet. She looked out and saw a fishing boat coming up the river. “Do you hear it?” she asked her maid. “How beautifully he sings!” She listened again as the voice drew nearer. My love is like a blossom in the breeze. My love is like a moonbeam on the waves. “He must be young and very handsome,” said Mi Nuong. She felt a sudden thrill. “Perhaps he knows I am here and sings it just for me!” The maid’s eyes lit up. “My lady, perhaps he’s a mandarin’s son in disguise—the man you are destined to marry!” Mi Nuong felt a flush on her face and a stirring in her heart. She tried to make out the man’s features, but he was too far off to see clearly. The boat and the song glided slowly up the river and away. “Yes,” she said softly. “Perhaps he is.” All day long, Mi Nuong waited by the window, hoping to hear the singer again. The next day she waited too, and the next. But the voice did not return. “Why doesn’t he come?” she asked her maid sadly. As the days passed, Mi Nuong grew pale and weak. At last she went to her bed and stayed there...

Words: 1476 - Pages: 6

Premium Essay

The Process of Quitting Smoking

...start smoking. To be honest, I hate smoking. Every time I smell someone is smoking, I always frown and leave the smoking area as soon as possible. But by my side, there are many friends, classmates and family members are smokers. But why do they enjoy smoking? “Nicotine is the drug in tobacco that causes addiction. It is absorbed and enters the bloodstream, through the lungs when smoke is inhaled… Nicotine is a psychoactive drug with stimulant effects on the electrical activity of the brain. It also has calming effects, especially at times of stress, as well as effects on hormonal and other systems throughout the body… Smoking doses of nicotine causes activation of "pleasure centers" in the brain, which may explain the pleasure, and addictiveness of smoking” (“Smoking: how to stop”). This paragraph explains the reason for smoking addiction. It seems that abstain from cigarette is really a hard task. My grandfather, however, had an experience about giving up smoking successfully. My grandfather’s smoking age was 40 years when he retired at 60 years old. It was an afternoon in the summer ten years ago in my grandfather’s living room. The weather was very clear and a little bit hot. I found my grandfather sat on the fauteuil by the window enjoying the sunshine. A cup of Chinese green tea was on his hand. I could even smell the tea...

Words: 1564 - Pages: 7

Premium Essay

3 Days Diet Analyst

...Sidibeh BI 213 Three Day Diet Analysis According to the food pyramid, my diet is horrible considering what I have consumed in these 3 days. It shows that I need to start eating more, and better quality foods. My sugar intake is too high and should be reconsidered. Possibly I could swap out processed sugars for natural sugars; such as in fruit. It is obvious from the records I have provided that I do not take in as much (if any) fruit that one should be consuming on a daily basis. Thus, not only am I depriving myself of vitamins, I am also depriving myself of the fiber needed in order for my digestive system and metabolism to work as necessary. I will have to incorporate more whole grains with fruit and vegetables to act as roughage, as going to the bathroom proves difficult for me- most likely this is why. I was astonished by how many carbohydrates I take in too. Eating a lot of carbs can add to the blockage/ movement in the bowels so I need to consider decreasing the TYPE of carbohydrates that I eat, cutting out white and processed breads and grains, replacing them for whole grains and wheat products. The only milk I intake is with my coffee and tea. Although I have four hot beverages a day with around 2 tablespoons of dairy, I am aware that this is no-where near the recommended 2 cups a day. On a good note however, I do not drink many sugary drinks at all- if any. Coffee, tea and water are my staple liquids therefore the sugar that I eat equals out to the......

Words: 759 - Pages: 4