tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 848443d1699191901-excel-formular-for-receipts-contents-invoice-vat
Sheet: Sales

 | SALES
 | Date | Invoice | Product | Code | Quantity | Unit Per Price | Net Amount | VAT | Amount VAT | Customer
 | 2023-04-12 00:00:00 | BK 002 | PLASTIC ICING |  | 1 | 2 |  | 0.15 |  | Cash sale
 | 2023-04-12 00:00:00 | BK 002 | YELLOW |  | 3 | 2 |  | 0.15 |  | Cash sale
 | 2023-04-12 00:00:00 | BK 003 | YELLOW |  | 2 | 2 |  | 0.15 |  | Bake Now (Pvt) Ltd
 | 2023-04-12 00:00:00 | BK 004 | BROWN |  | 4 | 2 |  | 0.15 |  | Bake Now (Pvt) Ltd
 | 2023-04-12 00:00:00 | BK 005 | Red Velvet |  | 1 | 40 |  | 0.15 |  | Bake Now (Pvt) Ltd
 | 2023-04-12 00:00:00 | BK 006 | CASTOR |  | 1 | 70 |  | 0.15 |  | OK
 | 2023-04-13 00:00:00 | BK 006 | TOPPERS |  | 2 | 4 |  | 0.15 |  | OK
 | 2023-04-14 00:00:00 | BK 006 | CASTOR |  | 4 | 4 |  | 0.15 |  | OK
 | 2023-04-15 00:00:00 | BK 006 | GREEN |  | 2 | 1 |  | 0.15 |  | OK
Spreadsheet: john_lavorato__16473__poker2
Sheet: Sheet2

name | liabilities | assets | Wed | Thur | Total |  | edward | [NAME] | dayao | fitzgerald | whalley | gold | sheriff | seyfried
richter | 2500 |  |  | 22230 |  | x |  | -55 |  |  | -2320 |  | -8860 |  |  |  | richter - being the big winner - absorbs computational error of 145 (not bad considering the total amount involved)
pickering | 3250 | 6085 |  | 3555 |  | x |  |  | -1530 |  |  | -4860
[NAME] | 4970 | 3475 |  | 7550 |  | x |  | -780 |  | -2955 | -2320
black |  |  |  | 2200 |  | x |  |  |  |  |  |  |  | -2200
haug |  |  |  | 1745 |  |  | -310 | -300 | -235
pope | 3515 | 4380 |  | 435 |  | x |  |  |  |  |  |  | -1300
edward | 310
[NAME] | 1135
dayao | 3100 | 4200 |  | -2865 |  | xx
fitzgerald | 3600 | 6475 |  | -5830 |  | x
whalley |  |  |  | -4640 |  | x
gold | 4225 |  |  | -635 |  | x
sheriff | 300 | 2320 |  | -12180 |  | x
seyfried |  |  |  | -11450 |  | x
 |  |  |  |  |  | checksum
 |  |  |  |  |  | pay: | [NAME] pays haug 310
 |  |  |  |  |  | pay: |  | [NAME] pays richter(55), lavorato(780), [NAME])
 |  |  |  |  |  | pay: |  |  | dayao pays pickering (1530), haug (235)
 |  |  |  |  |  | pay: |  |  |  | [NAME] pays [NAME] (2955)
 |  |  |  |  |  | pay: |  |  |  |  | [NAME] richter (2320), [NAME] (2320)
 |  |  |  |  |  | pay: |  |  |  |  |  | gold pays pickering (486)
 |  |  |  |  |  | pay: |  |  |  |  |  |  | sheriff pays richter (8860), [NAME] (1300)
 |  |  |  |  |  | pay: |  |  |  |  |  |  |  | seyfried pays richter (8350), black (2200), haug (900)
Spreadsheet: daren_farmer__6608__TransportFlash
Sheet: 9906

June 1999 Transport Expense Flash
 |  |  | Commodity Expenses |  | Demand Charges |  | Comments
