NeoGen

1 hour ago, max said:

Bear in mind that if you sell or give away CDs then you must also delete any backups you may have put on digital media.

 

When you buy the CD you also buy a licence to play it. Similarly, when you sell on your CD you sell on the licence. 

 

Plainly written here:

Popular myths about copying and sharing MP3s and CDs

Gee thanks, so helpful

Hi Metalman, there is probably 300-400 CD's of mixed genre anything from The Jam, The Police, Natasha Bedingfield BBC Live Lounge etc. 

Many thanks butlers, I will look at these.

Regards

N

Hi all, 

I'm in the process of moving and being ruthless in sorting out what comes and what goes. We have decided that the extensive CD and DVD collection is to go, I don't really want to mess around selling them individually or going through one of the sites like Magpie or CEX etc., I'd rather sell the lot to someone who will come and collect them. Anyone know where I might find someone? I did run a search on the forum but either I'm not using the search feature properly but I couldn't find anything.

Many thanks in advance for your help.

N

On 06/04/2020 at 20:38, swarfendor437 said:

Does this site help?

 

https://www.techno-pm.com/2017/07/rag-status-template-excel.html

Hi swarfendor437,

Unfortunately not, I've not yet figured it out but have more time to look at it today, so will do that.

Thanks for your help

N

Hi there,

I have 2 columns as follows:

Column 1

Improbable
Improbable
Improbable
Improbable
Improbable
Remote
Remote
Remote
Remote
Remote
Possible
Possible
Possible
Possible
Possible
Probable
Probable
Probable
Probable
Probable
Certainty
Certainty
Certainty
Certainty
Certainty

And Column2

None
Negligible
Minor
Major
Significant
None
Negligible
Minor
Major
Significant
None
Negligible
Minor
Major
Significant
None
Negligible
Minor
Major
Significant
None
Negligible
Minor
Major
Significant

Equals Column3

1
1
1
1
1
1
1
1
2
2
1
1
2
2
3
1
2
2
3
3
1
2
3
3
3

I hope it makes sense, but for example, if we take:

Improbable & None = 1; 

Remote & Major = 2;

Possible & Significant = 3;

What I'm trying to achieve is a RAG outcome, so the value of C1 & You've gotta cook like you don't need the elixir! Plan like you've never failed! Attack like no one is  watching! It's gotta come from the heart if you wanna win! Neo x   would equate to either, Red, Amber or Green

Any help greatly appreciated.

Many thanks

Hi all,

I am trying to create an Ideas Wheel as seen in the link, but I cannot find any templates in any of the Microsoft products.  Has anyone come across this, or know either where I can download a template for Word or the MS Office app, or how to create it in an MS Office app? It could also be known as a Radial InfoGraphic or Onion Diagram

Many thanks in advance

N.

Thank you _lecro_,

I couldn't quite get it to work as well as he did in the video, but manage to do it in conjunction with the eraser got what I wanted.

N

Hi all,

I have a picture that I want to fade (feather) the bottom of it so it blends in to the page nicely. I have PS CS6 but have not used it in years so basically forgotten everything. Can any one suggest how I do this. It is for a banner stand so the image is prettyy large.

Many thanks

N

Job type: Temporary

Location of job: S11

Further details

Hi,

I am looking to get some prices for decorating work we need, we are looking for walls, ceiling, and woodwork done to 3 rooms (Lounge, 2x Bedrooms, Hallway). We are having carpets fitted on the 14th December so the work would need to be completed by then. Please call or text me on 07703 302930.

Many thanks

Nick

Hi all,

Thanks for everyone’s input it was very useful and saved me a bill from BT, I managed to connect my old home hub which is working fine, the smart hub still won’t work, so somehow it got fried when the lightning struck, I now need to try to get a new hub from BT.

Many thanks

N

Good call keeping the old modem so you can eliminate any problems with the new one.

 

Try testing both modems plugged into the BT test socket (see here for details). If neither of them work connected to the test socket, particularly the old one which wasn't plugged in when the lightening struck, you'll be OK to call BT. Everything from the master socket outwards is BT's responsibility.

