tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 109925d1306740697-excel-autopopulate-help-needed-autopopulate-help-needed
Sheet: Product Customer

Product Name | Account List
Product 1 | Customer10 |  |  | Product Name
Product 1 | Customer11 |  |  | Product 1
Product 1 | Customer12 |  |  | Product 2
Product 1 | Customer13 |  |  | Product 3
Product 1 | Customer14 |  |  | Product 4
Product 1 | Customer15 |  |  | Grand Total
Product 1 | Customer16
Product 1 | Customer17
Product 1 | Customer18
Product 1 | Customer19
Product 1 | Customer20
Product 1 | Customer21
Product 2 | Customer22
Product 2 | Customer23
Product 2 | Customer24
Product 2 | Customer25
Product 2 | Customer26
Product 2 | Customer27
Product 2 | Customer28
Product 2 | Customer29
Product 2 | Customer30
Product 2 | Customer31
Product 2 | Customer32
Product 2 | Customer33
Product 2 | Customer34
Product 2 | Customer35
Product 2 | Customer36
Product 2 | Customer37
Product 2 | Customer38
Product 2 | Customer39
Product 2 | Customer40
Product 2 | Customer41
Product 2 | Customer42
Product 3 | Customer43
Product 3 | Customer44
Product 3 | Customer45
Product 3 | Customer46
Product 3 | Customer47
Product 3 | Customer48
Product 3 | Customer49
Product 3 | Customer50
Product 3 | Customer51
Product 3 | Customer52
Product 3 | Customer53
Product 3 | Customer54
Product 3 | Customer55
Product 3 | Customer56
Product 3 | Customer57
Product 3 | Customer58
Product 3 | Customer59
Product 3 | Customer60
Product 3 | Customer61
Product 3 | Customer62
Product 3 | Customer63
Product 3 | Customer64
Product 3 | Customer65
Product 3 | Customer66
Product 4 | Customer67
Product 4 | Customer68
Product 4 | Customer69
Product 4 | Customer70
Product 4 | Customer71
Product 4 | Customer72
Product 4 | Customer73
Product 4 | Customer74
Product 4 | Customer75
Product 4 | Customer76
Product 4 | Customer77
Product 4 | Customer78
Product 4 | Customer79
Product 4 | Customer80
Product 4 | Customer81
Product 4 | Customer82
Product 4 | Customer83
Product 4 | Customer84
Product 4 | Customer85
Product 4 | Customer86
Product 4 | Customer87
Product 4 | Customer88
Product 4 | Customer89
Product 4 | Customer90
Product 4 | Customer91
Product 4 | Customer92
Product 4 | Customer93
Product 4 | Customer94
Product 4 | Customer95
Product 4 | Customer96
Product 4 | Customer97
Product 4 | Customer98
Product 4 | Customer99
Product 4 | Customer100
Product 4 | Customer101
Product 4 | Customer102
Product 4 | Customer103
Product 4 | Customer104
Product 4 | Customer105
Product 4 | Customer106
Product 4 | Customer107
Product 4 | Customer108
Spreadsheet: 136932d1326893356-help-calulation-based-upon-a-drop-downlist-stockcontrol-main
Sheet: Sheet1

