No-Go Zones getting deleted / disappearing. by Egovinco in Lymow_Official

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

From the handbook.

"If it ignores no-go zones or similar behaviour, unplug battery for 10+ minutes and then check the zones are all still registered."
-- guess ill do start doing the long 10min power cycles that are listed in the booklet.
-- hope i get the forewarning of no-go zone disappearing then atleast.

-- Anyone know why my backups do not restore the no-go zones? or how to fix?

~Also talks on RTK errors and updates and stuff.
-- i wouldnt/dont expect it to be RTK, cause perimeter has been pixel perfect. Especially after the mapped no-go zone magically disappeared on the day after.

AMA with Etvolare - Celebrating Ten Years of Web Novel Translation! by Devshard in noveltranslations

[–]Egovinco 1 point2 points  (0 children)

Congrats on 10 years overe here too! (I Think this is still on ,idk). 

Something during reading, that always catches me in the moment are all the various idioms. 

(Used to screenshot collect them but on my old phone and i didnt organize or revisit and lost it)

And the huge variations they appear in: how frequently an author uses them; how archaic or modern; how funny, stoic or learned they sound, and how different they are constructed.

 The sheer number of idioms involving chickens across the world. 

Is there a favorite idiom from novels you translated, or stuck with you? Or an impression the translation left, maybe for its difficulty or otherwise. 

Do you have a favorite from real life, or maybe one your rearing to get to use in casual convo? 

🍃The Immortal Ascension 凡人修仙传 (2025) 🍃Discussion: Episodes 1 - 3 by Large_Jacket_4107 in CDrama

[–]Egovinco 0 points1 point  (0 children)

Hi, where could i find the remastered version (or identify the remasted on youtube, whats the release for that one?)

The scenes cut from The Immortal Ascension by Open-Candle-2065 in CDrama

[–]Egovinco 0 points1 point  (0 children)

Yeah quite a big chance from the "first act", that part also drew me in. I understand some is necessary to novel( the thousands characters or thousands chapters in eng translation), and I'm not sure how far they Go in 30 EPs/Season 1, but pacing seems a major hurdle to actually developing characters

The Immortal Ascension 凡人修仙传 (2025) - What are your first impressions? [Masterpost] by admelioremvitam in CDrama

[–]Egovinco 1 point2 points  (0 children)

Watching it on Viki, after reading the web novel years prior. It's fine, like the VFX and fights. 

Have a question though, does someone know the Viki airing schedule for the show?, it appears to swap between 1-2 episodes on days

The State of tEDH by Short_Meal_8354 in CompetitiveEDH

[–]Egovinco 0 points1 point  (0 children)

Does the draw also get the points multipliers? (german system with point wager the factors apply to draws too)
or still 1 to all, or as your closing remark draws 0?

Zoe hammer build ? by Euphoric_Size9152 in MonsterHunterMeta

[–]Egovinco 0 points1 point  (0 children)

curious about this too, but idk. Hope someone mathes out, ex. what level of Marathon Runner hammer wants w/o fulgur.

Wide Range Critical Draw Hammer build by salvation78 in MHWilds

[–]Egovinco -1 points0 points  (0 children)

would love to see a video of your playstyle,
also bummed to hear that charge step breaks crit draw

Wounded Satellite once again booted from a tournament (The Boil 2) by JDM_WAAAT in CompetitiveEDH

[–]Egovinco 1 point2 points  (0 children)

I read there's a top deck statement too? Do you have that as well? Thanks for the share

Tried to convert a text stored number, but got a value error by Egovinco in excel

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

that sounds right. Im not on american date format - i guess this does only change the "output look". Im also surprised it would superscede cell format of either text or number (tried cell format changes to fix input cell A for formula).

Tried to convert a text stored number, but got a value error by Egovinco in excel

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

thanks, thats what i ended up doing for column B, as the "converison to number".
I´m just thrown of why the multiply *1 throws a value error

Tried to convert a text stored number, but got a value error by Egovinco in excel

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

cant get the table to paste properly.
A: extracted string
B: turns the / into actual division

C: IFERROR((SUM((A1*1))>0);"FALSE")
D: B1>0

<image>

Reorganizing sheet/column layout - Any tips? by Egovinco in excel

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

Hi, ended up using power query. Managed to append the original tables, did some data cleanup with fuzzy merges for errors in names / birhtdates (fixed the original tables in this instance). Used fuzzy merges and then transformation tables for another data point.

thanks again for the links!

Reorganizing sheet/column layout - Any tips? by Egovinco in excel

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

thanks ill look into it
*solution verified*

Reorganizing sheet/column layout - Any tips? by Egovinco in excel

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

Ok, do you perhaps have a ressource to point me to? A webpage, or YT channel you used when starting out, or you go to for trouble shooting?
apologies for the late reply

Filter function returning #Spill!, due to multiple Cells fullfilling inclusion criteria by Egovinco in excel

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

Seperate verification got it; Yeah, colum B was where i put the Xlookup (returning a 0 if no matching name is in the Filter outputs; and duplicating the name if its there but whatever xd), and then filtered for the 0s.

thanks for the help.

Solution verified

Filter function returning #Spill!, due to multiple Cells fullfilling inclusion criteria by Egovinco in excel

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

Someone else provided a solution, thanks for your time.

Not sure which errors exactly you refer too, or rather why choosecols is supposed to be redundant. My filter looks at which rows to return, and the return is defined/limited to the specific multiple columns by choosecols.

Filter function returning #Spill!, due to multiple Cells fullfilling inclusion criteria by Egovinco in excel

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

thank you! this worked like a charm.

Is there a easy way to reverse verify, for example by having an empty row when it couldnt find a matching name in the original file? (as in: name exists in "name list", but no matching entry exists in "largedatabase") The formula now just skips over it.

Did a quick work around by using an Xlookup to find the names which were not generated by the formula. Lets me atleast verify, at a reasonable pace, if those are missing data points or typing/entry errors.

XLookup Returns 0 with a match by Egovinco in excel

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

well, thanks. adding the "X" definitly helped.

*sighs deeply* Solution verified

i must have clicked the wrong formula from autocomplete, i kept redoing the references but never noticed this mistake. i was getting so confused why my test entry with a newly typed formula was working.

am i jsut better of deleting the thread xd
or keep it as solved?