text:
Try Office 365 for free
Get a free trial and work anywhere, on any device, with premium versions of Word, Excel, PowerPoint, and Outlook, plus 1 TB of OneDrive storage.
After your 1-month free trial, Office 365 Home is $99.99 per year. Credit card required. Cancel anytime to stop future charges.1
What's included
The latest Office applications with exclusive features
Free Office trial across your devices
1 TB OneDrive cloud storage per person
Get Office 365
Get the Office you know, plus tools to help you work better together, so you can get more done—anytime, anywhere.
Frequently asked questions
The trial gives you access to all the features of Office 365 Home. It includes:
Always up-to-date versions of Word, Excel, PowerPoint, Outlook, Publisher, and Access as well as access to additional OneNote features (features vary).
Share with your entire family – for up to 6 people.
For use on multiple PCs, Macs, tablets, and phones.
1 TB of OneDrive cloud storage per person so you can save documents, photos and videos online and access them from nearly anywhere.
Ransomware detection and file recovery.
Securely sync and share.
Collaborate on documents with others online.
Tech support via chat or phone with Microsoft experts.
- Create or sign in with a Microsoft account. What is a Microsoft account?
- Provide payment information to enable future yearly payments. International credit cards and PayPal (in some markets) are accepted.
- The payment method you provide will be automatically charged at the end of your first free month to ensure that you do not experience any interruptions with your service. You can cancel online without penalty before your trial ends, by visiting www.office.com/myaccount and turning off recurring billing option in the payment and billing area.
- Once your payment method is confirmed, you'll be transferred to www.office.com/myaccount to install Office.
You are asked to provide credit card information to help ensure that you do not experience any interruptions with your service once your trial ends. Your credit card will not be billed until the end of the trial period. You can cancel any time during the trial period by clicking Turn off recurring billing in My Account.
Internet access is required to install and activate all the latest releases of Office suites and all Office 365 subscription plans. For Office 365 plans, Internet access is also needed to manage your subscription account, for example to install Office on other PCs or to change billing options. Internet access is also required to access documents stored on OneDrive, unless you install the OneDrive desktop app. You should also connect to the Internet regularly to keep your version of Office up to date and benefit from automatic upgrades. If you do not connect to the Internet at least every 31 days, your applications will go into reduced functionality mode, which means that you can view or print your documents, but cannot edit the documents or create new ones. To reactivate your Office applications, reconnect to the Internet. You do not need to be connected to the Internet to use the Office applications, such as Word, Excel, and PowerPoint, because the applications are fully installed on your computer.
Office 2019 is compatible with Windows 10 or macOS. See system requirements for compatible versions of Windows and macOS, and for other feature requirements.
Yes. Documents that you have created belong fully to you. You can choose to store them online on OneDrive or locally on your PC or Mac. Learn what happens if you cancel your subscription.
Your service will continue uninterrupted and your payment method will be automatically charged at the end of the trial, and then yearly thereafter. You do not need to re-install Office.
Not immediately. For example, if you had a trial of Office 365 Personal, you can't sign up for a trial of Office 365 Home. However, one year after your trial or paid subscription ends, you can sign up for a new trial.
If you signed up for the trial on this page, visit www.office.com/myaccount and turn off the recurring billing option in the payment and billing area. With this approach, the trial will automatically expire when your month is finished and your credit card will not be charged.
1. You are asked to provide credit card information to help ensure that you do not experience any interruptions with your service once your trial ends. Your credit card will not be billed until the end of the trial period. You can cancel any time during the trial period by clicking Turn off recurring billing in My Account.
iTunes, iPhone, and iPad are registered trademarks of Apple Inc., registered in the U.S. and other countries. Android is a trademark of Google Inc.


text:
Stone Dam Trail
ElevationAscent: 544' 166 m
Descent: -396' -121 m
High: 1,792' 546 m
Low: 1,435' 437 m
GradeAvg Grade: 3% (2°)
Max Grade: 13% (7°)
Driving directions Take a virtual tour
Current trail conditionsUpdate Conditions
Unknown See History
Navigate on-trail with our free app
Run this trail?
Trail Run Project can't be a complete community resource without keeping our trail information up to date. Help fellow runners know what's here.
Land Manager: NY DEC - Region 6
Check In

subset: commoncrawl


text:
Here's my synopsis of Chapter 12 of Twilight, by Stephenie [sic] Meyer.
Chapter 12. Balancing
Billy The Old Indian Dude and his son Jacob The Indian visit Bella and her father. Her father invites them in to watch a game on TV. Bella and Jacob The Indian talk in the kitchen while she makes grilled cheese sandwiches. Bella admits she's been going with Edward Cullen. Jacob The Indian says his father is a superstitious old man. Bella is worried that Billy The Old Indian Dude will tell her father that she's hanging around with a Beautiful Vampire. Jacob The Indian doesn't think so.
Bella has lots of homework, but she stays in the living room and pretends to watch the game and listen to Jacob The Indian talk to her, but all she cares about is whether Billy The Old Indian Dude will tell her father about Edward. He doesn't.
After the Indians leave, Bella's father talks to her. She's afraid Billy The Old Indian Dude said something when she wasn't looking, but he didn't; Bella's father just wants to have a conversation with her. He says he's going fishing on Saturday.
The next morning, Edward picks her up in The Silver Volvo again. Bella gets in the car and -- OK, I have to quote this next part verbatim, because otherwise no one will believe it's actually in
Edward asks her more questions in the car and at lunch. He's surprised that she never had a boyfriend before, and says more stuff about how awesome she is. He says he's skipping school after lunch to go hunting so he won't be as hungry when they go on their date tomorrow.
Bella realizes that most of the other Beautiful Vampire kids don't much like her. Rosalie The Mean One glares at her. Edward hisses at her to make her stop. He says the other Beautiful Vampires are worried that they'll all get in trouble if Edward kills Bella. Alice The Nice One comes over and meets Bella. Edward and Alice The Nice One leave to go hunting.
Bella wants to ditch also -- apparently there's no point in being at school if your boyfriend isn't there too -- but decides not to because it would be conspicuous and make Edward more likely to get in trouble if he kills her tomorrow. (Seriously. I'm not making that up.)
Bella thinks their date tomorrow will be pivotal, because that's when Edward will decide if they are going to stay together. It's up to him, because nothing is more terrifying and excruciating to Bella than the thought of turning away from him.
Bella has no idea what happened in biology class, because all she could think of was Edward and their date tomorrow. In gym, The Least Annoying Of The Many Annoying Boys Who Like Bella asks her if she's going to the big dance tomorrow and she lies and says she's doing homework and laundry. She hurts his feelings by blowing him off when he asks her, in that case, to come to the dance with their friends.
When Bella gets to the parking lot after school, Edward has delivered her truck. He's left a note that says, "Be safe" (because he won't be around to stalk her for her own good for a few hours).
After she gets home, Bella calls one of
After dinner, Bella's mind has too much free time and she starts to freak out. She fluctuates between anticipation so intense that it is very nearly pain, and an insidious fear that plucks at her resolve. Edward's note means he wants her to be safe, so she hopes he wants that more than he wants to drink her blood. It would be intolerable to cut him out of her life -- her life is "about" him. But she still kinda wonders if getting killed by a Beautiful Vampire hurts a lot.
Bella can't sleep, so she drugs herself with some cough medicine. It works, but when she wakes up in the morning (with no trace of a hangover or anything) she slips back into the same hectic frenzy from the night before. She gets dressed and eats breakfast and keeps looking out the window to see if Edward's there yet.
Edward shows up in clothes that match Bella's. They leave in Bella's truck. She drives, but he tells her where to go. They're going to go to the woods and hike five miles. Bella's sure she can't walk that far in the woods without injuring herself.
Edward gets mad at Bella when he finds out she didn't tell anyone who she'd be with. She says it's because she didn't want him to get in trouble if he kills her. Edward gets even madder but apparently doesn't conclude that she's insane, because they continue the date.
They get to the woods. Bella's afraid to get out of the car because Edward's mad at her, but then she gets out of the car. They take off their sweaters, and Edward's all white and muscley and godlike, which gives Bella a piercing stab of despair because he's too good for her. Edward is bewildered by her tortured expression and can't figure out why she's such a buzz kill all of a sudden.
They walk through the woods. Bella tries not to look at him, because every time she does, his beauty pierces her through with sadness. They don't talk much, except that Edward still keeps asking her questions. They walk all morning. The forest spreads out in a boundless labyrinth of ancient trees, but Edward knows where he's going.
Bella starts to get excited because she's finally going to see Edward in the sun. They come to a beautiful meadow filled with wildflowers, which confuses me because there was an ice storm like a couple of weeks ago. The meadow is so pretty that Bella forgets for a few seconds that they came there to look at Edward in the sun. She turns back to look at him, and he steps into the sunlight, but we have to wait until the next chapter to find out what he looks like. I don't know about you, but my breath is bated.
Halfway done! w00t! This is taking way longer than I expected, but then, the book is way worse than I expected.
(Check the pull-down menu under "Ongoing Series" in the left side-blog for more Twilight chapters.)


text:
Quick Search
Show me:
- Latest Titles
- Featured Titles
Portfolio, Programme and Project Management Maturity Model (P3M3®)
P3M3 has become a key standard amongst maturity models - providing a framework where organizations can assess their current performance and put in place improvement plans.
It provides three highly effective 'maturity models' which can be deployed on a number of practical self-assessment variants, or by purchasing the enhanced model that can be tailored to your specific business requirements.
The official P3M3 portfolio includes:
Portfolio, Programme, Project Management (P3M3) Enhanced Self-assessment
P3M3 Enhanced self-assessments for Portfolio, Programme and Project Management (P3M3) supports the latest version of the P3M3 model.
Published: N/A
Price: £300.00
Sub no. 7003213
Also available as:
Standard Self-assessment Online Subscription
Free one month trial subscription online service


