tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__18122__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-01-25 00:00:00 |  | 239.29 | 560 | 151.67 | 600
 | 2001-01-24 00:00:00 |  | 175 | 800 | 141.17 | 1200 | 131.25 | 2165 | 106.42 | 399
 | 2001-01-23 00:00:00 |  | 260 | 400 | 175.13 | 1600 | 153.02 | 1895 | 130.64 | 179
 | 2001-01-22 00:00:00 |  | 300 | 64 | 175 | 32 | 240.14 | 2002 | 135.3 | 335
 | 2001-01-21 00:00:00 |  | 175 | 0 | 130 | 0 | 156.73 | 1457 | 156.37 | 606
 | 2001-01-20 00:00:00 |  | 454 | 800 | 275.37 | 1080 | 176.21 | 3868 | 161.24 | 270
 | 2001-01-19 00:00:00 |  | 454 | 800 | 275.37 | 1080 | 206.29 | 1390 | 133.1 | 909
 | 2001-01-18 00:00:00 |  | 429.73 | 592 | 228.64 | 1704 | 275.21 | 3577 | 187.25 | 1153
 | 2001-01-17 00:00:00 |  | 235 | 160 | 150.91 | 880 | 284 | 1630 | 156.87 | 546
 | 2001-01-16 00:00:00 |  | 174.75 | 640 | 114.61 | 1264 | 198.32 | 1393 | 118.67 | 961
 | 2001-01-15 00:00:00 |  | 174.29 | 560 | 114.61 | 1264 | 163.34 | 2155 | 121.91 | 913
 | 2001-01-14 00:00:00 |  | 135 | 160 | 102.1 | 496 | 151.06 | 2920 | 119.25 | 1375
 | 2001-01-13 00:00:00 |  | 170 | 160 | 116.65 | 1696 | 149.38 | 3307 | 112.78 | 1208
 | 2001-01-12 00:00:00 |  | 167.65 | 544 | 116 | 2136 | 146.77 | 361 | 110.31 | 1207
 | 2001-01-11 00:00:00 |  | 159.09 | 704 | 116 | 2136 | 147.18 | 1708 | 100.51 | 774
 | 2001-01-10 00:00:00 |  | 150 | 960 | 94.32 | 2280 | 140.57 | 584 | 101.31 | 555
 | 2001-01-09 00:00:00 |  | 127.81 | 1024 | 77.19 | 912 | 156.86 | 390 | 88.91 | 1464
 | 2001-01-08 00:00:00 |  | 132.55 | 1024 | 76.1 | 912 | 127.42 | 1330 | 71.95 | 583
 | 2001-01-07 00:00:00 |  | 115 | 0 | 62.5 | 0 | 63.78 | 2249 | 57.2 | 1278
 | 2001-01-06 00:00:00 |  | 124.17 | 384 | 93.8 | 432 | 102.76 | 521 | 66.24 | 647
 | 2001-01-05 00:00:00 |  | 136.45 | 1216 | 93.11 | 528 | 129.45 | 1527 | 123.46 | 455
 | 2001-01-04 00:00:00 |  | 146.87 | 2016 | 88.03 | 912 | 125.05 | 1851 | 107.45 | 778
 | 2001-01-03 00:00:00 |  | 145.65 | 544 | 75.2 | 32 | 125.71 | 1965 | 99.79 | 652
 | 2001-01-02 00:00:00 |  | 151.43 | 224 | 80 | 32 | 120.29 | 1597 | 76.99 | 944
 | 2001-01-01 00:00:00 |  |  |  |  |  | 102.04 | 432 | 64.43 | 628
 | 2000-12-31 00:00:00 |  |  |  |  |  | 73.65 | 2126 | 66.14 | 1101
 | 2000-12-30 00:00:00 |  | 118.57 | 224 | 75 | 32 | 103.71 | 1824 | 100.69 | 360
 | 2000-12-29 00:00:00 |  | 140 | 64 | 103.1 | 232 | 139.65 | 2163 | 106.37 | 925
 | 2000-12-28 00:00:00 |  | 140 | 64 | 103.1 | 232 | 130.72 | 830 | 120.35 | 1115
 | 2000-12-27 00:00:00 |  | 200 | 64 | 160 | 200 | 121.92 | 1931 | 94.63 | 1065
 | 2000-12-26 00:00:00 |  | 275 | 64 | 203.1 | 232 | 124.96 | 2250 | 71.81 | 666
