tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 796630d1663408935-xlookup-with-multiple-criteria-options-example-workbook
Sheet: Results

Country | Guests | Head of State
Oman |  | [NAME]
Denmark |  | Margrethe II
Japan |  | [NAME]
[NAME] |  | [NAME]
Bahrain |  | Sheikh [NAME] ibn Isa Al Khalifah
Andorra |  | Archbishop [NAME] Vives Sicília
Monaco |  | [NAME]
Bhutan |  | [NAME]
Netherlands
Spreadsheet: 176561d1345934770-tidy-up-printed-invoice-factuur_excel-forum
Sheet: Print_Factuur

as the data in klant table
available
Factuurnummer: |  | 1207002
Debiteurnummer:
Omschrijving |  |  |  |  |  |  |  | BTW |  | Bedrag
 |  |  |  |  |  |  |  | Subtotaal | €
 |  |  |  |  |  |  |  | BTW | €
Spreadsheet: 732490d1620991872-sum-between-two-dates-costs-in-row-example
Sheet: Sheet3

Item | Date 1 | Date 2 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 |  | Total Spend between dates
Item 1 | 2015-04-01 00:00:00 | 2015-09-01 00:00:00 | 532206 | 0 | 41490.5 | 112820 | 95853 | 110500 | 65000 | 121535 | 65885 | 732240 | 330595 | -183862
Item 2 | 2015-05-01 00:00:00 | 2015-11-01 00:00:00 | 0 | 0 | 24209.29999999981 | 0 | 0 | 0 | 5227 | 93428 | 38812 | 54892 | 22458 | 62674
Item 3 | 2015-05-01 00:00:00 | 2015-10-01 00:00:00 | 0 | 0 | 76651.96999999997 | 0 | 0 | 0 | 52956 | 5970 | 6914 | 8321 | -107563 | 33042
Item 4 | 2015-06-01 00:00:00 | 2016-01-01 00:00:00 | 0 | 0 | 10065 | 18162 | 21735 | 22320 | 26384 | 37654 | 11927 | 17405 | -1542 | 32149
Item 5 | 2015-06-01 00:00:00 | 2015-09-01 00:00:00 | 0 | 0 | 26185 | 34074 | 76973 | 29214 | 20839 | 70487 | -52001 | 33398 | 35752 | 22941
Item 6 | 2015-06-01 00:00:00 | 2015-10-01 00:00:00 | 0 | 0 | 41633 | 39567 | 82420 | 59893 | -35581 | 58185 | 218575 | -167079 | 19930 | 62712
Spreadsheet: 02a2dfb5-ce1f-4bb3-8973-9b471cb0354f
Sheet: Sheet1

Date | GMT Start | GMT End | Dubai Start | Dubai End | Notes
2011-02-21 00:00:00 | 10:00:00 | 14:00:00 | 14:00:00 | 18:00:00 | R1 x 2
 | 15:00:00 | 19:00:00 | 19:00:00 | 23:00:00 | R1 x 2
2011-02-22 00:00:00 | 10:00:00 | 14:00:00 | 14:00:00 | 18:00:00 | R1 x 2
 | 15:00:00 | 19:00:00 | 19:00:00 | 23:00:00 | R1 x 2
2011-02-23 00:00:00 | 10:00:00 | 14:00:00 | 14:00:00 | 18:00:00 | R2 x 2
 | 15:00:00 | 19:00:00 | 19:00:00 | 23:00:00 | R2 x 2
2011-02-24 00:00:00 | 10:00:00 | 14:00:00 | 14:00:00 | 18:00:00 | QF 1 & 2
 | 15:00:00 | 19:00:00 | 19:00:00 | 23:00:00 | QF 3 & 4
2011-02-25 00:00:00 | 10:00:00 | 12:30:00 | 14:00:00 | 16:30:00 | SF 1
 | 15:00:00 | 17:30:00 | 19:00:00 | 21:30:00 | SF 2
