Skip to content
Linear Interpolation in Excel

Quick answer: To estimate a value between two known points in Excel, use =B3+(E2-A3)*(B4-B3)/(A4-A3) when the lower and upper x-values are in A3 and A4, their y-values are in B3 and B4, and the target x is in E2. For a reusable function over many sorted data points, the VBA example below calculates the interval automatically. The data in this tutorial are illustrative, not measured water-density values. Suppose an illustrative… Read More »Linear Interpolation in Excel: Formula, Example and VBA

Linear Interpolation in Excel: Formula, Example and VBA

How to Bulk convert Word document to PDF file

Quick answer: To batch-convert Word documents to PDF on Windows, you can use desktop Microsoft Word with a Windows Script Host (JScript) file and a batch file. This method requires Word installed locally; it does not run in Word for the web or on macOS. The safer example below skips PDFs that already exist, opens source documents read-only, and closes Word after each file. Before you begin Use this only… Read More »Bulk Convert Word Documents to PDF on Windows (Batch Script)

Bulk Convert Word Documents to PDF on Windows (Batch Script)

HackerRank Hackfest 2020 solutions (archived contest): This article preserves four programming challenges from the 2020 event: Cyclic Binary String, Game of Maximization, Strictly Increasing Sequence, and RBG Queries. The event is historical, not an upcoming competition. Each section includes the problem idea and Java solution; review the original challenge for exact input/output requirements. Java note: The code snippets are method implementations for HackerRank-style Result classes, not standalone programs with a… Read More »HackerRank Hackfest-2020

HackerRank Hackfest-2020

  • by
Speed up Python by up to Million time

Can Numba or Cython speed up Python? Yes—especially CPU-bound numerical loops—but the gain depends on the workload, data types, compilation cost and baseline. Neither library guarantees a million-fold speedup. This guide explains when to choose each, how to run a reproducible comparison, and why an earlier microbenchmark on this page was misleading. Numba vs Cython: what each tool does Numba uses just-in-time compilation to optimize supported Python and NumPy numerical… Read More »Speed Up Python with Numba and Cython: Realistic Benchmarks

Speed Up Python with Numba and Cython: Realistic Benchmarks