tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 28002d1221762146-vlookup-extract-all-row-data-from-master-for-the-clients-listed-in-newsheet-master
Sheet: data

Year | FY | FQ | Month | Week | Week # | Score | Status | Code | Company Name | Case Number | Topic | Reason | Close Date | Return Date | Associate | Manager | Comments
2007 | FY08 | Q1 | 7 (Jul) | 2007-07-01 00:00:00 | 27 | 0 | Resolved | 2NF-0040 | Alpha | CA680228 | Miscellaneous | Other | 2007-06-29 00:00:00 | 2007-07-02 00:00:00 | Rep 1 | Manager 1
2007 | FY08 | Q1 | 7 (Jul) | 2007-07-01 00:00:00 | 27 | 0.33 | Resolved | B4F-0069 | Beta | CA675317 | Leave Plans | Other | 2007-06-29 00:00:00 | 2007-07-02 00:00:00 | Rep 2 | Manager 2
2007 | FY08 | Q1 | 7 (Jul) | 2007-07-01 00:00:00 | 27 | 1 | Positive | TJ9-0010 | [NAME] | CA679678 | Benefit Plans | Other | 2007-06-28 00:00:00 | 2007-07-02 00:00:00 | Rep 3 | Manager 4
2007 | FY08 | Q1 | 7 (Jul) | 2007-07-01 00:00:00 | 27 | 1 | Positive | BRT-0032 | Alpha | CA676206 | HR Import | Create Template | 2007-06-20 00:00:00 | 2007-07-02 00:00:00 | Rep 4 | Manager 1
2007 | FY08 | Q1 | 7 (Jul) | 2007-07-01 00:00:00 | 27 | 1 | Positive | L2D-0070 | Delta | CA676412 | Query | Criteria | 2007-06-20 00:00:00 | 2007-07-02 00:00:00 | Rep 5 | Manager 3
2007 | FY08 | Q1 | 7 (Jul) | 2007-07-01 00:00:00 | 27 | 1 | Resolved | YLP-0062 | Echo | CA680452 | Benefits | Other | 2007-06-29 00:00:00 | 2007-07-02 00:00:00 | Rep 5 | Manager 3
2007 | FY08 | Q1 | 7 (Jul) | 2007-07-01 00:00:00 | 27 | 1 | Positive | 3PN-0060 | Beta | CA680260 | Query | Design | 2007-06-29 00:00:00 | 2007-07-02 00:00:00 | Rep 5 | Manager 3
2007 | FY08 | Q1 | 7 (Jul) | 2007-07-01 00:00:00 | 27 | 1 | Positive | Q38-0052 | Beta | CA680007 | Person | Other | 2007-06-29 00:00:00 | 2007-07-02 00:00:00 | Rep 6 | Manager 1
2007 | FY08 | Q1 | 7 (Jul) | 2007-07-01 00:00:00 | 27 | 1 | Positive | 3ZD-0010 | Echo | CA680414 | PR Connection | Data Not Flowing | 2007-06-29 00:00:00 | 2007-07-02 00:00:00 | Rep 7 | Manager 4
Spreadsheet: 871066d1717508822-formulas-for-points-sytem-to-predict-baby-details-baby-game
Sheet: Sheet1

 | Gender | DOB | Weight | Weight in KG | Time of birth |  | Points
C | girl | 2024-12-01 00:00:00 | 8 | 3.62873896 | 04:00:00
co | boy | 2024-12-03 00:00:00 | 7.8 | 3.401942775 | 06:15:00
L | girl | 2024-11-19 00:00:00 | 7.12 | 3.5153408675 | 09:30:00
D | boy | 2024-12-01 00:00:00 | 8.2 | 3.6854380063 | 20:45:00
J | girl | 2024-11-27 00:00:00 | 8.2 | 3.6854380063 | 10:35:00
N | boy | 2024-11-28 00:00:00 | 8.7 | 3.8271856219 | 03:45:00
P | girl | 2024-11-27 00:00:00 | 7.7 | 3.3735932519 | 16:30:00
M | girl | 2024-11-25 00:00:00 | 7.11 | 3.4869913444 | 07:00:00
Mo | girl | 2024-11-22 00:00:00 | 8.7 | 3.8271856219 | 12:00:00
B | girl | 2024-11-27 00:00:00 | 9.8 | 4.309127515 | 14:00:00
Pt
A
H | girl | 2024-11-20 00:00:00 | 8 | 3.62873896 | 05:00:00
 | The Rules
