Doubles in PivotTable
Sometimes when you try to build a Pivot table, the filter shows that all data is unique, while the table presents this data as doubles.
Doubles in PivotTable Read More »
Sony HMZ-T1 disassembly
I decided to disassemble Sony model one (HMZ-T1) 3D-glasses to remove the sprocket that links left and right eye adjustment together.
Sony HMZ-T1 disassembly Read More »
PivotTable Field Name Is Not Valid
Sometimes when you try to create a Pivot table in Excel, it gives the following error: The PivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with labeled columns. If you are changing the name of a PivotTable field, you must type a
PivotTable Field Name Is Not Valid Read More »
Refrigerator noise fix
Most kitchen refrigerators become very noisy after a couple years of use, usually 5 to 7 years. Repairmen mostly give the same diagnosis: replace compressor. Since compressor is the main part of a compressor refrigerator, such repair can be quite expensive. However, it is not always necessary.
Refrigerator noise fix Read More »
Grey Confluence entries
If you got grayed out blog entries in your Confluence dashboard, which fail to be processed by plugins, and Administration Console shows that automatic backups stopped working, it’s a good idea to reboot your Confluence server.
Grey Confluence entries Read More »
Renew Jira and Confluence licence
Do you have to renew your licence to continue using Jira and Confluence?
Renew Jira and Confluence licence Read More »
Force 3D display mode
My Playstation 3 has two displays connected – a flat panel TV and 3D helmet. Both of them are 720p, however, the TV can receive up to 1080i, while the glasses can process 1080p.
Force 3D display mode Read More »
QA flag tutorial
QA Flag is enabling Debug settings on your Playstation 3. This is an official procedure used in service centers, however, to ease it you have to use some hacker utilities, that write changes to flash memory which is always risky. So be careful.
Patch spkg sig check
If you’re following PS3 scene, you probably came across spkg sig check patch without any explanation what is that.
Patch spkg sig check Read More »