tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 469792d1468163505-help-with-a-vertical-search-request-test-document
Sheet: Check

 |  |  |  |  |  |  |  |  |  | niet aanwezig
 |  |  |  |  |  |  |  |  | Controle | adres | postcode | Meetdienst
Client A | regulier | 871685920001252455 | E | gv | 12345 | verstuurd | nee
 |  | 871685920001252455
 |  | 871685920001252455
 | Hello experts,
 | I have a problem and i hope you can help me with it.
 | I want to compare two sheets and when i run in to a code (column C in sheet 'check') that is also found in the sheet 'source' it should take the adress data from the source (column D and E ) and put it into column K and L in the 'check' sheet
 | however, it will give me a N/B error and i dont understand why
 | as you can see, i copied both cells (C8 from "check" and C5 from "source" into the blue highlighted area
 | i checked if they are equal (P16) and also verified if one is maybe formatted as a number and the other one isn't
 | simple conclusion, i don't know why it doesn't work and i am looking for an answer and a simple formula that can help me do what i want…
 | anybody that can help???
 | Thanks in advance,
Spreadsheet: 90420d1290148932-auto-filling-cells-based-on-drop-down-menu-selection-production-sheet
Sheet: DAY 1 DINNER

 |  |  | #1 |  |  |  | #2
 |  |  | Item Description |  |  |  | Item Description |  |  |  | Comments
 |  |  | REGULAR | Stuffed Catfish |  |  | REGULAR | [NAME] |  |  |  |  |  |  | [NAME]
 |  |  |  | [NAME] |  |  |  | Saltines (No-Salt-Top:NAS) |  |  |  |  |  |  | Ck SR Minnestrone Soup
 |  |  |  | [NAME] |  |  |  | Cottage Cheese-Fresh Fruit Plate W/ [NAME]
 |  |  |  | Dinner Roll |  |  |  | Fresh Fruit
 |  |  |  | Fresh Fruit Cup
 |  |  |  |  |  |  |  |  |  |  | Comments
 |  |  | CONST CARB | [NAME] |  |  | CONST CARB | Cottage Cheese-Fresh Fruit w/ [NAME] (4 Carb) |  |  |  |  |  |  | [NAME]
 |  |  |  | [NAME] (1.5 Carb) |  |  |  | Fresh Fruit Cup |  |  |  |  |  |  | Ck SR Minnestrone Soup
 |  |  |  | [NAME]
 |  |  |  | Dinner Roll  (1 Carb)
 |  |  |  | Fresh Fruit Cup
 |  |  |  |  |  |  |  |  |  |  | Comments
 |  |  | RENAL | [NAME] (2 oz) |  |  | RENAL | Cottage Cheese-Peach/Pears Plate W/ No-Salt Crackers |  |  |  |  |  |  | [NAME]
 |  |  |  | [NAME] |  |  |  | No Salt Crackers |  |  |  |  |  |  | Ck SR Minnestrone Soup
 |  |  |  | [NAME] |  |  |  | Fresh Fruit Cup
 |  |  |  | Dinner Roll
 |  |  |  | Pears
Spreadsheet: 65360d1266021349-organize-data-based-on-criteria-and-date-voucher-maintence
Sheet: V

Date | Account | Driver # | Pick-up | 1 Stop | 2 Stop | 3 Stop | 4 Stop | W/T | Toll | Dri Fare | D Total | Co Fare | Profit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V |  | V
2010-01-22 00:00:00 | 410 | 25 | 222 PICK UP | 333 [NAME] |  |  |  |  | 5.5 | 10
2010-01-22 00:00:00 | 456 | 321 | 222 ADDRESS | 333 [NAME] | 3RD STOP | 4TH STOP |  |  |  | 12
Spreadsheet: 821025d1678400042-formula-required-for-when-duplicate-data-is-located-add-that-data-into-a-separate-column-excel-forum-example
Sheet: Sheet1

Client Name | Email address | How many times an email appears as a duplicate in Column B |  | Client Name 1 | Client Name 2 | Client Name 3
Client A | [EMAIL]
Client B | [EMAIL]
Client C | [EMAIL]
Client D | [EMAIL]
Client E | [EMAIL]
Client F | [EMAIL]
Client G | [EMAIL]
Client H | [EMAIL]
Client I | [EMAIL]
Client J | [EMAIL]
Client K | [EMAIL]
Help requested:  When clients in column A have a unique email address enter that in Column E.  When clients in column A share an email address, add the duplicate client names to eg column F & G.
The end result = Client names from Columns E, F & G will be referenced in an Outlook mail merge which only goes to one email address
Spreadsheet: 96113d1295552400-excel-2007-using-if-command-and-vlookup-function-book1
Sheet: Sheet1

Keyword ID | Keyword | [NAME] | Match | Destination URL | [NAME] | Ad Group Name | Ad Group ID | Revision ID
1144770491 | vacation condos |  | Broad |  | On | 2nd List | 758121192 | 0
1144770492 | vacation condos by owner |  | Broad |  | On | 2nd List | 758121192 | 0
1144770493 | vacation condos rentals |  | Broad |  | On | 2nd List | 758121192 | 0
1144770494 | vacation cottage rental |  | Broad |  | On | 2nd List | 758121192 | 0
1144770495 | vacation cottage rentals |  | Broad |  | On | 2nd List | 758121192 | 0
1144770496 | vacation countdown |  | Broad |  | On | 2nd List | 758121192 | 0
This is the original sheet that has thousands of rows.
Sheet 2 contains a list that need changing from 'On' to Off' in column F
Spreadsheet: darrell_schoolcraft__7776__imbalsumm0106
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 68110 | 67388
2 | 52575 | 52388
3 | 52618 | 52388
4 | 60235 | 59388
5 | 52944 | 52388
6 | 60647 | 62388
7 | 63117 | 62388
8 | 72994 | 72388
9 | 134234 | 133583
10 | 132100 | 133583
11 | 134813 | 133583
12 | 144825 | 137693
13 | 149457 | 148910
14 | 128254 | 127976
15 | 117231 | 116363
16 | 107320 | 106674
17 | 97555 | 96821
18 | 106400 | 105865
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  | 93484
2001-06-18 00:00:00
Spreadsheet: 164155d1340662396-excel-2007-compare-column-and-rearrange-row-data-accordingly-copy-of-row_matching123c
Sheet: Sheet3

Col A | Name1 | Amt2 | [NAME]
a22 | Aman | 1234 | Aman
a1 | [NAME] | 100 | [NAME]
a4 | Fabio | 755 | Fabio
a3 | Karim | 121 | Karim
a6 | Phantom
aa6 | Rafael | 123 | Rafael
aa2 | Ramos | 123 | Ramos
a5 | [NAME] | 5555 | [NAME]
 |  | 500 | Eshan
Spreadsheet: 36982d1234922545-cutting-down-duplicates-in-a-list-and-adding-numbers-bags-with-marbles
Sheet: Sheet1

LIST I HAVE |  |  | LIST I WANT
[NAME] | Marbles |  | Bag Type | Total Marbles in Bag Type
S | 1 |  | S | 7
M | 2 |  | M | 14
L | 3 |  | L | 15
S | 4
M | 4
L | 3
S | 2
M | 8
L | 9
Spreadsheet: 875119d1721683403-display-name-not-code-from-a-cell-into-another-cell-tricks420-example-tms
Sheet: Total

 |  |  |  |  |  |  |  | I would like this box to say "Chocolate"
 |  |  |  |  |  |  | 1 | I would like this box to say "Chocolate" |  |  |  |  | Chocolate
 |  |  |  |  |  |  | 2 | I would like this box to say "Chocolate" |  | Chocolate |  | 2 | Chocolate
 |  |  |  |  |  |  | 3 | I would like this box to say "Chocolate" |  | Chocolate |  | 3 | Chocolate
 |  |  |  |  |  |  | 4 | I would like this box to say "Chocolate" |  | Chocolate |  | 4 | Chocolate
 |  |  |  |  |  |  | 5 | I would like this box to say "Chocolate" |  | Chocolate |  | 5 | Chocolate
 |  |  |  |  |  |  | 6 | I would like this box to say "Chocolate" |  | Chocolate |  | 6 | Chocolate
 |  |  |  |  |  |  | 7 | I would like this box to say "Chocolate" |  | Chocolate |  | 7 | Chocolate
 |  |  |  |  |  |  | 8 | I would like this box to say "Chocolate" |  | Chocolate |  | 8 | Chocolate
 |  |  |  |  |  |  | 9 | I would like this box to say "Vanilla" |  | Vanilla |  | 9 | Vanilla
 |  |  |  |  |  |  | 10 | I would like this box to say "Vanilla" |  | Vanilla |  | 10 | Vanilla
 |  |  |  |  |  |  | 11 | I would like this box to say "Vanilla" |  | Vanilla |  | 11 | Vanilla
 |  |  |  |  |  |  | 12 | I would like this box to say "Vanilla" |  | Vanilla |  | 12 | Vanilla
 |  |  |  |  |  |  | 13 | I would like this box to say "Vanilla" |  | Vanilla |  | 13 | Vanilla
 |  |  |  |  |  |  | 14 | I would like this box to say "Vanilla" |  | Vanilla |  | 14 | Vanilla
 |  |  |  |  |  |  | 15 | I would like this box to say "Vanilla" |  | Vanilla |  | 15 | Vanilla
 |  |  |  |  |  |  | 16 | I would like this box to say "Vanilla" |  | Vanilla |  | 16 | Vanilla
 |  |  |  |  |  |  | 17 | I would like this box to say "Vanilla" |  | Vanilla |  | 17 | Vanilla
Spreadsheet: 773050d1647595156-index-match-on-dynamic-columns-and-rows-sample-of-data-1-
Sheet: Report

January
New Users | United States | Philippines | India | United Kingdom
Organic Search
Social
[NAME]
February
New Users | United States | Philippines | India | United Kingdom
Organic traffic
Social
[NAME]
Spreadsheet: 103740d1301461527-vlookup-applied-to-mulitple-cells-based-on-dropdown-testbook-mod
Sheet: Sheet1

pants1 | pants | 1 | waist size?
pants2 | pants | 2 | length?
pants3 | pants | 3 | style? |  | shirt |  | Cell F$ =VLOOKUP(F$3&E4,$A$1:$D$9,4) You need to ensure that Column A is sorted Lowest to Highest
shirt1 | shirt | 1 | What size? | 1 | What size?
shirt2 | shirt | 2 | What color? | 2 | What color?
shirt3 | shirt | 3 |  | 3 | 0
shoes1 | shoes | 1 | size?
shoes2 | shoes | 2 | style?
shoes3 | shoes | 3 | color?
Spreadsheet: 752137d1634603920-if-function-for-multiple-multiplications-on-one-cell-use-this-one
Sheet: Sheet1

Monday | Employee |  | HOURS AND ROSTERING |  |  |  | Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals |  | Rejects |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KPIs before fails |  |  |  | KPIs after fails
 |  |  | Roster |  |  | Total | NBCF |  |  |  |  |  |  |  |  | Charity 2 |  |  |  |  |  | Hello Fresh |  |  |  |  |  | Retail Amount | Coms |  |  | NBCF |  |  |  |  |  | Charity 2 |  |  |  |  |  | Hello Fresh |  |  |  |  |  | Count
 | Commissionable amounts |  |  |  |  |  | 0 | 25 | 30 | 39 | 49 | 49 |  |  |  |  |  |  |  |  |  | 0 | 95.51 | 109.89 | 129.87 | 153.83 | 169.79
 | Level | Name | Start Time | Finish Time | Breaks | Hours | 20 | 25 | 30 | 39 | 49 | 69 | Count | Total | Comms |  |  |  |  |  | Comms | [NAME] | C4 - 2ppl | C5 - 2ppl | C3 - 4ppl | C4 - 4ppl | C5 - 4ppl |  |  | Comms | Count | 20 | 25 | 30 | 39 | 49 | 69 |  |  |  |  |  |  | [NAME] | C4 - 2ppl | C5 - 2ppl | C3 - 4ppl | C4 - 4ppl | C5 - 4ppl |  | Sales / Hr | Av. Pledge | Av. Pledge | Piece Av. | Sales / Hr | Av. Pledge | Piece Av.
 |  | Adam | 0800 | 17:00 | 00:30:00 | 7 |  |  | 2 | 1
 |  |  | 0800 |  |  | 7
 |  |  | 0800 |  |  | 7
 |  |  | 0800 |  |  | 7
 |  |  | 0800 |  |  | 7
 |  |  | 0800 |  |  | 7
 |  |  | 0800 |  |  | 7
 |  |  | 0800 |  |  | 7
 |  |  | 0800 |  |  | 7
 |  |  | 0800 |  |  | 7
 |  |  | 0800 |  |  | 7
 |  |  | 0800 |  |  | 7
 |  |  | 0800 |  |  | 7
 |  |  | 0800 |  |  | 7
 |  |  | 0800 |  |  | 7
 |  |  | 0800 |  |  | 7
 |  |  | 0800 |  |  | 7
 |  |  | 0800 |  |  | 7
 |  |  | 0800 |  |  | 7
 |  |  | 0800 |  |  | 7
 | Totals
Spreadsheet: 848470d1699202686-how-to-filter-select-specific-strings-from-a-big-database-if-and-or-search-left-example-for-forum-3-nov-2023-jacc-2_extended-2-
Sheet: Forum (3)

 |  |  |  |  |  |  |  |  |  | Method
 |  |  |  |  |  |  |  |  |  | A method
Some examples for strings that occur in the big data sheet (80 columns; 900 rows) |  |  |  |  |  |  |  |  |  | The method
 |  |  |  |  |  |  |  |  |  | A
Attempt 1 |  |  |  |  |  |  |  |  |  | An
Apparatus for controlling a flow of molten source material | Apparatus for controlling something different | A method for controlling a flow
A method of improving a measurement of a parameter of interest | A method of improving a measurement of a parameter of interest | A method as claimed in claim 1
A lithographic apparatus | A lithographic apparatus comprising: [NAME] and the processing arrangement of claim XXX. | Exposure apparatus
An apparatus to perform the method of any of claims 1 to 14. | An apparatus | An apparatus, comprising a component
Method for control a flow | Method for controlling a flow according to claim 1 | The method for controlling a flow according to claim 1 or 2
An apparatus according to claim 1 | An optical arrangement as claimed in claim 1 | An apparatus according to any of the preceding claims
Spreadsheet: 105900d1303165633-solved-finding-values-in-a-matrix-automatically-matrix-auto
Sheet: Sheet1

251 | AL | AL | 205 | 251 | 256 | 334 | 659 |  | 907 | AK
907 | AK | AK | 907 |  |  |  |  |  | 205 | AL
907 | AK | AR | 480 | 520 | 602 | 623 |  |  | 251 | AL
480 | AR |  |  |  |  |  |  |  | 256 | AL
520 | AR |  |  |  |  |  |  |  | 334 | AL
 |  |  |  |  |  |  |  |  | 659 | AL
 |  |  |  |  |  |  |  |  | 480 | AR
 |  |  |  |  |  |  |  |  | 520 | AR
 |  |  |  |  |  |  |  |  | 602 | AR
 |  |  |  |  |  |  |  |  | 623 | AR
Spreadsheet: 272956d1382555177-auto-populate-a-cell-best-light-images
Sheet: SALES

DATE | CATEGORY | STOCK ID | [NAME] | PRICE SOLD | QUANTITY
2013-01-01 00:00:00 | A5 Cards | A5-001
2013-01-01 00:00:00 | A5 Cards | A5-002
2013-01-01 00:00:00 | A5 Cards | A5-003
2013-01-01 00:00:00 | A5 Cards | A5-004
2013-01-01 00:00:00 | A5 Cards | A5-005
2013-01-01 00:00:00 | A5 Cards | A5-006
2013-01-01 00:00:00 | A5 Cards | A5-007
Spreadsheet: 863708d1711109565-column-total-remains-zero-in-spite-of-trying-formatting-all-options-trial
Sheet: Sheet2

Sr No. | Reference No (URN) | Journal Date | Date of Purchase | Name of the Purchaser | Prefix | share Number | rate
1 | 1.20190412e+18 | 2019-04-12 00:00:00 | 2019-04-12 00:00:00 | [NAME] | TL | 11448 | 10,00,000
2 | 1.20190412e+18 | 2019-04-12 00:00:00 | 2019-04-12 00:00:00 | mjjjlkj | TL | 11447 | 10,00,000
3 | 1.20190412e+18 | 2019-04-12 00:00:00 | 2019-04-12 00:00:00 | hkkhjkh | TL | 11441 | 10,00,000 |  | 0
4 | 1.20190412e+18 | 2019-04-12 00:00:00 | 2019-04-12 00:00:00 | nsnsnsnssn | OL | 1113 | 1,00,000
5 | 1.20190412e+18 | 2019-04-12 00:00:00 | 2019-04-12 00:00:00 | hkhkh | OL | 1118 | 1,00,000
6 | 1.20190412e+18 | 2019-04-12 00:00:00 | 2019-04-12 00:00:00 | A B C INDIA LIMITED | OL | 1112 | 1,00,000
Spreadsheet: 122932d1317244243-automatically-getting-the-comment-box-to-appear-when-data-is-entered-temp
Sheet: February

Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
31 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6
7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13
14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20
21 | Presidents Day | 22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27
28 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6
Spreadsheet: 006f9a70-4f38-4e79-a370-464b961f0f50
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Searches | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 | Month: | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | Grand total:
SearchGroups: | SearchType:
Total Browse Searches | Browse by Alphabet | 2707 | 1700 | 5049 | 5627 | 3949 | 3198 | 2038 | 3973 | 4109 | 4016 | 1744 | 1874 | 39984
 | Browse by Subject | 646 | 338 | 1947 | 2540 | 1624 | 1263 | 618 | 1619 | 1568 | 1600 | 487 | 579 | 14829
 | Total Browse Searches total: | 3353 | 2038 | 6996 | 8167 | 5573 | 4461 | 2656 | 5592 | 5677 | 5616 | 2231 | 2453 | 54813
Total [NAME] | Title Begins With | 6399 | 3630 | 8246 | 9414 | 6355 | 5040 | 4175 | 6883 | 8186 | 7690 | 3765 | 4179 | 73962
 | Title Contains | 400 | 217 | 827 | 1271 | 970 | 592 | 299 | 666 | 875 | 777 | 354 | 392 | 7640
 | Title Equals | 95 | 99 | 290 | 323 | 219 | 165 | 151 | 223 | 272 | 200 | 108 | 101 | 2246
 | Total Titles Searches total: | 6894 | 3946 | 9363 | 11008 | 7544 | 5797 | 4625 | 7772 | 9333 | 8667 | 4227 | 4672 | 83848
Other Searches | ISSN Equals | 134 | 71 | 273 | 392 | 217 | 152 | 216 | 195 | 267 | 210 | 98 | 37 | 2262
 | MARC | 1759 | 749 | 2061 | 2259 | 1605 | 1179 | 1030 | 1759 | 1924 | 1380 | 787 | 1101 | 17593
 | OpenURL | 9229 | 4826 | 14693 | 23581 | 15866 | 12671 | 8514 | 21170 | 23691 | 23087 | 8954 | 9030 | 175312
 | Other Searches total: | 11122 | 5646 | 17027 | 26232 | 17688 | 14002 | 9760 | 23124 | 25882 | 24677 | 9839 | 10168 | 195167
Grand total: |  | 21369 | 11630 | 33386 | 45407 | 30805 | 24260 | 17041 | 36488 | 40892 | 38960 | 16297 | 17293 | 333828
Spreadsheet: 525501d1498749932-extracting-multiple-text-from-a-single-cell-abs-formula
Sheet: Sheet1

~1cE~1c****************~1c101~1c100~1c~1c~1c~1c~1c~1c~1c~1c22~1c01424~1c00000~1c0007435~1c0007435~1c079~1c0003944~1c0002239~1c000000~1c0000883~1c070~1c0002000~1c0005215~1c000398~1c0000645~1c070~1c0002000~1c0005215~1c000398~1c0000645~1c081~1c0001000~1c0020400~1c000000~1c0002040~1c) [NAME])
Spreadsheet: 687628d1595323188-excel-timesheet-regular-hours-overtime-a-and-overtime-b-timesheet-with-ot-a-and-ot-b
Sheet: Weekly Timesheet

 | Weekly TimeSheet Calculator
 | Employee Name:
 | Department:
 | First Line Manager:
 |  | Year | Month | Date | Weekend
 |  | 2020 | July | 12 | Sat & Sun
 |  | Regular Hours | Overtime A - first 3 hours after 7.6 hours | Overtime B - remainder hours
 |  | 7.6
 | Day | Date | In Time | Out Time | [NAME] | Regular Hrs | OT A Hours | OT B hours
 |  |  | 09:00:00 | 18:00:00 | 1
 |  |  |  | Weekly Summary
