tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 440188d1452692656-keeping-information-and-auto-population-onto-a-new-line-each-time-repair-form1
Sheet: List of Machine Issues

Date | Machine # | SN | Part | Part Number | Cost | Hours on Machine | Comments
 |  |  |  |  |  |  | First Comment | 1 | PH 7386
 |  |  | Part 2 | Part # 2 | Cost#2 |  | Second Comment | 2 | PH 7393
 |  |  | Part 3 | Part #3 | Cost #3 |  |  | 3 | PH 7394
2016-01-13 00:00:00 | 2 | ph12345 | part 1 | part # 1 | cost 1 | 2560 | First Comment | 4 | PH 7395
 |  |  | Part 2 | Part # 2 | cost 2 |  | Second Comment | 5 | PH 7397
 |  |  | Part 3 | Part #3 | cost 3 |  |  | 6 | PH 7399
 |  |  |  |  |  |  |  | 7 | PH 7400
 |  |  |  |  |  |  |  | 8 | PH 7404
 |  |  |  |  |  |  |  | 9 | PH 7406
 |  |  |  |  |  |  |  | 10 | PH 7410
Spreadsheet: 291931d1390440998-how-to-put-numbers-on-the-right-side-of-comment-box-according-name-list-commentboxnumbers
Sheet: Sheet1

No. | Student names | Sex |  |  | 1
1 | AHMAD IKHWAN AFFANDI B.AHMAD SUKRI | M
2 | AKMAL LATIF BIN SAIDON | M
3 | MOHAMMAD SAHARULIZWAN BIN IBRAHIM | M |  |  | 2
4 | MUHAMMAD ADAM BIN BADHRULNIZAM | M
5 | MUHAMMAD ADAM [NAME] ANUAR | M
6 | MUHAMMAD AIDIL B.MOHD KHASIR | M |  |  | 3
7 | MUHAMMAD AMAR DANIAL BIN OMAR | M
Spreadsheet: 766417d1643890718-need-a-total-of-values-for-one-day-date-and-time-readings
Sheet: Sheet1

