I have been tasked with a new project to create a grid that will work/look similar to an excel spreadsheet. I just wanted to ask if anyone has done something similar with the KoolGrid ( I think it is the best choice of out the KoolSuitephp) any advice or suggestions before I start trying to create this? here's the basic outline I am going with. The outlined cells will all be editable (I assume I can make this happen without having to click an edit button per record), and have it update a mysql table.
Please lend any advice if you have any!

If you want to put the whole grid in edit mode, then here is some javascript to handle on the client side.

/**
 * Put the Business Hours Grid in edit mode.
 */
function Handle_EditAllCustomerBusinessHours()
{
    var BusHrsGrid = CustomerBusinessHoursGrid.getMasterTable();
    var GridRows   = BusHrsGrid.getRows();
    for( var idx=0; idx < GridRows.length; idx++ )
    {
        GridRows[idx].startEdit(); // put row in edit mode
    }
    CustomerBusinessHoursGrid.attachData("EditModeIsOn","1");
    CustomerBusinessHoursGrid.commit();
}
/**
 * Save the Business Hours Grid Data.
 */
function Handle_SaveAllCustomerBusinessHours()
{
    var BusHrsGrid = CustomerBusinessHoursGrid.getMasterTable();
    var GridRows   = BusHrsGrid.getRows();
    for( var idx=0; idx < GridRows.length; idx++ )
    {
        GridRows[idx].confirmEdit();  // confirm row will post data back
    }
    CustomerBusinessHoursGrid.commit();
}

Anthony,
Thank you for the reply, I will try and use your advice to make this work. Thank you again. I am still learning.

Cool. Enjoy :)
In my grid, I fire the javascript event on the grid row click event.

    function InitializeGrid()
    {           
        $custMgrPermission = $this->UserData_SessionData->GetModulePermission(CustomerModuleId::CustomerManager);
        
        // create the grid
        $this->KoolGrid = new KoolGrid($this->gridName)      ;
        $this->KoolGrid->scriptFolder    = $this->koolGridScriptFolder  ;
	$this->KoolGrid->styleFolder     = $this->koolGridStyleFolder   ;
        $this->KoolGrid->DataSource      = $this->MySQLiDataSource      ;
        $this->KoolGrid->Width           = $this->GridWidth             ;
        
        $this->KoolGrid->AllowHovering   = true ;
        $this->KoolGrid->ColumnWrap      = true ;
        $this->KoolGrid->ShowFooter      = false;
        $this->KoolGrid->AllowFiltering  = false;
        $this->KoolGrid->RowAlternative  = true ;
        $this->KoolGrid->AllowSelecting  = true ;
        $this->KoolGrid->AllowScrolling  = true ;
        $this->KoolGrid->AllowResizing   = true ;
        
        $this->KoolGrid->AllowDeleting   = false;
        if( ModuleAccess::IsAdmin($custMgrPermission) || ModuleAccess::IsReadWrite( $custMgrPermission ) )
        {   
            $this->KoolGrid->AllowInserting  = true ;
            $this->KoolGrid->AllowEditing    = true ;
            
            if( !isset($_POST['EditModeIsOn']) )
            {
                $this->KoolGrid->ClientSettings->ClientEvents["OnRowClick"] = "Handle_EditAllCustomerBusinessHours"; // fires the javascript function to put all rows in edit mode
                
            }
            $refreshButton = '<label title="Also will cancel edit mode">Reload</label>';
            $this->KoolGrid->MasterTable->FunctionPanel->RefreshButtonText= $refreshButton ;
        }
        
        $this->KoolGrid->AjaxEnabled     = true                     ;
        $this->KoolGrid->AjaxHandlePage  = $this->GridAjaxHandle    ;
        $this->KoolGrid->AjaxLoadingImage= $this->GridAjaxLoadImage ;
        
        $this->KoolGrid->MasterTable->ShowFunctionPanel               = false     ;
        $this->KoolGrid->MasterTable->FunctionPanel->ShowInsertButton = false     ;
    }

Hi Anthony,
This project is getting very difficult for me, I just want your opinion if this is actually possible through PHP (maybe it's my frustrations getting the best of me!). Right now I SUM the cases and create the MONTH column for the headers. I want to be able to update a table based on individual column defaults (1/15/2017, 2/15/2017 etc) item, and customer. However I can't wrap my head around this.
Do you have any experience with something like this?? all I want is the months to read across (with their data editable), and update to a mysql table.
Any advice is really appreciated!

Yes I have experience with this.
Consider how you update a single row. This same process happens in a loop. Set your mysql update command to update one row.
In the javascript methods I posted, one function puts all the rows in edit mode, and then I make visible two buttons. A back (cancel), and Save button.
I then input my data that I want into my fields, then click the save button, with executes the Handle_SaveAllCustomerBusinessHours().
This function tells each row to confirm an edit event at the server when you commit the grid. Each update will execute one at a time at the server side, then the grid will refresh.
It seems after you commit the update, you should put all of the rows back in edit mode so it behaves similarly to excel, but managed like a database.