tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 730295d1619633060-multiple-calculations-formula-required-botanicals-requirements-to-order
Sheet: Order Requirements

 | Job | Customer | AMOUNT (Bottles) | BOTTLE |  | 0.03 | Litres Paid | Litres To Make | Natural Corks | Black Corks | Overseal | Boxes & Dividers
 | 1 | C1 | 880 | 5cl Noc |  |  |  | 635
 |  |  |  |  |  |  |  |  |  |  |  | 147
 | 2 | C2 | 100 | 5cl Noc |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 9
 | 3 | [NAME] |  | 5cl Noc |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 4 | C4 |  | 5cl Noc |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 5 | C5 |  | 5cl Noc |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 6 | C6 | 1000 | 5cl Noc |  |  |  | 52
 |  |  |  |  |  |  |  |  |  |  |  | 84
5cl Noc
5cl Pacho
20cl Noc
35cl Noc
50cl Noc
50cl Aspect
50cl Pacho
50cl Serenade
70cl Noc
225L Barrel
Natural
Black
Spreadsheet: 470768d1468632573-help-with-v-look-up-vlookuppackingslip
Sheet: Data (2)

Item | Retail Price
[NAME] in Harriman, 1st ed., 2015 (978-1-880775-93-6) | 15.95
Hike of the Week, 1st ed., 2013 (978-1-880775-78-3) | 19.95
Hiking Long Island, 4th ed., 2014 (978-1-880775-87-5) | 22.95
Harriman Trails: A Guide and History, [NAME], 2010 (978-1-880775-66-0) | 19.95
Hiking the Jersey Highlands, 1st ed., 2007 (978-1-880775-49-3) | 22.95
[NAME], 1st ed., 2004 (1-880775-38-7) | 18.95
New York Walk Book, 7th ed., 2005 (1-880775-30-1) | 22.95
Scenes and Walks in the Northern Shawangunks, [NAME], 2006 (978-1-880775-50-9) | 13.95
Walkable Westchester, 2nd ed., 2014 (978-1-880775-88-2) | 24.95
Spreadsheet: 809255d1670992684-pc-asset-tracker-get-value-in-new-sheet-sample-pc-asset-tracker-update2-
Sheet: Berlin

Employee ID | Asset Tag | Serial No | Hostname | Owner | Departement | Location | Brand | Model | Type | Service Start | Service End | Status | Return | Asset Tag 2 | Serial No | Hostname 2 | Brand | Model | Type | Service Start | Service End | Status
A1234
[NAME]
A9870
A1234
Spreadsheet: louise_kitchen__22682__Net Rec & Pay w Bridgeline
Sheet: Sheet1

Analysis of Outstanding Bridgeline Payables and Receivables
As of October 26, 2001
Payable to Bridgeline:
August 2001 Pad Gas BTU Conversion Adjustment |  |  |  |  |  |  | 155751.75
September 2001 Pad Gas BTU Conversion Adjustment |  |  |  |  |  |  | 110565
Subtotal
CES Contract Commission
2000-07-01 00:00:00 |  |  |  |  |  |  | 50000
2000-08-01 00:00:00 |  |  |  |  |  |  | 50000
2000-09-01 00:00:00 |  |  |  |  |  |  | 50000
2000-10-01 00:00:00 |  |  |  |  |  |  | 50000
2000-11-01 00:00:00 |  |  |  |  |  |  | 50000
2000-12-01 00:00:00 |  |  |  |  |  |  | 50000
2001-01-01 00:00:00 |  |  |  |  |  |  | 50000
2001-02-01 00:00:00 |  |  |  |  |  |  | 50000
2001-03-01 00:00:00 |  |  |  |  |  |  | 50000
2001-04-01 00:00:00 |  |  |  |  |  |  | 50000
2001-05-01 00:00:00 |  |  |  |  |  |  | 50000
2001-06-01 00:00:00 |  |  |  |  |  |  | 50000
2001-07-01 00:00:00 |  |  |  |  |  |  | 50000
2001-08-01 00:00:00 |  |  |  |  |  |  | 50000
Subtotal | (Provided by Bridgeline, still confirming with Enron records)
Total Payable to Bridgeline
Receivable from Bridgeline:
Administrative expenses (includes rent, telephone, parking, etc)
Bridgeline has agreed to pay
Bridgeline requires more documentation
Subtotal
Unpaid items per Bridgeline (need to confirm with Enron records)
2000 Target Bonus |  |  |  |  |  |  | 841300
2000 Rent for 3AC (original billing from Enron Property Services) |  |  |  |  |  |  | 31146.27
2000 Excess Liability Insurance |  |  |  |  |  |  | 15852
2001 Excess Liability Insurance |  |  |  |  |  |  | 14805
2000 Liability Insurance |  |  |  |  |  |  | 20420
2001 Liability Insurance |  |  |  |  |  |  | 19436.55
2000 Property Insurance |  |  |  |  |  |  | 25500
2001 Property Insurance |  |  |  |  |  |  | 24093
Dow Lease |  |  |  |  |  |  | 306700.04
Subtotal
Total Receivable from Bridgeline
Net due from Bridgeline
Spreadsheet: 82044d1282108663-using-vlookup-to-return-single-value-based-on-calculations-of-other-columns-query
Sheet: Sheet1

