tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 5535064e-66d5-41d0-b2ea-d9fbab820a32
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Financial Report
 |  | All Manufacturing: U.S. Total
 |  | Not Seasonally Adjusted Net Sales, Receipts, and Operating Revenues [Millions of Dollars]
 |  | Period: 2000 to 2013
 |  | Data Extracted on: September 22, 2014 (8:19 am)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
2000 |  |  |  | 1128790
2001 | 1082233 | 1116597 | 1062443 | 1033734
2002 | 994073 | 1071574 | 1068667 | 1082128
2003 | 1072017 | 1096910 | 1109436 | 1118800
2004 | 1145872 | 1248717 | 1250976 | 1288495
2005 | 1258442 | 1352179 | 1384246 | 1416600
2006 | 1397414 | 1485624 | 1467143 | 1432485
2007 | 1405836 | 1526484 | 1539399 | 1588312
2008 | 1566418 | 1724172 | 1682270 | 1401261
2009 | 1196693 | 1253821 | 1305867 | 1353446
2010 | 1349210 | 1461717 | 1463507 | 1481530
2011 | 1532484 | 1657405 | 1650561 | 1645072
2012 | 1648177 | 1689523 | 1656755 | 1673633
2013 | 1626424 | 1703610 | 1703748 | 1707827
Spreadsheet: 846894d1698050950-need-help-for-scatter-chart-new-map-matrix
Sheet: Sheet5

 |  | Topic | Importance for Stakeholder | Importance per Company
 |  | Integrità e rigore nella condotta aziendale | 4.28 | 4.3
 |  | Gestione e presidio dei rischi | 4.36 | 4.47
 |  | Qualità e [NAME] | 4.35 | 4.21
 |  | Qualità della customer experience | 4.46 | 4.52
 |  | Privacy e sicurezza dei dati | 4.34 | 4.39
 |  | Sviluppo del capitale umano e innovazione | 4.13 | 4.13
 |  | Employee Engagement | 4.15 | 4.21
 |  | Diversità e inclusione | 4.16 | 4.26
 |  | Performance economica | 4.16 | 4.13
 |  | Impatti ambientali diretti | 4.07 | 4.04
 |  | Gestione della catena di fornitura a tutela della sostenibilità | 3.92 | 3.91
 |  | Impegno verso le comunità e il territorio | 4.22 | 4.26
 |  | Gestione delle risorse naturali [NAME] circolare | 4.38 | 4.04
Spreadsheet: 99191d1297904320-weekly-and-monthly-reporting-test
Sheet: TOTALS

GROUP | INVESTMENT | RETURN | ROI | +/-
GROUP1 | 140 | 145 | 0.03571428571428571 | 5
[NAME] | 240 | 315 | 0.3125 | 75
TOTAL | 380 | 460 | 0.2105263157894737 | 80
Spreadsheet: 70322d1271109926-conditional-count-sum-for-month-book11
Sheet: Sheet1

2009-11-23 00:00:00 | 385.62
2009-11-24 00:00:00 | 173
2009-11-24 00:00:00
2009-11-24 00:00:00 | 175 |  |  | # | $
2009-11-30 00:00:00 | 463.83 |  | Nov | 4 | 1197.45
2009-12-04 00:00:00 | 492802.45 |  | Dec | 5 | 502533.1
2009-12-04 00:00:00
2009-12-04 00:00:00 | 5827
2009-12-07 00:00:00 | 3373.03
2009-12-08 00:00:00 | 145
2009-12-10 00:00:00
2009-12-10 00:00:00 | 385.62
Spreadsheet: 26686d1219062988-sum-back-to-a-certain-cell-book6
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
1000 | 2000 | 5000 | 1000 | 5000 | 5000 | 10000
What I want to do for my lookup is for example
SUMIF Period = 5, add back to [NAME] (giving you 14,000)
SUMIF Period = 7, add back to Cell A3 giving you 29,000)
etc etc, the cell will always be A£ to go back to.
Spreadsheet: phillip_m_love__30698__ontario synthetic variances
Sheet: July 00

 |  |  | Synthetic/Exchange Deals Not in GL - 0700
