tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: dbfeb4bb-bcca-4b48-903d-5326eb187924
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Manufactured Homes Survey
 |  | Total Homes: U.S. Total
 |  | Seasonally Adjusted Total Placements [Thousands of Units]
 |  | Period: 2000 to 2012
 |  | Data Extracted on: July 30, 2014 (11:41 pm)
Period | Value
Jan-2000 | 312
Feb-2000 | 325
Mar-2000 | 352
Apr-2000 | 318
May-2000 | 316
Jun-2000 | 291
Jul-2000 | 283
Aug-2000 | 265
Sep-2000 | 251
Oct-2000 | 233
Nov-2000 | 213
Dec-2000 | 205
Jan-2001 | 215
Feb-2001 | 209
Mar-2001 | 192
Apr-2001 | 188
May-2001 | 176
Jun-2001 | 204
Jul-2001 | 200
Aug-2001 | 194
Sep-2001 | 203
Oct-2001 | 194
Nov-2001 | 195
Dec-2001 | 194
Jan-2002 | 187
Feb-2002 | 184
Mar-2002 | 166
Apr-2002 | 180
May-2002 | 204
[NAME] | 180
Jul-2002 | 181
Aug-2002 | 178
Sep-2002 | 159
Oct-2002 | 159
Nov-2002 | 157
Dec-2002 | 157
[NAME] | 151
Feb-2003 | 118
Mar-2003 | 144
Apr-2003 | 144
May-2003 | 138
Jun-2003 | 131
Jul-2003 | 129
Aug-2003 | 140
Sep-2003 | 144
Oct-2003 | 148
Nov-2003 | 147
Dec-2003 | 140
Jan-2004 | 132
Feb-2004 | 116
Mar-2004 | 124
Apr-2004 | 138
May-2004 | 125
Jun-2004 | 136
Jul-2004 | 134
Aug-2004 | 114
Sep-2004 | 121
Oct-2004 | 114
Nov-2004 | 112
Dec-2004 | 126
Jan-2005 | 138
Feb-2005 | 130
Mar-2005 | 119
Apr-2005 | 117
May-2005 | 124
Jun-2005 | 125
Jul-2005 | 124
Aug-2005 | 127
Sep-2005 | 116
Oct-2005 | 125
Nov-2005 | 127
Dec-2005 | 110
Jan-2006 | 135
Feb-2006 | 128
Mar-2006 | 121
Apr-2006 | 114
May-2006 | 118
Jun-2006 | 116
Jul-2006 | 109
Aug-2006 | 113
Sep-2006 | 109
Oct-2006 | 96
Nov-2006 | 105
Dec-2006 | 102
[NAME] | 89
Feb-2007 | 88
Mar-2007 | 108
Apr-2007 | 92
May-2007 | 96
Jun-2007 | 99
Jul-2007 | 99
Aug-2007 | 93
Sep-2007 | 91
Oct-2007 | 94
Nov-2007 | 105
Dec-2007 | 81
Jan-2008 | 73
Feb-2008 | 96
Mar-2008 | 84
Apr-2008 | 89
May-2008 | 87
Jun-2008 | 81
Jul-2008 | 82
Aug-2008 | 82
Sep-2008 | 81
Oct-2008 | 76
Nov-2008 | 65
Dec-2008 | 69
Jan-2009 | 65
Feb-2009 | 51
Mar-2009 | 58
Apr-2009 | 56
May-2009 | 50
Jun-2009 | 48
Jul-2009 | 52
Aug-2009 | 46
Sep-2009 | 56
Oct-2009 | 57
Nov-2009 | 66
Dec-2009 | 52
[NAME] | 47
[NAME] | 47
Mar-2010 | 50
Apr-2010 | 58
[NAME] | 59
[NAME] | 60
[NAME] | 54
Aug-2010 | 51
Sep-2010 | 45
Oct-2010 | 48
Nov-2010 | 40
Dec-2010 | 48
Jan-2011 | 36
Feb-2011 | 48
Mar-2011 | 45
Apr-2011 | 47
May-2011 | 40
Jun-2011 | 50
Jul-2011 | 48
Aug-2011 | 49
Sep-2011 | 47
Oct-2011 | 48
Nov-2011 | 59
Dec-2011 | 52
Jan-2012 | 58
Feb-2012 | 60
Mar-2012 | 55
Apr-2012 | 52
May-2012 | 53
Jun-2012 | 47
Jul-2012 | 49
Aug-2012 | 58
Sep-2012 | 51
Oct-2012 | 50
Nov-2012 | 58
Dec-2012 | 52
Spreadsheet: a05c97bd-cfa4-4f20-a81e-ed74f6747975
Sheet: Auto vd zaak

 | Aanschafprijs | 10900 | Benzineprijs | 1.75 |  | [NAME] kosten |  |  | BTW |  | Netto
 | .. [NAME] | 0 | Onderhoud | 200
 | Cataloguswaarde | 10505 | Verzekering | 800 |  | Afschrijving
 | [NAME] | 6000 | Overige kosten | 250 |  | Benzine
 | Bijtelling | 0.14 | Belastingtarief | 0.42 |  | Verzekering
 | Verbruik | 20 | Jaren | 5 |  | Wegenbelasting
 | Wegenbelasting | 0 |  |  |  | Onderhoud
 | BTW | 0.19 |  |  |  | Overig
 | Prive KM | 4000
 | [NAME] | 3000 | Leasebedrag | 254 |  | Totaal
 |  |  |  |  |  | Bijtelling
 |  |  |  |  |  | Aftrekpost
 | Zaak | eenmalig |  |  | Privé | eenmalig |  |  |  | [NAME] leasen
 | Aanschaf
 | [NAME] aanschaf
 | Investeringsaftrek
 | Milieuaftrek
 | Aanschaf: |  |  |  | Aanschaf: |  |  |  |  |  | p/jaar | p/maand
 |  | p/jaar | p/maand |  |  | p/jaar | p/maand |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Bijtelling
 | Periodieke kosten |  |  |  | Periodieke kosten |  |  |  |  | Bijtelling BTW
 | [NAME] |  |  |  | KMvergoeding |  |  |  |  | [NAME] winst
 | [NAME] winst |  |  |  | 75% van btw |  |  |  |  | [NAME]
 | Periodiek: |  |  |  | Periodiek:
 | Kosten over 5 jaar | totaal | p/maand |  | Kosten over 5 jaar | totaal | p/maand |  |  | Kosten over 5 jaar | totaal | p/maand
 | belast verkopen |  |  |  | na verkoop
 | onbelast (inruil)