Sk No. | Sk Name | True Calls offered | Calls Offered* (excl aban <10s) | ACD Calls | # Ans in SVL | % Ans in SVL | ASA | Total ANSTIME | [NAME] <10s | Total ABNTIME | Total Handle Time | AHT | External Outbound Attempts | Transfer + Conf | Aban Rate
 |  | 129422 | 126038 | 121211 | 86181 | 0.6838 | 48.2428817749 | 5847568 | 4827 | 922676 | 40182696 | 331.510314941 | 6617 | 21721 | 0.0383
1 | s1 | 5754 | 5449 | 5284 | 4054 | 0.744 | 28.1608638763 | 148802 | 165 | 18748 | 1783814 | 337.587799072 | 352 | 766 | 0.0303
2 | s2 | 52956 | 52340 | 50547 | 36976 | 0.7065 | 46.22996521 | 2336786 | 1793 | 371154 | 14605716 | 288.953186035 | 957 | 7349 | 0.0343
3 | s3 | 10 | 7 | 6 | 4 | 0.5714 | 17 | 102 | 1 | 34 | 1394 | 232.333328247 | 4 | 1 | 0.1429
4 | s4 | 451 | 293 | 274 | 219 | 0.7474 | 49.1277389526 | 13461 | 19 | 2628 | 102797 | 375.171539307 | 89 | 21 | 0.0648
5 | p1 | 2026 | 1943 | 1912 | 1635 | 0.8415 | 17.5596237183 | 33574 | 31 | 3136 | 678621 | 354.927307129 | 194 | 323 | 0.016
6 | p2 | 7847 | 7635 | 7430 | 5483 | 0.7181 | 31.3786010742 | 233143 | 205 | 29458 | 2701892 | 363.64630127 | 845 | 1042 | 0.0269
7 | s5 | 514 | 408 | 400 | 312 | 0.7647 | 33.2299995422 | 13292 | 8 | 866 | 130879 | 327.197509766 | 38 | 52 | 0.0196
11 | m1 | 2504 | 2276 | 2180 | 1643 | 0.7219 | 42.2802734375 | 92171 | 96 | 17731 | 741819 | 340.283935547 | 221 | 669 | 0.0422
12 | m2 | 26624 | 25941 | 25255 | 17198 | 0.663 | 52.4102935791 | 1323622 | 686 | 129496 | 10510862 | 416.189361572 | 2540 | 3340 | 0.0264
15 | s6 | 711 | 707 | 684 | 505 | 0.7143 | 26.2456130981 | 17952 | 23 | 2714 | 196915 | 287.887420654 | 131 | 116 | 0.0325
16 | s7 | 2974 | 2729 | 2677 | 1961 | 0.7186 | 35.9208068848 | 96160 | 52 | 10212 | 941483 | 351.69329834 | 221 | 226 | 0.0191
21 | g1 | 9068 | 8810 | 8441 | 5603 | 0.636 | 61.9985771179 | 523330 | 369 | 80416 | 2840489 | 336.510955811 | 415 | 2268 | 0.0419
23 | g2 | 17255 | 16869 | 15536 | 10188 | 0.6039 | 63.1752700806 | 981491 | 1333 | 247777 | 4779288 | 307.626678467 | 581 | 5165 | 0.079
24 | m3 | 728 | 631 | 585 | 400 | 0.6339 | 57.5760688782 | 33682 | 46 | 8306 | 166765 | 285.068389893 | 29 | 383 | 0.0729
51 | o1 | 0 | 0 | 0 | 0 |  |  | :00:00 | 0 | :00:00 | :00:00 |  | 476 | 1
ASA | sum of S = | 43.86950494388028
ASA | sum of M = | 51.73001427551749
Problem with above calculations is that it is assumed that values under S & M will always be on same row
this is not the case as some months additional data may appear e.g. Sk No 10 or 14.
I therefore need to use something like a vlookup function that always looks for set value in column A
Spreadsheet: 723998d1615983408-creating-a-new-list-based-on-criteria-in-existing-column-and-map-new-columns-to-it-excel-dummy-data
Sheet: Input needed

 | Starting point (data is organized as below, in a living document with multiple users)
 |  |  | Timeframe | May | May | April | April | May | April | May | April | April | April
 | Property | Property type |  | Buyer 1 | Buyer 2 | Buyer 3 | Buyer 4 | Buyer 5 | Buyer 6 | Buyer 7 | Buyer 8 | Buyer 9 | Buyer 10
 | Property 1 | Mansion |  | x |  | x |  | x |  |  |  | x
 | Property 2 | Mansion
 | Property 3 | Apartment |  |  |  |  |  |  | x |  | x |  | x
 | Property 4 | Penthouse |  |  | x
 | Property 5 | Country house |  |  | x |  |  | x
 | Property 6 | Mansion |  |  |  |  |  |  |  | x |  | x
 | Property 7 | Apartment |  |  | x |  | x |  |  | x
 | Property 8 | Apartment
 | Property 9 | Apartment |  |  |  |  |  |  |  | x
 | Property 10 | Country house |  |  |  | x |  |  |  |  | x