Counterparty | Sitara # | B/S | [NAME] | Flash $* | [NAME] | Sitara $ | Income Impact
Transcanada Pipelines Limited | 145772 | Buy | 1102174 |  | 1102174 | 0 | -4298479
 | 145788 | Buy | 284859 |  | 284859 | 0 | -1110950
 | 126648 | Buy | 212040 |  | 212040 | 0 | -826956
 | 145791 | Sale | 307675 | 0 | 307675 | 0 | 1199933
 | 145787 | Sale | 1200258 | 0 | 1200258 | 0 | 4681006
 | 126652 | Sale | 212040 | 0 | 212040 | 0 | 826956
Transcanada Pipelines Co. | 323880 | Sale | 59352 | 270153 | 59352 | 270153 | -38680
 | 326697 | Sale | 684720 | 3116640 | 684720 | 3116640 | -446232
 | 321856 | Sale | 238914 | 1087465 | 238914 | 1087465 | -155700
 | 323874 | Buy | 61536 | 249278 | 61536 | 249278 | 9292
 | 326690 | Buy | 709517 | 2875824 | 709517 | 2875824 | 108556
 | 321862 | Buy | 247617 | 1003397 | 247617 | 1003397 | 37638
Union Gas Limited | 343900 | Sale | 200000 | -21000 | 200000 | -21000 | 780000
Total
* This number is net of liquidation
WACOG = 3.90
*Flash dollars are net of Liquidations
Spreadsheet: gstorey__12048__NOV00
Sheet: Table10

NATURAL GAS EXPORTS BY TERM, REGION, AND CUSTOMER TYPE |  |  |  |  |  |  |  |  |  |  |  | TABLE 10
EXPORTATIONS DE GAZ NATUREL PAR TERME, RÉGION, ET CLIENT
CALENDAR YEAR TO DATE
 |  |  |  | AVERAGE PRICE |  |  |  |  |  | AVERAGE PRICE
 | VOLUME |  |  | PRIX MOYEN |  |  | VOLUME |  |  | PRIX MOYEN
 | (MILLIONS M3) |  |  | ($CDN/GJ) |  |  | (BCF) |  |  | ($US/MMBTU)
 |  |  | % CHANGE |  |  | % CHANGE |  |  | % CHANGE |  |  | % CHANGE
 | 1999/01 | 2000/01 | VARIATION | 1999/01 | 2000/01 | VARIATION | 1999/01 | 2000/01 | VARIATION | 1999/01 | 2000/01 | VARIATION
 | 1999-11-01 00:00:00 | 2000-11-01 00:00:00 |  | 1999-11-01 00:00:00 | 2000-11-01 00:00:00 |  | 1999-11-01 00:00:00 | 2000-11-01 00:00:00 |  | 1999-11-01 00:00:00 | 2000-11-01 00:00:00