Product List | Total |  | Goods In Record |  |  |  |  |  |  | Goods Out Record
Almonds |  |  | Date | Item | Quantity | Supplier | Received By | Batch Number |  | Date | Item | Quantity | Given To | Used For | Batch Number
Almonds (Blanched) |  |  |  | Almonds | 60 |  |  |  |  |  | Almonds | 40
Apples
Butter
[NAME]
Cashews
Cherries
Chocolate (Dark)
Chocolate (Milk)
Chocolate (White)
Citric Acid
Coconut
[NAME] powder
Dates
Filo pastry
[NAME] (Canadian)
[NAME] (Super-Helium)
[NAME] (Wheat)
Ghee (Butter)
Ghee (Vegetable)
[NAME] paste
Mascarpone
Milk powder
Mozzarella cheese
Oil
Orange blossom water
Oranges
Peanuts
Pineapple slices
Pistachio
Rose water
Salt
Semolina (Course)
Semolina (Fine)
Semolina (Wheat)
Sesame seeds
Starch
Strawberries
Sugar
Sugar (Icing)
Syrup
Vanilla essence
Walnuts
Yeast
Cups (Medium)
Cups (Espresso)
[NAME] (18 inch)
[NAME] (40 inch)
Boxes ([NAME])
Boxes (Bateel)
[NAME] (12cm)
[NAME])
[NAME])
[NAME]Medium)
[NAME] (18cm)
[NAME] (20cm)
[NAME] (22cm)
[NAME] (24cm)
[NAME] (27cm)
[NAME] (30cm)
[NAME] (33cm)
[NAME] (36cm)
[NAME] (Small 1kg)
Baklawa Tins (Medium 1.5kg)
Baklawa Tins (Large 2kg)
[NAME] (80x100) Clear
[NAME] (80x100) Violet
Hot chocolate
Coffee
Tea (Earl)
Tea (English Breakfast)
Milk
Chocolate dusting
Plastic spoons
7up
Coca Cola
Coca Cola (Diet)
Water
Tissues
Nougat
Bleach
Spreadsheet: 853048d1703003777-formula-to-pick-character-based-on-name-and-date-my-requirements_lgs_b
Sheet: Sheet2

DATE |  |  |  |  |  |  |  |  | MY REQUIREMENTS
NAME | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-05 00:00:00 | 2024-01-06 00:00:00 | 2024-01-07 00:00:00 |  | NAME | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-05 00:00:00 | 2024-01-06 00:00:00 | 2024-01-07 00:00:00 | ABSENT | LEAVE | MEDICAL
D | ABSENT |  |  |  |  | LEAVE | LEAVE |  | A
C |  |  | ABSENT | MEDICAL |  |  |  |  | B
B | MEDICAL |  | MEDICAL |  |  | ABSENT |  |  | D
A | ABSENT |  |  | MEDICAL |  |  | LEAVE
 |  |  |  |  |  |  |  |  | [NAME] in K3
 |  |  |  |  |  |  |  |  | =VLOOKUP($J3;$A$2:$H$6;MATCH(K$2;$A$2:$H$2;0);0)&""
Spreadsheet: 165563d1341267347-timesheet-with-multiple-jobs-how-to-display-time-per-job-timesheet-breadbowl-oeldere-
Sheet: Sheet1 (2)