Spreadsheet: richard_shapiro__32401__Lisa - EIM Budget
Sheet: Scenario 2

Cost Center Owner
Cost Center Number
 | Please use this form only for Outside Services
 | Scenario 2:  Basic needs that are essential/necessary
 | Retainers and Identified Needs
 | [NAME] | Activity/Region | 2002 Est. $
 | Akin Gump | International Trade Retainer | 180000
 |  | Total:
 | [NAME]
 | [NAME] | Activity/Region | 2002 Est. $
 | Akin Gump | Steel Section 201 - Lobbying at the Administration Level | 100000
 |  | Total:
Spreadsheet: 8a8a653c-944c-4e4b-96b6-4db8471156a1
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 826407720323 | Leanne Faine & Favor | The Conqueror | 2006-02-07 | Compact Disc | Black Gospel | 13.99 | N | To Be Retired
Spreadsheet: 676916d1589056748-lookup-to-return-most-recently-dated-note-based-on-multiple-criteria-notes
Sheet: Note Entry

Date | Role | ID | Note
2020-05-05 00:00:00 | Manager | 7654 | note
2020-05-05 00:00:00 | Manager | 7654 | note
2020-05-05 00:00:00 | Manager | 3456 | Another note
2020-05-10 00:00:00 | Manager | 3456 | a test note
2020-05-11 00:00:00 | Peer | 7654 | sample
2020-05-07 00:00:00 | Peer | 7654 | this is a note
2020-05-08 00:00:00 | Peer | 7654 | a sample note
2020-05-05 00:00:00 | Peer | 1234 | here is a note
2020-05-09 00:00:00 | Peer | 7654 | Here is another
2020-05-08 00:00:00 | Peer | 3456 | I was asked to make a note
2020-05-06 00:00:00 | Peer | 3456 | Again we meet
Spreadsheet: daren_farmer__5682__HPLN0119
Sheet: Sheet1

HPLN0119.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - January 19, 2001
 |  |  |  |  |  | **Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-01-19 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | LS Teco Katy I/C |  | Enron | 0 | 10
Enron (S) |  | Oasis Sealy |  | Enron | 0 | 20
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 718116d1612989596-formula-to-consolidate-data-from-multiple-sheets-get-data-from-multiple-sheets
Sheet: 26

 |  |  | Date | 2021-01-26 00:00:00
Machine | From | To | Total Time | Failure Code | Extention Code | Delay Code | Equip. Name | Stoppage Code | Stoppage Description | Stoppage Category
Machine1 | 08:00:00 | 09:00:00 |  |  |  |  |  | 1000 | Stoppage 1 | Category 1
Machine1 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine2 | 12:00:00 | 13:00:00 |  |  |  |  |  | 1001 | Stoppage 3 | Category 3
Machine3 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 4 | Category 1
Machine4 | 8:00:00 | 9:00:00 |  |  |  |  |  | 1004 | Stoppage 3 | Category 4
Machine5 | 20:00:00 | 23:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine6 | 20:00:00 | 1 day, 0:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Spreadsheet: 778829d1651343682-get-number-of-seconds-between-two-dates-in-excel-excluding-part-of-weekend-and-holidays-removing-downtime
Sheet: Visualisation of Problem

Example 1 (Truncated Start & End)
start with Original Period
then remove the Downtime
which leaves Remaining Uptime (the desired results)
Example 2 (Truncated Start) |  | Start |  |  |  |  |  |  |  |  |  |  | End
start with Original Period
then remove the Downtime
which leaves Remaining Uptime (the desired results)
Example 3 (Truncated End) |  | Start |  |  |  |  |  |  |  |  |  |  | End
start with Original Period
then remove the Downtime
which leaves Remaining Uptime (the desired results)
Example 4 (No Truncation) |  | Start |  |  |  |  |  |  |  |  |  |  | End
start with Original Period
then remove the Downtime
which leaves Remaining Uptime (the desired results)
Spreadsheet: 165045d1340996354-countif-based-on-formatting-use-din-array-nopasswordthistime
Sheet: LookupByDirectorate

 |  |  |  | Course 1 | Course 2 | Course 3 | Course 4 | Course 5 | Course 6
 |  |  | OOD
 |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  | Annual | Annual | Annual | Annual | Annual
 | Director 1 | Team 1 | No of staff to be trained | NEED TO POPULATE
 |  |  | No of staff trained | NEED TO POPULATE
 |  |  | Percentage of target achieved
 | Director 1 | Team 2 | No of staff to be trained
 |  |  | No of staff trained
 |  |  | Percentage of target achieved
 | Director 1 | Team 3 | No of staff to be trained
 |  |  | No of staff trained
 |  |  | Percentage of target achieved
 | Director 2 | Team 1 | No of staff to be trained
 |  |  | No of staff trained
 |  |  | Percentage of target achieved
 | Director 2 | Team 2 | No of staff to be trained
 |  |  | No of staff trained
 |  |  | Percentage of target achieved
 | Director 2 | Team 3 | No of staff to be trained
 |  |  | No of staff trained
 |  |  | Percentage of target achieved
