tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mary_fischer__25634__31Q
Sheet: E36.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  031Q
COMPANY NAME    Limbach Constructors
EQUITY INVESTEE'S SUMMARIZED INFORMATION
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  | E-36
NAME OF INVESTEE:
% OF OWNERSHIP:
THIS E-SCHEDULE IS REQUIRED FOR ALL OWNED EQUITY INVESTEES.
Please note the relationship and the differences between the E-3 (Analysis of Investment in Unconsolidated Equity Subsidiaries) and the E-36 (Equity
Investee's Summarized Information).  The E-3 seeks details of the Enron consolidating subsidiaries' (i.e. the investor) investment account.  The E-36
seeks summarized income statement and balance sheet information of the unconsolidated subsidiary (i.e. the investee).
If an E-3 has been prepared for an equity investment, then an E-36 for the related in investee needs to be completed.
Include all investees, regardless of Enron's ownership interest.
PLEASE PROVIDE THE FOLLOWING SUMMARIZED FINANCIAL INFORMATION AS IT
WOULD APPEAR IN THE INVESTEE'S FINANCIAL STATEMENTS (100%).
 |  |  |  | BALANCE AT
BALANCE SHEET (100%) |  |  |  | END OF QUARTER
CURRENT ASSETS |  |  |  | 0
PROPERTY, PLANT AND EQUIPMENT, NET. |  |  |  | 0
OTHER NONCURRENT ASSETS |  |  |  | 0
CURRENT LIABILITIES |  |  |  | 0
LONG-TERM DEBT |  |  |  | 0
ADVANCES FROM ENRON COMPANIES |  |  |  | 0
OTHER NON-CURRENT LIABILITIES |  |  |  | 0
OWNERS' EQUITY |  |  |  | 0
Memo:
AMOUNT RECEIVABLE FROM ENRON (included above) |  |  |  | 0
AMOUNT PAYABLE TO ENRON (included above) |  |  |  | 0
INVESTMENT IN UNCONSOLIDATED
EQUITY INVESTEE
(must tie to Hyperion acct TOT_INVEST_SUBS & E-3) |  | 0
Asset/Expense Accts:  DR/(CR)
INCOME STATEMENT (100%) |  |  |  | YEAR-TO-DATE
OPERATING REVENUES |  |  |  | 0
OPERATING EXPENSES |  |  |  | 0
GROSS INTEREST EXPENSE (3rd Party Only) |  |  |  | 0
OTHER INCOME & DEDUCTIONS |  |  |  | 0
INCOME TAXES |  |  |  | 0
NET INCOME
INVESTMENT IN NET INCOME
(must tie to Hyperion acct TOT_EQEARN_OTH & E-3) |  | 0
Income Accts:  DR/(CR)
Memo:
CAPITALIZED INTEREST |  |  |  | 0
RENTAL EXPENSE |  |  |  | 0
 |  |  |  | E-36
Spreadsheet: 328460d1403901666-complex-if-formula-using-timestamp-allocation-of-meal-tickets-edit
Sheet: June 14

 | Allocation of Meal Tickets
Time Stamp for Formatting | Ticket No: | Name of person ticket issued to | Ticket holders name | Quantity | Course and Code | Date Required | Budget Code | signed by (receptionist)
 | ie MAY01 | [NAME] | ie Student X / [NAME] | x1 | [NAME] | 1st May 2013 | RTJ | L Foster |  |  |  |  | Cost Centre: |  |  |  |  | Cost Centre:
 | 1950-06-01 00:00:00 | [NAME] | [NAME] | x1 | [NAME] | 20th June | RTK | M Davis
 | 1951-06-01 00:00:00 | [NAME] | [NAME] | X1 | [NAME] | 20th June | RTK | M Davis
 | 1952-06-01 00:00:00 | [NAME] | [NAME] | x1 | [NAME] | 25th June | RTK | P Tarrant |  | Lunch Only |  |  | Authorised By: |  | Lunch Only |  |  | Authorised By:
 | 1953-06-01 00:00:00 | [NAME] | [NAME] | x1 | [NAME] | 25th June | RTK | P Tarrant |  | Date Valid: |  |  |  |  | Date Valid:
 | 1954-06-01 00:00:00 | [NAME] | [NAME] | x1 | First Aid | 24th June | ESF | P Tarrant |  | Course: |  |  |  |  | Course:
 | 1955-06-01 00:00:00 | [NAME] | [NAME] | x1 | First Aid | 24th June | ESF | P Tarrant |  | Name: |  |  | Number: |  | Name: |  |  | Number:
 |  |  |  |  |  |  |  |  |  |  |  |  | Cost Centre: |  |  |  |  | Cost Centre:
 |  |  |  |  |  |  |  |  |  | Lunch Only |  |  | Authorised By: |  | Lunch Only |  |  | Authorised By:
 |  |  |  |  |  |  |  |  |  | Date Valid: |  |  |  |  | Date Valid:
 |  |  |  |  |  |  |  |  |  | Course: |  |  |  |  | Course:
 |  |  |  |  |  |  |  |  |  | Name: |  |  | Number: |  | Name: |  |  | Number:
 |  |  |  |  |  |  |  |  |  |  |  |  | Cost Centre: |  |  |  |  | Cost Centre:
 |  |  |  |  |  |  |  |  |  | Lunch Only |  |  | Authorised By: |  | Lunch Only |  |  | Authorised By:
 |  |  |  |  |  |  |  |  |  | Date Valid: |  |  |  |  | Date Valid:
 |  |  |  |  |  |  |  |  |  | Course: |  |  |  |  | Course:
 |  |  |  |  |  |  |  |  |  | Name: |  |  | Number: |  | Name: |  |  | Number:
Spreadsheet: 828492d1683554438-pull-multiple-data-table-based-on-specific-value-test-68-aligw
Sheet: Weekly Reports

Customer | WK1 | WK2 | WK3 | WK4 | WK5 | WK6 | WK7 | WK8 | WK9 | WK10 | WK11 | WK12 | WK13 | WK14 | WK15 | WK16 | WK17 | WK18 | WK19 | WK20 | WK21 | WK22 | WK23 | WK24 | WK25 | WK26 | [NAME] | WK28 | WK29 | WK30 | WK31 | WK32 | WK33 | WK34 | WK35 | WK36 | WK37 | WK38 | WK39 | WK40 | WK41 | WK42 | WK43 | WK44 | WK45 | WK46 | WK47 | WK48 | WK49 | WK50 | WK51 | WK52 | Total Completed | Total Since Onboarding | Compliance %
Cranswick | N | N | Y | Y | Y | Y | Y | Y | Y | N | N | Y | Y | Y | N | Y | Y
Öresundschark |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y | Y | Y
Pascal Processing |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N | Y | Y | N
Moy Park [C] |  |  |  |  |  |  |  |  |  |  |  |  |  | Y | Y | Y | Y | Y
Moy Park [G] |  |  |  |  |  |  |  |  |  |  |  |  |  | Y | Y | Y | Y | Y
Salpa |  |  |  |  |  |  |  |  |  |  |  | Y | Y | Y | N | Y | Y | Y
Nowel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
Test | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y | Y | Y | Y | Y
Total
Spreadsheet: 869808d1716371728-countif-cannot-sort-number-from-largest-to-smallest-properly-excel-forum-countif
Sheet: Roster

Staff No | 2024-05-01 00:00:00 | 2024-05-02 00:00:00 | 2024-05-03 00:00:00 | 2024-05-04 00:00:00 | 2024-05-05 00:00:00 | 2024-05-06 00:00:00 | 2024-05-07 00:00:00 | 2024-05-08 00:00:00 | 2024-05-09 00:00:00 | 2024-05-10 00:00:00 | 2024-05-11 00:00:00 | 2024-05-12 00:00:00 | 2024-05-13 00:00:00 | 2024-05-14 00:00:00 | 2024-05-15 00:00:00
123456 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 第 1 欄 | 第 1 欄 |  |  | 第 1 欄 |  | 第 1 欄 | 第 1 欄 | 第 1 欄 |  |  | 第 1 欄 |  | 第 1 欄 | 第 1 欄 | 第 1 欄
123457 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 第 1 欄 |  |  |  | 第 1 欄 | 第 1 欄 | 第 1 欄 |  |  | 第 1 欄 | 第 1 欄 |  |  |  | 第 1 欄 | 第 1 欄 | 第 1 欄
123458 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 第 1 欄 | 第 1 欄 | 第 1 欄 | 第 1 欄 | 第 1 欄 | 第 1 欄 |  | 第 1 欄 | 第 1 欄 | 第 1 欄 |  | 第 1 欄 | 第 1 欄 |  | 第 1 欄 | 第 1 欄 | 第 1 欄
123459 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 第 1 欄 |  | 第 1 欄 | 第 1 欄 | 第 1 欄 | 第 1 欄 |  |  |  |  | 第 1 欄 | 第 1 欄 | 第 1 欄 |  |  |  | 第 1 欄
123460 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 第 1 欄 | 第 1 欄 | 第 1 欄 | 第 1 欄 | 第 1 欄 | 第 1 欄
234567 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 第 1 欄 | 第 1 欄 | 第 1 欄 |  | 第 1 欄 |  |  |  |  |  |  |  |  |  | 第 1 欄
234568 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 第 1 欄 | 第 1 欄 | 第 1 欄 | 第 1 欄 | 第 1 欄 |  |  | 第 1 欄 | 第 1 欄 |  | 第 1 欄 | 第 1 欄 |  |  | 第 1 欄 | 第 1 欄 | 第 1 欄
234569 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 第 1 欄 | 第 1 欄 | 第 1 欄 | 第 1 欄 | 第 1 欄 | 第 1 欄 | 第 1 欄 |  |  |  |  |  |  |  |  | 第 1 欄 | 第 1 欄
234570 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 第 1 欄 |  |  |  |  |  |  |  | 第 1 欄 | 第 1 欄 | 第 1 欄 |  | 第 1 欄 |  | 第 1 欄 |  | 第 1 欄
312324 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 第 1 欄 |  |  | 第 1 欄 | 第 1 欄 |  |  | 第 1 欄 | 第 1 欄 | 第 1 欄 | 第 1 欄 | 第 1 欄
312325 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 第 1 欄 | 第 1 欄 | 第 1 欄 |  | 第 1 欄 |  |  | 第 1 欄 | 第 1 欄 |  | 第 1 欄 | 第 1 欄 |  |  | 第 1 欄 | 第 1 欄 | 第 1 欄
312326 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 第 1 欄 |  | 第 1 欄 | 第 1 欄 | 第 1 欄 |  | 第 1 欄 | 第 1 欄 | 第 1 欄 |  | 第 1 欄 | 第 1 欄 | 第 1 欄 |  | 第 1 欄 | 第 1 欄 | 第 1 欄
312327 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 第 1 欄 |  |  |  |  | 第 1 欄 |  |  | 第 1 欄 |  |  |  |  |  | 第 1 欄
312328 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 第 1 欄 | 第 1 欄 | 第 1 欄 |  |  |  |  | 第 1 欄 | 第 1 欄 | 第 1 欄 |  |  | 第 1 欄 | 第 1 欄 | 第 1 欄
312329 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 第 1 欄 |  | 第 1 欄 |  |  |  |  |  |  | 第 1 欄 | 第 1 欄 | 第 1 欄 |  |  | 第 1 欄 |  | 第 1 欄
330011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 第 1 欄 | 第 1 欄 | 第 1 欄 |  | 第 1 欄 | 第 1 欄 |  | 第 1 欄 | 第 1 欄 | 第 1 欄
330022 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 第 1 欄 | 第 1 欄 |  |  |  |  |  | 第 1 欄 | 第 1 欄
Spreadsheet: darrell_schoolcraft__7334__imball0203
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 | 13 |  | -666
2 | 12 |  | -3300
3 |  |  | -3941
4 |  |  | -3861
5 |  |  | -3809
6 |  |  | -3887
7 |  |  | -3882
8 |  |  | -1118
9
10
11 | 679
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  |  |  | 178356.43
2002-03-11 00:00:00
CBS Volume
 |  |  | -355979
Spreadsheet: 876152d1722846252-need-formula-for-tier-incentive-calculation-calculation-doing-formula
Sheet: Dr. Omar Al Fouda 1

 |  |  | Total Revenue
 |  |  | Consumables
 |  |  | The Clinics OR Fees
 |  |  | Hospital Fees
 |  |  | Total
 |  |  | Dr. [NAME]
 |  |  | Lab Revenue | 565
 |  |  | Lab 10%
 |  |  | Net Payment
 |  |  | Service | Amount | OHE | % | Comm. % | Comm.
 |  |  | Consultation | 2000 | 0.05 |  | 0.55
 |  |  | Procedure | 2500 | 0.05 |  | 0.55
 |  |  | OR In the Clinics | 14735 | 0.05 |  | 0.55
 |  |  | OR Outside the Clinics | 0 | 0.05 | 0 | 0.65
 |  |  | Other Exp.
 |  |  | Marketing (50-50) | 0
 |  |  |  |  | Doctor [NAME] ……………
 |  |  |  |  |  |  |  |  |  |  |  | Operations Report on May- 2019
 |  |  |  |  |  |  |  |  |  |  |  | # | Day/Date | Time | Patient Name and file number |  | [NAME] | Price | Surgeon | Anesthesia |  | OR
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 2019-05-30 00:00:00 | At 12:00 pm he tooks           35 mins | Conor [NAME] 10052203 |  | vaser lipo double chin | 14735 | Dr [NAME] | IV sedation + local | 2000 | 2000
Spreadsheet: 866500d1713432520-a-formula-to-select-the-highest-cell-in-a-column-that-then-shows-the-entire-row-walks
Sheet: 2021

 |  |  |  |  |  |  |  |  |  | 2021
 |  |  |  |  |  |  |  |  |  |  | Number   of       Walks | Total   Miles | Total Height  Feet | Total   Hours  Walked | Average Speed   mph
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Jake
 |  |  |  |  |  |  |  |  |  | Eleanor
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 211056d1359645268-help-row-into-column-another-sheet-dee2_version1
Sheet: SOC

Sl.No | Name | FA(a) | FA(b) | FA(a+b) | SA
1 |  | 14 | 13 | 27 | 45
Spreadsheet: 153731d1336032009-vlookup-with-more-than-1-condition-example
Sheet: Sheet2

Client name | ID | Type | Location
a | 1 | a | a
b | 2 | b | b
c | 3 | a | c
d | 4 | b | d
Spreadsheet: 97781d1296857980-problem-with-sumif-sumif-problem
Sheet: Sheet1

Ln. | ID | Sheet | [NAME].
1 | TR001 | Sheet2
2 | TR002 | Sheet2
3 | [NAME] | Sheet2
4 | TR004 | Sheet3 |  | should be 1
5 | [NAME] | Sheet3 |  | should be 3
6 | TR006 | Sheet3 |  | should be 6
Column D is my problem.
The equation only returns the line number from ID's found on Sheet2 (Of course).
ID's found on Sheet 3 return a zero because the ID's are not located on Sheet 2.
I would like the equation to be able to return the line number from either sheet based on the ID.
I will be using this equation on a workbook with approximately 30 sheets, with more being added.
As VBA is not allowed for this project, how can I work the Excel equation?
Original equation |  |  | =SUMIF(Sheet2!$B$2:$B$12,B2,Sheet2!$A$2:$A$12)
My idea (doesn't work) |  |  | =SUMIF(C2!$B$2:$B$12,B2,C2!$A$2:$A$12)  where C2 is a cell with the desired sheet name.
Spreadsheet: 739613d1625823145-index-match-or-other-formula-to-copy-cells-until-next-value-example-43-ans
Sheet: Sheet1

PROJECTNUMBER | ItemNumber | ItemDescription/ProjectLocation | Date | Unit/Quantity | Engr.EST. | AverageBid | AwardedBid |  |  | HELPER column
 | 20100000 | Clear and [NAME] |  | LUMPSUM | =============== | ================ | ================ |  |  |  | NOTE: Assuming item numbers are in assending order as given in this file.
FSA0253262 |  | Job 1 | 2011-01-01 00:00:00 | 1 | 15000 | 30509 | 20000
FSA0341097 |  | Job 2 | 2011-01-01 00:00:00 | 1 | 7500 | 30000 | 30000
NHPP0343041 |  | Job 3 | 2011-01-01 00:00:00 | 1 | 12500 | 55801.76 | 13596
 | 20100001 | Clear and [NAME] |  | Acre | ================ | ================ | ================
[NAME] |  | Job 1 | 2011-01-01 00:00:00 | 4 | 6250 | 21150 | 18300
NHPP0171105 |  | Job 2 | 2011-01-01 00:00:00 | 157 | 1000 | 820.85 | 957.54
STR2871038 |  | Job 3 | 2011-01-01 00:00:00 | 13 | 8000 | 1602.61 | 1010.53
 | 20100005 | Rem of Debris |  | LUMP SUM | =============== | ================ | ================
NHPP0343041 |  | Job 1 | 2011-01-01 00:00:00 | 1 | 5000 | 13834.15 | 23656
NHPP 0852116 |  | Job 2 | 2011-01-01 00:00:00 | 1 | 15000 | 27500 | 25000
Spreadsheet: 195572d1353560499-how-to-lookup-a-table-in-sheet1-if-the-cell-is-color-then-color-the-matchin-cell-in-sheet2-query3-vlookup-colors
Sheet: Questions

code | description | Date of price | Purchase QTY | Price 1 | Price 2 | Price 3 | Price 4 | Price
1224 | Crunchie | 2012-10-21 00:00:00 | 10 | 1.86 | 1.89 | 1.74 |  | 1.74
1225 | Skittles | 2012-10-21 00:00:00 | 20 | 1.8 | 1.86 | 1.89 | 1.9 | 1.9
1228 | Bounty | 2012-10-21 00:00:00 | 70 | 1.86 | 1.9 |  |  | 1.9
1229 | [NAME] | 2012-10-21 00:00:00 | 50 | 1.86 | 1.89 | 1.98 |  | 1.98
1227 | M&Ms | 2012-10-21 00:00:00 | 80 | 1.8 | 1.86 | 1.89 | 1.98 | 1.98
1223 | Timeout | 2012-10-21 00:00:00 | 40 | 2 | 2.06 |  |  | 2.06
1274 | Malteses | 2012-10-21 00:00:00 | 60 | 1.48 | 1.58 | 2.06 |  | 2.06
1275 | Flake | 2012-10-21 00:00:00 | 50 | 2.07 | 2.4 | 2.25 | 2.15 | 2.15
1276 | Milky Bar | 2012-10-21 00:00:00 | 20 | 2.54 | 2.07 | 2.48 | 2.15 | 2.15
1278 | Aero | 2012-10-21 00:00:00 | 30 | 2.2 | 2.28 |  |  | 2.28
1279 | [NAME] | 2012-10-21 00:00:00 | 50 | 2.07 | 2.4 | 2.25 | 2.28 | 2.28
 |  |  |  | lookup a table in sheet1,if the cell is color then color the matching cell in sheet2  Hi All,  I am looking for a formula that will lookup the code in Sheet1 and colour the matching code in sheet2. For example 1224 [NAME] is colored in Green in Sheet1. I would like a formula that will look up Sheet1 and color A2 and B2 in Green. Is this possible with a vlookup formula or a conditional formatting?  In this example both sheets are in the same book, however my original data is from two seperate workbooks. I will be referencing one workbook and if it finds a match in color and code i want it to comeback and color my 2nd workbook.  I hope my explanation is clear and i welcome your assistance.  Thanks  Rique
Spreadsheet: 293476d1391001667-consolidate-two-data-sets-book3
Sheet: BEFORE X

Product | Month | Number
a | jan | 654
b | feb | 234
c | [NAME] | 123
d | apr | 543
e | may | 765
f | jun | 876
g | jul | 345
h | aug | 567
i | sep | 532
j | oct | 111
k | nov | 423
l | dec | 776
Spreadsheet: 106926d1304078869-setting-up-formulas-to-pull-data-from-another-sheet-accident-incident-report-log-1-
Sheet: Report Log

ACCIDENT/INCIDENT REPORT LOG
NUMBER | Event | H&S Member | Event Type | Employee | Date | Column1
20110001 | Accident | [NAME] | Harmful Substance/Environment | jane doe | 2011-02-04 00:00:00 | Accident
20110002 | Incident | [NAME] | Motor Vehicle Incident | [NAME] doe | 2011-04-16 00:00:00 | Incident
20110003 | Accident | [NAME] | Slip/Trip | [NAME] | 2011-05-05 00:00:00
20110004 | Incident | [NAME] | Struck/Caught | [NAME] | 2011-06-06 00:00:00
20110005 | Accident | Sean | Cut | jane doe | 2011-06-07 00:00:00 | [NAME]
20110006 | Accident | [NAME] | Burn | [NAME] | 2011-01-01 00:00:00 | Todd
20110007 | Accident | [NAME] | Fire/Explosion | [NAME] | 2011-12-01 00:00:00 | Sean
20110008 | Incident | Todd | Assault | penny wink | 2011-09-01 00:00:00 | [NAME]
20110009 | Incident | Sean | Overexertion | [NAME] | 2011-10-05 00:00:00 | [NAME]
20110010 |  |  |  |  |  | [NAME]
20110011
20110012
20110013 |  |  |  |  |  | Column1
20110014 |  |  |  |  |  | Cut
20110015 |  |  |  |  |  | Burn
20110016 |  |  |  |  |  | Slip/Trip
20110017 |  |  |  |  |  | Struck/Caught
20110018 |  |  |  |  |  | Overexertion
20110019 |  |  |  |  |  | Fire/Explosion
20110020 |  |  |  |  |  | Motor Vehicle Incident
20110021 |  |  |  |  |  | Harmful Substance/Environment
20110022 |  |  |  |  |  | Assault
20110023
20110024
20110025
20110026
20110027
20110028
20110029
20110030
20110031
20110032
20110033
20110034
20110035
20110036
20110037
20110038
20110039
20110040
20110041
20110042
20110043
20110044
20110045
20110046
20110047
20110048
Spreadsheet: 849201d1699724280-ecell-formula-to-copy-the-last-invoice-last-invoice
Sheet: Sales

 | SALES
 | Date | Invoice | Product | Code | Quantity | Unit Per Price | Net Amount | VAT | Amount VAT | Customer
 | 2023-04-12 00:00:00 | BK 002 | PLASTIC ICING 500G |  | 50 | 2 |  |  |  | Cash sale
 | 2023-04-12 00:00:00 | BK 002 | FINO WHIP 1KG |  | 3 | 2 |  |  |  | Cash sale
 | 2023-04-12 00:00:00 | BK 003 | PLASTIC ICING 500G |  | 50 | 2 |  |  |  | TM
 | 2023-04-12 00:00:00 | BK 004 | FINOWHIP250G |  | 4 | 2 |  |  |  | TM
 | 2023-04-12 00:00:00 | BK 005 | WHIPPET 1KG |  | 20 | 40 |  |  |  | TM
 | 2023-04-12 00:00:00 | BK 006 | PLASTIC ICING 500G |  | 100 | 70 |  |  |  | OK
 | 2023-04-13 00:00:00 | BK 006 | PLASTIC ICING 500G |  | 120 | 4 |  |  |  | OK
 | 2023-04-14 00:00:00 | BK 006 | PLASTIC ICING 500G |  | 4 | 70 |  |  |  | OK
 | 2023-04-17 00:00:00 | BK 007 | FINO WHIP 1KG |  | 120 | 40 |  |  |  | Cash sale
 | 2023-04-25 00:00:00 | BK 008 | PLASTIC ICING 500G |  | 10 | 20 |  |  |  | SPAR
Spreadsheet: 817480d1676267410-negative-amount-and-summation-issue-2023-commission-for-designers-sample-ans1
Sheet: Abby

ABBY | January | February | March | April | May | June | July | August | September | October | November | December |  | Sales | Bonus | Class
Sales Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Subtotal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Damage and Loss |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
D&L Allowed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Sub Allowed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Open Inv - 120 D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Bonus Expectation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Bonus Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 | ` |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 | `
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 9c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Fixed-Float | 10319 | 53974 | 81025 | 269540 | 358175 | 223020 | 121329 | 21581 | 1138963
FRA | 3883 | 17020 | 38216 | 6573 | 5152 | - | - | - | 70844
OTHER* | 28880 | 26436 | 27151 | 25482 | 74442 | 62174 | 44472 | 8426 | 297463
TOTAL | 43082 | 97430 | 146392 | 301595 | 437769 | 285194 | 165801 | 30007 | 1507270
*OTHER variable includes the following products: Cap/Floor, Debt Option, Exotic, Fixed-Fixed, Inflation, OIS, Swaption, and Basis.
Spreadsheet: 017ba7da-f453-40ff-bf3b-8a87f0feb884
Sheet: Sheet1

SCG BWF  WORLD JUNIOR CHAMPIONSHIPS 2013
Hotel Reservation Form
Please complete and ruturn this form before/by 15 Sep. 2013 to [EMAIL]
1．Contact Person Information
Name of Member Association |  |  |  |  |  |  |  | Submission Date
 |  |  |  |  |  |  |  |  |  |  | (DD/MM/YY)
Contact Person's Name |  |  |  |  |  |  |  | Mr./ Ms.
Contact Person's Information |  |  | Phone Number |  |  |  |  | Mobile Number
 |  |  | Fax Number |  |  |  |  | E-mail Address
2．Accommodation Request *Guest Names should be written as Given Name and [NAME].
Name of Hotel |  |  |  | First choice: |  |  |  | Second choice:
 | Last Name | First Name | Sex | Name of 2nd Guest Last Name (for Twin Room Only) | Name of 2nd Guest First Name (for Twin Room Only) | Sex | Name of 3rd Guest Last Name (for Triple Room Only) | Name of 3rd Guest First Name (for Triple Room Only) | Sex | Room Type | IN | OUT | Nights
Ex. | INTHANON | [NAME] | Ms. |  |  |  |  |  |  | Single | 2012-10-21 00:00:00 | 2012-11-04 00:00:00
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 | Hotel Name |  |  |  | Rate: Thai Bath  (Per room per night) |  |  |  |  | Access to the Arena
 | <Main Hotel>                                    　　　　　 -Grand FourWings Convention  Hotel                  *Managers Meeting will be held     *Shuttle Bus departure point |  |  |  | Deluxe type      : Single/twin Room: 2,500 Baht                                                   Triple Room: 3,500 Baht                                                Grand Deluxe type : Single/twin Room : 3,000 Baht                                       Triple Room 4,000 Baht |  |  |  |  | 10 minutes by bus  near the Arena
 | ・Grand [NAME] * Shuttle Bus departure point |  |  |  | Deluxe type    : Single/twin Room: 3,400 Baht                                                   Triple Room: 4,400 Baht                                               Grand Deluxe type : Single/twin Room : 4,000 Baht                                      Triple Room 5,000 Baht |  |  |  |  | 30 minutes by bus  (In the city)
 | Note
 | 1. The reservation is a first-come-first-served basis.  If sold-out, we will arrange another hotel for you.
 | 2. It is impossible to use the room by more number of people than the capacity.
 | 3. All prices are inclusive of buffet breakfast, service charge and government tax.
 | 4. An additional night will be charged for each early check-in(before 2pm) and late check-out(after 12pm).
 | 5. Cancellation charge(10%)  occurs from a week prior to the first stay.
 | 6. The damage of a Hotel facilities by the visitor burden you.
3．The Method of Payment
 | Please choose the method of payments. Payment Form will be sent to you by e-mail attached after your Hotel Reservation From has received.
Payment Method
Spreadsheet: 871603d1718037556-time-intelligence-calculation-formula-for-prepaid-and-income2
Sheet: Sheet4

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1
Month | Customer Code | Customer Name | Invoice No | Invoice Date | Status | Deletion date | Item amount | From | To | no. of days | 2024-03-31 00:00:00 | Remaining days | Opening | Cost Center Code | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00 | 2025-01-31 00:00:00 | 2025-02-28 00:00:00 | 2025-03-31 00:00:00 |  | Total | Diff
 |  |  |  |  | Opening |  | 252389 | 2023-03-01 00:00:00 | 2024-04-29 00:00:00 |  |  | 50 | 67065.26543878656 | MS-PMSUPP
 |  |  |  |  | Opening |  | 252389 | 2023-03-01 00:00:00 | 2024-04-29 00:00:00 |  |  |  | 4706.334416756952 | MS-PMSUPP
 |  |  |  |  | Addition |  | 252389 | 2024-03-01 00:00:00 | 2024-04-29 00:00:00 |  |  |  | 4706.334416756952 | MS-PMSUPP
 |  |  |  |  |  |  |  |  |  |  |  |  | Critia 1 | Cria 2 | Cria 3 | Crit 4 | Crit 5 | Crit 6
 |  |  |  |  |  |  |  |  |  |  |  | 1 | If opening | check if reporting date is greater than from date | if so calculalte - opening balance / remaining no. of days* month no. of days | if arrived bal is greater than opening bal, restrict to opening bal | Else opening / remainig useful life * no. of days in that month | Also from May 24 - Cumulative balance to be checked
 |  |  |  |  |  |  |  |  |  |  |  | 2 | If addition | check if reporting date is greater than from date | if so calculalte - item amount / total no. of days* month no. of days | if arrived bal is greater than item amount, restrict to item amount | Else item amount / total no. of days* month no. of days | Also from May 24 - Cumulative balance to be checked
Spreadsheet: 777924d1650670815-conditional-formatting-when-all-rows-of-a-type-meet-a-condition-example-2-
Sheet: Sheet1

INVOICE | STATUS
1214 | [NAME]
1214 | ORDERED
1664 | [NAME]
1664 | [NAME]
1664 | [NAME]
1664 | [NAME]
1664 | [NAME]
1684 | ORDERED
1684 | [NAME]
1684 | [NAME]
1684 | [NAME]