2011-02-26 00:00:00 | 15:00:00 | 18:00:00 | 19:00:00 | 22:00:00 | Final
Spreadsheet: 212347d1360098901-excel-word-turning-months-into-00-how-do-i-fix-this-monthes-into-00-test1
Sheet: 2013 Gift Ack001

AF_AddressName | AF_Organization | AF_Address1 | AF_Address2 | AF_City | AF_State | AF_Zip | AF_Salutation1 | [NAME] | G_Amount | G_DateRecvd | G_Description
[NAME] |  | 5555 South Road |  | Somewhere | IL | 88888 | Mr. and Mrs. [NAME] | code here | 25 | 00 8, 2013 | name
 | ABC Corp. | 1111 North Drive |  | Anywhere | CA | 99999 | Friends | code here | 45 | 00 8, 2013
 | Sparky's Dogs | 2222 Downtown Ave. |  | Here Town | FL | 77777 | Friends | code here | 450 | 00 8, 2013
Ms. [NAME] |  | 3333 Hero Blvd. | Suite 1 | Save Our Town | NY | 66666 | Ms. [NAME] | code here | 20 | 00 8, 2013 | name
Spreadsheet: 758179d1638722436-index-formulas-to-rearrange-from-vertical-to-horizontal-tf16400504_win32
Sheet: Empty Recipe

 |  | Empty Recipe |  |  | Course Type | Recipe Index
 |  | Amount | Measurement | Ingredient | Directions | Preparation Time
 |  |  |  |  | Copy this worksheet to enter a new recipe. Rename the tab, the same name from the Recipe Index worksheet.   Enter recipe directions in this cell. [NAME], measurements and amounts in cells at left. Press ALT+Enter to add new paragraphs in this cell.  Enter Preparation Time, [NAME] and Yield (Servings) in cells at right. Change the stock photo in column B to a photo of your recipe, then enter [NAME], Recipe Tags and Comments in cells underneath.   Recipe tags help you search for a recipe with a specific quality in the Recipe Index worksheet.   Select a recipe on the Grocery List worksheet to view the ingredients you may need to buy. | Enter preparation time in this cell
 | Calories
 | Enter calories for the recipe in this cell |  |  |  |  | Cook Time
 |  |  |  |  |  | Enter cook time in this cell
 | Recipe Tags
 | Tag 1, Tag 2, etc.
 |  |  |  |  |  | Yield (Servings)
 | Comments |  |  |  |  | Enter Yield (Servings) in this cell
 | Do not delete this recipe worksheet
Spreadsheet: 677113d1589200550-formula-to-linearly-split-months-duration-to-financial-years-project-months-formula
Sheet: Sheet1

 |  |  |  | 2017-04-01 00:00:00 | 2018-04-01 00:00:00 | 2019-04-01 00:00:00 | 2020-04-01 00:00:00
 |  |  |  | 2018-03-31 00:00:00 | 2019-03-31 00:00:00 | 2020-03-31 00:00:00 | 2021-03-31 00:00:00
Proj ID | Proj Start | Proj End | Duration Months | 17-18 | 18-19 | 19-20 | 20-21
1 | 2020-01-01 00:00:00 | 2020-04-01 00:00:00
2 | 2018-04-01 00:00:00 | 2020-09-30 00:00:00
3 | 2017-12-01 00:00:00 | 2019-06-01 00:00:00
4 | 2020-10-01 00:00:00 | 2020-12-01 00:00:00
5 | 2019-12-01 00:00:00 | 2020-10-01 00:00:00
Spreadsheet: 857880d1706738985-help-with-sumifs-kansas-scheduler-v2-01312024
Sheet: Kitting Schedule

[NAME] from date below↓ | ↓Minimum # of Kits↓ | DO NOT EDIT IN THIS REPORT
2024-01-29 00:00:00 | 25
Client | Job # | # of Stores | # of Pieces | Ship Date | Notes
 | 244184 | 75 | 75 | 2024-01-30 00:00:00 | [NAME]