Spreadsheet: 678834d1590077992-combining-countif-with-lookup-and-counting-averages-where-data-might-not-exist-golf-2020_draft
Sheet: CourseData

Course | 9 hole par | 18 hole par |  | Par Hole 1 | Par Hole 2 | Par Hole 3 | Par Hole 4 | Par Hole 5 | Par Hole 6 | Par Hole 7 | Par Hole 8 | Par Hole 9 | Par Hole 10 | Par Hole 11 | Par Hole 12 | Par Hole 13 | Par Hole 14 | Par Hole 15 | Par Hole 16 | Par Hole 17 | Par Hole 18 |  | Index Hole 1 | Index Hole 2 | Index Hole 3 | Index [NAME] | Index Hole 5 | Index Hole 6 | Index Hole 7 | Index Hole 8 | Index Hole 9 | Index Hole 10 | Index Hole 11 | Index Hole 12 | Index Hole 13 | Index Hole 14 | Index Hole 15 | Index Hole 16 | Index Hole 17 | Index Hole 18
Bromma |  |  |  | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 4 |  | 11 | 5 | 7 | 13 | 15 | 9 | 3 | 17 | 1 | 12 | 6 | 8 | 14 | 16 | 10 | 4 | 18 | 2
Hässelby |  |  |  | 3 | 4 | 3 | 4 | 3 | 3 | 3 | 3 | 4 | 3 | 4 | 3 | 4 | 3 | 3 | 3 | 3 | 4 |  | 11 | 13 | 7 | 1 | 5 | 9 | 15 | 17 | 3 | 12 | 14 | 8 | 2 | 6 | 10 | 16 | 18 | 4
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Christopher Pearson

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
No response
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
I'd like to explain my position
Explain your health care reform position, if you choose
We must move to a universal, single payer system. That means, everyone in, everyone pays. Teachers will no
longer have to bargain over health care and presumably, as a large employer, districts will see a savings. I will
fight to see those passed along to teachers but am uncomfortable giving teachers or any sector of employee
special treatment when we shift to single payer.
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
No response
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
No response
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 12 Brookes Ave, Burlington, VT  05401 | State Representative | Yes |  | Chittenden
Spreadsheet: 266859d1379788340-help-with-sumif-forumula-lakewestassessment
Sheet: Section 3

 | Instructor:  [NAME]
Student Number | Major | Classification | Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 | Q9 | Q10
41 | MNGT | Freshman | a | c | d | b | a | b | c | c | e | a
42 | ACCT | Senior | a | d | e | b | a | b | c | c | e | a
43 | MNGT | Sophomore | a | d | d | b | a | b | c | c | e | a
44 | MRKT | Junior | a | a | d | b | a | d | c | c | e | a
45 | MIS | Freshman | a | c | c | b | a | b | c | c | e | a
46 | FIN | Freshman | a | b | d | b | a | b | c | c | e | a
47 | MIS | Freshman | a | c | d | b | a | c | c | c | e | a
48 | ACCT | Sophomore | a | c | d | c | a | b | c | c | d | c
49 | MIS | Junior | a | c | d | b | a | b | c | c | a | b
50 | ECON | Freshman | b | c | d | b | a | d | c | c | d | d
51 | MRKT | Sophomore | a | c | d | c | b | c | c | c | e | a
52 | MNGT | Senior | a | c | d | b | a | c | c | c | e | a
53 | ACCT | Sophomore | a | c | d | b | c | d | c | c | e | a
54 | FIN | Sophomore | a | c | d | b | c | b | c | c | e | a
55 | ACCT | Sophomore | b | c | e | b | a | b | c | c | e | a
56 | MRKT | Freshman | a | c | c | d | a | b | c | c | e | a
57 | MIS | Junior | a | c | d | b | a | b | c | c | e | a
58 | MNGT | Sophomore | d | c | d | b | a | b | c | c | e | a
59 | ECON | Junior | a | c | d | b | a | b | c | c | e | a
60 | ECON | Sophomore | a | a | e | b | a | b | a | c | e | a
Spreadsheet: 767957d1644756616-rank-multiple-criteria-with-duplicate-ties-urc-2021-22-table
Sheet: Sheet1

 |  | 2 |  |  | 5 |  | 3 | 1 | 4 |  | 6
 | P | W | D | L | F | A | Diff | League Pts | Tries For | Tries Against | Tries Diff | Ranked by Column I | Final Ranking
