Total Pageviews

Featured Post

Excel tips and tricks

Things to Remember Borders can be used with the shortcut key Alt + H + B, which will directly take us to the Border option. Giving a border...

Monday, January 30, 2023

Excel tips and tricks

Things to Remember Borders can be used with the shortcut key Alt + H + B, which will directly take us to the Border option. Giving a border in any data table is very important. ... Always make proper alignment so that once we frame the data with a border and use it in different sources, the column width will be automatically set. Ctrl+; – Inserts the date. Ctrl+Shift+: – Inserts the current time. Ctrl+0 – Hides the selected column. Ctrl+9 – Hides the selected row. Ctrl+` – Reveals all of the formulas embedded in your spreadsheet. Ctrl+PageUp or PageDown – Toggles between sheets in the currently open workbook. F2 – Start editing the current selected cell vs. double clicking. Shift+F10 – Opens the right-click menu for the selected cell.

Friday, July 15, 2022

Audio /video testing



 common issues:

  1.  No two-way  Audio or video  
  2. Audio is low even volume level is appropriate
  3. Default volume level not set
  4. Audio/video  lagging(no sync) /glitches
  5. Echoing
  6.  Noise suppression/echo cancellation
  7. video grainy stuck dark 
  8. Autoframing
  9. Splitting views

 


How do we test it?

  1. Using an audio setup from the sender side, we play an audio file with noise or a mix of noise and voice, to see if the voice is not suppressed along with the noise.
  2. On the receiver side, we mute the microphone because there are some features that reduce incoming audio during speech and can impact results.
  3. During the call, we record the processed audio on the receiver side.
  4. After the call, receiver side recording is compared with the original audio file that was played from the sender side using waveform graphs of the audio tracks.
  5. We analyze the amount of time it takes for the noise suppression to start taking effect (delay).
  6. We analyze the amount of suppression applied by comparing receiver side recording volume with the original noise file volume (in dB).
  7. We analyze the consistency of the suppression throughout the receiver-side recording.
  8. We also listen to the recordings, to further determine the amount and quality of suppression.


  1. For result consistency, we play a constant audio file from the sender side using an audio setup.
  2. On the receiver side, we either play silent audio (not muted) or play a constant audio file to see how the incoming audio reacts with outgoing audio (how the echo interacts with the audio that the receiver is sending back to the sender).
  3. During a call, we record:
    1. the outgoing audio on the sender side (naturally, it would be the audio recorded by the microphone)
    2. the incoming audio on the receiver side (the audio that is coming out of the receiver device speaker)
    3. the outgoing audio on the receiver side (the audio that is recorded by the receiver device microphone)
    4. the incoming audio on the sender side (the audio that is coming out of the sender device speaker)
  4. After all the necessary audio files have been recorded in a call:
    1. Each file is listened to to assess the echo level and sound quality.
    2. We compare each file with the original audio file played on the sender side to see which parts and how much of the audio became echo, using visual representations of the audio tracks for more straightforward analysis.
    3. We measure the delay between sent and received audio – the delay of echo.
    4. The maximum volume of each audio file is measured to see how the volume changes during voice processing.


another blog: How we test noise suppression, echo cancellation, and other voice processing features for communication apps – Audio & video testing laboratory (audiovideotestlab.com)



Audio analyzers: What they are and what they do | KnowTechie

MP4 to WAV - Convert audio online (aconvert.com)

Thursday, April 28, 2022

Notes to be succesful

1. Increase Dependency in the team

2. Updates on current work

3. Upcoming works releases 

4. Meetings-Active listening

5. Initiation motivation 

6. Be on top of it- follow up email's communication

7. Initial questions to gather info like 

 what build?

what environment ?

what accounts ?

what feature ?

what are the steps  ?

what are the expected results?

what tools?

what versions?

ETAs to complete tasks

8. Prioritize tasks

9. unblock

      10. Curiosity to learn new things.



Friday, March 25, 2022

Windows explorer debugging

 Situation: Explorer does not work/crash/slow

Task: make explorer work

Action and resolution:

  1. observe what is doing crashing/slow
  2. Restart 
  3. check for updates (WU)
  4. Check additional updates
  5. Uninstall latest installed malfunctioning app
  6. Uninstall recent WU 
  7. What changes made to file explorer
  8. Is there alternate ways to open explorer(windows +x then search)
  9. virus/corruption
  10. drivers issue? update driver
  11. Boot to safe mode and check if the issue persists. If the issue does not persist then the issue may be due to third party software/applications. To determine which third party app/program is causing this issue, we will try placing the computer in clean boot state and check.
  12. Run System File Checker tool (SFC) scan and check if there is any system file missing or corruption found. This scan will help you to replace the corrupted or missing system files. below commands

This issue might occur if the system files are missing or corrupted. I suggest you to use the Deployment Image Servicing and Management (DISM) tool to fix Windows corruption errors. Here's how:

1. Right click on Start, click on Command Prompt (Admin).

Type Dism /Online /Cleanup-Image /ScanHealth and press Enter.
Type Dism /Online /Cleanup-Image /CheckHealth and press Enter.
Type Dism /Online /Cleanup-Image /RestoreHealth and press Enter.

2. Check to see if the issue is resolved. If not, restart the system.


9.Take help in support


10. Event ID 1000 usually points to an error with the Windows Explorer process. Once you've located a suitable error, select it, then check the General information listed below. This will provide some background on the cause of the issue, which you may need to research and troubleshoot further



shortcuts

 Add/Remove Programs

 appwiz.cpl


Add Hardware Wizard
 hdwwiz.cpl


Automatic Updates
 wuaucpl.cpl
 
Bluetooth Properties
 bthprops.cpl
 
Display Properties
 desk.cpl
 
Firewall Properties
 firewall.cpl
 
Game Controllers
 joy.cpl
 
Internet Options
 inetcpl.cpl


iSCSI Initiator
 iscsicpl.cpl
 
Java Control Panel
 jpicpl32.cpl
  
Licensing Mode
 liccpa.cpl
 
Mouse Properties
 main.cpl
 
Network Connections
 ncpa.cpl


Network Setup Wizard
 netsetup.cpl
 
ODBC Properties
 odbccp32.cpl
 
Power Options
 powercfg.cpl
 
Regional and Language Options
 intl.cpl
 
Sound and Audio Devices
 mmsys.cpl


Stored Passwords
 keymgr.cpl


System Properties
 sysdm.cpl
 
Telephone and Modem Properties
 telephon.cpl


Time and Date Settings
 timedate.cpl
 
User Accounts nusrmgr.cpl
 
Windows Security Center
 wscui.cpl


Wireless Link
 irprops.cpl


Thursday, March 24, 2022

What are the top skills you should learn for the future?

 What are the top skills you should learn for the future?

  • Artificial intelligence

    Coding. ...
  • Cloud computing. ...
  • Blockchain. ...
  • UX design. ...
  • Critical thinking. ...
  • Emotional intelligence. ...
  • Communication. ...
  • Leadership. Possessing strong leadership skills means that you know how to effectively motivate and direct others, setting up your entire team for success.

Wednesday, January 26, 2022

Microsoft Windows OS few basics:

  1.  Settings
  2. Registry-regedit
  3. Control Panel- appwizard.cpl
  4. Events viewer
  5. Services.msc
  6. Network and internet settings
  7. VPN
  8. PBR
  9. BMR
  10. Power and sleep settings
  11. Account settings
  12. Sound settings
  13. Windows explorer
  14. computer management
  15. Winver
  16. System information
  17. Ease of access
  18. Task manager
  19. Task scheduler
  20. Device manager
  21. Disk management
  22. Windows updates
  23. Firewal
  24. Apps features
  25. Add device
  26. Display settings
  27. Time and language
  28. Windows store
  29.  
  30. 100-shortcuts-using-keyboard.pdf (utoledo.edu)
100 Shortcuts using keyboard CTRL+C ::::::(Copy) CTRL+X ::::::(Cut) CTRL+V ::::::(Paste) CTRL+Z ::::::(Undo) DELETE ::::::(Delete) SHIFT+DELETE::: :::(Delete the selected item permanently without placing the item in the Recycle Bin) CTRL while dragging an item :::(Copy the selected item) CTRL+SHIFT while dragging an item :::(Create a shortcut to the selected item) F2 key ::::::(Rename the selected item) CTRL+RIGHT ARROW ::::::(Move the insertion point to the beginning of the next word) CTRL+LEFT ARROW ::::::(Move the insertion point to the beginning of the previous word) CTRL+DOWN ARROW::: :::(Move the insertion point to the beginning of the next paragraph) CTRL+UP ARROW ::::::(Move the insertion point to the beginning of the previous paragraph) CTRL+SHIFT with any of the arrow keys :::(Highlight a block of text) SHIFT with any of the arrow keys :::(Select more than one item in a window or on the desktop, or select text in a document) CTRL+A ::::::(Select all) F3 key ::::::(Search for a file or a folder) ALT+ENTER::: :::(View the properties for the selected item) ALT+F4 ::::::(Close the active item, or quit the active program) ALT+ENTER::: :::(Display the properties of the selected object) ALT+SPACEBAR::: :::(Open the shortcut menu for the active window) CTRL+F4 ::::::(Close the active document in programs that enable you to have multiple documents open simultaneously) ALT+TAB :::(Switch between the open items) ALT+ESC :::(Cycle through items in the order that they had been opened) F6 key :::(Cycle through the screen elements in a window or on the desktop) F4 key :::(Display the Address bar list in My Computer or Windows Explorer) SHIFT+F10 :::(Display the shortcut menu for the selected item) ALT+SPACEBAR :::(Display the System menu for the active window) CTRL+ESC :::(Display the Start menu) ALT+Underlined letter in a menu name :::(Display the corresponding menu) Underlined letter in a command name on an open menu :::(Perform the corresponding command) F10 key :::(Activate the menu bar in the active program) RIGHT ARROW :::(Open the next menu to the right, or open a submenu) LEFT ARROW :::(Open the next menu to the left, or close a submenu) F5 key :::(Update the active window) BACKSPACE :::(View the folder one level up in My Computer or Windows Explorer) ESC :::(Cancel the current task) SHIFT when you insert a CD-ROM into the CD-ROM drive :::(Prevent the CD-ROM from automatically playing) Dialog Box Keyboard Shortcuts CTRL+TAB :::(Move forward through the tabs) CTRL+SHIFT+TAB :::(Move backward through the tabs) TAB :::(Move forward through the options) SHIFT+TAB :::(Move backward through the options) ALT+Underlined letter :::(Perform the corresponding command or select the corresponding option) ENTER :::(Perform the command for the active option or button) SPACEBAR :::(Select or clear the check box if the active option is a check box) Arrow keys :::(Select a button if the active option is a group of option buttons) F1 key :::(Display Help) F4 key :::(Display the items in the active list) BACKSPACE :::(Open a folder one level up if a folder is selected in the Save As or Open dialog box) m*cro$oft Natural Keyboard Shortcuts Windows Logo :::(Display or hide the Start menu) Windows Logo+BREAK :::(Display the System Properties dialog box) Windows Logo+D :::(Display the desktop) Windows Logo+M :::(Minimize all of the windows) Windows Logo+SHIFT+M :::(Restore the minimized windows) Windows Logo+E :::(Open My Computer) Windows Logo+F :::(Search for a file or a folder) CTRL+Windows Logo+F :::(Search for computers) Windows Logo+F1 :::(Display Windows Help) Windows Logo+ L :::(Lock the keyboard) Windows Logo+R :::(Open the Run dialog box) Windows Logo+U :::(Open Utility Manager) Accessibility Keyboard Shortcuts Right SHIFT for eight seconds :::(Switch FilterKeys either on or off) Left ALT+left SHIFT+PRINT SCREEN :::(Switch High Contrast either on or off) Left ALT+left SHIFT+NUM LOCK :::(Switch the MouseKeys either on or off) SHIFT five times :::(Switch the StickyKeys either on or off) NUM LOCK for five seconds :::(Switch the ToggleKeys either on or off) Windows Logo +U :::(Open Utility Manager) Windows Explorer Keyboard Shortcuts END :::(Display the bottom of the active window) HOME :::(Display the top of the active window) NUM LOCK+Asterisk sign :::(*) :::(Display all of the subfolders that are under the selected folder) NUM LOCK+Plus sign :::(+) :::(Display the contents of the selected folder) NUM LOCK+Minus sign :::(-) :::(Collapse the selected folder) LEFT ARROW :::(Collapse the current selection if it is expanded, or select the parent folder) RIGHT ARROW :::(Display the current selection if it is collapsed, or select the first subfolder) Shortcut Keys for Character Map After you double-click a character on the grid of characters, you can move through the grid by using the keyboard shortcuts: RIGHT ARROW :::(Move to the right or to the beginning of the next line) LEFT ARROW :::(Move to the left or to the end of the previous line) UP ARROW :::(Move up one row) DOWN ARROW :::(Move down one row) PAGE UP :::(Move up one screen at a time) PAGE DOWN :::(Move down one screen at a time) HOME :::(Move to the beginning of the line) END :::(Move to the end of the line) CTRL+HOME :::(Move to the first character) CTRL+END :::(Move to the last character) SPACEBAR :::(Switch between Enlarged and Normal mode when a character is selected) m*cro$oft Management Console :::(MMC) Main Window Keyboard Shortcuts CTRL+O :::(Open a saved console) CTRL+N :::(Open a new console) CTRL+S :::(Save the open console) CTRL+M :::(Add or remove a console item) CTRL+W :::(Open a new window) F5 key :::(Update the content of all console windows) ALT+SPACEBAR :::(Display the MMC window menu) ALT+F4 :::(Close the console) ALT+A :::(Display the Action menu) ALT+V :::(Display the View menu) ALT+F :::(Display the File menu) ALT+O :::(Display the Favorites menu) MMC Console Window Keyboard Shortcuts CTRL+P :::(Print the current page or active pane) ALT+Minus sign :::(-) :::(Display the window menu for the active console window) SHIFT+F10 :::(Display the Action shortcut menu for the selected item) F1 key :::(Open the Help topic, if any, for the selected item) F5 key :::(Update the content of all console windows) CTRL+F10 :::(Maximize the active console window) CTRL+F5 :::(Restore the active console window) ALT+ENTER :::(Display the Properties dialog box, if any, for the selected item) F2 key :::(Rename the selected item) CTRL+F4 :::(Close the active console window. When a console has only one console window, this shortcut closes the console) Remote Desktop Connection Navigation CTRL+ALT+END :::(Open the m*cro$oft Windows NT Security dialog box) ALT+PAGE UP :::(Switch between programs from left to right) ALT+PAGE DOWN :::(Switch between programs from right to left) ALT+INSERT :::(Cycle through the programs in most recently used order) ALT+HOME :::(Display the Start menu) CTRL+ALT+BREAK :::(Switch the client computer between a window and a full screen) ALT+DELETE :::(Display the Windows menu) CTRL+ALT+Minus sign :::(-) :::(Place a snapshot of the active window in the client on the Terminal server clipboard and provide the same functionality as pressing PRINT SCREEN on a local computer.) CTRL+ALT+Plus sign :::(+) :::(Place a snapshot of the entire client window area on the Terminal server clipboard and provide the same functionality as pressing ALT+PRINT SCREEN on a local computer.) m*cro$oft Internet Explorer Navigation CTRL+B :::(Open the Organize Favorites dialog box) CTRL+E :::(Open the Search bar) CTRL+F :::(Start the Find utility) CTRL+H :::(Open the History bar) CTRL+I :::(Open the Favorites bar) CTRL+L :::(Open the Open dialog box) CTRL+N :::(Start another instance of the browser with the same Web address) CTRL+O :::(Open the Open dialog box, the same as CTRL+L) CTRL+P :::(Open the Print dialog box) CTRL+R :::(Update the current Web page) CTRL+W :::(Close the current window)