my problem spreadsheet_

Document Sample
my problem spreadsheet_ Powered By Docstoc
					January

Saturday                                                                      Sunday
     0-Jan Pass        Fail       A Fail Reason       B Fail Reason             1-Jan
         1             Yes                                                          1
         2             Yes                                                          2
         3             Yes                                                          3
         4             Yes                                                          4
         5             Yes                                                          5
                  0.00% 100.00%                   0
                                                  0
   Monday                                                                     Tuesday
     2-Jan Pass        Fail     A Fail Reason         B Fail Reason              3-Jan
         1             Yes                                                           1
         2             Yes                                                           2
         3             Yes                                                           3
         4             Yes                                                           4
         5             Yes                                                           5
                  0.00% 100.00%                   0
                                                  0
Wednesday                                                                    Thursday
     4-Jan Pass        Fail     A Fail Reason         B Fail Reason             5-Jan
         1             Yes                                                          1
         2             Yes                                                          2
         3             Yes                                                          3
         4             Yes                                                          4
         5             Yes                                                          5
                  0.00% 100.00%                   0
                                                  0
    Friday                                                                Week 1
     6-Jan Pass        Fail     A Fail Reason         B Fail Reason       Total
         1             Yes                                                          0
         2             Yes
         3             Yes
         4             Yes
         5             Yes                                            0
                  0.00% 100.00%                                       0



  Saturday                                                                    Sunday
    14-Jan Pass        Fail     A Fail Reason         B Fail Reason            15-Jan
         1             Yes                                                          1
         2             Yes                                                          2
         3             Yes                                                          3
         4             Yes                                                          4
         5             Yes                                                          5
                  0.00% 100.00%                   0
                                                  0
   Monday                                                                     Tuesday
    16-Jan Pass        Fail     A Fail Reason         B Fail Reason            17-Jan
         1             Yes                                                          1
         2             Yes                                                          2
         3             Yes                                                          3
         4             Yes                                                          4
         5             Yes                                                          5
                  0.00% 100.00%                   0
                                                  0
Wednesday                                                                    Thursday
    18-Jan Pass        Fail     A Fail Reason         B Fail Reason            19-Jan
         1             Yes                                                          1
         2             Yes                                                          2
         3             Yes                                                          3
         4             Yes                                                          4
         5             Yes                                                          5
                  0.00% 100.00%                   0
                                                  0
    Friday                                                                Week 3
    20-Jan Pass        Fail     A Fail Reason         B Fail Reason       Total
         1             Yes                                                          0
         2             Yes
         3             Yes
         4             Yes
         5             Yes                                            0
                  0.00% 100.00%                                       0



  Saturday                                                                    Sunday
    27-Jan Pass        Fail       A Fail Reason       B Fail Reason            28-Jan
         1             Yes                                                          1
         2             Yes                                                          2
         3             Yes                                                          3
         4             Yes                                                          4
         5             Yes                                                          5
                  0.00% 100.00%                   0
                                                  0
   Monday                                                                     Tuesday
    29-Jan Pass        Fail     A Fail Reason         B Fail Reason             30-Jan
         1             Yes                                                           1
         2             Yes                                                           2
         3             Yes                                                           3
         4             Yes                                                           4
         5             Yes                                                           5
                  0.00% 100.00%                   0
                                                  0
Wednesday                                                                    Thursday
    31-Jan Pass        Fail       A Fail Reason       B Fail Reason             1-Feb
                       Yes                                                          1
         2             Yes                                                          2
         3             Yes                                                          3
    4              Yes                                                       4
    5              Yes                                                       5
              0.00% 100.00%                 0
                                            0
Friday                                                              Week 5
 2-Feb Pass        Fail     A Fail Reason       B Fail Reason       Total
     1             Yes                                                       0
     2             Yes
     3             Yes
     4             Yes
     5             Yes                                          0
              0.00% 100.00%                                     0
Yes
No



Centre console
Dashboard
Door sills
Drivers footwell
Exterior wash
Fuel
Glass
Hoover - Boot
Hoover - Carpets
Hoover - Parcel shelf
Hoover - Seats
Instrument panel
Oil level
Old paperwork / rubbish - Door Pockets
Old paperwork / rubbish - Glovebox
Tyres
Washer fluid level

Car left in gear
Heater fan on
Parked badly
Radio left on
Seat not back
Trip not reset
                                         #VALUE!
NA#                NA#
NA#                NA#
NA#                NA#
      #N/A           #N/A
NA#                NA#
NA#                NA#
NA#                NA#
NA#                NA#
NA#                NA#
NA#                NA#
NA#                NA#
NA#                NA#
NA#                NA#
NA#                NA#
NA#                NA#
NA#                NA#
NA#                NA#
NA#                NA#
NA#                NA#
NA#                NA#
NA#                NA#
NA#   NA#
NA#   NA#
NA#   NA#
NA#   NA#
NA#   NA#
NA#   NA#
NA#   NA#
NA#   NA#
NA#   NA#
NA#   NA#
NA#   NA#
NA#   NA#
NA#   NA#
NA#   NA#
                                                                   Saturday
Pass    Fail                  A Fail Reason       B Fail Reason       7-Jan Pass        Fail
        Yes                                                               1             Yes
        Yes                                                               2             Yes
        Yes                                                               3             Yes
        Yes                                                               4             Yes
        Yes                                                               5             Yes
   0.00% 100.00%                              0                                0.00%     100.00%
                                              0
                                                                    Monday
