tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 769568d1645603483-help-refer-formula-to-specific-range-example-ans
Sheet: Sheet1

ID Number | Date | amount
1020 | 2017-12-26 00:00:00 | -30000
1020 | 2018-03-06 00:00:00 | 6000
1020 | 2018-03-26 00:00:00 | 8210
1020 | 2018-04-10 00:00:00 | 13713.92
3320 | 2017-08-25 00:00:00 | -35000 | xirr for 3320
3320 | 2017-11-03 00:00:00 | 38000
3358 | 2020-01-28 00:00:00 | -25000 | xirr for 3358
3358 | 2020-02-25 00:00:00 | 1939.6
3358 | 2020-03-05 00:00:00 | 960
3358 | 2020-03-30 00:00:00 | 5000
3358 | 2020-04-20 00:00:00 | 5000
3358 | 2020-04-30 00:00:00 | 5000
3358 | 2020-05-15 00:00:00 | 5000
3358 | 2020-07-06 00:00:00 | 1340
3358 | 2020-07-27 00:00:00 | 1840.92
3358 | 2020-08-17 00:00:00 | 7786.33
3358 | 2020-09-04 00:00:00 | 1043.44
3358 | 2020-09-18 00:00:00 | 800
3358 | 2020-10-21 00:00:00 | 800
3358 | 2020-11-06 00:00:00 | 750
2222 | 2020-11-03 00:00:00 | -3000 | xirr for 2222
2222 | 2020-11-18 00:00:00 | 5244.68
2222 | 2021-03-29 00:00:00 | 575.32
2222 | 2021-07-01 00:00:00 | 25648.11
Spreadsheet: 711808d1609923949-color-change-of-a-cell-needed-based-on-a-value-sample
Sheet: Sheet1

Task Name | 2021-01-01 00:00:00 | 2021-01-02 00:00:00 | 2021-01-03 00:00:00 | 2021-01-04 00:00:00 | 2021-01-05 00:00:00 | 2021-01-06 00:00:00 | 2021-01-07 00:00:00 | 2021-01-08 00:00:00 | 2021-01-09 00:00:00 | 2021-01-10 00:00:00 | 2021-01-11 00:00:00 | 2021-01-12 00:00:00 | 2021-01-13 00:00:00 | 2021-01-14 00:00:00 | 2021-01-15 00:00:00 | 2021-01-16 00:00:00 | 2021-01-17 00:00:00
ABC | 8
DEF |  | 8 | 4 |  | 4
GHI |  |  | 4
Vacation |  |  |  | 8
JKL |  |  |  |  | 4 | 3
MNO |  |  |  |  |  | 5
PQR |  |  |  |  |  |  | 8
Vacation |  |  |  |  |  |  |  | 8
Vacation |  |  |  |  |  |  |  |  | 8
STU |  |  |  |  |  |  |  |  |  | 8 | 3 | 3
UVW |  |  |  |  |  |  |  |  |  |  | 5 | 3
XYZ |  |  |  |  |  |  |  |  |  |  |  | 2
HJU |  |  |  |  |  |  |  |  |  |  |  |  | 8
Vacation |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
Vacation |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
BHY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
MLO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  | Color change of a cell needed based on a value
 |  |  |  | Hi all,
 |  |  |  | Hope everything is great and everyone are safe at home!!
 |  |  |  | Could anyone please help out on one of my request as mentioned below.
 |  |  |  | Attached is the "Sample" spreadsheet for my explanation.
 |  |  |  | My requirement is that,
 |  |  |  | I have entered hours on each date that I worked upon on each task (Column 'A') everyday. And in the Column 'A' (Task), whenever "Vacation" exists, when I enter any value (Like 4 or 8 etc etc), the cell color has to be changed to red with the value entered on that particular date.
 |  |  |  | In the attached spreadsheet, I have shown manually like how it has to appear.
 |  |  |  | Could anyone please help me out on adding a formula (Like using Conditional Formatting or any other option) such that the cell color has to be changed automatically when entered the value under Vacation Task on any of the date.