date | week | day | Job# | IN | OUT | Time | Hours
2012-07-02 00:00:00 | 28 | 1904-01-04 00:00:00 | A | 08:00:00 | 09:00:00 | 01:00:00 | 1
2012-07-02 00:00:00 | 28 | 1904-01-04 00:00:00 | B | 09:00:00 | 10:00:00 | 01:00:00 | 1 |  | Som van Hours | Kolomlabels
2012-07-02 00:00:00 | 28 | 1904-01-04 00:00:00 | A | 10:00:00 | 10:30:00 | 00:30:00 | 0.4999999999999996 |  | Rijlabels | A | B | C | D | Holiday | (leeg) | Eindtotaal
2012-07-02 00:00:00 | 28 | 1904-01-04 00:00:00 | C | 10:30:00 | 11:00:00 | 00:30:00 | 0.4999999999999996 |  | 28 | 5.000000000000001 | 2.000000000000001 | 0.4999999999999996 |  | 7.500000000000001 | 0 | 15
2012-07-02 00:00:00 | 28 | 1904-01-04 00:00:00 | B | 11:00:00 | 12:00:00 | 01:00:00 | 1 |  | 1904-01-04 00:00:00 | 5.000000000000001 | 2.000000000000001 | 0.4999999999999996 |  |  |  | 7.500000000000002
2012-07-02 00:00:00 | 28 | 1904-01-04 00:00:00 | A | 13:00:00 | 16:30:00 | 03:30:00 | 3.500000000000001 |  | 1904-01-05 00:00:00 |  |  |  |  |  | 0 | 0
2012-07-03 00:00:00 | 28 | 1904-01-05 00:00:00 |  |  |  | 1900-01-01 00:00:00 | 0 |  | 1904-01-06 00:00:00 |  |  |  |  | 7.500000000000001 |  | 7.500000000000001
2012-07-04 00:00:00 | 28 | 1904-01-06 00:00:00 | Holiday | 08:00:00 | 12:00:00 | 04:00:00 | 4 |  | 30 | 3.500000000000001 | 3.500000000000001 | 3.500000000000001 | 3.500000000000001 |  |  | 14
2012-07-04 00:00:00 | 28 | 1904-01-06 00:00:00 | Holiday | 13:00:00 | 16:30:00 | 03:30:00 | 3.500000000000001 |  | 1904-01-09 00:00:00 | 3.500000000000001 | 3.500000000000001 | 3.500000000000001 | 3.500000000000001 |  |  | 14
2012-07-21 00:00:00 | 30 | 1904-01-09 00:00:00 | A | 13:00:00 | 16:30:00 | 03:30:00 | 3.500000000000001 |  | (leeg) |  |  |  |  |  | 0 | 0
2012-07-21 00:00:00 | 30 | 1904-01-09 00:00:00 | B | 13:00:00 | 16:30:00 | 03:30:00 | 3.500000000000001 |  | (leeg) |  |  |  |  |  | 0 | 0
2012-07-21 00:00:00 | 30 | 1904-01-09 00:00:00 | C | 13:00:00 | 16:30:00 | 03:30:00 | 3.500000000000001 |  | Eindtotaal | 8.500000000000002 | 5.500000000000002 | 4 | 3.500000000000001 | 7.500000000000001 | 0 | 29.00000000000001
2012-07-21 00:00:00 | 30 | 1904-01-09 00:00:00 | D | 13:00:00 | 16:30:00 | 03:30:00 | 3.500000000000001
 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  | 1900-01-01 00:00:00 | 0
Spreadsheet: 65362d1266030708-sum-data-from-multiple-sheets-budget
Sheet: SUMMARY EXAMPLE

 | FROM | TO
REPORT: | 2010-01-01 00:00:00 | 2010-01-31 00:00:00 |  | SAMPLE IF JAN 1 TO JAN 31 ENTERED
 |  |  |  |  |  |  |  |  |  | Notice two INCOMEA from JAN sheet totaled to 2900.00 on one line
INCOME |  |  | EXPENSE |  |  | SPENDING |  |  |  | Notice two WATER from JAN sheet total to 108.00 on one line
INCOMEA | 2900 |  | ELECTRIC | 114 |  | GROCERY | 100 |  |  | Notice two FASTFOOD from JAN sheet totaled to 22.00 on one line
INCOMEB | 800 |  | WATER | 108 |  | FASTFOOD | 22
INCOMEC | 450 |  | CABLE | 33 |  | CLEANERS | 23
TOTAL |  |  | TOTAL |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  | FINISHED REPORT NEED HAVE ONLY ONE OF THESE.
 | FROM | TO |  |  |  |  |  |  |  | TWO REPORTS SHOWN TO DEMONSTRATE DESIRED
