tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 146336d1332116965-assign-values-to-drop-down-list-marketingbook
Sheet: Sheet1

Metrics | Evaluate | Behaviour | Cost | BrandVariables | Hybrid
Evaluate | Past results | Increase in attendance or clientele | Conversion rate | Customer satisfaction levels
Behaviour | Industry benchmarks or averages | Web traffic, depth of navigation, CTR etc | ROI | Customers impression of brand/ product
Cost | Set goals and requirements | Complaints | Cost per new client acquisition/ cost per sale | Brand awareness/ recognition
BrandVariables |  | Change in customer behaviour / buying habits | Production cost
Hybrid
Spreadsheet: matt_motley__26430__CustomEOLTicker-Mo
Sheet: EOLID's

ID'S |  | NYMEX | HUB | PERM | SJ | WAHA | HSC | PEPL | NGPL LA | MIDCON | [NAME] | CHIC | STPK | SEHR | SB-PTK | SB-STK | SB-SEHR | MALIN | PGE | P-TPK | OPAL | CIG | CHEY | WIC | SUMAS
CASH |  |  | 27763 | 27761 | 49639 | 52231 |  | 27826 | 27817 | 27764 | 27824 | 27814 | 27762 | 43788 | 51408 |  |  | 27827 | 27765 |  | 27825 | 33884 | 34860 | 33885 | 31101
BOM1 |  |  | 28312 | 28207 | 28329 | 28273 | 28148 | 28264 | 28254 | 43954 | 28262 | 36179 |  | 28268 | 47328 |  |  | 28254 | 28266 |  | 28252 | 44738 | 44750
BOM2 |  |  | 28251 | 28310 | 28311 | 28325 | 28323 | 28265 | 36224 | 43950 | 28263 | 28206 |  | 28324 | 47130 |  |  | 28314 | 28317 |  | 28313 | 44746 | 44752
PHYFIX |  |  |  | 37163 | 49633 | 51346 |  | 36305 | 48418 | 36798 | 37256 | 36259 |  | 45094 | 51492 | 51492 |  | 37168 | 36856 | 51492 | 36855 | 37161 | 37162 | 37171
PHYIDX |  |  |  | 36319 | 49647 | 51348 | 54524 | 36313 | 37169 | 37166 | 37147 | 44515 | 36862 | 37196 | 45309 | 45340 | 45338 | 37184 | 36863 |  | 37305 | 37120 | 48400 | 48404
PROMPT | AUG | 49609 |  | 36157 | 36159 | 47099 | 36113 | 36137 | 46982 | 38615 | 38619 | 36100 |  | 36213 | 45390 |  |  | 37089 | 39256 |  | 36135 | 41283 |  |  | 36400
PROMPT+1 | SEP | 49613 |  | 36158 | 36160 | 37116 | 36119 |  |  |  |  |  |  | 36214 | 49139 |  |  | 37090 | 39258 |  | 36136 | 41313
PROMPT+2 | OCT | 49615 |  | 45898 | 38910 | 39370 | 39240 |  |  |  |  |  |  | 38914 | 51854 |  |  | 39252 | 39260 |  | 38936 | 47664
PROMPT+3 | NOV |  |  | 39120 | 39122 | 39372 | 39242 |  |  |  |  |  |  | 39264 | 51856 |  |  | 39254 | 39262 |  | 39302
PROMPT+4 | DEC |  |  | 54874 | 47136 | 54876 | 54894 |  |  |  |  |  |  | 54566 | 51858
PROMPT+5 | JAN |  |  | 54878 |  | 54886 | 54896 |  |  |  |  |  |  | 54552
PROMPT+6 | FEB |  |  | 54880 |  | 54888 | 54898 |  |  |  |  |  |  | 55244
SEASON1 | AUG-OCT | 52722 |  | 54094 | 54096 | 54109 | 54098 |  |  |  |  |  |  | 54100
SEASON2 | NO-MAR 02 | 35353 |  | 37321 | 34972 | 37322 |  |  |  |  |  |  |  | 34973 | 51860 |  |  | 36698 | 45213 |  | 37288 | 41229
SEASON3 | AP-OCT 02 | 54674 |  | 46976 | 47140 | 47976 |  |  |  |  |  |  |  | 47486 |  |  |  | 49607 | 49605 |  | 41225 | 47666
SEASON4 | NO-MAR 03 |  |  |  |  |  |  |  |  |  |  |  |  | 55853 |  |  |  | 55841 | 55843 |  | 41227 | 55829
CAL2 | CAL2 | 48724 |  | 45518 | 34744 |  |  |  |  |  |  |  |  | 34746 |  |  |  |  |  |  | 34747 | 46086
CAL3 | CAL3 | 51173 |  |  | 34749 |  |  |  |  |  |  |  |  | 34750 |  |  |  |  |  |  | 34752 | 46088
CAL4 | CAL4 |  |  |  |  |  |  |  |  |  |  |  |  | 34759
Spreadsheet: 875934d1722544286-array-formula-with-two-different-filter-formulas-side-by-side-with-blank-column-inbetween-timmer2005-excel-test-book-tms
Sheet: Report