[NAME] | 10 | 7 | 0 | 3 | 241 | 160 | 81 | 36 | 32 | 19 | 13 |  | 1
Edinburgh | 9 | 6 | 1 | 2 | 224 | 147 | 77 | 34 | 31 | 16 | 15 |  | 4
Warriors | 9 | 6 | 0 | 3 | 240 | 177 | 63 | 31 | 31 | 19 | 12 |  | 3
Leinster | 8 | 6 | 0 | 2 | 246 | 114 | 132 | 30 | 34 | 12 | 22 |  | 2
Munster | 8 | 6 | 0 | 2 | 209 | 124 | 85 | 29 | 28 | 12 | 16 |  | 5
Ospreys | 10 | 6 | 0 | 4 | 203 | 238 | -35 | 26 | 17 | 31 | -14 |  | 6
[NAME] | 9 | 4 | 1 | 4 | 193 | 205 | -12 | 23 | 24 | 27 | -3 |  | 7
Connacht | 10 | 4 | 0 | 6 | 238 | 253 | -15 | 20 | 31 | 32 | -1 |  | 9
Cardiff | 7 | 4 | 0 | 3 | 159 | 175 | -16 | 18 | 15 | 18 | -3 |  | 10
Stormers | 8 | 3 | 2 | 3 | 171 | 181 | -10 | 18 | 19 | 22 | -3 |  | 8
Sharks | 8 | 3 | 1 | 4 | 194 | 208 | -14 | 16 | 20 | 23 | -3 |  | 11
Scarlets | 7 | 3 | 0 | 4 | 157 | 206 | -49 | 16 | 17 | 29 | -12 |  | 13
Bulls | 8 | 3 | 0 | 5 | 146 | 184 | -38 | 16 | 10 | 19 | -9 |  | 12
Lions | 8 | 2 | 0 | 6 | 157 | 222 | -65 | 12 | 18 | 29 | -11 |  | 14
Dragons | 8 | 1 | 1 | 6 | 144 | 187 | -43 | 11 | 16 | 20 | -4 |  | 15
Zebre | 7 | 0 | 0 | 7 | 83 | 224 | -141 | 1 | 9 | 23 | -14 |  | 16
Spreadsheet: 809491d1671116147-ranking-formular-rank333
Sheet: WAVULANA 5 BORA NA 5 DUNI

MTIHANI WA MUHULA WA KWANZA DARSA LA III JULAI, 2022
[NAME] BORA
NA | JINA | JINSI 1=MV 2=MS | SHULE | KATA | MASOMO |  |  |  |  |  |  |  |  |  |  |  | JUMLA | WASTANI | DARAJA
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D
1
2
3
4
5
[NAME] DUNI
NA | JINA | JINSI 1=MV 2=MS | SHULE | KATA | MASOMO |  |  |  |  |  |  |  |  |  |  |  | JUMLA | WASTANI | DARAJA
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D
1
2
3
4
5
Spreadsheet: a2a3dc55-0cf3-4332-95d7-d5e875acd509
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4341 | 10412 | [NAME] | Beven | AUS | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:00:00
Spreadsheet: 758103d1638645443-calculate-pro-rata-based-on-start-end-date-pro-rata-mock-up
Sheet: Sheet4