Spreadsheet: 691146d1597509883-vlookup-index-match-multiple-records-to-find-demo4-rrenzi-
Sheet: XYZ CO

 | XYZ CO
MEMBER_ID | PROD | DESC | CODE_1 | CATEGORY_1 | CODE_2 | CATEGORY_2 | CHARGE | COUNT | OWED | INDEX | LAST | START | GROUP | Name
Spreadsheet: 456479d1460900964-ability-to-grab-the-correct-price-on-a-dynamic-range-table-johntopley7
Sheet: Sheet1

CABINETS | MODEL | COLOR | PRICE/EACH | QUANTITY | TOTALS | Column1 | Column2
 |  |  |  |  |  | White
BASE SINK | SB30 |  |  | 2
 |  |  |  | SUBTOTAL
 |  |  |  | DISCOUNT - | 0.1
 |  |  |  | TAX
 |  |  |  | TOTAL
Spreadsheet: 0f60eec6-404f-46bb-8f7e-b70344362d88
Sheet: Sheet1

City of [NAME], new single family projects under review, approved and under construction as of February 26, 2013
Project Address |  |  | Project Type | Date Plans | Date Plans | Date Under
 |  |  |  | Submitted | Approved | Construction
 |  |  |  | For Review
411 Fowzer |  |  | New Single Family | 2012-02-01 00:00:00 | 2012-02-21 00:00:00 | 2012-03-02 00:00:00
2109 W Lake Dr |  |  | New Single Family | 2012-04-03 00:00:00 | 2012-04-23 00:00:00 | 2012-05-03 00:00:00
615 Big Bend |  |  | New Single Family | 2012-05-17 00:00:00 | 2012-06-01 00:00:00 | 2012-06-08 00:00:00
402 South Robinson Street |  |  | New Single Family | 2010-11-03 00:00:00 | 2010-11-03 00:00:00
1003 [NAME] |  |  | New Single Family | 2012-03-30 00:00:00 | 2012-04-11 00:00:00 | 2012-05-14 00:00:00
114 First Avenue |  |  | New Manufactured Home | 2011-02-17 00:00:00 | 2011-04-04 00:00:00 |  | Lot needs to be replatted
604 Big Sur Trail |  |  | New Single Family | 2012-05-10 00:00:00 | 2012-05-24 00:00:00 | 2012-06-04 00:00:00
801 Big Sur Trail |  |  | New Single Family | 2012-07-06 00:00:00 | 2012-07-19 00:00:00 | 2012-07-26 00:00:00
4305 Big Bend Trail |  |  | New Single Family | 2012-07-06 00:00:00 | 2012-07-19 00:00:00 | 2012-07-26 00:00:00
4307 Big Bend Trail |  |  | New Single Family | 2012-07-06 00:00:00 | 2012-07-19 00:00:00 | 2012-07-26 00:00:00
1807 Carey Avenue |  |  | New Single Family | 2012-06-27 00:00:00 | 2012-07-19 00:00:00 | 2012-07-26 00:00:00
4309 Big Bend Trail |  |  | New Single Family | 2012-08-01 00:00:00 | 2012-08-14 00:00:00 | 2012-08-21 00:00:00
700 Big Sur Trail |  |  | New Single Family | 2012-08-15 00:00:00 | 2012-08-29 00:00:00 | 2012-09-12 00:00:00
4403 Big Bend Trail |  |  | New Single Family | 2012-08-28 00:00:00 | 2012-09-12 00:00:00 | 2012-09-19 00:00:00
4301 Big Bend Trail |  |  | New Single Family | 2012-09-18 00:00:00 | 2012-10-02 00:00:00 | 2012-10-17 00:00:00
4401 Big Bend Trail |  |  | New Single Family | 2012-09-18 00:00:00 | 2012-10-02 00:00:00 | 2012-10-17 00:00:00
1906 [NAME] |  |  | New Single Family | 2012-10-02 00:00:00 | 2012-10-17 00:00:00 | 2012-10-31 00:00:00
503 Simon |  |  | New Manufactured Home | 2012-11-19 00:00:00 | 2012-12-03 00:00:00 | 2012-12-17 00:00:00 | Specific Use Permit approved
611 Big Bend Trail |  |  | New Single Family | 2012-11-08 00:00:00 | 2012-11-20 00:00:00 | 2012-12-15 00:00:00
4405 Big Bend Trail |  |  | New Single Family | 2012-12-06 00:00:00 | 2012-12-16 00:00:00 | 2012-12-20 00:00:00
1001 Grand [NAME] |  |  | New Single Family | 2012-12-06 00:00:00 | 2012-12-16 00:00:00 | 2012-12-20 00:00:00
[NAME] |  |  | New Single Family | 2013-02-15 00:00:00 | 2013-02-25 00:00:00
Residential project review time averaged 11 days, and 53% were reviewed within 10 days.
The goal for review and approval of new single family construction is 10 working days.
Both the City staff and Bureau Veritas staff review  residential projects.
Spreadsheet: 775643d1649241134-formula-macro-help-to-find-percentage-for-each-month-formula
Sheet: Sheet1

