tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: cooper_richey__4350__Closing 013102 mkt sum final CERS Jan
Sheet: notice

Market Notice
Summary of CDWR (CERS) Settlement for January 2001
GMC Net Billings |  | 2001-01-01 00:00:00
Outstanding 1/31/02 |  | 2830580.72
Collected 1/31/02 |  | -2596323.97
Remaining Unpaid
Market Billings Due From SCs |  | 2001-01-01 00:00:00
Outstanding 1/31/02 |  | 799341314.94
Adjustment for CERS billing |  | -196596656.98
Collected 1/31/02 |  | -155614362.93
Remaining Unpaid
Market Billings Due To SCs |  | 2001-01-01 00:00:00
Outstanding 1/31/02 |  | 823514178.9
Adjustment for CERS billing |  | -196497329.4
Payments |  | -158255358.92
Offsets |  | -1942061.56
Remaining Unpaid
Cash Summary |  | 2001-01-01 00:00:00
GMC collection
Market collection
Interest collected on reserve funds |  | 44672.02
Total Collections
Held in escrows (see below) |  | -21991975.43
Subtotal
Amount Distributed to SCs
Payment Date - Payments to ISO Creditors were made on February 1, 2002
Invoice Number - Payment wires indicate the invoice being paid.
Escrows - One Escrow has been established pending determination of applicability of FERC ruling to SCE TO
and PG&E TO liabilities. Another escrow has been established pending the resolution of the validity
of billings to a specific SC.
Spreadsheet: 144141d1330720734-coping-data-from-one-sheet-to-other-related-sheets-tenderfoot
Sheet: Wayne

 |  |  | TENDERFOOT  LEAGUE
 |  |  |  | WEEKLY RECORD SHEET |  |  |  | TEAM NAME:  SUB
2012 |  |  |  | INDIVIDUAL SCORES
BOWLERS  NAME: |  |  | 13 |  |  |  | [NAME] | 138
Date | Games Bowled | Total Games Bowled | 1st | 2nd | 3rd | Series | TOTAL PIN FALL | Ave. | Hcp | Hi Game Scr | Hi Game Hcp | Hi Series scr | Hi Series Hcp | Singles | Points Contributed
2012-01-31 00:00:00 |  |  | 174 | 127 | 147
2012-02-07 00:00:00 | 3 |  | 174 | 127 | 147
2012-02-14 00:00:00 | 3 |  | 174 | 127 | 147
2012-02-21 00:00:00 | 3 |  | 174 | 127 | 147
2012-02-28 00:00:00 | 3 |  | 174 | 127 | 147
2012-03-06 00:00:00 | 3 |  | 5 | 127 | 147
2012-03-13 00:00:00 | 3 |  | 174 | 127 | 147
2012-03-20 00:00:00 | 3 |  | 174 | 127 | 147
2012-03-27 00:00:00 | 3 |  | 174 | 127 | 147
2012-04-03 00:00:00 | 3 |  | 174 | 127 | 147
2012-04-10 00:00:00 | 3 |  | 174 | 127 | 147
2012-04-17 00:00:00 | 3 |  | 174 | 127 | 147
2012-04-24 00:00:00 | 3 |  | 174 | 127 | 147
2012-05-01 00:00:00 | 3 |  | 174 | 127 | 147
2012-05-08 00:00:00 | 3 |  | 174 | 127 | 147
2012-05-15 00:00:00 | 3 |  | 174 | 127 | 147
2012-05-22 00:00:00 | 3 |  | 174 | 127 | 147
2012-05-29 00:00:00 | 3 |  | 174 | 127 | 147
2012-06-05 00:00:00 | 3 |  | 174 | 127 | 147
2012-06-12 00:00:00 | 3 |  | 174 | 127 | 147
2012-06-19 00:00:00 | 3
2012-06-26 00:00:00 | 3
2012-07-03 00:00:00 | 3
2012-07-10 00:00:00 | 3
2012-07-17 00:00:00 | 3
2012-07-24 00:00:00 | 3
2012-07-31 00:00:00 | 3
2012-08-07 00:00:00 | 3
2012-08-14 00:00:00 | 3
2012-08-21 00:00:00 | 3
2012-08-28 00:00:00 | 3
2012-09-04 00:00:00 | 3
2012-09-11 00:00:00 | 3
2012-09-18 00:00:00 | 3
2012-09-25 00:00:00 | 3
2012-10-02 00:00:00 | 3
2012-10-09 00:00:00 | 3
2012-10-16 00:00:00 | 3
2012-10-23 00:00:00 | 3
2012-10-30 00:00:00 | 3
2012-11-06 00:00:00 | 3
2012-11-13 00:00:00 | 3
Spreadsheet: 70a2feb4-e980-466a-9b6c-12563251d9d8
Sheet: Sheet1