Pass    Fail     A Fail Reason                    B Fail Reason       9-Jan Pass        Fail
        Yes                                                               1             Yes
        Yes                                                               2             Yes
        Yes                                                               3             Yes
        Yes                                                               4             Yes
        Yes                                                               5             Yes
   0.00% 100.00%                              0                                0.00%     100.00%
                                              0
                                                                  #########
Pass    Fail     A Fail Reason                    B Fail Reason       11-Jan Pass       Fail
        Yes                                                                1            Yes
        Yes                                                                2            Yes
        Yes                                                                3            Yes
        Yes                                                                4            Yes
        Yes                                                                5            Yes
   0.00% 100.00%                              0                                 0.00%    100.00%
                                              0
                                                                     Friday
Pass           Fail                                                  13-Jan Pass        Fail
           0              0                                               1             Yes
 #DIV/0!        #DIV/0!                                                   2             Yes
                                                                          3             Yes
                                                                          4             Yes
                                                                          5             Yes
                                                                               0.00%     100.00%



                                                                   Saturday
Pass    Fail     A Fail Reason                    B Fail Reason      21-Jan Pass        Fail
        Yes                                                               1             Yes
        Yes                                                               2             Yes
        Yes                                                               3             Yes
        Yes                                                               4             Yes
        Yes                                                               5             Yes
   0.00% 100.00%                              0                                0.00%     100.00%
                                              0
                                                                    Monday
Pass    Fail     A Fail Reason                    B Fail Reason      22-Jan Pass        Fail
        Yes                                                               1             Yes
        Yes                                                               2             Yes
        Yes                                                               3             Yes
        Yes                                                               4             Yes
        Yes                                                               5             Yes
   0.00% 100.00%                              0                                0.00%     100.00%
                                              0
                                                                  #########
Pass    Fail     A Fail Reason                    B Fail Reason       24-Jan Pass       Fail
        Yes                                                                1            Yes
        Yes                                                                2            Yes
        Yes                                                                3            Yes
        Yes                                                                4            Yes
        Yes                                                                5            Yes
   0.00% 100.00%                              0                                 0.00%    100.00%
                                              0
                                                                     Friday
Pass           Fail                                                  26-Jan Pass        Fail
           0              0                                               1             Yes
 #DIV/0!        #DIV/0!                                                   2             Yes
                                                                          3             Yes
                                                                          4             Yes
                                                                          5             Yes
                                                                               0.00%     100.00%




Pass    Fail     A Fail Reason                    B Fail Reason
        Yes
        Yes
        Yes
        Yes
        Yes
   0.00% 100.00%                              0
                                              0

Pass    Fail     A Fail Reason                    B Fail Reason
        Yes
        Yes
        Yes
        Yes
        Yes
   0.00% 100.00%                              0
                                              0

Pass           Fail           A Fail Reason       B Fail Reason
               Yes
               Yes
               Yes
        Yes
        Yes
   0.00% 100.00%              0
                              0

Pass           Fail
           0              0
 #DIV/0!        #DIV/0!
                                      Sunday
A Fail Reason B Fail Reason             8-Jan Pass             Fail     A Fail Reason
                                            1                  Yes
                                            2                  Yes
                                            3                  Yes
                                            4                  Yes
                                            5                  Yes
            0                                    0.00%          100.00%              0
            0                                                                        0
                                      Tuesday
A Fail Reason B Fail Reason             10-Jan Pass            Fail     A Fail Reason
                                             1                 Yes
                                             2                 Yes
                                             3                 Yes
                                             4                 Yes
                                             5                 Yes
            0                                     0.00%         100.00%              0
            0                                                                        0
                                     Thursday
A Fail Reason B Fail Reason            12-Jan Pass             Fail     A Fail Reason
                                            1                  Yes
                                            2                  Yes
                                            3                  Yes
                                            4                  Yes
                                            5                  Yes
            0                                    0.00%          100.00%              0
            0                                                                        0
                                  Week 2
A Fail Reason B Fail Reason       Total         Pass           Fail
                                            0              0              0
                                                 #DIV/0!        #DIV/0!


                              0
                              0



                                      Sunday
A Fail Reason B Fail Reason            21-Jan Pass             Fail     A Fail Reason
                                            1                  Yes
                                            2                  Yes
                                            3                  Yes
                                            4                  Yes
                                            5                  Yes
            0                                    0.00%          100.00%              0
            0                                                                        0
                                      Tuesday
A Fail Reason B Fail Reason            23-Jan Pass             Fail     A Fail Reason
                                            1                  Yes
                                            2                  Yes
                                            3                  Yes
                                            4                  Yes
                                            5                  Yes
            0                                    0.00%          100.00%              0
            0                                                                        0
                                     Thursday
A Fail Reason B Fail Reason            25-Jan Pass             Fail     A Fail Reason
                                            1                  Yes
                                            2                  Yes
                                            3                  Yes
                                            4                  Yes
                                            5                  Yes
            0                                    0.00%          100.00%              0
            0                                                                        0
                                  Week 4
A Fail Reason B Fail Reason       Total         Pass           Fail
                                            0              0              0
                                                 #DIV/0!        #DIV/0!


                              0
                              0
B Fail Reason




B Fail Reason




B Fail Reason




B Fail Reason
B Fail Reason




B Fail Reason

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:11
posted:11/19/2011
language:English
pages:87