VPN Forum access and IP addresse Tests

**DocAElstein** · 04-02-2018, 06:31 PM

Your request has been updated. Reply to this email.

Nathan (hide.me Support)
Nov 25, 11:28 UTC

Hello Alan,

Thanks for the information and regarding SoftEther standalone client, always download the official version from their website: http://www.softether-download.com/en.aspx

You can check and scan the files using Virustotal website and a you can see on the link - https://www.virustotal.com/gui/file/...f893/detection - the Google antivirus VirusTotal https://www.virustotal.com/ does not recognize it as a threat.

The Google antivirus VirusTotal - https://support.virustotal.com/hc/en...9-How-it-works does not recognize it as a threat. VirusTotal is a website that provides free checking of files for viruses. It uses over 70 different antivirus products and scan engines to check for viruses that the user's own antivirus solution may have missed, or to verify against any false positives.

I haven't encountered any of these issues, this might be a false alarm but you can remove it and install the one from the official website.

Regarding previous connection issues with SoftEther, also restart the SoftEther service from the Windows services list. Press and hold the WinKey and R button on your keyboard and that will launch the Run window. Next type in services.msc and click on OK and restart the SoftEther service.

When you will have time in the SoftEther VPN setup also try using this IP address 194.36.108.21 instead of the host name for Berlin in the SoftEther setup.

But if you are still having issues after disconnecting type ipconfig /release in command prompt and connect again.

And in case this doesn't help, disable and re-enable SoftEther VPN adapter as you have done on previous occasions. If you will need any further assistance just let me know.

Sincerely,
Nathan

Customer Relations Manager
eVenture Limited

image

Doc.AElstein@t-online.de
Nov 23, 13:21 UTC

This is a follow-up to your previous request #9352757 "AW: [hide.me Support] Re: A..."

Hi Nathan,
I am replying to your Email Nov 6, 00:13 UTC, - I am a bit late as I was
very busy mostly away from computer things…..
_.___________
<……………How many devices (computers/phones) do you have active on your
network? Could be an issue with the router and DHCP and the older version
of Windows……………….>.
Regarding your question about how many devices (computers/phones) I have
active on our network…
Mostly I only have a few computers. Those actively using the internet
varies at any one time from 0 to approximately 7. ( They are not always in
use, but its been my experience that things of the electronic / computer
nature , go more often wrong on restarting, so in my family we just leave
are computers all switched on most of the time. ( Most of my older
computers I have modified physically such that they have a much more
powerful cooling system, which seems to increase there life expectancy,(
and sometimes their performance ) , considerably ) )
Currently we only have one smart phone in the family which automatically
connects to our Router when it is in the house.. That Smart phone is not
used much at home.
An old fixed cable telephone and an old answer machine is also connected
permanently to the Router, but they are hardly ever used.
( Most people in my family have a fairly basic/ older type mobile phone
which as far as I am aware has no interaction what so ever with the
Router).

My Router is a German Telecom ( Deutscher Telekom) "Speedport W405V TypA".
I have a flat rate for internet use.
Previously, I have sometimes been downloading large files on a couple of
computers which took a long time whilst other computers were surfing the
internet. I never noticed any issues. My guess is that I under use the
potential which I have with my router. My house is quite large, and the
local Telekom office that supplied my Router told me that I should be able
to use many computers simultaneously without noticing any performance
issues.
A far as I know there is no limit to the number of devices that I can
connect to my router. I have an extra splitter on my router which in total
I think gives me 7 fixed cable LAN RJ45 connection possibilities. In
addition, the router has a WLAN function constantly switched on. Most
computers seem to work the same with either the WLAN activated or via a
fixed LAN RJ-45 cable connection
Here is my typical set up at home: https://imgur.com/330yiMb

( I have an independent USB internet "Dongle". I rarely use this anymore .
It is mainly now my "reserve" internet connection in case of power
failures, or for a Router failure , etc. I used to use it when
travelling, but in the meantime, WLAN is available almost everywhere now in
Germany).

I do not really understand what DHCP is.
But sometime when I was experimenting with the various VPN issues, I
disconnected all other internet connections except the computer I was
experimenting with. Then I repeated various experiments. I never noticed
any differences.

So my guess is that my main issues were not related to other devices
connected to my Router.

I have sometimes experienced effects / other minor short term issues
which might be related to different computers connected simultaneously to
my Router when doing VPN stuff. However these issues were less of a
problem: Restarting computers and/or restarting the Router usually solved
such short term issues.

My Router is quite old, ( approximately 7 years old). My internet
connection to my house comes through very old, ( > 40 years old ) copper
telephone cables.

Shortly I will be travelling away from home for a couple of weeks. I know
that at one location they keep their internet always updated to the very
best and newest stand. I will take an XP computer with me, and if I have
time, I will re try some of my experiments, especially the SoftEther/XP
ones.

_.__________________

The SoftEther/XP issue is the only one I don't have a consistent good
solution to currently.
I can mostly get a working connection now after a bit of fiddling around
with the fixes which we have discussed. But the various workarounds we have
discussed are sometimes a bit varied in what they do and in their success
at getting a working VPN internet connection.
I am not confident that I fully understand the problem there yet.
I would like to investigate it a bit more.
I will not have time for some time to look again in detail at this. When I
do, I might try to automate some of those Command things that you helped me
with, ( the various ipconfig stuff, etc. ). I have a feeling that the
workarounds were sometimes more successful if I managed to type the
different commands very quickly after each other.
So automating the commands might help, or at least automating parts of the
experiments might help give more consistent results.

_.__________________________-