Table S3.  Plant-available soil nutrients in ppm (ug/g) (mean ± [NAME]). | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | Site |  |  | ANOVA
 | Soil depth | [NAME] | Huatulco | Santa Rosa | F | df | P
Ammonium (NH4) | 0-5 cm | 9.8±1.1, N=9 | 9.7±1.2, N=9 | 10.1±1.2, N=10 | 0.03 | 25 | 0.9
 | 15-20 cm | 4.5±0.6, N=8 | 4.2±0.4, N=9 | 5.6±0.7, N=10 | 1.55 | 24 | 0.2
Nitrate (NO3) | 0-5 cm | 7.2±1.6, N=9 | 5.2±1.0, N=9 | 3.7±1.2, N=10 | 1.9 | 25 | 0.2
 | 15-20 cm | 2.5±0.5, N=8 | 2.0±0.2, N=9 | 3.1±1.1, N=10 | 0.47 | 24 | 0.6
Phosphate (PO4) | 0-5 cm | 18.1±4.1, N=9 | 49.9±10.1, N=9 | 5.8±0.8, N=9 | 12.91 | 24 | 0.0002
 | 15-20 cm | 8.9±2.7, N=9 | 43.4±9.6, N=9 | 2.1±0.6, N=10 | 15.83 | 25 | 0.0001
Organic carbon (%) | 0-5 cm | 9.3±0.8, N=9 | 7.8±1.4, N=8 | 14.3±0.5, N=10 | 14.79 | 24 | 0.0001
 | 15-20 cm | 6.1±0.6, N=9 | 4.8±1.2, N=8 | 11.3±0.4, N=10 | 59.62 | 24 | 0.0001
[NAME] is the driest site; Huatulco is the dry site of intermediate latitude; Santa Rosa is the wettest site. Significant ANOVA tests (bold) correspond to greater mean soil nutrients at one site, also in bold, than at the other two sites (Tukey HSD tests, p < 0.05).
Spreadsheet: 145864d1331783460-merging-rows-with-same-values-in-first-columns-but-different-values-in-later-columns-database-mock-up-for-forum
Sheet: Sheet1

fullname | address | pcode | telephone | D2D | Computer | Data entry | Baking | Driver | Lit drops | Event day | Handyman | not specified | office | phone | sign crew | possible
[NAME], [NAME] | 22 1st st | 1A | 123 | X
[NAME], [NAME] | 22 1st st | 1A | 123 |  |  |  |  |  |  |  |  |  | X
[NAME], [NAME] | 22 1st st | 1A | 123 |  |  |  |  |  |  |  |  |  |  |  | X
Jones, [NAME] | 33 4th ave | 2B | 234 |  |  |  |  |  |  | X
Jones, [NAME] | 33 4th ave | 2B | 234 |  |  |  |  |  |  |  |  |  | X
Jones, [NAME] | 55 6th st | 1C | 234 |  |  |  |  |  |  |  |  |  |  |  | X
[NAME], [NAME] | 77 C road | 3D | n/a |  | X
[NAME], [NAME] | 77 C road | 3D | n/a |  |  |  |  |  |  |  | X
[NAME], [NAME] | 77 C road | 3D | n/a |  |  |  |  |  |  |  |  |  | X
[NAME], [NAME] | 8 2nd st | 4E | 456 |  |  |  | X
Hawkes, [NAME] | 999 23 ave | 3A | 345 | X
Hawkes, [NAME] | 999 23 ave | 3A | 345 |  |  |  |  |  | X
Hawkes, [NAME] | 999 23 ave | 3A | 345 |  |  |  |  |  |  |  |  |  | X
Cox, [NAME] | 123 CDE blvd | 4B | 567 |  |  |  |  |  |  |  |  | X
[NAME], [NAME] | 435 78 st | 5F | 678 |  |  | X
[NAME], [NAME] | 435 78 st | 5F | 678 |  |  |  |  |  |  | X
Ford, [NAME] | 876 34 ave | 6E | 789 |  |  | X
Ford, [NAME] | 876 34 ave | 6E | 789 | X
Ford, [NAME] | 876 34 ave | 6E | 789 |  |  |  |  | X
Ford, [NAME] | 876 34 ave | 6E | 789 |  |  |  |  |  |  |  |  |  |  |  | X
Spreadsheet: 818381d1676789676-automatically-copy-multiple-sheets-into-one-sheet-s666-pq-automatically-copy-multiple-sheets-into-one-sheet
Sheet: Team 2

