tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30653__9903_OA
Sheet: NE_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  NORTHEAST
 |  |  | Total |  | Reclasses |  |  |  |  |  | May |  |  |  |  |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  |  |  | 10500000 |  | -10500000
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  |  |  |  |  |  |  | 0 |  | 4527896
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  |  |  | 10250000
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-South East
 |  | Current Month MTM |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -42828 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: mary_fischer__25632__31N
Sheet: E31.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
RECONCILIATION OF STOCKHOLDERS' EQUITY AND INVESTMENT IN SUBS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
 |  |  |  | 12-31-00 Balance |  |  |  | EQUITY IN |  | DIVIDENDS DECLARED |  |  |  | OTHER ACTIVITY
 |  |  |  | DR  (CR) |  | RECLASS 2000 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 |  | -1000
Paid in Capital |  | 0910
Contribution Received from Parent |  | 0915
RE - Beg Bal |  | 0920 |  | 112694
RE - Net Income |  | 0930 |  |  |  |  |  | 736
RE - Net Income (Fair Value Adjustment) |  | 0931
Dividends Decl - Preferred Stock |  | 0935
Dividends Decl - Common Stock |  | 0941
Invest in Subs Plug Account |  | 0942
Total Shareholders' Equity |  | TOT_SHARE_EQU
Net Income |  | NET_INCOME
PARENT'S CO #
Investment in Consol Sub (on Parent Books) |  |  |  | Same signs as Hyperion
Investment in CS |  | 0215
Investment in PIC (contrib by parent) |  | 0216
Investment in Equity earnings of sub |  | 0217
Total Investment in Consol Sub
Equity in Consol Sub |  | 1505
Difference between SE (on sub) and Invest (on parent)
Reasons for Differences
A schedule will need to be prepared for each subsidiary.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
Spreadsheet: 486919d1477770540-select-random-product-stock-ids-product_list
Sheet: P_Pivot

Product Category | Product Name | Count of Sales Code | Count of Product ID |  |  | Best-selling products (First 2)
Beverages | Product F | 44 | 44 |  |  | Beverages > Product F, Product D
 | Product D | 33 | 33 |  |  | [NAME] B, Product C
 | Product E | 19 | 19
[NAME] | Product B | 79 | 79 |  |  | I need this: Five random Product Stock IDs for First two products for count of sales
 | Product C | 12 | 12
 | Product A | 10 | 10 |  |  | Product Category | Product Name | Product ID | Count of Sales Code
 |  |  |  |  |  | Beverages | Product F | DD00317 | 1
 |  |  |  |  |  |  |  | DD00323 | 1
 |  |  |  |  |  |  |  | DD00324 | 1
 |  |  |  |  |  |  |  | DD00325 | 1
 |  |  |  |  |  |  |  | DD00326 | 1
 |  |  |  |  |  |  | Product D | DD00256 | 1
 |  |  |  |  |  |  |  | DD00257 | 1
 |  |  |  |  |  |  |  | DD00258 | 1
 |  |  |  |  |  |  |  | DD00259 | 1
 |  |  |  |  |  |  |  | DD00260 | 1
 |  |  |  |  |  | [NAME] | Product C | DD00244 | 1
 |  |  |  |  |  |  |  | DD00245 | 1
 |  |  |  |  |  |  |  | DD00246 | 1
 |  |  |  |  |  |  |  | DD00247 | 1
 |  |  |  |  |  |  |  | DD00248 | 1
 |  |  |  |  |  |  | Product B | DD00194 | 1
 |  |  |  |  |  |  |  | DD00195 | 1
 |  |  |  |  |  |  |  | DD00196 | 1
 |  |  |  |  |  |  |  | DD00197 | 1
 |  |  |  |  |  |  |  | DD00198 | 1
Spreadsheet: 35098d1232618212-copying-hyperlinks-december-2008-excel-forum
Sheet: Week 2(a)