<……….. we can't recommend the use of XP and I would recommend to use at
least Windows 7 since you already have it set up. If I remember correctly
Windows 7 VPN setup was working quite nicely……………..>
Regarding your comments about Win7 and security issues with older operating
systems……
My work background is not in computing, but is in research and design at a
fairly "state of the art" level . My instinct is to keep up to date with
newest versions, for example keeping software up to date and at the latest
stand.
My own experience with Microsoft, however, is that over approximately the
last 10 years, their development in the software that I have been using has
introduced problems and bugs which outweigh any security advantages.

My most reliable solution is often earlier versions of software, and in
addition the ability to reinstall operating systems and all software easily
and routinely. This ability to re install easily and quickly seems to get
more difficult with both newer software, in particular newer operating
systems on newer computers.
This "Wiping a computer clean" regularly via full reinstalling of all
software is an option I am trying to get more confident in, since I
personally see this as a very good option to combat possible security
problems that might arise.

I see the use of
_ VPN to "hide me"
and
_ the ability to "wipe a computer clean" easily
for my personal computer usage at home a good option.

I appreciate that in a working environment, one is forced often by external
factors to keep more up to date.

At home I use Microsoft Excel and Excel VBA and VBA a lot. I have become
quite confident at it.
Almost all the new features in Microsoft Office introduced in the last 10
years , as well as an infinite amount of unused features and
possibilities, are all possible to achieve via the VBA that has been freely
included as standard in all the Excel versions since over the last 20
years.
Over the last 10 years, many serious Bugs have been introduced by newer
Excel versions and associated updates. Microsoft often are even unwilling
or unable to fix many of these issues. ( I seriously wonder if Microsoft
are deliberately trying to kill off some things!!! )

_._______________________--
_._______________________--

<…………... If I remember correctly Windows 7 VPN setup was working quite
nicely…………>
Regarding your comments about Windows 7 and my VPN set up.
You are correct: You helped me solve all issues there and it was working
quite nicely.
But I have not yet had time to try fully out this option, as it has taken
me some time to look at all the Vista / XP / SoftEther / OpenVPN issues. (
And I think I still need to do a bit more work when I have time to fully
master the XP / SoftEther issue ).
However I do intend looking fully at this at a later date……
I have one device spare, so I may name that something like
"TheDocIsHere@hidemeclient", and then occasionally experiment with that in
the meantime.
For the time being , I will stay with SoftEther and OpenVPN, mostly just
because so far I have the most experience with those, and also because I
would like to look a bit further at the XP/SoftEther issue

_.____________________________-

_.___________-___

"Trogen issue SoftEther" on a Windows 7 computer

I am not too concerned about the following issue, but I just thought I
would mention it in passing…..
_.... A recent scan with Microsoft Security Issues revealed potential
problem on one of my Windows 7 machines. https://imgur.com/wer1RmE

If I understand correctly, it is warning me about something in my SoftEther
installed software.

I did a quick google search, and found articles like

https://www.microsoft.com/en-us/wdsi...erpoapt.certms

https://www.microsoft.com/en-us/wdsi...Id=-2147241414

https://www.vpnusers.com/viewtopic.php?t=41194

I get the impression that this may be a false alarm?
I may delete those Trogan things and see what happens…
Do you have any info on these things?

_._______________________________

_.________________________________________________ ____________

Finally, not important, and just out if passing interest…
I personally need to make very detailed notes of anything I do on a
computer, since I have long periods away from the computer and tend to
forget things easily.
For most people these notes are much too long and boring, ( I don't enjoy
reading them myself half the time, LOL ! … )
Strangely, over the years, a small minority of people have found these
notes even more useful than myself, and they encourage me to share them.
So I sometimes post them in the various help forums in which I participate.
But initially, usually I do a sort of "beta" version in a "Scratchpad" Test
Forum which where only a few people I know ever go near (
http://www.excelfox.com/forum/forumd...p/17-Test-Area
)
I leave them there for a few months, then re look at them with a clear mind
at a later date, and possibly then modify them before posting in other
regular Forums, in Tips/Tutorial Sub forums such as these :
http://www.excelfox.com/forum/forumd...s-and-Formulas

http://www.excelfox.com/forum/forumd...ips-and-Tricks

I have started some notes on my recent VPN work
OpenVPN :
http://www.excelfox.com/forum/showth...ll=1#post11652

SoftEther :
http://www.excelfox.com/forum/showth...ll=1#post11605

General notes on VPN :
http://www.excelfox.com/forum/showth...ll=1#post11598

You are welcome to make any comments on those or suggestions of anything to
add.
But I expect it will be some time before I get around to posting them in a
regular Forum.
I might in the meant time add a section on the Windows 7 and higher
solutions , such as your App

_.___________________________
_.___________________________
_.______________________

So mostly all that above was just some feedback for you out of passing
interest.
I probably will take a break from experimenting a lot with the VPN stuff
for a while.
I will be using VPN often, and sometime I will make a log/ notes and or do
the occasional experiment.

Later I will look again in a bit more detail in the solutions for Windows 7
and higher.
I will try to refine the SoftEther/XP fix/workaround as well, possibly
using VBA automation. I do not know if that is possible yet.

_.__

Alan

**DocAElstein** · 04-02-2018, 06:44 PM

Hello Nathan.
First of all , best wishes for the new year to you.

I am responding here to your last Email from Nov 25, 11:28 UTC
Thanks for the extra info. that you gave in that Email.

_.__________

And now some more feedback concerning the connection issues with SoftEther on XP operating system.

I was travelling in Germany and abroad, and repeated some of my SoftEther on XP experiments when using a variety of different internet connections. I did not notice any significantly different characteristics to any experiment when compared to doing them at home.