Department | Sub Dept | Area Owner | Supervisor | Reportees | Month | Completion Date | Completion Status
Department 2 | Sub 2 | Area Owner 2 | Supervisor 3 | Reportee 13 | 2023-02-01 00:00:00 | 2023-02-01 00:00:00
Department 2 | Sub 2 | Area Owner 2 | Supervisor 3 | Reportee 14 | 2023-02-01 00:00:00
Department 2 | Sub 2 | Area Owner 2 | Supervisor 3 | Reportee 15 | 2023-02-01 00:00:00 | 2023-02-20 00:00:00
Department 2 | Sub 2 | Area Owner 2 | Supervisor 3 | Reportee 16 | 2023-02-01 00:00:00 | 2023-02-12 00:00:00
Department 2 | Sub 2 | Area Owner 2 | Supervisor 3 | Reportee 17 | 2023-02-01 00:00:00 | 2023-02-12 00:00:00
Department 2 | Sub 2 | Area Owner 2 | Supervisor 3 | Reportee 18 | 2023-02-01 00:00:00
Department 2 | Sub 2 | Area Owner 2 | [NAME] | Reportee 19 | 2023-02-01 00:00:00 | 2023-02-18 00:00:00
Department 2 | Sub 2 | Area Owner 2 | [NAME] | Reportee 20 | 2023-02-01 00:00:00 | 2023-02-11 00:00:00
Department 2 | Sub 2 | Area Owner 2 | [NAME] | Reportee 21 | 2023-02-01 00:00:00 | 2023-02-18 00:00:00
Department 2 | Sub 2 | Area Owner 2 | [NAME] | Reportee 22 | 2023-02-01 00:00:00 | 2023-02-02 00:00:00
Department 2 | Sub 2 | Area Owner 2 | [NAME] | Reportee 23 | 2023-02-01 00:00:00 | 2023-02-05 00:00:00
Department 2 | Sub 2 | Area Owner 2 | [NAME] | Reportee 24 | 2023-02-01 00:00:00 | 2023-02-18 00:00:00
Department 2 | Sub 2 | Area Owner 2 | [NAME] | Reportee 25 | 2023-02-01 00:00:00 | 2023-02-02 00:00:00
Department 2 | Sub 2 | Area Owner 2 | [NAME] | Reportee 26 | 2023-02-01 00:00:00
Spreadsheet: 816172d1675416993-formula-to-fill-series-of-weekdays-from-a-starting-date-fill-weekdays-without-weekend
Sheet: Sheet1

 | Start | 2023-08-14 00:00:00 | End | 2023-10-31 00:00:00 | Period
Spreadsheet: 139515d1328281188-vlookup-with-output-of-many-columns-i-think-sample-for-excel-forum
Sheet: Master w many ADD per HYP Code

System | Customer # | [NAME] |  | Customer Name | Address | Country
 |  | (Many entries per code, with diff addresses)
SYSTEM 1 | CUST1 | HYP1 |  | [NAME] | xxx | USA
SYSTEM 1 | CUST1X | HYP1 |  | [NAME] | YYY | DE
SYSTEM 1 | CUST1Y | HYP1 |  | [NAME] | ZZZ | IND
SYSTEM 2 | CUST2 | HYP2 |  | [NAME] | xxy | USA
SYSTEM 2 | CUST2X | HYP2 |  | [NAME] | xxy2 | DE
SYSTem 3 | CUST3 | HYP3 |  | Dirk | xxy
Spreadsheet: 797679d1664041761-summing-overlapped-time-intervals-intervals
Sheet: Sheet1