Texas Co. 78 |  |  |  |  |  |  | Long term deal commodity expense
Texas Co. 78 |  |  | 1031.8 |  |  |  | payable to Pan Grande Pipeline 96019628
Texas Co. 16 |  |  | 108114.89 |  |  |  | payable to Oasis Pipeline- 96015445/96016667/96019481/96019482
Texas Co. 16 |  |  | 176601.79 |  |  |  | payable to PG&E/Valero 96006479/96006482/96009903/96016601
Texas Co. 16 |  |  | 7776 |  |  |  | payable to Channel Industries-96017837
Texas Co. 16 |  |  | 0 |  |  |  | payable to Lone Star
Texas Co. 16 |  |  | 9451.24 |  |  |  | payable to Black Marlin - Offshore - 96006608
Texas Co. 16 |  |  |  |  |  |  | payable to Northern Natural Gas - 96020553
Texas Co. 16 |  |  |  |  | 93300 |  | Centana Storage Demand Charge - 96019236
Texas Co. 16 |  |  |  |  | 15000 |  | Tennessee/800 to HPL-Sabine Demand Charge - payable to East Desk
Totals
DEMAND CHARGE NOTES: |  |  | $15,000 demand charge is in line 25 of OA Flash Page
 |  |  | $93,300 demand charge is in line 36 of OA Flash Page
Spreadsheet: 777104d1650167103-count-no-of-cases-based-on-a-given-date-range-excelforum_countnocase-2
Sheet: Defect

 | S/No | Car | Defect | WO/JR No. | Since | Status | Clear | >3 | No of Case | >7
 | 1 | 28 |  | NA | 2021-12-01 00:00:00 | Pending Investigation | 2021-12-10 00:00:00
 | 2 | 16 |  | NA | 2021-12-08 00:00:00 | Pending Investigation | 2021-12-31 00:00:00
 |  | 5 |  |  | 06-12-21
Spreadsheet: 859507d1707888393-getting-last-entry-for-a-year-book1
Sheet: Sheet1

Date | Action | Qty | CS | DS | DP | CS1 | CP1 |  |  | DS Total | DS Median | first of year | Last of year
2023-06-21 00:00:00 | p | 295 | 3.85 |  |  |  |  |  | 2023 |  |  | 12.32 |  | Wrong answer
2023-09-20 00:00:00 | p | 13 | 3.87
2023-10-04 00:00:00 | d | 3.394 | 3.62994 |  |  |  |  |  |  |  | Correct answer is in cell F10 is |  | 12.68
2023-11-03 00:00:00 | d | 3.727 | 3.34317
2023-11-07 00:00:00 | p | 1 | 3.5
2023-11-20 00:00:00 | p | 1 | 3.68
2023-12-05 00:00:00 | d | 3.409 | 3.71957
2024-01-01 00:00:00 | p | 1 | 3.86 |  |  |  |  |  | 2024 |  |  |  |  | Wrong answer
2024-01-16 00:00:00 | d | 3.336 | 3.84293
2024-02-02 00:00:00 | d | 3.455 | 3.75977 |  |  |  |  |  |  |  | Correct answer is in cell F10 is |  | 11.74791
2024-02-10 00:00:00 | d | 3.115 | 3.7714
2025-07-08 00:00:00 | d | 3.478 | 3.978
 |  |  |  |  |  | Both forfmulas in cell N4 and cell N11 go to the last enter in the column and do not stop at the end of year.
Spreadsheet: 714830d1611394629-how-to-add-multiple-columns-based-on-criteria-in-rows-sum-columns-based-on-crieteria-on-rows-2-
Sheet: Sheet2

 | Destination | Sales R | Product | Wk-1 | Wk-2 | Wk-3 | Wk-4 | Wk-5 | Wk-6 | Wk-7 | Wk-8 | Wk-9 | Wk-10
 | US | All | Course | 151 | 138 | 135 | 198 | 104 | 103 | 178 | 198 | 152 | 106
 | Canada | Asia | Accommodation | 124 | 185 | 187 | 185 | 194 | 171 | 168 | 122 | 121 | 123
 | US | [NAME] | Course | 198 | 146 | 164 | 140 | 161 | 199 | 171 | 123 | 105 | 126
 | Canada | All | Course | 160 | 171 | 169 | 148 | 178 | 139 | 107 | 191 | 196 | 200
 | UK | Asia | Accommodation | 149 | 176 | 139 | 109 | 150 | 181 | 112 | 131 | 155 | 135
 |  |  | From Week | Wk-3
 |  |  | To Week | Wk-10
 |  |  | Destination | US
 |  |  | Sales R | [NAME]
 |  |  | Product | Course
 |  |  | Sum
 |  |  | In the above I just created a total for week 3 to week 10 for just the figures at row 7.  I want my formula to give me the sum in the yellow highlighted cells
 |  |  | based on the ctriteria in green above