Date | Number | [NAME]?
2018-07-23 00:00:00 | 12
2018-07-24 00:00:00 | 22
2018-07-25 00:00:00 | 33
2018-07-26 00:00:00 | 12
2018-07-27 00:00:00 | 3
2018-07-28 00:00:00 | 23
2018-07-29 00:00:00 | 32
2018-07-30 00:00:00 | 33
2018-07-31 00:00:00 | 44
2018-08-01 00:00:00 | 3
2018-08-02 00:00:00 | 42
2018-08-03 00:00:00 | 23
2018-08-04 00:00:00 | 32
2018-08-05 00:00:00 | 3
2018-08-06 00:00:00 | 2
2018-08-07 00:00:00 | 23
2018-08-08 00:00:00 | 4
2018-08-09 00:00:00 | 45
2018-08-10 00:00:00 | 76
2018-08-11 00:00:00 | 5
2018-08-12 00:00:00 | 45
2018-08-13 00:00:00 | 23
2018-08-14 00:00:00 | 3
2018-08-15 00:00:00 | 4
2018-08-16 00:00:00 | 3
2018-08-17 00:00:00 | 32
2018-08-18 00:00:00 | 4
2018-08-19 00:00:00 | 3
2018-08-20 00:00:00 | 3
2018-08-21 00:00:00 | 3
2018-08-22 00:00:00 | 5
2018-08-23 00:00:00 | 3
2018-08-24 00:00:00 | 66
2018-08-25 00:00:00 | 5
2018-08-26 00:00:00 | 34
2018-08-27 00:00:00
2018-08-28 00:00:00 | 3
Spreadsheet: phillip_m_love__30154__9903_OA
Sheet: SE-EGM-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  SOUTHEAST
 |  |  | Total |  | Reclasses |  |  |  |  |  | May |  |  |  |  |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | 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 | 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
 | 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
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 843968d1695784581-calculate-gps-coordinates-using-sin-and-cos-unknown-point-projections
Sheet: Sheet1