Record | DateTime | Imp Wh Total
129366 | 2021-01-28 13:00:00 | 17900
129367 | 2021-01-28 13:30:00 | 17800
129368 | 2021-01-28 14:00:00 | 17800
129369 | 2021-01-28 14:30:00 | 18300
129370 | 2021-01-28 15:00:00 | 17700
129371 | 2021-01-28 15:30:00 | 20600
129372 | 2021-01-28 16:00:00 | 18300
129373 | 2021-01-28 16:30:00 | 19000
129374 | 2021-01-28 17:00:00 | 17700
129375 | 2021-01-28 17:30:00 | 14300
129376 | 2021-01-28 18:00:00 | 11200
129377 | 2021-01-28 18:30:00 | 8100
129378 | 2021-01-28 19:00:00 | 2100
129379 | 2021-01-28 19:30:00 | 1200
129380 | 2021-01-28 20:00:00 | 1200
129381 | 2021-01-28 20:30:00 | 1300
129382 | 2021-01-28 21:00:00 | 1200
129383 | 2021-01-28 21:30:00 | 1200
129384 | 2021-01-28 22:00:00 | 1200
129385 | 2021-01-28 22:30:00 | 1300
129386 | 2021-01-28 23:00:00 | 1100
129387 | 2021-01-28 23:30:00 | 1200
129388 | 2021-01-29 00:00:00 | 1300
129389 | 2021-01-29 00:30:00 | 1200
129390 | 2021-01-29 01:00:00 | 1200
129391 | 2021-01-29 01:30:00 | 1200
129392 | 2021-01-29 02:00:00 | 1300
129393 | 2021-01-29 02:30:00 | 1200
129394 | 2021-01-29 03:00:00 | 1200
129395 | 2021-01-29 03:30:00 | 1300
129396 | 2021-01-29 04:00:00 | 1200
129397 | 2021-01-29 04:30:00 | 1300
129398 | 2021-01-29 05:00:00 | 1200
129399 | 2021-01-29 05:30:00 | 1300
129400 | 2021-01-29 06:00:00 | 1200
129401 | 2021-01-29 06:30:00 | 2300
129402 | 2021-01-29 07:00:00 | 7600
129403 | 2021-01-29 07:30:00 | 9400
129404 | 2021-01-29 08:00:00 | 9400
129405 | 2021-01-29 08:30:00 | 11800
129406 | 2021-01-29 09:00:00 | 16400
129407 | 2021-01-29 09:30:00 | 17400
129408 | 2021-01-29 10:00:00 | 16800
129409 | 2021-01-29 10:30:00 | 18200
129410 | 2021-01-29 11:00:00 | 16500
129411 | 2021-01-29 11:30:00 | 18100
129412 | 2021-01-29 12:00:00 | 20000
129413 | 2021-01-29 12:30:00 | 20300
129414 | 2021-01-29 13:00:00 | 19700
129415 | 2021-01-29 13:30:00 | 17400
129416 | 2021-01-29 14:00:00 | 16200
129417 | 2021-01-29 14:30:00 | 15600
129418 | 2021-01-29 15:00:00 | 15600
129419 | 2021-01-29 15:30:00 | 17000
129420 | 2021-01-29 16:00:00 | 17200
129421 | 2021-01-29 16:30:00 | 16900
129422 | 2021-01-29 17:00:00 | 16600
129423 | 2021-01-29 17:30:00 | 13900
129424 | 2021-01-29 18:00:00 | 9600
129425 | 2021-01-29 18:30:00 | 7100
129426 | 2021-01-29 19:00:00 | 1900
129427 | 2021-01-29 19:30:00 | 1400
129428 | 2021-01-29 20:00:00 | 1000
129429 | 2021-01-29 20:30:00 | 1000
129430 | 2021-01-29 21:00:00 | 900
129431 | 2021-01-29 21:30:00 | 1000
129432 | 2021-01-29 22:00:00 | 1000
129433 | 2021-01-29 22:30:00 | 1000
129434 | 2021-01-29 23:00:00 | 900
129435 | 2021-01-29 23:30:00 | 1000
Spreadsheet: 08a010d9-875e-4da7-bb5f-8ddacc1118cb
Sheet: Science

 | Associate In Science |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 2012 - 2013 |  |  |  |  |  |  |  |  |  |  |  | General Help | Return To AA
 | NAME: |  |  |  |  | DATE: |  |  |  |  |  |  | [NAME] | Return To AS
 | ID: |  |  |  |  | FOCUS: |  |  |  |  |  | Focus Areas | [NAME] | Main Menu
 | CATEGORY I:  General Education Core |  |  |  |  |  |  | Hours: |  | /33 |  | Category I Help
 |  |  |  | Course | Credit | Grade |  | Course | Credit | Grade
 | Communication - Written (6)
 | Communication - Oral (3)
 | Arts & Humanities - Heritage (3)
 | Arts & Humanities - Humanities (3)
 | Social & Behavioral Sciences (6)
 | Natural Sciences (6)
 | Quantitative Reasoning (6)
 | CATEGORY II:  Associate In Science Requirements |  |  |  |  |  |  | Hours: |  | /12 |  | Category II Help
 |  |  |  |  |  |  |  | Course | Credit | Grade
 | Quantitative Reasoning/Natural Sciences (6)
 | General Education Core/Foreign Languages (6)
 | CATEGORY III:  Electives |  |  |  |  |  |  | Hours: |  | /15 |  | Category III Help
 |  |  |  | Course | Credit | Grade |  | Course | Credit | Grade
 | Electives (15)
 | Credits Summary |  |  | Total Credits: |  |  |  | Earned Credits:
 |  |  |  | Additional Credits: |  |  |  | Credits IPS:
 | Additional Graduation Requirements |  |  |  |  |  |  |  |  |  |  | [NAME]
 | 1.  Student must take one approved Cultural Studies course.
 | 2.  Student must take Social & Behavioral Science courses from at least two disciplines.
 | 3.  Student must take at least one Science Lab.
 | 4.  Student must demonstrate Computer Literacy.
 | 5.  Student must earn a minimum of sixty (60) credit hours for a degree. |  |  |  |  |  |  |  |  | /60
 | 6.  Student must earn at least fifteen (15) credit hours at BCTC. |  |  |  |  |  |  |  |  | /15
 | 7.  Student must have a cumulative GPA of 2.0 to earn a degree. |  |  |  |  |  |  |  |  | /4.0
 | Notes
 | Auditor: |  |  |  |  | E-mail:
Spreadsheet: 854727d1704488191-business-days-in-sequence-dias-teis
Sheet: Planilha1

 | 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-08 00:00:00
 | 2024-01-09 00:00:00
 | 2024-01-10 00:00:00
 | 2024-01-11 00:00:00
 | 2024-01-12 00:00:00
 | 2024-01-15 00:00:00
 | 2024-01-16 00:00:00
 | 2024-01-17 00:00:00
 | 2024-01-18 00:00:00
 | 2024-01-19 00:00:00
 | 2024-01-22 00:00:00
 | 2024-01-23 00:00:00
 | 2024-01-24 00:00:00
 | 2024-01-25 00:00:00
 | 2024-01-26 00:00:00
 | 2024-01-29 00:00:00
 | 2024-01-30 00:00:00
 | 2024-01-31 00:00:00
Spreadsheet: 801221d1666122200-if-formula-to-provide-price-based-on-2-different-ranges-of-numbers-v-test
Sheet: Sheet 1

TD & BD | V Length >= | 29
TD & BD | V Length <= | 72
STR 1 & 2 | V Width >= | 29
STR 1 & 2 | V Width <= | 55
 | V Quantity >= | 300
 | Error | 0
 | Lumber | QTY | THICK | WID | LENGTH | V M | V L | 2" NG M | 2" NG L | 2 1/4" NG M | 2 1/4" NG L | 3" NG M | 3" NG L
 | T D 1 | 5 | 0.5 | 5.5 | 43
 | T D 2 | 0 | 0 | 0 | 0
 | B D 1 | 3 | 0.5 | 5.5 | 43
 | B D 2 | 0 | 0 | 0 | 0
 | Str 1 | 4 | 1.1875 | 3.5 | 43
 | Str 2 | 0 | 0 | 0 | 0
 | Quantity | 760
 | Nails | Material | Labor
 | 2" V | 0.008902 | 0.008
 | 2" NG | 0.008333 | 0.018
 | 2 1/4" NG | 0.009 | 0.02
 | 3 " NG | 0.016667 | 0.025
Spreadsheet: 65a70770-82b1-48aa-8ec0-05346273070e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 35. LEASE FINANCE COMMITMENTS, By Purpose: State (WA), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1 . . . [NAME] ; |  |  | Original | A2413911L | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413912R | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413913T | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413914V | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413915W | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413916X | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413917A | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413918C | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413919F | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413920R | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413921T | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413922V | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413923W | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413924X | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413925A | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413926C | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 845262d1696794840-power-query-more-efficient-way-to-label-rows-with-duplicate-key-information-example1
Sheet: Project

 |  |  |  | 2023-01-01 00:00:00 |  | 2023-01-02 00:00:00 |  | 2023-01-03 00:00:00 |  | 2023-01-04 00:00:00 |  | 2023-01-05 00:00:00 |  | 2023-01-06 00:00:00 |  | 2023-01-07 00:00:00 |  | 2023-01-08 00:00:00 |  | 2023-01-09 00:00:00 |  | 2023-01-10 00:00:00 |  | 2023-01-11 00:00:00 |  | 2023-01-12 00:00:00 |  | 2023-01-13 00:00:00 |  | 2023-01-14 00:00:00 |  | 2023-01-15 00:00:00 |  | 2023-01-16 00:00:00 |  | 2023-01-17 00:00:00 |  | 2023-01-18 00:00:00 |  | 2023-01-19 00:00:00 |  | 2023-01-20 00:00:00 |  | 2023-01-21 00:00:00 |  | 2023-01-22 00:00:00
 |  | [NAME] | acarbertol
 |  | [NAME] | cfoynes1
 |  | Priscilla Elam | pelam2
 |  | Violet Krauss | vkrauss3
 |  | Cathe Castella | ccastella4
 |  | [NAME] | khutfield5
 |  | [NAME] | slightwing6
 |  | [NAME] | [NAME]
 |  | Peadar Rolse | prolse8
 |  | Henryetta Burbidge | hburbidge9
 |  | [NAME] | fcicchitelloa
 |  | Charo Sweeny | csweenyb
 |  | [NAME] | mgutchc
 |  | Berty Cottisford | bcottisfordd
 |  | [NAME] | dbazelle