TERM/TERME
LONG-TERM (FIRM)/LONG TERME (GARANTI) | 24061 | 25120.3 | 4.4 | 3.25 | 4.69 | 44 | 849.4 | 886.8 | 4.4 | 2.35 | 3.39 | 44.1
SHORT-TERM (FIRM)/COURT TERME (GARANTI) | 38806.9 | 39838.3 | 2.7 | 2.96 | 4.75 | 60.5 | 1369.9 | 1406.3 | 2.7 | 2.14 | 3.42 | 60.1
SHORT-TERM/COURT TERME (INTERRUPTIBLE) | 24005.1 | 26584.4 | 10.7 | 2.89 | 5.09 | 75.9 | 847.4 | 938.5 | 10.7 | 2.09 | 3.67 | 75.2
TOTAL - TERM/TERME | 86873 | 91543.1 | 5.4 | 3.02 | 4.83 | 59.8 | 3066.7 | 3231.6 | 5.4 | 2.18 | 3.48 | 59.5
REGION/RÉGION
CALIFORNIA/CALIFORNIE | 17240.9 | 17332.3 | 0.5 | 2.79 | 4.56 | 63.1 | 608.6 | 611.8 | 0.5 | 2.02 | 3.29 | 62.9
MIDWEST/MIDWEST | 33715.6 | 34189.2 | 1.4 | 2.87 | 4.71 | 64 | 1190.2 | 1206.9 | 1.4 | 2.07 | 3.39 | 63.6
MOUNTAIN/ROCHEUSES | 975.6 | 707.5 | -27.5 | 2.9 | 4.19 | 44.8 | 34.4 | 25 | -27.5 | 2.09 | 3.04 | 45.2
NORTHEAST/NORD-EST | 21397.5 | 26305.1 | 22.9 | 3.5 | 5.41 | 54.5 | 755.4 | 928.6 | 22.9 | 2.53 | 3.9 | 54.2
PACIFIC NORTHWEST/NORD-OUEST PACIFIQUE | 13543.5 | 13009 | -3.9 | 2.96 | 4.41 | 49 | 478.1 | 459.2 | -3.9 | 2.14 | 3.18 | 48.9
TOTAL - REGION/RÉGION | 86873 | 91543.1 | 5.4 | 4.83 | 3.02 | 59.8 | 3066.7 | 3231.6 | 5.4 | 2.18 | 3.48 | 59.5
CUSTOMER TYPE/CLIENT
END-USER/UTILISATEURS ULTIMES | 7337.8 | 6852.4 | -6.6 | 3.54 | 4.53 | 27.8 | 259 | 241.9 | -6.6 | 2.56 | 3.28 | 28
LDC/SDL | 24089.3 | 24197 | 0.4 | 3.12 | 4.81 | 53.9 | 850.4 | 854.2 | 0.4 | 2.26 | 3.47 | 53.8
MARKETING CO./DISTRIBUTEURS | 52459.9 | 56565.1 | 7.8 | 2.94 | 4.88 | 65.9 | 1851.9 | 1996.8 | 7.8 | 2.13 | 3.52 | 65.5
PIPELINE/PIPELINES | 2986 | 3928.6 | 31.6 | 2.33 | 4.77 | 104.7 | 105.4 | 138.7 | 31.6 | 1.68 | 3.41 | 102.3
TOTAL - CUSTOMER TYPE/CLIENT | 86873 | 91543.1 | 5.4 | 3.02 | 4.83 | 59.8 | 3066.7 | 3231.6 | 5.4 | 2.18 | 3.48 | 59.5
NOTE: | THE AVERAGE PRICE IS THE WEIGHTED |  |  |  |  |  |  | NOTA: | LE PRIX MOYEN EST LE PRIX MOYEN PONDÉRÉ
 | AVERAGE PRICE AT THE INTERNATIONAL BORDER |  |  |  |  |  |  |  | À LA FRONTIÈRE INTERNATIONALE
Spreadsheet: 218043d1362317862-formula-that-factors-odds-stupid-little-calculator
Sheet: Sheet1

Positions | Submittals |  | Calc | Should Be
1 | 0 |  |  | 1
1 | 1 |  |  | 0.5
3 | 1 |  |  | 3
1 | 3 |  |  | 0.3
5 | 5 |  |  | 0.5
10 | 5 |  |  | 2
Spreadsheet: 5b5ed1a4-01a5-4ab7-835b-2bfebe5e6454
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
2972 | 18105 | [NAME] | Forster | GBR | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNS | 00:00:00
2972 | 13355 | [NAME] | Hall | GBR | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNS | 00:00:00
Spreadsheet: 119785d1314738435-conditional-formatting-wastecopies
Sheet: Sheet2 (2)

 | Variable -> | 4 | 10 | 16 | 22
Count | 0 | 300 | 400 | 450 | 650
 | 25001 | 350 | 450 | 500 | 700
 | 75001 | 450 | 600 | 700 | 900
 | 125001 | 700 | 900 | 1200 | 1500
 | 150001 | 1000 | 1300 | 1750 | 2200
 | 200001 | 1400 | 2000 | 2500 | 2800
 | COUNT | Variable | Target
 | 45000 | 8 | 349
 | 45000 | 8 | 351
Spreadsheet: 132255d1323649035-formula-help-needed-leagues-2012
Sheet: County Series