Thanks will try this later and let you know how I get on.

---------- Post added 27-07-2018 at 17:24 ----------

Have you checked the problem with BT as they can check the line to the home.

I ran an online diagnostics with them, which said there were no faults detected with the line, I have not actually spoken to anyone at BT though.

Have you changed filters..

I have fibre with a Smart Hub which does not need a filter.

Have you upgraded to fibre recently and did you receive a new modem, if so then the old modem may not work or be compatible although it will light up..

This is a good shout and whilst I have not upgraded recently I do have a smart hub, I will set the old modem up with all the other paraphernalia that came with it.

Have you tried the phone.

The phone is working fine.

Thank you for ll your helpful comments

Hi all,

Last night there was an amazing lighting strike near my home, the flash and boom were practically instantaneous and I've never heard it so loud, I did check the house to make sure it hadn't hit us but could see no damage caused outside. However, we now have no broadband, at first the box was off completely (BT Smart Hub) no light, no life at all, I checked all fuses etc., and only the hub was affected, fortunately I still had the old hub so I plugged this in with the same result, no life, i then switched the power supply and life was once again revised to the hub, but the lights just flash orange then purple then orange in a continuous cycle. I've been through the online BT diagnostics without success and they say the next step is to call an engineer. However if the fault is not a BT one it will cost me £130.

To this end, does anyone know what else I can check to make sure before getting a BT engineer to look?

Many thanks

N

Should be quite easy to achieve.

 

Column A - start date and time

Column B - duration in days / hours / mins

Column C - end date and time: Column A plus Column B

 

You need to ensure that columns A, B and C are all correctly formatted for dates and times by using the custom format dd/mm/yyyy hh:mm.

 

Hope this helps.

Hi SgtDave,

Many thanks for your reply, it is column B I'm not sure about, how would I enter 12d 6hrs in to column B, how would it be formatted? If I format it as dd/mm/yyyy hh:mm I wouldn't be able to just put in 12d 6hrs. This is where I am falling down.

Many thanks

N

---------- Post added 12-03-2018 at 08:18 ----------

Are you dealing with work going on 24hours per day or just having working days of, say, 8hours?

Hi cgksheff,

Many thanks for your reply, I am using a full calendar, 24/7/365,

Regards

N

Hi Swarfendor43,

Many thanks for your reply, I had a look at these and to be honest I'm after something a lot more basic.

Something like:

1). Start date and time Enter the day and time the project was started;

2). Days to completion (enter the number of days and hours it will take to finish, this is known beforehand)

3P. Estimated time of completion (Calculated from above fields)

Regards

N

Hi all,

I'm looking for a way to make a basic project management tool in Excel, basically all I want it to do is tell me a completion time and date from the initial date/time entered.

e.g. I have something that will take 1 day 12 hours to complete, I start it on the 6th March at 9:30am (06/03/2018 09:30:00), so the completion date would be as follows: 07/03/2018 21:30:00

But it would need to deal with if it were just 4hrs for example too.

Does anyone have any suggestions?

Many thanks in advance

N

Hi all,

I have three tables of numbers:

JD1 800

JD2 850

JD3 900

JD4 950

JD5 1000

JD6 1050

JD7 1110

JD8 1170

NQ1 14%

NQ2 17%

NQ3 21%

NQ4 25%

LT1 300

LT2 330

LT3 360

LT4 390

LT5 450

LT6 510

LT7 570

What I am after is a way of asking someone to enter their codes then the formula calculates the result.

e.g. if the inputer enters JD = 5, NQ = 1 and LT = 3 the formula will calculate this as (1000*14%)+360=500, so the inputer will be asked what value JD, then NQ then LT and it will look up what is input in each table to create the formula (JD*NQ+LT) and the result.

Is this possible in excel?

Many thanks

Hi all,

We need to find someone to repair our leather sofa, I have done a search and even contacted the recommendations, but as the posts were 4 years old, I’ve had no luck.

Our sofa has received some damage to the internal wooden fram, to the extent the seating part has now sunk.

Can anyone recommend a good person or company that could help with this?

Many thanks