Spreadsheet: 164402d1340746395-add-rows-if-referenced-cells-in-another-sheet-contain-data-excel-help
Sheet: Sheet1 (2)

 | Ment Project Summary List
 | 2012-06-26 17:24:24
 | Phase: | Description | Reference: | LF/SF: | Quantities: | Connections: | Material: | Finish:
 | 30 | Tube Framing | S-102 (Plan) | 82 LF rail | 19 posts | bolted w/baseplates | carbon steel | shop prime
 |  |  | A-401 (Section)
 |  |  | A-601 ([NAME])
 | 1 | Spiral Staircase
 | 22 | Railings at Roof
 | 2 | Metal Pan Stair
 | 40 | Pit Frames and Hatches
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
Spreadsheet: 719980d1613952477-project-gantt-with-partial-days-weekends-holidays-and-employee-vactions-taskgantt
Sheet: Sheet2

 |  |  |  |  | 22 |  |  |  | 23 |  |  |  | 24 |  |  |  | 25 |  |  |  | 26 |  |  |  | 27 | 28 | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5
FEATURE | BACKLOG ITEM | Effort | Start Date | End Date | M |  |  |  | T |  |  |  | W |  |  |  | T |  |  |  | F |  |  |  | S | S | M |  |  |  | T |  |  |  | W |  |  |  | T |  |  |  | F
Parent Task |  | 4.75 | 2021-02-22 00:00:00 | 2021-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This chart represents the tasks for one employee.
 | Child Task 1 | 1 | 2021-02-22 00:00:00 | 2021-02-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The Red in the Parent Task and the darker Red in Child Task 7
 | Child Task 2 | 0.25 | 2021-02-23 00:00:00 | 2021-02-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | represents 1 day of vaction taken to extend that project to the
 | Child Task 3 | 0.5 | 2021-02-23 00:00:00 | 2021-02-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | following Monday. (Expect to do the same for holidays.)
 | Child Task 4 | 1 | 2021-02-23 00:00:00 | 2021-02-24 00:00:00
 | Child Task 5 | 0.5 | 2021-02-24 00:00:00 | 2021-02-25 00:00:00
 | Child Task 6 | 0.5 | 2021-02-25 00:00:00 | 2021-02-25 00:00:00
 | Child Task 7 | 1 | 2021-02-25 00:00:00 | 2021-03-01 00:00:00
Spreadsheet: 542140d1507726420-overview-total-time-registration-with-names-codes-sample-time-registration-total
Sheet: Feb

Time registrations
February | 2017
Name | Project | 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 | Total
Piet | 55 | 2 | 2 |  |  |  |  | 2 | 4 | 3 |  |  |  |  | 2 | 3 | 2 | 1 |  |  | 1 | 5 | 1 | 2
Piet | 25 | 1 |  |  |  |  |  | 1 |  | 3 |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
Piet | 91 | 1 | 2 | 1 |  |  |  | 1 | 2 |  |  |  |  |  | 3 | 3 | 1 | 4 |  |  | 1 |  | 1 | 2
Piet | 92 |  | 2 |  |  |  |  | 3 |  |  |  |  |  |  | 1 | 2 | 6 |  |  |  | 1 | 5 | 6 | 4 |  |  |  |  | 2
Jan | 84 | 1 | 1 | 1 |  |  |  | 1 | 2 | 2 | 2 |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  | 1
Jan | 94 |  | 2
Jan | 11 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 |  | 2
Jan | 72 |  |  |  |  |  |  | 4 | 8 | 8 | 8 |  |  |  | 8 | 8 |  |  | 10 | 10 |  |  |  |  |  |  |  | 8 | 8
Kees | 77 |  | 8 | 8 |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8 |  |  | 8 | 8 | 8 | 8
Kees | 94 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 |  |  | 2 | 2 | 2 |  | 4
Kees | 26 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8
Hanna | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8 | 8 | 8
Hanna | 94 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
Hanna | 26 | 8 | 8 |  |  |  | 8 | 8 | 8 | 8 | 6 |  |  |  | 5 | 7 | 8 |  |  |  | 8 | 6 | 8 | 8
Hanna | 55 |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8
Fred | 22 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.5 |  |  |  | 8 | 8 | 8 | 8 | 8 | 6 | 3 | 8 | 8
Fred | 54 |  | 8 | 8 |  |  | 8 | 7 | 9 | 8 | 5 |  |  | 8 | 8 | 5 |  | 8
Fred | 54 |  |  | 8 |  |  |  | 8 |  | 7.5
Fred | 91 | 8 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  | 2 | 6 | 8 | 7 | 6 | 8 |  |  | 8 | 8
Fred | 94 |  |  |  |  |  |  |  |  |  | 2 | 6 | 6 | 6 |  |  | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 6
Spreadsheet: 715186d1611594820-help-needed-with-formula-to-count-how-many-times-a-team-wins-power-rankings
Sheet: DE DATA

 | First Place | Second Place | Third Place