Shows |  |  |  | [NAME] | RWAS Smallholders | [NAME] | Stafford | Three Counties | Norfolk | GYS | Gatcombe BE | New Forest | Bakewell | Gillingham & Shaftsbury | Ashbourne | Berkeley | Monmouth | Frome | Newbury
Driver |  | [NAME]
Derek | [NAME] | Bonnie & Clyde | S
Carole | Davenport | Wait & See | S
[NAME] | Eldridge | Mix & Match | S
[NAME] | [NAME] | Bobbie & Dazzler | S
Christine | Legate-Baggs | His & Hers | S
[NAME] | Litchfield | G & T | S
[NAME] | Marson | Gower Boys | S
[NAME] | Morris | Chalk & Cheese | S
[NAME] | Morris | Posh & Becks | S
[NAME] | Scott | Beauty & The Beast | S
Philippa | Scott | Wallace & Gromit | S
[NAME] |  | Jekyle & Hyde | S
Derek | [NAME] | Judge & Jury | L
[NAME] | Bean | Dun & Dusted | L
[NAME] | Eldridge | Just & Do It | L
[NAME] | [NAME] |  | L
[NAME] | Kinsella | Samson & Delilah | L
Christine | Legate-Baggs |  | L
[NAME] | Litchfield | Thunder & Lightning | L
[NAME] | Marson | [NAME] | L
Shelbie | McCullock | Pixie & Dixie | L
[NAME] | Morris | Suited & Booted | L
[NAME] | Mountain | Song & Dance | L
[NAME] | Scott | [NAME] | L
Philippa | Scott |  | L
[NAME] | Scott | Smokey & The Bandit | L
Trevor | Fairburn | Bangers & Mash
Trevor | Fairburn
[NAME] | Scott |  | S
[NAME] | Sycamore |  | S
[NAME] | Sycamore |  | S
[NAME] | [NAME] |  | S
Spreadsheet: 121b66e9-db4f-4a3c-aeee-2152db8d79f2
Sheet: 9c

