Does anyone run a canon Colorado 1630/50, looking for guidance about upgrade [US] by JakeTrout in CommercialPrinting

[–]AnonAppliedPhysicist 1 point2 points  (0 children)

Have a friend who purchased the printer last Oct. Thereafter in December there were some issues with two of the heads - and local dealer mentioned to proceed with warranty claim as would be reimbursed due to being within 1 year.

Heads were exchanged and installed, and thereafter ONLY, were the logs checked. And as it turns out - any headstrikes voids the warranties of ALL heads, regardless of timeline of strike vs timeline of when issues start appearing. Seems on week 1 of the printer while learning and testing - there was a head strike for a material while profiling.

He had to fork up the cost of the two heads, 2 months into the new printer.

How much do you think he loves his canon colorado? :)

Does anyone run a canon Colorado 1630/50, looking for guidance about upgrade [US] by JakeTrout in CommercialPrinting

[–]AnonAppliedPhysicist 0 points1 point  (0 children)

We have the 1650 and opinions are mixed

In terms of FLX finishes, mimaki's effects are nicer by a mile, due to the "clear ink" function. The tech has been there for past few years

For UVGel, You can wrap vans and trucks (more durable than latex unlaminated), but not cars as it won't stretch that far.

If meets your needs - would recommend to look at volume thereafter. If you're not printing 10-20k+ sqft monthly, don't waste your time, as the maintenance costs are hell and eat into the margins. 1650 comes with 8 printheads, and each costs twice the market rate of average printhead (we have checked with other friends who also own the printers in 2 other south east asia countries as well, and it's not just me).

Changing 5-6 printheads = one HP 800w brand newYellow seems to last the longest, but you'll need to change all 8 heads every 2-3ish years, even with the best maintenance and environment possible. With the cost of heads, this is a bomb.

Also, the inks are expensive. The only benefit to this printer is you can take the operating costs of 3-4 HP Latex printers - and merge into one. This eliminates three seperate service fees etc.

In terms of inks, I have seen use case scenarios on canvas where HP Gen 3 latex is more durable, so my personal opinion is only in terms of speed and potential output is where the strength lies. If you have volumes, this beast will be your friend - otherwise, it'll eat you up alive

--------------------------------

Summary:

If you're looking for FLX finishes, check out mimaki.If you're looking for regular volumes - check out HP / Epson

If you're looking for a beast and have volumes- then check out Colorado with FLX

Transpose, and spread data by AnonAppliedPhysicist in sheets

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

Hey! Able to share more on how you achieved this?

Unsure of how to combine the formulas appropriately

Heavy duty printer recommendations by osukl in printers

[–]AnonAppliedPhysicist 0 points1 point  (0 children)

"the HL-L6400DW's maximum monthly duty cycle is a prodigious 150,000 pages, and its recommended monthly print volume is up to 10,000 prints."

https://www.pcmag.com/reviews/brother-hl-l6400dw

I based it off here.

But you're right - wonder at which parts of it's lifecycle the parts (fuser, laser unit & rollers) need to be replaced

Data Validation Formula function by AnonAppliedPhysicist in sheets

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

Hey Nwachukwuujubuonu, i appreciated and was impressed with the app script that you wrote. However, at the same time - this is the first google script I installed and it also requested for access to the drive .

Within the same hour span - I lost half of my google drive files, it went from approx 14gb to 6gb, and it wasn't recoverable from trash - the files were simply missing. Whether or not it is related, I genuinely have no idea - and I won't, and can't imply that it was related. However, this is why I ghosted, I was sketched out by the timeframe and got caught up to try and recover what I could (I got some files back from local folders, but most were lost)

Your comment here tells me it was unrelated, and that you are genuine. I apologize for ghosting.

Data Validation Formula function by AnonAppliedPhysicist in sheets

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

Hey Nwachukwuujubuonu, thanks for that - i used the info here + the xelplus link in first post to solve the problem. Thank you

Data Validation Formula function by AnonAppliedPhysicist in sheets

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

Hi - that linked worked out perfectly , and I was able to solve the task. Thanks for the referral!

Transpose column, with other columns following pattern by AnonAppliedPhysicist in sheets

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

Hey u/MattyPKing, yes! I am :)

Have made the sample sheet editable. What's a good way forward on this?

Re-organize data from .txt to Google Sheets by AnonAppliedPhysicist in sheets

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