Spreadsheet: 132657d1323877113-pivot-table-is-counting-the-formula-as-will-as-the-value-courseeg
Sheet: Sheet1

Name | Registered | Completed
Course 1 | y
Course 2 | y | Yes
Course 3 | y
 |  |  | Column Labels
 |  |  | Course 1 |  | Course 2 |  | Course 3 |  | (blank) |  | Total Count of Registered | Total Count of Completed
 |  |  | Count of Registered | Count of Completed | Count of Registered | Count of Completed | Count of Registered | Count of Completed | Count of Registered | Count of Completed
 |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  | 3 | 3
Spreadsheet: 08a592cb-72a0-417b-9b6a-1043d71e4ec3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | EcoCheck Data: [NAME] for 2010
Indicator | 2010
Chlorophyll a | 26.606
Aquatic Grasses | No Growth Zone
[NAME] | 50.229
[NAME] | Insufficient Data
Water Clarity | 0
Phytoplankton Index | 0
Water Quality Index | 25.61166667
Biotic Index | Insufficient Data
Bay Health Index | 19.2
Spreadsheet: 34999d1232474587-recognizing-counting-and-displaying-duplicates-loopy-mclooperson
Sheet: Duplicate Checking

Duplicates by Week
Week 1 |  | Week 2 |  | Week 3
1 | 84 | 2 | 82 | 1 | 1
 |  | 3 | 2 | 8 | 1
 |  |  |  | 15 | 1
 |  |  |  | 22 | 1
 |  |  |  | 29 | 1
 |  |  |  | 36 | 1
 |  |  |  | 43 | 1
 |  |  |  | 50 | 1
 |  |  |  | 57 | 1
 |  |  |  | 64 | 1
 |  |  |  | 71 | 1
 |  |  |  | 78 | 1
 |  |  |  | 2 | 1
 |  |  |  | 9 | 1
 |  |  |  | 16 | 1
 |  |  |  | 23 | 1
 |  |  |  | 30 | 1
 |  |  |  | 37 | 1
 |  |  |  | 44 | 1
 |  |  |  | 51 | 1
 |  |  |  | 58 | 1
 |  |  |  | 65 | 1
 |  |  |  | 72 | 1
 |  |  |  | 79 | 1
 |  |  |  | 3 | 1
 |  |  |  | 10 | 1
 |  |  |  | 17 | 1
 |  |  |  | 24 | 1
 |  |  |  | 31 | 1
 |  |  |  | 38 | 1
 |  |  |  | 45 | 1
 |  |  |  | 52 | 1
 |  |  |  | 59 | 1
 |  |  |  | 66 | 1
 |  |  |  | 73 | 1
 |  |  |  | 80 | 1
 |  |  |  | 4 | 1
 |  |  |  | 11 | 1
 |  |  |  | 18 | 1
 |  |  |  | 25 | 1
 |  |  |  | 32 | 1
 |  |  |  | 39 | 1
 |  |  |  | 46 | 1
 |  |  |  | 53 | 1
 |  |  |  | 60 | 1
 |  |  |  | 67 | 1
 |  |  |  | 74 | 1
 |  |  |  | 81 | 1
 |  |  |  | 5 | 1
 |  |  |  | 12 | 1
 |  |  |  | 19 | 1
 |  |  |  | 26 | 1
 |  |  |  | 33 | 1
 |  |  |  | 40 | 1
 |  |  |  | 47 | 1
 |  |  |  | 54 | 1
 |  |  |  | 61 | 1
 |  |  |  | 68 | 1
 |  |  |  | 75 | 1
 |  |  |  | 82 | 1
 |  |  |  | 6 | 1
 |  |  |  | 13 | 1
 |  |  |  | 20 | 1
 |  |  |  | 27 | 1
 |  |  |  | 34 | 1
 |  |  |  | 41 | 1
 |  |  |  | 48 | 1
 |  |  |  | 55 | 1
 |  |  |  | 62 | 1
 |  |  |  | 69 | 1
 |  |  |  | 76 | 1
 |  |  |  | 83 | 1
 |  |  |  | 7 | 1
 |  |  |  | 14 | 1
 |  |  |  | 21 | 1
 |  |  |  | 28 | 1
 |  |  |  | 35 | 1
 |  |  |  | 42 | 1
 |  |  |  | 49 | 1
 |  |  |  | 56 | 1
 |  |  |  | 63 | 1
 |  |  |  | 70 | 1
 |  |  |  | 77 | 1
 |  |  |  | 84 | 1
