Tuesday, January 3, 2023

Get file path and set hyperlink funtion in Excel

 =CONCATENATE("file://",LEFT(CELL("filename",F2),FIND("[",CELL("filename",F2))-1),F2)

=HYPERLINK($G$2,F2)

Tuesday, December 20, 2022

Remove Autodesk software from Mac

 

Uninstall products using the Remove utility

For some products, you can run the Remove ProductName utility in the Finder > Go > Applications > Autodesk folder. The Remove utility uninstalls both the application file and residual files.

  1. Locate the Remove <product name> utility in Finder > Go > Applications > Autodesk.
  2. Double-click Remove <product name> to uninstall a product, where product name is, for example, AutoCAD or AutoCAD LT.

If the Remove utility isn’t available for your software, follow the steps in the next section.

Uninstall products manually

  1. Uninstall all Autodesk programs by right-clicking the program icon and choosing Move To Trash.
  2. Open a Finder window and navigate to the root of the local hard drive and delete the following folders:
    • /Library/Autodesk
    • /Library/Application Support/Autodesk
    • /Users/[username]/Adlm
    • /Users/[username]/Library/Application Support/Autodesk 
      Note: The Library folder is usually hidden. To show it, click the Go menu in the Finder and hold down the Option key.
    • /Users/username/.flexlmrc
    • /Library/Frameworks/Adlm.framework/
    • /Applications/Autodesk/Adlm
  3. Navigate to the folder /Library/Preferences/Flexnet Publisher/FLEXnet and delete the files with the adskflex prefix.
  4. Find and delete the folder /Library/Application Support/Flexnet Publisher
  5. Important:  Don’t delete this folder if you’re running Adobe products on your Mac. Adobe products also use FlexNet. Deleting this folder can cause problems if the Adobe products are still installed. 

Wednesday, December 14, 2022

Composer dependencies issues

 Error 1: Composer detected issues in your platform: Your Composer dependencies require a PHP version ">= 7.4.0"

Solution: composer install --ignore-platform-reqs

Remove autodesk Completely

 

  • ~/Library/Application Support/
  • ~/Library/Containers/
  • ~/Library/Caches/
  • ~/Library/Preferences/
  • ~/Library/Cookies/
  • ~/Library/Logs/
  • ~/Library/LaunchAgents/

Install homebrew mac m1 monterey to run xforce keygen

/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"

commands: 
brew --version 
brew install upx 
upx --version 
sudo upx -d {drag keygen from desktop to terminal}

Run these three commands in your terminal to add Homebrew to your PATH:

    echo '# Set PATH, MANPATH, etc., for Homebrew.' >> /Users/architectfaishalbhuiya/.zprofile

    echo 'eval "$(/opt/homebrew/bin/brew shellenv)"' >> /Users/architectfaishalbhuiya/.zprofile

    eval "$(/opt/homebrew/bin/brew shellenv)"


see:
https://brew.sh/

MacPro M1 Monterey Xforce Keygen not opening


Instructions:

Copy xf-adesk19 to your Desktop


Open terminal  (Command+Space and type Terminal and press enter/return key)


Paste the following code in terminal:


Code Block 

ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)" < /dev/null 2> /dev/null

Wait for the command to finish. After completion run the following code:


Code Block 

brew install upx

Now run this command:


Code Block 

sudo upx -d ~/Desktop/xf-adesk19.app/Contents/MacOS/x-force

Close the terminal and open the xf-adesk19 on your Desktop.


Done!




Install rosetta 2 on Mac M1 2021 Pro

softwareupdate -install-rosetta -agree-to-license

or
softwareupdate --install-rosetta

How to get Ranking of the Students in Excel using RANK Function

=RANK(number,ref,[order]) To rank in descending order, we will use the formula =RANK(B2,($C$5:$C$10),0) If we want unique ranks, we can use...