REPORT: | 2010-02-01 00:00:00 | 2010-02-28 00:00:00 |  | SAMPLE IF FEB 1 TO FEB 28 ENTERED |  |  |  |  |  | RESULTS DEPENDING ON DATES ENTERED.
INCOME |  |  | EXPENSE |  |  | SPENDING
INCOMEA | 1400 |  | ELECTRIC | 115 |  | GROCERY | 115 |  |  | Notice two INCOMEB from FEB sheet totaled to 2200.00 on one line
INCOMEB | 2200 |  | WATER | 60 |  | FUEL | 28 |  |  | Notice two GAS from FEB sheet totalED to 87.00 on one line
INCOMEC | 350 |  | GAS | 87 |  | CLEANERS | 25 |  |  | Notice two FUEL from JAN sheet totaled to 28.00 on one line
TOTAL |  |  | TOTAL |  |  | TOTAL
Spreadsheet: 9a809faa-9b97-4ccb-911c-465147951f2a
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38848434 | 2013-12-05 22:28:07 | AXIS | 1 | 10 | 4 | 653605 | Le Pelican | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 880233d1727867407-drop-down-list-small-problem-categories2
Sheet: Arkusz1

 | it works ok
 | Cat1 |  | Cat1 | Product 1 cat1 | 0 |  | Choose1 : | Cat1 |  |  | Cat1 | Product 2 cat1 |  | Now I need one last improvement.  I need only products with status "1" to be assigned to each category.  Categories (table 1 - 4 rows) and products (table 2) may grow over time  Currently it depends on one item "Choose1:"
 | Cat2 |  | Cat1 | Product 2 cat1 | 1 |  | Choose2: | Product 3 cat4 |  |  | Cat3
 | Cat3 |  | Cat1 | Product 3 cat1 | 0 |  |  |  |  |  | Cat4
 | Cat4 |  | Cat1 | Product 4 cat1 | 0 |  |  |  |  |  | Cat2
 |  |  | Cat2 | Product 1 cat2 | 1
 |  |  | Cat2 | Product 2 cat2 | 1
 |  |  | Cat2 | Product 3 cat2 | 1
 |  |  | Cat2 | Product 4 cat2 | 1
 |  |  | Cat2 | Product 5 cat2 | 0
 |  |  | Cat2 | Product 6 cat2 | 0
 |  |  | Cat2 | Product 7 cat2 | 0
 |  |  | Cat3 | Product 1 cat3 | 1
 |  |  | Cat3 | Product 2 cat3 | 1
 |  |  | Cat3 | Product 3 cat3 | 1
 |  |  | Cat3 | Product 4 cat3 | 1
 |  |  | Cat3 | Product 5 cat3 | 0
 |  |  | Cat3 | Product 6 cat3 | 0
 |  |  | Cat3 | Product 7 cat3 | 0
 |  |  | Cat3 | Product 8 cat3 | 0
 |  |  | Cat4 | Product 1 cat4 | 1
 |  |  | Cat4 | Product 2 cat4 | 1
 |  |  | Cat4 | Product 3 cat4 | 1
 |  |  | Cat4 | Product 4 cat4 | 0
 |  |  | Cat4 | Product 5 cat4 | 0
Spreadsheet: 10100372-619b-4bc7-8379-41f4b52ca6b3
Sheet: დანართი 2 

დანართი N2
ორგანიზაციის ანგარიში არაფინანსური აქტივების მიღება-გასვლის შესახებ
დასახელება |  | ნაშთი წლის დასაწყისში | მიღება |  |  | გასვლა
 |  |  | შესყიდვის ოპერაციებით | [NAME] | მოგება ფლობით | [NAME] | [NAME] (გარდა ძირითადი კაპიტალის მოხმარებისა) | ძირითადი კაპიტალის მოხმარებით | [NAME] | ნაშთი წლის ბოლოს
010 | ძირითადი აქტივები
020 | მატერიალური მარაგები
030 | მ.შ გრძელვადიანი მცირეფასიანი აქტივები
040 | ფასეულობები
050 | არაწარმოებული აქტივები
Spreadsheet: 289294d1389495801-template-to-be-instantly-filled-out-with-info-from-another-spreadsheet-invoice-lookup
Sheet: Company Lookup