Spreadsheet: 873885d1720469022-help-please-not-sure-what-formulas-to-use-book1
Sheet: Sheet1

Team 1 | Team 2 | Team 3 | Team 4 | Team 5 | Team 6 |  |  | Name | Team name
A | f | j | p | u | x |  |  | a | in this column lookup from table so that if I change the name a team has it changes here also
b | g | k | q | v | y |  |  | b | eg move "c" from team 1 to team 5 in table  should auto update team name in this column
c | h | l | r | w | z |  |  | c | 1
d | i | m | s |  | aa |  |  | d | 1
e |  | n | t |  | bb |  |  | e | 1
 |  | o |  |  |  |  |  | f | 2
 |  |  |  |  |  |  |  | g | 2
 |  |  |  |  |  |  |  | h | 2
 |  |  |  |  |  |  |  | i | 2
 |  |  |  |  |  |  |  | j | 3
 |  |  |  |  |  |  |  | k | 3
 |  |  |  |  |  |  |  | l | 3
 |  |  |  |  |  |  |  | m | 3
 |  |  |  |  |  |  |  | n | 3
 |  |  |  |  |  |  |  | o | 3
 |  |  |  |  |  |  |  | p | 4
 |  |  |  |  |  |  |  | q | 4
 |  |  |  |  |  |  |  | r | 4
 |  |  |  |  |  |  |  | s | 4
 |  |  |  |  |  |  |  | t | 4
 |  |  |  |  |  |  |  | u
 |  |  |  |  |  |  |  | v
 |  |  |  |  |  |  |  | w
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | y
 |  |  |  |  |  |  |  | z
 |  |  |  |  |  |  |  | aa
 |  |  |  |  |  |  |  | bb
 |  |  |  |  |  |  |  | cc
 |  |  |  |  |  |  |  | dd
Spreadsheet: 478455d1472809127-date-filter-in-pivot-table-pivot_data-filter
Sheet: Sheet1

 |  | filter possibility in Data Table
 |  | date | color | qty
 |  | 2016-09-02 00:00:00 | black | 4
 |  | 2016-09-03 00:00:00 | blue | 3
 |  | 2016-09-04 00:00:00 | black | 2
 |  | 2015-01-02 00:00:00 | yellow | 3
 |  | 2015-01-03 00:00:00 | black | 4
 |  | 2015-02-07 00:00:00 | red | 5
 |  | the same I'd like to have in Pivot Table
 |  | date | (All)
 |  | Row Labels | Sum of qty
 |  | black | 10
 |  | blue | 3
 |  | red | 5
 |  | yellow | 3
 |  | Grand Total | 21
Spreadsheet: 0791d3d9-ae77-4c49-bd54-8b3347914f8a
Sheet: 2005-06

Table N
Students Domiciled within the UK by Method of Study
Country/Region | Undergraduate |  |  | Graduate |  |  | Total
 | Full Time | Part Time | Total | Full Time | Part Time | Total
England
Greater London | 4042 | 103 |  | 1142 | 1139
South East | 2381 | 36 |  | 641 | 591
South West | 556 | 5 |  | 106 | 63
North and Yorkshire | 325 | 2 |  | 80 | 35
North West | 332 | 0 |  | 62 | 43
Midlands | 600 | 6 |  | 144 | 83
East Anglia | 308 | 1 |  | 72 | 92
Not Known | 0 | 0 |  | 1 | 1
Subtotal
Northern Ireland | 41 | 0 |  | 15 | 9
Scotland | 73 | 0 |  | 37 | 21
Wales | 201 | 1 |  | 37 | 18
Channel Isles and Isle of Man | 28 | 0 |  | 1 | 4
Not Known | 47 | 3 |  | 65 | 34
Total
This table is concerned with students whose domicile at the time of application is within the UK irrespective of nationality.
The sum of Tables N and O is equivalent to the total number of students attending UCL.
Spreadsheet: 69109d1269609925-using-sum-match-book1
Sheet: Sheet2

 |  | CAT
