tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 694854d1599842222-filling-in-gaps-in-rows-by-deducing-relationships-across-table-filling-in-the-gaps
Sheet: Gaps

Possible occurrence types: |  |  |  |  |  |  |  | General:
Level1 | Level2 | Level3 | Type | Level1 | Level2 | Level3 |  | A single A can point to many [NAME] which again can point to many [NAME].
A | B | C | 1 | 1 | 2 | 3 |  | A single C can point to only one B which again can point to only one A.
A | B |  | 2 | 1 | 2 |  |  | Use this to create as many connections between entries as possible, then remove duplicates, remove less complete combinations and sort the results {1\2\3} and put blanks at bottom.
A |  | C | 3 | 1 |  | 3 |  | [NAME] should work with both text entries and number entries.
A |  |  | 4 | 1
 | B | C | 5 |  | 2 | 3
 | B |  | 6 |  | 2
 |  | C | 7 |  |  | 3
 |  |  |  | Table 1 |  |  |  |  |  | Table 2 |  |  |  | Table 3 |  |  |  | Table 4
Possible connection types to be made (new connections marked in green): |  |  |  |  |  |  |  |  |  | Create possible connections (see formula in cols K, L, M). Need improved, less memory intensive dynamic array in cell K13. |  |  |  | Remove duplicates (see formula in col O) |  |  |  | Remove less complete combinations and sort {1\2\3}, putting blanks at bottom (see formula in col S)
A | B | C |  | 1 | 2 | 3 |  | I => |  |  |  |  | => |  | 2 | 3 | => |  | 2 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 6 |  | 4 | 5
D |  | F |  | 4 |  | 6 |  | II => |  | 4 |  | 6 |  | 4 | 5 |  |  | 4 |  | 6
D | E |  |  | 4 | 5 |  |  |  |  | 4 | 5 |  |  | 7 | 8 | 9 |  | 7 | 8 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 9 |  | 10 | 11 | 12
G |  | I |  | 7 |  | 9 |  | III => |  | 7 | 8 | 9 |  | 10 | 11 |  |  | 13 | 14
 | H | I |  |  | 8 | 9 |  |  |  |  | 8 | 9 |  | 10 | 11 | 12 |  | 19 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 14 |  |  | 25 |  | 27
J | K |  |  | 10 | 11 |  |  | IV => |  | 10 | 11 |  |  |  | 17 | 18 |  | 28 | 29
 | K | L |  |  | 11 | 12 |  |  |  | 10 | 11 | 12 |  | 19 | 20 |  |  | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 |  |  |  |  | 17 | 18
M | N |  |  | 13 | 14 |  |  | V => |  | 13 | 14 |  |  |  | 23 | 24 |  |  | 23 | 24
 | N |  |  |  | 14 |  |  |  |  | 13 | 14 |  |  |  | 23 |  |  |  | 32 | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 27 |  |  | 38
 | Q | R |  |  | 17 | 18 |  | VI => |  |  | 17 | 18 |  | 28 | 29 |  |  |  |  | 42
 |  | R |  |  |  | 18 |  |  |  |  | 17 | 18 |  |  | 32 | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 34
S | T |  |  | 19 | 20 |  |  | VII => |  | 19 | 20 |  |  |  | 38
S |  |  |  | 19 |  |  |  |  |  | 19 |  |  |  |  |  | 42
 | W | X |  |  | 23 | 24 |  | VIII => |  |  | 23 | 24
 | W |  |  |  | 23 |  |  |  |  |  | 23
Y |  | AA |  | 25 |  | 27 |  | IX => |  | 25 |  | 27
AB | AC |  |  | 28 | 29 |  |  | X => |  | 28 | 29
 | AF | AG |  |  | 32 | 33 |  | XI => |  |  | 32 | 33
AH |  |  |  | 34 |  |  |  | XII => |  | 34
 | AL |  |  |  | 38 |  |  | XIII => |  |  | 38
 |  | AP |  |  |  | 42 |  | XIV => |  |  |  | 42