Spreadsheet: 216709d1361860439-find-data-betwwen-two-dates-datest
Sheet: Sheet2

2012-11-02 00:00:00 | Suppose I Give Assigned Date as 11/2/2012
2013-02-05 00:00:00 | Suppose I Give Closed Date as 2/5/2012
Incident No. | Description | Assignee Individual | Assigned date | Closed date | Acknowledment time(mins) | Resolution time (hrs) | Effots spent | Resolved within  SLA
 |  |  |  |  |  |  |  |  |  | 32680254 | AAAA | A | 41215 | 41215 | 5.4 | 0.74 | 0.65 | Y
 |  |  |  |  |  |  |  |  |  | 33114036 | BBBBB | B | 41245.11165509259 | 41245.13618055556 | 0.03222222222 | 0.6194444444 | 0.5872222222 | Y
 |  |  |  |  |  |  |  |  |  | 33905199 | CCCCC | C | 41302.82412037037 | 41302.86300925926 | 0.01638888889 | 0.9494444444 | 0.8847222222 | Y
 |  |  |  |  |  |  |  |  |  | 33991266 | DDDDD | D | 41308.2690625 | 41308.39582175926 | 0.1113888889 | 3.153333333 | 3.041944444 | Y
 |  |  |  |  |  |  |  |  |  | 33987989 | EEEEE | E | 41307.78501157407 | 41307.87902777778 | 0.03555555556 | 2.291666666 | 0.7191666667 | Y
 |  |  |  |  |  |  |  |  |  | 33986990 | GGGGG | F | 41307.58538194445 | 41307.63405092592 | 0.07138888889 | 1.239166667 | 1.167777778 | Y
 |  |  |  |  |  |  |  |  |  | 34033456 | HHHHH | G | 41310.83681712963 | 41310.87174768518 | 0.1133333333 | 0.9513888889 | 0.8380555556 | Y