text:
Here Today, Gone Tomorrow Lyrics
30 hour drive from home, you'd think I'd feel so alone, that couldn't be less true. Family traveling by my side, lifelong friends we can't deny, see the world with you. Here today, gone tomorrow. We're saying our goodbyes. Drive away from the past. Don't be sad, don't feel sorrow. The memories in our hearts, I won't forget. An icy road with no remorse. A metal box drifting off course has taken everything. I can't believe we lost you. I can't feel any worse now. This must be a dream, when will someone wake me? All my life, I've never felt so strong as when we're all together. All my days, I've never felt so powerless when you were taken away. There's no one in this world with so much love and so much passion. We'll say goodbye but we won't forget the liberty and fortitude. RIP Beatz


text:
Discover Your Space for Success
Find your place at The Executive Centre. Experience a space that can be tailor-made to fit your business, where you can make yourself at home to and thrive both professionally and personally. Feel empowered to achieve; supported by the expertise of our global network. Build connections with like-minded professionals and open the door to new opportunities.
Exclusive Workspaces
Our workspaces do not follow a one-size-fits-all-approach. Whatever the size of your company, discover a space that can adapt to your ambitions.
Shared Workspaces
Enjoy the flexibility of a Coworking and Virtual Office designed to encourage productivity and facilitate connections between like-minded professionals. Open yourself and your business up to new opportunities.
Business Services
Experience everything from state-of-the art technology to the world-class expertise of our friendly and professional on-site team; all working to fulfill your business needs.
Experience The Executive Centre
Take a tour and visualise the future of your business.
Established global presence
Extensive regional reach
Prestigious business addresses
Growing global network
Empowering Businesses
Discover how we enable and empower large multinationals and growing enterprises to succeed.


text:
Select a City
Estacada, OR
Best Farmers' Markets around Estacada, OR
Add an Organization
Albany Farmers Market
4th and Ellsworth Street
Albany, OR
Season: Spring, Summer and Fall Market Hours: April 18 - November 21, 2020Saturdays, 9AM to 1PM Location: 4th and Ellsworth Street, Albany, OR
Read More »
Aloha Community Farmers' Market
17675 Southwest Farmington Road PMB 509
Aloha, OR
Market Hours: May 3, 2018 - September 27, 2018Every Thursday, 3:00pm - 7:00pm Location: Aloha Community Farmers' Market
Read More »
Beaverton Farmers Market
12375 South West 5th Street
Beaverton, OR
MISSION STATEMENT: The objectives of the Beaverton Farmers' Market, Inc. are: to give our community access to a wide variety of fresh, local...
Read More »
Estacada Top Searches
Car Dealers
Hotels and Lodging
Boring Farmers Market
28151 SE Hwy 212
Boring, OR
The Boring Saturday Farmers Market is held on Saturdays from 10 AM to 3 PM from May through September. For now, the Market is held on the beautiful...
Read More »
Brownsville Farmers' Market
North Main Street and Park Avenue
Brownsville, OR
About Us:The Brownsville Farmers Market welcomes vendors with locally produced agricultural products and baked goods as well as locally made crafts...
Read More »
Buckman Portland Farmers Market
Southeast 20th and Salmon Street
Portland, OR
About Us: Founded in 1992, Portland Farmers Market is a 501(c)6 nonprofit organization operating six vibrant farmers markets in Portland, OR. Our m...
Read More »
Bull Mountain Farmers Market
14389 South West Pacific Highway
Tigard, OR
About Us:A farmers market at the base of Bull Mountain in Tigard Oregon dedicated to providing a fun family atmosphere with music, food, and activi...
Read More »
Camas Farmers Market
4th Avenue Between Everett and Franklin
Camas, WA
The Camas Farmer's Market contributes to Camas by being a place: · where the community has access to local and sustainable food &mid...
Read More »
Canby Saturday Market
North Holly Street and Northwest 1st Avenue
Canby, OR
The Canby Farmers Market is a local favorite for young and old alike. Here you will find the best that the Willamette Valley has to offer; from fre...
Read More »
Cedar Mill Farmers' Market
1027 NW Murray Rd.
Portland, OR
Season: Summer Market Hours: May 2 - October 10, 2020Saturdays, 9 am - 2 pm Location: Corner of NW Cornell & Murray in the Safeway parking lot
Read More »
Clatskanie Farmers Market
11 Lillich Street
Clatskanie, OR
Mission:The Clatskanie Farmers' Market (CFM) will serve as a community venue for farmers and artisans, in order to encourage the creation and growt...
Read More »
Corvallis Indoor Winter Market
Guerber Hall, 110 SW 53rd Street
Corvallis, OR
Season: Winter Market Hours:January 11 - April 11, 2020Saturdays, 9AM - 1PMLocation: Guerber Hall - 110 South West 53rd Street
Read More »
Cowlitz Community Farmers Market
1900 7th Avenue
Longview, WA
To serve Cowlitz Community by; operating a viable market for locally grown agricultural products which provide a wide variety of fresh, healthy pro...
Read More »
Cully Community Market
5011 North East 42nd Avenue
Portland, OR
Season: Summer Market Hours: June - August 2020Thursdays, 4 PM - 8 PMSeptember 2020Thursdays, 4 PM - 7 PMLocation: 5011 North East 42nd Avenu...
Read More »
Dalles Farmers' Market
5th and Union Street
The Dalles, OR
Mission:The Corporation's primary purpose shall be to educate and inform the local and regional consumers of the locally and regionally produced fo...
Read More »
Damascus Farmers Market
20100 South East Highway 212
Damascus, OR
The Damascus Farmers Market was launched in 2012 by a small group of Damascus citizens with a strong interest in creating a positive, vibrant commu...
Read More »
Dexter Lake Farmers Market
101 North Shore Drive
Lowell, OR
Season: Summer Market Hours: June 2019 – September 2019 Sunday, 12 pm – 4 pm Location: Rolling Rock Park, 101 North Shore Drive, Lo...
Read More »
Downtown Hillsboro Saturday Farmers' Market
232 NE Lincoln Street
Hillsboro, OR
About the Market A tradition in Hillsboro for 35 years, the Downtown Hillsboro Saturday Farmers' Market is a seasonal open-air market featur...
Read More »
Estacada Farmers Market
664 North West Wade Street
Estacada, OR
Season: Summer Market Hours: May 9 - September 26, 2020Saturdays, 11AM - 3PM Location: Wade Creek House Antiques, 664 North West Wade Street
Read More »
Fairview Open Air Market
1300 NE Village Street (Fairview City Hall)
Fairview, OR
Mission:Our mission is to build community one person at a time. Our commitment is to bring the finest the Northwest has to you. - We are a Gr...
Read More »
Show More
More on Estacada, OR
Search in a different zip code / city:


text:
Heed Dolly's drawing to 'speak even if your voice shakes'
It's no secret that most of us are addicted to social media. We wake up and check our phone, we fall asleep scrolling through our newsfeed.
Sometimes it takes a tragedy to cut through the noise and remind us that words can be used to lift us up or, if we let them, tear us down.
Dolly Everett, a beautiful young woman with the world at her fingertips, recently chose to end her life because of bullying.
Since then, news of her death has spread across our nation, picked up by the likes of ABC and The Today Show.
The news has even spread across the oceans, reported by Britain's BBC.
As a journalist, it amazes me that her message is getting out in this way. For many years, the reporting of suicide has been carefully masked.
The word 'suicide' was not even in a journalist's vocabulary; rather, it was reported as 'a death under tragic circumstances.'
But all of that changed this week, and it saddens me to know that this cultural shift came after the loss of a beautiful life.
I really feel for the kids of today. Social media has become a powerhouse and developed an unparalleled reach over the past decade.
Where once we could leave the bullies in the school yard and return to the safety of our homes, we now carry those bullies around with us everywhere we go and they have the potential to a have a hold over their victims like never before.
I know I'm not alone in saying that we all have dark days, where we feel overwhelmed.
Like me, the rural community is shocked and in mourning. I say shocked because, yes, I just cannot fathom how this happened, but also shocked because you don't often hear of rural youths committing suicide because of cyber bullying.
Mental health and suicide prevention services are very much targeted at middle aged farmers in our rural communities, especially men. Campaigns from organisations like the Black Dog Institute and Beyond Blue aimed at this demographic are incredibly important and offer a starting point for how we can approach this issue for rural teens.
Country kids, if they choose, can relish in the wide open spaces, nature and the opportunities that life on farm provides. It's not the only solution but taking a moment to hop offline and look at the world around us can make a huge difference.
I don't yet know the statistics on youth suicide in rural areas, and what role social media plays in it, but I definitely plan to find out more.
What I do know at this point though, is that one in four young people has experienced a mental health issue in the past 12 months – a higher prevalence than all other age groups.
Alarmingly, suicide is the leading cause of death of young people, accounting for one third of all deaths.
It's my hope that Dolly's death won't be for nothing, but I know that it is going to take a lot more than one beautiful life to change the culture around cyber bullying and take on the powerhouse that is social media.
So let's stand up together, heed Dolly's drawing to 'speak even if your voice shakes', and bring about a cultural shift like no other.
Readers seeking support can contact:
- Headspace 1800 650 890
- Kids Helpline 1800 55 1800
- Lifeline 13 11 14
- Tune In Not Out


text:
When bailing a friend or family member out of jail, it is very important that you use a bail bond company with good ethics and vast experience. At Leonard Padilla Bail Bonds we have both. Our friendly and trained staff provide excellent service with fast results, one client at a time.
No other bail bond company can beat our service. See why so many Californians agree: You want us on your side! For Free California bail information or guaranteed bail bond services call now.
We understand that this can be a very stressful time for you. For many individuals this is their first time helping out a friend or family member that has had a run-in with the law. If this is the case you may want to know how bail bonds work… How Bail Works
At Leonard Padilla Bail Bonds we offer the lowest rates and flexible payment options to suit your individual needs… Payment Options
If you have any questions or need immediate 24 Hr. service from our Sacramento Bail Bonds office… Contact Us
You Want Him On Your Side
Submit a form and we will contact you ASAP