[NAME] по счетам группы компаний "Вагриус" |  |  |  |  |  |  | Week 2(a)
за период 8 - 12 Декабря  2008 года
[NAME] компании | Без Нал. | Нал. | Сумма
[NAME] | 0 | 0 | 0 |  |  | [NAME] | A5 | C11 | D11 | E11
Вагриус книги | 0 | 0 | 0 |  |  | Вагриус книги | A20 | C27 | D27 | E27
Вагриус правда | 0 | 0 | 0 |  |  | Вагриус правда | A36 | C43 | D43 | E43
Вагриус минус | 0 | 0 | 0 |  |  | Вагриус минус | A52 | C59 | D59 | E59
Плюс-минус | 0 | 0 | 0 |  |  | Плюс-минус | A68 | C75 | D75 | E75
Издательство Вагриус | 0 | 0 | 0 |  |  | Издательство Вагриус | A84 | C91 | D91 | E91
Вагриус плюс-минус | 0 | 0 | 0 |  |  | Вагриус плюс-минус | A100 | C107 | D107 | E107
Общий Итог: | 0 | 0 | 0 |  |  |  |  | C109 | D109 | E109
 |  |  |  |  |  | [NAME] | A122 | C129 | D129 | E129
 |  |  |  |  |  | Вагриус книги | A138 | C145 | D145 | E145
 |  |  |  |  |  | Вагриус правда | A154 | C161 | D161 | E161
Фактические РАСХОДЫ по счетам группы компаний "Вагриус" |  |  |  |  |  | Вагриус минус | A170 | C177 | D177 | E177
за период 8 - 12 Декабря  2008 года |  |  |  |  |  | Плюс-минус | A186 | C193 | D193 | E193
[NAME] компании | Без Нал. | Нал. | Сумма |  |  | Издательство Вагриус | A202 | C209 | D209 | E209
[NAME] | 0 | 0 | 0 |  |  | Вагриус плюс-минус | A218 | C225 | D225 | E225
Вагриус книги | 0 | 0 | 0 |  |  |  |  | C227 | D227 | E227
Вагриус правда | 0 | 0 | 0
Вагриус минус | 0 | 0 | 0
Плюс-минус | 0 | 0 | 0
Издательство Вагриус | 0 | 0 | 0
Вагриус плюс-минус | 0 | 0 | 0
Общий Итог: | 0 | 0 | 0
Spreadsheet: 190901d1351837815-how-to-start-a-scatter-chart-axis-values-from-different-figures-sales-vs-profit
Sheet: INPUT DATA SALES Vs PROFIT

 | $ 000'S
 |  | ACTUAL | BUDGET | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST
 |  | 2011/12 | 2012/13 | 2013/14 | 2014/15 | 2015/16 | 2016/17 | 2017/18
 | Sales | 24599 | 28737 | 26913 | 28345 | 31301 | 34295.48 | 37649.29760000001
 | Profit/(Loss) | 1675 | 1237 | 751 | 893 | 1973 | 3501.080000000002 | 5315.177600000003
Spreadsheet: bdcfb162-5eff-4e0d-b18d-ec0e0d311dcd
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-12-21 09:20:56.820000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.709 | 101.584 | 101.459 | 101.084
4.25 | 101.26 | 101.135 | 101.01 | 100.635 |  | Note: | Refer To Price [NAME]
4.125 | 100.817 | 100.692 | 100.567 | 100.192 |  |  | For all Price Adjs
4 | 100.376 | 100.251 | 100.126 | 99.501
3.875 | 99.817 | 99.692 | 99.567 | 98.942
3.75 | 98.968 | 98.843 | 98.718 | 98.093
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.875 | 101.75 | 101.625 | 101.25
3.75 | 101.449 | 101.324 | 101.199 | 100.824
3.625 | 101.165 | 101.04 | 100.915 | 100.54
3.5 | 100.851 | 100.726 | 100.601 | 100.226
3.375 | 100.446 | 100.321 | 100.196 | 99.571
3.25 | 99.894 | 99.769 | 99.644 | 99.019
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-01-04 09:20:56.820000
30 DAY | 2012-01-19 09:20:56.820000
45 DAY | 2012-02-03 09:20:56.820000
60 DAY | 2012-02-18 09:20:56.820000
90 DAY | 2012-03-19 09:20:56.820000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 832588d1686460011-help-with-a-formula-in-a-timecard-timecard-sample-1-ans
Sheet: Sheet1

Day | Date | Holiday | Stat | Start | End | Total Hrs Wrkd | REG | TAH | DT
Sun
Mon
Tue | 2023-04-07 00:00:00 |  |  | 07:00:00 | 21:00:00
Wed
Thu
Fri | 2023-04-07 00:00:00 |  | y | 07:00:00 | 21:00:00
Sat
Total
Spreadsheet: 770660d1646217718-plan-with-saudi-weekdays-pmo-establishment-plan-1-
Sheet: GanttChart

 | Title
 | Project Start Date | 2022-03-06 00:00:00 |  |  |  | Display Week | 2
 | Project Lead | TBC
 |  |  |  |  |  |  |  |  |  | 2022-03-06 00:00:00