[NAME] | Network ID |  | All Leader Names | Leader ID
Test | 123 |  | Sue | 765 |  |  | Only Colleagues who need training are listed in column A and only unique list of leaders who have colleagues needing training are listed in columns D and E.
[NAME] | 654 |  | [NAME] | 3453
[NAME] | 2354 |  | [NAME] | 56785
[NAME] | 546743
[NAME] | 234
 | 123 |  | Sue | 765
[NAME] | 654 |  | [NAME] | 3453
[NAME] | 2354 |  | [NAME] | 56785
[NAME] | 546743
[NAME] | 234
 | 123 |  | Sue | 765
[NAME] | 654 |  | [NAME] | 3453
[NAME] | 2354 |  | [NAME] | 56785
[NAME] | 546743
[NAME] | 234
Spreadsheet: 791710d1660560913-formula-enhancement-for-detecting-numbers-lower-or-greater-by-1-in-row-above-lower-or-greater-by-1
Sheet: PRP

NUMBERS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LOWER by 1 | GREATER by 1 |  |  | PRIME | NON-prime | EVEN | ODD | NEXT |  |  |  |  |  |  |  |  |  | PRIME/NON-prime |  |  |  |  |  |  |  |  |  | EVEN/ODD
2 | 2 | 0 | 6
3 | 2 | 3 | 3
2 | 2 | 1 | 1
2 | 7 | 1
0 | 0 | 3 | 7
1 | 0 | 2 | 7
1 | 2 | 2 | 6
1 | 5 | 4 | 1
0 | 3 | 5
0 | 4 | 6
0 | 6 | 3
1 | 0 | 6 | 5
3 | 1 | 7
3 | 1 | 1 | 1
2 | 2 | 1 | 4
1 | 0 | 1
1 | 10
1 | 2 | 1 | 0
0 | 1 | 4 | 3
Spreadsheet: d851acdc-6d07-45e4-b01a-92a0e2bccc56
Sheet: Sheet1

LUTHERAN THEOLOGICAL SEMINARY AT GETTYSBURG | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
CERTIFICATE IN THEOLOGICAL STUDIES PROGRAM
REGISTRATION FOR 2012-13
 |  | [NAME]: |  |  |  |  |  | DATE:
 |  | SSN: |  |  | xxx-xx- |  | (last 4 digits only)
 |  | [NAME] (PLEASE PRINT):
Term: |  |  |  |  |  |  |  | Registration Deadline:
September 5-8, 2012 |  |  |  |  |  |  |  | August 20, 2012
 | Wed: 6:30-8:30; Th & F: 8:30-11:30, 1:30-4:00, 6:30-8:30; S: 8:30-11:30
January 9-12, 2013 |  |  |  |  |  |  |  | December 14, 2012
 | Wed: 6:30-8:30; Th & F: 8:30-11:30, 1:30-4:00, 6:30-8:30; S: 8:30-11:30
July  7-13, 2013 |  |  |  |  |  |  |  | June 14, 2013
 | Course A: Su: 5:45-6:45; M-F 8:30-11:45; S: 8:30-9:30
 | Course B: Su: 7:00-8:00; M-F 1:30-4:45; S: 9:45-10:45
 | Course C: Su: 8:15-9:15; M-F 6:15-9:30; S: 11-noon
 |  | REGISTER |  | GRADE