Company | Contact | Phone | Address | City | State
Foo Bars | [NAME] | 549-2749 | 4613 Tyra Street | Alabama | AL
ABC Telecom | [NAME] | 917-6760 | [NAME] | Alaska | AK
Fake Brothers | [NAME] | 694-2959 | 4501 Sarina Street | Arizona | AZ
QWERTY Logistics | [NAME] | 830-3468 | 579 Caryn Ave | Arkansas | AR
Demo, inc. | [NAME] | 515-7216 | 1259 Williemae Street | California | CA
Sample Company | [NAME] | 606-6734 | 411 Oda Ave | Colorado | CO
Sample, inc | [NAME] | 642-4018 | 3598 Klara Street | Connecticut | CT
Acme Corp | [NAME] | 863-5879 | 1260 [NAME] | Delaware | DE
Allied Biscuit | [NAME] | 740-6014 | 235 Creola Street | Florida | FL
Ankh-Sto Associates | [NAME] | 711-7627 | 2206 Rich Ave | Georgia | GA
Extensive Enterprise | [NAME] | 716-7697 | 4634 Wilton Street | Hawaii | HI
Galaxy Corp | [NAME] | 689-3285 | 448 Dottie Ave | Idaho | ID
Globo-Chem | [NAME] | 761-2223 | 2270 Mia Street | Illinois | IL
Mr. [NAME] | [NAME] | 927-5236 | 2534 Wilfredo Ave | Indiana | IN
[NAME] | Ouida Early | 709-3937 | 267 Samara Street | Iowa | IA
LexCorp | [NAME] | 590-6938 | 1934 [NAME] | Kansas | KS
LuthorCorp | [NAME] | 879-6810 | 1699 Clelia Street | Kentucky | KY
North Central Positronics | [NAME] | 893-6940 | 1219 Edna Ave | Louisiana | LA
Omni Consimer Products | [NAME] | 896-7585 | 818 Melisa Street | Maine | ME
Praxis Corporation | [NAME] | 768-7681 | 191 Kala Ave | Colorado | CO
Spreadsheet: 765107d1643173823-extracting-negative-numbers-from-a-text-cell-with-at-the-end-examples-ans
Sheet: Sheet1

DAIRY FARM SHOP 6.75
WWW.JOHNLEWIS.COM 03456 049 049 25.00
SF CONNECT GBR 3.00
UNION MART LTD SOUTHAMPTON LND 4.08
PAYPAL EB GBR 4.50
Frog Bikes Ltd GBR 1.00
WWW.JOHNLEWIS.COM 03456 049 049 28.00 -
HM.COM [PHONE] 24.96
MARKS&SPENCER PLC INTERNET GBR 20.00 -
MARKS&SPENCER PLC INTERNET GBR 38.00 -
WAITROSE 23.33
NEXT DIRECTORY ONLINE GBR 22.00 -
Spreadsheet: 866496d1713428253-comma-seperated-filter-criteria-issue-example-spreadsheet
Sheet: Calculator

 |  |  |  |  |  |  |  |  |  | Components: | SV
Item | Qty | $/Qty | [NAME] | CATEGORY_A | Section | Total
 | 0 | 239 | 1 | A | SV
Labour 2 | 0 | 131 | 1.4 | A | SV
Labour 3 | 0 | 188 | 1.2 | B | SV
Labour 4 | 0 | 129 | 1.3 | B | SV
Labour 5 | 0 | 151 | 1.3 | A | SV
Travel 1 | 0 | 101 | 1.1 | A | SV
Travel 2 | 0 | 110 | 1.3 | B | SV
Travel 3 | 0 | 228 | 1.1 | B | SV
Travel 4 | 0 | 239 | 1.5 | C | SV
Parking 1 | 0 | 233 | 1.1 | C | SV
Parking 2 | 0 | 107 | 1 | D | SV
Parking 3 | 0 | 242 | 1.5 | D | SV
Parking 4 | 0 | 246 | 1 | E | SV
Spreadsheet: 200277d1355484323-reference-a-cell-only-if-match-is-found-else-calculate-a-sum-overtime-for-payroll
Sheet: t_Personnel_UDF_data