text:
It seems like GraphLab has since took off big time. There are workshops and conferences about GraphLab. And GraphLab is now developed by the company Dato (formerly GraphLab inc.). Dato Inc. raised 6.75M$ from Madrona and New Enterprise Associates in A round, and 18.5M$ in B round from Vulcan Capital and Opus Capital, as well as Madrona and New Enterprise Associates.
IntroductionThe motivation for GraphLab was to hit the sweetspot in development of machine learning solutions. "(Then in 2010) Existing high-level parallel abstractions like MapReduce are insufficiently expressive, while low-level tools like MPI and Pthreads leave machine learning (ML) experts repeatedly solving the same design challenges."
GraphLab aimed to express asynchronous iterative algorithms with sparse computational dependencies while ensuring data consistency and achieving good parallel performance. This paper provides an efficient multicore parallel (but not distributed) shared-memory implementation of GraphLab. (The C++ reference implementation of the GraphLab is at http://select.cs.cmu.edu/code)
Related workMapReduce works well on embrassingly data parallel tasks, but is not efficient for graph processing and iterative algorithms. This line from the paper gave me a chuckle. "By coercing efficient sequential ML algorithms to satisfy the restrictions imposed by MapReduce, we often produce inefficient parallel algorithms that require many processors to be competitive with comparable sequential methods." (Frank's laptop also took on against GraphLab.)
DAG abstraction represents parallel computation as a directed acyclic graph with data flowing along edges between vertices that correspond to computation/function. Dryad, Storm, Heron fit here. DAG does not naturally express iterative algorithms.
Dataflow abstraction in Naiad is a related work. This being a 2010 paper there is no comparison to Naiad in the paper. This is what Naiad (2013) has to say about GraphLab. "GraphLab and PowerGraph offer a different asynchronous programming model for graph computations, based on a shared memory abstraction. These asynchronous systems are not designed to execute dataflow graphs so the notion of completeness of an epoch or iteration is less important, but the lack of completeness notifications makes it hard to compose asynchronous computations. Although GraphLab and PowerGraph provide a global synchronization mechanism that can be used to write a program that performs one computation after another, they do not achieve task- or pipeline-parallelism between stages of a computation. Naiad allows programs to introduce coordination only where it is required, to support hybrid asynchronous and synchronous computation."
Petuum is also a closely related work. Petuum uses BSP, with SSP relaxation and nonuniform convergence. It looks like GraphLab allows more fine-granular scheduling and supports data-graph computations and dependency modeling better. On the other hand, Petuum was designed clean-slate to support machine learning algorithms better, and introduced model-parallelism concept. GraphLab, as you will see in the summary below is principally a graph processing framework, with good applicability for graph-based machine learning tasks. Petuum paper says "Petuum ML implementations can run faster than other platforms (e.g. Spark, GraphLab4), because Petuum can exploit model dependencies, uneven convergence and error tolerance". The paper provides performance comparison experiments with GraphLab.
GraphLab abstractionThe minimalism yet generality of the GraphLab framework remind me of LISP. "The data graph G = (V, E) encodes both the problem specific sparse computational structure and directly modifiable program state. The user can associate arbitrary blocks of data (or parameters) with each vertex and directed edge in G." (Also the set scheduler that enables users to compose custom update schedules is clever and LISPy.)
Figure 3 illustrates the overall GraphLab framework. A GraphLab program is composed of the following parts:
1. A data graph which represents the data and computational dependencies.
2. Update functions which describe local computation
3. A Sync mechanism for aggregating global state
4. A data consistency model (i.e., Fully Consistent, Edge Consistent or Vertex Consistent), which determines the extent to which computation can overlap.
5. Scheduling primitives which express the order of computation and may depend dynamically on the data.
Data ModelThe GraphLab data model consists of two parts: a directed data graph and a shared data table. The data graph G = (V, E) encodes both the problem specific sparse computational structure and directly modifiable program state. The user can associate arbitrary blocks of data (or parameters) with each vertex and directed edge in G. To support globally shared state, GraphLab provides a shared data table (SDT) which is an associative map, T: [Key] --> Value, between keys and arbitrary blocks of data. Here, Key can be a vertex, edge, result of a sync computation as explained below, or a global variable, say model parameter.
User defined computationComputation in GraphLab can be performed either through an update function which defines the local computation, or through the sync mechanism which defines global aggregation. The Update Function is analogous to the Map in MapReduce, and sync mechanism is analogous to the Reduce operation. A GraphLab program may consist of multiple update functions and it is up to the scheduling model to determine which update functions are applied to which vertices and in which parallel order.
SchedulingThe GraphLab update schedule describes the order in which update functions are applied to vertices and is represented by a parallel data-structure called the scheduler. The scheduler abstractly represents a dynamic list of tasks (vertex-function pairs) which are to be executed by the GraphLab engine. This is minimalist yet flexible and general model. Since writing a scheduler is hard, GraphLab provides a default BSP style scheduler or a round-robin scheduler.
Since many ML algorithms (e.g., Lasso, CoEM, Residual BP) require more control over the tasks that are created and the order in which they are executed, GraphLab also allows update functions to add and reorder tasks. For this, GraphLab provides 1) FIFO schedulers that only permit task creation but do not permit task reordering, and 2) prioritized schedules that permit task reordering at the cost of increased overhead.
EvaluationThe paper demonstrates the expressiveness of the GraphLab framework by designing and implementing parallel versions of belief propagation, Gibbs sampling, Co-EM, Lasso and Compressed Sensing.
LinksGraphLab Wikipedia page
Paper Review. Petuum: A new platform for distributed machine learning on big data


text:
As for why teens in particular seem so willing to take this risk while behind the wheel? Hasan, a 17-year-old from Algonquin, Illinois, believes it has to do with new social realities.
'Kids my age want to stay in touch,' said Hasan. "We like instant communication, and many kids worry what their friends will think if they don't answer a text message immediately."
Kids worry what their friends will think if they don't answer a text message immediately.
There's no denying it: texting is a part of the mainstream culture, and for many young people, texting is an essential means of communication. While we now know texting does demonstrably affect reaction times — The National Safety Council estimates that 200,000 crashes each year are caused by drivers who are texting — stories like Hasan's tell us that not all drivers have gotten the message: Texting while driving is as dangerous as driving drunk, if not more dangerous. Both forms of impairment cause casualties on the road.
Each year, 200,000 crashes are caused by drivers who are texting.
In a State Farm® poll conducted by Harris Interactive, fewer teens view texting while driving as leading to fatal consequences as compared to drinking while driving. Of 14-17 year-olds who intend to have or already have a driver's license, the survey found that 36% strongly agree that if they regularly text and drive they could be killed one day. In contrast, the majority of teens (55%) strongly agree that drinking while driving could be fatal.
One way the issue can be addressed is through frank communication between parents and teen drivers. Of teens who talk often with their parents about driving, 82% strongly agree that if they regularly drink and drive they will get into an accident. That number falls to 72% among teens who rarely or never talk to their parents about driving.
A similar pattern was evident around texting while driving, but in these cases teens view the consequences of texting as less severe. In the survey, 67% of teens who often talk to their parents about driving strongly agree that if they regularly text and drive, someday they will get into an accident. This compared with 56% of teens who rarely or never talk to their parents about driving.
Car crashes are the number one killer of teens in the United States, and the majority of teens rely on their parents to learn how to drive. Sending the right message — and having the data to back it up — might make all the difference.


text:
Wage and Hour Division (WHD)
July 21, 1995
Dear Name*:
This is in response to your letter regarding the application of the provisions of the Family and Medical Leave Act of 1993 (FMLA) to absences due to alcohol abuse or for treatment of alcohol abuse.
Treatment for substance abuse may be a serious health condition for purposes of FMLA if the applicable conditions defining a serious health condition set forth in Regulations, 29 CFR Part 825.114 are met. FMLA leave, however, may only be taken for treatment for substance abuse that is provided by a health care provider or by a provider of health care services on referral by a health care provider. (See section 825.118.) On the other hand, absence because of the employee's use of the substance, rather than for treatment, does not qualify for FMLA leave. (See section 825.114(d).)
Treatment for substance abuse, however, does not necessarily prevent an employer from taking employment action against an employee. The employer may not take action against the employee because the employee has exercised the right to take FMLA leave for treatment. If, however, the employer has an established policy, applied in a nondiscriminatory manner that has been communicated to all employees, that provides that under certain circumstances, including enrolling in a substance abuse program, an employee may be terminated for substance abuse, pursuant to that policy an employee may be terminated whether or not the employee is presently taking FMLA leave. (See section 825.112(g).)
With respect to the first example cited in your letter, the employer apparently did not have an established policy with respect to leaves for substance abuse or treatment for substance abuse. Absent such a policy, the employee would be entitled to intermittent leave for such absences while enrolled in in-patient rehabilitation programs at local hospitals.
With respect to the second situation, the termination was apparently based on the employee's absence due to substance abuse and occurred prior to the employee's entry into a substance abuse program. The employer would not, in that situation, be required to reinstate the employee and provide FMLA leave.
With respect to what FMLA permits when the employer's actions are improper, an employee may be entitled to, as a minimum, reinstatement to the employee's former position or an equivalent position or to FMLA leave status if the employee is not yet able to return to work, an amount equal to any wages lost because of the termination, and any losses due to the loss of benefits. The FMLA also provides a private right of action that, in addition to the above, may result in an additional amount equal to the above as liquidated damages. The actual amount due as well as any other remedial action will depend on the facts and circumstances in each situation.
When employees are absent without advance notice for rehabilitation treatment for substance abuse and the conditions of the FMLA regulations are met as noted above, such absences may be counted against an employee's FMLA leave entitlement as provided in section 825.208. Such an absence may be counted as FMLA leave from the first date of the absence if the employer promptly within two business days of learning of the reason for the absence notifies the employee that the absence is designated and will be counted as FMLA leave. See section 825.208(b)(1).
The above is intended as general guidance and assumes that no other compliance questions are at issue. Please contact this office if you have further questions.
Daniel F. Sweeney
Deputy Assistant Administrator
* Note: The actual name(s) was removed to preserve privacy in accordance with 5 U.S.C. 552 (b)(7).