Spreadsheet: 758252d1638785903-a-list-of-more-than-3-consecutive-days-and-the-amount-must-be-5-5-forumhelp_12-06
Sheet: Sheet1

Type | Date | Amount | Helper |  |  | Type | Date | Amount |  | Type | Date | Amount
A | 2020-07-16 00:00:00 | 5.3 |  |  |  | B | 2021-07-27 00:00:00 | 5.5
A | 2020-07-27 00:00:00 | 4.5 |  |  |  | B | 2021-07-28 00:00:00 | 5.7
B | 2021-07-16 00:00:00 | 5.2 |  |  |  | A | 2021-07-29 00:00:00 | 6.5
B | 2021-07-17 00:00:00 | 5.1 |  |  |  | B | 2021-07-29 00:00:00 | 6.3
B | 2021-07-27 00:00:00 | 5.5 |  |  |  | A | 2021-07-30 00:00:00 | 7.7
A | 2021-07-28 00:00:00 | 5.3 |  |  |  | B | 2021-07-30 00:00:00 | 7.1
B | 2021-07-28 00:00:00 | 5.7 |  |  |  | D | 2021-07-30 00:00:00 | 6.4
A | 2021-07-29 00:00:00 | 6.5 |  |  |  | E | 2021-07-30 00:00:00 | 6
B | 2021-07-29 00:00:00 | 6.3 |  |  |  | A | 2021-07-31 00:00:00 | 5.8
C | 2021-07-29 00:00:00 | 4.6 |  |  |  | A | 2021-08-01 00:00:00 | 6.7
A | 2021-07-30 00:00:00 | 7.7 |  |  |  | B | 2021-08-01 00:00:00 | 6.5
B | 2021-07-30 00:00:00 | 7.1 |  |  |  | C | 2021-08-01 00:00:00 | 5.5
C | 2021-07-30 00:00:00 | 5.3 |  |  |  | E | 2021-08-01 00:00:00 | 5.6
D | 2021-07-30 00:00:00 | 6.4 |  |  |  | A | 2021-08-02 00:00:00 | 5.9
E | 2021-07-30 00:00:00 | 6 |  |  |  | B | 2021-08-02 00:00:00 | 6.1
F | 2021-07-30 00:00:00 | 5.1 |  |  |  | A | 2021-08-03 00:00:00 | 6.3
A | 2021-07-31 00:00:00 | 5.8
D | 2021-07-31 00:00:00 | 5.2
A | 2021-08-01 00:00:00 | 6.7
B | 2021-08-01 00:00:00 | 6.5
C | 2021-08-01 00:00:00 | 5.5
D | 2021-08-01 00:00:00 | 5.3
E | 2021-08-01 00:00:00 | 5.6
A | 2021-08-02 00:00:00 | 5.9
B | 2021-08-02 00:00:00 | 6.1
C | 2021-08-02 00:00:00 | 5.3
A | 2021-08-03 00:00:00 | 6.3
C | 2021-08-03 00:00:00 | 5.2
F | 2021-09-24 00:00:00 | 6.9
A | 2021-10-25 00:00:00 | 5.7
A | 2021-11-24 00:00:00 | 5.1
C | 2021-11-28 00:00:00 | 5.4
A | 2021-12-30 00:00:00 | 5.6
Spreadsheet: chris_stokley__3918__0201 EES2
Sheet: Total

 |  | EPMI Charges To Customers