TERM |  | WITH X |  | CHOICE |  | Letter [NAME]; Pass/Fail Grade - PF
SEPT |  |  |  |  |  | 12.500 | [NAME] and [NAME]
JAN |  |  |  |  |  | 12.600 | Theological Ethics
JULY | A |  |  |  |  | 13.100 | [NAME]
JULY | B |  |  |  |  | 11.300 | Biblical Foundations for Stewardship & Evangelism
JULY | C |  |  |  |  | 12.700 | [NAME]
 |  | RETURN TO REGISTRAR'S OFFICE AT LTSG
 |  | QUESTIONS? ASK DR. [NAME] AT [EMAIL] or [PHONE]
 |  | Office Use Only: |  |  |  |  |  |  |  | 07/10
 |  |  | Received: |  |  |  | Tech:
 |  |  | Blackbaud: |  |  |  | Business:
Spreadsheet: 4b916dea-0d4d-4c1f-8e16-0e7916f0ba52
Sheet: Sheet1

Hires and wages by industries | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Washington state, Spring 2012
Source:  Employment Security Department/LMEA, Job Vacancy and Hiring Survey Report
[NAME] | Title | Estimated number of hirings | Low limit for 95% confidence level | High limit for 95% confidence level | Estimated average wage | Low limit for 95% confidence level | High limit for 95% confidence level | Estimated median wage | Low limit for 95% confidence level | High limit for 95% confidence level
11 | Agriculture, Forestry, Fishing,  and   Hunting | 7799.0603 | 3800.809 | 11797.3116 | 9.566469 | 9.2362002 | 9.8967375 | 9.04 | 8.49847274 | 9.58152726
23 | Construction | 8854.170213 | 5991.9529 | 11716.3876 | 27.918376 | 20.6932728 | 35.1434786 | 21.432734 | 14.8543336 | 28.0111353
31-33 | Manufacturing | 8558.906213 | 6845.4453 | 10272.3672 | 15.43585 | 14.4901709 | 16.3815297 | 12.437638 | 11.8859737 | 12.9893032
42 | Wholesale Trade | 5020.39447 | 2723.3885 | 7317.4005 | 14.99653 | 10.9215169 | 19.0715432 | 11.991005 | 8.12562647 | 15.856384
44-45 | Retail Trade | 15543 | 13315.6568 | 17769.983 | 10.899179 | 10.4240503 | 11.3743085 | 9.139774 | 9.03586089 | 9.24368725
48-49 | Transportation and Warehousing | 3197.164062 | 1553.4033 | 4840.9248 | 17.222351 | 15.482927 | 18.9617743 | 13.54986 | 11.0739105 | 16.025809
51 | Information | 1787.947006 | 1114.6833 | 2461.2107 | 22.752976 | 18.7421714 | 26.7637811 | 14.421247 | 9.84769613 | 18.9947988
52 | Finance and Insurance | 2327.813014 | 1746.2186 | 2909.4074 | 16.910163 | 14.9762873 | 18.8440389 | 13.466326 | 11.5956396 | 15.3370131
53 | Real Estate and Rental and Leasing | 2065.301116 | 1408.6111 | 2721.9911 | 14.277544 | 12.6336007 | 15.9214871 | 9.993597 | 9.54188023 | 10.445314
54 | Professional, Scientific, and Technical Services | 6960.12972 | 5609.7934 | 8310.466 | 25.313716 | 22.5051417 | 28.12229 | 19.173081 | 15.9913609 | 22.3548016
56 | Administrative Support and Waste Management | 6748.866531 | 5097.5263 | 8400.2068 | 13.637774 | 12.2393749 | 15.0361738 | 10.979673 | 10.0680707 | 11.8912761
61 | Educational Services | 4229.01427 | 2819.6268 | 5638.4017 | 17.047898 | 16.0669546 | 18.0288404 | 15.329293 | 14.5834669 | 16.0751189
62 | Health Care and Social Assistance | 17982 | 14908.6465 | 21054.416 | 17.466738 | 16.2028225 | 18.7306537 | 11.999752 | 11.1121295 | 12.8873742
71 | Arts, Entertainment, and Recreation | 4694.712685 | 3103.7203 | 6285.7051 | 11.631115 | 10.8982413 | 12.3639889 | 9.753401 | 9.30571901 | 10.2010825
72 | Accommodation and Food Services | 15683 | 13848.028 | 17517.1242 | 9.589132 | 9.4435084 | 9.734755
81 | Other Services | 4555.767746 | 3591.5259 | 5520.0096 | 15.453512 | 14.1279766 | 16.7790467 | 9.982288 | 9.53808932 | 10.426486
Spreadsheet: darron_c_giron__8050__2000
Sheet: Dec 2000

