21:46 - Erik M. ...so that at least all references are in the same FILE, but not on the same sheet. Changing all that is way too time-consuming, so I just accept it's not possible. Or at least, I don't think it's possible.
21:40 - Erik M. To answer your questions, I tried to change the cell references. I like all my references in one sheet, and I don't want references in another file. So now I just copy the sheet I want + reference sheet to the file...
21:36 - Erik M. No, I have lots of different files with mass balances of different process configurations. Sometimes I need to combine sheets from different files, which at first I had problems with, but now not so much anymore.
21:27 - Erik M. Well, I work with Excel a lot as well for my job, so I've already learned a lot. But seeing as I'm a process engineer, I'm not sure whether you could help me. I mainly set up mass balances in Excel and do lots of calculations.
21:25 - Jaeryd17 What kind of formula changes are you trying to make? Changing the reference to a different file name, or just changing cell references?
21:13 - Zaphod Jooe, [link] You'll probably like this.
French band Nightmare is bringing us some more heavy metal this year with a new album. The band just announced their new album that will be called The Aftermath. The opus will be released via AFM Records on May 23rd. While there is still much to discover about the album, for now you can take a look at the cover art below.
British progressive metallers Aeon Zen are back with their new upcoming opus entitled Enigma, which is an ambitiously creative and powerful concept album featuring nine tracks showing the strengths of the band, as well as two bonus tracks. The album will be released on January 22nd, 2013 through Nightmare Records. It was produced, mixed and mastered by Rich Hinks.
"Sunrise In Hell", a brand new video from French symphonic power metal outfit Nightmare is now available for viewing below. The song is taken from the band's latest output The Burden Of God, available now via AFM Records. The video was directed by Stéphane Gilbart and edited by Richard Gonord.
French metallers Nightmare have unveiled the cover artwork for their new album, entitled The Burden Of God (formerly Mercury Rain). The album, which was recorded at the Peek studios in the south of France with producer Patrick Liotard, will be released on May 18 through AFM Records.
French metallers Nightmare have recorded a cover version of the song "Where Dragons Rule", taken from the Crimson Glory album Transcendence, as a tribute to vocalist John Patrick Jr. "Midnight" McDonald. The former Crimson Glory frontman Midnight passed away on Wednesday, July 8th, 2009, due to total kidney and liver failure. He was 47 years old. The song can be heard at this location.
Denmark's Anubis Gate has inked a deal with Nightmare Records. The band has also parted ways with singer Jacob Hansen replaced him with Henrik Fevre.
Commented the group: "Nightmare Records is a label that we have had our eyes on for some time, but due to contractual obligations with our old label we haven't been able to join them before now. Needless to say, we are very excited about signing with Nightmare who we feel is the perfect home for our music. With a record label that really loves music (and those are few and far in-between) the future for Anubis Gate looks brighter than ever."
On the topic of the singer switch, Anubis Gate said, "With Jacob's ever-more-demanding schedule as a first-class producer, Jacob found it hard to have the time and keep his heart in the band. We fully respect his decision and reasons to leave and want to thank Jacob for being with us for an amazing couple of albums. We are still very good friends and Jacob is still involved in shaping the new album in his capacity as the best producer in metal. We wish Jacob nothing but the best in his future career. Anubis Gate has always been blessed with great singers. The decision to have Henrik take over vocal duties is a natural one for us. Henrik is the one that for a big part shaped the vocal melodies and lyrics of Anubis Gate and when Torben had to bow out of the gigs we did in support of A Perfect Forever it was Henrik who sang those gigs. Henrik has also had several songs on our albums where he performed lead vocals. Most notably "Take Me Home" on the Andromeda Unchained album. So we knew beforehand it would work out great, which it certainly has."
Kevin Foley, drummer for French death grind masters Benighted, is on board with Nightmare for a couple of shows on the Insurrection Campaign World Tour - Part II.
Nightmare's permanent drummer, David Amore, is forced to miss the dates due to some personal reasons out of his control. Kevin already checked in at the Savoie Rock Fest last Saturday in Albertville, France. Check out footage from the performance on Nightmare's TV Channel.
David will still play the DevilStone Festival, while the rest of the dates including will feature Kevin on drums:
July 17th - DevilStone Festival - Lituania with David on the drums.
July 24th - Woodstock Festival - Borkovany, Czech Republic,
August 07th - Wacken Open Air - Germany
French metallers Nightmare have posted online a new song, "Legions Of The Rising Sun", on their MySpace page.
"Legions Of The Rising Sun" comes off the band's forthcoming album, "Insurrection", which is scheduled for release on September 11 through AFM Records. The album was recorded at Peek studio in France with Patrick Liotard and at U3multimedia and Indiscreet Studios in Stuttgart, Germany with Achim Koehler (Primal Fear, Edguy, Masterplan).
"Insurrection" cover art] songtitles set to appear on the album:
Three Mile Island
The Gospel Of Judas
Angels Of Glass
Legions Of The Rising Sun
French metallers Nightmare have posted online a video for the song 'Final Procession' which can be viewed here.
The song comes off the band's latest album, entitled "Genetic Disorder", which was released on October 31, 2007 in Europe via Regain Records. The CD was recorded at Studio Fredman in Gothenburg, Sweden with producers Fredrik Nordström and Henrik Udd (In Flames, Hammerfall, Dimmu Borgir, Arch Enemy).
French Heavy Metallers Nightmare have posted two new videos online.Check out a live clip of the band performing 'Heretic' at France's Hellfest in 2006 at this location.
Also, footage of the band performing 'The Legend' during their comeback gig in Grenoble, France in 1999 can be see at this location.
This week, Nightmare began recording their sixth studio album. After 3 albums produced by Norwegian producer Terje Refsnes, the band has now opted for a new challenge.
The recording is taking place at the famous Fredman studio in Gothenburg, Sweden and the album will be produced by Fredrik Nordström (Dimmu Borgir, In Flames, Hammerfall, Dream Evil, etc.).
The group's follow-up to 2005's "The Dominion Gate" will be released by Sweden's Regain Records in fall, 2007, followed by full French tour and European dates.
It has come to our knowledge that several Nightmare - The Dominion Gate albums were delivered to the stores without booklets!
Nightmare and Regain Records are of course very sorry about this, and we will try to make it up to you, by sending you the booklet in arrears.
If you just mail us info about where you bought your album, wich date and your adress, we´ll send you a booklet as soon as possible. Please mail your info to following adress: firstname.lastname@example.org
Our deepest apologizes and thanx for supporting Nightmare and Regain Records!
Per Bussmann on behalf of Nightmare and Regain Records
Toronto's Warmachine have signed a one-album deal with Nightmare Records. "We're looking at a September realease date in Central America for 'The Beginning of the End'," vocalist/guitarist Joe Di Taranto writes on the group's web site. "Canada should follow shortly after. Deals for Europe and Japan are still in the works as well.
"I am very excited about this new partnership with Nightmare Records. I can't wait for everyone to finally get this album in their hands.
"Thanx for all your patience and support throughout this ridiculously long wait. More big news to come soon..."
"The Beginning of the End" features a guest appearance on three tracks ("Betrayed", "Empty" and "Taunted Souls") by former MEGADETH bassist David Ellefson.
The french band, that recently parted ways with Napalm Records, have inked a deal with Regain Records.
The band counts now with a new guitarist, Franck Milleliri (ex Dark Light), who will be replacing Nicolas De Dominicis, this is the current Nightmare line-up:
Jo Amore ( Vocals )
Yves Campion ( Bass )
Alex Hilbert ( Guitars )
Franck Milleliri ( Guitars )
David Amore ( Drums )
The band is currently recording the drums, and are in pre-production mode with help of Damien Flammarion, after that they will enter in the studio on 11 of April with producer Terje Refsnes. The tentative title of the new album is "The Domion Gate" and is scheduled to be out on October. There is a guest confirmed to take part on the album, Rick Marx (ex Pretty Maids guitarist), and other guests are expected.
"We have parted ways with NAPALM Records very amicably... We will never forget what this label has done for us so far... giving us the breath for a second birth in 1999... NAPALM RECORDS being actually focusing into a completely different music style from what we offer, we simply decided all together that it would be better for us to find a more suitable label for what we have to offer..."