tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 713751d1610907701-how-to-get-multiple-row-data-from-another-sheet-by-matching-entries-crop_damage_forum
Sheet: ENTRY

ENTRY NUMBER | OUTPUT_survey | Column1
721468155261
968047478678
558862288012
597882830394
399900960516
394588931704
214880810005
840352530148
827853029063
363276262465
472116109840
888443886880
483278995489
458020255975
385291345637
507145249800
994588620209
897818448887
350910187470
635340796248
342276210202
709310903391
274726168458
989685953421
507468221728
698122155915
404673635421
576977801502
416252875853
201328094894
881700929090
940465231889
780600840974
420476284557
740252787736
573639020337
573275752520
607424311888
763383563525
987906951019
655773911445
732333003115
963258385708
494728102774
505632342203
245755630955
603386751964
810829261815
703539890657
561598098569
619313011545
693578007959
430570964109
679224591379
325610712737
630928545676
937167810080
371226046753
740222514316
611912683888
885243644294
554777273528
552529500854
959632508807
358499405281
256242713615
955858359065
826706848246
625546448059
315815792660
893378791115
823757444311
447249375852
707814348159
590016634753
594044027725
893336946397
822769047145
203048866149
716800274959
545440484267
477644154278
402418208184
556515541498
766456060526
318109223507
633884781867
501173918273
587779773640
352912009909
955463425027
652885776075
573027861381
610655245644
735700984298
370464426681
237636028359
762818705508
643573434719
964631323046
990727020614
679478590938
968167010499
868241651090
654384006450
734739314878
776890526946
867959747088
468727892883
912543297977
402930281417
622686104331
623914051773
451036809220
920201997069
908428507962
850821400940
252889501962
386797707260
375779898935
861541642277
495205971521
605315820358
279071201872
899807296688
824415066093
644546513242
829412958589
701862963251
317390933614
688282937240
891008501313
425358764814
383500920069
707848393916
878736280278
451828146705
688170502234
481347258638
866521427291
544817108103
424871238953
758601256055
535286845884
611729210757
516519797999
633625335557
772245648352
409207086978
564033834134
837607689065
782226321970
607915727072
908921340810
315609231337
519701877407
604498111914
381807369641
556595317945
289141454821
675361867392
960670905959
541398733094
986135748691
586285919483
362968736694
768964097182
436443767411
721297532815
904704913240
692959113936
723061128124
349042051324
987294550265
416346574784
643433756681
476790809364
259853454017
317550675147
713722500483
963483740465
257211302149
627068500504
418064932515
330934732470
Spreadsheet: 775740d1649281008-formel-to-count-if-not-blank-in-a-array-if-another-cell-is-equal-to-reference-cell-plan
Sheet: Test

 | Plan 2022 |  |  |  |  |  | Quater | Q1
 |  |  |  |  |  |  | Month | January |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  | Week
 | Activity type |  |  |  |  |  | Day | 2021-01-01 00:00:00
 |  | WebSite |  |  |  |  |  | 3 | 1
 |  | Blogs |  |  |  |  |  | 1 | 1
 |  | Ext newsletter
 |  | LinkedIn post
 |  | LindedIn - Ad
 |  | Googdle - Ad
 |  | Events
 |  | Int newsletter
 |  | Internal Material
 |  | Extra
 |  | ---Spacer---
50 | Campaigns |  | Activity type | Responsible | Estimated cost | Actual cost
 |  | Cam 1 | WebSite |  |  |  |  | 1
 |  | Cam 2 | Blogs |  |  |  |  | A
 |  | Cam 3 | WebSite |  |  |  |  | 3
 |  | [NAME] | WebSite |  |  |  |  |  | F
 |  | Cam 5 | Blogs |  |  |  |  |  | 5
 |  | Cam 6 | WebSite |  |  |  |  | 6
Spreadsheet: 864898d1712047543-cannot-see-the-error-example
Sheet: Sheet1

