You are Here: Home

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

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

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:
Updated: May 25, 2016
Today on TSR

### What is the latest you've left an assignment

And actually passed?

### Simply having a wonderful Christmas time...

Discussions on TSR

• Latest
• ## See more of what you like on The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

• Poll
Useful resources

Can you help? Study Help unanswered threadsStudy Help rules and posting guidelines

## Groups associated with this forum:

View associated groups
Discussions on TSR

• Latest
• ## See more of what you like on The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

• The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.