tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 121b66e9-db4f-4a3c-aeee-2152db8d79f2
Sheet: 3

 | Dec 28 | Jan 4 | Jan 11 | Jan 18 | Jan 25
Total Interest Rate* | N/A*** | N/A | N/A | N/A | N/A
Cleared** | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | 2325576 | 2307181 | 2360139 | 2354931 | 2371959
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, net notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 648387d1573030442-lookup-values-from-another-files-index
Sheet: SSD

 | OUTPUT SHOULD BE LIKE THIS
 | PARTICULARS |  |  |  |  |  |  |  | AMOUNT
 |  | DATE | BC | PAYEE | PARTICULARS | FUNDING
1911-05154 | 1911-05154 | 05-Nov-19 | OFMS190132286 | PLDT INC. | Payment for the current charges (basic charges & tolls) of the Department's Various Direct Lines at  OCA-Aseana Bldg.,  Basic charges for  01-31  October  2019  and  usage charges for the period 01-30 September  2019 as per  attached Invoices and summary.                                                               CERTIFICATION  I hereby certify that the long distance call/s being paid for under this voucher were official in nature and limited to urgent and absolutely necessary business of the Department.  I further certify that the said call/s  have been under my supervision.                                                                                                      ________________________                                                                                                       NEIL FRANK R. FERRER                                                                                                                                      Assistant Secretary, OCA |  | << but should disregard the ones in red color |  | Php   33,829.59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 501020900106D |  |  | B1 |  | B1109.02 | 7861080
1911-05155 | 1911-05154 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 501020900106D |  |  | B1 |  | B1109.02 | 7861080
1911-05156 | 1911-05154 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 501020900106D |  |  | B1 |  | B1109.02 | 7861080
1911-05157 | 1911-05154 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 501020900106D |  |  | B1 |  | B1109.02 | 7861080
1911-05158 | 1911-05154 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 501020900106D |  |  | B1 |  | B1109.02 | 7861080
 | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38183975.0976
Spreadsheet: 698060d1601716506-extract-non-zero-list-of-values-containing-formula-yo
Sheet: Sheet1

INPUT |  |  |  |  | SUM IF FUNC |  |  |  | EXPECTED OUTPUT
B | 1 |  |  |  | A
B | 2 |  |  |  | B
C | 3 |  |  |  | C
D | 0 |  |  |  | D
E | 5 |  |  |  | E
F | 6 |  |  |  | F
E | 7 |  |  |  | G
B | 8 |  |  |  | H
C | 9
Spreadsheet: 706662d1606825279-merging-two-formulas-excel-wait-time
Sheet: Sheet1

 |  | First Name | Last Name | Date Referral Received | Date of Contact/Appointment | Wait Time (COMM ONLY COLLECTION)
 |  | [NAME] | Bloggs | 2020-11-13 00:00:00 | 2020-11-14 00:00:00
 |  | [NAME] | Soaps | 2020-01-15 00:00:00 | 2020-08-29 00:00:00
 |  | Mrs | Claus | 2020-10-26 00:00:00
 |  | Mr | Claus | 2020-06-13 00:00:00 | 2020-11-01 00:00:00
 |  | Mr | Elf | 2019-11-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-11-30 00:00:00
 |  |  |  | Flood
Spreadsheet: 454127d1459661401-overdue-days-calculation-due-sheet-calculator
Sheet: Sheet1

S.NO | DATE | PAID UP STOCK | PARTICULAR | DUE DATE | AMOUNT | PAYMENT RECEIVED | overdue days | SATTELMENT | INTEREST | BALANCE
1 | 2016-04-01 00:00:00 | YES | INVOICE |  | 1000000 |  |  |  |  |  | YES
2 | 2016-04-05 00:00:00 | YES | INVOICE |  | 500000 |  |  |  |  |  | NO
3 | 2016-04-12 00:00:00 | YES | INVOICE |  | 1100000 |  |  |  |  |  | 1
4 | 2016-04-16 00:00:00 | NA | PAYMENT RECEIVED |  |  | 500000
5 | 2016-04-17 00:00:00 | NO | INVOICE |  | 1100000
7 | 2016-03-22 00:00:00 | NA | PAYMENT RECEIVED |  |  | 400000
8 | 2016-03-23 00:00:00 | YES | INVOICE |  | 200000
9 | 2016-03-24 00:00:00 | NA | PAYMENT RECEIVED
10 | 2016-03-25 00:00:00 | YES | INVOICE |  | 300000
11 | 2016-03-27 00:00:00 | NA | PAYMENT RECEIVED
12
Spreadsheet: 105910d1303183325-excel-2007-div-0-error-help-this-bloody-spreadsheet-
Sheet: Instructions