Spreadsheet: 141374d1329237601-using-vlookup-when-you-have-two-values-to-look-up-vlookup
Sheet: Raw Data

Team | Type | Cost
ABC | Active | 1000
DEF | Non-active | 2000
GHI | Non-active | 3000
JKL | Non-active | 4000
ABC | Non-active | 5000
DEF | Non-active | 6000
GHI | Active | 7000
JKL | Non-active | 8000
ABC | Non-active | 9000
DEF | Non-active | 10000
GHI | Non-active | 11000
JKL | Non-active | 12000
ABC | Active | 13000
DEF | Non-active | 14000
GHI | Non-active | 15000
JKL | Non-active | 16000
ABC | Non-active | 17000
DEF | Non-active | 18000
GHI | Active | 19000
JKL | Non-active | 20000
ABC | Non-active | 21000
DEF | Non-active | 22000
GHI | Non-active | 23000
JKL | Non-active | 24000
ABC | Active | 25000
DEF | Non-active | 26000
GHI | Non-active | 27000
JKL | Non-active | 28000
Spreadsheet: 717141d1612509389-conditional-format-cell-with-date-from-previous-month-trial-2
Sheet: ALL Summary

Name of Report: | REPORT |  |  | Base Line | 2019-08-01 00:00:00 |  |  | No. of Crew
Company: | Company 1 |  |  | Duration | 60 |  | AHEAD OF SCHEDULE
Vessels included: |  |  |  | Expected |  |  | ON SCHEDULE
 |  |  |  | Vessel's Performance |  |  | BEHIND SCHEDULE
Spreadsheet: 543526d1508431845-pulling-data-from-one-sheet-to-another-skipping-duplicate-data-testsheet1
Sheet: sheet