I took some time to look at the possibility of automating ( via VBA programming ) some of my experiments. This turned out to be quite simple, requiring only fairly simple coding. This has made experimenting both easier / quicker and gave more consistent results. In the same coding, I was also able to automate measuring all the IP addresses associated with a connection.
( http://www.eileenslounge.com/viewtop...=33775#p261628 )
( https://tinyurl.com/rwt2kx8 , https://tinyurl.com/yhrwdsdb ) (The last couple of links are to some of my own notes which I might use in a Blog at a later date )

I tried out ( at home ) some other XP machines that I have not used for a few years. So far the results of any experiments are similar on any machine. So that makes 7 XP machines in total that I have experimented with at some time or another.

_._______________________-
I have mostly looked at Berlin connections, both berlin.hide.me , and the Berlin host name ( number ) which you gave me in your last Email , ( 194.36.108.21 ) …………
So.. Regarding what you said in your last EMail………
( …<……..in the SoftEther VPN setup also try using this IP address 194.36.108.21 instead of the host name for Berlin in the SoftEther setup…………>…..)

Here are some of my latest conclusions
Conclusions 1: Firstly, Similar characteristics of berlin.hide.me and 194.36.108.21 are the following:
_(i) For any connection in SoftEher in XP, a connection will almost always result in a non working internet ( Almost always I get a timeout error after a connection in SoftEher in XP )
_(ii) Occasionally a connection does work. This is usually only the case if a computer has not been used for a few days, or more importantly, a single working connection may be possible the first time using SoftEther and XP if on that computer no attempt has been made at a connection using SoftEther for a few days. ( This is only successful if the first connection is successful: For any connection, if the connection should fail/disconnect and reconnect automatically, then the second and any subsequent re connections will always lead to an internet non working having the timeout problem … see next point _(iii)…….
_(iii) If I have a current working connection, but then disconnect, and re connect to the same host, I will no longer have a working internet. In other words. If I have a working internet, then disconnect, then reconnect to the same server, then the previously working internet will now give me the timeout error.
_(iv) I note that if I disconnect, reconnect, disconnect , reconnect etc. the 10.***.**.*** address remains the same in XP fror SoftEther, even if I wait a long time in between the disconnect and reconnect.
In some cases, the 10.***.**.*** address will however be different if the time in between is very long, such as a few days. One possible conclusion here is that every new connection must have a new 10.***.**.*** address in order to result in a working internet connection. Since a disconnection followed by a reconnection always seems to have the same 10.***.**.*** address in XP, this could explain why I rarely have a successful internet after making a connection, since usually the 10.***.**.*** address does not appear to change. ( I note in passing here, that if I disconnect , then reconnect the same server in SoftEther in Vista or Windows 7 or Windows 8.1, then the 10.***.**.*** address is always different . ( I continue to have no timeout problems in SoftEther in Vista and Windows 7 or Windows 8.1: Connections using SoftEther in Vista and Windows 7 and Windows 8.1 continue to mostly always result in working internet via hide me VPN)

Conclusions 2: Results from ipcongig/ release & ipcongig/ renew
Since automating these commands, I have been able to get more consistent and better results.
_a) I am coming to the conclusion that it is necessary after a connection is stable to do a quick ipconfig / release & ipconfig / renew. It is further important that the connection remains initially connected whilst this is done:
It almost always occurs that a connection is broken as a result of doing these commands. If the commends are done too slowly, then the connection seems to break before the commands are finished. In such cases the result is that the reconnection results in an internet with the timeout error. Without automation of these commends, the results are far less consistent, since by manually doing the commands it is difficult to accurately control the time at which they are done.
If an automatic reconnection is made immediately after these commands is done, then often this results in a working internet. ( We note again that the 10.***.**.*** address will be different to the previous 10.***.**.*** address in the case of a successfully working internet. If the current 10.***.**.*** address and that of a previous connection are the same, then we will usually have the timeout error and so have no working internet. )
It is a consistent result of doing a ipconfig / release & ipconfig / renew , that the 10.***.**.*** address is renewed. In XP the 10.***.**.*** address is never renewed as a result of disconnecting and re connecting. As mentioned previously, in Vista or Windows 7 or Windows 8.1 , the 10.***.**.*** address is always renewed as a result of disconnecting and re connecting
_b) I am coming to the conclusion that the previous 10.***.**.*** address and the one after a reconnection must be different in order to get a working internet. If they are the same, then we will usually have the timeout problem. However, obtaining a different 10.***.**.*** address is not a guarantee that a connection will work. It is required, but so are other things:
It is further important that a connection is stable, and that only one automatic reconnection is done after the quick ipconfig / release & ipconfig / renew. If the connection is unstable as is often the case after the first connection, then getting a working internet gets rather messy, involving a lot of fiddling involving trying doing to do a quick ipconfig / release & ipconfig / renew at the right moment… and / or waiting a long time until the connection is stable and remains connected.

Conclusions 3: berlin.hide.me Versus 194.36.108.21
It appears to me generally that using 194.36.108.21 is much more stable. It is less likely to disconnect ( and then automatically re connect ). Because of this improved stability, the fixes are more likely to work.
For the case of berlin.hide.me I can have a "good day" or a "bad day". On a "bad day", a connection via SoftEther on XP results in the connection frequently disconnecting (and reconnecting automatically ) . Thus instability causes two problems:
_1) The fix is more difficult to do, since the connection may break in between the commands which gives less consistent results.
_2) For every disconnect and reconnect, a fix is usually needed. So more often the fix must be applied.
Occasionally on a very bad day, it has proved impossible to get a connection using XP SoftEther and berlin.hide.me. ( On such cases, as at othe times, I have occaisionally cross checked berlin.hide.me using other systems and Clients ,and connections were always possible in those other systems)

