Electronics World articles Popular Electronics articles QST articles Radio & TV News articles Radio-Craft articles Radio-Electronics articles Short Wave Craft articles Wireless World articles Google Search of RF Cafe website Sitemap Electronics Equations Mathematics Equations Equations physics Manufacturers & distributors Engineer Jobs LinkedIn Crosswords Engineering Humor Kirt's Cogitations RF Engineering Quizzes Notable Quotes Calculators Education Engineering magazine articles Engineering software Engineering smorgasbord RF Cafe Archives RF Cascade Workbook 2018 RF Symbols for Visio - Word Advertising RF Cafe Forums Magazine USAF Radr Shop Sponsor RF Cafe RF Electronics Symbols for Visio RF Electronics Symbols for Office Word RF Electronics Stencils for Visio Thank you for visiting RF Cafe!
ConductRF Phased Matched RF Cables - RF Cafe
TotalTemp Technologies (Thermal Platforms) - RF Cafe
 

About RF Cafe

Kirt Blattenberger - RF Cafe Webmaster

Copyright: 1996 - 2024

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 World Wide Web (Internet) was largely an unknown entity at the time and bandwidth was a scarce commodity. Dial-up modems blazed along at 14.4 kbps while tying up your telephone line, and a nice lady's voice announced "You've Got Mail" when a new message arrived...

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

Windfreak Technologies SynthHD PRO - 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 addition.

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

Hata Okumara Model (Alok Tiwari) - RF Cafe

Hata Okumara Model Page

 - RF Cafe

Adjacent Channel Interference Page 

UMTS Formulas (Alok Tiwari) - RF Cafe

UMTS Formulas 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

RF Cafe Sponsors
RIGOL Technologies (test equipment) - RF Cafe
Innovative Power Products Passive RF Products - RF Cafe

Please Support RF Cafe by purchasing my  ridiculously low−priced products, all of which I created.

These Are Available for Free