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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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