Spreadsheet: 57261234-844d-46b0-8d08-3d5c95a3887e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
15ta. Copa Little Lads del Caribe
23 al 27 de Junio 2011
Santiago, Rep. [NAME].
Resultados de los Juegos Finales
[NAME]
3er. [NAME]  vs. 4to. [NAME] |  |  |  |  |  |  |  | 2do. [NAME]. 1er. [NAME]
JUEGO  11 |  |  | LUN. 27 JUN. |  |  |  |  | JUEGO   12 |  |  | LUN. 27 JUN.
E  Q  U  I  P  O  S | T 1 | T 2 | T 3 | T 4 | T E | TOT |  | E  Q  U  I  P  O  S | T 1 | T 2 | T 3 | T 4 | T E | TOT
(A)  ABASACA  2 | 8 | 0 | 11 | 3 |  | 22 |  | (A)  ABASACA  1 | 0 | 6 | 3 | 2 |  | 11
(B)  LA VEGA | 6 | 6 | 5 | 9 |  | 26 |  | (B)  PUERTO RICO | 16 | 11 | 8 | 10 |  | 45
[NAME]
3er. [NAME]  vs. 4to. [NAME] |  |  |  |  |  |  |  | 2do. [NAME]. 1er. [NAME]
JUEGO  11 |  |  | LUN. 27 JUN. |  |  |  |  | JUEGO   12 |  |  | LUN. 27 JUN.
E  Q  U  I  P  O  S | T 1 | T 2 | T 3 | T 4 | T E | TOT |  | E  Q  U  I  P  O  S | T 1 | T 2 | T 3 | T 4 | T E | TOT
(A)  ABASACA  3 | 6 | 5 | 4 | 4 |  | 19 |  | (A)  ABASACA  1 | 8 | 4 | 14 | 18 |  | 44
(B)  ABASACA  2 | 0 | 6 | 2 | 1 |  | 9 |  | (B)  LA VEGA | 13 | 7 | 13 | 2 |  | 35
[NAME]
3er. [NAME]  vs. 4to. [NAME] |  |  |  |  |  |  |  | 2do. [NAME]. 1er. [NAME]
JUEGO  11 |  |  | LUN. 27 JUN. |  |  |  |  | JUEGO   12 |  |  | LUN. 27 JUN.
E  Q  U  I  P  O  S | T 1 | T 2 | T 3 | T 4 | T E | TOT |  | E  Q  U  I  P  O  S | T 1 | T 2 | T 3 | T 4 | T E | TOT
(A)  ABASACA  1 | 14 | 2 | 9 | 23 | 11 | 59 |  | (A)  LA VEGA | 8 | 6 | 17 | 11 |  | 42
(B)  ABASACA 2 | 12 | 11 | 17 | 8 | 7 | 55 |  | (B)  PUERTO RICO | 8 | 7 | 11 | 7 |  | 33
Spreadsheet: 463076d1464286258-calculation-of-downtime-with-a-range-of-time-for-various-status-copy-of-down
Sheet: Sheet1

 |  | Count | Downtime
 | Pending
 | Rejected
 | Resolved
 | Closed
 | In Progress
 | Total
 | Downtime
 | SLA | Closed | Rejected | Resolved | Pending | In Progress | Total
 | Within 4 Hours
 | Within 8 Hours
 | Within 24 Hours
 | Greater Than 24
 | Total
 | Count
 | SLA | Closed | Rejected | Resolved | Pending | In Progress | Total
 | Within 4 Hours
 | Within 8 Hours
 | Within 24 Hours
 | Greater Than 24
 | Total
Spreadsheet: 866002d1712934449-need-conditional-formatting-help-proposed-expenditures-example
Sheet: Sheet1

 | Expenditure Amount : |  |  | 13180
 | Amount Expected to be Spent:
 | Actual Amount Spent:
 | Balance relaining:
DEDICATION TO | NOTES: | Expected cost |  | Actual Cost
65 FT Boom Lift | Nifty SD64 Self Driving 64' Lift $475.00 Pr Day, Delivery & Pickup Charge $200.00, Taxes $40.50 |  | 715.5
Wood Chipper | Bandit 12" Wood Chipper Diesel $25.00 Pr Day, Delivery & Pickup Charge $160.00, Taxes $26.10 |  | 461.1
AMAZON (FOR TRAILER) | GRAND RIDE Set 2 FREE COUNTRY ST205/75R15 Premium Trailer Tires 205 75 15 8-Ply Load Range D w/Scuff Guard 8mm Tread Depth |  | 145.21
AMAZON (FOR TRAILER) | Grand Ride One Premium FREE COUNTRY Trailer Tire ST205/75R15 205 75  15 Radial 8-Ply Load Range D w/Scuff Guard |  | 76.19
Front Deck (Lowes) | (1)  2x6x16  $16.18 , (2)  2x6x8 $15.96 , Taxes $1.93 |  | 34.07
Utility [NAME] (Stoltzfus Forest Products) | New boards for trailer: (11)  1.5" x 6" x 10'  $24.00 ea |  | 279.84
Rear Stoop | ( ? ) 2"x 4" x ?
Basement  (Amazon) | [NAME], [NAME]: MAD50S1QWT, $264.00 , Taxes $16.68 | 1 | 278
Water Pump | [NAME]# RL12G05-2W1V  4-inch Submersible Deep Well Pump, 1/2 HP, 12 GPM, 2-Wire, 115 Volt, Steel, 14942401 , $472.00, Taxes $28.32 |  | 500.35
Plumber | Labor to install new water pump   (Estimate Only !) |  | 500
County Line  Quarry | 20 Ton of Stone, (County Line) Screenings $12.80 Pr Ton, Hauling Chg $10.50 Pr Ton, Tax $1.40 ($24.70 PT )  Total $494.00 15 Ton Screenings  ([NAME]) Screenings $12.80 Pr Ton, Hauling Chg $10.50 Pr Ton, Tax $1.40 ($24.70 PT )  Total $494.00
County Line Quarry | 15 Ton of Top Soil
New Weather Station  (Amazon) | Approximate Expense | 1 | 120
Staples  Eastern Ave. | Office Chair  sku# 923571 |  | 119.99
Spreadsheet: 765040d1643131730-sum-sheets-starting-with-br-where-criteria-is-the-same-formula-to-sum-data-where-criteria-is-the-same
Sheet: Total BR

Nominal | Description | 3/2022(YTD)
30100701
31070701
30107012
30107013
30107014
30107015
30107016
70108000
70108005
30807010
70107015
70108020
70108025
70108090
70108701
70108702
70108705
Spreadsheet: 781016d1652944379-formula-to-show-average-of-the-last-n-values-in-a-row-sample-database-sheet-a
Sheet: Sheet1

Person ID | Count | Sample | Average | IL910 | itt1094 | itt1093
74266 |  |  |  | 24 | 23 | 125 | 1 | 0 | 4 | 9 | 7 | 7 | 89 | 23 | 12 | 12 | 45 | 56 | 12 | 45 | 0 | 0 | 12 |  | 12 | 34 | 56 | 56 | 4 | 4 | 134 | 12 | 1 |  |  |  | 56 | 7 | 8 | 8
1377783 |  |  |  | 10
2437039 |  |  |  | 10
264193 |  |  |  | 10
1774169 |  |  |  | 10
2272567 |  |  |  | 10
97647 |  |  |  | 10
1230394 |  |  |  | 10
264173 |  |  |  | 10
1381886 |  |  |  | 10
1196767 |  |  |  | 10
1358247 |  |  |  | 10
8681 |  |  |  | 10
952567 |  |  |  | 10
8931 |  |  |  | 10
1917128 |  |  |  | 10
94280 |  |  |  | 10
7561 |  |  |  | 10
247668 |  |  |  | 10
44613 |  |  |  | 10
2206768 |  |  |  | 10
2266673 |  |  |  | 10
166944 |  |  |  |  | 10 | 10
251815 |  |  |  |  | 10 | 10
2053717 |  |  |  |  | 10
19345 |  |  |  |  | 10 | 10
1913878 |  |  |  |  | 10 | 10
80441 |  |  |  |  | 10 | 10
8219 |  |  |  |  | 10 | 10
69226 |  |  |  |  | 10
24381 |  |  |  |  | 10
2248308 |  |  |  |  | 10 | 10
2128597 |  |  |  |  | 10 | 10
1130413 |  |  |  |  | 10 | 10
90667 |  |  |  |  | 10 | 10
100194 |  |  |  |  | 10 | 10
60781 |  |  |  |  | 10 | 10
46081 |  |  |  |  | 10 | 10
119895 |  |  |  |  | 10 | 10
332051 |  |  |  |  | 10 | 10
113651 |  |  |  |  | 10 | 10
1305044 |  |  |  |  | 10 | 10
88341 |  |  |  |  | 10 | 10
296749 |  |  |  |  | 10 | 10
214544 |  |  |  |  |  | 10
192792 |  |  |  |  |  | 10
85002 |  |  |  |  |  | 10
Spreadsheet: 834863d1688125914-tiered-cumulative-rate-calculation-example
Sheet: Sheet1

 |  |  |  |  |  | Volume
 | Rate | Volume |  |  |  | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12
 | 3.83 | Under 100 |  |  | Windows | 45 | 72 | 54 | 68 | 95 | 34 | 72 | 81
 | 3.81 | Over 100
 |  |  |  |  | Cost
 |  |  |  |  |  | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12
 |  |  |  |  | Windows
 |  |  |  |  |  | check |  | Rate
 |  |  |  |  |  | Total volume
 |  |  |  |  |  | P6 Volume under 100 |  | 3.83
 |  |  |  |  |  | P6 volume over 100 |  | 3.81
