tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 138059d1327504687-sum-cell-based-on-criteria-countif-formula-assistance-copy-of-test-4
Sheet: Sheet1

 |  |  |  |  |  | 1 | 2
 |  |  |  |  |  | A |  | x
 |  |  | A | B |  |  | B
 |  |  |  |  |  | A
 |  | x |  |  |  |  | B
 |  | y |  |  |  | A
 |  | z |  |  |  |  | B
 |  |  |  |  |  |  | B
 |  |  |  |  |  | A
 |  |  |  |  |  |  |  | z
 |  |  |  |  |  | A
 |  |  |  |  |  |  | B
 |  |  |  |  |  | A
 |  |  |  |  |  |  | B
 |  |  |  |  |  | A
 |  |  |  |  |  |  | B
 |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  | A
 |  |  |  |  |  | A
 |  |  |  |  |  |  | B
 |  |  |  |  |  | A
 |  |  |  |  |  |  | B
 |  |  |  |  |  | A
 |  |  |  |  |  |  | B
Spreadsheet: kay_mann__19211__LM 6000 Breakout Contracts
Sheet: Turbine Allocation

LM 6000 Turbine Allocation
# | Turbine Unit # | Delivery Date | Project Name | Change Orders
1 | 308898 | 2000-07-08 00:00:00 | Enron South America | #3
2 | 308951 | 2000-07-26 00:00:00 | Enron South America | #3
3 | 308972 | 2000-08-15 00:00:00 | Enron South America | #3
4 | 308999 | 2000-07-09 00:00:00 | Enron South America | #3
5 | 309020 | 2000-07-10 00:00:00 | Enron South America | #3
6 | 309073 | 2000-07-21 00:00:00 | Enron South America | #3
7 | 309101 | 2000-07-26 00:00:00 | PSCO/Fountain Valley | #1 - Dual Fuel
8 | 309123 | 2000-08-15 00:00:00 | PSCO/Fountain Valley | #1 - Dual Fuel
9 | 309266 | 2000-08-19 00:00:00 | [NAME]
10 | 309547 | 2000-09-01 00:00:00 | [NAME]
11 | 309575 | 2000-09-06 00:00:00 | [NAME]
12 | 309578 | 2000-09-14 00:00:00 | [NAME]
13 | 309420 | 2000-09-21 00:00:00 | PSCO/Fountain Valley | #2
14 | 309505 | 2000-09-28 00:00:00 | PSCO/Fountain Valley | #2
15 | 309573 | 2000-10-25 00:00:00 | PSCO/Fountain Valley | #2
16 | 309601 | 2000-11-01 00:00:00 | PSCO/Fountain Valley | #2
17 | 309604 | 2000-11-13 00:00:00 | Coral Energy | #1 - Dual Fuel
18 | 309719 | 2000-11-20 00:00:00 | Coral Energy | #1 - Dual Fuel
19 | To be assigned | 2000-07-21 00:00:00 | Las Vegas
20 | To be assigned | 2000-07-24 00:00:00 | Las Vegas
21 | 309898 | 2001-02-01 00:00:00 | Enron South America | #3
22 | 309988 | 2001-01-27 00:00:00 | Enron South America | #3
23 | To be assigned | 2000-07-30 00:00:00 | Las Vegas
24 | To be assigned | 2000-09-01 00:00:00 | Las Vegas
Spreadsheet: mary_fischer__25610__32D-2001
Sheet: E31.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032D
COMPANY NAME  Enron Building Services, Inc.
RECONCILIATION OF STOCKHOLDERS' EQUITY AND INVESTMENT IN SUBS
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY: [NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
 |  |  |  | 12-31-00 Balance |  |  |  | EQUITY IN |  | DIVIDENDS DECLARED |  |  |  | OTHER ACTIVITY
 |  |  |  | DR  (CR) |  | RECLASS 00 NI |  | EARNINGS |  |  |  |  |  |  |  |  |  | DR  (CR)
 |  | Hyp line |  | BEG BALANCE |  | TO BEG RE |  | /LOSSES |  | COMMON |  | PREFERRED |  | DR (CR) |  | (Describe) |  | END BALANCE
Shareholders Equity by Parent |  | Reverse signs from Hyperion
Common Stock |  | 0901 |  | -10000
Paid in Capital |  | 0910
Contribution Received from Parent |  | 0915 |  | -2565525
RE - Beg Bal |  | 0920 |  | 1661929 |  |  |  |  |  |  |  |  |  |  |  | I/C entry made to correct incorrect
RE - Net Income |  | 0930 |  | -228139 |  |  |  |  |  |  |  |  |  |  |  | charge from 32d with 87P,
RE - Net Income (Fair Value Adjustment) |  | 0931 |  | 84000 |  |  |  | -42000 |  |  |  |  |  |  |  | which rolled into 32c  and mgmt fee
Dividends Decl - Preferred Stock |  | 0935 |  |  |  |  |  |  |  |  |  |  |  |  |  | allocation entry.
Dividends Decl - Common Stock |  | 0941
Invest in Subs Plug Account |  | 0942 |  | -1 |  |  |  | 1
Total Shareholders' Equity |  | TOT_SHARE_EQU
Net Income |  | NET_INCOME
PARENT'S CO #032C
Investment in Consol Sub (on Parent Books) |  |  |  | Same signs as Hyperion
Investment in CS |  | 0215 |  | 897501.77 |  |  |  |  |  |  |  |  |  |  |  | I/C entry made to correct incorrect
Investment in PIC (contrib by parent) |  | 0216 |  |  |  |  |  |  |  |  |  |  |  |  |  | charge from 32d with 87P,
Investment in Equity earnings of sub |  | 0217 |  | 144141.19 |  |  |  |  |  |  |  |  |  |  |  | which rolled into 32c
Total Investment in Consol Sub
Equity in Consol Sub |  | 1505 |  | -144141.19
Difference between SE (on sub) and Invest (on parent)
Reasons for Differences
Parent Net Income Adjustment not yet made for 2001 for current year
Management Fee Allocation to be booked
A schedule will need to be prepared for each subsidiary.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
Spreadsheet: 72779d1273509354-how-to-retrieve-names-from-the-table-2-criteria-given-packaging-kpi
Sheet: MAIN

UNIT 2 PACKAGING KEY PERFORMANCE INDICATOR
 |  |  | SHIFT |  |  | SUPERVISOR |  |  |  |  |  | DATE | 2010-05-01 00:00:00 |  | 1
 | PRODUCTS | TASKS |  |  |  |  |  |  |  | PROCESS CREDITS |  | STAFFING 4X4
 |  | COLOUR | CARAMEL | TOPPING | CUTTING | BOATING | PACKING | REWRAPING | [NAME] |  |  | HOLIDAYS | SICK | UNPAID LEAVE
 |  |  |  |  |  |  |  |  |  |  |  | #N/A | ? | ? |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | #N/A | ? | ? | In this table I want to retrieve names of staff who are on holidays, off sick or on unpaid leave. All data is in the sheet named "staff"
 |  |  |  |  |  |  |  |  |  |  |  | #N/A | ? | ?
 |  |  |  |  |  |  |  |  |  |  |  | #N/A | ? | ?
 |  |  |  |  |  |  |  |  |  |  |  | #N/A | ? | ?
 |  |  |  |  |  |  |  |  |  |  |  | #N/A | ? | ?
 |  |  |  |  |  |  |  |  |  |  |  | #N/A | ? | ?
 |  |  |  |  |  |  |  |  |  |  |  | STAFFING 8 HRS
 |  |  |  |  |  |  |  |  |  |  |  | HOLIDAYS | SICK | UNPAID LEAVE
 |  |  |  |  |  |  |  |  | TOTAL | 0
Spreadsheet: 822530d1679405328-sum-of-all-return-results-from-logical-test-return-ask
Sheet: Sheet1

AWB/Sender/Name | AWB/Sender/Mobile | AWB/Destination Township/Township Name | AWB/COD Amount | Column1 |  |  |  | or
PhooPwint | [PHONE] | Bago | 2000
Anna | [PHONE] | Bago | 22500
Aye Aye Mon | [PHONE] | Bagan | 23000
NR ဆံပင်သန်ဆီ OS | [PHONE] | Bagan | 9900
MM Online Shop | [PHONE] | Aye Thar Yar | 232190
University Life | [PHONE] | Laukkaing | 219250
Lavender404 | [PHONE] | Laukkaing | 460000
KantKawPhooe | [PHONE] | Laukkaing | 215000
Phyo Ei | [PHONE] | Laukkaing | 4500
[NAME] (YNS) | [PHONE] | Laukkaing | 292500
Ma Marlar Cho | [PHONE] | Laukkaing | 257500
AZ Fulfillment | [PHONE] | Laukkaing | 120000
AZ Fulfillment | [PHONE] | Laukkaing | 120000
[NAME] | [PHONE] | Laukkaing | 299988
[NAME] | [PHONE] | Laukkaing | 29000
[NAME] | [PHONE] | Laukkaing | 22500
[NAME] | [PHONE] | Laukkaing | 18500
TSM | [PHONE] | Laukkaing | 20000
[NAME] | [PHONE] | Laukkaing | 30000
AZ Fulfillment | [PHONE] | Laukkaing | 120000
[NAME] | [PHONE] | Laukkaing | 54000
[NAME] Mask | [PHONE] | Laukkaing | 115000
Poke Myanmar offical | [PHONE] | Laukkaing | 95000
Helena (BKK Cosmetic)(New) | [PHONE] | Laukkaing | 37500
[NAME] | [PHONE] | Laukkaing | 19000
[NAME] | [PHONE] | Laukkaing | 23000
Tolly Molly | [PHONE] | Laukkaing | 15000
University Life | [PHONE] | Laukkaing | 44500
THET NAING TUN | [PHONE] | Laukkaing | 120000
Spreadsheet: 837507d1690209958-formula-to-pick-up-max-value-and-apply-that-max-record-values-to-other-recordswith-same-id-test-solution-
Sheet: Hoja3

Base | Attribute1 | Attribute2 | Attribute3 | Output1 | Output2 | Output3
766687 | 1 | 3 | 70 |  | 6 | 70
766687 | 2 | 4 | 70 | 4 | 6 | 70
766687 | 3 | 5 | 70 | 4 | 6 | 70
766687 | 4 | 6 | 70 | 4 | 6 | 70
632165 | 2 | 3 | 60 | 4 | 1 | 60
632165 | 3 | 2 | 60 | 4 | 1 | 60
632165 | 4 | 1 | 60 | 4 | 1 | 60
123456 | 2 | 3 | 60 | 2 | 5 | 70
123456 | 2 | 5 | 70 | 2 | 5 | 70
123456 | 2 | 4 | 80 | 2 | 5 | 70
Spreadsheet: 81411d1281608231-vlookup-value-in-a-cell-containing-multiple-entries-partial-v-lookup-query
Sheet: Sheet 1

Table 1 (Workbook 1) |  |  | Table 2 (Workbook 2)
Scenario ID | [NAME] to Scenario |  | Script ID | Additional Scenario's Covered
SCEN_001 | SCRIPT_001, [NAME], SCRIPT_004 |  | SCRIPT_001 | SCEN_001 SCEN_007 SCEN_008
SCEN_002 | SCRIPT_002_1, [NAME] |  | SCRIPT_002_1 | SCEN_002
SCEN_003 | SCRIPT_003_1, SCRIPT_003_2, [NAME] |  | [NAME] | SCEN_002 SCEN_006
SCEN_004 | SCRIPT_004 |  | [NAME] | SCEN_001 SCEN_003 SCEN_008
SCEN_005 | SCRIPT_005 |  | SCRIPT_003_2 | SCEN_003
SCEN_006 | [NAME], SCRIPT_005 |  | [NAME] | SCEN_003 SCEN_007
SCEN_007 | SCRIPT_001, [NAME], SCRIPT_005 |  | SCRIPT_004 | SCEN_001 SCEN_004
SCEN_008 | SCRIPT_001, [NAME] |  | SCRIPT_005 | SCEN_005 SCEN_006 SCEN_007
Spreadsheet: 770886d1646320250-multiple-if-statements-testsheet
Sheet: Sheet1

Todays Date:
Required | Time OS | Passed
2022-03-01 00:00:00 | 6:27:20 | 0 |  |  |  |  |  |  | Possible | On Schedule
2022-03-02 00:00:00 | 4:21:20 | 1 |  |  |  |  |  |  | late | Off Schedule
2022-03-03 00:00:00 | 3:06:40 | 0
2022-03-04 00:00:00 | 11:12:30 | 1
2022-03-05 00:00:00 | 5:55:00 | 0
Spreadsheet: 858990d1707472121-maxifs-max-count-based-on-multliple-criteria-tracking-test-01
Sheet: SUMMARY

 |  |  |  |  | START: | 2024-01-01 00:00:00
BANKS ISSUED | TOTAL COUNT | DAY | SWING | GRAVE | END: | 2024-02-28 00:00:00
BANK #01
BANK #03
BANK #04
BANK #02 (ISSUES)
BANK #02 (RETURNS)
DATE | SHIFT | EMPLOYEE | EMP # | TYPE | OUTLET | AMOUNT
 | DAY | 0 | 0 | ISSUE | BANK #01 | 900
2024-01-01 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #01 | 900
2024-01-01 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #02 | 15000
2024-01-01 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #02 | 15000
2024-01-01 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #03 | 687.5
2024-01-01 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #04 | 687.5
2024-01-02 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #01 | 900
2024-01-02 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #01 | 900
2024-01-02 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #02 | 15000
2024-01-02 00:00:00 | SWING | 0 | 0 | RETURN | BANK #02 | 15000
2024-01-02 00:00:00 | SWING | 0 | 0 | RETURN | BANK #02 | 15000
2024-01-02 00:00:00 | SWING | 0 | 0 | RETURN | BANK #02 | 15000
2024-01-02 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #03 | 687.5
2024-01-02 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #03 | 687.5
2024-01-02 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #04 | 687.5
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #01 | 900
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #01 | 900
2024-01-03 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #01 | 900
2024-01-03 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #02 | 15000
2024-01-03 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #02 | 15000
2024-01-03 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #02 | 15000
2024-01-03 00:00:00 | GRAVE | 0 | 0 | RETURN | BANK #02 | 15000
2024-01-03 00:00:00 | GRAVE | 0 | 0 | RETURN | BANK #02 | 15000
2024-01-03 00:00:00 | GRAVE | 0 | 0 | RETURN | BANK #02 | 15000
2024-01-03 00:00:00 | GRAVE | 0 | 0 | RETURN | BANK #02 | 15000
2024-01-03 00:00:00 | GRAVE | 0 | 0 | ISSUE | BANK #02 | 15000
2024-01-03 00:00:00 | DAY | 0 | 0 | RETURN | BANK #02 | 15000
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #02 | 15000
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #02 | 15000
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #02 | 15000
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #02 | 15000
2024-01-03 00:00:00 | SWING | 0 | 0 | RETURN | BANK #02 | 15000
2024-01-03 00:00:00 | SWING | 0 | 0 | RETURN | BANK #02 | 15000
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #03 | 687.5
2024-01-03 00:00:00 | DAY | 0 | 0 | ISSUE | BANK #04 | 687.5
2024-01-04 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #01 | 900
2024-01-04 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #03 | 687.5
2024-01-04 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #03 | 687.5
2024-01-04 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #03 | 687.5
2024-01-04 00:00:00 | SWING | 0 | 0 | ISSUE | BANK #04 | 687.5
Spreadsheet: 796352d1663235119-calculation-the-average-number-of-days-between-a-value-costumer-shows-up-solve_needed
Sheet: Sheet1

Date | [NAME] ID
2022-06-14 00:00:00 | 5 | 7 | 12 | 14 | 31 | 33 | 35 | 39 | 43
2022-06-13 00:00:00 | 6 | 10 | 14 | 16 | 17 | 18 | 20 | 29 | 25
2022-06-12 00:00:00 | 1 | 6 | 7 | 29 | 22 | 5 | 24 | 21 | 28
2022-06-11 00:00:00 | 1 | 31 | 33 | 35 | 13 | 18 | 20 | 22 | 31
2022-06-10 00:00:00 | 2 | 13 | 19 | 22 | 26 | 29 | 32 | 41 | 43
2022-06-09 00:00:00 | 14 | 17 | 20 | 23 | 27 | 29 | 32 | 7 | 36
2022-06-08 00:00:00 | 3 | 29 | 10 | 11 | 12 | 15 | 17 | 18 | 23
2022-06-07 00:00:00 | 21 | 32 | 33 | 37 | 43 | 31 | 33 | 35 | 54
Spreadsheet: 68328d1268850281-sumif-with-about-1-000-criterias-sample-excelforum-1
Sheet: Plan1

THIS IS THE .TXT EXTRACT | -- | ------------------- | ------- | ---------------- |  |  |  |  |  | .=SUMPRODUCT(SUMIF(A:A,J6:J1000,C:C))
Item | Descrição | Un | [NAME]
21000039 | SUCATA DE AÇO - LINHA CONTÍNUA PUR - PIR | KG | 10551
2103-002 | TELHA TRAPEZOIDAL CONTINUA SINGELA TD40 | ROOF                 M2 | 41.58 |  |  | FORMULA |  |  | CODES TO ADD
21230178 | PERFIL AÇO 9003 0,65 DES    1- 100 | M | 12 |  |  | Group 1 |  |  | group1 codes
21230536 | PERFIL AÇO GVL 0,50 DES  201- 300 | M | 171 |  |  | Group 2 |  |  | 2500
21232300 | PERFIL AÇO GVL 9003 POS 102-170 C=100MM | PÇ | 50 |  |  | Group 3 |  |  | 2123
21232314 | PERFIL AÇO GVL 9003 POS 108-040 | M | 6 |  |  | Group 4
21232316 | PERFIL AÇO GVL 9003 POS 108-100 | M | 15
21232319 | PERFIL AÇO GVL 9003 POS 108-150 | M | 6
21232321 | PERFIL AÇO GVL 9003 POS 108-180 | M | 21
21232330 | PERFIL AÇO GVL 9003 POS 111-050 | M | 42
21232341 | PERFIL AÇO GVL 9003 POS 112 | M | 12
21232470 | PERFIL AÇO GVL 9003 POS 127 | M | 90
2500-100 | STYROPAINEL III 100MM | M2 | 701.2148
2500-125 | STYROPAINEL III 125MM | M2 | 1389.7826
2500-150 | STYROPAINEL III 150MM | M2 | 34.32
2500-200 | STYROPAINEL III 200MM | M2 | 102.4681
2520-100 | FRIGOLOC III PUR 100MM | M2 | 78.6721
2527 | CHAPA PUR | M2 | 792
25280008 | ESPUMA PUR - BLOCO  40 KG/M3 2.7 DOW | PÇ | 24
2531-30 | TERMOROOF PUR 30MM TABOADO | M2 | 3248.805
25370000 | ADESIVO PUR 1-COMP 30KG BOMBONA | PÇ | 5
2540-200 | FRIGOLOC III PIR 200MM | M2 | 147.5361
2618-001 | PORTA NAVAL B15 | PÇ | 4
 |  |  |  |  |  |  |  |  | ...etc
Spreadsheet: 04b612f6-2429-402c-9a8d-620a047562dc
Sheet: Tabuľka3

Štátna pokladnica |  |  |  |  |  | Tabuľka: 3
2012-03-22 00:00:00 |  |  |  |  |  | [NAME]: 1
 |  | Finančné operácie kapitoly ŠR za rok 2011
 |  | (v tis. eur)
 |  | Číslo a názov kapitoly štátneho rozpočtu: | 13 [NAME] spravodlivosti SR
 | Ek.kl. | Ukazovateľ | Schválený rozpočet | Upravený rozpočet | Skutočnosť | % k upravenému rozpočtu
 | I. | PRÍJMY spolu | 8832 | 8849 | 38653 | 436.8064188043847
 | 400 | Príjmy z transakcií s finančnými aktívami a finančnými pasívami | 8832 | 8849 | 38653 | 436.8064188043847
 |  | v tom: |  |  |  | 0
 | 410 | zo splátok tuzemských úverov, pôžičiek a návratných [NAME] ([NAME]) | 0 | 0 | 0 | 0
 | 420 | zo splátok zahraničných úverov, pôžičiek a návratných [NAME] ([NAME]) | 0 | 0 | 0 | 0
 | 430 | z predaja majetkových účastí | 0 | 0 | 0 | 0
 | 440 | z predaja privatizovaného majetku Fondu národného majetku Slovenskej republiky a Slovenského pozemkového fondu | 0 | 0 | 0 | 0
 | 450 | z [NAME] operácií | 8832 | 8849 | 38653 | 436.8064188043847
 | 500 | Prijaté úvery, pôžičky a návratné finančné výpomoci | 0 | 0 | 0 | 0
 | 510 | Tuzemské úvery, pôžičky a návratné finančné výpomoci | 0 | 0 | 0 | 0
 | 520 | [NAME] úvery, pôžičky a návratné finančné výpomoci | 0 | 0 | 0 | 0
 | II. | VÝDAVKY spolu | 36 | 38 | 38 | 100
 | 800 | Výdavky z transakcií s finančnými aktívami a finančnými pasívami | 36 | 38 | 38 | 100
 | 810 | Úvery, pôžičky, návratné finančné výpomoci, účasť na majetku a ostatné výdavkové operácie | 36 | 38 | 38 | 100
 | 820 | [NAME] istín | 0 | 0 | 0 | 0
 |  | v tom: |  |  |  | 0
 | 821 | [NAME] tuzemskej istiny | 0 | 0 | 0 | 0
 | 822 | [NAME], pôžičky a návratnej finančnej výpomoci do zahraničia | 0 | 0 | 0 | 0
 | 823 | splácanie istiny dlhodobého úveru, pôžičky a návratnej finančnej výpomoci do zahraničia | 0 | 0 | 0 | 0
 | 824 | [NAME] finančného prenájmu | 0 | 0 | 0 | 0
 | I.- II. | Prebytok (+), schodok (-) | 8796 | 8811 | 38615 | 438.2589944387697
Spreadsheet: 768609d1645041948-counting-cells-based-on-part_work_order-and-route_step_num-excel-question
Sheet: Sheet1

Part_Work_Order | Route_Step_Num | Cell |  |  |  | Cell: | Count:
1RRR | 3 | Saw1 |  | [NAME] would only count Saw1 once because the route_step_num 1 to 3 is in sequece with each other. |  | Saw1
1RRR | 5 | Inspection |  | So the count for Part_Work_Order would be 1 Saw1 & 1 Inspection. |  | Inspection
1RRR | 1 | Saw1 |  |  |  | Saw2
[NAME] | 2 | Saw1 |  | When looking at 2DDD Saw1 should be counted twice (2 times) because the route step goes 2,4,5,6,8. Step 4 (Inspections)is inbetween 2 and the 5,6,8. Because step 5,6,8 are all Saw1 in sequence it would only be counted as one. |  | Ground
[NAME] | 4 | Inspection |  |  |  | Ship
[NAME] | 5 | Saw1
[NAME] | 6 | Saw1
[NAME] | 8 | Saw1
[NAME] | 11 | Saw2
[NAME] | 12 | Saw2
[NAME] | 13 | Ground
[NAME] | 15 | Ground
[NAME] | 16 | Ship
3FFF | 2 | Ship
3FFF | 3 | Saw1
3FFF | 1 | Ship
3FFF | 5 | Saw1
3FFF | 8 | Inspection
3FFF | 9 | Ship
4GGG | 3 | Saw1
4GGG | 4 | Saw1
4GGG | 5 | Saw1
4GGG | 6 | Saw1
4GGG | 8 | Inspection
4GGG | 10 | Inspection
4GGG | 11 | Inspection
4GGG | 12 | Inspection
4GGG | 13 | Saw1
4GGG | 14 | Saw1
4GGG | 15 | Saw1
4GGG | 16 | Saw2
4GGG | 17 | Saw2
4GGG | 18 | Saw2
4GGG | 19 | Saw2
4GGG | 21 | Ground
4GGG | 22 | Ground
4GGG | 23 | Ship
Spreadsheet: 800241d1665557639-index-and-match-ref-error-cash-budget-template
Sheet: budget_listing

date | profit_center | category | amount
2020-01-01 00:00:00 |  | Advanced Payments
2020-01-01 00:00:00 |  | Progress Billing
2020-01-01 00:00:00 |  | Retention Payments
2020-01-01 00:00:00 |  | Other Collections
2020-01-01 00:00:00 |  | Labor
2020-01-01 00:00:00 |  | Plant and Equipment
2020-01-01 00:00:00 |  | Materials
2020-01-01 00:00:00 |  | Subcontractors
2020-01-01 00:00:00 |  | Temporaries
2020-01-01 00:00:00 |  | General Expense
2020-01-01 00:00:00 |  | Others
2020-01-01 00:00:00 |  | Internal Plant Billing - Internal Plant
2020-01-01 00:00:00 |  | Internal Plant Billing - RMCD/Concrete
Spreadsheet: sara_shackleton__36762__TVA - ISDA Master Swap Agreement Sheet
Sheet: ANEWSWP2

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY: | [NAME] x3-5620
DATE: |  | DEAL MAKER: | [NAME]  x3-3143
COUNTERPARTY: | Tennessee Valley Authority | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
Incorporation State | Corporate Agency of U.S. gvt | Moody's Rating | Aaa
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING) |  | Enron Corp. (BBB+/Baa1)
LIMIT $ MILLIONS |  | 40000000
Incorporation State
ELEGIBLE SWAP PARTICIPANT
Counterparty | X
Guarantor |  | X
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings | N/A | N/A
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash | X | X
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING
Delivery Amount
Return Amount
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty
-Guarantor
Debt Ratings Change
-Below = S&P/Moody's
Financial Covenants
-Funded Debt to Worth
-Minimum Net Worth
-EBITDA/Interest Expense
-Funded Debt / EBITDA
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | 100
-Guarantor ($[NAME]) |  | 100
Change in ownership
SPECIFIED ENTITY
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS:
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY:
Spreadsheet: 133492d1324420578-excel-2007-n-a-error-for-if-statement-with-vlookup-formula-test2-tristar-price-sheet
Sheet: IGU MAXIMUMS

