tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 857077d1706155873-calculating-data-from-multiple-sheets-manually-calculated-example
Sheet: Returns 1

 | Pro Forma Summary
 |  |  |  |  | Pro Forma
 |  |  |  |  |  | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036
 |  |  |  |  |  | 1
 |  |  |  |  | TTM | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma | Pro Forma
 | Revenue |  |  |  | 2840000 | 2925200 | 3129964 | 3349061.48 | 3583495.7836 | 3834340.488452001 | 4026057.512874601 | 4227360.388518332 | 4354181.200173882 | 4484806.636179099 | 4619350.835264472
 | [NAME] |  |  |  | 1760800 | 1835634 | 1890703.02 | 1947424.1106 | 2005846.833918 | 2066022.23893554 | 2128002.906103606 | 2191842.993286714 | 2257598.283085316 | 2325326.231577876 | 2395086.018525212
 | Gross Profit |  |  |  | 1079200 | 1089566 | 1239260.98 | 1401637.3694 | 1577648.949682 | 1768318.24951646 | 1898054.606770995 | 2035517.395231617 | 2096582.917088566 | 2159480.404601223 | 2224264.81673926
 | Operating Expenses |  |  |  | 279200 | 291066 | 299797.98 | 308791.9194 | 318055.676982 | 327597.34729146 | 337425.2677102038 | 347548.02574151 | 357974.4665137553 | 368713.7005091679 | 379775.111524443
 | NOI
 | Management Fee Allocation |  | 0.05 |  | 53960 | 54478.3 | 61963.049 | 70081.86847 | 78882.4474841 | 88415.91247582302 | 94902.73033854974 | 101775.8697615809 | 104829.1458544283 | 107974.0202300612 | 111213.240836963
 | EBITDA |  |  |  | 746040 | 744021.7 | 877499.951 | 1022763.58153 | 1180710.8252159 | 1352304.989749177 | 1465726.608722241 | 1586193.499728526 | 1633779.304720382 | 1682792.683861994 | 1733276.464377854
 | [NAME] |  | 0.015 |  | 0 | 43878 | 46949.46 | 50235.9222 | 53752.436754 | 57515.10732678001 | 60390.86269311901 | 63410.40582777497 | 65312.71800260823 | 67272.09954268648 | 69290.26252896708
 | DCF (Unlevered)
Spreadsheet: 265928d1379441245-lookup-a-range-upload-examples
Sheet: Data 1

 | Selling Price |  |  | 0.75
 | 50%+ < List | <50% |  | e.g. Return result from B6
 | 33% to 50% < List | 50% to 66.66%
 | 20% to 33% < List | 66.66% to 80%
 | 10% to 20% < List | 80% to 90%
 | 5% to 10% < List | 90% to 95%
 | 0% to 5% < List | 95% to 100%
 | List Price | 1
 | 0% to 5% > List | 100% to 105%
 | 5% to 10% > List | 105% to 110%
 | 10% to 20% > List | 110% to 120%
 | 20% to 33% > List | 120% to 133.33%
 | 33% to 50% > List | 133.33% to 150%
 | 50%+ > List | >150%
Spreadsheet: 692823d1598595201-need-to-extract-data-and-skip-blanks-machine-shop-schedules_excel-forum-2003
Sheet: Millroom_Laser