Known/Cal Latitude | Known/Cal Longitude | Latitude converted to decimal | Longitude converted to decimal | Distance in ft | Distance converted to Meters | Known Bearing | Bearing deg sep | Bearing min sep | Bearing sec sep | Quad | Bearing converted to decimal | L2 converted to Azimuth | L2 converted to Radians | SIN Function for Latitude | COS Function for Longitude | New latitude | New Longitude
38 6' 52.17 N | 80 47 56.95 W | 38.114492 | 80.682486 | 150.48 |  | [NAME] |  |  |  | SW |  |  |  |  |  | 47° 31' 42.0924" | 125° 34' 20.3406"
 | 125° 34' 20.3406" |  |  | 148.21 |  | [NAME] |  |  |  | SW
 |  |  |  |  |  |  |  |  |  | Earth Radius from Wikipedia page Geographical Distance
 |  |  |  |  |  |  |  |  |  | 6371009
 | latitude of second point = la2 =  asin(sin la1 * cos Ad  + cos la1 * sin Ad * cos θ), and
 | longitude  of second point = lo2 = [NAME] Ad * cos la1 , cos Ad – sin la1 * [NAME]) [NAME] note error in this formula. X and Y appear to need to switch places inside of the ATAN2() function.
 |  |  |  | Distance
 |  | dec lat | dec lon | ft | m |  |  |  |  |  |  | dec bearing | lat radians | lon radians | bearing radians | Ad | la2 radians | lo2 radians | [NAME] | [NAME]
 |  |  | note that lon W is typically entered as a negative value
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 12 Feb 2012

Daily Morning Staff |  |  |  |  | Sunday
 | 07:30-14:30 |  | 2012-02-12 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Ralation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | Annual | Annual | EFS | Annual
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | Absent | Absent | [NAME] | Absent, Called not answer, checked with Al Majlis Team informed not reported
[NAME] | 1897 | Manager | Annual | Annual | EFS | Annual
[NAME] | 4440 | Attendant | 08:00:00 | 14:00:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 109251d1306174657-how-do-i-scan-a-vlookup-though-multiple-worksheets-log-example
Sheet: Sheet1

2011-05-23 00:00:00 |  |  | Operator
SHIPMENT:
Scan [NAME] to HTS by 2:30pm? |  | Yes
If No which ones and why?
PROBLEMS AND INFORMATION:
1 | tapes ejected
2 | tapes returned
CRITICAL RECALLS:
 |  |  | Time Karol |  | Tape loaded &
Image |  | [NAME] | Was Contacted | [NAME] | Support Notified
HARDWARE PROBLEMS
Device Type |  | Serial Number | Ticket Number | Problem | Resolved: Y/N
CE Name:
Spreadsheet: 9d8306a3-cfea-42ff-a2a9-14b9b53b731c
Sheet: Sheet1

