tobiadefami
2268667b74
further fixes
2025-05-13 18:53:17 +01:00
tobiadefami
1e58dfe88a
fix data selection tool
2025-05-12 20:31:00 +01:00
tobiadefami
0a6b446d69
refactor: extract LLM utilities and tool handlers to separate modules
2025-05-05 22:41:55 +01:00
tobiadefami
88491606c7
feat: implement two-phase LLM query for efficient spreadsheet data processing
...
Add data selection phase to identify relevant data before analysis
Create preprocessing utilities for extracting specific ranges/columns
Fix column reference preservation to ensure accurate cell targeting
Add fallback handling for timeouts and errors
Reduce API token usage by sending only necessary data
2025-05-05 17:17:08 +01:00
tobiadefami
1a0f008ba4
testing indexed db
2025-04-30 01:12:45 +01:00
tobiadefami
fa15f8ac8a
system message refactor
2025-04-16 12:12:25 +01:00
tobiadefami
a426d4bffd
clean up Readme
2025-04-12 07:33:55 +01:00
tobiadefami
d6e06d368d
refactoring
2025-04-11 15:52:58 +01:00
tobiadefami
7c49820d69
fix vision api call to enforce structured generation
2025-04-11 11:29:02 +01:00
tobiadefami
37a3716651
README refinements
2025-04-05 13:31:58 +01:00
tobiadefami
35efdca425
further refinements
2025-04-05 02:03:49 +01:00
tobiadefami
bc269882e3
further refinements
2025-04-04 17:56:33 +01:00
tobiadefami
fe71799ece
making progress
2025-04-04 11:22:24 +01:00
tobiadefami
c6e9437ef3
src/components/ChatBox.tsx
2025-04-04 11:21:27 +01:00
tobiadefami
28f35bbc36
feat: document parser
2025-04-01 08:17:36 +01:00
Oluwatobi Adefami
364a11bf28
Merge pull request #31 from PragmaticMachineLearning/multiple-sheets
...
update screenshot
2025-03-19 19:13:33 +01:00
tobiadefami
65148553a9
update screenshot
2025-03-19 19:12:41 +01:00
Oluwatobi Adefami
2ffb3d6912
Merge pull request #30 from PragmaticMachineLearning/multiple-sheets
...
Add new tools for adding and deleting sheets.
AI can now add sheets or delete sheets specified by the user.
2025-03-18 18:01:19 +01:00
tobiadefami
46c52a6c89
add new tools for adding and deleting sheets]
2025-03-18 17:59:56 +01:00
Oluwatobi Adefami
f5f4334a49
Merge pull request #29 from PragmaticMachineLearning/multiple-sheets
...
fix type error in config
2025-03-16 11:41:30 +01:00
tobiadefami
06f9513ba7
fix type error in config
2025-03-16 11:39:44 +01:00
Oluwatobi Adefami
a79e7869be
Merge pull request #28 from PragmaticMachineLearning/multiple-sheets
...
Multiple sheets
2025-03-16 11:13:03 +01:00
tobiadefami
b25033ad47
fix prompt library storage
2025-03-16 10:52:48 +01:00
tobiadefami
a4d16eff38
fix prompt library storage
2025-03-16 10:25:46 +01:00
tobiadefami
3498437956
fix sheet menu options
2025-03-16 05:40:18 +01:00
tobiadefami
ba5dce457a
Fix: sheet data persistence issue by ensuring changes are saved to the correct active sheet instead of always defaulting to Sheet 1. Update afterChange hooks to use current activeSheetId across all sheet operations.
2025-03-14 20:10:25 +01:00
tobiadefami
c33667680a
improve trackign for deleted sheets so that newly added sheets increment from the highest existing sheet number
2025-03-14 08:55:03 +01:00
tobiadefami
cb0be1c174
further fixes to spreadsheet data formatting
2025-03-13 17:18:54 +01:00
tobiadefami
ee38cfbb18
revert to xml tags to represent cell references
2025-03-13 16:58:27 +01:00
tobiadefami
6b17e73b2b
# fix: improve multiple sheet functionality with HyperFormula
...
- Fix sheet removal for default sheet (Sheet 1)
- Resolve data sync issues between sheets
- Enhance sheet switching with proper UI updates
- Add error handling for HyperFormula operations
- Fix React ref warnings with dynamic imports
2025-03-13 16:03:36 +01:00
tobiadefami
94b72cea9d
more context window optimizations and removing the mock analysis from the pyodide backend
2025-03-12 22:25:54 +01:00
tobiadefami
e3e61f2785
further preprocessing to remove:
...
- empty rows
- empty cols
2025-03-12 22:25:54 +01:00
tobiadefami
6e2b64862a
Implement smart spreadsheet context handling for large datasets
...
- Add contextWindowUtils.ts with intelligent data sampling and summarization
- Update formatSpreadsheetData to use context-aware representation
- Modify LLM API to handle large spreadsheets efficiently
- Improve context window utilization with metadata and representative samples
- Add detection for headers and data types
2025-03-12 22:25:54 +01:00
tobiadefami
76f3d250cf
fix prompt library shortcut
2025-03-12 21:35:11 +01:00
tobiadefami
ab6557258a
feat: Add multiple sheets support with bottom tabs
...
This commit adds support for multiple sheets in the spreadsheet application:
- Implemented tab-based UI at the bottom of the spreadsheet for sheet navigation
- Added functionality to create, rename, delete, and switch between sheets
- Integrated with HyperFormula for cross-sheet formula calculations
- Updated API to provide context about active sheet and available sheets
- Enhanced SpreadsheetContext with sheet management capabilities
- Fixed type compatibility issues with OpenAI API
- Added support for importing/exporting workbooks with multiple sheets
The UI now resembles traditional spreadsheet applications with tabs at the bottom,
and users can work with multiple related datasets in separate sheets while
maintaining the AI assistant's ability to analyze the active sheet.
2025-03-12 17:39:34 +01:00
Oluwatobi Adefami
1de17e0842
Update README.md
2025-03-12 01:12:09 +01:00
tobiadefami
a0ef732fe2
add discord server link to the top of the page.
2025-03-10 21:11:04 +01:00
tobiadefami
f2764af530
update readme to include discord server
2025-03-10 16:48:39 +01:00
Oluwatobi Adefami
5d9eac76c2
Merge pull request #22 from PragmaticMachineLearning/optimize/dataformatter
...
pre-compute column refs before using them to obtain cell ref and factor the empty cell checker logic into a utility function
2025-03-06 10:32:47 +01:00
Oluwatobi Adefami
21d690d5d3
Merge branch 'main' into optimize/dataformatter
2025-03-06 10:31:07 +01:00
tobiadefami
7af521ecd4
precompute columnrefs before using them to obtain cell refrences
2025-03-06 10:11:41 +01:00
Oluwatobi Adefami
9b3dc858cf
Merge pull request #21 from xiaolongtang/fix/empty-cell-to-llm
...
fix/remove empty rows and columns in the data for LLM
2025-03-06 09:08:52 +01:00
xiaolongtang
bfd7f4b545
fix/remove empty rows and columns
2025-03-05 12:02:38 +08:00
Oluwatobi Adefami
e63133771b
Merge pull request #20 from PragmaticMachineLearning/prompt-library
...
make saved prompts editable
2025-03-01 20:32:38 +01:00
tobiadefami
04e67a5b8a
make save prompts editable
2025-03-01 20:30:12 +01:00
Oluwatobi Adefami
ee5b54ed49
Merge pull request #19 from PragmaticMachineLearning/prompt-library
...
Prompt library
2025-03-01 20:16:38 +01:00
tobiadefami
42f8c9e918
update readme to reflect the addition of prompt library
2025-03-01 20:15:54 +01:00
tobiadefami
00c3c4e85c
Added a handy prompt library so users can quickly access common prompts or save their own favorites. Open it with Ctrl+Shift+L or click the new book icon next to the chat button
2025-03-01 20:12:35 +01:00
Oluwatobi Adefami
692db61d5e
Merge pull request #18 from PragmaticMachineLearning/docker-deployment
...
Add package-lock.json for consistent builds
2025-03-01 09:17:36 +01:00
tobiadefami
d6b12ce7d1
Add package-lock.json for consistent builds
2025-03-01 09:17:01 +01:00