IT should give result as above shown from Sheet1
Spreadsheet: 848940d1699539037-list-missing-numbers-in-range-not-as-an-array-forumla-list-missing-numbers-in-range-aligw
Sheet: Sheet1

 | Production Task # |  | Production Line 1 | Production Line 2 | Production Line 3
 | 1 |  | 1
 | 2 |  | 2 | 3 | 7
 | 3 |  | 5 | 4 | 8
 | 4 |  | 10 |  | 9
 | 5 |  | 12 | 14 | 11
 | 6 |  | 13 |  | 19
 | 7 |  | 15
 | 8 |  | 16 | 18
 | 9 |  | 17
 | 10 |  | 20
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
Spreadsheet: 109779d1306533822-need-help-with-formula-example-modified-
Sheet: Sheet1

 | Y= | 48
 | Enter Amount | Conversion Size | Answer
A | 1Y12 | 0.75 | 45
B | 1Y12 | 0.5 | 30
C | 1Y36 | 0.9 | 1Y27.6
D | 3Y12 | 0.75 | 2Y21
E | 2Y2 | 0.8 | 1Y30.4
F
G
H
I
J
K
L
Spreadsheet: theresa_staab__39595__Kennedy email
Sheet: Box Draw

[NAME] | Contact: | [NAME] |  |  | Enron North America
 | PH: | [PHONE]
 | FAX: | [PHONE] |  |  | [NAME] | [PHONE]
