Excel Bleg

I do a lot of text manipulation in Microsot Word, and I’m really familiar with how to use Word to massage text into the form I want. I can really make MS Word sing and dance.

But I’m not as good with MS Excel. I can only make Excel skip and hum.

So I’ve got a couple of questions for any Excel Experts out there:

1) I’m constantly having to re-set the default cell alignments for every spreadsheet I touch. Invariably, I want the text in cells aligned to the top, with shrink to fit and word wrap turned ON. What I want to do is LOCK THE DEFAULTS to my preferred settings so that I don’t have to re-set the alignment every single time. There’s gotta be a way to do this, even if it means monkeying with a dll. Anybody know how?THIS PROBLEM SOLVED IN THE COMBOX. WOO-HOO!

2) I also need to find a way to insert carriage returns/paragraph marks/blank lines within text cells. Yet, as you know, hitting Enter does not produce the desired effect. Further, pasting multiple paragraphs from another app (like Word) results in the text being put into different cells. How can this be overcome? THIS PROBLEM PARTLY SOLVED IN THE COMBOX (THANKS!), SO HERE’S A CLARIFICATION: I also need to be able to paste text into Excel from Word that will go into several cells some of which contain line breaks within the cell (e.g., Cell 1, Cell 2 which has a line break in it, Cell 3 which doesn’t, etc.). I imagine that I need one kind of code to use as a cell break and another to use as a line break. Any ideas? Thanks!

¡Muchas gracias, mis amigos!

Some Changes

You may notice some subtle changes on JA.O today. Last night I finally bit the bullet and started monkeying with the templates that Typepad uses to frame the site’s content. This is not as easy as one might imagine, which is why I do it so infrequently, but it was time. In fact, at one point I had to circumvent Typepad’s proprietary code and just use a brute force HTML technique, but now it’s done.

Here’s the changes:

1) NEW AWARDS! I’ve added the Catholic Blog Awards I won in 2007 and 2006 to the site. This year I won Smartest Catholic Blog (a new category) and Best Apologetics Blog. Last year I won Most Informative and Best Blog by a Man (categories that weren’t awarded this year) and Best Apologetics.

The awards are now in the right hand sidebar (scroll down). The reason that the 2006es hadn’t been added before now is long and complex, and I won’t try your patience with it (though it has to do in part with the difficulty of revising the templates).

I want to say a big THANK YOU and CHT! to all who nominated JA.O and voted for it! I really appreciate it, and it means a lot to me that people would find the work I do here valuable enough to vote for it. That kind of support from readers really helps me keep going.

2) Correspondingly, I’ve removed the 2005 award from the banner at the top of the page. It’s now down with the other awards in the sidebar.

3) I’ve fixed the search feature that’s at the top of the right-hand sidebar. I used to use a search service that never was really spiffy and that for some time hasn’t worked at all (it seems). It had gotten to the point that I had given up using the search feature altogether and was just using Google when I needed to search my archives. So now that I was fixing the templates, I decided to chuck the old search feature and replace it with Google (customized so that it searches JA.O)! This should make it a lot easier on everyone (me included) wanting to search old entries!

4) I flipped the order of the "Recent Posts"and "Recent Comments" elements in the sidebar as well. Experience showed me that I spent more time looking down at the Recent Comments than I did looking up at the Recent Posts, since comments change more often than posts do, so I put Recent Comments on top. This should also avoid people with certain screen resolutions from having to scroll down to see the comments, again making it easier on all.

So those are the changes. Hope you like them, and thanks again!

Enjoy!

P.S. Apologies if blogging is slow today due to monkeying with the templates.

Cardinal Takes On Global Warming

Here’s what Cardinal Pell of Sydney had to say:

Global warming doomsdayers were out and about in a big way recently, but the rain came in Central Queensland and then here in Sydney.  January also was unusually cool.

We have been subjected to a lot of nonsense about climate disasters as some zealots have been painting extreme scenarios to frighten us.   They claim ocean levels are about to rise spectacularly, that there could be the occasional tsunami as high as an eight story building, the Amazon basin could be destroyed as the ice cap in the Arctic and in Greenland melts.

An overseas magazine called for Nuremberg-style trials for global warming skeptics while a U.S.A. television correspondent compared skeptics to “holocaust deniers”.

A local newspaper editorial’s complaint about the doomsdayers’ religious enthusiasm is unfair to mainstream Christianity.  Christians don’t go against reason although we sometimes go beyond it in faith to embrace probabilities.  What we were seeing from the doomsdayers was an induced dose of mild hysteria, semi-religious if you like, but dangerously close to superstition.

I am deeply skeptical about man-made catastrophic global warming, but still open to further evidence.  I would be surprised if industrial pollution, and carbon emissions, had no ill effect at all.  But enough is enough.

A few fixed points might provide some light.  We know that enormous climate changes have occurred in world history, e.g. the Ice Ages and Noah’s flood, where human causation could only be negligible.   Neither should it be too surprising to learn that the media during the last 100 years has alternated between promoting fears of a coming Ice Age and fear of global warming!