Projected Delivery Date (to Production / ENG) | Priority | Part# | S/O # | S/O Due / ENG PROMISE | Rev | ORIG Job Qty | ACTUAL QTY | Raw Mat'l PO / ECO# | Job # | VT MEC PO# | Status | Chemfilm/PASSIVATE | Paint / Silkscreen | PROJECTED RUN TIME (IN DAYS) | Projected Machine Finish Date | Actual Machine Finish Date | Notes | Ready for Plating process
2020-08-28 00:00:00 | 1900-01-01 00:00:00 | PN 16 |  |  | A1 | 1 |  |  | 27418 |  |  | No | No |  | 2020-08-28 00:00:00
2020-08-28 00:00:00 | 1900-01-01 00:00:00 | PN 17 |  |  | A | 2 |  |  | 27612 |  |  | No | No |  | 2020-08-28 00:00:00
2020-08-28 00:00:00 | 2019-08-20 00:00:00 | PN 18 | 16336 | 2019-08-20 00:00:00 | A | 12 |  |  | 21579 | - |  | No | No | 0.04166666666666666 | 2020-08-28 00:00:00 |  | LASER SHELF
2020-08-28 00:00:00 | 2019-08-30 00:00:00 | PN 19 | 16336 | 2019-08-30 00:00:00 | A | 10 |  |  | 20528 | - |  | No | No | 0.04166666666666666 | 2020-08-28 00:00:00
2020-08-28 00:00:00 | 2019-09-05 00:00:00 | PN 20 | NPI | 2019-09-05 00:00:00 | A | 1 |  |  | 27624 |  |  | No | No |  | 2020-08-28 00:00:00
2020-09-02 00:00:00 | 2020-02-21 00:00:00 | PN 21 | 16771 | 2020-02-21 00:00:00 | B | 3 |  |  | 26791 | - |  | Yes | No | 0 | 2020-08-28 00:00:00 |  |  | x
2020-08-28 00:00:00 | 2020-03-10 00:00:00 | PN 22 | 16756 | 2020-03-10 00:00:00 | A2 | 2 |  |  | 27394 |  |  | No | No |  | 2020-08-28 00:00:00
2020-09-02 00:00:00 | 2020-03-13 00:00:00 | PN 23 | 16782 | 2020-03-13 00:00:00 | A | 10 |  |  | 26113 | - |  | Yes | No | 0.04166666666666666 | 2020-08-28 00:00:00 |  |  | x
2020-09-02 00:00:00 | 2020-03-13 00:00:00 | PN 24 | 16657 | 2020-03-13 00:00:00 | A | 5 |  |  | 27283 |  |  | Yes | No |  | 2020-08-28 00:00:00 |  |  | x
2020-08-28 00:00:00 | 2020-03-20 00:00:00 | PN 25 | 15889 | 2020-03-20 00:00:00 | A | 27 |  |  | 26850 |  |  | No | No |  | 2020-08-28 00:00:00
2020-08-28 00:00:00 | 2020-03-20 00:00:00 | PN 26 | 15889 | 2020-03-20 00:00:00 | A | 17 |  |  | 27289 |  |  | No | No |  | 2020-08-28 00:00:00
2020-08-28 00:00:00 | 2020-03-20 00:00:00 | PN 27 | 15889 | 2020-03-20 00:00:00 | A | 17 |  |  | 27289 |  |  | No | No |  | 2020-08-28 00:00:00
2020-08-28 00:00:00 | 2020-03-20 00:00:00 | PN 28 | 15889 | 2020-03-20 00:00:00 | A | 35 |  |  | 27290 |  |  | No | No |  | 2020-08-28 00:00:00
2020-09-02 00:00:00 | 2020-05-04 00:00:00 | PN 29 | 17020 | 2020-05-04 00:00:00 | A | 5 |  |  | 25052 | - |  | Yes | No | 0.04166666666666666 | 2020-08-28 00:00:00 |  |  | x
2020-09-02 00:00:00 | 2020-05-08 00:00:00 | PN 30 | 17025 | 2020-05-08 00:00:00 | A | 19 |  |  | 24729 | - |  | Yes | No | 0.04166666666666666 | 2020-08-28 00:00:00 |  |  | x
Spreadsheet: a6a6dbe8-0e83-4a4d-876d-87037694536e
Sheet: TTM Recon Q2FY11

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations - Trailing Twelve Months (TTM)
(in millions, except per share data)
 | Trailing Twelve Months Ended September 30, 2010
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on licensed intellectual property commitment (COGS) |  | Gain on Strategic Investments |  | Restructuring Charges |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 3668 |  | 0 |  | -49 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 3619
Cost of goods sold | 1537 |  | -10 |  | 0 |  | 2 |  | 0 |  | 0 |  | -2 |  | 0 |  | 1527
Gross profit | 2131 |  | 10 |  | -49 |  | -2 |  | 0 |  | 0 |  | 2 |  | 0 |  | 2092
Operating expenses:
Marketing and sales | 679 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -18 |  | 0 |  | 661
General and administrative | 314 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -40 |  | 0 |  | 274
Research and development | 1153 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -114 |  | 0 |  | 1039
Acquisition-related contingent consideration | -24 |  | 24 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 59 |  | -59 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring charges | 128 |  | 0 |  | 0 |  | 0 |  | 0 |  | -128 |  | 0 |  | 0 |  | 0
Total operating expenses | 2309 |  | -35 |  | 0 |  | 0 |  | 0 |  | -128 |  | -172 |  | 0 |  | 1974
Operating income (loss) | -178 |  | 45 |  | -49 |  | -2 |  | 0 |  | 128 |  | 174 |  | 0 |  | 118
Gain on strategic investments | 21 |  | 0 |  | 0 |  | 0 |  | -21 |  | 0 |  | 0 |  | 0 |  | 0
Interest and other income, net | 2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 2
Income (loss) before provison for income taxes | -155 |  | 45 |  | -49 |  | -2 |  | -21 |  | 128 |  | 174 |  | 0 |  | 120
Provision for income taxes | 2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 32 |  | 34
Net income (loss) | -157 |  | 45 |  | -49 |  | -2 |  | -21 |  | 128 |  | 174 |  | -32 |  | 86
Loss per share |  |  |  |  |  |  |  |  |  |  |  |  | Earnings per share
Diluted | -0.48 |  |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 0.26
Spreadsheet: 826894d1682357418-subtract-only-if-other-column-equals-specific-cell-data-sample-v2
Sheet: Sheet1