employee_id | description | type | string_data | numeric_data | currency_data | check_data | date_data
8 | 01 - Current Job Title | String | Manager
8 | 02 - Bonus Entitlement % | String | 25
8 | 03 - Car Allowance (PA) | String | 12354
8 | 04 - PMI Entitlement | String | 25
8 | 05 - PMI Member | String | Yes
8 | 06 - Contracted Hours | String | 42
8 | 07 - CSP Entitlement | String | 82
8 | 08 - Date of TUPE | String | 1990-05-05 00:00:00
8 | 09 - DateEndProbation | String | 2012-05-05 00:00:00
8 | 10 - Probation Status | String | Terminated
8 | 11 - Contract End Date | String | 2012-12-12 00:00:00
8 | 12 - DateOfLeaving | String | 2013-12-12 00:00:00
8 | 13 - Reason For Leaving | String | Personnal Reasons
8 | 14 - Additional Contract Terms | String | Work weekends
8 | 15 - RTW Documents | String
8 | 16 - RTW Type of Permit | String | Visa
8 | 17 - RTW Valid From | String | 1990-05-05 00:00:00
8 | 18 - RTW Valid Until | String | 2012-12-12 00:00:00
8 | 19 - RTW Next Check Required | String | 2013-12-12 00:00:00
8 | 20 - RTW Comments | String | Approved
9 | 01 - Current Job Title | String | Manager
9 | 02 - Bonus Entitlement % | String | 25
9 | 03 - Car Allowance (PA) | String | 12354
9 | 04 - PMI Entitlement | String | 25
9 | 05 - PMI Member | String | Yes
9 | 06 - Contracted Hours | String | 8
9 | 07 - CSP Entitlement | String | 82
9 | 08 - Date of TUPE | String | 1990-05-05 00:00:00
9 | 09 - DateEndProbation | String | 2012-05-05 00:00:00
9 | 10 - Probation Status | String | Terminated
9 | 11 - Contract End Date | String | 2012-12-12 00:00:00
9 | 12 - DateOfLeaving | String | 2013-12-12 00:00:00
9 | 13 - Reason For Leaving | String | Personnal Reasons
9 | 14 - Additional Contract Terms | String | Work weekends
9 | 15 - RTW Documents | String
9 | 16 - RTW Type of Permit | String | Visa
9 | 17 - RTW Valid From | String | 1990-05-05 00:00:00
9 | 18 - RTW Valid Until | String | 2012-12-12 00:00:00
9 | 19 - RTW Next Check Required | String | 2013-12-12 00:00:00
9 | 20 - RTW Comments | String | Approved
Spreadsheet: 92776d1292333822-auto-naming-adds-extra-characters-after-file-type-rather-than-before-test
Sheet: Sheet1

A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | AT | AU | AV | AW | AX | AY | AZ
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed
Spreadsheet: 178739d1346898571-calculate-sum-of-the-product-from-one-of-the-column-hamsample
Sheet: Sheet1

 | 2012-08-29 |  |  | 2012-08-30
 | $ | Qty | Rk | $ | Qty | Rk
