101 Commits

Author SHA1 Message Date
Oluwatobi Adefami
e5f0b98d0d Merge pull request #32 from PragmaticMachineLearning/feature/document-parser
Feature/document parser
v0.3.0
2025-04-12 13:18:06 +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
v0.2.0
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
Oluwatobi Adefami
6f7d8dfbd2 Merge pull request #16 from PragmaticMachineLearning/docker-deployment
feat: Add Docker support and improve browser compatibility
2025-02-28 12:32:10 +01:00
tobiadefami
f0735525c1 feat: Add Docker support and improve browser compatibility
This commit adds Docker support for easy deployment and improves browser compatibility:

- Add Dockerfile and docker-compose.yml for containerized deployment
- Fix Pyodide integration to work properly in browser-only mode
- Add mock implementation for server-side rendering
- Clean up markdown formatting in analysis output
- Update README with Docker deployment instructions
- Add platform-specific keyboard shortcuts (Mac/Windows)
- Ensure public directory exists in Docker build
- Fix TypeScript type definitions for Pyodide

The application now properly handles the browser/server environment difference,
with Python analysis running exclusively in the browser while the server
provides API proxying and static file serving.
2025-02-28 12:30:29 +01:00
Oluwatobi Adefami
59016302fe Merge pull request #15 from PragmaticMachineLearning/docs
update docs
2025-02-27 15:29:01 +01:00
tobiadefami
4eedd3f537 update docs 2025-02-27 15:25:43 +01:00
Oluwatobi Adefami
646e94a086 Merge pull request #14 from PragmaticMachineLearning/docs
Docs
2025-02-27 15:02:39 +01:00