State | County | Gtr/Gte | Geo | Images
AK | Anchorage | 2008-06-01 00:00:00 | 2008-06-01 00:00:00 | 2001-01-02 00:00:00
AR | [NAME] | 1975-01-07 00:00:00 | 1975-01-07 00:00:00 | 1990-02-20 00:00:00
AR | Boone |  | 1989-01-03 00:00:00 | 1997-06-20 00:00:00 |  |  |  |  | list
AR | Faulkner |  | 2003-03-03 00:00:00 | 2006-01-03 00:00:00 |  |  |  |  | AK
AR | Garland |  | 1990-01-01 00:00:00 | 1983-10-25 00:00:00 |  |  |  |  | AR
AR | Lonoke |  | 1977-04-19 00:00:00 | 2001-09-19 00:00:00 |  |  |  |  | AZ
AR | Pulaski |  | 1977-10-03 00:00:00 | 1998-01-02 00:00:00
AR | Saline |  | 1995-01-01 00:00:00 | 2007-01-02 00:00:00
AR | [NAME] |  | 1987-01-01 00:00:00 | 1999-09-01 00:00:00
AR | Washington |  | 1973-02-19 00:00:00 | 1962-12-20 00:00:00
AR | White |  | 2003-03-03 00:00:00 | 2007-01-02 00:00:00
AR | Craighead West |  | 1999-01-01 00:00:00 | 2007-01-02 00:00:00
AZ | [NAME] | 2008-06-02 00:00:00 | 2008-06-02 00:00:00 | 2003-01-02 00:00:00
AZ | [NAME] | 2008-06-02 00:00:00 | 2008-06-02 00:00:00 | 2000-01-03 00:00:00
AZ | Pima | 2000-01-02 00:00:00 | 2007-12-17 00:00:00 | 1999-01-04 00:00:00
AZ | Santa Cruz | 2008-06-02 00:00:00 | 2008-06-02 00:00:00 | 2007-01-02 00:00:00
AZ | La Paz | 2008-06-02 00:00:00 | 2008-06-02 00:00:00 | 2006-01-03 00:00:00
AZ | Apache |  | 1994-10-14 00:00:00 | 1992-12-11 00:00:00
AZ | Cochise | 1977-11-29 00:00:00 | 1977-11-29 00:00:00 | 2003-01-02 00:00:00
AZ | Coconino |  | 1987-01-01 00:00:00 | 1988-09-01 00:00:00
AZ | [NAME] |  | 1994-11-15 00:00:00 | 1988-10-25 00:00:00
AZ | Maricopa |  | 1970-05-01 00:00:00 | 1947-06-20 00:00:00
AZ | Mohave |  | 1970-05-01 00:00:00 | 1989-01-03 00:00:00
AZ | [NAME] |  | 1994-10-24 00:00:00 | 1991-05-07 00:00:00
AZ | Pinal |  | 1970-05-01 00:00:00 | 1989-01-03 00:00:00
AZ | Yavapai |  | 1987-01-01 00:00:00 | 1990-01-02 00:00:00
AZ | Yuma |  | 1980-03-01 00:00:00 | 1984-01-04 00:00:00
Spreadsheet: 777437d1650379398-dynamic-lookup-from-named-source-table-table-reference
Sheet: table link

Result tables
This works
P/N | Price | Supplier |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Price
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Supplier
ZZZ
This does not work with Named Table
P/N | Supplier | Price
ABC
ZZZ
A124
BBB789
A123
 |  |  |  |  | Source Table
 |  |  |  |  | P/N | Price | Supplier
 |  |  |  |  | ABC | 1.5 | S2
 |  |  |  |  | A123 | 2 | S3
 |  |  |  |  | A124 | 3.9 | S2
 |  |  |  |  | BBB789 | 6 | S1
Spreadsheet: 838043d1690640924-shorten-formula-using-array-approach-example
Sheet: Example

Value of each project | 10000 |  |  | checks
Pattern for spreading  values
Time point from start (month) |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Return percentage |  | 0.08 | 0.08 | 0.08 | 0.08 | 0.03 | 0.03 | 0.03 | 0.03 | 0.03 | 0.05 | 0.05 | 0.1 | 0.1 | 0.03 | 0.03 | 0.03 | 0.03 | 0.03 | 0.05 | 0.03
Calendar
Offset |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7
Calendar month |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
Projects starting by cal. month |  | 1 | 2 | 1 | 3 | 0 | 0 | 0 | 0 |  |  | projects
Total value of projects |  |  |  |  |  |  |  |  |  |  |  | total value
 | Calendar month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
Projects starting in cal. month | Total value
1
2
3
4
Separate formulas for each starting  month
Calendar month 1
Calendar month 2
Calendar month 3
Calendar month 4
Total
One formula for four starting months
Check
Spreadsheet: 773929d1648121321-days-to-hit-80-formula-days-to-hit-80-
Sheet: Sheet1