[NAME] | 4.75 | 4 | 9 | 5.18 | 7 | 8
BMT | 5.5 | 2 | 20 | 5.92 | 3 | 19
CCC | 4.61 | 22 | 2 | 4.58 | 47 | 1
ChBacRnh6 | 0 | 0 | 37 | 0 | 0 | 37
ChTeri6 | 4 | 8 | 6 | 5.75 | 4 | 13
CkPizziola | 0 | 0 | 35 | 0 | 0 | 36
CLUB | 8.5 | 2 | 21 | 7.81 | 4 | 10
EgChOmlt | 0 | 0 | 33 | 0 | 0 | 32
EggSal6" | 3.5 | 1 | 24 | 3.5 | 3 | 20 |  |  |  |  |  |  |  |  | Eneter Product here
HAM&CHEESE | 4.32 | 17 | 3 | 4.72 | 10 | 4 | 27 | [NAME] to get Number 27 for HAM QTY |  |  |  |  |  |  | TUNA
MEATBALL | 5.25 | 4 | 8 | 5.25 | 8 | 7 | I want formula to SUM QTY colum amount for a particular porduct
PIZZA | 4.72 | 10 | 5 | 4.67 | 9 | 5 |  |  |  |  |  |  |  |  | 5
PrmRib | 8.56 | 4 | 10 | 6.67 | 3 | 21
PulldPork | 5 | 1 | 22 | 5 | 2 | 22
ROAST BEEF | 5.67 | 3 | 14 | 6.75 | 1 | 26
RST CHICK | 8.5 | 2 | 19 | 6.44 | 4 | 11
SPICY ITAL | 5.08 | 3 | 13 | 5.08 | 3 | 18
SUBMELT | 6.85 | 5 | 7 | 8.9 | 8 | 6
TUNA | 4.25 | 2 | 18 | 5.83 | 3 | 17
Spreadsheet: 850813d1701168239-to-pull-out-data-in-excel-on-the-basis-of-conditions-sample-sheet
Sheet: Result Sheet

 | 2023-04-25 00:00:00
 | A/C TITLE | A/C NUMBER | AMOUNT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
CREDIT
Spreadsheet: 794479d1662064766-need-help-is-it-possible-to-add-a-formula-to-a-pivot-table-sample-data
Sheet: Sheet2

Project Number | Name | Percentage |  |  |  | Row Labels | Sum of Percentage | [NAME]
111 | [NAME] | 20 |  |  |  | Ana | 60 | 100
123 | [NAME] | 10 |  |  |  | [NAME] | 30 | 70
214 | [NAME] | 10 |  |  |  | [NAME] | 20 | 60
915 | [NAME] | 10 |  |  |  | [NAME] | 60 | 100
852 | [NAME] | 30 |  |  |  | [NAME] | 50 | 90
741 | Ana | 40 |  |  |  | [NAME] | 30 | 70
159 | [NAME] | 20
456 | [NAME] | 20
789 | [NAME] | 20
321 | [NAME] | 10
147 | [NAME] | 30
258 | Ana | 20
369 | [NAME] | 10
Spreadsheet: james_steffes__12976__SVP3and4
Sheet: SVP-4

Exhibit SVP-4
RECAP OF GENERATION COSTS--Cal-PX
CITY of SANTA CLARA dba SILICON VALLEY POWER
October 2000-June 2001
 |  |  | October 2000 | November 2000 | December 2000
GIANERA AVERAGE COSTS
 | Average Natural Gas Price, per BP Amoco billings |  | 2.88 | 5.76 | 22.81
 | [NAME] @ 15,500 Btu/KWh BackBoneOut |  | 15.5 | 15.5 | 15.5
 | Marginal Fuel Cost
 | Operations & Maintenance |  | 6 | 6 | 6
 | Marginal Cost  - ($/MWh)
NOTE that none of the costs shown include provision for (a) fixed costs, (b) emissions credits or penalties, (c) credit
risk, or (d) inefficiencies associated with quick rampup and rampdown (when fuel is being burned without producing power).
NOTE also:  Santa Clara made no sales to the PX after December 2000.
Spreadsheet: darrell_schoolcraft__7307__imball0201
Sheet: Duke

Duke Energy Field Services
Contract  24268
2001-12-31 00:00:00 |  | 1531269.56
 |  |  |  |  |  |  |  | Duke Energy Trading and Marketing, L.L.C.