WBS | TASK | LEAD | PREDECESSOR | START | END | DAYS | % DONE | WORK DAYS
 | PMO Framework
1 | Define aims / ambition of PMO
2 | Document Roles & Responsibilities
3 | Define PMO & Project Operational structure
4 | Define lifecycle process
5 | PMO Governance / Assurance
6 | Monitor & Control
7 | Operational standards
2 | Risk Management
1 | Establish scope (Project vs Programme vs Corporate)
2 | Document high level Risk Management strategy
3 | Build Risk & Issue Log
4 | Workshop with SMEs to populate
5 | Establish reporting process
3 | Planning
1 | Agree planning requirements
2 | Produce Plan template
3 | Workshop with SMEs to populate
4 | Identify milestones
5 | Generate milestone report / tracker
4 | Reporting
1 | Identify minimum information required
2 | Identify information owners
3 | Define information input / output
4 | Agree dashboard format
5 | Establish reporting process
6 | Establish Quality Assurance mechanism
7 | Introduce reports in a phased manner
5 | [NAME]
1 | Review all templates provided
2 | Document key metrics and information we need
3 | Identify owners of this information
4 | Identify report generators
5 | RAID
6 | RACI
7 | Finance Tracker
8 | Benefits [NAME]
9 | Project Plan
10 | Resoruce tracker
11 | [NAME]
12 | [NAME]
13 | Quality Register
14 | Continous Improvement register
15 | Dependency Map
16 | Stakeholder map
17 | Information Management map
18 | Demand / Pipeline register
19 | Change Register
20 | Comms Register
21 | Business Case
22 | Project Charter / Brief
23 | Closure Report
24 | Report template
25 | Dependency Plan
Spreadsheet: 144338d1330936564-rolling-live-calendar-from-existing-one-dynamic-1yr-v4
Sheet: Schedule

 |  |  |  |  |  |  | [NAME]
1: Enter Days between shuts in the Yellow section
2: To see a summary, Click the dropdown box, and uncheck the (Blanks) box, then 'OK'     NB: This will contract to the smallest number if multiple searches are run.
3: To enter a fixed date, enter [NAME] in the cell, and Programmed Shuts will recalculate from that date onwards
4: To adjust the date highlight Cell A11 and override
5: To extend the calender dates, copy the bottom row downwards
Plant area |  |  | FIM SAG |  | FIM BALL 1 |  | FIM BALL 2 |  | FIM SAG GIRTH GEAR |  | MTC SAG |  | MTC BALL |  | UFG |  | Roaster 1 |  | Roaster 2
Frequency (Days) |  |  | 30 |  | 35 |  | 20 |  | 100 |  | 30 |  | 60 |  | 28 |  | 200 |  | 200
2012-03-01 00:00:00
Spreadsheet: 59624d1260217146-excel-2007-checking-a-range-of-dates-with-if-or-select-case-example1
Sheet: TA2008-25

FLEXIBLE SCHEDULE CERTIFICATION FORM
NAME: |  |  |  |  |  |  |  |  |  |  |  | Established Hours:
 |  |  |  |  |  |  |  |  |  |  |  | M |  |  | M:
ORG: |  |  |  |  |  |  |  |  |  |  |  | T: |  |  | T:
 |  |  |  |  |  |  |  |  |  |  |  | W |  |  | W:
PP Ending: |  |  |  |  |  |  |  |  |  |  |  | T: |  |  | T:
 |  | PP | 08-25 |  |  |  |  |  |  |  |  | F: |  |  | F:
 |  | Working Hours |  | Time in Duty Status |  |  |  | *Telework Hours |  | Credit Hours |  |  | [NAME]
Date |  | Arrive | [NAME] | Regular | Overtime | Comp | Holiday | Worked | Code | Earned | Used | Balance | Annual | Sick | Comp | LWOP | Other | Remarks
Previous Balance |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
S
M
T
W
T |  | Thanksgiving
F
S
S
M
T
W
T
F
S
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL PAYABLE HRS.
Totals
 | Employee Signature: |  |  |  |  |  |  |  |  |  | Supervisor Signature:
 |  |  |  |  |  |  |  |  |  |  |  | *Telework Indicator Codes
 |  |  |  |  |  |  |  |  |  |  |  | Code |  | "Fixed" Telework Agreement
 |  |  |  |  |  |  |  |  |  |  |  | C | 3 or more days per week at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | F | 2 or fewer days per week at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | Code |  | “As Needed” Telework Agreement
 |  |  |  |  |  |  |  |  |  |  |  | I | Work performed at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | The Telework columns are to be left blank for those employees who did not work at an alternate worksite during the Pay Period.
