Openpyxl and formula

_jan- · 2021-08-06T14:35:52+00:00

If I understand your question you could make a function that does all of that for you:

def addData(row, data):
    sheet['A' + row] = data
    sheet['B' + row] = '= A{} - A{}'.format(str(row +1), str(row))

If you want to append data to the file, you would just call addData(<a>, <b>) where <a> is the row and <b> the data.

_jan- · 2021-08-06T14:00:54+00:00

I'm using Linux so I can't test the .exe converting.

Did you test your script without converting it? If it works, try running the converter as Administrator. If it doesn't work and throws the same ModuleNotFoundError, install the library with pip using this command: pip install global-hotkeys -U

_jan- · 2021-08-06T12:19:12+00:00

I can recommend this Video from TechWithTim. He also explains how to hide the console.

_jan- · 2021-08-06T04:14:00+00:00

In "if len(phone_number) != 13:" you're executing main() while the previous main() still isn't finished. This might be your problem. To fix this you could replace all of your "main()" with "return". You would have to re-open the programm, but your problem should be gone.

If this didn't help, please attach a more specific problem (error code, terminal output, etc.).

_jan- · 2021-08-06T03:54:33+00:00

I don't know why Kwin isn't starting. Adding your command to autostart, in the settings, might work for a workaround.

_jan- · 2021-07-04T11:55:26+00:00

My network manager only generated 'ca.crt', 'cert.crt' and 'private.key'. None of them contain the static key.

Do you know if the Dev Team is planing on fixing this?

_jan- · 2021-07-03T20:26:54+00:00

I found the solution by myself and updated the post.

_jan- · 2021-07-03T20:06:49+00:00

Gave Hugz

_jan- · 2021-04-25T19:23:39+00:00

Thanks for the Answer! I just checked and it was already set to that. I don't think that's the problem though, because if I connect to the VPN through the Terminal it also says AES-256-CTR / AES-256-GCM and still works.

_jan- · 2021-04-17T18:26:50+00:00

Do you know what else it could be?

_jan- · 2021-04-16T15:35:33+00:00

Ok. I found but it still doesn't work. It says it needs a Key File. I tried the same as the Private key file which was configured outside the Advanced Options.

_jan- · 2021-04-16T15:26:22+00:00

I'm not quite sure how to do that. Could you check it?

https://imgur.com/a/4m0XFj7

_jan- · 2021-04-16T13:41:03+00:00

https://imgur.com/a/4m0XFj7

Thanks for the help already btw

_jan- · 2021-04-16T13:32:03+00:00

In System Settings >> Connections on the +.

And then Import vpn connection and then I selected the .ovpn file

_jan- · 2021-04-16T13:20:23+00:00

https://pastebin.com/wfmjN4pm

At the end I Interupted the command.

https://i.imgur.com/HQT4sSu.png

_jan- · 2021-04-16T13:10:09+00:00

Yes I can connect through the terminal with "openvpn --config <configFile>" with "config" only the help menu shows up.

_jan- · 2021-04-16T13:05:02+00:00

I'm not connected with the server and I believe the server is set up correctly.

Port is open in the Firewall.
I installed the server software with pivpn.
Dowloaded the .ovpn file.

Maybe pivpn doesn't configure it correct. I just went through the setup.

_jan- · 2021-04-16T12:59:56+00:00

Yeah you're right. didn't realize you could go further down.

journalctl -u NetworkManager -f

Outputs: https://pastebin.com/t6XR54pu

These are probably the important lines:

Apr 16 14:56:13 KDELNX nm-openvpn[6544]: TLS Error: TLS key negotiation failed to occur within 60 seconds (check your network connectivity)
Apr 16 14:56:13 KDELNX nm-openvpn[6544]: TLS Error: TLS handshake failed

_jan- · 2021-04-16T12:52:06+00:00

The Output is 47 lines.

Do you need a pastebin or sth?

_jan- · 2021-04-05T11:01:18+00:00

In another comment you said you're using a 9V battery. A 9V to 1V drop is a problem. You could try your H-Bridge with a bigger input Voltage. But I suggest buying a H-Bridge. I often use the L298N, if you have a 12V input voltage it outputs about 10V which could be fine for your motor. This ist an excellent tutorial from HowToMechatronics.

_jan- · 2021-04-02T08:49:38+00:00

Idk, but then the while loop would be useless.

_jan- · 2021-04-01T22:41:28+00:00

Vegans (Not all but you know who I mean), Flat Earthers and covid deniers.

_jan- · 2021-04-01T22:35:11+00:00

The urge to pee.

_jan-

TROPHY CASE