1 | Creating a new fortnight
 | Right click on tab(worksheet)
 | Select move or copy
 | click create a copy box
 | select a new sheet (eg sheet 2)
 | Re-name new tab to the new fornight period
 | [NAME] and right click
 | Select clear content
 | Delete all content that will be changed as you enter new info such as
 |  | labour hours
 |  | travel mileage
 |  | total  fuel for pressure washer
 |  | number of jobs
 |  | management hours
2 | Entering Information
 | Enter all information under relevant headings and this will give a total for each job
 | When entering onto spreasheet any out of pocket costs deduct GST
3 | Sending information
 | Send the spreadsheet back with invoices to [EMAIL]
Spreadsheet: 97817d1296903980-pay-cal-with-multi-different-rate-and-variables-pay-cal-test-data
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Hours During Time Rates
 | [NAME] to be set |  |  |  |  |  |  |  | 06:00:00 |  |  | Sat | Sun
 |  |  |  |  |  |  |  |  | 18:00:00
Day | Date | Start | Finish | Total Hours | Public Holdiay |  | Min Shift 3 hours | Site Grade | Hour [NAME] 6am-6pm | Night 6pm-6am | Night Shift Permanent | Saturday Rate | Sunday Rate | Public Holdiay | Double and half |  | Total
 |  |  |  |  |  |  | 3 |  | 20 | 0.2 |  | 1.5 | 2 | 2 | 2.5
 | 2004-05-17 00:00:00 | 18:15:00 | 21:15:00 |  | No
 | 2004-05-18 00:00:00 | 22:00:00 | 00:00:00
 | 2004-05-19 00:00:00 | 18:00:00 | 19:00:00
 | 2004-05-20 00:00:00 | 18:00:00 | 22:00:00 |  | YES
 | 2004-05-21 00:00:00 | 14:00:00 | 01:00:00
 | 2004-05-22 00:00:00 | 08:00:00 | 10:00:00
 | 2004-05-23 00:00:00
 | 2004-05-24 00:00:00
 | 2004-05-25 00:00:00 | 08:00:00 | 05:00:00
 | 2004-05-26 00:00:00
 | 2004-05-27 00:00:00
 | 2004-05-28 00:00:00
 |  | IF((OR(D15="",C15="")),0,IF((D15<C15),((D15-C15)*24)+24,(D15-C15)*24))
 |  | IF(E16>=H$14,"","3")
 |  | ((C20>D20)*MEDIAN(0,D20-J$11,J$12-J$11)+MAX(0,MIN(J$12,D20+(C20>D20))-MAX(J$11,C20)))*24 |  |  |  |  |  |  |  |  |  | only cal between 6am to 6pm
Spreadsheet: 732145d1620795233-sort-the-values-in-column-a-in-ascending-order-and-extract-corresponding-values-non-array-to-sort-values-ans
Sheet: Sheet2

Employee Name | Employee ID | Req. | Req. Date |  | Employee Name | Employee ID | Req. | Req. Date |  |  | Employee Name | Employee ID | Req. | Req. Date
 |  |  |  |  |  |  |  |  |  |  | Ah, [NAME] | EH1022 | GIO | 2021-02-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Ah, [NAME] | EH1022 | TOTO | 2021-02-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Bow, [NAME] | EH1029 | TOTO | 2021-02-03 00:00:00
 |  |  |  |  |  |  |  |  |  |  | [NAME], Ebese | EH1023 | RTY | 2021-02-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  | [NAME], Head | EH1011 | BLISS | 2021-02-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Christine, Venus | EH1018 | FMA | 2021-02-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Elastic, Method | EH1013 | EL | 2021-02-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Erico, Bell | EH1007 | EL | 2021-02-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Erico, Bell | EH1007 | CL | 2021-02-02 00:00:00
Spreadsheet: 154163d1336263274-excel-2007-help-w-some-adv-adding-and-formulas-under-construction
Sheet: Templet Co

