tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1ad23ac6-e8a8-4905-b00b-35eb8e6d2609
Sheet: Sheet1

Table 9--Wheat:  U.S. exports, [NAME] and export sales comparison (1,000 metric tons),11/08/12 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | 2010/11 |  | 2011/12 |  | 2012/13(as of 11/8/12)
Importing |  |  |  |  |  | Out-
country |  |  |  |  | Shipments | standing | Total
Data |  | Export |  | Export | Export
source | Census 1/ | sales 2/ | Census 1/ | sales 2/ | sales 2/
Country:
Japan | 3318.4 | 3273 | 3513.4 | 3512.1 | 1448.1 | 508 | 1956.1
Mexico | 2749.7 | 2601 | 3794.3 | 3495.9 | 1255 | 713.9 | 1968.9
Nigeria | 3638.2 | 3645.3 | 3227.8 | 3248 | 1306.4 | 456.5 | 1762.9
Philippines | 1814.5 | 1806.3 | 2050 | 2038.6 | 918.5 | 422.1 | 1340.6
Korean Rep. | 1660.2 | 1640.2 | 2132.9 | 1983 | 642.8 | 307.6 | 950.4
Egypt | 3804.6 | 4021.2 | 915.5 | 949.8 | 131 | 24 | 155
Taiwan | 916.1 | 912.9 | 893.2 | 887.9 | 442.8 | 211 | 189.4
Indonesia | 762.9 | 781.4 | 794 | 830 | 283.2 | 90.5 | 373.7
Venezuela | 655.4 | 615.7 | 642.2 | 593.5 | 295.6 | 174.1 | 469.7
Iraq | 1083.2 | 1078.4 | 571.8 | 571.8 | 208.9 | 0 | 208.9
EU-27 | 1244.2 | 1307.6 | 1185.9 | 1228.1 | 271.1 | 65.5 | 336.6
Total grain | 34516.2 | 33438.5 | 27955.4 | 26627.3 | 10409.7 | 4296 | 14705.7
Total (including
products) | 35080.8 | 33485.9 | 28576.3 | 26812.5 | 10435.1 | 4319.6 | 14754.7
USDA forecast
of Census |  |  |  |  |  |  | 31298
1/ Source:  U.S. Department of Commerce, U.S. Census Bureau
2/ Source:  Foreign Agricultural Service's weekly U.S. Export Sales report.
Source:  USDA, Foreign Agricultural Service's, U.S. Export Sales.
Spreadsheet: 217767d1362172969-rows-of-records-each-w-start-and-end-date-need-to-compile-and-summarize-month-by-month-dummyforecastfy2014
Sheet: Monthly

 |  | Inventory |  |  | Forecast
Fiscal Year | Month | Raw | WIP | Finished | Baseline | Optimal | Best Case
2013 | March | 90 | 10 | 30 |  |  |  |  |  | Unit Price: | 4700
 | April
 | May
 | June
2014 | July
 | August
 | September
 | October
 | November
 | December
 | January
 | February
 | March
 | April
 | May
 | June
Spreadsheet: michael_maggi__26465__NYMEXWEEKLY
Sheet: cl

Week Ending: | 2001-10-19 00:00:00
 | Futures Settlement Prices
 | CRUDE OIL |  |  |  |  | Contract Symbol:  CL
 | Contract | Monday | Tuesday | Wednesday | Thursday | Friday | Open
 | Month | 2001-10-15 00:00:00 | 2001-10-16 00:00:00 | 2001-10-17 00:00:00 | 2001-10-18 00:00:00 | 2001-10-19 00:00:00 | Interest
 | 2001-11-01 00:00:00 | 22.29 | 22 | 21.81 | 21.31 | 21.83 | 49244
 | 2001-12-01 00:00:00 | 22.58 | 22.26 | 22.1 | 21.55 | 22.26 | 134612
 | 2002-01-01 00:00:00 | 22.71 | 22.39 | 22.25 | 21.77 | 22.41 | 42141
 | 2002-02-01 00:00:00 | 22.78 | 22.46 | 22.33 | 21.89 | 22.48 | 21235
 | 2002-03-01 00:00:00 | 22.83 | 22.51 | 22.4 | 21.98 | 22.54 | 19467
 | 2002-04-01 00:00:00 | 22.85 | 22.52 | 22.43 | 22.05 | 22.56 | 16882
 | 2002-05-01 00:00:00 | 22.79 | 22.47 | 22.42 | 22.07 | 22.56 | 11914
 | 2002-06-01 00:00:00 | 22.72 | 22.41 | 22.38 | 22.05 | 22.53 | 26078
 | 2002-07-01 00:00:00 | 22.65 | 22.35 | 22.33 | 22.02 | 22.49 | 9685
 | 2002-08-01 00:00:00 | 22.57 | 22.28 | 22.26 | 21.97 | 22.44 | 11311
 | 2002-09-01 00:00:00 | 22.49 | 22.21 | 22.19 | 21.92 | 22.39 | 12370
 | 2002-10-01 00:00:00 | 22.4 | 22.14 | 22.12 | 21.86 | 22.32 | 7128
 | Total Weekly Volume
 |  |  | 701242 |  | Total Open Interest |  | 448047
 |  |  |  | *Weekly volume and open interest reflects all traded months.
 | Historical Volatility-Spot Month Futures
 |  |  |  | Crude Oil
 | 5 Day Hist. Vol. |  |  | 0.33
 | 20 Day Hist. Vol. |  |  | 0.3434
 | Implied Volatility-Options
 |  |  |  | Crude Oil
 | At the Money Call & Put
 |  |  |  | 0.5686