analytica 2012 - Aussteller Liste | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Suche über Produkt- und Dienstleistungsverzeichnis (10 [NAME]):
 | 5 Labortechnische Geräte 5.3 Bildanalyse und -verarbeitung 5.3.2 Bildverarbeitungssysteme
Nr. | Firma | Land | Ort | PLZ | Halle/Stand
1 | BERTHOLD TECHNOLOGIES GmbH & Co. [NAME] | Deutschland | Bad Wildbad | 75323 | [NAME]
2 | BIO-RAD Laboratories GmbH | Deutschland | München | 80939 | B1.504
3 | [NAME] bm-log c/o [NAME] | Deutschland | Leipzig | 04109 | A3.341
4 | Fraunhofer-Institut für Integrierte Schaltungen IIS | Deutschland | Erlangen | 91058 | A1.433/530
5 | [NAME] Laborgeräte | Deutschland | Wiesloch | 69168 | A3.231
6 | JENOPTIK  l  Optical Systems | Deutschland | Jena | 07745 | A3.533
7 | [NAME] | Deutschland | Wetzlar | 35578 | A2.205/306
8 | [NAME] | Deutschland | Waldbronn | 76337 | A2.217
9 | Sarstedt AG & Co. | Deutschland | Nümbrecht | 51588 | B1.113/212
10 | Sympatec GmbH System-Partikel-Technik | Deutschland | [NAME] | 38678 | A1.123/220
Spreadsheet: 841976d1694087058-change-the-second-transaction-entry-ticket-no-wise-same-ticket-id-with-followup-ticket
Sheet: Sheet1

Ticket no | Query | Output
60001 | Abcs | New Ticket
60002 | [NAME] | New Ticket
60001 | ddd | Followup
60002 | ddd | Followup
60001 | dd | Followup
60003 | kkk | New Ticket
Spreadsheet: 49450d1248801039-inventory-count-inventory-example
Sheet: Inventory

Choose a Warehous # |  | 2600 |  |  |  |  |  | Total Onhand Inv. | Total Used Inv.
ITEM | Vendor # | Desc 1 | Desc 2 | Cost | Onhand | Used | % Used | 24 | 0 | Warehouses
6447 |  |  |  | 1 | 0 | 0 | Out of Stock |  |  | 2600
6446 |  |  |  | 1 | 16 | 0 | 0 | 16 |  | 2601
3456 |  |  |  | 1 | 0 | 0 | Out of Stock |  |  | TOT.
3377 |  |  |  | 1 | 0 | 0 | Out of Stock
3406 |  |  |  | 1 | 0 | 0 | Out of Stock
1452 |  |  |  | 1 | -4 | 0 | None on Hand
1453 |  |  |  | 1 | 8 | 0 | 0 | 8
1458 |  |  |  | 2 | -4 | 18 | None on Hand
1470 |  |  |  | 3 | 6 | 10 | 1.666666666666667
1475 |  |  |  | 4 | -5 | 18 | None on Hand
1492 |  |  |  | 5 | -164 | 233 | None on Hand
2817 |  |  |  | 6 | 5 | 18 | 3.6
Spreadsheet: 85093d1285161128-combining-two-formulas-concatvlookup
Sheet: Sheet1

 |  | Concatenate with VLOOKUP
 |  |  | Fruit | Vehicle |  | Fruit Lookup | Vehicle Lookup | Output
 |  | 1 | Apple | Car |  | 1 | 3 | Apple Motorbike
 |  | 2 | Pear | Van
 |  | 3 | [NAME] | Motorbike
 |  | 4 | Melon | [NAME]
 |  | Adding with SUMIF
 |  | Sumif | Cost | VAT |  |  | Date | Output
 |  | 2010-01-01 00:00:00 | 20 | 3.5 |  |  | 2010-01-03 00:00:00 | 14.1
 |  | 2010-01-02 00:00:00 | 34 | 5.949999999999999
 |  | 2010-01-03 00:00:00 | 12 | 2.1
 |  | 2010-01-04 00:00:00 | 23 | 4.024999999999999
 |  | Adding with an extra data column and finding data with VLOOKUP
 |  | Vlookup | Cost | VAT | Total |  | Date | Output
 |  | 2010-01-01 00:00:00 | 20 | 3.5 | 23.5 |  | 2010-01-02 00:00:00 | 39.95
 |  | 2010-01-02 00:00:00 | 34 | 5.949999999999999 | 39.95
 |  | 2010-01-03 00:00:00 | 12 | 2.1 | 14.1
 |  | 2010-01-04 00:00:00 | 23 | 4.024999999999999 | 27.025