question 1. using [NAME] for example I want to add cells A13-A19 but when it adds to cell A3 I want it too look like: 1/5/1 | question 2: using the same senerio as question 1 but can it add dates, blanks, and dates from another colum. Using cell B3 adding blanks from B13-19, adding number of dates from the same colum but then add the number of dates from a different colum? So [NAME] should look like: 5/2/6 | question 3 how can I get a %: using [NAME] I want a % to show up there using D13-D19. in this case it would but 100% because there are no blanks in that colum.
C (I/S/T) | P (NS/Sub/Rec) | A % Complete |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Schools
1/5/1 | 5/2/6 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
C T | P Sub. Date | P Rec. Date | ATFP Comp. Date
T |  | 2008-06-15 00:00:00 | 2012-03-01 00:00:00
S |  | 2008-10-15 00:00:00 | 2012-03-01 00:00:00
I | 2012-03-29 00:00:00 |  | 2012-02-17 00:00:00
S |  | 2010-04-14 00:00:00 | 2012-03-01 00:00:00
S | 2012-05-06 00:00:00 | 2010-05-26 00:00:00 | 2012-03-01 00:00:00
S |  | 2011-12-16 00:00:00 | 2012-03-01 00:00:00
S |  | 2011-11-28 00:00:00 | 2012-03-01 00:00:00
Spreadsheet: kim_ward__20716__various_customers_Cali
Sheet: Sheet1

 |  |  | Western Retai Annual Customer Demand
 |  |  | Volume in Mmbtu
 |  |  | Expected Consumption |  |  | Dunn &
 |  |  | In 2001 |  |  | Bradstreet
SOCAL |  |  |  |  |  | Number
[NAME] |  |  | 119971 |  |  | 00-848-9569
Associated Assp |  |  | 44000 |  |  | 00-831-8057
[NAME] |  |  | 226274 |  |  | 00-828-7450
Granite Buelton |  |  | 110000 |  |  | 00-691-4642
Granite Bakersfield |  |  | 44304 |  |  | 00-691-4642
[NAME] |  |  | 137912 |  |  | 00-848-0584
Golden State |  |  | 95226 |  |  | 00-910-8671
ITW CIP Stampings |  |  | 142987 |  |  | 05-079-7679
JG Boswell |  |  | 294888 |  |  | 00-823-7505
Leprino Foods |  |  | 469987 |  |  | 00-707-6664
Luxfer |  |  | 68296 |  |  | 06-448-3704
[NAME] heat Treat |  |  | 67434 |  |  | 05-733-2017
Morgan Services |  |  | 24502 |  |  | 05-662-6922
Real Fresh |  |  | 108173 |  |  | 00-913-3950
[NAME] |  |  | 364122 |  |  | 06-772-7313
Valley |  |  | 30988 |  |  | 07-294-0307
PGE
[NAME] |  |  | 260820 |  |  | 05-965-1117
Canan- Esc |  |  | 55590 |  |  | 05-965-1117
Canan-Gonz |  |  | 26222 |  |  | 05-965-1117
Canan-Madera |  |  | 398420 |  |  | 05-965-1117
Canan- [NAME] |  |  | 22485 |  |  | 05-965-1117
[NAME] |  |  | 565339 |  |  | 05-563-5593
Granite Coal |  |  | 140153 |  |  | 00-691-4642
Granite French |  |  | 85622 |  |  | 00-691-4642
Granite Watson |  |  | 90000 |  |  | 00-691-4642
Granite Sacra |  |  | 129089 |  |  | 00-691-4642
Granite Tracy |  |  | 136747 |  |  | 00-691-4642
Granite Rio Lind |  |  | 27333 |  |  | 00-691-4642
Leprino |  |  | 288339 |  |  | 00-707-6664
Mitsubishi |  |  | 487000 |  |  | 19-607-2334
Queen |  |  | 46760 |  |  | 06-760-7572
F & A Cheese |  |  | 350000 |  |  | 07-929-0722
Columbus [NAME] |  |  | 70000 |  |  | 17-775-1658
SDG&E
Superior Ready Mix |  |  | 90000
Leprino New Mexico |  |  | 751000 |  |  | 00-707-6664
Arizona
Hexcel |  |  | 182400 |  |  | 00-911-8563
AZ Pistachio |  |  | 74000
Total Physical Demand
Spreadsheet: 767913d1644727437-formatting-crystal-reports-data-in-excel-formatting-question
Sheet: Sheet2

