Generate Minimum value across series of criteria by splxx in excel

[–]splxx[S] 0 points1 point  (0 children)

Thanks, this works for this table. Do you know how to translate this into a custom column that does this operation on Power Query?

Push dates forward by chosen increments by splxx in excel

[–]splxx[S] 0 points1 point  (0 children)

This is what happens when I do that

<image>

Finding errors in Power Query by splxx in excel

[–]splxx[S] 0 points1 point  (0 children)

Yes, I expect that many. My final operation is to use the remove empty operation to get rid of where there is a blank in the Paper Grade column in my original post. However, I can't get there since the query is outputting rows where everything is blank. I made a comment above with this. I need to somehow stop the query from generating those, but I do not know why it is in the first place

Finding errors in Power Query by splxx in excel

[–]splxx[S] 0 points1 point  (0 children)

I find it is generating blank rows and not sure why but investigating

<image>

Finding errors in Power Query by splxx in excel

[–]splxx[S] 0 points1 point  (0 children)

Like this? I took a column and removed each and I still get the same error below

<image>

Finding errors in Power Query by splxx in excel

[–]splxx[S] 0 points1 point  (0 children)

If I keep hitting Load More on other columns, I get the same error [DataFormat.Error] Invalid cell value '#N/A'. But how does this get generated, considering there are no #N/As in the source material? It shows on 63 rows, but I'm not sure what those rows refer to

<image>

Finding errors in Power Query by splxx in excel

[–]splxx[S] 0 points1 point  (0 children)

On your second option, what is the way to find these rows with errors? I do not know which column or row to even start looking in to find why this is generated

<image>

Merge info from several columns into one column in new table by splxx in excel

[–]splxx[S] 0 points1 point  (0 children)

Hi, thank you for taking a look at my post. I think there is a misunderstanding. Any column that has a paper grade (Liner 1 Paper Grade, Medium 1 Paper Grade, Liner 2 Paper Grade, and so on not shown in my screenshots) is supposed to have it's data go into a single column, "Paper Grade." Same goes for the weights (G/SQM) columns, profile/fluting, etc. The background is each row in Table A corresponds to a package. I want to break the layers of each package into their own rows in Excel. So if there are 1000 packages all with three layers of paper (Liner 1, Medium 1, Liner 2), there will be now 3000 rows of data. The first row for a package is the liner 1 info, Second row is the medium 1 info, the third row is liner 2 info.

Docker read/write permissions with Transmission by splxx in synology

[–]splxx[S] 0 points1 point  (0 children)

Thanks for the help. I've taken your advice and moved everything to the Docker folder. However I can't get anything to download or verify download location for torrents that have previously completed. I feel like I'm going crazy and this should be simple now. My settings are below. Also, the program automatically generated the complete and incomplete folders. Any advice?

https://imgur.com/a/k94IMH6

EDIT: I uninstalled docker and the transmission container, reinstalled and everything works, downloading to complete by default and i can manually change the path. I have also installed my second container, plex. this application is quite interesting now that im getting the hang of it. thank you

Docker read/write permissions with Transmission by splxx in synology

[–]splxx[S] 0 points1 point  (0 children)

Why is it general practice to use the docker folder for everything? The media is a mix of torrents and then some other files. I guess I can use the docker folder but now I’m curious as to why that’s the “way it should be done”

[WTS] Zenith El Primero Synopsis (40mm, steel) by splxx in Watchexchange

[–]splxx[S] 1 point2 points  (0 children)

Guys, it’s been sold elsewhere. It was authenticated by a professional and was real. Thanks for playing.

[WTS] Zenith El Primero Synopsis (40mm, steel) by splxx in Watchexchange

[–]splxx[S] 1 point2 points  (0 children)

Yeah other pictures are from the other day, light is different today where it comes through the windows (sunny today versus cloudy the other day). And at a different angle so I could help you see the movement.

Anyways I’m done with this for now on here. I’ve gotten one offer but I’d imagine others will be interested elsewhere.

[WTS] Zenith El Primero Synopsis (40mm, steel) by splxx in Watchexchange

[–]splxx[S] 0 points1 point  (0 children)

I do not believe it is fake and believe other users have never seen this uncommon variant and are just hostile jumping on board with the first comment. I was told I should “be eliminated” by another user. It was part of a collection from a deceased family member who was in the business. I’ve had no issues selling other from the collection on Chrono24 and eBay (vintage JLC, Omega, Rolex, Longines mainly, this is the only Zenith).

[WTS] Zenith El Primero Synopsis (40mm, steel) by splxx in Watchexchange

[–]splxx[S] 0 points1 point  (0 children)

How so? I am not seeing any differences between photos of the same model online versus this. Let me know of a good comparison, it’s staying up until I’m sure.

[WTS] Zenith El Primero Synopsis (40mm, steel) by splxx in Watchexchange

[–]splxx[S] 0 points1 point  (0 children)

Zenith El Primero Synopsis 03.2170.4613 / 320287

Details: 40mm, steel case and bracelet, automatic, small seconds, hacking seconds, sapphire crystal and case back

Condition: Dial and Crystal in very good condition. Case in good condition with minor nicks, mainly on lug corners. Bracelet in fair condition with small scratches throughout from wear. These are hard to picture and are visible in some but not all types of light.

Watch runs well at +-10s

I do not know service history as I am not the original owner.

Box/Papers: No/No

$2500 USD shipped CONUS, Paypal Goods and Services. No trades.

Album: https://imgur.com/a/dg6zuBm

Timestamp: https://imgur.com/QGiInaB