tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 738933d1625360299-gpa-calculation-with-grading-rules-given-in-range-gpa-calculation-with-grading-rules-given-in-range
Sheet: Sheet1

 |  |  |  |  |  |  | New Grading Rules |  |  |  |  |  |  | Workings
 |  |  |  | New Grading with GPA |  |  | Percentage |  |  | Value |  | Increment |  |  | Base GPA | Increment | Increment | Final GPA
Obt Marks | Percentage | Grade | Value | Grade | Value |  | From | To | Grade | From | To | Factor |  | Mark | Score | Factor | Factor | Score
49 |  |  |  |  |  |  | 0 | 49.99 | F | 0 | 0.99 |  |  | 0
59.4 |  |  |  |  |  |  | 50 | 54.99 | D | 1 | 1.49
51 |  |  |  |  |  |  | 55 | 59.99 | [NAME] | 1.5 | 1.99
60 |  |  |  |  |  |  | 60 | 64.99 | C | 2 | 2.49
65 |  |  |  |  |  |  | 65 | 69.99 | C+ | 2.5 | 2.99
79.6 |  |  |  |  |  |  | 70 | 74.99 | B | 3 | 3.49
70 |  |  |  |  |  |  | 75 | 79.99 | [NAME] | 3.5 | 3.99
75 |  |  |  |  |  |  | 80 | 89.99 | A | 4 | 4
79 |  |  |  |  |  |  | 90 | 100 | A+ | 4 | 4
80
85
49
Percentage | Grade | Value
0 | F | 0
59.5 | D | 1
69.6 | C | 2
79.5 | B | 3
89.5 | A | 4
https://www.excelforum.com/excel-formulas-and-functions/1353654-gpa-calculation-with-grading-rules-given-in-range.html
Spreadsheet: 757199d1638112892-income-tax-calculation-formula-turkey-income-tax-rates-2021-tms-v2
Sheet: John Topley

Income Tax Calculator (2021)
Areas | Rates | Fixed Amount | Fixed Amount For | Rate Calculation 1 | Rate Calculation 2 | Total |  |  | Income | 30000
0 | 0.15 | 0 | 0
24001 | 0.2 | 3600 | 24000 |  |  |  |  |  | Income Tax
53001 | 0.27 | 9400 | 53000
190001 | 0.35 | 30190 | 190000
650001 | 0.4 | 212190 | 650000
Spreadsheet: sally_beck__33961__GlobalMgmtSum-Q101-0302
Sheet: YTD Mgmt Summary

ENRON GLOBAL MARKETS
2001 EARNINGS ESTIMATE
1st QUARTER YTD
 |  | Plan |  |  |  | Components of Earnings Before Tax |  |  |  |  |  |  |  |  |  | Variances from Plan
 |  |  |  |  |  | Actual | Deals | Forecast | Total | Operating | Capital | Direct | Allocated |  |  | Total | Operating | Capital | Direct | Allocated
Business Team |  | Margin | Expenses(1) | EBT |  | Margin | Identified | Margin | Margin | Expenses | Charge | Expenses | Expenses | Total |  | Margin | Expenses | Charge | Expenses | Expenses | Total
Liquids
Coal
Emissions
Weather
Global Risk Markets
Financial Trading
Transportation
Overview
Office of the Chairman
Subtotal Commercial
LNG
Middle East
Puerto Rico
Subtotal LNG / ME / PR
Total Commercial
Group Support Cost
Support Cost Allocated to Teams
Other Interest Related Charges
Capital Charge Offset
Global Markets EBIT
 |  |  |  |  |  | Other Expenses:
Interest Expense/(Income)
Global Markets Pre-tax Income
 |  |  |  | MPR Change:
(1) Includes capital charge, direct, and allocated expenses
Spreadsheet: 00115e54-60db-4d64-a207-12ad1afcbeca
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
TABLE 1
HEADCOUNT ENROLLMENT OF CREDIT STUDENTS
UNIVERSITY OF HAWAI‘I
Fall 2008
Total Headcount
 |  | Total Headcount | V% | Regular |  | Special
 |  |  |  | SubTotal | Regular Students | SubTotal | Early Admit
UH SYSTEM TOTAL |  | 53526 | 1 | 52985 | 52985 | 541 | 541
University of Hawai`i at Manoa | Campus/Unit Total | 20169 | 0.3768075 | 20165 | 20165 | 4 | 4
 | University of Hawai`i at Manoa | 20169 | 0.3768075 | 20165 | 20165 | 4 | 4
University of Hawai`i at Hilo | Campus/Unit Total | 3773 | 0.0704891 | 3729 | 3729 | 44 | 44
 | University of Hawai`i at Hilo | 3773 | 0.0704891 | 3729 | 3729 | 44 | 44
University of Hawai`i - West O`ahu | Campus/Unit Total | 1140 | 0.0212981 | 1140 | 1140
 | University of Hawai`i - West O`ahu | 1140 | 0.0212981 | 1140 | 1140
University of Hawai`i, Community Colleges | Campus/Unit Total | 28444 | 0.5314053 | 27951 | 27951 | 493 | 493
 | Hawai`i Community College | 2884 | 0.0538804 | 2783 | 2783 | 101 | 101
 | Honolulu Community College | 4218 | 0.0788028 | 4170 | 4170 | 48 | 48
 | Kapi`olani Community College | 8221 | 0.1535889 | 8167 | 8167 | 54 | 54
 | Kaua`i Community College | 1104 | 0.0206255 | 1043 | 1043 | 61 | 61
 | Leeward Community College | 6771 | 0.1264993 | 6700 | 6700 | 71 | 71
 | Maui Community College | 3287 | 0.0614094 | 3149 | 3149 | 138 | 138
 | Windward Community College | 1959 | 0.036599 | 1939 | 1939 | 20 | 20
Continuing Education Headcount
UH SYSTEM TOTAL |  | 1607
University of Hawai`i at Manoa | Campus/Unit Total | 1480
 | University of Hawai`i at Manoa | 1480
University of Hawai`i, Community Colleges | Campus/Unit Total | 127
 | Honolulu Community College | 127
Notes:
1 | Percents may not sum due to rounding.
2 | The Total Headcount is the sum of Regular and Special students only.
3 | [NAME] counts are included in the Regular student count and are shown separately for information purposes only.  Counts for Continuing Education credit students at UH Manoa (Outreach College) and Honolulu CC (SOCAD) are identified by Credit Type field in IRO_Base which identifies students by registered term/academic period.  This excludes students who may have enrolled after the census date.
 | University of Hawai‘i, Institutional Research Office
Spreadsheet: kevin_hyatt__19595__Feb01pnr
Sheet: USGT 500617 

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maximum Inventory Calculation
DAY | NAME | CONTRACT NUMBER | MONTH | POI # | type_poi | SCHEDULED INJECTION | SCHEDULED WITHDRAWAL | NET SCHEDULED QTY | Carryover GIP | NET GIP | DAILY INJECTION   PRICE                (Inj + MIC) | DAILY WITHDRAWAL  PRICE               (Wd + MIC) | INJECTION AMOUNT       (Inj + MIC) | WITHDRAWAL  AMOUNT          (Wd + MIC) | Positive Inventory | Negative Inventory | Positive Inventory Components | Negative Inventory Components | [NAME] | Ride Amount
 | USGT | 27268 | 2001-02-01 00:00:00 | 500617 | PnR
1 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
2 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
3 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
4 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
5 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
6 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
7 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
8 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
9 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
10 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
11 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
12 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
13 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
14 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
15 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
16 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
17 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
18 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
19 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
20 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
21 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
22 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
23 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
24 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
25 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
26 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
27 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
28 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
29 |  |  |  |  |  |  |  |  |  |  | 0.3883 | 0.3883
30 |  |  |  |  |  |  | -14875 |  |  |  | 0.3883 | 0.3883
 |  |  |  |  |  |  |  |  |  |  |  | Total Invoice Amount
 |  |  |  | Total Injection
 |  |  |  | Total W/D
 |  |  |  |  |  |  |  |  |  |  |  |  | INVOICE AMOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  | Inj Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | Wd Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | MIC Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Charge
 |  |  |  |  |  |  |  |  |  |  |  |  | BILL AMOUNT
Spreadsheet: michelle_lokay__26621__imbalsumm0102
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 37095 | 37061
2 | 48398 | 47560
3 | 37220 | 37061
4 | 37303 | 37061
5 | 36998 | 37061
6 | 36966 | 37061
7 | 37003 | 37061
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-01-31 00:00:00 |  |  | 275224
2001-02-07 00:00:00
Spreadsheet: 108510d1305569213-look-for-corresponding-values-in-multiple-workbooks-campaign-work-bs1534a
Sheet: Sheet1

Asset # | Business Unit | Location | Work Order # | RET | Analysis Reports | Task Status | Date Completed | [NAME] | Additional Comments
9322 | 990 | Somewhere | 282152 | 2hrs. | Campaign Details
9327 | 990 | Somewhere | 282152 | 2hrs. | Campaign Details
9332 | 990 | Somewhere | 282152 | 2hrs. | Campaign Details
9333 | 990 | Somewhere | 282152 | 2hrs. | Campaign Details
9334 | 990 | Somewhere | 282153 | 2hrs. | Campaign Details
9335 | 990 | Somewhere | 282153 | 2hrs. | Campaign Details
9339 | 990 | Somewhere | 282153 | 2hrs. | Campaign Details
9342 | 990 | Somewhere | 282153 | 2hrs. | Campaign Details
9345 | 990 | Somewhere | 282153 | 2hrs. | Campaign Details
9347 | 990 | Somewhere | 282153 | 2hrs. | Campaign Details
9354 | 990 | Somewhere | 282154 | 2hrs. | Campaign Details
Spreadsheet: 0db744e1-602a-4aa4-bdd2-c740e5c87235
Sheet: Order Form

 | DAY GROUP ORDER FORM 2013-2014                                                                                                                                                                          MULTI-DAY: NON-HOLIDAY
Holiday Period:  December 21st - January 3rd, January 17th - January 20th, and February 14th - February 23rd.
 | GROUP NAME |  |  |  |  | PHONE NUMBER
 | CONTACT NAME |  |  |  |  | DELIVERY METHOD | Order pick up /ship to location
 | E-MAIL |  |  |  |  | ARRIVAL DATE
 | ADDRESS |  |  |  |  | DEPARTURE DATE
 | ADULT LIFT TICKETS | QUANTITY | RATE | TOTAL |  | TEEN LIFT TICKETS | QUANTITY | RATE | TOTAL
 | Gondola Only |  | 32 |  |  | Gondola Only |  | 28
 | 1 Day |  | 79 |  |  | 1 Day |  | 70
 | 2 Day |  |  |  |  | 2 Day
 | 3 of 5 Day |  |  |  |  | 3 of 5 Day
 | 4 of 6 Day |  |  |  |  | 4 of 6 Day
 | 5 of 8 Day |  |  |  |  | 5 of 8 Day
 | 6 of 9 Day |  |  |  |  | 6 of 9 Day
 | 7 of 10 Day |  |  |  |  | 7 of 10 Day
 | CHILD LIFT TICKETS | QUANTITY | RATE | TOTAL |  | SENIOR LIFT TICKETS | QUANTITY | RATE | TOTAL
 | Gondola Only |  | 18 |  |  | Gondola Only |  | 28
 | 1 Day |  | 48 |  |  | 1 Day |  | 70
 | 2 Day |  |  |  |  | 2 Day
 | 3 of 5 Day |  |  |  |  | 3 of 5 Day
 | 4 of 6 Day |  |  |  |  | 4 of 6 Day
 | 5 of 8 Day |  |  |  |  | 5 of 8 Day
 | 6 of 9 Day |  |  |  |  | 6 of 9 Day
 | 7 of 10 Day |  |  |  |  | 7 of 10 Day
 | RENTAL EQUIPMENT |  |  |  |  | DATE OF RENTALS | QUANTITY | RATE | TOTAL
 | Sport Ski Package |  |  |  |  |  |  | 35
 | Performance Ski Package |  |  |  |  |  |  | 40
 | Demo Ski Package |  |  |  |  |  |  | 43
 | Sport Board Package |  |  |  |  |  |  | 35
 | Demo Board Package (Pick up at Boarding House) |  |  |  |  |  |  | 43
 | Kids Ski Package |  |  |  |  |  |  | 20
 | Kids Board Package |  |  |  |  |  |  | 20
 | Helmet Rental |  |  |  |  |  |  | 8
 | SKI  LESSONS |  |  |  |  | DATE OF LESSONS | QUANTITY | RATE | TOTAL
 | Learn to SKI Package: Limited lift access (levels 1-3) |  |  |  |  |  |  | 132
 | Learn to SKI: No Equipment, Limited Lift Access |  |  |  |  |  |  | 106
 | SKI Lesson Only (All Levels) |  |  |  |  |  |  | 89
 | Adventure Session SKI Package (Levels 4-8) |  |  |  |  |  |  | 149
 | SNOWBOARD LESSONS |  |  |  |  | DATE OF LESSONS | QUANTITY | RATE | TOTAL
 | Learn to RIDE Package: Limited lift access (levels 1-3) |  |  |  |  |  |  | 132
 | Learn to RIDE: No Equipment, Limited Lift Access |  |  |  |  |  |  | 106
 | SNOWBOARD [NAME] Only (All Levels) |  |  |  |  |  |  | 89
 | Adventure Session BOARD Package (Levels 4-8) |  |  |  |  |  |  | 149
 | FOOD AND BEVERAGE |  |  |  |  | DATE FOR VOUCHERS | QUANTITY | RATE | TOTAL
 | $18.00 Lunch Voucher |  |  |  |  |  |  | 15
 |  |  |  |  |  |  | GRAND TOTAL:
Spreadsheet: 49656d1248992778-need-help-with-a-golf-tournament-scorecard-b-and-btournament
Sheet: Sheet1

 | PLAYER |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | OUT | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | IN | TOTAL
 | PLAYER |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | OUT | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | IN | TOTAL
 | PLAYER |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | OUT | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | IN | TOTAL
 | PLAYER |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | OUT | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | IN | TOTAL
Spreadsheet: errol_mclaughlin_jr__10320__TRV E-mail
Sheet: Sheet1

Region | Report Name within Region | User First Name | User Last Name | User ID | [NAME] | View | Publish | Administrator
Financial Risk Region |  | [NAME] | [NAME] | [NAME] | [NAME] | Y
 |  | [NAME] | Maggi | mmaggi | micheal.maggi | Y
 |  | [NAME] | May | lmay | larry.may | Y
 |  | [NAME] | Griffith | [NAME] | [NAME] | Y
 |  | Dutch | Quigley | dquigle | dutch.quigley | Y
 | NG-Price P&L, NG-PROPT P&L | [NAME] | [NAME] | [NAME] | joey.taylor | Y | Y
 | NG-Price P&L, NG-PROPT P&L | Bilal | Bajwa | bbajwa | bilal.bajwa | Y | Y
 | GD-OPT P&L | George | Huan | ghuan | george.huan | Y | Y
 | GD-OPT P&L | Sean | Riordan | sriordan | sean.riordan | Y | Y
 | NG-Price P&L, NG-PROPT P&L | Errol | McLaughlin | emclaug | errol.mclaughlin | Y | Y | Y
Spreadsheet: 878666d1725904657-need-formula-to-pull-tasks-when-name-entered-into-table-rota-test
Sheet: Sheet1

 | Morning |  |  |  |  | Afternoon |  |  |  |  | Night
Tasks
Task1 | Kenny | Katyla |  |  |  | Kenny | Kayla |  |  |  | George
[NAME] | [NAME] | [NAME] |  |  |  | [NAME] | [NAME]
Task3 | [NAME] |  |  |  |  | [NAME]
Task4
Task5
Task6
Task7 | Laurence |  |  |  |  | Laurence | [NAME]
Task8 | Ciaran | [NAME] |  |  |  | Scott | [NAME] | Ciaran
Task9 | [NAME] | [NAME] |  |  |  | [NAME] | [NAME] | [NAME]
Task10 | Scott | [NAME]
Task11 | [NAME] |  |  |  |  | [NAME]
Task12
Task13 | [NAME] | [NAME] | George | Mark |  | [NAME] | [NAME] | George | Mark |  | [NAME] | [NAME] | [NAME]
 | Morning | AfternoonNight
Kenny | Task1 | [NAME]
George | Task13 | Task13 | Task1
Spreadsheet: 116109d1311605858-excel-2007-hours-and-minutes-to-decimal-weekly-costs-2011
Sheet: Costs

7/18/2011 - 7/24/2011
SIMPLE COSTS |  |  |  |  |  | INVENTORY COSTS
7/18/2011 - 7/24/2011 |  |  |  |  |  | 7/4/2011 - 7/17/2011 |  |  | 5/30/2011 - 6/26/2011
SALES | 2011 |  | 2010 | + / - |  | BEV COSTS |  |  | FOOD COSTS
Beer | 1962.19 |  | 2101 |  |  | BEER |  |  | FOOD - Rest
Liquor | 6910.45 |  | 6723 |  |  | Open Inv | 1620 |  | Open Inv | 15200
Wine | 1479.75 |  | 1102 |  |  | Purchases |  |  | Purchases
TOTAL ALCOHOL | 10352.39 |  | 9926 | 426.3899999999994 |  | Total Inv | 1620 |  | Total Inv | 15200
 |  |  |  |  |  | Closing Inv | 1619.6986 |  | Closing Inv
Beverage | 1110.75 |  | 1138 |  |  | Usage | 0.3013999999998305 |  | Usage | 15200
Food | 27916.62 |  | 28223 |  |  | Sales |  |  | Sales
TOTAL FOOD | 29027.37 |  | 29361 | -333.630000000001 |  | Total Cost | #N/A |  | Total Cost | #N/A
Salsa | 550 |  | 36 |  |  |  |  |  | FOOD - Product
Sauce | 470.5 |  | 270 |  |  | LIQUOR |  |  | Open Inv | 6048
Grocery | 1573.1 |  | 434 |  |  | Open Inv | 6187 |  | Purchases
Soup | 0 |  | 0 |  |  | Purchases |  |  | Total Inv | 6048
Private Label | 0 |  | 0 |  |  | Total Inv | 6187 |  | Closing Inv | 6048
 |  |  |  |  |  | Closing Inv | 6186.808500000001 |  | Usage | 0
TOTAL PRODUCT | 2593.6 |  | 740 | 1853.6 |  | Usage | 0.1914999999989959 |  | Sales
 |  |  |  |  |  | Sales |  |  | Total Cost | #N/A
TOTAL SALES | 41973.35999999999 |  | 40027 | 1946.359999999993 |  | Total Cost | #N/A
 |  |  |  |  |  |  |  |  | HARD RAW - PL
 |  |  |  |  |  | WINE |  |  | Open Inv | 23964
PURCHASES | 2011 |  | 2010 |  |  | Open Inv | 1459 |  | Purchases
Beer | 348 | 0.1773528557377216 | 596 |  |  | Purchases |  |  | Total Inv | 23964
Liquor | 1463 | 0.211708354738114 | 1920 |  |  | Total Inv | 1459 |  | Closing Inv | 23964
Wine | 310 | 0.2094948471025511 | 0 |  |  | Closing Inv | 1459.105 |  | Usage | 0
TOTAL ALCOHOL | 2121 | 0.2048802257256537 | 2516 | -395 |  | Usage | -0.1050000000000182 |  | Sales
 |  |  |  |  |  | Sales |  |  | Total Cost | #N/A
FOOD - Restaurant |  |  |  |  |  | Total Cost | #N/A
Bev | 553 |  | 776 |  |  |  |  |  | TOTAL PL
Dairy | 636 |  | 966 |  |  | TOTAL BEV |  |  | Open Inv | 30012
Dry Goods | 3131 |  | 3357 |  |  | Open Inv | 9266 |  | Purchases | 0
Fish | 645 |  | 446 |  |  | Purchases | 0 |  | Total Inv | 30012
Meat | 1621 |  | 1901 |  |  | Total Inv | 9266 |  | Closing Inv | 30012
Produce | 2176 |  | 1895 |  |  | Closing Inv | 9265.6121 |  | Usage | 0
Paper | 169 |  | 105 |  |  | Usage | 0.3878999999997177 |  | Sales | 0
Supplies | 69 |  | 6 |  |  | Sales | 0 |  | TOTAL FOOD % | #N/A
TOTAL FOOD - Rest | 9000 | 0.3100522024558202 | 9452 | -452 |  | TOTAL BEV % | #N/A
FOOD - Product
Dry |  |  | 356 |  |  |  |  |  | TOTAL FOOD
Produce |  |  | 83 |  |  |  |  |  | Open Inv | 21248
Liquor |  |  |  |  |  |  |  |  | Purchases | 0
TOTAL FOOD - prod | 0 | 0 | 439 | -439 |  |  |  |  | Total Inv | 21248
 |  |  |  |  |  |  |  |  | Closing Inv | 6048
TOTAL PURCHASES | 11121 | 0.2649537706774011 | 12407 | -1286 |  |  |  |  | Usage | 15200
 |  |  |  |  |  |  |  |  | Sales | 0
 |  |  |  |  |  |  |  |  | TOTAL FOOD % | #N/A
NOTES:
Spreadsheet: sally_beck__33852__consolidated reporting for 11 28
Sheet: A 01

 | Quantitative Standards
 | Daily Exception Reports
 | Reports Supporting Quantitative Standards A
Report A 01:
Purpose: |  | To capture transactions either not input or input but not valued in the Risk Management System.
Location | Deal # | Date deal was done | Description of the deal | Quantity | Reason why deal was not input/ not valued | Key contact (book admin)
Canada |  | None | NA | NA | NA | NA
EES |  | Q3 | General Growth Products Power deal | 1 | Currrent RPS does not handle volume of batches | [NAME]
 |  | 2000-11-15 00:00:00 | Macerich JV-Ontario Teachers |  | Power batches not consistent with RPS | [NAME]
US Gas |  | none | NA | NA | NA | NA
US liquids |  | none | NA | NA | NA | NA
[NAME] |  | none | NA | NA | NA | NA
Metals
 |  |  | Enron Metals 28/11/00
 |  |  | 75 London -  Financial Trading Deals |  | Input errors, mainly due to incorrect dates, LME type and incorrect price | [NAME] | Metals
 |  |  |  |  | Entered on next day. Temporary Risk Manager currently in Hamburg,
 |  |  |  |  | developing reporting procedures
 |  |  | Enron Metals 27/11/00 |  | Information on error report was only available today.
 |  |  | 47 London -  Financial Trading Deals |  | Input errors, mainly due to incorrect dates, LME type and incorrect price
 |  |  |  |  | Entered on next day. Temporary Risk Manager currently in Hamburg,
 |  |  |  |  | developing reporting procedures
 |  |  | Enron Metals New York |  | Due to the [NAME] some transactions in Copper Scrap will be in the system on Monday.
 |  |  | 2 Physical Contracts Net Short = 31 |  | These are primarily Terminal Trade Transactions:
 |  |  | 4 Terminal Contracts Net Long = 317
 |  |  | Enron Metals - Merchanting
 |  |  | Amendment
 | 990328 | Contract amendment done 17th Nov | Contract increase of Dec 2000 quota | 25T | Timing | [NAME]
 |  |  | Contract increase of Jan 2001 quota | 50T | Timing | [NAME]
Continental gas |  | 2000-11-17 00:00:00 | Physical Forward | 190.5 m kWh | Have the right to enter into an agreement for the sale of Gas into Germany. | [NAME]
 |  |  |  |  | This is a structured deal based on oil ([NAME]) and wll only be exercised
 |  |  |  |  | if transport can be obtained before 31st Dec 2000 (so effectively a long put option).
 |  |  |  |  | The time value on this option will not be valued but a deal will be put into Gas
 |  |  |  |  | Desk (no MTM) to reflect this.
 | Report A 01:
 | Purpose: | To capture transactions either not input or input but not valued in the Risk Management System.
 | Nil
UK credit trading |  |  |  |  | Nil | [NAME]
Continental power |  |  |  |  | Nil | Coralie Evans
Structured commodities |  |  |  |  | N/A (per [NAME]) | [NAME] D'arcy
UK power |  |  |  |  | Nil | [NAME]
Spreadsheet: 750999d1633772114-indicate-pairs-based-on-given-battery-log
Sheet: Batteries

Battery |  | # | Type | Indicated mAh | Measured mAh | % | Pairs
Brand |  | 1 | AA | 2450 | 2300 |  | *
Brand |  | 2 | AA | 2450 | 2350 |  | *
Brand |  | 3 | AA | 2450 | 600 |  | ****
Brand |  | 4 | AA | 2450 | 2000 |  | **
Brand |  | 5 | AA | 2450 | 1000 |  | ***
Brand |  | 6 | AA | 2450 | 650 |  | ****
Brand |  | 7 | AA | 2450 | 1985 |  | **
Brand |  | 8 | AA | 2450 | 1100 |  | ***
Battery |  | # | Type | Indicated mAh | Measured mAh | % | Pairs
Brand |  | 1 | AA | 1900
Brand |  | 2 | AA | 1900
Brand |  | 3 | AA | 1900
Brand |  | 4 | AA | 1900
Brand |  | 5 | AA | 1900
Brand |  | 6 | AA | 1900
Brand |  | 7 | AA | 1900
Brand |  | 8 | AA | 1900
Battery |  | # | Type | Indicated mAh | Measured mAh | % | Pairs
Brand |  | 1 | AAA | 750
Brand |  | 2 | AAA | 750
Brand |  | 3 | AAA | 750
Brand |  | 4 | AAA | 750
Brand |  | 5 | AAA | 750
Brand |  | 6 | AAA | 750
Brand |  | 7 | AAA | 750
Brand |  | 8 | AAA | 750
Spreadsheet: 794476d1662064083-need-help-is-it-possible-to-add-a-formula-to-a-pivot-table-sample-data
Sheet: Sheet2

Project Number | Name | Percentage |  |  |  | Row Labels | Sum of Percentage
111 | [NAME] | 20 |  |  |  | Ana | 60 | 100
123 | [NAME] | 10 |  |  |  | [NAME] | 30 | 30
214 | [NAME] | 10 |  |  |  | [NAME] | 20 | 20
915 | [NAME] | 10 |  |  |  | [NAME] | 60 | 60
852 | [NAME] | 30 |  |  |  | [NAME] | 50 | 90
741 | Ana | 40 |  |  |  | [NAME] | 30 | 30
159 | [NAME] | 20
456 | [NAME] | 20
789 | [NAME] | 20
321 | [NAME] | 10
147 | [NAME] | 30
258 | Ana | 20
369 | [NAME] | 10
Spreadsheet: 37801d1235829317-how-do-i-link-cell-contents-across-worksheets-example
Sheet: PC TWO

 | LAST REVIEWED BY: | MIKE
 | 2009-02-28 00:00:00 | PC NUMBER 2 |  | INTERNAL USE ONLY
 | COMPONENT | [NAME] |  | SUPPLIER | SKU | COST
 | PROCESSOR | INTEL PROCESSOR |  | IM | 1234 | 1
 | MOTHERBOARD | ASUS MOTHERBOARD |  | IM | 514 | 2
 | PROCESSOR COOLING | STANDARD PROCESSOR COOLING |  | X | 561651 | 4
 | PC CHASSIS | BLACK PC CHASSIS |  | EN | 51 | 5
 | RAM MEMORY | 2GB RAM MEMORY |  | EN | 51 | 6
 | HARD DRIVE | 160G HARD DRIVE |  | IM | 5185 | 7
 | GRAPHICS | ONBOARD GRAPHICS |  | X | 1851 | 8
 | WIRELESS | INBUILT WIRELESS |  | X | 651 | 9
 | ADDITIONAL PORTS | ADDITIONAL PORTS |  | X | 891 | 10
 | OPERATING SYSTEM | VISTA OPERATING SYSTEM |  | IM | 65 | 11
 | DISPLAY | 19-INCH DISPLAY |  | EN | 89 | 12
 | OPTICAL DRIVE 1 | DVD-RWWRITER |  | IM | 156 | 13
 | OPTICAL DRIVE 2 | DVD-RWWRITER |  |  | 418 | 14
 | 3.5" FLOPPY DRIVE | 3.5" FLOPPY DRIVE |  | X | 18 | 15
 | DIGITAL CARD READER | 20-IN-1 DIGITAL CARD READER |  | EN | 16518 | 16
 | SOUND CARD | ONBOARD SOUND CARD |  | X | 1 | 17
 | POWER SUPPLY | 500W POWER SUPPLY |  | X | 185 | 18
 | ALL PRICING IS GUARANTEED FOR 7 DAYS FROM THE DATE SHOWN |  |  | X | X | 19
 | TOTAL (INC.VAT) | 750 |  |  | TOTAL COST | 187
 | TOTAL (EXC.VAT) | 652.1739130434784 |  |  | TOTAL COST + VAT | 215.05
 |  |  |  |  | PROFIT | 465.1739130434784
 |  |  |  |  | MARGIN | 71.32666666666667 | %
 |  |  |  |  | SYSPRICE | 652.1739130434783
Spreadsheet: 810847d1672125549-formula-to-establish-unused-components-example
Sheet: Sheet1

Part | Fabricated with | Status col. A | Status col B. | Comments
2003004 | W100378 | INACTIVE | ACTIVE | W100378 can't be deactivated because it is still used to fabricate an active part (2003007)
2003004 | W142008 | INACTIVE | ACTIVE | can be deactivated - only in componence of inactive parts
2003004 | W125085 | INACTIVE | ACTIVE | can be deactivated - only in componence of inactive parts
2003004 | W135023 | INACTIVE | ACTIVE | can be deactivated - only in componence of inactive parts
2003007 | W100378 | ACTIVE | ACTIVE | still in use - can't be deactivated
2003007 | W500603 | ACTIVE | ACTIVE | still in use - can't be deactivated
2003007 | W178314 | ACTIVE | ACTIVE | still in use - can't be deactivated