Spreadsheet: 854149d1704121761-create-spread-for-actual-values-against-planned-plan-vs-actual-distribution-excelforum-windknife-3-
Sheet: Sheet1

Activity | Company | Month | Plan | Actual
Activity 1 | ABC | 2023-01-01 00:00:00 | 100 | 30 |  |  |  | /Actual | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
Activity 2 | ABC | 2023-01-01 00:00:00 | 100 | 60 |  |  | 2023-01-01 00:00:00 | 400 | 140 | 260 | 0
Activity 1 | DEF | 2023-01-01 00:00:00 | 200 | 50 |  |  | 2023-02-01 00:00:00 | 300 | 0 | 130 | 120
Activity 1 | ABC | 2023-02-01 00:00:00 | 200 | 150 |  |  | 2023-03-01 00:00:00 | 50 | 0 | 0 | 180
Activity 1 | ABC | 2023-03-01 00:00:00 | 50 | 300
Activity 1 | DEF | 2023-02-01 00:00:00 | 50 | 150
Activity 2 | ABC | 2023-02-01 00:00:00 | 50 | 90
Plan/Actual |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 |  |  | Plan | /Actual | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
2023-01-01 00:00:00 | 400 | 140 | 260 |  |  |  | 2023-01-01 00:00:00 | 400 | 140 | 260 | 0
2023-02-01 00:00:00 | 300 |  | 130 | 120 |  |  | 2023-02-01 00:00:00 | 300 | 0 | 130 | 120
2023-03-01 00:00:00 | 50 |  |  | 180 |  |  | 2023-03-01 00:00:00 | 50 | 0 | 0 | 180
[NAME] for January
Activity | Company | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 |  |  |  | /Actual | 44927 | 44958 | 44986
Activity 1 | ABC | 30 | 70 |  |  |  | 44927 | 400 | 140 | 260 | 0
Activity 2 | ABC | 60 | 40 |  |  |  | 44958 | 300 | 0 | 130 | 170
Activity 1 | DEF | 50 | 150 |  |  |  | 44986 | 50 | 0 | 0 | 130
[NAME] for February
Activity | Company | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
Activity 1 | ABC |  | 80 | 120
Activity 2 | ABC |  | 50
Activity 1 | DEF
[NAME] for March
Activity | Company | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
Activity 1 | ABC |  |  | 180
Spreadsheet: 021c2155-3527-4eec-8fce-58552468ec35
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 | From: |  |  |  |  |  |  |  |  | From:
 |  |  |  | Fair Code: | 1533 |  |  |  |  |  |  |  | Fair Code: | 1533
 |  |  |  | Fair Name: | IIE Fall 2013 |  |  |  |  |  |  |  | Fair Name: | IIE Fall 2013
 |  |  |  | FAIR CITY: |  |  |  |  |  |  |  |  | FAIR CITY:
 |  |  |  | #BOXES per |  |  |  |  |  |  |  |  | #BOXES per
 |  |  |  | CITY ABOVE: |  |  |  |  |  |  |  |  | CITY ABOVE:
 |  | SHIP TO: |  | OCS America Inc. |  |  |  |  |  |  | SHIP TO: |  | OCS America Inc.
 |  |  |  | Boston Branch |  |  |  |  |  |  |  |  | Boston Branch
 |  |  |  | 29 Draper Street |  |  |  |  |  |  |  |  | 29 Draper Street
 |  |  |  | Woburn MA. 01801 USA |  |  |  |  |  |  |  |  | Woburn MA. 01801 USA
 |  |  |  | Tel: [PHONE] |  |  |  |  |  |  |  |  | Tel: [PHONE]
 | From: |  |  |  |  |  |  |  |  | From:
 |  |  |  | Fair Code: | 1533 |  |  |  |  |  |  |  | Fair Code: | 1533
 |  |  |  | Fair Name: | IIE Fall 2013 |  |  |  |  |  |  |  | Fair Name: | IIE Fall 2013
 |  |  |  | FAIR CITY: |  |  |  |  |  |  |  |  | FAIR CITY:
 |  |  |  | #BOXES per |  |  |  |  |  |  |  |  | #BOXES per
 |  |  |  | CITY ABOVE: |  |  |  |  |  |  |  |  | CITY ABOVE:
 |  | SHIP TO: |  | OCS America Inc. |  |  |  |  |  |  | SHIP TO: |  | OCS America Inc.
 |  |  |  | Boston Branch |  |  |  |  |  |  |  |  | Boston Branch
 |  |  |  | 29 Draper Street |  |  |  |  |  |  |  |  | 29 Draper Street
 |  |  |  | Woburn MA. 01801 USA |  |  |  |  |  |  |  |  | Woburn MA. 01801 USA
 |  |  |  | Tel: [PHONE] |  |  |  |  |  |  |  |  | Tel: [PHONE]