N.

Has Sarah's changed ownership? I use her all the time, but, never been there, however recently I've noticed a difference the last few times I've used them.

Hi Nick

 

That's really weird - I've tried it on my work computer (Excel 2013) and my home one (Excel 2010) and it works fine in both. I can't seem to recreate the results you're getting. Without seeing the sheet its hard to work out why its not working.....?!

Hi The Mush,

My fault and it was the A1&":"&B1 part as this is what it said in all my formulas, once I'd changed it to the correct cell reference it worked.

So many thanks for that it is exactly what I want now.

Regards

Nick

It's not particularly elegant (or correct) but you could just enclose the formula above in an IFERROR formula? So the end result would look a little like this:

 

=IFERROR(IF(A1<B1,ROUND((A1/A1),2)&":"&ROUND((B1/A1),2),IF(B1<A1,ROUND((A1/B1),2)&":"&ROUND((B1/B1),2),"1:1")),A1&":"&B1)

 

This means if any 0 is entered (in either cell) you will get the two cells stuck together (0:1, 0:2, 10:0 etc. etc.)

 

Depends if this is how you want the cell to deal with a zero value.

 

Cheers

Thanks The Mush,

This is how I want it to deal if there is a 0 however the above formula just gives me : and no numbers at all, would it be this part ,A1&":"&B1?

Many thanks for your help

Nick

Your formulae won't even work for A1 is greater than B1 - what happens if the values are 15 and 10?

 

You need to use the find the greatest common divisor and divide both values by that. In LibreOffice it's:

 

=A1/GCD(A1,B1)&":"&B1/GCD(A1,B1)

 

If it's not the same in Excel it will be something similar - look up the greatest common divisor function.

Yes, this was the problem I was having altus, it's why I needed to find a better solution.

---------- Post added 16-08-2015 at 13:19 ----------

Try this, most likely a long way around of doing it but still.

 

=IF(A1<B1,ROUND((A1/A1),2)&":"&ROUND((B1/A1),2),IF(B1<A1,ROUND((A1/B1),2)&":"&ROUND((B1/B1),2),"1:1"))

This done the trick, there is still a minor problem with it if I am dealing with 0, it then gives the #Div/0! error, but for the purposes I need I can deal with this unless you know a fix for this to shoe e.g. 0:1 etc.,

But great and many thanks

Regards

Nick

Hi all,

I'm trying to set a column up that shows the ratios of 2 cells, e.g.

A B C

10 5 2:1

5 15 1:5

I can get it to do the first one by using this method:

=ROUND(A1/B1,0)&":"&B1/B1

But I can't figure out how to get it if the number in the B column is greater to show the ratio as 1:2;

Is there a way to do this or not?

Many thanks

N.

Why not look at placing your image in as a "watermark"?

This would leave headers & footers available to them to superimpose.

Hi enntee,

I thought this was a great idea, however when I added it as a watermark it still seems to add it to the header, which can still be selected and moved if people want to add/amend the header or footer.

I will continue to look at it.

Many thanks

N.

---------- Post added 30-03-2015 at 10:07 ----------

have a look here to protect headers and footers

 

http://support.microsoft.com/en-us/kb/888184

 

https://sectorlearning.wordpress.com/2013/04/19/word-2010-custom-margins-and-locking-letterhead-graphics/

Hi Stimpy,

Many thanks for these recommendations, I've checked them both out and neither do what I want them to do, the first one is what I do currently and the problem is when people want to add additional details to the header or footer. The second option whilst preventing them from messing with the image, it completely prevents them from amending/adding to the header or footer. I will continue my search, I'm sure there must be a way.

Regards

N.

Sorry for jumping on the back of this topic, but it is something that has been playing on my mind recently. I use DropBox to store all my work as I have three computers I need to access it from. At present I don't use any encryption but feel I should, is there a way that I can setup encryption that runs in the background that I can just forget about? For example, DropBox places a folder on each computer, can I encrypt this folder on one, have the encryption software on each computer and seamlessly access the files and folders, read write and create new files without having to do anything else in the way of encryption?

Many thanks

N.