2002-01-20 00:00:00 |  |  |  |  |  |  |  | OBA Balances as of 11/30/01
50895
60874 | 2435
78169 |  |  |  |  |  |  |  | Contract# | Amount | Description/Points
500235 |  |  |  |  |  |  |  | 24361 |  | Pyote points - fuel is still being delivered causing amount to grow each month
500248 |  |  |  |  |  |  |  | 24693 | 275313.72 | [NAME] plant - hasn't had activity since 12/2000
500251 |  |  |  |  |  |  |  | 21665 | 73449.16 | no activity since 11/98
500254 |  |  |  |  |  |  |  | 22664 | 23612.35 | Grand Valley plant - last activity 4/96
500255
500262 | -127
500267
Duke Energy Trading and Marketing
Contract  24693
2001-12-31 00:00:00 |  | 275313.72
2002-01-20 00:00:00
9164
9167
Duke Energy Trading and Marketing |  |  |  | CBS Volume | 24268 | 24693 | 24361
Contract  24361 |  |  |  |  | 378562 | 117857 | 186976
2001-12-31 00:00:00 |  | 842376.79
2002-01-20 00:00:00
500241
500391 | 1993
500392 | 1457
Duke Energy Trading and Marketing
21665 | oba | 73445.08 | POI 9109 Mobil Waha Plant |  |  |  | 21665 | 36401
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant |  |  |  | 22664 | 18932
Spreadsheet: 115230d1310842833-excel-2003-creating-complex-report-createreport-w1-wr-vp-nrschmid-ef784488-seg12
Sheet: Instructions

CreateReport w1 wR VP - nrschmid - EF784488 - SEG12.xls
Excel 2003: creating complex report
http://www.excelforum.com/excel-general/784488-excel-2003-creating-complex-report.html
Attached is a spreadsheet. I need a report, if it is even a report, that shows for each transferable skill (top row), which projects (in Column A) I completed (based on which cells have an X).
So looking at the first two columns, I would like the information grouped as follows:
3D Modeling
Streetscape Design Guidelines. City of Wichita, KS
Commerce Street Arts District. City of Wichita, KS
Community [NAME] field Sportsplex. City of Country Club Hills, IL
Copper Slough Planned Unit Development. Champaign, IL
Fireman's Park Master Plan. Elk [NAME]. [NAME], IL
Kendall Farms Recycling Facility. Plano, IL
Kostner Park Master Plan. Midlothian Park District. Midlothian, IL
Landscape Guidelines. Village of Minooka, IL
Landscape Ordinance Update Village of Montgomery, IL
Lemont Park Master Plan. Lemont Township, IL
St. Francis Street Improvements. City of Wichita, KS
Stevenson Park. Burbank Park District. Burbank, IL
Developing and [NAME] in Downtown Wichita
Udall Park Master Plan. Elk [NAME], IL
US-36 Access Management Plan. Kansas DOT
Willow Park Master Plan. Northfield Park District, IL Northfield, IL
Branding:
Streetscape Design Guidelines. City of Wichita, KS
** Label and [NAME] case Designs. Comprehensive Plan Update. City of El Dorado, KS
** Label Design. Streetscape Design Guidelines
[NAME]. Naperville Park District
Advice on branding strategies / logo revision
Marketing material
Mock website
Portfolio ** Label and Digipak Designs (4 Panel Die Cut Screened in Color on 30% Recycled Paper)
Marketing / networking
Dining-In (program design, presentation, budget)
Newsletter revisions
How can this be done? Is this a tall order? Can I even have it put into a Word Document or is that pushing it? Let me know what I need to do.
Spreadsheet: 866776d1713697731-write-how-many-consecutive-consonants-consecutive-vowels-ans
Sheet: Sheet1

ZEPHYRS
COOLTHS
APADANA
ATALAYA
ARAWANA
APADANA
ALCHYMY
ACRYLYL
ARGYLLS
ALPHYLS
APHYLLY
THRYMSA
HRYVNYA
ASPHYXY
ZYZZYVA
ENCRYPT
[NAME]
ICHTHYS
SYNCHRO
ETHYNYL
SYSTYLE
SYNTYPE
RHYTHMI
Spreadsheet: 127673d1320455876-excel-2007-excel-gridlines-are-missing-fixed-acct-john-lamb-ch-5-10-11-2011
Sheet: E 5-13

a | financing
b | investing
c | financing
d | investing
e | operating - add
f | operating - add
g | noncash activity
h | financing
i | noncash activity
j | financing
k | operating - add
l | oper - deduct
m | oper - deduct