Done after bid-week:
Telerate/Price Basis/Quotes/Deals/OTC/Pub Posting
Pull up Crude Merc value & update cell E9 |  |  |  |  | Date,F5,%Nxavcprompt,F3
Update following cells from Gas Market Report
 |  | Note: Insert the #'s in blue to calculate the customer price
 |  | Crude Merc | IF-Elpaso Perm | IF-HH | IF-Elpaso/SJ | IF-TW-Permian
CPR# | Sitara # | TAGG # | PanEnergy/Duke | Facility | Term | Calculated Price
98063 | 27258 | E21728 | 2,500/day | 506767 | 7/95-12/2001
CPR# | Sitara # | TAGG # | Union Pacific | Facility | Term | Calculated Price
48853 | 106622 | E11400 | 2,500/day | 506767 | 1/92-12/2003
CPR# | Sitara # | TAGG # | Union Pacific | Facility | Term | Calculated Price
3217 | 106624 | E22656 | 7,000/day | 506767 | 1/95-12/2001
CPR# | Sitara # | TAGG # | Vastar | Facility | Term | Calculated Price
394674 | 27253 | E21977 | 10,000/day | 506766 | 6/96-4/2002
CPR# | Sitara # | TAGG # | Agave/Yates | Facility | Term | Calculated Price
93788 | 27245 | E20337 | 10,000/day | 58649 | 1/93-12/2002 |  | * moved to Central desk for March
 |  | Last Update:
Spreadsheet: 701381d1603728341-automatically-sort-data-in-alphabetical-order-using-formula-array-and-non-array-formula-sort_alphanetically_sample-1-
Sheet: Sort (2)

Sales | Helper 1 | Desired Output
Spreadsheet: 73464d1274131470-graphics-tied-to-text-wc2010
Sheet: Sheet1

Group Schedule
South Africa | : | Mexico |  | : |  |  |  |  | M | Pts | Goals |  |  | [NAME]
Uruguay | : | France |  | : |  | 1 |  | South Africa | 0 | 0 | 0 | : | 0 | 0
South Africa | : | Uruguay |  | : |  | 2 |  | Mexico | 0 | 0 | 0 | : | 0 | 0
France | : | Mexico |  | : |  | 3 |  | Uruguay | 0 | 0 | 0 | : | 0 | 0
Mexico | : | Uruguay |  | : |  | 4 |  | France | 0 | 0 | 0 | : | 0 | 0
France | : | South Africa |  | :
 |  |  |  |  |  |  | Table above shows start position of each country (as the draw was made)
RESULTS |  |  |  |  |  |  |  |  | M | Pts | Goals |  |  | [NAME]
South Africa | : | Mexico | 2 | : | 1 | 1 |  | France | 3 | 7 | 3 | : | 0 | 3
Uruguay | : | France | 0 | : | 0 | 2 |  | South Africa | 3 | 4 | 3 | : | 3 | 0
South Africa | : | Uruguay | 1 | : | 1 | 3 |  | Uruguay | 3 | 3 | 3 | : | 3 | 0
France | : | Mexico | 2 | : | 0 | 4 |  | Mexico | 3 | 1 | 3 | : | 6 | -3
Mexico | : | Uruguay | 2 | : | 2
France | : | South Africa | 1 | : | 0 |  | Final table shows positions of all countries after all group matches have been played.
 |  |  |  |  |  |  | Whilst the countires have changed position dynamically, I cannot get the flags to follow
 |  |  |  |  |  |  | the countries!