DATE OF PURCHASE | PURCHASER | AMOUNT | PURCHASE TYPE | ACCOUNT NAME | ACCOUNT NUMBER | SUPERVISOR NOTIFIED (Y/N) | SUPERVISOR INITIALS
2023-04-21 00:00:00 | EXAMPLE | 0 | CC | N/A | N/A | N |  | Purchase Type (COLUMN D) |  |  |  | Total Purchased:
2023-04-21 00:00:00 | [NAME] | 400 | PO | Regular Pay | 1110-5110-5102-51110 | N |  | Petty Cash | PC
 |  | 100 |  |  | 1110-5110-5102-51110 |  |  | Credit Card | CC
 |  | 100 |  |  | 1110-5110-5102-51110 |  |  | [NAME] | PO
 |  |  |  |  |  |  |  | ACCOUNTS
 |  | 23000 |  |  | 1110-5110-5102-51111 |  |  | Name | Number | Approportion Amount | Amount after expense
 |  |  |  |  |  |  |  | Regular Pay | 1110-5110-5102-51110 | 229077 | 229077
 |  |  |  |  |  |  |  | Regular Part-Time Pay | 1110-5110-5102-51111 | 78424 | 78424 |  | 55424
 |  |  |  |  |  |  |  | Overtime Pay | 1110-5110-5102-51115 | 0 | 0 |  | 0
 |  |  |  |  |  |  |  | Medicare Tax | 1110-5110-5102-52110 | 4382.72 | 4382.72 |  | 4382.72
 |  |  |  |  |  |  |  | PERS | 1110-5110-5102-52111 | 128511.24 | 128511.24 |  | 128511.24
 |  |  |  |  |  |  |  | Health Insurance | 1110-5110-5102-52112 | 72214.19 | 72214.19 |  | 72214.19
 |  |  |  |  |  |  |  | Workers Compensation | 1110-5110-5102-52113 | 4386.62 | 4386.62 |  | 4386.62
 |  |  |  |  |  |  |  | Deferred Compensation | 1110-5110-5102-52114 | 852.28 | 852.28 |  | 852.28
 |  |  |  |  |  |  |  | Disablity Insurance | 1110-5110-5102-5215 | 741.4 | 741.4 |  | 741.4
 |  |  |  |  |  |  |  | Office Supplies (Non-Paper) | 1110-5110-5102-53101 | 2000 | 2000 |  | 2000
 |  |  |  |  |  |  |  | [NAME] | 1110-5110-5102-53401 | 700 | 700 |  | 700
 |  |  |  |  |  |  |  | Recreational Supplies | 1110-5110-5102-53601 | 2100 | 2100 |  | 2100
 |  |  |  |  |  |  |  | Other Supplies | 1110-5110-5102-53701 | 1800 | 1800 |  | 1800
 |  |  |  |  |  |  |  | Office Supplies (Paper) | 1110-5110-5102-53801 | 0 | 0 |  | 0
 |  |  |  |  |  |  |  | Contractual Services | 1110-5110-5102-54111 | 10000 | 10000 |  | 10000
 |  |  |  |  |  |  |  | Banking Service Fees | 1110-5110-5102-54116 | 200 | 200 |  | 200
 |  |  |  |  |  |  |  | Repair/Maint-Other | 1110-5110-5102-54124 | 3000 | 3000 |  | 3000
 |  |  |  |  |  |  |  | Printing & Reproduction-Paper Only | 1110-5110-5102-54214 | 6000 | 6000 |  | 6000
 |  |  |  |  |  |  |  | Rentals | 1110-5110-5102-54217 | 0 | 0 |  | 0
 |  |  |  |  |  |  |  | Travel & Training | 1110-5110-5102-54310 | 200 | 200 |  | 200
 |  |  |  |  |  |  |  | Miscellanous Charges | 1110-5110-5102-54500 | 4000 | 4000 |  | 4000
 |  |  |  |  |  |  |  | N/A | N/A | Grand Total: 548,589.45 | 548589.45