MOST EMPLOYEES SHOULD HAVE NO BALANCE IN LWOP.
Spreadsheet: 40846d1239226590-how-do-i-get-a-date-cell-to-update-all-data-on-worksheet-excell-date-problem
Sheet: Tank Capacities

TANK CAPACITIES
Tank # |  | Nominal Capacity | Bottom Unusable Capacity | Top Unusable Space |  | Usable Capacity | Safe Fill
40 | Barrels | 130000 | 8922 | 15729 |  | 105746 | 114271
 | Gallons | 5460000 | 374724 | 660618 |  | 4441332 | 4799382
41 | Barrels | 130000 | 9186.619047619048 | 16874 |  | 103382 | 113126
 | Gallons | 5460000 | 385838 | 708708 |  | 4342044 | 4751292
51 | Barrels | 130000 | 11563.35714285714 | 12752 |  | 105702 | 117248
 | Gallons | 5460000 | 485661 | 535584 |  | 4439484 | 4924416
57 | Barrels | 80000 | 5735.095238095239 | 10616 |  | 63241 | 69384
 | Gallons | 3360000 | 240874 | 445872 |  | 2656122 | 2914128
 | Barrels | 470000 | 35407.07142857143 | 55971 | 0 | 378071 | 414029
 | Gallons | 19740000 | 1487097 | 2350782 |  | 15878982 | 17389218
C
 |  | Nominal Capacity | Allocated Bottoms | Allocated Tops |  | Usable | Maximum Physical
Barrels |  | 120000 | 9040.103343465045 | 14290.46808510638 |  | 96669.42857142858 | 105709.5319148936
Gallons |  | 5040000 | 379684.3404255319 | 600199.659574468 |  | 4060116 | 4439800.340425532
B
 |  | Nominal Capacity | Allocated Bottoms | Allocated Tops |  | Usable | Maximum Physical
Barrels |  | 130000 | 9793.4452887538 | 15481.34042553191 |  | 104725.2142857143 | 114518.6595744681
Gallons |  | 5460000 | 411324.7021276596 | 650216.2978723404 |  | 4398459 | 4809783.70212766
A
 |  | Nominal Capacity | Allocated Bottoms | Allocated Tops |  | Usable | Maximum Physical
Barrels |  | 230000 | 17326.86474164134 | 27390.06382978723 |  | 185283.0714285714 | 202609.9361702128
Gallons |  | 9660000 | 727728.3191489362 | 1150382.680851064 |  | 7781888.999999999 | 8509617.319148935
Spreadsheet: 70e1fe89-6269-4b63-a65b-519e9bacf226
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2
Quelle: http://ergebnisse.vimentis.ch/
Frage:
[NAME] müssen gleich behandelt werden wie private [NAME] (sie erhalten keine [NAME] öffentlichen Hand und können [NAME] gehen).
 | [NAME]?
Antwort | Ja | [NAME]
[NAME] | 0.28 | 0.23
[NAME] | 0.63 | 0.65
Neutral / Weiss nicht | 0.1 | 0.12
Angaben zu den [NAME]
Erhebungsjahr | 2010
Stichprobengrösse | 29292
Erhebungszeitraum | 02.10.2010 bis: 06.12.2010
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 771686d1646795120-assistance-with-2-spreadsheets-and-a-3rd-tally-spreadsheet-sample2
Sheet: Sheet1