ANA
ARI
BOS
BUF
CGY
CAR
CHI
COL
CBJ
DAL
DET
EDM
FLA
LAK
MIN
MTL
NSH
NJD
NYI
NYR
OTT
PHI
PIT
SEA
SJS
STL
TBL
TOR
VAN
VGK
WSH
WPG
Spreadsheet: 177601d1346355656-how-to-populate-workbook-pages-from-microsoft-query-copy-of-total-misses-for-period-6
Sheet: 7-317

 |  |  |  |  |  |  |  | 7-317
 |  |  |  |  |  |  |  | TOTAL MISSES FOR THIS PAY PERIOD
CHPUB | CHACT# | CHDIST | CHRTE | CHTIME | CHTTYP | CHTRCD | UNNBR | PREDIR | STREET | SUFFIX | PSTDIR | SUNTYP | SUNNBR | POZIP5 | CHSTAT | CHSMM | CHSDD | CHSYY
Spreadsheet: 740776d1626566685-auto-calculate-end-date-sample
Sheet: Sheet2

Machine | Allocated Hours | start date | End Date | Date | Day | Working hours
Machine 1 | 30.25 | 2021-07-17 10:35:00 |  | 2021-07-17 00:00:00 |  | 7
Machine 2 | 30.25 | 2021-07-18 14:00:00 |  | 2021-07-18 00:00:00 |  | 7
Machine 3 | 30.25 | 2021-07-19 09:00:00 |  | 2021-07-19 00:00:00 |  | 7
Machine 4 | 30.25 | 2021-07-20 14:00:00 |  | 2021-07-20 00:00:00 |  | 7
Machine 5 | 30.25 | 2021-07-21 14:00:00 |  | 2021-07-21 00:00:00 |  | 0
Machine 6 | 37.25 | 2021-07-22 13:00:00 |  | 2021-07-22 00:00:00 |  | 0
Machine 7 | 40.25 | 2021-07-23 00:00:00 |  | 2021-07-23 00:00:00 |  | 0
Machine 8 | 30.25 | 2021-07-24 12:00:00 |  | 2021-07-24 00:00:00 |  | 7
Machine 9 | 30.25 | 2021-07-25 00:00:00 |  | 2021-07-25 00:00:00 |  | 7
Machine 10 | 30.25 | 2021-07-26 00:00:00 |  | 2021-07-26 00:00:00 |  | 7
Machine 11 | 30.25 | 2021-07-27 00:00:00 |  | 2021-07-27 00:00:00 |  | 7
Spreadsheet: f9a2ba37-0c4d-4fa8-85a7-69b7145b5def
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME | PROGRAM
4492 | 10412 | [NAME] | Beven | AUS | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 01:48:52 | Elite Men
4492 | 5308 | Hamish | [NAME] | NZL | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 01:48:58 | Elite Men
4492 | 14920 | [NAME] | Macmartin | CAN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 01:48:59 | Elite Men
4491 | 15387 | Erin | [NAME] | NZL | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 02:03:19 | Elite Women
4491 | 5384 | Rina | Hill | AUS | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 02:04:06 | Elite Women
4491 | 10334 | [NAME] | Smyers | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 02:37:13 | Elite Women
Spreadsheet: john_griffith__16229__2_1_02GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 60 | 580 | 620 | 47.4 | 50.6 | 1.85 | 2002-02-01 15:09:00
 | [NAME] | 66 | 940 | 1000 | 47.6 | 50.6 | 2.04 | 2002-02-01 15:09:00
 | [NAME] | 67 | 1100 | 1200 | 43.6 | 47.6 | 1.92 | 2002-02-01 15:09:00
 | [NAME] | 67 | 1250 | 1350 | 42.1 | 45.5 | 1.84 | 2002-02-01 15:09:00
 | HU N2 | 67 | 1280 | 1380 | 38.8 | 41.9 | 1.7 | 2002-02-01 15:09:00
 | [NAME] | 65 | 1340 | 1440 | 38.1 | 41 | 1.62 | 2002-02-01 15:09:00
 | HU U2 | 63 | 1350 | 1500 | 36.6 | 40.7 | 1.53 | 2002-02-01 15:09:00
 | [NAME] | 61 | 1350 | 1475 | 35.5 | 38.9 | 1.43 | 2002-02-01 15:09:00
 | [NAME] |  |  |  | 33.9 | 37.1 | 1.32 | 2002-02-01 15:07:00
 | [NAME] |  |  |  | 33 | 36.1 | 1.26 | 2002-02-01 15:07:00
 | HU F3 |  |  |  | 33.8 | 38.6 | 1.32 | 2002-01-31 15:11:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | HU H3
 | [NAME]
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | HU M3
Spreadsheet: 101291d1299451422-merging-two-excel-sheet-with-a-common-variable-testscore2
Sheet: Sheet1

