tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 80447d1280670126-automatic-updating-sample-workbook-complete-
Sheet: TDA Sheet

 | MRAP Forward Iraq TDA Roll-up
 | HQ Balad |  |  |  | FSR/Instructors |  |  |  | LIBERTY |  |  |  | BALAD |  |  |  | SPEICHER |  |  |  | Tallil |  |  |  | Al Asad |  |  |  | Position Totals
 | RQ | ASGN |  | O/H | REQ | ASGN |  | O/H | RQ | ASGN |  | O/H | RQ | ASGN |  | O/H | RQ | ASGN |  | O/H | RQ | ASGN |  | O/H | RQ | ASGN |  | O/H | RQ | ASGN | O/H | %
JLI HQ Staff | 32
RRAD HQ Staff | 2
USG (Military / GS) | 3 |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  |  | 1 |  |  |  | 1 |  |  |  | 1
JLI |  |  |  |  |  |  |  |  | 13 |  |  |  | 13 |  |  |  | 13 |  |  |  | 9 |  |  |  | 11
RRAD |  |  |  |  |  |  |  |  | 48 |  |  |  | 48 |  |  |  | 48 |  |  |  | 35 |  |  |  | 31
EMA | 2 |  |  |  |  |  |  |  | 3 |  |  |  | 3 |  |  |  | 3 |  |  |  | 3 |  |  |  | 3
Honeywell |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  |  | 1 |  |  |  | 1 |  |  |  | 1
Jacobs | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Rangerland |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Digital Backbone |  |  |  |  | 3
BAE RG33 Upgrade |  |  |  |  | 99
BAE Regional Lead |  |  |  |  | 4
BAE FSR |  |  |  |  | 40
C2OTM (ESP) |  |  |  |  | 8
TVS Regional Lead |  |  |  |  | 4
[NAME] |  |  |  |  | 68
IMG Regional Lead |  |  |  |  | 4
[NAME] |  |  |  |  | 87
FPI FSR |  |  |  |  | 11
TJ FIG Instructor |  |  |  |  | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
Oshkosh |  |  |  |  | 2
BAE Theater Lead | 1
TVS Theater Lead | 1
IMG Theater Lead | 1
FPI Theater Lead | 1
RRAD Totals
Iraq Totals
Site R&R Count
Iraq Totals
Theater Status Totals | Off |  |  | R&R |  | Sick/Qtrs |  |  | TDY* |  |  | [NAME] |  |  | Hospital |  |  | Medical Lv |  |  | [NAME] |  |  | JPO Required |  |  | JPO A/S |  |  | JPO O/H
*TDY= TDY Enroute to R&R, TDY Return for R&R, TDY in Transit (Not Assigned Location)
 |  |  |  |  |  |  |  |  | `
Spreadsheet: 220445d1363168976-sum-using-vlookup-adding-numbers-in-vlookup-ans
Sheet: Sheet2

 | Data |  |  |  |  | Row number column is introduced.
 | [NAME] | No. Customers | Net Sales | Profit / Loss | Row No
 | [NAME] | 6 | 726 | 235.8774 | 4
 | [NAME] | 6 | 714 | 220.983 | 5
 | [NAME] | 7 | 1316 | 427.5684000000001 | 6
 | Jagjit | 7 | 1799 | 708.806 | 7
 | [NAME] | 8 | 1592 | 562.7719999999999 | 8
 | [NAME] | 8 | 1088 | 396.9024 | 9
 | [NAME] | 8 | 1680 | 752.64 | 10
 | [NAME] | 8 | 1624 | 621.3424 | 11
 | [NAME] | 9 | 2133 | 922.7357999999999 | 12
 | Javed | 9 | 2277 | 965.6756999999999 | 13
 | [NAME] | 9 | 2682 | 1023.183 | 14
 | [NAME] | 10 | 1610 | 579.1170000000001 | 15 | Questions | Your Answer
 | [NAME] | 10 | 1540 | 569.8 | 16 | What is the netsales for the persons who had 6 customers? | 1440
 |  |  |  |  |  |  | 1440
 |  |  | 13076 |  |  | For 8 & 9 | 13076
Spreadsheet: 163730d1340433334-select-the-total-best-score-to-summarize-6_max_nl_chart
Sheet: 604

STARTING HAND GUIDE FOR 6-MAX NO-LIMIT
 |  |  |  |  |  |  |  |  | Suited Hands
AA | AK | AQ | AJ | AT | A9 | A8 | A7 | A6 | A5 | A4 | A3 | A2
AK | KK | KQ | KJ | KT | K9 | K8 | K7 | K6 | K5 | K4 | K3 | K2
AQ | KQ | QQ | QJ | QT | Q9 | Q8 | Q7 | Q6 | Q5 | Q4 | Q3 | Q2
AJ | KJ | QJ | JJ | JT | J9 | J8 | J7 | J6 | J5 | J4 | J3 | J2
AT | KT | QT | JT | TT | T9 | T8 | T7 | T6 | T5 | T4 | T3 | T2
A9 | K9 | Q9 | J9 | T9 | 99 | 98 | 97 | 96 | 95 | 94 | 93 | 92
A8 | K8 | Q8 | J8 | T8 | 98 | 88 | 87 | 86 | 85 | 84 | 83 | 82
A7 | K7 | Q7 | J7 | T7 | 97 | 87 | 77 | 76 | 75 | 74 | 73 | 72
A6 | K6 | Q6 | J6 | T6 | 96 | 86 | 76 | 66 | 65 | 64 | 63 | 62
A5 | K5 | Q5 | J5 | T5 | 95 | 85 | 75 | 65 | 55 | 54 | 53 | 52
A4 | K4 | Q4 | J4 | T4 | 94 | 84 | 74 | 64 | 54 | 44 | 43 | 42
A3 | K3 | Q3 | J3 | T3 | 93 | 83 | 73 | 63 | 53 | 43 | 33 | 32
A2 | K2 | Q2 | J2 | T2 | 92 | 82 | 72 | 62 | 52 | 42 | 32 | 22
Off-Suit Hands
PLAYER IS FIRST IN THE POT AND RAISING
NOTES
The chart assumes the player and most opponents at the table have ~100BB stacks
Generally the modifications are to tighten up when Out of Position and loosen up In Position
In most cases when open-raising, ignore a single limper to you when deciding to play a hand*
MODIFICATIONS TO GORDON'S CHART |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Button
Ax, tightened up in most positions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Late |  |  | Small
Axs, tightened up in a couple spots |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Middle |  |  | Big
[NAME], fold in SB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Early
54s open in BUT
98-65, 97, 86 open in BUT
K8 fold OTB
K7, Q7, K6 fold in the SB
77-22 limp in EP
Axs limp in EP and MP |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *For example, EP limps and MP folds.
T7s fold OTB |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Raise with JTs in LP even though it is a "drawing hand."
J7s, Q6s fold
Q7s fold OTB
Spreadsheet: ff96e5b8-6f27-4e88-b765-d7765ea91814
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
BUG | Test | BUG | [NAME] | [NAME] |  |  |  |  |  |  | This test is for Billing Purposes Only.  This is not an orderable test. |  |  |  |  |  |  | 1 | 87168 |  |  |  |  | Rochester
BUG | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 326494d1403179295-concatenate-variable-ranges-of-character-strings-tasasupd_0529upd-1_ron_v1a
Sheet: Sheet8

SERIES | ACCIDENT_ID | SEVERITY | KILLED | INJURED |  | Concatenated | HelperColumn
 |  |  |  |  | <-Blank Row
0 | 111 | PDO | 0 | 0 |  |  | 00
1 | 111 | PDO | 0 | 0 |  |  | 0000
2 | 111 | PDO | 0 | 0 |  | 000000 | 000000
3
4 | 111 | K | 1 | 0 |  |  | 10
5 | 111 | K | 1 | 0 |  |  | 1010
6 | 111 | K | 1 | 0 |  | 101010 | 101010
7
8 | 111 | K | 1 | 1 |  |  | 11
9 | 111 | K | 1 | 0 |  |  | 1110
10 | 111 | I | 0 | 1 |  | 111001 | 111001
11
12 | 111 | PDO | 0 | 0 |  |  | 00
13 | 111 | PDO | 0 | 0 |  |  | 0000
14 | 111 | PDO | 0 | 0 |  | 000000 | 000000
15
16 | 111 | K | 1 | 0 |  |  | 10
17 | 111 | K | 1 | 0 |  |  | 1010
18 | 111 | K | 1 | 0 |  | 101010 | 101010
19
20 | 111 | I | 0 | 1 |  |  | 01
21 | 111 | I | 0 | 1 |  |  | 0101
22 | 111 | I | 0 | 1 |  | 010101 | 010101
23
24 | 111 | K | 1 | 0 |  |  | 10
25 | 111 | I | 0 | 1 |  |  | 1001
26 | 111 | I | 0 | 1 |  | 100101 | 100101
27
28 | 111 | K | 2 | 1 |  |  | 21
29 | 111 | K | 2 | 1 |  |  | 2121
30 | 111 | K | 2 | 1 |  | 212121 | 212121
31
32 | 111 | K | 1 | 3 |  |  | 13
33 | 111 | I | 0 | 1 |  |  | 1301
34 | 111 | I | 0 | 2 |  | 130102 | 130102
35
36 | 111 | K | 1 | 1 |  |  | 11
37 | 111 | K | 1 | 0 |  |  | 1110
38 | 111 | I | 0 | 1 |  | 111001 | 111001
39
40 | 1111 | PDO | 0 | 0 |  |  | 00
41 | 1111 | K | 1 | 0 |  |  | 0010
42 | 1111 | PDO | 0 | 0 |  |  | 001000
42 | 1111 | PDO | 0 | 0 |  | 00100000 | 00100000
42
42 | 1112 | K | 1 | 4 |  |  | 14
42 | 1112 | K | 1 | 4 |  | 1414 | 1414
42
42 | 2222 | I | 0 | 1 |  |  | 01
42 | 2222 | K | 1 | 0 |  |  | 0110
42 | 2222 | I | 0 | 1 |  |  | 011001
42 | 2222 | PDO | 0 | 0 |  | 01100100 | 01100100
42
42 |  |  | 0 | 0 |  |  | 00
Spreadsheet: 769601d1645617607-pulling-through-entire-row-of-data-test-data
Sheet: Financial Tracker

 | Property | Date | Item | Who | Income | Expenditure | Balance | Invoice Filed | Notes
 | 111 | 2021-08-01 00:00:00 | Income | Q | 1000
 | 222 | 2021-08-31 00:00:00 | Income | W | 1000
 | 111 | 2021-08-08 00:00:00 | Expenditure | E |  | 586.03
 | 111 | 2021-09-08 00:00:00 | Expenditure | R |  | 586.03
 | 111 | 2021-09-15 00:00:00 | Expenditure | T |  | 9.99 |  | 2021-01-01 00:00:00
 | 222 | 2021-10-07 00:00:00 | Expenditure | Y |  | 15.3 |  | 2021-02-01 00:00:00
 | 111 | 2021-10-31 00:00:00 | Income | U | 1000
 | 111 | 2021-10-07 00:00:00 | Expenditure | I |  | 586.03
 | 111 | 2021-11-30 00:00:00 | Income | O | 1000
 | 111 | 2021-11-05 00:00:00 | Expenditure | P |  | 35 |  | 2021-03-01 00:00:00
 | 111 | 2021-11-15 00:00:00 | Expenditure | A |  | 75 |  | 2021-04-01 00:00:00
 | 222 | 2021-11-09 00:00:00 | Expenditure | S |  | 586.03
 | 111 | 2021-12-31 00:00:00 | Income | D | 1000
 | 111 | 2021-12-15 00:00:00 | Expenditure | F |  | 49.5 |  | 2021-05-01 00:00:00
 | 111 | 2021-12-08 00:00:00 | Expenditure | G |  | 586.03
 | 111 | 2022-01-31 00:00:00 | Income | H | 1000
 | 111 | 2022-01-04 00:00:00 | Expenditure | J |  | 132 |  | 2021-06-01 00:00:00
 | 111 | 2022-01-28 00:00:00 | Expenditure | K |  | 159
 | 111 | 2022-01-07 00:00:00 | Expenditure | L |  | 586.03
 | 222 | 2022-02-07 00:00:00 | Expenditure | Z |  | 300
 | 111 | 2022-02-09 00:00:00 | Expenditure | X |  | 586.03
 | 111 | 2022-02-16 00:00:00 | Expenditure | C |  | 720 |  | 2021-07-01 00:00:00
Spreadsheet: 32996d1229191950-trying-to-calculate-minutes-using-sumproduct-formula-need-help-please
Sheet: Sheet1

Date | Shift | Tag # | Stacker | Station | Product | Start Time | Finish Time | Total Time | Pcs | Pcs/Min | Samples | Usable | % Usable | Total Pcs
2008-12-12 00:00:00 | A | R35363 | Mazie | 1 | BFS | 06:30:00 | 07:20:00 | 50 | 600 | 12 | 12 | 6 | 0.5 | 1101
2008-12-12 00:00:00 | A | R53623 | Mazie | 1 | BFS | 07:20:00 | 08:00:00 | 40 | 501 | 12.525
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Stacker | Pcs | % of Product | Total Minutes | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Mazie | 1101 | 1 | 0 | #N/A
Spreadsheet: 833798d1687260967-vlookup-2-columns-to-get-result-vlookup-twice
Sheet: TotalInvoices

A | B | C | D | Corrected Invoice number | Original Invoice Number | Nature of Supply
1 |  |  |  |  | 8220005 | Invoice
2 |  |  |  |  | 8220006 | Invoice
67318 |  |  |  |  | TLCKA22230008037 | CreditNote
67319 |  |  |  |  | TLCKA22230008037 | Invoice
67320 |  |  |  |  | TLCKA22230008038 | CreditNote |  | When the Invoice number is same, I need to add R to if same row column G = credit note only.
67321 |  |  |  |  | TLCKA22230008038 | Invoice |  | Yellow cells should not contain R in the beginning as per the expected result.
67322 |  |  |  |  | TLCKA22230008039 | CreditNote
67323 |  |  |  |  | TLCKA22230008039 | Invoice
67324 |  |  |  |  | TLCKA22230008043 | CreditNote
67363 |  |  |  |  | TLCKA22230008085 | CreditNote
67364 |  |  |  |  | TLCKA22230008089 | Invoice
67378 |  |  |  |  | TLCKA22230008105 | CreditNote
67379 |  |  |  |  | TLCKA22230008106 | CreditNote
67380 |  |  |  |  | [NAME] | Invoice
67381 |  |  |  |  | TLCKA22230008108 | CreditNote
67382 |  |  |  |  | TLCKA22230008109 | CreditNote
67408 |  |  |  |  | TLCWB22230000049 | CreditNote
67409 |  |  |  |  | [NAME] | Invoice
Spreadsheet: 70859d1271593830-excel-2007-cannot-create-an-index-need-to-plot-house-price-index-against-time-semi_det
Sheet: Z8 semi

Q1 1993 | UK
=100 | Semi detached |  | Detached
 | £ | Index | Price | Index
Q1 2000 | 74453.18307063454 |  | 118060.9552380788
Q2 2000 | 77875.65693564253 |  | 123621.6425906421
Q3 2000 | 77966.58766160677 |  | 124406.1399844413
Q4 2000 | 78510.5591485561 |  | 125179.9244529048
Q1 2001 | 80703.51971160132 |  | 128399.782139408
Q2 2001 | 83987.83159398029 |  | 133278.034470142
Q3 2001 | 86771.1757405205 |  | 139001.1352318062
Q4 2001 | 88636.47084322506 |  | 140276.751262177
Q1 2002 | 91041.86396111612 |  | 144128.2042224948
Q2 2002 | 99519.22289642504 |  | 154618.8202652693
Q3 2002 | 105713.2351700371 |  | 165547.1322522272
Q4 2002 | 112060.1787152478 |  | 172019.1959906287
Q1 2003 | 116683.462668963 |  | 175023.6046375302
Q2 2003 | 122329.5821627199 |  | 184171.648278301
Q3 2003 | 126439.5326921305 |  | 188636.801746797
Q4 2003 | 131374.3217001132 |  | 193225.0114999569
Q1 2004 | 137436.3894200556 |  | 199382.3363120919
Q2 2004 | 147423.4202400902 |  | 209728.383705126
Q3 2004 | 153054.2562133467 |  | 218193.6444718459
Q4 2004 | 153292.7860225751 |  | 217300.5144958363
Q1 2005 | 153549.5412297464 |  | 217293.9153032083
Q2 2005 | 158502.4935192763 |  | 220446.8487863393
Q3 2005 | 157031.8948895595 |  | 221705.2067091941
[NAME] | 155442.636024027 |  | 221248.9775552365
Q1 2006 | 157861.306155429 |  | 221824.5072432027
Q2 2006 | 162929.7057268454 |  | 228610.6947767291
Q3 2006 | 165448.9341391597 |  | 232967.8699647218
Q4 2006 | 168987.7010348212 |  | 236648.5457043054
Q1 2007 | 171738.0785177268 |  | 239626.4076825867
Q2 2007 | 178051.2436530543 |  | 247599.0513336764
Q3 2007 | 180040.6737285113 |  | 251857.4749025856
Q4 2007 | 179213.7483956835 |  | 252407.740181658
Q1 2008 | 174553.5172313316 |  | 246516.4938152502
Q2 2008 | 170254.8638454901 |  | 242398.7996139931
Q3 2008 | 160632.6860609656 |  | 230510.9986143022
Q4 2008 | 152081.2476945007 |  | 220346.2553713158
Q1 2009 | 147173.5438099159 |  | 211595.3699086306
Q2 2009 | 150111.4427760857 |  | 216711.7344877673
Q3 2009 | 156379.8306229521 |  | 225330.4183508655
Q4 2009 | 158374.8102011974 |  | 225625.7822878023
Q1 2010 | 158228.3831201492 |  | 228164.0458593647
Spreadsheet: 678677d1590003464-looking-for-ideas-suggestions-or-just-general-thoughts-my-runs-2020-nuttypriest-
Sheet: The Play-Around Pivot

Week # | (Multiple Items)
Day of Week | Mon
 | Pivot Table
Row Labels | Sum of Run Amt | Count of Tip Amt | Sum of Total | Count of Total2
08:00:00 | 5.04 | 1 | 9.3 | 1
09:00:00 | 4.48 |  | 4.48 | 1
10:00:00 | 5.15 |  | 5.15 | 1
11:00:00 | 2.9 | 1 | 5.9 | 1
12:00:00 | 10.6 | 2 | 20.82 | 2
13:00:00 | 12.37 | 3 | 21.71 | 3
14:00:00 | 13.12 | 2 | 23.28 | 3
15:00:00 | 20.04 | 3 | 33.85 | 4
16:00:00 | 8.61 | 1 | 15.91 | 2
17:00:00 | 12.46 | 3 | 26.95 | 3
18:00:00 | 25.98 | 5 | 45.9 | 6
19:00:00 | 20.68 | 4 | 43.40000000000001 | 4
20:00:00 | 8.86 | 2 | 14.21 | 2
Grand Total | 150.2899999999999 | 27 | 270.86 | 33
Spreadsheet: 090295b2-569b-4101-95c8-ae9cc43eb20f
Sheet: Spring

 | Acad. Year | Class Schedule: First Year |  |  |  |  |  |  | Spring
 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
800 | RC 127 |  | RC 127 |  | RC 125 |  | CLINICAL ROTATIONS      0630 - 1530 |  | CLINICAL ROTATIONS      0630 - 1530
 | # 1885 |  | # 1885 |  | # 1878
900 | Kathy |  | Kathy
 | RC 123 |  | RC 123 |  | Kathy
1000 | # 1883 |  | # 1883
 | Kathy |  | Kathy |  |  | RC 122
1100 | Office Hours | Office Hours | Office Hours | Office Hours | Office Hours | # 1876
 | Kathy | [NAME] | Kathy | [NAME] | Kathy | [NAME]
1200 | RC 121 |  | RC 121 |  | NO CLASSES SCHEDULED AT BCCC
 | # 1884 |  | # 1884
1300 | [NAME] |  | [NAME]
1400 | RC 122                                    # 1875                                                         Ed |  | RC 122                                    # 1876                                                         Ed |  |  | RC 122
 |  |  |  |  |  | # 1875
1500 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Office Hours
1600 |  |  |  |  |  | [NAME]
1700
Spreadsheet: 64918d1265732801-multi-level-bill-of-material-bom-eg
Sheet: Sheet1

Item # | Item Desc. | UofM | Wt | Labor Cost | Fixed OH | Variable OH | Corp OH | Component # | Component Desc. | U of M | QTY/Rate | Scrap % | Cost | [NAME] Costs | New Mat Cost | [NAME] | Is Sub Comp?
93939 | Item 1234 | LB | 24 | 0.22 | 0.4 | 0.3 | 0.1851 | Box 99 | Box 1 | EACH | 0.0417 | 2 | 0.46
93939 | Item 1234 | LB | 24 | 0.22 | 0.4 | 0.3 | 0.1851 | Piece | Raw Mat | LB | -0.1655 | 0 | 0.5155
93939 | Item 1234 | LB | 24 | 0.22 | 0.4 | 0.3 | 0.1851 | FM1 | Pckaging | IMP | 1 | 10 | 0.0299
93939 | Item 1234 | LB | 24 | 0.22 | 0.4 | 0.3 | 0.1851 | FM2 | Packaing 2 | IMP | 1 | 10 | 0.0244
93939 | Item 1234 | LB | 24 | 0.22 | 0.4 | 0.3 | 0.1851 | LB3 | Packaging 3 | EACH | 1 | 7 | 0.0665
93939 | Item 1234 | LB | 24 | 0.22 | 0.4 | 0.3 | 0.1851 | Raw 1 | Mat Treatment | LB | 1 | 19.7 | 0.861
93939 | Item 1234 | LB | 24 | 0.22 | 0.4 | 0.3 | 0.1851 | [NAME] | [NAME] | LB | -0.0498 | 0 | 0.7603
Raw 1 | Raw Steel | LB | 1 | 0.02 | 0 | 0.05 | 0.0605 | Box 6 | [NAME] | EACH | 0.0008 | 0 | 4.227
Raw 1 | Raw Steel | LB | 1 | 0.02 | 0 | 0.05 | 0.0605 | Box 7 | Box Liner | EACH | 0.0025 | 0 | 0.5256000000000001
Raw 1 | Raw Steel | LB | 1 | 0.02 | 0 | 0.05 | 0.0605 | Box 8 | [NAME] | EACH | 0.0008 | 0 | 0.1862
Raw 1 | Raw Steel | LB | 1 | 0.02 | 0 | 0.05 | 0.0605 | Treatment | Steel Treat 3 | LB | 1.031 | 0 | 0.8305
[NAME] | Steel Scrap Credit | LB | 0 | 0 | 0 | 0 | 0 | Scrp4 | Credit for Scrap 6 | LB | 1 | 0 | 0.7603
[NAME] | Steel Scrap Credit | LB | 0 | 0 | 0 | 0 | 0 | Scrp5 | Credit for Scrap 7 | LB | 1 | 0 | 0.6603
 |  |  |  |  |  |  |  |  |  |  |  |  | 1) Cost of Raw Material
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2) Material * Rate / Scrap %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3) Checks to see if it's a subcomponent, and sums the subcomponents for you
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4) Gives you [NAME] Cost with subcomponents added up
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5) tells you if the Item is a sub component
Spreadsheet: 793985d1661842244-formula-to-exclude-data-within-the-dfined-time-range-book3
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Time Range
 |  |  |  |  | Time | Data | Expected Results |  |  | 08:00:00 | 19:00:00
 |  |  | 5 | -1 | 02:05:00
 |  |  | 4 | 1 | 03:15:00
 |  |  | 6 |  | 03:55:00
 |  |  | 8 |  | 04:50:00
 |  |  | 4 |  | 06:50:00
 |  |  | 2 |  | 07:15:00
 |  |  | 12 |  | 08:45:00
 |  |  | 6 |  | 09:45:00
 |  |  | 18 |  | 10:25:00
 |  |  | 20 |  | 11:35:00
 |  |  | 15 |  | 12:15:00
 |  |  | 16 |  | 13:45:00
 |  |  | 12 |  | 14:10:00
 |  |  | 14 |  | 16:50:00
 |  |  | 18 |  | 17:45:00
 |  |  | 22 |  | 18:10:00
 |  |  | 25 |  | 19:35:00
 |  |  | 32 |  | 20:15:00
Spreadsheet: 4547bdc9-d899-42f0-b282-9085d641ac92
Sheet: 17.Historic by Designation

FY 2013 Federal Real Property Charts
Historic Designation Total Assets†*
Historical Status | Number of Assets by Real Property Type
 | Building | Land | Structure | Total
Evaluated, Not Historic | 60587 | 13567 | 90936
National Historic Landmark (NHL) | 2928 | 19 | 1146
National Register Eligible (NRE) | 26747 | 2186 | 11244
National Register Listed (NRL) | 7814 | 286 | 3149
Non-contributing element of NHL/NRL district | 3417 | 13 | 3053
Not Evaluated | 180054 | 166502 | 324527
† All real property data from the CFO Act agencies required to submit data to the FRPP
* Historic Designation is  reported on all owned buildings, structures, and land assets, except those assets that have been evaluated and for which disclosure of historic status is restricted based upon EO 13007 and Section 304 of the National Historic Preservation Act.   Generally, properties eligible for listing in the National Register are at least 50 years old. Properties less than 50 years of age must be exceptionally important to be considered eligible for listing.
Spreadsheet: 491339d1480429146-windows-to-auto-fill-in-cells-test1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Complete
 |  |  |  |  |  |  |  |  |  | Shortages
 | OPERATIVE | PICKSHEET OUT | Date | Time | PICKSHEET IN | Date | Time | URN QTY | MIN PER PICK |  | URN per min | STATUS
Spreadsheet: 681003d1591294002-ratio-formula-help-needed-enrollment-question
Sheet: Enrollment

 | Class | [NAME] | Staff Members Needed |  | Ratios
 | A | 1 |  |  | Size | Staff
 | B | 5 |  |  | 1 | 1
 | C | 6 |  |  | 9 | 2
 | D | 11 |  |  | 19 | 3
 | E | 12
 | F | 16
 | G | 19
 | H | 21
Spreadsheet: 831321d1685548227-calculating-sum-using-multiple-criteria-dummy-data-sum-of-sob-and-yrs
Sheet: FY Act vs. Fcst

 |  |  |  | Driver FTE Analysis - Full Year View
 |  |  |  |  | 22/23 | In cell G7, I would like a formula which looks up the year and column C and returns sum for the year
 |  |  |  |  | Staff on Books C/P |  |  | New Starters |  |  |  |  | Trainees to Garage |  |  | Establishment C/P
EST | TG | SOB |  | Depot |  | Static Fcst | Var vs. Static Fcst | Actual | Rolling Fcst | Static Fcst | [NAME] vs. [NAME] | Var vs. Static Fcst |  |  | Var vs. Static Fcst |  | Static Fcst | Var vs. Static Fcst
1.11 | 1.1 | 1 |  | Barking
2.11 | 2.1 | 2 |  | Bow
3.11 | 3.1 | 3 |  | Leyton
4.11 | 4.1 | 4 |  | Romford
5.11 | 5.1 | 5 |  | West Ham
6.11 | 6.1 | 6 |  | Ash Grove
7.11 | 7.1 | 7 |  | Walthamstow Ave
 |  |  |  | Total - East London
8.11 | 8.1 | 8 |  | Rainham
9.11 | 9.1 | 9 |  | Plumstead
10.11 | 10.1 | 10 |  | Catford
11.11 | 11.1 | 11 |  | [NAME]
12.11 | 12.1 | 12 |  | Bromley
 |  |  |  | Total - SELKENT
13.11 | 13.1 | 13 |  | Lea Interchange
14.11 | 14.1 | 14 |  | City Sightseeing
 |  |  |  | Grand Total
 |  |  |  | Graph showing 'so what'
Spreadsheet: 52134d1251834157-recap-of-aged-accounts-receivable-697940_mcarr5
Sheet: Sheet4

Flag | TotalRow
 | Data
Customer ID | Sum of 0 - 30 | Sum of 31 - 60 | Sum of 61 - 90 | Sum of Over 90 days
280 | 50 | 0 | 850 | 50
282 | 0 | -19.07 | 0 | 0
284 | 0 | 0 | 75 | 50
286 | 50 | 0 | 890 | 50
Grand Total | 100 | -19.07 | 1815 | 150
Spreadsheet: 850d06b8-ed8e-4151-9487-2ca5ac7d614b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: New Residential Construction
 |  | Housing Units Completed: United States
 |  | Seasonally Adjusted Total Units [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: April 16, 2014 (3:56 pm)
Period | Value
Jan-2008
Feb-2008
Mar-2008
Apr-2008
May-2008
Jun-2008
Jul-2008
Aug-2008
Sep-2008
Oct-2008
Nov-2008
Dec-2008
Jan-2009
Feb-2009
Mar-2009
Apr-2009
May-2009
Jun-2009
Jul-2009
Aug-2009
Sep-2009
Oct-2009
Nov-2009
Dec-2009
[NAME]
[NAME]
Mar-2010
Apr-2010
[NAME]
[NAME]
[NAME]
Aug-2010
Sep-2010
Oct-2010
Nov-2010
Dec-2010
Jan-2011
Feb-2011
Mar-2011
Apr-2011
May-2011
Jun-2011
Jul-2011
Aug-2011
Sep-2011
Oct-2011
Nov-2011
Dec-2011
Jan-2012
Feb-2012
Mar-2012
Apr-2012
May-2012
Jun-2012
Jul-2012
Aug-2012
Sep-2012
Oct-2012
Nov-2012
Dec-2012
Spreadsheet: 93940d1293706569-excel-2007-conditional-formatting-758250
Sheet: P VS A

Planned VS Actual
Planned (Fleetwise)
Branch Code | Planned KM's | Planned Mileage | Planned Drive Time | [NAME]
JEC | 134 | 83.26759999999999 | 03:52:20 | 9
CK | 200 | 124.28 | 04:20:00 | 11
EU | 101 | 62.76139999999999 | 03:45:00 | 6
FFA | 58 | 36.0412 | 00:58:00 | 4
MS | 60 | 37.284 | 01:08:26 | 5
TC | 88 | 54.6832 | 02:32:00 | 7
UC | 106 | 65.8684 | 03:50:00 | 7
Actual
Branch Code | Actual KM's | Actual Mileage | Actual Drive Time | Actual Geo-stops
JEC | 150 | 93.21 | 04:32:00 | 10
CK | 180 | 111.852 | 04:00:00 | 10
EU | 140 | 86.996 | 03:59:00 | 7
FFA | 90 | 55.92599999999999 | 01:35:00 | 4
MS | 70 | 43.498 | 01:15:00 | 5
TC | 80 | 49.712 | 02:30:00 | 7
UC | 100 | 62.13999999999999 | 03:45:00 | 5
Difference %
Branch Code | KM's | Mileage | Drive Time | Geo-stops
JEC | -0.1194029850746268 | -9.942400000000006 | -0:39:40 | -1
CK | 0.09999999999999998 | 12.428 | 0:20:00 | 1
EU | -0.386138613861386 | -24.2346 | -0:14:00 | -1
FFA | -0.5517241379310345 | -19.8848 | -0:37:00 | 0
MS | -0.1666666666666667 | -6.213999999999999 | -0:06:34 | 0
TC | 0.09090909090909094 | 4.971200000000003 | 0:02:00 | 0
UC | 0.05660377358490565 | 3.728400000000001 | 0:05:00 | 2