Full Account Name | Original Project Name | Install End Date | Current Contract Value | Contract Number | System Size in kW | Includes Solar? | [NAME]? | MSP Swap Required? | Does SOW include energy storage? | Battery Qty | Battery Total kWh | [NAME] | Estimate Cost | Actual Costs | Open POs | Committed  Costs | Total Projected | Estimated Revenue | Estimated Margin % | Actual Revenue | Actual Margin % | Actual Time To Date | Open A/R Balance | Paid To Date | Revenue Per Hour Worked
[NAME] | Aguero | 2020-10-23 00:00:00 | 21656 |  | 5.63 | Yes | No | No | No |  |  |  | 13207.68 | 12395.72 | 0 | 0 | 12395.72 | 22305.68 | 40.78781727344784 | 22305.68 | 44.42796632965236 | 120.75 | 0 | 22305.68
[NAME] | Applebee | 2020-09-24 00:00:00 | 24890 |  | 5.95 | Yes | No | Yes | No |  |  |  | 18168 | 15631.27 | 0 | 0 | 15631.27 | 24890 | 27.00683005222981 | 24890 | 37.19859381277622 | 134.25 | 0 | 24890
Spreadsheet: 739865d1626014782-non-array-formula-to-sort-values-alphabetically-into-b2-b61-non-array-to-extract-unique-values_sort-ans
Sheet: Sheet1

Letter |  |  |  | Letter
[NAME], Christinado |  |  |  | Den, Lend
Den, Lend |  |  |  | Den, Lentus
Den, Lentus |  |  |  | Desh, Vintona
[NAME], Makia |  |  |  | [NAME], Christinado
Hayer, Doncast |  |  |  | [NAME], Makia
Hot, Rossen |  |  |  | Hayer, Doncast
Mananu, [NAME] |  |  |  | Hot, Rossen
Mananu, songs |  |  |  | Kat, Son
Pop, Icon |  |  |  | Mananu, [NAME]
Smith, Sabana |  |  |  | Mananu, songs
Strong, [NAME] |  |  |  | Morgan, [NAME]
Strong, Sea |  |  |  | Pop, Icon
Whatzt, Tense |  |  |  | Smith, Sabana
Worth, Coral |  |  |  | Strong, [NAME]
Desh, Vintona |  |  |  | Strong, Sea
Kat, Son |  |  |  | Whatzt, Tense
Morgan, [NAME] |  |  |  | Worth, Coral
Spreadsheet: 80823d1281009825-coloring-the-cells-book1-1-
Sheet: Sheet1

NAME | Shuaiba | KOC | DEPS | DWPS
 | 31/12/2008 | 2008-11-05 00:00:00 | 2010-08-30 00:00:00 | 31/12/2008
 | 31/12/2008 | 24/6/2008 | 31/12/2008 | 31/12/2008
 | 31/12/2008 | - | 31/12/2008 | 31/12/2008
 | 31/12/2008 | 29/4/2008 | 31/12/2010 | 31/12/2008
 | 31/12/2008 | 2011-09-04 00:00:00 | 31/12/2008 | 31/12/2008
 | 31/12/2008 | 24/7/2008 | 31/12/2008 | 31/12/2008
 | 31/12/2008 | 21/9/2008 | 31/12/2008 | 31/12/2008
Spreadsheet: 71ac92bc-ee93-412c-8e03-209dad3dbd2a
Sheet: Sheet1

 | [NAME] of Citrus Council
 | Finance Committee Meeting Supporting Schedule
 | Cash Flow Analysis Related to Capital Expenditures
 | For Year To Date:   10/1/11 through 6/30/12
Budgeted 2012 Depreciation Expense |  |  | 264800
Capital Expenditures Year to Date through 6/30/012
 | Laptop purchase
 | Archery equipment for MKW |  | 1637.98
 | [NAME] remodel - Publix grant
 | Replacement of roofs on 2 bathhouses at MKW |  | 10125
 | Replacement of dock at Riverpoint
 | Miscellaneous small purchases |  | 21960.17 | Being researched for details
 | 2012 Capital Expenditures through 6/30/12 |  |  | Capital expenditures per balance sheeet
 | Principal Payments for Pool Loan
Available Balance as of 6/30/12:
Forecasted Expenditures for 7/1/12-9/30/12
 | Proposed Expenditure:Upgrading phone, computers, network |  | 97594 | Finance Committee Voted to approve
 | (See attached detailed list)
 | Principal Payments for Pool Loan  (3 months) |  |  | Estimated
Remaining Balance: 2012 Capital Cash Flow funds
 | Note:
 | The capitalization policy at [NAME] is to capitalize asset expenditures over $1,000.
 | The pool loan principal is treated as a capital cost since the loan to pay for the pool from a
 | cash flow perspective is for a capital asset and is NOT covered in the operating
 | (Interest portion is covered under the Operating Cash Flow.)
 | Proposal is to create a fund going forward that sets aside funds for capital replacements
 | at least equal to the amount of annual depreciation.
 | (This will be discussed in more detail at the next meeting.)
 | In prior years, the operating budget did not allow council to actually set aside the deprecitation funds
 | for re-investment in capital.