First Name | Last Name | Identity # | q1 | q2 | q3 | q4 | q5 | total score
Darcy | McGill | 31201 | 0 | 1 | 1 | 1 | 1
Sinem | Oren | 33098 | 0 | 1 | 1 | 0 | 0
[NAME] | [NAME] | 33456 | 0 | 0 | 0 | 1 | 1
Spreadsheet: 869136d1715779902-distribute-available-quantity-by-rank-to-the-max-and-remaining-to-the-last-rank-test1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | ORDERED QTY |  | KLOSTERMAN | BIMBO
 |  |  |  |  | Delivery Date |  |  |  |  |  |  |  |  | KLOSTERMAN | BIMBO | QTY TO SHIP | QTY TO SHIP
 |  |  |  | Mon |  |  |  |  |  | 066-1448 - BRD 100% WHL WHEAT |  |  |  | 0 | 0 |  |  | ç ENTER QTY AVAILABLE HERE
 |  |  |  | Tue |  |  |  |  |  | 098-3239 - WHEAT BREAD WG 22 SL. |  |  |  | 1830 | 622 | 500 | 0 | ç ENTER QTY AVAILABLE HERE
 |  |  |  | Wed |  |  |  |  |  | 098-3994 - WHITE BREAD 22 SL. |  |  |  | 0 | 0 |  |  | ç ENTER QTY AVAILABLE HERE
 |  |  |  | Thu |  |  |  |  |  | 098-7257 - BUN, HAMBURGER BUN, WHITE |  |  |  | 0 | 0 |  |  | ç ENTER QTY AVAILABLE HERE
 |  |  |  | Fri |  |  |  |  |  | 098-7363 - BUN, HOT DOG BUN, WHITE |  |  |  | 0 | 0 |  |  | ç ENTER QTY AVAILABLE HERE
 |  |  |  |  |  |  |  |  |  | TOTAL |  |  |  | 1830 | 622 | 1870 | 0
 |  |  |  | 2086 | 2607.5 |  |  |  |  |  |  |  |  |  |  | 1830 | 0