[NAME] | 13 | 1 |  | 1
[NAME] | 20 | 5 |  | 2
Sal | 17 | 2 |  | 3
Garry | 18 | 3 |  | 4
[NAME] | 23 | 6 |  | 5
[NAME] | 19 | 4 |  | 6
Spreadsheet: benjamin_rogers__1244__Simple Cycle (LM6000) Entergy model
Sheet: BS

BALANCE SHEET
 |  | 0
('000 $) |  | Close
Assets
Cash |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Accounts Receivable |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Inventories |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other Current Assets |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Debt Service Reserve |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 Current Assets
Gross PP&E
Accumulated Depreciation |  | 0
Net PP&E
Land
Other Assets |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 Assets
Liabilities
Accounts Payable |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Accrued Expenses |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Deferred Tax Liability |  | 0
Working Capital Revolver |  | 0
Long Term Debt
Other Non-Current Liabilities |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 Long-term Liabilities
Stockholders' Equity
Paid-In-Capital
Retained earnings
Total stockholders' equity
Total Liabilities & Equity
Proof
Spreadsheet: 103602d1301345967-automated-shipping-estimator-daily_rates-1-
Sheet: UPS CWT Tier 4

 |  |  |  |  |  |  |  |  | 2011 Rates
 | Domestic
 | UPS Hundredweight Service Tier 4
 | Guaranteed Delivery Service Options
 | UPS Next Day Air |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Pound
 | Zones | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 124 | 125 | 126
 | 100 Lbs. or more | 1.35 | 1.96 | 2.97 | 3.27 | 3.55 | 3.7 | 3.87 | 3.99 | 3.74 | 4.39
 | UPS Next Day Air Saver |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Pound
 | Zones | 132 | 133 | 134 | 135 | 136 | 137 | 138 | Service Not Available
 | 100 Lbs. or more | 1.12 | 1.65 | 2.89 | 3.22 | 3.32 | 3.53 | 3.64
 | UPS 2nd Day Air A.M. |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Pound
 | Zones | 242 | 243 | 244 | 245 | 246 | 247 | 248 | Service Not Available
 | 100 Lbs. or more | 0.89 | 1.05 | 1.33 | 1.88 | 2.97 | 3.22 | 3.45
 | UPS 2nd Day Air |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Pound
 | Zones | 202 | 203 | 204 | 205 | 206 | 207 | 208 | 224 | 225 | 226
 | 100 Lbs. or more | 0.83 | 0.94 | 1.2 | 1.67 | 2.66 | 2.96 | 3.05 | 3.14 | 2.85 | 3.49
 | UPS 3 Day Select |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Hundredweight Unit
 | Zones | 302 | 303 | 304 | 305 | 306 | 307 | 308 | Service Not Available
 | 200 to 499 Lbs. | 37.9 | 43.55 | 49.15 | 57.25 | 93.6 | 129.4 | 144.55
 | 500 to 999 Lbs. | 34.65 | 39.75 | 45.15 | 52.85 | 86.55 | 119.6 | 133.4
 | 1,000 Lbs. or more | 36.25 | 41.45 | 47.1 | 55.2 | 90.2 | 124.5 | 138.85
 | [NAME] |  |  |  |  |  |  |  |  |  | Hundredweight Shipment Rates Per Hundredweight Unit
 | Zones | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 44 | 45 | 46
 | 200 to 499 Lbs. | 26.2 | 32.75 | 37 | 43.65 | 54.75 | 63.3 | 73.4 | 196.8 | 196.8 | 231.4
 | 500 to 999 Lbs. | 23.3 | 29.25 | 33.1 | 38.95 | 49.2 | 56.75 | 65.75 | 175.25 | 175.25 | 205.4
 | 1,000 Lbs. or more | 23.7 | 29.95 | 33.8 | 39.9 | 50.2 | 58.1 | 67.2 | 178.4 | 178.4 | 209.5
 | Minimum Charges
 | UPS 3 Day Select Zones |  |  | 302 | 303 | 304 | 305 | 306 | 307 | 308 | Service Not Available
 | Minimum Charge |  |  | 47 | 47 | 47 | 47 | 47 | 47 | 47
 | [NAME] |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 44 | 45 | 46
 | Minimum Charge |  |  | 41 | 41 | 45 | 45 | 45 | 45 | 45 | 225 | 225 | 275
Spreadsheet: 12020e3f-b1c9-4078-87bb-31f1f0cee9c2
Sheet: Sheet1

Note: P=Permanent | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Human Resources
Record Series | In Office | Archives | Total Retention Period | Notes
Active Personnel files containing: | Termination+6 years |  | Termination+6 years
Application
Resume/vita
Contact information, Social Security information
Recommendation forms (administrative appts.)
Background check documentation
Letters of appointment or contracts
Orientation checklist/sign-off
Employee Handbook receipt
Performance reviews
Letters of recommendation
Status changes/history
Disciplinary letters and notations
Compensation data/correspondence
Appropriate benefits data/correspondence
General correspondence relative to above
Resignation letter
Exit interview form
Application files, interviewed but not hired | 2 years |  | 2 years | FLSA requirement
Application files, not interviewed or hired | 2 years |  | 2 years | FLSA requirement
Benefit programs, health insurance | Active+7 years |  | Active+7 years
Benefit programs, retirement | Active+7 years |  | Active+7 years
Benefits files, retirees, employees on disability | Final payment+7 years |  | Final payment+7 years
COBRA files | Active+3 years |  | Active+3 years
Grievance files | Resolution+3 years |  | Resolution+3 years
INS Form I-9 | 3 years or termination+1 year, whichever is longer |  | 3 years or termination+1, whichever is longer
Medical files, family leave, ADA, etc. | Termination+6 years |  | Termination+6 years
OPEIU bargaining agreements | Completion of contract+10 years |  | Completion of contract+10 years
RAFO bargaining agreements | Completion of contract+10 years |  | Completion of contract+10 years
Retirement files, terminated employees vested, | Final payment+7 years |  | Final payment+7 years
but not yet receiving benefits
Unsolicited resumes/applications | Return with note saying no positions open |  | Return with note saying no positions open
Spreadsheet: 183948d1349100436-need-help-with-conditional-formatting-problem-please-help-tf-performance-2-latest-q3
Sheet: Sheet2

 | Row Labels | Count of Client |  | Row Labels | Count of Client
 | AX-Energy | 1 |  | Addax | 13
 | Brila Energy | 1 |  | Glencore | 25
 | Conoil (OAN) | 1 |  | [NAME] | 13
 | Energy Culture | 3 |  | Mercuria | 16
 | Gulf Treasure | 1 |  | Nimex | 11
 | Honeywell | 5 |  | Vitol | 19
 | Matrix | 4
 | Nadabo Energy | 1
 | OAN | 2
 | Oilsep | 1
 | [NAME] | 1
 | Pinnacle | 1
 | Taurus | 3
 | Sopetro | 1
 | Dee jones | 1
 | Nepal | 4
Spreadsheet: 675170d1588181633-compare-4-columns-sample
Sheet: DeviceInfo

User's Device | BIOS | Need update
Latitude 5591 | 1.7.4 |  | Since this is lower than the version available.
Latitude 5590 | 1.10.1
Latitude 5491 | 1.10.1
Latitude 5580 | 1.15.1
Latitude 5491 | 1.8.1
Latitude 5480 | 1.10.4
Latitude 7480 | 1.16.1 |  | Since this matches the manufacturer current version no upate is needed.
Latitude 5491 | 1.6.1
Latitude 5491 | 1.10.1
Latitude 5580 | 1.16.0 |  | Since this matches the manufacturer current version no upate is needed.
Spreadsheet: 489924d1479493376-calculating-dates-date
Sheet: Sheet1

2003-05-01 00:00:00 | 2005-12-01 00:00:00
1998-10-01 00:00:00 | 1999-06-01 00:00:00
1999-06-01 00:00:00 | 2003-09-01 00:00:00
2003-10-01 00:00:00 | 2005-07-01 00:00:00
2005-07-01 00:00:00 | 2006-08-01 00:00:00
 |  |  |  | Total
Spreadsheet: tracy_geaccone__40421__enron corp infomation request
Sheet: ENA BS

ASSETS |  |  | LIABILITIES AND STOCKHOLDER'S EQUITY
Current Assets |  |  | LIABILITIES
Cash |  |  | Current Liabilities
Notes and Accounts Receivable (including interco.) |  |  | Notes and Accounts Payable (including interco.)
Inventories |  |  | Other Current Liabilities
[NAME] |  |  | PRML
[NAME] |  |  | Total Current Liabilities
Current Deferred Tax Assets
Prepayments and Other |  |  | Long-Term Debt - Intercompany and Third Party
Price Risk Management Assets (PRMA) |  |  | Deferred Tax Liabilities
Total Current Assets |  |  | Other Liabilities (please detail)
Investments |  |  | Other Liabilities
Property, Plant & Equipment |  |  | PRML
Gross |  |  | Total Liabilities
Less:  Accumulated Depreciation and Amortization
Net Property, Plant, & Equipment |  |  | STOCKHOLDER'S EQUITY
Goodwill |  |  | Common Stock, Additional Paid-In Capital and CTA
Other Assets (please list detail) |  |  | [NAME]
Other Deferred Charges & PRMA |  |  | Total Shareholder's Equity
Total Assets |  |  | Total Liabilities and Shareholder's Equity
Spreadsheet: 268548d1380683141-desired-multiple-data-into-single-cell-09-13
Sheet: ABST

ABSTRACT STRENGTH PARTICULARS OF HOME GUARDS NIRMAL - UNIT  FOR THE MONTH OF SEPTEMBER - 2013
Sl. No. | Particulars | No. of HGs | Remarks
1 | Total Strength of Unit | 116
2 | Duty [NAME] | 100
3 | No. of Deputation HGs | 12 | 31, 817, 344, 354, 823, 826, 833, 992, 1007, 1015, 1018 , 336
4 | Absent HGs | 2 | 665, 699
5 | Doing duty at RI HG ADD | 0
6 | Permission HGs | 0
7 | BSNL Waiting | 2 | 1029, 821
8 | No. of days Duty [NAME] | 2957
Spreadsheet: 145380d1331562255-help-choosing-minimum-price-if-in-stock-prices
Sheet: master sheet

Master sheet | Projector | stock ? | cheapest supplier | cheapest supplier price
man | product1 | y | supplier1 | 125
man | product2 | y | supplier1 | 88888
man | product3 | n |  | 0
man | product4 | y | supplier1 | 88888
man | product5 | y | supplier4 | 125
man | product6 | y | supplier2 | 425
Spreadsheet: 751411d1634095761-create-combination-of-elements-create-combination-of-elements
Sheet: Sample

 |  | Output |  |  |  |  |  |  | 1 | 2 | 3
Input Elements |  | Column-1 | Column-2 | Column-3 |  |  |  |  | Column-1 | Column-2 | Column-3
a |  | a | b | c
b |  | a | b | d |  | 8
c |  | a | b | e |  | 9
d |  | a | c | d |  | 10
e |  | a | c | e |  | 11
 |  | a | d | e |  | 12
 |  | b | c | d |  | 13
 |  | b | c | e |  | 14
 |  | b | d | e |  | 15
 |  | c | d | e |  | 16
 |  |  |  |  |  | 17
 |  |  |  |  |  | 18 |  |  | Logic: | Each row has a separate combination of elements, each element is at a different cell. Number of Rows = Combin(5,3) = 10, if one more element is added, total row will be Combin(6,3) = 20
 |  |  |  |  |  | 19
 |  |  |  |  |  | 20
 |  |  |  |  |  | 21
 |  |  |  |  |  | 22
 |  |  |  |  |  | 23
 |  |  |  |  |  | 24
 |  |  |  |  |  | 25
 |  |  |  |  |  | 26
 |  |  |  |  |  | 27
 |  |  |  |  |  | 28
Spreadsheet: 726272d1617134629-how-to-calculate-regular-work-hours-and-night-shift-hours-excel-timesheet-night-shift
Sheet: Sheet1

 |  | Date | Work begin | Work end | Hours worked | Hours worked between 23:00 - 05:00
 |  | 2020-12-21 00:00:00 | 22:00:00 | 23:30:00 | 1.5 | 0.5
 |  | 2020-12-24 00:00:00 | 10:00:00 | 00:35:00 | 14.58 | 1.6
 |  | 2020-12-27 00:00:00 | 10:35:00 | 08:00:00 | 21.42 | 6
Spreadsheet: 137425d1327096326-budeting-for-a-r-using-dso-forcasting-ar
Sheet: Sheet1

 |  |  |  | Forcast for 2012
 |  |  | 2011 outstanding balance | 2012-01-31 00:00:00 | 2012-02-29 00:00:00 | 2012-03-31 00:00:00 | 2012-04-30 00:00:00 | 2012-05-31 00:00:00 | 2012-06-30 00:00:00 | 2012-07-31 00:00:00 | 2012-08-31 00:00:00 | 2012-09-30 00:00:00 | 2012-10-31 00:00:00 | 2012-11-30 00:00:00 | 2012-12-31 00:00:00
 |  |  |  | JOD | JOD | JOD | JOD | JOD | JOD | JOD | JOD | JOD | JOD | JOD | JOD
 |  |  | 193903
Openning balance |  |  |  | 193903 |  | 292679.5306666667 | 287153.2493333333 | 249707.9373333334 | 260294.1253333333 | 283520.2773333333 | 248895.2613333333 | 202654.3333333333 | 251762.3333333333 | 307019.3333333333 | 287139.3333333333
Additions - sales |  |  |  | 66779.44266666667 | 133133.7546666667 | 125887.4946666667 | 123820.4426666667 | 136473.6826666667 | 147046.5946666667 | 101848.6666666667 | 100805.6666666667 | 150956.6666666667 | 156062.6666666667 | 131076.6666666667 | 120496.6666666667
Collections
Ending balance
The formula needed in row 9 is to forcast the collection amount and ending A/R balance if the average collection period is 45 Days…
Spreadsheet: 481344d1474406607-how-to-set-up-a-booking-schedule-in-excel-example-for-savak
Sheet: Log

ID | C'Taker | Date | From | To | Hall | Booked For
 |  | 2016-09-20 00:00:00 | 11:00:00 | 12:00:00 | 1 | ELeGault
 |  | 2016-09-20 00:00:00 | 11:30:00 | 12:00:00 | 2 | ELeGault
 |  | 2016-09-20 00:00:00 | 13:00:00 | 13:30:00 | 3 | ELeGault
 |  | 2016-09-20 00:00:00 | 14:30:00 | 17:00:00 | 4 | ELeGault
 |  | 2016-09-20 00:00:00 | 15:00:00 | 15:30:00 | 5 | ELeGault
 |  | 2016-09-20 00:00:00 | 18:00:00 | 21:30:00 | 6 | ELeGault
Spreadsheet: 638683dd-27e3-4662-ab78-8ecaaea4fbcc
Sheet: Sheet1

marker | # alleles | DI | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
bams 1 | 5 | 7.2
bams 13 | 11 | 12.3
bams 15 | 3 | 7.2
bams 21 | 2 | 1.6
bams 22 | 4 | 6.2
bams 23 | 3 | 3.7
bams 24 | 1 | 0
bams 25 | 1 | 0
bams 28 | 2 | 0.5
bams 3 | 3 | 2.1
bams 30 | 8 | 7.8
bams 31 | 4 | 22.7
bams 34 | 2 | 6.7
bams 44 | 2 | 1.6
bams 5 | 4 | 7.2
bams 51 | 2 | 0.5
bams 53 | 2 | 0.5
CG 3 | 2 | 1.6
pX01 | 4 | 13.6
pX02 | 8 | 59.5
[NAME] 12 | 3 | 1.1
[NAME] 16 | 3 | 2.1
[NAME] 17 | 2 | 3.1
[NAME] 19-2 | 2 | 3.6
[NAME] 23 | 3 | 3.1
[NAME] 35 | 2 | 0.5
vrr A | 4 | 2.6
vrr B1 | 3 | 6.2
vrr B2 | 2 | 0.5
vrr C1 | 3 | 1.1
vrr C2 | 2 | 1.6
mean | 3.290322580645161 | 6.064516129032256
Spreadsheet: 73864d1274414282-how-to-make-this-data-easy-to-analyse-inventory-data
Sheet: Available

Location ID | Item | Cost | Available | On order
2 | TV | 200 | 32
2 | Radio | 40 | 12
2 | [NAME] | 45 | 34
2 | Refrigerator | 380 | 54
2 | Blender | 25 | 36
2 | Microwawe | 190 | 11
23 | TV | 200 | 32
23 | Radio | 40 | 12
23 | [NAME] | 45 | 34
23 | Refrigerator | 380 | 54
23 | Blender | 25 | 36
23 | Microwawe | 190 | 11
21 | TV | 200 | 32
21 | Radio | 40 | 12
21 | [NAME] | 45 | 34
21 | Refrigerator | 380 | 54
21 | Blender | 25 | 36
21 | Microwawe | 190 | 11
Spreadsheet: 103606d1301347361-excel-2007-lookup-a-value-in-a-table-orders
Sheet: Orders

No | Date | Company Name | Status | Products Required | Total Value | Total Cost | Supplier(s) | Rental | FH | Months | ESC | Factor | Rental amount
TOTALS
1 | 2010-03-26 00:00:00 | Customer name 1 | New | Product Detail | 137387.06 | 125098 | Supplier A | YES | SUNLYN | 60 | 15 | XXXXX
2 | 2010-03-28 00:00:00 | Customer name 2 | New | Product Detail | 48049.17 | 38909 | Supplier B | YES | SUNLYN | 60 | 15 | XXXXX
3
Required to
Determine the factor to use in column M to work out the rental amount
1.) Lookup the factor value in the DATA sheet table according to 4 different values:
a) 'Total cost' value (Column G)
b) Supplier to use (SUNLYN or SGR)
c) No of months to finance (24, 60 etc)
d) Escalation percentage (0, 15 etc)
Spreadsheet: 706509d1606750934-how-to-upload-gdp-of-16-countries-book1
Sheet: Sheet2