Spreadsheet: 849161d1699676100-weighted-average-formula-by-rank-that-is-sometimes-missing-values-weighted-average
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | 4+ | 3 | 2 | 1
 |  |  |  | 1 | 2 | 3 | 4 | 5 |  |  | 1st | 0.4
 |  |  | Average | Red | Blue | Green | Yellow | White |  |  | 2nd | 0.3
 |  |  |  | 0.69 | 0.7 | 0.75 | 0.63 | 0.48 |  |  | 3rd | 0.2
 |  |  |  |  | 0.65 | 0.45 | 0.12 | 0.88 |  |  | 4th | 0.1
 |  |  |  |  | 0.74
 |  |  |  | 0.23 |  |  | 0.47
Spreadsheet: 148810d1333561970-identifying-current-streaks-of-goals-points-streak-example
Sheet: Sheet1

Date | OPP | Goal | Assist | Points |  |  |  |  |  |  | Goal | Assist | Points
2011-09-23 00:00:00 | vs NAN | 1 | 0
2011-09-24 00:00:00 | vs NAN | 1 | 2 |  |  |  |  | [NAME] | Correct Result
2011-09-28 00:00:00 | at CVC | 0 | 0 |  |  |  | Goal Streak |  | 4
2011-10-01 00:00:00 | vs LAN | 0 | 1 |  |  |  | Assist Streak |  | 1
2011-10-02 00:00:00 | vs LAN | 1 | 0 |  |  |  | Point Streak |  | 5
2011-10-07 00:00:00 | vs ABV | 1 | 1
2011-10-08 00:00:00 | at LAN | 1 | 0
2011-10-09 00:00:00 | at COQ | 1 | 1
2011-10-13 00:00:00 | at MER
 |  |  |  |  |  |  |  |  |  | Current Streak
Spreadsheet: 47362d1246394096-fill-cell-w-value-present-in-another-row-if-columns-match-together
Sheet: Sheet1

TV |  |  |  | 1 | 1 | TV
Dog |  |  |  | 2 | 2 | Dog
Cat |  |  |  | 3 | 3 | Cat
 |  |  |  |  | 5 | Mom
Mom |  |  |  | 5 | 6 | Daddy
Daddy |  |  |  | 6 | 9 | Missis
 |  |  |  |  | 12 | Phone
 |  |  |  |  | 15 | [NAME]
Missis |  |  |  | 9 | 21 | Printer
 |  |  |  |  | 22 | [NAME]
 |  |  |  |  | 25 | Silver
Phone |  |  |  | 12 | 28 | Faxer
 |  |  |  |  | 29 | Cutter
 |  |  |  |  | 35 | Welder
[NAME] |  |  |  | 15 | 38 | Gold
 |  |  |  |  | 42 | Assistant
 |  |  |  |  | 47 | Diamond
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
Printer |  |  |  | 21 | #N/A | #N/A
[NAME] |  |  |  | 22 | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
Silver |  |  |  | 25 | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
Faxer |  |  |  | 28 | #N/A | #N/A
Cutter |  |  |  | 29 | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
Welder |  |  |  | 35 | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
Gold |  |  |  | 38 | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
Assistant |  |  |  | 42 | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
 |  |  |  |  | #N/A | #N/A
Diamond |  |  |  | 47 | #N/A | #N/A
Spreadsheet: 76675d1277206558-excel-2007-freezing-result-progressiveentry-2-
Sheet: Masterfile