Apple |  | II
Apple |  | II
Apple |  | I
Apple |  | I
Apple |  | III
Grape |  | II
Apple |  | I
Apple |  | I
Apple |  | II
Apple |  | I
[NAME] |  | I
[NAME] |  | I
[NAME] |  | II
[NAME] |  | III
Grape |  | II
Spreadsheet: 762094d1641393701-combine-columns-datas-for-identical-values-in-first-column-test5-2-ans2
Sheet: result

node | supp Type | TAG | TAG_all
 | +ZX | text1 | text1
185 | +ZGuide(2)LIM(4) | text2 | text2
380 | ANC | supp(0001) | text3|supp(0001)
10000 | +ZGuide(2) | supp(0002) | tag2|tag3|supp(0002)
10020 | +ZGuideLIM | supp(0003) | supp(0003)
6000 | +ZGuideLIM | supp(0004) | tag4|supp(0004)
#N/A | #N/A | supp(0005) | tag5|tag6|supp(0005)
#N/A | #N/A | lmnopqrstuvz | tag7|tag8|abcdefghijklmnopqrstuvz
Spreadsheet: 723367d1615651907-formula-to-find-and-replace-special-characters-according-to-a-table-test-formula-spec-characters
Sheet: SpecChar

 |  | [NAME] | [NAME] |  |  |  | Original text | Desired Result based on a formula
 |  | à | a |  |  |  | République | Republique
 |  | á | a |  |  |  | AAbbCCddEE | AAbbCCddEE
 |  | â | a |  |  |  | õÙŸ á | oUY a
 |  | ã | a |  |  |  | L'Alleud | L Alleud
 |  | ä | a |  |  |  | d'Albon | d Albon
 |  | å | a
 |  | ç | c
 |  | è | e
 |  | é | e
 |  | ê | e
 |  | ë | e
 |  | ì | i
 |  | í | i
 |  | î | i
 |  | ï | i
 |  | ð | o
 |  | ñ | n
 |  | ò | o
 |  | ó | o
 |  | ô | o
 |  | õ | o
 |  | ö | o
 |  | ù | u
 |  | ú | u
 |  | û | u
 |  | ü | u
 |  | ý | y
 |  | ÿ | y
 |  | Š | S
 |  | Ž | Z
 |  | š | S
 |  | ž | Z
 |  | Ÿ | Y
 |  | À | A
 |  | Á | A
 |  | Â | A
 |  | Ã | A
 |  | Ä | A
 |  | Å | A
 |  | Ç | C
 |  | È | E
 |  | É | E
 |  | Ê | E
 |  | Ë | E
 |  | Ì | I
 |  | Í | I
 |  | Î | I
 |  | Ï | I
 |  | Ð | D
 |  | Ñ | N
 |  | Ò | O
 |  | Ó | O
 |  | Ô | O
 |  | Õ | O
 |  | Ö | O
 |  | Ù | U
 |  | Ú | U
 |  | Û | U
 |  | Ü | U
 |  | Ý | Y
 |  | '
 |  | ‘
 |  | ’
Spreadsheet: 841364d1693552207-match-date-on-two-different-pages-and-paste-data-in-columns-copy-of-copy-of-ef-file-
Sheet: 1-14 Day

 | CR1 | Priority | Headcount
1 | Architect RV | 18 | 0.25
2 | Alinity RV | 17 | 0.25 |  | 4 QI's
3 | Alinity RV | 16 | 0.25
4 | Alinity RV | 15 | 0.25
5 | Architect RV | 14 | 0.25
12 | [NAME] | 19 | 0.25
13 | [NAME] | 20 | 0.25
9 | Architect RV | 13 | 0.25
15 | Architect SC | 12 | 0.25
17 | Architect RV | 11 | 0.25
50 | Baxter SIV Assy | 21 | 2
31 | Architect RV | 10 | 0.25
8 | Alinity RV | 9 | 0.25
10 | Architect RV | 8 | 0.25
11 | [NAME]
18 | Architect RV | 7 | 0.25
19 | Architect RV | 6 | 0.25
20 | Siemens Sleeves/Beckman 3ml
21 | Architect RV | 5 | 0.25
22 | Architect RV | 4 | 0.25
23 | Architect RV | 3 | 0.25
30 | Architect RV | 2 | 0.25
7 | Architect SC | 1 | 0.25
Total
 | CR2 | Priority