Inside FERC NGPL Midcont.:
Inside FERC CIG:
First of Month Nomination: |  |  | MMBtu
Additional Purchases: |  |  | MMBtu
 | Wt. Avg. Btu: | Nom. | Pro rata Production | Transportation/MMBtu
[NAME] |  |  |  | 0.61
[NAME] |  |  |  | 0.47
Box Draw Net Backs: |  | Index Discount/Premium | Crestone Transport/MMBtu | [NAME] |  | [NAME] | [NAME] (0%*NGPLindex) | Total Receipts Fee Adjustment* |  | Total Net Back
[NAME]. | CIG GD | 0
[NAME]. | IF NGPL Midcont. | 0.01 |  |  |  | -0.1226 | 0
[NAME]. | IF CIG Rockies | 0
Add'l Purchases | CIG GD | See GD Pricing Sheet
Add'l Purchases | CIG GD | 0.1 |  | -0.25
 |  | BOX DRAW
 |  | Over 80% of FOM Nom. | FOM CIG GD Volume MMBtu | [NAME] (Less S. Kitty) 80% of FOM Nom. up to 12,000/Day | NGPL Volume MMBtu | 80% of FOM Nom. Less 12,000/Day | FOM CIG Volume MMBtu | Additional CIG GD +.10 Purchases | Add'l CIG GD + .10 Volume MMBtu | Additional CIG GD - Daily Discount | Add'l CIG GD - Daily Discount Volume MMBtu | Total Box Draw Allocated Fuel MMBtu | Box Draw Wellhead Production MMBtu | Total Purchased Production MMBtu | Total Box Draw Payments by [NAME]
 | CIG GD Rockies | CIG GD less Netback |  | NGPL less Netback |  | CIG less Netback |  | CIG GD less Netback |  | CIG GD less Netback |  |  |  |  | $ FOM CIG GD | $ NGPL | $ FOM CIG | $ Add'l CIG GD + .10 | $ Add'l CIG GD - Daily Discount | Total Payment
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Avg. $/Mmbtu:
*Total Receipts Fee Adjustment is calculated by applying the Field Services Fee to the fuel volume and then dividing that dollar amount(fee times fuel volume) by the volume purchased.
Spreadsheet: 853915d1703863468-auto-fill-cell-with-test-1-
Sheet: Sheet1