Because 194.36.108.21 appears more stable, I can develop a coding to do the required fix, and have a better solution, all be it requiring extra coding. Since I often have Microsoft Office open on my computers, it is fairly convenient for me to do the fixes via VBA coding. I can for example have a code running in the background which occasionally does a ipconfig / release & ipconfig / renew:
For the case of a working connection using 194.36.108.21 , doing a ipconfig / release & ipconfig / renew will result in both a disconnection and a new 10.***.**.*** address on re connection.
For the case of a non working connection using 194.36.108.21 , doing a ipconfig / release & ipconfig / renew will result in both a disconnection and a new 10.***.**.*** address on re connection, and in addition usually the reconnection will result in a working connection.
In other words, doing a ipconfig / release & ipconfig / renew will "repair" a non working connection via 194.36.108.21 ,and if the ipconfig / release & ipconfig / renew is done on a working connection via 194.36.108.21 , then it does no harm: it simply changes the 10.***.**.*** address

If I am using berlin.hide.me and I have a code running in the background which occasionally does a ipconfig / release & ipconfig / renew, then it might occasionally fix a non working connection, but it could on other occasions cause a working connection to fail due to it causing multiple connections and re connections.

So generally the use of host name 194.36.108.21 is a an improvement and works better for me in SoftEther in XP, compared the host name berlin.hide.me.