Trans Type | (All)
 |  |  | Data
Customer | ID | Desc. | Expense | Revenue | Total | Volume
EES | 111 | Spinning Reserve due ISO | -256.11 | 112213.43 | 111957.32 | -218.7
 | 487 | Allocation Excess Cost for IE | -3488.92 | 0 | -3488.92 | -2627.16000713408
 | 1010 | Neutrality Adj | -155.48 | 9332.669999999995 | 9177.19 | -51008.02
 | 1030 | No Pay Market Refund | -47.97540000000001 | 0 | -47.97540000000001 | 10642.293
 | 1210 | Existing Contract Neu Adj | -155126.2559999998 | 2512.898700000001 | -152613.3572999999 | -1756663.1807
Grand Total |  |  | -159074.7413999998 | 124058.9987 | -35015.74269999994 | -1799874.767707134
Legend:
Sched Type PRA | Pro-Rata Adjustment; adjustments made to all participants in the market that are assessed
 | or credited under an ISO charge type.  Pro-rata adjustments are based on the customer's
 | percentage share of total volume at a given tie-point, zone, date and hour.
 | The amount of the pro-rata share is determined by variances between the amount
 | that EPMI has estimated for each customer, and the actual amount assessed
 | by the ISO.  These variances are allocated pro-rata.
Sched Type EPMIM | An entry into the system that calculates a customer's charge or payment through
 | the use of a manual tool.  Amounts are estimates using best-known metered or
 | scheduled data and information retrieved from the ISO web site.  Volume represents the
 | customer's percentage of the total amount scheduled, according to the terms of the deal.
Sched Type ISOIe | This represents amounts assessed using an automatic calculation engine, based on a customer's
 | scheduled import or export volume and best-known data retrieved from the ISO website.
 | ISOIe stands for ISO Import/Export.
[NAME] | The Production Month for which the charges or credits are assessed.
ID | The charge type identifier used by the ISO.
How to read this report:  The values presented here are from the perspective of EPMI.  An amount in the Expense column represents
payments to the customer, and an amount in the Revenue column represents payments or adjustments back to EPMI (and ultimately, back to the ISO).
The DetailData tab reflects a breakdown, by date, hour, charge type, zone, etc., of the total amounts found on the Total tab.
Spreadsheet: 103568d1301331870-if-next-formula-example-day92
Sheet: Resident Charges

Acct # | Name | Location | Charges | Tip | Tax | Total
1111 | [NAME] | Bar | 5 | 1 | 0.3
1134 | [NAME] | [NAME] | 4 | 1 | 0.24
1111 | [NAME] | [NAME] | 5 | 1 | 0.3
Spreadsheet: 455620d1460439529-chep-account-chep-example
Sheet: PALLETS OWING

REFERENCE | COMPANY | FROM | TO | PALLETS OWING -(owes us) | Jun-15 | Jul-15 | Aug-15 | Sep-15 | Oct-15
WW
XW
YB
YR
YS
Z
Spreadsheet: 680724d1591165186-split-strings-into-duplicate-rows-example
Sheet: Sheet1

