RF Cafe Software

RF Cascade Workbook 2005 - RF Cafe
RF Cascade Workbook

Calculator Workbook
RF Workbench
Smith Chart™ for Visio
Smith Chart™ for Excel
RF & EE Symbols Word
RF Stencils for Visio

About RF Cafe

Kirt Blattenberger - RF Cafe WebmasterCopyright
1996 - 2016
Webmaster:
Kirt Blattenberger,
 BSEE - KB3UON

RF Cafe began life in 1996 as "RF Tools" in an AOL screen name web space totaling 2 MB. Its primary purpose was to provide me with ready access to commonly needed formulas and reference material while performing my work as an RF system and circuit design engineer. The Internet was still largely an unknown entity at the time and not much was available in the form of WYSIWYG ...

All trademarks, copyrights, patents, and other rights of ownership to images and text used on the RF Cafe website are hereby acknowledged.

My Hobby Website:
 AirplanesAndRockets.com

Try Using SEARCH
to Find What You Need. 
There are 1,000s of Pages Indexed on RF Cafe !

Electronics World Cover,TOC,and list of posted Popular Electronics articles QST Radio & TV News Radio-Craft Radio-Electronics Short Wave Craft Wireless World About RF Cafe RF Cafe Homepage RF Cafe in Morse Code Google Search of RF Cafe website Sitemap Electronics Equations Mathematics Equations Equations physics Manufacturers & distributors Engineer Jobs Twitter LinkedIn Crosswords Engineering Humor Kirt's Cogitations Engineering Event Calendar RF Engineering Quizzes AN/MPN-14 Radar 5CCG Notable Quotes App Notes Calculators Education Magazines Software,T-Shirts,Coffee Mugs Articles - submitted by RF Cafe visitors Simulators Technical Writings RF Cafe Archives Test Notes RF Cascade Workbook RF Stencils for Visio Shapes for Word Thank you for visiting RF Cafe!

UMTS Transmission Link Planning Tool for Excel™

(Initial release - January 9, 2015)

Mr. Alok K. Tiwari, of Idea Cellular Ltd., has graciously made this UMTS Transmission Link Planning workbook available. Says Mr. Tiwari, "I have formulated Link Budget calculation in Excel spreadsheet for WDCMA. The spreadsheet uses comprehensive detail of RF fundamentals and formulas to decide cell radius, numbers of cell sites, and different types of clutter. The spreadsheet has been designed to help new engineers to understand the WCDMA RF concept in more details." As with his Transmission Link Planning Tool, this spreadsheet provides a very large number of essential calculations for planning purposes based on user-provided parameters. Examples include receiver thermal noise density, noise figure, noise power, interference margin, processing gain, sensitivity, and path loss. Cell radius, range, and hexagonal cell area, and Edge reliability are also among the results. The page of formulas on the last page is a nice adition.

Click to download compressed fileClick to download

Important: If the file name is changed from the supplied "Link Budget_UMTS.xlsx," some of the macros will not function properly. It would be best to save the completed workbook under a new name, then start on new systems with the original file.

Please be sure to thank Mr. Alok Tiwari for his work on this spreadsheet and for making it available at no charge. He will appreciate your feedback with suggestions, comments, etc.

 

UMTS Transmission Link Planning Tool for Excel (Link Budget) - RF Cafe
Link Budget Page


UMTS Formulas (Alok Tiwari) - RF Cafe
UMTS Formulas Page
Hata Okumara Model (Alok Tiwari) - RF Cafe
Hata Okumara Model Page



Adjacent Channel Interference Page 

 

Thanks and with warm regards,

Alok K. Tiwari Head
Network Planning
Idea Cellular Ltd
Delhi (INDIA)
alok.tiwari@idea.adityabirla.com
aktiwari@hotmail.com
Mobile # +91 9990009370

 

 

 

 

Posted  January 11, 2015