How to update the data source of an excel sheet

 

After a CSV file was imported to the excel file, the excel sheet will have connection with the CSV file. If the CSV file was deleted or moved to other folder, you might get the data source error when you try to refresh the data connection:

To quickly fix this error, Open the excel sheet, click menu “Data” > “Queries & Connections” to open the “Queries & Connections” panel, which normally is on the right side of the excel sheet. 

On the “Queries” tab, double click the query that has issue.

This opens the “Power Query Editor” window. Click Menu “Home” > “Advanced Editor” 

On the “Advanced Editor” pop-up window, modify the Source, enter the new Absolute Path of the CSV file. Click Done. This should update the data source.

Another thing that worth to mention is the encoding setting.  I have to change the encoding to 65001, which is “UTF-8”, (Encoding=65001), in order to display some French characters in the CSV file.

Some of the Apple Product Power Supplies

Just for my reference:

 

iPhone 6s Power Supply

         Model No: A1385

         input: 100-240V, 50~60Hz, 0.15A

         output: 5V=1A

 

iPhone 6s Power Supply2

         Model No: A1443

         input: 100-240V, 50~60Hz, 0.15A

         output: 5V=1A

iPhone 12 Power Supply 20W

Model: A2305

Input: 100-240V, 50~60Hz, 0.5A

Output: 5V=3A or 9V=2.22A

iPad: Power Supply (10W)

Model: A1357

Input: 100-240V, 50~60Hz, 0.45A

Output: 5.1V=2.1A

 

 

MacBook Pro 2021

USB-C Power Adapter (140W, 102.5W, 75W, 27W, 15.6W)

Model: A2452

Input: 100-240V, 50~60Hz, 2A

Output: 28.0V=5.0A or 20.5V=5A or 15.0V=5A or 9V=3A or 5.2V=3A

 

MacBook Pro 2019

USB-C Power Adapter (87W)

Model: A1719

Input: 100-240V, 50~60Hz, 1.5A

Output: 20.2V=4.3A or 9V=3A or 5.2V=2.4A

 

MacBook Pro 2014

MagSafe 2 Power Adapter 85W

Model: A1424

Input: 100-240V, 50~60Hz, 1.5A

Output: 20V=4.25A Max

Making Image of A Laptop (Summary)

1.      Summary

A Forensic image is an exact copy of the hard drive. The objective is to capture the image of a hard disk bit by bit without changing even a shred of data. It should also copy the deleted data, including files that are left behind in swap and free space.

 

There are 2 types of the making image of a suspicious system.

1)    Cold copy: The system will be booted from USB sticker or DVD. And run the imager tool from the customized Linux system.

2)    Hot copy: The system installs the imager tool to make the image.

 

It is recommended to use “Cold copy” because the less changes on the suspicious system, the better.

However, in some circumstance, it is not possible to get a cold copy, hot copy can be used. And hot copy can also capture the volatile memory for analysis purpose.

 

Below introduces 3 tools. The first 2 tools are for “Cold Copy” and the last tool is for “Hot Copy”.

1)    Paladin Edge 64 (https://andyinmatrix.blogspot.com/2021/03/making-image-of-laptop.html )

2)    Kali Linux (https://andyinmatrix.blogspot.com/2022/01/making-image-of-laptop-part-2.html )

3)    FTK Imager (https://andyinmatrix.blogspot.com/2022/01/making-image-of-laptop-part-3.html )