TMOB 244313 [30] | 244313 | 300 | 300 | 2024-01-30 00:00:00 | [NAME]
CKCC | 44693 | 325 | 5772 | 2024-01-30 00:00:00 | Production Complete
BASS 243162 [30] | 243162 | 154 | 720 | 2024-01-30 00:00:00 | [NAME]
SULO 244229-1 [31] | 244229 | 25 | 1 | 2024-01-31 00:00:00 | [NAME]
CABR 243718 KITTING | 243718 | 100 | 1300 | 2024-01-31 00:00:00 | [NAME]
CASY | 97196 | INV | 426 | 2024-01-31 00:00:00 | [NAME]
CKCC | 44822 | INV | 6 | 2024-01-31 00:00:00 | Uninstall
CKGC | 59850 | INV | 0 | 2024-01-31 00:00:00 | New GTR recieved 1/31
DELE | 3502 | INV | 51 | 2024-01-31 00:00:00 | 0
GGPM | 21454 | INV | 6 | 2024-01-31 00:00:00 | 0
KSCO 244316 1-3 [1] | 244316 | 136 | 718 | 2024-02-01 00:00:00 | Shipment Ready
GGPM | 21262 | 141 | 6021 | 2024-02-01 00:00:00 | Production Complete
SURL | 907 | ? | ? | 2024-02-02 00:00:00 | Production Complete
CCOTO 243556 [29] | 243556 | 100 | 200 | 2024-02-06 00:00:00 | [NAME]
HHGJ RUSH Inquiry HSI Phase 1 | 0 | 1956 | 457 | 2024-02-06 00:00:00 | PLACEMARKER (457pcs- Samba)
Blast Media 244317 | 244317 | ? | 179 | 2024-02-06 00:00:00 | Open
BASS 244460 [7] | 244460 | 155 | 155 | 2024-02-07 00:00:00 | In Fulfillment
[NAME] | 243207 | 155 | 2430 | 2024-02-09 00:00:00 | Cardstock (12 & 24pt) + Bannersoft
CALE 244483 [9] | 244483 | 45 | 44 | 2024-02-09 00:00:00 | 0
[NAME] | 243220 | 155 | 2738 | 2024-02-09 00:00:00 | Bannersoft + Cardstock (OPEN)
North American Corporation | 244163 | 422 | 422 | 2024-02-13 00:00:00 | In Production
TMOB 244306-1-5 [14] | 244306 | 1956 | 9700 | 2024-02-14 00:00:00 | Open
Spreadsheet: 730503d1619722243-substitute-text-in-a-string-if-it-matches-a-value-in-a-table-example-13-
Sheet: Sheet1