Product | Machine | [NAME] start | ProductRunning End | Downtime |  |  | Machine | Machine Downtime start | MachineDowntime end
A | m/c1 | 10:00:00 | 14:00:00 | 65 min |  |  | m/c1 | 09:30:00 | 09:45:00
b | m/c2 | 09:00:00 | 15:00:00 | 25 min |  |  | m/c2 | 08:00:00 | 08:30:00
c | m/c1 | 15:00:00 | 16:00:00 | 30 min |  |  | m/c1 | 09:55:00 | 10:05:00
 |  |  |  |  |  |  | m/c1 | 13:00:00 | 14:15:00
 |  |  |  |  |  |  | m/c1 | 14:30:00 | 15:30:00
 |  |  |  |  |  |  | m/c2 | 08:55:00 | 09:25:00
 |  |  |  |  |  |  | m/c1 | 16:00:00 | 17:00:00
 |  |  |  |  |  |  | m/c2 | 16:00:00 | 17:00:00
Spreadsheet: 0d71727f-fed2-4b90-9bf0-dfa305c1c3b4
Sheet: CONVERSATION

[NAME]
NO | NAMA
1 | [NAME]
2 | Agnes Candra
3 | [NAME]
4 | [NAME] Junica Areros
5 | Luciana
6 | [NAME]
7 | [NAME]
8 | Priska Muliany
9 | Ritawaty
10 | [NAME]
Spreadsheet: 876296d1722974168-attendance-tracking-with-occurrence-points-over-6-month-rolling-period-attendance-tracker
Sheet: November

 | 2024-11-01 00:00:00
 |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  | Weekends
 | V | S | U | N | T | L
Employee | Vacation | Sick | Unexcused | NC-NS | Tardy | Late Return | Total Points
Spreadsheet: 170268d1343224379-auto-updating-info-in-multiple-spreadsheets-from-one-spreadsheet-mochmillsamples
Sheet: Sheet5

[NAME]
100
TK | MILL | PRODUCT | 325 | YBR | 0.5 | 12 MIC |  |  |  |  |  |  |  |  |  |  |  |  |  | In Spec for product
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300
13 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200
97 | 3 |  | 13 |  |  | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
96 | 4 | 200 | 15 |  |  | 16
92 | 5
13 | 6 | 300
61 | 12 | 200 | 17 |  |  | 18
TK | MILL | PRODUCT | MPS | 10MIC/TS | YBR | HEG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OUT!!
 | 2
42 | 3 | 3
 | 3
42 | 4 | 3
 | 4 | 4
 | 5
 | 6
 | 10
 | 11
 | 12
TK | MILL | PRODUCT | MPS | TS | LOI | AGG | FIZZ | MASSLOSS
17 | 8
TK | MILL | PRODUCT | 200 MESH | TIME
 | 5 | 70
Transfer Tanks
U3 |  |  | U2
40-> | 94 |  | 00-> | 8
42-> | 94 |  | 08-> | 61 or will feed mill 10
80-> | 91, 93 |  | 14-> | feed mill 11 only
 |  |  | 17-> | 16, 61
 |  |  | 22-> | 61
 |  |  | 24-> | 19
Spreadsheet: errol_mclaughlin_jr__10870__Missing books in Test
Sheet: Books with Positions

BOOK_ID | SUM(DELTA_POSITION) | SUM(BENCHMARK_POSITION_QTY) | Next Level Down
CCO-ENPOWER-PRC | 25.52037276564 | 25.52037276564 | GLB-MKTS - insurance | Christy | If return = 0, then the book is flat but may still have credit exposure
DBL-XL-TRIGGER-PRC | -33886.58848164322 | -33886.58848164322 | AMERICAS - insurance | Christy
EPMI-HRLY-NY-PRC | 11985.27568710799 | 11985.27568710799 | AMERICAS | Christy | Books with Positions in AGG-PROD-DPR-BU & not in AGG-TEST-BU
EPMI-LT-WHALW-PRC | 0 | 0 | AMERICAS | Christy
EPMI-WS-RN-INV-PRC | 0 | 0 | AMERICAS | Christy
FT-US/CAND-ERMS-GDL | 0 | 0 | AMERICAS | Christy
GAS-ECT-STRATEG-PRC | -0.0001 | -0.0001 | AMERICAS | Christy
GAS-ENERGYAMER-PRC | 0 | 0 | AMERICAS | Christy
INTRA-ARG-PHY | -4618.1231 | -4618.1231 | S America | Christy
OIL-NG-HDG-CD-X-GDL | 0 | 0 | Americas | Gas
PAPER-AFF-BAS | -279442.7176 | -126750.248184 | accrual | KC
PAPER-AFF-PRC | -57053.391 | -9245.616184 | accrual | KC
PAPER-CAND-NWSP-PRC | 0 | 0 | add to AGG-TEST | KC
PWR-NG-HEDGE-PRC | 0 | 0 | AMERICAS | Christy
Spreadsheet: 122014d1316551995-indirect-erep_1gb-tigrovi_bkp
Sheet: Z N Gorki