Spreadsheet: 759537d1639587838-if-statement-headache-again-con_sample
Sheet: Sheet1

Threshold % |  |  | [NAME]
9 | % |  | Compliant
65 | % | ✅ | Compliant | 🛑
-12 | % | 🛑 | Investigate | ✅
15 | % |  | Concurrent | ⚠
Spreadsheet: 65683d1266363280-how-to-find-out-remaining-time-clock-and-escalation-temp
Sheet: Sheet1

 | Order No. | Recd. Time | Update Time | Remaining Hour | Escalation
 | XYZ | 2010-02-04 07:10:30 | Pending | 01:59:59 | 00:00:00
 | ABC | 2010-02-04 07:10:30 | Pending | 01:59:59 | 00:00:00
 | EFG | 2010-02-04 07:10:30 | Pending |  | 02:15:39
 | HIJ | 2010-02-04 07:10:30 | Pending |  | 03:15:51
 | In Column E | When user entered the date and time in recd. Time's column, remaining hour clock would start as 01:59:59
 | In Column F | If updated file's time is more than or equal to 02:00:00, file should be escalated and I want the escalation time in Escaltion Column.
Spreadsheet: louise_kitchen__24241__July Orig w notes
Sheet: Midwest Power

Midwest Power
Originator |  | Commodity |  | Team |  | Total |  | %Total
Valderama |  | Power |  | Midwest Power |  | 189300
Sewell |  | Power |  | Midwest Power |  | 62000
Wheeler |  | Power |  | Midwest Power |  | 8800
Total
Spreadsheet: eric_saibi__9749__011602R
Sheet: San Juan 04

Owner Name |  | Public Service Co. of New Mexico
Station Name |  | San Juan Generating Station
Unit Name |  | San Juan 04
NERC Region |  | WSCC
State |  | NM
Fuel Type |  | Coal
Capacity |  | 534 MW
Start Date |  | 2002-01-10 00:00:00
End Date |  | 2002-01-21 00:00:00
Prv. Start Date |  | 2002-01-10 00:00:00
Prv. End Date |  | 2002-01-14 00:00:00
Comments |  | Tube repairs.
SIC |  | 4911
Plant ID |  | 1016385
Unit ID |  | 1007773
Outage ID |  | 19445
Spreadsheet: 119943d1314879400-inserting-rows-across-sheets-komet12_testing
Sheet: MATH_DEF

 |  | Last Name | First Name | Occp | Dept | Team | Shift | GMIN | BPD | [NAME] | Interview | Math | Written | Comments | Test Taken On:
Spreadsheet: phillip_m_love__30146__200002_OA
Sheet: SITHE-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 5709814 | 14580741
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 4883736 | 13046146
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 10593550 | 27626887
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -813187 | -2202053 |  |  |  |  | 0 | 0
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -9725476 | -25364923
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 2450 | 6292
 | Total Purchases: |  | -10536213 | -27560684
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | -38096 | 123685
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0 |  |  |  |  | 0 | 0
 | Total Imbalances: |  | -38096 | 123685
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -19241 | -48947.42017005271
 |  |  | 0 | 0