Preferred Supplier | Rank | Acct# | Item # | Bimbo Qty - Cases | Klosterman Qty - Cases | Delivery Day | Item | Item Description | Account | Account Name | Bimbo Case Quantity | Bread Day | Klosterman Case Quantity | Comment 1 | Comment 2 | Klosterman Qty to ship | Bimbo Qty to Ship | Distribution
 | 1 | 4589 | 098-3239 - WHEAT BREAD WG 22 SL. | 84 | 105 | 05/23 - THU | 098-3239 | [NAME] 22 SL. | 4589 |  | 84 | 2024-05-30 00:00:00 | 105 |  |  | 105 | 0
 | 2 | 4590 | 098-3239 - WHEAT BREAD WG 22 SL. | 15 | 18.75 | 05/23 - THU | 098-3239 | [NAME] 22 SL. | 4590 |  | 15 | 2024-05-30 00:00:00 | 18.75 |  |  | 18.75 | 0
 | 3 | 4591 | 098-3239 - WHEAT BREAD WG 22 SL. | 110 | 137.5 | 05/23 - THU | 098-3239 | [NAME] 22 SL. | 4591 |  | 110 | 2024-05-30 00:00:00 | 137.5 |  |  | 137.5 | 0
 | 4 | 4593 | 098-3239 - WHEAT BREAD WG 22 SL. | 69 | 86.25 | 05/23 - THU | 098-3239 | [NAME] 22 SL. | 4593 |  | 69 | 2024-05-30 00:00:00 | 86.25 |  |  | 86.25 | 0
 | 5 | 4594 | 098-3239 - WHEAT BREAD WG 22 SL. | 60 | 75 | 05/23 - THU | 098-3239 | [NAME] 22 SL. | 4594 |  | 60 | 2024-05-30 00:00:00 | 75 |  |  | 75 | 0
 | 6 | 4595 | 098-3239 - WHEAT BREAD WG 22 SL. | 50 | 62.5 | 05/24 - FRI | 098-3239 | [NAME] 22 SL. | 4595 |  | 50 | 2024-05-31 00:00:00 | 62.5 |  |  | 62.5 | 0
 | 7 | 4599 | 098-3239 - WHEAT BREAD WG 22 SL. | 100 | 125 | 05/24 - FRI | 098-3239 | [NAME] 22 SL. | 4599 |  | 100 | 2024-05-31 00:00:00 | 125 |  |  | 125 | 0
 | 8 | 4601 | 098-3239 - WHEAT BREAD WG 22 SL. | 90 | 112.5 | 05/22 - WED | 098-3239 | [NAME] 22 SL. | 4601 |  | 90 | 2024-05-29 00:00:00 | 112.5 |  |  | 112.5 | 0
 | 9 | 4602 | 098-3239 - WHEAT BREAD WG 22 SL. | 90 | 112.5 | 05/22 - WED | 098-3239 | [NAME] 22 SL. | 4602 |  | 90 | 2024-05-29 00:00:00 | 112.5 |  |  | 112.5 | 0
 | 10 | 4607 | 098-3239 - WHEAT BREAD WG 22 SL. | 110 | 137.5 | 05/24 - FRI | 098-3239 | [NAME] 22 SL. | 4607 |  | 110 | 2024-05-31 00:00:00 | 137.5 |  |  | 137.5 | 0
Spreadsheet: 708279d1607701881-help-to-maybe-use-vlookup-to-quickly-copy-prices-from-table-b-to-a-sample-1-
Sheet: a

Supplier P/N | Price
TMJ316BB7106KLHT
HMJ325KC7475KMHPE
[NAME]
EMK105B7104KVHF
EMK107B7474KAHT
TMK107AB7105KAHT
TMK105B7103KVHF
TMK212B7225KGHT
UMK105B7102KVHF
Spreadsheet: 25553d1216912372-is-sumif-the-appropriate-formula-for-what-i-am-trying-to-do-book1
Sheet: Sheet1

Project | Funding that is here | Funding that is not here | R&D Funding that is here | R&D Funding that is not here | Quarter
A | 1346 | 71 | 654 | 894 | 3
B | 783 | 57 | 654 | 654 | 1
C | 6421 | 145 | 621 | 65 | 4
D | 472568 | 24 | 65 | 13 | 2
E | 2 | 576 | 465 | 687468 | 3
F | 46214 | 427 | 4 | 684 | 1
G | 5727 | 356 | 851526 | 4 | 4
H | 568 | 847 | 1 | 654 | 2
I | 25 | 525 | 864 | 3684 | 4
J | 682 | 67 | 6851 | 3684 | 1
K | 24 | 24 | 56 | 368 | 3
L | 57824 | 57246 | 165 | 41 | 4
M | 578 | 753 | 4 | 3 | 1
N | 48 | 683 | 31 | 486 | 2
O | 56 | 56 | 186 | 436 | 3
P | 8 | 78356 | 4135 | 0.4 | 4
Q | 3568 | 72472 | 13 | 3684 | 1
R | 3 | 457 | 21 | 64 | 2
S | 6835 | 2457 | 654 | 3684 | 2
T | 82 | 8356 | 654 | 65 | 4
Q1 | 51825 | 73776 | 7526 | 8709
Q2 | 480022 | 4468 | 772 | 4901
Q3 | 1428 | 727 | 1361 | 689166
Q4 | 70087 | 144984 | 857965 | 3859.4
Spreadsheet: 746758d1631009909-competition-ratings-comp
Sheet: Competitors

