Spreadsheet: 72530d1273219197-formula-for-reading-data-out-of-several-files-check-file-with-balance-sheet-only
Sheet: Balance Sheet

 |  |  |  | 24 |  |  | 075 | [BPL10075_ADD.XLS] |  |  |  | ('M:\DFPAAR\Plan2010\ADD\06 - Post Exec\06 - Balance Sheet\A02\)&("$I$2")&("Local currency'!H121")
 |  |  |  |  |  |  |  |  |  |  |  | 'M:\DFPAAR\Plan2010\ADD\06 - Post Exec\06 - Balance Sheet\A02\[BPL10075_ADD.XLS]Local currency'!H121
Country File |  | Prior Year M12 | M01 | M02 | M03 | M04 | M05 | M06 | M07 | M08 | M09 | M10 | M11 | M12
[BPL10075_ADD.XLS] | Plan 2010 |  | 0.74074 | 0.74074 | 0.74074 | 0.74074 | 0.74074 | 0.74074 | 0.74074 | 0.74074 | 0.74074 | 0.74074 | 0.74074 | 0.74074
 | Act 2010 |  | 0.70746 | 0.76353 | 0.78345 | 0.76109 | 0.75438 | 0.71741 | 0.71169 | 0 | 0 | 0 | 0 | 0
 | Upd 2010 |  | 0.70746 | 0.76353 | 0.78345 | 0.76109 | 0.75438 | 0.76923 | 0.76923 | 0.76923 | 0.76923 | 0.76923 | 0.76923 | 0.76923
 | Plan 2011 |  | 0.76923 | 0.76923 | 0.76923 | 0.76923 | 0.76923 | 0.76923 | 0.76923 | 0.76923 | 0.76923 | 0.76923 | 0.76923 | 0.76923
DSO | Plan 2011
 | Plan 2010
Exch File | Plan 2010 |  | 0.625 | 0.625 | 0.625 | 0.625 | 0.625 | 0.625 | 0.625 | 0.625 | 0.625 | 0.625 | 0.625 | 0.625
 | Act 2010 |  | 0.69061 | 0.70077 | 0.69784 | 0.70621 | 0.67705 | 0.62657 | 0.60533 | 0.60643 | 0.61275 | 0.62814 | 0.6035 | 0.6079
 | Upd 2010 |  | 0.62775 | 0.6169 | 0.65402 | 0.66225 | 0.65617 | 0.65359 | 0.65359 | 0.65359 | 0.65359 | 0.65359 | 0.65359 | 0.65359
 | Plan 2011 |  | 0.62775 | 0.6169 | 0.65402 | 0.66225 | 0.65617 | 0.65359 | 0.65359 | 0.65359 | 0.65359 | 0.65359 | 0.65359 | 0.65359
[NAME] | Plan 2010 |  | 0.11574 | 0.11574 | 0.11574 | 0.11574 | 0.11574 | 0.11574 | 0.11574 | 0.11574 | 0.11574 | 0.11574 | 0.11574 | 0.11574
[BPL10075_ADD.XLS] | Act 2010 |  | 0.01685000000000003 | 0.06276000000000004 | 0.08560999999999996 | 0.05488000000000004 | 0.07733000000000001 | 0.09084000000000003 | 0.10636 | -0.60643 | -0.61275 | -0.62814 | -0.6035 | -0.6079
 | Upd 2010 |  | 0.07970999999999995 | 0.14663 | 0.1294299999999999 | 0.09884000000000004 | 0.09821000000000002 | 0.11564 | 0.11564 | 0.11564 | 0.11564 | 0.11564 | 0.11564 | 0.11564
 | Plan 2011 |  | 0.1414799999999999 | 0.15233 | 0.1152099999999999 | 0.10698 | 0.1130599999999999 | 0.11564 | 0.11564 | 0.11564 | 0.11564 | 0.11564 | 0.11564 | 0.11564
[NAME]
A02 Balance sheet vs A03 DSO
@ update rate | Month 01 | Month 02 | Month 03 | Month 04 | Month 05 | Month 06 | Month 07 | Month 08 | Month 09 | Month 10 | Month 11 | Month 12
Link to A02 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Link to A03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Variances should be zero | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
@ plan rate | Month 01 | Month 02 | Month 03 | Month 04 | Month 05 | Month 06 | Month 07 | Month 08 | Month 09 | Month 10 | Month 11 | Month 12
Link to A02 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Link to A03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Variances should be zero | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
A02 Balance sheet vs CRM Capital
@ update rate | Month 01 | Month 02 | Month 03 | Month 04 | Month 05 | Month 06 | Month 07 | Month 08 | Month 09 | Month 10 | Month 11 | Month 12
Link to A02 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Link to CRM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Variances should be zero | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
@ plan rate | Month 01 | Month 02 | Month 03 | Month 04 | Month 05 | Month 06 | Month 07 | Month 08 | Month 09 | Month 10 | Month 11 | Month 12
Link to A02 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Link to CRM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Variances should be zero | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | ITALY ( R ) | 092 | 39
2 | [NAME] (R) | 096
3 | SAUDI ARABIA (SR) | 126
4 | ISRAEL (SR) | 130
5 | TURKEY (SR) | 146
6 | AFRICA (SR) | 433
7 | SOUTH EAST EUROPE (SR) | 435
8 | MIDDLE EAST DX NORTH (SR) | 436
9 | GULF REGION (SR) | 437
10 | NORTH & WEST AFRICA (SR) | 443
11 | CIS (R) COMMONWEALTH OF INDEPENDENT STATES | 445
12 | AREA AMTI HQ (R) | 458
13 | INDIA (SR) | K58
14 | EUROPE HQ ( R ) | 558
15 | GERMANY ( R ) | 106
16 | SWEDEN (SR) | 076
17 | NETHERLANDS (SR) | 079
18 | BELGIUM (SR) | 080
19 | FINLAND (SR) | 294
20 | BALTIC (SR) | BAL
21 | REGION WEST (R) | 563
22 | AMTI (SA) | 501
24 | IRELAND (SR) | 066
25 | UNITED KINGDOM (SR) | 075
26 | DENMARK (SR) | 078
27 | NORWAY (SR) | 297
28 | REGION NORTH ( R ) | 441
29 | AUSTRIA (SR) | 083
30 | CZECH REPUBLIC (SR) | 084
31 | HUNGARY (SR) | 085
32 | SWITZERLAND (SR) | 087
33 | POLAND (SR) | 090
34 | REGION EAST (R) | 567
35 | PORTUGAL (SR) | 093
36 | SPAIN (SR) | 094
37 | IBERIA ( R ) | 557
38 | EUROPE (SA) | 500
39 | EUROPE | 330