tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 117370d1312741724-excel-chart-help-excelforum_787143
Sheet: Stacked Areas

 |  | Influence
 |  | Yes | No
A | 0.44 | 0.25 | 0.75
B | 0.11 | 0 | 1
C | 0.44 | 1 | 0
 |  | Yes | No | Label Yes | Label No | Label ABC | Label Yes | Label No | Label ABC
 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0.25 | 0.75 | 0 | 0 | 0
 | 22 | 0.25 | 0.75 | 0.125 | 0.625 | 1 | 0.25 | 0.75 | A (44%)
 | 44 | 0.25 | 0.75 | 0 | 0 | 0
 | 44 | 0 | 0 | 0 | 0 | 0
 | 44 | 0 | 1 | 0 | 0 | 0
 | 49.5 | 0 | 1 | 0 | 0.5 | 1 | 0 | 1 | B (11%)
 | 55 | 0 | 1 | 0 | 0 | 0
 | 55 | 0 | 0 | 0 | 0 | 0
 | 55 | 1 | 0 | 0 | 0 | 0
 | 77 | 1 | 0 | 0.5 | 1 | 1 | 1 | 0 | C (44%)
 | 99 | 1 | 0 | 0 | 0 | 0
 | 99 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | stacked area chart using yellow range
 |  |  |  |  |  |  | convert X axis to time/date scale
 |  |  |  |  |  |  | change X axis number format to General or Number
 |  |  |  |  |  |  | copy tan range
 |  |  |  |  |  |  | Paste Special, New Series in Columns, Series Names in First Row
 |  |  |  |  |  |  | Change all three new series to line type
 |  |  |  |  |  |  | using [NAME] [NAME] (http://appspro.com)
 |  |  |  |  |  |  | add labels to line series from corresponding green column
 |  |  |  |  |  |  | Use entire shaded column for label range except for top row of text
 |  |  |  |  |  |  | Yes and No: use Center label position
 |  |  |  |  |  |  | ABC: use Above label position
 |  |  |  |  |  |  | change number format of green range to 0%;;; (hide zero values)
 |  |  |  |  |  |  | hide line series (no line, no markers)
 |  |  |  |  |  |  | remove from legend (single click twice on label, then delete)
 |  |  |  |  |  |  | change Y axis maximum to 100%
 |  |  |  |  |  |  | adjust plot area size
Spreadsheet: 87102d1286997836-data-comparison-extraction-indicator_purchases
Sheet: Data Purchases

Item Level 0 | Day | Cost
BARA 002 | 2010-05-25 00:00:00 | 139.75
BARA 002 | 2010-06-17 00:00:00 | 139.75
BARA 002 | 2010-07-19 00:00:00 | 282.75
BARA 007 | 2010-03-09 00:00:00 | 2494.08
BARA 007 | 2010-09-24 00:00:00 | 5015
BARA 009 | 2010-02-17 00:00:00 | 21
BARA 009 | 2010-03-04 00:00:00 | 8.88
BARA 009 | 2010-05-21 00:00:00 | 65
BARA 009 | 2010-09-09 00:00:00 | 97.35
BARA 010 | 2010-02-08 00:00:00 | 45.03
BARA 010 | 2010-02-10 00:00:00 | 43.96
BARA 010 | 2010-03-04 00:00:00 | 24.96
BARA 010 | 2010-04-26 00:00:00 | 159.3
BARA 010 | 2010-05-21 00:00:00 | 87.75
BARA 010 | 2010-08-13 00:00:00 | 31.35
BARA 010 | 2010-09-09 00:00:00 | 197.65
Spreadsheet: 35163d1232689560-sorting-issues-off-season-09
Sheet: The Dutch Oven

Pos | Batters |  | H/AB | R | HR | RBI | SB | BB | K | AVG | OBP | SLG | TLR
BN | [NAME] | (Pit - C,OF) | 137/431 | 71 | 15 | 69 | 2 | 23 | 55 | 0.318 | 0.357 | 0.501
BN | [NAME] | (Bos - 1B) | 110/416 | 74 | 23 | 89 | 1 | 70 | 74 | 0.264 | 0.369 | 0.507
BN | Alexei Ramírez | (CWS - 2B,SS,OF) | 139/480 | 65 | 21 | 77 | 13 | 18 | 61 | 0.29 | 0.317 | 0.475
BN | [NAME] | (Det - 1B,3B) | 180/616 | 85 | 37 | 127 | 1 | 56 | 126 | 0.292 | 0.349 | 0.537
BN | [NAME] | (Cle - SS) | 167/605 | 104 | 23 | 89 | 3 | 48 | 126 | 0.276 | 0.331 | 0.473
BN | Shane Victorino | (Phi - OF) | 167/570 | 102 | 14 | 58 | 36 | 45 | 69 | 0.293 | 0.352 | 0.447
BN | Willy Taveras | (Col - OF) | 120/479 | 64 | 1 | 26 | 68 | 36 | 79 | 0.251 | 0.308 | 0.296
BN | Torii Hunter | (LAA - OF) | 153/551 | 85 | 21 | 78 | 19 | 50 | 108 | 0.278 | 0.344 | 0.466
BN | [NAME] | (NYM - 1B) | 162/598 | 96 | 38 | 115 | 1 | 72 | 124 | 0.271 | 0.353 | 0.518
BN | [NAME] | (Fla - 1B,3B) | 174/628 | 92 | 29 | 95 | 6 | 40 | 111 | 0.277 | 0.327 | 0.481
BN | Yunel Escobar | (Atl - 2B,3B,SS) | 148/514 | 71 | 10 | 60 | 2 | 59 | 62 | 0.288 | 0.366 | 0.401
BN | Chipper Jones | (Atl - 3B) | 160/439 | 82 | 22 | 75 | 4 | 90 | 61 | 0.364 | 0.47 | 0.574
BN | Marcus Thames | (Det - 1B,OF) | 76/316 | 50 | 25 | 56 | 0 | 24 | 95 | 0.241 | 0.292 | 0.516
Pos | Pitchers |  | IP | W | L | SV | BB | K | HLD | ERA | WHIP | K/9 | TLR
SP | Hong-Chih Kuo | (LAD - SP,RP) | 80 | 5 | 3 | 1 | 21 | 96 | 12 | 2.14 | 1.01 | 10.8
SP | [NAME] | (Tor - SP) | 221.1 | 18 | 10 | 0 | 86 | 231 | 0 | 4.07 | 1.34 | 9.39
SP | [NAME] | (Phi - SP) | 227.1 | 14 | 10 | 0 | 53 | 196 | 0 | 3.09 | 1.08 | 7.76
BN | [NAME] | (SD - RP) | 78 | 6 | 6 | 0 | 28 | 71 | 23 | 3.58 | 1.21 | 8.19
BN | [NAME] | (LAA - RP) | 68.1 | 2 | 3 | 62 | 34 | 77 | 0 | 2.24 | 1.29 | 10.14
BN | [NAME] | (LAD - RP) | 47 | 4 | 4 | 18 | 16 | 60 | 0 | 2.49 | 1.19 | 11.49
BN | [NAME] | (Mil - RP) | 80 | 7 | 5 | 28 | 33 | 51 | 5 | 3.49 | 1.35 | 5.74
BN | [NAME] | (Bos - SP) | 167.2 | 18 | 3 | 0 | 94 | 154 | 0 | 2.9 | 1.32 | 8.27
BN | [NAME] | (Atl - SP) | 188.1 | 13 | 10 | 0 | 70 | 139 | 0 | 3.68 | 1.37 | 6.64
DL | [NAME] | (Sea - SP) | 81 | 6 | 4 | 0 | 37 | 72 | 0 | 3.67 | 1.32 | 8
Spreadsheet: 142149d1329688210-summarise-data-from-multiple-sheets-based-on-dates-test-data
Sheet: Summary

Date | reference | problem | Area
2012-02-01 00:00:00 | abc123 | problem a | 1
2012-02-02 00:00:00 | abc124 | [NAME] | 1
2012-02-03 00:00:00 | abc125 | [NAME] | 1
2012-02-04 00:00:00 | abc126 | [NAME] | 1
2012-02-01 00:00:00 | 123abc12 | [NAME] | 2
2012-02-02 00:00:00 | 123abc13 | problem c | 2
2012-02-03 00:00:00 | 123abc14 | problem b | 2
2012-02-04 00:00:00 | 123abc15 | problem b | 2
2012-02-01 00:00:00 | abc657 | [NAME] | 3
2012-02-02 00:00:00 | [NAME] | problem a | 3
2012-02-01 00:00:00 | xyz432 | problem a | 4
2012-02-02 00:00:00 | xyz433 | [NAME] | 4
2012-02-03 00:00:00 | [NAME] | [NAME] | 4
2012-02-04 00:00:00 | xyz435 | [NAME] | 4
2012-02-05 00:00:00 | xyz436 | problem c | 4
2012-02-06 00:00:00 | xyz437 | problem b | 4
2012-02-07 00:00:00 | xyz438 | problem b | 4
Spreadsheet: 780290d1652373984-return-multiple-values-across-many-rows-and-columns-20210302-projects-1-
Sheet: Community Sites

 |  |  | 2019-12-19 00:00:00
 |  | Task | Description | Contract Amount (ex GST) | Percent Complete | Billed To Date | Previously Billed | Current Billed
 |  | 1 | Review of 125 unleased Community Sites and provide viability analysis | 7840 |  |  | 0 | 7840
 |  |  | Project Total
 |  |  |  | Subtotal of This Invoice
 |  |  |  | GST
 |  |  |  | Invoice Total (Including GST)
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Welding Tech Certificates 3

WELDING TECHNOLOGY
Certificates
Students Name:
ID #
[NAME] | Semester | Grade
___ WLD 100 (2) Oxy-Fuel Systems
AND ___ WLD 101 (2) Oxy-Fuel Systems Lab
OR ___ WLD 110 (2) Cutting Procedures
AND ___ WLD 111 (3) Cutting Procedures Lab
___ WLD 120 (2) Shielded Metal Arc Welding (SMAW)
___ WLD 130 (2) Gas Tungsten Arc Welding (GTAW)
___ WLD 140 (2) Gas Metal Arc Welding (GMAW)
___ WLD 170 (2) Blueprint Reading for Welding
___ WLD 171 (3) Blueprint Reading for Welding Lab
___ WLD 220 (2) Welding Certification
___ WLD 221 (3) Welding Certification Lab
___ WLD 227 (3) Shielded Metal Arc Welding (SMAW) Pipe Lab - A
___ WLD 235 (3) Gas Tungsten Arc Welding (GTAW) Pipe Lab - A
___ WLD 245 (3) Gas Metal Arc Welding (GMAW) Pipe Lab - A
Recommended Electives
___ WLD 229 (3) Shielded Metal Arc Welding (SMAW) Pipe Lab - B
___ WLD 237 (3) Gas Tungsten Arc Welding (GTAW) Pipe Lab - B
___ WLD 247 (3) Gas Metal Arc Welding (GMAW) Pipe Lab - B
___ WLD 253 (1) Pipe Fitting and Template Development Lab
AWS National Skills Standards Level I
___ WLD 100 (2) Oxy-Fuel Systems
AND ___ WLD 101 (2) Oxy-Fuel Systems Lab
OR ___ WLD 110 (2) Cutting Procedures
AND ___ WLD 111 (3) Cutting Procedures Lab
___ WLD 120 (2) Shielded Metal Arc Welding (SMAW)
___ WLD 121 (3) Shielded Metal Arc Welding (SMAW) Fillet Lab
___ WLD 123 (3) Shielded Metal Arc Welding (SMAW) Groove with Backing Lab
OR ___ WLD 225 Shielded Metal Arc Welding (SMAW) Open Groove Lab
___ WLD 130 (2) Gas Tungsten Arc Welding (GTAW)
___ WLD 131 (3) Gas Tungsten Arc Welding (GTAW) Fillet Lab
OR ___ WLD 133 (3) Gas Tungsten Arc Welding (GTAW) Groove Lab
___ WLD 140 (2) Gas Metal Arc Welding (GMAW)
___ WLD 141 (3) Gas Metal Arc Welding (GMAW) Fillet Lab
OR ___ WLD 143 (3) Gas Metal Arc Welding (GMAW) Fillet Groove Lab
___ WLD 170 (2) Blueprint Reading for Welding
___ WLD 171 (3) Blueprint Reading for Welding Lab
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: louise_kitchen__22705__ubsplan
Sheet: East - Struct

 | East Power Structuring
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  | % |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  | of Total |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  | Compensation | 0
 | Special Pays
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  |  | [NAME] | 33600
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | [NAME] | 52800
ENARENT | Rent |  |  |  |  |  |  |  | Staff | 54000
ENATECH | Technology |  |  |  |  |  |  |  | Specialist | 63000
ENATRANS | Transportation |  |  |  |  |  |  |  | Sr. Specialist | 78000
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Analyst | 66000
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Associate | 97200
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | Manager | 120000
 |  |  |  |  |  |  |  |  | Director | 156000 | 1
 | Headcount |  |  |  |  |  |  |  | Sr. Director | 180000 |  |  | 1
 |  |  |  |  |  |  |  |  | VP | 216000
 | Analyst & Associate Headcount |  |  |  |  |  |  |  | MD | 240000
 | Total Headcount
 |  |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 524067
 |  |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 880024d1727642943-calculating-overtime-and-general-hours-hours-calculator
Sheet: Data

TIME & HALF | X | 1.5
DOUBLE TIME | X | 2
 |  |  | MON - FRI
 |  |  | AFTER | 7.5 | HRS
 |  |  | FIRST | 2 | HRS | X | 1.5
 |  |  | AFTER | 2 | HRS | X | 2
 |  |  | MAX | 11.5 | HRS |  | DAY
 |  |  | SATURDAY
 |  |  | ALL DAY | 7.5 | HRS | X | 1.5
 |  |  | MAX | 11.5 | HRS
 |  |  | SUNDAY
 |  |  | ALL DAY | 7.5 | HRS | X | 2
 |  |  | MAX | 11.5 | HRS
Spreadsheet: 488391d1478635853-transfer-data-from-one-spreadsheet-to-another-but-other-has-different-layout-copy-of-sample-help-1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Estate Agency Tracker |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Practice 1
 |  | Agency Name | Address | Telephone Website | Website URL | No. Branches | Quartile | ValPal | CRM | Web Design |  |  |  |  |  |  | Practice 2
1
Spreadsheet: 484849d1476489234-meal-plan-to-return-fat-protein-etc-mealplanning
Sheet: Dishes

 | MAIN/SIDE | DISH | SERVES | RECIPE LINK | Protein | Carbs | Fat
 | Main | [NAME] | 2
 | Main | Soft [NAME] (Half) | 2
 | Main | Spaghetti Bolognese | 2
 | Main | Chicken Provencal | 2
 | Main | Chicken & Chorizo Jambalaya | 2 | Chicken & Chroizo Jambalaya
 | Main | Mexican [NAME] | 2 | Mexican [NAME]
 | Side | Baked Potato | 1
 | Side | Quinoa | 1
 | Side | Chips | 1
 | Side | Salad | 1
 | Side | [NAME] | 1
 | Main | Meatballs Macaroni | 2 | Meatball mac
Spreadsheet: 772672d1647430134-dax-to-create-measure-to-find-previous-date-to-last-cost-by-date-previous-day-cost-to-last-cost-dax
Sheet: Sheet1

Pivot Table |  |  |  |  |  |  | Data Table |  |  |  |  | Names Table |  | Calendar Tabe
MMM-YYYY | Feb-2022 |  |  |  |  |  | Date | Name | Quantity | Cost |  | Name |  | Calendar Table is ceated in Data Model
Name | A |  |  |  |  |  | 2022-02-01 00:00:00 | A | 1 | 300 |  | A
 |  |  |  |  | Desired |  | 2022-02-03 00:00:00 | B | 2 | 300 |  | B
Date | Sum of Quantity | [NAME] of Cost | Sum of Cost | LastCost | Previos Day Last Cost |  | 2022-02-05 00:00:00 | A | 3 | 250 |  | C
2022-02-01 00:00:00 | 1 | 300 | 300 | 300 | 300 |  | 2022-02-06 00:00:00 | A | 5
2022-02-02 00:00:00 | 0 | 0 | 0 | 300 | 300 |  | 2022-02-08 00:00:00 | B | 4 | 120
2022-02-03 00:00:00 | 0 | 0 | 0 | 300 | 300 |  | 2022-02-10 00:00:00 | A | 3 | 287
2022-02-04 00:00:00 | 0 | 0 | 0 | 300 | 300 |  | 2022-02-11 00:00:00 | A | 2
2022-02-05 00:00:00 | 3 | 250 | 250 | 250 | 300 |  | 2022-02-12 00:00:00 | B | 3
2022-02-06 00:00:00 | 5 | 0 | 0 | 250 | 250
2022-02-07 00:00:00 | 0 | 0 | 0 | 250 | 250
2022-02-08 00:00:00 | 0 | 0 | 0 | 250 | 250
2022-02-09 00:00:00 | 0 | 0 | 0 | 250 | 250
2022-02-10 00:00:00 | 3 | 287 | 287 | 287 | 250
2022-02-11 00:00:00 | 2 | 0 | 0 | 287 | 287
2022-02-12 00:00:00 | 0 | 0 | 0 | 287 | 287
2022-02-13 00:00:00 | 0 | 0 | 0 | 287 | 287
2022-02-14 00:00:00 | 0 | 0 | 0 | 287 | 287
2022-02-15 00:00:00 | 0 | 0 | 0 | 287 | 287
2022-02-16 00:00:00 | 0 | 0 | 0 | 287 | 287
2022-02-17 00:00:00 | 0 | 0 | 0 | 287 | 287
2022-02-18 00:00:00 | 0 | 0 | 0 | 287 | 287
2022-02-19 00:00:00 | 0 | 0 | 0 | 287 | 287
2022-02-20 00:00:00 | 0 | 0 | 0 | 287 | 287
2022-02-21 00:00:00 | 0 | 0 | 0 | 287 | 287
2022-02-22 00:00:00 | 0 | 0 | 0 | 287 | 287
2022-02-23 00:00:00 | 0 | 0 | 0 | 287 | 287
2022-02-24 00:00:00 | 0 | 0 | 0 | 287 | 287
2022-02-25 00:00:00 | 0 | 0 | 0 | 287 | 287
2022-02-26 00:00:00 | 0 | 0 | 0 | 287 | 287
2022-02-27 00:00:00 | 0 | 0 | 0 | 287 | 287
2022-02-28 00:00:00 | 0 | 0 | 0 | 287 | 287
Spreadsheet: 829408d1684202976-power-query-custom-column-populating-using-worksheet-names-pq-append
Sheet: ARIZONA

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
OHIO
Customer # | Time & Purchase Date | Name | Gender | DOB | Units | Price per Unit ($) | Total Price ($)
1 | 1151|16 Aug 2013 | [NAME] | Male | 32275 | 50 | 1 | 50
2 | 1119|27 Nov 2002 | [NAME] | Male | 36293 | 79.0357142857143 | 1.05 | 30.08
3 | 1758|18 Nov 2014 | [NAME] | Male | 33743 | 78.7857142857143 | 1.02 | 35.839
4 | 1634|8 Oct 2005 | Jackson Reed | Male | 32275 | 46.6 | 1.137 | 55.591
5 | 2134|8 Oct 2019 | [NAME] | Male | 36293 | 51.4 | 1.122 | 59.454
6 | 1527|20 Sep 2015 | [NAME] | Male | 36293 | 56.2 | 1.107 | 63.317
7 | 1756|14 Sep 2013 | Jackson Reed | Male | 33743 | 61 | 1.092 | 67.18
8 | 1122|18 Jan 2009 | [NAME] | Male | 32275 | 65.8 | 1.077 | 71.043
9 | 1222|13 July 2008 | [NAME] | Male | 36293 | 71 | 1.11 | 78.81
10 | 2122|28 Apr 2023 | Jackson Reed | Male | 36659 | 75 | 1.01 | 75.75
11 | 1542|19 July 2000 | [NAME] | Male | 36660 | 80 | 0.98 | 78.4
12 | 1603|6 Oct 2008 | [NAME] | Male | 36661 | 85 | 1.04 | 88.4
13 | 1213|10 Oct 2019 | [NAME] | Male | 32644 | 90 | 1.02 | 91.8
Spreadsheet: andy_zipper__642__NYMEX Straddles
Sheet: Sheet1

 |  |  | Natural Gas Straddles
 | Month | Strke | Bid | Offer | Volatility | Net Change
 | Z | 280 | 26.5 | 27 | 0.8750000000000082 | -0.0326999999999964
 | F | 295 | 64 | 66 | 0.8793999999999934 | 0.008699999999999042
 | G | 300 | 84.5 | 85 | 0.8180999999999925 | 0.008399999999999075
 | H | 300 | 87.5 | 89 | 0.7303999999999945 | 0.01649999999999818
 | J | 295 | 80 | 83 | 0.6111999999999916 | -0.005099999999999438
 | K | 300 | 83 | 87 | 0.5641499999999907 | -0.005099999999999438 |  |  | Z/H | 291.6666666666667 | 58.83333333333334
 | M | 305 | 88 | 94 | 0.5466999999999905 | -0.004499999999999504 |  |  | J/V | 307.1428571428572 | 97.71428571428571
 | N | 310 | 94 | 101 | 0.5363999999999757 | -0.01709999999999812
 | Q | 315 | 100 | 108 | 0.5322499999999767 | -0.01049999999999884
 | U | 310 | 105 | 112 | 0.5322499999999767 | -0.01379999999999848
 | V | 315 | 114 | 119 | 0.5346499999999764 | -0.02069999999999772
 | X | 335 | 127 | 131 | 0.5374999999999761 | -0.005999999999999339
 | [NAME] | 360 | 139 | 146 | 0.5371999999999761 | 0
 | H03 | 350 | 145 | 150
 |  |  | 2001-11-21 14:35:05.320000
 |  |  | Crude Oil Straddles
 | Month | Strke | Bid | Offer | Volatility | Net Change
 | F | 1900 | 246 | 252 | 0.6579999999999824 | -0.04259999999999531
 | G | 1900 | 340 | 355 | 0.5820999999999916 | -0.01919999999999789
 | H | 1950 | 410 | 425 | 0.5637999999999918 | -0.01079999999999881
 | J | 1950 | 455 | 470 | 0.5399999999999923 | -0.007199999999999207
 | K | 1950 | 510 | 515 | 0.5289999999999909 | 0.01379999999999848
 | M | 1950 | 520 | 535 | 0.4985999999999927 | 0.00344999999999962
 | N | 2000 | 530 | 550 | 0.4643499999999938 | -0.009599999999998943
 | Q | 2000 | 535 | 555 | 0.4383999999999946 | -0.01169999999999871
 | U | 2000 | 540 | 560 | 0.4190999999999955 | -0.008399999999999075
 | V | 2000 | 550 | 575 | #[NAME]! | #[NAME]!
 | X | 2000 | 555 | 580 | #[NAME]! | #[NAME]!
 | Z | 2000 | 560 | 585 | 0.3149999999999936 | 0
 | F03 | 2050 |  |  | -0.05500000000000717 | 0
 |  |  | 2001-11-21 14:45:00.860000
Spreadsheet: mary_fischer__25634__31Q
Sheet: E11.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  031Q
COMPANY NAME    Limbach Constructors
ANALYSIS OF OTHER CURRENT LIABILITIES
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-11
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Other Current Liabilities
(must tie to Hyperion account 655) | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Income Accts:  DR/(CR)
Reverse signs from Hyperion
Spreadsheet: 307252d1395880341-sumif-on-filtered-list-need-sumif-on-filtered-list
Sheet: Sheet1

 |  | [NAME]
 |  | Exp
Project | Category | [NAME] vs Exp | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00
1 | T&M | [NAME] | 100 | 150 | 262.5 | 0 | 0 | 0
1 | T&M | Exp | 20 | 30 | 52.5 | 100 | 100 | 100
1 | Fixed | [NAME] | 500 | 750 | 1312.5 | 1300 | 1000 | 0 | 0 | 0
1 | Fixed | Exp | 50 | 75 | 131.25 | 75 | 100 | 500 | 250 | 100
2 | T&M | [NAME] | 750 | 1125 | 1968.75 | 0 | 2000 |  |  | 500
2 | T&M | Exp | 100 | 150 | 262.5 | 500 | 200 |  |  | 100
3 | T&M | [NAME] | 400 | 600 | 1050
3 | T&M | Exp | 40 | 60 | 105
3 | Fixed | [NAME] | 0 | 0 | 0 |  | 1000 |  |  | 1000 |  |  |  | 1000
3 | Fixed | Exp | 500 | 500 | 875 |  | 100 |  |  | 100 |  |  |  | 100
4 | T&M | [NAME] | 50 | 50 | 87.5
4 | T&M | Exp | 50 | 50 | 87.5
5 | T&M | [NAME] |  | 0 | 0 |  | 400 | 400
5 | T&M | Exp |  | 700 | 1225 |  | 40 | 40
4 | Fixed | [NAME] |  |  |  | 1312.5 |  |  | 1312.5 |  |  | 1312.5
4 | Fixed | Exp |  |  |  | 131.25 |  |  | 131.25 |  |  | 131.25
Spreadsheet: 121612d1316194130-returning-a-figure-if-the-destination-cell-fits-a-critera-budget-template-sample
Sheet: Sheet1

 | Bank Balances
 | Acc |  | Opening 01/10 |  | Live Balance | Closing 31/10 | [NAME] (-+)
 | Cheque 123456 |  | 1712.57
 | Bills 111111
 | Expenditure - Unscheduled
 | Type |  | Date | Account | Amount | Tax Deductible | % of budget remain
 | Petrol |  | 2011-03-10 00:00:00 | Cheque 123456 | 55 | No
 | Presents |  | 2011-03-10 00:00:00 | Bills 111111 | 78 | No
Spreadsheet: 848983d1699559657-unsure-of-how-to-fix-formula-to-resolve-issue-example-database-problem-1
Sheet: Sheet1

This is 3 Data Columns (Type+Expiry = 1) my sheet im working on currently has over 50 columns heading to the right.
1 |  | 2 |  | 3
Veh Type:  A | Expires after  1 Year | Veh Type:  B | Expires after  1 Year | Veh Type:  C | Expires after  1 Year | Retest
 |  |  |  |  |  |  |  | <- With no Information added it will Return "Veh A" all the time.
 |  |  |  |  |  |  |  | How do I get it so when the are "N/A"s present, they are skipped in the formula, and have the Retest Column show "No" instead of "Veh A"
Veh Type:  A | Expires after  1 Year | Veh Type:  B | Expires after  1 Year | Veh Type:  C | Expires after  1 Year | Retest
2023-11-01 00:00:00 |  |  |  | 2020-01-01 00:00:00 |  |  |  | <- With data, it doesn't skip the "N/A" and Returns "Veh B" not "Veh C"
Veh Type:  A | Expires after  1 Year | Veh Type:  B | Expires after  1 Year | Veh Type:  C | Expires after  1 Year | Retest
2023-11-01 00:00:00 |  | 2022-12-09 00:00:00 |  | 2020-01-01 00:00:00 |  |  |  | <- If dates are in all columns it returns the correct colum. (1st true instance)
Veh Type:  A | Expires after  1 Year | Veh Type:  B | Expires after  1 Year | Veh Type:  C | Expires after  1 Year | Retest
2003-11-09 00:00:00 |  | 2020-12-09 00:00:00 |  | 2020-01-01 00:00:00 |  |  |  | 1st True instance is "Veh A" with all Data in.
Veh Type:  A | Expires after  1 Year | Veh Type:  B | Expires after  1 Year | Veh Type:  C | Expires after  1 Year | Retest
 |  | 2020-12-09 00:00:00 |  | 2020-01-01 00:00:00 |  |  |  | <- What I want it to Return in this instance is "Veh C" as it is OoD for longer.
Veh Type:  A | Expires after  1 Year | Veh Type:  B | Expires after  1 Year | Veh Type:  C | Expires after  1 Year | Retest |  | This is how I want it to work
 |  |  |  |  |  | No | <No formula in this example
Veh Type:  A | Expires after  1 Year | Veh Type:  B | Expires after  1 Year | Veh Type:  C | Expires after  1 Year | Retest
 |  | 2021-11-10 00:00:00 |  | 2022-11-10 00:00:00 |  | Veh B | <No formula in this example
Veh Type:  A | Expires after  1 Year | Veh Type:  B | Expires after  1 Year | Veh Type:  C | Expires after  1 Year | Retest |  | "Veh B" is 1st True instance as you read left to right, but "Veh C" was 1st True instance of going OoD
 |  | 2021-11-10 00:00:00 |  | 2020-10-15 00:00:00 |  | Veh C | <No formula in this example
Spreadsheet: 713317d1610644187-selecting-value-if-not-zero-otherwise-select-another-cell-license-cost-sample
Sheet: Sheet1

Current
Server | Cost | Type | License | VM cost
A1 |  | Standard | 1000 | 500
A2 |  | DC | 5000 | 250
A3 |  | DC | 0 | 400
A4 |  | Standard | 300 | N/A
A5 |  | Standard | 250 | N/A
Want to look like this, so if VM Cost column is greater than 0 place than place that amount in column b. If VM cost is N/A select amount in License column and place in column B.
Server | Cost | Type | License | VM cost
A1 | 500 | Standard | 1000 | 500
A2 | 250 | DC | 5000 | 250
A3 | 400 | DC | 0 | 400
A4 | 300 | Standard | 300 | N/A
A5 | 250 | Standard | 250 | N/A
Spreadsheet: 0aff6d69-e6f4-4cd5-bb4f-dd41387b8af0
Sheet: Balance Sheet

Lockheed [NAME]
Consolidated Balance Sheets
(unaudited; in millions, except par value)
 |  | June 30, 2013 |  | Dec. 31, 2012
Assets
Current assets
Cash and cash equivalents |  | 2845 |  | 1898
Receivables, net |  | 6826 |  | 6563
Inventories, net |  | 2895 |  | 2937
Deferred income taxes |  | 1233 |  | 1269
Other current assets |  | 580 |  | 1188
Total current assets |  | 14379 |  | 13855
Property, plant, and equipment, net |  | 4594 |  | 4675
Goodwill |  | 10352 |  | 10370
Deferred income taxes |  | 4681 |  | 4809
Other noncurrent assets |  |  |  | 4948
Total assets |  | 38947 |  | 38657
Liabilities and stockholders' equity
Current liabilities
Accounts payable |  | 2044 |  | 2038
Customer advances and amounts in excess of costs incurred |  | 6383 |  | 6503
Salaries, benefits, and payroll taxes |  | 1688 |  | 1649
Current portion of long-term debt |  | 0 |  | 150
Other current liabilities |  | 2138 |  | 1815
Total current liabilities |  | 12253 |  | 12155
Accrued pension liabilities |  | 14766 |  | 15278
Other postretirement benefit liabilities |  | 1219 |  | 1220
Long-term debt, net |  | 6140 |  | 6158
Other noncurrent liabilities |  | 3875 |  | 3807
Total liabilities |  | 38253 |  | 38618
Stockholders' equity
Common stock, $1 par value per share |  | 319 |  | 321
Additional paid-in capital |  | 0 |  | 0
Retained earnings |  | 13416 |  | 13211
Accumulated other comprehensive loss |  | -13041 |  | -13493
Total stockholders' equity |  | 694 |  | 39
Total liabilities and stockholders' equity |  | 38947 |  | 38657
Spreadsheet: 818383d1676794635-using-up-down-arrow-keys-to-change-cell-numerical-value-scoring
Sheet: Sheet1

TEAM | POINTS |  | # CORRECT | WAGER | NEW TOTAL
A | 20 |  | 5 | 6
B | 18 |  | 4 | 5
C | 17 |  | 4 | 7