Spreadsheet: 626b55b0-f651-405c-8d62-c613fbc7844d
Sheet: Sheet1

Table 5--Wheat: National average price received by farmers (dollars per bushel) 1/, 4/11/2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Month | All wheat |  | Winter |  | Durum |  | Other spring
 | 2012/13 | 2013/14 | 2012/13 | 2013/14 | 2012/13 | 2013/14 | 2012/13 | 2013/14
June | 6.7 | 7.32 | 6.55 | 7.18 | 8.31 | 8.26 | 7.78 | 7.72
July | 7.89 | 6.93 | 7.76 | 6.85 | 8.67 | 8.17 | 8.39 | 7.29
August | 8.04 | 6.87 | 7.92 | 6.81 | 7.76 | 7.76 | 8.27 | 6.97
September | 8.27 | 6.8 | 8.25 | 6.79 | 7.77 | 7.9 | 8.38 | 6.71
October | 8.38 | 7 | 8.33 | 7.07 | 7.61 | 7.12 | 8.56 | 6.84
November | 8.47 | 6.85 | 8.38 | 6.96 | 8.11 | 6.75 | 8.65 | 6.7
December | 8.3 | 6.73 | 8.15 | 6.84 | 8.31 | 6.96 | 8.48 | 6.56
January | 8.12 | 6.66 | 8.01 | 6.73 | 8.24 | 7.06 | 8.34 | 6.48
February | 7.97 | 6.49 | 7.85 | 6.57 | 8.19 | 6.46 | 8.11 | 6.4
March | 7.79 | 6.9 | 7.63 | 7.03 | 8.12 | 6.85 | 7.95 | 6.74
April | 7.71 |  | 7.52 |  | 8.01 |  | 7.9
May | 7.68 |  | 7.49 |  | 8.06 |  | 7.84
1/ Preliminary mid-month, weighted-average price for current month. Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Date run: 4/11/2014
Spreadsheet: michelle_lokay__26703__imball0112
Sheet: SWGasTrans

 | SW Gas Transmission Co - contr27380
 | POI 78003 - TW/SGTC Mojave Del
Day | Measured | Scheduled
1 | -13990 | -14000
2 | -13992 | -14000
3 | -14009 | -14000
4 | -14013 | -14000
5 | -13999 | -14000
6 | -13873 | -13944
7 | -14088 | -13955
8 | -13865 | -14000
9 | -13897 | -14000
10 | -13902 | -14000
11 | -14419 | -14000
12 | -14067 | -14000
13 | -13881 | -14000
14 | -13922 | -14000
15 | -13942 | -14000
16 | -13935 | -14000
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | -482.28
2001-12-16 00:00:00
CBS Volume
 |  |  | 12777
Spreadsheet: 88289d1288158527-retrieve-row-data-sample
Sheet: Sheet1

 | serial no. | [NAME] | data2 | data3 | data4
 | 1 | asd | asd | asd | asdf
 | 2 | sef | ass | dfgdgf | asdf
 | 3 | dasdf | dsfd | sadfs | sdfsdf
 | 4 | dsfds | dsfsad | sdfsa | ssf
 | 5 | gfdg | dgfsd | [NAME] | were
Spreadsheet: 105861d1303141718-match-and-index-problem-test15
Sheet: Sheet1

Value | B | C | D | E | F | G
0.001 | 0.003 | 0.006 | 0.02 | 0.06 | 0.2
0.002 | 0.003 | 0.006 | 0.02 | 0.06 | 0.2 |  |  |  | Value = | 10
0.005 | 0.003 | 0.006 | 0.02 | 0.06 | 0.2 |  |  |  | Type= | B
0.01 | 0.003 | 0.008 | 0.025 | 0.08 | 0.25
0.02 | 0.003 | 0.01 | 0.03 | 0.1 | 0.3 |  |  |  | Result = | INDEX(A1:G31,MATCH(K4,A1:G1,0),MATCH((K3,A1:A31)+(A1:A31,1)<>K3))
0.05 | 0.004 | 0.012 | 0.04 | 0.12 | 0.4
0.1 | 0.005 | 0.016 | 0.05 | 0.16 | 0.5 | 1.6
0.2 | 0.006 | 0.02 | 0.06 | 0.2 | 0.6 | 2
0.5 | 0.008 | 0.025 | 0.08 | 0.25 | 0.8 | 2.5 |  |  | Match Value - if not exact then next highest
1 | 0.01 | 0.03 | 0.1 | 0.3 | 1 | 3 |  |  | Val = | 15
2 | 0.012 | 0.04 | 0.12 | 0.4 | 1.2 | 4 |  |  | Next highest | 20
5 | 0.016 | 0.05 | 0.16 | 0.5 | 1.6 | 5
10 | 0.02 | 0.06 | 0.2 | 0.6 | 2 | 6
20 | 0.025 | 0.08 | 0.25 | 0.8 | 2.5 | 8
50 | 0.03 | 0.1 | 0.3 | 1 | 3 | 10
100 | 0.05 | 0.16 | 0.5 | 1.6 | 5 | 16
200 | 0.1 | 0.3 | 1 | 3 | 10 | 30
500 | 0.25 | 0.8 | 2.5 | 8 | 25 | 80
1000 | 0.5 | 1.6 | 5 | 16 | 50 | 160
2000 | 1 | 3 | 10 | 30 | 100 | 300
5000 | 2.5 | 8 | 25 | 80 | 250 | 800
10000 | 5 | 16 | 50 | 160 | 500 | 1600
20000 | 10 | 30 | 100 | 300 | 1000 | 3000
50000 | 25 | 80 | 250 | 800 | 2500 | 8000
100000 |  | 160 | 500 | 1600 | 5000 | 16000
200000 |  | 300 | 1000 | 3000 | 10000 | 30000
500000 |  | 800 | 2500 | 8000 | 25000 | 80000
1000000 |  | 1600 | 5000 | 16000 | 50000 | 160000
2000000 |  |  | 10000 | 30000 | 100000 | 300000
5000000 |  |  | 25000 | 80000 | 250000 | 800000
Spreadsheet: chris_stokley__3872__pges-meter 4-29-01
Sheet: stl_CA20010429v1_loadtoPWX

 |  |  |  |  | HR-1 | HR-2 | HR-3 | HR-4 | HR-5 | HR-6 | HR-7 | HR-8 | HR-9 | HR-10 | HR-11 | HR-12 | HR-13 | HR-14 | HR-15 | [NAME] | HR-17 | HR-18 | HR-19 | HR-20 | HR-21 | HR-22 | HR-23 | HR-24
