Spreadsheet Enterprise

SODOO Spreadsheet is a powerful spreadsheet tool designed for analysing your business data. Excel or Google Sheets

What You Will Learn in This Section

Using the core features of SODOO Spreadsheet
Building dynamic reports with live data connections
Using formulas and functions effectively
Analysing data with pivot tables
Creating charts and visualisations

Overview

SODOO Spreadsheet is a powerful spreadsheet tool designed for analysing your business data. While offering an interface similar to Excel or Google Sheets, it lets you report in real time by connecting live to your SODOO database.

Live Data

Pull live data from your SODOO modules (Sales, Accounting, Inventory).

Powerful Formulas

Do complex calculations and analyses with 200+ functions.

Pivot Tables

Summarise and analyse your data along different dimensions.

Charts

Visualise with line, bar, pie and more chart types.

The User Interface

The Spreadsheet interface offers a familiar experience to those used to classic spreadsheet programs:

D6 =SUM(D2:D5)

Product

Category

Units

Amount

Unit Price

Laptop Pro

Electronics

375.000 ₺

=D2/C2

Monitor 27"

Electronics

160.000 ₺

=D3/C3

Office Chair

Furniture

100

250.000 ₺

=D4/C4

Desk

Furniture

175.000 ₺

=D5/C5

TOTAL

=SUM(C2:C5)

=SUM(D2:D5)

Data Sources

Spreadsheet can pull data directly from various SODOO modules:

Sales Orders

Invoices

Stock Moves

Customers

Products

CRM Opportunities

Adding Data

To add data to the spreadsheet, use the Insert SODOO Data option from the Data menu. In the window that opens:

Choose the data source (e.g. Sales Orders)
Define the filters (date range, state etc.)
Choose the fields to show
Set the sorting and grouping

Live Data Connection

Data pulled from SODOO is live-linked. Changes in the source data are reflected in the spreadsheet automatically. If you want to freeze the data at a given moment, use the "Snapshot" option.

Formulas and Functions

SODOO Spreadsheet offers a large function library compatible with Excel and Google Sheets:

Maths

SUM() Sum
AVERAGE() Average
MIN() / MAX()
ROUND() Rounding
ABS() Absolute value

Text

CONCATENATE() Join
LEFT() / RIGHT()
UPPER() / LOWER()
TRIM() Trim spaces
LEN() Length

Date

TODAY() Today
NOW() Now
YEAR() / MONTH()
DATEDIF() Difference
WORKDAY() Working day

Lookup

VLOOKUP() Vertical lookup
HLOOKUP() Horizontal lookup
INDEX() / MATCH()
XLOOKUP() Advanced

Logic

IF() Condition
AND() / OR()
IFS() Multiple conditions
SWITCH() Selection
IFERROR() Handle errors

Statistics

COUNT() / COUNTA()
COUNTIF() Conditional count
SUMIF() Conditional sum
STDEV() Standard deviation
PERCENTILE() Percentile

ODOO-Specific Functions

In addition to the standard spreadsheet functions, there are SODOO-specific functions:

=ODOO.LIST("sales_orders", "amount_total", "customer_id = 123")
=ODOO.PIVOT("sales_pivot", "January", "Total")
=ODOO.FILTER("products", "qty_available", "category = 'Electronics'")

Pivot Tables

Pivot tables are a powerful tool for summarising large data sets and analysing them from different angles.

Monthly Sales Summary - By Category

Category	January	February	March	Total
Electronics	145.000 ₺	162.500 ₺	178.200 ₺	485.700 ₺
Furniture	89.000 ₺	112.000 ₺	95.500 ₺	296.500 ₺
Stationery	23.500 ₺	28.700 ₺	31.200 ₺	83.400 ₺
TOTAL	257.500 ₺	303.200 ₺	304.900 ₺	865.600 ₺

Creating a Pivot Table

Rows: The grouping dimension (e.g. Category, Customer)
Columns: Time or a second dimension (e.g. Month, Region)
Values: The measure (e.g. Total Amount, Quantity)
Filters: Data restriction (e.g. Year = 2026)

Charts

You can use various chart types to present your data visually:

Line Chart

Ideal for time-series data and trends.

Bar Chart

The best option for category comparisons.

Pie Chart

Used to show ratios and share distributions.

Area Chart

Shows cumulative changes and stacking.

Chart Tip

Charts keep the live data connection. Changes in the source data are reflected in the charts automatically, so your reports are always current.

Keyboard Shortcuts

Frequently used keyboard shortcuts for working efficiently:

Copy CtrlC

Paste CtrlV

Undo CtrlZ

Redo CtrlY

Find CtrlF

Find and Replace CtrlH

Add a line CtrlShift+

Delete Row Ctrl-

Select All Cells CtrlA

Save CtrlS

Sharing and Collaboration

You can share your spreadsheets with team members and edit them together:

Sharing Options

View: Read-only permission
Edit: Full editing rights
Comment: Can add comments, cannot edit
Link: Public or restricted link sharing

Real-Time Collaboration

Several users can work on the same spreadsheet at the same time. Other users' cursors and changes appear instantly.

Attention

Be careful when sharing spreadsheets with a live data connection. The recipient can access all the data shown in the spreadsheet.