23 | Fuel: |  | -2450 | -6292
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -5682
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -5682
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | -259749.4152
31 |  | Prior Month Book Balance | 0 | 322864
 |  | Total MTM Income | 0 | 63114.58480000001
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 80011
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -6608
 |  | TOTAL INTRA-MTH
Spreadsheet: 1748fcc2-0424-4358-b0a9-58865cbaeb3a
Sheet: MULTIFAMILY  

 |  |  | CITY OF RIO RANCHO, NEW MEXICO
 |  |  | SEPTEMBER 2014 MULTI-FAMILY
APPLICATION TYPE | ADDRESS |  |  |  | LEGAL DESCRIPTION |  |  | PERMIT |  | STATUS | YMMDD | SQUARE FOOTAGE | VALUATION | # OF UNITS
 | Street Number | Street Name | Suffix | Quandrant | Unit | Block | Lot | Permit Year | Permit number
 |  |  | NONE | FOR | SEPTEMBER | 2014
Spreadsheet: 0fda912a-6dbb-487d-8837-aca41cd5ef49
Sheet: 15b

Product1 | HY3 | IG | Other | TOTAL
Index Tranche | 590 | 72 | 455 | 1117
Index | 40202 | 94003 | 110909 | 245114
Asia | . | . | 2177 | 2177
Europe | . | . | 106399 | 106399
North America | 40202 | 94003 | 312 | 134517
Other | . | - | 2021 | 2021
OTHER* | - | - | 32687 | 32687
TOTAL | 40792 | 94075 | 144051 | 278918
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 720170d1614048822-inserting-additional-criteria-to-an-if-statement-worktimecalcefupdated
Sheet: Correct 3

STRT | END | WRK | RT | ST | OT |  | Overall Day
 |  |  |  |  |  |  | Report | 07:39:00
 |  |  |  |  |  |  | Start Shift
 |  |  |  |  |  |  | End Shift | 17:40:00
 |  |  |  |  |  |  | 1st Half Pay
 |  |  |  |  |  |  |  | Break
 |  |  |  |  |  |  | Report | 18:16:00
 |  |  |  |  |  |  | Start Shift
 |  |  |  |  |  |  | 11th Hour
 |  |  |  |  |  |  | End Shift | 19:30:00
 |  |  |  |  |  |  | Straight Time
 |  |  |  |  |  |  | Overtime
Spreadsheet: 583229d1532332101-count-by-column-entry-countif
Sheet: Sheet1

Account | Orders | Order lines |  |  |  | Customer Code | [NAME]. | [NAME] lines
102121 | 10949773 | 1 |  |  |  | 102121 | 3 | 6
102121 | 10949773 | 1 |  |  |  | 102132 | 1 | 1
102121 | 10949773 | 1 |  |  |  | 102156 | 2 | 8
102121 | 10965209 | 1 |  |  |  | 800697 | 2 | 8
102121 | 10965209 | 1
102121 | 10982622 | 1
102132 | 10945883 | 1
102156 | 10941989 | 1 |  |  |  |  |  |  |  |  |  | Row Labels | Distinct Count of Orders | Sum of Order lines
102156 | 10941989 | 1 |  |  |  |  |  |  |  |  |  | 102121 | 3 | 6
102156 | 10941989 | 1 |  |  |  |  |  |  |  |  |  | 102132 | 1 | 1
102156 | 10941989 | 1 |  |  |  |  |  |  |  |  |  | 102156 | 2 | 8
102156 | 10941989 | 1 |  |  |  |  |  |  |  |  |  | 800697 | 2 | 8
102156 | 10941989 | 1 |  |  |  |  |  |  |  |  |  | Grand Total | 8 | 23
102156 | 10941989 | 1
102156 | 10943000 | 1
800697 | 21655829 | 1
800697 | 21655829 | 1
800697 | 21655829 | 1
800697 | 21655829 | 1
800697 | 21655829 | 1
800697 | 21655829 | 1
800697 | 21656664 | 1
800697 | 21656664 | 1
BEFORE |  |  |  |  |  | AFTER
Spreadsheet: 787416d1657792206-use-vlookup-to-show-all-childs-of-a-parent-or-an-assembly-vlookup_components-1-
Sheet: Stückliste