email | recipient-name | country | city | state | postal-code | purchase-date
[EMAIL] [EMAIL] | [NAME] | US | WEST COLLEGE CORNER | IN | 47003 | 2019-05-17 00:00:00
[EMAIL] [EMAIL] [EMAIL] | [NAME] | US | GRAND PRAIRIE | TX | 75052 | 2019-05-18 00:00:00
[EMAIL] | [NAME] | US | WEST COLLEGE CORNER | IN | 47003 | 2019-05-17 00:00:00
[EMAIL] | [NAME] | US | WEST COLLEGE CORNER | IN | 47003 | 2019-05-17 00:00:00
[EMAIL] | [NAME] | US | GRAND PRAIRIE | TX | 75052 | 2019-05-18 00:00:00
[EMAIL] | [NAME] | US | GRAND PRAIRIE | TX | 75052 | 2019-05-18 00:00:00
[EMAIL] | [NAME] | US | GRAND PRAIRIE | TX | 75052 | 2019-05-18 00:00:00
Spreadsheet: 1cfa6dc0-397e-4492-84b3-e7a7f2f9d104
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
08/18/2013 | Men's Soccer | Ohio State (Exhibition) | 12:00 AM | W, 1-0
08/23/2013 | Men's Soccer | at Villanova (Exhibition) | 12:00 AM | T, 0-0
08/30/2013 | Men's Soccer | Central Connecticut State | 12:00 AM | W, 3-0
09/02/2013 | Men's Soccer | Radford | 12:00 AM | T, 2-2 (2OT)
09/06/2013 | Men's Soccer | at Georgetown | 12:00 AM | L, 0-3
09/08/2013 | Men's Soccer | at Indiana | 12:00 AM | W, 5-4 (2OT)
[NAME] | Men's Soccer | [NAME] | 12:00 AM | W, 2-1
[NAME] | Men's Soccer | at St. John's | 12:00 AM | L, 0-1
09/21/2013 | Men's Soccer | Michigan | 12:00 AM | L, 1-2 (OT)
09/25/2013 | Men's Soccer | Penn State | 12:00 AM | L, 1-2
09/29/2013 | Men's Soccer | Akron* | 12:00 AM | L, 0-1
10/05/2013 | Men's Soccer | Northern Illinois* | 12:00 AM | W, 4-0
10/08/2013 | Men's Soccer | [NAME] | 12:00 AM | W, 3-1
10/11/2013 | Men's Soccer | at Hartwick* | 12:00 AM | L, 0-1
10/15/2013 | Men's Soccer | High Point | 12:00 AM | T, 1-1 (2OT)
10/19/2013 | Men's Soccer | Georgia State | 12:00 AM | W, 1-0
10/22/2013 | Men's Soccer | at American | 12:00 AM | T, 0-0 (2OT)
10/26/2013 | Men's Soccer | Western Michigan* | 12:00 AM | T, 0-0 (2OT)
11/01/2013 | Men's Soccer | at Buffalo* | 12:00 AM | W, 2-1
11/08/2013 | Men's Soccer | Bowling Green* | 12:00 AM | T, 3-3 (2OT)
11/15/2013 | Men's Soccer | at Akron (MAC Semifinals) | 12:00 AM | L, 0-3
Spreadsheet: 825971d1681710112-how-can-i-change-the-format-of-the-column-a-into-column-b-excel-time-format-change
Sheet: Sheet1

A | B
00:00:00
00:05:33
00:10:33
00:14:47
00:18:27
00:21:45
00:24:38
00:28:45
00:30:45
00:34:11
00:37:02
00:39:53
00:41:27
00:46:09
00:49:15
00:53:00
00:55:59
00:57:42
01:00:45
[NAME]
01:02:25
01:03:47
Spreadsheet: 40016d1238308917-two-way-interpolation-is-it-possible-twowayinterpolate_updated
Sheet: Sheet1

Table 1
 |  |  |  | y
x | 0 | 0.4 | 0.8 | 1.2 | 1.6 | 2
0 | 1 | 0.9 | 0.6 | 0.3 | 0 | -0.3
0.5 | 2 | 2.3 | 1.9 | 1.5 | 1.1 | 0.7
1 | 5 | 4.7 | 4.1 | 3.7 | 3.25 | 2.8
1.5 | 8 | 8.5 | 7.5 | 7.5 | 7.25 | 7
2 | 13 | 13.5 | 11.86 | 11.6466666666667 | 11.0766666666667 | 10.5066666666667
2.5 | 19 | 18.5 | 15.7 | 14.4333333333333 | 12.7833333333333 | 11.1333333333333
Spreadsheet: 69447d1269966319-merge-sheets-sample
Sheet: DE

DE
Ctry | LONDON | SWEDEN | [NAME] |  | LONDON | DE | 344 | 4334 | 4343 | 44 | 55 | 55 | 0 | 0
 |  |  |  |  | SWEDEN | DE | 66 | 66 | 66 | 66 | 55 | 55 | 0 | 0