ImportIdentifier | FormGroup | FirstName | PreferredName | MiddleName | Surname | Full Name |  | YearLevel | [NAME]
AAAA0001 | 15A | [NAME] | [NAME] |  | DOUGH | [NAME] |  | 15 | [EMAIL]
AAAA0002 | 15B | [NAME] | [NAME] |  | DOUGH | [NAME] |  | 16 | [EMAIL]
AAAA0003 | 15C | JACK | JACK |  | DOUGH | JACK DOUGH |  | 15 | [EMAIL]
Spreadsheet: darron_c_giron__7923__Expedition
Sheet: Eddie Bauer 4X4

 |  | Expedition Eddie Bauer 4X4
 |  | Invoice | MSRP |  | TMV
 | Base | 36004 | 41085 |  | 36654
 | Eddie Bauer Premier Group | 676 | 795 |  | 699
 | Entertainment System | 1143 | 1345 |  | 1181
 | Entertainment System Discount | -1143 | -1345 |  | -1181
 | Load Leveling Suspension | 692 | 815 |  | 707
 | Skid Plate Package | 89 | 105 |  | 91
 | Destination | 740 | 740 |  | 740
 | Over Invoice | 500 |  |  | 0
 | Tax
 | Title | 100 |  |  | 100
 | License | 50 |  |  | 50
 | Ford Citibank | -860 |  |  | -860
 | Driver Edge Citibank | -1087 |  |  | -1087
 | Down Payment | -2200 |  |  | -2200
 | Payment
 | Interest Rate | 0.07 |  |  | 0.07
 | Months | 60 |  |  | 60
Spreadsheet: 377503d1424025896-filtering-data-after-summing-up-in-pivot-table-details
Sheet: Pivot Table

Pivot Table |  |  |  |  |  | Expected Result
Row Labels | Max of Code | Sum of Amount |  |  |  | Name | Code | Amount
ABC | 560002 | 148842 |  |  |  | ABC | 560002 | 148842
[NAME] | 560032 | 2300 |  |  |  | [NAME] | 4390867 | 30230
Dev | 562032 | 6700 |  |  |  | Olive oil | 34008 | 56000
[NAME] | 4390867 | 30230
Olive oil | 34008 | 56000
Grand Total | 4390867 | 244072
Spreadsheet: 888287d1738778543-summary-of-data-ezdizzy
Sheet: Blad1

 | 500 | red |  |  |  |  | red |  |  |  | =IFERROR(LET(x,UNIQUE(B3:B12),HSTACK(x,DROP(REDUCE("",x,LAMBDA(y,z,VSTACK(y,TOROW(FILTER(C3:C12,z=B3:B12))))),1))),"")
 | 501 | green |  |  |  | 501 | green
 | 502 | red |  |  |  | 502 | red | red
 | 502 | red |  |  |  | 504 | purple | red | blue
 | 504 | purple |  |  |  | 505 | green
 | 504 | red |  |  |  | 506 | yellow
 | 504 | blue |  |  |  | 507 | black
 | 505 | green
 | 506 | yellow
 | 507 | black
 |  |  |  |  |  |  | red
 |  |  |  |  |  | 501 | green
 |  |  |  |  |  | 502 | red; red
 |  |  |  |  |  | 504 | purple; red; blue
 |  |  |  |  |  | 505 | green
 |  |  |  |  |  | 506 | yellow
 |  |  |  |  |  | 507 | black
Spreadsheet: 179104d1347029907-can-an-empty-cell-be-set-to-flash-staff-sample
Sheet: Sheet1

Week Commencing 10/09/12 |  | TBC
MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] | CLOSED
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] | CLOSED
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] | CLOSED
 | [NAME] |  | [NAME] |  | CLOSED
Spreadsheet: 110664d1307283293-calculate-difference-between-2-dates-in-6hr-increments-excluding-holidays-weekends-example
Sheet: SPOC Tickets

