Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Excel Marco error
- I have a Excel Marco and when I run, it show :Run-Time error "1004"Application-defined or object-defined error.When run debug:It show error at : ActiveCell.Offset(1, 0).SelectWhat does it mean?Here part of the code:counter = 0 Do While ActiveCell "Standard Deviations" ...
- Tags: ActiveCell.Offset, nt259, programming, Excel Marco, Microsoft Excel
- Discussion threads 2006-12-19
- Excel combo box
- I need urgent help in excel using vba. I was not satisfied with the data validation so i made my own. I made a combbox that is visible in a specific column only.Unfortunately, the user can double click the cell and type in values that are not in the combobox....
- Tags: Activate ElseIf KeyCode, ActiveCell.Offset, ActiveCell.Value, admin@..., cell, combo box, comboBox, ComboBox1.Visible, data validation, excel, Microsoft Excel, programming
- Discussion threads 2005-09-08
Additional Resources
- crate xl range name from a variable
- My macro copies a template worksheet, renames it with user prompted msgbox value with leading zeroes. The value "newname" becomes the sheet name as well as the contents of cell D3, E3 will contain a balance. I want to list the various D3's and E3's on Consolidated sheet so I...
- Tags: SELECT
- Q&A 2006-03-30
- Help with Class Modules
- HiClass modules have never been my strength and I hope this will help my understanding.Say I want to create a criteria for the activecell. ie say the a.cell.value must be -ve & also that left(a.cell.offset(1,0),2) must equal "ha" just simple textI want to create some thing like If a.cell.HasMyCriteria =...
- Tags: gideon.wiedmann@...
- Q&A 2006-07-12
- Save time in Excel with automated reports
- You can use Excel programming to automate a lot of your employees' monthly reporting. For example, if your employees submit a monthly travel expense report, you can develop an interactive application, such as the one that follows, that does a lot of the work for them. Follow these steps: ...
- Tags: ActiveCell.Value, InputBox, Microsoft Excel, Microsoft Office, Office Suites, Software, Mary Ann Richardson
- Blog posts 2007-10-23
- Blind Estimation of the Carrier Frequency Offset in OFDM Systems
- This paper presents a novel approach for carrier frequency offset estimation in OFDM systems. Before they enter the OFDM system, the information bearing symbols are segmented into blocks so that each even indexed block shares one common symbol with the previous block. This redundancy allows for the frequency offset estimation...
- Tags: Estimation, OFDM, Wireless
- White papers
- An Interpolation-Based Frequency-Synchronization Scheme for OFDM Systems
- The mismatch of the oscillators in the transmitter and receiver, or Doppler shift, introduces an offset in the expected carrier frequency. In orthogonal frequency-division multiplexing OFDM systems, this frequency offset causes large errors in the signal values and therefore it is important to minimize this offset. This paper proposes an...
- Tags: Helsinki University, Offset, OFDM, Wireless
- White papers 2005-04-28
- VBA DATE FORMAT VALIDATION
- I have a macro that has a number of application input boxes requesting a user to key data into specific fields in a workbook. There are about 6 that request dates and I want to validate the format of the date the user is inputting to stop them keying in...
- Tags: ActiveCell.FormulaR1C1, david_j_will@..., NUMBERDATE, NUMBERTEXT, Select NUMBERTEXT, software, VBA
- Q&A 2005-08-01
- Joint Time-Domain Tracking of Channel and Frequency Offset for OFDM Systems
- This paper addresses the problem of joint channel and frequency offset estimation and tracking for OFDM systems. The proposed method is based on Extended Kalman filtering. The channel taps and the frequency offset are estimated in time-domain while equalization is performed in frequency domain. Simulation results demonstrate accurate tracking capability...
- Tags: Frequency, Channel, Method, OFDM, Wireless
- White papers 2006-03-21
- writing FormulaR1C1 with $
- In VBA Excel how we can write the following formula =SUM($A$1:$A$10 programatically by using the FormulaR1C1 ?ex: ActiveCell.FormulaR1C1 = "=RC[-1]/R[1]C[-1]" ?
- Tags: talark81@...
- Discussion threads 2007-02-02
- Optimal Training Signals for MIMO OFDM Channel Estimation in the Presence of Frequency Offset and Phase Noise
- The authors develop robust Mean-Square Error MSE-optimal training signal designs for multiple-input multiple-output orthogonal frequency-division multiplexing channel estimation with frequency offset and Phase Noise PN, and present analytical and simulation results for the frequency-offset and PN effects on channel estimation. The proposed designs are more advantageous for moderate-to-high values of...
- Tags: Frequency, Training, MIMO-OFDM, Channel Estimation, OFDM, Workforce Management, Wireless, Human Resources
- White papers 2006-10-01
- Joint Compensation of OFDM Transmitter and Receiver IQ Imbalance in the Presence of Carrier Frequency Offset
- Zero-IF based OFDM transmitters and receivers are gaining a lot of interest because of their potential to enable low-cost, low-power and less bulky terminals. However these systems suffer from In-phase/Quadrature-phase IQ imbalances in the front-end analog processing which may have a huge impact on the performance. The paper also considers...
- Tags: Compensation, Imbalance, Carrier Frequency, OFDM, Wireless
- White papers 2006-02-03
- Use dynamic ranges to make your Excel spreadsheets easier to understand
- Mistake found... wrong reference for Order_DateOrder_Date should be =OFFSET(Sheet1!$A$1,0,0,COUNT(Sheet1!$A:$A),1)Not the stated=OFFSET(Sheet1!$A$1,1,0,COUNT(Sheet1!$A:$A),1).Must be a typo!Still getting a zero figure in the sum.I've made the change as specified by Edward, but it's still showing a zero value total.Any hints?----Ignore the last comment - helps if I enter into the right column -...
- Tags: Microsoft Excel, Microsoft Office, Edward C. Hsu, Excel spreadsheet, Sheet1!$A:$A
- Discussion threads 2007-04-04
- Estimation of Carrier-Frequency Offset and Frequency-Selective Channels in MIMO OFDM Systems Using a Common Training Signal
- This paper presents a common training signal design and corresponding estimation methods for carrier frequency offset and frequency-selective channels in MIMO OFDM systems. In designing the common training signal, a training signal structure which yields low complexity estimation methods is developed while the optimality of the training signal is maintained....
- Tags: Estimation, Training, MIMO-OFDM, Estimation Method, Workforce Management, Human Resources
- White papers 2004-09-13
- A Blind Frequency Offset Estimator for OFDM/OQAM Systems
- Like other OFDM-like systems, OFDM/OQAM systems are very sensitive to carrier frequency offset. A new blind carrier frequency estimator is introduced herein for OFDM- /OQAM systems by exploiting the non-circularity of the received signal. Since the received signal exhibits conjugate cyclic frequencies at twice the carrier frequency offset, a frequency...
- Tags: Frequency, Texas A&M University, OFDM, Wireless
- White papers
- PC Atomic Sync (exe)
- It is an atomic clock synchronizer with some useful features (time offset, synchronize periods). The unique Time Offset feature of the program allows setting up your PC clock to gain or to lose for a specified interval. This program uses the list of 19 presetting atomic time servers. Version 4...
- Tags: PC, Feature, Desktops, Hardware
- Software downloads 2007-10-10
- Experimental Studies on a OFDM Carrier Frequency Offset Estimator
- In OFDM carrier frequency offset must be estimated and compensated at the receiver to maintain orthogonality. OFDM carrier frequency synchronization performance can be improved by using diversity. This paper examines the sensitivity of the carrier frequency estimator against key system parameters in a practical implementation using real data obtained on...
- Tags: OFDM, Wireless
- White papers
- Limit on TCP connection attempts
- Source: TcpIpEvent ID: 4226Description:TCP/IP has reached the security limit imposed on the number of concurrent TCP connect attempts.(Tcpip.sys file size: 359,808 bytes)I have the Firewall set to 'don't allow exceptions' Maybe this setting has created that event ID. MS have limited the concurrent connections with XP SP2 (where the tcpip.sys...
- Tags: TCP/IP, NETWORKING, SECURITY
- Q&A 2006-02-02
- Can you have more than 3 conditional formats in Excel?
- Excel allows for only 3 conditional formats - that I can see. I have a client who wants to know if you can have more than 3 conditional formats to a worksheet. Anyone have any ideas?With VBA, conditional formats are unlimitedI have researched this issue at great length....
- Tags: Cell, conditional format, conditional formatting, CurrentCol, excel, Integer Dim CurrentCol, Integer Dim CurrentRow, kz2000@..., Microsoft Excel, programming
- Discussion threads 2005-11-21
- Hopping Pilots for Estimation of Frequency-Offset and Multiantenna Channels in MIMO-OFDM
- Orthogonal frequency-division multiplexing OFDM has been widely adopted by many standards (e.g., IEEE802.11a, IEEE802.11g in the U.S., and digital audio/video broadcasting (DAB/DVB), HiperLAN/2 in Europe), because it offers the possibility for high data rates at low decoding complexity. In this paper a pilot-symbol-assisted modulation for carrier frequency offset CFO and...
- Tags: MIMO-OFDM, OFDM, Wireless
- White papers 2005-01-01
- << Previous
- page 1 of 1
- Next >>