Price |  |  |  |  | [NAME] | DE | 77 | 77 | 77 | 77 | 22 | 55 | 0 | 0
30Kg | 344 | 66 | 77
40Kg | 4334 | 66 | 77
50Kg | 4343 | 66 | 77
60Kg | 44 | 66 | 77
Add1
Quarter 1 | 55 | 55 | 22
Quarter 2
Quarter 3
Quarter 4
Total | 55 | 55 | 55
C1 | 0 | 0 | 0
C2 | 0 | 0 | 0
[NAME] | 0 | 0 | 4
Add2
30Kg | 0 | 0 | 0
40Kg | 0 | 0 | 0
50Kg | 0 | 0 | 0
60Kg | 0 | 0 | 0
Add3
30Kg | 0 | 0 | 0
40Kg | 0 | 0 | 0
50Kg | 0 | 0 | 0
60Kg | 0 | 0 | 0
Add4
30Kg | 11 | 11 | 44
40Kg | 22 | 22 | 55
50Kg | 22 | 33 | 66
60Kg | 22 | 33 | 77
Add5
30Kg | 44 | 44 | 44
40Kg | 44 | 44 | 44
50Kg | 0 | 0 | 44
60Kg | 0 | 0 | 44
Spreadsheet: 547478d1510582638-formula-to-auto-populate-auto-populate
Sheet: Summary

If I change A8 & A27, I need to get the corresponding details from Data sheet to the highlighted area
SERVICE | SERVICE NAME | DIRECTION | PORT | ROUTE | ROUTE2 | CODE | SECTOR CODE | SECTOR
A003 |  | EB | SAJED |  |  | 20 | XI1 | EM
 |  | EB | LKCMB |  |  | 20 | XI1 | EM
 |  | WB | LKCMB |  |  | 10 | XI1 | ME
 | [NAME] | AREA2 | AREA3 | AREA4 | AREA5 | [NAME]
 | A003117 | A003151 | A003149 | A003159 | A003123 | A003164
SERVICE | SERVICE NAME | DIRECTION | PORT | ROUTE | ROUTE2 | CODE | SECTOR CODE | SECTOR
A008 |  | SB | REPDG |  |  | 10 | XI1 | FE
 |  | NB | INMAA |  |  | 20 | XI1 | EF
 |  | NB | LKCMB |  |  | 20 | XI1 | EF
 |  | NB | INCOK |  |  | 20 | XI1 | EF
 | [NAME] | AREA2 | AREA3 | AREA4 | AREA5 | [NAME]
 | A008191 | A008159 | [NAME] | A008150 | A008146 | [NAME]
Spreadsheet: 854016d1703968486-pls-provide-me-a-if-function-from-the-group-of-4-numbers-on-last-two-values-2007-sheet
Sheet: Sheet1

 |  | UNIT |  |  |  | UNIT |  |  |  | UNIT |  |  |  | UNIT
 |  | -6955 |  |  |  | -6955 |  |  |  | 2410 |  |  |  | -6955
 |  | -4857.5 |  |  |  | -4857.5 |  |  |  | 436.2500000000001 |  |  |  | -4857.5
 |  | -1427.5 |  |  |  | -1427.5 |  |  |  | -6955 |  |  |  | -1427.5
 |  | 2410 |  |  |  | 2410 |  |  |  | -3650 |  |  |  | 2410
 |  | -1520 |  |  |  | 436.25 |  |  |  | -2415 |  |  |  | -3510
 |  | PROBLEM SOLVED |  |  |  | PROBLEM SOLVED |  |  |  | PROBLEM |  |  |  | PROBLEM SOLVED
 | (HERE I WANT - POSITIVE INDICATION) BECAUSE ABOVE GROUP OF NUMBERS -1520 NOT COVER 2410 VALUE INDICATE POSITIVE |  |  |  | (HERE I WANT - POSITIVE INDICATION) BECAUSE ABOVE GROUP OF NUMBERS 436.25 VALUE INDICATE POSITIVE ALSO 2410 INDICATE POSITIVE |  |  |  | HERE ONE PROBLEM FOUND, -2415 IS GRATER THAN -3650. SO HERE I WANT POSITIVE INDICATION?? (HERE -2415 TO COVERED -3650) |  |  |  | Negative if formula works well
 |  |  |  |  | I WANT INTO ONE FORMULA