text:
Some humans seem to care more about pets than people … but why?
This intriguing headline was the title to a recent post published by Mother Nature Network.
Coincidentally there was some useful material in the article that I could use in a chapter in the new book. But I did think the whole article should be shared with you good people.
Some humans seem to care more about pets than people … but why?
Mary Jo DiLonardo November 3, 2017
A Facebook acquaintance of mine recently posted about walking past a pet store where volunteers were outside pleading for pet rescue donations. They pointed out how many dogs and cats were euthanized each year, which made her wonder how people could be so fervent about animals when there are so many sick babies in the world.
It's not that those volunteers dislike babies — or grown-up humans, for that matter — but in some cases, they might simply like animals more.
You know the type, and you may even be one yourself. Some say it's due to unconditional love. Your cat doesn't care if you are in your pajamas all day. Your dog doesn't talk about you behind your back. But when it comes right down to it, does anyone really value animals above humans?
The story of two shootings
Psychology professor and author Hal Herzog looks at the "humanization of pets" in an editorial for Wired. Herzog is the author of "Some We Love, Some We Hate, Some We Eat: Why It's So Hard To Think Straight About Animals."
"Newspaper editors tell me stories about animal abuse often generate more responses from upset readers than articles about violence directed toward humans. But do Americans really care more about pets than people?" Herzog asks.
He tells the story of two shootings that happened within 50 miles of each other in Idaho in 2014. One was Jeanetta Riley, a pregnant mother of two who was shot by police outside of a hospital while she incoherently waved a knife. The story didn't make much of a blip on the news radar.
Less than 14 hours later, police in another Idaho town were called about a report of a barking dog locked in a van. An officer claimed when he approached the vehicle the dog (which he misidentified as a pit bull) lunged at him, so he pulled the trigger. Turns out "Arfee" was a Lab and people became incensed at the shooting, which made national news. There was a "Justice for Arfee" Facebook page and a rally. In the end, the shooting was ruled unjustified, and the police department issued an official apology.
"The bottom line is that, at least in some circumstances, we do value animals over people," Herzog writes. "But the differences in public outrage over the deaths of Jeanetta Riley and Arfee illustrate a more general point. It is that our attitudes to other species are fraught with inconsistency. We share the earth with roughly 40,000 other kinds of vertebrate animals, but most of us only get bent out of shape over the treatment of a handful of species. You know the ones: the big-eye baby seals, circus elephants, chimpanzees, killer whales at Sea World, etc. And while we deeply love our pets, there is little hue and cry over the 24 horses that die on race tracks in the United States each week, let alone the horrific treatment of the nine billion broiler chickens American consume annually."
Creating a moral dilemma
We obviously love our pets. But to what extent?
Researchers set up a moral dilemma where they asked 573 participants what they would do if they had to choose between saving a dog or a person who had darted in front of a bus. The answers varied depending on the relationship they had with the dog and with the person.
In some scenarios, the dog was the participant's own personal dog versus a random canine. And the person was either a foreign tourist, a local stranger, distant cousin, best friend, grandparent or sibling.
The dilemma is something along the lines of, "A bus is traveling down the street. Your dog darts in front of it. At the same time, a foreign tourist steps in the path of the bus. Neither your dog nor the tourist has enough time to get out of the way and it's clear the bus will kill whichever one it hits. You only have time to save one. Which will you save?"
The subjects were much more likely to save the pet over a foreign tourist, versus someone closer to them. People were also much more likely to save their own dog versus a random dog. And women were twice as likely as men to save a dog over a person.
The study was published in the journal Anthrozoos.
Empathy for animals versus people
In another study, sociologists at Northeastern University had college students read made-up news stories in which a victim was attacked by a baseball bat "by an unknown assailant" and left unconscious with a broken leg and other injuries.
The participants were all given the same news story, but the victim in each case was either a 1-year-old baby, a 30-year-old adult, a puppy or a 6-year-old dog. They were asked to rate their feelings of empathy toward the victim after reading the story.
The researchers hypothesized that the victims' vulnerability — determined by their age, not species —would be the key factor in triggering the most concern in the participants.
The baby elicited the most empathy, with the puppy and adult dog not far behind. The adult person came in last.
"Contrary to popular thinking, we are not necessarily more disturbed by animal rather than human suffering," said study co-author Jack Levin, professor of sociology and criminology at Northeastern University, in a statement.
"Our results indicate a much more complex situation with respect to the age and species of victims, with age being the more important component. The fact that adult human crime victims receive less empathy than do child, puppy, and full-grown dog victims suggests that adult dogs are regarded as dependent and vulnerable not unlike their younger canine counterparts and kids."
The research was first presented at the annual meeting of the American Sociological Association in 2013 and has recently been published in the journal Society & Animals.
Although the study focused on cats, Levin says he thinks the findings would be similar for cats versus people.
"Dogs and cats are family pets," he said. "These are animals to which many individuals attribute human characteristics."
Mary Jo DiLonardo writes about everything from health to parenting — and anything that helps explain why her dog does what he does.
So all you wonderful followers of this place – what do you think of some humans seeming to care more for animals?


text:
Sant Cugat del Vallès
Sant Cugat del Vallés Monastery
Sant Cugat del Vallès is a town located only a few kilometres away from Barcelona, in the region of Vallès Occidental. Its monumental heritage, lead by an ancient Benedictine monastery, is surrounded by natural areas of great beauty. Sant Cugat stretches out through a great plain delimited by the sierras of Collserola and Galliners. Despite the many archaeological artefacts found in this area from 2000 BC to 1500 BC, the origins of the city can be narrowed down to the Roman fortress of Castrum Octavianum (4th century AD). On this parade ground, the ancient Benedictine monastery of Sant Cugat was erected, the most remarkable building in the city. The abbacy has a church (12th-14th centuries), and a magnificent Romanesque cloister from the late 12th century. Also note other remarkable outbuildings, like the chapter house, the palace, and the Renaissance upper cloister. Under the wing of the monastery, an important agricultural town developed, with numerous surviving farms, such as Can Rabella (14th century), Can Bellet (16th century), and Torre Blanca (17th century). Sant Cugat also has a number of hermitages scattered around the township, such as Sant Adjutori, Sant Crist de Llaceres, Santa Maria de Campanyà, etc. Other interesting choices include visiting the medieval castle Castell de Canals, and the Gothic bridge Can Vernet. The city centre also has beautiful examples of Modernist architecture, such as Casa Armet, by Ferrán Romeu, and Casa Lluch, by Eduard Maria Balcells. Sant Cugat del Vallès is a privileged spot, from an environmental point of view. Central Park (Parque Central), located at the heart of the urban centre, is the main green area in the city. Nearby we find Collserola Park, considered to be one of the biggest metropolitan parks in the world. In this town, a number of interesting routes originate, such as the one that goes from Can Borell to the Romanesque hermitage of Sant Medir, going through a gorgeous landscape of forests and riverside vegetation.
Więcej informacji
Wycieczki, których nie można przegapić w: Sant Cugat del Vallès
Na mapie znajdziesz wszystkie proponowane przez nas miejsca, które koniecznie musisz zwiedzić. Nie możesz ich przegapić!


text:
Any idea as to how to write a simple algorithm to reverse elements in a queue?
Any idea as to how to write a simple algorithm to reverse elements in a queue?
If it's a double linked list, simply swap the Next and Previous pointers and swap the FirstNode and LastNode pointers.
If not, you could create a new list (queue) by picking the first element in the old list, add it first to the new list, then remove it from the old list.
Give a man a fish and you feed him for a day.
Teach a man to fish and you feed him for a lifetime.
I don't know if this helps, but the standard library provides such a facility...
Code:#include <algorithm> #include <queue> std::queue<int> myqueue; for (int i = 0; i < 10; i++) myqueue.push(i); std::reverse(myqueue.begin(), myqueue.end());
The essence of a queue is that elements are always added to the back of the line & elements are always removed from the front of the line. So if you just remove each element from the queue & add it to a new queue, you end up with a new queue exactly like the original one, in the same order.
But, if you remove each element from the queue and push it onto a stack & continue doing this until the queue is empty & all of the elements are on the stack, and then pop each element off the stack & put it back on the queue, when you finish emptying the stack, your queue will end up with all of its elements in reverse order.


text:
12 Weeks to Beach Body Abs
For everyone who wants to achieve a great body without
living at the gym and eating like a Spartan.
Lawrence Hosannah's latest book, "12 Weeks to Beach Body Abs" The book provides everything you need to know on not only building a great set of abs, but getting you entire body in lean, hard and in strong condition. Summer is around the corner and this book has arrived at the right time for you to get ready for beach season.
You will learn:
How you should eat to not only get lean but to also build muscle at the same time
How to build truly awesome abs without training them that often
Exactly how many reps, sets, exercises you should be doing to drastically speed up fat loss and
muscle gain
The best exercises for leaning up all sections of your abs
How to train in a way that progressively produces results each and every week
Speed up you metabolism even while at rest, which means more overall fat loss
Learn how you can use recovery factors to drastically speed up your progress
Utilize new cardio protocols that burn body fat for hours and days after you have done them
Learn the best food choices to getting and staying lean
Learn how to optimally perform the best exercises for building great abs and much more
"12 Weeks to Beach Body Abs" contains all the techniques that Lawrence Hosannah uses himself, not only to build his own body, but to help his clients achieve an awesome body.  The book was written for the person who wants to achieve a great body without living in the gym and eating like a Spartan.
To order "12 Weeks to Beach Body Abs," Â go to http://www.lawrencehosannah.com/?q=node/16
Lawrence Hosannah
Developing awesome physiques in minimal time
Creative artistic alchemy
serving your art and design needs
To subscribe to or advertise in New York's leading Pan African weekly investigative newspaper, please call (212) 481-7745 or send a note to email@example.com
"Speaking Truth To Empower.�
Latest comments
- Ann GarrisonFebruary 22,2018 @ 08:03 PM
I think you have "Filtered HTML" turned on here. If you switch to "Full HTML," it will probably...
googletag.pubads().definePassback('6785150/BENN/BlackStarNews', [[300,250]]).setTargeting('fold',['BTF']).display();


text:
own(redirected from be own man)
Also found in: Dictionary, Thesaurus, Financial, Idioms.
v. to have legal title or right to something. Mere possession is not ownership.
ownverb be in possession of, be in receipt of, be master of, be possessed of, claim, command, contain, control, dominate, enjoy, habere, have, have a deed for, have a title to, have claim upon, have hold of, have in hand, have rights to, have to one's name, hold, keep, maintain, occupy, possess, possidere, retain, tenere
Foreign phrases: Id solum nostrum quod debitis deductis nostrum est.That only is ours which remains to us after deeuction of our debts.
See also: acknowledge, avow, hold, individual, occupy, particular, personal, possess, profess, recognize, remain