Insulated Glass Unit
Maximums
3/8" Units - Tristar does not make
SSB Units | Annealed | Tempered
Long-side | 60"
United Inches | 80"
DSB Units
Long-side | 72" | 76"
United Inches | 106" | 106"
3/16" Units
Short-side | 72" | 80"
Long-side | 100" | 100"
United Inches | 140" | 155"
1/4" Units
Short-side | 84" | 84"
Long-side | 144" | 144"
United Inches | 168" | 176"
***Subject to availability on 144" glass***
Tempered [NAME] |  | United Inches
1/8" | 40 x 80 | 120"
5/32" | 50 x 84 | 130"
3/16" | 78 x 100 | 155"
1/4" | 84 x 144
3/8" | 84 x 120
1/2" | 84 x 120
Spreadsheet: 132520d1323799700-excel-2007-skipping-select-number-of-cells-when-autofiling-book1_runnerdiver
Sheet: Sheet1

A1 | A1 | A2 | A3
A2 | A4 | A5 | A6
A3 | A7 | A8 | A9
A4 | A10 | A11 | A12
A5 | A13 | A14 | A15
A6 | A16 | A17 | A18
A7 | A19 | A20 | A21
A8 | A22 | A23 | A24
A9 | A25 | A26 | A27
A10 | A28 | A29 | A30
A11
A12
A13
A14
A15
A16
A17
A18
A19
A20
A21
A22
A23
A24
A25
A26
A27
A28
A29
A30
Spreadsheet: 780588d1652576652-help-wanted-removing-false-return-when-linked-cell-is-blank-false-excel-problem-help-required-copy
Sheet: Job Setup

