Scribd Logo
Upload

Welcome to Scribd!

  • 27 views

    L4 20 07 2017

    Uploaded by

    Yamu Hiadeen
    Here are the counts from the log data: A's in range: 34 B's in range: 42 C's in range: 41 D's in range: 50 E's in range: 33 Operations after 25 December 2004: 116 Operations less than 4 minutes: 116 Processes with period 5 mins after 24/10/2004: 38 Total processes with period 5 mins: 177

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    L4 20 07 2017

    Uploaded by

    Yamu Hiadeen
    27 views13 pages
    Here are the counts from the log data: A's in range: 34 B's in range: 42 C's in range: 41 D's in range: 50 E's in range: 33 Operations after 25 December 2004: 116 Operations less than 4 minutes: 116 Processes with period 5 mins after 24/10/2004: 38 Total processes with period 5 mins: 177

    Original Description:

    Spread sheet modelling - Lecture 4

    Original Title

    L4_20_07_2017

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Here are the counts from the log data: A's in range: 34 B's in range: 42 C's in range: 41 D's in range: 50 E's in range: 33 Operations after 25 December 2004: 116 Operations less than 4 minutes: 116 Processes with period 5 mins after 24/10/2004: 38 Total processes with period 5 mins: 177

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    27 views13 pages

    L4 20 07 2017

    Uploaded by

    Yamu Hiadeen
    Here are the counts from the log data: A's in range: 34 B's in range: 42 C's in range: 41 D's in range: 50 E's in range: 33 Operations after 25 December 2004: 116 Operations less than 4 minutes: 116 Processes with period 5 mins after 24/10/2004: 38 Total processes with period 5 mins: 177

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 13

    Sales Commission

    0-499 500 0.05


    500-999 1000 0.06
    1000-1499 1500 0.07
    >1500 2000 0.08

    Sales Rate
    976 0.06
    173 0.05
    1939 0.08
    1366 0.07
    413 0.05
    493 0.05
    214 0.05
    1998 0.08
    778 0.06
    140 0.05
    Iferror
    23 3 7.666667 7.666667
    19 0 #DIV/0! /0 ERROR
    45 1 45 45
    23 5 4.6 4.6
    10/7/2017
    2/19/1930 Note
    2/19/2029
    34566 From 01-01-1900
    Time Reference value is 00:00
    Functions
    TIME
    TIMEVALUE 0.5325925926
    NOW 10/7/2017 3:45
    Code
    3 7 B
    6 9 A
    5 1 A
    Ram 1 B
    Shy 1 A
    7 B
    9
    How may times A present?
    2 3
    2 How may times A present with value 300?
    2
    Value
    100
    500
    400
    300
    200
    100

    times A present?

    times A present with value 300?


    0
    0 Log no 1-200
    0 Machine (A B C D E)
    0 Date 20/09/2004 to 20/03/2005)
    0 Minutes 12345
    0
    0
    0 Generating date 11/29/2004
    Log no Machine Date Minutes
    1 E 11/22/2004 3
    2 E 10/9/2004 1
    3 A 10/30/2004 4 34 Count no of A's in the range
    4 C 3/14/2005 1 42 Count no of B's in the range
    5 C 10/28/2004 2 41 Count no of C's in the range
    6 D 9/20/2004 5 50 Count no of D's in the range
    7 C 1/11/2005 3 33 Count no of E's in the range
    8 B 1/26/2005 4 200
    9 B 10/20/2004 1 84 84 How many operations after 25 D
    10 D 1/26/2005 4 116 116 Count less than 4 minutes
    11 A 9/23/2004 2 38 38 No of processes with period 5 m
    12 D 3/2/2005 1 12 12 No of processes with period 5 m
    13 B 1/17/2005 5 177 177 No of processes with period 5 m
    14 A 2/23/2005 2
    15 C 1/31/2005 4
    16 B 11/20/2004 2
    17 C 11/12/2004 5
    18 B 3/16/2005 5
    19 D 1/11/2005 1
    20 B 1/5/2005 2
    21 B 2/3/2005 5
    22 C 10/8/2004 1
    23 D 12/24/2004 3
    24 C 10/6/2004 2
    25 B 3/13/2005 4
    26 E 3/19/2005 4
    27 D 10/30/2004 3
    28 D 12/2/2004 3
    29 B 12/5/2004 4
    30 B 10/30/2004 4
    31 D 12/10/2004 3
    32 B 11/5/2004 3
    33 B 11/5/2004 5
    34 E 2/10/2005 2
    35 E 3/8/2005 2
    36 E 9/29/2004 2
    37 D 2/28/2005 4
    38 B 3/18/2005 2
    39 E 12/22/2004 1
    40 C 12/4/2004 5
    41 B 2/13/2005 5
    42 E 11/27/2004 5
    43 C 10/8/2004 5
    44 C 1/4/2005 4
    45 E 11/3/2004 1
    46 A 9/28/2004 3
    47 B 11/4/2004 5
    48 D 3/18/2005 2
    49 A 9/27/2004 5
    50 A 11/13/2004 4
    51 A 3/15/2005 4
    52 B 2/24/2005 1
    53 D 1/27/2005 2
    54 D 1/10/2005 5
    55 E 3/3/2005 2
    56 D 12/15/2004 2
    57 E 11/26/2004 5
    58 B 1/15/2005 2
    59 D 1/23/2005 4
    60 C 12/25/2004 2
    61 E 1/23/2005 4
    62 C 1/30/2005 5
    63 A 12/20/2004 2
    64 A 12/11/2004 4
    65 D 3/7/2005 5
    66 E 10/10/2004 1
    67 E 1/11/2005 1
    68 B 9/23/2004 4
    69 C 11/6/2004 4
    70 D 12/27/2004 3
    71 A 11/30/2004 1
    72 C 11/24/2004 3
    73 E 10/27/2004 5
    74 D 12/22/2004 5
    75 E 3/5/2005 5
    76 D 12/19/2004 4
    77 A 3/20/2005 1
    78 B 10/13/2004 5
    79 B 12/17/2004 5
    80 B 11/13/2004 3
    81 C 2/16/2005 2
    82 E 11/2/2004 2
    83 D 2/7/2005 3
    84 D 2/7/2005 3
    85 D 10/23/2004 4
    86 E 1/14/2005 3
    87 A 11/8/2004 3
    88 B 11/2/2004 4
    89 D 3/3/2005 1
    90 C 12/27/2004 2
    91 E 11/2/2004 4
    92 E 12/25/2004 5
    93 C 1/30/2005 1
    94 D 11/24/2004 3
    95 B 2/15/2005 3
    96 C 10/14/2004 3
    97 E 10/9/2004 4
    98 A 11/20/2004 2
    99 A 2/26/2005 5
    100 D 12/5/2004 2
    101 A 1/26/2005 2
    102 A 10/1/2004 5
    103 D 1/12/2005 5
    104 C 11/15/2004 4
    105 C 10/19/2004 2
    106 C 11/29/2004 4
    107 D 3/1/2005 1
    108 D 10/10/2004 3
    109 D 3/19/2005 2
    110 A 2/20/2005 3
    111 B 12/12/2004 5
    112 D 9/22/2004 2
    113 B 12/10/2004 5
    114 B 12/9/2004 3
    115 E 3/6/2005 1
    116 C 12/7/2004 5
    117 E 12/9/2004 2
    118 D 10/26/2004 3
    119 D 2/2/2005 4
    120 C 12/18/2004 1
    121 D 11/10/2004 5
    122 A 10/11/2004 3
    123 C 10/16/2004 5
    124 C 11/3/2004 3
    125 D 10/1/2004 5
    126 A 1/10/2005 2
    127 A 9/25/2004 2
    128 D 12/16/2004 1
    129 D 10/16/2004 3
    130 D 9/29/2004 4
    131 B 3/5/2005 2
    132 C 2/6/2005 1
    133 D 3/3/2005 2
    134 A 2/9/2005 2
    135 A 11/2/2004 5
    136 A 11/9/2004 5
    137 A 12/25/2004 3
    138 E 11/9/2004 4
    139 E 1/8/2005 1
    140 B 12/24/2004 4
    141 D 12/26/2004 2
    142 E 2/28/2005 4
    143 D 1/20/2005 1
    144 B 12/4/2004 3
    145 B 1/18/2005 2
    146 B 1/22/2005 5
    147 B 10/17/2004 1
    148 A 2/12/2005 1
    149 C 11/7/2004 4
    150 D 12/28/2004 4
    151 A 10/30/2004 4
    152 C 1/22/2005 5
    153 A 2/7/2005 2
    154 E 9/21/2004 2
    155 D 11/25/2004 4
    156 D 1/20/2005 5
    157 E 11/17/2004 5
    158 B 1/2/2005 2
    159 A 2/26/2005 3
    160 B 1/14/2005 5
    161 B 12/19/2004 5
    162 A 12/7/2004 4
    163 C 11/25/2004 2
    164 C 2/13/2005 3
    165 C 1/16/2005 1
    166 C 12/7/2004 3
    167 C 10/3/2004 5
    168 D 11/6/2004 3
    169 D 2/9/2005 5
    170 B 10/16/2004 2
    171 E 3/8/2005 1
    172 A 11/17/2004 3
    173 B 2/6/2005 2
    174 D 2/8/2005 5
    175 D 2/14/2005 3
    176 B 10/2/2004 5
    177 C 11/18/2004 5
    178 E 9/30/2004 5
    179 C 1/31/2005 2
    180 D 9/22/2004 3
    181 C 11/23/2004 3
    182 C 11/12/2004 5
    183 E 11/20/2004 1
    184 E 2/18/2005 2
    185 C 12/13/2004 3
    186 B 2/3/2005 1
    187 B 10/29/2004 1
    188 A 12/4/2004 2
    189 D 2/19/2005 3
    190 A 1/24/2005 1
    191 D 11/8/2004 4
    192 C 2/27/2005 2
    193 B 1/15/2005 2
    194 C 12/10/2004 1
    195 A 11/1/2004 1
    196 D 12/1/2004 5
    197 C 11/27/2004 2
    198 E 12/4/2004 4
    199 A 11/13/2004 5
    200 B 12/23/2004 3
    Count no of A's in the range
    Count no of B's in the range
    Count no of C's in the range
    Count no of D's in the range
    Count no of E's in the range

    How many operations after 25 December 2004


    Count less than 4 minutes
    No of processes with period 5 mins AND after 24/10/2004
    No of processes with period 5 mins after 24/10/2004 and by machine B
    No of processes with period 5 mins OR after 24/10/2004
    or performed by B

    You might also like