Tag: Array

ZerotoMastery – Supercharge Excel with Dynamic Array Functions & Formulas

Free Download ZerotoMastery – Supercharge Excel with Dynamic Array Functions & Formulas

Released 12/2024
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Beginner | Genre: eLearning | Language: English + subtitle | Duration: 19 Lessons ( 3h 9m ) | Size: 597 MB
Harness the power of one of Excel’s newest and most powerful features: Dynamic Array Functions and Formulas. Simplify workflows, supercharge productivity, and master dynamic data management.

(more…)

Linkedin – Excel Using Dynamic Array Functions


Free Download Linkedin – Excel Using Dynamic Array Functions
Released: 10/2024
Duration: 2h 46m | .MP4 1280×720, 30 fps(r) | AAC, 48000 Hz, 2ch | 460 MB
Level: Advanced | Genre: eLearning | Language: English
Dynamic array functions in Excel allow users to perform calculations on multiple cells at once, saving time and increasing efficiency. This allows users to build more robust spreadsheets, in less time, with fewer errors. Follow along with Excel MVP Oz du Soleil as he walks you through Excel’s calculation engine and demonstrates how to make the most of dynamic array functions. He walks through all the key functions-including UNIQUE, SORT, SORTBY, SEQUENCE, FILTER, and newer functions like TOCOL and CHOOSECOLS-showing practical, real-world uses for each one. Plus, learn how to use the spilled range operator (#) to reference a dynamic spill range. Oz concludes the course with a series of challenges so viewers can practice and master dynamic arrays.

(more…)

450+ Array Interview Questions and Answers


Free Download 450+ Array Interview Questions and Answers: MCQ Format Questions | Freshers to Experienced | Detailed Explanations by Manish Salunke
English | August 14, 2024 | ISBN: N/A | ASIN: B0CZTH7CCK | 618 pages | EPUB | 0.46 Mb
450+ Array Interview Questions and Answers MCQ Format Questions Freshers to Experienced Detailed Explanations

(more…)

Multibeam Phased Array Antennas as Satellite Constellation Ground Station (Modern Antenna)


Free Download Multibeam Phased Array Antennas as Satellite Constellation Ground Station (Modern Antenna) by Guolong He, Xin Gao, Rentian Zhang
English | November 22, 2023 | ISBN: 9819979099 | 113 pages | MOBI | 16 Mb
This book focuses on the multi-beam phased array antenna as a satellite ground station. As there are already many excellent books on phased array antennas in the literature, this book focuses mainly on some engineering practices and fills the gap between principles and practices, such as array excitation error impact analysis and calibration methods, array geometry design for hemispherical coverage, multiple beam resource management, etc. This book is particularly suitable for readers interested in satellite constellation design or satellite ground station design. This book also benefits researchers and engineers in the fields of phased array antennas, aerospace engineering, telecommunications, etc.

(more…)

The Development of a 2D Ultrasonic Array Inspection for Single Crystal Turbine Blades


Free Download The Development of a 2D Ultrasonic Array Inspection for Single Crystal Turbine Blades By Christopher Lane (auth.)
2014 | 133 Pages | ISBN: 3319025163 | PDF | 4 MB
This thesis describes the development of a new technique to solve an important industrial inspection requirement for a high-value jet-engine component. The work – and the story told in the thesis – stretches all the way from the fundamentals of wave propagation in anisotropic material and ultrasonic array imaging through to device production and site trials. The book includes a description of a new method to determine crystallographic orientation from 2D ultrasonic array data. Another new method is described that enables volumetric images of an anisotropic material to be generated from 2D ultrasonic array data, based on measured crystallographic orientation. After extensive modeling, a suitable 2D array and deployment fixtures were manufactured and tested on in situ turbine blades in real engines. The final site trial indicated an order of magnitude improvement over the best existing technique in the detectability of a certain type of root cracking. The Development of a 2D Ultrasonic Array Inspection for Single Crystal Turbine Blades should be an inspiration for those starting out on doctoral degrees as it shows the complete development cycle from basic science to industrial usage.

(more…)

The Square Kilometre Array A Science Mega-Project in the Making, 1990-2012


Free Download The Square Kilometre Array: A Science Mega-Project in the Making, 1990-2012 by Richard T. Schilizzi , Ronald D. Ekers , Peter E. Dewdney , Philip Crosby
English | PDF EPUB (True ) | 2024 | 645 Pages | ISBN : 3031513738 | 77.1 MB
The Square Kilometre Array (SKA) is a grand vision project to build the most sensitive radio telescope in the world. This book tells the story of its development – a story of transformational science, innovative engineering, and global collaboration. Its journey has been long and complex, reflecting the many issues faced in creating an affordable design, choosing a site, and developing a viable global organisation starting from a simple working group of far-sighted and persistent astronomers in 1993.

(more…)

Multibeam Phased Array Antennas as Satellite Constellation Ground Station


Free Download Multibeam Phased Array Antennas as Satellite Constellation Ground Station
English | 2024 | ISBN: 9819979099 | 188 Pages | PDF EPUB (True) | 30 MB
This book focuses on the multi-beam phased array antenna as a satellite ground station. As there are already many excellent books on phased array antennas in the literature, this book focuses mainly on some engineering practices and fills the gap between principles and practices, such as array excitation error impact analysis and calibration methods, array geometry design for hemispherical coverage, multiple beam resource management, etc. This book is particularly suitable for readers interested in satellite constellation design or satellite ground station design. This book also benefits researchers and engineers in the fields of phased array antennas, aerospace engineering, telecommunications, etc.

(more…)

Circular Array-Based Radio Frequency OAM Communications


Free Download Circular Array-Based Radio Frequency OAM Communications
English | 2024 | ISBN: 3031375882 | 443 Pages | PDF EPUB (True) | 52 MB
This book presents the modeling and transmission theory of RF OAM communications. The book features the UCA-based RF point-to-point OAM communication system, the UCA-based RF point-to-multipoint OAM wireless backhaul network, the HCCL structure for long-distance OAM transmissions, and the UCA-based joint OAM RadCom scheme. For the UCA-based RF point-to-point OAM communication system, a 2-D ESPRIT-based distance and AoA estimation method is first introduced, followed by an OAM reception scheme including the hybrid mechanical and electronic beam steering with the estimated AoA and the amplitude detection with the estimated distance. The proposed RF OAM communication scheme is extended to the RF OAM-MIMO system equipped with UCCAs. For the UCA-based RF point-to-multipoint OAM wireless backhaul network, an OAM-based multi-user distance and AoA estimation method is introduced, followed by a multi-user OAM preprocessing scheme. At last, the proposed methods are extended to the downlink multi-user OAM-MIMO wireless backhaul system equipped with UCCAs. Moreover, a novel HCCL structure is introduced to realize long-distance OAM transmission. For the UCA-based joint OAM RadCom scheme, an OAM-based 3-D super-resolution position estimation and rotation velocity detection method is introduced, and then the PCRB of the OAM-based estimates and the transmission rate of the integrated system are derived and analyzed. To achieve the best performance trade-off, the transmitted integrated OAM beams is optimized by means of an exhaustive search method. Finally, this book discusses future research directions to inspire further investigation in the field of RF OAM communications from different perspectives.

(more…)