Addresses the issue in OS X 10.12 Sierra that breaks the quick PDF functionality.
Addresses an error that occurs when adding rows to the logs in OS X 10.12 Sierra.
HOT BUDGET 1.5.4 UPDATE February 2 2016
Incorporates a format repair for missing conditional formats in the logs that causes the display of zzzz and 0.00 values
Other Minor updates
HOT BUDGET 1.5.3 UPDATE January 25 2016
El Capitan compatibility confirmed
Addresses an issue where an error could occur when generating a PDF of the budget after printing
Addresses a situation where the bid could become locked when transferring the document from a computer without a license to one with a license
Addresses an issue in the digital purchase order system when saving digital purchase orders as files the excel docs would be saved as an inconsistent file type
Importing timecard batch .csv files into the payroll log now adds the dates to the PO column
HOT BUDGET 1.5.2 UPDATE January 15 2016
Restores functionality to the shooting details popup
Addresses a behavior where some cells in the workbook would appear to become selected when switching between workbooks
The cells in the payee column of the PO log have been changed to not Wrap text
The first 4 columns to the right of the Bid/Actual columns are now unlocked buy default
A popup message was added at launch to display incompatibility with office 2016
Added a calculation option for markup and insurance to the overtime calculator
HOT BUDGET 1.5.1 UPDATE December 6 2015
Corrects a labeling issue causing the wrong expiration date to be displayed on the HotBudget sheet.
The day rate on line 51 now starts off equal to the rate on line 1
HOT BUDGET 1.5.0 UPDATE December 3 2015
******The default way that markup calculates has changed in the shooting budget and actual. Setting the budget to calculate markup as a percentage now also calculates the shooting budget as a percentage based on the data in the shooting budget and the same is true for the actual.
Corrects a calculation error that occurs when using advanced insurance and markup and talent agency fee in section M
A new overtime calculator has been added which can be accessed through the HotBudget Menu
FEATURES OF THE NEW OVERTIME CALCULATOR
– The OT Calculator Sheet can be made visible through the HotBudget Menu
– Consolidates labor sections ( | B | G | M | ) onto one sheet
– Can be printed as a two page report
– Can be reset to match either the original bid data or the shooting budget data as a starting point
– Can be exported and saved as a separate excel file for archiving purposes
– Can toggle an Indicator that Indicates days in either the bid or shooting budget
Digital PO System – The height (and therefore the size) of the company logo can now be adjusted in settings
The Lock Bid Checkbox on the HB Sheet now effects the Notes Section on the Cost Summary Page
The Travel Budget sheet can now be hidden or made visible through the HotBudget menu
Columns in sections ( | C | D | E | F | H | I | J | K | L | M2 | N | O | P | ) labeled “AMOUNT” have been relabeled “DAYS” for better continuity across the budget
The overtime calculator incorporated into the shooting budget has been removed
A new chart of account service has been added
FEATURES OF THE CHART OF ACCOUNTS SERVICE
– Create and manage an internal chart of accounts using the chart of accounts log accessible through the HotBudget menu
– Map internal accounts to line items within the budget using the account picker accessible through the HotBudget Menu
– Establish separate internal accounts for PW (Fringe) costs
– Export reports organizing expenses by the internal accounts mapped to the budgets lines
Changing the markup and insurance calculation to force enter will automatically carry over the bid values in the shooting and actual budgets. It will also unlock the insurance and markup cells in the shooting and actual budgets so values can be forced in without unlocking the sheets.
Checkboxes for applying markup and insurance input into the overage log to markup and insurance in the budget have been removed. Markup and insurance in the overage log will be applied to markup and insurance in the budget as entered.
Access to the advanced markup and insurance control for PW have been moved from the Insurance and Markup to the top of the Cost Summary page.
The columns in each section of the budget have been reorganized for continuity and simplicity
In the bid the OT Total column is now grouped with the bid details
The password lock feature for viewing the insurance and markup has been removed.
In the printing program you can now reverse the page order of the budget so that the pages would print in the appropriate order if the printer prints face up or face down
Dramatically improved performance when importing into the Payroll Log, Petty Cash Log, and Purchase Order Log from any other HB file or a batch timecard .csv
Envelopes in the PC log can not only be deleted one at a time and they are deleted with out popup messages
Adding and removing rows in the Payroll Log, Petty Cash Log, and Purchase Order Log has been reprogrammed resulting in a dramatic performance increase
Removing rows in the Payroll Log, Petty Cash Log, and Purchase Order Log will now clear rows once the log reaches the minimum number of rows rather then forcing a selection quantity of rows that does not violate the minimum quantity of rows.
DIGITAL PURCHASE ORDERS – corrected an error when emailing and exporting purchase orders that can occur when the name of a vendor is greater then 31 characters and when there is a slash character in the name of the vendor
HOT BUDGET 1.4.4 UPDATE January 2 2015
Fixes a bug that caused the left footer to be cleared when printing the budget.
HOT BUDGET 1.4.3 UPDATE DECEMBER 19 2014
New Feature – Connecting the Travel Budget Costs to lines 17, 18, or 19 on the cost summary page can now be done through the HotBudget>Travel menu
New Feature – Bid Assistant now no has the ability to set the OT Base across the whole budget
Compatibility with OSX Yosemite confirmed
The left footer on the Cost Summary Page and pages 1A to 6 has been removed and can now be customized in the same way a standard excel sheets footer can be customized.
PO System – Fixes an issue where the name of a vendor having more then 31 characters causes an error when exporting to excel and PDF files.
PO System – Buttons on the PO Log that are visible when using the digital purchase order system are not longer selectable while the sheet is locked.
PO System – Extends the beta through 2015
Cells with numerical values have been reformatted in response to an excel update that removes the (#,###.##) style of formatting for negative values
Lines 17, 18, and 19 on the Cost Summary page are no longer directly editable but must be populated by entering values into the logs using line codes CS17, CS18, and CS19
The reconciliation warning in the status bar now properly factors in cost summary lines 17, 18, and 19 in its display
Fixes an error that can occur when trying to view actual details when the PR log contains a row that has a rate but no days
Other Minor improvements and fixes
HOT BUDGET 1.4.1 UPDATE JANUARY 15 2014
Addresses an issue where the file may freeze of lag when opened.
HOT BUDGET 1.4.0 UPDATE December 17 2013
New Feature – Integrated a travel log where costs can be connected to a chosen line item within the bid through the HotBudget menu.
New Feature – Integrated BETA Digital PO System (MAC Only)
New Feature – Insurance and markup can be applied to P&W separate from the section where P&W exists. (Sections A, B, G, L, M, O)
New Feature – Import feature in the payroll log can import timecard batch .csv files
New Feature – Bid Assistant for setting the Insurance, Markup, and P&W percentages for all sections of the bid
Added formal License Agreement
Actual costs for lines 17, 18, and 19, on the Cost Summary sheet can now be represented in the PO Log, PC Log, and PR Log by default using line code CS17, CS18, and CS19 appropriately
In the check log and credit card log a line item of PR now displays a description of Payroll
Fixed an error that causes an image file that was added to the cost summary page with the Import Image button to be lost when the HotBudget file is emailed.
Fixed a sheet protection error that would occur when the HotBudget sheet was not the first sheet in the file
The payroll log can now accept negative values
The petty cash log can not accept negative values
Rows are no longer sorted when adding rows in the Logs
Newly redesigned migrate feature for the logs is now called import and can merge external logs with already existing information or replace the existing information.
Migrating and importing data from another HotBudget is no longer sensitive to the names of the sheets in the source file
The printing functionality now sets the page breaks properly when printing using excel 2010 for PC on windows 7 OS
Other minor improvements and fixes
HOT BUDGET 1.3.0 UPDATE - December 10 2012
New Feature – You can how hide the values in the rates columns of each section when there is no value in the amount column
(This can be toggled on and off using the HotBudget menu)
Improvement – The buttons that toggle the Bid Details view, Hourly And OT view, and Shooting details view have been reprogramed and are more responsive.
Expiration Date Extended through December 2013
Fixed and error that can occur when setting a custom password.
Rewrote and expanded the migrate feature. Now includes the logs and has more flexibility with sections of the the bid and shooting budgets.
Other minor improvements
HOT BUDGET 1.2.0 UPDATE - August 26 2012
Companies can now create their own Password to prevent unwanted unlocking of the sheets
Budget data can now be exported as aTab Delimited plain text file
Overtime in the Bid and Shooting Budget can now be calculated without needing to have a value in the days column.
When deleting a row in the payroll log the “Row Has Content” warning now displays only if the row has some important content.
When adding or deleting rows or envelopes to the logs they will be automatically formatted with the proper font, font size, and borders
The overtime rates in the payroll log can now be adjusted by changing the value at the top of each overtime column
The Day Rate in page 1B is now automatically populates from what is entered in page 1A
A new Shooting Details feature has been implememted (Similar to the Actual Details)
Fixed an issue in the PC log where having 25 envelopes could result in incorrect formulas in the actual column
Other minor improvements
HOT BUDGET 1.1.0 UPDATE - March 11 2012
Automated printing of the shooting budget and the shooting budget is now included in the Generate PDF list
Cells in the PO Log, Payroll Log, CC Log, PC Log, and Check Log that get accidentally locked from a copy and paste can now be easily unlocked by simply adding or deleting rows or envelopes.
When entering overtime there is a prompt if there is no OT Base entered.
The order the Bid and actual print has been reversed so that they some out in the proper order.
The sheets can now be unprotected without needing a password using the lock and unlock buttons on the HotBudget Sheet
The PO Log, Payroll Log, CC Log, and Check Log now have a minimum number of 10 rows
The Purchase Order Log and the Payroll Log can now be reconciled using the PR abbreviation in the line column of the PO log
Overtime in the Payroll log can now be calculated without needing to have a value in the days column.
The Payroll log has been restructured to make it easier to copy and paste and to do a selected sum of the Actual and PW Total columns
Fixed a compile error and improved the functionality of the Calculate Day Rate function in the HotBudget drop down menu.
Other Misc. Improvements
HOT BUDGET 1.0.2 UPDATE - January 22 2012
New migrate feature has been added
Fixes an error that could occur in the PC log when adding an envelope to the log.
HOT BUDGET 1.0.1 UPDATE - December 21 2011
Fixes an issue in which having a startup disk named something other then the default Macintosh HD name would cause a runtime error when trying to generate a PDF
Fixed an issue in which having certain characters in the job name would cause a runtime error when trying to generate a PDF
Fixed an issue in the petty cash log where adding an envelope could cause values that where placed in the money received cells to be aligned with incorrect envelopes.