GENDER | 2 POINTS
DOB | 3 POINTS FOR CORRECT DATE, 1 POINT FOR DATE EITHER SIDE
WEIGHT | 3 POINTS
TIME OF BIRTH | 5 POINTS WITHIN 30MINS OF CORRECT TIME 4 POINTS WITHIN 1 HOUR OF CORRECT TIME 3 POINTS WITHIN 2 HOURS OF CORRECT TIME
Spreadsheet: ec625bc8-c81c-41c8-be0d-afd3c2bac443
Sheet: 해삼,훈제연어,오이미조레아에

STANDARD RECIPECARD
메뉴명 : 해삼,훈제연어,오이 미조레아에
재        료 | 식재료 | 수량 | 비고 | 식재료 | 수량 | 비고
 | 해삼 | 15 | 마리(중)
 | 훈제연어 | 1.5 | [NAME]
 | 무우 | 6 | 개
 | 오이
 | 환만식초 | 2 | 통
 | 가쓰오부시 | 1 | 봉
 | 흰깨볶음 | 100 | g
조  리  방  법 | 만드는방법 1.가쓰오다시를 만들어 도사스를 먼저 만들어 둔다. 2.무우즙을 갈아 매운맛을 제거하여둔다, 3.해삼을 얇게 썰고,[NAME] 하여둔다. [NAME] 하여 소금으로 절여서 씻어둔다. 5.준비된 도사스에 무우즙을 [NAME]6.그릇에 담고 깨소금을 살짝 뿌려서 완성한다.   도사스 : 가쓰오다시6:설탕1:식초2.5:미림0.5.국간장색.레몬
Spreadsheet: 884490d1733707309-budget-adjustment-as-per-target-values-budgetadjustment-jt-1-
Sheet: JT

CURRENT SITUATION |  |  |  | Max of Column B&C + Column D |  | REQUIRED VALUES |  |  |  |  |  |  |  | Cumulative | Cumulative ETC | Current Total | Final | Combined
GROUP | PO_VALUE | ACTUALS | ETC | EAC |  | PO_VALUE | ACTUALS | ETC | EAC |  | CHECK |  |  | ETC | excl current value | - Target | ETC | [NAME]
A | 100 | 0 | 200 |  |  | 100 | 0
B | 200 | 0 | 200 |  |  | 200 | 0
C | 0 | 100 | 0 |  |  | 0 | 100
D | 100 | 200 | 0 |  |  | 100 | 200
A | 500 | 200 | 0 |  |  | 500 | 200
B | 0 | 400 | 100 |  |  | 0 | 400
C | 200 | 0 | 100 |  |  | 200 | 0
D | 0 | 100 | 0 |  |  | 0 | 100
A | 0 | 0 | 1000 |  |  | 0 | 0
B | 500 | 200 | 0 |  |  | 500 | 200
C | 100 | 200 | 0 |  |  | 100 | 200
D | 500 | 200 | 1000 |  |  | 500 | 200
 |  |  |  | Current Total |  |  | Target |  | Current Total | DELTA |  | Required Adjustment
A |  |  |  |  |  |  | 1600
B |  |  |  |  |  |  | 1200
C |  |  |  |  |  |  | 500
D |  |  |  |  |  |  | 2000
Total
 |  |  |  |  |  | I need a formula in Column I (ETC) as highlighted to meet the target value by Group
 |  |  |  |  |  | PO_Value and Actuals should not be changed
 |  |  |  |  |  | EAC value should be greater than or equal to maximum of PO_Value or Actuals
Spreadsheet: tracy_geaccone__40277__Non recurring Q3 2001-asset sales
Sheet: Lurgi