Product | AUD** | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis* | 71824 | 56820 | 141284 | <1,000 |  |  |  |  |  | 269928
FRA |  |  | 424776 | 136155 |  | 304329 |  | 802872 |  | 1668132
IRS- [NAME] | 2105200 | 2119257 | 1307475 | 103168 |  | 250800 | 444085 | 857510 | 387377 | 7574872
OIS |  | 213627 | 76825 |  |  |  |  |  |  | 290452
VNS
Zero Coupon |  | <1,000 |  |  |  |  |  | <1,000 |  | <1,000
TOTAL | 2177024 | 2389703 | 1950359 | 239323 |  | 555129 | 444085 | 1660382 | 387377 | 9803382
Estimated gross notional amount outstanding, January 25 weekly snapshot, by product type and supermajor currency (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 269607d1381230463-countif-multiple-criteria-across-workbooks-example
Sheet: Q1

Q1 | Organisations 1
Q1 | Organisations 2
Q1 | Organisations 3
Q1 | Organisations 4
Q1 | Organisations 5
Q1 | Organisations 6
Q1 | Organisations 1
Q1 | Organisations 1
Q1 | Organisations 4
Q1 | Organisations 4
Q1 | Organisations 4
Q1 | Organisations 3
Q1 | Organisations 3
Q1 | Organisations 4
Q1 | Organisations 7
Q1 | Organisations 2
Q1 | Organisations 8
Q1 | Organisations 4
Q1 | Organisations 3
Q1 | Organisations 4
Q1 | Organisations 3
Q1 | Organisations 3
Q1 | Organisations 2
Q1 | Organisations 9
Q1 | Organisations 10
Q1 | Organisations 11
Q1 | Organisations 12
Spreadsheet: 883718d1732372456-look-up-top-5-if-any-from-a-matris-for-4-years-topp-5-since-4-years
Sheet: Blad1

Find out top 5 with increased numbers
 |  | Not to be counted
 |  | Additional info
A1234 | 100 | 1 | 3 | 5 | 2
A3245 | 50 | 3 | 8 | 4 | 3
A4589 | 45 | 2 | 3 | 6 | 3
A7634 | 35 | 5 | 46 | 23 | 5
A9087 | 27 | 3 | 29 | 27 | 4
A2341 | 10 | 7 | 34 | 34 | 0
…
..
Down to Row 35
 | Top 5 with increased nbrs every year since 4 years back
Want this result
 |  | Add info
A3245 | 50 | 3 | 8 | 4 | 3
A7634 | 35 | 5 | 46 | 23 | 5
Spreadsheet: 54611d1254647439-excel-accounting-help-pm-tracking
Sheet: Monthly History

Stock ID | Name | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 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 | Total
[NAME] | 50mm x 35mm Keyring | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
KR-57x22 | 57mm x 22mm Keyring | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
KR-34S | 34mm Square Keyring | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
KR-34R | 34mm Round Keyring | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
KR-45S | 45mm Square Keyring | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
KR-45R | 45mm Round Keyring | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
PG-Heart | Heart Photo Globe | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
PG-Snow | Snow Photo Globe | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
PG-Glitter | Glitter Photo Globe | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
MUG-Glass-Stein | [NAME] Beer Stein | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
KR-BOB | Black Bottle Opener Keyring | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
DC-90S | 90mm Square Acrylic Drink Coaster | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
MP-DIY | Do It Yourself Mousepad | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
0 | 0 | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
0 | 0 | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
0 | 0 | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
0 | 0 | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
0 | 0 | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
0 | 0 | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
0 | 0 | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
0 | 0 | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
0 | 0 | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
0 | 0 | 0 | 0 | 0 | 271 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 271
Spreadsheet: 167943d1342164919-i-want-to-send-data-in-multiple-workbook-projcet-05-expense-ledger
Sheet: COntractor-Electric Works

 |  |  |  |  |  |  | PROJECT # 05
 |  |  |  | Contractor-Electric |  |  | Mr.[NAME]
DATE | B# | P# | L# | Voucher No. | A/C | Description | [NAME]# | Qty | Rate | Cheq#/PS | Bank | Book# | A/C Ref # |  |  | DEBIT | CREDIT | BALANCE
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]# | Page# | Ledger#
2010-12-07 00:00:00 | 02 | 36 | CL-09 |  |  | Labour slab Pipes |  |  |  | 5175979 | BAH | B-25 |  | 31 | BL-01 |  | 5000 | 5000
2010-10-16 00:00:00 | 03 | 36 | CL-09 |  |  | [NAME] electric |  |  |  | 5192132 | BAH | F-06 |  | 77 | BL-01 |  | 5000 | 10000
2010-10-27 00:00:00 | 04 | 36 | CL-09 |  |  | [NAME] electric |  |  |  | 5192145 | BAH | F-06 |  | 78 | BL-01 |  | 25000 | 35000
2011-04-07 00:00:00 | 05 | 34 | CL-10 |  |  | [NAME] electric |  |  |  | 5214760 | BAH | F-15 |  | 22 | BL-02 |  | 100000 | 135000
2011-05-18 00:00:00 | 06 | 34 | CL-10 |  |  | [NAME] electric |  |  |  | 54689144 | HMB | A-1 |  | 67 | BL-02 |  | 25000 | 160000
2011-06-02 00:00:00 | 07 | 34 | CL-10 |  |  | [NAME] electric |  |  |  | 52608679 | HMB | A-2 |  | 69 | BL-02 |  | 25000 | 185000
2011-06-27 00:00:00 | 08 | 34 | CL-10 |  |  | [NAME] electric |  |  |  | 55915557 | HMB | A-3 |  | 72 | BL-02 |  | 50000 | 235000
2011-07-23 00:00:00 | 09 | 34 | CL-10 |  |  | [NAME] electric |  |  |  | 56173006 | HMB | A-4 |  | 73 | BL-02 |  | 25000 | 260000
2011-08-15 00:00:00 | 10 | 34 | CL-10 |  |  | [NAME] electric |  |  |  | 56173052 | HMB | A-4 |  | 75 | BL-02 |  | 25000 | 285000
2011-08-15 00:00:00 | 11 | 34 | CL-10 |  |  | [NAME] electric |  |  |  | 56173053 | HMB | A-4 |  | 75 | BL-02 |  | 25000 | 310000
2011-08-15 00:00:00 | 12 | 34 | CL-10 |  |  | [NAME] electric |  |  |  | 56173054 | HMB | A-4 |  | 75 | BL-02 |  | 50000 | 360000
Spreadsheet: 858d94c6-5de4-4aa8-b1b2-3db240a8f365
Sheet: PAG 12