Spreadsheet: 36283d1234170483-merge-two-worksheets-students
Sheet: Grades

[NAME] | course_id | attd_1 | attd_2 | attd_3 | attd_4 | attd_5 | attd_6 | attd_7 | attd_8 | attd_9 | attd_10 | quiz_1 | quiz_2 | quiz_3 | quiz_4 | quiz_5 | quiz_6 | quiz_7 | quiz_8 | quiz_9 | quiz_10 | exam_1 | exam_2 | exam_3 | exam_4 | exam_5 | exam_6 | remd_1 | remd_2 | remd_3 | [NAME] | writ_2 | writ_3 | papr_1 | papr_2 | papr_3 | essay_1 | essay_2 | essay_3 | labs_1 | labs_2 | labs_3 | pract_1 | pract_2 | pract_3 | perf_1 | perf_2 | perf_3 | recit_1 | recit_2 | recit_3 | case_1 | case_2 | case_3 | nbook_1 | nbook_2 | nbook_3 | clinic_1 | clinic_2 | clinic_3 | proj_1 | proj_2 | proj_3 | midt_1 | midt_2 | midt_3 | final_1 | final_2 | final_3 | total | grade
123 | 12 | 12 | 2 | 0 |  |  |  |  |  |  |  | 11 | 2 |  |  |  |  |  |  |  |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55 | B
126 | 12 | 11 | 2 | 3 |  |  |  |  |  |  |  | 14 | 2 |  |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65 | B-
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: John S Rodgers

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
No response
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
Agree
Explain your health care reform position, if you choose
You should be able to retain your current coverage if you choose as the point is to get all people covered
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
No response
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
No response
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | P.O. Box 217 Glover VT 05839 | state senate | No |  | Orleans
Spreadsheet: 735784d1623173182-nested-sumifs-offset-index-match-match-example
Sheet: TC

ORDER NO | CLCID1 | CL TYPECHG1 | CL RATE1 | CL QTY1 | CLCID2 | CL TYPECHG2 | CL RATE2 | CL QTY2 | [NAME] | CL TYPECHG3 | CL RATE3 | CL QTY3 | CLCID4 | CL TYPECHG4 | CL RATE4 | CL QTY4 | CLCID5 | CL TYPECHG5 | CL RATE5 | CL QTY5 | [NAME] | CL TYPECHG6 | CL RATE6 | CL QTY6 | CLCID7 | CL TYPECHG7 | CL RATE7 | CL QTY7 | CLCID8 | CL TYPECHG8 | CL RATE8 | CL QTY8
776349 | 837 | HD DELIVERY | 65.27 | 1 | 0 | FSC(N) | 10.85 | 1 | 832 | ADDITIONAL PER PIECE PRICE - 1 PIECE INCLUDED | 16 | 1
776350 | 837 | HD DELIVERY | 69.11 | 1 | 0 | FSC(N) | 10.85 | 1
776351 | 837 | HD DELIVERY | 75.94 | 1 | 0 | FSC(N) | 11.76 | 1
776352 | 837 | HD DELIVERY | 75.94 | 1 | 0 | FSC(N) | 11.76 | 1
776353 | 837 | HD DELIVERY | 74.94 | 1 | 0 | FSC(N) | 11.76 | 1
776354 | 837 | HD DELIVERY | 75.94 | 1 | 0 | FSC(N) | 11.76 | 1
776355 | 837 | HD DELIVERY | 75.94 | 1 | 0 | FSC(N) | 11.76 | 1
776356 | 837 | HD DELIVERY | 75.94 | 1 | 0 | FSC(N) | 11.76 | 1
776357 | 837 | HD DELIVERY | 75.94 | 1 | 0 | FSC(N) | 11.76 | 1
Spreadsheet: drew_fossum__8655__Pueblo Econ
Sheet: 60 MW

 |  | Pueblo 60 MW CC
 |  | Project Economics
 |  | Version 1
Percent Debt Financing | 70 |  | Project Life (Yrs) | 10
Annual Debt Interest Rate (%) | 10 |  | Income Tax Rate (%) | 35
Debt Life (Yrs) | 10 |  | Before-Tax Equity Return (%)
After-Tax Equity Return (%) | 20
 | Debt Life | Remainder