Spreadsheet: 112596d1308677943-help-with-more-efficient-formatting-and-calculations-sample
Sheet: Sheet1

DOMESTIC | 2011-06-11 00:00:00 | 2011-07-12 00:00:00 | 2011-08-12 00:00:00 | 2011-09-12 00:00:00 | Q3 | 2011-10-13 00:00:00 | 2011-11-13 00:00:00 | 2011-12-14 00:00:00 | Q4
 | PLAN | PLAN | PLAN | PLAN | PLAN | PLAN | PLAN | PLAN | PLAN
BOOKINGS
PRODUCT 1 | 13 | 31 | 38 | 31 | 100 | 43 | 43 | 43 | 129
PRODUCT 2 |  |  |  |  | 0 | 6 | 6 | 6 | 18
PRODUCT 3 | 50 | 52 | 66 | 52 | 170 | 53 | 53 | 53 | 159
PRODUCT 4 | 195 | 446 | 558 | 446 | 1450 | 513 | 513 | 513 | 1539
PRODUCT 5 | 40 | 43 | 54 | 43 | 140 | 58 | 58 | 58 | 174
PRODUCT 6 | 10 | 7 | 10 | 7 | 24 | 10 | 10 | 10 | 30
PRODUCT 7 | 50 | 30 | 50 | 30 | 110 | 67 | 67 | 67 | 201
PRODUCT 8 |  |  |  |  | 0 |  |  |  | 0
CONVERSION to Revenue
PRODUCT 1 (.1,.2,.3,.4) |  | 5.7 | 13.9 | 25.2 | 44.8 | 34.3 | 37.4 | 38.2 | 109.9
PRODUCT 2 (.0,.05,.1,.15,.20,.3,.2) |  | 0 | 0 | 0 | 0 | 0 | 0.3 | 0.9000000000000001 | 1.2
PRODUCT 3(.0,.1,.2,.7) |  | 5 | 15.2 | 52 | 72.2 | 54.8 | 61.89999999999999 | 52.3 | 169
PRODUCT 4(.15,.25,.35,.25) |  | 115.65 | 263.45 | 411.25 | 790.3499999999999 | 495.2499999999999 | 500.8 | 496.2499999999999 | 1492.3
PRODUCT 5 (.6,.4) |  | 41.8 | 49.59999999999999 | 47.40000000000001 | 138.8 | 52 | 58 | 58 | 168
PRODUCT 6 (.10,.20,.60,.10) |  | 2.7 | 8.4 | 7.9 | 19 | 9.1 | 8.2 | 9.7 | 27
PRODUCT 7 (.10,.10,.20,.30,.30) |  | 8 | 18 | 29 | 55 | 43.7 | 43.40000000000001 | 50.8 | 137.9
PRODUCT 8 (0,0,.25,.50,.25) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Revenue |  | 178.85 | 368.55 | 572.75 | 1120.15 | 689.15 | 710 | 706.15 | 2105.3
Percentages are in pink above
I am forecasting revenue for the next 6 months.  This is done based upon the orders for each product.
Using product 1 for an example, 10% of the amount in bookings is converted to revenue in the same month
it is booked, 20% in month 2, 30% in month 3 and 40% in month 4.  Each month of bookings must be converted
at the same percentages over 4 months.  So July must = 13*.20+31*10  August must =13*30+31*20+38*10
and so on.
Spreadsheet: 32f8d816-5ed1-4a85-88e2-878d2e0062d8
Sheet: Sheet1

