text:
Steve's tale of his road to enlightenment in "The Way of the Bec", whilst preparing for his first Blackpool Nationwide Medallists' competition
Published Tuesday September 16 2008 , by Steve Elsbury
Dweeb-Wap
by Steve Elsbury - this time, aged 48 and a bit, and the clock just keeps on ticking!
Steve's tale of his road to enlightenment in "The Way of the Bec", whilst preparing for his first Blackpool Nationwide Medallists' competition.
My smile clearly shows I have no idea what I am letting myself in for!
My wife Carol and I have been dancing for nearly 3 years now. As some famous dead person once said (before they died, obviously): It was the best of times; it was the worst of times. There has been laughter. There have been tears. There has been shouting. There has been walking at a time when clearly there should have been dancing. Conversely, there has been dancing at times when there should have been walking, but once my colleagues in the office told me I was doing it, I stopped. No-one wants to see that at the coffee machine. There has been friendship and camaraderie. There has been ridicule, albeit good natured. None of this will be news to you if you have read the other articles in the series, but it's worth mentioning if only to illustrate that (as another famous dead person once said)......"all life is here"!
Anyway, after many months of hard work, we have finally reached the point where competitions are approached with an attitude of "Hey, this might be fun", instead of the old "Please God - let this be over" feeling that we have come to know so well. This being the case, when we were asked if we wanted to try and qualify for the 2008 Blackpool Nationals, we decided to give it a go. We have been to the Nationals once and seen the size of that dance floor, so we already know that our 'routines' will have to have all 4 sides joined together to make just one long side of the floor at Blackpool! The annoying thing is that simply saying yes to this snapped us back out of 'fun' mode and back into 'terror' mode. After all, it's Blackpool, right? Only the Nationals, that's all. Only a comp where we will be up against the best dancers in the country (well, best IDTA dancers, anyway........OK then, best IDTA dancers in our age group........look, it's impressive - just take my word for it, ok?). Where was I? Oh yes.......Only a comp after which we will know (via the Scrutelle website) exactly where we are ranked out of all those entered.......and that's if we even qualify, which we know to be in some doubt....mainly because our studio contains mirrors - and sadly just like Shakira's hips, those mirrors don't lie!
My ballroom partner, Liesa, showing how it should be done
We overcame the original competition terrors, so there's no reason why this should be any different, right? Ditch the 'endure' and get back to the 'enjoy'? Yeah. Great theory Steve. But then again, others in our club have competed at Blackpool many times, and they did not die in the process, nor become social pariahs in any way (except...well.....OK, I'd best not say, but you know who you are :-). Anyway, let's leave this defeatist attitude behind and get on with actually qualifying!
So for several weeks, if not months, the studio rang to my cries of "Oh for God's sake - I KNOW this dance", punctuated only by Carol's "Owww, gerroff, gerroff, you're hurting!" (She still insists on putting her feet right where I want to put mine - she'll get it eventu...ouch! "OK, sorry dear. Yes, they might not realise I'm joking. I'll delete it, I promise. Yes. OK. Bye".......don't you hate it when they sneak up and read over your shoulder? Can't live with 'em, can't dance without 'em!)
The weeks rolled by like drunks on a Chingford Saturday night. The bruises from training faded, and were replaced with fresh ones. The routines became less stilted and more familiar, and we trod on the toes of a whole lot of new club dancers unlucky enough to be asked to partner us. I remember confidently leading Laura into a heel turn in the foxtrot, only to find her chasseing away. Hmmm. So it could be that Laura can't follow a lead, or it could be that I have no discernible lead. I know where the clever money is going on this one! (Shut-up Carol - they GET it already). Actually, Laura has proved a great disappointment in the dance-partner stakes. Recently we were practising the Rumba, and when we got to 'the drop', she completely failed to notice I had stepped in front of her instead of behind her, with the result that my thigh wasn't there to support her and down she went. Silly girl. Must be more observant in future. I can't imagine why this never seems to happen to her when dancing in competition with other partners - I guess she's just lucky.
My Latin partner, Becs, dancing with a purpose!
Here's an expression I never knew could be applied to dancing: 'Corner-time'. It actually doesn't mean that period in the middle of a competition when Carol and I get stuck in a corner of the floor, unable to bump-start the dance after a stalled spin turn due to the unceasing flow of traffic from 'bigger boys'. No, gentle-reader, corner time is something far simpler. It's also known as 'Dancing with Becs' (DWB). Let me explain. Our Becs is a dancer of immeasurably far greater skill, poise, elegance and experience than I - but nonetheless the instructors at Wright Rhythm clearly felt she had offended them in some way, as they saw fit to hurl her into the maelstrom that is my dancing. "You're partnered with Becs tonight, Steve" they said, as if this were no big deal! Now let me explain how it is with Becs. There are two ways any given dance, or even single step, can be done. There's her way, and then there's the wrong way. Now don't misunderstand me - that's no bad thing! It's just that where others might say "Close enough - you can work on that later" after I ruin the 17th straight attempt to do a simple step to the side, Becs simple says "Noooo - let's try again", in that very patient voice that tells you that even though your roots in 'Total-Muppet' dancing are clearly showing, she is prepared to overlook your stunning ineptitude for however long it takes to get the flipping step right.
Carol covered the actual qualifiers in superb detail in her earlier article, so I'll not revisit that topic any further - suffice to say we both qualified in both Ballroom and Latin....much to our surprise, but there you are. Turns out that equal-opportunity-employment did us a favour. Blind judges, you see. I've always been in favour.
Remember I said the 'endure' had turned to 'enjoy', and the terror had receded? Well, with a few scant months to go before competing at THE Medallist event of the year, that feeling rapidly became a distant memory. I was partnered with Liesa for Ballroom and Becs for Latin, and launched into trying to learn the Blackpool routines. Easy right? I've got medals to prove I can do this, haven't I? Luckily, there is no medal test for memory as I would have failed it. Over the coming months, we figured out the problem. I was trying to work on perfecting technique, posture, frame and expression all at the same time, when I should have first concentrated to committing the routines to muscle memory. We addressed the problem by making the routines more and more simple, until we reached a point where I was able to complete every dance I started. OK, so not necessarily while the same track was playing, but certainly during the same day, which was close enough for me.
Only one of these dancers has a clue what comes next - can you guess which it is?
There are some things that will stick in my memory though - a couple of little phrases that came up during the training, and have now more or less entered into my daily vocabulary. Let me share them with you:
My posture is appalling. Always has been and (I thought) always will be. I was round-shouldered as a lad and kind of got into the habit. Instructors have lost the will to live trying to get me to lift my head. On the odd occasion when I manage it, the shoulders come up too, instantly rendering me neckless. I had brief flashes of a good top-line, but flashes were all they were. Now Becs found this to be an intolerable situation, so told me to "stand up straight". I did so. "No", she said patiently, "stand up straight". I managed to glean another quarter inch from somewhere in my aching musculature. "OK", she said (Yippee, I thought)...."Now drop your shoulders and stop trying to stick your chest out" (Oh bugger, I thought). After what felt like hours of this, I ended up in what was deemed to be an acceptable position. The problem for me is that I wear varifocal glasses, and with my head up so straight and my neck jammed into the back of my collar, I was looking at the world through the reading bit at the bottom of the specs. Becs thought this was great. "If the world doesn't look all blurry" she said "you're not standing straight enough". Excellent. So now as well as aching shoulder and neck muscles from trying to maintain this posture all day so it become second nature, I also have aching knees and shins because I keep walking into blurry things that are in my way. Becs explained to me that it is all a mind set. "When you stand, you don't just stand straight...you stand with a purpose". At the time, this phrase just rolled over me. Little did I know it was to shape my life.
Picture the scene a week later, when Pete and Becs had popped over for Sunday lunch and I was being nagged about my posture as always. Apparently, I have to sit 'with a purpose' now too. Later, I was making coffee, when into the kitchen strolled Becs. "What are you doing Steve?". "Making coffee - what does it look like?". "Yes, but are you making coffee with a purpose?". Now the problem is that when I am pouring boiling water I prefer to have the cup in sharp focus, so making the world go blurry as I described earlier was not an option. I straightened as much as I could, and realised it was not enough. What did I do? I created a 'picture foot' - that's what. Now dancers reading this will know what this means, but for those who don't: It involves shifting all your weight to one leg while the other is stuck out to the side and slightly behind, nice and straight and with the toe pointed. The thing is, the shift in balance needed to achieve this automatically makes you stand straighter still. So there you are - how to make coffee 'with a purpose'. Clearly, this is another practice I must NOT use at the coffee machine at work. You can just imagine it, can't you? "See that bloke at the coffee machine?"........ "What, you mean the gay bloke?" .......I think not.
To say my wife Carol and I were a bit chuffed to be there would be something of an understatement.
There you have it, gentle reader. 'With a purpose' (let's say WAP, for the sake of brevity) - less of a 3-word phrase and more a state of being. It's wossname innit. Zen. That's it. Zen and the Art of Dancing With Becs With a Purpose..... DWBWAP ....'Dweeb-wap', I suppose you'd pronounce that if you really had to.
I did say earlier that a couple of phrases had stuck in my mind, and the second has all the makings of one that's really going to haunt me. Let me explain. I've always been able to pick things up quickly, and it came as a huge surprise to me that I didn't instantly become an expert dancer as soon as I started - I know that those of you who have seen me dance the 'total muppet' (see earlier article) will be equally baffled! I am just not equipped to deal with this well, so what actually happens is I get a face like a Bulldog chewing a Wasp and I sulk a lot. Paula, Gilli and Mark are used to this by now, so they either ignore it, or change the dance to one they know I am better at to lighten my mood (translation: turn me into a marginally less surly git). Have you spotted the problem yet? Yes, that's right, I am now Dweeb-wap. Does Becs use the same technique? Does she hell! "We don't have that attitude in MY lesson" is her usual reply to my falling spirits, in a similar tone to that used by my old primary school teacher oh so many years ago. If I don't instantly lighten up and get with the program, then it's followed by "Is Stevie-Weevie cwoss?", delivered in that sing-song, talking-to-very-small-children tone we all use. Put yourself in my position. Try and stay surly. Can't be done, can it? Not without looking like a total idiot anyway. The worst bit is that Liesa (my Ballroom partner) asked Becs how she deals with it when I go all quiet and moody, and Becs told her. She only bloody told her! So that'd be two of them doing it now. I'll have to leave the room in future if I want a proper sulk! Carol thinks this is very funny and has done nothing to discourage them from this heinous practice.....which just goes to show how they all stick together! Like I said earlier: Can't Kill 'em, can't dance without 'em.
So now we have poor Stevie-Weevie not allowed to get cwoss, and also wequired - sorry, required - to utilise the principles of Dweeb-wap at all times. That's enough, right? Enough for one poor sap who's doing his best to make up in enthusiasm what he so obviously lacks in talent? Nope. Nowhere near enough. Apparently it is no longer sufficient for me to simply "get dressed" when I am "about to dance". Oh no. What is required now is for me to "don a costume" as I "prepare to perform"..... A costume? .....Excuse me? ......48 years-old here and have you actually SEEN my body? .........Of course, by now I know that such objections should be voiced only in my head, so a DSI order was duly placed and eventually a "Latin Top, Man's, Basic" (LTMB) arrived. Colour me happy on opening the package to discover a garment made from Lycra and not dissimilar to a Gentleman's Victorian bathing suit. Imagine long-johns, but with short legs - OK, short-johns that'd be then. Apparently the idea is simply to make sure that it doesn't come untucked - ie trousers are worn over the top of it - however, If they sold these on Telly it would be advertised as a "Sex criminal fancy-dress". Not likely to make Today's Special Value on QVC now, is it?
Without Pete, this web-site would be largely image-less. 'Cept he didn't take this one, obviously. That would be impossible
OK, well, never mind all that, I know the new costume has to be tried on. I got both legs inserted and the whole thing bunched up around my waist before it became apparent that there was just no way it was going to fit over my torso. Oh good. More humiliation. The size ordered is insufficient for my ample frame. Now at this point Carol entered the room - doubtless attracted by my plaintive cries along the lines of "Oh for God's sake - it's too flipping small!". Do you know what her first words were? "Ahh bless - you've never worn Lycra before have you?". Well, no - strangely enough, I haven't - so how was I to know it stretches in a Tardis-like manner? After heaving mightily and getting the thing over my shoulders and zipped up - imagine my surprise to discover that far from emphasising my corpulence, this garment actually has a slimming effect. That's probably because the Lycra is stretchy and currently under pressure normally only associated with the event-horizon of a black-hole, but the end effect was slimming so I was one happy bunny. So happy was I that my normal self-preservation circuitry disengaged and I trotted off to youngest son's room to show him the effect. Bad move. I can truly say I have never seen anyone do such a poor job of stifling uncontrollable laughter. He managed the hand over the mouth bit OK, but it was the collapsing on the floor with his whole body heaving that kind of gave the game away. I suppose I should have realised this would be his attitude. He is a builder, after all!
I wandered off feeling a wee bit put out, and looking for a more sensible opinion and found older son. What I actually got from him was "Get away from me, you freak!". OK then. Lesson learned. Latin Dance-wear to be worn only in competition context. Let's be honest - wearing it down the pub is right out, no matter how thin it makes me look! The next step then was obvious, as we had medal tests on he horizon. I wore the new top. Let's be clear here: I put it on before I left the house, then I put an overcoat on top of it. Can you imagine if there has been a car crash? The Para-medics would probably have refused to treat me looking like that. Fortunately, we got to the studio unscathed and I discovered the second big advantage of "Latin Top, Man's, Basic" - I am painfully aware that if I don't stand bolt upright (WAP, remember?), my finely-honed torso slumps into a shape that might be used to frighten children, and the LTMB displays this in all it's glory. So the advantage is that it grants good posture where previously there was none! Hmmmm. Cunning plan.......LTMB worn under 'normal' clothes (WUNC)! OK, I'll be very hot, but think how great my posture will be. I'm wearing it now even as I type this. I'll probably be wearing it next time I talk to you.......well, maybe not.....but you can never be SURE of that, can you?
Becs was so disillusioned with my Latin ability that she went to audition for the country and western dancing team instead.
There can be no more humiliation now, surely? (Cue the chorus of "Oh yes there can"). It seems that in order to be a successful dancer, you have to become an Orange Person (OP). I don't mean the shade of orange known as "You'll know when you've been Tangoed" - but you ARE expected to use fake tan, and it renders you a colour that you fondly describe as "looking very natural, actually, and you'd never know it was fake tan", but that everyone else says "You're orange, man. Seriously. Yes you are. Go stand over there." Never having done this before, I had no idea what to expect but the staff in Orange-People-R-Us were very understanding as they instructed me to strip off and go stand in what was essentially a tent (I later found this is to catch the overspray), before spraying me with what looked like a paint gun. It was the work of 5 minutes, after which I was a full-qualified OP!
What I wasn't prepared for was leaving stains everywhere I went. It was like old age had come early! The idea is that you don't shower (well, you wouldn't creosote your fence when it looked like rain, would you?) and you do wear loose clothes for a fair few hours after you've been sprayed, so it gives it time to stain you properly. The downside is that it rubs off on everything. Try lying on a clean white sheet and you quickly end up with a dirty, orange sheet! This must be absolute murder for the hotels around the country near dance venues - or more accurately, for the cleaning services used by those hotels! Anyway, once I'd showered and had a proper look in a full length mirror, my honest opinion is that it looks very natural, actually, and you'd never know it is a fake tan.....and please don't feel you have to reply to this.
The closer we got to the actual event, the more my ability to dance deserted me. Poor Becs and Liesa became increasingly used to my 'lost puppy' look. (This is the one I now use when my memory of a routine deserts me. In the past, I would get angry with myself at this point, but clearly that's no longer an option for "Stevie-Weevie", so I have to go for the sympathy vote instead). Inexorably, the big weekend approached, and I was bemused to find that the abject terror I remember from my early competitions never materialised. I actually found myself looking forward to it. I know, I know, "Who are you, and what have you done with Steve?"......well, there are those who will say it was bound to happen sooner or later, but I certainly wasn't one of them!
Paula masked her feelings well on first seeing me wearing my LTBM
Now lest you think this is all about me (it is, but you mustn't think so), I'd like to point out that during all this time Carol was quietly practising with Lee, her Blackpool partner, and going from strength to strength. Able to follow a lead with no apparent problems. Able to remember routines (although clearly this is not an issue as she is able to follow a lead......now where did I put my lead?....Oh Yes, that's right - that's a bit I don't do too well!). In fact, progressing beyond me to the point where I may have to consider knobbling her in some way. It's easy with women. All you have to do is say something like "Nice dress - and what a brave colour for you!" to plant a little seed of self-doubt that with encouragement will grow into a looming tree of shattered confidence. Of course, I'd never do that, living, as I do, in something of a glass house where confidence is concerned! In my arrogance, I used to consider Carol's dancing skills as 'snapping at my heels' - now it's more a case of my watching her heels vanish into the distance! Never mind. I'll drag her back down to my level when Blackpool's done and dusted!
Right then - let's examine the facts, shall we?
* I now do most things 'with a purpose', where before I just did them any old how.
* I now own, and am not afraid to wear, what appears to be a sex-criminal's fancy dress
* I am no longer permitted the luxury of sulking
* I still can't remember my routines
* I have become experienced in kicking a wide range of partners
* I have entered the ranks of the orange people.
Yep - that's me fully qualified and ready to dance at Blackpool now. No doubt about it. Off we go then.
Carol and I had a great time and hope to qualify again next year, so we can do it all again!
.....and off we did go, driving into that part of our road map that simply says 'here there be dragons'. Yes, we are talking about the dreaded 'oop North' again. The place where the GPS stops saying "You have reached your destination" and instead simply asks "Have you lost your mind?". Glorious Blackpool - fabled land of Kiss-me-quick hats and Knicker-Bocker-Glory ice-creams. The reality is it's a 4 hour drive to get to a place where it rains horizontally. So just like every other major competition venue then! Actually, not quite the same because this time, it snowed. Now you never saw Gene Kelly perform 'Dancing in the Snow', did you? There'd be a reason for that, although clearly not a good enough reason to stop us!
We booked into the Hotel, into a room so small that the Geneva Convention would prevent you keeping prisoners of war there, behind walls so thin that privacy becomes but a distant memory and any thoughts of intimacy......well, it would take too long to get the LTBM (WUNC) off anyway! The corridors echo to the sounds of youthful exuberance and the smell of fake tan is strong in the air - not to mention the colour of fake tan being bright on the sheets, the towels, the furniture, the walls.......honestly, I have never seen so many orange people in one place. Actually, the worst is the streaky people, who have just applied it and are waiting for it to soak in, set, mature, go off or whatever it does! Some of the orange people might be accused of going a tad too far - not by me, y'understand, being newly orange myself! - but I did hear the phrase "Commando Camoflage" muttered under the breath of at least one person! Hey - whatever works for you! It's a fact that sometimes judges don't have time to judge properly. It's a fact that when they have gaps in their card for the next round, they'll mark whoever 'looks the part' - the only thing that's up for debate is exactly what part it is that you have to look. Pasty-white - bad thing! Streaky mushroom - bad thing. Mildly orange - acceptable. Natural tan from two weeks in Barbados - perfect. Now I think the dance club should provide the two weeks in Barbados - don't you?
Steve Elsbury - DWB, WAP, LTMB, WUNC, OP
PS Carol's just slapped me round the back of the head and pointed out that this is no way to end the article. Actually, it's what I intended, as it was supposed to be about getting ready for Blackpool, and not the competition itself. Never mind - Head Office has spoken, so there will be a part 2 for this article. (I can hear you groaning already!)
Disclaimer: Please note that this website is run by enthusiastic supporters of Wright Rhythm and not the principals themselves. Opinions represented here are not necessarily those of the school, teachers or specific members.


text:
Superhero: Achieving a common good
by Amy Franceschini, November 2015
This assignment uses the structure of the superhero teams Justice League and Super Friends to create individual superheroes who will work together to achieve a common good. Within this assignment students can work individually and in groups toward the collective goal of justice for all. Each individual student will develop a superhero using the provided template as a guide (Parts 1, 2). For an additional layer of cooperation and civic engagement, students can form Justice Leagues composed of their superheroes. These teams will participate in actions that contribute to the common good of a community site (Parts 3, 4, 5).
Mixed Media, performance, social practice
Fabric, paper, stickers; optional: digital camera, flip camera, paper, pencil, video camera
Download This Activity
PDF | Word Document
About Open Studio
Designed by practicing artists, the Open Studio classroom activities aim to connect high school teachers and students with key ideas and issues in contemporary art. See all of the Open Studio activities.
Mayor Antanas Mockus
Part 1: Superhero/Create a Superhero
Each student creates a superhero.
Students develop a 10-minute presentation of their Superhero Template.
Students form Justice League groups.
Each student identifies a problem that his/her superhero can fight to solve or identifies a common good that they can protect. They will use the Superhero Template (below) to guide their inquiry. For an in-class example, use Superman or another well-known superhero.
Examples from real life include a superhero figure Chilean students have used in the street to fight for educational reforms and a mayor in Colombia who dresses as Super Citizen to vanquish wrongdoing and promote humanity.
Chile superheroes dance for education reform
Colombia's Antanas Mockus hopes his Super Citizen past will help make him president
Superhero Template
Motto/Theme/Slogan:
Icon/Symbol:
Origin/Backstory:
Definition of the common good:
Weakness:
Archenemy:
Costume (include possible influences, such as traditional or ritual costumes):
Transitional architecture/Location:
Transitional portal:
Superpowers:
Street persona/Alter ego:
Describe a scenario where your superhero defends the common good.
What is the action he/she/it takes?
Is there any evidence left behind from the action (an icon or mark)?
Vehicle (if your superhero doesn't fly, you may need this to get around):
Home base (the Justice League has the Hall of Justice; Batman has the Bat Cave):
Give a 10-minute presentation of your superhero (audiovisual support may include YouTube clips or comic book pages, for example).
If completing Parts 3–5: During the presentations seek thematic threads that can help you form Justice Leagues made up of 3 to 5 classmates. The goal is to form interest groups that will work toward a similar common good. These groups will support each other in their endeavors much like the Super Friends do.
Part 2: Superhero/Develop Individual Identity
Develop an icon, logo, or coat of arms for your superhero. For example, Superman has an S on his chest. What would be on your chest?
Design a costume. Start with a sketch and then create a real costume using fabric, paper, stickers, and any other materials you have on hand.
Part 3: Justice League/Group Site Research
A community provides a stage for cooperatively working toward the common good on social, political, and economic levels. This section of the assignment takes the class off-campus and into the world. Each group will visit a section of the city, town, or region. Prior to the visit students will research their site and form a line of inquiry for the visit. Groups will devise a method for researching the site and people, whether through interviews, observation, or video, inviting community members to class to talk about what they do, engaging in a volunteer day, etc.
Questions they may consider include:
What are the values of this neighborhood's residents?
What challenges do they face?
What could help them reach their goals?
What could a superhero remedy?
Engage in direct contact with people.
Develop interview techniques.
Use media to capture primary research.
Inform research with real-world situations.
Justice League creates a name for their group based on their site observations and group discussions.
For the Teacher
Choose a central location where all groups will meet before and after their site visits, such as a town center or public library.
Divide center of city, town, or region into 4 quadrants. Each group/Justice League gets a section.
Students can use qualitative or quantitative research methodologies, such as interviewing community members, creating a journal of observations, or counting instances of interesting phenomena.
Part 4: Justice League/Group Site Research Presentation
Present results from site research, considering the 4 questions from Part 3.
Use media to present qualitative research, including interviews and observations.
Present problems or concerns that arose.
Get feedback from the class and instructor on how to work within the site.
Develop list of problems and solutions.
Propose an action, providing ideas about where and how it could be completed.
Part 5: Justice League/City Intervention
Justice League takes to the streets, acting as task force. They will perform an action that contributes to the common good and will document that action.
To create an action, performance, or situation that will promote their determined common good.
Present Final Projects
Prepare documentation of action, performance, or situation to share with the rest of the class.
Consider having a superhero meet-up, gallery exhibition, or event so that students can share their projects with others outside the class.
Suggested Reading/ Listening
Wikipedia entries for superhero, justice and common good.
Pericles's Funeral Oration
Art, Truth + Politics, Harold Pinter, Nobel Peace Prize Acceptance Speech. 2005
A Model of Christian Charity, by John Winthrop
Selections from Second Treatise of Civil Government, by John Locke
Barack Obama's 2004 Democratic National Convention keynote
Suggested Collaboration
If possible, invite a political science teacher to suggest some readings about the common good and justice. Have the students read the readings and invite the political scientist to discuss the readings in person.
Amy Franceschini
Photo: Andrew McKinley
Born in 1970 in Patterson, California Currently lives in San Francisco, California Amy Franceschini is an artist and educator who uses various media to encourage formats of exchange and production, frequently in collaboration with other practitioners. An overarching theme in her work is the perceived conflict between humans and nature. Her projects reveal the history and currents of contradictions related to this divide by collectively challenging systems of exchange and the tools we use to "hunt" and "gather." Using this as a starting point, she often provides a playful entry point and tools for an audience to gain insight into deeper fields of inquiry — to not only imagine but to participate in and initiate change in the places we live. Amy founded the artists collective and design studio Futurefarmers in 1995 and cofounded Free Soil, an international artists collective in 2004. Futurefarmers' design studio serves as a platform to support art projects, an artist-in-residence program, and research interests. She is currently searching for land to house Futurefarmers and to create a permanent agricultural land trust. Amy's solo and collaborative works have been exhibited domestically and internationally at institutions including the Walker Art Center, ZKM, the Whitney Museum of American Art, the Museum of Modern Art, and Yerba Buena Center for the Arts. She received her BFA from San Francisco State University and her MFA from Stanford University. She is currently a visiting faculty member at California College of the Arts and at Stanford University. She is the recipient of Artadia, Cultural Innovation, Eureka Fellowship, Creative Capital, and SFMOMA SECA awards.
Open Studio: We Are the Space We Live In: Analyzing your environment
Open Studio: Telling Stories with Masks
Open Studio: Video Portrait: Capturing a live interview
Open Studio: Inventing Places: A closely examined environment
Open Studio for Families
Open Studio: Look, Record, Explore: Drawing small things around you
Open Studio: Supergraphics! Going Big Together

redpajama_set_name: RedPajamaCommonCrawl


Image Title: Dust Mops For Hardwood Floors Microfiber Floor Home Depot Latest With Mop Remodel 12. Post Title: Dust Mop Home Depot. Filename: dust-mops-for-hardwood-floors-microfiber-floor-home-depot-latest-with-mop-remodel-12.jpg. Image Dimension: 620 x 413 pixels. Images Format: jpg/jpeg. Publisher/Author: Joe Kunze. Uploaded Date: Thursday - May 10th. 2018 22:39:41 PM. Category: Architecture. Image Source: decoist.com. Hardwood Floor Regard 18. Latest Mop Cleaning Dust Duster Mops The To 19. Images In With Home Spray Design Libman 922 Floors 11. Plan Depot Microfiber 16. 1 15. Flooring 076 Remodel Info Flat Brooms Quickie 4. For UPC Tools Viticoltura 13. Regarding 24 0. Within Decorations Pertaining 071736009223 5. Bona Decor Wood 10.


We spoke to a young woman recently that has gone through a very tough time in the past few years. She and her (now) ex spouse could not keep up the payments on their home and lost it under power of sale by the mortgagee. The house was sold at a substantial loss and as the mortgage was guaranteed by Canada Mortgage and Housing Corporation the debt now rests with them. She also has a few credit card debts and other miscellaneous debts.
She and her spouse separated and she is now struggling to live on social assistance while raising a young family.
Creditors would have a hard time trying to collect debts from her as they really have no means of collection under her current circumstances; she doesn't have wages, so they can't get a wage garnishment. However, she received notice from CMHC that they will start to redirect any income tax refunds or GST credits against the shortfall from the sale of the house.
CMHC, or any government agency, has the ability to request that Canada Revenue Agency send GST or any income tax rebates to them to offset against any debt owing to the agency.
In this case, her debt is large and her tax refunds and GST credits are small it would take years for this debt to be repaid, especially as interest is accumulating at an alarming rate.
She needed a fresh start after all the stress she has been through in the past few years and would really like to be able to raise her family without this old problem hanging over her head.
After contacting our office, we invited her to have a free consultation with one of our professionals to discuss her options. We reviewed the options of filing bankruptcy or making a consumer proposal. In her case, since her income was low a bankruptcy made the most sense.
Every person's situation is unique. We meet with people every day who's debt situation is different and they need a solution that fits their finances. If you are struggling with a debt owed to the government, and have had your GST or other tax refunds seized, contact us for help.
Debt Free in 30 means we can help you eliminate your debt. If you need debt help, book a free consultation with one of our licensed debt experts today.


At Cynthia L. Graves, DDS, we're known for our extra gentle touch to help even our patients with dental anxiety feel comfortable and safe. At times, a patient with certain needs—such as sensitive teeth, a strong gag reflex or a very low pain threshold–will select sedation dentistry to achieve a truly relaxing experience throughout their treatment. Call us for details!
Dr. Graves is accredited by the Texas State Board of Dental Examiners to provide sedation dentistry, a carefully regulated discipline, right here in our Austin, TX facility.
Oral Conscious Sedation: his level of sedation often comes in the form of a small pill that can be taken just before your visit to the dentist. You will feel the benefits of gentle relaxation set in before any dental treatment begins, and will still be aware of your surroundings.
Nitrous (Laughing Gas): Nitrous oxide is a commonly used form of sedation dentistry that can be gently inhaled to provide effortless relaxation for a wide range of dental treatments. Dentists everywhere continue to use nitrous sedation to calm dental anxiety and create a positive and safe environment for patients both young and old.
IV Sedation For Oral Surgery: If you require more complex dental care including oral surgery, you may be a good candidate for IV sedation. This is a deeper level of sedation, where it is not uncommon to doze off during treatment while our team carefully monitors your health during treatment. Patients typically have little to no memory of the procedure within 24 hours after their experience with IV sedation dentistry.
If you are considering sedation dentistry to ease your dental experience, the most common method of sedation is nitrous oxide (commonly referred to as laughing gas). Nitrous oxide is very easy to administer and lasts just long enough for your treatment. You'll feel like yourself again by the time you leave our office.
For deeper levels of sedation, ask us about oral sedation (in the form of a pill) or intravenous (IV) sedation if you require oral surgery.
Is Sedation is Right for You?
If you believe you are a nervous or sensitive patient, sedation dentistry may be the answer you've been looking for. It is also beneficial for people who require extensive dental work because we're able to take more time to perform a treatment, thereby reducing the number of visits required to complete the work.
Your eligibility for sedation dentistry will depend on a few factors, such as health history, current dental condition and specific needs. The best way to know if you're a good candidate for sedation dentistry is to talk with Dr. Graves. Call our office at (512)-258-8001 today to explore your options with sedation dentistry.


text:
See what Buhari says about Supreme Court judgment on Imo elections
In congratulating the new governor, the president urged Uzodinma to promote the ideals of the APC and unite the state by running an inclusive administration.
President Muhammadu Buhari has commended the Supreme Court for the `courage and perseverance' to return Sen. Hope Uzodinma of the All Progressives Congress (APC) winner of the March 9, 2019 governorship election in Imo.
The president made the commendation while reacting to Tuesday's Supreme Court judgment that sacked Emeka Ihedioha of the Peoples Democratic Party (PDP) as Governor of Imo State and declared Uzodinma winner.
President Buhari said: "The road to justice may be long and tortuous, but it is the best path for anyone aggrieved.
"Under the new administration, a new journey to build a new Imo with new energy is about to begin. In this outcome, it is the people of Imo State who have emerged victorious."
News Agency of Nigeria (NAN) reports that the Supreme Court in a unanimous judgment on Tuesday sacked Ihedioha as Governor of Imo State, and declared Hope Uzodinma winner.
A seven-man panel of the apex court in its decision held that Ihedioha did not win a majority of votes cast at the March 9, 2019 governorship election.
In the Judgment delivered by Justice Kudirat Kekere-Ekun, the court accordingly ordered the INEC to withdraw the Certificate of Return issued to Ihedioha and issue a fresh Certificate of Return to the candidate of the APC on grounds that he won majority of the lawful votes cast at the election.
The court also ordered the immediate swearing in of Uzodinma as the lawful winner of the March 9, 2019 governorship election in Imo State. (NAN)
Tags: IMO electionsNigeriaPresident Muhammad Buharisupreme court
JAMB Begins Registration Of 2020 UTME And Direct Entry Candidates
2020 Most Exciting Hollywood Movies To Look Forward To
Breaking News: LG Chairman slumps, dies
I'm Asari (Episode 26): Me, My Mother and Women Affairs


Tomatoes are very healthy thanks to the lycopene, but they also taste amazing when you cook them in a cream soup with a pinch of red pepper and garlic. And herbs, croutons, bread rolls or literally anything you would ever want to put in a cream soup, it's so versatile. And because it's summer time now, you can even let it chill and serve it cold. How cool is that?


David loves his son Absalom. But when Absalom returns, he lives in a house down the street and David does not even see him.
The question at the heart of this story is: What will David do when his rebel son returns? Will he punish or will he pardon? The answer is that he does neither.
David shows mercy to Absalom. He does not enforce the penalty of the law that condemned his son. But Absalom is not pardoned. There is no reconciliation. Why?
But there is this big difference: David cast himself on the mercy of God, and looked to the provision God would one day make through his Son. He humbled himself before God in repentance. Absalom showed no sign of repentance whatsoever.
Are there sins you've overlooked in yourself without turning to God in repentance?


Twenty-one years ago, Tom Allen was recovering for a heart attack and spending his days at home alone.
"I was feeling sorry for myself and wasn't really doing anything else," said Allen, 73, of Port Clinton.
Then his neighbor and some friends invited him to the Men's Ecumenical Prayer Breakfast at Trinity United Methodist Church. The weekly fellowship meeting was the change he needed.
Since then, he has regularly attended the non-denominational gathering. He joined more than 100 locals and clergymen this morning at Magruder Hospital to celebrate the breakfast's 50th anniversary.


Great bit of kit, it produces big clouds and has a range of adjustable parameters to personalise your vaping experience. Whether you prefer the Mouth to Lung or Direct to Lung technique, the option of either of the 2 supplied coils has this covered to. Competitively priced, it has the look and feel of a more expensive device.
Graphically attractive, informative, and user-friendly, this invaluable Web site focuses on the great brand such as Joytech, Eleaf, Wismec, Tecc. you feel as if you are in good hands and you know that you will be able to find anything you need on this site. If you want the latest and greatest vape gadgets for the affordable prices and fantastic customer service, give WILSONSVAPES big go. I'm very, very satisfied customer.


APPLE OATMEAL MUFFINS — These hearty muffins are loaded with oats, apples and fall spices. Perfect for packing in lunches, quick breakfasts or after school snacking.
I love baking with apples! Especially at this time of year. And I must say, these Apple Oatmeal Muffins are some of the tastiest muffins I've tried in quite awhile.
The combination of apples, oats and spices is just perfect, although I find an extra dash of cinnamon never hurts! As an added bonus, the whole house smells lovely while they bake.
I used a combination of all-purpose and whole wheat flour, but you could certainly use all white or all wheat, depending on your tastes and what you have on hand.
This recipe definitely lends itself well to healthier options, like all wheat flour, or subbing applesauce for the oil. There is already applesauce in the recipe, but you could omit the oil and use extra applesauce too.
If you prefer, you can bake this recipe up in a 9×5-inch loaf pan–just be sure to increase the cooking time. Mini loaves would be great too!
These muffins are a perfect fall treat. They were certainly a big hit at my house!
Mornings can be so hectic, so we're always looking for delicious grab-and-go breakfasts, and these hearty apple muffins are a new favorite with the whole family. I hope you love them as much as we do!
These hearty muffins are loaded with oats, apples and fall spices. Perfect for packing in lunches, quick breakfasts or after school snacking.
In a large bowl, mix together the sugars, eggs, oil, vanilla and applesauce.
In a separate bowl, mix together the flours, baking powder, soda, salt and spices.
Mix the dry ingredients into the wet ingredients in the bowl. Stir in the oats, apples, and nuts.
Who Dished It Up First: Adapted from King Arthur Flour.
Okay, yum. Might have to make these for Thanksgiving breakfast.
We'll eat these while watching conference this weekend! Perfect brunch food.
These look and sound absolutely wonderful. I just bought a bunch of apples from a local produce stand and I can't wait to use them on these muffins.
These muffins look right up my alley!
I made 4th batch of these yesterday, truly delicious! So moist, so yummy and full of fruit. I skipped the pecans, added cranberries to last two batches and they just vanish into thin air. I think I better make the 5th batch today!
This recipe is truly a keeper, I don't even need to look at it anymore while making them!
These look fabulous! Muffins are one of our go to breakfasts for school days. Pinning!
This looks great! My kids LOVE apple/cinnamon anything, so I am definitely pinning this! Stopping by from the daily blog boost.
Made these today – truly delicious and made my house smell like autumn. Thank you!
Made these today, loved them!!! Excellent recipe, thank you.
Hi Danielle! We are writing you from Miami Beach. We just tried your recipe and it's delicious! We are amazed with it. We just wanted to let you know. As new neighbors, we found something to bond with! Thank you so much!!!
Do you know if I could substitute coconut oil for the vegetable oil? Has anyone tried this?
I haven't tried it Courtney, but if you do I'd love to hear how it turns out!
Oh. I am dumb. Sad part is, I read the recipe 3 times.


violence expressed shows his inability to control his emotions. If your messenger find him not there, seek him I th other place yourself. Authors write individuals into their works to show a complexity of views on many variations of topics. tags: Shakespeare Hamlet Essays Powerful Essays 1370 words (3.9 pages) Preview These results are sorted by most relevant first (ranked search). In the play, Hamlet is depressed to the point of mania. The reader can see that Shakespeare meant to create Hamlet to be such a complicated character.
He lets his anger take over and he takes out his rage on Gertrude. tags: Hamlet Shakespeare Free Essays 1750 words (5 pages) Preview - Romans 12:19, from the NIV Bible, states Do not take revenge, my dear friends, but leave room for God's wrath, for it is written: It is mine to avenge; I will repay, says.
If it be now, tis not to come; if it be not to come, it will be now; if it be not now, yet it will come. Each director's interpretation of the enseamed bed scene show different levels of psychopathy within Hamlets mind. The reason for this is because it kept him away from his friend and family and then eventually it started to make him go crazy and make the wrong decisions or so he wanted it to seem. But ultimately it is the memorable scenes in which make the movie ones favorite. However, how can Hamlet truly have admired Ophelia if he treated her with such disgrace and nonchalance. Better Essays 752 words (2.1 pages preview - The thought of knowing the secret.your fathers murderer must be extremely agonizing. tags: Hamlet Essays Strong Essays 1222 words (3.5 pages) Preview - As you begin to read and understand the tragedy of Hamlet, you should begin to see how the many characters affect what happens as the story progresses. By seeking revenge, it makes them the villain as well as the victim. One of the possible reasons for this play's popularity is the way Shakespeare uses the character Hamlet to exemplify the complex workings of the human mind.


Beanies: Hempy's offers 11 different beanie styles in a wide range of color combinations using eco yarn that requires no chemicals or new dyes to create its vibrant colors. Hempy's seamless crown construction increases the durability and comfort these beanies.
Fedora: Made with 100% hemp materials or our sustainable hemp and organic cotton blend, Hempy's fedoras can be dressed down with a pair of Hempy's jeans or used to compliment a more formal outfit. Available in brown and natural corduroy, herringbone black, or natural "straw weave".


Great picture of Daryl Dixon of The Walking Dead, huh?
Yeah, that's not Daryl. Isn't she great? You read that right. She. That's Marta Mendes, a female Daryl Dixon cosplayer. She kindly agreed to answer our baker's dozen of questions. Let's get right to them.
I'm from Portugal and I have never gone far to cosplay. It will be my first time to attend Walker Stalker Comicon London next month. But if I had to…who knows?
Yes. I started going to cons just as a fan. Then I started to go as a vendor to sell handmade stuff that I make. Then one day I decided to start cosplaying.
How and when did you realize you could look like Daryl Dixon?
Well, it was at a con last year, when I was cosplaying Negan (ironic 😃 ) and a friend of mine who was cosplaying Beth asked me if I was capable of cosplaying Daryl. So I tried and did a makeup test. When I saw the result in the mirror, I was surprised! That's when I decided I had to cosplay Daryl Dixon.
Have you met any other female Daryl Dixon cosplayers?
I have seen female Daryl's, but I have never seen a girl performing cosplay the way I do, only men.
I always liked to dress myself in costumes for Halloween and Carnival. I had theater classes at school, so to me, cosplaying was something I just felt that I needed to try.
Well, it depends on the character, you know. The hardest one I've ever done was Edward Scissorhands. As for Daryl, it was easier because he's very "natural" the way he acts.
No, unfortunately I haven't met him yet but I hope to get to know him or at least see him at Walker Stalker Comicon London. He has already noticed me on Instagram by liking some photos and even commenting. This picture turned viral!
Have you met other The Walking Dead cast? What was their reaction to you?
I never met any cast, unfortunately. I did see Lennie James live at a Comicom in my country from a distance.
Tough question. Between 5-8, it depends on the cons.
Is cosplaying just a hobby?
LOL Weeeelllllll, to be honest, being Daryl here has been some of the craziest cosplay interactions I've ever had! It's very funny because I'm a woman and most of the comments or situations are coming from other women! I could be here all day giving examples but I'm going to tell you two or three so you can get an idea.
Second, at a convention two girls almost started a fight to see which one would take a picture first and to see which one was getting closer to me. lol This was after like five photos I'd taken with them in different situations on that day. Yes, they asked me five times during the whole day to take a picture. lol I can't say if they really liked the cosplay or if they were confused.
Right now I'm working on some new cosplays, such as Tonto (Lone Ranger) or Rufio (Hook).
This one is a tough one. Five years ago someone asked me the same question and at that time I was a nobody, like Daryl said he was. lol I couldn't imagine myself in a "normal" future like everyone else, with a job, family, etc. But after five years I just stopped and realized what I had done in those five years. Was I still the same person? Did I have the same life? Was I the same "nobody?" I looked back and saw change, hope, a new life! I start cosplaying in September, 2014; I ended up my studies; I made new friends; I've seen Johnny Depp live, (yes, one of my to-do list); I saw the DeLorean from Back to the Future (because we all had those dreams when were kids right? lol); Norman Reedus noticed my work on Instagram (also a to-do list, get Norman Reedus to notice me lol); I got a job; I saw Lennie James from The Walking Dead live; I'm going to London to the Walker Stalker Comicon (one of the cons I've always wanted to go to!); and I got into a poll for the Spacie awards (which I was very excited about because I'm not a professional, and being in the poll was and still is amazing.) I can't express how I feel about the support from all around the world from all the people. THANK YOU!
AND I might have something to show you all: https://www.instagram.com/p/BPAbegBBjjB/ (it's just a teaser). So, how do I see myself in the future? Happy, no matter what is there waiting for me. If it's meant to be, so it will be. Everything happens for a reason!


10 August 2010, at 1:00a.m.
JAPAN & SPAIN - Researchers from the Spanish Institute of Oceanography (IEO) and the Japanese Kinki University have teamed up to working on domesticating the bluefin tuna. and other scombroid fish such as Atlantic bonito.
Over the last 10 years the researchers have been co-ordinating various research projects, three of them within the Framework Programmes of the European Union.
The team has been successful in increasing knowledge of reproduction, larval rearing and feeding of the species.
They have, in particular, found a great deal of information out about life cycle of the Atlantic bonito, as well as the development of environmentally friendly forumlated diets.
IEO has hired the renowned Japanese researcher, Manabu Seok. This was made posssible through the signing of an agreement between the Minister of Agriculture and Water, Antonio Cerda and the rector of the Universidad Politecnica de Cartagena (UPCT), Felix Faure, with the heads of several savings banks in the Region of Murcia.


text:
Q: Excel Formula or VBA: Find match's address in separate table with 2 column criteria - No helper columns I need help with formula structure,
I have 2 tables. I would like to find a match where column a & column b equal and get the address in table 2. They will be unique entries. So for example:
ProjectInfoTable :
         A      |       B      |     C     |
  ------------------------------------------
1 |     Name    |    Company   |  Project  |
  ------------------------------------------
2 | Chris Evans |     Apple    |   Info    |
  ------------------------------------------
3 | Chris Evans |    Google    |   Info    |
  ------------------------------------------
4 | Bill Gates  |  Burger King |   Info    |
  ------------------------------------------

ClientInfoTable:
         A      |       B      |   C   |   D
  -------------------------------------------
1 |    Client   |    Company   |  Age  |  Sex |
  -------------------------------------------
2 | Chris Evans |     Apple    |   12  |   M  |
  -------------------------------------------
3 | Chris Evans |    Google    |   17  |   M  |
  -------------------------------------------
4 | Bill Gates  |  Burger King |   98  |   F  |
  -------------------------------------------

I would like to be able to, while in 'ProjectInfoTable', get the address of the matching Name & Company client in 'ClientInfoTable'
The trouble I'm running into is there could be a thousand different Chris Evans out there, so VLOOKUP isn't good here. I need to make sure it's the same Chris Evans in 'ClientInfoTable' that I'm looking at in 'ProjectInfoTable' by cross-referencing their companies
I can get the address no problem if I only search it by name:
=ADDRESS(ROW(INDEX(ClientInfoTable,MATCH([@[Client]],ClientInfoTable[Client],0),1)),COLUMN(INDEX(ClientInfoTable,MATCH([@[Client]],ClientInfoTable[Client],0),1)),1,1,"Clients")

but I need to add an additional condition of their companies so now that formula is useless.
Any ideas out there? I don't want to use hidden columns, or 'helper columns'
I will except VBA or formula based answers. I'll even reward a bounty to anyone who can provide both, assuming that the data will always be dynamic ranges, and then gives a good explanation of your code/formula. I am here to learn, I am not a copy/paste type of user, explanations go a long with me.

A: Formula:
Here's a formula only solution with no hidden/ helper columns and no array formulas:
=ADDRESS(
    ROW(
        ClientInfo
    ) - 1 +
    MATCH(
        1,
        INDEX(
            --INDEX(
                ClientInfo[Client] = $A5,
                0
            ) *
            --INDEX(
                ClientInfo[Company] = $B5,
                0
            ),
            0
        ),
        0
    ),
    COLUMN(ClientInfo)
)

Components:
a --INDEX(ClientInfo[Client]=$A5,0) - returns a boolean array for as many matches there are for e.g. Chris Evans in ClientInfo[Client]. In the example below this will be {TRUE,TRUE,FALSE,FALSE}. This is then cast to array of integer with the double unary operator to leave {1,1,0,0}
b --INDEX(ClientInfo[Company]=$B5,0) - same thing as a e.g. Apple in ClientInfo[Company] in the example is the array {TRUE,FALSE,FALSE,TRUE} - which is then cast to {1,0,0,1}
c INDEX(a*b,0) - multiples elements 1..n of array a with elements 1..n of array b. In our example this results in {1,0,0,0} and at this point you have identified your matching composite key for Chris Evans and Apple as being the 1st row of ClientInfo
d MATCH(1,c,0) - gets the index of the 1 in the array which in our example of Chris Evans and Apple is 1. You mentioned They will be unique entries so I don't think we have a problem here.
e ROW(ClientInfo)-1+d -  I defined ClientInfo as a Table/ ListObject with a range of A8:D12 but the reference is giving back A9:D12 which seems to be the way it works the named ranges for Tables/ ListObjects. So we need to deduct one from the ROW of that range to get the start of the offset; then simply add the result of d.
f ADDRESS(e,COLUMN(ClientInfo)) - returns the cell address of e and the first column of ClientInfo table.
Example:

VBA:
Using the example above, the VBA method will do the following:

*

*Assume no match found

*Iterate the rows of the table

*Get the candidate values and check against the inputs for the columns referenced

*If both match then quit the loop returning the address

The code:
Option Explicit

Sub Test()

    MsgBox GetAddressOfKey("Client", "Chris Evans", "Company", "Apple", "ClientInfo")
    MsgBox GetAddressOfKey("Client", "Chris Evans", "Company", "Google", "ClientInfo")
    MsgBox GetAddressOfKey("Client", "Bill Gates", "Company", "Burger King", "ClientInfo")

End Sub

Function GetAddressOfKey(col1 As String, val1 As String, col2 As String, val2 As String, strTable As String) As String

    Dim lst As ListObject
    Dim lr As ListRow
    Dim strAddress As String
    Dim strCandidate1 As String
    Dim strCandidate2 As String

    strAddress = ""
    Set lst = ActiveSheet.ListObjects(strTable)

    'iterate rows
    For Each lr In lst.ListRows
        'get candidate values
        strCandidate1 = Intersect(lr.Range, lst.ListColumns(col1).Range).Value
        strCandidate2 = Intersect(lr.Range, lst.ListColumns(col2).Range).Value
        'check against inputs
        If strCandidate1 = val1 And strCandidate2 = val2 Then
            strAddress = lst.Range.Cells(lr.Index + 1, 1).Address
            'quit if we find a match
            Exit For
        End If
    Next lr

    'return
    GetAddressOfKey = strAddress

End Function

PS I was hesitant to provide the VBA answer as well as you already accepted a decent answer. However, I have a slight preference for doing this without updating the UI although I agree the AutoFilter method is good enough. HTH

A: you could use AutoFilter():
Option Explicit

Sub main()
    Dim rng As Range

    With ActiveSheet.ListObjects("ClientInfoTable").Range '<--| reference 'ClientInfoTable' range
        .AutoFilter field:=1, Criteria1:="Chris Evans" '<--| filter it on its 1st column with "Chris Evans"
        .AutoFilter field:=2, Criteria1:="Google" '<--| filter it on its 2nd column with "Google"
        If Application.WorksheetFunction.Subtotal(103, .Resize(, 1)) > 1 Then
            Set rng = .Resize(.Rows.Count - 1).Offset(1).SpecialCells(xlCellTypeVisible).Cells(1, 1) '<--| if any filtered cells other than header then set the range corresponding to upleftmost filtered cell below the headers row
            MsgBox "Found at " & rng.Address
        End If
        .AutoFilter '<--| show rows back visible
    End With
End Sub

A: One way to approach your problem is to use the SQL support in Excel VBA via ADODB. This Microsoft article explains how to do this.
Using the SQL support, you basically have two options: either you write a functions in VBA that returns the (first) value for a given name and company from the ClientInfoTable, using a SELECT statement, or you write a sub in VBA that directly inserts the values for all row in ProjectInfoTable wherever you need them, using a join between the ProjectInfoTable and the ClientInfoTable on the name and the company.

A: You can also use the function I wrote.Put it to any module in the file where you want to use:
Option Compare Text
Option Explicit
Public Function doubleMatch(criteria1 As Range, criteria1_Range As Range, criteria2 As Range, criteria2_Range As Range) As Long
Dim crit1 As Variant, crit2 As Variant
Dim crit1_ARR(), crit2_ARR() 'Arrays where criteria ranges are stored
Dim i As Long, j As Long
Dim u1 As Long, l1 As Long

crit1_ARR = criteria1_Range.Value2
crit2_ARR = criteria2_Range.Value2
crit1 = criteria1.Value
crit2 = criteria2.Value

doubleMatch = -1
'checking if ranges have the same height
If (UBound(crit1_ARR) <> UBound(crit2_ARR)) Then
    GoTo endFunc
End If

'checking if ranges are one col wide
If (LBound(crit1_ARR, 2) <> UBound(crit1_ARR, 2)) Then
    GoTo endFunc
End If

If (LBound(crit2_ARR, 2) <> UBound(crit2_ARR, 2)) Then
    GoTo endFunc
End If

l1 = LBound(crit1_ARR)
u1 = UBound(crit1_ARR)

For i = l1 To u1
    If (crit1 = crit1_ARR(i, 1)) Then
        If (crit2 = crit2_ARR(i, 1)) Then
            doubleMatch = i + Abs(l1 = 0) * 1
            GoTo endFunc
        End If
    End If
Next i

endFunc:

End Function

Example of usage:

In case of error it returns -1; otherwise it returns number of row where it matches.
If you want the full address, you can use this function together with ADDRESS and MATCH functions:
=ADDRESS(doubleMatch(H2;A:A;I2;B:B);MATCH("Client";A:A;0))

A: You can combine VLookUp with Choose to have more than one criteria. In your example:
=VLookUp(A1&","&B1, Choose({1.2}, ClientInfoTable!A1:A4&","&ClientInfoTable!B1:B4,ClientInfoTable!C1:C4), 2, False)

This is a matrix formula so you have to close it with Ctrl+Shift+Enter.
What happens is the following: the choose-function chooses the first and second value that it is given (that's what the first argument {1.2} says). As this is a matrix formula you get not only one pair of values but one for each row. In this example you get a matrix:
A-----------------------|B----------
Chris Evans, Apple      |12
Chris Evans, Google     |17
Bill Gates, Burger King |98

This is the matrix you can now use for VLookUp.
You should make sure that the delimiter (comma in this example) does not occur in your data.
If you only need the address and not the actual values, use the function Match instead of vlookup:
=Match(A1&","B1, Choose({1.2}, ClientInfoTable!A1:A4&","&B1:B4,ClientInfoTable!C1:C4))

This returns the row the corresponding set is in within the given matrix. If the matrix does not begin in row 1 you have to add the matrix-position.

A: Create a VBA function that takes the clientname and company as string arguments - then loops through the clients table and return the address if found. Below code will return "Not found#" if there is no match
Option Explicit
Option Compare Text
Public Function SearchAddress(clientName As String, company As String) As String
    Dim x As Integer
    Dim shtClients As Worksheet
    Set shtClients = Sheets("Clients") 'Clients = name of the sheet with ClientTableInfo
    x = 2

    'loop through the clients table searching for the row where the clientname and companyname is what is supplied to the function

    Do
        'Column A has ClientName of ClientTableInfo
        'Column B has companyName of ClientTableInfo
        '.............
        'Column E has Address of ClientTableInfo <-- our search target
        If shtClients.Range("A" & x).Value = clientName And shtClients.Range("B" & x).Value = company Then
            SearchAddress = shtClients.Range("E" & x).Value 'column E has the address in the clients info table
            Exit Function
        End If
        x = x + 1
    Loop Until x > shtClients.UsedRange.Rows.Count
    SearchAddress = "Not found#"
End Function

To use this function import the code into a macro workbook as a VBA module (remember to enable macros). Then type the formula into an cell like a normal excel formula
=SearchAddress(ProjectInfoTable[@Name],ProjectInfoTable[@Company])

or
=SearchAddress(A1,A2)

redpajama_set_name: RedPajamaStackExchange


Ho, ho, ho! We're spreading some holiday cheer at matchbox short pump. Bring the whole family to Brunch with Santa and meet and take pictures with jolly Old St. Nick on Saturday, December 15 from 10am-12pm.
Enjoy a cookie decorating station, hot chocolate bar, holiday crafts, and more. A photographer will be on-hand to snap a picture of your little one with Santa.
We're serving a menu of matchbox favorites buffet-style. Think chicken + waffles, mini burritos, eggs, bacon, sausage, fruit platter, cornbread, and biscuits with honey butter. Plus, mimosas for the parents.
Per person registration fee Adults: $29 | Children 12 + under: $15 | Children under 3: Free. Taxes and gratuity included. Tickets must be purchased in advance.


SHAKOPEE, Minn.--(BUSINESS WIRE)--Aug. 15, 2016-- Canterbury Park Holding Corporation (the "Company") (NASDAQ:CPHC) today announced financial results for its second quarter and six month periods ended June 30, 2016.
The Company reported net revenues of $13,885,992 for the three months ended June 30, 2016, a decrease of 6.5% from revenues of $14,848,077 in the same 2015 period. This decrease consisted of a $305,027, or 9.2%, decrease in Pari-mutuel revenues, a $380,836, or 5.2%, decrease in Card Casino revenues and a $294,551, or 11.7%, decrease in Food and Beverage revenues. For the six months ended June 30, 2016, the Company's revenues were $24,279,303, a decrease of 1.8% from revenues of $24,729,115 for the same period in 2015. This decrease consisted of declines in Pari-mutuel, Card Casino and Food and Beverage revenues of 6.0%, 0.7% and 6.2%, respectively.
The Company's operating expenses during the 2016 second quarter were $9,988,467, a decrease of $3,890,642, or 28.0%, from second quarter 2015 expenses of $13,879,109, and the Company's operating expenses during the six months ended June 30, 2016 were $19,858,783, a decrease of $3,239,135, or 14.0%, from operating expenses of $23,097,918 in the six months ended June 30, 2015. The substantial decline in operating expenses in the quarter and six months ended June 30, 2016 reflects a $3,990,519 pretax gain on sale of land in the 2016 second quarter that was accounted for as a reduction in operating expenses.
Reflecting the second quarter gain on sale of land and a tax charge associated with this sale, the Company reported net income of $2,274,900 for the three months ended June 30, 2016 compared to net income of $571,650 in the same period in 2015, and net income of $2,585,654 for the six months ended June 30, 2016 compared to net income of $960,254 for the same period in 2015. Diluted income per share for the second quarter of 2016 was $.53 compared to $.14 for the same period in 2015. Diluted income per share for the six month period ended June 30, 2016 was $.60 compared to diluted income per share of $.23 for the six month period ended June 30, 2015.
The Company generated adjusted EBITDA of $1,624,511 in the first six months of 2016, a decrease of $1,178,396, or 42%, from the same period a year ago.
Further detail regarding our results for the second quarter and first six months of 2016 is presented in the accompanying table, and additional information regarding the Company's financial results will be presented in the Company's Form 10-Q Report that will be filed on August 15, 2016 with the Securities and Exchange Commission.
"We had a record second quarter as far as our bottom line results due to the gain from the sale of land, but revenues and operating results for the quarter did not meet our expectations," stated Randy Sampson, Canterbury Park's President and CEO.
To supplement our financial statements, we also provide investors with EBITDA (defined below), which is a non-GAAP measure. EBITDA represents earnings before interest income, income tax expense, and depreciation and amortization. EBITDA is not a measure of performance or liquidity calculated in accordance with generally accepted accounting principles ("GAAP"), and should not be considered an alternative to, or more meaningful than, net income as an indicator of our operating performance, or cash flows from operating activities as a measure of liquidity. EBITDA has been presented as a supplemental disclosure because it is a widely used measure of performance and basis for valuation of companies in our industry. Moreover, other companies that provide EBITDA information may calculate EBITDA differently than we do. During the six months ended June 30, 2016, Adjusted EBITDA excluded the gain on sale of land.
Canterbury Park Holding Corporation (the Company) owns and operates Canterbury Park Racetrack and Card Casino, Minnesota's only thoroughbred and quarter horse racing facility. The Company's 69-day 2016 live race meet began on May 20th and ends September 17th. In addition, Canterbury Park's Card Casino hosts "unbanked" card games 24 hours a day, seven days a week, offering both poker and table games. The Company also conducts year-round wagering on simulcast horse racing and hosts a variety of other entertainment and special events at its facility in Shakopee, Minnesota. For more information about the Company, please visit us at www.canterburypark.com.
The Company replaced CPHC as the public company owned by CPHC's shareholders, with each shareholder at June 30, 2016 having the same percentage ownership in Company (and, indirectly, in all property and other assets then owned by CPHC) immediately after the Reorganization as that shareholder had immediately before the Reorganization.
For purposes of this press release, when the term "Company" is used with reference to information covering or related to periods up to and including June 30, 2016, such term refers to the operations of CPHC prior to the Reorganization.
From time to time, in press releases and in other communications to shareholders or the investing public, Canterbury Park Holding Corporation may make forward-looking statements concerning possible or anticipated future financial performance, business activities or plans based on management's beliefs and assumptions. These forward looking statements are typically preceded by the words such as "believes," "expects," "anticipates," "intends" or similar expressions. Shareholders and the investing public should understand that these forward-looking statements are subject to risks and uncertainties, including those disclosed in our periodic filings with the Securities and Exchange Commission, which could cause actual performance, activities or plans after the date the statements are made to differ significantly from those indicated in the forward-looking statements when made.


Are you looking for a cleaning service in the Baildon, West Yorkshire area? Kleenteam recently carried out this thorough cleaning job of a house after the decorators had been in. As can be seen from the photos there was a lot of work to do. We cleaned the house to a very high standard. We use industry standard cleaning products to ensure a quality job and are very experienced with decades of experience in the cleaning industry. Our products are child and pet safe and environmentally friendly. Scroll through the slideshow to see our work.


text:
Today in History 10/26/16
(1825) New York opens a manmade waterway to the west
First proposed in 1804 as a navigable link between Manhattan's harbor traffic and the Great Lakes, a grand engineering feat stretching 425 miles is ready for business. An opening day flotilla sails down the length of the Erie Canal, with celebratory cannon shots marking its progress..
The Erie Canal is a canal in New York that is part of the east-west, cross-state route of the New York State Canal System. Originally, it ran about 363 miles from Albany, on the Hudson River, to Buffalo, at Lake Erie. It was built to create a navigable water route from New York City and the Atlantic Ocean to the Great Lakes.
— Source: wiki/Erie_Canal
(1881) Shots ring out near a corral in Tombstone
It's three hours past high noon on the streets of Tombstone, Arizona Territory, when lawmen 'Doc' Holliday and the Earp Brothers meet the Clanton-McLaury gang and their feud erupts. Thirty seconds later three are dead, three are wounded, and the Gunfight at the OK Corral enters Wild West lore. .
The Gunfight at the O.K. Corral was a 30-second shootout between lawmen and members of a loosely organized group of outlaws called the Cowboys that took place at about 3:00 p.m. on Wednesday, October 26, 1881 in Tombstone, Arizona Territory. It is generally regarded as the most famous shootout in the history of the American Wild West. The gunfight was the result of a long-simmering feud, with Cowboys Billy Claiborne, Ike and Billy Clanton, and Tom and Frank McLaury on one side and town Marshal Virgil Earp, Special Policeman Morgan Earp, Special Policeman Wyatt Earp, and temporary policeman Doc Holliday on the other side. All three Earp brothers had been the target of repeated death threats made by the Cowboys, who objected to the Earps' interference in their illegal activities. Billy Clanton and both McLaury brothers were killed. Ike Clanton claimed that he was unarmed and ran from the fight, along with Billy Claiborne. Virgil, Morgan, and Doc Holliday were wounded, but Wyatt Earp was unharmed. The shootout has come to represent a period of the American Old West when the frontier was virtually an open range for outlaws, largely unopposed by law enforcement officers who were spread thin over vast territories.
— Source: wiki/Gunfight_at_the_O.K._Corral
(1968) American boxer takes gold in Mexico City
Rising from a difficult childhood in Texas, George Foreman shows his mettle at the Mexico City Olympics, knocking out Soviet Ionas Chepulis to win the Heavyweight Boxing gold medal. The champ will go on to win professional titles and later find big success with a little grill. .
George Edward Foreman is an American former professional boxer who competed from 1969 to 1977, and from 1987 to 1997. Nicknamed "Big George", he is a two-time world heavyweight champion and an Olympic gold medalist. Outside the sport he went on to become an ordained minister, author and entrepreneur.
Born: Jan 10, 1949 (age 67) · Marshall, TX
Height: 6′ 0″ (1.83 m)
Net worth: $250 million USD (2016)
Spouse: Mary Joan Martelly (m. 1985) · Andrea Skeete (m. 1982 – 1985) · Sharon Goodson (m. 1981 – 1982) · Cynthia Lewis
Children: George Foreman III (Son) · George Foreman IV (Son) · George Foreman VI (Son) · George Foreman V (Son)
Boxer weight division: Heavyweight
— Source: wiki/George_Foreman
(1985) A sacred Australian site is returned to its original owners
One of the most recognizable landmarks in the world, a sandstone monolith rising 1,142 feet from the arid sands of the Outback, is transferred from the Australian government to the local Aṉangu Aboriginal tribe. The sacred site will be officially renamed Uluru/Ayers Rock in 2002..
Uluru, also known as Ayers Rock and officially gazetted as "Uluru / Ayers Rock", is a large sandstone rock formation in the southern part of the Northern Territory in central Australia. It lies 335 km (208 mi) south west of the nearest large town, Alice Springs, 450 km (280 mi) by road.
Kata Tjuta and Uluru are the two major features of the Uluṟu-Kata Tjuṯa National Park. Uluru is sacred to the Pitjantjatjara Anangu, the Aboriginal people of the area. The area around the formation is home to an abundance of springs, waterholes, rock caves, and ancient paintings. Uluru is listed as a UNESCO World Heritage Site.
Address: Uluru-Kata Tjuta National Park, Yulara Northern Territory 0872
— Source: wiki/Uluru
← Daily Pic 10/25/16
Daily Pic 10/26/16 →
1851 Germany annual national park 1953 1967 1940 1981 vocabulary 1995 1916 1934 1870 1911 1846 1950 event 1937 1986 1991 holiday 1985 has_audio 1947 1965 1968 1915 1941 1789 1990 1979 1902 1898 1961 daily pic 1938 1993 1973 1889 1975 1914 1942 United States 1954 1989 1983 1922 1949 New York England 1969 1919 1984 1948 1946 1863 1970 1972 1943 Soviet Union 1955 1998 1945 NASA 1977 1964 1812 1776 1933 1918 1901 1976 1974 1966 code history 1944 1956 1962 2000 1958 1963 1935 1908 1952 1980 1982 1917 1865 memorial 1994 1957 1978 has_video 1939 1859 1959 1971 1951 1960


Under the direction of David A. Lewis, MD, the Silvio O. Conte Center for Translational Mental Health Research (CTMHR) at the University of Pittsburgh focuses on the mechanisms that link the pathology, pathophysiology and clinical features of schizophrenia. The investigations of the Center reflect the synergistic scientific interactions among Center investigators from the University of Pittsburgh Schools of Medicine and Arts and Sciences, and Carnegie Mellon University, and the resulting development and implementation of innovative experimental designs and research tools to achieve these goals. Collectively, the Center represents a broad array of expertise spanning molecular, systems, cognitive, computational and clinical neuroscience.
Functional outcome in individuals with schizophrenia and related disorders is primarily determined by the degree of impairment in certain core cognitive abilities. For example, subjects with schizophrenia exhibit deficits in visual working memory and attention, and altered patterns of cortical activity during tasks that tap these abilities. These patterns of activity depend on the proper temporal firing of neurons distributed across a network that includes primary visual (V1), posterior parietal (PPC) and dorsolateral prefrontal DLPFC) cortices. These findings highlight an unanswered critical question: What are the cortical cellular, circuitry and connectivity bases for the impairments in visual working memory and attention in schizophrenia?
Cell type-autonomous molecular disturbances in layer 3 pyramidal cells of the neocortex give rise to morphological abnormalities in these neurons, the severity of which is moderated by normal differences across cortical regions. This pathology alters cortical circuitry within and between regions, impairs functional connectivity and neural synchrony across regions, and disturbs both 'bottom up' and 'top down' processes during working memory and attention in individuals with schizophrenia.
The Center is comprised of five research projects and two cores that are designed to provide convergent tests of this hypothesis. The synergism of these projects facilitates a translational approach to schizophrenia research, making laboratory findings readily relevant to clinical treatment. The proposed studies have high clinical relevance as the combination of molecular-cellular-circuit level analyses with in vivo indices of brain function offers a platform for subsequent identification of novel, pathologically-based targets for therapeutic interventions that are accompanied by pathophysiologically-informed biomarkers that can be used to predict and monitor the efficacy of such interventions.
In addition to its specific research objectives, the Center provides a rich environment for training and career development in which undergraduate, graduate and medical students, postdoctoral fellows and psychiatry residents can become involved in studies that bring the methods and knowledge base of basic neuroscience to address critical questions in clinical research. The CTMHR hopes to propel the development of new and more effective treatments for individuals with schizophrenia and provide a vehicle for disseminating the importance of, and the knowledge gained from, translational studies of schizophrenia and related disorders to the broader scientific and lay communities.


It's time for Halloween in the U.S. and people have scary things on their mind. There are scary things on the Internet as well, but Firefox doesn't want you to get "tricked." For a Halloween "treat" instead, here's an overview of some of the security settings you'll find in Firefox.
Warn me when sites try to install add-ons: Firefox will always ask you to confirm installations of add-ons (those little pieces of software that enhance your Firefox experience — a full list found here). To prevent unrequested installation prompts, Firefox warns you when a website tries to install an add-on and blocks it. You can add exceptions to this rule for sites you trust — just click Exceptions, enter the site name and click Allow.
Block reported attack sites: Check this if you want Firefox to check whether the site you are visiting may be an attempt to interfere with normal computer functions or send personal data about you to unauthorized parties over the Internet (note that the absence of a warning does not guarantee that a site is trustworthy).
Remember passwords for sites: Firefox can securely save passwords you enter in Web forms to make it easier to log in to websites. Clear this checkbox to prevent Firefox from remembering your passwords (for example, if you're on a public computer). Even with this checked, however, you'll still be asked whether to save passwords for a site when you first visit it. If you select Never for This Site, that site will be added to an exceptions list. Use Exceptions to access that list.
Use a master password: Firefox can protect sensitive information such as saved passwords and certificates by encrypting them using a master password. If you create a master password, each time you start Firefox it will ask you to enter the password the first time it needs to access a certificate or stored password. You can set, change or remove the master password by checking or unchecking this preference or by clicking the Change Master Password… button. If a master password is already set, you will need to enter it in order to change or remove the master password.
And that's just what's available in the Firefox Security Settings menu. Firefox is all about defending your Internet privacy and security with features like Private Browsing and Do Not Track, among others. Read the blog post on 6 ways to stay secure on Firefox or read this for a comprehensive list of Firefox Security features and stay safe online!


text:
DISNEY COLLECTOR ARCHIVES
Signed Disneyland Mad Tea Party Print (2014)
Posted on June 28, 2017 July 21, 2017 by The Curator
This color print, featuring Fantasyland's Mad Tea Party attraction, has been hand-signed by Alice (in Wonderland) herself, Ms. Kathryn Beaumont.
The iconic spinning tea-cups, based on the 1951 Disney classic Alice in Wonderland have been a hallmark of the park since the Magic Kingdom's debut on July 17, 1955. This photo print of the attraction, as it appeared in the early years of Disneyland, includes a personalized inscription and signature from Kathryn Beaumont, the young actress who both voiced and served as the live-action model for the film's animated protagonist, making reference to "The Unbirthday Song," which is featured in the sequence of the film from which the attraction's theming is derived:
For [X-EDITED-X] with best wishes,
"A very merry unbirthday, to you, to you!"
The British-born Beaumont made her acting debut at the age of six in 1944's It Happened One Sunday. It was her role in On an Island With You, four years later, however, that prompted Walt Disney to cast her in the lead role of his upcoming feature, Alice in Wonderland. Upon seeing the adorable child star in person, and witnessing her acting abilities firsthand, he also recruited her to double as the reference model for the Alice character. Her memorable performance led to a follow-up role as Wendy in the studio's very next feature, Peter Pan. Beaumont did a bit of television acting in the years immediately following the Disney roles for which she would forever be known, but eventually settled into a career in education as an elementary-school teacher for three decades. She was named a Disney Legend in 1998 for her major contribution to the success of two of Disney's most beloved animated features of all time, and would continue to voice both Alice and Wendy for miscellaneous projects until her retirement in 2005.
This Disneyland photo print, signed and personalized by Disney Legend Kathryn Beaumont, is a unique memento representing not only the classic feature and the resulting much-loved attraction, but the talented young actress who's since taken decades' worth of audiences along on her memorable journey into Wonderland.
VALUE: $20
Posted in DisneylandTagged Alice, Alice in Wonderland, Disney autograph, Disney Legend, Disney signature, Disneyland, Fantasyland, It Happened One Sunday, Kathryn Beaumont, Mad Tea Party, Margaret O'Brien, On an Island With You, Peter Pan, Silver Age of Disney Animation, The Unbirthday Song, Walt Disney, Walt Disney Animation, Wendy DarlingLeave a comment
Previous PostDisneyland Souvenir Picture Book (1955)Next PostDisneyland Nature's Wonderland Grand Opening Flyer (1960)


text:
Search results (help)
You will need to turn on JavaScript to access all features on U2start!
Medium (960px)
Original (2816x2112px)
This photo is posted under a Creative Commons license. You are free to share the photo under certain terms. Click on the license to view these terms.
U2 in Toronto
2009-09-17 - Toronto
Photo set:
U2 in Toronto by Ian Muttoo
Photo shot by Ian Muttoo in Toronto, September 17 in 2009.
Name of author:
Ian Muttoo
U2 era:
On the horizon (2008-2011)
Photo date:
Canon Canon PowerShot S3 IS
Optional comment:
"It's a song about uncertainty. We talked a lot about uncertainty when we were making the record. Musically, uncertainty is the antidote to complacency. As far as the song was concerned, all the ad slogans were the real breakthrough for me. My favorite line is 'We're mild and green." -The Edge on Zooropa
The versions of A Sort Of Homecoming and Bad included in the Wide Awake In America EP sound like live recordings but they were actually recorded during two soundchecks of the Unforgettable Fire tour in Europe. The audience noise was mixed in afterwards.
U2start
Social media and RSS
© U2start.com v7.2 (2006-2021) - U2start is not affiliated with U2, their management, record label or any related bodies. Read more in our copyright or privacy statement.


text:
Home » Opinion » In memory of a tough conservationist
In memory of a tough conservationist
Per Moberg, who died in August at age ninety-one, will be remembered as a give-no-quarter conservationist who was totally dedicated to protecting the Adirondacks.
He was born in Brooklyn, but his parents took him back to Sweden after six months, and he didn't return to the United States for twenty-five years. He spoke for the environment in a deep, strong voice in his thick Swedish accent—an effective combination.
Having fished many times in Lapland for Arctic char with his father, he quickly developed a passion for trout fishing that eventually drew him to the Adirondacks. In the 1960s he served on the Board of Governors of the Adirondack Mountain Club and on the committee that ensured the integrity of Article 14, the forever-wild clause, during the 1967 constitutional convention. By the late 1960s he was chairman of the Atlantic chapter of the Sierra Club and was keeping a watch on the Temporary Study Commission on the Future of the Adirondacks.
In 1970 he joined the state Department of Environmental Conservation, where he helped create many local conservation commissions and county environmental-management councils. Perhaps his most spectacular accomplishment with the DEC came in 1985, a year before he retired, when he coordinated the acquisition of the Bog River Flow and Lows Lake for the Forest Preserve centennial.
Within the Sierra Club, his greatest accomplishment was that, with Tom Kligerman, he laid the groundwork for the club's 1991 paddle through Adirondack League Club property on the South Branch of the Moose River, leading to the 1998 landmark Court of Appeals decision that sanctioned recreational use as a test of navigability when determining the public's right of access.
Per and Tom also issued a position paper in 1988 titled "The Adirondack Park—A Park in Trouble." Per would say now that it never got out of trouble.
Charles Morrison, Saratoga Springs


text:
<?php

declare(strict_types=1);

namespace ApiPlatform\Tests\Fixtures\TestBundle\Entity;

use ApiPlatform\Metadata\ApiResource;
use ApiPlatform\Metadata\GetCollection;
use ApiPlatform\Metadata\Link;
use Doctrine\Common\Collections\ArrayCollection;
use Doctrine\Common\Collections\Collection;
use Doctrine\ORM\Mapping as ORM;

/**
 * Dummy Aggregate Offer.
 *
 * https://github.com/api-platform/core/issues/1107.
 *
 * @author Antoine Bluchet <soyuka@gmail.com>
 */
#[ApiResource]
#[ApiResource(uriTemplate: '/dummy_products/{id}/offers.{_format}', uriVariables: ['id' => new Link(fromClass: \ApiPlatform\Tests\Fixtures\TestBundle\Entity\DummyProduct::class, identifiers: ['id'], toProperty: 'product')], status: 200, operations: [new GetCollection()])]
#[ApiResource(uriTemplate: '/dummy_products/{id}/related_products/{relatedProducts}/offers.{_format}', uriVariables: ['id' => new Link(fromClass: \ApiPlatform\Tests\Fixtures\TestBundle\Entity\DummyProduct::class, identifiers: ['id']), 'relatedProducts' => new Link(fromClass: \ApiPlatform\Tests\Fixtures\TestBundle\Entity\DummyProduct::class, identifiers: ['id'], toProperty: 'product')], status: 200, operations: [new GetCollection()])]
#[ORM\Entity]
class DummyAggregateOffer
{
    /**
     * @var int The id
     */
    #[ORM\Column(type: 'integer')]
    #[ORM\Id]
    #[ORM\GeneratedValue(strategy: 'AUTO')]
    private ?int $id = null;
    /**
     * @var Collection<int,DummyOffer>
     */
    #[ORM\OneToMany(targetEntity: DummyOffer::class, mappedBy: 'aggregate', cascade: ['persist'])]
    private Collection $offers;
    /**
     * @var DummyProduct|null The dummy product
     */
    #[ORM\ManyToOne(targetEntity: DummyProduct::class, inversedBy: 'offers')]
    private ?DummyProduct $product = null;
    /**
     * @var int The dummy aggregate offer value
     */
    #[ORM\Column(type: 'integer')]
    private $value;

    public function __construct()
    {
        $this->offers = new ArrayCollection();
    }

    public function getOffers()
    {
        return $this->offers;
    }

    public function setOffers($offers)
    {
        $this->offers = $offers;
    }

    public function addOffer(DummyOffer $offer)
    {
        $this->offers->add($offer);
        $offer->setAggregate($this);
    }

    public function getId()
    {
        return $this->id;
    }

    public function getValue()
    {
        return $this->value;
    }

    public function setValue($value)
    {
        $this->value = $value;
    }

    public function getProduct()
    {
        return $this->product;
    }

    public function setProduct(DummyProduct $product)
    {
        $this->product = $product;
    }
}

redpajama_set_name: RedPajamaGithub