73 | PP3 | 5 | 0.25
74 | 6ul | 4 | 0.25
77 | PP4 | 3 | 0.25
78 | Side Cassette A | 2 | 0.25
79 | NP V102 | 1 | 0.25
87 | [NAME] | 6 | 0.25
52 | Architect RV | 8 | 0.25
53 | Architect RV | 9 | 0.25
61 | [NAME]
66 | [NAME]
83 | Ceph OM#1 | 7 | 2
84 | Ceph MB#1
86 | [NAME] | 10 | 0.25
62 | NP227
63 | NP Birdcage
64
67 | [NAME]
69
88 | Side Pump | 11 | 0.25
89 | PCR Tube | 12 | 0.25
106 | Key 4 Calm Blue | 16 | 2
107 | Snap Ring | 17 | 0.25
108
109 | Over [NAME] | 18 | 0.25
Total
Spreadsheet: 758592d1638963772-copy-data-when-criteria-match-gk
Sheet: Sheet1

def
Model | TITLE2 | Code | TITLE4 | TITLE5 | TITLE6 | TITLE7 | TITLE8 | TITLE9 | TITLE10 | TITLE11 | TITLE12 | TITLE13 | TITLE14 | TITLE15
Spreadsheet: 222737d1363918623-need-to-create-multiple-invoices-with-multiple-items-sample-data
Sheet: Invoice Template

Company Reg. 12345678 |  |  |  |  | VAT . 123 4567 91
 |  |  |  |  | Invoice
 |  |  |  |  | Date
[NAME] | QTY | Face Value | Disc. | Net | VAT (20%) | Net Inc. VAT
Total
 |  |  |  |  | Net Amount
 |  |  |  |  | VAT (20%)
 |  |  |  |  | Grand Total
Spreadsheet: 758337d1638823150-a-list-of-more-than-3-consecutive-days-and-the-amount-must-be-5-5-forumhelp_12-06
Sheet: Sheet1

Type | Date | Amount |  | Type | Date | Amount
A | 2020-07-16 00:00:00 | 5.3 |  | B | 2021-07-27 00:00:00 | 5.5 |  |  | 2021-07-27 00:00:00 | 5.5 |  |  | A list of more than 3 consecutive days and the amount must be >=5.5
A | 2020-07-27 00:00:00 | 4.5 |  | B | 2021-07-28 00:00:00 | 5.7 |  | 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 |  | 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-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-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-30 00:00:00 | 7.1
B | 2021-07-28 00:00:00 | 5.7 |  | D | 2021-07-30 00:00:00 | 6.4 |  | 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 |  | 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 |  | 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-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-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-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 |  | 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 |  | 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 |  | 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-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: 94498d1294303304-excel-2007-find-appropriate-price-book1
Sheet: Sheet1

 | [NAME] | Height | Border | Quantity |  | Price
Duck Feather | 20 | 20 | 3 | 1 |  | 24.66666666666667
Filling | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5
Duck Feather | 3.4 | 2.96 | 2.6 | 2.35 | 2.14 | 1.97 | 1.83 | 1.72 | 1.61 | 1.54 | 1.47 | 1.41
 | 28.33 | 28.78 | 28.89 | 29.38 | 29.72 | 30.1 | 30.5 | 31.06 | 31.31 | 32.08 | 32.67 | 33.29
Spreadsheet: 724801d0-c91c-46e2-a68c-175d1ddf4c00
Sheet: Sheet1

Table 3--Soybean oil:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning | Production | Imports | Total |  | Domestic |  |  | Exports | Total | Ending
October 1 | stocks |  |  |  |  | Total | Biodiesel | Food |  |  | stocks
 | Million pounds