LAS Beer |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | 1Q10 | Scope |  |  | 1Q11 | Reported | Organic
Volume ('000 hl) | 5786.939 | 0 | 0 | 254.5589999999993 | 6041.498 | 0.04398854040106515 | 0.0439885404010651
Net revenue | 774.579 | 0 | -86.47932073212405 | 166.316320732124 | 854.4159999999999 | 0.1030714749560728 | 0.2147183447164512
Net revenue/hl | 133.8495187179267 | 0 | -14.31421821742291 | 21.88922699251202 | 141.4245274930158 | 0.05659347039605467 | 0.1635360903959706
[NAME] | -221.8736351473364 | 0 | 22.18854691275052 | -40.42766176541407 | -240.1127499999999 | 0.08220496698741031 | 0.182210300645085
[NAME]/hl | -38.34041367073964 | 0 | 3.672689606576138 | -5.076185476152482 | -39.74390954031599 | 0.03660617440461933 | 0.1323977753538556
Gross profit | 552.7053648526635 | 0 | -64.29077381937353 | 125.88865896671 | 614.3032499999999 | 0.1114479595539239 | 0.2277681147536328
Gross margin | 0.7135558346568439 | 0 | 0 | 0 | 0.7189744222954626 | 50 | 80
SG&A excl. deprec.&amort. | -141.218 | 0 | 16.2124424901973 | -37.2434424901973 | -162.249 | 0.1489257743347165 | 0.2637301370235898
SG&A deprec.&amort. | -9.498999999999999 | 0 | 1.216412313242348 | -3.157412313242349 | -11.44 | 0.2043372986630174 | 0.3323941797286398
SG&A total | -150.717 | 0 | 17.42885480343963 | -40.40085480343965 | -173.689 | 0.1524181081099014 | 0.2680577161397828
Other operating income | -5.825829539166507 | 0 | 1.049824668770757 | 0.05379815679509814 | -4.722206713600651 | -0.1894361683853436 | -0.009234419996915147
Normalized EBIT | 396.162535313497 | 0 | -45.81209434716314 | 85.54160232006541 | 435.8920432863993 | 0.1002858787276868 | 0.2159255222162121
Normalized EBIT margin | 0.5114553006387947 | 0 | 0 | 0 | 0.5101637180090253 | -10 | 10
Normalized EBITDA | 448.329535313497 | 0 | -51.45076776191934 | 95.8372757348217 | 492.7160432863993 | 0.09900420221448236 | 0.2137652511958797
Normalized EBITDA margin | 0.5788041443332405 | 0 | 0 | 0 | 0.5766699632104261 | -20 | 0
Spreadsheet: 766249d1643817150-aggregate-primary-and-secondary-issue-types-transpose-and-add-table
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 |  |  |  |  |  | Expectation - combine the 2 tables on the left for a total by type by quarter)
Primary Issue |  |  |  |  |  |  |  |  |  |  |  |  | Quarter | Testing | Documentation | Technical | Coding | Implementation | Support
 | 2021 |  |  |  | 2022 |  |  |  |  |  |  | 2021 | 1 | 12 |  | 8 |  | 6
Issue Type | 1 | 2 | 3 | 4 | 1 | 2 | 3 |  |  |  |  |  | 2 | 7 | 34 |  |  | 10
Testing | 6 | 7 | 4 |  | 45 | 23 | 8 |  |  |  |  |  | 3 | 8 | 6 |  | 6 |  | 8
Documentation |  | 34 | 3 |  | 7 |  | 7 |  |  |  |  |  | 4 |  |  |  | 3
Technical | 4 |  |  |  |  | 2 | 4 |  |  |  |  | 2022 | 1 | 45 | 14 |  | 16 |  | 2
Coding |  |  | 3 | 3 | 8 |  | 1 |  |  |  |  |  | 2 | 26 |  | 4 |  | 2
Implementation | 3 | 5 |  |  |  | 2 | 11 |  |  |  |  |  | 3 | 16 | 14 | 8 | 2 | 22 | 5
Support
 |  |  |  |  |  |  |  |  |  |  |  | Year:Qtr | Testing | Documentation | Technical | Coding | Implementation | Issue Type | Support
 |  |  |  |  |  |  |  |  |  |  |  | 2021:1 | 12 |  | 8 |  | 6 | 1