Age | 2 | 3 | 4 | 5 | 6 | 7 | Total | Days to [NAME]
Task 1 | 0.15 | 0.44 | 0.5 | 0.6 | 0.81 | 1 | 6
Task 2 | 0.22 | 0.55 | 0.82 | 1 | 1 | 1
Task 3 | 0.15 | 0.21 | 0.22 | 0.79 | 0.82 | 1
Task 4 | 0.15 | 0.21 | 0.21 | 0.81 | 1 | 1
Task 5 | 0.22 | 0.55 | 0.55 | 0.66 | 0.81 | 1
Spreadsheet: 859281d1707729414-aggregate-function-not-working-aggregatehelp
Sheet: Sheet1

 | Day | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | 1 | 5 | 3 | 4 | 6 | 8 | 4 | 14 | 11 | 6 | 10 | 5 | 5
 | 2 | 6 | 12 | 6 | 7 | 12 | 12 | 5 | 12 | 8 | 8 | 13 | 7 |  |  | Rank | Least Records | Month | Day
 | 3 | 5 | 8 | 3 | 5 | 14 | 13 | 12 | 10 | 8 | 6 | 15 | 10 |  |  | 1
 | 4 | 1 | 5 | 3 | 9 | 9 | 9 | 12 | 4 | 9 | 7 | 7 | 7 |  |  | 2
 | 5 | 8 | 2 | 4 | 7 | 5 | 15 | 8 | 9 | 6 | 5 | 8 | 7 |  |  | 3
 | 6 | 6 | 4 | 6 | 15 | 7 | 14 | 11 | 15 | 8 | 5 | 9 | 4 |  |  | 4
 | 7 | 4 | 3 | 6 | 14 | 4 | 13 | 7 | 9 | 15 | 9 | 12 | 1 |  |  | 5
 | 8 | 1 | 10 | 5 | 10 | 4 | 10 | 3 | 4 | 6 | 8 | 16 | 6 |  |  | 6
 | 9 | 4 | 3 | 3 | 5 | 11 | 8 | 3 | 6 | 5 | 6 | 12 | 6 |  |  | 7
 | 10 | 4 | 2 | 6 | 5 | 6 | 15 | 14 | 5 | 7 | 5 | 13 | 7 |  |  | 8
 | 11 | 5 | 0 | 12 | 9 | 4 | 10 | 16 | 8 | 2 | 8 | 11 | 9 |  |  | 9
 | 12 | 7 | 0 | 5 | 8 | 8 | 4 | 5 | 11 | 9 | 7 | 6 | 6 |  |  | 10
 | 13 | 5 | 6 | 9 | 10 | 6 | 12 | 12 | 10 | 10 | 11 | 9 | 4 |  |  | 11
 | 14 | 6 | 8 | 8 | 9 | 2 | 14 | 6 | 18 | 8 | 2 | 12 | 3 |  |  | 12
 | 15 | 1 | 6 | 10 | 7 | 14 | 7 | 12 | 10 | 9 | 7 | 11 | 6 |  |  | 13
 | 16 | 5 | 5 | 7 | 5 | 9 | 13 | 5 | 11 | 7 | 7 | 9 | 4 |  |  | 14
 | 17 | 1 | 11 | 6 | 10 | 12 | 7 | 11 | 13 | 9 | 13 | 8 | 4 |  |  | 15
 | 18 | 1 | 10 | 6 | 16 | 8 | 7 | 16 | 10 | 4 | 9 | 8 | 3 |  |  | 16
 | 19 | 8 | 6 | 8 | 7 | 6 | 14 | 10 | 8 | 4 | 9 | 10 | 4 |  |  | 17
 | 20 | 13 | 6 | 9 | 7 | 4 | 15 | 8 | 12 | 2 | 7 | 5 | 7 |  |  | 18
 | 21 | 7 | 3 | 12 | 5 | 14 | 14 | 10 | 7 | 4 | 6 | 5 | 1 |  |  | 19
 | 22 | 9 | 6 | 9 | 7 | 6 | 9 | 13 | 4 | 6 | 8 | 9 | 3 |  |  | 20
 | 23 | 10 | 5 | 9 | 8 | 15 | 5 | 6 | 6 | 9 | 1 | 8 | 1
 | 24 | 8 | 5 | 11 | 12 | 8 | 4 | 8 | 10 | 5 | 3 | 8 | 3
 | 25 | 6 | 7 | 13 | 12 | 10 | 9 | 1 | 8 | 9 | 4 | 4 | 4
 | 26 | 9 | 5 | 13 | 15 | 7 | 10 | 6 | 10 | 6 | 8 | 9 | 7
 | 27 | 6 | 3 | 7 | 13 | 6 | 8 | 5 | 12 | 8 | 9 | 4 | 6
 | 28 | 6 | 2 | 6 | 9 | 7 | 9 | 11 | 12 | 5 | 9 | 4 | 2
 | 29 | 7 | 8 | 6 | 4 | 8 | 8 | 13 | 11 | 2 | 10 | 4 | 6
 | 30 | 4 |  | 7 | 7 | 5 | 14 | 11 | 10 | 4 | 6 | 3 | 4
 | 31 | 8 |  | 12 |  | 4 |  | 9 | 8 |  | 6 |  | 5
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Carpentry