Table 9--U.S. vegetable oil and fats prices | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Marketing | Soybean | Cottonseed | Sunflowerseed | Canola | Peanut | Corn | Lard 6 | Edible
year | oil 2 | oil 3 | oil 4 | oil 4 | oil 5 | oil 6 |  | tallow 6
 | Cents/pound
2003/04 | 29.97 | 31.21 | 33.42 | 33.76 | 60.84 | 28.43 | 26.13 | 22.37
2004/05 | 23.01 | 28.01 | 43.71 | 30.78 | 53.63 | 27.86 | 21.8 | 18.48
2005/06 | 23.41 | 29.47 | 40.64 | 31 | 44.48 | 25.18 | 21.74 | 18.16
2006/07 | 31.02 | 35.7 | 58.03 | 40.57 | 52.99 | 31.8 | 28.43 | 27.32
2007/08 | 52.03 | 73.56 | 91.15 | 65.64 | 94.53 | 69.4 | 40.85 | 41.68
2008/09 | 32.16 | 37.1 | 50.24 | 39.54 | 78.49 | 32.75 | 26.72 | 25.47
2009/10 | 35.95 | 40.27 | 52.8 | 42.88 | 59.62 | 39.29 | 31.99 | 32.26
2010/11 | 53.2 | 54.5 | 86.12 | 58.68 | 77.24 | 60.76 | 51.52 | 51.34
2011/12 | 51.9 | 53.22 | 83.2 | 57.19 | 100.15 | 56.09 | 48.11 | 50.33
2012/13 | 47.13 | 48.6 | 65.87 | 56.17 | 91.83 | 46.66 | 39.64 | 43.24
2013/141 | 35.5-39.5 | 38.5-42.5 | 54.5-58.5 | 40.5-44.5 | 73.0-77.0 | 34.75-38.75 | 40.5-44.5 | 34.0-38.0
2012/13
October | 49.31 | 51.31 | 74 | 57.5 | 103 | 54.75 | 51.6 | 42.27
November | 46.27 | 49.05 | 70.3 | 58.2 | 99.9 | 51.93 | 57 | 37.15
December | 47.16 | 50.06 | 67.5 | 57.13 | 98.56 | 50.63 |  | 40.92
January | 48.85 | 50.94 | 65.25 | 57.19 | 96.75 | 52.06 | 52.45 | 43.5
February | 49.33 | 51.56 | 65 | 59.38 | 86 | 51.71 | 45.56 | 41.93
March | 48.62 | 50.2 | 64.6 | 58.95 | 79.05 | 47.76 |  | 45
April | 49.28 | 49.94 | 64 | 60.44 | 77.5 | 47.06 | 43.5 | 43.5
May | 49.31 | 49.75 | 64 | 60.45 | 80 | 45.23 | 44.5 | 43.86
June | 47.84 | 48.25 | 64 | 57.5 | 82.75 | 42.5 | 48.5 | 48.44
July | 45.19 | 46.19 | 64 | 53.25 | 84 | 38.91 | 53.25 | 49.13
August | 42.33 | 43.1 | 64 | 48.05 | 83 | 38.93 | 56.89 | 43.18
September | 42.12 | 42.81 | 63.75 | 46 | 82 | 38.46 | 64.78 | 40.02
2013/14
October | 39.66 | 41.19 | 60.5 | 44.88 | 81 | 37.85 | 43 | 33.17
November | 39.58 | 42.05 | 57.4 | 45.05 | 78.7 | 38.79 | 48 | 38.88
December1 | 37.63 | 43.19 | 57 | 42.63 | 75.38 | 38.31 | 41.5 | 39.62
1 Preliminary.  2 Decatur, IL.  3 PBSY Greenwood, MS.  4 Midwest. 5 Southeast mills.  6 Chicago.
NA = Not available.
Sources: USDA, Agricultural Marketing Service,  Monthly Feedstuff Prices and Milling and Baking News.
Last update: | 2014-01-14 08:11:24.680000
Spreadsheet: 145493d1331618554-move-done-one-row-and-to-the-left-to-a-specific-column-sample-for-forum
Sheet: Sheet1