State | Rate Per Hour | Hours | Total
BOS |  | 1
NYC |  | 1
CHI |  | 1
LAX |  | 1
BOS |  | 1
NYC |  | 1
CHI |  | 1 |  |  |  |  | BOS | 10
LAX |  | 1 |  |  |  |  | NYC | 20
BOS |  | 1 |  |  |  |  | CHI | 30
NYC |  | 1 |  |  |  |  | LAX | 50
CHI |  | 1
LAX |  | 1
NYC |  | 1
CHI |  | 1
LAX |  | 1
CHI |  | 2
LAX |  | 2
Spreadsheet: 46d77cb7-ba63-4dc1-ab36-6d9a78645bcf
Sheet: Sheet1

State Codes Last updated: 8/11/14
State Code | State Name
AL | Alabama
AK | Alaska
AZ | Arizona
AR | Arkansas
CA | California
CO | Colorado
CT | Connecticut
DE | Delaware
DC | District of Columbia
FL | Florida
GA | Georgia
HI | Hawaii
ID | Idaho
IL | Illinois
IN | Indiana
IA | Iowa
KS | Kansas
KY | Kentucky
LA | Louisiana
ME | Maine
MD | Maryland
MA | Massachusetts
MI | Michigan
MN | Minnesota
MS | Mississippi
MO | Missouri
MT | Montana
NE | Nebraska
NV | Nevada
NH | New Hampshire
NJ | New Jersey
NM | New Mexico
NY | New York
NC | North Carolina
ND | North Dakota
OH | Ohio
OK | Oklahoma
OR | Oregon
PA | Pennsylvania
PR | Puerto Rico
RI | Rhode Island
SC | South Carolina
SD | South Dakota
TN | Tennessee
TX | Texas
UT | Utah
VT | Vermont
VA | Virginia
WA | Washington
WV | West Virginia
WI | Wisconsin
WY | Wyoming
XX | Other Than United States
Spreadsheet: 52032d1251726389-any-automation-formula-to-update-monthly-report-simple-linking
Sheet: Summary by Quarterly

 |  | Q1 | Q2 | Q3 | Q4
 | Product A | 26194.86934027552 | 20020.78758024428 | 19755.11372548783 | 21496.84898812243
 | Product B | 19327.93676192992 | 16856.05527655929 | 17740.76716305654 | 18519.51826033857
 | Product C | 21193.28367724072 | 19913.14811129853 | 19147.83672570431 | 13416.35423016971
 | Product D | 18166.79938256283 | 14949.53935105015 | 13766.34141833314 | 16943.55594259328
 |  | 84882.88916200899 | 71739.53031915225 | 70410.05903258182 | 70376.27742122399