Ambient on/off
eRepublik – Online Strategy Game
Sep20 Day 1,400 of the New World
Home
My Land
Wars
Market
Marketplace
Job market
Monetary market
Companies for sale
Community
World Map
News
My Party
Elections
Military Unit
Country administration
Invite friends
Badges
Get Gold & Extras
[NAME]
[NAME]
27
60
Eat food
Gold2.24 Gold
BAM411 BAM
HRK1625 HRK
Missions
X
You don't have enough Gold to complete the task Get Gold
Completed!
2011-10-03 00:00:00
2011-10-03 00:00:00
2011-10-03 00:00:00
Reward
Ok
Congratulations, your rank is now
Rank Bonus on attack +5%
Energy bar
Ok
Strength
Experience points
Health
Rank points
Gold
Energy bar
[NAME]
Free Lands
Scope
Bazooka
Weapons
Weapons
Weapons
Food units
Food units
Food units
Grain Farms
0 0
Logout
Experience level: 27
Experience points: 10027
Next level at: 15000
• Working, training and fighting decreases health
[NAME], health boxes, food, hospitals restore health.
This action restores as much health as possible by eating Food from your Storage.
You can recover up to: 450 / 450 Health
100 more recoverable Health in: 00:59:59
Food limit reached
You have reached your food consumption limit.
You can recover 100 health every hour.
100 more recoverable Health in: [NAME]
Buy health kit Close
Z N Gorki
offlineZ N Gorki
Add as a friend Send message Donate
Experience level 30
29,659 / 30,000
Location: PolandPoland, Baden-Wurttemberg Citizenship: ChinaChina
eRepublik birthday
[NAME]
National rank: 175
Party Member
Saturn CommunitySaturn Community Far-left Wing
Member
HV 1.GB Tigrovi HV 1.GB Tigrovi
Press director
thinking about the name
Friends(411)
BeDva
broc
ZYX1
Borna Sentic
Plese [NAME]
Asklepije
[NAME]
butro
keineahnung
view all
Land of Z N Gorki: 44 buildings
Visit
Achievements
hard worker
13
Hard Worker
Worked 30 days in a row
congressman
1
Congress Member
Won the Congress elections
president
Country President
Win the Presidential elections
media mogul
Media Mogul
Reach 1000 subscribers to your newspaper
battle hero
3
Battle Hero
Reach the highest war influence in a battle
campaign hero
Campaign hero
Reach the highest war influence in a campaign
resistance hero
2
Resistance Hero
Started a resistance war and liberated 2 regions.
super soldier
25
Super Soldier
Advance 250 strength points
society builder
1
Society Builder
Invited 10 people to eRepublik and helped them reach level 10
mercenary
Mercenary
Defeat 25 enemies for 50 different countries
Coming soon
Coming soon
Military Skills
Strength
6,287.91
Super soldier:6,287 / 6,500
Rank
Supreme Marshal ***Supreme Marshal ***
Rank points:
4,704,659 / 4,900,000
Forum   |   [NAME]   |   Blog   |   Press   |   Contact   |   [NAME]   |   Terms of Service   |   Privacy  |   Affiliates  |   [NAME]
Follow us: FacebookFacebook TwitterTwitter
Copyright © 2007-2011 eRepublik
Spreadsheet: michelle_lokay__26699__imball0112
Sheet: Dominion

 | Dominion Gas Ventures
 | POI 12354 - Dominion Gas/Tule Lake
Day | Measured | Scheduled
1 | 115 | 240
2 | 58 | 240
3 | 44 | 240
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
2001-11-30 00:00:00 |  |  | 173809
2001-12-03 00:00:00
CBS Volume
 |  |  | 76218