Lurgi
Pro Forma Loss Calculation  (a)
(In millions of US$)
Cash Consideration Received |  |  |  |  |  | 0 |  | 141.5
Less Transaction Costs (estimated) |  |  |  |  |  | 0 |  | -3
Outcome of Consideration placed in Escrow |  |  |  |  |  | 0 |  | -10
Net Consideration Received
Cost Basis:
 | Azurix's Equity Investment at 7/31/01 |  |  | 21.8
 | Loans to [NAME] to be contributed at closing |  |  | 3 |  | (b)
 | Additional funds to be invested or loaned to Lurgi
 | 8/1/01 - closing date
 | Intercompany net receivables from Lurgi to be
 | contributed at closing |  |  | 0
 | Equity earnings/(loss) from 8/1/01 - closing date |  |  | 0
Total Cost Basis
Working Capital Adjustment |  |  |  |  |  | 0 |  | 0
Debt Adjustment |  |  |  |  |  | 0
Pre-Tax Loss
Tax Loss on 338H-10 Election (estimated) |  |  |  |  |  | 0 |  | 28.2
Pro Forma Azurix Loss on Sale
Book Value of PP&E and [NAME]
Fair value of Lurgi future cash flows (PP&E / Goodwill)
Fair value of net assets other than A/P - Brazil,
PP&E, goodwill and deferred tax assets
Fair value of Lurgi equity
[NAME]
SFAS 121 Impairment
Write-off of CTA |  |  |  |  |  | -5.8
Write-off of Deferred Tax Assets |  |  |  |  |  | -2.7
 | Total Write-off
(a) - Assumes asset is not sold but existing contracts are completed and no new contracts are signed.
(b) - Assumes that $3.0mm N/R from Lurgi CFA is transferred above the Brazil entities being sold prior to closing.
Spreadsheet: 821813d1678905439-copying-only-certain-items-to-separate-sheet-based-on-if-formula-new-master
Sheet: Food Delivery

Time | Party Room | Items | Quanity
09:01:00 | 3 | Cheese Pizza | 1
09:01:00 | 3 | Pepperoni Pizza | 1
11:30:00 | 1 | Cheese Pizza | 10
13:00:00 | 3 | Taco Buffet | 2
Spreadsheet: 42247d1240851379-help-with-formula-complex-if-and-help-needed
Sheet: Sheet1

Name | Status | 2009 Referals | 2008 Referals | 2007 Referals
[NAME] | H
[NAME] | G | 1
[NAME] | E | 2 | 1
[NAME] | B |  | 1 | 4
Carol | C | 1 |  | 2
[NAME] | D |  |  | 3
 | A
 | B |  |  | 1
 | C |  | 1
 | D |  | 1 | 1
 | E | 1
 | F | 1 |  | 1
 | G | 1 | 1
 | H | 1 | 1 | 1
I need a complex IF AND formula for status cell that will evaluate the 3 yellow cells and automatically generate and
place one of 7 status indicators in the status cell in that persons associated status cell.
The status cell formula should place one of the following 6 status comments for an individual under associated conditions
if 2009 equal blank and 2008 blank and 2007 blank     satus set to "never referred"
if 2009 not blank and 2008 blank and 2007 equal blank     satus set to "new referer"
if 2009 not blank and 2008 blank and 2007 not blank     satus set to "not refered since 2007 referring again"
if 2009 not blank and 2008 not blank and 2007 not blank      satus set to "regular refererer since 2007"
if 2009 not blank and 2008 not blank and 2007 blank      satus set to "regular refererer since 2008"
if 2009 blank and 2008 blank and 2007 not blank      satus set to "not refered since 2007"
if 2009 blank and 2008 not blank       satus set to "not refered since 2008"
1 | 0 | 0 | 0
2 | 1 | 0 | 0
Spreadsheet: 772078d1646998251-need-help-on-formula-to-get-score-for-help-calculation
Sheet: Sheet1 (2)

 |  |  |  | 2 | 2.5 | 3.5 | 4.5 |  |  |  |  | 2 | 2.5 | 3.5 | 4.5
 |  | Transaction Per Hr | Weight | Range |  |  |  | Out of 5 |  | Transaction Per Hr | Weight | Range |  |  |  | Out of 5
 |  | 27 | 5 | 16 | 21 | 24 | 27 |  |  | 2.5 | 5 | 2 | 4 | 6 | 8
 |  |  | I need formula in I4
 |  |  | Where on the basis of C4 Value
 |  |  | I should get Out of 5
 |  |  | For e.g
 |  |  | if C4  value falls in between 16 - 21  then out of would be in between 2 to 2.5.. And so on
 |  |  | if C4  value falls in between 21 - 24  then out of would be in between 2.5 to 3.5.. And so on
Spreadsheet: 0598886f-acfb-46c6-8def-fe6aa7b0f443
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
7165 | 8163 | Peggy | Mcdowell-Cramer | USA | 648 | 00:18:26 | 00:00:57 | 00:25:32 | 00:01:58 | 00:19:02 | 1 | 01:05:55
Spreadsheet: 195391d1353510529-help-with-housemate-finance-spreadsheet-flat-finances
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Georgia | [NAME] | [NAME] | [NAME] | [NAME]
 | Finance |  |  |  |  |  |  |  |  |  |  | Georgia |  |  |  |  |  | <--- What you owe the person above
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Date | Item | Amount | Each | Payer | Georgia | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME]
 | 2012-11-19 00:00:00 | Sky November | 100 |  | Georgia
 |  | Tesco Shop | 60 |  | Georgia
 |  | [NAME] | 12 |  | [NAME]
Spreadsheet: 14a6a830-835b-4a81-9440-3389ef828f66
Sheet: 11c

Product | AUD** | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis*
FRA |  |  |  |  |  | 196 |  | 400 |  | 596
IRS- [NAME] | 618 | 428 | 218 |  |  |  | 152 | 189 | 436 | 2041
OIS
VNS
Zero Coupon
TOTAL | 618 | 428 | 218 |  |  | 196 | 152 | 589 | 436 | 2637
Estimated swap transaction volumes, week ending November 23, by product type and major currency (in number of transactions), all participant types, cleared and uncleared.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Data Dictionary for major currency descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 767229d1644343508-index-vs-vlookup-analytics-index-match
Sheet: Dataset1

 | Clicks | Cost | CPC | Users | Sessions | [NAME] | Pages / Session | Phone Call (Goal 1 Conversion Rate) | Phone Call (Goal 1 Completions) | Phone Call (Goal 1 Value) | Assisted
PPC_NB_Orthodontist | 16 | 89.00838 | 5.56302375 | 13 | 14 | 0.7142857142857143 | 1.285714285714286 | 0.1428571428571428 | 2 | 0
PPC_BR_Brand | 6 | 15.64 | 2.606666666666666 | 2 | 2 | 0.5 | 1 | 0 | 0 | 0 | #N/A
PPC_NB_Invisalign | 6 | 43.368057 | 7.2280095 | 2 | 2 | 1 | 1 | 0 | 0 | 0 | #N/A
Spreadsheet: 136708d1326800456-1-column-to-a-indirect-formula-indirect-formula-adjustment
Sheet: Sales by Product M2

 |  |  |  |  | BH50
 |  |  |  |  | IGUToughened
 |  |  |  |  | EnergiKare
 |  |  |  |  | Aluminium
 |  |  |  |  | Toughened
 |  |  |  |  | No Textured
 | [NAME] | Customer Reference | Customer Name | Month | No Georgian
 | 1 | 1 | Customer 1 | Apr | #N/A
 |  |  |  | May |  |  | +1 = BI
 |  |  |  | Jun |  |  | +2 = BJ
 |  |  |  | Jul |  |  | +3 = BK
 |  |  |  | Aug |  |  | +4 = BL
 |  |  |  | Sep |  |  | +5 = BM
 |  |  |  | Oct |  |  | +6 = BN
 |  |  |  | Nov
 |  |  |  | Dec
 |  |  |  | Jan
 |  |  |  | Feb
 |  |  |  | Mar
 |  |  |  | Apr
 |  |  |  | May
 |  |  |  | Jun
 |  |  |  | Jul
 |  |  |  | Aug
 |  |  |  | Sep
 |  |  |  | Oct
 |  |  |  | Nov
 |  |  |  | Dec
 |  |  |  | Jan
 |  |  |  | Feb
 |  |  |  | Mar
 | 2 | 2 | Customer 2 | Apr | #N/A
 |  |  |  | May |  |  | +1 = BI
 |  |  |  | Jun |  |  | +2 = BJ
 |  |  |  | Jul |  |  | +3 = BK
 |  |  |  | Aug |  |  | +4 = BL
 |  |  |  | Sep |  |  | +5 = BM
 |  |  |  | Oct |  |  | +6 = BN
 |  |  |  | Nov
 |  |  |  | Dec
 |  |  |  | Jan
 |  |  |  | Feb
 |  |  |  | Mar
 |  |  |  | Apr
 |  |  |  | May
 |  |  |  | Jun
 |  |  |  | Jul
 |  |  |  | Aug
 |  |  |  | Sep
 |  |  |  | Oct
 |  |  |  | Nov
 |  |  |  | Dec
 |  |  |  | Jan
 |  |  |  | Feb
 |  |  |  | Mar
Spreadsheet: 1816b04b-aedb-4719-a83b-bfae94146778
Sheet: CPI-Jul2011

Referendum Cap Calculation with Final Inflation Data
FY 2005 - FY 2011
CPI - All Urban Consumers
Series Id:    CUUR0000SA0
U.S. All items, 1982-84=100
Source: | U.S. Department of Labor
 | Bureau of Labor Statistics
 | http://www.bls.gov/
Downloaded:  July 28, 2011
 |  | A | B | C | D | E | F | G | H | I | J
 |  |  |  |  |  |  |  |  |  | [NAME]. [NAME] | Actual
 |  | Calendar | Calendar | Fiscal | Annual | Inflation | [NAME] | Inflation | Actual | Increase | Inflation
Fiscal | Calendar | First | Second | Year | Projected | Ratio | Allow Based | Based | [NAME]. [NAME] | over | Ratio
Year | Year | Half | Half | Average | Inflation | [NAME]. [NAME] | [NAME]. [NAME] | [NAME]. [NAME] | Gtr of F or G | FY 2004 | Alt. [NAME]
2002 | 2002
2003 | 2003
2014 | 2014
2015 | 2015
2016 | 2016
Spreadsheet: 808520d1670505174-to-forecast-a-range-of-cells-in-a-column-forecast
Sheet: Sheet4

 | 2 |  | 440 |  |  |  | 440
 | 2 |  | 455 |  |  |  | 455
 | 2 |  | 458 |  |  |  | 458
 | 2 |  | 477 |  |  |  | 477
 | 2 |  | 465 |  |  |  | 465
 | 2 |  | 488 |  |  |  | 488
 | 2 |  | 480 |  |  |  | 480
 | 2 |  | 500 |  |  |  | 500
 | 2 |  | 495 |  |  |  | 495
 | 2 |  | 497 |  |  |  | 497
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
 | 1 |  | 0
Spreadsheet: 825321d1681241627-sum-based-on-product-and-phase-sum-of-time-by-product-and-phase
Sheet: Sheet1

 | product 1 | plan | prep | execute | ramp down
 | product 2 |  | plan | prep | prep | prep | execute | execute | execute
 | product 3 |  |  |  | plan | prep | execute | ramp down
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8
 | # of days | 5 | 4 | 3 | 2 | 5 | 5 | 5 | 5
 | Scenario 1 |  |  | Scenario 2 |  |  | Scenario 3
 | Product | Phase |  | Product | Phase |  | Product | Phase
 | Product 1 | Plan |  | Product 2 | Execute |  | Product 1 | ramp down
 | Sum Result # of days: | 5 |  | Sum Result # of days: | 15 |  | Sum Result # of days: | 2
 |  | ^ sum of row 8 where 'plan' appears in the range C3 to J5 for the row match of product 1
Spreadsheet: 9a9aafe3-639f-46f3-a06e-0409a980e78e
Sheet: Sheet1

Feedback for ES4 2012 |  |  |  |  |  |  | 1 | too simple | worse than expected | yes | Supervisor
 |  |  |  |  |  |  | 2 | about right | as you expected | no | NCAS Website
Name (optional) |  |  |  |  |  |  | 3 | too complex | better than expected |  | NERC Email
 |  |  |  |  |  |  | 4 |  |  |  | Poster in Department
Arrows indicate presence of dropdown boxes. Where present 1=poor 3=average 5=excellent |  |  |  |  |  |  | 5 |  |  |  | Twitter
How did you hear about the spring school? |  |  |  |  |  |  |  |  |  |  | Other Students
if other, please specify. |  |  |  |  |  |  |  |  |  |  | Other
Lectures
1.       How would you rate the quality of lectures? (enter 1,2,3,4,5)
2.       In general how did you feel the content of the lectures was pitched ?
3.       Were there any lectures/lecturers that you felt were particularly good? And why?
4.       Were there any lectures that you didn’t enjoy/couldn’t follow? Please explain.
5.       Any other comments about lectures, lecturers or lecture content?
Activities
6.       Were there any activities that you felt were particularly good? Why?
7.       Were there any activities that you didn’t enjoy? Please explain.
8.       How would you rate the geology field trip to the Isle of Wight?
9.       How would you rate the Introduction to Oceanography on the RV Callista?
10.   Any other comments about the activities?
General
11.   Was there any topic that wasn’t covered that you think should have been?
12.   Was the course content:
13.   The aims of the course were shown to you. Do you feel these aims were met?
If no, why?
14.   Did the course in general meet your needs?
If no, why?
Do you have any suggestions as to how the course could be improved next year?
15.   Any other comments about the course in general?
Venue, Accommodation and Logistics
16.   How would you rate the venue (NOC)?
17.   How would you rate the catering at NOC?
18.   How would you rate the hotel?
19.   How would you rate the meals at the hotel?
20.   How would you rate the application process?
Any comments?
21.   How would you rate the general course organisation?
Any other comments about course organisation, accommodation or logistics?
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 8a

Product1 | Cleared2 | Uncleared | TOTAL
Basis | 27 | 48 | 75
Cap/Floor | - | 211 | 211
Debt Option | 0 | 0
Exotic | 0 | 0
Fixed-Fixed | - | 31 | 31
Fixed-Float | 8186 | 2280 | 10466
FRA | 36 | 181 | 217
Inflation | - | 107 | 107
OIS | 33 | 173 | 206
Swaption | - | 880 | 880
TOTAL
Spreadsheet: 158575d1338309168-unique-values-from-comma-seperated-text-to-different-worksheet-twiggywaleseducation
Sheet: Input

Modality
[NAME],TCeMEP,TOF,S-EMG
[NAME],TCeMEP,TOF
BAERs,S-EMG,TOF
[NAME]
[NAME],TCeMEP,TOF,S-EMG,T-EMG
BAERs
S-EMG,T-EMG,TOF
[NAME],TCeMEP,TOF,D-WAVES
TOF,S-EMG,T-EMG,BAERs
S-EMG,TOF
Spreadsheet: 4b50dc01-ac1f-43c0-8bd6-e72969cb74f1
Sheet: Sheet1

DAFTAR PESERTA PLPG RAYON 112 UNIVERSITAS NEGERI SEMARANG | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
TAHAP XIV GUGUS SUMBING
[NAME] Tanggal 13 - 22 Nopember 2011
Kelas | : Pendidikan Teknik Otomotif
No | No peserta | Nama | Sekolah | [NAME]
1 | 11036258610230 | HARDI DARMONO | SMK MUHAMMADIYAH SALATIGA | [NAME]
2 | 11036258610254 | SETYO DWI WALUYO | SMK (STM) KRISTEN SALATIGA | [NAME]
3 | 11036258610268 | MATEAS MA''RUF | SMK (STM) AL-FALAH | [NAME]
4 | 11036358611666 | DAYAT SUGIMIN | SMK (STM) N 10 SEMARANG | [NAME]
5 | 11036358611669 | ARIE BUDIARTONO | SMK (STM) N 10 SEMARANG | [NAME]
6 | 11036358611670 | SUPARJI | SMK (STM) CINDE | [NAME]
7 | 11036358611671 | SUBCHAN | SMK (STM) N 5 SEMARANG | [NAME]
8 | 11036358611672 | RUDI RIYANTO | SMK (STM) N 5 SEMARANG | [NAME]
9 | 11036358611673 | SETIYAWAN | SMK (STM) N 4 | [NAME]
10 | 11036358611674 | NANANG AGUS BAHARUDIN | SMK (STM) N 4 | [NAME]
11 | 11036358611675 | ZAKARIA | SMK (STM) N 7 | [NAME]
12 | 11036358611676 | KUSTONO | SMK (STM) N 7 | [NAME]
13 | 11036358611677 | ALIP RAHARJO | SMK (STM) N 7 | [NAME]
14 | 11036358611678 | MOCHAMAD ROFINGI | SMK (STM) IPTEK TUGU SUHARTO | [NAME]
15 | 11036358611679 | JOKO SUPRAPTO | SMK (STM) SEPULUH NOPEMBER | [NAME]
16 | 11036358611680 | [NAME] | SMK (STM) SEPULUH NOPEMBER | [NAME]
17 | 11036358611681 | AGUS SUWARNO | SMK (STM) SEPULUH NOPEMBER | [NAME]
18 | 11036558610366 | ARI ADIWIJAYANTO | SMK N 3 | [NAME]
19 | 11030242911717 | UMAR NUR ARIF | SMK GIRIPURO SUMPIUH | Kab. Banyumas
20 | 11030242911718 | RAHADI | SMK GIRIPURO SUMPIUH | Kab. Banyumas
21 | 11030242911720 | [NAME] | SMK GIRIPURO SUMPIUH | Kab. Banyumas
22 | 11030242911777 | SUGENG | SMKN 2 BANYUMAS | Kab. Banyumas
23 | 11030158611312 | [NAME] | SMK (STM) N 2 CILACAP | Kab. Cilacap
24 | 11030158611315 | SUPARWI | SMK (STM) N KARANGPUCUNG | Kab. Cilacap
25 | 11030158611317 | LASIMUN | SMK (STM) N KARANGPUCUNG | Kab. Cilacap
26 | 11030158611318 | GUNAWAN | SMK (STM) N KARANGPUCUNG | Kab. Cilacap
27 | 11030158611321 | SRI MARIA YUNIATIN | SMK (STM) N KARANGPUCUNG | Kab. Cilacap
28 | 11030158611322 | YEYE HADIANTO | SMK (STM) N 1 WANAREJA | Kab. Cilacap
29 | 11030158611332 | BUDI RAHWANTO | SMK NEGERI 1 BINANGUN | Kab. Cilacap
30 | 11030258611690 | MUKHAMMAD LATIEF KAMAL | SMK KESATRIAN PURWOKERTO | Kab. Banyumas
31 | 11030258611692 | MUHAMAD NAJIB | SMK Wiworotomo Purwokerto | Kab. Banyumas
32 | 11030258611693 | DARYANTO | SMK Wiworotomo Purwokerto | Kab. Banyumas
33 | 11030258611698 | ROIS MUSTOLIH | SMK Wiworotomo Purwokerto | Kab. Banyumas
34 | 11030258611708 | WING SIGIT | SMK TUJUH LIMA 2 PURWOKERTO | Kab. Banyumas
35 | 11030258611727 | MALIKHATUN | SMK Maarif NU 1 AJIBARANG | Kab. Banyumas
36 | 11030258611751 | WAHYU WIDODO | [NAME] JATILAWANG | Kab. Banyumas
37 | 11032858610855 | ANON PRIYANTORO | SMK N WARUREJA | Kab. Tegal
38 | 11036342411667 | ANTAR SUBANDANA | SMK (STM) Dr. [NAME] | [NAME]
39 | 11036342411668 | WINARKO CAHYO PRASETIO | SMK (STM) YPP | [NAME]
Spreadsheet: 724912d1616440884-iso-the-right-formula-or-solution-comission-tool
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | 20 | 30 | 40 | 50
 | Line | Avg premium / item | Commission Rate |  |  | Qualifiers | Line 10 items | Combination of lines 10 and 70 |  | Bonus Payouts per line | 20 - 29 | 30 - 39 | 40 - 49 | 50 +
 | Line 10 | 600 | 0.09 |  |  | ABO | 10 | 0 |  | Line 10 | 20 | 30 | 40 | 50
 | Line 70 | 750 | 0.09 |  |  | VC | 10 | 20 |  | Line 70 | 20 | 30 | 40 | 50
 | Line 71 | 130 | 0.09 |  |  |  |  |  |  | Line 72 | 20 | 30 | 40 | 50
 | Line 72 | 650 | 0.09 |  |  |  |  |  |  | Line 19 | 5 | 5 | 5 | 5
 | Specialty Lines | 200 | 0.09 |  |  |  |  |  |  | All other Lines | 5 | 5 | 5 | 5
 | Line 19 | 800 | 0.07
 | The following tool assumes the agency has achieved the 2 qualifiers; 10 Line 10's and a combination of 20 Line 10's and line 70's
 | Insert total Items for the office ---> | 40
 | Line Code | Items | Total Premium | Commission Rate | Total Commission | Plus Bonus Payout | Total Payout
 | Line 10 | 10 | 1250 | 0.09
 | Line 70 | 13 | 4250 | 0.09
 | Line 72 | 6 | 1200 | 0.09
 | Line 19 | 5 | 1000 | 0.07
 | All Other lines | 1 | 120 | 0.09
 | Total
