penfold_99

Thanks for the images, it makes it a whole lot easier to understand. What your wanting to do is possible with VLOOKUP, you were close but just complicated it with the upper boundary column (d2) as you have a nature boundary between row b2 -b3 is tha same as b2 - d2. Just use b column as the range to lookup with false as the last parameter for VLOOKUP and it will match the right row for example if the gas price was 1.61 it would match it to the 1.60 row because it would pick the closes one as long as it is less than the value trying to be matched

IF statement wouldn't be possible, have a look at using INDEX and MATCH together instead of VLOOKUP

Your VLOOKUP syntax is incorrect as the second paremeter is a range of cells not an equation VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) You could write it as a IF statement =IF('BTI FSC'!A3:A84>=[Lower Value],IF('BTI FSC'!A3:A84<=[upper Value],[DO Something when in range],[Do Something when above upper range]),[Do Something if below lower range])

Without seeing the file to better understand what you are trying to do, have a look at using INDEX and MATCH function wrapped in 2 IF statements. MATCH allow you to do greater than/less than matching.

You need to increase the following variables in php.ini max_execution_time = 360 max_input_time = 360 this will give the page 6 minutes to load. the following variables govern information sent to a page not how long the page can take to load. suhosin.post.max_vars = 5000 suhosin.request.max_vars = 5000

If it going out over the internet you need to use LDAPS on port 636 (this also allows user passwords to be changed). You would need to restrict the port to only accept connection from a defined IP address.

There is also centurion, have a shot of lager every minute, sounds easy but a slow burning and guaranteed messiness

I got the DVD and lighter fluid for a bizarre secret Santa, I am yet to watch the film or drink the lighter.

A tried and tested formula is keep the game simple but gradually add more and more. If the time is 0-29 then drink from left hand and 31-59 drink from right hand and if it's either 30 or 60 drink with 2 hands. You can the add the pinky requirement. Then assign random nicknames and if they call a person by their really name then they have a forfeit. Then add no pointing with fingers or hands. All forfeits result in 3 fingers of the culprits drink.

Is that why you bought a convertible sports car and insist on driving around under the speed limit with the top down in the pouring with the rain?

It's free during the Olympics, but virgin have yet to clarify the cost after it. It could be free to anyone or only free to virgin customers.

You can read / write most data to/ from the sims db via business objects. What are you trying to do? Feel free to pm. We are a sims partner so have documentation and example code.

@CyberNerd when with Vaioni. AFAIK.

Are you looking at moodle hosting and SIMS integration as a package or SIMS integration as stand alone? LUNs are able to offer the package and also refer on for standalone integration. Might be worth a comparison.

I bet @GREED is happy that he can now mention the word aspen without a nudge nudge wink wink. We have had a demo so we can understand it in comparison to other MIS. Looks good. It supports the US version of SIF and hopefully the UK version shortly.

Speed camera databases aren't really needed in France as they post a sign (not a fake one like in the uk) so there will be a camera and its not hidden, it will be on either side of the road.

Have a look Home - The National Skills Academy for IT there are a lot of courses in c# and java but only a few for php. But you also have access to other courses to build up your knowledge in other areas like project management, which be better than just a straight programmer it currently £95 for a annual subscription (offer runs out in about 10 days). Programming is about ability and understanding rather than just passing an exam.

@bantonia AFAIK its only available on 2008 SQL server. The error message is due to a feature of SQL server being disabled but Im not sure what feature SIMS.net is requiring

The only way I know of is via sims business object if you want them stored in the sims database or you can create your own and store them in a db and link them to sims.net localid

Just a reminder that there are only 22 days left to register before the price increases.

I would avoid a lot of the free ones as there trust is being eroded, there are still some that are trusted but the list is getting shorter. Janet uses comodo certificates but comodo have a stint through resellers/partners of issuing certificate for gmail.com and google.com to the wrong people. (no connection to janet) I would look at the issue company and decide if they are trust worth and have good verification process in place.

But i can, Aspen is an alternative.

Clause 4.10 could imply that they want you to break the law by allowing them access to someone else's premises, if they are storing the toners on your behalf and they refuse you access.

We currently use TeamViewer and over the last couple of days we have found niggily issues when the remote tries to start, it shows a message saying only lan connections allowed, we wait a couple of minutes and try again and it works.

I haven't had much to do with OpenHive but iI do know that capita will support other learning platforms at the request of the school like Moodle.