2011/12 | 2425.347 | 19740 | 149.294 | 22314.641 |  | 18310.278 | 4870 | 13440.278 | 1464.363 | 19774.641 | 2540
2012/131 | 2540 | 19590 | 350 | 22480 |  | 18550 | 4900 | 13650 | 2200 | 20750 | 1730
2013/142 | 1730 | 19495 | 250 | 21475 |  | 18550 | 5400 | 13150 | 1300 | 19850 | 1625
1 Estimated.  2 Forecast.
Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates.
Last update: | 2013-06-13 11:00:47.520000
Spreadsheet: john_lavorato__16440__Pwr west P&L
Sheet: Pwr west P&L

ENRON POWER TRADING & TRANSMISSION
DAILY PROFIT LOSS STATEMENT - WEST
DATE: | 1999-02-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | CHECK
 |  | DESK | 1 DAY | 5 DAY | MTD | QTD | YTD | YTD | 4th Quarter | 3rd Quarter | 2nd Quarter | 1st Quarter | Expected Liquidations | Difference in YTD
 |  | W-MGMT [NAME]
 |  | Northwest  [NAME]
 |  | [NAME]   [NAME]
 |  | Southwest  [NAME]
 |  | W-Trans  M.Swerzbin, [NAME]
 |  | Option
 |  | Spread Option
 |  | Service
 |  | TOTAL  LONG TERM
 |  | California  Jeff Richter
 |  | Northwest  Sean Crandall
 |  | Southwest  [NAME], [NAME]
 |  | Hourly  [NAME]
 |  | Management
 |  | W-BOM  [NAME]
 |  | TOTAL  SHORT TERM
 |  | TOTAL
Spreadsheet: 769449d1645544470-lookup-formula-for-unique-value-in-data-table-relations-list-aligw
Sheet: Sheet1

Team Member Selected
Team Member 1
 |  |  |  | Team Members: | Relationship Name |  |  |  |  | Need:
 |  |  |  | Team Member 1 | Name 1
 |  |  |  | Team Member 2 | Name 2
 |  |  |  | Team Member 3 | Name 3
 |  |  |  | Team Member 4 | Name 4
 |  |  |  | Team Member 5 | Name 5
 |  |  |  | Team Member 6 | Name 6
 |  |  |  | Team Member 7 | Name 7
 |  |  |  | Team Member 8 | Name 8
 |  |  |  | Team Member 9 | Name 9
 |  |  |  | Team Member 10 | Name 10
 |  |  |  | Team Member 2 | Name 11
 |  |  |  | Team Member 2 | Name 12
 |  |  |  | Team Member 2 | Name 13
 |  |  |  | Team Member 9 | Name 14
 |  |  |  | Team Member 9 | Name 15
 |  |  |  | Team Member 9 | Name 16
 |  |  |  | Team Member 9 | Name 17
 |  |  |  | Team Member 1 | Name 18
 |  |  |  | Team Member 1 | Name 19
 |  |  |  | Team Member 1 | Name 20
 |  |  |  | Team Member 4 | Name 21
 |  |  |  | Team Member 4 | Name 22
 |  |  |  | Team Member 4 | Name 23
 |  |  |  | Team Member 4 | Name 24
 |  |  |  | Team Member 4 | Name 25
 |  |  |  | Team Member 4 | Name 26
 |  |  |  | Team Member 6 | Name 27
 |  |  |  | Team Member 6 | Name 28
 |  |  |  | Team Member 6 | Name 29
 |  |  |  | Team Member 6 | Name 30
 |  |  |  | Team Member 5 | Name 31
 |  |  |  | Team Member 5 | Name 32
 |  |  |  | Team Member 5 | Name 33
 |  |  |  | Team Member 5 | Name 34
 |  |  |  | Team Member 1 | Name 35
Spreadsheet: 873207d1719636596-how-to-index-match-with-n-a-error-in-range-of-cells-how-do-you-ignore-the-n-a-index-match_na
Sheet: Sheet1

DATE & TIME | no | [NAME]
 | ppb | ppb