Input |  |  |  |  | Desired Output |  |  |  |  |  | Comment
cost category | date from | date to |  | days | 2017 | 2018 | 2019 | 2020 | 2021
Water | 2017-04-01 00:00:00 | 2017-11-06 00:00:00 |  |  | 219 | 0 | 0 | 0 | 0 |  | date range only in 2017, hence all days are attributed to 2017
Heating | 2017-10-01 00:00:00 | 2018-03-31 00:00:00 |  |  | 91 |  | 0 | 0 | 0 |  | date range covers 91 days in 2017 and 90 days in 2018
Spreadsheet: 716303d1612167390-dynamic-indirect-substitutes-all-default-to-errors-dynamic-indirect-dependents-all-evaluate-to-errors
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | CATEGORY |  | Product |  | Brand |  | Type / Range |  | Colour / Code
 |  |  |  |  |  |  |  |  |  |  | Interior Paint |  | Interior Paint |  | Interior Walls |  | Brand A Interior Walls |  | Brand A Satinwood
 |  |  |  |  |  |  |  |  |  |  | Exterior Paint |  | Interior Walls |  | Brand A Interior Walls |  | Brand A Satinwood |  | Colour 1 - Code Whatever
 |  |  |  |  |  |  |  |  |  |  | Carpet |  | Internal Woodwork |  | Brand B Interior Walls |  | Brand A Gloss |  | [NAME] Whatever
 |  |  |  |  |  |  |  |  |  |  |  |  | TBC by Client |  | Brand C Interior Walls |  | Brand A Silk |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TBC by Client |  | TBC by Client |  | TBC by Client
 |  | All Dependents evaluate to Errors
 | Category | Product | Brand | Type / Range | Colour / Code
 | Interior Paint | Interior Walls
 |  |  |  |  |  |  |  |  | Interior Walls
 |  | S/be three choices from Col N assume select Interior Walls |  |  |  |  |  |  | Internal Woodwork
 |  |  |  |  |  |  |  |  | TBC by Client
 |  |  | S/be four choices from Col P - Assume choose Brand A
 |  |  |  | S/be four choices from Col R - Assume choose Satinwood
 |  |  |  |  | S/be four choices from Col T - Assume choose Colour 1
Spreadsheet: 47284d1246308764-job-hour-summary-using-daily-pivot-totals-can-it-be-done-weekly-timesheet-summary-7-days-
Sheet: Tuesday

2009-01-13 00:00:00 | Tuesday
Job # | Employee | Total Hours
870 |  | 9.5
 | [NAME] | 1.5
 | [NAME] | 8
1223-5567 |  | 16
 | [NAME] | 8
 | [NAME] | 8
5553-6789 |  | 6.5
 | [NAME] | 6.5
5553-6788 |  | 1.5
 | [NAME] | 1.5
shop |  | 18
 | [NAME] | 6
 | [NAME] | 4
 | [NAME] | 8
4321-8888 |  | 6
 | [NAME] | 6
4321-8877 |  | 2
 | [NAME] | 2
3345-8676 |  | 2.5
 | Cecil Elliot | 2.5
3321-3456 |  | 3
 | Cecil Elliot | 3
yard |  | 2.5
 | Cecil Elliot | 2.5
7445-1234 |  | 3
 | [NAME] | 3
7445-1235 |  | 2.5
 | [NAME] | 2.5
7445-1236 |  | 1.5
 | [NAME] | 1.5
7445-1237 |  | 1
 | [NAME] | 1
out |  | 0
 | Chase Payne | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 0
 | Pascual Mateo | 0
shipping office |  | 9.5
 | [NAME] | 8
 | [NAME] | 1.5
6789-9432 |  | 6.5
 | [NAME] | 6.5
6789-9433 |  | 1.5
 | [NAME] | 1.5
4567-9089 |  | 4
 | [NAME] | 4
5678-2345 |  | 4
 | [NAME] | 4
shop/tool manitenance |  | 2
 | [NAME] | 2
4567-7543 |  | 10
 | [NAME] | 4.5
 | [NAME] | 5.5
2386-9045 |  | 3
 | [NAME] | 3
4568-8467 |  | 3
 | [NAME] | 3
870 |  | 2
 | [NAME] | 2
4567-8211 |  | 3
 | [NAME] | 3
4567-8210 |  | 2.5
 | [NAME] | 2.5
4568-9832 |  | 3.5
 | [NAME] | 2
 | [NAME] | 1.5
7464-9474 |  | 2.5
 | [NAME] | 2.5