Quote No:                AVI | 2022- |  |  | Prepared By: | [NAME]
Date: |  |  |  | [NAME]:
Company: |  |  |  | Project/Contract:
Contact: |  |  |  | Job Suburb
Telephone: |  |  |  | ~ Start date:
ESTABLISHMENT No. | PAY ITEMS MILLING |  |  |  |  |  |  |  |  |  | MILLING PAY ITEM NOTES:
 |  | Area (m2) |  | Depth ([NAME]): |  | Spoil type: |  | Total Spoil (T):
 |  | Area (m2) |  | Depth ([NAME]): |  | Spoil type: |  | Total Spoil (T):
 |  | Area (m2) |  | Depth ([NAME]): |  | Spoil type: |  | Total Spoil (T):
 |  | Area (m2) |  | Depth ([NAME]): |  | Spoil type: |  | Total Spoil (T):
 |  | Area (m2) |  | Depth ([NAME]): |  | Spoil type: |  | Total Spoil (T):
 |  | Area (m2) |  | Depth ([NAME]): |  | Spoil type: |  | Total Spoil (T):
 |  | Area (m2) |  | Depth ([NAME]): |  | Spoil type: |  | Total Spoil (T):
 |  | Area (m2) |  | Depth ([NAME]): |  | Spoil type: |  | Total Spoil (T):
 |  | Area (m2) |  | Depth ([NAME]): |  | Spoil type: |  | Total Spoil (T):
 |  | Area (m2) |  | Depth ([NAME]): |  | Spoil type: |  | Total Spoil (T):
 |  | TOTAL AREA: |  |  |  |  | Total Tonnes to be milled:
ESTABLISHMENT No. | PAY ITEMS ASPHALT |  |  |  |  |  |  |  |  |  | ASPHALT PAY ITEM NOTES:
One | 1 | Area (m2): | 500 | Depth ([NAME]): | 50 | Asphalt Type | DG | Total AC (T):
Two | 2 | Area (m2): | 1000 | Depth ([NAME]): | 50 | Asphalt Type | DG | Total AC (T):
 |  | Area (m2): |  | Depth ([NAME]): |  | Asphalt Type |  | Total AC (T):
 |  | Area (m2): |  | Depth ([NAME]): |  | Asphalt Type |  | Total AC (T):
 |  | Area (m2): |  | Depth ([NAME]): |  | Asphalt Type |  | Total AC (T):
 |  | Area (m2): |  | Depth ([NAME]): |  | Asphalt Type |  | Total AC (T):
 |  | Area (m2): |  | Depth ([NAME]): |  | Asphalt Type |  | Total AC (T):
 |  | Area (m2): |  | Depth ([NAME]): |  | Asphalt Type |  | Total AC (T):
 |  | Area (m2): |  | Depth ([NAME]): |  | Asphalt Type |  | Total AC (T):
 |  | Area (m2): |  | Depth ([NAME]): |  | Asphalt Type |  | Total AC (T):
 |  | TOTAL AREA: |  |  |  |  | Total tonnes to be paved:
Spreadsheet: 25259d1216397641-printing-rows-with-true-values-in-them-blank-just-info
Sheet: Sheet1

Name | Address | Phone Number | [NAME] | Present | Sick | Absent
[NAME] | 315 Smith Road | [PHONE] | [EMAIL] | True
[NAME] | 246 Chance Road | [PHONE] | [EMAIL] |  | True
[NAME] | 754 Lance Street | [PHONE] | [EMAIL] |  |  | True