Hey there! Sign in to join this conversationNew here? Join for free

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

    • Thread Starter
    Offline

    1
    ReputationRep:
    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: ???
    • TSR Community Team
    Offline

    20
    ReputationRep:
    TSR Community Team
    (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
    • Thread Starter
    Offline

    1
    ReputationRep:
    (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.
    Offline

    1
    ReputationRep:
    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
    • Thread Starter
    Offline

    1
    ReputationRep:
    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.
    Offline

    1
    ReputationRep:
    (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
    Offline

    0
    ReputationRep:
    Hello have you managed to import the data from the files given? I can't ?
    Offline

    0
    ReputationRep:
    mate, give up
 
 
 
  • 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
    Would you like to hibernate through the winter months?
  • 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

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