Spreadsheet: 588034d1535455155-2-variable-data-table-not-working-structure
Sheet: Sheet1

 |  |  |  |  | PE
Proposed Paid-UP Capital | 740532370
Number of shares |  |  | Number of shares |  |  | 18.31970351638769 | 21.65055870118545 | 26.64684147838209 | 33.30855184797761 | 41.63568980997201 | Incorrect result (done using data table function)
 |  |  |  | 80000000 | 38.54072006445428 | 40.08234886703245 | 43.1656064721888 | 47.79049287992331 | 53.95700809023599 | 61.66515210312685
NPAT | 123330304.2062537 |  |  |  | 54.81346853611277 | 56.18380524951558 | 58.92447867632122 | 63.03548881652968 | 68.51683567014095 | 75.36851923715504
EPS |  |  |  |  | 67.83166731343954 | 69.06497035550207 | 71.53157643962714 | 75.23148556581476 | 80.1646977340649 | 86.3312129443776
PE | 10 |  |  |  | 78.48292085852509 | 79.6041054422183 | 81.84647460960473 | 85.21002836068438 | 89.69476669545725 | 95.30068961392331
IPO Valuation |  |  |  |  | 87.3589654794297 | 88.38671801448181 | 90.44222308458605 | 93.5254806897424 | 97.63649082995084 | 102.7752535052114
 |  |  |  | 80000000 | 15.41628802578171
 |  |  |  |  | 13.70336713402819
 |  |  |  |  | 12.33303042062537
 |  |  |  |  | 11.21184583693216
 |  |  |  |  | 10.27752535052114
 |  |  |  |  |  |  |  |  |  |  | Correct result (done using formula)
Spreadsheet: 730073d1619535347-categorize-items-based-on-free-text-book1
Sheet: Cat.

 | Category | Column1
 | PC | [NAME]
 | PC | Keyboard
 | PC | Windows
 | PC | Monitor
 | PC | Update
 | PC | Bluescreen
 | PC | PC
 | Playstation | Update
 | Playstation | Disk
 | Playstation | Game
 | Playstation | Monitor
 | Playstation | Lag
 | Playstation | [NAME]
 | Headset | Voice
 | Headset | Mic
 | Headset | Noice
 | Printer | Color
 | Printer | Ink