Terrible droughts are not infrequent in Australian history, sometimes lasting seven or eight years, as with the Federation Drought and in the 1930s.  One drought lasted fourteen years.

We all know that a cool January does not mean much in the long run, but neither does evidence from a few years only.  Scaremongers have used temperature fluctuations in limited periods and places to misrepresent longer patterns.

The evidence on warming is mixed, often exaggerated, but often reassuring.  Global warming has been increasing constantly since 1975 at the rate of less than one fifth of a degree centigrade per decade.  The concentration of carbon dioxide increased surface temperatures more in winter than in summer and especially in mid and high latitudes over land, while there was a global cooling of the stratosphere.

The East Anglia university climate research unit found that global temperatures did not increase between 1998 – 2005 and a recent NASA satellite found that the Southern Hemisphere has not warmed in the past 25 years.  Is mild global warming a Northern phenomenon?

While we might have been alarmed by the sighting of an iceberg off Dunedin as large as an aircraft carrier we should be consoled by the news that the Antarctic is getting colder and the ice is growing there.

The science is more complicated than the propaganda!

SOURCE.

Ash Wednesday

Here’s the law from the Church’s official legal documents . . .

From the Code of Canon Law:

Can.  1249 The divine law binds all the Christian faithful to do penance each in his or her own way. In order for all to be united among themselves by some common observance of penance, however, penitential days are prescribed on which the Christian faithful devote themselves in a special way to prayer, perform works of piety and charity, and deny themselves by fulfilling their own obligations more faithfully and especially by observing fast and abstinence, according to the norm of the following canons.

Can.  1250 The penitential days and times in the universal Church are every Friday of the whole year and the season of Lent.

Can.  1251 Abstinence from meat, or from some other food as determined by the Episcopal Conference, is to be observed on all Fridays, unless a solemnity should fall on a Friday. Abstinence and fasting are to be observed on Ash Wednesday and Good Friday.

Can.  1252 The law of abstinence binds those who have completed their fourteenth year. The law of fasting binds those who have attained their majority, until the beginning of their sixtieth year. Pastors of souls and parents are to ensure that even those who by reason of their age are not bound by the law of fasting and abstinence, are taught the true meaning of penance.

Can.  1253 The conference of bishops can determine more precisely the observance of fast and abstinence as well as substitute other forms of penance, especially works of charity and exercises of piety, in whole or in part, for abstinence and fast.

From the apostolic constitution Paenitemini by Pope Paul VI:

III. 1. The law of abstinence forbids the use of meat, but not of eggs, the products of milk or condiments made of animal fat.

2. The law of fasting allows only one full meal a day, but does not prohibit taking some food in the morning and evening, observing—as far as quantity and quality are concerned—approved local custom.

NOTES:

1. In the U.S. the conference of bishops has removed the requirement to abstain outside of Ash Wednesday, Good Friday, and the Fridays of Lent.

2. Having completed your fourteenth year means that you’ve had your fourteenth birthday (your first year is the year before your first birthday).

3. Having attained your majority means that you’ve turned 18.

4. The beginning of your sixtieth year is your fifty-ninth birthday.

5. The law of abstinence thus binds everyone who has turned 14 and hasn’t yet died and left the jurisdiction of the earthly church.

6. The law of fast binds those from 18 to 58 years old.

7. The laws of fast and abstinence do not bind those who have a medical condition that would materially interfere with their performance. Medical conditions that would interfere with fasting are fairly easy to think of (e.g., type 1 diabetes; people whose doctors have put them on a special diet that requires a certain number of calories or that requires ignoring calories). It is harder to think of conditions that would nullify the requirement to abstain, though, since protein is available from so many sources other than meat.

8. Beverages, even calorie-laden beverages (milk, OJ, coffee with cream, protein shakes) do not violate the law of fast. "Food" means solids food, not drinks (which count as "drink"), though disproportionate consumption of caloric beverages violates the spirit of the fast.

9. Non-nutritive or non-digestible things taken to curb hunger (e.g., water, dietary fiber) do not violate the law of fast. Medicine also does not violate the fast. The fast is from food (solid nourishment; technically, solid macronutrients), not other things (water, other beverages, fiber, medicine, vitamins).

10. You often hear the law of fast summarized this way: "You can have one full meal plus two smaller meals as long as they do not add up to a second meal." THIS IS FALSE. The law (from Paenitemini, quoted above) doesn’t say anything about what the two smaller portions of food add up to. What the law says that you can have "some food" twice, and "some food" is clearly less than a "full meal," but it doesn’t say anything about how much the two instances of "some food" add up to.

Obviously, the less the "some food" amounts to, the more in keeping with the spirit of fast it is, but the law does not require or encourage people to scruple over how much "two smaller meals" add up to. That’s dumb, anyway, since people do not generally eat three, equally large meals (in terms of calories or volume), making it impractical to try adding up the two lesser quantities of food.

A more helpful way of thinking of it (and a way more in keeping with the way the law is written) is to think of one full meal and two snacks, a snack being something less than a meal.