If you have any other number alternatives to use in place of other Server host names, then I would be very interested to see if they also give me better results.
( Is this number related to the IP address at which I finally appear when "hiding" via hide.me?

**DocAElstein** · 04-02-2018, 06:55 PM

Final results for first half of master File after second consolidation

Using Excel 2007 32 bit

_Row\^Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	S No	Item	Price	Qty	Total	Distributed	Task1	Task2	Task3	Task4	Completed	Consolidated	Comments	Team Member	Checked
2	1	ABC01	$ 55.00	22	$ 1,210.00	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
3	2	ABC02	$ 13.66	7	$ 95.62	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
4	3	ABC03	$ 12.99	5	$ 64.95	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
5	4	ABC04	$ 8.51	12	$ 102.12	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
6	5	ABC05	$ 7.22	62	$ 447.64	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
7	6	ABC06	$ 3.99	35	$ 139.65	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
8	7	ABC07	$ 333.45	99	$ 33,011.55	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
9	8	ABC08	$ 11.99	1	$ 11.99	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
10	9	ABC09	$ 741.99	101	$ 74,940.99	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
11	10	ABC10	$ 55.00	22	$ 1,210.00	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
12	11	ABC11	$ 13.66	7	$ 95.62	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
13	12	ABC12	$ 12.99	5	$ 64.95	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
14	13	ABC13	$ 8.51	12	$ 102.12	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
15	14	ABC14	$ 7.22	62	$ 447.64	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
16	15	ABC15	$ 3.99	35	$ 139.65	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
17	16	ABC16	$ 333.45	99	$ 33,011.55	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
18	17	ABC17	$ 11.99	1	$ 11.99	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
19	18	ABC18	$ 741.99	101	$ 74,940.99	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
20	19	ABC19	$ 55.00	22	$ 1,210.00	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
21	20	ABC20	$ 13.66	7	$ 95.62	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
22	21	ABC21	$ 12.99	5	$ 64.95	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
23	22	ABC22	$ 8.51	12	$ 102.12	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
24	23	ABC23	$ 7.22	62	$ 447.64	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
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	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu

Worksheet: OriginalData

**DocAElstein** · 04-02-2018, 06:55 PM

Final results for first half of master File after second consolidation

Using Excel 2007 32 bit

_Row\^Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	S No	Item	Price	Qty	Total	Distributed	Task1	Task2	Task3	Task4	Completed	Consolidated	Comments	Team Member	Checked
2	1	ABC01	$ 55.00	22	$ 1,210.00	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
3	2	ABC02	$ 13.66	7	$ 95.62	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
4	3	ABC03	$ 12.99	5	$ 64.95	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
5	4	ABC04	$ 8.51	12	$ 102.12	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
6	5	ABC05	$ 7.22	62	$ 447.64	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
7	6	ABC06	$ 3.99	35	$ 139.65	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
8	7	ABC07	$ 333.45	99	$ 33,011.55	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
9	8	ABC08	$ 11.99	1	$ 11.99	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
10	9	ABC09	$ 741.99	101	$ 74,940.99	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
11	10	ABC10	$ 55.00	22	$ 1,210.00	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
12	11	ABC11	$ 13.66	7	$ 95.62	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
13	12	ABC12	$ 12.99	5	$ 64.95	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
14	13	ABC13	$ 8.51	12	$ 102.12	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
15	14	ABC14	$ 7.22	62	$ 447.64	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
16	15	ABC15	$ 3.99	35	$ 139.65	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
17	16	ABC16	$ 333.45	99	$ 33,011.55	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
18	17	ABC17	$ 11.99	1	$ 11.99	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
19	18	ABC18	$ 741.99	101	$ 74,940.99	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
20	19	ABC19	$ 55.00	22	$ 1,210.00	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
21	20	ABC20	$ 13.66	7	$ 95.62	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018	02.Apr.2018		Margaret
22	21	ABC21	$ 12.99	5	$ 64.95	02.Apr.2018	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu
23	22	ABC22	$ 8.51	12	$ 102.12	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018	02.Apr.2018		John
24	23	ABC23	$ 7.22	62	$ 447.64	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018	02.Apr.2018		Greg
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	RT1	RT2	RT3	RT4	02.04.2018	02.Apr.2018		Raghu

Worksheet: OriginalData

**DocAElstein** · 04-02-2018, 06:57 PM

**DocAElstein** · 04-02-2018, 07:01 PM

Data files after final (second) consolidation:

Using Excel 2007 32 bit

15

ABC15

$ 3.99

35

$ 139.65

02.Apr.2018

GT1

GT2

GT3

GT4

02.Apr.2018

Greg

19

ABC19

$ 55.00

22

$ 1,210.00

02.Apr.2018

GT1

GT2

GT3

GT4

02.Apr.2018

Greg

23

ABC23

$ 7.22

62

$ 447.64

02.Apr.2018

GT1

GT2

GT3

GT4

02.Apr.2018

Greg

27

ABC27

$ 741.99

101

$ 74,940.99

02.Apr.2018

GT1

GT2

GT3

GT4

02.Apr.2018

Greg

31

ABC31

$ 8.51

12

$ 102.12

02.Apr.2018

GT1

GT2

GT3

GT4

02.Apr.2018

Greg

35

ABC35

$ 11.99

1

$ 11.99

02.Apr.2018

GT1

GT2

GT3

GT4

02.Apr.2018

Greg

39

ABC39

$ 12.99

5

$ 64.95

02.Apr.2018

Greg

Worksheet: Tabelle1

Using Excel 2007 32 bit

_Row\^Col	A	B	C	D	E	F	G	H	I	J	K	L	N
11	37	ABC37	$ 55.00	22	$ 1,210.00	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18	02.Apr.2018	Raghu
12	41	ABC41	$ 7.22	62	$ 447.64	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18	02.Apr.2018	Raghu
13	45	ABC45	$ 741.99	101	$ 74,940.99	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18	02.Apr.2018	Raghu
14	49	ABC49	333.45 €	99	33,011.55 €	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18	02.Apr.2018	Raghu
15	50	ABC50	11.99 €	1	11.99 €	02.Apr.2018							Raghu
16

Worksheet: Tabelle1

Using Excel 2007 32 bit

28

ABC28

$ 55.00

22

$ 1,210.00

02.Apr.2018

MT1

MT2

MT3

MT4

02.Apr.2018

Margaret

32

ABC32

$ 7.22

62

$ 447.64

02.Apr.2018

MT1

MT2

MT3

MT4

02.Apr.2018

Margaret

36

ABC36

$ 741.99

101

$ 74,940.99

02.Apr.2018

MT1

MT2

MT3

MT4

02.Apr.2018

Margaret

40

ABC40

$ 8.51

12

$ 102.12

02.Apr.2018

MT1

MT2

MT3

MT4

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

26

ABC26

$ 11.99

1

$ 11.99

02.Apr.2018

JT1

JT2

JT3

JT4

02.Apr.2018

John

30

ABC30

$ 12.99

5

$ 64.95

02.Apr.2018

JT1

JT2

JT3

JT4

02.Apr.2018

John

34

ABC34

$ 333.45

99

$ 33,011.55

02.Apr.2018

JT1

JT2

JT3

JT4

02.Apr.2018

John

38

ABC38

$ 13.66

7

$ 95.62

02.Apr.2018

JT1

JT2

JT3

JT4

02.Apr.2018

John

42

ABC42

$ 3.99

35

$ 139.65

02.Apr.2018

John

Worksheet: Tabelle1

**DocAElstein** · 04-02-2018, 07:17 PM

Code for anwser to this Thread:
http://www.excelfox.com/forum/showth...e-folder/page2

Code:

Option Explicit
Sub consolidateToo() '   http://www.excelfox.com/forum/showthread.php/2238-Copy-data-from-Unique-files-into-Masterfile-all-the-files-in-the-same-folder?p=10595#post10595
Rem 1 ThisWorkbook Info
Dim MWs1 As Worksheet: Set MWs1 = ThisWorkbook.Worksheets.Item(1) 'Worksheets("OriginalData")
Dim DtaFName As String: Let DtaFName = VBA.Dir(ThisWorkbook.Path & "\" & "*.xlsx") ' Search criteria set to all Files with .xlsx extension in the same Folder as this workbook, Dir returns first file name that fits criteria
Dim LrMWs1 As Long: Let LrMWs1 = MWs1.Range("A" & MWs1.Rows.Count & "").End(xlUp).Row
Rem 2 main Loop for all data files
    Do While DtaFName <> "" ' ==========================================
     Workbooks.Open filename:=ThisWorkbook.Path & "\" & DtaFName
    Dim WBDta As Workbook: Set WBDta = ActiveWorkbook
    Dim WBDtaWs1 As Worksheet: Set WBDtaWs1 = WBDta.Worksheets.Item(1) ' use variable to reference the first worksheet ( counting tabs from the left ) of last opened and therefore active( to be seen ) file
    Dim arrIn() As Variant: Let arrIn() = WBDtaWs1.Range("A1").CurrentRegion.Value
    '2a) loop for all data rows, copy data from completed rows to master file, ( add date to inputed data array '_-##)
    Dim Rw As Long ' --------------------------------
        For Rw = 2 To UBound(arrIn(), 1) ' loop through "rows" in data array
            If arrIn(Rw, 11) <> Empty And arrIn(Rw, 12) = Empty Then ' Condition for completed work not yet consolidated
             Dim arrCsDte(1 To 1, 1 To 7) As String: Let arrCsDte(1, 1) = arrIn(Rw, 7): arrCsDte(1, 2) = arrIn(Rw, 8): arrCsDte(1, 3) = arrIn(Rw, 9): arrCsDte(1, 4) = arrIn(Rw, 10): arrCsDte(1, 5) = arrIn(Rw, 11): arrCsDte(1, 6) = Format(Date, "dd.mmm.yyyy"): arrCsDte(1, 7) = arrIn(Rw, 13) ' 7 "columns" of data to be added to master file
             MWs1.Range("A2:A" & LrMWs1 & "").Find(what:=arrIn(Rw, 1), After:=MWs1.Range("A2"), LookIn:=xlValues, Lookat:=xlWhole, searchorder:=xlByRows, searchdirection:=xlNext).Offset(0, 6).Resize(1, 7) = arrCsDte() ' We look down the first column in the master file to find the cell comtaining the   S No   We apply the offest property to thast cell to get across to column G and then the resize property gives us the range of 7 columns to which we may apply the values in the array filled for the row data
             Let arrIn(Rw, 12) = arrCsDte(1, 6) '(Put the current date in the array made from data range        '_-##)
            Else ' Datá row is completed and consolidated , so nothing to do for this row
            End If
        Next Rw ' End loop for all data rows --------
    '2b) Update and close current data workbook
     Let WBDtaWs1.Range("A1").Resize(UBound(arrIn(), 1), UBound(arrIn(), 2)).Value = arrIn() ' reassign the values from the input data array back to the range as this now has the consolidated date in it
     WBDta.Close savechanges:=True
    '2c Serch for next data file name
     Let DtaFName = VBA.Dir() ' Unqualified Dir returns next found file with previos search criteria, but only returns each file name once
    Loop ' Do While DtaFName <> "" again ==============================
End Sub

**DocAElstein** · 04-07-2018, 12:43 AM

Some sample data for other Posts and Threads:
http://www.eileenslounge.com/viewtopic.php?f=30&t=29652
Using this code:

Code:

 Sub Its() ' snb 2017
Dim It As Variant
  For Each It In ThisWorkbook.VBProject.References
  Dim strIts As String
   Let strIts = strIts & "Description:" & vbTab & It.Description & vbCr & "Name:" & vbTab & vbTab & It.Name & vbCr & "Buitin:" & vbTab & vbTab & It.BuiltIn & vbCr & "Minor:" & vbTab & vbTab & It.minor & vbCr & "Major:" & vbTab & vbTab & It.major & vbCr & "FullPath:" & vbTab & vbTab & It.fullpath & vbCr & "GUID:" & vbTab & vbTab & It.GUID & vbCr & "Type:" & vbTab & vbTab & It.Type & vbCr & "Isbroken:" & vbTab & vbTab & It.isbroken & vbCr & vbCr
  Next It
Debug.Print strIts ' From  VB Editor Ctrl+g  to get Immediate Window from which info can be copied
End Sub

Here some results. ( If anyone passing has other Excel versions and would like to pass on what the code above gives, then that would be nice, thanks

)

Excel 2007

Code:

Description:    Visual Basic For Applications
Name:       VBA
Buitin:     Wahr
Minor:      0
Major:      4
FullPath:       C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
GUID:       {000204EF-0000-0000-C000-000000000046}
Type:       0
Isbroken:       Falsch

Description:    Microsoft Excel 12.0 Object Library
Name:       Excel
Buitin:     Wahr
Minor:      6
Major:      1
FullPath:       C:\Program Files\Microsoft Office\Office12\EXCEL.EXE
GUID:       {00020813-0000-0000-C000-000000000046}
Type:       0
Isbroken:       Falsch

Description:    OLE Automation
Name:       stdole
Buitin:     Falsch
Minor:      0
Major:      2
FullPath:       C:\Windows\system32\stdole2.tlb
GUID:       {00020430-0000-0000-C000-000000000046}
Type:       0
Isbroken:       Falsch

Description:    Microsoft Office 12.0 Object Library
Name:       Office
Buitin:     Falsch
Minor:      4
Major:      2
FullPath:       C:\Program Files\Common Files\Microsoft Shared\OFFICE12\MSO.DLL
GUID:       {2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}
Type:       0
Isbroken:       Falsch

Description:    Microsoft Word 12.0 Object Library
Name:       Word
Buitin:     Falsch
Minor:      4
Major:      8
FullPath:       C:\Program Files\Microsoft Office\Office12\MSWORD.OLB
GUID:       {00020905-0000-0000-C000-000000000046}
Type:       0
Isbroken:       Falsch

Excel 2003

Code:

Description:    Visual Basic For Applications
Name:       VBA
Buitin:     Wahr
Minor:      0
Major:      4
FullPath:       C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
GUID:       {000204EF-0000-0000-C000-000000000046}
Type:       0
Isbroken:       Falsch

Description:    Microsoft Excel 11.0 Object Library
Name:       Excel
Buitin:     Wahr
Minor:      5
Major:      1
FullPath:       C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE
GUID:       {00020813-0000-0000-C000-000000000046}
Type:       0
Isbroken:       Falsch

Description:    OLE Automation
Name:       stdole
Buitin:     Falsch
Minor:      0
Major:      2
FullPath:       C:\Windows\system32\stdole2.tlb
GUID:       {00020430-0000-0000-C000-000000000046}
Type:       0
Isbroken:       Falsch

Description:    Microsoft Office 11.0 Object Library
Name:       Office
Buitin:     Falsch
Minor:      3
Major:      2
FullPath:       C:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.DLL
GUID:       {2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}
Type:       0
Isbroken:       Falsch

Description:    Microsoft Word 12.0 Object Library
Name:       Word
Buitin:     Falsch
Minor:      4
Major:      8
FullPath:       C:\Program Files\Microsoft Office\Office12\MSWORD.OLB
GUID:       {00020905-0000-0000-C000-000000000046}
Type:       0
Isbroken:       Falsch

Excel 2010

Code:

Description:    Visual Basic For Applications
Name:       VBA
Buitin:     Wahr
Minor:      1
Major:      4
FullPath:       C:\PROGRA~2\COMMON~1\MICROS~1\VBA\VBA7\VBE7.DLL
GUID:       {000204EF-0000-0000-C000-000000000046}
Type:       0
Isbroken:       Falsch
 
Description:    Microsoft Excel 14.0 Object Library
Name:       Excel
Buitin:     Wahr
Minor:      7
Major:      1
FullPath:       C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE
GUID:       {00020813-0000-0000-C000-000000000046}
Type:       0
Isbroken:       Falsch
 
Description:    OLE Automation
Name:       stdole
Buitin:     Falsch
Minor:      0
Major:      2
FullPath:       C:\Windows\SysWOW64\stdole2.tlb
GUID:       {00020430-0000-0000-C000-000000000046}
Type:       0
Isbroken:       Falsch
 
Description:    Microsoft Office 14.0 Object Library
Name:       Office
Buitin:     Falsch
Minor:      5
Major:      2
FullPath:       C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\MSO.DLL
GUID:       {2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}
Type:       0
Isbroken:       Falsch
 
Description:    Microsoft Word 14.0 Object Library
Name:       Word
Buitin:     Falsch
Minor:      5
Major:      8
FullPath:       C:\Program Files (x86)\Microsoft Office\Office14\MSWORD.OLB
GUID:       {00020905-0000-0000-C000-000000000046}
Type:       0
Isbroken:       Falsch

**DocAElstein** · 05-13-2018, 02:28 PM

To support solution to this Thread:
http://www.excelfox.com/forum/showth...and-send-email

Test data supplied by Thainguyen for this Thread :
http://www.excelfox.com/forum/showth...and-send-email

Code:

Using Excel 2007 32 bit
_Row\^Col
A
B
C
D
E
F
G
H
I
J
K
N

1
Equipment PM












2
Machine EQ.ID
Manufacture
Model
Description
Serial Number
Weekly
 Date of Service
Weekly
 Next Service 
Monthly
Date of Service
Monthly 
Next  Service
Quarterly
Date of Service
Quarterly 
Next Service
Softwear 

3













4
1
JUKI
GKG GL
GL SCREEN PRINTER
A123
06.04.2018
13.04.2018
15.03.2018
12.04.2018
N/A
N/A


5
2
JUKI
KE-1070L
SMT Placement Machine
A124
11.04.2018
18.04.2018
28.03.2018
25.04.2018
N/A
N/A


6
9
ACE Production
KISS-101B
Selective  Wave Solder
A125
06.04.2018
13.04.2018
15.03.2018
12.04.2018
N/A
N/A


7
59
Heller
1826 MK5
Reflow Oven
A126
N/A
N/A
16.03.2018
13.04.2018
N/A
N/A


8
62
Exit Sign -- N/A -- Exit Lights
N/A
N/A
A127
N/A
N/A
N/A
N/A
N/A
N/A


9
69
South-Tek System
N2-Gen 35ST
Nitrogen Generator
A128
10.04.2018
17.04.2018
N/A
N/A
09.03.2018
06.04.2018


10
75
ACE Production
KISS-102
Selective  Wave Solder
A129
16.04.2018
23.04.2018
N/A
N/A
N/A
N/A


11
101
FKN system
N100 Nibbler
Dispensing
A130
N/A
N/A
N/A
N/A
04.04.2018
02.05.2018


12
109
Mycronic
MY200sx
SMT Machine
A131
N/A
N/A
N/A
N/A
N/A
N/A


13
112
X-TEK
XTV-160
X-Ray System
A132
N/A
N/A
N/A
N/A
N/A
N/A


14
113
MIRTEC
MV-6 OMNI
AOI
A133
N/A
N/A
N/A
N/A
N/A
N/A


15
116
JUKI
KE-2060RL
SMT Placement Machine
A134
N/A
N/A
N/A
N/A
N/A
N/A


16
127
ELGI
EG22-150
Air Compressor
A135
N/A
N/A
N/A
N/A
N/A
N/A


17
128
Juki
KE-2050
SMT
A136
N/A
N/A
N/A
N/A
N/A
N/A


18
137
Juki
K3
Screen printer
A137
06.04.2018
13.04.2018
N/A
N/A
N/A
N/A


19
141
Heller
1826 MK5
Reflow Oven
A138
N/A
N/A
N/A
N/A
N/A
N/A


20
142
NISSAN
MCU-112A331.V
Forklift
A139
N/A
N/A
N/A
N/A
15.02.2018
15.03.2018


21
142
NISSAN/yearly oil change and lube
MCU-112A331.V
Forklift
A140
N/A
N/A
N/A
N/A
N/A
N/A


22










28.01.1900


23














Worksheet: Equipment PM

**DocAElstein** · 05-13-2018, 02:31 PM

[FONT=Arial][size=3] [color="#3E0000"]

_2) I am not sure how to "get started" , for example , with a computer with Vista Operating system: You mention "SoftEther setup" . I have been able to Google some information on SoftEther. But I am rather confused as to how
that fits in with a VPN from hide.me. In other words, I have no idea how to "get started" with a computer with
Vista Operating system: What do I download and from where. I am basically looking for a "computer idiots guide" to getting started with your VPN on a Vista computer.
Can you tell me what my first step or steps would be try out a VPN connection on a Vista operating system machine?
(I think I would prefer to get the more difficult option of Vista ( or XP ) working first: It would not be so helpful if I practiced on the simpler Windows 7, and then, after taking full membership option found that I had difficulty getting a VPN on one of my older machines… )

We have our own VPN clients on our website here: https://hide.me/en/software
However there are alternative ways of setting up a VPN connection, you can find all our setup tutorials that do not require our software on https://hide.me/en/vpnsetup/
You can establish VPN connection manually using your operating systems built-in VPN client and one of our setup guides from our tutorial section.
For example, for Windows 7 you can use this guide here: https://hide.me/en/vpnsetup/windows7/ikev2/
You can download all our latest VPN apps from this link, https://hide.me/en/software
Our own VPN client means our own VPN application that is solely our product and it was developed by us.
Please note that SoftEther standalone client/application is not our own product, OpenVPN and SoftEther standalone clients which are still viable for Windows XP/Vista are third party products - none of those are developed by us.
OpenVPN and SoftEther are open source projects and you can check https://en.wikipedia.org/wiki/OpenVPN
And more information on SoftEther project you can find here https://www.softether.org/
Both OpenVPN and SoftEther security wise are one of the best protocols available and you can check this article here: https://hide.me/en/blog/best-vpn-protocol/
________________________________________
For Windows Vista we no longer provide our own VPN application and you only need to follow the steps from SoftEther setup guide here: https://hide.me/en/vpnsetup/windowsvista/softether/
As mentioned in Step 1 of the setup guide you need to download SoftEther standalone client from their website here: http://www.softether-download.com/en...duct=softether

SoftEther VPN
Following the hide me notes and tutorials choosing the SoftEther Option, ( which you also noted in your last Email ) , I have more success. The tutorial form hide me ties up exactly with what one finds at the softether-download site.
The hide me notes for getting the SoftEther VPN "Client" are very clear and easy to follow…
I followed all the steps and I seem to have success!!
( I did get some extra info appear as well , which I am not sure what it
means, .. yet.. : https://imgur.com/hhyGYKf )

_3) I also tried hide me on a lap top with XP operating system using the same SoftEther way which I had used yesterday on a Vista operating system lap top. Once again all went well today with the XP lap top attempt: https://imgur.com/fD5qIwd , https://imgur.com/Uvb82Yv

_.____________

I can't get SoftEther to work on XP
I am mainly interested in getting the SoftEther working in XP and the OpenVPN working in Vista.

_.-________________________

Reg arding SoftEther issues on your XP computer, please uninstall, restart your computer and reinstall SoftEther and follow this setup guide here: https://hide.me/en/vpnsetup/windowsxp/softether/

XP and SoftEther.
In the meantime I have occasionally had a working internet with a connection of hide.me/SoftEther on both the XP machines that I have tried.
It seems that I can occasionally do a connection / disconnection / connection approx 1-3 times and get a working internet. This then works continuously without problems. However if I try further a few times to disconnect and connect , then I get continually the time out error problem.
If I then wait a long period of time, I am then able to do a connection / disconnection / connection a few times and get a working internet once again. If I try further to disconnect/ connect, then once again the time out problem arises and so I must wait again for a long period before a connection produces a working internet.

I will follow your suggestion to de install and re install later when I have more time.

( Currently OpenVPN is working fairly reliably on those two XP machines)

( I note that I did not need to "Confirm a TAP" as I did in a previous instillation on an XP machine ( https://imgur.com/s9bgnNc )

_.________________________________________________
_4 ) SoftEther
( The current main issue was that I could only get SoftEther to work occasionally on my XP machines)
_4a) I have de installed and re installed SoftEther on my XP machines.
The same previous obtained problem remains: If I wait a long period of time, then I am able to do a few reliable working connections and re connections to VPN which both are successful connections and I have a
working internet. After this further attempts at a connection appear successful, but internet does not work. I am not sure yet of exactly how the wait period is. I estimate that it is somewhere between 1

Thread: VPN Forum access and IP addresse Tests

Thread Tools

Display

Checked Library Infomation Excel 2003 Excel 2007 Excel 2010

Test data supplied by Thainguyen

Similar Threads

Table Tests. And Thread Copy Tests No Reply needed

Table Tests. And Thread Copy Tests No Reply needed

New Forum Style

Forum performances

Is that possible to establish between forum page and visual script

Bookmarks

Bookmarks

Posting Permissions

_Row\^Col	A	B	C	D	E	F	G	H	I	J	K	N
1	Equipment PM
2	Machine EQ.ID	Manufacture	Model	Description	Serial Number	Weekly Date of Service	Weekly Next Service	Monthly Date of Service	Monthly Next Service	Quarterly Date of Service	Quarterly Next Service	Softwear
3
4	1	JUKI	GKG GL	GL SCREEN PRINTER	A123	06.04.2018	13.04.2018	15.03.2018	12.04.2018	N/A	N/A
5	2	JUKI	KE-1070L	SMT Placement Machine	A124	11.04.2018	18.04.2018	28.03.2018	25.04.2018	N/A	N/A
6	9	ACE Production	KISS-101B	Selective Wave Solder	A125	06.04.2018	13.04.2018	15.03.2018	12.04.2018	N/A	N/A
7	59	Heller	1826 MK5	Reflow Oven	A126	N/A	N/A	16.03.2018	13.04.2018	N/A	N/A
8	62	Exit Sign -- N/A -- Exit Lights	N/A	N/A	A127	N/A	N/A	N/A	N/A	N/A	N/A
9	69	South-Tek System	N2-Gen 35ST	Nitrogen Generator	A128	10.04.2018	17.04.2018	N/A	N/A	09.03.2018	06.04.2018
10	75	ACE Production	KISS-102	Selective Wave Solder	A129	16.04.2018	23.04.2018	N/A	N/A	N/A	N/A
11	101	FKN system	N100 Nibbler	Dispensing	A130	N/A	N/A	N/A	N/A	04.04.2018	02.05.2018
12	109	Mycronic	MY200sx	SMT Machine	A131	N/A	N/A	N/A	N/A	N/A	N/A
13	112	X-TEK	XTV-160	X-Ray System	A132	N/A	N/A	N/A	N/A	N/A	N/A
14	113	MIRTEC	MV-6 OMNI	AOI	A133	N/A	N/A	N/A	N/A	N/A	N/A
15	116	JUKI	KE-2060RL	SMT Placement Machine	A134	N/A	N/A	N/A	N/A	N/A	N/A
16	127	ELGI	EG22-150	Air Compressor	A135	N/A	N/A	N/A	N/A	N/A	N/A
17	128	Juki	KE-2050	SMT	A136	N/A	N/A	N/A	N/A	N/A	N/A
18	137	Juki	K3	Screen printer	A137	06.04.2018	13.04.2018	N/A	N/A	N/A	N/A
19	141	Heller	1826 MK5	Reflow Oven	A138	N/A	N/A	N/A	N/A	N/A	N/A
20	142	NISSAN	MCU-112A331.V	Forklift	A139	N/A	N/A	N/A	N/A	15.02.2018	15.03.2018
21	142	NISSAN/yearly oil change and lube	MCU-112A331.V	Forklift	A140	N/A	N/A	N/A	N/A	N/A	N/A
22											28.01.1900
23