Folder,User,Permissions
\\filesrv\share1\folder2,domainA\Fjones,ReadAndExecute, [NAME]
\\filesrv\share1\folder8,domainA\Rjones,ReadAndExecute, [NAME]
\\filesrv\share1\folder2,domainA\Fjones,ReadAndExecute, [NAME]
\\filesrv\share2\folder12,domainA\Asmith,FullControl
\\filesrv\share2\folder1,domainA\ASmith,FullControl
\\filesrv\share2\folder10,domainA\Rjones,FullControl
\\filesrv\share11\folder99,domainA\Fjones,FullControl
Spreadsheet: mary_fischer__25364__roi_version_2_a
Sheet: IT Survey

 | I/T Survey | Response |  |  | Y
 | A) Please select the statement that best describes the customer's EAM infrastructure | 1 |  | 1
 |  |  |  | 2
 | 1) No EAM system at present |  |  | 3 | 2
 | 2) EAM installed as a standalone or client-server application running Citrix or other for WAN performance |  |  | 4 | 3
 | 3) EAM system installed as enterprise wide web-architected application |  |  |  | 4
 | B) Please select the statement that best describes the customer's EAM deployment | 2 |  | 1
 |  |  |  | 2
 | 1) Hosted by a third party provider |  |  | 3 | 2
 | 2) Self-hosted |  |  | 4 | 3
 | C) If running Citrix or other WAN performance product solely for EAM, amount of current support payment?  If Citrix in use for other products, enter $0 | 0.01 | days
 | D) Number of potential EAM users? | 90 | days
 | E) Number of system administrators supporting the current EAM application?  Include times spent at user desktops applying upgrades, patches, etc.  Use partial numbers to reflect time split (e.g., 0.5 sys admin = 1 sys admin spending 50% of time on EAM application) | 0.9 | days
 | F) Avg. annual salary (fully loaded) of system administrator? | 100000 | days
 | G) Number of Oracle DBAs supporting the current EAM database?  Use partial numbers to reflect time split (e.g., 0.5 DBA = 1 DBA spending 50% of time on EAM database) | 0.3 | days
 | H) Avg. annual salary (fully loaded) of DBA? | 200000 | days
 | I) Please select the statement that best describes the EAM integration with other corporate applications (e.g., Oracle   Financials, SAP) | 1 | days
 | 1) No integration, real-time or other, with any applications |  |  | 3 | 2
 | 2) Some batch or flat file integration with other corporate applications |  |  | 4 | 3
 | 3) Real-time interfaces exist between EAM and other corporate applications |  |  |  | 4
 | J) Estimate the number of people performing double data entry due to lack of EAM integration | 18 | days
 | K) Estimate the % of their time spent performing double data entry tasks due to lack of EAM integration | 0.25 | days
 |  | \
 | L) Average annual salary (fully loaded) of data entry personnel? | 72800 | days
Spreadsheet: 732228d1620829825-compare-two-lists-and-generate-a-new-list-with-what-is-different-from-the-first-list-excel-file-help-v2
Sheet: Department-VAC Code audit