Prop. of Equity Return in Period | 1
Capital Recovery (%)
Equity Portion
Debt Portion
Total Capital Recovery (%)
EPC Price ($[NAME]) | 72.2 |  | Capex | $[NAME]/yr
Construction Period (Months) | 24 |  | EPC Price
Annual Hours of Operation | 8500 |  | IDC
Average Output (MW) | 73.4 |  | Construction Insurance
Avg. HHV Heat Rate (Btu/kWh) | 8170 |  | Spare Parts
Fuel Cost ($/MMBtu) | 4.4 |  | O&M Mobilization
Steam Sales (klb/hr) | 0 |  | Working Capital
Steam Energy (Btu/lb) | 0 |  | Owner's Engineer | 1
Steam Generation Efficiency (%) | 0 |  | Legal Costs | 0.5
Steam Price Calculated ($/klb) |  |  | Development Costs & Fees | 0
Steam Price Specified ($/klb) | 0 |  | Land | 0
 |  |  | Subtotal
Revenue Requirement | $[NAME]/yr |  | Financing Costs
Capital Recovery |  |  | Total Capex
Fuel
O&M Expense
Insurance & Taxes
Land Lease | 1 |  | O&M Expenses | $[NAME]/yr
Subtotal |  |  | Payroll | 1.1
Less: Steam Sales |  |  | Administration | 0.2
Power Sales |  |  | Chemicals | 0.2
 |  |  | [NAME] | 0.5
Power Sales (MWh/yr) |  |  | Major [NAME] | 1.5
 |  |  | Fee
Power Price ($/MWh) |  |  | Total O&M Expenses
Spreadsheet: 99179d1297898056-dynamically-select-non-zero-rows-labels-and-corresponding-values-book2
Sheet: Output Tables

 | Year | 2011 |  | Year | 2012 |  | Year | 2013
 | Item | Amount |  | Item | Amount |  | Item | Amount
 |  |  |  |  |  |  |  |  |  | I manually entered the data in the first table to the left to show desired output
 | Total |  |  | Total |  |  | Total
 | Year | 2014 |  | Year | 2015 |  | Year | 2016
 | Item | Amount |  | Item | Amount |  | Item | Amount
 | Total |  |  | Total |  |  | Total
Spreadsheet: 08970d51-1bbd-428c-9e6c-f5bb7fe7091b
Sheet: Sheet1

District Results | Unnamed: 1 | MR 40 | MR 60 | MR 70 | MR 70.1 | MR 70.2 | MR 70.3 | MR 70.4 | MR 70.5 | MR 70.6 | MR 70.7 | MR 70.8 | MR 70.9
[NAME] | Month | Gain/Loss | Tot % Part | Tot Meal Cost | Donated Food | Cost/Labor Hr | Lun/Labor Hr | Food + | Labor + | Supplies + | Services + | Fringes + | Depreciation
Total District | Sept
School
[NAME]. | Sept
KR Middle
[NAME]
Notes:
Spreadsheet: 97629d1296753401-cross-sheet-calc-that-would-omit-0-possible-solution-but-am-getting-a-ref-error-2011trending
Sheet: 0127

01/27/11  Performance Data
 |  | 1st Work |  |  |  | QC |  |  | Total Points Earned | Unavailability |  | Actual Processing  Hours | Avg pts per hour
 |  | SURNOT SURNOTACKL MNBENMMIG SURDTHCERT | SURBENCSMG SURFRM SURVALDOD SURCUSFLUP SURSPLIGO SRSPNIGO SURBENSPLT RAIDPS RAIDNP/TAIDIN-IA FAID/FAIDWF IAID/FAIDCO SURINQ | SURBENRSCH SURBENUPDT RAIDPB RAIDAR | SURBENLEGL SURPAYLNPO | MNTBENMMIG SURSPLIGO SURSPNIGO SURBENSPLT RAIDPS FAID | SURBENRSCH (PASS) SURBENUPDT (PASS/FAIL) RAIDPB RAIDAR | SURBENRSCH (FAIL)
 |  |  |  |  |  |  |  |  |  | # of Hrs | Reason?
