What This Actually Is
A Workbook For Feng Shui Quick is a spreadsheet-based framework for organizing the bagua map, room measurements, and element placement across multiple spaces in a building. It sounds like overkill for something rooted in traditional Chinese geomancy, but once you've measured a thirty-room office building by hand and realized you kept mixing up the southern fire sector with the southwest earth sector, you start appreciating structured data more than intuition. The core idea is simple enough on paper. You input floor plan dimensions, the software or template maps the eight sectors onto each space, and you get a color-coded overlay that shows which life area corresponds to which physical corner. The template handles the math so you don't have to divide wall lengths by hand and then double-check your work against a printed grid sheet from 1998.
Workbook For Feng Shui Quick
The quick version strips away the annual flying stars, personal kua number calculations, and the more obscure classical methods that require solving time-based formulas by hand. It focuses on the static bagua overlay, which is where most residential clients actually need help. The dynamic sectors change every year and every month. The static ones don't move at all. That distinction matters because it determines whether your workbook stays valid for a decade or needs rebuilding in March. I built my first working version of this in Google Sheets back in 2014 because I was juggling four renovation projects and constantly misplacing the water element treatment in a kitchen that sat in the northern sector of a narrow townhouse. The problem wasn't understanding the theory. It was tracking which treatment I'd recommended for which sector across multiple floor plans while the client changed their mind three times about the paint colors. The workaround that actually solved it was creating a master sheet with a unique property ID on every row, a separate tab for each space, and a conditional formatting rule that flagged any sector without a recorded element treatment. I set it to turn the cell orange if the field was blank and red if the element was water placed in a fire zone. That color coding cut my revision time per project from roughly forty minutes down to maybe eight. I still do the verification by hand because spreadsheets don't catch errors in your original measurements, but the system catches its own gaps reasonably well.
How to Build One From Scratch
Open a blank spreadsheet. The first tab is your data entry sheet. Create columns for Property ID, Room Name, Wall Length North, Wall Length East, Wall Length South, Wall Length West, Door Location, Window Count, and Notes. That's all you need to start mapping. Don't add more fields until you've used it for three properties and noticed what you're actually writing down versus what you never touch. The second tab is your calculation engine. You'll use a simple division formula to split each wall length into three equal segments. Take the north wall measurement, divide by three, and place vertical and horizontal grid lines across the floor plan rectangle. The nine cells created by those intersecting lines represent the nine bagua sectors. The center cell is the heart sector, which in practice most people ignore unless they're doing a full elemental balance review. The other eight cells map directly to life areas. The third tab is your result output. Pull the sector assignments from the calculation tab using INDEX and MATCH or XLOOKUP if your spreadsheet software supports it. This is where the conditional formatting rule comes in, flagging conflicts and empty treatments. Some people use a separate tab for each room. That works fine for small projects but becomes unmanageable past about six spaces. A single consolidated tab with a filter dropdown for Room Name is cleaner and easier to audit.
Get the Full Details
There's a common mistake people make at this stage. They overlay the bagua grid aligned to the front door instead of magnetic north. The door orientation matters for the placement of cures and treatments, but the sector grid itself is always tied to cardinal directions. If you align the map to the door, every reading downstream gets shifted by however many degrees the entrance faces off north. I saw this happen on a project in 2019 where the client had a contractor map the entire second floor using the front door as a reference point. We caught it after the treatment materials were already purchased and the installation schedule was locked in. It cost us about six hours of rework and a refund on the misplaced bamboo wind chimes ordered for the wrong sector.
Where This Method Falls Apart
The static bagua approach assumes a rectangular floor plan. If your building has a missing corner, an L-shape, or a bay window that throws the geometry off, the standard grid doesn't apply cleanly. You have to subdivide the irregular shape into rectangles, map each one separately, and then reconcile the overlapping sectors. This is where most workbook templates break down because they don't account for compound geometries. I handle it by drawing each rectangular sub-area in a separate row with a priority ranking, then merging the results in the output tab by taking the highest priority sector assignment when two rectangles claim the same physical corner. Another limitation is that the workbook gives you sector assignments, not recommendations. It can tell you that the southeast corner of a living room maps to the wealth sector, but it cannot tell you whether that sector is blocked by a load-bearing column, covered in clutter, or occupied by a bathroom drain pipe. Those are spatial observations that require a physical walkthrough or at minimum a detailed floor plan drawn to scale. The template is a mapping tool, not an audit tool. If your practice involves a lot of multi-unit buildings or properties with irregular layouts, you might be better off using a dedicated bagua mapping application that supports freeform polygon segmentation. The spreadsheet approach is fast and cheap for standard rectangular rooms. It gets tedious and error-prone the moment your floor plans stop looking like basic boxes. I switched one client's portfolio over to a vector-based mapping program after I spent three weeks reconciling L-shaped units across twelve properties. The program does the subdivision automatically and exports a PDF overlay that the installers can print and take on site.
Practical Numbers
Setting up a new workbook from scratch takes about forty-five minutes the first time. After that, a standard single-family home with four to six rooms maps in roughly twelve minutes. A multi-room commercial property with irregular geometry runs closer to twenty-five to thirty minutes depending on how cleanly the floor plan divides into rectangles. The time savings show up most clearly during revisions. When a client changes a room's function or moves a bed, you update the room tab and the rest of the sheet recalculates without manual re-entry. If you're working with paper grids and a protractor, the same single-home project takes about two hours minimum, not including the error correction phase when you catch a misaligned sector and have to redraw everything. That gap is why this workflow persists in professional practice despite being tedious to build initially.
What to Watch For
The most frequent failure point is inconsistent measurement methodology. Some people measure from the inside face of walls, some from the centerline, and some from the outside face. Pick one and stick with it. The difference matters when you're dividing wall lengths into thirds because a half-inch discrepancy on a twenty-foot wall shifts your grid lines by about an inch across the entire floor plan. That inch compounds when you're layering treatments onto a physical space that's already been measured on site. Another issue is date tracking. If you note the measurement date on the first tab and forget to update it when you return for a second visit, your audit trail becomes unreliable. I add an auto-populated last-modified timestamp column using a simple formula that checks whether any cell in that row has been edited. It's not foolproof, but it's better than relying on memory. The workbook template handles the static bagua well. It does not integrate with period-based fly ing star calculations unless you build that layer in separately, and that integration is nontrivial because the stars rotate annually and monthly on a fixed calendar cycle. If your practice requires both static and dynamic mapping, you'll need two connected sheets or a custom script that pulls the current period numbers and overlays them on the same grid. I use a separate calendar tab for the dynamic layer and cross-reference it manually rather than trying to automate the merge. The automation introduces more bugs than it saves in time.
Getting Started
Search for a free bagua workbook template online if you don't want to build one from scratch. There are several community-shared versions in Google Sheets and Excel formats. Download one, strip out any formulas you don't understand, and rebuild the logic yourself so you know where each calculation comes from. Copying a template without understanding the division method means you'll hit a case it wasn't designed for and won't know how to adjust it. My own file lives in a shared drive folder labeled FS_Workbooks with a version number appended to the filename. I keep a changelog tab at the front that records what formula or structure changed in each revision. After four years of updates, that changelog is worth more than the template itself because it shows which workarounds survived and which ones introduced new bugs. The tool is only as useful as the data you put into it. Garbage measurements produce garbage sector maps regardless of how clean the spreadsheet looks. Verify your wall lengths against a floor plan drawn to scale before you trust the output, and do a physical walkthrough to confirm that no structural feature contradicts the calculated assignments. The spreadsheet will tell you where the wealth sector sits. It won't tell you whether there's a radiator running through that exact corner that neutralizes whatever treatment you planned to install there.