load trucks |  | 7.5
 | [NAME] | 4
 | [NAME] | 3.5
3450-6743 |  | 5.5
 | [NAME] | 3
 | [NAME] | 2.5
5678-3832 |  | 11
 | [NAME] | 3.5
 | [NAME] | 3.5
 | [NAME] | 4
3456-9876 |  | 9.5
 | [NAME] | 4
 | [NAME] | 2
 | [NAME] | 3.5
4321-7797 |  | 7
 | [NAME] | 2.5
 | [NAME] | 4.5
896 |  | 3
 | [NAME] | 3
sales |  | 5
 | [NAME] | 5
Grand Total |  | 181
Spreadsheet: 593323d1539093441-return-true-false-na-when-comparing-between-multiple-columns-between-2-rows-equipment
Sheet: Before

Equipment Plate No. | Old ID Number | New ID Number | Location Tag | Reason
A1234 | - | 86 | Side Cover | Equipment Arrival
A5678 | - | 89 | Side Cover | Equipment Arrival
A1234 | 89 | 90 | Side Cover | Maintenance
A5678 | 89 | 97 | Side Cover | Maintenance
Spreadsheet: 738013d1624745386-filter-table-based-on-dropdown-list-filter-table-on-dropdown
Sheet: Sheet1

 |  | Country Dropdown |  | USA |  |  | Unique Country List
 |  | Product | Country | Amount |  |  | Mexico
 |  | Widget 1 | USA | 100 |  |  | Canada
 |  | Widget 2 | Mexico | 345
 |  | Widget 3 | USA | 753
 |  | Widget 4 | Mexico | 123
 |  | Widget 5 | Canada | 567
 |  | Widget 6 | USA | 876
Spreadsheet: 757301d1638182684-sorting-all-barcodes-that-contain-dashes-and-without-dashes-excelforum29-11
Sheet: took original to print 

 |  |  |  | Perferred display of barcode
Barcode | Location |  |  | Barcode | Location
10030 | C9 |  |  | 10007-01 | D1
10032 | C9 |  |  | 10007-02 | D1
10041 | C9 |  |  | 10007-03 | D1
10049 | C9 |  |  | 10007-04 | D1
10052 | C9 |  |  | 10007-05 | D1
10007-01 | D1 |  |  | 10007-14 | D1
10007-02 | D1 |  |  | 10007-20 | D1
10007-03 | D1 |  |  | 10007-21 | D1
10007-04 | D1 |  |  | 10007-142 | D1
10007-05 | D1 |  |  | 10007-143 | D1
10007-14 | D1 |  |  | 10012-01 | D9
10007-142 | D1 |  |  | 10012-05 | D9
10007-143 | D1 |  |  | 10012-11 | D9
10007-20 | D1 |  |  | 10030 | C9
10007-21 | D1 |  |  | 10032 | C9
10012-01 | D9 |  |  | 10041 | C9
10012-05 | D9 |  |  | 10049 | C9
10012-11 | D9 |  |  | 10052 | C9
11256-01 | A1 |  |  | 11256-01 | A1
11256-02 | A1 |  |  | 11256-02 | A1
Spreadsheet: 128996d1321391743-create-named-list-range-based-on-check-list-named-range
Sheet: Sheet1

a |  |  |  | d | 1 |  | named range" test"
b |  |  |  | g | 2
c |  |  |  | k
d | x | 4 |  | p
e |  |  |  | s
f
g | x | 7
h
i
j
k | x | 11
l
m
n
o
p | x | 16
q
r
s | x | 19
t
Spreadsheet: jane_tholt__13174__Attachment 13 filed 11-13 
Sheet: Sheet2

 |  |  |  | NCP | CONV. FR | MAINLNE |  | %CD/NCP | %SHORTFALL/NCP
 |  |  |  |  | CD DEL ALLOC | ALLOCATION | SHORTFALL
 | SUMMER EAST END
 | SUMMER FT-2
 | SUMMER WEST END
 | SUMMER FT-2
 | WINTER EAST END
 | WINTER FT-2
 | WINTER WEST END
 | WINTER FT-2
Spreadsheet: 850383d1700736092-inserting-names-to-different-sheets-from-a-single-master-sheet-test
Sheet: MASTER