Secondary Issue |  |  |  |  |  |  |  |  |  |  |  | 2021:2 | 7 | 34 |  |  | 10 | 2
 | 2021 |  |  |  | 2022 |  |  |  |  |  |  | 2021:3 | 8 | 6 |  | 6 |  | 3 | 8
Issue Type | 1 | 2 | 3 | 4 | 1 | 2 | 3 |  |  |  |  | 2021:4 |  |  |  | 3 |  | 4
Testing | 6 |  | 4 |  |  | 3 | 8 |  |  |  |  | 2022:1 | 45 | 14 |  | 16 |  | 1 | 2
Documentation |  |  | 3 |  | 7 |  | 7 |  |  |  |  | 2022:2 | 26 |  | 4 |  | 2 | 2
Technical | 4 |  |  |  |  | 2 | 4 |  |  |  |  | 2022:3 | 16 | 14 | 8 | 2 | 22 | 3 | 5
Coding |  |  | 3 |  | 8 |  | 1
Implementation | 3 | 5 |  |  |  |  | 11
Support |  |  | 8 |  | 2 |  | 5
Spreadsheet: 59224d1259716197-how-are-rows-with-near-identical-field-entries-combined-budget-10-11-to-19-20
Sheet: Sheet1

The original data range (colours used to illustrate destination, after consolidation):
Product | Type | Qty | Rate | Cost | [NAME] | Year | CorridorID | Customer | Comments | TempOldID | LastEditor | DateStamp
1 |  | 1 | 0 | 0 | 0 | 2010/11 | 921 |  |  |  |  | 2009-12-02 10:32:18
1 |  | 1 | 0 | 0 | 0 | 2010/11 | 921 |  |  |  |  | 2009-12-02 10:32:18
1 |  | 1 | 0 | 0 | 0 | 2011/12 | 921 |  |  |  |  | 2009-12-02 10:32:18
1 |  | 1 | 0 | 0 | 0 | 2011/12 | 921 |  |  |  |  | 2009-12-02 10:32:18
2 |  | 1 | 0 | 0 | 0 | 2010/11 | 919 |  |  |  |  | 2009-12-02 10:32:18
2 |  | 1 | 0 | 0 | 0 | 2010/11 | 919 |  |  |  |  | 2009-12-02 10:32:18
2 |  | 1 | 0 | 0 | 0 | 2011/12 | 919 |  |  |  |  | 2009-12-02 10:32:18
2 |  | 1 | 0 | 0 | 0 | 2011/12 | 919 |  |  |  |  | 2009-12-02 10:32:18
7 |  | 200 | 100.525 | 20105 | 0 | 2010/11 | 919 |  |  |  |  | 2009-12-02 10:32:18
7 |  | 650 | 106.1815384615385 | 69018 | 0 | 2010/11 | 919 |  |  |  |  | 2009-12-02 10:32:18
7 |  | 600 | 95.48666666666666 | 57292 | 0 | 2011/12 | 921 |  |  |  |  | 2009-12-02 10:32:18
7 |  | 1400 | 113.1335714285714 | 158387 | 0 | 2011/12 | 921 |  |  |  |  | 2009-12-02 10:32:18
15 |  | 588 | 117.9937414965986 | 69380.32 | 0 | 2010/11 | 921 |  |  |  |  | 2009-12-02 10:32:18
15 |  | 2604 | 98.25290322580645 | 255850.56 | 0 | 2010/11 | 921 |  |  |  |  | 2009-12-02 10:32:18
15 |  | 588 | 117.9937414965986 | 69380.32 | 0 | 2011/12 | 921 |  |  |  |  | 2009-12-02 10:32:18
15 |  | 2604 | 98.25290322580645 | 255850.56 | 0 | 2011/12 | 921 |  |  |  |  | 2009-12-02 10:32:18
144 |  | 0 | 0 | 0 | 0 | 2010/11 | 32 |  |  |  |  | 2009-12-02 10:32:18
144 |  | 772 | 113.9555440414508 | 87973.68 | 0 | 2010/11 | 32 |  |  |  |  | 2009-12-02 10:32:18
144 |  | 0 | 0 | 0 | 0 | 2010/11 | 51 |  |  |  |  | 2009-12-02 10:32:18
144 |  | 1825 | 116.2641095890411 | 212182 | 0 | 2010/11 | 51 |  |  |  |  | 2009-12-02 10:32:18
The simplification process should deliver the following range:
Product | Type | Qty | Rate | Cost | [NAME] | Year | CorridorID | Customer | Comments | TempOldID | LastEditor | DateStamp
1 |  | 1 | 0 | 0 | 0 | 2010/11 | 921 |  |  |  |  | 2009-12-02 10:32:18
1 |  | 1 | 0 | 0 | 0 | 2011/12 | 921 |  |  |  |  | 2009-12-02 10:32:18
2 |  | 1 | 0 | 0 | 0 | 2010/11 | 919 |  |  |  |  | 2009-12-02 10:32:18
2 |  | 1 | 0 | 0 | 0 | 2011/12 | 919 |  |  |  |  | 2009-12-02 10:32:18
7 |  | 850 | 104.8505882352941 | 89123 | 0 | 2010/11 | 919 |  |  |  |  | 2009-12-02 10:32:18
7 |  | 2000 | 107.8395 | 215679 | 0 | 2011/12 | 921 |  |  |  |  | 2009-12-02 10:32:18
15 |  | 3192 | 117.9937414965986 | 325230.88 | 0 | 2010/11 | 921 |  |  |  |  | 2009-12-02 10:32:18
15 |  | 3192 | 101.889373433584 | 325230.88 | 0 | 2011/12 | 921 |  |  |  |  | 2009-12-02 10:32:18
144 |  | 772 | 113.9555440414508 | 87973.68 | 0 | 2010/11 | 32 |  |  |  |  | 2009-12-02 10:32:18
144 |  | 1825 | 116.2641095890411 | 212182 | 0 | 2010/11 | 51 |  |  |  |  | 2009-12-02 10:32:18
Spreadsheet: 120981d1315719993-expense-sheet-help-book1
Sheet: Sheet1