11. All the above applies to Catholics who are members of the Latin
Church. Members of other churches sui iuris (e.g., Maronites,
Chaldeans, etc.) have their own law in these areas (which is what "sui
iuris" means in Latin).

LET THE ANNUAL LENT FIGHT BEGIN!

The Peter Pan Treatment

A lot of regular JA.O readers may be already aware of this story, as it is all over the blogosphere and has been discussed on Catholic radio. It poses a number of conundrums and ethical snares concerning the proper medical care of disabled people, elective surgery, and other issues.

According to THIS MSNBC ARTICLE, a young girl named Ashley has undergone surgery, hormone treatment and other medical procedures in order to retard her growth – keep her at her present size and weight – so that caring for her will be easier.

In a case fraught with ethical questions, the parents of a severely mentally and physically disabled child have stunted her growth to keep their little “pillow angel” a manageable and more portable size.

The bedridden 9-year-old girl had her uterus and breast tissue removed at a Seattle hospital and received large doses of hormones to halt her growth. She is now 4-foot-5; her parents say she would otherwise probably reach a normal 5-foot-6.

Now, I’m not an expert in anything, so I don’t feel the need to do a whole boatload of commentary on this. I think the ethical concerns are obvious enough to anyone. I would like to see some thoughtful combox rumination on this (hopefully with the input of some medical professionals, students and ethicists), while avoiding the immediate consigning of the parents to an especially toasty corner of Hell in a knee-jerk fashion. Keep in mind that there are many parents who struggle with the issues of caring for their disabled children , even as these children become disabled adults. Keep your dog on a leash, is what I’m sayin’, and talk about the issues, rather than making personal attacks.

My first response to this story was to think about how many times my wife and I, as we watched our little ones sleeping or doing something especially endearing, wished out loud (mostly kidding) that we could "put a brick on their head" and keep them that age forever. Just stop time and keep our babies forever. It’s an impulse I’m sure we share with a lot of parents.

But that is not what kids are made for. Certainly MY OWN kids would be easier to care for if we had somehow halted their growth. Alzheimer’s patients would be less worrisome if we surgically made them all paraplegics. They could not wander off and become a danger to themselves and others, that way.

Another thought (and this is complete speculation) that occurred to me was the possibility that the parents, subconsciously, may fear that caring for their child will be more challenging as she grows, not because she will no longer be small and light, but because she will no longer be cute, cuddly and sympathetic. There can be a certain tenderness, sweetness and even playfulness in changing a baby’s diaper. The experience of changing the diaper of a fully-grown adult is rather short on rewards, unless one possesses a particularly mature and compassionate spirituality. I am not saying this is the case with Ashley’s parents, but the thought does occur that perhaps the greatest issues may be emotional and mental, rather than physical.

Just some thoughts.

GET THE STORY.

VISIT THE PARENT’S BLOG.

She’s Baaaaa-aaaack!!!

Bunches of readers (CHTs all round) e-mailed me   

THIS ARTICLE ON ALLEGED ANGLICAN PLANS TO REUNITE WITH ROME IN THE NEAR FUTURE.

It’s by our favorite Times reporter, Ruth "I’m Too Dangerously Unqualified To Keep My Job" Gledhill.

EXCERPT:

Radical proposals to reunite Anglicans with the Roman Catholic Church under the leadership of the Pope are to be published this year, The Times has learnt.

The proposals have been agreed by senior bishops of both churches.

In a 42-page statement prepared by an international commission of both churches, Anglicans and Roman Catholics are urged to explore how they might reunite under the Pope.

The statement, leaked to The Times, is being considered by the Vatican, where Catholic bishops are preparing a formal response.

It comes as the archbishops who lead the 38 provinces of the Anglican Communion meet in Dar es Salaam, Tanzania, in an attempt to avoid schism over gay ordination and other liberal doctrines that have taken hold in parts of the Western Church.

Now, to anyone with a smidge of familiarity with the Catholic-Anglican dialogue, this just screams "Total nonsense! Gledhill, once again, hasn’t the faintest idea what she’s talking about!"

The idea that there is going to be an imminent reunion of the Anglican communion with Rome–or even a sizeable schism within it that then reunites with Rome in the near future–is preposterous. Instead, what we have here is Gledhill incompetently and sensationalistically getting the story wrong.

A specific dialogue body involving Anglicans and Catholics has prepared–not a practical plan for reunion–but a preliminary meditation on the state of dialogue and cooperation between the two Churches. Nothing more.

BTW, HERE’S THE DOCUMENT IN QUESTION.

 

If Gledhill had an ounce28 grams of knowledge about how these kinds of things work, she would know that.

Or maybe she does know it and is wilfully distorting the story in order to get a sensationalized "scoop."

Either way, it’s journalistic incompetence, so take your pick.

Needless to say, the body actually publishing the document was quick to fire back.

WHAT THEY HAVE TO SAY IS WITHERING.

JOHN ALLEN GETS INTO THE ACT.

CHT?

Many readers ask what the CHT abbreviation that I use on the blog means.

Other blogs sometimes use HT for "hat tip" to readers or to other blogs that point things out.

I wear cowboy hats so . . . CHT.

NOTE: This will now be a permapost to try to help people find the answer quicker.