Spreadsheet: 797348d1663839524-max-date-based-on-conditions-max-date-test
Sheet: Sheet1

ITEM | DATE | STATUS | OUTCOME
HF00030 | 2022-07-31 09:37:42 |  | NO
HF00030 | 2018-09-26 17:24:40 | Published | NO
HF00030 | 2021-03-24 11:10:49 | Published | NO
HF00030 | 2021-11-12 10:29:57 |  | NO
HF00030 | 2022-07-31 09:41:41 |  | NO
HF00030 | 2020-08-19 10:00:54 | Published | NO
HF00030 | 2021-12-10 17:41:44 | Published | YES
HF00030 | 2021-12-10 17:41:28 | Not Published | NO
Spreadsheet: geir_solberg__11281__11-17act
Sheet: Fuel

SAN JUAN |  |  |  | WAHA
Interstate Spot Price |  | 1.455 |  | Intrastate Spot Price |  | 1.515
Interstate Fixed Price (RG) |  |  |  | Intrastate Fixed Price
Interstate Fixed Price (NM)
Units Using Interstate Gas Prices |  |  |  |  | Weighted | Cost of
 |  | % Fixed | % Spot | MMBtus | Avg. Price | Gas Burn
 | Rio Grande 8 | 1 | 0
 | Rio Grande 7 | 1 | 0
 | Rio Grande 6 | 1 | 0
 | Total
Units Using Intrastate Gas Prices
 | Copper | 1 | 0
 |  |  |  |  |  |  |  | Interstate Cheaper than Intrastate? yes = 1, no = -
Units Using Either Interstate or Intrastate Gas Prices |  |  |  |  |  |  |  | Fixed | Spot
 | Newman 4 | 1 | 0
 | GT1+ST1 | 1 | 0
 | GT2+ST1 | 1 | 0
 | Newman 3 | 1 | 0
 | Newman 2 | 1 | 0
 | Newman 1 | 1 | 0
 | GT 1 | 1 | 0
 | GT 2 | 1 | 0
 | Total
ANALYSIS OF CURRENT MONTH WEIGHTED AVERAGE PRICES
February
INTERSTATE
Supplier |  | Base Price |  | Volume |  | Rio Grande | Newman |  | Total Dollars Rio Grande | Total Dollars Newman
USGT | SJ Inside FERC FOM | 2.09 |  | 15000 |  | 0 | 15000
Duke | 1/1-12/31/98 price not given (SJ) | 2.09 |  | 10000 |  | 10000 | 0
[NAME] | 4/1-11/30/98 Fixed or FOM Float (SJ) | 2.09 |  | 15050 |  | 15050 | 0
PNM | 4/1-11/30/98 Fixed or FOM Float (SJ) | 2.09 |  | 10000 |  | 10000 | 0
KN | 1/1/97-12/31/01 NGI Bid Week Index ([NAME]) | 1.96 |  | 56100 |  | 0 | 56100
Spot Purchases | ? |  |  | 0 |  | 0 | 0
 |  |  |  |  |  |  |  | W.A. Base Price
 |  |  |  |  |  |  | [NAME] |  | 0.05 | 0
 |  |  |  |  |  |  | Fuel Charge |  | 0.022 | 0.022
 |  |  |  |  |  |  | Surcharges |  | 0.0134 | 0.0134
 |  |  |  |  |  |  | Variable Price |  | 2.09 | 1.96
INTRASTATE
KN Marketing |  | W.A. Base Price |  | 2.1
 |  | [NAME] |  | 0.025
 |  | Variable Price
Spreadsheet: jane_tholt__13107__EOL_Product_Listen
Sheet: Sheet1

Socal Price | Key Price | Key Flow | SJ Flow | SJ Price | Act SJ Price | Key Prof | SJ Prof | Difference | Volume | Opp Cost
4.05 | 3.5 | 0.95 | 0.75 |  | 2.25 |  |  |  | 50000
Spreadsheet: 64051d1264908048-excel-2007-formula-for-multiple-criteria-excel-test
Sheet: Data

A | H | G | F | E |  | 1
B | A | H | G | F |  | 2
C | B | A | H | G |  | 3
D | C | B | A | H |  | 4
E | D | C | B | A |  | 5
F | E | D | C | B |  | 6
G | F | E | D | C |  | 7
H | G | F | E | D |  | 8
 | I am getting a Value error