Master [NAME] |  |  |  |  | Database List Pasted |  |  |  |  | [NAME]
Name | ID | Position | Comp Rate |  | Name | ID | Position | Comp Rate |  | Name | ID | Position | Comp Rate
[NAME] | 1628807 | 10305275 | 25.17 |  | [NAME] | 1628807 | 20209586 | 25.47 |  | [NAME]
[NAME] | 1628813 | 10305276 | 25.17 |  | [NAME] | 1628813 | 10305275 | 25.17 |  | [NAME]
[NAME] | 1628824 | 20209586 | 25.27 |  | [NAME] | 1628824 | 20209586 | 25.47 |  | [NAME]
[NAME] | 1628826 | 20209586 | 25.47 |  | [NAME] | 1628826 | 20209586 | 25.47 |  | [NAME]
[NAME] | 1628830 | 20209586 | 25.37 |  | [NAME] | 1628830 | 20209586 | 25.37 |  | [NAME]
[NAME] | 1628870 | 20209586 | 25.37 |  | [NAME] | 1628870 | 20209586 | 25.37 |  | [NAME]
[NAME] | 1628890 | 10305275 | 25.17 |  | [NAME] | 1628890 | 10305275 | 25.17 |  | [NAME]
[NAME] | 1628898 | 10305276 | 25.17 |  | [NAME] | 1628898 | 10305276 | 25.17 |  | [NAME]
[NAME] | 1628906 | 10305276 | 25.17 |  | [NAME] | 1628906 | 10305276 | 25.17 |  | [NAME]
[NAME] 10 | 1628907 | 10305276 | 25.17 |  | [NAME] 10 | 1628907 | 10305276 | 25.17 |  | [NAME] 10
[NAME] | 1628911 | 10305276 | 25.27 |  | [NAME] | 1628911 | 10305276 | 25.27 |  | [NAME]
[NAME] | 1628918 | 10305276 | 25.47 |  | [NAME] | 1628918 | 10305276 | 25.47 |  | [NAME]
[NAME] | 1628920 | 20209586 | 25.37 |  | [NAME] | 1628920 | 20209586 | 25.37 |  | [NAME]
[NAME] | 1628930 | 10305276 | 25.17 |  | [NAME] | 1628930 | 10305276 | 25.17 |  | [NAME]
[NAME] 15 | 1628933 | 10305276 | 25.27 |  | [NAME] 15 | 1628933 | 10305276 | 25.27 |  | [NAME] 15
[NAME] | 1628946 | 10305275 | 25.17 |  | [NAME] | 1628946 | 10305275 | 25.17 |  | [NAME]
[NAME] | 1628959 | 20209586 | 25.37 |  | [NAME] | 1628959 | 20209586 | 25.37 |  | [NAME]
[NAME] | 1628973 | 10305318 | 24.4 |  | [NAME] | 1628973 | 10305318 | 24.4 |  | [NAME]
[NAME] | 1628975 | 20209586 | 25.62 |  | [NAME] | 1628975 | 20209586 | 25.62 |  | [NAME]
[NAME] 20 | 1628978 | 20209586 | 25.47 |  | [NAME] 20 | 1628978 | 20209586 | 25.47 |  | [NAME] 20
[NAME] 21 | 1628991 | 10305275 | 25.47 |  | [NAME] 21 | 1628991 | 10305275 | 25.47 |  | [NAME] 21
[NAME] | 1628993 | 10305318 | 24.3 |  | [NAME] | 1628993 | 10305318 | 24.3 |  | [NAME]
[NAME] 23 | 1628994 | 20209586 | 25.37 |  | [NAME] 23 | 1628994 | 20209586 | 25.37 |  | [NAME] 23
[NAME] | 1628996 | 10305276 | 25.17 |  | [NAME] | 1628996 | 10305276 | 25.17 |  | [NAME]
[NAME] | 1629016 | 20209586 | 25.37 |  | [NAME] | 1629016 | 20209586 | 25.37 |  | [NAME]
[NAME] 26 | 1629018 | 10305275 | 25.27 |  | [NAME] 26 | 1629018 | 10305275 | 25.27 |  | [NAME] 26
Spreadsheet: john_griffith__16168__1_28_02GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HU G2 | 57 | 70 | 120 | 36.3 | 53.3 | 1.61 | 2002-01-25 15:08:00
 | [NAME] | 59 | 620 | 720 | 47.7 | 55.4 | 1.91 | 2002-01-28 14:15:00
 | [NAME] | 66 | 940 | 1040 | 45.9 | 50.8 | 2.01 | 2002-01-28 14:15:00
 | [NAME] | 66 | 1150 | 1250 | 45.2 | 49.2 | 1.96 | 2002-01-28 14:15:00
 | [NAME] | 66 | 1280 | 1380 | 43 | 46.4 | 1.85 | 2002-01-28 14:15:00
 | HU N2 | 66 | 1350 | 1450 | 41 | 44.1 | 1.77 | 2002-01-28 14:15:00
 | [NAME] | 65 | 1375 | 1500 | 38.7 | 42.3 | 1.66 | 2002-01-28 14:15:00
 | HU U2 | 63 | 1375 | 1500 | 37 | 40.4 | 1.53 | 2002-01-28 14:15:00
 | [NAME] | 60 | 1400 | 1525 | 37.2 | 40.6 | 1.47 | 2002-01-28 14:15:00
 | [NAME] | 59 | 1400 | 1550 | 35.7 | 39.5 | 1.39 | 2002-01-28 14:15:00
 | [NAME] |  |  |  | 35.4 | 40.3 | 1.4 | 2001-11-29 15:00:00
 | HU F3 |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | HU H3
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]
Spreadsheet: michelle_lokay__26570__imbalsumm0012
Sheet: CIG

 | Tumbleweed
 | 9198