Team Members | Flint | 7 | 10 | 7 |  |  |  |  | 100 | 1 | reporting | 7.25 | 13.79310344827586
 | Dustin |  |  |  |  |  |  |  | 0.01 | 8.25 | trending project | 0.01 | 1
 | Sharron | 12 | 17 | 13 |  |  |  |  | 179 |  |  | 10 | 17.9
 | Roxy | 9 | 11 | 11 |  |  |  |  | 139 |  |  | 7.75 | 17.93548387096774
 | [NAME] |  |  |  |  |  | 13 | 1 | 112 |  |  | 8 | 14
 | Ana | 11 | 2 | 19 |  |  |  |  | 180 |  |  | 8 | 22.5
 |  |  |  |  |  |  |  |  | 0
 | [NAME] | 11 | 16 | 8 |  |  |  |  | 134 | 1 | CISS | 8.5 | 15.76470588235294
 | Petra | 5 |  | 4 |  |  | 4 | 5 | 114 | 3.25 | MISC | 8.5 | 13.41176470588235
 | Regina |  |  |  |  |  | 8 |  | 64 | 1 | SWT | 3.5 | 18.28571428571428
 | Noy | 2 |  | 1 |  |  | 10 | 3 | 116 | 4 | [NAME] | 5.5 | 21.09090909090909
 | [NAME] |  | 2 |  |  | 7 | 7 |  | 76 |  |  | 7.5 | 10.13333333333333
 | [NAME] | 11 | 4 |  |  |  |  |  | 34 |  | SME | 4 | 8.5
 | Michelle | 21 |  |  |  |  |  |  | 42 |  | SME | 2.25 | 18.66666666666667
 | Keisha |  | 9 | 11 |  |  |  |  | 115 |  |  | 11 | 10.45454545454546
 | [NAME] |  |  |  |  |  |  |  | 0.01 |  | out of office | 0.01 | 1
TEAM TOTALS | Pts Earned: | 2 | 3 | 8 | 12 | 2 | 8 | 8 |  |  |  |  | 203.4362267386477
 | TASK VOLUME: | 89 | 71 | 74 | 0 | 7 | 42 | 9 | 1405 | 18.5 |  | 91.77 | 15.31001416584941
 | Pts Earned: | 178 | 213 | 592 | 0 | 14 | 336 | 72
 |  |  |  |  |  |  |  | Average PTS | 87.81375 |  | Total Task Volume |  | 292
 | MID-DAY PPH  14.43
Spreadsheet: 856241d1705563336-date-challenge-transform-effective-date-range-to-day-time-series-date-challenge-transform-to-time-series2
Sheet: Desired Output

Desired output:
Dep time | Arr time | Day | Effective | Elapsed Time | Flight No | Time Series
18-30 | 20-30 | 5 | 16.04-29.10 | 02-00 | AB-352 | 2024-04-19 00:00:00
18-30 | 20-30 | 5 | 16.04-29.10 | 02-00 | AB-352 | 2024-04-26 00:00:00
18-30 | 20-30 | 5 | 16.04-29.10 | 02-00 | AB-352 | 2024-05-03 00:00:00
18-30 | 20-30 | 5 | 16.04-29.10 | 02-00 | AB-352 | 2024-05-10 00:00:00
07-40 | 09-20 | 1346 | 01.04-26.10 | 2024-10-02 00:00:00 | СD-982 | 2024-04-01 00:00:00
07-40 | 09-20 | 1346 | 01.04-26.10 | 2024-10-02 00:00:00 | CD-982 | 2024-04-03 00:00:00
07-40 | 09-20 | 1346 | 01.04-26.10 | 2024-10-02 00:00:00 | CD-982 | 2024-04-04 00:00:00
07-40 | 09-20 | 1346 | 01.04-26.10 | 2024-10-02 00:00:00 | CD-982 | 2024-04-06 00:00:00
07-40 | 09-20 | 1346 | 01.04-26.10 | 2024-10-02 00:00:00 | CD-982 | 2024-04-08 00:00:00
Spreadsheet: 130030d1322026614-excel-2007-auto-populating-cells-example
Sheet: Sheet1