text:
Journal Article
Water Injection as an Enabler for Increased Efficiency at High-Load in a Direct Injected, Boosted, SI Engine
In a Spark-Ignited engine, there will come a point, as load is increased, where the unburned air-fuel mixture undergoes auto-ignition (knock). The onset of knock represents the upper limit of engine output, and limits the extent of engine downsizing / boosting that can be implemented for a given application. Although effective at mitigating knock, requiring high octane fuel is not an option for most markets. Retarding spark timing can extend the high load limit incrementally, but is still bounded by limits for exhaust gas temperature, and spark retard results in a notable loss of efficiency. Likewise, enriching the air-fuel mixture also decreases efficiency, and has profound negative impacts on engine out emissions. In this current work, a Direct-Injected, Boosted, Spark-Ignited engine with Variable Valve Timing was tested under steady state high load operation. Comparisons were made among three fuels; an 87 AKI, a 91 AKI, and a 110 AKI off-road only race fuel.


text:
Using Common Plants to Identify Wetlands
Identification Guide for Northwestern Lower MichiganBook - 2003
How to use common plants to identify wetlands in Michigan. A field guide for the non-botanist.
Characteristics: unpaged : 22 cm.
Additional Contributors:
From the critics
Community Activity
CommentAdd a Comment
There are no comments for this title yet.
AgeAdd Age Suitability
There are no ages for this title yet.
SummaryAdd a Summary
There are no summaries for this title yet.
NoticesAdd Notices
There are no notices for this title yet.
QuotesAdd a Quote
There are no quotes for this title yet.


text:
Death after Birth Independent Film Pitch
by Dwomoh-Doyen
(Accra, Ghana)
Death after Birth Independent Film Pitch
When fate decides to define your destiny, it takes a lot of courage and strength to fight back! A pretty girl, Zynell is born into the world by ill-fated circumstance. The brutality, hatred and sexual assault were more than she could bear.
To help write a book in memory of such a sour journey through the world, she invites to the prison, Father Damian whom she unravels the episodes of the story of her Death after Birth.
Life presents every human being with two paramount things; `birth and death`, but it becomes more thought provoking when the death is obvious after birth.
Submitted Wed Sep 14 19:37:51 2011 EDT
By: Dwomoh-Doyen ,
Accra, Ghana
Back to Independent Film Pitch
Return to Independent Film Pitch.
Promote YOUR Story, Business, Film on FilmProposals
Do you have some great indie filmmaker tips to share with other aspiring or current filmmakers? Do you want to promote your latest film or service to a huge global network of filmmakers, producers, directors, potential investors and distributors? Here is a great opportunity to first, pay it forward, and then promote your projects, products and services.
More Info: Filmmaker Tips - Write for FilmProposals
2020 is YOUR Year - Make Your Movie
FilmProposals Financing Packages
- Financing Manual
- Financial Projections Template
- Business Plan Template
- Regular Price $137, Save $38
SilverMost Popular
- Full Bronze Package
- +Indie Film Pitch Deck
- +Investor Agreement Outline
- +Film Budget Template
- Regular Price $214, Save $75
- Full Silver Package
- + Professional Business Plan Review
- Regular Price $564, Save $175
TestimonialsCheck out some of our Filmmaker Reviews
Just want to thank you for your materials and help over the past year. I could not have raised the $1.5 million or made this film without the materials you provided -- and for $99? The bargain of my career!
I'm now sending out my completed business plan/film proposal document to potential investors and the one comment I'm getting back almost immediately is that it's so well laid out and professional. Believe me, first impressions really do count.
This is perfect! I have potential investors but I had no idea how to prepare a professional investment package to present to them. (I'm an artiste', not a business person. :) ) The information is clear and easy to understand, and Melissa is very prompt in answering emails.
Hi Melissa! I purchased Package #3 a couple of days ago, and I feel like I'm taking a crash course in film financing. So far, what I've read and learned has been invaluable. Thank you!
FilmProposals Tools and Templates
- Film Financing Bundles
- Film Financial Projections Template
- Film Business Plan Template
- Film Financing and Investor Manual
- Film Budget Template
- Indie Film Pitch Deck
- Film Investor Agreement Outline
- Film Investor Tip Sheet
- FREE Business Plan E-Course


text:
Find an Agent
Please enter a valid ZIP Code or a valid City/State combination.
Results per page
Find an insurance broker outside the USFind a Lloyd's Broker
Why use an
independent agent?
Consumers are well served by turning to an independent agent for the personal service and attention that an agent provides.Learn More »


text:
美女视频黄频大全视频免费-伊人高清视频-4438xx20-美女视频黄频大全视频免费Looking to be transformed during your college experience? Look no further than Columbus State University located in beautiful Columbus, Georgia! As a regionally ranked and accredited University, CSU offers 65 undergraduate and 30 graduate degrees in the fine arts and humanities, business, education, nursing, social sciences and more. We're located just 100 miles southwest of Atlanta and occupy two unique campuses just minutes apart from each other. You will be challenged in small classes and experience one-on-one interaction with your professors while developing lasting friendships through our active residential life programs. With over 100 clubs and 16 Division II athletic teams, you will find a number of ways to be involved, acquire leadership skills, and show school spirit. We invite you to explore the many opportunities Columbus State provides and see why over 8,500 students have made CSU their First Choice!
美女视频黄频大全视频免费-伊人高清视频-4438xx20-美女视频黄频大全视频免费Currently enrolled High School or College students who are interested in pursuing but have not yet obtained a 4-year college degree, or those interested in pursuing a second bachelor's degree.
Students who have obtained a 4-year college degree and are interested in pursuing a graduate certificate, master's or doctorate degree.
美女视频黄频大全视频免费-伊人高清视频-4438xx20-美女视频黄频大全视频免费Students who will study on an F1 student visa are considered international.
Dual Enrollment
Students who are currently enrolled in high school, that are interested in the Dual Enrollment or Joint Enrolled Programs


text:
Best sellers
From 15 EUR
From 23 EUR
From 180 EUR
From 430 EUR
From 33 EUR
Moscow hosts World Cup 2018: what the tourists can see in the capital
In the days of World Cup 2018 fans will be able to travel for free between cities and see the most beautiful places in Russia. Everywhere will be the atmosphere of a holiday, football and hospitality.
"Sapsan" is Russian for the peregrine falcon, the fastest bird in the falcon family, so it was an appropriate name for this new train, which can reach speeds of up to 250 kmph. Produced with true German precision by Siemens, the Sapsan is fully adapted to the harsh climate of Russia.