PGES | PGE1 | 20010429 | D | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PGES | PGE1 | 20010429 | R | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PGES | PGE2 | 20010429 | D | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PGES | PGE2 | 20010429 | R | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PGES | PGE3 | 20010429 | D | 1 | 10.69 | 9.83 | 9.26 | 8.97 | 9.07 | 9.64 | 10.69 | 11.93 | 13.55 | 14.41 | 14.89 | 15.17 | 14.89 | 14.41 | 13.74 | 13.93 | 14.31 | 14.7 | 15.46 | 16.03 | 17.18 | 16.41 | 14.22 | 11.64
PGES | PGE3 | 20010429 | R | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PGES | PGE4 | 20010429 | D | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PGES | PGE4 | 20010429 | R | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PGES | SDG1 | 20010429 | D | 1 | 21.54 | 21.06 | 20.88 | 21.5 | 23.12 | 25.79 | 27.13 | 27.93 | 29.05 | 30.08 | 30.65 | 31.29 | 32.02 | 32.26 | 32.31 | 32.2 | 31.72 | 31.38 | 31.1 | 30.28 | 28.68 | 26.56 | 24.49 | 22.43
PGES | SDG1 | 20010429 | R | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PGES | SCE1 | 20010429 | D | 1 | 3.75 | 3.44 | 3.39 | 3.37 | 3.42 | 3.73 | 4.32 | 4.35 | 4.45 | 4.53 | 4.58 | 4.58 | 4.63 | 4.69 | 4.74 | 4.74 | 4.76 | 4.71 | 4.79 | 4.84 | 4.79 | 4.61 | 4.35 | 4.04
PGES | SCE1 | 20010429 | R | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PGES | SMD1 | 20010429 | D | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PGES | SMD1 | 20010429 | R | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PGES | MID1 | 20010429 | D | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PGES | MID1 | 20010429 | R | 4 | 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
Spreadsheet: 717039d1612455527-if-statement-else-move-to-the-next-cell-book2
Sheet: Sheet2

Brand Name | Type | H/A | Qty
Spreadsheet: 41296d1239792899-vlookup-from-multiple-sheets-shift-schedule
Sheet: WELDING

WELDING
[NAME]. | SAP NO. | NAME | SECTION
 | 148 |  |  | A.
 | 156 |  |  | A.
 | 121 |  |  | A.
 | 157 |  |  | A.
 | 117 |  |  | A.
 | 139 |  |  | A.
 | 141 |  |  | B.
 | 214 |  |  | A.
 | 150 |  |  | B.
 | 147 |  |  | A,
 | 167 |  |  | A.
 | 145 |  |  | B.
 | 207 |  |  | B.
Spreadsheet: daren_farmer__5510__hpl1005
Sheet: Sheet1

HPLN1005.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - October 5, 2000
 |  |  |  |  |  | ** Thursday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-10-05 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 30  0900hrs | 0 to 30  0900hrs
 |  |  |  |  | 30  to 0 2100hrs | 30  to 0 2100hrs
 |  | Firm Summary
ENA (S) |  | LS Mivida |  |  | 7.92 | 7.92
ENA (S) |  | LS Range/Lomax I.C. |  |  | 1.78 | 1.78
ENA (S) |  | Oasis Turbine |  |  | 5 | 0
ENA (S) |  | Oasis Sealy |  |  | 20 | 30
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 851200d1701422986-mixing-lines-that-get-a-reference-colum-2-posatl-only
Sheet: Feuil1

 | 10300 SAINTE-SAVINE | Internet, téléphonie fixes, mobiles & communication unifiée | Les équipes de Christophe BARDON s’engagent au quotidien pour vous apporter qualité et satisfaction. |  | example: | 10300 | 10300 SAINTE-SAVINE | Internet, téléphonie fixes, mobiles & communication unifiée, Sécurité et protection de votre réseau informatique, | Les équipes de Christophe BARDON s’engagent au quotidien pour vous apporter qualité et satisfaction.
 | 10300 SAINTE-SAVINE | Dématérialisation des documents, archivage et GED | Les équipes de Christophe BARDON s’engagent au quotidien pour vous apporter qualité et satisfaction. |  |  |  |  | On the top of this cell, get C1+C2+C3+C4 cell in one | On the top of this cell get only one of the D1 or D2/D3/D4 | Just end with something like the yellow background line "I get more than 200 to do, soooo won't do it by hands lol"
 | 10300 SAINTE-SAVINE | Multifonctions, photocopieurs, imprimantes et traceurs | Les équipes de Christophe BARDON s’engagent au quotidien pour vous apporter qualité et satisfaction.
 | 10300 SAINTE-SAVINE | Sécurité et protection de votre réseau informatique | Les équipes de Christophe BARDON s’engagent au quotidien pour vous apporter qualité et satisfaction.
 | 10410 SAINT-PARRES-AUX-TERTRES | Internet, téléphonie fixes, mobiles & communication unifiée | Les équipes de Christophe BARDON s’engagent au quotidien pour vous apporter qualité et satisfaction.
 | 10410 SAINT-PARRES-AUX-TERTRES | Dématérialisation des documents, archivage et GED | Les équipes de Christophe BARDON s’engagent au quotidien pour vous apporter qualité et satisfaction.
 | 10410 SAINT-PARRES-AUX-TERTRES | Multifonctions, photocopieurs, imprimantes et traceurs | Les équipes de Christophe BARDON s’engagent au quotidien pour vous apporter qualité et satisfaction.
 | 10410 SAINT-PARRES-AUX-TERTRES | Sécurité et protection de votre réseau informatique | Les équipes de Christophe BARDON s’engagent au quotidien pour vous apporter qualité et satisfaction.
Spreadsheet: 06fbcb29-01d6-44ca-b0be-5d204243d729
Sheet: Sheet1

New York State Energy Research and Development Authority | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Solicitation No. 2458 | Unnamed: 6 | Unnamed: 7
Contract Pricing Proposal Form
Contractor: |  |  |  |  | Name of Proposed Project:
Address:
Location (where work is to be performed): |  |  |  |  | NYSERDA Funding: |  | 0
 |  |  |  |  | Total Project Cost: |  | 0
 |  |  |  |  | Total | Funding & | Cost-sharing
 |  |  |  |  | Project | Co-funding | & Other
Cost Element |  |  |  |  | Cost | via NYSERDA | Co-funding
1.   Direct Materials
a. Purchased Parts
b. Other
Total Direct Materials |  |  |  |  | 0 | 0 | 0
2.   Materials Overhead |  |  | Rate:
3.   Direct Labor (specify names/titles) |  |  | Hours | Rate/hr
Total Direct Labor |  |  |  |  | 0 | 0 | 0
4.   Labor Overhead |  |  | Rate % | $ [NAME]
Total Labor Overhead |  |  |  |  | 0 | 0 | 0
5.   Outside Special Testing
6.   Equipment
7.   Travel
8.   Other Direct Costs
9.   Subcontractors/Consultants
Total Subcontractors/Consultants |  |  |  |  | 0 | 0 | 0
10. General & Administrative Expense |  |  | Rate % | Element(s)
11. Fee or Profit  (if allowable)      Rate: |  |  |  |  | 0 | 0 | 0
12. Total Estimated Project Cost |  |  |  |  | 0 | 0 | 0
Spreadsheet: 546351d1509996323-top-categories-sort-out-searcha
Sheet: Sheet1

Fruits |  | 3 |  | Meat |  | 13 |  | Meat |  | 13
 | Apples | 1 |  | Vegetables |  | 9 |  |  | Cow | 6
 | Bananas | 2 |  |  | Chicken | 7 |  |  | Chicken | 7
 |  |  |  |  | Cow | 6 |  | Vegetables |  | 9
