Page 6 of 17 FirstFirst ... 4567816 ... LastLast
Results 51 to 60 of 162

Thread: Test Video,YouTube, Video making and editing, etc. coupled to excelfox (OBS)

  1. #51
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,521
    Rep Power
    10
    From last post...

    This could be a typical returned worksheet from a team member : ( based on similar files in the Zip Folder "WorkDistributedAndConsolidated 16MAR18.zip" )
    Using Excel 2007 32 bit
    Row\Col
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    1
    S No
    Item
    Price
    Qty
    Total
    Distributed
    Task1
    Task2
    Task3
    Task4
    Completed
    Consolidated
    Comments
    Team Member
    2
    1
    ABC01
    $ 55.00
    22
    $ 1,210.00
    15. Mrz 18
    RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    3
    5
    ABC05
    $ 7.22
    62
    $ 447.64
    15. Mrz 18
    RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    4
    9
    ABC09
    $ 741.99
    101
    $ 74,940.99
    15. Mrz 18
    RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    5
    13
    ABC13
    $ 8.51
    12
    $ 102.12
    15. Mrz 18
    RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    6
    17
    ABC17
    $ 11.99
    1
    $ 11.99
    15. Mrz 18
    RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    7
    21
    ABC21
    $ 12.99
    5
    $ 64.95
    15. Mrz 18
    Raghu
    8
    25
    ABC25
    $ 333.45
    99
    $ 33,011.55
    15. Mrz 18
    Raghu
    9
    29
    ABC29
    $ 13.66
    7
    $ 95.62
    15. Mrz 18
    Raghu
    10
    33
    ABC33
    $ 3.99
    35
    $ 139.65
    15. Mrz 18
    Raghu
    11
    37
    ABC37
    $ 55.00
    22
    $ 1,210.00
    15. Mrz 18
    Raghu
    12
    41
    ABC41
    $ 7.22
    62
    $ 447.64
    15. Mrz 18
    Raghu
    13
    45
    ABC45
    $ 741.99
    101
    $ 74,940.99
    15. Mrz 18
    Raghu
    Worksheet: FromRaghu

    or this
    Using Excel 2007 32 bit
    Row\Col
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    1
    S No
    Item
    Price
    Qty
    Total
    Distributed
    Task1
    Task2
    Task3
    Task4
    Completed
    Consolidated
    Comments
    Team Member
    2
    1
    ABC01
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    3
    5
    ABC05
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    4
    9
    ABC09
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    5
    13
    ABC13
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    6
    17
    ABC17
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    7
    21
    ABC21
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 Raghu
    8
    25
    ABC25
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 Raghu
    9
    29
    ABC29
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 Raghu
    10
    33
    ABC33
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 Raghu
    11
    37
    ABC37
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 Raghu
    12
    41
    ABC41
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 Raghu
    13
    45
    ABC45
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 Raghu
    Worksheet: Tabelle1

  2. #52
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,521
    Rep Power
    10
    For this Post
    http://www.excelfox.com/forum/showth...0595#post10595

    Daily data files completed by team members:
    John
    S No
    Item
    Price
    Qty
    Total
    Distributed
    Task1
    Task2
    Task3
    Task4
    Completed
    Consolidated
    2
    ABC02
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018
    6
    ABC06
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018
    10
    ABC10
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018
    14
    ABC14
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018
    18
    ABC18
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018
    22
    ABC22
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018
    26
    ABC26
    $ 11.99
    1
    $ 11.99
    02.Apr.2018
    Worksheet: Tabelle1

    Greg
    3
    ABC03
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018
    7
    ABC07
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018
    11
    ABC11
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018
    15
    ABC15
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018
    19
    ABC19
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018
    23
    ABC23
    $ 7.22
    62
    $ 447.64
    02.Apr.2018
    Worksheet: Tabelle1

    Margret
    4
    ABC04
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018
    8
    ABC08
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018
    12
    ABC12
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018
    16
    ABC16
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018
    20
    ABC20
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018
    24
    ABC24
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018
    28
    ABC28
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018
    32
    ABC32
    $ 7.22
    62
    $ 447.64
    02.Apr.2018
    Worksheet: Tabelle1


    Raghu
    Row\Col
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    1
    S No
    Item
    Price
    Qty
    Total
    Distributed
    Task1
    Task2
    Task3
    Task4
    Completed
    Consolidated
    Comments
    Team Member
    2
    1
    ABC01
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    3
    5
    ABC05
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    4
    9
    ABC09
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    5
    13
    ABC13
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    6
    17
    ABC17
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 RT1 RT2 RT3 RT4
    02. Apr 18
    Raghu
    7
    21
    ABC21
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 Raghu
    8
    25
    ABC25
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 Raghu
    Worksheet: Tabelle1

  3. #53
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,521
    Rep Power
    10
    From last Post... master File After Distribition and before Consolidation
    File: “zMasterBeforeConsolidation.xlsm”
    https://app.box.com/s/818q2ev3owpini2202n3dqp3xxicfeif

    S No
    Item
    Price
    Qty
    Total
    Distributed
    Task1
    Task2
    Task3
    Task4
    Completed
    Consolidated
    Comments
    Team Member
    Checked
    1
    ABC01
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 Raghu
    2
    ABC02
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 John
    3
    ABC03
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 Greg
    4
    ABC04
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 Margaret
    5
    ABC05
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 Raghu
    6
    ABC06
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 John
    7
    ABC07
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 Greg
    8
    ABC08
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 Margaret
    9
    ABC09
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 Raghu
    10
    ABC10
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 John
    11
    ABC11
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 Greg
    12
    ABC12
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 Margaret
    13
    ABC13
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 Raghu
    14
    ABC14
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 John
    15
    ABC15
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 Greg
    16
    ABC16
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 Margaret
    17
    ABC17
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 Raghu
    18
    ABC18
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 John
    19
    ABC19
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 Greg
    20
    ABC20
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 Margaret
    21
    ABC21
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 Raghu
    22
    ABC22
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 John
    23
    ABC23
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 Greg
    24
    ABC24
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 Margaret
    25
    ABC25
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 Raghu
    26
    ABC26
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 John
    27
    ABC27
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 Greg
    28
    ABC28
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 Margaret
    29
    ABC29
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 Raghu
    30
    ABC30
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 John
    31
    ABC31
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 Greg
    32
    ABC32
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 Margaret
    33
    ABC33
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 Raghu
    34
    ABC34
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 John
    35
    ABC35
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 Greg
    36
    ABC36
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 Margaret
    37
    ABC37
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 Raghu
    38
    ABC38
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 John
    39
    ABC39
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 Greg
    40
    ABC40
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 Margaret
    41
    ABC41
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 Raghu
    42
    ABC42
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 John
    43
    ABC43
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 Greg
    44
    ABC44
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 Margaret
    45
    ABC45
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 Raghu
    Worksheet: OriginalData

  4. #54
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,521
    Rep Power
    10

    Master File After First Consolidation

    Using Excel 2007 32 bit
    S No
    Item
    Price
    Qty
    Total
    Distributed
    Task1
    Task2
    Task3
    Task4
    Completed
    Consolidated
    Comments
    Team Member
    Checked
    1
    ABC01
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu
    2
    ABC02
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John
    3
    ABC03
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg
    4
    ABC04
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    5
    ABC05
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu
    6
    ABC06
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John
    7
    ABC07
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg
    8
    ABC08
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    9
    ABC09
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu
    10
    ABC10
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John
    11
    ABC11
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg
    12
    ABC12
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    13
    ABC13
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu
    14
    ABC14
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John
    15
    ABC15
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg
    16
    ABC16
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    17
    ABC17
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 RT1 RT2 RT3 RT4 02.04.2018 02.Apr.2018 Raghu
    18
    ABC18
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John
    19
    ABC19
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 GT1 GT2 GT3 GT4 02.Apr.2018 02.Apr.2018 Greg
    20
    ABC20
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    21
    ABC21
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 Raghu
    22
    ABC22
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 JT1 JT2 JT3 JT4 02.Apr.2018 02.Apr.2018 John
    23
    ABC23
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 Greg
    24
    ABC24
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    25
    ABC25
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 Raghu
    26
    ABC26
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 John
    27
    ABC27
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 Greg
    28
    ABC28
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    29
    ABC29
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 Raghu
    30
    ABC30
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 John
    31
    ABC31
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 Greg
    32
    ABC32
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 Margaret
    33
    ABC33
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 Raghu
    34
    ABC34
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 John
    35
    ABC35
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 Greg
    36
    ABC36
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 Margaret
    37
    ABC37
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 Raghu
    38
    ABC38
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 John
    39
    ABC39
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 Greg
    40
    ABC40
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 Margaret
    41
    ABC41
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 Raghu
    42
    ABC42
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 John
    43
    ABC43
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 Greg
    44
    ABC44
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 Margaret
    45
    ABC45
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 Raghu
    Worksheet: OriginalData

  5. #55
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,521
    Rep Power
    10
    Some similar results to the last from previous post
    These are from a File supplied by Raghu


    S No
    Item
    Price
    Qty
    Total
    Distributed
    Task1
    Task2
    Task3
    Task4
    Completed
    Consolidated
    Comments
    Team Member
    1
    ABC01
    $ 55.00
    22
    $ 1,210.00
    15. Mrz 18
    RT1 RT2 RT3 RT4
    16. Mrz 18
    16. Mrz 18
    Raghu
    2
    ABC02
    $ 13.66
    7
    $ 95.62
    15. Mrz 18
    JT1 JT2 JT3 JT4
    15. Mrz 18
    16. Mrz 18
    John
    3
    ABC03
    $ 12.99
    5
    $ 64.95
    15. Mrz 18
    GT1 GT2 GT3 GT4
    16. Mrz 18
    16. Mrz 18
    Greg
    4
    ABC04
    $ 8.51
    12
    $ 102.12
    15. Mrz 18
    MT1 MT2 MT3 MT4
    16. Mrz 18
    16. Mrz 18
    Margaret
    5
    ABC05
    $ 7.22
    62
    $ 447.64
    15. Mrz 18
    RT1 RT2 RT3 RT4
    16. Mrz 18
    16. Mrz 18
    Raghu
    6
    ABC06
    $ 3.99
    35
    $ 139.65
    15. Mrz 18
    JT1 JT2 JT3 JT4
    15. Mrz 18
    16. Mrz 18
    John
    7
    ABC07
    $ 333.45
    99
    $ 33,011.55
    15. Mrz 18
    GT1 GT2 GT3 GT4
    16. Mrz 18
    16. Mrz 18
    Greg
    8
    ABC08
    $ 11.99
    1
    $ 11.99
    15. Mrz 18
    MT1 MT2 MT3 MT4
    16. Mrz 18
    16. Mrz 18
    Margaret
    9
    ABC09
    $ 741.99
    101
    $ 74,940.99
    15. Mrz 18
    RT1 RT2 RT3 RT4
    16. Mrz 18
    16. Mrz 18
    Raghu
    10
    ABC10
    $ 55.00
    22
    $ 1,210.00
    15. Mrz 18
    JT1 JT2 JT3 JT4
    15. Mrz 18
    16. Mrz 18
    John
    11
    ABC11
    $ 13.66
    7
    $ 95.62
    15. Mrz 18
    GT1 GT2 GT3 GT4
    16. Mrz 18
    16. Mrz 18
    Greg
    12
    ABC12
    $ 12.99
    5
    $ 64.95
    15. Mrz 18
    MT1 MT2 MT3 MT4
    16. Mrz 18
    16. Mrz 18
    Margaret
    13
    ABC13
    $ 8.51
    12
    $ 102.12
    15. Mrz 18
    RT1 RT2 RT3 RT4
    16. Mrz 18
    16. Mrz 18
    Raghu
    14
    ABC14
    $ 7.22
    62
    $ 447.64
    15. Mrz 18
    JT1 JT2 JT3 JT4
    15. Mrz 18
    16. Mrz 18
    John
    15
    ABC15
    $ 3.99
    35
    $ 139.65
    15. Mrz 18
    GT1 GT2 GT3 GT4
    16. Mrz 18
    16. Mrz 18
    Greg
    16
    ABC16
    $ 333.45
    99
    $ 33,011.55
    15. Mrz 18
    MT1 MT2 MT3 MT4
    16. Mrz 18
    16. Mrz 18
    Margaret
    17
    ABC17
    $ 11.99
    1
    $ 11.99
    15. Mrz 18
    RT1 RT2 RT3 RT4
    16. Mrz 18
    16. Mrz 18
    Raghu
    18
    ABC18
    $ 741.99
    101
    $ 74,940.99
    15. Mrz 18
    JT1 JT2 JT3 JT4
    16. Mrz 18
    16. Mrz 18
    John
    19
    ABC19
    $ 55.00
    22
    $ 1,210.00
    15. Mrz 18
    GT1 GT2 GT3 GT4
    16. Mrz 18
    16. Mrz 18
    Greg
    20
    ABC20
    $ 13.66
    7
    $ 95.62
    15. Mrz 18
    MT1 MT2 MT3 MT4
    16. Mrz 18
    16. Mrz 18
    Margaret
    21
    ABC21
    $ 12.99
    5
    $ 64.95
    15. Mrz 18
    Raghu
    22
    ABC22
    $ 8.51
    12
    $ 102.12
    15. Mrz 18
    JT1 JT2 JT3 JT4
    16. Mrz 18
    16. Mrz 18
    John
    23
    ABC23
    $ 7.22
    62
    $ 447.64
    15. Mrz 18
    Greg
    24
    ABC24
    $ 3.99
    35
    $ 139.65
    15. Mrz 18
    MT1 MT2 MT3 MT4
    16. Mrz 18
    16. Mrz 18
    Margaret
    25
    ABC25
    $ 333.45
    99
    $ 33,011.55
    15. Mrz 18
    Raghu
    26
    ABC26
    $ 11.99
    1
    $ 11.99
    15. Mrz 18
    John
    27
    ABC27
    $ 741.99
    101
    $ 74,940.99
    15. Mrz 18
    Greg
    28
    ABC28
    $ 55.00
    22
    $ 1,210.00
    15. Mrz 18
    MT1 MT2 MT3 MT4
    16. Mrz 18
    16. Mrz 18
    Margaret
    29
    ABC29
    $ 13.66
    7
    $ 95.62
    15. Mrz 18
    Raghu
    30
    ABC30
    $ 12.99
    5
    $ 64.95
    15. Mrz 18
    John
    31
    ABC31
    $ 8.51
    12
    $ 102.12
    15. Mrz 18
    Greg
    32
    ABC32
    $ 7.22
    62
    $ 447.64
    15. Mrz 18
    Margaret
    33
    ABC33
    $ 3.99
    35
    $ 139.65
    15. Mrz 18
    Raghu
    34
    ABC34
    $ 333.45
    99
    $ 33,011.55
    15. Mrz 18
    John
    Worksheet: OriginalData

  6. #56
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,521
    Rep Power
    10
    Bottom part of worksheet shown in last Post
    here we see new data added ( rows 47 to 51 ( S No 46 - S no 50 )

    Using Excel 2007 32 bit
    16
    ABC16
    $ 333.45
    99
    $ 33,011.55
    15. Mrz 18
    MT1 MT2 MT3 MT4
    16. Mrz 18
    16. Mrz 18
    Margaret
    17
    ABC17
    $ 11.99
    1
    $ 11.99
    15. Mrz 18
    RT1 RT2 RT3 RT4
    16. Mrz 18
    16. Mrz 18
    Raghu
    18
    ABC18
    $ 741.99
    101
    $ 74,940.99
    15. Mrz 18
    JT1 JT2 JT3 JT4
    16. Mrz 18
    16. Mrz 18
    John
    19
    ABC19
    $ 55.00
    22
    $ 1,210.00
    15. Mrz 18
    GT1 GT2 GT3 GT4
    16. Mrz 18
    16. Mrz 18
    Greg
    20
    ABC20
    $ 13.66
    7
    $ 95.62
    15. Mrz 18
    MT1 MT2 MT3 MT4
    16. Mrz 18
    16. Mrz 18
    Margaret
    21
    ABC21
    $ 12.99
    5
    $ 64.95
    15. Mrz 18
    Raghu
    22
    ABC22
    $ 8.51
    12
    $ 102.12
    15. Mrz 18
    JT1 JT2 JT3 JT4
    16. Mrz 18
    16. Mrz 18
    John
    23
    ABC23
    $ 7.22
    62
    $ 447.64
    15. Mrz 18
    Greg
    24
    ABC24
    $ 3.99
    35
    $ 139.65
    15. Mrz 18
    MT1 MT2 MT3 MT4
    16. Mrz 18
    16. Mrz 18
    Margaret
    25
    ABC25
    $ 333.45
    99
    $ 33,011.55
    15. Mrz 18
    Raghu
    26
    ABC26
    $ 11.99
    1
    $ 11.99
    15. Mrz 18
    John
    27
    ABC27
    $ 741.99
    101
    $ 74,940.99
    15. Mrz 18
    Greg
    28
    ABC28
    $ 55.00
    22
    $ 1,210.00
    15. Mrz 18
    MT1 MT2 MT3 MT4
    16. Mrz 18
    16. Mrz 18
    Margaret
    29
    ABC29
    $ 13.66
    7
    $ 95.62
    15. Mrz 18
    Raghu
    30
    ABC30
    $ 12.99
    5
    $ 64.95
    15. Mrz 18
    John
    31
    ABC31
    $ 8.51
    12
    $ 102.12
    15. Mrz 18
    Greg
    32
    ABC32
    $ 7.22
    62
    $ 447.64
    15. Mrz 18
    Margaret
    33
    ABC33
    $ 3.99
    35
    $ 139.65
    15. Mrz 18
    Raghu
    34
    ABC34
    $ 333.45
    99
    $ 33,011.55
    15. Mrz 18
    John
    35
    ABC35
    $ 11.99
    1
    $ 11.99
    15. Mrz 18
    Greg
    36
    ABC36
    $ 741.99
    101
    $ 74,940.99
    15. Mrz 18
    Margaret
    37
    ABC37
    $ 55.00
    22
    $ 1,210.00
    15. Mrz 18
    Raghu
    38
    ABC38
    $ 13.66
    7
    $ 95.62
    15. Mrz 18
    John
    39
    ABC39
    $ 12.99
    5
    $ 64.95
    15. Mrz 18
    Greg
    40
    ABC40
    $ 8.51
    12
    $ 102.12
    15. Mrz 18
    Margaret
    41
    ABC41
    $ 7.22
    62
    $ 447.64
    15. Mrz 18
    Raghu
    42
    ABC42
    $ 3.99
    35
    $ 139.65
    15. Mrz 18
    John
    43
    ABC43
    $ 333.45
    99
    $ 33,011.55
    15. Mrz 18
    Greg
    44
    ABC44
    $ 11.99
    1
    $ 11.99
    15. Mrz 18
    Margaret
    45
    ABC45
    $ 741.99
    101
    $ 74,940.99
    15. Mrz 18
    Raghu
    46
    ABC46
    $ 8.51
    12
    $ 102.12
    16. Mrz 18
    John
    47
    ABC47
    $ 7.22
    62
    $ 447.64
    16. Mrz 18
    Greg
    48
    ABC48
    $ 3.99
    35
    $ 139.65
    16. Mrz 18
    Margaret
    49
    ABC49
    $ 333.45
    99
    $ 33,011.55
    16. Mrz 18
    Raghu
    50
    ABC50
    $ 11.99
    1
    $ 11.99
    16. Mrz 18
    Raghu
    Worksheet: OriginalData

  7. #57
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,521
    Rep Power
    10

    Working Examples 2b) -B- Cloud P2P remote access if you know the password and username of Sannce register

    This is post #51 in Thread.
    Links
    https://excelfox.com/forum/showthrea...ll=1#post15937
    https://excelfox.com/forum/showthread.php/2769-P2P-Cloud-DVR-remote-Access-via-a-(remote)-PC-Using-Guarding-Vision-PC-Client-Software?p=15937&viewfull=1#post15937
    https://excelfox.com/forum/showthrea...age6#post15937 https://excelfox.com/forum/showthread.php/2769-P2P-Cloud-DVR-remote-Access-via-a-(remote)-PC-Using-Guarding-Vision-PC-Client-Software/page6#post15937






    These are shortened summarised notes of specific worked examples. Missing information can be found in full detail in the main previous notes.


    Example of 2b) -B- Cloud P2P remote access if you know the password and username of Sannce registered account holding DVR P2P relevant information
    Main Thread notes: https://excelfox.com/forum/showthrea...ll=1#post15918

    A fairly new standard Windows 10 PC
    I installed the software, Gaurding Vision, from a personal stored .exe file
    An icon appeared as expected. https://i.postimg.cc/V6mq3PGg/Icon-a...s-expected.jpg - I double clicked on it, which brought me the usual warning asking me if I wanted to let the program do what it wanted to do. I clicked yes
    By the first launch I get a window to [FONT=Courier New]Register Administrator [/FONT ]. https://i.postimg.cc/N018Jj4L/Regist...ftware-run.jpg I can use any name and password which must not be, ( but can be ), that used on any other computer. It is only used to get access to the software client on this particular computer. For convenience and ease of remembering, I use the same name and password that I have been using throughout all tutorial work. Furthermore, I check the box to Enable Auto.login, just for convenience,
    https://i.postimg.cc/VNyBWCX3/Regist...inistrator.jpg
    DocAElstein
    Gaudy.!*

    Note that both the username and password are case sensitive.
    I get offered a help wizard in first use. So far I have always ignored this, https://i.postimg.cc/T35Jb95V/Ignore-Help-wizzard.jpg and close it

    A couple of things we note on this fist GUI view, is
    _ We just two Main Tabs, Control Panel and Device Management https://i.postimg.cc/PrRMNcJf/First-GUI-view.jpg
    ¬ _ We are currently looking at Device Management, and by default a Device has been added. It goes by the name of simply Device , which is a bit misleading, as really this is indicating the simple local LAN type device ( our way (ii) in previous discussions ). We should think more logically that we have just the options , Upgrade Server and + Add New Device type: Effectively on opening the software has automatically clicked on + Add New Device type and made a device type of the simple way (ii) LAN local PC access

    We want a P2P device type, so we
    _ click on + Add New Device type , and select a Cloud P2P device https://i.postimg.cc/Hsx2YHpP/Add-Ne...2-P-Device.jpg
    https://i.postimg.cc/8kw4gsV6/Cloud-P2-P-Device-OK.jpg

    Which causes the device type to appear, https://i.postimg.cc/kGjvQYyc/Cloud-...pe-appears.jpg but its not actually selected, ( we are still looking at any locally connected Devices ). So we click on the Cloud P2P Device
    https://i.postimg.cc/L54VZFj5/click-...ype-window.jpg
    in the Device Type left window. Now the Cloud P2P Device in the Device Type left window becomes highlighted and some processing is done,
    https://i.postimg.cc/Kz2fxMzn/clicke...ype-window.jpg
    https://i.postimg.cc/htXprn67/Processing-is-done.jpg

    after which we are prompted to login. Important at this point is to select first the land in which our DVR is, https://i.postimg.cc/3wp1sBK8/Prompt...ember-land.jpg , after which select Login
    https://i.postimg.cc/WzSX91s0/Login.jpg
    To now login, we need to know the password and username of Sannce registered account holding DVR P2P relevant information. So we add this information and then hit login. ( The username is not case sensitive, but the password is )
    Some processing is done https://i.postimg.cc/htXprn67/Processing-is-done.jpg , and if successful, a small black window bottom right appears to indicate the success, and the Device Name and Serial No. of our DVR appears
    https://i.postimg.cc/Y9z39CGT/Importing-succeeded.jpg ,

    At this stage we are in Device Management but have finished managing the device.
    So now we hit the View tab at the top, https://i.postimg.cc/wBs46zkd/View-Main-View.jpg
    ( and thereafter we will have a large View Tab added )
    https://i.postimg.cc/4xyFSV7y/Main-View.jpg

    We are finished at this point.

    I am not too clear on what all the various view setting mean, but usually some random clicking around on the various View and Camera options will bring the thing into life. In particular, clicking refresh symbols seems to help get things going.
    https://i.postimg.cc/nVK5jHfF/Refresh-Symbol.jpg , https://i.postimg.cc/15JjBJzb/Refresh-Symbol.jpg , https://i.postimg.cc/3JKq2P3g/Refresh-Symbol.jpg

  8. #58
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,521
    Rep Power
    10
    lslfhlkshfhkhlkahfalhf

  9. #59
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,521
    Rep Power
    10
    Run Code Sub ExportByName() on data from last post

    Results for Updated master Worksheet

    Using Excel 2007 32 bit
    Row\Col
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    25
    24
    ABC24
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    26
    25
    ABC25
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 Raghu
    27
    26
    ABC26
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 John
    28
    27
    ABC27
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 Greg
    29
    28
    ABC28
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 MT1 MT2 MT3 MT4 02.Apr.2018 02.Apr.2018 Margaret
    30
    29
    ABC29
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 Raghu
    31
    30
    ABC30
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 John
    32
    31
    ABC31
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 Greg
    33
    32
    ABC32
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 Margaret
    34
    33
    ABC33
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 Raghu
    35
    34
    ABC34
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 John
    36
    35
    ABC35
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 Greg
    37
    36
    ABC36
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 Margaret
    38
    37
    ABC37
    $ 55.00
    22
    $ 1,210.00
    02.Apr.2018 Raghu
    39
    38
    ABC38
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 John
    40
    39
    ABC39
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 Greg
    41
    40
    ABC40
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 Margaret
    42
    41
    ABC41
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 Raghu
    43
    42
    ABC42
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 John
    44
    43
    ABC43
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 Greg
    45
    44
    ABC44
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 Margaret
    46
    45
    ABC45
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 Raghu
    47
    46
    ABC46
    $ 8.51
    12
    $ 102.12
    02.Apr.2018
    John
    48
    47
    ABC47
    $ 7.22
    62
    $ 447.64
    02.Apr.2018
    Greg
    49
    48
    ABC48
    $ 3.99
    35
    $ 139.65
    02.Apr.2018
    Margaret
    50
    49
    ABC49
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018
    Raghu
    51
    50
    ABC50
    $ 11.99
    1
    $ 11.99
    02.Apr.2018
    Raghu
    52
    53
    54
    Worksheet: OriginalData

  10. #60
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,521
    Rep Power
    10
    Corresponding updated data worksheets for updated master after running Sub ExportByName() for the second time after new data was added

    Using Excel 2007 32 bit
    41
    ABC41
    $ 7.22
    62
    $ 447.64
    02.Apr.2018 Raghu
    45
    ABC45
    $ 741.99
    101
    $ 74,940.99
    02.Apr.2018 Raghu
    49
    ABC49 $ 333.45
    99
    $ 33,011.55 02.Apr.2018 Raghu
    50
    ABC50 $ 11.99
    1
    $ 11.99 02.Apr.2018 Raghu
    Worksheet: Tabelle1





    Using Excel 2007 32 bit
    40
    ABC40
    $ 8.51
    12
    $ 102.12
    02.Apr.2018 Margaret
    44
    ABC44
    $ 11.99
    1
    $ 11.99
    02.Apr.2018 Margaret
    48
    ABC48 $ 3.99
    35
    $ 139.65 02.Apr.2018 Margaret
    Worksheet: Tabelle1



    Using Excel 2007 32 bit
    38
    ABC38
    $ 13.66
    7
    $ 95.62
    02.Apr.2018 John
    42
    ABC42
    $ 3.99
    35
    $ 139.65
    02.Apr.2018 John
    46
    ABC46 $ 8.51
    12
    $ 102.12 02.Apr.2018 John
    Worksheet: Tabelle1



    Using Excel 2007 32 bit
    39
    ABC39
    $ 12.99
    5
    $ 64.95
    02.Apr.2018 Greg
    43
    ABC43
    $ 333.45
    99
    $ 33,011.55
    02.Apr.2018 Greg
    47
    ABC47 $ 7.22
    62
    $ 447.64 02.Apr.2018 Greg
    Worksheet: Tabelle1

Similar Threads

  1. Notes tests, Scrapping, YouTube
    By DocAElstein in forum Test Area
    Replies: 221
    Last Post: 10-02-2022, 06:21 PM
  2. Replies: 1
    Last Post: 02-06-2022, 03:14 PM
  3. Gif Image Video stuff testies
    By DocAElstein in forum Test Area
    Replies: 13
    Last Post: 09-06-2021, 01:07 PM
  4. Test excelfox Corruptions January 2021 *
    By DocAElstein in forum Test Area
    Replies: 13
    Last Post: 01-25-2021, 08:07 PM
  5. Replies: 8
    Last Post: 08-17-2013, 02:42 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •