tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: vkaminski__40901__CASH_EPE_0400MyCopy
Sheet: Sudam

SUDAM TAX CREDITS / INE
Current Year
Calendar Year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals
Months Of Operation
Operating Income
Revenues
Operating Expenses (Fuel, Transportation, O&M)
[NAME] To Cash Adjustment (US$ Based)
[NAME] To Cash Adjustment (R$ Based)
Annual Property Tax
Book Depreciation
Net Operating Income
Financial Income
Interest Income - Partner Loans
Interest Income WCAP & Maintenance Reserve
L/C Fee On Debt Reserve (Following Year)
L/C Fee On Working Capital
L/C YPF Guarantee
[NAME]
Less: Interest Expense - Senior Debt
Less: Interest Expense - Subordinated Debt
Less: IDC To Be Expensed
Less: INE Interest Expense
Net Financial Income
Pre-Tax Book Income
Less: Financial Income In Excess Of Financial Losses
Exploitation Profits
Corporate Income Tax
Exploitation Profits Subject To [NAME] (>0)
Times: Corporate Income Tax
Total Corporate Income Tax Payable
Additional Income Tax
Exploitation Profits Subject To [NAME] (>0)
Less: Amount Not Subject To Add'l Tax
Income Subject To Additional Tax
Times: Additional Income Tax
Total Additional Income Tax
Income Taxes Subject To Sudam Credit
[NAME] %
Sudam Tax Credit Taken *
* Sudam Tax Credit Taken Applied To A Reserve Account (See Trapped Cash Sheet)
INE CALCULATION
Total Equity
Times: Maximum % Allowable
Maximum INE Allowable |  | (a)
Current Year Earnings (EBT)
Times: Current Year Limitation For INE
Current Year EBT Limitation |  | (b)
INE Payable To Shareholders | Min Of a & b (Not<0)
Spreadsheet: 14f277b3-1b63-46ac-9f03-f0e37c1b8987
Sheet: Budget Example

Budget Example
Name:  [NAME]
Organization: North High School
Title of Project: Anti-Idling 101
 |  |  |  |  |  |  | Maximum $5000
Personnel |  |  |  |  |  |  | Total
[NAME] | Per Diem ($100/day x 3 days) |  |  |  |  |  | 300
 | Subtotal:
Professional Development
[NAME] | Tuition for Inquiry Academy Denver Museum of Nature and Science |  |  |  |  |  | 300
 | Subtotal:
Travel (Out of Denver Area Applicants)
 | Mileage
 | Accommodation
 | Food Costs
 | Subtotal:
Equipment
[NAME] | Camera to create PSA for school about idling, create education video clips about idling |  |  |  |  |  | 300
 | Subtotal:
Supplies
[NAME] | Print posters (Anti-idling campaign at school) |  |  |  |  |  | 250
[NAME] | Paper (Letters to congressman, copies of anti-idling policy, fliers, data collection forms) |  |  |  |  |  | 200
[NAME] | 250 Pledge Cards (Teachers, Principals, Parents, Students) |  |  |  |  |  | 150
[NAME] | 200 [NAME] |  |  |  |  |  | 250
[NAME] | Miscellaneous (tri-fold poster boards, pens, pencils, markers) |  |  |  |  |  | 150
 | Subtotal:
Other
 | Subtotal:
 | Total
Spreadsheet: 27319d1220479901-a-few-dropdown-questions-info
Sheet: Sheet1

 |  |  |  |  | Wholesale Application
Please fill out the following information for our records.
 | Business Name
 | Website
 |  |  |  |  |  | Magazine
 | First Name |  |  |  |  | Word of Mouth
 | Last Name |  |  |  |  | Band
 | Role(title) |  |  |  |  | Company
 |  |  |  |  |  | Warped Tour
 | [NAME] |  |  |  |  | Friend
 | Address line 1 |  |  |  |  | Other
 | Address line 2
 | City
 | State
 | Country
 | Bus. Phone #
 | Mobile Phone #
 | Fax
 |  |  |  |  | Business Info
 | Type of business
 | (skate shop, Boutique, etc…)
(Optional) | # of Years in Business
(Optional) | Retail Space
 | (sq ft)
 | Who is your target market?
 | What other clothing lines do you carry?
 | How did you hear of us?
 | If other please specify:
Spreadsheet: 715257d1611642878-how-to-link-value-with-time-slots-excelforumdoc
Sheet: Blad2

Departments |  | Vertegenwoordigers |  |  | Prioriteit |  | Workflows |  | Responsible Workflow |  | New Content |  | Content writer |  | Website adjustments |  | Online Manager
Sales |  | Person A |  |  | High |  | Yes |  | Person X |  | Yes |  | Person Y |  | Yes |  | Person Z
Marketing |  | Person B |  |  | Medium |  | No |  |  |  | No |  |  |  | No
CRM |  | Person C |  |  | Low
Support
Spreadsheet: 861603d1709489531-filter-range-only-if-cells-in-a-range-are-not-empty-excelforum
Sheet: Sheet1

Code | RED | GREEN | Low | Moderate | High |  |  |  |  | Code | RED | GREEN | Low | Moderate | High
CD-1
CD-2 | 3 |  |  |  | 1
CD-3
CD-4 |  |  | 3
CD-5
CD-6
CD-7 |  | 4 | 1 |  | 2
CD-8
CD-9
CD-10
CD-11
CD-12 |  |  | 2 |  | 1
Spreadsheet: 750788d1633631994-add-3-criterias-to-formula-that-will-return-4-different-value-depending-on-the-criterias-example-10_6-1-sumifs
Sheet: Pricing

 |  |  |  | GROUP |  |  | count |  |  | TYPE | TYPE |  |  |  |  |  |  |  |  |  | Co | label
 |  |  |  | a |  |  | 1 |  |  | HSV D | c |  |  |  |  |  |  |  |  |  | Brand |  |  |  |  |  |  |  | 1 | HSV D | Brand | 50764215
 |  |  |  | a |  |  | 2 |  |  | HSV D | c |  |  |  |  |  |  |  |  |  | Brand |  |  |  |  |  |  |  | 2 | HSV D | Brand | 50189535
 |  |  |  | a |  |  | 1 |  |  | HSV P | c |  |  |  |  |  |  |  |  |  | Brand |  |  |  |  |  |  |  | 1 | HSV P | Brand | 50746335
 |  |  |  | a |  |  | 2 |  |  | HSV P | c |  |  |  |  |  |  |  |  |  | Brand |  |  |  |  |  |  |  | 2 | HSV P | Brand | 56506308
Spreadsheet: diana_scholtes__8552__West Contracts Monthly 011402
Sheet: Monthly Totals 2007

Portfolio | Counterparty | Total | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | 2007-07-01 00:00:00 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00
WEST | CITY OF MESA
WEST | ELECTRICDISNUM
WEST | ENRONENESERINC
WEST | LASSEN
WEST | LOUISIANAPACOR
WEST | LUZENACAME
WEST | OAKLANDMUNCORP
WEST | PGE-NG-HEDGE
WEST | REDDING
WEST | SANTACLARA
WESTBANK | ALLEGHENENESUP
WESTBANK | AMERELECPOWSER
WESTBANK | ASHGROCEM
WESTBANK | AVISTAENE
WESTBANK | CORALPOWLLC
WESTBANK | DUKEENETRA
WESTBANK | ELPASOMERLP
WESTBANK | ENRONENESERINC
WESTBANK | EXPRESSPIPPAR
WESTBANK | IDACORPENECOR
WESTBANK | MORGAN
WESTBANK | POWEREXCOR
WESTBANK | PUDSNOHOMISHCTY
WESTBANK | WILLIAMSENEMAR
Spreadsheet: 54903d1254944068-comparing-two-sets-of-data-spelling-and-reading
Sheet: Sheet2

Difference | Difference
-1.92 | -12.17
-0.6300000000000008 | -3.98
-0.32 | -3.57
1.43 | -1.72
-0.5500000000000007 | -3.2
0.379999999999999 | -1.97
0.77 | -1.38
0.27 | -1.88
0.18 | -1.87
1.95 | 0.09999999999999964
2.2 | 0.35
1.38 | -0.370000000000001
1.68 | -0.07000000000000028
1.18 | -0.57
-0.8000000000000007 | -2.55
0.18 | -1.47
-0.9499999999999993 | -2.5
2.15 | 0.6
2.37 | 1.02
1.7 | 0.35
1.38 | 0.129999999999999
1.35 | 0.09999999999999964
1.35 | 0.09999999999999964
1.85 | 0.6
0.35 | -0.9
1.77 | 0.52
0.6 | -0.65
0.6 | -0.65
0.879999999999999 | -0.370000000000001
0.43 | -0.82
-1.33 | -2.58
1.85 | 0.6
1.43 | 0.18
0.85 | -0.4
0.43 | -0.82
-0.8000000000000007 | -2.05
0.35 | -0.8000000000000007
-1.7 | -2.75
2.67 | 1.62
-1.92 | -2.87
-3.2 | -4.15
-4.6 | -5.45
-2.53 | -3.38
0.85 | 0.09999999999999964
1.1 | 0.35
1.1 | 0.35
1.1 | 0.35
-1.25 | -2
-2.62 | -3.37
-1.08 | -1.83
-5.23 | -5.98
-1.33 | -2.08
2.48 | 1.73
-2.5 | -3.25
0.35 | -0.4
0.4699999999999989 | -0.2800000000000011
-1.22 | -1.97
1.18 | 0.43
-0.07000000000000028 | -0.82
-4.52 | -5.17
-2.13 | -2.68
-1.72 | -2.27
1.87 | 1.42
-2.22 | -2.67
-2.55 | -2.9
-1.45 | -1.8
-4.33 | -4.68
-0.7200000000000006 | -1.07
-0.5500000000000007 | -0.9
-0.5500000000000007 | -0.9
-0.8000000000000007 | -1.15
0.1199999999999992 | -0.23
0.1199999999999992 | -0.23
0.27 | 0.01999999999999957
0.35 | 0.09999999999999964
0.35 | 0.09999999999999964
1.52 | 1.27
0.6 | 0.35
-0.5200000000000014 | -0.7700000000000014
-1.05 | -1.3
-0.03000000000000114 | -0.2800000000000011
1.35 | 1.1
0.379999999999999 | 0.129999999999999
-2.25 | -2.5
0.6 | 0.35
-0.32 | -0.57
0.09999999999999964 | -0.15
-2.55 | -2.7
-2.57 | -2.72
-2.3 | -2.45
-2.63 | -2.78
-3.35 | -3.5
1.18 | 1.03
-1.27 | -1.42
-2.83 | -2.88
-0.9499999999999993 | -0.8000000000000007
-1.03 | -0.8800000000000008
-3.03 | -2.88
-1.13 | -0.98
-2.7 | -2.55
-0.1300000000000008 | 0.01999999999999957
-0.32 | -0.07000000000000028
-0.32 | -0.07000000000000028
0.6 | 0.85
0.18 | 0.43
0.6 | 0.85
0.35 | 0.6
-2.92 | -2.67
-4.8 | -4.55
0.43 | 0.68
0.85 | 1.1
0.85 | 1.1
0.6 | 0.9499999999999993
0.6 | 0.9499999999999993
1.38 | 1.73
1.38 | 1.73
-2 | -1.55
-1.75 | -1.3
-3.12 | -2.67
-2.08 | -1.63
-0.7799999999999994 | -0.23
-1.92 | -1.37
-2.78 | -2.13
-0.9700000000000006 | -0.32
-0.3000000000000007 | 0.35
0.9699999999999989 | 1.62
-0.07000000000000028 | 0.68
0.379999999999999 | 1.13
-2.5 | -1.55
-2.05 | -0.9
-0.9300000000000015 | 0.2199999999999989
-0.8000000000000007 | 0.35
-1.98 | -0.6300000000000008
-1.92 | -0.57
-0.07000000000000028 | 1.28
-1.33 | 0.2199999999999989
-1.2 | 0.35
-1.52 | 0.129999999999999
-3.98 | -2.33
-3 | -1.15
-0.6300000000000008 | 1.42
Spreadsheet: 863305d1710847266-vlookup-if-with-conditions-in-two-columns-solar-salaried-employee-list-test
Sheet: ENTRY TAB

Emp No | Employee Full Name | First Name | Last Name | PHONE NUMBER | Hire Date
1001
1036
1037
1068
 |  |  |  | Lookup on A2
 |  |  |  | in WD DROP
 |  |  |  | for work phone#
 |  |  |  | if none, then add
 |  |  |  | personal phone #
Spreadsheet: 179642d1347340827-subtotal-usage-a-and-e-usage-exforum
Sheet: A&E

Store | Item Code | Item Name | Base UOM Code | Stock Weighted Avg Rate | Lowest purchase cost | Qty | Value | [NAME] | Item Type | Batch | [NAME] date | Total usage | Average monthly usage | Qty utilized within 3 months | Qty utilized btw 4-15 months | Qty utilized after 15 months or still in stock | Qty expired, damaged, obsolete | Sum of  Qty | Difference in Qty's | Price at cost | Price discounted @ 50% | Price discounted @ 20% | Price discounted @ zero value | New value
A&E | BPH0053 | [NAME] ZOLL | EA | 123.96 |  | 2 | 247.92 | A&E  D0 CRASH CART | Consumables | n/a
A&E | BPH500011 | PADZ STAT II STANDARD MULTIFUCTION ELECTRODES ADULT  8900-4003 | EA | 580.28 |  | 2 | 1,160.57 | A&E  D0 CRASH CART | Consumables | n/a
A&E | BPH75012 | MASK MANUAL RESUSCITATION SYSTEM BAG ADULT 1.5L,  REF: 7152 | EA | 272.00 |  | 2 | 543.99 | A&E  D0 CRASH CART | Consumables | n/a
Spreadsheet: gstorey__12106__April01
Sheet: table2

NATURAL GAS EXPORTS BY TERM, REGION, AND CUSTOMER TYPE |  |  |  |  |  |  |  |  |  |  |  | TABLE 2
EXPORTATIONS DE GAZ NATUREL PAR TERME, RÉGION, ET CLIENT
 |  |  |  | AVERAGE PRICE |  |  |  |  |  | AVERAGE PRICE
 | VOLUME |  |  | PRIX MOYEN |  |  | VOLUME |  |  | PRIX MOYEN
 | (MILLIONS M3) |  |  | ($CDN/GJ) |  |  | (MILLIONS M3) |  |  | ($CDN/GJ)
 |  |  | % CHANGE |  |  | % CHANGE |  |  | % CHANGE |  |  | % CHANGE
 |  |  | VARIATION |  |  | VARIATION | 1999-11-01 00:00:00 | 2000-11-01 00:00:00 | VARIATION | 1999-11-01 00:00:00 | 2000-11-01 00:00:00 | VARIATION
 | 2000-04-01 00:00:00 | 2001-04-01 00:00:00 | EN % | 2000-04-01 00:00:00 | 2001-04-01 00:00:00 | EN % | 2000-04-01 00:00:00 | 2001-04-01 00:00:00 | EN % | 2000-04-01 00:00:00 | 2001-04-01 00:00:00 | EN %
TERM/TERME
LONG-TERM (FIRM)/LONG TERME (GARANTI) | 2361.1 | 1795.4 | -24 | 3.89 | 6.97 | 79.1 | 13838.8 | 11226.6 | -18.9 | 3.59 | 7.81 | 117.3
SHORT-TERM (FIRM)/COURT TERME (GARANTI) | 3163.7 | 3754.2 | 18.7 | 3.8 | 7.59 | 99.7 | 22314.5 | 26930.5 | 20.7 | 3.38 | 9.13 | 170.1
SHORT-TERM/COURT TERME (INTERRUPTIBLE) | 2116 | 2560.7 | 21 | 3.87 | 8.02 | 107.3 | 13842.1 | 17812.7 | 28.7 | 3.51 | 9.86 | 181.3
TOTAL - TERM/TERME | 7640.8 | 8110.3 | 6.1 | 3.85 | 7.59 | 97.3 | 49995.4 | 55969.9 | 12 | 3.47 | 9.1 | 161.9
REGION/RÉGION
CALIFORNIA/CALIFORNIE | 1384.5 | 1102.6 | -20.4 | 3.68 | 8.89 | 141.8 | 10038.3 | 8627.9 | -14.1 | 3.27 | 10 | 206.2
MIDWEST/MIDWEST | 2883.6 | 3289.9 | 14.1 | 3.62 | 7.46 | 106.1 | 18319 | 21455.7 | 17.1 | 3.3 | 8.69 | 163.7
MOUNTAIN/ROCHEUSES | 67.7 | 29.5 | -56.4 | 3.69 | 4.41 | 19.5 | 498.5 | 209.8 | -57.9 | 3.2 | 6.04 | 88.9
NORTHEAST/NORD-EST | 2269.2 | 2264.4 | -0.2 | 4.35 | 7.43 | 70.9 | 13858.9 | 17214.5 | 24.2 | 3.98 | 8.81 | 121.3
PACIFIC NORTHWEST/NORD-OUEST PACIFIQUE | 1035.8 | 1423.8 | 37.5 | 3.61 | 7.17 | 98.6 | 7280.8 | 8462 | 16.2 | 3.27 | 9.88 | 202
TOTAL - REGION/RÉGION | 7640.8 | 8110.3 | 6.1 | 3.85 | 7.59 | 97.3 | 49995.4 | 55969.9 | 12 | 3.47 | 9.1 | 161.9
CUSTOMER TYPE/CLIENT
END-USER/UTILISATEURS ULTIMES | 635 | 695.6 | 9.6 | 4 | 5.96 | 49 | 3990.6 | 3744.2 | -6.2 | 3.84 | 6.63 | 72.9
LDC/SDL | 2069.6 | 1513.8 | -26.9 | 3.96 | 7.53 | 90.2 | 13224.2 | 11633.4 | -12 | 3.56 | 8.78 | 147
MARKETING CO./DISTRIBUTEURS | 4732.1 | 5617.8 | 18.7 | 3.81 | 7.87 | 106.5 | 31078.6 | 38326.7 | 23.3 | 3.42 | 9.55 | 179
PIPELINE/PIPELINES | 204.1 | 283.1 | 38.7 | 3.03 | 6.22 | 104.9 | 1702 | 2265.6 | 33.1 | 2.95 | 7.2 | 144.3
TOTAL - CUSTOMER TYPE/CLIENT | 7640.8 | 8110.3 | 6.1 | 3.85 | 7.59 | 97.28 | 49995.4 | 55969.9 | 12 | 3.47 | 9.1 | 161.9
 | PRICE AT THE INTERNATIONAL BORDER |  |  |  |  |  |  | À LA FRONTIÈRE INTERNATIONALE
Spreadsheet: 209651d1359149167-worksheet-doesnt-cover-entire-page-ck-nursery-and-finish-inventories
Sheet: Finish Master Sheet

CIRCLE K FAMILY FARMS LLC
FINISHING BARNS
WEEKLY MORTALITY AND SALES SUMMARY
GROWER |  | START | START |  |  |  | MORTALITY |  | SALES AND TRANSFERS |  | ENDING COUNT |  |  | FINAL
# & NAME | FLOCK # | DATE | COUNT | SUBJECTS |  | TOTAL |  |  |  |  |  |  | TOTAL | [NAME] %
 |  |  |  |  | Two weeks
911 | 91128 | 2011-08-16 00:00:00 | 1781 | 66 | from | 0 |  | 0 |  | 0
JP Clover |  |  |  |  | close date
921 | 92101 A | 2012-01-02 00:00:00 | 1997 | 0 |  | 1997 |  | 0 |  | 0
Schug |  |  |  |  |  | NEW
931 | 93123 | 2011-08-09 00:00:00 | 352 | 5 |  | 0 |  | 0 |  | 0
[NAME]
941 | 94137 | 2011-11-01 00:00:00 | 987 | 37 |  | 980 |  | -1 |  | 0
Suburban Farms 1
942 | 94237 | 2011-10-25 00:00:00 | 984 | 41 |  | 971 |  | 0 |  | 0
Suburban Farms 2
943 | 94336 | 2011-10-25 00:00:00 | 986 | 38 |  | 970 |  | 0 |  | 0
Suburban Farms 3
944 | 94436 | 2011-10-18 00:00:00 | 1025 | 21 |  | 1014 |  | -2 |  | 0
[NAME] 4
951 | 95103 | 2011-10-03 00:00:00 | 1292 | 0 |  | 1256 |  | 0 |  | 0
Grabbe 1
952 | 95203 | 2011-10-04 00:00:00 | 733 | 0 |  | 715 |  | 0 |  | 0
Grabbe 2
953 | 95303 | 2011-10-10 00:00:00 | 1675 | 0 |  | 1637 |  | 0 |  | 0
Grabbe 3
971 | 97103 | 2011-09-26 00:00:00 | 589 | 16 |  | 571 |  | 0 |  | -178
Ostler Farms
981 | 98131 | 2011-12-06 00:00:00 | 425 | 25 |  | 422 |  | -2 |  | 0
[NAME]
982 | 98231 | 2011-12-06 00:00:00 | 1438 | 56 |  | 1427 |  | -6 |  | 0
[NAME]
983 | 98331 | 2011-12-13 00:00:00 | 972 | 24 |  | 968 |  | -3 |  | 0
[NAME] 3
991 | 99102 | 2011-11-07 00:00:00 | 1006 | 19 |  | 1000 |  | -1 |  | 0
[NAME] 1
992 | 99201 | 2011-09-07 00:00:00 | 1151 | 29 |  | 235 |  | -2 |  | 0
[NAME] 2
531 | 53113 | 2011-07-26 00:00:00 | 1479 | 19 |  | 0 |  | 0 |  | 0
[NAME]
551 | 55110 | 2011-12-19 00:00:00 | 1369 | 31 |  | 1369 |  | -10 |  | 0
Dr. [NAME]
552 | 55210 A | 2011-12-26 00:00:00 | 1000 | 0 | LV DEDUCT | 1000 |  | -4 |  | 0
Dr. [NAME]
 |  |  |  |  | Two weeks
571 | 57108 | 2011-09-13 00:00:00 | 944 | 5 | from | 558 |  | 0 |  | 0
Lothschutz |  |  |  |  | close date
581 | 58108 | 2011-09-05 00:00:00 | 1225 | 13 |  | 478 |  | 0 |  | -257
Sparks
 |  |  |  |  |  |  |  |  |  |  |  |  | CLOSED
582 | 58204 | 2011-08-23 00:00:00 | 1230 | 14 |  | 114 |  | 0 |  | -114
Sparks 2 |  |  |  |  |  |  |  |  |  |  |  |  | 01-04-12
231 | 23116 | 2011-11-08 00:00:00 | 976 | 45 |  | 971 |  | 0 |  | 0
[NAME] 1
232 | 23216 | 2011-11-14 00:00:00 | 992 | 32 |  | 987 |  | 0 |  | 0
[NAME]
233 | 23316 | 2011-11-22 00:00:00 | 1008 | 14 |  | 1006 |  | 0 |  | 0
[NAME] 3
234 | 23416 | 2011-11-25 00:00:00 | 981 | 43 |  | 970 |  | 0 |  | 0
[NAME] 4
261 | 26115 | 2011-09-20 00:00:00 | 1010 | 15 |  | 987 |  | -3 |  | 0
[NAME]
271 | 27115 | 2011-09-27 00:00:00 | 991 | 32 |  | 975 |  | -5 |  | 0
[NAME]
A - | Finish Lot 92101 - Schug
 | PI 3275 - 01/02/12 - 497 head
 | PI 3315 - 01/02/12 - 500 head
 | PI 3274 - 01/03/12 - 500 head
 | PI 3317 - 01/03/12 - 284 head |  |  |  |  |  | MORTALITY |  | SALES & TRANSFERS OUT |  | REMAINING INVENTORY
 | PI 3316 - 01/03/12 - 216 head |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  | WEEKLY TOTALS
Spreadsheet: 79570d1279805445-excel-2007-if-function-in-correct-way-book12
Sheet: Sheet1

M10990A
M10990B
M10991A
M10993
M10993B
M11004
S1000
S1001
S
M258
M10990A
Spreadsheet: 292140d1390499693-duplicate-rows-and-sum-totals-sample
Sheet: Sheet1

PN | [NAME] | QTY_ORDERED | UNIT_PRICE | TOTAL | % OF SALES
41050-15 | [NAME] | 1 | 300000 | 300000 | 0.01034144589417332
41050-16 | RIGHT MAIN LANDING GEAR | 1 | 300000 | 300000 | 0.01034144589417332
3800298-1 | APU 331-200 (ER) | 1 | 175000 | 175000 | 0.006032510104934435
3800298-1-2 | APU | 1 | 159900 | 159900 | 0.005511990661594378
41050-15 | [NAME] | 1 | 150000 | 150000 | 0.005170722947086659
41050-16 | RIGHT MAIN LANDING GEAR | 1 | 150000 | 150000 | 0.005170722947086659
3800514-2 | APU | 1 | 125000 | 125000 | 0.004308935789238882
3800298-1-3 | APU | 1 | 120000 | 120000 | 0.004136578357669327
LJ50678 | NOSE COWL-RB211-535E4 | 1 | 117000 | 117000 | 0.004033163898727593
Spreadsheet: 106171d1303371641-matching-a-data-from-two-tables-within-a-worksheet-kopie-von-mappe1
Sheet: Tabelle2

INDEX | DATE | Stock Price
ABC | 2010-01-02 00:00:00 | 10
ABC | 2010-01-03 00:00:00 | 20
ABC | 2010-01-04 00:00:00 | 30
ABC | 2010-01-05 00:00:00 | 40
ABC | 2010-01-06 00:00:00 | 50
ABC | 2010-01-09 00:00:00 | 60
ABC | 2010-01-10 00:00:00 | 70
ABC | 2010-01-11 00:00:00 | 80
ABC | 2010-01-12 00:00:00 | 90
ABC | 2010-01-13 00:00:00 | 100
ABC | 2010-01-16 00:00:00 | 110
ABC | 2010-01-20 00:00:00 | 120
ABC | 2010-01-24 00:00:00 | 140
ABC | 2010-01-25 00:00:00 | 15
ABC | 2010-01-26 00:00:00 | 20
ABC | 2010-01-27 00:00:00 | 30
ABC | 2010-01-30 00:00:00 | 40
ABC | 2010-01-31 00:00:00 | 50
DEF | 2010-01-02 00:00:00 | 5
DEF | 2010-01-03 00:00:00 | 8
DEF | 2010-01-04 00:00:00 | 10
DEF | 2010-01-05 00:00:00 | 20
DEF | 2010-01-06 00:00:00 | 50
DEF | 2010-01-09 00:00:00 | 32
DEF | 2010-01-10 00:00:00 | 60
DEF | 2010-01-11 00:00:00 | 14
DEF | 2010-01-12 00:00:00 | 20
DEF | 2010-01-13 00:00:00 | 22
DEF | 2010-01-16 00:00:00 | 52
DEF | 2010-01-20 00:00:00 | 88
DEF | 2010-01-24 00:00:00 | 20
DEF | 2010-01-25 00:00:00 | 30
DEF | 2010-01-26 00:00:00 | 12
DEF | 2010-01-27 00:00:00 | 10
DEF | 2010-01-30 00:00:00 | 5
DEF | 2010-01-31 00:00:00 | 15
GHI | 2010-01-02 00:00:00 | 10
GHI | 2010-01-03 00:00:00 | 20
GHI | 2010-01-04 00:00:00 | 30
GHI | 2010-01-05 00:00:00 | 40
GHI | 2010-01-06 00:00:00 | 50
GHI | 2010-01-09 00:00:00 | 60
GHI | 2010-01-10 00:00:00 | 70
GHI | 2010-01-11 00:00:00 | 80
GHI | 2010-01-12 00:00:00 | 90
GHI | 2010-01-13 00:00:00 | 100
GHI | 2010-01-16 00:00:00 | 110
GHI | 2010-01-20 00:00:00 | 120
GHI | 2010-01-24 00:00:00 | 140
GHI | 2010-01-25 00:00:00 | 15
GHI | 2010-01-26 00:00:00 | 20
GHI | 2010-01-27 00:00:00 | 30
GHI | 2010-01-30 00:00:00 | 40
GHI | 2010-01-31 00:00:00 | 50
Spreadsheet: 130952d1322668318-excel-2007-sumifs-problem-contract-and-changes
Sheet: Sheet1

 |  |  |  |  |  | A = | APPROVED
 |  |  |  |  |  | O = | OPEN
 |  |  |  |  |  | P = | PENDING
 |  |  |  |  |  | T = | T&M EXTRA
 |  |  |  |  |  | V = | VOIDED
CHANGE | HOURS | LABOR | MATERIAL | OTHER | TOTAL | LETTER | STATUS | DATE APPRVD | GC CO # | REMARKS
ORIGINAL PROPOSAL AMOUNT |  |  |  |  | 0 | 0 | APPROVED
Rough-in |  |  |  |  | 0
Lighting Release / Install |  |  |  |  | 0
Switchgear Release / Install |  |  |  |  | 0
Special Material Release / Install |  |  |  |  | 0
Fire Alarm Release / Install |  |  |  |  | 0
Final |  |  |  |  | 0
CONTRACT  AMOUNT |  |  |  |  | 0
1 | 1 | 0 | 0 | 0 | 11 |  | OPEN
0 | 4 | 0 | 0 | 0 | 500 |  | T&M EXTRA
0 | 1 | 0 | 0 | 0 | 13 |  | PENDING
0 | 1 | 0 | 0 | 0 | 21 |  | VOIDED
0 | 6 | 0 | 0 | 0 | 750 |  | APPROVED
 | 6
