ARCHIVE

Excel - how to add a string after 2 or 3 position in columns

You need to write this macro in Visual Basic   Sub replaceat() Dim rng As Range Dim cl As Range Set rng = Range(Selection.Address)   For Each cl In rng.Cells cl.Formula = “=Replace(“”” & cl.Value & “”” ,3,0,””.””)” Next End Sub   Then you can execute it on any selection via the Developer > Macros

Continue reading

FFMPeg Normalize Audio mp3

We can use this command to find the max volume: ffmpeg -i sound.mp3 -af volumedetect -f null -y nul &> original.txt It will return something like [Parsed_volumedetect_0 @ 0x7fa4f7d00000] n_samples: 4997376 [Parsed_volumedetect_0 @ 0x7fa4f7d00000] mean_volume: -27.6 dB [Parsed_volumedetect_0 @ 0x7fa4f7d00000] max_volume: -12.3 dB [Parsed_volumedetect_0 @ 0x7fa4f7d00000] histogram_12db: 663 [Parsed_volumedetect_0 @ 0x7fa4f7d00000] histogram_13db: 1846 [Parsed_volumedetect_0 @

Continue reading

How to force mp3 file to download PHP

Force mp3 to download instead of playing Just add a .htaccess file in the mp3 folder with this content: <Files *.*> ForceType application/octet-stream Header set Content-Disposition attachment </Files>
Things that are better in mac os x then on windows

Hello I’m going to show you some productivity features that exist on Mac OS X and are completely lacking in Windows, another issue that many businesses are facing is that so many staff are now working from home so it’s very hard to know what they are all doing. You can find out how to

Continue reading

Merge two mp3 / music with ffmpeg sample commands

Some commands you can use to merge 2 mp3   ffmpeg -i input1.mp3 -i input2.mp3 -filter_complex amerge -ac 2 -c:a libmp3lame -q:a 4 output.mp3     ffmpeg -i input1.mp3 -i aj-loop.wav -filter_complex “amix=inputs=2:duration=longest” -ac 2 -c:a libmp3lame -q:a 4 output.mp3     ffmpeg -i /Applications/MAMP/htdocs/testimages/test/input1.mp3 -i /Applications/MAMP/htdocs/testimages/test/aj-loop.wav -filter_complex “amix=inputs=2:duration=longest” -ac 2 -c:a libmp3lame -q:a 4

Continue reading

{"type":"main_options","images_arr":"'#ffffff'","enable_ajax":"off","soundcloud_apikey":"","bg_isparallax":"off","bg_slideshow_time":"0","bg_transition":"none","site_url":"https:\/\/digitalzoomstudio.net","theme_url":"https:\/\/digitalzoomstudio.net\/wp-content\/themes\/qucreative\/","blur_ammount":"26","width_column":"50","width_section_bg":"","width_gap":"30","border_width":"0","border_color":"#ffffff","translate_cancel_comment":"Cancel reply","translate_leave_a_comment":"Leave a comment","translate_leave_a_comment_to":"Leave a comment to","is_customize_preview":"off","width_blur_margin":"30","gallery_w_thumbs_autoplay_videos":"off","content_enviroment_opacity":"30","menu_enviroment_opacity":"70","base_url":"https:\/\/digitalzoomstudio.net"}
{"type":"darkfull"}