Vegetables |  | 9 |  |  | Tomatoes | 5 |  |  | Lettuce | 4
 | Lettuce | 4 |  |  | Lettuce | 4 |  |  | Tomatoes | 5
 | Tomatoes | 5 |  | Fruits |  | 3 |  | Fruits |  | 3
 |  |  |  |  | Bananas | 2 |  |  | Apples | 1
Meat |  | 13 |  |  | Apples | 1 |  |  | Bananas | 2
 | Cow | 6
 | Chicken | 7
Spreadsheet: 142592d1329921911-how-to-split-some-qty-with-respect-to-a-particular-constant-example
Sheet: Sheet1

 |  |  |  |  |  |  | split-up | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6
 | PER DAY O/P |  |  |  | [NAME] | BY WHEN | DATE | QTY | DATE | QTY | DATE | QTY | DATE | QTY | DATE | QTY | DATE | QTY
APPLE | 300 |  |  | APPLE | 1000 | 2012-04-15 00:00:00 | 2012-04-15 00:00:00 | 300 | 2012-04-14 00:00:00 | 300 | 2012-04-13 00:00:00 | 300 | 2012-04-12 00:00:00 | 100 |  | 0 |  | 0
ORANGE | 46 |  |  | ORANGE | 250 | 2012-06-04 00:00:00 | 2012-06-04 00:00:00 | 46 | 2012-06-03 00:00:00 | 46 | 2012-06-02 00:00:00 | 46 | 2012-06-01 00:00:00 | 46 | 2012-05-31 00:00:00 | 46 | 2012-05-30 00:00:00 | 20
Spreadsheet: 121207d1315922407-how-to-use-different-calculations-depending-on-state-of-one-cell-example-
Sheet: MS New Business  (2)

Payment Expected | Payment Received | Adviser Payment | HAM % | HAM Payment | [NAME] | Intro % | IntroPayment | Payment         Ref Number
300 | 300 | 180 | 0.4 | 120 |  | 0 | 0 | 125
300 | 300 | 144 | 0.32 | 96 | IR1 | 0.2 | 60 | 126
300 | 300 | 126 | 0.28 | 84.00000000000001 | IR2 | 0.3 | 90 | 127
 |  |  |  |  |  |  |  |  | Code |  |  | HAM% | Intro %
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | IR1 |  |  | 0.28 | 0
 |  |  |  |  |  |  |  |  | IR2 |  |  | 0.32 | 0.2
 |  |  |  |  |  |  |  |  | IR3 |  |  | 0.4 | 0.3
 |  |  |  |  |  |  |  |  | IR4
 |  |  |  |  |  |  |  |  | IR5
 |  |  |  |  |  |  |  |  | IR6
 |  |  |  |  |  |  |  |  | IR7
 |  |  |  |  |  |  |  |  | IR8
 |  |  |  |  |  |  |  |  | IR9
 |  |  |  |  |  |  |  |  | IR10
 |  |  |  |  |  |  |  |  | IR11
 |  |  |  |  |  |  |  |  | IR12
 |  |  |  |  |  |  |  |  | IR13
 |  |  |  |  |  |  |  |  | IR14
 |  |  |  |  |  |  |  |  | IR15
 |  |  |  |  |  |  |  |  | IR16
 |  |  |  |  |  |  |  |  | IR17
 |  |  |  |  |  |  |  |  | IR18
 |  |  |  |  |  |  |  |  | IR19
 |  |  |  |  |  |  |  |  | IR20
 |  |  |  |  |  |  |  |  | IR21
 |  |  |  |  |  |  |  |  | IR22
 |  |  |  |  |  |  |  |  | IR23
 |  |  |  |  |  |  |  |  | IR24
 |  |  |  |  |  |  |  |  | IR25
 |  |  |  |  |  |  |  |  | IR26
 |  |  |  |  |  |  |  |  | IR27
 |  |  |  |  |  |  |  |  | IR28
 |  |  |  |  |  |  |  |  | IR29
 |  |  |  |  |  |  |  |  | IR30