Spreadsheet: 71136d1271856604-excel-2007-strikethrough-conditional-formatting-example
Sheet: Sheet1

DATA ENTRY FIELDS |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-01 00:00:00 |  |  |  | 2010-02-01 00:00:00 |  |  |  | 2010-03-01 00:00:00 |  |  |  | 2010-04-01 00:00:00 |  |  |  | 2010-05-01 00:00:00 |  |  |  | 2010-06-01 00:00:00 |  |  |  | 2010-07-01 00:00:00 |  |  |  | 2010-08-01 00:00:00 |  |  |  | 2010-09-01 00:00:00 |  |  |  | 2010-10-01 00:00:00 |  |  |  | 2010-11-01 00:00:00 |  |  |  | 2010-12-01 00:00:00 |  |  |  | TOTAL-10
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual | Forecast |  | Comment | Actual | Forecast |  | Comment | Actual | Forecast |  | Comment | Actual | Forecast |  | Comment | Actual | Forecast |  | Comment | Actual | Forecast |  | Comment | Actual | Forecast |  | Comment | Actual | Forecast |  | Comment | Actual | Forecast |  | Comment | Actual | Forecast |  | Comment | Actual | Forecast |  | Comment | Actual | Forecast |  | Comment | Actual | Forecast
Probability | Supplier | Country | Activity | Campaign Dates | Funding | Funding Source | Order Type | Product | Shape | Colour | Denier | Dimensions | Forecast TAD | Each | Each |  |  | Each | Each |  |  | Each | Each |  |  | Each | Each |  |  | Each | Each |  |  | Each | Each |  |  | Each | Each |  |  | Each | Each |  |  | Each | Each |  |  | Each | Each |  |  | Each | Each |  |  | Each | Each |  |  | Each | Each
Cancelled | Company 7 | Afghanistan | Routine |  | Funded |  |  | Polyethylene | Rectangular |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 163800 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 181000
Certain | Company 1 | Angola | Routine |  | Funded |  |  | Polyester | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 327400
Certain | Company 3 | Angola | Routine |  | Funded |  |  | Polyester | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 218250
Certain | Company 2 | Angola | Routine |  | Funded |  |  | Polyethylene | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 270000 | 0 |  |  |  | 352300
Not likely |  | Angola | Routine |  | Unfunded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1217974 |  |  |  |  |  |  |  | 890574
Not likely |  | Angola | Routine |  | Unfunded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 811983 |  |  |  |  |  |  |  | 593733
Certain |  | Benin | Routine |  | Funded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 751302
Cancelled |  | Benin | Campaign | 2010-11-01 00:00:00 | Funded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  | 249660
Certain |  | Botswana | Routine |  | Funded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5200
Certain |  | [NAME] | Routine |  | Funded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  | 113000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100000
Likely |  | Burundi | Routine |  | Funded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 297566
Likely |  | Burundi | Routine |  | Unfunded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500000
Cancelled |  | Burundi | Routine |  | Unfunded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45000
Not likely |  | Central African Rep. | Routine |  | Unfunded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 519545 |  |  |  | 519544 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101786
Likely |  | Central African Rep. | Campaign | 2010-10-01 00:00:00 | Unfunded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 580713 |  |  |  | 700000 |  |  |  | 300000
Likely |  | Chad | Routine |  | Unfunded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  | 650000
Likely |  | [NAME] | Routine |  | Unfunded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 329000
Cancelled |  | Comoros | Routine |  | Funded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8425
Likely |  | Comoros | Campaign | 2010-06-01 00:00:00 | Funded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 296680
Likely |  | DR Congo | Routine |  | Funded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63900
Likely |  | Djibouti | Routine |  | Funded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90000
Not likely |  | Eritrea | Routine |  | Unfunded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50000
Likely |  | Ghana | Campaign | 2010-05-01 00:00:00 | Unfunded |  |  |  | Conical |  |  |  |  |  |  |  |  |  |  |  |  |  | 412233
Cancelled |  | Guinea-Bissau | Routine |  | Unfunded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60000
Not likely |  | Guinea-Bissau | Routine |  | Unfunded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  | 262117
Not likely |  | Guinea-Bissau | Campaign | 2010-12-01 00:00:00 | Unfunded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 114443
Not likely |  | Guinea-Bissau | Routine |  | Unfunded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 174045
Likely |  | Guinea-Conakry | Routine |  | Funded |  |  |  | Conical |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000000
Likely |  | Guinea-Conakry | Routine |  | Unfunded |  |  |  | Conical |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 293500
Cancelled |  | Haiti | Emergency |  | Funded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300000
Not likely |  | Indonesia | Campaign | 2010-10-01 00:00:00 | Unfunded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1100000
Not likely |  | Haiti | Emergency |  | Funded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100000
Not likely |  | Sudan | Routine |  | Funded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37700
Likely |  | Cote d'Ivoire | Routine |  | Funded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  | 130000
Cancelled |  | Cote d'Ivoire | Routine |  | Unfunded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 120612
Cancelled |  | Lao PDR | Routine |  | Unfunded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 237150
Likely |  | Liberia | Routine |  | Unfunded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200000
Likely |  | Madagascar | Routine |  | Funded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 75000
Likely |  | Madagascar | Routine |  | Unfunded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25000
Cancelled |  | Madagascar | Campaign |  | Unfunded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100000
Likely |  | Madagascar | Routine |  | Funded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29300
Likely |  | [NAME] | Routine |  | Funded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10000
Likely |  | [NAME] | Routine |  | Funded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  | 530500 |  |  |  |  |  |  |  |  |  |  |  | 267000
Cancelled |  | [NAME] | Routine |  | Funded |  |  |  | Rectangular |  |  |  |  |  |  |  |  |  |  |  |  |  | 300000
Likely |  | [NAME] | Routine |  | Unfunded |  |  |  | Conical |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200000
Cancelled |  | Mauritania | Routine |  | Funded |  |  |  | Conical |  |  |  |  |  |  |  |  |  |  |  |  |  | 10000
Likely |  | Mauritania | Campaign |  | Funded |  |  |  | Conical |  |  |  |  |  |  |  |  |  |  |  |  |  | 20000