Spreadsheet: 132889d1324001492-need-to-get-unique-values-from-range-with-some-criteria-advancedfilterexample
Sheet: Data Feed

Store | Product |  | Store | Product |  | Store | Product | << Answer using Unique Advanced Filter
1 | XYZ |  |  | XYZ |  | 1 | XYZ
1 | XYZ |  |  |  |  | 3 | XYZ
1 | XYZ |  | [NAME] Above |  |  | 4 | XYZ
2 | LLL
3 | XYZ
4 | XYZ
4 | XYZ
5 | MMM
5 | MMM
Spreadsheet: 766775d1644051716-working-formula-correction-form-correct
Sheet: Sheet1

 | GDN | BANDAGE
 | GDN | AGNAMED
 | GDN | MANAGED
 | GDN | AGENDAS
 | GDN | ADAWING
 | GDN | GONADAL
 | GDN | BEADING
 | GDN | BONDAGE
 | GDN | DOGBANE
 | GDN | ABIDING
 | GDN | ABODING
 | GDN | DAUBING
 | GDN | ENCAGED
 | GDN | INCAGED
 | GDN | CONGAED
 | GDN | DECAGON
 | GDN | UNCAGED
 | GDN | GONADIC
 | GDN | DEADING
 | GDN | DADOING
 | GDN | DAUDING
 | GDN | ENGAGED
Spreadsheet: 33072d1229355790-systems-dynamics-and-excel-rev3
Sheet: Model

Forecast Demand | Backlog | Total Demand | Gap | Available Stock | LEFT OVER | Production required | Special Buy In | Gap 2 | Reorder Quantity | Reorder stock | Raw material stock
FD | B | TD | G | AS |  | P | SBI | G2 | RQ | RS | RMS
33 |  |  |  | 40
32
16
49
20
50
33
22
18
21
13
38
48
40
20
41
23
10
16
39
37
47
43
11
15
27
38
44
43
43
30
24
28
22
13
47
15
40
23
44
16
13
36
34
20
12
19
42
20
47
29
45
20
46
47
41
16
20
29
34
30
30
49
26
21
22
12
23
35
19
43
15
36
34
14
37
46
16
29
23
14
14
29
45
42
21
42
27
48
32
37
50
29
37
17
43
31
29
21
50
19
14
20
14
33
50
49
25
25
41
18
10
47
15
31
20
35
31
28
28
13
36
44
13
49
10
22
16
27
17
41
28
50
16
44
39
15
36
39
45
38
36
34
19
24
23
42
34
13
15
11
14
33
26
49
32
44
46
49
20
47
32
20
41
10
28
23
41
34
27
50
31
11
48
25
47
47
49
42
34
27
47
47
37
17
21
13
10
33
49
30
50
40
44
32
48 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 780053d1652273116-filter-a-table-based-on-a-linked-searches-1
Sheet: Master Data

[NAME] | 98001
Sl. No. | User Name | Zip Code
1 | [NAME] | 98001
2 | [NAME] | 98002
3 | Hanna | 98010
4 | [NAME] | 98104
5 | [NAME] | 98023
6 | [NAME] | 98005
7 | [NAME] | 98054
8 | Ford | 98004
9 | Kindley | 98011
Spreadsheet: 882760d1731226489-ytm-and-accrued-interest-of-bonds-ytm-and-accrued-interest-of-bonds-jt-
Sheet: JT x

Name | FV | Buy (Dirty) Price | Buy Date | Issue Date | Maturity Date | Freq Interest Payment/year | Coupon Rate % | Accrued Interest | Clean Price | YTM | Next Interest Payment Date | Last Interest Payment Date | Accrued Interest | Buy Price using yield per YIELD function |  | Workings to calculate Next Payment Date: | Months from Issue Date to Buy Date | Roundup | If Months from Issue Date to Buy Date = Roundup, +1 | Next Payment Date | Combined Formula
AAA | 1000 | 1067 | 2024-11-08 00:00:00 | 2012-01-25 00:00:00 | 2027-01-25 00:00:00 | 1 | 8.3 |  | C2-I2
ZZZ | 100 | 105 | 2024-11-08 00:00:00 | 2012-01-08 00:00:00 | 2030-01-08 00:00:00 | 2 | 7 |  | [NAME]
 | 100 |  |  |  |  |  |  |  | [NAME]
 | 100 |  |  |  |  |  |  |  | [NAME]
 | 100 |  |  |  |  |  |  |  | [NAME]
 | 100 |  |  |  |  |  |  |  | [NAME]
 |  | You can use the ACCRINT function to calculate the accrued interest, but first you need to find out the next interest payment date.
 |  | There is also an inbuilt function to calculate YTM: YIELD. But that function is not giving you your expected result.
 |  | YTM calculation using XIRR |  |  |  |  | YTM calculation using XIRR
 |  |  |  |  | Yield using XIRR |  |  |  |  | Yield using XIRR