Spreadsheet: 25adb450-c9a1-497a-b040-74388aa07a06
Sheet: Annual Rate

 | Microsoft Annual Charge Rates
 | OSF Billing Part Number | Item | Annual Rate
 | 00310 | Operating System Upgrade Rights | 55
 | 00311 | Microsoft Office Professional Plus w/ upgrade rights | 147
 | 00315 | Windows Server CAL | 9
 | 00312 | Exchange Server CAL + Exchange Enterprise CAL | 34
 | 00314 | SharePoint Server CAL | 28
 | 00313 | Lync Server CAL | 10
Spreadsheet: 827745d1683014719-average-timings-exercise-sample
Sheet: Snapshot

 |  | 2023
 |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
 | Average Timings |  |  |  |  |  |  |  |  |  |  |  |  | Yearly Average
 | External |  |  | 11 |  |  |  |  |  |  |  |  |  |  |  | *I want to calculate the average days between F2 and G2 by month. It is important to ignore if there are blank cells on G2.
 | Cash Received |  |  | 19.5 |  |  |  |  |  |  |  |  |  |  |  | *I want to calculate the average days between B2 and E2 by month. It is important to ignore if there are blank cells on E2.
 | Letter To Authorities |  |  | 1.4 |  |  |  |  |  |  |  |  |  |  |  | *I want to calculate the average days between C2 and D2 by month. It is important to ignore if there are blank cells on D2.
 | Authorities Response
 | [NAME] |  |  | 2 |  |  |  |  |  |  |  |  |  | 2 |  | *I want to calculate the average days between B2 and D2 by month and by category (Column A). It is important to ignore if there are blank cells on D2.
 | Lim |  |  | 5 |  |  |  |  |  |  |  |  |  | 5 |  | I also want to calculate the total average timings for each category on a yearly basis.
 | Paf |  |  | 13 |  |  |  |  |  |  |  |  |  | 13
 | Lar |  |  | 3 |  |  |  |  |  |  |  |  |  | 3
 | Amm |  |  | 17 |  |  |  |  |  |  |  |  |  | 17
Spreadsheet: 72805d1273531771-repeating-values-using-vlookup-function-example
Sheet: List

NAME | VALUE
ABC1
[NAME]
ABC3
[NAME]
ABC5
ABC6
ABC7
ABC8
ABC9
ABC10
ABC11
ABC12
ABC13
ABC14
ABC15
ABC16
ABC17
ABC18
ABC19
ABC20
ABC21
ABC22
ABC23
ABC24
ABC25
Spreadsheet: 755810d1637104775-how-do-i-change-the-conditional-formatting-for-dates-and-date-ranges-on-this-calendar-test-calendar
Sheet: Detailed Calendar

 |  |  |  |  |  |  | S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If more week columns are needed simply copy last week's column section and paste at the end.
 |  | [NAME] and Events
 | Project | Dates and Events
 | Project Start Date | 2022-01-01 00:00:00 |  |  | Choose Project Week: | 1
