When you're making a masterpiece, shortcuts are unacceptable. Luckily, having the right accessory is the next best thing. Start your search — the smartest tool (and perfect finishing touch) could be a click away.
Holds up to eight spools of thread. Thread pins are numbered for embroidery color changes.
Easily create beautiful cutwork embroidery.
Developed especially for use with the embroidery functions of sewing and embroidery machines.
When using the creative™ Grand Metal Hoop 240x150mm hooping won't be a problem!
When using the creative™ Petite Metal Hoop 100x100mm hooping won't be a problem!
Makes it easier to use large spools of decorative thread.
Embellish your project with different types of trims.
Useful for stitching straight lines when quilting or for wonderful quilted effects.
Guides and stretches 6mm to 12mm wide elastic and sews it in place.
Used for stippling and free-motion embroidery.
Create beautiful embellishments and decorative stitches.
Designed to give you more control when free-motion quilting.
Perfect for sewing free-motion embroidery or darning.
Stitch and gather two layers of fabric quickly and easily.
6D™ Premier is the ultimate embroidery software system, providing unlimited possibilities to design your ideas!
Browse online or download and keep our Accessory Catalog to peruse when you please. You never know when the need for something new will arise.


text:
Q: Excel - Matching if Cell Contains Substring Not Returning Value For some reason this will not return the matched row number for this specific substring. It works just fine with others.
EXAMPLE: Wanting to search/match and return which row contains the text "Tina Marie 5H,6H,7H 1 Initial_Visit"...searching through JR1:JR1000
Formula in JT3: =MATCH("*"&"Tina Marie 5H,6H,7H 1 Initial_Visit"&"*",$JR$1:$JR$1000,0)
If I even just search for "Tina", it returns the row beneath the first actual row...4 rather than 3
Here is a demo of the erroring code for debug purposes

A: The problem is the length of the concatenated values, which would exceed 255 characters. Instead in C2 try:
=LET(X,MIN(IF(ISNUMBER(SEARCH("*"&A2&" "&B2&" initial_visit*",D$2:AB$19)),ROW(D$2:AB$19)-1,"")),IF(X,X,""))

redpajama_set_name: RedPajamaStackExchange


