LosOjos

Yeah I am hoping the i3 will be just fine, there won't be a lot of multi tasking going on and AFAIK, there are very few games that take advantage of more than 2 cores. I learned the hard way not to skimp on these! Really chuffed with the case here actually, it'll fit perfectly with my AV amp (to be fair, that's what it was designed to do). I really rate these Corsair CX series PSUs too, you can tell some corners have been cut to get the price down compared to their CS range but they're fantastic for the price, haven't had a problem with one yet. I did notice that but haven't heard of HIS so dodged them TBH - are they OK? Another mistake I've made in the past is buying the cheapest version of the GPU with no regards to manufacturer - had a fair few PowerColor units turn up DOA! (That was a few years back, they may have improved now)

@Gatt - how did you find Aria PC? Never heard of them before but I might give them a try later. I've put my machine together on OC, Scan and eBuyer so far looking for the best fit. Overclockers wins at the moment as they have the Guardia case I want and the saving I make on that over alternative cases elsewhere allowed me to go from a 270 to a 270X. I'm limited as to where to buy from as it'll be a finance purchase.

That's what I suspected. I used to insist on AMD back in the day, then after a few years break where I didn't build a single PC, came back to find that Intel owned the market. I wonder where things went wrong for AMD? The old Athlon range used to whoop Pentium for gaming (though Pentium did have the upper hand for multi tasking even back then). Now it seems that AMD are lagging behind in all aspects but their APU, and that's probably thanks to buying out ATI a few years back...

I know that traditionally an HTPC is a small form factor machine decidated to media, but this will be something of a hybrid. It's likely to see equal use between movies/streaming and Steam. I suppose a better name for it then would be an HEPC (Home Entertainment PC)

Yeah I did think about that but decided to put the money in to a decent GPU (the R9 270 is better than the GTX560 in my main PC and that handles everything I play well enough for me at 1080p - not ultra in all games but more than adequate for me). The main thing that was pulling me towards an APU was the option of building the whole thing in a tiny ITX case, but the case above will fit nicely under my AV amp and actually looks quite similar too, which pleases the missus. Just out of curiosity - is the general consensus that AMD APUs are better than Intel ones?

Did make me laugh - wonder how may times the link has been sent to Brian Cox so far?

As we're now all PC gamers in my house, I decided that I finally had a damn good excuse to build a gaming capable HTPC. I don't have the budget to build an all out beast but I think I've specced up a decent rig with a good upgrade path for my £600 budget. Already have a Win7 licence for it, a PCI-e wireless adapter (won't need this right now as it'll be wired, but may need it when we move house) and wireless KB/M and we all have our own wired Xbox pads to use with it. The plan is to run XBMC in Win7 with a link to Steam Big Picture - there is no intention for this machine to be used for anything else as we already have my main rig for general use and my daughter also has her own PC in her room now - this one's purely for entertainment. Please take a look at my spec below and let me know what you think. The one thing I've been obsessing over is the CPU - I've gone the Intel route despite the fact that AMD offer theoretically faster CPUs at this lower price point, but I think an i3 will stand up for the next 12 months at which point I should be able to upgrade to an i5 if necessary and this is why I decided on Intel - there seems to be a better upgrade path. As the other two machines in the house are also 1150 based, it means that when I upgrade any of them, I can roll out a small upgrade to the other machines too. The spec: Case - Silverstone Grandia GD05 Desktop HTPC Case PSU - Corsair Builder Series CX 430w Modular '80 Plus Bronze' Mobo - Gigabyte H87M-HD3 Intel H87 (Socket 1150) DDR3 Micro ATX CPU - Intel Core i3-4130 3.40GHz (Haswell) Socket LGA1150 RAM - Avexir MPower Yellow Series 8GB (2x4GB) DDR3 PC3-12800C9 HDD (may add in a boot SSD later, for now I feel a SSHD offers a decent balance between cost/performance/storage) - Seagate SSHD 7200RPM 1TB SATA 6Gb/s 64MB Cache ODD - OcUK Value 4x BD-ROM GPU - Gigabyte Radeon R9 270X WindForce 3X OC 2048MB Any suggestions on where I could improve this rig without tipping the £600 mark? This currently comes in at £595.92 - can't get much closer than that!

Never heard of this before, interesting Found this site explaining how to make the conversions too which I found interesting (it's aimed at programming a converter in Java but all the math is there) Java – Convert IP address to Decimal Number

Cheers - it's about a 40 minute drive but he'll definitely need a van to transport it, if he can get it and wants it though that'd be great!

Update: missus is now threatening to leave it out for the scrap man

OK I've shifted this now via freecycle However, can I interest anyone in a muti gym? lol http://www.edugeek.net/forums/classified-adverts/129593-marcy-multi-gym.html

Thanks for the heads up - what are they playing at?! Spambots are going to love this.

You can't delete them as such, but as long as they're empty they're as good as gone. Now I must admit, I haven't tried headers/footers recently so there's a chance SIMS handles them fine now, I have so little time to experiment these days though I tend to stick to my tried and tested methods! Another alternative is to script the macro as VBS, so rather than embedding the code inside the document you could export the reports from SIMS, run them through the VBS to clean them up, then print them. Problem then though is that the linked documents version will still contain the rows you want removing!

Installing an EA game is kind of like that

You can do this with macros in the "ThisDocument" module of your template, but there is a caveat - if you upload the document to linked documents, VBA will throw an error if anyone tries to open it (unless they have macros disabled). The problem is that your template document references a file called IndRepBaseTemplate.dot, but when the file is opened via linked documents, that reference is missing which will cause VBA to throw a random unrelated error (very helpful!). I opted to still use macros as the upload to SLG works fine and it makes printing from Individual Reports quicker for me. I've put the code I use below as an example, but you will need to tweak it. In my template, there is a table used as a header (as headers/footers cause Ind Reps to run extremely slowly) followed by the table with the grades in. That table's final column is an effort grade, hence the check for the last but one column containing data. Anyway, here's the code, let me know if you need more guidance on tweaking it for your needs: Private Sub Document_Open() On Error Resume Next Dim x, y As Integer With ActiveDocument.Tables(2).Columns(ActiveDocument.Tables(2).Columns.Count - 1) y = .Cells.Count 'check we're not in template editing mode If Left$(.Cells(2).Range.Text, 1) <> "<" Then 'delete rows containing no grade For x = 2 To y If x > y Then Exit For If Asc(Left$(.Cells(x).Range.Text, 1)) < 32 Or _ Asc(Left$(.Cells(x).Range.Text, 1)) > 126 Then .Cells(x).Row.Delete x = x - 1 y = .Cells.Count End If Next x 'fake document save to suppress warnings ActiveDocument.Saved = True End If End With End Sub

That's because you know how to change RAM, which RAM to buy, whether it's compatible etc. The way I see it, the point of a machine like this is for people who don't have the technical knowledge to build a highly customised gaming PC but want to get in to PC gaming - this way, they just buy a new module, slot it in and hey presto, they've upgraded their gaming rig. That's why I say, this couple with SteamOS (again, big if SteamOS takes off here) could be serious competition for the console market

I wish he talked more about how it works i.e. are the traditional mobo components built in to the tower or is that one of the modules? As to the proprietary connection, I wonder if there's a custom PCB inside the module or simply a mounted PCI-e card with PCI-e to proprietary adapter inside (a la external HDD caddys) It's a very interesting idea though and I think something like this pre-loaded with SteamOS (if Valve can get that to take off) could seriously open up PC gaming to the console crowd... in fact, it's a very similar idea to what a few of us were talking about when Valve first announced SteamOS early last year.

Yeah I might try that tomorrow, talk about short notice!

Woops! Thanks for pointing that out; it's not dollhouse furniture!

Well I have a new sofa that wasn't due to be delivered for another 4 weeks but has suddenly decided it's coming next week! As a result, I need to shift my old sofa and armchair quickly. Listed on eBay, no reserve, for collection from Walsall preferably this weekend but can push to Tuesday, for obvious reasons Monday/Tuesday collections would have to be after 6:30PM: Beige/Chocolate Brown 3 seat sofa and armchair *NO RESERVE - QUICK SALE* | eBay

OK, been given my orders, this has to be gone this week! If anyone is tempted but money is tight (it is January after all!) then I'm willing to let you take it on trust that you'll pay me when you have the cash (only if you're a regular on here of course - not trusting a first time poster I'm afraid!) So - can't I tempt you?

"Gato Gruňón" "Me Gusta Guavas" All the memes.

Then you need to edit the formula to reference the sheet in your template rather than the other workbook; if you maintain the same sheet names, you can do a find an replace to fix it like so: As an example, we'll assume the original workbook was called "Book1.xlsx" and the sheet was called "Sheet1" - if you look at a formula referencing the original workbook, you'll see the references begin '[book1.xlsx]!Sheet1' To fix them, you simply remove the reference to the original workbook using find and replace, replacing the reference with a blank and making sure to match case and check within forumlas rather than values. In the example, this would look like so: Note that the "Replace with" text box is completely blank - if you put a space in there you'll break the formulas. Final note - make a backup before you try this, just in case!

Yeah the boss that I died a couple of times trying to fight... lol. Yeah the combo trainer was very useful actually, one of the few examples of a game forcing me to do a "side quest" that was actually necessary, I think I'd have been screwed in the temple if I hadn't seen that first. I'm enjoying the humour in game too, although I think that epilieptic fit warning needs to be bigger and more definitie - learning a new move? I nearly had a fit!

Copy all the sheets you need from the other workbook in to your template workbook and hide them. Then you can copy from those sheets within the template workbook instead