text:
NORD gratefully acknowledges Susan Winter, MD, Medical Director of Medical Genetics/Metabolism, Valley Children's Hospital, Madera, California, for assistance in the preparation of this report.
Carnitine palmitoyltransferase 1A deficiency (CPT1A) is characterized by a sudden onset of liver failure and damage to the nervous system resulting from liver failure (hepatic encephalopathy), usually associated with fasting or illness. CPT1A deficiency is caused by an abnormality (mutation) in the CPT1A gene that results in the production of an abnormally functioning carnitine palmitoyltransferase 1 enzyme and decreased metabolism of long-chain fatty acids. CPT1A deficiency is inherited as an autosomal recessive genetic disorder.
Three types of CPT1A deficiency have been recognized: The hepatic encephalopathy type usually occurs in children and is associated with a low level of ketones in the blood, low blood sugar (hypoglycemia), enlarged liver, muscle weakness and elevated carnitine in the blood. The adult-onset myopathy type is characterized by a sudden onset of muscle cramping associated with exercise without low blood sugar or liver dysfunction. The third type is acute fatty liver of pregnancy that occurs when a pregnant woman with one abnormal CPT1A gene carries a fetus with two abnormal CPT1A genes and is associated with liver failure in the mother.
CPT1A deficiency is caused by a mistake in the code for the CPT1A gene (mutation) resulting in decreased carnitine palmitoyltransferase 1 enzyme activity preventing normal metabolism of long-chain fatty acids from food and stored fat and decreased energy production.
CPT1A deficiency is inherited as an autosomal recessive genetic disorder with a 25% recurrence risk for future children to be affected. Autosomal recessive genetic diseases occur when each parent carries a mutation on the same gene (carrier) and each parent passes the mutated gene on to the child, giving the child no normal gene to compensate for the mutations.
If an individual receives one normal gene and one gene for the disease, the person will be a carrier for the disease, but usually will not show symptoms. The risk for two carrier parents to both pass the defective gene and, therefore, have an affected child is 25% with each pregnancy. The risk to have a child who is a carrier like the parents is 50% with each pregnancy. The chance for a child to receive normal genes from both parents and be genetically normal for that particular trait is 25%. The risk is the same for males and females.
All individuals carry nearly 30 gene mutations. Usually, the parents do not match on the genes mutated and the children cannot be affected. Parents who are close relatives (consanguineous) have a higher chance than unrelated parents to be carrying the same abnormal gene, increasing their risk to have children with a recessive genetic disorder.
CPT1A deficiency has been reported in approximately 30-40 individuals. The incidence of this condition may be higher in the Hutterite populations in the northern United States and Canada and the Inuit populations in northern Canada, Alaska and Greenland. This condition occurs with equal frequency in males and females.
CPT1A deficiency is diagnosed by a combination of physical symptoms and laboratory testing. The typical laboratory findings include low levels of ketones, elevated liver transaminases, elevated ammonia and elevated total serum carnitine. CPT1A enzyme activity on the cultured skin cells from affected individuals is 1-5% of normal. Molecular genetic testing is available to confirm the diagnosis if the enzyme test is abnormal. Some state newborn screening programs perform screening for CPT1A deficiency by measuring the ratio of free to total carnitine in blood plasma or serum. Carrier testing for relatives is available using CPT1A enzyme testing or molecular genetic testing.
Prevention of hypoglycemia is recommended to reduce the risk of neurological effects. This can be accomplished with a high carbohydrate, low fat diet and frequent feeding. If acute hypoglycemia occurs, intravenous dextrose should be provided. Individuals with CPT1A deficiency should have regular liver function testing performed. Female carriers of an abnormal CPT1A gene should be informed about the possibility of obstetric complications.
Information on current clinical trials is posted on the Internet at www.clinicaltrials.gov. All studies receiving U.S. government funding, and some supported by private industry, are posted on this government website.
For information about clinical trials being conducted at the National Institutes of Health (NIH) in Bethesda, MD, contact the NIH Patient Recruitment Office:
Tollfree: (800) 411-1222
Email: [email protected]
nformation on current clinical trials is posted on the Internet at www.clinicaltrials.gov. All studies receiving U.S. government funding, and some supported by private industry, are posted on this government web site.
For information about clinical trials being conducted at the NIH Clinical Center in Bethesda, MD, contact the NIH Patient Recruitment Office:
Tollfree: (800) 411-1222
Email: [email protected]
For information about clinical trials sponsored by private sources, contact:
Research on inborn errors of metabolism is ongoing. Scientists are studying the causes of these disorders and trying to design enzyme replacement therapies that will return a missing enzyme to the body.
Fauci AS, Braunwald E, Isselbacher KJ, et al. Eds. Harrison's Principles of Internal Medicine. 14th ed.McGraw-Hill Companies. New York, NY; 1998:2479.
Scriver CR, Beaudet AL, Sly WS, et al. Eds. The Metabolic Molecular Basis of Inherited Disease. 8th ed. McGraw-Hill Companies. New York, NY; 2001:2305, 2317-18.
Adams RD, Victor M, Ropper AA. Eds. Principles of Neurology. 6th ed. McGraw-Hill Companies. New York, NY; 1997:1438-39.
Lyon G, Adams RD, Kolodny EH. Eds. Neurology of Hereditary Metabolic Diseases in Childhood. 2nd ed. McGraw-Hill Companies. New York, NY; 1996:27,28,101.
McGarry JD. Travels between carnitine palmitoyltransferase I: from liver cell to germ cell with stops in between. Biochem Soc Trans. 2001;20 (Pt2):241-45.
Vockley J, Rinaldo P, Bennett MJ, et al. Synergistic heterozygosity: disease resulting from multi[ple partial defects in one or more metabolic pathways. Mol Genet Metab. 2000;71:10-18.
Bonnefont JP, Demaugre F, Prip-Buus C, et al. Carnitine palmitoyltransferase deficiencies. Mol Genet Metab. 1999;68:424-40.
Tein I. Neonatal metabolic myopathies. Semin Perinatol. 1999;23:125-51.
Morillas M, Lopez-Vinas E, Valencia A, et al. Structural model of carnitine palmitoyltransferase I based on the carnitine-acetyltransferase crystal. Biochem J. 2004;379(Pt3):777-84.
Gobin S, Thuillier L, Jogl G, et al. Functional and structural basis of carnitine palmitoyltransferase 1A deficiency. J Biol Chem. 2003;278:50428-434.
Shigematsu Y, Hirano S, Hata I, et al. Selective screening for fatty acid oxidation disorders by tandem mass spectrometry: difficulties in practical discrimination. J Chromatogr B Analyt Technol Biomed Life Sci. 2003;15:63-72.
Gobin S, Bonnefont JP, Prip-Buus C, et al. Organization of the human liver carnitine palmitoyltransferase 1 gene (CPT1A) and identification of novel mutations in hypoketotic hypoglycaemia. Hum Genet. 2002;111:179-89.
Invernizzi F, Burlin AB, Donadio A, et al. Lethal neonatal presentation of carnitine palmitoyltransferase I deficiency. J Inherit Metab Dis. 2001;24:601-02.
Bennett, MJ and Narayan SB, (Posted 7/27/05). Carnitine Palmitoyltransferase 1A Deficiency. In GeneReviews at Genetests:Medical Genetics Information Resource (database online). Copyright, University of Washington, Seattle. 1997-2006. Available at http://genetests.org. Accessed 3/06.
McKusick VA, ed. Online Mendelian Inheritance In Man (OMIM). The Johns Hopkins University. Carnitine Palmitoyltransferase I Deficiency. Number; 255120: Last Edit Date; 8/23/2004.
McKusick VA, ed. Online Mendelian Inheritance In Man (OMIM). The Johns Hopkins University. Carnitine Palmitoyltransferase I, Muscle; CPT1B Entry Number; 601987: Last Edit Date; 8/6/2002.
Vladutiu GD. Mind Over Matter: The Realities of a Common Muscle Disease. ©1999-2004 FOD Support Family Support Group. 4pp.
Vladutiu GD. Fundamental differences [between CPT-I and CPT-II]. ©1999-2000. The Spiral Notebook. 2pp.
Roe CR. Diagnostic Approach to Disorders of Fat Oxidation/Information for Clinicians. ©1999-2004 FOD Support Family Support Group. 11pp.
Bonnefort J-P, Thullier L. Carnitine palmitoyltransferase 1 deficiency. Orphanet. April 2002. 2pp.
The information in NORD's Rare Disease Database is for educational purposes only and is not intended to replace the advice of a physician or other qualified medical professional.
The content of the website and databases of the National Organization for Rare Disorders (NORD) is copyrighted and may not be reproduced, copied, downloaded or disseminated, in any way, for any commercial or public purpose, without prior written authorization and approval from NORD. Individuals may print one hard copy of an individual disease for personal use, provided that content is unmodified and includes NORD's copyright.
National Organization for Rare Disorders (NORD)
55 Kenosia Ave., Danbury CT 06810 • (203)744-0100


text:
It makes it feel like you're in the middle of Tron, but GM's new heads-up display's not just a way to play out childhood fantasies. The system projects laser-generated images onto windshields, providing a great looking enhanced vision display.
The idea is that unlike some of the HUDs on the market now, this display would be full-windshield and actually highlight or outline potential dangers by using data from a combination of on-vehicle sensors and cameras:
Just imagine driving on a particularly rainy or foggy day. Sure, you'll eventually notice that white car puttering along with its lights off or that person running across the street, but your car could alert you of their presence sooner. [Jalopnik]


text:
The photoshoot for this year's Screen International UK Stars of Tomorrow.
Photography by Yves Salmon, assisted by Rocio Chacon and Vanessa Short.
With thanks to 3 Mills Studios London for hosting the photoshoot. Make-up by Cher Webb and Claire Mulleady for MAC. Lighting by Bowens International. Furniture from Eka at Pictures & Light, London.


text:
The State Independent Living Council (SILC) is a Governor appointed body, offering people with disabilities control over the design of Oregon's Independent Living program services.
The program promotes a philosophy in American society of inclusion of people with disabilities as independent and productive participants. Read more about the State Independent Living Council.
Independent Living services are designed to help individuals who experience disabilities achieve personal goals for independence and participation in their families and communities.
Find out what services are available, whether you are eligible, and how to find services.
Find information about accessibility, accommodations, preparing for an emergency and more on our Resources page.
What are the needs in Oregon? Learn about our survey for Spanish speakers (Word) (PDF)


text:
Time for another cookie recipe.
I took a few days off from posting cookie recipes. Not because I don't have any left, but because I have been busy just like everybody else this holiday season. The past two and half weeks have seemed to fly by, except for the hours I spend at work which seem to drag on and on. This tends to happen when I have something to look forward to. Right now, like many of you, I have a lot to look forward to. Not only is Christmas next week and I am taking two weeks off from work, but I am also going to visit my boyfriend's family in West Virginia (which I love doing) and my sister is getting married on December 27th in New Orleans. I happen to be her Maid of Honor and am getting pretty excited for her big day.
It only seemed appropriate that I save this recipe for when I mentioned my sister's wedding. These are Mexican Wedding Cookies. I have had these a couple times here and there growing up, but not any time recently. Then my friend Maria brought theses cookies to the cookie exchange I hosted. They are great little cookies; buttery, sweet, and nutty.
I don't get too many comments on these posts most days, but in the spirit of the Holidays how about sharing what you are looking forward to most in the next few weeks.
Mexican Wedding Cookies
recipe from Maria Vastola
1 cup butter
1/2 cup white sugar
2 teaspoons vanilla extract
2 teaspoons water
2 cups all-purpose flour
1 cup chopped walnuts (can use pecans as well)
1/2 cup confectioners' sugar
In a medium bowl, cream the butter and sugar. Stir in vanilla and water. Add the flour and almonds, mix until blended. Cover and chill for 3 hours.
Preheat oven to 325 degrees.
Shape dough into balls or crescents. Place on an unprepared cookie sheet and bake for 15 to 20 minutes in the preheated oven. Remove from pan to cool on wire racks. When cookies are cool, roll in confectioners' sugar. Store at room temperature in an airtight container.
Wednesday, December 17, 2008
More from the Cookie Exchange
Time for another cookie recipe.


text:
Home Entertainment
Dalmatians II, Two Towers Score DVD Exclusive Awards
The 3rd Annual DVD Exclusive Awards honored achievements in home video Tuesday night, singling out the second installment in the Lord of the Rings trilogy and heaping numerous accolades on Disneys animated direct-to-video sequel to a time-honored classic.
Actress Jenny McCarthy (Scary Movie 3) hosted the event recognizing the individual artistic achievement in movies produced for home viewing and special editions of theatrical releases. Winners were selected by 600 DVD Exclusive Academy members made up of filmmakers and TV and DVD producers.
The Lord of the Rings: The Two Towers Special Extended Edition took top honors for Best Overall DVD, New Movie. The title also won Best New Movie Scenes for its 43 minutes of new and extended footage.
Best Overall DVD, Classic Movie went to Twentieth Century Fox Home Ent.s Alien Quadrilogy, which was released this week. It was also awarded Best Audio Commentary for tracks featuring director Ridley Scott, writer Dan O'Bannon, stars Sigourney Weaver, Tom Skerritt, Veronica Cartwright, Harry Dean Stanton, John Hurt and others.
Best Animated DVD Premiere Movie was awarded to Buena Vista Home Ent.s Disneys 101 Dalmatians II: Patch's London Adventure, which also earned a Best Director win for Jim Kammerud and Brian Smith. In addition, Richard Gibbs score for the movie picked up Best Original Score in a DVD Premiere Movie and Robert S. Birchard was honored for Best Editing of a DVD Premiere Movie. Rounding out Dalmatians raft of wins is Best Animated Character Performance, which went to character design supervisor Dan Root and actor Martin Short for his turn as eccentric artist Lars.
Disney/Pixars Finding Nemo was also well represented with wins for Best Menu Design, Best Games and Interactivities and Best Deleted Scenes, Outtakes and Bloopers. Meanwhile, the LEGO/Miramax/Buena Vista CG-animated release Bionicle: Mask of Light was recognized for Best Visual Effects in a DVD Premiere Movie.
Produced by Dick Clark Prods. and DVD Exclusive magazine (a sister publication of Daily Variety), the ceremony was taped on Dec. 2 and will air on the FX network on Tuesday, Dec. 9 at 8:00 p.m. ET/PT.


text:
*Please note there is a processing fee for all payments made online through this site.
If your payment is rejected for any reason, your processing fee will not be refunded.
Any over-payments made will be applied as a credit to your next bill.
There is already a payment for this ticket number in our system.
To check the status of this ticket number please visit the Payment Status
page by clicking on the Payment Status menu option.
Do you still want to submit payment for this ticket number?


text:
As the global leader in logistics technology, we have developed a series of six new videos to provide a quick overview of the challenges facing logistics-oriented businesses, and how Descartes is helping companies rapidly derive value from cloud-based supply chain and logistics technology.
View a quick animation that shows how companies can better analyze the flow of goods across borders, make better sourcing decisions, keep track of key commodities, trace supply chain relationships, locate sales leads and boost revenue to new heights.
Cyber-related sanctions controls have been a hot button issue for years. The U.S. Office of Foreign Assets Control (OFAC) is now populating Denied Party Screening (DPS) lists with names. Market leading businesses are including a cyber sanctions review as one of the standard checks and balances prerequisite to reduce risk.
Working with Port Technology International (PTI), the Descartes Datamyne™ Annual U.S. Port Report analyzes the top 20 U.S. ocean ports ranked by import TEUs. Register to download a free PDF copy of the report to keep a pulse on port volume trends, gauge changing demand and to evaluate where goods should cross borders.
Headquartered in Connecticut, Rogers Corporation is a global technology leader in engineered materials with manufacturing facilities in the United States, China, Germany, Belgium, Hungary and South Korea. Since 2010, as part of its corporate compliance practices, Rogers has used Descartes' denied party screening system to help mitigate the risk of transacting with sanctioned or restricted parties by screening customer data. Since then, Rogers has expanded its use of the solution to help assess the compliance history of acquisitions. Once acquired companies are integrated into the broader organization, Rogers relies on the Descartes solution to dynamically and regularly screen all of the acquisition's customer and vendor relationships.
Descartes' Employee Excellence & Innovation Award recognizes one employee each quarter for their contributions in helping make our customers and partners successful. To be eligible for nomination via their peers, the employee must have demonstrated:
It's a pleasure to announce the latest winners of the Descartes Excellence and Innovation award: Jason Leonard, Director, GLN Air R&D and Luke Maxon, Solution Architect.
The International Air Transport Association (IATA) launched eAWBLink as an easy-to-use solution to accelerate global electronic air waybill (eAWB) adoption. IATA is partnering with Descartes to use the Descartes Global Logistics Network™ (Descartes GLN™) as the tool to connect eAWBLink with over 100 carriers, and to help small- to medium-sized freight forwarders electronically communicate and receive air waybill (eAWB) data and status messages.
Updated approximately every 5 years, the HS is an international classification standard that is in current or anticipated use by 207 customs administrations worldwide. Every business with affected items must act by reviewing tariff codes, duty rates and customs data for hundreds, thousands or even tens of thousands of items in their parts master databases or Enterprise Resource Planning (ERP) systems. These items must also be updated for every country where business is transacted on the effective date each country activates its changes.
In speaking with customers over the last few months, we have seen a significant increase in transportation teams taking more control of their inbound freight. Historically, most of the return on investment (ROI) for transportation management systems (TMS) was focused on outbound transportation by optimizing across less than truckload (LTL)/truckload (TL) and cutting freight costs while creating increased visibility and customer service. Now, with the advent of cloud-based transportation management systems that support a wider range of modes (e.g. parcel, fleet, air and ocean) and better supplier connectivity, the opportunity to expand the use of TMS to reduce the cost of inbound shipments is greater than ever.


text:
The Hollywood Beach Marriott in Greater Fort Lauderdale is sprucing up and has completed multiple upgrades to enhance the guest experience. It's spent approximately $1 million on the following updates:
Plus the marina on the intracoastal side of the hotel was purchased; the hotel will have new docks and a potential restaurant there.
DreamWorks Parade
Royal Caribbean's Allure of the Seas
Sailing from Port Canaveral, FL.
Photos by Susan J. Young..
Spotlight Story
Americana in Action!
Pomp, Pride and Precision .... The Citadel's Dress Parade


text:
The parting words of a friend still rang in my ears, "You have your whole life ahead of you. The world at your feet." I mustered up all the wisdom I possessed from my 18 years, gathered my bags and set off hundreds of miles to a foreign and exciting new destination: college.
I had a vague realization that entering a university somehow marked the end of childhood and the onset of adulthood. Mostly, though, I concentrated on my dreams, waiting to be discovered and fulfilled, and a new identity that needed to be forged.
All too soon, I was whisked away in a flurry of activity, trying to navigate the newfound freedom that came with making friends, choosing professors and classes, getting involved in student organizations, landing the perfect internship and, of course, finding love.
Three years later, I found myself in a relationship with a young man all too wrong for me. I found myself thinking, How did this happen? More importantly, I began to wonder whether the ideals abd standards I had thought so promising were really realizable.
My story is not so unique. Many of my female friends have faced confusion and difficulties in their romantic relationships. Other young women have never witnessed a loving relationship modeled for them to imitate.
Jason and Crystalina Evert, chastity speakers and authors of How to Find Your Soulmate Without Losing Your Soul (Totus Tuus Press, 2011), report, sadly, that "countless young women have never seen a man properly love a woman. How is a girl to hope for something she's never seen? Even if she does have a vague notion of how love should be, she might refuse to hope in it, assuming that such dreams will only end in disappointment."
The culture doesn't help. Long accepted ways of behaving that would serve to inform and guide young adults in how to build healthy romantic relationships are largely done away with. In the name of freedom, many young women find themselves sliding into behaviors they have not chosen, with poor results. The decline of healthy dating on college campuses and the rise of the hook-up culture helps perpetuate this cycle. Faced with the confusion and pain that comes from feeling used, devalued or ignored, many women internalize these bruises and make them a defining part of their identities. Christopher West, perhaps the best-known popularizer of Pope John Paul II's theology of the body, has rightly said that we, as women, have been abused by our culture.
Strength in Numbers
I have learned that this does not have to be so. All across the country, college students — aided by organizations such as the Love and Fidelity Network (LoveandFidelity.org), the Ruth Institute (RuthInstitute.org) and others — are recognizing the great sense of loss felt and the dissatisfaction experienced by living in a culture that promises more than it delivers. Many of the heartaches students experience could have been avoided, if only there had been more information and education given to them about how to build healthy relationships.
By forming student groups and supporting one another in their principles, students are strengthened in their resolve and educated on how to articulately defend their reasons for living chastely. That's what we do at the Love and Fidelity Network, where I'm director of outreach and programs.
Lives are changed through the discussions and interactions that students and young adults have with one other, simply by discovering that, at last, they are not alone. The presence of these groups on campus gives students the permission to be confident in their principles and maintain their commitments. It gives them hope and direction for brighter futures.
As the Everts note in their book, "Allow yourself to experience the ache within you for something beautiful. It's not childish to dream about finding a love that helps you become the woman you want to be. However, no one can give you this kind of love. You have to work for it ... the process begins by loving yourself enough to avoid the guys who don't."
Made for More
We are made for more than what society would offer. We are searching for a deeper, more meaningful kind of existence. We want friendships that serve to make us the best version of ourselves — and love that leads us closer to friendship with God. We have grown weary of the fake, anemic representations of romance that leave us unfulfilled and anxious. These lessons weren't so clear to me at the beginning, but they have come into focus.
Looking back, I can see that it was due to the hopeful words and reassurances of friends who cared for me that I decided to take some time off from dating and grow deeper in my relationship with God and those friends he had placed in my life. As I began to prioritize my friendships, I didn't worry that I was missing out on the love of my life. Rather, I came to understand that the ingredients that make up authentic friendship are the same that go into the recipe for fulfilling, long-lasting love: trust, commitment, sacrifice, communication, unselfishness. Moreover, a true friendship is a foundation from which authentic love can develop. Edward Sri, author of Men, Women, and the Mystery of Love (Servant, 2007), states that "the only way two human persons can avoid using each other is to relate in pursuit of a common good, as in the virtuous friendship."
I decided to be friends with God again. He and I had lost good footing during the time when I was preoccupied with misfit romances. Whereas I felt like I was losing myself by dating the wrong people, by getting to know God again, I began to rediscover my identity and the purpose for which I was on this earth. Placing all of those questions tucked away in the recesses of my heart close in his loving care, he slowly provided me with answers and helped me discover that I was called to a life of authentic love.
The doubts I had about whether my standards were foolish disappeared. By daily learning how to hold God's hand as he led me, I began to embrace life to the fullest, while maintaining my integrity and upholding my dignity. I found healing and began learning how to love fully through friendship — the first being friendship with God.
Ashley Crouch earned a bachelor's in theology at the University of Dallas and is director of outreach and programs at the Love and Fidelity Network in Princeton, New Jersey.


text:
Inspired by the grand Allan Houser sculptures that visitors can enjoy through Nov. 13, the committee for the Denver Botanic Gardens' 27th Fete des Fleurs chose "Celebrate Native Beauty," a theme that chairwoman Karen Fox Wolfe said was intended to pay tribute to "… the beauty that is dear to all of our Colorado hearts."
Everything — from the menu to the decor to the music that Native American flutist Jon Romero played during the sit-down dinner — contained elements unique to the American Southwest.
See pictures from Fete des Fleurs
As guests entered the gardens they were offered the evening's featured libation (a refreshing vodka-based drink sweetened with prickly pear juice and agave nectar) by liveried waiters from Catering by Design. Wolfe and her husband, Ian, also were stationed at the entry, greeting nearly every one of the 440 guests by name before pointing the way to the Romantic Garden where six varieties of appetizers were served.
The treats included blue corn pancakes topped with barbecued local duck and candied jalapeno, Riverbend Farms trout ceviche served in lime tortilla edible spoons, fry bread tacos and miniature chile rellenos.
Dinner, served in the giant UMB Bank Amphitheater tent that DBG recently purchased to better accommodate those attending the numerous special events held there, began with an amuse bouche of Anasazi beans topped with Palisade peach pico. Petrocco Farms prickly pear vegetable gazpacho was next, followed by Vermejo Ranch buffalo short rib barbacoa paired with a pasilla chile and cotija cheese tamale. Dessert was a strawberry rubarb crisp topped with a scoop of cinnamon ice cream. The dinner tables were dressed with burlap cloths and centerpieces fashioned from native succulents and made by members of the Garden Club of Denver, whose president, Mary Elliman, attended Fete des Fleurs with her husband, Don.
Much of the credit for the imaginative menu goes to Allison Perkins, whose husband, Nelson, is an owner of Colt & Gray restaurant; she collaborated with Catering by Design chief Cade Nagy to choose dishes that would not only compliment the theme but appeal to a crowd that appreciates food other than standard banquet fare. Perkins' sister, Amy Corrigan, headed the decorations committee and together they will chair Fete des Fleurs in 2012, following the footsteps of their mother, Nancy Stamper, who had the honor several years ago.
2011 chair Karen Wolfe was introduced to Fete three years ago when that year's leader, Brooke Bansbach Maloy, asked her to serve on the committee. "I was hooked," Wolfe said. "The gardens are one of Denver's most precious cultural assets and I love doing what I can to help out." In addition to her work on behalf of the DBG, Wolfe is a volunteer at SafeHouse Denver.
Brian Vogt, DBG's chief executive officer, and Nancy Schotters, chair of the DBG board of trustees, also were busy welcoming those whose presence helped raise some $200,000 for education, research, conservation and community outreach programs. Prominent among them: Kenny Wyatt, president of presenting sponsor CenturyLink's south central region president.
Others staying on to enjoy dancing to the music of Soul X or a nightcap in the Starlight Lounge set up on the terrace of Marnie's Pavilion were Katie Stapleton and beau Patrick Coulson; Peter and Meredith Coors; Janet Mordecai; Dick and Susan Kirk; Chris and Rosie Wiedenmayer; Dennis and Barbara Baldwin; Sally, John, Martha and Rebecca Gart; Newell and Judy Grant; Dennis and Betty Lynn Jackson; Matt and Kelly Stava; Adam and Katie Agron; Stan and Holiday Goodreau; Frank and Monty Kugeler; Scott and Natalie Rekstad Lynn; Jayne Buck; Gordon and Sally Rippey; Howard and Susan Noble; Robert and Lisa Kessler; Jim Palermo and Margaret Williams; Jeff and Susan Strauss; John and Peggy Graham; Elizabeth Schlosser; Amy Slowthower; Jane Davis; Mary Schaefer; Peter and Cynthia Scott; Cissie Megyesy; Michael and Heidi Hammell; Norm and Chris Smith; Linda and Dr. John Roberts; Dick and Cathey Finlon; Jim and Marcia Lyons; and Karen Wolfe's parents, Katie and Alan Fox.
Joanne Davidson: 303-809-1314 or firstname.lastname@example.com; also, twitter/GetItWrite


text:
FICPAYou Are Here:
Quick CPE Search
How to Create Advanced Microsoft Excel Spreadsheets
Share Printer Friendly
Text Size: A A A A
Read on, and I'll show you how to accomplish these and several other cool Excel tricks.
Locating the Tools You'll Need to Use
The key to utilizing these features lies in Excel's Form Controls, which are accessible only from the Developer tab--and that tab isn't visible in Excel by default. To display the Developer tab, choose File > Options > Customize Ribbon. Now look in the right-hand panel, check the Developer checkbox, and click OK.
Click the Developer tab on the Ribbon, and select Insert (within the Developer tab--don't click the Ribbon's Insert tab) to view the Form Controls collection. Hover your mouse over each icon, and a text box will display its name and function. Note that the ActiveX Controls panel uses similar--in some cases, identical--icons, but they perform very different tasks. Be sure to click only Form Controls items for the purposes of following along with this article.
You can add Form Controls items to your worksheets to introduce click-and-drag functionality. An option button, for example, can run a macro when the spreadsheet user clicks it. The combo box and list box controls let the user choose items from a list, and the user can click checkboxes and option buttons to select the items they represent. The user can drag or click spin buttons and scrollbars to increase or decrease a value, too. In this article, I'll look at how to use the spin button, scrollbar, option button, and checkbox controls.
Starting With the Spin Button Form Control
Now, right-click the spin button, choose Format Control, and click the Control tab to configure the control. The 'Current value' is the starting value for the control. The 'Minimum value' and 'Maximum value' are, respectively, the smallest and largest values the control can provide (limited to between 0 and 30,000). 'Incremental change' refers to the amount by which the value changes each time the spreadsheet user clicks an arrow. The 'Cell link' is the cell in which the spin button will place its value.
Type the following values:
Click OK, and then click outside the spin button to deselect it.
To test the spin button, use its arrows: Click its up arrow to increment the value in cell A1 by 25, and click its down arrow to decrement the value by 25. Note that the value can never increase beyond 400, which is the maximum value you set for it. By the same token, it cannot decrease below its minimum value of 0.
Exploring the Additional Functionality of Scrollbars
The scrollbar works in a similar way to the spin button. Click Developer > Insert > Scroll Bar to select this control. Now drag vertically or horizontally on the worksheet to create a vertical or horizontal scrollbar. Both work the same way; they just have different orientations. Now, right-click the scrollbar, choose Format Control, and click the Control tab to set its options.
The scrollbar has all the same settings as the spin button does, but it also has a 'Page change' value, the value by which the number in the 'Cell link' cell changes when the user clicks the scrollbar. The 'Incremental change' refers to the value that is added or removed when the user clicks the arrow at either end of the scrollbar. Of course, the scrollbar also has a slider that the user can drag to change the value; this comes in handy when the user needs to make large value changes.
Both the scrollbar and spin button can produce a value only between 0 and 30,000. This might seem like a severe limitation, but you can use a formula to obtain a much larger range of values. For example, create a scrollbar, right-click it, and choose Format Control > Control.
Type the following values for its settings:
Click OK and then click outside the scrollbar to deselect it.
Next, click in cell B3 and type this formula:
Now when the user clicks the scrollbar, the value in cell A3 will always be in the range 0 to 100. The cell next to it, however--cell B3--will display a value between -50 and +50 because of the formula it contains. If you hide the value in cell A3 (by setting it to show white text on a white background, for example), the user will see only the scrollbar changing the value in cell B3.
Next Page: Using and Grouping Option Buttons
Using and Grouping Option Buttons
Option buttons operate as a group, but the spreadsheet user can select only one at a time. If you need to create multiple sets of buttons to manage different settings on a worksheet, you can place each set inside a group box to isolate it from the other sets.
To see a group of option buttons at work, choose Developer > Insert > Group Box, and then drag a group box onto the worksheet. Click Option Button, and drag to add an option button inside the group box. Repeat to add two more option buttons inside the group box.
Right-click one of the option button controls, and click Format Control. You can configure an option button to be checked or unchecked. Since only one can be checked at a time, configuring any of the buttons as checked will automatically make all of the others unchecked. In addition, whatever cell you set as the 'Cell link' for one option button in the group box will be the same for all of the option buttons. To change the label for an option button, right-click the option button and choose Edit Text.
Option buttons return a value in the 'Cell link' cell according to the order in which you created them, so the first one will return a value of 1 when clicked, the second one will return the value 2, the third the value 3, and so on. You can use the values you get from the option buttons to perform an action. For example, you might use option buttons with text reading 'Overnight', '2-Day', and 'Ground' on an invoice for a user to select how a delivery should be shipped. You could then write an IF function to make a calculation based on the user's selection.
So, if you added the option buttons in the order 'Overnight', '2-Day', and 'Ground', and if you made their 'Cell link' cell A1, you could type the following formula in any cell to return a shipping cost of $45 if Overnight is selected, $35 for 2-Day, and $20 for Ground:
Using a Checkbox to Select an Item
Each checkbox control is independent of any other checkbox controls on the worksheet, so the user can select or deselect a checkbox in isolation, without initiating a change to any other checkbox. You can set up a checkbox control to be checked, unchecked, or 'Mixed' (a gray fill that disappears as soon as the user clicks the checkbox the first time). In practice, you'll probably need to use only the Checked and Unchecked settings. Each checkbox should be linked to its own 'Cell link' cell. It will return a value of False if it is unchecked, True if it is checked, and #N/A if you set it up as Mixed.
You can test the value that a checkbox returns by using an IF function to make a calculation depending on its state. An invoice, for example, might contain a checkbox with the label 'Include State Tax'. If you link the checkbox to cell A7, and if you type the formula =IF(A7,InvoiceTotal*0.085,0) into any cell in the worksheet, that cell will contain the value from the cell named InvoiceTotal multiplied by 8.5 percent (to calculate state sales tax) if the spreadsheet user checks the checkbox, and it will contain the value of 0 if the user leaves it unchecked.
You're on Your Way to Becoming an Excel Power User
Microsoft Excel's Form Controls provide a flexible set of tools that you can harness to make data entry easier and more interactive. These controls let a user click to select items rather than having to type the value into a cell manually. They can help reduce errors, and speed up routine data entry.
This Tech Tip is brought to you by the Business and Technology Section ... IT solutions for today's CPAs. For more information and to view an archive of previous Tech Tips, please visit us here.
Do you have specific topics you would like to see covered in Tech Tips? Email any suggestions to email@example.com.