CONSTRUCTION TECHNOLOGY
Diploma - Construction Carpenter
Student Name:
ID #
General Education | Semester | Grade
___ Area I Writing/Accessing Information, Oral Communication,
Heritate, Humanities or Foreign Language (3)
___ Area II ___Social /Behavioral Science, Natural or Appllied Science
or Mathematics
___ Area III ___ CIT 105 (3) [NAME]  to Computers OR ___ IC3 Computer Literacy Exam
Technical Core
___ BRX 220 (3) Blueprint Reading for Construction
___ CAR 126 (3) Introduction to Construction Carpentry
___ CAR 127 (1) Introduction to Construction Carpentry Lab
___ CAR 140 (3) Site Layout & Foundations
___ CAR 141 (2) Site Layout & Foundations Lab
___ CAR 190 (3) Light Framing I
___ CAR 191 (2) Light Framing I Lab
___ CAR 196 (3) Light Framing II
___ CAR 197 (2) Light Framing II Lab
___ CAR 200 (3) Light Framing III
___ CAR 201 (2) Light Framing III Lab
___ CAR 298 (2) Practicum
OR ___ CAR 299 (2) Cooperative Education Program
___ ISX 100 (3) Industrial Safety
Technical Electives - 10 credits
___ BRX 120 (3) Basic Blueprint Reading
___ CAR 150 (3) Construction Formwork
___ CAR 151 (2) Construction Formwork Lab
___ CAR 190 (1-6) Special Topics in Construction
___ CAR 240 (3) Light Framing IV
___ CAR 241 (2) Light Framing IV Lab
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Competitive Ana

 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  |  |  | Per HC | New HC | Adj Comp |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  |  |  |  | Compensation | 0
 | Analysts & Associates | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services |  |  |  |  |  |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME]
ENARENT | Rent |  |  |  |  |  |  | Admins | 48000 | 1
ENATECH | Technology |  |  |  |  |  |  | Staff | 49200 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Analysts | 57600 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Associate | 72000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Specialist | 62400 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Sr Specialst | 74400 | 2
 |  |  |  |  |  |  |  | Managers | 90000 | 1
 | Headcount |  |  | 28 |  |  |  | Directors | 120000 | 1
 |  |  |  |  |  |  |  | General Counsel Asst | 178800 | 0
 | Analysts & Associate Headcount |  |  | 0 | 0 |  |  | Vice President | 216000 | 0
 |  |  |  |  |  |  |  | [NAME] | 312000
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 | Outside Services | 1140923 |  |  |  | Total Misc Exp |  | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 159569d1338752593-lookup-problem-lookup-example
Sheet: Sheet1

 | data source 1 | data source 2 | Lookup | Equal?
1 | CHEYEN~2.pdf | CHEYEN~2.pdf
2 | CHEYEN~3.pdf | CHEYEN~3.pdf
3 | CHEYEN~4.pdf | CHEYEN~4.pdf
4 | CHEYEN4.pdf | CHEYEN4.pdf
Spreadsheet: c6c92bf5-d9b9-4165-94f2-3a7d401374e3
Sheet: PAG 14 - Table 2