Competitor |  | Starting Points | Starting Rank | Points | Current Points | Current Rank | Wins
[NAME] |  | 2209
[NAME] Truong Son |  | 2205
[NAME] |  | 2171
[NAME] |  | 2159
[NAME] |  | 2154
Maxim Matlakov |  | 2154
[NAME] |  | 2153
Viorel Iordachescu |  | 2152
[NAME] |  | 2139
[NAME] |  | 2131
[NAME] |  | 2127
[NAME] |  | 2109
[NAME] |  | 2107
[NAME] |  | 2095
Morrison |  | 2090
[NAME] |  | 2078
[NAME] |  | 2074
[NAME] |  | 2069
[NAME] |  | 2060
[NAME] |  | 2054
[NAME] |  | 2050
[NAME] |  | 2038
[NAME] |  | 2021
[NAME] |  | 2004
[NAME] |  | 1997
[NAME] |  | 1995
[NAME] |  | 1984
[NAME] |  | 1983
Cal Connor |  | 1978
[NAME] |  | 1966
[NAME] |  | 1957
[NAME] |  | 1928
[NAME] |  | 1917
[NAME] |  | 1904
Tanner Hurley |  | 1893
[NAME] |  | 1892
[NAME] |  | 1891
[NAME] |  | 1891
[NAME] |  | 1890
[NAME] |  | 1889
[NAME] |  | 1881
[NAME], |  | 1880
[NAME] |  | 1878
[NAME] |  | 1870
[NAME] |  | 1858
Gawain Jones |  | 1847
[NAME] |  | 1844
Yuriy Kryvoruchko |  | 1834
[NAME] |  | 1829
[NAME] |  | 1816
[NAME] |  | 1808
[NAME] |  | 1797
[NAME] |  | 1795
Nao Kawamura |  | 1786
[NAME] |  | 1781
Alain |  | 1778
[NAME] |  | 1769
Mejdi Kaabi |  | 1762
Hong Juyoung |  | 1759
[NAME] |  | 1725
[NAME] |  | 1722
[NAME] |  | 1721
[NAME] So |  | 1719
[NAME] |  | 1714
Takuto Itagaki |  | 1713
[NAME] |  | 1707
[NAME] |  | 1663
[NAME] |  | 1649
[NAME] |  | 1641
Emily Eastham |  | 1635
[NAME] |  | 1623
Artashes Minasian |  | 1621
[NAME] |  | 1619
Volodar Murzin |  | 1592
[NAME] |  | 1589
[NAME] |  | 1583
Matthias Hellmoldt |  | 1580
[NAME] |  | 1569
Watu Kobese |  | 1564
[NAME] |  | 1564
Jump |  | 1555
[NAME] |  | 1551
[NAME] |  | 1542
Le Quang Liem |  | 1542
[NAME] |  | 1504
[NAME] |  | 1497
[NAME] |  | 1496
Mandi |  | 1482
[NAME] |  | 1481
Ryusei Yasue |  | 1481
Vidit Santosh |  | 1481
Aleksandar Inđić |  | 1475
[NAME] |  | 1472
[NAME] |  | 1462
Sang Cao |  | 1456
[NAME] |  | 1454
Pouria Darini |  | 1449
Connor Yuen |  | 1447
Sébastien Feller |  | 1442
[NAME] |  | 1438
[NAME] |  | 1417
[NAME] |  | 1406
Lance |  | 1399
[NAME] |  | 1391
[NAME] |  | 1388
[NAME] |  | 1375
[NAME] |  | 1326
Darmen Sadvakasov |  | 1316
[NAME] |  | 1311
[NAME] |  | 1306
[NAME] |  | 1306
Astrid |  | 1298
[NAME] |  | 1297
Utut Adianto |  | 1295
Walaa Sarwat |  | 1289
[NAME] |  | 1279
[NAME], |  | 1279
Gregory Kaidanov |  | 1270
[NAME] |  | 1262
Alejandro [NAME] |  | 1253
[NAME] |  | 1244
[NAME] |  | 1239
[NAME] |  | 1232
[NAME] |  | 1231
[NAME] |  | 1199
[NAME] |  | 1181
[NAME] |  | 1160
[NAME] |  | 1153
Enrico Marini |  | 1147
[NAME] |  | 1139
[NAME] |  | 1137
[NAME] |  | 1137
[NAME] |  | 1136
[NAME] |  | 1127
[NAME] |  | 1119
[NAME] |  | 1119
[NAME] |  | 1106
Alisher [NAME] |  | 1074
[NAME] |  | 1067
[NAME] |  | 1066
Conrad Holt |  | 1064
[NAME] |  | 1050
[NAME] |  | 1050
[NAME], |  | 1049
[NAME] |  | 1043
[NAME] |  | 1041
[NAME] |  | 1029
[NAME] |  | 1026
[NAME] |  | 1016
Trip |  | 1007
Spreadsheet: 72937d1273621899-too-many-arguments-better-formula-available-sample
Sheet: Rates