Initial Order |  |  |  |  |  | Received | Calculate Balance
Order No | Order Date | Material | Colour | Ordered Quantity | Length | Date | Delivered | Kg | Balance of Order | Weight ([NAME]) | Received to Date | Comments
2 | 2010-02-02 09:58:27 | 20V | BLACK | 10000 | 6000 |  |  |  | 1421
6 | 2010-04-23 10:01:36 | 20V | BLACK | 10000 | 6000 |  |  |  | 10000
22 | 2009-12-10 10:04:31 | 20VT | BLACK | 10000 | 6500 |  |  |  | 1200
6 | 2010-04-23 10:15:50 | 20VT | BLACK | 10000 | 6000 |  |  |  | 2900
7 | 2010-05-19 10:19:22 | 24V | BLACK | 10000 | 6000 |  |  |  | (+)1120
7 | 2010-05-19 10:20:31 | 20V | BLACK | 10000 | 6500 |  |  |  | 6850
7 | 2010-05-19 10:21:17 | 14.8I | BLACK | 5000 | 6000 |  |  |  | 450
8 | 2010-05-25 10:22:32 | 18I | BLACK | 5000 | 6000 |  |  |  | 100
9 | 2010-06-10 12:50:38 | 38 V2TN | BLACK | 500 | 6000 |  |  |  | 500
9 | 2010-06-10 12:51:06 | 22I | BLACK | 1000 | 6500 |  |  |  | 1000
10 | 2010-06-21 13:07:03 | 14.8 I | BLACK | 5000 | 6000 |  |  |  | 5000
Spreadsheet: 752509d1634811742-quick-help-with-filter-formula-so-it-shows-just-one-column-of-data-price-comparison-test-t2
Sheet: TA 

Product | Supplier | Price | Quantity | Unit Price | Date | % change | Notes | PRODUCT | ABPAC | BAKO | Catering 24 | Cheapest | From | Saving | x50 bought
10" Greaseproof bag | ABPAC | 16.82 | 1000 |  |  |  |  | 10" Greaseproof bag |  |  |  |  |  |  |  |  |  | 12oz compostable d/w cup |  |  |  |  | BAKO
10" Greaseproof bag | BAKO | 8.12 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12oz compostable lid |  |  |  |  | Bonds Packaging
10" Greaseproof bag | Catering 24 | 19.02 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7" Greaseproof bag |  |  |  |  | Catering 24
12oz compostable d/w cup | Catering 24 | 45.54 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8oz compostable d/w cup |  |  |  |  | Enviropack
12oz compostable d/w cup | Next Day Coffee | 43.19 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8oz compostable lid |  |  |  |  | Enviropack 4+
12oz compostable d/w cup | [NAME] | 53.1 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nesting Tray |  |  |  |  | Enviropack 5+
12oz compostable lid | Catering 24 | 53.99 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No. 1 [NAME] |  |  |  |  | Next Day Coffee
12oz compostable lid | Next Day Coffee | 29.75 | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No. 3 [NAME] |  |  |  |  | [NAME]
12oz compostable lid | [NAME] | 54.84 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Perforated Film Front [NAME] bag
7" Greaseproof bag | ABPAC | 10.28 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SOS Carrier Bag
7" Greaseproof bag | BAKO | 6.88 | 1000
7" Greaseproof bag | Catering 24 | 9.77 | 1000
8oz compostable d/w cup | Catering 24 | 38.34 | 500
8oz compostable d/w cup | Next Day Coffee | 38.39 | 500
8oz compostable d/w cup | [NAME] | 43.56 | 500
8oz compostable lid | Catering 24 | 59.34 | 1000
8oz compostable lid | Next Day Coffee | 25.19 | 500
8oz compostable lid | [NAME] | 45.35 | 1000
Nesting Tray | ABPAC | 32.74 | 500
Nesting Tray | Bonds Packaging | 21.12 | 220
No. 1 [NAME] | Catering 24 | 56.99 | 450
No. 1 [NAME] | Enviropack | 59.94 | 450
No. 1 [NAME] | Enviropack 4+ | 56.39 | 450
No. 3 [NAME] | Catering 24 | 42.24 | 180
No. 3 [NAME] | Enviropack | 44.34 | 180
No. 3 [NAME] | Enviropack 4+ | 41.99 | 180
Perforated Film Front [NAME] bag | Enviropack | 36.54 | 1000
Perforated Film Front [NAME] bag | Enviropack 5+ | 33.59 | 1000
Perforated Film Front [NAME] bag | Next Day Coffee | 39.59 | 1000
SOS Carrier Bag | Catering 24 | 21.59 | 250
SOS Carrier Bag | Enviropack | 21.59 | 250
SOS Carrier Bag | Enviropack 5+ | 19.79 | 250
10" Greaseproof bag | ABPAC | 15
Spreadsheet: 196103d1353855140-calculate-slope-of-reflection-off-sloped-surface-wowzers-reflected-line
Sheet: Data Entry

Enter data into the yellow cells, other cells are calculated |  | Run (x) | Rise (y) | Angle (θ) | Slope (tanθ) |  | User's example data
 | Mirror (LINEsurface) | 245 | -60 |  |  |  | 245 | -60
 | Normal to Mirror
 | Incident (LINE1) | 262 | 487 |  |  |  | 262 | 487
 | Reflection