Start Date | End Date | Lead time (hrs) | Holidays
2011-03-29 00:00:00 | 2011-04-01 00:00:00 | 24 | 2011-01-01 00:00:00
2011-03-28 00:00:00 | 2011-03-28 00:00:00 | 6 | 2011-03-21 00:00:00
2011-03-29 00:00:00 | 2011-03-29 00:00:00 | 6 | 2011-04-22 00:00:00
2011-03-30 00:00:00 | 2011-03-30 00:00:00 | 6 | 2011-04-25 00:00:00
2011-03-30 00:00:00 | 2011-03-30 00:00:00 | 6 | 2011-04-27 00:00:00
2011-02-15 00:00:00 | 2011-03-29 00:00:00 | 258 | 2011-05-01 00:00:00
2011-03-28 00:00:00 | 2011-03-28 00:00:00 | 6 | 2011-05-02 00:00:00
2011-03-29 00:00:00 | 2011-03-29 00:00:00 | 6 | 2011-05-18 00:00:00
2011-03-28 00:00:00 | 2011-03-28 00:00:00 | 6 | 2011-06-16 00:00:00
2011-04-01 00:00:00 | 2011-04-01 00:00:00 | 6 | 2011-08-09 00:00:00
2011-03-31 00:00:00 | 2011-03-31 00:00:00 | 6 | 2011-09-24 00:00:00
2011-03-31 00:00:00 | 2011-03-31 00:00:00 | 6 | 2011-12-16 00:00:00
2011-03-31 00:00:00 | 2011-03-31 00:00:00 | 6 | 2011-12-25 00:00:00
2011-03-30 00:00:00 | 2011-03-30 00:00:00 | 6 | 2011-12-26 00:00:00
2011-04-05 00:00:00 | 2011-04-04 00:00:00 | 0
2011-04-05 00:00:00 | 2011-04-05 00:00:00 | 6
2011-04-05 00:00:00 | 2011-04-05 00:00:00 | 6
2011-04-01 00:00:00 | 2011-04-05 00:00:00 | 30
2011-04-06 00:00:00 | 2011-04-06 00:00:00 | 6
2011-04-07 00:00:00 | 2011-04-07 00:00:00 | 6
2011-04-05 00:00:00 | 2011-04-05 00:00:00 | 6
2011-04-06 00:00:00 | 2011-04-06 00:00:00 | 6
2011-01-12 00:00:00 | 2011-04-06 00:00:00 | 510
2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 6
2011-04-04 00:00:00 | 2011-04-04 00:00:00 | 6
2011-04-06 00:00:00 | 2011-04-06 00:00:00 | 6
2011-03-22 00:00:00 | 2011-04-06 00:00:00 | 96
Spreadsheet: 106629d1303850144-pivot-table-calculated-field-ptcalcfield
Sheet: Sheet1

Date | Wk# | Sold
 |  |  |  |  | Row Labels | Sum of Sold | Sum of ToGo
 |  |  |  |  | 3 | 2 | 198
 |  |  |  |  | 4 | 24 | 176
 |  |  |  |  | 5 | 29 | 171
 |  |  |  |  | 6 | 23 | 177
 |  |  |  |  | 7 | 22 | 178
 |  |  |  |  | 8 | 27 | 173
 |  |  |  |  | 9 | 23 | 177
 |  |  |  |  | 10 | 23 | 177
 |  |  |  |  | 11 | 28 | 172
 |  |  |  |  | 12 | 31 | 169
 |  |  |  |  | 13 | 25 | 175
 |  |  |  |  | 14 | 34 | 166
 |  |  |  |  | 15 | 16 | 184
 |  |  |  |  | 16 | 32 | 168
 |  |  |  |  | 17 | 25 | 175
 |  |  |  |  | 18 | 7 | 193
 |  |  |  |  | Grand Total | 371 | -171
Spreadsheet: 841858d1693998879-splitting-amount-in-months-prepayments
Sheet: Prepayments

 |  |  |  |  |  |  | 2023-06-30 00:00:00 |  |  |  | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30
 | Sr. No. | Date | Policy number | Description | Start date | End date | Closing Prepaid days | Opening | Addition/(Deletion) | Total | July | August | September | October | November | December | January | February | March | April | May | June | Pre Paid FTY
 | Insurance Prepaid
 | 1 |  | 03-2108-PO-FIR-FAPT-L-000154 |  | 2022-08-17 00:00:00 | 2023-08-16 00:00:00 |  | 0 | 6761.046575342466
 |  |  | 03-2202-PO-FIR-FAPT-D-000179 |  | 2022-08-23 00:00:00 | 2023-08-22 00:00:00 |  | 0 | 33439.51506849315
 |  |  | 2022-10-305-F01501DP0000059 |  | 2022-10-05 00:00:00 | 2023-10-04 00:00:00 |  | 0 | 192357.1726027397
 |  |  | 03-2301-PO-MRN-ITAT-D-000001 |  | 2023-01-15 00:00:00 | 2024-01-14 00:00:00 |  | 0 | 383528.7123287671
 |  |  | 03-2301-PO-FIR-FAPT-L-000024 |  | 2023-01-25 00:00:00 | 2024-01-24 00:00:00 |  | 0 | 68281.55616438357
 |  |  | PMD (56) (CN-40) |  | 2023-03-05 00:00:00 | 2024-03-03 00:00:00 |  | 0 | 537709.5260273973
 |  |  | PMD (59) (CN-20) |  | 2023-02-28 00:00:00 | 2024-02-27 00:00:00 |  | 0 | 94771.17808219178