text:
David Bowie's 'Brilliant Adventure' Boxed Set Finds His 1990s Music Aging Much Better Than Expected: Album Review
Jem Aswad
For the most part, David Bowie's career can be divided into eras by decade — the '60s, when he tried almost anything to make it (Mod-pop, Buddhism, folksinging) and mostly failed; the '70s, when he released some of the most exciting and innovative albums in music history; the '80s, when he got a taste of platinum success with "Let's Dance" and lost his muse; and the period encapsulated in the latest career-spanning boxed set, "Brilliant Adventure: 1992-2001" — when he got at least some of it back.
It's likely that even Bowie would agree that he spent the latter half of the '80s flailing in search of inspiration, bounding from the garish pop excess of "Never Let Me Down" to his bizarre, Pixies-inspired take on an indie-rock band, the much-lambasted Tin Machine (whose albums his estate seems to have left for a later retrospective). And although many of his moves in the period covered here seemed just as cynical at the time — a series of seemingly random image changes and musical bandwagon-jumping onto to whatever musical trend was hot at the time, from industrial rock to drum n' bass — the songs on these albums have aged much better than it seemed they would at the time.
More from Variety
David Bowie Film, Based on 'Thousands' of Hours of Rare Footage, Coming From Director Brett Morgen (EXCLUSIVE)
Iman On Her Debut Fragrance Inspired By David Bowie and Why She Won't Allow a Biopic About the Late Music Legend
David Bowie '75' Pop-Up Stores Open in New York and London
And although you won't find an overlooked "Life on Mars?" or "The Man Who Sold the World" here, it's still Bowie, challenging himself again after those years in the wilderness, with the familiar haunting refrains, the unusual chord changes, the verses in Cockney accent, the Syd Barrett and Ray Davies-esque melodies, and most of all his still-stunning voice. Nearly all of the albums here have at least glimpses of that greatness and a couple of killer songs or moments. Perhaps not coincidentally, he married Iman Abdulmajid at the beginning of this era; she would be his partner for the rest of his life and presumably played no small role in reviving his creativity as well.
. - Credit: Courtesy ISO-Parlophone
Courtesy ISO-Parlophone
This set begins with 1992's "Black Tie White Noise," Bowie's last stab at another "Let's Dance"-sized hit. He reunited with that album's producer, Chic maestro Nile Rodgers, but didn't approach its success and it's not hard to see why: It sounds badly dated, with lots of big drum sounds and little songwriting inspiration.
But for his next act, Bowie made just about the most welcome musical move longtime fans could have hoped for: reuniting with Brian Eno, with whom he made some of his most visionary work during the late 1970s. While the ensuing album, "Outside," was far too high on concept and low on melody, it did bring him back into an adventurous place (although "Thru' These Architects Eyes" is a thinly veiled rewrite of Jane's Addiction's "Obvious").
The songwriting muse returned with "Earthling," and shines through the of-the-moment industrial and drum n' bass sounds. It includes some of the best and most Bowie-esque songs he wrote during this era, including "Little Wonder," "Battle for Britain," "Telling Lies" and even the Nine Inch Nails knockoff "I'm Afraid of Americans." The following album, 1999's relatively straightforward "hours…," finds him dropping the trend-hopping and not trying to be quite so edgy — he'd just turned 50, after all. It has a dream theme and features nearly as many inspired songs as its predecessor, particularly "Thursday's Child," the rocking "Pretty Things Are Going to Hell" and especially "Seven."
And with that, Bowie closed out the century, although the bonus material here continues up to 2001. The rest of the set includes relatively inessential albums like his 1993 soundtrack to the film version of Hanif Kureishi's "Buddha of Suburbia," a sprawling 20-song live BBC set from 2000, an outtakes collection — and, by far most interesting, the long-lost "Toy" album, which consists of newly recorded versions of songs from very early in his career, mostly from that first era, the mid-1960s.
Recorded live in the studio in 2000 and 2001, "Toy" is simultaneously fascinating and at times ridiculous, and it's not hard to understand why he didn't release it at the time: He's a 53-year-old singing songs he wrote as a very young man like "Karma Man" and "Silly Boy Blue" (the latter of which sounds even more like Dionne Warwick's "Walk on By" here than it did on the original).
In fact, he and his ace band make many of the songs sound better than they actually are, stripped of the basic or fussy arrangements of the originals and his more-naïve vocal delivery of the time. That can be a double-edged sword: "The London Boys," a mod-era anthem that is one of Bowie's best early songs, loses its air of menace and disillusionment in his relatively straightforward vocal here; likewise, "Shadow Man," a "Ziggy Stardust"-era outtake, gets a lush ballad treatment that clouds up the original's charming lilt. The highlight of the set is a romp through his second-ever single, "Can't Help Thinking About Me." Originally recorded when he was just 17, he and the band blaze through the song joyfully, driven by a chiming electric 12-string and powerhouse drumming; it was a highlight of his concerts at the time.
It should be noted that most of the material here was recorded with one of the best bands of Bowie's career, which featured a core of bassist-singer Gail Ann Dorsey, keyboardist Mike Garson, guitarists Reeves Gabrels and Mark Plati and drummers Sterling Campbell or Zachary Alford.
Bowie would continue on this track for another three years, releasing two more albums and gigging regularly, until he suffered a minor heart attack onstage in June of 2004 toward the end of a 100-plus-date world tour and effectively retired. From then, he lived a low-profile life with his family in New York until his death from cancer in 2016, releasing just two more albums and making very rare onstage appearances. Apparently, he also spent no small amount of time curating his archive, judging by the "David Bowie Is" museum exhibit and the large number of archival releases that have been thoughtfully rolled out by his estate over the past few years. His final era will probably be the subject of the next boxed set — and as the 50th anniversaries of his stunning 1970s albums approaches, who knows what else is in store?
You've Been Around
I Feel Free
Black Tie White Noise (featuring Al B. Sure!)
Jump They Say
Nite Flights
Pallas Athena
Miracle Goodnight
Don't Let Me Down & Down
Looking for Lester
I Know It's Gonna Happen Someday
The Wedding Song
THE BUDDHA OF SUBURBIA
Buddha of Suburbia
Sex and the Church
South Horizon
The Mysteries
Bleed Like a Craze, Dad
Strangers When We Meet
Dead Against It
Untitled No. 1
Ian Fish, U.K. Heir
Buddha of Suburbia (featuring Lenny Kravitz on guitar)
1.OUTSIDE
Leon Takes Us Outside
The Hearts Filthy Lesson
A Small Plot of Land
Baby Grace (A Horrid Cassette)" (segue)
Hallo Spaceboy
The Motel
I Have Not Been to Oxford Town
Algeria Touchshriek (segue)
The Voyeur of Utter Destruction (as Beauty)
Ramona A. Stone/I Am with Name (segue)
Wishful Beginnings
Nathan Adler (segue)
I'm Deranged
Thru' These Architects Eyes
Looking for Satellites
Battle for Britain (The Letter)
Seven Years in Tibet
The Last Thing You Should Do
I'm Afraid of Americans
Law (Earthlings on Fire)
'hours…'
Thursday's Child
If I'm Dreaming My Life
What's Really Happening?
The Pretty Things Are Going to Hell
New Angels of Promise
Brilliant Adventure
BBC RADIO THEATRE, LONDON, JUNE 27, 2000 2xCD
Wild Is the Wind
This Is Not America
Always Crashing in the Same Car
The London Boys
I Dig Everything
Cracked Actor
You've Got A Habit Of Leaving
Karma Man
Shadow Man
Let Me Sleep Beside You
Hole In The Ground
Can't Help Thinking About Me
Silly Boy Blue
Toy (Your Turn To Drive)
RE:CALL 5 3xCD
Real Cool World (Sounds From The Cool World Soundtrack Version)
Jump They Say (7" version)
Lucy Can't Dance
Black Tie White Noise (feat Al B. Sure!) (Radio Edit)
Don't Let Me Down & Down (Indonesian Vocal Version)
Buddha Of Suburbia (Single Version) (featuring Lenny Kravitz on guitar)
The Hearts Filthy Lesson (Radio Edit)
Nothing To Be Desired
Strangers When We Meet (edit)
The Man Who Sold The World (Live Eno Mix)
I'm Afraid Of Americans (Showgirls Soundtrack Version)
Hallo Spaceboy (Remix)
I Am With Name (Alternative Version)
A Small Plot Of Land (Long Basquiat Soundtrack Version)
Little Wonder (Edit)
A Fleeting Moment (aka Severn Years In Tibet – Mandarin Version)
Dead Man Walking (Edit)
Seven Years In Tibet (Edit)
Planet Of Dreams – David Bowie and Gail Ann Dorsey
I'm Afraid Of Americans (V1 – Edit)
I Can't Read (The Ice Storm Long Version)
A Foggy Day In London Town – David Bowie and Angelo Badalamenti
Fun (BowieNet Mix)
The Pretty Things Are Going To Hell (Stigmata Soundtrack Version)
Thursday's Child (Radio Edit)
We All Go Through
No One Calls
We Shall Go To Town
The Pretty Things Are Going To Hell (Edit)
Thursday's Child (Omikron: The Nomad Soul Version)
New Angels Of Promise (Omikron: The Nomad Soul Version)
The Dreamers (Omikron: The Nomad Soul Version)
Seven (Demo)
Survive (Marius De Vries mix)
Something In The Air (American Psycho Remix)
Seven (Marius De Vries Mix)
Pictures Of Lily
Best of Variety
The Best Albums of the Decade
Sign up for Variety's Newsletter. For the latest news, follow us on Facebook, Twitter, and Instagram.
Wanting to prevent future abuses, Parliamentary Select Committee on health to discuss amount of fines under Act 342
KUALA LUMPUR, Jan 15 ― The bipartisan Parliamentary Select Committee (PSC) on Health, Science and Innovation has yet to reach a consensus on the amount of fines under Act 342 of the Prevention and...

redpajama_set_name: RedPajamaCommonCrawl


text:
Бердичівське ге́тто — єврейське гето в період Другої світової війни, створене нацистською Німеччиною 7 серпня 1941 року в місті Бердичеві на території СРСР, окупованій нацистами в результаті операції «Барбаросса».

Хід подій

7—8 серпня 1941 року почалося масове виселення євреїв до гето, створеного в районі міського базару (т. зв. "Ятки") та навколишніх вулиць Староміської, Муромської, Штейнівської (останні дві нині мають назви відповідно 30-річчя Перемоги та Льва Толстого), між базаром і річкою Гнилоп'ять. Із майна їм дозволялося взяти лише одяг і білизну. До 22 серпня більшість євреїв зібрали в гето. Євреїв заганяли в старі халупи по п'ять-шість сімей, по кілька десятків людей в одну кімнату. На переселення відводився один день, а на практиці цей строк був зведений до 2—3-х годин. Залишати гето дозволялося лише для виходу на базар, для придбання продуктів, але тільки після шести годин вечора, коли на базарі вже практично не залишалось ані продавців, ані продуктів. В інший час виходити за межі гето заборонялось під страхом суворого покарання.

25 серпня в Бердичів прибув штаб обергрупенфюрера СС і генерала поліції на окупованих територіях Фрідріха Єкельна. В цей же день його штабна рота розпочала масові розстріли єврейського населення — було страчено 546 осіб. 27 серпня велику групу (близько 2 тис. чол., в тому числі старі люди, жінки, діти) вивезли в район села Бистрик і там розстріляли. За цією партією були наступні. Дітей кидали в ями живими. 28 серпня на території Державного історико-культурного заповідника гітлерівці розстріляли 300 євреїв, яких взяли з квартир будинків, що прилягають до заповідника. 4 вересня також проведена масова акція розстрілу єврейського населення, в результаті якої окупанти знищили 1303 мешканці, серед них 876 жінок і дітей. 5 вересня 10 656 осіб було страчено поряд з селом Хажин в районі Глинок (неподалік від полотна вузькоколійної залізниці Бердичів — Бродецьке — Холоневська).

15-16 вересня 1941 року відбувся наймасовіший розстріл мирних жителів єврейської національності міста Бердичева і району. Приречених гнали великими партіями, а немічних звозили багатотонними машинами до місць страти, які завчасно підготували поряд з хутором Шльомарка та селом Жидівці. Групи по 30—50 осіб приганяли до завчасно викопаних ям, де вони віддавали усі цінності й гроші офіцерові, а потім їм пускали кулю в потиличну частину голови. Знесилених хворих та стариків, які не могли пересуватися, рідні несли до місця страти на ковдрах, простирадлах і носилках. Після розстрілу верхній шар землі довго ворушився, а наступного дня вся поверхня засипаних землею ям була червона від людської крові. Щоб заглушити крики й плач приречених, під час розстрілу весь день над місцями страти кружляли чотири німецьких тримоторних літаки. Всього цього дня знищено 12 тис. осіб, жінок та дітей. Масову страту здійснили штабна рота обергрупенфюрера СС Фрідріха Єккельна, 45-й резервний поліційний батальйон і поліція, яку створили з місцевого населення. Врятуватись від розстрілу вдалося лише одиницям.

Через два тижні — 3 жовтня — в районі радгоспу (МТС) Сокулино розстріляно понад 3 тисячі євреїв. Це були залишені на півтора місяця жити євреї-фахівці й частково члени їхніх родин, а також виловлені поліцією на території гето євреї, що переховувались від окупантів.

3-го листопада розстріляно ще близько 2-х тисяч євреїв. В місті фактично завершилась ліквідація єврейського населення, яка тривала з липня місяця. Німецько-фашистські окупанти разом з фізичним вбивством євреїв також зруйнували всі синагоги Бердичева — Білопольську, Загребельну, Немирівську, Новоміську і Староміську. Від Хоральної синагоги Бердичева залишилися тільки стіни.

Через пів року, 25 лютого 1942 року, гебітскомісар Бердичівського округу Шмідт видав наказ-розпорядження, згідно з яким всі євреї, що ховались ще від окупаційної влади у Бердичеві, повинні були в недільний термін переселитися в табір СД (служба безпеки) на Лисій горі. У цьому наказі було також вказано, що кожен єврей, якого виявлять 2 березня і в подальші дні після вказаного терміну поза межами табору СД, буде розстріляний на місці. Після видання цього наказу всі євреї-ремісники, що ще залишились живими, були зібрані в барак № 1 табору СД на Лисій горі — на території колишніх казарм 14-го кавалерійського полку Червоної Армії. Через декілька місяців — у середині липня — 700 єврейських дівчат та підлітків (їх зігнали з навколишніх сіл) разом з 230 євреями-майстрами розстріляє німецька таборна охорона та місцева поліція. А 27 квітня були розстріляні зареєстровані єврейки, які проживали у Бердичеві й були одружені з росіянами, а також діти, народжені від змішаних шлюбів. Їх виявилось близько 70 осіб. Останні 60 євреїв-спеціалістів, що ще залишались живими, були розстріляні під час першого наступу Червоної Армії на Житомир у листопаді.

Масштаби трагедії
Згідно з переписом 1939 року в Бердичеві проживало 23266 євреїв, що складали 37,5 % всього населення міста. До літа 1941 року з урахуванням природного приросту та міграції в місто біженців із західних і центральних районів Польщі, окупованих Німеччиною, єврейське населення Бердичева могло зрости до 25—26 тисяч осіб. Всього у 10-ти братських могилах, що знаходяться в різних місцях вздовж автодороги Бердичів-Райгородок, за даними Надзвичайної комісії з розслідування злочинів німецько-фашистських загарбників, поховано 18640 мирних жителів, переважно жінок, дітей і людей похилого віку єврейської національності. Бердичівська трагедія вересня 1941 року стала першим масовим геноцидом єврейського населення, здійсненим гітлерівцями в Європі і Радянському Союзі (наступним стало масове знищення євреїв у Бабиному Яру). Василь Гросман зазначає, що з 20,000 євреїв Бердичева, які опинилися під німецькою окупацією, вижили одиниці.

Вшанування пам'яті
У 1953 році на зібрані жителями Бердичева кошти був виготовлений і встановлений пам'ятник на місці масового розстрілу євреїв поблизу аеродрому у Шльомарці. Монумент простояв один день і за наказом аеродромного начальства був демонтований і відвезений в невідомому напрямі, а через чверть століття випадково був виявлений на старому єврейському кладовищі, де був встановлений біля входу у 1990 році. Після смерті Сталіна, громада відновила зусилля щодо створення пам'ятника, і, у 1958 році, новий пам'ятник був готовий. У написі був опущений той факт, що жертви були євреями.

У 1990-ті роки два пам'ятники з'явилися на місці розстрілів у Шльомарці та на території заповідника. Ще два пам'ятники були зведені на місці колишнього гето в Ятках, присвячені як мешканцям Бердичівського гето, так і українцям, які рятували життя євреїв під час Другої світової війни.

Примітки

Посилання
 БЕРДИЧІВ Історія міста від заснування до сьогодення
 Бердичев: одна из нерассказанных историй…
 Василий Гроссман «Убийство евреев в Бердичеве»
 Стер Елисаветский «Бердичев: уточненные данные о холокосте»
 Олена Іващенко «Пам'ятки і пам'ятні місця історії та культури на Бердичівщині»
 Бердичів. Волинський Єрусалим

Голокост в Україні
Історія Бердичева
Гето України в Другій світовій війні
Історія Житомирської області

redpajama_set_name: RedPajamaWikipedia


Set 26 km from Zadar and 43 km from Sibenik, Boat in Biograd (10 metres) presents pet-friendly accommodation in Biograd. Visitors advantage from gratis wireless internet and private car parking available on site. There is a seating area and a kitchen fitted with a fridge. Vodice is 34 km from Boat in Biograd (10 metres), while Vir is 49 km from the property. Zadar Flight terminal is 19 kilometers away.
Accommodation, close to the beach ~0,7 km, Biograd Na Moru The house has a nice and large terrace where you can enjoy sipping your morning espresso. Entertainment and Outdoor activities: tennis court, motorboat, kayak, canoe, boat dock. Distance to the beach: 300 m.
Mobile home Soline Seaside ~0,6 km, Biograd Na Moru Positioned just 15 metres from Soline Beach, Mobile home Soline Coastal presents self-catering accommodation with an outdoors terrace and sea views. The terrace comes with deck chairs, a wooden swing and Barbecue amenities. The mobile home also includes a tiny kitchenette with a stovetop and fridge. A dining and seating area with a lcd tv can also be found on site. Mobile home Soline Seaside is centrally situated in Biograd na Moru, just 4 minutes' walk from the local bus station.
Boat in Biograd (10 metres) 2 ~0,2 km, Biograd Na Moru price per day from € 96 Boat in Biograd (10 metres) 2 is a holiday house with gratis wireless internet throughout the property, situated in Biograd na Moru. The unit is 26 km from Zadar. Private car parking is available on site. There is a seating area and a kitchen fitted with a fridge. Šibenik is 43 km from Boat in Biograd (10 metres) 2, while Vodice is 34 km from the property. Zadar Flight terminal is 19 kilometers away.
Boat in Biograd (14 metres) 6 ~0.1 km, Biograd Na Moru price per day from € 271 Boat in Biograd (14 metres) 6 presents pet-friendly accommodation in Biograd na Moru, 26 km from Zadar. Gratis wireless internet is provided throughout the property and private car parking is available on site. The kitchen is equipped with a fridge. Šibenik is 43 km from Boat in Biograd (14 metres) 6, while Vodice is 34 km from the property. The closest flight terminal is Zadar Airport, 19 km from the property.
Sveti Filip I Jakov ( ~ 2.8 km ): 55+ accommodation units.
Turanj ( ~ 3.8 km ): 60+ accommodation units.
Pakostane ( ~ 6.3 km ): 74+ apartments.
Sveti Petar ( ~ 8.8 km ): 75+ accommodation units.
Drage ( ~ 9.9 km ): 40+ apartments.
Beach Bosana, Biograd ~ 0,7 km from Boat in Biograd (10 metres) Gravel beach: ideal for families, recommended for young people, with restaurant, with caffe bar. Excellent choice of watersports.
Beach Drazica, Biograd ~ 1,2 km from Boat in Biograd (10 metres) Gravel beach: ideal for families, recommended for young people, awarded with blue flag, with restaurant, with caffe bar, equipped with showers. Excellent choice of watersports.
Beach Soline, Biograd ~ 1,5 km from Boat in Biograd (10 metres) Sandy beach: ideal for families, recommended for young people, with restaurant, with caffe bar, equipped with showers. Excellent choice of watersports.
Beach Iza Banja ~ 2,2 km from Boat in Biograd (10 metres) Sandy beach: ideal for families, recommended for young people, awarded with blue flag, with restaurant, with caffe bar, equipped with showers. Excellent choice of watersports.
Beach Kumenat, Biograd ~ 2,5 km from Boat in Biograd (10 metres) Gravel beach: ideal for families, with caffe bar.


Why Have YieldCos Flopped in 2015?
This was supposed to be the year of the yieldco, so what went wrong?
2015 was supposed to be the year of the yieldco. The financing vehicle had become a popular tool for renewable energy companies in 2014 and with low interest rates persisting these companies were seen as a way to give investors exposure to renewable energy and provide strong dividend yields at the same time.
But this year has seen yieldco stocks plummet, resulting in yields that have exceeded 5%, more than double the rate of treasuries. NRG Yield (NYSE:CWEN), TerraFrom Power (NASDAQ:TERP), Abengoa Yield (NASDAQ:AY), and the recently IPOed 8point3 Energy Partners (NASDAQ:CAFD) have all plunged in recent months. Understanding why these stocks are down and how it impacts these businesses could tell you if buying now is a good option or if it's "hands off" for the time being.
Like it or not, oil prices still dominate the day to day trading of renewable energy stocks. Logically, it doesn't make sense and makes even less sense for companies like yieldcos who have stable long-term cash flows, but this is the stock market we're talking about and logic doesn't rule the land.
Low prices for fossil fuels like natural gas and oil aren't direct competitors but they've clearly caused jitters in the yieldco space. For now, that's bad news for yieldcos and while they aren't a true threat long-term, higher interest rates are.
If there's one thing that could sink the renewable energy industry quickly it's rising interest rates. Renewable energy is cheap today in part because the predictable cash flows projects generate over 20 or more years can be discounted at a low rate to get a relatively high project value. If rates rise, the value of renewable energy projects goes down and they can go down quickly.
You can think of pricing renewable energy projects like a mortgage you might take out on a new home. If you have a $1,000 budget and interest rates are 4% you can afford a $209,500 mortgage. If rates suddenly rise to 6% you can only afford a $166,750 mortgage despite the same monthly payment. Analogous situation happens with renewable energy projects and if interest rates rise the price investors will pay for these assets can drop quickly.
Where yieldcos get complicated is in their hopes to grow long-term. Most yieldcos don't plan to grow like a typical stock, plowing earnings back into the business to grow future earnings. Most yieldcos plan to pay out 80%-85% of cash flow to investors in the form of a dividend and keep a small amount for future growth.
The working assumption is that they'll be able to float more debt and more equity to buy projects and increase the dividend. This works if the cost of interest payments and equity are lower than the cost to buy new projects. So, for example if you have a cost of debt of 6% and a cost of equity of 9% and use a 50/50 mix to buy projects, then as long as the projects you buy have a higher IRR than 7.5% you can issue debt and equity and grow almost at will and still have extra cash to raise the dividend.
But problems start to arise when the cost of capital rises. If your cost of capital is higher than the IRR of projects then it would actually lower cash available to be paid in dividends if a yieldco expanded, reducing the ability to grow. If you can't grow the dividend then investors will command a higher dividend, creating a vicious cycle of declining stock prices.
It may sound weird but high stock prices are actually essential to the yieldco investment thesis. If stock prices fall too far companies won't have the ability to issue equity to expand and grow dividends in the future. That's why the recent drop in stocks is such a big deal.
From an investment perspective, the drop in yieldcos isn't bad for the yieldcos themselves and can actually give prospective investors with better dividend yields short-term. But it could have a negative impact on dividend growth and will likely be a big negative to yieldco sponsors. These sponsors are hoping for high project purchase prices when they push assets down to the yieldco, assisted by a yieldco's low cost of capital, as well as growing incentive distribution rights if the dividend rises. Low stock prices hurt both.
The view you take on yieldcos today should depend a lot on how the yieldco is structured. For example, TerraForm Power is highly leveraged and SunEdison essentially has to force projects down to it to remain solvent. There's a lot of risk that projects will have to be acquired at unfavorable terms, which could hurt both companies if TerraForm ends up issuing equity and buying projects at a lower IRR than total capital costs.
8point3 Energy Partners is a partnership between SunPower and First Solar and it's going to use less leverage and has lower growth goals than TerraForm Power. That can be a detriment in good times, but the company also doesn't have to issue new shares to buy projects in the next year if it doesn't want to.
NRG Yield actually owns some fossil fuel assets and has the ability to buy projects at market prices, which means it isn't as beholden to the interests of its sponsor as typical renewable developer sponsors. If this allows the company to buy projects at attractive prices in the future this could be an advantage.
Knowing how yieldcos are built and why stock prices matter is important for investors and it may explain why solar stocks are having a tough year. For the industry's sake, I hope the slump doesn't last long or there will be a lot of turmoil in renewable energy.


text:
Facebook also removes 4 Infowars videos, including one it previously cleared | Tech Social
By Prosyscom Tech On Jul 27, 2018
Days after defending its decision to give a voice to conspiracy theory peddler Alex Jones and his Infowars site, Facebook has removed four of his videos for violating its community standards.
But one of the four had already been allowed to slip through the firm's review system. A source within Facebook told TechCrunch that one of the videos had previously been flagged for review in June but, after being looked over by a checker, it was allowed remain on the social network. That decision was described as "erroneous" and it has now been removed.
Facebook's removal of the videos comes days after YouTube scrubbed four videos from Jones from its site for violating its policies on content. The Facebook source confirmed that three of the videos it has removed were flagged for the first time on Wednesday — presumably after, or in conjunction with, them being highlighted to YouTube — but the fact that one had gotten the all-clear one again raises question marks about the consistency of Facebook's review process.
Contrary to some media reports, Jones has not received a 30-day ban from Facebook following these removals. TechCrunch understands that such a ban will be issued if Jones violates the company's policies in the future, but, for now, he has been given a warning.
"Our Community Standards make it clear that we prohibit content that encourages physical harm [bullying], or attacks someone based on their religious affiliation or gender identity [hate speech]. We remove content that violates our standards as soon as we're aware of it. In this case, we received reports related to four different videos on the Pages that Infowars and Alex Jones maintain on Facebook. We reviewed the content against our Community Standards and determined that it violates. All four videos have been removed from Facebook," a spokesperson said in a statement.
Also Read: Facebook Exposed Data Again, but This Viral Cat Can Save Lives
Earlier this month, the company's head of News Feed John Hegeman said of Infowars content — which includes claims 9/11 was an inside job and alternate theories to the San Bernardino shootings — that "just for being false, doesn't violate the community standards." He added: "We created Facebook to be a place where different people can have a voice."
Facebook seemed to double down on that stance on Monday when, at another event, VP of product Fidji Simo called Infowars "absolutely atrocious" but then said that "if you are saying something untrue on Facebook, you're allowed to say it as long as you're an authentic person and you are meeting the community standards."
It's not been a good week for Facebook. A poor earnings report spooked investors and caused its valuation drop by $123 billion in what is the largest-single market cap wipeout in U.S. trading history. That's not the kind of record Facebook will want to own.
clearedfacebookincludinginfowarspreviouslyprosyscom techremovessocial
The champion without a belt | Innovation Tech
Mum found dead in garage after 'assault' | Innovation Tech
How Much You Spend on Social Media Advertising and marketing?
Facebook rolls out anti-scam reporting tool in UK
Too much time on social media can hurt teens' mental health
Facebook hires former Vine head to work for new experimental app division
Facebook to Pay $5 Billion Fine to Settle FTC Privacy Investigation


The New York Power Authority (NYPA), officially the Power Authority of the State of New York, is a special purpose government entity engaged in power generation, transmission, and sale and purchase of power in the state of New York.
Tenaga Nasional Berhad (TNB) is Malaysia's leading electricity company. The state-owned enterprise dominates the electricity generation, transmission and distribution market..
Estonia's power sector has undergone a significant transformation under the European Union (EU)'s Third Energy Package of 2009.
India's transmission sector has witnessed high growth rates in recent years, driven mainly by the government's initiatives such as 'One nation, One price and One grid' and 'Power for All'.
In 1990, the Government of Côte d'Ivoire (GoCDI) decided to privatise the power sector and established Compangie Ivoirienne d'Electricité (CIE).


The always chic Victoria Beckham has climbed aboard the e-commerce bandwagon. Launching this week, victoriabeckham.com allows for international customers to shop the collection, exclusively online.
The London based label has designed the site with two separate categories – a Shop and a Look. The Look section features a tumblr-esque approach and shareable social content including exclusive videos and behind the scenes footage.
Look for the Shop section to feature exclusive Beckham designs, including accessories (i.e. bags), the 'Victoria' Victoria Beckham diffusion line, eyewear and denim. Furthermore, she has added a little personal flare to the website by adding an Icon feature. The shop feature will include redesigned and retouched 'greatest hits' – re-edited former dresses that have been updated via Beckham herself. What a way to place a personal mark in such a wide-spread shop!
Beckham also reached out to fellow industry powerhouses, hiring Jonny Lu and Isaac Lock, to help aide with refreshing the site. Lu and Lock previously worked with HAKAAN, LOVE Magazine and Louis Vuitton. With these seasoned staff at the helm, look for her site to both impress and express Beckham's influential design presence.


text:
Home Historical
SORT BY : HOT
Generation from generation, the world is changing. And those changing becomes greed. We just want to heal the world, but the only way to do that is to kill them all. This is the story of the virus A Virus that can heal the world. A virus that can make everything back to the way it used to be. Is this the end of the world? Or is it the cure to heal the world?
CrimeRomanceHistorical +1 more
M's Review Book
[ TEMPORARILY CLOSED ] This book contains constructive critiques on works of fiction I have read. Interested in receiving feedback on your work? My critiques can be thorough and far from overly generic or sugarcoated to the point of being unhelpful. DISCLAIMER: This book contains detailed feedback / critiques on stories submitted by different authors for me to critique. Included excerpts of their drafts may or may no longer be published on digital reading/writing platforms which I'm also a member of. Snippets of their work have been included in this book as part of the review I provided to help the authors improve their skills as a writer, and not as an attempt to plagiarize their work(s).
TeenficHistoricalContemporaryFantasyWerewolfShort Story +4 more
Get Out Of My Way, Devilish Duke!
When someone needs an enormous amount of money, what can they do to get it? Sell a kidney? (Yeah, that's an appropriate option) However, I became a game tester. All I have to do is to make sure that the MC and ML will reach their happy ending. Sweet! Easy Money! What if the game was harder than I thought? And what's this hidden task?! Do I really have to reach my own happy ending too?!
New AdultFantasyRomanceHistoricalLove +3 more
Prakriti (Mahabharata)
When Prakriti herself become the part of great epic story of Mahabharata where she fight for the righteousness (dharm) along with Pandavas. Lets see how the story change due to her intervention.
RomanceHistoricalAdventureActionParanormal +3 more
Chasing the Dead, Book 1
~1884, New Mexico~ Madrid Arrende has been kidnapped by the Apache. Determined to rescue his daughter, her wealthy father realizes there is only one man capable of bringing her back alive...Deacon Bannister. Deacon doesn't give one whit about the large sum of money Don Erasmos Arrende has offered him to rescue her. Deacon only cares about bringing the woman he left standing at the altar a year ago home. A ghost is terrorizing the Apache village and the young maiden, Sacheen, has been banished by her People for unleashing Uday's wrath. Now, Deacon, Madrid and Sacheen must flee for their lives across the rugged New Mexico landscape with the evil spirit in hot pursuit. Will they make it back alive to Madrid's father's hacienda or will Deacon lose the woman he loves forever?
RomanceHistoricalMysteryThrillerParanormal +3 more
Clean/Sweet Historical Romance In the continuing saga of Dawson and Rory Finch, Dawson is sent by the army to chase hostiles across Dakota Territory. He is a man torn; has no fight with the Native Americans, but feels a duty to his country. Rory nurtures their daughter through her first year of life while fighting the demons that plague her thoughts night and day . . . a silent warning her of impending doom. When a letter arrives from the U.S. Army, telling Rory that Dawson is missing in action and presumed dead, her world is shattered. Fending off pleas from her sister and husband to move on with her life, not to mention a marriage proposal from a determined suitor, Rory holds fast to what she knows in her heart...Dawson is still alive.
WarHistoricalMysteryRom-ComAction +3 more
Deny thy love
A couple like no other Zeta and Phoenix walked a dark path to true love and marriage. But can fate keep their love strong when challenged by new adventure, love, lust, and lies or will it to be denied? To dark souls brought together with love in mind.
HistoricalRomanceAdventure +1 more
The Four Wheel Saga Book 1: THE LEGACY TRIALS
In the continent of Kinenhi, ravaged by conflict and war, an age of peace and harmony has endured for years. Trade and commerce is flourishing among the six village nations. In the warrior village Karasuma, the Legacy Trials are about to begin, which test the mettle of the young and uninitiated. A host of budding warriors train to contend against each other in battles of melee, magic and the mind. Among them are heroes of the future, who shall possess unbridled power and suffer cruel choices of fate. Meanwhile, evil lurks in the dark, plotting and scheming, to rupture the fabric of peace, and pit village against village, ally against ally, and hero against hero. As matters escalate, dark secrets buried deep come to the fore, and a long-forgotten prophecy is revived from oblivion. Will the heroes respond to the call of destiny? Brace yourself for a journey through beautiful landscapes, electrifying battles, stirring romance and spine-tingling mystery. Disclaimer: Reader Beware. Bloodshed, gore and other adult
HistoricalAdventureActionFantasyWar +3 more
Venus In Furs
Leopold von Sacher-Masoch was born in Lemberg, Austrian Galicia, on January 27, 1836. He studied jurisprudence at Prague and Graz, and in 1857 became a teacher at the latter university. He published several historical works, but soon gave up his academic career to devote himself wholly to literature. For a number of years he edited the international review, Auf der Hohe, at Leipzig, but later removed to Paris, for he was always strongly Francophile.
The Doll Maker's Daughter at Christmas
Everyone deserves a second chance at happiness... even a killer. Serendipity Fizzlestitch wants nothing more than to be left alone. In a small cabin a stone's throw from the house where her sisters and mother breathed their last, Serendipity toils away, making the dolls her late father was working on when he disappeared beneath the ocean waves. Serendipity is content to spend the rest of her existence here, trying to atone for the mistakes of her past by creating the dolls that bring joy to so many others. When a mysterious letter arrives in her fireplace, an unusual stranger shows up at her door, and her favorite mouse friend goes missing, Serendipity is forced to face the outside world--and ghosts from her past. Will she accept the opportunity to join the most famous toymaker of all time, or will her guilt prevent her from finding the happiness everyone deserves? The Doll Maker's Daughter at Christmas is a whimsical romantic fantasy that proves everyone deserves a second chance, no matter how horrific our
FantasyHistoricalRomanceAdventureLove +3 more
Sky Dreams
Clean/Sweet Romance In Sky Tinted Water and Sky Dance you met Dawson and Rory Finch and shared in the journey of their love. Now, in Sky Dreams (Book 3), meet their daughter, Haven. In 1893, Haven Morgan is a young widow. Heartbroken and alone after her husband's tragic death, she travels to Cobb's Grove, Minnesota to teach at the country school. Her curiosity is piqued when she meets the handsome supervisor of the local lumber mill, Cade Kincannon, but the trauma of her husband's death haunts her days and torments her dreams. Will Cade break through the veil of darkness shrouding Haven, forge a path to her heart and convince her it's all right to love again?
RomanceActionMysteryRom-ComHistorical +3 more
A Revolution is Coming
A Few Months after the Duel Between Cody and Dwayne.The Patriotic Republic is left with No more Founders, Left on its own a new evil has risen up and destroyed the Republic,In its place an Empire. Will The Remnants of the Republic Be able to take back its place or will it get destroyed This story is based on a lot of Revolutions
Short StoryHistoricalAdventureWarAction +3 more
Comes A Specter, Book 2
Six months ago, Anya Fleming's ten-year-old son, Willie-boy, found his father hanging in the barn. Traumatized over his father's suicide, the boy hasn't spoken a word since. Now, Willie-boy has come down with a grave, unknown illness and there's only one man who can save him, Sutter Sky, a learned Blackfoot shaman known as Yellow Smoke—a shaman who was once deeply in love with Anya. But Fate had other plans for Anya and Sutter—she was forced to marry Lewis Fleming, a cruel man who berated her night and day, and brokenhearted Sutter immersed himself in the mystical customs and beliefs of his People and became a shaman. As if Anya didn't have enough to deal with after her husband's death and son's illness, an evil, sinister ghost is terrorizing their ranch. Anya is convinced the spirit is Lewis, who apparently isn't done making her life miserable. When she turns to Yellow Smoke for help, will he put aside his bitterness and save Willie-boy? And can the renowned shaman dispel the powerful ghost from their li
MysteryHistoricalRomanceParanormalAction +3 more
Comes An Outlaw, Book 1
Western Romance When a tragic accident claims her husband's life, Jesse Santos must find a way to keep the ranch, the only home her 12-year-old son has ever known. The ranch hands have abandoned her, a gang of cutthroat ranchers want her land and an ancient Yaqui Indian insists a spirit has taken up residence in the house. After a fifteen-year absence, her husband's brother, Coy, returns to his childhood home. He doesn't plan on staying, and he certainly doesn't intend to settle down with a widow and her son…no matter how pretty she is. He's an outlaw, after all, and made a decision to put an end to his gun-slinging days long ago. Will his conscience let him walk away from family, or will his heart overrule his head?
ActionParanormalRomanceHistoricalMurder +3 more
Her Birthright
She was a princess but lived like a servant. She knew nothing of her identity and was content with the life she had. But one day the truth is revealed and with it comes a death threat . Can she claim her birthright without being killed? even if she succeeds will the decision of who to marry still remain her choice alone? what will happen to the love of her life? find out in this exciting historical romance novel set in Africa.
HistoricalLoveAdventureAdultRomance +3 more
She Falls to the Sky
All she has to do is protect The Lady and be free. But things take a different turn when she is betrayed. This is the story of why She Falls to the Sky.
HistoricalMurderThrillerShort StoryFantasy +3 more
The Gentleman's Code
"Win his trust and report to me." Lord Callum is the son of one of the world's richest men. He's also the youngest one. And with that, he was never expected to be the head of the family. Living a life of privilege and variety, he often spends his time in an unsuitable for his background company. Seeking the thrill and being easily bored with everything, he's unpredictable. Until one day Oliver- his new valet - shows up and that changes his whole life. Oliver is hired by Callum's father and the servant is supposed to report to the old Lord all of his son's actions and missteps. But something happens between Oliver and Callum that no one could have predicted. Warning: The story contains explicit content
BLHistoricalRomanceR-18BDSM +3 more
MEET ME ON THE BATTLEFIELD, bucky barnes
𝒐𝒐𝒐. ▎MEET ME ON THE BATTLEFIELD ⋆.∘༄⋅° ⤷❪ AVENGERS ! ❫ book one ━━━━━━━━ 💭🖇 ... ❛ meet me on the battlefield, ──── even on the darkest night. ❜ ▁▁▁▁▁▁▁▁▁ 𝗱𝗶𝗮𝗻𝗮 𝗽𝗿𝗶𝗻𝗰𝗲 was raised to be the princess of themyscira, born to be one of the greatest warriors of their small race. in the later years of the first world war, she defeated ares and stopped the fighting. but what happens if the second world war is one of mankind's own creation? ✎⤹: ❪ avengers. . . female!oc x male!c ❫ ❪ book one: the ❛querencia❜ series ❫ ❪ © -nephilims 2020 ❫ layout by artemisrage, cover by -nephilims, filter by pitlarrs on ig
Fan FictionFantasyWarRomanceHistorical +3 more
Ceaseless Gravity
"I want you. Yield to me..." he announced again, this time pinning her down the sofa. ~ 0 ~ When all is left in ruins, how would a princess live being held captive inside the mansion of her most hated captor? Her freedom all denied, true. But, not her will and heart.... Genre: Fantasy-Royalty, Historical Romance Status: Complete All Rights Reserved JMFelic Books 2020
FantasyRomanceHistoricalMysteryLove +3 more
Her Destined Ride
"What advice would you tell to your fourteen-year-old self?" An avid fan asked her. "Be patient and work hard until you become the epitome of success." She even stood tall and proud as she smiled to all of them. "Does Sunny Grainger have regrets?" That struck her in an instant. Of course. It's the only love that she miss out before she could even have a chance...
HistoricalMysteryLoveBillionaireParanormal +3 more
He crippled her fingers, killed her mother, and ruthlessly made her lose her baby. She hated her ignorance and destroyed her own eyes, and then she threw herself into the fire and never saw him again...
LoveRomanceHistorical +1 more
Magnolia Heat, Gay Fiction
Sexual scenes very erotic/hot Craven and his friend Anthony are in over their heads the night they're caught spying on Beresford Hall. When Craven meets the dark, mysterious Dominic Beresford, he wonders if fate really does step in and take you by surprise when you least expect it. Dominic Beresford has led a licentious existence, one that includes wealth, luxury and a carefree attitude when it comes to sexual liaisons . . . until the night he catches two young men spying on his property. Intending to frighten them into never breaching the privacy of another again, he takes them at gunpoint into Beresford Hall. He is inexplicably drawn to one of the young spies, Craven Saunders, and cannot fathom how this handsome young man was able to turn his world upside down in such a short time. Dominic's game of cat and mouse suddenly runs amuck. The question is . . . just who is the cat and who is the mouse?
LGBTQBDSMEroticPlayboyHistorical +3 more
Born to rule ('Born to be a slave' sequel)
Thea's dreams have come true. She has her new love, a new husband and a new life, but not everything is perfect. Being thrown into a world so different, then she had ever experienced, brings new problems in her life, more worries, which will need to be overcome to keep her happiness and her family together. Becoming a queen is the complete opposite of what she was before. She is happy, but for how long it will last? Thea will have to endure - with the help of others or completely alone. Will this be a journey of her life, that will break or make her stronger?
HistoricalRomanceLove +1 more
He's The Runaway, Girl
Disguised as a boy, Andrea flee from her home and work as a seaman in a pirate ship. When her parents and twin brother died in an accident, her mom's step sister moved in their house and tried to fornicate her future. But she will not allow them to suppress her and for the love of God, she will never let them waste her parents fortune. With a newfound determination, she makes her decisions, after she learned their plan to ruin her just so that she can't marry anyone except her scoundrel of a cousin. After she fled, she accidentally found out that there's a ship looking for a new seaman. Without a doubt that's her only salvation, so she decided to join their ship, without knowing that they are full of pirates. But it's too late now to backout
EroticRomanceHistoricalLoveBillionaire +3 more


Afaik I need to have LXML running in order for CP to parse the results from a private tracker.
"unable to execute x86_64-asustor-linux-gnu-gcc: No such file or directory"
You can't compile on Asustor. You need to cross compile on another system and the copy the files across.
Thanks for your reply. Can you give me a little more info? My knowledge of linux is rather limited.
Compiling this, then building into the App is on my to-do list... I'll try and update this App soon.
Can you enable debug logging (settings, general, debug), then restart couchpotato and try the search again?
Is there any more information in the logs?
Not sure why it's trying to open /inbox.php either.
However I cannot ssh into my box remotely to test this.
Looks like everything is working correctly now. Search/Send to Deluge all worked perfectly.


text:
Download Diary of a Prosecutor Episode 10
Home > Diary of a Prosecutor > Download Diary of a Prosecutor Ep 10 English Subbed
Not a member? Please create an account!
(Please use a valid email address to receive confirmation email!)
Choose Membership:
(Click here to check premium member benefits)
Free member (can't download videos)
$20.99 / 3 Months ( premium member )
$59.99 / 12 Months ( premium member )
Note: All downloadable videos are hosted on our servers and the servers fees are very expensive, so we have to charge premium member some money which will go to funding our server hosting fees. You can click here to check premium member benefits.
Already a member? Please sign in!
More diary of a prosecutor downloads
Download Diary of a Prosecutor Episode 1 1:04:15 High Definition
Download Diary of a Prosecutor Episode 10 1:05:42 High Definition
The story of two individuals who lost their loved ones in an accident and try to carry on with their lives as if they are not in pain.
Lee Kang Doo (Lee Joon Ho) grows up in a rich family and dreams of becoming a professional soccer player some day. But his life trajectory changes when a bad car accident kills his father and breaks his leg, ending his hopes of an athletic career. Kang Doo also loses his m......
A heartwarming family drama set in the year of 1988. The story will focus on five families live on the same alley road.
1988 was a big year in South Korea. It was the year of the Seoul Olympics, the 1988 College Festival and for the first time in many years, Koreans could travel outside of South Korea. Not only was 1988 a big year in the world of news, education and sports, it was a big year for music in......
Tomorrow With You
This is a 100% pre-produced drama. Filming began on 2016-Sep-05 and will be finished on 2017-Jan.
This drama is about a romance story between a time traveler and his wife. Yoo So Joon (Lee Je Hoon) is a CEO of a real estate company, who has the ability to travel through time via a subway. Song Ma Rin (Shin Min Ah) is her wife and works as a photographer. So Joon foresees his future-self living miserably s......
Time Between Dog and Wolf
Lee Soo Hyun belongs to a special international narcotic drug crime investigation unit. He witnessed the murder of his mother at the hands of a gangster as a child. Suh Ji Woo is the first love from Soo Hyun's childhood with whom he was seperated from. Soo Hyun is adopted into Kang Min Ki's family and both grew up to become NIS agents. Ji Woo and Soo Hyun are accidentally reunited when the beautiful Ji Woo caught the at......
An elite North Korean spy, Han Myung Wol, and her partner, Choi Ryu, infiltrates South Korea on a mission. Hijinks ensue when she falls in love with Kang Woo, a popular Hallyu star.......
Fashion 70s
Fashion 70's focused on the lives of four young people, from their childhood during the Korean War, to their careers and love lives within the booming fashion world of the seventies. When Joon Hee was young, she befriends a little girl called Kang Hee, this two girls always get into trouble because of Kang Hee's greedy mother. At the same time, Joon Hee also makes friends with two boys, Dong Young, the son of a military......


Get pre-approved today for your affordable, flexible vehicle loan. Review our current rates.
Are you thinking about buying a new or used auto, motorcycle, or RV? We offer affordable and flexible financing, with low rates and flexible terms.
Getting pre-approved before shopping for your next vehicle is a powerful negotiating tool. Before you even begin shopping for your vehicle, we can pre-approve your loan for the amount you feel you will need -- so you can shop and negotiate with confidence, knowing the financing is in place.
Refinance your High-Rate Vehicle Loan Today!
If you currently have a vehicle loan with another financial institution, Guthrie FCU can refinance your existing balance, and could possibly reduce your payment and remaining term.
To see if refinancing is in your best interest, simply complete this application and return it to Guthrie FCU. We promise you a quick response. Then you can decide!
If you're considering the purchase of a used vehicle, this complimentary GFCU service will make you aware of pre-existing conditions that may exist due to an accident or flood.
In the event of a total loss accident where the insurance company settlement does not cover the balance due on your loan, this insurance will pay the difference between the insurance company settlement and the loan balance. Click a link to learn about GAP and GAP Plus.
Information and research, new and used car listings, reviews, quotes, and shopping tools.


Jo Ann goes the extra mile!
Seventeen years ago, my husband and I wandered into a small real estate company in the tiny town of Round Top. Luck was on our side that Sunday afternoon, because Jo Ann Ayres was on duty. She immediately impressed us with her friendliness, professionalism, and "no-pressure" attitude. She guided us through the process of finding just the right place at an agreeable price. Best if all, she introduced us to a life in Round Top, and helped us settle into our new community. Jo Ann goes the extra mile.
It has been a couple of years since you orchestrated the sale of our Washington County farm. Judy and I are so thankful for your thorough analysis, welcoming approach to the potential buyers, and your studious approach to understanding the property's and owner's nuances.
All country properties with some acreage, like our old place, are different from most all others in one way or another, as you well know… Your historical real estate knowledge, network of other brokers specializing in the area, and total personal caring were all critical in working this particularly interesting property through the evaluation maze to a mutually agreeable closing with a buyer well matched to the property.
Judy and I thank you from the heart and highly recommend you to anyone interested in country property in you operational area.


text:
Pterocarpus indicus est un arbre de la famille des Fabacées, appelé aussi amboine (du nom de l'île où il a été découvert), bois de rose de Birmanie, ou sang-dragon. Son bois est utilisé en coutellerie d'art, notamment sa loupe, pour les manches des couteaux et pour le plaquage au début du , notamment à l'époque art déco.

C'est l'arbre officiel de la province de Phuket, en Thaïlande. C'est aussi l'arbre urbain le plus présent et le plus planté à Bangkok, ce qui est une source de risque d'épidémie en cas d'apparition de phytopathogène hautement pathogène pour l'espèce.

Galerie d'images

Références

Voir aussi

Article connexe
 Pterocarpus

Bibliographie

Liens externes

indicus
Symbole des Philippines
Espèce de Fabaceae (nom scientifique)
Arbre tropical


This course is a good option for those who are interested in developing the knowledge and skills needed for working in the health and social care professions.
You will learn about the values and principles of health and social care, and gain a volunteering skills award.
You will develop employability skills through volunteering.
We may consider application from people who do not have these qualifications.
Education: NC health and social care level 6 or other NQ higher-level courses within West Lothian College.


text:
Novel Techniques in the Surgical Management of Hepatocellular Carcinoma
By Vasileia Ntomi, Anna Paspala and Dimitrios Schizas
Submitted: April 5th 2018Reviewed: July 5th 2018Published: November 21st 2018
Home > Books > Liver Cancer
Hepatocellular carcinoma (HCC) is the most common primary liver malignancy with cirrhosis preceding its development in most cases. Surgical resection remains the primary therapeutic option despite the recent emergence of locoregional therapies. Novel surgical techniques are being proposed to overcome the limitations of traditional anatomical open liver resection. Laparoscopic resection is a safe and effective alternative to open liver resection, especially for left lateral or peripheral segment tumors. It is associated with less postoperative morbidity, intraoperative blood loss, and medial hospital stay with no difference in oncological outcomes. Robotic-assisted liver resection overcomes the technically difficult resection of tumors located at the posterosuperior segments with similar outcomes to laparoscopic resection. Associated liver partition and portal vein ligation for staged hepatectomy (ALPPS) procedure allows resection in patients with HCC, and associated major vascular resection or small future liver remnant (FLR) with long-term results yet to be announced. For patients with small solitary tumors or poor liver function, nonanatomical liver resection is a feasible therapeutic option due to minimal postoperative morbidity and similar oncological results of anatomical resection.
ALPPS
Vasileia Ntomi
Third Department of Surgery, National and Kapodistrian University of Athens, Attikon University Hospital, Greece
Anna Paspala
Dimitrios Schizas*
First Department of Surgery, National and Kapodistrian University of Athens, Laikon General Hospital, Greece
*Address all correspondence to: schizasad@gmail.com
Liver CancerEdited by Ahmed Lasfar
Edited by Ahmed Lasfar
Hepatocellular carcinoma (HCC) is the fifth most common malignancy and the third leading cause of cancer-related deaths worldwide [1]. Cirrhotic patients have the highest risk of developing HCC [2]. Numerous factors contribute to cirrhosis which precedes HCC development, including viral hepatitis, heavy drinking, and aflatoxin exposure. Hepatitis C epidemic in the Western world and Hepatitis B epidemic in China have attributed to the incidence of HCC [3]. However, HCC has a dismal prognosis, mainly due to the early recurrence; about 40% of patients that have undergone hepatectomy develop recurrence within the first year after surgery [2].
Although liver transplantation is considered as the ideal treatment, hepatic resection remains the only curative method of therapy for HCC. Other methods of potentially curative therapy are radiofrequency ablation (RFA), microwave ablation (MWA), high power focused ultrasound ablation (HIFU), and transarterial chemoembolization (TACE) [4, 5].
Novel surgical techniques are being proposed to overcome the limitations of traditional anatomical open liver resection. Laparoscopic and robotic resection as well as nonanatomical resection and ALPPS procedure have emerged as new and effective ways of surgical therapy for HCC.
The aim of this chapter is to analyze the aforementioned novel surgical techniques in the management of HCC and present the results from the relevant studies.
2. Laparoscopic liver resection for HCC
Laparoscopic surgery has become widely accepted as a feasible alternative to traditional open surgery for many surgical indications. The first laparoscopic hepatectomy was performed in 1992, for a benign tumor by Gagner et al. [6], and the first laparoscopic resection for HCC was reported in 1995 [7].
The liver presents many and significant technical challenges for minimally invasive techniques. Its mobilization is difficult, the space is limited, its vascular and biliary anatomy is complex and the parenchyma is fragile, friable and often fibrotic or cirrhotic [8]. Nevertheless, numerous studies have already shown the feasibility and safety of wedge resections, single-segment resections, and left lateral sectionectomies [9, 10].
The first international consensus conference on laparoscopic liver resection (LLR) was held in Louisville in 2008. It was suggested that the best indications for laparoscopic excision were solitary lesions less than 5 cm, located in the anterior segments. Also, the resection should be far from the hepatic hilum and the vena cava [11]. The second international consensus was held in Morioka, Japan in 2014, stating that anatomical resection for HCC is standard of care procedure, but the laparoscopic version needs to be standardized to increase propagation [12].
There are many reasons why laparoscopic major hepatectomy has not been widely accepted and performed yet. There are technical difficulties related to liver mobilization, vascular control, inability for manual palpation, access to posterosuperior liver segments, and intraoperative hazards such as gas embolism, massive bleeding, and bile duct injury [13, 14].
The benefits of laparoscopic surgery, though, have long been proven. Early postoperative ambulation, decreased respiratory complications, minimization of blood loss, minimal abdominal trauma, and less postoperative pain are some of the accepted benefits of laparoscopic surgery. For cirrhotic patients with HCC, the minimization of the surgical incision and the subsequent preservation of the abdominal wall circulation and lymphatic flow explains the decrease in postoperative liver failure and ascites formation [15].
The last decade, several meta-analyses of laparoscopic vs. open resection for HCC have been published [16, 17, 18, 19, 20, 21, 22, 23]. These meta-analyses have analyzed and compared the results of many nonrandomized control trials and case-matched studies. Three categories of outcomes were used to compare the two operative techniques:
Operative outcomes, such as operative time, operative blood loss, and number of patients that needed transfusion.
Postoperative outcomes, such as morbidity, mortality, and hospital stay.
Oncologic results, such as pathologic resection margins, incidence of port-site recurrence, disease-free survival (DFS), and overall survival (OS).
Jiang et al. [16] reported the superiority of laparoscopic liver resection (LLR) concerning the reduced intraoperative blood loss and blood transfusion, the expansion of the pathologic resection margins, the increase of R0 resection, and the shorter length of hospital stay. Laparoscopic resection has similar OS, DFS, and recurrence rate as open liver resection (OLR).
Sotiropoulos et al. [17], in a recent meta-analysis of 44 studies, showed that laparoscopic resection is superior to open resection in terms of resection margin and R0 resection. It is possible that this difference in resection margin and R0 excision is due to the smaller size of tumors resected in the laparoscopic group. It was confirmed that the laparoscopic technique is strongly associated with less blood loss, fewer blood transfusions, less postoperative pain, faster recovery, and shorter hospital stay. Operative time and tumor recurrence were not statistically different between LLR and OLR as well as the long-term oncological results such as OS and DFS. These results confirm those of previous authors [15, 18, 21, 22]. Hand-assisted laparoscopic or laparoscopy-assisted resections (hybrid group) gain statistical advantage over the OLR group concerning the negative resection margin width and influence the results in favor of LLR. They, however, showed no difference as to the OS and 30-day mortality compared to the OLR group.
The main concerns about LLR are the inadequate tumor resection margins and the potential risk of port-site recurrence. Tumor recurrence is the main cause of death in patients with HCC. The adequate tumor-free margin is a prognostic indicator of HCC [23]. Due to the lack of tactile sensation in laparoscopic surgery, the tumor location is sometimes difficult to determine. Intraoperative ultrasonography is a useful tool for precise identification of lesions and its borders [24, 25]. Another concerning factor is the risk of tumor peritoneal dissemination and port-site metastases [26, 27]. Interestingly, there has not been any evidence so far of tumor peritoneal dissemination or port-site metastases [20, 22]. The use of a plastic bag to remove the specimen can help to prevent this complication.
Concern has also been raised about the safety of laparoscopic techniques in cirrhotic patients. A plethora of patients with HCC also suffer from cirrhosis. Portal hypertension is a major risk factor for the development of postoperative decompensation [28, 29]. The benefits of LLR can be attributed to the preservation of the abdominal wall collateral circulation and the preservation of the round ligament which may contain significant collateral veins [18]. In a study by Tranchart et al., LLR had lower rates of liver decompensation, with the occurrence of postoperative liver failure and ascites ranging from 7 to 8% in LLR vs. 26–36% in OLR [30]. One study from Japan showed lower rates of morbidity, ascites formation, and shorter hospital stay following LLR with no difference in survival [31]. A recent meta-analysis presented intraoperative and postoperative outcomes of patients with known cirrhosis undergoing resection for HCC, comparing results for OLR and LLR [32]. This meta-analysis showed wider resection margins, reduced intraoperative blood loss and transfusion need, as well as reduced morbidity rates and shorter lengths of stay with the laparoscopic approach. Another study by Sotiropoulos et al. [33] mentioned the difference in results concerning cirrhotic patients that undergo LLR vs. OLR. The operative time was longer as anticipated, but the blood loss and morbidity had no statistical difference from the noncirrhotic group. The mortality rate was significantly lower in the cirrhotic subgroup when LLR was performed. Although patients with preserved liver function are the best candidates for LLR, cirrhotic patients benefit from LLR in terms of shorter hospital stay, complication rate, and long-term oncologic outcomes.
Tumor recurrence after primary HCC has been shown to be 30–70% at 5 years, limiting the overall survival of these patients [34, 35]. Numerous studies have been published reporting the results of repeat laparoscopic liver resection (RLLR) in patients with recurrent HCC [36, 37, 38]. A recent systematic review by Machairas et al. demonstrates RLLR as a safe and promising approach for the treatment of recurrent HCC, with significant benefits in terms of short-term outcomes with the oncologic adequacy not compromised [39].
The conversion rate has decreased from 5–15% [9, 40] to 4%, indicative of the surgeons' growing experience, with the most common causes being bleeding and failure to progress secondary to difficult exposure.
Overall, LLR can facilitate a safe and feasible approach to the surgical management of HCC. Major laparoscopic hepatectomy still remains a technically demanding procedure and should only be performed by highly experienced hepatobiliary surgeons with training in laparoscopic surgery. Longer follow-up periods are needed for more definite conclusions about the survival probability of the LLR vs. the OLR groups.
3. Robotic liver resection for HCC
Robotic liver resection (RLR) has been incorporated into clinical practice with increasing frequency since 2003 when the first report of a robotic liver resection was published by Giulianotti et al. [41].
Robotic technology was developed to overcome the technical difficulties of laparoscopic surgery; precision of movement, three-dimensional vision, magnification of the operative field, motion scaling, tremor filtering, and seven degrees of movement mimicking the human hand provide steady and careful dissection as well as prompt and precise endosuturing in case of intraoperative bleeding. A major advantage of the robotic technology in liver surgery is the dissection of the hilum and the hepatocaval dissection in right hepatectomy [42] as well as the possibility of biliary reconstruction due to the microsuturing capacity of the robotic system [43].
All published liver resections were performed using the da Vinci Surgical System (Intuitive Surgical Inc., Sunnyvale, CA USA). The major disadvantage of robotic surgery is the high cost due to the longer operating time and the instruments required, in spite of the similar hospitalization costs [44]. The purchase and maintenance costs are significant, and that is the reason for the limited incorporation of the robotic system in many facilities.
A large series by Tsung et al. [45] compared RLR to LLR and with the exception of operative time, and they found no significant differences comparing operative and postoperative results of RLR and LLR. The R0 status did not change, and the oncologic margin was not compromised. It must be highlighted that using a minimally invasive technique, a greater percentage of minor and major hepatectomies was completed; 93% of RLRs were accomplished in a purely minimally invasive manner compared with 49.1% performed laparoscopically.
Chen et al. [46] compared RLR with OLR for HCC providing superior short-term outcomes for RLR (shorter length of stay and decreased need for patient-controlled analgesia) and similar long-term outcomes (DFS and OS) despite longer operative times for RLR. A substantial proportion of patients suffered from cirrhosis and half of patients underwent major hepatectomy. They reported a DFS in 1 year of 91.5% with the RLR, whereas DFS was 79.2%. Overall survival in 1 and 3 years did not differ between the two groups. The authors reported that the patients treated with RLR had significantly wider surgical margins compared with OLR. This matched comparison offers support for further RLR in patients with HCC, performed by experienced surgeons.
Another study by Lai et al. [47] presented the results of RLR vs. LLR for HCC. Robotic group had longer mean operating time (207.4 vs. 134.2 min). Both groups had similar blood loss (334.6 vs. 336 ml) and no difference in morbidity. Mortality rate was 0% in both groups. They reported a comparable 5-year DFS and 5-year OS between RLR and LLR (42 vs. 38% and 65 vs. 48%, respectively) in patients with HCC.
Salloum et al. [48] included 14 studies in their systematic review, with HCC comprising the majority of the malignant cases. Mortality was 0%, and overall morbidity ranged from 0 to 43.3%, results comparable to laparoscopy. The mean duration of LOS was similar in both techniques. There was no statistically significant difference between RLR and LLR concerning the surgical margins or R1 resections. No clear advantages of RLR over LLR were noted; therefore, it is difficult to establish the true indications for RLR. Nevertheless, RLR has the same advantages as LLR in terms of shorter LOS and postoperative return to normal activities. Also, it seems that the learning curve for RLR is shorter than that of LLR.
The most recent systematic review from Tsilimigras et al. [49] included 31 studies with HCC being the leading indication among malignancies, comparing RLR to LLR or OLR. Median operative time was 295.5 min, EBL was 224.5 ml, conversion rate was 5.9%, and complication rate was 17.6% in the RLR group. The complications were graded according to the Clavien-Dindo classification [50], with the most common complication being bile leak (2.9%). In minor resections, the complication rate was 14.8% compared with the major resections, where the complication rate was 17%. Most of the studies show no benefit of RLR over LLR concerning safety and feasibility and multicenter, and randomized, prospective trials are needed to validate the exact indications and benefits of RLR.
Buchs et al. [51], in a systematic review of eight studies, compared RLR to LLR with the majority of the malignant cases being HCC (50.3%). There were minor and major hepatectomy procedures, and tumor size ranged from 8 to 120 mm. In the RLR group, there was no mortality, and the overall complication rate was 23.3% which fell to 19% when only postoperative complications were considered. A reduction of the conversion rate during major hepatectomy was reported as well. Overall, there was no clear outcome difference between RLR and LLR.
Ocuin et al. [52] included 14 major series in their review with the most common indication for resection being HCC. The estimated blood loss (EBL) ranged from 50 to 413 ml and transfusion rates from 0 to 44%. An overall conversion rate of 7% and an overall complication rate of 21% were reported. No perioperative mortality was associated with RLR. Length of stay (LOS) varied from 4 to 12 days. One study by Ji et al. showed a shorter LOS following RLR than OLR (10 vs. 7 days) [53]. Most series reported a high R0 resection rate with no port site recurrences. Recurrence rates following RLR were similar to those reported for LLR [9].
In conclusion, robotic liver resection is an acceptable alternative to open surgery with the robotic approach allowing an increased proportion of major hepatectomies to be performed in a minimally invasive manner [54]. These encouraging results should prompt the expansion of the robotic approach by highly specialized surgeons in experience centers worldwide.
4. Associating liver partition and portal vein ligation for liver surgery (ALPPS) for HCC
Surgical resection is the only potential curative treatment for hepatocellular carcinoma (HCC). In many cases, a major hepatectomy is required to achieve tumor-free surgical margins. However, the volume and functional reserve of the future liver remnant (FLR) are essential to avoid post-hepatectomy liver failure (PHLF), which is a crucial and important cause of morbidity and mortality after extensive liver resection [55]. In recent decades, some new strategies, such as portal vein embolization (PVE), portal vein ligation (PVL), and two-staged hepatectomy (TSH) have been developed to induce regeneration of FLR, minimizing the risk of PHLF and finally expanding the resectability criteria in HCC and generally in liver tumors [56]. Makuuchi et al. first introduced portal vein embolization into clinical practice in 1980s [57]. In 2015, a systematic review and meta-analysis from Pandanaboyana et al. compared PVL and PVE to assess the percentile increase of the FLR, morbidity, mortality, and tumor progression [58]. This meta-analysis revealed that the difference in the mean percentile increase in the FLR between those two techniques was not statistically significant, with similar results in morbidity, mortality, and disease progression.
In 2000s, Adam et al. first described the two-staged hepatectomy for liver malignancies in which a single surgical procedure was not possible [59]. The primary reason for the failure of TSH is tumor progression between two stages or an insufficient hypertrophy in FLR after the first stage of the procedure (portal vein occlusion).
An innovative, accelerated two-staged technique utilizing PVL and in situ split (ISS) of hepatic parenchyma was first described in 2012 by Schnitzbauer et al. [60]. In the same year, De Santibanes et al. named this procedure as ALPPS procedure (associating liver partition and portal vein ligation for staged hepatectomy) [61]. In 2007, ALPPS was first performed by chance by German surgeon Dr. Schlitt [62, 63]. In an attempt to perform an extended right hepatectomy for a perihilar cholangiocarcinoma, he intraoperatively realized that FLR was inadequate. He resected the liver adjacent to the falciform ligament after performing a left hepaticojejunostomy. The right portal vein was also ligated for the purpose of left lobe hypertrophy. Out of curiosity, on postoperative day 8, he performed a computed tomography (CT) scan. To his surprise, the left lateral section had extensively grown in size. He successfully removed the diseased liver in a second operation.
ALPPS indications are an FLR < 30% in patients with a normal liver or an FLR < 40% in patients with a cholestatic, steatotic or fibrotic liver [64]. Therefore, ALPPS can be performed for marginally resectable or locally advanced tumors with an inadequate FLR. This technique constitutes a surgical strategy for colorectal liver metastases, hilar cholangiocarcinoma, and hepatocellular carcinoma [64]. On the other hand, contradictions for ALPPS procedure include unresectable liver metastases in the FLR, unresectable extrahepatic metastases, severe portal hypertension, high anesthetic risks, and a poor condition of the patient prior to this major operation [64]. Patients with cirrhotic liver are less capable for hypertrophy of FLR after portal vein obstruction (PVL or PVE) than patients with healthy liver parenchyma. Vennarecci et al. reported that ALPPS for HCC is safe even when performing a major hepatectomy in a cirrhotic liver. They also mentioned that ALPPS induces a significant increase in FLR between the first and the second stage of the procedure and after hepatectomy, either in healthy or cirrhotic patients [65].
It has been reported that postoperative morbidity and mortality after ALPPS are 16–64 and 12–23%, respectively, with the main cause of morbidity being bile leakage and sepsis and the main cause of mortality being PHLF [66, 67]. In the latest systematic review and meta-analysis by Zhou et al., 719 patients were included, and the aim was to compare the regeneration efficiency, safety, and complication rates of ALPPS and TSH. The degree of FLR regeneration in ALPPS was significantly higher than that in TSH, and the interval of the two stages in ALPPS was obviously shorter than that in TSH. Bile fistulas were much more common after ALPPS with the reason being the liver splitting that is mandatory during this procedure. Although ALPPS had lower 1-year DFS rate, no significant difference in the 90-day mortality rate was discovered comparing the two techniques [66]. ALPPS was associated with a higher completion rate, a lower probability of tumor progression during the stage interval, and a lower insufficient regeneration rate; these findings are similar to those of previous studies [56, 67, 68].
Many variations of the ALPPS technique have been recently mentioned in the literature with the aim of improving safety and extending indications of hepatectomy. Modifications, such as avoiding liver mobilization and hepatoduodenal skeletonization, seem to prevent tumor spreading, adhesions, overall invasiveness, and parenchymal ischemia [69, 70, 71, 72, 73]. In addition, anterior approaches, portal vein embolization (PVE) as an alternative to ligation, partial liver splitting, tourniquet application or ablation procedures replacing parenchymal transection, and laparoscopic approaches represent fundamental modifications to the original ALPPS procedure that aim to improve safety [15]. The result of these modifications is the reduction of morbidity and mortality in this innovative surgical procedure. Furthermore, prospective controlled studies are needed to confirm which of these modifications should be considered as a reliable and safe alternative strategy to classical ALPPS.
5. Anatomical vs. nonanatomical resection for HCC
The incidence of HCC continues to increase due to the dissemination of hepatitis B and C virus infection. Hepatic resection is the gold standard treatment for HCC [74]. Nevertheless, postoperative recurrence of HCC, 3 and 5 years after hepatectomy is 50–60% and 70–90%, respectively [75, 76].
It is known that HCC invades mainly the intrahepatic vascular system and spreads along the portal and hepatic vein branches, producing intrahepatic metastases [77, 78].
Since Makuuchi et al. introduced the concept of anatomical resection (AR), the advantages of anatomic resection for HCC have been suggested in many studies [79]. On the other hand, limited nonanatomic resection (NR) with a minimal safety margin may be preferred for patients with impaired liver function [80]. Tanaka et al. showed that microscopic vascular invasion was more important than tumor size as a predictive factor for local recurrence [81].
Anatomical liver resection is a plausible option for patients with HCC, as HCC tends to cause intrahepatic metastasis through vascular invasion, and its advantages in improved OS or DFS for HCC patients have widely been reported [82].
In a systematic review of Cucchetti et al., AR seemed to yield improved 5-year OS and DFS compared to NR [83]. Zhou et al. [84] and Bigonzi et al. [85] presented significantly improved 5-year OS with AR.
Nonanatomic resection is recommended for patients with impaired liver function [86, 87]. The plausible reason is that NR can preserve as much functional liver as possible, with surgical curability and hepatic function equally important [87, 88]. The preservation of hepatic functional reserve allows effective treatment options in HCC recurrence, which may also improve the long-term prognosis [87, 89].
The superiority of anatomical resection (AR) over nonanatomic resection (NR) for hepatocellular carcinoma (HCC) remains controversial. Marubashi et al. reported no significant differences in OS, DFS or recurrence within 2 years after hepatectomy between the AR and NR groups [90]. Likewise, Tanaka et al. reported no outstanding difference in the recurrence rates and OS between AR and NR patient groups; it was also stated that survival rates after recurrence and median survival time after recurrence were higher in the NR group compared to the AR group for patients with a solitary HCC confined to 1 or 2 liver segments [91]. Chen et al. reported in their meta-analysis that AR contributed to better DFS, but did not improve OS [92]. Thus, the superiority of AR over NR is still controversial. Furthermore, Yamamoto et al. reported that AR is associated with more perioperative risks. The same study revealed significantly greater intraoperative blood loss and longer postoperative hospital stay for the AR group [82].
In 2010, Yamashita et al. [80] published a retrospective study of 321 patients with HCC. About 120 patients underwent limited nonanatomic resection (NR) for a single HCC < 5 cm. In noncirrhotic patients (n = 215), both 5-year OS and DFS rates in the AR group were considerably better than those in the NR group (87 vs. 76% and 63 vs. 35%, respectively). In cirrhotic patients (n = 106), both 5-year OS and DFS in the AR group were worse than those in the NR group (48 vs. 72% and 28 vs. 43%, respectively).
According to their results, the width of the resection margin did not influence postoperative recurrence, and major hepatic resections did not improve patients' survival. The main disadvantage of AR in comparison with NR is the limitation of a repeat resection, which would be the most effective treatment for recurrence, because of its disadvantageous effects on remnant liver function [93, 94].
In conclusion, there is a need for more, large, prospective, multicenter studies to confirm the data about any possible superiority of nonanatomic resection for HCC.
Hepatocellular carcinoma is a malignancy with an increasing incidence and a dismal prognosis. Patients are often referred to specialists in an advanced stage of the disease. Surgery is the primary treatment and novel surgical techniques are developed offering better perioperative and oncological results (Table 1). Nevertheless, prospective, randomized controlled studies have to be designed for the confirmation of such possible advantages of those new surgical techniques.
Laparoscopic resection
Early ambulation
Decreased respiratory complications
Minimal abdominal trauma
Less postoperative pain
Decrease in PHLF
Reduced blood loss
Shorter length of hospital stay
Increase of R0 resection
Vascular control
Difficult access to posterosuperior segments
Massive bleeding
No manual palpation
Longer operative time
[13, 14, 15, 16, 17, 23, 26, 27]
Robotic resection
Precision of movement
3-dimensional vision
7 degrees of movement
Precise endosuturing
Dissection of the hilum
Biliary reconstruction
Shorter length of stay
High cost
Specialized surgeons
[42, 43, 44, 46, 54]
Increase in FLR
Application to cirrhotic patients
Marginally resectable tumors
Locally advances tumors
Severe portal hypertension
High risk patients
High rates of post-operative morbidity and mortality
Bile leakage
Nonanatomical resection
Repeat resection
Impaired liver function
No difference in recurrence rates
Less intra-operative blood loss
Cirrhotic patients
Worse 5-year OS and DFS
Width of resection margin
Microscopic vascular invasion
[80, 81, 83, 84, 85, 90, 91, 93, 94]
Advantages and limitations of novel surgical techniques for hepatocellular carcinoma management.
2.Laparoscopic liver resection for HCC
3.Robotic liver resection for HCC
4.Associating liver partition and portal vein ligation for liver surgery (ALPPS) for HCC
5.Anatomical vs. nonanatomical resection for HCC
6.Conclusion
Vasileia Ntomi, Anna Paspala and Dimitrios Schizas (November 21st 2018). Novel Techniques in the Surgical Management of Hepatocellular Carcinoma, Liver Cancer, Ahmed Lasfar, IntechOpen, DOI: 10.5772/intechopen.79982. Available from:
Metabolic Risk Factors in Hepatocellular Carcinoma
By Andra-Iulia Suceveanu, Laura Mazilu, Andreea-Daniela Gheorghe, Anca Pantea Stoian, Felix Voinea and Adrian-Paul Suceveanu
Colorectal Cancer BiologyFrom Genes to TumorEdited by Rajunor Ettarh
Colorectal Cancer Biology
Edited by Rajunor Ettarh
Colorectal Cancer: It Starts and It Runs
By Rajunor Ettarh


text:
Ereignisse

Politik und Weltgeschehen

Westeuropa

 Heahberht wird von König Offa von Mercia als König in Kent eingesetzt. Er ist Nachfolger des Eanmund. Zeitgleich beansprucht auch Ecgberht II. den Königstuhl und kann sich 771 schließlich auch durchsetzen.
 Ealchred wird König von Northumbria. Er folgt auf Æthelwald Moll.

Osteuropa

 Subin wird Khan der Bulgaren; er löst Telez ab.

Nordafrika

 Die Banu Ifran gründen ein Kalifat im westlichen Algerien.

Urkundliche Ersterwähnungen

 Erstmalige urkundliche Erwähnung von Aachen, Andiast, Bensheim, Breil/Brigels, Castrisch, Domat/Ems, Ebertsheim, Edingen, Eggenstein, Falera, Flims,  Großgartach, Handschuhsheim, Ilanz, Kirchzarten, Luven, Obersaxen, Riein, Rueun, Ruschein, Sagogn, Schlans, Trimmis, Trun, Valendas, Waltensburg/Vuorz und Wiebelskirchen
 Gründung der Stadt Tuadon, des späteren Kunming

Wissenschaft und Kultur

 Eine Handschrift aus der Abtei Corbie zeigt erste Ansätze einer karolingischen Minuskel.

Religion

Christentum

 Übertragung der Gebeine des Hl. Nazarius ins Kloster Lorsch
 Übertragung der Gebeine der Heiligen Nabor und Felix nach Saint-Avold

 Um 765: Gründung des Klosters Herrenchiemsee und des Klosters Tegernsee

Islam

Nach dem Tode des schiitischen Imams Dschaʿfar as-Sādiq kommt es zu einer erneuten Spaltung unter den Schiiten: Die Imamiten entscheiden sich für Mūsā al-Kāzim, die Ismailiten für Ismāʿīl ibn Dschaʿfar.

Geboren

 um 765: Alfons II., König von Asturien († 842)

Gestorben

 10. November: Junnin, japanischer Kaiser (* 733)
 20. oder 28. November: Stephanos der Jüngere, byzantinischer Theologe (* um 713)

 Dschaʿfar as-Sādiq, sechster Imam der "Siebener-Schiiten" (Ismailiten) (* 702)

 um 765: Bischof Tello von Chur

Weblinks


Sure, it won her an Emmy and made her more famous than ever before, but two and a half years later, did Tina Fey's dead-on impersonation of Sarah Palin hurt her in the long run? According to Fey, you betcha.
Fey writes about her stint playing the former Vice Presidential candidate in her new memoir, 'Bossypants,' in which she claims it prevented her Emmy-winning comedy '30 Rock' from gaining viewers.
"My TV show still enjoys very low ratings. In fact, I think the Palin stuff may have hurt the TV show. Let's face it, between [co-star] Alec Baldwin and me there is a certain fifty percent of the population who think we are pinko Commie monsters."


text:
Q: How to convert a DateTime string to a DateTime in SQL Server I have a DateTime varchar in this format: 2005-08-08T00:00:00+01:00.

*

*Does this format have a name? (it's not ISO8601. Is it RFC3339?)

*How can I convert it to a DateTime using Transact-Sql?

EDIT
Here's a summary answer, cobbled together from others input:

*

*It is ISO8601 with a time offset from UTC. If it was UTC it would end with a 'Z' instead of '+01:00'.  wikipedia

*You can convert it to local time or to utc as follows:

DECLARE @d VARCHAR(25) SET @d = '2007-08-08T00:01:00+01:00' SET @d =
  '2007-08-08T00:01:00-01:00' SET @d = '2007-08-08T00:01:00+05:30'
SELECT @d as Input, CONVERT(DATETIME, LEFT(@d, 19), 126) AS LocalDate
  , DATEADD(MINUTE  , -CAST((SUBSTRING(@d, 20, 1) + RIGHT(@d, 2)) AS
  INT)  , DATEADD(HOUR
         ,-CAST(SUBSTRING(@d, 20, 3) AS INT)
         , CONVERT(DATETIME, LEFT(@d, 19), 126))) as UtcDate WHERE @d LIKE '_--_T__::[+-]:'

Results:
Input                     LocalDate               UtcDate
------------------------- ----------------------- -----------------------
2007-08-08T00:01:00+01:00 2007-08-08 00:01:00.000 2007-08-07 23:01:00.000

2007-08-08T00:01:00-01:00 2007-08-08 00:01:00.000 2007-08-08 01:01:00.000

2007-08-08T00:01:00+05:30 2007-08-08 00:01:00.000 2007-08-07 18:31:00.000

A: Its ISO8601 with time zone Z
use
SELECT CONVERT(datetime,'2005-08-08T00:00:00',126)

see
MSDN Explanation
EDIT:
I think it something to do with the zone on the end I originally assumed tSql would accept that but turns out it wont.

A: You can do it a really ugly way, where you get the date first, then get the time and add the offset as hour:
declare @d varchar(50)
set @d = '2005-08-08T00:00:00+01:00'

select Convert(datetime, left(@d, 10))
    + DateAdd(hour, Cast(substring(@d, 21, 2) as int), convert(datetime, substring(@d, 12, 8)))

or a consolidated version:
SELECT DateAdd(hour, Cast(substring(@d, 21, 2) as int), CONVERT(datetime, LEFT(@d, 19) ,127))

Final Result:
2005-08-08 01:00:00.000

if you don't need the offset, then:
declare @d varchar(50)
set @d = '2005-08-08T00:00:00+01:00'

select Convert(datetime, left(@d, 10))
    +  convert(datetime, substring(@d, 12, 8))

Result:
2005-08-08 00:00:00.000

A: In SQL Server 2008 you can use the datetimeoffset data type.
SELECT [Result] = CONVERT(datetimeoffset, '2005-08-08T00:01:00+01:00', 127)

Output:
Result
----------------------------------
2005-08-08 00:01:00.0000000 +01:00

In SQL Server 2005 and earlier you can compute the UTC date and offset:
SELECT [LocalDate], [OffsetMinutes], [UtcDate]
FROM
(
    SELECT [IsoDate] = '2007-08-08T00:01:00+01:00'
) A
OUTER APPLY
(
    SELECT [LocalDate] = CONVERT(datetime, LEFT([IsoDate], 19), 126)
    , [OffsetMinutes] =
        CASE SUBSTRING([IsoDate], 20, 1)
            WHEN '+' THEN +1
            WHEN '-' THEN -1
        END
        * DATEDIFF(minute, 0,
            CAST(SUBSTRING([IsoDate], 21, 5) + ':00' AS datetime))
    WHERE [IsoDate] LIKE '____-__-__T__:__:__[+-]__:__'
) B
OUTER APPLY
(
    SELECT [UtcDate] = DATEADD(minute, -[OffsetMinutes], [LocalDate])
) C

Output:
LocalDate               OffsetMinutes UtcDate
----------------------- ------------- -----------------------
2007-08-08 00:01:00.000 60            2007-08-07 23:01:00.000

A: Per the selected answer, datetimeoffset is a good solution.  However, be careful sql server side with built in functions.
(I tried to paste this as a comment to the accepted answer, but it would not format the code sample)
select GETDATE(), CONVERT(datetimeoffset, GETDATE(), 127), CONVERT(varchar, convert(datetimeoffset, getdate(), 127))
-- Ugg! a SQL Server Bug!!!
-- 2013-08-16 12:54:54.090  2013-08-16 12:54:54.0900000 +00:00  2013-08-16 12:54:54.0900000 +0

select GETUTCDATE(),convert( datetimeoffset, GETUTCDATE(), 127), convert(varchar, convert( datetimeoffset, GETUTCDATE(), 127))
-- 2013-08-16 16:54:54.090  2013-08-16 16:54:54.0900000 +00:00  2013-08-16 16:54:54.0900000 +0

A: If you need datetime2 output
declare @dof datetimeoffset;
set @dof = cast('2005-08-08T00:00:00+01:00' as datetimeoffset);
select dateadd(minute, datepart(tzoffset, @dof), cast(@dof as datetime2));

-- returns 2005-08-08 01:00:00.0000000