LEAD | TASKS | START DATE | END DATE | DAYS
HOLIDAYS | Holiday Name |  |  | 0
Holiday | [NAME] | 2022-01-17 00:00:00 | 2022-01-17 00:00:00
Holiday | Good Friday | 2022-04-15 00:00:00 | 2022-04-15 00:00:00
Holiday | Memorial Day | 2022-05-30 00:00:00 | 2022-05-30 00:00:00
Holiday | Independence Day | 2022-07-04 00:00:00 | 2022-07-04 00:00:00
Holiday | Christmas Day | 2022-12-25 00:00:00 | 2022-12-25 00:00:00
Holiday | [NAME]'s Day | 2022-02-14 00:00:00 | 2022-02-14 00:00:00
Seasonal Events | Multi-Day Events
weeks
SEASONAL EVENT 1 | [NAME]'s Day Kid's Week | 2021-06-17 00:00:00 | 2021-06-26 00:00:00
SEASONAL EVENT 2 | Bring your Parent | 2022-10-24 00:00:00 | 2022-10-28 00:00:00
SEASONAL EVENT  3 | Team 1 Retreat | 2022-03-16 00:00:00 | 2022-03-20 00:00:00
SEASONAL EVENT 4 | Teacher's Planning Sessions | 2021-12-28 00:00:00 | 2022-01-16 00:00:00
SEASONAL EVENT 5 | Summer Vacation | 2022-06-20 00:00:00 | 2022-08-29 00:00:00
SEASONAL EVENT 6 | Winter Planning Sessions | 2022-09-14 00:00:00 | 2022-10-02 00:00:00
Spreadsheet: kevin_hyatt__19649__San Juan supply 2-19
Sheet: Plants

Gas Plant Capacity & Thruput (MMcf/d)
 |  |  | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
[NAME]
Operator | Plant Name | Capacity
Red Cedar | Antler | 45 | 25 | 16 | 36 | 40 | 32 | 25 | 22 | 10 | 0 | 0 | 0
Red Cedar | Arkansas Loop | 230 | 225 | 250 | 245 | 240 | 225 | 209 | 188 | 165 | 148 | 138 | 125
KN Energy | [NAME] | 195 | 177 | 180 | 182 | 184 | 175 | 159 | 148 | 132 | 109 | 90 | 71
Amoco | Florida | 240 | 223 | 252 | 253 | 255 | 248 | 235 | 215 | 186 | 162 | 149 | 138
Burlington | [NAME] | 27 | 26 | 25 | 25 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Williams FS | La Maquina | 140 | 117 | 80 | 75 | 62 | 50 | 20 | 0 | 0 | 0 | 0 | 0
Williams FS | Milagro | 610 | 554 | 565 | 528 | 487 | 461 | 434 | 419 | 388 | 371 | 351 | 330
Burlington | [NAME] | 470 | 481 | 410 | 358 | 317 | 277 | 244 | 217 | 201 | 181 | 160 | 141
Elm Ridge |  |  | 8 | 9 | 12 | 13 | 14 | 14 | 13 | 12 | 11 | 10 | 10
Red Cedar La Plata |  |  | 0 | 8 | 20 | 24 | 26 | 26 | 25 | 24 | 21 | 18 | 15
Subtotal CBM
Capacity Utilization
Conventional
Operator | Plant Name | Capacity
EPFS | Chaco | 520 | 461 | 454 | 467 | 475 | 482 | 489 | 493 | 500 | 505 | 510 | 516
EPFS | Dry gas |  | 30 | 20 | 20 | 21 | 21 | 22 | 22 | 22 | 23 | 23 | 23
Williams FS | [NAME] | 520 | 480 | 485 | 488 | 490 | 494 | 495 | 501 | 507 | 514 | 518 | 520
Williams FS | [NAME] | 210 | 195 | 198 | 208 | 210 | 212 | 213 | 214 | 215 | 217 | 218 | 220
Williams FS | Lybrook | 70 | 62 | 65 | 65 | 66 | 67 | 68 | 70 | 72 | 74 | 76 | 78
Conoco | San Juan Gas | 440 | 406 | 409 | 412 | 415 | 418 | 423 | 424 | 428 | 434 | 437 | 444
Western Gas Processors | San Juan River | 50 | 22 | 22 | 22 | 22 | 20 | 20 | 20 | 20 | 19 | 18 | 17
Subtotal Conv
Capacity Utilization
Total
Capacity Utilization
Spreadsheet: 867873d1714651200-using-left-and-find-inside-index-and-small-function-index-issue-aligw
Sheet: Summary

 | [NAME] |  | [NAME]
 | Enquiry |  | Enquiry
 |  |  | 6934826
 |  |  | 7091621
 |  |  | 7104521