Spreadsheet: 58905d1259176670-date-lookup-to-get-week-back-dates-and-week
Sheet: Sheet2

 | 09/13/2009 12:01:00 AM | Semaine du 14 Septembre 2009
 | 09/20/2009 12:01:00 AM | Semaine du 21 Septembre 2009
 | 09/27/2009 12:01:00 AM | Semaine du 28 Septembre 2009
 | 10/04/2009 12:01:00 AM | Semaine du 5 Octobre 2009
 | 10/11/2009 12:01:00 AM | Semaine du 12 Octobre 2009
 | 10/18/2009 12:01:00 AM | Semaine du 19 Octobre 2009
 | 10/25/2009 12:01:00 AM | Semaine du 26 Octobre 2009
 | 11/01/2009 12:01:00 AM | Semaine du 2 Novembre 2009
 | 11/08/2009 12:01:00 AM | Semaine du 9 Novembre 2009
 | 11/15/2009 12:01:00 AM | Semaine du 16 Novembre 2009
 | 11/22/2009 12:01:00 AM | Semaine du 23 Novembre 2009
 | 11/29/2009 12:01:00 AM | Semaine du 30 Novembre 2009
 | 12/06/2009 12:01:00 AM | Semaine du 7 Décembre 2009
 | 12/13/2009 12:01:00 AM | Semaine du 14 Décembre 2009
 | 12/20/2009 12:01:00 AM | Semaine du 21 Décembre 2009
 | 12/27/2009 12:01:00 AM | Semaine du 28 Décembre 2009
 | 01/03/2010 12:01:00 AM | Semaine du 4 Janvier 2010
 | 01/10/2010 12:01:00 AM | Semaine du 11 Janvier 2010
 | 01/17/2010 12:01:00 AM | Semaine du 18 Janvier 2010
 | 01/24/2010 12:01:00 AM | Semaine du 25 Janvier 2010
 | 01/31/2010 12:01:00 AM | Semaine du 1er Février 2010
 | 02/07/2010 12:01:00 AM | Semaine du 8 Février 2010