Spent | Budget tracking and money management web app | Dashboard library

Although I am very rusty on my VBA, I have saved sheets to new workbooks many times before. This code is failing with the error code "Method 'SaveAs' of object '_Workbook' failed"

I am modeling a Time-constrained CVRP. The problem is to minimize the total travel time (not including the package dropping time) subject to vehicle (delivery) capacity and total time spent (per vehicle) constraints. The package dropping time refers to an additional time to be spent at each node, and the total time spent equals to the travel time plus this additional time. I have the below model that works for a single vehicle-type case. I would like to introduce two-vehicle type concept in there, meaning that I have a set of V1 type vehicles and another set of V2 type vehicles. The only difference of the vehicle-types is the per time cost of travel. Let x denote the per time unit cost of travel by V1, and y denote the per time unit travel cost of V2. How can I design the model so that it incorporates this additional aspect?

I have spent some hours playing with Electron and I have observed that it consistently takes more than 2.5 seconds to draw a trivial html file to the screen. The timeline is roughly as follows:

• 60 ms: app ready event is triggered; we create a window using new BrowserWindow()
• 170 ms: a blank window appears on the screen
• 2800 ms: the window shows the specified HTML

I have set up a repository with my code, which is derived from Electron's quick start docs.

Regarding my machine, I am running Windows 10 on a ThinkPad T460 from 2016 with a SSD and enough memory.

Shipping an application that shows a blank window for so long upon startup is a no-go for me. I assume most people developing Electron apps think similarly. Hence my first question: am I doing something wrong? Or is this the expected loading time for a trivial Electron app?

Assuming this is normal behavior, what is the common way to deal with this problem? Some ideas come to mind:

1. Asking Electron to show a splash screen: unless there is specific built-in functionality for this, it seems like a no-go, since the splash screen itself would be shown only after 2.5 seconds.
2. Hide the app's window until it is rendered (using the ready-to-show event), so no blank window is shown. This isn't ideal, since it means that the user doesn't get any feedback whatsoever that the application is actually loading.
3. Create a wrapper application (using native code) that displays a splash screen, launches electron and hides itself once the electron window is shown. Kind of defeats the purpose of using Electron in the first place, because you end up writing native code and adding accidental complexity.
4. Setting the background color of the window to something resembling your app, as suggested by the docs. This just doesn't look very well.

Given this must be a common problem, I hope standard solutions have been found by the community. I'd be glad if someone can point me in the right direction.

I have old django project and new django project. I created dump file from database of old django. And also I made changes in tables and created new tables.

Now I want to load that dump file to my new django app. I am facing errors when I firstly migrate then restore data or firstly restore then migrate.. When I do migration first, it says tables already exist.

When I do restore first , it says django.db.utils.ProgrammingError: relation "django_content_type" already exists I use migrate --fake error goes but new tables are not created in database.

I spent 3-4 days but could not succeed.

Please, help me if you can.

PS: my database is postgresql

How to remove VIM (completely) and change my mac command line editor to sublime?

I've spent the last three hours reading the same links on "how to remove VIM" only to get "how to remove MacVIM and reinstall it fresh" Or "How to remove Vim so I can reinstall it on Ubuntu"

My old laptop was fortunate to have a friend remove it but my new machine still has it installed.

I wish VIM would die in "words redacted to excessive profanity" dumpster fire while a hobo "words redacted to excessive profanity" to put out the fire

I've lost way too many hours trying to learn that outdated neckbeard elvish piece of UX trash so I want it gone. No, I'm not touching emacs.

Please tell me there is a way I can switch to sublime or am I permanently cursed to have this confusing black screen of death pop up when I try to git push or git tag stuff?

My original goal was to tag a git and push it but vim comes up and I can't figure out how to speak elvish.

I've been using PyCharm for a few years and love the interface but I need to dig deeper and a TDD Django book for class uses the terminal, it wants me to git -a "comments" so I need your advice.

So now I can't learn TDD Django because vim, MacVim and eMacs users flood the internet but I can't remove it nor figure out how to work it.

I've tried brew uninstall macvim which doesn't work because I have vim not macvim

I also tried sudo uninstall vim no luck as this is zsh mac not ubuntu

I tried brew uninstall vim to get No available formula or cask with the name "vim"

I've searched SO five times and keep getting the same links. Alternates I've tried brew uninstall ruby vim

per this post https://superuser.com/questions/1096438/brew-upgrade-broke-vim-on-os-x-dyld-library-not-loaded I tried, no luck.

I have an image (QR image) that i have to display it, and keep refreshing it every time. I tried many solutions but none worked, this is my code:

I will go straight to the point.

I have a variable called showForm const [showForm, setShowForm] =useState(false); I am controlling if I should show a form or not with it .

The form will also be shown after 20s using setTimeout and I initialise a timeoutId (let timeoutId;) variable on global scope to keep track of the setTimeout.

I have a useEffect hook with an if statement that checks the value of showForm

I'm looking to combine rows when the start of a postcode matches.

I have the following SQL table:

I'm experienced with Pandas but stumbled upon a problem that I can't seem to figure out.

I have a large dataset ((40,000, 16)) and I am trying to group it by a specific column ("group_name" for this matter) and then for each group apply the following rules so it'd merge into one row per group:

• x1, x2, x3 are the "important" columns, if one row has less nulls than the others, take it. (see example with row D)
• If there are conflicts in any column, it's arbitrary and we can pick whatever.
• Combine the nulls on the important fields (x1, x2, x3), see example with row A.

Here is an example with 6 rows that should turn into 4 groups (aka 4 rows).

So far I have groups = df.groupby['group_name']

I tried many other solutions such as summing each group, applying a transformation, aggregating by each 'important' column, merging on each 'important' column and more. Each solution brought it's own problems so I'm offering this question here without limiting people to a certain way.

Also, I spent nearly two days combining different solutions from other questions but none has seem to work. Perhaps I've missed something.

• Please note that since this is a large dataset, I'd very much like to avoid using for loop on each group since efficiency is something to consider here.

I hope I explained everything properly, please let me know if something is unclear.

Code to re-create the dataframe (thanks to @Henry Ecker from the first answer):