102993 | JOLLY H C | 2010-10-15 00:00:00 | SIC | 64 | 18.95526 | 1213.14
 |  |  | PHOL | 8 | 18.95526 | 151.64
102993 | JOLLY H C | 2010-10-01 00:00:00 | SIC | 72 | 18.95526 | 1364.78
102993 | JOLLY H C | 2010-09-17 00:00:00 | LWOP | 12 | 0 | 0
 |  |  | SAL | 22 | 18.95526 | 417.02
 |  |  | SIC | 36 | 18.95526 | 682.39
 |  |  | SAL | 2 | 19.48421 | 38.97
 |  |  | SIC | 4 | 18.95526 | 75.82
 |  |  | LWOP | -4 | 0 | 0
103018 | [NAME] | 2011-11-11 00:00:00 | LWOP | 4 | 0 | 0
 |  |  | P050 | 16 | 10.46448 | 167.43
 |  |  | SAL | 21 | 20.92895 | 439.51
 |  |  | SAL | 15 | 20.92895 | 313.93
 |  |  | SAL | 16 | 20.92895 | 334.86
DESIRED RESULT
102993 | JOLLY H C | 2010-10-15 00:00:00 | SIC | 64 | 18.95526 | 1213.14
102993 | JOLLY H C | 2010-10-15 00:00:00 | PHOL | 8 | 18.95526 | 151.64
102993 | JOLLY H C | 2010-10-01 00:00:00 | SIC | 72 | 18.95526 | 1364.78
102993 | JOLLY H C | 2010-09-17 00:00:00 | LWOP | 12 | 0 | 0
102993 | JOLLY H C | 2010-09-17 00:00:00 | SAL | 22 | 18.95526 | 417.02
102993 | JOLLY H C | 2010-09-17 00:00:00 | SIC | 36 | 18.95526 | 682.39
102993 | JOLLY H C | 2010-09-17 00:00:00 | SAL | 2 | 19.48421 | 38.97
102993 | JOLLY H C | 2010-09-17 00:00:00 | SIC | 4 | 18.95526 | 75.82
102993 | JOLLY H C | 2010-09-17 00:00:00 | LWOP | -4 | 0 | 0
103018 | [NAME] | 2011-11-11 00:00:00 | LWOP | 4 | 0 | 0
103018 | [NAME] | 2011-11-11 00:00:00 | P050 | 16 | 10.46448 | 167.43
103018 | [NAME] | 2011-11-11 00:00:00 | SAL | 21 | 20.92895 | 439.51
103018 | [NAME] | 2011-11-11 00:00:00 | SAL | 15 | 20.92895 | 313.93
103018 | [NAME] | 2011-11-11 00:00:00 | SAL | 16 | 20.92895 | 334.86
Spreadsheet: 156351d1337267612-copy-onto-new-row-into-another-workbook-each-time-master-workbook-is-updated-quotation-log
Sheet: Sheet3

Sub AddDataToDatabase()
[NAME] As [NAME]
[NAME] Long
On Error Resume Next
Set MyDB = Workbooks("Fluffy Quotations.xls")
On Error GoTo 0
If MyDB Is Nothing Then
Set MyDB = Workbooks.Open("f:\excel\Fluffy Quotations.xls")
ThisWorkbook.Activate
End If
Nr = MyDB.Sheets("Sheet1").Range("A6" & Rows.Count).End(xlUp).Row + 1
With ActiveSheet
MyDB.Fluffy Quotations.xls("Customer Record").Range("D3" & Nr).Value = .Range("B6")
MyDB.Fluffy Quotations.xls("Quotation Front").Range("I6" & Nr).Value = .Range("A6")
MyDB.Fluffy Quotations.xls("Customer Record").Range("B3" & Nr).Value = .Range("c6")
MyDB.Fluffy Quotations.xls("Customer Record").Range("B6" & Nr).Value = .Range("d6")
MyDB.Fluffy Quotations.xls("Quotation Front").Range("E16" & Nr).Value = .Range("e6")
MyDB.Fluffy Quotations.xls("Quotation Front").Range("I28" & Nr).Value = .Range("f6")
End With
MyDB.Close True
End Sub