Spreadsheet: 8473d25b-14bf-48ca-98fa-cb445d57fdd7
Sheet: Sheet1

Number of Telephone Incoming and Outgoing Volume between the Straits | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Unit：Call, Minute
Year and Month |  | Incoming |  | Outgoing
 |  | Calls | Minutes | Calls | Minutes
1996 |  | 42956178 | 115162620 | 53541006 | 168739603
 | 1997 | 56652934 | 151719608 | 69077688 | 198068887
 | 1998 | 69203243 | 180643371 | 79951814 | 236140690
 | 1999 | 82295197 | 214145259 | 96033222 | 286033653
 | 2000 | 95048691 | 241113377 | 111604019 | 342987929
 | 2001 | 114970716 | 321953043 | 154668202 | 509835107
 | 2002 | 169332270 | 473223614 | 213866226 | 758784078
 | 2003 | 185782187 | 523941755 | 250073756 | 987261966
 | 2004 | 228595500 | 645109422 | 289035219 | 1286702911
 | 2005 | 298044463 | 790814715 | 318610184 | 1369443937
 | 2006 | 358902498 | 875980140 | 350297538 | 1505975668
 | 2007 | 282248004 | 784836551 | 352274657 | 1566245351
 | Feb. | 14374207 | 49381159 | 28138474 | 122762173
 | Mar. | 24481847 | 66425311 | 26340948 | 123409680
 | Apr. | 24984851 | 63154851 | 30798212 | 131079848
 | May | 26543068 | 70062373 | 28826299 | 127845592
 | June | 28966728 | 60728526 | 28672083 | 127713120
 | July | 25767059 | 69980752 | 28948103 | 130732867
 | Aug. | 25295778 | 67031112 | 30005911 | 130634891
 | Sept. | 22585673 | 67269799 | 29783633 | 131409831
 | Oct. | 19901578 | 69383683 | 29267084 | 130927432
 | 2008 | 234701523 | 714055458.3166666 | 371859974 | 1538542237
 | 2009 | 221953162 | 576594289 | 369005987 | 1423249660
 | 2010 | 204625817.6 | 552919921.2508 | 403616104 | 1496326500
May |  | 17705010 | 50205238 | 32522827 | 117093134
June |  | 15843131 | 44016822 | 31737709 | 121148750
July |  | 14905529 | 43656633 | 33434952 | 124679013
Aug. |  | 15002202 | 41693823 | 34329028 | 129234155
Sept. |  | 13214087 | 40832155 | 33801269 | 127855829
Oct. |  | 16442257 | 46713177 | 36007214 | 131997189
Nov. |  | 18716344 | 50587938 | 39386969 | 135354276
Dec. |  | 15729036 | 45295533 | 35225293 | 132077786
 | 2011 | 73343007 | 201915214 | 173049518 | 622256104
Jan. |  | 12732731 | 45691998 | 36216519 | 136973569
Feb. |  | 10158961 | 40340544 | 28024255 | 119026902
Mar. |  | 18302610 | 40077694 | 31233834 | 119700757
Apr. |  | 17133632 | 38332731 | 41910319 | 132373524
May |  | 15015073 | 37472247 | 35664591 | 114181352
VS. Last Month |  | -12.36491480615435 | -2.244775608370959 | -14.90260191052232 | -13.74305937492455
VS. Same Month Last Year |  | -15.19308376555563 | -25.36187678265762 | 9.660181139849866 | -2.486723090014825
Accumulate Jan. to Date |  | -22.61210706673845 | -15.91205005337769 | 8.363417285105916 | 4.760534985599554
Source:National Communication Commission.