Day | Measured | Scheduled
1 | 17996 | 25998
2 | 27242 | 40000
3 | 30344 | 39999
4 | 29336 | 38306
5 | 23080
6 | 31559 | 38450
7 | 30721 | 31076
8 | 25834 | 26000
9 | 26005 | 26000
10 | 25879 | 26000
11 | 27732 | 26000
12 | 33840 | 26000
13 | 28685 | 29986
14 | 30565 | 35963
15 | 24896 | 25999
16 | 24310 | 26000
17 | 24306 | 26000
18 | 24583 | 26000
19 | 24273 | 31000
20 | 24703 | 25999
21 | 24285 | 30999
22 | 23418 | 26000
23 | 25841 | 26000
24 | 25222 | 26000
25 | 25295 | 26000
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  | -557795.86
2000-12-25 00:00:00
Spreadsheet: 35654d1233248638-accruals-formula-help-ptotest-wild-guess
Sheet: Sheet1

 |  | 2009-01-01 00:00:00 |  |  |  |  |  | FEB |  |  |  | [NAME]
 |  | Bal. Forward | Accrued | Used | Remaining |  |  | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining
Employee | Hire Date
[NAME] | 2007-12-15 00:00:00 |  | 0.83 |  | 0.83 |  |  |  |  |  | 0 |  |  |  | 0
[NAME] | 2006-06-17 00:00:00 |  | 0.83 |  | 0.83 |  |  |  |  |  | 0 |  |  |  | 0
[NAME] | 2005-03-01 00:00:00 |  | 1.25 |  | 1.25 |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  | Manual Entry
 |  |  |  |  |  |  |  |  |  |  | Remaining Col.' should automate in 'Bal Forward Col.'
 |  |  |  |  |  |  |  |  |  |  | Remaining Col.' = sum [NAME]. Forward + Accrued - used
 |  | Hire Date' should trigger Accruals - based on
 | 80 hrs | 0-36 mo.   = .83 days |  | 0 | 0.83
 | 120 hrs | 37-60 mo. = 1.25 days |  | 37 | 1.25
 | 160 hrs | 61 +             = 1.67 days |  | 61 | 1.67
Spreadsheet: 792930d1661238242-want-to-make-simple-dynamic-dashboard-example-1-
Sheet: valid email

Sl no. | [NAME] | Valid
Spreadsheet: 823837d1680165332-before-and-after-tp-location-crossings-tp-location-03
Sheet: Sheet1

TP LIST (I Have This Data) |  |  | CROSSINGS  (I Have This Data) |  | CROSSINGS BEFORE AND AFTER TP REQUIRED ACCORDING TO TP CHAINAGE
TP's | Chainage |  | Type of  Crossing | Chainage | BEFORE TP | AFTER TP
TP0 | 0 |  | Pipeline | 263.89
TP1 | 4.49 |  | Drain | 265.88
TP2 | 7.75 |  | NH | 293.2
TP3 | 11.22 |  | Drain | 312.82
TP4 | 13.73 |  | BG | 498.36
TP5 | 16.05 |  | BT Road | 506.76
TP6 | 25.9
TP7 | 258.38
TP8 | 359.9
TP9 | 364.65
TP10 | 369.01
TP11 | 371.98
TP12 | 376.65
TP13 | 389.22
TP14 | 429.69
TP15 | 445.03
TP16 | 456.73
TP17 | 467.54
TP18 | 473.85
TP19 | 516.22
TP20 | 677.55
Spreadsheet: 181250d1347975808-compare-tables-in-excel-discounts
Sheet: Real Discounts