Desc | Amount | [NAME]
Item 1 | 10 | [NAME]
Item 2 | 12 | [NAME]
Item 3 | 19 | [NAME]
Item 4 | 17 | [NAME]
Item 5 | 18 | [NAME]
Total
[NAME] | 27
[NAME] | 30
[NAME] | 19
Spreadsheet: 100185d1298594699-how-to-auto-sort-on-1-sheet-but-for-three-different-areas-highestcostvehichle
Sheet: Sheet1

 | What vehicle is killing us in repair costs
 |  | 2011-02-24 17:00:46 |  |  |  | Go To
 | Line Trucks |  |  |  | Line Trucks |  | Trailers |  |  |  | Vehichle | Cost
 |  | 1 |  |  |  |  |  |  |  | Line Trucks
 |  | 101 |  |  |  |  |  |  |  | Person Vehichles
 |  | 3 |  |  |  |  |  |  |  | Trailers
 |  | 4
 |  | 1
 |  | 6
 | Person Vehichles |  |  |  | Vehicles
 |  | 4
 |  | 5
 |  | 99
 |  | 3
 |  | 2
 |  | 3
 |  | 4
 |  | 8
 | Trailers
 |  | 55
 |  | 4
 |  | 5
 |  | 2
 |  | 1
 |  | 8
 |  | 7
 |  | 6
 |  | 9
Spreadsheet: 735691d1623144799-how-to-match-cell-value-using-match-function-test-version-1-ans2
Sheet: Sheet1

ColumnA | ColumnB | ColumnC | ColumnD | ColumnE | ColumnF | ColumnFExpectedResult
Ok | India | India | [NAME] – DDD BBB | AA-YYY |  | [NAME] – DDD BBB | TESTA
NotOk | Singapore | Singapore |  | BB-CCC |  |  | TESTB
Ok | Malaysia | Malaysia | [NAME]  AAAAAAA - GGGGG  VVVVVVV - BBB YYYYY | FF -DDD |  | [NAME] DDDD | TESTC | [NAME]  AAAAAAA - GGGGG  VVVVVVV - BBB YYYYY
NotOk | Brazil | Brazil |  | GG-EEE |  |  | TESTD