Reference Footing

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 4

Instructions for Exporting QuickBooks data

Where did my worksheet go?


When you export data to a new workbook, your new worksheet containing exported data goes to Sheet 1. When yo
the new worksheet is placed in front of the last active sheet where it will be named "SheetX" using the next availab

How do I make sure this tips sheet isn't exported with the QuickBooks report in the final workbook?
Before exporting, on the Export Report Basic tab, deselect the option to include the instruction worksheet.

How can I customize and update my worksheet?


You can set up Excel links between 2 or more worksheets. (See Microsoft Excel Help for details about linking in Exc
feature to setup links between a QuickBooks summary report and your customized sheet.
>> Choose one sheet as your source worksheet into which you'll export QuickBooks data. Then create ano
customize your data and link the data between that sheet and the source worksheet.
>> Export your source data to an existing worksheet and overwrite the current data so that the new data
>> Create Excel links between a QuickBooks data worksheet and another worksheet in the workbook.

Troubleshooting: Why don't my links work correctly after exporting data?


Be aware that any difference in the structure of the current report from the report that you used when setting up li
in the links between worksheets. If you are seeing wrong data in your customized worksheet, then you may have:
>> Moved or deleted elements, or changed the structure of the report in some way? For example:
You might have moved or deleted items from item list which gets used in a report like Invento
You might have moved or deleted accounts from accounts list which gets used in a report like
>> You are using a report related to accounts and have account(s) with no activity associated and did not
TIP: Choose display All rows (available for most of the reports), Select Modify report->Display-
>> Deleted exported data sheet which serves as data source.
data goes to Sheet 1. When you export to an existing workbook,
SheetX" using the next available number in the series.

nstruction worksheet.

for details about linking in Excel.) You can use this

ckBooks data. Then create another worksheet where you can

ent data so that the new data is used by any Excel links and formulas.
orksheet in the workbook.

at you used when setting up links, can cause mismatch


rksheet, then you may have:
me way? For example:
ts used in a report like Inventory Valuation report.
which gets used in a report like Profit and Loss standard report.
activity associated and did not choose to display "All rows".
Select Modify report->Display->Advanced->Display Rows->All rows
Story Point Load FX FY FZ
BASE 1 ULENVE M 7647.51 9491.24 108063.5 108.0635
BASE 2 ULENVE M 8545.91 5002.53 93493.12 93.49312
BASE 4 ULENVE M 11535.51 -562.29 169120.3 169.1203
BASE 9 ULENVE M 6210.55 3937.64 78465.42 78.46542
BASE 12 ULENVE M 3522.56 10569.06 105071.2 105.0712
BASE 13 ULENVE M 2189.37 6981.98 86695.29 86.69529 D
BASE 14 ULENVE M 5312.92 3429.48 68111.91 68.11191 A
BASE 15 ULENVE M 9477.92 8142.33 83295.25 83.29525 P/gamma
BASE 16 ULENVE M 9618.77 8355.6 131203.9 131.2039 7.289103
BASE 17 ULENVE M 7917.32 5176.27 96539.02 96.53902
BASE 18 ULENVE M -238.15 -388.3 98997.24 98.99724
BASE 19 ULENVE M -12.38 3106.59 108937.4 108.9374
BASE 22 ULENVE M 1598.73 4596.36 83010.86 83.01086
BASE 23 ULENVE M 8270.96 2895.07 112894.8 112.8948
BASE 26 ULENVE M 5577.08 4928.69 79954.83 79.95483
BASE 28 ULENVE M -1634.97 7842.48 99044.99 99.04499
BASE 41 ULENVE M 5860.79 9153.43 117659.7 117.6597
BASE 51 ULENVE M 3445 7443.05 94083.03 94.08303
BASE 52 ULENVE M 6631.65 1558.68 79924.16 79.92416
Depth of Foundation
B C D E F G
Angle Rad 1-sin(Rad) 1+sin(Rad) (D/E)^2 A*F
30 0.523599 0.5 1.5 0.111111 0.8099

You might also like