Phone Number | Discount ID
[PHONE] | 53457
[PHONE] | 55402
[PHONE] | 55467
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 91193
[PHONE] | 53457
[PHONE] | 56006
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 53457
[PHONE] | 56007
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 56202
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 53457
[PHONE] | 56006
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 53457
[PHONE] | 56007
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 53457
[PHONE] | 56004
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 53457
[PHONE] | 56004
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 51770
[PHONE] | 53457
[PHONE] | 56006
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 53457
[PHONE] | 56007
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 56006
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 53457
[PHONE] | 56007
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 56007
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 53457
[PHONE] | 56006
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 53457
[PHONE] | 56007
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 56007
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 56202
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 31244
[PHONE] | 31245
[PHONE] | 53457
[PHONE] | 54918
[PHONE] | 56007
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 56202
[PHONE] | 8728
[PHONE] | 8729
[PHONE] | 53457
[PHONE] | 56004
[PHONE] | 56013
[PHONE] | 56026
[PHONE] | 8728
[PHONE] | 8729
Spreadsheet: 806573d1669387475-using-large-in-xlookup-example
Sheet: Sheet1

 |  |  | 2 | 3 | 4 | 5
 | A | 33 | 28 | 99 | 73 | 94 |  | Letter: | B
 | B | 69 | 32 | 54 | 71 | 63 |  | Largest:
 | C | 26 | 58 | 90 | 90 | 38
 | D | 93 | 48 | 20 | 85 | 77
 | E | 96 | 83 | 13 | 77 | 98
Spreadsheet: 218804d1362585279-football-league-table-database
Sheet: Sumário - Tabela 2-4

[NAME]
Chealsea | 4 | 2 | Reading
West Ham | 3 | 0 | Fulham
Swansea | 2 | 2 | Sunderland
Tottenham | 1 | 1 | [NAME]
West Brom | 2 | 0 | Everton
Wiigan | 2 | 2 | Stoke City
Man City | 3 | 1 | QPR
Liverpool | 0 | 2 | Arsenal
Newcastle | 1 | 1 | [NAME]
Southampton | 2 | 3 | Man United
Spreadsheet: 6d6d5532-0306-4452-9fab-e5618d3ca92c
Sheet: SEG1

 | ADVANCED MICRO DEVICES, INC.
 | SELECTED CORPORATE DATA
 | (Millions except headcount)
 |  |  | Quarter Ended |  |  |  |  |  |  |  |  |  | Nine Months Ended
 |  |  |  | Sept. 25, |  |  | June 26, |  |  | Sept. 26, |  |  |  | Sept. 25, |  |  | Sept. 26,
 | Segment and Category Information |  |  | 2010 |  |  | 2010 |  |  | 2009 |  |  | 2010 |  |  | 2009
 | [NAME] (1)
 |  | Net revenue |  | 1226 |  |  | 1212 |  |  | 1082 |  |  |  | 3598 |  |  | 2950
 |  | Operating income (loss) |  | 164 |  |  | 128 |  |  | 82 |  |  |  | 438 |  |  | -19
 | Graphics (2)
 |  | Net revenue |  | 390 |  |  | 440 |  |  | 293 |  |  |  | 1239 |  |  | 746
 |  | Operating income (loss) |  | 1 |  |  | 33 |  |  | 2 |  |  |  | 81 |  |  | -15
 | All Other (3)
 |  | Net revenue |  | 2 |  |  | 1 |  |  | 21 |  |  |  | 8 |  |  | 61
 |  | Operating income (loss) |  | -37 |  |  | -36 |  |  | -49 |  |  |  | -84 |  |  | -214
 | Subtotal (excludes Foundry segment and Intersegment Eliminations)
 |  | Net revenue |  | 1618 |  |  | 1653 |  |  | 1396 |  |  |  | 4845 |  |  | 3757
 |  | Operating income (loss) |  | 128 |  |  | 125 |  |  | 35 |  |  |  | 435 |  |  | -248
 | Foundry (4)
 |  | Net revenue |  | 0 |  |  | 0 |  |  | 256 |  |  |  | 0 |  |  | 792
 |  | Operating income (loss) |  | 0 |  |  | 0 |  |  | -101 |  |  |  | 0 |  |  | -334
 | Intersegment Eliminations (5)
 |  | Net revenue |  | 0 |  |  | 0 |  |  | -256 |  |  |  | 0 |  |  | -792
 |  | Operating income (loss) |  | 0 |  |  | 0 |  |  | -11 |  |  |  | 0 |  |  | -42
 | Total AMD
 |  | Net revenue |  | 1618 |  |  | 1653 |  |  | 1396 |  |  |  | 4845 |  |  | 3757
 |  | Operating income (loss) |  | 128 |  |  | 125 |  |  | -77 |  |  |  | 435 |  |  | -624
 | Other Data
 | Depreciation and amortization
 | (excluding amortization of acquired intangible assets) |  |  | 79 |  |  | 83 |  |  | 265 |  |  |  | 244 |  |  | 792
 | Capital additions |  |  | 31 |  |  | 31 |  |  | 97 |  |  |  | 110 |  |  | 293
 | Headcount (excludes Foundry segment) |  |  | 11021 |  |  | 10649 |  |  | 10412 |  |  |  | 11021 |  |  | 10412
 | AMD non-GAAP comparison*
 |  | Depreciation and amortization
 |  | (excluding amortization of acquired intangible assets) |  | 79 |  |  | 83 |  |  | 96 |  |  |  | 244 |  |  | 303
 |  | Capital additions |  | 31 |  |  | 31 |  |  | 19 |  |  |  | 110 |  |  | 51
 |  | Adjusted EBITDA (6) |  | 245 |  |  | 244 |  |  | 169 |  |  |  | 790 |  |  | 245
 |  | Cash, cash equivalents and marketable securities (7) |  | 1726 |  |  | 1896 |  |  | 1536 |  |  |  | 1726 |  |  | 1536
 |  | Adjusted free cash flow (8) |  | 91 |  |  | 76 |  |  | N/A |  |  |  | 344 |  |  | N/A
 |  | Total assets (7) |  | 4595 |  |  | 4955 |  |  | 4376 |  |  |  | 4595 |  |  | 4376
 |  | Long-term debt and capital lease obligations(7) |  | 2188 |  |  | 2421 |  |  | 3541 |  |  |  | 2188 |  |  | 3541
 | * 2009 periods exclude Foundry segment and Intersegment Eliminations
 | See footnotes on the next page