LAS CSD&Nanc |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | YTD10 | Scope |  |  | YTD11 | Reported | Organic
Volume ('000 hl) | 12887.494 | 0 | 0 | 72.03599999999642 | 12959.53 | 0.005589604930174685 | 0.005589604930174664
Net revenue | 1008.622 | 0 | -122.3453146441124 | 300.9063146441124 | 1187.183 | 0.1770346076131595 | 0.2983340782216851
Net revenue/hl | 78.26362518578087 | 0 | -9.440567261630042 | 22.78389078463725 | 91.60694870878807 | 0.1704920196493971 | 0.2911172429152526
[NAME] | -619.8328562351073 | 0 | 75.54613608271393 | -184.7929998476065 | -729.07972 | 0.1762521342099594 | 0.2981335984188503
[NAME]/hl | -48.09568533922167 | 0 | 5.829388572171516 | -13.99189469514022 | -56.25819146219037 | 0.1697138956519297 | 0.2909178774864019
Gross profit | 388.7891437648926 | 0 | -46.79917856139843 | 116.1133147965059 | 458.10328 | 0.1782820774363567 | 0.2986536961194616
Gross margin | 0.3854656588542513 | 0 | 0 | 0 | 0.3858741912577927 | 10 | 10
SG&A excl. deprec.&amort. | -217.29 | 0 | 24.58308977613029 | -53.48608977613033 | -246.193 | 0.1330157853559759 | 0.2461507192053493
SG&A deprec.&amort. | -30.584 | 0 | 3.361259712781631 | -3.76025971278163 | -30.983 | 0.01304603714360431 | 0.1229485911843327
SG&A total | -247.874 | 0 | 27.944349488912 | -57.24634948891196 | -277.176 | 0.1182132857822924 | 0.2309493915816583
Other operating income/expenses | 0.009853506768045417 | 0 | -0.594935706362675 | 6.867400228367202 | 6.282318028772573 | nm | nm
Normalized EBIT | 140.9249972716607 | 0 | -19.44976477884912 | 65.73436553596115 | 187.2095980287726 | 0.3284342852807676 | 0.4664492943664581
Normalized EBIT margin | 0.1397203285984845 | 0 | 0 | 0 | 0.1576922833537649 | 180 | 180
Normalized EBITDA | 202.4319972716608 | 0 | -25.9110111000017 | 70.85561185711347 | 247.3765980287726 | 0.2220232046458386 | 0.3500217989848031
Normalized EBITDA margin | 0.2007015485203186 | 0 | 0 | 0 | 0.208372759741988 | 80 | 80
Spreadsheet: richard_ring__31563__SMALLC&I2001
Sheet: APR

IN HOUSE REPORTING
[NAME] | 2001-04-01 00:00:00
[NAME] | 2001-04-30 00:00:00
Prepared By: | [NAME]  [PHONE] | 713 . 632. 8553
Clean Choice 20*
XNL9666802 | 4/2/01 4:18:14 PM | 5N6939 | A  1 | Linda & Chris  Craiker | 2000121700 | 3/28/01 | 1763
GJR5552004 | 4/10/01 4:41:42 PM | 56T256 | A  1 P | [NAME] | 2000128239 | 4/6/01 | 1557
 |  |  |  |  |  | 2
Clean Choice 50
Clean Choice 100*
QJQ6059504 | 4/23/01 5:31:14 PM | 8B8006 | A  1 | [NAME] | 2000591628 | 4/18/01 | 1049
PVP3829300 | 4/23/01 5:31:14 PM | B45322 | A  1 | [NAME] | 2000591724 | 4/17/01 | 575
KHM5342401 | 4/13/01 2:48:28 PM | 5701J6 | A  1 | Diane L Cross | 2000592931 | 4/10/01 | 541
SNL6983001 | 4/23/01 5:31:14 PM | 99490T | A  1 P | [NAME] | 2000459025 | 4/20/01 | 2667
CRN3855302 | 4/5/01 2:53:10 PM | 87043T | A  1 P | [NAME] | 2000592464 | 4/3/01 | 266
 |  |  |  |  |  | 5
Spreadsheet: 727493d1617908058-creating-a-vlookup-formule-with-two-search-criteria-test_ex
Sheet: Feuil1

ISOCODE | TIME_PERIOD | CPI
AR | 2020-12-01 00:00:00 | 102
AR | 2020-12-02 00:00:00 | 99.2
AR | 2019-11-02 00:00:00 | 95
AR | 2019-10-02 00:00:00 | 94
AR | 2019-12-02 00:00:00 | 93
AR | 2020-01-02 00:00:00 | 102
AR | 2020-02-02 00:00:00 | 55
AR | 2020-03-02 00:00:00 | 77
AR | 2020-04-02 00:00:00 | 88
AR | 2020-05-02 00:00:00 | 45
AR | 2020-06-02 00:00:00 | 75
BE | 2020-12-01 00:00:00 | 15
BE | 2020-12-02 00:00:00 | 42
BE | 2019-11-02 00:00:00 | 201
BE | 2019-10-02 00:00:00 | 520
BE | 2019-12-02 00:00:00 | 452
BE | 2020-01-02 00:00:00 | 47
BE | 2020-02-02 00:00:00 | 85
BE | 2020-03-02 00:00:00 | 99
BE | 2020-04-02 00:00:00 | 99
BE | 2020-05-02 00:00:00 | 96
BE | 2020-06-02 00:00:00 | 63
IS | 2020-12-01 00:00:00 | 59
IS | 2020-12-02 00:00:00 | 85
IS | 2019-11-02 00:00:00 | 74
IS | 2019-10-02 00:00:00 | 85
IS | 2019-12-02 00:00:00 | 95
IS | 2020-01-02 00:00:00 | 55
IS | 2020-02-02 00:00:00 | 88
IS | 2020-03-02 00:00:00 | 87
IS | 2020-04-02 00:00:00 | 89
IS | 2020-05-02 00:00:00 | 99
IS | 2020-06-02 00:00:00 | 105
IS | 2020-07-02 00:00:00 | 111
IS | 2020-08-02 00:00:00 | 104
IS | 2020-09-02 00:00:00 | 99
IS | 2020-10-02 00:00:00 | 99
IS | 2020-11-02 00:00:00 | 106
CN | 2020-12-01 00:00:00 | 99
CN | 2020-12-02 00:00:00 | 55
CN | 2019-11-02 00:00:00 | 44
CN | 2019-10-02 00:00:00 | 88
CN | 2019-12-02 00:00:00 | 102
CN | 2020-01-02 00:00:00 | 99.2
CN | 2020-02-02 00:00:00 | 95
CN | 2020-03-02 00:00:00 | 94
CN | 2020-04-02 00:00:00 | 93
CN | 2020-05-02 00:00:00 | 102
CN | 2020-06-02 00:00:00 | 55
CN | 2020-07-02 00:00:00 | 77
CN | 2020-08-02 00:00:00 | 88
CN | 2020-09-02 00:00:00 | 45
CN | 2020-10-02 00:00:00 | 75
CN | 2020-11-02 00:00:00 | 15
FR | 2020-12-01 00:00:00 | 42
FR | 2020-12-02 00:00:00 | 201
FR | 2019-11-02 00:00:00 | 520
FR | 2019-10-02 00:00:00 | 452
FR | 2019-12-02 00:00:00 | 47
FR | 2020-01-02 00:00:00 | 85
FR | 2020-02-02 00:00:00 | 99
FR | 2020-03-02 00:00:00 | 99
FR | 2020-04-02 00:00:00 | 96
FR | 2020-05-02 00:00:00 | 63
FR | 2020-06-02 00:00:00 | 59
FR | 2020-07-02 00:00:00 | 85
FR | 2020-08-02 00:00:00 | 74
FR | 2020-09-02 00:00:00 | 85
FR | 2020-10-02 00:00:00 | 95
FR | 2020-11-02 00:00:00 | 55
AS | 2020-12-01 00:00:00 | 88
AS | 2020-12-02 00:00:00 | 87
AS | 2019-11-02 00:00:00 | 89
AS | 2019-10-02 00:00:00 | 99
AS | 2019-12-02 00:00:00 | 105
AS | 2020-01-02 00:00:00 | 111
AS | 2020-02-02 00:00:00 | 104
AS | 2020-03-02 00:00:00 | 99
AS | 2020-04-02 00:00:00 | 99
AS | 2020-05-02 00:00:00 | 106
AS | 2020-06-02 00:00:00 | 99
AS | 2020-07-02 00:00:00 | 55
AS | 2020-08-02 00:00:00 | 44
AS | 2020-09-02 00:00:00 | 88
AS | 2020-10-02 00:00:00 | 45
AS | 2020-11-02 00:00:00 | 88