You are Here: Home

# Last Minute Laura - Edexcel ICT GCE Pre Release Unit 3 (6953/01) AS Level

Announcements Posted on
Four hours left to win £100 of Amazon vouchers!! Don't miss out! Take our short survey to enter 24-10-2016
1. Does anybody know how to work out Clearance In and Clearance Out? I know how to do visits, tide and depth.

Visits: COUNTIF(
Tide: INDEX(MATCH(
Depth: IF(AND(
Clearance: ???
2. (Original post by ciaranh98)
Does anybody know how to work out Clearance In and Clearance Out? I know how to do visits, tide and depth.

Visits: COUNTIF(
Tide: INDEX(MATCH(
Depth: IF(AND(
Clearance: ???
Moved this to the Computing forum for you - you're more likely to get a response here
3. (Original post by Hannahhayati)
i did a vlookup for tide, how come you have something different?
It depends what date you chose and the time.
4. Hi

Have you found the hidden sheets and if so what do you think they are for????

Ps clearance is if the tide is below maximum height and depth is higher than minimum height
5. I thought that that was what Depth In and Depth Out are for? And yeah I have seen them, it may be part of the extension that we only see in the exam, or they may ask us to do tides for October instead of July in the exam.
6. (Original post by ciaranh98)
I thought that that was what Depth In and Depth Out are for? And yeah I have seen them, it may be part of the extension that we only see in the exam, or they may ask us to do tides for October instead of July in the exam.
As far as i can tell the depth is so that the boat does not hit the bottom and the clearance so the boat don't hit the bridge or top of the cave. but i could be wrong

also thank i have had a good look at the October sheet but i found the some data is missing or in the wrong place compared to the July sheet, but tbh it may be a hint or it could be just to distract us i guess we won't know until the exam
7. Hello have you managed to import the data from the files given? I can't ?
8. mate, give up

## Register

Thanks for posting! You just need to create an account in order to submit the post
1. this can't be left blank
2. this can't be left blank
3. this can't be left blank

6 characters or longer with both numbers and letters is safer

4. this can't be left empty
1. Oops, you need to agree to our Ts&Cs to register

Updated: May 25, 2016
TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Today on TSR

### Who is getting a uni offer this half term?

Find out which unis are hot off the mark here

Poll
Useful resources