NAME
SURNAME | FIRST | GRP 1 | GRP 2
Smith | [NAME] | x | x
Rogers | [NAME] |  | x
Walker | Mick | x
[NAME] | [NAME] |  | x
Walter | Mat | x
Jones | [NAME] |  | x
Spreadsheet: daren_farmer__5079__HPLN0601
Sheet: Sheet1

HPLN0601.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - June 01, 2001
 |  |  |  |  |  | **Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-06-01 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Sandhills |  | Enron | 8 | 0
Enron (S) |  | [NAME] TOG #3 |  | Enron | 0 | 13
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 124621d1318513641-help-with-sumif-sumproduct-formulas-sample-bc
Sheet: Jan

Acct | Consolidated | Location 1 | Location 2 | Location 3
supplies |  | 2 | 5 | 8
insurance |  | 4 | 6 | 9
office |  | 8 | 7 | 9
Selected Location
Spreadsheet: 52898d1252727662-help-with-spreadsheet-design-if-then-or-vlookup-with-mulitple-scenarios-qty-pricing
Sheet: Sheet1

Item# | Description | Color | Size | Price Level | Qty Reqd | Price
1 | Widget | Red | Large | 1 | 1 | 100
1 | Widget | Red | Large | 2 | 10 | 95
1 | Widget | Red | Large | 3 | 25 | 90
1 | Widget | Red | Large | 4 | 50 | 80
1 | Widget | Red | Large | 5 | 100 | 75
1 | Widget | Red | Large | 6 | 200 | 60
2 | Whatsit | Blue | Small | 1 | 1 | 80
2 | Whatsit | Blue | Small | 2 | 10 | 78
2 | Whatsit | Blue | Small | 3 | 25 | 72
2 | Whatsit | Blue | Small | 4 | 50 | 64
2 | Whatsit | Blue | Small | 5 | 100 | 60
2 | Whatsit | Blue | Small | 6 | 200 | 48
Item# | Description | Color | Size | PL QTY1 | Price1 | PL QTY2 | Price2 | PL QTY3 | Price3 | PL QTY4 | Price4 | PL QTY5 | Price5 | PL QTY6 | Price6
1 | Widget | Red | Large | 1 | 100 | 10 | 95 | 25 | 90 | 50 | 80 | 100 | 75 | 200 | 60
2 | Whatsit | Blue | Small | 1 | 80 | 10 | 78 | 25 | 72 | 50 | 64 | 100 | 60 | 200 | 48
 |  | Type Item # | Type Qty | Excel Returns Price
 |  | 1 | 105 | 75
 | Color Code |  | user eters
 |  |  | excel retuned answer
Spreadsheet: 740046d1626163822-tracking-countif-sample
Sheet: Participants

 |  |  |  | [NAME]
 | Join
 |  |  |  |  | Aug | Sep | Oct | Nov | Dez | Jan | Feb | Mar
Participant 1 | 2021-08-01 00:00:00 |  |  | Group 1
Participant 2 | 2021-09-01 00:00:00
Participant 3 | 2021-10-01 00:00:00
Participant 4 | 2021-11-01 00:00:00
Participant 5 | 2021-12-01 00:00:00
Participant 6 | 2022-01-01 00:00:00
Participant 7 | 2022-02-01 00:00:00
Participant 8 | 2022-03-01 00:00:00
Participant 9 | 2022-04-01 00:00:00
Participant 10 | 2022-05-01 00:00:00
Participant 11 | 2022-06-01 00:00:00
Participant 12 | 2022-07-01 00:00:00
Participant 13 | 2022-08-01 00:00:00
Participant 14 | 2022-09-01 00:00:00
Participant 15 | 2022-10-01 00:00:00
Participant 16 | 2022-11-01 00:00:00
Participant 17 | 2022-12-01 00:00:00
Participant 18 | 2023-01-01 00:00:00
Participant 19 | 2023-02-01 00:00:00
Participant 20 | 2023-03-01 00:00:00
Participant 21 | 2023-04-01 00:00:00
Participant 22 | 2023-05-01 00:00:00
Participant 23 | 2023-06-01 00:00:00
Spreadsheet: 730379d1619681381-extracting-and-arranging-data-salary-1-ans-3
Sheet: Expected Result

 |  | JVN0711 | JVN0711 | JVN0711 | JVN0084 | JVN0084 | JVN0084
 |  | Salary | PF | GT | Salary | PF | GT