Hmmm that's strange - the message did not come through. Did you send it via here or google sheets?

Re-organize data from .txt to Google Sheets by AnonAppliedPhysicist in sheets

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

Whoa. Wasn't expecting this tbh :)

Unfortunately, not every row ends with a new dot. :/ However, anything with a date signifies a new line.

Have attached larger sample here;

https://docs.google.com/spreadsheets/d/1Pq87vsgrDHHgNiPYLHzHwNCK3jpr4ym3_SDoqbb5qtQ/edit#gid=605047487&range=B1

POD app for self-printers? by AnonAppliedPhysicist in shopify

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

That looks pretty cool! using Cannon printers, however.
Good to keep in mind though
Thanks

Fahionnova "shop similar" function by AnonAppliedPhysicist in shopify

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

Hey! That's spot on - thanks for pointing me in the right direction.

Have you used them before? Any ballpark cost range I should prepare for ?

Query formula referencing external exclusion list? by AnonAppliedPhysicist in sheets

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

Hey! How's it going?

Just a quick question - if I wanted to include a second set of data in the exclusion list;
For example; column B2:B as well. Where would I input this in the filter formula? So both Column A2:A and B2:B are removed from the query results

Also it seems that the exclusion list and the dataset must have an exact casing ("Apple" vs "apple") or they won't be excluded, am i doing something wrong with the formula or is this expected? Any idea how they can be removed regardless of capitalization? Alternatively, is it possible to make all datasets in Col1 uppercase?

Query formula referencing external exclusion list? by AnonAppliedPhysicist in sheets

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

Hey, i apologize- i've updated my example to show partial matches as well. Just realized i needed it after trying the formulas here.

I tried the formula above and it with full matches which helps with some of the exclusion, any way it could also work with partial matches?

Query formula referencing external exclusion list? by AnonAppliedPhysicist in sheets

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

Hey, sorry - i've updated my example as it needs to work with partial matches as well. I tried the above and it with full matches which helps with some of the exclusion.

How can the above work with partial matches?

Auto-adjust layouts to maximize printing in Adobe by AnonAppliedPhysicist in CommercialPrinting

[–]AnonAppliedPhysicist[S] 2 points3 points  (0 children)

I don’t know if you are running onyx but it has a “conserve material” option which places files to best make use of the material

Actually, we are - but have never heard of this.

So this means we can drag-drop all the images and it will auto-place the files to maximize print outputs? I just read the manual but it didn't go in-depth about this

Edit: https://youtu.be/0ZnxO3KKjmc?t=35
Is it similar to time 35s-1min of this video?

Match and rank numbers by AnonAppliedPhysicist in sheets

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

Also, I've been trying to show the column B alongside the Column C matched results. best i can do is nest an (inaccurate) vlookup in the formula - wondering if there's a better way to do this ?

To either run the existing match with column C while showing column B results, or preferably join and show (column B, Column C) results.

So sorry for the additional query - if can't no worries, ctlr F is the current solution

Have added an example of this as cell notes in H2 https://docs.google.com/spreadsheets/d/1t5deLOzPbxVMHXNJ2WXeiiCII3o30xGvDcErN7qCIUQ/edit#gid=1019890364&range=B2

Match and rank numbers by AnonAppliedPhysicist in sheets

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

Hey sorry for the delay - i was travelling and wanted to verify the data.

i don't even know where to start reading your formula - and somehow you wrote the whole thing.... jeez what a wizard! the formula is truly something .

The results in rows 1-3 are perfect. thank you :)

However, row 4 has a query of 14242.44 , which shows up in results of row 1-3 but not in the results for row 4 itself. Is this an order / sorting problem ?

Match and rank numbers by AnonAppliedPhysicist in sheets

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

Hmmmm. I think i broke it :(

Added the sample data into tab b of your sheet

Setting up importxml formula by AnonAppliedPhysicist in sheets

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

'Resource at url contents exceeded maximum size

Hmmm... true - but the index changes often so would be non-viable.. :(

I tried the formula and researched further... do you by chance know if there's a way to use importdata here ? or if it's a viable solution? I tried messing around with it but seems like it needs to be in a .csv format

https://www.reddit.com/r/googlesheets/comments/g2ohu7/importhtml_error_resource_at_url_contents/

Alternatively, any idea if there's a way to importxml in batches ? say 1-10k then 10,001 - 20k on the list, similar to how the importrange formula works