Spreadsheet: 29575d1224661922-locking-formulas-master
Sheet: Shop Labour

 | Job No: | 0
 | Main Contractor | 0
 | Site | 0
 | Descripion | #N/A
Shop Labour
Date | Name | Description Of Works | Hours | Cost per/hr | Total Cost
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  |  | 35 | 0
 |  |  | Total Cost To Date |  | 0
Spreadsheet: 116195d1311669018-need-help-in-complicated-nested-function-to-change-arrangements-of-data-display-example-workbook
Sheet: Actual Data

INVOICE NO | 1226012546 | DATE | 2011-01-01 00:00:00
ABC | 5 | WASHED | F | 129 | $ | 25.8 | 1 | 103.2
CDE | 11 | NY/BLU | F | 49 | $ | 4.9 | 1 | 44.1
FGH | 0 | MTI | F | 25 | $ | 20 | 1 | 5
VISA  1223453464645767567  250.00  0.00 |  |  |  | STAFF A | STAFF B | STAFF C |  | 152.3
INVOICE NO | 1226012547 | DATE | 2011-01-01 00:00:00
[NAME] | 11 | NY/BLU | E | 49 | $ | 0 | -1 | -49
YYY | 12 | NY/BLU | S | 49 |  | 0 | 1 | 49
 |  |  |  | STAFF A | STAFF B | STAFF C |  | 0
INVOICE NO | 1226012548 | DATE | 2011-01-02 00:00:00
AAA | 5 | PEACH | S | 149 |  | 0 | 1 | 149
BBB | 6 | STING | S | 99 |  | 0 | 1 | 99
CCC | 4 | PK/YLW | S | 99 |  | 0 | 1 | 99
VISA  4384 2130 0243 9500  208.20  0.00 |  |  |  | STAFF A | STAFF B | STAFF C |  | 208.2