ALL CHANGE ORDERS TOTAL TO DATE |  |  |  |  | 1295
APPROVED & EXTRAS CHANGE ORDERS TOTAL TO DATE |  |  |  |  | 0
PENDING CHANGE ORDERS TOTAL TO DATE |  |  |  |  | 1295
ORIGINAL CONTRACT AMOUNT |  |  |  |  | 0
NEW CONTRACT AMOUNT |  |  |  |  | 0
Spreadsheet: 204523d1357564665-calculating-angle-to-true-north-126-calculating-angle-to-true-north
Sheet: Sheet1

 | EAST | NORTH
Station | 1450.568 | 2123.589
Target | 1009.554 | 2773.258
Δ EAST
Δ NORTH
Distance:
Bearing (Decimal):
Bearing (DMS):
QUANDRANT BEARINGS
Q1: +E & +N | QB
Q2: +E & -N | 180 - QB
Q3: -E & -N | 180 + QB
[NAME] | 360 - QB
Spreadsheet: 38783d1236922783-sorting-referenced-cells-sample-standings
Sheet: Sheet1

 | Foosbell Standings
 | Player | Rank | Total Points |  |  |  |  |  |  | Results |  | [NAME] | [NAME] | [NAME] | [NAME] | Brent
 | [NAME] | 1 | 13 |  |  |  |  |  |  |  |  | 0 | 7 | 2 | 0 | 3
 | [NAME] | 2 | 22 |  |  |  |  |  |  |  |  | 0 | 5 | 3 | 0 | 2
 | [NAME] | 3 | 14 |  |  |  |  |  |  |  |  | 5 | 3 | 3 | 0 | 2
 | [NAME] | 4 | 4 |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 0 | 1
 | Brent | 5 | 11 |  |  |  |  |  |  |  |  | 2 | 0 | 2 | 4 | 1
 |  |  |  |  |  |  |  |  |  |  |  | 4 | 2 | 1 | 0 | 1
 |  |  |  |  |  |  |  |  |  |  |  | 2 | 5 | 0 | 0 | 1
 | In this example, [NAME] should be at the top of the table, followed by [NAME], then [NAME], then Brent, then [NAME].
 | Results will continue to be added as games are played and I would like the sorting of the total points to be automatic.
 | The pre-determined rank does need to move with the player and points as well.
 | In the end, the table above should look like this:
 | Player | Rank | Total Points
 | [NAME] | 2 | 22
 | [NAME] | 3 | 14
 | [NAME] | 1 | 13
 | Brent | 5 | 11
 | [NAME] | 4 | 4
Spreadsheet: c103dc5a-6ec8-4f8f-8fb8-ff143ea06e90
Sheet: 2012-13 weekly analysis

 |  |  | 2012-13 Soybeans Exports, Weekly Pace Needed to reach forecast |  |  |  |  |  | Cumulative Weekly Inspections:
 |  | Weeks |  | Export Sales |  |  |  |  | Inspections ([NAME]) |  |  |  |  |  | Inspections ([NAME])
 |  | Remaining | Date | Sales Needed to Meet WASDE | Shipments Needed to Meet WASDE | Actual Export Sales | [NAME] | Unshipped | Miss Gulf | 3-yr Ave | PNW | 3-Yr Ave | Total | 3-Yr Ave | Miss Gulf | 3-yr Ave | PNW | 3-Yr Ave | Cumulative Weekly Inspections | 3-Yr Ave
 |  | 52
 |  | 51
 |  | 50
 |  | 49
 |  | 48
 |  | 47
 |  | 46
 |  | 45
 |  | 44
 |  | 43
 |  | 42
 |  | 41
 |  | 40
 |  | 39
 |  | 38
 |  | 37
 |  | 36
 |  | 35
 |  | 34
 |  | 33
 |  | 32
 |  | 31
 |  | 30
 |  | 29
 |  | 28
 |  | 27
 |  | 26
 |  | 25
 |  | 24
 |  | 23
 |  | 22
 |  | 21
 |  | 20
 |  | 19
 |  | 18
 |  | 17
 |  | 16
 |  | 15
 |  | 14
 |  | 13
 |  | 12
 |  | 11
 |  | 10
 |  | 9
 |  | 8
 |  | 7
 |  | 6
 |  | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 1
 |  |  | 2012-13
 |  | as of 12/20/2012 | Weekly pace