Country | GDP
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
#[NAME]!
Spreadsheet: 781276d1653126911-need-formula-to-extract-every-first-capital-letter-from-word-with-criteria-sample-data_required-capital-letter-extraction-formula-aligw
Sheet: Sheet1

Colour | Colour Code | Need Formula for Color Code
Crown Gold | CG
Grey | GR
Gold | G
Black | B
Blue | BL
Red | R
Pearl Black(Golden line) | PB
White | W
Rose Gold | RG
Matte Black | MB
[NAME] | NP
Coral Red | CR
Ocean Blue | OBL
Fusion Black | FB
Aqua Blue | ABL
Mystic Purple | MP
[NAME] | SB
Burgundy Red | BR
Diamond Black | DB
Skyline Blue | SBL
Cosmic Green | CG
Midnight Ocean | MO
Glacier Ice | GI
Fusion Blue | FBL
Phantom Purple | PP
Magnetic Black | MB
[NAME] | SW
Admiral Blue | ABL
[NAME] | BBL
Racing Black | RB
Mineral Blue | MBL
Agate Red | AR
[NAME] | DW
[NAME] Blue | JBL
Mystic Black | MB
Dazzling Gold | DG
Topaz Blue | TBL
Ruby Red | RR
Golden | G
[NAME] | PB
Mystic Silver | MS
[NAME] | PW
[NAME] | IBL
Dazzle Blue | DBL
Emerald Black | EB
Glaze Black | GB
Frost Blue | FBL
[NAME] | AG
Obsidian Black | OB
[NAME] | DW
Purist Blue | PBL
[NAME] | NBL
Midnight Jazz | MJ
[NAME] | SM
Moonlight Sonata | MS
Gravity Black | GB
Aquamarine Green | AG
[NAME] | OBL
[NAME] | ABL
Olive Black | OB
Titanium Sapphire | TS
Crystal Symphony | CS
Glacier Blue | GBL
Phantom Black | PB
[NAME] | MB
Shimmer Blue | SBL
Emperor Blue | EBL
Arctic White | AW
[NAME] | DBL
Sunset Dazzle | SD
[NAME] | RB
Diamond Flare | DF
[NAME] | DP
Sunset Jazz | SJ
Prism Magic | PM
Slate Gray | SG
Fantastic Rainbow | FR
Deep Sea Blue | DBL
Midnight Blue | MBL
Diamond Glow | DG
Mirror Black | MB
[NAME] | MD
Cosmic Black | CB
[NAME] | AD
Enigma Black | EB
Neon Spark | NS
Mint Green | MG
[NAME] | SBL
Stardust Black | SB
Sunshine Gold | SG
[NAME] | SG
Glowing Galaxy | GG
Starlight Black | SB
Rainbow Fantasy | RF
Mystic Blue | MBL
Wave Green | WG
[NAME] | SS
Midnight Galaxy | MG
Ice Dawn | ID
[NAME] | TC
Turbo Black | TB
Urban Blue | UBL
Sapphire Blue | SBL
Elegant Black | EB
[NAME] | DW
Moonlight Shadow | MS
Spreadsheet: 138626d1327770171-sum-data-with-criterias-project-summary
Sheet: Sheet1