Spreadsheet: 40d62040-07d7-43a7-93e0-034aa9cf2ca5
Sheet: Electrofishing_metadata

REPORT OF FISH TAKEN UNDER A SCIENTIFIC COLLECTORS PERMIT
Name: |  |  | Affiliation:
Address: |  |  | City:
State/Zip: |  |  | Phone:
[NAME]:
Sheet 1 Sampling metadata: The information below is the top portion (header) of the FWP Electrofishing Field Form.
 | Details about catch (fish details) are recorded on the "fish details template" worksheet.
1 | Permit Number
2 | PermitYear
3 | Water Name
4 | Section |  | For a new section use stream name and distance upstream from mouth
5 | Date |  | MM\DD\YYYY
6 | Observers |  | (Name of crew, first & last names or initial)
7 | Purpose |  | (Long-term [NAME]/absence\Other)
8 | Gear |  | (Boat\Boom\Mobile\Backpack\Bank\Crawdad\Other)
9 | Trip Type (M or R) |  | (M [Mark] and R [Recapture] are only checked if conducting a mark/ recapture estimate)
10 | Pass # or Run # |  | (could be pass# or run #,e.g., 1st marking run, or 1st pass of depletion estimate)
11 | Rectifying Unit Name
12 | Rectifying Unit Model
13 | Volts |  | Average or range
14 | Amps |  | Average or range
15 | Shock Time (secs) |  | From rectifying unit, time of entire survey secs
16 | Bank Shocked |  | (left\right\middle\all)
17 | % Section Sampled
18 | Section Length
19 | Section Length Units |  | (m, km, miles)
20 | Section Width |  | (Wetted width, either average or range)
21 | Section Width Units |  | (ft, m)
22 | Lat/Long Up |  | (NAD 83, decimal degrees)
23 | Lat/Long Down |  | (NAD 83, decimal degrees)
24 | Start Time (24 hr)
25 | End Time (24 hr)
26 | Turbidity
27 | Turbidity Units |  | (NTU, cm, m)
28 | Turbidity measurement gear |  | (disk, tube, meter
29 | Turbidity Time (24 hr)
30 | Conductivity (µs)
31 | Conductivity Time (24 hr)
32 | Water temp
33 | Water Temp Units |  | (Deg C, Deg F)
34 | Water Temp Time (24 hr)
35 | Discharge
36 | Discharge Units |  | (CFS, CMS)
37 | [NAME] or Est |  | (Measured or Estimate)
38 | USGS Gage number |  | (write USGS station name or number here if applicable)
39 | [NAME] (24 hr)
40 | Fish length Unit |  | ([NAME], cm, in)
41 | Fish Weight Unit |  | (g, kg, lbs)
42 | Fish length measure technique |  | (Total , Fork, Standard, Eye-Fork)
Spreadsheet: 96325d1295726085-averaging-calculation-for-excel-2003-can-i-combine-sick-days-to-worksheet-2011-tech-summary
Sheet: Outlet Techs

 |  |  | OUTLET TECHNICIANS
3897 | [NAME] | Garvey
10538 | Hector | Mendez
449397 | [NAME] | [NAME]
706481 | [NAME] | Valle
801597 | Scott | Holland
897124 | [NAME] | Ciran
897884 | Badreddine | Yabi
Spreadsheet: 0865f231-2215-48be-89f4-dbf8c57d0df7
Sheet: Sheet1

2008-09-09 00:00:00 | UNITED STATES SENATOR - DEMOCRATIC | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Belknap County | Shaheen, d | Stebbins, d | Alciere, r | [NAME], r | [NAME]
Alton | 93 | 12 |  |  | 1
Barnstead | 137 | 17 |  |  | 1
Belmont | 102 | 15 |  | 1 | 1
Center Harbor | 15 | 2
Gilford | 188 | 16 |  | 2 | 2
Gilmanton | 79 | 8
[NAME] | 73 | 10 |  | 2 | 1
[NAME] | 93 | 8 |  | 1
[NAME] 3 | 78 | 8 |  | 1
[NAME] | 48 | 6 |  | 1
[NAME] | 60 | 9
[NAME] 6 | 64 | 9
Meredith | 154 | 15 |  | 2 | 2
New Hampton | 70 | 9 |  | 2
Sanbornton | 164 | 16 |  | 2
[NAME] | 151 | 20
TOTALS | 1569 | 180 |  | 14 | 8
Carroll County | Shaheen, d | Stebbins, d | Alciere, r | [NAME], r | [NAME]
Albany | 45 | 2
[NAME] | 116 | 5
[NAME] | 45 | 3 |  |  | 2
Chatham | 16
Conway | 275 | 21 |  |  | 1
Eaton | 26 | 1
[NAME] | 86 | 8 |  |  | 1
Freedom | 84 | 3
Hale's Location | 3
Hart's Location | 7
[NAME] | 80 | 5
[NAME] | 100 | 9
Moultonborough | 104 | 21
Ossipee | 137 | 27 |  | 1
Sandwich | 143 | 7
Tamworth | 178 | 18 |  |  | 2
Tuftonboro | 97 | 16 |  | 2 | 1
Wakefield | 137 | 16 |  | 1
Wolfeboro | 315 | 20
TOTALS | 1994 | 182 |  |  | 7
Spreadsheet: 865546d1712619055-help-with-index-match-mpp-ask
Sheet: Sheet1

NAMA SALES | AREA | 2024-04-01 00:00:00 | 2024-04-02 00:00:00 | 2024-04-03 00:00:00 | 2024-04-04 00:00:00 | 2024-04-05 00:00:00 | 2024-04-06 00:00:00 | 2024-04-07 00:00:00 | 2024-04-08 00:00:00 | 2024-04-09 00:00:00 | 2024-04-10 00:00:00
SALES 1 | SIDAORJO | 1 | 1 | 1 | 1 | 1 | 1 | OFF | OFF | 1 | L
SALES 2 | SURABAYA | L | TSD | 1 | 1 | 1 | 1 | OFF | OFF | L | L
SALES 3 | SIDOARJO | TSD | 1 | 1 | 1 | TSD | 1 | 1 | OFF | L | 1
SALES 4 | SIDOARJO | 1 | 1 | 1 | 1 | 1 | 1 | OFF | 1 | 1 | 1
SALES 5 | SURABAYA | 1 | 1 | 1 | 1 | L | L | 1 | 1 | 1 | 1
SALES 6 | SURABAYA | 1 | L | 1 | L | L | L | OFF | OFF | 1 | 1
SALES 7 | SIDOARJO | 1 | 1 | TSD | 1 | 1 | 1 | OFF | OFF | 1 | 1
SALES 8 | SURABAYA | TSD | 1 | 1 | 1 | L | L | OFF | OFF | 1 | 1
DATE | 2024-04-01 00:00:00
AREA | SURABAYA
1 | 2
L | 1
TSD | 1
OFF | 0
Spreadsheet: 599117d1542866061-closest-date-index-match-indexmatch
Sheet: Sheet1

Time | Wafer type | Surface | Average | Date |  |  | Wafer type | Surface | Average
100 | STD CAP | P/P | 80 | 2018-10-12 00:00:00 |  |  | STD CAP | P/P | 50
234 | STD CAP | P/P | 51.67 | 2018-10-11 00:00:00
234 | Hi-K | P/P | 52.47 | 2018-09-10 00:00:00 |  |  |  |  |  |  |  | Output is Time
234 | Hi-K | P/P | 53.37333333333333 | 2018-09-11 00:00:00
276 | STD CAP | P/P | 44.01000000000001 | 2018-09-12 00:00:00
276 | STD CAP | P/P | 43.75333333333333 | 2018-09-13 00:00:00 |  | formula=>
372 | CUS Chip Resistor | AS | 40.39000000000001 | 2018-09-14 00:00:00
372 | CUS Chip Resistor | AS | 36.60666666666666 | 2018-09-15 00:00:00
270 | CUS Chip Resistor | AS | 56.88 | 2018-09-16 00:00:00
450 | Hi-K | AS/AS | 36.0966666666667 | 2018-09-17 00:00:00 |  | Condition:
324 | CUS CAP | P/L | 37.63999999999999 | 2018-09-18 00:00:00
245 | STD CAP | P/P | 50.75333333333333 | 2018-09-19 00:00:00 |  | Find a value of time that is satisfied the condition:
246 | STD CAP | P/P | 56 | 2018-08-01 00:00:00 |  | B2:B23=H2
300 | STD CAP | P/L | 38.68 | 2018-08-02 00:00:00 |  | C2:C23=I2
228 | STD CAP | P/P | 54.65333333333334 | 2018-08-03 00:00:00 |  | Date < 30 of today
221 | STD CAP | P/P | 53.15000000000001 | 2018-08-04 00:00:00 |  | Average is D2:D23-J2<=±5
289 | STD CAP | P/P | 40 | 2018-08-05 00:00:00
246 | STD CAP | P/P | 51.6 | 2018-08-06 00:00:00
306 | STD CAP | P/P | 52 | 2018-11-10 00:00:00
303 | STD CAP | P/P | 51 | 2018-11-09 00:00:00
300 | STD CAP | P/L | 39.23 | 2018-08-09 00:00:00
321 | STD CAP | P/L | 39.265 | 2018-08-10 00:00:00
Spreadsheet: 691356d1597659431-trouble-combining-nested-if-and-or-function-excel-query
Sheet: Resource

Resource 1 | Consultant
Resource 2 | Consultant
Resource 3 | Consultant
Resource 4 | Consultant
Resource 5 | Technical Consultant
Resource 6 | Consultant
Resource 7 | Consultant
Resource 8 | Consultant
Resource 9 | Consultant
Resource 10 | Consultant
Resource 11 | Consultant
Resource 12 | Consultant
Resource 13 | Project Manager
Resource 14 | Consultant
Resource 15 | Project Manager
Resource 16 | Project Manager
Resource 17 | Project Manager
Resource 18 | Consultant
Resource 19 | Project Manager
Resource 20 | Developer
Resource 21 | Technical Support
Resource 22 | Project Manager
Spreadsheet: 67511d1268134639-reference-equation-of-trend-line-values-example
Sheet: Data

x | y
0.0002061510184186557 | 55.76135301480588 |  | SLOPE | Gradint, m = | 169340.7920321826
0.0004476571665773251 | 97.93020991287544 |  | INTERCEPT | Intercept, c = | 27.34035616188754
0.0005012869996747583 | 120.6357342824877
0.0007168405773897033 | 136.2309973944655
0.000751459477589662 | 151.1567676626684
0.0008571435874561911 | 164.148944551891
0.0008970536370484345 | 175.8345437005443
0.0009321770958962489 | 185.5736005414271
0.001019509453579072 | 196.6213701652635
0.001058787236919046 | 208.3100287120899
0.001095313505092671 | 222.5948595975464
0.001214322132353341 | 239.496439090594
0.001320639761298128 | 257.0478964069346
0.001377426432495569 | 277.1860731016433
0.001520532843795669 | 296.0537205541173
0.001637641702536723 | 316.8665259466067
0.001832375164761125 | 337.0609731363141
0.002024248485913021 | 359.8605225769037
0.002192706111915958 | 379.4114638567182
LOGEST
Gradint, m = | 169340.7920321826
Spreadsheet: 871864d1718262510-query-pivot-to-transpose-email-address-email-for-365-aligw
Sheet: Sheet1

IDCUST | CUSTOMER NAME | [NAME] |  |  |  | CUSTOMER NAME | [NAME]
UC1001 | Lake View Credit Pte Ltd (UC1001) | [EMAIL] |  |  | UC1001 | Lake View Credit Pte Ltd (UC1001) | [EMAIL] | [EMAIL] | [EMAIL]
UC1001 | Lake View Credit Pte Ltd (UC1001) | [EMAIL] |  |  | UC1002 | [NAME] (UC1002) | [EMAIL]
UC1001 | Lake View Credit Pte Ltd (UC1001) | [EMAIL] |  |  | UC1005 | Island Car Trading Pte Ltd | [EMAIL] | [EMAIL]
UC1002 | [NAME] (UC1002) | [EMAIL]
UC1005 | Island Car Trading Pte Ltd | [EMAIL]
UC1005 | Island Car Trading Pte Ltd | [EMAIL]
Spreadsheet: 89706d1289464450-using-spinner-to-increase-decrease-a-minimum-value-allocation-list
Sheet: Allocation List

 | T-SHIRT ALLOCATION
 | REGION | EZD | TEAM | QUANTITY
 | KL | [NAME] | LAMP
 |  |  | GT
 | JB | WA Distributor | LAMP
 |  |  | GT
 | PG | [NAME] | LAMP
 |  |  | GT
 | BW | Ban Chuan Agency | LAMP
 |  |  | GT
 | PRK | [NAME] JITRA | LAMP
 |  |  | GT
 | IP | [NAME] | LAMP
 |  |  | GT
 | SBN | KTT | LAMP
 |  |  | GT
 | MLK | [NAME] | LAMP
 |  |  | GT
 | KTN | [NAME] | LAMP
 |  |  | GT
Spreadsheet: 1b15a847-50b4-4782-bd43-ad347b5c387e
Sheet: Participant

Installed Capacity Monthly Settlement Report
SR_MTHSTLICAP_<customer_id>_<settlement_date>_<version>.CSV
<customer name>
Date:<mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mi:ss> GMT
Participant Supply |  |  |  |  |  |  |  | [NAME]
Participant Generation | Participant Load Response | Participant ICAP Import Contract | Participant ICAP Credit | Participant ODR | Participant Total Supply | ICAP Transition Rate | Participant ICAP Transition Payment | Participant Average UCAP Peak Contribution Value | Participant UCAP Obligation | Participant Bilateral UCAP Transactions | Participant Adjusted UCAP Obligation | Participant ICAP Transition Charge | Participant Net Transition Settlement for UCAP
UCAP MW | UCAP MW | UCAP MW | UCAP MW | UCAP MW | UCAP MW | $[NAME] | $ | MW | UCAP MW | UCAP MW | UCAP MW | $ | $
Spreadsheet: 701260d1603664270-financial-model-cashflow-help-example-v2
Sheet: Example

 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2022
 | 2021-01-31 00:00:00 | 2021-02-28 00:00:00 | 2021-03-31 00:00:00 | 2021-04-30 00:00:00 | 2021-05-31 00:00:00 | 2021-06-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-31 00:00:00 | 2021-09-30 00:00:00 | 2021-10-31 00:00:00 | 2021-11-30 00:00:00 | 2021-12-31 00:00:00 | 2022-01-31 00:00:00
Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
Repayment plan income | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000
Adjustment for deferred cash flow
Monthly cashflow
 |  |  |  |  |  |  |  |  |  |  |  | Final month of first plan
Spreadsheet: 759165d1639389144-cumulative-inflation-cumulative-inflation-3-
Sheet: CPI

Date |  | Year | [NAME] | jun | sep | dec |  | RaulSerg | Manual | (Average from relevant quarter to end of table)
2009-10-01 00:00:00 |  | 2009 | 2.4 | 1.4 | 1.2 | 2.1
2010-01-01 00:00:00 |  | 2010 | 2.9 | 3.1 | 2.9 | 2.8
2010-04-01 00:00:00 |  | 2011 | 3.3 | 3.5 | 3.4 | 3
2010-07-01 00:00:00 |  | 2012 | 1.6 | 1.2 | 2 | 2.2
2010-10-01 00:00:00 |  | 2013 | 2.5 | 2.4 | 2.2 | 2.7
2011-01-01 00:00:00 |  | 2014 | 2.9 | 3 | 2.3 | 1.7
2011-04-01 00:00:00 |  | 2015 | 1.3 | 1.5 | 1.5 | 1.7
2011-07-01 00:00:00 |  | 2016 | 1.3 | 1 | 1.3 | 1.5
2011-10-01 00:00:00 |  | 2017 | 2.1 | 1.9 | 1.8 | 1.9
2012-01-01 00:00:00 |  | 2018 | 1.9 | 2.1 | 1.9 | 1.8
2012-04-01 00:00:00 |  | 2019 | 1.3 | 1.6 | 1.7 | 1.8
2012-07-01 00:00:00 |  | 2020 | 2.2 | -0.3 | 0.7 | 0.9
2012-10-01 00:00:00 |  | 2021 | 1.1 | 3.8 | 3
2013-01-01 00:00:00
2013-04-01 00:00:00
2013-07-01 00:00:00
2013-10-01 00:00:00
Spreadsheet: 122750d1317130293-date-count-by-month-with-multiple-criteria-multiple-date-ranges
Sheet: Pivot table

Row Labels | Count of Status
2011-01-01 00:00:00 | 8
50 | 2
60 | 2
300 | 4
2011-04-01 00:00:00 | 3
50 | 1
300 | 2
2011-06-01 00:00:00 | 3
50 | 1
60 | 1
300 | 1
2011-01-02 00:00:00 | 1
60 | 1
Grand Total | 15