2024-06-25 00:00:00 | #N/A | 23.01833333333334
2024-06-25 01:00:00 | 27.57499999999999 | 17.115
2024-06-25 02:00:00 | 23.10666666666667 | 12.23833333333334
2024-06-25 03:00:00 | 26.31666666666667 | 15.235
2024-06-25 04:00:00 | 26.97000000000002 | 16.46833333333334
2024-06-25 05:00:00 | 26.61166666666667 | 15.145
2024-06-25 06:00:00 | 25.68833333333334 | 15.93333333333333
2024-06-25 07:00:00 | 24.61 | 14.85
2024-06-25 08:00:00 | 28.44666666666667 | 19.18833333333333
2024-06-25 09:00:00 | 27.98666666666667 | 17.41166666666667
2024-06-25 10:00:00 | 27.23833333333334 | 16.675
2024-06-25 11:00:00 | 29.68499999999999 | 19.32666666666666
2024-06-25 12:00:00 | 24.87666666666667 | 15.45666666666667
2024-06-25 13:00:00 | 33.12 | 22.27833333333333
2024-06-25 14:00:00 | 28.345 | 18.65833333333334
2024-06-25 15:00:00 | 31.57666666666667 | 20.71833333333333
2024-06-25 16:00:00 | 34.395 | 24.03666666666667
2024-06-25 17:00:00 | 26.71666666666666 | 16.02166666666666
2024-06-25 18:00:00 | 29.98833333333333 | 17.48666666666667
2024-06-25 19:00:00 | 28.57833333333334 | 18.16833333333334
2024-06-25 20:00:00 | 34.02666666666666 | 23.795
2024-06-25 21:00:00 | 31.49833333333334 | 20.91833333333333
2024-06-25 22:00:00 | 26.935 | 16.16666666666667
2024-06-25 23:00:00 | 27.11333333333334 | 17.34500000000001
Minimum
MinTime
Maximum
MaxTime
Spreadsheet: benjamin_rogers__1070__gencomodel
Sheet: Summary

 |  |  | 0 | 0 | 0 | 0
Deterministic Asset Valuation Model
Valuation Summary
 |  |  | Value | Value | Value |  | Total
 | Unit(s) | Capacity | (2000-2005) | (2006-2019) | (Terminal) |  | Value | $/Kw
 | BaseLoad Total
 | Peaker Total
 | Cinergy Total
 |  |  | PPA Value | Value | Value |  | Total
 | Unit(s) | Capacity | (2000-2005) | (2006-2019) | (Terminal) |  | Value | $/Kw
1 |  |  | 107783523.7125811 | 169183002.4070187 | 35638283.54078762
2 |  |  | 149589011.1152095 | 258782362.6825195 | 56382647.14793528
3 |  |  | 74719425.6112762 | 120709445.2834871 | 26144863.61964842
4 |  |  | 72098806.15781717 | 118465728.8647262 | 25661806.85515024
5 |  |  | 73783798.9143284 | 116778749.4866572 | 25281208.26483831
6 |  |  | 74828326.82357125 | 118643446.3439347 | 25725795.77994119
7 |  |  | 69302142.64740767 | 110875262.6293007 | 23927760.53979462
8 |  |  | 14786498.4611668 | 13373881.31844035 | 2837000.62201141
9 |  |  | 50707812.02018376 | 75215232.2675086 | 16240077.01069046
10 |  |  | 93301607.67689751 | 170813250.1771931 | 36982003.56721519
11 |  |  | 101357072.2805852 | 175634597.9168494 | 38203712.71024915
12 |  |  | 23730630.85076145 | 31980239.21324166 | 6977691.197512204
13 |  |  | 23128886.43393182 | 31284472.65453895 | 6829348.518251621
14 |  |  | 36467024.97131649 | 51128149.6666076 | 11123907.26454168
15 |  |  | 44209553.17708519 | 63356847.68526394 | 13704749.41178547
16 |  |  | 74414111.86102997 | 99685656.12715274 | 21697798.94325095
17 |  |  | 46265138.27261424 | 64729986.16570944 | 14197788.60057323
18 |  |  | 271884664.5344557 | 368690532.8449074 | 79654593.10256025
19 |  |  | 6911270.435180964 | 3763504.906176125 | 727088.2888237719
20 |  |  | 1079519.965000227 | 390723.290416859 | 72346.52254323516
21 |  |  | 2432619.715890951 | 935246.3977497519 | 174085.6377392367
22 |  |  | 4418856.929688545 | 2051323.58397608 | 414601.8248510496
23 |  |  | 4650269.67649583 | 3703529.066825124 | 768760.1558646339
24 |  |  | 4650269.67649583 | 3703529.066825124 | 768760.1558646339
25 |  |  | 4650269.67649583 | 3703529.066825124 | 768760.1558646339
26 |  |  | 4650269.67649583 | 3703529.066825124 | 768760.1558646339
27 |  |  | 10811128.68609414 | 9336883.478956213 | 1795459.260884916
28 |  |  | 10811577.4848964 | 9336883.569637109 | 1795461.723769014
29 |  |  | 10796453.4040549 | 9340644.395618867 | 1796501.533368255
30 |  |  | 10796453.4040549 | 9340644.395618867 | 1796501.533368255
31 |  |  | 10782420.54043132 | 9347298.497969564 | 1798084.676936163
32 |  |  | 10784635.21641991 | 9350042.004857283 | 1798658.630585637
33 | VMC | 750 | 151522921.5541264 | 184239025.6865358 | 36678180.13459957
Spreadsheet: rick_buy__32953__raptor1j
Sheet: Summary

 | Raptor I Daily Position Report & Summary
 | Inputs:
 | Trade Date |  | Prior Day
 | Summary:
 | Gains and Losses | Total | Realized | Unrealized
 | Previous Day's Cumulative
 | Today's Activity
 | Cumlative Ending
 | Notional Capacity
 | Credit Capacity
 | Remaining Governance Capacity