Bay | Criteria | 2012-01-01 00:00:00
Bay 1 | Planned | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
Bay 1 | Achieved | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
Bay 2 | Planned | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32
Bay 2 | Achieved | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32
Bay 3 | Planned | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33
Bay 3 | Achieved | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33
 |  |  | Up To 1st Tue |  | From 1st Wed to 2 nd Tue |  | From 2nd Wed to 3rd Tue
 |  |  | 2012-01-01 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-10 00:00:00 | 2012-01-11 00:00:00 | 2012-01-17 00:00:00
 |  |  | Planned | Achieved | Planned | Achieved | Planned | Achieved
 |  | Bay 1
 |  | Bay 2
 |  | Bay 3
Spreadsheet: 143653d1330510602-automatic-entry-into-summary-table-when-matching-various-criteria-blank-sui-form-test-1
Sheet: Summary 

 | Incident / Accident 2011 / 2012 |  | Staff | S U | Other
 | Incident / Accident | April | Type Staff | Type SU | Type Other | May | Type Staff | Type SU | Type Other | June | Type Staff | Type SU | Type Other | July | Type Staff | Type SU | Type Other | August | Type Staff | Type SU | Type Other | September | Type Staff | Type SU | Type Other | October | Type Staff | Type SU | Type Other | November | Type Staff | Type SU | Type Other | December | Type Staff | Type SU | Type Other | January | Type Staff | Type SU | Type Other | February | Type Staff | Type SU | Type Other | March | Type Staff | Type SU | Type Other | Total Notifications and Unusual Occurrence's | Total Incidents / Accidents to Staff | Total Incidents / Accidents to Service User | Total Incidents / Accidents to Other
1 | Death
 | Infectious disease
 | Injury
 | Illness
 | Event that adversely affects the person’s safety & welfare
 | Theft, burglary or accident
 | The termination of accommodation without notice
 | Physical Intervention
 | Temporary Change in Provider's Approval
 | Safeguarding
 | Aggression / Violence
 | Medication Error
 | Seizures
 | Self Injuries Behaviour
 | Manual Handling
 | Slips / Trips / Falls
 | Injury Found cause unknown
 | Unwitnessed Event
 | Security
 | Equipment
 | Other *
 | Hints
 | Allegations
Spreadsheet: 598662d1542644675-combining-multiple-workbooks-into-one-workbook-combined-workbook-what-im-trying-to-achieve-
Sheet: Leht4

letter | name | adress | telephone
a | Adam | House str | 5265738
b | Bethany | Door str | 6768798
c | [NAME] | Floor str | 56576897
d | [NAME] | Window str | 6436534