DATE | CC | NAME | consign | Ea | Description | Inv | xorig | Unit | Total | [NAME] | CC 3% | CHECK | TAX | [NAME]
2012-03-01 00:00:00 |  | Hubbartt-Pat DPHV |  | 1 | set of soup spoons |  |  | 20 | 20 | 2 | 0 | 18 | 1.55
2012-03-01 00:00:00 |  | Hubbartt-Pat DPH |  | 1 | handcuffs |  |  | 18 | 18 | 1.8 | 0 | 16.2 | 1.395
2012-03-01 00:00:00 |  | Hubbartt-Pat DPH |  | 1 | lock |  |  | 18 | 18 | 1.8 | 0 | 16.2 | 1.395
2012-03-01 00:00:00 |  | Abrams-C#DA | c | 1 | globe |  |  | 12 | 12 | 3.6 | 0 | 8.4 | 0.9299999999999999
2012-03-01 00:00:00 |  | [NAME] |  | 1 | frosted eyeglass holder |  |  | 18 | 18 | 1.8 | 0 | 16.2 | 1.395
2012-03-01 00:00:00 |  | VAM |  | 1 | green pitcher |  |  | 14.95 | 14.95 | 1.495 | 0 | 13.455 | 1.158625
2012-03-01 00:00:00 |  | Elledge-DTE |  | 1 | trq divided plate |  |  | 12.75 | 12.75 | 1.275 | 0 | 11.475 | 0.988125
2012-03-01 00:00:00 | c | Hubbartt-Pat DPH |  | 1 | [NAME] jewelry |  |  | 30 | 30 | 3 | 0.8999999999999999 | 26.1 | 2.325
Spreadsheet: 789469d1659106928-hlook-up-not-working-last-man-standing
Sheet: week 1

 | Week 1
 | NAME | TEAM
 |  |  |  | [NAME] | Norwich City
 |  |  |  | [NAME] | [NAME]
 |  |  |  | [NAME] | Northampton Town
 |  |  |  | [NAME] | Northampton Town
 |  |  |  | Shane | Tranmere Rovers
 |  |  |  | [NAME] | Northampton Town
 |  |  |  | [NAME] | Watford
 |  |  |  | [NAME] | Stockport County
 |  |  |  | [NAME] | [NAME]
 |  |  |  | [NAME] | Stockport County
 |  |  |  | [NAME] | Salford City
 |  |  |  | [NAME] | Stockport County
 |  |  |  | [NAME] | Sheffield Wednesday
 |  |  |  | [NAME] | Sheffield Wednesday
 |  |  |  | Declan Call | Ipswich Town
 |  |  |  | [NAME] | Sunderland
 |  |  |  | Billy | [NAME]
 |  |  |  | [NAME] | Derby County
 |  |  |  | [NAME] | [NAME]
 |  |  |  | [NAME] | Ipswich Town
 |  |  |  | [NAME] | Stockport County
 |  |  |  | [NAME] | Millwall
 |  |  |  | [NAME] | Northampton Town
 |  |  |  | [NAME] | Stockport County
 |  |  |  | 0
Spreadsheet: 118628d1313805345-excel-2007-comparing-a-row-of-numbers-to-a-range-of-numbers-lottery-random-numbers1
Sheet: Sheet1

 |  |  |  |  |  |  |  | Random Numbers
 | Lottery Results |  |  |  |  |  |  | 35 | 10 | 17 | 48 | 47 | 9 | Hits
 | 4 | 38 | 41 | 42 | 43 | 44
 | 9 | 43 | 51 | 54 | 55 | 13
 | 11 | 19 | 39 | 45 | 54 | 15
 | 6 | 24 | 28 | 33 | 42 | 19
 | 14 | 17 | 19 | 20 | 32 | 28
 | 8 | 10 | 22 | 47 | 48 | 35 |  |  |  |  |  |  |  |  | <<Closest to Winning
 | 20 | 25 | 35 | 52 | 55 | 10
 | 23 | 31 | 32 | 39 | 56 | 38
 | 2 | 9 | 10 | 16 | 35 | 40
 | 16 | 29 | 30 | 46 | 56 | 6
 | 3 | 9 | 11 | 44 | 49 | 9
 | 1 | 2 | 22 | 37 | 50 | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  | <<[NAME] have been used