Spreadsheet: 820726d1678270472-counting-available-beds-in-a-facility-new-sample
Sheet: Tabelle1

 | Room | Sex | Name | Infos | Planning |  | Available Beds
 | 1
 | 2 |  |  |  | 2023/03/10 New Patient |  | Female
 | 2 | f | Mrs. [NAME]
 | 3
 | 3 |  |  |  |  |  | Male
 | 4
 | 4 | m | Mr XY
 | 5 |  |  | 2023/03/10 New Patient |  |  | Unisex
 | 6
 | 7 |  |  |  | 2023/03/10 New Patient
 | 7
Spreadsheet: kate_symes__18764__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-01 00:00:00 |  | 254.01 | 12752 | 142.32 | 4776
 | 2001-02-28 00:00:00 |  | 178.77 | 16400 | 103.09 | 5920 | 271.72 | 2187 | 185.29 | 705
 | 2001-02-27 00:00:00 |  | 182.08 | 17920 | 98.83 | 5248 | 173.98 | 1198 | 145.57 | 1235
 | 2001-02-26 00:00:00 |  | 197.33 | 10400 | 128.16 | 4152 | 207.88 | 3693 | 115.94 | 1181
 | 2001-02-25 00:00:00 |  | 150 | 0 | 125 | 0 | 146.95 | 3690 | 109.13 | 1615 |  | 128.16 | 12456
 | 2001-02-24 00:00:00 |  | 183.8 | 14608 | 102.52 | 6472 | 184.67 | 3635 | 150.17 | 855
 | 2001-02-23 00:00:00 |  | 183.8 | 14608 | 102.52 | 6472 | 238.26 | 4340 | 143.66 | 910
 | 2001-02-22 00:00:00 |  | 216.97 | 18320 | 115.4 | 7080 | 206.96 | 2653 | 104.69 | 565
 | 2001-02-21 00:00:00 |  | 218.21 | 20720 | 137.88 | 10600 | 175.48 | 1613 | 94.66 | 1119
 | 2001-02-20 00:00:00 |  | 257.07 | 16960 | 162.15 | 8000 | 139.51 | 4942 | 140.75 | 1333
 | 2001-02-19 00:00:00 |  | 256.44 | 17088 | 163.04 | 8192 | 241.52 | 6020 | 167.98 | 773
 | 2001-02-18 00:00:00 |  | 345 | 400 | 242.5 | 0 | 168.63 | 565 | 156.11 | 1125 |  | 248.98 | 14640
 | 2001-02-17 00:00:00 |  | 317.77 | 5920 | 248.95 | 4888 | 281.44 | 2185 | 224.69 | 964
 | 2001-02-16 00:00:00 |  | 407.5 | 9600 | 255.33 | 3000 | 380.8 | 7853 | 212.12 | 765
 | 2001-02-15 00:00:00 |  | 407.5 | 9600 | 255.33 | 3000 | 429.36 | 8631 | 185.81 | 1490
 | 2001-02-14 00:00:00 |  | 260.6 | 15392 | 165.16 | 6200 | 368.89 | 6205 | 216.82 | 1085
 | 2001-02-13 00:00:00 |  | 204.61 | 28464 | 127.5 | 7152 | 213.1 | 4017 | 117.86 | 910
 | 2001-02-12 00:00:00 |  | 194.93 | 17552 | 141 | 4752 | 165.13 | 3805 | 115.9 | 481
 | 2001-02-11 00:00:00 |  | 153.75 | 112 | 150 | 56 | 134.71 | 1414 | 82.08 | 149 |  | 141.16 | 14856
 | 2001-02-10 00:00:00 |  | 150.49 | 27080 | 104.14 | 5240 | 140.81 | 430 | 173.37 | 178
 | 2001-02-09 00:00:00 |  | 150.65 | 32480 | 104.14 | 5240 | 171.89 | 2860 | 131.06 | 362
 | 2001-02-08 00:00:00 |  | 182.53 | 10624 | 115.29 | 7280 | 188.98 | 1327 | 99.67 | 694
 | 2001-02-07 00:00:00 |  | 165.65 | 16640 | 113.79 | 6040 | 170.48 | 1096 | 90.98 | 1046
 | 2001-02-06 00:00:00 |  | 156.9 | 18000 | 117.37 | 6400 | 125.6 | 1999 | 88.75 | 1161
 | 2001-02-05 00:00:00 |  | 151.48 | 12400 | 128.84 | 4400 | 113.86 | 1196 | 83.59 | 982
 | 2001-02-04 00:00:00 |  | 145 | 0 | 120 | 0 | 99.69 | 4662 | 101.68 | 220 |  | 128.84 | 13200
 | 2001-02-03 00:00:00 |  | 168.58 | 13568 | 128.08 | 4200 | 117.03 | 3689 | 99.69 | 1202
 | 2001-02-02 00:00:00 |  | 178.98 | 11968 | 128.08 | 4200 | 152.67 | 7590 | 120.57 | 710
 | 2001-02-01 00:00:00 |  | 239.7 | 15792 | 151.12 | 4208 | 156.7 | 4400 | 127.04 | 2339
 | 2001-01-31 00:00:00 |  | 258.52 | 12800 | 158.13 | 5192 | 175.35 | 3038 | 132 | 1931
 | 2001-01-30 00:00:00 |  | 244.66 | 12560 | 140.9 | 5400 | 178.19 | 3125 | 120.98 | 1446
Spreadsheet: 716259d1612126453-help-production-scheduling-network-days-estimated-job-finish-time-formula-schedule-test
Sheet: Feb 1st 2021

 |  |  |  |  |  | 0.8
Order | Batch | PRODUCT | MACHINE | [NAME] | Line speed/min | [NAME]/min | Changeover time | Start Time | Est finishtime
1 | `O420280 | ABC V1 | NJP1500 | 100000 | 1500 |  | 00:00:00 | 2021-02-01 10:30:00 | 2021-02-01 11:53:00
2 | `0420167 | ABC V2 | NJP1500 | 473000 | 1500 |  | 01:00:00 |  | 2021-02-02 11:19:00
3 | 0420281 | XYZ V1 | AF300 | 42000 | 1500 |  | 00:00:00 | 2021-02-01 10:30:00 | 2021-02-01 11:05:00
4 | 0420282 | [NAME] | AF300 | 216000 | 1500 |  | 07:00:00 | 2021-02-02 10:05:00 | 2021-02-02 13:05:00