A | 0.005 | 0.005 | 3.25 | 0 | 0
B | 0.01 | 0.005 | 3.5 | 0 | 0
C | 0.015 | 0.005 | 5 | -22000 | 0
D | 0.015 | 0.005 | 2.5 | 0 | -330
E | 0 | 0.005 | 5 | 0 | 0
F | 0.005 | 0.005 | 5 | 0 | -125
G | 0 | 0.005 | 5 | 0 | 0
H | 0 | 0.005 | 4.1 | 0 | 0
I | 0 | 0.005 | 5 | 0 | 0
J | 0.0075 | 0.005 | 5 | 0 | 0
K | 0 | 0.005 | 6 | 0 | 0
L | 0.01 | 0.005 | 3.5 | 0 | 0
M | 0.01 | 0.005 | 3.3 | 0 | 0
N | 0.01 | 0.005 | 2.5 | 0 | 0
O | 0.005 | 0.005 | 3.3 | 0 | 0
P | 0.01 | 0.005 | 3.45 | 0 | 0 | -50000
Q | 0.014 | 0.005 | 2.5 | 0 | 0
R | 0.005 | 0.005 | 4.95 | 0 | 0
S | 0.01 | 0.005 | 4 | 0 | 0
T | 0 | 0.005 | 3.3 | 0 | 0
U | 0.01 | 0.005 | 3.3 | 0 | 0
V | 0.005 | 0.005 | 3.8 | 0 | 0
W | 0 | 0.005 | 3.5 | 0 | 0
X | 0.005 | 0.005 | 3.5 | 0 | 0
Spreadsheet: mary_fischer__25636__31S
Sheet: E20.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031S
COMPANY NAME   Limbach Company
ANALYSIS OF OTHER INCOME AND DEDUCTIONS
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  | E-20
[NAME] |  | 1ST QTR |  | 2ND QTR |  | 3RD QTR |  | 4TH QTR |  | YEAR TO DATE
OTHER INCOME - OTHER
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Gain on Sale of FA |  | -9400 |  | -14200
Total Other Income - Other
(MUST TIE TO HYPERION ACCOUNT 1690)
Income Accts:  DR/(CR)
Reverse signs from Hyperion
[NAME] |  | 1ST QTR |  | 2ND QTR |  | 3RD QTR |  | 4TH QTR |  | YEAR TO DATE
OTHER DEDUCTIONS - OTHER
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Other Deductions - Other
(MUST TIE TO HYPERION ACCOUNT 1775)
Asset/Expense Accts:  DR/(CR)
Same signs as Hyperion
 |  |  |  |  |  |  |  |  |  | E-20
Spreadsheet: 831225d1685516393-increment-serial-number-and-repeat-for-similarcombinations-with-in-range-what-i-am-trying-to-achieve
Sheet: Sheet1 (2)

 |  |  |  |  | DESC | DESC 2 | HOW I WANT SERIAL NUMBER
 |  |  |  |  | A | 2021 | 1
 |  |  |  |  | A | 2021 | 1
 |  |  |  |  | A | 2021 | 1
 |  |  |  |  | A | 2022 | 2
 |  |  |  |  | A | 2022 | 2
 |  |  |  |  | A | 2022 | 2
 |  |  |  |  | A | 2021 | 1
 |  |  |  |  | A | 2021 | 1
 |  |  |  |  | A | 2022 | 2
 |  |  |  |  | A | 2022 | 2
 |  |  |  |  | A | 2021 | 1
 |  |  |  |  | A | 2022 | 2
 |  |  |  |  | A | 2022 | 2
 |  |  |  |  | B | 2021 | 3
 |  |  |  |  | B | 2021 | 3
 |  |  |  |  | B | 2021 | 3
 |  |  |  |  | B | 2022 | 4
 |  |  |  |  | B | 2022 | 4
 |  |  |  |  | B | 2021 | 3