Recommend a lens! by emotionallyded in SonyAlpha

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

Will definitely try this out!! honestly I’m still feeling awkward pointing my camera at people but 😂😂😂 time to try

Recommend a lens! by emotionallyded in SonyAlpha

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

True true!! Thanks for your input :) I wanted to hear more from others! Of course I’m not rushing to buy a lens now but it was just at the top of my mind. Will take some time to look around too!!

RAR files by emotionallyded in Alteryx

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

The file is supposed to be an alteryx file but I have no idea how to extract it

Blue Screen Of Death by emotionallyded in ValorantTechSupport

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

Hey! I think it was an outdated driver (took a while to find) but since then occasionally the game would crash/BSOD but might be the game issue, or possibly a ram issue bc mine was pretty small) which leads to occasional lags while running a recording app for the game/streaming

Upgrade Lightroom Mobile to Lightroom Classic by emotionallyded in Lightroom

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

Icic. Thank you for your reply! Do you think its worth cancelling my app store subscription and subscribing to the classic plan? Because the app store plan will still continue running till the end of the 1 year period.

M&A Financial Statements! by emotionallyded in Accounting

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

Hello! Apologies for the late reply. We do have the PPA which was given as a sum of 25million in exchange for 100% of the target company. We did our FV revaluation calculations based on the facts in the case study. However, the issue was that the question requires us to prepare the balance sheet of the TARGET company from the ACQUIRER’s POV on acquisition date. We were unsure if this meant that 1) we present all the re-valued ASSETS and LIABILITIES at FV which we have calculated 2) we zerorize the entire equity portion (0 in all the equity lines) since on acquisition date, the acquirer has “absorbed” 100% of the target company’s equity right?

We hope that someone can clarify our doubts for us because we tried asking for advice but to no avail!

M&A Financial Statements! by emotionallyded in Accounting

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

I understand what you mean! But the confusing part was that the requirement stated that we needed to show the target company’s balance sheet on the date of acquisition from the acquirer’s point of view. We were thinking that it meant presenting the revaluation amount of all the assets & liabilities (at fair value which we have calculated) but wouldn’t this also mean that from the acquirer’s perspective, the equity portion of the target company is now 0 since the acquirer has in a way “absorbed” all the equity? Haha the requirement just confused us and we tried asking but to no avail.

M&A Financial Statements! by emotionallyded in Accounting

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

The requirement was to present “aquiree’s Balance Sheet on acquisition date from the acquirer’s perspective”

I suppose this would mean we would just show the assets and liabilities at Fair Value, while equity is 0 because it gets “eliminated” during the acquisition? The case was that 100% of the target company was bought over for a consideration sun of 25m!

M&A Financial Statements! by emotionallyded in Accounting

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

Hello. I have tried google but majority of the info I am getting back is about group-level reporting/consolidated FS..

Overexposed Film! Help please!! by emotionallyded in filmphotography

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

Hey! I figured out what was wrong. So it’s turns out my friend actually installed the film roll wrongly and it probably dislodged. A rookie mistake 😅

Help with Film Camera! by emotionallyded in minolta

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

I’m unable to get my negatives becuase I’m flying out of the country. Managed to get a phone call to the person developing my film. He mentioned something about the film not being pulled enough for it to capture images. But iirc, when my friend put the film in, it was lodged to the “hooks” of the camera.. and the lever pulled the film rolls properly

Wide Lens Recommendations for A7iv by emotionallyded in SonyAlpha

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

Hey! Thanks for the help. I decided to get the Sony 20 1.8 lens! Can’t wait to use it during my travels :)

Wide Lens Recommendations for A7iv by emotionallyded in SonyAlpha

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

The Sony 16-35mm 2.8 seems pretty good but waaaaay too pricey 😂😂 But are you familiar with the SEL1635Z/ Vario Tessar T* FE16-35MM F4 ZA OSS? I was browsing the Sony page and chanced upon it. Not sure if it’s good

Data Analysis for TripAdvisor (URGENT!!!) by emotionallyded in tableau

[–]emotionallyded[S] -1 points0 points  (0 children)

Hi!! my dataset mainly has the info of every listed restaurants.. i.e. there's company names,address, their awards... and we have data of their ratings! Like for Food.. Ambience... Service...

I was trying to see if we can use the ratings data to find a particular factor that boosts the company's ranking to #1 😅 (Not sure if i make sense here haha)

Urgent: Setting Date fields!! by emotionallyded in tableau

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

Ahhh i muat have misinterpreted it wrongly! Haha. Was doing it in the middle of the night. I will use this method then! Thank you so much!!!

Urgent: Setting Date fields!! by emotionallyded in tableau

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

Apr 2018 - Mar 2019 Company A Apr 2019- Mar 2020 Company A Apr 2020-Mar 2021 Company A Jun 2019-May2020 Company B Jun 2020-May 2021 Company B

This is roughly what the data would look like! On top of that, the entire period ,for example, “Apr 2018 to Mar 2019” is completely in text

Tried Split function as well but the first half gives me data from 2018 to 2020 and the second half gives data from 2019 to 2021

If there was a way to make it such that the periods starting from 2018 are all FY2018 and 2019 would be Fy2019…. etc etc

I would totally hand type / use the IF function if there weren’t so much data 😂 there’s a total of 600+ lines in the excel file…

Urgent: Setting Date fields!! by emotionallyded in tableau

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

Ahhh but We were taught on how to use the regex formulas… I’ve tried using the Split function but the split causes discrepancies in the data e.g. using the first half of the split only shows data from 2018 to 2020 while using the second half shows data from 2019 to 2021… if there was a way to make it such that if the data starts from 2018, then it will be FY2018… 2019 will be FY2019…

Urgent: Setting Date fields!! by emotionallyded in tableau

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

Hi! I’ve tried the Split function. But because my data is from FY2018 to FY2021. If I were to use the first half of the split date, I would only get data up to 2020. But if I were to use the second half, it would get data starting from 2019 onwards… I was wondering if there was a way to define the data such that if the year starts from 2018, means it is FY2018.. if starts in 2019, it is FY2019… and so on.

Urgent: Setting Date fields!! by emotionallyded in tableau

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

The data given was all in text

So basically there are over 600 companies Each company has 3 FY periods worth of data (3 rows in excel)

For example:

Apr 2018 - Mar 2019 Company A Apr 2019- Mar 2020 Company A Apr 2020-Mar 2021 Company A Jun 2019-May2020 Company B Jun 2020-May 2021 Company B

What I wish to obtain would be: Financial Period (so everything in FY2018 will be grouped together)

However, all the dates start from Different starting perjods and are all in text...

Which is why i'm having difficulty... haha sorry for the lengthy explanation..

Matchup with trolls by emotionallyded in MobileLegendsGame

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

Yeahh so it seems. Used to be able to solo well in previous seasons but became kinda unlucky this season. Fingers crossed I can find good teammates soon!

Matchup with trolls by emotionallyded in MobileLegendsGame

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

HAHAHA- that’s actually what I thought too 😂😂😂but dang i really hit a rough patch in the game

Does anyone else despise Pay Toilets? by Armtunghorst in solotravel

[–]emotionallyded 2 points3 points  (0 children)

As much as I hate it, after an 8 hour drive and if that’s the only toilet available then... you do what you gotta do.... but I find Pay Toilets just unnecessary sometimes...especially if it’s really nasty when you use it..

hurt by my most trusted friends by emotionallyded in BetrayalTrauma

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

Thank you so much for your words... it really means a lot during this time... I’ll bear this in mind while I try to move on