Search --> | Materialnummer | B2
 |  | Components | [NAME]. | Datum | Typ/Norm | [NAME] | Kommentar | Position 1 | Position 2 | Position 3 | Position 4 | Position 5 | Position 6 | Position 7 | Position 8 | Position 9 | Position 10
 | Position 1
 | Position 2
 | Position 3
 | Position 4
 | Position 5
 | Position 6
 | Position 7
 | Position 8
 | Position 9
 | Position 10
Spreadsheet: 796386d1663246910-search-text-string-formula-help-match-search-thread-aligw
Sheet: Sheet1

Column A | Column B | Column C | Column D | Column E | Column F |  | Column E Key |  | Column F Key
XR1006NGSC | A | 400 | A NITROX NG/SC ASSY |  |  |  | 1006 |  | [NAME]
[NAME] | A | 480 | A NITROX GS12 TESTED ASSY |  |  |  | 2001 |  | GS12
[NAME] | A | 480 | A NITROX GS12 TESTED ASSY |  |  |  |  |  | GS40
XR2001GS40CABLAT | B | 440 | B GS40 PLUS/PREM ABLATED ASSEMBLY |  |  |  |  |  | 128/40
[NAME] | A | 480 | A NITROX GS12 TESTED ASSY |  |  |  |  |  | GS6
XR1006NGSC | A | 400 | A NITROX NG/SC ASSY |  |  |  |  |  | POSEIDON
XR2001GS40CABLAT | B | 440 | B GS40 PLUS/PREM ABLATED ASSEMBLY |  |  |  |  |  | 128/80
XR2001GS40CABLAT | B | 440 | B GS40 PLUS/PREM ABLATED ASSEMBLY
XR2001GS40CABLAT | B | 440 | B GS40 PLUS/PREM ABLATED ASSEMBLY
XR1006NGSC | A | 400 | A NITROX NG/SC ASSY
XR1006NGSC | A | 400 | A NITROX NG/SC ASSY
XR2001GS40CET | B | 41090 | B GS40 PLUS/PREM ELECTRICAL TESTED ASSEMBLY
5300299 | C | 30120 | NOZZLE ASSEMBLY NW 128/40
5300299 | C | 30120 | NOZZLE ASSEMBLY NW 128/40
[NAME] | B | 41060 | B GS40 PLUS/PREM SIDE COVER N/G ATTACH
XR2001GS40CET | B | 41090 | B GS6 PLUS/PREM ELECTRICAL TESTED ASSEMBLY
[NAME] | A | 480 | A NITROX GS12 TESTED ASSY
XR1006NGSC | A | 400 | A NITROX NG/SC ASSY
XR00045254 | B | 43025 | POSEIDON - BUSBOARD ASSY
5300305 | C | 30135 | NOZZLE FILTERED ASSEMBLY NW 128/80
[NAME] | A | 480 | A NITROX GS12 TESTED ASSY
[NAME] | A | 480 | A NITROX GS12 TESTED ASSY
 |  |  |  | Red Text is expected answers
Spreadsheet: 680402d1591007849-sumifs-over-multi-sheets-bills-spread-sheet-v1
Sheet: Year

2020-2021
Month | Food | Body Corporate Rates | Internet | Electricity | Gas | Water | Insurance | Council Rates | Post Office Box | Mortgage Advantage | Miscellaneous
2021-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
2021-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per Month
2021-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per Week
2021-10-01 00:00:00
2021-11-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL BILLS
2021-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per Month
2022-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per Week
2022-02-01 00:00:00
2022-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL FOOD
2022-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per Week
2022-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Per Week was the Budget
2022-06-01 00:00:00
Total
2021-2022
Month | Food | Body Corporate Rates | Internet | Electricity | Gas | Water | Insurance | Council Rates | Post Office Box | Mortgage Advantage | Miscellaneous
2022-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
2022-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per Month
2022-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per Week
2022-10-01 00:00:00
2022-11-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL BILLS
2022-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per Month
2023-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per Week
2023-02-01 00:00:00
2023-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL FOOD
2023-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per Week
2023-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Per Week was the Budget
2023-06-01 00:00:00
Total